public function update_data(Request $request) { try { $parameter = config('base.product_parameters'); $name = $parameter[$request->input('prod_param')]; $query_update = ProductParameter::where('id', $request->input('id_product_parameter'))->where('ad_retailer_product_id', $request->input('id_retailer_product'))->first(); $query_update->name = $name; $query_update->slug = $request->input('prod_param'); $query_update->age_min = $request->input('edad_min'); $query_update->age_max = $request->input('edad_max'); $query_update->amount_min = $request->input('monto_min'); $query_update->amount_max = $request->input('monto_max'); $query_update->expiration = $request->input('caduc'); $query_update->detail = $request->input('num_titu'); if ($query_update->save()) { return redirect()->route('admin.de.parameters.list-parameter-additional', ['nav' => 'de', 'action' => 'list_parameter_additional', 'id_retailer_product' => $request->input('id_retailer_product')])->with(array('ok' => 'Se edito correctamente los datos del formulario')); } } catch (QueryException $e) { return redirect()->back()->with(array('error' => $e->getMessage())); } //dd($request->input('id_retailer_product')); }
public function listInsured($rp_id, $header_id, $steep) { $prodParam = ProductParameter::where('ad_retailer_product_id', decode($rp_id))->where('slug', 'GE')->first(); $detail = Detail::where('op_td_header_id', decode($header_id))->get(); $exedDetail = 0; if (count($detail) == $prodParam->detail) { $exedDetail = $prodParam->detail; } $var = ['template' => view('td.listInsured', compact('detail', 'header_id', 'rp_id', 'exedDetail', 'prodParam', 'steep'))->render()]; return response()->json($var); }
public function update_parameter_additional(Request $request) { $parameter = config('base.product_parameters'); $name = $parameter[$request->input('prod_param')]; $query_update = ProductParameter::where('id', $request->input('id_product_parameters'))->where('ad_retailer_product_id', $request->input('id_retailer_product'))->first(); //dd($query_update); if ($query_update instanceof ProductParameter) { $query_update->name = $name; $query_update->slug = $request->input('prod_param'); $query_update->age_min = $request->input('edad_min'); $query_update->age_max = $request->input('edad_max'); $query_update->amount_min = $request->input('monto_min'); $query_update->amount_max = $request->input('monto_max'); $query_update->expiration = $request->input('caduc'); $query_update->detail = $request->input('num_titu'); if ($query_update->save()) { return redirect()->route('admin.vi.parameters.list-parameter-additional', ['nav' => 'vi', 'action' => 'list_parameter_additional', 'id_retailer_product' => $request->input('id_retailer_product')])->with(array('ok' => 'Se edito correctamente los datos del formulario')); } } else { return redirect()->back()->with(array('error' => 'error de consulta')); } }
/** * fucion determina regla facultativo mediante el valor asegurado. * * @param type $idHeader */ public function roleFacultative($rpId, $idHeader, $header) { $moneda = $this->returnTipoCambio($rpId, $header); $ge = ProductParameter::where('ad_retailer_product_id', $rpId)->where('slug', 'GE')->first(); $fa = ProductParameter::where('ad_retailer_product_id', $rpId)->where('slug', 'FA')->first(); $detail = Detail::where('op_td_header_id', $idHeader)->get(); $totalInsured = 0; $facultative = []; $arrayFac = []; $keyFac = 0; # validacion facultativos por riesgo foreach ($detail as $key => $value) { if ($value->matter_insured == 'PR' && $value->use == 'IP') { if ($value->insured_value >= $fa->amount_min * $moneda && $value->insured_value <= $fa->amount_max * $moneda) { $arrayFac['role1'][] = $value; $keyFac++; } } $totalInsured += $value->insured_value; } # validacion facultativos generales if ($totalInsured > $ge->amount_max * $moneda) { $arrayFac['role2']['total_amount'] = $totalInsured; $arrayFac['role2']['amount_max'] = $ge->amount_max * $moneda; $arrayFac['role2']['details'] = $detail; $keyFac++; } $facultative['facultative'] = $keyFac; $facultative['roles'] = $arrayFac; $facultative['parameter']['FA'] = $fa; $facultative['parameter']['GE'] = $ge; return $facultative; }