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"; } }