自定义任务实现修改导出文件名称_邮件方式

importPackage(Packages.smartbi.email.module);
importPackage(Packages.java.io);
//报表ID
var reportID = 'I4028818a015d62bd62bd9475015d97c4ee9b40d9';
//报表参数设置：日期参数 默认值是今天
var reportParamSetting = [
    {id:"OutputParameter.I4028818a015d62bd62bd9475015d97c4d00040d5.开始日期2",value:getNowFormatDate(),displayValue:getNowFormatDate()}
];
//收件人邮箱，多个时，用英文分号隔开(;)
var mailList = "zhangxueqiong@smartbi.com.cn;zhangmeiting@smartbi.com.cn";
//邮件的内容
var mailText = "这是一个系统自动发送的邮件，所含附件是您订阅的报表";
//报表名称的固定值
var seperatorFix = "_V01";
//服务器临时文件目录
var tmpPath = "c:/";
//获取当前日期：YYYY-MM-DD
function getNowFormatDate() {
    var date = new Date();
    var seperator1 = "";
    var month = date.getMonth() + 1;
    var strDate = date.getDate();
    if (month >= 1 && month <= 9) {
        month = "0" + month;
    }
    if (strDate >= 0 && strDate <= 9) {
        strDate = "0" + strDate;
    }
 //YYYY-MM-DD 
 var currentdate_date = date.getFullYear() + seperator1 + month + seperator1 + strDate;
    return currentdate_date;
}var openReportOutput = execute('openResource', {
  connector: connector,
  reportId: reportID
});
var enumerateParamValuesOutput = execute('enumerateParamValues', {
  resourceHandle: openReportOutput.resourceHandle,
  byEveryParam: false,
  paramsSetting: reportParamSetting
});
var exportReportOutput = execute('exportResource', {
  connector: connector,
  resourceHandle: openReportOutput.resourceHandle,
  paramSettingIterator: enumerateParamValuesOutput.getParamValues(),
  exportSetting: {"delimiter":"","pathId":"","fileNameSufParams":true},
  taskName: taskName,
  exportType: "EXCEL2007"
});
openReportOutput.resourceHandle.close();
var outputFile = exportReportOutput.file;
//文件重命名
var fileName = outputFile.getName();
var index = fileName.lastIndexOf(".");
var newName = fileName.substring(0, index)+seperatorFix+"."+fileName.substring(index+1);//新建一个重命名的文件
var destFile = new File(tmpPath+newName);
//文件若存在，则删掉
if(destFile.exists()){
  destFile.delete();
}
var flag = outputFile.renameTo(destFile);
outputFile = destFile;
var sendToMailOutput = execute('sendToMail', {
  connector: connector,
  taskName: taskName,
  paramValueMap: null,
  files: [outputFile],
  sendSetting: {"mailList":mailList,"doZip":false,"title":"%TASKNAME_%DATE%TIME","text":mailText,"picInMail":false}
});