selectservicelist.java

电信的网厅的整站代码

package com.doone.fj1w.fjmgr.rpt;

import java.util.ArrayList;
import com.doone.data.*;
import com.doone.util.ExtString;
import com.doone.util.FileLogger;

import java.util.HashMap;
import java.util.Hashtable;
import java.util.List;
import java.util.Map;
import java.util.TreeMap;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;

public class SelectServiceList {
	
	public static Map getDskSlfLevel(Map param) {
		Map map = new Hashtable();
		map.put("A", "全部");
		map.put("1", "一级");
		map.put("2", "二级");
		map.put("3", "三级");
		return map;
	}
	
	public static Map getClientTypeList(Map param) {
		Map map = new Hashtable();
		map.put("A", "全部");
		map.put("0", "游客");
		map.put("U", "注册帐号");
		map.put("P", "产品登录客户");
		map.put("E", "内部员工");
		map.put("B", "大客户");
		map.put("UP", "关联的产品登录客户");
		return map;
	}

	public static Map getQueryTypeList(Map param) {
		Map map = new Hashtable();
		map.put("ML", "默认");
		//map.put("NN", "年");
		//map.put("JJ", "季");
		//map.put("YE", "月");
		//map.put("XU", "旬");
		//map.put("ZH", "周");
		//map.put("RI", "日");
		
		return map;
	}
	
	public static Map getApplyTypeList(Map param) {
		Map map = new Hashtable();
		/*map.put("5", "变更");
		map.put("4", "取消");
		map.put("3", "设置");
		map.put("2", "关");
		map.put("1", "开");		
		map.put("0", "全部");*/
		
		map.put("5", "变更");
		map.put("4", "取消");
		map.put("3", "设置");
		map.put("2", "关");
		map.put("1", "开");		
		map.put("6", "全部");		
		
		return map;
	}
/*	public static String getApplyTypeList1() {
		Map map = new Hashtable();
		StringBuffer s = new StringBuffer();
		s.append("<select name='APPLYTYPE' id='APPLYTYPE' style='width:100%'>");
		s.append("<option value='6' selected>全部</option>");
		s.append("<option value='变更'>变更</option>");
		s.append("<option value='取消'>取消</option>");
		s.append("<option value='设置'>设置</option>");
		s.append("<option value='关'>关</option>");
		s.append("<option value='开'>开</option>");
		s.append("</select>");
		return s.toString();
	}*/
	
	public static Map getApplyTypeList1(Map param) {
		Map map = new Hashtable();
		map.put("6", "全部");
		map.put("变更", "变更");
		map.put("取消", "取消");
		map.put("设置", "设置");
		map.put("关", "关");
		map.put("开", "开");
		return map;
	}	
	public static Map getProductTypeList(Map param) {
		Map map = new Hashtable();
		map.put("3", "宽带");
		map.put("1", "固定电话");
		map.put("2", "小灵通");
		map.put("A", "全部");
		
		return map;
	}
	
	public static Map getStatisticTypeList(Map param) {
		Map map = new Hashtable();
		map.put("1", "每月");
		map.put("2", "每天");
		
		return map;
	}
	
	public static Map getFJ1000rptTypeList(Map param) {
		Map map = new Hashtable();
		map.put("2", "各地处理完毕工单情况统计报表");
		map.put("1", "各地工单第一次处理情况统计报表");
		
		return map;
	}

	
	public static Map getTypeList(Map param) {
		Map map = new Hashtable();
		map.put("N", "新业务");
		map.put("T", "套餐");
		map.put("C", "程控");
		
		return map;
	}
	//以下是为帐单寄送添加的map
	public static Map getMailTypeList(Map param) {
		Map map = new Hashtable();
		map.put("1", "帐单");
		map.put("2", "长途清单");
		map.put("3", "上网清单");
		map.put("4", "信息费清单");
		map.put("5", "全部");
		return map;
	}
	//以下是为帐单寄送添加的map
	public static Map getMailSuccOrFailList(Map param) {
		Map map = new Hashtable();
		map.put("1", "全部");
		map.put("2", "寄送成功");
		map.put("3", "寄送失败");
		return map;
	}
	public static Map getMailYearList(Map param) {
		Map map = new Hashtable();
		map.put("2006", "2006");
		map.put("2007", "2007");
		map.put("2008", "2008");
		map.put("2009", "2009");
		map.put("2010", "2010");
		return map;
	}
	
	public static Map getMailMonthList(Map param) {
		Map map = new Hashtable();
		map.put("1", "1");
		map.put("2", "2");
		map.put("3", "3");
		map.put("4", "4");
		map.put("5", "5");
		map.put("6", "6");
		map.put("7", "7");
		map.put("8", "8");
		map.put("9", "9");
		map.put("10", "10");
		map.put("11", "11");
		map.put("12", "12");
		return map;
	}	
	
	
	public static Map getProdfunList(Map param) {
		Map map = new Hashtable();
		try {
			
			DacClient db = new DacClient();
			String sProdfunId = (String)param.get("PRODFUNID");
			String sFunType = (String)param.get("FUNTYPE");
			String sConnectionType = (String)param.get("MUTEXLEANTYPE");
			DataTable prodfunlist = null;
			com.doone.fj1w.fjmgr.config.MutexleanFunBean mfb = 
				new com.doone.fj1w.fjmgr.config.MutexleanFunBean();
			if(sConnectionType == null || sConnectionType.equals("1")){
		        //查询程控功能的互斥关系
		        prodfunlist = mfb.getMutexleanFunById(new DacClient(),sProdfunId,"1",sFunType);
		    }
		    else if(sConnectionType.equals("2")){
		        //查询程控功能的依赖关系
			    prodfunlist = mfb.getMutexleanFunById(new DacClient(),sProdfunId,sFunType); 
		    }
			/*else{
			    //查询程控功能的被依赖关系
			    prodfunlist = mfb.getMutexleanFunById(new DacClient(),sProdfunId,"2");
			}*/
			StringBuffer sql = new StringBuffer();
			sql.append("select t.productid from td_prodfun t where t.prodfunid = ?");
			List oParam = new ArrayList();
			oParam.add(new Integer(sProdfunId));
			Object ap[] = new Object[oParam.size()];
			
			for (int i = 0; i < ap.length; i++) {
				ap[i] = oParam.get(i);
			}
			DataTable dt = db.executeQuery(sql.toString(), ap);
			String sProductId = "";
			if(dt != null && dt.getRows().getCount() > 0) {
				sProductId = dt.getRow(0).getString("productid");
			}
			
			sql = new StringBuffer();
			sql.append("select t.prodfunid,t.funname from td_prodfun t where t.productid = ? and t.funtype = ?");
			oParam = new ArrayList();
			oParam.add(sProductId);
			oParam.add(sFunType);
			ap = new Object[oParam.size()];
			
			for (int i = 0; i < ap.length; i++) {
				ap[i] = oParam.get(i);
			}
			dt = db.executeQuery(sql.toString(), ap);
			
			if(dt != null && dt.getRows().getCount() > 0) {
				for(int i = 0;i < dt.getRows().getCount(); i++) {
					DataRow dr = dt.getRow(i);
					sProdfunId = dr.getString("prodfunid"); 
					String funName = dr.getString("funname");
					boolean b = true;
					for(int j = 0;j < prodfunlist.getRows().getCount();j++) {
						if(sConnectionType == null || sConnectionType.equals("1")) {
							String sReProdfunId = prodfunlist.getRow(j).getString("CorrProdFunId");
							if(sReProdfunId != null && sReProdfunId.equals(sProdfunId)) {
								b = false;
							}
						}
						else if(sConnectionType.equals("2")){
							String sReProdfunId = prodfunlist.getRow(j).getString("ProdfunId");
							if(sReProdfunId != null && sReProdfunId.equals(sProdfunId)) {
								b = false;
							}
						}
					}
					
					if (b)
						map.put(sProdfunId, funName);
					
					b = true;
				}
			}
			else map.put("0", "没有该类型的信息");
			
		}
		catch (Exception e) {
			FileLogger.getLogger().warn(e.getMessage(), e);
		}
		return map;
	}
	
