session_start();
if(!isset($_SESSION['Unit']) && !isset($_SESSION['user_type'])){
header("Location: ../index.php");
}
//include '../conn.php';
include '../function.php';
include ("rtcmaater.php");
$pno=$_REQUEST['id'];
while(strlen($pno)<9){
$pno="0".$pno;
}
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,rank_id 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'].'_'.$x['rank_id'];
}
function formatDateField($date){
if($date=='0000-00-00' || $date=='')
return '';
$strArray=explode("-",$date);
$newDate=$strArray[2]."/".$strArray[1]."/".$strArray[0];
return $newDate;
}
function datetodatabase($str){
if($str=='' || $str=='//'){
return '';
}
$strarr=explode("/",$str);
$newdate=$strarr[2]."-".$strarr[1]."-".$strarr[0];
return $newdate;
}
$rec=mysql_query("select max(selection_type) maxi from promotion_detail where Personal_Number=".$pno);
$sec_type=array();
if(mysql_num_rows($rec)){
while($row=mysql_fetch_array($rec)){
$sec_type[]=$row['maxi'];
}
}
$cnt=count($sec_type);
//print_r($_SESSION);
if(isset($_REQUEST["B1"]))
{
/*print_r($_REQUEST);
exit(0);*/
if($_REQUEST['pdate']!=""){
$temp = explode('/',$_REQUEST['pdate']);
$Promotion_Date = $temp[2].'-'. $temp[1].'-'. $temp[0];
} else{
$Promotion_Date="0000-00-00";
}
/*
$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 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);
$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['rank'];
$no_of_previous_promotion=0;
if($_REQUEST['promotion_status']!=""){
$no_of_previous_promotion=$_REQUEST['promotion_status'];
}
}
$rec=mysql_query("select max(selection_type) maxi from promotion_detail where Personal_Number=".$Personal_Number);
$sec_type=array();
if(mysql_num_rows($rec)){
while($row=mysql_fetch_array($rec)){
$sec_type[]=$row['maxi'];
}
}
$cnt=count($sec_type);
$sel_type=$sec_type[$cnt-1]+1;
if($sel_type==1){
$select_grade=$_REQUEST["Present_grad1"];
$temp=explode('/',$_REQUEST['sgd1']);
}
if($sel_type==2){
$select_grade=$_REQUEST["Present_grad2"];
$temp=explode('/',$_REQUEST['sgd2']);
}
if($sel_type==3){
$select_grade=$_REQUEST["Present_grad3"];
$temp=explode('/',$_REQUEST['sgd3']);
}
if($_REQUEST['p_orderdate']==""){
$promotionOrderDate="0000-00-00";
} else {
$promotionOrderDate=datetodatabase($_REQUEST['p_orderdate']);
}
$remarks=$_REQUEST['comment'];
$select_date=$temp[2].'-'.$temp[1].'-'.$temp[0];
if($select_date=='--' && $select_grade==''){
$sel_type=0;
}
if($select_date=='--'){
$select_date='0000-00-00';
}
if($_POST['mark_obtained']!=""){
$mark_obtaineddb=$_POST['mark_obtained'];
}
if($_POST['total_marks']!=""){
$total_marksdb=$_POST['total_marks'];
}
if($_POST['session_from']!=""){
$PTC_Session=$_POST['session_from'].'-'.$_POST['session_to'];
}
if($_POST['PCT_Batch_no']!=""){
$PCT_Batch_no=$_POST['PCT_Batch_no'];
}
$username=$_SESSION['user_name'];
$ip = $_SERVER["REMOTE_ADDR"];
if($Promotion_Type=='1' || $Promotion_Type=='2' || $Promotion_Type=='4')
{
mysql_query("insert into promotion_detail(Personal_Number, Employee_name,no_of_previous_promotion , Promotion_Date, Promotion_Order_No, Promotion_OrderDate, Promotion_Type,remark, seniority_level, sub_unit, Previous_Promotion_rank,selection_date,selection_grade,selection_type, Total_marks,marks_Obtained,PTC_Session,PCT_Batch_no,chest_no,PTCName,cader,isPresent,user_name,ipaddress,unit) values('$Personal_Number', '$Employee_name','$no_of_previous_promotion', '$Promotion_Date', '$Promotion_Order_No','".$promotionOrderDate."', '$Promotion_Type','".$remarks."', '$seniority_level', '$sub_unit', '$Previous_Promotion_rank','".$select_date."','".$select_grade."',".$sel_type.",'".$total_marksdb."','".$mark_obtaineddb."','".$PTC_Session."','".$PCT_Batch_no."','".$_POST['chest_no']."','".$_POST['PTCName']."','".$_POST['cadre']."','".$_POST['radiobutton']."','".$username."','".$ip."','".$_SESSION['Unit']."')");
}
else if($Promotion_Type=='3')
{
mysql_query("insert into promotion_detail(Personal_Number, Employee_name,no_of_previous_promotion , Promotion_Date, Promotion_Order_No, Promotion_OrderDate, Promotion_Type,remark, seniority_level, sub_unit, Previous_Promotion_rank,selection_date,selection_grade,selection_type, Total_marks,marks_Obtained,PTC_Session,PCT_Batch_no,chest_no,PTCName,cader,isPresent,user_name,ipaddress,unit) values('$Personal_Number', '$Employee_name','$no_of_previous_promotion', '$Promotion_Date', '$Promotion_Order_No','".$promotionOrderDate."', '$Promotion_Type','".$remarks."', '$seniority_level', '$sub_unit', '".$_SESSION['r_id']."','".$select_date."','".$select_grade."',".$sel_type.",'".$total_marksdb."','".$mark_obtaineddb."','".$PTC_Session."','".$PCT_Batch_no."','".$_POST['chest_no']."','".$_POST['PTCName']."','".$_POST['cadre']."','".$_POST['radiobutton']."','".$username."','".$ip."','".$_SESSION['Unit']."')");
}
if($_POST['radiobutton']=='1' && ($Promotion_Type=='1' || $Promotion_Type=='2' || $Promotion_Type=='4'))
{
mysql_query("update employee_master set rank='$Previous_Promotion_rank',cadre='".$_POST['cadre']."',isDirectOrRanker='1',joining_date_presnetRank='".$Promotion_Date."' ,user_name='".$username."' ,ipaddress='".$ip."' where personal_number='$Personal_Number'") or print mysql_error();
}
else if($_POST['radiobutton']=='1' && $Promotion_Type=='3')
{
mysql_query("update employee_master set isDirectOrRanker='1',joining_date_presnetRank='".$Promotion_Date."' ,user_name='".$username."' ,ipaddress='".$ip."',isoutofturn='1' where personal_number='$Personal_Number'") or print mysql_error();
}
else if($_POST['radiobutton']=='2' && $Promotion_Type=='3')
{
mysql_query("update employee_master set isDirectOrRanker='1', isoutofturn='1' where personal_number='$Personal_Number'") or print mysql_error();
}
updatecrkrecotd($_SESSION['login_pno'], $Personal_Number, promotion_transdate);
/*mysql_query("insert into promotion_detail(Personal_Number, Employee_name,no_of_previous_promotion , Promotion_Date, Promotion_Order_No, Promotion_Type, seniority_level, sub_unit, Total_marks, Previous_Promotion_rank,selection_date,selection_grade,selection_type) values('$Personal_Number', '$Employee_name','$no_of_previous_promotion', '$Promotion_Date', '$Promotion_Order_No', '$Promotion_Type', '$seniority_level', '$sub_unit', '$Total_marks', '$Previous_Promotion_rank','".$select_date."','".$select_grade."',".$sel_type.")") ;*/
header("Location: confirm_add.php?id=".$personal_number);
}
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';
}
}
$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='".$pno."'") ;
$arow=mysql_fetch_array($results);
extract($arow);
?>
Uttar Pradesh Police Nominol Roll System
|
|
|
जनपद/इकाई का नाम
echo ' - '.strToUpper($_SESSION['Unit1']); ?> |
|
बैक |
होम |
लॉग आऊट |
|
|
|
|