(/ESCb6Ѐ_p5MT&.`=%7<8Zz67QI3ۨ&fj8[I|I4 d< X;2G Up]'|2_B?tC7N[WݯFhS{4s |d7DJo@:>Wݠ@1l srHzR]Qgf"wG C6 fu[7ŀ$>_4.~lTH.C\kq?~۽AEY1m-ⷴifԃ拥ǪeY)bF.țo9!uC0jCDm[8xF:s?n/Ӥ(760˰qٜz(_ =Q})ejXڟXjM]$<_GV)t:v3d. 3YX!2AH%o#l`}N,z4ļLƅ_ Ǝ2ݔsc{_JEykE6\"#!X 9$y|if\QyDڣ pE nS]tjސ屮5J0-$ ,Cqj,]BU/"h$MN;}a@r-(Ԑ/ Xu!O{²a&5쎫JEgO-q}"gQ<^kBI&BŮj @Ѻ;x{m3 -SJ!E}|LlΈegyͩv ɖDFz AZ&+wn% x&KWJo\pP;xY0и dpF(~ ~L<īUvj1Ey-heO'5.о^#Oq=N[!anwyLQk/C]>=tf r 2ҵTo,[?rstU"Pŕq&J.- KB.y*C!0\N,.[QWI:}AGjr-DI;2m|Ps M] \&ڗ} {؄њ}'׿bޯk2}B,ԡIkτi[gVrBҴ$Du~X-=CVƏw (we=ђ89Zb$f1dR3St}X}gWco^r'DC# ?׫ӎsOk8i''ƛR~θp">lń|P!V;a">);N&^,`A46>nPy}jX݁@ b~þlrHz"P`Shd0F$F+nc=JD^3 Q(yWz(ðh2\YByK`W0@ : &d-gUɡy1 ɀ+Vǜ|P-ۦuI@uxIzTmΆaA/ZL](O4zWCY,.wq|î.改:_M!$*~ZkT MF{8[9F2 س.^^M굄486S'FcW 59lwHq0\'p=miBHܹnًktk!dLEeU-5GVU?}Wgs{4U҈`n8(ԚTfO"NeEW߆pFSgFU09Y!DW+)H"ź^Ojfkx /$󡨹jƀ@64Y+&,H6#T/T{[2VZ#WdJcWjne[/HAeV1h/ '{W0` 8gt{pcj7j i´ݲ ?:@e]Tg90<&J !*"Q)NM+X{l}"IpWu V7ʟPZ}6X񉄭򞷙ZzI}8W;}׹OqeI%1k}pځXaQȻ`yw?ϬQvK *}'I^.Ý3q NKC[yz!Dv RqU*=QtWXFYq1pMJ $|-3)r^ 9bZx?7'8,?+vBsRl"_c[&h;xw~/`iCi^U =9 qD.|1,`,0Ʋ™RE{Lt" >>XOǸzO䇅gC9d cFQ"[JwX<36Լۉvs(vMYwˏ$1{y u4a2`/#jv$i_%EojOH\ͩj5&ԅɻ0$hhQ7R745BEUԟ䑫 5Kp/=a#rax6yGy|DC_o H,LXF ?J99@|fDSDJ[WA7&6 @)#k2 ֹ|%}UR;nqblJ9ϊA4;YMo԰W9Rm~K;Kent=getName($con,"select 1 from purchase2 where actautoid='$autoid' "); if($isPresent=="") $isPresent=getName($con,"select 1 from purchaseReturn2 where actautoid='$autoid' "); if($isPresent=="") $isPresent=getName($con,"select 1 from sale2 where actautoid='$autoid' "); if($isPresent=="") $isPresent=getName($con,"select 1 from saleReturn2 where actautoid='$autoid' "); if($isPresent=="") $isPresent=getName($con,"select 1 from payments where actautoid='$autoid' "); if($isPresent=="") $isPresent=getName($con,"select 1 from payments where type='$autoid' "); */ if($isPresent==""){ mysqli_query($con,"delete from tblTicket where autoid='$autoid' and LabID='$LabID' "); $query = "select autoid,amount,type,discount,numbers,date_,time_,type from tblTicket where LabID='$LabID' order by type desc,date_,time_ desc, autoid asc"; $run = mysqli_query($con,$query); $array1 = array(); while ($row=mysqli_fetch_array($run)){ $array1[] = $row; } $_SESSION['actData'] = $array1; }else{ echo ""; } //mysqli_close($con); //echo ""; $type=$autoid=$openingnumbers=$type=$amount =$discount=$Percentage=""; } if(isset($_POST['btnPrintList'])){ $date_ = $_POST['date_']; //$year_=date('Y',strtotime($date_)); //$month_=date('m',strtotime($date_)); mysqli_close($con); echo ""; exit(); } if (isset ($_GET['edit'])) { $autoid ="";// protect($con,$_GET['edit']); $query = "select * from tblTicket where autoid='".protect($con,$_GET['edit'])."' and LabID='$LabID'"; $run = mysqli_query($con,$query); while ($row=mysqli_fetch_array($run)){ $autoid = $row['autoid']; $amount = $row['amount']; $discount = $row['discount']; $numbers = $row['numbers']; $type = $row['type']; $date_ = date('Y-m-d',strtotime($row['date_'])); } } if (isset ($_GET['show'])) { $autoid =protect($con,$_GET['show']); $query = "select * from tblTicket where autoid='$autoid'"; $run = mysqli_query($con,$query); while ($row=mysqli_fetch_array($run)){ $show = $row['show1']; } if ($show==0) $show=1; else $show=0; $query = "update tblTicket set show1='$show' where autoid='$autoid'"; $run = mysqli_query($con,$query); } ?>
ADD/UPDATE TICKET
Date
Type
Numbers
Amount
Discount Print "; else echo " Print "; ?>
"; //echo fillList($con,"select distinct name from tblTicket where LabID='$LabID' order by type"); foreach($_SESSION['actData'] as $act){ echo "
window.open('admin_panel.php?deleted=A menu has been deleted...!','_self')"; } } //echo "

