session_start();
if(!$_SESSION['Unit']){
if(!$_SESSION['pension_unit']){
header("Location:../../index.php");
}
}
include '../../conn.php';
include "../functions.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['dob']!=''){
$temp = explode('/',$_REQUEST['dob']);
$dob = $temp[2].'-'. $temp[1].'-'. $temp[0];
}else
$dob='0000-00-00';
$rs = mysql_query('select * from employee_master where personal_number = '.$_REQUEST['personalno']);
if(mysql_num_rows($rs) > 0)
{
$data = mysql_fetch_assoc($rs);
$employee_name = $data['first_name_of_employee_english'].' '.$data['middle_name_of_employee_english'].' '.$data['last_name_of_employee_english'];
$pno=$data['personal_number'];
$name_of_member = $_REQUEST['nname'];
$rel = $_REQUEST['relation'];
if($dob!='0000-00-00'){
$age = differenceDate("-",gmdate("Y-m-d",time()+19800),$dob);
}else
$age=0;
$present_address = $_REQUEST['paddress'];
$permanant_address = $_REQUEST['prmaddr'];
$rank=$data['rank'];
$gs=$_REQUEST['gs'];
$marital=$_REQUEST['maritial'];
$designation=$data['designation'];
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=($_REQUEST['other']==''?'Other':$_REQUEST['other']);
}
$relation=$hindi;
$name_eng=$_REQUEST['name_eng'];
}
$abrs=mysql_query("select * from family_detail");
$num=mysql_num_rows($abrs);
$sql = "INSERT INTO `family_detail` (`employee_name`, `name_of_family_member`, `relation`, `date_of_birth`, `related_of_govt_service`, `marital_status`, `address`, `district`, `remark`, `personal_number`, `member_name_eng`,`relation_eng`) VALUES ('".$employee_name."', '".addslashes($name_of_member)."', '".addslashes($relation)."', '".$dob."', '".addslashes($gs)."', '".addslashes($marital)."', '".$present_address."', '', '', '".$pno."', '".$name_eng."','".$eng."')";
mysql_query($sql) or die(mysql_error());
header("Location: listing.php?id=".$data['personal_number']);
}
$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