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 retireSingleGift($lGiftID, $lGroupID)
{
//---------------------------------------------------------------------
// $lGroupID is the recyle bin group id; set to null if deleting
// a single gift
//---------------------------------------------------------------------
global $glUserID;
$sqlStr = "UPDATE gifts\n SET\n gi_bRetired=1,\n gi_lLastUpdateID={$glUserID}\n WHERE gi_lKeyID={$lGiftID};";
$this->db->query($sqlStr);
// if this is a silent auction donation,
// remove gift ID
$sqlStr = "UPDATE gifts_auctions_packages\n SET\n ap_lGiftID = NULL,\n ap_lLastUpdateID = {$glUserID}\n WHERE ap_lGiftID = {$lGiftID};";
$this->db->query($sqlStr);
$uf = new muser_fields();
$uf->deleteForeignViaUFTableType(CENUM_CONTEXT_GIFT, $lGiftID);
$this->logGiftRetire($lGiftID, $lGroupID);
}
public function retireSingleSponsorship($lSponID, &$lGroupID)
{
//---------------------------------------------------------------------
// $lGroupID is the recyle bin group id; set to null if deleting
// a single gift
//---------------------------------------------------------------------
global $glUserID;
$sqlStr = "UPDATE sponsor\n SET\n sp_bRetired=1,\n sp_lLastUpdateID={$glUserID}\n WHERE sp_lKeyID={$lSponID};";
$this->db->query($sqlStr);
$this->logSponsorshipRetire($lSponID, $lGroupID);
// remove UF table entries
$uf = new muser_fields();
$uf->deleteForeignViaUFTableType(CENUM_CONTEXT_SPONSORSHIP, $lSponID);
}
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);
}
