function DeleteCompany($Id, $NoRedir = false)
{
global $Db, $nsProduct, $Logs, $Lang;
$Users = array();
$Query = "SELECT USER_ID FROM " . PFX . "_tracker_user WHERE COMPANY_ID={$Id}";
$Sql = new Query($Query);
while ($Row = $Sql->Row()) {
$Users[] = $Row->USER_ID;
}
for ($i = 0; $i < count($Users); $i++) {
$Query = "DELETE FROM " . PFX . "_system_user WHERE ID = " . $Users[$i];
$Db->Query($Query);
$Query = "DELETE FROM " . PFX . "_tracker_user WHERE USER_ID = " . $Users[$i];
$Db->Query($Query);
$Query = "DELETE FROM " . PFX . "_tracker_user_column WHERE USER_ID = " . $Users[$i];
$Db->Query($Query);
$Query = "DELETE FROM " . PFX . "_tracker_user_settings WHERE USER_ID = " . $Users[$i];
$Db->Query($Query);
}
$Query = "SELECT ID FROM " . PFX . "_tracker_site WHERE COMPANY_ID={$Id}";
$Sql = new Query($Query);
while ($Row = $Sql->Row()) {
DeleteHost($Id, $Row->ID, false, true);
}
DeleteCompanyActions($Id);
DeleteCompanySaleItems($Id);
$Query = "SELECT ID FROM " . PFX . "_tracker_campaign WHERE PARENT_ID=0 AND COMPANY_ID={$Id}";
$Sql = new Query($Query);
while ($Row = $Sql->Row()) {
DeleteCampaign($Row->ID, true);
}
$Query = "DELETE FROM " . PFX . "_tracker_config WHERE COMPANY_ID={$Id}";
$Db->Query($Query);
$Query = "DELETE FROM " . PFX . "_tracker_const_group WHERE COMPANY_ID={$Id}";
$Db->Query($Query);
$Query = "DELETE FROM " . PFX . "_tracker_user_report WHERE COMPANY_ID={$Id}";
$Db->Query($Query);
$Query = "DELETE FROM " . PFX . "_tracker_watch WHERE COMPANY_ID={$Id}";
$Db->Query($Query);
DropStatTables($Id);
$Query = "DELETE FROM " . PFX . "_tracker_client WHERE ID = {$Id}";
$Db->Query($Query);
if (!$NoRedir) {
$nsProduct->Redir("company", "RDlt=1");
}
}
}
$CpId = $CompId;
if (!ValidId($CpId)) {
$nsProduct->Redir("default");
}
/////////////////////////////////////////////
///////// call any process functions
if (!$nsUser->DEMO) {
if (ValidId($EditId) && isset($EditArr) && is_array($EditArr)) {
UpdateCampaign($EditId, $EditArr);
}
if (isset($EditId) && $EditId == "new" && isset($EditArr) && is_array($EditArr)) {
CreateCampaign($EditArr, $ParentId);
}
if (ValidId($DeleteId)) {
DeleteCampaign($CpId, $DeleteId);
}
if (ValidId($MoveId) && ValidId($MoveTo)) {
MoveCampaign($MoveId, $MoveTo);
}
if (ValidId($SortId) && isset($SortTo) && ValidId($ParentId)) {
SortTable(PFX . "_tracker_campaign", false, $SortId, $SortTo, "PARENT_ID={$ParentId}");
}
}
/////////////////////////////////////////////
///////// display section here
//// campaigns tree
if (!isset($EditId) || !ValidId($EditId) && $EditId != "new") {
UserColumns();
$SubMenu[0]['Name'] = $Lang['AddGroup'];
$SubMenu[0]['Link'] = getURL("campaign", "EditId=new");
