def mergeOrg2DepartmentReport(resultDir, reportDirName, orgName,
histroryFileName):
fileList = scanDir(reportDirName)
for fileName in fileList:
if fileName.find(".docx") > 0:
# 将从班组周报信息改为从合并后的周报获取信息
singleWeekDict = extractAllInfo(fileName)
histroryFileName = mergeAllinfo2HistoryXlsx(
resultDir, orgName, singleWeekDict, histroryFileName)
def mergeExcelReport(resultDir, orgName, histroryFileName):
fileList = scanDir(resultDir)
for fileName in fileList:
if fileName.find(".docx") > 0:
# 将从原始文件获取周报信息改为从合并后的周报获取信息
doneDict = extractDoneInfo(fileName)
histroryFileName = merge2HistoryXlsx(resultDir, orgName, doneDict,
histroryFileName)
return histroryFileName
def generateHistoryReport():
tempHistorytDirName = 'history_' + str(
datetime.datetime.now().month) + str(datetime.datetime.now().day)
createTempDir(tempHistorytDirName)
# 下载历史团队周报
downloadReports(emailaddress, password, pop3_server, teamNumber, 14, -14,
'汇总.xls', tempHistorytDirName)
historyFiles = scanDir(tempHistorytDirName)
histroryFileName = tempHistorytDirName + '/history.xlsx'
renameFile(historyFiles[0], histroryFileName)
return histroryFileName, tempHistorytDirName
historyFiles = scanDir(tempHistorytDirName)
histroryFileName = tempHistorytDirName + '/history.xlsx'
renameFile(historyFiles[0], histroryFileName)
return histroryFileName, tempHistorytDirName
def getRelativeNameList(dirName, fullNameList):
out = []
for fullName in fullNameList:
name = getRelativeName(fullName)
out.append(dirName + '/' + name)
return out
if __name__ == '__main__':
emailaddress, password, pop3_server, smtp_server, teamNumber, orgName, toAddress = loadConfig(
)
timeStampe = str(datetime.datetime.now().month) + str(
datetime.datetime.now().day)
tempResultDirName = 'result_' + timeStampe
createTempDir(tempResultDirName)
histroryFileName, tempHistorytDirName = generateHistoryReport()
# 合并到excel
mergeExcelReport(tempResultDirName, orgName, histroryFileName)
# 扫描成果文件夹
resultList = scanDir(tempResultDirName)
# 将成果作为邮件附件发送到管理邮箱中
sendResults(getRelativeNameList(tempResultDirName, resultList),
emailaddress, emailaddress, password, smtp_server, "软件二组周报")
clearTempDirs(tempHistorytDirName)
clearTempDirs(tempResultDirName)
#!/usr/bin/python3
# _*_ coding: utf-8 _*_
import datetime
from mailOperate import downloadReports,sendResults
from mergeWordReport import mergeWordReport
from mergeExcelReport import mergeExcelReport
from fileUtil import scanDir,clearTempDirs,clearFiles,createTempDir,renameFile,loadConfig
if __name__ == '__main__':
emailaddress,password,pop3_server,smtp_server,teamNumber,orgName,toAddress=loadConfig()
timeStampe=str(datetime.datetime.now().month)+str(datetime.datetime.now().day)
tempReportDirName='reports_'+timeStampe
tempResultDirName='result_'+timeStampe
createTempDir(tempReportDirName)
createTempDir(tempResultDirName)
# 下载团队成员周报
downloadReports(emailaddress,password,pop3_server,teamNumber,7,-7,'周报',tempReportDirName)
# 扫描文件夹
reportInfoList=scanDir(tempReportDirName)
# 合并到word
mergeWordReport(tempResultDirName,teamNumber,orgName,reportInfoList)
clearTempDirs(tempReportDirName)