/**
* Cat update.
*
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$data = $request->all();
// dd($data);
Cat::where('id', $id)->update($data);
return response()->json(['message' => '更新成功'], 201);
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(CatCreateRequest $request)
{
// dd($request->input('sub_cats'));
$catName = $request->input('name');
if ($existingCat = Cat::where('name', $catName)->first()) {
$existingCat->meta_description = $request->input('meta_description');
$existingCat->image_class = $request->input('cat_image');
$existingCat->save();
if ($request->input('subcat')) {
$newSub = new SubCat();
$newSub->name = $request->input('subcat');
$newSub->image_class = $request->input('sub_image');
$newSub->cat_id = $existingCat->id;
}
return redirect('/admin/cat')->withSuccess("The Category '{$existingCat->name}' has been updated.");
} else {
$category = new Cat();
$category->name = $request->input('name');
$category->meta_description = $request->input('meta_description');
$category->image_class = $request->input('cat_image');
$category->save();
if ($request->input('subcat')) {
$freshSub = new SubCat();
$freshSub->name = $request->input('subcat');
$freshSub->image_class = $request->input('sub_image');
$freshSub->cat_id = $category->id;
$freshSub->save();
}
return redirect('/admin/cat')->withSuccess("The Category '{$category->name}' has been created.");
}
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(CatCreateRequest $request)
{
// dd($request->input('sub_cats'));
$catName = $request->input('category_name');
$subName = $request->input('subcategory_name');
$catImage = $request->input('cat_image');
if ($existingCat = Cat::where('name', $catName)->first()) {
return redirect('/admin/cat/create')->withErrors("The Category '{$existingCat->name}' Is already existing");
}
foreach ($subName as $subb) {
if ($existingSub = SubCat::where('name', $subb)->first()) {
return back()->withErrors("The Sub-Category '{$existingSub->name}' Is already existing");
}
}
if (!($existingImage = DB::table('subcategory')->where('name', $catImage)->first())) {
$image = DB::table('subcategory')->insert(array('name' => $catImage));
}
$category = new Cat();
$category->name = $request->input('category_name');
$category->meta_description = $request->input('meta_description');
$category->image_class = $catImage;
$category->save();
foreach ($subName as $subb) {
$freshSub = new SubCat();
$freshSub->name = $subb;
$freshSub->cat_id = $category->id;
$freshSub->save();
}
/* $existingCat->meta_description=$request->input('meta_description');
$existingCat->image_class=$request->input('cat_image');
$existingCat->save();
if($request->input('subcat') ){
$newSub= new SubCat();
$newSub->name=$request->input('subcat');
$newSub->image_class=$request->input('sub_image');
$newSub->cat_id=$existingCat->id;
}
return redirect('/admin/cat')
->withSuccess("The Category '$existingCat->name' has been updated."); */
/* }
else{
$category=new Cat();
$category->name= $request->input('category_name');
$category->meta_description=$request->input('meta_description');
$category->image_class= $request->input('cat_image');
$category->save();
foreach($subName as $subb){
$freshSub=new SubCat();
$freshSub->name=$request->input('subcat');
$freshSub->image_class= $request->input('sub_image');
$freshSub->cat_id= $category->id;
$freshSub->save();
} */
return redirect('/admin/cat/')->withSuccess("The Category '{$category->name}' has been created.");
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
\Excel::load('MiRO_All Products_Pricelist.xls', function ($reader) {
// Get workbook title
$results = $reader->get();
$workbookTitle = $results->getTitle();
echo "workbookTitle: " . $workbookTitle . "<br>";
// $n = 0;
foreach ($results as $sheet) {
// get sheet title
$sheetTitle = $sheet->getTitle();
echo "sheetTitle: " . $sheetTitle . "<br>";
// Check if Category exists, and if so, get category ID
$category = Cat::where('name', $sheetTitle)->first();
if ($category) {
//echo "Category exists id'" . $category->id . "'<br>";
} else {
echo "Category does not exist, now adding<br>";
$category = new Cat();
$category->name = $sheetTitle;
$category->save();
}
foreach ($sheet as $cells) {
// Check if it's an empty line, and if so, assume this is a subcategory
// Check if valid data before loading into products array
if ($cells->sku && $cells->name && $cells->qty_1) {
// Check if product exists, if not, add it
//echo "Sheet sku: " . $cells->sku . "<br>";
$product = Product::where('sku', $cells->sku)->first();
if ($product) {
// Update product
//echo "Found a product with this SKU, updating<br>";
$product->name = $cells->name;
$product->price1 = $cells->qty_1;
$product->cat_id = $category->id;
$product->save();
} else {
// Create product
echo "Can't find a product with this SKU, creating<br>";
$product = new Product();
$product->sku = $cells->sku;
$product->name = $cells->name;
$product->price1 = $cells->qty_1;
$product->cat_id = $category->id;
$product->save();
}
}
// $n = $n + 1;
// if ($n > 10) {
// //break;
// dd($cells);
// }
}
}
});
}
public function setSlugAttribute($slug_name)
{
if (empty($slug_name)) {
$this->info = Str::generate_ge($this->attributes['name']);
$slug_name = Cat::where('slug', '=', $this->info)->pluck('slug');
$this->attributes['slug'] = empty($slug_name) ? $this->info : $this->info . '-' . str_random(5);
} else {
if (isset($_REQUEST['_method']) == 'PATCH') {
$this->info = Str::generate_ge($slug_name);
$slug_name = Cat::where('slug', '=', $this->info)->count();
$this->attributes['slug'] = $slug_name <= 1 ? $this->info : $this->info . '-' . str_random(5);
} else {
$this->info = Str::generate_ge($slug_name);
$slug_name = Cat::where('slug', '=', $this->data)->pluck('slug');
$this->attributes['slug'] = empty($slug_name) ? $this->info : $this->info . '-' . str_random(5);
}
}
}
public function createTask()
{
$cats = Cat::where('catStatus', 1)->get();
return view('admin.task.createTask')->with('cats', $cats);
}
public function edit(Cat $cat)
{
$categories = Cat::where('parent', 0)->get();
return view('cats.edit', compact('cat', 'categories'));
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
Cache::forget('cats');
Cat::findOrFail($id)->delete();
Cat::where('parent', $id)->delete();
return trans('sections.section') . ' #' . $id . ' ' . trans('sections.successfully_removed');
}
public function show($cat, $group, $range)
{
$catId = Cat::where('slug', '=', $cat)->first();
$groupId = Group::where('slug', '=', $group)->first();
$rangeId = Range::where('slug', '=', $range)->first();
$cat_id = "%";
$catSlug = '0';
$catName = '';
if ($cat !== '0') {
$cat_id = $catId->id;
$catSlug = $catId->slug;
$catName = $catId->name;
}
$group_id = "%";
$groupSlug = '0';
$groupName = '';
if ($group !== '0') {
$group_id = $groupId->id;
$groupSlug = $groupId->slug;
$groupName = $groupId->name;
}
$range_id = "%";
$rangeSlug = '0';
$rangeName = '';
if ($range !== '0') {
$range_id = $rangeId->id;
$rangeSlug = $rangeId->slug;
$rangeName = $rangeId->name;
}
// return $range_id;
//
$results = Product::with('range', 'group')->where('cat_id', 'LIKE', $cat_id, 'AND')->where('group_id', 'LIKE', $group_id, 'AND')->where('range_id', 'LIKE', $range_id)->orderby('order')->paginate(12);
// return $cat_id . '-' . $group_id . '-' .$range_id ;
$groups = Group::where('cat_id', 'LIKE', $cat_id)->get();
$ranges = Range::where('cat_id', 'LIKE', $cat_id)->orderby('order')->get();
$keywords = $catName . ', ' . $groupName . ', ' . $rangeName;
Session::flash('keywords', $keywords);
Session::flash('title', $catName);
//return $results;
return View::make('results', compact('results', 'groups', 'groupSlug', 'ranges', 'rangeSlug', 'cat_id', 'cat', 'catSlug', 'catName', 'groupName', 'rangeName'));
//return View::make('results');
}
