<?
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 = '".htmlspecialchars($_POST['Joining_Unit_Name'])."',  joining_sub_unit = '".htmlspecialchars($_POST['Joining_Sub_Unit_Name'])."',  transfer_reason = '".htmlspecialchars($_POST['Transfer_reason'])."',  type_of_joining = '".htmlspecialchars($_POST['Type_of_Joining'])."' where personal_number = ".htmlspecialchars($_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
 (
 '".htmlspecialchars($_POST['Personal_number'])."',
 '".htmlspecialchars($_POST['Present_rank'])."',
 '".htmlspecialchars($_POST['Present_designation'])."',
 '".$transfer_date."',
 '".htmlspecialchars($_POST['Joining_Range'])."',
 '".htmlspecialchars($_POST['Joining_State'])."',
 '".htmlspecialchars($_POST['Joining_District'])."',
 '".htmlspecialchars($_POST['Type_of_Joining'])."',
 '".htmlspecialchars($_POST['Joining_Unit_Name'])."',
 '".htmlspecialchars($_POST['Joining_Sub_Unit_Name'])."',
 '".$Release_date."',
 '".htmlspecialchars($_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; 
?>