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);
}
public function getNewMisc($id)
{
$title = "Nueva Caracteristica";
$item = Items::find($id);
$misc = Misc::where('item_id', '=', $item->id)->get();
$item->misc = $misc;
$cat = Cat::where('deleted', '=', 0)->get();
$tallas = Tallas::where('deleted', '=', 0)->get();
$colors = Colores::where('deleted', '=', 0)->get();
return View::make('admin.newMisc')->with('title', $title)->with('item', $item)->with('cat', $cat)->with('tallas', $tallas)->with('colores', $colors);
}
