ERROR - 2025-06-06 00:20:58 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-06 00:20:58 --> 
ERROR - 2025-06-06 00:23:39 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-06 00:23:39 --> 
ERROR - 2025-06-06 00:24:49 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-06 00:24:49 --> 
ERROR - 2025-06-06 13:24:23 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-06 13:24:23 --> 
ERROR - 2025-06-06 13:25:55 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-06 13:25:55 --> 
ERROR - 2025-06-06 14:06:17 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-06 14:06:17 --> 
ERROR - 2025-06-06 18:38:21 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-06 18:38:21 --> 
ERROR - 2025-06-06 19:37:42 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-06 19:37:42 --> 
CRITICAL - 2025-06-06 20:09:11 --> whereIn() expects $values to be of type array or closure
in SYSTEMPATH/Database/BaseBuilder.php on line 940.
 1 SYSTEMPATH/Database/BaseBuilder.php(827): CodeIgniter\Database\BaseBuilder->_whereIn('trips.company_id', '1', false, 'AND ', null)
 2 SYSTEMPATH/Model.php(871): CodeIgniter\Database\BaseBuilder->whereIn('trips.company_id', '1')
 3 ROOTPATH/modules/Trip/Models/SubtripModel.php(105): CodeIgniter\Model->__call('whereIn', [...])
 4 ROOTPATH/modules/Coupon/Controllers/Coupon.php(387): Modules\Trip\Models\SubtripModel->getTripsByCompany('1')
 5 SYSTEMPATH/CodeIgniter.php(932): Modules\Coupon\Controllers\Coupon->getTripsByCompany()
 6 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Coupon\Controllers\Coupon))
 7 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 8 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 9 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-06 20:09:27 --> whereIn() expects $values to be of type array or closure
in SYSTEMPATH/Database/BaseBuilder.php on line 940.
 1 SYSTEMPATH/Database/BaseBuilder.php(827): CodeIgniter\Database\BaseBuilder->_whereIn('trips.company_id', '2', false, 'AND ', null)
 2 SYSTEMPATH/Model.php(871): CodeIgniter\Database\BaseBuilder->whereIn('trips.company_id', '2')
 3 ROOTPATH/modules/Trip/Models/SubtripModel.php(105): CodeIgniter\Model->__call('whereIn', [...])
 4 ROOTPATH/modules/Coupon/Controllers/Coupon.php(387): Modules\Trip\Models\SubtripModel->getTripsByCompany('2')
 5 SYSTEMPATH/CodeIgniter.php(932): Modules\Coupon\Controllers\Coupon->getTripsByCompany()
 6 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Coupon\Controllers\Coupon))
 7 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 8 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 9 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-06 20:27:03 --> whereIn() expects $values to be of type array or closure
in SYSTEMPATH/Database/BaseBuilder.php on line 940.
 1 SYSTEMPATH/Database/BaseBuilder.php(827): CodeIgniter\Database\BaseBuilder->_whereIn('trips.company_id', '1', false, 'AND ', null)
 2 SYSTEMPATH/Model.php(871): CodeIgniter\Database\BaseBuilder->whereIn('trips.company_id', '1')
 3 ROOTPATH/modules/Trip/Models/SubtripModel.php(105): CodeIgniter\Model->__call('whereIn', [...])
 4 APPPATH/Controllers/AjaxController.php(427): Modules\Trip\Models\SubtripModel->getTripsByCompany('1')
 5 SYSTEMPATH/CodeIgniter.php(932): App\Controllers\AjaxController->getTripsByCompany()
 6 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AjaxController))
 7 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 8 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 9 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-06 20:28:54 --> whereIn() expects $values to be of type array or closure
in SYSTEMPATH/Database/BaseBuilder.php on line 940.
 1 SYSTEMPATH/Database/BaseBuilder.php(827): CodeIgniter\Database\BaseBuilder->_whereIn('trips.company_id', '1', false, 'AND ', null)
 2 SYSTEMPATH/Model.php(871): CodeIgniter\Database\BaseBuilder->whereIn('trips.company_id', '1')
 3 ROOTPATH/modules/Trip/Models/SubtripModel.php(105): CodeIgniter\Model->__call('whereIn', [...])
 4 APPPATH/Controllers/AjaxController.php(427): Modules\Trip\Models\SubtripModel->getTripsByCompany('1')
 5 SYSTEMPATH/CodeIgniter.php(932): App\Controllers\AjaxController->getTripsByCompany()
 6 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AjaxController))
 7 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 8 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 9 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-06 20:43:04 --> Class 'Modules\Trip\Models\SubtripModel' not found
