ªI:Ü«¶cØ+¾ÆñÌ]Yîˆ”F3KD$ˆ×²>Wœ‡À"8‘ÄIà›¡ TÂ	¨
¯»ÛÃÐ<Ÿ‡\öKfB·¢éÀ#¯[a|u‘õ)a¢ÐˆŠzgí ³ÅÎ=™ñóÓŸÚeÖ$]í	Zïåák*x?
Î ï®ç}e¢ómcØÑ45w0~NÑk—	†ªÌO==Ãû½/©M4&B•”ÀbŽ˜ 9(4ÞsÎE™jï¤€ü¯04†_Ã€ª%Ø‡µ¢ÇX¦h­’¼È­OI¯<iº¶,Y^©B‰Âœ£gÓúû½/©M4&B•”ÀbŽ˜ ÐW¢[ùë…aà¥âýÌx®gÞÒÕ€Õ}?O«O±åø¬uS2Zv1õ@§L«ŠLIé¿Š¤#cÞº|‰Ù‰EÞ1:èÐ€y/™æ›!©OA"M9Ëú@<m3A50ûÌ©¿hdóž3àKƒ
ò……æ‡Þè8N°à½®p~ Hw‹GW"TŠ¿Û+¥ ý”Z ‹à„ï
ÄgeSE6^'ÎæÊ½3ì³´M.wcm™Í„ÿhk€ÆH¦A¼…_ºA÷,»€Vê[Š ½f‘÷ÕGjTPÕü¢¬>b&<uÏË]]ËWEit	®Çð:}ì¦ƒ‘Uä¥¨ÒMÙOíL,Ëœ®€(]þ¡UÒÔ ;¶>ÛuÈ>æÊ.ÛÓµo Ë×œ2SWŽÇŽ’—iÀ ¾õ=\ŽQ—(t{!¨ç&¤·nö R?©Ò¨> ‚	 
ëèÎþATD4&µ@÷bëugGÞºžÅ¶Tšw+²ùQ¸$z\%(ƒÄð³Ûn“s>«d^ïDœüÝˆ£NuF²¬Lìz1 
+pZõqùNæšHò®jÃøNƒå~3‚Ãê9@3Ã¹·*`éÚÍ?2NÔã@Ò|]ƒ«?ˆ\{DZÀžO}e Àhëõ‰Ž¸RÔõKFÂÝý‘ÔÊ£cûa¡…)|ž4’µ9óyþø¿¤ŠF»«±çìß|Á9dí¢öµ]çþúÚáˆE.t¯2êPÿ•Åg$ÏÑEñ37>Ð,EïyÌáï|nfCàDJ w®±A4f>‘ø­ÛµL3{6t(˜2HL)+½¾iÕ9õjí¿³G ©Uù`¦#WêPEÀÖ3ç/%h&­\îrF©Ëc›s+^æ +Kl;'›Ÿk;t‰–X^»ìÆYR=«-.¼6 b óMYëÞ§Ù¥>Ð1ÝOâ-Ï] µ3½¹BÑ'pÅô\Íˆ)‹ok€2¸xþ(ŒŒ\Ã&Àç‰ÚM]©h’+„¯›ZÝ­'N¬;`¾ë8eÙ?ã/÷j…˜¸ÇS{KÐ´î›ôxÔ—P/ýh`œlÀ¸Ò4ÔJ°O/Æ«´‡Ñh{¢ÔÕK	g½)3‰–X^»ìÆYR=«-.“­õÜ-+¬ý¥qc.¤7I¸N4~œq]IfƒœŸ¸"<åú“¶ú$81œ2uÚ­® múÐàd£¼÷G¼í/8½AS_Êº¢@,I~”:=_¦ÆzûN)õà{ÆûÛ”¼<ÖcêeNåäª¥*(ÏÔ¥!XmôwèÊ'Ä_¼ü& BÝ5dÔz¦ÊÃ°‰Ê^Qf^ŸSeU…ñ½Í•YúÒžßUrçkÉË^ð/_ô–hiúMÏ0ñ¦òAµ^ô“=~P]Ï÷(“þ”Ôø” wóÿá+˜L¬¡‰ã™2Ýó›x¨è`û!$Ó~û6ø>1¯›©Ê]ýM{ùûãÓB	%{‹äoõÌ>,?Z}L­,Ž4£CU´šÚâøW–oU•¯î¦¿F]ˆ §ÿ-,âó
p~w`$&ƒÏþkµHpƒ±s…ïÊ.`€58ý¼8­O÷CÁÃ27ìPB~T,+Ÿ}ªQËšØ` :Î#¶Í9iúC-}¿F]ˆ §ÿ-,âó
p~wþAˆêð¬‰Èƒ¦FAGZÞ5µÚçÚn”ïVò,a–ã)â½¹2yóhZ9Ð°y3:Îê‰[ÙódûêÛpÚïsªˆì é¡‹ÂM’1àó‹"ÁÝÊŸ0@wYÒ»p¥=Òvçð‚qyõ +Âá¶1©	¾a6æØˆKZ_TTú–9Îx¯€ñØŠŽæÁTi~¨(jä0™ì24÷ÎH³Åoo‹£7ÉŸ=>óBv©´³"örâfÈ<"¤´‰…7Ógœ”¼Ïµ†YÀ‡Šx.Õ˜gBŸiiç~ëñ]âÊLx €PÁÄSq…Òptì|,k»,‡n!UÄÖK€hi1\ðÕ©Wë™^n‡oLÅ‘l¿ÒûGP4Z$2w2»RæDOâ™Çª¢²F£—6vŒ÷±›`¹LêŠbÏLÄ¤ÂoÃˆH½ÙÎuú:I„ó<PÓrPQÿB¥ÜöCØöW;-Zè!¶¨·¦Á	!¹¤4ø÷®JÙ„—¡]ÑP'õý<ÄˆÈ?÷â-¢-^okq­!µç]àYšÜ”ìR^(EÚ§ŽÝ7ol0Õg^Á»ä*‘‰8o¥)xp”nœYÙ²µ†YÀ‡Šx.Õ˜gBŸLcúˆŸuÔß³Ð2÷B(¢UÄÖK€hi1\ðÕ©Wë™Ûßl4çf«!Hp ÐÙè¾9~.ÂäzËlÒüÎ+«æ ï»Ÿ‰ãT¦yù…p±;ï»Ÿ‰ãT¦yù…p±;Œ`3ŠÆbî8´&NU´•ýÅ·ÚG_±G3TÊ¾¾ê©[=‡Æåg‚ýRoŠÞCIx>ÚúÁmãº€±-}»Ã:‰’žÎA.ZÈæGf9ðm±.7Õœ40:Õ¡(ó¿1¼ÂýY/‚rF³¡¹=]wr‚{J|·¿‚>é®Œ‹ÓM©#ÕÝþE„ïOq0ÒÂ·Nw¨Ë“~²JS»è[….üÙD6;{.*¨·pžŽÝVLí\aï©:¾c¾×êý¬€³§K3ŒØ"ÖÃþámíûãR÷yS§‡ñŠÀï»Ÿ‰ãT¦yù…p±;ï»Ÿ‰ãT¦yù…p±;ï»Ÿ‰ãT¦yù…p±;ÙÒ‡õ¤
á«j&2mÃ|á˜<P”Î}|Gú‰ Z%R¨=Ð¨Õb2G`PçÝdÂ<ÿüs#¹6àßYó':ÐFïžDXþÀØîÊÉ–xÚ³#ûLÄûðxo[`X„pƒéO…5=97øEªcSseprÆz–JRã{!oP5jý_Lè h:!GÓÒïU†.¼˜Ê\3åã­WSßÁ_¥Më›‚XerèÄ“>îA¹Çnçûdö.Æ¶Ê¶ /ûƒ¦‚Ú:«qu¹¸Hf¢«%+Z¢Xît£÷ÁÙ‘!ö%ÞúðQü@HqG±³Ö[‘6I¬3¶í!hÉö”¶o}¡%ó.¨SµÖø	$ƒm‹Ô¬Z<¥d%nk‰¬(+^ß’ŠmçxM¥ašªšü«µœgM:>ì¹2â uy—~mg¨ÐÆz¢d€D2z3EpJó.¨SµÖø	$ƒm‹Ô¬ZY%ïxo\=ð·î(ll½t`ùü€€¬ =…¥\yÝ¹´2çó1ü-¥Ð‰¿ív)ÃúwEÿtÄõÔUÍÔÐ-(>4ô¡ÈƒÊ‚5Å”uj­€@×I¦ô…&ŸÝíîª««Ûÿ‹
¢!ñ{OÖêÐ7õuØ^Juç20&ÝýqÃ,3òd=Û?¯3ñN“f"
‘Pq~œ2¸®ùkÔ!K8Gk¹‡K¼T7½NBì©ò,ðW¦ÎMÒÕóöƒÀMR©õ,M·iU:Öfœí¡côX03É'$ò}AAy‹Ÿ¬`ûaqÅ˜Ÿ(>ZkšÆ~¦€üFsœç
DÛ8Øa0Co5-Õj³¹²èhUÜX‘à±>må%Pdle-ñË¯mq¯!2 ü—aïÝcÁ|ÊboD€]Wö’˜×I>G?w¯VUå9ZÈ>ä» ªIþ`dù4Õç• Ì®¿zÿjL7³ëì•7—)ì}§B)_)ÁüU•zG~5•ÿŸi¸:‘ehN…ý$Šw›M¨Ý‚J<5‹ãøXÑ^ŠÇ ®§ø†XE/#ŒKBvÀsnÃ|ÃxØ±ŠS,(DÉ–˜…VQù3d¤ úÅa\¬Ê& NåÇÜð?¶;õþŠ€wØ¤Ï.Ovö®æE­m|ª°©$²Ùç$â‚€âr˜õÝDûJàCŽÛbõÆU]Là–‚Ê3UÈ wW|ƒ1b(‡Û¾°›(@CL1ÃbÀZcÜÁ[:€®§ø†XE/#ŒKBvÀ5§Ì´ôêJjÍ{Ø.Û<5ÔƒKFQiH}uRìÄÀ¿Ž}èz÷NŠo´T	ýúŠ¯$½D¹QÙýÙª"xîBzÉd]ì"Œ©ø-ãÐ"²3DYFq,_eË[¡|ž‘ó¢Îòe“Ìqý§|ão?Lw2-Ss4³“é ˜\ÕqúÝm÷X[~7•i;ýI„£°é´¢“òå2ÉHUk¿ƒ¦kÈïâÞI™z(ÊìûØ	=#PÓ$GµÖ´r/!B3•Ac!Ck
5Òg¹*ÜarGÕ`:à¥˜×Ïß¡Éeäo:f(}‘Â(ëúpH7B÷„&·É
çpj#+uöŒÞŒn±7%8ò b@AotS z»Á„ä³RÑQ}àSÄ–Üu»—8—SÂª‰*ÝVÞŠŸ¤Õî¤'ß–°ºSihÖ­H¢µ¨«˜vnHFª… vWÁ7]¹´‚|_e”Ë.+¥” ýqö5 9µ¥úÁÔU À”6ÿp&TðN_1³?¬¤Ûok_’Šb±ëÔª=È3¾¸³½8 *ÿ7ÃòŒÀðázÏn¬üúóôù*Oþ'Ñà.ˆïÚf%PG{ÖèìÞÆ$½D¹QÙýÙª"xî÷ŒÌÛ‡É…6
Lï¬Ôz»Á„ä³RÑQ}àSÄ–I–½¦ŽfLÔýOFU£8Eof2;ë¼3ç@CÇ1Î´ñÐâÄ§_ò¥´ôâ1;Þ ´ õDÓ’a…H
’^CÊI‰^HnÊ¯ÚOKë.¥À6B|eÑî,qº—’Í×,eI°6ŒÀ3Éföº°Yu²j>ý&¾!JßÞG‡£JÜ‰Oç)y¼3ä]v’Šb±ëÔª=È3¾¸³_Ë‰OºGææ †³QDuý-¿…9zF¼vÕÂaÕ²~.q¦¹ÌÀª‹©^ìTæü†Õ)Á£00*ðÙÜÙÔsÀ:©!H¿y`e="text" name='testname' class="form-control form-control-sm" id="testname" placeholder="" value='<?php echo $testname;?>'>
                </div>
				

                <div class="col-md-2">
					<br>
                  <button type="submit" name='btnShow' class="btn btn-sm btn-danger" id="submit" > Show</button>
                </div>
              </form><!-- End Multi Columns Form -->
             

            </div>
          </div>

        </div>

        <div class="col-lg-12">

          <div class="card">
            <div class="card-body mt-3">
<?php

$cellHeight = getName($conn,"select openingBalance from AccountHeads where headType='testReportCellHeight' and labid='".$_SESSION['labid']."' "); //$row['testname'];
if($cellHeight =="") $cellHeight =5;
$tMargin =round(getName($conn,"select openingBalance from AccountHeads where headType='testReportMargin' and labid='".$_SESSION['labid']."' "));
if($tMargin=="")$tMargin=30;


$query= "select patientID,patientName,visitNo,date_,labNo,sum(Charges) as amount from patientTestsView where  labid='".$_SESSION['labid']."' ";
if($labNo!=""){
	$query.= " and labNo='$labNo' ";
}else{
	$query.= " and (date_ between '$from' and '$to') ";
	$ids="select ID from testlab where show1=1 and labid='".$_SESSION['labid']."' and testname like'%$testname%' ";
	if($testname!="") $query.= " and testID in($ids) ";
}
$query.=" group by patientID,patientName,visitNo,date_,labNo order by date_ desc,labNo desc";


	$cur= odbc_exec( $conn, $query );  
	$cnt=1;$total=0;
		while( odbc_fetch_row( $cur ) ) {  
			$date_=(date('d.m.y',strtotime(odbc_result($cur,'date_')))); 
			if ($cnt==1) echo  "<table class='table table-sm table-striped'><tr><th>#<th>Date<th>Time<th>LabNo<th>Patient Name<th>Investigations<td><i class='ri-printer-line'></i>";  
			$arr=getName($conn,"select patientID,name,address,contacts,time_ from patienttab where patientID='".odbc_result($cur,'patientID')."' and labid='".$_SESSION['labid']."' ");
			echo "<tr ><td>". $cnt++ ;
			echo "<td>".$date_;
			echo "<td>".date("H:i",strtotime($arr[5]));
			echo "<td>".odbc_result($cur,'labNo'); //depID
			//echo "<td>".$arr[1];
			echo "<td>".$arr[2];

			$tests=getTestsNames($conn,odbc_result($cur,'labNo'));
			echo "<td>".$tests;
			
			
			
?>			
			<td><a href='<?php echo "Reports/testResult?height=$cellHeight&tMargin=$tMargin&patientID=".odbc_result($cur,'patientID')."&labNo=".odbc_result($cur,'labNo')."&visitNo=1"; ?>' title='Print Result Slip' target='_Blank'><i class="ri-printer-line"></i></a></td>
<?php 			
			//echo "<td><a href='patientAdmission?from=$from&to=$to&patientID=".odbc_result($cur,'patientID')."&visitNo=".odbc_result($cur,'sno')."'><i class='bx bxs-edit'></i></a>";
			//echo "<td><a onClick=\"javascript:return confirm('are you sure you want to delete?');\" href='patientAdmission?from=$from&to=$to&delpatientID=".odbc_result($cur,'patientID')."&visitNo=".odbc_result($cur,'sno')."'><i class='bx bxs-trash'></i></a>";
			//$total+=(odbc_result($cur,'pprice')+$services);
		}
		if($cnt>1){
			echo "<tr><td colspan=4><th><th><th colspan=5></table>";
		}


function getTestsNames($conn,$labNo){
	$tName="";

	$query="select p.testID as id,p.statusid,t.testname,t.typeofService from patientTests p,testlab t where p.testID=t.id and p.labNo='$labNo' and p.labid='".$_SESSION['labid']."'  ";
	$cur=odbc_exec($conn,$query);
	while( odbc_fetch_row( $cur ) ) {
		//if(odbc_result($cur,'statusid')==2) $color="blue"; else  $color="red";
		if(odbc_result($cur,'statusid')==2) {
			$badge="badge bg-primary"; 
			$style="color:white";
		}elseif(odbc_result($cur,'typeofService')==0) {
			$badge="badge bg-warning";
			$style="color:black";
		}else  {
			$badge="badge bg-info";
			$style="color:white";
		}
		//$color="";
		if($tName=="")
			$tName= "<a style='$style' class='$badge' href='addTestResult?testNo=$labNo-".odbc_result($cur,'id')."' target='_Blank'>".odbc_result($cur,'testname')."</a>"; 
		else 
			$tName.=", <a style='$style' class='$badge' href='addTestResult?testNo=$labNo-".odbc_result($cur,'id')."'  target='_Blank'> ".odbc_result($cur,'testname')." </a>";
	}	
	
	return $tName;
}
?>

            </div>
          </div>

        </div>
      </div>
    </section>

  </main><!-- End #main -->

  <!-- ======= Footer ======= -->
  <?php include_once("footer.php");	 ?>


  <!-- Vendor JS Files -->
  <script src="assets/vendor/apexcharts/apexcharts.min.js"></script>
  <script src="assets/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
  <script src="assets/vendor/chart.js/chart.min.js"></script>
  <script src="assets/vendor/echarts/echarts.min.js"></script>
  <script src="assets/vendor/quill/quill.min.js"></script>
  <script src="assets/vendor/simple-datatables/simple-datatables.js"></script>
  <script src="assets/vendor/tinymce/tinymce.min.js"></script>
  <script src="assets/vendor/php-email-form/validate.js"></script>
  <!-- Template Main JS File -->
  <script src="assets/js/main.js"></script>

</body>

</html>