r;5&MBm6k9dd: 5U\P|2= .Hm'seOwps@;Vt㪤ͣa\<'%3^t,,t}](ijhx 1gb?{;Vt㪤ͣa\<'%3ݮ,(8hx 1}8[3Q4\aF/CMY#u S8'蠛+h@nDx6]fu`Ӛ+#J+!dF&ᵤ6㰞gOi`i"rk= %)h_FS PO-TJ/j(nETG9,jnR[ƾ$>ҤmҐ+؅`eTPT͛3|Pνyo-m6:Bt+ %+y1Ңz@CWz2a6Dq'ezj}h [hbª@Y DwhLOc56/ܿY ٻ2].Ƃ2O'q>y^rdoO 7U:Z^v)X>Î9x-ÎvB}ÇEp[cAtӷH}T 2'_R5tzES4X 6/)+HMZ= =uS簃rP'D"aVWOư_9`}լ@Q2Qb PpK|1)gu|̥` Cc̄| O? N5"\iD>dE鏕qRHkNZAe)Cp;}uUnԅ)Ԡd:'/=!J 5[Kn2Bdb.S1KQY:BUFzhXrir ׈6gUY>LtzESy)WtX򇳠@r0rxfq/cyBn$ܗb𿠜 1fc e`(ԥ0^S5ǬӤO#~J̳aꧾ#BPQϝN@ Lc 9C.^ǣOD$4WrK!Ÿ7kV +M64¾ӛ{Y qEExn-Tsn5ѯ 7}[ypjwYW:{D:_j˭$Æ*S 2~8 ]|ȿiBRt"]#dty)lH2 %nF|U3z7rZH*y;=0wĦ`ٔJ"a+Dڿ%,@(bƝ50Gy52N?=ƕh] >Xމ<53 rT?bu(-ZsKWN;d~C&L3xsNvD!OKB_aOU֝9#rBMOdje&-ԝi$8Ts`TmPQnd zHJw=Lj53 rT?bS|v2)wb){F~TQ{"!AKj&Qgo]J5H3ʑ"(X'v?;'] eqzMJ.<;]1U)S)-h-&v}B k=hM(^v1E=|_q .@ڗVx;@#u7ЇBt j|dBEu5* sZ%,Ǐʵ7hPzwy^.ݿ.h[<WP{GR~M更 2r:q-@~|[oo&(_@JCU}fqJ`%.)$B +ťkKqw|t XY#_ό j\*1pjR'ȫj -./\1LzsR|${Hj[,$С4g}q2ȝ.Ƃ2O'q>y,eo)\ZNKM%$QU-ia*6 X2BXPxoZڸỏtL_c}_ܶ 8FLHŴ\X`-y]W,>gD[9Ь5P+ynґGq ޭI ^DXr' E)W. {-F(:żEEPyihJ[{M9/Qmkq iޖl-gpnN.M mrR\?d Ssr @+7.}Ab Kc,|BcTgN%I$_#@BdC-\^ICml=rRK' ٖ>r$<:tY/J NBwbAf|H 봺/ذ+G 6 Usa]Lą*3QwFKowQQr9ywh8Kƨ-Rә_+H +[ ՠT?4 _KYCc6M Q:22(q^}jTSkK8O3'\HﺲRhP@qAfx iGhk\Vv̂C0]&R/OL 513<ÊlF+=ߏl},͏oXlB~1p'*  GVe3xh 컳/V UZ&YʋaZHi5X=c͞Rx٩rYiG&{F~TQ{"!AKjֳ 1+}ڄ};3,pΔXo0O>c]|ȿiBRr^o׃$| ( odbc_fetch_row($cur1)){ //$query.=" from testlab where id='".odbc_result($cur,'id')."' "; $ret=addSubTest($conn,odbc_result($cur1,'id'),$newid,$labid); //echo "
".$query; } return (0); } $childRange1=$childRange2=$subDetail=$range2= "";$default_= ""; $order_= ""; $head_id= "";$testname= ""; $charges= "";$date_= "";$id= "";$Department= "";$anyvalue= ""; $testname= ""; $typeofService=""; $Status=0;$id="";$Salary=0;$date_ = date('Y-m-d',time()); $from = date('Y-m-d',time()); $to = date('Y-m-d',time()); $upper_=$lower_=$searchNames="";$unit="";$range=""; odbc_exec( $conn, "update testlab set childRange1=testrange where childRange1 is null" ); odbc_exec( $conn, "update testlab set childRange2=testrange where childRange2 is null" ); odbc_exec( $conn, "update testlab set LabID='$labid' where LabID is null" ); //odbc_exec( $conn, "ALTER TABLE testlab ALTER COLUMN testrange varchar(300)" ); //odbc_exec( $conn, "update testlab set range2=testrange where range2 is null" ); //odbc_exec( $conn, "update testlab set subHead=head_id where subHead is null" ); //odbc_exec( $conn, "update testlab set mainHead=head_id where mainHead is null" ); if(isset($_POST['btnSearch'])){ $head_id=$_POST['head_id']; $typeofService = getName($conn,"select typeofService from testlab where id='$head_id' "); } if(isset($_GET['head_id'])) { $head_id=$_GET['head_id']; $typeofService = getName($conn,"select typeofService from testlab where id='$head_id' "); } if(isset($_POST['btnSave'])){ //$userID =$_SESSION['UserID']; $head_id= $_POST['head_id']; $testname= $_POST['testname']; $searchNames= $_POST['searchNames']==""?$_POST['testname']:$_POST['searchNames']; $testunit= $_POST['unit']; $testrange= $_POST['range']; $range2= $_POST['range2']; $range2= $_POST['range2']==""?$_POST['range']:$_POST['range2']; $default_= $_POST['default_']; $order_= $_POST['order_']; $subDetail= $_POST['subDetail']; if($order_=="") $order_=getName($conn,"select isnull(max(order_),0)+1 from testlab where head_id='$head_id'"); $charges= $_POST['charges']; $id= $_POST['id']; $head= $_POST['head']; $show1= $_POST['show1']; $lower_= $_POST['lower_']; $upper_= $_POST['upper_']; $subHead= $_POST['subHead']; $mainHead= $_POST['mainHead']; $typeofService= $_POST['typeofService']; $childRange1= $_POST['childRange1']; $childRange2= $_POST['childRange2']; $level_ = getName($conn,"select level+1 from testlab where id='$head_id' "); if ($id=="") { $id= getName( $conn, "select max(id)+1 from testlab" ); $query = "insert into testlab (childRange1,childRange2,upper_,lower_,subDetail,subHead,mainHead,range2,default_,order_,searchNames,typeofService,LabID,show1,head,head_id,level,id,testname,testunit,testrange,charges) "; $query.=" values ('$childRange1','$childRange2','$upper_','$lower_','$subDetail','$subHead','$mainHead','$range2','$default_','$order_','$searchNames','$typeofService','$labid','$show1','$head','$head_id','$level_','$id','$testname','$testunit','$testrange','$charges')"; if(canSave($conn,"addTest")=="0") $cur= odbc_exec( $conn, $query ); }else { //odbc_exec( $conn, "delete from testlab where id='$id'" ); $query = "update testlab set childRange1='$childRange1',childRange2='$childRange2',upper_='$upper_',lower_='$lower_',subDetail='$subDetail',subHead='$subHead',mainHead='$mainHead' ,range2='$range2',default_='$default_',order_='$order_',searchNames='$searchNames',typeofService='$typeofService',show1='$show1',head='$head',head_id='$head_id',level='$level_',testname='$testname',testunit='$testunit',testrange='$testrange',charges='$charges' where id='$id' "; if(canUpdate($conn,"addTest")=="0") $cur= odbc_exec( $conn, $query ); } //echo $query; //odbc_exec($conn,"update testlab set subHead='$subHead' where head_id='$head_id'" ); //odbc_exec($conn,"update testlab set mainHead='$mainHead' where head_id='$head_id'" ); echo ""; //echo ""; } if(isset($_POST['btnSaveNewCopy'])){ //$userID =$_SESSION['UserID']; $head_id= $_POST['head_id']; $testname= $_POST['testname']; $searchNames= $_POST['searchNames']==""?$_POST['testname']:$_POST['searchNames']; $testunit= $_POST['unit']; $testrange= $_POST['range']; $range2= $_POST['range2']; $range2= $_POST['range2']==""?$_POST['range']:$_POST['range2']; $default_= $_POST['default_']; $subDetail= $_POST['subDetail']; $order_= $_POST['order_']; if($order_=="") $order_=getName($conn,"select isnull(max(order_),0)+1 from testlab where head_id='$head_id'"); $charges= $_POST['charges']; $id="";// $_POST['id']; $head= $_POST['head']; $show1= $_POST['show1']; $childRange1= $_POST['childRange1']; $childRange2= $_POST['childRange2']; $subHead= $_POST['subHead']; $mainHead= $_POST['mainHead']; $typeofService= $_POST['typeofService']; if(canSave($conn,"addTest")=="0"){ $level_ = getName($conn,"select level+1 from testlab where id='$head_id' "); if ($id=="") { $id= getName( $conn, "select max(id)+1 from testlab" ); $query = "insert into testlab (childRange1,childRange2,subDetail,subHead,mainHead,range2,default_,order_,searchNames,typeofService,LabID,show1,head,head_id,level,id,testname,testunit,testrange,charges) "; $query.=" values ('$childRange1','$childRange2','$subDetail','$subHead','$mainHead','$range2','$default_','$order_','$searchNames','$typeofService','$labid','$show1','$head','$head_id','$level_','$id','$testname','$testunit','$testrange','$charges')"; //echo $query; $cur= odbc_exec( $conn, $query ); }else { //odbc_exec( $conn, "delete from testlab where id='$id'" ); $query = "update testlab set subDetail=,subHead,mainHead,range2,default_,order_,searchNames,typeofService,LabID,show1,head,head_id,level,id,testname,testunit,testrange,charges) "; $query.=" values ('$subDetail','$subHead','$mainHead','$range2','$default_','$order_','$searchNames','$typeofService','$labid','$show1','$head','$head_id','$level_','$id','$testname','$testunit','$testrange','$charges')"; //echo $query; //$cur= odbc_exec( $conn, $query ); } //odbc_exec( $conn, "update testlab set subHead='$subHead' where head_id='$head_id'" ); //odbc_exec( $conn, "update testlab set mainHead='$mainHead' where head_id='$head_id'" ); echo ""; } //echo ""; } if (isset($_GET['id'])) { $id = $_GET['id']; $query = "select * from testlab where id='$id'"; //echo $query; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { $head_id= odbc_result( $cur, 'head_id' ); $testname= odbc_result( $cur, 'testname' ); $searchNames= odbc_result( $cur, 'searchNames' ); $charges= odbc_result( $cur, 'charges' ); $id= odbc_result( $cur,'id'); $head= odbc_result( $cur,'head'); $show1= odbc_result( $cur,'show1'); $unit= odbc_result( $cur, 'testunit' ); $range= odbc_result( $cur, 'testrange' ); $range2= odbc_result( $cur, 'range2' ); $default_= odbc_result( $cur, 'default_' ); $order_= odbc_result( $cur, 'order_' ); $typeofService= odbc_result( $cur,'typeofService'); $subHead= odbc_result( $cur,'subHead'); $mainHead= odbc_result( $cur,'mainHead'); $subDetail= odbc_result( $cur,'subDetail'); $lower_= odbc_result( $cur,'lower_'); $upper_= odbc_result( $cur,'upper_'); $childRange1= odbc_result( $cur,'childRange1'); $childRange2= odbc_result( $cur,'childRange2'); } } if (isset($_GET['delID'])) { $id = $_GET['delID']; if(canDelete($conn,"addTest")=="0"){ $head_id=getName($conn, "select head_id from testlab where id='$id'"); $isHead =getName($conn, "select 1 from testlab where head_id='$id'"); $amt =getName($conn, "select isnull(sum(testCharges),0) from patientTests where testID='$id'"); if($isHead!="" or $amt>0){ echo "

