沙世明
2022-09-13 bfca7a84bec815da594f1d12558535ed06d2490b
force-app/main/default/pages/SelectAssetEstimateURF.page
@@ -92,6 +92,7 @@
    blockme();
    searchfunc();
}
//<!-- HWAG-B4R3SS  END 20181026-->
// 初始化设定画面项目不可用
function pageSetDisabled(){
@@ -102,6 +103,10 @@
        j$(escapeVfId('allPage:allForm:allBlock:contract:monthRange')).attr("disabled", true);
        j$(escapeVfId('allPage:allForm:allBlock:contract:estimateTarget')).attr("disabled", true);
        j$(escapeVfId('allPage:allForm:allBlock:contract:EndUserType')).attr("disabled", true);
        //URF限次合同2期 LY 20220811 start
        j$(escapeVfId('allPage:allForm:allBlock:contract:estimateURFVMaxRepairCount')).attr("disabled", true);
        j$(escapeVfId('allPage:allForm:allBlock:contract:estimateURFPMaxRepairCount')).attr("disabled", true);
        //URF限次合同2期 LY 20220811 end
        var rowCnt = {!productCount};
        for (var i = 0; i < rowCnt; i++) {
            var isManual = j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':IsManual')).text();
@@ -208,7 +213,7 @@
            //j$(escapeVfId('allPage:allForm:decidebtn')).attr("class", 'btnDisabled');
            
            if (confirm(Confirm_EstimateRefresh)) {
                window.location.href="/apex/SelectAssetEstimateVM?copyid={!URLENCODE(targetEstimateId)}";
                window.location.href="/apex/SelectAssetEstimateURF?copyid={!URLENCODE(targetEstimateId)}";
                return true;
            } else {
                if ('{!DecideBtnDisabled}' == 'false') {
@@ -240,7 +245,7 @@
            //j$(escapeVfId('allPage:allForm:decidebtn')).attr("class", 'btnDisabled');
            
            if (confirm('已超过创建日6个月,是否更新报价?')) {
                window.location.href="/apex/SelectAssetEstimateVM?copyid={!URLENCODE(targetEstimateId)}";
                window.location.href="/apex/SelectAssetEstimateURF?copyid={!URLENCODE(targetEstimateId)}";
                return true;
            } else {
                if ('{!DecideBtnDisabled}' == 'false') {
@@ -320,6 +325,43 @@
    //contractStartDateChange();
    refreshAsset(cnt);
}
//URF限次合同2期 LY 20220811 start
function checkVMaxRepairCount(val, cnt) {
    var uRFSeriesMap =[];
    for (var i = 0; i < cnt; i++) {
        var uRFSeries = j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':uRFSeries')).text();
        // var uRFSeries = j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':uRFSeries')).value();
        uRFSeriesMap.push(uRFSeries);
    }
    if ((val == null || val == "" || val == "0") && uRFSeriesMap.includes('URF-V')){
        alert("合同对象设备中含有URF-V系列,必须选择URF-V的最大大修次数!");
        j$(escapeVfId('allPage:allForm:allBlock:contract:estimateURFVMaxRepairCount')).val("");
        return;
    }
    if (uRFSeriesMap.includes('URF-V')==false) {
        alert("合同对象设备中不含有URF-V系列,URF-V的最大大修次数必须选择/!");
        j$(escapeVfId('allPage:allForm:allBlock:contract:estimateURFVMaxRepairCount')).val("0");
    }
    refreshAsset(cnt);
}
function checkPMaxRepairCount(val, cnt) {
    var uRFSeriesMap =[];
    for (var i = 0; i < cnt; i++) {
        var uRFSeries = j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':uRFSeries')).text();
        uRFSeriesMap.push(uRFSeries);
    }
    if ((val == null || val == "" || val == "0") && uRFSeriesMap.includes('URF-P')){
        j$(escapeVfId('allPage:allForm:allBlock:contract:estimateURFPMaxRepairCount')).val("3");
    }
    if (uRFSeriesMap.includes('URF-P')==false) {
        alert("合同对象设备中不含有URF-P系列,URF-P的最大大修次数必须选择/!");
        j$(escapeVfId('allPage:allForm:allBlock:contract:estimateURFPMaxRepairCount')).val("0");
    }
    refreshAsset(cnt);
}
//URF限次合同2期 LY 20220811 end
function checkContractEstiStartDate(val, cnt) {
    if (val == null || val == "") {
@@ -391,6 +433,10 @@
    var upPriceSum = 0;
    // 合同月数乗算
    var month = localParseFloat(j$(escapeVfId('allPage:allForm:allBlock:contract:monthRange')).val());
    //URF限次合同2期 LY 20220811 start
    var estimateURFVMaxRepairCount=localParseFloat(j$(escapeVfId('allPage:allForm:allBlock:contract:estimateURFVMaxRepairCount')).val())
    var estimateURFPMaxRepairCount=localParseFloat(j$(escapeVfId('allPage:allForm:allBlock:contract:estimateURFPMaxRepairCount')).val())
    //URF限次合同2期 LY 20220811 end
    // XLIU-CE7AVC【委托】URF限次修理合同的最高价格修改 thh 20220509 start
    var Contract_year = 0;
    if (month == undefined || month == "" || month <= 12) {
@@ -420,6 +466,7 @@
        var isManual = j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':IsManual')).text();
        var isnew = j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':assetNewHidden')).val();
        var assetListmonth = j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':assetListPriceHidden')).val();
        if (isManual == 'true') {
            var a = j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':Assert')).value();
            if (a != '') {
@@ -433,8 +480,22 @@
                strMoney = j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':assetListPriceHidden')).val();
                // XLIU-CE7AVC【委托】URF限次修理合同的最高价格修改 thh 20220509 start
                //URF限次合同2期 LY 20220811 start
                var uRFSeries= j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':uRFSeries')).value();
                if (uRFSeries=='URF-V' && estimateURFVMaxRepairCount==2) {
                strMoneyMax = j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':uFRMaxPrice')).val();
                strMoneyMin = j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':uFRMinPrice')).val();
                }else if (uRFSeries=='URF-V' && estimateURFVMaxRepairCount==0) {
                    strMoneyMax = 0;
                    strMoneyMin = 0;
                }else if (uRFSeries=='URF-P' && estimateURFPMaxRepairCount==0){
                    strMoneyMax = 0;
                    strMoneyMin = 0;
                }else{
                    strMoneyMax = j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':uFRMaxPrice3')).val();
                    strMoneyMin = j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':uFRMinPrice3')).val();
                }
                //URF限次合同2期 LY 20220811 end
                // XLIU-CE7AVC【委托】URF限次修理合同的最高价格修改 thh 20220509 end
                // alert(strMoney);
                Price_YearTXT = strMoney * 12;
