大理访客登记微信扫码及管理端界面sql
diff --git a/src/main/resources/data.sql b/src/main/resources/data.sql
index 13663ee..0748c4f 100644
--- a/src/main/resources/data.sql
+++ b/src/main/resources/data.sql
@@ -197,16 +197,127 @@
INSERT INTO tb_systemparam(param_key,param_value,param_desc,param_flag) VALUES ('PAYAPI_APPID','300003','登录核心平台appid','1');
INSERT INTO tb_systemparam(param_key,param_value,param_desc,param_flag) VALUES ('PAYAPI_SECRET','b32309b244904e1789b055eb1da51db1','登录核心平台secret','1');
-INSERT INTO "tb_dept"("deptcode", "deptname", "deptno", "ename", "fdeptcode", "lastsaved", "status") VALUES ('0', '根部门', 'root', NULL, '-1', NULL, 'normal');
+
+/**
+访客登记相关表sql
+ */
+ /**
+ 访客登记表
+ */
+CREATE TABLE e_visitor_check_dtl (
+id int4 NOT NULL,
+visitorname varchar(40) COLLATE default,
+phone varchar(20) COLLATE default,
+time varchar(14) COLLATE default,
+deptcode varchar(32) COLLATE default,
+custid varchar(32) COLLATE default,
+company varchar(255) COLLATE default,
+remarks varchar(255) COLLATE default,
+sex varchar(1) COLLATE default,
+status int4,
+CONSTRAINT e_visitor_check_dtl_pkey PRIMARY KEY (id)
+)
+WITH (OIDS=FALSE)
+;
+
+ALTER TABLE e_visitor_check_dtl OWNER TO payapi;
+
+/**
+访客扫码登记表
+ */
+ CREATE TABLE e_visitor_dtl (
+openid varchar(40) COLLATE default,
+nickname varchar(40) COLLATE default,
+sex varchar(40) COLLATE default,
+province varchar(40) COLLATE default,
+city varchar(40) COLLATE default,
+country varchar(40) COLLATE default,
+headimgurl varchar(255) COLLATE default,
+unionid varchar(40) COLLATE default,
+inoutflag int4,
+transdate varchar(8) COLLATE default,
+transtime varchar(6) COLLATE default,
+status int4,
+privilege varchar(40) COLLATE default,
+binddate varchar(14) COLLATE default,
+id int4 NOT NULL,
+trandtime varchar(6) COLLATE default,
+CONSTRAINT e_visitor_dtl_pkey PRIMARY KEY (id)
+)
+WITH (OIDS=FALSE)
+;
+
+ALTER TABLE e_visitor_dtl OWNER TO payapi;
+
+COMMENT ON COLUMN e_visitor_dtl.inoutflag IS '出入标记 进门-1 出门-2';
+
+COMMENT ON COLUMN e_visitor_dtl.status IS '状态';
+
+/**
+微信扫码登记信息表
+ */
+CREATE TABLE e_wechat_account (
+wxid varchar(32) COLLATE default NOT NULL,
+userid varchar(32) COLLATE default,
+appkey int4,
+openid varchar(128) COLLATE default,
+stuempno varchar(40) COLLATE default,
+status varchar(1) COLLATE default,
+binddate varchar(14) COLLATE default,
+nickname varchar(100) COLLATE default,
+sex varchar(1) COLLATE default,
+province varchar(60) COLLATE default,
+country varchar(60) COLLATE default,
+headimgurl varchar(200) COLLATE default,
+privilege varchar(40) COLLATE default,
+unionid varchar(128) COLLATE default,
+cardcode varchar(40) COLLATE default,
+city varchar(60) COLLATE default,
+CONSTRAINT e_wechat_account_pkey PRIMARY KEY (wxid)
+)
+WITH (OIDS=FALSE)
+;
+
+ALTER TABLE e_wechat_account OWNER TO payapi;
+
+
+CREATE TABLE e_wechat_config (
+id varchar(40) COLLATE default NOT NULL,
+appid varchar(40) COLLATE default,
+secret varchar(200) COLLATE default,
+shopid varchar(32) COLLATE default,
+shopkey varchar(200) COLLATE default,
+cardid varchar(40) COLLATE default,
+accesstoken varchar(200) COLLATE default,
+refreshtoken varchar(200) COLLATE default,
+tokentime int4,
+domain varchar(200) COLLATE default,
+CONSTRAINT e_wechat_config_pkey PRIMARY KEY (id)
+)
+WITH (OIDS=FALSE)
+;
+
+ALTER TABLE e_wechat_config OWNER TO payapi;
+
+
+
+
+
INSERT INTO "t_dictionary"("dicttype", "dicttypename", "dictval", "dictcaption") VALUES (8, '设备类型', 'H', '会议平板');
INSERT INTO "t_dictionary"("dicttype", "dicttypename", "dictval", "dictcaption") VALUES (16, '设备使用类别', 'HY', '会议签到');
+INSERT INTO "tb_function"("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid", "grade") VALUES (29, NULL, 0, NULL, 'layui-icon-app', '#', '会议签到', 8, -1, NULL);
+INSERT INTO "tb_function"("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid", "grade") VALUES (31, NULL, 1, NULL, '', '/system/custtypeindex', '客户类别管理', 9, 3, NULL);
+INSERT INTO "tb_function"("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid", "grade") VALUES (32, NULL, 1, NULL, '', '/system/deptindex', '部门管理', 10, 3, NULL);
+INSERT INTO "tb_function"("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid", "grade") VALUES (33, NULL, 1, NULL, '', '/customer/index', '客户管理', 2, 21, NULL);
+INSERT INTO "tb_function"("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid", "grade") VALUES (35, NULL, 1, NULL, '', '/conference/index', '会议管理', 1, 29, NULL);
INSERT INTO "tb_function"("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid", "grade") VALUES (45, NULL, 1, NULL, '', '#', '考勤流水管理', NULL, 36, NULL);
INSERT INTO "tb_function"("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid", "grade") VALUES (44, NULL, 1, NULL, '', '/confreport/index', '会议报表', 3, 29, NULL);
INSERT INTO "tb_function"("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid", "grade") VALUES (43, NULL, 1, NULL, 'layui-icon-set', '/visitor/checkin', '访客登记', 54, 38, NULL);
INSERT INTO "tb_function"("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid", "grade") VALUES (42, NULL, 1, NULL, '', '/atte/class/index', '考勤排班', NULL, 36, NULL);
+
INSERT INTO "tb_function"("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid", "grade") VALUES (41, NULL, 1, NULL, 'layui-icon-set', '/visitor/index', '访客记录查询', 53, 38, NULL);
INSERT INTO "tb_function"("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid", "grade") VALUES (40, NULL, 1, NULL, '', '/atte/custsea/index', '人员类别绑定', NULL, 36, NULL);
INSERT INTO "tb_function"("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid", "grade") VALUES (39, NULL, 1, NULL, '', '/confpeople/index', '会议人员查询', 2, 29, NULL);
@@ -218,3 +329,5 @@
INSERT INTO "tb_function"("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid", "grade") VALUES (32, NULL, 1, NULL, '', '/system/deptindex', '部门管理', 10, 3, NULL);
INSERT INTO "tb_function"("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid", "grade") VALUES (31, NULL, 1, NULL, '', '/system/custtypeindex', '客户类别管理', 9, 3, NULL);
INSERT INTO "tb_function"("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid", "grade") VALUES (29, NULL, 0, NULL, 'layui-icon-app', '#', '会议签到', 8, -1, NULL);
+
+