CRITICAL - 2025-05-30 05:19:32 --> Use of undefined constant php - assumed 'php' (this will throw an Error in a future version of PHP)
in ROOTPATH/modules/Ticket/Views/journeylist/print.php on line 100.
 1 ROOTPATH/modules/Ticket/Views/journeylist/print.php(100): CodeIgniter\Debug\Exceptions->errorHandler(2, 'Use of undefined constant php - assumed \'php\' (this will throw an Error in a future version of PHP)', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Views/journeylist/print.php', 100, [...])
 2 SYSTEMPATH/View/View.php(226): include('/home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Views/journeylist/print.php')
 3 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
 4 SYSTEMPATH/Common.php(1174): CodeIgniter\View\View->render('Modules\\Ticket\\Views\\journeylist\\print', [], true)
 5 ROOTPATH/modules/Ticket/Controllers/Journeylist.php(499): view('Modules\\Ticket\\Views\\journeylist\\print', [...])
 6 SYSTEMPATH/CodeIgniter.php(932): Modules\Ticket\Controllers\Journeylist->getJourneylistData('61', '2025-05-29', '1')
 7 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Journeylist))
 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-05-30 05:42:18 --> syntax error, unexpected '{'
in ROOTPATH/modules/Ticket/Controllers/Cancel.php on line 106.
 1 SYSTEMPATH/Autoloader/Autoloader.php(291): CodeIgniter\Autoloader\Autoloader->includeFile('/home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Controllers/Cancel.php')
 2 SYSTEMPATH/Autoloader/Autoloader.php(269): CodeIgniter\Autoloader\Autoloader->loadInNamespace('Modules\\Ticket\\Controllers\\Cancel')
 3 [internal function]: CodeIgniter\Autoloader\Autoloader->loadClass('Modules\\Ticket\\Controllers\\Cancel')
 4 [internal function]: spl_autoload_call('Modules\\Ticket\\Controllers\\Cancel')
 5 SYSTEMPATH/CodeIgniter.php(890): class_exists('\\Modules\\Ticket\\Controllers\\Cancel', 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-05-30 05:45:29 --> syntax error, unexpected '{'
in ROOTPATH/modules/Ticket/Controllers/Cancel.php on line 104.
 1 SYSTEMPATH/Autoloader/Autoloader.php(291): CodeIgniter\Autoloader\Autoloader->includeFile('/home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Controllers/Cancel.php')
 2 SYSTEMPATH/Autoloader/Autoloader.php(269): CodeIgniter\Autoloader\Autoloader->loadInNamespace('Modules\\Ticket\\Controllers\\Cancel')
 3 [internal function]: CodeIgniter\Autoloader\Autoloader->loadClass('Modules\\Ticket\\Controllers\\Cancel')
 4 [internal function]: spl_autoload_call('Modules\\Ticket\\Controllers\\Cancel')
 5 SYSTEMPATH/CodeIgniter.php(890): class_exists('\\Modules\\Ticket\\Controllers\\Cancel', 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-05-30 05:45:48 --> syntax error, unexpected '{'
in ROOTPATH/modules/Ticket/Controllers/Cancel.php on line 103.
 1 SYSTEMPATH/Autoloader/Autoloader.php(291): CodeIgniter\Autoloader\Autoloader->includeFile('/home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Controllers/Cancel.php')
 2 SYSTEMPATH/Autoloader/Autoloader.php(269): CodeIgniter\Autoloader\Autoloader->loadInNamespace('Modules\\Ticket\\Controllers\\Cancel')
 3 [internal function]: CodeIgniter\Autoloader\Autoloader->loadClass('Modules\\Ticket\\Controllers\\Cancel')
 4 [internal function]: spl_autoload_call('Modules\\Ticket\\Controllers\\Cancel')
 5 SYSTEMPATH/CodeIgniter.php(890): class_exists('\\Modules\\Ticket\\Controllers\\Cancel', 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-05-30 05:46:28 --> syntax error, unexpected '{'
in ROOTPATH/modules/Ticket/Controllers/Cancel.php on line 104.
 1 SYSTEMPATH/Autoloader/Autoloader.php(291): CodeIgniter\Autoloader\Autoloader->includeFile('/home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Controllers/Cancel.php')
 2 SYSTEMPATH/Autoloader/Autoloader.php(269): CodeIgniter\Autoloader\Autoloader->loadInNamespace('Modules\\Ticket\\Controllers\\Cancel')
 3 [internal function]: CodeIgniter\Autoloader\Autoloader->loadClass('Modules\\Ticket\\Controllers\\Cancel')
 4 [internal function]: spl_autoload_call('Modules\\Ticket\\Controllers\\Cancel')
 5 SYSTEMPATH/CodeIgniter.php(890): class_exists('\\Modules\\Ticket\\Controllers\\Cancel', 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-05-30 05:47:02 --> Undefined property: Modules\Ticket\Controllers\Cancel::$picdropModel
in ROOTPATH/modules/Ticket/Controllers/Cancel.php on line 104.
 1 ROOTPATH/modules/Ticket/Controllers/Cancel.php(104): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Undefined property: Modules\\Ticket\\Controllers\\Cancel::$picdropModel', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Controllers/Cancel.php', 104, [...])
 2 SYSTEMPATH/CodeIgniter.php(932): Modules\Ticket\Controllers\Cancel->new('5930', 'ticket')
 3 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Cancel))
 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-05-30 05:47:04 --> Undefined property: Modules\Ticket\Controllers\Cancel::$picdropModel
in ROOTPATH/modules/Ticket/Controllers/Cancel.php on line 104.
 1 ROOTPATH/modules/Ticket/Controllers/Cancel.php(104): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Undefined property: Modules\\Ticket\\Controllers\\Cancel::$picdropModel', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Controllers/Cancel.php', 104, [...])
 2 SYSTEMPATH/CodeIgniter.php(932): Modules\Ticket\Controllers\Cancel->new('5930', 'ticket')
 3 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Cancel))
 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-05-30 05:47:06 --> Undefined property: Modules\Ticket\Controllers\Cancel::$picdropModel
