session_start(); include("../conn.php"); function findrank($id = null) { $results=mysql_query("select * from rank_master where rank_id=".$id) or die(mysql_error()); if($x = mysql_fetch_array($results)) { return $x['rank_eng']; } else { return 'N/A'; } } function getSubUnit($userId) { //echo 'select * from sub_unitmaster where sub_unit_code = \''.$userId.'\''; $rs2 = mysql_query('select * from sub_unitmaster where sub_unit_code = \''.$userId.'\''); if(mysql_num_rows($rs2) != 0 ) { $rs2 = mysql_fetch_array($rs2); return $rs2['sub_unit']; } else { return false; } } function getUnit($userId) { $rs2 = mysql_query('select * from sub_unitmaster where pno_unit_code = \''.$userId.'\''); if(mysql_num_rows($rs2) != 0 ) { $rs2 = mysql_fetch_array($rs2); return $rs2['unit']; } else { return 'N/A'; } } $rs = mysql_query("select * from new_posting_detail where personal_number = ".$_REQUEST['Personal_number']); $rs = mysql_fetch_array($rs); $_SESSION['pno']=$_REQUEST['Personal_number']; $Personal_Number = $_REQUEST['Personal_number']; $Employee_name_hindi = $rs['first_name_of_employee_hindi'].' '.$rs['mname_hindi'].' '.$rs['lname_hindi']; $Employee_name_eng = $rs['first_name_of_employee_english'].' '.$rs['middle_name_of_employee_english'].' '.$rs['last_name_of_employee_english']; $Present_address = $rs['present_address']; $Present_address_hindi = $rs['present_address_hindi']; $Present_phone_residence_mobile = $rs['phone_number_residence_mob']; $Prsesent_phone_office = $rs['phone_number_office']; $Present_state_name = $rs['state_name']; $Present_district_name = $rs['district_name']; $Present_rank = $rs['present_rank']; $Present_designation = $rs['present_designation']; $Proficency_of_employee = $rs['proficiency_of_employee']; $Present_grad = $rs['selection_grade']; $date_of_selection_grad = $rs['date_of_selection_grade']; $S_Selection_Grade_Date = $rs['present_address_hindi']; $S_Selection_Grade = $rs['selection_grade']; $Higher_Selection_Grade_Date = $rs['higher_selection_grade_date']; $Higher_Selection_Grade = $rs['higher_selection_grade']; $Transfer_Flag = 'P'; $Transfer_Order_Date = $rs['transfer_order_date']; $Order_no = $rs['order_no']; $Release_date = $rs['release_date']; $Joining_Unit = $rs['joining_unit']; $Joining_Sub_Unit = $rs['joining_sub_unit']; $Transfer_Reason = $rs['transfer_reason']; $Transfer_attchment_from_date = ''; $Transfer_attachment_to_date = ''; $Transfer_on_attachment_period_extended = ''; $Transfer_on_deputation_from_date = ''; $Transfer_on_deputation_to_date = ''; $Transfer_on_deputation_period_extended = $rs['present_address_hindi']; $temp = explode('/',$_REQUEST['StartDate']); $Posting_date = $temp[2].'-'. $temp[0].'-'. $temp[1]; $Posting_time = $_REQUEST['Joining_time']; $Promotion_date = $rs['promotion_date']; $Present_Range = $rs['present_rank']; $Type_of_Joining = $rs['type_of_joining']; ?>