LEFT JOIN KontrakAset AS KTRA ON PGNA.Aset_ID = KTRA.Aset_ID LEFT JOIN Kontrak AS KTR ON KTR.Kontrak_ID = KTRA.Kontrak_ID LEFT JOIN Lokasi AS L ON A.Lokasi_ID=L.Lokasi_ID LEFT JOIN Kelompok AS K ON A.Kelompok_ID=K.Kelompok_ID LEFT JOIN Satker AS S ON A.LastSatker_ID=S.Satker_ID WHERE PGNA.Status=1 AND PGNA.StatusMenganggur=0 AND PGNA.StatusMutasi=0 AND PGNA.Aset_ID IN ($dataNew) ORDER BY PGNA.Aset_ID asc limit 50"; //mengenerate query $result_query=$REPORT->retrieve_query($query); //set gambar untuk laporan $gambar = $FILE_GAMBAR_KABUPATEN; //retrieve html $html=$REPORT->retrieve_html_mutasi_dengan_pilihan($result_query, $gambar); //print html $count = count($html); for ($i = 0; $i < $count; $i++) { //echo $html[$i]; } //cetak reporting //$mpdf=new mPDF(); $REPORT->show_status_download_kib(); $mpdf=new mPDF('','','','',15,15,16,16,9,9,'L'); $mpdf->debug=true; $mpdf->AddPage('L','','','','',15,15,16,16,9,9); $mpdf->setFooter('{PAGENO}') ;