private function AddGroups($member) { //Clear groups (although none should exist...) $memMemGrps = MemberMembergroup::Schema()->FetchByMember(false, $member); foreach ($memMemGrps as $memMemGrp) { $memMemGrp->Delete(); } $confGroups = RegisterConfirmMembergroup::Schema()->FetchByConfirm(false, $this->confirm); foreach ($confGroups as $confGroup) { $memMemGrp = new MemberMembergroup(); $memMemGrp->SetMember($member); $memMemGrp->SetMemberGroup($confGroup->GetMemberGroup()); $memMemGrp->Save(); } }
private function ClearMembergroups(array $selectedIDs) { $sql = Access::SqlBuilder(); $tblConfirmGroup = RegisterConfirmMembergroup::Schema()->Table(); $where = $sql->Equals($tblConfirmGroup->Field('Confirm'), $sql->Value($this->confirm->GetID())); if (count($selectedIDs)) { $where = $where->And_($sql->NotIn($tblConfirmGroup->Field('MemberGroup'), $sql->InListFromValues($selectedIDs))); } RegisterConfirmMembergroup::Schema()->Delete($where); }