/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($nav, $action, $id_exchange)
{
$main_menu = $this->menu_principal();
$array_data = $this->array_data();
$retailer = Retailer::where('active', 1)->first();
$query_exchange = \DB::table('ad_exchange_rates')->where('id', $id_exchange)->where('ad_retailer_id', $retailer->id)->first();
return view('admin.exchange.edit', compact('nav', 'action', 'retailer', 'main_menu', 'query_exchange', 'id_exchange', 'array_data'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index($nav, $action, $id_company)
{
$main_menu = $this->menu_principal();
$array_data = $this->array_data();
if ($action == 'list') {
$query = \DB::table('ad_retailer_products as arp')->join('ad_retailers as ar', 'ar.id', '=', 'arp.ad_retailer_id')->join('ad_company_products as acp', 'acp.id', '=', 'arp.ad_company_product_id')->join('ad_products as ap', 'ap.id', '=', 'acp.ad_product_id')->select('arp.id as id_retailer_products', 'ar.name as retailer', 'ap.name as product', 'arp.type', 'arp.active', 'ap.code')->where('ar.active', true)->where('acp.active', true)->get();
$parameter = config('base.retailer_product_types');
//dd($parameter);
return view('admin.addtoretailer.list', compact('nav', 'action', 'id_company', 'main_menu', 'query', 'parameter', 'array_data'));
} elseif ($action == 'new') {
$query_ret = Retailer::where('active', true)->get();
$query_pr_co = \DB::table('ad_company_products as acp')->join('ad_products as ap', 'ap.id', '=', 'acp.ad_product_id')->select('acp.id as id_company_products', 'ap.name as product')->where('acp.active', true)->where('acp.ad_company_id', $id_company)->get();
return view('admin.addtoretailer.new', compact('nav', 'action', 'id_company', 'main_menu', 'query_ret', 'query_pr_co', 'array_data'));
}
}
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)
{
$this->validate($request, ['txtFile' => 'mimes:jpeg,jpg,png']);
//dd($request->file('txtFile'));
if (count($request->file('txtFile')) > 0) {
// upload the image //
$file = $request->file('txtFile');
$destination_path = 'assets/files/';
$file_id = date('U') . '_' . md5(uniqid('@F#1$' . time(), true));
$filename = $file_id . '.' . $file->getClientOriginalExtension();
$file->move($destination_path, $filename);
$field_image = $destination_path . $filename;
} else {
$field_image = $request->input('aux_file');
}
try {
// save image data into database //
$query_update = Retailer::where('id', $request->input('id_retailer'))->first();
$query_update->name = $request->input('txtRetailer');
$query_update->image = $field_image;
$query_update->domain = $request->input('txtDominio');
if ($query_update->save()) {
return redirect()->route('admin.retailer.list', ['nav' => 'retailer', 'action' => 'list'])->with(array('ok' => 'Se edito correctamente los datos del formulario'));
}
} catch (QueryException $e) {
return redirect()->back()->with(array('error' => $e->getMessage()));
}
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($nav, $action, $id_depto)
{
$main_menu = $this->menu_principal();
$array_data = $this->array_data();
$query = City::where('id', $id_depto)->first();
$query_re = Retailer::where('active', 1)->get();
$query_ret_city = \DB::table('ad_retailer_cities')->where('ad_city_id', $id_depto)->get();
//dd($query_ret_city);
return view('admin.cities.edit', compact('nav', 'action', 'query', 'query_re', 'main_menu', 'query_ret_city', 'array_data'));
}