public function showProduct($brandname, $catname) { $brandname = urlunslug($brandname); $catname = urlunslug($catname); $brand = Brand::where('name', '=', $brandname)->first(); $productcat = Productcategory::where('brand_id', '=', $brand->id)->where('name', '=', $catname)->select('id', 'type')->first(); $productsObj = Productcategory::find($productcat->id)->products(); $mode = Input::get('mode', 'retail'); $products = $productsObj->select('id', 'productcat_id', 'brand_id', 'barcodeid', 'name', 'quantity', 'almost_finished', 'costprice', 'published', $mode . '_price as price', $mode . '_discount as discount', $mode . '_discountedprice as discountedprice', $mode . '_totalprice as totalprice'); if ($products == null) { return $this->callErrorPage(404); } $products = $products->orderBy('id', 'desc')->get(); $data['products'] = $products->toArray(); $data['sum_total'] = $this->_sumTotalprice($data['products']); $data['sum_cost'] = $this->_sumTotalcost($data['products']); $data['profit_margin'] = $data['sum_total'] - $data['sum_cost']; $data['addProductLink'] = array('brand_id' => $brand->id, 'productcat_id' => $productcat->id); $data['mode'] = $mode; $data['brand'] = $brand; $data['cat'] = $catname; Larasset::start('footer')->js('dataTables-min', 'dataTables-bootstrap', 'bootstrap_editable'); Larasset::start('header')->css('bootstrap_editable'); if (!Request::ajax()) { $data['modes'] = Mode::listModes(); $this->layout->title = $brand['name'] . ' - ' . $catname; $blade = $productcat->type === 'service' ? 'showservice' : 'tab_showproduct'; $this->layout->content = View::make('admin.liststock.' . $blade, $data); } else { return View::make('admin.liststock.showproduct', $data); } }
public function deleteCategories() { $ids = explode(',', Input::get('javascriptArrayString')); //Log $cats = []; foreach ($ids as $id) { $cats[] = Productcategory::where('id', $id)->pluck('name'); } $brandName = Productcategory::find($ids[0])->brand()->pluck('name'); //Then temp delete them Productcategory::destroy($ids); if (!empty($cats)) { $log['products'] = "Category Belonging To <b class='orange'>" . $brandName . "</b> Brand = <b>" . implode(' | ', $cats) . '</b>'; $log['stocktype'] = 'delete'; $this->_saveActivityLog($log); } $data['status'] = 'success'; $data['message'] = 'Deleted successfully'; return Response::json($data); }