function lap_perpanjang()
{
$n = 0;
$data = array();
$datax = array();
$no_spb = $_POST['no_spb'];
$data['ae'] = $this->Admin_model->is_oto('spb/perpanjang', 'e');
$data = $this->Admin_model->show_list('spb', "where jt_spb <now() order by left(no_spb,5),year(tgl_spb)");
foreach ($data->result() as $row) {
$n++;
echo "\n<tr class='xx' id='" . $row->no_spb . "' align='center'>\r\n\t\t\t\t <td class='kotak' align='left'>" . $row->id_barang . "</td>\t\r\n\t\t\t\t <td class='kotak' align='left'>" . substr($row->no_spb, 0, 5) . "</td>\t\r\n\t\t\t\t <td class='kotak' align='left'>" . ShortTgl($row->tgl_spb, true) . "</td>\t\r\n\t\t\t\t <td class='kotak' align='left'>" . $row->nama_spb . "</td>\t\r\n\t\t\t\t <td class='kotak' align='right'>" . number_format($row->taksir_spb, 2) . "</td>\t\r\n\t\t\t\t <td class='kotak' align='right'>" . number_format($row->nilai_spb, 2) . "</td>\t\r\n\t\t\t\t <td class='kotak'>" . $row->jw_spb . "</td>\t\r\n\t\t\t\t <td class='kotak'>" . TglfromSql($row->jt_spb) . "</td>\r\n\t\t\t\t <td id='c-1' class='kotak'>" . perpanjang($row->no_spb, 1, true) . "</td>\t\r\n\t\t\t\t <td id='c-2' class='kotak'>" . perpanjang($row->no_spb, 2, true) . "</td>\t\r\n\t\t\t\t <td id='c-3' class='kotak'>" . perpanjang($row->no_spb, 3, true) . "</td>\t\r\n\t\t\t\t <td id='c-4' class='kotak'>" . perpanjang($row->no_spb, 4, true) . "</td>\t\r\n\t\t\t\t <td id='c-5' class='kotak'>" . perpanjang($row->no_spb, 5, true) . "</td>\t\r\n\t\t\t\t <td id='c-6' class='kotak'>" . perpanjang($row->no_spb, 6, true) . "</td>\t\r\n\t\t\t\t <td id='c-7' class='kotak'>" . perpanjang($row->no_spb, 7, true) . "</td>\t\r\n\t\t\t\t <td id='c-8' class='kotak'>" . perpanjang($row->no_spb, 8, true) . "</td>\t\r\n\t\t\t\t <td id='c-9' class='kotak'>" . perpanjang($row->no_spb, 9, true) . "</td>\t\r\n\t\t\t\t <td id='c-10' class='kotak'>" . perpanjang($row->no_spb, 10, true) . "</td>\t\r\n\t\t\t\t </tr>\n";
}
//$datax['pp_ke']=rdb('perpanjang_spb','pp_ke','pp_ke',"where no_spb='".$row->no_spb."'");
//echo json_encode($datax);
}
$user_aktiv = $this->session->userdata("userid");
$blnj = "<select id='bulan' name='bulan'></select>";
$thnj = "<select id='thn' name='thn'></select>";
$img = "<img src='" . base_url() . "asset/images/printer.png' id='printing' title='Print Report' class='xx'>";
echo "<form id='frm1' name='frm1' action='' method='post'>";
panel_begin('Daftar SPB,Perpanjang SPB', '', "Filter by Bulan :," . $blnj . ",Tahun :," . $thnj . ", ", "{$img}");
panel_multi('daftarspb', 'block');
$zb = new zetro_listBuilder('asset/bin/zetro_form.cfg');
$zb->ListHeader('Spb', '100%', 'listTable');
$no = 0;
//($page+1);
foreach ($list->result_array() as $lst) {
$no++;
echo "<tr class='xx' id='" . $lst['no_spb'] . "' align='center'>\r\n\t\t <td class='kotak'>{$no}</td>\r\n\t \t <td class='kotak'>" . $lst['no_spb'] . "</td>\r\n\t\t <td class='kotak'>" . tglfromSql($lst['tgl_spb']) . "</td>\r\n\t\t <td class='kotak' align='left'>" . $lst['nama_spb'] . "</td>\r\n\t\t <td class='kotak' align='left'>" . $lst['ktp_spb'] . "</td>\r\n\t\t <td class='kotak' align='left'>" . $lst['id_barang'] . "</td>\r\n\t\t <td class='kotak' align='right'>" . number_format($lst['taksir_spb'], 2) . "</td>\r\n\t\t <td class='kotak' align='right'>" . number_format($lst['nilai_spb'], 2) . "</td>\r\n\t\t <td class='kotak'>" . $lst['jw_spb'] . "</td>\r\n\t\t <td class='kotak'>" . tglfromSql($lst['jt_spb']) . "</td>";
$ppke = rdb("perpanjang_spb", "pp_ke", 'pp_ke', "where no_spb='" . $lst['no_spb'] . "'");
echo compare_date($lst['jt_spb'], date('Y-m-d')) ? "<td class='kotak' width='5%'>" . perpanjang($lst['no_spb'], $ppke) . "<td>" : "<td class='kotak' width='5%'> </td></tr>";
}
echo "</tbody></table>\n";
panel_multi_end();
panel_multi('perpanjangspb');
?>
<table id='listdata' style='border-collapse:collapse'>
<thead>
<tr class='header'>
<th class='kotak' rowspan='2' width='20%'>URAIAN</th>
<th class='kotak' colspan='2' width='12%'>PENJUALAN</th>
<th class='kotak' rowspan='2' width='10%'>NAMA NASABAH</th>
<th class='kotak' rowspan='2' width='10%'>TAKSIR</th>
<th class='kotak' rowspan='2' width='10%'>NILAI TAKSIR</th>
<th class='kotak' rowspan='2' width='5%'>WAKTU</th>
<th class='kotak' rowspan='2' width='8%'>JATUH TEMPO</th>
function pelunasan()
{
$n = 0;
$data = array();
$datax = array();
$no_spb = $_POST['no_spb'];
$data['ae'] = $this->Admin_model->is_oto('spb/lunas', 'e');
$data = $this->Admin_model->show_list('spb', "where no_spb='{$no_spb}' order by left(no_spb,5),year(tgl_spb)");
foreach ($data->result() as $row) {
$n++;
echo "\n<tr class='xx' id='" . $row->no_spb . "' align='center'>\r\n\t\t\t\t <td class='kotak' align='left'>" . $row->id_barang . "</td>\t\r\n\t\t\t\t <td class='kotak' align='right'>" . number_format($row->taksir_spb, 2) . "</td>\t\r\n\t\t\t\t <td class='kotak' align='right'>" . number_format($row->nilai_spb, 2) . "</td>\t\r\n\t\t\t\t <td class='kotak'>" . $row->jw_spb . "</td>\t\r\n\t\t\t\t <td class='kotak'>" . TglfromSql($row->jt_spb) . "</td>\r\n\t\t\t\t <td id='c-1' class='kotak'>" . perpanjang($row->no_spb, 1, true, true) . "</td>\t\r\n\t\t\t\t <td id='c-2' class='kotak'>" . perpanjang($row->no_spb, 2, true, true) . "</td>\t\r\n\t\t\t\t <td id='c-3' class='kotak'>" . perpanjang($row->no_spb, 3, true, true) . "</td>\t\r\n\t\t\t\t <td id='c-4' class='kotak'>" . perpanjang($row->no_spb, 4, true, true) . "</td>\t\r\n\t\t\t\t <td id='c-5' class='kotak'>" . perpanjang($row->no_spb, 5, true, true) . "</td>\t\r\n\t\t\t\t <td id='c-6' class='kotak'>" . perpanjang($row->no_spb, 6, true, true) . "</td>\t\r\n\t\t\t\t <td id='c-7' class='kotak'>" . perpanjang($row->no_spb, 7, true, true) . "</td>\t\r\n\t\t\t\t <td id='c-8' class='kotak'>" . perpanjang($row->no_spb, 8, true, true) . "</td>\t\r\n\t\t\t\t <td id='c-9' class='kotak'>" . perpanjang($row->no_spb, 9, true, true) . "</td>\t\r\n\t\t\t\t <td id='c-10' class='kotak'>" . perpanjang($row->no_spb, 10, true, true) . "</td>\t\r\n\t\t\t\t </tr>\n";
}
}
