window.open('modul/laporan/cetak-pinjam.php?kode='+id); } } </script> <?php include '../../inc/inc.koneksi.php'; include '../../inc/fungsi_tanggal.php'; include '../../inc/fungsi_koperasi.php'; $tgl1 = !empty($_POST['tgl1']) ? $_POST['tgl1'] : ''; $tgl2 = !empty($_POST['tgl2']) ? $_POST['tgl2'] : ''; if (!empty($tgl1)) { $tgl1 = jin_date_sql($_POST['tgl1']); $tgl2 = jin_date_sql($_POST['tgl2']); $where = " WHERE tgl BETWEEN '{$tgl1}' AND '{$tgl2}'"; } else { $where = ""; } echo "<table id='theTable' class='satu' width='100%'>\n\t\t<tr>\n\t\t\t<th width='5%'>No</th>\n\t\t\t<th>Nomor</th>\n\t\t\t<th>Tanggal</th>\n\t\t\t<th>No.Anggota</th>\n\t\t\t<th>Nama</th>\n\t\t\t<th>L/P</th>\n\t\t\t<th>Lama</th>\n\t\t\t<th>Jumlah</th>\n\t\t\t<th>Bunga</th>\n\t\t\t<th>Jumlah <br>Bayar</th>\n\t\t\t<th>Jumlah <br>Cicilan</th>\n\t\t\t<th>Sisa</th>\n\t\t\t<th>Hapus</th>\n\t\t\t<th>Cetak</th>\n\t\t</tr>"; $sql = "SELECT a.*,b.namaanggota,b.jk\n\t\t\t\tFROM pinjaman as a\n\t\t\t\tJOIN nasabah as b\n\t\t\t\tON a.noanggota=b.noanggota\n\t\t\t\t{$where}\n\t\t\t\tORDER BY a.id_pinjam DESC"; $query = mysql_query($sql); $no = 1; $gtotal = 0; while ($rows = mysql_fetch_array($query)) { $jml_bayar = jmlBayar($rows['id_pinjam']); $jml_cicilan = sisa($rows['id_pinjam']); $sisa = $jml_bayar - $jml_cicilan; echo "<tr>\n\t\t\t\t<td align='center'>{$no}</td>\n\t\t\t\t<td>" . $rows['id_pinjam'] . "</td>\n\t\t\t\t<td align='center'>" . jin_date_str($rows['tgl']) . "</td>\n\t\t\t\t<td align='center'>" . $rows['noanggota'] . "</td>\n\t\t\t\t<td>" . $rows['namaanggota'] . "</td>\n\t\t\t\t<td align='center'>" . $rows['jk'] . "</td>\n\t\t\t\t<td align='center'>" . $rows['lama'] . "</td>\n\t\t\t\t<td align='right'>" . number_format($rows['jumlah']) . "</td>\n\t\t\t\t<td align='center'>" . $rows['bunga'] . "</td>\n\t\t\t\t<td align='center'>" . number_format($jml_bayar) . "</td>\n\t\t\t\t<td align='center'>" . number_format($jml_cicilan) . "</td>\n\t\t\t\t<td align='center'>" . number_format($sisa) . "</td>\n\t\t\t\t<td align='center'>\n\t\t\t\t<a href='javascript:deleteRow(\"{$rows['id_pinjam']}\")'>Hapus</a>\t\t\t\n\t\t\t\t</td>\n\t\t\t\t<td align='center'>\n\t\t\t\t<a href='javascript:CetakRow(\"{$rows['id_pinjam']}\")'>Cetak</a>\t\t\t\n\t\t\t\t</td>\n\t\t\t</tr>"; $no++; $gtotal = $gtotal + $rows['jumlah']; } echo "\n\t<tr>\n\t\t<td colspan='7' align='center'>Total</td>\n\t\t<td align='right'><b>" . number_format($gtotal) . "</b></td>\n </tr>\n\t</table>";
$data = mysql_query($query); function myheader($judul_H) { echo "<div class='header'>\r\n\t\t <h2>" . $judul_H . "</h2>\r\n\t\t </div>\r\n\t\t<table class='grid' >\r\n\t\t<tr>\r\n\t\t\t<th width='5%'>No</th>\r\n\t\t\t<th>Nomor</th>\r\n\t\t\t<th>Tanggal</th>\r\n\t\t\t<th>No.Anggota</th>\r\n\t\t\t<th>Nama</th>\r\n\t\t\t<th>L/P</th>\r\n\t\t\t<th>Lama</th>\r\n\t\t\t<th>Jumlah</th>\r\n\t\t\t<th>Bunga</th>\r\n\t\t\t<th>Jumlah <br>Bayar</th>\r\n\t\t\t<th>Jumlah <br>Cicilan</th>\r\n\t\t\t<th>Sisa</th>\r\n\t\t</tr>"; } //echo $query; function myfooter() { echo "</table>"; } $no = 1; $page = 1; while ($r_data = mysql_fetch_array($data)) { $tgl = jin_date_str($r_data['tgl']); $jml_bayar = jmlBayar($r_data[id_pinjam]); $jml_cicilan = sisa($r_data[id_pinjam]); $sisa = $jml_bayar - $jml_cicilan; $t_jml = $t_jml + $r_data['jumlah']; $t_jmlbayar = $t_jmlbayar + $jml_bayar; $t_jmlcicilan = $t_jmlcicilan + $jml_cicilan; $t_jmlsisa = $t_jmlsisa + $sisa; //$stotal = $stotal+$saldo; if ($no % 40 == 1) { if ($no > 1) { myfooter(); echo "<div class=\"pagebreak\" align='right'>\r\n\t\t<div class='page' align='center'>Hal - {$page}</div>\r\n\t\t</div>"; $page++; } myheader($judul_H); } echo "<tr>\r\n\t\t\t<td align='center'>{$no}</td>\r\n\t\t\t<td align='center'>{$r_data['id_pinjam']}</td>\r\n\t\t\t<td align='center'>{$tgl}</td>\r\n\t\t\t<td align='center'>{$r_data['noanggota']}</td>\r\n\t\t\t<td align='left'>{$r_data['namaanggota']}</td>\r\n\t\t\t<td align='center'>{$r_data['jk']}</td>\r\n\t\t\t<td align='center'>{$r_data['lama']}</td>\r\n\t\t\t<td align='right'>" . number_format($r_data['jumlah']) . "</td>\r\n\t\t\t<td align='center'>{$r_data['bunga']} %</td>\r\n\t\t\t<td align='right'>" . number_format($jml_bayar) . "</td>\r\n\t\t\t<td align='right'>" . number_format($jml_cicilan) . "</td>\r\n\t\t\t<td align='right'>" . number_format($sisa) . "</td>\r\n\t\t\t</tr>";