in ROOTPATH/modules/Report/Controllers/Report.php on line 60.
 1 SYSTEMPATH/CodeIgniter.php(904): Modules\Report\Controllers\Report->__construct()
 2 SYSTEMPATH/CodeIgniter.php(488): CodeIgniter\CodeIgniter->createController()
 3 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 4 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 5 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
ERROR - 2025-06-06 20:52:05 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-06 20:52:05 --> 
ERROR - 2025-06-06 21:09:02 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-06 21:09:02 --> 
CRITICAL - 2025-06-06 21:19:01 --> syntax error, unexpected end of file
in ROOTPATH/modules/Report/Controllers/Report.php on line 323.
 1 SYSTEMPATH/Autoloader/Autoloader.php(291): CodeIgniter\Autoloader\Autoloader->includeFile('/home/busvalle/data.busvalley.com/busvalley_new/modules/Report/Controllers/Report.php')
 2 SYSTEMPATH/Autoloader/Autoloader.php(269): CodeIgniter\Autoloader\Autoloader->loadInNamespace('Modules\\Report\\Controllers\\Report')
 3 [internal function]: CodeIgniter\Autoloader\Autoloader->loadClass('Modules\\Report\\Controllers\\Report')
 4 [internal function]: spl_autoload_call('Modules\\Report\\Controllers\\Report')
 5 SYSTEMPATH/CodeIgniter.php(890): class_exists('\\Modules\\Report\\Controllers\\Report', true)
 6 SYSTEMPATH/CodeIgniter.php(484): CodeIgniter\CodeIgniter->startController()
 7 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 8 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 9 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
ERROR - 2025-06-06 21:20:37 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-06 21:20:37 --> 
CRITICAL - 2025-06-06 21:26:59 --> Array to string conversion
in ROOTPATH/modules/Report/Views/report/ticketsold.php on line 89.
 1 ROOTPATH/modules/Report/Views/report/ticketsold.php(89): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Array to string conversion', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Report/Views/report/ticketsold.php', 89, [...])
 2 SYSTEMPATH/View/View.php(226): include('/home/busvalle/data.busvalley.com/busvalley_new/modules/Report/Views/report/ticketsold.php')
 3 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
 4 SYSTEMPATH/Common.php(1174): CodeIgniter\View\View->render('Modules\\Report\\Views\\report/ticketsold', [], true)
 5 ROOTPATH/modules/Report/Controllers/Report.php(319): view('Modules\\Report\\Views\\report/ticketsold', [...])
 6 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleData()
 7 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
 8 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 9 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
10 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-06 21:29:53 --> syntax error, unexpected end of file
in ROOTPATH/modules/Report/Controllers/Report.php on line 327.
 1 SYSTEMPATH/Autoloader/Autoloader.php(291): CodeIgniter\Autoloader\Autoloader->includeFile('/home/busvalle/data.busvalley.com/busvalley_new/modules/Report/Controllers/Report.php')
 2 SYSTEMPATH/Autoloader/Autoloader.php(269): CodeIgniter\Autoloader\Autoloader->loadInNamespace('Modules\\Report\\Controllers\\Report')
 3 [internal function]: CodeIgniter\Autoloader\Autoloader->loadClass('Modules\\Report\\Controllers\\Report')
 4 [internal function]: spl_autoload_call('Modules\\Report\\Controllers\\Report')
 5 SYSTEMPATH/CodeIgniter.php(890): class_exists('\\Modules\\Report\\Controllers\\Report', true)
 6 SYSTEMPATH/CodeIgniter.php(484): CodeIgniter\CodeIgniter->startController()
 7 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 8 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 9 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-06 21:33:12 --> Undefined variable: selectedMainTrips
