/**
* funcion retorna registros mediante id de hader
*
* @param type $idHeader
*
* @return boolean
*/
public function getDetailByHeader($idHeader)
{
$query = Detail::where('op_td_header_id', '=', $idHeader);
$this->model = $query->get();
if ($this->model->count() == 1) {
$this->model = $this->model->first();
return true;
}
return false;
}
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);
}
/**
* 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;
}
