gozap_api/Reports/User/index.php

<?php

// Include Database connection
include_once "../../include/DB.php";
// Include SimpleXLSXGen library
include_once "../../include/SimpleXLSXGen.php";
$id = 0;
$fromDate="";
$toDate="";
$userSqlfilter="";
$userCountSqlfilter="";
$users = [
  ['#', 'User ID', 'Rider ID', 'DEID', 'User Name', 'Phone Number', 'User Created At', 'User UpdatedAt']
];

$userCount = [
  ['#', 'Date', 'Count']
];
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')";
}
if (isset($_GET["RiderID"]) && !empty($_GET["RiderID"])) {
  $RiderID=$_GET["RiderID"];
  $userSqlfilter .=" AND user.RiderID='$RiderID'";
  $userCountSqlfilter .=" AND user.RiderID='$RiderID'";
}
include 'user_report.php';

$xlsx = SimpleXLSXGen::fromArray($users,'Users')->addSheet($userCount,'User Count');
$xlsx->downloadAs('users_report.xlsx'); // This will download the file to your local system

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

echo "<pre>";
print_r($users);
print_r($userCount);