in ROOTPATH/modules/Ticket/Controllers/Cancel.php on line 104.
 1 ROOTPATH/modules/Ticket/Controllers/Cancel.php(104): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Undefined property: Modules\\Ticket\\Controllers\\Cancel::$picdropModel', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Controllers/Cancel.php', 104, [...])
 2 SYSTEMPATH/CodeIgniter.php(932): Modules\Ticket\Controllers\Cancel->new('5930', 'ticket')
 3 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Cancel))
 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-05-30 05:55:28 --> syntax error, unexpected '}'
in ROOTPATH/modules/Ticket/Controllers/Cancel.php on line 122.
 1 SYSTEMPATH/Autoloader/Autoloader.php(291): CodeIgniter\Autoloader\Autoloader->includeFile('/home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Controllers/Cancel.php')
 2 SYSTEMPATH/Autoloader/Autoloader.php(269): CodeIgniter\Autoloader\Autoloader->loadInNamespace('Modules\\Ticket\\Controllers\\Cancel')
 3 [internal function]: CodeIgniter\Autoloader\Autoloader->loadClass('Modules\\Ticket\\Controllers\\Cancel')
 4 [internal function]: spl_autoload_call('Modules\\Ticket\\Controllers\\Cancel')
 5 SYSTEMPATH/CodeIgniter.php(890): class_exists('\\Modules\\Ticket\\Controllers\\Cancel', 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-05-30 07:31:04 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 07:31:04 --> 
ERROR - 2025-05-30 07:31:52 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 07:31:52 --> 
ERROR - 2025-05-30 07:33:34 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 07:33:34 --> 
ERROR - 2025-05-30 07:34:22 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 07:34:22 --> 
ERROR - 2025-05-30 07:35:04 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 07:35:04 --> 
ERROR - 2025-05-30 07:36:16 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 07:36:16 --> 
ERROR - 2025-05-30 07:37:05 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 07:37:05 --> 
ERROR - 2025-05-30 07:37:53 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 07:37:53 --> 
ERROR - 2025-05-30 07:39:44 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 07:39:44 --> 
ERROR - 2025-05-30 07:40:25 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 07:40:25 --> 
ERROR - 2025-05-30 07:41:13 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 07:41:13 --> 
ERROR - 2025-05-30 07:41:55 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 07:41:55 --> 
ERROR - 2025-05-30 08:24:25 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 08:24:25 --> 
ERROR - 2025-05-30 08:47:47 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 08:47:47 --> 
CRITICAL - 2025-05-30 10:04:01 --> Undefined variable: ticketType
in ROOTPATH/modules/Report/Views/report/ticketsold.php on line 106.
 1 ROOTPATH/modules/Report/Views/report/ticketsold.php(106): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Undefined variable: ticketType', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Report/Views/report/ticketsold.php', 106, [...])
 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(160): 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-05-30 10:12:00 --> syntax error, unexpected 'echo' (T_ECHO)
