newaccesslogimpl.java

电信的网厅的整站代码

				if(!sNodeId.equals("959") && !sNodeId.equals("1201")) {
					StringBuffer sql = new StringBuffer();
					sql.append("select count(1) from td_report_tree where   state='E'");
					TD_Report_tree td_report_tree = new TD_Report_tree(new DacClient(),Long.parseLong(sNodeId));
					Object ap[] = new Object[1];
					ap[0] = td_report_tree.getIndexCode();
					String tmp = db.getStringFromSqlQuery(sql.toString(), ap);
					if(tmp != null) {
						if(Integer.parseInt(tmp) > 1) str = "0";
						else str = "1";
					}
					else str = "1";
				}
				else {
					str = "0";
				}
			}
			
		}catch(Exception e) {
			str = "1";
			FileLogger.getLogger().info(e.getMessage(),e);
		}
		return str;
	}
	/**获取标题
	 * 
	 * @param request
	 * @param response
	 * @param _map
	 * @return
	 */
	public  String getTitle(ServletRequest request, ServletResponse response, Map _map) {
		String title = "";
		try {
			String sNodeId = (String) _map.get("NODEID");
			if(sNodeId != null) {
					title = this.getNodeName(sNodeId);
				}
				else {
					title = "系统访问量";
				}
		}catch(Exception e) {
			FileLogger.getLogger().info(e.getMessage(),e);
		}

		return title;
	}
	public String getNodeName(String sNodeId) {
		DacClient db = new DacClient();
		String sNodeName="";
		try {
		StringBuffer selectSql = new StringBuffer();
		selectSql.append(" select NODENAME from td_report_node ");
		selectSql.append(" where state='E' and nodeid=? and rownum=1");//三级
		Object ap[] = new Object[1];
		ap[0]=sNodeId;
		DataTable dt=db.executeQuery(selectSql.toString(), ap);
		if ((dt!=null)&&(dt.getRows().getCount() != 0 )) {
			sNodeName=dt.getRow(0).getString("NODENAME");
		}
		
		} catch (Exception e) {
			FileLogger.getLogger().warn(e.getMessage(), e);
		}
		return sNodeName;
	}
	public boolean hasNext(String sNodeId) {
		DacClient db = new DacClient();
		boolean hasNext=false;
		String COUNT="";
		try {
		StringBuffer selectSql = new StringBuffer();
		selectSql.append(" select count(ACTION_STATE) COUNT1 from TL_REPORTOFDAY ");
		selectSql.append(" where nodeid=? and TYPE=2");//有子级
		Object ap[] = new Object[1];
		ap[0]=sNodeId;
		DataTable dt=db.executeQuery(selectSql.toString(), ap);
		if ((dt!=null)&&(dt.getRows().getCount() != 0 )) {
			COUNT=dt.getRow(0).getString("COUNT1");
		}} catch (Exception e) {
			FileLogger.getLogger().warn(e.getMessage(), e);
		}
		if (!COUNT.equals("0"))
			hasNext=true;
		return hasNext;
	}
	public String getNodeId(String type) {
		DacClient db = new DacClient();
		String sNodeID="";
		try {
		StringBuffer selectSql = new StringBuffer();
	
		selectSql.append(" select NODEID from td_report_node ");
		selectSql.append(" where state='E' and nodename=? and type=?");//三级
		Object ap[] = new Object[2];
		if (type!=null&&type.equals("1")) {
		ap[0]="系统访问量";
		ap[1]="1";}
		if (type!=null&&type.equals("2")) {
		ap[0]="业务受理量";
		ap[1]="2";}
		DataTable dt=db.executeQuery(selectSql.toString(), ap);
		if ((dt!=null)&&(dt.getRows().getCount() != 0 )) {
			sNodeID=dt.getRow(0).getString("NODEID");
		}
		} catch (Exception e) {
			FileLogger.getLogger().warn(e.getMessage(), e);
		}
		return sNodeID;
	}
	/**判断该模块是否有下级
	 * 
	 * @param request
	 * @param response
	 * @param _map
	 * @return
	 */
	public static String isEntitiy(ServletRequest request, ServletResponse response, Map _map) {
		String isEntity = "";
		StringBuffer _sb = new StringBuffer();
		DacClient db = new DacClient(); 
		List oParam = new ArrayList();
		
		try {
		String sNodeId = (String) _map.get("NODEID");
		String sOptype = (String) _map.get("OPTYPE");
		_sb.append(" select d.* ");
		_sb.append(" from TD_REPORT_NODE d ");
		_sb.append(" where d.upnodeid =   ? and state='E' and type=? ");
		oParam.add(sNodeId);
		oParam.add(sOptype);
		Object ap[] = new Object[oParam.size()];
		for (int i = 0; i < ap.length; i++) {
			ap[i] = oParam.get(i);
		}
		DataTable dt=  db.executeQuery(_sb.toString(), ap);
		if ((dt!=null)&&(dt.getRows().getCount() != 0 )) {
			 isEntity = "0";	
		}
		else
			 isEntity = "1";
 		return isEntity;
		} catch (Exception e) {
			FileLogger.getLogger().warn(e.getMessage(), e);
		}
		return "1";
	}
	
	/**保存历史记录
	 * 
	 * @param request
	 * @param response
	 * @param _map
	 * @return "1"  表示失败，"0"  表示成功
	 */
	public static String setHistory(HttpServletRequest request, HttpServletResponse response, Map _map) {
		String str = "1";
		try {
			String count = (String) _map.get("count");
			HttpServletRequest req = (HttpServletRequest)request;
			HttpSession session = req.getSession();
			session.removeAttribute(count);
			session.setAttribute(count, _map);
			str = "0";
		}catch(Exception e) {
			FileLogger.getLogger().info(e.getMessage(),e);
		}
		return str;
	}
	
	public static String getHistoryPid(HttpServletRequest request,HttpServletResponse response, Map _map) {
		String pid = "";
		try {
			pid = AccesslogImpl.getHistoryByName(request,response,_map,"pid");
			if (pid == null) pid = "";
		}catch(Exception e) {
			FileLogger.getLogger().info(e.getMessage(),e);
		}
		return pid;
	}
	
	public static String getHistoryLevel(HttpServletRequest request,HttpServletResponse response, Map _map) {
		String level = "";
		try {
			level = AccesslogImpl.getHistoryByName(request,response,_map,"level");
			if (level == null) level = "";
		}catch(Exception e) {
			FileLogger.getLogger().info(e.getMessage(),e);
		}
		return level;
	}
	
	public static String getHistoryCityCode(HttpServletRequest request,HttpServletResponse response, Map _map) {
		String cityCode = "";
		try {
			cityCode = AccesslogImpl.getHistoryByName(request,response,_map,"cityCode");
			if (cityCode == null) cityCode = "";
		}catch(Exception e) {
			FileLogger.getLogger().info(e.getMessage(),e);
		}
		return cityCode;
	}
	
	public static String getHistoryAreaCode(HttpServletRequest request,HttpServletResponse response, Map _map) {
		String areaCode = "";
		try {
			areaCode = AccesslogImpl.getHistoryByName(request,response,_map,"areaCode");
			if (areaCode == null) areaCode = "";
		}catch(Exception e) {
			FileLogger.getLogger().info(e.getMessage(),e);
		}
		return areaCode;
	}
	
	public static String getHistoryClientType(HttpServletRequest request,HttpServletResponse response, Map _map) {
		String clientType = "";
		try {
			clientType = AccesslogImpl.getHistoryByName(request,response,_map,"clientType");
			if (clientType == null) clientType = "";
		}catch(Exception e) {
			FileLogger.getLogger().info(e.getMessage(),e);
		}
		return clientType;
	}
	public static String getHistorySEARNAME(HttpServletRequest request,HttpServletResponse response, Map _map) {
		String SEARNAME = "";
		try {
			SEARNAME = AccesslogImpl.getHistoryByName(request,response,_map,"SEARNAME");
			if (SEARNAME == null) SEARNAME = "";
		}catch(Exception e) {
			FileLogger.getLogger().info(e.getMessage(),e);
		}
		return SEARNAME;
	}
	public static String getHistoryOPLEVEL(HttpServletRequest request,HttpServletResponse response, Map _map) {
		String OPLEVEL = "";
		try {
			OPLEVEL = AccesslogImpl.getHistoryByName(request,response,_map,"OPLEVEL");
			if (OPLEVEL == null) OPLEVEL = "";
		}catch(Exception e) {
			FileLogger.getLogger().info(e.getMessage(),e);
		}
		return OPLEVEL;
	}
	public static String getHistoryNODEID(HttpServletRequest request,HttpServletResponse response, Map _map) {
		String NODEID = "";
		try {
			NODEID = AccesslogImpl.getHistoryByName(request,response,_map,"NODEID");
			if (NODEID == null) NODEID = "";
		}catch(Exception e) {
			FileLogger.getLogger().info(e.getMessage(),e);
		}
		return NODEID;
	}
	public static String getHistoryAPPLYTYPE(HttpServletRequest request,HttpServletResponse response, Map _map) {
		String APPLYTYPE = "";
		try {
			APPLYTYPE = AccesslogImpl.getHistoryByName(request,response,_map,"APPLYTYPE");
			if (APPLYTYPE == null) APPLYTYPE = "";
		}catch(Exception e) {
			FileLogger.getLogger().info(e.getMessage(),e);
		}
		return APPLYTYPE;
	}
	public static String getHistoryORDERTYPE(HttpServletRequest request,HttpServletResponse response, Map _map) {
		String ORDERTYPE = "";
		try {
			ORDERTYPE = AccesslogImpl.getHistoryByName(request,response,_map,"ORDERTYPE");
			if (ORDERTYPE == null) ORDERTYPE = "";
		}catch(Exception e) {
			FileLogger.getLogger().info(e.getMessage(),e);
		}
		return ORDERTYPE;
	}
	public static String getHistoryOPTYPE(HttpServletRequest request,HttpServletResponse response, Map _map) {
		String OPTYPE = "";
		try {
			OPTYPE = AccesslogImpl.getHistoryByName(request,response,_map,"OPTYPE");
			if (OPTYPE == null) OPTYPE = "";
		}catch(Exception e) {
			FileLogger.getLogger().info(e.getMessage(),e);
		}
		return OPTYPE;
	}

	
	public static String getHistoryStartTime(HttpServletRequest request,HttpServletResponse response, Map _map) {
		String startTime = "";
		try {
			startTime = AccesslogImpl.getHistoryByName(request,response,_map,"startTime");
			if (startTime == null) startTime = "";
		}catch(Exception e) {
			FileLogger.getLogger().info(e.getMessage(),e);
		}
		return startTime;
	}
	
	public static String getHistoryEndTime(HttpServletRequest request,HttpServletResponse response, Map _map) {
		String endTime = "";
		try {
			endTime = AccesslogImpl.getHistoryByName(request,response,_map,"endTime");
			if (endTime == null) endTime = "";
		}catch(Exception e) {
			FileLogger.getLogger().info(e.getMessage(),e);
		}
		return endTime;
	}
	
	public static String getHistoryTitle(HttpServletRequest request,HttpServletResponse response, Map _map) {
		String title = "";
		try {
			title = AccesslogImpl.getHistoryByName(request,response,_map,"title");
			if (title == null) title = "";
		}catch(Exception e) {
			FileLogger.getLogger().info(e.getMessage(),e);
		}
		return title;
	}
	
	public static String getHistoryByName(HttpServletRequest request,HttpServletResponse response, Map _map,String name) {
		String value = "";
		try {
			String count = (String) _map.get("count");
			HttpServletRequest req = (HttpServletRequest)request;
			HttpSession session = req.getSession();
			_map = (Map)session.getAttribute(count);
			value = (String)_map.get(name);
			if (value == null) value = "";
		}catch(Exception e) {
			FileLogger.getLogger().info(e.getMessage(),e);
		}
		return value;
	}
	

}