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: exportdestock.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'];
}

//echo $compid;

?>
<!DOCTYPE html>
<html>
<head>
	
	
<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=datetodatedetailsstock.xls");

?>
</head>
<body style="padding:5%;">
	
	<table>
		
				<tr style="background-color:#d5d5d5;">
                        <th>Category</th>
						<th>Product</th>
                        <th>Date</th>
						<th>Company</th>
                        <th>Type</th>
						<th>Quan</th>

</tr>

<?php 
				$totalamt=0;
                if($compid=='0'){
                    
                    if($stockin=='0'){

$qry="SELECT * FROM tbl_stock WHERE st_date BETWEEN '$fromdate' AND '$todate'";

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

$qry="SELECT * FROM tbl_stock WHERE st_quan > 0 AND st_date BETWEEN '$fromdate' AND '$todate'";

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

$qry="SELECT * FROM tbl_stock WHERE st_quan < 0 AND st_date BETWEEN '$fromdate' AND '$todate'";

}

}else{

if($stockin=='0'){

$qry="SELECT * FROM tbl_stock WHERE com_id='$compid' AND st_date BETWEEN '$fromdate' AND '$todate'";

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

$qry="SELECT * FROM tbl_stock WHERE com_id='$compid' AND  st_quan > 0 AND st_date BETWEEN '$fromdate' AND '$todate'";

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

$qry="SELECT * FROM tbl_stock WHERE com_id='$compid' AND  st_quan < 0 AND st_date BETWEEN '$fromdate' AND '$todate'";

}

}
                //echo $qry;
                $cc=mysqli_query($con,$qry);
                while($arrcats=mysqli_fetch_array($cc)){
                    
                        $getcats=f(q("SELECT * FROM tbl_ptype WHERE pt_id=(SELECT p_type FROM tbl_products WHERE p_ids='$arrcats[st_prodid]')"));
                        $catname=$getcats['pt_name'];
                        $getprods=f(q("SELECT * FROM tbl_products WHERE p_ids='$arrcats[st_prodid]'"));
                        $coms=f(q("SELECT * FROM tbl_company WHERE ids='$arrcats[com_id]'"));
                        $comnames=$coms['c_name'];

</tr>

<?php  } ?>

</table>

</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: exportdestock.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation