?>
</td>
                    <td align="center">&nbsp;<?php 
    $result = ResultDB($sqlAllBorn7);
    $rs = mysql_fetch_array($result);
    echo $rs['total'];
    ?>
</td>
                    <td align="center">&nbsp;<?php 
    $result = ResultDB($sqlAllBorn8);
    $rs = mysql_fetch_array($result);
    echo $rs['total'];
    ?>
</td>
                    <td align="center">&nbsp;<?php 
    $result = ResultDB($sqlAllBorn9);
    $rs = mysql_fetch_array($result);
    echo $rs['total'];
    ?>
</td>
                    <td>&nbsp;</td>
                  </tr>
                  <td>&nbsp;</td>
                  <td>&nbsp;¤ÅÍ´»¡µÔ</td>
                  <td align="center">&nbsp;</td>
                  <td align="center">&nbsp;</td>
                  <td align="center">&nbsp;</td>
                  <td align="center">&nbsp;</td>
                  <td align="center">&nbsp;</td>
                  <td align="center">&nbsp;</td>
                  <td align="center">&nbsp;</td>
					<input type="checkbox" name="cause_err17" value="[c17]">17.Å×ÁãËéÂÒ<br>&nbsp;
					<input type="checkbox" name="cause_err18" value="[c18]">18.äÁèÁÕ¡ÒõÃǨÊͺ«éÓ<br>&nbsp;
					<input type="checkbox" name="cause_err19" value="[c19]">19.Telephone Order<br>&nbsp;
					<input type="checkbox" name="cause_err20" value="[c20">20.Í×è¹æ (ÃкØ) <br>
					&nbsp; &nbsp;<input type="text" name="cause_err20txt" size="40"><br><br>					
					</td>
                </tr>
                <tr>
                  <td bgcolor="#CCFF00">ÃдѺ¤ÇÒÁÃعáç :</td>
                  <td colspan="5" bgcolor="#CCFF00">&nbsp;</td>
                </tr>
                <tr align="left" valign="top">
                  <td colspan="6"> -&gt;&gt;
				  <?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 "&nbsp;";
        echo $rs_search['pt_name'];
        echo "&nbsp;&nbsp;";
        /*
        echo "�ѹ�Դ ";
        echo "&nbsp;";
        echo dateThai($rs_search['birthday']);
        echo "</b></font>";
        */
        $i++;
    }
} else {
    echo "<font color='yellow' size='5'><b>";
    echo "&nbsp;";
    echo "�������ª��ͤ�������к�";
    echo "</b></font>";
Example #4
0
}

</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>";
Example #6
0
    $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">&nbsp;id : </td>
                  <td colspan="3" bgcolor="#FFFFCC">&nbsp;<?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>
Example #8
0
        echo "<tr>";
        echo "<td width='63' align='right'>" . ($i + 1) . ".</td>";
        echo "<td width=380'>гя╧╥уХарця║ир╬бр╨ре&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;" . 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>&nbsp;&nbsp;╨р╥</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">&nbsp;</font></td>
      <td colspan="3"><font size="+2" face="AngsanaUPC, BrowalliaUPC, CordiaUPC"><strong>&nbsp; 
        &nbsp;&nbsp;&nbsp;цгаЮ╩Г╧Ю╖т╧╓Ир╖╙сцп╥яИ╖йтИ╧ &nbsp; 
        <?php 
echo number_format(floor($resultOpd_Socail_sum['price']));
?>
        &nbsp;&nbsp;╨р╥  (<?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>
Example #10
0
    ?>
						</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td align="left">&nbsp;</td>
                      </tr>
                    </table></td>
                </tr>
              </table>
              <p>&nbsp;</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>&nbsp;|&nbsp;<a href="javascript:history.back(-1)">Âé͹¡ÅѺ</a>&nbsp;|</font> 
          </td>
          <td height="16" background="img_mian/bgcolor2.gif">&nbsp;</td>
        </tr>
Example #11
0
        } 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);
        ?>
      &nbsp;»Õ :&nbsp;
      <input name="t_year" type="text" size="10" value="<?php 
        echo $s_year;
        ?>
