<script type="text/javascript">
$(function() {
$("#theTable.dua tr:even").addClass("stripe1");
$("#theTable.dua tr:odd").addClass("stripe2");
$("#theTable.dua tr").hover(
function() {
$(this).toggleClass("highlight");
},
function() {
$(this).toggleClass("highlight");
}
);
});
</script>
<?php
include '../../inc/inc.koneksi.php';
include '../../inc/fungsi_tanggal.php';
$tgl1 = jin_date_sql($_POST['tgl1']);
$tgl2 = jin_date_sql($_POST['tgl2']);
$where = " WHERE tgl BETWEEN '{$tgl1}' AND '{$tgl2}'";
echo "<table id='theTable' class='dua' width='100%'>\r\n\t\t<tr>\r\n\t\t\t<th width='5%'>No</th>\r\n\t\t\t<th>Tanggal</th>\r\n\t\t\t<th>No Anggota</th>\r\n\t\t\t<th>Anggota</th>\r\n\t\t\t<th>L/P</th>\r\n\t\t\t<th>Simpanan</th>\r\n\t\t\t<th>Jumlah</th>\r\n\t\t</tr>";
$sql = "SELECT a.*,b.jenis_simpanan,c.namaanggota,c.jk\r\n\t\t\t\tFROM pengambilan as a\r\n\t\t\t\tJOIN jenis_simpanan as b\r\n\t\t\t\tJOIN nasabah as c\r\n\t\t\t\tON a.id_jenis=b.id_jenis AND a.noanggota=c.noanggota\r\n\t\t\t\t{$where}\r\n\t\t\t\tORDER BY a.id_ambil DESC";
$query = mysql_query($sql);
$no = 1;
while ($rows = mysql_fetch_array($query)) {
echo "<tr>\r\n\t\t\t\t<td align='center'>{$no}</td>\r\n\t\t\t\t<td align='center'>" . jin_date_str($rows['tgl']) . "</td>\r\n\t\t\t\t<td align='center'>" . $rows['noanggota'] . "</td>\r\n\t\t\t\t<td>" . $rows['namaanggota'] . "</td>\r\n\t\t\t\t<td>" . $rows['jk'] . "</td>\r\n\t\t\t\t<td>" . $rows['jenis_simpanan'] . "</td>\r\n\t\t\t\t<td align='right'>" . number_format($rows['jumlah']) . "</td>\r\n\t\t\t</tr>";
$no++;
}
echo "</table>";
$query = "select * from nasabah\n\t\t{$where}\n\t\torder by noanggota";
//echo $query;
$data = mysql_query($query);
function myheader($profil, $judul_H)
{
echo "<div class='profil'>" . $profil . "\n\t\t</div>\n\t\t<br>\n\t\t<div class='header'>\n\t\t <h2>" . $judul_H . "</h2>\n\t\t </div>\n\t\t<table class='grid' >\n\t\t<tr>\n\t\t\t<th width='5%'>No</th>\n\t\t\t<th >Nomor Anggota</th>\n\t\t\t<th >No Identitas</th>\n\t\t\t<th >Nama Anggota</th>\n\t\t\t<th >L/P</th>\n\t\t\t<th >Tempat, Tanggal Lahir</th>\n\t\t\t<th >Alamat</th>\n\t\t\t<th >HP</th>\n\t\t\t<th >Simpanan</th>\n\t\t\t<th >Pinjaman</th>\n\t\t</tr>";
}
//echo $query;
function myfooter()
{
echo "</table>";
}
$no = 1;
$page = 1;
while ($r_data = mysql_fetch_array($data)) {
$tgllhr = jin_date_str($r_data['tgl_lahir']);
$simpanan = simpanan($r_data['noanggota']);
$pinjaman = sisaAngsuran($r_data['noanggota']);
if ($no % 40 == 1) {
if ($no > 1) {
myfooter();
echo "<div class=\"pagebreak\" align='right'>\n\t\t<div class='page' align='center'>Hal - {$page}</div>\n\t\t</div>";
$page++;
}
myheader($profil, $judul_H);
}
echo "<tr>\n\t\t\t<td align='center'>{$no}</td>\n\t\t\t<td align='center'>{$r_data['noanggota']}</td>\n\t\t\t<td align='center'>{$r_data['noidentitas']}</td>\n\t\t\t<td align='left'>{$r_data['namaanggota']}</td>\n\t\t\t<td align='center'>{$r_data['jk']}</td>\n\t\t\t<td align='left'>{$r_data['tempat_lahir']}, {$tgllhr}</td>\n\t\t\t<td align='left'>{$r_data['alamat']}</td>\n\t\t\t<td align='left'>{$r_data['hp']}</td>\n\t\t\t<td align='right'>" . number_format($simpanan) . "</td>\n\t\t\t<td align='right'>" . number_format($pinjaman) . "</td>\n\t\t\t</tr>";
$no++;
}
myfooter();
echo "</table>";
$query = "SELECT id_simpanan as id,tgl,noanggota,id_jenis,jumlah,user_id,'simpan' as ket,tglinsert FROM simpanan\r\n\t\t{$where}\r\n\t\tUNION\r\n\t\tSELECT id_ambil as id, tgl,noanggota,id_jenis,jumlah,user_id,'tarik tunai' as ket,tglinsert FROM pengambilan\r\n\t\t{$where}\r\n\t\torder by tglinsert";
$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 >Tanggal</th>\r\n\t\t\t<th >Jenis</th>\r\n\t\t\t<th >Debet</th>\r\n\t\t\t<th >Kredit</th>\r\n\t\t\t<th >Saldo</th>\r\n\t\t</tr>";
}
//echo $query;
function myfooter()
{
echo "</table>";
}
$no = 1;
$page = 1;
$saldo = 0;
while ($r_data = mysql_fetch_array($data)) {
$tgl = jin_date_str($r_data['tgl']);
$jenis = cariJenis($r_data['id_jenis']);
$ket = $r_data['ket'];
if ($ket == 'simpan') {
$debet = $r_data['jumlah'];
$kredit = 0;
} else {
$debet = 0;
$kredit = $r_data['jumlah'];
}
$saldo = $saldo + $debet - $kredit;
//$total = $r_data[hargabeli]*$r_data[jmlbeli];
//$gtotal = $gtotal+$total;
if ($no % 40 == 1) {
if ($no > 1) {
myfooter();
<?php
include "../../inc/inc.koneksi.php";
include "../../inc/fungsi_tanggal.php";
$table = 'nasabah';
$id = $_POST['cari'];
$text = "SELECT *\r\n\t\t\tFROM {$table} WHERE noanggota= '{$id}'";
$sql = mysql_query($text);
$row = mysql_num_rows($sql);
if ($row > 0) {
$r = mysql_fetch_array($sql);
if ($r['jk'] == 'L') {
$sex = 'Laki-laki';
} else {
$sex = 'Perempuan';
}
echo "<table>\r\n\t\t<tr>\r\n\t\t\t<td>No Identitas</td>\r\n\t\t\t<td>: " . $r['noidentitas'] . "</td>\r\n\t\t</tr>\r\n\t\t<tr>\r\n\t\t\t<td>Nama</td>\r\n\t\t\t<td>: " . $r['namaanggota'] . "</td>\r\n\t\t</tr>\r\n\t\t<tr>\r\n\t\t\t<td>Jenis Kelamin</td>\r\n\t\t\t<td>: {$sex}</td>\r\n\t\t</tr>\r\n\t\t<tr>\r\n\t\t\t<td>Tempat, Tgl Lahir</td>\r\n\t\t\t<td>: " . $r['tempat_lahir'] . ", " . jin_date_str($r['tgl_lahir']) . "</td>\r\n\t\t</tr>\r\n\t\t<tr>\r\n\t\t\t<td>Alamat</td>\r\n\t\t\t<td>: " . $r['alamat'] . "</td>\r\n\t\t</tr>\r\n\t</table>";
}
<?php
include "../../inc/inc.koneksi.php";
include "../../inc/fungsi_tanggal.php";
$table = 'pinjaman';
$id = $_POST['cari'];
$text = "SELECT *\r\n\t\t\tFROM {$table} WHERE id_pinjam= '{$id}'";
$sql = mysql_query($text);
$row = mysql_num_rows($sql);
if ($row > 0) {
while ($r = mysql_fetch_array($sql)) {
$data['nomor'] = $r['noanggota'];
$data['tgl'] = jin_date_str($r['tgl']);
$data['lama'] = $r['lama'];
$data['jml'] = number_format($r['jumlah']);
$data['bunga'] = $r['bunga'];
echo json_encode($data);
}
} else {
$data['nomor'] = '';
$data['tgl'] = '';
$data['lama'] = '';
$data['jml'] = '';
$data['bunga'] = '';
echo json_encode($data);
}
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>";
var id = ID;
var cari = $("#nomor").val();
var pilih = confirm('Data yang akan dihapus = '+id+ '?');
if (pilih==true) {
$.ajax({
type : "POST",
url : "modul/penarikan/hapus.php",
data : "id="+id,
success : function(data){
$("#tampil_data1").load("modul/penarikan/tampil_data1.php?cari="+cari);
}
});
}
}
</script>
<?php
include '../../inc/inc.koneksi.php';
include '../../inc/fungsi_tanggal.php';
$cari = $_GET['cari'];
$where = " WHERE noanggota='{$cari}'";
echo "<table id='theTable' width='100%'>\r\n\t\t<tr>\r\n\t\t\t<th width='5%'>No</th>\r\n\t\t\t<th>Tanggal</th>\r\n\t\t\t<th>Simpanan</th>\r\n\t\t\t<th>Jumlah</th>\r\n\t\t\t<th>Hapus</th>\r\n\t\t</tr>";
$sql = "SELECT a.*,b.jenis_simpanan\r\n\t\t\t\tFROM pengambilan as a\r\n\t\t\t\tJOIN jenis_simpanan as b\r\n\t\t\t\tON a.id_jenis=b.id_jenis\r\n\t\t\t\t{$where}\r\n\t\t\t\tORDER BY a.id_ambil DESC";
$query = mysql_query($sql);
$no = 1;
$gtotal = 0;
while ($rows = mysql_fetch_array($query)) {
echo "<tr>\r\n\t\t\t\t<td align='center'>{$no}</td>\r\n\t\t\t\t<td align='center'>" . jin_date_str($rows['tgl']) . "</td>\r\n\t\t\t\t<td>" . $rows['jenis_simpanan'] . "</td>\r\n\t\t\t\t<td align='right'>" . number_format($rows['jumlah']) . "</td>\r\n\t\t\t\t<td align='center'>\r\n\t\t\t\t<a href='javascript:deleteRow(\"{$rows['id_ambil']}\")'>Hapus</a>\r\n\t\t\t\t</td>\r\n\t\t\t</tr>";
$no++;
$gtotal = $gtotal + $rows['jumlah'];
}
echo "\r\n\t<tr>\r\n\t\t<td colspan='3' align='center'>Total</td>\r\n\t\t<td align='right'><b>" . number_format($gtotal) . "</b></td>\r\n\t</table>";
$query = "SELECT * FROM angsuran\r\n\t\t{$where}\r\n\t\torder by cicilan";
$data = mysql_query($query);
function myheader($profil, $judul_H, $ket)
{
echo "<div class='profil'>" . $profil . "\r\n\t\t</div>\r\n\t\t<br>\r\n\t\t<div class='header'>\r\n\t\t <h2>" . $judul_H . "</h2>\r\n\t\t</div>\r\n\t\t" . $ket . "\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 >Cicilan Ke</th>\r\n\t\t\t<th >Jatuh Tempo</th>\r\n\t\t\t<th >Angsuran</th>\r\n\t\t\t<th >Bunga</th>\r\n\t\t\t<th >Total</th>\r\n\t\t\t<th >Tanggal Bayar</th>\r\n\t\t\t<th >Jumlah Bayar</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_jatuh_tempo']);
$tglbayar = jin_date_str($r_data['tgl_bayar']);
$angsuran = $r_data['angsuran'];
$bunga = $r_data['bunga'];
$total = $angsuran + $bunga;
$jmlbayar = $r_data['jumlah_bayar'];
//$total = $r_data[hargabeli]*$r_data[jmlbeli];
$gtotal = $gtotal + $total;
$sisa = $sisa + $jmlbayar;
$tsisa = $gtotal - $sisa;
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($profil, $judul_H, $ket);
$(this).toggleClass("highlight");
}
);
});
</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)) {
$where = " WHERE tgl BETWEEN '{$tgl1}' AND '{$tgl2}'";
} else {
$where = "";
}
echo "<table id='theTable' class='satu' width='100%'>\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>Nomor <br>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>";
$sql = "SELECT a.*,b.namaanggota,b.jk\r\n\t\t\t\tFROM pinjaman as a\r\n\t\t\t\tJOIN nasabah as b\r\n\t\t\t\tON a.noanggota=b.noanggota\r\n\t\t\t\t{$where}\r\n\t\t\t\tORDER BY a.id_pinjam DESC";
$query = mysql_query($sql);
//echo $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>\r\n\t\t\t\t<td align='center'>{$no}</td>\r\n\t\t\t\t<td>" . $rows['id_pinjam'] . "</td>\r\n\t\t\t\t<td align='center'>" . jin_date_str($rows['tgl']) . "</td>\r\n\t\t\t\t<td align='center'>" . $rows['noanggota'] . "</td>\r\n\t\t\t\t<td>" . $rows['namaanggota'] . "</td>\r\n\t\t\t\t<td align='center'>" . $rows['jk'] . "</td>\r\n\t\t\t\t<td align='center'>" . $rows['lama'] . "</td>\r\n\t\t\t\t<td align='right'>" . number_format($rows['jumlah']) . "</td>\r\n\t\t\t\t<td align='center'>" . $rows['bunga'] . "</td>\r\n\t\t\t\t<td align='center'>" . number_format($jml_bayar) . "</td>\r\n\t\t\t\t<td align='center'>" . number_format($jml_cicilan) . "</td>\r\n\t\t\t\t<td align='center'>" . number_format($sisa) . "</td>\r\n\t\t\t</tr>";
$no++;
$gtotal = $gtotal + $rows['jumlah'];
}
echo "\r\n\t<tr>\r\n\t\t<td colspan='7' align='center'>Total</td>\r\n\t\t<td align='right'><b>" . number_format($gtotal) . "</b></td>\r\n\t</table>";
<?php
include "../../inc/inc.koneksi.php";
include "../../inc/fungsi_tanggal.php";
$table = 'nasabah';
$id = $_POST['id'];
$text = "SELECT * FROM {$table} WHERE noanggota= '{$id}'";
$sql = mysql_query($text);
$row = mysql_num_rows($sql);
if ($row > 0) {
while ($r = mysql_fetch_array($sql)) {
$data['id'] = $r['noidentitas'];
$data['nama'] = $r['namaanggota'];
$data['jk'] = $r['jk'];
$data['tempat'] = $r['tempat_lahir'];
$data['tgl'] = jin_date_str($r['tgl_lahir']);
$data['alamat'] = $r['alamat'];
$data['hp'] = $r['hp'];
echo json_encode($data);
}
} else {
$data['id'] = '';
$data['nama'] = '';
$data['jk'] = '';
$data['tempat'] = '';
$data['tgl'] = '';
$data['alamat'] = '';
$data['hp'] = '';
echo json_encode($data);
}
$judul_H .= "{$noanggota} - {$nama}<br>";
$query = "SELECT * FROM angsuran\r\n\t\t{$where}\r\n\t\torder by cicilan";
$data = mysql_query($query);
function myheader($judul_H, $ket)
{
echo "<div class='header'>\r\n\t\t <h2>" . $judul_H . "</h2>\r\n\t\t</div>\r\n\t\t" . $ket . "\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 >Cicilan Ke</th>\r\n\t\t\t<th >Jatuh Tempo</th>\r\n\t\t\t<th >Angsuran</th>\r\n\t\t\t<th >Bunga</th>\r\n\t\t\t<th >Total</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_jatuh_tempo']);
$angsuran = $r_data['angsuran'];
$bunga = $r_data['bunga'];
$total = $angsuran + $bunga;
//$total = $r_data[hargabeli]*$r_data[jmlbeli];
$gtotal = $gtotal + $total;
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, $ket);
}
echo "<tr>\r\n\t\t\t<td align='center'>{$no}</td>\r\n\t\t\t<td align='center'>{$r_data['cicilan']}</td>\r\n\t\t\t<td align='center'>{$tgl}</td>\r\n\t\t\t<td align='right'>" . number_format($angsuran) . "</td>\r\n\t\t\t<td align='right'>" . number_format($bunga) . "</td>\r\n\t\t\t<td align='center'>" . number_format($total) . "</td>\r\n\t\t\t</tr>";
$no++;
<?php
include "../../inc/inc.koneksi.php";
include "../../inc/fungsi_tanggal.php";
include "../../inc/fungsi_koperasi.php";
$table = 'nasabah';
$id = $_POST['cari'];
$text = "SELECT *\r\n\t\t\tFROM {$table} WHERE noanggota= '{$id}'";
$sql = mysql_query($text);
$row = mysql_num_rows($sql);
if ($row > 0) {
$r = mysql_fetch_array($sql);
if ($r['jk'] == 'L') {
$sex = 'Laki-laki';
} else {
$sex = 'Perempuan';
}
$sisaangsuran = sisaAngsuran($r['noanggota']);
echo "<table>\r\n\t\t<tr>\r\n\t\t\t<td>No Identitas</td>\r\n\t\t\t<td>: {$r['noidentitas']}</td>\r\n\t\t</tr>\r\n\t\t<tr>\r\n\t\t\t<td>Nama</td>\r\n\t\t\t<td>: {$r['namaanggota']}</td>\r\n\t\t</tr>\r\n\t\t<tr>\r\n\t\t\t<td>Jenis Kelamin</td>\r\n\t\t\t<td>: {$sex}</td>\r\n\t\t</tr>\r\n\t\t<tr>\r\n\t\t\t<td>Tempat, Tgl Lahir</td>\r\n\t\t\t<td>: {$r['tempat_lahir']}, " . jin_date_str($r['tgl_lahir']) . "</td>\r\n\t\t</tr>\r\n\t\t<tr>\r\n\t\t\t<td>Alamat</td>\r\n\t\t\t<td>: {$r['alamat']}</td>\r\n\t\t</tr>\r\n\t\t<tr>\r\n\t\t\t<td>Sisa Angsuran</td>\r\n\t\t\t<td>: " . number_format($sisaangsuran) . "</td>\r\n\t\t</tr>\r\n\t</table><input type='hidden' id='no' value='{$id}' name='no'>";
}
});
</script>
<?php
include '../../inc/inc.koneksi.php';
include '../../inc/fungsi_tanggal.php';
include '../../inc/fungsi_koperasi.php';
$nomor = $_POST['nomor'];
$tgl = jin_date_sql($_POST['tgl']);
//$where = " ";
$where = " WHERE tgl='{$tgl}'";
$cari = " ";
if (!empty($nomor)) {
$where .= " AND noanggota='{$nomor}'";
$cari = " AND noanggota='{$nomor}'";
}
echo "<table id='theTable' width='100%'>\n\t\t<tr>\n\t\t\t<th width='5%'>No</th>\n\t\t\t<th>Nomor Bukti</th>\n\t\t\t<th>Tanggal</th>\n\t\t\t<th>Nomor Anggota</th>\n\t\t\t<th>Nama Anggota</th>\n\t\t\t<th>Jumlah</th>\n\t\t\t<th>Kegiatan</th>\n\t\t</tr>";
$sql = "SELECT id_simpanan as no_bukti,tgl as tgl, noanggota as no_anggota,jumlah as jml, 'Simpanan' as ket FROM simpanan {$where}\n\t\t\t\tUNION\n\t\t\t\tSELECT id_ambil as no_bukti,tgl as tgl, noanggota as no_anggota,jumlah as jml, 'Pengambilan' as ket FROM pengambilan {$where}\n\t\t\t\tUNION\n\t\t\t\tSELECT id_pinjam as no_bukti,tgl as tgl,noanggota as no_angota,jumlah as jml, 'Pinjaman' as ket FROM pinjaman {$where}\n\t\t\t\tUNION\n\t\t\t\tSELECT a.id_pinjam as no_bukti, tgl_bayar as tgl, noanggota as no_anggota, jumlah_bayar as jml, 'Bayar Pinjaman' as ket \n\t\t\t\tFROM pinjaman as a\n\t\t\t\tJOIN angsuran as b\n\t\t\t\tON a.id_pinjam=b.id_pinjam\n\t\t\t\tWHERE tgl_bayar='{$tgl}' {$cari}\n\t\t\t\t\n\t\t\t\tORDER BY tgl DESC";
//echo $sql;
$query = mysql_query($sql);
$no = 1;
while ($rows = mysql_fetch_array($query)) {
$no_bukti = $rows['no_bukti'];
$tgl = jin_date_str($rows['tgl']);
$nomor = $rows['no_anggota'];
$nama = cariNama($rows['no_anggota']);
$jml = number_format($rows['jml']);
$ket = $rows['ket'];
echo "<tr>\n\t\t\t\t<td align='center'>{$no}</td>\n\t\t\t\t<td align='center'>{$no_bukti}</td>\n\t\t\t\t<td align='center'>{$tgl}</td>\n\t\t\t\t<td align='center'>{$nomor}</td>\n\t\t\t\t<td >{$nama}</td>\n\t\t\t\t<td align='right'>{$jml}</td>\n\t\t\t\t<td >{$ket}</td>\n\t\t\t</tr>";
$no++;
}
echo "</table>";
});
$(".tgl").mask('99-99-9999');
</script>
<?php
include '../../inc/inc.koneksi.php';
include '../../inc/fungsi_tanggal.php';
$cari = $_GET['cari'];
$where = " WHERE id_pinjam='{$cari}'";
echo "<div align='center'>\n\t <button class='ui-state-default ui-corner-all' id='simpan'>\n\t <span class='ui-icon ui-icon-disk'></span>Simpan\n\t </button>\n\t <button class='ui-state-default ui-corner-all' id='cetak'>\n\t <span class='ui-icon ui-icon-print'></span>Cetak\n\t </button>\n\t <button class='ui-state-default ui-corner-all' id='tutup'>\n\t <span class='ui-icon ui-icon-circle-close'></span>Tutup\n\t </button>\n\t\t</div>";
echo "<table id='theTable' width='100%'>\n\t\t<tr>\n\t\t\t<th width='5%'>No</th>\n\t\t\t<th>Cicilan Ke</th>\n\t\t\t<th>Tanggal <br>Jatuh Tempo</th>\n\t\t\t<th>Angsuran</th>\n\t\t\t<th>Bunga</th>\t\t\t\n\t\t\t<th>Total</th>\n\t\t\t<th>Tangal Bayar</th>\n\t\t\t<th>Jumlah Bayar</th>\n\t\t</tr>";
$sql = "SELECT *\n\t\t\t\tFROM angsuran\n\t\t\t\t{$where}\n\t\t\t\tORDER BY id_pinjam,cicilan";
$query = mysql_query($sql);
//echo $sql;
$no = 1;
$gtot = 0;
$gtotal = 0;
while ($rows = mysql_fetch_array($query)) {
$tanggal = jin_date_str($rows['tgl_bayar']);
$jatuhtempo = jin_date_str($rows['tgl_jatuh_tempo']);
$jumlah = $rows['angsuran'] + $rows['bunga'];
$jml = $rows['jumlah_bayar'];
echo "<tr>\n\t\t\t\t<td align='center'>{$no}</td>\n\t\t\t\t<td align='center'>" . $rows['cicilan'] . "</td>\n\t\t\t\t<td align='center'>{$jatuhtempo}</td>\n\t\t\t\t<td align='right'>" . number_format($rows['angsuran']) . "</td>\n\t\t\t\t<td align='right'>" . number_format($rows['bunga']) . "</td>\n\t\t\t\t<td align='right'>" . number_format($jumlah) . "</td>\n\t\t\t\t<td align='center'><input type='text' id='tanggal{$no}' value='{$tanggal}' class='tgl' size='10'></td>\n\t\t\t\t<td align='center'><input type='text' id='jml{$no}' value='{$jml}' class='jml' size='11'></td>\n\t\t\t</tr>";
$no++;
$gtotal = $gtotal + $jumlah;
$gtot = $gtot + $jml;
}
$sisa = $gtotal - $gtot;
echo "\n\t<tr>\n\t\t<td colspan='4' align='center'>Total</td>\n\t\t<td align='right'><b>" . number_format($gtotal) . "</b></td>\n\t\t<td align='center'></td>\n\t\t<td align='center'></td>\n\t\t<td align='right'><b>" . number_format($gtot) . "</b></td>\n\t</tr>\n\t<tr>\n\t\t<td colspan='4' align='center'>Sisa Angsuran</td>\n\t\t<td align='right'><b>" . number_format($sisa) . "</b></td>\n\t</tr>\n\t</table>";
<?php
include "../../inc/inc.koneksi.php";
include "../../inc/fungsi_tanggal.php";
include "../../inc/fungsi_koperasi.php";
$table = 'nasabah';
$id = $_POST['cari'];
$text = "SELECT *\r\n\t\t\tFROM {$table} WHERE noanggota= '{$id}'";
$sql = mysql_query($text);
$row = mysql_num_rows($sql);
if ($row > 0) {
$r = mysql_fetch_array($sql);
if ($r['jk'] == 'L') {
$sex = 'Laki-laki';
} else {
$sex = 'Perempuan';
}
$saldo = saldo($r['noanggota']);
echo "<table>\r\n\t\t<tr>\r\n\t\t\t<td>Nama</td>\r\n\t\t\t<td>: {$r['namaanggota']}</td>\r\n\t\t</tr>\r\n\t\t<tr>\r\n\t\t\t<td>Jenis Kelamin</td>\r\n\t\t\t<td>: {$sex}</td>\r\n\t\t</tr>\r\n\t\t<tr>\r\n\t\t\t<td>Tempat, Tgl Lahir</td>\r\n\t\t\t<td>: {$r['tempat_lahir']}, " . jin_date_str($r['tgl_lahir']) . "</td>\r\n\t\t</tr>\r\n\t\t<tr>\r\n\t\t\t<td>Alamat</td>\r\n\t\t\t<td>: {$r['alamat']}</td>\r\n\t\t</tr>\r\n\t\t<tr>\r\n\t\t\t<td>Saldo</td>\r\n\t\t\t<td>: " . number_format($saldo) . "</td>\r\n\t\t</tr>\r\n\t</table>";
}
