protected function handle() { $request = $this->getRequest(); if ($request->getMethod() == 'POST') { $ids = $request->request->get('ids'); $session = $this->getSession(); $db = UserDatabase::getDb(); $db->transaction(); try { if (!$ids) { throw new \Exception('没有选择任何用户'); } $users = UserAuthModel::allUsers(function (QueryBuilder $qb) use($ids) { $qb->andWhere($qb->expr()->in('id', $ids)); }); if (!$users) { throw new \Exception('用户不存在'); } // 删除用户 foreach ($users as $user) { UserAuthModel::deleteAuth($user['id']); // 删除资料 UserProfileModel::deleteProfile($user['id']); // 删除元数据 $metadata = UserMetadataModel::allMetadata(function (QueryBuilder $qb) use($user) { $qb->andWhere($qb->expr()->eq('user_id', ':user_id'))->setParameter(':user_id', $user['id']); }); foreach ($metadata as $data) { UserMetadataModel::deleteMetadata($user['id'], $data['meta_key']); } } $db->commit(); $session->addFlash('success', '操作成功'); } catch (\Exception $e) { $db->rollback(); $session->addFlash('error', $e->getMessage()); } return new RedirectResponse($this->generateUrl('admin_user_index')); } else { $ids = $request->query->get('ids'); if (is_string($ids)) { $ids = json_decode($ids, true); } if (!$ids) { throw new \Exception('没有选择任何用户'); } $users = UserAuthModel::allUsers(function (QueryBuilder $qb) use($ids) { $qb->andWhere($qb->expr()->in('id', $ids)); }); if (!$users) { throw new \Exception('用户不存在'); } return $this->render('user/delete.html.twig', array('users' => $users)); } }
/** * @param $id * @return null|UserProfileModel */ protected function getUserProfile($id) { $user_profile = UserProfileModel::getProfile($id); if (!$user_profile) { $user_profile = new UserProfileModel(); $user_profile->id = $id; // 保存 $user_profile = UserProfileModel::createProfile($user_profile); } return $user_profile; }
public function __invoke() { /** @var \Tachigo\User\Aware\Hook\UserHook $hook */ $hook = $this->getHook(); $user_id = $hook->getUserId(); $hook_results = $hook->getResults(); $hook_results['auth'] = UserAuthModel::getAuth($user_id); $hook_results['profile'] = UserProfileModel::getProfile($user_id); $hook->setResults($hook_results); /*$hook = $this->getHook(); $user_id = $hook->getUserId(); $hook_results = $hook->getResults(); $db = UserDatabase::getDb(); $hook_results['auth'] = $db->getUserInfo($user_id); $hook_results['profile'] = $hook_results['auth']; $hook->setResults($hook_results);*/ }
/** * @param $user_ids * @return array */ public function getUsersInfo(array $user_ids) { if (empty($user_ids)) { return array(); } $sql = <<<SQL SELECT * FROM {@auth_table} AS a LEFT JOIN {@profile_table} AS p ON a.`id` = p.`id` WHERE a.`id` in :id SQL; $auth_table = UserAuthModel::getTableName(); $profile_table = UserProfileModel::getTableName(); $sql = strtr($sql, array('{@auth_table}' => $auth_table, '{@profile_table}' => $profile_table)); $query = $this->getSelectQuery($sql, array(':id' => '(' . implode(',', $user_ids) . ')')); $data = $query->getResult(); $return = array(); foreach ($data as $row) { $return[$row['id']] = $row; } return $return; }
private function handleAvatar($auth_id) { $user_auth = UserAuthModel::getAuth($auth_id); if (!$user_auth) { throw new \Exception('用户不存在'); } $user_profile = UserProfileModel::getProfile($user_auth->id); if (!$user_profile) { $user_profile = new UserProfileModel(); $user_profile->id = $user_auth->id; // 保存 $user_profile = UserProfileModel::createProfile($user_profile); } $request = $this->getRequest(); $posts = $request->request; $avatar = $posts->get('avatar'); $user_profile->avatar = $avatar; // 保存 UserProfileModel::saveProfile($user_profile); }
public function __invoke() { /** @var \Tachigo\User\Aware\Component\UserAwareHook $hook */ $hook = $this->getHook(); if ($hook instanceof UserRegisterFieldsHook) { // 如果是用户登录字段配置的钩子 $hook_results = $hook->getResults(); $results = array('fields' => array('username' => array('element' => 'input', 'type' => 'text', 'placeholder' => '请输入用户名', 'label' => '用户名'), 'password' => array('element' => 'input', 'type' => 'password', 'placeholder' => '请输入密码', 'label' => '密码'), 'confirm_password' => array('element' => 'input', 'type' => 'password', 'placeholder' => '请输入密码', 'label' => '确认密码'), 'nickname' => array('element' => 'input', 'type' => 'text', 'placeholder' => '请输入昵称', 'label' => '昵称'))); $hook->setResults(array_merge($hook_results, $results)); } elseif ($hook instanceof UserRegisterHook) { $request = $this->getRequest(); $session = $this->getSession(); $posts = $request->request; $db = UserDatabase::getDb(); try { $db->transaction(); $username = $posts->get('username'); $password = $posts->get('password'); $confirm_password = $posts->get('confirm_password'); $nickname = $posts->get('nickname'); // 检查 if (!$username) { throw new \Exception('用户名不能为空'); } if (strlen($username) < 2) { throw new \Exception('用户名至少2位字符'); } if (!$password) { throw new \Exception('密码不能为空'); } if (strlen($password) < 6) { throw new \Exception('密码至少6位字符'); } if ($password != $confirm_password) { throw new \Exception('密码不一致'); } if (!$nickname) { throw new \Exception('昵称不能为空'); } if (strlen($nickname) < 2) { throw new \Exception('昵称至少2个字符'); } // 检查重复 $user_auth = UserAuthModel::getAuthByUsername($username); if ($user_auth) { throw new \Exception('用户名已被占用,请重新选择'); } // 创建用户 $user_auth = new UserAuthModel(); $user_auth->username = $username; $user_auth->password = md5($password); $now = time(); $user_auth->createTimestamp = $now; $user_auth->updateTimestamp = $now; $user_auth->loginTimestamp = $now; $user_auth->status = 1; // 保存 $user_auth = UserAuthModel::createAuth($user_auth); $user_profile = $this->getUserProfile($user_auth->id); $user_profile->nickname = $nickname; $user_profile = UserProfileModel::saveProfile($user_profile); $db->commit(); $session['auth'] = $user_auth; $session['profile'] = $user_profile; } catch (\Exception $e) { $db->rollback(); throw $e; } } }
/** * 保存 * @param UserProfileModel $profile * @return UserProfileModel * @throws \Exception */ public static function saveProfile(UserProfileModel $profile) { return self::editProfile($profile->toArray()); }
public function __invoke() { $request = $this->getRequest(); if ($request->getMethod() == 'POST') { $posts = $request->request; $session = $this->getSession(); $db = UserDatabase::getDb(); try { $db->transaction(); $username = $posts->get('username'); $password = $posts->get('password'); $repeat_password = $posts->get('repeat_password'); $nickname = $posts->get('nickname'); // 检查 if (!$username) { throw new \Exception('用户名不能为空'); } if (strlen($username) < 2) { throw new \Exception('用户名至少2位字符'); } if (!$password) { throw new \Exception('密码不能为空'); } if (strlen($password) < 6) { throw new \Exception('密码至少6位字符'); } if ($password != $repeat_password) { throw new \Exception('密码不一致'); } if (!$nickname) { throw new \Exception('昵称不能为空'); } if (strlen($nickname) < 2) { throw new \Exception('昵称至少2个字符'); } // 检查重复 $user_auth = UserAuthModel::getAuthByUsername($username); if ($user_auth) { throw new \Exception('用户名已被占用,请重新选择'); } // 创建用户 $user_auth = new UserAuthModel(); $user_auth->username = $username; $user_auth->password = md5($password); $now = time(); $user_auth->createTimestamp = $now; $user_auth->updateTimestamp = $now; $user_auth->loginTimestamp = $now; $user_auth->status = 1; // 保存 $user_auth = UserAuthModel::createAuth($user_auth); $user_profile = $this->getUserProfile($user_auth->id); $user_profile->nickname = $nickname; $user_profile = UserProfileModel::saveProfile($user_profile); $db->commit(); $session['auth'] = $user_auth; $session['profile'] = $user_profile; $session->addFlash('success', '注册成功'); // 重定向到完善资料 return new RedirectResponse($this->generateUrl('user_homepage')); } catch (\Exception $e) { $db->rollback(); $session->addFlash('error', $e->getMessage()); return new RedirectResponse($this->generateUrl('user_register')); } } return $this->render('passport/register.html.twig'); }
public function user_by_id($value, $args, $context, ResolveInfo $info) { /*$user = array( 'auth' => array(), 'profile' => array(), ); $user_auth = UserAuthModel::getAuthByUsername($args['username_like']); if ($user_auth) { $user['auth'] = $user_auth->toArray(); $user_profile = UserProfileModel::getProfile($user_auth->id); $user['profile'] = $user_profile->toArray(); }*/ $user = array(); $user_auth = UserAuthModel::getAuth($args['id']); if ($user_auth) { $user = $user_auth->toArray(); $user_profile = UserProfileModel::getProfile($user_auth->id); if ($user_profile) { $user += $user_profile->toArray(); } if (!isset($user['avatar']) || empty($user['avatar'])) { // todo $user['avatar'] = 'http://cdn.tachigo.com/user/img/avatar.gif'; } } return $user; }