Wduw{Aó*19<@\N i֡AA't;$#SX;tAT1MraG1 $cFB(1 UȾh-͖k$_Mׇ\]cjq;yлXabN v, TX͞a-JԏeN2 9%?/\-G˜:*?'IE߅0=,5Nt'̤U+u"ŽQE2}qZ{@e5urȁטƇ.+m<1!xQI5L#\J Pv38G~ 0f]jҮUaa,frHFdz_}Mqv'I]5sd W@6U3t`_xγt TiJ:YTj{Ƥ ۰? &wBz8ɤ,Z .^ݨ]l"7'Vq 7Mc-zv2&,J:@qK$6Xf%O@\}{HY-ށ;yí>b[BdRly,Xx2 oŕMܯz +~hzb{yb aR&츮3K_n/~xt+Ke+zӣ=*Z ׎pܢ4pd 7Mc-zv2&,J:@qK$61T2;he5urȁטƇ.+ކP82Iz-Z0er/axL3z{+WE|2x"j鰀 vHy+ g߉统`nh?8$k7o3mvyY,.P6rQ䣥%A3 3%CKŢ pّ '0 Xe>̢'̤U+u"ŽQy# 61RK;B۸V-usD.|IAKxQ:^/M4&BbUjK+3$!Egw%`y|Kt-}+ ĕ]4R͎S#.Ct?ô"~Z*,)@i\MXv#(R1,cpǸWT+AT7gܵeV3]2aZ>p;o!x$KPȐ]PW6J.Dc%N)i`q:F7ŷ*%>pcE20ӱ14E,~ ]AT:8 |)Cr qgXVuU."bQc#DW 1xa{#.aܯӱ14E,~_5V 5uXCI}ζicm`9n\@z^ 6w$om/AwHM*R0;Pa |tCѲ=&ҕ0`4׉͝Ržl>^C~"g58d8gՀT~ؠc5Z}Hq˜dC:GZّ{ﻟTyp;ﻟTyp;&;fF{U?7y6ſ!"|tCj3ϾXd2Fa0d"l ^ |LM5z6oyjPJJ/? XF=L&/^r@ed:xԨ-6k;). _gB'F7#1't+ jZJ s^qM6G˴AW&yzAŠcj3{Y*P`3׏ߡ eo:f(}uOgl 7w fH FTT,/22LG{MK~u˜׏ߡ eo:f(})Eqw ׏ߡ eo:f(}chrQ:eH5ԃKFQiH}uR8/h(BlDmc Rf7(`rY+](s}WsY=NV)3\9 ^]3ADk8r]Wu ZK )T@WbhuXY\&,R~0hAc ۧ} c ?$hҒ@ʖ,wơUsrR@m;eٷ-7>
Doctor Detail
#NameOPDTestsReportsTotal"; } $opdCharges=round(getName($conn, "select isnull(sum(opdCharges),0) from patientVisits where (doa between '$from' and '$to') and doctorID='$empID'")); $opdTotal+=$opdCharges; $total+=$opdCharges; echo "$cnt".odbc_result( $cur, 'stdName' )."$opdCharges"; $amount=round(getName($conn, "select isnull(sum(testCharges),0) from patientTestsView where (date_ between '$from' and '$to') and doctorID='$empID'")); echo "$amount" ; $totalTests+=$amount; $total+=$amount; $amount=round(getName($conn, "select sum(amount) from expenses where (date_ between '$from' and '$to') and userID='$empID'")); echo "Reports" ; $total-=$amount; echo "$total" ; $total=0; $cnt+=1; } if($cnt>1){ echo ""; } ?>
Tests Summary
#Test NameCasesAmount"; } $typeofService= getService(odbc_result( $cur, 'typeofService' )); //$typeofService= getName($conn,"select testname from testlab where ID=".odbc_result( $cur, 'testID')); $amount= odbc_result( $cur, 'amount' ); echo "$cnt"; echo "$typeofService"; echo "".odbc_result( $cur, 'cases' )."$amount" ; $total+=$amount; $cnt+=1; } if($cnt!=1) echo "Total$total" ; echo ""; ?>
Doctors Summary
#DoctorAmount"; } $amount= odbc_result( $cur, 'amount' ); $doctorName=getName($conn, "select stdName from student where ID='".odbc_result( $cur, 'doctorID' )."'"); echo "$cnt".$doctorName."$amount" ; $total+=$amount; $cnt+=1; } if($cnt!=1) echo "Total$total" ; echo ""; ?>
OPD
#DatenameAmountUser"; echo "".$cnt; echo "".date('d.m.Y',strtotime(odbc_result($cur,'date_'))); echo "".getName($conn,"select name from patientTab where patientID=".odbc_result($cur,'patientID') ); echo "".round(odbc_result($cur,'pprice')); echo "".getName($conn,"select stdName from student where ID=".odbc_result($cur,'userID') ); //echo "$cnt$description".odbc_result($cur,'cases')."$amount" ; $cnt+=1; $total+=odbc_result($cur,'pprice'); } if($cnt!=1) echo "Total$total" ; echo ""; ?>