private function VerifyMember(Member $member, $password, $dontSave = false)
{
$pwHash = hash('sha256', $password . $member->GetPasswordSalt());
if ($pwHash == $member->GetPassword()) {
if (!$dontSave) {
$this->member = $member;
$_SESSION[self::$sessionParam] = $this->member->GetID();
}
return true;
}
return false;
}
/**
* The url to the page with the member edit/create form
* @param Member $member If member is given, form page will be in edit mode, otherwise in create mode
* @return string Returns the form page url
*/
protected function FormUrl(Member $member = null)
{
$args = array();
if ($member) {
$args['member'] = $member->GetID();
}
return BackendRouter::ModuleUrl(new MemberForm(), $args);
}
/**
* Deletes the unselected group ids
* @param array $exGroupIDs Currently assigned group ids
* @param array $selGroupIDs Selected group ids
*/
private function DeleteOldGroups(array $selGroupIDs)
{
$tblMmg = MemberMembergroup::Schema()->Table();
$sql = Access::SqlBuilder();
$where = $sql->Equals($tblMmg->Field('Member'), $sql->Value($this->member->GetID()));
if (count($selGroupIDs) > 0) {
$selectedList = $sql->InListFromValues($selGroupIDs);
$where = $where->And_($sql->NotIn($tblMmg->Field('MemberGroup'), $selectedList));
}
MemberMembergroup::Schema()->Delete($where);
}
/**
* Gets the member's member groups
* @param Member $member
* @return Membergroup[] Returns the member groups assigned to the user
*/
static function MemberMembergroups(Member $member)
{
if (!$member->Exists()) {
return array();
}
$sql = Access::SqlBuilder();
$tblMmg = MemberMembergroup::Schema()->Table();
$tblMg = Membergroup::Schema()->Table();
$join = $sql->Join($tblMmg);
$joinCondition = $sql->Equals($tblMmg->Field('MemberGroup'), $tblMg->Field('ID'));
$where = $sql->Equals($tblMmg->Field('Member'), $sql->Value($member->GetID()));
$orderBy = $sql->OrderList($sql->OrderAsc($tblMg->Field('Name')));
return Membergroup::Schema()->Fetch(false, $where, $orderBy, null, 0, null, $join, JoinType::Inner(), $joinCondition);
}
