25 [transfer_date_m] => 4 [transfer_date_yr] => 1955 [return] => P [Personal_number] => 000470025 [Employee_name] => BHARAT (DHOBI) [Present_rank] => 15 [Present_designation] => [orderno] => 12122 [B1] => Submit [PHPSESSID] => 8334eea4ea5ac80f3733148d6dffdaf0 ) Array ( [return] => P [Personal_number] => 692260108 [Employee_name] => RAMESH CHANDRA YADAV [Present_rank] => [Present_designation] => [dor] => 09/04/2007 [orderno] => ORDER NO [Type_of_Joining] => DISTRICT [tempas] => LUCKNOW [Joining_Range] => 13 [Joining_District] => FZD [Joining_Unit_Name] => 896 [Joining_Sub_Unit_Name] => 89611 [Transfer_reason] => Public Intrest [B1] => Submit [PHPSESSID] => ba974d7a33d8feb4a2a19c9fec6e1438 ) */ /*$checkquery = mysql_query("select max(keyid),joining_unit,joining_sub_unit from archive_posting_detail where personal_number='".$_REQUEST['Personal_number']."' group by keyid") or die("query not fired = ".mysql_error()); if(mysql_num_rows($checkquery)>0){ while($results=mysql_fetch_array($checkquery)){ if($results['keyid']==null){echo "query result1 = ".mysql_num_rows($checkquery)."
\n"; continue;} if($results['joining_sub_unit']==null && $results['joining_unit']==$_POST['Joining_Sub_Unit_Name']){ echo "query result2 = ".mysql_num_rows($checkquery)."
\n";?> \n";?> 0) { $rs = mysql_fetch_array($rs); //echo "update new_posting_detail set order_no = '".$_POST['orderno']."', joining_unit = '".$_POST['Joining_Unit_Name']."', joining_sub_unit = '".$_POST['Joining_Sub_Unit_Name']."', transfer_reason = '".$_POST['Transfer_reason']."', type_of_joining = '".$_POST['Type_of_Joining']."', transfer_order_date = '".$transfer_date."' where personal_number = ".$_REQUEST['Personal_number']; //mysql_query("insert into archive_posting_detail select * from new_posting_detail where keyid = ".$rs['keyid']) ; //print_r($_REQUEST); //exit(0); mysql_query("insert ignore into temp_itransfer_detail select * from new_posting_detail where personal_number = ".$_REQUEST['Personal_number']) or die(mysql_error()); mysql_query("insert into archive_posting_detail select *, NOW() from new_posting_detail where personal_number = ".$_REQUEST['Personal_number']) or die(mysql_error()); /* [return] => P [Personal_number] => 642010492 [Employee_name] => ABHAYRAM [Present_rank] => [Present_designation] => [dor] => 09/01/2007 [orderno] => 123 [Type_of_Joining] => DISTRICT >> [tempas] => ALLAHABAD >> [Joining_Range] => CHITRAKOOT DHAM *TO BE CODE >> present_range >> [Joining_District] => HAMIRPUR *TO BE CODE >> present_district_name [Joining_Unit_Name] => 636 [Joining_Sub_Unit_Name] => 63603 [Transfer_reason] => Public Intrest [B1] => Submit [PHPSESSID] => ba974d7a33d8feb4a2a19c9fec6e1438 Array ( [return] => P [Personal_number] => 692260108 [Employee_name] => RAMESH CHANDRA YADAV [Present_rank] => [Present_designation] => [dor] => 09/04/2007 [orderno] => ORDER NO [Type_of_Joining] => DISTRICT >> [tempas] => LUCKNOW >> [Joining_Range] => 13 >> [Joining_District] => FZD [Joining_Unit_Name] => 896 [Joining_Sub_Unit_Name] => 89611 [Transfer_reason] => Public Intrest [B1] => Submit [PHPSESSID] => ba974d7a33d8feb4a2a19c9fec6e1438 ) */ //$_SESSION['orderno']=$_POST['orderno']; $_SESSION['pno']=$_REQUEST['Personal_number']; mysql_query("update temp_itransfer_detail set nature_of_job = '".$_POST['nature_of_job']."', order_no = '".$_POST['orderno']."', joining_unit = '".$_POST['Joining_Unit_Name']."', joining_sub_unit = '".$_POST['Joining_Sub_Unit_Name']."', transfer_posting_flag = 'T', transfer_reason = '".$_POST['Transfer_reason']."', type_of_joining = '".$_POST['Type_of_Joining']."', transfer_order_date = '".$transfer_date."', zone_name = '".$_POST['tempas']."', present_range = '".$_POST['Joining_Range']."', present_district_name = '".$_POST['Joining_District']."' where personal_number = ".$_REQUEST['Personal_number']) or die(mysql_error()) or die(mysql_error()); mysql_query("update new_posting_detail set nature_of_job = '".$_POST['nature_of_job']."', transfer_posting_flag = 'T' where personal_number = ".$_REQUEST['Personal_number']) or die(mysql_error()) or die(mysql_error()); //exit(0); mysql_query("insert into transfer_detail ( personal_number, present_rank, present_designation, transfer_date, joining_range, joining_state, joining_district, type_of_joining, Joining_unit_name, joining_sub_unit_name, release_date, transfer_reason ) values ( '".$_POST['Personal_number']."', '".$_POST['Present_rank']."', '".$_POST['Present_designation']."', '".$transfer_date."', '".$_POST['Joining_Range']."', '".$_POST['Joining_State']."', '".$_POST['Joining_District']."', '".$_POST['Type_of_Joining']."', '".$_POST['Joining_Unit_Name']."', '".$_POST['Joining_Sub_Unit_Name']."', '".$Release_date."', '".$_POST['Transfer_reason']."' )") or die(mysql_error()); } //header("Location: ../posting_detail/search2.php?saved=1&page=".$_SESSION['page']."&c=".$_SESSION['c']."&k".$_SESSION['k']); header("Location: confirm_transfer.php"); exit(0); } ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// if(!isset($_REQUEST['pno'])) { header('Location: ../posting_detail/search1.php'); exit(0); } //echo 'select * from new_posting_detail where personal_number = '.$_REQUEST['pno']; $rsq = mysql_query('select * from new_posting_detail where personal_number = '.$_REQUEST['pno']); $rsq = mysql_fetch_array($rsq); if($rsq['transfer_posting_flag']=='T') { header('Location: transfer1.php?pno='.$_REQUEST['pno']); exit(0); } $results=mysql_query("select * from new_posting_detail where personal_number='".$_REQUEST['pno']."' ") or die(mysql_error()); if(mysql_num_rows($results)==0) { $_SESSION['error1'] = true; header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/posting.php" ); exit; ?> Uttar Pradesh Police Nominol Roll System
जनपद/इकाई का नाम -
बैक  |  होम  |  लॉग आऊट  | पूर्व कर्मचारी का विवरण जोडें  | रिपोर्टस

TRANSFER DETAIL
Personal Number:

Name of Employee:

Present Rank: