public function postCatSubCat() { if (Request::ajax()) { $id = Input::get('id'); $subcat = SubCat::where('cat_id', '=', $id)->where('deleted', '=', 0)->get(); return $subcat; } }
public function getSubCat() { if (Request::ajax()) { $id = Input::get('id'); $subCat = SubCat::where('categoria_id', '=', $id)->get(); return $subCat; } }
public function getSubCategory() { $id = Input::get('cat_id'); $subCat = SubCat::where('categoria_id', '=', $id)->where('deleted', '=', 0)->orderBy('desc')->get(); return Response::json(array('type' => 'success', 'data' => $subCat)); }
public function search() { $busq = Input::get('busq'); $title = "Busqueda: " . $busq; $cat = Cat::where('deleted', '=', 0)->get(array('categorias.id', 'categorias.cat_nomb')); $subcat = array(); foreach ($cat as $c) { $aux = SubCat::where('cat_id', '=', $c->id)->where('deleted', '=', 0)->get(); $subcat[$c->id] = $aux->toArray(); } $art = DB::select("SELECT DISTINCT `item`.`id`,\t\n\t\t\t\t\t\t\t\t\t\t `item`.`item_nomb`,\n\t\t\t\t\t\t\t\t\t\t `item`.`item_cod`,\n\t\t\t\t\t\t\t\t\t\t `item`.`item_stock`,\n\t\t\t\t\t\t\t\t\t\t `item`.`item_precio`,\n\t\t\t\t\t\t\t\t\t\t `m`.`id` AS misc_id,\n\t\t\t\t\t\t\t\t\t\t `i`.`image`\n\t\t\tFROM `item` \n\t\t\tLEFT JOIN `miscelanias` AS m ON `m`.`item_id` = `item`.`id` \n\t\t\tLEFT JOIN `images` \t AS i ON `i`.`misc_id` = `m`.`id`\n\t\t\tLEFT JOIN `tallas` AS t ON `m`.`item_talla`=`t`.`id`\n\t\t\tLEFT JOIN `colores` \t AS c ON `m`.`item_color`=`c`.`id`\n\t\t\tWHERE (\n\t\t\t\tLOWER( `item`.`item_nomb` ) LIKE '%" . strtolower($busq) . "%' OR\n\t\t\t\tLOWER( `item`.`item_desc` ) LIKE '%" . strtolower($busq) . "%' OR\n\t\t\t\tLOWER( `item`.`item_precio` ) LIKE '%" . strtolower($busq) . "%' OR\n\t\t\t\tLOWER( `t`.`talla_desc` ) LIKE '%" . strtolower($busq) . "%' OR\n\t\t\t\tLOWER( `t`.`talla_nomb` ) LIKE '%" . strtolower($busq) . "%' OR\n\t\t\t\tLOWER( `c`.`color_nomb` ) LIKE '%" . strtolower($busq) . "%' OR\n\t\t\t\tLOWER( `c`.`color_desc` ) LIKE '%" . strtolower($busq) . "%'\n\t\t\t)\n\t\t\tAND `item`.`deleted` = 0\n\t\t\tGROUP BY item.id\n\t\t\t"); return View::make('indexs.busq')->with('title', $title)->with('art', $art)->with('cat', $cat)->with('subcat', $subcat)->with('busq', $busq); }