新增统计月份，季度，年度统计开锁次数

DELL

2025-02-07 351bbd8738c89c0302465360c1ca0c92abd18eba

 ElectLock_Monitor/src/com/dev/lock/data/ElectLock_Array.java

@@ -2,9 +2,12 @@


import java.sql.ResultSet;

import java.sql.SQLException;

import java.time.Year;

import java.util.ArrayList;

import java.util.Date;

import java.util.List;



import com.dev.lock.comm.Lock_Task_SQL;

import com.sql.MysqlConnPool;

import com.sql.Sql_Mysql;



@@ -27,6 +30,8 @@
      ResultSet res = null;

      boolean isChange = false;

      try {

         int nowYear = Year.now().getValue();

			
         res = sql.sqlMysqlQuery(sql_str);

         while(res.next()) {

            int lock_id = res.getInt("lock_id");

@@ -37,6 +42,9 @@
            String lock_address = res.getString("lock_address");   //'锁地址',

            String lock_path = res.getString("lock_path");         //'图片路径',

            String lock_ip = res.getString("lock_ip").trim();      //'电子锁IP地址[内网可通过IP地址识别设备]',

				
            Date lastUpdateTime = res.getTimestamp("last_update_time");

            int open_count = res.getInt("lock_open_count");

            

            boolean isexist = false;

            for(int k = 0 ;k<mInfs.size();k++) {

@@ -53,7 +61,7 @@
            if(isexist) {

               continue;

            } else {

               ElectLock_Inf tmp_lock = new ElectLock_Inf();

               ElectLock_Inf tmp_lock = new ElectLock_Inf(pool);

               tmp_lock.setLock_id(lock_id);

               tmp_lock.setArea_id(area_id);            //'区域id',

               tmp_lock.setLock_name(lock_name);         //'锁名称',

@@ -62,6 +70,13 @@
               tmp_lock.setLock_address(lock_address);      //'锁地址',

               tmp_lock.setLock_path(lock_path);         //'图片路径',

               tmp_lock.setLock_ip(lock_ip);;            //'电子锁IP地址[内网可通过IP地址识别设备]',

					
               tmp_lock.setLast_update_time(lastUpdateTime);   //上一次锁具状态更新时间

               tmp_lock.setLock_open_count(open_count);      //锁具开启次数

					
               Lock_Task_SQL.queryLock_Rt_TableByLockId(pool, lock_id, tmp_lock.lockState);

               Lock_Task_SQL.queryLock_Report_TableByLockId(pool, lock_id, tmp_lock.lockReport, nowYear);

					
               mInfs.add(tmp_lock);

            }