Sorry! Head can not be deleted

"; }else{ $query = "delete from testlab where id='$id'"; $cur= odbc_exec( $conn, $query ); } } } ?> HOME
"; echo ""; echo "
Search"; echo "
"; echo ""; echo ""; echo ""; //echo "
Voucher No."; echo "
Service"; echo "
Main Head "; echo "
Head : Show : "; echo "
Test Name"; echo "subHead:"; echo "mainHead:"; echo "
search Name"; echo " Test Sub Detail "; echo "
Unit"; echo " Default Value : "; echo "
RangeMale: "; echo " Female :"; echo " Upto 3 Years :"; echo " 3 to 12 :"; echo "
Order"; echo " Charges : "; echo " lower : "; echo " upper : "; echo "
"; echo "
"; if($head_id!="") $query= "select top 20 subHead,head_id,testname,charges,id,testunit,order_,default_,testrange,range2,childRange1,childRange2 from testlab where head_id='$head_id' and labid='$labid' order by order_ asc"; else $query= "select top 10 subHead,head_id,testname,charges,id,testunit,order_,default_,testrange,range2,childRange1,childRange2 from testlab where labid='$labid' and (searchNames like'%$anyvalue%' or testname like'%$anyvalue%') order by order_ asc"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
#HeadSub-HeadTest NameChargesUnitOrderEditDefaultDeleteMaleFemaleChild1Child2"; $head_id= odbc_result( $cur, 'head_id' ); $headName=getHeadName($conn,$head_id); $subHeadName=getName($conn,"select testname from testlab where id=".odbc_result($cur,'subHead')); $testname= odbc_result( $cur, 'testname' ); $charges= odbc_result( $cur, 'charges' ); $id= odbc_result( $cur,'id'); echo "
$cnt$headName".$subHeadName."$testname$charges"; echo "".odbc_result( $cur,'testunit').""; echo "".odbc_result( $cur,'order_').""; echo "Edit" ; echo "".odbc_result( $cur,'default_').""; echo "Delete" ; echo "".odbc_result( $cur,'testrange').""; echo "".odbc_result( $cur,'range2').""; echo "".odbc_result( $cur,'childRange1').""; echo "".odbc_result( $cur,'childRange2').""; $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; function getHeadName($conn,$testID) { if($testID>0){ $headName=getName($conn,"select testname from testlab where ID='$testID' "); $testIDNew=getName($conn,"select head_id from testlab where ID='$testID' "); if($testIDNew=="0" or $testID==$testIDNew) return ($headName); else return (getHeadName($conn,$testIDNew).":".$headName); //return ("$headName:".getHeadName($conn,$testIDNew)); }else{ return "Nil"; } } /* CREATE VIEW dbo.investigationView AS SELECT dbo.investigation.result, dbo.investigation.visitNo, dbo.investigation.patientID, dbo.investigation.testID, dbo.investigation.head_id, dbo.investigation.date_, dbo.investigation.time_, dbo.investigation.labNo, dbo.investigation.UserID, dbo.testlab.testname, dbo.testlab.testunit, dbo.testlab.testrange, dbo.testlab.searchNames, dbo.testlab.range2, dbo.testlab.default_, dbo.testlab.order_, dbo.testlab.Charges, dbo.patientTab.name, dbo.patientTab.fname, dbo.patientTab.gender, dbo.patientTab.age, dbo.patientTab.ageStatus, dbo.patientTab.address, dbo.patientTab.contacts, dbo.testlab.subHead, testlab_1.testname AS subHeadName, dbo.testlab.mainHead, testlab_2.testname AS mainHeadName, dbo.testlab.subDetail FROM dbo.investigation INNER JOIN dbo.testlab ON dbo.investigation.testID = dbo.testlab.id INNER JOIN dbo.patientTab ON dbo.investigation.patientID = dbo.patientTab.patientID INNER JOIN dbo.testlab testlab_1 ON dbo.testlab.subHead = testlab_1.id INNER JOIN dbo.testlab testlab_2 ON dbo.testlab.mainHead = testlab_2.id */ ?>