$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'];
}
}
$nomor_surat = $no . $reg;
$tanggal_cetak = kontgl(tgltgl(date("d M Y")));
$kode_blok = $id;
$query = "select * from CS_PARAMETER_COL";
$obj = $conn->execute($query);
$nama_pejabat = $obj->fields['NAMA_PEJABAT'];
$nama_jabatan = $obj->fields['NAMA_JABATAN'];
$nama_pt = $obj->fields['NAMA_PT'];
$pecah_tanggal = explode("-", $tanggal_tempo);
$tgl = $pecah_tanggal[0];
$bln = $pecah_tanggal[1];
$thn = $pecah_tanggal[2];
if ($bln + 1 > 12) {
$next_bln = $bln % 12;
$next_thn = $thn + 1;
} else {
$next_bln = $bln + 1;
$identitas = $obj->fields['IDENTITAS']; $no_identitas = $obj->fields['NO_IDENTITAS']; $kode_agen = $obj->fields['KODE_AGEN']; $kode_koordinator = $obj->fields['KODE_KOORDINATOR']; $npwp = $obj->fields['NPWP']; $jenis_npwp = $obj->fields['JENIS_NPWP']; $bank = $obj->fields['KODE_BANK']; $jumlah_kpr = round($obj->fields['JUMLAH_KPR']); $tgl_akad = tgltgl(f_tgl($obj->fields['TANGGAL_AKAD'])); $status_kompensasi = $obj->fields['STATUS_KOMPENSASI']; $tanda_jadi = round($obj->fields['TANDA_JADI']); $status_spp = $obj->fields['STATUS_SPP']; $tgl_proses = tgltgl(f_tgl($obj->fields['TANGGAL_PROSES'])); $tgl_tanda_jadi = tgltgl(f_tgl($obj->fields['TANGGAL_TANDA_JADI'])); $redistribusi = $obj->fields['SPP_REDISTRIBUSI']; $tgl_redistribusi = tgltgl(f_tgl($obj->fields['SPP_REDISTRIBUSI_TANGGAL'])); $kelengkapan = $obj->fields['KELENGKAPAN']; $keterangan = $obj->fields['KETERANGAN']; $catatan_penagihan = $obj->fields['CATATAN_PENAGIHAN']; $pola_pembayaran = $obj->fields['POLA_PEMBAYARAN']; $harga_total = $obj->fields['HARGA_TOTAL']; $pola_bayar = $obj->fields['POLA_BAYAR']; //DATA RENCANA & REALISASI $luas_tanah = $obj->fields['LUAS_TANAH']; $luas_bangunan = $obj->fields['LUAS_BANGUNAN']; $tipe_bangunan = $obj->fields['TIPE_BANGUNAN']; $tanah = $luas_tanah * $obj->fields['HARGA_TANAH']; $disc_tanah = round($tanah * $obj->fields['DISC_TANAH'] / 100, 0); $nilai_tambah = round(($tanah - $disc_tanah) * $obj->fields['NILAI_TAMBAH'] / 100, 0); $nilai_kurang = round(($tanah - $disc_tanah) * $obj->fields['NILAI_KURANG'] / 100, 0); $faktor = $nilai_tambah - $nilai_kurang;
?>
">
<td class="text-center"><?php
echo $id;
?>
</td>
<td><?php
echo $obj->fields['NAMA_PEMBELI'];
?>
</td>
<td><?php
echo $obj->fields['ALAMAT_SURAT'];
?>
</td>
<td><?php
echo $TELP;
?>
</td>
<td class="text-center"><?php
echo tgltgl(date("d-m-Y", strtotime($obj->fields['TANGGAL_AKAD'])));
?>
</td>
</tr>
<?php
$obj->movenext();
}
?>
</table>
</body>
</html>
$bln = $pecah_tanggal[1];
$thn = $pecah_tanggal[2];
}
while ($iterasi <= $banyak) {
$query4 = "\n\t\tSELECT COUNT(*) AS TOTAL\n\t\tFROM REALISASI WHERE KODE_BLOK = '{$id}' AND TANGGAL >= CONVERT(DATETIME,'{$tgl}-{$bln}-{$thn}',105) \n\t\tAND TANGGAL <= CONVERT(DATETIME,'{$periode_akhir}',105) \n\t\t";
$obj4 = $conn->execute($query4);
$ada = $obj4->fields['TOTAL'];
if ($ada == 0) {
if ($iterasi == 1) {
$tgl = $tgl;
} else {
$tgl = 01;
}
$query3 = "\n\t\t\t\tSELECT top 1 *\n\t\t\t\tFROM RENCANA WHERE KODE_BLOK = '{$id}' AND TANGGAL >= CONVERT(DATETIME,'{$tgl}-{$bln}-{$thn}',105) AND TANGGAL <= CONVERT(DATETIME,'{$periode_akhir}',105) \n\t\t\t\t order by TANGGAL\n\t\t\t\t";
$obj3 = $conn->execute($query3);
$tanggal = tgltgl(date("d-m-Y", strtotime($obj3->fields['TANGGAL'])));
$nilai = $obj3->fields['NILAI'];
$nilai_rekap = $nilai_rekap + $nilai;
$tanggal_skg = f_tgl(date("Y-m-d"));
$time1 = strtotime($tanggal);
$time2 = strtotime($tanggal_skg);
$selisih = ($time2 - $time1) / (60 * 60 * 24);
if ($selisih <= 45) {
$nilai45_rekap = $nilai45_rekap + $nilai;
} else {
if ($selisih <= 60 && $selisih > 45) {
$nilai4560_rekap = $nilai4560_rekap + $nilai;
} else {
$nilai60_rekap = $nilai60_rekap + $nilai;
}
}
?>
">
<td><?php
echo $id;
?>
</td>
<td><?php
echo $obj->fields['NAMA_CALON_PEMBELI'];
?>
</td>
<td><?php
echo tgltgl(date("d-m-Y", strtotime($obj->fields['TANGGAL_RESERVE'])));
?>
</td>
<td><?php
echo tgltgl(date("d-m-Y", strtotime($obj->fields['BERLAKU_SAMPAI'])));
?>
</td>
<td><?php
echo $obj->fields['ALAMAT'];
?>
</td>
<td><?php
echo $obj->fields['TELEPON'];
?>
</td>
<td><?php
echo $obj->fields['AGEN'];
?>
</td>
<td><?php
?>
</td>
<td class="text-center"><?php
echo $id;
?>
</td>
<td><?php
echo $obj->fields['NAMA_PEMBELI'];
?>
</td>
<td class="text-center"><?php
echo kontgl(tgltgl(date("d M Y", strtotime($obj->fields['TANGGAL_SPP']))));
?>
</td>
<td class="text-center"><?php
echo kontgl(tgltgl(date("d M Y", strtotime($obj->fields['TANGGAL_MEMO']))));
?>
</td>
<td class="text-center"><?php
echo to_money($obj->fields['NILAI_TRANSAKSI']);
?>
</td>
<td class="text-center"><?php
echo to_money($obj->fields['TOTAL_PEMBAYARAN']);
?>
</td>
<td></td>
</tr>
<?php
$i++;
$obj->movenext();
?>
</td>
<td><?php
echo $id;
?>
</td>
<td><?php
echo $obj->fields['NAMA_CALON_PEMBELI'];
?>
</td>
<td><?php
echo tgltgl(f_tgl($obj->fields['TANGGAL_RESERVE']));
?>
</td>
<td><?php
echo tgltgl(f_tgl($obj->fields['BERLAKU_SAMPAI']));
?>
</td>
</tr>
<?php
$i++;
$obj->movenext();
}
?>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
$obj = $conn->Execute("\n\tSELECT \n\t\ts.NO_VA,\n\t\ts.KODE_BLOK,\n\t\ts.LUAS_BANGUNAN,\n\t\ts.STATUS_STOK,\n\t\ts.TERJUAL,\n\t\ts.KODE_PENJUALAN,\n\t\tt.TIPE_BANGUNAN,\n\t\ths.KODE_SK,\n\t\ths.HARGA_CASH_KERAS,\n\t\ths.CB36X,\n\t\ths.CB48X,\n\t\ths.KPA24X,\n\t\ths.KPA36X,\n\t\th.*,\n\t\tju.*,\n\t\tt.*,\n\t\tp.*\n\t\tFROM \n\t\tSTOK s\n\t\tLEFT JOIN TIPE t ON s.KODE_TIPE = t.KODE_TIPE\n\t\tLEFT JOIN HARGA_SK hs ON s.KODE_SK = hs.KODE_SK AND s.KODE_BLOK = hs.KODE_BLOK\n\t\tLEFT JOIN LOKASI h ON s.KODE_LOKASI = h.KODE_LOKASI\n\t\tLEFT JOIN JENIS_UNIT ju ON s.KODE_UNIT = ju.KODE_UNIT\n\t\tLEFT JOIN JENIS_PENJUALAN p ON s.KODE_PENJUALAN = p.KODE_JENIS\n\t\tWHERE\t\t\n\t\ts.KODE_BLOK = '{$id}'");
$no_va = $obj->fields['NO_VA'];
$kode_blok = $obj->fields['KODE_BLOK'];
$kode_lokasi = $obj->fields['KODE_LOKASI'];
$kode_unit = $obj->fields['KODE_UNIT'];
$kode_tipe = $obj->fields['KODE_TIPE'];
$kode_penjualan = $obj->fields['KODE_PENJUALAN'];
$kode_sk = $obj->fields['KODE_SK'];
$lokasi = $obj->fields['LOKASI'];
$jenis_unit = $obj->fields['JENIS_UNIT'];
$tipe_bangunan = $obj->fields['TIPE_BANGUNAN'];
$jenis_penjualan = $obj->fields['JENIS_PENJUALAN'];
$luas_bangunan = $obj->fields['LUAS_BANGUNAN'];
$harga_cash_keras = $obj->fields['HARGA_CASH_KERAS'];
$CB36X = $obj->fields['CB36X'];
$CB48X = $obj->fields['CB48X'];
$KPA24X = $obj->fields['KPA24X'];
$KPA36X = $obj->fields['KPA36X'];
}
if ($act == 'Reserve') {
$obj = $conn->Execute("SELECT BATAS_RESERVE FROM CS_PARAMETER_MARK");
$batas_reserve = $obj->fields['BATAS_RESERVE'];
$obj = $conn->Execute("SELECT GETDATE() AS TANGGAL_RESERVE, GETDATE()+{$batas_reserve} AS BERLAKU_SAMPAI");
$tanggal_reserve = tgltgl(date("d-m-Y", strtotime($obj->fields['TANGGAL_RESERVE'])));
$berlaku_sampai = tgltgl(date("d-m-Y", strtotime($obj->fields['BERLAKU_SAMPAI'])));
$obj = $conn->Execute("SELECT NO_VA FROM STOK where KODE_BLOK = '{$id}'");
$no_va = $obj->fields['NO_VA'];
if (!isset($no_va)) {
$no_va = '';
}
}
$tgl = $pecah_tanggal[2];
if ($bln + 1 > 12) {
$next_bln = $bln % 12;
$next_thn = $thn + 1;
} else {
$next_bln = $bln + 1;
$next_thn = $thn;
}
$query = "SELECT * FROM RENCANA WHERE KODE_BLOK = '{$id}'\n\t\t\tAND TANGGAL >= CONVERT(DATETIME,'01-{$bln}-{$thn}',105) \n\t\t\tAND TANGGAL < CONVERT(DATETIME,'01-{$next_bln}-{$next_thn}',105)";
$obj = $conn->execute($query);
$no_somasi1 = $obj->fields['NO_SURAT2'];
$tgl_somasi1 = kontgl(tgltgl(date("d M Y", strtotime($obj->fields['TANGGAL_SURAT2']))));
$no_somasi2 = $obj->fields['NO_SURAT3'];
$tgl_somasi2 = kontgl(tgltgl(date("d M Y", strtotime($obj->fields['TANGGAL_SURAT3']))));
$no_somasi3 = $obj->fields['NO_SURAT4'];
$tgl_somasi3 = kontgl(tgltgl(date("d M Y", strtotime($obj->fields['TANGGAL_SURAT4']))));
if ($status == 2) {
$query = "update CS_REGISTER_CUSTOMER_SERVICE set NOMOR_SURAT_TUNAI = NOMOR_SURAT_TUNAI + 1";
ex_false($conn->execute($query), $query);
} else {
if ($status == 1) {
$query = "update CS_REGISTER_CUSTOMER_SERVICE set NOMOR_SURAT_KPR = NOMOR_SURAT_KPR + 1";
ex_false($conn->execute($query), $query);
}
}
$query = "update RENCANA set NO_SURAT5 = '{$nomor_surat}', TANGGAL_SURAT5 = CONVERT(DATETIME,GETDATE(),105) \n\t\t\tWHERE KODE_BLOK = '{$id}'\n\t\t\tAND TANGGAL >= CONVERT(DATETIME,'01-{$bln}-{$thn}',105) \n\t\t\tAND TANGGAL < CONVERT(DATETIME,'01-{$next_bln}-{$next_thn}',105)";
ex_false($conn->execute($query), $query);
$query = "update SPP set STATUS_WANPRESTASI = 1 \n\t\t\tWHERE KODE_BLOK = '{$id}' ";
ex_false($conn->execute($query), $query);
// Create a new PHPWord Object
$PHPWord = new PHPWord();
$tanggal_surat = substr($tanggal_tempo, 0, 10);
$pecah_tanggal = explode("-", $tanggal_surat);
$thn = $pecah_tanggal[0];
$bln = $pecah_tanggal[1];
$tgl = $pecah_tanggal[2];
if ($bln + 1 > 12) {
$next_bln = $bln % 12;
$next_thn = $thn + 1;
} else {
$next_bln = $bln + 1;
$next_thn = $thn;
}
$query = "SELECT * FROM RENCANA WHERE KODE_BLOK = '{$id}'\n\t\t\tAND TANGGAL >= CONVERT(DATETIME,'01-{$bln}-{$thn}',105) \n\t\t\tAND TANGGAL < CONVERT(DATETIME,'01-{$next_bln}-{$next_thn}',105)";
$obj = $conn->execute($query);
$nomor_surat_dahulu = $obj->fields['NO_SURAT3'];
$tanggal_surat_dahulu = kontgl(tgltgl(date("d M Y", strtotime($obj->fields['TANGGAL_SURAT3']))));
if ($status == 2) {
$query = "update CS_REGISTER_CUSTOMER_SERVICE set NOMOR_SURAT_TUNAI = NOMOR_SURAT_TUNAI + 1";
ex_false($conn->execute($query), $query);
} else {
if ($status == 1) {
$query = "update CS_REGISTER_CUSTOMER_SERVICE set NOMOR_SURAT_KPR = NOMOR_SURAT_KPR + 1";
ex_false($conn->execute($query), $query);
}
}
$query = "update RENCANA set NO_SURAT4 = '{$nomor_surat}', TANGGAL_SURAT4 = CONVERT(DATETIME,GETDATE(),105) \n\t\t\tWHERE KODE_BLOK = '{$id}'\n\t\t\tAND TANGGAL >= CONVERT(DATETIME,'01-{$bln}-{$thn}',105) \n\t\t\tAND TANGGAL < CONVERT(DATETIME,'01-{$next_bln}-{$next_thn}',105)";
ex_false($conn->execute($query), $query);
// Create a new PHPWord Object
$PHPWord = new PHPWord();
$document = $PHPWord->loadTemplate('../../../../../surat/Surat_Somasi_3.docx');
//header
$tanggal_spp = kontgl(tgltgl(date("d M Y", strtotime($obj->fields['TANGGAL_SPP']))));
$no_identitas = $obj->fields['NO_IDENTITAS'];
$npwp = $obj->fields['NPWP'];
$luas_tanah = $obj->fields['LUAS_TANAH'];
$luas_bangunan = $obj->fields['LUAS_BANGUNAN'];
$nomor_customer = $obj->fields['NOMOR_CUSTOMER'];
$tanah = $luas_tanah * $obj->fields['HARGA_TANAH'];
$disc_tanah = round($tanah * $obj->fields['DISC_TANAH'] / 100, 0);
$nilai_tambah = round(($tanah - $disc_tanah) * $obj->fields['NILAI_TAMBAH'] / 100, 0);
$nilai_kurang = round(($tanah - $disc_tanah) * $obj->fields['NILAI_KURANG'] / 100, 0);
$faktor = $nilai_tambah - $nilai_kurang;
$total_tanah = $tanah - $disc_tanah + $faktor;
$ppn_tanah = round($total_tanah * $obj->fields['PPN_TANAH'] / 100, 0);
$bangunan = $luas_bangunan * $obj->fields['HARGA_BANGUNAN'];
$disc_bangunan = round($bangunan * $obj->fields['DISC_BANGUNAN'] / 100, 0);
$total_bangunan = $bangunan - $disc_bangunan;
$ppn_bangunan = round($total_bangunan * $obj->fields['PPN_BANGUNAN'] / 100, 0);
$total_harga = to_money($total_tanah + $total_bangunan);
$total_ppn = to_money($ppn_tanah + $ppn_bangunan);
$sisa_pembayaran = $total_tanah + $total_bangunan + ($ppn_tanah + $ppn_bangunan);
$tanda_jadi = $obj->fields['TANDA_JADI'];
$tgl_jadi = $obj->fields['TANGGAL_TANDA_JADI'];
$jml_kpr = $obj->fields['JUMLAH_KPR'];
$query2 = "\n\t\tSELECT * FROM PEMBAYARAN WHERE NOMOR_VA = '{$nomor_customer}' AND STATUS = '0'\n\t";
$obj2 = $conn->execute($query2);
$nomor_va = $obj2->fields['NOMOR_VA'];
$nilai = $obj2->fields['NILAI'];
$tanggal_bayar = tgltgl(date("d-m-Y", strtotime($obj2->fields['TANGGAL'])));
$tanggal = f_tgl(date("Y-m-d"));
$catatan = '';
}
?>
</td>
<td><?php
echo $obj->fields['NAMA_PEMBELI'];
?>
</td>
<td><?php
echo sistem_pembayaran($obj->fields['STATUS_KOMPENSASI']);
?>
</td>
<td><?php
echo tgltgl(date("d-m-Y", strtotime($obj->fields['TANGGAL_SPP'])));
?>
</td>
<td><?php
echo tgltgl(date("d-m-Y", strtotime($obj->fields['TANGGAL_TANDA_JADI'])));
?>
</td>
</tr>
<?php
if ($i % $per_page === 0) {
echo '<tr><td class="nb"><div class="newpage"></div></td></tr>';
th_print();
}
$i++;
$obj->movenext();
}
echo $set_ttd;
}
?>
$from_query .= " FROM CS_JENIS_PPJB ";
$status .= " STATUS_CETAK ";
}
}
// query data pembeli
$query = "\n\tSELECT *\n\tFROM\n\tCS_PARAMETER_PPJB";
$obj = $conn->execute($query);
//DATA PEMBELI
$NAMA_PT = $obj->fields['NAMA_PT'];
$NAMA_DEP = $obj->fields['NAMA_DEP'];
$NAMA_PEJABAT = $obj->fields['NAMA_PEJABAT'];
$NAMA_JABATAN = $obj->fields['NAMA_JABATAN'];
$PEJABAT_PPJB = $obj->fields['PEJABAT_PPJB'];
$JABATAN_PPJB = $obj->fields['JABATAN_PPJB'];
$NOMOR_SK = $obj->fields['NOMOR_SK'];
$TANGGAL_SK = tgltgl(date("d-m-Y", strtotime($obj->fields['TANGGAL_SK'])));
//query JENIS PPJB
$query = "\n\tSELECT KODE_JENIS\n\t,NAMA_JENIS\n\t,NAMA_FILE\n\t{$from_query}\n\tWHERE KODE_JENIS = '{$kode_jenis_ppjb}'\n\t";
$obj = $conn->execute($query);
//DATA JENIS PPJB
$KODE_JENIS = $obj->fields['KODE_JENIS'];
$NAMA_JENIS = $obj->fields['NAMA_JENIS'];
$NAMA_FILE = $obj->fields['NAMA_FILE'];
//query update status cetak PPJB
$query2 = "\n\tUPDATE CS_PPJB SET {$status}='1' WHERE KODE_BLOK='{$id}';\n\t";
$obj = $conn->execute($query2);
//Format Tanggal Berbahasa Indonesia
// Array Hari
$array_hari = array(1 => 'Senin', 'Selasa', 'Rabu', 'Kamis', 'Jumat', 'Sabtu', 'Minggu');
$hari = $array_hari[date('N')];
//Format Tanggal
require_once '../../../../../config/config.php';
require_once '../../../../../config/terbilang.php';
die_login();
//die_app('');
//die_mod('');
$conn = conn($sess_db);
die_conn($conn);
$terbilang = new Terbilang();
$id = isset($_REQUEST['id']) ? base64_decode(clean($_REQUEST['id'])) : '';
$catatan_kwt = isset($_REQUEST['catatan_kwt']) ? clean($_REQUEST['catatan_kwt']) : '';
$query = "\n\tSELECT * \n\tFROM KWITANSI_LAIN_LAIN\n\tWHERE NOMOR_KWITANSI = '{$id}'\n";
$obj = $conn->execute($query);
$nama_pembayar = $obj->fields['NAMA_PEMBAYAR'];
$keterangan = $obj->fields['KETERANGAN'];
$nilai = $obj->fields['NILAI'];
$tanggal = kontgl(tgltgl(date("d M Y", strtotime($obj->fields['TANGGAL']))));
$query = "\n\t\tUPDATE KWITANSI_LAIN_LAIN SET \n\t\t\tSTATUS_KWT = '1',\n\t\t\tCATATAN_KWT = '{$catatan_kwt}'\n\t\tWHERE NOMOR_KWITANSI = '{$id}'\n\t\t";
ex_false($conn->Execute($query), $query);
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<style type="text/css">
@page {
size: A4;
margin: 0;
}
@media screen, print{
body {
echo json_encode($json);
exit;
}
die_login();
// die_app('C');
die_mod('C03');
$conn = conn($sess_db);
die_conn($conn);
if ($act == 'Detail') {
$query = "\n\tSELECT *\n\tFROM\n\t\tSPP a \n\t\tLEFT JOIN STOK b ON a.KODE_BLOK = b.KODE_BLOK\n\t\tLEFT JOIN TIPE c ON b.KODE_TIPE = c.KODE_TIPE\n\t\tLEFT JOIN HARGA_TANAH d ON b.KODE_SK_TANAH = d.KODE_SK\n\t\tLEFT JOIN HARGA_BANGUNAN e ON b.KODE_SK_BANGUNAN = e.KODE_SK\n\t\tLEFT JOIN FAKTOR f ON b.KODE_FAKTOR = f.KODE_FAKTOR\n\tWHERE \n\t\ta.KODE_BLOK = '{$id}'";
$obj = $conn->execute($query);
$kode_blok = $obj->fields['KODE_BLOK'];
$nama_pembeli = $obj->fields['NAMA_PEMBELI'];
$alamat = $obj->fields['ALAMAT_RUMAH'];
$tlp1 = $obj->fields['TELP_RUMAH'];
$tanggal_spp = kontgl(tgltgl(date("d M Y", strtotime($obj->fields['TANGGAL_SPP']))));
$no_identitas = $obj->fields['NO_IDENTITAS'];
$npwp = $obj->fields['NPWP'];
$luas_tanah = $obj->fields['LUAS_TANAH'];
$luas_bangunan = $obj->fields['LUAS_BANGUNAN'];
$nomor_customer = $obj->fields['NOMOR_CUSTOMER'];
$tanah = $luas_tanah * $obj->fields['HARGA_TANAH'];
$disc_tanah = round($tanah * $obj->fields['DISC_TANAH'] / 100, 0);
$nilai_tambah = round(($tanah - $disc_tanah) * $obj->fields['NILAI_TAMBAH'] / 100, 0);
$nilai_kurang = round(($tanah - $disc_tanah) * $obj->fields['NILAI_KURANG'] / 100, 0);
$faktor = $nilai_tambah - $nilai_kurang;
$total_tanah = $tanah - $disc_tanah + $faktor;
$ppn_tanah = round($total_tanah * $obj->fields['PPN_TANAH'] / 100, 0);
$bangunan = $luas_bangunan * $obj->fields['HARGA_BANGUNAN'];
$disc_bangunan = round($bangunan * $obj->fields['DISC_BANGUNAN'] / 100, 0);
$total_bangunan = $bangunan - $disc_bangunan;
$tgl_jadi = $obj->fields['TANGGAL_TANDA_JADI'];
$jml_kpr = $obj->fields['JUMLAH_KPR'];
$no_spp = $obj->fields['NOMOR_SPP'];
}
if ($act == 'Ubah') {
$query = "SELECT COUNT(*)+1 AS COUNT_RENCANA FROM RENCANA R JOIN KWITANSI K ON R.KODE_BLOK = K.KODE_BLOK WHERE R.KODE_BLOK = '{$id}' AND MONTH(K.TANGGAL) = MONTH(R.TANGGAL) AND YEAR(K.TANGGAL) = YEAR(R.TANGGAL) AND K.KODE_BAYAR = '4'";
$count_rencana = $conn->Execute($query)->fields['COUNT_RENCANA'];
$query = "\n\t\tSELECT * FROM KWITANSI a\n\t\tLEFT JOIN STOK b ON a.KODE_BLOK = b.KODE_BLOK\n\t\tLEFT JOIN LOKASI c ON b.KODE_LOKASI = c.KODE_LOKASI\t\t\n\t\tLEFT JOIN TIPE d ON b.KODE_TIPE = d.KODE_TIPE\n\t\tLEFT JOIN JENIS_PEMBAYARAN e ON a.KODE_BAYAR = e.KODE_BAYAR\n\t\tWHERE NOMOR_KWITANSI = '{$id}'\n\t";
$obj = $conn->execute($query);
$nomor = $obj->fields['NOMOR_KWITANSI'];
$nama_pembayar = $obj->fields['NAMA_PEMBAYAR'];
$keterangan = $obj->fields['KETERANGAN'];
$jumlah = round($obj->fields['NILAI']);
$diposting = $obj->fields['NILAI_DIPOSTING'];
$tanggal = tgltgl(date("d-m-Y", strtotime($obj->fields['TANGGAL'])));
$tgl_terima = tgltgl(date("d-m-Y", strtotime($obj->fields['TANGGAL_BAYAR'])));
$via = $obj->fields['BAYAR_VIA'];
$catatan = $obj->fields['CATATAN'];
$catatan_kwt = $obj->fields['CATATAN_KWT'];
$biro = $obj->fields['VER_COLLECTION'];
$keuangan = $obj->fields['VER_KEUANGAN'];
$pindah = $obj->fields['STATUS_PINDAH_BLOK'];
$posting = $obj->fields['STATUS_POSTING'];
$jenis_bayar = $obj->fields['JENIS_BAYAR'];
if ($jenis_bayar == NULL) {
$jenis_pembayaran = 'JENIS_BAYAR';
$kode_bayar = 0;
} else {
$jenis_pembayaran = $jenis_bayar;
$kode_bayar = $obj->fields['KODE_BAYAR'];
}
?>
</td>
<td><?php
echo $obj->fields['NO_VA_PH'];
?>
</td>
<td><?php
echo $obj->fields['KODE_BLOK'];
?>
</td>
<td><?php
echo $obj->fields['PIHAK_PERTAMA'];
?>
</td>
<td><?php
echo tgltgl(f_tgl($obj->fields['TANGGAL']));
?>
</td>
</tr>
<?php
$obj->movenext();
}
}
?>
</table>
<table id="pagging-2" class="t-control w60"></table>
<script type="text/javascript">
jQuery(function($) {
$('#pagging-2').html($('#pagging-1').html());
<?php
$query = "\n\t\t\t\tSELECT K.TANGGAL, R.NILAI, K.NOMOR_KWITANSI,K.VER_KEUANGAN AS KEU, K.BAYAR_VIA AS KETERANGAN, K.VER_COLLECTION_TANGGAL, K.VER_KEUANGAN_TANGGAL from REALISASI R JOIN KWITANSI K ON R.KODE_BLOK = K.KODE_BLOK \n\t\t\t\tWHERE K.KODE_BLOK = '{$kode_blok}' AND K.KODE_BLOK = R.KODE_BLOK AND K.NOMOR_KWITANSI = R.NOMOR_KWITANSI\n\t\t\t\tORDER BY TANGGAL\n\t\t\t\t";
$obj = $conn->execute($query);
$i = 1;
$nilai = 0;
while (!$obj->EOF) {
$bayar_via = array('1' => "Tunai", '2' => "Giro / Cek", '3' => "Bank O", '4' => "Lain", '5' => "Virtual Account");
$keterangan = $bayar_via[$obj->fields['KETERANGAN']];
?>
<tr>
<td><?php
echo $obj->fields['NOMOR_KWITANSI'];
?>
</td>
<td><?php
echo tgltgl(date("d M Y", strtotime($obj->fields['TANGGAL'])));
?>
</td>
<td class="text-right"><?php
echo to_money($obj->fields['NILAI']);
?>
</td>
</tr>
<?php
$obj->movenext();
}
?>
</table>
<div class="clear"><br></div>
<!-- REALISASI -->
?>
</td>
<td><?php
echo $obj->fields['COL'];
?>
</td>
<td><?php
echo tgltgl(date("d-m-Y", strtotime($obj->fields['VER_COLLECTION_TANGGAL'])));
?>
</td>
<td><?php
echo $obj->fields['KEU'];
?>
</td>
<td><?php
echo tgltgl(date("d-m-Y", strtotime($obj->fields['VER_KEUANGAN_TANGGAL'])));
?>
</td>
<td class="text-center"><?php
echo $obj->fields['CATATAN'];
?>
</td>
</tr>
<?php
$i++;
$obj->movenext();
}
$query = "\n\tSELECT SUM(NILAI) AS TOTAL FROM KWITANSI WHERE KODE_BLOK = '{$kode_blok}'\n\t";
$obj = $conn->execute($query);
?>
<tr>
$kode = $obj->fields['KODE_BLOK'];
$no_va_ph = $obj->fields['NO_VA_PH'];
$nomor = $obj->fields['NO_PPJB_AWAL'];
$tanggal_awal = f_tgl($obj->fields['TANGGAL_PPJB_AWAL']);
$harga_awal = $obj->fields['HARGA_AWAL'];
$pihak_pertama = $obj->fields['PIHAK_PERTAMA'];
$no_id = $obj->fields['NO_ID_PIHAK_PERTAMA'];
$npwp = $obj->fields['NPWP'];
$alamat = $obj->fields['ALAMAT_PIHAK_PERTAMA'];
$tlp1 = $obj->fields['NO_TELP_PIHAK_PERTAMA'];
$tlp3 = $obj->fields['NO_HP_PIHAK_PERTAMA'];
$email = $obj->fields['EMAIL_PIHAK_PERTAMA'];
$suami_istri = $obj->fields['SUAMI_ISTRI'];
$no_fax = $obj->fields['NO_FAX_PIHAK_PERTAMA'];
$no_ppjb_hak = $obj->fields['NO_PPJB_PH'];
$tanggal = tgltgl(f_tgl($obj->fields['TANGGAL']));
$tanggal_permohonan = tgltgl(f_tgl($obj->fields['TANGGAL_PERMOHONAN']));
$tanggal_persetujuan = tgltgl(f_tgl($obj->fields['TANGGAL_PERSETUJUAN']));
$harga_hak = $obj->fields['HARGA_PENGALIHAN_HAK'];
$biaya = $obj->fields['BIAYA_PENGALIHAN_HAK'];
$masa_bangun = $obj->fields['MASA_BANGUN'];
$keterangan = $obj->fields['KETERANGAN'];
$pihak_kedua = $obj->fields['PIHAK_KEDUA'];
$no_id_hak = $obj->fields['NO_ID_PIHAK_KEDUA'];
$alamat_hak = $obj->fields['ALAMAT_PIHAK_KEDUA'];
$tlp1_hak = $obj->fields['NO_TELP_PIHAK_KEDUA'];
$tlp3_hak = $obj->fields['NO_HP_PIHAK_KEDUA'];
$email_hak = $obj->fields['EMAIL_PIHAK_KEDUA'];
$suami_istri_hak = $obj->fields['NAMA_SUAMI_ISTRI'];
$no_fax_hak = $obj->fields['NO_FAX_PIHAK_KEDUA'];
}
} else {
$error = TRUE;
}
}
$msg = $error ? 'Sebagian data gagal dihapus.' : 'Data hari libur berhasil dihapus.';
}
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$conn->rollbacktrans();
}
}
close($conn);
$json = array('act' => $act, 'error' => $error, 'msg' => $msg);
echo json_encode($json);
exit;
}
die_login();
// die_app('C');
die_mod('C02');
$conn = conn($sess_db);
die_conn($conn);
if ($act == 'Ubah') {
$query = "SELECT * FROM CS_HARI_LIBUR WHERE TANGGAL_AWAL = CONVERT(DATETIME,'{$id}',105)";
$obj = $conn->execute($query);
$tanggal_awal = tgltgl(date("d-m-Y", strtotime($obj->fields['TANGGAL_AWAL'])));
$tanggal_akhir = tgltgl(date("d-m-Y", strtotime($obj->fields['TANGGAL_AKHIR'])));
$keterangan = $obj->fields['KETERANGAN'];
}
require_once '../../../../../config/config.php';
die_login();
// die_app('C');
die_mod('C37');
$conn = conn($sess_db);
die_conn($conn);
$query = "SELECT * FROM CS_PARAMETER_COL";
$obj = $conn->Execute($query);
?>
<table class="t-popup pad wauto">
<tr class="input_label">
<tr>
<td>Tanggal Efektif Program (Cut Off) </td>
<td><input class="text-right" type="text" name="tanggal_efektif_prog" id="tanggal_efektif_prog" size="15" class="apply dd-mm-yyyy" value="<?php
echo tgltgl(date("d-m-Y", strtotime($obj->fields['TANGGAL_EFEKTIF_PROG'])));
?>
"></td></td>
</tr>
<tr>
<td>Nilai Sisa Tagihan dianggap Lunas s/d </td>
<td><input type="text" class="text-right" name="nilai_sisa_tagihan" id="nilai_sisa_tagihan" size="10" value="<?php
echo to_money($obj->fields['NILAI_SISA_TAGIHAN']);
?>
"></td></td>
</tr>
<tr>
<td>Masa Berlaku Denda </td>
<td><input type="text" class="text-right" name="masa_berlaku_denda" id="masa_berlaku_denda" size="10" value="<?php
echo $obj->fields['MASA_BERLAKU_DENDA'];
?>
?>
</td>
<td class="text-center"><?php
echo $no_va;
?>
</td>
<td><?php
echo $obj->fields['NAMA_PEMBELI'];
?>
</td>
<td class="text-center"><?php
echo tgltgl(date("d-m-Y", strtotime($obj->fields['TANGGAL_SPP'])));
?>
</td>
<td class="text-center"><?php
echo tgltgl(date("d-m-Y", strtotime($obj->fields['TGL_BATAS'])));
?>
</td>
<td class="text-center"><?php
echo $hari;
?>
</td>
<td><?php
echo $obj->fields['ALAMAT_RUMAH'];
?>
</td>
</tr>
<?php
$obj->movenext();
}
}
?>
</td>
<td><?php
echo $obj->fields['NAMA_PEMBELI'];
?>
</td>
<td><?php
echo $obj->fields['ALAMAT_SURAT'];
?>
</td>
<td><?php
echo $TELP;
?>
</td>
<td class="text-center"><?php
echo tgltgl(date("d-m-Y", strtotime($obj->fields['TGL_SRT_PERUBAHAN_PLAFON'])));
?>
</td>
</tr>
<?php
$obj->movenext();
}
}
?>
</table>
<table id="pagging-2" class="t-control "></table>
<script type="text/javascript">
jQuery(function($) {
$('#pagging-2').html($('#pagging-1').html());
$kode_unit = $obj->fields['KODE_UNIT']; $kode_sk_tanah = $obj->fields['KODE_SK_TANAH']; $kode_faktor = $obj->fields['KODE_FAKTOR']; $kode_tipe = $obj->fields['KODE_TIPE']; $kode_sk_bangunan = $obj->fields['KODE_SK_BANGUNAN']; $kode_penjualan = $obj->fields['KODE_PENJUALAN']; $nama_desa = $obj->fields['NAMA_DESA']; $lokasi = $obj->fields['LOKASI']; $jenis_unit = $obj->fields['JENIS_UNIT']; $harga_tanah_sk = $obj->fields['HARGA_TANAH_SK']; $faktor_strategis = $obj->fields['FAKTOR_STRATEGIS']; $tipe_bangunan = $obj->fields['TIPE_BANGUNAN']; $harga_bangunan_sk = $obj->fields['HARGA_BANGUNAN_SK']; $jenis_penjualan = $obj->fields['JENIS_PENJUALAN']; $tgl_bangunan = tgltgl(f_tgl($obj->fields['TGL_BANGUNAN'])); $tgl_selesai = tgltgl(f_tgl($obj->fields['TGL_SELESAI'])); $progress = $obj->fields['PROGRESS']; $class = $obj->fields['CLASS']; $status_gambar_siteplan = $obj->fields['STATUS_GAMBAR_SITEPLAN']; $status_gambar_lapangan = $obj->fields['STATUS_GAMBAR_LAPANGAN']; $status_gambar_gs = $obj->fields['STATUS_GAMBAR_GS']; $program = $obj->fields['PROGRAM']; $luas_tanah = $obj->fields['LUAS_TANAH']; $base_harga_tanah = $obj->fields['BASE_HARGA_TANAH']; $nilai_tambah = $obj->fields['NILAI_TAMBAH']; $nilai_kurang = $obj->fields['NILAI_KURANG']; $fs_harga_tanah = $obj->fields['FS_HARGA_TANAH']; $disc_tanah = $obj->fields['DISC_TANAH']; $disc_harga_tanah = $obj->fields['DISC_HARGA_TANAH']; $ppn_tanah = $obj->fields['PPN_TANAH']; $ppn_harga_tanah = $obj->fields['PPN_HARGA_TANAH'];
$tgl = $obj->fields['TANGGAL'];
?>
<tr class="onclick" id="<?php
echo $id;
?>
">
<td class="text-center"><?php
echo $i;
?>
</td>
<td class="text-center"><?php
echo $id;
?>
</td>
<td><?php
echo tgltgl(date("d-m-Y", strtotime($obj->fields['TANGGAL_OTORISASI'])));
?>
</td>
<td><?php
echo $obj->fields['HARI_TUNGGAKAN'];
?>
</td>
<td class="text-center"><?php
echo to_money($obj->fields['NILAI']);
?>
</td>
<td><?php
echo to_money($obj->fields['DENDA']);
?>
</td>
<td><?php
?>
</td>
<td class="text-center"><?php
echo number_format($total_harga);
?>
</td>
<td class="text-center"><?php
echo number_format($total_ppn);
?>
</td>
<td class="text-center"><?php
echo number_format($uang_pesanan);
?>
</td>
<td class="text-center"><?php
echo kontgl(tgltgl(date("d M Y", strtotime($tgl_rencana))));
?>
</td>
<td class="text-center"><?php
echo number_format($nilai);
?>
</td>
</tr>
<?php
if ($i % $per_page === 0) {
echo '<tr><td class="nb"><div class="newpage"></div></td></tr>';
th_print();
}
$i++;
$obj->movenext();
}
?>
</td>
<td><?php
echo $obj->fields['NAMA_PEMBELI'];
?>
</td>
<td><?php
echo $obj->fields['ALAMAT_SURAT'];
?>
</td>
<td><?php
echo $TELP;
?>
</td>
<td class="text-center"><?php
echo tgltgl(date("d-m-Y", strtotime($obj->fields['TGL_SRT_PEMBERITAHUAN_SPK_TLK'])));
?>
</td>
</tr>
<?php
$obj->movenext();
}
}
?>
</table>
<table id="pagging-2" class="t-control "></table>
<script type="text/javascript">
jQuery(function($) {
$('#pagging-2').html($('#pagging-1').html());
require_once '../../../../../config/config.php';
require_once '../../../../../config/terbilang.php';
die_login();
//die_app('');
//die_mod('');
$conn = conn($sess_db);
die_conn($conn);
$terbilang = new Terbilang();
$id = isset($_REQUEST['id']) ? base64_decode(clean($_REQUEST['id'])) : '';
$query = "\n\tSELECT * \n\tFROM KWITANSI\n\tWHERE NOMOR_KWITANSI = '{$id}'\n";
$obj = $conn->execute($query);
$nama_pembayar = $obj->fields['NAMA_PEMBAYAR'];
$keterangan = $obj->fields['KETERANGAN'];
$nilai = to_money($obj->fields['NILAI']);
$tanggal = tgltgl(f_tgl($obj->fields['TANGGAL']));
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<style type="text/css">
@page {
size: A4;
margin: 0;
}
@media screen, print{
body {
font-family: verdana,sans-serif;
font-size: 14px;
// die_app('C');
die_mod('C06');
$conn = conn($sess_db);
die_conn($conn);
if ($act == 'Detail') {
$query = "\n\t\tSELECT NOMOR_MEMO, MAX(TANGGAL_MEMO) AS TGL_MEMO FROM\n\t\tCS_MEMO_PEMBATALAN\n\t\tWHERE NOMOR_MEMO = '{$id}'\n\t\tGROUP BY NOMOR_MEMO\n\t";
$obj = $conn->execute($query);
$nomor_memo = $obj->fields['NOMOR_MEMO'];
$tanggal_memo = kontgl(tgltgl(date("d M Y", strtotime($obj->fields['TGL_MEMO']))));
}
if ($act == 'Ubah') {
$query = "\n\t\tSELECT * FROM CS_MEMO_PEMBATALAN WHERE NOMOR_MEMO = '{$id}'\n\t";
$obj = $conn->execute($query);
$nomor_memo = $obj->fields['NOMOR_MEMO'];
$tanggal_memo = $obj->fields['TANGGAL_MEMO'];
}
if ($act == 'TambahMemo') {
$query = "\n\t\tSELECT MAX(NOMOR_MEMO) AS NO_MEMO FROM CS_MEMO_PEMBATALAN\n\t";
$obj = $conn->execute($query);
$kode_blok = '';
$nomor_memo = 1 + $obj->fields['NO_MEMO'];
$tanggal_memo = kontgl(tgltgl(date("d M Y")));
$id = $nomor_memo;
}
if ($act == 'Tambah') {
$query = "\n\t\tSELECT MAX(NOMOR_MEMO) AS NO_MEMO FROM CS_MEMO_PEMBATALAN\n\t";
$obj = $conn->execute($query);
$kode_blok = '';
$tanggal_memo = kontgl(tgltgl(date("d M Y")));
$id = $nomor_memo;
}
