✏️ Edit: ProductController.php
Path:
/home/thiqat5/tmphone.thiqatech.com/tm/app/Http/Controllers/Admin/ProductController.php
Size: 24 KB · Modified: 2021-11-17 23:00:14 · Perm: 0644 · Writable
← Back to directory
👁 View
⬇ Download
<?php namespace App\Http\Controllers\Admin; use App\CentralLogics\Helpers; use App\Http\Controllers\Controller; use App\Model\Category; use App\Model\Order; use App\Model\Product; use App\Model\Review; use App\Model\Translation; use Brian2694\Toastr\Facades\Toastr; use Illuminate\Http\Request; use Illuminate\Support\Facades\DB; use Illuminate\Support\Facades\Storage; use Illuminate\Support\Facades\Validator; use Illuminate\Support\Str; use Rap2hpoutre\FastExcel\FastExcel; class ProductController extends Controller { public function variant_combination(Request $request) { $options = []; $price = $request->price; $product_name = $request->name; if ($request->has('choice_no')) { foreach ($request->choice_no as $key => $no) { $name = 'choice_options_' . $no; $my_str = implode('', $request[$name]); array_push($options, explode(',', $my_str)); } } $result = [[]]; foreach ($options as $property => $property_values) { $tmp = []; foreach ($result as $result_item) { foreach ($property_values as $property_value) { $tmp[] = array_merge($result_item, [$property => $property_value]); } } $result = $tmp; } $combinations = $result; return response()->json([ 'view' => view('admin-views.product.partials._variant-combinations', compact('combinations', 'price', 'product_name'))->render(), ]); } public function get_categories(Request $request) { $cat = Category::where(['parent_id' => $request->parent_id])->get(); $res = '<option value="' . 0 . '" disabled selected>---Select---</option>'; foreach ($cat as $row) { if ($row->id == $request->sub_category) { $res .= '<option value="' . $row->id . '" selected >' . $row->name . '</option>'; } else { $res .= '<option value="' . $row->id . '">' . $row->name . '</option>'; } } return response()->json([ 'options' => $res, ]); } public function index() { $categories = Category::where(['position' => 0])->get(); return view('admin-views.product.index', compact('categories')); } public function list(Request $request) { $query_param = []; $search = $request['search']; if ($request->has('search')) { $key = explode(' ', $request['search']); $query = Product::where(function ($q) use ($key) { foreach ($key as $value) { $q->orWhere('id', 'like', "%{$value}%") ->orWhere('name', 'like', "%{$value}%"); } })->latest(); $query_param = ['search' => $request['search']]; } else { $query = Product::latest(); } $products = $query->paginate(Helpers::pagination_limit())->appends($query_param); return view('admin-views.product.list', compact('products', 'search')); } public function search(Request $request) { $key = explode(' ', $request['search']); $products = Product::where(function ($q) use ($key) { foreach ($key as $value) { $q->orWhere('name', 'like', "%{$value}%"); } })->get(); return response()->json([ 'view' => view('admin-views.product.partials._table', compact('products'))->render() ]); } public function view($id) { $product = Product::where(['id' => $id])->first(); $reviews = Review::where(['product_id' => $id])->latest()->paginate(Helpers::pagination_limit()); return view('admin-views.product.view', compact('product', 'reviews')); } public function store(Request $request) { $validator = Validator::make($request->all(), [ 'name' => 'required|unique:products', 'category_id' => 'required', 'images' => 'required', 'total_stock' => 'required|numeric|min:1', 'price' => 'required|numeric|min:1', ], [ 'name.required' => 'Product name is required!', 'category_id.required' => 'category is required!', ]); if ($request['discount_type'] == 'percent') { $dis = ($request['price'] / 100) * $request['discount']; } else { $dis = $request['discount']; } if ($request['price'] <= $dis) { $validator->getMessageBag()->add('unit_price', 'Discount can not be more or equal to the price!'); } $img_names = []; if (!empty($request->file('images'))) { foreach ($request->images as $img) { $image_data = Helpers::upload('product/', 'png', $img); array_push($img_names, $image_data); } $image_data = json_encode($img_names); } else { $image_data = json_encode([]); } $p = new Product; $p->name = $request->name[array_search('en', $request->lang)]; $category = []; if ($request->category_id != null) { array_push($category, [ 'id' => $request->category_id, 'position' => 1, ]); } if ($request->sub_category_id != null) { array_push($category, [ 'id' => $request->sub_category_id, 'position' => 2, ]); } if ($request->sub_sub_category_id != null) { array_push($category, [ 'id' => $request->sub_sub_category_id, 'position' => 3, ]); } $p->category_ids = json_encode($category); $p->description = $request->description[array_search('en', $request->lang)]; $choice_options = []; if ($request->has('choice')) { foreach ($request->choice_no as $key => $no) { $str = 'choice_options_' . $no; if ($request[$str][0] == null) { $validator->getMessageBag()->add('name', 'Attribute choice option values can not be null!'); return response()->json(['errors' => Helpers::error_processor($validator)]); } $item['name'] = 'choice_' . $no; $item['title'] = $request->choice[$key]; $item['options'] = explode(',', implode('|', preg_replace('/\s+/', ' ', $request[$str]))); array_push($choice_options, $item); } } $p->choice_options = json_encode($choice_options); $variations = []; $options = []; if ($request->has('choice_no')) { foreach ($request->choice_no as $key => $no) { $name = 'choice_options_' . $no; $my_str = implode('|', $request[$name]); array_push($options, explode(',', $my_str)); } } //Generates the combinations of customer choice options $combinations = Helpers::combinations($options); $stock_count = 0; if (count($combinations[0]) > 0) { foreach ($combinations as $key => $combination) { $str = ''; foreach ($combination as $k => $item) { if ($k > 0) { $str .= '-' . str_replace(' ', '', $item); } else { $str .= str_replace(' ', '', $item); } } $item = []; $item['type'] = $str; $item['price'] = abs($request['price_' . str_replace('.', '_', $str)]); $item['stock'] = abs($request['stock_' . str_replace('.', '_', $str)]); array_push($variations, $item); $stock_count += $item['stock']; } } else { $stock_count = (integer)$request['total_stock']; } if ((integer)$request['total_stock'] != $stock_count) { $validator->getMessageBag()->add('total_stock', 'Stock calculation mismatch!'); } if ($validator->getMessageBag()->count() > 0) { return response()->json(['errors' => Helpers::error_processor($validator)]); } //combinations end $p->variations = json_encode($variations); $p->price = $request->price; $p->unit = $request->unit; $p->image = $image_data; // $p->set_menu = $request->item_type; $p->tax = $request->tax_type == 'amount' ? $request->tax : $request->tax; $p->tax_type = $request->tax_type; $p->discount = $request->discount_type == 'amount' ? $request->discount : $request->discount; $p->discount_type = $request->discount_type; $p->total_stock = $request->total_stock; $p->attributes = $request->has('attribute_id') ? json_encode($request->attribute_id) : json_encode([]); $p->save(); $data = []; foreach ($request->lang as $index => $key) { if ($request->name[$index] && $key != 'en') { array_push($data, array( 'translationable_type' => 'App\Model\Product', 'translationable_id' => $p->id, 'locale' => $key, 'key' => 'name', 'value' => $request->name[$index], )); } if ($request->description[$index] && $key != 'en') { array_push($data, array( 'translationable_type' => 'App\Model\Product', 'translationable_id' => $p->id, 'locale' => $key, 'key' => 'description', 'value' => $request->description[$index], )); } } Translation::insert($data); return response()->json([], 200); } public function edit($id) { $product = Product::withoutGlobalScopes()->with('translations')->find($id); $product_category = json_decode($product->category_ids); $categories = Category::where(['parent_id' => 0])->get(); return view('admin-views.product.edit', compact('product', 'product_category', 'categories')); } public function status(Request $request) { $product = Product::find($request->id); $product->status = $request->status; $product->save(); Toastr::success('Product status updated!'); return back(); } public function update(Request $request, $id) { $validator = Validator::make($request->all(), [ 'name' => 'required', 'category_id' => 'required', 'total_stock' => 'required|numeric|min:1', 'price' => 'required|numeric|min:1', ], [ 'name.required' => 'Product name is required!', 'category_id.required' => 'category is required!', ]); if ($request['discount_type'] == 'percent') { $dis = ($request['price'] / 100) * $request['discount']; } else { $dis = $request['discount']; } if ($request['price'] <= $dis) { $validator->getMessageBag()->add('unit_price', 'Discount can not be more or equal to the price!'); } $p = Product::find($id); $images = json_decode($p->image); if (!empty($request->file('images'))) { foreach ($request->images as $img) { $image_data = Helpers::upload('product/', 'png', $img); array_push($images, $image_data); } } if (!count($images)) { $validator->getMessageBag()->add('images', 'Image can not be empty!'); } $p->name = $request->name[array_search('en', $request->lang)]; $category = []; if ($request->category_id != null) { array_push($category, [ 'id' => $request->category_id, 'position' => 1, ]); } if ($request->sub_category_id != null) { array_push($category, [ 'id' => $request->sub_category_id, 'position' => 2, ]); } if ($request->sub_sub_category_id != null) { array_push($category, [ 'id' => $request->sub_sub_category_id, 'position' => 3, ]); } $p->category_ids = json_encode($category); $p->description = $request->description[array_search('en', $request->lang)]; $choice_options = []; if ($request->has('choice')) { foreach ($request->choice_no as $key => $no) { $str = 'choice_options_' . $no; if ($request[$str][0] == null) { $validator->getMessageBag()->add('name', 'Attribute choice option values can not be null!'); return response()->json(['errors' => Helpers::error_processor($validator)]); } $item['name'] = 'choice_' . $no; $item['title'] = $request->choice[$key]; $item['options'] = explode(',', implode('|', preg_replace('/\s+/', ' ', $request[$str]))); array_push($choice_options, $item); } } $p->choice_options = json_encode($choice_options); $variations = []; $options = []; if ($request->has('choice_no')) { foreach ($request->choice_no as $key => $no) { $name = 'choice_options_' . $no; $my_str = implode('|', $request[$name]); array_push($options, explode(',', $my_str)); } } //Generates the combinations of customer choice options $combinations = Helpers::combinations($options); $stock_count = 0; if (count($combinations[0]) > 0) { foreach ($combinations as $key => $combination) { $str = ''; foreach ($combination as $k => $item) { if ($k > 0) { $str .= '-' . str_replace(' ', '', $item); } else { $str .= str_replace(' ', '', $item); } } $item = []; $item['type'] = $str; $item['price'] = abs($request['price_' . str_replace('.', '_', $str)]); $item['stock'] = abs($request['stock_' . str_replace('.', '_', $str)]); array_push($variations, $item); $stock_count += $item['stock']; } } else { $stock_count = (integer)$request['total_stock']; } if ((integer)$request['total_stock'] != $stock_count) { $validator->getMessageBag()->add('total_stock', 'Stock calculation mismatch!'); } if ($validator->getMessageBag()->count() > 0) { return response()->json(['errors' => Helpers::error_processor($validator)]); } //combinations end $p->variations = json_encode($variations); $p->price = $request->price; $p->unit = $request->unit; // $p->image = json_encode(array_merge(json_decode($p['image'], true), json_decode($image_data, true))); // $p->set_menu = $request->item_type; $p->image = json_encode($images); // $p->available_time_starts = $request->available_time_starts; // $p->available_time_ends = $request->available_time_ends; $p->tax = $request->tax_type == 'amount' ? $request->tax : $request->tax; $p->tax_type = $request->tax_type; $p->discount = $request->discount_type == 'amount' ? $request->discount : $request->discount; $p->discount_type = $request->discount_type; $p->total_stock = $request->total_stock; $p->attributes = $request->has('attribute_id') ? json_encode($request->attribute_id) : json_encode([]); $p->save(); foreach ($request->lang as $index => $key) { if ($request->name[$index] && $key != 'en') { Translation::updateOrInsert( ['translationable_type' => 'App\Model\Product', 'translationable_id' => $p->id, 'locale' => $key, 'key' => 'name'], ['value' => $request->name[$index]] ); } if ($request->description[$index] && $key != 'en') { Translation::updateOrInsert( ['translationable_type' => 'App\Model\Product', 'translationable_id' => $p->id, 'locale' => $key, 'key' => 'description'], ['value' => $request->description[$index]] ); } } return response()->json([], 200); } public function delete(Request $request) { $product = Product::find($request->id); foreach (json_decode($product['image'], true) as $img) { if (Storage::disk('public')->exists('product/' . $img)) { Storage::disk('public')->delete('product/' . $img); } } $product->delete(); Toastr::success('Product removed!'); return back(); } public function remove_image($id, $name) { $product = Product::find($id); $img_arr = []; foreach (json_decode($product['image'], true) as $img) { if (strcmp($img, $name) != 0) { array_push($img_arr, $img); } } if (count($img_arr) == 0) { Toastr::error('Product must have at least one image!'); return back(); } if (Storage::disk('public')->exists('product/' . $name)) { Storage::disk('public')->delete('product/' . $name); } Product::where(['id' => $id])->update([ 'image' => json_encode($img_arr) ]); Toastr::success('Image removed successfully!'); return back(); } public function bulk_import_index() { return view('admin-views.product.bulk-import'); } public function bulk_import_data(Request $request) { try { $collections = (new FastExcel)->import($request->file('products_file')); } catch (\Exception $exception) { Toastr::error('You have uploaded a wrong format file, please upload the right file.'); return back(); } $data = []; $dis = 0; foreach ($collections as $key => $collection) { if ($collection['name'] === "") { Toastr::error('Please fill name field of row ' . ($key + 2)); return back(); } if ($collection['description'] === "") { Toastr::error('Please fill description field of row ' . ($key + 2)); return back(); } if ($collection['price'] === "") { Toastr::error('Please fill price field of row ' . ($key + 2)); return back(); } if ($collection['tax'] === "") { Toastr::error('Please fill tax field of row ' . ($key + 2)); return back(); } if ($collection['category_id'] === "") { Toastr::error('Please fill category_id field of row ' . ($key + 2)); return back(); } if ($collection['sub_category_id'] === "") { Toastr::error('Please fill sub_category_id field of row ' . ($key + 2)); return back(); } if ($collection['discount'] === "") { Toastr::error('Please fill discount field of row ' . ($key + 2)); return back(); } if ($collection['discount_type'] === "") { Toastr::error('Please fill discount_type field of row ' . ($key + 2)); return back(); } if ($collection['tax_type'] === "") { Toastr::error('Please fill tax_type field of row ' . ($key + 2)); return back(); } if ($collection['unit'] === "") { Toastr::error('Please fill unit field of row ' . ($key + 2)); return back(); } if ($collection['total_stock'] === "") { Toastr::error('Please fill total_stock field of row ' . ($key + 2)); return back(); } if (!is_numeric($collection['price'])) { Toastr::error('Price of row ' . ($key + 2) . ' must be number'); return back(); } if (!is_numeric($collection['discount'])) { Toastr::error('Discount of row ' . ($key + 2) . ' must be number'); return back(); } if (!is_numeric($collection['tax'])) { Toastr::error('Tax of row ' . ($key + 2) . ' must be number'); return back(); } if (!is_numeric($collection['total_stock'])) { Toastr::error('Total stock of row ' . ($key + 2) . ' must be number'); return back(); } $product = [ 'discount_type' => $collection['discount_type'], 'discount' => $collection['discount'], ]; if ($collection['price'] <= Helpers::discount_calculate($product, $collection['price'])) { Toastr::error('Discount can not be more or equal to the price!'); return back(); } } foreach ($collections as $collection) { array_push($data, [ 'name' => $collection['name'], 'description' => $collection['description'], 'image' => json_encode(['def.png']), 'price' => $collection['price'], 'variations' => json_encode([]), 'tax' => $collection['tax'], 'status' => 1, 'attributes' => json_encode([]), 'category_ids' => json_encode([['id' => $collection['category_id'], 'position' => 0], ['id' => $collection['sub_category_id'], 'position' => 1]]), 'choice_options' => json_encode([]), 'discount' => $collection['discount'], 'discount_type' => $collection['discount_type'], 'tax_type' => $collection['tax_type'], 'unit' => $collection['unit'], 'total_stock' => $collection['total_stock'], ]); } DB::table('products')->insert($data); Toastr::success(count($data) . ' - Products imported successfully!'); return back(); } public function bulk_export_data() { $storage = []; $products = Product::get(); foreach ($products as $item) { $category_id = 0; $sub_category_id = 0; foreach (json_decode($item->category_ids, true) as $category) { if ($category['position'] == 1) { $category_id = $category['id']; } else if ($category['position'] == 2) { $sub_category_id = $category['id']; } } if (!isset($item->name)) { $item->name = 'Unnamed Product'; } if (!isset($item->description)) { $item->description = 'No description available'; } $storage = [ 'name' => $item->name, 'description' => $item->description, 'category_id' => $category_id, 'sub_category_id' => $sub_category_id, 'price' => $item->price, 'tax' => $item->tax, 'status' => $item->status, 'discount' => $item->discount, 'discount_type' => $item->discount_type, 'tax_type' => $item->tax_type, 'unit' => $item->unit, 'total_stock' => $item->total_stock, ]; } return (new FastExcel($storage))->download('products.xlsx'); } }
💾 Save
Cancel
Save as UTF-8, newlines normalized to LF