public function __construct(PdfController $pdf) { $this->pdf = $pdf; $auth = Auth::user(); $user = User::where('id', $auth->id)->first(); $this->retailer = $user->retailerUser->retailer; }
public function __construct(PdfController $pdf) { $this->pdf = $pdf; $auth = Auth::user(); $user = User::where('id', $auth->id)->first(); $this->retailer = $user->retailerUser->retailer; $this->retailerProduct = RetailerProduct::where('ad_retailer_id', $this->retailer->id)->where('type', 'MP')->get(); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request) { if ($request->get('agencia') != 0) { $agency = $request->get('agencia'); } else { $agency = null; } try { $array = explode('|', $request->get('tipo_usuario')); $array_city = explode('|', $request->get('depto')); $id_company = null; if (!is_null($request->get('id_profile'))) { $id_profile = explode('|', $request->get('id_profile')); if ($id_profile[1] == 'COP') { $id_company = $request->get('id_company'); } } $user_update = User::where('id', $request->input('id_user'))->first(); $user_update->full_name = $request->input('txtNombre'); $user_update->email = $request->input('txtEmail'); $user_update->phone_number = $request->input('txtTelefono'); $user_update->ad_city_id = $array_city[1]; $user_update->ad_agency_id = $agency; $user_update->ad_user_type_id = $array[0]; if ($user_update->save()) { $query_update_retailer_user = \DB::table('ad_retailer_users')->where('ad_user_id', $request->get('id_user'))->update(['ad_company_id' => $id_company, 'updated_at' => date("Y-m-d H:i:s")]); if ($query_update_retailer_user) { if ($array[1] == 'UST' || $array[1] == 'OPT') { try { if ($array[1] == 'UST') { $quest_user_profile = \DB::table('ad_user_profiles')->where('ad_user_id', $request->input('id_user'))->first(); if (count($quest_user_profile) > 0) { $query_update_profile = \DB::table('ad_user_profiles')->where('ad_user_id', $request->input('id_user'))->update(['ad_profile_id' => $id_profile[0], 'updated_at' => date("Y-m-d H:i:s"), 'active' => true]); } else { $query_insert = \DB::table('ad_user_profiles')->insert(['ad_user_id' => $request->get('id_user'), 'ad_profile_id' => $id_profile[0], 'active' => true, 'created_at' => date("Y-m-d H:i:s"), 'updated_at' => date("Y-m-d H:i:s")]); } if ($id_profile[1] == 'SEP') { $query_del_register = \DB::table('ad_retailer_user_products')->where('ad_retailer_user_id', $request->get('id_retailer_user'))->delete(); if (count($request->get('product')) > 0) { foreach ($request->get('product') as $key => $value) { $query_products = \DB::table('ad_retailer_user_products')->insert(['ad_retailer_user_id' => $request->get('id_retailer_user'), 'ad_product_id' => $value, 'created_at' => date("Y-m-d H:i:s"), 'updated_at' => date("Y-m-d H:i:s")]); } } } } $query_del = \DB::table('ad_user_permissions')->where('ad_user_id', $request->input('id_user'))->delete(); if (count($request->get('permiso')) > 0) { foreach ($request->get('permiso') as $key => $value) { $query_permissions = \DB::table('ad_user_permissions')->insert(['ad_user_id' => $request->input('id_user'), 'ad_permission_id' => $value, 'active' => true, 'created_at' => date("Y-m-d H:i:s"), 'updated_at' => date("Y-m-d H:i:s")]); } } return redirect()->route('admin.user.list', ['nav' => 'user', 'action' => 'list'])->with(array('ok' => 'Se edito correctamente los datos del formulario')); } catch (QueryException $e) { return redirect()->back()->with(array('error' => $e->getMessage())); } } else { try { $query_update_profile = \DB::table('ad_user_profiles')->where('ad_user_id', $request->input('id_user'))->update(['active' => false]); if (count($query_update_profile) > 0) { return redirect()->route('admin.user.list', ['nav' => 'user', 'action' => 'list'])->with(array('ok' => 'Se actualizo correctamente los datos del formulario')); } else { return redirect()->route('admin.user.list', ['nav' => 'user', 'action' => 'list'])->with(array('ok' => 'Se actualizo correctamente los datos del formulario')); } } catch (QueryException $e) { return redirect()->back()->with(array('error' => $e->getMessage())); } } } else { } } } catch (QueryException $e) { return redirect()->back()->with(array('error' => $e->getMessage())); } }