	public static Map get_tl_maillogTable_List(Map param) {
		Map map = new TreeMap();
		Map map1 = new TreeMap();
		new TreeMap();
		try {
			
			DacClient db = new DacClient();
			StringBuffer sql = new StringBuffer();
			List oParam = new ArrayList();
			Object ap[] = new Object[oParam.size()];
			sql.append("select Substr(table_name, 12, 6) table_name from (select a.table_name from user_tables a ");
			sql.append("where ");
			sql.append("  a.table_name like 'TL_MAILLOG_%') order by table_name desc");
			//System.out.println(sql);
			for (int i = 0; i < ap.length; i++) {
				ap[i] = oParam.get(i); 
			}
			DataTable dt = db.executeQuery(sql.toString(), ap);
			if(dt != null && dt.getRows().getCount() > 0) {
				for(int i = 0;i < dt.getRows().getCount(); i++) {
					DataRow dr = dt.getRow(i);
					
					String sTableName = dr.getString("table_name");
					map.put("0","全部"); 
					map.put(sTableName, 
							sTableName.substring(0,4) + "年"
							+ sTableName.substring(4,6) + "月");
				}
			}
			else map.put("0", "没有账单寄送的信息");
			
		}
		catch (Exception e) {
			FileLogger.getLogger().warn(e.getMessage(), e);
		}
		return map;
	}
	public static String getMenuLevel(String optype) {
		StringBuffer s = new StringBuffer();
		try {
			DacClient db = new DacClient();
			StringBuffer sql = new StringBuffer();
			Object ap[] = new Object[1];
			s.append("<select name='PURVIEWID' id='PURVIEWID'  style='width:100%' >");
			sql.append(" select a.PURVIEWNAME,a.PURVIEWID,a.LEVEL1  from (select d.PURVIEWNAME,d.PURVIEWID, level level1,type ");
			sql.append(" from TD_REPORT_NODE d ");
			sql.append(" connect by prior d.purviewid = d.uppurviewid ");
			sql.append(" start with  d.uppurviewid in  (select purviewid ");
			sql.append(" from tf_purview t ");
			sql.append(" where uppurviewid = 0 and STATE = 'E' and type="+optype+") and    STATE='E') a where    type="+optype);
 			DataTable dt = db.executeQuery(sql.toString());
			if(dt != null && dt.getRows().getCount() > 0) {
				for(int i = 0;i < dt.getRows().getCount(); i++) {
						DataRow row=dt.getRow(i);
						String value=row.getString("PURVIEWID");
						String name="";
						String LEVEL=row.getString("LEVEL1");
						String he="";
						if (LEVEL!=null&&(!LEVEL.equals("1"))) {
							for (int j=Integer.parseInt(LEVEL);j>0;j--) {
								he=he+"-";
							}
							 name=he+row.getString("PURVIEWNAME");}
							else { 
								if (LEVEL!=null&&(LEVEL.equals("1"))) {
									name=row.getString("PURVIEWNAME");}
							}
							s.append("<option value='"+value+"'>"+name+"</option>");
						}
				}
			s.append(" </select>");
		}
		catch (Exception e) {
			FileLogger.getLogger().warn(e.getMessage(), e);
		}
		return s.toString();
	}
 	public static String getOpType() {
		StringBuffer s = new StringBuffer();
			s.append("<select name='OPTYPE' id='OPTYPE' >");
			s.append("<option value='1'>---访问量---</option>");
			s.append("<option value='2'>---受理量---</option>");
			s.append(" </select>");
		return s.toString();
	}
	 
 	
 
	public static Map getOpLevel(Map param) {
		Map map = new Hashtable();
		map.put("", "全部");
		map.put("1", "一级");
		map.put("2", "二级");
		map.put("3", "三级");
		map.put("4", "四级");
		return map;
	}	
	/**获取程控功能列表
	 * 
	 * @param param
	 * @return
	 */
	public static Map get_prodfunTable_List(Map param) {
		Map map = new Hashtable();
		try {
			String cityCode = (String)param.get("CITYCODE");
			DacClient db = new DacClient();
			StringBuffer sql = new StringBuffer();
			DataTable dt = null;
			if(cityCode == null || cityCode.equals("")) {
				sql.append("select t1.prodfunid,t1.funname || '(' || t3.cityname || '-' || t2.productname || ')' \"funname\" from td_prodfun t1, td_product t2,td_city t3 ");
				sql.append("where t1.funstate='E' and t1.funtype='C' and t1.productid = t2.productid and t1.citycode = t3.citycode ");
				dt = db.executeQuery(sql.toString());
			}