update

whycrzg

2021-02-01 51f6e3d555d9e6021fd2470bb39f6befca9aa895

 src/main/java/com/fgkj/mapper/impl/BattDischarge_planMapper.java

@@ -4,6 +4,8 @@

import com.fgkj.dto.BattDischarge_plan;
import com.fgkj.dto.BattMap_information;
import com.fgkj.dto.Batt_Maint_Dealarm;
import com.fgkj.dto.User_inf;
import com.fgkj.mapper.BattTestData;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
@@ -49,7 +51,10 @@
   public int del(BattDischarge_plan obj);

   //8.1批量添加作业计划时先检测计划的可行性
   public int judgePlan(Object obj);
   @Select(" SELECT battgroupid FROM web_site.tb_battdischarge_plan " +
         "WHERE discharge_starttime>=#{discharge_starttime1} and discharge_starttime<=#{discharge_stoptime1} AND discharge_cleartype=1 and discharge_state in(0,1) AND battgroupid " +
         "in (select battgroupid FROM db_battinf.tb_battinf where stationname=#{note})")
   public List<String> judgePlan(BattDischarge_plan obj);

   @Select("select  num,battgroupid,discharge_starttime,discharge_stoptime,discharge_state,discharge_reason,discharge_cleartype,preset_time,preset_cap,preset_monvol,preset_groupvol,preset_curr,preset_mon,dcvolhighlimit,chargecurrset,note from web_site.tb_battdischarge_plan ")
   public List<BattDischarge_plan> searchAll() ;
@@ -144,7 +149,9 @@
      }
      return list;
   }*/
   public List serchByCondition(Object obj);


   public List serchByCondition(Batt_Maint_Dealarm obj);

    //9.1查询机房放电计划中存在放电延时的总数
   //地图上所有的放电延时机房
@@ -187,7 +194,13 @@
      }
      return nums;
   }*/
   public int searchNums(Object obj) ;

   @Select("select count(num) as nums from web_site.tb_battdischarge_plan " +
         "where discharge_state='${@com.fgkj.mapper.BattTestData@test_plan0}' and battgroupid " +
         "in (select distinct db_battinf.tb_battinf.battgroupid  " +
         "from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf " +
         "where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid and db_user.tb_user_inf.uid=#{uId})")
   public int searchNums(User_inf obj) ;

   //8.1放电计划管理中饼状图(放电计划统计查询)
   /*public List searchState(){
@@ -214,6 +227,13 @@
         });
         return list;
      }*/
   public List searchState(Object obj);


   @Select("SELECT COUNT(num) num,discharge_state,battgroupid " +
         "from web_site.tb_battdischarge_plan " +
         "GROUP BY battgroupid,discharge_state " +
         "having web_site.tb_battdischarge_plan.battgroupid " +
         "in(select distinct db_battinf.tb_battinf.battgroupid from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid and db_user.tb_user_inf.uid=#{uId})")
   public List<BattDischarge_plan> searchState(User_inf obj);

}