hargaTagihan
harga tagihanunknown
abap
a year ago
814 B
1
Indexable
Never
$hrgAdm = DB::table('uji_harga_tagihan_adm as a') ->select( 'a.id', 'a.harga_net', ); $dataTagihan = $dataTagihan ->leftJoinSub($hrgAdm, 'adm', function ($join) { $join->on('adm.id', '=', 'uji_harga_tagihan.id_hrg_adm'); }) ->selectRaw('count(id_peserta) as tot_srtf') ->selectRaw('sum(nilai_trm) as tot_nilai_trm') ->selectRaw('sum(cash_back) as tot_cash_back'); if($f_sts_data == 2){ $dataTagihan->groupBy('id_pj_srtf'); } elseif($f_sts_data == 3){ $dataTagihan->groupBy('id_tim_prod'); } elseif($f_sts_data == 6){ $dataTagihan->groupBy('id_pj_srtf','id_tim_m'); } elseif($f_sts_data == 7){ $dataTagihan->groupBy('id_tim_prod','id_tim_m'); }