public static function getByUser($userId, $page) { $result = Capsule::table(Comment::TABLE_NAME)->where('userId', '=', $userId)->orderBy('date', 'desc')->skip(10 * ($page - 1))->take(10)->get(); foreach ($result as $item) { $item->promo = Promo::query()->where('id', '=', $item->promoId)->first(['id', 'title', 'thumbnail']); unset($item->promoId); } return $result; }
} }); $app->get('/promo-detail/{id}', function (Request $request, Response $response, $id) { try { $promo = Promo::getById($id); if ($promo == null) { throw new Exception("Data not found!"); } return ResultWrapper::getResult($promo, $response); } catch (Exception $e) { return ResultWrapper::getError($e->getMessage(), $response); } }); $app->get('/search/{keyword}/{page}', function (Request $request, Response $response, $keyword, $page) { try { $promos = Promo::search($keyword, $page); if ($promos == null) { throw new Exception("Data not found!"); } return ResultWrapper::getResult($promos, $response); } catch (Exception $e) { return ResultWrapper::getError($e->getMessage(), $response); } }); $app->get('/category', function (Request $request, Response $response) { try { return ResultWrapper::getResult(Category::all(), $response); } catch (Exception $e) { return ResultWrapper::getError($e->getMessage(), $response); } });
public static function fillDescriptionPromo() { $i = 0; foreach (Capsule::table(Promo::TABLE_NAME)->where('fullDescription', '=', '')->limit(3)->get() as $item) { $promo = Promo::find($item->id); $desc = Scraper::scrapDetailPromoWithId($promo->id); $promo->fullDescription = $desc; $promo->save(); if ($desc != '') { $i++; } } return "Filled {$i} Promos"; }