session_start();
if(!$_SESSION['Unit']){
if(!$_SESSION['pension_unit']){
header("Location:../../index.php");
}
}
include '../../conn.php';
function findrank1($rankid){
if($rankid == '') return $rankid;
$results=mysql_query("select rank_eng from rank_master where rank_id=$rankid") or die(mysql_error());
if($x = mysql_fetch_array($results)) return $x['rank_eng'];
}
if(isset($_REQUEST["B1"]))
{
if($_REQUEST['ndate']!=''){
$temp = explode('/',$_REQUEST['ndate']);
$ndate = $temp[2].'-'. $temp[1].'-'. $temp[0];
}else
$ndate=gmdate("Y-m-d",time()+19800);
if($_REQUEST['dob']!=''){
$temp = explode('/',$_REQUEST['dob']);
$dob = $temp[2].'-'. $temp[1].'-'. $temp[0];
}else
$dob='0000-00-00';
$soid = $_REQUEST['soid'];
$dob = $dob;
$name_of_nominess = $_REQUEST['nname'];
$rel = $_REQUEST['relation'];
$nomination_date = $ndate;
$present_address = $_REQUEST['paddress'];
$permanant_address = $_REQUEST['prmaddr'];
$identification_mark = $_REQUEST['idmark'];
$nominee_type = $_REQUEST['ntype'];
$share = $_REQUEST['ans_shear'];
if($rel==1){
$hindi='firk';
$eng='Father';
}else if($rel==2){
$hindi='ekrk';
$eng='Mother';
}else if($rel==3){
$hindi='iq=h';
$eng='Daughter';
}else if($rel==4){
$hindi='iq=';
$eng='Son';
}else if($rel==5){
$hindi='ifr';
$eng='Husband';
}else if($rel==6){
$hindi='iRuh';
$eng='Wife';
}else {
$hindi='vU;';
// $eng='Other';
$eng=($_REQUEST['other']==''?'Other':$_REQUEST['other']);
}
$relation=$hindi;
$query1=mysql_query("select nomi_photo from nominees_detail where serial_number = '$soid' ");
$xx = mysql_fetch_array($query1);
if($xx['nomi_photo']!='' && empty($_FILES["file"]["name"])){
$share= $_REQUEST['share'];
//echo "update nominees_detail set name_of_nominess='".addslashes($name_of_nominess)."', relation='$relation', nomination_date='$nomination_date', present_address='$present_address', permanant_address='$permanant_address', nominee_type='$nominee_type', identification_mark='".addslashes($identification_mark)."', dob = '$dob', ans_shear='".($_REQUEST['share']==''?100: $share)."', nominee_name_eng='".$_REQUEST['name_eng']."', relation_eng='".$eng."', age='".$_POST['age']."' where serial_number = '$soid'";
mysql_query("update nominees_detail set name_of_nominess='".addslashes($name_of_nominess)."', relation='$relation', nomination_date='$nomination_date', present_address='$present_address', permanant_address='$permanant_address', nominee_type='$nominee_type', identification_mark='".addslashes($identification_mark)."', dob = '$dob', ans_shear='".($_REQUEST['share']==''?100: $share)."', nominee_name_eng='".$_REQUEST['name_eng']."', relation_eng='".$eng."', age='".$_POST['age']."' where serial_number = '$soid'") or die(mysql_error());
header("Location: confirm_so_edit.php?id=".trim($_REQUEST['personalno']));
}else{
if(!empty($_FILES["file"]["name"]))
{
$allowedExts = array("gif", "jpeg", "jpg", "png");
$temp = explode(".", $_FILES["file"]["name"]);
$msg1="";
$msg="";
$extension = end($temp);
if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/jpg")
|| ($_FILES["file"]["type"] == "image/pjpeg")
|| ($_FILES["file"]["type"] == "image/x-png")
|| ($_FILES["file"]["type"] == "image/png"))
&& ($_FILES["file"]["size"] < 700000000)
&& in_array($extension, $allowedExts))
{
$img_name1="nominee_image/".time().$_FILES["file"]["name"];
$img_name="../../nominee/".$img_name1;
if(move_uploaded_file($_FILES["file"]["tmp_name"], $img_name))
{
echo "update nominees_detail set name_of_nominess='".addslashes($name_of_nominess)."', relation='$relation', nomination_date='$nomination_date', present_address='$present_address', permanant_address='$permanant_address', nominee_type='$nominee_type', identification_mark='".addslashes($identification_mark)."', dob = '$dob', ans_shear=".($_REQUEST['share']==''?100:$_REQUEST['share']).", nominee_name_eng='".$_REQUEST['name_eng']."', relation_eng='".$eng."', age='".$_POST['age']."',nomi_photo='".$img_name1."' where serial_number = '$soid'";
//mysql_query("update nominees_detail set name_of_nominess='sdfdsf', relation='ekrk', nomination_date='2014-04-16', present_address='dsdsds ', permanant_address='dsdsdsds ', nominee_type='f}rh;', identification_mark='sdsad', dob = '2014-04-16', ans_shear=23,nominee_name_eng='dfdsfsdf',relation_eng='Mother',age='1' where serial_number = '104613'") or die(mysql_error());
mysql_query("update nominees_detail set name_of_nominess='".addslashes($name_of_nominess)."', relation='$relation', nomination_date='$nomination_date', present_address='$present_address', permanant_address='$permanant_address', nominee_type='$nominee_type', identification_mark='".addslashes($identification_mark)."', dob = '$dob', ans_shear=".($_REQUEST['share']==''?100:$_REQUEST['share']).", nominee_name_eng='".$_REQUEST['name_eng']."', relation_eng='".$eng."', age='".$_POST['age']."',nomi_photo='".$img_name1."' where serial_number = '$soid'") or die(mysql_error());
header("Location: confirm_so_edit.php?id=".trim($_REQUEST['personalno']));
}
}
else
{
echo "Please Upload less than 50KB Image";
}
}
else
{
echo "update nominees_detail set name_of_nominess='".addslashes($name_of_nominess)."', relation='$relation', nomination_date='$nomination_date', present_address='$present_address', permanant_address='$permanant_address', nominee_type='$nominee_type', identification_mark='".addslashes($identification_mark)."', dob = '$dob', ans_shear=".($_REQUEST['share']==''?100:$_REQUEST['share']).", nominee_name_eng='".$_REQUEST['name_eng']."', relation_eng='".$eng."', age='".$_POST['age']."', nomi_photo='".$img_name1."' where serial_number = '$soid'";
mysql_query("update nominees_detail set name_of_nominess='".addslashes($name_of_nominess)."', relation='$relation', nomination_date='$nomination_date', present_address='$present_address', permanant_address='$permanant_address', nominee_type='$nominee_type', identification_mark='".addslashes($identification_mark)."', dob = '$dob', ans_shear=".($_REQUEST['share']==''?100:$_REQUEST['share']).", nominee_name_eng='".$_REQUEST['name_eng']."', relation_eng='".$eng."', age='".$_POST['age']."', nomi_photo='".$img_name1."' where serial_number = '$soid'") or die(mysql_error());
header("Location: confirm_so_edit.php?id=".trim($_REQUEST['personalno']));
}
}
}
function findrank($id = null)
{
$results=mysql_query("select * from rank_master where rank_id=".$id) or die(mysql_error());
if($x = mysql_fetch_array($results))
{
return $x['rank_eng'];
} else {
return 'N/A';
}
}
$results=mysql_query("select * from employee_master where personal_number='".$_REQUEST['id']."' ") or die(mysql_error());
$arow=mysql_fetch_assoc($results);
?>
UP POLICE: PENSION SYSTEM