public static function setSetting($user_id, $key, $value)
{
$setting = UserSetting::where('user_id', '=', $user_id)->where('settings_key', '=', $key)->first();
if ($setting == null) {
$setting = new UserSetting();
$setting->user_id = $user_id;
}
$setting->settings_key = $key;
$setting->settings_value = $value;
$setting->save();
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$roles = new Roles();
$user = new User();
$user->first_name = $this->argument('first_name');
$user->last_name = $this->argument('last_name');
$user->email = $this->argument('email');
$user->password = bcrypt($this->argument('password'));
$user->role_id = $roles->getAdminRoleId();
$user->save();
// Settings
$settings = new UserSetting();
$settings->user_id = $user->id;
$settings->language_id = 2;
$settings->save();
// Trial period
UserTrialPeriod::create(['user_id' => $user->id, 'trial_period_id' => TrialPeriod::first()->id]);
$this->info('User with admin privileges was generated');
}
/**
* Create new account.
*
* @param CreateAccountRequest $request
* @return \Illuminate\Contracts\Routing\ResponseFactory|\Symfony\Component\HttpFoundation\Response
*/
public function register(CreateAccountRequest $request)
{
$response = new AjaxResponse();
$roles = new Roles();
// Build user data array
$data = ['email' => $request->get('email'), 'password' => bcrypt($request->get('password')), 'role_id' => $roles->getUserRoleId()];
// Insert user
$user = User::create($data);
// User settings
UserSetting::insert(['user_id' => $user->id, 'language_id' => Settings::defaultLanguageId()]);
// Create trial period
UserTrialPeriod::create(['user_id' => $user->id, 'trial_period_id' => TrialPeriod::where('validity_days', 90)->first()->id]);
Auth::login($user);
$response->setSuccessMessage(trans('register.account_created'));
return response($response->get());
}
public function update_status()
{
$sUpdateType = "";
$iUpdateValue = 0;
if (Input::get('status_type') == 'chat') {
$sUpdateType = 'user_chat_status';
$iUpdateValue = Input::get('status') == 'true' ? UserSetting::CHAT_STATUS_ENABLED_BY_USER : UserSetting::CHAT_STATUS_DISABLED_BY_USER;
} elseif (Input::get('status_type') == 'profile') {
$sUpdateType = 'user_profile_status';
$iUpdateValue = Input::get('status') == 'true' ? UserSetting::PROFILE_STATUS_ENABLED_BY_USER : UserSetting::PROFILE_STATUS_DISABLED_BY_USER;
} elseif (Input::get('status_type') == 'character') {
$sUpdateType = 'user_character_status';
$iUpdateValue = Input::get('status') == 'true' ? UserSetting::CHARACTER_STATUS_ENABLED_BY_USER : UserSetting::CHARACTER_STATUS_DISABLED_BY_USER;
}
$result = UserSetting::where('user_id', Session::get('user')['id'])->update([$sUpdateType => $iUpdateValue]);
if ($result) {
echo json_encode(array('status' => true, 'message' => "Successfully changed chat settings"));
} else {
echo json_encode(array('status' => false, 'message' => "Something went wrong. Please try again later"));
}
}
public function settings()
{
if (Session::has('user')) {
$aLoggedInUser = null;
$bOwner = true;
$oMate = null;
$bLoggedInUser = Session::has('user');
if ($bLoggedInUser) {
/*if($oUser->toArray()['id'] == Session::get('user')['id']){
$bOwner = true;
}*/
$aLoggedInUser['user'] = User::where('id', Session::get('user')['id'])->first()->toArray();
$aLoggedInUser['current_character'] = Character::where('id', $aLoggedInUser['user']['current_character_id'])->first()->toArray();
}
$aUser['user'] = User::where('id', Session::get('user')['id'])->first()->toArray();
$aUser['active_characters'] = Character::where('user_id', $aUser['user']['id'])->where('status', Character::CHARACTER_STATUS_DEFAULT)->orWhere('status', Character::CHARACTER_STATUS_ENABLED_BY_USER)->orWhere('status', Character::CHARACTER_STATUS_ENABLED_BY_ADMIN)->get()->toArray();
$aUser['inactive_characters'] = Character::where('user_id', $aUser['user']['id'])->where('status', Character::CHARACTER_STATUS_DISABLED_BY_USER)->orWhere('status', Character::CHARACTER_STATUS_INACTIVE)->get()->toArray();
$aUser['current_character'] = Character::where('id', $aUser['user']['current_character_id'])->first()->toArray();
$aUser['user_settings'] = UserSetting::where('id', Session::get('user')['id'])->first()->toArray();
$aLoggedInUser['user'] = $aUser['user'];
$aLoggedInUser['current_character'] = $aUser['current_character'];
$aCountries = Country::all()->toArray();
return view('users.users.settings')->with('aUser', $aUser)->with('aLoggedInUser', $aLoggedInUser)->with('aCountries', $aCountries)->with('bLoggedInUser', $bLoggedInUser)->with('bOwner', $bOwner);
}
}
public function show($id, $format = '')
{
$stockdata = StockData::with('stockdata_rows')->find($id);
if ($stockdata == null) {
if ($format == 'json') {
echo json_encode([]);
exit;
}
return redirect('stockdata')->with('notice', ['title' => 'Error!', 'text' => 'Stock data not found.']);
}
if ($format == 'json') {
echo json_encode($stockdata->stockdata_rows);
exit;
}
return view('stockdata/show')->with('title', 'Stock data : ' . $stockdata->name)->with('stockdata', $stockdata)->with('tableRowsCount', UserSetting::getSetting(Auth::user()->id, 'STOCKDATA_DETAIL_TABLE_ROWS'));
}
/**
* Allow admin to create new user.
*
* @param CreateNewUserRequest $request
* @return mixed
*/
public function createNewUser(CreateNewUserRequest $request)
{
$roles = new Roles();
$user = User::create(['email' => $request->get('new_user_email'), 'password' => bcrypt($request->get('new_user_password')), 'special_user' => (bool) $request->get('make_special_user'), 'role_id' => $roles->getUserRoleId()]);
// Generate user settings
UserSetting::insert(['user_id' => $user->id, 'language_id' => Settings::defaultLanguageId()]);
$response = new AjaxResponse();
$response->setSuccessMessage(trans('users_manager.user_created_successfully'));
return response($response->get())->header('Content-Type', 'application/json');
}
public function control($sUserName)
{
switch ($sUserName) {
case 'logout':
return redirect('user/logout');
case 'characters':
return redirect('character/index');
case 'users':
return redirect('user/index');
default:
$oUser = User::where('user_name', $sUserName)->first();
if ($oUser == null) {
dd("ALALALHJ!");
} else {
$aLoggedInUser = null;
$bOwner = false;
$oMate = null;
$bLoggedInUser = Session::has('user');
if ($bLoggedInUser) {
if ($oUser->toArray()['id'] == Session::get('user')['id']) {
$bOwner = true;
}
$aLoggedInUser['user'] = User::where('id', Session::get('user')['id'])->first()->toArray();
$aLoggedInUser['current_character'] = Character::where('id', $aLoggedInUser['user']['current_character_id'])->first()->toArray();
}
$aUser['user'] = $oUser->toArray();
$aUser['current_character'] = Character::where('id', $aUser['user']['current_character_id'])->first()->toArray();
$aUser['active_characters'] = Character::where('user_id', $aUser['user']['id'])->where('status', Character::CHARACTER_STATUS_DEFAULT)->orWhere('status', Character::CHARACTER_STATUS_ENABLED_BY_USER)->orWhere('status', Character::CHARACTER_STATUS_ENABLED_BY_ADMIN)->get()->toArray();
$aUser['inactive_characters'] = Character::where('user_id', $aUser['user']['id'])->where('status', Character::CHARACTER_STATUS_DISABLED_BY_USER)->orWhere('status', Character::CHARACTER_STATUS_INACTIVE)->get()->toArray();
$aUser['user_settings'] = UserSetting::where('user_id', $oUser->toArray()['id'])->first()->toArray();
$aUser['current_photo'] = Photo::where('id', $aUser['user']['photo_id'])->first()->toArray();
//Mates
$bRequestedFromLoggedInUser = false;
if ($bLoggedInUser) {
$sSql = 'SELECT * from mates where ((from_user_id = ' . $aUser['user']['id'] . ' AND to_user_id = ' . Session::get('user')['id'] . ') OR (from_user_id = ' . Session::get('user')['id'] . ' AND to_user_id = ' . $aUser['user']['id'] . ')) AND (status = ' . Mate::MATE_STATUS_ADDED_BY_USER . ' OR status <> ' . Mate::MATE_STATUS_ADDED_BY_ADMIN . ')';
$oMate = DB::select($sSql);
$oMate = Mate::where('from_user_id', $aUser['user']['id'])->orWhere('to_user_id', Session::get('user')['id'])->orWhere(function ($query) {
$query->where('status', Mate::MATE_STATUS_ADDED_BY_ADMIN)->where('status', Mate::MATE_STATUS_ADDED_BY_ADMIN);
})->orderBy('id', 'desc')->first();
}
$aUser['mate'] = is_null($oMate) || empty($oMate) ? NULL : $oMate->toArray();
if ($aUser['mate']['from_user_id'] == Session::get('user')['id']) {
$bRequestedFromLoggedInUser = true;
}
//End of mate
//Likes
$oUserUserLikers = Like::where('to_user_id', $aUser['user']['id'])->where('like_type', Like::LIKE_TYPE_USER)->where('user_id', $aUser['user']['id'])->where('status', Like::LIKE_STATUS_ACTIVE)->get();
$aUser['user']['likers'] = $oUserUserLikers ? $oUserUserLikers->toArray() : [];
$aUser['user']['logged_in_user']['has_liked'] = LikesController::checkHasLikedInArray($aUser['user']['likers'], $aLoggedInUser['user']['id']);
$oCurrentCharacterLikers = Like::where('to_user_id', $aUser['user']['id'])->where('like_type', Like::LIKE_TYPE_CHARACTER)->where('character_id', $aUser['user']['current_character_id'])->where('status', Like::LIKE_STATUS_ACTIVE)->get();
$aUser['current_character']['likers'] = $oCurrentCharacterLikers ? $oCurrentCharacterLikers->toArray() : [];
$aUser['current_character']['logged_in_user']['has_liked'] = LikesController::checkHasLikedInArray($aUser['current_character']['likers'], $aLoggedInUser['user']['id']);
for ($i = 0; $i < count($aUser['active_characters']); $i++) {
$aActiveCharacterLikers = Like::where('to_user_id', $aUser['user']['id'])->where('like_type', Like::LIKE_TYPE_CHARACTER)->where('character_id', $aUser['active_characters'][$i]['id'])->where('status', Like::LIKE_STATUS_ACTIVE)->get();
$aUser['active_characters'][$i]['likers'] = $aActiveCharacterLikers ? $aActiveCharacterLikers->toArray() : [];
$aUser['active_characters'][$i]['logged_in_user']['has_liked'] = LikesController::checkHasLikedInArray($aUser['active_characters'][$i]['likers'], $aLoggedInUser['user']['id']);
}
for ($i = 0; $i < count($aUser['inactive_characters']); $i++) {
$aInActiveCharacterLikers = Like::where('to_user_id', $aUser['user']['id'])->where('like_type', Like::LIKE_TYPE_CHARACTER)->where('character_id', $aUser['inactive_characters'][$i]['id'])->where('status', Like::LIKE_STATUS_ACTIVE)->get();
$aUser['inactive_characters'][$i]['likers'] = $aInActiveCharacterLikers ? $aInActiveCharacterLikers->toArray() : [];
$aUser['inactive_characters'][$i]['logged_in_user']['has_liked'] = LikesController::checkHasLikedInArray($aUser['inactive_characters'][$i]['likers'], $aLoggedInUser['user']['id']);
}
$oCurrentPhotoLikers = Like::where('to_user_id', $aUser['user']['id'])->where('like_type', Like::LIKE_TYPE_PHOTO)->where('photo_id', $aUser['current_photo']['id'])->where('status', Like::LIKE_STATUS_ACTIVE)->get();
$aUser['current_photo']['likers'] = $oCurrentPhotoLikers ? $oCurrentPhotoLikers->toArray() : [];
$aUser['current_photo']['logged_in_user']['has_liked'] = LikesController::checkHasLikedInArray($aUser['current_photo']['likers'], $aLoggedInUser['user']['id']);
//dd($aUser);
$aFamilies = Family::where('status', Family::FAMILY_STATUS_DEFAULT)->get()->toArray();
$aSpecies = Specy::where('status', Specy::SPECY_STATUS_DEFAULT)->get()->toArray();
return view('users.users.profile')->with('aLoggedInUser', is_array($aLoggedInUser) ? $aLoggedInUser : null)->with('aUser', $aUser)->with('bOwner', $bOwner)->with('bRequestedFromLoggedInUser', $bRequestedFromLoggedInUser)->with('bLoggedInUser', $bLoggedInUser)->with('aSpecies', $aSpecies)->with('aFamilies', $aFamilies);
}
}
}
public function update($settings_key)
{
UserSetting::setSetting(Auth::user()->id, $settings_key, Input::get('value'));
echo '{}';
}