@@ -557,8 +618,22 @@
            }
            strMoney = j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':assetListPriceHidden')).val();
            // XLIU-CE7AVC【委托】URF限次修理合同的最高价格修改 thh 20220509 start
            //URF限次合同2期 LY 20220811 start
            var uRFSeries= j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':uRFSeries')).value();
            if (uRFSeries=='URF-V' && estimateURFVMaxRepairCount==2) {
            strMoneyMax = j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':uFRMaxPrice')).val();
            strMoneyMin = j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':uFRMinPrice')).val();
            }else if (uRFSeries=='URF-V' && estimateURFVMaxRepairCount==0) {
                    strMoneyMax = 0;
                    strMoneyMin = 0;
            }else if (uRFSeries=='URF-P' && estimateURFPMaxRepairCount==0){
                    strMoneyMax = 0;
                    strMoneyMin = 0;
            }else{
                strMoneyMax = j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':uFRMaxPrice3')).val();
                strMoneyMin = j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':uFRMinPrice3')).val();
            }
            //URF限次合同2期 LY 20220811 end
            // XLIU-CE7AVC【委托】URF限次修理合同的最高价格修改 thh 20220509 end
            Price_YearTXT = strMoney * 12;
            if (isnew == 'true') {
@@ -863,7 +938,11 @@
    var alert1s = 0;
    var today = new Date();
    today.setMonth(today.getMonth() - 3);
    //URF限次合同2期 LY 20220811 start
    var uRFSeriesMap =[];
    var valURFV =j$(escapeVfId('allPage:allForm:allBlock:contract:estimateURFVMaxRepairCount')).val();
    var valURFP =j$(escapeVfId('allPage:allForm:allBlock:contract:estimateURFPMaxRepairCount')).val();
    //URF限次合同2期 LY 20220811 end
    for (var i = 0; i < cntWithKara; i++) {
        var isManual = j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':IsManual')).text();
        if (isManual == 'true') {
@@ -885,7 +964,28 @@
                alerts = 1;
            }
        }
        //URF限次合同2期 LY 20220811 start
        var uRFSeries = j$(escapeVfId('allPage:allForm:allBlock:assetSection:assetTable:' + i + ':uRFSeries')).text();
        uRFSeriesMap.push(uRFSeries);
        //URF限次合同2期 LY 20220811 end
    }
    //URF限次合同2期 LY 20220811 start
    if ((valURFV == null || valURFV == "" || valURFV == "0") && uRFSeriesMap.includes('URF-V')){
        alert("合同对象设备中含有URF-V系列,必须选择URF-V的最大大修次数!");
        j$(escapeVfId('allPage:allForm:allBlock:contract:estimateURFVMaxRepairCount')).val("");
        return;
    }
    if (uRFSeriesMap.includes('URF-V')==false) {
        j$(escapeVfId('allPage:allForm:allBlock:contract:estimateURFVMaxRepairCount')).val("0");
    }
    if ((valURFP == null || valURFP == "" || valURFP == "0") && uRFSeriesMap.includes('URF-P')){
        j$(escapeVfId('allPage:allForm:allBlock:contract:estimateURFPMaxRepairCount')).val("3");
    }
    if (uRFSeriesMap.includes('URF-P')==false) {
        j$(escapeVfId('allPage:allForm:allBlock:contract:estimateURFPMaxRepairCount')).val("0");
    }
    //URF限次合同2期 LY 20220811 end
    if (alerts == 1) {
        if (confirm("选择的保有设备[最后点检日]为空或已经超过三个月之前,是否继续?")) {
            
@@ -1250,7 +1350,7 @@
       
        <apex:pageMessages id="pageMessages"></apex:pageMessages>
        <!-- update 合同报价页面的优化 添加‘assetSection’ fxk 2021/9/10 Star-->
        <apex:actionFunction name="refreshProductData" action="{!refreshProductData}" rerender="pageMessages,EquipmentGuaranteeFlg,EGFlgassHidden,EquipmentGuaranteeFlgtxt, assetListPriceHidden, productCount3, assetSection, uFRMaxPrice, uFRMinPrice" oncomplete="refreshAsset({!productCount});unblockUI();">
        <apex:actionFunction name="refreshProductData" action="{!refreshProductData}" rerender="pageMessages,EquipmentGuaranteeFlg,EGFlgassHidden,EquipmentGuaranteeFlgtxt, assetListPriceHidden, productCount3, assetSection, uFRMaxPrice, uFRMinPrice, uFRMaxPrice3, uFRMinPrice3,uRFSeries" oncomplete="refreshAsset({!productCount});unblockUI();">
            <apex:param assignTo="{!productIdx}" name="productIdx" value=""/>
        </apex:actionFunction>
        <!-- update 合同报价页面的优化 添加‘assetSection’ fxk 2021/9/10 End-->
@@ -1386,11 +1486,29 @@
                    <label class="labelCol vfLabelColTextWrap " style="margin-left:30%"> 经销商名</label></td>
                <td width="50%" align="left"> <apex:inputField value="{!estimate.Dealer__c}" id="dealer" /> </td>
            </tr>
            <!-- URF限次合同2期 LY 20220811 start -->
            <tr>
                <td width="50%" align="right">
                    <label class="labelCol vfLabelColTextWrap " style="margin-left:22%">URF-V最大大修次数:</label></td>
                <td>
                    <apex:inputField value="{!estimate.URF_V_MaxRepairCount__c}" required="false" id="estimateURFVMaxRepairCount" onchange="checkVMaxRepairCount(this.value,{!productCount})" style="margin-left:5px"/>次
                </td>
            </tr>
            <tr>
                <td  width="50%" align="right">
                    <label class="labelCol vfLabelColTextWrap " style="margin-left:30%">URF-P最大大修次数:</label></td>
                <td width="50%" align="left">
                    <apex:inputField value="{!estimate.URF_P_MaxRepairCount__c}" required="false" id="estimateURFPMaxRepairCount" onchange="checkPMaxRepairCount(this.value,{!productCount})" style="margin-left:5px"/>次
                </td>
            
            </tr>
            <!-- URF限次合同2期 LY 20220811 end -->
        </table>
        <script type="text/javascript">
            j$(escapeVfId('allPage:allForm:allBlock:contract:estimateTarget')).children('option[value=]').remove();
            resetDealer();
            j$(escapeVfId('allPage:allForm:allBlock:contract:estimateURFVMaxRepairCount')).children('option[value=]').remove();
            j$(escapeVfId('allPage:allForm:allBlock:contract:estimateURFPMaxRepairCount')).children('option[value=]').remove();
        </script>
        </apex:outputPanel>
        </apex:pageBlockSection>
@@ -1422,13 +1540,19 @@
                    <tr class="headerRow" height="30px">
                        <th style="width:25px" class="headerRow  booleanColumn"><input type='checkbox' onClick='checkAll(this)'/></th>
                        <th class="headerRow  booleanColumn">{!$ObjectType.Asset.fields.Name.label}</th>
                        <!-- URF限次合同2期 LY 20220811 start -->
                        <th style="width:35px" class="headerRow  booleanColumn">{!$ObjectType.Maintenance_Contract_Asset_Estimate__c.fields.URF_Series__c.label}
                        </th>
                        <!-- URF限次合同2期 LY 20220811 end -->
                        <th style="width:70px" class="headerRow  booleanColumn">{!$ObjectType.Asset.fields.Asset_situation__c.label}</th>
                        <th style="width:70px" class="headerRow  booleanColumn">{!$ObjectType.Asset.fields.SerialNumber.label}</th>
                        <th class="headerRow  booleanColumn">{!$ObjectType.Asset.fields.EGFlg_fromContract_asset__c.label}</th>
                        <th style="width:70px" class="headerRow  booleanColumn">{!$ObjectType.Asset.fields.InstallDate.label}</th>
                        <!--add点检改善:新增一个点检对象复选框字段,默认为true 2021.6.8 fxk Star-->
                        <th style="width:70px" class="headerRow  booleanColumn">
                        {!$ObjectType.Maintenance_Contract_Asset_Estimate__c.fields.Check_Object__c.label}</th>
                        <!-- URF限次合同2期 LY 20220811 start -->
                        <!-- <th style="width:70px" class="headerRow  booleanColumn">
                        {!$ObjectType.Maintenance_Contract_Asset_Estimate__c.fields.Check_Object__c.label}</th> -->
                        <!-- URF限次合同2期 LY 20220811 end -->
                        <!--add点检改善:新增一个点检对象复选框字段,默认为true 2021.6.8 fxk end-->
                        <th style="width:40px" class="headerRow  booleanColumn">{!$ObjectType.Maintenance_Contract_Asset_Estimate__c.fields.IsNew__c.label}</th>
                        <th style="width:70px" class="headerRow  booleanColumn">{!$ObjectType.Asset.fields.Department_Name__c.label}</th>
@@ -1473,6 +1597,11 @@
                                    <apex:inputField value="{!ar.mcae.Product_Manual__c}" id="Assert" style="width:90%;" rendered="{!ar.IsManual}" onchange="blockme();refreshProductData({!ar.lineNo});"/>
                                    <apex:inputText id="ProductId" value="{!ar.mcae.Product_Manual__c}" style="display:none;" disabled="true"/>
                                </td>
                                <!-- URF限次合同2期 LY 20220811 start -->
                                <td class="dataCell" width="70px" >
                                    <apex:outputText value="{!ar.uFRSerial}" id="uRFSeries"/>
                                </td>
                                <!-- URF限次合同2期 LY 20220811 end -->
                                <td class="dataCell" width="70px">
                                    <apex:outputField value="{!ar.rec.Asset_situation__c}" rendered="{!Not(ar.IsManual)}" />
                                </td>
@@ -1490,9 +1619,11 @@
                                    <apex:outputField value="{!ar.rec.InstallDate}" id="InstallDate" rendered="{!Not(ar.IsManual)}" />
                                </td>
                                <!--add点检改善:新增一个点检对象复选框字段,默认为true 2021.6.8 fxk Star-->
                                <td class="dataCell" width="70px" style="text-align:center" >
                                <!-- URF限次合同2期 LY 20220811 start -->
                                <!-- <td class="dataCell" width="70px" style="text-align:center" >
                                    <apex:inputCheckbox value="{!ar.mcae.Check_Object__c}" id="assetCheck" disabled="{!ar.CheckRows}"/>
                                </td>
                                </td> -->
                                <!-- URF限次合同2期 LY 20220811 end -->
                                <!--add点检改善:新增一个点检对象复选框字段,默认为true 2021.6.8 fxk end-->
                                <td class="dataCell" width="40px" style="text-align:center" >
                                    <apex:inputCheckbox value="{!ar.mcae.IsNew__c}" id="assetNew" disabled="true"/>
@@ -1538,6 +1669,10 @@
                                        <apex:inputHidden value="{!ar.uFRMaxPrice}" id="uFRMaxPrice"/>
                                        <apex:inputHidden value="{!ar.uFRMinPrice}" id="uFRMinPrice"/>
                                        <!-- XLIU-CE7AVC【委托】URF限次修理合同的最高价格修改 thh 20220509 end -->
                                        <!-- URF限次合同2期 LY 20220811 start -->
                                        <apex:inputHidden value="{!ar.uFRMaxPrice3}" id="uFRMaxPrice3"/>
                                        <apex:inputHidden value="{!ar.uFRMinPrice3}" id="uFRMinPrice3"/>
                                        <!-- URF限次合同2期 LY 20220811 end -->
                                        <apex:inputHidden value="{!ar.mcae.Estimate_List_Price_Page__c}" id="assetListPricePageHidden" />
                                        <apex:inputHidden value="{!ar.rec.CurrentContract_F__r.Estimate_Num__c}" id="Estimate_NumHidden" />
                                    </apex:outputPanel>
@@ -1656,6 +1791,9 @@
                    <tr class="headerRow" height="30px">
                        <th style="width:25px" class="headerRow  booleanColumn"><input type='checkbox' onClick='checkAll2(this)'/></th>
                        <th style="width:25%" class="headerRow  booleanColumn">{!$ObjectType.Asset.fields.Name.label}</th>
                        <!-- URF限次合同2期 LY 20220811 start -->
                        <th style="width:90px" class="headerRow  booleanColumn">限次系列<!-- {!$ObjectType.Asset.fields.Product2.ProductURF__r.URFLimitSerial__c.label} --></th>
                        <!-- URF限次合同2期 LY 20220811 end -->
                        <th style="width:70px" class="headerRow  booleanColumn">{!$ObjectType.Asset.fields.Asset_situation__c.label}</th>
                        <th style="width:70px" class="headerRow  booleanColumn">{!$ObjectType.Asset.fields.SerialNumber.label}</th>
                        <th class="headerRow  booleanColumn">{!$ObjectType.Asset.fields.Department_Name__c.label}</th>
@@ -1677,12 +1815,21 @@
                    <apex:repeat value="{!unCheckedAssetsView}" var="assetsView" id="outassetTable2">
                        <apex:repeat value="{!assetsView}" var="ar" id="assetTable2">
                            <tr class="dataRow {!IF(MOD(cnt, 2)==0, 'odd', 'even')} {!IF(cnt==1, 'first', '')}" onmouseover="if (window.hiOn){hiOn(this);} " onmouseout="if (window.hiOff){hiOff(this);} " onblur="if (window.hiOff){hiOff(this);}" onfocus="if (window.hiOn){hiOn(this);}">
                                <td class="dataCell" width="25px">
                                <!-- <td class="dataCell" width="25px">
                                    <apex:inputCheckbox value="{!ar.rec_checkBox_c}" id="assetRowCheckbox2" disabled="{!IF(ar.uFRPrice == 0 || ar.rec.IF_Warranty__c = '否', 'true', 'false')}"/>
                                </td> -->
                                <!-- gzw update 20220823 -->
                                <td class="dataCell" width="25px">
                                    <apex:inputCheckbox value="{!ar.rec_checkBox_c}" id="assetRowCheckbox2" disabled="{!IF( ar.rec.IF_Warranty__c = '否', 'true', 'false')}"/>
                                </td>
                                <td class="dataCell" width="25%">
                                    <apex:outputField value="{!ar.rec.name}" id="assetName"/>
                                </td>
                                <!-- URF限次合同2期 LY 20220811 start -->
                                <td class="dataCell" width="90px">
                                    <!-- <apex:outputField value="{!ar.rec.Product2.ProductURF__r.URFLimitSerial__c}"/> --><apex:outputText value="{!ar.uFRSerial}"/>
                                </td>
                                <!-- URF限次合同2期 LY 20220811 end -->
                                <td class="dataCell" width="70px">
                                    <apex:outputField value="{!ar.rec.Asset_situation__c}"/>
                                </td>
@@ -2062,7 +2209,7 @@
    // 选择设备后价格变更check
    if (assIds.length > 0) {
        // alert('222222222222' + assIds);
        var sql = "SELECT Id, Maintenance_Price_Month__c,Product2.UFR_Maintenance_Price_Month__c, Posting_Date__c, InstallDate from Asset where Id In(" + assIds + ")";
        var sql = "SELECT Id, Maintenance_Price_Month__c,Product2.UFR_Maintenance_Price_Month__c, Posting_Date__c, InstallDate,Product2.UFR_Maintenance_Price_Month_3__c from Asset where Id In(" + assIds + ")";
        var rt = sforce.connection.query(sql);
        var asList = rt.getArray("records"); 
        if (asList != null) {
@@ -2072,7 +2219,10 @@
                var asId = asvar["Id"];
                // alert('asvar++++' + asvar["Product2"].["ProductURF__r"].["UFR_Maintenance_Price_Month__c"]);
                // var mprice = asvar["Maintenance_Price_Month__c"];
                var mprice = asvar["Product2"].UFR_Maintenance_Price_Month__c;
                //URF限次合同2期 LY 20220811 start
                //var mprice = asvar["Product2"].UFR_Maintenance_Price_Month__c;
                var mprice = asvar["Product2"].UFR_Maintenance_Price_Month_3__c;
                //URF限次合同2期 LY 20220811 end
                var ptDt = asvar["Posting_Date__c"];
                var postingDate = null;
                if (ptDt != null && ptDt != '') {
@@ -2110,7 +2260,7 @@
                return true;
            }
        } else {
            var sql = "SELECT Id, Maintenance_Price_Month__c,UFR_Maintenance_Price_Month__c from Product2 where Id In(" + proIds + ")";
            var sql = "SELECT Id, Maintenance_Price_Month__c,UFR_Maintenance_Price_Month__c,UFR_Maintenance_Price_Month_3__c from Product2 where Id In(" + proIds + ")";
            var rt = sforce.connection.query(sql);
            var pdList = rt.getArray("records");
            if (pdList != null) {
@@ -2118,7 +2268,10 @@
                    var pdvar = pdList[i];
                    var pdId = pdvar["Id"];
                    // var mprice = pdvar["Maintenance_Price_Month__c"];
                    var mprice = pdvar["UFR_Maintenance_Price_Month__c"];
                    //URF限次合同2期 LY 20220811 strat
                    //var mprice = pdvar["UFR_Maintenance_Price_Month__c"];
                    var mprice = pdvar["UFR_Maintenance_Price_Month_3__c"];
                    //URF限次合同2期 LY 20220811 end
                    var priceShow = priceMap.get(pdId);
                    if (Number(mprice).toFixed(2) != Number(priceShow).toFixed(2)) {
                        needClearId = true;