public function getIndex()
{
if (!ACL::hasPermission('products')) {
return redirect(route('home'))->withErrors(['Você não pode acessar a página de produtos.']);
}
$products = Products::orderBy('name', 'ASC')->get();
return view('admin.products.index')->with(compact('products'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$proArr = Products::orderBy('id')->get();
foreach ($proArr as $pro) {
$this->changeColsToOutFormat($pro);
}
return response()->json($proArr);
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
$allcustomers = \App\Customers::orderBy('first_name')->get();
$customers = $allcustomers->lists('CustomerFullName', 'id');
$allproducts = \App\Products::orderBy('product_name')->get();
$products = $allproducts->lists('ProductShowInfo', 'id');
//\App\Products::lists('product_name','id');
return view('orders.create', compact('customers', 'products'));
}
public function index()
{
$page = 'produtos';
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
$pages = Pages::where('slug', '=', $page)->first();
$advertising = Advertising::orderByRaw("RAND()")->get();
foreach ($advertising as $ad) {
array_add($ad, "image", Advertising::imageVideo($ad->url));
array_set($ad, "url", Advertising::embedVideo($ad->url, 1));
}
$calls = Calls::orderByRaw("RAND()")->limit(2)->get();
$products = Products::orderBy('sortorder', 'ASC')->get();
return view('website.products')->with(compact('page', 'websiteSettings', 'pages', 'advertising', 'calls', 'products'));
}
public function getViewProduct($id)
{
$product = Products::findOrFail($id);
$brands = Brands::all();
$models = Models::all();
$productImages = DB::table('product_images')->where('in_product', $id)->get();
$randProducts = Products::orderBy(DB::raw('RAND()'))->take(3)->get();
$randImages = Images::all();
$price_text = '';
if ($product->price_count == 'yes') {
$price_text = 'за брой';
}
return view('pages.view-product')->with('product', $product)->with('brands', $brands)->with('models', $models)->with('productImages', $productImages)->with('randProducts', $randProducts)->with('randImages', $randImages)->with('price_text', $price_text);
}
public function search(Request $request)
{
if (!isset($request->keywords)) {
return redirect(url('produtos'));
}
$keywordsSearched = isset($request->keywords) ? $request->keywords : null;
$page = 'produtos';
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
$pages = Pages::where('slug', '=', $page)->first();
$productsCategories = ProductsCategories::orderBy('sortorder', 'asc')->get();
$activePrinciples = Products::addSelect(DB::raw('DISTINCT(activePrinciple)'))->where('activePrinciple', '!=', '')->orderBy('activePrinciple', 'asc')->get();
foreach ($activePrinciples as $activePrinciple) {
array_add($activePrinciple, 'activePrincipleSlug', str_slug($activePrinciple->activePrinciple, '-'));
}
$products = Products::orderBy('name', 'asc')->where('name', 'LIKE', '%' . $request->keywords . '%')->get();
return view('website.products.index')->with(compact('page', 'pages', 'websiteSettings', 'productsCategories', 'products', 'activePrinciples', 'keywordsSearched'));
}
public function query(Request $request)
{
$validator = Validator::make($request->all(), ['currentPage' => 'required', 'items_per_page' => 'required']);
if ($validator->fails()) {
return Response::json(array('result' => false, 'data' => 'data is valid.'));
}
$parpage = $request->input('items_per_page');
$page = $request->input('currentPage');
$skip = ($page - 1) * $parpage;
if ($request->input('publisher')) {
$products = Products::where('publisher_id', $request->input('publisher'))->orderBy('created_at', 'desc')->skip($skip)->take($parpage)->get();
} else {
$products = Products::orderBy('created_at', 'desc')->skip($skip)->take($parpage)->get();
}
if ($products) {
$counts = Products::count();
return Response::json(array('result' => true, 'data' => $products, 'count' => $counts));
}
}
public function getOrder()
{
if (!ACL::hasPermission('products', 'edit')) {
return redirect(route('products'))->withErrors(['Você não pode editar a ordem dos produtos.']);
}
$products = Products::orderBy('sortorder', 'ASC')->addSelect('productsId')->addSelect('title')->addSelect('sortorder')->get();
return view('admin.products.order')->with(compact('products'));
}
public function listProducts(Request $request)
{
if (Auth::user()->email == '*****@*****.**') {
$query = $request->input('search');
$products = '';
if (empty($query)) {
$products = Products::orderBy('id', 'desc')->paginate(15);
} else {
$products = Products::where(DB::raw("vt_number"), 'LIKE', "%{$query}%")->orWhere(DB::raw("name"), 'LIKE', "%{$query}%")->paginate(15);
$products->setPath('/admin/list-products?search=' . $query);
}
return view('admin.list-products')->with('products', $products)->with('query', $query);
}
return redirect('/');
}