in ROOTPATH/modules/Report/Views/report/ticketsold.php on line 136.
 1 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
 2 SYSTEMPATH/Common.php(1174): CodeIgniter\View\View->render('Modules\\Report\\Views\\report/ticketsold', [], true)
 3 ROOTPATH/modules/Report/Controllers/Report.php(162): view('Modules\\Report\\Views\\report/ticketsold', [...])
 4 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleLoad()
 5 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
 6 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 7 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 8 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-05-30 10:12:01 --> syntax error, unexpected 'echo' (T_ECHO)
in ROOTPATH/modules/Report/Views/report/ticketsold.php on line 136.
 1 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
 2 SYSTEMPATH/Common.php(1174): CodeIgniter\View\View->render('Modules\\Report\\Views\\report/ticketsold', [], true)
 3 ROOTPATH/modules/Report/Controllers/Report.php(162): view('Modules\\Report\\Views\\report/ticketsold', [...])
 4 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleLoad()
 5 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
 6 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 7 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 8 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-05-30 10:12:06 --> syntax error, unexpected 'echo' (T_ECHO)
in ROOTPATH/modules/Report/Views/report/ticketsold.php on line 136.
 1 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
 2 SYSTEMPATH/Common.php(1174): CodeIgniter\View\View->render('Modules\\Report\\Views\\report/ticketsold', [], true)
 3 ROOTPATH/modules/Report/Controllers/Report.php(162): view('Modules\\Report\\Views\\report/ticketsold', [...])
 4 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleLoad()
 5 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
 6 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 7 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 8 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-05-30 10:12:08 --> syntax error, unexpected 'echo' (T_ECHO)
in ROOTPATH/modules/Report/Views/report/ticketsold.php on line 136.
 1 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
 2 SYSTEMPATH/Common.php(1174): CodeIgniter\View\View->render('Modules\\Report\\Views\\report/ticketsold', [], true)
 3 ROOTPATH/modules/Report/Controllers/Report.php(162): view('Modules\\Report\\Views\\report/ticketsold', [...])
 4 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleLoad()
 5 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
 6 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 7 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 8 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-05-30 10:12:33 --> syntax error, unexpected 'echo' (T_ECHO)
in ROOTPATH/modules/Report/Views/report/ticketsold.php on line 136.
 1 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
 2 SYSTEMPATH/Common.php(1174): CodeIgniter\View\View->render('Modules\\Report\\Views\\report/ticketsold', [], true)
 3 ROOTPATH/modules/Report/Controllers/Report.php(162): view('Modules\\Report\\Views\\report/ticketsold', [...])
 4 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleLoad()
 5 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
 6 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 7 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 8 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-05-30 10:12:35 --> syntax error, unexpected 'echo' (T_ECHO)
in ROOTPATH/modules/Report/Views/report/ticketsold.php on line 136.
 1 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
 2 SYSTEMPATH/Common.php(1174): CodeIgniter\View\View->render('Modules\\Report\\Views\\report/ticketsold', [], true)
 3 ROOTPATH/modules/Report/Controllers/Report.php(162): view('Modules\\Report\\Views\\report/ticketsold', [...])
 4 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleLoad()
 5 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
 6 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 7 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 8 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-05-30 10:12:37 --> syntax error, unexpected 'echo' (T_ECHO)
