function selectLNC($name, $atribut = "")
{
$db_function = new db_function();
$options = array();
$data = $db_function->selectAllRows("select singkatan from master_cab order by singkatan asc");
foreach ($data as $row) {
$options[$row["singkatan"]] = $row["singkatan"];
}
$value = cleanstr($_POST[$name]);
$value = in_array($value, array(null, "")) ? $_GET[$name] : $value;
$return = "<select id='{$name}' name='{$name}' {$atribut}>";
$return .= "<option value='all'>- All -</option>";
if (!empty($options)) {
foreach ($options as $optVal => $optName) {
$selected = $optVal == $value ? "selected='selected'" : "";
$return .= "<option value='{$optVal}' {$selected} >{$optName}</option>";
}
}
$return .= "</select>";
return $return;
}
ini_set('memory_limit', '-1');
if (!empty($_POST)) {
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");
header("Content-Disposition: attachment;filename=EXPORTCADS_" . str_replace("-", "", $_POST["frm"]["tgl_awal"]) . "_" . str_replace("-", "", $_POST["frm"]["tgl_akhir"]) . ".xls ");
header("Content-Transfer-Encoding: binary ");
xlsBOF();
$judulArray = array("TGL SIMPAN", "TGL. INPUT", "LNC", "NO. APLIKASI", "NAMA DEBITUR", "TEMPAT LAHIR", "TGL. LAHIR", "CIF", "NO.REKG. PINJAMAN", "AFILIASI", "INSTANSI", "PRODUK", "PLAFOND", "NO. PK", "TGL. PK", "JKW. KREDIT", "FIX RATE", "TGL. JT TEMPO", "TGL. JT FIX", "LOKASI DOK. ASLI", "NO.BANTEK ASLI", "NO. AMPLOP ASLI", "LOKASI DOK. COPY", "NO. BANTEK COPY", "NO. AMPLOP COPY", "JENIS SERTIFIKAT", "STATUS SERTIFIKAT", "NO. GS/SU", "JENIS SURAT TANAH", "ALAMAT OBYEK JAMINAN", "LUAS TANAH", "TGL.JT SURAT TANAH", "JENIS HT", "NILAI HT", "STATUS COVERNOTE", "NO COVERNOTE", "TGL. COVERNOTE", "JKW COVERNOTE", "TGL JT COVERNOTE", "NAMA NOTARIS", "NAMA PEMILIK JAMINAN", "JUMLAH JAMINAN", "STATUS AJB", "NO. AJB", "NO. KEPEMILIKAN TANAH", "COLLATERAL ZIPCODE", "LUAS BANGUNAN", "TGL. SERTIFIKAT", "HARGA TANAH", "HARGA BANGUNAN", "HARGA TANAH IMB/M2", "HARGA BANGUNAN IMB/M2", "STATUS PENGIKATAN", "NO. PENGIKATAN", "PROSES PENGIKATAN", "TGL PENGIKATAN", "TGL PENERAHAN BERKAS", "DEVELOPER", "NO PKS", "SKIM PKS", "STATUS IMB", "NO. IMB", "NAMA PROYEK", "KATEGORI PROYEK", "JENIS PROYEK", "TOTAL UNIT DI BANGUN", "PENGUASAAN SERTIFIKAT", "NO REK ESCROW", "CAIR TAHAP FONDASI", "TGL CAIR TAHAP FONDASI", "KET CAIR TAHAP FONDASI", "CAIR TAHAP TOPPING", "TANGGAL CAIR TAHAP TOPPING", "KET CAIR TAHAP TOPPING", "CAIR TAHAP BAST", "TANGGAL CAIR TAHAP BAST", "KET CAIR TAHAP BAST", "CAIR TAHAP DOK", "TANGGAL CAIR TAHAP DOK", "KET CAIR TAHAP DOK", "PROSES ANGGUNAN", "ASS. JIWA", "STATUS POLIS ASS JW", "NO.POLIS ASS JW", "PREMI ASS.JW", "NILAI PERTANGG ASS JW", "TGL. ASS JW", "TGL. JT ASS JW", "BERKAS ASURANSI JW", "ASS. KERUGIAN", "STATUS POLIS ASS KERUGIAN", "NO. POLIS ASS KERUGIAN", "PREMI KERUGIAN", "NILAI PERTGG ASS KERUGIAN", "TGL. ASS KERUGIAN", "TGL. JT ASS KERUGIAN", "BERKAS ASURANSI KERUGIAN", "JENIS KENDARAAN", "STATUS BPKB", "NO. BPKB", "NO. RANGKA", "NAMA DEALER", "MERK", "NO. MESIN", "NO. POLISI", "STATUS REKG", "TGL. LUNAS", "TANGGAL DISERAHKAN", "PENERIMA PELUNASAN", "KETERANGAN PELUNASAN", "MEMO", "SKDR", "STATUS SIUP", "SIUP", "STATUS TDP", "TDP", "STATUS OTHERS", "OTHERS", "STATUS PENYERAHAN JAMINAN", "KENDALA", "TGL. UPDATE", "BUNGA", "PROGRAM", "AGAMA", "NO. NPWP", "JENIS KELAMIN", "TGL. IMB", "PENILAI", "TGL. TAKSASI", "ALAMAT", "KODE CABANG", "NO. KTP", "IBU KANDUNG", "JABATAN", "MEMO APPRAISAL", "PLAFOND DIMOHON", "NAMA EMERGENCY", "NO.TELP. EMERGENCY", "ALAMAT KANTOR", "HUBUNGAN EMERGENCY", "PROGRESS BANGUNAN", "NAMA SALES", "NO. HP SALES", "STATUS KJPP", "KJPP", "STATUS APLIKASI", "TGL.UPDATE APP", "TGL.UPDATE LOS", "TGL.UPDATE ASC", "SKIM PENCAIRAN", "STATUS JAMINAN FLEKSI", "NO JAMINAN FLEKSI", "JENIS JAMINAN FLEKSI", "SURAT PERNYATAAN FLEKSI", "USER CREATE", "USER UPDATE");
$db_function = new db_function();
$sql = "select action,input_date,LNC,NOAPLIKASI,NAMADEBITUR,TEMPATLAHIR,TGLLAHIR,CIF,no_rekg_pinjaman,afiliasi,instansi,produk,maksimum_kredit,no_pk,tgl_pk,jkw_kredit,fixed_rate,tgl_jt_pk,tgl_jt_fixed_rate,lokasi_dokumen_asli,amplop_asli,amplopasli,lokasi_dokumen_copy,amplop_copy,amplopcopy,jenis_sertifikat,jaminan,jml_jaminan,jenis_surat_tanah,alamat_collateral,luas_tanah,tgl_jt_surat_tanah,jenis_pengikatan,nilai_ht,no_covernote,no_covernote_n,tgl_covernote,jkw_covernote,tgl_jt_covernote,notaris,appraisal,jml_jaminan_n,no_ajb,no_ajb_n,no_surat_tanah,collateral_zipcode,luas_bangunan,nilai_taksasi,harga_tanah,harga_bangunan,harga_tanah_imb,harga_bangunan_imb,no_pengikatan,no_pengikatan_n,proses_pengikatan,tgl_pengikatan,tgl_penyerahan_berkas,developer,no_pks,skim_pks,status_imb,no_imb,nama_perumahan,kategori_proyek,jenis_proyek,total_unitdibangun,penguasaan_sertifikat,no_rek_escrow,cair_tahap_fondasi,tgl_cair_tahap_fondasi,ket_cair_tahap_fondasi,cair_tahap_topping,tgl_cair_tahap_topping,ket_cair_tahap_topping,cair_tahap_bast,tgl_cair_tahap_bast,ket_cair_tahap_bast,cair_tahap_dok,tgl_cair_tahap_dok,ket_cair_tahap_dok,proses_agunan,asuransi_jiwa,no_polis_ass_jiwa,no_polis_ass_jiwa_n,premi_jiwa,nilai_pertanggungan_ass_jiwa,tgl_ass_jiwa,tgl_jt_ass_jiwa,berkas_assuransi_jiwa,asuransi_kerugian,no_polis_ass_kerugian,no_polis_ass_kerugian_n,premi_kerugian,nilai_pertanggungan_ass_kerugian,tgl_ass_kerugian,tgl_jt_ass_kerugian,berkas_asuransi_kerugian,jenis_kendaraan,no_bpkb,no_bpkb_n,no_rangka,nama_dealer,merk,no_mesin,no_polisi,status_rekg,tgl_pelunasan,tgl_serah,pelunasan_penerima,pelunasan_keterangan,memo,skdr,siup,siup_n,tdp,tdp_n,others,others_n,serah,kendala,tgl_update,bunga,program,agama,npwp,kelamin,tgl_imb,penilai,tgl_taksasi,tinggal,cabang,no_ktp,ibu_kandung,jabatan,memo_appraisal,plafond_dimohon,nama_emergency,telp_emergency,alamat_kantor,hubungan,progress,sales,hp_sales,kjpp_flag,kjpp,status,tgl_update_app,tgl_update_los,tgl_update_asc,skim_pencairan,no_jaminan_fleksi,no_jaminan_fleksi_n,jns_jaminan_fleksi,srt_pernyataan_fleksi,usercreate,userupdate from debitur ";
$sql .= "where tgl_update>= '" . balikTgl($_POST["frm"]["tgl_awal"]) . " 00:00:00' and tgl_update<='" . balikTgl($_POST["frm"]["tgl_akhir"]) . " 23:59:59'";
$dataArray = $db_function->selectAllRows($sql);
xlsWriteLabel(0, 0, "[debitur]");
$row = 1;
foreach ($judulArray as $col => $data) {
xlsWriteLabel($row, $col, $data);
}
$row++;
foreach ($dataArray as $data) {
foreach ($judulArray as $col => $judul) {
$kata = $data[$col];
if (strlen($kata) > 1000) {
$kata = substr($kata, 0, 1000);
}
xlsWriteLabel($row, $col, $kata);
}
$row++;
}
$strKey = substr_replace($strKey, "", -1);
$strVal = substr_replace($strVal, "", -2);
$query = "insert into debitur_trail\r\n (no_trail,{$strKey},userupdate,tgl_update) \r\n values('1',{$strVal},'{$userCreate}',now());";
$buf = cleanstr($db_function->exec($query));
if ($buf != "") {
cleanstr($db_function->exec("delete from debitur where noaplikasi='" . $_POST['frm']['noaplikasi'] . "'"));
}
}
//------------
if ($buf != "") {
array_push($pesanError, $buf);
} else {
if ($frm['jaminan'] == "SATUAN" && cleanstr($frm['no_surat_tanah']) != "" && cleanstr($frm['jml_jaminan']) != "") {
$sql = "select lnc,noaplikasi,namadebitur,no_rekg_pinjaman,produk,jaminan,no_surat_tanah,jml_jaminan " . "FROM debitur WHERE debitur.no_surat_tanah = '" . $frm['no_surat_tanah'] . "' " . "AND debitur.jaminan='" . $frm['jaminan'] . "' AND debitur.jml_jaminan='" . $frm['jml_jaminan'] . "' order by input_date desc";
$dataduplikasi = $db_function->selectAllRows($sql);
if (count($dataduplikasi) > 0) {
$buf = "<h3>DAFTAR DEBITUR YANG TERINDIKASI DUPLIKASI SERTIFIKAT</h3><table class='tblLookup' border='1px'><thead><tr>\r\n <th>NAMA LNC</th> \r\n <th>NO. APLIKASI</th> \r\n <th>NAMA DEBITUR</th>\r\n <th>NO. REK. PINJAMAN</th>\r\n <th>JENIS PRODUK</th>\r\n <th>STATUS SERTIFIKAT</th>\r\n <th>NO. SERTIFIKAT</th>\r\n <th>NO. GS/SU</th>\r\n </tr></thead><tbody>";
foreach ($dataduplikasi as $row) {
$buf .= "<tr><td>" . $frm['lnc'] . "</td>" . "<td>" . $frm['noaplikasi'] . "</td>" . "<td>" . $frm['namadebitur'] . "</td>" . "<td>" . $frm['no_rekg_pinjaman'] . "</td>" . "<td>" . $frm['produk'] . "</td>" . "<td>" . $frm['jaminan'] . "</td>" . "<td>" . $frm['no_surat_tanah'] . "</td>" . "<td>" . $frm['jml_jaminan'] . "</td>" . "</tr>";
}
$buf .= "</tbody></table>";
$_SESSION['colateral']['message'] = showMessage($buf, "notice", "-ses");
}
}
if (empty($_SESSION['colateral']['message'])) {
$_SESSION['colateral']['message'] = showMessage("Data debitur telah disimpan", "success", "-ses");
}
header("location:col_frminput.php");
exit;
}
foreach ($buf as $key => $val) {
if (!is_int($key)) {
$trailSekarang[strtolower($key)] = isDateDB($val) ? balikTgl($val) : $val;
}
}
$usersCreate = $db_function->selectOneRows("select * from pegawai where npp='" . $trailSekarang['userupdate'] . "'");
if ($_GET['no_trail'] > 1) {
$buf = $db_function->selectOneRows("select * from debitur_trail where no_rekg_pinjaman='" . $_GET['id'] . "' and no_trail='" . ($_GET['no_trail'] - 1) . "'");
foreach ($buf as $key => $val) {
if (!is_int($key)) {
$trailSebelum[strtolower($key)] = isDateDB($val) ? balikTgl($val) : $val;
}
}
}
$cekTrail = new CekTrail($trailSekarang, $trailSebelum);
$buf = $db_function->selectAllRows("select distinct no_trail from debitur_trail where no_rekg_pinjaman='" . $_GET['id'] . "' order by no_trail asc");
$ListNoTrail = array();
foreach ($buf as $row) {
$ListNoTrail[$row['no_trail']] = $row['no_trail'];
}
$produk_nm = trim(strtoupper($_POST['frm']["produk"]));
//echo $produk_nm;exit;
if (in_array($produk_nm, array("BNI GRIYA", "BNI OTO", "BNI GRIYA MULTIGUNA", "BNI FLEKSI", "BNI CERDAS", "BNI WIRAUSAHA", "UMG"))) {
// kalau pilihan nya ada didatabase baru pakek kondisi
//cuma Griya/Multiguna/BWU yg bisa
if (in_array($produk_nm, array("BNI GRIYA", "BNI GRIYA MULTIGUNA", "BNI WIRAUSAHA"))) {
$showInformasiJaminan = true;
}
//cuma Griya/OTO/Multiguna/BWU yg bisa
if (in_array($produk_nm, array("BNI GRIYA", "BNI OTO", "BNI GRIYA MULTIGUNA", "BNI WIRAUSAHA"))) {
$showInformasiAsuransiKerugian = true;
$db_function = new db_function();
if (strtolower($_POST['action']) == "simpan point") {
$data = $_SESSION['colateral']['summery_pending'];
$tanggal = $data[0]['tanggal'];
$setTgl = $tanggal;
unset($_SESSION['colateral']['summery_pending']);
$db_function->exec("delete summery_pending where tanggal='{$tanggal}'");
foreach ($data as $row) {
if (intval($row['jumlah']) != 0) {
$db_function->exec("insert into summery_pending values('" . $row['tanggal'] . "',\n '" . $row['lnc'] . "',\n '" . $row['jenis'] . "',\n '" . $row['jumlah'] . "')");
}
}
header("location:col_sumPending.php?jns_pencarian=point&tgl_point=" . $tanggal);
exit;
}
$dataLNC = $db_function->selectAllRows("select UPPER(singkatan) singkatan from master_cab order by singkatan asc");
if ($_GET['jns_pencarian'] == "saat_ini") {
$setTgl = date("Y-m-d");
$sql = "select LNC as lnc,count(LNC) as jml from debitur where 1=1 :paramwhere: group by LNC";
$sqlBPKB = str_replace(":paramwhere:", "and no_bpkb='PENDING' ", $sql);
$sqlAJB = str_replace(":paramwhere:", "and no_ajb='PENDING' ", $sql);
$sqlSHT = str_replace(":paramwhere:", "and no_pengikatan='PENDING' ", $sql);
$sqlPolisAssJiwa = str_replace(":paramwhere:", "and no_polis_ass_jiwa='PENDING' ", $sql);
$sqlPolisAssRugi = str_replace(":paramwhere:", "and no_polis_ass_kerugian='PENDING' ", $sql);
$sqlTotalDebitur = str_replace(":paramwhere:", "and status_rekg='AKTIF' ", $sql);
$countBPKB = pecahData($db_function->selectAllRows($sqlBPKB));
$countAJB = pecahData($db_function->selectAllRows($sqlAJB));
$countSHT = pecahData($db_function->selectAllRows($sqlSHT));
$countAssJiwa = pecahData($db_function->selectAllRows($sqlPolisAssJiwa));
$countKerugian = pecahData($db_function->selectAllRows($sqlPolisAssRugi));
$countTotalDebitur = pecahData($db_function->selectAllRows($sqlTotalDebitur));
$db_function = new db_function();
if (strtolower($_POST['action']) == "simpan point") {
$data = $_SESSION['colateral']['summery_legal'];
$tanggal = $data[0]['tanggal'];
$setTgl = $tanggal;
unset($_SESSION['colateral']['summery_legal']);
$db_function->exec("delete summery_legal where tanggal='{$tanggal}'");
foreach ($data as $row) {
if (intval($row['jumlah']) != 0) {
$db_function->exec("insert into summery_legal values('" . $row['tanggal'] . "',\n '" . $row['lnc'] . "',\n '" . $row['jenis'] . "',\n '" . $row['jumlah'] . "')");
}
}
header("location:col_sumLegalitas.php?jns_pencarian=point&tgl_point=" . $tanggal);
exit;
}
$dataLNC = $db_function->selectAllRows("select UPPER(singkatan) singkatan from master_cab order by singkatan asc");
if ($_GET['jns_pencarian'] == "saat_ini") {
$setTgl = date("Y-m-d");
$sql = "select LNC as lnc,count(LNC) as jml from debitur where 1=1 :paramwhere: group by LNC";
$sqlIMB = str_replace(":paramwhere:", "and status_imb='PENDING' ", $sql);
$sqlSIUP = str_replace(":paramwhere:", "and siup='PENDING' ", $sql);
$sqlTDP = str_replace(":paramwhere:", "and tdp='PENDING' ", $sql);
$sqlOTHERS = str_replace(":paramwhere:", "and others='PENDING' ", $sql);
// echo $sqlIMB;
$countIMB = pecahData($db_function->selectAllRows($sqlIMB));
$countSIUP = pecahData($db_function->selectAllRows($sqlSIUP));
$countTDP = pecahData($db_function->selectAllRows($sqlTDP));
$countOTHERS = pecahData($db_function->selectAllRows($sqlOTHERS));
$showtable = true;
} else {
if ($_GET['jns_pencarian'] == "tgl") {
$cssTabActive = "ui-tabs-active ui-state-active";
$cssInput = $cssTabActive;
$cssEdit = "";
$submn = $_GET['submn'];
if ($submn == "input") {
$cssInput = $cssTabActive;
$cssEdit = "";
} else {
$cssEdit = $cssTabActive;
$cssInput = "";
}
$db_function = new db_function();
$dataTBL = array();
$listLNC = array();
$listLNC[''] = "semua";
$data = $db_function->selectAllRows("select singkatan from master_cab order by singkatan asc");
foreach ($data as $row) {
$listLNC[$row["singkatan"]] = $row["singkatan"];
}
if (!empty($_POST)) {
$tgl1 = balikTgl($_POST['frm']['tgl1']);
$tgl2 = balikTgl($_POST['frm']['tgl2']);
$sql = "select lnc,npp,nama,jml from pegawai right join\n (select lnc,userupdate,count(no_rekg_pinjaman) jml from debitur_trail \n where 1=1 :whereLNC: and :whereInput: and tgl_update>'{$tgl1}' and tgl_update<'{$tgl2} 23:59:59'\n group by userupdate,lnc) sumjml on pegawai.npp=sumjml.userupdate order by lnc,npp";
if ($_POST['frm']['lnc'] == "") {
$sql = str_replace(":whereLNC:", "", $sql);
} else {
$sql = str_replace(":whereLNC:", "and lnc='" . $_POST['frm']['lnc'] . "'", $sql);
}
if ($submn == "input") {
$sql = str_replace(":whereInput:", "no_trail=1", $sql);
} else {
unset($_POST['frm']['cair_tahap_bast']);
unset($_POST['frm']['tgl_cair_tahap_bast']);
unset($_POST['frm']['cair_tahap_dok']);
unset($_POST['frm']['tgl_cair_tahap_dok']);
}
//update debitur
$query = "update debitur set tgl_update=now(),userupdate='{$userCreate}',";
foreach ($_POST['frm'] as $key => $val) {
if (isDate($val)) {
$val = balikTgl($val);
}
$query .= "{$key}='{$val}',";
}
//cari kolom debitur
$kolomDebitur = array();
$buf = $db_function->selectAllRows("SHOW COLUMNS FROM debitur ");
$queryLower = strtolower($query);
foreach ($buf as $val) {
//tgl_update=now(),userupdate='$userCreate',no_rekg_pinjaman
$kolom = strtolower($val[0]);
if (!strpos($queryLower, $kolom) && $kolom != "no_rekg_pinjaman") {
$query .= strtolower($val[0]) . "='',";
}
}
$query = substr_replace($query, "", -1);
$query .= " where no_rekg_pinjaman='" . $_POST['frm']['no_rekg_pinjaman'] . "'";
$buf = cleanstr($db_function->exec($query));
if ($buf == "") {
//insert trail
$strKey = "";
$strVal = "'";
<table>
<tr>
<td>Nama LNC</td>
<td><?php
echo selectLNC("LNC");
?>
</td>
</tr>
<tr>
<td>Nama Produk</td>
<td>
<?php
$db_function = new db_function();
$options = array();
$data = $db_function->selectAllRows("select produk_nm from master_produk");
foreach ($data as $row) {
$options[$row["produk_nm"]] = $row["produk_nm"];
}
echo selectnya("cari", $options);
?>
</td>
</tr>
<tr>
<td>Hari Proses</td>
<td><?php
echo inputnya("hariproses1", "style='width:100px'") . " s/d " . inputnya("hariproses2", "style='width:100px'");
?>
</td>
</tr>
</table>
$db_function = new db_function();
if (strtolower($_POST['action']) == "simpan point") {
$data = $_SESSION['colateral']['summery_bertahap'];
$tanggal = $data[0]['tanggal'];
$setTgl = $tanggal;
unset($_SESSION['colateral']['summery_bertahap']);
$db_function->exec("delete summery_bertahap where tanggal='{$tanggal}'");
foreach ($data as $row) {
if (intval($row['jumlah']) != 0) {
$db_function->exec("insert into summery_bertahap values('" . $row['tanggal'] . "',\r\n '" . $row['lnc'] . "',\r\n '" . $row['jenis'] . "',\r\n '" . $row['jumlah'] . "')");
}
}
header("location:col_sumCairTahap.php?jns_pencarian=point&tgl_point=" . $tanggal);
exit;
}
$dataLNC = $db_function->selectAllRows("select UPPER(singkatan) singkatan from master_cab order by singkatan asc");
if ($_GET['jns_pencarian'] == "saat_ini") {
$setTgl = date("Y-m-d");
$sql = "select lnc,count(tgl_cair_tahap_fondasi)jml from debitur where skim_pencairan='PARTIAL DROW DOWN' " . "and skim_pks in('KAVLING BANGUN','INDENT') and progress <> '' group by lnc";
$countDebitur = pecahData($db_function->selectAllRows($sql));
$sql = "select lnc,count(tgl_cair_tahap_fondasi)jml from debitur where progress='BELUM SELESAI' and skim_pencairan='PARTIAL DROW DOWN' " . "and skim_pks in('KAVLING BANGUN','INDENT') and tgl_cair_tahap_fondasi in(null,'','0000-00-00') group by lnc";
$countFondasi = pecahData($db_function->selectAllRows($sql));
$sql = "select lnc,count(tgl_cair_tahap_topping)jml from debitur where progress='BELUM SELESAI' and skim_pencairan='PARTIAL DROW DOWN' " . "and skim_pks in('KAVLING BANGUN','INDENT') and tgl_cair_tahap_fondasi >'0000-00-00' and tgl_cair_tahap_topping in(null,'','0000-00-00') group by lnc";
$countTopping = pecahData($db_function->selectAllRows($sql));
$sql = "select lnc,count(tgl_cair_tahap_bast)jml from debitur where progress='BELUM SELESAI' and skim_pencairan='PARTIAL DROW DOWN' " . "and skim_pks in('KAVLING BANGUN','INDENT') and tgl_cair_tahap_topping >'0000-00-00' and tgl_cair_tahap_bast in(null,'','0000-00-00') group by lnc";
$countBast = pecahData($db_function->selectAllRows($sql));
$sql = "select lnc,count(tgl_cair_tahap_dok)jml from debitur where progress='BELUM SELESAI' and skim_pencairan='PARTIAL DROW DOWN' " . "and skim_pks in('KAVLING BANGUN','INDENT') and tgl_cair_tahap_bast >'0000-00-00' and tgl_cair_tahap_dok in(null,'','0000-00-00') group by lnc";
$countTahapDok = pecahData($db_function->selectAllRows($sql));
$sql = "select lnc,count(tgl_cair_tahap_dok)jml from debitur where progress='SELESAI' and skim_pencairan='PARTIAL DROW DOWN' " . "and skim_pks in('KAVLING BANGUN','INDENT') group by lnc";
$countSelesai = pecahData($db_function->selectAllRows($sql));
$showtable = true;
$listTypeLookup[$row["type"]]=$row["type"];
}*/
$listTypeLookup = array("asuransi_jiwa" => "Asuransi Jiwa", "asuransi_kerugian" => "Asuransi Kerugian", "daftar_kjpp" => "Daftar Kjpp", "developer" => "Developer", "jns_kendaraan" => "Jenis Kendaraan", "merk_kendaraan" => "Merek Kendaraan", "notaris" => "Notaris", "kendala" => "Kendala Pengikatan", "jns_pengikatan" => "Jenis Pengikatan", "jns_surat_tanah" => "Jenis Jaminan");
$listLookup = "";
$action = $_GET['action'] != null ? $_GET['action'] : "Simpan";
if (!empty($_POST)) {
if ($_POST['action'] == "Batal") {
header("location:col_lookup.php?type=" . $_GET['type']);
} elseif ($_POST['action'] == "Simpan") {
$frm = $_POST['frm'];
$sql = "insert into lookup(type,value,lnc)values('" . $frm['type'] . "','" . $frm['value'] . "','" . $frm['lnc'] . "')";
$db_function->exec($sql);
header("location:col_lookup.php?type=" . $_GET['type']);
} elseif ($_POST['action'] == "Edit") {
$frm = $_POST['frm'];
$db_function->exec("update lookup set type='" . $frm['type'] . "',value='" . $frm['value'] . "',lnc='" . $frm['lnc'] . "' " . "where type='" . $_GET['type'] . "' and value='" . $_GET['value'] . "'");
header("location:col_lookup.php?type=" . $_GET['type']);
}
}
if ($action == "delete") {
$db_function->exec("delete from lookup where type='" . $_GET['type'] . "' and value='" . $_GET['value'] . "'");
header("location:col_lookup.php?type=" . $_GET['type']);
} elseif ($action == "Edit" && empty($_POST)) {
$_POST['frm']['value'] = $_GET['value'];
$_POST['frm']['lnc'] = $db_function->selectOnefield("select lnc from lookup where type='" . $_GET['type'] . "' and value='" . $_GET['value'] . "'");
}
if ($_GET['type'] != null) {
$_POST['frm']['type'] = $_GET['type'];
$sql = "select * from lookup where type= '" . $_GET['type'] . "' order by value asc";
$listLookup = $db_function->selectAllRows($sql);
}
function json_sumDetCair()
{
$db_function = new db_function();
$lnc = $_GET['lnc'];
$jns = $_GET['jns'];
$page = $_GET['page'];
$limit = $_GET['rows'];
$sidx = $_GET['sidx'];
$sord = $_GET['sord'];
$tgl = $_GET['tgl'];
if ($limit == "") {
$limit = 10;
}
$tgl_update = $tgl . " 23:59:59";
$sql = "select trail.noaplikasi,trail.namadebitur,trail.no_rekg_pinjaman,trail.tgl_pk ,trail.tgl_cair_tahap_fondasi,trail.tgl_cair_tahap_topping,trail.tgl_cair_tahap_bast,trail.tgl_cair_tahap_dok \n from debitur join debitur_trail trail on debitur.no_rekg_pinjaman=trail.no_rekg_pinjaman\n join (\n select max(tgl_update) tgl_update,no_rekg_pinjaman from debitur_trail where tgl_update <= '{$tgl_update}' group by no_rekg_pinjaman) bb\n on trail.no_rekg_pinjaman=bb.no_rekg_pinjaman and trail.tgl_update=bb.tgl_update\n where 1=1 and trail.skim_pencairan='PARTIAL DROW DOWN' and trail.skim_pks in('KAVLING BANGUN','INDENT') :paramwhere: group by trail.lnc";
if (isset($_GET['searchValue']) && trim($_GET['searchValue']) != "") {
$sql .= " and " . $_GET['searchBy'] . " like '%" . $_GET['searchValue'] . "%' ";
}
switch ($jns) {
case "debitur":
$sql = str_replace(":paramwhere:", "and trail.progress <>'' ", $sql);
break;
case "pondasi":
$sql = str_replace(":paramwhere:", "and trail.progress='BELUM SELESAI' and trail.tgl_cair_tahap_fondasi in(null,'','0000-00-00') ", $sql);
break;
case "topping":
$sql = str_replace(":paramwhere:", "and trail.progress='BELUM SELESAI' and trail.tgl_cair_tahap_fondasi >'0000-00-00' and trail.tgl_cair_tahap_topping in(null,'','0000-00-00') ", $sql);
break;
case "bast":
$sql = str_replace(":paramwhere:", "and trail.progress='BELUM SELESAI' and trail.tgl_cair_tahap_topping >'0000-00-00' and trail.tgl_cair_tahap_bast in(null,'','0000-00-00') ", $sql);
break;
case "dokumen":
$sql = str_replace(":paramwhere:", "and trail.progress='BELUM SELESAI' and trail.tgl_cair_tahap_bast >'0000-00-00' and trail.tgl_cair_tahap_dok in(null,'','0000-00-00') ", $sql);
break;
case "inprogress":
$sql = str_replace(":paramwhere:", "and trail.progress='SELESAI' ", $sql);
break;
case "selesai":
$sql .= "AND progress='SELESAI'";
break;
}
$sqlCount = "select count(*) from ({$sql}) test";
$count = $db_function->selectOnefield($sqlCount);
if ($count > 0 && $limit > 0) {
$total_pages = ceil($count / $limit);
} else {
$total_pages = 0;
}
if ($page > $total_pages) {
$page = $total_pages;
}
$start = $limit * $page - $limit;
if ($start < 0) {
$start = 0;
}
$sqlDt = "select * from ({$sql})temp LIMIT {$start} , {$limit}";
$query = $db_function->selectAllRows($sqlDt);
$responce['page'] = $page;
$responce['total'] = $total_pages;
$responce['records'] = $count;
$i = 0;
foreach ($query as $row) {
$row['tgl_pk'] = balikTgl($row['tgl_pk']);
$row['tgl_cair_tahap_fondasi'] = cleanDate(balikTgl($row['tgl_cair_tahap_fondasi']));
$row['tgl_cair_tahap_topping'] = cleanDate(balikTgl($row['tgl_cair_tahap_topping']));
$row['tgl_cair_tahap_bast'] = cleanDate(balikTgl($row['tgl_cair_tahap_bast']));
$row['tgl_cair_tahap_dok'] = cleanDate(balikTgl($row['tgl_cair_tahap_dok']));
$responce['rows'][$i]['id'] = $i;
$responce['rows'][$i]['cell'] = $row;
$i++;
}
echo json_encode($responce);
exit;
}
