Query("SELECT B.*,DATE_FORMAT(B.Tgl_PO,'%d-%m-%Y') Tgl_PO2,S.Kode_Sup,S.Nama_Sup,S.Alamat_Sup FROM (SELECT * FROM inv_po WHERE No_PO='".$nota."') B LEFT JOIN para_supplier S ON (S.SupID=B.SupID)"); if ($db->Next()) $ainfo = $db->AllRow(); $ainfo['Alamat_Sup'] = str_replace("\n", "
", $ainfo['Alamat_Sup']); $db->Query("SELECT D.*,P.Nama_Produk,P.Nama_Satuan FROM (SELECT InvID,SatuanID,Harga_Beli,SUM(Qty) Qty,SUM(Qty*Harga_Beli) Jumlah FROM inv_po_detail WHERE No_PO='".$nota."' AND Qty>0 GROUP BY InvID,SatuanID,Harga_Beli) D LEFT JOIN vi_inv_produk P ON (P.InvID=D.InvID AND P.SatuanID=D.SatuanID) ORDER BY P.Nama_Produk"); $html = '

PURCHASE ORDER

'.$_SESSION['__WEB_APP']['REG_NAME'].'

Nomor PO	'.$ainfo['No_PO'].'
Tanggal PO	'.$ainfo['Tgl_PO2'].'
Supplier	'.$ainfo['Nama_Sup'].(($ainfo['Kode_Sup'])?" [".$ainfo['Kode_Sup']."]":"").'
Alamat	'.$ainfo['Alamat_Sup'].'

'; $footer = ''; $_setfoot = ''; $t_head = '

'; $t_foot = '

No.	Nama Barang	Qty	Satuan

'; $_line = '%s%s%s%s'; $html .= sprintf($footer, 10, "Purchase Order ".$ainfo['No_PO']); $html .= sprintf($_setfoot, 10); $body .= $t_head; $nomor = 1; while ($db->Next()) { $body .= sprintf($_line, $nomor++, $db->Row("Nama_Produk"), rupiah30($db->Row("Qty")), $db->Row("Nama_Satuan")); } if ($nomor <= $baris_faktur) { $nomor--; for ($x=$baris_faktur; $x>fmod($nomor, $baris_faktur); $x--) { $body .= sprintf($_line, " ", " ", " ", " "); } } $body .= sprintf($t_foot); $body .= '

Penerima,

Hormat Kami,

Tanda Tangan & Cap Perusahaan

'; $mpdf = new \Mpdf\Mpdf([ 'mode' => 'c', 'format' => 'A4', 'margin_left' => 8, 'margin_right' => 8, 'margin_top' => 8, 'margin_header' => 5, 'margin_footer' => 5 ]); $mpdf->SetDisplayMode('fullpage'); $css = file_get_contents($_SESSION['__WEB_APP']['REAL_PATH'].'assets/css/pdf/po.css'); $mpdf->WriteHTML($css, \Mpdf\HTMLParserMode::HEADER_CSS); $mpdf->WriteHTML($html . $body, \Mpdf\HTMLParserMode::HTML_BODY); $mpdf->SetAuthor($_SESSION['__WEB_APP']['REG_NAME']); $mpdf->SetCreator($_SESSION['__WEB_APP']['APP_NAME']." v".$_SESSION['__WEB_APP']['APP_VER']); $mpdf->setTitle("Purchase Order ".$ainfo['No_PO']); $mpdf->Output("Purchase Order ".$ainfo['No_PO'].".pdf", ($mode=="view" ? "I" : "D")); unset($mpdf); } $db = $db ?? new MySQL(); $data = Param::Get("data"); $mode = Param::Get("mode", "view"); $nomor = Param::Get("Nomor_Cetak"); if ( $data == "pdf-po" ) { pdf_po($db, $nomor, $mode); } else if ( $data == "default") {} ?>