常量

12079

常量总览

_constant结构

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

_constant 表数据

公司名称

constantKey	constantType
companyName	string

杭州闵尚信息技术有限公司

自定义工资项目

constantKey	constantType
customSalarySubject	object

{
  "totalSalaryContent": [
    "工资",
    "津贴补助",
    "奖金",
    "其他所得"
  ],
  "totalDeductSalaryContent": [
    "考勤扣款",
    "其他扣款"
  ],
  "realPaySalaryAdjustmentContent": [
    "测试下",
    "测试 2"
  ]
}

五险一金配比

constantKey	constantType
defaultMemberInsuranceConfig	object

{
  "endowmentInsurance": {
    "name": "养老保险",
    "paymentBase": 5554,
    "personalRatio": 8,
    "companyRatio": 20,
    "personalPay": "444.32",
    "companyPay": "1110.80"
  },
  "medicalInsurance": {
    "name": "医疗保险",
    "paymentBase": 5554,
    "personalRatio": 22,
    "companyRatio": 8,
    "personalPay": "1221.88",
    "companyPay": "555.40"
  },
  "unemploymentInsurance": {
    "name": "失业保险",
    "paymentBase": 4443,
    "personalRatio": 0.2,
    "companyRatio": 1,
    "personalPay": "8.89",
    "companyPay": "44.43"
  },
  "injuryInsurance": {
    "name": "工伤保险",
    "paymentBase": 5554,
    "personalRatio": 50,
    "companyRatio": 0.5,
    "personalPay": "2777.00",
    "companyPay": "27.77"
  },
  "maternityInsurance": {
    "name": "生育保险",
    "paymentBase": 4444,
    "personalRatio": 0,
    "companyRatio": 0.8,
    "personalPay": "0.00",
    "companyPay": "35.55"
  },
  "housingFund": {
    "name": "住房公积金",
    "paymentBase": 5553,
    "personalRatio": 12,
    "companyRatio": 12,
    "personalPay": "666.36",
    "companyPay": "666.36"
  }
}

辅助项列表

constantKey	constantType
assistList	array

[
  {
    "value": "customer",
    "text": "客户"
  },
  {
    "value": "supplier",
    "text": "供应商"
  },
  {
    "value": "staff",
    "text": "职员"
  },
  {
    "value": "project",
    "text": "项目"
  },
  {
    "value": "depart",
    "text": "部门"
  },
  {
    "value": "cunhuo",
    "text": "存货"
  }
]

凭证模板类型

constantKey	constantType
voucherTemplateType	array

[
  {
    "value": "日常支出",
    "text": "日常支出"
  },
  {
    "value": "采购",
    "text": "采购"
  },
  {
    "value": "销售",
    "text": "销售"
  },
  {
    "value": "工资",
    "text": "工资"
  },
  {
    "value": "税金",
    "text": "税金"
  },
  {
    "value": "折旧和摊销",
    "text": "折旧和摊销"
  }
]

凭证类型

constantKey	constantType
voucherType	array

[
  {
    "value": "普通凭证",
    "text": "普通凭证"
  },
  {
    "value": "结账凭证",
    "text": "结账凭证"
  },
  {
    "value": "日记账凭证",
    "text": "日记账凭证"
  },
  {
    "value": "进项发票",
    "text": "进项发票"
  },
  {
    "value": "销项发票",
    "text": "销项发票"
  },
  {
    "value": "工资凭证",
    "text": "工资凭证"
  }
]

_constant语句

INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'companyName', 'string', '公司名称', '杭州闵尚信息技术有限公司', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (7, 'customSalarySubject', 'object', '自定义工资项目', '{"totalSalaryContent":["工资","津贴补助","奖金","其他所得"],"totalDeductSalaryContent":["考勤扣款","其他扣款"],"realPaySalaryAdjustmentContent":["测试下","测试 2"]}', 'update', 'admin', '系统管理员', '2023-08-19T15:19:32+08:00');
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'defaultMemberInsuranceConfig', 'object', '五险一金配比', '{"endowmentInsurance":{"name":"养老保险","paymentBase":5554,"personalRatio":8,"companyRatio":20,"personalPay":"444.32","companyPay":"1110.80"},"medicalInsurance":{"name":"医疗保险","paymentBase":5554,"personalRatio":22,"companyRatio":8,"personalPay":"1221.88","companyPay":"555.40"},"unemploymentInsurance":{"name":"失业保险","paymentBase":4443,"personalRatio":0.2,"companyRatio":1,"personalPay":"8.89","companyPay":"44.43"},"injuryInsurance":{"name":"工伤保险","paymentBase":5554,"personalRatio":50,"companyRatio":0.5,"personalPay":"2777.00","companyPay":"27.77"},"maternityInsurance":{"name":"生育保险","paymentBase":4444,"personalRatio":0,"companyRatio":0.8,"personalPay":"0.00","companyPay":"35.55"},"housingFund":{"name":"住房公积金","paymentBase":5553,"personalRatio":12,"companyRatio":12,"personalPay":"666.36","companyPay":"666.36"}}', 'jhUpdate', 'admin', '系统管理员', '2023-09-08T12:40:26+08:00');
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'assistList', 'array', '辅助项列表', '[
    {
        "value": "customer",
        "text": "客户"
    },
    {
        "value": "supplier",
        "text": "供应商"
    },
    {
        "value": "staff",
        "text": "职员"
    },
    {
        "value": "project",
        "text": "项目"
    },
    {
        "value": "depart",
        "text": "部门"
    },
        {
        "value": "cunhuo",
        "text": "存货"
    }
]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (10, 'voucherTemplateType', 'array', '凭证模板类型', '[
    {
        "value": "日常支出",
        "text": "日常支出"
    },
    {
        "value": "采购",
        "text": "采购"
    },
    {
        "value": "销售",
        "text": "销售"
    },
    {
        "value": "工资",
        "text": "工资"
    },
    {
        "value": "税金",
        "text": "税金"
    },
    {
        "value": "折旧和摊销",
        "text": "折旧和摊销"
    }
]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'voucherType', 'array', '凭证类型', '[
    {
        "value": "普通凭证",
        "text": "普通凭证"
    },
    {
        "value": "结账凭证",
        "text": "结账凭证"
    },
    {
        "value": "日记账凭证",
        "text": "日记账凭证"
    },
    {
        "value": "进项发票",
        "text": "进项发票"
    },
    {
        "value": "销项发票",
        "text": "销项发票"
    },
    {
        "value": "工资凭证",
        "text": "工资凭证"
    }
]', 'insert', NULL, NULL, NULL);