def export_price_sheet(self): inputParams = self.getInput() try: order = Orders.get(Orders.id == int(inputParams['id'])) details = OrderDetails.select().where(OrderDetails.order == order).order_by(OrderDetails.id.desc()) self.privData['ORDER'] = order self.privData['DETAILS'] = details import pdfcrowd # create an API client instance client = pdfcrowd.Client("luo_brian", "8fee9a05739553c92673004a3ec80201") # convert an HTML string and save the result to a file import os import config import utils tmpFile = os.path.join(config.UPLOAD_DIR, 'temp', '%s.pdf' % utils.uuidgen()) ofile = open(tmpFile, 'wb') html = self.display('price-sheet-details-pdf') #html="<head></head><body>我的转换</body>" client.convertHtml(html, ofile) ofile.close() buf = open(tmpFile).read() os.unlink(tmpFile) web.header('Content-Type', 'application/pdf') return buf except Exception, e: print e return self.error(msg='获取订单详情失败!')
def price_sheet_details(self): inputParams = self.getInput() try: #import pdb;pdb.set_trace(); order = Orders.get(Orders.id == int(inputParams['id'])) details = OrderDetails.select().where(OrderDetails.order == order).order_by(OrderDetails.id.desc()) for od in details: print od.product.diameter self.privData['ORDER'] = order self.privData['DETAILS'] = details return self.display('price-sheet-details') except Exception, e: print e return self.error(msg='获取订单详情失败!')
def edit_price_sheet(self): inputs = self.getInput() try: #import pdb; pdb.set_trace() order = Orders.get(Orders.id == int(inputs['id'])) details = OrderDetails.select().where(OrderDetails.order == order).order_by(OrderDetails.id.desc()) for each_d in details: print each_d.name print each_d.flag self.privData['ORDER'] = order self.privData['DETAILS'] = details return self.display('edit-price-sheet') except Exception,e: print e return self.error(msg='获取报价单详情信息失败!')