V1.14__print_template.sql
112 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
INSERT INTO `sys_menu` (`id`, `code`, `name`, `title`, `icon`, `component_type`, `component`, `request_param`, `parent_id`, `sys_module_id`, `path`, `no_cache`, `display`, `hidden`, `permission`, `is_special`, `available`, `description`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`) VALUES ('2000011', '2000011', 'PrintTemplate', '打印模板', NULL, 0, '/base-data/print-template/index', NULL, '2000', '15', '/print-template', 0, 1, 0, 'base-data:print-template:query', 1, 1, '', '系统管理员', '1', '2021-07-05 21:59:35', '系统管理员', '1', '2021-07-05 21:59:36');
INSERT INTO `sys_menu` (`id`, `code`, `name`, `title`, `icon`, `component_type`, `component`, `request_param`, `parent_id`, `sys_module_id`, `path`, `no_cache`, `display`, `hidden`, `permission`, `is_special`, `available`, `description`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`) VALUES ('2000011001', '2000011001', '', '新增打印模板', NULL, 0, '', NULL, '2000011', '15', '', 0, 2, 0, 'base-data:print-template:add', 1, 1, '', '系统管理员', '1', '2021-05-12 22:50:27', '系统管理员', '1', '2021-07-04 00:34:23');
INSERT INTO `sys_menu` (`id`, `code`, `name`, `title`, `icon`, `component_type`, `component`, `request_param`, `parent_id`, `sys_module_id`, `path`, `no_cache`, `display`, `hidden`, `permission`, `is_special`, `available`, `description`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`) VALUES ('2000011002', '2000011002', '', '修改打印模板', NULL, 0, '', NULL, '2000011', '15', '', 0, 2, 0, 'base-data:print-template:modify', 1, 1, '', '系统管理员', '1', '2021-05-12 23:23:33', '系统管理员', '1', '2021-07-04 00:34:23');
CREATE TABLE `tbl_print_template` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(20) NOT NULL COMMENT '名称',
`template_json` longtext COMMENT 'JSON配置',
`demo_data` longtext COMMENT '示例数据',
`create_by` varchar(32) NOT NULL COMMENT '创建人',
`create_by_id` varchar(32) NOT NULL COMMENT '创建人ID',
`create_time` datetime NOT NULL COMMENT '创建时间',
`update_by` varchar(32) NOT NULL COMMENT '修改人',
`update_by_id` varchar(32) NOT NULL COMMENT '修改人ID',
`update_time` datetime NOT NULL COMMENT '修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COMMENT='打印模板';
CREATE TABLE `tbl_print_template_comp` (
`id` varchar(20) NOT NULL COMMENT 'ID',
`template_id` int(11) NOT NULL COMMENT '模板ID',
`comp_json` longtext NOT NULL COMMENT '组件配置',
PRIMARY KEY (`id`),
KEY `template_id` (`template_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='打印模板组件';
INSERT INTO `tbl_print_template` (`id`, `name`, `template_json`, `demo_data`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`) VALUES (1, '采购订单', '{\"tempItems\":[{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":122,\"height\":14,\"left\":500,\"top\":5,\"title\":\"标题\",\"value\":\"采购订单\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":14,\"FontColor\":\"#000000\",\"Bold\":\"1\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"center\",\"ItemType\":\"1\",\"bordered\":false,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":0,\"leftOffset\":0},\"uuid\":\"35205865ddd83246b7aa9b82addbc49b5a7e\"},{\"type\":\"braid-barcode\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":200,\"height\":40,\"left\":920,\"top\":5,\"title\":\"单号条码\",\"name\":\"code\",\"style\":{\"zIndex\":0,\"FontSize\":\"9\",\"ShowBarText\":\"1\",\"CodeType\":\"Code39\",\"ItemType\":\"1\"},\"value\":\"{单号}\",\"uuid\":\"027597a790715443beeae5d06cd8d1f06b60\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":10,\"top\":60,\"title\":\"仓库编号-标题\",\"value\":\"仓库编号：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"387f44812bf5e84fc2a89b8689beb7ae95ff\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":118,\"top\":60,\"title\":\"仓库编号\",\"value\":\"{仓库编号}\",\"name\":\"scCode\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"b7217c3c1571794c4428f5d5823bfb0a4a99\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":286,\"top\":60,\"title\":\"仓库名称-标题\",\"value\":\"仓库名称：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"a400e796d4c955457bc819f8cf6c43d6c19a\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":394,\"top\":60,\"title\":\"仓库名称\",\"value\":\"{仓库名称}\",\"name\":\"scName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"7cf2034a2a4e1b443ffa3d5972bfc322a88e\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":562,\"top\":60,\"title\":\"供应商编号-标题\",\"value\":\"供应商编号：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"09bc7fd608d8e641df48b4e94b47f05ff923\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":670,\"top\":60,\"title\":\"供应商编号\",\"value\":\"{供应商编号}\",\"name\":\"supplierCode\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"4a08de3bd8296a4ac6ab9f2c5cab79f61584\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":838,\"top\":60,\"title\":\"供应商名称-标题\",\"value\":\"供应商名称：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"2bcbd47062dffb4d0038afc6ac3e58455eab\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":946,\"top\":60,\"title\":\"供应商名称\",\"value\":\"{供应商名称}\",\"name\":\"supplierName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"c39584ca3946284d908bd758d6dad5a70517\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":10,\"top\":84,\"title\":\"采购员-标题\",\"value\":\"采购员：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"4c9ba4c9e0da3443d2097761f206563a6e31\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":118,\"top\":84,\"title\":\"采购员\",\"value\":\"{采购员}\",\"name\":\"purchaserName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"a4508027b5bd034c440a063e59b7ee0cc297\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":286,\"top\":84,\"title\":\"操作人-标题\",\"value\":\"操作人：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"09debe4c6886374dbdd847de695a364339aa\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":394,\"top\":84,\"title\":\"操作人\",\"value\":\"{操作人}\",\"name\":\"createBy\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"aea91c8a37984b4d90e8545fa84a823a9e2b\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":562,\"top\":84,\"title\":\"操作时间-标题\",\"value\":\"操作时间：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"b80a43b94128624c56a97c3e88689b6af8d6\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":670,\"top\":84,\"title\":\"操作时间\",\"value\":\"{操作时间}\",\"name\":\"createTime\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"89d3b43387c17e44f798ef2bf220d26bf3e3\"},{\"type\":\"braid-table\",\"isEdit\":0,\"draggable\":true,\"resizable\":true,\"width\":1104,\"height\":60,\"left\":10,\"top\":118,\"title\":\"采购商品明细\",\"value\":\"{details}\",\"defaultValue\":[],\"tabelHtml\":\"\",\"columnsAttr\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"采购数量\",\"value\":\"{采购数量}\",\"name\":\"purchaseNum\"},{\"title\":\"采购价\",\"value\":\"{采购价}\",\"name\":\"purchasePrice\"},{\"title\":\"采购金额\",\"value\":\"{采购金额}\",\"name\":\"purchaseAmount\"}],\"columns\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"采购数量\",\"value\":\"{采购数量}\",\"name\":\"purchaseNum\"},{\"title\":\"采购价\",\"value\":\"{采购价}\",\"name\":\"purchasePrice\"},{\"title\":\"采购金额\",\"value\":\"{采购金额}\",\"name\":\"purchaseAmount\"}],\"selectCol\":[\"_seq\",\"productCode\",\"productName\",\"skuCode\",\"externalCode\",\"purchaseNum\",\"purchasePrice\",\"purchaseAmount\"],\"name\":\"details\",\"style\":{\"zIndex\":0,\"Alignment\":\"left\",\"FontSize\":12,\"FontColor\":\"#000000\",\"borderColor\":\"#000000\",\"autoHeight\":true,\"BottomMargin\":20},\"uuid\":\"a54b8d97a637b64fd5f9ca417d7d5211716e\"},{\"type\":\"braid-page\",\"isEdit\":false,\"draggable\":true,\"resizable\":true,\"width\":97,\"height\":20,\"left\":1025,\"top\":770,\"title\":\"分页\",\"curPageStyle\":\"第##页\",\"splitPageStyle\":\"/\",\"totalPageStyle\":\"共##页\",\"name\":\"\",\"style\":{\"zIndex\":0,\"ItemType\":\"1\",\"autoHeight\":false,\"BottomMargin\":5,\"Alignment\":\"right\",\"FontSize\":12,\"FontColor\":\"#000000\"},\"uuid\":\"d6f62ce0a7931e438188be50bc350f99da7d\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":838,\"top\":84,\"title\":\"预计到货日期-标题\",\"value\":\"预计到货日期：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"604209e64d1a984bbaabe0ad64ad77f5eeee\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":946,\"top\":84,\"title\":\"预计到货日期\",\"value\":\"{预计到货日期}\",\"name\":\"expectArriveDate\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"e874b94582286747e2a8865a0ded60b4d639\"}],\"title\":\"采购订单\",\"pageWidth\":210,\"pageHeight\":297,\"width\":1122,\"height\":793,\"pageDirection\":2}', '{\n \"code\": \"202503220000000002\",\n \"scCode\": \"1\",\n \"scName\": \"测试仓库\",\n \"supplierCode\": \"1\",\n \"supplierName\": \"测试供应商\",\n \"purchaserName\": \"\",\n \"expectArriveDate\": \"2025-04-22\",\n \"description\": \"\",\n \"createBy\": \"系统管理员\",\n \"createTime\": \"2025-03-22 08:04:30\",\n \"approveBy\": \"\",\n \"approveTime\": \"\",\n \"details\": [\n {\n \"productCode\": \"11\",\n \"productName\": \"商品222\",\n \"skuCode\": \"41\",\n \"externalCode\": \"51\",\n \"purchaseNum\": 1,\n \"purchasePrice\": 121,\n \"purchaseAmount\": 121\n }\n ]\n}', '系统管理员', '1', '2025-01-28 18:41:35', '系统管理员', '1', '2025-05-09 19:49:08');
INSERT INTO `tbl_print_template` (`id`, `name`, `template_json`, `demo_data`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`) VALUES (2, '采购收货单', '{\"tempItems\":[{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":122,\"height\":14,\"left\":500,\"top\":5,\"title\":\"标题\",\"value\":\"采购收货单\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":14,\"FontColor\":\"#000000\",\"Bold\":\"1\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"center\",\"ItemType\":\"1\",\"bordered\":false,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":0,\"leftOffset\":0},\"uuid\":\"35205865ddd83246b7aa9b82addbc49b5a7e\"},{\"type\":\"braid-barcode\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":200,\"height\":40,\"left\":920,\"top\":5,\"title\":\"单号条码\",\"name\":\"code\",\"style\":{\"zIndex\":0,\"FontSize\":\"9\",\"ShowBarText\":\"1\",\"CodeType\":\"Code39\",\"ItemType\":\"1\"},\"value\":\"{单号}\",\"uuid\":\"027597a790715443beeae5d06cd8d1f06b60\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":10,\"top\":60,\"title\":\"仓库编号-标题\",\"value\":\"仓库编号：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"387f44812bf5e84fc2a89b8689beb7ae95ff\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":118,\"top\":60,\"title\":\"仓库编号\",\"value\":\"{仓库编号}\",\"name\":\"scCode\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"b7217c3c1571794c4428f5d5823bfb0a4a99\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":286,\"top\":60,\"title\":\"仓库名称-标题\",\"value\":\"仓库名称：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"a400e796d4c955457bc819f8cf6c43d6c19a\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":394,\"top\":60,\"title\":\"仓库名称\",\"value\":\"{仓库名称}\",\"name\":\"scName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"7cf2034a2a4e1b443ffa3d5972bfc322a88e\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":562,\"top\":60,\"title\":\"供应商编号-标题\",\"value\":\"供应商编号：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"09bc7fd608d8e641df48b4e94b47f05ff923\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":670,\"top\":60,\"title\":\"供应商编号\",\"value\":\"{供应商编号}\",\"name\":\"supplierCode\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"4a08de3bd8296a4ac6ab9f2c5cab79f61584\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":838,\"top\":60,\"title\":\"供应商名称-标题\",\"value\":\"供应商名称：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"2bcbd47062dffb4d0038afc6ac3e58455eab\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":946,\"top\":60,\"title\":\"供应商名称\",\"value\":\"{供应商名称}\",\"name\":\"supplierName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"c39584ca3946284d908bd758d6dad5a70517\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":10,\"top\":84,\"title\":\"采购员-标题\",\"value\":\"采购员：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"4c9ba4c9e0da3443d2097761f206563a6e31\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":118,\"top\":84,\"title\":\"采购员\",\"value\":\"{采购员}\",\"name\":\"purchaserName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"a4508027b5bd034c440a063e59b7ee0cc297\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":286,\"top\":84,\"title\":\"操作人-标题\",\"value\":\"操作人：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"09debe4c6886374dbdd847de695a364339aa\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":394,\"top\":84,\"title\":\"操作人\",\"value\":\"{操作人}\",\"name\":\"createBy\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"aea91c8a37984b4d90e8545fa84a823a9e2b\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":562,\"top\":84,\"title\":\"操作时间-标题\",\"value\":\"操作时间：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"b80a43b94128624c56a97c3e88689b6af8d6\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":670,\"top\":84,\"title\":\"操作时间\",\"value\":\"{操作时间}\",\"name\":\"createTime\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"89d3b43387c17e44f798ef2bf220d26bf3e3\"},{\"type\":\"braid-table\",\"isEdit\":0,\"draggable\":true,\"resizable\":true,\"width\":1104,\"height\":60,\"left\":10,\"top\":142,\"title\":\"收货商品明细\",\"value\":\"{details}\",\"defaultValue\":[],\"tabelHtml\":\"\",\"columnsAttr\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"收货数量\",\"value\":\"{收货数量}\",\"name\":\"receiveNum\"},{\"title\":\"采购价\",\"value\":\"{采购价}\",\"name\":\"purchasePrice\"},{\"title\":\"收货金额\",\"value\":\"{收货金额}\",\"name\":\"receiveAmount\"}],\"columns\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"收货数量\",\"value\":\"{收货数量}\",\"name\":\"receiveNum\"},{\"title\":\"采购价\",\"value\":\"{采购价}\",\"name\":\"purchasePrice\"},{\"title\":\"收货金额\",\"value\":\"{收货金额}\",\"name\":\"receiveAmount\"}],\"selectCol\":[\"_seq\",\"productCode\",\"productName\",\"skuCode\",\"externalCode\",\"receiveNum\",\"purchasePrice\",\"receiveAmount\"],\"name\":\"details\",\"style\":{\"zIndex\":0,\"Alignment\":\"left\",\"FontSize\":12,\"FontColor\":\"#000000\",\"borderColor\":\"#000000\",\"autoHeight\":true,\"BottomMargin\":20},\"uuid\":\"a54b8d97a637b64fd5f9ca417d7d5211716e\"},{\"type\":\"braid-page\",\"isEdit\":false,\"draggable\":true,\"resizable\":true,\"width\":97,\"height\":20,\"left\":1025,\"top\":770,\"title\":\"分页\",\"curPageStyle\":\"第##页\",\"splitPageStyle\":\"/\",\"totalPageStyle\":\"共##页\",\"name\":\"\",\"style\":{\"zIndex\":0,\"ItemType\":\"1\",\"autoHeight\":false,\"BottomMargin\":5,\"Alignment\":\"right\",\"FontSize\":12,\"FontColor\":\"#000000\"},\"uuid\":\"d6f62ce0a7931e438188be50bc350f99da7d\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":10,\"top\":108,\"title\":\"付款日期-标题\",\"value\":\"付款日期：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"604209e64d1a984bbaabe0ad64ad77f5eeee\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":118,\"top\":108,\"title\":\"付款日期\",\"value\":\"{付款日期}\",\"name\":\"paymentDate\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"e874b94582286747e2a8865a0ded60b4d639\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":286,\"top\":108,\"title\":\"实际到货日期-标题\",\"value\":\"实际到货日期：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"6dd07e667962904ffc295c2ebc5e75c164ad\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":394,\"top\":108,\"title\":\"实际到货日期\",\"value\":\"{实际到货日期}\",\"name\":\"receiveDate\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"572db42f6ec9644a9c4863c94af8b229e6e8\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":838,\"top\":84,\"title\":\"采购订单号-标题\",\"value\":\"采购订单号：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"a4e29827b8e062405258d7f5e7bb535f9dd5\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":946,\"top\":84,\"title\":\"采购订单号\",\"value\":\"{采购订单号}\",\"name\":\"purchaseOrderCode\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"e7681d4c03d9664ad96b96efc49bd124f871\"}],\"title\":\"采购收货单\",\"pageWidth\":210,\"pageHeight\":297,\"width\":1122,\"height\":793,\"pageDirection\":2}', '{\n \"code\": \"202501190000000003\",\n \"scCode\": \"1\",\n \"scName\": \"测试仓库\",\n \"supplierCode\": \"1\",\n \"supplierName\": \"测试供应商\",\n \"purchaserName\": \"\",\n \"paymentDate\": \"2025-02-19\",\n \"receiveDate\": \"2025-01-19\",\n \"purchaseOrderCode\": \"\",\n \"description\": \"\",\n \"createBy\": \"系统管理员\",\n \"createTime\": \"2025-01-19 21:39:08\",\n \"approveBy\": \"\",\n \"approveTime\": \"\",\n \"details\": [\n {\n \"productCode\": \"11\",\n \"productName\": \"商品222\",\n \"skuCode\": \"41\",\n \"externalCode\": \"51\",\n \"receiveNum\": 1,\n \"purchasePrice\": 121,\n \"receiveAmount\": 121\n }\n ]\n}', '系统管理员', '1', '2025-01-28 18:44:12', '系统管理员', '1', '2025-05-09 18:04:40');
INSERT INTO `tbl_print_template` (`id`, `name`, `template_json`, `demo_data`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`) VALUES (3, '采购退货单', '{\"tempItems\":[{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":122,\"height\":14,\"left\":500,\"top\":5,\"title\":\"标题\",\"value\":\"采购退货单\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":14,\"FontColor\":\"#000000\",\"Bold\":\"1\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"center\",\"ItemType\":\"1\",\"bordered\":false,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":0,\"leftOffset\":0},\"uuid\":\"35205865ddd83246b7aa9b82addbc49b5a7e\"},{\"type\":\"braid-barcode\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":200,\"height\":40,\"left\":920,\"top\":5,\"title\":\"单号条码\",\"name\":\"code\",\"style\":{\"zIndex\":0,\"FontSize\":\"9\",\"ShowBarText\":\"1\",\"CodeType\":\"Code39\",\"ItemType\":\"1\"},\"value\":\"{单号}\",\"uuid\":\"027597a790715443beeae5d06cd8d1f06b60\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":10,\"top\":60,\"title\":\"仓库编号-标题\",\"value\":\"仓库编号：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"387f44812bf5e84fc2a89b8689beb7ae95ff\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":118,\"top\":60,\"title\":\"仓库编号\",\"value\":\"{仓库编号}\",\"name\":\"scCode\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"b7217c3c1571794c4428f5d5823bfb0a4a99\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":286,\"top\":60,\"title\":\"仓库名称-标题\",\"value\":\"仓库名称：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"a400e796d4c955457bc819f8cf6c43d6c19a\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":394,\"top\":60,\"title\":\"仓库名称\",\"value\":\"{仓库名称}\",\"name\":\"scName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"7cf2034a2a4e1b443ffa3d5972bfc322a88e\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":562,\"top\":60,\"title\":\"供应商编号-标题\",\"value\":\"供应商编号：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"09bc7fd608d8e641df48b4e94b47f05ff923\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":670,\"top\":60,\"title\":\"供应商编号\",\"value\":\"{供应商编号}\",\"name\":\"supplierCode\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"4a08de3bd8296a4ac6ab9f2c5cab79f61584\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":838,\"top\":60,\"title\":\"供应商名称-标题\",\"value\":\"供应商名称：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"2bcbd47062dffb4d0038afc6ac3e58455eab\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":946,\"top\":60,\"title\":\"供应商名称\",\"value\":\"{供应商名称}\",\"name\":\"supplierName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"c39584ca3946284d908bd758d6dad5a70517\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":10,\"top\":84,\"title\":\"采购员-标题\",\"value\":\"采购员：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"4c9ba4c9e0da3443d2097761f206563a6e31\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":118,\"top\":84,\"title\":\"采购员\",\"value\":\"{采购员}\",\"name\":\"purchaserName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"a4508027b5bd034c440a063e59b7ee0cc297\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":286,\"top\":84,\"title\":\"操作人-标题\",\"value\":\"操作人：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"09debe4c6886374dbdd847de695a364339aa\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":394,\"top\":84,\"title\":\"操作人\",\"value\":\"{操作人}\",\"name\":\"createBy\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"aea91c8a37984b4d90e8545fa84a823a9e2b\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":562,\"top\":84,\"title\":\"操作时间-标题\",\"value\":\"操作时间：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"b80a43b94128624c56a97c3e88689b6af8d6\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":670,\"top\":84,\"title\":\"操作时间\",\"value\":\"{操作时间}\",\"name\":\"createTime\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"89d3b43387c17e44f798ef2bf220d26bf3e3\"},{\"type\":\"braid-table\",\"isEdit\":0,\"draggable\":true,\"resizable\":true,\"width\":1104,\"height\":60,\"left\":10,\"top\":142,\"title\":\"退货商品明细\",\"value\":\"{details}\",\"defaultValue\":[],\"tabelHtml\":\"\",\"columnsAttr\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"退货数量\",\"value\":\"{退货数量}\",\"name\":\"returnNum\"},{\"title\":\"退货价\",\"value\":\"{退货价}\",\"name\":\"purchasePrice\"},{\"title\":\"退货金额\",\"value\":\"{退货金额}\",\"name\":\"returnAmount\"}],\"columns\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"退货数量\",\"value\":\"{退货数量}\",\"name\":\"returnNum\"},{\"title\":\"退货价\",\"value\":\"{退货价}\",\"name\":\"purchasePrice\"},{\"title\":\"退货金额\",\"value\":\"{退货金额}\",\"name\":\"returnAmount\"}],\"selectCol\":[\"_seq\",\"productCode\",\"productName\",\"skuCode\",\"externalCode\",\"returnNum\",\"purchasePrice\",\"returnAmount\"],\"name\":\"details\",\"style\":{\"zIndex\":0,\"Alignment\":\"left\",\"FontSize\":12,\"FontColor\":\"#000000\",\"borderColor\":\"#000000\",\"autoHeight\":true,\"BottomMargin\":20},\"uuid\":\"a54b8d97a637b64fd5f9ca417d7d5211716e\"},{\"type\":\"braid-page\",\"isEdit\":false,\"draggable\":true,\"resizable\":true,\"width\":97,\"height\":20,\"left\":1025,\"top\":770,\"title\":\"分页\",\"curPageStyle\":\"第##页\",\"splitPageStyle\":\"/\",\"totalPageStyle\":\"共##页\",\"name\":\"\",\"style\":{\"zIndex\":0,\"ItemType\":\"1\",\"autoHeight\":false,\"BottomMargin\":5,\"Alignment\":\"right\",\"FontSize\":12,\"FontColor\":\"#000000\"},\"uuid\":\"d6f62ce0a7931e438188be50bc350f99da7d\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":10,\"top\":108,\"title\":\"付款日期-标题\",\"value\":\"付款日期：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"604209e64d1a984bbaabe0ad64ad77f5eeee\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":118,\"top\":108,\"title\":\"付款日期\",\"value\":\"{付款日期}\",\"name\":\"paymentDate\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"e874b94582286747e2a8865a0ded60b4d639\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":838,\"top\":84,\"title\":\"采购收货单号-标题\",\"value\":\"采购收货单号：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"a4e29827b8e062405258d7f5e7bb535f9dd5\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":946,\"top\":84,\"title\":\"采购收货单号\",\"value\":\"{采购收货单号}\",\"name\":\"receiveSheetCode\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"e7681d4c03d9664ad96b96efc49bd124f871\"}],\"title\":\"采购退货单\",\"pageWidth\":210,\"pageHeight\":297,\"width\":1122,\"height\":793,\"pageDirection\":2}', '{\n \"code\": \"202501190000000005\",\n \"scCode\": \"1\",\n \"scName\": \"测试仓库\",\n \"supplierCode\": \"1\",\n \"supplierName\": \"测试供应商\",\n \"purchaserName\": \"\",\n \"paymentDate\": \"2025-02-19\",\n \"receiveSheetCode\": \"\",\n \"description\": \"\",\n \"createBy\": \"系统管理员\",\n \"createTime\": \"2025-01-19 21:51:18\",\n \"approveBy\": \"系统管理员\",\n \"approveTime\": \"2025-01-19 21:51:24\",\n \"details\": [\n {\n \"id\": \"1880976328979779584\",\n \"productId\": \"1738409214449160192\",\n \"productCode\": \"11\",\n \"productName\": \"商品222\",\n \"skuCode\": \"41\",\n \"externalCode\": \"51\",\n \"returnNum\": 1,\n \"purchasePrice\": 121,\n \"returnAmount\": 121\n }\n ]\n}', '系统管理员', '1', '2025-05-09 18:03:12', '系统管理员', '1', '2025-05-09 19:45:12');
INSERT INTO `tbl_print_template` (`id`, `name`, `template_json`, `demo_data`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`) VALUES (4, '零售出库单', '{\"tempItems\":[{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":122,\"height\":14,\"left\":500,\"top\":5,\"title\":\"标题\",\"value\":\"零售出库单\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":14,\"FontColor\":\"#000000\",\"Bold\":\"1\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"center\",\"ItemType\":\"1\",\"bordered\":false,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":0,\"leftOffset\":0},\"uuid\":\"35205865ddd83246b7aa9b82addbc49b5a7e\"},{\"type\":\"braid-barcode\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":200,\"height\":40,\"left\":920,\"top\":5,\"title\":\"单号条码\",\"name\":\"code\",\"style\":{\"zIndex\":0,\"FontSize\":\"9\",\"ShowBarText\":\"1\",\"CodeType\":\"Code39\",\"ItemType\":\"1\"},\"value\":\"{单号}\",\"uuid\":\"027597a790715443beeae5d06cd8d1f06b60\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":10,\"top\":60,\"title\":\"仓库编号-标题\",\"value\":\"仓库编号：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"387f44812bf5e84fc2a89b8689beb7ae95ff\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":118,\"top\":60,\"title\":\"仓库编号\",\"value\":\"{仓库编号}\",\"name\":\"scCode\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"b7217c3c1571794c4428f5d5823bfb0a4a99\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":286,\"top\":60,\"title\":\"仓库名称-标题\",\"value\":\"仓库名称：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"a400e796d4c955457bc819f8cf6c43d6c19a\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":394,\"top\":60,\"title\":\"仓库名称\",\"value\":\"{仓库名称}\",\"name\":\"scName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"7cf2034a2a4e1b443ffa3d5972bfc322a88e\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":562,\"top\":60,\"title\":\"会员编号-标题\",\"value\":\"会员编号：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"09bc7fd608d8e641df48b4e94b47f05ff923\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":670,\"top\":60,\"title\":\"会员编号\",\"value\":\"{会员编号}\",\"name\":\"memberCode\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"4a08de3bd8296a4ac6ab9f2c5cab79f61584\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":838,\"top\":60,\"title\":\"会员名称-标题\",\"value\":\"会员名称：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"2bcbd47062dffb4d0038afc6ac3e58455eab\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":946,\"top\":60,\"title\":\"会员名称\",\"value\":\"{会员名称}\",\"name\":\"memberName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"c39584ca3946284d908bd758d6dad5a70517\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":10,\"top\":84,\"title\":\"销售员-标题\",\"value\":\"销售员：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"4c9ba4c9e0da3443d2097761f206563a6e31\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":118,\"top\":84,\"title\":\"销售员\",\"value\":\"{销售员}\",\"name\":\"salerName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"a4508027b5bd034c440a063e59b7ee0cc297\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":286,\"top\":84,\"title\":\"操作人-标题\",\"value\":\"操作人：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"09debe4c6886374dbdd847de695a364339aa\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":394,\"top\":84,\"title\":\"操作人\",\"value\":\"{操作人}\",\"name\":\"createBy\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"aea91c8a37984b4d90e8545fa84a823a9e2b\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":562,\"top\":84,\"title\":\"操作时间-标题\",\"value\":\"操作时间：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"b80a43b94128624c56a97c3e88689b6af8d6\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":670,\"top\":84,\"title\":\"操作时间\",\"value\":\"{操作时间}\",\"name\":\"createTime\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"89d3b43387c17e44f798ef2bf220d26bf3e3\"},{\"type\":\"braid-table\",\"isEdit\":0,\"draggable\":true,\"resizable\":true,\"width\":1104,\"height\":60,\"left\":10,\"top\":118,\"title\":\"出库商品明细\",\"value\":\"{details}\",\"defaultValue\":[],\"tabelHtml\":\"\",\"columnsAttr\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"出库数量\",\"value\":\"{出库数量}\",\"name\":\"outNum\"},{\"title\":\"价格\",\"value\":\"{价格}\",\"name\":\"taxPrice\"},{\"title\":\"出库金额\",\"value\":\"{出库金额}\",\"name\":\"outAmount\"}],\"columns\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"出库数量\",\"value\":\"{出库数量}\",\"name\":\"outNum\"},{\"title\":\"价格\",\"value\":\"{价格}\",\"name\":\"taxPrice\"},{\"title\":\"出库金额\",\"value\":\"{出库金额}\",\"name\":\"outAmount\"}],\"selectCol\":[\"_seq\",\"productCode\",\"productName\",\"skuCode\",\"externalCode\",\"outNum\",\"taxPrice\",\"outAmount\"],\"name\":\"details\",\"style\":{\"zIndex\":0,\"Alignment\":\"left\",\"FontSize\":12,\"FontColor\":\"#000000\",\"borderColor\":\"#000000\",\"autoHeight\":true,\"BottomMargin\":20},\"uuid\":\"a54b8d97a637b64fd5f9ca417d7d5211716e\"},{\"type\":\"braid-page\",\"isEdit\":false,\"draggable\":true,\"resizable\":true,\"width\":97,\"height\":20,\"left\":1025,\"top\":770,\"title\":\"分页\",\"curPageStyle\":\"第##页\",\"splitPageStyle\":\"/\",\"totalPageStyle\":\"共##页\",\"name\":\"\",\"style\":{\"zIndex\":0,\"ItemType\":\"1\",\"autoHeight\":false,\"BottomMargin\":5,\"Alignment\":\"right\",\"FontSize\":12,\"FontColor\":\"#000000\"},\"uuid\":\"d6f62ce0a7931e438188be50bc350f99da7d\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":838,\"top\":84,\"title\":\"付款日期-标题\",\"value\":\"付款日期：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"604209e64d1a984bbaabe0ad64ad77f5eeee\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":946,\"top\":84,\"title\":\"付款日期\",\"value\":\"{付款日期}\",\"name\":\"paymentDate\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"e874b94582286747e2a8865a0ded60b4d639\"}],\"title\":\"零售出库单\",\"pageWidth\":210,\"pageHeight\":297,\"width\":1122,\"height\":793,\"pageDirection\":2}', '{\n \"code\": \"202501190000000004\",\n \"scCode\": \"1\",\n \"scName\": \"测试仓库\",\n \"memberCode\": \"1\",\n \"memberName\": \"测试会员\",\n \"salerName\": \"\",\n \"paymentDate\": \"2025-02-19\",\n \"description\": \"\",\n \"createBy\": \"系统管理员\",\n \"createTime\": \"2025-01-19 22:20:59\",\n \"approveBy\": \"系统管理员\",\n \"approveTime\": \"2025-01-19 22:21:23\",\n \"details\": [\n {\n \"productCode\": \"11\",\n \"productName\": \"商品222\",\n \"skuCode\": \"41\",\n \"externalCode\": \"51\",\n \"outNum\": 1,\n \"taxPrice\": 141,\n \"outAmount\": 141\n }\n ]\n}', '系统管理员', '1', '2025-05-09 19:54:59', '系统管理员', '1', '2025-05-09 20:03:51');
INSERT INTO `tbl_print_template` (`id`, `name`, `template_json`, `demo_data`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`) VALUES (5, '零售退货单', '{\"tempItems\":[{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":122,\"height\":14,\"left\":500,\"top\":5,\"title\":\"标题\",\"value\":\"零售退货单\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":14,\"FontColor\":\"#000000\",\"Bold\":\"1\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"center\",\"ItemType\":\"1\",\"bordered\":false,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":0,\"leftOffset\":0},\"uuid\":\"35205865ddd83246b7aa9b82addbc49b5a7e\"},{\"type\":\"braid-barcode\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":200,\"height\":40,\"left\":920,\"top\":5,\"title\":\"单号条码\",\"name\":\"code\",\"style\":{\"zIndex\":0,\"FontSize\":\"9\",\"ShowBarText\":\"1\",\"CodeType\":\"Code39\",\"ItemType\":\"1\"},\"value\":\"{单号}\",\"uuid\":\"027597a790715443beeae5d06cd8d1f06b60\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":10,\"top\":60,\"title\":\"仓库编号-标题\",\"value\":\"仓库编号：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"387f44812bf5e84fc2a89b8689beb7ae95ff\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":118,\"top\":60,\"title\":\"仓库编号\",\"value\":\"{仓库编号}\",\"name\":\"scCode\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"b7217c3c1571794c4428f5d5823bfb0a4a99\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":286,\"top\":60,\"title\":\"仓库名称-标题\",\"value\":\"仓库名称：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"a400e796d4c955457bc819f8cf6c43d6c19a\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":394,\"top\":60,\"title\":\"仓库名称\",\"value\":\"{仓库名称}\",\"name\":\"scName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"7cf2034a2a4e1b443ffa3d5972bfc322a88e\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":562,\"top\":60,\"title\":\"会员编号-标题\",\"value\":\"会员编号：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"09bc7fd608d8e641df48b4e94b47f05ff923\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":670,\"top\":60,\"title\":\"会员编号\",\"value\":\"{会员编号}\",\"name\":\"memberCode\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"4a08de3bd8296a4ac6ab9f2c5cab79f61584\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":838,\"top\":60,\"title\":\"会员名称-标题\",\"value\":\"会员名称：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"2bcbd47062dffb4d0038afc6ac3e58455eab\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":946,\"top\":60,\"title\":\"会员名称\",\"value\":\"{会员名称}\",\"name\":\"memberName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"c39584ca3946284d908bd758d6dad5a70517\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":10,\"top\":84,\"title\":\"销售员-标题\",\"value\":\"销售员：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"4c9ba4c9e0da3443d2097761f206563a6e31\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":118,\"top\":84,\"title\":\"销售员\",\"value\":\"{销售员}\",\"name\":\"salerName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"a4508027b5bd034c440a063e59b7ee0cc297\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":286,\"top\":84,\"title\":\"操作人-标题\",\"value\":\"操作人：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"09debe4c6886374dbdd847de695a364339aa\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":394,\"top\":84,\"title\":\"操作人\",\"value\":\"{操作人}\",\"name\":\"createBy\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"aea91c8a37984b4d90e8545fa84a823a9e2b\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":562,\"top\":84,\"title\":\"操作时间-标题\",\"value\":\"操作时间：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"b80a43b94128624c56a97c3e88689b6af8d6\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":670,\"top\":84,\"title\":\"操作时间\",\"value\":\"{操作时间}\",\"name\":\"createTime\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"89d3b43387c17e44f798ef2bf220d26bf3e3\"},{\"type\":\"braid-table\",\"isEdit\":0,\"draggable\":true,\"resizable\":true,\"width\":1104,\"height\":60,\"left\":10,\"top\":142,\"title\":\"退货商品明细\",\"value\":\"{details}\",\"defaultValue\":[],\"tabelHtml\":\"\",\"columnsAttr\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"退货数量\",\"value\":\"{退货数量}\",\"name\":\"returnNum\"},{\"title\":\"价格\",\"value\":\"{价格}\",\"name\":\"taxPrice\"},{\"title\":\"退货金额\",\"value\":\"{退货金额}\",\"name\":\"returnAmount\"}],\"columns\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"退货数量\",\"value\":\"{退货数量}\",\"name\":\"returnNum\"},{\"title\":\"价格\",\"value\":\"{价格}\",\"name\":\"taxPrice\"},{\"title\":\"退货金额\",\"value\":\"{退货金额}\",\"name\":\"returnAmount\"}],\"selectCol\":[\"_seq\",\"productCode\",\"productName\",\"skuCode\",\"externalCode\",\"returnNum\",\"taxPrice\",\"returnAmount\"],\"name\":\"details\",\"style\":{\"zIndex\":0,\"Alignment\":\"left\",\"FontSize\":12,\"FontColor\":\"#000000\",\"borderColor\":\"#000000\",\"autoHeight\":true,\"BottomMargin\":20},\"uuid\":\"a54b8d97a637b64fd5f9ca417d7d5211716e\"},{\"type\":\"braid-page\",\"isEdit\":false,\"draggable\":true,\"resizable\":true,\"width\":97,\"height\":20,\"left\":1025,\"top\":770,\"title\":\"分页\",\"curPageStyle\":\"第##页\",\"splitPageStyle\":\"/\",\"totalPageStyle\":\"共##页\",\"name\":\"\",\"style\":{\"zIndex\":0,\"ItemType\":\"1\",\"autoHeight\":false,\"BottomMargin\":5,\"Alignment\":\"right\",\"FontSize\":12,\"FontColor\":\"#000000\"},\"uuid\":\"d6f62ce0a7931e438188be50bc350f99da7d\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":10,\"top\":108,\"title\":\"付款日期-标题\",\"value\":\"付款日期：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"604209e64d1a984bbaabe0ad64ad77f5eeee\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":118,\"top\":108,\"title\":\"付款日期\",\"value\":\"{付款日期}\",\"name\":\"paymentDate\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"e874b94582286747e2a8865a0ded60b4d639\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":838,\"top\":84,\"title\":\"零售出库单号-标题\",\"value\":\"零售出库单号：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"10488b69c261764f0e388a6607267aae769f\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":946,\"top\":84,\"title\":\"零售出库单号\",\"value\":\"{零售出库单号}\",\"name\":\"outSheetCode\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"ba426c11fae59f4442a84d29ef5ab38c82ff\"}],\"title\":\"零售退货单\",\"pageWidth\":210,\"pageHeight\":297,\"width\":1122,\"height\":793,\"pageDirection\":2}', '{\n \"code\": \"202501190000000003\",\n \"scCode\": \"1\",\n \"scName\": \"测试仓库\",\n \"memberCode\": \"1\",\n \"memberName\": \"测试会员\",\n \"salerName\": \"\",\n \"paymentDate\": \"2025-02-19\",\n \"outSheetCode\": \"\",\n \"description\": \"\",\n \"createBy\": \"系统管理员\",\n \"createTime\": \"2025-01-19 22:28:28\",\n \"approveBy\": \"\",\n \"approveTime\": \"\",\n \"details\": [\n {\n \"productCode\": \"11\",\n \"productName\": \"商品222\",\n \"skuCode\": \"41\",\n \"externalCode\": \"51\",\n \"returnNum\": 1,\n \"taxPrice\": 141,\n \"returnAmount\": 141\n }\n ]\n}', '系统管理员', '1', '2025-05-09 20:54:00', '系统管理员', '1', '2025-05-09 21:03:49');
INSERT INTO `tbl_print_template` (`id`, `name`, `template_json`, `demo_data`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`) VALUES (6, '销售订单', '{\"tempItems\":[{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":122,\"height\":14,\"left\":500,\"top\":5,\"title\":\"标题\",\"value\":\"销售订单\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":14,\"FontColor\":\"#000000\",\"Bold\":\"1\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"center\",\"ItemType\":\"1\",\"bordered\":false,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":0,\"leftOffset\":0},\"uuid\":\"35205865ddd83246b7aa9b82addbc49b5a7e\"},{\"type\":\"braid-barcode\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":200,\"height\":40,\"left\":920,\"top\":5,\"title\":\"单号条码\",\"name\":\"code\",\"style\":{\"zIndex\":0,\"FontSize\":\"9\",\"ShowBarText\":\"1\",\"CodeType\":\"Code39\",\"ItemType\":\"1\"},\"value\":\"{单号}\",\"uuid\":\"027597a790715443beeae5d06cd8d1f06b60\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":10,\"top\":60,\"title\":\"仓库编号-标题\",\"value\":\"仓库编号：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"387f44812bf5e84fc2a89b8689beb7ae95ff\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":118,\"top\":60,\"title\":\"仓库编号\",\"value\":\"{仓库编号}\",\"name\":\"scCode\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"b7217c3c1571794c4428f5d5823bfb0a4a99\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":286,\"top\":60,\"title\":\"仓库名称-标题\",\"value\":\"仓库名称：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"a400e796d4c955457bc819f8cf6c43d6c19a\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":394,\"top\":60,\"title\":\"仓库名称\",\"value\":\"{仓库名称}\",\"name\":\"scName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"7cf2034a2a4e1b443ffa3d5972bfc322a88e\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":562,\"top\":60,\"title\":\"客户编号-标题\",\"value\":\"客户编号：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"09bc7fd608d8e641df48b4e94b47f05ff923\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":670,\"top\":60,\"title\":\"客户编号\",\"value\":\"{客户编号}\",\"name\":\"customerCode\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"4a08de3bd8296a4ac6ab9f2c5cab79f61584\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":838,\"top\":60,\"title\":\"客户名称-标题\",\"value\":\"客户名称：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"2bcbd47062dffb4d0038afc6ac3e58455eab\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":946,\"top\":60,\"title\":\"客户名称\",\"value\":\"{客户名称}\",\"name\":\"customerName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"c39584ca3946284d908bd758d6dad5a70517\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":10,\"top\":84,\"title\":\"销售员-标题\",\"value\":\"销售员：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"4c9ba4c9e0da3443d2097761f206563a6e31\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":118,\"top\":84,\"title\":\"销售员\",\"value\":\"{销售员}\",\"name\":\"salerName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"a4508027b5bd034c440a063e59b7ee0cc297\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":286,\"top\":84,\"title\":\"操作人-标题\",\"value\":\"操作人：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"09debe4c6886374dbdd847de695a364339aa\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":394,\"top\":84,\"title\":\"操作人\",\"value\":\"{操作人}\",\"name\":\"createBy\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"aea91c8a37984b4d90e8545fa84a823a9e2b\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":562,\"top\":84,\"title\":\"操作时间-标题\",\"value\":\"操作时间：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"b80a43b94128624c56a97c3e88689b6af8d6\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":670,\"top\":84,\"title\":\"操作时间\",\"value\":\"{操作时间}\",\"name\":\"createTime\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"89d3b43387c17e44f798ef2bf220d26bf3e3\"},{\"type\":\"braid-table\",\"isEdit\":0,\"draggable\":true,\"resizable\":true,\"width\":1104,\"height\":60,\"left\":10,\"top\":118,\"title\":\"销售商品明细\",\"value\":\"{details}\",\"defaultValue\":[],\"tabelHtml\":\"\",\"columnsAttr\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"销售数量\",\"value\":\"{销售数量}\",\"name\":\"orderNum\"},{\"title\":\"价格\",\"value\":\"{价格}\",\"name\":\"taxPrice\"},{\"title\":\"销售金额\",\"value\":\"{销售金额}\",\"name\":\"orderAmount\"}],\"columns\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"销售数量\",\"value\":\"{销售数量}\",\"name\":\"orderNum\"},{\"title\":\"价格\",\"value\":\"{价格}\",\"name\":\"taxPrice\"},{\"title\":\"销售金额\",\"value\":\"{销售金额}\",\"name\":\"orderAmount\"}],\"selectCol\":[\"_seq\",\"productCode\",\"productName\",\"skuCode\",\"externalCode\",\"orderNum\",\"taxPrice\",\"orderAmount\"],\"name\":\"details\",\"style\":{\"zIndex\":0,\"Alignment\":\"left\",\"FontSize\":12,\"FontColor\":\"#000000\",\"borderColor\":\"#000000\",\"autoHeight\":true,\"BottomMargin\":20},\"uuid\":\"a54b8d97a637b64fd5f9ca417d7d5211716e\"},{\"type\":\"braid-page\",\"isEdit\":false,\"draggable\":true,\"resizable\":true,\"width\":97,\"height\":20,\"left\":1025,\"top\":770,\"title\":\"分页\",\"curPageStyle\":\"第##页\",\"splitPageStyle\":\"/\",\"totalPageStyle\":\"共##页\",\"name\":\"\",\"style\":{\"zIndex\":0,\"ItemType\":\"1\",\"autoHeight\":false,\"BottomMargin\":5,\"Alignment\":\"right\",\"FontSize\":12,\"FontColor\":\"#000000\"},\"uuid\":\"d6f62ce0a7931e438188be50bc350f99da7d\"}],\"title\":\"零售出库单\",\"pageWidth\":210,\"pageHeight\":297,\"width\":1122,\"height\":793,\"pageDirection\":2}', '{\n \"code\": \"202501190000000003\",\n \"scCode\": \"1\",\n \"scName\": \"测试仓库\",\n \"customerCode\": \"1\",\n \"customerName\": \"测试客户\",\n \"salerName\": \"\",\n \"description\": \"\",\n \"createBy\": \"系统管理员\",\n \"createTime\": \"2025-01-19 22:08:46\",\n \"approveBy\": \"\",\n \"approveTime\": \"\",\n \"details\": [\n {\n \"productCode\": \"11\",\n \"productName\": \"商品222\",\n \"skuCode\": \"41\",\n \"externalCode\": \"51\",\n \"orderNum\": 1,\n \"taxPrice\": 131,\n \"orderAmount\": 131\n }\n ]\n}', '系统管理员', '1', '2025-05-09 22:34:50', '系统管理员', '1', '2025-05-09 22:35:00');
INSERT INTO `tbl_print_template` (`id`, `name`, `template_json`, `demo_data`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`) VALUES (7, '销售出库单', '{\"tempItems\":[{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":122,\"height\":14,\"left\":500,\"top\":5,\"title\":\"标题\",\"value\":\"销售出库单\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":14,\"FontColor\":\"#000000\",\"Bold\":\"1\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"center\",\"ItemType\":\"1\",\"bordered\":false,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":0,\"leftOffset\":0},\"uuid\":\"35205865ddd83246b7aa9b82addbc49b5a7e\"},{\"type\":\"braid-barcode\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":200,\"height\":40,\"left\":920,\"top\":5,\"title\":\"单号条码\",\"name\":\"code\",\"style\":{\"zIndex\":0,\"FontSize\":\"9\",\"ShowBarText\":\"1\",\"CodeType\":\"Code39\",\"ItemType\":\"1\"},\"value\":\"{单号}\",\"uuid\":\"027597a790715443beeae5d06cd8d1f06b60\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":10,\"top\":60,\"title\":\"仓库编号-标题\",\"value\":\"仓库编号：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"387f44812bf5e84fc2a89b8689beb7ae95ff\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":118,\"top\":60,\"title\":\"仓库编号\",\"value\":\"{仓库编号}\",\"name\":\"scCode\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"b7217c3c1571794c4428f5d5823bfb0a4a99\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":286,\"top\":60,\"title\":\"仓库名称-标题\",\"value\":\"仓库名称：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"a400e796d4c955457bc819f8cf6c43d6c19a\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":394,\"top\":60,\"title\":\"仓库名称\",\"value\":\"{仓库名称}\",\"name\":\"scName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"7cf2034a2a4e1b443ffa3d5972bfc322a88e\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":562,\"top\":60,\"title\":\"客户编号-标题\",\"value\":\"客户编号：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"09bc7fd608d8e641df48b4e94b47f05ff923\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":670,\"top\":60,\"title\":\"客户编号\",\"value\":\"{客户编号}\",\"name\":\"customerCode\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"4a08de3bd8296a4ac6ab9f2c5cab79f61584\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":838,\"top\":60,\"title\":\"客户名称-标题\",\"value\":\"客户名称：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"2bcbd47062dffb4d0038afc6ac3e58455eab\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":946,\"top\":60,\"title\":\"客户名称\",\"value\":\"{客户名称}\",\"name\":\"customerName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"c39584ca3946284d908bd758d6dad5a70517\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":10,\"top\":84,\"title\":\"销售员-标题\",\"value\":\"销售员：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"4c9ba4c9e0da3443d2097761f206563a6e31\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":118,\"top\":84,\"title\":\"销售员\",\"value\":\"{销售员}\",\"name\":\"salerName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"a4508027b5bd034c440a063e59b7ee0cc297\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":286,\"top\":84,\"title\":\"操作人-标题\",\"value\":\"操作人：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"09debe4c6886374dbdd847de695a364339aa\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":394,\"top\":84,\"title\":\"操作人\",\"value\":\"{操作人}\",\"name\":\"createBy\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"aea91c8a37984b4d90e8545fa84a823a9e2b\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":562,\"top\":84,\"title\":\"操作时间-标题\",\"value\":\"操作时间：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"b80a43b94128624c56a97c3e88689b6af8d6\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":670,\"top\":84,\"title\":\"操作时间\",\"value\":\"{操作时间}\",\"name\":\"createTime\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"89d3b43387c17e44f798ef2bf220d26bf3e3\"},{\"type\":\"braid-table\",\"isEdit\":0,\"draggable\":true,\"resizable\":true,\"width\":1104,\"height\":60,\"left\":10,\"top\":142,\"title\":\"出库商品明细\",\"value\":\"{details}\",\"defaultValue\":[],\"tabelHtml\":\"\",\"columnsAttr\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"出库数量\",\"value\":\"{出库数量}\",\"name\":\"outNum\"},{\"title\":\"价格\",\"value\":\"{价格}\",\"name\":\"taxPrice\"},{\"title\":\"出库金额\",\"value\":\"{出库金额}\",\"name\":\"outAmount\"}],\"columns\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"出库数量\",\"value\":\"{出库数量}\",\"name\":\"outNum\"},{\"title\":\"价格\",\"value\":\"{价格}\",\"name\":\"taxPrice\"},{\"title\":\"出库金额\",\"value\":\"{出库金额}\",\"name\":\"outAmount\"}],\"selectCol\":[\"_seq\",\"productCode\",\"productName\",\"skuCode\",\"externalCode\",\"outNum\",\"taxPrice\",\"outAmount\"],\"name\":\"details\",\"style\":{\"zIndex\":0,\"Alignment\":\"left\",\"FontSize\":12,\"FontColor\":\"#000000\",\"borderColor\":\"#000000\",\"autoHeight\":true,\"BottomMargin\":20},\"uuid\":\"a54b8d97a637b64fd5f9ca417d7d5211716e\"},{\"type\":\"braid-page\",\"isEdit\":false,\"draggable\":true,\"resizable\":true,\"width\":97,\"height\":20,\"left\":1025,\"top\":770,\"title\":\"分页\",\"curPageStyle\":\"第##页\",\"splitPageStyle\":\"/\",\"totalPageStyle\":\"共##页\",\"name\":\"\",\"style\":{\"zIndex\":0,\"ItemType\":\"1\",\"autoHeight\":false,\"BottomMargin\":5,\"Alignment\":\"right\",\"FontSize\":12,\"FontColor\":\"#000000\"},\"uuid\":\"d6f62ce0a7931e438188be50bc350f99da7d\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":10,\"top\":108,\"title\":\"付款日期-标题\",\"value\":\"付款日期：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"604209e64d1a984bbaabe0ad64ad77f5eeee\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":118,\"top\":108,\"title\":\"付款日期\",\"value\":\"{付款日期}\",\"name\":\"paymentDate\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"e874b94582286747e2a8865a0ded60b4d639\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":838,\"top\":84,\"title\":\"销售订单号-标题\",\"value\":\"销售订单号：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"a4e29827b8e062405258d7f5e7bb535f9dd5\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":946,\"top\":84,\"title\":\"销售订单号\",\"value\":\"{销售订单号}\",\"name\":\"saleOrderCode\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"e7681d4c03d9664ad96b96efc49bd124f871\"}],\"title\":\"销售出库单\",\"pageWidth\":210,\"pageHeight\":297,\"width\":1122,\"height\":793,\"pageDirection\":2}', '{\n \"code\": \"202501190000000004\",\n \"scCode\": \"1\",\n \"scName\": \"测试仓库\",\n \"customerCode\": \"1\",\n \"customerName\": \"测试客户\",\n \"salerName\": \"\",\n \"paymentDate\": \"2025-02-19\",\n \"saleOrderCode\": \"\",\n \"description\": \"\",\n \"createBy\": \"系统管理员\",\n \"createTime\": \"2025-01-19 22:09:55\",\n \"approveBy\": \"系统管理员\",\n \"approveTime\": \"2025-01-19 22:10:01\",\n \"details\": [\n {\n \"productCode\": \"11\",\n \"productName\": \"商品222\",\n \"skuCode\": \"41\",\n \"externalCode\": \"51\",\n \"outNum\": 1,\n \"taxPrice\": 131,\n \"outAmount\": 131\n }\n ]\n}', '系统管理员', '1', '2025-05-09 22:50:02', '系统管理员', '1', '2025-05-09 22:50:13');
INSERT INTO `tbl_print_template` (`id`, `name`, `template_json`, `demo_data`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`) VALUES (8, '销售退货单', '{\"tempItems\":[{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":122,\"height\":14,\"left\":500,\"top\":5,\"title\":\"标题\",\"value\":\"销售退货单\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":14,\"FontColor\":\"#000000\",\"Bold\":\"1\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"center\",\"ItemType\":\"1\",\"bordered\":false,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":0,\"leftOffset\":0},\"uuid\":\"35205865ddd83246b7aa9b82addbc49b5a7e\"},{\"type\":\"braid-barcode\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":200,\"height\":40,\"left\":920,\"top\":5,\"title\":\"单号条码\",\"name\":\"code\",\"style\":{\"zIndex\":0,\"FontSize\":\"9\",\"ShowBarText\":\"1\",\"CodeType\":\"Code39\",\"ItemType\":\"1\"},\"value\":\"{单号}\",\"uuid\":\"027597a790715443beeae5d06cd8d1f06b60\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":10,\"top\":60,\"title\":\"仓库编号-标题\",\"value\":\"仓库编号：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"387f44812bf5e84fc2a89b8689beb7ae95ff\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":118,\"top\":60,\"title\":\"仓库编号\",\"value\":\"{仓库编号}\",\"name\":\"scCode\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"b7217c3c1571794c4428f5d5823bfb0a4a99\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":286,\"top\":60,\"title\":\"仓库名称-标题\",\"value\":\"仓库名称：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"a400e796d4c955457bc819f8cf6c43d6c19a\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":394,\"top\":60,\"title\":\"仓库名称\",\"value\":\"{仓库名称}\",\"name\":\"scName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"7cf2034a2a4e1b443ffa3d5972bfc322a88e\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":562,\"top\":60,\"title\":\"客户编号-标题\",\"value\":\"客户编号：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"09bc7fd608d8e641df48b4e94b47f05ff923\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":670,\"top\":60,\"title\":\"客户编号\",\"value\":\"{客户编号}\",\"name\":\"customerCode\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"4a08de3bd8296a4ac6ab9f2c5cab79f61584\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":838,\"top\":60,\"title\":\"客户名称-标题\",\"value\":\"客户名称：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"2bcbd47062dffb4d0038afc6ac3e58455eab\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":946,\"top\":60,\"title\":\"客户名称\",\"value\":\"{客户名称}\",\"name\":\"customerName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"c39584ca3946284d908bd758d6dad5a70517\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":10,\"top\":84,\"title\":\"销售员-标题\",\"value\":\"销售员：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"4c9ba4c9e0da3443d2097761f206563a6e31\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":118,\"top\":84,\"title\":\"销售员\",\"value\":\"{销售员}\",\"name\":\"salerName\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"a4508027b5bd034c440a063e59b7ee0cc297\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":286,\"top\":84,\"title\":\"操作人-标题\",\"value\":\"操作人：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"09debe4c6886374dbdd847de695a364339aa\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":394,\"top\":84,\"title\":\"操作人\",\"value\":\"{操作人}\",\"name\":\"createBy\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"aea91c8a37984b4d90e8545fa84a823a9e2b\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":562,\"top\":84,\"title\":\"操作时间-标题\",\"value\":\"操作时间：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"b80a43b94128624c56a97c3e88689b6af8d6\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":670,\"top\":84,\"title\":\"操作时间\",\"value\":\"{操作时间}\",\"name\":\"createTime\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"89d3b43387c17e44f798ef2bf220d26bf3e3\"},{\"type\":\"braid-table\",\"isEdit\":0,\"draggable\":true,\"resizable\":true,\"width\":1104,\"height\":60,\"left\":10,\"top\":142,\"title\":\"退货商品明细\",\"value\":\"{details}\",\"defaultValue\":[],\"tabelHtml\":\"\",\"columnsAttr\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"退货数量\",\"value\":\"{退货数量}\",\"name\":\"returnNum\"},{\"title\":\"价格\",\"value\":\"{价格}\",\"name\":\"taxPrice\"},{\"title\":\"退货金额\",\"value\":\"{退货金额}\",\"name\":\"returnAmount\"}],\"columns\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"退货数量\",\"value\":\"{退货数量}\",\"name\":\"returnNum\"},{\"title\":\"价格\",\"value\":\"{价格}\",\"name\":\"taxPrice\"},{\"title\":\"退货金额\",\"value\":\"{退货金额}\",\"name\":\"returnAmount\"}],\"selectCol\":[\"_seq\",\"productCode\",\"productName\",\"skuCode\",\"externalCode\",\"returnNum\",\"taxPrice\",\"returnAmount\"],\"name\":\"details\",\"style\":{\"zIndex\":0,\"Alignment\":\"left\",\"FontSize\":12,\"FontColor\":\"#000000\",\"borderColor\":\"#000000\",\"autoHeight\":true,\"BottomMargin\":20},\"uuid\":\"a54b8d97a637b64fd5f9ca417d7d5211716e\"},{\"type\":\"braid-page\",\"isEdit\":false,\"draggable\":true,\"resizable\":true,\"width\":97,\"height\":20,\"left\":1025,\"top\":770,\"title\":\"分页\",\"curPageStyle\":\"第##页\",\"splitPageStyle\":\"/\",\"totalPageStyle\":\"共##页\",\"name\":\"\",\"style\":{\"zIndex\":0,\"ItemType\":\"1\",\"autoHeight\":false,\"BottomMargin\":5,\"Alignment\":\"right\",\"FontSize\":12,\"FontColor\":\"#000000\"},\"uuid\":\"d6f62ce0a7931e438188be50bc350f99da7d\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":10,\"top\":108,\"title\":\"付款日期-标题\",\"value\":\"付款日期：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"604209e64d1a984bbaabe0ad64ad77f5eeee\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":118,\"top\":108,\"title\":\"付款日期\",\"value\":\"{付款日期}\",\"name\":\"paymentDate\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"e874b94582286747e2a8865a0ded60b4d639\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":108,\"height\":24,\"left\":838,\"top\":84,\"title\":\"销售出库单号-标题\",\"value\":\"销售出库单号：\",\"name\":\"\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"right\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":0},\"uuid\":\"10488b69c261764f0e388a6607267aae769f\"},{\"type\":\"braid-txt\",\"isEdit\":1,\"draggable\":true,\"resizable\":true,\"width\":168,\"height\":24,\"left\":946,\"top\":84,\"title\":\"销售出库单号\",\"value\":\"{销售出库单号}\",\"name\":\"outSheetCode\",\"style\":{\"zIndex\":0,\"FontSize\":12,\"FontColor\":\"#000000\",\"Bold\":\"0\",\"Italic\":\"0\",\"Underline\":\"0\",\"Alignment\":\"left\",\"ItemType\":\"1\",\"bordered\":true,\"intLineStyle\":0,\"intLineWidth\":1,\"topOffset\":4,\"leftOffset\":5},\"uuid\":\"ba426c11fae59f4442a84d29ef5ab38c82ff\"}],\"title\":\"销售退货单\",\"pageWidth\":210,\"pageHeight\":297,\"width\":1122,\"height\":793,\"pageDirection\":2}', '{\n \"code\": \"202501190000000003\",\n \"scCode\": \"1\",\n \"scName\": \"测试仓库\",\n \"customerCode\": \"1\",\n \"customerName\": \"测试客户\",\n \"salerName\": \"\",\n \"paymentDate\": \"2025-02-19\",\n \"outSheetCode\": \"\",\n \"description\": \"\",\n \"createBy\": \"系统管理员\",\n \"createTime\": \"2025-01-19 22:10:44\",\n \"approveBy\": \"\",\n \"approveTime\": \"\",\n \"details\": [\n {\n \"productCode\": \"11\",\n \"productName\": \"商品222\",\n \"skuCode\": \"41\",\n \"externalCode\": \"51\",\n \"returnNum\": 1,\n \"taxPrice\": 131,\n \"returnAmount\": 131\n }\n ]\n}', '系统管理员', '1', '2025-05-09 23:03:03', '系统管理员', '1', '2025-05-09 23:03:35');
INSERT INTO `tbl_print_template_comp` (`id`, `template_id`, `comp_json`) VALUES ('1', 0, '{\"type\":\"braid-txt\"}');
INSERT INTO `tbl_print_template_comp` (`id`, `template_id`, `comp_json`) VALUES ('100', 1, '{\"type\":\"braid-table\",\"isEdit\":0,\"title\":\"采购商品明细\",\"name\":\"details\",\"value\":\"{details}\",\"style\":{},\"tabelHtml\":\"\",\"columnsAttr\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"采购数量\",\"value\":\"{采购数量}\",\"name\":\"purchaseNum\"},{\"title\":\"采购价\",\"value\":\"{采购价}\",\"name\":\"purchasePrice\"},{\"title\":\"采购金额\",\"value\":\"{采购金额}\",\"name\":\"purchaseAmount\"}],\"columns\":[]}');
INSERT INTO `tbl_print_template_comp` (`id`, `template_id`, `comp_json`) VALUES ('101', 2, '{\"type\":\"braid-table\",\"isEdit\":0,\"title\":\"收货商品明细\",\"name\":\"details\",\"value\":\"{details}\",\"style\":{},\"tabelHtml\":\"\",\"columnsAttr\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"收货数量\",\"value\":\"{收货数量}\",\"name\":\"receiveNum\"},{\"title\":\"采购价\",\"value\":\"{采购价}\",\"name\":\"purchasePrice\"},{\"title\":\"收货金额\",\"value\":\"{收货金额}\",\"name\":\"receiveAmount\"}],\"columns\":[]}');
INSERT INTO `tbl_print_template_comp` (`id`, `template_id`, `comp_json`) VALUES ('102', 3, '{\"type\":\"braid-table\",\"isEdit\":0,\"title\":\"退货商品明细\",\"name\":\"details\",\"value\":\"{details}\",\"style\":{},\"tabelHtml\":\"\",\"columnsAttr\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"退货数量\",\"value\":\"{退货数量}\",\"name\":\"returnNum\"},{\"title\":\"退货价\",\"value\":\"{退货价}\",\"name\":\"purchasePrice\"},{\"title\":\"退货金额\",\"value\":\"{退货金额}\",\"name\":\"returnAmount\"}],\"columns\":[]}');
INSERT INTO `tbl_print_template_comp` (`id`, `template_id`, `comp_json`) VALUES ('103', 4, '{\"type\":\"braid-table\",\"isEdit\":0,\"title\":\"出库商品明细\",\"name\":\"details\",\"value\":\"{details}\",\"style\":{},\"tabelHtml\":\"\",\"columnsAttr\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"出库数量\",\"value\":\"{出库数量}\",\"name\":\"outNum\"},{\"title\":\"价格\",\"value\":\"{价格}\",\"name\":\"taxPrice\"},{\"title\":\"出库金额\",\"value\":\"{出库金额}\",\"name\":\"outAmount\"}],\"columns\":[]}');
INSERT INTO `tbl_print_template_comp` (`id`, `template_id`, `comp_json`) VALUES ('104', 5, '{\"type\":\"braid-table\",\"isEdit\":0,\"title\":\"退货商品明细\",\"name\":\"details\",\"value\":\"{details}\",\"style\":{},\"tabelHtml\":\"\",\"columnsAttr\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"退货数量\",\"value\":\"{退货数量}\",\"name\":\"returnNum\"},{\"title\":\"价格\",\"value\":\"{价格}\",\"name\":\"taxPrice\"},{\"title\":\"退货金额\",\"value\":\"{退货金额}\",\"name\":\"returnAmount\"}],\"columns\":[]}');
INSERT INTO `tbl_print_template_comp` (`id`, `template_id`, `comp_json`) VALUES ('105', 6, '{\"type\":\"braid-table\",\"isEdit\":0,\"title\":\"销售商品明细\",\"name\":\"details\",\"value\":\"{details}\",\"style\":{},\"tabelHtml\":\"\",\"columnsAttr\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"销售数量\",\"value\":\"{销售数量}\",\"name\":\"orderNum\"},{\"title\":\"价格\",\"value\":\"{价格}\",\"name\":\"taxPrice\"},{\"title\":\"销售金额\",\"value\":\"{销售金额}\",\"name\":\"orderAmount\"}],\"columns\":[]}');
INSERT INTO `tbl_print_template_comp` (`id`, `template_id`, `comp_json`) VALUES ('106', 7, '{\"type\":\"braid-table\",\"isEdit\":0,\"title\":\"出库商品明细\",\"name\":\"details\",\"value\":\"{details}\",\"style\":{},\"tabelHtml\":\"\",\"columnsAttr\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"出库数量\",\"value\":\"{出库数量}\",\"name\":\"outNum\"},{\"title\":\"价格\",\"value\":\"{价格}\",\"name\":\"taxPrice\"},{\"title\":\"出库金额\",\"value\":\"{出库金额}\",\"name\":\"outAmount\"}],\"columns\":[]}');
INSERT INTO `tbl_print_template_comp` (`id`, `template_id`, `comp_json`) VALUES ('107', 8, '{\"type\":\"braid-table\",\"isEdit\":0,\"title\":\"退货商品明细\",\"name\":\"details\",\"value\":\"{details}\",\"style\":{},\"tabelHtml\":\"\",\"columnsAttr\":[{\"title\":\"序号\",\"name\":\"_seq\"},{\"title\":\"商品编号\",\"value\":\"{商品编号}\",\"name\":\"productCode\"},{\"title\":\"商品名称\",\"value\":\"{商品名称}\",\"name\":\"productName\"},{\"title\":\"商品SKU编号\",\"value\":\"{商品SKU编号}\",\"name\":\"skuCode\"},{\"title\":\"商品简码\",\"value\":\"{商品简码}\",\"name\":\"externalCode\"},{\"title\":\"退货数量\",\"value\":\"{退货数量}\",\"name\":\"returnNum\"},{\"title\":\"价格\",\"value\":\"{价格}\",\"name\":\"taxPrice\"},{\"title\":\"退货金额\",\"value\":\"{退货金额}\",\"name\":\"returnAmount\"}],\"columns\":[]}');
INSERT INTO `tbl_print_template_comp` (`id`, `template_id`, `comp_json`) VALUES ('2', 0, '{\"type\":\"braid-page\"}');
INSERT INTO `tbl_print_template_comp` (`id`, `template_id`, `comp_json`) VALUES ('3', 0, '{\"type\":\"braid-react\"}');
INSERT INTO `tbl_print_template_comp` (`id`, `template_id`, `comp_json`) VALUES ('4', 0, '{\"type\":\"braid-barcode\"}');