$Total =$Total+$amount;
$num++;
$sql = "SELECT idcard,address,tambol,ampur,changwat,phone,dbirth
FROM opcard
WHERE hn = '$hn' limit 1";
list($idcard,$address,$tambol,$ampur,$changwat,$phone,$dbirth) = mysql_fetch_row(Mysql_Query($sql));
print (" <tr>\n".
" <td BGCOLOR=F5DEB3>$num</td>\n".
" <td BGCOLOR=F5DEB3>$thidate</td>\n".
" <td BGCOLOR=F5DEB3>$hn</td>\n".
" <td BGCOLOR=F5DEB3><a target=_BLANK href=\"hndrugcheck.php? sDate=$thidate&hn=$hn\">$ptname</a></td>\n".
" <td BGCOLOR=F5DEB3>".calcage($dbirth)."</td>\n".
" <td BGCOLOR=F5DEB3>$ptright</a></td>\n".
" <td BGCOLOR=F5DEB3>$diag</td>\n".
" <td BGCOLOR=F5DEB3>$icd10</td>\n".
" <td BGCOLOR=F5DEB3>$icd101</td>\n".
" <td BGCOLOR=F5DEB3>$idcard</td>\n".
" <td BGCOLOR=F5DEB3>$address</td>\n".
" <td BGCOLOR=F5DEB3>$tambol</td>\n".
" <td BGCOLOR=F5DEB3>$ampur</td>\n".
" <td BGCOLOR=F5DEB3>$changwat</td>\n".
" <td BGCOLOR=F5DEB3>$phone</td>\n".
" </tr>\n");
if($icd10 != ""){
if(!isset($sum[$icd10]))
$sum[$icd10] = 0;
$ageY=$ageY-1;
$ageM=12+$ageM;
}
if ($ageM==0){
$pAge="$ageY ��";
}
else{
$pAge="$ageY �� $ageM ��";
}
return $pAge;
}
//$Y=($y-543);
//$dbirth="$Y-$m-$d";
$dbirth="$y-$m-$d"; //�觼�ҹ�������ѹ�Դ�ҡ opedit �¡�� submit
$cAge=calcage($dbirth);
//update opdcard table
$hospcode=$_POST['hospcode'];
$ptrcode=$_POST['rdo1'];
$employee = ( isset($_POST['employee']) && $_POST['employee'] === 'y' ) ? 'y' : 'n' ;
$sql = "UPDATE opcard SET idcard='$idcard',
mid='$mid',
hn='$cHn',
yot='$yot',
name='$name',
surname='$surname',
goup='$goup',
married='$married',
dbirth='$dbirth',
guardian='$guardian',
<td align="center" >ÍÒÂØ</td>
<td align="center" >¹éÓ˹ѡ<br>
(¡.¡)</td>
<td align="center">¾Ñ²¹Ò¡ÒÃÊÁÇÑÂ<br>
´éÒ¹ÃèÒ§¡ÒÂáÅÐÍÒÃÁ³ì</td>
<td align="center" >¡ÒÃà¨ÃÔàµÔºâµµÒÁÁҵðҹÍÒÂØáÅйéÓ˹ѡ</td>
<td align="center" >¹ÁáÁèã¹à´ç¡ 2-6 à´×͹</td>
<td align="center" id="no_print">á¡éä¢</td>
</tr>
<? } ?>
<tr class="forntsarabun">
<td align="center"><?=$n++; ?></td>
<td><?=$row['yot'].$row['name'].' '.$row['surname'];?></td>
<td><?=$row['hn'];?></td>
<td><?=calcage($row['dbirth']);?></td>
<td align="center"><?=$row['weight']?></td>
<td><?=$row['develop_age']?></td>
<td><?= $growth;?></td>
<td><?=$row['breastmilk'];?></td>
<td align="center" id="no_print"><a href="javascript:MM_openBrWindow('clinic_well_baby_edit.php?row_id=<?=$row['row_id'];?>','','width=600,height=600')">á¡éä¢</a></td>
<td align="center"><a href="JavaScript:if(confirm('Â×¹Âѹ¡ÒÃź¢éÍÁÙÅ?')==true){window.location='clinic_wellbaby_del.php?row_id=<?=$row["row_id"];?>';}">ź</a></td>
</tr>
<?
}
} else {
echo "<tr>";
echo "<td colspan='10' align=center class='forntsarabun'><font color=red>ÂѧäÁèÁÕÃÒ¡ÒÃ</font></td>";
echo "</tr>";
}
continue;
}
If ($result){
$cHn=$row->hn;
$cYot = $row->yot;
$cName = $row->name;
$cSurname = $row->surname;
$cPtright = $row->ptright;
$cGoup= $row->goup;
$cCamp= $row->camp;
$cIdcard=$row->idcard;
$cAge=$row->dbirth;
$cAddress=$row->address;
$cMuang="�. $row->tambol �. $row->ampur �. $row->changwat" ;
$cAge=calcage($cAge);
echo "��Ǩ�ͺ���ͼ����� ���ͤ����١��ͧ���Ѻ����<br>";
echo "<FONT SIZE='4' COLOR='#FF0000'>HN : $cHn, <B>AN:$an</B></FONT> <BR><FONT SIZE='4' COLOR=''> ����: $cYot $cName $cSurname, �Է�ԡ���ѡ�� : $cPtright </FONT><br>";
}
else {
echo "��辺 HN : $hn ";
}
}
ELSE {
echo "��辺 AN in ipcard table : $an ";
}
/////////////
if ($ageM<0) {
$ageY=$ageY-1;
$ageM=12+$ageM;
}
if ($ageM==0){
$pAge="$ageY ��";
}else{
$pAge="$ageY �� $ageM ��";
}
return $pAge;
}
if($cYot=="�.�."||$cYot=="�.�."||$cYot=="�硪��"||$cYot=="��˭ԧ"){
$agechk = substr(calcage($cDbirth),0,2);
if($agechk>=15){
?>
<script>
alert("���ؤú 15 �� ��س�����¹�ӹ�˹�Ҫ��ʹ��¤�");
</script>
<?
}
}
$cPtname=$cYot." ".$cName." ".$cSurname;
if(substr($cPtright,0,3)=='R07'){
$sql = "Select id From ssodata where id LIKE '$cIdcard%' limit 1 ";
if(Mysql_num_rows(Mysql_Query($sql)) > 0){
$color = "#339966";
}else{
$_SESSION["dt_dental"] = true;
} else {
$_SESSION["dt_doctor"] = $_SESSION["sOfficer"];
$_SESSION["dt_dental"] = false;
}
if (isset($_POST["special"])) {
$_SESSION["dt_special"] = true;
} else {
$_SESSION["dt_special"] = false;
}
list($hn_now, $_SESSION["time_opday"], $mcheckdx) = Mysql_fetch_row($result);
$_SESSION["vn_now"] = $_REQUEST["vn_now"];
$sql = "Select hn, idcard, yot, name, surname, dbirth, ptright From opcard where hn = '" . $hn_now . "' limit 1";
$result = Mysql_Query($sql);
list($_SESSION["hn_now"], $_SESSION["idcard_now"], $_SESSION["yot_now"], $_SESSION["name_now"], $_SESSION["surname_now"], $_SESSION["age_now"], $_SESSION["ptright_now"]) = Mysql_fetch_row($result);
$_SESSION["age_now"] = calcage($_SESSION["age_now"]);
$thidate = date("d-m-") . (date("Y") + 543);
$thidatehn = $thidate . $_SESSION["hn_now"];
$sql = "Select temperature, pause, rate, weight, bp1, bp2, congenital_disease, organ, officer, drugreact, time_format(thidate,'%H:%i'), height, type From opd where thdatehn = '" . $thidatehn . "' limit 1";
$result = Mysql_Query($sql) or die("Error opd");
list($_SESSION["temperature"], $_SESSION["pause"], $_SESSION["rate"], $_SESSION["weight"], $bp1, $bp2, $_SESSION["congenital_disease"], $_SESSION["organ"], $_SESSION["staff"], $_SESSION["drugreact"], $_SESSION["time_opd"], $_SESSION["height"], $_SESSION["type"]) = Mysql_fetch_row($result);
$sql = "Update opd set dc_diag = '" . date("H:i:s") . "' Where thdatehn = '" . $thidatehn . "' limit 1 ";
$result = Mysql_Query($sql);
$_SESSION["bp"] = $bp1 . "/" . $bp2;
//$_SESSION["dt_diag_detail"]=$_SESSION["organ"];
if ($_SESSION["sIdname"] == "md19921") {
$sql = "select count(hn) from opday where doctor ='¸¹º´Ô¹·Ãì ¼ÅÈÃÕ¹Ò¤ (Ç.19921)' AND hn='" . $_SESSION["hn_now"] . "' AND diag IS NOT NULL Order by row_id DESC limit 1";
$result = mysql_query($sql);
list($rows) = mysql_fetch_row($result);
if ($rows > 0) {
$sql = "Select diag From opday where hn='" . $_SESSION["hn_now"] . "' AND doctor ='¸¹º´Ô¹·Ãì ¼ÅÈÃÕ¹Ò¤ (Ç.19921)' AND diag IS NOT NULL Order by row_id DESC limit 1 ";
</tr>
</table>
<input type="hidden" name="hn" value="<?php
echo $show['hn'];
?>
">
<input type="hidden" name="name" value="<?php
echo $show['name'];
?>
">
<input type="hidden" name="surname" value="<?php
echo $show['surname'];
?>
">
<input type="hidden" name="age" value=" <?php
echo calcage($show['dbirth']);
?>
">
<input type="hidden" name="ptright" value=" <?php
echo $show['ptright'];
?>
">
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td class="f" style="border-bottom-style:none; border-right-style:none;">»ÃÐàÀ·</td>
<td class="f1" style="border-bottom-style:none; border-right-style:none;"><input type="radio" name="type" id="type" value="»¡µÔ" /> »¡µÔ</td>
<td colspan="5" class="f1" style="border-bottom-style:none; border-left-style:none;"><input type="radio" name="type" id="type" value="©Ø¡à©Ô¹" /> ©Ø¡à©Ô¹</td>
</tr>
<tr>
<td class="f" style="border-bottom-style:none; border-right-style:none; border-top-style:none;">Clinic</td>
<td class="f1" style="border-bottom-style:none; border-right-style:none; border-top-style:none;"><input type="radio" name="clinic" id="clinic" onclick="document.form1.case11.disabled=true;" value="ÍÒÂØáÃÃÁ" /> ÍÒÂØáÃÃÁ</td>
<tr>
<td align="center"><span class="style2">�Է�� :
<?=$strRows["ptright"];?></span>
<?=$strRows["toborow"];?></td>
</tr>
</table></td>
</tr>
<tr class="style2">
<td height="28" colspan="3" align="center" class="style3"><strong>�ç��Һ�Ť�������ѡ��������</strong></td>
</tr>
<tr>
<td colspan="2" align="left" valign="top" class="style3"><strong>���� : </strong><?=$rows["yot"].$rows["name"]." ".$rows["surname"];?></td>
<td width="23%" align="left" valign="top"><strong>HN : </strong><?=$rows["hn"];?></td>
</tr>
<tr align="left" valign="top">
<td width="14%"><strong>���� : </strong><?=calcage($rows["dbirth"]);?></td>
<td width="12%"><strong>�� : </strong>
<? if($rows["sex"]=="�" || $rows["sex"]=="1"){ echo "���";}else if($rows["sex"]=="�" || $rows["sex"]=="2"){ echo "˭ԧ";}else{ echo "������к�";}?></td>
<td><?=$rows["idcard"];?></td>
</tr>
</table>
<table width="100%" height="85%" border="0" cellpadding="0" cellspacing="0" style="border-top:1px solid #000000;">
<tr>
<td width="45%" height="405" align="left" valign="top"><table width="100%" height="189" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="21" colspan="3"><strong>���� : </strong>.....................<strong>�ѡɳм����� : </strong>...........................................</td>
</tr>
<tr>
<td width="28%" height="21"><strong>BW : </strong> ..........Kg.</td>
<td width="30%"><strong>High : </strong>..........cm.</td>
<td width="42%"><strong>BP : </strong>........../..........mmHg.</td>
if(!($row = mysql_fetch_object($result)))
continue;
}
//31
$chn=$row->hn;
$cyot=$row->yot;
$cname=$row->name;
$csurname=$row->surname;
$cptright=$row->ptright;
$cdbirth=$row->dbirth;
$cptname=$cyot.''.$cname.''.$csurname;
$cbedname='äµà·ÕÂÁ';
$cdoctor = calcage($cdbirth);
////
///po97 㺷Õè 1
print "<HTML>";
print "<script>";
print "ie4up=nav4up=false;";
print "var agt = navigator.userAgent.toLowerCase();";
print "var major = parseInt(navigator.appVersion);";
print "if ((agt.indexOf('msie') != -1) && (major >= 4))";
$_POST["date_in"] = (date("Y",$ti)+543).date("-m-d",$ti);*/
$time_in = "23:31:00";
}else if($time_in >= "23:31:00" && $time_in <= "23:59:59"){
list($y,$m,$d) = explode("-",$_POST["date_in"]);
$y=$y-543;
$ti = mktime(0,0,0,$m,$d+1,$y);
$_POST["date_in"] = (date("Y",$ti)+543).date("-m-d",$ti);
$time_in = "07:31:00";
}else if($time_in >= "00:00:00" && $time_in < "07:31:00"){
$time_in = "07:31:00";
}
$sql ="INSERT INTO `trauma` ( `date` , `vn` , `hn` , `an`, `age` , `list_ptright` , `list_ptright2` , `disease_people` , `drug_alert` , `dx`, `organ`, `maintenance`, `doctor`, `type_accident` , `wounded_vehicle` , `wounded_detail` , `cause_accident` , `spirits` , `belt` , `helmet` , `sender` , `cure`, `time_diag` , `time_in` , `time_out`, `officer`, `trauma`, `obs`, `type_wounded`, `type_wounded2`, `accident_detail`, `date_in`,`etc_sender`, `with_cause_accident`, `list_with_cause_accident`, `admit_ward`, `refer_hospital`, `repeat`, `cause_refer`, `type_patient`, `means_refer`, `take_care`,`doc_refer`, `nurse`, `assistant_nurse`, `estimate`, `no_estimate`, `cradle`, `doc_txt`, `consult`, `to_or`, `to_lr`, `to_etc`, `er_tell`, `problem_refer`, `suggestion`, `to_hpt_lp`, `out_changwat`, `next_ka` ) VALUES ('".$thaidate."', '".$_POST["vn"]."', '".$_POST["hn"]."', '".$_POST["an"]."', '".calcage($dbirth)."', '".$_POST["list_ptright"]."', '".$_POST["list_ptright2"]."', '".jschars($_POST["disease_people"])."', '".jschars($_POST["drug_alert"])."', '".jschars($_POST["dx"])."', '".jschars($_POST["organ"])."', '".jschars($_POST["maintenance"])."', '".$_POST["doctor"]."', '".$_POST["type_accident"]."', '".$_POST["wounded_vehicle"]."', '".$_POST["wounded_detail"]."', '".$_POST["cause_accident"]."', '".$_POST["spirits"]."', '".$_POST["belt"]."', '".$_POST["helmet"]."', '".$_POST["sender"]."', '".$_POST["cure"]."', '".$time_diag."', '".$time_in."', '".$time_out."', '".$_SESSION["sOfficer"]."', '".$_POST["trauma"]."', '".$_POST["obs"]."', '".$_POST["type_wounded"]."', '".$_POST["type_wounded2"]."', '".$_POST["accident_detail"]."','".$_POST["date_in"]."','".$_POST["etc_sender"]."','".$_POST["with_cause_accident"]."','".$_POST["list_with_cause_accident"]."','".$_POST["admit_ward"]."','".$_POST["refer_hospital"]."', '".$_POST["repeat"]."', '".$_POST["cause_refer"]."', '".$_POST["type_patient"]."', '".$_POST["means_refer"]."', '".$_POST["take_care"]."','".$_POST["doc_refer"]."', '".$_POST["nurse"]."', '".$_POST["assistant_nurse"]."', '".$_POST["estimate"]."', '".$_POST["no_estimate"]."', '".$_POST["cradle"]."', '".$_POST["doc_txt"]."', '".$_POST["consult"]."', '".$_POST["to_or"]."', '".$_POST["to_lr"]."', '".$_POST["to_etc"]."', '".$_POST["er_tell"]."', '".$_POST["problem_refer"]."', '".$_POST["suggestion"]."', '".$_POST["to_hpt_lp"]."', '".$_POST["out_changwat"]."', '1' );";
$result = Mysql_Query($sql) or Mysql_error();
$id= Mysql_insert_id();
if($result){
$count = count($_POST["lst_labcare"]);
for($i=0;$i<$count;$i++){
$sql = "INSERT INTO `trauma_lst_labcare` (`for_id`, `hn`, `lst_labcare`, `amount`) values ('".$id."','".$_POST["hn"]."','".$_POST["lst_labcare"][$i]."', '".$_POST["amount_lst_labcare"][$i]."');";
if($_POST["lst_labcare"][$i] != "L01")
$result2 = Mysql_Query($sql);
}
$i=1;
while($arr=mysql_fetch_array($query)){
$id=substr($arr['id'],0,13);
$sql2="SELECT * FROM `opcard` WHERE idcard ='".$id."' ";
$query2=mysql_query($sql2);
while($arr2=mysql_fetch_array($query2)){
?>
<tr>
<td align="center"><?=$i;?></td>
<td> <?=$arr2['idcard'];?></td>
<td> <?=$arr2['hn'];?></td>
<td> <?=$arr2['yot'].$arr2['name'].' '.$arr2['surname'];?></td>
<td> <?=calcage($arr2['dbirth']);?></td>
<td align="center"><?=$arr2['sex'];?></td>
</tr>
<?
$i++;
}
}
?>
</table>
</body>
</html>
</td>
<td align="center" valign="top" class="texthead"><strong>ẺÃÒ§ҹ¡ÒõÃǨÊØ¢ÀÒ¾ÅÙ¡¨éÒ§»ÃÐ¨Ó»Õ <?=$nPrefix?></strong></td>
</tr>
<tr>
<td align="center" valign="top" class="texthead"><strong>âç¾ÂÒºÒŤèÒÂÊØÃÈÑ¡´ÔìÁ¹µÃÕ Í.àÁ×ͧ ¨.ÅÓ»Ò§ â·Ã.054-839305</strong></td>
</tr>
</table>
</td></tr>
<tr>
<td valign="top">
<table border="1" cellpadding="0" cellspacing="0" bordercolor="#666666" width="100%" >
<tr><td>
<table width="100%" class="text1"><tr><td width="15%" valign="top" class="text2"><strong>HN :</strong> <?=$result['hn']?></td>
<td colspan="3" valign="top" class="text2"><strong>ª×èÍ :</strong> <span style="font-size:24px"><strong><?=$result['yot']." ".$result['name']." ".$result['surname']?></strong></span></td>
<td valign="top" class="text2"><strong>ÍÒÂØ :</strong>
<?=calcage($result['dbirth'])?></td>
<td valign="top" class="text3"><strong>Êѧ¡Ñ´ : </strong>
<span style="font-size:24px"><strong><?=$result['camp']?></strong></span>
</td>
</tr>
<tr>
<td valign="top"><span class="text3"><strong>¹éÓ˹ѡ: </strong>
<?=$result1['weight']?>¡¡.</span></td>
<td width="14%" valign="top"><span class="text3"><strong>ÊèǹÊÙ§:</strong>
<?=$result1['height']?>
«Á.</span></td>
<td width="10%" valign="top"><span class="text3"><strong>BMI: </strong>
<u><?=$result1['bmi']?></u>
</span></td>
<td width="14%" valign="top"><span class="text3"><strong>ÃͺàÍÇ:</strong>
<?=$result1['round_']?>
<td width="157" height="67" class="style9"style="border-right-style:none; border-left-style:none; border-bottom-style:none; "><strong>ª×èÍ-Ê¡ØÅ</strong></td>
<td colspan="5" class="style9"style="border-right-style:none; border-left-style:none; border-bottom-style:none"><strong><font style="font-size: 16px;"><?=$show['yot'];?>
<?=$show['name'];?>
<?=$show['surname'];?>
</strong></td>
<td width="96" class="style11"><strong>AN</strong></td>
<td width="95" class="style11"><strong>XN</strong></td>
</tr>
<tr>
<td class="style9" style="border-right-style:none; border-left-style:none; border-bottom-style:none; border-top-style:none"><strong>Çѹ à´×͹ »Õà¡Ô´</strong></td>
<td width="141" class="style13" style="border-right-style:none; border-left-style:none; border-bottom-style:none; border-top-style:none"><? $a1 = array( "","Á¡ÃÒ¤Á", "¡ØÁÀҾѹ¸ì", "ÁÕ¹Ò¤Á", "àÁÉÒ¹", "¾ÄÉÀÒ¤Á", "ÁԶعÒ¹", "¡Ã¡®Ò¤Á", "ÊÔ§ËÒ¤Á", "¡Ñ¹ÂÒ¹", "µØÅÒ¤Á", "¾ÄȨԡÒ¹", "¸Ñ¹ÇÒ¤Á" );?> <?=substr($show['dbirth'],8,2)." ".$a1[substr($show['dbirth'],5,2)+0]." ".substr($show['dbirth'],0,4);?></td>
<td width="160" class="style9" style="border-right-style:none; border-left-style:none; border-bottom-style:none; border-top-style:none"><strong>à¾È</strong></td>
<td width="107" class="style13" style="border-right-style:none; border-left-style:none; border-bottom-style:none; border-top-style:none">
<? if($show['sex'] != "") { echo "ªÒÂ"; }else{ echo "ËÔ§"; } ?> </td>
<td class="style9" style="border-right-style:none; border-left-style:none; border-bottom-style:none; border-top-style:none"><strong>ÍÒÂØ</strong></td>
<td width="177" class="style13" style="border-right-style:none; border-left-style:none; border-bottom-style:none; border-top-style:none"><?=calcage($show['dbirth'])?></td>
<td class="style9"> </td>
<td class="style9"> </td>
</tr>
<tr>
<td class="style9" style="border-right-style:none; border-left-style:none; border-bottom-style:none; border-top-style:none"><strong>ÈÒʹÒ</strong></td>
<td class="style13" style="border-right-style:none; border-left-style:none; border-bottom-style:none; border-top-style:none"><?=$show['religion'];?></td>
<td class="style9" style="border-right-style:none; border-left-style:none; border-bottom-style:none; border-top-style:none"><strong>àª×éͪҵÔ</strong></td>
<td class="style13" style="border-right-style:none; border-left-style:none; border-bottom-style:none; border-top-style:none"><?=$show['race'];?></td>
<td class="style9" style="border-right-style:none; border-left-style:none; border-bottom-style:none; border-top-style:none"><strong>ÊѪҵÔ</strong></td>
<td class="style9" style="border-right-style:none; border-left-style:none; border-bottom-style:none; border-top-style:none"><?=$show['nation'];?></td>
<td class="style9"> </td>
<td class="style9"> </td>
</tr>
<tr>
<td class="style9" style="border-right-style:none; border-left-style:none; border-bottom-style:none; border-top-style:none"><strong>ºÔ´Ò</strong></td>
</TR> </TABLE> </TD> </TR> <TR> <TD colspan="2"> <FONT style="font-size: 24px;">╙вХм<U> <?=$testUser['yot'].' '.$testUser['name'].' '.$testUser['surname'];?> </U></FONT> </TD> </TR> <TR> <TD><FONT style="font-size: 24px;">HN<U> <?php echo $testUser["hn"];?></U></FONT></TD> <TD><FONT style="font-size: 24px;">ID<U> <?php echo $testUser["idcard"];?></U></FONT></TD> </TR> <TR> <TD>йт╥╦тЛ : <B><?php echo substr($testUser["ptright"],4);?></TD> <TD>мрбь : <?php echo calcage($testUser["dbirth"]);?></TD> </TR> <TR> <TD colspan="2">А╬╥бЛ : <?php echo $itemEtc["doctor"];?></TD> </TR> <TR> <TD colspan="2"> <TABLE border="1" align="center" width="300" bordercolor="#000000" cellspacing="0" cellpadding="0" style="font-size: 30px;"> <TR align="center"> <TD width="30"> <FONT style="font-size: 22px;">Ю╒Га</FONT></TD> <TD width="60"> <FONT style="font-size: 22px;">VN</FONT></TD> <TD width="90"> <FONT style="font-size: 22px;">г/╢/╩</FONT></TD> <TD width="50"> <FONT style="font-size: 22px;">Югер</FONT></TD> <TD width="50"> <FONT style="font-size: 22px;">╪ыИ╘у╢</FONT></TD> </TR> <?php
if ($ageM < 0) {
$ageY = $ageY - 1;
$ageM = 12 + $ageM;
}
if ($ageM == 0) {
$pAge = "{$ageY} ��";
} else {
$pAge = "{$ageY} �� {$ageM} ��";
}
return $pAge;
}
$row_id = trim($_GET['row_id']);
$sql = "SELECT * FROM `booking` WHERE `row_id` ='" . $row_id . "' ";
$query = mysql_query($sql);
$dbarr = mysql_fetch_array($query);
$age = calcage($dbarr['bdate']);
// header('Content-type: application/pdf');
$pdf = new PDF_AutoPrint("P", 'mm', "A4");
$pdf->SetThaiFont();
// �絿��
$pdf->SetAutoPageBreak(false, 0);
$pdf->SetMargins(0, 0);
$pdf->SetTopMargin(2);
$pdf->AddPage();
$pdf->SetFont('THSarabun');
// ���¡��ҹ�������������
$pdf->SetFontSize(17);
$pdf->Cell(0, 4, "�ͧ/Ἱ�/��ǹ �ٹ�������� �͡��������Ţ FR-IPC-001/3 ��䢤��駷�� 00 �ѹ����ռźѧ�Ѻ�� 28 �.�.44", 0, 1, "C");
$pdf->SetFontSize(30);
$pdf->Cell(0, 10, "㺨ͧ��§", 0, 1, "C");
$pdf->SetFontSize(23);
if ($ageM<0) {
$ageY=$ageY-1;
$ageM=12+$ageM;
}
if ($ageM==0){
$pAge="$ageY ��";
}else{
$pAge="$ageY �� $ageM ��";
}
return $pAge;
}
$cAge=calcage($arr['dbirth']);
?>
<table width="100%" border="1" style="border-collapse:collapse;" bordercolor="#000000" cellpadding="0" cellspacing="0">
<tr>
<td align="center"><table width="100%" border="0">
<tr>
<td align="center" class="forntsarabun">�ͧ/Ἱ�/��ǹ �ٹ�������� �͡��������Ţ FR-IPC-001/8 ��䢤��駷�� 02 �ѹ����ռźѧ�Ѻ�� 01,01,52</td>
</tr>
<tr class="forntsarabun2">
<td align="center">Ẻ����Ѻ��ѡ�ҵ�� þ.��������ѡ��������</td>
</tr>
<tr >
<td align="right" class="forntsarabun3">�ѹ���...................................��..................................��...............................</td>
</tr>
<tr >
<td align="left" class="forntsarabun3">����-ʡ�ż�����...<?=$arr['ptname']?>...����..<?=$cAge?> �ä..............................................................</td>
$month['05'] = "¾ÄÉÀÒ¤Á";
$month['06'] = "ÁԶعÒ¹";
$month['07'] = "¡Ã¡®Ò¤Á";
$month['08'] = "ÊÔ§ËÒ¤Á";
$month['09'] = "¡Ñ¹ÂÒ¹";
$month['10'] = "µØÅÒ¤Á";
$month['11'] = "¾ÄȨԡÒ¹";
$month['12'] = "¸Ñ¹ÇÒ¤Á";
if(isset($_GET["action"]) && $_GET["action"] == "view"){
include("connect.inc");
$sql = "Select concat(yot,' ',name,' ',surname) as fullname, ptright, idcard, dbirth From opcard where hn = '".$_GET["hn"]."' limit 1 ";
$result = Mysql_Query($sql);
list($fullname, $ptright,$idcard,$dbirth) = Mysql_fetch_row($result);
echo "<FONT COLOR=\"red\">ª×èÍ-Ê¡ØÅ ",$fullname," ÊÔ·¸Ô¡ÒÃÃÑ¡ÉÒ ", $ptright,"</FONT>";
echo "<INPUT TYPE=\"hidden\" Name=\"fullname\" Value=\"".$fullname."\"><INPUT TYPE=\"hidden\" Name=\"ptright\" value=\"".$ptright."\"><INPUT TYPE=\"hidden\" Name=\"idcard\" value=\"".$idcard."\"><INPUT TYPE=\"hidden\" Name=\"dbirth\" value=\"".$dbirth."\"><INPUT TYPE=\"hidden\" Name=\"age\" value=\"".calcage($dbirth)."\">";
include("unconnect.inc");
exit();
}
if(isset($_GET["action"]) && $_GET["action"] == "view_inj"){
$_GET['y'] = $_GET['y']-543;
echo "<TABLE width='100%' cellpadding='2' cellspacing='0' border='1' bordercolor='#000000' style='BORDER-COLLAPSE: collapse'>
<TR align='center'>
<TD>Çѹ·Õè¹Ñ´·Óá¼Å</TD>
</TR>";
$ageY=$ageY-1;
$ageM=12+$ageM;
}
if ($ageM==0){
$pAge="$ageY »Õ";
}else{
$pAge="$ageY »Õ $ageM à´×͹";
}
return $pAge;
}
$sqlage = "select idcard,dbirth,idguard,goup from opcard where hn ='".$cHn."'";
$arr_age = mysql_fetch_array(mysql_query($sqlage));
$age = calcage($arr_age['dbirth']);
$idcard=$arr_age['idcard'];
$idguard=$arr_age['idguard'];
$goup=$arr_age['goup'];
if($idcard=="" || $idcard=="-"){
$img=$cHn.'.jpg';
}else{
$img=$idcard.'.jpg';
}
if(file_exists("../image_patient/$img")){
$image="<IMG SRC='../image_patient/$img' WIDTH='100' HEIGHT='150' BORDER='1' ALT=''>";
echo "<option value='$arr[name]'>$arr[name]</option>";
}
}
?>
</select>
</td>
</tr>
<tr>
<td>2.</td>
<td colspan="2" class="sample">���ͺؤ�ҡ�
<input name="ptname" type="text" class="hfont" id="ptname" size="40" value="<?=$ptname;?>"/></td>
<td>����</td>
<td>
<input name="age" type="text" class="hfont" id="age" value="<?=calcage($dbarr['dbirth']);?>"/></td>
</tr>
<tr>
<td>3.</td>
<td colspan="4">�������ؤ�ҡ�</td>
</tr>
<tr>
<td> </td>
<td colspan="4">
<input type="radio" name="staff" id="staff1" value="ᾷ��" <? if($myarr['staff']=='ᾷ��'){ echo "checked='checked'"; }?>/>
ᾷ��
<input type="radio" name="staff" id="staff2" value="��Һ��" <? if($myarr['staff']=='��Һ��'){ echo "checked='checked'"; }?> />
��Һ��
<input type="radio" name="staff" id="staff3" value="�����¾�Һ��" <? if($myarr['staff']=='�����¾�Һ��'){ echo "checked='checked'"; }?>/>
�����¾�Һ��
<input type="radio" name="staff" id="staff4" value="��ѡ�ҹ���¡�þ�Һ��" <? if($myarr['staff']=='��ѡ�ҹ���¡�þ�Һ��'){ echo "checked='checked'"; }?>/>
$hn = isset($_GET["id"]) ? intval($_GET["id"]) : null;
if (!empty($hn)) {
$csql = sprintf("SELECT * FROM `hypertension_history` WHERE `id` = '%s' ", $hn);
$cquery = mysql_query($csql);
$crow = mysql_num_rows($cquery);
if (!$crow) {
?>
<br> <font class='forntsarabun1'>äÁ辺 HN <b>$hn</b> ã¹·ÐàºÕ¹ HT</font><?php
} else {
// $arr_opd = mysql_fetch_array($cquery);
// $sqlht = sprintf("SELECT *, concat(yot,name,' ',surname) AS ptname FROM opcard WHERE hn='%s' ", $hn);
// $queryht = mysql_query($sqlht);
// $row = mysql_num_rows($queryht);
$arr_opd = mysql_fetch_assoc($cquery);
// $arr_opd = $arr_opd;
$arr_opd["age"] = calcage($arr_opd["dbirth"]);
$height = $arr_opd["height"];
$weight = $arr_opd["weight"];
$cigarette = $arr_opd["smork"];
////////////////////////////////////////
// var_dump($arr_opd);
////////////////////////////////////////
$datenow = date("Y-m-d");
?>
<!-- ¢éÍÁÙÅàº×éͧµé¹¢Í§¼Ùé»èÇ -->
<FORM METHOD="post" ACTION="hypertension_edithistory.php?do=save" name="F1">
<TABLE border="1" cellpadding="2" cellspacing="0" bordercolor="#393939" bgcolor="#FFFFCE" >
<TR>
<TD>
<TABLE border="0" cellpadding="0" cellspacing="0">
<TR>
$sql = "INSERT INTO `pharinj_history` (`id` ,`hn` ,`dphardep_id`, `start_date`)
VALUES (
NULL , '$hn', '".$item['idno']."', '".$item['date']."'
);";
mysql_query($sql) or die( mysql_error() );
$count = count($list_date);
for($i = 0; $i < $count; $i++){
// ╨я╧╥ж║╒Имаые ║рц╧я╢
$sql = "INSERT INTO appoint(date,officer,hn,ptname,age,doctor,appdate,apptime,room,detail,detail2,advice,patho,xray,other,depcode,injno,detail_etc)VALUES
('$Thidate',
'$sOfficer',
'$hn',
'$full_name',
'".calcage($birth_day)."',
'$sDoctor',
'".$list_date[$i]."',
'08:00 ╧. - 11.00 ╧.',
'А╪╧║╥пЮ╨уб╧',
'FU22 ╧я╢╘у╢бр',
'╧я╢╘у╢бр ".$injCode[$dgcode]."',
'',
'',
'',
'╧я╢╘у╢бр ".$injCode[$dgcode]."',
'U22 кИм╖╗Хрббр',
'Ю╒Га╥уХ ".($i+1)."',
'');";
$result = mysql_query($sql);
//echo mysql_errno() . ": " . mysql_error(). "\n";
//echo "<br>";
print "<center><font style='font-size: 24px;'><b> ÅӴѺ·Õè:$vkew1 </b></font><br> ";
print "<font style='font-size: 18px;'><b>·ËÒÃáÅФÃͺ¤ÃÑÇ </b></font><br> ";
print "<font style='font-size: 13px;'><b>Çѹ·Õè$Thaidate</b></font><br> ";
print "$cPtname<br>";
print "HN:$cHn.....VN:$nVn<br>";
print "<b>ÃÍÃѺºÃÔ¡Ò÷Õè¨Ø´¤Ñ´á¡</b></center>";
}else{
$sql = "select * from opcard where hn = '$cHn' ";
$row = mysql_query($sql);
$result = mysql_fetch_array($row);
$ages = calcage($result["dbirth"]);
if($ages>=75){
$query = "SELECT title,prefix,runno FROM runno WHERE title = 'kewolder'";
$result = mysql_query($query)
or die("Query failed runno ask");
for ($i = mysql_num_rows($result) - 1; $i >= 0; $i--) {
if (!mysql_data_seek($result, $i)) {
echo "Cannot seek to row $i\n";
continue;
}
if(!($row = mysql_fetch_object($result)))
continue;
}
<B> <?php echo $_POST["drug_inj"];?> </B> </TD> </TR> </TABLE> </TD> </TR> <TR> <TD colspan="2"><FONT style="font-family: Angsana New; font-size: 24px;">����<U> <?php echo $_POST["fullname"];?> </U></FONT></TD> </TR> <TR> <TD><FONT style="font-family: Angsana New; font-size: 24px;">HN<U> <?php echo $_POST["hn"];?></U></FONT></TD> <TD><FONT style="font-family: Angsana New; font-size: 24px;">ID<U> <?php echo $_POST["idcard"];?></U></FONT></TD> </TR> <TR> <TD>�Է��� : <B><?php echo substr($_POST["ptright"],4);?></TD> <TD>���� : <?php echo calcage($_POST["dbirth"]);?></TD> </TR> <TR> <TD colspan="2">ᾷ�� : <?php echo $_POST["doctor"];?></TD> </TR> <TR> <TD colspan="2"> <TABLE border="1" align="center" width="300" bordercolor="#000000" cellspacing="0" cellpadding="0" style="font-family: Angsana New; font-size: 30px;"> <TR align="center"> <TD width="30"> <FONT style="font-family: Angsana New; font-size: 22px;">���</FONT></TD> <TD width="60"> <FONT style="font-family: Angsana New; font-size: 22px;">VN</FONT></TD> <TD width="90"> <FONT style="font-family: Angsana New; font-size: 22px;">�/�/�</FONT></TD> <TD width="50"> <FONT style="font-family: Angsana New; font-size: 22px;">����</FONT></TD> <TD width="50"> <FONT style="font-family: Angsana New; font-size: 22px;">���մ</FONT></TD> </TR>
}else{
//¤é¹ËÒ hn ¨Ò¡ hiv_vo ****************************************************************************************
$sql = "Select * From hiv where row_id = '".$_REQUEST["row_id"]."' limit 0,1";
$result = mysql_query($sql) or die("".mysql_error()." -->");
//echo $sql;
/*if(mysql_num_rows($result) <= 0){
echo "<CENTER>¼Ùé»èÇÂÂѧäÁèä´é·Ó¡ÒÃŧ·ÐàºÕ¹</CENTER>";
exit();
}*/
$arr_view = mysql_fetch_array($result);
//¤é¹ËÒÇѹà¡Ô´¨Ò¡ opcard ****************************************************************************************
$arr_view["age"] = calcage($arr_view["age"]);
////////////////////////////////////////
$datenow=date("Y-m-d");
/*$sqlvo="select max(vo_id )as vo_id from hiv_vo ";
$queryvo=mysql_query($sqlvo);
$arrvo=mysql_fetch_array($queryvo);
$vo=$arrvo['vo_id']+1;
$vo_no=$vo;*/
?>
<form name="f2" method="post" action="booking_edit.php?do=save" onsubmit="JavaScript:return fncSubmit();">
<table border="0" class="forntsarabun">
<tr>
<td colspan="7" align="center" bgcolor="#CCCCCC">у║и═зр╡╒┬з╝┘щ╗ш╟┬у╣</td>
</tr>
<tr>
<td>к╫ш═-╩б╪┼</td>
<td><label for="ptname"></label>
<input name="ptname" type="text" class="forntsarabun" id="ptname" value="<?php
echo $dbarr['ptname'];
?>
"/></td>
<td>═╥┬╪</td>
<td colspan="3"><label for="age"></label>
<input name="age" type="text" class="forntsarabun" id="age" value="<?php
echo calcage($dbarr['dbirth']);
?>
"/></td>
<td> </td>
</tr>
<tr>
<td>HN</td>
<td><input name="hn" type="text" class="forntsarabun" id="hn" value="<?php
echo $dbarr['hn'];
?>
" readonly="readonly"/></td>
<td>├╤║╗ш╟┬р┴╫ш═</td>
<td colspan="3">
<input name="date_in" type="text" class="forntsarabun" id="datepicker-th-2" value="<?php
echo $date_in;
?>
$thdatehn=$d.'-'.$m.'-'.$yr.$_POST["id_barcode"];
$today = date("Y-m-d");
$code21 = '21';
$thdatevn=$d.'-'.$m.'-'.$yr.$vn;
$case = $_SESSION["case_service"];
$sql = "Select * From opcard where hn = '".$_POST["id_barcode"]."' limit 0,1 ";
$result = Mysql_Query($sql);
$arr_member = Mysql_fetch_assoc($result);
$count = mysql_num_rows($result);
if($count>0){
$cYot = $arr_member["yot"];
$cPtname=$arr_member["yot"].' '.$arr_member["name"].' '.$arr_member["surname"];
$cPtright = $arr_member["ptright"];
$ages = calcage($arr_member["dbirth"]);
/*if (substr($arr_member["idguard"],0,4)=='MX03'){
$queue = "vip";
$print_case = "VIP";
$kew = "vip";
}else{
switch(substr($_POST["case1"],0,4)){
case "EX01" :
if(substr($arr_member["idguard"],0,4)=='MX01'){
$sql ="update runno SET runno = runno+1 WHERE title='kew1'";
</head> <body> <?php $_SESSION["hn_now"] = $_POST["txthn"]; ?> <p align="center"><a href="../nindex.htm">║ея╨Юа╧ыкея║</a> || <a href="drxray_hn.php">цп╨ь HN ЦкаХ</a></p> <? $select = "select * from opcard where hn = '".$_SESSION["hn_now"]."'"; $result = mysql_query($select); $row = mysql_fetch_array($result); ?> <div align="center">╙вХм╪ыИ╩Хгб : <u><?php echo $row["yot"] . $row["name"] . " " . $row["surname"]; ?> </u> мрбь : <u><?php echo calcage($row["dbirth"]); ?> </u> йт╥╦тЛ║рцця║ир : <u><?php echo $row["ptright"]; ?> </u></div> <TABLE border="1" align="center" cellpadding="2" cellspacing="0" bordercolor="#0046D7"> <TR> <TD> <TABLE width="800" border="0" align="center" cellpadding="0" cellspacing="2"> <TR align="center" class="tb_head"> <TD >XRAYNO.<//TD> <TD>DATE</TD> <TD>DOCTOR</TD> <TD>DETAIL_ALL (║╢╢ы©теаЛ)</TD> </TR>
if($item != false){
$notification = true;
}
?>
<form name="f2" method="post" action="booking.php?do=save" onsubmit="JavaScript:return fncSubmit();">
<table border="0" class="forntsarabun">
<tr>
<td colspan="7" align="center" bgcolor="#CCCCCC">㺨ͧ��§�������</td>
</tr>
<tr>
<td>����-ʡ��</td>
<td><label for="ptname"></label>
<input name="ptname" type="text" class="forntsarabun" id="ptname" value="<?=$ptname;?>"/></td>
<td>����</td>
<td colspan="3"><label for="age"></label>
<input name="age" type="text" class="forntsarabun" id="age" value="<?=calcage($dbarr['dbirth']);?>"/></td>
<td> </td>
</tr>
<tr>
<td>HN</td>
<td><input name="hn" type="text" class="forntsarabun" id="hn" value="<?=$dbarr['hn'];?>"/></td>
<td>�ѹ��� Admit</td>
<td colspan="3">
<input name="date_in" type="text" class="forntsarabun" id="datepicker-th-2" value=""/> <td>ex.22/04/2013</td>
</td>
<td> </td>
</tr>
<tr>
<td>DX</td>
<td><input name="diag" type="text" class="forntsarabun" id="diag" /></td>
<td>�Է���ѡ��</td>
print "<BR><font class='forntsarabun1'> HN ".$hn." ä´éŧ·ÐàºÕ¹áÅéÇ </font>";
print "<BR><font class='forntsarabun1'> µéͧ¡Òà <a href='hypertension_edit.php?p_hn=$hn'>á¡éä¢</a> ËÃ×ÍäÁè</font>";
//print "<META HTTP-EQUIV='Refresh' CONTENT='2;URL=hypertension.php'>";
}else{
$arr_view = mysql_fetch_assoc($queryht);
$y=date("Y")+543;
$d=date("d");
$m=date("m");
$date1=$y.'-'.$m.'-'.$d;
$opd = "Select * From opd where hn='".$arr_view["hn"]."' ORDER BY `thidate` DESC limit 0,1 ";
$result_opd = mysql_query($opd);
$arr_opd = mysql_fetch_array($result_opd);
$arr_view["age"] = calcage($arr_view["dbirth"]);
$height = $arr_opd["height"];
$weight = $arr_opd["weight"];
$cigarette=$arr_opd["cigarette"];
////////////////////////////////////////
$datenow=date("Y-m-d");
$sqlht="select max(ht_no)as htnumber from hypertension_clinic";
$queryht=mysql_query($sqlht);
$arrht=mysql_fetch_array($queryht);
$ht=$arrht['htnumber']+1;
$ht_no=$ht;
</tr>
<tr>
<td align="right" bgcolor="#66CC99"><strong>µÓáË¹è§ : </strong></td>
<td bgcolor="#CCFFCC"><input name="position" type="text" class="forntsarabun" value="<?php echo $position; ?>" size="15" /></td>
</tr>
<tr>
<td align="right" bgcolor="#66CC99"><strong>ªèÇÂÃÒª¡Òà (¶éÒÁÕ) : </strong></td>
<td bgcolor="#CCFFCC"><input name="ratchakarn" type="text" class="forntsarabun" id="ratchakarn" value="<?php echo $ratchakarn; ?>" size="15" /></td>
</tr>
<tr>
<td align="right" bgcolor="#66CC99"><strong>Çѹ/à´×͹/»Õ à¡Ô´ : </strong></td>
<td bgcolor="#CCFFCC"><input name="dbirth" type="text" class="forntsarabun" id="dbirth" size="15" value="<?=$dbirth;?>"/></td>
</tr>
<tr>
<td align="right" bgcolor="#66CC99"><strong>ÍÒÂØ : </strong></td>
<td bgcolor="#CCFFCC"><input name="age" type="text" class="forntsarabun" id="age" size="15" value="<?=calcage($rep["dbirth"]);?>" /></td>
</tr>
<tr>
<td align="right" bgcolor="#009999"> </td>
<td bgcolor="#009999"><input name='save2' type='submit' class="forntsarabun" id='save2' value='ºÑ¹·Ö¡¢éÍÁÙÅ'></td>
</tr>
</table>
</form>
<?
}else{
?>
<a href ="../nindex.htm" ><< ä»àÁ¹Ù</a> || <a href ="chk_year.php" target="_blank" >ÃÒª×èÍ·ËÒ÷Õèŧ·ÐàºÕ¹µÃǨÊØ¢ÀÒ¾</a>
<form name="form1" method="post" action="<? $_SERVER['PHP_SELF']?>">
<strong>ŧ·ÐàºÕ¹µÃǨÊØ¢ÀÒ¾·ËÒÃ</strong><br>
<table width="40%" border="0" cellspacing="0" cellpadding="3">
<tr>
