var ReportTemplateCycleEnums = {
HOUR: "1",
WORK: "2",
DAY: "3",
WEEK: "4",
MONTH: "5",
QUARTER: "6",
HALFAYEAR: "7",
YEAR: "8",
OTHER: "9"
};
var DayEnums = {
A_DAY: -1,
THE_DAY: 0,
NEXT_DAY: 1
};
function currentSPDsRow(formula, detailCycle, parameter) {
var res = [];
var DATETIME_FORMAT = "YYYY-MM-DD HH:mm:ss";
var startTime = parameter.startTime;
var endTime = parameter.endTime;
var cycle = parameter.cycle;
var rowIndex = parameter.rowIndex;
var colIndex = parameter.colIndex;
var calendarDOList = parameter.factoryCalendarDTO.calendarDOList;
var shiftDOList = parameter.factoryCalendarDTO.shiftDOList;
var obj = {
"entId": parameter.entId,
"templateVarValType": parameter.templateVarValType,
"unitId": parameter.unitId + "",
"aliasFormula": "A1",
"sheetIndex": parameter.sheetIndex,
"rowIndex": rowIndex,
"colIndex": colIndex,
"detList": [{
"aliasName": "A1",
"collectionFormula": formula.substring(1),
"startTime": startTime,
"endTime": endTime
}]
};
switch (cycle) {
case ReportTemplateCycleEnums.YEAR:
if (detailCycle == '年') {
res.push(obj);
} else if (detailCycle == '半年') {
for (var i = 0; i < 2; i++) {
var item = JSON.parse(JSON.stringify(obj));
item.colIndex = colIndex + i;
if (shiftDOList[0].startDay == DayEnums.A_DAY) {
item.detList[0].startTime = moment(calendarDOList[0 + i * 6].startTime).add(-1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
} else if (shiftDOList[0].startDay == DayEnums.THE_DAY) {
item.detList[0].startTime = moment(calendarDOList[0 + i * 6].startTime).format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
} else if (shiftDOList[0].startDay == DayEnums.NEXT_DAY) {
item.detList[0].startTime = moment(calendarDOList[0 + i * 6].startTime).add(1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
}
if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.A_DAY) {
item.detList[0].endTime = moment(calendarDOList[5 + i * 6].endTime).add(-1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
} else if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.THE_DAY) {
item.detList[0].endTime = moment(calendarDOList[5 + i * 6].endTime).format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
} else if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.NEXT_DAY) {
item.detList[0].endTime = moment(calendarDOList[5 + i * 6].endTime).add(1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
}
res.push(item);
}
} else if (detailCycle == '季度') {
for (var i = 0; i < 4; i++) {
var item = JSON.parse(JSON.stringify(obj));
item.colIndex = colIndex + i;
if (shiftDOList[0].startDay == DayEnums.A_DAY) {
item.detList[0].startTime = moment(calendarDOList[0 + i * 3].startTime).add(-1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
} else if (shiftDOList[0].startDay == DayEnums.THE_DAY) {
item.detList[0].startTime = moment(calendarDOList[0 + i * 3].startTime).format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
} else if (shiftDOList[0].startDay == DayEnums.NEXT_DAY) {
item.detList[0].startTime = moment(calendarDOList[0 + i * 3].startTime).add(1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
}
if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.A_DAY) {
item.detList[0].endTime = moment(calendarDOList[2 + i * 3].endTime).add(-1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
} else if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.THE_DAY) {
item.detList[0].endTime = moment(calendarDOList[2 + i * 3].endTime).format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
} else if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.NEXT_DAY) {
item.detList[0].endTime = moment(calendarDOList[2 + i * 3].endTime).add(1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
}
res.push(item);
}
} else if (detailCycle == '月') {
for (var i = 0; i < calendarDOList.length; i++) {
var item = JSON.parse(JSON.stringify(obj));
item.colIndex = colIndex + i;
if (shiftDOList[0].startDay == DayEnums.A_DAY) {
item.detList[0].startTime = moment(calendarDOList[i].startTime).add(-1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
} else if (shiftDOList[0].startDay == DayEnums.THE_DAY) {
item.detList[0].startTime = moment(calendarDOList[i].startTime).format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
} else if (shiftDOList[0].startDay == DayEnums.NEXT_DAY) {
item.detList[0].startTime = moment(calendarDOList[i].startTime).add(1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
}
if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.A_DAY) {
item.detList[0].endTime = moment(calendarDOList[i].endTime).add(-1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
} else if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.THE_DAY) {
item.detList[0].endTime = moment(calendarDOList[i].endTime).format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
} else if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.NEXT_DAY) {
item.detList[0].endTime = moment(calendarDOList[i].endTime).add(1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
}
res.push(item);
}
}
break;
case ReportTemplateCycleEnums.HALFAYEAR:
if (detailCycle == '半年') {
res.push(obj);
} else if (detailCycle == '季度') {
for (var i = 0; i < 2; i++) {
var item = JSON.parse(JSON.stringify(obj));
item.colIndex = colIndex + i;
if (shiftDOList[0].startDay == DayEnums.A_DAY) {
item.detList[0].startTime = moment(calendarDOList[0 + i * 3].startTime).add(-1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
} else if (shiftDOList[0].startDay == DayEnums.THE_DAY) {
item.detList[0].startTime = moment(calendarDOList[0 + i * 3].startTime).format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
} else if (shiftDOList[0].startDay == DayEnums.NEXT_DAY) {
item.detList[0].startTime = moment(calendarDOList[0 + i * 3].startTime).add(1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
}
if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.A_DAY) {
item.detList[0].endTime = moment(calendarDOList[2 + i * 3].endTime).add(-1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
} else if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.THE_DAY) {
item.detList[0].endTime = moment(calendarDOList[2 + i * 3].endTime).format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
} else if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.NEXT_DAY) {
item.detList[0].endTime = moment(calendarDOList[2 + i * 3].endTime).add(1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
}
res.push(item);
}
} else if (detailCycle == '月') {
for (var i = 0; i < calendarDOList.length; i++) {
var item = JSON.parse(JSON.stringify(obj));
item.colIndex = colIndex + i;
if (shiftDOList[0].startDay == DayEnums.A_DAY) {
item.detList[0].startTime = moment(calendarDOList[i].startTime).add(-1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
} else if (shiftDOList[0].startDay == DayEnums.THE_DAY) {
item.detList[0].startTime = moment(calendarDOList[i].startTime).format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
} else if (shiftDOList[0].startDay == DayEnums.NEXT_DAY) {
item.detList[0].startTime = moment(calendarDOList[i].startTime).add(1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
}
if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.A_DAY) {
item.detList[0].endTime = moment(calendarDOList[i].endTime).add(-1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
} else if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.THE_DAY) {
item.detList[0].endTime = moment(calendarDOList[i].endTime).format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
} else if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.NEXT_DAY) {
item.detList[0].endTime = moment(calendarDOList[i].endTime).add(1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
}
res.push(item);
}
}
break;
case ReportTemplateCycleEnums.QUARTER:
if (detailCycle == '季度') {
res.push(obj);
} else if (detailCycle == '月') {
for (var i = 0; i < calendarDOList.length; i++) {
var item = JSON.parse(JSON.stringify(obj));
item.colIndex = colIndex + i;
if (shiftDOList[0].startDay == DayEnums.A_DAY) {
item.detList[0].startTime = moment(calendarDOList[i].startTime).add(-1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
} else if (shiftDOList[0].startDay == DayEnums.THE_DAY) {
item.detList[0].startTime = moment(calendarDOList[i].startTime).format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
} else if (shiftDOList[0].startDay == DayEnums.NEXT_DAY) {
item.detList[0].startTime = moment(calendarDOList[i].startTime).add(1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
}
if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.A_DAY) {
item.detList[0].endTime = moment(calendarDOList[i].endTime).add(-1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
} else if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.THE_DAY) {
item.detList[0].endTime = moment(calendarDOList[i].endTime).format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
} else if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.NEXT_DAY) {
item.detList[0].endTime = moment(calendarDOList[i].endTime).add(1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
}
res.push(item);
}
}
break;
case ReportTemplateCycleEnums.MONTH:
if (detailCycle == '月') {
res.push(obj);
} else if (detailCycle == '天') {
var dayNum = moment(calendarDOList[0].endTime).diff(moment(calendarDOList[0].startTime), 'days') + 1;
for (var i = 0; i < dayNum; i++) {
var item = JSON.parse(JSON.stringify(obj));
item.colIndex = colIndex + i;
if (shiftDOList[0].startDay == DayEnums.A_DAY) {
item.detList[0].startTime = moment(calendarDOList[0].startTime).add(-1 + i, 'days').format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
} else if (shiftDOList[0].startDay == DayEnums.THE_DAY) {
item.detList[0].startTime = moment(calendarDOList[0].startTime).add(i, 'days').format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
} else if (shiftDOList[0].startDay == DayEnums.NEXT_DAY) {
item.detList[0].startTime = moment(calendarDOList[0].startTime).add(1 + i, 'days').format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
}
if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.A_DAY) {
item.detList[0].endTime = moment(calendarDOList[0].endTime).add(-1 - dayNum + i + 1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
} else if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.THE_DAY) {
item.detList[0].endTime = moment(calendarDOList[0].endTime).add(-dayNum + i + 1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
} else if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.NEXT_DAY) {
item.detList[0].endTime = moment(calendarDOList[0].endTime).add(1 - dayNum + i + 1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
}
res.push(item);
}
} else if (detailCycle == '班') {
var dayNum = moment(calendarDOList[0].endTime).diff(moment(calendarDOList[0].startTime), 'days') + 1;
for (var i = 0; i < dayNum; i++) {
for (var j = 0; j < shiftDOList.length; j++) {
var item = JSON.parse(JSON.stringify(obj));
item.colIndex = colIndex++;
if (shiftDOList[j].startDay == DayEnums.A_DAY) {
item.detList[0].startTime = moment(calendarDOList[0].startTime).add(-1 + i, 'days').format("YYYY-MM-DD") + " " + shiftDOList[j].startTime;
} else if (shiftDOList[j].startDay == DayEnums.THE_DAY) {
item.detList[0].startTime = moment(calendarDOList[0].startTime).add(i, 'days').format("YYYY-MM-DD") + " " + shiftDOList[j].startTime;
} else if (shiftDOList[j].startDay == DayEnums.NEXT_DAY) {
item.detList[0].startTime = moment(calendarDOList[0].startTime).add(1 + i, 'days').format("YYYY-MM-DD") + " " + shiftDOList[j].startTime;
}
if (shiftDOList[j].endDay == DayEnums.A_DAY) {
item.detList[0].endTime = moment(calendarDOList[0].endTime).add(-1 - dayNum + i + 1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[j].endTime;
} else if (shiftDOList[j].endDay == DayEnums.THE_DAY) {
item.detList[0].endTime = moment(calendarDOList[0].endTime).add(-dayNum + i + 1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[j].endTime;
} else if (shiftDOList[j].endDay == DayEnums.NEXT_DAY) {
item.detList[0].endTime = moment(calendarDOList[0].endTime).add(1 - dayNum + i + 1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[j].endTime;
}
res.push(item);
}
}
}
break;
case ReportTemplateCycleEnums.WEEK:
if (detailCycle == '周') {
res.push(obj);
} else if (detailCycle == '天') {
var year = parameter.year;
var week = moment(startTime).add(3, 'days').format("W");
var weekdays = [];
weekdays[0] = moment(year + '-' + week, 'GGGG-WW').format(DATETIME_FORMAT);
weekdays[1] = moment(year + '-' + week, 'GGGG-WW').weekday(7).format(DATETIME_FORMAT);
for (var i = 0; i < 7; i++) {
var item = JSON.parse(JSON.stringify(obj));
item.colIndex = colIndex + i;
if (shiftDOList[0].startDay == DayEnums.A_DAY) {
item.detList[0].startTime = moment(weekdays[0]).add(-1 + i, 'days').format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
} else if (shiftDOList[0].startDay == DayEnums.THE_DAY) {
item.detList[0].startTime = moment(weekdays[0]).add(i, 'days').format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
} else if (shiftDOList[0].startDay == DayEnums.NEXT_DAY) {
item.detList[0].startTime = moment(weekdays[0]).add(1 + i, 'days').format("YYYY-MM-DD") + " " + shiftDOList[0].startTime;
}
if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.A_DAY) {
item.detList[0].endTime = moment(weekdays[1]).add(-1 - 7 + i + 1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
} else if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.THE_DAY) {
item.detList[0].endTime = moment(weekdays[1]).add(-7 + i + 1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
} else if (shiftDOList[shiftDOList.length - 1].endDay == DayEnums.NEXT_DAY) {
item.detList[0].endTime = moment(weekdays[1]).add(1 - 7 + i + 1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[shiftDOList.length - 1].endTime;
}
res.push(item);
}
} else if (detailCycle == '班') {
var year = parameter.year;
var week = moment(startTime).add(3, 'days').format("W");
var weekdays = [];
weekdays[0] = moment(year + '-' + week, 'GGGG-WW').format(DATETIME_FORMAT);
weekdays[1] = moment(year + '-' + week, 'GGGG-WW').weekday(7).format(DATETIME_FORMAT);
for (var i = 0; i < 7; i++) {
for (var j = 0; j < shiftDOList.length; j++) {
var item = JSON.parse(JSON.stringify(obj));
item.colIndex = colIndex++;
if (shiftDOList[j].startDay == DayEnums.A_DAY) {
item.detList[0].startTime = moment(weekdays[0]).add(-1 + i, 'days').format("YYYY-MM-DD") + " " + shiftDOList[j].startTime;
} else if (shiftDOList[j].startDay == DayEnums.THE_DAY) {
item.detList[0].startTime = moment(weekdays[0]).add(i, 'days').format("YYYY-MM-DD") + " " + shiftDOList[j].startTime;
} else if (shiftDOList[j].startDay == DayEnums.NEXT_DAY) {
item.detList[0].startTime = moment(weekdays[0]).add(1 + i, 'days').format("YYYY-MM-DD") + " " + shiftDOList[j].startTime;
}
if (shiftDOList[j].endDay == DayEnums.A_DAY) {
item.detList[0].endTime = moment(weekdays[1]).add(-1 - 7 + i + 1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[j].endTime;
} else if (shiftDOList[j].endDay == DayEnums.THE_DAY) {
item.detList[0].endTime = moment(weekdays[1]).add(-7 + i + 1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[j].endTime;
} else if (shiftDOList[j].endDay == DayEnums.NEXT_DAY) {
item.detList[0].endTime = moment(weekdays[1]).add(1 - 7 + i + 1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[j].endTime;
}
res.push(item);
}
}
}
break;
case ReportTemplateCycleEnums.DAY:
if (detailCycle == '天') {
res.push(obj);
} else if (detailCycle == '班') {
var dayNum = moment(calendarDOList[0].endTime).diff(moment(calendarDOList[0].startTime), 'days') + 1;
for (var i = 0; i < dayNum; i++) {
if (i + 1 == parameter.day) {
for (var j = 0; j < shiftDOList.length; j++) {
var item = JSON.parse(JSON.stringify(obj));
item.colIndex = colIndex++;
if (shiftDOList[j].startDay == DayEnums.A_DAY) {
item.detList[0].startTime = moment(calendarDOList[0].startTime).add(-1 + i, 'days').format("YYYY-MM-DD") + " " + shiftDOList[j].startTime;
} else if (shiftDOList[j].startDay == DayEnums.THE_DAY) {
item.detList[0].startTime = moment(calendarDOList[0].startTime).add(i, 'days').format("YYYY-MM-DD") + " " + shiftDOList[j].startTime;
} else if (shiftDOList[j].startDay == DayEnums.NEXT_DAY) {
item.detList[0].startTime = moment(calendarDOList[0].startTime).add(1 + i, 'days').format("YYYY-MM-DD") + " " + shiftDOList[j].startTime;
}
if (shiftDOList[j].endDay == DayEnums.A_DAY) {
item.detList[0].endTime = moment(calendarDOList[0].endTime).add(-1 - dayNum + i + 1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[j].endTime;
} else if (shiftDOList[j].endDay == DayEnums.THE_DAY) {
item.detList[0].endTime = moment(calendarDOList[0].endTime).add(-dayNum + i + 1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[j].endTime;
} else if (shiftDOList[j].endDay == DayEnums.NEXT_DAY) {
item.detList[0].endTime = moment(calendarDOList[0].endTime).add(1 - dayNum + i + 1, 'days').format("YYYY-MM-DD") + " " + shiftDOList[j].endTime;
}
res.push(item);
}
}
}
} else if (detailCycle == '小时') {
for (var i = 0; i < 24; i++) {
var item = JSON.parse(JSON.stringify(obj));
item.colIndex = colIndex + i;
item.detList[0].startTime = moment(startTime).add(i, 'hours').format(DATETIME_FORMAT);
item.detList[0].endTime = moment(startTime).add(i + 1, 'hours').format(DATETIME_FORMAT);
res.push(item);
}
}
break;
case ReportTemplateCycleEnums.WORK:
if (detailCycle == '班') {
res.push(obj);
} else if (detailCycle == '小时') {
var hoursNum = moment(endTime).diff(moment(startTime), 'hours');
for (var i = 0; i < hoursNum; i++) {
var item = JSON.parse(JSON.stringify(obj));
item.colIndex = colIndex + i;
item.detList[0].startTime = moment(startTime).add(i, 'hours').format(DATETIME_FORMAT);
item.detList[0].endTime = moment(startTime).add(i + 1, 'hours').format(DATETIME_FORMAT);
res.push(item);
}
}
break;
default:
};
// 必须转为json格式
return JSON.stringify(res);
}
var para ={
"colIndex": 0,
"createByName": "李青松",
"cycle": "8",
"day": 2,
"endTime": "2022-08-31 00:00:00",
"entId": "87685456",
"factoryCalendarDTO": {
"calendarDOList": [{
"endTime": "2022-01-31 00:00:00",
"month": 1,
"startTime": "2022-01-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-02-28 00:00:00",
"month": 2,
"startTime": "2022-02-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-03-31 00:00:00",
"month": 3,
"startTime": "2022-03-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-04-30 00:00:00",
"month": 4,
"startTime": "2022-04-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-05-31 00:00:00",
"month": 5,
"startTime": "2022-05-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-06-30 00:00:00",
"month": 6,
"startTime": "2022-06-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-07-31 00:00:00",
"month": 7,
"startTime": "2022-07-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-08-31 00:00:00",
"month": 8,
"startTime": "2022-08-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-09-30 00:00:00",
"month": 9,
"startTime": "2022-09-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-10-31 00:00:00",
"month": 10,
"startTime": "2022-10-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-11-30 00:00:00",
"month": 11,
"startTime": "2022-11-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-12-31 00:00:00",
"month": 12,
"startTime": "2022-12-01 00:00:00",
"year": 2022
}],
"lastTenYears": [{
"endTime": "2022-01-31 00:00:00",
"entId": "87685456",
"month": 1,
"startTime": "2022-01-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-02-28 00:00:00",
"entId": "87685456",
"month": 2,
"startTime": "2022-02-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-03-31 00:00:00",
"entId": "87685456",
"month": 3,
"startTime": "2022-03-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-04-30 00:00:00",
"entId": "87685456",
"month": 4,
"startTime": "2022-04-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-05-31 00:00:00",
"entId": "87685456",
"month": 5,
"startTime": "2022-05-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-06-30 00:00:00",
"entId": "87685456",
"month": 6,
"startTime": "2022-06-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-07-31 00:00:00",
"entId": "87685456",
"month": 7,
"startTime": "2022-07-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-08-31 00:00:00",
"entId": "87685456",
"month": 8,
"startTime": "2022-08-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-09-30 00:00:00",
"entId": "87685456",
"month": 9,
"startTime": "2022-09-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-10-31 00:00:00",
"entId": "87685456",
"month": 10,
"startTime": "2022-10-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-11-30 00:00:00",
"entId": "87685456",
"month": 11,
"startTime": "2022-11-01 00:00:00",
"year": 2022
}, {
"endTime": "2022-12-31 00:00:00",
"entId": "87685456",
"month": 12,
"startTime": "2022-12-01 00:00:00",
"year": 2022
}, {
"endTime": "2021-01-31 00:00:00",
"entId": "87685456",
"month": 1,
"startTime": "2021-01-01 00:00:00",
"year": 2021
}, {
"endTime": "2021-02-28 00:00:00",
"entId": "87685456",
"month": 2,
"startTime": "2021-02-01 00:00:00",
"year": 2021
}, {
"endTime": "2021-03-31 00:00:00",
"entId": "87685456",
"month": 3,
"startTime": "2021-03-01 00:00:00",
"year": 2021
}, {
"endTime": "2021-04-30 00:00:00",
"entId": "87685456",
"month": 4,
"startTime": "2021-04-01 00:00:00",
"year": 2021
}, {
"endTime": "2021-05-31 00:00:00",
"entId": "87685456",
"month": 5,
"startTime": "2021-05-01 00:00:00",
"year": 2021
}, {
"endTime": "2021-06-30 00:00:00",
"entId": "87685456",
"month": 6,
"startTime": "2021-06-01 00:00:00",
"year": 2021
}, {
"endTime": "2021-07-31 00:00:00",
"entId": "87685456",
"month": 7,
"startTime": "2021-07-01 00:00:00",
"year": 2021
}, {
"endTime": "2021-08-31 00:00:00",
"entId": "87685456",
"month": 8,
"startTime": "2021-08-01 00:00:00",
"year": 2021
}, {
"endTime": "2021-09-30 00:00:00",
"entId": "87685456",
"month": 9,
"startTime": "2021-09-01 00:00:00",
"year": 2021
}, {
"endTime": "2021-10-31 00:00:00",
"entId": "87685456",
"month": 10,
"startTime": "2021-10-01 00:00:00",
"year": 2021
}, {
"endTime": "2021-11-30 00:00:00",
"entId": "87685456",
"month": 11,
"startTime": "2021-11-01 00:00:00",
"year": 2021
}, {
"endTime": "2021-12-31 00:00:00",
"entId": "87685456",
"month": 12,
"startTime": "2021-12-01 00:00:00",
"year": 2021
}, {
"endTime": "2020-01-31 00:00:00",
"entId": "87685456",
"month": 1,
"startTime": "2020-01-01 00:00:00",
"year": 2020
}, {
"endTime": "2020-02-29 00:00:00",
"entId": "87685456",
"month": 2,
"startTime": "2020-02-01 00:00:00",
"year": 2020
}, {
"endTime": "2020-03-31 00:00:00",
"entId": "87685456",
"month": 3,
"startTime": "2020-03-01 00:00:00",
"year": 2020
}, {
"endTime": "2020-04-30 00:00:00",
"entId": "87685456",
"month": 4,
"startTime": "2020-04-01 00:00:00",
"year": 2020
}, {
"endTime": "2020-05-31 00:00:00",
"entId": "87685456",
"month": 5,
"startTime": "2020-05-01 00:00:00",
"year": 2020
}, {
"endTime": "2020-06-30 00:00:00",
"entId": "87685456",
"month": 6,
"startTime": "2020-06-01 00:00:00",
"year": 2020
}, {
"endTime": "2020-07-31 00:00:00",
"entId": "87685456",
"month": 7,
"startTime": "2020-07-01 00:00:00",
"year": 2020
}, {
"endTime": "2020-08-31 00:00:00",
"entId": "87685456",
"month": 8,
"startTime": "2020-08-01 00:00:00",
"year": 2020
}, {
"endTime": "2020-09-30 00:00:00",
"entId": "87685456",
"month": 9,
"startTime": "2020-09-01 00:00:00",
"year": 2020
}, {
"endTime": "2020-10-31 00:00:00",
"entId": "87685456",
"month": 10,
"startTime": "2020-10-01 00:00:00",
"year": 2020
}, {
"endTime": "2020-11-30 00:00:00",
"entId": "87685456",
"month": 11,
"startTime": "2020-11-01 00:00:00",
"year": 2020
}, {
"endTime": "2020-12-31 00:00:00",
"entId": "87685456",
"month": 12,
"startTime": "2020-12-01 00:00:00",
"year": 2020
}, {
"endTime": "2019-01-31 00:00:00",
"entId": "87685456",
"month": 1,
"startTime": "2019-01-01 00:00:00",
"year": 2019
}, {
"endTime": "2019-02-28 00:00:00",
"entId": "87685456",
"month": 2,
"startTime": "2019-02-01 00:00:00",
"year": 2019
}, {
"endTime": "2019-03-31 00:00:00",
"entId": "87685456",
"month": 3,
"startTime": "2019-03-01 00:00:00",
"year": 2019
}, {
"endTime": "2019-04-30 00:00:00",
"entId": "87685456",
"month": 4,
"startTime": "2019-04-01 00:00:00",
"year": 2019
}, {
"endTime": "2019-05-31 00:00:00",
"entId": "87685456",
"month": 5,
"startTime": "2019-05-01 00:00:00",
"year": 2019
}, {
"endTime": "2019-06-30 00:00:00",
"entId": "87685456",
"month": 6,
"startTime": "2019-06-01 00:00:00",
"year": 2019
}, {
"endTime": "2019-07-31 00:00:00",
"entId": "87685456",
"month": 7,
"startTime": "2019-07-01 00:00:00",
"year": 2019
}, {
"endTime": "2019-08-31 00:00:00",
"entId": "87685456",
"month": 8,
"startTime": "2019-08-01 00:00:00",
"year": 2019
}, {
"endTime": "2019-09-30 00:00:00",
"entId": "87685456",
"month": 9,
"startTime": "2019-09-01 00:00:00",
"year": 2019
}, {
"endTime": "2019-10-31 00:00:00",
"entId": "87685456",
"month": 10,
"startTime": "2019-10-01 00:00:00",
"year": 2019
}, {
"endTime": "2019-11-30 00:00:00",
"entId": "87685456",
"month": 11,
"startTime": "2019-11-01 00:00:00",
"year": 2019
}, {
"endTime": "2019-12-31 00:00:00",
"entId": "87685456",
"month": 12,
"startTime": "2019-12-01 00:00:00",
"year": 2019
}, {
"endTime": "2018-01-31 00:00:00",
"entId": "87685456",
"month": 1,
"startTime": "2018-01-01 00:00:00",
"year": 2018
}, {
"endTime": "2018-02-28 00:00:00",
"entId": "87685456",
"month": 2,
"startTime": "2018-02-01 00:00:00",
"year": 2018
}, {
"endTime": "2018-03-31 00:00:00",
"entId": "87685456",
"month": 3,
"startTime": "2018-03-01 00:00:00",
"year": 2018
}, {
"endTime": "2018-04-30 00:00:00",
"entId": "87685456",
"month": 4,
"startTime": "2018-04-01 00:00:00",
"year": 2018
}, {
"endTime": "2018-05-31 00:00:00",
"entId": "87685456",
"month": 5,
"startTime": "2018-05-01 00:00:00",
"year": 2018
}, {
"endTime": "2018-06-30 00:00:00",
"entId": "87685456",
"month": 6,
"startTime": "2018-06-01 00:00:00",
"year": 2018
}, {
"endTime": "2018-07-31 00:00:00",
"entId": "87685456",
"month": 7,
"startTime": "2018-07-01 00:00:00",
"year": 2018
}, {
"endTime": "2018-08-31 00:00:00",
"entId": "87685456",
"month": 8,
"startTime": "2018-08-01 00:00:00",
"year": 2018
}, {
"endTime": "2018-09-30 00:00:00",
"entId": "87685456",
"month": 9,
"startTime": "2018-09-01 00:00:00",
"year": 2018
}, {
"endTime": "2018-10-31 00:00:00",
"entId": "87685456",
"month": 10,
"startTime": "2018-10-01 00:00:00",
"year": 2018
}, {
"endTime": "2018-11-30 00:00:00",
"entId": "87685456",
"month": 11,
"startTime": "2018-11-01 00:00:00",
"year": 2018
}, {
"endTime": "2018-12-31 00:00:00",
"entId": "87685456",
"month": 12,
"startTime": "2018-12-01 00:00:00",
"year": 2018
}, {
"endTime": "2017-01-31 00:00:00",
"entId": "87685456",
"month": 1,
"startTime": "2017-01-01 00:00:00",
"year": 2017
}, {
"endTime": "2017-02-28 00:00:00",
"entId": "87685456",
"month": 2,
"startTime": "2017-02-01 00:00:00",
"year": 2017
}, {
"endTime": "2017-03-31 00:00:00",
"entId": "87685456",
"month": 3,
"startTime": "2017-03-01 00:00:00",
"year": 2017
}, {
"endTime": "2017-04-30 00:00:00",
"entId": "87685456",
"month": 4,
"startTime": "2017-04-01 00:00:00",
"year": 2017
}, {
"endTime": "2017-05-31 00:00:00",
"entId": "87685456",
"month": 5,
"startTime": "2017-05-01 00:00:00",
"year": 2017
}, {
"endTime": "2017-06-30 00:00:00",
"entId": "87685456",
"month": 6,
"startTime": "2017-06-01 00:00:00",
"year": 2017
}, {
"endTime": "2017-07-31 00:00:00",
"entId": "87685456",
"month": 7,
"startTime": "2017-07-01 00:00:00",
"year": 2017
}, {
"endTime": "2017-08-31 00:00:00",
"entId": "87685456",
"month": 8,
"startTime": "2017-08-01 00:00:00",
"year": 2017
}, {
"endTime": "2017-09-30 00:00:00",
"entId": "87685456",
"month": 9,
"startTime": "2017-09-01 00:00:00",
"year": 2017
}, {
"endTime": "2017-10-31 00:00:00",
"entId": "87685456",
"month": 10,
"startTime": "2017-10-01 00:00:00",
"year": 2017
}, {
"endTime": "2017-11-30 00:00:00",
"entId": "87685456",
"month": 11,
"startTime": "2017-11-01 00:00:00",
"year": 2017
}, {
"endTime": "2017-12-31 00:00:00",
"entId": "87685456",
"month": 12,
"startTime": "2017-12-01 00:00:00",
"year": 2017
}, {
"endTime": "2016-01-31 00:00:00",
"entId": "87685456",
"month": 1,
"startTime": "2016-01-01 00:00:00",
"year": 2016
}, {
"endTime": "2016-02-29 00:00:00",
"entId": "87685456",
"month": 2,
"startTime": "2016-02-01 00:00:00",
"year": 2016
}, {
"endTime": "2016-03-31 00:00:00",
"entId": "87685456",
"month": 3,
"startTime": "2016-03-01 00:00:00",
"year": 2016
}, {
"endTime": "2016-04-30 00:00:00",
"entId": "87685456",
"month": 4,
"startTime": "2016-04-01 00:00:00",
"year": 2016
}, {
"endTime": "2016-05-31 00:00:00",
"entId": "87685456",
"month": 5,
"startTime": "2016-05-01 00:00:00",
"year": 2016
}, {
"endTime": "2016-06-30 00:00:00",
"entId": "87685456",
"month": 6,
"startTime": "2016-06-01 00:00:00",
"year": 2016
}, {
"endTime": "2016-07-31 00:00:00",
"entId": "87685456",
"month": 7,
"startTime": "2016-07-01 00:00:00",
"year": 2016
}, {
"endTime": "2016-08-31 00:00:00",
"entId": "87685456",
"month": 8,
"startTime": "2016-08-01 00:00:00",
"year": 2016
}, {
"endTime": "2016-09-30 00:00:00",
"entId": "87685456",
"month": 9,
"startTime": "2016-09-01 00:00:00",
"year": 2016
}, {
"endTime": "2016-10-31 00:00:00",
"entId": "87685456",
"month": 10,
"startTime": "2016-10-01 00:00:00",
"year": 2016
}, {
"endTime": "2016-11-30 00:00:00",
"entId": "87685456",
"month": 11,
"startTime": "2016-11-01 00:00:00",
"year": 2016
}, {
"endTime": "2016-12-31 00:00:00",
"entId": "87685456",
"month": 12,
"startTime": "2016-12-01 00:00:00",
"year": 2016
}, {
"endTime": "2015-01-31 00:00:00",
"entId": "87685456",
"month": 1,
"startTime": "2015-01-01 00:00:00",
"year": 2015
}, {
"endTime": "2015-02-28 00:00:00",
"entId": "87685456",
"month": 2,
"startTime": "2015-02-01 00:00:00",
"year": 2015
}, {
"endTime": "2015-03-31 00:00:00",
"entId": "87685456",
"month": 3,
"startTime": "2015-03-01 00:00:00",
"year": 2015
}, {
"endTime": "2015-04-30 00:00:00",
"entId": "87685456",
"month": 4,
"startTime": "2015-04-01 00:00:00",
"year": 2015
}, {
"endTime": "2015-05-31 00:00:00",
"entId": "87685456",
"month": 5,
"startTime": "2015-05-01 00:00:00",
"year": 2015
}, {
"endTime": "2015-06-30 00:00:00",
"entId": "87685456",
"month": 6,
"startTime": "2015-06-01 00:00:00",
"year": 2015
}, {
"endTime": "2015-07-31 00:00:00",
"entId": "87685456",
"month": 7,
"startTime": "2015-07-01 00:00:00",
"year": 2015
}, {
"endTime": "2015-08-31 00:00:00",
"entId": "87685456",
"month": 8,
"startTime": "2015-08-01 00:00:00",
"year": 2015
}, {
"endTime": "2015-09-30 00:00:00",
"entId": "87685456",
"month": 9,
"startTime": "2015-09-01 00:00:00",
"year": 2015
}, {
"endTime": "2015-10-31 00:00:00",
"entId": "87685456",
"month": 10,
"startTime": "2015-10-01 00:00:00",
"year": 2015
}, {
"endTime": "2015-11-30 00:00:00",
"entId": "87685456",
"month": 11,
"startTime": "2015-11-01 00:00:00",
"year": 2015
}, {
"endTime": "2015-12-31 00:00:00",
"entId": "87685456",
"month": 12,
"startTime": "2015-12-01 00:00:00",
"year": 2015
}, {
"endTime": "2014-01-31 00:00:00",
"entId": "87685456",
"month": 1,
"startTime": "2014-01-01 00:00:00",
"year": 2014
}, {
"endTime": "2014-02-28 00:00:00",
"entId": "87685456",
"month": 2,
"startTime": "2014-02-01 00:00:00",
"year": 2014
}, {
"endTime": "2014-03-31 00:00:00",
"entId": "87685456",
"month": 3,
"startTime": "2014-03-01 00:00:00",
"year": 2014
}, {
"endTime": "2014-04-30 00:00:00",
"entId": "87685456",
"month": 4,
"startTime": "2014-04-01 00:00:00",
"year": 2014
}, {
"endTime": "2014-05-31 00:00:00",
"entId": "87685456",
"month": 5,
"startTime": "2014-05-01 00:00:00",
"year": 2014
}, {
"endTime": "2014-06-30 00:00:00",
"entId": "87685456",
"month": 6,
"startTime": "2014-06-01 00:00:00",
"year": 2014
}, {
"endTime": "2014-07-31 00:00:00",
"entId": "87685456",
"month": 7,
"startTime": "2014-07-01 00:00:00",
"year": 2014
}, {
"endTime": "2014-08-31 00:00:00",
"entId": "87685456",
"month": 8,
"startTime": "2014-08-01 00:00:00",
"year": 2014
}, {
"endTime": "2014-09-30 00:00:00",
"entId": "87685456",
"month": 9,
"startTime": "2014-09-01 00:00:00",
"year": 2014
}, {
"endTime": "2014-10-31 00:00:00",
"entId": "87685456",
"month": 10,
"startTime": "2014-10-01 00:00:00",
"year": 2014
}, {
"endTime": "2014-11-30 00:00:00",
"entId": "87685456",
"month": 11,
"startTime": "2014-11-01 00:00:00",
"year": 2014
}, {
"endTime": "2014-12-31 00:00:00",
"entId": "87685456",
"month": 12,
"startTime": "2014-12-01 00:00:00",
"year": 2014
}, {
"endTime": "2013-01-31 00:00:00",
"entId": "87685456",
"month": 1,
"startTime": "2013-01-01 00:00:00",
"year": 2013
}, {
"endTime": "2013-02-28 00:00:00",
"entId": "87685456",
"month": 2,
"startTime": "2013-02-01 00:00:00",
"year": 2013
}, {
"endTime": "2013-03-31 00:00:00",
"entId": "87685456",
"month": 3,
"startTime": "2013-03-01 00:00:00",
"year": 2013
}, {
"endTime": "2013-04-30 00:00:00",
"entId": "87685456",
"month": 4,
"startTime": "2013-04-01 00:00:00",
"year": 2013
}, {
"endTime": "2013-05-31 00:00:00",
"entId": "87685456",
"month": 5,
"startTime": "2013-05-01 00:00:00",
"year": 2013
}, {
"endTime": "2013-06-30 00:00:00",
"entId": "87685456",
"month": 6,
"startTime": "2013-06-01 00:00:00",
"year": 2013
}, {
"endTime": "2013-07-31 00:00:00",
"entId": "87685456",
"month": 7,
"startTime": "2013-07-01 00:00:00",
"year": 2013
}, {
"endTime": "2013-08-31 00:00:00",
"entId": "87685456",
"month": 8,
"startTime": "2013-08-01 00:00:00",
"year": 2013
}, {
"endTime": "2013-09-30 00:00:00",
"entId": "87685456",
"month": 9,
"startTime": "2013-09-01 00:00:00",
"year": 2013
}, {
"endTime": "2013-10-31 00:00:00",
"entId": "87685456",
"month": 10,
"startTime": "2013-10-01 00:00:00",
"year": 2013
}, {
"endTime": "2013-11-30 00:00:00",
"entId": "87685456",
"month": 11,
"startTime": "2013-11-01 00:00:00",
"year": 2013
}, {
"endTime": "2013-12-31 00:00:00",
"entId": "87685456",
"month": 12,
"startTime": "2013-12-01 00:00:00",
"year": 2013
}, {
"endTime": "2012-01-31 00:00:00",
"entId": "87685456",
"month": 1,
"startTime": "2012-01-01 00:00:00",
"year": 2012
}, {
"endTime": "2012-02-29 00:00:00",
"entId": "87685456",
"month": 2,
"startTime": "2012-02-01 00:00:00",
"year": 2012
}, {
"endTime": "2012-03-31 00:00:00",
"entId": "87685456",
"month": 3,
"startTime": "2012-03-01 00:00:00",
"year": 2012
}, {
"endTime": "2012-04-30 00:00:00",
"entId": "87685456",
"month": 4,
"startTime": "2012-04-01 00:00:00",
"year": 2012
}, {
"endTime": "2012-05-31 00:00:00",
"entId": "87685456",
"month": 5,
"startTime": "2012-05-01 00:00:00",
"year": 2012
}, {
"endTime": "2012-06-30 00:00:00",
"entId": "87685456",
"month": 6,
"startTime": "2012-06-01 00:00:00",
"year": 2012
}, {
"endTime": "2012-07-31 00:00:00",
"entId": "87685456",
"month": 7,
"startTime": "2012-07-01 00:00:00",
"year": 2012
}, {
"endTime": "2012-08-31 00:00:00",
"entId": "87685456",
"month": 8,
"startTime": "2012-08-01 00:00:00",
"year": 2012
}, {
"endTime": "2012-09-30 00:00:00",
"entId": "87685456",
"month": 9,
"startTime": "2012-09-01 00:00:00",
"year": 2012
}, {
"endTime": "2012-10-31 00:00:00",
"entId": "87685456",
"month": 10,
"startTime": "2012-10-01 00:00:00",
"year": 2012
}, {
"endTime": "2012-11-30 00:00:00",
"entId": "87685456",
"month": 11,
"startTime": "2012-11-01 00:00:00",
"year": 2012
}, {
"endTime": "2012-12-31 00:00:00",
"entId": "87685456",
"month": 12,
"startTime": "2012-12-01 00:00:00",
"year": 2012
}],
"shiftDOList": [{
"endDay": 0,
"endTime": "08:00:00",
"name": "第一班",
"startDay": 0,
"startTime": "00:00:00"
}, {
"endDay": 0,
"endTime": "16:00:00",
"name": "第二班",
"startDay": 0,
"startTime": "08:00:00"
}, {
"endDay": 1,
"endTime": "00:00:00",
"name": "第三班",
"startDay": 0,
"startTime": "16:00:00"
}]
},
"month": 8,
"quarter": 3,
"rowIndex": 1,
"sheetIndex": 0,
"startTime": "2022-08-01 00:00:00",
"templateVarValType": "采集值",
"unitId": "396731776942485518",
"year": 2022,
"yearNum": 2
};
console.log(currentSPDsRow("#JLDL009+JLDL007", "月", para));
console