in ROOTPATH/modules/Report/Views/report/ticketsold.php on line 136.
 1 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
 2 SYSTEMPATH/Common.php(1174): CodeIgniter\View\View->render('Modules\\Report\\Views\\report/ticketsold', [], true)
 3 ROOTPATH/modules/Report/Controllers/Report.php(162): view('Modules\\Report\\Views\\report/ticketsold', [...])
 4 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleLoad()
 5 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
 6 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 7 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 8 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-05-30 10:12:45 --> syntax error, unexpected 'echo' (T_ECHO)
in ROOTPATH/modules/Report/Views/report/ticketsold.php on line 136.
 1 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
 2 SYSTEMPATH/Common.php(1174): CodeIgniter\View\View->render('Modules\\Report\\Views\\report/ticketsold', [], true)
 3 ROOTPATH/modules/Report/Controllers/Report.php(162): view('Modules\\Report\\Views\\report/ticketsold', [...])
 4 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleLoad()
 5 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
 6 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 7 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 8 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-05-30 10:12:56 --> syntax error, unexpected 'echo' (T_ECHO)
in ROOTPATH/modules/Report/Views/report/ticketsold.php on line 136.
 1 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
 2 SYSTEMPATH/Common.php(1174): CodeIgniter\View\View->render('Modules\\Report\\Views\\report/ticketsold', [], true)
 3 ROOTPATH/modules/Report/Controllers/Report.php(162): view('Modules\\Report\\Views\\report/ticketsold', [...])
 4 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleLoad()
 5 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
 6 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 7 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 8 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
ERROR - 2025-05-30 10:16:46 --> mysqli_sql_exception: MySQL server has gone away in /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:295
Stack trace:
#0 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(295): mysqli->query('SELECT *\nFROM `...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT *\nFROM `...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT *\nFROM `...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT *\nFROM `...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
#6 /home/busvalle/data.busvalley.com/busvalley_new/app/Libraries/Language.php(40): CodeIgniter\BaseModel->findAll()
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/View/Cell.php(279): App\Libraries\Language->getAllLanguage()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/View/Cell.php(103): CodeIgniter\View\Cell->renderSimpleClass(Object(App\Libraries\Language), 'getAllLanguage', Array, 'App\\Libraries\\L...')
#9 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Common.php(1190): CodeIgniter\View\Cell->render('\\App\\Libraries\\...', Array, 0, 'AppLibrariesLan...')
#10 /home/busvalle/data.busvalley.com/busvalley_new/app/Views/template/admin/navbar.php(53): view_cell('\\App\\Libraries\\...')
#11 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/View/View.php(226): include('/home/busvalle/...')
#12 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
#13 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/View/View.php(462): CodeIgniter\View\View->render('template/admin/...', NULL, true)
#14 /home/busvalle/data.busvalley.com/busvalley_new/app/Views/template/admin/main.php(40): CodeIgniter\View\View->include('template/admin/...')
#15 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/View/View.php(226): include('/home/busvalle/...')
#16 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
#17 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/View/View.php(242): CodeIgniter\View\View->render('template/admin/...', Array, true)
#18 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Common.php(1174): CodeIgniter\View\View->render('Modules\\Report\\...', Array, true)
#19 /home/busvalle/data.busvalley.com/busvalley_new/modules/Report/Controllers/Report.php(162): view('Modules\\Report\\...', Array)
#20 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleLoad()
#21 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
#22 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#23 /home/busvalle/data.busvalley.com/busvalley_new/public/index.php(65): CodeIgniter\CodeIgniter->run()
#24 /home/busvalle/data.busvalley.com/busvalley_new/index.php(2): require_once('/home/busvalle/...')
#25 {main}
CRITICAL - 2025-05-30 10:16:46 --> MySQL server has gone away
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT *
FROM `localizes`
WHERE `localizes`.`deleted_at` IS NULL
ORDER BY `id` DESC', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT *
FROM `localizes`
WHERE `localizes`.`deleted_at` IS NULL
ORDER BY `id` DESC')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT *
FROM `localizes`
WHERE `localizes`.`deleted_at` IS NULL
ORDER BY `id` DESC')
 4 SYSTEMPATH/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT *
