Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.19.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u802471691

Directory:

/home/u802471691/domains/thetechnozone.in/public_html/stock

Free Space:

9.31 TB

🔧 Quick Actions

✏️ Editing: exportstock.php

<?php include "top.php";

$fromdate=$_REQUEST['fromdate'];
$todate=$_REQUEST['todate'];
$compid=$_REQUEST['compid'];
$stockin=$_REQUEST['stockin'];

if($compid=='0'){

$comname="All Company";

}else{
	$comps=f(q("SELECT * FROM tbl_company WHERE ids='$compid'"));
	$comname=$comps['c_name'];
}

?>
<!DOCTYPE html>
<html>
<head>
	<title><?php echo date("d-m-Y", strtotime($fromdate))?> to <?php echo date("d-m-Y", strtotime($todate))?> Stock Report for <?php echo $comname;?></title>
	
<style>

table {
  width: 100%;
  border-collapse: collapse;
}
tr{
	width: 100%;
}
th{

text-align: center;
	padding-top:20px;
	padding-bottom: 20px;
}
td{

text-align: center;
	border-bottom: 1px solid gray;
}

</style>
<?php

header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=datetodatestock.xls");

?>
</head>
<body style="padding:5%;">
	
	<table>
		
				<tr style="background-color:#d5d5d5;">
						<th>Category</th>
						<th>Product</th>
						<th>Opening Stock</th>
						<th>Current Stock</th>

</tr>

<?php 
				$totalamt=0;
						$cc=mysqli_query($con,"SELECT * FROM tbl_ptype");
					while($arrcats=mysqli_fetch_array($cc)){
						$pp=mysqli_query($con,"SELECT * FROM tbl_products WHERE p_type='$arrcats[pt_id]'");
						while($arrprod=mysqli_fetch_array($pp)){
							if($compid!='0'){
								if($stockin=='0'){	
								$openq=f(q("SELECT SUM(st_quan) as stk FROM tbl_stock WHERE com_id='$compid' AND st_prodid='$arrprod[p_ids]' AND st_date BETWEEN '1970-01-01' AND '$fromdate'"));
							$cq=f(q("SELECT SUM(st_quan) as stk FROM tbl_stock WHERE com_id='$compid' AND st_prodid='$arrprod[p_ids]' AND st_date BETWEEN '$fromdate' AND '$todate'"));
								}elseif($stockin=='1'){
									$openq=f(q("SELECT SUM(st_quan) as stk FROM tbl_stock WHERE com_id='$compid' AND st_prodid='$arrprod[p_ids]' AND st_date BETWEEN '1970-01-01' AND '$fromdate' AND st_quan>0"));
									$cq=f(q("SELECT SUM(st_quan) as stk FROM tbl_stock WHERE com_id='$compid' AND st_prodid='$arrprod[p_ids]' AND st_date BETWEEN '$fromdate' AND '$todate'  AND st_quan>0"));			
									
								}elseif($stockin=='2'){
									$openq=f(q("SELECT SUM(st_quan) as stk FROM tbl_stock WHERE com_id='$compid' AND st_prodid='$arrprod[p_ids]' AND st_date BETWEEN '1970-01-01' AND '$fromdate'  AND st_quan<0"));
							$cq=f(q("SELECT SUM(st_quan) as stk FROM tbl_stock WHERE com_id='$compid' AND st_prodid='$arrprod[p_ids]' AND st_date BETWEEN '$fromdate' AND '$todate'  AND st_quan<0"));

}

}else{

if($stockin=='0'){

$openq=f(q("SELECT SUM(st_quan) as stk FROM tbl_stock WHERE st_prodid='$arrprod[p_ids]' AND st_date BETWEEN '1970-01-01' AND '$fromdate'"));
							$cq=f(q("SELECT SUM(st_quan) as stk FROM tbl_stock WHERE st_prodid='$arrprod[p_ids]' AND st_date BETWEEN '$fromdate' AND '$todate'"));

}elseif($stockin=='1'){

$openq=f(q("SELECT SUM(st_quan) as stk FROM tbl_stock WHERE st_prodid='$arrprod[p_ids]'  AND st_quan>0 AND st_date BETWEEN '1970-01-01' AND '$fromdate'"));
							$cq=f(q("SELECT SUM(st_quan) as stk FROM tbl_stock WHERE st_prodid='$arrprod[p_ids]'  AND st_quan>0 AND st_date BETWEEN '$fromdate' AND '$todate'"));

}elseif($stockin=='2'){

$openq=f(q("SELECT SUM(st_quan) as stk FROM tbl_stock WHERE st_prodid='$arrprod[p_ids]' AND st_quan<0 AND st_date BETWEEN '1970-01-01' AND '$fromdate'"));
							$cq=f(q("SELECT SUM(st_quan) as stk FROM tbl_stock WHERE st_prodid='$arrprod[p_ids]' AND st_quan<0 AND st_date BETWEEN '$fromdate' AND '$todate'"));

}

</tr>

<?php  } } ?>

</table>

</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: exportstock.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation