document.getElementById('slip_detail').style.display = 'none';
document.getElementById('drug_inject_amount').style.display = '';
document.getElementById('drug_inject_time').style.display = '';
document.getElementById('drug_inject_slip').style.display = '';
document.getElementById('drug_inject_type').style.display = '';
document.getElementById('drug_inject_etc').style.display = '';
document.getElementById('drug_inject_amount2').style.display = 'none';
document.form1.drug_inject_amount.value = '",jschars($_SESSION["list_drug_inject_amount"][$i]),"';
document.form1.drug_inject_unit.value = '",jschars($_SESSION["list_drug_inject_unit"][$i]),"';
document.form1.drug_inject_amount2.value = '",jschars($_SESSION["list_drug_inject_amount2"][$i]),"';
document.form1.drug_inject_unit2.value = '",jschars($_SESSION["list_drug_inject_unit2"][$i]),"';
document.form1.drug_inject_time.value = '",jschars($_SESSION["list_drug_inject_time"][$i]),"';
document.form1.drug_inject_slip.value = '",jschars($_SESSION["list_drug_inject_slip"][$i]),"';
document.form1.drug_inject_type.value = '",jschars($_SESSION["list_drug_inject_type"][$i]),"';
document.form1.drug_inject_etc.value = '",jschars($_SESSION["list_drug_inject_etc"][$i]),"';
if(document.form1.drug_inject_slip.value=='2ins'){
document.getElementById('drug_inject_amount2').style.display = '';
document.getElementById('drug_inject_time').style.display = 'none';
document.getElementById('drug_inject_type').style.display = 'none';
}
}else{
document.getElementById('slip_detail').style.display = '';
document.getElementById('drug_inject_amount').style.display = 'none';
document.getElementById('drug_inject_amount2').style.display = 'none';
document.getElementById('drug_inject_time').style.display = 'none';
document.getElementById('drug_inject_slip').style.display = 'none';
document.getElementById('drug_inject_type').style.display = 'none';
document.getElementById('drug_inject_etc').style.display = 'none';
$sql = "INSERT INTO `appoint_lab` ( `id` , `code` ) VALUES ";
$list = array();
for ($n = 0; $n < $count; $n++) {
if (!empty($_SESSION["list_code"][$n])) {
$q = "('" . $idno . "', '" . $_SESSION["list_code"][$n] . "') ";
array_push($list, $q);
}
}
$sql .= implode(", ", $list);
$result = Mysql_Query($sql) or die("Error appoint_lab " . Mysql_Error());
$patho = implode(", ", $_SESSION["list_code"]);
}
$pathoall = $patho . ' ' . $patho2;
$sqltel = "update opcard SET phone='" . $_POST['telp'] . "' where hn='" . $cHn . "'";
$result = mysql_query($sqltel);
$sql = "INSERT INTO appoint(date,officer,hn,ptname,age,doctor,appdate,apptime,room,\ndetail,detail2,advice,patho,xray,other,depcode,labextra)\n\n\tVALUES('{$Thidate}','{$sOfficer}','{$cHn}','{$cPtname}','{$cAge}','{$cdoctor}','{$appd}','{$capptime}',\n\n\t'{$room}','{$detail}','" . jschars($detail2) . "','{$advice}','{$pathoall}','{$xrayall}','" . jschars($other) . "','{$depcode}','" . jschars($labm) . "');";
$result = mysql_query($sql);
$idno = mysql_insert_id();
$count = count($_SESSION["list_code"]);
if ($count > 0) {
$sql = "INSERT INTO `appoint_lab` ( `id` , `code` ) VALUES ";
$list = array();
for ($n = 0; $n < $count; $n++) {
if (!empty($_SESSION["list_code"][$n])) {
$q = "('" . $idno . "', '" . $_SESSION["list_code"][$n] . "') ";
array_push($list, $q);
}
}
$sql .= implode(", ", $list);
$result = Mysql_Query($sql) or die("Error appoint_lab " . Mysql_Error());
$patho = implode(", ", $_SESSION["list_code"]);
{
echo "<pre>";
print_r($str);
echo "</pre>";
}
// ¤é¹ËÒª×èÍÂÒ
if (isset($_GET["action"]) && $_GET["action"] == "drugcode") {
include "connect.inc";
$sql = "Select drugcode,tradname,genname from druglst where drugcode like '%" . $_GET["search1"] . "%' limit 10 ";
$result = Mysql_Query($sql) or die(Mysql_error());
if (Mysql_num_rows($result) > 0) {
echo "<Div style=\"position: absolute;text-align: center; width:500px; height:430px; overflow:auto; \">";
echo "<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#FF99CC\"><tr align=\"center\" bgcolor=\"#333333\"><td ><strong> </strong></td><td ><font style=\"color: #FFFFFF;\"><strong>ÃËÑÊÂÒ</strong></font></td><td ><font style=\"color: #FFFFFF;\"><strong>ª×èÍÂÒ(¡ÒäéÒ)</strong></font></td><td ><strong> <A HREF=\"#\" onclick=\"document.getElementById('list').innerHTML='';\"><font style=\"color: #FFFF99;\">»Ô´</font></A></strong></td></tr>";
$i = 1;
while ($se = Mysql_fetch_assoc($result)) {
echo "<tr><td valign=\"top\"></td><td><A HREF=\"javascript:void(0);\" Onclick=\"document.getElementById('" . $_GET["getto"] . "').value = '", jschars($se["drugcode"]), "';document.getElementById('txt1').value = '", jschars($se["tradname"]), "';document.getElementById('txt2').value = '", jschars($se["genname"]), "';document.getElementById('list').innerHTML ='';\">", $se["drugcode"], "</A></td><td>" . $se['tradname'] . "</td><td> </td></tr>";
}
echo "</TABLE></Div>";
}
exit;
}
if (isset($_POST['ok'])) {
$sel = "SELECT * \n\tFROM `druglst` \n\tWHERE `drugcode` = '" . $_POST['drugcode'] . "' ";
$row = mysql_query($sel) or die(mysql_error());
$result = mysql_fetch_array($row);
// if($result['usercontrol']==""){
$sql1 = "UPDATE `druglst` SET \n `usercontrol` = '" . $_SESSION['sOfficer'] . "',\n `min` = '" . $_POST['min'] . "',\n `max` = '" . $_POST['max'] . "' \n WHERE `drugcode` = '" . $_POST['drugcode'] . "'";
$query1 = mysql_query($sql1) or die(mysql_error());
// à¡çº log àÍÒäÇé´éÇÂÇèÒã¤Ãá¡éÍÐäÃ仺éÒ§
$date_now = date('Y-m-d H:i:s');
$sql = "INSERT INTO `smdb`.`drug_control_log` (\n\t\t`id` ,`author` ,`min` ,`max` ,`drugcode` ,`date_add`\n\t)\n\tVALUES (\n\t\tNULL , '" . $_SESSION['sOfficer'] . "', '" . $_POST['min'] . "', '" . $_POST['max'] . "', '" . $_POST['drugcode'] . "', '{$date_now}'\n\t);";
$result = mysql_query($sql);
if (mysql_num_rows($result) > 0) {
echo "<Div style=\"position: absolute;text-align: left; width:600px; height:300px; overflow:auto; \">";
echo "<TABLE border=\"1\" bordercolor=\"#336600\" cellpadding=\"0\" cellspacing=\"0\" width='100%'>\n\t\t<TR >\n\t\t\t<TD>\n\t\t<table bgcolor=\"#FFFFCC\" width=\"100%\" border=\"0\" cellpadding=\"2\" cellspacing=\"0\">\n\t\t\t<tr align=\"center\" bgcolor=\"#336600\">\n\t\t\t<td width=\"120\"><font style=\"color: #FFFFFF\"><strong>àÅ×Í¡</strong>\n\t\t\t\t<td width=\"120\"><font style=\"color: #FFFFFF\"><strong>ICD9CM</strong></font></td>\n\t\t\t\t<td ><font style=\"color: #FFFFFF\"><strong>Diag</strong></font></td>\n\t\t\t\t<td width=\"50\" bgcolor=\"#FF0000\"><font style=\"color: #000000\"><strong><A HREF=\"javascript:void(0);\" Onclick=\"document.getElementById('list1').innerHTML ='';\">Close</A></strong></font></td>\n\t\t\t\t<td></td>\n\t\t\t</tr>";
if (isset($_GET['num'])) {
$getto2 = "icd9cmdetaila" . $_GET['num'];
$getto = "icd9cma" . $_GET['num'];
}
$i = 1;
while ($arr = mysql_fetch_assoc($result)) {
if ($i % 2 == 0) {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#FFFFCC";
}
echo "<tr bgcolor=\"{$bgcolor}\" class='font3'><td><INPUT id='choice2' TYPE=\"radio\" NAME=\"choice2\" onkeypress=\"if(event.keyCode==13){ \n\t\t\tdocument.getElementById('" . $getto . "').value = '" . $arr["code"] . "';\n\t\t\tdocument.getElementById('" . $getto2 . "').value = '", jschars($arr["detail"]), "';\n\t\t\tdocument.getElementById('list1').innerHTML =''; } \" \n\t\t\tondblclick=\"document.getElementById('" . $getto . "').value = '" . $arr["code"] . "';\n\t\t\tdocument.getElementById('" . $getto2 . "').value = '", jschars($arr["detail"]), "';\n\t\t\tdocument.getElementById('list1').innerHTML ='';\"></td><td>" . $arr["code"] . "</td>\n\t\t\t\t\t<td align=\"center\"><A HREF=\"javascript:void(0);\" \n\t\t\t\t\tOnclick=\"document.getElementById('" . $getto . "').value = '" . $arr["code"] . "';\n\t\t\t\t\tdocument.getElementById('" . $getto2 . "').value = '", jschars($arr["detail"]), "';\n\t\t\t\t\tdocument.getElementById('list1').innerHTML ='';\">" . $arr["detail"] . "</A></td></tr>";
$i++;
}
echo "</TABLE></TD>\n\t\t</TR>\n\t\t</TABLE></Div>";
}
exit;
}
?>
<script type="text/javascript">
function newXmlHttp(){
var xmlhttp = false;
try{
xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
}catch(e){
?>
<TABLE id="bock_lab" width="100%" border="1" bordercolor='#000000' cellpadding="3" cellspacing="0" style="display:none;">
<TR valign="top">
<TD width="500">
<CENTER><B>��¡�õ�Ǩ�ҧ��Ҹ�</B></CENTER>
<TABLE width="100%" align="left" border="0">
<TR valign="top">
<TD colspan="<?php echo $r*2;?>" align='left' >��ǨLAB ���� �к� : <INPUT TYPE="text" NAME="" size="13" onKeyPress="searchSuggest('lab',this.value,2);"><Div id="list"></Div></TD>
</TR>
<TR>
<?php
for($i=1;$i<=$count;$i++){
echo "<TD valign='top'><A HREF=\"javascript:void(0);\" onclick=\"addtolist('".jschars($list_lab_check[$i-1]["code"])."');\" >".jschars($list_lab_check[$i-1]["detail"])."</A></TD>";
if($i%$r==0)
echo "</TR><TR>";
}
?>
</TR>
<TR>
<TD colspan="<?php echo $r*2;?>">
<?php
/*$sql = "Select code, detail From labcare where left(code,3) ='DR@' ";
$result = Mysql_Query($sql);
if(Mysql_num_rows($result) > 0){
echo "�ٵ� LAB<BR>";
while($arr = Mysql_fetch_assoc($result)){
$i=0;
<input type="text" name="drugcode" size="10"></font>
<input type="submit" value=" ��ŧ " name="B1">
<a target=_top href="../nindex.htm"><< �����</a></font></p>
</form>
<table width="500">
<tr>
<th bgcolor=CC9900><font face='Angsana New'>����</th>
<th bgcolor=CC9900><font face='Angsana New'>������</th>
<th bgcolor=CC9900><font face='Angsana New'>�ӹǹ㹤�ѧ</th>
<th bgcolor=CC9900><font face='Angsana New'>�ӹǹ���ͧ����</th>
<th bgcolor=CC9900><font face='Angsana New'>����ط��</th>
<th bgcolor=CC9900><font face='Angsana New'> </th>
</tr>
<?php
if (!empty($drugcode)) {
$query = "SELECT drugcode, tradname, stock, oldstock ,mainstk,totalstk FROM druglst WHERE drugcode like '" . $_POST["drugcode"] . "%' ";
$result = mysql_query($query) or die("Query failed");
while (list($drugcode, $trandname, $stock, $oldstock, $mainstk, $totalstk) = mysql_fetch_row($result)) {
if ($oldstock == 0) {
$oldstock = $stock;
}
print " <FORM METHOD=POST ACTION=\"{$PHP_SELF}\">\n <tr>\n" . " <td BGCOLOR=#FFCC99><font face='Angsana New'>{$drugcode}</td>\n" . " <td BGCOLOR=#FFCC99><font face='Angsana New'>{$trandname}</td>\n" . " <td BGCOLOR=#FFCC99><font face='Angsana New'>{$mainstk}</td>\n" . " <td BGCOLOR=#FFCC99><INPUT TYPE=\"text\" NAME=\"stock\" value=\"{$stock}\"></td>\n" . " <td BGCOLOR=#FFCC99><font face='Angsana New'>{$totalstk}</td>\n" . " <td BGCOLOR=#FFCC99><INPUT TYPE=\"submit\" name=\"editstock\" value=\" ��� \"></td>\n" . " </tr>\n\t\t <INPUT TYPE=\"hidden\" name=\"drugcode\" value=\"" . jschars($drugcode) . "\">\n\t\t <INPUT TYPE=\"hidden\" name=\"mainstk\" value=\"" . $mainstk . "\">\n\t\t <INPUT TYPE=\"hidden\" name=\"tradname\" value=\"" . jschars($trandname) . "\">\n\t\t\t<INPUT TYPE=\"hidden\" name=\"oldstock\" value=\"" . $oldstock . "\">\n </FORM>\n\t\t\t\n\t\t \n";
}
}
include "unconnect.inc";
?>
</table>
</TD>
</TR>
<TR>
<TD>
<TABLE align="left" border="0">
<TR valign="top">
<TD colspan="<?php echo $r*2;?>" align='left' >µÃǨLAB Í×è¹æ ÃÐºØ : <INPUT TYPE="text" NAME="" size="13" onKeyPress="searchSuggest('lab',this.value,2);"><Div id="list"></Div></TD>
</TR>
<TR>
<?php
for($i=1;$i<=$count;$i++){
echo "<TD align='right' >";
echo "<INPUT TYPE=\"checkbox\" NAME=\"\" id=\"".jschars($list_lab_check[$i-1]["code"])."\" onclick=\"addbycheck(this.checked, '".jschars($list_lab_check[$i-1]["code"])."');\">";
echo "</TD>";
echo "<TD>".jschars($list_lab_check[$i-1]["detail"])."</TD>";
if($i%$r==0)
echo "</TR><TR>";
}
?>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
<TD valign="top" align="center">
<TABLE width="100%" border="1" bordercolor="#3366FF">
<TR>
<TD align="center" bgcolor="#3366FF" class="font_title" colspan ="8">
{
$str = str_replace("\\\\", "\\\\", $str);
$str = str_replace("\"", "\\\"", $str);
$str = str_replace("'", "\'", $str);
$str = str_replace("\r\n", "\\n", $str);
$str = str_replace("\r", "\\n", $str);
$str = str_replace("\n", "\\n", $str);
$str = str_replace("\t", "\\t", $str);
$str = str_replace("<", "\\x3C", $str); // for inclusion in HTML
$str = str_replace(">", "\\x3E", $str);
return $str;
}
$diag=jschars($_POST['diag']);
$diag1=jschars($_POST['diag1']);
$addfood=jschars($_POST['addfood']);
$repadmit=$_POST['rep'];
if($repadmit=="other"){
$hospital=$_POST['hosother'];
}else{
$hospital="";
}
if($_REQUEST['do']=='first'){
$sql = "UPDATE ipcard SET date='$cAdmitd',
ptname='$cPtname',
age='$cAge',
ptright='$cPtright',
goup='$cGoup',
camp='$cCamp',
bedcode='$Bcode',
mysql_query($sql);
}
$sql2 = "select code,status,detail,diag_thai,diag_eng from icdthai where code='" . $_SESSION["dt_icd10"] . "' ";
$result = mysql_query($sql2);
list($code, $status, $detail, $thai, $eng) = mysql_fetch_array($result);
$sql = "Update opday set history='" . $_SESSION["dt_diag_detail"] . "' , diag='" . jschars($_SESSION["dt_diag"]) . "', diag_eng='" . $detail . "', diag_thai='" . $thai . "', icd10 = '" . $_SESSION["dt_icd10"] . "' , `diag_morbidity` = '" . $_SESSION["dt_diag_morbidity"] . "', `diag_complication` = '" . $_SESSION["dt_diag_complication"] . "', `diag_other` = '" . $_SESSION["dt_diag_other"] . "',`external_cause` = '" . $_SESSION["dt_diag_external"] . "',`icd101` = '" . $_SESSION["dt_icd10_morbidity"] . "', `icd10_complication` = '" . $_SESSION["dt_icd10_complication"] . "',`icd10_other` = '" . $_SESSION["dt_icd10_other"] . "', `icd10_external_cause` = '" . $_SESSION["dt_icd10_external"] . "' where thdatevn = '" . date("d-m-") . (date("Y") + 543) . $_SESSION["vn_now"] . "' limit 1";
$result = Mysql_Query($sql);
$sql = "Update dxofyear set dx='" . $_SESSION["dt_diag_detail"] . "' where thdatevn = '" . (date("Y") . date("-m-d")) . $_SESSION["vn_now"] . "' limit 1";
$result = Mysql_Query($sql);
//$sql = "Update opd set organ='".$_SESSION["dt_diag_detail"]."' where thdatehn = '".date("d-m-").(date("Y")+543).$_SESSION["hn_now"]."' limit 1";
//$result = Mysql_Query($sql);
/*$sql = "Update diag set diag='".$_SESSION["dt_diag"]."',icd10='".$_SESSION["dt_icd10"]."' where regisdate like '".(date("Y")+543).date("-m-d")."%' and hn='".$_SESSION["hn_now"]."' and office = '".$_SESSION["dt_doctor"]."' and type='PRINCIPLE' limit 1";
//echo $sql;
$result = Mysql_Query($sql);
$sum =mysql_affected_rows();
if($sum==0){*/
$sql = "insert into diag (regisdate,hn,an,diag,icd10,type,office,diag_thai,svdate,status) values('" . (date("Y") + 543) . date("-m-d H:i:s") . "','" . $_SESSION["hn_now"] . "','" . $_SESSION["vn_now"] . "','" . jschars($_POST['dt_diag']) . "','" . $_POST['dt_icd10'] . "','PRINCIPLE','" . $_SESSION["dt_doctor"] . "','" . $thai . "','" . (date("Y") + 543) . date("-m-d H:i:s") . "','Y') ";
$result1 = mysql_query($sql);
// }
for ($k = 0; $k < 16; $k++) {
if ($_POST['dt_diag_morbidity' . $k] != "") {
$sql = "insert into diag (regisdate,hn,an,diag,icd10,type,office,svdate,status) values('" . (date("Y") + 543) . date("-m-d H:i:s") . "','" . $_SESSION["hn_now"] . "','" . $_SESSION["vn_now"] . "','" . jschars($_POST['dt_diag_morbidity' . $k]) . "','" . $_POST['dt_icd10_morbidity' . $k] . "','CO-MORBIDITY','" . $_SESSION["dt_doctor"] . "','" . (date("Y") + 543) . date("-m-d H:i:s") . "','Y') ";
$result = mysql_query($sql);
}
}
if ($result) {
echo "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"0;URL=dt_drug.php\">";
} else {
echo "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"0;URL=dt_diag.php\">";
}
include "unconnect.inc";
while($arr = mysql_fetch_assoc($result)){
if($i%2==0)
$bgcolor="#FFFF99";
else
$bgcolor="#FFFFFF";
?>
<tr bgcolor="<?php echo $bgcolor;?>">
<td width="45" align="center">
<?php $i++; $j++;?><INPUT TYPE="checkbox" NAME="rediag<?php echo $i;?>" id="rediag<?php echo $i;?>" >
</td>
<td>
<A HREF="javascript:void(0);" onClick="document.getElementById('dt_diag').value='<?=jschars($arr["diag"])?>';document.getElementById('dt_icd10').value='<?=$arr["icd10"]?>';document.getElementById('head_remed').style.display='none';"><?php echo $arr["diag"];?></A></td>
<td align="center"> <?php echo $arr["icd10"];?>
<input type="hidden" name="code<?=$i?>" value="<?php echo $arr["icd10"];?>">
<input type="hidden" name="detail<?=$i?>" value="<?php echo jschars($arr["diag"]);?>">
<input type="hidden" name="detailthai<?=$i?>" value="<?php echo jschars($arr["diag_thai"]);?>"></td>
<td align="center" ><?php echo $arr["type"];?></td>
<td align="center" ><input type="radio" name="d_princ" value="<?=$i?>" id="d_princ<?=$i?>"></td>
</tr>
<?php }?>
<tr>
<td>
<FONT COLOR="red"><B><A HREF="#" onClick="document.getElementById('head_remed').style.display='none';" style="text-decoration:underline; color:#FF0000;">Close</A></B></FONT>
</td>
<td colspan="3" align="center"><input type="button" name="Submit" value="µ¡Å§" onClick="addtolist_muli();document.getElementById('head_remed').style.display='none';"/></td>
</tr>
<INPUT TYPE="hidden" name="totalcheck" value="<?php echo $i;?>">
</table>
</FORM>
<?
exit();
<td><A HREF="trauma.php?action=edit&id=<?php echo $arr["row_id"];?>" onmouseover= "show_tooltip('<?php echo $hn[$arr["hn"]];?>','center',0,0);" onMouseOut="hid_tooltip();" style="text-decoration:none;"><?php echo $arr["hn"];?></A></td>
<td>
<TABLE>
<TR>
<TD align='right'>DX : </TD>
<TD>
<A HREF="javascript:void(0);" Onclick="document.getElementById('dx').value='<?php echo $arr["dx"];?>';" style="color: #0000FF;text-decoration:none;"><?php echo $arr["dx"];?></A>
</TD>
</TR>
<TR>
<TD align='right'>ÍÒ¡ÒÃ : </TD>
<TD><A HREF="javascript:void(0);" <?php if(strlen($arr["organ"]) > 18){?> Onclick="document.getElementById('organ').value='<?php echo $arr["organ"];?>';" onmouseover= "show_tooltip('<?php echo jschars($arr["organ"]);?>','left',0,0);" onMouseOut="hid_tooltip();" <?php }else{ ?><?php }?> style="color: #0000FF;text-decoration:none;"><?php echo substr($arr["organ"],0,18); if(strlen($arr["organ"]) > 18) echo " ...";?></A></TD>
</TR>
<TR>
<TD align='right'>ÃÑ¡ÉÒ : </TD>
<TD><A HREF="javascript:void(0);" <?php if(strlen($arr["maintenance"]) > 18){?> onmouseover= "show_tooltip('<?php echo jschars($arr["maintenance"]);?>','left',0,0);" onMouseOut="hid_tooltip();" <?php }else{ ?> Onclick="document.getElementById('maintenance').value='<?php echo $arr["maintenance"];?>';" <?php }?> style="color: #0000FF;text-decoration:none;"><?php echo substr($arr["maintenance"],0,18); if(strlen($arr["maintenance"]) > 18) echo " ...";?></A></TD>
</TR>
</TABLE>
</td>
<td><?php echo $arr["type_wounded"],", ",$arr["type_wounded2"];?></td>
<td align="center"><?php if($arr["trauma"]=="nontrauma") echo "non<BR>trauma"; else echo $arr["trauma"];?></td>
<td align="center"><A HREF="#" onClick="if(confirm('·èÒ¹µéͧ¡ÒÃźÃÒ¡ÒùÕéãªéËÃ×ÍäÁè')){ window.location.href='<?php echo $_SERVER['PHP_MYSELF'];?>?action=del&id=<?php echo $arr["row_id"];?>'; }">ź</A><BR><BR><A HREF="consent4.php?id=<?php echo $arr["row_id"]; ?>&hn=<?php echo urlencode($arr["hn"]); ?>&doctor=<?php echo urlencode($arr["doctor"]);?>" target="_blank">ãºÂÔ¹ÂÍÁ</A></td>
</tr>
<?php }?>
</table></td>
</tr>
</table>
<!-- -->
if (isset($_POST['reason' . $countddys])) {
$_SESSION['list_drug_reason'][$i] = $_POST['reason' . $countddys];
}
////à˵ؼÅãËÁè/////
if (substr($_SESSION["list_drug_reason"][$i], 0, 1) == "F") {
$sql = "Select tradname, part, salepri, freepri, unit From druglst_pt where drugcode = '" . $_SESSION["list_drugcode"][$i] . "' limit 1";
$result = Mysql_Query($sql);
list($tradname, $part, $salepri, $freepri, $unit) = Mysql_fetch_row($result);
$pricetype["DDN1"] += $salepri * $_SESSION["list_drugamount"][$i];
//ºÇ¡ÃÒ¤ÒãËÁè
$pricetype["DDY1"] -= $salepri * $_SESSION["list_drugamount"][$i];
//źÃÒ¤Òà¡èÒÍÍ¡
}
}
}
$sql = "INSERT INTO dphardep_pt(chktranx,date,ptname,hn,price,doctor,item,idname,diag,essd,nessdy,nessdn,dpy,dpn,dsy,dsn,tvn,ptright,whokey,kew)VALUES('" . $nRunno . "','" . $Thidate . "','" . $Ptname . "','" . $_SESSION["hn_now"] . "','" . $Netprice . "','" . $_SESSION["dt_doctor"] . "','" . $_POST["totalitem"] . "','" . $_SESSION["sOfficer"] . "','" . jschars($_SESSION["dt_diag"]) . "','" . $pricetype["DDL1"] . "','" . $pricetype["DDY1"] . "','" . $pricetype["DDN1"] . "','" . $pricetype["DPY1"] . "','" . $pricetype["DPN1"] . "','" . $pricetype["DSY1"] . "','" . $pricetype["DSN1"] . "','" . $_SESSION["vn_now"] . "','" . $_SESSION["ptright_now"] . "','DR','" . $kew . "');";
//echo "<!-- ".$sql." -->";
$result = Mysql_Query($sql);
if ($result) {
$insert1 = true;
$idno = mysql_insert_id();
} else {
$insert1 = false;
}
$commar = "";
//$_SESSION["dt_drugstk"] = "<font style=\"font-family:'MS Sans Serif'; font-size:12px\" >   ".$Thidate2."; HN:".$_SESSION["hn_now"].", <br>   ".$_SESSION["yot_now"]." ".$_SESSION["name_now"]." ".$_SESSION["surname_now"]." âä ".$_SESSION["dt_diag"]."<BR>";
if ($_SESSION["dt_drugstk"] != "") {
$_SESSION["dt_drugstk"] .= "<DIV style=\"page-break-after:always\"></DIV>";
}
$_SESSION["dt_drugstk"] .= "<TABLE cellpadding=\"0\" cellspacing=\"0\">\n\t<TR>\n\t\t<TD colspan=\"3\"><font style=\"font-family:'MS Sans Serif'; font-size:12px\" >   " . $Thidate2 . "; HN:" . $_SESSION["hn_now"] . ", <br>   " . $_SESSION["yot_now"] . " " . $_SESSION["name_now"] . " " . $_SESSION["surname_now"] . " âä " . $_SESSION["dt_diag"] . "</TD>\n\t</TR>\n\t";
$_SESSION["dt_drugstk1"] .= "<TABLE cellpadding=\"0\" cellspacing=\"0\">\n\t<TR>\n\t\t<TD colspan=\"3\"><font style=\"font-family:'MS Sans Serif'; font-size:16px\" > ãºÃѺÍØ»¡Ã³ì <br> ãËéä»ÃѺ·ÕèµÖ¡¡ÒÂÀÒ¾<br>  " . $Thidate2 . " <br> HN:" . $_SESSION["hn_now"] . " <br> " . $_SESSION["yot_now"] . " " . $_SESSION["name_now"] . " " . $_SESSION["surname_now"] . " <br> âä " . $_SESSION["dt_diag"] . " <br> ÊÔ·¸Ô " . $_SESSION["ptright_now"] . "</TD>\n\t</TR>\n\t";
$q = mysql_query($sql);
$allergic_list = array();
while ($item = mysql_fetch_assoc($q)) {
$allergic_list[] = $item['drug_code'];
}
$sql = "SELECT TRIM(a.`drugcode`) AS `code`, b.`drug_code` AS `check_code`\nFROM `ddrugrx` AS a \nLEFT JOIN `phar_allergic` AS b ON b.`hn` = a.`hn` AND b.`drug_code` = a.`drugcode`\nWHERE a.`idno` = '{$dphardep_id}'";
$q = mysql_query($sql);
while ($item = mysql_fetch_assoc($q)) {
// ������������ʷ�����ع�ç�������������ŧ� phar_allergic
if (array_search($item['code'], $allergic_list) !== false && empty($item['check_code'])) {
$sql_insert = "INSERT INTO `phar_allergic` (`id` ,`date_save` ,`hn` ,`drug_code`,`phardep_id`)\n\t\tVALUES (\n\t\t\tNULL , '{$date_now}', '{$hn}', '" . $item['code'] . "', '{$idno}'\n\t\t);\n\t\t";
mysql_query($sql_insert);
}
}
//update data in opday
$query = "UPDATE opday SET diag = '" . jschars($cDiag) . "', \ndoctor='{$cDoctor}', \nphar= phar+{$Netprice} \nWHERE thdatehn= '{$Thdhn}' AND vn = '{$tvn}' ";
$result = mysql_query($query) or die("Query failed,update opday");
$query = "UPDATE dphardep set stkcutdate = '" . date("H:i:s") . "' WHERE row_id = '{$sRow_id}' ";
$result = mysql_query($query);
if ($result) {
?>
<script>
window.opener.location.reload();
</script>
<?php
}
include "unconnect.inc";
include "slipprntest1.php";
?>
//************************** áÊ´§ÃÒ¡Òà lab ********************************************************
if (isset($_GET["action"]) && $_GET["action"] == "addtolist") {
$sql = "Select detail, yprice, nprice From labcare where code = '" . $_GET["code"] . "' limit 1; ";
list($detail, $yprice, $nprice) = Mysql_fetch_row(Mysql_Query($sql));
array_push($_SESSION["list_code"], $_GET["code"]);
array_push($_SESSION["list_detail"], $detail);
array_push($_SESSION["list_nprice"], $nprice);
array_push($_SESSION["list_yprice"], $yprice);
exit;
}
if (isset($_GET["action"]) && $_GET["action"] == "viewlablist") {
$i = 0;
$list = "";
echo "<FONT SIZE=\"2\" >";
foreach ($_SESSION["list_code"] as $key => $value) {
echo "<INPUT TYPE=\"hidden\" name=\"list_lab_appoint[]\" value=\"" . jschars($value) . "\"><A HREF=\"javascript:void(0);\" Onclick=\"del_list('" . $value . "');show_listlab();\">" . $_SESSION["list_detail"][$i] . "</A><BR>";
$i++;
$list .= " '" . $value . "',";
}
if ($i > 0) {
$sql = "Select (sum(yprice)+sum(nprice)) as ynprice From labcare where code in (" . substr($list, 0, -1) . ");";
$result = Mysql_Query($sql);
list($ynprice) = Mysql_fetch_row($result);
echo "ÃÒ¤ÒÃÇÁ " . $ynprice . " ºÒ·";
}
echo "</FONT>";
exit;
}
//************************** ź¢éÍÁÙÅÍÍ¡¨Ò¡ÃÒ¡Òà ********************************************************
if (isset($_GET["action"]) && $_GET["action"] == "delete") {
$count = count($_SESSION["list_code"]);
$str = str_replace("\\\\", "\\\\", $str);
$str = str_replace("\"", "\\\"", $str);
$str = str_replace("'", "\\'", $str);
$str = str_replace("\r\n", "\\n", $str);
$str = str_replace("\r", "\\n", $str);
$str = str_replace("\n", "\\n", $str);
$str = str_replace("\t", "\\t", $str);
$str = str_replace("<", "\\x3C", $str); // for inclusion in HTML
$str = str_replace(">", "\\x3E", $str);
return $str;
}
// print "row_id=$sRow_id<br>";
// print "$report<br>";
//update data in patdata
$query ="UPDATE patdata SET copy = 'Y', report='".jschars($report)."'
WHERE row_id='$sRow_id' ";
$result = mysql_query($query)
or die("Query failed,update patdata");
//echo mysql_errno() . ": " . mysql_error(). "\n";
//echo "<br>";
print "HN $sHn<br>";
if (!empty($sAn)){
print "AN $sAn<br>";
}
print "$sPtname<br>";
print "����: $sAge<br>";
if (!empty($sPtright)){
print "�Է�ԡ���ѡ��: $sPtright<br>";
}
// print "�������:$cAddress $cMuang<br>";
<TR valign="top">
<TD width="500">
<TABLE width="100%" align="left" border="0">
<TR valign="top">
<TD colspan="<?php
echo $r * 2;
?>
" align='left' >µÃǨLAB Í×è¹æ ÃÐºØ : <INPUT TYPE="text" NAME="" size="13" onkeypress="searchSuggest('lab',this.value,2);"><Div id="list"></Div></TD>
</TR>
<TR>
<?php
for ($i = 1; $i <= $count; $i++) {
echo "<TD align='right' >";
//echo "<INPUT TYPE=\"checkbox\" NAME=\"\" id=\"".jschars($list_lab_check[$i-1]["code"])."\" >";
echo "</TD>";
echo "<TD><a href ='javascript:void(0);' onclick=\"addbycheck('" . jschars($list_lab_check[$i - 1]["code"]) . "');\" >" . jschars($list_lab_check[$i - 1]["detail"]) . "</a></TD>";
if ($i % $r == 0) {
echo "</TR><TR>";
}
}
?>
</TR>
<TR>
<TD colspan="<?php
echo $r * 2;
?>
">
<?php
$sql = "Select code, detail From labcare where left(code,3) ='DR@' ";
$result = Mysql_Query($sql);
