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