7.29新增许可模块

需求

许可新增：
1）iTablet云许可增加高级版；（安卓\IOS）
2）iMobile开发包增加AR分析组件；（安卓\IOS）
3）新增SuperMap DB Engine的开发和运行，支持文件许可购买、试用许可申请；(云惟英)
4）新增SuperMap DB Server及核产品，支持文件许可购买、试用许可申请；（周强）
5）新增SuperMap DB Client 10i(2020)，支持文件许可购买、试用许可申请；(老胡)

##一、iTablet云许可增加高级版；（安卓\IOS）

1.sql

18003 SuperMap iTablet 10i for iOS 高级版
19003 SuperMap iTablet 10i for Android 高级版

online_timelicensemodule 模块表以前有，只是把名字升了一版

# iTablet云许可增加高级版
update online_timelicenseproduct set status = 1 where id = 10011003;
update online_timelicenseproduct set status = 1 where id = 10010003;


sql把状态0改为1即可

2.旧版页面

以前有

3.新版页面

跟旧版差不多

4.测试购买

没问题

##二、iMobile开发包增加AR分析组件；（安卓\IOS）

1.sql

基础包及包含了 AR分析组件(亚运改过的)

use onlinegishost;
#iMobile Android 开发版 AR分析组件
insert into online_timelicensemodule values
(10308113,null,null,0,1,1,null,'0','0','0','0','0','0','0',10825,2);
#iMobile iOS 开发版 AR分析组件
insert into online_timelicensemodule values
(10309113,null,null,0,1,1,null,'0','0','0','0','0','0','0',10925,2);

insert into timelicenseproduct_to_module values(null,10008002,10308113);
insert into timelicenseproduct_to_module values(null,10009002,10309113);

2.旧版页面

LimitedTimeLicenseModuleResource_en_US.js
LimitedTimeLicenseModuleResource_zh_CN.js

"10308113" : {
        "moduleCode" : "10825",
        "moduleGeneralName" : "基础开发包",
        "moduleName" : "AR分析组件"
    },
"10309113" : {
        "moduleCode" : "10925",
        "moduleGeneralName" : "基础开发包",
        "moduleName" : "AR分析组件"
    },    
    
"10308113" : {
        "moduleCode" : "10825",
        "moduleGeneralName" : "Base Develop package",
        "moduleName" : "AR Analyst"
    },
"10309113" : {
        "moduleCode" : "10925",
        "moduleGeneralName" : "Base Develop package",
        "moduleName" : "AR Analyst"
    },

3.新版页面

跟旧版差不多

4.测试购买

没问题

##三、新增SuperMap DB Engine的开发和运行，支持文件许可购买、试用许可申请；(云惟英)

1.sql

24是java代码枚举控制

# SuperMap DB Engine 开发版
insert into online_timelicenseproduct values(10013001,24,1,'289',8,null,'10.1i','DEVELOPER','WINDOWS');
# SuperMap DB Engine 开发版
insert into online_timelicensemodule values
(10313001,null,null,0,1,1,null,'289','969','2249','3859','6429','11569','17349',10074,0);
# SuperMap DB Engine 运行版
insert into online_timelicenseproduct values(10013002,24,1,'399',8,null,'10.1i','RUNTIME','WINDOWS');
# SuperMap DB Engine 运行版
insert into online_timelicensemodule values
(10313002,null,null,0,1,1,null,null,null,'399','689','1149','2059','3099',10075,0);
#关联表
insert into timelicenseproduct_to_module(productId,moduleId) values(10013001,10313001),(10013002,10313002);

价格： 
SuperMap DB Engine 开发版
1年 6429   
1周=6429*0.15*0.3=289.305=289
1月=6429*0.15=964.35=969
1季=6429*0.35=2250.15=2249
半年=6429*0.6=3857.4=3859
1年 6429 定价
2年 11569 定价
3年 17349 定价

SuperMap DB Engine 运行版
1年 1149
1季=1149*0.35=402.15=399
半年=1149*0.6=689.4=689
1年 1149 定价
2年 2059 定价
3年 3099 定价

2.旧版页面

staticFiles/js/resources/i18n/LimitedTimeLicenseProductResource_zh_CN.js
staticFiles/js/resources/i18n/LimitedTimeLicenseProductResource_en_US.js
//10i SuperMap DB Engine
    "10013001" : {
        "description" : "",
        "productName" : "SuperMap DB Engine 开发版",
        "detailedIntroLink":"",
        "summary" : "地理空间数据库引擎组件开发许可,提供空间数据库的管理能力，可基于单机Java API或者Spark 分布式 API进行二次开发，对空间数据库进行查询和修改,内置DB Client产品。"
    },
    "10013002" : {
        "description" : "",
        "productName" : "SuperMap DB Engine 运行版",
        "detailedIntroLink":"",
        "summary" : "地理空间数据库引擎组件开发许可,提供空间数据库的管理能力，可基于单机Java API或者Spark 分布式 API进行二次开发，对空间数据库进行查询和修改,内置DB Client产品。"
    },

