$kategori = $purifier->purify($_POST["kategori"]);
$data = array("kategori_institusi" => "{$kategori_institusi}", "tingkat" => "{$tingkat}", "nama_institusi" => "{$nama_institusi}", "kelas" => "{$kelas}", "jenis_institusi" => "{$jenis_institusi}", "nama_bidang" => "{$nama_bidang}", "nama_yayasan" => "{$nama_yayasan}", "nama_sekolah" => "{$nama_sekolah}", "alamat_sekolah" => "{$alamat_sekolah}", "kota" => "{$kota}", "mulaibelajar" => "{$mulaibelajar}", "periode_belajar-start" => "{$periode_belajar_start}", "periode_belajar-end" => "{$periode_belajar_end}", "kode" => "{$kode}", "lamaijin" => "{$lamaijin}", "ket_program" => "{$ket_program}", "penyelenggara_program" => "{$penyelenggara_program}", "kategori" => "{$kategori}");
break;
case 3:
$nmrpaspor = $purifier->purify($_POST["nmrpaspor"]);
$mulaipassport = $UTILITY->format_tanggal_db($_POST["mulaipassport"]);
$akhirpassport = $UTILITY->format_tanggal_db($_POST["akhirpassport"]);
//$passport1=$purifier->purify($_POST["passport1"]);
$pembiayaan_idpembiayaan = $purifier->purify($_POST["pembiayaan_idpembiayaan"]);
$sumber_pembiayaan = $purifier->purify($_POST["sumber_pembiayaan"]);
// $keuangan=$purifier->purify($_POST["keuangan"]);
//$pernyataan1=$purifier->purify($_POST["pernyataan1"]);
//$kesehatan=$purifier->purify($_POST["kesehatan"]);
//$loa=$purifier->purify($_POST["loa"]);
$ijazah = upload_for_mahasiswa("ijazah", $kode, 3, $path_upload);
$passport1 = upload_for_mahasiswa("passport1", $kode, 3, $path_upload);
$keuangan = $_POST["keuangan"];
//upload_for_mahasiswa("keuangan", $kode, 3, $path_upload);
$pernyataan1 = $_POST["pernyataan1"];
//upload_for_mahasiswa("pernyataan1", $kode, 3, $path_upload);
$kesehatan = $_POST["kesehatan"];
//upload_for_mahasiswa("kesehatan", $kode, 3, $path_upload);
$loa = $_POST["loa"];
//upload_for_mahasiswa("loa", $kode, 1, $path_upload);
if ($keuangan == "" || $pernyataan1 == "" || $kesehatan == "" || ($loa = "")) {
$status = 6;
}
$kategori = $purifier->purify($_POST["kategori"]);
$data = array("nmrpaspor" => "{$nmrpaspor}", "mulaipassport" => "{$mulaipassport}", "akhirpassport" => "{$akhirpassport}", "passport1" => "{$passport1}", "pembiayaan_idpembiayaan" => "{$pembiayaan_idpembiayaan}", "sumber_pembiayaan" => "{$sumber_pembiayaan}", "keuangan" => "{$keuangan}", "pernyataan1" => "{$pernyataan1}", "kesehatan" => "{$kesehatan}", "loa" => "{$loa}", "ijazah" => "{$ijazah}", "kode" => "{$kode}", "kategori" => "{$kategori}");
//save and finish
$username = $_POST["idmahasiswa"];
$mulaipassport = $UTILITY->format_tanggal_db($_POST["mulaipassport"]);
$akhirpassport = $UTILITY->format_tanggal_db($_POST["akhirpassport"]);
//$passport1=$purifier->purify($_POST["passport1"]);
$pembiayaan_idpembiayaan = $purifier->purify($_POST["pembiayaan_idpembiayaan"]);
$sumber_pembiayaan = $purifier->purify($_POST["sumber_pembiayaan"]);
// $keuangan=$purifier->purify($_POST["keuangan"]);
//$pernyataan1=$purifier->purify($_POST["pernyataan1"]);
//$kesehatan=$purifier->purify($_POST["kesehatan"]);
//$loa=$purifier->purify($_POST["loa"]);
$jabatan_penjamin = $purifier->purify($_POST["jabatan_penjamin"]);
$ijazah = upload_for_mahasiswa("ijazah", $kode, 3, $path_upload);
$passport1 = upload_for_mahasiswa("passport1", $kode, 3, $path_upload);
$keuangan = upload_for_mahasiswa("keuangan", $kode, 3, $path_upload);
$pernyataan1 = upload_for_mahasiswa("pernyataan1", $kode, 3, $path_upload);
$kesehatan = upload_for_mahasiswa("kesehatan", $kode, 3, $path_upload);
$loa = upload_for_mahasiswa("loa", $kode, 3, $path_upload);
$jml_kitas = $purifier->purify($_POST["jml_kitas"]);
$data = array("nmrpaspor" => "{$nmrpaspor}", "mulaipassport" => "{$mulaipassport}", "akhirpassport" => "{$akhirpassport}", "passport1" => "{$passport1}", "pembiayaan_idpembiayaan" => "{$pembiayaan_idpembiayaan}", "sumber_pembiayaan" => "{$sumber_pembiayaan}", "keuangan" => "{$keuangan}", "pernyataan1" => "{$pernyataan1}", "kesehatan" => "{$kesehatan}", "loa" => "{$loa}", "ijazah" => "{$ijazah}", "kode" => "{$kode}", "jabatan_penjamin" => "{$jabatan_penjamin}", "jml_kitas" => "{$jml_kitas}");
break;
}
if ($kondisi == "account") {
$username = $_POST["idmahasiswa"];
$password = $UTILITY->sha512($_POST["login_password"]);
$universitas_iduniversitas = $_POST["universitas_iduniversitas"];
$user_id = $DB->get_auto_increment("user");
$tgl_update = date("Y-m-d");
$qWhere = array("userlogin" => $username);
$data = $USER->readUser($qWhere);
if ($data != "") {
$jData = count($data);
} else {
//$passport1=$purifier->purify($_POST["passport1"]);
$pembiayaan_idpembiayaan = $purifier->purify($_POST["pembiayaan_idpembiayaan"]);
$sumber_pembiayaan = $purifier->purify($_POST["sumber_pembiayaan"]);
// $keuangan=$purifier->purify($_POST["keuangan"]);
//$pernyataan1=$purifier->purify($_POST["pernyataan1"]);
//$kesehatan=$purifier->purify($_POST["kesehatan"]);
//$loa=$purifier->purify($_POST["loa"]);
$jabatan_penjamin = $purifier->purify($_POST["jabatan_penjamin"]);
$ijazah = upload_for_mahasiswa("ijazah", $kode, 3, $path_upload);
$passport1 = upload_for_mahasiswa("passport1", $kode, 3, $path_upload);
$keuangan = upload_for_mahasiswa("keuangan", $kode, 3, $path_upload);
$pernyataan1 = upload_for_mahasiswa("pernyataan1", $kode, 3, $path_upload);
$kesehatan = upload_for_mahasiswa("kesehatan", $kode, 3, $path_upload);
// $loa = upload_for_mahasiswa("loa", $kode, 3, $path_upload);
$kitas = upload_for_mahasiswa("kitas", "{$kode}", 1, $path_upload);
$skld = upload_for_mahasiswa("skld", "{$kode}", 1, $path_upload);
$tgl_kitas = $UTILITY->format_tanggal_db($_POST["tgl_kitas"]);
$tgl_skld = $UTILITY->format_tanggal_db($_POST["tgl_skld"]);
$tgl_kitas_akhir = $UTILITY->format_tanggal_db($_POST["tgl_kitas_akhir"]);
$no_kitas = $purifier->purify($_POST["no_kitas"]);
$no_skld = $purifier->purify($_POST["no_skld"]);
//$dok_mou = upload_for_mahasiswa("dok_mou", $kode, 3, $path_upload);
$jml_kitas = $purifier->purify($_POST["jml_kitas"]);
$data = array("nmrpaspor" => "{$nmrpaspor}", "mulaipassport" => "{$mulaipassport}", "akhirpassport" => "{$akhirpassport}", "passport1" => "{$passport1}", "pembiayaan_idpembiayaan" => "{$pembiayaan_idpembiayaan}", "sumber_pembiayaan" => "{$sumber_pembiayaan}", "keuangan" => "{$keuangan}", "pernyataan1" => "{$pernyataan1}", "kesehatan" => "{$kesehatan}", "loa" => "{$loa}", "kode" => "{$kode}", "kitas" => "{$kitas}", "skld" => "{$skld}", "tgl_kitas" => "{$tgl_kitas}", "tgl_skld" => "{$tgl_skld}", "no_kitas" => "{$no_kitas}", "no_skld" => "{$no_skld}", "ijazah" => "{$ijazah}", "tgl_kitas_akhir" => "{$tgl_kitas_akhir}", "jabatan_penjamin" => "{$jabatan_penjamin}", "jml_kitas" => "{$jml_kitas}");
break;
}
if ($kondisi == "account") {
$username = $_POST["idmahasiswa"];
$password = $UTILITY->sha512($_POST["login_password"]);
$universitas_iduniversitas = $_POST["universitas_iduniversitas"];
$user_id = $DB->get_auto_increment("user");
//$kesehatan=$purifier->purify($_POST["kesehatan"]);
//$loa=$purifier->purify($_POST["loa"]);
$ijazah = upload_for_mahasiswa("ijazah", $kode, 3, $path_upload);
$passport1 = upload_for_mahasiswa("passport1", $kode, 3, $path_upload);
$keuangan = $_POST["keuangan"];
//upload_for_mahasiswa("keuangan", $kode, 3, $path_upload);
$pernyataan1 = $_POST["pernyataan1"];
//upload_for_mahasiswa("pernyataan1", $kode, 3, $path_upload);
$kesehatan = $_POST["kesehatan"];
//upload_for_mahasiswa("kesehatan", $kode, 3, $path_upload);
$ket_bekerja = $_POST["ket_bekerja"];
//("kesehatan", $kode, 3, $path_upload);
$loa = upload_for_mahasiswa("loa", $kode, 1, $path_upload);
$kitas = upload_for_mahasiswa("kitas", "{$kode}", 1, $path_upload);
$skld = upload_for_mahasiswa("skld", "{$kode}", 1, $path_upload);
$imta = upload_for_mahasiswa("imta", "{$kode}", 1, $path_upload);
$tgl_kitas = $UTILITY->format_tanggal_db($_POST["tgl_kitas"]);
$tgl_skld = $UTILITY->format_tanggal_db($_POST["tgl_skld"]);
$tgl_kitas_akhir = $UTILITY->format_tanggal_db($_POST["tgl_kitas_akhir"]);
$no_kitas = $purifier->purify($_POST["no_kitas"]);
$no_skld = $purifier->purify($_POST["no_skld"]);
$no_imta = $purifier->purify($_POST["no_imta"]);
$data = array("eks" => 'true', "nmrpaspor" => "{$nmrpaspor}", "mulaipassport" => "{$mulaipassport}", "akhirpassport" => "{$akhirpassport}", "passport1" => "{$passport1}", "pembiayaan_idpembiayaan" => "{$pembiayaan_idpembiayaan}", "sumber_pembiayaan" => "{$sumber_pembiayaan}", "keuangan" => "{$keuangan}", "pernyataan1" => "{$pernyataan1}", "kesehatan" => "{$kesehatan}", "ket_bekerja" => "{$ket_bekerja}", "kode" => "{$kode}", "kitas" => "{$kitas}", "skld" => "{$skld}", "imta" => "{$imta}", "tgl_kitas" => "{$tgl_kitas}", "tgl_skld" => "{$tgl_skld}", "no_kitas" => "{$no_kitas}", "no_skld" => "{$no_skld}", "no_imta" => "{$no_imta}", "ijazah" => "{$ijazah}", "tgl_kitas_akhir" => "{$tgl_kitas_akhir}");
//kondisi account
$username = $_POST["idmahasiswa"];
$password = $UTILITY->sha512($_POST["login_password"]);
$mahasiswa_universitas_iduniversitasrsitas = $_POST["universitas_iduniversitas"];
$user_id = $DB->get_auto_increment("user");
$qWhere = array("userlogin" => $username);
$udata = $USER->readUser($qWhere);
// echo("user :".$username);
