Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

Apache

System:

Linux 5.14.0-570.60.1.el9_6.x86_64

PHP Version:

8.1.34

User:

jivandharaoldage

Directory:

/home/jivandharaoldage/www/donation/admin

Free Space:

26.69 GB

🔧 Quick Actions

✏️ Editing: print_report_donation_collection.php

<?php 
error_reporting(0);
session_start(); 
include('config.php');

$group_name = $_GET['group_name'];  echo '<br>';
   $donation_status = $_GET['donation_status'];  echo '<br>';
  $datefrom = $_GET['datefrom']; echo '<br>';
   $datetos = $_GET['datetos']; echo '<br>';
 ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<title>Print Invoice</title>
<head>
<style type="text/css">
@media print {
input#printButton {
display: none;
}
}
</style>
</head>
<body>
<center>
  <form name="form" method="post" >
    <input type="submit" id="printButton" onclick="window.print();" value="Print Invoice" name="print" />
    
  </form>
  <?php  
	if(isset($_REQUEST['print'])) 
		{    				
	//unset($_SESSION['lastid']);
	?>
  <script language="javascript">window.location.href="report_donation_collection.php";</script>
  <?php
		} 
 		?>
</center>
<center>
  <table width="100%" id="example-datatables" border="1"  cellspacing="0" cellpadding="0">
    <thead>
      <tr height="50">
        <td  colspan="8" align="center"><b style="font-size:18px" >* Report Donation Collection *</b></td>
      <tr>
    </thead>
    <tbody>
      
      <tr>
        
        <th>Name</th>
      
        <th align="center">Mobile</th>
        <th>Group Name</th>
        <th align="center">Donate Amount</th>
        <th align="center">Payment Type</th>
        <th align="center">Pay Date</th>
        <th align="center">Status</th>
      </tr>
      <?php				$n=0;
                           		 if($group_name == '' && $donation_status == '' && $datefrom != '1970-01-01' && $datetos != '1970-01-01')
 								{
								  $ure="SELECT *  FROM tbl_donation_detail where reg_date between '$datefrom' and '$datetos' order by donation_id desc";
								
								   $ures = mysqli_query($conn,$ure);
								   
								   
 								}
								
							    else if($group_name != '' && $donation_status == '' && $datefrom != '1970-01-01' && $datetos != '1970-01-01')
  								{
								 $ure="SELECT *  FROM tbl_donation_detail WHERE group_name='$group_name' && reg_date between '$datefrom' and '$datetos' order by donation_id desc";
							
								$ures = mysqli_query($conn,$ure);
  								} 	
								
								else if($group_name == '' && $donation_status != '' && $datefrom == '1970-01-01' && $datetos == '1970-01-01')
  								{
								 $ure="SELECT *  FROM tbl_donation_detail WHERE donation_status='$donation_status'  order by donation_id desc";
							
								$ures = mysqli_query($conn,$ure);
  								} 	
								
								 else if($group_name != '' && $donation_status == '' && $datefrom == '1970-01-01' && $datetos == '1970-01-01')
  								{
								 $ure="SELECT *  FROM tbl_donation_detail WHERE group_name='$group_name'  order by donation_id desc";
							
								$ures = mysqli_query($conn,$ure);
  								} 	
								
								  else if($group_name == '' && $donation_status != '' && $datefrom != '1970-01-01' && $datetos != '1970-01-01')
  								{
								  $ure="SELECT *  FROM tbl_donation_detail WHERE donation_status='$donation_status' AND reg_date between '$datefrom' and '$datetos' order by donation_id desc";
							
								$ures = mysqli_query($conn,$ure);
  								} 	
								
								 else if($group_name != '' && $donation_status != '' && $datefrom == '1970-01-01' && $datetos == '1970-01-01')
  								{
								  $ure="SELECT *  FROM tbl_donation_detail WHERE group_name='$group_name' && donation_status='$donation_status' order by donation_id desc";
							
								$ures = mysqli_query($conn,$ure);
  								} 	
								
								 else if($group_name != '' && $donation_status != '' && $datefrom != '1970-01-01' && $datetos != '1970-01-01')
  								{
								 $ure="SELECT *  FROM tbl_donation_detail WHERE group_name='$group_name' && donation_status='$donation_status' AND donation_status='$donation_status' AND reg_date between '$datefrom' and '$datetos' order by donation_id desc"; 
							
								$ures = mysqli_query($conn,$ure);
  								} 						 		
								
									 							 					 
								
								while($urow=mysqli_fetch_array($ures))
								{ 
									$pay_date1 = $urow['pay_date'];
									$donation_status1 = $urow['donation_status'];
								 	?>
      <tr>
																									
																								
													<td><?php echo $urow['donator_name']; ?></td>
													<?php /*?><td><?php echo $urow['donator_address']; ?></td><?php */?>
													<td align="center"><?php echo $urow['donator_mobile']; ?></td>
													
													<td><?php echo $urow['group_name']; ?></td>
													<td align="right"><?php echo $total = $urow['donator_amount']; $total_amount2[] = $urow['donator_amount']; ?>.00</td>
													<td align="center"><?php echo $urow['payment_type']; ?></td>
													<?php if($pay_date1 == '' || $pay_date1 == '1970-01-01' || $pay_date1 == '0000-00-00'){?>
													<td align="center">-</td>
													<?php } else { ?>
													<td align="center"><?php $date1=$urow['pay_date']; echo  $pay_date =date("d-m-Y", strtotime($date1)); ?></td>
													<?php } ?>
													<td align="center"><?php echo $urow['donation_status']; ?></td>
													
													
													
													
													
												</tr>
												<?php } ?>
												<tr>
																									
																								
													<td colspan="7">&nbsp;</td>
													</tr>
													<tr>
													<td colspan="3" align="right"><b>Total Collection :</b></td>
													
													<td align="right"> <b><?php $total_amount11 = array_sum($total_amount1); $total_amount22 = array_sum($total_amount2); echo $total_amount3 = $total_amount11 + $total_amount22; ?>.00</b></td>
													
													<td colspan="3">&nbsp;</td>
													
													
													
													
													
												</tr>
												
    </tbody>
  </table>
  </tbody>
  </table>
</center>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: print_report_donation_collection.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation