流水查询
diff --git a/src/main/resources/data.sql b/src/main/resources/data.sql
index 83baf7d..2ef0d00 100644
--- a/src/main/resources/data.sql
+++ b/src/main/resources/data.sql
@@ -225,23 +225,26 @@
INSERT INTO "tb_dept"("deptcode", "deptname", "deptno", "ename", "fdeptcode", "lastsaved", "status") VALUES ('0', '根部门', 'root', NULL, '-1', NULL, 'normal');
--atte
-create view v_atte_dtl as SELECT t.transdate,
- t.transtime,
- substr((t.doorid)::text, 5) AS deviceid,
- t.doorseqno,
- t.cardno,
- t.cardphyid,
- t.bankcardno,
- t.custid,
- t.custname,
- t.status,
- t.devtype
- FROM t_doordtl t
- WHERE ((substr((t.doorid)::text, 5))::integer IN ( SELECT DISTINCT d.deviceid
+create view v_atte_dtl as SELECT t.transdate,
+ t.transtime,
+ substr((t.doorid)::text, 5) AS deviceid,
+ t.doorseqno,
+ t.cardno,
+ t.cardphyid,
+ t.bankcardno,
+ t.custid,
+ t.custname,
+ t.status,
+ t.devtype,
+ ((((t.transdate)::text || (t.factoryid)::text) || (t.doorid)::text) || (t.doorseqno)::text) AS dtlid
+ FROM t_doordtl t
+ WHERE (((substr((t.doorid)::text, 5))::integer IN ( SELECT DISTINCT d.deviceid
FROM (t_dev_rule d
LEFT JOIN t_atte_rule r ON ((d.ruleid = r.id)))
- WHERE (r.status = 1)))
- ORDER BY t.doorseqno;
+ WHERE (r.status = 1))) AND (EXISTS ( SELECT t_customer.custid
+ FROM t_customer
+ WHERE ((t_customer.custid)::text = (t.custid)::text))))
+ ORDER BY t.doorseqno
INSERT INTO "tb_businesspara" VALUES ('atte_bmin', '60');
INSERT INTO "tb_businesspara" VALUES ('atte_min', '60');