2-;R$?1祧WgբxakL!\ҦD /ЦK[XE2#\]E9Q2@iHEPjTCrn-$qÉ^ϔ- H= bݕ9>oSXo#5Cm4IR;ǐiz L;tӋ6 Y:OOAa$q_S^>фڗ<12o2B"<%At-s¿FK^ߢ3ndQQva[Z!^(RĎ2;n9  zjdD 5*=cE%qLA9&vB;"9)[njT"TaG[*&vH)Yzf Dzp6\BIEH!Feңwg3ۈ/7z4s0A$@#h e֝qr]Dv=kO0iJ7I.# ze(OUB9p6LŸ`k.,YRbCn9.})"EhBο<8;4!>W a5Ko6:#+bYЦ#Ic.W@%S9.;$/ZM=y`5EErV ۛEm0QV4o4+"s^LD}I q9]Ȋ%^= AeLM <>~PaDzN w;ާJG@ɢ^iB?nEXոNǢ Bc, S.>LIH7MRdgl&H ׵\BUwL.ZFTC1ԇkEܮ&#d fl}ROKvHqmf y/c<ᶦϡ5O”}y?8m^c_hs*^X0MpEer/B2az_uVD=B-V6ZG"(-v,p4x"O3is?`YE֢IW>Ar6}ot-]KZv,p4x"O3is?`YE֢Ibu-@*䈔6es@3j|f cWҰU-1yѻŨO_-Pqw 0Y\q䖱0RvCZ( uD:se.tc<;/@cpӓ.*^m7`{cFƚY)\B}!4aRyAl|ۏ;(w+}F `ɰ.6##y2m\0D-yEw4`Ǐ8)2KV# yéصA?$' 2gtnѿ÷%ꩻH~WUfʷ b?k>L+`kԥ0^S5ǬӤO#:Pa;})SLnC#.a{QMYItԢtA4GV;OQ\0<CPTv-1g/EY\T! ! Le?*k)|IR3$gOA_5ZKWBQS:f]}Z/ pt"4wX{Nt$8y ]uv g SS,~~7ΫG"RQ f⛳͑/n7']s/:zfrW@u@H]T+O~DY= ^c1^X>Î9x-L"bBakS&WC'D൑5&{R5 s$0f2 'I}*bP݄u`fR;mZ\%WPyc|q.Q6(^ cJɓ3:1Mo}n(Ez[d+K<\ zaFdG^8iE{RMsOO5PZ753n#rJ,z)( 3T^l=2=Ք Q^ϔ$i/R'D[toMqA5PA*8De"HDNaŋvuYMbp0+Gbhj{7 a(<25ܙҁ$&jsRa a+]ˆ5 T4ÓV;:qcW``v%\JA'ke˔H:žSH],m }Z٦o3t.͂YuLrBLA0.&uSxh]I-&4U$|7ֻى \CS8ƒӄ)@-naɟ N$S}N)A5_͂YuLrBLBOE`T=kʺ-Wk>ݫ![ &y A稇pǚo7pԸI{u!!?1YE<ˊu Uյ<0O;`ujN&}-OWۉr~ 8r%*{2MGt5ko9n {;[ɂkah*E$H`ȭtύg{땰Xb AIio95wt߾ˬJ[Sg XOCD$!C/Yp.mRBՠ,3i$*gbi[y8Þo_XS Zn]UA--"eKw??~rOxrk=f>6 J3~h)D.` *[,$С4g}!sWzTTF?\$An41!Y\~6aƸ4Ao # n;6 v㛏 s8 ^PNBn8n%Uu:湂Ӂ{۞R`yȁ0yˈb*0fĴ D1pZ!ДNDa iL(4 2-[i(TT)*ԣqG)s~`+861[jl+`ƣZ٦o3t.;ӯyjprE5^%Zޚ"dXe5DY*g1Iغ|MQ T>CEiu/}5'C u[PA4v]'K1{\MdP.;2,;5|fm patientTestsSummary where patientID='$patientID' and visitNo='$visitNo' and labNo='$labNo' " ); if($cur==""){ $query="insert into patientTestsSummary(time_,userID,labNo,date_,patientID,visitNo,amount,paymentType,discount,paid) "; $query.= " values(getdate(),'".$_SESSION['userID']."','$labNo','$date_','$patientID','$visitNo','$amount','$paymentType','$discount','$paid') "; }else{ $query="update patientTestsSummary set amount='$amount',discount='$discount',paid='$paid' "; $query.= " where labNo='$labNo' "; } $cur= odbc_exec( $conn, $query ); echo ""; } if(isset($_POST['btnSaveTest'])){ $patientID = $_POST['patientID']; $visitNo = $_POST['visitNo']; $labNo = $_POST['labNo']; $testname = $_POST['testname']; $discount = $_POST['discount']; $paymentType = $_POST['paymentType']; $date_ = date('Y-m-d',strtotime($_POST['date_'])); $doc = date('Y-m-d',strtotime($_POST['date_'])); //$discount=0; $paid=0; //if ($labNo=="NEW") $labNo=getname($conn,"select max(labNo)+1 from patientTests where patientID='$patientID' and visitNo='$visitNo'"); if ($labNo=="NEW") $labNo=getname($conn,"select isnull(max(labNo),0)+1 from patientTests"); $testID=getname($conn,"select ID from testlab where testname='$testname'"); $cur= odbc_exec( $conn, "delete from patientTests where patientID='$patientID' and visitNo='$visitNo' and labNo='$labNo' and testID='$testID' " ); if($discount==""){ $discount=0; $query="insert into patientTests(time_,userID,testID,labNo,date_,doc,patientID,visitNo,testCharges,paymentType) "; $query.= " select getdate(),'".$_SESSION['userID']."',ID,'$labNo','$date_','$doc','$patientID','$visitNo','$discount','$paymentType' from testlab where testname='$testname'"; }elseif($discount>0){ $query="insert into patientTests(time_,userID,testID,labNo,date_,doc,patientID,visitNo,testCharges,paymentType) "; $query.= " select getdate(),'".$_SESSION['userID']."',ID,'$labNo','$date_','$doc','$patientID','$visitNo','$discount','$paymentType' from testlab where testname='$testname'"; }else{ $query="insert into patientTests(time_,userID,testID,labNo,date_,doc,patientID,visitNo,testCharges,paymentType) "; $query.= " select getdate(),'".$_SESSION['userID']."',ID,'$labNo','$date_','$doc','$patientID','$visitNo',Charges,'$paymentType' from testlab where testname='$testname'"; } $cur= odbc_exec( $conn, $query ); //$cur= odbc_exec( $conn, "delete from patientTestsSummary where patientID='$patientID' and visitNo='$visitNo' and labNo='$labNo' " ); //$amount=getName($conn,"select sum(testCharges) from patientTests where patientID='$patientID' and visitNo='$visitNo' and labNo='$labNo' "); //$query="insert into patientTestsSummary(time_,userID,labNo,date_,patientID,visitNo,amount,paymentType,discount,paid) "; //$query.= " values(getdate(),'".$_SESSION['userID']."','$labNo','$date_','$patientID','$visitNo','$amount','$paymentType','$discount','$paid') "; //$cur= odbc_exec( $conn, $query ); $amount=getName($conn,"select sum(testCharges) from patientTests where patientID='$patientID' and visitNo='$visitNo' and labNo='$labNo' "); $cur= getName($conn, "select 1 from patientTestsSummary where patientID='$patientID' and visitNo='$visitNo' and labNo='$labNo' " ); if($cur==""){ $query="insert into patientTestsSummary(time_,userID,labNo,date_,patientID,visitNo,amount,paymentType,discount,paid) "; $query.= " values(getdate(),'".$_SESSION['userID']."','$labNo','$date_','$patientID','$visitNo','$amount','$paymentType','$discount','$paid') "; }else{ $query="update patientTestsSummary set amount='$amount' "; $query.= " where labNo='$labNo' "; } $cur= odbc_exec( $conn, $query ); //add for investigation/Tests only if("0"==getname($conn,"select typeofService from testlab where id='$testID'")){ //check if test not already added to investigation if("1"!=getName($conn,"select 1 from investigation where labNo='$labNo' and (testid='$testID' or testid in (select id from testlab where head_id='$testID') )")){ $a1=add2Invest($conn,$testID,$patientID,$date_,$labNo,$visitNo); } } //echo "receipt"; //echo ""; echo ""; } function add2Invest($conn,$testID2,$patientID,$date_,$labNo,$visitNo) { //$qry2="delete from investigation where labNo='$labNo' and (testid='$testID2' or testid in (select id from testlab where head_id='$testID2'))"; $qry2="delete from investigation where labNo='$labNo' and testid='$testID2' "; $run1=odbc_exec($conn,$qry2); //echo "
".$qry2; $qry2="insert into investigation (userID,patientid,testid,head_id,date_,labNo,visitNo) select '".$_SESSION['userID']."','$patientID',id,head_id,'$date_','$labNo','$visitNo' from testlab where head=0 and id='$testID2' "; $run1=odbc_exec( $conn,$qry2); //echo "
".$qry2; $qry2="insert into investigation (userID,patientid,testid,head_id,date_,labNo,visitNo) select '".$_SESSION['userID']."','$patientID',id,head_id,'$date_','$labNo','$visitNo' from testlab where head=0 and head_id='$testID2' "; $run1=odbc_exec($conn, $qry2); //echo "
".$qry2; $qry2 ="select id,testunit,head from testlab where head=1 and head_id='$testID2'"; $run1 = odbc_exec( $conn,$qry2); while( odbc_fetch_row( $run1 ) ) { //echo $testID2= odbc_result( $run1, 'id' ); $a1=add2Invest($conn,odbc_result($run1,'id'),$patientID,$date_,$labNo,$visitNo); } return (0); } if (isset($_GET['delID'])) { $patientID = $_GET['delID']; $testID = $_GET['testID']; if(canDelete($conn,"patientTests")=="0"){ $query = "delete from patientTests where patientID='$patientID' and testID='$testID' and labNo='$labNo' "; $cur= odbc_exec( $conn, $query); $a1=add2Delete($conn,$testID,$patientID,$labNo); $amount=getName($conn,"select sum(testCharges) from patientTests where patientID='$patientID' and visitNo='$visitNo' and labNo='$labNo' "); if($amount>0){ $query="update patientTestsSummary set amount='$amount' where labNo='$labNo' "; $cur= odbc_exec( $conn, $query ); }else{ $cur= odbc_exec( $conn, "delete from patientTestsSummary where labNo='$labNo' " ); } } } function add2Delete($conn,$testID2,$patientID,$labNo) { //$qry="delete from investigation where testid ='$testID2' and labNo='$labNo' "; //$cur= odbc_exec( $conn, $qry ); //echo "
".$qry $qry="delete from investigation where labNo='$labNo' and (testid ='$testID2' or testid in (select id from testlab where head_id='$testID2'))"; $cur= odbc_exec( $conn, $qry ); $qry ="select id,testunit,head from testlab where head=1 and head_id='$testID2' "; $run1 = odbc_exec( $conn,$qry); while( odbc_fetch_row( $run1 ) ) { //$testID2= odbc_result( $run1, 'id' ); $a1=add2Delete($conn,odbc_result($run1,'id'),$patientID,$labNo); } return (0); } $patientName=getName($conn,"select name from patientTab where patientID='$patientID' "); echo "
"; echo ""; echo "
Lab No : "; ?> < Go Back"; //echo " Home Page"; echo "
"; echo "
"; echo "
"; echo ""; echo "
Name"; echo "
Date"; echo "
Visit No."; echo "
Lab No"; echo "
Discounted Rate"; echo "
Test"; echo ""; //echo fillList($conn,"select distinct testname from testlab where head=1 and show1=1 order by testname"); echo fillList($conn,"select distinct testname from testlab where show1=1 order by testname"); echo ""; echo "
Payment Type"; echo "
"; echo "
"; /* echo "		"; echo "
"; echo ""; echo ""; echo ""; //echo "
Name"; echo "
Date"; //$amount=getName($conn,"select sum(amount) from patientTests where labNo='$labNo' "); if($labNo>0) $amount=getName($conn,"select sum(testCharges) from patientTests where patientID='$patientID' and visitNo='$visitNo' and labNo='$labNo' "); echo "
Amount"; if($labNo>0) $discount=getName($conn,"select discount from patientTestsSummary where labNo='$labNo' "); echo "
Discount"; if($labNo>0) $paid=getName($conn,"select paid from patientTestsSummary where labNo='$labNo' "); echo "
Paid"; echo "
Payment Type"; echo "
"; echo "
"; */ echo "
"; if(isset($_POST['btnRemarks'])){ $remarks = $_POST['remarks']; $labNo = $_POST['labNo']; $testID = $_POST['testID']; $patientID = getName($conn,"select patientID from patientTests where labNo='$labNo'"); $visitNo = getName($conn,"select visitNo from patientTests where labNo='$labNo'"); $cur= odbc_exec( $conn, "update patientTests set remarks='$remarks' where labNo='$labNo' and testID='$testID' " ); echo ""; } $tMargin =round(getName($conn,"select openingBalance from AccountHeads where headType='testReportMargin'")); if($tMargin=="")$tMargin=30; $query="select * from patientTests where patientID='$patientID' order by visitNo desc,date_ desc,labNo desc"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) { echo "
#DateVisitlabNoTestChargesDeleteReceiptResultallSingleBar1Bar2Remakrs"; //echo ""; //echo ""; } $visitNo= odbc_result( $cur, 'visitNo' ); $labNo= odbc_result( $cur, 'labNo' ); $date_ = date('Y-m-d',strtotime(odbc_result( $cur, 'date_' ))); $testCharges= odbc_result( $cur, "testCharges" ); $testID= odbc_result( $cur, 'testID' ); $remarks= odbc_result( $cur, 'remarks' ); $testname = getName($conn,"select testname from testlab where id='$testID'"); //$row['testname']; echo "
". $cnt++ . "$date_$visitNo$labNo"; echo "$testname"; echo "$testChargesdelete"; /* $maxHeight=31*getName($conn,"select count(*) from patientTests where labNo='$labNo'"); echo ""; */ echo "receipt"; echo "resultall" ; echo "single"; echo "barcode"; //echo "barcode"; //echo ""; echo ""; echo ""; echo "
"; echo ""; echo ""; echo "
"; echo ""; echo ""; } echo "
"; // // //echo "
Hellow
"; odbc_close($conn); ?>