常量

12144

常量总览

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

_constant 表数据

人员

• constantKey：user

• constantType：array

[
  {
    "value": "王语嫣",
    "text": "王语嫣"
  },
  {
    "value": "张无忌",
    "text": "张无忌"
  }
]

线索来源

• constantKey：leadSource

• constantType：array

[
  {
    "value": "促销",
    "text": "促销"
  },
  {
    "value": "搜索引擎",
    "text": "搜索引擎"
  },
  {
    "value": "广告",
    "text": "广告"
  }
]

客户行业

• constantKey：customerIndustry

• constantType：array

[
  {
    "value": "金融",
    "text": "金融"
  },
  {
    "value": "商业",
    "text": "商业"
  }
]

客户级别

• constantKey：customerLevel

• constantType：array

[
  {
    "value": "普通客户",
    "text": "普通客户"
  },
  {
    "value": "重要客户",
    "text": "重要客户"
  }
]

放入线索池的理由

• constantKey：putIntoLeadSeaReason

• constantType：array

[
  {
    "value": "联系不上客户",
    "text": "联系不上客户"
  },
  {
    "value": "客户暂无需求",
    "text": "客户暂无需求"
  }
]

跟进方式

• constantKey：followUpType

• constantType：array

[
  {
    "value": "打电话",
    "text": "打电话"
  },
  {
    "value": "见面拜访",
    "text": "见面拜访"
  }
]

客户来源

• constantKey：customerSource

• constantType：array

[
  {
    "value": "促销",
    "text": "促销"
  },
  {
    "value": "搜索引擎",
    "text": "搜索引擎"
  },
  {
    "value": "广告",
    "text": "广告"
  }
]

放入客户公海的理由

• constantKey：putIntoCustomerSeaReason

• constantType：array

[
  {
    "value": "联系不上客户",
    "text": "联系不上客户"
  },
  {
    "value": "客户暂无需求",
    "text": "客户暂无需求"
  }
]

性别

• constantKey：gender

• constantType：array

[
  {
    "value": "女",
    "text": "女"
  },
  {
    "value": "男",
    "text": "男"
  }
]

客户

• constantKey：customer

• constantType：array

[
  {
    "value": "先声药业",
    "text": "先声药业"
  },
  {
    "value": "辉瑞药业",
    "text": "辉瑞药业"
  }
]

商机状态组

• constantKey：businessType

• constantType：array

[
  {
    "value": "默认状态组",
    "text": "默认状态组"
  }
]

合同类型

• constantKey：contractType

• constantType：array

[
  {
    "value": "直销合同",
    "text": "直销合同"
  },
  {
    "value": "服务合同",
    "text": "服务合同"
  }
]

合同

• constantKey：contract

• constantType：array

[
  {
    "value": "1月原料采购",
    "text": "1月原料采购"
  },
  {
    "value": "2月原料采购",
    "text": "2月原料采购"
  }
]

回款方式

• constantKey：receivablesMethod

• constantType：array

[
  {
    "value": "支票",
    "text": "支票"
  },
  {
    "value": "现金",
    "text": "现金"
  }
]

开票类型

• constantKey：invoiceType

• constantType：array

[
  {
    "value": "增值税专用发票",
    "text": "增值税专用发票"
  },
  {
    "value": "增值税普通发票",
    "text": "增值税普通发票"
  }
]

回访形式

• constantKey：visitMethod

• constantType：array

[
  {
    "value": "打电话",
    "text": "打电话"
  },
  {
    "value": "见面拜访",
    "text": "见面拜访"
  }
]

客户满意度

• constantKey：satisficing

• constantType：array

[
  {
    "value": "很满意",
    "text": "很满意"
  },
  {
    "value": "一般",
    "text": "一般"
  }
]

产品类型

• constantKey：productType

• constantType：array

[
  {
    "value": "默认",
    "text": "默认"
  }
]

活动关联对象

• constantKey：targetAudience

• constantType：array

[
  {
    "value": "客户",
    "text": "客户"
  },
  {
    "value": "线索",
    "text": "线索"
  }
]

