public class GetPublicpartyAccessToken {
private static Logger logger =
LoggerManager.getInstance().getLogger(GetPublicpartyAccessToken.class.getName());
private static String weixingetpublicpartyaccesstoken =
WebUtils.getProperty("weixin.get_publicparty_access_token_URL", "");
// 获取第三方平台accesstoken //synchronized
public JSONObject getAccessToken(WxPublicpartyControl wppc) {
WePublicparty wpp = wppc.getWePublicparty();
JSONObject accesstokeninfo = new JSONObject();
JSONObject param = new JSONObject();
if (wpp == null
|| nds.util.Validator.isNull(wpp.getAppid())
|| nds.util.Validator.isNull(wpp.getAppsecret())) {
logger.debug("WePublicparty error->");
return accesstokeninfo;
}
try {
param.put("component_appid", wpp.getAppid());
param.put("component_appsecret", wpp.getAppsecret());
param.put("component_verify_ticket", wpp.getComponent_verify_ticket());
} catch (Exception e) {
}
ValueHolder vh = null;
logger.debug("get publicparty access token");
try {
vh = RestUtils.sendRequest_buff(weixingetpublicpartyaccesstoken, param.toString(), "POST");
String result = (String) vh.get("message");
logger.debug("get publicparty access token result->" + result);
JSONObject tjo = new JSONObject(result);
String returns = "获取授权码失败！";
if (tjo != null && tjo.has("component_access_token")) {
accesstokeninfo.put("code", 0);
accesstokeninfo.put("message", "获取成功");
accesstokeninfo.put("data", tjo);
} else {
accesstokeninfo.put("code", -1);
accesstokeninfo.put("message", returns);
}
} catch (Exception e) {
logger.debug("get publicparty access token error->" + e.getLocalizedMessage());
e.printStackTrace();
try {
accesstokeninfo.put("code", -1);
accesstokeninfo.put("message", "获取授权码失败！");
} catch (JSONException e1) {
}
}
return accesstokeninfo;
}
}
/**
* Register user information, will check sesstion attribute "nds.control.web.ValidateMServlet"
* defined in ValidateMServlet
*/
public class RegisterHandler extends RequestHandlerSupport {
private static Logger logger =
LoggerManager.getInstance().getLogger(RegisterHandler.class.getName());
public RegisterHandler() {}
/**
* Find sesstion attribute "nds.control.web.ValidateMServlet" defined in ValidateMServlet, and
* compare with user input named "verifyCode"
*/
public NDSEvent processRequest(HttpServletRequest request) throws NDSEventException {
String serverValidCode =
(String) request.getSession().getAttribute("nds.control.web.ValidateMServlet");
if (serverValidCode == null)
throw new NDSEventException(
"Internal error, nds.control.web.ValidateMServlet not set in session attribute");
String userValidCode = request.getParameter("verifyCode");
if (serverValidCode.equalsIgnoreCase(userValidCode)) {
} else {
throw new NDSEventException("@error-verify-code@");
}
DefaultWebEvent event = new DefaultWebEvent("CommandEvent");
event.setParameter("command", "RegistrateUser");
/**
* add param named "nds.query.querysession", which hold QuerySession object
*
* @since 2.0
*/
SessionContextManager scmanager = WebUtils.getSessionContextManager(request.getSession(true));
UserWebImpl usr = (UserWebImpl) scmanager.getActor(WebKeys.USER);
if (usr != null && usr.getSession() != null)
event.put("nds.query.querysession", usr.getSession());
event.put("JAVA.UTIL.LOCALE", usr.getLocale());
Enumeration enu = request.getParameterNames();
while (enu.hasMoreElements()) {
String name = (String) enu.nextElement();
String[] value = request.getParameterValues(name);
if (name.equalsIgnoreCase("command")) {
/* ############# tony 's method was deferred to EJB layer to implement,
see nds.control.ejb.CommandFactory
event.setParameter(name, commandName(value[0]));
######## yfzhu marked above */
event.setParameter(name, value[0]);
// nmdemo, ObjectPermit and ObjectRollback will also need spName
// if(value[0].endsWith("Submit"))
event.setParameter("spName", value[0]);
} else if (value.length == 1) event.setParameter(name, value[0]);
else event.setParameter(name, value);
}
return event;
}
}
/** * Return JasperReport * * @author [email protected] */ public class JasperReport implements BinaryHandler { private Logger logger = LoggerManager.getInstance().getLogger(JasperReport.class.getName()); public void init(ServletContext context) {} /** * return OutputStream of JasperReport object, this page could only be viewed from localhost for * security concern. parameter can be (id), or (table and type) * * @param id - report id, or * @param table - table name * @param type - reporttype "s","l","o", case insensitive * @param client(*) - client domain * @param version - version number, default to -1 */ public void process(HttpServletRequest request, HttpServletResponse response) throws Exception { String clientName = request.getParameter("client"); int objectId = ParamUtils.getIntAttributeOrParameter(request, "id", -1); if (objectId == -1) { // try using table and type objectId = getReportId(clientName, request.getParameter("table"), request.getParameter("type")); } if (objectId == -1) { logger.error("report not found, request is:" + Tools.toString(request)); throw new NDSException("report not found"); } int version = ParamUtils.getIntAttributeOrParameter(request, "version", -1); File reportXMLFile = new File(ReportTools.getReportFile(objectId, clientName)); if (reportXMLFile.exists()) { // generate jasperreport if file not exists or not newer String reportName = reportXMLFile.getName().substring(0, reportXMLFile.getName().lastIndexOf(".")); File reportJasperFile = new File(reportXMLFile.getParent(), reportName + ".jasper"); if (!reportJasperFile.exists() || reportJasperFile.lastModified() < reportXMLFile.lastModified()) { JasperCompileManager.compileReportToFile( reportXMLFile.getAbsolutePath(), reportJasperFile.getAbsolutePath()); } InputStream is = new FileInputStream(reportJasperFile); response.setContentType("application/octetstream;"); response.setContentLength((int) reportJasperFile.length()); // response.setHeader("Content-Disposition","inline;filename=\""+reportJasperFile.getName()+"\""); ServletOutputStream os = response.getOutputStream(); byte[] b = new byte[8192]; int bInt; while ((bInt = is.read(b, 0, b.length)) != -1) { os.write(b, 0, bInt); } is.close(); os.flush(); os.close(); } else { throw new NDSException("Not found report template"); } } /** * Find report with input, throw exception if could not found. When there's more than one, use id * small one * * @param clientDomain * @param tableName * @param reportType * @return * @throws Exception */ private int getReportId(String clientDomain, String tableName, String reportType) throws Exception { reportType = reportType.toUpperCase(); Table table = nds.schema.TableManager.getInstance().findTable(tableName); if (table == null) throw new NDSException("table " + tableName + " not found."); String sql = "select r.id from ad_report r, ad_client c where c.domain='" + clientDomain + "' and r.ad_table_id=" + table.getId() + " and r.reporttype='" + reportType + "' and c.id=r.ad_client_id order by id asc"; return Tools.getInt(QueryEngine.getInstance().doQueryOne(sql), -1); } }
public class MonitorManager {
private static Logger logger =
LoggerManager.getInstance().getLogger(MonitorManager.class.getName());
private static MonitorManager instance = null;
private boolean isInitialized = false;
private PluginManager<ObjectActionListener> oaLmanager;
private boolean isMonitorPluginInstalled = false;
private CollectionValueHashtable objActionListeners;
private Hashtable<Integer, ObjectActionListener> objActionListenersIds;
private MonitorManager() {
this.objActionListeners = new CollectionValueHashtable();
this.objActionListenersIds = new Hashtable();
}
public String getMonitorRootFolder(String paramString) {
return WebUtils.getProperty("export.root.nds", "/aic/home")
+ File.separator
+ paramString
+ File.separator
+ "monitor";
}
public void checkMonitorPlugin() {
// System.out.print("asdfasdfasd");
if (!this.isMonitorPluginInstalled) {
logger.debug("not install");
throw new NDSRuntimeException("@monitor-not-installed@");
}
logger.debug("installed");
}
public boolean isMonitorPluginInstalled() {
return this.isMonitorPluginInstalled;
}
public void dispatchEvent(ObjectActionEvent paramObjectActionEvent) {
if (!this.isMonitorPluginInstalled) return;
try {
logger.debug("dispatch " + paramObjectActionEvent.getClass().getName());
Collection b =
this.objActionListeners.get(
paramObjectActionEvent.getAdClientId() + "." + paramObjectActionEvent.getTableId());
if (b != null)
for (Iterator it = b.iterator(); it.hasNext(); ) {
ObjectActionListener localObjectActionListener;
localObjectActionListener = (ObjectActionListener) it.next();
localObjectActionListener.onAction(paramObjectActionEvent);
}
return;
} catch (Exception e) {
logger.error("Error dispatch " + paramObjectActionEvent.toString(), e);
throw new NDSRuntimeException("@error-dispatch-monitor-event@:" + e.getMessage());
}
}
private ObjectActionListener createListener(int paramInt) throws Exception {
ObjectActionListener v = (ObjectActionListener) this.oaLmanager.findPlugin("default");
if (v != null) {
try {
ObjectActionListener localObjectActionListener = v.getClass().newInstance();
logger.debug("monid :" + String.valueOf(paramInt));
localObjectActionListener.init(paramInt);
localObjectActionListener.setDebug(true);
return localObjectActionListener;
} catch (Throwable e) {
logger.error("fail to new ObjectActionListener of " + e.getClass(), e);
}
}
return null;
}
public synchronized void reloadListener(int paramInt) throws Exception {
removeListener(paramInt);
ObjectActionListener localObjectActionListener;
localObjectActionListener = createListener(paramInt);
if (localObjectActionListener == null) {
throw new NDSException(
"No implementation for ObjectActionListener, check your plugin configuration");
}
this.objActionListeners.add(
localObjectActionListener.getAdClientId() + "." + localObjectActionListener.getTableId(),
localObjectActionListener);
this.objActionListenersIds.put(Integer.valueOf(paramInt), localObjectActionListener);
}
public synchronized ObjectActionListener removeListener(int paramInt) throws NDSException {
Object localObject;
localObject = (ObjectActionListener) this.objActionListenersIds.get(Integer.valueOf(paramInt));
if (localObject != null) {
Collection b =
this.objActionListeners.get(
((ObjectActionListener) localObject).getAdClientId()
+ "."
+ ((ObjectActionListener) localObject).getTableId());
for (Iterator it = b.iterator(); it.hasNext(); ) {
ObjectActionListener localObjectActionListener;
if ((localObjectActionListener = (ObjectActionListener) it.next()).getId() == paramInt) {
b.remove(localObjectActionListener);
break;
}
}
return (ObjectActionListener) this.objActionListenersIds.remove(Integer.valueOf(paramInt));
}
return null;
}
public synchronized void reloadObjectActionListeners() throws Exception {
this.objActionListeners.clear();
List localList;
try {
localList =
QueryEngine.getInstance()
.doQueryList(
"select id from ad_monitor m where m.check_type='action' and m.monitor_type='obj' and m.isactive='Y'");
} catch (Throwable e) {
throw new NDSException("Fail to read ad_monitor table from db", e);
}
if (localList != null)
for (int i = 0; i < localList.size(); i++) {
int j = Tools.getInt(localList.get(i), -1);
ObjectActionListener localObjectActionListener = createListener(j);
logger.debug("reloadObjectActionListeners complet!");
if (localObjectActionListener == null) {
throw new NDSException(
"No implementation for ObjectActionListener, check your plugin configuration");
}
this.objActionListeners.add(
localObjectActionListener.getAdClientId()
+ "."
+ localObjectActionListener.getTableId(),
localObjectActionListener);
this.objActionListenersIds.put(Integer.valueOf(j), localObjectActionListener);
}
}
public List getModifiableMonitors(Table paramTable, UserWebImpl usr) throws Exception {
// this = (this = TableManager.getInstance()).getTable("ad_monitor");
Table mo_table = TableManager.getInstance().getTable("ad_monitor");
QueryRequestImpl query;
query = QueryEngine.getInstance().createRequest(usr.getSession());
query.setMainTable(mo_table.getId());
query.addSelection(mo_table.getColumn("id").getId());
query.addSelection(mo_table.getColumn("name").getId());
query.addSelection(mo_table.getColumn("monitor_type").getId());
query.addSelection(mo_table.getColumn("check_type").getId());
query.addSelection(mo_table.getColumn("isactive").getId());
query.addOrderBy(new int[] {mo_table.getColumn("name").getId()}, true);
Expression localExpression =
(localExpression =
(localExpression =
(localExpression =
new Expression(
new ColumnLink("ad_monitor.monitor_type"), "=obj", null))
.combine(
new Expression(
new ColumnLink("ad_monitor.monitor_type"), "=list", null),
2,
null))
.combine(usr.getSecurityFilter(mo_table.getName(), 3), 1, null))
.combine(
new Expression(
new ColumnLink("ad_monitor.ad_table_id"), "=" + paramTable.getId(), null),
1,
null);
query.addParam(localExpression);
logger.debug("getModifiableMonitors sql is:" + query.toSQL());
return QueryEngine.getInstance().doQueryList(query.toSQL());
}
public static synchronized MonitorManager getInstance() {
if (instance == null) {
instance = new MonitorManager();
}
if (!instance.isInitialized) {
try {
MonitorManager localMonitorManager = instance;
PluginController localPluginController =
(PluginController)
WebUtils.getServletContextManager().getActor("nds.io.plugincontroller");
localMonitorManager.oaLmanager =
new PluginManager(ObjectActionListener.class, localPluginController.getPluginScanner());
localMonitorManager.oaLmanager.init();
if (localMonitorManager.oaLmanager.findPlugin("default") != null) {
localPluginController.getPluginScanner().addDeploymentListener(new a());
localMonitorManager.reloadObjectActionListeners();
logger.info("Monitor plugin found.");
localMonitorManager.isMonitorPluginInstalled = true;
} else {
localMonitorManager.isMonitorPluginInstalled = false;
logger.warning("Monitor plugin not installed.");
}
localMonitorManager.isInitialized = true;
Velocity.init();
} catch (Exception localException) {
throw new NDSRuntimeException(localException.getMessage(), localException);
}
}
return instance;
}
static class a implements DeploymentListener {
a() {}
public final void urlDeployed(DeploymentEvent paramDeploymentEvent) {
try {
MonitorManager.getInstance().reloadObjectActionListeners();
return;
} catch (Throwable e) {
logger.error("fail to reload listeners", e);
}
}
public final void urlModified(DeploymentEvent paramDeploymentEvent) {
try {
MonitorManager.getInstance().reloadObjectActionListeners();
return;
} catch (Throwable e) {
logger.error("fail to reload listeners", e);
}
}
public final void urlRemoved(DeploymentEvent paramDeploymentEvent) {
try {
MonitorManager.getInstance().reloadObjectActionListeners();
return;
} catch (Throwable e) {
logger.error("fail to reload listeners", e);
}
}
}
}
/**
* Create Sub System view for user
*
* @author yfzhu
*/
public class SubSystemView {
private static Logger logger =
LoggerManager.getInstance().getLogger(SubSystemView.class.getName());
/** People can view the specified subsystem */
public static final int PERMISSION_VIEWABLE = 0;
/** People has no permission on this subsystem */
public static final int PERMISSION_NO_PERM = 1;
/** Company not buy the license for the subsystem */
public static final int PERMISSION_NO_LICENSE = 2;
private List<SubSystem> subSystemNoLicense = null; // elements are SubSystem(not in TableManager)
public SubSystemView() {}
/**
* @param request
* @param permissionType PERMISSION_VIEWABLE, PERMISSION_NO_PERM or PERMISSION_NO_LICENSE
* @return never null, elements are nds.schema.SubSystem
*/
public List<SubSystem> getSubSystems(HttpServletRequest request, int permissionType)
throws Exception {
if (permissionType == PERMISSION_VIEWABLE) return getSubSystems(request);
UserWebImpl userWeb =
((UserWebImpl)
WebUtils.getSessionContextManager(request.getSession())
.getActor(nds.util.WebKeys.USER));
String subsystems =
(String)
QueryEngine.getInstance()
.doQueryOne("SELECT subsystems from users where id=" + userWeb.getUserId());
if (Validator.isNotNull(subsystems)) {
return Collections.EMPTY_LIST;
}
TableManager manager = TableManager.getInstance();
if (permissionType == PERMISSION_NO_PERM) {
ArrayList subs = new ArrayList();
List al = (List) userWeb.getProperty("subsystems"); // elements are subystem.id
if (al == null) {
getSubSystems(request);
al = (List) userWeb.getProperty("subsystems");
}
// no perm
List ss = manager.getSubSystems();
for (int i = 0; i < ss.size(); i++) {
SubSystem sa = (SubSystem) ss.get(i);
boolean found = false;
for (int j = 0; j < al.size(); j++) {
if (((Integer) al.get(j)).intValue() == sa.getId()) {
found = true;
break;
}
}
if (!found) subs.add(sa);
}
return subs;
} // else{
// no license
if (subSystemNoLicense == null) {
subSystemNoLicense = new ArrayList<SubSystem>();
List al =
QueryEngine.getInstance()
.doQueryList(
"select id, name, orderno, iconurl,url from ad_subsystem s where exists(select 1 from ad_tablecategory c where c.ad_subsystem_id=s.id) order by orderno asc");
for (int i = 0; i < al.size(); i++) {
List als = (List) al.get(i);
if (manager.getSubSystem(Tools.getInt(als.get(0), -1)) == null) {
SubSystem ss = new SubSystem();
ss.setId(Tools.getInt(als.get(0), -1));
ss.setName((String) als.get(1));
ss.setOrderno(Tools.getInt(als.get(2), -1));
ss.setIconURL((String) als.get(3));
ss.setPageURL((String) als.get(4));
subSystemNoLicense.add(ss);
}
}
}
return subSystemNoLicense;
// }
}
/**
* Get viewable subsystem list
*
* @param request
* @return never null, elements are nds.schema.SubSystem
*/
public List getSubSystems(HttpServletRequest request) {
UserWebImpl userWeb =
((UserWebImpl)
WebUtils.getSessionContextManager(request.getSession())
.getActor(nds.util.WebKeys.USER));
ArrayList subs = new ArrayList();
if (userWeb.getUserId() == userWeb.GUEST_ID) {
return subs;
}
List al = (List) userWeb.getProperty("subsystems"); // elements are subystem.id
TableManager manager = TableManager.getInstance();
if (al != null) {
for (int i = 0; i < al.size(); i++) {
int sid = ((Integer) al.get(i)).intValue();
SubSystem ss = manager.getSubSystem(sid);
if (ss != null) subs.add(ss);
}
} else {
// search all tablecategoris for subsystem
// add users subsystems param
al = new ArrayList();
String[] sub_list;
try {
String subsystems =
(String)
QueryEngine.getInstance()
.doQueryOne("SELECT subsystems from users where id=" + userWeb.getUserId());
if (Validator.isNotNull(subsystems)) {
sub_list = subsystems.split(",");
for (int m = 0; m < sub_list.length; m++) {
SubSystem usersub = manager.getSubSystem(sub_list[m].trim());
if (usersub != null) {
if (usersub.getId() == 10) continue;
al.add(new Integer(usersub.getId()));
subs.add(usersub);
}
}
userWeb.setProperty("subsystems", al);
return subs;
}
} catch (QueryException e) {
logger.error("Fail to load subsystems from users", e);
}
for (int i = 0; i < manager.getSubSystems().size(); i++) {
SubSystem ss = (SubSystem) manager.getSubSystems().get(i);
if (containsViewableChildren(request, ss)) {
al.add(new Integer(ss.getId()));
subs.add(ss);
}
}
userWeb.setProperty("subsystems", al);
}
return subs;
}
/**
* @param request
* @param subSystemId
* @return
*/
private boolean containsViewableActions(HttpServletRequest request, SubSystem ss) {
List<WebAction> list = ss.getWebActions();
Connection conn = null;
try {
UserWebImpl userWeb =
((UserWebImpl)
WebUtils.getSessionContextManager(request.getSession())
.getActor(nds.util.WebKeys.USER));
conn = QueryEngine.getInstance().getConnection();
HashMap webActionEnv = new HashMap();
webActionEnv.put("connection", conn);
webActionEnv.put("httpservletrequest", request);
webActionEnv.put("userweb", userWeb);
for (int i = 0; i < list.size(); i++) {
WebAction wa = list.get(i);
if (wa.canDisplay(webActionEnv)) {
return true;
}
}
} catch (Throwable t) {
logger.error("Fail to load subsystem webaction", t);
} finally {
try {
if (conn != null) conn.close();
} catch (Throwable te) {
}
}
return false;
}
/**
* if contains one category (and at least one table is menu object), will return true;
*
* @param request
* @param subSystemId
* @return
*/
private boolean containsViewableChildren(HttpServletRequest request, SubSystem ss) {
// Create categories and their tables in hashtable
TableManager manager = TableManager.getInstance();
// Iterator tables = manager.getAllTables().iterator();
// Hashtable categories = new Hashtable(50,20); // key:Integer(category id), values :List of
// table
Integer tableCategoryId;
Table table;
WebAction action;
ArrayList cats = new ArrayList();
Connection conn = null;
try {
UserWebImpl userWeb =
((UserWebImpl)
WebUtils.getSessionContextManager(request.getSession())
.getActor(nds.util.WebKeys.USER));
conn = QueryEngine.getInstance().getConnection();
HashMap webActionEnv = new HashMap();
webActionEnv.put("connection", conn);
webActionEnv.put("httpservletrequest", request);
webActionEnv.put("userweb", userWeb);
List categories = ss.children();
for (int i = 0; i < categories.size(); i++) {
Object o = categories.get(i); // TableCategory or WebAction
if (o instanceof TableCategory) {
TableCategory tc = (TableCategory) o;
List children = tc.children();
ArrayList catschild = new ArrayList();
for (int j = 0; j < children.size(); j++) {
if (children.get(j) instanceof Table) {
table = (Table) children.get(j);
if (!table.isMenuObject()) {
continue;
}
try {
WebUtils.checkTableQueryPermission(table.getName(), request);
} catch (NDSSecurityException e) {
continue;
}
// table is ok for current user to list
return true;
} else if (children.get(j) instanceof WebAction) {
action = (WebAction) children.get(j);
if (action.canDisplay(webActionEnv)) return true;
} else {
throw new NDSRuntimeException(
"Unsupported element in TableCategory children:" + children.get(j).getClass());
}
}
} else if (o instanceof WebAction) {
if (((WebAction) o).canDisplay(webActionEnv)) {
return true;
}
} else {
throw new NDSException(
"Unexpected class in subsystem (id=" + ss.getId() + "), class is " + o.getClass());
}
}
} catch (Throwable t) {
logger.error("Fail to load subsystem tree", t);
} finally {
try {
if (conn != null) conn.close();
} catch (Throwable e) {
}
}
return false;
}
/**
* 事实表和关联报表属于当前传入数组的交叉报表
*
* @param request
* @return elements are ArrayList, first is cxtab id, second is cxtab name
*/
public List getCxtabs(HttpServletRequest request, int tableCategoryId) {
List tables = getChildrenOfTableCategory(request, tableCategoryId, false);
ArrayList<Integer> al = new ArrayList();
for (int i = 0; i < tables.size(); i++) {
al.add(((Table) tables.get(i)).getId());
}
return getCxtabs(request, al);
}
/**
* 事实表和关联报表属于当前传入数组的交叉报表
*
* @param request
* @param tables elements are table.id
* @return elements are ArrayList, first is cxtab id, second is cxtab name
*/
public List getCxtabs(HttpServletRequest request, List<Integer> tables) {
TableManager manager = TableManager.getInstance();
UserWebImpl userWeb =
((UserWebImpl)
WebUtils.getSessionContextManager(request.getSession())
.getActor(nds.util.WebKeys.USER));
StringBuffer sb = new StringBuffer();
for (int i = 0; i < tables.size(); i++) {
// Table t= tables.get(i);
if (i > 0) sb.append(",");
sb.append(tables.get(i));
}
String ts = sb.toString();
try {
Table cxtabTable = manager.getTable("AD_CXTAB");
QueryRequestImpl queryData;
// only pk,dk will be selected, order by ak asc
queryData = QueryEngine.getInstance().createRequest(userWeb.getSession());
queryData.setMainTable(cxtabTable.getId());
queryData.addSelection(cxtabTable.getPrimaryKey().getId());
queryData.addSelection(cxtabTable.getDisplayKey().getId());
Column colOrderNo = cxtabTable.getColumn("orderno");
queryData.setOrderBy(new int[] {colOrderNo.getId()}, true);
queryData.setRange(0, Integer.MAX_VALUE);
Expression expr =
new Expression(
null,
"(AD_CXTAB.AD_TABLE_ID in ("
+ ts
+ ") or exists (select 1 from ad_cxtab_reftable r where r.ad_cxtab_id=AD_CXTAB.id and r.ad_table_id in ("
+ ts
+ ")))",
null);
// set reporttype to "S"
expr =
expr.combine(
new Expression(new ColumnLink("AD_CXTAB.REPORTTYPE"), "=S", null),
SQLCombination.SQL_AND,
null);
expr =
expr.combine(
new Expression(new ColumnLink("AD_CXTAB.ISACTIVE"), "=Y", null),
SQLCombination.SQL_AND,
null);
expr =
expr.combine(
new Expression(new ColumnLink("AD_CXTAB.ISPUBLIC"), "=Y", null),
SQLCombination.SQL_AND,
null);
expr =
expr.combine(
userWeb.getSecurityFilter(cxtabTable.getName(), 1), SQLCombination.SQL_AND, null);
queryData.addParam(expr); // read permission
return QueryEngine.getInstance().doQueryList(queryData.toSQL());
} catch (Throwable t) {
logger.error(
"Fail to load reports for user " + userWeb.getUserId() + " with table ids: " + ts, t);
}
return Collections.EMPTY_LIST;
}
/**
* 事实表属于当前传入数组的交叉报表
*
* @param request
* @param tables elements are table.id
* @return elements are ArrayList, first is cxtab id, second is cxtab name
*/
/*public List getCxtabs(HttpServletRequest request, List<Integer> tables){
TableManager manager=TableManager.getInstance();
UserWebImpl userWeb= ((UserWebImpl)WebUtils.getSessionContextManager(request.getSession()).getActor(nds.util.WebKeys.USER));
StringBuffer ts=new StringBuffer();
for(int i=0;i<tables.size();i++){
//Table t= tables.get(i);
if(i>0 )ts.append(",");
ts.append(tables.get(i));
}
try{
Table cxtabTable= manager.getTable("AD_CXTAB");
QueryRequestImpl queryData;
// only pk,dk will be selected, order by ak asc
queryData=QueryEngine.getInstance().createRequest(userWeb.getSession());
queryData.setMainTable(cxtabTable.getId());
queryData.addSelection(cxtabTable.getPrimaryKey().getId());
queryData.addSelection(cxtabTable.getDisplayKey().getId());
Column colOrderNo=cxtabTable.getColumn("orderno") ;
queryData.setOrderBy( new int[]{ colOrderNo.getId()}, true);
queryData.setRange(0, Integer.MAX_VALUE);
Expression expr= new Expression(new ColumnLink("AD_CXTAB.AD_TABLE_ID")," IN("+ts+")" ,null);
//set reporttype to "S"
expr=expr.combine(new Expression(new ColumnLink("AD_CXTAB.REPORTTYPE"), "=S",null), SQLCombination.SQL_AND,null);
expr=expr.combine(new Expression(new ColumnLink("AD_CXTAB.ISACTIVE"), "=Y",null), SQLCombination.SQL_AND,null);
expr=expr.combine(new Expression(new ColumnLink("AD_CXTAB.ISPUBLIC"), "=Y",null), SQLCombination.SQL_AND,null);
expr=expr.combine(userWeb.getSecurityFilter(cxtabTable.getName(), 1) , SQLCombination.SQL_AND,null);
queryData.addParam(expr);//read permission
return QueryEngine.getInstance().doQueryList(queryData.toSQL());
}catch(Throwable t){
logger.error("Fail to load reports for user "+userWeb.getUserId()+" with table ids: "+ ts, t);
}
return Collections.EMPTY_LIST;
}*/
/**
* @param request
* @param tableCategoryId
* @paqram includeAction if true, will load webactions also
* @return elements are Table or WebAction
*/
public List getChildrenOfTableCategory(
HttpServletRequest request, int tableCategoryId, boolean includeAction) {
TableManager manager = TableManager.getInstance();
WebAction action;
ArrayList cats = new ArrayList();
Connection conn = null;
HashMap webActionEnv = null;
Table table;
UserWebImpl userWeb =
((UserWebImpl)
WebUtils.getSessionContextManager(request.getSession())
.getActor(nds.util.WebKeys.USER));
TableCategory tc = manager.getTableCategory(tableCategoryId);
List children = tc.children();
ArrayList catschild = new ArrayList();
try {
if (includeAction) {
conn = QueryEngine.getInstance().getConnection();
webActionEnv = new HashMap();
webActionEnv.put("connection", conn);
webActionEnv.put("httpservletrequest", request);
webActionEnv.put("userweb", userWeb);
}
for (int j = 0; j < children.size(); j++) {
if (children.get(j) instanceof Table) {
table = (Table) children.get(j);
if (!table.isMenuObject()) {
continue;
}
try {
WebUtils.checkTableQueryPermission(table.getName(), request);
} catch (NDSSecurityException e) {
continue;
}
// table is ok for current user to list
catschild.add(table);
} else if (children.get(j) instanceof WebAction) {
if (includeAction) {
action = (WebAction) children.get(j);
if (action.canDisplay(webActionEnv)) catschild.add(action);
}
} else {
throw new NDSRuntimeException(
"Unsupported element in TableCategory children:" + children.get(j).getClass());
}
}
} catch (Throwable t) {
logger.error("Fail to load subsystem tree", t);
} finally {
try {
if (conn != null) conn.close();
} catch (Throwable e) {
}
}
return catschild;
}
/**
* menu action
*
* @throws Exception cyl
* @param request
* @param tableCategoryId desgin menu list
* @paqram includeAction if true, will load webactions also
* @return elements are Table or WebAction and menu list
*/
public List getChildrenOfTableCategorybymenu(
HttpServletRequest request, int tableCategoryId, boolean includeAction) throws Exception {
TableManager manager = TableManager.getInstance();
WebAction action;
ArrayList cats = new ArrayList();
List children = new ArrayList();
Connection conn = null;
HashMap webActionEnv = null;
Table table;
List al =
QueryEngine.getInstance()
.doQueryList(
"select e.id,e.name from ad_table g,AD_ACCORDION e where g.AD_ACCORDION_id=e.id and g.ad_tablecategory_id="
+ tableCategoryId
+ " group by e.id,e.name,e.orderno order by e.orderno asc");
UserWebImpl userWeb =
((UserWebImpl)
WebUtils.getSessionContextManager(request.getSession())
.getActor(nds.util.WebKeys.USER));
TableCategory tc = manager.getTableCategory(tableCategoryId);
if (tc != null) children = tc.children();
// ArrayList prow= new ArrayList();
if (al.size() > 0) {
for (int i = 0; i < al.size(); i++) {
List als = (List) al.get(i);
int ACCORDION = Tools.getInt(als.get(0), -1);
logger.debug("ACCORDION~~~~~~~~~~" + String.valueOf(ACCORDION));
ArrayList catschild = new ArrayList();
String ACCORDION_name = (String) als.get(1);
try {
if (includeAction) {
conn = QueryEngine.getInstance().getConnection();
webActionEnv = new HashMap();
webActionEnv.put("connection", conn);
webActionEnv.put("httpservletrequest", request);
webActionEnv.put("userweb", userWeb);
}
for (int j = 0; j < children.size(); j++) {
if (children.get(j) instanceof Table) {
table = (Table) children.get(j);
// logger.debug("getAccordid~~~~~~~~~~"+String.valueOf(table.getAccordid()));
if (!table.isMenuObject()) {
continue;
} else if (ACCORDION != table.getAccordid()) {
// logger.debug(String.valueOf(ACCORDION)+"!="+String.valueOf(table.getAccordid()));
continue;
}
try {
WebUtils.checkTableQueryPermission(table.getName(), request);
} catch (NDSSecurityException e) {
continue;
}
// table is ok for current user to list
logger.debug(String.valueOf(ACCORDION) + "&&" + String.valueOf(table.getAccordid()));
catschild.add(table);
} else if (children.get(j) instanceof WebAction) {
if (includeAction) {
action = (WebAction) children.get(j);
if (action.canDisplay(webActionEnv) && (action.getAcordionId() == ACCORDION)) {
logger.debug("add action" + String.valueOf(ACCORDION));
// System.out.print("add action"+String.valueOf(ACCORDION));
// System.out.print("action name"+String.valueOf(action.getName()));
// System.out.print("ACCORDION name"+String.valueOf(ACCORDION));
// System.out.print("action
// name"+String.valueOf(action.getAcordionId()));
catschild.add(action);
}
}
} else {
throw new NDSRuntimeException(
"Unsupported element in TableCategory children:" + children.get(j).getClass());
}
}
} catch (Throwable t) {
logger.error("Fail to load subsystem tree", t);
} finally {
try {
if (conn != null) conn.close();
} catch (Throwable e) {
}
}
if (catschild.size() > 0) {
// show this category
ArrayList row = new ArrayList();
row.add(ACCORDION_name);
row.add(catschild);
cats.add(row);
}
}
return cats;
} else {
ArrayList catschild1 = new ArrayList();
try {
if (includeAction) {
conn = QueryEngine.getInstance().getConnection();
webActionEnv = new HashMap();
webActionEnv.put("connection", conn);
webActionEnv.put("httpservletrequest", request);
webActionEnv.put("userweb", userWeb);
}
for (int j = 0; j < children.size(); j++) {
if (children.get(j) instanceof Table) {
table = (Table) children.get(j);
if (!table.isMenuObject()) {
continue;
}
try {
WebUtils.checkTableQueryPermission(table.getName(), request);
} catch (NDSSecurityException e) {
continue;
}
// table is ok for current user to list
catschild1.add(table);
} else if (children.get(j) instanceof WebAction) {
if (includeAction) {
action = (WebAction) children.get(j);
if (action.canDisplay(webActionEnv)) catschild1.add(action);
}
} else {
throw new NDSRuntimeException(
"Unsupported element in TableCategory children:" + children.get(j).getClass());
}
}
} catch (Throwable t) {
logger.error("Fail to load subsystem tree", t);
} finally {
try {
if (conn != null) conn.close();
} catch (Throwable e) {
}
}
if (catschild1.size() > 0) {
// show this category
ArrayList row = new ArrayList();
row.add(tc.getName());
row.add(catschild1);
cats.add(row);
}
}
return cats;
}
/**
* MU_FAVORITE
*
* @throws Exception cyl
* @param request
* @return elements are Table or WebAction and menu list
* @paqram includeAction if true?not now
*/
public List getSubSystemsOfmufavorite(HttpServletRequest request) throws Exception {
ArrayList mufavorite = new ArrayList();
TableManager manager = TableManager.getInstance();
// Table table;
try {
UserWebImpl userWeb =
((UserWebImpl)
WebUtils.getSessionContextManager(request.getSession())
.getActor(nds.util.WebKeys.USER));
int userid = userWeb.getUserId();
List al =
QueryEngine.getInstance()
.doQueryList(
"select t.ad_table_id,t.fa_menu,t.menu_re,t.IS_REPORT from MU_FAVORITE t where t.ownerid="
+ String.valueOf(userid)
+ " group by t.ad_table_id,t.menu_no,t.fa_menu,t.menu_re,t.IS_REPORT,t.creationdate order by t.menu_no,t.creationdate asc");
logger.debug("MU_FAVORITE size is " + String.valueOf(al.size()));
if (al.size() > 0) {
for (int i = 0; i < al.size(); i++) {
// ArrayList catschild= new ArrayList();
List als = (List) al.get(i);
String fa_menu = (String) als.get(1);
String menu_re = (String) als.get(2);
String isreport = (String) als.get(3);
int table_id = Tools.getInt(als.get(0), -1);
Table table = manager.getTable(table_id);
logger.debug(table.getName());
/*
if(!table.isMenuObject()){
continue;
//because many table is webaction not ismenuobject
}*/
try {
WebUtils.checkTableQueryPermission(table.getName(), request);
} catch (NDSSecurityException e) {
continue;
}
logger.debug("add_table ->" + table.getName());
ArrayList row = new ArrayList();
row.add(fa_menu);
row.add(menu_re);
row.add(isreport);
row.add(table);
mufavorite.add(row);
}
}
} catch (Throwable t) {
logger.error("Fail to load mufavorite", t);
}
return mufavorite;
}
/**
* Return table categories and table that user has view permission
*
* @param request
* @param subSystemId
* @return never null, elements are List, containing 2 elements: 1)when first element is
* nds.schema.TableCategory, then second will be java.util.List (nds.schema.Table or
* nds.schema.WebAction) 2) when first element is nds.schema.WebAction, then second is null
*/
public List getTableCategories(HttpServletRequest request, int subSystemId) {
return getTableCategories(request, subSystemId, true);
}
/**
* Return table categories and table that user has view permission
*
* @param request
* @param subSystemId
* @return never null, elements are List, containing 2 elements: 1)when first element is
* nds.schema.TableCategory, then second will be java.util.List (nds.schema.Table or
* nds.schema.WebAction) 2) when first element is nds.schema.WebAction, then second is null
*/
public List getTableCategories(
HttpServletRequest request, int subSystemId, boolean includeActions) {
// Create categories and their tables in hashtable
TableManager manager = TableManager.getInstance();
// Iterator tables = manager.getAllTables().iterator();
// Hashtable categories = new Hashtable(50,20); // key:Integer(category id), values :List of
// table
SubSystem ss;
Integer tableCategoryId;
Table table;
WebAction action;
ArrayList cats = new ArrayList();
Connection conn = null;
HashMap webActionEnv = null;
try {
UserWebImpl userWeb =
((UserWebImpl)
WebUtils.getSessionContextManager(request.getSession())
.getActor(nds.util.WebKeys.USER));
if (includeActions) {
conn = QueryEngine.getInstance().getConnection();
webActionEnv = new HashMap();
webActionEnv.put("connection", conn);
webActionEnv.put("httpservletrequest", request);
webActionEnv.put("userweb", userWeb);
}
List categories = manager.getSubSystem(subSystemId).children();
for (int i = 0; i < categories.size(); i++) {
Object o = categories.get(i); // TableCategory or WebAction
if (o instanceof TableCategory) {
TableCategory tc = (TableCategory) o;
List children = tc.children();
ArrayList catschild = new ArrayList();
for (int j = 0; j < children.size(); j++) {
if (children.get(j) instanceof Table) {
table = (Table) children.get(j);
if (!table.isMenuObject()) {
continue;
}
try {
WebUtils.checkTableQueryPermission(table.getName(), request);
} catch (NDSSecurityException e) {
continue;
}
// table is ok for current user to list
catschild.add(table);
} else if (children.get(j) instanceof WebAction) {
if (includeActions) {
action = (WebAction) children.get(j);
if (action.canDisplay(webActionEnv)) catschild.add(action);
}
} else {
throw new NDSRuntimeException(
"Unsupported element in TableCategory children:" + children.get(j).getClass());
}
}
if (catschild.size() > 0) {
// show this category
ArrayList row = new ArrayList();
row.add(tc);
row.add(catschild);
cats.add(row);
}
} else if (o instanceof WebAction) {
if (includeActions && ((WebAction) o).canDisplay(webActionEnv)) {
ArrayList row = new ArrayList();
row.add(o);
row.add(Collections.EMPTY_LIST);
cats.add(row);
}
} else {
throw new NDSException(
"Unexpected class in subsystem (id=" + subSystemId + "), class is " + o.getClass());
}
}
} catch (Throwable t) {
logger.error("Fail to load subsystem tree", t);
} finally {
try {
if (conn != null) conn.close();
} catch (Throwable e) {
}
}
return cats;
}
}