/**
* 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_company_products as acp')->join('ad_products as ap', 'ap.id', '=', 'acp.ad_product_id')->join('ad_companies as ac', 'ac.id', '=', 'acp.ad_company_id')->select('acp.id as id_company_product', 'ap.name as product', 'ac.name as company', 'acp.active', 'acp.ad_product_id')->where('acp.ad_company_id', '=', $id_company)->get();
return view('admin.addproductcompany.list', compact('nav', 'action', 'main_menu', 'query', 'id_company', 'array_data'));
} elseif ($action == 'new') {
$query_cia = Company::where('id', $id_company)->first();
$query_prod = \DB::table('ad_products as ap')->whereNotExists(function ($query_two) use($id_company) {
$query_two->select(\DB::raw(1))->from('ad_company_products as acp')->whereRaw('acp.ad_product_id = ap.id')->whereRaw('acp.ad_company_id =' . $id_company);
})->get();
//dd($query_prod);
return view('admin.addproductcompany.new', compact('nav', 'action', 'main_menu', 'id_company', 'query_cia', 'query_prod', 'array_data'));
}
}
/**
* 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 = Company::where('id', $request->input('id_company'))->first();
$query_update->name = $request->input('txtCompany');
$query_update->image = $field_image;
if ($query_update->save()) {
return redirect()->route('admin.company.list', ['nav' => 'company', 'action' => 'list'])->with(array('ok' => 'Se edito correctamente los datos del formulario'));
}
} catch (QueryException $e) {
return redirect()->back()->with(array('error' => $e->getMessage()));
}
}
