/** * 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(); $retailer_product_query = RetailerProduct::with('retailer', 'companyProduct.product')->where('id', $id_retailer_product)->first(); if ($action == 'list') { $query = \DB::table('ad_retailer_product_payment_methods as arppm')->join('ad_retailer_products as arp', 'arp.id', '=', 'arppm.ad_retailer_product_id')->join('ad_company_products as acp', 'acp.id', '=', 'arp.ad_company_product_id')->join('ad_products as ap', 'ap.id', '=', 'acp.ad_product_id')->select('arppm.id as id_payment_method', 'ap.name as product', 'arppm.payment_method', 'arppm.active')->where('arppm.ad_retailer_product_id', $id_retailer_product)->get(); //dd($retailer_product_query); return view('admin.payment.list', compact('nav', 'action', 'id_retailer_product', 'main_menu', 'array_data', 'query', 'retailer_product_query')); } elseif ($action == 'new') { $vec = array(); $query = array(); $retailer_product_query = RetailerProduct::with('retailer', 'companyProduct.product')->where('id', $id_retailer_product)->first(); $payment = \DB::table('ad_retailer_product_payment_methods')->where('ad_retailer_product_id', $id_retailer_product)->get(); foreach ($payment as $datos) { $vec[] = $datos->payment_method; } foreach (config('base.payment_methods') as $key => $data) { if (in_array($key, $vec)) { } else { $query[] = $key . '|' . $data; } } //dd($query); return view('admin.payment.new', compact('nav', 'action', 'id_retailer_product', 'main_menu', 'array_data', 'retailer_product_query', 'query')); } }
/** * 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') { $retailer_product_query = RetailerProduct::with('retailer', 'companyProduct.product')->where('id', $id_retailer_product)->first(); $query = \DB::table('ad_credit_products')->get(); return view('admin.de.creditproduct.list', compact('nav', 'action', 'id_retailer_product', 'main_menu', 'array_data', 'query', 'retailer_product_query')); } elseif ($action == 'new') { $vec = array(); $query = array(); $retailer_product_query = RetailerProduct::with('retailer', 'companyProduct.product')->where('id', $id_retailer_product)->first(); $credit_product = \DB::table('ad_credit_products')->where('ad_retailer_product_id', $id_retailer_product)->get(); foreach ($credit_product as $datos) { $vec[] = $datos->slug; } foreach (config('base.credit_products') as $key => $data) { if (in_array($key, $vec)) { } else { $query[] = $key . '|' . $data; } } return view('admin.de.creditproduct.new', compact('nav', 'action', 'id_retailer_product', 'main_menu', 'array_data', 'retailer_product_query', 'query')); } }
public function getActivitiesByProduct($rp_id) { $selectOption = $this->getSelectOption(); $rp = RetailerProduct::with(['activities' => function ($query) { $query->addSelect(['ad_activities.id', 'category', 'occupation', 'code']); }])->where('id', $rp_id)->first(); $activities = $selectOption->merge($rp->activities->toArray()); return $activities; }
public function getRetailerProductById($rp_id) { $this->model = RetailerProduct::with(['retailer.exchangeRate', 'retailer.retailerProducts.companyProduct.product', 'companyProduct.product', 'rates.increments.category', 'parameters', 'subProducts.productCompany', 'subProducts.companyProduct.product', 'coverages'])->where('id', $rp_id)->get(); if ($this->model->count() === 1) { $this->model = $this->model->first(); return true; } return false; }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($nav, $action, $id_rates, $id_retailer_products, $code_product, $type) { $main_menu = $this->menu_principal(); $array_data = $this->array_data(); if ($code_product == 'de' || $code_product == 'vi' || $code_product == 'td') { $query = \DB::table('ad_rates as ar')->leftjoin('ad_coverages as ac', 'ac.id', '=', 'ar.ad_coverage_id')->join('ad_retailer_products as arp', 'arp.id', '=', 'ar.ad_retailer_product_id')->join('ad_retailers as aret', 'aret.id', '=', 'arp.ad_retailer_id')->join('ad_company_products as acp', 'acp.id', '=', 'arp.ad_company_product_id')->join('ad_products as ap', 'ap.id', '=', 'acp.ad_product_id')->select('ar.id as id_rates', 'ar.rate_company', 'ar.rate_bank', 'ar.rate_final', 'ap.name as product', 'ac.name as coverage', 'aret.name as retailer', 'ap.code as code_product')->where('ar.id', '=', $id_rates)->first(); } elseif ($code_product == 'au') { $retailer_product = RetailerProduct::with('retailer', 'companyProduct.product')->where('id', $id_retailer_products)->first(); $query_rate = \DB::table('ad_rates')->where('id', $id_rates)->first(); $category_query = \DB::table('ad_au_increments as aui')->join('ad_retailer_product_categories as arpc', 'arpc.id', '=', 'aui.ad_retailer_product_category_id')->select('aui.id as id_increment', 'arpc.category', 'aui.increment')->where('ad_rate_id', $query_rate->id)->where('arpc.ad_retailer_product_id', $id_retailer_products)->get(); //dd($category_query); } return view('admin.tasas.edit', compact('nav', 'action', 'query', 'main_menu', 'id_rates', 'array_data', 'id_retailer_products', 'code_product', 'query_rate', 'category_query', 'retailer_product', 'type')); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function ajax_modal($id_retailer_product, $text) { $query_product = RetailerProduct::with('retailer', 'companyProduct.product')->where('id', $id_retailer_product)->first(); $query_occupation = \DB::table('ad_retailer_product_activities as arpa')->join('ad_activities as ac', 'ac.id', '=', 'arpa.ad_activity_id')->select('ac.occupation')->where('arpa.ad_retailer_product_id', $id_retailer_product)->get(); //dd($query_product); $response = view('partials.modal_content_occupation', compact('query_occupation', 'text', 'query_product')); return response()->json(['payload' => $response->render()]); }
public function edit_parameter_additional($nav, $action, $id_product_parameters, $id_retailer_product) { $main_menu = $this->menu_principal(); $array_data = $this->array_data(); $retailer_product_query = RetailerProduct::with('retailer', 'companyProduct.product')->where('id', $id_retailer_product)->first(); if ($action == 'edit_parameter_additional') { //dd($id_retailer_product); $query = ProductParameter::where('id', $id_product_parameters)->where('ad_retailer_product_id', $id_retailer_product)->first(); //dd($query); return view('admin.td.parameters.edit-parameter-additional', compact('nav', 'action', 'id_product_parameters', 'id_retailer_product', 'main_menu', 'array_data', 'query', 'retailer_product_query')); } }