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