/* */ @Transactional(propagation = Propagation.REQUIRED) /* */ public void delete(Integer id) { /* 144 */ EopSite site = get(id); /* */ /* 146 */ Integer userid = site.getUserid(); /* 147 */ Integer siteid = site.getId(); /* */ /* 150 */ String sql = "show tables like '%_" + userid + "_" + siteid + "'"; /* 151 */ List tableList = this.daoSupport.queryForList(sql, new StringMapper(), new Object[0]); /* 152 */ for (String tbName : tableList) { /* 153 */ sql = "drop table if exists " + tbName; /* 154 */ this.daoSupport.execute(sql, new Object[0]); /* */ } /* */ /* 158 */ sql = "delete from eop_sitedomain where siteid = ?"; /* 159 */ this.daoSupport.execute(sql, new Object[] {id}); /* 160 */ sql = "delete from eop_site where id = ?"; /* 161 */ this.daoSupport.execute(sql, new Object[] {id}); /* */ /* 164 */ String userTplFile = EopSetting.EOP_PATH + "/user/" + userid + "/" + siteid; /* */ /* 166 */ String userStyleFile = EopSetting.IMG_SERVER_PATH + "/user/" + userid + "/" + siteid; /* */ /* 168 */ FileUtil.delete(userTplFile); /* 169 */ FileUtil.delete(userStyleFile); /* */ }