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); }