session_start();
//include '../conn.php';
include '../function.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"]))
{
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;
$rank=$present_rank;
$name_of_nominess = $_REQUEST['nname'];
$rel = $_REQUEST['relation'];
if($rel=='firk'){
$hindi='firk';
$eng='Father';
}else if($rel=='ekrk'){
$hindi='ekrk';
$eng='Mother';
}else if($rel=='iq=h'){
$hindi='iq=h';
$eng='Daughter';
}else if($rel=='iq='){
$hindi='iq=';
$eng='Son';
}else if($rel=='ifr'){
$hindi='ifr';
$eng='Husband';
}else if($rel=='iRuh'){
$hindi='iRuh';
$eng='Wife';
}else {
$hindi='vU;';
$eng=($_REQUEST['other']==''?'Other':$_REQUEST['other']);
}
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'];
}
$name_eng=$_REQUEST['name_eng'];
$designation=$present_designation;
}
/*$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 {
$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"] < 70000)
&& in_array($extension, $allowedExts))
{
$img_name1="nominee_image/".time().$_FILES["file"]["name"];
$img_name="../".$img_name1;
if(move_uploaded_file($_FILES["file"]["tmp_name"], $img_name))
{
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,nominee_name_eng,relation_eng,nominee_image) values('$personal_number', '".addslashes($employee_name)."', '$rank', '".addslashes($designation)."', '".addslashes($name_of_nominess)."', '$hindi', '$age', '$nomination_date', '$present_address', '$permanant_address', '".addslashes($nominee_typeb)."', '".addslashes($identification_mark)."', '$dob',null,'".$share."','".$name_eng."','".$eng."','".$img_name1."')");
header("Location: listing.php?id=".$personal_number);
}
}
else
{
echo "Please Upload less than 50KB Image";
}
}
updatecrkrecotd($_SESSION['login_pno'], $personal_number, nominee_transdate);
}
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']); ?> |
|
बैक |
होम |
लॉग आऊट |
|
|