File: /home/thehunarfound/public_html/sms/wsw
<?php
include('lib/config.php');
$role=$_SESSION["Role"];
if(isset($_POST['interested_trade1'])){
$application_complete = 1;
if(isset($_FILES["upload_ssc_certificate"])){
$target_dir = "documents/";
$form = $_GET['form_no'];
$ssc ="SSC-CERTIFICATE";
$upload_ssc_certificate =$target_dir . $ssc . $form . basename($_FILES["upload_ssc_certificate"]["name"]);
$uploadOk = 1;
if ($uploadOk == 0) {
// echo "Sorry, your file was not uploaded.";
// if everything is ok, try to upload file
} else {
if (move_uploaded_file($_FILES["upload_ssc_certificate"]["tmp_name"], $upload_ssc_certificate)) {
// echo "The file ". basename( $_FILES["ufile_source"]["name"]). " has been uploaded.";
} else {
$application_complete = 0;
}
}
}else{
$application_complete = 0;
}
if(isset($_FILES["upload_photograph"])){
$target_dir = "documents/";
$form = $_GET['form_no'];
$pic = "PHOTO";
$upload_photograph = $target_dir . $pic . $form . basename($_FILES["upload_photograph"]["name"]);
$uploadOk = 1;
if ($uploadOk == 0) {
// echo "Sorry, your file was not uploaded.";
// if everything is ok, try to upload file
} else {
if (move_uploaded_file($_FILES["upload_photograph"]["tmp_name"], $upload_photograph)) {
// echo "The file ". basename( $_FILES["ufile_source"]["name"]). " has been uploaded.";
} else {
$application_complete = 0;
}
}
}else{
$application_complete = 0;
}
if(isset($_FILES["upload_candidate_cnic"])){
$target_dir = "documents/";
$form = $_GET['form_no'];
$can = "CAND-NIC";
$upload_candidate_cnic = $target_dir . $can . $form . basename($_FILES["upload_candidate_cnic"]["name"]);
$uploadOk = 1;
if ($uploadOk == 0) {
// echo "Sorry, your file was not uploaded.";
// if everything is ok, try to upload file
} else {
if (move_uploaded_file($_FILES["upload_candidate_cnic"]["tmp_name"], $upload_candidate_cnic)) {
// echo "The file ". basename( $_FILES["ufile_source"]["name"]). " has been uploaded.";
} else {
$application_complete = 0;
}
}
}else{
$application_complete = 0;
}
if(isset($_FILES["upload_father_cnic"])){
$target_dir = "documents/";
$form = $_GET['form_no'];
$fath = "FATH-NIC";
$upload_father_cnic = $target_dir . $fath . $form . basename($_FILES["upload_father_cnic"]["name"]);
$uploadOk = 1;
if ($uploadOk == 0) {
// echo "Sorry, your file was not uploaded.";
// if everything is ok, try to upload file
} else {
if (move_uploaded_file($_FILES["upload_father_cnic"]["tmp_name"], $upload_father_cnic)) {
// echo "The file ". basename( $_FILES["ufile_source"]["name"]). " has been uploaded.";
} else {
$application_complete = 0;
}
}
}else{
$application_complete = 0;
}
if(isset($_FILES["upload_testimonial"])){
$target_dir = "documents/";
$form = $_GET['form_no'];
$other = "OTHER-DOC";
$upload_testimonial = $target_dir . $other . $form . basename($_FILES["upload_testimonial"]["name"]);
$uploadOk = 1;
if ($uploadOk == 0) {
// echo "Sorry, your file was not uploaded.";
// if everything is ok, try to upload file
} else {
if (move_uploaded_file($_FILES["upload_testimonial"]["tmp_name"], $upload_testimonial)) {
// echo "The file ". basename( $_FILES["ufile_source"]["name"]). " has been uploaded.";
} else {
// $application_complete = 1;
}
}
}else{
// $application_complete = 1;
}
if($upload_ssc_certificate == $target_dir . $ssc . $form && ($_POST["upload_ssc_certificate_oldfile"] != $target_dir . $ssc . $form) && ($_POST["upload_ssc_certificate_oldfile"] != "")){
$upload_ssc_certificate = $_POST["upload_ssc_certificate_oldfile"];
}
if($upload_candidate_cnic == $target_dir . $can . $form && ($_POST["upload_candidate_cnic_oldfile"] != $target_dir . $can . $form) && ($_POST["upload_candidate_cnic_oldfile"] != "")){
$upload_candidate_cnic = $_POST["upload_candidate_cnic_oldfile"];
}
if($upload_photograph == $target_dir . $pic . $form && ($_POST["upload_photograph_oldfile"] != $target_dir . $pic . $form) && ($_POST["upload_photograph_oldfile"] != "")){
$upload_photograph = $_POST["upload_photograph_oldfile"];
}
if($upload_father_cnic == $target_dir . $fath . $form && ($_POST["upload_father_cnic_oldfile"] != $target_dir . $fath . $form) && ($_POST["upload_father_cnic_oldfile"] != "")){
$upload_father_cnic = $_POST["upload_father_cnic_oldfile"];
}
if($upload_testimonial == $target_dir . $other . $form && ($_POST["upload_testimonial_oldfile"] != $target_dir . $other . $form) && ($_POST["upload_testimonial_oldfile"] != "")){
$upload_testimonial = $_POST["upload_testimonial_oldfile"];
}
if(($_FILES["upload_ssc_certificate"]["name"] != "" || ($_POST["upload_ssc_certificate_oldfile"] != $target_dir . $ssc . $form && $_POST["upload_ssc_certificate_oldfile"] != ""))
&& ($_FILES["upload_candidate_cnic"]["name"] != "" || ($_POST["upload_candidate_cnic_oldfile"] != $target_dir . $can . $form && $_POST["upload_candidate_cnic_oldfile"] != ""))
&& ($_FILES["upload_photograph"]["name"] != "" || ($_POST["upload_photograph_oldfile"] != $target_dir . $pic . $form && $_POST["upload_photograph_oldfile"] != "" ))
&& ($_FILES["upload_father_cnic"]["name"] != "" || ($_POST["upload_father_cnic_oldfile"] != $target_dir . $fath . $form && $_POST["upload_father_cnic_oldfile"] != "" )))
{
$application_complete = 1;
// print_r($_FILES["upload_photograph"]); die;
}
extract($_POST);
$domicile_opt = $domicile == 'otherQuery' ? $other_opt : $domicile;
$sql = "Delete from application_form where form_no = '".$form_no."'";
$db->ExecuteQuery($sql);
$sql = "INSERT into application_form(`trade1`,`trade2`,`trade3`,`batch_no`, `candidate_name`, `cnic_no`, `dob`, `phone_no`, `cell_no`, `emergency_no`, `email`, `nationality`, `gender`, `domicile`, `address`, `blood_group`, `father_name`, `father_cnic_no`, `occupation`, `business`, `father_cell_no`, `father_cell_no2`, `relationship`, `degree`,`subject`, `institute`, `year`, `marks`, `grade`, `ssc_certificate`, `photograph`, `candidate_cnic`, `father_cnic`, `other_data`, `form_no`, `application_completed`)
values('".$interested_trade1."','".$interested_trade2."','".$interested_trade3."','".$batch_no."','".$candidate_name."','".$cnic_no."','".$dob."','".$phone_no."','".$cell_no."','".$emergency_no."','".$email."','".$nationality."','".$gender."','".$domicile_opt."','".$address."','".$blood_group."','".$father_name."','".$father_cnic_no."','".$occupation."','".$business."','".$father_cell_no."','".$father_cell_no2."','".$father_relationship."','".implode(",",$degree)."','".implode(",",$subject)."','".implode(",",$institute)."','".implode(",",$year)."','".implode(",",$marks)."','".implode(",",$grade)."','".$upload_ssc_certificate."','".$upload_photograph."','".$upload_candidate_cnic."','".$upload_father_cnic."','".$upload_testimonial."','".$form_no."',".$application_complete.")";
// echo $sql;die;
$db->ExecuteQuery($sql);
$query = "INSERT into log(`name`,`activity`)
values('".$_SESSION['USER']."','Applicaton form submitted')";
$db->ExecuteQuery($query);
// die;
echo "<script>alert('Application Submitted Successfully');</script>";
reDirectUsingJavascript('query-log.php');
}
if(isset($_GET['form_no'])){
$sql = "SELECT `fullname`,`phone`, `query_type`, `query_for`, `interested_trade1`, `interested_trade2`, `interested_trade3`,`batch_no`, `hear_about_us`, `form_no`, `address`, `city`, `area`, `email`, `dob`, `qualification`, `ssc_per`, `shift_interested`, `campus`, `user_id` from query_log Where form_no = '".$_GET['form_no']."'" ;
$res = $db->ExecuteQuery($sql);
// print_r($res->FetchAsArray());die;
list($fullname,$phone,$query_type,$query_for,$interested_trade1,$interested_trade2,$interested_trade3,$batch_no,$hear_about_us,$form_no,$address,$city,$area,$email,$dob,$qualification,$ssc_per,$shift_interested,$campus,$user_id) = $res->FetchAsArray();
}
if(isset($_GET['form_no'])){
$sql = "SELECT `trade1`, `trade2`, `trade3`, `shift`, `batch_no`, `candidate_name`, `cnic_no`, `dob`, `phone_no`, `cell_no`, `emergency_no`, `email`, `nationality`, `gender`, `domicile`, `address`, `blood_group`, `father_name`, `father_cnic_no`, `occupation`, `business`, `father_cell_no`, `father_cell_no2`, `relationship`, `degree`, `subject`, `institute`, `year`, `marks`, `grade`, `ssc_certificate`, `photograph`, `candidate_cnic`, `father_cnic`, `other_data`, `application_completed` FROM application_form Where form_no = '".$_GET['form_no']."'" ;
$res = $db->ExecuteQuery($sql);
// print_r($res->FetchAsArray());die;
list($trade1,$trade2,$trade3,$shift,$batch_no1,$candidate_name,$cnic_no,$dob1,$phone_no,$cell_no,$emergency_no,$email1,$nationality,$gender,$domicile,$address1,$blood_group,$father_name,$father_cnic_no,$occupation,$business,$father_cell_no,$father_cell_no2,$father_relationship,$degree,$subject,$institute,$year,$marks,$grade,$upload_ssc_certificate,$upload_photograph,$upload_candidate_cnic,$upload_father_cnic,$upload_testimonial,$application_completed) = $res->FetchAsArray();
}
// echo $interested_trade1;
// die;
?>
<!DOCTYPE html>
<html lang="en">
<head>
<!-- head scripts -->
<?php include('includes/head-scripts.php')?>
<!-- Onchange hide/show [Domicile] -->
<!-- upload image with preview -->
<script>
function previewFile12() {
var preview = document.querySelector('#img12');
var file = document.querySelector('#previewFile').files[0];
var reader = new FileReader();
reader.onloadend = function () {
preview.src = reader.result;
}
if (file) {
reader.readAsDataURL(file);
} else {
preview.src = "";
}
}
function change() {
if (document.getElementById("other2").value == "otherQuery"){
document.getElementById("queryResult2").style.display= "block";
}
else if
( document.getElementById("other2").value != "otherQuery" ){
document.getElementById("queryResult2").style.display = "none";
}
}
</script>
<style>
#queryResult2{display: none;}
</style>
<!-- /Onchange hide/show [Domicile] -->
</head>
<script>
function duplicate() {
var original = document.getElementById('qualification');
var clone = original.cloneNode(true); // "deep" clone
// clone.id = ""; // there can only be one element with an ID
// clone.onclick = duplicate; // event handlers are not cloned
var InputType = clone.getElementsByTagName("input");
for (var i=0; i<InputType.length; i++){
if( InputType[i].type=='text'){
InputType[i].value = "";
}
}
original.parentNode.appendChild(clone);
}
</script>
<body>
<div id="sb-site">
<!-- chat sidebar -->
<?php include('includes/chat-drawer.php')?>
<!--<div id="loading">
<div class="svg-icon-loader">
<img src="https://agileui.com/demo/delight/assets/images/svg-loaders/bars.svg" width="40" alt=""></div>
</div>-->
<!-- page-wrapper -->
<div id="page-wrapper">
<div id="mobile-navigation"><button id="nav-toggle" class="collapsed" data-toggle="collapse" data-target="#page-sidebar"><span></span></button>
</div>
<!-- left Nav -->
<?php include('includes/sidebar.php'); ?>
<!-- Right Content Area -->
<div id="page-content-wrapper">
<div id="page-content">
<!-- Header -->
<?php include('includes/header.php'); ?>
<!-- application form --->
<div id="page-title">
<h2>Application Form</h2>
</div>
<form class="form-horizontal bordered-row" id="demo-form" data-parsley-validate="" method="post" enctype="multipart/form-data">
<input type="hidden" name="form_no" value="<?=$form_no?>">
<!-- sec a --->
<div class="panel">
<div class="panel-body">
<h3>(A) Select Preferred Trade</h3><br>
<div class="example-box-wrapper">
<div class="row">
<!-- lft -->
<div class="col-md-6">
<div class="form-group">
<label class="col-sm-3 control-label">Program 1 *</label>
<div class="col-sm-6">
<select name="interested_trade1" class="form-control" data-parsley-id="0429">
<option value="N/A" disabled selected>--select--</option>
<?php
if($role=='admin'){
$sql = "SELECT `value` FROM `add_setup` WHERE name='program'" ;
}else{
$sql = "SELECT DISTINCT program FROM `admission_setup` WHERE campus= '".$_SESSION["Role"]."'";
}
// $sql = "SELECT `value` FROM `add_setup` WHERE name='program'" ;
$res = $db->ExecuteQuery($sql);
while(list($available_prog) = $res->FetchAsArray())
{
?>
<option value="<?=$available_prog?>" <?php if($available_prog == $interested_trade1){ echo "selected"; } ?>><?=$available_prog?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Program 3 *</label>
<div class="col-sm-6">
<select name="interested_trade3" class="form-control" data-parsley-id="0429">
<option value="N/A" disabled selected>--select--</option>
<?php
// $sql = "SELECT `value` FROM `add_setup` WHERE name='program'" ;
if($role=='admin'){
$sql = "SELECT `value` FROM `add_setup` WHERE name='program'" ;
}else{
$sql = "SELECT DISTINCT program FROM `admission_setup` WHERE campus= '".$_SESSION["Role"]."'";
}
$res = $db->ExecuteQuery($sql);
while(list($available_prog) = $res->FetchAsArray())
{
?>
<option value="<?=$available_prog?>" <?php if($available_prog == $interested_trade3){ echo "selected"; } ?>><?=$available_prog?></option>
<?php } ?>
</select>
</div>
</div>
</div>
<!-- rgt -->
<div class="col-md-6">
<div class="form-group">
<label class="col-sm-3 control-label">Program 2 *</label>
<div class="col-sm-6">
<select name="interested_trade2" class="form-control" data-parsley-id="0429">
<option value="N/A" disabled selected>--select--</option>
<?php
if($role=='admin'){
$sql = "SELECT `value` FROM `add_setup` WHERE name='program'" ;
}else{
$sql = "SELECT DISTINCT program FROM `admission_setup` WHERE campus= '".$_SESSION["Role"]."'";
}
// $sql = "SELECT `value` FROM `add_setup` WHERE name='program'" ;
$res = $db->ExecuteQuery($sql);
while(list($available_prog) = $res->FetchAsArray())
{
?>
<option value="<?=$available_prog?>" <?php if($available_prog == $interested_trade2){ echo "selected"; } ?>><?=$available_prog?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Batch No *</label>
<div class="col-sm-6">
<select name="batch_no" class="form-control">
<option value="N/A" disabled selected>--select--</option>
<?php
if($role == 'admin'){
$sql = "SELECT `value` FROM add_setup WHERE name='batch'";
}else{
$sql = "SELECT DISTINCT batch FROM admission_setup WHERE campus = '".$_SESSION["Role"]."'";
}
$res = $db->ExecuteQuery($sql);
while(list($batch_no_val) = $res->FetchAsArray())
{
?>
<option value="<?=$batch_no_val?>" <?php if($batch_no_val == $batch_no){ echo "selected"; } ?>><?=$batch_no_val?></option>
<?php } ?>
</select>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- sec b --->
<div class="panel">
<div class="panel-body">
<h3>(B) Candidate Information</h3> <br>
<div class="example-box-wrapper">
<div class="row">
<!-- lft -->
<div class="col-md-6">
<div class="form-group">
<label class="col-sm-3 control-label">Candidate Name</label>
<div class="col-sm-6"><input type="text" name="candidate_name" required class="form-control" value="<?=$fullname?>" onkeyup="this.value = this.value.replace(/[^a-z, '', A-Z, '']/, '')"></div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Date of Birth</label>
<div class="col-sm-6">
<!-- Date -->
<div class="input-prepend input-group">
<span class="add-on input-group-addon">
<i class="glyph-icon icon-calendar"></i>
</span>
<input type="text" name="dob" value="<?=$dob?>" class="bootstrap-datepicker form-control"
data-date-format="mm/dd/yy">
</div>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Cell No *</label>
<div class="col-sm-6">
<div class=""><input type="tel" name="cell_no" pattern="^\d{4}-\d{7}$" placeholder="xxxx-xxxxxxx" value="<?=$cell_no?>" required class="form-control" <?=$cell_no?> /></div>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Email</label>
<div class="col-sm-6">
<input type="text" data-parsley-type="email" name="email" value="<?=$email?>" class="form-control" data-parsley-id="8336">
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Gender *</label>
<div class="col-sm-6">
<select name="gender" class="form-control" >
<option value="Male" <?php if($gender == "Male"){ echo "selected"; }?>>Male</option>
<option value="Female" <?php if($gender == "Female"){ echo "selected"; }?>>Female</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Address for Correspondence</label>
<div class="col-sm-6">
<div class="">
<input type="text" value="<?=$address?>" name="address" required class="form-control"></div>
</div>
</div>
</div>
<!-- rgt -->
<div class="col-md-6">
<?php //if($role != 'CVI') {?>
<div class="form-group">
<label class="col-sm-3 control-label">CNIC No *</label>
<div class="col-sm-6"><input type="tel" pattern="^\d{5}-\d{7}-\d{1}$" placeholder="xxxxx-xxxxxxx-x" name="cnic_no" value="<?=$cnic_no?>" required class="form-control"></div>
</div>
<?php //} ?>
<div class="form-group">
<label class="col-sm-3 control-label">Phone No</label>
<div class="col-sm-6">
<div class=""><input type="tel" required name="phone_no" pattern="^\d{4}-\d{7}$" placeholder="xxx-xxxxxxx" value="<?=$phone?>" required class="form-control"></div>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Cell No incase of Emergency</label>
<div class="col-sm-6">
<input type="text" name="emergency_no" pattern="^\d{4}-\d{7}$" placeholder="xxxx-xxxxxxx" class="form-control" value="<?=$emergency_no?>">
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Nationality </label>
<div class="col-sm-6">
<!--<input type="text" name="nationality" required class="form-control">-->
<select class="form-control md-input " id="nationality" name="nationality">
<!-- <option value="Male" <?php if($gender == "Male"){ echo "selected"; }?>>Male</option> -->
<!-- <option value="">Choose any one</option $nationality> -->
<option class="black" value="1">Afghan</option>
<option class="black" value="2">Albanian</option>
<option class="black" value="3">Algerian</option>
<option class="black" value="114">American</option>
<option class="black" value="187">Angolan</option>
<option class="black" value="4">Antigua</option>
<option class="black" value="5">Argentinian</option>
<option class="black" value="6">Australian</option>
<option class="black" value="115">Austrian</option>
<option class="black" value="7">Azerbaijani</option>
<option class="black" value="8">Bahraini</option>
<option class="black" value="9">Bangladeshi</option>
<option class="black" value="10">Barbadian</option>
<option class="black" value="188">Barbuda</option>
<option class="black" value="193">Belarusian</option>
<option class="black" value="11">Belgian</option>
<option class="black" value="113">Belizian</option>
<option class="black" value="215">Bosnian</option>
<option class="black" value="13">Botswanan</option>
<option class="black" value="14">Brazilian</option>
<option class="black" value="108">British</option>
<option class="black" value="15">Bruneian</option>
<option class="black" value="16">Bulgarian</option>
<option class="black" value="17">Burmese</option>
<option class="black" value="222">Cambodian</option>
<option class="black" value="18">Cameroonian</option>
<option class="black" value="116">Canadian</option>
<option class="black" value="19">Chadian</option>
<option class="black" value="20">Chechnya</option>
<option class="black" value="21">Chilean</option>
<option class="black" value="22">Chinese</option>
<option class="black" value="24">Colombian</option>
<option class="black" value="25">Congolese</option>
<option class="black" value="196">Costa Rican</option>
<option class="black" value="26">Croat or Croatian</option>
<option class="black" value="198">Cuban</option>
<option class="black" value="27">Cypriot</option>
<option class="black" value="217">Czech</option>
<option class="black" value="29">Danish</option>
<option class="black" value="194">Democratic Republic of the Congo</option>
<option class="black" value="192">Djiboutian</option>
<option class="black" value="201">Dominican</option>
<option class="black" value="72">Duch</option>
<option class="black" value="30">Egyptian</option>
<option class="black" value="23">Emirati</option>
<option class="black" value="31">Eritrean</option>
<option class="black" value="151">Estonian</option>
<option class="black" value="32">Ethiopian</option>
<option class="black" value="33">Fijian</option>
<option class="black" value="81">Filipino</option>
<option class="black" value="34">Finnish</option>
<option class="black" value="35">French</option>
<option class="black" value="36">Gambian</option>
<option class="black" value="142">Georgian</option>
<option class="black" value="37">German</option>
<option class="black" value="38">Ghanaian</option>
<option class="black" value="228">Gibraltarian</option>
<option class="black" value="39">Greek</option>
<option class="black" value="40">Guinean</option>
<option class="black" value="146">Haitian</option>
<option class="black" value="41">Hong Kong</option>
<option class="black" value="42">Hungarian</option>
<option class="black" value="43">Icelandic</option>
<option class="black" value="44">Indian</option>
<option class="black" value="45">Indonesian</option>
<option class="black" value="46">Iranian</option>
<option class="black" value="47">Iraqi</option>
<option class="black" value="48">Irish</option>
<option class="black" value="50">Italian</option>
<option class="black" value="51">Jamaican</option>
<option class="black" value="52">Japanese</option>
<option class="black" value="53">Jordanian</option>
<option class="black" value="54">Kazakh</option>
<option class="black" value="55">Kenyan</option>
<option class="black" value="56">Kosovo</option>
<option class="black" value="57">Kuwaiti</option>
<option class="black" value="58">Kyrgyzstan</option>
<option class="black" value="117">Lao Peoples Democratic Republic</option>
<option class="black" value="128">Latvian</option>
<option class="black" value="59">Lebanese</option>
<option class="black" value="118">Liberian</option>
<option class="black" value="60">Libyan</option>
<option class="black" value="61">Madagascan</option>
<option class="black" value="62">Malawian</option>
<option class="black" value="63">Malaysian</option>
<option class="black" value="122">Maldivian</option>
<option class="black" value="64">Malian</option>
<option class="black" value="65">Maltese</option>
<option class="black" value="66">Mauritanian</option>
<option class="black" value="67">Mauritian</option>
<option class="black" value="68">Mexican</option>
<option class="black" value="69">Moroccan</option>
<option class="black" value="70">Mozambican</option>
<option class="black" value="71">Nepalese</option>
<option class="black" value="73">New Zealand</option>
<option class="black" value="74">Niger</option>
<option class="black" value="75">Nigerian</option>
<option class="black" value="76">Norwegian</option>
<option class="black" value="77">Omani</option>
<option class="black" value="79" selected="">Pakistani</option>
<option class="black" value="78">Palestinian</option>
<option class="black" value="173">Papua New Guinean</option>
<option class="black" value="80">Peruvian</option>
<option class="black" value="82">Polish</option>
<option class="black" value="83">Portuguese</option>
<option class="black" value="230">Puerto Rican</option>
<option class="black" value="84">Qatari</option>
<option class="black" value="158">Romanian</option>
<option class="black" value="85">Russian</option>
<option class="black" value="121">Rwandan</option>
<option class="black" value="86">Saudi</option>
<option class="black" value="234">Savlbardian</option>
<option class="black" value="87">Senegalese</option>
<option class="black" value="224">Serbian</option>
<option class="black" value="88">Sierra Leonian</option>
<option class="black" value="89">Singaporean</option>
<option class="black" value="165">Slovak</option>
<option class="black" value="90">Slovenian</option>
<option class="black" value="91">Somali</option>
<option class="black" value="92">South African</option>
<option class="black" value="232">South Georgian</option>
<option class="black" value="219">South Korean</option>
<option class="black" value="220">South Sudanese</option>
<option class="black" value="94">Spanish</option>
<option class="black" value="95">Sri Lankan</option>
<option class="black" value="96">Sudanese</option>
<option class="black" value="97">Swedish</option>
<option class="black" value="98">Swiss</option>
<option class="black" value="99">Syrian</option>
<option class="black" value="101">Taiwanese</option>
<option class="black" value="100">Tajik or Tadjik</option>
<option class="black" value="102">Tanzanian</option>
<option class="black" value="103">Thai</option>
<option class="black" value="177">Timorese</option>
<option class="black" value="104">Tunisian</option>
<option class="black" value="105">Turkish</option>
<option class="black" value="106">Turkoman</option>
<option class="black" value="107">Ugandan</option>
<option class="black" value="119">Ukrainian</option>
<option class="black" value="109">Uzbek</option>
<option class="black" value="110">Venezuelan</option>
<option class="black" value="180">Vietnamese</option>
<option class="black" value="111">Yemeni</option>
<option class="black" value="112">Zimbabwean</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Domicile *</label>
<div class="col-sm-6">
<!--<input type="text" name="domicile" required class="form-control">-->
<select name="domicile" class="form-control" id="other2" onChange="change()">
<option value="N/A" disabled selected>--select--</option>
<option value="ABBOTTABAD" <?php if($domicile == "ABBOTTABAD"){ echo "selected"; } ?>>ABBOTTABAD</option>
<option value="BADIN" <?php if($domicile == "BADIN"){ echo "selected"; } ?>>BADIN</option>
<option value="D I KHAN" <?php if($domicile == "D I KHAN"){ echo "selected"; } ?>>D I KHAN</option>
<option value="DADU" <?php if($domicile == "DADU"){ echo "selected"; } ?>>DADU</option>
<option value="FAISALABAD" <?php if($domicile == "FAISALABAD"){ echo "selected"; } ?>>FAISALABAD</option>
<option value="GWADAR" <?php if($domicile == "GWADAR"){ echo "selected"; } ?>>GWADAR</option>
<option value="GHOTKI (AT MIRPUR MATHELO)" <?php if($domicile == "GHOTKI (AT MIRPUR MATHELO)"){ echo "selected"; } ?>>GHOTKI (AT MIRPUR MATHELO)</option>
<option value="HYDERABAD" <?php if($domicile == "HYDERABAD"){ echo "selected"; } ?>>HYDERABAD</option>
<option value="JACOBABAD" <?php if($domicile == "JACOBABAD"){ echo "selected"; } ?>>JACOBABAD</option>
<option value="JAMSHORO" <?php if($domicile == "JAMSHORO"){ echo "selected"; } ?>>JAMSHORO</option>
<option value="KARACHI" <?php if($domicile == "KARACHI"){ echo "selected"; } ?>>KARACHI</option>
<option value="KAMBAR SHAHDADKOT" <?php if($domicile == "KAMBAR SHAHDADKOT"){ echo "selected"; } ?>>KAMBAR SHAHDADKOT</option>
<option value="KARACHI CENTRAL" <?php if($domicile == "KARACHI CENTRAL"){ echo "selected"; } ?>>KARACHI CENTRAL</option>
<option value="KARACHI EAST" <?php if($domicile == "KARACHI EAST"){ echo "selected"; } ?>>KARACHI EAST</option>
<option value="KARACHI SOUTH" <?php if($domicile == "KARACHI SOUTH"){ echo "selected"; } ?>>KARACHI SOUTH</option>
<option value="KARACHI WEST" <?php if($domicile == "KARACHI WEST"){ echo "selected"; } ?>>KARACHI WEST</option>
<option value="KASHMORE" <?php if($domicile == "KASHMORE"){ echo "selected"; } ?>>KASHMORE</option>
<option value="KHAIRPUR" <?php if($domicile == "KHAIRPUR"){ echo "selected"; } ?>>KHAIRPUR</option>
<option value="KORANGI" <?php if($domicile == "KORANGI"){ echo "selected"; } ?>>KORANGI</option>
<option value="LAHORE" <?php if($domicile == "LAHORE"){ echo "selected"; } ?>>LAHORE</option>
<option value="LARKANA" <?php if($domicile == "LARKANA"){ echo "selected"; } ?>>LARKANA</option>
<option value="MALIR" <?php if($domicile == "MALIR"){ echo "selected"; } ?>>MALIR</option>
<option value="MATIARI" <?php if($domicile == "MATIARI"){ echo "selected"; } ?>>MATIARI</option>
<option value="MULTAN" <?php if($domicile == "MULTAN"){ echo "selected"; } ?>>MULTAN</option>
<option value="MIRPUR KHAS" <?php if($domicile == "MIRPUR KHAS"){ echo "selected"; } ?>>MIRPUR KHAS</option>
<option value="NAUSHAHRO FEROZE" <?php if($domicile == "NAUSHAHRO FEROZE"){ echo "selected"; } ?>>NAUSHAHRO FEROZE</option>
<option value="NAWAB SHAH" <?php if($domicile == "NAWAB SHAH"){ echo "selected"; } ?>>NAWAB SHAH</option>
<option value="PESHAWAR" <?php if($domicile == "PESHAWAR"){ echo "selected"; } ?>>PESHAWAR</option>
<option value="QUETTA" <?php if($domicile == "QUETTA"){ echo "selected"; } ?>>QUETTA</option>
<option value="RAWALPINDI" <?php if($domicile == "RAWALPINDI"){ echo "selected"; } ?>>RAWALPINDI</option>
<option value="SANGHAR" <?php if($domicile == "SANGHAR"){ echo "selected"; } ?>>SANGHAR</option>
<option value="SHAHEED BENAZIRABAD" <?php if($domicile == "SHAHEED BENAZIRABAD"){ echo "selected"; } ?>>SHAHEED BENAZIRABAD</option>
<option value="SHIKARPUR" <?php if($domicile == "SHIKARPUR"){ echo "selected"; } ?>>SHIKARPUR</option>
<option value="SUJAWAL" <?php if($domicile == "SUJAWAL"){ echo "selected"; } ?>>SUJAWAL</option>
<option value="SIALKOT" <?php if($domicile == "SIALKOT"){ echo "selected"; } ?>>SIALKOT</option>
<option value="SUKKUR" <?php if($domicile == "SUKKUR"){ echo "selected"; } ?>>SUKKUR</option>
<option value="SAWAT" <?php if($domicile == "SAWAT"){ echo "selected"; } ?>>SAWAT</option>
<option value="SAWAT" <?php if($domicile == "GUJRAT"){ echo "selected"; } ?>>GUJRAT</option>
<option value="TANDO ALLAHYAR" <?php if($domicile == "TANDO ALLAHYAR"){ echo "selected"; } ?>>TANDO ALLAHYAR</option>
<option value="TANDO MUHAMMAD KHAN" <?php if($domicile == "TANDO MUHAMMAD KHAN"){ echo "selected"; } ?>>TANDO MUHAMMAD KHAN</option>
<option value="THARPARKAR" <?php if($domicile == "THARPARKAR"){ echo "selected"; } ?>>STHARPARKAR</option>
<option value="THATTA" <?php if($domicile == "THATTA"){ echo "selected"; } ?>>THATTA</option>
<option value="UMERKOT" <?php if($domicile == "UMERKOT"){ echo "selected"; } ?>>UMERKOT</option>
<option value="otherQuery" <?php if($domicile == "otherQuery"){ echo "selected"; } ?>>OTHER</option>
</select>
<br>
<div class="form-group" id="queryResult2" >
<input type="text" name="other_opt" class="form-control">
</div>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Blood Group</label>
<div class="col-sm-6"><input type="text" name="blood_group" class="form-control" value="<?=$blood_group?>"></div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- sec c --->
<div class="panel">
<div class="panel-body">
<h3>(C) Father/Guardian Information</h3> <br>
<div class="example-box-wrapper">
<div class="row">
<!-- lft -->
<div class="col-md-6">
<div class="form-group">
<label class="col-sm-3 control-label">Father/Guardian Name *</label>
<div class="col-sm-6"><input type="text" name="father_name" required class="form-control" value="<?=$father_name?>" onkeyup="this.value = this.value.replace(/[^a-z, '', A-Z, '']/, '')"></div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Occupation of Father/Guardian *</label>
<div class="col-sm-6">
<div class=""><input type="text" name="occupation" required class="form-control" value="<?=$occupation?>"></div>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Cell No Father / Guardian * </label>
<div class="col-sm-6">
<div class=""><input type="text" name="father_cell_no" pattern="^\d{4}-\d{7}$" value="<?=$father_cell_no?>" required class="form-control" placeholder="xxxx-xxxxxxxx"></div>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Guardian's Relationship with Applicant</label>
<div class="col-sm-6">
<div class="">
<input type="text" name="father_relationship" value="<?=$father_relationship?>" class="form-control" onkeyup="this.value = this.value.replace(/[^a-z, '', A-Z, '']/, '')">
<!-- <select name="father_relationship" class="form-control" data-parsley-id="9735">
<option value="Son" <?php if($father_relationship == "Son"){ echo "selected"; } ?>>Son</option>
<option value="Daughter" <?php if($father_relationship == "Daughter"){ echo "selected"; } ?>>Daughter</option>
<option value="Relative" <?php if($father_relationship == "Relative"){ echo "selected"; } ?>>Relative </option>
<option value="Other" <?php if($father_relationship == "Other"){ echo "selected"; } ?>>Other</option>
</select> -->
<!--<input type="text" name="father_relationship" required class="form-control">-->
</div>
</div>
</div>
</div>
<!-- rgt -->
<div class="col-md-6">
<?php // if($role != 'CVI'){ ?>
<div class="form-group">
<label class="col-sm-3 control-label">CNIC No *</label>
<div class="col-sm-6"><input type="tel" placeholder="xxxxx-xxxxxxx-x" value="<?=$father_cnic_no?>" pattern="^\d{5}-\d{7}-\d{1}$" name="father_cnic_no" required class="form-control"></div>
</div>
<?php //} ?>
<div class="form-group">
<label class="col-sm-3 control-label">Organization / Business</label>
<div class="col-sm-6">
<div class=""><input type="text" name="business" class="form-control" value="<?=$business?>"></div>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Cell No (Alternate) Optional</label>
<div class="col-sm-6">
<input type="text" name="father_cell_no2" class="form-control" pattern="^\d{4}-\d{7}$" placeholder="xxxx-xxxxxxx" value="<?=$father_cell_no2?>">
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- sec D --->
<div class="panel">
<div class="panel-body">
<h3>(D) Educational Qualification *</h3> <br>
<div class="example-box-wrapper">
<div class="row" style="overflow-x:auto;">
<table id="datatable-responsive" class="table table-striped table-bordered responsive no-wrap dataTable dtr-inline" cellspacing="0" width="100%" role="grid" aria-describedby="datatable-responsive_info" style="width: 100%;">
<thead>
<tr role="row" class="thead-color">
<th class="" tabindex="0" aria-controls="datatable-responsive" rowspan="1" colspan="1" style="width: 149px;">Degree/ Certificate </th>
<th class="" tabindex="0" aria-controls="datatable-responsive" rowspan="1" colspan="1" style="width: 79px;">Subject</th>
<th class="" tabindex="0" aria-controls="datatable-responsive" rowspan="1" colspan="1" style="width: 79px;">Institute</th>
<th class="" tabindex="0" aria-controls="datatable-responsive" rowspan="1" colspan="1" style="width: 108px;">Passing Year</th>
<th class="" tabindex="0" aria-controls="datatable-responsive" rowspan="1" colspan="1" style="width: 54px;">% Marks</th>
<th tabindex="0" aria-controls="datatable-responsive" rowspan="1" colspan="1" style="width: 175px;" aria-sort="descending">Grade</th>
</tr>
</thead>
<tbody>
<div>
<tr role="row" class="odd" id="qualification">
<td class=""><select name="degree[]" style="overflow: auto;" >
<?php
$deg = explode(",",$degree);
?>
<option value="N/A" disabled selected>--select--</option>
<option value="8th(Middle)" <?php if(in_array("8th(Middle)" == $deg)){ echo "selected"; }?>>8th(Middle)</option>
<option value="1-7(lower)" <?php if(in_array("1-7(lower)" == $deg)){ echo "selected"; }?>>1-7(lower)</option>
<option value="Illiterate" <?php if(in_array("IlliterateL" == $deg)){ echo "selected"; }?>>Illiterate</option>
<option value="MATRIC/ O-LEVEL" <?php if(in_array('MATRIC/ O-LEVEL',$deg)){ echo "selected"; } ?>>Matric/ O-level</option>
<option value="INTERMEDIATE / A-LEVEL" <?php if(in_array("INTERMEDIATE / A-LEVEL",$deg)){ echo "selected"; } ?>>Intermediate / A-level</option>
<option value="BACHELOR" <?php if(in_array('BACHELOR',$deg)){ echo "selected"; } ?>>Bachelor</option>
<option value="MASTER (MA / MSc)" <?php if(in_array('MASTER (MA / MSc)',$deg)){ echo "selected"; } ?>>Master (ma / Msc)</option>
<option value="MS / M.PHIL (18 years)" <?php if(in_array('MS / M.PHIL (18 years)',$deg)){ echo "selected"; } ?>>Ms / M.phil (18 Years)</option>
<option value="CERTIFICATE" <?php if(in_array('CERTIFICATE',$deg)){ echo "selected"; }?>>Certificate</option>
</select></td>
<?php
$sub = explode(",",$subject);
$ins = explode(",",$institute);
$years = explode(",",$year);
$mark = explode(",",$marks);
$grades = explode(",",$grade);
?>
<td class=""><input type="text" name="subject[]" value="<?=$subject?>" <?php if(in_array($subject,$sub)){ echo "selected"; } ?>/></td>
<td class=""><input type="text" name="institute[]" value="<?=$institute?>" <?php if(in_array($institute,$ins)){ echo "selected"; } ?>/></td>
<td class=""><input type="text" name="year[]" value="<?=$year?>" <?php if(in_array($year,$years)){ echo "selected"; } ?>/></td>
<td class=""><input type="text" name="marks[]" value="<?=$marks?>" <?php if(in_array($marks,$mark)){ echo "selected"; } ?>/></td>
<td class=""><input type="text" name="grade[]" value="<?=$grade?>" <?php if(in_array($grade,$grades)){ echo "selected"; } ?>/></td>
</tr>
</div>
<button onClick="duplicate();return false;">ADD</button>
</tbody>
</table>
</div>
</div>
</div>
</div>
<!-- <style>
/* a {
color: hotpink;
} */
</style> -->
<!-- sec E --->
<div class="panel">
<div class="panel-body">
<h3>(E) Upload Documents</h3> <br>
<div class="example-box-wrapper">
<div class="row">
<!-- lft -->
<div class="col-md-6">
<div class="form-group">
<label class="col-sm-5 control-label">SSC / Equivalent Certificate or Marksheet *</label>
<div class="col-sm-7">
<input type="file" name="upload_ssc_certificate" class="form-control" value="<?=$upload_ssc_certificate?>">
<?php
if(($upload_ssc_certificate == "documents/"."SSC-CERTIFICATE".$form_no) || ($upload_ssc_certificate == "documents/".$form_no)){
echo '<h4>No file upload</h4>';
}
else{
?>
<img src="<?php echo $upload_ssc_certificate ?>" style="height:75px;width:75px;">
<?php } ?>
<input type="hidden" value="<?=$upload_ssc_certificate?>" name="upload_ssc_certificate_oldfile">
<?php if(($db->GetSingleRecord("select ssc_certificate from application_form where form_no = ".$form_no) != "documents/"."SSC-CERTIFICATE".$form_no) && ($db->GetSingleRecord("select ssc_certificate from application_form where form_no = ".$form_no) != "documents/".$form_no) && ($db->GetSingleRecord("select ssc_certificate from application_form where form_no = ".$form_no) != "")){ ?>
<a href="<?=$upload_ssc_certificate?>" target="_blank" style="color:green">Download file</a>
<?php } ?>
</div>
</div>
<br><br>
<div class="form-group">
<label class="col-sm-5 control-label">CNIC / Form-B of Candidate *</label>
<div class="col-sm-7">
<input type="file" name="upload_candidate_cnic" class="form-control" value="<?=$upload_candidate_cnic?>">
<?php
if(($upload_candidate_cnic == "documents/"."CAND-NIC".$form_no) || ($upload_candidate_cnic == "documents/".$form_no)){
echo '<h4>No file upload</h4>';
}
else{
?>
<img src="<?php echo $upload_candidate_cnic ?>" style="height:75px;width:75px;">
<?php } ?>
<input type="hidden" value="<?=$upload_candidate_cnic?>" name="upload_candidate_cnic_oldfile">
<?php if(($db->GetSingleRecord("select candidate_cnic from application_form where form_no = ".$form_no) != "documents/"."CAND-NIC".$form_no) && ($db->GetSingleRecord("select candidate_cnic from application_form where form_no = ".$form_no) != "documents/".$form_no) && ($db->GetSingleRecord("select candidate_cnic from application_form where form_no = ".$form_no) != "")){ ?>
<a href="<?=$upload_candidate_cnic?>" target="_blank" style="color:green">Download file</a>
<?php } ?>
</div>
</div><br><br>
<div class="form-group">
<label class="col-sm-5 control-label">Any Other Testimonial</label>
<div class="col-sm-7">
<input type="file" name="upload_testimonial" class="form-control" value="<?=$upload_testimonial?>" >
<?php
if(($upload_testimonial == "documents/"."OTHER-DOC".$form_no) || ($upload_testimonial == "documents/".$form_no)){
echo '<h4>No file upload</h4>';
}
else{
?>
<img src="<?php echo $upload_testimonial ?>" style="height:75px;width:75px;">
<?php } ?>
<input type="hidden" value="<?=$upload_testimonial?>" name="upload_testimonial_oldfile">
<?php
if(($db->GetSingleRecord("select other_data from application_form where form_no = ".$form_no) != "documents/"."OTHER-DOC".$form_no) && ($db->GetSingleRecord("select other_data from application_form where form_no = ".$form_no) != "documents/".$form_no) && ($db->GetSingleRecord("select other_data from application_form where form_no = ".$form_no) != "")){ ?>
<a href="<?=$upload_testimonial?>" target="_blank" style="color:green">Download file</a>
<?php } ?>
</div>
</div>
</div>
<!-- rgt -->
<div class="col-md-6">
<div class="form-group">
<label class="col-sm-5 control-label">Passport Size Photograph *</label>
<div class="col-sm-7">
<input type="file" id="previewFile" onchange="previewFile12()" name="upload_photograph" class="form-control">
<input type="hidden" value="<?=$upload_photograph?>" name="upload_photograph_oldfile">
<?php
if(($upload_photograph == "documents/"."PHOTO".$form_no) || ($upload_photograph == "documents/".$form_no)){
echo '<h4>No file upload</h4>';
}
else{
?>
<img src="<?php echo $upload_photograph ?>" style="height:75px;width:75px;">
<?php } ?>
<img src="images/<?=$upload_photograph?>" id="img12" height="200" alt="">
<?php if(($db->GetSingleRecord("select photograph from application_form where form_no = ".$form_no) != "documents/"."PHOTO".$form_no) && ($db->GetSingleRecord("select photograph from application_form where form_no = ".$form_no) != "documents/".$form_no) && ($db->GetSingleRecord("select photograph from application_form where form_no = ".$form_no) != "")){ ?>
<a href="<?=$upload_photograph?>" target="_blank" style="color:green">Download file</a>
<?php } ?>
</div>
</div><br><br>
<div class="form-group">
<label class="col-sm-5 control-label">CNIC / Form-B of Father *</label>
<div class="col-sm-7">
<input type="file" name="upload_father_cnic" class="form-control" value="<?=$upload_father_cnic?>">
<?php
if(($upload_father_cnic == "documents/"."FATH-NIC".$form_no) || ($upload_father_cnic == "documents/".$form_no)){
echo '<h4>No file upload</h4>';
}
else{
?>
<img src="<?php echo $upload_father_cnic ?>" style="height:75px;width:75px;">
<?php } ?>
<!-- <img src="<?php echo $upload_father_cnic ?>" style="height:75px;width:75px;"> -->
<input type="hidden" value="<?=$upload_father_cnic?>" name="upload_father_cnic_oldfile">
<?php if(($db->GetSingleRecord("select father_cnic from application_form where form_no = ".$form_no) != "documents/"."FATH-NIC".$form_no) && ($db->GetSingleRecord("select father_cnic from application_form where form_no = ".$form_no) != "documents/".$form_no) && ($db->GetSingleRecord("select father_cnic from application_form where form_no = ".$form_no) != "")){ ?>
<a href="<?=$upload_father_cnic?>" target="_blank" style="color:green">Download file</a>
<?php } ?>
</div>
</div><br>
</div>
</div>
</div>
</div>
</div>
<?php //if(!isset($_POST['action'])){ ?>
<?php
// if($role == 'Admin')
// {
?> <!-- btn --->
<?php
// if(($db->GetSingleRecord("Select COUNT(*) from enrollment_report where form_no = '".$form_no."'") == 0) || ($role == 'PATTI')){
// print_r("Select COUNT(*) from enrollment_report where form_no = '".$form_no."'");
// exit;
// $a=$db->GetSingleRecord("Select COUNT(*) from enrollment_report where form_no = '".$form_no."'");
// print_r($batch_no1);
// exit;
//for particular batch || $batch_no1 == 'BATCH-03(2018B)'
// echo "Select COUNT(*) from enrollment_report where form_no = '".$form_no."'";
// if($db->GetSingleRecord("Select COUNT(*) from enrollment_report where form_no = '".$form_no."'") == 0 || $role == 'admin' ){
if(true){
?>
<div class="panel">
<div class="panel-body">
<div class="example-box-wrapper">
<div class="bg-default content-box text-center pad20A mrg25T">
<button id="submit" class="btn btn-lg btn-primary">Submit</button>
</div>
</div>
</div>
</div>
<?php } ?>
</form>
</div>
</div>
<!-- Right Content Area -->
</div>
<!-- page-wrapper -->
<!-- foot Scripts -->
<?php include('includes/foot-scripts.php')?>
</div>
</body>
</html>