'."\n";
$response = json_decode($response);
$status = $response->status;
if (empty($status)) {
return false;
}
//echo '$response->data->custCode = '.$response->data->custCode." \n";
if (!empty($response->data->custCode)) {
return true;
}
return false;
}
function lulus_ujian($thn,$gel,$no_ujian,$prodi_diterima,$file_pendukung='',$keterangan_tes_kesehatan,$status_tes_kesehatan) {
global $CONFIG,$con2,$conn;
$keterangan_tes_kesehatan = strip_s($keterangan_tes_kesehatan);
$keterangan_tes_kesehatan = add_s($keterangan_tes_kesehatan);
$con2 = $_SESSION[$cookiename]['con2'];
//mysqli_select_db($dbmhs_mysql,$con);
$now=date("Y-m-d H:i:s");
//$connect=odbc_connect($CONFIG['mssql']['db_host'],$CONFIG['mssql']['db_user'],$CONFIG['mssql']['db_password']);
//$db=odbc_select_db($CONFIG['mssql']['db_name'],$conn);
$tahun_akademik=$thn;
$gelombang=$gel;
$no_ujian=trim($no_ujian);
$sql_cari="select * from TM_FORMULIR_YG_TERBAYAR where NO_UJIAN='$no_ujian'";
$query_cari=cmd_query($sql_cari);
$hasil_cari=cmd_fetch_array($query_cari);
$prodi_diterima = $hasil_cari['KD_PRODI_TAHAP1'];
$ujian_tahap1 = $hasil_cari['UJIAN_TAHAP1'];
if (empty($prodi_diterima)) {
return false;
}
/*
if ($ujian_tahap1 == 'L' AND ) {
}
*/
$s = "SELECT * FROM TR_KODE_PROGRAM_STUDI WHERE KD_PROGRAM_STUDI='$prodi_diterima'";
$h = cmd_query($s);
$r = cmd_fetch_array($h);
$kd_fakultas = $r['KD_FAKULTAS'];
$kd_program_studi = $r['KD_PROGRAM_STUDI'];
switch ($kd_fakultas) {
case "1":
$l_fakultas = 4;
break;
case "8":
$l_fakultas = 6;
break;
case "2":
$l_fakultas = 3;
break;
case "3":
$l_fakultas = 2;
break;
case "4":
$l_fakultas = 1;
break;
case "6" :
$l_fakultas = 5;
break;
case "7" :
$l_fakultas = 7;
break;
}
switch ($kd_program_studi) {
case "10":
$l_program_studi=2;
break;
case "70":
$l_program_studi=10;
break;
case "20":
$l_program_studi=6;
break;
case "21":
$l_program_studi=7;
break;
case "40":
$l_program_studi=3;
break;
case "411":
$l_program_studi=13;
break;
case "412":
$l_program_studi=12;
break;
case "50":
$l_program_studi=4;
break;
case "30":
$l_program_studi=5;
break;
case "60":
$l_program_studi=1;
break;
case "210":
$l_program_studi=8;
break;
case "220":
$l_program_studi=9;
break;
case "230":
$l_program_studi=11;
break;
case "240":
$l_program_studi=15;
break;
case "310":
$l_program_studi=14;
break;
}
$today=date("Y-m-d H:i:s");
$sa = "SELECT * FROM pmb_akademik_semester WHERE aktif_akademik_semester='Y' LIMIT 1";
$ha = cmd_query($sa);
$ra = cmd_fetch_array($ha);
$l_akademik_semester = $ra['id_akademik_semester'];
if ($rangking=="D" || $rangking=="T"){
$tunggu=$no_urut;
} else {
$tunggu=0;
}
$tot = 0;
$_error = array(); $_err_point = array();
if (!empty($hasil_cari['NO_UJIAN'])) {
$gel = $hasil_cari['GELOMBANG'];
$tahun_akademik = $hasil_cari['TAHUN_AKADEMIK'];
$sql_ = "SELECT COUNT(*) FROM TM_CALON_LULUS_UJIAN_DITERIMA WHERE NO_UJIAN='".$hasil_cari['NO_UJIAN']."'";
$h_ = cmd_query($sql_);
list($tot) = cmd_fetch_array($h_);
//exit('$tot = '.$tot);
if ($tot < 1) {
$gen_npm = false;
if ($gen_npm) {
if ($kd_program_studi == "70") $kdprodi = '11';
else $kdprodi = $kd_program_studi;
if (strlen($kdprodi) == 3) {
$npm_check = $kdprodi.$tahun_akademik.'001';
} else
$npm_check = '1'.$kdprodi.$tahun_akademik.'001';
//$sn = "SELECT COUNT(*) FROM TM_CALON_LULUS_UJIAN_DITERIMA WHERE KD_FAKULTAS='$kd_fakultas' AND KD_PROGRAM_STUDI='$kd_program_studi' AND NPM='$npm_check'";
$sn = "SELECT MAX(NPM) FROM TM_CALON_LULUS_UJIAN_DITERIMA WHERE KD_FAKULTAS='$kd_fakultas'
AND KD_PROGRAM_STUDI='$kd_program_studi' AND TAHUN_AKADEMIK='$tahun_akademik'";
$hn = cmd_query($sn);
list($last_npm) = cmd_fetch_array($hn);
if (strlen($last_npm) != 10) {
$npm = $npm_check;
} else {
$npm = $last_npm;
}
$sn = "SELECT COUNT(*) FROM TM_CALON_LULUS_UJIAN_DITERIMA WHERE KD_FAKULTAS='$kd_fakultas' AND KD_PROGRAM_STUDI='$kd_program_studi' AND NPM='$npm'";
$hn = cmd_query($sn);
list($tot_npm) = cmd_fetch_array($hn);
if ($tot_npm > 0) {
$sn = "SELECT MAX(NPM) FROM TM_CALON_LULUS_UJIAN_DITERIMA WHERE KD_FAKULTAS='$kd_fakultas'
AND KD_PROGRAM_STUDI='$kd_program_studi' AND TAHUN_AKADEMIK='$tahun_akademik'";
$hn = cmd_query($sn);
list($last_npm) = cmd_fetch_array($hn);
$npm = $last_npm + 1;
} else {
$npm = $npm_check;
}
}
$keterangan_file_pendukung = $file_pendukung;
$check_file_pendukung = true;
if (!empty($keterangan_file_pendukung['name'])) {
$file_rename = '';
if (preg_match("/(.+)\.(.*?)\Z/", $keterangan_file_pendukung['name'], $matches)) {
$ext = trim($matches[2]);
$file_rename = $no_ujian.'_doc_kesehatan';
}
$res_ops = upload_file($keterangan_file_pendukung, 'file_pendukung', $check_file_pendukung, $keterangan_file_pendukung['name'], false, false, $file_rename);
$file_pendukung = $res_ops[0];
if (count($res_ops[1] > 0)) $_error = array_merge($_error,$res_ops[1]);
if (count($res_ops[2] > 0)) $_err_point = array_merge($_err_point,$res_ops[2]);
$add_file = ",FILE_DOKUMEN_PENDUKUNG='$file_pendukung'";
} else {
$file_pendukung = '';
$add_file = "";
}
if (count($_error) > 0) {
die(implode(' ',$_error));
}
$sql_insert="INSERT INTO TM_CALON_LULUS_UJIAN_DITERIMA (NAMA_CALON_MHS,ALAMAT_CALON_MHS,KD_POS_CALON_MHS,
AGAMA,NO_PENDAFTARAN,TEMPAT_LAHIR,TAHUN_LAHIR,BULAN_LAHIR,TANGGAL_LAHIR,GELOMBANG,TAHUN_AKADEMIK,TGL_UPDATE,TGL_INPUT,
NILAI_STTB,NO_RUANG_UJIAN,LOKASI_UJIAN,NO_TLP_CALON_MHS,KD_AREA_TLP,STATUS_KELULUSAN,NO_UJIAN,JENIS_KELAMIN,NO_HP_CALON_MHS,
IJAZAH_CALON_MHS,KEWARGANEGARAAN,ASAL_SEKOLAH_CALON_MHS,ALAMAT_SEKOLAH_CALON_MHS,KD_POS_SEKOLAH_CALON_MHS,HARI_UJIAN,JAM_UJIAN,
TAHUN_IJAZAH,KODE_IJAZAH,KOTA_KAB,KOTA_KAB_SEKOLAH,KODE_KOTA_KAB,KODE_KOTA_KAB_SEKOLAH,PROVINSI,PROVINSI_SEKOLAH,KODE_PROVINSI,
KODE_PROVINSI_SEKOLAH,TANGGAL_UJIAN,PASSWD,NIK,RT,RW,JENIS_KELAS,STATUS_AWAL,EMAIL,TGL_DITERIMA_TAHAP1)
SELECT NAMA_CALON_MHS,ALAMAT_CALON_MHS,KD_POS_CALON_MHS,AGAMA,NO_PENDAFTARAN,TEMPAT_LAHIR,TAHUN_LAHIR,BULAN_LAHIR,TANGGAL_LAHIR,
GELOMBANG,TAHUN_AKADEMIK,TGL_UPDATE,TGL_INPUT,NILAI_STTB,NO_RUANG_UJIAN,LOKASI_UJIAN,NO_TLP_CALON_MHS,KD_AREA_TLP,STATUS_KELULUSAN,
NO_UJIAN,JENIS_KELAMIN,NO_HP_CALON_MHS,IJAZAH_CALON_MHS,KEWARGANEGARAAN,ASAL_SEKOLAH_CALON_MHS,ALAMAT_SEKOLAH_CALON_MHS,
KD_POS_SEKOLAH_CALON_MHS,HARI_UJIAN,JAM_UJIAN,TAHUN_IJAZAH,KODE_IJAZAH,KOTA_KAB,KOTA_KAB_SEKOLAH,KODE_KOTA_KAB,
KODE_KOTA_KAB_SEKOLAH,PROVINSI,PROVINSI_SEKOLAH,KODE_PROVINSI,KODE_PROVINSI_SEKOLAH,TANGGAL_UJIAN,PASSWD,NIK,RT,RW,JENIS_KELAS,
STATUS_AWAL,EMAIL,TGL_DITERIMA_TAHAP1
FROM TM_FORMULIR_YG_TERBAYAR
WHERE NO_UJIAN='$hasil_cari[NO_UJIAN]'";
$query_insert=cmd_query($sql_insert);
$sql_ = "UPDATE TM_CALON_LULUS_UJIAN_DITERIMA SET TGL_INPUT='$today' $add_file WHERE NO_UJIAN='$hasil_cari[NO_UJIAN]'";
$h_ = cmd_query($sql_);
list($id_last) = cmd_last_insert_id();
if (!$gen_npm) {
$npm = '';
}
$sql_update="update TM_CALON_LULUS_UJIAN_DITERIMA set KD_FAKULTAS='$kd_fakultas',KD_PROGRAM_STUDI='$kd_program_studi',
STATUS_PEMBAYARAN='0',STATUS_KELULUSAN='1',TGL_UPDATE='$today',WAKTU_PILIHAN='1',
KETERANGAN_PENDUKUNG='$keterangan_tes_kesehatan',STATUS_TES_KESEHATAN='$status_tes_kesehatan',
RANKING='$rangking',SEMESTER='1',NILAI_UJIAN='$nilai',TUNGGU='$tunggu',NPM='$npm'
where NO_UJIAN='$no_ujian'";
$query_update=cmd_query($sql_update);
$sql_update="update TM_FORMULIR_YG_TERBAYAR set STATUS_TES_KESEHATAN='$status_tes_kesehatan',KETERANGAN_PENDUKUNG='$keterangan_tes_kesehatan' $add_file
where NO_UJIAN='$no_ujian'";
$query_update=cmd_query($sql_update);
$sh = "SELECT * FROM TM_CALON_LULUS_UJIAN_DITERIMA WHERE NO_UJIAN='$hasil_cari[NO_UJIAN]'";
$hh = cmd_query($sh);
$rh = cmd_fetch_array($hh);
$nama_mahasiswa = stripslashes($rh['NAMA_CALON_MHS']);
$alamat_mahasiswa = stripslashes($rh['ALAMAT_CALON_MHS']);
$no_ujian = $hasil_cari['NO_UJIAN'];
$no_pendaftaran = $rh['NO_PENDAFTARAN'];
$tempat_lahir = stripslashes($rh['TEMPAT_LAHIR']);
$tanggal_lahir = $rh['TAHUN_LAHIR'].'-'.$rh['BULAN_LAHIR'].'-'.$rh['TANGGAL_LAHIR'];
$so = "SELECT * FROM TM_ORANG_TUA_CALON_MHS WHERE NO_PENDAFTARAN='".$rh['NO_PENDAFTARAN']."'";
$ho = cmd_query($so);
$ro = cmd_fetch_array($ho);
$nama_ayah_mahasiswa = stripslashes($ro['NAMA_BAPAK']);
$nama_ibu_mahasiswa = stripslashes($ro['NAMA_IBU']);
$alamat_ortu_mahasiswa = stripslashes($ro['ALAMAT_ORANG_TUA']);
$sk = "SELECT * FROM pmb_biaya WHERE angkatan='$tahun_akademik' AND KD_FAKULTAS='$kd_fakultas' AND KD_PROGRAM_STUDI='$kd_program_studi' AND nama_biaya='SPT/PKKMB' LIMIT 1";
$hk = cmd_query($sk);
$rk = cmd_fetch_array($hk);
$total_tagihan = $rk['jumlah'];
if (!empty($total_tagihan)) {
$sk = "INSERT INTO pmb_tagihan (l_jenis_biaya,l_peserta,total_tagihan,created_by,created_date,update_by,update_date)
VALUES ('8','$no_pendaftaran','$total_tagihan','1','$today','1','$today')";
$hk = cmd_query($sk);
}
for ($k=1; $k<=6; $k++) {
$sk = "SELECT * FROM pmb_biaya WHERE angkatan='$tahun_akademik' AND KD_FAKULTAS='$kd_fakultas' AND KD_PROGRAM_STUDI='$kd_program_studi' AND nama_biaya='BPP' LIMIT 1";
$hk = cmd_query($sk);
$rk = cmd_fetch_array($hk);
$total_tagihan = $rk['cicilan_'.$k];
$l_biaya = $rk['id_biaya'];
$sk = "SELECT * FROM pmb_jenis_biaya WHERE kd_jenis_biaya='C$k' LIMIT 1";
$hk = cmd_query($sk);
$rk = cmd_fetch_array($hk);
$l_jenis_biaya = $rk['id_jenis_biaya'];
if (!empty($l_biaya) && !empty($total_tagihan)) {
$st = "INSERT INTO pmb_tagihan (l_jenis_biaya,l_akademik_semester,no_pendaftaran,total_tagihan,created_by,created_date,update_by,update_date)
VALUES ('$l_jenis_biaya','$l_akademik_semester','$no_pendaftaran','$total_tagihan','1','$today','1','$today')";
$ht = cmd_query($st);
}
}
$sk = "SELECT * FROM pmb_biaya WHERE angkatan='$tahun_akademik' AND KD_FAKULTAS='$kd_fakultas' AND KD_PROGRAM_STUDI='$kd_program_studi' AND nama_biaya='BPP' LIMIT 1";
$hk = cmd_query($sk);
$rk = cmd_fetch_array($hk);
$total_tagihan = $rk['jumlah'];
$l_biaya = $rk['id_biaya'];
if (!empty($l_biaya)) {
$sk = "INSERT INTO pmb_keuangan (l_biaya,l_akademik_semester,kelebihan,kekurangan,lunas,l_peserta,no_pendaftaran)
VALUES ('$l_biaya','$l_akademik_semester','0','0','T','$id_last','$no_pendaftaran')";
$hk = cmd_query($sk);
}
/*$l_fakultas = $kd_fakultas;
$sp = "SELECT * FROM .program_studi WHERE l_fakultas='$l_fakultas' LIMIT 1";
$hp = mysqli_query($con2,$sp) or die("ERROR: $sp ".mysqli_error($con2));
$rp = mysqli_fetch_array($hp);
$l_program_studi = $rp['id_program_studi'];
*/
$kd_status_awal = $rh['STATUS_AWAL'];
$sp = "SELECT * FROM status_awal_mahasiswa WHERE kd_status_awal='$kd_status_awal' LIMIT 1";
$hp = mysqli_query($con2,$sp) or die("ERROR: $sp ".mysqli_error($con2));
$rp = mysqli_fetch_array($hp);
$l_status_awal__mahasiswa = $rp['id_status_awal_mahasiswa'];
$warga_negara = ($rh['KEWARGANEGARAAN'] == 'INDONESIA') ? 'I' : 'A';
$sa = "SELECT * FROM agama WHERE nama_agama LIKE '".$rh['AGAMA']."%' LIMIT 1";
$ha = mysqli_query($con2,$sa) or die("ERROR: $sa ".mysqli_error($con2));
$ra = mysqli_fetch_array($ha);
$id_agama = $ra['id_agama'];
$si = "INSERT INTO mahasiswa (`nama_mahasiswa`, `no_ujian_mahasiswa`, `no_pendaftaran_mahasiswa`,
`nomor_induk_mahasiswa`, `l_fakultas__mahasiswa`, `l_program_studi__mahasiswa`, `l_status_awal__mahasiswa`,
`password_mahasiswa`, `tempat_lahir_mahasiswa`, `tanggal_lahir_mahasiswa`, `jenis_kelamin_mahasiswa`,
`warga_negara_mahasiswa`, `nik_mahasiswa`,
`l_agama__mahasiswa`, `status_nikah_mahasiswa`,
`alamat_mahasiswa`, `rt_alamat_mahasiswa`, `rw_alamat_mahasiswa`,
`kodepos_mahasiswa`, `status_alamat_mahasiswa`, `telp_mahasiswa`, `hp_mahasiswa`, `email_mahasiswa`,
`nama_ayah_mahasiswa`, `nama_ibu_mahasiswa`, `nik_ayah_mahasiswa`, `nik_ibu_mahasiswa`,
`alamat_ortu_mahasiswa`, `kodepos_ortu_mahasiswa`, `telp_ortu_mahasiswa`)
VALUES ('".addslashes($nama_mahasiswa)."','$no_ujian','$no_pendaftaran','$npm','$l_fakultas','$l_program_studi','$l_status_awal__mahasiswa',
'".$rh['PASSWD']."','".addslashes($tempat_lahir)."','$tanggal_lahir','".$rh['JENIS_KELAMIN']."',
'$warga_negara','".$rh['NIK']."','$id_agama','B',
'".addslashes($alamat_mahasiswa)."','".$rh['RT']."','".$rh['RW']."',
'".$rh['KD_POS_CALON_MHS']."','ROT','".$rh['NO_TLP_CALON_MHS']."','".$rh['NO_HP_CALON_MHS']."','".$rh['EMAIL']."',
'".addslashes($nama_ayah_mahasiswa)."','".addslashes($nama_ibu_mahasiswa)."','".$ro['NIK_AYAH']."','".$ro['NIK_IBU']."',
'".addslashes($alamat_ortu_mahasiswa)."','".$ro['KD_POS_ORANG_TUA']."','".$ro['NO_TLP_ORANG_TUA']."'
)";
$hi = mysqli_query($con2,$si) or die("ERROR: $si ".mysqli_error($con2));
$id_mhs = mysqli_insert_id($con2);
$si = "INSERT INTO `user`(`username`, `username_ldap`, `password`, `l_karyawan`, `l_mahasiswa`, `l_role`, `aktif`,
`created_by`, `created_date`, `updated_by`, `updated_date`)
VALUES ('$no_ujian', NULL, md5('".$rh['PASSWD']."'), 0, $id_mhs, 5, 'y',
1, '$tgl_reg', 1, '$tgl_reg')";
$hi = mysqli_query($con2,$si) or die("ERROR: $si ".mysqli_error($con2));
} else {
$sh = "SELECT * FROM TM_CALON_LULUS_UJIAN_DITERIMA WHERE NO_UJIAN='$hasil_cari[NO_UJIAN]'";
$hh = cmd_query($sh);
$rh = cmd_fetch_array($hh);
$nama_mahasiswa = stripslashes($rh['NAMA_CALON_MHS']);
$alamat_mahasiswa = stripslashes($rh['ALAMAT_CALON_MHS']);
$no_ujian = $hasil_cari['NO_UJIAN'];
$no_pendaftaran = $rh['NO_PENDAFTARAN'];
$npm = $rh['NPM'];
$tempat_lahir = stripslashes($rh['TEMPAT_LAHIR']);
$tanggal_lahir = $rh['TAHUN_LAHIR'].'-'.$rh['BULAN_LAHIR'].'-'.$rh['TANGGAL_LAHIR'];
$id_peserta = $rh['ID_CALON_MHS'];
$so = "SELECT * FROM TM_ORANG_TUA_CALON_MHS WHERE NO_PENDAFTARAN='".$rh['NO_PENDAFTARAN']."'";
$ho = cmd_query($so);
$ro = cmd_fetch_array($ho);
$nama_ayah_mahasiswa = stripslashes($ro['NAMA_BAPAK']);
$nama_ibu_mahasiswa = stripslashes($ro['NAMA_IBU']);
$alamat_ortu_mahasiswa = stripslashes($ro['ALAMAT_ORANG_TUA']);
/*
$l_fakultas = $kd_fakultas;
$sp = "SELECT * FROM program_studi WHERE l_fakultas='$l_fakultas' LIMIT 1";
$hp = mysqli_query($con2,$sp) or die("ERROR: $sp ".mysqli_error($con2));
$rp = mysqli_fetch_array($hp);
$l_program_studi = $rp['id_program_studi'];*/
$kd_status_awal = $rh['STATUS_AWAL'];
$sp = "SELECT * FROM status_awal_mahasiswa WHERE kd_status_awal='$kd_status_awal' LIMIT 1";
$hp = mysqli_query($con2,$sp) or die("ERROR: $sp ".mysqli_error($con2));
$rp = mysqli_fetch_array($hp);
$l_status_awal__mahasiswa = $rp['id_status_awal_mahasiswa'];
$warga_negara = ($rh['KEWARGANEGARAAN'] == 'INDONESIA') ? 'I' : 'A';
$sa = "SELECT * FROM agama WHERE nama_agama LIKE '".$rh['AGAMA']."%' LIMIT 1";
$ha = mysqli_query($con2,$sa) or die("ERROR: $sa ".mysqli_error($con2));
$ra = mysqli_fetch_array($ha);
$id_agama = $ra['id_agama'];
for ($k=1; $k<=6; $k++) {
$sb = "SELECT * FROM pmb_biaya WHERE angkatan='$tahun_akademik' AND KD_FAKULTAS='$kd_fakultas' AND KD_PROGRAM_STUDI='$kd_program_studi' AND nama_biaya='BPP' LIMIT 1";
$hb = cmd_query($sb);
$rb = cmd_fetch_array($hb);
$total_tagihan = $rb['cicilan_'.$k];
$l_biaya = $rb['id_biaya'];
$sk = "SELECT * FROM pmb_jenis_biaya WHERE kd_jenis_biaya='C$k' LIMIT 1";
$hk = cmd_query($sk);
$rk = cmd_fetch_array($hk);
$l_jenis_biaya = $rk['id_jenis_biaya'];
if (!empty($total_tagihan) && !empty($l_biaya)) {
$st = "SELECT COUNT(*) FROM pmb_tagihan WHERE l_jenis_biaya='$l_jenis_biaya' AND l_akademik_semester='$l_akademik_semester' AND no_pendaftaran='$no_pendaftaran'";
$ht = cmd_query($st);
list($tot_st) = cmd_fetch_array($ht);
if ($tot_st < 1) {
$st = "INSERT INTO pmb_tagihan (l_jenis_biaya,l_akademik_semester,l_peserta,no_pendaftaran,total_tagihan,created_by,created_date,update_by,update_date)
VALUES ('$l_jenis_biaya','$l_akademik_semester','$id_peserta','$no_pendaftaran','$total_tagihan','1','$today','1','$today')";
$ht = cmd_query($st);
}
}
}
$sk = "SELECT * FROM pmb_biaya WHERE angkatan='$tahun_akademik' AND KD_FAKULTAS='$kd_fakultas' AND KD_PROGRAM_STUDI='$kd_program_studi' AND nama_biaya='BPP' LIMIT 1";
$hk = cmd_query($sk);
$rk = cmd_fetch_array($hk);
$total_tagihan = $rk['jumlah'];
$l_biaya = $rk['id_biaya'];
if (!empty($l_biaya)) {
$st = "SELECT COUNT(*) FROM pmb_keuangan WHERE l_biaya='$l_biaya' AND l_akademik_semester='$l_akademik_semester' AND l_peserta='$id_peserta'";
$ht = cmd_query($st);
list($tot_st) = cmd_fetch_array($ht);
if ($tot_st < 1) {
$sk = "INSERT INTO pmb_keuangan (l_biaya,l_akademik_semester,kelebihan,kekurangan,lunas,l_peserta,no_pendaftaran)
VALUES ('$l_biaya','$l_akademik_semester','0','0','T','$id_peserta','$no_pendaftaran')";
$hk = cmd_query($sk);
}
}
$sc = "SELECT COUNT(*) FROM mahasiswa WHERE no_ujian_mahasiswa='$no_ujian'";
$hc = mysqli_query($con2,$sc) or die("ERROR: $sa ".mysqli_error($con2));
list($tot_sc) = mysqli_fetch_array($hc);
if ($tot_sc > 0) {
$si = "UPDATE mahasiswa SET `nama_mahasiswa`='".addslashes($nama_mahasiswa)."',
`nomor_induk_mahasiswa`='$npm' WHERE no_ujian_mahasiswa='$no_ujian'";
$hi = mysqli_query($con2,$si) or die("ERROR: $si ".mysqli_error($con2));
//echo $si.' ';
} else {
$si = "INSERT INTO mahasiswa (`nama_mahasiswa`, `no_ujian_mahasiswa`, `no_pendaftaran_mahasiswa`,
`nomor_induk_mahasiswa`, `l_fakultas__mahasiswa`, `l_program_studi__mahasiswa`, `l_status_awal__mahasiswa`,
`password_mahasiswa`, `tempat_lahir_mahasiswa`, `tanggal_lahir_mahasiswa`, `jenis_kelamin_mahasiswa`,
`warga_negara_mahasiswa`, `nik_mahasiswa`,
`l_agama__mahasiswa`, `status_nikah_mahasiswa`,
`alamat_mahasiswa`, `rt_alamat_mahasiswa`, `rw_alamat_mahasiswa`,
`kodepos_mahasiswa`, `status_alamat_mahasiswa`, `telp_mahasiswa`, `hp_mahasiswa`, `email_mahasiswa`,
`nama_ayah_mahasiswa`, `nama_ibu_mahasiswa`, `nik_ayah_mahasiswa`, `nik_ibu_mahasiswa`,
`alamat_ortu_mahasiswa`, `kodepos_ortu_mahasiswa`, `telp_ortu_mahasiswa`)
VALUES ('".addslashes($nama_mahasiswa)."','$no_ujian','$no_pendaftaran','$npm','$l_fakultas','$l_program_studi','$l_status_awal__mahasiswa',
'".$rh['PASSWD']."','".addslashes($tempat_lahir)."','$tanggal_lahir','".$rh['JENIS_KELAMIN']."',
'$warga_negara','".$rh['NIK']."','$id_agama','B',
'".addslashes($alamat_mahasiswa)."','".$rh['RT']."','".$rh['RW']."',
'".$rh['KD_POS_CALON_MHS']."','ROT','".$rh['NO_TLP_CALON_MHS']."','".$rh['NO_HP_CALON_MHS']."','".$rh['EMAIL']."',
'".addslashes($nama_ayah_mahasiswa)."','".addslashes($nama_ibu_mahasiswa)."','".$ro['NIK_AYAH']."','".$ro['NIK_IBU']."',
'".addslashes($alamat_ortu_mahasiswa)."','".$ro['KD_POS_ORANG_TUA']."','".$ro['NO_TLP_ORANG_TUA']."'
)";
$hi = mysqli_query($con2,$si) or die("ERROR: $si ".mysqli_error($con2));
$id_mhs = mysqli_insert_id($con2);
$si = "INSERT INTO `user`(`username`, `username_ldap`, `password`, `l_karyawan`, `l_mahasiswa`, `l_role`, `aktif`,
`created_by`, `created_date`, `updated_by`, `updated_date`)
VALUES ('$no_ujian', NULL, md5('".$rh['PASSWD']."'), 0, $id_mhs, 5, 'y',
1, '$tgl_reg', 1, '$tgl_reg')";
$hi = mysqli_query($con2,$si) or die("ERROR: $si ".mysqli_error($con2));
}
}
$brivastats = '';
/*
if (get_token_briva()) {
if (is_briva_exists($rh['NO_PENDAFTARAN'])) {
if (update_briva($rh['NO_PENDAFTARAN'],$nama_mahasiswa)) {
$brivastats .= "Briva updated";
}
} else {
if (create_briva($rh['NO_PENDAFTARAN'],$nama_mahasiswa)) {
$brivastats .= "Briva created";
}
}
}
*/
}
if ($tot == 1) {
$_error = array(); $_err_point = array();
$keterangan_file_pendukung = $file_pendukung;
$check_file_pendukung = true;
if (!empty($keterangan_file_pendukung['name'])) {
$file_rename = '';
if (preg_match("/(.+)\.(.*?)\Z/", $keterangan_file_pendukung['name'], $matches)) {
$ext = trim($matches[2]);
$file_rename = $no_ujian.'_doc_kesehatan';
}
$res_ops = upload_file($keterangan_file_pendukung, 'file_pendukung', $check_file_pendukung, $keterangan_file_pendukung['name'], false, false, $file_rename);
$file_pendukung = $res_ops[0];
if (count($res_ops[1] > 0)) $_error = array_merge($_error,$res_ops[1]);
if (count($res_ops[2] > 0)) $_err_point = array_merge($_err_point,$res_ops[2]);
$add_file = ",FILE_DOKUMEN_PENDUKUNG='$file_pendukung'";
} else {
$file_pendukung = '';
$add_file = "";
}
if (count($_error) > 0) {
die(implode(' ',$_error));
}
$sql_update="update TM_CALON_LULUS_UJIAN_DITERIMA set KD_FAKULTAS='$kd_fakultas',KD_PROGRAM_STUDI='$kd_program_studi',
STATUS_PEMBAYARAN='0',STATUS_KELULUSAN='1',TGL_UPDATE='$today',WAKTU_PILIHAN='1',
RANKING='$rangking',SEMESTER='1',NILAI_UJIAN='$nilai',TUNGGU='$tunggu' $add_file
where NO_UJIAN='$no_ujian'";
$query_update=cmd_query($sql_update);
}
/*
$sql_sesuai="select BIAYA_BPP,BIAYA_KEGIATAN_MHS_BARU,BIAYA_SPP,MINIMUM_CICILAN_PERTAMA,CICILAN_KEDUA from TM_BIAYA_KULIAH
where TAHUN_AKADEMIK='$tahun_akademik' and KD_PROGRAM_STUDI='$kd_program_studi' and KD_FAKULTAS='$kd_fakultas'";
$db=odbc_select_db("KEUANGAN",$conn);
$query_sesuai=cmd_query($sql_sesuai);
$hasil_sesuai=cmd_fetch_array($query_sesuai);
$total_biaya_kuliah=$hasil_sesuai[BIAYA_BPP]+$hasil_sesuai[BIAYA_KEGIATAN_MHS_BARU]+$hasil_sesuai[BIAYA_SPP];
$total_biaya_kuliah=intval($total_biaya_kuliah);
$MINIMUM_CICILAN_PERTAMA = intval($MINIMUM_CICILAN_PERTAMA);
$BIAYA_KEGIATAN_MHS_BARU = intval($BIAYA_KEGIATAN_MHS_BARU);
$BIAYA_BPP = intval($BIAYA_BPP);
$CICILAN_KEDUA = intval($CICILAN_KEDUA);
@extract($hasil_sesuai);
if ($tot < 1) {
$sql_keuangan="insert into TR_MHS_BARU_DAN_BIAYA_KULIAH(TAHUN_AKADEMIK,BIAYA_SPP,TOTAL_BIAYA_KULIAH,
KD_SEMESTER,TAHUN_MASUK,NO_UJIAN,RANKING,MINIMUM_CICILAN_PERTAMA,KD_FAKULTAS,KD_PROGRAM_STUDI,TUNGGAKAN,
GELOMBANG,BIAYA_KEGIATAN_MHS_BARU,BIAYA_BPP,CICILAN_KEDUA) values ('$tahun_akademik','$BIAYA_SPP','$total_biaya_kuliah','1','$tahun_akademik','$no_ujian',
'C','$MINIMUM_CICILAN_PERTAMA','$kd_fakultas','$kd_program_studi','$total_biaya_kuliah','$gelombang','$BIAYA_KEGIATAN_MHS_BARU','$BIAYA_BPP','$CICILAN_KEDUA')";
//echo $sql_keuangan;return;
$db=odbc_select_db("KEUANGAN",$conn);
$query_keuangan=cmd_query($sql_keuangan);
} else {
$sql_keuangan="update TR_MHS_BARU_DAN_BIAYA_KULIAH SET BIAYA_SPP='$BIAYA_SPP',TOTAL_BIAYA_KULIAH='$total_biaya_kuliah',RANKING='$rangking',
MINIMUM_CICILAN_PERTAMA='$MINIMUM_CICILAN_PERTAMA',BIAYA_KEGIATAN_MHS_BARU='$BIAYA_KEGIATAN_MHS_BARU',BIAYA_BPP='$BIAYA_BPP',CICILAN_KEDUA='$CICILAN_KEDUA'
where NO_UJIAN='$no_ujian'";
//echo $sql_keuangan;return;
$db=odbc_select_db("KEUANGAN",$conn);
$query_keuangan=cmd_query($sql_keuangan);
}
*/
//$db=odbc_select_db("REGISTRASI",$conn);
}
function sync_dbmahasiswa($thn,$gel,$no_ujian) {
global $CONFIG,$con,$con2,$conn;
$host_mysql = 'db1.yarsi.ac.id';
$user_mysql = 'website';
$pass_mysql = 'networkwebsite';
$dbmhs_mysql = 'db_mahasiswa';
$dbproxy_mysql = 'proxy';
$keterangan_tes_kesehatan = strip_s($keterangan_tes_kesehatan);
$keterangan_tes_kesehatan = add_s($keterangan_tes_kesehatan);
//$con = mysqli_connect($host_mysql,$user_mysql,$pass_mysql) or die('Can\'t connect to '.$host_mysql.'; '.mysqli_error());
//mysqli_select_db($dbmhs_mysql,$con);
$now=date("Y-m-d H:i:s");
//$connect=odbc_connect($CONFIG['mssql']['db_host'],$CONFIG['mssql']['db_user'],$CONFIG['mssql']['db_password']);
//$db=odbc_select_db($CONFIG['mssql']['db_name'],$conn);
$tahun_akademik=$thn;
$gelombang=$gel;
//if (!get_token_briva()) die("Can't get BRIVA token!");
$no_ujian=trim($no_ujian);
$sql_cari="select * from TM_FORMULIR_YG_TERBAYAR where NO_UJIAN='$no_ujian'";
$query_cari=cmd_query($sql_cari);
$hasil_cari=cmd_fetch_array($query_cari);
$prodi_diterima = $hasil_cari['KD_PRODI_TAHAP1'];
$s = "SELECT * FROM TR_KODE_PROGRAM_STUDI WHERE KD_PROGRAM_STUDI='$prodi_diterima'";
$h = cmd_query($s);
$r = cmd_fetch_array($h);
$kd_fakultas = $r['KD_FAKULTAS'];
$kd_program_studi = $r['KD_PROGRAM_STUDI'];
switch ($kd_fakultas) {
case "1":
$l_fakultas = 4;
break;
case "8":
$l_fakultas = 6;
break;
case "2":
$l_fakultas = 3;
break;
case "3":
$l_fakultas = 2;
break;
case "4":
$l_fakultas = 1;
break;
case "6" :
$l_fakultas = 5;
break;
case "7" :
$l_fakultas = 7;
break;
}
switch ($kd_program_studi) {
case "10":
$l_program_studi=2;
break;
case "70":
$l_program_studi=10;
break;
case "20":
$l_program_studi=6;
break;
case "21":
$l_program_studi=7;
break;
case "40":
$l_program_studi=3;
break;
case "411":
$l_program_studi=13;
break;
case "412":
$l_program_studi=12;
break;
case "50":
$l_program_studi=4;
break;
case "30":
$l_program_studi=5;
break;
case "60":
$l_program_studi=1;
break;
case "210":
$l_program_studi=8;
break;
case "220":
$l_program_studi=9;
break;
case "230":
$l_program_studi=11;
break;
case "240":
$l_program_studi=15;
break;
case "310":
$l_program_studi=14;
break;
}
$today=date("Y-m-d H:i:s");
$sa = "SELECT * FROM pmb_akademik_semester WHERE aktif_akademik_semester='Y' LIMIT 1";
$ha = cmd_query($sa);
$ra = cmd_fetch_array($ha);
$l_akademik_semester = $ra['id_akademik_semester'];
if ($rangking=="D" || $rangking=="T"){
$tunggu=$no_urut;
} else {
$tunggu=0;
}
$tot = 0;
$_error = array(); $_err_point = array();
//exit('$no_ujian = '.$no_ujian);
if (!empty($hasil_cari['NO_UJIAN'])) {
$gel = $hasil_cari['GELOMBANG'];
$tahun_akademik = $hasil_cari['TAHUN_AKADEMIK'];
$sql_ = "SELECT COUNT(*) FROM TM_CALON_LULUS_UJIAN_DITERIMA WHERE NO_UJIAN='".$hasil_cari['NO_UJIAN']."'";
$h_ = cmd_query($sql_);
list($tot) = cmd_fetch_array($h_);
if ($tot == 1) {
$sh = "SELECT * FROM TM_CALON_LULUS_UJIAN_DITERIMA WHERE NO_UJIAN='$hasil_cari[NO_UJIAN]'";
$hh = cmd_query($sh);
$rh = cmd_fetch_array($hh);
$nama_mahasiswa = stripslashes(trim($rh['NAMA_CALON_MHS']));
$alamat_mahasiswa = stripslashes(trim($rh['ALAMAT_CALON_MHS']));
$no_ujian = $hasil_cari['NO_UJIAN'];
$no_pendaftaran = $rh['NO_PENDAFTARAN'];
$npm = $rh['NPM'];
$tempat_lahir = stripslashes(trim($rh['TEMPAT_LAHIR']));
$tanggal_lahir = $rh['TAHUN_LAHIR'].'-'.$rh['BULAN_LAHIR'].'-'.$rh['TANGGAL_LAHIR'];
$id_peserta = $rh['ID_CALON_MHS'];
$so = "SELECT * FROM TM_ORANG_TUA_CALON_MHS WHERE NO_PENDAFTARAN='".$rh['NO_PENDAFTARAN']."'";
$ho = cmd_query($so);
$ro = cmd_fetch_array($ho);
$nama_ayah_mahasiswa = stripslashes(trim($ro['NAMA_BAPAK']));
$nama_ibu_mahasiswa = stripslashes(trim($ro['NAMA_IBU']));
$alamat_ortu_mahasiswa = stripslashes(trim($ro['ALAMAT_ORANG_TUA']));
/*
$l_fakultas = $kd_fakultas;
$sp = "SELECT * FROM $dbmhs_mysql.program_studi WHERE l_fakultas='$l_fakultas' LIMIT 1";
$hp = mysqli_query($con,$sp) or die("ERROR: $sp ".mysqli_error($con));
$rp = mysqli_fetch_array($hp);
$l_program_studi = $rp['id_program_studi'];*/
$kd_status_awal = $rh['STATUS_AWAL'];
$sp = "SELECT * FROM status_awal_mahasiswa WHERE kd_status_awal='$kd_status_awal' LIMIT 1";
$hp = mysqli_query($con2,$sp) or die("ERROR: $sp ".mysqli_error($con2));
$rp = mysqli_fetch_array($hp);
$l_status_awal__mahasiswa = $rp['id_status_awal_mahasiswa'];
$warga_negara = ($rh['KEWARGANEGARAAN'] == 'INDONESIA') ? 'I' : 'A';
$sa = "SELECT * FROM agama WHERE nama_agama LIKE '".$rh['AGAMA']."%' LIMIT 1";
$ha = mysqli_query($con2,$sa) or die("ERROR: $sa ".mysqli_error($con2));
$ra = mysqli_fetch_array($ha);
$id_agama = $ra['id_agama'];
$sc = "SELECT COUNT(*) FROM mahasiswa WHERE no_ujian_mahasiswa='$no_ujian'";
$hc = mysqli_query($con2,$sc) or die("ERROR: $sa ".mysqli_error($con2));
list($tot_sc) = mysqli_fetch_array($hc);
/*
$brivastats = '';
if (is_briva_exists($rh['NO_PENDAFTARAN'])) {
if (update_briva($rh['NO_PENDAFTARAN'],$nama_mahasiswa)) {
$brivastats .= "Briva updated";
}
} else {
if (create_briva($rh['NO_PENDAFTARAN'],$nama_mahasiswa)) {
$brivastats .= "Briva created";
}
}
*/
if ($tot_sc > 0) {
$si = "UPDATE mahasiswa SET `nama_mahasiswa`='".addslashes($nama_mahasiswa)."',
`no_pendaftaran_mahasiswa`='$no_pendaftaran',`nomor_induk_mahasiswa`='$npm',`tempat_lahir_mahasiswa`='".addslashes($tempat_lahir)."',
`tanggal_lahir_mahasiswa`='$tanggal_lahir', `jenis_kelamin_mahasiswa`='".$rh['JENIS_KELAMIN']."',
`warga_negara_mahasiswa`='$warga_negara', `nik_mahasiswa`='".$rh['NIK']."',
`l_agama__mahasiswa`='$id_agama',
`alamat_mahasiswa`='".addslashes($alamat_mahasiswa)."', `rt_alamat_mahasiswa`='".$rh['RT']."', `rw_alamat_mahasiswa`='".$rh['RW']."',
`kodepos_mahasiswa`='".$rh['KD_POS_CALON_MHS']."', `status_alamat_mahasiswa`='ROT',
`telp_mahasiswa`='".$rh['NO_TLP_CALON_MHS']."', `hp_mahasiswa`='".$rh['NO_HP_CALON_MHS']."', `email_mahasiswa`='".$rh['EMAIL']."'
WHERE no_ujian_mahasiswa='$no_ujian'";
$hi = mysqli_query($con2,$si) or die("ERROR: $si ".mysqli_error($con2));
//echo $si.' ';
} else {
$si = "INSERT INTO mahasiswa (`nama_mahasiswa`, `no_ujian_mahasiswa`, `no_pendaftaran_mahasiswa`,
`nomor_induk_mahasiswa`, `l_fakultas__mahasiswa`, `l_program_studi__mahasiswa`, `l_status_awal__mahasiswa`,
`password_mahasiswa`, `tempat_lahir_mahasiswa`, `tanggal_lahir_mahasiswa`, `jenis_kelamin_mahasiswa`,
`warga_negara_mahasiswa`, `nik_mahasiswa`,
`l_agama__mahasiswa`, `status_nikah_mahasiswa`,
`alamat_mahasiswa`, `rt_alamat_mahasiswa`, `rw_alamat_mahasiswa`,
`kodepos_mahasiswa`, `status_alamat_mahasiswa`, `telp_mahasiswa`, `hp_mahasiswa`, `email_mahasiswa`,
`nama_ayah_mahasiswa`, `nama_ibu_mahasiswa`, `nik_ayah_mahasiswa`, `nik_ibu_mahasiswa`,
`alamat_ortu_mahasiswa`, `kodepos_ortu_mahasiswa`, `telp_ortu_mahasiswa`)
VALUES ('".addslashes($nama_mahasiswa)."','$no_ujian','$no_pendaftaran','$npm','$l_fakultas','$l_program_studi','$l_status_awal__mahasiswa',
'".$rh['PASSWD']."','".addslashes($tempat_lahir)."','$tanggal_lahir','".$rh['JENIS_KELAMIN']."',
'$warga_negara','".$rh['NIK']."','$id_agama','B',
'".addslashes($alamat_mahasiswa)."','".$rh['RT']."','".$rh['RW']."',
'".$rh['KD_POS_CALON_MHS']."','ROT','".$rh['NO_TLP_CALON_MHS']."','".$rh['NO_HP_CALON_MHS']."','".$rh['EMAIL']."',
'".addslashes($nama_ayah_mahasiswa)."','".addslashes($nama_ibu_mahasiswa)."','".$ro['NIK_AYAH']."','".$ro['NIK_IBU']."',
'".addslashes($alamat_ortu_mahasiswa)."','".$ro['KD_POS_ORANG_TUA']."','".$ro['NO_TLP_ORANG_TUA']."'
)";
$hi = mysqli_query($con2,$si) or die("ERROR: $si ".mysqli_error($con2));
$id_mhs = mysqli_insert_id($con2);
$si = "INSERT INTO `user`(`username`, `username_ldap`, `password`, `l_karyawan`, `l_mahasiswa`, `l_role`, `aktif`,
`created_by`, `created_date`, `updated_by`, `updated_date`)
VALUES ('$no_ujian', NULL, md5('".$rh['PASSWD']."'), 0, $id_mhs, 5, 'y',
1, '$tgl_reg', 1, '$tgl_reg')";
$hi = mysqli_query($con2,$si) or die("ERROR: $si ".mysqli_error($con2));
}
}
}
//$db=odbc_select_db("REGISTRASI",$conn);
}
function gen_npm($thn,$gel,$no_ujian,$prodi_diterima,$gen_ldap=true,$gen_sisakad=true,$send_email=true,$npm=false) {
global $CONFIG,$con1,$conn,$con_sisakad,$ds,$dbind;
$host_mysql = 'db1.yarsi.ac.id';
$user_mysql = 'website';
$pass_mysql = 'networkwebsite';
$dbmhs_mysql = 'db_mahasiswa';
$dbproxy_mysql = 'proxy';
if (!$con_sisakad) {
$con_sisakad = $_SESSION[$cookiename]['con_sisakad'];
die("Sisakad DB not connected!");
}
//$con1 = mysqli_connect('db3.yarsi.ac.id',$user_mysql,$pass_mysql,$dbproxy_mysql) or die('Can\'t connect to '.$host_mysql.'; '.mysqli_error());
//mysqli_select_db($dbproxy_mysql,$con1);
//$_SESSION[$cookiename]['con1'] = $con1;
$ldap_uname = $CONFIG['ldap_uname'];
$ldap_pw = $CONFIG['ldap_pass'];
$ldap_host = $CONFIG['ldap_host'];
$ds = ldap_connect($ldap_host) or die("Could not connect to server. Error is " . ldap_error($ds));
$dbind = ldap_bind($ds, $ldap_uname, $ldap_pw) or die("Could not bind to server. Error is " . ldap_error($ds));
$now=date("Y-m-d H:i:s");
//$connect=odbc_connect($CONFIG['mssql']['db_host'],$CONFIG['mssql']['db_user'],$CONFIG['mssql']['db_password']);
//$db=odbc_select_db($CONFIG['mssql']['db_name'],$conn);
$tahun_akademik=$thn;
$gelombang=$gel;
$no_ujian=trim($no_ujian);
$sql_cari="select * from TM_FORMULIR_YG_TERBAYAR where NO_UJIAN='$no_ujian'";
$query_cari=cmd_query($sql_cari);
$hasil_cari=cmd_fetch_array($query_cari);
$prodi_diterima = $hasil_cari['KD_PRODI_TAHAP1'];
$no_pendaftaran = $hasil_cari['NO_PENDAFTARAN'];
$s = "SELECT * FROM TR_KODE_PROGRAM_STUDI AS p
INNER JOIN TR_KODE_FAKULTAS AS f ON p.KD_FAKULTAS=f.KD_FAKULTAS
WHERE p.KD_PROGRAM_STUDI='$prodi_diterima'";
$h = cmd_query($s);
$r = cmd_fetch_array($h);
$kd_fakultas = $r['KD_FAKULTAS'];
$kd_program_studi = $r['KD_PROGRAM_STUDI'];
$nama_fakultas = $r['FAKULTAS'];
$nama_program_studi = $r['PROGRAM_STUDI'];
switch ($kd_fakultas) {
case "1":
$l_fakultas = 4;
break;
case "8":
$l_fakultas = 6;
break;
case "2":
$l_fakultas = 3;
break;
case "3":
$l_fakultas = 2;
break;
case "4":
$l_fakultas = 1;
break;
case "6" :
$l_fakultas = 5;
break;
case "7" :
$l_fakultas = 7;
break;
}
switch ($kd_program_studi) {
case "10":
$l_program_studi=2;
break;
case "70":
$l_program_studi=10;
break;
case "20":
$l_program_studi=6;
break;
case "21":
$l_program_studi=7;
break;
case "40":
$l_program_studi=3;
break;
case "411":
$l_program_studi=13;
break;
case "412":
$l_program_studi=12;
break;
case "50":
$l_program_studi=4;
break;
case "30":
$l_program_studi=5;
break;
case "60":
$l_program_studi=1;
break;
case "210":
$l_program_studi=8;
break;
case "220":
$l_program_studi=9;
break;
case "230":
$l_program_studi=11;
break;
case "240":
$l_program_studi=15;
break;
case "310":
$l_program_studi=14;
break;
}
$today=date("Y-m-d H:i:s");
$today_short = date('Y-m-d');
$sa = "SELECT * FROM pmb_akademik_semester WHERE aktif_akademik_semester='Y' LIMIT 1";
$ha = cmd_query($sa);
$ra = cmd_fetch_array($ha);
$l_akademik_semester = $ra['id_akademik_semester'];
if ($rangking=="D" || $rangking=="T"){
$tunggu=$no_urut;
} else {
$tunggu=0;
}
$tot = 0;
$_error = array(); $_err_point = array();
//exit('$no_ujian = '.$no_ujian);
if (!empty($hasil_cari['NO_UJIAN'])) {
$gel = $hasil_cari['GELOMBANG'];
$tahun_akademik = $hasil_cari['TAHUN_AKADEMIK'];
$sql_ = "SELECT COUNT(*) FROM TM_CALON_LULUS_UJIAN_DITERIMA WHERE NO_UJIAN='".$hasil_cari['NO_UJIAN']."'";
$h_ = cmd_query($sql_);
list($tot) = cmd_fetch_array($h_);
if ($tot == 1) {
$sn = "SELECT * FROM TM_CALON_LULUS_UJIAN_DITERIMA WHERE NO_UJIAN='".$hasil_cari['NO_UJIAN']."'";
$hn = cmd_query($sn);
$rn = cmd_fetch_array($hn);
//exit('$rn[NPM] = '.$rn['NPM']);
if ((empty($rn['NPM']) || strlen($rn['NPM']) < 10) || !empty($npm)) {
if (empty($npm)) {
if ($kd_program_studi == "70") $kdprodi = '11';
else $kdprodi = $kd_program_studi;
if (strlen($kdprodi) == 3) {
$npm_check = $kdprodi.$thn.'001';
} else
$npm_check = '1'.$kdprodi.$thn.'001';
//$sn = "SELECT COUNT(*) FROM TM_CALON_LULUS_UJIAN_DITERIMA WHERE KD_FAKULTAS='$kd_fakultas' AND KD_PROGRAM_STUDI='$kd_program_studi' AND NPM='$npm_check'";
$sn = "SELECT MAX(NPM) FROM TM_CALON_LULUS_UJIAN_DITERIMA WHERE KD_FAKULTAS='$kd_fakultas'
AND KD_PROGRAM_STUDI='$kd_program_studi' AND TAHUN_AKADEMIK='$tahun_akademik'";
$hn = cmd_query($sn);
list($last_npm) = cmd_fetch_array($hn);
if (strlen($last_npm) != 10) {
$npm = $npm_check;
} else {
$npm = $last_npm;
}
$sn = "SELECT COUNT(*) FROM TM_CALON_LULUS_UJIAN_DITERIMA WHERE KD_FAKULTAS='$kd_fakultas' AND KD_PROGRAM_STUDI='$kd_program_studi' AND NPM='$npm'";
$hn = cmd_query($sn);
list($tot_npm) = cmd_fetch_array($hn);
if ($tot_npm > 0) {
$sn = "SELECT MAX(NPM) FROM TM_CALON_LULUS_UJIAN_DITERIMA WHERE KD_FAKULTAS='$kd_fakultas'
AND KD_PROGRAM_STUDI='$kd_program_studi' AND TAHUN_AKADEMIK='$tahun_akademik'";
$hn = cmd_query($sn);
list($last_npm) = cmd_fetch_array($hn);
$npm = $last_npm + 1;
while ($npm == '1302021071' || $npm == '1302021072' || $npm == '1212021039') {
$npm = $npm + 1;
}
if ($no_pendaftaran == '121752') {
$npm = '1212021039';
} else if ($no_pendaftaran == '1217716') {
$npm = '1302021071';
} else if ($no_pendaftaran == '1218266') {
$npm = '1302021072';
}
} else {
$npm = $npm_check;
}
//exit('$npm = '.$npm);
$sql_update="update TM_CALON_LULUS_UJIAN_DITERIMA set STATUS_PEMBAYARAN='1',STATUS_KELULUSAN='1',TGL_UPDATE='$today',WAKTU_PILIHAN='1',
NPM='$npm',TANGGAL_DAFTAR_ULANG='".$today_short."'
where NO_UJIAN='$no_ujian'";
$query_update=cmd_query($sql_update);
$sh = "SELECT * FROM TM_CALON_LULUS_UJIAN_DITERIMA WHERE NO_UJIAN='$hasil_cari[NO_UJIAN]'";
$hh = cmd_query($sh);
$rh = cmd_fetch_array($hh);
$nama_mahasiswa = stripslashes($rh['NAMA_CALON_MHS']);
$alamat_mahasiswa = stripslashes($rh['ALAMAT_CALON_MHS']);
$no_ujian = $hasil_cari['NO_UJIAN'];
$no_pendaftaran = $rh['NO_PENDAFTARAN'];
$tempat_lahir = stripslashes($rh['TEMPAT_LAHIR']);
$tanggal_lahir = $rh['TAHUN_LAHIR'].'-'.$rh['BULAN_LAHIR'].'-'.$rh['TANGGAL_LAHIR'];
if (!get_token_briva()) {
echo "Can't get BRIVA token for ".$rh['NO_PENDAFTARAN']." \n";
//die("Can't get BRIVA token!");
}
$brivastats = '';
if (is_briva_exists($rh['NO_PENDAFTARAN'])) {
if (update_briva($rh['NO_PENDAFTARAN'],$nama_mahasiswa)) {
$brivastats .= "Briva updated";
}
} else {
if (create_briva($rh['NO_PENDAFTARAN'],$nama_mahasiswa)) {
$brivastats .= "Briva created";
}
}
}
$sql = "SELECT * FROM TM_FORMULIR_YG_TERBAYAR where (NO_UJIAN='$no_ujian') and NO_UJIAN IS NOT NULL;";
$hs = cmd_query($sql);
$rs = cmd_fetch_array($hs);
$nomor_pendaftaran = trim($rs['NO_PENDAFTARAN']);
$angkatan = substr($npm,3,4);
$nama_mhs = kapital_kata(add_s(trim(strtolower(str_replace(' ','',$rs['NAMA_CALON_MHS'])))));
//deb_echo($nama_mhs);
$email = add_s(trim($rs['EMAIL']));
if (empty($email)) $emaildb = 'NULL'; else $emaildb = "'$email'";
$telp = add_s(trim($rs['NO_TLP_CALON_MHS']));
$hp = add_s(trim($rs['NO_HP_CALON_MHS']));
if (empty($telp) && empty($hp)) $tp = 'NULL'; else $tp = "'$telp#$hp'";
$tgl = trim($rs['TGL_UPDATE']);
$tgl_msk = '';
if (!empty($tgl)) {
$tgl = explode("/",$tgl);
$tgl_msk = $tgl[2].'-'.$tgl[0].'-'.$tgl[1];
}
//$tgl_msk = trim($rs['TGL_UPDATE']);
if (empty($tgl_msk)) $tgl_msk = "'".$angkatan.'-09-01'."'"; else $tgl_msk = "'$tgl_msk'";
$status_awal = get_stats(trim($rs['STATUS_AWAL']));
//$notify[] = 'Status MHS: '.$rs['STATUS_MHS'].'; $status_awal = '.$status_awal;
if (empty($status_awal)) $status_awal = '1';
$dosen_pa = get_id_dos_by_inisial(trim($val[7]),$l_fakultas,$l_program_studi);
if (empty($dosen_pa)) $dosen_pa = 'NULL'; else $dosen_pa = "'$dosen_pa'";
$alamat = add_s(trim($rs['ALAMAT_CALON_MHS']));
$kotaprop = get_stats(strip_s($rs['KOTA_KAB']),3);
$kotaprop = explode("#",$kotaprop);
$kota = $kotaprop[0];
if (empty($kota)) $kota = 'NULL'; else $kota = "'$kota'";
$propinsi = $kotaprop[1]; //trim($val[10]);
if (empty($propinsi)) $propinsi = 'NULL'; else $propinsi = "'$propinsi'";
$kodepos = add_s(trim($rs['KD_POS_CALON_MHS']));
$alamat_kos = add_s(trim($val[12]));
if (empty($alamat_kos)) $alamat_kos = 'NULL'; else $alamat_kos = "'$alamat_kos'";
$warga_negara = get_stats(trim($rs['KEWARGANEGARAAN']),1);
if (empty($warga_negara)) $warga_negara = '1';
$ttl = explode(',',trim(trim($rs['']),', '));
$tmpt_lhr = add_s($rs['TEMPAT_LAHIR']);
$tgl_lhr = $rs['TAHUN_LAHIR'].'-'.$rs['BULAN_LAHIR'].'-'.$rs['TANGGAL_LAHIR']; //tgl_id_2_db($ttl[1]);
$gender = strtolower(trim($rs['JENIS_KELAMIN']));
/*
if ($gender == 'p') $gender = 'p';
else $gender = 'l';*/
$gender = get_stats($gender,4);
$agama = get_stats(trim($rs['AGAMA']),5);
if (empty($agama)) $agama = 'NULL'; else $agama = "'$agama'";
$gol_darah = ''; //get_stats(trim($val[17]),6);
if (empty($gol_darah)) $gol_darah = 'NULL'; else $gol_darah = "'$gol_darah'";
$status_nikah = '';
if (empty($status_nikah)) $status_nikah = 'NULL'; else $status_nikah = "'$status_nikah'";
$no_ktp = '';
if (empty($no_ktp)) $no_ktp = 'NULL'; else $no_ktp = "'$no_ktp'";
$status_mhs = ''; //get_stats(trim($val[20]),2);
if (empty($status_mhs)) $status_mhs = '1';
$tgl_lulus = '';
if (empty($tgl_lulus)) {
$tgl_lulus = 'NULL'; $lulus = 'n';
} else {
$tgl_lulus = "'$tgl_lulus'"; $lulus = 'y';
}
$judul_ta = ''; //add_s(trim($val[22]));
if (empty($judul_ta)) $judul_ta = 'NULL'; else $judul_ta = "'$judul_ta'";
$no_ijazah = ''; //add_s(trim($val[23]));
if (empty($no_ijazah)) $no_ijazah = 'NULL'; else $no_ijazah = "'$no_ijazah'";
$l_mahasiswa = get_mhs_by_npm($npm,'id_mahasiswa');
//$l_kurikulum = get_kur_aktif($l_fakultas,$l_program_studi,'id_kurikulum');
$sk = "SELECT * FROM kurikulum WHERE aktif='y' AND l_fakultas='$l_fakultas'
AND l_program_studi='$l_program_studi'
ORDER BY tahun DESC LIMIT 1";
$hk = mysqli_query($con_sisakad,$sk) or die(mysqli_error($con_sisakad));
$rk = mysqli_fetch_array($hk);
$l_kurikulum = $rk['id_kurikulum'];
$jenis_kelas = $rs['JENIS_KELAS'];
if (empty($jenis_kelas)) $jenis_kelas = 'R';
$img_name = '';
if (cek_pic($npm.'.jpg')) {
$img_name_u = "image_path='".$npm.".jpg',";
$img_name_i = "image_path,";
$img_name_i2 = "'".$npm.".jpg',";
}
$tdate = date("Y-m-d H:i:s");
if ($gen_sisakad) {
$s = "SELECT COUNT(*) FROM mahasiswa WHERE id_mahasiswa='$l_mahasiswa'";
$h = mysqli_query($con_sisakad,$s) or die(mysqli_error($con_sisakad));
list($added) = mysqli_fetch_array($h);
if ($added > 0) {
$s = "SELECT * FROM mahasiswa WHERE id_mahasiswa='$l_mahasiswa'";
$h = mysqli_query($con_sisakad,$s) or die(mysqli_error($con_sisakad));
$r = mysqli_fetch_array($h);
$add_this = "";
if (empty($r['l_kurikulum'])) {
$add_this = "l_kurikulum='$l_kurikulum',";
}
//if ($npm == '1402012101') deb_echo($r['updated_date'].' - '.$r['created_date']);
//if ($npm == '1402012101') deb_echo($status_awal);
if ($r['updated_date'] == $r['created_date']) {
$s = "UPDATE mahasiswa SET nama_mahasiswa='$nama_mhs',email=$emaildb, $add_this
telepon=$tp,l_fakultas='$l_fakultas',l_program_studi='$l_program_studi',nomor_ujian='$nomor_ujian',nomor_pendaftaran='$nomor_pendaftaran',
tanggal_masuk=$tgl_msk,l_status_awal_mahasiswa='$status_awal',l_status_mahasiswa='$status_mhs',
alamat='$alamat',angkatan='$angkatan',alamat_kost=$alamat_kos,l_kota_kabupaten=$kota,
l_propinsi=$propinsi,l_negara='$warga_negara',l_warga_negara='$warga_negara',kodepos='$kodepos',
jenis_kelamin='$gender',l_status_nikah=$status_nikah,angkatan='$angkatan',$img_name_u
nomor_ktp=$no_ktp,tempat_lahir='$tmpt_lhr',tanggal_lahir='$tgl_lhr',jenis_kelas='$jenis_kelas',
l_agama=$agama,l_golongan_darah=$gol_darah,l_status_nikah=$status_nikah
WHERE id_mahasiswa='$l_mahasiswa' LIMIT 1";
$h = mysqli_query($con_sisakad,$s) or die(mysqli_error($con_sisakad));
}
} else {
$s = "INSERT INTO mahasiswa (nomor_induk_mahasiswa,nama_mahasiswa,email,telepon,l_fakultas,l_program_studi,
tanggal_masuk,l_status_awal_mahasiswa,l_status_mahasiswa,l_dosen_pa,alamat,angkatan,l_kurikulum,nomor_ujian,nomor_pendaftaran,
alamat_kost,l_kota_kabupaten,l_propinsi,l_negara,l_warga_negara,kodepos,jenis_kelamin,l_status_nikah,
nomor_ktp,tanggal_lulus,tempat_lahir,tanggal_lahir,l_agama,l_golongan_darah,lulus,judul_ta,nomor_ijazah,jenis_kelas,
$img_name_i
created_by,created_date,updated_by,updated_date)
VALUES('$npm','$nama_mhs',$emaildb,$tp,'$l_fakultas','$l_program_studi',$tgl_msk,
'$status_awal','$status_mhs',$dosen_pa,'$alamat','$angkatan','$l_kurikulum','$nomor_ujian','$nomor_pendaftaran',
$alamat_kos,$kota,
$propinsi,'$warga_negara','$warga_negara','$kodepos','$gender',$status_nikah,$no_ktp,$tgl_lulus,
'$tmpt_lhr','$tgl_lhr',$agama,$gol_darah,'$lulus',
$judul_ta,$no_ijazah,'$jenis_kelas',$img_name_i2
'1','$tdate','1','$tdate')";
$h = mysqli_query($con_sisakad,$s) or die(mysqli_error($con_sisakad));
$lid = mysqli_insert_id($con_sisakad);
$s = "INSERT INTO user (username,password,l_mahasiswa,l_role,created_by,created_date)
VALUES('$npm','".md5($npm)."','$lid','5',
'1','$tdate')";
$h = mysqli_query($con_sisakad,$s) or die(mysqli_error($con_sisakad));
}
}
//exit('$s = '.$s);
if ($gen_ldap) {
$user_info = array(
'nama_lengkap' => $nama_mhs,
'hp' => $hp,
'alamat' => $alamat,
'email' => $email,
'npm' => $npm,
'notelp' => $telp,
'kodepos' => $kodepos,
'tipe_user' => 'M',
'tgl_lhr' => $tgl_lhr,
'user_role' => 'U'
);
if ($added > 0) {
$body_gen = gen_ldap ($npm,$user_info,($tot+1),true);
/*
if (!$body_gen) {
$notify[] = '- Tidak dapat mengambil data akun LDAP untuk NPM '.$npm.' ('.$nama_mhs.') ';
} else {
$tab_gen .= $body_gen;
}
*/
} else {
$body_gen = gen_ldap ($npm,$user_info,($tot+1),false);
/*
if (!$body_gen) {
$notify[] = '- Tidak dapat menambahkan akun LDAP untuk NPM '.$npm.' ('.$nama_mhs.') ';
} else {
$tab_gen .= $body_gen;
}
*/
}
}
$add_text = ''; $add_text2 = '';
if (is_array($body_gen) && !empty($body_gen[0]) && !empty($body_gen[1])) {
$add_text = 'Untuk proses kegiatan belajar/mengajar, kamu juga mendapatkan akun akademik YARSI sebagai berikut:<
Nomor Pokok Mahasiwa (NPM): '.$npm.'
Username: '.$body_gen[0].'
Password: '.$body_gen[1].'
Akun YARSI ini dapat kamu gunakan untuk mengakses beberapa halaman berikut:
Sistem Akademik Universitas YARSI di URL https://sisakad.yarsi.ac.id
Sistem E-Learning YARSI (LAYAR) di URL https://layar.yarsi.ac.id
Email Mahasiswa di URL http://students.yarsi.ac.id
Sistem Bahasa Inggris di URL https://olc.yarsi.ac.id
Kamu juga dapat melihat informasi login akun YARSI di atas, di halaman sistem PMB kamu, login di '.$CONFIG['url_apps'].'/login.php menggunakan username dan password PMB kamu, lalu klik menu "Cek Pembayaran Formulir".
Info akun YARSI akan muncul di bagian bawah halaman tersebut.
';
$add_text2 = 'Nomor Pokok Mahasiwa (NPM): '.$npm.'
Username: '.$body_gen[0].'
Password: '.$body_gen[1].' ';
} else {
$add_text = 'Saat akan memulai perkuliahan di bulan September nanti, kamu juga akan mendapat informasi NPM (Nomor Pokok Mahasiswa) dan login akun YARSI
di halaman sistem PMB kamu, login di '.$CONFIG['url_apps'].'/login.php menggunakan username dan password PMB kamu,
lalu klik menu "Cek Pembayaran Formulir".
Info akun YARSI akan muncul di bagian bawah halaman tersebut.
Akun YARSI ini dapat kamu gunakan untuk mengakses beberapa halaman berikut:
Sistem Akademik Universitas YARSI di URL https://sisakad.yarsi.ac.id
Sistem E-Learning YARSI (LAYAR) di URL https://layar.yarsi.ac.id
Email Mahasiswa di URL http://students.yarsi.ac.id
Sistem Bahasa Inggris di URL https://olc.yarsi.ac.id
';
$add_text2 = '';
}
if ($send_email) {
$subject = '[PMB YARSI] Notifikasi Status Daftar Ulang Peserta PMB';
$sesi_teks = 'Selanjutnya silakan lengkapi dokumen-dokumen persyaratan daftar ulang lainnya yaa..
Untuk info lebih lanjut mengenai prosedur daftar ulang silakan ke alamat berikut https://www.yarsi.ac.id/pendaftaran/#tab_prosedur-pendaftaran
'.$add_text.'
Salam Hangat, Wassalamualaikum,
Tim PMB YARSI
';
$mailtext = '
Assalamualaikum Wr. Wb.,
Selamat '.strtoupper($nama_mhs).'! Kamu Telah Terdaftar menjadi mahasiswa Universitas YARSI
pada Fakultas '.$nama_fakultas.' Program Studi
'.$nama_program_studi.' di Universitas YARSI.
'.$sesi_teks.'
';
echo "Sending mail peserta.. \n";
send_mail($email_peserta,'no_reply@yarsi.ac.id',$subject,$mailtext);
$subject = '[Sistem PMB] Peserta PMB No. Pendaftaran '.$no_pendaftaran.' an '.$nama_mhs.' telah melakukan Daftar Ulang di prodi '.$nama_program_studi;
$mailtext = '
Assalamualaikum Wr. Wb.,
Peserta dengan No. Pendaftaran '.$no_pendaftaran.' an '.strtoupper($nama_mhs).' telah melakukan pembayaran dan diubah statusnya menjadi "Sudah Registrasi Ulang" di sistem PMB.
Berikut informasi akun YARSI untuk peserta tersebut:
Program Studi diterima: '.$nama_program_studi.'
'.$add_text2.'
Mohon teruskan juga informasi ini ke nomor HP peserta agar memastikan peserta tersebut telah mengetahui status daftar ulang nya.
Untuk melihat detail data peserta, silakan login pada halaman berikut '.$CONFIG['url_apps'].'
Terima kasih.
';
//deb_echo($mailtext);
//send_mail($email_peserta,'no_reply@yarsi.ac.id',$subject,$mailtext);
echo "Sending mail pic.. \n";
$s = "SELECT * FROM pegawai AS p INNER JOIN users AS u ON u.l_pegawai_user=p.id_pegawai
WHERE (p.kd_fakultas_pegawai='$fak' AND u.l_role_user=7) OR (p.kd_program_studi_pegawai='$prodi_diterima' AND u.l_role_user=8)";
$h = cmd_query($s);
while ($r = cmd_fetch_array($h)) {
$email = $r['email_pegawai'];
if (empty($email)) continue;
if (is_sent($subject,$email)) continue;
send_mail($email,'no_reply@yarsi.ac.id',$subject,$mailtext);
}
$s = "SELECT * FROM pegawai AS p INNER JOIN users AS u ON u.l_pegawai_user=p.id_pegawai
WHERE (u.l_role_user BETWEEN 1 AND 4)";
$h = cmd_query($s);
while ($r = cmd_fetch_array($h)) {
$email = $r['email_pegawai'];
if (empty($email)) continue;
if (is_sent($subject,$email)) continue;
send_mail($email,'no_reply@yarsi.ac.id',$subject,$mailtext);
}
}
}
}
}
}
function is_dev() {
global $CONFIG;
if (in_array($_SERVER['REMOTE_ADDR'],$CONFIG['dev_ips'])) return true;
else return false;
}
function is_user() {
global $CONFIG,$cookiename,$permission,$conn;
if (!empty($_SESSION[$cookiename]['user_id']) || $_SERVER['argv'][1] == 'admin') {
if ($_SERVER['argv'][1] == 'admin') {
$_SESSION[$cookiename]['id_role'] = 1;
$_SESSION[$cookiename]['id_user'] = 1;
$_SESSION[$cookiename]['user_id'] = 1;
}
$strsql = "SELECT * FROM permission WHERE 1";
$res = cmd_query($strsql);
//exit('test');
$_SESSION[$cookiename]['permission'] = array();
$permission = array();
while ($rows = cmd_fetch_array($res)) {
$perm = explode(',',trim($rows['roles_permission'],', '));
//echo 'array_search('.$grup.',$perm) = ' . array_search($grup,$perm) . ' ';
if (array_search($_SESSION[$cookiename]['id_role'],$perm) !== false) {
//echo $rows['nama_permission'].' ';
$_SESSION[$cookiename]['permission'][] = $rows['nama_permission'];
$permission[] = $rows['nama_permission'];
}
}
return true;
}
return false;
}
function check_perm($nama_tabel,$access_scope=array()) {
global $CONFIG, $permission, $cookiename;
if (!is_array($access_scope) || (is_array($access_scope) && count($access_scope) < 1)) {
$access_scope = $CONFIG['acl_scope'];
}
if (empty($_SESSION[$cookiename]['permission'])) return false;
if (is_array($access_scope) && count($access_scope) > 0) {
$ok = true;
foreach ($access_scope as $val) {
$ijin = $nama_tabel.'_'.$val;
if ($_SESSION[$cookiename]['id_role'] == 1) return true;
if (count($_SESSION[$cookiename]['permission']) < 1) return false;
if (array_search($ijin,$_SESSION[$cookiename]['permission']) === false) {
$ok = false;
}
}
if ($ok) return true;
}
return false;
}
function get_perm($ijin) {
global $permission, $cookiename;
//deb_echo(in_array($ijin,$_SESSION[$cookiename]['permission']),false);
if ($_SESSION[$cookiename]['id_role'] == 1) return true;
else return (@in_array($ijin,$_SESSION[$cookiename]['permission']));
}
function can_ops($tabel) {
if (get_perm("$tabel_list") || get_perm("$tabel_add") || get_perm("$tabel_edit")
|| get_perm("$tabel_view") || get_perm("$tabel_del") || get_perm("$tabel_approve"))
return true;
else return false;
}
function error_msg($msg,$tipe="normal",$title="Error!",$con='') {
global $page_height,$conn;
if ($tipe == 'mysql') {
if ($con)
$mysqlmsg = mysqli_error($con);
else
$mysqlmsg = mysqli_error($conn);
}
else if ($tipe == 'mssql') {
if ($con)
$mysqlmsg = odbc_errormsg($con);
else
$mysqlmsg = odbc_errormsg($conn);
}
ob_end_clean();
ob_start();
//$judul = "- $title";
page_header($title);
$maincontent = '';
$maincontent .= '
';
if ($show === true) echo $output;
else return $output;
}
function suc_box($msg,$box_title='SUKSES!',$show=false) {
$output = '
'.$box_title.'
'.$msg.'
';
if ($show === true) echo $output;
else return $output;
}
function logout() {
global $cookiename;
unset($_SESSION[$cookiename]);
@session_destroy();
}
function makeThumbnail($o_file, $destfilename, $new_size = 100) {
$image_info = getImageSize($o_file) ; // see EXIF for faster way
switch ($image_info['mime']) {
case 'image/gif':
if (imagetypes() & IMG_GIF) { // not the same as IMAGETYPE
$o_im = imageCreateFromGIF($o_file) ;
} else {
$ermsg = 'GIF images tidak dapat dibuat thumbnail ';
}
break;
case 'image/jpeg':
if (imagetypes() & IMG_JPG) {
$o_im = imageCreateFromJPEG($o_file) ;
} else {
$ermsg = 'JPEG images tidak dapat dibuat thumbnail ';
}
break;
case 'image/png':
if (imagetypes() & IMG_PNG) {
$o_im = imageCreateFromPNG($o_file) ;
} else {
$ermsg = 'PNG images tidak dapat dibuat thumbnail ';
}
break;
case 'image/wbmp':
if (imagetypes() & IMG_WBMP) {
$o_im = imageCreateFromWBMP($o_file) ;
} else {
$ermsg = 'WBMP images tidak dapat dibuat thumbnail ';
}
break;
default:
$ermsg = $image_info['mime'].' tidak dapat dibuat thumbnail ';
break;
}
if (!isset($ermsg)) {
// height/width
$srcWidth = imagesx($o_im);
$srcHeight = imagesy($o_im);
$ratio = max($srcWidth, $srcHeight) / $new_size;
$ratio = max($ratio, 1.0);
$destWidth = round($srcWidth / $ratio);
$destHeight = round($srcHeight / $ratio);
$dst_img = imagecreatetruecolor($destWidth, $destHeight);
imageCopyResampled($dst_img, $o_im, 0, 0, 0, 0, $destWidth, $destHeight, $srcWidth, $srcHeight);
if ($o_file == $destfilename) {
$filenametmp = $destfilename.".tmp";
imagejpeg($dst_img,$filenametmp, 95);
unlink($o_file);
rename($filenametmp,$destfilename);
} else {
imagejpeg($dst_img,$destfilename, 95);
}
//imageJPEG($t_im);
imageDestroy($o_im);
imageDestroy($dst_img);
}
return isset($ermsg)?$ermsg:NULL;
}
function add_s($teks,$allow_html=false) {
global $CONFIG,$cookie,$cookiename,$jenis,$idz,$nama,$grup;
if ($allow_html === false) {
$teks = htmlspecialchars($teks);
$teks = ascii_only($teks);
}
if (!get_magic_quotes_gpc() || $CONFIG['db_type']=="mssql") {
if ($CONFIG['db_type']=="mssql") {
$teks = str_replace("'","''",$teks);
return $teks;
} else return addslashes($teks);
}
else return $teks;
}
function strip_s($teks,$allow_html=false) {
global $CONFIG,$cookie,$cookiename,$jenis,$idz,$nama,$grup;
if ($allow_html === false) {
$teks = strip_tags($teks);
}
if (!get_magic_quotes_gpc() || $CONFIG['db_type']=="mssql") {
if ($CONFIG['db_type']=="mssql") {
$searchstr = array("''","\\r\\n","\\n","\\");
$repstr = array("'","\n","\n","");
$teks = str_replace($searchstr,$repstr,$teks);
//$teks = str_replace("\\r\\n","\n",$teks);
//return $teks;
}
return stripslashes($teks);
}
else return $teks;
}
function ascii_only($str) {
$str = preg_replace('/[[:^print:]]/', '', $str);
return $str;
}
function back_button($link_query='',$title='Kembali',$js_str='') {
if (!empty($link_query)) {
$back_button = '
'.$title.' ';
} else {
$back_button = '
« '.$title.' ';
}
return $back_button;
}
function buat_halaman($links,$show_user,$num=0) {
global $page,$start_limit,$CONFIG,$conn;
$page = $_REQUEST['page'];
if(!empty($page)) {
$start_limit = ($page-1) * $show_user;
}
else {
$start_limit = 0;
$page = 1;
}
//$query = cmd_query("SELECT count($field) FROM $table $where");
//$num = mysqli_result($query,0);
if($num > $show_user) {
$pages = $num / $show_user;
$pages = ceil($pages);
if ($page == $pages) {
$to = $pages;
} elseif ($page == $pages-1) {
$to = $page+1;
} elseif ($page == $pages-2) {
$to = $page+2;
} else {
$to = $page+3;
}
if ($page == 1 || $page == 2 || $page == 3) {
$from = 1;
} else {
$from = $page-3;
}
for ($i = $from; $i <= $to; $i++) {
if ($i == $page) {
$x = $i-1;
$y = $i+1;
if ($i == 1) {
$fwd_back_all_down = "";
$fwd_back_down = "";
} else {
$fwd_back_all_down = ' << ';
$fwd_back_down = ' < ';
}
$fwd_back .= ' ' . $i . ' ';
if ($i >= $to) {
$fwd_back_up = "";
$fwd_back_all_up = "";
} else {
$fwd_back_up = ' > ';
$fwd_back_all_up = ' >> ';
}
} else {
$fwd_back .= ' ' . $i . ' ';
}
}
$page_option = "";
for ($i=0;$i<$pages;$i++) {
$sel = "";
if (($i+1) == $page) $sel = " selected";
$page_option .= '';
}
$sd_option = "";
foreach ($CONFIG['show_data_num'] as $val) {
$sel = "";
if ($show_user == $val) $sel = " selected";
$sd_option .= '';
}
$preg_search = array('/\\&page=(\\d+)/i','/\\&sd=(\\d+)/i');
$preg_replace = array('','');
$q1 = preg_replace($preg_search[0],$preg_replace[0],$_SERVER['QUERY_STRING']);
$q2 = preg_replace($preg_search[1],$preg_replace[1],$_SERVER['QUERY_STRING']);
$multipage = "Halaman: [ $fwd_back_all_down $fwd_back_down $fwd_back $fwd_back_up $fwd_back_all_up ]
Ke Halaman:
Data per Halaman:
";
}
else { $multipage = ""; }
return $multipage;
}
function get_propinsi($kd_propinsi,$field='') {
global $conn;
$s = "SELECT * FROM TR_KODE_PROVINSI WHERE KODE_PROVINSI='$kd_propinsi' LIMIT 1";
$h = cmd_query($s);
$r = cmd_fetch_array($h);
if (!empty($field)) {
return strip_s($r[$field]);
} else return $r;
return strip_s($r['NAMA_PROVINSI']);
}
function list_kategori($l_kategori=0,$filter_aktif=0,$show=true) {
global $conn;
if ($filter_aktif == 1) $where = "aktif='y'";
else $where = "1";
$s = "SELECT * FROM kategori WHERE $where ORDER BY nama_kategori";
$h = cmd_query($s);
$output = '';
while ($r = cmd_fetch_array($h)) {
if ($r['id_kategori'] == $l_kategori) $sel = " selected";
else $sel = "";
$output .= '';
}
if ($show === true)
echo $output;
else
return $output;
}
function get_kota($kd_kota,$field='') {
global $conn;
$s = "SELECT * FROM TR_KODE_KOTA_KAB WHERE KODE_KOTA_KAB='$kd_kota' LIMIT 1";
$h = cmd_query($s);
$r = cmd_fetch_array($h);
if (!empty($field)) {
return strip_s($r[$field]);
} else return $r;
return strip_s($r['NAMA_KOTA_KAB']);
}
function list_items($l_items=0,$filter_aktif=0,$show=true) {
if ($filter_aktif == 1) $where = "aktif='y'";
else $where = "1";
$s = "SELECT * FROM items WHERE $where ORDER BY judul_items";
$h = cmd_query($s);
$output = ''; $js_val = '';
while ($r = cmd_fetch_array($h)) {
if ($r['id_items'] == $l_items) $sel = " selected";
else $sel = "";
$output .= '';
}
if ($show === true) {
echo $output;
}
else
return $output;
}
function get_sekolah($l_sekolah,$field='') {
global $conn;
$s = "SELECT * FROM TM_SEKOLAH WHERE NAMA_SEKOLAH='$l_sekolah' LIMIT 1";
$h = cmd_query($s);
$r = cmd_fetch_array($h);
if (!empty($field)) {
return strip_s($r[$field]);
} else return $r;
return strip_s($r['NAMA_SEKOLAH']);
}
function list_tema($l_tema=0,$filter_aktif=0,$show=true) {
global $conn;
if ($filter_aktif == 1) $where = "aktif='y'";
else $where = "1";
$s = "SELECT * FROM tema WHERE $where ORDER BY nama_tema";
$h = cmd_query($s);
$output = '';
while ($r = cmd_fetch_array($h)) {
if ($r['id_tema'] == $l_tema) $sel = " selected";
else $sel = "";
$output .= '';
}
if ($show === true)
echo $output;
else
return $output;
}
function get_volume($l_volumes,$field='') {
global $conn;
$s = "SELECT * FROM volumes WHERE id_volumes='$l_volumes' LIMIT 1";
$h = cmd_query($s);
$r = cmd_fetch_array($h);
if (!empty($field)) {
return strip_s($r[$field]);
} else return $r;
return strip_s($r['nama_volumes']);
}
function get_members($l_members,$field='') {
global $conn;
$s = "SELECT * FROM members WHERE id_members='$l_members' LIMIT 1";
$h = cmd_query($s);
$r = cmd_fetch_array($h);
if (!empty($field)) {
return strip_s($r[$field]);
} else return $r;
return strip_s($r['nama']);
}
function list_volume($l_volumes=0,$filter_aktif=0,$show=true) {
global $conn;
if ($filter_aktif == 1) $where = "aktif='y'";
else $where = "1";
$s = "SELECT * FROM volumes WHERE $where ORDER BY nama_volumes";
$h = cmd_query($s);
$output = '';
while ($r = cmd_fetch_array($h)) {
if ($r['id_volumes'] == $l_volumes) $sel = " selected";
else $sel = "";
$output .= '';
}
if ($show === true)
echo $output;
else
return $output;
}
function GetaField($_tbl,$_key,$_value,$_result) {
global $strCantQuery,$conn;
$_sql = "SELECT $_result FROM $_tbl WHERE $_key='$_value' limit 1";
$_res = cmd_query($_sql);
if (cmd_num_rows($_res) == 0) return '';
else return cmd_result($_res, 0, cmd_field_name($_res, 0));
}
function GetFields($_tbl, $_key, $_value, $_results) {
global $strCantQuery,$conn;
$s = "SELECT $_results FROM $_tbl WHERE $_key='$_value' limit 1";
$r = cmd_query($s);
if (cmd_num_rows($r) == 0) return '';
else {
$res = array();
for ($i=0; $i < cmd_num_fields($r); $i++) {
$res[cmd_field_name($r, $i)] = cmd_result($r, 0, cmd_field_name($r, $i));
}
return $res;
}
}
function page_header($judul='',$print=false,$js=false,$left=false,$right=false) {
global $CONFIG,$nohead,$head_align,$cookiename,$bread_array,$permission,$conn;
if (md5($_SESSION[$cookiename]['username_user']) == $_SESSION[$cookiename]['password_user']) {
//define('UBAH_PASSWORD','1');
if (!preg_match("/pegawai_ubah\.php/i",$_SERVER["PHP_SELF"])) {
//echo '$_SERVER["PHP_SELF"] = '.$_SERVER["PHP_SELF"].' ';
header("Location: pegawai_ubah.php?msg=2");
exit;
}
}
//$pagetitle = $judul;
if (!$print) {
if (!$js) {
include "includes/header.php";
include "includes/menu.php";
} else include "includes/header_js.php";
}
else include "includes/header_print.php";
}
function page_footer($print=false,$js=false) {
global $CONFIG,$conn;
if (!$print) {
if (!$js)
include "includes/footer.php";
else include "includes/footer_js.php";
}
else include "includes/footer_print.php";
exit;
}
function get_months($date_from,$date_until) {
$d1 = strtotime($date_from);
$d2 = strtotime($date_until);
$y1 = date('Y', $d1);
$y2 = date('Y', $d2);
$m1 = date('n', $d1);
$m2 = date('n', $d2);
$month_diff = ($y2 - $y1) * 12 + ($m2 - $m1);
return $month_diff;
}
function date_empty($datetime) {
if ($datetime == '0000-00-00 00:00:00' ||
$datetime == '0000-00-00' ||
$datetime == '00:00:00' ||
preg_match('/00\/00\/0000/i',$datetime) ||
empty($datetime)) return true;
else return false;
}
function createDateRange($start, $end, $format = 'Y-m-d') {
$start = new DateTime($start);
$end = new DateTime($end);
$invert = $start > $end;
$dates = array();
$dates[] = $start->format($format);
while ($start != $end) {
$start->modify(($invert ? '-' : '+') . '1 day');
$dates[] = $start->format($format);
}
return $dates;
}
function mysql_to_ts($mysqli_time) {
if (preg_match('/^(\\d{4})-(\\d{2})-(\\d{2}) (\\d{2}):(\\d{2}):(\\d{2})$/', $mysqli_time, $matches)) {
return mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
} else if (preg_match('/^(\\d{4})-(\\d{2})-(\\d{2})$/', $mysqli_time, $matches)) {
return mktime(0, 0, 0, $matches[2], $matches[3], $matches[1]);
} else if (preg_match('/^(\\d{2}):(\\d{2}):(\\d{2})$/', $mysqli_time, $matches)) {
return mktime($matches[1], $matches[2], $matches[3], 0, 0, 0);
} else if (preg_match('/^(\\w{3}) (\\d{1}|\\d{2}) (\\d{4})[ ]*(\\d{1}|\\d{2}):(\\d{1}|\\d{2})(\\w{2})$/', $mysqli_time, $matches)) {
//Oct 23 2008 11:05AM
return strtotime($mysqli_time);
}
return NULL;
}
/*
$longdate = 1 : panjang
2 : singkat
3 : custom -> $custom = definisikan format tgl custom
*/
function waktu($time_stamp,$datetype=2,$custom="",$timestamp=1) {
global $CONFIG;
if ($timestamp == 0) {
if (date_empty($time_stamp)) return "-";
$time_stamp = mysql_to_ts($time_stamp);
}
$tambah = ($CONFIG['waktuoffset']*3600);
$time_stamp = $time_stamp + $tambah;
//date_default_timezone_set('Asia/Jakarta');
setlocale(LC_TIME, $CONFIG['locale']);
if ($datetype == 1) {
$output = strftime(_DATEHOURSTRING,$time_stamp); //Format tgl panjang: Selasa, 07 Februari 2007 21:45 WIB
}
elseif ($datetype == 2) {
$output = strftime(_DATEHOURSTRING_S,$time_stamp); //Format tgl singkat: 07/02/2007, 21:45 WIB
}
elseif ($datetype == 3) {
$output = strftime(_DATESTRING,$time_stamp); //15 Februari 2008
}
elseif ($datetype == 4) {
$output = strftime(_DATESTRING_S,$time_stamp); //15/02/2008
}
elseif ($datetype == 5) {
$output = strftime(_HOURSTRING,$time_stamp); //23:11:12 WIB
}
elseif ($datetype == 6) {
$output = strftime(_HOURSTRING_S,$time_stamp); //23:11 WIB
}
else {
$output = strftime($custom,$time_stamp);
}
$str_find = array("Monday","Tuesday","Wednesday","Thursday","Friday",
"Saturday","Sunday",
"January", "February", "Pebruari", "March",
"May", "June", "July", "August", "Nopember",
"October","December",
"Peb", "Aug", "Nop", "Oct", "Dec",
"Sat", "Sun", "Mon", "Tue", "Wed", "Thu", "Fri");
$str_replace = array("Senin","Selasa","Rabu","Kamis","Jumat",
"Sabtu","Minggu",
"Januari", "Februari", "Februari", "Maret",
"Mei", "Juni", "Juli", "Agustus", "November",
"Oktober","Desember",
"Feb", "Agt", "Nov", "Okt", "Des",
"Sab", "Min", "Sen", "Sel", "Rab", "Kam", "Jum");
$output = str_replace($str_find, $str_replace, $output);
return $output;
}
function hari_kerja($jml_hari) {
$now = date('D');
switch ($now) {
case 'Mon':
if ($jml_hari > 4) {
$jml_hari += 2;
}
break;
case 'Tue':
if ($jml_hari > 3) {
$jml_hari += 2;
}
break;
case 'Wed':
if ($jml_hari > 2) {
$jml_hari += 2;
}
break;
case 'Thu':
if ($jml_hari > 1) {
$jml_hari += 2;
}
break;
case 'Fri':
$jml_hari += 2;
break;
}
return $jml_hari;
}
function side_bar_left($box_title,$isi) {
global $_print;
if (!$_print) {
echo '
';
return true;
} else return false;
}
function box($judul,$isi,$color='default') {
$array_color = array('blue','orange','green','black');
if (!empty($color) && in_array(strtolower($color),$array_color)) {
$mod = strtolower($color);
$mod2 = 'color';
}
else {
$mod = 'default';
$mod2 = 'default';
}
$out = '
';
if (!empty($judul)) {
$out .= '
'.$judul.'
';
}
$out .= '
'.$isi.'
';
return $out;
}
function box_tab($judul,$isi,$color='default') {
?>
Warning: Undefined variable $judul in /var/www/clients/client4/web10/web/pmb/pendaftaran/includes/func.php on line 2379
Warning: Undefined variable $isi in /var/www/clients/client4/web10/web/pmb/pendaftaran/includes/func.php on line 2382
Warning: Undefined variable $judul in /var/www/clients/client4/web10/web/pmb/pendaftaran/includes/func.php on line 2403
Warning: Undefined variable $isi in /var/www/clients/client4/web10/web/pmb/pendaftaran/includes/func.php on line 2404
'.$judul.'
'.$isi.'
';
}
function container_box($isi) {
global $page_height,$cookiename,$permission;
echo $isi;
}
function deb_echo($what,$exit=true) {
if (is_array($what)) {
echo '
';
print_r($what);
echo '
';
} else echo '$var = '.$what.' ';
if ($exit == true) exit;
else return '';
}
function makeNull($what) {
if (empty($what)) return 'NULL';
else return "'$what'";
}
function make_th($field_title,$sortby_value,$field_sortby,$linksort,$showsort=true,$show=true) {
global $_print,$sortorder;
if (preg_match("/::/i",$field_title)) {
$ft = explode("::",trim($field_title));
$field_title = trim($ft[0]);
$field_desc = ' title="'.trim($ft[1]).'"';
}
if ($showsort===true && !$_print) {
if ($sortby_value == $field_sortby) {
if ($sortorder == 'asc') {
$field_title = ''.$field_title.'';
} else {
$field_title = ''.$field_title.'';
}
} else {
$field_title = ''.$field_title.' ';
}
}
$print_th = '
Ekstension file (".$file_name.";".$id_form_element.") tidak diperbolehkan untuk diupload.
Hanya boleh meng-upload file dengan ekstension di bawah ini: ".$CONFIG[$allow_ext]."
";
$_err_point[$id_form_element] = $err_class;
} else {
if (!empty($rename_file)) {
$file_name = $rename_file.".".$matches[2];
}
$des_file_name = str_replace("_"," ",$file_name);
$des_file_name = substr($des_file_name,0,strlen($des_file_name)-4);
while (file_exists($CONFIG[$location]."/".$file_name)) {
if (preg_match("/(.+)\.(.*?)\Z/", $file_name, $matches)) {
$file_name = $matches[1].'_'.rand(100,900).'.'.$matches[2];
}
}
if (!move_uploaded_file($file_data['tmp_name'],$CONFIG[$location]."/".$file_name)) {
$_error[] = "
Proses upload ".$file_name." gagal! Mohon hubungi Administrator (".$CONFIG['admin_contact'].")
Ekstension file (".$file_name.";".$id_form_element.") tidak diperbolehkan untuk diupload.
Hanya boleh meng-upload file dengan ekstension di bawah ini: ".$CONFIG[$allow_ext]."
";
$_err_point[$id_form_element] = $err_class;
} else {
if (!empty($rename_file)) {
$file_name = $rename_file.".".$matches[2];
}
$des_file_name = str_replace("_"," ",$file_name);
$des_file_name = substr($des_file_name,0,strlen($des_file_name)-4);
while (file_exists($CONFIG[$location]."/".$file_name)) {
if (preg_match("/(.+)\.(.*?)\Z/", $file_name, $matches)) {
$file_name = $matches[1].'_'.rand(100,900).'.'.$matches[2];
}
}
if (!rename($CONFIG['tmp_upload_dir'].'/'.$file_data_name,$CONFIG[$location]."/".$file_name)) {
$_error[] = "
Proses upload ".$file_name." gagal! Mohon hubungi Administrator (".$CONFIG['admin_contact'].")
";
}
}
}
}
}
if (count($_error) > 0) {
@unlink($CONFIG[$location]."/".$file_name);
@unlink($CONFIG[$location]."/thumb_".$file_name);
@unlink($CONFIG[$location]."/athumb_".$file_name);
if ($is_replace) $file_name = $old_file_name;
} else {
if ($is_replace) {
@unlink($CONFIG[$location]."/".$old_file_name);
@unlink($CONFIG[$location]."/thumb_".$old_file_name);
@unlink($CONFIG[$location]."/athumb_".$old_file_name);
}
}
$res_ops = array($file_name,$_error,$_err_point);
return $res_ops;
}
function is_img_ext($file_name) {
global $CONFIG;
if (!preg_match("/(.+)\.(.*?)\Z/", $file_name, $matches)) {
$matches[1] = 'invalid_fname';
$matches[2] = 'xxx';
}
if (!empty($matches[2]) && stristr($CONFIG['allowed_file_extensions'], $matches[2])) {
return true;
}
return false;
}
function write_autocomplete($ajax_url,$ajax_data,$id_field,$value_field) {
$maincontent .= '
';
return $maincontent;
}
function cron_sarana() {
global $CONFIG,$conn;
$now = date('Y-m-d H:i:s');
$s = "UPDATE sarana SET waktu_awal_pinjam_sarana=NULL,waktu_akhir_pinjam_sarana=NULL
WHERE ('$now' NOT BETWEEN waktu_awal_pinjam_sarana AND waktu_akhir_pinjam_sarana)
AND status_pinjam_sarana!='S'";
$h = cmd_query($s);
}
function cron_usia_karyawan() {
global $CONFIG,$conn;
$s = "SELECT * FROM karyawan WHERE 1";
$h = cmd_query($s);
while ($r = cmd_fetch_array($h)) {
$id_karyawan = $r['id_karyawan'];
$tanggal_lahir_karyawan = $r['tanggal_lahir_karyawan'];
if (empty($id_karyawan)) continue;
if (!date_empty($tanggal_lahir_karyawan)) {
$birthDate = $tanggal_lahir_karyawan;
$birthDate = explode("-", $birthDate);
$usia_karyawan = (date("md", date("U", mysql_to_ts($tanggal_lahir_karyawan))) > date("md") ? ((date("Y")-$birthDate[0])-1):(date("Y")-$birthDate[0]));
if ($usia_karyawan < 1) continue;
$s2 = "UPDATE karyawan SET usia_karyawan='$usia_karyawan' WHERE id_karyawan='$id_karyawan' LIMIT 1";
$h2 = cmd_query($s2);
}
}
}
function send_notif_mail($no_pendaftaran,$fak,$ps='') {
global $CONFIG,$conn;
$sc = "SELECT * FROM TM_FORMULIR_YG_TERBAYAR WHERE NO_PENDAFTARAN='$no_pendaftaran'";
$hc = cmd_query($sc);
$rc = cmd_fetch_array($hc);
$nama = strip_s($rc['NAMA_CALON_MHS']);
$tahun = $rc['TAHUN_AKADEMIK'];
$gel = $rc['GELOMBANG'];
$subject = '[Sistem PMB UYARSI] Notifikasi Pendaftaran Peserta PMB Baru';
$mailtext = '
Assalamualaikum Wr. Wb.,
Anda memiliki tambahan 1 peserta PMB UYARSI yang telah melakukan pembayaran formulir sbb: Tahun pendaftaran: '.$tahun.' Gelombang: '.$gel.' No. Pendaftaran: '.$no_pendaftaran.' Nama Peserta: '.$nama.'
Silakan login pada halaman berikut '.$CONFIG['url_apps'].' untuk melakukan verifikasi data.
Terima kasih.
';
if (!empty($ps)) {
$s = "SELECT * FROM pegawai WHERE kd_program_studi_pegawai='$ps'";
$h = cmd_query($s);
while ($r = cmd_fetch_array($h)) {
$email = $r['email_pegawai'];
if (empty($email)) continue;
send_mail($email,'no_reply@yarsi.ac.id',$subject,$mailtext);
}
}
$s = "SELECT * FROM pegawai WHERE kd_fakultas_pegawai='$fak' AND (kd_program_studi_pegawai='' OR kd_program_studi_pegawai IS NULL)";
$h = cmd_query($s);
while ($r = cmd_fetch_array($h)) {
$email = $r['email_pegawai'];
if (empty($email)) continue;
if (is_sent($subject,$email)) continue;
send_mail($email,'no_reply@yarsi.ac.id',$subject,$mailtext);
}
}
function send_notif_mail_d2($no_pendaftaran,$ps_asal,$fak,$ps='') {
global $CONFIG,$conn;
$sc = "SELECT * FROM TM_FORMULIR_YG_TERBAYAR WHERE NO_PENDAFTARAN='$no_pendaftaran'";
$hc = cmd_query($sc);
$rc = cmd_fetch_array($hc);
$nama = strip_s($rc['NAMA_CALON_MHS']);
$tahun = $rc['TAHUN_AKADEMIK'];
$gel = $rc['GELOMBANG'];
$add_tks = " Ditawarkan dari Prodi $ps_asal";
$subject = '[Sistem PMB UYARSI] Pendaftaran Peserta PMB Baru ($add_tks)';
$mailtext = '
Assalamualaikum Wr. Wb.,
Anda memiliki tambahan 1 peserta PMB UYARSI yang telah ditawarkan oleh Prodi $add_tks sbb: Tahun pendaftaran: '.$tahun.' Gelombang: '.$gel.' No. Pendaftaran: '.$no_pendaftaran.' Nama Peserta: '.$nama.'
Silakan login pada halaman berikut '.$CONFIG['url_apps'].' untuk melakukan verifikasi data.
Terima kasih.
';
if (!empty($ps)) {
$s = "SELECT * FROM pegawai WHERE kd_program_studi_pegawai='$ps'";
$h = cmd_query($s);
while ($r = cmd_fetch_array($h)) {
$email = $r['email_pegawai'];
if (empty($email)) continue;
send_mail($email,'no_reply@yarsi.ac.id',$subject,$mailtext);
}
}
$s = "SELECT * FROM pegawai WHERE kd_fakultas_pegawai='$fak' AND (kd_program_studi_pegawai='' OR kd_program_studi_pegawai IS NULL)";
$h = cmd_query($s);
while ($r = cmd_fetch_array($h)) {
$email = $r['email_pegawai'];
if (empty($email)) continue;
if (is_sent($subject,$email)) continue;
send_mail($email,'no_reply@yarsi.ac.id',$subject,$mailtext);
}
}
function send_notif_dekan($no_pendaftaran,$fak,$ps='') {
global $conn;
$sc = "SELECT * FROM TM_FORMULIR_YG_TERBAYAR WHERE NO_PENDAFTARAN='$no_pendaftaran'";
$hc = cmd_query($sc);
$rc = cmd_fetch_array($hc);
$nama = strip_s($rc['NAMA_CALON_MHS']);
$tahun = $rc['TAHUN_AKADEMIK'];
$gel = $rc['GELOMBANG'];
$subject = '[Sistem PMB UYARSI] Proses verifikasi data peserta PMB No. Pendaftaran '.$no_pendaftaran.' ('.strip_s($nama).') telah lengkap';
$mailtext = '
Assalamualaikum Wr. Wb.,
Peserta PMB UYARSI berikut telah selesai diverifikasi data-data nilai rapor dan ijazah nya dan sudah lengkap:
Tahun pendaftaran: '.$tahun.' Gelombang: '.$gel.' No. Pendaftaran: '.$no_pendaftaran.' Nama Peserta: '.$nama.'
Silakan login pada halaman berikut '.$CONFIG['url_apps'].' untuk untuk proses seleksi selanjutnya.
Terima kasih.
';
$s = "SELECT * FROM pegawai AS p INNER JOIN users AS u ON u.l_pegawai_user=p.id_pegawai
WHERE p.kd_fakultas_pegawai='$fak' AND (u.l_role_user=7 OR u.l_role_user=8)";
$h = cmd_query($s);
while ($r = cmd_fetch_array($h)) {
$email = $r['email_pegawai'];
if (empty($email)) continue;
if (is_sent($subject,$email)) continue;
send_mail($email,'no_reply@yarsi.ac.id',$subject,$mailtext);
}
}
function is_sent($subject,$email) {
global $CONFIG,$conn;
$subject = add_s($subject);
$s = "SELECT COUNT(*) FROM email_notif_log
WHERE subject_email_notif='$subject' AND (email_address='$email')";
$h = cmd_query($s);
list($tot) = cmd_fetch_array($h);
if ($tot > 0) return true;
else {
$s = "INSERT INTO email_notif_log (subject_email_notif,email_address)
VALUES ('$subject','$email')";
$h = cmd_query($s);
return false;
}
}
function send_mail($to,$email_pmb,$subject,$mailtext,$email_cc='') {
global $CONFIG,$conn;
if (empty($to) || empty($mailtext)) return false;
if (!empty($to) && filter_var($to, FILTER_VALIDATE_EMAIL)) {
$txtEmail = $to;
$headers = 'From: PMB YARSI <'.$email_pmb.'>';
$mail = new PHPMailer;
//$mail->SMTPDebug = 4; // debugging: 1 = errors and messages, 2 = messages only
$mail->isSMTP(); // Set mailer to use SMTP
$mail->Host = $CONFIG['mail']['Host']; // Specify main and backup SMTP servers
$mail->Port = $CONFIG['mail']['Port'];
$mail->SMTPAuth = true; // Enable SMTP authentication
$mail->Username = $CONFIG['mail']['Username']; // SMTP username
$mail->Password = $CONFIG['mail']['Password']; // SMTP password
$mail->SMTPSecure = $CONFIG['mail']['SMTPSecure']; // Enable encryption, 'ssl' also accepted
$mail->From = $CONFIG['mail']['From'];
$mail->FromName = $CONFIG['mail']['FromName'];
$mail->addAddress($txtEmail); // Add a recipient
//$mail->addAddress('ellen@example.com'); // Name is optional
//$mail->addReplyTo('info@example.com', 'Information');
if (!empty($email_cc)) $mail->addCC($email_cc);
//$mail->addBCC('pmb.no_reply@yarsi.ac.id');
//$mail->WordWrap = 50; // Set word wrap to 50 characters
//$mail->addAttachment('/var/tmp/file.tar.gz'); // Add attachments
//$mail->addAttachment('/tmp/image.jpg', 'new.jpg'); // Optional name
$mail->isHTML(true); // Set email format to HTML
$mail->Subject = $subject;
$mail->Body = $mailtext;
//$mail->AltBody = 'This is the body in plain text for non-HTML mail clients';
$mail->copyToFolder("Sent");
save_log('Sending email to '.$to."...\n");
if(!$mail->send()) {
if ($_SERVER['REMOTE_ADDR'] == '10.10.11.232') {
$deb = "Message could not be sent. \n";
$deb .= 'Mailer Error: ' . $mail->ErrorInfo;
save_log($deb);
}
}
} else {
if (!empty($to)) {
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= 'From: PMB YARSI <'.$email_pmb.'>';
mail($to,$subject,$mailtext,$headers);
}
}
}
function save_log($somecontent, $exit = false) {
$filename = 'debug.log';
if (!$handle = fopen($filename, 'a')) {
echo "Cannot open file ($filename)";
exit;
}
// Write $somecontent to our opened file.
if (fwrite($handle, $somecontent) === FALSE) {
echo "Cannot write to file ($filename)";
exit;
}
fclose($handle);
if ($exit) {
echo $somecontent;
exit;
}
}
function get_pmb_config() {
global $CONFIG,$conn;
$sql = "select * from CONFIG_PMB where aktif_config_pmb=1";
$h = cmd_query($sql);
while ($r = cmd_fetch_array($h)) {
$config_name = $r['nama_config_pmb'];
$CONFIG[$config_name] = $r['value_config_pmb'];
}
if ($_SERVER['REMOTE_ADDR'] == '10.10.11.232') {
//deb_echo('
$CONFIG = '.print_r($CONFIG,true).'
',false);
}
}
function get_thn_aktif_pmb($string=1,$field="") {
global $CONFIG,$conn;
$strSQL = "SELECT t.* FROM pmb_akademik_semester AS t WHERE t.aktif_akademik_semester='Y' LIMIT 1";
$hasil = cmd_query($strSQL);
$arr_thn = array('Gan'=>'Gasal', 'Gen'=>'Genap', 'P'=>'Pendek');
$baris = cmd_fetch_array($hasil);
if ($string == 1)
return $baris['tahun_awal_akademik_semester'].'/'.$baris['tahun_akhir_akademik_semester'].' Semester '.$arr_thn[$baris['sub_akademik_semester']];
else {
if (!empty($field)) return $baris[$field];
else return $baris;
}
}
function get_thn_pmb($l_akademik_semester,$string=1,$field="") {
global $CONFIG,$conn;
$strSQL = "SELECT t.* FROM pmb_akademik_semester t WHERE l_semester=id_semester AND id_akademik_semester='$l_akademik_semester'";
$hasil = cmd_query($strSQL);
$baris = cmd_fetch_array($hasil);
if ($string == 1)
return $baris['tahun_awal_akademik_semester'].'/'.$baris['tahun_akhir_akademik_semester'].' Semester '.$arr_thn[$baris['sub_akademik_semester']];
else {
if (!empty($field)) return $baris[$field];
else return $baris;
}
}
function get_harga_formulir($thn,$kdfak,$kdprodi) {
global $CONFIG,$conn;
$s = "SELECT * FROM pmb_biaya WHERE angkatan='$thn' AND KD_FAKULTAS='$kdfak' AND KD_PROGRAM_STUDI='$kdprodi' AND nama_biaya='Formulir' LIMIT 1";
$h = cmd_query($s);
$r = cmd_fetch_array($h);
if (empty($r['jumlah'])) $r['jumlah'] = 0;
return $r['jumlah'];
}
function is_ok_kartu_ujian($no_pendaftaran) {
global $CONFIG,$conn;
$s = "SELECT * FROM pmb_tagihan WHERE no_pendaftaran='$no_pendaftaran' AND l_jenis_biaya='7'";
$h = cmd_query($s);
$r = cmd_fetch_array($h);
if ($r['total_tagihan'] > 0 && $r['total_bayar'] > 0 && $r['total_bayar'] >= $r['total_tagihan']) {
//deb_echo($r);
return true;
}
return false;
}
function is_lulus_tahap1($no_pendaftaran) {
global $CONFIG,$conn;
$s = "SELECT COUNT(*) FROM TM_FORMULIR_YG_TERBAYAR WHERE no_pendaftaran='$no_pendaftaran' AND UJIAN_TAHAP1='L'";
$h = cmd_query($s);
list($tot) = cmd_fetch_array($h);
if ($tot > 0) {
return true;
}
return false;
}
function is_pmb_open() {
global $CONFIG,$conn;
$tnow = time();
$tstart = mysql_to_ts($CONFIG['register_start']);
$tstop = mysql_to_ts($CONFIG['register_stop']);
$allow_reg = $CONFIG['allow_reg_ips'];
if ($CONFIG['pmb_global_close']) return false;
if (preg_match('/,/i',$allow_reg)) {
$arr_allow = explode(",",$allow_reg);
} else {
$arr_allow = array($allow_reg);
}
//echo 'allow_reg = '.$allow_reg.' ';exit;
foreach ($arr_allow as $ip) {
$str_search = array('.');
$str_replace = array('\\.');
$ip = str_replace($str_search, $str_replace, $ip);
if (preg_match('/^'.$ip.'/i',$_SERVER['REMOTE_ADDR'])) {
return true;
}
}
/*if (preg_match('/^10\\.10\\.11\\./i',$_SERVER['REMOTE_ADDR'])) {
return true;
}*/
if ($_SERVER['REMOTE_ADDR'] == '10.10.11.232' || $_SERVER['REMOTE_ADDR'] == '202.80.214.28') {
//echo '$tnow = '.$tnow.' - '.date('Y-m-d').' '.$CONFIG['register_start'].' ';
//echo '$tstart = '.$tstart.' ';
//echo '$tstop = '.$tstop.' ';
//exit();
//return true;
}
if ($tnow >= $tstart && $tnow < $tstop) {
return true;
} else {
return false;
}
}
function xml_header() {
global $CONFIG,$conn;
echo '
Sisfo PMBSisfo PMB'.date('Y-m-d').'T'.date('H:i:s').'Z'.date('Y-m-d').'T'.date('H:i:s').'Z16.0097502160000FalseFalse
';
}
function xml_footer() {
global $CONFIG;
echo '
200200FalseFalse';
}
function gen_ldap ($npm,$user_info,$no=1,$is_update=true) {
global $CONFIG,$cookiename;
$con1 = $_SESSION[$cookiename]['con1'];
if (is_array($user_info) && $is_update) {
$sql="SELECT * FROM akses_proxy_pdc WHERE npm='$npm'";
$h=mysqli_query($con1,$sql) or die("Can't query $sql; ".mysqli_error($con1));
$r=mysqli_fetch_array($h);
if (empty($r['username_proxy'])) {
return gen_ldap ($npm,$user_info,$no,false);
}
$bgcolor = (($no % 2) == 0) ? 'windowbg2' : 'windowbg1';
$body_tab = '
'.$no.'
'.$npm.'
'.$r['nama_lengkap'].'
'.$r['username_proxy'].'
'.$r['password_default'].'
';
/*
$cn = str_replace('.','',$r['username_proxy']);
del_user($cn);
$s = "DELETE FROM akses_proxy_pdc WHERE username_proxy='".$r['username_proxy']."' LIMIT 1";
$h = mysqli_query($con1,$s) or die('Error: '.$s.'; '.mysqli_error($con1));
$body_tab = '';
*/
return $body_tab;
}
$uname = set_username($user_info['nama_lengkap'],$user_info['npm']);
$cn = $uname;
$npm = $user_info['npm'];
$passwd = generatePassword();
$user_info['passwd'] = $passwd;
$user_info['uid'] = $cn;
$user_info['cn'] = $cn;
if (_ldap_add($user_info)) {
$fakultas=substr($npm,1,1);
extract($user_info);
$tanggal_registrasi=date('Y-m-d');
list($count) = mysqli_fetch_array(mysqli_query($con1,"SELECT COUNT(*) FROM akses_proxy_pdc WHERE username_proxy='$uname'"));
if ($count < 1) {
//insert into akses_proxy_pdc
$sql="insert into akses_proxy_pdc(username_proxy,nama_lengkap,fakultas,npm,tipe_user,user_role,tgl_lhr,no_telp,no_hp,alamat,kodepos,email,
status,max_user,tgl_registrasi,password_default)
values('$uname','".add_s($nama_lengkap)."','$fakultas','$npm','$tipe_user','$user_role','$tgl_lhr','$notelp','$hp','".add_s($alamat)."','$kodepos','$email',
'1','1','$tanggal_registrasi','$passwd')";
$query=mysqli_query($con1,$sql) or die("Can't query $sql; ".mysqli_error($con1));
} else {
$s = "SELECT * FROM akses_proxy_pdc WHERE username_proxy='$uname'";
$h = mysqli_query($con1,$s) or die('Error: '.$s.'; '.mysqli_error($con1));
$r = mysqli_fetch_array($h);
if (empty($r['npm'])) $update = true;
$sql = "update akses_proxy_pdc set fakultas='$fakultas',npm='$npm',tipe_user='$tipe_user',user_role='$user_role',tgl_lhr='$tgl_lhr',no_telp='$notelp',no_hp='$hp',alamat='".add_s($alamat)."',kodepos='$kodepos',email='$email'
where username_proxy='$uname' LIMIT 1";
$query = mysqli_query($con1,$sql) or die("Error $sql: ".mysqli_error($con1));
}
$nama_lengkap = strtoupper($nama_lengkap);
//$no++;
$bgcolor = (($no % 2) == 0) ? 'windowbg2' : 'windowbg1';
//if ($no == 1) $bgcolor = 'windowbg1';
$body_tab = '
'.$no.'
'.$npm.'
'.$nama_lengkap.'
'.$uname.'
'.$passwd.'
';
$body_tab = array($uname,$passwd);
//deb_echo($body_tab,false);
$subject = 'Welcome to UYARSI!';
$message = "Selamat $nama_lengkap! Sekarang Anda sudah memiliki account Single Login YARSI dan fasilitas email dari UYARSI sebesar 10MB.
\n\nAlamat email Anda adalah: ".$email_yarsi." dan dapat diakses melalui http://students.yarsi.ac.id
\n\n";
$message .= "Informasi login:
\n\Nomor Pokok Mahasiswa: ".$npm." \nUsername: ".$uname." \nPassword: ".$passwd."
\n\n";
//if (preg_match('/^11/',$uname)) {
// $message .= "Anda juga dapat menggunakan informasi login diatas untuk login ke Sistem Akademik FK (http://medinfo.yarsi.ac.id) dan Sistem E-Learning FK (http://layar.yarsi.ac.id)
\n\n";
//} else {
$message .= "Anda juga dapat menggunakan informasi login diatas untuk login ke Sistem Akademik YARSI (https://sisakad.yarsi.ac.id) dan Sistem E-Learning YARSI (https://layar.yarsi.ac.id)
\n\n";
//}
$message .= "Untuk mengganti password account Single Login YARSI di atas, silakan ke link berikut https://www.yarsi.ac.id/ganti-password-akun-yarsi \nJika Anda memiliki kesulitan login atau ada pertanyaan lebih lanjut, silakan datang ke OPTIMA-ITT di lantai 1, Universitas YARSI.
\n\n";
$message .= "Salam, \nUniversitas YARSI
\n\n";
$headers = 'From: Univ. YARSI ';
$from = 'admin@yarsi.ac.id';
//send_mail($from,$email,$subject,$message,'');
return $body_tab;
} else return false;
}
function generatePassword() {
$passwd=rand(100000,999999);
return ($passwd);
}
function set_username($txtNamaLengkap,$nim) {
global $CONFIG,$ds;
$txtNamaLengkap = strtolower(str_replace(array("'",'"',"''",'""','-',','),'',trim($txtNamaLengkap)));
$explode=explode(" ",$txtNamaLengkap);
if (count($explode) > 1) {
// namadepan.namakedua@
$user_email=$explode[0].".".$explode[1];
$user_email= str_replace('..','.',$user_email);
$duplikat=cek_duplikat_user($user_email);
if ($duplikat>0) {
if (!empty($explode[2])){
# salman.pratista
$user_email=$explode[0].".".$explode[2];
if(cek_duplikat_user($user_email)>0){
# s.teguh
$user_email=substr($explode[0],0,1).".".$explode[1];
$user_email= str_replace('..','.',$user_email);
if (cek_duplikat_user($user_email)>0){
# s.pratista
$user_email=substr($explode[0],0,1).".".$explode[2];
$user_email= str_replace('..','.',$user_email);
if (cek_duplikat_user($user_email)>0){
$user_email=create_alternate_user($explode[0],$nim);
$user_email= str_replace('..','.',$user_email);
}
}
}
}else{
# s.teguh
$user_email=substr($explode[0],0,1).".".$explode[1];
$user_email= str_replace('..','.',$user_email);
if (cek_duplikat_user($user_email)>0){
$user_email=create_alternate_user($explode[0],$nim);
$user_email= str_replace('..','.',$user_email);
}
}
}
$user_login=$user_email;
} else {
// namadepan@
$user_email=$explode[0];
// cek apakah ada duplikat?
if (cek_duplikat_user($user_email)>0){
$user_email=create_alternate_user($explode[0],$nim);
}
$user_login=$user_email;
}
$user_login=$user_email;
return($user_login);
}
function create_alternate_user($nama_depan,$id_number) {
if (strlen($id_number)==10) {
$fakultas=substr($id_number,1,1);
$tiga3=substr($id_number,-3);
$username=$nama_depan.$fakultas.$tiga3;
} else {
$username=$nama_depan.substr($id_number,-3);
}
return($username);
}
function cek_duplikat_user($user_login) {
global $CONFIG,$cookiename,$con1;
if (!$con1) {
$con1 = $_SESSION[$cookiename]['con1'];
}
$s = "SELECT COUNT(*) FROM akses_proxy_pdc WHERE username_proxy='$user_login'";
$h = mysqli_query($con1,$s) or die('$s = '.$s.' '.mysqli_error($con1));
list($count) = mysqli_fetch_array($h);
return $count;
}
function _ldap_add($user_info) {
global $CONFIG,$ds;
extract($user_info);
//deb_echo($user_info);
$dbind = true;
if($dbind) {
$entry = array();
$entry['objectclass'][] = "inetOrgPerson";
$entry['objectclass'][] = "organizationalPerson";
$entry['objectclass'][] = "person";
$entry['objectclass'][] = "qmailUser";
$entry['objectclass'][] = "top";
if (empty($nama_lengkap)) {
die("_ldap_add Nama lengkap ($nama_lengkap) kosong!
".print_r($user_info,true)."
");
}
$nama_lengkap = strip_s($nama_lengkap);
if (!empty($nama_lengkap)) {
$cn = str_replace(array('"',"'"),'',strip_s($cn));
$entry['uid'] = $cn;
$entry['cn'] = $cn;
$entry['displayName'] = $nama_lengkap;
$cna = explode(" ",trim($nama_lengkap));
$jml = count($cna)-1;
$entry['givenName'] = $cna[0];
$entry['sn'] = $cna[$jml];
}
if (!empty($hp)) {
if ($hp != "-" && $hp != "---") {
$entry['telephoneNumber']=str_replace(array('*','_','(',')',' ','"',"'","`"),'',trim($hp));
}
}
if (!empty($alamat)) {
$entry['street']=$alamat;
}
if (!empty($npm)){
$entry['description']=$npm;
}
if (!empty($notelp)) {
if ($notelp != "-" && $notelp != "---") {
$entry['homePhone']=str_replace(array('*','_','(',')',' ','"',"'","`"),'',trim($notelp));
}
}
if (!empty($kodepos)){
$entry['homePostalAddress']=str_replace(array('*','_','(',')',' ','"',"'","`"),'',trim($kodepos));
}
if (!empty($kota)){
$entry['l']=str_replace(array('*','_','(',')','"',"'"),'',trim($kota));
}
if (!empty($tipe_user)){
$entry['title']=$tipe_user;
}
if (!empty($user_role)){
$entry['pager']=$user_role;
}
if (strlen($npm)==10) {
$domain_email="students.yarsi.ac.id";
$group_default="Students";
} else {
$domain_email="yarsi.ac.id";
$group_default="Staffs";
}
$entry['mail'][] = $cn."@".$domain_email;
//$entry['qmailUID'] = $info[0]["uidnumber"][0];
$entry['mailHost'] = $domain_email;
$entry['mailMessageStore'] = "/home/vmail/".$cn;
if (!empty($email)){
$entry['mailAlternateAddress'][]=$email;
}
$entry['userPassword'] = "{SHA}".base64_encode(pack("H*",sha1($passwd)));
$result = ldap_search($ds,"dc=yarsi,dc=ac,dc=id", "(ou=Users)") or die ("Error in search query");
$info = ldap_get_entries($ds,$result);
$entry['qmailDotMode'] = "ldaponly";
$entry['qmailUID'] = 37000+$info['count']+1;
$entry['qmailGID'] = 513;
if(!ldap_add($ds, "uid=$cn, ou=Users,dc=yarsi,dc=ac,dc=id", $entry)) {
$error = ldap_error($ds);
if (preg_match('/Already exists/i',$error)) {
//save_log("User $cn already added to ldap: $error!\n",false);
return true;
}
else die('Tidak dapat menambah user '.$cn.' ke LDAP!
'.print_r($entry,true).'
Error: ' . ldap_error($ds));
} else {
$group = array();
$group['memberUid'][]=$cn;
ldap_mod_add($ds, "cn=".$group_default.",ou=Groups,dc=yarsi,dc=ac,dc=id", $group);
$entry2 = array();
$entry2['objectclass'][] = "posixAccount";
$entry2['uidNumber'] = $entry['qmailUID'];
$entry2['gidNumber'] = 513;
$entry2['homeDirectory'] = '/home/'.$cn;
$entry2['loginShell'] = '/bin/bash';
if (!ldap_mod_add($ds, "uid=".$cn.",ou=Users,dc=yarsi,dc=ac,dc=id", $entry2)) {
die('Tidak dapat menambah user '.$cn.' ke LDAP! Error: ' . ldap_error($ds) . '; Count data: ' . $info['count']);
}
if(!ldap_mod_replace($ds, "uid=".$cn.",ou=Users,dc=yarsi,dc=ac,dc=id", array('userPassword' => "{SHA}".base64_encode(pack("H*",sha1($passwd)))))) {
die('Tidak dapat mengganti password LDAP!');
}
//ldap_close($ds);
return true;
}
} else return false;
}
function del_user($user_login) {
global $CONFIG,$ds;
$result = ldap_search($ds,"dc=yarsi,dc=ac,dc=id", "(uid=$user_login)") or die ("Error in search query");
$info = ldap_get_entries($ds,$result);
$value=$info[0][uid][0];
$match=@ldap_delete($ds, "uid=".$user_login.",ou=Users,dc=yarsi,dc=ac,dc=id");
$group['memberUid'][]=$user_login;
$match1=@ldap_mod_del($ds, "cn=Staffs,ou=Groups,dc=yarsi,dc=ac,dc=id", $group);
$match2=@ldap_mod_del($ds, "cn=Students,ou=Groups,dc=yarsi,dc=ac,dc=id", $group);
return($match);
}
function cek_pic($file_name) {
global $CONFIG;
$dir = $CONFIG['pic_location'];
//deb_echo('Checking = '.$dir.$file_name,false);
if (empty($file_name)) return false;
if (file_exists($dir.'/'.$file_name.'.jpg')) {
return true;
} else return false;
}
function get_thn_by_ta($thn_awal,$smt,$field='') {
global $CONFIG,$cookiename,$con_sisakad;
if (!$con_sisakad) {
$con_sisakad = $_SESSION[$cookiename]['con_sisakad'];
}
$s = "SELECT * FROM akademik_semester WHERE tahun_awal='$thn_awal' AND l_semester='$smt' LIMIT 1";
$h = mysqli_query($con_sisakad,$s) or die(mysqli_error($con_sisakad));
$r = mysqli_fetch_array($h);
if (!empty($field)) {
return $r[$field];
} else return $r;
}
function get_mhs_by_npm($npm,$field='') {
global $CONFIG,$cookiename,$con_sisakad;
if (!$con_sisakad) {
$con_sisakad = $_SESSION[$cookiename]['con_sisakad'];
}
$s = "SELECT * FROM mahasiswa WHERE nomor_induk_mahasiswa='$npm' LIMIT 1";
$h = mysqli_query($con_sisakad,$s) or die(mysqli_error($con_sisakad));
$r = mysqli_fetch_array($h);
if (!empty($field)) {
return $r[$field];
} else return $r;
}
function get_stats($what,$type=0) {
global $CONFIG,$cookiename,$con_sisakad;
if (!$con_sisakad) {
$con_sisakad = $_SESSION[$cookiename]['con_sisakad'];
}
if ($type == 0) {
switch (strtolower($what)) {
case ('baru'):
$stats = '1';
break;
case '0':
$stats = '1';
break;
case ('pindahan'):
$stats = '2';
break;
case '1':
$stats = '2';
break;
case 'p':
$stats = '2';
break;
case 'pf':
$stats = '3';
break;
case 'pp':
$stats = '4';
break;
default:
$stats = '1';
break;
}
} else if ($type == 1) {
switch (strtolower($what)) {
case 'indonesia':
$stats = '1';
break;
case 'asing':
$stats = '2';
break;
}
} else if ($type == 2) {
$stats = '6';
switch (strtolower($what)) {
case 'ya':
case 'lulus':
$stats = '5';
break;
case 'aktif':
case 'tidak (belum)':
$stats = '1';
break;
case 'nn':
case 'non aktif':
$stats = '6';
break;
case preg_match('/ud/',$what):
case 'undur diri':
$stats = '4';
break;
case '?':
$stats = '6';
break;
}
//deb_echo('$what = '.$what.'; $stats = '.$stats);
} else if ($type == 3) {
if (empty($what)) return '0#0';
$kotakabupaten = strtolower(str_replace(' ','%',$what));
$s = "SELECT id_kota_kabupaten,l_propinsi FROM kota_kabupaten WHERE nama_kota_kabupaten like '%$kotakabupaten%'
ORDER BY nama_kota_kabupaten DESC LIMIT 1";
$h = mysqli_query($con_sisakad,$s) or die(mysqli_error($con_sisakad));
$r = mysqli_fetch_array($h);
if (!empty($r['id_kota_kabupaten']) && !empty($kotakabupaten)) {
$stats = $r['id_kota_kabupaten'].'#'.$r['l_propinsi'];
} else $stats = '0#0';
} else if ($type == 4) {
switch (strtolower($what)) {
case 'l':
$stats = 'l';
break;
case 'laki-laki':
$stats = 'l';
break;
case 'p':
$stats = 'p';
break;
case 'perempuan':
$stats = 'p';
break;
}
} else if ($type == 5) {
$agama = $what;
$s = "SELECT id_agama FROM agama WHERE nama_agama='$agama' LIMIT 1";
$h = mysqli_query($con_sisakad,$s) or die(mysqli_error($con_sisakad));
$r = mysqli_fetch_array($h);
$stats = $r['id_agama'];
} else if ($type == 6) {
$gol_darah = strtoupper($what);
$s = "SELECT id_golongan_darah FROM golongan_darah WHERE kd_golongan_darah='$gol_darah' LIMIT 1";
$h = mysqli_query($con_sisakad,$s) or die(mysqli_error($con_sisakad));
$r = mysqli_fetch_array($h);
$stats = $r['id_golongan_darah'];
} else if ($type == 7) {
$status_nikah = $what;
$s = "SELECT id_status_nikah FROM status_nikah WHERE keterangan='$status_nikah' LIMIT 1";
$h = mysqli_query($con_sisakad,$s) or die(mysqli_error($con_sisakad));
$r = mysqli_fetch_array($h);
$stats = $r['id_status_nikah'];
}
return $stats;
}
function get_id_dos_by_inisial($what,$l_fakultas,$l_program_studi,$field="id_karyawan") {
global $con_sisakad;
if (!$con_sisakad) {
$con_sisakad = $_SESSION[$cookiename]['con_sisakad'];
}
$s = "SELECT * FROM karyawan WHERE inisial='$what' AND l_fakultas='$l_fakultas' AND l_program_studi='$l_program_studi' LIMIT 1";
$h = mysqli_query($con_sisakad,$s) or die(mysqli_error($con_sisakad));
$r = mysqli_fetch_array($h);
if (!empty($field)) {
return $r[$field];
} else return $r;
}
function e_deb($varname,$value,$exit=0) {
echo ''.$varname.' = '.$value.' ';
if ($exit == 1) exit;
}
//20 September 1982 -> 1982-09-20
function tgl_id_2_db($what) {
$what = strtolower($what);
if (preg_match('/^(\\d{4})-(\\d{2})-(\\d{2})$/i',trim($what))) return $what;
$what = str_replace("'",'',$what);
$what = str_replace("-",' ',$what);
$what = str_replace("/",' ',$what);
$what = str_replace("peb",'feb',$what);
$what = str_replace("nop",'nov',$what);
$what = preg_replace("/\\s+/i",' ',$what);
$tgl = explode(' ',trim($what));
$tgl_t = trim($tgl[0]);
$tgl_t = ($tgl_t < 0 && substr($tgl_t,0,1) != '0') ? "0$tgl_t" : $tgl_t;
$tgl_b = to_month(trim($tgl[1]));
$tgl_th = trim($tgl[2]);
if (!empty($tgl_t) && !empty($tgl_b) && !empty($tgl_th))
return "$tgl_th-$tgl_b-$tgl_t";
else return "0000-00-00";
}
function to_month($what) {
$str_search = array('januari','februari','maret','april','mei','juni','juli','agustus','september','oktober',
'november','desember');
$str_search2 = array('jan','feb','mar','apr','mei','jun','jul','agu','sep','okt','nov','des');
$str_search3 = array('jan','feb','mar','apr','may','jun','jul','aug','sep','oct','nov','dec');
$str_replace = array('01','02','03','04','05','06','07','08','09','10','11','12');
$res = str_replace($str_search,$str_replace,strtolower($what));
$res = str_replace($str_search2,$str_replace,strtolower($res));
$res = str_replace($str_search3,$str_replace,strtolower($res));
return $res;
}
function get_sek_type($what) {
switch (strtoupper($what)) {
case 'GONTOR':
$jenis_sek = '3';
break;
case 'MA':
$jenis_sek = '3';
break;
case 'SMA':
$jenis_sek = '1';
break;
case 'SMU':
$jenis_sek = '1';
break;
case 'SMY':
$jenis_sek = '1';
break;
case 'SLTA':
$jenis_sek = '1';
break;
case 'SMA N':
$jenis_sek = '1';
break;
case 'SMAN':
$jenis_sek = '1';
break;
case 'SMAI':
$jenis_sek = '1';
break;
case 'SMUI':
$jenis_sek = '1';
break;
case 'SMK':
$jenis_sek = '2';
break;
case 'STM':
$jenis_sek = '4';
break;
case 'SMK-SMIP':
$jenis_sek = '2';
break;
default :
$jenis_sek = '1';
break;
}
return $jenis_sek;
}
is_user();
?>
Warning: Undefined array key "action" in /var/www/clients/client4/web10/web/pmb/pendaftaran/login.php on line 11
Warning: Undefined array key "from_sisakad" in /var/www/clients/client4/web10/web/pmb/pendaftaran/login.php on line 26
Fatal error: Uncaught Error: Call to undefined function is_user() in /var/www/clients/client4/web10/web/pmb/pendaftaran/login.php:29
Stack trace:
#0 {main}
thrown in /var/www/clients/client4/web10/web/pmb/pendaftaran/login.php on line 29
';
}
} else {
$field_title = ''.$field_title.' ';
}
}
$print_th = '