$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) != "") {