江湖数字化平台
登录

常量

12114

常量总览

_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 = 24 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '常量表; 软删除未启用;'

_constant 表数据

资产科目列表

  • constantKey：financeSubjectList

  • constantType：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：depreciationMethodList

  • constantType：object

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

null

  • constantKey：companyTitle

  • constantType：null

  1. 昆明航成经贸有限公司销售单

null

  • constantKey：companyName

  • constantType：null

  1. 昆明航成经贸有限公司

null

  • constantKey：inventoryTitle

  • constantType：null

  1. 昆明航成经贸有限公司采购入库单

null

  • constantKey：saleReturnTitle

  • constantType：null

  1. 昆明航成经贸有限公司销售退货单

null

  • constantKey：purchaseReturnTitle

  • constantType：null

  1. 昆明航成经贸有限公司采购退货单

null

  • constantKey：warehouseInventoryInTitle

  • constantType：null

  1. 昆明航成经贸有限公司入库单

仓库列表

  • constantKey：warehouse

  • constantType：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：printConfig

  • constantType：object

  1. {
  2.   "inventoryIn": {
  3.     "documentCreator": "刘娜",
  4.     "shipper": "练郁琨"
  5.   },
  6.   "inventoryOut": {
  7.     "documentCreator": "雷继武",
  8.     "shipper": "李成"
  9.   }
  10. }

支付账户

  • constantKey：paymentAccount

  • constantType：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. ]

null

  • constantKey：purchaseReturnInventoryOutTitle

  • constantType：null

  1. 昆明航成经贸有限公司采购退货出库单

_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 (5, 'companyTitle', NULL, NULL, '昆明航成经贸有限公司销售单', 'insert', NULL, NULL, NULL);
  4. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'companyName', NULL, NULL, '昆明航成经贸有限公司', 'insert', NULL, NULL, NULL);
  5. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (7, 'inventoryTitle', NULL, NULL, '昆明航成经贸有限公司采购入库单', 'insert', NULL, NULL, NULL);
  6. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'saleReturnTitle', NULL, NULL, '昆明航成经贸有限公司销售退货单', 'insert', NULL, NULL, NULL);
  7. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'purchaseReturnTitle', NULL, NULL, '昆明航成经贸有限公司采购退货单', 'insert', NULL, NULL, NULL);
  8. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'warehouseInventoryInTitle', NULL, NULL, '昆明航成经贸有限公司入库单', 'insert', NULL, NULL, NULL);
  9. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (20, 'warehouse', 'array', '仓库列表', '[
  10.     {
  11.         "warehouseName": "仓库1",
  12.         "stockList": [
  13.             "货架1",
  14.             "货架2"
  15.         ]
  16.     },
  17.     {
  18.         "warehouseName": "冷库1",
  19.         "stockList": [
  20.             "货架3",
  21.             "货架4"
  22.         ]
  23.     }
  24. ]', 'insert', NULL, NULL, NULL);
  25. 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);
  26. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (22, 'paymentAccount', 'array', '支付账户', '[
  27.     {
  28.         "accountName": "公司账户1",
  29.         "accountNum": "44xxxxx",
  30.         "accountType": "银行账户",
  31.         "accountBankName": "中国银行",
  32.         "accountBranchBankName": "朝阳分行"
  33.     },
  34.     {
  35.         "accountName": "公司账户2",
  36.         "accountNum": "44xxxxx",
  37.         "accountType": "银行账户",
  38.         "accountBankName": "中国银行",
  39.         "accountBranchBankName": "朝阳分行"
  40.     },
  41.     {
  42.         "accountName": "微信账户",
  43.         "accountNum": "44xxxxx",
  44.         "accountType": "微信",
  45.         "accountBankName": "",
  46.         "accountBranchBankName": ""
  47.     }
  48. ]', 'insert', NULL, NULL, NULL);
  49. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (23, 'purchaseReturnInventoryOutTitle', NULL, NULL, '昆明航成经贸有限公司采购退货出库单', 'insert', NULL, NULL, NULL);