$month = intval(substr($buf['tgl'], 2, 2));
$year = intval(substr($buf['tgl'], 4, 4));
if (!checkdate($month, $day, $year)) {
$chekNoaplikasi = false;
$error_format = "Nomor Aplikasi format tanggal salah";
}
$program_kd = $buf['program_kd'];
$cab_kd = $buf['cab_kd'];
$_POST['frm']['input_date'] = substr($buf['tgl'], 0, 2) . "-" . substr($buf['tgl'], 2, 2) . "-" . substr($buf['tgl'], 4, 4);
$_POST['frm']['lnc'] = cleanstr($db_function->selectOnefield("select singkatan from master_cab where cab_kd='" . $buf['cab_kd'] . "'"));
$lnc = $_POST['frm']['lnc'];
if ($lnc == "") {
$chekNoaplikasi = false;
$error_format = "Nomor Aplikasi LNC salah";
}
$buf = $db_function->selectOneRows("select prog.program_nm,prod.produk_kd,prod.produk_nm from master_program prog \r\n left join master_produk prod on prog.produk_kd=prod.produk_kd\r\n where prog.program_kd='" . $buf['program_kd'] . "'\r\n ");
$produk_kd = "";
if (!empty($buf)) {
$_POST['frm']['produk'] = $buf['produk_nm'];
$_POST['frm']['program'] = $buf['program_nm'];
$produk_kd = $buf['produk_kd'];
} else {
$_POST['frm']['produk'] = "";
$_POST['frm']['program'] = "";
$chekNoaplikasi = false;
$error_format = "Nomor Aplikasi tidak di temukan produk & program";
}
// . "-" . substr($buf['tgl'], 2, 2) . "-" . substr($buf['tgl'], 4, 4)
/*
01 BNI GRIYA
02 BNI OTO
$showInformasiOto = false;
$showDtLunas = false;
$showForm = true;
$showInformasiLain = true;
$showEmergencyKon = true;
$messageBox = "";
$pesanError = array();
$program_kd = "";
$cab_kd = "";
$lnc = "*";
//$messageBox = showMessage("<div>Data Telah di simpan</div>","notice");
$no_trail = $_GET['no_trail'];
$_POST['frm']['no_trail'] = $no_trail;
$trailSekarang;
$trailSebelum;
$buf = $db_function->selectOneRows("select * from debitur_trail where no_rekg_pinjaman='" . $_GET['id'] . "' and no_trail='" . $_GET['no_trail'] . "'");
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);
$developerLama = "";
$skim_pencairanLama = "";
$siupLama = "";
$tdpLama = "";
$otherLama = "";
$no_polis_ass_kerugianLama = "";
$jenis_kendaraanLama = "";
$merkLama = "";
$asuransi_jiwaLama = "";
$asuransi_kerugianLama = "";
$berkas_asuransi_kerugianLama = "";
$no_polis_ass_jiwaLama = "";
$kendalaLama = "";
$jenis_sertifikatLama = "";
if (empty($_POST)) {
$buf = $db_function->selectOneRows("select * from debitur where no_rekg_pinjaman='" . $_GET['id'] . "'");
// print_r($_POST);
foreach ($buf as $key => $val) {
if (!is_int($key)) {
$_POST['frm'][strtolower($key)] = isDateDB($val) ? balikTgl($val) : $val;
}
}
$_POST['frm']['produk'] = strtoupper($_POST['frm']['produk']);
$produkLama = $_POST['frm']['produk'];
$programLama = $_POST['frm']['program'];
$agamaLama = $_POST['frm']['agama'];
$kelaminLama = $_POST['frm']['kelamin'];
$skdrLama = $_POST['frm']['skdr'];
$jaminanLama = $_POST['frm']['jaminan'];
$proses_agunanLama = $_POST['frm']['proses_agunan'];
$jenis_surat_tanahLama = $_POST['frm']['jenis_surat_tanah'];
<?php
session_start();
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
if (!empty($_SESSION['colateral'])) {
header('location:start.php');
}
$errorBox = "";
$db_function = new db_function();
if (!empty($_POST)) {
$pesanError = array();
$dataUser = $db_function->selectOneRows("select * from pegawai where npp='" . $_POST['frm']['npp'] . "'");
if (empty($dataUser)) {
array_push($pesanError, "Pegawai Tidak Terdaftar");
} elseif ($dataUser['PASSWORD'] != $_POST['frm']['password']) {
array_push($pesanError, "Password salah");
} else {
$_SESSION['colateral']['npp'] = $dataUser["NPP"];
$_SESSION['colateral']['nama'] = $dataUser["NAMA"];
$_SESSION['colateral']['jabatan'] = $dataUser["JABATAN"];
$_SESSION['colateral']['cabang'] = $dataUser["CABANG"];
$_SESSION['colateral']['group'] = $dataUser["group"];
header('location:start.php');
}
$errorBox = showMessage($pesanError);
}
function json_nomor_aplikasi()
{
$db_function = new db_function();
$dataprint = array('status' => 'gagal');
$noaplikasi = $_GET['noaplikasi'];
if (strlen($noaplikasi) == 20) {
$buf['tgl'] = substr($noaplikasi, 0, 8);
$buf['program_kd'] = substr($noaplikasi, 8, 2);
$buf['cab_kd'] = substr($noaplikasi, 10, 5);
$program_kd = $buf['program_kd'];
$cab_kd = $buf['cab_kd'];
$inputdate = substr($buf['tgl'], 0, 2) . "-" . substr($buf['tgl'], 2, 2) . "-" . substr($buf['tgl'], 4, 4);
$lnc = cleanstr($db_function->selectOnefield("select singkatan from master_cab where cab_kd='" . $buf['cab_kd'] . "'"));
$buf = $db_function->selectOneRows("select prog.program_nm,prod.produk_kd,prod.produk_nm from master_program prog \n left join master_produk prod on prog.produk_kd=prod.produk_kd\n where prog.program_kd='" . $buf['program_kd'] . "'\n ");
$produk_kd = "";
$program = "";
$produk = "";
if (!empty($buf)) {
$produk = $buf['produk_nm'];
$program = $buf['program_nm'];
$produk_kd = $buf['produk_kd'];
}
$ListProgram = getlistProgram($produk);
if ($produk != "") {
$dataprint = array('status' => 'sukses', 'listProgram' => $ListProgram, 'field' => array('produk' => $produk, 'program' => $program, 'inputdate' => $inputdate, 'lnc' => $lnc));
}
}
echo json_encode($dataprint);
exit;
}
