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;
}
