public function insert(UserModel $user)
{
$data = array('user_id' => $user->getUserId(), 'email' => $user->getEmail(), 'display_name' => $user->getDisplayName(), 'password' => $user->getPassword(), 'salt' => $user->getSalt(), 'register_time' => new Expr('NOW()'), 'register_ip' => new Expr("INET_ATON('{$_SERVER['REMOTE_ADDR']}')"));
$db = $this->getWriteAdapter();
$db->insert($this->getTableName(), $data);
$userId = $db->lastInsertId();
$user->setUserId($userId);
return $user;
}
public function updateUser(User $user)
{
$updateArray = array('username' => $user->getUsername() ?: null, 'role' => $user->getRole() ?: null, 'salt' => $user->getSalt() ?: null, 'password' => $user->getPassword() ?: null, 'fullName' => $user->getFullName() ?: null, 'gender' => $user->getGender() ?: null, 'birthdate' => $user->getBirthdate() ?: null, 'email' => $user->getEmail() ?: null, 'mobile' => $user->getMobile() ?: null, 'cityId' => (int) $user->getCityId() ?: null, 'districtId' => (int) $user->getDistrictId() ?: null, 'address' => $user->getAddress() ?: null, 'rememberMe' => $user->getRememberMe() ?: null, 'lastAccess' => $user->getLastAccess() ?: null, 'activeKey' => $user->getActiveKey() ?: null, 'resetKey' => $user->getResetKey() ?: null, 'active' => $user->getActive(), 'registeredDate' => $user->getRegisteredDate() ?: null, 'facebook' => $user->getFacebook() ?: null, 'description' => $user->getDescription() ?: null, 'locked' => $user->getLocked() ?: null);
$updateArray = array_filter($updateArray, 'strlen');
$updateArray = array_filter($updateArray);
$update = $this->getDbSql()->update(self::TABLE_NAME);
if ($user->getId()) {
$update->where(array('id' => $user->getId()));
}
$update->set($updateArray);
$query = $this->getDbSql()->buildSqlString($update);
$result = $this->getDbAdapter()->query($query, Adapter::QUERY_MODE_EXECUTE);
return $result;
}
/**
* @param \User\Model\User $user
* @return boolean
*/
public function updateUser(\User\Model\User $user)
{
if (!$user->getId() && !$user->getEmail() && !$user->getUsername()) {
return false;
}
/* @var $userMapper \User\Model\UserMapper */
$userMapper = $this->getServiceLocator()->get('User\\Model\\UserMapper');
if ($user->getPassword()) {
$user->setSalt(substr(md5(rand(2000, 5000) . time() . rand(2000, 5000)), 0, 20));
$user->setPassword(md5($user->getSalt() . $user->getPassword()));
}
return $userMapper->updateUser($user);
}
public function createFromForm(Form $form)
{
$user = new UserModel();
$user->setEmail($form->getValue('email'))->setDisplayName($form->getValue('display_name'))->setSalt($this->randomBytes(16))->setPassword($this->hashPassword($form->getValue('password'), $user->getSalt()));
$userId = $this->getUserMapper()->insert($user);
}
