"; echo "div#divprint{width:850px; border:1px solid #000; padding:20px 0; margin-bottom:25px;}"; echo "table.tbl {width:700px;border-width:0 0 1px 1px;border-spacing:0;border-collapse:collapse;font-size:9pt;text-align:center;}"; echo "table.tbl,table.tbl td {border-color:#000;border-style:solid;}"; echo "table.tbl td {margin:0;padding:2px;border-width:1px 1px 0 0;}"; echo "body {font-size:9pt;}"; echo "div.luar{text-align:left;margin-left:150px;}"; echo ".header{font-weight:bold;text-align:center;}"; echo ".isi{text-align:left;}"; echo ".warnaBarisStrip{font-weight : bold; background-color : #FFFF33;}"; echo ".warnaBarisKategori{font-weight : bold; background-color: #FFCC00;}"; echo ".master{text-align:left;}"; echo ""; $startDate = decTgl($_POST['startDate']); $endDate = decTgl($_POST['endDate']); if(bukaKoneksi()){ global $conn; /*----------------------------------------Laporan pembayaran per supplier*/ $query = /*"SELECT a.kd_supplier,a.jenis_bayar,nama_supplier,a.tgl_bayar,a.totalbayartunai,b.totalbayargiro, c.totalbayartransfer FROM supplier s LEFT JOIN (SELECT kd_supplier,jenis_bayar,tgl_bayar,total_bayar as totalbayartunai FROM bayar WHERE jenis_bayar = 'cash' AND kd_supplier != '' AND tgl_bayar BETWEEN '$startDate' AND '$endDate' order by jenis_bayar,tgl_bayar)a ON s.`kd_supplier` = a.kd_supplier LEFT JOIN (SELECT kd_supplier,tgl_bayar,total_bayar as totalbayargiro FROM bayar WHERE jenis_bayar = 'giro' AND kd_supplier != '' AND tgl_bayar BETWEEN '$startDate' AND '$endDate' order by jenis_bayar,tgl_bayar)b ON s.kd_supplier = b.kd_supplier LEFT JOIN (SELECT kd_supplier,tgl_bayar,total_bayar as totalbayartransfer FROM bayar WHERE jenis_bayar = 'transfer' AND kd_supplier != '' AND tgl_bayar BETWEEN '$startDate' AND '$endDate'order by jenis_bayar,tgl_bayar)c ON s.kd_supplier = c.kd_supplier";*/ "SELECT b.kd_supplier,b.jenis_bayar,s.nama_supplier,b.tgl_cair,b.total_bayar from bayar b join supplier s on b.kd_supplier=s.kd_supplier where b.kd_supplier != '' AND date(tgl_cair) BETWEEN '$startDate' AND '$endDate' order by tgl_cair,kd_supplier,jenis_bayar"; if($stmt = mysqli_prepare($conn,$query)){ mysqli_stmt_execute($stmt); mysqli_stmt_store_result($stmt); $cek = mysqli_stmt_num_rows($stmt); if($cek > 0){ /*mysqli_stmt_bind_result($stmt,$kd_supplier,$jnsbyr,$namasupp,$tgl_bayar,$totalbayartunai,$totalbayargiro,$totalbayartransfer);*/ mysqli_stmt_bind_result($stmt,$kd_supplier,$jnsbyr,$namasupp,$tgl_cair,$totalbyr); print("
| Tanggal Bayar | Kode Supplier | Nama Supplier | Total Bayar Tunai | Total Bayar Giro | Total Bayar Transfer |
| $kd_supplier | $namasupp | $tgl_bayar | ".number_format($totalbayartunai,0,',','.')." | ".number_format($totalbayargiro,0,',','.')." | ".number_format($totalbayartransfer,0,',','.')." |
| $tgl_cair | $kd_supplier | $namasupp | ".number_format($totalbyr,0,',','.')." | ".number_format(0,0,',','.')." | ".number_format(0,0,',','.')." |
| $tgl_cair | $kd_supplier | $namasupp | ".number_format(0,0,',','.')." | ".number_format($totalbyr,0,',','.')." | ".number_format(0,0,',','.')." |
| $tgl_cair | $kd_supplier | $namasupp | ".number_format(0,0,',','.')." | ".number_format(0,0,',','.')." | ".number_format($totalbyr,0,',','.')." |
| Sub Total | ".number_format($totalbyrtunai, 0, ",", ".")." | ".number_format($totalbyrgiro, 0, ",", ".")." | ".number_format($totalbyrtransfer, 0, ",", ".")." | ||
| Total Pembayaran | ".number_format($ttHP,0,',','.')." | ||||