PHP app\models Product::query Examples

Example #1

File: Product.php Project: sebalb/shopapp

 public function show($id)
 {
     $product = \App\Models\Product::query()->with(['seller' => function ($q) {
         $q->select('id', 'username');
     }, 'categories'])->find($id);
     if ($userAuth = \Auth::user()) {
         \App\Models\Product::setFavourites(collect([$product]), $userAuth);
     }
     return $product ?: $this->notFoundJson();
 }

Example #2

File: ProductRepository.php Project: fredery777/siloginventario

 public function search($input)
 {
     $query = Product::query();
     $columns = Schema::getColumnListing('products');
     $attributes = array();
     foreach ($columns as $attribute) {
         if (isset($input[$attribute]) and !empty($input[$attribute])) {
             $query->where($attribute, $input[$attribute]);
             $attributes[$attribute] = $input[$attribute];
         } else {
             $attributes[$attribute] = null;
         }
     }
     return [$query->get(), $attributes];
 }

Example #3

File: ProductController.php Project: asleao/LumenExperience

 public function view($id)
 {
     return Product::query()->find($id);
 }