<th class="w20">NAMA</th> <th class="w40">ALAMAT SURAT</th> <th class="w10">TELEPON</th> <th class="w10">TANGGAL JATUH TEMPO</th> <th class="w10">NILAI JATUH TEMPO</th> </tr> <?php if ($total_data > 0) { $query = "\n\tSELECT \n\t\tA.KODE_BLOK,A.NAMA_PEMBELI,A.ALAMAT_SURAT,A.TELP_KANTOR,A.TELP_LAIN,A.TELP_RUMAH,B.TANGGAL,B.NILAI\n\tFROM \n\t\tSPP A JOIN RENCANA B ON A.KODE_BLOK = B.KODE_BLOK\n\tWHERE\n\t\tB.TANGGAL = CONVERT(DATETIME,'{$tgl}',105)AND \n\tB.KODE_BLOK NOT IN({$query_blok_lunas})\n\tORDER BY A.KODE_BLOK\n\t"; $obj = $conn->selectlimit($query, $per_page, $page_start); while (!$obj->EOF) { $id = $obj->fields['KODE_BLOK']; $tanggal_tempo = fm_date(date("Y-m-d", strtotime($obj->fields['TANGGAL']))); $TELP_KANTOR = trim($obj->fields["TELP_KANTOR"]) != "" ? trim(strtoupper($obj->fields["TELP_KANTOR"])) : ""; $TELP_LAIN = trim($obj->fields["TELP_LAIN"]) != "" ? "," . trim(strtoupper($obj->fields["TELP_LAIN"])) : ""; $TELP_RUMAH = trim($obj->fields["TELP_RUMAH"]) != "" ? "," . trim(strtoupper($obj->fields["TELP_RUMAH"])) : ""; $TELP = $TELP_KANTOR . $TELP_LAIN . $TELP_RUMAH; ?> <tr class="onclick" id="<?php echo $id; ?> "> <td width="30" class="notclick text-center"><input type="checkbox" name="cb_data[]" class="cb_data" value="<?php echo $id; ?> "></td> <td class="text-center"><?php echo $id;
$cb_data = isset($_REQUEST['cb_data']) ? $_REQUEST['cb_data'] : ''; $tanggal_tempo = isset($_REQUEST['tanggal_tempo']) ? clean($_REQUEST['tanggal_tempo']) : ''; $tgl_tempo = fm_date(date("Y-m-d", strtotime($tanggal_tempo))); $array_bulan = array(1 => 'Januari', 'Februari', 'Maret', 'April', 'Mei', 'Juni', 'Juli', 'Agustus', 'September', 'Oktober', 'November', 'Desember'); if ($act == 'Surat') { $act = array(); foreach ((array) $cb_data as $id) { $query = "SELECT *, B.TANGGAL AS TGL_TEMPO FROM SPP A JOIN RENCANA B ON A.KODE_BLOK = B.KODE_BLOK\n\t\t\t\tWHERE A.KODE_BLOK = '{$id}'"; $obj = $conn->execute($query); $nama_pembeli = $obj->fields['NAMA_PEMBELI']; $alamat = $obj->fields['ALAMAT_SURAT']; $TELP_KANTOR = trim($obj->fields["TELP_KANTOR"]) != "" ? trim(strtoupper($obj->fields["TELP_KANTOR"])) : ""; $TELP_LAIN = trim($obj->fields["TELP_LAIN"]) != "" ? "," . trim(strtoupper($obj->fields["TELP_LAIN"])) : ""; $TELP_RUMAH = trim($obj->fields["TELP_RUMAH"]) != "" ? "," . trim(strtoupper($obj->fields["TELP_RUMAH"])) : ""; $telepon = $TELP_KANTOR . $TELP_LAIN . $TELP_RUMAH; $tanggal_spp = fm_date(date("Y-m-d", strtotime($obj->fields['TANGGAL_SPP']))); $bulan = $array_bulan[date("n", strtotime($tanggal_tempo))]; $nomor_spp = $obj->fields['NOMOR_SPP']; $nilai = $obj->fields['NILAI']; $query = "select STATUS_KOMPENSASI FROM SPP WHERE KODE_BLOK = '{$id}'"; $obj = $conn->execute($query); $status = $obj->fields['STATUS_KOMPENSASI']; $query = "select * from CS_REGISTER_CUSTOMER_SERVICE"; $obj = $conn->execute($query); if ($status == 2) { $no = 1 + $obj->fields['NOMOR_SURAT_TUNAI']; $reg = $obj->fields['REG_SURAT_TUNAI']; } else { if ($status == 1) { $no = 1 + $obj->fields['NOMOR_SURAT_KPR']; $reg = $obj->fields['REG_SURAT_KPR'];
<form name="form" id="form" method="post"> <table class="t-control2"> <tr> <td style="font-size:20px;text-align:center;font-weight:bold" >Daftar Surat Pemberitahuan Pengurusan Akad </td> </tr> </table> <table class="t-control"> <tr> <td>Tanggal</td><td>:</td> <td><?php echo fm_date(date("Y-m-d")); ?> </td> </tr> <tr> <td width="100">Jumlah Baris</td><td width="10">:</td> <td> <input type="text" name="per_page" size="3" id="per_page" class=" apply text-center" value="20"> <input type="button" name="apply" id="apply" value=" Apply "> <input type="hidden" name="act" id="act" value="Surat"> </td> </tr> <tr> <td>Total Data</td><td>:</td> <td id="total-data"></td> </tr> </table> <script type="text/javascript"> jQuery(function($) { /* -- FILTER -- */
<?php require_once '../../../../../config/config.php'; die_login(); $conn = conn($sess_db); die_conn($conn); $namafile = "Daftar Penagihan " . "(" . substr(fm_date(date("Y-m-d")), 3) . ").xls"; header("Content-type: application/octet-stream"); header("Content-Disposition: attachment; filename={$namafile}"); //ganti nama sesuai keperluan header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Pragma: no-cache"); header("Expires: 0"); ?> <html> <body> <table class="t-data w50"> <tr> <th class="w10">KODE BLOK</th> <th class="w10">NO PELANGGAN</th> <th class="w20">NAMA PELANGGAN</th> <th class="w10">TAGIHAN</th> </tr> <?php $query = "\n\tSELECT a.KODE_BLOK, b.NAMA_PEMBELI, a.NILAI, a.TANGGAL, NOMOR_CUSTOMER = CASE WHEN b.NOMOR_CUSTOMER IS NULL\n\tTHEN '-' ELSE b.NOMOR_CUSTOMER END\n\tfrom RENCANA a LEFT JOIN SPP b\n\tON a.KODE_BLOK = b.KODE_BLOK\n\twhere TANGGAL >= CONVERT(DATETIME,'01-01-2015',105) \n\tAND TANGGAL < CONVERT(DATETIME,'01-02-2015',105)\n\tAND STATUS_WANPRESTASI IS NULL\n\tAND a.KODE_BLOK NOT IN ({$query_blok_lunas})\n\t{$query_search}\n\torder BY a.TANGGAL\n\n\t"; $obj = $conn->execute($query); while (!$obj->EOF) { $id = $obj->fields['KODE_BLOK'];
$kemarin_bln = 12; $kemarin_thn = $sekarang_thn - 1; } $query_blok_lunas_bayar = ''; $query_pemb_jt = ''; $query_tglmerah = ''; $query_libur = ''; $query_blok_lunas_bayar = "SELECT C.KODE_BLOK FROM ( SELECT A.KODE_BLOK,B.SUMOFREALISASI,A.SUMOFPLAN,(B.SUMOFREALISASI-A.SUMOFPLAN) AS REMAIN FROM \n( SELECT SUM (A.NILAI) as SUMOFPLAN, A.KODE_BLOK from ( select A.KODE_BLOK,A.TANGGAL_TANDA_JADI AS TANGGAL,ISNULL(A.TANDA_JADI,0) \nAS NILAI from spp A where A.KODE_BLOK is not null UNION ALL SELECT A.KODE_BLOK,A.TANGGAL,ISNULL(A.NILAI,0) FROM RENCANA A WHERE A.KODE_BLOK IS NOT NULL\n)a GROUP BY a.KODE_BLOK ) A LEFT JOIN (SELECT SUM(A.NILAI) AS SUMOFREALISASI,A.KODE_BLOK FROM REALISASI A GROUP BY A.KODE_BLOK)B \nON A.KODE_BLOK=B.KODE_BLOK where (B.SUMOFREALISASI-A.SUMOFPLAN)>=0 )C LEFT JOIN SPP D ON C.KODE_BLOK = D.KODE_BLOK\nWHERE C.REMAIN - (ISNULL(D.NILAI_CAIR_KPR,0)) >= 0 UNION ALL SELECT KODE_BLOK FROM KWITANSI WHERE TANGGAL >= CONVERT(DATETIME,'01-{$kemarin_bln}-{$kemarin_thn}',105)\nAND TANGGAL < CONVERT(DATETIME,'01-{$sekarang_bln}-{$sekarang_thn}',105)\n"; $query_pemb_jt .= "(SELECT SOMASI_DUA FROM CS_PARAMETER_COL)"; # Pagination $query = "\nSELECT \n\tA.KODE_BLOK\n\tFROM \n\t\tSPP A JOIN RENCANA B ON A.KODE_BLOK = B.KODE_BLOK\n\tWHERE\n\t\t(select dbo.tambah_tgl(B.TANGGAL,{$query_pemb_jt})) = CONVERT(DATETIME,'{$tgl}',105)AND \n\tb.KODE_BLOK NOT IN({$query_blok_lunas_bayar})\n\tORDER BY A.KODE_BLOK\n"; $total_data = $conn->execute($query)->recordcount(); $total_page = ceil($total_data / $per_page); $set_jrp = ' <tr><td colspan="8" class="nb text-center"><b> LAPORAN DAFTAR SURAT SOMASI II </b></td></tr> <tr><td colspan="8" class="nb text-center"> Tanggal Cetak : ' . fm_date(date("Y-m-d")) . ' </td></tr> <tr> <td colspan="6" class="nb"> </td> <td colspan="2" class="nb">Halaman '; $set_th = ' dari ' . $total_page . '</td> </tr> <tr> <th class="w5">BLOK / NOMOR </th> <th class="w20">NAMA</th> <th class="w40">ALAMAT SURAT</th> <th class="w10">TELEPON</th> <th class="w10">TANGGAL JATUH TEMPO</th> <th class="w10">NILAI JATUH TEMPO</th>
//ex_ha('', 'D'); $act = array(); $cb_data = $_REQUEST['cb_data']; ex_empty($cb_data, 'Pilih data yang akan dihapus.'); foreach ($cb_data as $id_del) { $id = $id_del; $query = "SELECT *, B.TANGGAL AS TGL_TEMPO FROM SPP A JOIN RENCANA B ON A.KODE_BLOK = B.KODE_BLOK\n\t\t\t\t\t\tWHERE A.KODE_BLOK = '{$id}'"; $obj = $conn->execute($query); $nama = $obj->fields['NAMA_PEMBELI']; $alamat_surat = $obj->fields['ALAMAT_SURAT']; $TELP_KANTOR = trim($obj->fields["TELP_KANTOR"]) != "" ? trim(strtoupper($obj->fields["TELP_KANTOR"])) : ""; $TELP_LAIN = trim($obj->fields["TELP_LAIN"]) != "" ? "," . trim(strtoupper($obj->fields["TELP_LAIN"])) : ""; $TELP_RUMAH = trim($obj->fields["TELP_RUMAH"]) != "" ? "," . trim(strtoupper($obj->fields["TELP_RUMAH"])) : ""; $telp = $TELP_KANTOR . $TELP_LAIN . $TELP_RUMAH; $tanggal_spp = fm_date(date("Y-m-d", strtotime($obj->fields['TANGGAL_SPP']))); $tanggal_tempo = fm_date(date("Y-m-d", strtotime($obj->fields['TGL_TEMPO']))); $nilai = $obj->fields['NILAI']; $query = "select NOMOR_SURAT_PEMBERITAHUAN,REG_SURAT_PEMBERITAHUAN from CS_REGISTER_CUSTOMER_SERVICE"; $obj = $conn->execute($query); $no = $obj->fields['NOMOR_SURAT_PEMBERITAHUAN']; $reg = $obj->fields['REG_SURAT_PEMBERITAHUAN']; } } } catch (Exception $e) { $msg = $e->getmessage(); $error = TRUE; if ($conn) { $conn->rollbacktrans(); } } close($conn);
<tr> <td class="text-center"><?php echo $va; ?> </td> <td></td><td></td><td>IDR</td> <td class="text-left"><?php echo $obj->fields['NAMA_PEMBELI']; ?> </td> <td class="text-left"><?php echo $obj->fields['KODE_BLOK']; ?> </td> <td class="text-left"><?php echo substr(fm_date(date("Y-m-d")), 3); ?> </td> <?php //cek bulan ini merupakan rencana pertama atau bukan $query2 = "\n\t\t\tSELECT COUNT(*) AS TOTAL\n\t\t\tFROM RENCANA WHERE KODE_BLOK = '{$id}' \n\t\t\tAND TANGGAL < CONVERT(DATETIME,'01-{$bln}-{$thn}',105)\n\t\t\t"; $obj2 = $conn->execute($query2); $n_rencana = $obj2->fields['TOTAL']; //jika bulan ini merupakan rancana pertama if ($n_rencana == 0) { //tagihan bulan ini $rencana_sekarang = 0; $query2 = "\n\t\t\t\tSELECT *\n\t\t\t\tFROM RENCANA WHERE KODE_BLOK = '{$id}' \n\t\t\t\tAND TANGGAL >= CONVERT(DATETIME,'01-{$bln}-{$thn}',105)\n\t\t\t\tAND TANGGAL < CONVERT(DATETIME,'01-{$next_bln}-{$next_thn}',105)\n\t\t\t\t"; $obj2 = $conn->execute($query2);
$tanggal = $obj->fields['TANGGAL']; ?> <tr class="onclick" id="<?php echo $id . ' ' . $tanggal; ?> "> <td><?php echo $id; ?> </td> <td><?php echo $obj->fields['NAMA_PEMBELI']; ?> </td> <td class="text-center"><?php echo fm_date(date("Y-m-d", strtotime($obj->fields['TANGGAL']))); ?> </td> <td class="text-center"><?php echo $obj->fields['NOMOR_CUSTOMER']; ?> </td> </tr> <?php $obj->movenext(); } } ?> </table> <table id="pagging-2" class="t-control w60"></table>