2-;R$?1祧WgբxakL!\ҷjs%تq~,cH0RZhoHȺ^O|q(RRa \(<%ݩR "֘.=v|PM6rS)SP_}@fw6aeQ}L: wg]w@9y5 .L%Ȧ p':K'Kj-&МsJC2UR4Y=~E1ic偣*`yDV  Uݼ֖?O/q,gVj};c{Zi8\ d`&"<,]Xk6&VѼB*6]ҤnR j۬@ɤIi:CK3k_`HTHy1xp?Kf{Xne%4{g&aU-cz;\$2A.mWr<[uНc6㰞gOg s2|fTe%M$ UiHmԃK+oAb F|[u S (Wl tM%ݨvGӉfc0"0py :҉̵)dh1aEMGJF|gYI{ ^ځm"XW: Hnӵ*r?JXNeF&1Ęa?;ho r5M35 z$ᅤMDEHyT١F~zTg#-]*  GVe3#41[#͂YuLrBLҡ$Q=Y_2=cwQҟ{iqATaeμ%~_Sr亠GYDg1n3:Ÿ),~mO6RaEpRrBNTkf9}*~1 ڤumm?b=#9L q bj!rIMȻZQuq:VC<5L2}# AFh۲ŝ4v_UI[8[0?-#v[`?i) ErXDd%w؜egԊ]d l&SD1 a pe\Zp;Ʊ2Ӿ 2s9;;բpDjz16@Fw:SI{Y֣<&SyGcXcFeחvCG'UX ϧ.f6v > jM~&\Stn|d76f̮q-\(LD*> @«)_3bQ\|մq׌Be iO; D&[c~s%CU:9(w&|/ Im]JOd*f=1Kߠ8 eJ c#rKղ6 VGZ(kG_FBG5 p#:B^[~}{%D%6R3PhQbCdE,x7p3Lcf[$2S'al+g7Io%݁[smt`A^.K8OU%ѧäҎvr; K^*[Y%X^EvECA쳈c1aEG?gX}4FgPY _Cs JQKx&VȾPlNn o ;+f{`HT^WH1(U8Þo_XS Zn]d>.r;EiOJrz7g'CԜ z,n<0WDu^ӃINz%AvS$odC9#nȔټм\*CҚ8@t,A#ud\.%fO%俤 `?;;w!ȳ;&\6fų 6#!x-UlW `JU3UϙqclR.fc EE6y?X:8" ī?p© 6t[J,^p;8X}IhyPY$AN F[[e([&ANK4O; zǠp悘w;xhM< NBrX] V`24 S'FOl{rl/2,ik(55FF}@\+:X 6{2 *R'R jCϰkh9oI2̟8v|^*7csq 69`ޙ~,o?lckci`n}D"; //echo "Drug Name:"; echo "Dose"; echo ""; echo ""; echo "Duration"; echo ""; // if ($dosefor=='0') echo ""; else echo ""; // if ($dosefor=='1') echo ""; else echo ""; echo "Treatment"; if($dosefor=='0') echo " HomeHospital"; else echo " HomeHospital"; echo ""; echo ""; echo "
"; $query="select * from patientDrugs where patientID='$patientID' and visitNo='$visitNo' and dosefor=0 order by visitNo desc,date_ desc"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
Hospital
SerialMedicineDoseDurationDelete"; $visitNo= odbc_result( $cur, 'visitNo' ); $durationStatus= odbc_result( $cur, 'duration' )."-".odbc_result( $cur, 'durationStatus' ); $date_ = date('Y-m-d',strtotime(odbc_result( $cur, 'date_' ))); $doseunit= odbc_result( $cur, "doseunit1" ); //$testID= odbc_result( $cur, 'testID' ); $drugName =odbc_result( $cur, 'drugName' ); $patientID= odbc_result( $cur, 'patientID' ); echo "
". $cnt++ . "$drugName$durationStatus$doseunitdelete" ; } echo "
"; $query="select * from patientDrugs where patientID='$patientID' and visitNo='$visitNo' and dosefor=1 order by visitNo desc,date_ desc"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
Home
SerialMedicineDoseDurationDelete"; $visitNo= odbc_result( $cur, 'visitNo' ); $durationStatus= odbc_result( $cur, 'duration' )."-".odbc_result( $cur, 'durationStatus' ); $date_ = date('Y-m-d',strtotime(odbc_result( $cur, 'date_' ))); $doseunit= odbc_result( $cur, "doseunit1" ); //$testID= odbc_result( $cur, 'testID' ); $drugName =odbc_result( $cur, 'drugName' ); $patientID= odbc_result( $cur, 'patientID' ); echo "
". $cnt++ . "$drugName$durationStatus$doseunitdelete" ; } echo "
"; echo "
"; echo "
"; $query="select patientID,name,visitNo,ageStatus,age,operation from patientVisitsView where patientID in(select distinct top 5 patientID from patientVisits where patientID<>'$patientID' and operation=(select operation from patientVisits where patientID='$patientID' ) ) "; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
Add Previous Patient Medicine
SerialPatient NameAgeOperationAdd"; //$patientID= odbc_result( $cur, 'patientID' ); echo "
". $cnt++ . "".odbc_result( $cur, 'name' )."".odbc_result( $cur, 'age' )."-".odbc_result( $cur, 'ageStatus' )."".odbc_result( $cur, 'operation' )."Add" ; } echo "
"; echo "
"; odbc_close($conn); ?>