gozap_api/Reports/index.php

<?php

// Include Database connection
include_once "../include/DB.php";
// Include SimpleXLSXGen library
include_once "../include/SimpleXLSXGen.php";
$id = 0;
$RiderID="";
$AssetID="";
$fromDate="";
$toDate="";
$filter="";
$userSqlfilter="";
$userCountSqlfilter="";
$swapSqlfilter="";
$swapCountSqlfilter="";
$rechargeSqlfilter="";
$rechargeCountSqlfilter="";
$serviceSqlfilter="";
$assetSqlfilter="";
$users = [
  ['#', 'User ID', 'Rider ID', 'DEID', 'User Name', 'Phone Number', 'User Created At', 'User UpdatedAt']
];
$userCount = [
  ['#', 'Date', 'Count']
];
$swaps = [
  ['#', 'Rider ID', 'DEID', 'Return Batter ID', 'Swapped Batter ID', 'Is Free Swap', 'Swap Created At', 'Swap UpdatedAt']
];
$swapCount = [
  ['#', 'Date', 'Count']
];
$recharges = [
  ['#', 'Recharge History ID', 'Rider ID', 'DEID', 'Transaction ID', 'Payment Type ID', 'Recharge Created At', 'Recharge Updated At']
];
$rechargeCount = [
  ['#', 'Date', 'Count']
];
$services = [
  ['#', 'Service History ID', 'Asset ID', 'is Serviced', 'In Ward', 'out Ward', 'Service Created At', 'Service Updated At']
];
$assets = [
  ['#', 'Asset ID', 'Asset Name', 'IsInServiceCenter', 'Asset Category', 'Asset Created At', 'Asset Updated At']
];
if (isset($_GET["fromDate"]) && !empty($_GET["fromDate"]) && isset($_GET["toDate"]) && !empty($_GET["toDate"])) {
  $fromDate=$_GET["fromDate"];
  $toDate=$_GET["toDate"];
  $userSqlfilter .="AND user.CreatedDate BETWEEn '$fromDate' AND '$toDate'";
  $userCountSqlfilter .="AND (user.CreatedDate BETWEEn '$fromDate' AND '$toDate')";
  $swapSqlfilter .="AND (swap.CreatedDate BETWEEn '$fromDate' AND '$toDate')";
  $swapCountSqlfilter .="AND (swap.CreatedDate BETWEEn '$fromDate' AND '$toDate')";
  $rechargeSqlfilter .="AND (recharge.CreatedDate BETWEEN '$fromDate' AND '$toDate')";
  $rechargeCountSqlfilter .="AND (recharge.CreatedDate BETWEEN '$fromDate' AND '$toDate')";
  $serviceSqlfilter .="AND (servicehistory.CreatedDate BETWEEN '$fromDate' AND '$toDate')";
  $assetSqlfilter .="AND (asset.CreatedDate BETWEEN '$fromDate' AND '$toDate')";
}
if (isset($_GET["RiderID"]) && !empty($_GET["RiderID"])) {
  $RiderID=$_GET["RiderID"];
  $userSqlfilter .=" AND user.RiderID='$RiderID'";
  $userCountSqlfilter .=" AND user.RiderID='$RiderID'";
  $swapSqlfilter .=" AND swap.RiderID='$RiderID'";
  $swapCountSqlfilter .=" AND swap.RiderID='$RiderID'";
  $rechargeSqlfilter .=" AND recharge.RiderID='$RiderID'";
  $rechargeCountSqlfilter .=" AND recharge.RiderID='$RiderID'";
}
if (isset($_GET["AssetID"]) && !empty($_GET["AssetID"])) {
  $AssetID=$_GET["AssetID"];
  $serviceSqlfilter .="AND servicehistory.AssetID='$AssetID'";
  $assetSqlfilter .="AND asset.AssetID='$AssetID'";
}


include 'User/user_report.php';
include 'Swap/swap_report.php';
include 'Service/service_report.php';
include 'Recharge/recharge_report.php';
include 'Asset/asset_report.php';

$xlsx = SimpleXLSXGen::fromArray($users,'Users')->addSheet($userCount,'User Count')->addSheet($swaps,'Swap')->addSheet($swapCount,'Swap Count')->addSheet($recharges,'Recharge')->addSheet($rechargeCount,'Recharge Count')->addSheet($services,'Service')->addSheet($assets,'Asset');
$xlsx->downloadAs('report.xlsx'); // This will download the file to your local system

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

echo "<pre>";
print_r($users);
print_r($userCount);
print_r($swaps);
print_r($swapCount);
print_r($recharges);
print_r($rechargeCount);
print_r($services);
print_r($assets);