//10i SuperMap DB Engine
    "10013001" : {
        "description" : "",
        "productName" : "SuperMap DB Engine Develop",
        "detailedIntroLink":"",
        "summary" : "Geospatial database engine component development license that provides spatial database management capabilities, secondary development based on stand-alone Java API or Spark distributed API. It could query and modification of spatial database. The DB Client product is configured internally."
    },
    "10013002" : {
        "description" : "",
        "productName" : "SuperMap DB Engine Runtime",
        "detailedIntroLink":"",
        "summary" : "Geospatial database engine component development license that provides spatial database management capabilities, secondary development based on stand-alone Java API or Spark distributed API. It could query and modification of spatial database. The DB Client product is configured internally."
    }
    
staticFiles/js/resources/i18n/LimitedTimeLicenseModuleResource_zh_CN.js
staticFiles/js/resources/i18n/LimitedTimeLicenseModuleResource_en_US.js
// SuperMap DB Engine
    "10313001" : {
        "moduleCode" : "10074",
        "moduleGeneralName" : "基础平台",
        "moduleName" : "基础平台"
    },
    "10313002" : {
        "moduleCode" : "10075",
        "moduleGeneralName" : "基础平台",
        "moduleName" : "基础平台"
    },
    
     // SuperMap DB Engine
    "10313001" : {
        "moduleCode" : "10074",
        "moduleGeneralName" : "Base Platform",
        "moduleName" : "Base Platform"
    },
    "10313002" : {
        "moduleCode" : "10075",
        "moduleGeneralName" : "Base Platform",
        "moduleName" : "Base Platform"
    },

3.新版页面

4.测试

# SuperMap DB Engine 开发版
params = {"Codes":["10074"],"ProductName":"SuperMap DB Engine","VersionHF":"DEVELOPER","OperatePlatform":"Windows","ProVersion":"10.0","HardwarePlatform":"X64","key":"286cc92783f24a755648a4d3fbf8d2ff1ffd69e95d70ea72da297ea6e7946ab268a47859c2c9b3778e4a949e6a21e0273a33095ae4ea45662949472e106ee1cf"}
# SuperMap DB Engine 运行版
params = {"Codes":["10075"],"ProductName":"SuperMap DB Engine","VersionHF":"RUNTIME","OperatePlatform":"Windows","ProVersion":"10.0","HardwarePlatform":"X64","key":"286cc92783f24a755648a4d3fbf8d2ff1ffd69e95d70ea72da297ea6e7946ab268a47859c2c9b3778e4a949e6a21e0273a33095ae4ea45662949472e106ee1cf"}

##四、新增SuperMap DB Server及核产品，支持文件许可购买、试用许可申请；（周强）

1.sql

#SuperMap DB Server 标准版
insert into online_timelicenseproduct values(10014001,25,1,'1399',6,null,'10.1i','STANDARD','WINDOWS');

#SuperMap DB Server 10i
insert into online_timelicensemodule values
(10314001,null,null,0,1,1,null,'1399','4679','10909','18709','31179','56119','84179',11201,0);
#SuperMap DB Server 10i(32核)
insert into online_timelicensemodule values
(10314002,null,null,0,1,1,null,'1399','4679','10909','18709','31179','56119','84179',11203,1);
#SuperMap DB Server 10i(附加2核)
insert into online_timelicensemodule values
(10314003,null,null,0,1,1,null,'139','469','1099','1879','3134','5642','8462',11204,1);

insert into timelicenseproduct_to_module(productId,moduleId) values(10014001,10314001),(10014001,10314002),(10014001,10314003);

价格： 
#SuperMap DB Server 标准版 （2核cpu）
1年 31179   
1周=31179*0.15*0.3=1403.055=1399 
1月=31179*0.15=4676.85=4679
1季=31179*0.35=10912.5=10909
半年=31179*0.6=18707.4=18709
1年 31179 定价
2年 56119 定价
3年 84179 定价

#SuperMap DB Server 标准版 （32核）
1年 31179   
1周=31179*0.15*0.3=1403.055=1399 
1月=31179*0.15=4676.85=4679
1季=31179*0.35=10912.5=10909
半年=31179*0.6=18707.4=18709
1年 31179 定价
2年 56119 定价
3年 84179 定价

