hargaTagihan

$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');
    }