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: blsummarymnbd.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<br>(Advance & Final Amount)</th>
											<th>Current Month<br>(Advance & Final Amount)</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)) {
											$rowtota=mysqli_fetch_array(mysqli_query($con,"select 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'"));
											$rowtotb=mysqli_fetch_array(mysqli_query($con,"select sum(advance) amt from `bill` bk where bk.aby='".$rowashis['id']."' and bk.bdate>='".$lstdt."' and bk.bdate<='".$lftdt."' and (bk.net='0' or bk.net='') and bk.status='1'"));
											$rowtotc=mysqli_fetch_array(mysqli_query($con,"select 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'"));
											$rowtotd=mysqli_fetch_array(mysqli_query($con,"select sum(advance) amt from `bill` bk where bk.aby='".$rowashis['id']."' and bk.bdate>='".$stdt."' and bk.bdate<='".$ftdt."' and (bk.net='0' or bk.net='') and bk.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;">
														Final: <?php print $rowtota['amt']!=''?round($rowtota['amt']):0; ?><br>
														Advance: <?php print $rowtotb['amt']!=''?round($rowtotb['amt']):0; ?><br>
														-----------<br>
														Total: <?php print round($rowtota['amt']+$rowtotb['amt'],2); ?>
													</td>
													<td style="padding: 3px;"">
														Final: <?php print $rowtotc['amt']!=''?round($rowtotc['amt']):0; ?><br>
														Advance: <?php print $rowtotd['amt']!=''?round($rowtotd['amt']):0; ?><br>
														-----------<br>
														Total: <?php print round($rowtotc['amt']+$rowtotd['amt'],2); ?>
													</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: blsummarymnbd.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation