1#@!#!123s

file_get_contents 1#@!#!123s
: / home / u247928417 / domains / ranafurnicos.com / public_html / admin / reports /
Filename : view-payu-money-report.php
back
<?php
include ("../session/session.php");
include ("../config/config.php");
include '../panel-files/report-function.php';
//xls download function start here
  function cleanData($str)
  {
    $str = preg_replace("/\t/", "\\t", $str);
    $str = preg_replace("/\r?\n/", "\\n", $str);
    if(strstr($str, '"')) $str = '"' . str_replace('"', '""', $str) . '"';
  }

  // filename for download
  $filename = "payu-money-payment" . date('d-m-Y') . ".xls";

  header("Content-Disposition: attachment; filename=\"$filename\"");
  header("Content-Type: application/vnd.ms-excel");
 //xls download function end here
 
if($_REQUEST['from']!='' and $_REQUEST['to']!=''){
	
$search="where t2.date_order  BETWEEN '".$_REQUEST['from']."' AND '".$_REQUEST['to']."'";	
	
}else{
	
$search='';	
}

$sel_discount= "SELECT * FROM `payment_gateway_transactions` t1
left join `order` t2 on t1.`orders_id`=t2.`order_details_id` ".$search." order by payment_gateway_id DESC";
$disc_result =mysqli_query($conn,$sel_discount) or die(mysqli_error());
 ?>
<table class="table table-striped table-bordered" border="1" style="background-color:#333; color:#fff;">
  <tr>
    <th colspan="9">View PayU Money Payment Gateway Details</th>
  </tr>
</table>

<table class="table table-striped table-bordered" border="1">
                                                <thead>
                                                    <tr>
                                                       
                                                        <th> Transaction Id </th>
                                                        <th> Order Number</th>
                                                        <th> Payu Payment Status</th>
                                                        <th> Payment Mode</th>
                                                        <th> Error Details</th>
                                                        <th> Status</th>
                                                        <th> Payment Gateway Name</th>
                                                        <th> Amount</th>
                                                        <th> Date</th>
                                                    </tr>
                                                </thead>

                                                <tbody>
                                                    <?php while ($fetch_discount= mysqli_fetch_assoc($disc_result)) {?>
                                                            <tr>
                                                               
                                                                <td><?php echo $fetch_discount['payu_transaction_id']?></td>
                                                                <td><?php echo $fetch_discount['order_number']?></td>
                                                                <td><?php echo $fetch_discount['payU_payment_status']; ?></td>
                                                                <td><?php  if($fetch_discount['mode_payment']=='NB'){
																	
																	echo 'Net Banking';
																	
																	
																	}
																	if($fetch_discount['mode_payment']=='CC'){
																	
																	echo 'Credit Card';
																	
																	
																	}
																	if($fetch_discount['mode_payment']=='DC'){
																	
																	echo 'Debit Card';
																	
																	
																	}
																	if($fetch_discount['mode_payment']==''){
																	
																	echo 'None(Payment Failure)';
																	}
																	if ($fetch_discount['mode_payment'] == 'WALLET') {

																	echo    $payment = "WALLET(Payu Money)";
																	}
																	?></td>
                                                               <td><?php echo $fetch_discount['error']; ?></td>
                                                               <td><?php echo $fetch_discount['unmappedstatus']; ?></td>
                                                               <td><?php echo $fetch_discount['payment_gateway_name']; ?></td>
                                                               <td><?php echo $fetch_discount['total_amount']; ?></td>
                                                                <td><?php echo $fetch_discount['date_order']; ?></td>
                                                            </tr>
                                                            <?php } ?>
                                                </tbody>

                                            </table>