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: blsummarymn.php

<?php
ob_start();
session_start();
error_reporting(0);
include("includes/connection.php");
include("includes/functions.php");
include("includes/headermain.php");
?>
<script src="js/jsfunction.js" type="text/javascript"></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 Summary Storewise</h3>
						<div class="tabls">
							<div id="uform" class="bs-bg" data-example-id="contextual-table">
								<table class="table">
									<thead>
										<tr>
											<th>Store</th>
											<th>Last Month</th>
											<th>Current Month</th>
										</tr>
									</thead>
									<tbody>
										<?php
										$dt=date("d");
										$mn=date("m");
										$yr=date("Y");
										$mnl=$mn-1;
										if($mnl<1) {
											$mnl=12;
											$yr=$yr-1;
										}
										$stdt=date("Y")."-".$mn."-01";
										$ftdt=date("Y-m-d");
										$lstdt=$yr."-".$mnl."-01";
										$lftdt=$yr."-".$mnl."-".$dt;
										$tcount=0;
										$tamnt=0;
										$sqlashis="select * from `admin` where `utype`='store' and `status`='1' and `id`!='43'";
										$resshis=mysqli_query($con,$sqlashis);
										while($rowashis=mysqli_fetch_array($resshis)) {
											$rowtot=mysqli_fetch_array(mysqli_query($con,"select count(*) as cnt, sum(net) amt from `booking` bk where bk.aby='".$rowashis['id']."' and bk.date>='".$lstdt."' and bk.date<='".$lftdt."' and bk.net!='0' and bk.net<'2000' and bk.status='1'"));
											//$tcount+=$rowtot['cnt'];
											//$tamnt+=$rowtot['amt'];
											$rowtotv=mysqli_fetch_array(mysqli_query($con,"select count(*) as cnt from `booking` bk where bk.aby='".$rowashis['id']."' and bk.date>='".$lstdt."' and bk.date<='".$lftdt."' and bk.amount='0' and bk.status='1'"));
											$rowtotnv=mysqli_fetch_array(mysqli_query($con,"select count(*) as cnt, sum(net) amt from `booking` bk where bk.aby='".$rowashis['id']."' and bk.date>='".$lstdt."' and bk.date<='".$lftdt."' and bk.net>='2000' and bk.status='1'"));
											$rowtotbr=mysqli_fetch_array(mysqli_query($con,"select count(*) as cnt, sum(net) amt from `bill` bk where bk.aby='".$rowashis['id']."' and bk.fdate>='".$lstdt."' and bk.fdate<='".$lftdt."' and bk.net>'0' and bk.status='1'"));

$rowtotc=mysqli_fetch_array(mysqli_query($con,"select count(*) as cnt, sum(net) amt from `booking` bk where bk.aby='".$rowashis['id']."' and bk.date>='".$stdt."' and bk.date<='".$ftdt."' and bk.net!='0' and bk.net<'2000' and bk.status='1'"));
											//$tcount+=$rowtot['cnt'];
											//$tamnt+=$rowtot['amt'];
											$rowtotvc=mysqli_fetch_array(mysqli_query($con,"select count(*) as cnt from `booking` bk where bk.aby='".$rowashis['id']."' and bk.date>='".$stdt."' and bk.date<='".$ftdt."' and bk.amount='0' and bk.status='1'"));
											$rowtotnvc=mysqli_fetch_array(mysqli_query($con,"select count(*) as cnt, sum(net) amt from `booking` bk where bk.aby='".$rowashis['id']."' and bk.date>='".$stdt."' and bk.date<='".$ftdt."' and bk.net>='2000' and bk.status='1'"));
											$rowtotbrc=mysqli_fetch_array(mysqli_query($con,"select count(*) as cnt, sum(net) amt from `bill` bk where bk.aby='".$rowashis['id']."' and bk.fdate>='".$stdt."' and bk.fdate<='".$ftdt."' and bk.net>'0' and bk.status='1'"));
											//print "select count(*) as cnt, sum(net) amt from `bill` bk where bk.aby='".$rowashis['id']."' and bk.date>='".$stdt."' and bk.date<='".$ftdt."' and bk.net>'0' and `status`='1'";
									?>
												<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 style="padding: 3px;"><?php print $rowashis['blng']; ?></td>
													<td style="padding: 3px;">
														NC: <?php print $rowtot['cnt']; ?><br>
														VC: <?php print $rowtotv['cnt']; ?><br>
														NVC: <?php print $rowtotnv['cnt']; ?><br>
														NA: <?php print $rowtot['amt']; ?><br>
														NVA: <?php print $rowtotnv['amt']; ?><br><br>
														BC: <?php print $rowtotbr['cnt']; ?><br>
														BA: <?php print $rowtotbr['amt']!=''?round($rowtotbr['amt']):0; ?><br>
														-----------<br>
														Total: <?php print round($rowtot['amt']+$rowtotnv['amt']+$rowtotbr['amt']); ?>
													</td>
													<td style="padding: 3px;"">
														NC: <?php print $rowtotc['cnt']; ?><br>
														VC: <?php print $rowtotvc['cnt']; ?><br>
														NVC: <?php print $rowtotnvc['cnt']; ?><br>
														NA: <?php print $rowtotc['amt']; ?><br>
														NVA: <?php print $rowtotnvc['amt']; ?><br><br>
														BC: <?php print $rowtotbrc['cnt']; ?><br>
														BA: <?php print $rowtotbrc['amt']!=''?round($rowtotbrc['amt']):0; ?><br>
														-----------<br>
														Total: <?php print round($rowtotc['amt']+$rowtotnvc['amt']+$rowtotbrc['amt']); ?>
													</td>		
												</tr>	
										<?php $count++; } ?>
										<?php /* ?><tr>
											<td colspan="15" align="right" style="font-size: 16px;">
												<strong>
													Total Count: <?php print $tcount; ?>&nbsp;&nbsp;&nbsp;&nbsp;Total Amount: Rs. <?php print number_format(round($tamnt),2); ?>
												</strong>
											</td>
										</tr><?php */ ?>
									</table>
								</div>	
							</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: blsummarymn.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation