change_month_isThai PHP Code Examples

Example #1

0

Show file

File: report_in_department_nutrition34.php Project: jeerayuth/hosxp

    //echo $d1."dd".$d2;
    if ($opt == "all") {
        $sql1 = "SELECT\r\n\t\r\n\t (select count(nutrition_level) from person_wbc_nutrition where     \r\n\t   nutrition_date BETWEEN '{$d1}' AND '{$d2}' )  as level_all ,\r\n      \r\n\t  (select count(nutrition_level) from person_wbc_nutrition where nutrition_level=0 and nutrition_date BETWEEN '{$d1}' AND '{$d2}' )  as level0 ,\r\n      (select count(nutrition_level) from person_wbc_nutrition where nutrition_level=1 and nutrition_date BETWEEN '{$d1}' AND '{$d2}' )  as level1 ,\r\n      (select count(nutrition_level) from person_wbc_nutrition where nutrition_level=2 and nutrition_date BETWEEN '{$d1}' AND '{$d2}' )  as level2 ,\r\n      (select count(nutrition_level) from person_wbc_nutrition where nutrition_level=3 and nutrition_date BETWEEN '{$d1}' AND '{$d2}' )  as level3 ,\r\n      (select count(nutrition_level) from person_wbc_nutrition where nutrition_level=4 and nutrition_date BETWEEN '{$d1}' AND '{$d2}' )  as level4 ,\r\n      (select count(nutrition_level) from person_wbc_nutrition where nutrition_level=5 and nutrition_date BETWEEN '{$d1}' AND '{$d2}' )  as level5\r\n\r\nFROM\r\n       person_wbc_nutrition\r\n\r\nLIMIT 1";
    } else {
        if ($opt == "0") {
            $sql1 = "SELECT\r\n  \r\n   (select count(pw.nutrition_level) from person_wbc_nutrition    pw\r\n   left outer join person_wbc pbc on pbc.person_wbc_id = pw.person_wbc_id\r\n   left outer join person p on p.person_id = pbc.person_id\r\n   where\r\n   pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and p.village_id =1)  as level_all ,\r\n\r\n   (select count(pw.nutrition_level) from person_wbc_nutrition    pw\r\n   left outer join person_wbc pbc on pbc.person_wbc_id = pw.person_wbc_id\r\n   left outer join person p on p.person_id = pbc.person_id\r\n   where\r\n   pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and p.village_id=1 and pw.nutrition_level=0)  as level0 ,\r\n\r\n   (select count(pw.nutrition_level) from person_wbc_nutrition    pw\r\n   left outer join person_wbc pbc on pbc.person_wbc_id = pw.person_wbc_id\r\n   left outer join person p on p.person_id = pbc.person_id\r\n   where\r\n   pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and p.village_id=1 and pw.nutrition_level=1)  as level1 ,\r\n\r\n   (select count(pw.nutrition_level) from person_wbc_nutrition    pw\r\n   left outer join person_wbc pbc on pbc.person_wbc_id = pw.person_wbc_id\r\n   left outer join person p on p.person_id = pbc.person_id\r\n   where\r\n   pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and p.village_id=1 and pw.nutrition_level=2)  as level2 ,\r\n\r\n\r\n   (select count(pw.nutrition_level) from person_wbc_nutrition    pw\r\n   left outer join person_wbc pbc on pbc.person_wbc_id = pw.person_wbc_id\r\n   left outer join person p on p.person_id = pbc.person_id\r\n   where\r\n   pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and p.village_id=1 and pw.nutrition_level=3)  as level3 ,\r\n\r\n\r\n  (select count(pw.nutrition_level) from person_wbc_nutrition    pw\r\n   left outer join person_wbc pbc on pbc.person_wbc_id = pw.person_wbc_id\r\n   left outer join person p on p.person_id = pbc.person_id\r\n   where\r\n   pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and p.village_id=1 and pw.nutrition_level=4)  as level4 ,\r\n\r\n   (select count(pw.nutrition_level) from person_wbc_nutrition    pw\r\n   left outer join person_wbc pbc on pbc.person_wbc_id = pw.person_wbc_id\r\n   left outer join person p on p.person_id = pbc.person_id\r\n   where\r\n   pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and p.village_id=1 and pw.nutrition_level=5)  as level5\r\n\r\nFROM\r\n       person_wbc_nutrition\r\n\r\nLIMIT 1 ";
        } else {
            if ($opt == "1") {
                $sql1 = "SELECT\r\n  \r\n   (select count(pw.nutrition_level) from person_wbc_nutrition    pw\r\n   left outer join person_wbc pbc on pbc.person_wbc_id = pw.person_wbc_id\r\n   left outer join person p on p.person_id = pbc.person_id\r\n   where\r\n   pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and p.village_id !=1)  as level_all ,\r\n\r\n   (select count(pw.nutrition_level) from person_wbc_nutrition    pw\r\n   left outer join person_wbc pbc on pbc.person_wbc_id = pw.person_wbc_id\r\n   left outer join person p on p.person_id = pbc.person_id\r\n   where\r\n   pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and p.village_id!=1 and pw.nutrition_level=0)  as level0 ,\r\n\r\n   (select count(pw.nutrition_level) from person_wbc_nutrition    pw\r\n   left outer join person_wbc pbc on pbc.person_wbc_id = pw.person_wbc_id\r\n   left outer join person p on p.person_id = pbc.person_id\r\n   where\r\n   pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and p.village_id!=1 and pw.nutrition_level=1)  as level1 ,\r\n\r\n   (select count(pw.nutrition_level) from person_wbc_nutrition    pw\r\n   left outer join person_wbc pbc on pbc.person_wbc_id = pw.person_wbc_id\r\n   left outer join person p on p.person_id = pbc.person_id\r\n   where\r\n   pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and p.village_id!=1 and pw.nutrition_level=2)  as level2 ,\r\n\r\n\r\n   (select count(pw.nutrition_level) from person_wbc_nutrition    pw\r\n   left outer join person_wbc pbc on pbc.person_wbc_id = pw.person_wbc_id\r\n   left outer join person p on p.person_id = pbc.person_id\r\n   where\r\n   pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and p.village_id!=1 and pw.nutrition_level=3)  as level3 ,\r\n\r\n\r\n  (select count(pw.nutrition_level) from person_wbc_nutrition    pw\r\n   left outer join person_wbc pbc on pbc.person_wbc_id = pw.person_wbc_id\r\n   left outer join person p on p.person_id = pbc.person_id\r\n   where\r\n   pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and p.village_id!=1 and pw.nutrition_level=4)  as level4 ,\r\n\r\n   (select count(pw.nutrition_level) from person_wbc_nutrition    pw\r\n   left outer join person_wbc pbc on pbc.person_wbc_id = pw.person_wbc_id\r\n   left outer join person p on p.person_id = pbc.person_id\r\n   where\r\n   pw.nutrition_date BETWEEN '{$d1}' AND '{$d2}' and p.village_id!=1 and pw.nutrition_level=5)  as level5\r\n\r\nFROM\r\n       person_wbc_nutrition\r\n\r\nLIMIT 1 ";
            }
        }
    }
    $result1 = ResultDB($sql1);
    //echo mysql_num_rows($resultDenService);
    if (mysql_num_rows($result1) > 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 "";
        //create row
        ?>
<br><br>
					
					
<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 bgcolor='yellow'><td colspan="8"><b>à¡³±ì ÍÒÂØ/¹éÓË¹Ñ¡ ºÑªÕ 3</b></td></tr>

Example #2

0

Show file

File: show_pharmacy_advice_report_sum2.php Project: jeerayuth/hosxp

    print "<option value='{$sd2}'>{$sd2}</option>";
}
for ($i = 1; $i <= 31; $i++) {
    print "<option value='{$i}'>{$i}</option>";
}
print "</select>";
?>
</td>
               <td><?php 
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) {

Example #3

0

Show file

File: medicate_err_form_calen.php Project: jeerayuth/hosxp

		  <table width="650" border="0" cellpadding="0" cellspacing="0" class="bd-external">
            <tr align="center" bgcolor="#99CCFF">
              <td height="24" colspan="2" class="headmenu" background="img_mian/bgcolor2.gif">Medication Error <?php 
    echo "&nbsp;" . $Hospname . "&nbsp;";
    ?>
</td>
            </tr>
            <tr align="center" valign="top">
              <td colspan="2"><br>
	<?php 
    $d = date("d");
    $m = date("n");
    $y = date("Y");
    $m2 = date("m");
    //date in the day ,month 05->m,5->n
    $date_current = $d . " " . change_month_isThai($m) . " " . ($y + 543);
    //date cuurent thai show
    $date_current2 = $y . "-" . $m2 . "-" . $d;
    //date cuurent add to db
    $time_current = date("H:i:s");
    $h = date("H");
    $mm = date("i");
    $s = date("s");
    //time cuurent
    if ($submit_err == "") {
        //check botton submit
        ?>
			 <form method="get" name="frisk_report"  action="<?php 
        $PHP_SELF;
        ?>
">

Example #4

0

Show file

File: user_command_view.php Project: jeerayuth/hosxp

  						<?php 
            $i = 0;
            while ($i < mysql_num_rows($resultList_commandDoc)) {
                //while
                $rsList_commandDoc = mysql_fetch_array($resultList_commandDoc);
                ?>
  						<tr class="text-intable">
    					<td width="35" height="20" align="center" valign="middle"><?php 
                echo $i + 1;
                ?>
</td>
    					<td width="82" align="left" valign="middle">&nbsp;
						<?php 
                //echo $rsList_commandDoc["Month"];  number of month //echo $rsList_commandDoc["nonth"];  name of month
                //call function number of month change is name month
                echo change_month_isThai($rsList_commandDoc["Month"]);
                $month_year = $rsList_commandDoc["Year"] . "-" . $rsList_commandDoc["Month"] . "#" . $rsList_commandDoc["Year"] . "-0" . $rsList_commandDoc["Month"];
                //echo $month_year;
                ?>
</td>
    					<td width="46" align="center" valign="middle"><?php 
                echo $rsList_commandDoc["year"];
                ?>
</td>
    					<td width="86" align="center" valign="middle"><?php 
                echo $rsList_commandDoc["total"];
                ?>
</td>
    					<td width="94" align="center" valign="middle">
						<?php 
                print "<form method='get' action='{$PHP_SELF}'>";

Example #5

0

Show file

File: show_pharmacy_advice.php Project: jeerayuth/hosxp

				  </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 ov.vn as vn,ov.hn as hn ,ov.an as an,concat(pt.pname,pt.fname,'  ',pt.lname)as patient_name,ov.vstdate as vstdate,\r\nov.vsttime as vsttime,concat(ov.pttype,' ',ptt.name) as pttype ,ov.pttypeno,concat(ov.spclty,' ',sp.name)  as spclty\r\nfrom ovst ov\r\nleft outer join pttype ptt on ptt.pttype = ov.pttype\r\nleft outer join spclty  sp on sp.spclty=ov.spclty\r\nleft outer join patient pt on pt.hn = ov.hn\r\nwhere ov.vstdate ='{$d1}' ";
    $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>";
        //create row
        ?>
						
						<br><br>
					<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 width="25" height="21"  align="center" background="img_mian/bgcolor2.gif">���</td>
                            <td width="100"  align="center" background="img_mian/bgcolor2.gif">VN</td>
                            <td width="54" align="center"  background="img_mian/bgcolor2.gif">HN</td>
                            <td width="70" align="center"  background="img_mian/bgcolor2.gif">AN</td>
							<td width="160" align="center"  background="img_mian/bgcolor2.gif">����-ʡ��</td>
                           
                            <td width="100" align="center"  background="img_mian/bgcolor2.gif">�ѹ������Ѻ��ԡ��</td>

Example #6

0

Show file

File: med_report_b.php Project: jeerayuth/hosxp

            $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>
				<td width="63">ÃÐ´Ñº</td>
			  </tr>
		<?php

Example #7

0

Show file

File: med_report.php Project: jeerayuth/hosxp

            $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>áÊ´§¢éÍÁÙÅ¢Í§ÇÑ¹·Õè {$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>";
            ?>
			<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>
				<td width="63">ÃÐ´Ñº</td>
			  </tr>
		<?php

Example #8

0

Show file

File: faccount.php Project: jeerayuth/hosxp

 <table width="700" border="0" cellspacing="2" cellpadding="2">
  <tr align="center" bgcolor="#FFFF66">
    <td colspan="6">ÃÒÂ¡ÒÃà§Ô¹à´×Í¹</td>
  </tr>
  <tr align="center">
    <td colspan="6">
	ÃÒÂ¡ÒÃ»ÃÐ¨Óà´×Í¹ :&nbsp;&nbsp;
<?php 
        if ($s_month == "") {
            print "<select name='s_mount'>";
            for ($i = 1; $i <= 12; $i++) {
                print "<option value='{$i}'>" . change_month_isThai($i) . "</option>";
            }
            print "</select>";
        } 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);

Example #9

0

Show file

File: report_in_department_social_opd_pat1.php Project: jeerayuth/hosxp

            $i++;
        }
        //while
        ?>
                        </table></td>
                      </tr>
                    </table>
					<?php 
        $exp_file = "opd";
        /*
        print"<br><br>
        <img src='img_mian/excel_icon.gif' align='middle'>&nbsp;<a href='#excel_export.php?sy1=$sy1&sm1=$sm1&sd1=$sd1&sy2=$sy2&sm2=$sm2&sd2=$sd2&exp_file=$exp_file'>Excel Export File</a><br><br>";
        */
    } else {
        if ($sy1 != "") {
            print "<font color='green'><b>����բ����Ţͧ<br>�ѹ��� <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></b></font>";
        } else {
            print "<font color='green'><b>��س����͡��ǧ���� ����Ѻ��§ҹ</b></font><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>";
        }
    }
    ?>
                  </td>
                </tr>
                <tr>
                  <td width="544">&nbsp;</td>
                  <td width="475">&nbsp;</td>
                </tr>
              </table>
              <!-- form -->
              <!-- end form --></td>
        </tr>

Example #10

0

Show file

File: account_main.php Project: jeerayuth/hosxp

        $sql_DetailAccount = "select * from detail_account where UserID='{$s_name}' and mouth='{$s_month}' and syear='{$s_year}' ";
        // no detail account
        $resultDetailAccount = ResultDB($sql_DetailAccount);
        $rsDetailAccount = mysql_fetch_array($resultDetailAccount);
        ?>
<br><p align="center">
<table width="650" border="0" cellspacing="0" cellpadding="0" class="bd-external" align="center"><tr><td>
<table width="650" border="0" cellspacing="2" cellpadding="2" align="center">
  <tr align="center" bgcolor="#FFFF66">
    <td colspan="6"><b>ÃÒÂ¡ÒÃà§Ô¹à´×Í¹</b></td>
  </tr>
  <tr align="left">
    <td colspan="6">
	ÃÒÂ¡ÒÃ»ÃÐ¨Óà´×Í¹ :&nbsp;&nbsp;
      <input name="t_month" type="text" value="<?php 
        echo change_month_isThai($s_month);
        ?>
" size="10" disabled>
      &nbsp; <font size="2">»Õ :&nbsp;
      <input name="s_year" type="text" value="<?php 
        echo $s_year;
        ?>
" size="5" disabled> 
&nbsp; 
      </font>ÃËÑÊ :&nbsp;
      <input name="t_UserID" type="text" size="5" value="<?php 
        echo $code_login;
        ?>
" disabled> 
     &nbsp; ºÑªÕàÅ¢·Õè : 
      <input name="t_NoBank_Account " type="text"  size="13"  value="<?php

PHP change_month_isThai Examples