8.9 移动许可的申请和归还接口，不再每次操作SERP或者OA去做更新

背景：自己创建个合同表，做个缓存，不用每次都查企管的数据库（oa或serp）

##一、脚本同步OA或serp


###1.创建表

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for m_contract
-- ----------------------------
DROP TABLE IF EXISTS `m_contract`;
CREATE TABLE `m_contract`  (
  `id` int(32) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `snId` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '序列号id',
  `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '许可模块id',
  `proVersion` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '版本',
  `available` int(1) DEFAULT NULL COMMENT '是否可用',
  `operatePlatform` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '操作平台',
  `kType` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否升级',
  `modelID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '产品模块id',
  `productName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '产品名',
  `moduleNAme` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '模块名',
  `xukeNum` int(32) DEFAULT NULL COMMENT '许可数量',
  `outNumber` int(32) DEFAULT NULL COMMENT '出货数量(不超过许可数量)',
  `ctrID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '企管合同id',
  `ctr_Statu` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '企管合同状态',
  `ctr_StatuName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '企管合同描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

SET FOREIGN_KEY_CHECKS = 1;

2.测试数据

oa:L9311-X5E3V-01K28-DB753-4298Q
serp:B4493-68559-0F41F-E85CA-2A8B2

修复serp的code相同导致同时修改多条数据

3-1、3-4、3-5、3-8

4-1、4-3、

update m_contract set outNumber = 24 where code = 2 and sn = '4DB65-92452-E24E6-F9C88-CBC51' and modelID = '4180';
update m_contract set outNumber = 0 where code = 2 and sn = '4DB65-92452-E24E6-F9C88-CBC51' and modelID = '4189';

update m_contract set outNumber = 49 where code = 2 and sn = '623B2-889B4-95448-DA837-02D50' and modelID = '4180';

update m_contract set outNumber = 104 where code = 2 and sn = '40239-7D428-B84D5-BA44C-4F864' and modelID = '4180';

update m_contract set outNumber = 54 where code = 2 and sn = 'F891A-BE96C-CA4B8-EBDE3-DFA0F' and modelID = '4189';

update m_contract set outNumber = 4 where code = 2 and sn = '9918D-AE6CF-6F4BB-1BB90-DFAC2' and modelID = '4180';