public function returnHtmlModal($type, $idHeader, $flagPdf, $aux)
{
$cli = 1;
$header = Header::where('id', $idHeader)->first();
$retailer = Retailer::where('id', $header->client->ad_retailer_id)->first();
$retailerProduct = RetailerProduct::where('ad_company_product_id', $aux)->get();
$companyProduct = CompanyProduct::where('id', $aux)->first();
$vehicleType = VehicleType::where('active', 1)->get();
$groupVehicle = [];
$time = $header->getFullYearAttribute();
$i = 1;
$e = 1;
foreach ($vehicleType as $key => $value) {
$groupVehicle[$i][$value->id]['id_vehicle'] = $value->id;
$groupVehicle[$i][$value->id]['name_vehicle'] = $value->vehicle;
if ($e == 5) {
$i++;
$e = 1;
}
$e++;
}
$data = ['fecha_validacion' => date('Y-m-d', strtotime('+' . $retailerProduct[0]->parameters[0]->expiration . ' days', strtotime($header->created_at)))];
$tools = 1;
switch ($type) {
case 'cotizacion':
$var = ['template_cert' => view('au.cert.cotizacion', compact('time', 'header', 'retailer', 'retailerProduct', 'companyProduct', 'data', 'type', 'aux', 'tools'))->render()];
break;
case 'emision':
$var = ['template_cert' => view('au.cert.emision', compact('header', 'retailer', 'retailerProduct', 'companyProduct', 'data', 'type', 'aux', 'vehicleType', 'groupVehicle', 'tools'))->render()];
break;
case 'print_all':
$cot = view('au.cert.cotizacion', compact('time', 'header', 'retailer', 'retailerProduct', 'companyProduct', 'data', 'type', 'aux', 'tools'))->render();
$tools = 0;
$emi = view('au.cert.emision', compact('header', 'retailer', 'retailerProduct', 'companyProduct', 'data', 'type', 'aux', 'vehicleType', 'groupVehicle', 'tools'))->render();
$var = ['template_cert' => view('au.cert.printAll', compact('cot', 'emi'))->render()];
break;
default:
break;
}
$arr = ['html' => $var, 'cli' => $cli];
return $arr;
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request)
{
try {
$retailer_update = RetailerProduct::where('id', $request->input('id_retailer_product'))->first();
$retailer_update->billing = $request->input('fact');
$retailer_update->provisional_certificate = $request->input('cert');
$retailer_update->modality = $request->input('moda');
$retailer_update->facultative = $request->input('facu');
$retailer_update->ws = $request->input('webs');
if ($retailer_update->save()) {
return redirect()->route('admin.vi.parameters.list', ['nav' => 'vi', 'action' => 'list', 'id_retailer_product' => $request->input('id_retailer_product')])->with(array('ok' => 'Se actualizo correctamente los datos del formulario'));
}
} catch (QueryException $e) {
return redirect()->back()->with(array('error' => $e->getMessage()));
}
}
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;
}
/**
* retorna tipo de cambio
*
* @param type $rpId
* @param type $header
*
* @return type
*/
function returnTipoCambio($rpId, $header)
{
$retailerProduct = RetailerProduct::where('id', $rpId)->first();
$moneda = 1;
switch ($header->currency) {
case 'USD':
$moneda = $retailerProduct->retailer->exchangeRate->usd_value;
break;
case 'BS':
$moneda = $retailerProduct->retailer->exchangeRate->bs_value;
break;
default:
break;
}
return $moneda;
}