" disabled>
&nbsp; 
      ÃËÑÊ :&nbsp;
      <input name="t_UserID" type="text" size="10" value="<?php 
        echo $code_log;
        ?>
" disabled> 
     &nbsp; ºÑ­ªÕàÅ¢·Õè : 
      <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>

							
Example #13
0
                 print "<td align='center' bgcolor='red'>&nbsp;" . $rs['review_status'] . "</td>";
             }
             print "<td align='left'>&nbsp;" . $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'>&nbsp;" . $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;
                ?>
Example #15
0
				<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">&nbsp; </td>
                    </tr>
                    <tr>
                      <td>&nbsp; �س��� 
					  <?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'] . "&nbsp;<b><font color=red>>></b>&nbsp;" . $rsDcode["name"] . "</font><br>";
    ?>
</td>
                      <td align="right">&nbsp;</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 ";
Example #16
0
             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'];
             }
Example #17
0
        $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>
Example #20
0
</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">&nbsp;&nbsp;
                      <?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">&nbsp;&nbsp;<?php 
                echo $addr_patient;
Example #21
0
    $rsDcode = mysql_fetch_array($resultDcode);
    echo $_SESSION['ip_Log'] . "&nbsp;<b><font color=red>>></b>&nbsp;" . $rsDcode["name"] . "</font><br>";
    ?>
						</td>
                      <td align="left">����������´ �ѧ��� </td>
                    </tr>
                    <tr align="left" valign="bottom">
                      <td colspan="2" valign="bottom"> &nbsp;<?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 "&nbsp;<b><font color=yellow>>></font></b>&nbsp;&nbsp;<font color=black>��¡�ä����ᾷ�������&nbsp;�ӹǹ <b>" . $rsDoctor_All['total1'] . " </b>��¡��</font>";
        echo "<br>&nbsp;&nbsp;<b><font color=yellow>>></font></b>&nbsp;&nbsp;<font color=black>��¡�ä����ᾷ���� Approve&nbsp;���� �ӹǹ  <b>" . $rsApprComplete['total2'] . " </b>��¡��</font>";
        echo "<br>&nbsp;&nbsp;<b><font color=yellow>>></font></b>&nbsp;&nbsp;<a href=command_doc.php?Dcode={$Dcode}>��¡�ä����ᾷ�����ѧ��� Approve&nbsp; �ӹǹ <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">&nbsp;</td>
                      <td align="left">&nbsp;</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>";
    }
}
Example #23
0
              </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
Example #24
0
				<tr>
					<td align="center" colspan="4">
						
							<table border="0" width="800">
								
								<tr bgcolor='yellow'>
									<td><b>�ӴѺ</td>
									<td width="350">&nbsp;<b>��¡����</b></td>
									<td width="150">&nbsp;<b>strength</b></td>
									<td width="150">&nbsp;<b>units</b></td>
									<td width="150">&nbsp;<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 "&nbsp;��͹&nbsp;";
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 "&nbsp;��&nbsp;";
$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>&nbsp;&nbsp;&nbsp;<input type='submit' value='Continue' id='Button'>";
?>
				</td>
               </tr>
Example #26
0
            <tr align="center">
              <td colspan="2">&nbsp;</td>
            </tr>
            <tr>
              <td>&nbsp;</td>
              <td>&nbsp;</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();'>&nbsp;&nbsp;<input type='submit' value='Âé͹¡ÅѺ'  id='Button' onClick='goHist(-1);'><br><br>";
                //print"Development By <b>Guprajag</b> CopyRight &copy; 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>
Example #28
0
<?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>
Example #30
0
	</select> 
&nbsp;
&nbsp;
<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>