in ROOTPATH/modules/Report/Views/report/ticketsold.php on line 89.
 1 ROOTPATH/modules/Report/Views/report/ticketsold.php(89): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Undefined variable: selectedMainTrips', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Report/Views/report/ticketsold.php', 89, [...])
 2 SYSTEMPATH/View/View.php(226): include('/home/busvalle/data.busvalley.com/busvalley_new/modules/Report/Views/report/ticketsold.php')
 3 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
 4 SYSTEMPATH/Common.php(1174): CodeIgniter\View\View->render('Modules\\Report\\Views\\report/ticketsold', [], true)
 5 ROOTPATH/modules/Report/Controllers/Report.php(162): view('Modules\\Report\\Views\\report/ticketsold', [...])
 6 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleLoad()
 7 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
 8 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 9 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
10 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-06 21:33:32 --> Undefined variable: selectedMainTrips
in ROOTPATH/modules/Report/Views/report/ticketsold.php on line 89.
 1 ROOTPATH/modules/Report/Views/report/ticketsold.php(89): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Undefined variable: selectedMainTrips', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Report/Views/report/ticketsold.php', 89, [...])
 2 SYSTEMPATH/View/View.php(226): include('/home/busvalle/data.busvalley.com/busvalley_new/modules/Report/Views/report/ticketsold.php')
 3 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
 4 SYSTEMPATH/Common.php(1174): CodeIgniter\View\View->render('Modules\\Report\\Views\\report/ticketsold', [], true)
 5 ROOTPATH/modules/Report/Controllers/Report.php(162): view('Modules\\Report\\Views\\report/ticketsold', [...])
 6 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleLoad()
 7 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
 8 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 9 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
10 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-06 21:33:36 --> syntax error, unexpected ''expe' (T_ENCAPSED_AND_WHITESPACE), expecting ']'
in ROOTPATH/modules/Report/Controllers/Report.php on line 879.
 1 SYSTEMPATH/Autoloader/Autoloader.php(291): CodeIgniter\Autoloader\Autoloader->includeFile('/home/busvalle/data.busvalley.com/busvalley_new/modules/Report/Controllers/Report.php')
 2 SYSTEMPATH/Autoloader/Autoloader.php(269): CodeIgniter\Autoloader\Autoloader->loadInNamespace('Modules\\Report\\Controllers\\Report')
 3 [internal function]: CodeIgniter\Autoloader\Autoloader->loadClass('Modules\\Report\\Controllers\\Report')
 4 [internal function]: spl_autoload_call('Modules\\Report\\Controllers\\Report')
 5 SYSTEMPATH/CodeIgniter.php(890): class_exists('\\Modules\\Report\\Controllers\\Report', true)
 6 SYSTEMPATH/CodeIgniter.php(484): CodeIgniter\CodeIgniter->startController()
 7 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 8 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 9 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-06 21:33:41 --> Undefined variable: selectedMainTrips
in ROOTPATH/modules/Report/Controllers/Report.php on line 81.
 1 ROOTPATH/modules/Report/Controllers/Report.php(81): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Undefined variable: selectedMainTrips', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Report/Controllers/Report.php', 81, [...])
 2 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleLoad()
 3 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
 4 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 5 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 6 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-06 21:33:55 --> Undefined variable: selectedMainTrips
in ROOTPATH/modules/Report/Controllers/Report.php on line 81.
 1 ROOTPATH/modules/Report/Controllers/Report.php(81): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Undefined variable: selectedMainTrips', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Report/Controllers/Report.php', 81, [...])
 2 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleLoad()
 3 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
 4 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 5 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 6 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-06 21:35:44 --> Undefined variable: sub_trip
in ROOTPATH/modules/Report/Controllers/Report.php on line 277.
 1 ROOTPATH/modules/Report/Controllers/Report.php(277): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Undefined variable: sub_trip', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Report/Controllers/Report.php', 277, [...])
 2 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleData()
 3 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
 4 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 5 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 6 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-06 21:35:54 --> Undefined variable: sub_trip
in ROOTPATH/modules/Report/Controllers/Report.php on line 277.
 1 ROOTPATH/modules/Report/Controllers/Report.php(277): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Undefined variable: sub_trip', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Report/Controllers/Report.php', 277, [...])
 2 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleData()
 3 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
 4 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 5 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 6 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-06 21:36:05 --> Array to string conversion
