LEFT OUTER JOIN Kondisi KDS ON A.Aset_ID = KDS.Aset_ID
LEFT OUTER JOIN BAPemusnahan BAP ON A.BAPemusnahan_ID = BAP.BAPemusnahan_ID
LEFT OUTER JOIN Lokasi L ON A.Lokasi_ID = L.Lokasi_ID
WHERE A.Kelompok_ID = K.Kelompok_ID
ORDER BY A.LastSatker_ID ASC
LIMIT 0 , 30";


//mengenerate query
$result_query=$REPORT->retrieve_query($query);

//set gambar untuk laporan
$gambar=$REPORT->getLogo('bireun', $url_rewrite);

//retrieve html
$html=$REPORT->retrieve_html_untukdimusnahkan($result_query, $gambar);


//print html
$count = count($html);
//echo "$query ";
for ($i = 0; $i < $count; $i++) {
     
     echo $html[$i];     
}


//cetak reporting
//$mpdf=new mPDF(); 
$mpdf=new mPDF('','','','',15,15,16,16,9,9,'P');
$mpdf->AddPage('L','','','','',15,15,16,16,9,9);