本文整理汇总了PHP中tgltgl函数的典型用法代码示例。如果您正苦于以下问题:PHP tgltgl函数的具体用法?PHP tgltgl怎么用?PHP tgltgl使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了tgltgl函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: kontgl
$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;
开发者ID:rizafr,项目名称:market_ancol,代码行数:31,代码来源:surat_pemberian_jatuh_tempo.php
示例2: round
$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;
开发者ID:rizafr,项目名称:market_ancol,代码行数:31,代码来源:informasi_pembeli_proses.php
示例3: tgltgl
?>
">
<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>
开发者ID:rizafr,项目名称:market_ancol,代码行数:30,代码来源:print_perpanjangan_akad.php
示例4: while
$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;
}
}
开发者ID:rizafr,项目名称:market_ancol,代码行数:31,代码来源:umur_piutang_load_rekap.php
示例5: tgltgl
?>
">
<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
开发者ID:rizafr,项目名称:market_ancol,代码行数:31,代码来源:reserve_persediaan_load.php
示例6: kontgl
?>
</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();
开发者ID:rizafr,项目名称:market_ancol,代码行数:31,代码来源:pembatalan_spp_load.php
示例7: tgltgl
?>
</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>
开发者ID:rizafr,项目名称:market_ancol,代码行数:31,代码来源:reserve_load.php
示例8: GETDATE
$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 = '';
}
}
开发者ID:rizafr,项目名称:market_ancol,代码行数:31,代码来源:informasi_persediaan_proses.php
示例9: CONVERT
$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();
开发者ID:rizafr,项目名称:market_ancol,代码行数:31,代码来源:surat_wanprestasi.php
示例10: substr
$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
开发者ID:rizafr,项目名称:market_ancol,代码行数:31,代码来源:surat_somasi_tiga.php
示例11: kontgl
$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 = '';
}
开发者ID:rizafr,项目名称:market_ancol,代码行数:31,代码来源:pembayaran_proses.php
示例12: sistem_pembayaran
?>
</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;
}
?>
开发者ID:rizafr,项目名称:market_ancol,代码行数:31,代码来源:daftar_belum_ppjb_print.php
示例13: tgltgl
$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
开发者ID:rizafr,项目名称:market_ancol,代码行数:31,代码来源:ppjb_cetak.php
示例14: die_login
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 {
开发者ID:rizafr,项目名称:market_ancol,代码行数:31,代码来源:kuitansi_lain_print.php
示例15: json_encode
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;
开发者ID:rizafr,项目名称:market_ancol,代码行数:31,代码来源:pembayaran_proses.php
示例16: COUNT
$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'];
}
开发者ID:rizafr,项目名称:market_ancol,代码行数:31,代码来源:kuitansi_proses.php
示例17: tgltgl
?>
</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());
开发者ID:rizafr,项目名称:market_ancol,代码行数:31,代码来源:pengalihan_hak_histori_load.php
示例18: while
<?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 -->
开发者ID:rizafr,项目名称:market_ancol,代码行数:31,代码来源:akunting_print.php
示例19: tgltgl
?>
</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>
开发者ID:rizafr,项目名称:market_ancol,代码行数:31,代码来源:kartu_kuning_popup.php
示例20: f_tgl
$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'];
}
开发者ID:rizafr,项目名称:market_ancol,代码行数:31,代码来源:pengalihan_hak_histori_proses.php
注:本文中的tgltgl函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论