session_start(); if(!isset($_REQUEST['pno'])) { header('Location: ../posting_detail/search1.php'); exit(0); } include '../conn.php'; if(isset($_REQUEST['B1'])) { $Release_date = $_REQUEST['sg3'].'-'.$_REQUEST['sg2'].'-'.$_REQUEST['sg1']; $rs = mysql_query('select * from temp_itransfer_detail where personal_number = '.$_REQUEST['Personal_number']); if(mysql_num_rows($rs) > 0) { $rs = mysql_fetch_array($rs); if($_POST['status']) { if($rs['transfer_posting_flag'] == 'T') { //mysql_query("insert into archive_posting_detail select * from new_posting_detail where keyid = ".$rs['keyid']) ; //echo "update temp_itransfer_detail set transfer_posting_flag = 'TP', release_date = '".$Release_date."' where personal_number = ".$_REQUEST['Personal_number']; //mysql_query("insert into archive_posting_detail select *, null from new_posting_detail where keyid = ".$rs['keyid']) or die(mysql_error()) ; mysql_query("update temp_itransfer_detail set transfer_posting_flag = 'TP', release_date = '".$Release_date."' where personal_number = ".$_REQUEST['Personal_number']) or die(mysql_error()); mysql_query("delete from new_posting_detail where personal_number = ".$_REQUEST['Personal_number']) or die(mysql_error()); mysql_query("insert ignore into new_posting_detail select * from temp_itransfer_detail where personal_number = ".$_REQUEST['Personal_number']); mysql_query("delete from temp_itransfer_detail where personal_number = ".$_REQUEST['Personal_number']) or die(mysql_error()); //header("Location: ../posting_detail/search2.php?saved=1&page=".$_SESSION['page']."&c=".$_SESSION['c']."&k".$_SESSION['k']); header("Location: confirm_transfer1.php"); exit(0); } } else { echo "update new_posting_detail set transfer_posting_flag = 'P' where personal_number = ".$_REQUEST['Personal_number']; mysql_query("update new_posting_detail set transfer_posting_flag = 'P' where personal_number = ".$_REQUEST['Personal_number']) or die(mysql_error()); mysql_query("delete from temp_itransfer_detail where personal_number = ".$_REQUEST['Personal_number']) or die(mysql_error()); //header("Location: ../posting_detail/search2.php?saved=1&page=".$_SESSION['page']."&c=".$_SESSION['c']."&k".$_SESSION['k']); header("Location: confirm_transfer1.php"); exit(0); } } } function findrank($id = null) { if($id == '') return $id; $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']; } } $rsq = mysql_query('select * from temp_itransfer_detail where personal_number = '.$_REQUEST['pno']); $rsq = mysql_fetch_array($rsq); if($rsq['transfer_posting_flag']=='P') { header('Location: transfer.php?pno='.$_REQUEST['pno']); exit(0); } $orderdate = $rsq['transfer_order_date']; $orderno = $rsq['order_no ']; $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; ?> } $arow=mysql_fetch_array($results); extract($arow); ?>