public function removeClient($lClientID) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- global $glUserID; $sqlStr = "UPDATE client_records\n SET\n cr_lLastUpdateID = {$glUserID},\n cr_bRetired = 1\n WHERE cr_lKeyID={$lClientID};"; $query = $this->db->query($sqlStr); // remove group membership $clsGroups = new mgroups(); $clsGroups->removeMemFromAllGroups(CENUM_CONTEXT_CLIENT, $lClientID); // delete client entries in personalized tables $uf = new muser_fields(); $uf->deleteForeignViaUFTableType(CENUM_CONTEXT_CLIENT, $lClientID); $uf->deleteForeignViaUFTableType(CENUM_CONTEXT_CPROGENROLL, $lClientID); $uf->deleteForeignViaUFTableType(CENUM_CONTEXT_CPROGATTEND, $lClientID); $uf->deleteForeignViaUFTableType(CENUM_CONTEXT_CPREPOST, $lClientID); }
public function removePersonBiz($bBiz = false) { //----------------------------------------------------------------------- // caller must first set // $this->lPeopleID (set to bizID if business) // // note that both businesses and people are removed from this routine //----------------------------------------------------------------------- global $glUserID; if (is_null($this->lPeopleID)) { screamForHelp('PEOPLE ID NOT SET!<br>error on <b>line:</b> ' . __LINE__ . '<br><b>file: </b>' . __FILE__ . '<br><b>function: </b>' . __FUNCTION__); } $lPID = $this->lPeopleID; $sqlStr = "UPDATE people_names\n SET\n pe_bRetired=1,\n pe_lLastUpdateID={$glUserID}\n WHERE pe_lKeyID={$lPID};"; $this->db->query($sqlStr); $lGroupID = null; $this->logPeopleRetire($lGroupID); //----------------------------- // remove associated gifts //----------------------------- $clsGifts = new mdonations(); $clsGifts->retireGiftsViaPID($lPID, $lGroupID); //--------------------------------- // remove associated sponsorships //--------------------------------- $clsSpon = new msponsorship(); $clsSpon->retireSponsorshipsViaPID($lPID, $lGroupID); //--------------------------------- // remove business contacts //--------------------------------- $clsBiz = new mbiz(); $clsBiz->lPID = $lPID; $clsBiz->deleteBizContact(false, true, false, $lGroupID); //--------------------------------- // remove group membership //--------------------------------- $clsGroups = new mgroups(); $clsGroups->removeMemFromAllGroups($bBiz ? CENUM_CONTEXT_BIZ : CENUM_CONTEXT_PEOPLE, $lPID); // delete people/biz entries in personalized tables $uf = new muser_fields(); $uf->deleteForeignViaUFTableType(CENUM_CONTEXT_PEOPLE, $lPID); $uf->deleteForeignViaUFTableType(CENUM_CONTEXT_BIZ, $lPID); $uf->deleteForeignViaUFTableType(CENUM_CONTEXT_VOLUNTEER, $lPID); }