session_start();
include '../conn.php';
function findrank1($pno){
if($pno == '') return $pno;
//echo "select rank_hin from rank_master where rank_id=(select confirmation_rank from employee_master where personal_number=".$pno.")";
$results=mysql_query("select rank_hin from rank_master where rank_id=(select rank from employee_master where personal_number=".$pno.")") ;
if($x = mysql_fetch_array($results)) return $x['rank_hin'];
}
if(isset($_REQUEST["B1"]))
{
/*print_r($_REQUEST);
exit(0);*/
if($_REQUEST['ndate']==""){
$ndate="0000-00-00";
}else{
$temp = explode('/',$_REQUEST['ndate']);
$ndate = $temp[2].'-'. $temp[1].'-'. $temp[0];
}
if($_REQUEST['dob']==""){
$dob="0000-00-00";
}else{
$temp = explode('/',$_REQUEST['dob']);
$dob = $temp[2].'-'. $temp[1].'-'. $temp[0];
}
$rs = mysql_query('select key_id,personal_number,present_address,present_address_hindi,present_phone_residence_mobile,present_phone_office,present_range,present_state_name,present_district_name,present_rank,present_designation,proficiency_of_employee,present_grad,date_of_selection_grad,s_selection_grad_date,s_selection_grad,higher_selection_grad_date,higher_selection_grad,transfer_posting_flag,transfer_order_date,order_no,release_date,type_of_joining,joining_unit,joining_sub_unit,transfer_reason,posting_date,posting_time,pormotion_date,alloted_to,first_name_of_employee_english,middle_name_of_employee_english,last_name_of_employee_english,archive_date from new_posting_detail where personal_number = '.$_REQUEST['personalno']);
if(mysql_num_rows($rs) > 0)
{
$rs = mysql_fetch_array($rs);
extract($rs);
$employee_name = $first_name_of_employee_english.' '.$middle_name_of_employee_english.' '.$last_name_of_employee_english;
$date_of_birth = $dob;
$name_of_nominess = $_REQUEST['nname'];
$relation = $_REQUEST['relation'];
if($_REQUEST['age']==""){
$age=0;
}else {
$age = $_REQUEST['age'];
}
$nomination_date = $ndate;
$present_address = $_REQUEST['paddress'];
$permanant_address = $_REQUEST['prmaddr'];
$identification_mark = $_REQUEST['idmark'];
$nominee_typeb = $_REQUEST['ntype'];
$share=0;
if($_REQUEST['share']!=""){
$share = $_REQUEST['share'];
}
}
/*$abrs=mysql_query("select max(serial_number) as maxid from nominees_detail");
$abnum=mysql_fetch_assoc($abrs);
$num=$abnum['maxid'];*/
$rs=mysql_query("select count(*) cnt from nominees_detail where personal_number='".$personal_number."' and name_of_nominess like '".addslashes($name_of_nominess)."' and relation like '".$relation."' and identification_mark like '".addslashes($identification_mark)."' and dob='".$dob."'") ;
$dup=mysql_fetch_assoc($rs);
if($dup['cnt']>0){}
else {
mysql_query("insert into nominees_detail(personal_number, employee_name, rank, designation, name_of_nominess, relation, age, nomination_date, present_address, permanant_address, nominee_type, identification_mark, dob,serial_number,ans_shear) values('$personal_number', '".addslashes($employee_name)."', '$rank', '".addslashes($designation)."', '".addslashes($name_of_nominess)."', '$relation', '$age', '$nomination_date', '$present_address', '$permanant_address', '".addslashes($nominee_typeb)."', '".addslashes($identification_mark)."', '$dob',null,".$share.")");
}
header("Location: listing.php?id=".$personal_number);
}
function findrank($id = null)
{
$results=mysql_query("select * from rank_master where rank_id=".$id) ;
if($x = mysql_fetch_array($results))
{
return $x['rank_eng'];
} else {
return 'N/A';
}
}
$results=mysql_query("select key_id,personal_number,present_address,present_address_hindi,present_phone_residence_mobile,present_phone_office,present_range,present_state_name,present_district_name,present_rank,present_designation,proficiency_of_employee,present_grad,date_of_selection_grad,s_selection_grad_date,s_selection_grad,higher_selection_grad_date,higher_selection_grad,transfer_posting_flag,transfer_order_date,order_no,release_date,type_of_joining,joining_unit,joining_sub_unit,transfer_reason,posting_date,posting_time,pormotion_date,alloted_to,first_name_of_employee_english,middle_name_of_employee_english,last_name_of_employee_english,archive_date from new_posting_detail where personal_number='".$_REQUEST['id']."' ") ;
$arow=mysql_fetch_array($results);
extract($arow);
?>
Uttar Pradesh Police Nominol Roll System
|
|
|
|
|
जनपद/इकाई का नाम
echo ' - '.strToUpper($_SESSION['Unit1']); ?> |
|
बैक |
होम |
लॉग आऊट |
|
|