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) {