connect_error) {
die("DB connection failed");
}
/*$SECRET_TOKEN = 'EXPORT_FFC_2026';
if (!isset($_POST['token']) || $_POST['token'] !== $SECRET_TOKEN) {
http_response_code(403);
exit('Unauthorized');
}
if (empty($_POST['export'])) {
exit('No report selected');
}
*/
if (empty($_POST['export'])) {
die('No data selected for export');
}
foreach ($_POST['export'] as $type) {
if ($type == 'vimal') {
$sql = "select tbl_history_devices.sys_service_id, `group`.id,name,veh_reg_api,services.veh_reg as vehiclenumber,imei,sys_service_id,
mobile_simcards.mobile_no ,tbl_history_devices.add_date ,remove_date from tbl_history_devices left join services on tbl_history_devices.sys_service_id=services.id
left join devices on services.sys_device_id=devices.id
left join mobile_simcards on mobile_simcards.id=devices.sys_simcard
left join `group` on tbl_history_devices.sys_group_id=`group`.id where (remove_date is null or remove_date ='0000-00-00 00:00:00') and sys_group_id!=1998 order by name,veh_reg";
}
if ($type == 'elock') {
$sql = "select sys_group_id,name,veh_reg_api,services.veh_reg as vehiclenumber,imei,
mobile_simcards.mobile_no ,group_services.sys_added_date,veh_reg1 as ControlerNum from group_services left join services on group_services.sys_service_id=services.id
left join devices on services.sys_device_id=devices.id
left join mobile_simcards on mobile_simcards.id=devices.sys_simcard
left join `group` on group_services.sys_group_id=`group`.id where sys_group_id not in (55660,55848,55850,55851,55852,55853,55854,55855,55856,55857,55858,55923,56000,57275,57320,57385,57454,57540,57798,58065,58072,58102,58134,58135,59271,59274,59299,59392,59393,59639,59640,59641,59642,59646,59658,59708,59752,59753,59758,59759,59760,59761,59762,59763,59764,59765,59766,59767,59768,59769,59770,59771,59772,59773,59774,59775,59776,59777,59778,59779,59780,59804,59875,59876,59877,59878,59879,59880,59881,59882,59883,59964,59965,59966,60032,60034,60035,60036,60037,60038,60039,60040,60041,55849,55660,55850,55851,55852,55853,55854,55855,55856,55857,55858,55923,56000,57275,57454,57798,58065,58072,58102,58134,58135,1998,55907,57236,55924) and services.veh_body='controller'
order by name,veh_reg";
}
$result = $mysql->query($sql);
if (!$result) {
die("Query failed: " . $mysql->error);
}
$excel_data .= '