/**
* 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'));
}
}