FROM `localizes`
WHERE `localizes`.`deleted_at` IS NULL
ORDER BY `id` DESC', [], false)
 5 SYSTEMPATH/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
 6 SYSTEMPATH/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
 7 APPPATH/Libraries/Language.php(40): CodeIgniter\BaseModel->findAll()
 8 SYSTEMPATH/View/Cell.php(279): App\Libraries\Language->getAllLanguage()
 9 SYSTEMPATH/View/Cell.php(103): CodeIgniter\View\Cell->renderSimpleClass(Object(App\Libraries\Language), 'getAllLanguage', [], 'App\\Libraries\\Language')
10 SYSTEMPATH/Common.php(1190): CodeIgniter\View\Cell->render('\\App\\Libraries\\Language::getAllLanguage', [], 0, 'AppLibrariesLanguagegetAllLanguage40cd750bba9870f18aada2478b24840a')
11 APPPATH/Views/template/admin/navbar.php(53): view_cell('\\App\\Libraries\\Language::getAllLanguage')
12 SYSTEMPATH/View/View.php(226): include('/home/busvalle/data.busvalley.com/busvalley_new/app/Views/template/admin/navbar.php')
13 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
14 SYSTEMPATH/View/View.php(462): CodeIgniter\View\View->render('template/admin/navbar', null, true)
15 APPPATH/Views/template/admin/main.php(40): CodeIgniter\View\View->include('template/admin/navbar')
16 SYSTEMPATH/View/View.php(226): include('/home/busvalle/data.busvalley.com/busvalley_new/app/Views/template/admin/main.php')
17 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
18 SYSTEMPATH/View/View.php(242): CodeIgniter\View\View->render('template/admin/main', [], true)
19 SYSTEMPATH/Common.php(1174): CodeIgniter\View\View->render('Modules\\Report\\Views\\report/ticketsold', [], true)
20 ROOTPATH/modules/Report/Controllers/Report.php(162): view('Modules\\Report\\Views\\report/ticketsold', [...])
21 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleLoad()
22 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
23 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
24 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
25 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-05-30 10:18:21 --> syntax error, unexpected 'if' (T_IF)
in ROOTPATH/modules/Report/Controllers/Report.php on line 222.
 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-05-30 10:18:23 --> syntax error, unexpected 'if' (T_IF)
in ROOTPATH/modules/Report/Controllers/Report.php on line 222.
 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-05-30 10:18:25 --> syntax error, unexpected 'if' (T_IF)
in ROOTPATH/modules/Report/Controllers/Report.php on line 222.
 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-05-30 10:18:27 --> syntax error, unexpected 'if' (T_IF)
in ROOTPATH/modules/Report/Controllers/Report.php on line 222.
 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-05-30 10:21:19 --> mysqli_sql_exception: Unknown column 'i.created_at' in 'SELECT' in /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:295
