续航饼状图

81041

2018-11-26 05f6c230566d1f04496bd5b65be6967f6bbfd5a4

续航饼状图

 gx_tieta/src/com/fgkj/actions/Batt_enduranceAction.java

@@ -19,7 +19,13 @@
        result=tojson(model);

        return SUCCESS;

    }



    //续航不足1小时，2小时等的饼状图

    public String serchByState_xuhang() {

        User_inf uinf=(User_inf) getUser();

        ServiceModel model=service.serchByState_xuhang(uinf);

        result=tojson(model);

        return SUCCESS;

    }

    

    

    


 gx_tieta/src/com/fgkj/dao/impl/Batt_enduranceImpl.java

@@ -13,6 +13,7 @@
import com.fgkj.db.DBUtil;

import com.fgkj.dto.Batt_endurance;

import com.fgkj.dto.Page;

import com.fgkj.dto.User_inf;

import com.mysql.fabric.xmlrpc.base.Array;



public class Batt_enduranceImpl implements BaseDAO,CallBack{

@@ -57,7 +58,7 @@
                "  left outer join db_user.tb_user_battgroup_baojigroup_battgroup on db_user.tb_user_battgroup_baojigroup_battgroup.stationid=db_battinf.tb_battinf.stationid " +

                "  left outer join db_user.tb_user_battgroup_baojigroup_usr on db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id " +

                "  left outer join db_user.tb_user_inf on tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid " +

                "  where db_user.tb_user_inf.uid=?  ) " ;

                "  where db_user.tb_user_inf.uid=? and db_battinf.tb_battinf.station_install=1 ) " ;

        //机房筛选

        String stationSql=" and db_battinf.tb_battinf.StationName like ? and db_battinf.tb_battinf.StationName1 like ? and db_battinf.tb_battinf.StationName2 like ? and db_battinf.tb_battinf.StationName5 like ?";

        sql+=stationSql;

@@ -125,7 +126,53 @@
        }

        return list;

    }

    //续航不足1小时，2小时等的饼状图

    public List serchByState_xuhang(Object obj) {

        User_inf uinf=(User_inf) obj;

        String sql="select  distinct tb_batt_endurance.deviceid,tb_batt_endurance.stationid,endurance_theory_timelong,endurance_actual_timelong " +

                " from web_site.tb_batt_endurance " +

                " where   tb_batt_endurance.stationid in (" +

                "  select distinct db_battinf.tb_battinf.stationid  " +

                "  from db_battinf.tb_battinf " +

                "  left outer join db_user.tb_user_battgroup_baojigroup_battgroup on db_user.tb_user_battgroup_baojigroup_battgroup.stationid=db_battinf.tb_battinf.stationid " +

                "  left outer join db_user.tb_user_battgroup_baojigroup_usr on db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id " +

                "  left outer join db_user.tb_user_inf on tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid " +

                "  where db_user.tb_user_inf.uid=?  and db_battinf.tb_battinf.station_install=1) " ;

        //System.out.println(sql);

        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUId()}, new CallBack() {



            public List getResults(ResultSet rs) {

                List list=new ArrayList();

                int num_hour=0;//续航一小时内的

                int num_two=0;//续航一小时到两个小时的

                int num_three=0;//续航两小时到三小时内的

                int num_other=0;//续航三小时以上

                try {

                    while(rs.next()){

                        int actual_timelong=rs.getInt("endurance_actual_timelong");

                        if(actual_timelong<=60){

                            num_hour+=1;

                        }else if(actual_timelong<=120){

                            num_two+=1;

                        }else if(actual_timelong<=180){

                            num_three+=1;

                        }else{

                            num_other+=1;

                        }

                    }

                    list.add(num_hour);

                    list.add(num_two);

                    list.add(num_three);

                    list.add(num_other);

                } catch (SQLException e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                }

                return list;

            }

        });

        return list;

    }

    public List serchByInfo(Object obj) {

        // TODO Auto-generated method stub

        return null;

@@ -143,11 +190,19 @@
        page.setPageCurr(1);

        page.setPageSize(10);

        ben.setPage(page);

        List<Batt_endurance> list=bimpl.serchByCondition(ben);

        /*List<Batt_endurance> list=bimpl.serchByCondition(ben);

        for (Batt_endurance b : list) {

            System.out.println(b);

        }

        System.out.println(list.size());

        System.out.println(list.size());*/

		
        User_inf uinf=new User_inf();

        uinf.setUId(1002);

        List<Integer> list=bimpl.serchByState_xuhang(uinf);

        for (int num : list) {

            System.out.println(num);

        }

        //System.out.println(list.size());

    }






 gx_tieta/src/com/fgkj/services/Batt_enduranceService.java

@@ -4,6 +4,7 @@


import com.fgkj.dao.BaseDAO;

import com.fgkj.dao.BaseDAOFactory;

import com.fgkj.dao.impl.Batt_enduranceImpl;

import com.fgkj.dto.ServiceModel;



public class Batt_enduranceService {

@@ -28,5 +29,18 @@
        }

        return model;

    }

    //续航不足1小时，2小时等的饼状图

    public ServiceModel serchByState_xuhang(Object obj) {

        List list=((Batt_enduranceImpl)dao).serchByState_xuhang(obj);

        if(list.size()>0&&list!=null){

            model.setCode(1);

            model.setData(list);

            model.setMsg("查询成功!");

        }else{

            model.setCode(0);

            model.setMsg("查询失败!");

        }

        return model;

    }



}