/**
* callback 驗證Email是否重複
*/
public function cbValidateEmailUnique(sfValidatorCallback $Validator, $Value, $Arguments)
{
$Value = strtolower($Value);
if (MemberTable::getInstance()->findOneByEmail($Value)) {
throw new sfValidatorError($Validator, 'invalid', array('value' => $Value));
}
return $Value;
}
public function executeAuthenticateLogin(sfWebRequest $request)
{
$username = $request->getParameter('username');
$password = $request->getParameter('password');
$query = MemberTable::getInstance()->createQuery()->select('m.username, m.country')->from('Member m')->where('m.username = ?', $username)->andWhere('m.password = ?', $password);
$rs = $query->fetchOne();
$rsCount = $query->execute()->count();
if ($rsCount > 0) {
$_SESSION['username'] = $rs->getUsername();
$_SESSION['userId'] = $rs->getId();
$_SESSION['country'] = $rs->getCountry();
$_SESSION['state'] = $rs->getState();
}
die(json_encode(array('success' => $rsCount == 0 ? false : true)));
}
public static function checkMemberInfo($column = null, $value = null)
{
$q = MemberTable::getInstance()->createQuery();
$q->where("{$column} = ?", $value);
return $q->execute();
}