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);
}
public function postNewSubCat()
{
$dat = Input::all();
$rules = array('name' => 'required|min:4|max:64', 'cat' => 'required');
$msg = array('name.required' => 'El campo nombre de la categoria es obligatorio', 'categoria.required' => 'El campo categoria es obligatorio', 'min' => 'El campo nombre de la categoria debe tener un minimo de 4 caracteres', 'max' => 'El campo nombre de la categoria debe tener un maximo de 64 caracteres');
$validator = Validator::make($dat, $rules, $msg);
if ($validator->fails()) {
return Redirect::back()->withErrors($validator);
}
$nomb = Input::get('name');
$cat_id = Input::get('cat');
$cat = new SubCat();
$cat->desc = $nomb;
$cat->categoria_id = $cat_id;
if ($cat->save()) {
Session::flash('success', 'Se ha creado la sub-categoria satisfactoriamente.');
return Redirect::back();
} else {
Session::flash('danger', 'Error al guardar la nueva sub-categoria.');
return Redirect::back();
}
}
/**
* Update the specified resource in storage.
*
* @param Request $request
* @param int $id
* @return Response
*/
public function update(Request $request, $id)
{
$biz = Biz::findorFail($id);
$cat = $biz->cats->lists('id')->all();
$sub = $biz->subcats->lists('id')->all();
// dd($sub);
$catList = Cat::lists('name', 'id');
$subList = SubCat::lists('name', 'id');
// dd($subList);
$stateList = State::lists('name', 'id');
$lgaList = Lga::lists('name', 'id');
//$area= Address::lists
//dd($biz->address->state->name);
// foreach ($biz->subcats as $sub) {
// $currentSubs[] = $sub->id;
// }
// if(empty($currentSubs)){
// $currentSubs = '';
// }
return view('admin/biz/edit', compact('biz', 'catList', 'subList', 'stateList', 'cat', 'currentSubs', 'lgaList', 'sub'));
}
public function postElimSubCat()
{
if (Request::ajax()) {
$id = Input::get('id');
$subcat = SubCat::find($id);
$subcat->deleted = 1;
$subcat->save();
return Response::json(array('type' => 'success', 'msg' => 'Categoría eliminada correctamente'));
}
}
