LEFT JOIN Satker AS S ON A.LastSatker_ID=S.Satker_ID LEFT JOIN Kelompok AS K ON A.Kelompok_ID=K.Kelompok_ID LEFT JOIN Kondisi AS KDS ON A.LastKondisi_ID=KDS.Kondisi_ID LEFT JOIN Tanah AS T ON A.Aset_ID=T.Aset_ID LEFT JOIN Bangunan AS B ON A.Aset_ID=B.Aset_ID WHERE UA.Jenis_Usulan='MNF' AND UA.StatusPenetapan=0 AND UA.Usulan_ID='$id' ORDER BY UA.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_usulan_aset_yang_akan_dimanfaatkan($result_query, $gambar); //print html $count = count($html); for ($i = 0; $i < $count; $i++) { //echo $html[$i]; } //cetak reporting $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}') ; $mpdf->progbar_heading = ''; $mpdf->StartProgressBarOutput(2);