123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228 |
- <?php
- namespace App\Http\Controllers;
- use Illuminate\Http\Request;
- use App\Models\Category;
- use App\Models\Product;
- use App\Models\CategoryTranslation;
- use App\Utility\CategoryUtility;
- use Illuminate\Support\Str;
- use Cache;
- class CategoryController extends Controller
- {
- /**
- * Display a listing of the resource.
- *
- * @return \Illuminate\Http\Response
- */
- public function index(Request $request)
- {
- $sort_search =null;
- $categories = Category::orderBy('order_level', 'desc');
- if ($request->has('search')){
- $sort_search = $request->search;
- $categories = $categories->where('name', 'like', '%'.$sort_search.'%');
- }
- $categories = $categories->paginate(15);
- return view('backend.product.categories.index', compact('categories', 'sort_search'));
- }
- /**
- * Show the form for creating a new resource.
- *
- * @return \Illuminate\Http\Response
- */
- public function create()
- {
- $categories = Category::where('parent_id', 0)
- ->with('childrenCategories')
- ->get();
- return view('backend.product.categories.create', compact('categories'));
- }
- /**
- * Store a newly created resource in storage.
- *
- * @param \Illuminate\Http\Request $request
- * @return \Illuminate\Http\Response
- */
- public function store(Request $request)
- {
- $category = new Category;
- $category->name = $request->name;
- $category->order_level = 0;
- if($request->order_level != null) {
- $category->order_level = $request->order_level;
- }
- $category->digital = $request->digital;
- $category->banner = $request->banner;
- $category->icon = $request->icon;
- $category->meta_title = $request->meta_title;
- $category->meta_description = $request->meta_description;
- if ($request->parent_id != "0") {
- $category->parent_id = $request->parent_id;
- $parent = Category::find($request->parent_id);
- $category->level = $parent->level + 1 ;
- }
- if ($request->slug != null) {
- $category->slug = preg_replace('/[^A-Za-z0-9\-]/', '', str_replace(' ', '-', $request->slug));
- }
- else {
- $category->slug = preg_replace('/[^A-Za-z0-9\-]/', '', str_replace(' ', '-', $request->name)).'-'.Str::random(5);
- }
- if ($request->commision_rate != null) {
- $category->commision_rate = $request->commision_rate;
- }
- $category->save();
- $category->attributes()->sync($request->filtering_attributes);
- $category_translation = CategoryTranslation::firstOrNew(['lang' => env('DEFAULT_LANGUAGE'), 'category_id' => $category->id]);
- $category_translation->name = $request->name;
- $category_translation->save();
- flash(translate('Category has been inserted successfully'))->success();
- return redirect()->route('categories.index');
- }
- /**
- * Display the specified resource.
- *
- * @param int $id
- * @return \Illuminate\Http\Response
- */
- public function show($id)
- {
- //
- }
- /**
- * Show the form for editing the specified resource.
- *
- * @param int $id
- * @return \Illuminate\Http\Response
- */
- public function edit(Request $request, $id)
- {
- $lang = $request->lang;
- $category = Category::findOrFail($id);
- $categories = Category::where('parent_id', 0)
- ->with('childrenCategories')
- ->whereNotIn('id', CategoryUtility::children_ids($category->id, true))->where('id', '!=' , $category->id)
- ->orderBy('name','asc')
- ->get();
- return view('backend.product.categories.edit', compact('category', 'categories', 'lang'));
- }
- /**
- * Update the specified resource in storage.
- *
- * @param \Illuminate\Http\Request $request
- * @param int $id
- * @return \Illuminate\Http\Response
- */
- public function update(Request $request, $id)
- {
- $category = Category::findOrFail($id);
- if($request->lang == env("DEFAULT_LANGUAGE")){
- $category->name = $request->name;
- }
- if($request->order_level != null) {
- $category->order_level = $request->order_level;
- }
- $category->digital = $request->digital;
- $category->banner = $request->banner;
- $category->icon = $request->icon;
- $category->meta_title = $request->meta_title;
- $category->meta_description = $request->meta_description;
- $previous_level = $category->level;
- if ($request->parent_id != "0") {
- $category->parent_id = $request->parent_id;
- $parent = Category::find($request->parent_id);
- $category->level = $parent->level + 1 ;
- }
- else{
- $category->parent_id = 0;
- $category->level = 0;
- }
- if($category->level > $previous_level){
- CategoryUtility::move_level_down($category->id);
- }
- elseif ($category->level < $previous_level) {
- CategoryUtility::move_level_up($category->id);
- }
- if ($request->slug != null) {
- $category->slug = strtolower($request->slug);
- }
- else {
- $category->slug = preg_replace('/[^A-Za-z0-9\-]/', '', str_replace(' ', '-', $request->name)).'-'.Str::random(5);
- }
- if ($request->commision_rate != null) {
- $category->commision_rate = $request->commision_rate;
- }
- $category->save();
- $category->attributes()->sync($request->filtering_attributes);
- $category_translation = CategoryTranslation::firstOrNew(['lang' => $request->lang, 'category_id' => $category->id]);
- $category_translation->name = $request->name;
- $category_translation->save();
- Cache::forget('featured_categories');
- flash(translate('Category has been updated successfully'))->success();
- return back();
- }
- /**
- * Remove the specified resource from storage.
- *
- * @param int $id
- * @return \Illuminate\Http\Response
- */
- public function destroy($id)
- {
- $category = Category::findOrFail($id);
- $category->attributes()->detach();
- // Category Translations Delete
- foreach ($category->category_translations as $key => $category_translation) {
- $category_translation->delete();
- }
- foreach (Product::where('category_id', $category->id)->get() as $product) {
- $product->category_id = null;
- $product->save();
- }
- CategoryUtility::delete_category($id);
- Cache::forget('featured_categories');
- flash(translate('Category has been deleted successfully'))->success();
- return redirect()->route('categories.index');
- }
- public function updateFeatured(Request $request)
- {
- $category = Category::findOrFail($request->id);
- $category->featured = $request->status;
- $category->save();
- Cache::forget('featured_categories');
- return 1;
- }
- }
|