/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index($nav, $action, $id_retailer_product) { $main_menu = $this->menu_principal(); $array_data = $this->array_data(); $query = RetailerProduct::join('ad_company_products', 'ad_company_products.id', '=', 'ad_retailer_products.ad_company_product_id')->join('ad_products', 'ad_products.id', '=', 'ad_company_products.ad_product_id')->select('ad_retailer_products.id as id_retailer_product', 'ad_retailer_products.type', 'ad_retailer_products.billing', 'ad_retailer_products.provisional_certificate', 'ad_retailer_products.modality', 'ad_retailer_products.facultative', 'ad_retailer_products.ws', 'ad_retailer_products.active', 'ad_products.name as producto', 'ad_retailer_products.warranty')->where('ad_retailer_products.id', '=', $id_retailer_product)->first(); return view('admin.au.parameters.list-parameter', compact('nav', 'action', 'id_retailer_product', 'main_menu', 'array_data', 'query')); }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($nav, $action, $id_retailer_product, $id_planes) { $main_menu = $this->menu_principal(); $array_data = $this->array_data(); $query = \DB::table('ad_plans')->where('id', $id_planes)->where('ad_retailer_product_id', $id_retailer_product)->first(); $query_retailer = RetailerProduct::join('ad_company_products as acp', 'acp.id', '=', 'ad_retailer_products.ad_company_product_id')->join('ad_products as ap', 'ap.id', '=', 'acp.ad_product_id')->select('ap.name as product')->where('ad_retailer_products.id', $id_retailer_product)->first(); //dd($query_retailer); return view('admin.vi.planes.edit', compact('nav', 'action', 'id_retailer_product', 'id_planes', 'main_menu', 'query', 'query_retailer', 'array_data')); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index($nav, $action, $id_retailer_product) { $main_menu = $this->menu_principal(); $array_data = $this->array_data(); if ($action == 'list') { $query = RetailerProduct::join('ad_company_products', 'ad_company_products.id', '=', 'ad_retailer_products.ad_company_product_id')->join('ad_products', 'ad_products.id', '=', 'ad_company_products.ad_product_id')->select('ad_retailer_products.id as id_retailer_product', 'ad_retailer_products.type', 'ad_retailer_products.billing', 'ad_retailer_products.provisional_certificate', 'ad_retailer_products.modality', 'ad_retailer_products.facultative', 'ad_retailer_products.ws', 'ad_retailer_products.active', 'ad_products.name as producto')->where('ad_retailer_products.id', '=', $id_retailer_product)->get(); //dd($query); return view('admin.vi.parameters.list', compact('nav', 'action', 'id_retailer_product', 'query', 'main_menu', 'array_data')); } elseif ($action == 'list_parameter_additional') { $query = \DB::table('ad_product_parameters')->where('ad_retailer_product_id', '=', $id_retailer_product)->get(); //dd($query); return view('admin.vi.parameters.list-parameter-additional', compact('nav', 'action', 'query', 'id_retailer_product', 'main_menu', 'array_data')); } elseif ($action == 'new_parameter_additional') { return view('admin.vi.parameters.new-parameter-additional', compact('nav', 'action', 'id_retailer_product', 'main_menu', 'array_data')); } elseif ($action == 'new') { return view('admin.vi.parameters.new', compact('nav', 'action', 'id_retailer_product', 'main_menu', 'array_data')); } }