$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'];
$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> <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>
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; } } $isi_data++; } $bln++;
$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 a LEFT JOIN BANK b on a.KODE_BANK = b.KODE_BANK WHERE NOMOR_VA = '{$nomor_customer}' AND STATUS = '0' AND MONTH(TANGGAL) = {$bln} AND YEAR(TANGGAL) = {$thn}\n\t"; $obj2 = $conn->execute($query2); $nomor_va = $obj2->fields['NOMOR_VA']; $nilai = $obj2->fields['NILAI']; $nama_bank = $obj2->fields['NAMA_BANK']; $kode_bank = $obj2->fields['KODE_BANK']; $tanggal = f_tgl(date("Y-m-d")); $catatan = ''; }
?> </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());
?> <tr class="onclick" data-kode_blok="<?php echo $obj->fields['KODE_BLOK']; ?> " data-no_va="<?php echo $obj->fields['NOMOR_CUSTOMER']; ?> " data-nomor="<?php echo $obj->fields['NOMOR']; ?> " data-tanggal="<?php echo f_tgl($obj->fields['TANGGAL']); ?> " data-nama="<?php echo $obj->fields['NAMA_PEMBELI']; ?> " data-no_identitas="<?php echo $obj->fields['NO_IDENTITAS']; ?> " data-alamat="<?php echo $obj->fields['ALAMAT_RUMAH']; ?> " data-tlp_rmh="<?php
<td><input type="text" name="alamat" id="alamat" size="80" value="<?php echo $obj->fields['ALAMAT']; ?> "></td> </tr> <tr> <td>NPWP</td><td>:</td> <td><input type="text" name="npwp" id="npwp" size="20" value="<?php echo $obj->fields['NPWP']; ?> "></td> </tr> <tr> <td>Tgl PKP</td><td>:</td> <td><input type="text" name="tanggal" id="tanggal" size="15" class="apply dd-mm-yyyy" value="<?php echo tgltgl(f_tgl($obj->fields['TGL_PKP'])); ?> "></td> </tr> <tr> <td class="td-action" colspan="3"><br> <input type="hidden" id="act" name = 'act'> <input type="submit" id="ubah1" value=" Simpan "> <input type="reset" id="reset" value=" Reset "> </td> </tr> </table> <?php close($conn); exit;
?> </td> <td><?php echo $id; ?> </td> <td><?php echo $obj->fields['NAMA_PEMBELI']; ?> </td> <td><?php echo to_money($jumlah); ?> </td> <td><?php echo f_tgl($obj->fields['TANGGAL_SPP']); ?> </td> </tr> <?php $i++; $obj->movenext(); } } ?> </table> <table id="pagging-2" class="t-control w60"></table> <script type="text/javascript"> jQuery(function($) {
$keuangan = 0; $pindah = 0; $posting = 0; $jumlah_awal = 0; $jenis_pembayaran = 0; $kode_bayar = 0; $kode_lain = 5; $luas_bangunan = $obj->fields['LUAS_BANGUNAN']; $lokasi = $obj->fields['LOKASI']; $kode_blok = $obj->fields['KODE_BLOK']; $tipe = $obj->fields['TIPE_BANGUNAN']; $nomor_customer = $obj->fields['NOMOR_CUSTOMER']; $query = "\n\t\tSELECT MAX(TANGGAL) AS MAX_TGL FROM CS_VIRTUAL_ACCOUNT WHERE NOMOR_VA = '{$nomor_customer}'\n\t"; $obj = $conn->execute($query); $max_tgl = $obj->fields['MAX_TGL']; $tanggal_rencana = f_tgl(date("Y-m-d")); $pecah_tanggal = explode("-", $tanggal_rencana); $tgl = $pecah_tanggal[0]; $bln = $pecah_tanggal[1]; $thn = $pecah_tanggal[2]; $bulan_depan = $bln + 1; $tahun_depan = $thn; if ($bulan_depan > 12) { $bulan_depan = $bulan_depan % 12; $tahun_depan = $thn + 1; } $query = "\n\tselect count(*) as TOTAL_ANGSURAN from kwitansi where kode_blok = '{$id}' \n\t"; $obj = $conn->execute($query); $angsuran_ke = 1 + $obj->fields['TOTAL_ANGSURAN']; $query = "\n\tselect * from TAGIHAN_LAIN_LAIN where kode_bayar = '9' and kode_blok = '{$id}'\n\tAND STATUS_BAYAR = 0;\n\t"; $obj = $conn->execute($query);
<td><input readonly="readonly" type="text" name="blok_asal" id="blok_asal" size="10" value="<?php echo $id; ?> "></td> </tr> <tr> <td>Nama Pemilik</td><td>:</td> <td><input readonly="readonly" type="text" name="nama" id="nama" size="30" value="<?php echo $nama; ?> "></td> </tr> <tr> <td>Tanggal SPP</td><td>:</td> <td><input readonly="readonly" type="text" name="tanggal_spp" id="tanggal_spp" size="15" value="<?php echo f_tgl($tanggal); ?> "></td> </tr> <tr> <td>Blok Baru</td><td>:</td> <td> <select name="blok_baru" id="blok_baru"> <option value=""> -- Blok Baru -- </option> <?php $query = "SELECT * FROM SPP WHERE KODE_BLOK = '{$id}'"; $obj = $conn->execute($query); $nama_pembeli = $obj->fields['NAMA_PEMBELI']; $obj = $conn->execute("\n\t\t\tSELECT * \n\t\t\tFROM SPP \n\t\t\tWHERE NAMA_PEMBELI = '{$nama_pembeli}' \n\t\t\tAND KODE_BLOK <> '{$id}'\n\t\t\tAND KODE_BLOK NOT IN (SELECT DISTINCT KODE_BLOK FROM KWITANSI WHERE NAMA_PEMBAYAR = '{$nama_pembeli}') \n\t\t\tORDER BY TANGGAL_SPP DESC\n\t\t"); while (!$obj->EOF) { $ov = $obj->fields['KODE_BLOK'];
$r_tipe_bangunan = $obj->fields['TIPE_BANGUNAN']; $r_harga_bangunan_sk = $obj->fields['HARGA_BANGUNAN_SK']; $r_jenis_penjualan = $obj->fields['JENIS_PENJUALAN']; $NO_FAX = $obj->fields['NO_FAX']; $tgl_lahir = tgltgl(f_tgl($obj->fields['TANGGAL_LAHIR'])); $luas_bangunan = $obj->fields['LUAS_BANGUNAN']; $query = "SELECT \n[NAMA_PT]\n,[NAMA_DEP]\n,[NAMA_PEJABAT]\n,[NAMA_JABATAN]\n,[PEJABAT_SPP]\n,[JABATAN_SPP]\n,[NAMA_SALES]\nFROM [CS_PARAMETER_MARK]"; $obj = $conn->execute($query); $nama_pejabat = $obj->fields['NAMA_PEJABAT']; $nama_jabatan = $obj->fields['NAMA_JABATAN']; $pejabat_spp = $obj->fields['PEJABAT_SPP']; $jabatan_spp = $obj->fields['JABATAN_SPP']; $nama_sales = $obj->fields['NAMA_SALES']; $query_rencana = "SELECT \nS.KODE_BLOK,\nS.POLA_BAYAR,\nS.TANDA_JADI,\nS.HARGA_TOTAL,\nR.TANGGAL,\nR.NILAI,\nJ.JENIS_BAYAR\nFROM RENCANA R,SPP S, JENIS_PEMBAYARAN J\nWHERE S.KODE_BLOK= R.KODE_BLOK \nAND J.KODE_BAYAR = R.KODE_BAYAR\nAND R.KODE_BLOK = '{$id}'"; $obj = $conn->execute($query_rencana); $tanggal_rencana = tgltgl(f_tgl($obj->fields['TANGGAL'])); $nilai = $obj->fields['NILAI']; $pola_bayar = $obj->fields['POLA_BAYAR']; $harga_total = $obj->fields['HARGA_TOTAL']; $tanda_jadi = $obj->fields['TANDA_JADI']; $jenis_bayar = $obj->fields['JENIS_BAYAR']; $blok = explode("-", $id); $no_unit = $blok[1]; $tower = substr($blok[0], -2, 1); //A1 $lantai = substr($blok[0], 1); $ttd = $conn->execute("\n\tSELECT *\n\tFROM \n\tSPP_TANDA_TANGAN\n\tWHERE KODE_BLOK='{$id}';\n"); $tt = $conn->execute("\n\tSELECT *\n\tFROM \n\tSPP_TANDA_TANGAN\n\tWHERE KODE_BLOK='{$id}';\n"); $t = $conn->execute("\n\tSELECT *\n\tFROM \n\tSPP_TANDA_TANGAN\n\tWHERE KODE_BLOK='{$id}';\n"); ?>
" > <td class="text-center"><?php echo $i; ?> </td> <td><?php echo $id; ?> </td> <td><?php echo $obj->fields['NAMA_CALON_PEMBELI']; ?> </td> <td><?php echo f_tgl($obj->fields['TANGGAL_RESERVE']); ?> </td> <td><?php echo $obj->fields['ALAMAT']; ?> </td> </tr> <?php $i++; $obj->movenext(); } } ?> </table>
<?php require_once '../../../../../config/config.php'; die_login(); // die_app('C'); die_mod('C08'); $conn = conn($sess_db); die_conn($conn); $per_page = isset($_REQUEST['per_page']) ? max(1, $_REQUEST['per_page']) : 20; $page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1; $tgl = f_tgl(date("Y-m-d")); $query_blok_lunas = ''; $query_pemb_jt = ''; $query_tglmerah = ''; $query_libur = ''; $query_blok_lunas = "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\n"; $query_pemb_jt .= "(SELECT PEMB_JATUH_TEMPO FROM CS_PARAMETER_COL)"; $query_tglmerah = "SELECT COUNT(*) FROM CS_HARI_LIBUR a WHERE a.tanggal_awal<=@CUR_DATE AND @CUR_DATE<=a.tanggal_akhir)"; # Pagination $query = "\nSELECT \n\tCOUNT(TANGGAL) AS TOTAL\nFROM \n\tRENCANA \nWHERE\n\tTANGGAL = CONVERT(DATETIME,'{$tgl}',105) AND \n\tKODE_BLOK NOT IN({$query_blok_lunas})\n"; $total_data = $conn->execute($query)->fields['TOTAL']; $total_page = ceil($total_data / $per_page); $page_num = $page_num > $total_page ? $total_page : $page_num; $page_start = ($page_num - 1) * $per_page; # End Pagination ?> <table id="pagging-1" class="t-control"> <tr> <td> <input type="button" id="print" value=" Cetak Data ">
$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']; }
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;
$tanggal = tgltgl(date("d-m-Y", strtotime($obj->fields['TANGGAL']))); $kode_blok = $obj->fields['KODE_BLOK']; $nama_pembayar = $obj->fields['NAMA_PEMBELI']; $kode_bayar = $obj->fields['BAYAR_UNTUK']; $no_tlp = $obj->fields['NOMOR_TELEPON']; $alamat = $obj->fields['ALAMAT_PEMBELI']; $bank = $obj->fields['BANK_GIRO']; $keterangan = $obj->fields['KETERANGAN']; $jumlah = $obj->fields['JUMLAH_DITERIMA']; $koordinator = $obj->fields['KOORDINATOR']; $penerima = $obj->fields['KASIR']; $bayar_secara = $obj->fields['BAYAR_SECARA']; } if ($act == 'Tambah') { $query = "SELECT RIGHT(replicate('0',4)+cast((SELECT CAST((NOMOR_KWITANSI_TTS + 1) AS VARCHAR(10)) FROM CS_REGISTER_CUSTOMER_SERVICE) as varchar(10)),4) AS NO, \n\t\t\t(SELECT TOP 1 REG_KWITANSI_TTS FROM CS_REGISTER_CUSTOMER_SERVICE) AS REG, \n\t\t\t(SELECT SUBSTRING(CONVERT(VARCHAR(10),(SELECT GETDATE()),10),1,2)) AS BULAN,\n\t\t\t(SELECT SUBSTRING(CONVERT(VARCHAR(10),(SELECT GETDATE()),10),7,2)) AS TAHUN,\n\t\t\t(SELECT GETDATE()) AS TANGGAL,\n\t\t\t(SELECT NOMOR_KWITANSI_TTS + 1 FROM CS_REGISTER_CUSTOMER_SERVICE) AS NOMOR_KWITANSI_TTS\n\t\t\t"; $obj = $conn->execute($query); $no = $obj->fields['NOMOR_KWITANSI_TTS']; $nomor = $obj->fields['NO'] . $obj->fields['REG'] . '/' . $obj->fields['BULAN'] . $obj->fields['TAHUN']; $tanggal = f_tgl($obj->fields['TANGGAL']); $kode_blok = ''; $penerima = $_SESSION['FULL_NAME']; $nama_pembayar = ''; $kode_bayar = ''; $no_tlp = ''; $alamat = ''; $bank = ''; $keterangan = ''; $jumlah = ''; $koordinator = ''; $bayar_secara = ''; }