Stack trace:
#0 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `tickets...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `tickets...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `tickets...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `tickets...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Report/Controllers/Report.php(270): CodeIgniter\BaseModel->findAll()
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleData()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
#9 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#10 /home/busvalle/data.busvalley.com/busvalley_new/public/index.php(65): CodeIgniter\CodeIgniter->run()
#11 /home/busvalle/data.busvalley.com/busvalley_new/index.php(2): require_once('/home/busvalle/...')
#12 {main}
CRITICAL - 2025-05-30 10:21:19 --> Unknown column 'i.created_at' in 'SELECT'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->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`, `i`.`created_at` AS `refund_date`, `j`.`created_at` AS `cancel_date`
FROM `tickets`
LEFT JOIN `cancels` `j` ON `j`.`booking_id` = `tickets`.`booking_id`
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` = 1
AND `subtrips`.`status` = 1
AND `e`.`status` = 1
AND `tickets`.`cancel_status` = 1
AND DATE(tickets.created_at) >= \'2025-05-01\'
AND DATE(tickets.created_at) <= \'2025-05-30\'
AND `tickets`.`deleted_at` IS NULL', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('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`, `i`.`created_at` AS `refund_date`, `j`.`created_at` AS `cancel_date`
FROM `tickets`
LEFT JOIN `cancels` `j` ON `j`.`booking_id` = `tickets`.`booking_id`
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` = 1
AND `subtrips`.`status` = 1
AND `e`.`status` = 1
AND `tickets`.`cancel_status` = 1
AND DATE(tickets.created_at) >= \'2025-05-01\'
AND DATE(tickets.created_at) <= \'2025-05-30\'
AND `tickets`.`deleted_at` IS NULL')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('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`, `i`.`created_at` AS `refund_date`, `j`.`created_at` AS `cancel_date`
FROM `tickets`
LEFT JOIN `cancels` `j` ON `j`.`booking_id` = `tickets`.`booking_id`
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` = 1
AND `subtrips`.`status` = 1
AND `e`.`status` = 1
AND `tickets`.`cancel_status` = 1
AND DATE(tickets.created_at) >= \'2025-05-01\'
AND DATE(tickets.created_at) <= \'2025-05-30\'
AND `tickets`.`deleted_at` IS NULL')
 4 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`, `i`.`created_at` AS `refund_date`, `j`.`created_at` AS `cancel_date`
FROM `tickets`
LEFT JOIN `cancels` `j` ON `j`.`booking_id` = `tickets`.`booking_id`
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`.`cancel_status` = :tickets.cancel_status:
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)
 5 SYSTEMPATH/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
 6 SYSTEMPATH/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
 7 ROOTPATH/modules/Report/Controllers/Report.php(270): CodeIgniter\BaseModel->findAll()
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleData()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
10 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
11 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
12 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
ERROR - 2025-05-30 10:21:52 --> mysqli_sql_exception: Unknown column 'i.created_at' in 'SELECT' in /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:295
Stack trace:
#0 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `tickets...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `tickets...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `tickets...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `tickets...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Report/Controllers/Report.php(270): CodeIgniter\BaseModel->findAll()
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleData()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
#9 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#10 /home/busvalle/data.busvalley.com/busvalley_new/public/index.php(65): CodeIgniter\CodeIgniter->run()
#11 /home/busvalle/data.busvalley.com/busvalley_new/index.php(2): require_once('/home/busvalle/...')
#12 {main}
CRITICAL - 2025-05-30 10:21:52 --> Unknown column 'i.created_at' in 'SELECT'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->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`, `i`.`created_at` AS `refund_date`, `j`.`created_at` AS `cancel_date`
FROM `tickets`
LEFT JOIN `cancels` `j` ON `j`.`booking_id` = `tickets`.`booking_id`
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` = 1
AND `subtrips`.`status` = 1
AND `e`.`status` = 1
AND `tickets`.`cancel_status` = 1
AND DATE(tickets.created_at) >= \'2025-05-01\'
AND DATE(tickets.created_at) <= \'2025-05-30\'
AND `tickets`.`deleted_at` IS NULL', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('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`, `i`.`created_at` AS `refund_date`, `j`.`created_at` AS `cancel_date`
FROM `tickets`
LEFT JOIN `cancels` `j` ON `j`.`booking_id` = `tickets`.`booking_id`
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` = 1
AND `subtrips`.`status` = 1
AND `e`.`status` = 1
AND `tickets`.`cancel_status` = 1
AND DATE(tickets.created_at) >= \'2025-05-01\'
AND DATE(tickets.created_at) <= \'2025-05-30\'
AND `tickets`.`deleted_at` IS NULL')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('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`, `i`.`created_at` AS `refund_date`, `j`.`created_at` AS `cancel_date`
FROM `tickets`
LEFT JOIN `cancels` `j` ON `j`.`booking_id` = `tickets`.`booking_id`
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` = 1
AND `subtrips`.`status` = 1
AND `e`.`status` = 1
AND `tickets`.`cancel_status` = 1
AND DATE(tickets.created_at) >= \'2025-05-01\'
AND DATE(tickets.created_at) <= \'2025-05-30\'
AND `tickets`.`deleted_at` IS NULL')
 4 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`, `i`.`created_at` AS `refund_date`, `j`.`created_at` AS `cancel_date`
FROM `tickets`
LEFT JOIN `cancels` `j` ON `j`.`booking_id` = `tickets`.`booking_id`
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`.`cancel_status` = :tickets.cancel_status:
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)
 5 SYSTEMPATH/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
 6 SYSTEMPATH/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
 7 ROOTPATH/modules/Report/Controllers/Report.php(270): CodeIgniter\BaseModel->findAll()
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleData()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
10 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
11 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
12 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
ERROR - 2025-05-30 10:22:01 --> mysqli_sql_exception: Unknown column 'i.created_at' in 'SELECT' in /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:295
Stack trace:
#0 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `tickets...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `tickets...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `tickets...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `tickets...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Report/Controllers/Report.php(270): CodeIgniter\BaseModel->findAll()
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleData()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
#9 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#10 /home/busvalle/data.busvalley.com/busvalley_new/public/index.php(65): CodeIgniter\CodeIgniter->run()
#11 /home/busvalle/data.busvalley.com/busvalley_new/index.php(2): require_once('/home/busvalle/...')
#12 {main}
CRITICAL - 2025-05-30 10:22:01 --> Unknown column 'i.created_at' in 'SELECT'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->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`, `i`.`created_at` AS `refund_date`, `j`.`created_at` AS `cancel_date`
FROM `tickets`
LEFT JOIN `cancels` `j` ON `j`.`booking_id` = `tickets`.`booking_id`
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` = 1
AND `subtrips`.`status` = 1
AND `e`.`status` = 1
AND `tickets`.`cancel_status` = 1
AND DATE(tickets.created_at) >= \'2025-05-01\'
AND DATE(tickets.created_at) <= \'2025-05-30\'
AND `tickets`.`deleted_at` IS NULL', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('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`, `i`.`created_at` AS `refund_date`, `j`.`created_at` AS `cancel_date`
FROM `tickets`
LEFT JOIN `cancels` `j` ON `j`.`booking_id` = `tickets`.`booking_id`
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` = 1
AND `subtrips`.`status` = 1
AND `e`.`status` = 1
AND `tickets`.`cancel_status` = 1
AND DATE(tickets.created_at) >= \'2025-05-01\'
AND DATE(tickets.created_at) <= \'2025-05-30\'
AND `tickets`.`deleted_at` IS NULL')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('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`, `i`.`created_at` AS `refund_date`, `j`.`created_at` AS `cancel_date`
FROM `tickets`
LEFT JOIN `cancels` `j` ON `j`.`booking_id` = `tickets`.`booking_id`
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` = 1
AND `subtrips`.`status` = 1
AND `e`.`status` = 1
AND `tickets`.`cancel_status` = 1
AND DATE(tickets.created_at) >= \'2025-05-01\'
AND DATE(tickets.created_at) <= \'2025-05-30\'
AND `tickets`.`deleted_at` IS NULL')
 4 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`, `i`.`created_at` AS `refund_date`, `j`.`created_at` AS `cancel_date`
FROM `tickets`
LEFT JOIN `cancels` `j` ON `j`.`booking_id` = `tickets`.`booking_id`
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`.`cancel_status` = :tickets.cancel_status:
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)
 5 SYSTEMPATH/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
 6 SYSTEMPATH/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
 7 ROOTPATH/modules/Report/Controllers/Report.php(270): CodeIgniter\BaseModel->findAll()
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Report\Controllers\Report->ticketSaleData()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Report\Controllers\Report))
10 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
11 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
12 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-05-30 10:22:26 --> syntax error, unexpected ''b.id = trips.drop_' (T_ENCAPSED_AND_WHITESPACE), expecting ')'
in ROOTPATH/modules/Report/Controllers/Report.php on line 321.
 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-05-30 10:24:55 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 10:24:55 --> 
