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