-- https://www.phpmyadmin.net/
--


--
-- Database: `LBS_db`
--

-- --------------------------------------------------------

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--

INSERT INTO `failed_jobs` (`id`, `connection`, `queue`, `payload`, `exception`, `failed_at`) VALUES
(24, 'database', 'default', '{\"displayName\":\"App\\\\Jobs\\\\SearchLocation\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"delay\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SearchLocation\",\"command\":\"O:23:\\\"App\\\\Jobs\\\\SearchLocation\\\":11:{s:6:\\\"\\u0000*\\u0000lat\\\";N;s:7:\\\"\\u0000*\\u0000long\\\";N;s:8:\\\"\\u0000*\\u0000token\\\";N;s:6:\\\"\\u0000*\\u0000job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 'Illuminate\\Queue\\MaxAttemptsExceededException: App\\Jobs\\SearchLocation has been attempted too many times or run too long. The job may have previously timed out. in /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php:632\nStack trace:\n#0 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(446): Illuminate\\Queue\\Worker->maxAttemptsExceededException(Object(Illuminate\\Queue\\Jobs\\DatabaseJob))\n#1 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(358): Illuminate\\Queue\\Worker->markJobAsFailedIfAlreadyExceedsMaxAttempts(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), 1)\n#2 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(314): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#3 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(267): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#4 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(112): Illuminate\\Queue\\Worker->runNextJob(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#5 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(96): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#6 [internal function]: Illuminate\\Queue\\Console\\WorkCommand->handle()\n#7 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(32): call_user_func_array(Array, Array)\n#8 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#9 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))\n#10 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/Container.php(591): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)\n#11 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(134): Illuminate\\Container\\Container->call(Array)\n#12 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Command/Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#13 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#14 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(1001): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#15 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(271): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#16 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(147): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#17 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#18 /Users/itexecutive/Documents/projects/LBS/vendor/laravel/lumen-framework/src/Console/Kernel.php(115): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#19 /Users/itexecutive/Documents/projects/LBS/artisan(35): Laravel\\Lumen\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#20 {main}', '2020-06-03 20:31:16'),
(25, 'database', 'default', '{\"displayName\":\"App\\\\Jobs\\\\SearchLocation\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"delay\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SearchLocation\",\"command\":\"O:23:\\\"App\\\\Jobs\\\\SearchLocation\\\":11:{s:6:\\\"\\u0000*\\u0000lat\\\";N;s:7:\\\"\\u0000*\\u0000long\\\";N;s:8:\\\"\\u0000*\\u0000token\\\";N;s:6:\\\"\\u0000*\\u0000job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 'Illuminate\\Queue\\MaxAttemptsExceededException: App\\Jobs\\SearchLocation has been attempted too many times or run too long. The job may have previously timed out. in /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php:632\nStack trace:\n#0 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(446): Illuminate\\Queue\\Worker->maxAttemptsExceededException(Object(Illuminate\\Queue\\Jobs\\DatabaseJob))\n#1 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(358): Illuminate\\Queue\\Worker->markJobAsFailedIfAlreadyExceedsMaxAttempts(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), 1)\n#2 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(314): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#3 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(267): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#4 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(112): Illuminate\\Queue\\Worker->runNextJob(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#5 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(96): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#6 [internal function]: Illuminate\\Queue\\Console\\WorkCommand->handle()\n#7 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(32): call_user_func_array(Array, Array)\n#8 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#9 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))\n#10 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/Container.php(591): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)\n#11 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(134): Illuminate\\Container\\Container->call(Array)\n#12 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Command/Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#13 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#14 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(1001): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#15 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(271): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#16 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(147): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#17 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#18 /Users/itexecutive/Documents/projects/LBS/vendor/laravel/lumen-framework/src/Console/Kernel.php(115): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#19 /Users/itexecutive/Documents/projects/LBS/artisan(35): Laravel\\Lumen\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#20 {main}', '2020-06-03 20:31:58'),
(26, 'database', 'default', '{\"displayName\":\"App\\\\Jobs\\\\SearchLocation\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"delay\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SearchLocation\",\"command\":\"O:23:\\\"App\\\\Jobs\\\\SearchLocation\\\":11:{s:6:\\\"\\u0000*\\u0000lat\\\";N;s:7:\\\"\\u0000*\\u0000long\\\";N;s:8:\\\"\\u0000*\\u0000token\\\";N;s:6:\\\"\\u0000*\\u0000job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 'ErrorException: Trying to get property \'program_id\' of non-object in /Users/itexecutive/Documents/projects/LBS/app/Jobs/SearchLocation.php:39\nStack trace:\n#0 /Users/itexecutive/Documents/projects/LBS/app/Jobs/SearchLocation.php(39): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(8, \'Trying to get p...\', \'/Users/itexecut...\', 39, Array)\n#1 [internal function]: App\\Jobs\\SearchLocation->handle()\n#2 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(32): call_user_func_array(Array, Array)\n#3 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#4 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))\n#5 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/Container.php(591): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)\n#6 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/bus/Dispatcher.php(94): Illuminate\\Container\\Container->call(Array)\n#7 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/pipeline/Pipeline.php(130): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}(Object(App\\Jobs\\SearchLocation))\n#8 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\SearchLocation))\n#9 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/bus/Dispatcher.php(98): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#10 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/CallQueuedHandler.php(83): Illuminate\\Bus\\Dispatcher->dispatchNow(Object(App\\Jobs\\SearchLocation), false)\n#11 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/pipeline/Pipeline.php(130): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}(Object(App\\Jobs\\SearchLocation))\n#12 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\SearchLocation))\n#13 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/CallQueuedHandler.php(85): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#14 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/CallQueuedHandler.php(59): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(App\\Jobs\\SearchLocation))\n#15 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Jobs/Job.php(88): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#16 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(368): Illuminate\\Queue\\Jobs\\Job->fire()\n#17 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(314): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#18 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(267): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#19 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(112): Illuminate\\Queue\\Worker->runNextJob(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#20 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(96): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#21 [internal function]: Illuminate\\Queue\\Console\\WorkCommand->handle()\n#22 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(32): call_user_func_array(Array, Array)\n#23 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#24 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))\n#25 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/Container.php(591): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)\n#26 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(134): Illuminate\\Container\\Container->call(Array)\n#27 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Command/Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#28 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#29 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(1001): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#30 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(271): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#31 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(147): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#32 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#33 /Users/itexecutive/Documents/projects/LBS/vendor/laravel/lumen-framework/src/Console/Kernel.php(115): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#34 /Users/itexecutive/Documents/projects/LBS/artisan(35): Laravel\\Lumen\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#35 {main}', '2020-06-03 21:44:05'),
(27, 'database', 'default', '{\"displayName\":\"App\\\\Jobs\\\\SearchLocation\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"delay\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SearchLocation\",\"command\":\"O:23:\\\"App\\\\Jobs\\\\SearchLocation\\\":11:{s:6:\\\"\\u0000*\\u0000lat\\\";N;s:7:\\\"\\u0000*\\u0000long\\\";N;s:8:\\\"\\u0000*\\u0000token\\\";N;s:6:\\\"\\u0000*\\u0000job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 'ErrorException: Trying to get property \'program_id\' of non-object in /Users/itexecutive/Documents/projects/LBS/app/Jobs/SearchLocation.php:39\nStack trace:\n#0 /Users/itexecutive/Documents/projects/LBS/app/Jobs/SearchLocation.php(39): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(8, \'Trying to get p...\', \'/Users/itexecut...\', 39, Array)\n#1 [internal function]: App\\Jobs\\SearchLocation->handle()\n#2 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(32): call_user_func_array(Array, Array)\n#3 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#4 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))\n#5 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/Container.php(591): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)\n#6 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/bus/Dispatcher.php(94): Illuminate\\Container\\Container->call(Array)\n#7 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/pipeline/Pipeline.php(130): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}(Object(App\\Jobs\\SearchLocation))\n#8 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\SearchLocation))\n#9 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/bus/Dispatcher.php(98): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#10 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/CallQueuedHandler.php(83): Illuminate\\Bus\\Dispatcher->dispatchNow(Object(App\\Jobs\\SearchLocation), false)\n#11 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/pipeline/Pipeline.php(130): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}(Object(App\\Jobs\\SearchLocation))\n#12 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\SearchLocation))\n#13 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/CallQueuedHandler.php(85): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#14 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/CallQueuedHandler.php(59): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(App\\Jobs\\SearchLocation))\n#15 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Jobs/Job.php(88): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#16 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(368): Illuminate\\Queue\\Jobs\\Job->fire()\n#17 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(314): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#18 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(267): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#19 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(112): Illuminate\\Queue\\Worker->runNextJob(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#20 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(96): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#21 [internal function]: Illuminate\\Queue\\Console\\WorkCommand->handle()\n#22 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(32): call_user_func_array(Array, Array)\n#23 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#24 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))\n#25 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/Container.php(591): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)\n#26 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(134): Illuminate\\Container\\Container->call(Array)\n#27 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Command/Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#28 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#29 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(1001): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#30 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(271): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#31 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(147): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#32 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#33 /Users/itexecutive/Documents/projects/LBS/vendor/laravel/lumen-framework/src/Console/Kernel.php(115): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#34 /Users/itexecutive/Documents/projects/LBS/artisan(35): Laravel\\Lumen\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#35 {main}', '2020-06-03 21:44:05'),
(28, 'database', 'default', '{\"displayName\":\"App\\\\Jobs\\\\SearchLocation\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"delay\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SearchLocation\",\"command\":\"O:23:\\\"App\\\\Jobs\\\\SearchLocation\\\":11:{s:6:\\\"\\u0000*\\u0000lat\\\";N;s:7:\\\"\\u0000*\\u0000long\\\";N;s:8:\\\"\\u0000*\\u0000token\\\";N;s:6:\\\"\\u0000*\\u0000job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 'ErrorException: Trying to get property \'program_id\' of non-object in /Users/itexecutive/Documents/projects/LBS/app/Jobs/SearchLocation.php:39\nStack trace:\n#0 /Users/itexecutive/Documents/projects/LBS/app/Jobs/SearchLocation.php(39): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(8, \'Trying to get p...\', \'/Users/itexecut...\', 39, Array)\n#1 [internal function]: App\\Jobs\\SearchLocation->handle()\n#2 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(32): call_user_func_array(Array, Array)\n#3 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#4 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))\n#5 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/Container.php(591): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)\n#6 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/bus/Dispatcher.php(94): Illuminate\\Container\\Container->call(Array)\n#7 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/pipeline/Pipeline.php(130): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}(Object(App\\Jobs\\SearchLocation))\n#8 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\SearchLocation))\n#9 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/bus/Dispatcher.php(98): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#10 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/CallQueuedHandler.php(83): Illuminate\\Bus\\Dispatcher->dispatchNow(Object(App\\Jobs\\SearchLocation), false)\n#11 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/pipeline/Pipeline.php(130): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}(Object(App\\Jobs\\SearchLocation))\n#12 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\SearchLocation))\n#13 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/CallQueuedHandler.php(85): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#14 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/CallQueuedHandler.php(59): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(App\\Jobs\\SearchLocation))\n#15 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Jobs/Job.php(88): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#16 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(368): Illuminate\\Queue\\Jobs\\Job->fire()\n#17 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(314): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#18 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(267): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#19 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(112): Illuminate\\Queue\\Worker->runNextJob(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#20 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(96): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#21 [internal function]: Illuminate\\Queue\\Console\\WorkCommand->handle()\n#22 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(32): call_user_func_array(Array, Array)\n#23 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#24 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))\n#25 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/Container.php(591): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)\n#26 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(134): Illuminate\\Container\\Container->call(Array)\n#27 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Command/Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#28 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#29 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(1001): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#30 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(271): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#31 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(147): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#32 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#33 /Users/itexecutive/Documents/projects/LBS/vendor/laravel/lumen-framework/src/Console/Kernel.php(115): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#34 /Users/itexecutive/Documents/projects/LBS/artisan(35): Laravel\\Lumen\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#35 {main}', '2020-06-03 21:44:06'),
(29, 'database', 'default', '{\"displayName\":\"App\\\\Jobs\\\\SearchLocation\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"delay\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SearchLocation\",\"command\":\"O:23:\\\"App\\\\Jobs\\\\SearchLocation\\\":11:{s:6:\\\"\\u0000*\\u0000lat\\\";N;s:7:\\\"\\u0000*\\u0000long\\\";N;s:8:\\\"\\u0000*\\u0000token\\\";N;s:6:\\\"\\u0000*\\u0000job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 'ErrorException: json_decode() expects parameter 1 to be string, array given in /Users/itexecutive/Documents/projects/LBS/app/Jobs/SearchLocation.php:165\nStack trace:\n#0 [internal function]: Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(2, \'json_decode() e...\', \'/Users/itexecut...\', 165, Array)\n#1 /Users/itexecutive/Documents/projects/LBS/app/Jobs/SearchLocation.php(165): json_decode(Array)\n#2 /Users/itexecutive/Documents/projects/LBS/app/Jobs/SearchLocation.php(60): App\\Jobs\\SearchLocation->next_priority(Array)\n#3 [internal function]: App\\Jobs\\SearchLocation->handle()\n#4 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(32): call_user_func_array(Array, Array)\n#5 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#6 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))\n#7 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/Container.php(591): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)\n#8 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/bus/Dispatcher.php(94): Illuminate\\Container\\Container->call(Array)\n#9 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/pipeline/Pipeline.php(130): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}(Object(App\\Jobs\\SearchLocation))\n#10 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\SearchLocation))\n#11 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/bus/Dispatcher.php(98): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#12 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/CallQueuedHandler.php(83): Illuminate\\Bus\\Dispatcher->dispatchNow(Object(App\\Jobs\\SearchLocation), false)\n#13 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/pipeline/Pipeline.php(130): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}(Object(App\\Jobs\\SearchLocation))\n#14 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\SearchLocation))\n#15 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/CallQueuedHandler.php(85): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#16 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/CallQueuedHandler.php(59): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(App\\Jobs\\SearchLocation))\n#17 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Jobs/Job.php(88): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#18 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(368): Illuminate\\Queue\\Jobs\\Job->fire()\n#19 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(314): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#20 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(267): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#21 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(112): Illuminate\\Queue\\Worker->runNextJob(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#22 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(96): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#23 [internal function]: Illuminate\\Queue\\Console\\WorkCommand->handle()\n#24 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(32): call_user_func_array(Array, Array)\n#25 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#26 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))\n#27 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/Container.php(591): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)\n#28 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(134): Illuminate\\Container\\Container->call(Array)\n#29 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Command/Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#30 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#31 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(1001): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#32 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(271): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#33 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(147): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#34 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#35 /Users/itexecutive/Documents/projects/LBS/vendor/laravel/lumen-framework/src/Console/Kernel.php(115): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#36 /Users/itexecutive/Documents/projects/LBS/artisan(35): Laravel\\Lumen\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#37 {main}', '2020-06-03 21:45:54'),
(30, 'database', 'default', '{\"displayName\":\"App\\\\Jobs\\\\SearchLocation\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"delay\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SearchLocation\",\"command\":\"O:23:\\\"App\\\\Jobs\\\\SearchLocation\\\":11:{s:6:\\\"\\u0000*\\u0000lat\\\";N;s:7:\\\"\\u0000*\\u0000long\\\";N;s:8:\\\"\\u0000*\\u0000token\\\";N;s:6:\\\"\\u0000*\\u0000job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 'Illuminate\\Queue\\MaxAttemptsExceededException: App\\Jobs\\SearchLocation has been attempted too many times or run too long. The job may have previously timed out. in /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php:632\nStack trace:\n#0 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(446): Illuminate\\Queue\\Worker->maxAttemptsExceededException(Object(Illuminate\\Queue\\Jobs\\DatabaseJob))\n#1 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(358): Illuminate\\Queue\\Worker->markJobAsFailedIfAlreadyExceedsMaxAttempts(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), 1)\n#2 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(314): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#3 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(267): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#4 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(112): Illuminate\\Queue\\Worker->runNextJob(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#5 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(96): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#6 [internal function]: Illuminate\\Queue\\Console\\WorkCommand->handle()\n#7 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(32): call_user_func_array(Array, Array)\n#8 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#9 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))\n#10 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/Container.php(591): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)\n#11 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(134): Illuminate\\Container\\Container->call(Array)\n#12 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Command/Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#13 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#14 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(1001): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#15 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(271): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#16 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(147): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#17 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#18 /Users/itexecutive/Documents/projects/LBS/vendor/laravel/lumen-framework/src/Console/Kernel.php(115): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#19 /Users/itexecutive/Documents/projects/LBS/artisan(35): Laravel\\Lumen\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#20 {main}', '2020-06-03 21:45:58');
INSERT INTO `failed_jobs` (`id`, `connection`, `queue`, `payload`, `exception`, `failed_at`) VALUES
(31, 'database', 'default', '{\"displayName\":\"App\\\\Jobs\\\\SearchLocation\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"delay\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SearchLocation\",\"command\":\"O:23:\\\"App\\\\Jobs\\\\SearchLocation\\\":11:{s:6:\\\"\\u0000*\\u0000lat\\\";N;s:7:\\\"\\u0000*\\u0000long\\\";N;s:8:\\\"\\u0000*\\u0000token\\\";N;s:6:\\\"\\u0000*\\u0000job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 'ErrorException: json_decode() expects parameter 1 to be string, array given in /Users/itexecutive/Documents/projects/LBS/app/Jobs/SearchLocation.php:165\nStack trace:\n#0 [internal function]: Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(2, \'json_decode() e...\', \'/Users/itexecut...\', 165, Array)\n#1 /Users/itexecutive/Documents/projects/LBS/app/Jobs/SearchLocation.php(165): json_decode(Array)\n#2 /Users/itexecutive/Documents/projects/LBS/app/Jobs/SearchLocation.php(60): App\\Jobs\\SearchLocation->next_priority(Array)\n#3 [internal function]: App\\Jobs\\SearchLocation->handle()\n#4 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(32): call_user_func_array(Array, Array)\n#5 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#6 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))\n#7 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/Container.php(591): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)\n#8 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/bus/Dispatcher.php(94): Illuminate\\Container\\Container->call(Array)\n#9 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/pipeline/Pipeline.php(130): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}(Object(App\\Jobs\\SearchLocation))\n#10 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\SearchLocation))\n#11 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/bus/Dispatcher.php(98): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#12 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/CallQueuedHandler.php(83): Illuminate\\Bus\\Dispatcher->dispatchNow(Object(App\\Jobs\\SearchLocation), false)\n#13 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/pipeline/Pipeline.php(130): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}(Object(App\\Jobs\\SearchLocation))\n#14 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\SearchLocation))\n#15 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/CallQueuedHandler.php(85): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#16 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/CallQueuedHandler.php(59): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(App\\Jobs\\SearchLocation))\n#17 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Jobs/Job.php(88): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#18 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(368): Illuminate\\Queue\\Jobs\\Job->fire()\n#19 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(314): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#20 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(267): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#21 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(112): Illuminate\\Queue\\Worker->runNextJob(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#22 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(96): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#23 [internal function]: Illuminate\\Queue\\Console\\WorkCommand->handle()\n#24 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(32): call_user_func_array(Array, Array)\n#25 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#26 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))\n#27 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/Container.php(591): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)\n#28 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(134): Illuminate\\Container\\Container->call(Array)\n#29 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Command/Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#30 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#31 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(1001): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#32 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(271): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#33 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(147): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#34 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#35 /Users/itexecutive/Documents/projects/LBS/vendor/laravel/lumen-framework/src/Console/Kernel.php(115): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#36 /Users/itexecutive/Documents/projects/LBS/artisan(35): Laravel\\Lumen\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#37 {main}', '2020-06-03 21:46:26'),
(32, 'database', 'default', '{\"displayName\":\"App\\\\Jobs\\\\SearchLocation\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"delay\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SearchLocation\",\"command\":\"O:23:\\\"App\\\\Jobs\\\\SearchLocation\\\":11:{s:6:\\\"\\u0000*\\u0000lat\\\";N;s:7:\\\"\\u0000*\\u0000long\\\";N;s:8:\\\"\\u0000*\\u0000token\\\";N;s:6:\\\"\\u0000*\\u0000job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 'Illuminate\\Queue\\MaxAttemptsExceededException: App\\Jobs\\SearchLocation has been attempted too many times or run too long. The job may have previously timed out. in /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php:632\nStack trace:\n#0 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(446): Illuminate\\Queue\\Worker->maxAttemptsExceededException(Object(Illuminate\\Queue\\Jobs\\DatabaseJob))\n#1 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(358): Illuminate\\Queue\\Worker->markJobAsFailedIfAlreadyExceedsMaxAttempts(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), 1)\n#2 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(314): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#3 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(267): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#4 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(112): Illuminate\\Queue\\Worker->runNextJob(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#5 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(96): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#6 [internal function]: Illuminate\\Queue\\Console\\WorkCommand->handle()\n#7 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(32): call_user_func_array(Array, Array)\n#8 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#9 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))\n#10 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/Container.php(591): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)\n#11 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(134): Illuminate\\Container\\Container->call(Array)\n#12 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Command/Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#13 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#14 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(1001): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#15 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(271): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#16 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(147): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#17 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#18 /Users/itexecutive/Documents/projects/LBS/vendor/laravel/lumen-framework/src/Console/Kernel.php(115): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#19 /Users/itexecutive/Documents/projects/LBS/artisan(35): Laravel\\Lumen\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#20 {main}', '2020-06-04 08:34:21'),
(33, 'database', 'default', '{\"displayName\":\"App\\\\Jobs\\\\SearchLocation\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"delay\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SearchLocation\",\"command\":\"O:23:\\\"App\\\\Jobs\\\\SearchLocation\\\":11:{s:6:\\\"\\u0000*\\u0000lat\\\";N;s:7:\\\"\\u0000*\\u0000long\\\";N;s:8:\\\"\\u0000*\\u0000token\\\";N;s:6:\\\"\\u0000*\\u0000job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 'Illuminate\\Queue\\MaxAttemptsExceededException: App\\Jobs\\SearchLocation has been attempted too many times or run too long. The job may have previously timed out. in /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php:632\nStack trace:\n#0 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(446): Illuminate\\Queue\\Worker->maxAttemptsExceededException(Object(Illuminate\\Queue\\Jobs\\DatabaseJob))\n#1 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(358): Illuminate\\Queue\\Worker->markJobAsFailedIfAlreadyExceedsMaxAttempts(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), 1)\n#2 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(314): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#3 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(267): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#4 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(112): Illuminate\\Queue\\Worker->runNextJob(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#5 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(96): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#6 [internal function]: Illuminate\\Queue\\Console\\WorkCommand->handle()\n#7 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(32): call_user_func_array(Array, Array)\n#8 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#9 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))\n#10 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/Container.php(591): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)\n#11 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(134): Illuminate\\Container\\Container->call(Array)\n#12 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Command/Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#13 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#14 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(1001): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#15 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(271): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#16 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(147): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#17 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#18 /Users/itexecutive/Documents/projects/LBS/vendor/laravel/lumen-framework/src/Console/Kernel.php(115): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#19 /Users/itexecutive/Documents/projects/LBS/artisan(35): Laravel\\Lumen\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#20 {main}', '2020-06-04 08:34:58'),
(34, 'database', 'default', '{\"displayName\":\"App\\\\Jobs\\\\SearchLocation\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"delay\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SearchLocation\",\"command\":\"O:23:\\\"App\\\\Jobs\\\\SearchLocation\\\":11:{s:6:\\\"\\u0000*\\u0000lat\\\";N;s:7:\\\"\\u0000*\\u0000long\\\";N;s:8:\\\"\\u0000*\\u0000token\\\";N;s:6:\\\"\\u0000*\\u0000job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 'Illuminate\\Queue\\MaxAttemptsExceededException: App\\Jobs\\SearchLocation has been attempted too many times or run too long. The job may have previously timed out. in /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php:632\nStack trace:\n#0 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(446): Illuminate\\Queue\\Worker->maxAttemptsExceededException(Object(Illuminate\\Queue\\Jobs\\DatabaseJob))\n#1 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(358): Illuminate\\Queue\\Worker->markJobAsFailedIfAlreadyExceedsMaxAttempts(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), 1)\n#2 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(314): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#3 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(267): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#4 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(112): Illuminate\\Queue\\Worker->runNextJob(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#5 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(96): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#6 [internal function]: Illuminate\\Queue\\Console\\WorkCommand->handle()\n#7 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(32): call_user_func_array(Array, Array)\n#8 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#9 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))\n#10 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/Container.php(591): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)\n#11 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(134): Illuminate\\Container\\Container->call(Array)\n#12 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Command/Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#13 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#14 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(1001): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#15 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(271): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#16 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(147): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#17 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#18 /Users/itexecutive/Documents/projects/LBS/vendor/laravel/lumen-framework/src/Console/Kernel.php(115): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#19 /Users/itexecutive/Documents/projects/LBS/artisan(35): Laravel\\Lumen\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#20 {main}', '2020-06-04 08:35:36'),
(35, 'database', 'default', '{\"displayName\":\"App\\\\Jobs\\\\SearchLocation\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"delay\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SearchLocation\",\"command\":\"O:23:\\\"App\\\\Jobs\\\\SearchLocation\\\":11:{s:6:\\\"\\u0000*\\u0000lat\\\";N;s:7:\\\"\\u0000*\\u0000long\\\";N;s:8:\\\"\\u0000*\\u0000token\\\";N;s:6:\\\"\\u0000*\\u0000job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 'Illuminate\\Queue\\MaxAttemptsExceededException: App\\Jobs\\SearchLocation has been attempted too many times or run too long. The job may have previously timed out. in /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php:632\nStack trace:\n#0 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(446): Illuminate\\Queue\\Worker->maxAttemptsExceededException(Object(Illuminate\\Queue\\Jobs\\DatabaseJob))\n#1 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(358): Illuminate\\Queue\\Worker->markJobAsFailedIfAlreadyExceedsMaxAttempts(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), 1)\n#2 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(314): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#3 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Worker.php(267): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#4 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(112): Illuminate\\Queue\\Worker->runNextJob(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#5 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/queue/Console/WorkCommand.php(96): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#6 [internal function]: Illuminate\\Queue\\Console\\WorkCommand->handle()\n#7 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(32): call_user_func_array(Array, Array)\n#8 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#9 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))\n#10 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/container/Container.php(591): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)\n#11 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(134): Illuminate\\Container\\Container->call(Array)\n#12 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Command/Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#13 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#14 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(1001): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#15 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(271): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#16 /Users/itexecutive/Documents/projects/LBS/vendor/symfony/console/Application.php(147): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#17 /Users/itexecutive/Documents/projects/LBS/vendor/illuminate/console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#18 /Users/itexecutive/Documents/projects/LBS/vendor/laravel/lumen-framework/src/Console/Kernel.php(115): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#19 /Users/itexecutive/Documents/projects/LBS/artisan(35): Laravel\\Lumen\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#20 {main}', '2020-06-04 08:39:33');

-- --------------------------------------------------------

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--

INSERT INTO `jobs` (`id`, `queue`, `payload`, `attempts`, `reserved_at`, `available_at`, `created_at`) VALUES
(5, 'default', '{\"displayName\":\"App\\\\Jobs\\\\SearchLocation\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"delay\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SearchLocation\",\"command\":\"O:23:\\\"App\\\\Jobs\\\\SearchLocation\\\":11:{s:6:\\\"\\u0000*\\u0000lat\\\";N;s:7:\\\"\\u0000*\\u0000long\\\";N;s:8:\\\"\\u0000*\\u0000token\\\";N;s:6:\\\"\\u0000*\\u0000job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 1, 1591256319, 1591256318, 1591256318);

-- --------------------------------------------------------

--
-- Table structure for table `locations`
--

CREATE TABLE `locations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `program_id` int(10) DEFAULT NULL,
  `location_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `longitude` decimal(10,6) NOT NULL,
  `latitude` decimal(10,6) NOT NULL,
  `radius` bigint(20) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `locations`
--

INSERT INTO `locations` (`id`, `program_id`, `location_name`, `slug`, `longitude`, `latitude`, `radius`, `status`, `created_at`, `updated_at`) VALUES
(1, 5, 'Kano State', 'grandsquare-abuja', '-78.395833', '37.297778', 10, 1, '2020-04-29 09:26:00', '2020-06-03 10:36:31'),
(2, 6, 'Port Harcourt', 'david-wej-vi', '-76.706944', '37.270833', 40, 1, '2020-04-29 09:28:18', '2020-06-03 10:36:33'),
(5, 5, 'Anambra', 'anambra-slug', '-78.395833', '37.297778', 60, 1, '2020-05-11 21:33:36', '2020-06-04 07:54:44'),
(6, 2, 'calabar', 'calabar-slug', '-76.262500', '36.848700', 200, 1, '2020-05-11 21:33:36', '2020-06-04 08:37:38'),
(7, 1, 'virginia commonwealth university', 'virginia-commonwealth-university', '-77.453255', '37.546615', 90, 1, '2020-05-13 14:32:48', '2020-06-03 10:36:41'),
(8, 1, 'irginia military institute', 'irginia-military-institute', '-79.440000', '37.790000', 120, 1, '2020-05-13 14:32:48', '2020-06-04 07:52:34'),
(9, 4, 'virginia state university', 'virginia-state-university', '-77.425556', '37.242778', 30, 1, '2020-05-13 14:34:08', '2020-06-03 10:36:49'),
(10, 3, 'virginia tech', 'virginia-tech', '-80.425000', '37.225000', 10, 1, '2020-05-13 14:34:08', '2020-06-03 10:36:51'),
(11, 2, 'uva wise', 'uva-wise', '-82.576944', '36.978056', 200, 1, '2020-05-13 14:35:13', '2020-06-04 08:37:42'),
(12, 4, 'university of virginia', 'university-of-virginia', '-78.478889', '38.030000', 20, 1, '2020-05-13 14:36:02', '2020-06-03 10:36:55'),
(13, NULL, 'David Wej VI', 'test-test', '2.543000', '3.675400', 200, 1, '2020-06-09 23:33:35', '2020-06-09 23:33:35');

-- --------------------------------------------------------

--
-- Table structure for table `location_jobs`
--

CREATE TABLE `location_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `membership_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_handle` tinyint(1) NOT NULL DEFAULT '0',
  `location_id` int(10) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `location_jobs`
--

INSERT INTO `location_jobs` (`id`, `membership_number`, `is_handle`, `location_id`, `created_at`, `updated_at`) VALUES
(27, '126376367679', 0, 5, '2020-06-08 11:44:22', '2020-06-08 11:44:22'),
(28, '126376367663', 0, 6, '2020-06-08 11:44:22', '2020-06-09 14:14:21'),
(29, '126376367675', 0, 5, '2020-06-08 11:44:22', '2020-06-08 11:44:22'),
(30, '126376367656', 0, 5, '2020-06-08 11:44:22', '2020-06-08 11:44:22'),
(31, '126376367643', 0, 5, '2020-06-08 11:44:22', '2020-06-08 11:44:22'),
(32, '126376367655', 0, 5, '2020-06-08 11:44:22', '2020-06-08 11:44:22'),
(33, '126376367622', 0, 5, '2020-06-08 11:44:22', '2020-06-08 11:44:22'),
(34, '126376367677', 0, 6, '2020-06-08 11:44:22', '2020-06-08 11:44:22');

-- --------------------------------------------------------

--
-- Table structure for table `location_message`
--

CREATE TABLE `location_message` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `location_id` int(11) NOT NULL,
  `message_id` int(11) NOT NULL,
  `priority` int(10) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `location_message`
--

INSERT INTO `location_message` (`id`, `location_id`, `message_id`, `priority`, `status`, `created_at`, `updated_at`) VALUES
(12, 1, 6, 1, 1, '2020-06-09 19:29:16', '2020-06-09 19:29:16'),
(13, 1, 7, 2, 1, '2020-06-09 19:49:18', '2020-06-09 19:49:18'),
(14, 1, 8, 3, 1, '2020-06-09 19:50:18', '2020-06-09 19:50:18');

-- --------------------------------------------------------

--
-- Table structure for table `location_msg_medium`
--

CREATE TABLE `location_msg_medium` (
  `id` int(10) UNSIGNED NOT NULL,
  `location_id` int(10) NOT NULL,
  `medium_id` int(10) NOT NULL,
  `msg_interval` bigint(20) NOT NULL,
  `reset_interval` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `location_msg_medium`
--

INSERT INTO `location_msg_medium` (`id`, `location_id`, `medium_id`, `msg_interval`, `reset_interval`) VALUES
(1, 2, 2, 72, 24),
(2, 5, 1, 72, 24),
(3, 6, 2, 12, 24);

-- --------------------------------------------------------

--
-- Table structure for table `log_activity`
--

CREATE TABLE `log_activity` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `old_data` text COLLATE utf8mb4_unicode_ci,
  `new_data` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `agent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `log_activity`
--

INSERT INTO `log_activity` (`id`, `subject`, `old_data`, `new_data`, `url`, `method`, `ip`, `agent`, `slug`, `created_at`, `updated_at`) VALUES
(1, 'new Loyalty program added', '', 'a:3:{s:12:\"program_name\";s:8:\"newtest4\";s:4:\"slug\";s:8:\"newtest4\";s:5:\"token\";s:62:\"$2y$10$UpejqebdeBn1SAqZRxDKUOHDYhIpeZd3QS4zMWPylrsM3Jjiqnjsdhg\";}', 'http://localhost:8000/api/v1/program/add', 'POST', '::1', 'PostmanRuntime/7.21.0', 'newtest4', '2020-06-09 09:33:30', '2020-06-09 09:33:30'),
(2, 'Update Loyalty program', 'O:8:\"stdClass\":3:{s:2:\"id\";i:1;s:12:\"program_name\";s:4:\"preX\";s:6:\"status\";i:1;}', 'a:1:{s:12:\"program_name\";s:4:\"PreX\";}', 'http://localhost:8000/api/v1/program/update/prex-test?program_name=PreX', 'PUT', '::1', 'PostmanRuntime/7.21.0', 'prex-test', '2020-06-09 10:01:34', '2020-06-09 10:01:34'),
(3, 'Update Loyalty program', 'O:8:\"stdClass\":3:{s:2:\"id\";i:1;s:12:\"program_name\";s:4:\"PreX\";s:6:\"status\";i:1;}', 'a:1:{s:12:\"program_name\";s:4:\"preX\";}', 'http://localhost:8000/api/v1/program/update/prex-test?program_name=preX', 'PUT', '::1', 'PostmanRuntime/7.21.0', 'prex-test', '2020-06-09 10:04:07', '2020-06-09 10:04:07'),
(4, 'Update Loyalty program', 'O:8:\"stdClass\":3:{s:2:\"id\";i:1;s:12:\"program_name\";s:4:\"preX\";s:6:\"status\";i:1;}', 'a:1:{s:12:\"program_name\";s:4:\"PreX\";}', 'http://localhost:8000/api/v1/program/update/prex-test?program_name=PreX', 'PUT', '::1', 'PostmanRuntime/7.21.0', 'prex-test', '2020-06-09 10:04:25', '2020-06-09 10:04:25'),
(5, 'Update Loyalty program', 'O:8:\"stdClass\":3:{s:2:\"id\";i:1;s:12:\"program_name\";s:4:\"PreX\";s:6:\"status\";i:1;}', 'a:1:{s:12:\"program_name\";s:4:\"preX\";}', 'http://localhost:8000/api/v1/program/update/prex-test?program_name=preX', 'PUT', '::1', 'PostmanRuntime/7.21.0', 'prex-test', '2020-06-09 10:13:27', '2020-06-09 10:13:27'),
(6, 'Disable a Loyalty program', 'O:8:\"stdClass\":3:{s:2:\"id\";i:5;s:12:\"program_name\";s:11:\"grandsquare\";s:6:\"status\";i:1;}', 'a:1:{s:6:\"status\";i:2;}', 'http://localhost:8000/api/v1/program/disable/grandsquare-test', 'GET', '::1', 'PostmanRuntime/7.21.0', 'grandsquare-test', '2020-06-09 10:17:30', '2020-06-09 10:17:30'),
(7, 'Enable a Loyalty program', 'O:8:\"stdClass\":3:{s:2:\"id\";i:5;s:12:\"program_name\";s:11:\"grandsquare\";s:6:\"status\";i:2;}', 'a:1:{s:6:\"status\";i:1;}', 'http://localhost:8000/api/v1/program/enable/grandsquare-test', 'GET', '::1', 'PostmanRuntime/7.21.0', 'grandsquare-test', '2020-06-09 10:18:02', '2020-06-09 10:18:02'),
(8, 'New Message Created', '', 'a:4:{s:18:\"loyalty_program_id\";s:1:\"6\";s:12:\"message_name\";s:16:\"new test message\";s:12:\"message_body\";s:16:\"test new message\";s:8:\"priority\";s:1:\"2\";}', 'http://localhost:8000/api/v1/message/create', 'POST', '::1', 'PostmanRuntime/7.21.0', 'remis-test', '2020-06-09 12:13:20', '2020-06-09 12:13:20'),
(9, 'Message Updated', 'O:8:\"stdClass\":9:{s:2:\"id\";i:4;s:18:\"loyalty_program_id\";i:6;s:11:\"location_id\";N;s:12:\"message_name\";s:16:\"new test message\";s:12:\"message_body\";s:16:\"test new message\";s:8:\"priority\";i:2;s:6:\"status\";i:1;s:10:\"created_at\";s:19:\"2020-06-09 12:13:20\";s:10:\"updated_at\";s:19:\"2020-06-09 12:13:20\";}', 'a:0:{}', 'http://localhost:8000/api/v1/message/edit/4?location_id=6', 'PUT', '::1', 'PostmanRuntime/7.21.0', '4', '2020-06-09 12:45:43', '2020-06-09 12:45:43'),
(10, 'Message Updated', 'O:8:\"stdClass\":9:{s:2:\"id\";i:4;s:18:\"loyalty_program_id\";i:6;s:11:\"location_id\";i:6;s:12:\"message_name\";s:16:\"new test message\";s:12:\"message_body\";s:16:\"test new message\";s:8:\"priority\";i:2;s:6:\"status\";i:1;s:10:\"created_at\";s:19:\"2020-06-09 12:13:20\";s:10:\"updated_at\";s:19:\"2020-06-09 12:45:43\";}', 'a:0:{}', 'http://localhost:8000/api/v1/message/edit/4?location_id=5', 'PUT', '::1', 'PostmanRuntime/7.21.0', '4', '2020-06-09 12:52:19', '2020-06-09 12:52:19'),
(11, 'New Message Created', '', 'a:4:{s:18:\"loyalty_program_id\";s:1:\"6\";s:12:\"message_name\";s:16:\"new test message\";s:12:\"message_body\";s:16:\"test new message\";s:8:\"priority\";s:1:\"2\";}', 'http://localhost:8000/api/v1/message/create', 'POST', '::1', 'PostmanRuntime/7.21.0', 'remis-test', '2020-06-09 19:08:08', '2020-06-09 19:08:08'),
(12, 'New Message Created', '', 'a:4:{s:18:\"loyalty_program_id\";s:1:\"5\";s:12:\"message_name\";s:19:\"new program message\";s:12:\"message_body\";s:19:\"program new message\";s:8:\"priority\";s:1:\"1\";}', 'http://localhost:8000/api/v1/message/create', 'POST', '::1', 'PostmanRuntime/7.21.0', 'grandsquare-test', '2020-06-09 19:08:42', '2020-06-09 19:08:42'),
(13, 'Location message created', '', 'a:3:{s:11:\"location_id\";s:1:\"1\";s:10:\"message_id\";s:1:\"6\";s:8:\"priority\";i:1;}', 'http://localhost:8000/api/v1/assignmessage/create', 'POST', '::1', 'PostmanRuntime/7.21.0', '', '2020-06-09 19:29:16', '2020-06-09 19:29:16'),
(14, 'New Message Created', '', 'a:4:{s:18:\"loyalty_program_id\";s:1:\"5\";s:12:\"message_name\";s:23:\"another program message\";s:12:\"message_body\";s:23:\"another program message\";s:8:\"priority\";s:1:\"2\";}', 'http://localhost:8000/api/v1/message/create', 'POST', '::1', 'PostmanRuntime/7.21.0', 'grandsquare-test', '2020-06-09 19:39:50', '2020-06-09 19:39:50'),
(15, 'New Message Created', '', 'a:4:{s:18:\"loyalty_program_id\";s:1:\"5\";s:12:\"message_name\";s:15:\"another message\";s:12:\"message_body\";s:27:\"another message for program\";s:8:\"priority\";s:1:\"3\";}', 'http://localhost:8000/api/v1/message/create', 'POST', '::1', 'PostmanRuntime/7.21.0', 'grandsquare-test', '2020-06-09 19:41:38', '2020-06-09 19:41:38'),
(16, 'New Message Created', '', 'a:4:{s:18:\"loyalty_program_id\";s:1:\"5\";s:12:\"message_name\";s:12:\"last message\";s:12:\"message_body\";s:24:\"last message for program\";s:8:\"priority\";s:1:\"4\";}', 'http://localhost:8000/api/v1/message/create', 'POST', '::1', 'PostmanRuntime/7.21.0', 'grandsquare-test', '2020-06-09 19:45:01', '2020-06-09 19:45:01'),
(17, 'Location message created', '', 'a:3:{s:11:\"location_id\";s:1:\"1\";s:10:\"message_id\";s:1:\"7\";s:8:\"priority\";i:2;}', 'http://localhost:8000/api/v1/assignmessage/create', 'POST', '::1', 'PostmanRuntime/7.21.0', '', '2020-06-09 19:49:18', '2020-06-09 19:49:18'),
(18, 'Location message created', '', 'a:3:{s:11:\"location_id\";s:1:\"1\";s:10:\"message_id\";s:1:\"8\";s:8:\"priority\";i:3;}', 'http://localhost:8000/api/v1/assignmessage/create', 'POST', '::1', 'PostmanRuntime/7.21.0', '', '2020-06-09 19:50:18', '2020-06-09 19:50:18'),
(19, 'Location Created', '', 'a:7:{s:13:\"location_name\";s:12:\"David Wej VI\";s:13:\"location_slug\";s:9:\"test-test\";s:9:\"longitude\";s:8:\"2.543000\";s:8:\"latitude\";s:8:\"3.675400\";s:6:\"status\";i:1;s:10:\"created_at\";s:19:\"2020-06-09 23:33:35\";s:10:\"updated_at\";s:19:\"2020-06-09 23:33:35\";}', 'http://localhost:8000/api/v1/location/add', 'POST', '::1', 'PostmanRuntime/7.21.0', 'test-test', '2020-06-09 23:33:35', '2020-06-09 23:33:35');

-- --------------------------------------------------------

--
-- Table structure for table `max_distance`
--

CREATE TABLE `max_distance` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `loyalty_program_id` int(11) NOT NULL,
  `location_id` int(10) DEFAULT NULL,
  `message_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message_body` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `priority` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` (`id`, `loyalty_program_id`, `location_id`, `message_name`, `message_body`, `priority`, `status`, `created_at`, `updated_at`) VALUES
(5, 6, NULL, 'new test message', 'test new message', 2, 1, '2020-06-09 19:08:08', '2020-06-09 19:08:08'),
(6, 5, NULL, 'new program message', 'program new message', 1, 1, '2020-06-09 19:08:42', '2020-06-09 19:08:42'),
(7, 5, NULL, 'another program message', 'another program message', 2, 1, '2020-06-09 19:39:50', '2020-06-09 19:39:50'),
(8, 5, NULL, 'another message', 'another message for program', 3, 1, '2020-06-09 19:41:38', '2020-06-09 19:41:38'),
(9, 5, NULL, 'last message', 'last message for program', 4, 1, '2020-06-09 19:45:01', '2020-06-09 19:45:01');

-- --------------------------------------------------------

--
-- Table structure for table `message_medium`
--

CREATE TABLE `message_medium` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `message_medium`
--

INSERT INTO `message_medium` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'email', '2020-06-03 11:06:42', '2020-06-03 11:07:37'),
(2, 'sms', '2020-06-03 11:06:42', '2020-06-03 11:07:32');

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2020_04_27_101700_create_programs_table', 1),
(2, '2020_04_27_105648_create_program_settings_master_table', 1),
(3, '2020_04_27_113004_create_locations_table', 1),
(6, '2020_04_27_113430_create_location_message_table', 1),
(7, '2020_04_27_114926_create_max_distance_table', 1),
(8, '2020_04_27_115004_create_max_interval_table', 1),
(9, '2020_04_28_110244_add_program_name_to_program_settings_master_table', 2),
(10, '2020_04_28_112812_add_status_to_program_settings_mastet_table', 3),
(11, '2020_04_27_113131_create_program_locations', 4),
(12, '2020_04_27_113317_create_program_message_table', 5),
(13, '2020_05_03_154645_create_log_activity_table', 6),
(14, '2020_05_13_160411_create_search_result_table', 7),
(15, '2020_05_13_163722_create_failed_jobs_table', 8),
(16, '2020_05_19_073351_create_sent_messages_table', 9),
(17, '2020_06_01_121829_create_message_medium_table', 10),
(18, '2020_06_01_122458_create_distance_request_table', 10),
(19, '2020_06_05_105041_create_location_jobs_table', 11);

-- --------------------------------------------------------

--
-- Table structure for table `msg_interval`
--

CREATE TABLE `msg_interval` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `programs`
--

CREATE TABLE `programs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `program_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `access` tinyint(1) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '1',
  `token` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `programs`
--

INSERT INTO `programs` (`id`, `program_name`, `slug`, `access`, `status`, `token`, `created_at`, `updated_at`) VALUES
(1, 'preX', 'prex-test', 1, 1, '$2y$10$UpejqebdeBn1SAqZRxDKUOHDYhIpeZd3QS4zMWPylrsM3JjiqM6ZM', '2020-04-28 09:08:07', '2020-06-09 10:13:27'),
(5, 'grandsquare', 'grandsquare-test', 0, 1, '$2y$10$UpejqebdeBn1SAqZRxDKUOHDYhIpeZz3QS4zMWPylrsM3JjiqM6MM', '2020-04-28 09:08:35', '2020-06-09 10:18:02'),
(6, 'remis', 'remis-test', 0, 0, '$2y$10$UpejqebdeBn1SAqZRxDKUOHDYhIpeZd3QS4zMWPylrsM3JjiqM6Zs', '2020-04-28 10:24:23', '2020-06-09 12:06:51'),
(18, 'test test', 'test-test', 0, 1, '$2y$10$UpejqebdeBn1SAqZRxDKUOHDYhIpeZd3QS4zMWPylrsM3JjiqM6Zc', '2020-05-04 15:10:35', '2020-06-09 08:38:04'),
(19, 'test test2', 'test-test2', 0, 1, '$2y$10$UpejqebdeBn1SAqZRxDKUOHDYhIpeZd3QS4zMWPylrsM3JjiqM6Zn', '2020-05-04 15:13:08', '2020-06-09 08:38:08'),
(20, 'test test3', 'test-test3', 0, 1, '$2y$10$UpejqebdeBn1SAqZRxDKUOHDYhIpeZd3QS4zMWPylrsM3JjiqM6Zl', '2020-05-04 15:13:59', '2020-06-09 08:38:13'),
(21, 'newtest4', 'newtest4', 0, 1, '$2y$10$UpejqebdeBn1SAqZRxDKUOHDYhIpeZd3QS4zMWPylrsM3Jjiqnjsdhg', '2020-06-09 09:33:30', '2020-06-09 09:33:30');

-- --------------------------------------------------------

--
-- Table structure for table `program_locations`
--

CREATE TABLE `program_locations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `loyalty_program_id` int(11) NOT NULL,
  `location_id` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `program_locations`
--

INSERT INTO `program_locations` (`id`, `loyalty_program_id`, `location_id`, `status`, `created_at`, `updated_at`) VALUES
(1, 5, 1, 1, '2020-04-29 12:04:36', '2020-04-29 12:19:12'),
(2, 6, 2, 1, '2020-04-29 14:31:58', '2020-05-13 14:38:10'),
(3, 5, 3, 1, '2020-05-04 23:23:22', '2020-05-04 23:23:22'),
(4, 5, 7, 1, '2020-05-13 14:38:48', '2020-05-13 14:38:48'),
(5, 5, 12, 1, '2020-05-13 14:38:48', '2020-05-13 14:38:48');

-- --------------------------------------------------------

--
-- Table structure for table `program_settings_master`
--

CREATE TABLE `program_settings_master` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `loyalty_program_id` int(11) NOT NULL,
  `maximum_distance` mediumint(9) NOT NULL,
  `message_interval` mediumint(9) NOT NULL,
  `message_medium` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `program_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `program_settings_master`
--

INSERT INTO `program_settings_master` (`id`, `loyalty_program_id`, `maximum_distance`, `message_interval`, `message_medium`, `created_at`, `updated_at`, `program_name`, `status`) VALUES
(1, 1, 1, 40, '1', '2020-04-28 14:32:55', '2020-05-04 21:58:49', 'prex', 1),
(2, 2, 2, 30, '1', '2020-04-28 15:38:10', '2020-04-28 17:32:22', 'prex', 1),
(3, 3, 2, 30, '1', '2020-04-28 15:53:36', '2020-04-28 17:32:26', 'prex', 1),
(4, 5, 2, 30, '1', '2020-05-04 21:34:55', '2020-05-04 21:34:55', 'grandsquare', 1);

-- --------------------------------------------------------

--
-- Table structure for table `search_results`
--

CREATE TABLE `search_results` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `search_result` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `loyalty_program` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `search_results`
--

INSERT INTO `search_results` (`id`, `search_result`, `loyalty_program`, `created_at`, `updated_at`) VALUES
(1, 'a:3:{i:0;O:8:\"stdClass\":8:{s:2:\"id\";i:1;s:13:\"location_name\";s:10:\"Kano State\";s:4:\"slug\";s:17:\"grandsquare-abuja\";s:9:\"longitude\";s:10:\"-78.395833\";s:8:\"latitude\";s:9:\"37.297778\";s:6:\"status\";i:1;s:10:\"created_at\";s:19:\"2020-04-29 09:26:00\";s:10:\"updated_at\";s:19:\"2020-05-13 14:29:56\";}i:1;O:8:\"stdClass\":8:{s:2:\"id\";i:7;s:13:\"location_name\";s:32:\"virginia commonwealth university\";s:4:\"slug\";s:32:\"virginia-commonwealth-university\";s:9:\"longitude\";s:10:\"-77.453255\";s:8:\"latitude\";s:9:\"37.546615\";s:6:\"status\";i:1;s:10:\"created_at\";s:19:\"2020-05-13 14:32:48\";s:10:\"updated_at\";s:19:\"2020-05-13 14:32:48\";}i:2;O:8:\"stdClass\":8:{s:2:\"id\";i:12;s:13:\"location_name\";s:22:\"university of virginia\";s:4:\"slug\";s:22:\"university-of-virginia\";s:9:\"longitude\";s:10:\"-78.478889\";s:8:\"latitude\";s:9:\"38.030000\";s:6:\"status\";i:1;s:10:\"created_at\";s:19:\"2020-05-13 14:36:02\";s:10:\"updated_at\";s:19:\"2020-05-13 14:36:02\";}}', 5, '2020-05-14 12:54:02', '2020-05-14 12:54:02');

-- --------------------------------------------------------

--
-- Table structure for table `sent_messages`
--

CREATE TABLE `sent_messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `location_id` int(10) NOT NULL,
  `message_id` tinyint(10) NOT NULL,
  `member_number` bigint(20) NOT NULL,
  `priority` int(10) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sent_messages`
--

INSERT INTO `sent_messages` (`id`, `location_id`, `message_id`, `member_number`, `priority`, `created_at`, `updated_at`) VALUES
(1, 5, 2, 126376367677, 2, '2020-06-03 14:00:58', '2020-06-04 12:48:43'),
(2, 2, 1, 126376367673, 1, '2020-06-04 11:33:14', '2020-06-04 12:57:29'),
(3, 5, 1, 126376367677, 1, '2020-06-05 22:12:25', '2020-06-05 22:12:25'),
(4, 5, 1, 126376367677, 1, '2020-06-05 22:12:25', '2020-06-05 22:12:25'),
(5, 5, 1, 126376367677, 1, '2020-06-05 22:13:08', '2020-06-05 22:13:08'),
(6, 5, 1, 126376367677, 1, '2020-06-05 22:13:08', '2020-06-05 22:13:08'),
(7, 5, 1, 126376367677, 1, '2020-06-07 10:24:27', '2020-06-07 10:24:27'),
(8, 6, 1, 126376367677, 1, '2020-06-07 10:24:27', '2020-06-08 11:48:36');

-- --------------------------------------------------------

--
-- Table structure for table `users_request`
--

CREATE TABLE `users_request` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `program_id` int(11) NOT NULL,
  `longitude` decimal(10,6) NOT NULL,
  `latitude` decimal(10,6) NOT NULL,
  `membership_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_handle` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users_request`
--

INSERT INTO `users_request` (`id`, `program_id`, `longitude`, `latitude`, `membership_number`, `is_handle`, `created_at`, `updated_at`) VALUES
(105, 5, '-78.245278', '37.496111', '126376367679', 1, '2020-06-03 20:44:24', '2020-06-08 11:44:22'),
(106, 5, '-78.245278', '37.496111', '126376367663', 1, '2020-06-03 20:45:53', '2020-06-08 11:44:22'),
(107, 5, '-78.245278', '37.496111', '126376367675', 1, '2020-06-03 20:46:24', '2020-06-08 11:44:22'),
(108, 5, '-78.245278', '37.496111', '126376367656', 1, '2020-06-04 07:32:48', '2020-06-08 11:44:22'),
(109, 5, '-78.245278', '37.496111', '126376367643', 1, '2020-06-04 07:33:24', '2020-06-08 11:44:22'),
(110, 5, '-78.245278', '37.496111', '126376367655', 1, '2020-06-04 07:34:02', '2020-06-08 11:44:22'),
(111, 5, '-78.245278', '37.496111', '126376367622', 1, '2020-06-04 07:38:01', '2020-06-08 11:44:22'),
(112, 2, '-78.245276', '37.496112', '126376367677', 1, '2020-06-04 07:38:38', '2020-06-08 11:44:22');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `locations`
--
ALTER TABLE `locations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `location_jobs`
--
ALTER TABLE `location_jobs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `location_message`
--
ALTER TABLE `location_message`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `location_msg_medium`
--
ALTER TABLE `location_msg_medium`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `log_activity`
--
ALTER TABLE `log_activity`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `max_distance`
--
ALTER TABLE `max_distance`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `message_medium`
--
ALTER TABLE `message_medium`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `msg_interval`
--
ALTER TABLE `msg_interval`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `programs`
--
ALTER TABLE `programs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `program_locations`
--
ALTER TABLE `program_locations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `program_settings_master`
--
ALTER TABLE `program_settings_master`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `search_results`
--
ALTER TABLE `search_results`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sent_messages`
--
ALTER TABLE `sent_messages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users_request`
--
ALTER TABLE `users_request`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `locations`
--
ALTER TABLE `locations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `location_jobs`
--
ALTER TABLE `location_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `location_message`
--
ALTER TABLE `location_message`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `location_msg_medium`
--
ALTER TABLE `location_msg_medium`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `log_activity`
--
ALTER TABLE `log_activity`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `max_distance`
--
ALTER TABLE `max_distance`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `message_medium`
--
ALTER TABLE `message_medium`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `msg_interval`
--
ALTER TABLE `msg_interval`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `programs`
--
ALTER TABLE `programs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `program_locations`
--
ALTER TABLE `program_locations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `program_settings_master`
--
ALTER TABLE `program_settings_master`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `search_results`
--
ALTER TABLE `search_results`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sent_messages`
--
ALTER TABLE `sent_messages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `users_request`
--
ALTER TABLE `users_request`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=113;
