TenderController.php#235simantev_kalsel1.76msselect `kd_satker`, `nama_satker`, count(kd_satker) as jumlah_paket, SUM(pagu) as pagu, SUM(hps) as hps, SUM(nilai_penawaran) as nilai_penawaran from (SELECT
a.*,
c.nilai_penawaran,
c.nilai_terkoreksi,
c.nilai_negosiasi,
c.nilai_pdn_kontrak,
c.nilai_umk_kontrak,
c.nama_penyedia AS nama_penyedia_pemenang,
c.npwp_penyedia AS npwp_penyedia_pemenang,
b.nama_penyedia AS nama_penyedia_berkontrak,
b.npwp_penyedia AS npwp_penyedia_berkontrak,
b.nilai_kontrak
FROM
tender_pengumuman AS a
LEFTJOIN
v_tender_kontrak AS b ON a.kd_tender = b.kd_tender
LEFTJOIN
tender_nilais AS c ON a.kd_tender = c.kd_tender
WHERE
a.tahun_anggaran =2025AND a.status_tender ='Selesai'GROUPBY
a.kd_tender) as data groupby `kd_satker`