สอบถามเกี่ยวกับ การอนุมัติ และยกเลิกการอนุมัติ (เรื่องการโอนย้ายพนักงาน)

<?
session_start();

include("header.php");

#Query Document
$objQuery = mysql_query("SELECT transfer.tr_id,transfer.tr_status,transfer.tr_update,transfer.tr_rootcause,transfer.tr_update_id,transfer.tr_fix,
			transfer.tr_con,transfer.tr_con_id,
			asset.emp_id,asset.dept_id,
			adminis.admin_id,adminis.admin_name,adminis.admin_lastname,
			user.user_id,user.user_name,user.user_lastname,
			department.dept_id,department.dept_name,
			employee.emp_id,employee.emp_name,employee.emp_lastname
			FROM transfer LEFT JOIN transfer_detail ON (transfer_detail.tr_id = transfer.tr_id)
			LEFT JOIN adminis ON (adminis.admin_id = transfer.tr_update_id)
			LEFT JOIN asset ON (asset.asset_id = transfer.asset_id)
			LEFT JOIN user ON (user.user_id = transfer.tr_update_id)
			LEFT JOIN employee ON (employee.emp_id = transfer.emp_id)
			LEFT JOIN department ON (department.dept_id = transfer.dept_id)
			WHERE transfer.tr_id = '".$_GET["transfer_id"]."'") or die ("Not Query Database1");
$objResult = mysql_fetch_array($objQuery);

#Deasciption
echo "
<center>
<table id=\"tblDescription\">
<tr>
<td valign=\"top\">

<br>
<div id=\"titlePage\" align=\"center\">รายละเอียดโอนย้ายสินทรัพย์
[";
if($objResult["tr_status"] == "1"){
	echo "รออนุมัติ";
}elseif($objResult["tr_status"] == "2"){
	echo "<font color='#FF0000'>ยกเลิก</font>";
}else{
	echo "<font color='#0000FF'>อนุมัติแล้ว</font>";
}
echo "]</div>
<div id=\"titlePage\" align=\"left\">
<a href=\"transfer.php\" id=\"btnLink\"><img src=\"../images/icons/undo-icon.png\">ย้อนกลับ</a>
</div>
<center>
<form action=\"".$_SERVER["PHP_SELF"]."?transfer_id=".$objResult["tr_id"]."\" method=\"post\">
<table id=\"tblfrmAdd\">
	<tr height=\"30\">
	<td width=\"20%\" align=\"right\" valign=\"middle\">วันที่โอนย้ายสินทรัพย์ :</td>
	<td width=\"30%\" align=\"left\" valign=\"middle\">".convertDate(strtotime($objResult["tr_update"]))."&nbsp;".convertTime(strtotime($objResult["tr_update"]))."</td>
		<td width=\"20%\" align=\"right\" valign=\"middle\">เลขที่เอกสาร :</td>
		<td width=\"30%\" align=\"left\" valign=\"middle\">".$objResult["tr_id"]."</td>
	</tr>

	<tr height=\"30\">
		<td align=\"right\" valign=\"middle\">ผู้ขอโอนย้ายสินทรัพย์ :</td>
		<td align=\"left\" valign=\"middle\">
";
	 	if($objResult["admin_id"] == $objResult["tr_update_id"]){
			echo $objResult["admin_name"]." ".$objResult["admin_lastname"]." ";
		}elseif($objResult["user_id"] == $objResult["tr_update_id"]){
			echo $objResult["user_name"]." ".$objResult["user_lastname"];
		}
echo "
		</td>

	</tr>
	</tr>

	<tr height=\"30\">
	<td width=\"20%\" align=\"right\" valign=\"middle\">สาเหตุการแจ้งซ่อม :</td>
	<td width=\"30%\" align=\"left\" valign=\"middle\">".$objResult["tr_rootcause"]."</td>
	</tr>

</table>
<table id=\"tblWhileData\" width=\"100%\" height=\"30\">
	<tr height=\"30\" bgcolor=\"#CCCCCC\">
	<th width=\"10%\">รหัสสินทรัพย์</th>
	<th width=\"30%\">ชื่อสินทรัพย์</th>
	<th width=\"15%\">แผนกโอนออก</th>
	<th width=\"15%\">ชื่อพนักงานโอนออก</th>
	<th width=\"15%\">แผนกโอนเข้า</th>
	<th width=\"15%\">ชื่อพนักงานโอนเข้า</th>
	</tr>
";
	#Query Loop asset
	$objQuery = mysql_query("SELECT * FROM transfer_detail
				LEFT JOIN transfer ON (transfer.tr_id = transfer_detail.tr_id)
				LEFT JOIN asset ON (transfer_detail.asset_id = asset.asset_id)
				LEFT JOIN department ON (department.dept_id = asset.dept_id)
				LEFT JOIN employee ON (employee.emp_id = asset.emp_id)
				LEFT JOIN unit ON (unit.unit_id = asset.unit_id)
				WHERE transfer.tr_id = '".$_GET["transfer_id"]."'") or die ("Not Query Database2");
	while($objResult = mysql_fetch_array($objQuery)){
echo "
	<tr height=\"30\" id=\"tblWhileData1\">
		<td align=\"center\" valign=\"middle\">".$objResult["asset_id"]."</td>
		<td align=\"left\" valign=\"middle\">".$objResult["asset_name"]."</td>
		<td align=\"center\" valign=\"top\">

";
	$objQuery = mysql_query("SELECT * FROM transfer_detail
				LEFT JOIN transfer ON (transfer_detail.tr_id = transfer.tr_id)
				LEFT JOIN department ON (transfer.depto_id = department.dept_id)
				WHERE transfer.tr_id = '".$_GET["transfer_id"]."'") or die ("Not Query Database5");
				while($objResult = mysql_fetch_array($objQuery)){
					echo $objResult["dept_name"];

				}
echo "

		</td>
		<td align=\"center\" valign=\"top\">

		";
		$objQuery = mysql_query("SELECT * FROM transfer_detail
				LEFT JOIN transfer ON (transfer_detail.tr_id = transfer.tr_id)
				LEFT JOIN employee ON (transfer.empo_id = employee.emp_id)
				WHERE transfer.tr_id = '".$_GET["transfer_id"]."'") or die ("Not Query Database5");
				while($objResult = mysql_fetch_array($objQuery)){
					echo $objResult["emp_name"]." ".$objResult["emp_lastname"];

				}
		echo "

		</td>

		<td align=\"center\" valign=\"top\">

		";
		//แผนกโอนเข้า
		$objQuery_dept = mysql_query("SELECT * FROM transfer_detail
				LEFT JOIN transfer ON (transfer_detail.tr_id = transfer.tr_id)
				LEFT JOIN asset ON (transfer_detail.asset_id = asset.asset_id)
				LEFT JOIN department ON (transfer.dept_id = department.dept_id)
				LEFT JOIN unit ON (unit.unit_id = asset.unit_id)
				WHERE transfer.tr_id = '".$_GET["transfer_id"]."'") or die ("Not Query Database5");
				while($objResult_dept = mysql_fetch_array($objQuery_dept)){
					echo $objResult_dept["dept_name"];
					$dept_id = $objResult_dept["dept_id"];
				}
		echo "

		</td>
		<td align=\"center\" valign=\"top\">

";
//ชื่อพนักงานโอนเข้า
	$objQuery_emp = mysql_query("SELECT * FROM transfer_detail
		 		LEFT JOIN transfer ON (transfer_detail.tr_id = transfer.tr_id)
				LEFT JOIN asset ON (transfer_detail.asset_id = asset.asset_id)
				LEFT JOIN employee ON (transfer.emp_id = employee.emp_id)
				LEFT JOIN unit ON (unit.unit_id = asset.unit_id)
				WHERE transfer.tr_id = '".$_GET["transfer_id"]."'") or die ("Not Query Database6");
				while($objResult_emp = mysql_fetch_array($objQuery_emp)){
					echo $objResult_emp["emp_name"]." ".$objResult_emp["emp_lastname"];
					$emp_id = $objResult_emp["emp_id"];

				}
echo "

		</td>


	</tr>
";
	}
echo "
	<tr height=\"50\">
		<td colspan=\"6\" align=\"center\" valign=\"middle\">
";
		#Query Status
		$objQuery = mysql_query("SELECT * FROM transfer WHERE tr_id = '".$_GET["transfer_id"]."'") or die ("Not Query Database");
		$objResult = mysql_fetch_array($objQuery);
		if($objResult["tr_status"] == "1"){
echo "
			<input type=\"submit\" id=\"btnCancel\" name=\"btnCancel\" value=\"ยกเลิกใบโอนย้าย\" onclick=\"return confirm('ยืนยันการยกเลิกใบโอนย้าย ".$_GET["transfer_id"]."')\"/>
			<input type=\"submit\" id=\"btnSubmit\" name=\"btnSubmit\" value=\"อนุมัติใบโอนย้าย\" onclick=\"return confirm('ยืนยันการอนุมัติใบโอนย้าย ".$_GET["transfer_id"]."')\"/>
";
		}elseif($objResult["tr_status"] == "3" || $objResult["tr_status"] == "4"){
echo "
			<input type=\"button\" id=\"btnPrint\" name=\"btnPrint\" value=\"พิมพ์ใบโอนย้าย\" onclick=\"window.open('transfer_print.php?transfer_id=".$_GET["transfer_id"]."')\"/></td>
";
		}
echo "
	</tr>
</table>
</form>
</center>

</td>
</tr>
</table>

";

include("../inc/inc_footer.php");

echo "
</center>
";


//echo $objResult_emp["emp_name"];echo "<br>";
//echo $_SESSION[$requestRowcount][0];echo "<br>";

//die();
#Update Status
if($_POST["btnCancel"]){
	$objQuery = mysql_query("UPDATE transfer SET
		tr_con = now(),
		tr_con_id = '".$_SESSION["User_ID"]."',
		tr_status = '2'
		WHERE tr_id = '".$_GET["transfer_id"]."'") or die ("Not Query Database3");
	if($objQuery == true){
		echo "<script>alert('ยกเลิกใบโอนย้าย ".$_GET["transfer_id"]." สำเร็จ');window.location=\"transfer.php?transfer_id=".$_GET["transfer_id"]."\";</script>";
		addLogfile($_SESSION["User_ID"],$_SESSION["User_Level"],"ยกเลิกใบโอนย้าย ".$_GET["transfer_id"]);
	}
	else{
		echo "<script>alert('ยกเลิกใบโอนย้าย ".$_GET["transfer_id"]." ไม่สำเร็จ');window.location=\"transfer.php?transfer_id=".$_GET["transfer_id"]."\";</script>";
	}
}



if($_POST["btnSubmit"]){
	$objQuery = mysql_query("UPDATE transfer SET
		tr_con = now(),
		tr_con_id = '".$_SESSION["User_ID"]."',
		tr_status = '3'
		WHERE tr_id = '".$_GET["transfer_id"]."'") or die ("Not Query Database4");
	if($objQuery == true){
		echo "<script>alert('อนุมัติใบโอนย้าย ".$_GET["transfer_id"]." สำเร็จ');window.location=\"transfer_detail?transfer_id=".$_GET["transfer_id"]."\";</script>";
		addLogfile($_SESSION["User_ID"],$_SESSION["User_Level"],"อนุมัติใบโอนย้าย ".$_GET["transfer_id"]);
	}
	else{
		echo "<script>alert('อนุมัติใบโอนย้าย ".$_GET["transfer_id"]." ไม่สำเร็จ');window.location=\"transfer_detail?transfer_id=".$_GET["transfer_id"]."\";</script>";
	}
}





mysql_close();
?>