From cd40c6f6f3a6138cb70b2e2d017cc7f34a887ef8 Mon Sep 17 00:00:00 2001
From: lgq <1015864684@qq.com>
Date: 星期五, 17 四月 2026 13:59:49 +0800
Subject: [PATCH] 1.更新vf107代码，更新自动上报通行记录接口、人员查询接口、人员添加接口
---
vf107/src/service/sqliteService.js | 16 ++++++++++++++++
1 files changed, 16 insertions(+), 0 deletions(-)
diff --git a/vf107/src/service/sqliteService.js b/vf107/src/service/sqliteService.js
index d5fcd26..9b41ded 100644
--- a/vf107/src/service/sqliteService.js
+++ b/vf107/src/service/sqliteService.js
@@ -29,9 +29,11 @@
extra: "TEXT",
extra2: "TEXT",
message: "TEXT",
+ reported: "INTEGER DEFAULT 0",
},
d1_permission: {
permissionId: "VARCHAR(128) PRIMARY KEY",
+ userId: "VARCHAR(128)",
door: "VARCHAR(128)",
extra: "TEXT",
timeType: "INTEGER",
@@ -59,6 +61,14 @@
name: "VARCHAR(128)",
extra: "TEXT",
permissionIds: "TEXT",
+ },
+ d1_emergency_password: {
+ id: "VARCHAR(128) PRIMARY KEY",
+ password: "VARCHAR(128)",
+ description: "TEXT",
+ createTime: "INTEGER",
+ updateTime: "INTEGER",
+ status: "INTEGER",
}
}
@@ -133,6 +143,7 @@
sqliteService.d1_security = new Proxy({ tableName: "d1_security" }, handler);
sqliteService.d1_voucher = new Proxy({ tableName: "d1_voucher" }, handler);
sqliteService.d1_person = new Proxy({ tableName: "d1_person" }, handler);
+sqliteService.d1_emergency_password = new Proxy({ tableName: "d1_emergency_password" }, handler);
// 鎸夊鍚嶆ā绯婃煡璇汉鍛�
sqliteService.findPersonsByNameLike = function (name) {
@@ -165,6 +176,11 @@
return sqliteService.select(query)
}
+// 鏌ヨ鎵�鏈夋湭涓婃姤鐨勯�氳璁板綍锛堟寜鏃堕棿鍗囧簭锛�
+sqliteService.d1_pass_record.findAllByReportedOrderByTimeStampAsc = function () {
+ const sql = `SELECT * FROM d1_pass_record WHERE reported = 0 OR reported IS NULL ORDER BY timeStamp ASC;`
+ return sqliteService.select(sql)
+}
// 寮�濮嬩簨鍔★紝浜嬪姟涓嶆彁浜ゆ暟鎹簱閲嶅惎鍚庯紝鏁版嵁浼氳繕鍘燂紝鎵�浠ransaction鍚庝竴瀹氳commit锛屼絾鏄鏋滃湪涓�涓簨鍔″皻鏈彁浜ゆ垨鍥炴粴鐨勬儏鍐典笅鎵ц鍙︿竴涓� BEGIN TRANSACTION锛孲QLite 浼氳嚜鍔ㄥ皢鏂扮殑浜嬪姟宓屽鍦ㄤ箣鍓嶇殑浜嬪姟鍐呴儴锛岃�屼笉鏄鐩栦箣鍓嶇殑浜嬪姟銆�
sqliteService.transaction = function () {
--
Gitblit v1.9.3