SOURCE

function lastSP(formula,lastCycle, parameter) {
    var res = [];
    var DATETIME_FORMAT = "YYYY-MM-DD HH:mm:ss";
    var startTime = parameter.startTime;
    var endTime = parameter.endTime;
    switch (lastCycle) {
        case '年':
            startTime = moment(startTime).add(-12, 'M').format(DATETIME_FORMAT);
            endTime = moment(endTime).add(-12, 'M').format(DATETIME_FORMAT);
            break;
        case '半年':
            startTime = moment(startTime).add(-6, 'M').format(DATETIME_FORMAT);
            endTime = moment(endTime).add(-6, 'M').format(DATETIME_FORMAT);
            break;
        case '季度':
            startTime = moment(startTime).add(-3, 'M').format(DATETIME_FORMAT);
            endTime = moment(endTime).add(-3, 'M').format(DATETIME_FORMAT);
            break;
        case '月':
            startTime = moment(startTime).add(-1, 'M').format(DATETIME_FORMAT);
            endTime = moment(endTime).add(-1, 'M').format(DATETIME_FORMAT);
            break;
        case '周':
            startTime = moment(startTime).add(-7, 'days').format(DATETIME_FORMAT);
            endTime = moment(endTime).add(-7, 'days').format(DATETIME_FORMAT);
            break;
        case '天':
            startTime = moment(startTime).add(-1, 'days').format(DATETIME_FORMAT);
            endTime = moment(endTime).add(-1, 'days').format(DATETIME_FORMAT);
            break;
        default:

    };
    var obj = {
        "entId": parameter.entId,
        "templateVarValType": parameter.templateVarValType,
        "unitId": parameter.unitId + "",
        "aliasFormula": "A1",
        "sheetIndex": parameter.sheetIndex,
        "rowIndex": parameter.rowIndex,
        "colIndex": parameter.colIndex,
        "detList": [{
            "aliasName": "A1",
            "collectionFormula": formula.substring(1),
            "startTime": startTime,
            "endTime": endTime
        }]
    };
    res.push(obj);
    // 必须转为json格式
    return JSON.stringify(res);
}


var para = {
    "entId": 87685456,
    "templateVarValType": "采集值",
    "unitId": "396731776942485518",
    "sheetIndex": 0,
    "rowIndex": 1,
    "colIndex": 1,
    "startTime": "2022-08-01 23:30:00",
    "endTime": "2022-08-02 07:30:00",
    "cycle": "班",
    "year": 2022,
    "yearNum": 2,
    "quarter": 3,
    "month": 8,
    "day": 2,
    "factoryCalendarDTO": {
        calendarDOList: [
            {
                "year": 2022,
                "month": 8,
                "startTime": "2022-08-01 00:00:00",
                "endTime": "2022-08-31 00:00:00"
            }
        ],
        shiftDOList: [
            {
                "startDay": 0,
                "endTDay": 1,
                "startTime": "23:00:00",
                "endTime": "07:00:00"
            },
            {
                "startDay": 1,
                "endTDay": 1,
                "startTime": "07:00:00",
                "endTime": "15:00:00"
            },
            {
                "startDay": 1,
                "endTDay": 1,
                "startTime": "15:00:00",
                "endTime": "23:00:00"
            },
        ]
    }
};

console.log(lastSP("#JLDL009+JLDL007", "季度", para));
console 命令行工具 X clear

                    
>
console