in SYSTEMPATH/Database/Query.php on line 329.
 1 [internal function]: CodeIgniter\Debug\Exceptions->errorHandler(8, 'Array to string conversion', '/home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/Query.php', 329, [...])
 2 SYSTEMPATH/Database/Query.php(329): implode(',', [...])
 3 SYSTEMPATH/Database/Query.php(310): CodeIgniter\Database\Query->matchNamedBinds('SELECT `tickets`.`created_at` as `date`, `tickets`.*, `trips`.`company_id`, `trips`.`id` as `tripid`, `trips`.*, `subtrips`.`id` as `subtripid`, `subtrips`.*, `schedules`.*, `a`.`name` as `pickup_location_name`, `b`.`name` as `drop_location_name`, `c`.`name` as `sub_pickup_location_name`, `d`.`name` as `sub_drop_location_name`, `e`.`name` AS `company_name`, `g`.`first_name` AS `booked_by_f_name`, `g`.`last_name` AS `booked_by_l_name`, `h`.`first_name` AS `agent_fname`, `h`.`last_name` As `agent_lname`
FROM `tickets`
JOIN `trips` ON `trips`.`id` = `tickets`.`trip_id`
JOIN `subtrips` ON `subtrips`.`id` = `tickets`.`subtrip_id`
JOIN `schedules` ON `schedules`.`id` = `trips`.`schedule_id`
LEFT JOIN `locations` `a` ON `a`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` `b` ON `b`.`id` = `trips`.`drop_location_id`
LEFT JOIN `locations` `c` ON `c`.`id` = `subtrips`.`pick_location_id`
LEFT JOIN `locations` `d` ON `d`.`id` = `subtrips`.`drop_location_id`
JOIN `companies` `e` ON `e`.`id` = `trips`.`company_id`
LEFT JOIN `users` `f` ON `f`.`id` = `tickets`.`bookby_user_id`
LEFT JOIN `user_details` `g` ON `g`.`user_id` = `f`.`id`
LEFT JOIN `agents` `h` ON `h`.`user_id` = `f`.`id`
WHERE `trips`.`status` = :trips.status:
AND `subtrips`.`status` = :subtrips.status:
AND `e`.`status` = :e.status:
AND `tickets`.`refund` = :tickets.refund:
AND `tickets`.`cancel_status` = :tickets.cancel_status:
AND `tickets`.`trip_id` IN :tickets.trip_id:
AND `tickets`.`subtrip_id` IN :tickets.subtrip_id:
AND DATE(tickets.created_at) >= :DATE(tickets.created_at):
AND DATE(tickets.created_at) <= :DATE(tickets.created_at).1:
AND `tickets`.`deleted_at` IS NULL', [...])
 4 SYSTEMPATH/Database/Query.php(159): CodeIgniter\Database\Query->compileBinds()
 5 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\Query->getQuery()
 6 SYSTEMPATH/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `tickets`.`created_at` as `date`, `tickets`.*, `trips`.`company_id`, `trips`.`id` as `tripid`, `trips`.*, `subtrips`.`id` as `subtripid`, `subtrips`.*, `schedules`.*, `a`.`name` as `pickup_location_name`, `b`.`name` as `drop_location_name`, `c`.`name` as `sub_pickup_location_name`, `d`.`name` as `sub_drop_location_name`, `e`.`name` AS `company_name`, `g`.`first_name` AS `booked_by_f_name`, `g`.`last_name` AS `booked_by_l_name`, `h`.`first_name` AS `agent_fname`, `h`.`last_name` As `agent_lname`
FROM `tickets`
JOIN `trips` ON `trips`.`id` = `tickets`.`trip_id`
JOIN `subtrips` ON `subtrips`.`id` = `tickets`.`subtrip_id`
JOIN `schedules` ON `schedules`.`id` = `trips`.`schedule_id`
LEFT JOIN `locations` `a` ON `a`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` `b` ON `b`.`id` = `trips`.`drop_location_id`
LEFT JOIN `locations` `c` ON `c`.`id` = `subtrips`.`pick_location_id`
LEFT JOIN `locations` `d` ON `d`.`id` = `subtrips`.`drop_location_id`
JOIN `companies` `e` ON `e`.`id` = `trips`.`company_id`
LEFT JOIN `users` `f` ON `f`.`id` = `tickets`.`bookby_user_id`
LEFT JOIN `user_details` `g` ON `g`.`user_id` = `f`.`id`
LEFT JOIN `agents` `h` ON `h`.`user_id` = `f`.`id`
WHERE `trips`.`status` = :trips.status:
AND `subtrips`.`status` = :subtrips.status:
AND `e`.`status` = :e.status:
AND `tickets`.`refund` = :tickets.refund:
AND `tickets`.`cancel_status` = :tickets.cancel_status:
AND `tickets`.`trip_id` IN :tickets.trip_id:
AND `tickets`.`subtrip_id` IN :tickets.subtrip_id:
AND DATE(tickets.created_at) >= :DATE(tickets.created_at):
AND DATE(tickets.created_at) <= :DATE(tickets.created_at).1:
AND `tickets`.`deleted_at` IS NULL', [...], false)
 7 SYSTEMPATH/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
 8 SYSTEMPATH/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
 9 ROOTPATH/modules/Report/Controllers/Report.php(288): CodeIgniter\BaseModel->findAll()
10 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleData()
11 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
12 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
13 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
14 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-06 21:36:34 --> Array to string conversion
in SYSTEMPATH/Database/Query.php on line 329.
 1 [internal function]: CodeIgniter\Debug\Exceptions->errorHandler(8, 'Array to string conversion', '/home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/Query.php', 329, [...])
 2 SYSTEMPATH/Database/Query.php(329): implode(',', [...])
 3 SYSTEMPATH/Database/Query.php(310): CodeIgniter\Database\Query->matchNamedBinds('SELECT `tickets`.`created_at` as `date`, `tickets`.*, `trips`.`company_id`, `trips`.`id` as `tripid`, `trips`.*, `subtrips`.`id` as `subtripid`, `subtrips`.*, `schedules`.*, `a`.`name` as `pickup_location_name`, `b`.`name` as `drop_location_name`, `c`.`name` as `sub_pickup_location_name`, `d`.`name` as `sub_drop_location_name`, `e`.`name` AS `company_name`, `g`.`first_name` AS `booked_by_f_name`, `g`.`last_name` AS `booked_by_l_name`, `h`.`first_name` AS `agent_fname`, `h`.`last_name` As `agent_lname`
FROM `tickets`
JOIN `trips` ON `trips`.`id` = `tickets`.`trip_id`
JOIN `subtrips` ON `subtrips`.`id` = `tickets`.`subtrip_id`
JOIN `schedules` ON `schedules`.`id` = `trips`.`schedule_id`
LEFT JOIN `locations` `a` ON `a`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` `b` ON `b`.`id` = `trips`.`drop_location_id`
LEFT JOIN `locations` `c` ON `c`.`id` = `subtrips`.`pick_location_id`
LEFT JOIN `locations` `d` ON `d`.`id` = `subtrips`.`drop_location_id`
JOIN `companies` `e` ON `e`.`id` = `trips`.`company_id`
LEFT JOIN `users` `f` ON `f`.`id` = `tickets`.`bookby_user_id`
LEFT JOIN `user_details` `g` ON `g`.`user_id` = `f`.`id`
LEFT JOIN `agents` `h` ON `h`.`user_id` = `f`.`id`
WHERE `trips`.`status` = :trips.status:
AND `subtrips`.`status` = :subtrips.status:
AND `e`.`status` = :e.status:
AND `tickets`.`refund` = :tickets.refund:
AND `tickets`.`cancel_status` = :tickets.cancel_status:
AND `tickets`.`trip_id` IN :tickets.trip_id:
AND `tickets`.`subtrip_id` IN :tickets.subtrip_id:
AND DATE(tickets.created_at) >= :DATE(tickets.created_at):
AND DATE(tickets.created_at) <= :DATE(tickets.created_at).1:
AND `tickets`.`deleted_at` IS NULL', [...])
 4 SYSTEMPATH/Database/Query.php(159): CodeIgniter\Database\Query->compileBinds()
 5 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\Query->getQuery()
 6 SYSTEMPATH/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `tickets`.`created_at` as `date`, `tickets`.*, `trips`.`company_id`, `trips`.`id` as `tripid`, `trips`.*, `subtrips`.`id` as `subtripid`, `subtrips`.*, `schedules`.*, `a`.`name` as `pickup_location_name`, `b`.`name` as `drop_location_name`, `c`.`name` as `sub_pickup_location_name`, `d`.`name` as `sub_drop_location_name`, `e`.`name` AS `company_name`, `g`.`first_name` AS `booked_by_f_name`, `g`.`last_name` AS `booked_by_l_name`, `h`.`first_name` AS `agent_fname`, `h`.`last_name` As `agent_lname`
FROM `tickets`
JOIN `trips` ON `trips`.`id` = `tickets`.`trip_id`
JOIN `subtrips` ON `subtrips`.`id` = `tickets`.`subtrip_id`
JOIN `schedules` ON `schedules`.`id` = `trips`.`schedule_id`
LEFT JOIN `locations` `a` ON `a`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` `b` ON `b`.`id` = `trips`.`drop_location_id`
LEFT JOIN `locations` `c` ON `c`.`id` = `subtrips`.`pick_location_id`
LEFT JOIN `locations` `d` ON `d`.`id` = `subtrips`.`drop_location_id`
JOIN `companies` `e` ON `e`.`id` = `trips`.`company_id`
LEFT JOIN `users` `f` ON `f`.`id` = `tickets`.`bookby_user_id`
LEFT JOIN `user_details` `g` ON `g`.`user_id` = `f`.`id`
LEFT JOIN `agents` `h` ON `h`.`user_id` = `f`.`id`
WHERE `trips`.`status` = :trips.status:
AND `subtrips`.`status` = :subtrips.status:
AND `e`.`status` = :e.status:
AND `tickets`.`refund` = :tickets.refund:
AND `tickets`.`cancel_status` = :tickets.cancel_status:
AND `tickets`.`trip_id` IN :tickets.trip_id:
AND `tickets`.`subtrip_id` IN :tickets.subtrip_id:
AND DATE(tickets.created_at) >= :DATE(tickets.created_at):
AND DATE(tickets.created_at) <= :DATE(tickets.created_at).1:
AND `tickets`.`deleted_at` IS NULL', [...], false)
 7 SYSTEMPATH/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
 8 SYSTEMPATH/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
 9 ROOTPATH/modules/Report/Controllers/Report.php(288): CodeIgniter\BaseModel->findAll()
10 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleData()
11 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
12 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
13 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
14 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-06 21:36:46 --> Array to string conversion
in SYSTEMPATH/Database/Query.php on line 329.
 1 [internal function]: CodeIgniter\Debug\Exceptions->errorHandler(8, 'Array to string conversion', '/home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/Query.php', 329, [...])
 2 SYSTEMPATH/Database/Query.php(329): implode(',', [...])
 3 SYSTEMPATH/Database/Query.php(310): CodeIgniter\Database\Query->matchNamedBinds('SELECT `tickets`.`created_at` as `date`, `tickets`.*, `trips`.`company_id`, `trips`.`id` as `tripid`, `trips`.*, `subtrips`.`id` as `subtripid`, `subtrips`.*, `schedules`.*, `a`.`name` as `pickup_location_name`, `b`.`name` as `drop_location_name`, `c`.`name` as `sub_pickup_location_name`, `d`.`name` as `sub_drop_location_name`, `e`.`name` AS `company_name`, `g`.`first_name` AS `booked_by_f_name`, `g`.`last_name` AS `booked_by_l_name`, `h`.`first_name` AS `agent_fname`, `h`.`last_name` As `agent_lname`
FROM `tickets`
JOIN `trips` ON `trips`.`id` = `tickets`.`trip_id`
JOIN `subtrips` ON `subtrips`.`id` = `tickets`.`subtrip_id`
JOIN `schedules` ON `schedules`.`id` = `trips`.`schedule_id`
LEFT JOIN `locations` `a` ON `a`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` `b` ON `b`.`id` = `trips`.`drop_location_id`
LEFT JOIN `locations` `c` ON `c`.`id` = `subtrips`.`pick_location_id`
LEFT JOIN `locations` `d` ON `d`.`id` = `subtrips`.`drop_location_id`
JOIN `companies` `e` ON `e`.`id` = `trips`.`company_id`
LEFT JOIN `users` `f` ON `f`.`id` = `tickets`.`bookby_user_id`
LEFT JOIN `user_details` `g` ON `g`.`user_id` = `f`.`id`
LEFT JOIN `agents` `h` ON `h`.`user_id` = `f`.`id`
WHERE `trips`.`status` = :trips.status:
AND `subtrips`.`status` = :subtrips.status:
AND `e`.`status` = :e.status:
AND `tickets`.`refund` = :tickets.refund:
AND `tickets`.`cancel_status` = :tickets.cancel_status:
AND `tickets`.`subtrip_id` IN :tickets.subtrip_id:
AND DATE(tickets.created_at) >= :DATE(tickets.created_at):
AND DATE(tickets.created_at) <= :DATE(tickets.created_at).1:
AND `tickets`.`deleted_at` IS NULL', [...])
 4 SYSTEMPATH/Database/Query.php(159): CodeIgniter\Database\Query->compileBinds()
 5 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\Query->getQuery()
 6 SYSTEMPATH/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `tickets`.`created_at` as `date`, `tickets`.*, `trips`.`company_id`, `trips`.`id` as `tripid`, `trips`.*, `subtrips`.`id` as `subtripid`, `subtrips`.*, `schedules`.*, `a`.`name` as `pickup_location_name`, `b`.`name` as `drop_location_name`, `c`.`name` as `sub_pickup_location_name`, `d`.`name` as `sub_drop_location_name`, `e`.`name` AS `company_name`, `g`.`first_name` AS `booked_by_f_name`, `g`.`last_name` AS `booked_by_l_name`, `h`.`first_name` AS `agent_fname`, `h`.`last_name` As `agent_lname`
FROM `tickets`
JOIN `trips` ON `trips`.`id` = `tickets`.`trip_id`
JOIN `subtrips` ON `subtrips`.`id` = `tickets`.`subtrip_id`
JOIN `schedules` ON `schedules`.`id` = `trips`.`schedule_id`
LEFT JOIN `locations` `a` ON `a`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` `b` ON `b`.`id` = `trips`.`drop_location_id`
LEFT JOIN `locations` `c` ON `c`.`id` = `subtrips`.`pick_location_id`
LEFT JOIN `locations` `d` ON `d`.`id` = `subtrips`.`drop_location_id`
JOIN `companies` `e` ON `e`.`id` = `trips`.`company_id`
LEFT JOIN `users` `f` ON `f`.`id` = `tickets`.`bookby_user_id`
LEFT JOIN `user_details` `g` ON `g`.`user_id` = `f`.`id`
LEFT JOIN `agents` `h` ON `h`.`user_id` = `f`.`id`
WHERE `trips`.`status` = :trips.status:
AND `subtrips`.`status` = :subtrips.status:
AND `e`.`status` = :e.status:
AND `tickets`.`refund` = :tickets.refund:
AND `tickets`.`cancel_status` = :tickets.cancel_status:
AND `tickets`.`subtrip_id` IN :tickets.subtrip_id:
AND DATE(tickets.created_at) >= :DATE(tickets.created_at):
AND DATE(tickets.created_at) <= :DATE(tickets.created_at).1:
AND `tickets`.`deleted_at` IS NULL', [...], false)
 7 SYSTEMPATH/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
 8 SYSTEMPATH/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
 9 ROOTPATH/modules/Report/Controllers/Report.php(288): CodeIgniter\BaseModel->findAll()
10 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleData()
11 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
12 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
13 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
14 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
ERROR - 2025-06-06 21:41:41 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-06 21:41:41 --> 
CRITICAL - 2025-06-06 21:43:13 --> Array to string conversion
in SYSTEMPATH/Database/Query.php on line 329.
 1 [internal function]: CodeIgniter\Debug\Exceptions->errorHandler(8, 'Array to string conversion', '/home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/Query.php', 329, [...])
 2 SYSTEMPATH/Database/Query.php(329): implode(',', [...])
 3 SYSTEMPATH/Database/Query.php(310): CodeIgniter\Database\Query->matchNamedBinds('SELECT `tickets`.`created_at` as `date`, `tickets`.*, `trips`.`company_id`, `trips`.`id` as `tripid`, `trips`.*, `subtrips`.`id` as `subtripid`, `subtrips`.*, `schedules`.*, `a`.`name` as `pickup_location_name`, `b`.`name` as `drop_location_name`, `c`.`name` as `sub_pickup_location_name`, `d`.`name` as `sub_drop_location_name`, `e`.`name` AS `company_name`, `g`.`first_name` AS `booked_by_f_name`, `g`.`last_name` AS `booked_by_l_name`, `h`.`first_name` AS `agent_fname`, `h`.`last_name` As `agent_lname`
FROM `tickets`
JOIN `trips` ON `trips`.`id` = `tickets`.`trip_id`
JOIN `subtrips` ON `subtrips`.`id` = `tickets`.`subtrip_id`
JOIN `schedules` ON `schedules`.`id` = `trips`.`schedule_id`
LEFT JOIN `locations` `a` ON `a`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` `b` ON `b`.`id` = `trips`.`drop_location_id`
LEFT JOIN `locations` `c` ON `c`.`id` = `subtrips`.`pick_location_id`
LEFT JOIN `locations` `d` ON `d`.`id` = `subtrips`.`drop_location_id`
JOIN `companies` `e` ON `e`.`id` = `trips`.`company_id`
LEFT JOIN `users` `f` ON `f`.`id` = `tickets`.`bookby_user_id`
LEFT JOIN `user_details` `g` ON `g`.`user_id` = `f`.`id`
LEFT JOIN `agents` `h` ON `h`.`user_id` = `f`.`id`
WHERE `trips`.`status` = :trips.status:
AND `subtrips`.`status` = :subtrips.status:
AND `e`.`status` = :e.status:
AND `tickets`.`refund` = :tickets.refund:
AND `tickets`.`cancel_status` = :tickets.cancel_status:
AND `tickets`.`trip_id` IN :tickets.trip_id:
AND `tickets`.`subtrip_id` IN :tickets.subtrip_id:
AND DATE(tickets.created_at) >= :DATE(tickets.created_at):
AND DATE(tickets.created_at) <= :DATE(tickets.created_at).1:
AND `tickets`.`deleted_at` IS NULL', [...])
 4 SYSTEMPATH/Database/Query.php(159): CodeIgniter\Database\Query->compileBinds()
 5 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\Query->getQuery()
 6 SYSTEMPATH/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `tickets`.`created_at` as `date`, `tickets`.*, `trips`.`company_id`, `trips`.`id` as `tripid`, `trips`.*, `subtrips`.`id` as `subtripid`, `subtrips`.*, `schedules`.*, `a`.`name` as `pickup_location_name`, `b`.`name` as `drop_location_name`, `c`.`name` as `sub_pickup_location_name`, `d`.`name` as `sub_drop_location_name`, `e`.`name` AS `company_name`, `g`.`first_name` AS `booked_by_f_name`, `g`.`last_name` AS `booked_by_l_name`, `h`.`first_name` AS `agent_fname`, `h`.`last_name` As `agent_lname`
FROM `tickets`
JOIN `trips` ON `trips`.`id` = `tickets`.`trip_id`
JOIN `subtrips` ON `subtrips`.`id` = `tickets`.`subtrip_id`
JOIN `schedules` ON `schedules`.`id` = `trips`.`schedule_id`
LEFT JOIN `locations` `a` ON `a`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` `b` ON `b`.`id` = `trips`.`drop_location_id`
LEFT JOIN `locations` `c` ON `c`.`id` = `subtrips`.`pick_location_id`
LEFT JOIN `locations` `d` ON `d`.`id` = `subtrips`.`drop_location_id`
JOIN `companies` `e` ON `e`.`id` = `trips`.`company_id`
LEFT JOIN `users` `f` ON `f`.`id` = `tickets`.`bookby_user_id`
LEFT JOIN `user_details` `g` ON `g`.`user_id` = `f`.`id`
LEFT JOIN `agents` `h` ON `h`.`user_id` = `f`.`id`
WHERE `trips`.`status` = :trips.status:
AND `subtrips`.`status` = :subtrips.status:
AND `e`.`status` = :e.status:
AND `tickets`.`refund` = :tickets.refund:
AND `tickets`.`cancel_status` = :tickets.cancel_status:
AND `tickets`.`trip_id` IN :tickets.trip_id:
AND `tickets`.`subtrip_id` IN :tickets.subtrip_id:
AND DATE(tickets.created_at) >= :DATE(tickets.created_at):
AND DATE(tickets.created_at) <= :DATE(tickets.created_at).1:
AND `tickets`.`deleted_at` IS NULL', [...], false)
 7 SYSTEMPATH/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
 8 SYSTEMPATH/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
 9 ROOTPATH/modules/Report/Controllers/Report.php(292): CodeIgniter\BaseModel->findAll()
10 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleData()
11 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
12 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
13 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
14 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
