session_start();
include '../conn.php';
$pno=$_REQUEST['id'];
while(strlen($pno)<9){
$pno="0".$pno;
}
function findrank1($pno){
if($pno == '') return $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'];
}
//$sel_date
if(isset($_REQUEST["B1"]))
{
$temp = explode('/',$_REQUEST['pdate']);
$Promotion_Date = $temp[2].'-'. $temp[1].'-'. $temp[0];
$temp = explode('/',$_REQUEST['fdate']);
$From_Date = $temp[2].'-'. $temp[1].'-'. $temp[0];
$temp = explode('/',$_REQUEST['tdate']);
$To_Date = $temp[2].'-'. $temp[1].'-'. $temp[0];
$temp = explode('/',$_REQUEST['jdate']);
$Joing_Date_at_Promotion = $temp[2].'-'. $temp[1].'-'. $temp[0];
$rs = mysql_query('select * from new_posting_detail where personal_number = '.$_REQUEST['personalno']);
if(mysql_num_rows($rs) > 0)
{
$rs = mysql_fetch_array($rs);
extract($rs);
$Personal_Number = $personal_number;
$Employee_name = $first_name_of_employee_english.' '.$middle_name_of_employee_english.' '.$last_name_of_employee_english;
$Promotion_Order_No = $_REQUEST['p_orderno'];
$Promotion_Type = $_REQUEST['ptype'];
$seniority_level = $_REQUEST['slevel'];
$sub_unit = $_REQUEST['Joining_Sub_Unit_Name'];
$Batch = $_REQUEST['batch'];
$Total_marks = '0';
$marks_Obtained = $_REQUEST['tmarks'];
$Position = $_REQUEST['position'];
$promotion_District = $_REQUEST['district'];
$promotion_Unit = $_REQUEST['Joining_Unit_Name'];
$Previous_Promotion_rank = $_REQUEST['Previous_Promotion_rank'];
$no_of_previous_promotion=$_REQUEST['promotion_status'];
}
mysql_query("update promotion_detail set Promotion_Date='$Promotion_Date', Promotion_Order_No='$Promotion_Order_No', Promotion_Type='$Promotion_Type', seniority_level='$seniority_level', sub_unit='$sub_unit', Batch='$Batch', To_Date='$To_Date', From_Date='$From_Date', Total_marks='$Total_marks', marks_Obtained='$marks_Obtained', Position='$Position', Joing_Date_at_Promotion='$Joing_Date_at_Promotion', promotion_District='$promotion_District', promotion_Unit='$promotion_Unit',Previous_Promotion_rank='$Previous_Promotion_rank',no_of_previous_promotion='$no_of_previous_promotion' where Serial_number=".$_REQUEST['soid']) ;
header("Location: confirm_edit.php?id=".$personal_number);
}
$rec=mysql_query("select * from promotion_detail where Serial_number=".$_REQUEST['eid']);
$sec_type=array();
if(mysql_num_rows($rec)){
while($row=mysql_fetch_array($rec)){
$sec_type[]=$row['selection_type'];
$seldate1=$row['selection_date'];
$selgrade=$row['selection_grade'];
}
}
$cnt=count($sec_type);
$recno=mysql_query("select max(selection_type) maxi from promotion_detail where Personal_Number=".$pno);
// $sec_type1=array();
if(mysql_num_rows($recno)){
while($row=mysql_fetch_array($recno)){
$sec_type1=$row['maxi'];
}
}
$cnt1=count($sec_type1);
$temp = explode('-',$seldate1);
$sel_date = $temp[2].'/'. $temp[1].'/'. $temp[0];
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 * from new_posting_detail where personal_number='".$pno."' ") ;
$arow=mysql_fetch_array($results);
extract($arow);
?>
Uttar Pradesh Police Nominol Roll System
|
|
|
जनपद/इकाई का नाम
echo ' - '.strToUpper($_SESSION['Unit1']); ?> |
|
बैक |
होम |
लॉग आऊट |
|
|
|
|