pco_system.sql 110 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350
  1. /*
  2. Navicat Premium Data Transfer
  3. Source Server : local
  4. Source Server Type : MySQL
  5. Source Server Version : 80027
  6. Source Host : localhost:3306
  7. Source Schema : pco_system
  8. Target Server Type : MySQL
  9. Target Server Version : 80027
  10. File Encoding : 65001
  11. Date: 12/01/2022 15:23:30
  12. */
  13. SET NAMES utf8mb4;
  14. SET FOREIGN_KEY_CHECKS = 0;
  15. -- ----------------------------
  16. -- Table structure for sp_admin
  17. -- ----------------------------
  18. DROP TABLE IF EXISTS `sp_admin`;
  19. CREATE TABLE `sp_admin` (
  20. `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT 'id,--主键、自增',
  21. `customer_id` bigint(0) NULL DEFAULT NULL COMMENT '客户id',
  22. `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'admin名称',
  23. `avatar` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像地址',
  24. `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  25. `pw` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '明文密码',
  26. `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
  27. `role_id` int(0) NULL DEFAULT 11 COMMENT '所属角色id',
  28. `status` int(0) NULL DEFAULT 1 COMMENT '账号状态(1=正常, 2=禁用)',
  29. `create_by_aid` bigint(0) NULL DEFAULT -1 COMMENT '创建自哪个管理员',
  30. `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  31. `login_time` datetime(0) NULL DEFAULT NULL COMMENT '上次登陆时间',
  32. `login_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上次登陆IP',
  33. `login_count` int(0) NULL DEFAULT 0 COMMENT '登陆次数',
  34. PRIMARY KEY (`id`) USING BTREE,
  35. UNIQUE INDEX `name`(`name`) USING BTREE
  36. ) ENGINE = InnoDB AUTO_INCREMENT = 10003 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统管理员表' ROW_FORMAT = Compact;
  37. -- ----------------------------
  38. -- Records of sp_admin
  39. -- ----------------------------
  40. INSERT INTO `sp_admin` VALUES (10001, -1, 'sa', 'http://sa-admin.dev33.cn/sa-frame/admin-logo.png', 'E4EF2A290589A23EFE1565BB698437F5', '123456', NULL, 1, 1, -1, '2022-01-12 11:49:36', '2022-01-12 15:17:41', '127.0.0.1', 4);
  41. INSERT INTO `sp_admin` VALUES (10002, 1, 'admin', 'http://sa-admin.dev33.cn/sa-frame/admin-logo.png', '1DE197572C0B23B82BB2F54202E8E00B', 'admin', NULL, 2, 1, -1, '2022-01-12 11:49:36', '2022-01-12 15:01:40', '127.0.0.1', 3);
  42. -- ----------------------------
  43. -- Table structure for sp_apilog
  44. -- ----------------------------
  45. DROP TABLE IF EXISTS `sp_apilog`;
  46. CREATE TABLE `sp_apilog` (
  47. `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '请求id',
  48. `req_ip` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户端ip',
  49. `req_api` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求api',
  50. `req_parame` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '请求参数',
  51. `req_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求类型(GET、POST...)',
  52. `req_token` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求token',
  53. `req_header` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '请求header',
  54. `res_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '返回-状态码',
  55. `res_msg` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '返回-信息描述',
  56. `res_string` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '返回-整个信息字符串形式',
  57. `user_id` bigint(0) NULL DEFAULT NULL COMMENT 'user_id',
  58. `admin_id` bigint(0) NULL DEFAULT NULL COMMENT 'admin_id',
  59. `start_time` datetime(3) NULL DEFAULT NULL COMMENT '请求开始时间',
  60. `end_time` datetime(3) NULL DEFAULT NULL COMMENT '请求结束时间',
  61. `cost_time` bigint(0) NULL DEFAULT NULL COMMENT '花费时间,单位ms',
  62. PRIMARY KEY (`id`) USING BTREE
  63. ) ENGINE = InnoDB AUTO_INCREMENT = 10001 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'api请求记录表' ROW_FORMAT = Compact;
  64. -- ----------------------------
  65. -- Records of sp_apilog
  66. -- ----------------------------
  67. INSERT INTO `sp_apilog` VALUES (1481111693802213376, '127.0.0.1', '/AccAdmin/doLogin', '{\"password\":\"123456\",\"key\":\"sa\"}', 'POST', NULL, '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"22\",\"referer\":\"http://localhost:63343/\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":{\"admin\":{\"id\":10001,\"name\":\"sa\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"123456\",\"phone\":null,\"roleId\":1,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641959521103,\"loginIp\":\"127.0.0.1\",\"loginCount\":1,\"roleName\":\"超级管理员\"},\"per_list\":[\"bas\",\"1\",\"11\",\"99\",\"console\",\"sql-console\",\"redis-console\",\"apilog-list\",\"form-generator\",\"auth\",\"role-list\",\"menu-list\",\"admin-list\",\"admin-add\",\"sp-cfg\",\"sp-cfg-app\",\"sp-cfg-server\"],\"tokenInfo\":{\"tokenName\":\"satoken\",\"tokenValue\":\"e111bdac-3c1d-48a1-b978-eb53c4450251\",\"isLogin\":true,\"loginId\":\"10001\",\"loginType\":\"login\",\"tokenTimeout\":2592000,\"sessionTimeout\":2592000,\"tokenSessionTimeout\":-2,\"tokenActivityTimeout\":-1,\"loginDevice\":\"default-device\",\"tag\":null}},\"dataCount\":-1}', 0, 0, '2022-01-12 03:52:00.278', '2022-01-12 03:52:02.502', 2224);
  68. INSERT INTO `sp_apilog` VALUES (1481111710898196480, '127.0.0.1', '/AccAdmin/fristOpenAdmin', '{}', 'POST', 'e111bdac-3c1d-48a1-b978-eb53c4450251', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"e111bdac-3c1d-48a1-b978-eb53c4450251\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":{\"admin\":{\"id\":10001,\"name\":\"sa\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"123456\",\"phone\":null,\"roleId\":1,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641988321000,\"loginIp\":\"127.0.0.1\",\"loginCount\":1,\"roleName\":\"超级管理员\"},\"per_list\":[\"bas\",\"1\",\"11\",\"99\",\"console\",\"sql-console\",\"redis-console\",\"apilog-list\",\"form-generator\",\"auth\",\"role-list\",\"menu-list\",\"admin-list\",\"admin-add\",\"sp-cfg\",\"sp-cfg-app\",\"sp-cfg-server\"],\"app_cfg\":null},\"dataCount\":-1}', 0, 10001, '2022-01-12 03:52:04.264', '2022-01-12 03:52:04.309', 45);
  69. INSERT INTO `sp_apilog` VALUES (1481111753986281472, '127.0.0.1', '/RedisConsole/getPreInfo', '{\"sortType\":\"0\",\"pageNo\":\"1\",\"pageSize\":\"10\",\"k\":\"\"}', 'POST', 'e111bdac-3c1d-48a1-b978-eb53c4450251', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"34\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"e111bdac-3c1d-48a1-b978-eb53c4450251\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":{\"keys_count\":15,\"keyspace_hits\":\"4425\",\"used_memory_human\":\"743.14K\",\"used_memory_peak_human\":\"929.80K\",\"uptime_in_seconds\":\"584606\",\"isGtMax\":false},\"dataCount\":-1}', 0, 10001, '2022-01-12 03:52:14.535', '2022-01-12 03:52:14.583', 48);
  70. INSERT INTO `sp_apilog` VALUES (1481111754250522624, '127.0.0.1', '/RedisConsole/getKeys', '{\"k\":\"\"}', 'POST', 'e111bdac-3c1d-48a1-b978-eb53c4450251', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"2\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"e111bdac-3c1d-48a1-b978-eb53c4450251\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[\"api_pcode_list::1\",\"api_pcode_list2::1\",\"app:token:1465226520326483970\",\"app:token:1469215321943498754\",\"app:token:1469225326939791362\",\"app:token:2\",\"per:10016\",\"satoken:login:id:10016\",\"satoken:login:session:10001\",\"satoken:login:token:d85a0340-c320-49ac-bf75-eb5522680c42\",\"satoken:login:token:e111bdac-3c1d-48a1-b978-eb53c4450251\",\"sesstion:10016\",\"sp_cfg_::AppCfg\",\"VAR_GATEWAY_AUTH_TOKEN_KEY\",\"VAR_GATEWAY_AUTH_TOKEN_REFRESH_LAST_TIME_KEY\"],\"dataCount\":-1}', 0, 10001, '2022-01-12 03:52:14.599', '2022-01-12 03:52:14.611', 12);
  71. INSERT INTO `sp_apilog` VALUES (1481151862056030208, '127.0.0.1', '/AccAdmin/fristOpenAdmin', '{}', 'POST', 'e111bdac-3c1d-48a1-b978-eb53c4450251', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"e111bdac-3c1d-48a1-b978-eb53c4450251\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":{\"admin\":{\"id\":10001,\"name\":\"sa\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"123456\",\"phone\":null,\"roleId\":1,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641988321000,\"loginIp\":\"127.0.0.1\",\"loginCount\":1,\"roleName\":\"超级管理员\"},\"per_list\":[\"bas\",\"1\",\"11\",\"99\",\"console\",\"sql-console\",\"redis-console\",\"apilog-list\",\"form-generator\",\"auth\",\"role-list\",\"menu-list\",\"admin-list\",\"admin-add\",\"sp-cfg\",\"sp-cfg-app\",\"sp-cfg-server\"],\"app_cfg\":null},\"dataCount\":-1}', 0, 10001, '2022-01-12 06:31:37.046', '2022-01-12 06:31:37.097', 51);
  72. INSERT INTO `sp_apilog` VALUES (1481151875293253632, '127.0.0.1', '/role/getList', '{\"pageNo\":\"1\",\"name\":\"\",\"pageSize\":\"1000\"}', 'POST', 'e111bdac-3c1d-48a1-b978-eb53c4450251', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"28\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"e111bdac-3c1d-48a1-b978-eb53c4450251\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[{\"id\":1,\"name\":\"超级管理员\",\"info\":\"最高权限\",\"isLock\":1,\"createTime\":1641988176000},{\"id\":2,\"name\":\"二级管理员\",\"info\":\"二级管理员\",\"isLock\":2,\"createTime\":1641988176000},{\"id\":11,\"name\":\"普通账号\",\"info\":\"普通账号\",\"isLock\":1,\"createTime\":1641988176000},{\"id\":12,\"name\":\"测试角色\",\"info\":\"测试角色\",\"isLock\":2,\"createTime\":1641988176000}],\"dataCount\":-1}', 0, 10001, '2022-01-12 06:31:40.206', '2022-01-12 06:31:40.264', 58);
  73. INSERT INTO `sp_apilog` VALUES (1481151884462002176, '127.0.0.1', '/SpRolePermission/getPcodeByRid', '{\"roleId\":\"2\"}', 'POST', 'e111bdac-3c1d-48a1-b978-eb53c4450251', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"e111bdac-3c1d-48a1-b978-eb53c4450251\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[],\"dataCount\":-1}', 0, 10001, '2022-01-12 06:31:42.385', '2022-01-12 06:31:42.433', 48);
  74. INSERT INTO `sp_apilog` VALUES (1481152055484747776, '127.0.0.1', '/SpRolePermission/updatePcodeByRid', '{\"code\":[\"tb-business\",\"tb-business-list\",\"tb-business-add\",\"tb-business-item\",\"tb-business-item-list\",\"tb-business-item-add\",\"tb-costomer\",\"tb-costomer-list\",\"tb-costomer-add\",\"tb-item\",\"tb-item-list\",\"tb-item-add\"],\"roleId\":\"2\"}', 'POST', 'e111bdac-3c1d-48a1-b978-eb53c4450251', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"243\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"e111bdac-3c1d-48a1-b978-eb53c4450251\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":12,\"dataCount\":-1}', 0, 10001, '2022-01-12 06:32:23.175', '2022-01-12 06:32:23.214', 39);
  75. INSERT INTO `sp_apilog` VALUES (1481152100934225920, '127.0.0.1', '/role/delete', '{\"id\":\"12\"}', 'POST', 'e111bdac-3c1d-48a1-b978-eb53c4450251', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"5\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"e111bdac-3c1d-48a1-b978-eb53c4450251\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":1,\"dataCount\":-1}', 0, 10001, '2022-01-12 06:32:33.997', '2022-01-12 06:32:34.033', 36);
  76. INSERT INTO `sp_apilog` VALUES (1481152180831522816, '127.0.0.1', '/role/update', '{\"isLock\":\"2\",\"is_update\":\"true\",\"name\":\"管理员\",\"id\":\"2\",\"info\":\"二级管理员\"}', 'POST', 'e111bdac-3c1d-48a1-b978-eb53c4450251', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"112\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"e111bdac-3c1d-48a1-b978-eb53c4450251\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":1,\"dataCount\":-1}', 0, 10001, '2022-01-12 06:32:53.045', '2022-01-12 06:32:53.079', 34);
  77. INSERT INTO `sp_apilog` VALUES (1481152235168731136, '127.0.0.1', '/role/update', '{\"isLock\":\"1\",\"is_update\":\"true\",\"name\":\"客户\",\"id\":\"11\",\"info\":\"普通账号\"}', 'POST', 'e111bdac-3c1d-48a1-b978-eb53c4450251', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"95\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"e111bdac-3c1d-48a1-b978-eb53c4450251\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":1,\"dataCount\":-1}', 0, 10001, '2022-01-12 06:33:06.000', '2022-01-12 06:33:06.030', 30);
  78. INSERT INTO `sp_apilog` VALUES (1481154996451020800, '127.0.0.1', '/SpRolePermission/getPcodeByRid', '{\"roleId\":\"2\"}', 'POST', 'e111bdac-3c1d-48a1-b978-eb53c4450251', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"e111bdac-3c1d-48a1-b978-eb53c4450251\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[\"tb-business\",\"tb-business-list\",\"tb-business-add\",\"tb-business-item\",\"tb-business-item-list\",\"tb-business-item-add\",\"tb-costomer\",\"tb-costomer-list\",\"tb-costomer-add\",\"tb-item\",\"tb-item-list\",\"tb-item-add\"],\"dataCount\":-1}', 0, 10001, '2022-01-12 06:44:05.056', '2022-01-12 06:44:05.923', 867);
  79. INSERT INTO `sp_apilog` VALUES (1481158631612354560, '127.0.0.1', '/AccAdmin/doExit', '{}', 'POST', 'e111bdac-3c1d-48a1-b978-eb53c4450251', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"e111bdac-3c1d-48a1-b978-eb53c4450251\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":null,\"dataCount\":-1}', 0, 10001, '2022-01-12 06:58:31.471', '2022-01-12 06:58:31.552', 81);
  80. INSERT INTO `sp_apilog` VALUES (1481158662323048448, '127.0.0.1', '/AccAdmin/doLogin', '{\"password\":\"123456\",\"key\":\"admin\"}', 'POST', 'e111bdac-3c1d-48a1-b978-eb53c4450251', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"25\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"e111bdac-3c1d-48a1-b978-eb53c4450251\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '500', '密码错误', '{\"code\":500,\"msg\":\"密码错误\",\"data\":null,\"dataCount\":-1}', 0, 0, '2022-01-12 06:58:38.354', '2022-01-12 06:58:38.400', 46);
  81. INSERT INTO `sp_apilog` VALUES (1481158703901184000, '127.0.0.1', '/AccAdmin/doLogin', '{\"password\":\"admin\",\"key\":\"admin\"}', 'POST', 'e111bdac-3c1d-48a1-b978-eb53c4450251', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"24\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"e111bdac-3c1d-48a1-b978-eb53c4450251\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":{\"admin\":{\"id\":10002,\"name\":\"admin\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"admin\",\"phone\":null,\"roleId\":1,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641970728297,\"loginIp\":\"127.0.0.1\",\"loginCount\":1,\"roleName\":\"超级管理员\"},\"per_list\":[\"bas\",\"1\",\"11\",\"99\",\"console\",\"sql-console\",\"redis-console\",\"apilog-list\",\"form-generator\",\"auth\",\"role-list\",\"menu-list\",\"admin-list\",\"admin-add\",\"sp-cfg\",\"sp-cfg-app\",\"sp-cfg-server\"],\"tokenInfo\":{\"tokenName\":\"satoken\",\"tokenValue\":\"09783595-9754-4f3b-b85f-a4f4ee7e031c\",\"isLogin\":true,\"loginId\":\"10002\",\"loginType\":\"login\",\"tokenTimeout\":2592000,\"sessionTimeout\":2592000,\"tokenSessionTimeout\":-2,\"tokenActivityTimeout\":-1,\"loginDevice\":\"default-device\",\"tag\":null}},\"dataCount\":-1}', 0, 0, '2022-01-12 06:58:48.268', '2022-01-12 06:58:48.356', 88);
  82. INSERT INTO `sp_apilog` VALUES (1481158707436982272, '127.0.0.1', '/AccAdmin/fristOpenAdmin', '{}', 'POST', '09783595-9754-4f3b-b85f-a4f4ee7e031c', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"09783595-9754-4f3b-b85f-a4f4ee7e031c\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":{\"admin\":{\"id\":10002,\"name\":\"admin\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"admin\",\"phone\":null,\"roleId\":1,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641999528000,\"loginIp\":\"127.0.0.1\",\"loginCount\":1,\"roleName\":\"超级管理员\"},\"per_list\":[\"bas\",\"1\",\"11\",\"99\",\"console\",\"sql-console\",\"redis-console\",\"apilog-list\",\"form-generator\",\"auth\",\"role-list\",\"menu-list\",\"admin-list\",\"admin-add\",\"sp-cfg\",\"sp-cfg-app\",\"sp-cfg-server\"],\"app_cfg\":null},\"dataCount\":-1}', 0, 10002, '2022-01-12 06:58:49.117', '2022-01-12 06:58:49.147', 30);
  83. INSERT INTO `sp_apilog` VALUES (1481158764076863488, '127.0.0.1', '/role/getList', '{\"pageNo\":\"1\",\"name\":\"\",\"pageSize\":\"1000\"}', 'POST', '09783595-9754-4f3b-b85f-a4f4ee7e031c', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"28\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"09783595-9754-4f3b-b85f-a4f4ee7e031c\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[{\"id\":1,\"name\":\"超级管理员\",\"info\":\"最高权限\",\"isLock\":1,\"createTime\":1641988176000},{\"id\":2,\"name\":\"管理员\",\"info\":\"二级管理员\",\"isLock\":2,\"createTime\":1641988176000},{\"id\":11,\"name\":\"客户\",\"info\":\"普通账号\",\"isLock\":1,\"createTime\":1641988176000}],\"dataCount\":-1}', 0, 10002, '2022-01-12 06:59:02.620', '2022-01-12 06:59:02.714', 94);
  84. INSERT INTO `sp_apilog` VALUES (1481158782032678912, '127.0.0.1', '/role/getList', '{}', 'POST', '09783595-9754-4f3b-b85f-a4f4ee7e031c', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"09783595-9754-4f3b-b85f-a4f4ee7e031c\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[{\"id\":1,\"name\":\"超级管理员\",\"info\":\"最高权限\",\"isLock\":1,\"createTime\":1641988176000},{\"id\":2,\"name\":\"管理员\",\"info\":\"二级管理员\",\"isLock\":2,\"createTime\":1641988176000},{\"id\":11,\"name\":\"客户\",\"info\":\"普通账号\",\"isLock\":1,\"createTime\":1641988176000}],\"dataCount\":-1}', 0, 10002, '2022-01-12 06:59:06.899', '2022-01-12 06:59:06.960', 61);
  85. INSERT INTO `sp_apilog` VALUES (1481158782032678913, '127.0.0.1', '/admin/getList', '{\"sort_type\":\"0\",\"roleId\":\"\",\"pageNo\":\"1\",\"name\":\"\",\"pageSize\":\"10\",\"id\":\"\"}', 'POST', '09783595-9754-4f3b-b85f-a4f4ee7e031c', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"50\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"09783595-9754-4f3b-b85f-a4f4ee7e031c\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[{\"id\":10002,\"name\":\"admin\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"admin\",\"phone\":null,\"roleId\":1,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641999528000,\"loginIp\":\"127.0.0.1\",\"loginCount\":1,\"roleName\":\"超级管理员\"},{\"id\":10001,\"name\":\"sa\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"123456\",\"phone\":null,\"roleId\":1,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641988321000,\"loginIp\":\"127.0.0.1\",\"loginCount\":1,\"roleName\":\"超级管理员\"}],\"dataCount\":2,\"pageNo\":1,\"pageSize\":10,\"startIndex\":0,\"pageCount\":1}', 0, 10002, '2022-01-12 06:59:06.899', '2022-01-12 06:59:07.012', 113);
  86. INSERT INTO `sp_apilog` VALUES (1481158820351840256, '127.0.0.1', '/AccAdmin/doExit', '{}', 'POST', '09783595-9754-4f3b-b85f-a4f4ee7e031c', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"09783595-9754-4f3b-b85f-a4f4ee7e031c\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":null,\"dataCount\":-1}', 0, 10002, '2022-01-12 06:59:16.031', '2022-01-12 06:59:16.035', 4);
  87. INSERT INTO `sp_apilog` VALUES (1481158832666316800, '127.0.0.1', '/AccAdmin/doLogin', '{\"password\":\"123456\",\"key\":\"sa\"}', 'POST', '09783595-9754-4f3b-b85f-a4f4ee7e031c', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"22\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"09783595-9754-4f3b-b85f-a4f4ee7e031c\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":{\"admin\":{\"id\":10001,\"name\":\"sa\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"123456\",\"phone\":null,\"roleId\":1,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641970758991,\"loginIp\":\"127.0.0.1\",\"loginCount\":2,\"roleName\":\"超级管理员\"},\"per_list\":[\"bas\",\"1\",\"11\",\"99\",\"console\",\"sql-console\",\"redis-console\",\"apilog-list\",\"form-generator\",\"auth\",\"role-list\",\"menu-list\",\"admin-list\",\"admin-add\",\"sp-cfg\",\"sp-cfg-app\",\"sp-cfg-server\"],\"tokenInfo\":{\"tokenName\":\"satoken\",\"tokenValue\":\"9fc19dc9-3dca-46b0-aee6-81a9a8e0c215\",\"isLogin\":true,\"loginId\":\"10001\",\"loginType\":\"login\",\"tokenTimeout\":2592000,\"sessionTimeout\":2592000,\"tokenSessionTimeout\":-2,\"tokenActivityTimeout\":-1,\"loginDevice\":\"default-device\",\"tag\":null}},\"dataCount\":-1}', 0, 0, '2022-01-12 06:59:18.967', '2022-01-12 06:59:19.034', 67);
  88. INSERT INTO `sp_apilog` VALUES (1481158835791073280, '127.0.0.1', '/AccAdmin/fristOpenAdmin', '{}', 'POST', '9fc19dc9-3dca-46b0-aee6-81a9a8e0c215', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"9fc19dc9-3dca-46b0-aee6-81a9a8e0c215\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":{\"admin\":{\"id\":10001,\"name\":\"sa\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"123456\",\"phone\":null,\"roleId\":1,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641999558000,\"loginIp\":\"127.0.0.1\",\"loginCount\":2,\"roleName\":\"超级管理员\"},\"per_list\":[\"bas\",\"1\",\"11\",\"99\",\"console\",\"sql-console\",\"redis-console\",\"apilog-list\",\"form-generator\",\"auth\",\"role-list\",\"menu-list\",\"admin-list\",\"admin-add\",\"sp-cfg\",\"sp-cfg-app\",\"sp-cfg-server\"],\"app_cfg\":null},\"dataCount\":-1}', 0, 10001, '2022-01-12 06:59:19.717', '2022-01-12 06:59:19.726', 9);
  89. INSERT INTO `sp_apilog` VALUES (1481158845618327552, '127.0.0.1', '/admin/getList', '{\"sort_type\":\"0\",\"roleId\":\"\",\"pageNo\":\"1\",\"name\":\"\",\"pageSize\":\"10\",\"id\":\"\"}', 'POST', '9fc19dc9-3dca-46b0-aee6-81a9a8e0c215', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"50\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"9fc19dc9-3dca-46b0-aee6-81a9a8e0c215\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[{\"id\":10002,\"name\":\"admin\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"admin\",\"phone\":null,\"roleId\":1,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641999528000,\"loginIp\":\"127.0.0.1\",\"loginCount\":1,\"roleName\":\"超级管理员\"},{\"id\":10001,\"name\":\"sa\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"123456\",\"phone\":null,\"roleId\":1,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641999558000,\"loginIp\":\"127.0.0.1\",\"loginCount\":2,\"roleName\":\"超级管理员\"}],\"dataCount\":2,\"pageNo\":1,\"pageSize\":10,\"startIndex\":0,\"pageCount\":1}', 0, 10001, '2022-01-12 06:59:22.060', '2022-01-12 06:59:22.117', 57);
  90. INSERT INTO `sp_apilog` VALUES (1481158845702213632, '127.0.0.1', '/role/getList', '{}', 'POST', '9fc19dc9-3dca-46b0-aee6-81a9a8e0c215', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"9fc19dc9-3dca-46b0-aee6-81a9a8e0c215\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[{\"id\":1,\"name\":\"超级管理员\",\"info\":\"最高权限\",\"isLock\":1,\"createTime\":1641988176000},{\"id\":2,\"name\":\"管理员\",\"info\":\"二级管理员\",\"isLock\":2,\"createTime\":1641988176000},{\"id\":11,\"name\":\"客户\",\"info\":\"普通账号\",\"isLock\":1,\"createTime\":1641988176000}],\"dataCount\":-1}', 0, 10001, '2022-01-12 06:59:22.079', '2022-01-12 06:59:22.115', 36);
  91. INSERT INTO `sp_apilog` VALUES (1481158861581848576, '127.0.0.1', '/admin/updateRole', '{\"roleId\":\"2\",\"id\":\"10002\"}', 'POST', '9fc19dc9-3dca-46b0-aee6-81a9a8e0c215', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"17\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"9fc19dc9-3dca-46b0-aee6-81a9a8e0c215\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":1,\"dataCount\":-1}', 0, 10001, '2022-01-12 06:59:25.862', '2022-01-12 06:59:25.895', 33);
  92. INSERT INTO `sp_apilog` VALUES (1481158886353408000, '127.0.0.1', '/AccAdmin/doLogin', '{\"password\":\"admin\",\"key\":\"admin\"}', 'POST', '9fc19dc9-3dca-46b0-aee6-81a9a8e0c215', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"24\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"9fc19dc9-3dca-46b0-aee6-81a9a8e0c215\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":{\"admin\":{\"id\":10002,\"name\":\"admin\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"admin\",\"phone\":null,\"roleId\":2,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641970771813,\"loginIp\":\"127.0.0.1\",\"loginCount\":2,\"roleName\":\"管理员\"},\"per_list\":[\"tb-business\",\"tb-business-list\",\"tb-business-add\",\"tb-business-item\",\"tb-business-item-list\",\"tb-business-item-add\",\"tb-costomer\",\"tb-costomer-list\",\"tb-costomer-add\",\"tb-item\",\"tb-item-list\",\"tb-item-add\"],\"tokenInfo\":{\"tokenName\":\"satoken\",\"tokenValue\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"isLogin\":true,\"loginId\":\"10002\",\"loginType\":\"login\",\"tokenTimeout\":2592000,\"sessionTimeout\":2592000,\"tokenSessionTimeout\":-2,\"tokenActivityTimeout\":-1,\"loginDevice\":\"default-device\",\"tag\":null}},\"dataCount\":-1}', 0, 10001, '2022-01-12 06:59:31.773', '2022-01-12 06:59:31.863', 90);
  93. INSERT INTO `sp_apilog` VALUES (1481158889985675264, '127.0.0.1', '/AccAdmin/fristOpenAdmin', '{}', 'POST', 'ff7068a3-e748-4541-8ac0-b1ffed803075', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":{\"admin\":{\"id\":10002,\"name\":\"admin\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"admin\",\"phone\":null,\"roleId\":2,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641999571000,\"loginIp\":\"127.0.0.1\",\"loginCount\":2,\"roleName\":\"管理员\"},\"per_list\":[\"tb-business\",\"tb-business-list\",\"tb-business-add\",\"tb-business-item\",\"tb-business-item-list\",\"tb-business-item-add\",\"tb-costomer\",\"tb-costomer-list\",\"tb-costomer-add\",\"tb-item\",\"tb-item-list\",\"tb-item-add\"],\"app_cfg\":null},\"dataCount\":-1}', 0, 10002, '2022-01-12 06:59:32.633', '2022-01-12 06:59:32.667', 34);
  94. INSERT INTO `sp_apilog` VALUES (1481158891252355072, '127.0.0.1', '/admin/getList', '{\"sort_type\":\"0\",\"roleId\":\"\",\"pageNo\":\"1\",\"name\":\"\",\"pageSize\":\"10\",\"id\":\"\"}', 'POST', 'ff7068a3-e748-4541-8ac0-b1ffed803075', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"50\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '403', '无此权限:admin-list', '{\"code\":403,\"msg\":\"无此权限:admin-list\",\"data\":null,\"dataCount\":-1}', 0, 10002, '2022-01-12 06:59:32.934', '2022-01-12 06:59:32.969', 35);
  95. INSERT INTO `sp_apilog` VALUES (1481158891252355073, '127.0.0.1', '/role/getList', '{}', 'POST', 'ff7068a3-e748-4541-8ac0-b1ffed803075', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '403', '无此权限:99', '{\"code\":403,\"msg\":\"无此权限:99\",\"data\":null,\"dataCount\":-1}', 0, 10002, '2022-01-12 06:59:32.935', '2022-01-12 06:59:32.969', 34);
  96. INSERT INTO `sp_apilog` VALUES (1481158913712852992, '127.0.0.1', '/AccAdmin/fristOpenAdmin', '{}', 'POST', 'ff7068a3-e748-4541-8ac0-b1ffed803075', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":{\"admin\":{\"id\":10002,\"name\":\"admin\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"admin\",\"phone\":null,\"roleId\":2,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641999571000,\"loginIp\":\"127.0.0.1\",\"loginCount\":2,\"roleName\":\"管理员\"},\"per_list\":[\"tb-business\",\"tb-business-list\",\"tb-business-add\",\"tb-business-item\",\"tb-business-item-list\",\"tb-business-item-add\",\"tb-costomer\",\"tb-costomer-list\",\"tb-costomer-add\",\"tb-item\",\"tb-item-list\",\"tb-item-add\"],\"app_cfg\":null},\"dataCount\":-1}', 0, 10002, '2022-01-12 06:59:38.289', '2022-01-12 06:59:38.299', 10);
  97. INSERT INTO `sp_apilog` VALUES (1481158960986853376, '127.0.0.1', '/AccAdmin/doLogin', '{\"password\":\"123456\",\"key\":\"sa\"}', 'POST', 'ff7068a3-e748-4541-8ac0-b1ffed803075', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"22\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":{\"admin\":{\"id\":10001,\"name\":\"sa\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"123456\",\"phone\":null,\"roleId\":1,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641970789592,\"loginIp\":\"127.0.0.1\",\"loginCount\":3,\"roleName\":\"超级管理员\"},\"per_list\":[\"bas\",\"1\",\"11\",\"99\",\"console\",\"sql-console\",\"redis-console\",\"apilog-list\",\"form-generator\",\"auth\",\"role-list\",\"menu-list\",\"admin-list\",\"admin-add\",\"sp-cfg\",\"sp-cfg-app\",\"sp-cfg-server\"],\"tokenInfo\":{\"tokenName\":\"satoken\",\"tokenValue\":\"9fc19dc9-3dca-46b0-aee6-81a9a8e0c215\",\"isLogin\":true,\"loginId\":\"10001\",\"loginType\":\"login\",\"tokenTimeout\":2592000,\"sessionTimeout\":2592000,\"tokenSessionTimeout\":-2,\"tokenActivityTimeout\":-1,\"loginDevice\":\"default-device\",\"tag\":null}},\"dataCount\":-1}', 0, 10002, '2022-01-12 06:59:49.566', '2022-01-12 06:59:49.620', 54);
  98. INSERT INTO `sp_apilog` VALUES (1481158964589760512, '127.0.0.1', '/AccAdmin/fristOpenAdmin', '{}', 'POST', '9fc19dc9-3dca-46b0-aee6-81a9a8e0c215', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"9fc19dc9-3dca-46b0-aee6-81a9a8e0c215\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":{\"admin\":{\"id\":10001,\"name\":\"sa\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"123456\",\"phone\":null,\"roleId\":1,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641999589000,\"loginIp\":\"127.0.0.1\",\"loginCount\":3,\"roleName\":\"超级管理员\"},\"per_list\":[\"bas\",\"1\",\"11\",\"99\",\"console\",\"sql-console\",\"redis-console\",\"apilog-list\",\"form-generator\",\"auth\",\"role-list\",\"menu-list\",\"admin-list\",\"admin-add\",\"sp-cfg\",\"sp-cfg-app\",\"sp-cfg-server\"],\"app_cfg\":null},\"dataCount\":-1}', 0, 10001, '2022-01-12 06:59:50.419', '2022-01-12 06:59:50.454', 35);
  99. INSERT INTO `sp_apilog` VALUES (1481158978133168128, '127.0.0.1', '/admin/getList', '{\"sort_type\":\"0\",\"roleId\":\"\",\"pageNo\":\"1\",\"name\":\"\",\"pageSize\":\"10\",\"id\":\"\"}', 'POST', '9fc19dc9-3dca-46b0-aee6-81a9a8e0c215', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"50\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"9fc19dc9-3dca-46b0-aee6-81a9a8e0c215\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[{\"id\":10002,\"name\":\"admin\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"admin\",\"phone\":null,\"roleId\":2,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641999571000,\"loginIp\":\"127.0.0.1\",\"loginCount\":2,\"roleName\":\"管理员\"},{\"id\":10001,\"name\":\"sa\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"123456\",\"phone\":null,\"roleId\":1,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641999589000,\"loginIp\":\"127.0.0.1\",\"loginCount\":3,\"roleName\":\"超级管理员\"}],\"dataCount\":2,\"pageNo\":1,\"pageSize\":10,\"startIndex\":0,\"pageCount\":1}', 0, 10001, '2022-01-12 06:59:53.648', '2022-01-12 06:59:53.677', 29);
  100. INSERT INTO `sp_apilog` VALUES (1481158978149945344, '127.0.0.1', '/role/getList', '{}', 'POST', '9fc19dc9-3dca-46b0-aee6-81a9a8e0c215', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"9fc19dc9-3dca-46b0-aee6-81a9a8e0c215\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[{\"id\":1,\"name\":\"超级管理员\",\"info\":\"最高权限\",\"isLock\":1,\"createTime\":1641988176000},{\"id\":2,\"name\":\"管理员\",\"info\":\"二级管理员\",\"isLock\":2,\"createTime\":1641988176000},{\"id\":11,\"name\":\"客户\",\"info\":\"普通账号\",\"isLock\":1,\"createTime\":1641988176000}],\"dataCount\":-1}', 0, 10001, '2022-01-12 06:59:53.652', '2022-01-12 06:59:53.669', 17);
  101. INSERT INTO `sp_apilog` VALUES (1481158987780067328, '127.0.0.1', '/role/getList', '{\"pageNo\":\"1\",\"name\":\"\",\"pageSize\":\"1000\"}', 'POST', '9fc19dc9-3dca-46b0-aee6-81a9a8e0c215', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"28\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"9fc19dc9-3dca-46b0-aee6-81a9a8e0c215\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[{\"id\":1,\"name\":\"超级管理员\",\"info\":\"最高权限\",\"isLock\":1,\"createTime\":1641988176000},{\"id\":2,\"name\":\"管理员\",\"info\":\"二级管理员\",\"isLock\":2,\"createTime\":1641988176000},{\"id\":11,\"name\":\"客户\",\"info\":\"普通账号\",\"isLock\":1,\"createTime\":1641988176000}],\"dataCount\":-1}', 0, 10001, '2022-01-12 06:59:55.952', '2022-01-12 06:59:55.983', 31);
  102. INSERT INTO `sp_apilog` VALUES (1481158995472420864, '127.0.0.1', '/SpRolePermission/getPcodeByRid', '{\"roleId\":\"2\"}', 'POST', '9fc19dc9-3dca-46b0-aee6-81a9a8e0c215', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"9fc19dc9-3dca-46b0-aee6-81a9a8e0c215\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[\"tb-business\",\"tb-business-list\",\"tb-business-add\",\"tb-business-item\",\"tb-business-item-list\",\"tb-business-item-add\",\"tb-costomer\",\"tb-costomer-list\",\"tb-costomer-add\",\"tb-item\",\"tb-item-list\",\"tb-item-add\"],\"dataCount\":-1}', 0, 10001, '2022-01-12 06:59:57.783', '2022-01-12 06:59:57.818', 35);
  103. INSERT INTO `sp_apilog` VALUES (1481159335290736640, '127.0.0.1', '/AccAdmin/fristOpenAdmin', '{}', 'POST', '9fc19dc9-3dca-46b0-aee6-81a9a8e0c215', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"9fc19dc9-3dca-46b0-aee6-81a9a8e0c215\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":{\"admin\":{\"id\":10001,\"name\":\"sa\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"123456\",\"phone\":null,\"roleId\":1,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641999589000,\"loginIp\":\"127.0.0.1\",\"loginCount\":3,\"roleName\":\"超级管理员\"},\"per_list\":[\"bas\",\"1\",\"11\",\"99\",\"console\",\"sql-console\",\"redis-console\",\"apilog-list\",\"form-generator\",\"auth\",\"role-list\",\"menu-list\",\"admin-list\",\"admin-add\",\"sp-cfg\",\"sp-cfg-app\",\"sp-cfg-server\"],\"app_cfg\":null},\"dataCount\":-1}', 0, 10001, '2022-01-12 07:01:18.802', '2022-01-12 07:01:18.851', 49);
  104. INSERT INTO `sp_apilog` VALUES (1481159336695828480, '127.0.0.1', '/role/getList', '{\"pageNo\":\"1\",\"name\":\"\",\"pageSize\":\"1000\"}', 'POST', '9fc19dc9-3dca-46b0-aee6-81a9a8e0c215', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"28\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"9fc19dc9-3dca-46b0-aee6-81a9a8e0c215\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[{\"id\":1,\"name\":\"超级管理员\",\"info\":\"最高权限\",\"isLock\":1,\"createTime\":1641988176000},{\"id\":2,\"name\":\"管理员\",\"info\":\"二级管理员\",\"isLock\":2,\"createTime\":1641988176000},{\"id\":11,\"name\":\"客户\",\"info\":\"普通账号\",\"isLock\":1,\"createTime\":1641988176000}],\"dataCount\":-1}', 0, 10001, '2022-01-12 07:01:19.143', '2022-01-12 07:01:19.165', 22);
  105. INSERT INTO `sp_apilog` VALUES (1481159350302150656, '127.0.0.1', '/SpRolePermission/getPcodeByRid', '{\"roleId\":\"2\"}', 'POST', '9fc19dc9-3dca-46b0-aee6-81a9a8e0c215', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"9fc19dc9-3dca-46b0-aee6-81a9a8e0c215\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[\"tb-business\",\"tb-business-list\",\"tb-business-add\",\"tb-business-item\",\"tb-business-item-list\",\"tb-business-item-add\",\"tb-costomer\",\"tb-costomer-list\",\"tb-costomer-add\",\"tb-item\",\"tb-item-list\",\"tb-item-add\"],\"dataCount\":-1}', 0, 10001, '2022-01-12 07:01:22.380', '2022-01-12 07:01:22.396', 16);
  106. INSERT INTO `sp_apilog` VALUES (1481159401330053120, '127.0.0.1', '/SpRolePermission/updatePcodeByRid', '{\"code\":[\"tb-business\",\"tb-business-list\",\"tb-business-add\",\"tb-business-item\",\"tb-business-item-list\",\"tb-business-item-add\",\"tb-car\",\"tb-car-list\",\"tb-car-add\",\"tb-costomer\",\"tb-costomer-list\",\"tb-costomer-add\",\"tb-item\",\"tb-item-list\",\"tb-item-add\",\"tb-goods\",\"tb-goods-list\",\"tb-goods-add\"],\"roleId\":\"2\"}', 'POST', '9fc19dc9-3dca-46b0-aee6-81a9a8e0c215', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"339\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"9fc19dc9-3dca-46b0-aee6-81a9a8e0c215\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":18,\"dataCount\":-1}', 0, 10001, '2022-01-12 07:01:34.558', '2022-01-12 07:01:34.596', 38);
  107. INSERT INTO `sp_apilog` VALUES (1481159426156138496, '127.0.0.1', '/AccAdmin/doLogin', '{\"password\":\"admin\",\"key\":\"admin\"}', 'POST', '9fc19dc9-3dca-46b0-aee6-81a9a8e0c215', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"24\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"9fc19dc9-3dca-46b0-aee6-81a9a8e0c215\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":{\"admin\":{\"id\":10002,\"name\":\"admin\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"admin\",\"phone\":null,\"roleId\":2,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641970900481,\"loginIp\":\"127.0.0.1\",\"loginCount\":3,\"roleName\":\"管理员\"},\"per_list\":[\"tb-business\",\"tb-business-list\",\"tb-business-add\",\"tb-business-item\",\"tb-business-item-list\",\"tb-business-item-add\",\"tb-car\",\"tb-car-list\",\"tb-car-add\",\"tb-costomer\",\"tb-costomer-list\",\"tb-costomer-add\",\"tb-item\",\"tb-item-list\",\"tb-item-add\",\"tb-goods\",\"tb-goods-list\",\"tb-goods-add\"],\"tokenInfo\":{\"tokenName\":\"satoken\",\"tokenValue\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"isLogin\":true,\"loginId\":\"10002\",\"loginType\":\"login\",\"tokenTimeout\":2592000,\"sessionTimeout\":2592000,\"tokenSessionTimeout\":-2,\"tokenActivityTimeout\":-1,\"loginDevice\":\"default-device\",\"tag\":null}},\"dataCount\":-1}', 0, 10001, '2022-01-12 07:01:40.465', '2022-01-12 07:01:40.516', 51);
  108. INSERT INTO `sp_apilog` VALUES (1481159429184425984, '127.0.0.1', '/AccAdmin/fristOpenAdmin', '{}', 'POST', 'ff7068a3-e748-4541-8ac0-b1ffed803075', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":{\"admin\":{\"id\":10002,\"name\":\"admin\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"admin\",\"phone\":null,\"roleId\":2,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641999700000,\"loginIp\":\"127.0.0.1\",\"loginCount\":3,\"roleName\":\"管理员\"},\"per_list\":[\"tb-business\",\"tb-business-list\",\"tb-business-add\",\"tb-business-item\",\"tb-business-item-list\",\"tb-business-item-add\",\"tb-car\",\"tb-car-list\",\"tb-car-add\",\"tb-costomer\",\"tb-costomer-list\",\"tb-costomer-add\",\"tb-item\",\"tb-item-list\",\"tb-item-add\",\"tb-goods\",\"tb-goods-list\",\"tb-goods-add\"],\"app_cfg\":null},\"dataCount\":-1}', 0, 10002, '2022-01-12 07:01:41.187', '2022-01-12 07:01:41.197', 10);
  109. INSERT INTO `sp_apilog` VALUES (1481159430337859584, '127.0.0.1', '/role/getList', '{\"pageNo\":\"1\",\"name\":\"\",\"pageSize\":\"1000\"}', 'POST', 'ff7068a3-e748-4541-8ac0-b1ffed803075', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"28\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '403', '无此权限:99', '{\"code\":403,\"msg\":\"无此权限:99\",\"data\":null,\"dataCount\":-1}', 0, 10002, '2022-01-12 07:01:41.463', '2022-01-12 07:01:41.478', 15);
  110. INSERT INTO `sp_apilog` VALUES (1481159447186378752, '127.0.0.1', '/TbCar/getList', '{\"sortType\":\"0\",\"pageNo\":\"1\",\"pageSize\":\"10\"}', 'POST', 'ff7068a3-e748-4541-8ac0-b1ffed803075', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"31\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[],\"dataCount\":0,\"pageNo\":1,\"pageSize\":10,\"startIndex\":0,\"pageCount\":0}', 0, 10002, '2022-01-12 07:01:45.480', '2022-01-12 07:01:45.521', 41);
  111. INSERT INTO `sp_apilog` VALUES (1481159794621550592, '127.0.0.1', '/AccAdmin/fristOpenAdmin', '{}', 'POST', 'ff7068a3-e748-4541-8ac0-b1ffed803075', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":{\"admin\":{\"id\":10002,\"name\":\"admin\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"admin\",\"phone\":null,\"roleId\":2,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641999700000,\"loginIp\":\"127.0.0.1\",\"loginCount\":3,\"roleName\":\"管理员\"},\"per_list\":[\"tb-business\",\"tb-business-list\",\"tb-business-add\",\"tb-business-item\",\"tb-business-item-list\",\"tb-business-item-add\",\"tb-car\",\"tb-car-list\",\"tb-car-add\",\"tb-costomer\",\"tb-costomer-list\",\"tb-costomer-add\",\"tb-item\",\"tb-item-list\",\"tb-item-add\",\"tb-goods\",\"tb-goods-list\",\"tb-goods-add\"],\"app_cfg\":null},\"dataCount\":-1}', 0, 10002, '2022-01-12 07:03:08.315', '2022-01-12 07:03:08.353', 38);
  112. INSERT INTO `sp_apilog` VALUES (1481159796290883584, '127.0.0.1', '/TbCar/getList', '{\"sortType\":\"0\",\"pageNo\":\"1\",\"pageSize\":\"10\"}', 'POST', 'ff7068a3-e748-4541-8ac0-b1ffed803075', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"31\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[],\"dataCount\":0,\"pageNo\":1,\"pageSize\":10,\"startIndex\":0,\"pageCount\":0}', 0, 10002, '2022-01-12 07:03:08.712', '2022-01-12 07:03:08.720', 8);
  113. INSERT INTO `sp_apilog` VALUES (1481159818617163776, '127.0.0.1', '/TbItem/getList', '{\"sortType\":\"0\",\"pageNo\":\"1\",\"pageSize\":\"10\"}', 'POST', 'ff7068a3-e748-4541-8ac0-b1ffed803075', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"31\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[],\"dataCount\":0,\"pageNo\":1,\"pageSize\":10,\"startIndex\":0,\"pageCount\":0}', 0, 10002, '2022-01-12 07:03:14.040', '2022-01-12 07:03:14.077', 37);
  114. INSERT INTO `sp_apilog` VALUES (1481159841476120576, '127.0.0.1', '/TbGoods/getList', '{\"sortType\":\"0\",\"pageNo\":\"1\",\"pageSize\":\"10\"}', 'POST', 'ff7068a3-e748-4541-8ac0-b1ffed803075', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"31\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[],\"dataCount\":0,\"pageNo\":1,\"pageSize\":10,\"startIndex\":0,\"pageCount\":0}', 0, 10002, '2022-01-12 07:03:19.489', '2022-01-12 07:03:19.499', 10);
  115. INSERT INTO `sp_apilog` VALUES (1481159865064886272, '127.0.0.1', '/TbBusiness/getList', '{\"sortType\":\"0\",\"pageNo\":\"1\",\"pageSize\":\"10\"}', 'POST', 'ff7068a3-e748-4541-8ac0-b1ffed803075', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"31\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[],\"dataCount\":0,\"pageNo\":1,\"pageSize\":10,\"startIndex\":0,\"pageCount\":0}', 0, 10002, '2022-01-12 07:03:25.113', '2022-01-12 07:03:25.149', 36);
  116. INSERT INTO `sp_apilog` VALUES (1481159890725638144, '127.0.0.1', '/TbBusinessItem/getList', '{\"sortType\":\"0\",\"pageNo\":\"1\",\"pageSize\":\"10\"}', 'POST', 'ff7068a3-e748-4541-8ac0-b1ffed803075', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"31\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[],\"dataCount\":0,\"pageNo\":1,\"pageSize\":10,\"startIndex\":0,\"pageCount\":0}', 0, 10002, '2022-01-12 07:03:31.229', '2022-01-12 07:03:31.271', 42);
  117. INSERT INTO `sp_apilog` VALUES (1481160960529010688, '127.0.0.1', '/TbCostomer/getList', '{\"sortType\":\"0\",\"pageNo\":\"1\",\"pageSize\":\"10\"}', 'POST', 'ff7068a3-e748-4541-8ac0-b1ffed803075', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"31\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[],\"dataCount\":0,\"pageNo\":1,\"pageSize\":10,\"startIndex\":0,\"pageCount\":0}', 0, 10002, '2022-01-12 07:07:46.913', '2022-01-12 07:07:47.874', 961);
  118. INSERT INTO `sp_apilog` VALUES (1481161713444327424, '127.0.0.1', '/AccAdmin/fristOpenAdmin', '{}', 'POST', 'ff7068a3-e748-4541-8ac0-b1ffed803075', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":{\"admin\":{\"id\":10002,\"name\":\"admin\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"admin\",\"phone\":null,\"roleId\":2,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641999700000,\"loginIp\":\"127.0.0.1\",\"loginCount\":3,\"roleName\":\"管理员\"},\"per_list\":[\"tb-business\",\"tb-business-list\",\"tb-business-add\",\"tb-business-item\",\"tb-business-item-list\",\"tb-business-item-add\",\"tb-car\",\"tb-car-list\",\"tb-car-add\",\"tb-costomer\",\"tb-costomer-list\",\"tb-costomer-add\",\"tb-item\",\"tb-item-list\",\"tb-item-add\",\"tb-goods\",\"tb-goods-list\",\"tb-goods-add\"],\"app_cfg\":null},\"dataCount\":-1}', 0, 10002, '2022-01-12 07:10:45.804', '2022-01-12 07:10:45.878', 74);
  119. INSERT INTO `sp_apilog` VALUES (1481161714954276864, '127.0.0.1', '/TbCostomer/getList', '{\"sortType\":\"0\",\"pageNo\":\"1\",\"pageSize\":\"10\"}', 'POST', 'ff7068a3-e748-4541-8ac0-b1ffed803075', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"31\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[],\"dataCount\":0,\"pageNo\":1,\"pageSize\":10,\"startIndex\":0,\"pageCount\":0}', 0, 10002, '2022-01-12 07:10:46.159', '2022-01-12 07:10:46.169', 10);
  120. INSERT INTO `sp_apilog` VALUES (1481161773200576512, '127.0.0.1', '/TbGoods/getList', '{\"sortType\":\"0\",\"pageNo\":\"1\",\"pageSize\":\"10\"}', 'POST', 'ff7068a3-e748-4541-8ac0-b1ffed803075', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"31\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":[],\"dataCount\":0,\"pageNo\":1,\"pageSize\":10,\"startIndex\":0,\"pageCount\":0}', 0, 10002, '2022-01-12 07:11:00.046', '2022-01-12 07:11:00.095', 49);
  121. INSERT INTO `sp_apilog` VALUES (1481162297933172736, '127.0.0.1', '/upload/image', '{}', 'POST', NULL, '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"1905\",\"referer\":\"http://localhost:63343/\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"connection\":\"keep-alive\",\"content-type\":\"multipart/form-data; boundary=----WebKitFormBoundary5BFtdwApEA8AXyJJ\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":\"http://127.0.0.1:8099/upload/image/2022/01-12/1641971585152396710759.png\",\"dataCount\":-1}', 0, 0, '2022-01-12 07:13:05.149', '2022-01-12 07:13:05.155', 6);
  122. INSERT INTO `sp_apilog` VALUES (1481163229513256960, '127.0.0.1', '/AccAdmin/doExit', '{}', 'POST', 'ff7068a3-e748-4541-8ac0-b1ffed803075', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":null,\"dataCount\":-1}', 0, 10002, '2022-01-12 07:16:47.258', '2022-01-12 07:16:47.331', 73);
  123. INSERT INTO `sp_apilog` VALUES (1481163457800835072, '127.0.0.1', '/AccAdmin/doLogin', '{\"password\":\"123456\",\"key\":\"sa\"}', 'POST', 'ff7068a3-e748-4541-8ac0-b1ffed803075', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"22\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"ff7068a3-e748-4541-8ac0-b1ffed803075\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"content-type\":\"application/x-www-form-urlencoded; charset=UTF-8\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":{\"admin\":{\"id\":10001,\"name\":\"sa\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"123456\",\"phone\":null,\"roleId\":1,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1641971861718,\"loginIp\":\"127.0.0.1\",\"loginCount\":4,\"roleName\":\"超级管理员\"},\"per_list\":[\"bas\",\"1\",\"11\",\"99\",\"console\",\"sql-console\",\"redis-console\",\"apilog-list\",\"form-generator\",\"auth\",\"role-list\",\"menu-list\",\"admin-list\",\"admin-add\",\"sp-cfg\",\"sp-cfg-app\",\"sp-cfg-server\"],\"tokenInfo\":{\"tokenName\":\"satoken\",\"tokenValue\":\"9fc19dc9-3dca-46b0-aee6-81a9a8e0c215\",\"isLogin\":true,\"loginId\":\"10001\",\"loginType\":\"login\",\"tokenTimeout\":2592000,\"sessionTimeout\":2592000,\"tokenSessionTimeout\":-2,\"tokenActivityTimeout\":-1,\"loginDevice\":\"default-device\",\"tag\":null}},\"dataCount\":-1}', 0, 0, '2022-01-12 07:17:41.685', '2022-01-12 07:17:41.741', 56);
  124. INSERT INTO `sp_apilog` VALUES (1481163592698040320, '127.0.0.1', '/AccAdmin/fristOpenAdmin', '{}', 'POST', '9fc19dc9-3dca-46b0-aee6-81a9a8e0c215', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"9fc19dc9-3dca-46b0-aee6-81a9a8e0c215\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":{\"admin\":{\"id\":10001,\"name\":\"sa\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"123456\",\"phone\":null,\"roleId\":1,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1642000661000,\"loginIp\":\"127.0.0.1\",\"loginCount\":4,\"roleName\":\"超级管理员\"},\"per_list\":[\"bas\",\"1\",\"11\",\"99\",\"console\",\"sql-console\",\"redis-console\",\"apilog-list\",\"form-generator\",\"auth\",\"role-list\",\"menu-list\",\"admin-list\",\"admin-add\",\"sp-cfg\",\"sp-cfg-app\",\"sp-cfg-server\"],\"app_cfg\":null},\"dataCount\":-1}', 0, 10001, '2022-01-12 07:18:13.848', '2022-01-12 07:18:13.865', 17);
  125. INSERT INTO `sp_apilog` VALUES (1481164261769220096, '127.0.0.1', '/AccAdmin/fristOpenAdmin', '{}', 'POST', '9fc19dc9-3dca-46b0-aee6-81a9a8e0c215', '{\"sec-fetch-mode\":\"cors\",\"content-length\":\"0\",\"referer\":\"http://localhost:63343/\",\"satoken\":\"9fc19dc9-3dca-46b0-aee6-81a9a8e0c215\",\"sec-fetch-site\":\"cross-site\",\"accept-language\":\"zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6\",\"origin\":\"http://localhost:63343\",\"accept\":\"application/json, text/javascript, */*; q=0.01\",\"sec-ch-ua\":\"\\\" Not A;Brand\\\";v=\\\"99\\\", \\\"Chromium\\\";v=\\\"96\\\", \\\"Microsoft Edge\\\";v=\\\"96\\\"\",\"sec-ch-ua-mobile\":\"?0\",\"sec-ch-ua-platform\":\"\\\"Windows\\\"\",\"host\":\"127.0.0.1:8099\",\"x-requested-with\":\"XMLHttpRequest\",\"connection\":\"keep-alive\",\"accept-encoding\":\"gzip, deflate, br\",\"user-agent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Edg/96.0.1054.62\",\"sec-fetch-dest\":\"empty\"}', '200', 'ok', '{\"code\":200,\"msg\":\"ok\",\"data\":{\"admin\":{\"id\":10001,\"name\":\"sa\",\"avatar\":\"http://sa-admin.dev33.cn/sa-frame/admin-logo.png\",\"password\":\"********\",\"pw\":\"123456\",\"phone\":null,\"roleId\":1,\"status\":1,\"createByAid\":-1,\"createTime\":1641988176000,\"loginTime\":1642000661000,\"loginIp\":\"127.0.0.1\",\"loginCount\":4,\"roleName\":\"超级管理员\"},\"per_list\":[\"bas\",\"1\",\"11\",\"99\",\"console\",\"sql-console\",\"redis-console\",\"apilog-list\",\"form-generator\",\"auth\",\"role-list\",\"menu-list\",\"admin-list\",\"admin-add\",\"sp-cfg\",\"sp-cfg-app\",\"sp-cfg-server\"],\"app_cfg\":null},\"dataCount\":-1}', 0, 10001, '2022-01-12 07:20:53.370', '2022-01-12 07:20:53.401', 31);
  126. -- ----------------------------
  127. -- Table structure for sp_cfg
  128. -- ----------------------------
  129. DROP TABLE IF EXISTS `sp_cfg`;
  130. CREATE TABLE `sp_cfg` (
  131. `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT 'id号',
  132. `cfg_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '配置名',
  133. `cfg_value` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '配置值',
  134. `remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  135. PRIMARY KEY (`id`) USING BTREE,
  136. UNIQUE INDEX `cfg_name`(`cfg_name`) USING BTREE
  137. ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配置信息表' ROW_FORMAT = Compact;
  138. -- ----------------------------
  139. -- Records of sp_cfg
  140. -- ----------------------------
  141. INSERT INTO `sp_cfg` VALUES (1, 'app_cfg', '{}', '应用配置信息,对外公开');
  142. INSERT INTO `sp_cfg` VALUES (2, 'server_cfg', '{}', '服务器私有配置');
  143. -- ----------------------------
  144. -- Table structure for sp_role
  145. -- ----------------------------
  146. DROP TABLE IF EXISTS `sp_role`;
  147. CREATE TABLE `sp_role` (
  148. `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '角色id,--主键、自增',
  149. `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称, 唯一约束',
  150. `info` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色详细描述',
  151. `is_lock` int(0) NOT NULL DEFAULT 1 COMMENT '是否锁定(1=是,2=否), 锁定之后不可随意删除, 防止用户误操作',
  152. `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  153. PRIMARY KEY (`id`) USING BTREE,
  154. UNIQUE INDEX `name`(`name`) USING BTREE
  155. ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统角色表' ROW_FORMAT = Compact;
  156. -- ----------------------------
  157. -- Records of sp_role
  158. -- ----------------------------
  159. INSERT INTO `sp_role` VALUES (1, '超级管理员', '最高权限', 1, '2022-01-12 11:49:36');
  160. INSERT INTO `sp_role` VALUES (2, '管理员', '二级管理员', 2, '2022-01-12 11:49:36');
  161. INSERT INTO `sp_role` VALUES (11, '客户', '普通账号', 1, '2022-01-12 11:49:36');
  162. -- ----------------------------
  163. -- Table structure for sp_role_permission
  164. -- ----------------------------
  165. DROP TABLE IF EXISTS `sp_role_permission`;
  166. CREATE TABLE `sp_role_permission` (
  167. `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT 'id号',
  168. `role_id` bigint(0) NULL DEFAULT NULL COMMENT '角色ID ',
  169. `permission_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单项ID',
  170. `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  171. PRIMARY KEY (`id`) USING BTREE
  172. ) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色权限中间表' ROW_FORMAT = Compact;
  173. -- ----------------------------
  174. -- Records of sp_role_permission
  175. -- ----------------------------
  176. INSERT INTO `sp_role_permission` VALUES (1, 1, 'bas', '2022-01-12 11:49:36');
  177. INSERT INTO `sp_role_permission` VALUES (2, 1, '1', '2022-01-12 11:49:36');
  178. INSERT INTO `sp_role_permission` VALUES (3, 1, '11', '2022-01-12 11:49:36');
  179. INSERT INTO `sp_role_permission` VALUES (4, 1, '99', '2022-01-12 11:49:36');
  180. INSERT INTO `sp_role_permission` VALUES (5, 1, 'console', '2022-01-12 11:49:36');
  181. INSERT INTO `sp_role_permission` VALUES (6, 1, 'sql-console', '2022-01-12 11:49:36');
  182. INSERT INTO `sp_role_permission` VALUES (7, 1, 'redis-console', '2022-01-12 11:49:36');
  183. INSERT INTO `sp_role_permission` VALUES (8, 1, 'apilog-list', '2022-01-12 11:49:36');
  184. INSERT INTO `sp_role_permission` VALUES (9, 1, 'form-generator', '2022-01-12 11:49:36');
  185. INSERT INTO `sp_role_permission` VALUES (10, 1, 'auth', '2022-01-12 11:49:36');
  186. INSERT INTO `sp_role_permission` VALUES (11, 1, 'role-list', '2022-01-12 11:49:36');
  187. INSERT INTO `sp_role_permission` VALUES (12, 1, 'menu-list', '2022-01-12 11:49:36');
  188. INSERT INTO `sp_role_permission` VALUES (13, 1, 'admin-list', '2022-01-12 11:49:36');
  189. INSERT INTO `sp_role_permission` VALUES (14, 1, 'admin-add', '2022-01-12 11:49:36');
  190. INSERT INTO `sp_role_permission` VALUES (15, 1, 'sp-cfg', '2022-01-12 11:49:36');
  191. INSERT INTO `sp_role_permission` VALUES (16, 1, 'sp-cfg-app', '2022-01-12 11:49:36');
  192. INSERT INTO `sp_role_permission` VALUES (17, 1, 'sp-cfg-server', '2022-01-12 11:49:36');
  193. INSERT INTO `sp_role_permission` VALUES (30, 2, 'tb-business', '2022-01-12 15:01:34');
  194. INSERT INTO `sp_role_permission` VALUES (31, 2, 'tb-business-list', '2022-01-12 15:01:34');
  195. INSERT INTO `sp_role_permission` VALUES (32, 2, 'tb-business-add', '2022-01-12 15:01:34');
  196. INSERT INTO `sp_role_permission` VALUES (33, 2, 'tb-business-item', '2022-01-12 15:01:34');
  197. INSERT INTO `sp_role_permission` VALUES (34, 2, 'tb-business-item-list', '2022-01-12 15:01:34');
  198. INSERT INTO `sp_role_permission` VALUES (35, 2, 'tb-business-item-add', '2022-01-12 15:01:34');
  199. INSERT INTO `sp_role_permission` VALUES (36, 2, 'tb-car', '2022-01-12 15:01:34');
  200. INSERT INTO `sp_role_permission` VALUES (37, 2, 'tb-car-list', '2022-01-12 15:01:34');
  201. INSERT INTO `sp_role_permission` VALUES (38, 2, 'tb-car-add', '2022-01-12 15:01:34');
  202. INSERT INTO `sp_role_permission` VALUES (39, 2, 'tb-costomer', '2022-01-12 15:01:34');
  203. INSERT INTO `sp_role_permission` VALUES (40, 2, 'tb-costomer-list', '2022-01-12 15:01:34');
  204. INSERT INTO `sp_role_permission` VALUES (41, 2, 'tb-costomer-add', '2022-01-12 15:01:34');
  205. INSERT INTO `sp_role_permission` VALUES (42, 2, 'tb-item', '2022-01-12 15:01:34');
  206. INSERT INTO `sp_role_permission` VALUES (43, 2, 'tb-item-list', '2022-01-12 15:01:34');
  207. INSERT INTO `sp_role_permission` VALUES (44, 2, 'tb-item-add', '2022-01-12 15:01:34');
  208. INSERT INTO `sp_role_permission` VALUES (45, 2, 'tb-goods', '2022-01-12 15:01:34');
  209. INSERT INTO `sp_role_permission` VALUES (46, 2, 'tb-goods-list', '2022-01-12 15:01:34');
  210. INSERT INTO `sp_role_permission` VALUES (47, 2, 'tb-goods-add', '2022-01-12 15:01:34');
  211. -- ----------------------------
  212. -- Table structure for tb_business
  213. -- ----------------------------
  214. DROP TABLE IF EXISTS `tb_business`;
  215. CREATE TABLE `tb_business` (
  216. `id` bigint(0) NOT NULL COMMENT '主键[num]',
  217. `customer_id` bigint(0) NULL DEFAULT NULL COMMENT '客户id',
  218. `customer_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '客户名称[no-add]',
  219. `no` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '编号',
  220. `card_no` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '车牌号',
  221. `card_size` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '车规格',
  222. `net_weight` double(10, 2) NULL DEFAULT NULL COMMENT '载重(kg)',
  223. `goods_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '商品',
  224. `goods_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '商品编号[no-add]',
  225. `driver_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '司机名称',
  226. `driver_id` bigint(0) NULL DEFAULT NULL COMMENT '司机id[no-add]',
  227. `driver_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '司机联系号码',
  228. `driver_id_card` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '司机身份证',
  229. `pay_ticket` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '支付凭证[img]',
  230. `expect_in_day` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '预计进边境日期',
  231. `real_in_day` date NULL DEFAULT NULL COMMENT '实际进边境日期[no-add]',
  232. `real_in_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '实际进境时间[no-add]',
  233. `pay_status` tinyint(1) NULL DEFAULT NULL COMMENT '支付状态(1=未支付,2=已支付)[j no-add]',
  234. `pay_time` datetime(0) NULL DEFAULT NULL COMMENT '支付时间[no-add]',
  235. `pay_type` tinyint(1) NULL DEFAULT NULL COMMENT '支付方式(1=线下支付,2现金支付,3=第三方支付)[j]',
  236. `out_day_time` datetime(0) NULL DEFAULT NULL COMMENT '离境时间[no-add]',
  237. `part_money` decimal(6, 0) NULL DEFAULT NULL COMMENT '停车费用[no-add]',
  238. `part_time` int(0) NULL DEFAULT NULL COMMENT '停车时常(分)[no-add]',
  239. PRIMARY KEY (`id`) USING BTREE
  240. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '入境登记' ROW_FORMAT = Dynamic;
  241. -- ----------------------------
  242. -- Table structure for tb_business_item
  243. -- ----------------------------
  244. DROP TABLE IF EXISTS `tb_business_item`;
  245. CREATE TABLE `tb_business_item` (
  246. `id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键[num no-add]',
  247. `business_id` bigint(0) NULL DEFAULT NULL COMMENT '等级表id[no-add]',
  248. `item_code` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '项目编号',
  249. `item_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '项目金额(元)',
  250. `item_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '项目名称',
  251. `status` tinyint(1) NULL DEFAULT NULL COMMENT '状态(1=未完成,2=已完成)',
  252. `operate_time` datetime(0) NULL DEFAULT NULL COMMENT '操作时间',
  253. `operaror` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '操作人员',
  254. PRIMARY KEY (`id`) USING BTREE
  255. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '业务作业项' ROW_FORMAT = Dynamic;
  256. -- ----------------------------
  257. -- Table structure for tb_car
  258. -- ----------------------------
  259. DROP TABLE IF EXISTS `tb_car`;
  260. CREATE TABLE `tb_car` (
  261. `id` bigint(0) NOT NULL COMMENT '主键[num no-add]',
  262. `card_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '名称',
  263. `card_size` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '规格',
  264. `last_goods_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '最后一次运输商品',
  265. `last_goods_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '最后一次运输商品编号',
  266. `last_net_weight` double(10, 2) NULL DEFAULT NULL COMMENT '最后一次载重',
  267. `last_in_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次入境时间',
  268. `last_out_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次出境时间',
  269. `status` tinyint(1) NULL DEFAULT NULL COMMENT '当前状态(1=境外,2=境内)[j]',
  270. PRIMARY KEY (`id`) USING BTREE
  271. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '车辆管理' ROW_FORMAT = Dynamic;
  272. -- ----------------------------
  273. -- Table structure for tb_costomer
  274. -- ----------------------------
  275. DROP TABLE IF EXISTS `tb_costomer`;
  276. CREATE TABLE `tb_costomer` (
  277. `id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键[num]',
  278. `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '名称',
  279. `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '联系号码',
  280. `duty_people` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '负责人',
  281. `address_ids` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '地址id',
  282. `address_str` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '地址',
  283. `business_licence` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '营业执照[img]',
  284. `status` tinyint(1) NULL DEFAULT 1 COMMENT '状态(0=否,1=是)[j switch=true]',
  285. `creare_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  286. `judge_status` tinyint(1) NULL DEFAULT NULL COMMENT '审核状态(1=未审核,2审核通过,3审核不通过)[j]',
  287. `judge_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
  288. `judge_content` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '审核意见',
  289. PRIMARY KEY (`id`) USING BTREE
  290. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '客户管理' ROW_FORMAT = Dynamic;
  291. -- ----------------------------
  292. -- Table structure for tb_driver
  293. -- ----------------------------
  294. DROP TABLE IF EXISTS `tb_driver`;
  295. CREATE TABLE `tb_driver` (
  296. `id` bigint(0) NOT NULL COMMENT '主键[num no-add]',
  297. `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '名称',
  298. `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '手机号码',
  299. `id_card` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '身份证',
  300. `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  301. PRIMARY KEY (`id`) USING BTREE
  302. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '司机' ROW_FORMAT = Dynamic;
  303. -- ----------------------------
  304. -- Table structure for tb_goods
  305. -- ----------------------------
  306. DROP TABLE IF EXISTS `tb_goods`;
  307. CREATE TABLE `tb_goods` (
  308. `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  309. `code` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '编号',
  310. `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '名称',
  311. `status` tinyint(1) NULL DEFAULT NULL COMMENT '状态(1=禁用,2=启用)[j switch=true]',
  312. `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  313. PRIMARY KEY (`id`) USING BTREE
  314. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '商品管理' ROW_FORMAT = Dynamic;
  315. -- ----------------------------
  316. -- Table structure for tb_item
  317. -- ----------------------------
  318. DROP TABLE IF EXISTS `tb_item`;
  319. CREATE TABLE `tb_item` (
  320. `id` bigint(0) NOT NULL COMMENT '主键[num no-add]',
  321. `item_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '项目编号',
  322. `item_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '项目名称',
  323. `price` decimal(10, 2) NULL DEFAULT NULL COMMENT '项目金额(元)',
  324. `need` tinyint(1) NULL DEFAULT NULL COMMENT '是否必须(1=否,2=是)[j switch=true]',
  325. `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间[no-add]',
  326. PRIMARY KEY (`id`) USING BTREE
  327. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '作业配置项' ROW_FORMAT = Dynamic;
  328. SET FOREIGN_KEY_CHECKS = 1;