<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>
