Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u176930106

Directory:

/home/u176930106/domains/jusjumpin.in/public_html

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: blreportdl.php

<?php
ob_start();
session_start();
include("includes/incall.php"); 
if(isset($_REQUEST['delete']) && $_REQUEST['delete']=="yes") {
	mysqli_query($con,"delete from `booking` where `bid`='".$_REQUEST['id']."'");
	$_SESSION['msgsu']="Booking is deleted successfully.";
	header("Location: ".basename(__FILE__));
	exit();
	
}
$dc=date("Y-m-d");
$exdate=date("Y-m-d",strtotime($dc."-1 day"));

$sql="select count(*) as cntysttot from `vouchers` where `date`<='".$exdate."'";
if($_SESSION['utype']=="store") {
	$sql.=" and `aby`='".$_SESSION['uid']."'";
}
$row=mysqli_fetch_array(mysqli_query($con,$sql));	
$cntysttot=$row['cntysttot'];

$sql="select count(*) as cntystused from `booking` where `date`<='".$exdate."' and `voucher`!='' and `status`='1'";
if($_SESSION['utype']=="store") {
	$sql.=" and `aby`='".$_SESSION['uid']."'";
}
$row=mysqli_fetch_array(mysqli_query($con,$sql));
$cntystused=$row['cntystused'];

$opening=$cntysttot-$cntystused;

$sql="select count(*) as cnttoday from `vouchers` where `date`='".$dc."'";
if($_SESSION['utype']=="store") {
	$sql.=" and `aby`='".$_SESSION['uid']."'";
}
$row=mysqli_fetch_array(mysqli_query($con,$sql));
$cnttoday=$row['cnttoday'];

$sql="select count(*) as cnttdused from `booking` where `date`='".$dc."' and `voucher`!='' and `amount`='0' and `status`='1'";
if($_SESSION['utype']=="store") {
	$sql.=" and `aby`='".$_SESSION['uid']."'";
}
$row=mysqli_fetch_array(mysqli_query($con,$sql));
$cnttdused=$row['cnttdused'];

$balance=$opening+$cnttoday-$cnttdused;
include("includes/headermain.php");
?>
<script src="js/jsfunction.js" type="text/javascript"></script>
<script language="javascript">
function del(id) {
	var fd=confirm("Are you sure to delete this entry?");
	if(fd==true) {
		location.href="blreportdl.php?id="+id+"&delete=yes";
	}	
}
</script>
<body class="sticky-header left-side-collapsed">
    <section>
		<?php include("includes/leftpanel.php"); ?>
		<div class="main-content">
			<?php include("includes/header.php"); ?>
			<div id="page-wrapper">
				<div class="graphs">
					<div class="col_3">
						<h3 class="blank1">Billing Daily Report</h3>
						<div class="tabls">
							<div id="uform" class="bs-bg" data-example-id="contextual-table">
								<div id="wd100">
									<form action="blreportdl.php" method="get" name="seform">
										<?php if($_SESSION['utype']=="superadmin") { ?>
											<strong>From:</strong>&nbsp;<input type="date" name="frdate" id="eventstartdate" class="largeinputa" required value="<?php print $_REQUEST['frdate']; ?>">
											&nbsp;&nbsp;&nbsp;
											<strong>To:</strong>&nbsp;<input type="date" name="todate" id="eventstartdatea" class="largeinputa" required value="<?php print $_REQUEST['todate']; ?>">
											&nbsp;&nbsp;&nbsp;
										<?php } ?>	
										<input type="text" name="mobile" id="mobile" class="largeinputa" value="<?php print $_REQUEST['mobile']; ?>" placeholder="Mobile No.">
										&nbsp;&nbsp;&nbsp;
										<select name="pmode" id="pmode" class="largeinputa">
											<option value="">Select Payment Mode
											<option value="Cash" <?php if($_REQUEST['pmode']=="Cash") { ?>selected<?php } ?>>Cash
											<option value="Card" <?php if($_REQUEST['pmode']=="Card") { ?>selected<?php } ?>>Card
											<option value="UPI" <?php if($_REQUEST['pmode']=="UPI") { ?>selected<?php } ?>>UPI
										</select>
										&nbsp;&nbsp;&nbsp;
										<?php if($_SESSION['utype']=="superadmin" && $_SESSION['uid']=="2") { ?>
											<select name="aby" id="aby" class="largeinputa">
												<option value="">Select Store
												<?php
												$sqlstr="select * from `admin` where `utype`='store' and `status`='1'";
												$resstr=mysqli_query($con,$sqlstr);
												while($rowstr=mysqli_fetch_array($resstr)) {
												?>
													<option value="<?php print $rowstr['id']; ?>" <?php if($_REQUEST['aby']==$rowstr['id']) { ?>selected<?php } ?>><?php print $rowstr['ini']; ?>
												<?php } ?>
												
											</select>
											&nbsp;&nbsp;&nbsp;
											<select name="dcount" id="dcount" class="largeinputa">
												<option value="">All 
												<option value="Duplicate Printing" <?php if($_REQUEST['dcount']=="Duplicate Printing") { ?>selected<?php } ?>>Duplicate Printing
											</select>&nbsp;
										<?php } else { ?>
											<input type="hidden" name="aby" id="aby" value="<?php print $_SESSION['uid']; ?>">
											<input type="hidden" name="dcount" id="dcount">
										<?php } ?>
										<div class="cleaner h20"></div>
										<div class="floatright">
											<input type="submit" name="search" value="Search">&nbsp;<input type="button" name="show" value="Show All" onClick="location.href='<?php print basename(__FILE__); ?>'"><?php if($_SESSION['utype']=="superadmin" && $_SESSION['uid']=="2") { ?>&nbsp;<input type="button" name="exp" value="Export" onClick="exportbl();"><?php } ?>
										</div>	
									</form>
								</div>
								<div class="cleaner h40"></div>
								<?php if($_SESSION['msgerror']!="") { ?><div class="msgerror"><?php print $_SESSION['msgerror']; $_SESSION['msgerror']=''; ?><div class="cleaner h10"></div></div><?php } ?>
								<?php if($_SESSION['msgsu']!="") { ?><div class="msuccess"><?php print $_SESSION['msgsu']; $_SESSION['msgsu']=''; ?><div class="cleaner h10"></div></div><?php } ?>
								<table class="table">
									<thead>
										<tr>
											<th>Sl.</th>
											<th>Date/Time</th>
											<th>TimeDiff</th>
											<th>Mode</th>
											<th>Name</th>
											<th>DOB</th>
											<th>Mobile</th>
											<th>Taxable Sales</th>
											<th>Discount</th>
											<th>GST</th>
											<th>Net</th>	
											<th>D Print</th>	
										</tr>
									</thead>
									<tbody>
										<?php
										$count=1;
										$aamount=0;
										$scthirty=0;
										$scforty=0;
										$scfifty=0;
										$scsixty=0;
										$d=date("Y-m-d");
										$sqlashis="select bk.date as dt, bk.amount as amt, bk.*, cs.* from `booking` bk, `customer` cs where bk.cusref=cs.cid and bk.status='1'";
										if(($_SESSION['utype']=="store" || $_SESSION['uid']!="") && $_SESSION['uid']!="2") {
											$sqlashis.=" and bk.aby='".$_SESSION['uid']."'";
											//$dt=date("Y-m-d");
											//$dtlast=date("Y-m-d",strtotime($dt."-5 days"));
										}
										/*if($_REQUEST['frdate']) {
											if($_SESSION['utype']=="store") {
												if(dtconvert($_REQUEST['frdate'])<$dtlast) {
													$_REQUEST['frdate']=dtconvert($dtlast);
												}
											}
											$sqlashis.=" and bk.date>='".dtconvert($_REQUEST['frdate'])."'";
										}*/
										if($_REQUEST['frdate']) {
											$sqlashis.=" and bk.date>='".$_REQUEST['frdate']."'";
										}
										if($_REQUEST['todate']) {
											$sqlashis.=" and bk.date<='".$_REQUEST['todate']."'";
										}
										if($_REQUEST['frdate']=="" && $_REQUEST['todate']=="") {
											$sqlashis.=" and bk.date='".$d."'";
										}
										if($_REQUEST['mobile']) {
											$sqlashis.=" and cs.mobile like '%".$_REQUEST['mobile']."%'";
										}
										if($_REQUEST['pmode']) {
											if($_REQUEST['pmode']=="Cash") {
												$sqlashis.=" and (bk.pmode='".$_REQUEST['pmode']."' or bk.pmode='')";
											} else {
												$sqlashis.=" and bk.pmode='".$_REQUEST['pmode']."'";
											}
										}
										if($_REQUEST['aby']) {
											$sqlashis.=" and bk.aby='".$_REQUEST['aby']."'";
										}
										if($_REQUEST['dcount']=="Duplicate Printing") {
											$sqlashis.=" and bk.pcount>'1'";
										}
										$sqlashis.=" order by bk.bid desc";
										//print $sqlashis;
										$resshis=mysqli_query($con,$sqlashis);
										if(mysqli_num_rows($resshis)>=1) {
											/*$sqltot="select sum(amount) am from `booking` where 1";
											if($_REQUEST['frdate']) {
												$sqltot.=" and `date`>='".dtconvert($_REQUEST['frdate'])."'";
											}
											if($_REQUEST['todate']) {
												$sqltot.=" and `date`<='".dtconvert($_REQUEST['todate'])."'";
											}
											if($_REQUEST['frdate']=="" && $_REQUEST['todate']=="") {
												$sqltot.=" and `date`='".$d."'";
											}
											$rowtot=mysqli_fetch_array(mysqli_query($con,$sqltot));*/
										?>
											<?php /*?><tr>
												<th colspan="6">Total Count: <?php print mysqli_num_rows($resshis); ?>&nbsp;&nbsp;&nbsp;&nbsp;Total Amount: Rs. <?php print $rowtot['am']; ?></th>
											</tr><?php */?>
										<?php	
											while($rowashis=mysqli_fetch_array($resshis)) {
												//if($rowashis['aby']!='8') {
													//$invid=$rowashis['bid'];
												//} else {
													//print $row['bid']-203057;
													//$inv=($row['bid']-203057)%50;
													//$chrid=floor(($row['bid']-203057)/50)+96;
													$inv=$rowashis['serial']%50;
													$chrid=floor($rowashis['serial']/50)+97;
													$chr=chr($chrid);
													$invid=strtoupper($chr).$inv;
												//}
												if($rowashis['status']=="1") {
													$net+=$rowashis['net'];
												}
												$rowcus=mysqli_fetch_array(mysqli_query($con,"select * from `customer` where `cid`='".$rowashis['cusref']."'"));
												$rowpk=mysqli_fetch_array(mysqli_query($con,"select * from `activity` where `id`='".$rowashis['pack']."'"));
												$aamount+=$rowashis['aamount'];
												if($rowashis['aamount']!="" && $rowashis['aamount']!="0") {
													$arr=explode(",",$rowashis['accessoriespr']);
													foreach($arr as $val) {
														if($val==30) {
															$scthirty++;
														} 
														if($val==40) {
															$scforty++;
														} 
														if($val==50) {
															$scfifty++;
														}
														if($val==60) {
															$scsixty++;
														}
													}
												}
												$ctr=strtotime($rowashis['time']);
												$ctrc=strtotime($rowashis['endtime']);
												$timediff=$ctrc-$ctr;
												$minutes=round($timediff/60);
										?>
												<tr class="<?php echo ++$flag%2==0?"active":"success";?>" onMouseOver="this.className='info'" onMouseOut="this.className='<?php echo $flag%2==0?"active":"success";?>'" id="go<?php print $flag; ?>">
													<td><?php print $count; ?></td>
													<td>
														<?php print dtconvert($rowashis['dt']); ?> <?php print $rowashis['time']; ?><br>(<?php print $rowashis['bid']; ?>)
														<?php //if($rowashis['aby']=='8') { ?><br>(<?php print $invid; ?>)<?php //} ?>
														<?php 
														if($rowashis['voucher']=="" || $rowashis['total']==0) {
															if($rowashis['pcount']>1) {
														?>
																<br><span class="msgerror"><strong>Duplicate Print: <?php print --$rowashis['pcount']; ?></strong></span>
															<?php } ?>
															<br>(<?php print $minutes; ?> Mins)
														<?php } ?>
													</td>
													<td>
														<?php if($rowashis['voucher']=="" || $rowashis['total']==0) { ?>
															In: <?php print $rowashis['time']; ?><br>
															Out: <?php print $rowashis['endtime']; ?><br>
															<?php if($rowashis['checkout']=="1") { ?>
																Check-Out: <?php print $rowashis['chkotime']; ?><br>
																<?php 
																if($rowashis['strchkotime']!="") { 
																	$diff=$rowashis['strchkotime']-$rowashis['strtime'];
																	$timediff=round($diff/60);
																	//print $timediff;
																}
																?>
																(<?php print $timediff; ?> Min(s))
															<?php } else { ?>
																(Active)
														<?php } } ?>	
													</td>
													<td><?php if($rowcus['cardno']!="") { ?>Card<?php } else { ?><?php print $rowashis['pmode']!=''?$rowashis['pmode']:"Cash"; ?><?php } ?></td>
													<td><?php print ucwords(strtolower(utf8_encode(stripslashes($rowcus['name'])))); ?></td>	
													<td><?php print dtconvert($rowcus['dob']); ?></td>	
													<td><?php if($_SESSION['uid']=='20' && $rowashis['checkout']=="1") { ?>xxxxxxxxxx<?php } else { ?><?php print $rowcus['mobile']; ?><?php } ?></td>	
													<td><?php print number_format($rowashis['amt'],2); ?></td>	
													<td>0.00</td>	
													<td><?php print number_format($rowashis['gst'],2); ?></td>	
													<td><?php print number_format($rowashis['net'],2); ?></td>	
													<td><?php print $rowashis['pcount']-1; ?></td>	
												</tr>	
										<?php $count++; } ?>
											<tr>
												<td colspan="15" align="right" style="font-size: 16px;">
													<strong>
														<?php if($_REQUEST['frdate']=="" && $_REQUEST['todate']=="") { ?>
															Voucher Summary - Opening Count: <?php print $opening; ?>&nbsp;&nbsp;&nbsp;&nbsp;Issued Today: <?php print $cnttoday; ?>&nbsp;&nbsp;&nbsp;&nbsp;Used Today: <?php print $cnttdused; ?>&nbsp;&nbsp;&nbsp;&nbsp;Closing Count: <?php print $balance; ?>
															&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
														<?php } ?>
														Socks (30): <?php print $scthirty; ?>&nbsp;&nbsp;&nbsp;&nbsp;Socks (40): <?php print $scforty; ?>&nbsp;&nbsp;&nbsp;&nbsp;Socks (50): <?php print $scfifty; ?>&nbsp;&nbsp;&nbsp;&nbsp;Socks (60): <?php print $scsixty; ?>&nbsp;&nbsp;&nbsp;&nbsp;Total Socks Amount: <?php print $aamount; ?>
														&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
															
														Total Count: <?php $count--; print $count; ?>&nbsp;&nbsp;&nbsp;&nbsp;Total Amount: Rs. <?php print number_format(round($net),2); ?>
													</strong>
												</td>
											</tr>
										<?php } else { ?>
											<tr>
												<td colspan="15">Sorry, Nothing Found.</td>
											</tr>
										<?php } ?>
									</table>
									<table class="table">	
										<tr>
											<td colspan="15">&nbsp;.</td>
										</tr>
										<thead>
										<tr>
											<th>Sl.</th>
											<th>Date/Time</th>
											<th>Name</th>
											<th>DOB</th>
											<th>Mobile</th>
											<th>Taxable Amount</th>
											<th>GST</th>
											<th>Net</th>	
										</tr>
									</thead>
										<?php
										//$count=$rowashis['serial']+1;
										$count++;
										$neta=0;
										$d=date("Y-m-d");
										$sqlashis="select * from `bill` bk where bk.net!='' and bk.status='1'";
										if($_SESSION['utype']=="store") {
											$sqlashis.=" and bk.aby='".$_SESSION['uid']."'";
										}
										if($_REQUEST['frdate']) {
											$sqlashis.=" and bk.fdate>='".$_REQUEST['frdate']."'";
										}
										if($_REQUEST['todate']) {
											$sqlashis.=" and bk.fdate<='".$_REQUEST['todate']."'";
										}
										if($_REQUEST['frdate']=="" && $_REQUEST['todate']=="") {
											$sqlashis.=" and (bk.bdate='".$d."' or bk.fdate='".$d."')";
										}
										if($_REQUEST['mobile']) {
											$sqlashis.=" and bk.mobile like '%".$_REQUEST['mobile']."%'";
										}
										if($_REQUEST['aby']) {
											$sqlashis.=" and bk.aby='".$_REQUEST['aby']."'";
										}
										$sqlashis.=" order by bk.blid  desc";
										//print $sqlashis;
										$resshis=mysqli_query($con,$sqlashis);
										if(mysqli_num_rows($resshis)>=1) {
											while($rowashis=mysqli_fetch_array($resshis)) {
												$neta+=$rowashis['net'];
										?>
												<tr class="<?php echo ++$flag%2==0?"active":"success";?>" onMouseOver="this.className='info'" onMouseOut="this.className='<?php echo $flag%2==0?"active":"success";?>'" id="go<?php print $flag; ?>">
													<td><?php print $count; ?></td>
													<td><?php print dtconvert($rowashis['fdate']); ?> <?php print $rowashis['time']; ?></td>
													<td><?php print ucwords(strtolower(utf8_encode(stripslashes($rowashis['name'])))); ?></td>	
													<td><?php print $rowashis['dob']; ?></td>	
													<td><?php print $rowashis['mobile']; ?></td>	
													<td><?php print number_format($rowashis['gross'],2); ?></td>	
													<td><?php print number_format($rowashis['gst'],2); ?></td>	
													<td><?php print number_format($rowashis['net'],2); ?></td>	
												</tr>	
										<?php $count++; } ?>
											<tr>
												<td colspan="15" align="right" style="font-size: 16px;">
													<strong>
														Total Count: <?php $count--; print $count; ?>&nbsp;&nbsp;&nbsp;&nbsp;Total Amount: Rs. <?php print number_format(round($neta),2); ?>
													</strong>
												</td>
											</tr>
										<?php } else { ?>
											<tr>
												<td colspan="15">Sorry, No birthday billing Found.</td>
											</tr>
										<?php } ?>
										<?php $nettot=$net+$neta; ?>
										<tr>
											<td colspan="15">&nbsp;</td>
										</tr>
										<tr>
											<td colspan="15" align="right" style="font-size: 16px;">
												<h3>
													Total Amount: Rs. <?php print number_format(round($nettot),2); ?>
												</h3>
											</td>
										</tr>
									</tbody>
								</table>
							</div>
						</div>		 
						<div class="clearfix"></div>
					</div>
				</div>
			</div>
		</div>
		<?php include("includes/footer.php"); ?>
	</section>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: blreportdl.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation