$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>