/**
* @param Request $request
* @return \Illuminate\Database\Eloquent\Collection|static[]
*/
public function getHeaderList(Request $request)
{
$headers = Header::with('details.client', 'user.city', 'user.agency')->where('issued', true)->where('canceled', false);
$this->filtersByHeader($request, $headers);
return $headers->get();
}
/**
* @param string $q
*
* @return bool
*/
public function getPolicies($product, $q = '')
{
try {
$this->model = Header::select('op_de_headers.id', 'issue_number', 'prefix')->leftJoin('op_de_coverage_warranties', function ($q1) {
$q1->on('op_de_headers.id', '=', 'op_de_coverage_warranties.op_de_header_id');
});
switch ($product) {
case 'au':
$this->model->whereNull('op_au_header_id');
break;
case 'td':
$this->model->whereNull('op_td_header_id');
break;
}
$this->model = $this->model->where('issued', true)->get();
if ($this->model->count() > 0) {
return true;
}
} catch (QueryException $e) {
}
return false;
}
public function getHeaderList($request)
{
$headers = Header::with('details.client', 'user.city', 'user.agency')->where('type', 'Q');
$this->filtersByHeader($request, $headers);
return $headers->get();
}
public function returnHtmlModal($type, $idHeader, $flagPdf, $aux)
{
$var = '';
$flagPdf = $flagPdf;
$retailer = $this->retailer;
//edw-->$retailerProduct = $this->retailerProduct;
$retailerProduct = RetailerProduct::where('ad_company_product_id', $aux)->get();
$cli = [];
$cli = \Sibas\Entities\De\Header::where('id', $idHeader)->first();
$detail = Detail::where('id', $cli->details[0]->id)->first();
$data = false;
if ($cli->facultative == true && $cli->issued == false) {
$data = $cli->facultative_observation;
} elseif ($cli->facultative == true && $cli->issued == true) {
$data = Facultative::where('op_de_detail_id', $detail->id)->get();
}
$header = Header::where('id', $idHeader)->first();
switch ($type) {
case 'cotizacion':
$resQuestion = $this->getEvaluationResponse($detail->response);
// no sirve
$imc = $detail->client->imc;
// no sirve
foreach ($cli->details as $key => $value) {
$cli->details[$key]->resQuestion = $this->getEvaluationResponse($value->response);
}
$var = ['template_cert' => view('cert.cert_cotizacion', compact('header', 'cli', 'idHeader', 'type', 'flagPdf', 'retailer', 'retailerProduct', 'resQuestion', 'imc', 'aux'))->render()];
break;
case 'emision':
$question = [];
$i = 1;
foreach ($cli->details as $key => $value) {
foreach (json_decode($value->response->response) as $key2 => $value2) {
$question[$value2->question][$i] = $value2->response;
}
$i++;
}
$adRates = DB::table('ad_rates')->get();
$adRates = $adRates[0];
$var = ['template_cert' => view('cert.cert_emision', compact('header', 'cli', 'question', 'adRates', 'idHeader', 'type', 'flagPdf', 'retailer', 'retailerProduct', 'data', 'aux'))->render()];
break;
case 'sub_vida_emision':
$deDetail = \Sibas\Entities\De\Detail::where('op_de_header_id', $idHeader)->first();
$viDetail = \Sibas\Entities\Vi\Detail::where('op_client_id', $deDetail->op_client_id)->first();
$viHeader = \Sibas\Entities\Vi\Header::where('id', $viDetail->op_vi_header_id)->first();
$cli = $viDetail;
$var = ['template_cert' => view('cert.cert_emision_vida', compact('viDetail', 'viHeader', 'idHeader', 'type', 'flagPdf', 'retailer', 'retailerProduct', 'aux'))->render()];
break;
case 'print_all':
$question = [];
$i = 1;
foreach ($cli->details as $key => $value) {
foreach (json_decode($value->response->response) as $key2 => $value2) {
$question[$value2->question][$i] = $value2->response;
}
$i++;
}
$adRates = DB::table('ad_rates')->get();
$adRates = $adRates[0];
# sub producto vida
$deDetail = \Sibas\Entities\De\Detail::where('op_de_header_id', $idHeader)->first();
$viDetail = 0;
$flag = 0;
if (count($deDetail) > 0) {
$viDetail = \Sibas\Entities\Vi\Detail::where('op_client_id', $deDetail->op_client_id)->first();
$flag = 1;
}
# validacion si existe sub.producto
$viHeader = 0;
if (count($viDetail) > 0) {
$viHeader = \Sibas\Entities\Vi\Header::where('id', $viDetail->op_vi_header_id)->first();
}
$var = ['template_cert' => view('cert.cert_all', compact('header', 'cli', 'question', 'adRates', 'viDetail', 'viHeader', 'flag', 'idHeader', 'type', 'flagPdf', 'retailer', 'retailerProduct', 'data', 'aux'))->render()];
break;
default:
break;
}
$arr = ['html' => $var, 'cli' => $cli];
return $arr;
}
/**
* @param Model|HeaderDe $de
*
* @return bool
*/
public function setCoverage($de)
{
try {
$de->coverageWarranty()->updateOrCreate(['op_de_header_id' => $de->id], ['op_au_header_id' => $this->model->id]);
return true;
} catch (QueryException $e) {
}
return false;
}
