session_start();
if(!isset($_SESSION['Unit']) && !isset($_SESSION['user_type'])){
header("Location: ../index.php");
}
include '../conn.php';
$personal_number=$_REQUEST['id'];
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'];
}
function findrank($id = null)
{
$results=mysql_query("select serial_number,rank_id,rank_eng,rank_hin from rank_master where rank_id=".$id);
if($x = mysql_fetch_array($results))
{
return $x['rank_eng'];
} else {
return 'N/A';
}
}
if(isset($_REQUEST["B1"]))
{
/*print_r($_REQUEST);
exit(0);*/
$e_sdate="0000-00-00";
if($_REQUEST['e_sdate']!=""){
$temp = explode('/',$_REQUEST['e_sdate']);
$e_sdate = $temp[2].'-'. $temp[1].'-'. $temp[0];
}
$e_edate="0000-00-00";
if($_REQUEST['e_edate']!=""){
$temp = explode('/',$_REQUEST['e_edate']);
$e_edate = $temp[2].'-'. $temp[1].'-'. $temp[0];
}
$enq_ord_date="0000-00-00";
if($_REQUEST['enq_ord_date']!=""){
$temp = explode('/',$_REQUEST['enq_ord_date']);
$enq_ord_date = $temp[2].'-'. $temp[1].'-'. $temp[0];
}
$dop="0000-00-00";
if($_REQUEST['dop']!=""){
$temp = explode('/',$_REQUEST['dop']);
$dop = $temp[2].'-'. $temp[1].'-'. $temp[0];
}
$sql="update investigation set investigation_date='".$enq_ord_date."', officer_name='".$_POST['ef_name']."', officer_post='".$_POST['tempas3']."', order_no='".$_POST['e_orderno']."', order_date='".$enq_ord_date."', e_type='".$_POST['e_type']."', order_type='".$_POST['e_suspend']."', dist_id='".$_POST['tempas2']."', investigation_start='".$e_sdate."', investigation_end='".$e_edate."' where investigation_id='".$_REQUEST['idd']."' and pno='".$_REQUEST['personalno']."'";
mysql_query($sql);
header("Location: confirm_edit.php?id=".$_REQUEST['personalno']);
}
$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