?> </td> <td align="center"> <?php $result = ResultDB($sqlAllBorn7); $rs = mysql_fetch_array($result); echo $rs['total']; ?> </td> <td align="center"> <?php $result = ResultDB($sqlAllBorn8); $rs = mysql_fetch_array($result); echo $rs['total']; ?> </td> <td align="center"> <?php $result = ResultDB($sqlAllBorn9); $rs = mysql_fetch_array($result); echo $rs['total']; ?> </td> <td> </td> </tr> <td> </td> <td> ¤ÅÍ´»¡µÔ</td> <td align="center"> </td> <td align="center"> </td> <td align="center"> </td> <td align="center"> </td> <td align="center"> </td> <td align="center"> </td> <td align="center"> </td>
<input type="checkbox" name="cause_err17" value="[c17]">17.Å×ÁãËéÂÒ<br> <input type="checkbox" name="cause_err18" value="[c18]">18.äÁèÁÕ¡ÒõÃǨÊͺ«éÓ<br> <input type="checkbox" name="cause_err19" value="[c19]">19.Telephone Order<br> <input type="checkbox" name="cause_err20" value="[c20">20.Í×è¹æ (ÃкØ) <br> <input type="text" name="cause_err20txt" size="40"><br><br> </td> </tr> <tr> <td bgcolor="#CCFF00">ÃдѺ¤ÇÒÁÃعáç :</td> <td colspan="5" bgcolor="#CCFF00"> </td> </tr> <tr align="left" valign="top"> <td colspan="6"> ->> <?php $sqlS_Level = "SELECT * FROM level_err "; $resultS_Level = ResultDB($sqlS_Level); if (mysql_num_rows($resultS_Level) > 0) { //row print "<select name='level_err' id='Txt-Field'>"; for ($i = 0; $i < mysql_num_rows($resultS_Level); $i++) { //for $rsS_Level = mysql_fetch_array($resultS_Level); if (strlen($rsS_Level['detail']) > 105) { $text_len105 = substr($rsS_Level['detail'], 0, 105) . "......"; } else { $text_len105 = $rsS_Level['detail']; } print "<option value='" . $rsS_Level['level_code'] . "' title='" . $text_len105 . "'>" . $rsS_Level['level_code'] . "->" . $text_len105 . "</option>\n"; //print "<option onmouseover=\"this.value='onmouseover fired'\" onmouseout=\"this.value=''\" value='".$rsS_Level['level_code']."' title='".$text_len105."'>".$rsS_Level['level_code']."->".$text_len105."</option>"; //print "<option onmouseover=\"this.value='onmouseover fired'\" onmouseout=\"this.value=''\" value='".$rsS_Level['level_code']."' title='".$rsS_Level['detail']."'>".$rsS_Level['level_code']."->".$text_len105."</option>"; //print "<option onmouseover=\"this.value='onmouseover fired'\" onmouseout=\"this.value=''\" value='".$level_en."' title='".$level_text."'>".$level_en."</option>";
<?php session_start(); header("Content-type:text/html; charset=windows-874"); include "phpconf.php"; include "func.php"; conDB(); $sql = "SELECT hn,concat(pname,fname,' ',lname) as pt_name,birthday FROM patient WHERE hn='{$_REQUEST['hn']}'"; $result_Search = ResultDB($sql); if (mysql_num_rows($result_Search) > 0) { $i = 0; while ($i < mysql_num_rows($result_Search)) { //while $rs_search = mysql_fetch_array($result_Search); echo "<font color='yellow' size='4'><b>"; echo " "; echo $rs_search['pt_name']; echo " "; /* echo "�ѹ�Դ "; echo " "; echo dateThai($rs_search['birthday']); echo "</b></font>"; */ $i++; } } else { echo "<font color='yellow' size='5'><b>"; echo " "; echo "�������ª��ͤ�������к�"; echo "</b></font>";
} </script> </head> <body> <div align="center"> <?php $vn = $_GET["vn"]; $imgnum = $_GET["imgnum"]; if ($imgnum == '') { $imgnum = "1"; } else { $imgnum = $imgnum; } $sqlPe = "select * from pe_image where vn='{$vn}' "; $resultPe = ResultDB($sqlPe); $rsPe = mysql_fetch_array($resultPe); //echo $rsPe['cc']; if (mysql_num_rows($resultPe) > 0) { if ($rsPe["image5"] != "") { $imgall = "5"; } elseif ($rsPe["image4"] != "") { $imgall = "4"; } elseif ($rsPe["image3"] != "") { $imgall = "3"; } elseif ($rsPe["image2"] != "") { $imgall = "2"; } elseif ($rsPe["image1"] != "") { $imgall = "1"; } if ($imgnum - 1 != "0") {
</form> <?php } elseif ($submit_risk == "Done") { //check botton submit //echo "Done->department_id:$department_id ,relation_program :$relation_program �ѹ��� $sdate $smonth $syear<br>"; //echo ",subject :$subject ,detail :$risk_detail ,risk_edit_basic :$risk_edit_basic ,risk_Info_system=$risk_Info_system"; //echo "Login : "******"risk_level_text=$risk_level_text ,risk_level :$risk_level "; //echo $time_current; $date_time_current = $syear . "-" . $smonth . "-" . $sdate . " " . $time_current; //echo $date_time_current; //$risk_level_all=$risk_level." : ".$risk_level_text;//echo $risk_level_all; //check ready //sql check $sqlReadyData = "SELECT * FROM risk_report_web where subject='{$subject}' and risk_detail='{$risk_detail}' and report_user='******' "; $resultReadyData = ResultDB($sqlReadyData); if (mysql_num_rows($resultReadyData) > 0) { //row ready echo "<center><h2>�����Ŵѧ������ա����§ҹ�ҧ�غѵԡ�ó����º��������....���ѡ����</h2></center>"; echo "<META HTTP-EQUIV='REFRESH' CONTENT='1; URL={$PHP_SELF}'>"; } else { //row ready //sql insert risk $sql_Risk_insert = "INSERT INTO risk_report_web(report_date_time,department_id,subject,risk_level,relation_program,risk_detail,report_user, "; //table name in database $sql_Risk_insert .= "review_status,review_date_time,review_staff,review_detail,edit_basic,info_system,respond_level_depart,result_follow,all_date_review) "; $sql_Risk_insert .= "VALUE ('{$date_time_current}','{$department_id}','{$subject}','{$risk_level}','{$relation_program}','{$risk_detail}','{$ip_Log}','N',NULL,NULL,NULL,'{$risk_edit_basic}','{$risk_Info_system}',NULL,NULL,NULL) "; if ($subject != "" and trim($risk_detail) != "") { //data empty mysql_query($sql_Risk_insert) or die("�������ö�ѹ�֡������㹰ҹ��������<br><center><font color=red><h2>�Դ��ͼ������к�</h2></font><br><a href='result_login.php'>˹����ѡ</a></center>" . mysql_error()); echo "<center><h2>�ѹ�֡������㹰ҹ������ ���º��������....���ѡ����</h2></center>";
$m = date("n"); $y = date("Y"); //date in the day ,month 05->m,5->n $date_current = $d . " " . change_month_isThai($m) . " " . ($y + 543); //date cuurent thai $time_current = date(" H:i:s"); //time cuurent //sql form id //echo "risk_id=".$risk_id."subject=".$subject; $sqlDetail = "SELECT m.*,right(r.level_name,length(r.level_name)-2) as n_level,h.name as depart_name,o.name as user_name "; $sqlDetail .= "FROM medication_err m "; $sqlDetail .= "left outer join risk_level r on left(r.level_name,1)=m.level_code "; $sqlDetail .= "left outer join hospital_department h on h.id=m.depart_code "; $sqlDetail .= "left outer join opduser o on o.loginname=m.user_err "; $sqlDetail .= "where m.err_id='{$err_id}' "; $result = ResultDB($sqlDetail); //echo mysql_num_rows($result); $rs = mysql_fetch_array($result); ?> <br> <table width="550" border="0" cellspacing="1" cellpadding="2"> <tr align="center"> <td colspan="4" bgcolor="#319ACE"><span class="headmenu">ÃÒÂÅÐàÍÕ´·Ñé§ËÁ´</span></td> </tr> <tr> <td bgcolor="#319ACE"> id : </td> <td colspan="3" bgcolor="#FFFFCC"> <?php echo $rs['err_id']; ?> </td> </tr>
<table width="700" border="1" align="center" cellpadding="3" cellspacing="3"> <tr> <td colspan="2" align="center" height="25"><font size="4"><b>б╥├и╤┤├╨┤╤║д╟╥┴├╪╣с├зв═з═╪║╤╡╘б╥├╖╤ш╟ф╗ (non - clinic)</b></font></td> </tr> <tr> <td width="100" align="center"><b>д╟╥┴├╪╣с├з</b></td> <td align="left"><b>р╦╡╪б╥├│ь</b></td> </tr> <tr> <?php $sqlS_general_relation = "SELECT * FROM risk_relation_general_program "; $resultS_relation = ResultDB($sqlS_general_relation); if (mysql_num_rows($resultS_relation) > 0) { for ($i = 0; $i < mysql_num_rows($resultS_relation); $i++) { $rsS_relation = mysql_fetch_array($resultS_relation); print "<tr><td align='center'><b>" . $rsS_relation['name'] . "</b></td><td>" . $rsS_relation['description'] . "</td></tr>"; } } ?> </table> <br/> <center><input type="button" value="╗╘┤╦╣щ╥╡ш╥з╣╒щ" onclick="javascript:window.close()"></center>
echo "<tr>"; echo "<td width='63' align='right'>" . ($i + 1) . ".</td>"; echo "<td width=380'>гя╧╥уХарця║ир╬бр╨ре " . thai_date(strtotime($rsOpd_Socail['arrear_date'])) . "</td>"; echo "<td width='150'>╗с╧г╧Ю╖т╧╥уХ╓Ир╖╙сцп</td>"; echo "<td align='right' width='55'>" . number_format(floor($rsOpd_Socail['amount'])) . "</td>"; echo "<td> ╨р╥</td>"; echo "</tr>"; echo "</table>"; $i++; } } //while ?> <?php $sql_sum_price = "select sum(amount) as price from rcpt_arrear where hn='{$hn}' and paid ='N' group by hn"; $resultOpd_Socail_sum = ResultDB($sql_sum_price); $resultOpd_Socail_sum = mysql_fetch_array($resultOpd_Socail_sum); $price = $resultOpd_Socail_sum['price']; ?> </td> </tr> <tr> <td><font face="AngsanaUPC, BrowalliaUPC, CordiaUPC"> </font></td> <td colspan="3"><font size="+2" face="AngsanaUPC, BrowalliaUPC, CordiaUPC"><strong> цгаЮ╩Г╧Ю╖т╧╓Ир╖╙сцп╥яИ╖йтИ╧ <?php echo number_format(floor($resultOpd_Socail_sum['price'])); ?> ╨р╥ (<?php echo num2wordsThai(floor($price)); ?>
<td colspan="2"> <?php //sql create table show $d1 = $sy1 . "-" . $sm1 . "-" . $sd1; $d2 = $sy2 . "-" . $sm2 . "-" . $sd2; //echo $d1."dd".$d2; if ($refer_point != null) { if ($refer_point == 'All') { $sqlSocail_refer_opd = "\r\n\r\nSELECT ri.refer_point,ri.icd10,ic.name as icd_name,count(ri.icd10) AS total_group \r\n\r\nFROM referin ri\r\n\r\nLEFT OUTER JOIN icd101 ic on ic.code = ri.icd10\r\n\r\nWHERE \r\n\tri.refer_date BETWEEN '{$d1}' AND '{$d2}' \r\n\t\r\nGROUP BY ri.icd10 \r\n\r\nORDER BY ri.refer_point"; } else { $sqlSocail_refer_opd = "\r\n\r\nSELECT ri.refer_point,ri.icd10,ic.name as icd_name,count(ri.icd10) AS total_group \r\n\r\nFROM referin ri\r\n\r\nLEFT OUTER JOIN icd101 ic on ic.code = ri.icd10\r\n\r\nWHERE \r\n\tri.refer_point='{$refer_point}' AND\r\n\tri.refer_date BETWEEN '{$d1}' AND '{$d2}'\r\n\t\t\r\nGROUP BY ri.icd10 \r\n\r\nORDER BY ri.refer_point"; } } $resultSocail_refer_opd = ResultDB($sqlSocail_refer_opd); if (mysql_num_rows($resultSocail_refer_opd) > 0) { print "<u><font color='green'><b>áÊ´§¢éÍÁÙŢͧÇѹ·Õè <font color='red'>{$sd1}</font> à´×͹ <font color='red'>" . change_month_isThai($sm1) . "</font> »Õ <font color='red'>" . ($sy1 + 543) . "</font> ¶Ö§Çѹ·Õè <font color='red'>{$sd2}</font> à´×͹ <font color='red'>" . change_month_isThai($sm2) . "</font> »Õ <font color='red'>" . ($sy2 + 543) . "</font>"; print "<br>ÁÕ·Ñé§ËÁ´ " . mysql_num_rows($resultSocail_refer_opd) . " ÃÒ¡ÒÃ</b></font></u>"; //create row ?> <br><br> <table width="700" border="1" cellspacing="0" cellpadding="0" class="bd-external"> <tr> <td height="44" align="center"> <table width="700" border="0" cellpadding="1" cellspacing="1"> <tr class="headtable"> <td width="50" height="21" align="center" background="img_mian/bgcolor2.gif">·Õè</td> <td width="100" align="center" background="img_mian/bgcolor2.gif">á¼¹¡</td> <td width="100" align="center" background="img_mian/bgcolor2.gif">ICD10</td>
?> </td> </tr> <tr> <td> </td> <td align="left"> </td> </tr> </table></td> </tr> </table> <p> </p> </div></td> <td width="148" align="center" valign="top" class="td-right"> <?php $sqlPic = "select count(*) as cc from patient_image where hn='{$hn}' "; $resultPic = ResultDB($sqlPic); $rsPic = mysql_fetch_array($resultPic); if ($rsPic["cc"] > 0) { print "<center>HN : <font color='red' size='4'><b>{$hn}</b></font>"; echo "<a title=¤ÅÔê¡à¾×èÍ´ÙÃÙ»¢ÂÒ href=javascript:popup(\"get_patient_image.php?hn={$hn}\",260,340,0)><img src=\"get_patient_image.php?hn={$hn}\" width=\"120\" height=\"105\" vlign=\"middle\" border=\"1\"></a>"; print "<br><font color='#FFFFFF'>" . $rs['fullname'] . "</font></center>"; } ?> </td> </tr> <tr valign="top"> <td height="16" background="img_mian/bgcolor2.gif" align="center"><font color=white>| <a href="pttype_service.php">¤é¹ËÒãËÁè</a> | <a href="javascript:history.back(-1)">Âé͹¡ÅѺ</a> |</font> </td> <td height="16" background="img_mian/bgcolor2.gif"> </td> </tr>
} else { print "<input name=\"s_mount\" type=\"text\" size=\"12\" value='" . change_month_isThai($s_month) . "' disabled>"; } //name $sqlName = "select * from opduser where loginname='{$s_name}' "; $resultName = ResultDB($sqlName); $rsName = mysql_fetch_array($resultName); $code_log = $rsName['doctorcode']; $name = $rsName['name']; //bank $result_Bank = ResultDB($sqlSelect_User_bank); $rs_Bank = mysql_fetch_array($result_Bank); $bank_no = $rs_Bank['bank']; //old_detail ·Õè¼èÒ¹ÁÒ $sqlDetail_Old = "select * from detail_account where UserID='{$s_name}' order by syear,mouth desc limit 1 "; $resultDetail_Old = ResultDB($sqlDetail_Old); $rsDetail_Old = mysql_fetch_array($resultDetail_Old); ?> »Õ : <input name="t_year" type="text" size="10" value="<?php echo $s_year; ?> " disabled> ÃËÑÊ : <input name="t_UserID" type="text" size="10" value="<?php echo $code_log; ?> " disabled> ºÑªÕàÅ¢·Õè : <input name="t_NoBank_Account" type="text" size="20" value="<?php
<tr align="center"> <td colspan="2"> </td> </tr> <tr align="center"> <td colspan="2"> <?php //sql create table show $d1 = $sy1 . "-" . $sm1 . "-" . $sd1; $d2 = $sy2 . "-" . $sm2 . "-" . $sd2; //echo $d1."dd".$d2; $sql_Socail = "select\r\nro.refer_hospcode, concat(hp.hosptype,' ',hp.name) as refer_hospname,\r\nrp.refer_response_type_name,rt.refer_type_name,ro.department,ro.vn,ro.refer_number,ro.hn,rfp.name as refer_point_name,ro.pre_diagnosis,d.name as doctor_name,ro.refer_number as refer_number,ks.department as department_name,ro.other_text,ro.refer_date,o.vstdate,ro.refer_time,o.vsttime,\r\n\r\nconcat(p.pname,p.fname,' ',p.lname) as ptname, concat(h.hosptype,' ',h.name) as hospname,pe.name as pttype_name,\r\n\r\n r.name as refername, ro.refer_point,ro.pre_diagnosis,ro.pdx as icd,ic.name as icd_name ,o.vstdate\r\n\r\n from referout ro\r\n\r\n\r\n left outer join ovst o on o.vn = ro.vn\r\n left outer join patient p on p.hn=ro.hn\r\n left outer join hospcode h on h.hospcode = ro.hospcode\r\n left outer join rfrcs r on r.rfrcs = ro.rfrcs\r\n left outer join refer_point_list rfp on rfp.name = ro.refer_point \r\n left outer join kskdepartment ks on ks.depcode = ro.depcode\r\n left outer join doctor d on d.code = ro.doctor\r\n left outer join pttype pe on pe.pttype = o.pttype\r\n left outer join icd101 ic on ic.code = ro.pdx\r\n left outer join refer_type rt on rt.refer_type = ro.refer_type\r\n left outer join refer_response_type rp on rp.refer_response_type_id = ro.refer_response_type_id\r\n\r\n\r\n left outer join hospcode hp on hp.hospcode = ro.refer_hospcode\r\n\r\n where ro.department = 'OPD' and ro.refer_date between '{$d1}' and '{$d2}' and ro.refer_type='{$refer_type}' and ro.depcode='{$department_type}'\r\n\r\n\r\n union \r\n \r\n select \r\n ro.refer_hospcode, concat(hp.hosptype,' ',hp.name) as refer_hospname,\r\n rp.refer_response_type_name,rt.refer_type_name,ro.department,ro.vn,ro.refer_number,ro.hn,rfp.name as refer_point_name,ro.pre_diagnosis,d.name as doctor_name,ro.refer_number as refer_number,ks.department as department_name,ro.other_text,ro.refer_date,o.regdate as vstdate,\r\n\r\n ro.refer_time,o.regtime as vsttime,concat(p.pname,p.fname,' ',p.lname) as ptname,\r\n concat(h.hosptype,' ',h.name) as hospname,pe.name as pttype_name, r.name as refername,\r\n ro.refer_point,ro.pre_diagnosis,ro.pdx as icd,ic.name as icd_name,o.regdate as vstdate\r\n\r\n from referout ro\r\n\r\n left outer join ipt o on o.an = ro.vn\r\n left outer join patient p on p.hn=ro.hn\r\n left outer join hospcode h on h.hospcode = ro.hospcode\r\n left outer join rfrcs r on r.rfrcs = ro.rfrcs\r\n left outer join refer_point_list rfp on rfp.name = ro.refer_point \r\n left outer join kskdepartment ks on ks.depcode = ro.depcode\r\n left outer join doctor d on d.code = ro.doctor\r\n left outer join pttype pe on pe.pttype = o.pttype\r\n left outer join icd101 ic on ic.code = ro.pdx\r\n left outer join refer_type rt on rt.refer_type = ro.refer_type\r\n left outer join refer_response_type rp on rp.refer_response_type_id = ro.refer_response_type_id\r\n\r\n left outer join hospcode hp on hp.hospcode = ro.refer_hospcode\r\n\r\n where ro.department = 'IPD' and ro.refer_date between '{$d1}' and '{$d2}' and ro.refer_type='{$refer_type}' and ro.depcode='{$department_type}' "; $result_Socail = ResultDB($sql_Socail); //echo mysql_num_rows($resultDenService); if (mysql_num_rows($result_Socail) > 0) { print "<u><font color='green'><b>áÊ´§¢éÍÁÙŢͧÇѹ·Õè <font color='red'>{$sd1}</font> à´×͹ <font color='red'>" . change_month_isThai($sm1) . "</font> »Õ <font color='red'>" . ($sy1 + 543) . "</font> ¶Ö§Çѹ·Õè <font color='red'>{$sd2}</font> à´×͹ <font color='red'>" . change_month_isThai($sm2) . "</font> »Õ <font color='red'>" . ($sy2 + 543) . "</font>"; print "<br>ÁÕ·Ñé§ËÁ´ " . mysql_num_rows($result_Socail) . " ÃÒ¡ÒÃ</b></font></u>"; //create row ?> <br><br> <table border="1" cellspacing="0" cellpadding="0" class="bd-external"> <tr> <td height="44" align="center"><table width="900" border="0" cellpadding="1" cellspacing="1"> <tr class="headtable"> <td width="20" height="21" align="center" background="img_mian/bgcolor2.gif">No.</td>
print "<td align='center' bgcolor='red'> " . $rs['review_status'] . "</td>"; } print "<td align='left'> " . $rs['review_staff'] . "</td>"; print "</tr>"; } //for } else { //r sql1 print "<p ailgn='center'><font color='#319ACE'><b>áÊ´§ÃÒ¡ÒâͧÇѹ·Õè " . $date_current; print "<h2>äÁèÁÕÃÒ¡ÒÃ</h2></font></p>"; } //r sql1 } elseif ($select_date = "Continue") { //click button //echo "sql2".$sql2; $result = ResultDB($sql2); if (mysql_num_rows($result) > 0) { //r sql1 print "<p align='center'><u><font color='#319ACE'><b>áÊ´§¢éÍÁÙŢͧÇѹ·Õè {$d_calen1['0']} à´×͹ " . change_month_isThai($d_calen1[1]) . " »Õ " . $d_calen1[2] . " ¶Ö§Çѹ·Õè {$d_calen2['0']} à´×͹ " . change_month_isThai($d_calen1[1]) . " »Õ " . $d_calen1[2]; print " ÁÕ·Ñé§ËÁ´ <font color='red'>" . mysql_num_rows($result) . "</font> ÃÒ¡ÒÃ</b></font></u></p>"; for ($i = 0; $i < mysql_num_rows($result); $i++) { $rs = mysql_fetch_array($result); if ($bg == '#FFFFFF') { $bg = "#FFFFCC"; } else { $bg = '#FFFFFF'; } //$subject_send=$rs['subject']; print "<tr bgcolor='{$bg}'>"; print "<td align='center'>" . ($i + 1) . "</td>"; print "<td align='center'> " . $rs['report_date_time'] . "</td>";
<td width="119" align="center" background="img_mian/bgcolor2.gif">�����á��</td> <td width="49" align="center" background="img_mian/bgcolor2.gif">��ԹԤ</td> <td width="110" align="center" background="img_mian/bgcolor2.gif">���ͤ�ԹԤ</td> <td width="210" align="center" background="img_mian/bgcolor2.gif">����ѵԡ�õ�ǨBP</td> </tr> <?php $i = 0; while ($i < mysql_num_rows($resultOpd_Socail)) { //while $rsOpd_Socail = mysql_fetch_array($resultOpd_Socail); $sqlOpd_Socail_details = "select count(o.hn) as hn_num\r\n\t\t\t\t\tfrom ovst o\r\n\r\n\t\t\t\t\tleft outer join clinicmember cl on cl.hn = o.hn\r\n\t\t\t\t\tleft outer join clinic c on c.clinic =cl.clinic\r\n\t\t\t\t\tleft outer join opdscreen oc on oc.vn = o.vn\r\n\t\t\t\t\tleft outer join patient pt on pt.hn = o.hn\r\n\t\t\t\t\twhere cl.clinic = '001' and (oc.bps!='' and oc.bpd!='') and (oc.bps<=130 and oc.bpd<=80) and o.hn='{$rsOpd_Socail['hn_number']}'\r\n\r\n\t\t\t\t\tand o.vstdate between '{$d1}' and '{$d2}'"; $w = 0; $resultOpd_Socail_details = ResultDB($sqlOpd_Socail_details); while ($w < mysql_num_rows($resultOpd_Socail_details)) { $rsOpd_Socail_details = mysql_fetch_array($resultOpd_Socail_details); if ($bg == "#FFFFFF") { //color $bg = "#B1C3D9"; //$bgm=""; } else { $bg = "#FFFFFF"; //$bgm="img_mian/bgcolor.gif"; } //color ?> <tr bgcolor="<?php echo $bg; ?>
<table width="680" border="0" align="center" cellpadding="0" cellspacing="0" class="bdmain"> <tr bgcolor="#99CCFF"> <td height="24" colspan="2" align="center" background="img_mian/bgcolor2.gif" class="flist"> <b>Approve Command Doctor</b></td> </tr> <tr> <td width="286" valign="top"> </td> <td width="332"> </td> </tr> <tr> <td> �س��� <?php $Dcode = $_SESSION['Dcode']; $sqlDcode = "select name from doctor where code='{$Dcode}' "; $resultDcode = ResultDB($sqlDcode); //$resultDcode=mysql_db_query($DBName,$sqlDcode) //or die("�������ö���͡���������ʴ���".mysql_error()); $rsDcode = mysql_fetch_array($resultDcode); echo $_SESSION['ip_Log'] . " <b><font color=red>>></b> " . $rsDcode["name"] . "</font><br>"; ?> </td> <td align="right"> </td> </tr> <tr align="center" valign="bottom"> <td colspan="2"> <?php //#---------------start if (!$submit and $Send_Comment !== "Continue") { //submit done button $sqlList_commandDoc = "select *,MONTH(vstdate) as Month,MONTHNAME(vstdate) as month, (YEAR(vstdate)+543) as year,YEAR(vstdate) as Year,count(*) as total ";
print "," . $rsDisp_err['dispens_err'] . "," . $rsDisp_err['cause'] . "," . $rsDisp_err['level_code'] . "\n"; $i++; } //while } //row order_err } elseif ($med_type_err == "admin_err") { //med_type $sqlAdmin_err = "SELECT err_id,err_date_report,err_date,err_time,detail_err,adminis_err,cause,level_code "; //$sqlMedAll.=",order_process_err,dispens_err,adminis_err,cause,level_code,1) as level_err "; //$sqlPre_err.=",order_process_err,dispens_err,adminis_err,cause,level_code "; $sqlAdmin_err .= "FROM medication_err m "; //$sqlMedAll.="left outer join risk_level r on left(r.level_name,1)=m.level_code "; $sqlAdmin_err .= "where err_date between '{$d1}' and '{$d2}' "; $sqlAdmin_err .= "and adminis_err <>'' order by err_date,err_time desc "; $resultAdmin_err = ResultDB($sqlAdmin_err); //echo mysql_num_rows($resultSocail_anc_opd); if (mysql_num_rows($resultAdmin_err) > 0) { //row admin print "·Õè,Çѹ/à´×͹/»Õ,ÃÒÂÅÐàÍÕ´,Administrator,ÊÒà˵Ø,ÃдѺ\n"; $i = 0; while ($i < mysql_num_rows($resultAdmin_err)) { //while $rsAdmin_err = mysql_fetch_array($resultAdmin_err); print $i + 1 . "," . FormatDate($rsAdmin_err['err_date']) . ","; if (eregi(",", $rsAdmin_err['detail_err'])) { // return true,false print str_replace(",", ".", $rsAdmin_err['detail_err']); } else { print $rsAdmin_err['detail_err']; }
$sqlMedType = "SELECT err_id,err_date_report,err_date,err_time,detail_err,prescrib_err\r\n,order_process_err,dispens_err,adminis_err,cause,left(r.level_name,1) as level_err\r\nFROM medication_err m\r\nleft outer join risk_level r on left(r.level_name,1)=m.level_code\r\nwhere err_date between '{$d1}' and '{$d2}' "; if ($med_type_err == "pre_err") { $sqlMedType .= "and prescrib_err <>'' order by err_date,err_time desc "; $title_err = "Prescribing"; } elseif ($med_type_err == "order_err") { $sqlMedType .= "and order_process_err <>'' order by err_date,err_time desc "; $title_err = "Order Processing"; } elseif ($med_type_err == "disp_err") { $sqlMedType .= "and dispens_err <>'' order by err_date,err_time desc "; $title_err = "Dispensing"; } elseif ($med_type_err == "admin_err") { $sqlMedType .= "and adminis_err <>'' order by err_date desc "; $title_err = "Administration"; } //create tr in table $result = ResultDB($sqlMedType); if (mysql_num_rows($result) > 0) { //r sql2 print "<p align='center'><u><font color='#319ACE'><b>áÊ´§¢éÍÁÙŢͧÇѹ·Õè {$sd1} à´×͹ " . change_month_isThai($sm1) . " »Õ " . ($sy1 + 543) . " ¶Ö§Çѹ·Õè {$sd2} à´×͹ " . change_month_isThai($sm2) . " »Õ " . ($sy2 + 543); print " ÁÕ·Ñé§ËÁ´ <font color='red'>" . mysql_num_rows($result) . "</font>ÃÒ¡ÒÃ</b></font></u></p>"; ?> <table width="750" border="0" cellspacing="1" cellpadding="1" class="bd-external"> <tr align="center" bgcolor="#319ACE"> <td width="41">ÅӴѺ</td> <td width="83">Ç/´/»</td> <td width="339" bgcolor="#319ACE">ÃÒÂÅÐàÍÕ´</td> <td width="117" bgcolor="#319ACE"><?php echo $title_err; ?> </td> <td width="88">ÊÒà˵Ø</td>
<tr align="center" valign="top"> <td colspan="2"> </td> </tr> <tr align="center"> <td colspan="2"> </td> </tr> <tr align="center"> <td colspan="2"> <?php $an_number = $_GET['an']; $sqlIpd_Socail = "SELECT \r\n\t\t\t\t\tipt.an,\r\n\t\t\t\t\tipt.icd10 as icd10,\r\n\t\t\t\t\tic.name as icd_eng,\r\n\t\t\t\t\tic.tname as icd_th\r\n\t\t\t\tFROM\r\n\t\t\t\t\tiptdiag ipt\r\n\t\t\t\tLEFT OUTER JOIN icd101 ic ON ic.code = ipt.icd10\r\n\t\t\t\tWHERE ipt.an=" . $an_number; $resultIpd_Socail = ResultDB($sqlIpd_Socail); //echo mysql_num_rows($resultDenService); if (mysql_num_rows($resultIpd_Socail) > 0) { //create row ?> <table width="900" border="1" cellspacing="0" cellpadding="0" class="bd-external"> <tr> <td height="44" align="center"> <table width="900" border="0" cellpadding="1" cellspacing="1"> <tr class="headtable"> <td height="21" align="center" width="20" background="img_mian/bgcolor2.gif">�ӴѺ���</td>
<tr align="center" valign="top"> <td colspan="2"> </td> </tr> <tr align="center"> <td colspan="2"> </td> </tr> <tr align="center"> <td colspan="2"> <?php //sql create table show $sql = "SELECT\r\n\r\n p.person_id,p.cid,concat(p.pname,p.fname,' ',p.lname) as ptname,p.birthdate\r\n\r\n ,w.vaccine_bcg_date,w.vaccine_hbv1_date,w.vaccine_hbv2_date,w.vaccine_hbv3_date,w.vaccine_dtphb1_date,w.vaccine_opv1_date,w.vaccine_dtphb2_date\r\n ,w.vaccine_opv2_date,w.vaccine_dtphb3_date,w.vaccine_opv3_date,w.vaccine_mmr_date\r\n\r\n ,e.vaccine_dtp4_date,e.vaccine_opv4_date,e.vaccine_je1_date,e.vaccine_je2_date,e.vaccine_je3_date,e.vaccine_dtp5_date,e.vaccine_opv5_date\r\n\r\nFROM\r\n\r\n person p\r\n\r\n\r\nLEFT OUTER JOIN person_wbc w on w.person_id = p.person_id\r\nLEFT OUTER JOIN person_epi e on e.person_id = p.person_id\r\n\r\n\r\nWHERE p.cid='{$cid}' "; $result = ResultDB($sql); //echo mysql_num_rows($result); if (mysql_num_rows($result) > 0) { //create row ?> <br><br> <table width="995" border="1" cellspacing="0" cellpadding="0" class="bd-external"> <tr> <td height="44" align="center"><table width="995" border="1" cellpadding="1" cellspacing="1"> <tr class="headtable"> <td align="center" background="img_mian/bgcolor2.gif">ª×èÍÊ¡ØÅ</td>
</div></td> <td width="67" background="<?php //echo $bgm; ?> "><div align="center"><?php echo $hn_patient; ?> </div></td> <td width="152" background="<?php //echo $bgm; ?> " align="left"> <?php if ($vn == "") { $sqlVn = "select * from ovst where hn='{$hn_patient}' order by vn desc limit 1 "; $resultVn = ResultDB($sqlVn); //$result = mysql_db_query($DBName,$sqlVn) //or die("ДаХйрарц╤Юевм║╒ИмаыеарАйД╢И".mysql_error()); $rsVn = mysql_fetch_array($resultVn); $vn = $rsVn["vn"]; echo "<a href=\"patient_medication_record.php?hn={$hn_patient}&vn={$vn}&keyword={$keyword}\">{$name_patient}</a>"; } else { echo "<a href=\"patient_medication_record.php?hn={$hn_patient}&vn={$vn}&keyword={$keyword}\">{$name_patient}</a>"; } ?> </td> <td width="254" background="<?php //echo $bgm; ?> " align="left"> <?php echo $addr_patient;
$rsDcode = mysql_fetch_array($resultDcode); echo $_SESSION['ip_Log'] . " <b><font color=red>>></b> " . $rsDcode["name"] . "</font><br>"; ?> </td> <td align="left">����������´ �ѧ��� </td> </tr> <tr align="left" valign="bottom"> <td colspan="2" valign="bottom"> <?php //sql doctor command doctor all from Dcode $sqlDoctor_All = "select count(*) as total1 from ovst where (vstdate >'2005-10-01') and command_doctor='{$Dcode}' "; $resultDoctor_All = ResultDB($sqlDoctor_All); $rsDoctor_All = mysql_fetch_array($resultDoctor_All); //find command_doctor='$Dcode' and Approve='' from code in command_doctor in ovst table if ($rsDoctor_All['total1'] > 0) { $sqlApprComplete = "select count(*) as total2 from approve_doctor where command_doctor='{$Dcode}' and (vstdate >'2005-10-01') "; $resultApprComplete = ResultDB($sqlApprComplete); $rsApprComplete = mysql_fetch_array($resultApprComplete); echo " <b><font color=yellow>>></font></b> <font color=black>��¡�ä����ᾷ������� �ӹǹ <b>" . $rsDoctor_All['total1'] . " </b>��¡��</font>"; echo "<br> <b><font color=yellow>>></font></b> <font color=black>��¡�ä����ᾷ���� Approve ���� �ӹǹ <b>" . $rsApprComplete['total2'] . " </b>��¡��</font>"; echo "<br> <b><font color=yellow>>></font></b> <a href=command_doc.php?Dcode={$Dcode}>��¡�ä����ᾷ�����ѧ��� Approve �ӹǹ <b>" . ($rsDoctor_All['total1'] - $rsApprComplete['total2']) . " </b>��¡��</a>"; } else { echo "<center><h2><font color=red>�������¡�÷������Ǣ�ͧ</font></h2></center>"; } ?> </td> </tr> <tr align="center" valign="bottom"> <td valign="bottom"> </td> <td align="left"> </td> </tr> <tr align="center" valign="bottom">
<?php session_start(); include "phpconf.php"; include "func.php"; conDB(); ?> <?php $hn = $_GET['hn']; $vn = $_GET['vn']; $vstdate = $_GET['vstdate']; if ($hn != '' and $vn != '' and $vstdate != '') { $sql = "update opitemrece set qty = 0,paidst='03' where hn='{$hn}' and vn='{$vn}' and vstdate='{$vstdate}' and icode in ('3001375','3007849') limit 2 "; $result = ResultDB($sql); $sql2 = "update opitemrece set paidst='02' where hn='{$hn}' and vn='{$vn}' and vstdate='{$vstdate}' and icode in ('1510003','1000011', '1570010') limit 2 "; $result2 = ResultDB($sql2); if ($result or $result2) { echo "<center><h3>Update Data Complete</h3></center>"; } else { echo "<center><h3>Error: Not Update Data</h3></center>"; } }
</table> <?php } elseif ($submit_review == "ºÑ¹·Ö¡") { //ºÑ¹·Ö¡ $date_current = date("Y-m-d"); //date cuurent $time_current = date("H:i:s"); //time cuurent $date_time = $date_current . " " . $time_current; //echo $review_detail."********".$respond_level_depart."**********".$result_follow."*************".$all_date_total; print "<br><font color='red'><b>*ËÅѧ¨Ò¡·Õè ·º·Ç¹ÃÒ¡ÒÃÍغѵÔàÃÕºÃéÍÂáÅéÇ ¡Ãسҡ´»ØèÁ Refresh</b></font>"; //echo "Save<br>";echo "Subject".$subject." Login ".$ip_Log; //sql Save Update //$sqlData="SELECT * FROM risk_report_web WHERE risk_id='$risk_id' and subject='$subject' "; $sqlData = "SELECT * FROM risk_report_web WHERE risk_id='{$risk_id}' "; $resultData = ResultDB($sqlData); if (mysql_num_rows($resultData) > 0) { //row data $rsData = mysql_fetch_array($resultData); $sqlUpdate = "UPDATE risk_report_web SET review_status='Y',review_date_time='{$date_time}',review_staff='{$ip_Log}', "; $sqlUpdate .= "review_detail='{$review_detail}',respond_level_depart='{$respond_level_depart}',result_follow='{$result_follow}',all_date_review='{$all_date_total}' "; $sqlUpdate .= "WHERE risk_id='{$risk_id}' "; //$sqlUpdate.="WHERE risk_id='$risk_id' and subject='$subject' "; mysql_query($sqlUpdate) or die("äÁèÊÒÁÒöºÑ¹·Ö¡¢éÍÁÙÅã¹°Ò¹¢éÍÁÙÅä´é<br><center><font color=red><h2>µÔ´µèͼÙé´ÙáÅÃкº</h2></font><br><a href='javascript:history.back(-1)'>Âé͹¡ÅѺ</a></center>" . mysql_error()); echo "<center><h2>ºÑ¹·Ö¡¢éÍÁÙÅã¹°Ò¹¢éÍÁÙÅ àÃÕºÃéÍÂáÅéÇ....ÃÍÊÑ¡¤ÃÙè</h2><br></center>"; //echo "<META HTTP-EQUIV='REFRESH' CONTENT='1; URL=$PHP_SELF'>"; //echo "<br>ÁÕ¢éÍÁÙÅ"; } else { echo "¢éÍÁÙÅäÁè¶Ù¡µéͧ"; } //row data
<tr> <td align="center" colspan="4"> <table border="0" width="800"> <tr bgcolor='yellow'> <td><b>�ӴѺ</td> <td width="350"> <b>��¡����</b></td> <td width="150"> <b>strength</b></td> <td width="150"> <b>units</b></td> <td width="150"> <b>����ҳ��è���</b></td> <?php $sql_select = "select o.vn,o.hn,s.name,s.strength,s.units,o.qty as qty,dru.shortlist\r\n\t\t\t\t\t\t\tfrom opitemrece o\r\n\t\t\t\t\t\t\tleft outer join s_drugitems s on s.icode =o.icode\r\n\t\t\t\t\t\t\tleft outer join drugusage dru on dru.drugusage= o.drugusage\r\n\r\n\t\t\t\t\t\t\twhere vstdate='{$_GET['vstdate']}' and o.hn='{$_GET['hn']}' and o.vn='{$_GET['vn']}'"; $result_Socail = ResultDB($sql_select); //echo mysql_num_rows($resultDenService); if (mysql_num_rows($result_Socail) > 0) { $i = 0; while ($i < mysql_num_rows($result_Socail)) { //while $rs_Socail = mysql_fetch_array($result_Socail); if ($bg == "#FFFFFF") { //color $bg = "#B1C3D9"; //$bgm=""; } else { $bg = "#FFFFFF"; //$bgm="img_mian/bgcolor.gif"; } //
print " �� "; print "<select name='sm2' id='Txt-Field'>"; if ($sm2 != "") { print "<option value='{$sm2}'>" . change_month_isThai($sm2) . "</option>"; } for ($i = 1; $i <= 12; $i++) { print "<option value='{$i}'>" . change_month_isThai($i) . "</option>"; } print "</select>"; ?> </td> <td> <?php print " �� "; $sqlSyear = "select DISTINCT YEAR(vstdate) as s_year from dtmain group by vstdate desc "; $result = ResultDB($sqlSyear); //echo mysql_num_rows($result); print "<select name='sy2' id='Txt-Field'>"; if ($sy2 != "") { print "<option value='{$sy2}'>" . ($sy2 + 543) . "</option>"; } if (mysql_num_rows($result) > 0) { for ($i = 0; $i < mysql_num_rows($result); $i++) { $rs = mysql_fetch_array($result); print "<option value='" . $rs['s_year'] . "'>" . ($rs['s_year'] + 543) . "</option>"; } } print "</select> <input type='submit' value='Continue' id='Button'>"; ?> </td> </tr>
<tr align="center"> <td colspan="2"> </td> </tr> <tr> <td> </td> <td> </td> </tr> </table><br><br><br><br> <?php } elseif ($sUser_access == "ºÑ¹·Ö¡") { //ch press button save $Slogin = $_GET['slogin']; //echo $Slogin; //chec user in database $sql_ch_user = "******"; $result_ch_user = ResultDB($sql_ch_user); if (mysql_num_rows($result_ch_user) > 0) { //yes user //ch user print "<br><br><center><h2>" . $Slogin . "...¡Ó˹´ÊÔ·¸ÔäÇéáÅéÇ...</h2>á¡éä¢</center><br>"; //echo "<META HTTP-EQUIV='REFRESH' CONTENT='1; URL=result_chlogin.php'>"; print "<p align=center><input type='submit' value='»Ô´Ë¹éÒµèÒ§' id='Button' onClick='javascript:window.close();'> <input type='submit' value='Âé͹¡ÅѺ' id='Button' onClick='goHist(-1);'><br><br>"; //print"Development By <b>Guprajag</b> CopyRight © 04-2006 <b>IM Team Mayo Hospital.</b>All right reserved</p>"; } else { //no user if ($_GET['all_access'] !== 'ALL') { //all access if (isset($_GET['hos_depart1'])) { $_Depart1 = "x" . $_GET['hos_depart1'] . "x,"; } if (isset($_GET['hos_depart2'])) { $_Depart2 = "x" . $_GET['hos_depart2'] . "x,";
<tr align="center"> <td colspan="2"> </td> </tr> <tr align="center"> <td colspan="2"> <?php //sql create table show $d1 = $sy1 . "-" . $sm1 . "-" . $sd1; $d2 = $sy2 . "-" . $sm2 . "-" . $sd2; //echo $d1."dd".$d2; $sqlOpd_Socail = "SELECT\r\n\tv.vn,v.hn,v.cid,\r\n\tconcat(p.pname,p.fname,' ',p.lname) as patient_name ,\r\n\tv.pttype,v.vstdate \r\nFROM \r\n\tvn_stat v\r\nLEFT OUTER JOIN patient p ON p.hn = v.hn\r\nWHERE \r\n\tv.pttype in ('89','52','56') \r\nAND \r\n\tv.vstdate between '{$d1}' and '{$d2}' "; $resultOpd_Socail = ResultDB($sqlOpd_Socail); //echo mysql_num_rows($resultDenService); if (mysql_num_rows($resultOpd_Socail) > 0) { print "<u><font color='green'><b>áÊ´§¢éÍÁÙŢͧÇѹ·Õè <font color='red'>{$sd1}</font> à´×͹ <font color='red'>" . change_month_isThai($sm1) . "</font> »Õ <font color='red'>" . ($sy1 + 543) . "</font> ¶Ö§Çѹ·Õè <font color='red'>{$sd2}</font> à´×͹ <font color='red'>" . change_month_isThai($sm2) . "</font> »Õ <font color='red'>" . ($sy2 + 543) . "</font>"; print "<br><h2>ÁÕ·Ñé§ËÁ´ " . mysql_num_rows($resultOpd_Socail) . " ¤ÃÑé§</h2></b></font></u>"; //create row ?> <br><br> <table width="800" border="1" cellspacing="0" cellpadding="0" class="bd-external"> <tr> <td height="44" align="center"><table width="900" border="0" cellpadding="1" cellspacing="1"> <tr class="headtable"> <td width="20" height="21" align="center" background="img_mian/bgcolor2.gif">·Õè</td> <td align="center" background="img_mian/bgcolor2.gif">VN</td> <td align="center" background="img_mian/bgcolor2.gif">HN</td> <td align="center" background="img_mian/bgcolor2.gif">CID</td>
<?php session_start(); include "phpconf.php"; include "func.php"; conDB(); $err_id = $_GET[err_id]; $detail_err = $_GET[detail_err]; $cmd = "UPDATE medication_err SET detail_err ='{$detail_err}' WHERE err_id='{$err_id}'"; $result = ResultDB($cmd); echo "<center><br /><br /><h2>á¡é䢢éÍÁÙÅÊÓàÃç¨áÅéÇ</h2></center>"; echo "<META http-equiv='refresh' content='1;URL= medicate_err_form_edit.php?err_id={$err_id}'>";
<?php if ($opt == "all") { $sql6 = "SELECT\r\n\t\t\r\n\t(select count(bmi_level) from person_epi_nutrition where \r\n\t nutrition_date BETWEEN '{$d1}' AND '{$d2}' ) as level_all ,\r\n\r\n (select count(bmi_level) from person_epi_nutrition where bmi_level=0 and nutrition_date BETWEEN '{$d1}' AND '{$d2}' ) as level0 ,\r\n\r\n (select count(bmi_level) from person_epi_nutrition where bmi_level=1 and nutrition_date BETWEEN '{$d1}' AND '{$d2}' ) as level1 ,\r\n\r\n (select count(bmi_level) from person_epi_nutrition where bmi_level=2 and nutrition_date BETWEEN '{$d1}' AND '{$d2}' ) as level2 ,\r\n\r\n (select count(bmi_level) from person_epi_nutrition where bmi_level=3 and nutrition_date BETWEEN '{$d1}' AND '{$d2}' ) as level3 ,\r\n\r\n (select count(bmi_level) from person_epi_nutrition where bmi_level=4 and nutrition_date BETWEEN '{$d1}' AND '{$d2}' ) as level4 ,\r\n\r\n (select count(bmi_level) from person_epi_nutrition where bmi_level=5 and nutrition_date BETWEEN '{$d1}' AND '{$d2}' ) as level5 ,\r\n\r\n (select count(bmi_level) from person_epi_nutrition where bmi_level=6 and nutrition_date BETWEEN '{$d1}' AND '{$d2}' ) as level6\r\n\r\n\r\nFROM\r\n person_epi_nutrition\r\n\r\nLIMIT 1"; } else { if ($opt == "0") { $sql6 = "SELECT\r\n\t\t\r\n\t(select count(pw.bmi_level) from person_epi_nutrition pw\r\n\t left outer join person_epi epi on epi.person_epi_id = pw.person_epi_id\r\n\t left outer join person p on p.person_id = epi.person_id\r\n\t where pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and p.village_id =1) as level_all ,\r\n\r\n (select count(pw.bmi_level) from person_epi_nutrition pw\r\n\t left outer join person_epi epi on epi.person_epi_id = pw.person_epi_id\r\n\t left outer join person p on p.person_id = epi.person_id\r\n\t where pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and pw.bmi_level=0 and p.village_id =1) as level0 ,\r\n\r\n (select count(pw.bmi_level) from person_epi_nutrition pw\r\n\t left outer join person_epi epi on epi.person_epi_id = pw.person_epi_id\r\n\t left outer join person p on p.person_id = epi.person_id\r\n\t where pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and pw.bmi_level=1 and p.village_id =1) as level1 ,\r\n\r\n (select count(pw.bmi_level) from person_epi_nutrition pw\r\n\t left outer join person_epi epi on epi.person_epi_id = pw.person_epi_id\r\n\t left outer join person p on p.person_id = epi.person_id\r\n\t where pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and pw.bmi_level=2 and p.village_id =1) as level2 ,\r\n\r\n (select count(pw.bmi_level) from person_epi_nutrition pw\r\n\t left outer join person_epi epi on epi.person_epi_id = pw.person_epi_id\r\n\t left outer join person p on p.person_id = epi.person_id\r\n\t where pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and pw.bmi_level=3 and p.village_id =1) as level3 ,\r\n\r\n (select count(pw.bmi_level) from person_epi_nutrition pw\r\n\t left outer join person_epi epi on epi.person_epi_id = pw.person_epi_id\r\n\t left outer join person p on p.person_id = epi.person_id\r\n\t where pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and pw.bmi_level=4 and p.village_id =1) as level4 ,\r\n\r\n (select count(pw.bmi_level) from person_epi_nutrition pw\r\n\t left outer join person_epi epi on epi.person_epi_id = pw.person_epi_id\r\n\t left outer join person p on p.person_id = epi.person_id\r\n\t where pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and pw.bmi_level=5 and p.village_id =1) as level5 ,\r\n\r\n (select count(pw.bmi_level) from person_epi_nutrition pw\r\n\t left outer join person_epi epi on epi.person_epi_id = pw.person_epi_id\r\n\t left outer join person p on p.person_id = epi.person_id\r\n\t where pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and pw.bmi_level=6 and p.village_id =1) as level6\r\n\r\n\r\nFROM\r\n person_epi_nutrition\r\n\r\nLIMIT 1"; } else { if ($opt == "1") { $sql6 = "SELECT\r\n\t\t\r\n\t(select count(pw.bmi_level) from person_epi_nutrition pw\r\n\t left outer join person_epi epi on epi.person_epi_id = pw.person_epi_id\r\n\t left outer join person p on p.person_id = epi.person_id\r\n\t where pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and p.village_id !=1) as level_all ,\r\n\r\n (select count(pw.bmi_level) from person_epi_nutrition pw\r\n\t left outer join person_epi epi on epi.person_epi_id = pw.person_epi_id\r\n\t left outer join person p on p.person_id = epi.person_id\r\n\t where pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and pw.bmi_level=0 and p.village_id !=1) as level0 ,\r\n\r\n (select count(pw.bmi_level) from person_epi_nutrition pw\r\n\t left outer join person_epi epi on epi.person_epi_id = pw.person_epi_id\r\n\t left outer join person p on p.person_id = epi.person_id\r\n\t where pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and pw.bmi_level=1 and p.village_id !=1) as level1 ,\r\n\r\n (select count(pw.bmi_level) from person_epi_nutrition pw\r\n\t left outer join person_epi epi on epi.person_epi_id = pw.person_epi_id\r\n\t left outer join person p on p.person_id = epi.person_id\r\n\t where pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and pw.bmi_level=2 and p.village_id !=1) as level2 ,\r\n\r\n (select count(pw.bmi_level) from person_epi_nutrition pw\r\n\t left outer join person_epi epi on epi.person_epi_id = pw.person_epi_id\r\n\t left outer join person p on p.person_id = epi.person_id\r\n\t where pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and pw.bmi_level=3 and p.village_id !=1) as level3 ,\r\n\r\n (select count(pw.bmi_level) from person_epi_nutrition pw\r\n\t left outer join person_epi epi on epi.person_epi_id = pw.person_epi_id\r\n\t left outer join person p on p.person_id = epi.person_id\r\n\t where pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and pw.bmi_level=4 and p.village_id !=1) as level4 ,\r\n\r\n (select count(pw.bmi_level) from person_epi_nutrition pw\r\n\t left outer join person_epi epi on epi.person_epi_id = pw.person_epi_id\r\n\t left outer join person p on p.person_id = epi.person_id\r\n\t where pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and pw.bmi_level=5 and p.village_id !=1) as level5 ,\r\n\r\n (select count(pw.bmi_level) from person_epi_nutrition pw\r\n\t left outer join person_epi epi on epi.person_epi_id = pw.person_epi_id\r\n\t left outer join person p on p.person_id = epi.person_id\r\n\t where pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and pw.bmi_level=6 and p.village_id !=1) as level6\r\n\r\n\r\nFROM\r\n person_epi_nutrition\r\n\r\nLIMIT 1"; } } } $result6 = ResultDB($sql6); //echo ?> <table width="900" border="0" cellpadding="1" cellspacing="1"> <tr bgcolor='yellow'><td colspan="9"><b>ࡳ±ì ¹éÓ˹ѡ/ÊèǹÊÙ§ ºÑªÕ 4</b></td></tr> <tr class="headtable"> <td width="20" height="21" align="center" background="img_mian/bgcolor2.gif">·Õè</td> <td width="50" align="center" background="img_mian/bgcolor2.gif">·Ñé§ËÁ´</td> <td width="50" align="center" background="img_mian/bgcolor2.gif">error</td> <td width="50" align="center" background="img_mian/bgcolor2.gif">¼ÍÁ</td> <td width="50" align="center" background="img_mian/bgcolor2.gif">¤è͹¢éÒ§¼ÍÁ</td> <td width="50" align="center" background="img_mian/bgcolor2.gif">ÊÁÊèǹ</td>
</select> <input type="submit" name="s_Submit" value="µ¡Å§" id="Button"></td> </tr></table> </form><br> <?php if ($_GET['s_Submit'] == "µ¡Å§") { $result_msalary = ResultDB($sqlSalary_month); //echo mysql_num_rows($result); $row_msalary = mysql_num_rows($result_msalary); if ($row_msalary == 0) { //row month print "<h2>äÁèÁÕ¢éÍÁÙÅ</h2>"; } else { $result_salary = ResultDB($sqlSalary); //echo mysql_num_rows($result); $rs_salary = mysql_fetch_array($result_salary); ?> <b>ÃÒ¡Òâͧ·èҹ㹻Õ<?php echo "<font color='red'>" . $_GET['s_year'] . "</font> Áըӹǹ <font color='red'>" . $row_msalary . "</font> ÃÒ¡ÒÃ"; ?> </b> <table width="95%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000"> <tr valign="middle"> <td width="4%" height="16" align="center" bgcolor="#CCCCCC">´/»</td> <td width="2%" align="center" bgcolor="#CCCCCC">¢Ñé¹</td> <td width="2%" align="center" bgcolor="#CCCCCC">ªèÇÂϺصÃ</td> <td width="5%" align="center" bgcolor="#CCCCCC">µÍºá·¹</td> <td width="5%" align="center" bgcolor="#CCCCCC">àÊÕè§ÀÑÂ</td> <td width="5%" align="center" bgcolor="#CCCCCC">ÈÖ¡ÉÒϺصÃ</td>