ERROR - 2025-05-30 12:11:42 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 12:11:42 --> 
ERROR - 2025-05-30 12:35:50 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 12:35:50 --> 
ERROR - 2025-05-30 12:56:49 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 12:56:49 --> 
ERROR - 2025-05-30 12:59:44 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 12:59:44 --> 
ERROR - 2025-05-30 13:02:55 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 13:02:55 --> 
ERROR - 2025-05-30 13:15:43 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 13:15:43 --> 
ERROR - 2025-05-30 13:15:45 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 13:15:45 --> 
ERROR - 2025-05-30 13:31:02 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 13:31:02 --> 
ERROR - 2025-05-30 13:47:57 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 13:47:57 --> 
ERROR - 2025-05-30 14:23:37 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 14:23:37 --> 
ERROR - 2025-05-30 14:32:32 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 14:32:32 --> 
ERROR - 2025-05-30 14:32:57 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 14:32:57 --> 
ERROR - 2025-05-30 14:42:24 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 14:42:24 --> 
ERROR - 2025-05-30 15:04:07 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 15:04:07 --> 
ERROR - 2025-05-30 15:04:07 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 15:04:07 --> 
ERROR - 2025-05-30 15:32:51 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 15:32:51 --> 
ERROR - 2025-05-30 16:04:22 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 16:04:22 --> 
ERROR - 2025-05-30 16:19:29 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 16:19:29 --> 
ERROR - 2025-05-30 16:23:07 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 16:23:07 --> 
ERROR - 2025-05-30 18:12:01 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 18:12:01 --> 
ERROR - 2025-05-30 18:45:48 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 18:45:48 --> 
ERROR - 2025-05-30 19:35:06 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 19:35:06 --> 
ERROR - 2025-05-30 20:01:21 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 20:01:21 --> 
ERROR - 2025-05-30 20:32:37 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 20:32:37 --> 
ERROR - 2025-05-30 21:23:06 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 21:23:06 --> 
CRITICAL - 2025-05-30 21:23:16 --> syntax error, unexpected end of file
in ROOTPATH/modules/Ticket/Controllers/Ticket.php on line 1874.
 1 SYSTEMPATH/Autoloader/Autoloader.php(291): CodeIgniter\Autoloader\Autoloader->includeFile('/home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Controllers/Ticket.php')
 2 SYSTEMPATH/Autoloader/Autoloader.php(269): CodeIgniter\Autoloader\Autoloader->loadInNamespace('Modules\\Ticket\\Controllers\\Ticket')
 3 [internal function]: CodeIgniter\Autoloader\Autoloader->loadClass('Modules\\Ticket\\Controllers\\Ticket')
 4 [internal function]: spl_autoload_call('Modules\\Ticket\\Controllers\\Ticket')
 5 SYSTEMPATH/CodeIgniter.php(890): class_exists('\\Modules\\Ticket\\Controllers\\Ticket', 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-05-30 21:32:49 --> Undefined variable: rolepermissionLibrary
in ROOTPATH/modules/Ticket/Controllers/Ticket.php on line 1293.
 1 ROOTPATH/modules/Ticket/Controllers/Ticket.php(1293): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Undefined variable: rolepermissionLibrary', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Controllers/Ticket.php', 1293, [...])
 2 ROOTPATH/modules/Ticket/Controllers/Ticket.php(1271): Modules\Ticket\Controllers\Ticket->filterBooking()
 3 SYSTEMPATH/CodeIgniter.php(932): Modules\Ticket\Controllers\Ticket->allbookinglist()
 4 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Ticket))
 5 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 6 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 7 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
ERROR - 2025-05-30 22:34:19 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 22:34:19 --> 
ERROR - 2025-05-30 22:43:17 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 22:43:17 --> 
ERROR - 2025-05-30 23:34:30 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-05-30 23:34:30 --> 
