fetchAll() as $data){ $sql_1 = $db->query('SELECT tglbayar, shift, sum(jmbayar) AS total FROM t_bayarrajal WHERE TGLBAYAR =\''.$data['tglbayar'].'\' AND SHIFT =\'1\' AND STATUS = \'LUNAS\' and CARABAYAR = 1 GROUP BY tglbayar,shift'); $shift_1= $sql_1->fetchAll()[0]; $sql_2 = $db->query('SELECT tglbayar, shift, sum(jmbayar) AS total FROM t_bayarrajal WHERE TGLBAYAR =\''.$data['tglbayar'].'\' AND SHIFT =\'2\' AND STATUS = \'LUNAS\' and CARABAYAR = 1 GROUP BY tglbayar,shift'); $shift_2= $sql_2->fetchAll()[0]; $sql_3 = $db->query('SELECT tglbayar, shift, sum(jmbayar) AS total FROM t_bayarrajal WHERE TGLBAYAR =\''.$data['tglbayar'].'\' AND SHIFT =\'3\' AND STATUS = \'LUNAS\' and CARABAYAR = 1 GROUP BY tglbayar,shift'); $shift_3= $sql_3->fetchAll()[0]; echo ''; } ?>

TGL BAYAR	SHIFT I	SHIFT II	SHIFT III	Total Pendapatan Perhari
'.$data['tglbayar'].' ['.'Rekap | Det ]	'.format_uang($shift_1['total']).'	'.format_uang($shift_2['total']).'	'.format_uang($shift_3['total']).'	'.format_uang($shift_1['total']+$shift_2['total']+$shift_3['total']).'