def getFeebody(fee):
insuranceType = fee.get("insuranceType", {})
# endDate = JQ_fTInsrncBgnTm = fee.get("endDate", "")
'''
if endDate != "":
# 保险结束时间与当前时间比较
datestr = compare_date(endDate, utils.getlatedate(0))
TLastSaliEndDate = ""
SY_fTInsrncBgnTm = utils.getlatedate(1, datestr) + ' 00:00:00' # 保险起止期(商)
SY_fTInsrncEndTm = utils.getlatedate(365, datestr) + " 23:59:59" # 保险起止期(商)
JQ_fTInsrncBgnTm = utils.getlatedate(1, datestr) + " 00:00:00" # 保险起止期(交)
JQ_fTInsrncEndTm = utils.getlatedate(365, datestr) + " 23:59:59" # 保险起止期(交)
else:
TLastSaliEndDate = utils.getlatedate(0) ##当前日期
SY_fTInsrncBgnTm = utils.getlatedate(1) + ' 00:00:00' # 保险起止期(商)
SY_fTInsrncEndTm = utils.getlatedate(365) + " 23:59:59" # 保险起止期(商)
JQ_fTInsrncBgnTm = utils.getlatedate(1) + " 00:00:00" # 保险起止期(交)
JQ_fTInsrncEndTm = utils.getlatedate(365) + " 23:59:59" # 保险起止期(交)
'''
SY_fTInsrncBgnTm = fee.get("syStart",
utils.getlatedate(1)) + ' 00:00:00' # 保险起止期(商)
SY_fTInsrncEndTm = utils.getlatedate(
364,
SY_fTInsrncBgnTm.split(" ")[0]) + " 23:59:59" # 保险起止期(商)
JQ_fTInsrncBgnTm = fee.get("jqStart",
utils.getlatedate(1)) + " 00:00:00" # 保险起止期(交)
JQ_fTInsrncEndTm = utils.getlatedate(
364,
SY_fTInsrncBgnTm.split(" ")[0]) + " 23:59:59" # 保险起止期(交)
JQ__fCTmSysCde = "365" # 默认间隔
SY__fCTmSysCde = "365" # 默认间隔
fTOprTm = fTAppTm = utils.getlatedate(0) ##当前日期
fCOprCde = "ex_fanglulu001" # 用户名
JQgCVhlTyp = fee['JQgCVhlTyp']
SYgCVhlTyp = fee['SYgCVhlTyp']
gNNewPurchaseTaxValue = fee['gNNewPurchaseTaxValue'] # 新车购置价(含税)
gNKindredPrice = fee['gNKindredPrice'] # 类比价格
gNKindredPriceTax = fee['gNKindredPriceTax'] # 类比价(含税)
gNNewPurchaseValue = fee['gNNewPurchaseValue'] # >新车购置价
gNDiscussActualValue = fee['gNDiscussActualValue'] # 协商实际价值
gCFrmNo = gCVin = fee['gCFrmNo'] # 车架号
gCMonDespRate = fee['gCMonDespRate'] # 月折旧率
gNActualValue = fee['gNActualValue'] # <!-- 车辆实际价值 -->
gNOfferPurChasePriceMax = fee['gNOfferPurChasePriceMax'] # 新车购置价浮动上限
gNOfferPurChasePriceMin = fee['gNOfferPurChasePriceMin'] # 新车购置价浮动下
gCIndustryModelCode = fee['gCIndustryModelCode'] # 行业车型编码
gCIndustryModelName = fee['gCIndustryModelName'] # 行业车型名称
gCNoticeType = fee['gCNoticeType'] # 行业公告车型
gCProdPlace = "0" # 系别名称"0";//国产 "1";//进口 "2";//合资 fee['gCProdPlace']=
gCFamilyCode = fee['gCFamilyCode'] # 车系编码
gCFamilyName = fee['gCFamilyName'] # 车系名称
gCFstRegYm = fee['gCFstRegYm'] # 初登日期
gCModelNme = fee['gCModelNme'] # 车型名称
gCBrandId = fee['gCBrandId']
gCModelCde = fee['gCModelCde'] # 精友车型代码
gCSearchCode = fee['gCSearchCode'] # code查询码
gCValidateCode = fee['gCValidateCode'] # 验证码
gCPlateNo = fee['gCPlateNo'] # 车牌
gCEngNo = fee['gCEngNo'] # 发动机
gNDisplacement = NExhaustCapacity = fee['gNDisplacement'] # 排气量
gCPlateTyp = fee['gCPlateTyp'] # 号牌种类
try:
gCCarAge = calc_user_years(SY_fTInsrncBgnTm.split(" ")[0], gCFstRegYm)
fee['gCCarAge'] = gCCarAge
except:
fee['gCCarAge'] = gCCarAge = "306007"
# 车龄等级???????????????????????????
gNSeatNum = fee['gNSeatNum'] # 座位数
gNPoWeight = fee['gNPoWeight'] # 整备质量
gNTonage = fee['RVehlcleTonnage']
# 机动车损失保险（主险）#保额-----------------------------------------
lNVhlActVal = lNAmt_036001 = fee['lNVhlActVal'] # 机动车损失保险（主险）#保额
fee['lNDeductible_036001'] = lNDeductible_036001 = "2000" # 免赔额
fee['lNDductRate_036001'] = lNDductRate_036001 = "0.15" # http://carply.cic.cn/pcis/policy/universal/quickapp/vhl_quick_offer.jsp?isOffer=1&prodNo=0360&dptCde=32010101&CUnionMrk=0&id=479A78C22656FB9CAFE2C29B6280C930
# 玻璃单独破碎险##################################################
# fee['lNAmt_036002']=lNAmt_036002="036002" #玻璃单独破碎险
# fee['lNAmt_036002']=lNAmt_036002=lNIndemLmt_036002="500000"
# fee['lCIndemLmtLvl_036002']=lCIndemLmtLvl_036002="306006009" #50万
# fee['lNDductRate__036002']=lNDductRate__036002="0.15"
####################机动车车上人员责任保险（司机）###############
# fee['lNDductRate_036003']=lNDductRate_036003="0.15"
####################机动车车上人员责任保险（乘客）###############
lNLiabDaysLmt_036004 = int(fee['gNSeatNum']) - 1 # 座位数-1
######################机动车全车盗窃保险（主险）</################
lNVhlActVal_036005 = lNAmt_036005 = fee['lNVhlActVal_036005']
# fee['lNDductRate_036005']=lNDductRate_036005="0.2"
########################机动车交通事故强制责任险@#####################
# fee['lNAmt_033201']=lNAmt_033201='122000'
########玻璃单独破碎险
fee['_l_s30'] = _l_s30 = "303011001" # 国产
# 自燃损失险
lNVhlActVal_036007 = NAmt_036007 = fee['lNVhlActVal_036007'] # 自燃损失险
# fee['lNDductRate_036007']=lNDductRate_036007="0.2"
##########发动机涉水损失险#############
###############车身划痕损失险##############
# fee['lNAmt_036013']=lNAmt_036013="2000"
# fee['lCIndemLmtLvl_306013']=lCIndemLmtLvl_306013="N03001001" #// 2000元
# lNDductRate_306013="0.15"
###交通违法次数
hCAppNme = iCInsuredNme = jCOwnerNme = fee['hCAppNme']
jCGender = fee['jCGender'] # "1061"#男
jCOwnerAge = fee['jCOwnerAge'] # ="341060"#年龄阶段
# fee['NExhaustCapacity']=NExhaustCapacity="2.354" #排气量
NCurbWt = fee['NCurbWt'] # 整备质量(吨)
CTaxItemCde = '398014'
gCRegVhlTyp = gCCardDetail = fee['gCRegVhlTyp'] # ='K33'
"""
PHCC_VHL_CARAGE_341023="341023";//1年以下
PHCC_VHL_CARAGE_341024="341024";// 1-2年
PHCC_VHL_CARAGE_341025="341025";// 2-6年
PHCC_VHL_CARAGE_341026="341026";// 6年以上
PHCC_VHL_CARAGE_341027="341027";// 2年以下
PHCC_VHL_CARAGE_341029="341029";// 2-3年
PHCC_VHL_CARAGE_341030="341030";// 3-4年
PHCC_VHL_CARAGE_341031="341031";// 4年以上
"""
# http://carply.cic.cn/pcis/core/js/compress/vhl_offer_app.js?version=704557
# 9900行 判断税目
if int(gNSeatNum) <= 9 and int(float(gNDisplacement) * 1000) <= 1000:
CTaxItemCde = "398013" # ["398013", "乘用车9人（含）以下排量1.0升（含）以下的"]
elif int(gNSeatNum) <= 9 and int(
float(gNDisplacement) * 1000) > 1000 and int(
float(gNDisplacement) * 1000) <= 1600:
CTaxItemCde = "398014" # ["398014", "乘用车9人（含）以下排量1.0升以上至1.6升（含）的"]);
elif int(gNSeatNum) <= 9 and int(
float(gNDisplacement) * 1000) > 1600 and int(
float(gNDisplacement) * 1000) <= 2000:
CTaxItemCde = "398015" # ["398015", "乘用车9人（含）以下排量1.6升以上至2.0升（含）的"]);
elif int(gNSeatNum) <= 9 and int(
float(gNDisplacement) * 1000) > 2000 and int(
float(gNDisplacement) * 1000) <= 2500:
CTaxItemCde = "398016" # ["398016", "乘用车9人（含）以下排量2.0升以上至2.5升（含）的"]);
elif int(gNSeatNum) <= 9 and int(
float(gNDisplacement) * 1000) > 2500 and int(
float(gNDisplacement) * 1000) <= 3000:
CTaxItemCde = "398017" # ["398017", "乘用车9人（含）以下排量2.5升以上至3.0升（含）的"]);
elif int(gNSeatNum) <= 9 and int(
float(gNDisplacement) * 1000) > 3000 and int(
float(gNDisplacement) * 1000) <= 4000:
CTaxItemCde = "398018" # ["398017", "乘用车9人（含）以下排量2.5升以上至3.0升（含）的"]);
elif int(gNSeatNum) <= 9 and int(float(gNDisplacement) * 1000) > 4000:
CTaxItemCde = "398019" # ["398017", "乘用车9人（含）以下排量2.5升以上至3.0升（含）的"]);
elif int(gNSeatNum) > 9 and int(gNSeatNum) < 20:
CTaxItemCde = "398020" # ["398020", "商用车9人以上20人以下的中型客车及电车"]);
elif int(gNSeatNum) >= 20:
CTaxItemCde = "398021" # ["398021", "商用车20人以上(含)的大型客车及电车"]);
body = '''
[
{
"isFilter": "false",
"dwType": "ONLY_DATA",
"dwName": "prodDef.vhl.Base_DW",
"rsCount": "5",
"pageSize": "8",
"pageNo": "1",
"pageCount": "1",
"maxCount": "undefined",
"toAddFlag": "false",
"filterMapList": [
],
"dataObjVoList": [
{
"index": "1",
"selected": "false",
"status": "UPDATED",
"attributeVoList": [
{
_-a"_-fCRenewMrk",
_-b""
},
{
_-a"SY__-fCAppNo",
_-b""
},
{
_-a"JQ__-fCAppNo",
_-b""
},
{
_-a"JQ__-fCOfferNo",
_-b""
},
{
_-a"SY__-fCOfferNo",
_-b""
},
{
_-a"JQ__-fNRiskCost",
_-b""
},
{
_-a"SY__-fNRiskCost",
_-b""
},
{
_-a"JQ__-fNTargetPrm",
_-b""
},
{
_-a"SY__-fNTargetPrm",
_-b""
},
{
_-a"JQ__-fNProfitRatio",
_-b""
},
{
_-a"SY__-fNProfitRatio",
_-b""
},
{
_-a"JQ__-fNPayRatio",
_-b""
},
{
_-a"_-fCPayRatioLevel",
_-b""
},
{
_-a"SY__-fNPayRatio",
_-b""
},
{
_-a"_-fNDoubleRiskCost",
_-b""
},
{
_-a"_-fNDoublePrm",
_-b""
},
{
_-a"_-fNDoublePayRatio",
_-b""
},
{
_-a"_-fCDoublePayRatioLevel",
_-b""
},
{
_-a"JQ__-fNCostRatio",
_-b""
},
{
_-a"SY__-fNCostRatio",
_-b""
},
{
_-a"JQ__-fNCostRate",
_-b""
},
{
_-a"SY__-fNCostRate",
_-b""
},
{
_-a"JQ__-fCCostRatioLevel",
_-b""
},
{
_-a"SY__-fCCostRatioLevel",
_-b""
},
{
_-a"_-fNDoubleCostRate",
_-b""
},
{
_-a"_-fNDoubleCostRatio",
_-b""
},
{
_-a"_-fCDoubleCostRatioLevel",
_-b""
},
{
_-a"_-fCCommonFlag",
_-b"0"
},
{
_-a"_-fCAppTyp",
_-b"A"
},
{
_-a"SY__-fCPlyNo",
_-b""
},
{
_-a"JQ__-fCPlyNo",
_-b""
},
{
_-a"_-fNEdrPrjNo",
_-b""
},
{
_-a"_-fCRelPlyNo",
_-b""
},
{
_-a"_-fCProdNo",
_-b"${SY_JQ_fCProdNo}"
},
{
_-a"_-fCDptCde",
_-b"32010702"
},
{
_-a"_-fCSlsCde",
_-b""
},
{
_-a"_-fCHandLe",
_-b""
},
{
_-a"_-fCBsnsTyp",
_-b"1900101"
},
{
_-a"_-fCChaType",
_-b""
},
{
_-a"_-fCBsnsSubtyp",
_-b""
},
{
_-a"_-fCBrkrCde",
_-b""
},
{
_-a"_-fCBrkrName",
_-b""
},
{
_-a"_-fCSaleNme",
_-b""
},
{
_-a"_-fCAgtAgrNo",
_-b""
},
{
_-a"_-fNSubCoNo",
_-b""
},
{
_-a"_-fNCommRate",
_-b""
},
{
_-a"_-fNCommissionRateUpper",
_-b""
},
{
_-a"SY__-fCRenewMrk",
_-b""
},
{
_-a"JQ__-fCRenewMrk",
_-b""
},
{
_-a"JQ__-fCTrunMrk",
_-b"0"
},
{
_-a"SY__-fCTrunMrk",
_-b"0"
},
{
_-a"_-fCPlyTyp",
_-b""
},
{
_-a"JQ__-fCOrigPlyNo",
_-b""
},
{
_-a"SY__-fCOrigPlyNo",
_-b""
},
{
_-a"_-fCOrigInsurer",
_-b""
},
{
_-a"_-fCAmtCur",
_-b""
},
{
_-a"SY__-fNAmt",
_-b"0.00"
},
{
_-a"JQ__-fNAmt",
_-b"122000.00"
},
{
_-a"_-fNAmtRmbExch",
_-b""
},
{
_-a"_-fCPrmCur",
_-b""
},
{
_-a"SY__-fNCalcPrm",
_-b""
},
{
_-a"JQ__-fNCalcPrm",
_-b""
},
{
_-a"SY__-fNPrm",
_-b"0.00"
},
{
_-a"JQ__-fNPrm",
_-b"0.00"
},
{
_-a"_-fNPrmRmbExch",
_-b"1"
},
{
_-a"_-fNIndemLmt",
_-b""
},
{
_-a"_-fCRatioTyp",
_-b"D"
},
{
_-a"SY__-fNRatioCoef",
_-b"1"
},
{
_-a"JQ__-fNRatioCoef",
_-b"1"
},
{
_-a"_-fNSavingAmt",
_-b""
},
{
_-a"_-fCPlySts",
_-b""
},
{
_-a"_-fTTermnTm",
_-b""
},
{
_-a"_-fCInwdMrk",
_-b""
},
{
_-a"_-fCCiMrk",
_-b""
},
{
_-a"_-fCCiTyp",
_-b""
},
{
_-a"_-fNCiJntAmt",
_-b""
},
{
_-a"_-fNCiJntPrm",
_-b""
},
{
_-a"_-fCLongTermMrk",
_-b""
},
{
_-a"_-fTAppTm",
_-b"${fTOprTm}"
},
{
_-a"_-fCOprTyp",
_-b""
},
{
_-a"_-fCPrnNo",
_-b""
},
{
_-a"_-fCIcCardId",
_-b""
},
{
_-a"SY__-fTInsrncBgnTm",
_-b"${SY_fTInsrncBgnTm}"
},
{
_-a"SY__-fTInsrncEndTm",
_-b"${SY_fTInsrncEndTm}"
},
{
_-a"SY__-fCTmSysCde",
_-b"${SY__fCTmSysCde}"
},
{
_-a"JQ__-fTInsrncBgnTm",
_-b"${JQ_fTInsrncBgnTm}"
},
{
_-a"JQ__-fTInsrncEndTm",
_-b"${JQ_fTInsrncEndTm}"
},
{
_-a"JQ__-fCTmSysCde",
_-b"${JQ__fCTmSysCde}"
},
{
_-a"SY__-fCUnfixSpc",
_-b""
},
{
_-a"JQ__-fCUnfixSpc",
_-b""
},
{
_-a"_-fCGrpMrk",
_-b""
},
{
_-a"_-fCListorcolMrk",
_-b""
},
{
_-a"_-fCMasterMrk",
_-b""
},
{
_-a"_-fCPkgNo",
_-b""
},
{
_-a"_-fCRegMrk",
_-b""
},
{
_-a"_-fCDecMrk",
_-b""
},
{
_-a"_-fCJuriCde",
_-b""
},
{
_-a"_-fCAgriMrk",
_-b"0"
},
{
_-a"_-fCForeignMrk",
_-b""
},
{
_-a"_-fCImporexpMrk",
_-b""
},
{
_-a"JQ__-fCManualMrk",
_-b""
},
{
_-a"SY__-fCManualMrk",
_-b""
},
{
_-a"_-fCManualMrk",
_-b""
},
{
_-a"_-fCInstMrk",
_-b""
},
{
_-a"_-fCVipMrk",
_-b""
},
{
_-a"_-fCOpenCoverNo",
_-b""
},
{
_-a"_-fCDisptSttlCde",
_-b"007001"
},
{
_-a"_-fCDisptSttlOrg",
_-b""
},
{
_-a"_-fCOprCde",
_-b"${fCOprCde}"
},
{
_-a"_-fTOprTm",
_-b"${fTOprTm}"
},
{
_-a"_-fCChkCde",
_-b""
},
{
_-a"_-fTIssueTm",
_-b""
},
{
_-a"_-fTUdrTm",
_-b""
},
{
_-a"_-fCUdrDptCde",
_-b""
},
{
_-a"_-fCUdrCde",
_-b""
},
{
_-a"_-fCUdrMrk",
_-b""
},
{
_-a"_-fCRiFacMrk",
_-b""
},
{
_-a"_-fCRiChkCde",
_-b""
},
{
_-a"_-fCRiMrk",
_-b""
},
{
_-a"_-fTNextEdrBgnTm",
_-b""
},
{
_-a"_-fTNextEdrEndTm",
_-b""
},
{
_-a"_-fTNextEdrUdrTm",
_-b""
},
{
_-a"_-fCRemark",
_-b""
},
{
_-a"_-fTEdrAppTm",
_-b""
},
{
_-a"_-fTEdrBgnTm",
_-b""
},
{
_-a"_-fTEdrEndTm",
_-b""
},
{
_-a"_-fCEdrMrk",
_-b""
},
{
_-a"_-fCEdrType",
_-b""
},
{
_-a"_-fCCrtCde",
_-b""
},
{
_-a"_-fTCrtTm",
_-b""
},
{
_-a"_-fCUpdCde",
_-b""
},
{
_-a"SY__-fTUpdTm",
_-b""
},
{
_-a"JQ__-fTUpdTm",
_-b""
},
{
_-a"_-fNRate",
_-b""
},
{
_-a"_-f_-s1",
_-b""
},
{
_-a"_-f_-s2",
_-b""
},
{
_-a"_-f_-s3",
_-b""
},
{
_-a"_-f_-s4",
_-b""
},
{
_-a"_-fCLatestMrk",
_-b""
},
{
_-a"_-fCBidMrk",
_-b""
},
{
_-a"_-fCPrmSts",
_-b""
},
{
_-a"_-fNAmtVar",
_-b""
},
{
_-a"_-fNCalcPrmVar",
_-b""
},
{
_-a"_-fNPrmVar",
_-b""
},
{
_-a"_-fNIndemLmtVar",
_-b""
},
{
_-a"_-fCAppPrsnCde",
_-b""
},
{
_-a"_-fCAppPrsnNme",
_-b""
},
{
_-a"_-fCEdrCtnt",
_-b""
},
{
_-a"_-fCOcPlyNo",
_-b""
},
{
_-a"_-fCRevertMrk",
_-b""
},
{
_-a"_-fCEdrRsnBundleCde",
_-b""
},
{
_-a"_-fNBefEdrPrjNo",
_-b""
},
{
_-a"_-fNBefEdrAmt",
_-b""
},
{
_-a"_-fNBefEdrPrm",
_-b""
},
{
_-a"_-fCEdrNo",
_-b""
},
{
_-a"JQ__-fCEdrNo",
_-b""
},
{
_-a"SY__-fCEdrNo",
_-b""
},
{
_-a"_-fNPrmDisc",
_-b""
},
{
_-a"_-fNDiscRate",
_-b""
},
{
_-a"_-fNMaxFeeProp",
_-b""
},
{
_-a"_-fCFinTyp",
_-b"001"
},
{
_-a"_-fCGrantDptCde",
_-b""
},
{
_-a"_-fCVipCus",
_-b""
},
{
_-a"_-fNOrigTimes",
_-b""
},
{
_-a"_-fCDptAttr",
_-b""
},
{
_-a"_-fCSalegrpCde",
_-b""
},
{
_-a"_-fCSlsId",
_-b""
},
{
_-a"_-fCSlsTel",
_-b""
},
{
_-a"_-fCSlsNme",
_-b""
},
{
_-a"_-fCMinUndrDpt",
_-b""
},
{
_-a"_-fCMinUndrCls",
_-b""
},
{
_-a"_-fCPkgMrk",
_-b""
},
{
_-a"_-fCAppStatus",
_-b""
},
{
_-a"JQ__-fCImmeffMrk",
_-b""
},
{
_-a"SY__-fCImmeffMrk",
_-b""
},
{
_-a"_-fCInsrncTm",
_-b""
},
{
_-a"_-fNBasePrm",
_-b""
},
{
_-a"_-fNAllPrm",
_-b""
},
{
_-a"_-fCSusBusiness",
_-b""
},
{
_-a"JQ__-fCNewFlg",
_-b"1"
},
{
_-a"SY__-fCNewFlg",
_-b"1"
},
{
_-a"_-fTInsrncTm",
_-b""
},
{
_-a"_-fCOprNm",
_-b""
},
{
_-a"_-fCSaleTeam",
_-b""
},
{
_-a"_-fCAgantPer",
_-b""
},
{
_-a"_-fCVisInsure",
_-b""
},
{
_-a"_-fCIsTender",
_-b""
},
{
_-a"_-fCTenderNo",
_-b""
},
{
_-a"_-fTRepstopExtLastEndTm",
_-b""
},
{
_-a"_-fCRepstopextStatus",
_-b""
},
{
_-a"_-fTRepStopExtBgnTm",
_-b""
},
{
_-a"_-fTRepStopExtEndTm",
_-b""
},
{
_-a"_-fCRepStopExtRleAppNo",
_-b""
},
{
_-a"_-fTUntilDate",
_-b""
},
{
_-a"_-fCMkupFlag",
_-b""
},
{
_-a"_-fCGrpBaseMrk",
_-b""
},
{
_-a"_-fCComputerIp",
_-b""
},
{
_-a"_-fCUsbKey",
_-b""
},
{
_-a"_-fCPosNo",
_-b""
},
{
_-a"_-fCChaNmeCode",
_-b"B"
},
{
_-a"_-fCChannelNme",
_-b""
},
{
_-a"_-fCNewChaType",
_-b"B01"
},
{
_-a"_-fCNewBsnsTyp",
_-b"B0105"
},
{
_-a"_-fCServiceCode",
_-b""
},
{
_-a"_-fCTeamCode",
_-b""
},
{
_-a"_-fCTeamName",
_-b""
},
{
_-a"_-fCServiceId",
_-b""
},
{
_-a"_-fCPubNetFlag",
_-b""
},
{
_-a"_-fCDeptName",
_-b""
},
{
_-a"_-fCAppointAreaCode",
_-b""
},
{
_-a"_-fCIsFullEndor",
_-b""
},
{
_-a"_-fNAdditionalCostRate",
_-b""
},
{
_-a"_-fCOfferPlan",
_-b"A"
},
{
_-a"_-fCClauseType",
_-b"01"
},
{
_-a"_-fCPrmCalcProTyp",
_-b""
},
{
_-a"_-fCPriskPremFlag",
_-b""
},
{
_-a"_-fNCarLossPrm",
_-b""
},
{
_-a"JQ__-fCOfferUseSpc",
_-b""
},
{
_-a"SY__-fCOfferUseSpc",
_-b""
},
{
_-a"_-fCOperDpt",
_-b""
},
{
_-a"_-fCPayAgreement",
_-b""
},
{
_-a"_-fNIncrementRate",
_-b""
},
{
_-a"JQ__-fNNoTaxPrm",
_-b""
},
{
_-a"SY__-fNNoTaxPrm",
_-b""
},
{
_-a"JQ__-fNAddedTax",
_-b""
},
{
_-a"SY__-fNAddedTax",
_-b""
},
{
_-a"_-fCDataSrc",
_-b""
},
{
_-a"_-fNExpectPayrate",
_-b""
},
{
_-a"_-fCFiMrk",
_-b""
},
{
_-a"_-fNJsPrm",
_-b""
},
{
_-a"_-fNJsAmt",
_-b""
},
{
_-a"_-fNJcPrm",
_-b""
},
{
_-a"_-fNJcAmt",
_-b""
},
{
_-a"_-fCPropertyMrk",
_-b""
},
{
_-a"_-fNPropertyPrm",
_-b""
},
{
_-a"_-fNPropertyAmt",
_-b""
},
{
_-a"_-fCCvrgResult",
_-b""
}
]
}
]
},
{
"isFilter": "false",
"dwType": "ONLY_DATA",
"dwName": "prodDef.vhl.Vhl_DW",
"rsCount": "1",
"pageSize": "10",
"pageNo": "1",
"pageCount": "0",
"maxCount": "1000",
"toAddFlag": "false",
"filterMapList": [
],
"dataObjVoList": [
{
"index": "1",
"selected": "true",
"status": "INSERTED",
"attributeVoList": [
{
_-a"_-gNNewPurchaseTaxValue",
_-b"${gNNewPurchaseTaxValue}"
},
{
_-a"_-gNKindredPrice",
_-b"${gNKindredPrice}"
},
{
_-a"_-gNKindredPriceTax",
_-b"${gNKindredPriceTax}"
},
{
_-a"_-gCVin",
_-b"${gCFrmNo}"
},
{
_-a"_-gCMonDespRate",
_-b"${gCMonDespRate}"
},
{
_-a"_-gNActualValue",
_-b"${gNActualValue}"
},
{
_-a"_-gCLoanVehicleFlag",
_-b"0"
},
{
_-a"JQ__-gCQryCde",
_-b""
},
{
_-a"SY__-gCQryCde",
_-b""
},
{
_-a"_-gCVehlcleFamily",
_-b""
},
{
_-a"_-gCModelDesc",
_-b""
},
{
_-a"_-gRMarketDate",
_-b""
},
{
_-a"_-gNAssignPrice",
_-b""
},
{
_-a"_-gNOfferPurChasePrice",
_-b""
},
{
_-a"_-gNOfferPurChasePriceMax",
_-b"${gNOfferPurChasePriceMax}"
},
{
_-a"_-gNOfferPurChasePriceMin",
_-b"${gNOfferPurChasePriceMin}"
},
{
_-a"_-gCSnModifyPrices",
_-b"0"
},
{
_-a"_-gCXnModifyPrices",
_-b"0"
},
{
_-a"_-gCFleetMrk",
_-b"0"
},
{
_-a"_-gCVhlPkgNO",
_-b""
},
{
_-a"_-gCIndustryModelCode",
_-b"${gCIndustryModelCode}"
},
{
_-a"_-gCIndustryModelName",
_-b"${gCIndustryModelName}"
},
{
_-a"_-gCNoticeType",
_-b"${gCNoticeType}"
},
{
_-a"_-gCProdPlace",
_-b"${gCProdPlace}"
},
{
_-a"_-gCHfcode",
_-b"0"
},
{
_-a"_-gCDragWeight",
_-b""
},
{
_-a"_-gCFamilyCode",
_-b"${gCFamilyCode}"
},
{
_-a"_-gCFamilyName",
_-b"${gCFamilyName}"
},
{
_-a"_-gCEcdemicMrk",
_-b"0"
},
{
_-a"_-gCDevice1Mrk",
_-b"0"
},
{
_-a"_-gCNewVhlFlag",
_-b"1"
},
{
_-a"_-gCNewMrk",
_-b"0"
},
{
_-a"_-gCFstRegYm",
_-b"${gCFstRegYm}"
},
{
_-a"_-gCFrmNo",
_-b"${gCFrmNo}"
},
{
_-a"_-gCModelNme",
_-b"${gCModelNme}"
},
{
_-a"CarModel",
_-b""
},
{
_-a"searcheVehicleModel",
_-b""
},
{
_-a"queryPlateCarInfo",
_-b""
},
{
_-a"_-gCBrandId",
_-b"${gCBrandId}"
},
{
_-a"_-gCModelCde",
_-b"${gCModelCde}"
},
{
_-a"_-gCModelCde2",
_-b""
},
{
_-a"CarSerachValidate",
_-b""
},
{
_-a"CarSerachConfirm",
_-b""
},
{
_-a"_-gCSearchCode",
_-b"${gCSearchCode}"
},
{
_-a"_-gCValidateCode",
_-b"${gCValidateCode}"
},
{
_-a"_-gCPlateNo",
_-b"${gCPlateNo}"
},
{
_-a"_-gCEngNo",
_-b"${gCEngNo}"
},
{
_-a"_-gNDisplacement",
_-b"${gNDisplacement}"
},
{
_-a"_-gCPlateTyp",
_-b"${gCPlateTyp}"
},
{
_-a"_-gNNewPurchaseValue",
_-b"${gNNewPurchaseValue}"
},
{
_-a"_-gNDiscussActualValue",
_-b"${gNDiscussActualValue}"
},
{
_-a"JQ__-gCUsageCde",
_-b"309001"
},
{
_-a"JQ__-gCVhlTyp",
_-b"${JQgCVhlTyp}"
},
{
_-a"_-gCCarAge",
_-b"${gCCarAge}"
},
{
_-a"SY__-gCUsageCde",
_-b"309001"
},
{
_-a"SY__-gCVhlTyp",
_-b"${SYgCVhlTyp}"
},
{
_-a"SY__-g_-s6",
_-b"11"
},
{
_-a"_-gCRegVhlTyp",
_-b"${gCRegVhlTyp}"
},
{
_-a"_-gCCardDetail",
_-b"${gCRegVhlTyp}"
},
{
_-a"_-gCNatOfBusines",
_-b"359002"
},
{
_-a"_-gNTonage",
_-b"${gNTonage}"
},
{
_-a"_-gNSeatNum",
_-b"${gNSeatNum}"
},
{
_-a"_-gTTransferDate",
_-b""
},
{
_-a"_-gCBillDate",
_-b""
},
{
_-a"_-gNPoWeight",
_-b"${gNPoWeight}"
},
{
_-a"_-gCDisplacementLvl",
_-b""
},
{
_-a"_-gCTaxItemCde",
_-b""
},
{
_-a"_-gCFuelType",
_-b"0"
}
]
}
]
},
{
"isFilter": "false",
"dwType": "GRID_CVRG",
"dwName": "prodDef.vhl.Cvrg_DW",
"rsCount": "1",
"pageSize": "10",
"pageNo": "1",
"pageCount": "0",
"maxCount": "1000",
"toAddFlag": "false",
"filterMapList": [
],
${dataObjVoList}
},
{
"isFilter": "false",
"dwType": "ONLY_DATA",
"dwName": "prodDef.vhl.PrmCoef_DW",
"rsCount": "1",
"pageSize": "10",
"pageNo": "1",
"pageCount": "0",
"maxCount": "1000",
"toAddFlag": "false",
"filterMapList": [
],
"dataObjVoList": [
{
"index": "1",
"selected": "true",
"status": "INSERTED",
"attributeVoList": [
{
_-a"JQ__-mNDiscountAmount",
_-b""
},
{
_-a"JQ__-mNCoef",
_-b""
},
{
_-a"JQ__-mNPriPre",
_-b""
},
{
_-a"SY__-mCAppNo",
_-b""
},
{
_-a"SY__-mCPlyNo",
_-b""
},
{
_-a"JQ__-mCAppNo",
_-b""
},
{
_-a"JQ__-mCPlyNo",
_-b""
},
{
_-a"_-mCCrtCde",
_-b""
},
{
_-a"_-mTCrtTm",
_-b""
},
{
_-a"_-mCUpdCde",
_-b""
},
{
_-a"_-mTUpdTm",
_-b""
},
{
_-a"JQ__-mNClaimTime",
_-b""
},
{
_-a"SY__-mNClaimTime",
_-b""
},
{
_-a"JQ__-mNTotalClaimAmount",
_-b""
},
{
_-a"SY__-mNTotalClaimAmount",
_-b""
},
{
_-a"_-mNManualProduct",
_-b""
},
{
_-a"_-mNPreChannelFactor",
_-b""
},
{
_-a"_-mNPreUnderFactor",
_-b""
},
{
_-a"_-mNDrinkDriRiseRat",
_-b"0"
},
{
_-a"_-mNProcesseNum",
_-b"0"
},
{
_-a"_-mNProcesseNumB",
_-b"0"
},
{
_-a"_-mNAllDrinkRiseRat",
_-b"0"
},
{
_-a"_-mNLllegalNum",
_-b"0"
},
{
_-a"_-mNDrinkDriRiseRatB",
_-b"0.15"
},
{
_-a"_-mNLllegalNumB",
_-b"0"
},
{
_-a"_-mNUnProcesseNum",
_-b""
},
{
_-a"_-mNDrunkDri",
_-b"0"
},
{
_-a"_-mNUnProcesseNumB",
_-b""
},
{
_-a"_-mNSpeedNum",
_-b"0"
},
{
_-a"_-mNBreakRul",
_-b"0"
},
{
_-a"_-mNOverloadNum",
_-b"0"
},
{
_-a"_-mNNoGood",
_-b"0"
},
{
_-a"_-mNOtherNum",
_-b"0"
},
{
_-a"JQ__-mCNdiscRsn",
_-b"0"
},
{
_-a"_-mNDeathToll",
_-b"0"
},
{
_-a"_-mNLyRepRiseRat",
_-b"1"
},
{
_-a"_-mNOneYearNoDanger",
_-b""
},
{
_-a"_-mNRecordRiseRat",
_-b"1"
},
{
_-a"_-mCSafetyViola",
_-b"00"
},
{
_-a"_-mCAccidentInfo",
_-b"00"
},
{
_-a"_-mCDangerInfo",
_-b"00"
},
{
_-a"SY__-mNDiscountAmount",
_-b""
},
{
_-a"SY__-mNCoef",
_-b""
},
{
_-a"SY__-mNPriPre",
_-b""
},
{
_-a"_-mCOfferPlan",
_-b"A"
},
{
_-a"_-mNNoLossRat",
_-b""
},
{
_-a"SY__-mNTrafficViolateRat",
_-b""
},
{
_-a"SY__-mNCarTypeRat",
_-b""
},
{
_-a"SY__-mNChannelFactor",
_-b""
},
{
_-a"SY__-mNIndeptUnderRat",
_-b""
}
]
}
]
},
{
"isFilter": "false",
"dwType": "ONLY_DATA",
"dwName": "prodDef.vhl.Vhlowner_DW",
"rsCount": "1",
"pageSize": "10",
"pageNo": "1",
"pageCount": "0",
"maxCount": "1000",
"toAddFlag": "false",
"filterMapList": [
],
"dataObjVoList": [
{
"index": "1",
"selected": "true",
"status": "INSERTED",
"attributeVoList": [
{
_-a"_-jCOwnerCde",
_-b""
},
{
_-a"_-jCCrtCde",
_-b""
},
{
_-a"_-jTCrtTm",
_-b""
},
{
_-a"_-jCUpdCde",
_-b""
},
{
_-a"_-jTUpdTm",
_-b""
},
{
_-a"_-j_-s1",
_-b"1"
},
{
_-a"_-jCOwnerNme",
_-b"${hCAppNme}"
},
{
_-a"_-jCOwnerAge",
_-b"${jCOwnerAge}"
},
{
_-a"_-jCGender",
_-b"${jCGender}"
},
{
_-a"_-jCCertfCls",
_-b""
},
{
_-a"_-jCCertfCde",
_-b""
},
{
_-a"_-jCCOwnerTyp",
_-b""
}
]
}
]
},
{
"isFilter": "false",
"dwType": "ONLY_DATA",
"dwName": "prodDef.vhl.Applicant_DW",
"rsCount": "1",
"pageSize": "10",
"pageNo": "1",
"pageCount": "0",
"maxCount": "1000",
"toAddFlag": "false",
"filterMapList": [
],
"dataObjVoList": [
{
"index": "1",
"selected": "true",
"status": "INSERTED",
"attributeVoList": [
{
_-a"_-hCAppNme",
_-b"${hCAppNme}"
}
]
}
]
},
{
"isFilter": "false",
"dwType": "ONLY_DATA",
"dwName": "prodDef.vhl.Insured_DW",
"rsCount": "1",
"pageSize": "10",
"pageNo": "1",
"pageCount": "0",
"maxCount": "1000",
"toAddFlag": "false",
"filterMapList": [
],
"dataObjVoList": [
{
"index": "1",
"selected": "true",
"status": "INSERTED",
"attributeVoList": [
{
_-a"_-iCInsuredNme",
_-b"${hCAppNme}"
}
]
}
]
},
{
"isFilter": "false",
"dwType": "ONLY_DATA",
"dwName": "prodDef.vhl.VsTax_DW",
"rsCount": "1",
"pageSize": "10",
"pageNo": "1",
"pageCount": "0",
"maxCount": "1000",
"toAddFlag": "false",
"filterMapList": [
],
"dataObjVoList": [
{
"index": "1",
"selected": "true",
"status": "INSERTED",
"attributeVoList": [
{
_-a"VsTax.NAggTaxVar",
_-b"0.00"
},
{
_-a"VsTax.NBefEdrTax",
_-b"0.00"
},
{
_-a"VsTax.NBalanceTax",
_-b"0.00"
},
{
_-a"VsTax.CTaxUnit",
_-b"0.00"
},
{
_-a"VsTax.CVehicleNumber",
_-b""
},
{
_-a"VsTax.CVsTaxMrk",
_-b"N"
},
{
_-a"VsTax.CPaytaxTyp",
_-b"T"
},
{
_-a"VsTax.CAbateMrk",
_-b"002"
},
{
_-a"VsTax.CAbateRsn",
_-b""
},
{
_-a"VsTax.CFreeType",
_-b""
},
{
_-a"VsTax.CAbateProp",
_-b""
},
{
_-a"VsTax.CAbateAmt",
_-b""
},
{
_-a"VsTax.CTaxReliefCertNo",
_-b""
},
{
_-a"VsTax.NBeforTax",
_-b""
},
{
_-a"VsTax.CTaxItemCde",
_-b"${CTaxItemCde}"
},
{
_-a"VsTax.NAnnUnitTaxAmt",
_-b"0"
},
{
_-a"VsTax.CTaxYear",
_-b"2017"
},
{
_-a"VsTax.CLastTaxYear",
_-b"2016"
},
{
_-a"VsTax.TBillDate",
_-b""
},
{
_-a"VsTax.CTaxpayerId",
_-b""
},
{
_-a"VsTax.CTaxpayerCertTyp",
_-b"01"
},
{
_-a"VsTax.CTaxpayerCertNo",
_-b""
},
{
_-a"VsTax.CTaxpayerNme",
_-b""
},
{
_-a"VsTax.TLastSaliEndDate",
_-b"${fTOprTm}"
},
{
_-a"VsTax.CDrawbackOpr",
_-b""
},
{
_-a"VsTax.NOverdueDays",
_-b""
},
{
_-a"VsTax.NOverdueFineProp",
_-b"0.0005"
},
{
_-a"VsTax.NOverdueAmt",
_-b""
},
{
_-a"VsTax.NChargeProp",
_-b"0.05"
},
{
_-a"VsTax.NChargeAmt",
_-b""
},
{
_-a"VsTax.NLastYearTaxableMonths",
_-b""
},
{
_-a"VsTax.NLastYear",
_-b""
},
{
_-a"VsTax.NTaxableMonths",
_-b""
},
{
_-a"VsTax.NTaxableAmt",
_-b"0.00"
},
{
_-a"VsTax.TTaxEffBgnTm",
_-b""
},
{
_-a"VsTax.TTaxEffEndTm",
_-b""
},
{
_-a"VsTax.NExhaustCapacity",
_-b"${gNDisplacement}"
},
{
_-a"VsTax.NCurbWt",
_-b"${NCurbWt}"
},
{
_-a"VsTax.CTaxPaymentRecptNo",
_-b""
},
{
_-a"VsTax.CDepartmentNonLocal",
_-b""
},
{
_-a"VsTax.CTaxAuthorities",
_-b""
},
{
_-a"VsTax.CDrawbackOprMonth",
_-b""
},
{
_-a"VsTax.NAggTax",
_-b"0"
},
{
_-a"VsTax.TSaliAppDate",
_-b""
},
{
_-a"VsTax.CDeclareStatusIA",
_-b""
},
{
_-a"VsTax.TDeclareDate",
_-b""
},
{
_-a"VsTax.CCalcTaxFlag",
_-b""
}
]
}
]
}
]
'''
# from collections import OrderedDict
# body=json.dumps(body, ensure_ascii=False,object_pairs_hook=OrderedDict)
# json.loads()
# print(body)
dataObjVoList = get_insurance_type(insuranceType, gNDiscussActualValue,
fee['gNSeatNum'], gCFrmNo)
from string import Template
body = Template(body)
flag = "1"
SY_JQ_fCProdNo = "0360_0332" # 商业险_交强险
if insuranceType.get("otherHurtPremium", "0") == "1" or insuranceType.get(
"carNickPremium", "0") == "1" or insuranceType.get(
"driverDutyPremium", "0") == "1" or insuranceType.get(
"passengerDutyPremium", "0") == "1" or insuranceType.get(
"carDamagePremium", "0") == "1":
flag = "1"
else:
flag = "0"
if insuranceType.get("compulsoryInsurance", "1") == "1" and flag == "1":
SY_JQ_fCProdNo = "0360_0332"
elif insuranceType.get("compulsoryInsurance", "1") == "0" and flag == "1":
SY_JQ_fCProdNo = "0360" # 0360_0332
elif insuranceType.get("compulsoryInsurance", "1") == "1" and flag == "0":
SY_JQ_fCProdNo = "0332"
body = body.substitute(dataObjVoList=dataObjVoList,
gNOfferPurChasePriceMin=gNOfferPurChasePriceMin,
gCFamilyCode=gCFamilyCode,
SY_fTInsrncBgnTm=SY_fTInsrncBgnTm,
gNOfferPurChasePriceMax=gNOfferPurChasePriceMax,
gCMonDespRate=gCMonDespRate,
JQ__fCTmSysCde=JQ__fCTmSysCde,
gNKindredPriceTax=gNKindredPriceTax,
gCPlateTyp=gCPlateTyp,
SYgCVhlTyp=SYgCVhlTyp,
gNPoWeight=gNPoWeight,
JQ_fTInsrncEndTm=JQ_fTInsrncEndTm,
gCValidateCode=gCValidateCode,
gNActualValue=gNActualValue,
fCOprCde=fCOprCde,
gCModelNme=gCModelNme,
gCProdPlace=gCProdPlace,
gCPlateNo=gCPlateNo,
CTaxItemCde=CTaxItemCde,
SY__fCTmSysCde=SY__fCTmSysCde,
gNNewPurchaseTaxValue=gNNewPurchaseTaxValue,
gNDiscussActualValue=gNDiscussActualValue,
gCIndustryModelCode=gCIndustryModelCode,
gNSeatNum=gNSeatNum,
NCurbWt=NCurbWt,
fTOprTm=fTOprTm,
NAmt_036007=NAmt_036007,
lNVhlActVal=lNVhlActVal,
gNKindredPrice=gNKindredPrice,
gCBrandId=gCBrandId,
gCIndustryModelName=gCIndustryModelName,
SY_fTInsrncEndTm=SY_fTInsrncEndTm,
gCNoticeType=gCNoticeType,
gCFamilyName=gCFamilyName,
jCGender=jCGender,
gCRegVhlTyp=gCRegVhlTyp,
gNTonage=gNTonage,
gNDisplacement=gNDisplacement,
gCCarAge=gCCarAge,
JQ_fTInsrncBgnTm=JQ_fTInsrncBgnTm,
hCAppNme=hCAppNme,
gCFrmNo=gCFrmNo,
gCEngNo=gCEngNo,
gCFstRegYm=gCFstRegYm,
gCModelCde=gCModelCde,
gCSearchCode=gCSearchCode,
lNVhlActVal_036005=lNVhlActVal_036005,
gNNewPurchaseValue=gNNewPurchaseValue,
jCOwnerAge=jCOwnerAge,
JQgCVhlTyp=JQgCVhlTyp,
SY_JQ_fCProdNo=SY_JQ_fCProdNo)
body = body.__str__().replace("\n", "")
return urllib.quote(urllib.quote(body))
