Error on SANDBOX for search near address endpoint
27 views
Skip to first unread message
gregory hutchinson
Nov 23, 2016, 7:49:39 PM11/23/16
to deliverydotcom API V2
No code changes on my end, but seems like searching for a restaurant -- simple test in postman returns the result below
{
"message": [
{
"code": "general_error",
"user_msg": "A technical error occurred. Please contact customer service.",
"dev_msg": {
"message": "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nyctogo.RESTAURANT_GEOMETRY' doesn't exist (SQL: (SELECT\n\t\t \tR.RESTAURANT_ID,\n R.TAKE_OUT,\n R.DELIVERY,\n 3959*2*ASIN(SQRT(POWER(SIN((R.LATITUDE - 34.17751)*pi()/180/2),2)+COS(R.LATITUDE * pi()/180)*COS(34.17751 * pi()/180) * POWER(SIN((R.LONGITUDE - -118.30304) * pi()/180/2),2))) AS DISTANCE,\n DR.DELIVERY_RANGE_ID,\n DR.DELIVERY_CHARGE,\n DR.DELIVERY_PERCENT,\n DR.MIN_DELIVER AS MINIMUM_DELIVERY_AMOUNT,\n DR.RANGE_TYPE,\n DR.LMP,\n RMP.MINIMUM_ORDER_AMOUNT as MINIMUM_PICKUP_AMOUNT,\n\t\t \tTRUE AS IS_DELIVERY,\n\t\t \tFALSE AS IS_PICKUP\n\t\t FROM\n\t\t \tRESTAURANT R\n \t\tJOIN DELIVERY_RANGE DR ON (R.RESTAURANT_ID=DR.RESTAURANT_ID)\n \t\t\n \t\tLEFT JOIN RESTAURANT_MINIMUM_PICKUP RMP\n\t\t\t ON (R.RESTAURANT_ID = RMP.RESTAURANT_ID)\n\t\t WHERE\n\t\t \t\tR.LONGITUDE IS NOT NULL\n\t\t \tAND R.ACTIVE='Y'\n\t\t \tAND R.DELIVERY='Y'\n\t\t \t\n\t\t \tAND DR.DELIVERY_RANGE_ID IN (0,18924,19937543,25470291,422719,25346670,77332,77350,18923,25333936)\n \n \n\t\t ) UNION ALL (\n\t\t\t SELECT\n\t\t\t \tR.RESTAURANT_ID,\n R.TAKE_OUT,\n R.DELIVERY,\n 3959*2*ASIN(SQRT(POWER(SIN((R.LATITUDE - 34.17751)*pi()/180/2),2)+COS(R.LATITUDE * pi()/180)*COS(34.17751 * pi()/180) * POWER(SIN((R.LONGITUDE - -118.30304) * pi()/180/2),2))) AS DISTANCE,\n null as DELIVERY_RANGE_ID,\n null as DELIVERY_CHARGE,\n null as DELIVERY_PERCENT,\n null as MINIMUM_DELIVERY_AMOUNT,\n null as LMP,\n RMP.MINIMUM_ORDER_AMOUNT as MINIMUM_PICKUP_AMOUNT,\n null as RANGE_TYPE,\n\t\t\t \tFALSE AS IS_DELIVERY,\n\t\t\t \tTRUE AS IS_PICKUP\n\t\t\t FROM\n\t\t\t \tRESTAURANT R\n\t\t\t \t\n\t\t\t LEFT JOIN RESTAURANT_MINIMUM_PICKUP RMP\n\t\t\t ON (R.RESTAURANT_ID = RMP.RESTAURANT_ID)\n JOIN RESTAURANT_GEOMETRY RG ON (R.RESTAURANT_ID=RG.RESTAURANT_ID)\n\t\t\t WHERE\n\t\t\t MBRWithin(RG.GEOMETRY, GeomFromText('LINESTRING(34.083434 -118.416754, 34.271586 -118.189326)'))\n\t\t\t \t\n\t\t\t \tAND R.ACTIVE = 'Y'\n\t\t\t \tAND R.TAKE_OUT = 'Y'\n\t\t\t\tAND 6.5 > 3959*2*ASIN(SQRT(POWER(SIN((R.LATITUDE - 34.17751)*pi()/180/2),2)+COS(R.LATITUDE * pi()/180)*COS(34.17751 * pi()/180) * POWER(SIN((R.LONGITUDE - -118.30304) * pi()/180/2),2))) \n \n \n\t\t\t)\n\n )",
"line": 625,
"file": "/var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php",
"exception": "exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nyctogo.RESTAURANT_GEOMETRY' doesn't exist' in /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:299\nStack trace:\n#0 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(299): PDO->prepare('(SELECT\\n\\t\\t \\tR....')\n#1 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(617): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}(Object(Illuminate\\Database\\MySqlConnection), '(SELECT\\n\\t\\t \\tR....', Array)\n#2 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(581): Illuminate\\Database\\Connection->runQueryCallback('(SELECT\\n\\t\\t \\tR....', Array, Object(Closure))\n#3 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(304): Illuminate\\Database\\Connection->run('(SELECT\\n\\t\\t \\tR....', Array, Object(Closure))\n#4 /var/www/deliveryApi/backend/laravel/vendor/dcom/lib-dcom/lib/DeliveryCoreLib/Merchant/Search/DcomSearchRangeSql.php(221): Illuminate\\Database\\Connection->select('(SELECT\\n\\t\\t \\tR....')\n#5 /var/www/deliveryApi/backend/laravel/vendor/dcom/lib-dcom/lib/DeliveryCoreLib/Merchant/Search/DcomSearchRangeSql.php(256): DeliveryCoreLib\\Merchant\\Search\\DcomSearchRangeSql->queryMerchantsInRange(Object(DeliveryCoreLib\\Address\\US\\Address))\n#6 /var/www/deliveryApi/backend/laravel/vendor/dcom/lib-dcom/lib/DeliveryCoreLib/Merchant/Search/DcomRepositoryNewOrderTime.php(116): DeliveryCoreLib\\Merchant\\Search\\DcomSearchRangeSql->getMerchantsInRange(Object(DeliveryCoreLib\\Address\\US\\Address))\n#7 /var/www/deliveryApi/backend/laravel/app/lib/Delivery/Packages/Search/Controllers/SearchController.php(139): DeliveryCoreLib\\Merchant\\Search\\DcomRepositoryNewOrderTime->findMerchantsInRange(Object(DeliveryCoreLib\\Address\\US\\Address))\n#8 [internal function]: Delivery\\Packages\\Search\\Controllers\\SearchController->getDeliverySearchResults()\n#9 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(231): call_user_func_array(Array, Array)\n#10 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(93): Illuminate\\Routing\\Controller->callAction('getDeliverySear...', Array)\n#11 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(62): Illuminate\\Routing\\ControllerDispatcher->call(Object(Delivery\\Packages\\Search\\Controllers\\SearchController), Object(Illuminate\\Routing\\Route), 'getDeliverySear...')\n#12 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(967): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request), '\\\\Delivery\\\\Packa...', 'getDeliverySear...')\n#13 [internal function]: Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()\n#14 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Routing/Route.php(109): call_user_func_array(Object(Closure), Array)\n#15 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1033): Illuminate\\Routing\\Route->run(Object(Illuminate\\Http\\Request))\n#16 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1001): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))\n#17 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(775): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))\n#18 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(745): Illuminate\\Foundation\\Application->dispatch(Object(Illuminate\\Http\\Request))\n#19 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Session/Middleware.php(72): Illuminate\\Foundation\\Application->handle(Object(Illuminate\\Http\\Request), 1, true)\n#20 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Cookie/Queue.php(47): Illuminate\\Session\\Middleware->handle(Object(Illuminate\\Http\\Request), 1, true)\n#21 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Cookie/Guard.php(51): Illuminate\\Cookie\\Queue->handle(Object(Illuminate\\Http\\Request), 1, true)\n#22 /var/www/deliveryApi/backend/laravel/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Illuminate\\Cookie\\Guard->handle(Object(Illuminate\\Http\\Request), 1, true)\n#23 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(641): Stack\\StackedHttpKernel->handle(Object(Illuminate\\Http\\Request))\n#24 /var/www/deliveryApi/backend/laravel/public/index.php(49): Illuminate\\Foundation\\Application->run()\n#25 {main}\n\nNext exception 'Illuminate\\Database\\QueryException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nyctogo.RESTAURANT_GEOMETRY' doesn't exist (SQL: (SELECT\n\t\t \tR.RESTAURANT_ID,\n R.TAKE_OUT,\n R.DELIVERY,\n 3959*2*ASIN(SQRT(POWER(SIN((R.LATITUDE - 34.17751)*pi()/180/2),2)+COS(R.LATITUDE * pi()/180)*COS(34.17751 * pi()/180) * POWER(SIN((R.LONGITUDE - -118.30304) * pi()/180/2),2))) AS DISTANCE,\n DR.DELIVERY_RANGE_ID,\n DR.DELIVERY_CHARGE,\n DR.DELIVERY_PERCENT,\n DR.MIN_DELIVER AS MINIMUM_DELIVERY_AMOUNT,\n DR.RANGE_TYPE,\n DR.LMP,\n RMP.MINIMUM_ORDER_AMOUNT as MINIMUM_PICKUP_AMOUNT,\n\t\t \tTRUE AS IS_DELIVERY,\n\t\t \tFALSE AS IS_PICKUP\n\t\t FROM\n\t\t \tRESTAURANT R\n \t\tJOIN DELIVERY_RANGE DR ON (R.RESTAURANT_ID=DR.RESTAURANT_ID)\n \t\t\n \t\tLEFT JOIN RESTAURANT_MINIMUM_PICKUP RMP\n\t\t\t ON (R.RESTAURANT_ID = RMP.RESTAURANT_ID)\n\t\t WHERE\n\t\t \t\tR.LONGITUDE IS NOT NULL\n\t\t \tAND R.ACTIVE='Y'\n\t\t \tAND R.DELIVERY='Y'\n\t\t \t\n\t\t \tAND DR.DELIVERY_RANGE_ID IN (0,18924,19937543,25470291,422719,25346670,77332,77350,18923,25333936)\n \n \n\t\t ) UNION ALL (\n\t\t\t SELECT\n\t\t\t \tR.RESTAURANT_ID,\n R.TAKE_OUT,\n R.DELIVERY,\n 3959*2*ASIN(SQRT(POWER(SIN((R.LATITUDE - 34.17751)*pi()/180/2),2)+COS(R.LATITUDE * pi()/180)*COS(34.17751 * pi()/180) * POWER(SIN((R.LONGITUDE - -118.30304) * pi()/180/2),2))) AS DISTANCE,\n null as DELIVERY_RANGE_ID,\n null as DELIVERY_CHARGE,\n null as DELIVERY_PERCENT,\n null as MINIMUM_DELIVERY_AMOUNT,\n null as LMP,\n RMP.MINIMUM_ORDER_AMOUNT as MINIMUM_PICKUP_AMOUNT,\n null as RANGE_TYPE,\n\t\t\t \tFALSE AS IS_DELIVERY,\n\t\t\t \tTRUE AS IS_PICKUP\n\t\t\t FROM\n\t\t\t \tRESTAURANT R\n\t\t\t \t\n\t\t\t LEFT JOIN RESTAURANT_MINIMUM_PICKUP RMP\n\t\t\t ON (R.RESTAURANT_ID = RMP.RESTAURANT_ID)\n JOIN RESTAURANT_GEOMETRY RG ON (R.RESTAURANT_ID=RG.RESTAURANT_ID)\n\t\t\t WHERE\n\t\t\t MBRWithin(RG.GEOMETRY, GeomFromText('LINESTRING(34.083434 -118.416754, 34.271586 -118.189326)'))\n\t\t\t \t\n\t\t\t \tAND R.ACTIVE = 'Y'\n\t\t\t \tAND R.TAKE_OUT = 'Y'\n\t\t\t\tAND 6.5 > 3959*2*ASIN(SQRT(POWER(SIN((R.LATITUDE - 34.17751)*pi()/180/2),2)+COS(R.LATITUDE * pi()/180)*COS(34.17751 * pi()/180) * POWER(SIN((R.LONGITUDE - -118.30304) * pi()/180/2),2))) \n \n \n\t\t\t)\n\n )' in /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:625\nStack trace:\n#0 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(581): Illuminate\\Database\\Connection->runQueryCallback('(SELECT\\n\\t\\t \\tR....', Array, Object(Closure))\n#1 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(304): Illuminate\\Database\\Connection->run('(SELECT\\n\\t\\t \\tR....', Array, Object(Closure))\n#2 /var/www/deliveryApi/backend/laravel/vendor/dcom/lib-dcom/lib/DeliveryCoreLib/Merchant/Search/DcomSearchRangeSql.php(221): Illuminate\\Database\\Connection->select('(SELECT\\n\\t\\t \\tR....')\n#3 /var/www/deliveryApi/backend/laravel/vendor/dcom/lib-dcom/lib/DeliveryCoreLib/Merchant/Search/DcomSearchRangeSql.php(256): DeliveryCoreLib\\Merchant\\Search\\DcomSearchRangeSql->queryMerchantsInRange(Object(DeliveryCoreLib\\Address\\US\\Address))\n#4 /var/www/deliveryApi/backend/laravel/vendor/dcom/lib-dcom/lib/DeliveryCoreLib/Merchant/Search/DcomRepositoryNewOrderTime.php(116): DeliveryCoreLib\\Merchant\\Search\\DcomSearchRangeSql->getMerchantsInRange(Object(DeliveryCoreLib\\Address\\US\\Address))\n#5 /var/www/deliveryApi/backend/laravel/app/lib/Delivery/Packages/Search/Controllers/SearchController.php(139): DeliveryCoreLib\\Merchant\\Search\\DcomRepositoryNewOrderTime->findMerchantsInRange(Object(DeliveryCoreLib\\Address\\US\\Address))\n#6 [internal function]: Delivery\\Packages\\Search\\Controllers\\SearchController->getDeliverySearchResults()\n#7 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(231): call_user_func_array(Array, Array)\n#8 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(93): Illuminate\\Routing\\Controller->callAction('getDeliverySear...', Array)\n#9 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(62): Illuminate\\Routing\\ControllerDispatcher->call(Object(Delivery\\Packages\\Search\\Controllers\\SearchController), Object(Illuminate\\Routing\\Route), 'getDeliverySear...')\n#10 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(967): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request), '\\\\Delivery\\\\Packa...', 'getDeliverySear...')\n#11 [internal function]: Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()\n#12 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Routing/Route.php(109): call_user_func_array(Object(Closure), Array)\n#13 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1033): Illuminate\\Routing\\Route->run(Object(Illuminate\\Http\\Request))\n#14 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1001): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))\n#15 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(775): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))\n#16 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(745): Illuminate\\Foundation\\Application->dispatch(Object(Illuminate\\Http\\Request))\n#17 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Session/Middleware.php(72): Illuminate\\Foundation\\Application->handle(Object(Illuminate\\Http\\Request), 1, true)\n#18 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Cookie/Queue.php(47): Illuminate\\Session\\Middleware->handle(Object(Illuminate\\Http\\Request), 1, true)\n#19 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Cookie/Guard.php(51): Illuminate\\Cookie\\Queue->handle(Object(Illuminate\\Http\\Request), 1, true)\n#20 /var/www/deliveryApi/backend/laravel/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Illuminate\\Cookie\\Guard->handle(Object(Illuminate\\Http\\Request), 1, true)\n#21 /var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(641): Stack\\StackedHttpKernel->handle(Object(Illuminate\\Http\\Request))\n#22 /var/www/deliveryApi/backend/laravel/public/index.php(49): Illuminate\\Foundation\\Application->run()\n#23 {main}",
"trace": [
{
"file": "/var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php",
"line": 581,
"function": "runQueryCallback",
"class": "Illuminate\\Database\\Connection",
"type": "->",
"args": [
"(SELECT\n\t\t \tR.RESTAURANT_ID,\n R.TAKE_OUT,\n R.DELIVERY,\n 3959*2*ASIN(SQRT(POWER(SIN((R.LATITUDE - 34.17751)*pi()/180/2),2)+COS(R.LATITUDE * pi()/180)*COS(34.17751 * pi()/180) * POWER(SIN((R.LONGITUDE - -118.30304) * pi()/180/2),2))) AS DISTANCE,\n DR.DELIVERY_RANGE_ID,\n DR.DELIVERY_CHARGE,\n DR.DELIVERY_PERCENT,\n DR.MIN_DELIVER AS MINIMUM_DELIVERY_AMOUNT,\n DR.RANGE_TYPE,\n DR.LMP,\n RMP.MINIMUM_ORDER_AMOUNT as MINIMUM_PICKUP_AMOUNT,\n\t\t \tTRUE AS IS_DELIVERY,\n\t\t \tFALSE AS IS_PICKUP\n\t\t FROM\n\t\t \tRESTAURANT R\n \t\tJOIN DELIVERY_RANGE DR ON (R.RESTAURANT_ID=DR.RESTAURANT_ID)\n \t\t\n \t\tLEFT JOIN RESTAURANT_MINIMUM_PICKUP RMP\n\t\t\t ON (R.RESTAURANT_ID = RMP.RESTAURANT_ID)\n\t\t WHERE\n\t\t \t\tR.LONGITUDE IS NOT NULL\n\t\t \tAND R.ACTIVE='Y'\n\t\t \tAND R.DELIVERY='Y'\n\t\t \t\n\t\t \tAND DR.DELIVERY_RANGE_ID IN (0,18924,19937543,25470291,422719,25346670,77332,77350,18923,25333936)\n \n \n\t\t ) UNION ALL (\n\t\t\t SELECT\n\t\t\t \tR.RESTAURANT_ID,\n R.TAKE_OUT,\n R.DELIVERY,\n 3959*2*ASIN(SQRT(POWER(SIN((R.LATITUDE - 34.17751)*pi()/180/2),2)+COS(R.LATITUDE * pi()/180)*COS(34.17751 * pi()/180) * POWER(SIN((R.LONGITUDE - -118.30304) * pi()/180/2),2))) AS DISTANCE,\n null as DELIVERY_RANGE_ID,\n null as DELIVERY_CHARGE,\n null as DELIVERY_PERCENT,\n null as MINIMUM_DELIVERY_AMOUNT,\n null as LMP,\n RMP.MINIMUM_ORDER_AMOUNT as MINIMUM_PICKUP_AMOUNT,\n null as RANGE_TYPE,\n\t\t\t \tFALSE AS IS_DELIVERY,\n\t\t\t \tTRUE AS IS_PICKUP\n\t\t\t FROM\n\t\t\t \tRESTAURANT R\n\t\t\t \t\n\t\t\t LEFT JOIN RESTAURANT_MINIMUM_PICKUP RMP\n\t\t\t ON (R.RESTAURANT_ID = RMP.RESTAURANT_ID)\n JOIN RESTAURANT_GEOMETRY RG ON (R.RESTAURANT_ID=RG.RESTAURANT_ID)\n\t\t\t WHERE\n\t\t\t MBRWithin(RG.GEOMETRY, GeomFromText('LINESTRING(34.083434 -118.416754, 34.271586 -118.189326)'))\n\t\t\t \t\n\t\t\t \tAND R.ACTIVE = 'Y'\n\t\t\t \tAND R.TAKE_OUT = 'Y'\n\t\t\t\tAND 6.5 > 3959*2*ASIN(SQRT(POWER(SIN((R.LATITUDE - 34.17751)*pi()/180/2),2)+COS(R.LATITUDE * pi()/180)*COS(34.17751 * pi()/180) * POWER(SIN((R.LONGITUDE - -118.30304) * pi()/180/2),2))) \n \n \n\t\t\t)\n\n ",
[],
{}
]
},
{
"file": "/var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php",
"line": 304,
"function": "run",
"class": "Illuminate\\Database\\Connection",
"type": "->",
"args": [
"(SELECT\n\t\t \tR.RESTAURANT_ID,\n R.TAKE_OUT,\n R.DELIVERY,\n 3959*2*ASIN(SQRT(POWER(SIN((R.LATITUDE - 34.17751)*pi()/180/2),2)+COS(R.LATITUDE * pi()/180)*COS(34.17751 * pi()/180) * POWER(SIN((R.LONGITUDE - -118.30304) * pi()/180/2),2))) AS DISTANCE,\n DR.DELIVERY_RANGE_ID,\n DR.DELIVERY_CHARGE,\n DR.DELIVERY_PERCENT,\n DR.MIN_DELIVER AS MINIMUM_DELIVERY_AMOUNT,\n DR.RANGE_TYPE,\n DR.LMP,\n RMP.MINIMUM_ORDER_AMOUNT as MINIMUM_PICKUP_AMOUNT,\n\t\t \tTRUE AS IS_DELIVERY,\n\t\t \tFALSE AS IS_PICKUP\n\t\t FROM\n\t\t \tRESTAURANT R\n \t\tJOIN DELIVERY_RANGE DR ON (R.RESTAURANT_ID=DR.RESTAURANT_ID)\n \t\t\n \t\tLEFT JOIN RESTAURANT_MINIMUM_PICKUP RMP\n\t\t\t ON (R.RESTAURANT_ID = RMP.RESTAURANT_ID)\n\t\t WHERE\n\t\t \t\tR.LONGITUDE IS NOT NULL\n\t\t \tAND R.ACTIVE='Y'\n\t\t \tAND R.DELIVERY='Y'\n\t\t \t\n\t\t \tAND DR.DELIVERY_RANGE_ID IN (0,18924,19937543,25470291,422719,25346670,77332,77350,18923,25333936)\n \n \n\t\t ) UNION ALL (\n\t\t\t SELECT\n\t\t\t \tR.RESTAURANT_ID,\n R.TAKE_OUT,\n R.DELIVERY,\n 3959*2*ASIN(SQRT(POWER(SIN((R.LATITUDE - 34.17751)*pi()/180/2),2)+COS(R.LATITUDE * pi()/180)*COS(34.17751 * pi()/180) * POWER(SIN((R.LONGITUDE - -118.30304) * pi()/180/2),2))) AS DISTANCE,\n null as DELIVERY_RANGE_ID,\n null as DELIVERY_CHARGE,\n null as DELIVERY_PERCENT,\n null as MINIMUM_DELIVERY_AMOUNT,\n null as LMP,\n RMP.MINIMUM_ORDER_AMOUNT as MINIMUM_PICKUP_AMOUNT,\n null as RANGE_TYPE,\n\t\t\t \tFALSE AS IS_DELIVERY,\n\t\t\t \tTRUE AS IS_PICKUP\n\t\t\t FROM\n\t\t\t \tRESTAURANT R\n\t\t\t \t\n\t\t\t LEFT JOIN RESTAURANT_MINIMUM_PICKUP RMP\n\t\t\t ON (R.RESTAURANT_ID = RMP.RESTAURANT_ID)\n JOIN RESTAURANT_GEOMETRY RG ON (R.RESTAURANT_ID=RG.RESTAURANT_ID)\n\t\t\t WHERE\n\t\t\t MBRWithin(RG.GEOMETRY, GeomFromText('LINESTRING(34.083434 -118.416754, 34.271586 -118.189326)'))\n\t\t\t \t\n\t\t\t \tAND R.ACTIVE = 'Y'\n\t\t\t \tAND R.TAKE_OUT = 'Y'\n\t\t\t\tAND 6.5 > 3959*2*ASIN(SQRT(POWER(SIN((R.LATITUDE - 34.17751)*pi()/180/2),2)+COS(R.LATITUDE * pi()/180)*COS(34.17751 * pi()/180) * POWER(SIN((R.LONGITUDE - -118.30304) * pi()/180/2),2))) \n \n \n\t\t\t)\n\n ",
[],
{}
]
},
{
"file": "/var/www/deliveryApi/backend/laravel/vendor/dcom/lib-dcom/lib/DeliveryCoreLib/Merchant/Search/DcomSearchRangeSql.php",
"line": 221,
"function": "select",
"class": "Illuminate\\Database\\Connection",
"type": "->",
"args": [
"(SELECT\n\t\t \tR.RESTAURANT_ID,\n R.TAKE_OUT,\n R.DELIVERY,\n 3959*2*ASIN(SQRT(POWER(SIN((R.LATITUDE - 34.17751)*pi()/180/2),2)+COS(R.LATITUDE * pi()/180)*COS(34.17751 * pi()/180) * POWER(SIN((R.LONGITUDE - -118.30304) * pi()/180/2),2))) AS DISTANCE,\n DR.DELIVERY_RANGE_ID,\n DR.DELIVERY_CHARGE,\n DR.DELIVERY_PERCENT,\n DR.MIN_DELIVER AS MINIMUM_DELIVERY_AMOUNT,\n DR.RANGE_TYPE,\n DR.LMP,\n RMP.MINIMUM_ORDER_AMOUNT as MINIMUM_PICKUP_AMOUNT,\n\t\t \tTRUE AS IS_DELIVERY,\n\t\t \tFALSE AS IS_PICKUP\n\t\t FROM\n\t\t \tRESTAURANT R\n \t\tJOIN DELIVERY_RANGE DR ON (R.RESTAURANT_ID=DR.RESTAURANT_ID)\n \t\t\n \t\tLEFT JOIN RESTAURANT_MINIMUM_PICKUP RMP\n\t\t\t ON (R.RESTAURANT_ID = RMP.RESTAURANT_ID)\n\t\t WHERE\n\t\t \t\tR.LONGITUDE IS NOT NULL\n\t\t \tAND R.ACTIVE='Y'\n\t\t \tAND R.DELIVERY='Y'\n\t\t \t\n\t\t \tAND DR.DELIVERY_RANGE_ID IN (0,18924,19937543,25470291,422719,25346670,77332,77350,18923,25333936)\n \n \n\t\t ) UNION ALL (\n\t\t\t SELECT\n\t\t\t \tR.RESTAURANT_ID,\n R.TAKE_OUT,\n R.DELIVERY,\n 3959*2*ASIN(SQRT(POWER(SIN((R.LATITUDE - 34.17751)*pi()/180/2),2)+COS(R.LATITUDE * pi()/180)*COS(34.17751 * pi()/180) * POWER(SIN((R.LONGITUDE - -118.30304) * pi()/180/2),2))) AS DISTANCE,\n null as DELIVERY_RANGE_ID,\n null as DELIVERY_CHARGE,\n null as DELIVERY_PERCENT,\n null as MINIMUM_DELIVERY_AMOUNT,\n null as LMP,\n RMP.MINIMUM_ORDER_AMOUNT as MINIMUM_PICKUP_AMOUNT,\n null as RANGE_TYPE,\n\t\t\t \tFALSE AS IS_DELIVERY,\n\t\t\t \tTRUE AS IS_PICKUP\n\t\t\t FROM\n\t\t\t \tRESTAURANT R\n\t\t\t \t\n\t\t\t LEFT JOIN RESTAURANT_MINIMUM_PICKUP RMP\n\t\t\t ON (R.RESTAURANT_ID = RMP.RESTAURANT_ID)\n JOIN RESTAURANT_GEOMETRY RG ON (R.RESTAURANT_ID=RG.RESTAURANT_ID)\n\t\t\t WHERE\n\t\t\t MBRWithin(RG.GEOMETRY, GeomFromText('LINESTRING(34.083434 -118.416754, 34.271586 -118.189326)'))\n\t\t\t \t\n\t\t\t \tAND R.ACTIVE = 'Y'\n\t\t\t \tAND R.TAKE_OUT = 'Y'\n\t\t\t\tAND 6.5 > 3959*2*ASIN(SQRT(POWER(SIN((R.LATITUDE - 34.17751)*pi()/180/2),2)+COS(R.LATITUDE * pi()/180)*COS(34.17751 * pi()/180) * POWER(SIN((R.LONGITUDE - -118.30304) * pi()/180/2),2))) \n \n \n\t\t\t)\n\n "
]
},
{
"file": "/var/www/deliveryApi/backend/laravel/vendor/dcom/lib-dcom/lib/DeliveryCoreLib/Merchant/Search/DcomSearchRangeSql.php",
"line": 256,
"function": "queryMerchantsInRange",
"class": "DeliveryCoreLib\\Merchant\\Search\\DcomSearchRangeSql",
"type": "->",
"args": [
{
"street": "266 E Providencia Ave",
"neighborhood": null,
"city": "Burbank",
"sublocality": null,
"state": "CA",
"zip": "91502",
"exactMatch": true,
"unit": "Unit A"
}
]
},
{
"file": "/var/www/deliveryApi/backend/laravel/vendor/dcom/lib-dcom/lib/DeliveryCoreLib/Merchant/Search/DcomRepositoryNewOrderTime.php",
"line": 116,
"function": "getMerchantsInRange",
"class": "DeliveryCoreLib\\Merchant\\Search\\DcomSearchRangeSql",
"type": "->",
"args": [
{
"street": "266 E Providencia Ave",
"neighborhood": null,
"city": "Burbank",
"sublocality": null,
"state": "CA",
"zip": "91502",
"exactMatch": true,
"unit": "Unit A"
}
]
},
{
"file": "/var/www/deliveryApi/backend/laravel/app/lib/Delivery/Packages/Search/Controllers/SearchController.php",
"line": 139,
"function": "findMerchantsInRange",
"class": "DeliveryCoreLib\\Merchant\\Search\\DcomRepositoryNewOrderTime",
"type": "->",
"args": [
{
"street": "266 E Providencia Ave",
"neighborhood": null,
"city": "Burbank",
"sublocality": null,
"state": "CA",
"zip": "91502",
"exactMatch": true,
"unit": "Unit A"
}
]
},
{
"function": "getDeliverySearchResults",
"class": "Delivery\\Packages\\Search\\Controllers\\SearchController",
"type": "->",
"args": []
},
{
"file": "/var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Routing/Controller.php",
"line": 231,
"function": "call_user_func_array",
"args": [
[
{
"sqlWrapper": {
"pdo": {}
}
},
"getDeliverySearchResults"
],
[]
]
},
{
"file": "/var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php",
"line": 93,
"function": "callAction",
"class": "Illuminate\\Routing\\Controller",
"type": "->",
"args": [
"getDeliverySearchResults",
[]
]
},
{
"file": "/var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php",
"line": 62,
"function": "call",
"class": "Illuminate\\Routing\\ControllerDispatcher",
"type": "->",
"args": [
{
"sqlWrapper": {
"pdo": {}
}
},
{},
"getDeliverySearchResults"
]
},
{
"file": "/var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
"line": 967,
"function": "dispatch",
"class": "Illuminate\\Routing\\ControllerDispatcher",
"type": "->",
"args": [
{},
{
"attributes": {},
"request": {},
"query": {},
"server": {},
"files": {},
"cookies": {},
"headers": {}
},
"\\Delivery\\Packages\\Search\\Controllers\\SearchController",
"getDeliverySearchResults"
]
},
{
"function": "Illuminate\\Routing\\{closure}",
"class": "Illuminate\\Routing\\Router",
"type": "->",
"args": []
},
{
"file": "/var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"line": 109,
"function": "call_user_func_array",
"args": [
{},
[]
]
},
{
"file": "/var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
"line": 1033,
"function": "run",
"class": "Illuminate\\Routing\\Route",
"type": "->",
"args": [
{
"attributes": {},
"request": {},
"query": {},
"server": {},
"files": {},
"cookies": {},
"headers": {}
}
]
},
{
"file": "/var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
"line": 1001,
"function": "dispatchToRoute",
"class": "Illuminate\\Routing\\Router",
"type": "->",
"args": [
{
"attributes": {},
"request": {},
"query": {},
"server": {},
"files": {},
"cookies": {},
"headers": {}
}
]
},
{
"file": "/var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Application.php",
"line": 775,
"function": "dispatch",
"class": "Illuminate\\Routing\\Router",
"type": "->",
"args": [
{
"attributes": {},
"request": {},
"query": {},
"server": {},
"files": {},
"cookies": {},
"headers": {}
}
]
},
{
"file": "/var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Application.php",
"line": 745,
"function": "dispatch",
"class": "Illuminate\\Foundation\\Application",
"type": "->",
"args": [
{
"attributes": {},
"request": {},
"query": {},
"server": {},
"files": {},
"cookies": {},
"headers": {}
}
]
},
{
"file": "/var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Session/Middleware.php",
"line": 72,
"function": "handle",
"class": "Illuminate\\Foundation\\Application",
"type": "->",
"args": [
{
"attributes": {},
"request": {},
"query": {},
"server": {},
"files": {},
"cookies": {},
"headers": {}
},
1,
true
]
},
{
"file": "/var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Cookie/Queue.php",
"line": 47,
"function": "handle",
"class": "Illuminate\\Session\\Middleware",
"type": "->",
"args": [
{
"attributes": {},
"request": {},
"query": {},
"server": {},
"files": {},
"cookies": {},
"headers": {}
},
1,
true
]
},
{
"file": "/var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Cookie/Guard.php",
"line": 51,
"function": "handle",
"class": "Illuminate\\Cookie\\Queue",
"type": "->",
"args": [
{
"attributes": {},
"request": {},
"query": {},
"server": {},
"files": {},
"cookies": {},
"headers": {}
},
1,
true
]
},
{
"file": "/var/www/deliveryApi/backend/laravel/vendor/stack/builder/src/Stack/StackedHttpKernel.php",
"line": 23,
"function": "handle",
"class": "Illuminate\\Cookie\\Guard",
"type": "->",
"args": [
{
"attributes": {},
"request": {},
"query": {},
"server": {},
"files": {},
"cookies": {},
"headers": {}
},
1,
true
]
},
{
"file": "/var/www/deliveryApi/backend/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Application.php",
"line": 641,
"function": "handle",
"class": "Stack\\StackedHttpKernel",
"type": "->",
"args": [
{
"attributes": {},
"request": {},
"query": {},
"server": {},
"files": {},
"cookies": {},
"headers": {}
}
]
},
{
"file": "/var/www/deliveryApi/backend/laravel/public/index.php",
"line": 49,
"function": "run",
"class": "Illuminate\\Foundation\\Application",
"type": "->",
"args": []
}
],
"human_id": 1713274
}
}
]
}
Wayne Cheng
Nov 23, 2016, 8:02:16 PM11/23/16
to deliverydotcom API V2
Hi,
This should be fixed now. Please try again.
This should be fixed now. Please try again.
gregory hutchinson
Nov 24, 2016, 6:49:19 PM11/24/16
to deliverydotcom API V2
confirmed, fixed. thank you!
Reply all
Reply to author
Forward
0 new messages