Cleopatra

0){ mysqli_stmt_bind_result($stmt,$faktur,$tglMsk,$tglNota,$tglTmp,$kdSup,$nmSup,$ttBeli,$ttRp,$ket); print("

"); print("

Rekap Pembelian Per Supplier

"); print("

TOKO ".$_SESSION['namatoko']."
"); print("TANGGAL NOTA : ".encTgl($startDate) ." s/d ".encTgl($endDate)."
"); print("DICETAK TANGGAL : ".date('d-m-Y')." ". date('H:i:s')."

"); print(""); print(""); $ttHP = 0; while(mysqli_stmt_fetch($stmt)){ $ttHP += $ttRp; print(" "); ?> "); print("

No. Faktur	Tanggal Masuk	Tanggal Nota	Tanggal Jt Tempo	Kode Supp.	Nama Supplier	Jumlah Pembelian	Rupiah Pembelian	Keterangan	Pelunasan
.$faktur	".encTgl($tglMsk)."	".encTgl($tglNota)."	".encTgl($tglTmp)."	.$kdSup	$nmSup	".number_format($ttBeli,0,',','.')."	".number_format($ttRp,0,',','.')."	$ket
Total HP Pembelian							".number_format($ttHP,0,',','.')."

"); print("

"); }else{ echo "tidak ada data pembelian"; echo "
"; } } if (!empty($kodesupp)){ /*----------------------------------------Retur grouping per supplier*/ $query2 = "SELECT m.no_nota,m.tgl_retur,m.keterangan,m.kd_supplier,u.nama_supplier, sum( d.jumlah ) jum,sum(d.jumlah*d.harga_satuan) hp FROM d_retur_beli d, m_retur_beli m, supplier u,barang b WHERE d.id_retur = m.id_retur AND b.kode_barang = d.kd_barang AND u.kd_supplier = m.kd_supplier AND m.tgl_retur BETWEEN '$startDate' AND '$endDate' AND m.kd_supplier = '$kodesupp' AND m.validasi = '1' AND m.status_bayar = '0' GROUP BY m.no_nota ORDER BY m.tgl_retur"; } if($stmt2 = mysqli_prepare($conn,$query2)){ mysqli_stmt_execute($stmt2); mysqli_stmt_store_result($stmt2); $cek2 = mysqli_stmt_num_rows($stmt2); if($cek2 > 0){ mysqli_stmt_bind_result($stmt2,$nota,$tglretur,$ketr,$kdsupplier,$nmsupplier,$jmlret,$rpret); print("

"); print("

Rekap Retur Per Supplier

"); print("

TOKO ".$_SESSION['namatoko']."
"); print("TANGGAL MASUK : ".encTgl($startDate) ." s/d ".encTgl($endDate)."
"); print("DICETAK TANGGAL : ".date('d-m-Y')." ". date('H:i:s')."

"); print(""); print(""); $ttHP2 = 0; while(mysqli_stmt_fetch($stmt2)){ $ttHP2 += $rpret; print(""); ?> "); print("

No.Nota	Tgl Retur	Kode Supp.	Nama Supplier	Jumlah Retur	Rupiah Retur	Keterangan	Pelunasan
.$nota	".encTgl($tglretur)."	$kdsupplier	$nmsupplier	$jmlret	".number_format($rpret,0,',','.')."	$ketr
Total HP Retur					".number_format($ttHP2,0,',','.')."

"); print("

"); }else{ echo "tidak ada data retur"; echo "
"; } } ?>

Form Pembayaran

" />

Periode Tgl Faktur	:
Tgl Pembayaran	:
Supplier	:
Jenis Pembayaran	:
	:
	:
Total Pembelian - Retur	:

Penyesuaian
Diskon	: Rp.
Penyesuaian	: Rp.
Materai	: Rp.

Total Pembayaran Supplier	: