clientservice.java

电信的网厅的整站代码

		}
		return ret;
	}
	
	public static boolean deleteAttchment(ServletRequest request, ServletResponse response, Map param) {
		String fileName = (String) param.get("FILENAME");
		if (fileName != null) {
			String fullName = "/view/bbs/UploadFile/" + fileName;
			String realPath = ((HttpServletRequest) request).getSession().getServletContext().getRealPath(
					fullName);
			FileLogger.getLogger().debug("要删除文件的实际路径：" + realPath);
			File file = new File(realPath);
			if (file.exists()) {
				file.delete();
				
				return true;
			}
		}
		
		return false;
	}
	public static int deleteAttchRecord(ServletRequest request, ServletResponse response, Map param) {
		String attchId = (String) param.get("ATTCHID");
//		String contentId = (String) param.get("CONTENTID");
		int doExp=0;
		try{
			String sql = " delete   tf_attchment t where attch_id = ?";
			DacClient db = new DacClient();
			Object[] ap = new Object[1];
			ap[0] = new String(attchId);
			db.getStringFromSqlQuery(sql.toString(), ap);
			
			doExp=db.executeUpdate(sql,1000,ap);
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex.getMessage(), ex);
		}
		return doExp;
		
	}
	public static int deleteContentRecord(ServletRequest request, ServletResponse response, Map param) {
		String contentId = (String) param.get("CONTENTID");
		int doExp=0;
		try{
			String sql1 = " delete   tf_content t where content_id = ?";
			DacClient db1 = new DacClient();
			Object[] ap1 = new Object[1];
			ap1[0] = new String(contentId);
			db1.getStringFromSqlQuery(sql1.toString(), ap1);
			doExp=db1.executeUpdate(sql1,1000,ap1);
			
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex.getMessage(), ex);
		}
		return doExp;
		
	}
	/**
	 * 取得子模块的模块图信息
	 * @param dbClient,long lPurviewId
	 * @return DataTable
	 */
	public static DataTable getAttchListByBoardId(DacClient db,long lPurviewId) {
		DataTable attchList = null;
		try {
			StringBuffer sql = new StringBuffer();
			sql.append("select attch_id,");
			sql.append("content_id,");
			sql.append("file_size,");
			sql.append("file_name,");
			sql.append("file_type,");
			sql.append("upload_time,");
			sql.append("attch_type");
			sql.append(" from tf_attchment t");
			sql.append(" where  attch_type='5' ");
			sql.append(" and content_id =(select content_id from  ");
			sql.append(" tf_content where board_id=? and contenttype='04' and rownum=1 and DELETE_SIGN='E')");
			
			Object[] aParam = new Object[1];
			aParam[0] = new Long(lPurviewId);
			if (db == null)
				db = new DacClient();
			attchList = db.executeQuery(sql.toString(), aParam);
		} catch (Exception ex) {
			FileLogger.getLogger().warn(ex.getMessage(), ex);
			
			attchList = null;
		}
		
		return attchList;
	}
	public static String getChildBoardList(ServletRequest request, ServletResponse response, Map param) {
		String ret = null;
		try {
			if (param != null && param.get("BOARDCODE") != null) {
				long boardID = Sys_Purview.getPurviewIdByCode((String) param.get("BOARDCODE"));
				
				Sys_Purview[] purvs = Sys_Purview.getPurviewByID(new DacClient(), boardID).getChilds();
				FormBody fb = new FormBody();
				for (int i = 0; purvs != null && i < purvs.length; i++) {
					if (purvs[i].getPurviewMode().equalsIgnoreCase(PurviewMode.MODULE))
						fb.append(purvs[i].getPurviewCode(), purvs[i].getName());
				}
				
				ret = fb.getXML();
			}
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex.getMessage(), ex);
		}
		
		return ret;
	}
	
	public static DataTable getCallCount(String cityCode, String sAffairType, String sChildType, String sText,String year,String quarter,String month,String xun,String rq,String start,String end,String popedom) {
		DataTable ret = null;
		if(popedom.equals("")||popedom==null){popedom="";}
		else{popedom=" and d.USERTYPE='"+popedom+"'";}
		
		//按年
		if(year.equals("")){year=" ";}
		else{
			if(quarter.equals("")&&month.equals("")&&xun.equals("")&&start.equals("")&&end.equals("")){year="  and to_char(d.VISITINGTIME,'yyyy')='"+year+"'";}
		}
		
		
		//按季度
		if(quarter.equals("")){quarter=" ";}
		else{
			if(quarter.equals("1")){
				String s1=year+"01";
				String s2=year+"03";
				quarter="  and to_char(d.VISITINGTIME,'yyyymm') between '" +s1+"' and '"+s2+"'";
				year="";}
			if(quarter.equals("2")){
				String s1=year+"04";
				String s2=year+"06";
				quarter="  and to_char(d.VISITINGTIME,'yyyymm') between '" +s1+"' and '"+s2+"'";
				year="";}
			if(quarter.equals("3")){
				String s1=year+"07";
				String s2=year+"09";
				quarter="  and to_char(d.VISITINGTIME,'yyyymm') between '" +s1+"' and '"+s2+"'";
				year="";}
			if(quarter.equals("4")){
				String s1=year+"10";
				String s2=year+"12";
				quarter="  and to_char(d.VISITINGTIME,'yyyymm') between '" +s1+"' and '"+s2+"'";
				year="";}
		}
		
		//按月份
		if(month.equals("")){month="";}
		else{
			if(xun.equals("")){month=" and to_char(d.VISITINGTIME,'yyyymm')='"+year+month+"'";year="";}
		}
		
		//按旬
		if(xun.equals("")){xun="";}
		else{ 
			if(xun.equals("1")){
				String s1="01";
				String s2="10";
				xun=" and to_char(d.VISITINGTIME,'yyyymmdd') between '"+year+month+s1+"' and '"+year+month+s2+"'";
				year="";
				month="";
				
			}
			if(xun.equals("2")){
				String s1="11";
				String s2="20";
				xun=" and to_char(d.VISITINGTIME,'yyyymmdd') between '"+year+month+s1+"' and '"+year+month+s2+"'";
				year="";
				month="";
				
			}
			if(xun.equals("3")){
				String s1="21";
				String s2="31";
				xun=" and to_char(d.VISITINGTIME,'yyyymmdd') between '"+year+month+s1+"' and '"+year+month+s2+"'";
				year="";
				month="";
				
			}
		}
		
		//按日期
		if(rq==null||rq.equals("")){rq="";}
		else{rq=" and to_char(d.VISITINGTIME,'yyyy-mm-dd')='"+rq+"'";}
		
		
		//按时间段
		
		if(start==null||start.equals("")){start="";}
		else{start=" and to_char(d.VISITINGTIME,'yyyy-mm-dd HH24:mi') between '"+start+"'";year="";}
		if(end==null||end.equals("")){end="";}
		else{end=" and '"+end+"'";year="";}
		
		
		
		
		try {
			String code = "BBS001";
			if (!cityCode.equals("0590"))
				code += String.valueOf(Integer.parseInt(cityCode));
			
			if (sChildType != null && sChildType.length() > code.length())
				code = sChildType;
			else if (sAffairType != null && sAffairType.length() > code.length())
				code = sAffairType;
			
			int iParamCount = 1;
			String[] aText = null;
			if (sText != null)
				aText = sText.split("[ \u3000]");
			ArrayList list = new ArrayList();
			
			StringBuffer sql = new StringBuffer();
			sql.append("select t.content_id,");
			sql.append(" t.board_id,");
			sql.append(" t.title,");
			sql.append(" p.purviewcode,");
			sql.append(" c.citycode,");
			sql.append(" c.cityname,");
			//sql.append(" d.VISITINGTIME,");
			sql.append(" decode(d.USERTYPE,'0','游客','U','注册帐号','P','产品登录客户','E','内部员工','B','大客户','关联的产品登录客户') USERTYPE,");
			sql.append(" count(*) cnt");
			sql.append(" from tl_visitinglog d,tf_content t, tf_purview p, td_city c");
			sql.append(" where d.CONTENT_ID=t.CONTENT_ID and  t.board_id = p.purviewid and");
			sql.append(" '0' || substr(p.purviewcode, 7, 3) = c.citycode and");
			sql.append(" p.purviewcode like ? and");
			sql.append(" t.delete_sign = 'E'");
			sql.append(year);
			sql.append(popedom);
			sql.append(quarter);
			sql.append(month);
			sql.append(xun);
			sql.append(rq);
			sql.append(start);
			sql.append(end);
			if (aText != null && aText.length > 0) {
				StringBuffer sql1 = new StringBuffer();
				for (int i = 0; i < aText.length; i++) {
					if (aText[i].length() > 0) {
						if (sql1.length() > 0) {
							iParamCount++;
							sql1.append(" and ( t.title like ?");
							list.add(aText[i]);
							
							iParamCount++;
							sql1.append(" or t.content like ? ) ");
							list.add(aText[i]);
						}
						else {
							iParamCount++;
							sql1.append(" ( t.title like ?");
							list.add(aText[i]);
							
							iParamCount++;
							sql1.append(" or t.content like ? )");
							list.add(aText[i]);
						}
					}
				}
				if (sql1.length() > 1) {
					sql.append(" and ( ");
					sql.append(sql1);
					sql.append(" )");
				}
			}
			sql.append(" group by t.content_id, t.board_id, t.title, p.purviewcode, c.citycode,c.cityname,d.USERTYPE");
			sql.append(" order by c.citycode, t.title");
			FileLogger.getLogger().info(sql.toString());
			FileLogger.getLogger().info(code);
			Object[] ap = new Object[iParamCount];
			ap[0] = code + "%";
			
			for (int i = 1; i < iParamCount; i++) {
				ap[i] = "%" + (String) list.get(i - 1) + "%";
			}
			
			DacClient db = new DacClient();
			//for(int n=0;n<ap.length;n++){
			//System.out.println("\n"+ap[n]);}
			ret = db.executeQuery(sql.toString(), ap);
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex.getMessage(), ex);
		}
		
		return ret;
	}
	
	public static String getBoardFullName(long boardId) {
		String ret = null;
		
		try {
			BufferCache buffer = new BufferCache("BOARDFULLNAME", Long.toString(boardId));
			if (buffer.exists()) {
				ret = buffer.getString();
			}
			
			StringBuffer sql = new StringBuffer();
			sql.append("select fullname from (");
			sql.append(" select t.purviewid, substr(SYS_CONNECT_BY_PATH(t.name, '-->'), 16) fullname");
			sql.append(" from tf_purview t");
			sql.append(" connect by prior t.purviewid = t.uppurviewid and t.purviewmode = 'M'");
			sql.append(" start with t.purviewcode = 'BBS001'");
			sql.append(" )");
			sql.append(" where purviewid = ?");
			
			DacClient db = new DacClient();
			Object[] ap = new Object[1];
			ap[0] = new Long(boardId);
			
			ret = db.getStringFromSqlQuery(sql.toString(), ap);
			if (ret.length() > 0)
				buffer.put(ret);
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex.getMessage(), ex);
		}
		
		if (ret != null && ret.length() > 0)
			ret = "【" + ret + "】";
		
		return ret;
	}
	
	/**
	 * 取备注编码
	 */
	public static DataTable getContentCode(String purviewCode) {
		return ClientDAO.getContentCode(purviewCode);
	}
	
	
	
}