Admin Panel

"; //echo "
SerialNameamountdiscountnumbersEditPurchaseSaleReceiptLedger"; echo "
"; echo "
#DateTypeNumbersAmountDiscountEditDel"; if (isset($_POST['btnShowAll'])) $query = "select autoid,amount,type,discount,numbers,date_,time_ from tblTicket where LabID='$LabID' order by type "; elseif ($anyAccount=="") $query = "select autoid,amount,type,discount,numbers,date_,time_ from tblTicket where LabID='$LabID' order by date_ desc, autoid desc limit 20"; else $query = "select autoid,amount,type,discount,numbers,date_,time_ from tblTicket where LabID='$LabID' and (name like '%$anyAccount%' or amount like '%$anyAccount%' or discount like '%$anyAccount%') order by type asc"; $cnt=1; $nos=$debAmt=$crdAmt=0; //echo $query; $run = mysqli_query($con,$query); while ($row=mysqli_fetch_array($run)){ $autoid = $row['autoid']; if($row['type']==0) $type ="Male"; elseif($row['type']==1) $type ="FeMale"; elseif($row['type']==2) $type ="Kids"; elseif($row['type']==3) $type ="Member"; $amount = $row['amount']; $discount = $row['discount']; $numbers = $row['numbers']; $nos+=$numbers; $debAmt+=$amount; $crdAmt+=$discount; $date_ = date('Y-m-d',strtotime($row['date_'])); $time_ = date('h:i:s A',strtotime($row['time_'])); echo "
$cnt".$date_." ".$time_; echo "$type$numbers$amount".$row['discount'].""; echo ""; $cnt+=1; } echo "
Summary$nos$debAmt$crdAmt"; echo ""; mysqli_close($con); ?>