/**
* @param Category $except
*
* @return CategoriesController
*/
protected function getCategoryOptions($except = null)
{
/** @var \Kalnoy\Nestedset\QueryBuilder $query */
$query = Category::select('id', 'category_name')->withDepth();
if ($except) {
$query->whereNotDescendantOf($except)->where('id', '<>', $except->id);
}
return $this->makeOptions($query->get());
}
/**
* Generate the Data File for de DataTables of Category.
*
* @return Datatable
*/
public function data()
{
$categories = Category::select(array('categories.Category', 'categories.id'));
return Datatables::of($categories)->add_column('actions', '
<div class="btn-group">
<a target="_blank" class="btn btn-xs btn-primary" data-categoria={{{ $Category }}} data-categoria_id={{{ $id }}}
<i class="fa fa-pencil"></i>Ver Conceptos</a>
</div>
')->remove_column('id')->make(true);
}
public function post_update($locale, $id)
{
$advertisement = Advertisement::where('published', 1)->where('id', $id)->first();
if (!$advertisement || Auth::user()->id != $advertisement->user_id) {
abort(404);
}
$input = Input::all();
$validator = Validator::make($input, $this->rules);
if ($validator->fails()) {
return redirect()->back()->with('error', $validator->errors()->all())->withInput();
}
$advertisement->title = $input['title'];
$advertisement->category_id = $input['category'];
$advertisement->description = $input['description'];
$advertisement->user_id = Auth::user()->id;
$slug = Slug::make($advertisement->id . '-' . $advertisement->title);
$advertisement->url = $slug;
$advertisement->save();
$category = Category::select('url')->where('id', $advertisement->category_id)->first()->url;
return redirect()->route('advertisement', ['locale' => $locale, 'category' => $category, 'url' => $slug])->with('success', trans('message.advertisement_update'));
}
/**
* Display setting store page
*
* @return response
*/
public function store()
{
$cities = select(City::select('id', 'name')->get());
$districts = ['' => _t('select_district')];
$wards = ['' => _t('select_ward')];
$categories = select(Category::select('id', 'name')->get());
$store = store();
if (user()->store !== null) {
$districts += select($this->_getDistrictsByCityId($store->city_id)->keyBy('id'));
$wards += select($this->_getWardsByCityId($store->district_id)->keyBy('id'));
}
return view('frontend::setting.store', ['categories' => ['' => _t('select_category')] + $categories, 'cities' => ['' => _t('select_city')] + $cities, 'districts' => $districts, 'wards' => $wards, 'store' => $store]);
}