PHP report_engine::retrieve_html_usulan_pemindahtanganan_dengan_pilihan示例

示例#1

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

                INNER JOIN Kontrak AS KTR ON KTR.Kontrak_ID=KTRA.Kontrak_ID
                LEFT JOIN Kelompok AS K ON A.Kelompok_ID = K.Kelompok_ID
                LEFT JOIN Lokasi AS L ON A.Lokasi_ID = L.Lokasi_ID 
                LEFT JOIN Satker AS S ON A.LastSatker_ID = S.Satker_ID
                LEFT JOIN Kondisi AS KDS ON A.LastKondisi_ID = KDS.Kondisi_ID
                WHERE A.Usulan_Pemindahtanganan_ID IS NULL AND A.NotUse=0 AND A.StatusValidasi=1 AND
                A.Aset_ID IN ($dataNew) ORDER BY A.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_pemindahtanganan_dengan_pilihan($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 = '';