代码拉取完成，页面将自动刷新
/*
Navicat Premium Data Transfer
Source Server : 本机
Source Server Type : MySQL
Source Server Version : 80025
Source Host : localhost:3306
Source Schema : billiards
Target Server Type : MySQL
Target Server Version : 80025
File Encoding : 65001
Date: 08/04/2023 22:37:01
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for announcement_info
-- ----------------------------
DROP TABLE IF EXISTS `announcement_info`;
CREATE TABLE `announcement_info` (
`announceid` bigint NOT NULL AUTO_INCREMENT,
`title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '公告标题',
`text` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '内容',
`type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '公告类型',
`is_del` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '关闭此公告？',
`create_time` date NULL DEFAULT NULL COMMENT '发布时间',
`deadline` date NULL DEFAULT NULL COMMENT '截至时间',
`creator` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '发布人',
`grade` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '通知等级',
`picture` blob NULL,
`extend3` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`extend4` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`extend5` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
PRIMARY KEY (`announceid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of announcement_info
-- ----------------------------
INSERT INTO `announcement_info` VALUES (1, '春季打折啦', '三月四月会员8折', '折扣活动', '', NULL, NULL, 'admin', '普通', NULL, NULL, NULL, NULL);
INSERT INTO `announcement_info` VALUES (7, 'aaaaaaaaaaaaaaa', 'dddddddddddddddddddd', '赛事活动', '1', NULL, NULL, 'dddddddddddddd', '重要', NULL, NULL, NULL, NULL);
INSERT INTO `announcement_info` VALUES (8, '2023年3月18日休息', '休息休息休息休息休息休息休息休息休息', '休息通知', '1', NULL, NULL, 'admin', '重要', NULL, NULL, NULL, NULL);
INSERT INTO `announcement_info` VALUES (9, '比赛', '竞技规则:中式八球最新比赛规则(所有球无须报袋)，女子及 14 岁以下选手直接让后预选赛采用7局4胜制;\n正赛相错蹿奥安局5胜制;\n半决赛 13局7胜制\n决赛17局9 胜制;', '赛事活动', NULL, NULL, NULL, NULL, '重要', 0x687474703A2F2F3132372E302E302E312F66696C652F646F776E6C6F6164496D673F6E616D653DE799BEE4BA8BE58FAFE4B9902E706E67, NULL, NULL, NULL);
-- ----------------------------
-- Table structure for billiard_user
-- ----------------------------
DROP TABLE IF EXISTS `billiard_user`;
CREATE TABLE `billiard_user` (
`user_id` bigint NOT NULL,
`nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`create_time` datetime(0) NULL DEFAULT NULL,
`is_vip` int NULL DEFAULT NULL,
`sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`age` int NULL DEFAULT NULL,
`balance` double(255, 0) NULL DEFAULT NULL,
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`is_del` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of billiard_user
-- ----------------------------
INSERT INTO `billiard_user` VALUES (2088822380969236, '小麋鹿', '19876543210', NULL, '2023-03-23 07:11:08', NULL, '男', 22, 281, 'https://gw.alipayobjects.com/mdn/rms_1bde6f/afts/img/A*nyU6QLX40OEAAAAAAAAAAAAAARQnAQ', '0');
-- ----------------------------
-- Table structure for commodity_management
-- ----------------------------
DROP TABLE IF EXISTS `commodity_management`;
CREATE TABLE `commodity_management` (
`commodityid` bigint NOT NULL AUTO_INCREMENT,
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '品类',
`number` int NULL DEFAULT NULL COMMENT '数量',
`price` float NULL DEFAULT NULL COMMENT '进价',
`selling_price` float NULL DEFAULT NULL COMMENT '售价',
`purchase_date` datetime(0) NULL DEFAULT NULL COMMENT '每月进货日期',
`linkman` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系人',
`sold_out` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '下架商品',
`picture` blob NULL,
`isdel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`extend4` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`extend5` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
PRIMARY KEY (`commodityid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of commodity_management
-- ----------------------------
INSERT INTO `commodity_management` VALUES (1, '农夫山泉', '水', 191, 1, 1.5, NULL, '12345678', NULL, 0x687474703A2F2F3132372E302E302E312F66696C652F646F776E6C6F6164496D673F6E616D653D5FE5869CE5A4ABE5B1B1E6B3892E706E67, NULL, NULL, NULL);
INSERT INTO `commodity_management` VALUES (2, '怡宝', '水', 82, 0.8, 2, NULL, '13841828005', NULL, 0x687474703A2F2F3132372E302E302E312F66696C652F646F776E6C6F6164496D673F6E616D653DE680A1E5AE9D2E706E67, NULL, NULL, NULL);
INSERT INTO `commodity_management` VALUES (3, '百岁山', '水', 77, 2.5, 3, NULL, '13634353333', NULL, 0x687474703A2F2F3132372E302E302E312F66696C652F646F776E6C6F6164496D673F6E616D653DE799BEE5B281E5B1B12E706E67, NULL, NULL, NULL);
INSERT INTO `commodity_management` VALUES (4, '干脆面', '食品', 46, 0.3, 0.5, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `commodity_management` VALUES (5, '乐事薯片', '食品', 43, 2.5, 4, NULL, NULL, NULL, 0x687474703A2F2F3132372E302E302E312F66696C652F646F776E6C6F6164496D673F6E616D653DE896AFE789872E706E67, NULL, NULL, NULL);
INSERT INTO `commodity_management` VALUES (6, '士力架', '食品', 50, 4.5, 7, NULL, NULL, NULL, 0x687474703A2F2F3132372E302E302E312F66696C652F646F776E6C6F6164496D673F6E616D653DE5A3ABE58A9BE69EB62E706E67, NULL, NULL, NULL);
INSERT INTO `commodity_management` VALUES (7, '红牛', '水', 98, 4.5, 6, NULL, NULL, NULL, 0x687474703A2F2F3132372E302E302E312F66696C652F646F776E6C6F6164496D673F6E616D653DE5BEAEE4BFA1E59BBEE789875F32303233303333303136303231332E706E67, NULL, NULL, NULL);
INSERT INTO `commodity_management` VALUES (8, '冰红茶', '水', 77, 1.5, 3.5, NULL, NULL, NULL, 0x687474703A2F2F3132372E302E302E312F66696C652F646F776E6C6F6164496D673F6E616D653DE586B0E7BAA2E88CB62E706E67, NULL, NULL, NULL);
INSERT INTO `commodity_management` VALUES (9, '可口可乐', '水', 98, 2, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `commodity_management` VALUES (10, '红烧牛肉面', '食品', 43, 3, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `commodity_management` VALUES (11, '品诺', '面巾纸', 191, 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `commodity_management` VALUES (23, 'test', '水', 12, 1, 2, '2023-03-19 21:06:18', NULL, NULL, 0x646174613A696D6167652F6A7065673B6261736536342C2F396A2F34514159525868705A67414153556B714141674141414141414141414141414141502F734142464564574E726551414241415141414141384141442F34514F4E6148523063446F764C32357A4C6D466B62324A6C4C6D4E7662533934595841764D5334774C7741385033687759574E725A585167596D566E6157343949752B377679496761575139496C63315454424E63454E6C61476C49656E4A6C5533704F56474E3661324D355A43492F5069413865447034625842745A585268494868746247357A4F6E6739496D466B62324A6C4F6D357A4F6D316C64474576496942344F6E68746348527250534A425A4739695A53425954564167513239795A5341314C6A5974597A45304F4341334F5334784E6A51774D7A5973494449774D546B764D4467764D544D744D4445364D4459364E54636749434167494341674943492B494478795A475936556B5247494868746247357A4F6E4A6B5A6A30696148523063446F764C336433647935334D793576636D63764D546B354F5338774D6938794D6931795A47597463336C75644746344C57357A4979492B494478795A4759365247567A59334A706348527062323467636D526D4F6D46696233563050534969494868746247357A4F6E68746345314E50534A6F644852774F693876626E4D7559575276596D5575593239744C336868634338784C6A4176625730764969423462577875637A707A64464A6C5A6A30696148523063446F764C32357A4C6D466B62324A6C4C6D4E7662533934595841764D5334774C334E556558426C4C314A6C63323931636D4E6C556D566D4979496765473173626E4D366547317750534A6F644852774F693876626E4D7559575276596D5575593239744C336868634338784C6A4176496942346258424E54547050636D6C6E6157356862455276593356745A57353053555139496E68746343356B615751365A4459774D5445354D5751744D5459774D43316A4E7A526B4C5749784E4463744E544577597A466A4E44646D4E324578496942346258424E5454704562324E316257567564456C4550534A34625841755A476C6B4F6B4935526A4243517A4930524442474E7A457852554D344E445134516A46454D544642526A67354D455178496942346258424E5454704A626E4E305957356A5A556C4550534A346258417561576C6B4F6B4935526A4243517A497A524442474E7A457852554D344E445134516A46454D544642526A67354D455178496942346258413651334A6C59585276636C527662327739496B466B62324A6C4946426F623352766332687663434244517941794D444530494368586157356B6233647A4B53492B494478346258424E545470455A584A70646D566B526E4A766253427A64464A6C5A6A7070626E4E305957356A5A556C4550534A346258417561576C6B4F6A49794E6A5A68596A67324C57566B5A6A51744F4749304D4330344D4467784C546C6A4D5759325A4455354F446C6B4E434967633352535A5759365A47396A6457316C626E524A5244306959575276596D55365A47396A61575136634768766447397A614739774F6D5A6A5A6A51344E7A6B344C5752694D5451744D54466C4E7930344E4751304C5755784D57597A5932566D4F574D324D794976506941384C334A6B5A6A70455A584E6A636D6C7764476C76626A3467504339795A475936556B5247506941384C336736654731776257563059543467504439346347466A61325630494756755A4430696369492F50762F75414135425A4739695A51426B774141414141482F327743454141594542415146424159464251594A4267554743517349426759494377774B4367734B436777514441774D4441774D4541774F44784150446777544578515545784D634778736248423866487838664878386648783842427763484451774E4742415147426F564552556148783866487838664878386648783866487838664878386648783866487838664878386648783866487838664878386648783866487838664878386648783866482F2F4141424549415A414330414D4245514143455145444551482F7841444941414541416749444151454141414141414141414141414142776746426745444241494A4151454141674D424151414141414141414141414141414142415544426763434152414141514D4341774D444368454C4167554541774141414145434177514645515948495249494D55455455534A79306853557446593347474678676248524D704A7A6B374E5564425631466A59586B554A53497A4E54307A526B4E565768597347436F724C5534554D6B4A634C446842454241414941417749484451634541674D42414141414141454345514D45555155684D52497A4644514751574678675A4768736445795572495446734868636F4B5355785877496B4A696F695043306B50782F396F4144414D424141495241784541507743314941414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414F7275756C2F664D39306E736E7A4636354D374475756C2F664D39306E736A45354D374475756C2F664D39306E736A45354D374475756C2F664D39306E736A45354D374475756C2F664D39306E736A45354D374475756C2F664D39306E736A45354D374475756C2F664D39306E736A45354D374475756C2F664D39306E736A45354D374830796547526347534E65764C67315558316A37692B545759665966485774545449716F737245564E696F726B506D4C31795A3250706B73556D505276612F446C3356526350794831386D4A683942384143716949717175434A74565641367536365839387A33536579664D58726B7A7366624A4935457859354870795974564639592B766B78672B672B414141414134633972477135366F31716371717543416948583358532F766D6536543254356939636D64683358532F766D653654325269636D64683358532F766D653654325269636D64683358532F766D653654325269636D646A3662555150636A57534D63356552456369716663587961792B772B4141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141427131373151794459376E4C61377465596153766733656D70337049726D373755653348646171625775525446624F7057634A6C4F796432616A4E724636556D61793850343236562B4D5650376D5874447A306E4C327333384C712F323538782B4E756C666A46542B356C3751644A7939702F4336763975664D3033563756374B46646B4B34552B57737770394D712B42616275563073553243547333393136497A44724D636476495964526E316D6B386D654659377033546E5631465A7A616632634F4F4F4578784B372F627A50486A46632B2F4B6A7479762B6262624C6365673548376450307773446F7A71376C61677950425435707A462F77446239504D352F6462705A70647858645A693955667A636D30734E506E3169763841645043314866473663322B664D355650374D49347349687650343236562B4D5650376D5874444E306E4C3271762B46316637632B592F473353767869702F6379396F4F6B3565302F6864582B33506D65327A36716166337135515779313371477172366C5653436E593254656372577139634D576F6D78714B7036726E306D63496C697A7431366A4C724E72306D4B77326F796F44382F37372F65376838356D2B4D556F4C6363757435484E313845504366475541414141414142594C684A2F6D737A3968522B764D54394233576F39712B4C4C2F4E3969786859744E555A315175636C7931457A465679637131383054647550575176574A6D337357495565644F4E35384C7157374D754B61624C6A2F5750507774343057316779746B4F7956394A63614B737161327471556C57536D62457245695A476A574E5658794D5848653375597A366655567045347176664F364D335658724E5A72466178336366556D5449757647574D355A67697364756F613243706C6A6B6C53536F62456A45534E753876744A48726A36684D797456573834524457396475504E303258387930316D4F396A366B6638514F7057644D765A346874316975386C46537051785353517870473739612B53544656336D75584864527048315764617473496E754C66634F37636A4F794A746D56786E6C5474377A78365436364F6957372F62322F7A50624A4647793273664336524E35642F70462F555272686831764B664D6A5538664C6C6B33727550486B394870486634664268787967636774725742304A315A794C6C544A556C73767477645456727132576449327754534A306232526F69373062484A7974556E36625070537545793148666D36732F507A2B586C31787279596A6A6A76704638346A53582F4C7637317176345A4936586C3756503950367633662B566657337579586D3333753155313174306979304E597A704B6552577559726D4B75434C757552484A36706E72614C526A43717A736D32566561573971454D635656585655316C734471655A384C6E564D794F574E7A6D71716447336C77564348727077694779646C36526139385978344956782B6D62763875715068582B7956334B6E613350354E4E6B65512B6D62763875715068582B794F564F302B54545A486B57657976504E507778564D73386A704A58577135377A3371726E4C684C4F695971766F466E536638416F38557448314E596A656B5248763039465656537262344141414570634E766C5370506D315438575364487A6969375239566E7777743457376E67414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414155333468664B33652B7870504249696E31664F5336503266366E54383378536A6B6A726B414141414141427632672F6C5A792F77432B542B44536D665338354370333731532F692B4B463043356331666E2F4148372B2B5848357A4E385970515734356462794F6272344953666F645A636731466C7A54657335306A616D6774506361704939736A756A535A3072565647786463754C6B627A4572545670684D3237696A33336E61694C35644D69634C5835586D773274782B6D2B4648354C463376582B775A75566B66316972666B6232327A35616E3033776F2F4A597539362F324279736A2B735435473974732B5770394E384B5079574C766576384159484B79503678506B6232327A35616E3033776F2F4A597539362F324279736A2B735435473974732B5772323257546869764E317062586271434B6175724A456970346C6772576F353775524E353649315056552B312B524D345248705938364E365A644A76613078574F2F5658764F464A545565626233523073615255314E5831554D455463634778736D6331725578366949562B5A4746706A767476306C35746B306D654F6178364531384A5038316D6633756A3965596D364875745A37563857582B6237477A63526D664D325A546A792B755836393143745974583353725752796233524A4475667447767777333135444C713832314D4D4A51657A3268796452792F6D563557484A77342B2F73565A6C6C6B6D6C664C4B355879794F567A3375584656633563565656394571323978455247454E317357692B704E2B744E5064725861656D6F4B707175676C64505478713545565578335A4A4775355536686D727037326A4749567566766E545A5635706532466F37302B704A4F6A476C476538705A336A766D594C65796874644E54564854564B31464F39473478387170484939324871456E5435467157786D4F4253623433726B616A492B586C323556706D4F444366556A2F4146327A4262723771525831647471593675695A48424444555175523748626B534B37646331584976584B7649523954654C586E4262376A30397372545669305957346653307968736C35754562704B43677161754E693772337751766B616A734D634656694C744D4D566D654B466C6650705467746149384D764566475637364B775832766836656874315656513471337059495A4A4737796371627A57716D4A39696B7A785178587A38756B34577445543335642F32527A5A2F68612F76576274543738753279586A7065543739664C4335656B744E5555326D2B58344B6D4A384D38644931736B556A565939713472735671344B686335455955687A6665746F7471627A4844484B65334F47517372357767706F4C2F5375716F71527A6E774E624C4A466735364969726A4735717273512B356D56572F47783654585A756E6D5A7935777837324C562F4E33306C2F78442B2B71722B495975695A65784F2B6F4E5837332F414272366A7A64394A6638414550373671763467364A6C374436673166766638612B706B4D335A6574575864494C395A72544573467670625A577042457233534B33665A4A4937726E713579396339655654316D556975584D527359644A714C35327370653834326D39667355704B5A3078617A537A536A54793736653253343347795131466255302B2F504F3530694F633766636D4B344F524330794D696B30695A686F4F394E36616E4C31463631764D566957312F676C70583475302F757065334D7652737659672F7A57722F636E7A4B363851655762466C335046505157536A5A51306271434B5A304D6538714B393073714B37726C5665527146667171525732456247343767314F5A6E5A453276504B6E6C5436496476445A355571543574552F466A52383438396F2B717A345957384C647A7741414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414B623851766C62766659306E676B525436766E4A644837503954702B6234706562517533572B35616F32656A75464E4657556B71564B7955383747795275334B575637635775525558427A55552B6161496D38524C33767A4D7454533274575A696544692F4643325834665A4238577256336C54646F577679716249386A514F6E366A39792F7743716657305858444A32554C66706465363267736C766F36754A4B666F7169436D68696B627656555446776578714C746135554D4770793678535A69495775354E5A6E5831564B3276615934654F5A6E2F475653697164415776304879686C4F356158327172754E6B6F4B3272652B705239525555734D73696F32706B524D587661726C775243313075585761526A454E4233357138366D717446623272484278544D647945676668396B487861745865564E32686E2B56545A486B56485439522B35663841565072565934676256624C58715256556C747049614B6C536E70334A42547874696A52584D785655617845546156657172455834473937677A6258303054615A744F4D38627936442B566E4C2F766B2F6730703830764F51796239367066786646433642637561767A2F7633393875507A6D623478536774787936336B63335877516B62532B69724B37533355656B6F6F5A4B6D716C5A62456A676859736B6A734A70467761784D5658596938684A79596D637532486555323837317271736962546848392F6F68704832447A7834753350764F6F375177664B74736C61644F7950334B6671686A376E5A4C31616E5273756C425530447055563054616D47534658496E4B7255656A6363447A617378787779356566544D3969305738453475696A6F367974715936576A676B71616D5663496F49574F6B6B6375474F4457745256552B52475045393376465978744F454D7639673838654C747A377A714F3050667972624A522B6E5A48376C503151327253724A3262715055584C39545632533455394E465752756C6E6C705A6D4D616D3361357A6D6F69495A636A4C744634344A562B394E5A6B3230313469395A6E6B375961706E7637385A682B73367A776835697A66616E77724451387854384666516D62684A2F6D737A2B393066727A457A5139317266617669792F774133324A463169796C6B444D4C62536D627237394370544C5564784C30384D4853394A30665366746D7533743364627964556B616A4C7062446C54677074306176555A504B2B54546C34345938457A68783463534E6D6153635037584E6375655563694C69725672614C42634F5A63474970482B526C653935345855373233682B7A2F77416265744C39727A357058613762545732687A466134614F6B6A624454784A56784C7573596D434A6972735358584E79346A434A687275626F64586D576D317375387A503841724C757273345A5676746E7574425A4C7653584B756451314C6D30314C4D796154446F3154486359726C7778636948326379746F6D496E463570704D334B765731363272586C52777A47486455342B776D6550463635393531486146503871327958522B6E5A4876302F5643796E44786C6538574C494E786464614E3946555639524A4E48484B69736B364A7354593033324F775676584E64796F57576B704E6154693076744271615A756F72794A7869735965645538716D2F4C59384C336B336D2B735A2F69346931305873654E6F486162724D66686A3755756B747277427147633956736D354F723461432B314D734E545552645045324F4638694B78584B7A4846714B6E4B3154446D5A396154684B78306536383755566D3258474D524F4847312F7741354453763564556437532B77654F6C3565314C2B6E64583773655747395A587A5061637A32574738326C37704B436F5637596E76617246586F337178335775322B3261706D70654C526A4372314F6D766B586D6C2F6168687456376851552B6E2B5961656F71596F5A36693231615538556A32746649765175324D61716F7276555047664D636966416B6272793754714B5445546846362B6C523870585546326446764A626C3335742F7744736358576E3575484D743839617A504333557A4B785648696B386F314E3957516648544656726662385466757A4856702F48506F68692B486173704B5455326C6D71353436654C75616F54704A58745933465762457863714965644A4F46326674445362615759694D65474677693363364141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141436D2F454C35573733324E4A344A45552B72357958522B7A2F41464F6E3576696B3465764B335A4F78712F424A52704F6367375164547638416C2B4B467943346334523972393549372F77426A546546776B665663334B33334431796E6A2B47564D696E644A584634642F4A4E6150664B72776D5174394A7A634F63396F4F74322F4C384D4A4A4A4B6C5644346B2F4B6C562F4E71623473714E5A7A6A6F665A7A71736547574C304838724F582F664A2F4270547A706563686E333731532F692B4B463043356331666E2F6676373563666E4D3378696C42626A6C31764935757667684E5844566D4332356573476337786333756A6F4B503650644F39725665354563366469594E5461753179453352336973576D6538316E74486B577A737A4B705832703558324A4838354453763564556437532B7753656C35653154665475723932504C43466466732F355A7A6C646254553247643838564C424A4650306B62346C527A6E6F354E6A305448595174566D31764D594E6C33446F4D33545574475A47474D77302F5461393236783536733933754D6978554E4850307337327456796F3147716D787263565577354E6F72654A6C5A627979625A7552656C66616D466D764F5130722B58564865307673466E30764C3274492B6E645837736557475379357266702F6D4B3955316D7464564E4C5831617562417830456A45586359723359756369496E5774553955314E4C54684444714E79366A4A704E3778484A6A76716C5A372B2F475966724F73384965564F6237552B46304451387854384666516D62684A2F6D737A2B393066727A457A5139317266617669792F77413332505278622F737372646C586574546E3358397A7876485A546A7A50792F38416B7271563763514358654747614B485547746D6C636A496F375655506B65356345613173734B71712B67694576526533346D766470596D645045523738656956697678513034385A725A333144327859664F7074687033385A716632372F706C31314770756E543665566A637A5778584F593545547575486C564F794535314E7350746432366E486D372F706C5277704855566C2B48584F6D55624C6B47576B7539356F36437164587A534A42555478787633466A6A524862726C52634633564C4C535A6C5970777A33576B396F64486E5A6D6F787053316F354D635565464B48346F6163654D317337366837596B2F4F707468522F786D702F62762B6D57775546665258436A69726147646C5453547076517A784F523748743672584A7356444A45785044434A664C74535A72614D4A68577A696E6F6132664E39726C6870354A596D57354E3937474F63314D4A3546327169466472596E6C52344736646C37316A4A74457A2F414A665A43437943326C63626833386B746F374F71384B6B4C66536333446E506144726476792F44434F2B4C622B61797832465A36384248312F6358485A54697A50792F617236694B71344A74566552434132356554537531316C723037734644575272465652556A466D6963697463787A31562B3635467732743373464C7649726853496C7937656D624639546531654C6C4E714D7141725678555A6175435832335A696968652B676653705356457A555657787952794F633365586D5279536250523951726462536359733358737671612F4C746C7A5039324F506D2B3542455837566E5A4A363542625650452F51773242794141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414B623851766C62766659306E676B525436766E4A644837503954702B6234704F48727974325473617677535561546E494F304855372F6C2B4B467943346334523972393549372F414E6A546546776B665663334B33334431796E6A2B47564D696E644A584634642F4A4E6150664B72776D5174394A7A634F63396F4F74322F4C384D4A4A4A4B6C5644346B2F4B6C562F4E71623473714E5A7A6A6F665A7A71736547574C304838724F582F414879667761553836586E495A392B39557634766968644175584E58352F33372B2B5848357A4E385970515734356462794F627234495356705261376A64644D74524C666271643956577A73747151303861627A6E4B6B30726C3355394A716B6E49724D30744564355337317A61356571794C576E4373637630513154384A4E54504671762B426359766B5832536E2F414D747066334B2B566837396C624D57583549597233623572664A4F315851736E62757135725677565554315478616B31343453636A565A6564457A5330577732504862626258334F75686F4C66412B70724B6832374442476D4C6E75777877525055506B524D7A68444A6D5A6C61566D31707772445A50776B314D3857712F3446786B2B52665A4B462F4C61583979766C62706F33707A6E7130366C575734584B7831644A5251506D57616F6C6A56474E52315049314D56374A79495A74506B336938544D4B7A664738636A4D303136317657625468365952316E7637385A682B73367A776835487A66616E77726E51387854384666516D62684A2F6D737A2B393066727A457A5139317266617669792F7A66596D724F47654D6D35576253757A4C574D70457131656C4C7678537A4B376F39336677534E6B6D47472B336C4A755A6D5672375457644A6F733750782B56474F484877784870565031737A4A5963783538714C6E593530714C653643474E6B714D6647697559334233577661786558304371314E347466474F4A762B35644E6D5A4F6E69755A4746735A657A51584E57584D7335306E7547594B704B53686B6F5A59456B64484A4B69794F6C6963317537473136386A46356A37706231726247646A46763353356D666B52584C6A47334B69664E4F3159564E5364504D7A577538322F4C396648563138647471706C6A62424E457152746A56726E62306B62453558707A6C6838366C6F6D496E754E512F6A74526B3272624D7268586C524848487255794B64306B4141414146336448664A686C7A356D3331314C72542B78446D47392B745A6E346D657A543932627638797150696E47532F73796936626E612F696A30714346433679754E77372B535730646E566546534676704F62687A6E7442317533356668683539634E525A386B30396F6E6774644A636E317A356D4F3772617137695249785533634F72766E7A5535334977344D58726375376F314D326962577279634F4A45366353317A62493252755637536B6A4D6478364D66764A6A3146784976544A325132443662726868387937312B64666D762F41417442377162746A37303632794750365779766674356A7A7238312F7743466F50645464734F6E573251665332563739764D2B583856655A35457766593765394F584279797236376830363279434F792B56482B64764D346A346F38774F65317135667432437169624F6B3531394D644E6E5A4437505A6A4C392B336D57674C4E6F77414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414155333468664B33652B7870504249696E31664F5336503266366E54383378536350586C62736E593166676B6F306E4F51646F4F70332F4C38554C6B467735776A3758377952332F7361627775456A36726D35572B3465755538667779706B5537704B34764476354A72523735566545794676704F62687A6E7442317533356668684A4A4A55716F66456E3555717635745466466C52724F636444374F64566A77797865672F6C5A792F373550344E4B65644C7A6B4D2B2F657158385878517567584C6D72382F77432F663379342F4F5A766A464B4333484C7265527A64664243664F456A396C6D6E7371483171676E3644752B4A716661766A792F7A662B4B7768594E51566F347366372F59506D6B767869466272754F4736396C65627634593943504E47664B6A6C7A35326E2F59346A36666E4958472B4F71356E67574134694D365A6D79725A4C545532437464517A3146532B4F5A37575276336D4A4876496D456A5870796B2F56356C7178474455757A2B6A79732F4D74475A484B6949527A70487135714A6674524C4E6162746548314E767158797050417355444E3763676B6533726D527464375A714C73556A354766653134695A584F39743036624B303137307068614D4F374F324F2B6933506633347A44395A316E6844794C6D2B31506858756835696E344B2B684D3343542F4E5A6E39376F2F586D4A6D683772572B3166466C2F6D2B7837754B3669724B6D484C486330456B2B343674332B6A59352B474B5159593449754849657464457A6778646C7231724F5A6A4F48732F2B5375633045384569787A7875696B546C593971746474394253756D4735567445384D454D45383869527752756C6B586B5978717564733942424546725248444B592B47613256734F6F4E5574585379525250746B374636574E7A5775786C683264636D4337435A6F346E6C2B4A726661544D724F6E6A4359397550524B7A6E304E61506B4E5038457A32437A354D4E492B626662506C526A7844584F335748543265476D706F6F717937534E6F6F6E736A6A52794D584638764E6A67736256627336704631646F7254777276732F6C577A6454457A4D345534665635315369716442544C6C666942746469735675737A636F55383064464379463953366471766B5645362B525772447975646937446539556D553155566949354C573956754332626D577638414E6D4F5650466835754E5A6D6C74316B716161476F6A6F715A59356D4E6B59715273564652794971594C6831464C4B4968704E737938544D597A77506448484845784934326F786A646A574E524552505352443078544F504778326166757A642F6D56523855343833396D5762546337583855656C51516F585756787548667953326A73367277715174394A7A634F63396F4F74322F4C384D504872767072666337306C6E5A615A36574261435364307931636A6F305870577352753672577632395970383157544E384D475463653863765454626C784D38724469377949504E6D7A3538767448664D6E38456964447674687358314A702F6476354939626C7644486E39376B617975744C6E4C79496C524B712F456A6F642B382B54326C302B792F6B6A31754B76686D7A3753553074565656397067706F474F6B6D6D6B714A5773597871597563357977344969494A306434377350744F306D6E744D5246627A4D39365057696D70695A44555352527A4D7147527556725A3474394750524639733370477366677638417561696B5356395763597877775A484B2B584C766D4B39303172744D437A3155726B582F414773596970765065764D31502F524E75423670536254684444717452544A704E377A68432F42664F54674141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414142546669463872643737476B3845694B665638354C6F2F5A2F7164507A66464C7A61473353323276553630313979716F714B69686255394C557A7662484733657070474E786337424E726E49683830316F6938544C3376764B746D61573161784E7254687752345957712F4644546A786D746E66555062467038366D3247682F77415A716632372F706C70477457664D6B3354544739304E7576744457566B7A594F68706F4B694F5352797471596E4C7574613746634552564D4F707A617A5359695957653574446E3031564C577061496A48686D4A32537165565466317064447451736B5762545331322B3633756B6F36324A3953736C504C496A58745231524935754B656969346C6E7073327355694A6C6F6D2B39426E356D7174616C4C545867376E6568766E3474365A2B4D6C42384B68492B66546243712F6974562B3362794B77363833327A3376555771727254567831744773464F784B694A6435697562476D4B4976506869566D717446723477336A635752664B30305676484A6E4758566F50355763762B2B542B44536E7A53383544317633716C2F4638554C6F467935712F502B2F663379342F4F5A766A464B4333484C7265527A6466424351744E35706F644A39534A595875696C6248624E3252697131552F58794A735643526B7A2F313338536E336A45547138694A2F33394549372B6D62763875715068582B79522B564F31632F4A70736A794F6D6F724B75705671314D386B79747833656B65352B47504C6869716E795A6D5871744B31346F7766455530734D6A5A4958756A6B623756374656726B394A5544374D524D5953374B697572716C4774716169575A477269314A487565694B76557856524D7A4C7A584C725869694962316F46444E4A7178596C6A59353652756E6649725556643176633069627A734F524D5652445070592F374956652F5A694E4A664876656D47745A372B2F475966724F733849655938333270384B626F6559702B43766F544E776B2F7A575A2F6536503135695A6F653631767458785A66357673574D4C4670716F66456E3555717635745466466C52724F636444374F64566A7779634E6E6C5370506D315438574E487A68326A3672506868627774335041437133452F6D5A4C686E536D73735473596250416E536F6D7A3966506739794C316347497A44307972317438625962472B646D644E794D69627A78336E7A522F556F72735669727231567930744733656B68707169726673566573706F585375545A6A74647562716569704672576263532B7A382B7556455462757A45655763474F504C4D75646F526D44365A307A744C6E76613665686136696D61336C62304337724E3730566A3358657158476D766A53484E742B5A48793956625A626838763370414A436F597A4E50335A752F7741797150696E486D2F73797A36626E612F696A30714346433679754E77372B535730646E566546534676704F62687A6E74423175333566686876462F792F5A372F613572586436566C58517A70672B4A2B504C7A4F52557756484A7A4B6D314450616B576A4356586B61692B56654C306E43304B6F61726149586E4A30306C77747A5A4C686C355678376F524D5A494F66435A4535763936624F7268737871732F545454686A696239757666564E52484A742F626D656E77657048746D766431736C7968755671716E306C645475336F703431327036436F754B4F52656446544253505730316E4746766E5A4E4D32733176474E5A6278714272646D664F566C704C524F787446537874526139734C6E59564D7256324F646A7452696246526D4B37647171706E7A64546138594B7651626C79744E6562782F64506378376B663133576E5A627933654D7958694330326D425A367564665233574E546C653964754455782F344A7477517730704E7077685A616E5530796154653834524334756D476D466E794E5A306767524A376E4F694F727135794A76506468794A2B69314F5A502B4F4B72635A4F54464937376E4F383935333156385A344B78785133557A4B7741414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414B623851766C62766659306E676B525436766E4A644837503954702B6234705279523179414141414141416C6E68777970644C6A6E366C7662496E4D747471535638745372563348535069574E496D727A75776B336C366E5079706A4B306C4A6D2B506368722F614C5655707035792F38723463486A3431745332632F666E2F4148372B2B5848357A4E385970515734356462794F62723449627070666E374B32584C546637526D53317A58533358784B5A48775175526D796E56377575647678755461394D4D464D32546D31724578614D6356627650515A7564656C387130567454486A372B444E6662446834385271337675622F79444A387A4A393255586F6D386633712F706A2F3150746877386549316233334E2F35412B5A6B2B374A3054655037316630782F366E327734655045617437376D2F3867664D7966646B364A764839367636592F3841552B32484478346A56766663332F6B44356D5437736E524E342F76562F54482F414B74677972725A6F2F6C61527A37486C47716F5A4A45335A4A32755A4C4B72565646564E2B57527A384E6E4A765947536D7079363856555456626C316D667A6D62467652356F516E6D47357375742F7564305978596D5639585055746A63754B745361527A3061717079346278437662475A6C73326E792F6C35646165375749386B4A7934536635724D2F7664483638784E305064617632723473763833324C474669303155506954387156583832707669796F316E4F4F68396E4F7178345A5950527A4E3171796E6E716B75393133306F5778797853766A61726C62306A4D456475707456505350476E7A49706647556E66476B76714D6961553972675774797671666C484D39767556777445386B314E61574A4A574B2B4A386174525775667352794A6A736A5574615A3162524D7833476861726475646B5772573859546669345773796353576C725933755A5756443374525662476C4E4B6975564F524D5654446159756D5A6164485A3356593855655746564D7933796F7675594C68654B6A487061366438797456635661317939617A486E3357344E4B753975564D79337A545A455A5758576B663478676E4C685A796B79574F383569715759746B6239485579726A375679492B5A6346324B6939596E714B5464466C386374583754367243615A6366696E37507451666D697A50736D59376E614849354F34616D57427176324F566A48716A484C32546346495636386D3077326A5335337A6371742F65694A53506F66724861386A55747974393567714A3647726B6255514C537459397A4A55627576785237342F62496A65666D4A476D3145557869564E7672644639564E62556D497448427772525A637631466D43785556366F6D794D704B2B4A4A6F57796F6A5A4561376D636A56636D50704B576C4C52614D59614C714D6932566D5453334857587A6D6E37733366356C5566464F462F5A6C3930334F312F46487055454B46316C5A48527A575054334C576E747473393475546F4C6841366F644E43326E6E6B52765354766533726D4D63316357755264696C6A703952537449695A6158766664476F7A745261394B34316E447578736A767050756D724F514C5452573273756430376C6775384356567656304D376C6B685844422B456248713348464E6A73464A4E732B6B52457A5047704D7264576F7A4C577257754D306E4365474F5079734E57612B61514F7070477958684B6D4E794B6A345570616C5663693832446F6D6F654A31575874534B6269316D507359654F767256517A6463624463637856745A596142625A61356E71366E70484F336C616E4F37424E6A4E376C3347374738696243727A4A695A78694D496239704D764D706C78584D74797252336636394C446E684A53396F50716E6C6A4B4539525133756A5A547856654C2F706D4E72354A5563314F746A6C616D387535796F336354597137553271704C307566576E42506C6137767A646562714969314A78772F78395363597465644A705A57524D767A56664935474E52616172546175784E7178594954656C5A6531713837693163526A7950505831742F4A43704141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141444533444B4755376C564F71376A5A4B437471336F6950714B696C686C6B636A55776169766531584C676E49654A79367A787843526C36764F70474662327248656D596562385073672B4C56713779707530506E79716249386A33302F556675582F414654367A385073672B4C5671377970753048797162493868302F556675582F414654363274366A615A5A65724D6C58576D734F5737656C346B69524B4A61656D70345A4F6B336B39712F426D377378357A486E5A4D545763496A464E3366764C4D726E316E4D7A4C636A4868786D5A56792F4162566E78666638414430763855727569356D787558383770506638414E62314C49614F5A50714C4E703962726266726248446449487A394E484B324F5279492B6437326465336661765775546B557364506C3455694A6A68615A766656786D6169317375324E5A77323747362F51316F2B51302F775450594D2F4A6857664E76746E796E304E61506B4E5038457A32427959506D33327A35587069686969596A496D4E6A596E4931714969666B512B76457A4D38623644347158644F4862552B7075645A5552555650305530386B6A4D616D4A463358505655352F524B6D326B766936426C646F4E4C576B524D7A7752736C35664E7631552B52552F664D58736E7A6F6559796655576B327A354A504E7631552B52552F664D58736A6F65596655576B327A354A504E7631552B52552F664D58736A6F65596655576B327A354A504E7631552B52552F664D58736A6F65596655576B327A354A504E7631552B52552F664D58736A6F65596655576B327A354A504E7631552B52552F664D58736A6F65596655576B327A354A6374346274553163694C52307A5556634663745448676E6F3746565230504D664A3752365462506B546C6F7070525535447431612B34564C4B6936584657644F6B4B717354475262323431717552466376584B717532637547477A465A326D79506C787738637458337A76574E56614F544746613765506853575356496744587252334E6D5963797835677939544E726B6D686A6771615A4A474D6B613650484236644972473771747752647672374947713039725778687475347437354F546C664C7A4A3550446A456F752F4166566E78666B2B487076347046364C6D6246372F4F3654332F4E62314A663055302B7A686C334B3262364F383231314A55334B46724B4B4E587850575255686D626769736335453276546C556C36624B7457746F6D4F4E72752B74666B3532626C577062474B7A773865324551666750717A3476796644303338556964467A4E6A5976353353652F774361337164744E6F4271764E55527850737663374A4849315A355A344E78694C2B633763653932436567315437476C7A4E6A7A6266326B694D65586A34703953314F6E32555963705A527439696A64306A365A6972504A2B6C4D39643652796567726C58424F626B4C544B792B52574961487239584F6F7A725A6B3933306478444775576975624C7A6D2B544D47584B524B364F765A476C564132526A4A475378735269752F5771787536725774354635655968366E54326D324E5779376B337A6B35655438764E6E6B386E692F714563666750717A3476796644303338556A64467A4E69352F6E644A372F6D74366C71744D3756634C526B4B7957793477725431314A544E6A71495656726C61394658464D577172563952533079617A464969576862797A61356D6F76617334316D577731644E4856556B314C4B6D4D5538626F6E70315776525772795964557954474B4A5330316D4A6A754B625A67304D31487464796E7036657A7A33436C5939557036756D5248746B5A7A4B725558656176565255356554464E7054333031346E696448794E39366139596D625257646B735A2B456D706E6931582F41755050794C374A5A2F3562532F75563871524E5564507337584C4C32526F4B437A5656544E62375048543172493431565970576F3146592F714C734A47646C576D4B3452334650757A5835464D7A4F6D3134694C58786A76776A7638414354557A7861722F41494678482B52665A4B342F6C744C2B3558797468797677396169586576696A754645746E6F48594F6C7136687A46636A646D787354584B395862655263444A5453586D6548675139543267303258575A72504C74736A31706A7A4677345A4F7138725257323074576A7574473165353769753138726C397433522B6E7672376E3833424E684D76704B7A58434F4E726D6E37525A3163326258346154334E6E672F72683771457172682F315767715A49575762756C6A467753654B65446366364C6439374859656D3143464F6C7A4E6A5A36622B306B786A793850464A5236466172783163456A374139474D6B61357939505463694F52562F3841644561624D3246392B6153596D4F58357039533552634F6267414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141383977754E4262715353737236694F6C70495533705A355849786A5536726E4C73512B544D527779393565586138386D735979694C4E48452F6B32334F6B6773744E50654A32386B695951552B4B4C745466646939665452696F524C363273635843324854646D63362F44655970486C6E2B7647304B353856656370706B57335775677049552F4D6D36576433756B64436E2F53594C613633636946726C396C386D492F7574615A38556574345A4F4B4855683763477732324E6366624E676B782F7743715679486E70742B387A52325A3032322F6C6A314F767A6E4E54503644766433626E7A70742B382B2F54576C2F32387633486E4F616D6630486537753348546239342B6D744C2F74356675646C4C784C366C5331554D5475346431373274642F38646552565250307A37477376336E6D335A765452457A2F6435667557774C566F4B454E6374594D335A4B7A545232797A647A647A54304C4B6C2F54784C493766644E4B786346527A646D4561454C553669314C59527362507554644754716371625878786932484250656848586E4F616D66304865377533493354623935632F54576C2F32387633486E4F616D6630486537753348546239342B6D744C2F74356675504F63314D2F6F4F393364754F6D333778394E61582F4147387633486E4F616D6630486537753348546239342B6D744C2F743566756472654B505564476F69303974637636537753342F36544966656D33377A7A394D616262667978366E75747646586E474B5656754E716F61754A667A59656C67636E2F4D7270765750556136336469474C4D374C354D782F626130655366556B584A33456C6B79397978557431592B79566A30524E36645564544B355635456D54444245546E656A53526C367974755067552B73374F5A2B56474E503734373348355056696C74723276616A6D4B6A6D72794B69346F53327654446B44564E564D7933504C4F517272664C5A7564335561517244307264396E36796F6A6A64693346507A587159732B3831704D776E37723031632F55567937657A4F506F6D5664764F63314D2F6F4F3933647556335462393575503031706639764C3978357A6D706E3942337537747830322F65507072532F376558376A7A6E4E54503644766433626A70742B386654576C2F323876334F5738547570614F525662514F52467833567033594C364779524230322F655070725466376558376E6235306D6F3379573266415466786A3730322F656566706A5462622B57505579317134723877524D527431736C4C564F782F6155386B6B477A4839463354592F6C5139313130393245664E374C5A632B786559385044366B6F5A51313979426D53574F6C376F66624B2B5264316C4E576F6A4E356469496A5A455659334B3579344E626A764C3143546C36716C75386F7458754C555A4D5934637175325036785351696F7149714C696937555643537067414141786D59637A574C4C747664634C7A575230644D33486464497149726E4931586272452F4F6375477845504E3778574D5A5A395070737A4F747961526A4B484D783856646A70706C697346706C754457765648564653394B646A6D6F6E4B78714A492F61763653495137363649346F6248702B792B5A614D6379305638484330717234704E515A5A6C6454306C757034755273665253765831584C4A796D43646266764C4F6E5A6A547848444E703863657034352B4A6E553658643348305547376A6A3064506A6A6A3164397A2F3841512B54724C736C657A656C6A3370386271383550564C35565339374D506E544D78362B6E4E4C736E796E6E4A3670664B7158765A67365A6D48303570646B2B566D636D6351476F39317A665A4C5A57564E4D366B72712B6D7071687261646A56574F615A7248594B6E4975446A4A6C36713832694A326F327333447073764A766573546A57737A783749576A4C4E6F6F414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414165432F587933574B7A315632754D715130644A47736B723136696379645656356B5461764D6562576973597979354752624E76464B786A4D715A366C616E3333504631644C5576644261346E4B7446623272316A453545632F44327A384F666D35696E7A7336627A336E536432377379394C54434F472F646C7068685751694B71344A74566552414D7854354E7A66554D3336657833435A6D7864364F6C6E636D43386D314771656F7937624A5272617A4A6A6A765839554F7A37435A343858726E336E55646F66666C5732532B644F795066702B714437435A343858726E336E55646F506C573253644F795066702B714866525A467A73327470334F792F633274624978566374484F6949694F542F5966597972593855764639646B636D663736667168657376484C4657654B76372F4146742B716F2F435A797231337478344739396C2B72322F48396C554C6B4E73724B304F55733156394B79726F624E5856644A4C6A30645242545453527533565672743137577131634652555539526C326E696955652B72797154686139596E767A44762B776D6550463635393531486148333556746B765054736A33366671672B776D65504636353935314861443556746B6E54736A333666716838545A4B7A6C437A666D734E786A596E4B35394A4F314F72797177664C74736C396A57354D3856362F7168686C52555842646970796F65456B416E6E687A31557161653452354F75387979556C51697061706E752F5A50616D4B7771712F6D71314F7432374F5462696D4537535A2F44795A61703268335845312B64534F475061372F6657564C4A7053507466764A48662B787076433453507175626C623768363554782F444B6D5254756B76586262526462704F366E746C465058547361736A6F71614A387A3059696F69755672456375474C6B54452B78575A346D504D7A61556A473078574F2F4F44492F595450486939632B38366A744431387132795748703252373950315166595450486939632B38366A7442387132795470325237395031513864646C362F3239697672376256556A45324B366543534A4D6654653144354E4A6A6A686B70714D752F73327250676D4750504C4D4154666F62725A5857327570637335697158545771647951304E5A4B717564547556634778756474586F3158596E36504A375832733354616D596E6B32346D723737334C57395A7A63754D4C527878742B2F2B75506A732B696F7149714C6969375556437A614F41613371446E69335A4D7933555869737765397657556C4D726B6173737970317245352F547754596D307835755A464B34796D36445257314F62464B2B4F646B4B595A757A6A6673313361533533696F57615679723055536249346D722B6178764D6D7850524B624D7A4A764F4D756B365452356552546B306A37324550435549697175434A6971386949426C61664B6D614B686E5355396E72706D636D394854544F54483030617036696C746A4262565A55636436783434646E324C7A6A2F41494B34393654396F66666C32325338394D796666722B7144374635782F77567837306E3751664C74736B365A6B2B2F5839554E673039796A6D75445075573535374C5878515258536A664C4B2B6D6D6178725731444663357A6C626769496E4F6538724C747934344A3430546547727970302B5A4558726A794C64324E693670644F5A674141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414142577269677A79366F756C4E6C476B6C2F5555614E714C6A757279797654474F4E3248364C6575564F5461336E517264626D38504A6272325A3057465A7A70343534492B332B76436759677472534C6F39704C565A3675556B395335395059614E794E71366875787A33716D50525271757A48446137714A6831535270386A6C7A336C4E7666657361577545634F5A504636317263755A48796E6C756C376D7331736770575949313730596A70486F6E4A76794F78652F30315574615A646138554E433147747A73366362326D576350614B414141414372504658392F72623956522B457A6C587276626A774E37374C3958742B50374B6F5849625A56787548667953326A73367277715174394A7A634F63396F4F74322F4C384D4A494A4B6C414145626178615657664E4F586179737061526B655961534A5A614F6F6A6169506B364E4D6568646868764E63694B696452567849326F794974587672726447394C35475A4554502F41467A5044483271644651364D3946757236693333436C72365A55625555633063384B72745248784F5237663955507354684F4C786D5A6358724E5A34706A42662B68716D56644654315561347371496D5373564F52556531484A363566524F4D4F53587279625447786F7576336B6A762F59303368634A6731584E79746477396370342F686C54497033535577634C666C4771667179663436456C364C322F45313374503161507878364A57754C566F494277356A5874567230527A563555564D5542456F333147304F79706D716A6E6E6F71614F32587A726E78566B445559325236347171544E6273656A6C352B564F596A5A326D72614F44676C64627533336D354578467035564E6B2F59714A64625858577135564E74726F6C68724B535230553061387A6D726873586E52655646546C517162566D4A776C304C4B7A61356C5974586869586C506A4975506F4C6E57664E4751344F3748724A6362572F754B716B63754C6E6F78714C4849754B71355663785578566556555574394C6D63716E4478773578763352786B616963505A7477783971527953706C514F4944504B356B7A724C52553738625A5A74366D68524F5230794C2B75667461313374757477584844445A796C527173336C5777376B4F69626830507963694C5437562B487864784742475869567446394635733554706472756A344D755150773259746455756176584D59376C335535484F54306B326B725436666C384D385367337A766D4E4E48497077356B2B5A5A2B775A4E79766C2B6C625457693255394978753769396B6264397A6D4969493537384E357A746E4B705A31793631346F61506E367A4E7A707876615A5A6B396F77414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414144356B656B63626E72794D52584C683643596839694D564363323379532F5A6E756C3465357A7537616D53575066584679527137434E71722F745A67306F6379334B744D75723654496A4B7971303932502F414E596B387043372B6B2B566D355A794661626336506F3670304B5431754B496A756D6D2F5750525652457833566475706A7A49585752546B3069484D4E363672352B6F746275593452344962655A6C63414141414142566E69722B2F77426266717150776D637139643763654276665A66713976782F5A56433544624B754E77372B535730646E566546534676704F62687A6E7442317533356668684A424A556F4141363671574F476D6C6C6C77364F4E6A6E76336C524737725578584656356A354C31574D5A6949666E7339556339796F6D434B71716964516F485859634239582F414D763038744E596262547970684C4453775279496934344F624731463270364B4639574F43484A4D2B30546D576D4F374D744E312B386B642F37476D384C684D4F713575566C7548726C5048384D715A464F36536D446862386F31543957542F48516B76526533346D7539702B72522B4F50524B3178617442414141437366464E6C574F6A7A42623878514D3357584F4E304655725552453661424533584C7A71357A48596638705761326D45786261336673787175566C3279352F7741654750425039656442704362536D766859765471624F5678744C6C5249726A523949694C79724C547652573466386B6A795A6F7259576D477339714D6E6C5A4E622B3762302F77425173626D323874736D574C72643161352F634E4C4C4F6A4772677171786971694971386D336E4C484D7479617A4C54644C6B2F4E7A6130393659685171616157615A38307A316B6C6C63723548755846584F63754B71713956564B4A316549694977687A5455303954555255314F785A4A3533746A696A616D4C6E5065753631714A315656524559766C7252574A6D654B4638736E35647073755A5A74746D70326F31744841794E376B613171766B527162373362757A65633746564C334C70796178446C5772314535326261383932575950614D4141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414159485031624A5135487A425752624A494C645650597163714F534632432B6F593832634B7A5065533942534C5A394B7A336252365644796A6456652B775548306A66626462384E3775797168673363555448705A47737778585A7A6E326B597A454D57666D636A4C74625A45797638414D61316A5559314D477452455250515176334A4A6C794141414141414372504658392F72623956522B457A6C587276626A774E37374C3958742B50374B6F5849625A567174433838354D744F6D56716F726E664B4769724933314B79553039524648493148564D6974336D75636970696934375330303262574B52457A44513939364C507A4E5661316157744842777845374962372B4B476E486A4E624F2B6F65324D2F7A7162595650384147616E39752F365A5078513034385A725A33314432772B645462422F47616E39752F365A645652717A7070547456306D5A614279496D5036755A73712F6B6A336C4535394E73505664316171662F6E62794966316834676250646244555A65796F35387A61357652316C77657830625568636E58787874656A58627A76617556573459636E6F513952716F6D4D4B7469335275432B586D526D5A334279654B4F2B72365147334E7330747968555A717A7262726379506670575374714B39565256596B45546B6339485966702B303955793547587972524376336E7134794D6931753778523466363456346B52455245524D455459694958626C36507466764A486638417361627775456A36726D35572B3465755538667779706B5537704B594F4676796A5650315A50384148516B76526533346D7539702B72522B4F50524B3178617442414141434A754A71317056366172566263626457515438715959507867322F436B545756786F324473336D386E5534653957592B333746536971644162396F5255397A367232427976566A5A4A4A596C564D64752F4249314532645632426E30732F396B4B6E666C63644A6678656D46692B494F7166543654336C476373793030537169345949366F6A5666796F6D42593671662B75576E6267726A71366437483053707355376F3761644C62613634366A5A63705562766F7466444B39754F474C4958644B2F62324C464D7552474E34384B4276544D35476D7A4A2F316E7A38433870647558414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414144574E55504A786D62367371766958474C4F396966416E6273367A6C2F6A72365647436B64535A7A49716F6D6438764B75784575644869762F3841517739355874523455585863786638414262304C354636355341414141414141717A78562F6636322F565566684D3556363732343844652B792F5637666A2B7971467947325541414141414463636D61545A337A624C47747674373461422B437263616C46696752713439633158625A506134645A6A744D32586B5776785172645A76584930386633577874736A6A2B377872576161615A5762496C70645330626C714B366F335672713579627270584E545A737858646133466431764E36617171326D546B78534F426F573874355831563862634659346F324E784D7975523972393549372F324E4E3458435239567A6372666350584B6550345A55794B64306C4D4843333552716E36736E2B4F684A65693976784E64375439576A3863656956726931614341414145623852486B6C752F5A307668555A4731664E7975757A2F57362F6D2B47564F536F644762706F776972716A6C7A424D662F414A582F414F446A4E702B636857623536726D65425937694D386C4E79392B70666A32466A712B626C70765A3772646642506F55394B683056765768796F6D7132586C5663453661525056574352454D2B6D357946567676716C2F4239734C714679356F41414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414D4E6E573350755754373362324971767171437069596A6556585069636A552F4B654D794D617A48655364486D636A4F70625A6150536F5555547137766F6170394858553957784D583038724A5770364C48493550574554684C786D5535565A6A62443941715370697171534771695648525478746C6A6369346F72586F6A6B5646394A532F6963584A4C316D737A453978326E3135414141414141717A78562F6636322F565566684D3556363732343844652B792F5637666A2B7971467947325650476C7567575663335A496F4C395856396442563154706D7952774F68534E4F696D66476D366A6F334F3971314F636E5A476C726573544D79315465652F7333543539737574617A455963654F7A777473383150492F77446C4C6E37756E2F676D586F4E64736F4831546E2B37547A2B743436336850792B364E33634E3971345A4E753673386363716567693776524879644448636C6B7032717A4D663771566E775978363269357434614D3657616E6B71725650466536654E7538356B545668714E694B727349334B35713459667034727A4A69594D7A52326A69345670704F306D526D5468654A70506C6A792F6369536147574756384D7A4852797875566B6B623056726D7561754374636937555646496B7732474A695978686E736E35397A526C4775625632577364453148623074493956645479386D4F2F486A6874524D4E354D485963696D544C7A62556E67524E586F637255567776486A3773654E63485462554F3135347344626C534A304654477652317445713475696B52455655782F4F62743631796371645263577062354F624634786337336A752B2B6C7A4F54504448636E613277797139483276336B6A762F59303368634A4831584E79743977396370342F686C54497033535577634C666C4771667179663436456C364C322F45313374503161507878364A57754C566F494141415248784F3356744A70793269526576755662444675375061786F365A562F4B7870453174734B59625777396D73726C616E6C65375766557161565466306A63506C464E5536723264386547464D326F6D6B782F525342375058656849307359356B4B6266393472704C59393343505043772B766C424A57365533747362584F6B67624455493176364D55374850566651526D38705961714D6375576E37697A4F54713659393347504C45715A464F36537A6D52626C48624D36574B345375526B4E4C58303073726C58424559325671767858622B6269653871634C5250665264646C38764976574F4F617A364638693963704141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141484432746531574F5446726B56465430464245714A5A2F79387558633658697A3775354853314C3067626A6A2B7065752F4674393763306F73326E4A744D4F71364455664F794B583278352B373532766E684C57393465733677332F497450625A4870394A574E45704A3249694A6A436E37422B7A71733633466556577157326B7A4F5658447577353576384130553557664E6F396D2F44342B366C456C4B4941414141414372504658392F72623956522B457A6C587276626A774E37374C3958742B50374B6F5849625A56787548667953326A73367277715174394A7A634F63396F4F74322F4C384D4A494A4B6C414146632B4A7654326C7032302B634C64436B617950536E756A574A7356565439564B7543594A7962693958464F6F563273797638414B4735646D7434544F4F5461652F5837592B315830674E75537077345A6B6D74576F6B4E753331376C764D627165526D39757436534E7179524F5871716D446D7032524B306C384C34625644326930305A6D6D6D336470772B74626F746E505566612F65534F2F396A546546776B665663334B33334431796E6A2B47564D696E644A544277742B5561702B724A2F6A6F53586F766238545865302F566F2F48486F6C613474576767414142565069587A6C46654D3230396B704A456B706249787A5A584E584646714A7346656D78566175363172553950464371316D5A6A624459333373336F3579386D627A783339454964496A593039634B57583353586938583937586F796E686252774F7736787A70584A4A496D5056616A47666C4A326870777A4C564F314F6F7770544C327A6A354F4C375668637757694338324F34576D6F2F593139504C547656467756456B59726355584265544871466865754D5444554E506E546C356C627878316D4A55477261536F6F7179656A715764485555306A345A6D6375362B4E7974636D7A714B68517A4745344F735576467178614F4B58534870646652334F7365624D6A3056572B546675464B314B613470676A634A6F30777836314562673575446B524F54457564506D6375726D653939464F6E7A356A2F41426E686A774E334D3672414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414146663841696679444E50465435786F593165366E616C4E6330627939486976525359624E6A567861764B75314F5A43427263722F41436874765A6E5878457A6B3237764458375956784B3575624E35517A6A666370586D4F375761626F7032624A49336259355763374A4734706931667939513935655A4E4A78684631656A793952546B586A6739437947574F4A334A4666546F6C386A6E74465731714B2F72485477756371375559364E485039303143787072617A783844544E5432617A36542F3134586A79543532373032724F6D6C517A666A7A4C623270314A4A32784C742F327962716D654D2B6D32465A626457706A2F414F647649376678513034385A725A33314432772B645462447A2F47616E39752F77436D5438554E4F504761326439513973506E55327766786D702F62763841706C7933553754707A6B61334D747356793745524B71484656582F6D487A716259503433552F74332F544C5A6A4B677173385666332B747631564834544F5665753975504133767376316533342F7371686368746C584734642F4A4C614F7A717643704333306E4E77357A3267363362387677776B676B71554141616871376159377070726D436D65315871796B6B71493270697137394F6E544D324A364C44446E3178704B7833546D7A5455306E2F41477738764170415572703759744F616D576D7A2F6C79614C3236584B6C627A386A356D74586B3942544A6B7A68655043683778724674506D5250755739433968654F566F2B312B386B642F37476D384C68492B71357556767548726C5048384D715A464F36536C50687976646D7332664B6D727539644262365662644E476B395449324A6976644C43714E525871694B716F69374356704C5246385A324B4874446B337A4E504555696254796F347548755373702B4B476E486A4E624F2B6F65324C4835314E734E4C2F6A4E542B3366394D6E346F6163654D31733736683759664F7074672F6A4E542B3366394D7642644E61644C376178487A5A67707073567733615658564B2F6B6852353874714B523357584B334E717238564A6A7738487052587144784F527A306B3975796A54534D64496A6D4C644B684562756F757A6569693271754B667034594C7A4B524D33576479712B30485A71596D4C5A302F6C6A375A56396C6C6C6C6C664C4B39306B736A6C644A49355663357A6E4C69717171375656564944626F69496A43484D45453038386345444853545375526B5562557863357A6C77613145546C56564551577445526A5045753370506B6C7554386C5564726B616956306D4E5263484969597250496962795970796F784552714C31454C7249792B5258427A4865757436526E7A66384178346F384463444D726C564F4A4C49556C6E7A52396F3657502F363638726A4F354D4D4756534A31324B496A55546654627A376356586C4B72575A57467556334A6237326331305A6D5638716661703650755134524778746C794A6E2F4D475372763841534E6F6C54646B54637136522B4B78544D366A6B3671666D753576537851795A57624E4A786843313267793954546B33385539324669387563545751612B6D62394D4A50614B744E78736A4852756D69565654726C592B4A484C756F7636545555736161796B386641303755646D39525366374D4C78355053322B6D3165307971492B6B6A7A4A524E62314A4A4F696479592B316B527275667147574E525461727262703155662F414473376678573032385A626433777A325437382B6D32486E2B4C31503764764966697470743479323776686E736A35394E7348385871663237655232306D70576E395A5677306C4A6D43676E71716837596F4957547363393733716A577461694C74565658412B786E556E677868357675335556695A6D6C6F694F383255794951414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414164565A5355315A5354556C564732616D71474F6A6D696531484E637879594B697463696F714B6E56506B78693955764E5A6959344A685650565851533935647135726C6C2B4239665970484B357345534F6B6E7038563972753963353745356E63714A37626B336C71382F537A58686A696237757666744D3649726D5479622B6166565039643545524562434141414144766F5035366D39395A2F3349665934336A4D396D66412F51637633496C57654B76372F573336716A384A6E4B76586533486762333258367662386632565175513279726A634F2F6B6C74485A31586855686236546D34633537516462742B583459535153564B414150426D436C5773734E797045544661696C6E69524635392B4E7A662B4A3574474D5379354675546D566E5A4D4B4146433632396C6D72456F727851316972676C4E5552544B7655364E364F35765350745A776D4A5938366E4B706175324A666F43787A58745237567861354556463942532F636A6D4566362F65534F2F396A546546776B665663334B33334431796E6A2B47564D696E644A4141414141413771536A713679706A70614F435370715A5633596F4957756B6B63764C67317255565645526A78504E3778574D62546843792B695768533257534C4D6D5A6D4E64644554656F614446484E6778543970497162485036694A73543065617930326D35503931754E704F2B742B664E6963724B396E757A742B354F4A4F61754159334D5758375A6D437A564E6F75634C5A364F7162757659354D64714C6969707A6F714C794B696F7163796F703576534C52684C4E703952624A7646367A684D4B67366C614F356C795856795339452B747369396444634930336B61692F6D7A496E745654394C6B585A794B754356476470375538446F6D3774373557706A44486B333265706F4A675777414141414E6A3033386F6557507261683849595A4D6E3234384D49653865725A6E344C656956367938637241414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141564556465255785264696F6F4771356B307379446D4E37704C725A6F4A4A3371697671496B57475A634F5A5A496C593744315446664970626A6850302B3839526B38464C7A6873343438375236376862302B6E6D57536E717268534D582F414E714F574E3755394A5A4933752F314D45364B6E66576C4F302B6F694F474B7A347039627953634B57544677364B3733467656336C676436306254353047753257534F314F64336131382F7264666D6F5A552F7A5666376D4874543530477532583336707A766372357A7A554D7166357176397A44326F364458624A3955353375563837376734566371777A527970656135566A636A30525777345974584839452B786F61375A664C64714D3259773546664F6D346D7459523971486F726C7A5056346775747A7261796D6E703664744B786C4D364A474B7872337949713738623178786B586E492B627036336E475676752F664F5A7061545373566D4A6E486878396256764E5479502F414A53352B37702F344A69364458624B663955352F7530382F7253626B6E4B4E446C484C6C505961476157656C7058534F6A6B6E33566B5870587249753872456133327A6C3569566C3563556A43464872645862555A6B356C6F694A6E597A703752514141564556465255785264696F6F454E316E43356B6171724A366E36517545505479506B36474A304B527333334B3764596A6F6E4F335578775446564963364B737A787932536E616650725749354E5A7738507264506D7035482F796C7A3933542F7741452B644272746C362B71632F336165663170667339752B6A62565357394A704B6C4B534A6B4C5A3563466B656A453355632F424554655645323449544B786847445863374D3564357468686A4C4835317972533572797A57356671356E3039505770476A356F734665336F355779706876497163724D447A6D553564634762523671636A4E6A4D694D5A72367345552B61686C542F41445666376D4874534A304775325639395535337556383535714756503831582B35683755644272746B2B716337334B2B633831444B6E2B61722F637739714F6731327966564F64376C664F6561686C542F4E562F75596531485161375A50716E4F3979766E646B66436C6B314D656C75397864314E3159472B7647342B394272746C386E74546E64797466503633757476432F7031537A644A56545639657A6D686D6D59786E713943794E332F55656F3056493273575A326D314E6F77694B313858727853446C72496D55637378626C6B746B4E4937645272356D74786C65694C696D2F4937467A734F62465450544B7258696855616E585A3266503939706C6E6A496941414142772B4E6B6A465A49314873647974636D4B4C3669683969634769332F512F544F3979724E5557646C4E4F75396A4A527564543471396364355778344E5655586B7851775730314C6478615A472B74566C5268467359372F414174506D34564D6B756B63364B36584B4F4E6661735630446C543165695177394272746C597832707A384F4774505036336D6E345438744B354F67766C6247336E523863543178394E4559664F6731327663647173337530723533563570746A38594B72344750746830474E723139565A6E755235547A54624834775658774D6662446F4D625436717A50636A79736A6C37686C73316C76317576444C33557A507431544456736964464731484F68656B694E5655566469713039553063566D4A78346D485564704C356D58616E49694F564578783755304578725141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141414141422F396B3D, NULL, NULL, NULL);
-- ----------------------------
-- Table structure for magic_api_file
-- ----------------------------
DROP TABLE IF EXISTS `magic_api_file`;
CREATE TABLE `magic_api_file` (
`file_path` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`file_content` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
PRIMARY KEY (`file_path`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of magic_api_file
-- ----------------------------
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/', 'this is directory');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/test/', 'this is directory');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/test/group.json', '{\r\n \"properties\" : { },\r\n \"id\" : \"5d306bd5b42f4e83b5318351d90bdaf2\",\r\n \"name\" : \"test\",\r\n \"type\" : \"api\",\r\n \"parentId\" : \"0\",\r\n \"path\" : \"test\",\r\n \"createTime\" : 1670682885050,\r\n \"updateTime\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"paths\" : [ ],\r\n \"options\" : [ ]\r\n}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/test/用户退出.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"d985999e06184641afecc5d4e0849a23\",\r\n \"script\" : null,\r\n \"groupId\" : \"5d306bd5b42f4e83b5318351d90bdaf2\",\r\n \"name\" : \"用户退出\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1678551575619,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"logout\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nimport cn.dev33.satoken.stp.StpUtil;\r\nStpUtil.logout();\r\nexit 200, \'用户已退出登录\';');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/test/登陆验证.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"e3c2c2cbbee54ed3829e543aafc63c51\",\r\n \"script\" : null,\r\n \"groupId\" : \"5d306bd5b42f4e83b5318351d90bdaf2\",\r\n \"name\" : \"登陆验证\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1678547112400,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"login\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"{\\\"loginid\\\": \\\"admin\\\",\\r\\n\\\"password\\\":\\\"123000\\\"\\r\\n}\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : \"{\\n \\\"code\\\": 200,\\n \\\"message\\\": \\\"success\\\",\\n \\\"data\\\": {\\n \\\"userid\\\": 1,\\n \\\"userName\\\": \\\"小红\\\",\\n \\\"loginid\\\": \\\"admin\\\",\\n \\\"password\\\": \\\"123000\\\",\\n \\\"age\\\": 24,\\n \\\"sex\\\": \\\"男\\\",\\n \\\"headPortrait\\\": null,\\n \\\"isdel\\\": null,\\n \\\"createTime\\\": null,\\n \\\"creator\\\": null,\\n \\\"extend1\\\": null,\\n \\\"extend2\\\": null,\\n \\\"extend3\\\": null,\\n \\\"extend4\\\": null,\\n \\\"extend5\\\": null\\n },\\n \\\"timestamp\\\": 1672145855400,\\n \\\"executeTime\\\": 9\\n}\",\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : {\r\n \"name\" : \"root\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"loginid\",\r\n \"value\" : \"admin\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"password\",\r\n \"value\" : \"123000\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n } ]\r\n },\r\n \"responseBodyDefinition\" : {\r\n \"name\" : \"\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"code\",\r\n \"value\" : \"200\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"message\",\r\n \"value\" : \"success\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"data\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"userid\",\r\n \"value\" : \"1\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"userName\",\r\n \"value\" : \"小红\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"loginid\",\r\n \"value\" : \"admin\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"password\",\r\n \"value\" : \"123000\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"age\",\r\n \"value\" : \"24\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"sex\",\r\n \"value\" : \"男\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"headPortrait\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"isdel\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"createTime\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"creator\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"extend1\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"extend2\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"extend3\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"extend4\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"extend5\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n } ]\r\n }, {\r\n \"name\" : \"timestamp\",\r\n \"value\" : \"1672145855400\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Long\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"executeTime\",\r\n \"value\" : \"9\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n } ]\r\n }\r\n}\r\n================================\r\nimport response;\r\nimport cn.dev33.satoken.stp.StpUtil;\r\nprintln(body)\r\nvar sql = \"\"\"\r\nselect\r\n u.* ,\r\n (\r\n select\r\n GROUP_CONCAT(r.role_name separator \',\')\r\n from\r\n role_info r\r\n where\r\n r.roleid in (\r\n select\r\n roleid\r\n from\r\n role_user ru\r\n where\r\n ru.userid = u.userid) ) as role\r\nfrom\r\n user_info u\r\n where loginid = #{body.loginid}\r\n\"\"\";\r\nvar userInfo = db.selectOne(sql);\r\nif (userInfo != null && userInfo != \"\") {\r\n if (body.password == userInfo.password) {\r\n StpUtil.login(userInfo.loginid)\r\n var token = StpUtil.getTokenInfo()\r\n userInfo.token = token\r\n return userInfo;\r\n } else {\r\n return response.json({\r\n code: 500,\r\n err: \"密码错误！\"\r\n })\r\n }\r\n} else {\r\n return response.json({\r\n code: 500,\r\n err: \"账号不存在！\"\r\n })\r\n}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/公告管理/', 'this is directory');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/公告管理/group.json', '{\r\n \"properties\" : { },\r\n \"id\" : \"9822d63957034db898063b0a62852bee\",\r\n \"name\" : \"公告管理\",\r\n \"type\" : \"api\",\r\n \"parentId\" : \"0\",\r\n \"path\" : \"announcement\",\r\n \"createTime\" : 1678377129175,\r\n \"updateTime\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"paths\" : [ ],\r\n \"options\" : [ ]\r\n}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/公告管理/修改信息.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"9e81f7b0c38b4f2c853cd2bc3823ba9e\",\r\n \"script\" : null,\r\n \"groupId\" : \"9822d63957034db898063b0a62852bee\",\r\n \"name\" : \"修改信息\",\r\n \"createTime\" : 1679111381523,\r\n \"updateTime\" : null,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"update\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nreturn db.table(\"announcement_info\").primary(\"announceid\").update(body)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/公告管理/删.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"21621d9ed3ce40f7a28466f37d6c4ae9\",\r\n \"script\" : null,\r\n \"groupId\" : \"9822d63957034db898063b0a62852bee\",\r\n \"name\" : \"删\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1678528642351,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"delete\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\n\r\nvar sql=\"\"\"\r\ndelete from announcement_info where announceid in\r\n<foreach item=\'item\' index=\'index\' collection=\'body.multipleSelection\'\r\n open=\"(\" separator=\",\" close=\")\">\r\n #{item.announceid}\r\n</foreach>\r\n\"\"\"\r\n\r\nreturn db.update(sql)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/公告管理/增.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"09743a117b854310b2273a3ab7339507\",\r\n \"script\" : null,\r\n \"groupId\" : \"9822d63957034db898063b0a62852bee\",\r\n \"name\" : \"增\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680265178509,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"insert\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nbody.createTime = now()\r\nreturn db.table(\'announcement_info\').insert(body)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/公告管理/查.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"aa03fa19a9584fbe89be4da5f7f3425f\",\r\n \"script\" : null,\r\n \"groupId\" : \"9822d63957034db898063b0a62852bee\",\r\n \"name\" : \"查\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680268210303,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"getList\",\r\n \"method\" : \"GET\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : \"{\\n \\\"code\\\": 200,\\n \\\"message\\\": \\\"success\\\",\\n \\\"data\\\": {\\n \\\"total\\\": 4,\\n \\\"list\\\": [{\\n \\\"announceid\\\": 1,\\n \\\"title\\\": \\\"春季打折啦\\\",\\n \\\"text\\\": \\\"三月四月会员8折\\\",\\n \\\"type\\\": \\\"折扣活动\\\",\\n \\\"isdel\\\": \\\"\\\",\\n \\\"createTime\\\": null,\\n \\\"deadline\\\": null,\\n \\\"creator\\\": \\\"admin\\\",\\n \\\"grade\\\": \\\"普通\\\",\\n \\\"picture\\\": null,\\n \\\"extend3\\\": null,\\n \\\"extend4\\\": null,\\n \\\"extend5\\\": null,\\n \\\"Picture\\\": null\\n }, {\\n \\\"announceid\\\": 7,\\n \\\"title\\\": \\\"aaaaaaaaaaaaaaa\\\",\\n \\\"text\\\": \\\"dddddddddddddddddddd\\\",\\n \\\"type\\\": \\\"赛事活动\\\",\\n \\\"isdel\\\": \\\"1\\\",\\n \\\"createTime\\\": null,\\n \\\"deadline\\\": null,\\n \\\"creator\\\": \\\"dddddddddddddd\\\",\\n \\\"grade\\\": \\\"重要\\\",\\n \\\"picture\\\": null,\\n \\\"extend3\\\": null,\\n \\\"extend4\\\": null,\\n \\\"extend5\\\": null,\\n \\\"Picture\\\": null\\n }, {\\n \\\"announceid\\\": 8,\\n \\\"title\\\": \\\"2023年3月18日休息\\\",\\n \\\"text\\\": \\\"休息休息休息休息休息休息休息休息休息\\\",\\n \\\"type\\\": \\\"休息通知\\\",\\n \\\"isdel\\\": \\\"1\\\",\\n \\\"createTime\\\": null,\\n \\\"deadline\\\": null,\\n \\\"creator\\\": \\\"admin\\\",\\n \\\"grade\\\": \\\"重要\\\",\\n \\\"picture\\\": null,\\n \\\"extend3\\\": null,\\n \\\"extend4\\\": null,\\n \\\"extend5\\\": null,\\n \\\"Picture\\\": null\\n }, {\\n \\\"announceid\\\": 9,\\n \\\"title\\\": \\\"比赛\\\",\\n \\\"text\\\": \\\"竞技规则:中式八球最新比赛规则(所有球无须报袋)，女子及 14 岁以下选手直接让后预选赛采用7局4胜制;\\\\n正赛相错蹿奥安局5胜制;\\\\n半决赛 13局7胜制\\\\n决赛17局9 胜制;\\\",\\n \\\"type\\\": \\\"赛事活动\\\",\\n \\\"isdel\\\": null,\\n \\\"createTime\\\": null,\\n \\\"deadline\\\": null,\\n \\\"creator\\\": null,\\n \\\"grade\\\": \\\"重要\\\",\\n \\\"picture\\\": \\\"aHR0cDovLzEyNy4wLjAuMS9maWxlL2Rvd25sb2FkSW1nP25hbWU955m+5LqL5Y+v5LmQLnBuZw==\\\",\\n \\\"extend3\\\": null,\\n \\\"extend4\\\": null,\\n \\\"extend5\\\": null,\\n \\\"Picture\\\": \\\"http://127.0.0.1/file/downloadImg?name=百事可乐.png\\\"\\n }]\\n },\\n \\\"timestamp\\\": 1680267008908,\\n \\\"executeTime\\\": 10\\n}\",\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : {\r\n \"name\" : \"\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"code\",\r\n \"value\" : \"200\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"message\",\r\n \"value\" : \"success\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"data\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"total\",\r\n \"value\" : \"4\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"list\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Array\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"announceid\",\r\n \"value\" : \"1\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"title\",\r\n \"value\" : \"春季打折啦\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"text\",\r\n \"value\" : \"三月四月会员8折\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"type\",\r\n \"value\" : \"折扣活动\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"isdel\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"createTime\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"deadline\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"creator\",\r\n \"value\" : \"admin\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"grade\",\r\n \"value\" : \"普通\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"picture\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"extend3\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"extend4\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"extend5\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"Picture\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n } ]\r\n } ]\r\n } ]\r\n }, {\r\n \"name\" : \"timestamp\",\r\n \"value\" : \"1680267008908\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Long\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"executeTime\",\r\n \"value\" : \"10\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n } ]\r\n }\r\n}\r\n================================\r\nvar sql = \"\"\" \r\nselect *,convert(picture using utf8) _picture from announcement_info where 1=1 \r\n<if test = \"title != null and title != \'\'\">\r\n and title like concat(\'%\', #{title}, \'%\')\r\n</if>\r\n<if test = \"type != null and type!=\'\'\">\r\n and type = #{type}\r\n</if>\r\n<if test = \"grade != null and grade != \'\'\">\r\n and grade = #{grade}\r\n</if>\r\n<if test = \"isDel==0\">\r\n and (is_del is null or is_del != \'1\')\r\n and (deadline is null or deadline > sysdate())\r\n</if>\r\n \"\"\"\r\nreturn db.page(sql)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/商品/', 'this is directory');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/商品/group.json', '{\r\n \"properties\" : { },\r\n \"id\" : \"bbce05c92a1b47aea07ceba9379e3694\",\r\n \"name\" : \"商品\",\r\n \"type\" : \"api\",\r\n \"parentId\" : \"0\",\r\n \"path\" : \"shop\",\r\n \"createTime\" : 1678517985170,\r\n \"updateTime\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"paths\" : [ ],\r\n \"options\" : [ ]\r\n}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/商品/下单_球桌.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"49e9304e1e2446f4b14f47d8a17455ca\",\r\n \"script\" : null,\r\n \"groupId\" : \"bbce05c92a1b47aea07ceba9379e3694\",\r\n \"name\" : \"下单_球桌\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680255069145,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"shoppingForTable\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nimport redis\r\nimport cn.dev33.satoken.stp.StpUtil;\r\nvar orderid = redis.get(body.tableid)\r\nvar user = StpUtil.getLoginIdDefaultNull()\r\nvar tx = db.transaction(); //开启事务\r\nvar updateSql = \"\"\"\r\n update commodity_management set number = number - ? where name = ?\r\n\"\"\"\r\nvar param = []\r\nvar name = []\r\nvar amount = []\r\nfor (index,item in body.shoppingTrolley){\r\n param.push([item,index].toArray())\r\n name.push(index)\r\n}\r\ntry{ \r\n db.batchUpdate(updateSql,param)\r\n tx.commit(); // 提交事务\r\n}catch(e){\r\n tx.rollback(); // 回滚事务\r\n}\r\nvar operations = []\r\nfor (index,item in body.shoppingTrolley) {\r\n var sql = \"\"\"\r\n select name,number,price,selling_price from commodity_management where 1=1 and name = #{index}\r\n\"\"\"\r\n var operation = db.selectOne(sql)\r\n operation.changeNumber = item\r\n operation.orderid = orderid\r\n operation.operationType = \'shopping\'\r\n operation.user = user\r\n operation.time = now()\r\n operations.push(operation)\r\n}\r\ndb.table(\'shop_operation\').batchInsert(operations)\r\nreturn {orderid,sumPrice}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/商品/商品消费金额.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"0a616c61a5ee4800a65b0629e34694fc\",\r\n \"script\" : null,\r\n \"groupId\" : \"bbce05c92a1b47aea07ceba9379e3694\",\r\n \"name\" : \"商品消费金额\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680257059292,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"commodityMoney\",\r\n \"method\" : \"GET\",\r\n \"parameters\" : [ {\r\n \"name\" : \"tableid\",\r\n \"value\" : \"1\",\r\n \"description\" : null,\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : null,\r\n \"error\" : null,\r\n \"expression\" : null,\r\n \"children\" : null\r\n } ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : \"{\\n \\\"code\\\": 200,\\n \\\"message\\\": \\\"success\\\",\\n \\\"data\\\": {\\n \\\"shopCharge\\\": 38.5,\\n \\\"shopList\\\": [{\\n \\\"name\\\": \\\"怡宝\\\",\\n \\\"changeNumber\\\": 3\\n }, {\\n \\\"name\\\": \\\"冰红茶\\\",\\n \\\"changeNumber\\\": 3\\n }, {\\n \\\"name\\\": \\\"红牛\\\",\\n \\\"changeNumber\\\": 2\\n }, {\\n \\\"name\\\": \\\"农夫山泉\\\",\\n \\\"changeNumber\\\": 1\\n }, {\\n \\\"name\\\": \\\"百岁山\\\",\\n \\\"changeNumber\\\": 1\\n }, {\\n \\\"name\\\": \\\"干脆面\\\",\\n \\\"changeNumber\\\": 1\\n }, {\\n \\\"name\\\": \\\"红烧牛肉面\\\",\\n \\\"changeNumber\\\": 1\\n }]\\n },\\n \\\"timestamp\\\": 1678554050196,\\n \\\"executeTime\\\": 9\\n}\",\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : {\r\n \"name\" : \"\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"code\",\r\n \"value\" : \"200\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"message\",\r\n \"value\" : \"success\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"data\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"shopCharge\",\r\n \"value\" : \"38.5\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Double\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"shopList\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Array\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"name\",\r\n \"value\" : \"怡宝\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"changeNumber\",\r\n \"value\" : \"3\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n } ]\r\n } ]\r\n } ]\r\n }, {\r\n \"name\" : \"timestamp\",\r\n \"value\" : \"1678554050196\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Long\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"executeTime\",\r\n \"value\" : \"9\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n } ]\r\n }\r\n}\r\n================================\r\nimport redis\r\nif (!orderid){\r\n orderid = redis.get(tableid)\r\n}\r\nvar sql = \"\"\"\r\n select sum(selling_price * change_number) price from shop_operation where orderid = #{orderid}\r\n\"\"\"\r\nvar shopCharge = db.selectValue(sql)\r\nif (shopCharge == null){\r\n shopCharge = 0\r\n}\r\nvar sql = \"\"\"\r\n select name,sum(change_number) change_number from shop_operation where orderid = #{orderid} group by name\r\n\"\"\"\r\nvar shopList = db.select(sql)\r\n\r\nreturn {\r\n shopCharge,shopList\r\n}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/商品/计算商品总价值.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"e948c2afae1b4a55b0e43cd6b96775b6\",\r\n \"script\" : null,\r\n \"groupId\" : \"bbce05c92a1b47aea07ceba9379e3694\",\r\n \"name\" : \"计算商品总价值\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1678522539440,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"sumCommodity\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nimport redis\r\n\r\nvar commodity = db.table(\'commodity_management\').select()\r\nvar sumPrice = 0\r\nfor (index,item in body.shoppingTrolley){\r\n var sellingPrice = select c.sellingPrice from commodity c where c.name = index\r\n var price = sellingPrice[0].sellingPrice\r\n sumPrice += item * price\r\n}\r\nvar orderid = redis.get(body.tableid)\r\nreturn {orderid,sumPrice}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/商品操作/', 'this is directory');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/商品操作/group.json', '{\r\n \"properties\" : { },\r\n \"id\" : \"9051d2fbfe9047b3926f35ee0596b68f\",\r\n \"name\" : \"商品操作\",\r\n \"type\" : \"api\",\r\n \"parentId\" : \"0\",\r\n \"path\" : \"shopOperation\",\r\n \"createTime\" : 1678707524452,\r\n \"updateTime\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"paths\" : [ ],\r\n \"options\" : [ ]\r\n}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/商品操作/操作查询.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"a635df5981e145b793ff18a0e1d51cb9\",\r\n \"script\" : null,\r\n \"groupId\" : \"9051d2fbfe9047b3926f35ee0596b68f\",\r\n \"name\" : \"操作查询\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680964437332,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"select\",\r\n \"method\" : \"GET\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nvar sql = \"\"\" \r\nselect * from shop_operation where 1=1 \r\n<if test = \"orderid != null and orderid != \'\'\">\r\n and orderid like concat(\'%\', #{orderid}, \'%\')\r\n</if>\r\n-- <if test = \"time != null and time!=\'\'\">\r\n-- and time = #{time}\r\n-- </if>\r\n-- <if test = \"operationid != null and operationid!=\'\'\">\r\n-- and operationid = #{operationid}\r\n-- </if>\r\n-- <if test = \"tableid != null and tableid!=\'\'\">\r\n-- and tableid = #{tableid}\r\n-- </if>\r\n-- <if test = \"userid != null and userid!=\'\'\">\r\n-- and userid = #{userid}\r\n-- </if>\r\n-- <if test = \"operationType != null and operationType!=\'\'\">\r\n-- and operation_type = #{operationType}\r\n-- </if>\r\n \"\"\"\r\nreturn db.page(sql)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/商品管理/', 'this is directory');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/商品管理/group.json', '{\r\n \"properties\" : { },\r\n \"id\" : \"21377bcc727a43aa851207fdbef1742d\",\r\n \"name\" : \"商品管理\",\r\n \"type\" : \"api\",\r\n \"parentId\" : \"0\",\r\n \"path\" : \"commodity\",\r\n \"createTime\" : 1677741161527,\r\n \"updateTime\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"paths\" : [ ],\r\n \"options\" : [ ]\r\n}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/商品管理/修改商品.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"6e74958a64224132b2b48c413e25c0c6\",\r\n \"script\" : null,\r\n \"groupId\" : \"21377bcc727a43aa851207fdbef1742d\",\r\n \"name\" : \"修改商品\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1679234993597,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"updateCommodity\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nreturn db.table(\'commodity_management\').primary(\'commodityid\').update(body)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/商品管理/商品信息.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"c2c5ae2ba75d4058b3914bffdd809711\",\r\n \"script\" : null,\r\n \"groupId\" : \"21377bcc727a43aa851207fdbef1742d\",\r\n \"name\" : \"商品信息\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680084462868,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"commodityList\",\r\n \"method\" : \"GET\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : \"{\\n \\\"timestamp\\\": \\\"2023-03-29T10:06:00.076+00:00\\\",\\n \\\"status\\\": 404,\\n \\\"error\\\": \\\"Not Found\\\",\\n \\\"path\\\": \\\"/commodity/commodityList\\\"\\n}\",\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : {\r\n \"name\" : \"\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"timestamp\",\r\n \"value\" : \"2023-03-29T10:06:00.076+00:00\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"status\",\r\n \"value\" : \"404\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"error\",\r\n \"value\" : \"Not Found\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"path\",\r\n \"value\" : \"/commodity/commodityList\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n } ]\r\n }\r\n}\r\n================================\r\nvar sql = \"\"\"select *,convert(picture using utf8) _picture from commodity_management where (isdel is null or isdel != \'1\')\r\n<if test = \"commodityid != null and commodityid != \'\'\">\r\n and commodityid like concat(\'%\', #{commodityid}, \'%\')\r\n</if>\r\n<if test = \"name != null and name!=\'\'\">\r\n and name like concat(\'%\', #{name}, \'%\')\r\n</if>\r\n<if test = \"type != null and type!=\'\'\">\r\n and type like concat(\'%\', #{type}, \'%\')\r\n</if>\r\n\"\"\"\r\nreturn db.page(sql)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/商品管理/新增商品.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"bb60ab73a24a430d9db4aa6fcbe26254\",\r\n \"script\" : null,\r\n \"groupId\" : \"21377bcc727a43aa851207fdbef1742d\",\r\n \"name\" : \"新增商品\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1679231172341,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"addCommodity\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nbody.purchaseDate = now()\r\nreturn db.table(\'commodity_management\').insert(body)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/客户/', 'this is directory');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/客户/group.json', '{\r\n \"properties\" : { },\r\n \"id\" : \"52f6a7a87fa44efd83cb45ea8fa59a25\",\r\n \"name\" : \"客户\",\r\n \"type\" : \"api\",\r\n \"parentId\" : \"0\",\r\n \"path\" : \"billiardUser\",\r\n \"createTime\" : 1679524089401,\r\n \"updateTime\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"paths\" : [ ],\r\n \"options\" : [ ]\r\n}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/客户/修改信息.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"0fbd080bb1854d4ca006948ccd3bb4ea\",\r\n \"script\" : null,\r\n \"groupId\" : \"52f6a7a87fa44efd83cb45ea8fa59a25\",\r\n \"name\" : \"修改信息\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680815091079,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"update\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nreturn db.table(\'billiard_user\').primary(\'user_id\').update(body)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/客户/改变状态.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"fc0072ff95dd49d3b053f1088724e029\",\r\n \"script\" : null,\r\n \"groupId\" : \"52f6a7a87fa44efd83cb45ea8fa59a25\",\r\n \"name\" : \"改变状态\",\r\n \"createTime\" : 1680161746307,\r\n \"updateTime\" : null,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"changeStatus\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nvar sql = \"\"\"\r\n update billiard_user set is_del = #{body.isDel} where user_id = #{body.userId}\r\n\"\"\"\r\nreturn db.update(sql)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/客户/查询用户信息.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"8935c5e1f09d4ed5b4567aaa58be01c6\",\r\n \"script\" : null,\r\n \"groupId\" : \"52f6a7a87fa44efd83cb45ea8fa59a25\",\r\n \"name\" : \"查询用户信息\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1679547255369,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"getUserInfo\",\r\n \"method\" : \"GET\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nreturn db.table(\'billiard_user\').where().eq(\'user_id\',userId).selectOne()');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/客户/消费.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"f3fa706b94ec4cecadf673b03f55a529\",\r\n \"script\" : null,\r\n \"groupId\" : \"52f6a7a87fa44efd83cb45ea8fa59a25\",\r\n \"name\" : \"消费\",\r\n \"createTime\" : 1680808260030,\r\n \"updateTime\" : null,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"userPay\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nvar sql = \"\"\"\r\n update billiard_user set balance = #{body.balance} where user_id = #{body.userId}\r\n\"\"\"\r\nreturn db.update(sql)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/客户/用户信息列表.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"2e021cd093684f2c8a0c56e90dc9f0b3\",\r\n \"script\" : null,\r\n \"groupId\" : \"52f6a7a87fa44efd83cb45ea8fa59a25\",\r\n \"name\" : \"用户信息列表\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680268356912,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"getUserList\",\r\n \"method\" : \"GET\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nvar sql = \"\"\"\r\n select * from billiard_user where 1=1 \r\n <if test=\"nickName!=null and nickName != \'\'\">\r\n and nick_name like concat(\'%\', #{nickName}, \'%\')\r\n </if>\r\n <if test=\"sex!=null and sex != \'\'\">\r\n and sex = #{sex}\r\n </if>\r\n <if test=\"mobile!=null and mobile != \'\'\">\r\n and mobile like concat(\'%\', #{mobile}, \'%\')\r\n </if>\r\n <if test=\"isDel==\'1\'\">\r\n and is_del = #{isDel}\r\n </if>\r\n\"\"\"\r\nreturn db.page(sql)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/客户/用户充值.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"54be4b81752741168e116029e29e4b2e\",\r\n \"script\" : null,\r\n \"groupId\" : \"52f6a7a87fa44efd83cb45ea8fa59a25\",\r\n \"name\" : \"用户充值\",\r\n \"createTime\" : 1679547163260,\r\n \"updateTime\" : null,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"recharge\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nvar sql = \"\"\"\r\n update billiard_user set balance = balance + #{body.money} where user_id = #{body.userId}\r\n\"\"\"\r\nreturn db.update(sql)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/客户/用户注册.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"23ff79c6c60c4e7fb4269d0d843265e7\",\r\n \"script\" : null,\r\n \"groupId\" : \"52f6a7a87fa44efd83cb45ea8fa59a25\",\r\n \"name\" : \"用户注册\",\r\n \"createTime\" : 1679526153409,\r\n \"updateTime\" : null,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"register\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nvar user = db.table(\'billiard_user\').where().eq(\'user_id\',body.userId).selectOne()\r\nvar param = {}\r\nif (user == null){\r\n param.userId = body.userId\r\n param.avatar = body.avatar\r\n param.nickName = body.nickName\r\n param.createTime = now()\r\n param.mobile = body.mobile\r\n param.email = body.email\r\n param.age = body.age\r\n db.table(\'billiard_user\').insert(param)\r\n return param\r\n}else{\r\n return user\r\n}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/操作/', 'this is directory');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/操作/group.json', '{\r\n \"properties\" : { },\r\n \"id\" : \"88bf37917b3646aa9276c6120d9101d7\",\r\n \"name\" : \"操作\",\r\n \"type\" : \"api\",\r\n \"parentId\" : \"0\",\r\n \"path\" : \"operation\",\r\n \"createTime\" : 1676044872535,\r\n \"updateTime\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"paths\" : [ ],\r\n \"options\" : [ ]\r\n}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/操作/操作查询.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"eaa8b6b6d87142f18cfa447d8b693696\",\r\n \"script\" : null,\r\n \"groupId\" : \"88bf37917b3646aa9276c6120d9101d7\",\r\n \"name\" : \"操作查询\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680964122900,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"operationSelect\",\r\n \"method\" : \"GET\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : \"{\\n \\\"code\\\": 200,\\n \\\"message\\\": \\\"success\\\",\\n \\\"data\\\": {\\n \\\"total\\\": 37,\\n \\\"list\\\": [{\\n \\\"operationid\\\": 81,\\n \\\"operationType\\\": \\\"start\\\",\\n \\\"time\\\": \\\"2023-03-02T12:07:22\\\",\\n \\\"tableid\\\": \\\"1\\\",\\n \\\"userid\\\": 1,\\n \\\"orderid\\\": \\\"120230302120721\\\",\\n \\\"矿泉水\\\": null,\\n \\\"extend3\\\": null,\\n \\\"extend4\\\": null,\\n \\\"extend5\\\": null\\n }, {\\n \\\"operationid\\\": 82,\\n \\\"operationType\\\": \\\"pause\\\",\\n \\\"time\\\": \\\"2023-03-02T12:14:32\\\",\\n \\\"tableid\\\": \\\"1\\\",\\n \\\"userid\\\": 1,\\n \\\"orderid\\\": \\\"120230302120721\\\",\\n \\\"矿泉水\\\": null,\\n \\\"extend3\\\": null,\\n \\\"extend4\\\": null,\\n \\\"extend5\\\": null\\n }, {\\n \\\"operationid\\\": 83,\\n \\\"operationType\\\": \\\"renew\\\",\\n \\\"time\\\": \\\"2023-03-02T12:14:37\\\",\\n \\\"tableid\\\": \\\"1\\\",\\n \\\"userid\\\": 1,\\n \\\"orderid\\\": \\\"120230302120721\\\",\\n \\\"矿泉水\\\": null,\\n \\\"extend3\\\": null,\\n \\\"extend4\\\": null,\\n \\\"extend5\\\": null\\n }, {\\n \\\"operationid\\\": 84,\\n \\\"operationType\\\": \\\"pause\\\",\\n \\\"time\\\": \\\"2023-03-02T13:27:38\\\",\\n \\\"tableid\\\": \\\"1\\\",\\n \\\"userid\\\": 1,\\n \\\"orderid\\\": \\\"120230302120721\\\",\\n \\\"矿泉水\\\": null,\\n \\\"extend3\\\": null,\\n \\\"extend4\\\": null,\\n \\\"extend5\\\": null\\n }, {\\n \\\"operationid\\\": 85,\\n \\\"operationType\\\": \\\"renew\\\",\\n \\\"time\\\": \\\"2023-03-02T13:43:03\\\",\\n \\\"tableid\\\": \\\"1\\\",\\n \\\"userid\\\": 1,\\n \\\"orderid\\\": \\\"120230302120721\\\",\\n \\\"矿泉水\\\": null,\\n \\\"extend3\\\": null,\\n \\\"extend4\\\": null,\\n \\\"extend5\\\": null\\n }, {\\n \\\"operationid\\\": 86,\\n \\\"operationType\\\": \\\"pause\\\",\\n \\\"time\\\": \\\"2023-03-02T13:47:37\\\",\\n \\\"tableid\\\": \\\"1\\\",\\n \\\"userid\\\": 1,\\n \\\"orderid\\\": \\\"120230302120721\\\",\\n \\\"矿泉水\\\": null,\\n \\\"extend3\\\": null,\\n \\\"extend4\\\": null,\\n \\\"extend5\\\": null\\n }, {\\n \\\"operationid\\\": 87,\\n \\\"operationType\\\": \\\"renew\\\",\\n \\\"time\\\": \\\"2023-03-02T13:51:38\\\",\\n \\\"tableid\\\": \\\"1\\\",\\n \\\"userid\\\": 1,\\n \\\"orderid\\\": \\\"120230302120721\\\",\\n \\\"矿泉水\\\": null,\\n \\\"extend3\\\": null,\\n \\\"extend4\\\": null,\\n \\\"extend5\\\": null\\n }, {\\n \\\"operationid\\\": 88,\\n \\\"operationType\\\": \\\"pause\\\",\\n \\\"time\\\": \\\"2023-03-02T13:52:10\\\",\\n \\\"tableid\\\": \\\"1\\\",\\n \\\"userid\\\": 1,\\n \\\"orderid\\\": \\\"120230302120721\\\",\\n \\\"矿泉水\\\": null,\\n \\\"extend3\\\": null,\\n \\\"extend4\\\": null,\\n \\\"extend5\\\": null\\n }, {\\n \\\"operationid\\\": 89,\\n \\\"operationType\\\": \\\"renew\\\",\\n \\\"time\\\": \\\"2023-03-02T13:52:30\\\",\\n \\\"tableid\\\": \\\"1\\\",\\n \\\"userid\\\": 1,\\n \\\"orderid\\\": \\\"120230302120721\\\",\\n \\\"矿泉水\\\": null,\\n \\\"extend3\\\": null,\\n \\\"extend4\\\": null,\\n \\\"extend5\\\": null\\n }, {\\n \\\"operationid\\\": 90,\\n \\\"operationType\\\": \\\"pause\\\",\\n \\\"time\\\": \\\"2023-03-02T14:02:00\\\",\\n \\\"tableid\\\": \\\"1\\\",\\n \\\"userid\\\": 1,\\n \\\"orderid\\\": \\\"120230302120721\\\",\\n \\\"矿泉水\\\": null,\\n \\\"extend3\\\": null,\\n \\\"extend4\\\": null,\\n \\\"extend5\\\": null\\n }]\\n },\\n \\\"timestamp\\\": 1679366957698,\\n \\\"executeTime\\\": 227\\n}\",\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : {\r\n \"name\" : \"\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"code\",\r\n \"value\" : \"200\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"message\",\r\n \"value\" : \"success\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"data\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"total\",\r\n \"value\" : \"37\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"list\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Array\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"operationid\",\r\n \"value\" : \"81\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"operationType\",\r\n \"value\" : \"start\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"time\",\r\n \"value\" : \"2023-03-02T12:07:22\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"tableid\",\r\n \"value\" : \"1\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"userid\",\r\n \"value\" : \"1\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"orderid\",\r\n \"value\" : \"120230302120721\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"矿泉水\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"extend3\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"extend4\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"extend5\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n } ]\r\n } ]\r\n } ]\r\n }, {\r\n \"name\" : \"timestamp\",\r\n \"value\" : \"1679366957698\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Long\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"executeTime\",\r\n \"value\" : \"227\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n } ]\r\n }\r\n}\r\n================================\r\nvar sql = \"\"\" \r\nselect * from operation where 1=1 \r\n<if test = \"orderid != null and orderid != \'\'\">\r\n and orderid like concat(\'%\', #{orderid}, \'%\')\r\n</if>\r\n<if test = \"time != null and time!=\'\'\">\r\n and time = #{time}\r\n</if>\r\n<if test = \"operationid != null and operationid!=\'\'\">\r\n and operationid = #{operationid}\r\n</if>\r\n<if test = \"tableid != null and tableid!=\'\'\">\r\n and tableid = #{tableid}\r\n</if>\r\n<if test = \"userid != null and userid!=\'\'\">\r\n and userid = #{userid}\r\n</if>\r\n<if test = \"operationType != null and operationType!=\'\'\">\r\n and operation_type = #{operationType}\r\n</if>\r\n \"\"\"\r\nreturn db.page(sql)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/操作/新增操作.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"16d95f77d4104eceb5f5c8c5a21b8f4f\",\r\n \"script\" : null,\r\n \"groupId\" : \"88bf37917b3646aa9276c6120d9101d7\",\r\n \"name\" : \"新增操作\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680964143200,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"insert\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nimport java.text.SimpleDateFormat;\r\nimport redis;\r\n\r\nbody.time = now()\r\n\r\nif (body.operationType == \"start\") {\r\n body.orderid = body.tableid + new SimpleDateFormat(\'yyyyMMddHHmmss\').format(body.time)\r\n redis.set(body.tableid, body.orderid)\r\n} else if (body.operation && body.operation.operationType == \"unrecharge\") {\r\n var sql = \"\"\"\r\n update billiard_user set balance = balance - #{body.money} where user_id = #{body.billiardUserId}\r\n \"\"\"\r\n db.update(sql)\r\n body = body.operation\r\n body.time = now()\r\n body.orderid = redis.get(body.tableid)\r\n} else {\r\n body.orderid = redis.get(body.tableid)\r\n}\r\nreturn db.table(\'operation\').insert(body);');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/操作/预约.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"6295c2563fb448be96a692d8bac3309a\",\r\n \"script\" : null,\r\n \"groupId\" : \"88bf37917b3646aa9276c6120d9101d7\",\r\n \"name\" : \"预约\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680815596034,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"appointment\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nimport java.text.SimpleDateFormat;\r\nvar sql = \"\"\" \r\nselect * from operation where 1=1 and operation_type = \'appointment\' and tableid = #{body.tableid}\r\nand (start_time between #{body.startTime} and #{body.endTime} \r\nor end_time between #{body.startTime} and #{body.endTime})\r\n \"\"\"\r\nvar appoint = db.selectOne(sql)\r\nif (appoint != null){\r\n exit 500,\'该时间段内球桌已被预订\'\r\n}\r\nbody.operationType = \'appointment\'\r\nbody.time = now()\r\nbody.orderid = \'apm\' + body.tableid + new SimpleDateFormat(\'yyyyMMddHHmmss\').format(new SimpleDateFormat(\'yyyy-MM-dd HH:mm:ss\').parse(body.startTime))\r\nbody.status = \'未开始\'\r\n\r\nreturn db.table(\'operation\').insert(body);');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/文件/', 'this is directory');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/文件/group.json', '{\r\n \"properties\" : { },\r\n \"id\" : \"127147d01e1a41a3b7265cf85934ac2d\",\r\n \"name\" : \"文件\",\r\n \"type\" : \"api\",\r\n \"parentId\" : \"0\",\r\n \"path\" : \"file\",\r\n \"createTime\" : 1678699230161,\r\n \"updateTime\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"paths\" : [ ],\r\n \"options\" : [ ]\r\n}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/文件/上传图片.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"861a549b1dcd4e16b1e3fa03c472b0b5\",\r\n \"script\" : null,\r\n \"groupId\" : \"127147d01e1a41a3b7265cf85934ac2d\",\r\n \"name\" : \"上传图片\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680084291153,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"uploadImg\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\n// import cn.hutool.core.io.FileUtil;\r\nimport java.io.File;\r\nimport request\r\n\r\nvar multipartFile = request.getFile(\'file\')\r\nvar f = new File(\'./img\')\r\nif (!f.exists()){\r\n f.mkdirs()\r\n}\r\nvar fileName = multipartFile.getOriginalFilename()\r\nvar path = f.getCanonicalPath() + \'/\' + fileName\r\nvar file = new File(path)\r\nwhile(file.exists()){\r\n fileName = \'_\' + fileName\r\n path = f.getCanonicalPath() + \'/\' + fileName\r\n file = new File(path)\r\n}\r\n\r\nmultipartFile.transferTo(new File(path))\r\nreturn {fileName}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/文件/文件下载.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"f9363de601204580a9008adba815f15c\",\r\n \"script\" : null,\r\n \"groupId\" : \"127147d01e1a41a3b7265cf85934ac2d\",\r\n \"name\" : \"文件下载\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680084611351,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"downloadImg\",\r\n \"method\" : \"GET\",\r\n \"parameters\" : [ {\r\n \"name\" : \"name\",\r\n \"value\" : \"微信图片_20230329152438-removebg-preview.png\",\r\n \"description\" : null,\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : null,\r\n \"error\" : null,\r\n \"expression\" : null,\r\n \"children\" : null\r\n } ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nimport java.io.File;\r\nimport java.io.FileInputStream;\r\nimport response;\r\nvar file = new File(\'./img/\' + name)\r\nvar fileType = name.substring(name.lastIndexOf(\'.\')+1)\r\nprintln(fileType)\r\nvar fis = new FileInputStream(file);\r\nvar fileBytes = new_byte_array(file.length()::int(0));\r\nfis.read(fileBytes);\r\n// response.setHeader(\"content-type\", \"application/octet-stream;charset=ISO8859-1\");\r\n// response.setContentType(\"application/octet-stream;charset=ISO8859-1\");\r\n// response.setHeader(\"Content-disposition\", String.format(\"attachment;filename=\\\"%s\\\"\", fileName));\r\n// response.setHeader(\"Content-Length\", String.valueOf(file.length()));\r\nreturn response.image(fileBytes,\'image/\'+fileType);\r\n');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/球桌管理/', 'this is directory');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/球桌管理/group.json', '{\r\n \"properties\" : { },\r\n \"id\" : \"fe7dcaf5fedd4dfcb72c0c1d83061cf5\",\r\n \"name\" : \"球桌管理\",\r\n \"type\" : \"api\",\r\n \"parentId\" : \"0\",\r\n \"path\" : \"table\",\r\n \"createTime\" : 1675929242431,\r\n \"updateTime\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"paths\" : [ ],\r\n \"options\" : [ ]\r\n}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/球桌管理/单个球桌信息.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"ee5213e5fbd34ccda91e0bd30c3bc658\",\r\n \"script\" : null,\r\n \"groupId\" : \"fe7dcaf5fedd4dfcb72c0c1d83061cf5\",\r\n \"name\" : \"单个球桌信息\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680257123630,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"getById\",\r\n \"method\" : \"GET\",\r\n \"parameters\" : [ {\r\n \"name\" : \"tableid\",\r\n \"value\" : \"1\",\r\n \"description\" : null,\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : null,\r\n \"error\" : null,\r\n \"expression\" : null,\r\n \"children\" : null\r\n } ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : \"{\\n \\\"code\\\": 200,\\n \\\"message\\\": \\\"success\\\",\\n \\\"data\\\": {\\n \\\"tableOperation\\\": [{\\n \\\"operationType\\\": \\\"pause\\\",\\n \\\"time\\\": \\\"2023-03-31T17:36:33\\\",\\n \\\"userid\\\": 1\\n }, {\\n \\\"operationType\\\": \\\"start\\\",\\n \\\"time\\\": \\\"2023-03-31T17:36:29\\\",\\n \\\"userid\\\": 1\\n }],\\n \\\"shopOperation\\\": [],\\n \\\"table\\\": {\\n \\\"tableid\\\": 1,\\n \\\"tableName\\\": \\\"球桌1\\\",\\n \\\"picture\\\": \\\"http://192.168.1.8/file/downloadImg?name=银腿.png\\\",\\n \\\"tableType\\\": \\\"乔氏银腿\\\",\\n \\\"price\\\": 20,\\n \\\"status\\\": \\\"2\\\",\\n \\\"isdel\\\": null,\\n \\\"extend2\\\": null,\\n \\\"extend3\\\": null,\\n \\\"extend4\\\": null,\\n \\\"extend5\\\": null\\n },\\n \\\"shopInfo\\\": {\\n \\\"shopCharge\\\": null,\\n \\\"shopList\\\": []\\n },\\n \\\"tableInfo\\\": {\\n \\\"charge\\\": 9334754.0,\\n \\\"duration\\\": 2.800426E7,\\n \\\"startTime\\\": \\\"17:36:29\\\"\\n }\\n },\\n \\\"timestamp\\\": 1680255571375,\\n \\\"executeTime\\\": 15\\n}\",\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nimport \"@get:/account/getAllCharge\" as getAllCharge;\r\nimport redis\r\nvar sql = \"\"\" \r\n select * from table_management where 1=1 and tableid = #{tableid}\r\n \"\"\"\r\nvar table = db.selectOne(sql)\r\n\r\nvar orderid = redis.get(tableid)\r\nsql = \"\"\"\r\n select operation_type,time,userid from operation where orderid = #{orderid} order by time desc\r\n\"\"\"\r\nvar tableOperation = db.select(sql)\r\n\r\nsql = \"\"\"\r\n select time,name,change_number from shop_operation where orderid = #{orderid} and operation_type = \'shopping\' order by time desc\r\n\"\"\"\r\nvar shopOperation = db.select(sql)\r\nvar chargeInfo = getAllCharge({tableid})\r\nreturn {tableOperation,shopOperation,table,...chargeInfo}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/球桌管理/新增球桌.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"4fe1566830c14559be5df50936fa20af\",\r\n \"script\" : null,\r\n \"groupId\" : \"fe7dcaf5fedd4dfcb72c0c1d83061cf5\",\r\n \"name\" : \"新增球桌\",\r\n \"createTime\" : 1679041306743,\r\n \"updateTime\" : null,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"insert\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nreturn db.table(\'table_management\').insert(body)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/球桌管理/更新状态.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"8ad449b55e744ee9a2acd812783c4b7d\",\r\n \"script\" : null,\r\n \"groupId\" : \"fe7dcaf5fedd4dfcb72c0c1d83061cf5\",\r\n \"name\" : \"更新状态\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1676568553851,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"upStatus\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nreturn db.table(\'table_management\').primary(\'tableid\').update(body)\r\n\r\n');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/球桌管理/球桌信息.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"9ea275dfb16a4233908f08de4099c7e5\",\r\n \"script\" : null,\r\n \"groupId\" : \"fe7dcaf5fedd4dfcb72c0c1d83061cf5\",\r\n \"name\" : \"球桌信息\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680807893747,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"tableList\",\r\n \"method\" : \"GET\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nvar sql = \"\"\" \r\nselect * from table_management where 1=1 \r\n<if test = \"tableName != null and tableName != \'\'\">\r\n and table_name like concat(\'%\', #{tableName}, \'%\')\r\n</if>\r\n<if test = \"tableid != null and tableid != \'\'\">\r\n and tableid = #{tableid}\r\n</if>\r\n<if test = \"status != null and status!=\'\'\">\r\n and status = #{status}\r\n</if>\r\n \"\"\"\r\nreturn db.page(sql)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/用户/', 'this is directory');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/用户/group.json', '{\r\n \"properties\" : { },\r\n \"id\" : \"00db175cdfb04c8aa8febdfc4a05fe56\",\r\n \"name\" : \"用户\",\r\n \"type\" : \"api\",\r\n \"parentId\" : \"0\",\r\n \"path\" : \"user\",\r\n \"createTime\" : 1672242792167,\r\n \"updateTime\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"paths\" : [ ],\r\n \"options\" : [ ]\r\n}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/用户/修改用户信息.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"dbffee3a65ef44e0bccc4080f8d6dee5\",\r\n \"script\" : null,\r\n \"groupId\" : \"00db175cdfb04c8aa8febdfc4a05fe56\",\r\n \"name\" : \"修改用户信息\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680157428690,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"update\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\ndb.table(\"user_info\").primary(\"userid\").update(body.param)\r\nvar sql = \"\"\"\r\n delete from role_user where userid = #{body.param.userid}\r\n\"\"\"\r\ndb.update(sql)\r\nvar insertSql = \"\"\"\r\n insert ignore into role_user(userid,roleid) values \r\n <foreach item=\'item\' index=\'index\' collection=\'body.roleids\' separator=\",\">\r\n (#{body.param.userid},#{item})\r\n </foreach>\r\n\"\"\"\r\n// for (item in body.roleids) {\r\n// sql += \"\"\"\r\n// ((#{body.param.userid},#{item})\r\n// \"\"\"\r\n// }\r\ndb.insert(insertSql)\r\nexit 200, \'修改成功\';');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/用户/删除用户.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"9c8ae6288a084e20a9a404ef6e2e3378\",\r\n \"script\" : null,\r\n \"groupId\" : \"00db175cdfb04c8aa8febdfc4a05fe56\",\r\n \"name\" : \"删除用户\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680158409597,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"delete\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\n\r\nvar sql = \"\"\"\r\nupdate user_info set isdel = \'1\' where `userid` in \r\n<foreach item=\'item\' index=\'index\' collection=\'body.userid\'\r\n open=\"(\" separator=\",\" close=\")\">\r\n #{item}\r\n</foreach>\r\n\"\"\"\r\nreturn db.update(sql)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/用户/启用用户.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"ebee30ffa4b04374b55dc252370c9f54\",\r\n \"script\" : null,\r\n \"groupId\" : \"00db175cdfb04c8aa8febdfc4a05fe56\",\r\n \"name\" : \"启用用户\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680158405628,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"reStart\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\n\r\nvar sql = \"\"\"\r\nupdate user_info set isdel = \'0\' where `userid` in \r\n<foreach item=\'item\' index=\'index\' collection=\'body.userid\'\r\n open=\"(\" separator=\",\" close=\")\">\r\n #{item}\r\n</foreach>\r\n\"\"\"\r\nreturn db.update(sql)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/用户/新增用户.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"057bde4cac134f76908a24c51ae7edfb\",\r\n \"script\" : null,\r\n \"groupId\" : \"00db175cdfb04c8aa8febdfc4a05fe56\",\r\n \"name\" : \"新增用户\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680964523891,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"insert\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\ndb.table(\"user_info\").primary(\"userid\").insert(body.param)\r\n// var sql = \"\"\"\r\n// delete from role_user where userid = #{body.param.userid}\r\n// \"\"\"\r\n// db.update(sql)\r\n// println(body)\r\nvar insertSql = \"\"\"\r\n insert ignore into role_user(userid,roleid) values \r\n <foreach item=\'item\' index=\'index\' collection=\'body.roleids\' separator=\",\">\r\n (#{body.param.userid},#{item})\r\n </foreach>\r\n\"\"\"\r\n// for (item in body.roleids) {\r\n// sql += \"\"\"\r\n// ((#{body.param.userid},#{item})\r\n// \"\"\"\r\n// }\r\ndb.insert(insertSql)\r\nexit 200, \'新增成功\';');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/用户/查询用户列表.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"8d7efe9a65744cc796977697c3407fef\",\r\n \"script\" : null,\r\n \"groupId\" : \"00db175cdfb04c8aa8febdfc4a05fe56\",\r\n \"name\" : \"查询用户列表\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680153726587,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"list\",\r\n \"method\" : \"GET\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nvar sql = \"\"\" \r\nselect\r\n u.* ,\r\n (\r\n select\r\n GROUP_CONCAT(r.role_name separator \',\')\r\n from\r\n role_info r\r\n where\r\n r.roleid in (\r\n select\r\n roleid\r\n from\r\n role_user ru\r\n where\r\n ru.userid = u.userid) ) as role,\r\n (\r\n select\r\n GROUP_CONCAT(ru.roleid separator \',\')\r\n from\r\n role_user ru\r\n where\r\n ru.userid = u.userid ) as roleids\r\nfrom\r\n user_info u\r\nwhere 1=1 \r\n<if test = \"userName != null and userName != \'\'\">\r\n and u.user_name like concat(\'%\', #{userName}, \'%\')\r\n</if>\r\n<if test = \"sex != null and sex != \'\'\">\r\n and u.sex like concat(\'%\', #{sex}, \'%\')\r\n</if>\r\n<if test = \"isDel == 1\">\r\n and u.isdel = #{isDel}\r\n</if>\r\n \"\"\"\r\nreturn db.page(sql)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/角色管理/', 'this is directory');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/角色管理/group.json', '{\r\n \"properties\" : { },\r\n \"id\" : \"d3c56be70b5a470185ee18a2a77cacc7\",\r\n \"name\" : \"角色管理\",\r\n \"type\" : \"api\",\r\n \"parentId\" : \"0\",\r\n \"path\" : \"roleManagement\",\r\n \"createTime\" : 1678321965836,\r\n \"updateTime\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"paths\" : [ ],\r\n \"options\" : [ ]\r\n}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/角色管理/删.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"2496f9d11b26413188d63f5e9794cbcb\",\r\n \"script\" : null,\r\n \"groupId\" : \"d3c56be70b5a470185ee18a2a77cacc7\",\r\n \"name\" : \"删\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1678330758929,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"delete\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"{\\r\\n \\\"roleid\\\":2\\r\\n}\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : \"{\\n \\\"code\\\": 200,\\n \\\"message\\\": \\\"success\\\",\\n \\\"data\\\": 0,\\n \\\"timestamp\\\": 1678327782769,\\n \\\"executeTime\\\": 2\\n}\",\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : {\r\n \"name\" : \"\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"roleid\",\r\n \"value\" : \"2\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n } ]\r\n },\r\n \"responseBodyDefinition\" : {\r\n \"name\" : \"\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"code\",\r\n \"value\" : \"200\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"message\",\r\n \"value\" : \"success\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"data\",\r\n \"value\" : \"0\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"timestamp\",\r\n \"value\" : \"1678327782769\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Long\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"executeTime\",\r\n \"value\" : \"2\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n } ]\r\n }\r\n}\r\n================================\r\n\r\nvar sql = \"\"\"\r\nupdate role_info set isdel = \'1\' where `roleid` = #{body.roleid}\"\"\"\r\nreturn db.update(sql)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/角色管理/增.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"fd9a3b6c44e04e648e89a8ce14cd08db\",\r\n \"script\" : null,\r\n \"groupId\" : \"d3c56be70b5a470185ee18a2a77cacc7\",\r\n \"name\" : \"增\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680964247263,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"insert\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"{\\r\\n \\\"visibleTable\\\": \\\"[\\\\\\\"home\\\\\\\",\\\\\\\"commodityManagement\\\\\\\"]\\\",\\r\\n \\\"roleName\\\": \\\"朱子元\\\"\\r\\n}\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : \"{\\n \\\"code\\\": 200,\\n \\\"message\\\": \\\"success\\\",\\n \\\"data\\\": null,\\n \\\"timestamp\\\": 1678335524009,\\n \\\"executeTime\\\": 3\\n}\",\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : {\r\n \"name\" : \"\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"visibleTable\",\r\n \"value\" : \"[\\\\\\\"home\\\\\\\",\\\\\\\"commodityManagement\\\\\\\"]\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"roleName\",\r\n \"value\" : \"朱子元\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n } ]\r\n },\r\n \"responseBodyDefinition\" : {\r\n \"name\" : \"\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"code\",\r\n \"value\" : \"200\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"message\",\r\n \"value\" : \"success\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"data\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"timestamp\",\r\n \"value\" : \"1678335524009\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Long\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"executeTime\",\r\n \"value\" : \"3\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n } ]\r\n }\r\n}\r\n================================\r\nimport java.text.SimpleDateFormat\r\n\r\nbody.createTime = now()\r\nreturn db.table(\'role_info\').insert(body)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/角色管理/改.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"copy1678330967724d65180\",\r\n \"script\" : null,\r\n \"groupId\" : \"d3c56be70b5a470185ee18a2a77cacc7\",\r\n \"name\" : \"改\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680155597368,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"update\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"{\\r\\n \\\"roleid\\\": 1,\\r\\n \\\"roleName\\\": \\\"管理员\\\",\\r\\n \\\"createTime\\\": null,\\r\\n \\\"creator\\\": null,\\r\\n \\\"visibleTable\\\": \\\"[\\\\\\\"announce\\\\\\\",\\\\\\\"home\\\\\\\",\\\\\\\"commodityManagement\\\\\\\",\\\\\\\"messageBoard\\\\\\\",\\\\\\\"roleManagement\\\\\\\",\\\\\\\"userManagement\\\\\\\",\\\\\\\"tableInfo\\\\\\\"]\\\",\\r\\n \\\"isdel\\\": null,\\r\\n \\\"extend3\\\": null,\\r\\n \\\"extend4\\\": null,\\r\\n \\\"extend5\\\": null\\r\\n}\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : \"{\\n \\\"code\\\": 500,\\n \\\"message\\\": \\\"系统内部出现错误\\\",\\n \\\"data\\\": null,\\n \\\"timestamp\\\": 1678331386467,\\n \\\"executeTime\\\": 10\\n}\",\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : {\r\n \"name\" : \"\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"roleid\",\r\n \"value\" : \"1\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"roleName\",\r\n \"value\" : \"管理员\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"createTime\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"creator\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"visibleTable\",\r\n \"value\" : \"[\\\\\\\"announce\\\\\\\",\\\\\\\"home\\\\\\\",\\\\\\\"commodityManagement\\\\\\\",\\\\\\\"messageBoard\\\\\\\",\\\\\\\"roleManagement\\\\\\\",\\\\\\\"userManagement\\\\\\\",\\\\\\\"tableInfo\\\\\\\"]\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"isdel\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"extend3\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"extend4\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"extend5\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n } ]\r\n },\r\n \"responseBodyDefinition\" : {\r\n \"name\" : \"\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"code\",\r\n \"value\" : \"500\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"message\",\r\n \"value\" : \"系统内部出现错误\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"data\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"timestamp\",\r\n \"value\" : \"1678331386467\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Long\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"executeTime\",\r\n \"value\" : \"10\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n } ]\r\n }\r\n}\r\n================================\r\nreturn db.table(\"role_info\").primary(\"roleid\").update(body)\r\n');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/角色管理/查.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"0d421cfaa603495fb08291abc2338760\",\r\n \"script\" : null,\r\n \"groupId\" : \"d3c56be70b5a470185ee18a2a77cacc7\",\r\n \"name\" : \"查\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1678322200437,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"getRoleList\",\r\n \"method\" : \"GET\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : null,\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : null\r\n}\r\n================================\r\nvar sql=\"\"\"select * from role_info\"\"\"\r\nreturn db.page(sql)\r\n');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/角色管理/查询可见页面.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"b27dff3fbac34e469830fadacd9573cb\",\r\n \"script\" : null,\r\n \"groupId\" : \"d3c56be70b5a470185ee18a2a77cacc7\",\r\n \"name\" : \"查询可见页面\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680964225384,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"getVisibleTable\",\r\n \"method\" : \"POST\",\r\n \"parameters\" : [ ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"{\\\"role\\\":[\\\"员工\\\",\\\"管理员\\\"]}\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : \"{\\n \\\"code\\\": 500,\\n \\\"message\\\": \\\"系统内部出现错误\\\",\\n \\\"data\\\": null,\\n \\\"timestamp\\\": 1678343380196,\\n \\\"executeTime\\\": 9\\n}\",\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : {\r\n \"name\" : \"root\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"role\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Array\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"\",\r\n \"value\" : \"员工\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n } ]\r\n } ]\r\n },\r\n \"responseBodyDefinition\" : {\r\n \"name\" : \"\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"code\",\r\n \"value\" : \"500\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"message\",\r\n \"value\" : \"系统内部出现错误\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"data\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Array\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"timestamp\",\r\n \"value\" : \"1678343380196\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Long\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"executeTime\",\r\n \"value\" : \"9\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n } ]\r\n }\r\n}\r\n================================\r\nvar sql = \"\"\"\r\nselect visible_table from role_info where role_name in \r\n<foreach item=\'item\' index=\'index\' collection=\'body.role\'\r\n open=\"(\" separator=\",\" close=\")\">\r\n #{item}\r\n</foreach>\r\n and (isdel != \'1\' or isdel is null)\r\n\"\"\"\r\n\r\nreturn db.select(sql)');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/账单/', 'this is directory');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/账单/group.json', '{\r\n \"properties\" : { },\r\n \"id\" : \"8315bed1b74a47aaaf1b49835a59d51f\",\r\n \"name\" : \"账单\",\r\n \"type\" : \"api\",\r\n \"parentId\" : \"0\",\r\n \"path\" : \"account\",\r\n \"createTime\" : 1676561251343,\r\n \"updateTime\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"paths\" : [ ],\r\n \"options\" : [ ]\r\n}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/账单/合计消费信息.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"750855d702bf46b888cecd330ecf3643\",\r\n \"script\" : null,\r\n \"groupId\" : \"8315bed1b74a47aaaf1b49835a59d51f\",\r\n \"name\" : \"合计消费信息\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1678555237866,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"getAllCharge\",\r\n \"method\" : \"GET\",\r\n \"parameters\" : [ {\r\n \"name\" : \"tableid\",\r\n \"value\" : \"7\",\r\n \"description\" : null,\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : null,\r\n \"error\" : null,\r\n \"expression\" : null,\r\n \"children\" : null\r\n } ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : \"{\\n \\\"code\\\": 500,\\n \\\"message\\\": \\\"系统内部出现错误\\\",\\n \\\"data\\\": null,\\n \\\"timestamp\\\": 1678555108539,\\n \\\"executeTime\\\": 22\\n}\",\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : {\r\n \"name\" : \"\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"code\",\r\n \"value\" : \"500\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"message\",\r\n \"value\" : \"系统内部出现错误\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"data\",\r\n \"value\" : \"null\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"timestamp\",\r\n \"value\" : \"1678555108539\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Long\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"executeTime\",\r\n \"value\" : \"22\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n } ]\r\n }\r\n}\r\n================================\r\nimport \"@get:/account/getCharge\" as getTableCharge;\r\nimport \"@get:/shop/commodityMoney\" as getShopCharge;\r\nvar shopInfo = getShopCharge({tableid})\r\nvar tableInfo = getTableCharge({tableid})\r\nreturn {shopInfo,tableInfo}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/api/账单/球桌计费信息.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"50860f6be7054627a82e4909552a06e1\",\r\n \"script\" : null,\r\n \"groupId\" : \"8315bed1b74a47aaaf1b49835a59d51f\",\r\n \"name\" : \"球桌计费信息\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680258040739,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"getCharge\",\r\n \"method\" : \"GET\",\r\n \"parameters\" : [ {\r\n \"name\" : \"tableid\",\r\n \"value\" : \"1\",\r\n \"description\" : null,\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : null,\r\n \"error\" : null,\r\n \"expression\" : null,\r\n \"children\" : null\r\n } ],\r\n \"options\" : [ ],\r\n \"requestBody\" : \"\",\r\n \"headers\" : [ ],\r\n \"paths\" : [ ],\r\n \"responseBody\" : \"{\\n \\\"code\\\": 200,\\n \\\"message\\\": \\\"success\\\",\\n \\\"data\\\": {\\n \\\"charge\\\": 1.0,\\n \\\"duration\\\": 1.0,\\n \\\"startTime\\\": \\\"17:36:29\\\"\\n },\\n \\\"timestamp\\\": 1680258040121,\\n \\\"executeTime\\\": 6\\n}\",\r\n \"description\" : null,\r\n \"requestBodyDefinition\" : null,\r\n \"responseBodyDefinition\" : {\r\n \"name\" : \"\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"code\",\r\n \"value\" : \"200\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"message\",\r\n \"value\" : \"success\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"data\",\r\n \"value\" : \"\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Object\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ {\r\n \"name\" : \"charge\",\r\n \"value\" : \"1.0\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Double\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"duration\",\r\n \"value\" : \"1.0\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Double\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"startTime\",\r\n \"value\" : \"17:36:29\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"String\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n } ]\r\n }, {\r\n \"name\" : \"timestamp\",\r\n \"value\" : \"1680258040121\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Long\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n }, {\r\n \"name\" : \"executeTime\",\r\n \"value\" : \"6\",\r\n \"description\" : \"\",\r\n \"required\" : false,\r\n \"dataType\" : \"Integer\",\r\n \"type\" : null,\r\n \"defaultValue\" : null,\r\n \"validateType\" : \"\",\r\n \"error\" : \"\",\r\n \"expression\" : \"\",\r\n \"children\" : [ ]\r\n } ]\r\n }\r\n}\r\n================================\r\nimport java.text.SimpleDateFormat;\r\nimport redis\r\nimport java.time.ZoneId;\r\nimport java.util.Date\r\n\r\nvar orderid = redis.get(tableid)\r\nvar startTime\r\nvar table = db.table(\'table_management\').where().eq(\'tableid\',tableid).selectOne()\r\nvar duration = table.status==\'2\'?0::long:now().getTime()\r\n\r\nvar sql = \"\"\"\r\n select * from operation where orderid = #{orderid}\r\n\"\"\"\r\nvar list = db.select(sql)\r\nfor (item in list) {\r\n if(item.operationType==\"start\"){\r\n startTime = item.time\r\n duration -= Date.from(item.time.atZone(ZoneId.systemDefault()).toInstant()).getTime()\r\n }else if(item.operationType==\"pause\"){\r\n duration += Date.from(item.time.atZone(ZoneId.systemDefault()).toInstant()).getTime()\r\n }else if(item.operationType==\"renew\"){\r\n duration -= Date.from(item.time.atZone(ZoneId.systemDefault()).toInstant()).getTime()\r\n }\r\n}\r\n\r\nvar price = db.selectValue(\"\"\"select price from table_management where tableid = #{tableid}\"\"\")\r\nvar num = duration * price::float / 3600000.0\r\nvar result = {}\r\nresult.charge = ceil(num)\r\nresult.duration = ceil(duration / 60000.0)\r\nresult.startTime = startTime.toLocalTime()\r\nreturn result');
INSERT INTO `magic_api_file` VALUES ('/magic-api/datasource/', 'this is directory');
INSERT INTO `magic_api_file` VALUES ('/magic-api/function/', 'this is directory');
INSERT INTO `magic_api_file` VALUES ('/magic-api/task/', 'this is directory');
INSERT INTO `magic_api_file` VALUES ('/magic-api/task/定时/', 'this is directory');
INSERT INTO `magic_api_file` VALUES ('/magic-api/task/定时/group.json', '{\r\n \"properties\" : { },\r\n \"id\" : \"9543648a1ae84f2e841bdf0a61275f30\",\r\n \"name\" : \"定时\",\r\n \"type\" : \"task\",\r\n \"parentId\" : \"0\",\r\n \"path\" : \"task\",\r\n \"createTime\" : 1679731895519,\r\n \"updateTime\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"paths\" : [ ],\r\n \"options\" : [ ]\r\n}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/task/定时/预约开始.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"397ab455bdf24119b424f6e2b227afef\",\r\n \"script\" : null,\r\n \"groupId\" : \"9543648a1ae84f2e841bdf0a61275f30\",\r\n \"name\" : \"预约开始\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680809377072,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"appointmentBegin\",\r\n \"cron\" : \"* * * * * *\",\r\n \"enabled\" : true,\r\n \"description\" : \"\"\r\n}\r\n================================\r\nimport redis\r\nvar nowTime = now()\r\nvar sql = \"\"\"\r\nselect * from operation where operation_type = \'appointment\' and status = \'未开始\' and start_time <= #{nowTime}\r\n\"\"\"\r\nvar waitList = db.select(sql)\r\nif (waitList.size()>0){\r\n for(i in waitList){\r\n db.table(\'table_management\').primary(\'tableid\').update({tableid:i.tableid,status: \'1\'})\r\n db.table(\'operation\').primary(\'operationid\').update({operationid:i.operationid,status: \'进行中\'})\r\n redis.set(i.tableid,i.orderid)\r\n }\r\n}');
INSERT INTO `magic_api_file` VALUES ('/magic-api/task/定时/预约结束.ms', '{\r\n \"properties\" : { },\r\n \"id\" : \"copy1680114095637d33590\",\r\n \"script\" : null,\r\n \"groupId\" : \"9543648a1ae84f2e841bdf0a61275f30\",\r\n \"name\" : \"预约结束\",\r\n \"createTime\" : null,\r\n \"updateTime\" : 1680809375413,\r\n \"lock\" : null,\r\n \"createBy\" : null,\r\n \"updateBy\" : null,\r\n \"path\" : \"appointmentEnd\",\r\n \"cron\" : \"* * * * * *\",\r\n \"enabled\" : true,\r\n \"description\" : \"\"\r\n}\r\n================================\r\nvar nowTime = now()\r\nvar sql = \"\"\"\r\nselect * from operation where operation_type = \'appointment\' and status = \'进行中\' and end_time <= #{nowTime}\r\n\"\"\"\r\nvar waitList = db.select(sql)\r\nif (waitList.size()>0){\r\n for(i in waitList){\r\n db.table(\'table_management\').primary(\'tableid\').update({tableid:i.tableid,status: \'0\'})\r\n db.table(\'operation\').primary(\'operationid\').update({operationid:i.operationid,status: \'已完成\'})\r\n }\r\n}');
-- ----------------------------
-- Table structure for operation
-- ----------------------------
DROP TABLE IF EXISTS `operation`;
CREATE TABLE `operation` (
`operationid` bigint NOT NULL AUTO_INCREMENT,
`operation_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作类型',
`time` datetime(0) NULL DEFAULT NULL,
`tableid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`userid` bigint NULL DEFAULT NULL,
`orderid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '关联订单号',
`start_time` datetime(0) NULL DEFAULT NULL,
`end_time` datetime(0) NULL DEFAULT NULL,
`status` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`extend5` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
PRIMARY KEY (`operationid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 190 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of operation
-- ----------------------------
INSERT INTO `operation` VALUES (124, 'checkOut', '2023-03-31 17:33:38', '1', 1, '120230323132953', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (125, 'start', '2023-03-31 17:36:29', '1', 1, '120230331173628', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (126, 'pause', '2023-03-31 17:36:33', '1', 1, '120230331173628', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (127, 'renew', '2023-03-31 18:20:35', '1', 1, '120230331173628', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (128, 'pause', '2023-03-31 18:21:02', '1', 1, '120230331173628', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (129, 'renew', '2023-03-31 18:21:13', '1', 1, '120230331173628', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (130, 'pause', '2023-03-31 18:31:41', '1', 1, '120230331173628', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (131, 'renew', '2023-03-31 18:33:45', '1', 1, '120230331173628', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (132, 'pause', '2023-03-31 18:34:10', '1', 1, '120230331173628', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (133, 'renew', '2023-03-31 18:40:40', '1', 1, '120230331173628', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (134, 'pause', '2023-03-31 18:40:57', '1', 1, '120230331173628', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (135, 'renew', '2023-03-31 18:41:03', '1', 1, '120230331173628', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (136, 'pause', '2023-03-31 18:45:16', '1', 1, '120230331173628', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (137, 'checkOut', '2023-03-31 18:45:33', '1', 1, '120230331173628', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (138, 'start', '2023-03-31 18:59:05', '2', 1, '220230331185904', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (139, 'pause', '2023-03-31 18:59:08', '2', 1, '220230331185904', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (140, 'checkOut', '2023-03-31 18:59:11', '2', 1, '220230331185904', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (141, 'start', '2023-03-31 18:59:13', '1', 1, '120230331185913', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (142, 'pause', '2023-03-31 19:47:06', '1', 1, '120230331185913', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (143, 'checkOut', '2023-03-31 20:38:35', '1', 1, '120230331185913', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (144, 'start', '2023-03-31 20:38:51', '1', 1, '120230331203850', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (145, 'pause', '2023-03-31 20:38:59', '1', 1, '120230331203850', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (146, 'checkOut', '2023-03-31 20:53:04', '1', 1, '120230331203850', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (147, 'start', '2023-03-31 20:53:41', '1', 1, '120230331205341', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (148, 'pause', '2023-03-31 20:53:47', '1', 1, '120230331205341', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (149, 'checkOut', '2023-03-31 20:54:27', '1', 1, '120230331205341', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (150, 'start', '2023-03-31 20:55:38', '1', 1, '120230331205537', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (151, 'pause', '2023-03-31 20:55:40', '1', 1, '120230331205537', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (152, 'checkOut', '2023-03-31 20:55:53', '1', 1, '120230331205537', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (153, 'start', '2023-03-31 20:55:57', '1', 1, '120230331205557', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (154, 'pause', '2023-03-31 20:56:15', '1', 1, '120230331205557', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (155, 'checkOut', '2023-03-31 20:59:38', '1', 1, '120230331205557', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (156, 'start', '2023-03-31 20:59:42', '1', 1, '120230331205941', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (157, 'pause', '2023-03-31 20:59:44', '1', 1, '120230331205941', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (158, 'checkOut', '2023-03-31 22:02:43', '1', 1, '120230331205941', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (159, 'start', '2023-03-31 22:02:47', '1', 1, '120230331220247', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (160, 'pause', '2023-03-31 22:02:50', '1', 1, '120230331220247', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (161, 'checkOut', '2023-03-31 22:03:12', '1', 1, '120230331220247', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (162, 'start', '2023-03-31 22:03:15', '1', 1, '120230331220315', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (163, 'pause', '2023-03-31 22:03:34', '1', 1, '120230331220315', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (164, 'renew', '2023-03-31 22:10:18', '1', 1, '120230331220315', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (165, 'pause', '2023-03-31 22:10:20', '1', 1, '120230331220315', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (166, 'checkOut', '2023-03-31 22:10:57', '1', 1, '120230331220315', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (167, 'start', '2023-03-31 22:11:43', '1', 1, '120230331221143', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (168, 'pause', '2023-03-31 22:12:57', '1', 1, '120230331221143', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (169, 'checkOut', '2023-03-31 22:14:08', '1', 1, '120230331221143', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (170, 'start', '2023-03-31 22:14:23', '1', 1, '120230331221423', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (171, 'pause', '2023-03-31 22:14:26', '1', 1, '120230331221423', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (172, 'checkOut', '2023-03-31 22:14:42', '1', 1, '120230331221423', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (173, 'start', '2023-03-31 22:16:08', '1', 1, '120230331221608', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (174, 'pause', '2023-03-31 22:16:10', '1', 1, '120230331221608', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (175, 'renew', '2023-03-31 22:26:46', '1', 1, '120230331221608', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (176, 'pause', '2023-03-31 22:26:48', '1', 1, '120230331221608', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (177, 'checkOut', '2023-03-31 22:27:03', '1', 1, '120230331221608', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (178, 'start', '2023-03-31 22:27:12', '1', 1, '120230331222712', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (179, 'pause', '2023-03-31 22:28:51', '1', 1, '120230331222712', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (180, 'unrecharge', NULL, '1', 1, '120230331222712', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (181, 'unrecharge', NULL, '1', 1, '120230331222712', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (182, 'checkOut', '2023-03-31 22:45:53', '1', 1, '120230331222712', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (183, 'start', '2023-03-31 22:54:13', '1', 1, '120230331225412', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (184, 'start', '2023-03-31 22:54:16', '8', 1, '820230331225415', NULL, NULL, NULL, NULL);
INSERT INTO `operation` VALUES (185, 'appointment', '2023-04-07 03:36:49', '4', 2088822380969236, 'apm420230407033305', '2023-04-07 03:33:05', '2023-04-07 03:53:00', '已完成', NULL);
INSERT INTO `operation` VALUES (186, 'appointment', '2023-04-07 05:10:41', '2', 2088822380969236, 'apm220230407051025', '2023-04-07 05:10:25', '2023-04-07 05:12:08', '已完成', NULL);
INSERT INTO `operation` VALUES (187, 'appointment', '2023-04-07 05:13:26', '3', 2088822380969236, 'apm320230407051138', '2023-04-07 05:11:38', '2023-04-07 05:13:09', '已完成', NULL);
INSERT INTO `operation` VALUES (188, 'appointment', '2023-04-07 05:17:09', '2', 2088822380969236, 'apm220230407051657', '2023-04-07 05:16:57', '2023-04-07 05:20:03', '已完成', NULL);
INSERT INTO `operation` VALUES (189, 'appointment', '2023-04-07 05:18:07', '4', 2088822380969236, 'apm420230407051805', '2023-04-07 05:18:05', '2023-04-07 05:21:00', '已完成', NULL);
-- ----------------------------
-- Table structure for order
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order` (
`orderid` bigint NOT NULL AUTO_INCREMENT,
`order_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`consumption` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '消费金额',
`userid` bigint NULL DEFAULT NULL,
PRIMARY KEY (`orderid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of order
-- ----------------------------
-- ----------------------------
-- Table structure for role_info
-- ----------------------------
DROP TABLE IF EXISTS `role_info`;
CREATE TABLE `role_info` (
`roleid` bigint NOT NULL AUTO_INCREMENT,
`role_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`create_time` datetime(0) NULL DEFAULT NULL,
`creator` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`visible_table` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`isdel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`extend3` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`extend4` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`extend5` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
PRIMARY KEY (`roleid`) USING BTREE,
UNIQUE INDEX `role_info_un`(`role_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of role_info
-- ----------------------------
INSERT INTO `role_info` VALUES (1, '管理员', NULL, NULL, '[\"announce\",\"home\",\"commodityManagement\",\"roleManagement\",\"userManagement\",\"tableInfo\",\"operation\",\"billiardUser\"]', NULL, NULL, NULL, NULL);
INSERT INTO `role_info` VALUES (2, '员工', NULL, NULL, NULL, '1', NULL, NULL, NULL);
-- ----------------------------
-- Table structure for role_user
-- ----------------------------
DROP TABLE IF EXISTS `role_user`;
CREATE TABLE `role_user` (
`userid` bigint NOT NULL,
`roleid` bigint NOT NULL,
PRIMARY KEY (`userid`, `roleid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of role_user
-- ----------------------------
INSERT INTO `role_user` VALUES (1, 1);
INSERT INTO `role_user` VALUES (1, 2);
INSERT INTO `role_user` VALUES (2, 1);
INSERT INTO `role_user` VALUES (3, 1);
INSERT INTO `role_user` VALUES (3, 2);
INSERT INTO `role_user` VALUES (5, 1);
INSERT INTO `role_user` VALUES (5, 2);
INSERT INTO `role_user` VALUES (6, 1);
INSERT INTO `role_user` VALUES (6, 2);
-- ----------------------------
-- Table structure for shop_operation
-- ----------------------------
DROP TABLE IF EXISTS `shop_operation`;
CREATE TABLE `shop_operation` (
`shopid` bigint NOT NULL AUTO_INCREMENT,
`orderid` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '关联订单号',
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '商品名',
`number` int NULL DEFAULT NULL COMMENT '变动前库存',
`price` float NULL DEFAULT NULL COMMENT '进价',
`selling_price` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '售价',
`change_number` int NULL DEFAULT NULL COMMENT '变动数量',
`user` varchar(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作人',
`operation_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作类型',
`time` datetime(0) NULL DEFAULT NULL,
PRIMARY KEY (`shopid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of shop_operation
-- ----------------------------
INSERT INTO `shop_operation` VALUES (11, '120230310214804', '怡宝', 87, 0.8, '2.0', 2, NULL, 'shopping', NULL);
INSERT INTO `shop_operation` VALUES (12, '120230310214804', '冰红茶', 85, 1.5, '3.5', 3, NULL, 'shopping', NULL);
INSERT INTO `shop_operation` VALUES (13, '120230310214804', '红牛', 98, 4.5, '6.0', 2, NULL, 'shopping', NULL);
INSERT INTO `shop_operation` VALUES (14, '120230310214804', '农夫山泉', 196, 1, '1.5', 1, NULL, 'shopping', NULL);
INSERT INTO `shop_operation` VALUES (15, '120230310214804', '怡宝', 86, 0.8, '2.0', 1, NULL, 'shopping', NULL);
INSERT INTO `shop_operation` VALUES (16, '120230310214804', '百岁山', 85, 2.5, '3.0', 1, NULL, 'shopping', NULL);
INSERT INTO `shop_operation` VALUES (17, '120230310214804', '干脆面', 46, 0.3, '0.5', 1, NULL, 'shopping', NULL);
INSERT INTO `shop_operation` VALUES (18, '120230310214804', '红烧牛肉面', 43, 3, '5.0', 1, NULL, 'shopping', NULL);
INSERT INTO `shop_operation` VALUES (19, '720230312011306', '农夫山泉', 193, 1, '1.5', 3, NULL, 'shopping', NULL);
INSERT INTO `shop_operation` VALUES (20, '720230312011306', '冰红茶', 82, 1.5, '3.5', 3, NULL, 'shopping', NULL);
INSERT INTO `shop_operation` VALUES (21, '720230312011306', '可口可乐', 98, 2, '3.0', 2, NULL, 'shopping', NULL);
INSERT INTO `shop_operation` VALUES (22, '720230216211959', '百岁山', 80, 2.5, '3.0', 5, 'admin', 'shopping', NULL);
INSERT INTO `shop_operation` VALUES (23, '320230313161456', '百岁山', 77, 2.5, '3.0', 3, 'admin', 'shopping', NULL);
INSERT INTO `shop_operation` VALUES (24, '720230323130550', '怡宝', 84, 0.8, '2.0', 2, NULL, 'shopping', NULL);
INSERT INTO `shop_operation` VALUES (25, '720230323130550', '冰红茶', 78, 1.5, '3.5', 4, NULL, 'shopping', NULL);
INSERT INTO `shop_operation` VALUES (26, '120230331173628', '农夫山泉', 191, 1, '1.5', 2, 'admin', 'shopping', '2023-03-31 18:21:48');
INSERT INTO `shop_operation` VALUES (27, '120230331173628', '乐事薯片', 45, 2.5, '4.0', 2, 'admin', 'shopping', '2023-03-31 18:21:48');
INSERT INTO `shop_operation` VALUES (28, '120230331220315', '乐事薯片', 43, 2.5, '4.0', 2, 'admin', 'shopping', '2023-03-31 22:10:29');
INSERT INTO `shop_operation` VALUES (29, '120230331220315', '冰红茶', 77, 1.5, '3.5', 1, 'admin', 'shopping', '2023-03-31 22:10:29');
INSERT INTO `shop_operation` VALUES (30, '120230331225412', '怡宝', 82, 0.8, '2.0', 2, 'admin', 'shopping', '2023-03-31 22:54:29');
-- ----------------------------
-- Table structure for table_management
-- ----------------------------
DROP TABLE IF EXISTS `table_management`;
CREATE TABLE `table_management` (
`tableid` bigint NOT NULL AUTO_INCREMENT,
`table_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '球桌号',
`picture` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '图片',
`table_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '球桌种类',
`price` int NULL DEFAULT NULL COMMENT '普通时价',
`status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '0未开台，2暂停，1已开台',
`isdel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '停用',
`extend2` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`extend3` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`extend4` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`extend5` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
PRIMARY KEY (`tableid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of table_management
-- ----------------------------
INSERT INTO `table_management` VALUES (1, '球桌1', 'http://192.168.1.8/file/downloadImg?name=银腿.png', '乔氏银腿', 20, '1', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `table_management` VALUES (2, '球桌2', 'http://127.0.0.1/file/downloadImg?name=银腿.png', '乔氏银腿', 20, '0', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `table_management` VALUES (3, '球桌3', 'http://127.0.0.1/file/downloadImg?name=银腿.png', '乔氏银腿', 20, '0', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `table_management` VALUES (4, '球桌4', 'http://127.0.0.1/file/downloadImg?name=银腿.png', '乔氏银腿', 20, '0', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `table_management` VALUES (5, '球桌5', 'http://127.0.0.1/file/downloadImg?name=银腿.png', '乔氏银腿', 20, '0', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `table_management` VALUES (6, '球桌6', 'http://127.0.0.1/file/downloadImg?name=银腿.png', '乔氏银腿', 20, '0', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `table_management` VALUES (7, '球桌7', 'http://127.0.0.1/file/downloadImg?name=银腿.png', '乔氏银腿', 20, '0', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `table_management` VALUES (8, '球桌8', 'http://127.0.0.1/file/downloadImg?name=金腿.png', '乔氏金腿', 25, '1', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `table_management` VALUES (9, '球桌9', 'http://127.0.0.1/file/downloadImg?name=金腿.png', '乔氏金腿', 25, '0', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `table_management` VALUES (10, '球桌10', 'http://127.0.0.1/file/downloadImg?name=金腿.png', '乔氏金腿', 25, '0', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `table_management` VALUES (11, '球桌11', 'http://127.0.0.1/file/downloadImg?name=金腿.png', '乔氏金腿', 25, '0', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `table_management` VALUES (12, '12号桌', 'http://127.0.0.1/file/downloadImg?name=金腿.png', '乔氏金腿', 25, '0', NULL, NULL, NULL, NULL, NULL);
-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
`userid` bigint NOT NULL AUTO_INCREMENT,
`user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`loginid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '登录名',
`password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '112233',
`age` int NULL DEFAULT NULL,
`sex` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`head_portrait` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`isdel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`create_time` datetime(0) NULL DEFAULT NULL,
`creator` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`extend1` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`extend2` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`extend3` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`extend4` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`extend5` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
PRIMARY KEY (`userid`) USING BTREE,
UNIQUE INDEX `user_info_un`(`loginid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户信息表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of user_info
-- ----------------------------
INSERT INTO `user_info` VALUES (1, '小红', 'admin', '123000', 24, '男', 'https://gw.alipayobjects.com/mdn/rms_1bde6f/afts/img/A*nyU6QLX40OEAAAAAAAAAAAAAARQnAQ', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (2, '小绿', '小绿', '123000', 23, '女', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (3, '张三', '张三', '123000', 22, '男', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (4, '李四', '李四', '123000', 24, '男', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (5, '王鹤棣', '王鹤棣', '123000', 23, '男', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (6, '成毅', '成毅', '123000', 22, '男', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (7, '肖战', '肖战', '123000', 22, '男', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (8, '王一博', '王一博', '123000', 26, '男', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (9, '赵露思', '赵露思', '123000', 23, '女', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (10, '王以纶', '王以纶', '123000', 25, '男', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (11, '白鹿', '白鹿', '123000', 24, '女', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (12, '任嘉伦', '任嘉伦', '123000', 26, '男', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (13, '王宽', '王宽', '123000', 23, '男', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (14, '关晓彤', '关晓彤', '123000', 25, '女', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (15, '鹿晗', '鹿晗', '123000', 27, '男', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (16, '罗云熙', '罗云熙', '123000', 26, '男', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (17, '虞书欣', '虞书欣', '123000', 26, '女', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (18, '景甜', '景甜', '123000', 26, '女', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (19, '杨幂', '杨幂', '123000', 25, '女', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (20, '杨颖', '杨颖', '123000', 25, '女', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (21, '舒畅', '舒畅', '123000', 27, '女', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (22, '吴磊', '吴磊', '123000', 23, '男', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (23, '蒋依依', '蒋依依', '123000', 26, '女', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (24, '宋祖儿', '宋祖儿', '123000', 23, '女', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (25, '范冰冰', '范冰冰', '123000', 26, '女', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (26, '李冰冰', '李冰冰', '123000', 25, '女', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
SET FOREIGN_KEY_CHECKS = 1;
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手