PHP Category::whereRaw方法代码示例

 /**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function index()
 {
     if (!Input::has('typeId')) {
         return redirect()->route('dashboard.category.index', ['typeId' => 1]);
     }
     $typeId = Input::get('typeId');
     $assign['categorys'] = $this->Category->whereRaw('parent_id = 0 and type_id = ' . $typeId)->orderByRaw('weight asc, id asc')->get();
     return view('dashboard.category.index', $assign);
 }

 public function index(Request $request)
 {
     $search = \Request::get('search');
     //<-- we use global request to get the param of URI
     if ($search) {
         $allCategory = Category::whereRaw('category_name = ?', [$search])->orderBy('id', 'asc')->paginate(5);
     } else {
         $allCategory = Category::orderBy('id', 'asc')->paginate(5);
     }
     return view('Category.index', ['Categories' => $allCategory]);
 }

 public function affiche($id)
 {
     $title = "voiture";
     $options = $idCategries = array();
     $customers = array();
     $customer = Customer::all();
     foreach ($customer as $c) {
         $customers[$c->id] = $c->name . ' ' . $c->last_name;
     }
     if (isset($id) && !empty($id)) {
         $car = Car::findOrFail($id);
         $options = current($car->optioncars()->lists('option_id'));
         if (!empty($options)) {
             $ids = implode(",", $options);
             //option ID's
             $prices = OptionCar::whereRaw('option_id  in (' . $ids . ' ) and car_id=' . $id . ' order by option_id')->get();
             foreach ($prices as $price) {
                 $prices_car[$price->option_id]['price'] = $price->option_price;
                 $prices_car[$price->option_id]['id'] = $price->id;
             }
             $optionsList = Option::whereRaw('id  in (' . $ids . ' ) order by id')->get();
             foreach ($optionsList as $option) {
                 $el = $option->category_id;
                 if (!in_array($el, $idCategries)) {
                     //if not exist in array
                     array_push($idCategries, $el);
                 }
             }
             $idCategries = implode(",", $idCategries);
             $categories = Category::whereRaw('id  in (' . $idCategries . ')')->get();
             foreach ($categories as $cat) {
                 foreach ($optionsList as $option) {
                     if ($option['category_id'] == $cat['id']) {
                         $listcategories[$cat->id]['name'] = $cat->name_category;
                         $listcategories[$cat->id]['options'][$option->id]['name'] = $option->name;
                         $listcategories[$cat->id]['options'][$option->id]['description'] = $option->description;
                         $listcategories[$cat->id]['options'][$option->id]['price'] = $prices_car[$option->id]['price'];
                         $listcategories[$cat->id]['options'][$option->id]['id'] = $prices_car[$option->id]['id'];
                     }
                 }
             }
             return view('Cars/car-details', ['categories' => $listcategories, 'title' => $title, 'car' => $car, 'customers' => $customers]);
         } else {
             return view('Cars/car-details', ['categories' => null, 'car' => $car, 'title' => $title]);
         }
     }
 }

 public function getSlug($title, $allow_overlap = true)
 {
     $slug = str_slug($title);
     $slugCount = count(Category::whereRaw("slug REGEXP '^{$slug}(-[0-9]*)?\$'")->get());
     if ($allow_overlap == false) {
         return $slugCount > 0 ? false : $slug;
     } else {
         return $slugCount > 0 ? "{$slug}-{$slugCount}" : $slug;
     }
 }

 public function getCategoriesFront($id_car)
 {
     //$car=Car::where('id',$id_car)->get();
     $idCategries = array();
     $car = Car::findOrFail($id_car);
     $options = current($car->optioncars()->lists('option_id'));
     if (!empty($options)) {
         $ids = implode(",", $options);
         //option ID's
         $prices = OptionCar::whereRaw('option_id  in (' . $ids . ' ) and car_id=' . $id_car . ' order by option_id')->get();
         foreach ($prices as $price) {
             $prices_car[$price->option_id]['price'] = $price->option_price;
             $prices_car[$price->option_id]['id'] = $price->id;
         }
         $optionsList = Option::whereRaw('id  in (' . $ids . ' ) order by id')->get();
         foreach ($optionsList as $option) {
             $el = $option->category_id;
             if (!in_array($el, $idCategries)) {
                 //if not exist in array
                 array_push($idCategries, $el);
             }
         }
         $idCategries = implode(",", $idCategries);
         $categories = Category::whereRaw('id  in (' . $idCategries . ')')->get();
         foreach ($categories as $cat) {
             foreach ($optionsList as $option) {
                 if ($option['category_id'] == $cat['id']) {
                     $listcategories[$cat->id]['name'] = $cat->name_category;
                     $listcategories[$cat->id]['icone'] = $cat->icon;
                     $listcategories[$cat->id]['options'][$option->id]['name'] = $option->name;
                     $listcategories[$cat->id]['options'][$option->id]['description'] = $option->description;
                     $listcategories[$cat->id]['options'][$option->id]['price'] = $prices_car[$option->id]['price'];
                     $listcategories[$cat->id]['options'][$option->id]['id'] = $prices_car[$option->id]['id'];
                 }
             }
         }
         return $listcategories;
     }
 }