#SuperMap DB Server 标准版 （附加2核）
1年 3134   
1周=3134*0.15*0.5=141.03=139 
1月=3134*0.15=470.1=469
1季=3134*0.35=1096.9=1099
半年=3134*0.6=1880.4=1879
1年 3134 定价
2年 5642 定价
3年 8462 定价

2.旧版页面

staticFiles/js/resources/i18n/LimitedTimeLicenseProductResource_zh_CN.js
staticFiles/js/resources/i18n/LimitedTimeLicenseProductResource_en_US.js
//10i DB Server
"10014001" : {
        "description" : "",
        "productName" : "SuperMap DB Server 标准版",
        "detailedIntroLink":"",
        "summary" : "地理空间数据库服务器,提供地理空间数据发布、浏览、查询统计和编辑等能力。"
    } 
//10i DB Server    
"10014001" : {
        "description" : "",
        "productName" : "SuperMap DB Server Standard",
        "detailedIntroLink":"",
        "summary" : "Geospatial database server, providing geospatial data publishing, browsing, query statistics, editing capabilities and so on."
    } 
    
LimitedTimeLicenseModuleResource_en_US.js
LimitedTimeLicenseModuleResource_zh_CN.js
// SuperMap DB Server
    "10314001" : {
        "moduleCode" : "11201",
        "moduleGeneralName" : "DB Server 标准版",
        "moduleName" : "DB Server 标准版"
    },
    "10314002" : {
        "moduleCode" : "11203",
        "moduleGeneralName" : "DB Server 标准版（32核）",
        "moduleName" : "DB Server 标准版（32核）"
    },
    "10314003" : {
        "moduleCode" : "11204",
        "moduleGeneralName" : "DB Server（附加2核）",
        "moduleName" : "DB Server（附加2核）"
    }

"10314001" : {
        "moduleCode" : "11201",
        "moduleGeneralName" : "DB Server Standard Edition",
        "moduleName" : "DB Server Standard Edition"
    },
    "10314002" : {
        "moduleCode" : "11203",
        "moduleGeneralName" : "DB Server Standard Edition(32 Cores)",
        "moduleName" : "DB Server Standard Edition(32 Cores)"
    },
    "10314003" : {
        "moduleCode" : "11204",
        "moduleGeneralName" : "DB Server Standard Edition(Additional 2 Cores)",
        "moduleName" : "DB Server Standard Edition(Additional 2 Cores)"
    }

3.新版页面

4.测试

params = {"Codes":["11201","11203","11204"],"ProductName":"SuperMap DB Server","VersionHF":"STANDARD","OperatePlatform":"Windows","ProVersion":"10.0","HardwarePlatform":"X64","key":"286cc92783f24a755648a4d3fbf8d2ff1ffd69e95d70ea72da297ea6e7946ab268a47859c2c9b3778e4a949e6a21e0273a33095ae4ea45662949472e106ee1cf"}


params = {"Codes":["10075"],"ProductName":"SuperMap DB Engine","VersionHF":"RUNTIME","OperatePlatform":"Windows","ProVersion":"10.1","HardwarePlatform":"X64","key":"286cc92783f24a755648a4d3fbf8d2ff1ffd69e95d70ea72da297ea6e7946ab268a47859c2c9b3778e4a949e6a21e0273a33095ae4ea45662949472e106ee1cf"}
data = [{"QUOTATIONID":"SM-A-0255-1387-37014","CODE":"10075","QUOTATIONNAME":"SuperMap DB Engine 10i 简体中文运行版（64位Windows版）-运行组件"}]
params2 = {"Ctr_ChgCon":0.01,"ShopName":["SuperMap DB Engine 10i 简体中文运行版（64位Windows版）-运行组件"],"ProductCount":[1],"InvoiceTitle":"","IsInvoice":0,"IndentID":"02-202108041009409400000","ShopID":["SM-A-0255-1387-37014"],"key":"286cc92783f24a755648a4d3fbf8d2ff1ffd69e95d70ea72da297ea6e7946ab268a47859c2c9b3778e4a949e6a21e0273a33095ae4ea45662949472e106ee1cf","Unitprice":[1149.0]}
createContractResult = 1
params3 = {"lpt":"File","lPt":"USB","hardwareID":"","IndentID":"02-202108041009409400000","Software_Num":0,"lat":"NetWork","CanActivateCount":0,"key":"286cc92783f24a755648a4d3fbf8d2ff1ffd69e95d70ea72da297ea6e7946ab268a47859c2c9b3778e4a949e6a21e0273a33095ae4ea45662949472e106ee1cf","flt":"None"}



