江湖数字化平台
登录

常量

12076

常量总览

_constant结构

  1. CREATE TABLE `_constant` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `constantKey` varchar(255)  DEFAULT NULL,
  4.   `constantType` varchar(255)  DEFAULT NULL COMMENT '常量类型; object, array',
  5.   `desc` varchar(255)  DEFAULT NULL COMMENT '描述',
  6.   `constantValue` text  COMMENT '常量内容; object, array',
  7.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  8.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  9.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  10.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  11.   PRIMARY KEY (`id`) USING BTREE
  12. ) ENGINE = InnoDB AUTO_INCREMENT = 23 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '常量表; 软删除未启用;'

_constant 表数据

资产科目列表

constantKey constantType
financeSubjectList object 
  1. [
  2.   {
  3.     "subjectId": "1601",
  4.     "subjectName": "固定资产"
  5.   },
  6.   {
  7.     "subjectId": "1602",
  8.     "subjectName": "累计折旧"
  9.   },
  10.   {
  11.     "subjectId": "1606",
  12.     "subjectName": "固定资产清理"
  13.   },
  14.   {
  15.     "subjectId": "5602",
  16.     "subjectName": "管理费用"
  17.   }
  18. ]

折旧方法

constantKey constantType
depreciationMethodList object 
  1. [
  2.   {
  3.     "methodId": "不折旧",
  4.     "methodName": "不折旧"
  5.   },
  6.   {
  7.     "methodId": "平均年限法",
  8.     "methodName": "平均年限法"
  9.   }
  10. ]

部门列表

constantKey constantType
deptList array 
  1. [
  2.   {
  3.     "deptId": "10001",
  4.     "deptName": "部门1"
  5.   },
  6.   {
  7.     "deptId": "10002",
  8.     "deptName": "部门2"
  9.   }
  10. ]

companyTitle

constantKey constantType
companyTitle null 
  1. xxx公司销售单

companyName

constantKey constantType
companyName null 
  1. xxx公司

inventoryTitle

constantKey constantType
inventoryTitle null 
  1. xxx公司采购入库单

saleReturnTitle

constantKey constantType
saleReturnTitle null 
  1. xxx公司销售退货单

purchaseReturnTitle

constantKey constantType
purchaseReturnTitle null 
  1. xxx限公司采购退货单

warehouseInventoryInTitle

constantKey constantType
warehouseInventoryInTitle null 
  1. xxx公司入库单

仓库列表

constantKey constantType
warehouse array 
  1. [
  2.   {
  3.     "warehouseName": "仓库1",
  4.     "stockList": [
  5.       "货架1",
  6.       "货架2"
  7.     ]
  8.   },
  9.   {
  10.     "warehouseName": "冷库1",
  11.     "stockList": [
  12.       "货架3",
  13.       "货架4"
  14.     ]
  15.   }
  16. ]

打印配置

constantKey constantType
printConfig object 
  1. {
  2.   "inventoryIn": {
  3.     "documentCreator": "小刘",
  4.     "shipper": "小张"
  5.   },
  6.   "inventoryOut": {
  7.     "documentCreator": "小刘",
  8.     "shipper": "小张"
  9.   }
  10. }

支付账户

constantKey constantType
paymentAccount array 
  1. [
  2.   {
  3.     "accountName": "公司账户1",
  4.     "accountNum": "44xxxxx",
  5.     "accountType": "银行账户",
  6.     "accountBankName": "中国银行",
  7.     "accountBranchBankName": "朝阳分行"
  8.   },
  9.   {
  10.     "accountName": "公司账户2",
  11.     "accountNum": "44xxxxx",
  12.     "accountType": "银行账户",
  13.     "accountBankName": "中国银行",
  14.     "accountBranchBankName": "朝阳分行"
  15.   },
  16.   {
  17.     "accountName": "微信账户",
  18.     "accountNum": "44xxxxx",
  19.     "accountType": "微信",
  20.     "accountBankName": "",
  21.     "accountBranchBankName": ""
  22.   }
  23. ]

_constant语句

  1. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'financeSubjectList', 'object', '资产科目列表', '[{"subjectId": "1601", "subjectName": "固定资产"},{"subjectId": "1602", "subjectName": "累计折旧"},{"subjectId": "1606", "subjectName": "固定资产清理"},{"subjectId": "5602", "subjectName": "管理费用"}]', 'insert', NULL, NULL, NULL);
  2. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'depreciationMethodList', 'object', '折旧方法', '[{"methodId": "不折旧", "methodName": "不折旧"},{"methodId": "平均年限法", "methodName": "平均年限法"}]', 'insert', NULL, NULL, NULL);
  3. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'deptList', 'array', '部门列表', '[{"deptId": "10001", "deptName": "部门1"},{"deptId": "10002", "deptName": "部门2"}]', 'insert', NULL, NULL, NULL);
  4. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (5, 'companyTitle', NULL, NULL, 'xxx公司销售单', 'insert', NULL, NULL, NULL);
  5. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'companyName', NULL, NULL, 'xxx公司', 'insert', NULL, NULL, NULL);
  6. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (7, 'inventoryTitle', NULL, NULL, 'xxx公司采购入库单', 'insert', NULL, NULL, NULL);
  7. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'saleReturnTitle', NULL, NULL, 'xxx公司销售退货单', 'insert', NULL, NULL, NULL);
  8. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'purchaseReturnTitle', NULL, NULL, 'xxx限公司采购退货单', 'insert', NULL, NULL, NULL);
  9. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'warehouseInventoryInTitle', NULL, NULL, 'xxx公司入库单', 'insert', NULL, NULL, NULL);
  10. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (20, 'warehouse', 'array', '仓库列表', '[
  11.     {
  12.         "warehouseName": "仓库1",
  13.         "stockList": [
  14.             "货架1",
  15.             "货架2"
  16.         ]
  17.     },
  18.     {
  19.         "warehouseName": "冷库1",
  20.         "stockList": [
  21.             "货架3",
  22.             "货架4"
  23.         ]
  24.     }
  25. ]', 'insert', NULL, NULL, NULL);
  26. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (21, 'printConfig', 'object', '打印配置', '{"inventoryIn": {"documentCreator": "小刘", "shipper": "小张"}, "inventoryOut": {"documentCreator": "小刘", "shipper": "小张"}}', 'insert', NULL, NULL, NULL);
  27. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (22, 'paymentAccount', 'array', '支付账户', '[
  28.     {
  29.         "accountName": "公司账户1",
  30.         "accountNum": "44xxxxx",
  31.         "accountType": "银行账户",
  32.         "accountBankName": "中国银行",
  33.         "accountBranchBankName": "朝阳分行"
  34.     },
  35.     {
  36.         "accountName": "公司账户2",
  37.         "accountNum": "44xxxxx",
  38.         "accountType": "银行账户",
  39.         "accountBankName": "中国银行",
  40.         "accountBranchBankName": "朝阳分行"
  41.     },
  42.     {
  43.         "accountName": "微信账户",
  44.         "accountNum": "44xxxxx",
  45.         "accountType": "微信",
  46.         "accountBankName": "",
  47.         "accountBranchBankName": ""
  48.     }
  49. ]', 'insert', NULL, NULL, NULL);