Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.37.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u732469475

Directory:

/home/u732469475/domains/apexnova.co.in/public_html/admin/ajaxPages

Free Space:

3.35 TB

🔧 Quick Actions

✏️ Editing: generateReport.php

<?php   
include('../connection/connection.php');

$start_date = $_POST['start_date'];
$end_date = $_POST['end_date'];
$customer = $_POST['customer'];
$product = $_POST['product'];
?>

</script>

<?php
$sql = "SELECT trans.*, prod.p_name ,
		IFNULL(user.fname, '') fname, IFNULL(user.lname, '') lname, IFNULL(guser.fname, '') gfname, IFNULL(guser.lname, '') glname
		FROM `transactions` trans 
		JOIN `product` prod ON prod.id = trans.product_id 
		LEFT JOIN `user_registration` user ON user.id = trans.user_id
		LEFT JOIN `guest_users` guser ON guser.guest_user_id = trans.user_id
		WHERE trans.status = '1'";

if($start_date != '')
{
	$sql .= " AND trans.created_date >= '".$start_date."'";
}
if($end_date != '')
{
	$sql .= " AND trans.created_date <= '".$end_date."'";
}
if($customer != '' && $customer != '-1')
{
	$sql .= " AND user.id = '".$customer."'";
} 
if($customer == '-1')
{
	$sql .= " AND guser.guest_user_id IN (SELECT guest_user_id FROM guest_users WHERE status = '1')";
} 
if($product != '')
{
	$sql .= " AND trans.product_id = '".$product."'";
}

$result = $conn->query($sql);
if($result->num_rows>0)
{
	?>
	
	
	<div class="table-responsive no-border">
		<table id="example" class="table table-bordered table-striped mg-t datatable editable-datatable">
			<thead>
				<tr>   
					<th>User</th>
					<th>Product</th>
					<th>Quantity</th>
					<th>Price</th>
					<th>Date</th>
				</tr>
			</thead>
			
			<tbody>
		<?php
		while($row = $result->fetch_array())
		{
			if($row['fname'] != '' || $row['lname'] != '')
			{
				$fullname = $row['fname']." ". $row['lname'];
			}
			if($row['gfname'] != '' || $row['glname'] != '')
			{
				$fullname = $row['gfname']." ". $row['glname'];
			}		
			
			?>
				<tr>
					<td><?= $fullname; ?></td>
					<td><?= $row['p_name']; ?></td>
					<td><?= $row['product_quantity']; ?></td>
					<td><?= $row['product_cost']; ?></td>
					<td><?= $row['created_date']; ?></td>
				</tr>
			<?php
		}
		?>
			</tbody>
		</table> 
		
		<button class="btn btn-info" name="downloadReport" id="downloadReport">Download Report</button>
	</div>
	<?php
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: generateReport.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation