Wduw{Aó*19üEwxLT)Z 2e;[cg6TS{* \ jCE_VtC & R6:D~=,@IL8 !ۙj>ub}r]oP0̰Mc{8 i-齗Y؞::6p[.K{,-,__ HW|" H]{dZyh`n S7zeZZ:SB|~ 6I8pOS(f(e^W O_Nww%‹遬svśF/̿ T$I%XB[+vsJA/I3{X0ȰznM; |mI݄H ɿGKUӥRU~D逝]y@=f:A07x: S F/bqɫ'jJgNr${@-kOp\nGY)vGy9eO ᓛw-+qc.zhC?'Cf\&h!g kO=3qNHSakr/ɴDAS IjۖKE0Op[ۨدY')&" Z=Mƺ͕YUr JM(!a+ {9O5V䐓cl%L']4_̎F[;=veVʮps  ZY 1?1VڼTĤO2zRHK mDD/6-33:[dps  ZY 1?1VWB?[n@ ! jQJ6ˆ7b5υ#DxIQkkٰZr}W3PEbtˤx=vVxp$bVx㴐u:I<κȺ r_kHP#W5ru:I0,\`j^DD]a2ȸށUD(if2G!2jZLB^}̡VﻟTyp;ﻟTyp;ﻟTyp;8Jw5\xԸˠW:D`ha3ݎ<-?# wѪ?hf@'i5/*>,Bdo RɃnO-w'd]kFY]uem d|X1kv,_ꀗ]s )gAVZ;q 5"]bhPˬ̉C2WV^nv1z*p+> Gݨ?X`よ;SɃSUEf"ZE"?JV Vd!LT2~]M\0O'OL>1>Rʰ㉞Mi Xxo\ZGA>!pn$c~ SEE-oX#n%'r zn@j|M]Ep8Y3L6/6hHwhouP2ֿ ֒8+>Zk~F s D8a0Co5-jhUX>m%Pdle-˯mq !2ac|boD]WI>G?wVU9Z> I`d4̮zjL77)}B)_Z+{x+ܑy<9!-d(<*KQΜ>DŞ<tr_P9,VuKٓ49|n==Lz~EH Duq$iS0`@}ߧ~jbF-,mz!"ߌ5_E2*L85\'e#~-g'bJ aK'$X0pLA %ZJ`#[MAR!x;<`ګN4g`8 00V c%wϒLl!IaaBM6좘 0<CPTcX:nQm0*%Te [Jʉk;V6 aRк&g,HHe@zsVxП5d[vd;IPuJ/ J៓d:1Gg^W]6&{3W^g3 RbjQző3,H9pe/+vX_ಕd2g%H WHrPZ$%6~Ջ s8זߨ{[`^ v'#d~6nxX<+ZFW4kעLX{ .Hm'sU:u$k~L {boa<3ܣۉr~ 86xYo ]$W&PvЌ[(F.tE׌jcLdp:%~]h42ܥw8Gy38G~oksnMiQz ]y`Z_]kB?k3iڭ ^ d%,U}EInW2b 4g]ܳ 1ovlH` xꧠ]$@XL¨? ?߽8*^0w nYeԕȩwTPX}ISQVL.#oTq:뇜a/,azE+ Mud/$ڗ 1`bq(ƮCxxu# ?p*+f[pUb|T 4w:&Nc-*:{'=R?taB;QZΝS.4i<-M 7Mc-zv2&,J:@qK$6ZF22:bL$h$U`})ejXڟXDVIC̾ʯ%0/r CM\3C+"+?RD+ oˏ wn>q5 UҪ_W"xph ?ӕ\$oMM2Sb?G3ЎZbnoH(XJx}7vCXA#JQ.h`Lga-vnAq8bʾ $fee= $_POST['fee']; $aptNo= $_POST['aptNo']; if($aptNo=="") $aptNo=getName($conn,"select isnull(max(aptNo),0)+1 from appointment where doctorID='$doctorID' and forDate='$forDate'"); if($autoID==""){ $autoID=getName($conn,"select isnull(max(autoID),0)+1 from appointment"); $query="insert into appointment (fee,aptNo,time_,date_,forDate,gender,remarks,doctorID,autoID,name,address,contacts,userID,labid)"; $query.=" values('$fee','$aptNo',getdate(),'$date_','$forDate','$gender','$remarks','$doctorID','$autoID','$name','$address','$contacts','".$_SESSION['userID']."','".$_SESSION['labid']."')"; }else{ $query="update appointment set aptNo='$aptNo',forDate='$forDate',gender='$gender',remarks='$remarks',contacts='$contacts'"; $query.=",doctorID='$doctorID',fee='$fee',address='$address',userID='".$_SESSION['userID']."',name='$name' "; $query.=" where autoID='$autoID' and labid='".$_SESSION['labid']."' "; } //echo $query; $cur= odbc_exec( $conn, $query ); echo ""; } if(isset($_POST['find'])){ $keyword= $_POST['keyword']; } if (isset($_GET['showid'])) { $autoID = $_GET['showid']; $query = "select * from appointment where autoID='$autoID'"; //echo $query; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { $name= odbc_result( $cur, 'name' ); $date_ = date('Y-m-d',strtotime(odbc_result( $cur, 'date_'))); $forDate = date('Y-m-d',strtotime(odbc_result( $cur, 'forDate'))); $contacts= odbc_result( $cur, 'contacts' ); $address= odbc_result( $cur, 'address' ); $doctorID= odbc_result( $cur, 'doctorID' ); $remarks= odbc_result( $cur, 'remarks' ); $gender= odbc_result( $cur, 'gender' ); $aptNo= odbc_result( $cur, 'aptNo' ); $fee= odbc_result( $cur, 'fee' ); } } echo ""; echo ""; echo ""; echo ""; //echo "
Date"; echo "
Appointment_Date "; echo "
Appointment_No."; if($doctorID=="") $doctorID=getName($conn,"select doctorID from appointment where autoID=(select max(doctorID) from appointment)"); echo "
Doctor "; echo "
Name "; if($gender=='0') echo " Male Female"; else echo " Male Female"; echo "
"; echo "
Contacts"; echo "
Address"; echo "
Remarks"; echo "
Fee"; echo "
"; echo "
"; $autoID= ""; $name= ""; //odbc_close($conn); ?>
"; echo ""; echo "
Search "; echo "
"; if ($keyword!="") $query= "select * from appointment where autoID>0 and (doctorID like'%$keyword%' or name like'%$keyword%' or aptNo like'%$keyword%' or contacts like'%$keyword%') order by name"; else $query= "select * from appointment where autoID>=0 order by autoID desc"; //$query= "select * from appointment where autoID>=0 and doctorID=(select max(doctorID) from appointment) order by aptNo asc"; //echo $query; echo "
"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
S.#DateApt No.NameAddressContactEDITSlip"; $date_= date("d-m-Y", strtotime(odbc_result( $cur, 'date_' ))); $forDate= date("d.m.Y", strtotime(odbc_result( $cur, 'forDate' ))); $autoID= odbc_result( $cur, 'autoID' ); $name= odbc_result( $cur, 'name' ); $address= odbc_result( $cur, 'address' ); $contacts= odbc_result( $cur,'contacts'); $doctorID= odbc_result( $cur,'doctorID'); echo "
$cnt$forDate".odbc_result( $cur, 'aptNo' )."$name$address$contactsedit" ; echo "Slip"; $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; echo "
"; ?>