Beispiel #1
0
 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;
 }
Beispiel #2
0
    }
});
$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);
    }
});
Beispiel #3
0
 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";
 }