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