• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

PHP tgltgl函数代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了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;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
PHP tgmpa函数代码示例发布时间:2022-05-23
下一篇:
PHP tglindonesia函数代码示例发布时间:2022-05-23
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap