$vn = $_GET['vn'];
$hn = $_GET['hn'];
if ($hn == "") {
$sql_hn = "select hn from an_stat where vn='{$vn}' ";
$result_hn = mysql_db_query($DBName, $sql_hn) or die("�������ö���͡���������ʴ���" . mysql_error());
$rs_hn = mysql_fetch_array($result_hn);
$hn = $rs_hn["hn"];
}
//end hn
//an
$sql_an = "select an from ipt where vn='{$vn}' ";
$result_an = mysql_db_query($DBName, $sql_an) or die("�������ö���͡���������ʴ���" . mysql_error());
$rs_an = mysql_fetch_array($result_an);
$an = $rs_an["an"];
//end an
$get_Name_Addr = Serch_datafrom_hn($hn);
$pmr = explode("|", $get_Name_Addr);
//�¡��ҵ���÷���Ѻ�Ҩҡ fuc ���� |
$p_name = $pmr[0];
// p[1] ����
$p_addr = $pmr[1];
// p[2] �������
$get_Age = Age_hn($hn, $vn);
//����
$Card_No = Card_No($hn);
//�����Ţ�ѵû�ЪҪ�
?>
<a name="top"></a>
<table width="800" border="0" cellspacing="0" cellpadding="0" id="table">
<tr>
<td width="927"><table width="800" cellpadding="0" cellspacing="0">
?>
</td>
<td width="119" align="center" valign="middle"><?php
echo $rsM_Y["vn"];
$vn = $rsM_Y["vn"];
?>
</td>
<td width="71" align="center" valign="middle"><?php
echo $rsM_Y["hn"];
$hn = $rsM_Y["hn"];
?>
</td>
<td width="172" align="left" valign="middle">
<?php
//echo $rsM_Y["hn"];
$get_Name_Addr = Serch_datafrom_hn($rsM_Y['hn']);
$pmr = explode("|", $get_Name_Addr);
$keyword = $pmr[0];
//�¡��ҵ���÷���Ѻ�Ҩҡ fuc ���� | ���͵Ѵ��������
print "<a href='patient_medication_record.php?vn={$vn}&hn={$hn}&keyword={$keyword}&submit=Edit'>{$keyword}</a>";
?>
</td>
<td width="131" align="center"><?php
if ($rsM_Y['approve_doctor'] == 'Y') {
echo "<font color=green>" . $rsM_Y['approve_doctor'] . "</font>";
} else {
echo "<font color=red>" . $rsM_Y['approve_doctor'] . "</font>";
}
?>
</td>
<td width="131" align="left"><?php
}
?>
<!-- end ʶҹ�Ҿ�Ѩ�غѹ --> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="2" align="center">
<?php
//*****************************************************************//
//--------------------Start Review and Approe-----------------------//
//*****************************************************************//
$n_Approve = Serch_datafrom_hn($hn);
$n_app = explode("|", $n_Approve);
//�¡��ҵ���÷���Ѻ�Ҩҡ fuc ���� | ���͵Ѵ��������
//echo $n_app[0].$n_app[1];
$Dcode = cmdDoctor_code($_SESSION['ip_Log']);
//$sqlCommandDoc="select * from ovst where vn='$vn' and (Approve_Doctor ='' or Approve_Doctor is NULL)"; //sql Appove
$sqlCommandDoc = "select * from ovst where vn='{$vn}' and command_doctor='{$Dcode}' and (vstdate >'2005-10-01') ";
//sql Appove
$sqlCommandDoc2 = "select * from approve_doctor where vn='{$vn}' and (vstdate >'2005-10-01') ";
//sql Review and Edit
$sqlDoctor_ovst = "select * from ovst where vn='{$vn}' ";
$resultDoctor_ovst = ResultDB($sqlDoctor_ovst);
$rsDoctor_ovst = mysql_fetch_array($resultDoctor_ovst);
//$permission="admin"
//***********************start Approve**************************//
if ($submit == "Approve" and cmdDoctor($vn) != "") {
