From 52cffc4ab8e9787a6f233295502c7c9788dddae1 Mon Sep 17 00:00:00 2001
From: fxl <473369119@qq.com>
Date: 星期二, 07 三月 2023 10:45:17 +0800
Subject: [PATCH] 3.7
---
src/main/java/com/hxzkoa/services/AttendanceService.java | 225 +++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 220 insertions(+), 5 deletions(-)
diff --git a/src/main/java/com/hxzkoa/services/AttendanceService.java b/src/main/java/com/hxzkoa/services/AttendanceService.java
index d2ba54b..e7a7335 100644
--- a/src/main/java/com/hxzkoa/services/AttendanceService.java
+++ b/src/main/java/com/hxzkoa/services/AttendanceService.java
@@ -17,7 +17,10 @@
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
+import com.hxzkoa.json.tb_cojilu;
+import com.hxzkoa.json.tb_heart_record;
import com.hxzkoa.json.tb_kaoqing;
+import com.hxzkoa.json.tb_lixianrecord;
import com.hxzkoa.json.tb_person;
import com.hxzkoa.json.tb_realkaoqing;
import com.hxzkoa.json.tb_shishi;
@@ -103,7 +106,7 @@
public List<vo_kaoqin_p> searchRealAttendance(String input) {
String sql = null;
Query query = null;
- sql = "SELECT rk.id, rk.area, rk.name, rk.bumen, rk.tagid, rk.intime, rk.beizhu, t.power FROM tb_realkaoqing rk, tb_tag t WHERE rk.tagid = t.tag_id AND rk.tagid = :tagid";
+ sql = "SELECT rk.id, rk.area, rk.name, rk.bumen, rk.tagid, rk.intime, rk.beizhu, t.power FROM tb_realkaoqing rk, tb_tag t WHERE rk.tagid = t.tag_id AND rk.tagid = :tagid OR rk.tagid = t.tag_id AND rk.name = :tagid";
query = this.em.createNativeQuery(sql);
query.setParameter("tagid", input);
List resultList = query.getResultList();
@@ -227,7 +230,7 @@
public List<vo_kaoqin_p> searchHistoricalAttendance(String input) {
String sql = null;
Query query = null;
- sql = "SELECT k.id,k.area,k.name,k.bumen,k.tagid,k.intime,k.outtime,k.alltime,k.beizhu,t.power FROM tb_kaoqing k,tb_tag t WHERE k.tagid = t.tag_id AND k.tagid = :tagid";
+ sql = "SELECT k.id,k.area,k.name,k.bumen,k.tagid,k.intime,k.outtime,k.alltime,k.beizhu,t.power FROM tb_kaoqing k,tb_tag t WHERE k.tagid = t.tag_id AND k.tagid = :tagid OR k.tagid = t.tag_id AND k.name = :tagid";
query = this.em.createNativeQuery(sql);
query.setParameter("tagid", input);
List resultList = query.getResultList();
@@ -347,15 +350,15 @@
public List<Object> gettongjishuju() {
String sql = null;
Query query = null;
- sql = "SELECT type_name,num FROM tb_tongji";
+ sql = "SELECT type,num FROM tb_tongji";
query = this.em.createNativeQuery(sql);
List resultList = query.getResultList();
List<String> rMap = new ArrayList<String>();
- List<Integer> reMap = new ArrayList<Integer>();
+ List<String> reMap = new ArrayList<String>();
for (int i = 0; i < resultList.size(); i++) {
Object[] obj = (Object[]) resultList.get(i);
rMap.add(obj[0].toString());
- reMap.add(Integer.parseInt(obj[1].toString()));
+ reMap.add(obj[1].toString());
}
List<Object> zong = new ArrayList<Object>();
zong.add(rMap);
@@ -399,4 +402,216 @@
return gaojing;
}
+ public List<tb_heart_record> findxinlv(int page){
+ String sql = null;
+ Query query = null;
+ sql = "select id,tagid,name,heart,okheart,state,time from tb_heart_record ORDER BY time DESC LIMIT :start,:end";
+ query = this.em.createNativeQuery(sql);
+ query.setParameter("start", (page - 1) * Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")));
+ query.setParameter("end", Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")));
+ List resultlist = query.getResultList();
+ List<tb_heart_record> permissions = new ArrayList<>();
+ if (resultlist.size() > 0) {
+ for (int i=0; i<resultlist.size(); i++) {
+ Object[] obj = (Object[])resultlist.get(i);
+ tb_heart_record per = new tb_heart_record();
+ per.setId((int)obj[0]);
+ per.setTagid(obj[1] == null?null:obj[1].toString());
+ per.setName(obj[2] == null?null:obj[2].toString());
+ per.setHeart(obj[3] == null?null:obj[3].toString());
+ per.setOkheart(obj[4] == null?null:obj[4].toString());
+ per.setState(obj[5] == null?null:obj[5].toString());
+ per.setTime(obj[6] == null?null:obj[6].toString());
+ permissions.add(per);
+ }
+ }
+ return permissions;
+ }
+
+ public List<tb_heart_record> findxinlv2(){
+ String sql = null;
+ Query query = null;
+ sql = "select id,tagid,name,heart,okheart,state,time from tb_heart_record ORDER BY time DESC";
+ query = this.em.createNativeQuery(sql);
+ List resultlist = query.getResultList();
+ List<tb_heart_record> permissions = new ArrayList<>();
+ if (resultlist.size() > 0) {
+ for (int i=0; i<resultlist.size(); i++) {
+ Object[] obj = (Object[])resultlist.get(i);
+ tb_heart_record per = new tb_heart_record();
+ per.setId((int)obj[0]);
+ per.setTagid(obj[1] == null?null:obj[1].toString());
+ per.setName(obj[2] == null?null:obj[2].toString());
+ per.setHeart(obj[3] == null?null:obj[3].toString());
+ per.setOkheart(obj[4] == null?null:obj[4].toString());
+ per.setState(obj[5] == null?null:obj[5].toString());
+ per.setTime(obj[6] == null?null:obj[6].toString());
+ permissions.add(per);
+ }
+ }
+ return permissions;
+ }
+
+ public List<tb_heart_record> findxinlv3(String input){
+ String sql = null;
+ Query query = null;
+ sql = "select id,tagid,name,heart,okheart,state,time from tb_heart_record WHERE tagid = :input OR name = :input ORDER BY time DESC";
+ query = this.em.createNativeQuery(sql);
+ query.setParameter("input", input);
+ List resultlist = query.getResultList();
+ List<tb_heart_record> permissions = new ArrayList<>();
+ if (resultlist.size() > 0) {
+ for (int i=0; i<resultlist.size(); i++) {
+ Object[] obj = (Object[])resultlist.get(i);
+ tb_heart_record per = new tb_heart_record();
+ per.setId((int)obj[0]);
+ per.setTagid(obj[1] == null?null:obj[1].toString());
+ per.setName(obj[2] == null?null:obj[2].toString());
+ per.setHeart(obj[3] == null?null:obj[3].toString());
+ per.setOkheart(obj[4] == null?null:obj[4].toString());
+ per.setState(obj[5] == null?null:obj[5].toString());
+ per.setTime(obj[6] == null?null:obj[6].toString());
+ permissions.add(per);
+ }
+ }
+ return permissions;
+ }
+
+ public int getxinlvManagementCount() {
+ String sql = null;
+ Query query = null;
+ sql = "SELECT count(1) FROM tb_heart_record";
+ query = this.em.createNativeQuery(sql);
+ return Integer.parseInt(query.getSingleResult().toString());
+ }
+
+ @Transactional
+ public void xinlv_delete(String[] checkVal) {
+ String sql = null;
+ Query query = null;
+ for (int i = 0; i < checkVal.length; i++) {
+ int id = Integer.parseInt(checkVal[i]);
+ sql = "DELETE FROM tb_heart_record WHERE id = :id";
+ query = this.em.createNativeQuery(sql);
+ query.setParameter("id", id);
+ query.executeUpdate();
+ }
+ }
+
+ @Transactional
+ public void xinlv_deletea() {
+ String sql = null;
+ Query query = null;
+ sql = "DELETE FROM tb_heart_record";
+ query = this.em.createNativeQuery(sql);
+ query.executeUpdate();
+ }
+
+ public List<tb_cojilu> findco(int page){
+ String sql = null;
+ Query query = null;
+ sql = "select id,tagid,name,nongdu,oknongdu,state,xypos,time from tb_cojilu ORDER BY time DESC LIMIT :start,:end";
+ query = this.em.createNativeQuery(sql);
+ query.setParameter("start", (page - 1) * Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")));
+ query.setParameter("end", Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")));
+ List resultlist = query.getResultList();
+ List<tb_cojilu> permissions = new ArrayList<>();
+ if (resultlist.size() > 0) {
+ for (int i=0; i<resultlist.size(); i++) {
+ Object[] obj = (Object[])resultlist.get(i);
+ tb_cojilu per = new tb_cojilu();
+ per.setId((int)obj[0]);
+ per.setTagid(obj[1] == null?null:obj[1].toString());
+ per.setName(obj[2] == null?null:obj[2].toString());
+ per.setNongdu(obj[3] == null?null:obj[3].toString());
+ per.setOknongdu(obj[4] == null?null:obj[4].toString());
+ per.setState(obj[5] == null?null:obj[5].toString());
+ per.setXypos(obj[6] == null?null:obj[6].toString());
+ per.setTime(obj[7] == null?null:obj[7].toString());
+ permissions.add(per);
+ }
+ }
+ return permissions;
+ }
+
+ public List<tb_cojilu> findco2(){
+ String sql = null;
+ Query query = null;
+ sql = "select id,tagid,name,nongdu,oknongdu,state,xypos,time from tb_cojilu ORDER BY time DESC";
+ query = this.em.createNativeQuery(sql);
+ List resultlist = query.getResultList();
+ List<tb_cojilu> permissions = new ArrayList<>();
+ if (resultlist.size() > 0) {
+ for (int i=0; i<resultlist.size(); i++) {
+ Object[] obj = (Object[])resultlist.get(i);
+ tb_cojilu per = new tb_cojilu();
+ per.setId((int)obj[0]);
+ per.setTagid(obj[1] == null?null:obj[1].toString());
+ per.setName(obj[2] == null?null:obj[2].toString());
+ per.setNongdu(obj[3] == null?null:obj[3].toString());
+ per.setOknongdu(obj[4] == null?null:obj[4].toString());
+ per.setState(obj[5] == null?null:obj[5].toString());
+ per.setXypos(obj[6] == null?null:obj[6].toString());
+ per.setTime(obj[7] == null?null:obj[7].toString());
+ permissions.add(per);
+ }
+ }
+ return permissions;
+ }
+
+ public List<tb_cojilu> findco3(String input){
+ String sql = null;
+ Query query = null;
+ sql = "select id,tagid,name,nongdu,oknongdu,state,xypos,time from tb_cojilu WHERE tagid = :input OR name = :input ORDER BY time DESC";
+ query = this.em.createNativeQuery(sql);
+ query.setParameter("input", input);
+ List resultlist = query.getResultList();
+ List<tb_cojilu> permissions = new ArrayList<>();
+ if (resultlist.size() > 0) {
+ for (int i=0; i<resultlist.size(); i++) {
+ Object[] obj = (Object[])resultlist.get(i);
+ tb_cojilu per = new tb_cojilu();
+ per.setId((int)obj[0]);
+ per.setTagid(obj[1] == null?null:obj[1].toString());
+ per.setName(obj[2] == null?null:obj[2].toString());
+ per.setNongdu(obj[3] == null?null:obj[3].toString());
+ per.setOknongdu(obj[4] == null?null:obj[4].toString());
+ per.setState(obj[5] == null?null:obj[5].toString());
+ per.setXypos(obj[6] == null?null:obj[6].toString());
+ per.setTime(obj[7] == null?null:obj[7].toString());
+ permissions.add(per);
+ }
+ }
+ return permissions;
+ }
+
+ public int getcoManagementCount() {
+ String sql = null;
+ Query query = null;
+ sql = "SELECT count(1) FROM tb_cojilu";
+ query = this.em.createNativeQuery(sql);
+ return Integer.parseInt(query.getSingleResult().toString());
+ }
+
+ @Transactional
+ public void co_delete(String[] checkVal) {
+ String sql = null;
+ Query query = null;
+ for (int i = 0; i < checkVal.length; i++) {
+ int id = Integer.parseInt(checkVal[i]);
+ sql = "DELETE FROM tb_cojilu WHERE id = :id";
+ query = this.em.createNativeQuery(sql);
+ query.setParameter("id", id);
+ query.executeUpdate();
+ }
+ }
+
+ @Transactional
+ public void co_deletea() {
+ String sql = null;
+ Query query = null;
+ sql = "DELETE FROM tb_cojilu";
+ query = this.em.createNativeQuery(sql);
+ query.executeUpdate();
+ }
}
--
Gitblit v1.10.0