HOME

Sorry! Head can not be deleted

HOME

"; echo ""; echo "

"; 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 " Cut-Off Value "; echo "
Unit	"; echo " Default Value : "; echo "
Range	Male: "; echo " Female :"; echo " Upto 3 Years :"; echo " 3 to 12 :"; echo "
Order	"; echo " Charges : "; echo " lower : "; echo " upper : "; echo " Gap After : "; 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 "

#	Head	Sub-Head	Test Name	Charges	Unit	Order	Edit	Default	Delete	Male	Female	Child1	Child2"; $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 */ ?>