unset($_POST['frm']['cair_tahap_dok']);
unset($_POST['frm']['tgl_cair_tahap_dok']);
}
$datenow = date(Ymd);
$userCreate = $_SESSION['colateral']['npp'];
foreach ($_POST['frm'] as $key => $val) {
if (isDate($val)) {
$val = balikTgl($val);
}
$strKey .= $key . ",";
$strVal .= trim($val) . "','";
}
$strKey = substr_replace($strKey, "", -1);
$strVal = substr_replace($strVal, "", -2);
$query = "insert into debitur\r\n ({$strKey},usercreate,userupdate,action,tgl_update) \r\n values({$strVal},'{$userCreate}','{$userCreate}','{$datenow}','{$datenow}');";
$buf = cleanstr($db_function->exec($query));
if ($buf == "") {
//--insert trail
$strKey = "";
$strVal = "'";
$frmTrail = $_POST['frm'];
$nonTrail = array('usercreate', 'action');
foreach ($nonTrail as $row) {
unset($frmTrail[$row]);
}
foreach ($frmTrail as $key => $val) {
if (isDate($val)) {
$val = balikTgl($val);
}
$strKey .= $key . ",";
$strVal .= trim($val) . "','";
$showtable = false;
$ddl_tglpoint = array();
$setTgl = "";
if (empty($_GET["jns_pencarian"])) {
header("location:col_sumPending.php?jns_pencarian=tgl");
exit;
}
$_POST['frm']['jns_pencarian'] = $_GET['jns_pencarian'];
if (!empty($_POST)) {
$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);
$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 = "'";
$frmTrail = $_POST['frm'];
foreach ($frmTrail as $key => $val) {
if (isDate($val)) {
$val = balikTgl($val);
}
$strKey .= $key . ",";
$strVal .= trim($val) . "','";
}
$query = "select no_trail from debitur_trail where no_rekg_pinjaman='" . $_POST['frm']['no_rekg_pinjaman'] . "' order by no_trail desc";
$lastOrder = $db_function->selectOnefield($query);
$lastOrder = $lastOrder == "" ? "0" : $lastOrder + 1;
function insertDebiturTrail($data, $row)
{
if (cleanstr($data->val($row, 9)) != "") {
$pesan = "";
$db_function = new db_function();
$sql = "delete from debitur_trail where no_rekg_pinjaman='" . $data->val($row, 7) . "' and no_trail='" . $data->val($row, 156) . "'";
$pesan = $db_function->exec($sql);
if ($pesan != "") {
$_SESSION['colateral']['message_loop'][] = $pesan;
}
$sql = "insert into debitur_trail (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,jaminan,jml_jaminan,jenis_surat_tanah,alamat_collateral,luas_tanah,tgl_jt_surat_tanah,jenis_pengikatan,nilai_ht,jkw_covernote,notaris,appraisal,no_ajb,no_surat_tanah,collateral_zipcode,luas_bangunan,nilai_taksasi,harga_tanah,harga_bangunan,harga_tanah_imb,harga_bangunan_imb,no_pengikatan,tgl_covernote,tgl_jt_covernote,developer,skim_pks,no_imb,status_imb,nama_perumahan,asuransi_jiwa,no_polis_ass_jiwa,premi_jiwa,nilai_pertanggungan_ass_jiwa,tgl_ass_jiwa,tgl_jt_ass_jiwa,asuransi_kerugian,no_polis_ass_kerugian,premi_kerugian,nilai_pertanggungan_ass_kerugian,tgl_ass_kerugian,tgl_jt_ass_kerugian,jenis_kendaraan,no_bpkb,no_rangka,nama_dealer,merk,no_mesin,no_polisi,status_rekg,tgl_pelunasan,memo,skdr,siup,tdp,others,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,status,tgl_update_app,tgl_update_los,tgl_update_asc,skim_pencairan,input_date,no_covernote,no_covernote_n,no_pengikatan_n,tgl_penyerahan_berkas,proses_pengikatan,jenis_sertifikat,jenis_proyek,kategori_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,no_polis_ass_kerugian_n,berkas_asuransi_kerugian,no_polis_ass_jiwa_n,berkas_assuransi_jiwa,no_jaminan_fleksi,no_jaminan_fleksi_n,jns_jaminan_fleksi,srt_pernyataan_fleksi,no_bpkb_n,tgl_serah,pelunasan_penerima,pelunasan_keterangan,siup_n,tdp_n,no_pks,tgl_pengikatan,others_n,kjpp_flag,no_ajb_n,jml_jaminan_n,userupdate,insertfrom,no_trail) values(";
for ($col = 1; $col <= 156; $col++) {
$value = $data->val($row, $col);
$sql .= "'" . $value . "',";
}
$sql = substr($sql, 0, strlen($sql) - 1);
$sql .= ")";
$pesan = $db_function->exec($sql);
if ($pesan != "") {
$_SESSION['colateral']['message_loop'][] = "[insrt debitur trail]no_rekg_pinjaman->" . $data->val($row, 7) . ":" . $pesan;
}
}
}
/*
$listTypeLookup=array();
$rows=$db_function->selectAllRows("select distinct type from lookup order by type asc");
foreach($rows as $row){
$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) {
