PHP report_engine::retrieve_html_penetapan_aset_yang_digunakan_tervalidasi示例

示例#1

文件： tes_class_penetapan_aset_yang_digunakan_validasi.php 项目： TrinataBhayanaka/simbada-tangsel

                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
                LEFT JOIN Mesin AS M ON A.Aset_ID=M.Aset_ID
                WHERE PGN.FixPenggunaan=1 AND PGN.Status=1 AND PGN.Penggunaan_ID='$id'
                ORDER BY PGN.Penggunaan_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_penetapan_aset_yang_digunakan_tervalidasi($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}') ;