</script>
</head>
<body>
<?php
if (!$_SESSION['ip_Log'] and !Check_Online(get_ip())) {
//ch login
echo "<center><h2><font color=red>��ҹ������Է����ҹ˹�ҹ��</font></h2></center>";
session_unregister("ip_Log");
echo "<META HTTP-EQUIV='REFRESH' CONTENT='1; URL=index.php'>";
} else {
$key_word = $_GET['keyword'];
if ($_SESSION['Dcode']) {
$Dcode = $_SESSION['Dcode'];
} else {
$Dcode = cmdDoctor_code($ip_Log);
}
//code doctor
//�ӹǹ��������ѹ������͡
?>
<table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="927"><table width="800" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2" valign="top">
<?php
if (Check_Online(get_ip()) and $Header == "N") {
} else {
include "header.inc";
}
?>
print "<link href='css/{$Theme}.css' rel='stylesheet' type='text/css'>";
?>
</head>
<body>
<?php
if (!$vn and !$hn) {
//ch vn hn
print "<h2>�к��������ö�ѹ�֡������㹰ҹ�������� ���ͧ�ҡ����դ�� HN ��� VN</h2>";
} else {
//ch vn hn
$d_approve = date("Y-m-d");
//date an approve
//SQL Save Approve
$sqlSaveApprove = "UPDATE ovst SET Approve_Doctor = '{$App_Choice}',Comment_Appr ='{$comment}', Date_Appr='{$d_approve}' where vn='{$vn}' ";
//$sqlSaveApprove="UPDATE ovst SET Approve_Doctor = '$App_Choice',Comment_Appr ='$comment', Date_Appr='$d_approve' ";
//$sqlSaveApprov.="WHERE vn = '$vn' and hn='$hn' ";
mysql_query($sqlSaveApprove, $conn) or die("<center><h2>�������ö�ѹ�֡��������</h2>" . mysql_error() . "<br><a href=\"javascript:history.back(-1)\">Back</a>");
//print "<h2>�ѹ�֡���������º��������</h2><br><a href='$PHP_SELF'>����¡���ա����</a>\n";
//if ($success=='Y'){
//print "<html><body bgcolor=red>\n";
print "<h2><center>�ѹ�֡���������º��������</h2></center><br><font color=red>�٢�ͤ������ approve ��� -><a href=\"javascript:history.back(-1)\">���꡷����</a>\n";
print "<br>��Ѻ价����ª��ͼ����·���ͧ��� approve ��� -><a href=\"command_doc.php?Dcode=" . cmdDoctor_code($ip_Log) . "\">���꡷����</a></font>\n";
//print"<META HTTP-EQUIV='REFRESH' CONTENT='20; URL=$PHP_SELF?hn=$hn&vn=$vn&keyword=$hn'>";
//print "</body></html>/n";
//}
//print"<META HTTP-EQUIV='REFRESH' CONTENT='2; URL=$PHP_SELF?hn=$hn&vn=$ovst_vn&keyword=$keyword&submit=HisSearch'>";
}
//ch vn hn
?>
</body>
</html>
print "<input type='hidden' name='vn' value='{$vn}'><input type='hidden' name='hn' value='{$hn}'><input type='hidden' name='action' value='Edit'>\n";
print "<input type='hidden' name='vstdate' value='{$vstdate}'><input type='hidden' name='cmd_doc' value='{$cmd_doc}'>\n";
print "</td></tr>\n";
}
print "</table></form><br>\n";
}
//strat 2
}
//vn,hn,keyword //ch 1
}
//permission 2
//*****************************************************************//
//--------------------End Review and Approe-----------------------//
//*****************************************************************//
//*********************Start Edit ****************************//
if ($permission or ($rsDoctor_ovst['command_doctor'] == cmdDoctor_code($ip_Log) or $rsDoctor_ovst['doctor'] == cmdDoctor_code($ip_Log)) and $action == "Edit") {
//permission 3
//echo $vn.$cmd_doc;
//sql edit approve
$sql = "select * from approve_doctor where vn='{$vn}' and command_doctor='{$cmd_doc}' ";
$result = ResultDB($sql);
if (mysql_num_rows($result) > 0) {
//row
$rs = mysql_fetch_array($result);
//echo $rs['vn'].$rs['hn']
$vstdate = $rs['vstdate'];
$cmd_doc = $rs['command_doctor'];
echo "<b>��䢡�� Approve</b> ����Ǩ : <font color=red>{$get_nDoctor}</font> �Ѻ����觨ҡ <font color=red>" . cmdDoctor($vn) . "</font>";
print "<form name='f_SendApprove' action='{$PHP_SELF}?#below' method='get'>";
print "<br><table width='360' border='0' cellpadding='0' cellspacing='3' bgcolor='#FFFF99' class='bd-external'>\n";
print "<tr bgcolor='#FFFF00'><td colspan='2'> <b>Approve �����ª��� <font color='#0066FF'>{$n_app['0']} [ HN: {$hn} ]</font></b></td></tr>\n";
