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(); } /*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
जनपद/इकाई का नाम
बैक  |  होम  |  लॉग आऊट  

पदोन्नति विवरण

पर्सनल नम्बर :

नाम : emp hindi name error = No database selected