25,985
社区成员
发帖
与我相关
我的任务
分享
public List Query(String startdate,String enddate,String telco){
List list =new ArrayList();
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
String sql="select sum(mttotalfee) as feesum,province,count(distinct sender) as sendernum,province from "
+" [platform].[dbo].[vasmt_dayfeeRecord] where adate>'"+startdate+"' and adate<'"+enddate+"'"
+" and telco='"+telco+"' group by province order by feesum desc";
String avgpirce="";
ReportBean reportBean=null;
try{
Context ic = new InitialContext();
DataSource source = (DataSource) ic.lookup("java:comp/env/jdbc/data");
conn = source.getConnection();
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next()){
reportBean=new ReportBean();
if(rs.getString("province")==null){
reportBean.setProvince("未知");
}else{
reportBean.setProvince(rs.getString("province"));
}
reportBean.setSendernum(rs.getInt("sendernum"));
reportBean.setFeesum(rs.getInt("feesum")/100);
reportBean.setStartdate(startdate);
reportBean.setTelco(telco);
reportBean.setEnddate(enddate);
avgpirce=reportBean.getFeesum()*1.00/reportBean.getSendernum()+"";
BigDecimal d=new BigDecimal(avgpirce);
d=d.setScale(2, BigDecimal.ROUND_HALF_UP);
reportBean.setAvgprice(d.toString());
list.add(reportBean);
if(list.size()!=0){
System.out.println("list:"+list.size());
System.out.println("开始时间:"+reportBean.getStartdate());
System.out.println("结束时间:"+reportBean.getEnddate());
System.out.println("省份:"+reportBean.getProvince());
}
}
}catch (Exception e) {
log.error("查询[report].[dbo].[akn_sender_daysumfee]出错:"+e.getMessage());
e.printStackTrace();
}finally{
Database.closeStatementByResultSet(rs);
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
log.info("报表记录长度:"+list.size());
return list;
}
public List PackageList(String startdate,String endDate,String telco){
System.out.println("开始时间:"+startdate+"------结束时间:"+endDate+"-----通道号:"+telco);
List list=new ArrayList();
List ReportList=new ArrayList();
List ReportListList=new ArrayList();
SimpleDateFormat formatter=new SimpleDateFormat("yyyy-MM-dd");
try {
Date date1 = formatter.parse(startdate);
Date date2 =formatter.parse(endDate);
long l = date2.getTime() - date1.getTime();
long d = l/(24*60*60*1000)+1;
Calendar startnow=Calendar.getInstance();
startnow.setTime(date1);
if(d==1){
ReportList=ReportDao.getInstance().Query(startdate, endDate, telco);
return ReportList;
}else{
for(int i=0;i<d;i++){
startnow.set(Calendar.DATE, startnow.get(Calendar.DATE)+1);
list=ReportDao.getInstance().Query(startdate, formatter.format(startnow.getTime()), telco);
if(list.size()!=0){
ReportListList.add(list);
System.out.println("外部LIST:"+ReportListList.size());
System.out.println("---------------------------------");
}
if(startdate.equals(formatter.format(startnow.getTime()))){
break;
}else{
startdate=formatter.format(startnow.getTime());
}
}
}
} catch (ParseException e) {
e.printStackTrace();
}
System.out.println("list长度:"+ReportListList.size());
return ReportListList;
}
function check(){
if(document.getElementById('telco').value==null || document.getElementById('telco').value==''){
alert("请选择你要查询的通道号");
return false;
}
if(document.getElementById('startdate').value =='' || document.getElementById('startdate').value ==null){
alert("请选择查询的开始时间")
return false;
}
if(document.getElementById('enddate').value =='' || document.getElementById('enddate').value ==null){
alert("请选择查询的结束时间")
return false;
}
if(document.getElementById('enddate').value<document.getElementById('startdate').value){
alert("你查询的时间错误,请重新选择时间")
return false;
}
setParam();
}
function setParam(){
var telco=document.getElementById('telco').value;
var startdate=document.getElementById('startdate').value;
var enddate=document.getElementById('enddate').value;
alert(telco+" "+ startdate+" "+enddate)
reportList.PackageList(startdate,enddate,telco,runData)
}
function runData(data){
for(var i=0;i<data.length;i++){
alert(data[i].length)
}
}