gozap_api/Reports/Recharge/index.php

<?php

// Include Database connection
include_once "../../include/DB.php";
// Include SimpleXLSXGen library
include_once "../../include/SimpleXLSXGen.php";
$id = 0;
$fromDate="";
$toDate="";
$rechargeSqlfilter="";
$rechargeCountSqlfilter="";
$recharges = [
  ['#', 'Recharge History ID', 'Rider ID', 'DEID', 'Transaction ID', 'Payment Type ID', 'Recharge Created At', 'Recharge Updated At']
];
$rechargeCount = [
  ['#', 'Date', 'Count']
];
if (isset($_GET["fromDate"]) && !empty($_GET["fromDate"]) && isset($_GET["toDate"]) && !empty($_GET["toDate"])) {
  $fromDate=$_GET["fromDate"];
  $toDate=$_GET["toDate"];
  $rechargeSqlfilter="AND (recharge.CreatedDate BETWEEN '$fromDate' AND '$toDate')";
  $rechargeCountSqlfilter="AND (recharge.CreatedDate BETWEEN '$fromDate' AND '$toDate')";
}
if (isset($_GET["RiderID"]) && !empty($_GET["RiderID"])) {
  $RiderID=$_GET["RiderID"];
  $rechargeSqlfilter .=" AND recharge.RiderID='$RiderID'";
  $rechargeCountSqlfilter .=" AND recharge.RiderID='$RiderID'";
}
include 'recharge_report.php';

$xlsx = SimpleXLSXGen::fromArray($recharges,'Recharge');
$xlsx->downloadAs('recharge_report.xlsx'); // This will download the file to your local system

// $xlsx->saveAs('recharge_report.xlsx'); // This will save the file to your server

echo "<pre>";
print_r($recharges);