$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;
示例#3
0
    ?>
</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++;
示例#5
0
    $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());	
示例#7
0
        ?>
							<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($) {
示例#10
0
 $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);
示例#11
0
	<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'];
示例#12
0
$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");
?>
示例#13
0
"
		> 
			<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>
示例#14
0
<?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'];
}
示例#16
0
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;
示例#17
0
    $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 = '';
}