def generateByWeek(startTime,endTime): ''' 生成每周邮件内容 ''' startTime = '{} 00:00:00'.format(startTime) endTime = '{} 23:59:59'.format(endTime) dataAccess = DataAccess() sailOrderNum,sailOrderPrice,_ = dataAccess.getdetailSailOrders(startTime,endTime) #获取销售订单数量,价格 purchaseNum,purchasePrice,_ =dataAccess.getdetailPurchases(startTime,endTime) #获取采购订单数量,价格 paysAmount,_= dataAccess.getdetailPays(startTime,endTime) #获取付款数目 billsAmount,_ = dataAccess.getdetaillBills(startTime,endTime) #获取收款数目 records = dataAccess.getSaleRecordOfPerson(startTime,endTime) #获取每位员工的销售情况 time = '{} 至 {}'.format(startTime,endTime) text = ''' 时间:{0}<br/> <b>本周销售订单情况</b><br/>共<a style="color:blue ">{1}</a>单, 合计金额<a style="color:blue ">{2:,}</a>元。 <br> <b>本周采购情况订单</b><br/>共<a style="color:red ">{3}</a>单, 合计金额<a style="color:red ">{4:,}</a>元。 <br/> <b>本周收付款情况</b><br/> 合计付款金额<a style="color:red ">{5:,}</a>元<br/>合计收款金额<a style="color:blue ">{6:,}</a>元。 <br /> <h3>人员销售业绩</h3><br>{7} '''.format(time,sailOrderNum,sailOrderPrice,purchaseNum,purchasePrice,paysAmount,billsAmount,records) return text
def generate(startTime, endTime): ''' 生成每日邮件内容 ''' startTime = '{} 00:00:00'.format(startTime) endTime = '{} 23:59:59'.format(endTime) dataAccess = DataAccess() time = '{} 至 {}'.format(startTime, endTime) orderNum, OrderpriceNum, detailsail = dataAccess.getdetailSailOrders( startTime, endTime) purchaseNum, purchasepriceNum, detailpur = dataAccess.getdetailPurchases( startTime, endTime) billprice, detailbills = dataAccess.getdetaillBills(startTime, endTime) purchaseprice, detailpays = dataAccess.getdetailPays(startTime, endTime) saleOrdersMoneyExpired = dataAccess.getSaleOrders_MoneyExpired() productsShipExpired = dataAccess.getProducts_ShipExpired() text = '''时间:{0}<br/><b>今日销售订单情况</b><br/>共<a style="color:blue ">{1}</a>单,合计金额<a style="color:blue ">{2}</a>元。 <br><b>今日采购情况订单</b><br/>共<a style="color:red ">{3}</a>单,合计金额<a style="color:red ">{4}</a>元。<br/> <b>今日收付款情况</b><br/>合计付款金额<a style="color:red ">{5}</a>元<br/>合计收款金额<a style="color:blue ">{6}</a>元。<br /><h3>销售清单</h3><br> {7}<br /><h3>采购清单</h3><br>{8}<br /><h3>收款清单</h3><br>{9}<br /><h3>付款清单</h3><br>{10}<br /> <h3>到期未收款订单信息</h3><br>{11}<br /> <h3> 到期未发货的产品信息</h3>{12} '''.format(time, orderNum, OrderpriceNum, purchaseNum, purchasepriceNum, purchaseprice, billprice, detailsail, detailpur, detailbills, detailpays, saleOrdersMoneyExpired, productsShipExpired) return text