system_call.java

电信的网厅的整站代码

		 
		 //按旬
		 if(xun.equals("")){xun="";}
		 else{ 
			   if(xun.equals("1")){
				   String s1="01";
				   String s2="10";
				   xun=" and to_char(a.operatetime,'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(a.operatetime,'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(a.operatetime,'yyyymmdd') between '"+year+month+s1+"' and '"+year+month+s2+"'";
				   year="";
				   month="";
				   
			                      }
		 }
		 
		 
//		按周
		 if(week==null||week.equals("")){week="";}
		 else{
			if(week.equals("1")){
				String s1="01";
				String s2="07";
				week=" and to_char(a.operatetime,'yyyymmdd') between '"+year+month+s1+"' and '"+year+month+s2+"'";
				year="";
				month="";
				
			} 
			if(week.equals("2")){
				String s1="08";
				String s2="15";
				week=" and to_char(a.operatetime,'yyyymmdd') between '"+year+month+s1+"' and '"+year+month+s2+"'";
				year="";
				month="";
				
			} 
			if(week.equals("3")){
				String s1="16";
				String s2="23";
				week=" and to_char(a.operatetime,'yyyymmdd') between '"+year+month+s1+"' and '"+year+month+s2+"'";
				year="";
				month="";
				
			} 
			if(week.equals("4")){
				String s1="24";
				String s2="31";
				week=" and to_char(a.operatetime,'yyyymmdd') between '"+year+month+s1+"' and '"+year+month+s2+"'";
				year="";
				month="";
				
			} 
			 
		 }
		 
		 
		 
		 
		 //按日期
		 if(rq==null||rq.equals("")){rq="";}
		 else{rq=" and to_char(a.operatetime,'yyyy-mm-dd')='"+rq+"'";}
		 
		 //按时间段
		 if(start==null||start.equals("")){start="";}
		 else{start=" and to_char(a.operatetime,'yyyy-mm-dd HH24:mi') between '"+start+"'";year="";}
		 if(end==null||end.equals("")){end="";}
		 else{end=" and '"+end+"'";year="";}
		 
		 
		 
		    StringBuffer sql=new StringBuffer();
		    sql.append("select count(*) count from (select count(*) cnt,a.logintype,a.siteid,b.NAMET");
		    sql.append(" from tl_clientlogin a,");
			sql.append(" (select c.treeid pptreeid,c.namet ppnamet,a.treeid ptreeid,a.namet  pnamet,b.namet  namet,b.treeid treeid,b.citycode from td_tree c,td_tree a, td_tree b");
			sql.append(" where c.treeid=a.pid and a.treeid = b.pid and b.url is not null ");
			sql.append(citycode);
			sql.append(" order by a.treeid) b");
			sql.append(" where a.siteid = b.treeid");
			sql.append(citycode);
			sql.append(transactpp);
			sql.append(transactp);
			sql.append(transact);
			sql.append(popedom);
			sql.append(year);
			sql.append(quarter);
			sql.append(month);
			sql.append(xun);
			sql.append(week);
			sql.append(rq);
			sql.append(start);
			sql.append(end);
			sql.append(" group by a.logintype,a.siteid,b.pptreeid,b.ppnamet,b.ptreeid,b.pnamet,b.namet,b.treeid,b.citycode");
			sql.append(" order by a.siteid,b.treeid");
			sql.append(")r");
	 		int count = 0;
	 		//System.out.println("得到总页数===》"+sql.toString());
	 		try {
	 			DataTable dt = _dac.executeQuery(sql.toString());
	 			count = Integer.parseInt(dt.getRow(0).getString(0));
	 			if (count % pagecount == 0)
	 				count = count / pagecount;
	 			else
	 				count = count / pagecount + 1;
	 		} catch (Exception ex) {
	 			count=0;
	 		}
	 		return String.valueOf(count);
		
		 
		 
		 
		 
	 }
	 
	 
	 public DataTable Qurey_popedom(String citycode,String pptreeid,String ptreeid){
		 
		 if(pptreeid==null||pptreeid.equals("")){pptreeid="";}
		 else{pptreeid=" and c.treeid='"+pptreeid+"'";}
		 if(ptreeid==null||ptreeid.equals("")){ptreeid="";}
		 else{ptreeid=" and a.treeid='"+ptreeid+"'";}
		 if(citycode==null||citycode.equals("")){citycode="";}
		 else{citycode=" and  b.CITYCODE='"+citycode+"'";}
		 
		 DataTable dt = null;
		 StringBuffer sql=new StringBuffer();
		 sql.append(" select  c.treeid pptreeid,c.namet ppnamet,a.treeid ptreeid,a.namet pnamet,b.namet namet,b.treeid treeid,b.url url");
		 sql.append(" from td_tree a,td_tree b,td_tree c");
		 sql.append(" where a.treeid=b.pid and a.pid=c.treeid and b.url is not null");
		 sql.append(" and b.STATE='E'");
		 sql.append(pptreeid);
		 sql.append(ptreeid);
		 sql.append(citycode);
		 sql.append(" order by a.treeid");
		 //System.out.println("shu "+sql.toString());
		 
			try {
		    	dt = _dac.executeQuery(sql.toString());
		     }
		     catch (Exception ex) {
		       FileLogger.getLogger().debug(ex);
		       return null;
		     }
		     return dt;
		 
		 
	 }
	 
	 
	 
	 public DataTable Qurey_popedomfist(String citycode){
		 if(citycode==null||citycode.equals("")){citycode="";}
		 else{citycode=" and  b.CITYCODE='"+citycode+"'";}
		 
		 
		 DataTable dt = null;
		 StringBuffer sql=new StringBuffer();
		 sql.append(" select distinct c.treeid pptreeid,c.namet ppnamet from td_tree a,td_tree b ,td_tree c where a.treeid=b.pid and a.pid=c.treeid and b.url is not null and b.STATE='E'   ");
		 sql.append(citycode);
		 sql.append(" order by c.treeid");
		 //System.out.println(sql.toString());
		 
			try {
		    	dt = _dac.executeQuery(sql.toString());
		     }
		     catch (Exception ex) {
		       FileLogger.getLogger().debug(ex);
		       return null;
		     }
		     return dt;
		 
		 
	 }
	 
	 
	 public DataTable Qurey_popedomsencond(String citycode,String pptreeid){
		 if(citycode==null||citycode.equals("")){citycode="";}
		 else{citycode=" and  b.CITYCODE='"+citycode+"'";}
		 if(pptreeid==null||pptreeid.equals("")){pptreeid="";}
		 else{pptreeid=" and c.treeid='"+pptreeid+"'";}
		 
		 
		 DataTable dt = null;
		 StringBuffer sql=new StringBuffer();
		 sql.append(" select distinct a.treeid ptreeid,a.namet pnamet from td_tree a,td_tree b ,td_tree c where a.treeid=b.pid and a.pid=c.treeid and b.url is not null and b.STATE='E'   ");
		 sql.append(citycode);
		 sql.append(pptreeid);
		 sql.append(" order by a.treeid");
		// System.out.println(sql.toString());
		 
			try {
		    	dt = _dac.executeQuery(sql.toString());
		     }
		     catch (Exception ex) {
		       FileLogger.getLogger().debug(ex);
		       return null;
		     }
		     return dt;
		 
		 
	 }
	 
	 
	 
	 
	 
	 
	 
	 
	 public DataTable Qurey_popedomlevel(String citycode){
		 if(citycode==null||citycode.equals("")){citycode="";}
		 else{citycode=" where r.CITYCODE='"+citycode+"'";}
		 
		 
		 DataTable dt = null;
		 StringBuffer sql=new StringBuffer();
		 sql.append(" select * from (");
		 sql.append(" select level l,t.* from td_tree t start with pid='-1'");
		 sql.append("connect by prior t.treeid=t.PID )r");
		 sql.append(citycode);
		 
		 //System.out.println(sql.toString());
		 
			try {
		    	dt = _dac.executeQuery(sql.toString());
		     }
		     catch (Exception ex) {
		       FileLogger.getLogger().debug(ex);
		       return null;
		     }
		     return dt;
		 
		 
	 }
	 
	 
//	得到城市列表 
	 public DataTable getCity()
	 { 
	   String sql="select cityname,citycode from td_city  where citycode<>'0590' and STATE='E'";
	   DataTable dt=null;
	  try {
	    dt=_dac.executeQuery(sql);
	    
	  }
	  catch (Exception ex) {
		  return null;
	  }
	  return dt;

	 }
	 
	 
	 
	public static void main(String[] args) {
		

	}

}