params = {"Codes":["10074"],"ProductName":"SuperMap DB Engine","VersionHF":"DEVELOPER","OperatePlatform":"Windows","ProVersion":"10.1","HardwarePlatform":"X64","key":"286cc92783f24a755648a4d3fbf8d2ff1ffd69e95d70ea72da297ea6e7946ab268a47859c2c9b3778e4a949e6a21e0273a33095ae4ea45662949472e106ee1cf"}
data = [{"QUOTATIONID":"SM-A-0255-1385-37011","CODE":"10074","QUOTATIONNAME":"SuperMap DB Engine 10i 简体中文开发版（64位Windows版）-开发组件"}]
params2 = {"Ctr_ChgCon":0.01,"ShopName":["SuperMap DB Engine 10i 简体中文开发版（64位Windows版）-开发组件"],"ProductCount":[1],"InvoiceTitle":"","IsInvoice":0,"IndentID":"02-202108041009339330000","ShopID":["SM-A-0255-1385-37011"],"key":"286cc92783f24a755648a4d3fbf8d2ff1ffd69e95d70ea72da297ea6e7946ab268a47859c2c9b3778e4a949e6a21e0273a33095ae4ea45662949472e106ee1cf","Unitprice":[6429.0]}
createContractResult = 1
params3 = {"lpt":"File","lPt":"USB","hardwareID":"","IndentID":"02-202108041009339330000","Software_Num":0,"lat":"NetWork","CanActivateCount":0,"key":"286cc92783f24a755648a4d3fbf8d2ff1ffd69e95d70ea72da297ea6e7946ab268a47859c2c9b3778e4a949e6a21e0273a33095ae4ea45662949472e106ee1cf","flt":"None"}



params = {"Codes":["11201","11203","11204"],"ProductName":"SuperMap DB Server","VersionHF":"STANDARD","OperatePlatform":"Windows","ProVersion":"10.1","HardwarePlatform":"X64","key":"286cc92783f24a755648a4d3fbf8d2ff1ffd69e95d70ea72da297ea6e7946ab268a47859c2c9b3778e4a949e6a21e0273a33095ae4ea45662949472e106ee1cf"}
data = [{"QUOTATIONID":"SM-A-0256-1386-37015","CODE":"11201","QUOTATIONNAME":"SuperMap DB Server 10i 简体中文标准版2物理CPU（64位Windows版）-基础平台"},{"QUOTATIONID":"SM-A-0256-1386-37017","CODE":"11203","QUOTATIONNAME":"SuperMap DB Server 10i 简体中文标准版32核（64位Windows版）-基础平台"},{"QUOTATIONID":"SM-A-0256-1386-37018","CODE":"11204","QUOTATIONNAME":"SuperMap DB Server 10i 简体中文标准版附加2核（64位Windows版）-基础平台"}]
params2 = {"Ctr_ChgCon":0.01,"ShopName":["SuperMap DB Server 10i 简体中文标准版2物理CPU（64位Windows版）-基础平台","SuperMap DB Server 10i 简体中文标准版32核（64位Windows版）-基础平台","SuperMap DB Server 10i 简体中文标准版附加2核（64位Windows版）-基础平台"],"ProductCount":[1,1,1],"InvoiceTitle":"","IsInvoice":0,"IndentID":"02-2021080410151415140000","ShopID":["SM-A-0256-1386-37015","SM-A-0256-1386-37017","SM-A-0256-1386-37018"],"key":"286cc92783f24a755648a4d3fbf8d2ff1ffd69e95d70ea72da297ea6e7946ab268a47859c2c9b3778e4a949e6a21e0273a33095ae4ea45662949472e106ee1cf","Unitprice":[31179.0,31179.0,3134.0]}
createContractResult = 1
params3 = {"lpt":"File","lPt":"USB","hardwareID":"","IndentID":"02-2021080410151415140000","Software_Num":0,"lat":"NetWork","CanActivateCount":0,"key":"286cc92783f24a755648a4d3fbf8d2ff1ffd69e95d70ea72da297ea6e7946ab268a47859c2c9b3778e4a949e6a21e0273a33095ae4ea45662949472e106ee1cf","flt":"None"}


{"lpt":"File","lPt":"USB","hardwareID":"","series":"_10i","IndentID":"02-202108051433013310000","Software_Num":0,"lat":"NetWork","CanActivateCount":0,"key":"286cc92783f24a755648a4d3fbf8d2ff1ffd69e95d70ea72da297ea6e7946ab268a47859c2c9b3778e4a949e6a21e0273a33095ae4ea45662949472e106ee1cf","flt":"None"}

##五、sdk增加 DB Server

最终组成json格式