活动类型

• constantKey：marketingType

• constantType：array

[
  {
    "value": "广告",
    "text": "广告"
  },
  {
    "value": "营销",
    "text": "营销"
  }
]

是否

• constantKey：yesOrNo

• constantType：array

[
  {
    "value": "是",
    "text": "是"
  },
  {
    "value": "否",
    "text": "否"
  }
]

线索池

• constantKey：leadSea

• constantType：array

[
  {
    "value": "线索池A",
    "text": "线索池A"
  },
  {
    "value": "线索池B",
    "text": "线索池B"
  }
]

_constant语句

INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'user', 'array', '人员', '[{"value": "王语嫣", "text": "王语嫣"}, {"value": "张无忌", "text": "张无忌"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'leadSource', 'array', '线索来源', '[{"value": "促销", "text": "促销"}, {"value": "搜索引擎", "text": "搜索引擎"}, {"value": "广告", "text": "广告"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'customerIndustry', 'array', '客户行业', '[{"value": "金融", "text": "金融"}, {"value": "商业", "text": "商业"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (4, 'customerLevel', 'array', '客户级别', '[{"value": "普通客户", "text": "普通客户"}, {"value": "重要客户", "text": "重要客户"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (5, 'putIntoLeadSeaReason', 'array', '放入线索池的理由', '[{"value": "联系不上客户", "text": "联系不上客户"}, {"value": "客户暂无需求", "text": "客户暂无需求"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'followUpType', 'array', '跟进方式', '[{"value": "打电话", "text": "打电话"}, {"value": "见面拜访", "text": "见面拜访"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (7, 'customerSource', 'array', '客户来源', '[{"value": "促销", "text": "促销"}, {"value": "搜索引擎", "text": "搜索引擎"}, {"value": "广告", "text": "广告"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'putIntoCustomerSeaReason', 'array', '放入客户公海的理由', '[{"value": "联系不上客户", "text": "联系不上客户"}, {"value": "客户暂无需求", "text": "客户暂无需求"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'gender', 'array', '性别', '[{"value": "女", "text": "女"}, {"value": "男", "text": "男"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (10, 'customer', 'array', '客户', '[{"value": "先声药业", "text": "先声药业"}, {"value": "辉瑞药业", "text": "辉瑞药业"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'businessType', 'array', '商机状态组', '[{"value": "默认状态组", "text": "默认状态组"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'contractType', 'array', '合同类型', '[{"value": "直销合同", "text": "直销合同"}, {"value": "服务合同", "text": "服务合同"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'contract', 'array', '合同', '[{"value": "1月原料采购", "text": "1月原料采购"}, {"value": "2月原料采购", "text": "2月原料采购"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (14, 'receivablesMethod', 'array', '回款方式', '[{"value": "支票", "text": "支票"}, {"value": "现金", "text": "现金"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (15, 'invoiceType', 'array', '开票类型', '[{"value": "增值税专用发票", "text": "增值税专用发票"}, {"value": "增值税普通发票", "text": "增值税普通发票"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (16, 'visitMethod', 'array', '回访形式', '[{"value": "打电话", "text": "打电话"}, {"value": "见面拜访", "text": "见面拜访"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (17, 'satisficing', 'array', '客户满意度', '[{"value": "很满意", "text": "很满意"}, {"value": "一般", "text": "一般"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (18, 'productType', 'array', '产品类型', '[{"value": "默认", "text": "默认"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (19, 'targetAudience', 'array', '活动关联对象', '[{"value": "客户", "text": "客户"}, {"value": "线索", "text": "线索"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (20, 'marketingType', 'array', '活动类型', '[{"value": "广告", "text": "广告"}, {"value": "营销", "text": "营销"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (21, 'yesOrNo', 'array', '是否', '[{"value": "是", "text": "是"}, {"value": "否", "text": "否"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (22, 'leadSea', 'array', '线索池', '[{"value": "线索池A", "text": "线索池A"}, {"value": "线索池B", "text": "线索池B"}]', 'insert', NULL, NULL, NULL);