/** * @param User $user * * @return array */ protected function data(User $user) { $this->getInstance(); $this->user = $user; $this->profile = $this->user->profile()->first(); $this->retailer = $this->user->retailerUser->retailer; $this->getDataForReport(); return ['cities' => $this->cities, 'agencies' => $this->agencies, 'users' => $this->users]; }
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(); }
public function listUser($auth) { if ($auth == 'ADT') { $this->model = User::join('ad_user_types', 'ad_users.ad_user_type_id', '=', 'ad_user_types.id')->leftjoin('ad_cities', 'ad_users.ad_city_id', '=', 'ad_cities.id')->leftjoin('ad_agencies', 'ad_users.ad_agency_id', '=', 'ad_agencies.id')->leftjoin('ad_user_profiles as aup', 'aup.ad_user_id', '=', 'ad_users.id')->leftjoin('ad_retailer_users', 'ad_retailer_users.ad_user_id', '=', 'ad_users.id')->leftjoin('ad_profiles as ap', 'ap.id', '=', 'aup.ad_profile_id')->select('ad_users.id as id_user', 'ad_user_types.name as type', 'ad_users.username', 'ad_users.full_name', 'ad_users.email', 'ad_cities.name as cities', 'ad_agencies.name as agencies', 'ad_users.active', 'ap.name as profile', 'aup.active as active_profile', 'ad_retailer_users.ad_retailer_id', 'ad_user_types.code as code_type')->where('ad_user_types.code', '<>', 'ADT')->get(); } else { $this->model = User::join('ad_user_types', 'ad_users.ad_user_type_id', '=', 'ad_user_types.id')->leftjoin('ad_cities', 'ad_users.ad_city_id', '=', 'ad_cities.id')->leftjoin('ad_agencies', 'ad_users.ad_agency_id', '=', 'ad_agencies.id')->leftjoin('ad_user_profiles as aup', 'aup.ad_user_id', '=', 'ad_users.id')->leftjoin('ad_retailer_users', 'ad_retailer_users.ad_user_id', '=', 'ad_users.id')->leftjoin('ad_profiles as ap', 'ap.id', '=', 'aup.ad_profile_id')->select('ad_users.id as id_user', 'ad_user_types.name as type', 'ad_users.username', 'ad_users.full_name', 'ad_users.email', 'ad_cities.name as cities', 'ad_agencies.name as agencies', 'ad_users.active', 'ap.name as profile', 'aup.active as active_profile', 'ad_retailer_users.ad_retailer_id', 'ad_user_types.code as code_type')->where('ad_user_types.code', '<>', 'ADT')->where('ad_user_types.code', '<>', 'OPT')->get(); } if ($this->model->count() > 0) { return true; } return false; }
/** * @param int $retailer_id * * @return mixed */ public function getUsersByRetailer($retailer_id) { return User::with('agency', 'city')->whereHas('retailerUser.retailer', function ($q) use($retailer_id) { $q->where('ad_retailers.id', $retailer_id); })->where('username', '!=', 'admin')->get(); }
public function ajax_active_inactive($id_user, $text) { if ($text == 'inactive') { $user_update = User::find($id_user); $user_update->active = false; if ($user_update->save()) { return 1; } else { return 0; } } elseif ($text == 'active') { $user_update = User::find($id_user); $user_update->active = true; if ($user_update->save()) { return 1; } else { return 0; } } }