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