<?
session_start(); 
include("../conn.php");
//$transfer_date=$_POST['transfer_date_yr'].'-'.$_POST['transfer_date_m'].'-'.$_POST['transfer_date_d'];
$Release_date=$_POST['Release_date_yr'].'-'.$_POST['Release_date_m'].'-'.$_POST['Release_date_d'];

$rs = mysql_query('select * from new_posting_detail where personal_number = '.$_REQUEST['Personal_number']);
if(mysql_num_rows($rs) > 0)
{	$rs = mysql_fetch_array($rs);
	if($rs['transfer_posting_flag'] == 'T')
	{
		//mysql_query("insert into archive_posting_detail select * from new_posting_detail where keyid = ".$rs['keyid']) ;
		mysql_query("update new_posting_detail set transfer_posting_flag = 'TP',  release_date = '".$Release_date."',  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']."' where personal_number = ".$_REQUEST['Personal_number']) or die(mysql_error());
		
		
		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());

$_SESSION['saved'] = true;

	} else {
	
	 
	header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/transfer1.php?err=3&pno=".$_REQUEST['Personal_number'] );
	exit; 
	}
} 


header("Location: ../posting_detail/search2.php?saved=1&page=".$_SESSION['page']."&c=".$_SESSION['c']."&k".$_SESSION['k']);
exit; 
?>