if (preg_match("/func.php/i",$_SERVER["PHP_SELF"])) {
Header("Location: ../index.php");
die();
}
ob_start();
session_start();
include ("config.php");
//include ("security.php");
//$locale = array("in_ID","in_IN","id_ID","id_IN","Indonesian_Indonesia","indonesian");
$loc_id = setlocale(LC_ALL, $CONFIG['locale']);
include "includes/func.db.php";
require 'phpmailer/PHPMailerAutoload.php';
$host_mysql = 'db1.yarsi.ac.id';
$user_mysql = 'website';
$pass_mysql = 'networkwebsite';
$dbmhs_mysql = 'db_mahasiswa';
$dbproxy_mysql = 'proxy';
$con_mysql = mysql_connect($host_mysql,$user_mysql,$pass_mysql) or die('Can\'t connect to '.$host_mysql.'; '.mysql_error());
$conn=cmd_conn();
$permission = array();
if (!function_exists('eregi')) {
function eregi($Expression, $Value) {
return preg_match("/{$Expression}/i", $Value);
}
}
/**
* Perform an LDAP search using comma seperated search strings
*
* @param string search string of search values
*/
function _ldap_simple_search($ds,$dn,$search)
{
$results = explode(';', $search);
foreach($results as $key=>$result) {
$results[$key] = '('.$result.')';
}
return _ldap_search($ds,$dn,$results);
}
/**
* Perform an LDAP search
*
* @param array Search Filters (array of strings)
* @param string DN Override
* @return array Multidimensional array of results
* @access public
*/
function _ldap_search($lconn, $dn, $filters)
{
$attributes = array ();
foreach ($filters as $search_filter)
{
$search_result = @ldap_search($lconn, $dn, $search_filter);
if ($search_result && ($count = @ldap_count_entries($lconn, $search_result)) > 0)
{
for ($i = 0; $i < $count; $i++)
{
$attributes[$i] = Array ();
if (!$i) {
$firstentry = @ldap_first_entry($lconn, $search_result);
} else {
$firstentry = @ldap_next_entry($lconn, $firstentry);
}
$attributes_array = @ldap_get_attributes($lconn, $firstentry); // load user-specified attributes
// ldap returns an array of arrays, fit this into attributes result array
foreach ($attributes_array as $ki => $ai)
{
if (is_array($ai))
{
$subcount = $ai['count'];
$attributes[$i][$ki] = Array ();
for ($k = 0; $k < $subcount; $k++) {
$attributes[$i][$ki][$k] = $ai[$k];
}
}
}
$attributes[$i]['dn'] = @ldap_get_dn($lconn, $firstentry);
}
}
}
return $attributes;
}
function is_user() {
global $CONFIG,$cookiename,$permission;
if (!empty($_SESSION[$cookiename]['user_id'])) {
$strsql = "SELECT * FROM TM_PERMISSION WHERE 1";
$res = cmd_query($strsql);
$_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) {
$_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 (@array_search($ijin,$_SESSION[$cookiename]['permission']) === false) {
$ok = false;
}
}
if ($ok) return true;
}
return false;
}
function get_perm($ijin) {
global $permission, $cookiename;
if ($_SESSION[$cookiename]['id_role'] == 1) return true;
else return (@array_search($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;
if ($tipe == 'mysql') {
if ($con)
$mysqlmsg = mysql_error($con);
else
$mysqlmsg = mysql_error();
}
else if ($tipe == 'mssql') {
if ($con)
$mysqlmsg = mssql_get_last_message($con);
else
$mysqlmsg = mssql_get_last_message();
}
ob_end_clean();
ob_start();
//$judul = "- $title";
page_header($title);
$maincontent = '';
$maincontent .= '
Warning: Undefined variable $judul in /var/www/clients/client4/web10/web/pmbs2/pendaftaran/includes/func.php on line 792
Warning: Undefined variable $isi in /var/www/clients/client4/web10/web/pmbs2/pendaftaran/includes/func.php on line 793
}
function box_menu($judul,$isi) {
return '
';
}
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 (@eregi("::",$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 = '
'.$field_title.'
|
';
//echo $print_th;
return $print_th;
}
function show_field($field,$show=true) {
global $subact, $arr_showfields;
//deb_echo($arr_showfields);
if ($subact != 'show_fields' && $show === true)
return true;
else if (is_array($arr_showfields) && in_array($field,$arr_showfields))
return true;
else return false;
}
function kapital_kata($what,$tabel="") {
$pattern = '/^l_(.*)/i';
$replacement = '$1';
$nama = preg_replace($pattern, $replacement, $what);
if (!empty($tabel))
$nama = str_replace('_'.$tabel,'',$nama);
$nama = str_replace('_',' ',trim($nama));
$exclude_words = array('dg', 'or', 'and', 'dan', 'no', 'tot', 'thn',
'jam', 'smt', 'by', 'ket', 'kos', 'sub', 'tgl', 'lhr', 'mnt', 'dtk');
$arr_nama = explode(" ",$nama);
$nama2 = array();
if (count($arr_nama) > 1) {
foreach($arr_nama as $val) {
$val = trim($val);
if (strlen($val) > 3) {
$nama2[] = ucwords($val);
} else {
if (!in_array($val,$exclude_words))
$nama2[] = strtoupper($val);
else $nama2[] = ucwords($val);
}
}
} else {
if (strlen($nama) > 3) {
$nama2[] = ucwords($nama);
} else {
if (!in_array($nama,$exclude_words))
$nama2[] = strtoupper($nama);
else $nama2[] = ucwords($nama);
}
}
return implode(" ",$nama2);
}
function write_jquery() {
$jout = '
';
return $jout;
}
function kartu_ujian_open() {
global $CONFIG;
if ($CONFIG['buka_kartu_ujian'] === false) return false;
else return true;
}
function upload_file(&$file_data, $id_form_element, $is_replace=false, $old_file_name='', $overwrite_resized=false, $is_img=true, $rename_file='', $check_img_dimension=false) {
global $CONFIG;
if ($is_replace && empty($old_file_name)) error_msg('Old file name not defined!');
$err_class = ' class="error_box"';
$_error = array(); $_err_point = array();
if ($is_img) {
$location = 'pic_location';
$allow_ext = 'allowed_file_extensions';
} else {
$location = 'docs_location';
$allow_ext = 'allowed_docs_extensions';
}
if ($overwrite_resized > 0) {
$resized = $overwrite_resized;
} else if ($overwrite_resized === 0) {
$check_img_dimension = true;
} else {
$resized = $CONFIG['resized'];
}
//deb_echo('$file_data ='.$file_data,false);
if (get_magic_quotes_gpc()) $file_data['name'] = stripslashes($file_data['name']);
$is_img = is_img_ext($file_data['name']);
$forbidden_chars = strtr($CONFIG['forbiden_fname_char'], array('&' => '&', '"' => '"', '<' => '<', '>' => '>', ' ' => ' '));
$file_name = strtr($file_data['name'], $forbidden_chars, str_repeat('_', strlen($CONFIG['forbiden_fname_char'])));
if (!preg_match("/(.+)\.(.*?)\Z/", $file_name, $matches)) {
$matches[1] = 'invalid_fname';
$matches[2] = 'xxx';
}
if ($matches[2]=='' || !stristr($CONFIG[$allow_ext], $matches[2])) {
$_error[] = "
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'].")";
$_err_point[$id_form_element] = $err_class;
} else {
if (stristr($CONFIG['allowed_file_extensions'], strtoupper($matches[2])) || $is_img === true) {
$size = GetImageSize($CONFIG[$location]."/".$file_name);
if (!$size) { $_error[] = "
Tidak bisa membaca ukuran foto! Mohon hubungi Administrator (".$CONFIG['admin_contact'].")"; }
else {
$w = $size[0];
$h = $size[1];
if ($check_img_dimension) {
if (($w < 800) || ($h < 1000)) {
$_error[] = "
Lebar Foto/Hasil Scan harus lebih besar dari 800 pixel dan Tinggi Foto/Hasil Scan harus lebih besar dari 1000 pixel.";
}
} else {
if (($w)||($h)) {
if (max($w,$h) > $resized) {
$errormsg = makeThumbnail($CONFIG[$location]."/".$file_name,
$CONFIG[$location]."/".$file_name,$resized);
if ($errormsg != NULL) $_error[] = "
".$errormsg.". Mohon hubungi Administrator (".$CONFIG['admin_contact'].")";
}
}
}
$errormsg = makeThumbnail($CONFIG[$location]."/".$file_name,
$CONFIG[$location]."/thumb_".$file_name,$CONFIG['thumbsize']);
if ($errormsg != NULL) $_error[] = "
".$errormsg.". Mohon hubungi Administrator (".$CONFIG['admin_contact'].")";
$errormsg = makeThumbnail($CONFIG[$location]."/".$file_name,
$CONFIG[$location]."/athumb_".$file_name,$CONFIG['thumbsize_avatar']);
if ($errormsg != NULL) $_error[] = "
".$errormsg.". 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() {
$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() {
$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='') {
$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] Notifikasi Pendaftaran Peserta PMB Baru';
$mailtext = '
Assalamualaikum Wr. Wb.,
Anda memiliki tambahan 1 peserta PMB yang telah melakukan pembayaran formulir sbb:
Tahun pendaftaran: '.$tahun.'
Gelombang: '.$gel.'
No. Pendaftaran: '.$no_pendaftaran.'
Nama Peserta: '.$nama.'
Silakan login pada halaman berikut https://www.yarsi.ac.id/pmb/pendaftaran 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,'noreply@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;
send_mail($email,'noreply@yarsi.ac.id',$subject,$mailtext);
}
}
function send_mail($to,$email_pmb,$subject,$mailtext,$email_cc='') {
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 = 'mail.yarsi.ac.id'; // Specify main and backup SMTP servers
$mail->Port = 465;
$mail->SMTPAuth = true; // Enable SMTP authentication
$mail->Username = 'noreply@yarsi.ac.id'; // SMTP username
$mail->Password = 'Master2015'; // SMTP password
$mail->SMTPSecure = 'ssl'; // Enable encryption, 'ssl' also accepted
$mail->From = 'pmb@yarsi.ac.id';
$mail->FromName = 'PMB Univ. YARSI';
$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.noreply@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_token_briva() {
global $CONFIG,$bearer;
$client_id = $CONFIG['bri']['client_id'];
$client_secret = $CONFIG['bri']['client_secret'];
$code = $CONFIG['bri']['code'];
$xbrikey = $CONFIG['bri']['X-BRI-KEY'];
$briva_no = $CONFIG['bri']['brivaNo'];
$companyCode = $CONFIG['bri']['companyCode'];
$url_active = $CONFIG['bri']['url_active'];
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "$url_active/token");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
curl_setopt($ch, CURLOPT_HEADER, FALSE);
curl_setopt($ch, CURLOPT_POST, TRUE);
curl_setopt($ch, CURLOPT_POSTFIELDS, "{
\"grant_type\": \"authorization_code\",
\"client_id\": \"$client_id\",
\"client_secret\": \"$client_secret\",
\"code\": \"$code\"
}");
curl_setopt($ch, CURLOPT_HTTPHEADER, array(
"content-type: application/json",
"X-BRI-KEY: $xbrikey"
));
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, FALSE);
$response = curl_exec($ch);
if (!$response) { die ("Error CURL Code: ". curl_error($ch)); }
curl_close($ch);
$response = json_decode($response);
$bearer = $response->data->access_token;
if (!empty($bearer)) return true;
else return false;
}
function create_briva($no_pendaftaran,$nama_mahasiswa) {
global $CONFIG,$bearer;
$xbrikey = $CONFIG['bri']['X-BRI-KEY'];
$briva_no = $CONFIG['bri']['brivaNo'];
$companyCode = $CONFIG['bri']['companyCode'];
$url_active = $CONFIG['bri']['url_active'];
$nama_mahasiswa = strip_s($nama_mahasiswa);
$nama_mahasiswa = str_replace("'","",$nama_mahasiswa);
$ch = curl_init();
$now = time();
$month3 = time() + (3600*24*7*12);
$exp_date = waktu($month3,'','%Y-%m-%d 23:59:59',1);
curl_setopt($ch, CURLOPT_URL, "$url_active/briva");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
curl_setopt($ch, CURLOPT_HEADER, FALSE);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, FALSE);
curl_setopt($ch, CURLOPT_POST, TRUE);
curl_setopt($ch, CURLOPT_POSTFIELDS, "{
\"institutionCode\": \"$companyCode\",
\"brivaNo\": \"$briva_no\",
\"custCode\": \"$no_pendaftaran\",
\"nama\": \"$nama_mahasiswa\",
\"amount\": \"1\",
\"keterangan\": \"Added by system\",
\"expiredDate\": \"$exp_date\"
}");
curl_setopt($ch, CURLOPT_HTTPHEADER, array(
"content-type: application/json",
"Authorization: Bearer $bearer",
"X-BRI-KEY: $xbrikey"
));
$response = curl_exec($ch);
if (!$response) { die ("Error CURL Code: ". curl_error($ch)); }
curl_close($ch);
$response = json_decode($response);
$status = $response->status;
if (empty($status)) {
//exit('$bearer = '.$bearer."\n".'
'.print_r($response,true).'
');
return false;
}
if (!empty($response->data->custCode)) {
return true;
}
return false;
}
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 is_pmb_open() {
global $CONFIG;
$tnow = time();
$tstart = mysql_to_ts($CONFIG['register_start']);
$tstop = mysql_to_ts($CONFIG['register_stop']);
$allow_reg = $CONFIG['allow_reg_ips'];
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) {
$ip = trim($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') {
/*
echo '$tnow = '.$tnow.'
'.$CONFIG['register_start'].'
';
echo '$tstart = '.$tstart.'
';
echo '$tstop = '.$tstop.'
';
*/
//return true;
}
if ($tnow >= $tstart && $tnow < $tstop) {
return true;
} else {
return 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 TOP 1 * FROM pmb_biaya WHERE angkatan='$thn' AND KD_FAKULTAS='$kdfak' AND KD_PROGRAM_STUDI='$kdprodi' AND nama_biaya='Formulir'";
$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']) 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;
}
is_user();
?>
Fatal error: 'break' not in the 'loop' or 'switch' context in
/var/www/clients/client4/web10/web/pmbs2/pendaftaran/includes/jqgrid_dist.php on line
10