def generate(self): saleId = self.IntReq('Id') try: sale = Sale.get(Sale.id == saleId) except: sale = Sale.get() self.headers.append(('Id', str(sale.id))) self.headers.append(('CustomerId', str(sale.customer.id))) self.headers.append(('CustomerName', sale.customer.name)) self.headers.append(('Date', sale.date)) self.headers.append(('Time', sale.time)) self.headers.append(('DateTime', getDate() + ' ' + getTime())) self.headers.append(('Remain', '0')) self.headers.append(('UserName', sale.user.fullname())) details = [d for d in sale.details] pages = split(details, _max_rows_) for page_details in pages: self.Echo('<Page>') for row in page_details: self.Echo('<Row>') self.EchoTag('ProductId', row.id) self.EchoTag('StorageName', row.storage.name) self.EchoTag('ProductName', row.product.name) self.EchoTag('Quantity', row.quantity) self.EchoTag('UnitPrice', row.saleprice) self.EchoTag('FullPrice', str(row.full_sale())) self.Echo('</Row>') self.Echo('</Page>')
def generate(self): username = self.StringReq('User') try: user = User.get(User.username == username) except: user = User.get() self.headers.append(('DateTime', getDate() + ' ' + getTime())) self.headers.append(('UserName', user.fullname())) list = user.salelist list = [d for d in list] users = User.select() for user in users: self.Echo('<User>') self.EchoTag('Id', user.username) self.EchoTag('UserName', user.fullname()) self.Echo('</User>') pages = split(list, _max_rows_) for list in pages: self.Echo('<Page>') for row in list: self.Echo('<Row>') self.EchoTag('Id', row.id) self.EchoTag('Time', row.time) self.EchoTag('Customer', row.customer.name) self.EchoTag('FullSale', row.fullsale) self.EchoTag('Prepaid', row.advance) self.EchoTag('Remain', row.remind()) self.Echo('</Row>') self.Echo('</Page>')
def generate(self): self.headers.append(('DateTime', getDate() + ' ' + getTime())) list = Cost().select() list = [d for d in list] pages = split(list, _max_rows_) for list in pages: self.Echo('<Page>') for row in list: self.Echo('<Row>') self.EchoTag('Title', row.title) self.EchoTag('InvoiceId', row.invoiceno) self.EchoTag('RegDate', row.regdate) self.EchoTag('Amount', row.amount) self.Echo('</Row>') self.Echo('</Page>')
def generate(self): storageId = self.IntReq('Id') try: storage = Storage.get(Storage.id == storageId) except: storage = Storage.get() self.headers.append(('StorageName', storage.name)) self.headers.append(('DateTime', getDate() + ' ' + getTime())) storages = Storage.select() for st in storages: self.Echo('<Storage>'); self.EchoTag('Id', st.id) self.EchoTag('Name', st.name) self.Echo('</Storage>'); list = storage.goodlist() list = [d for d in list] pages = split(list, _max_rows_) for list in pages: self.Echo('<Page>') for row in list: self.Echo('<Row>') self.EchoTag('ProductId', row.product.id) self.EchoTag('StorageName', row.storage.name) self.EchoTag('ProductName', row.product.name) self.EchoTag('CategoryName', row.product.group.name) self.EchoTag('Entrance', row.storage_entrance(storage)) self.EchoTag('Egress', row.storage_egress(storage)) self.EchoTag('Current', row.storage_current(storage)) # self.EchoTag('UnitPrice',row.saleprice) # self.EchoTag('FullPrice',str(row.full_sale())) self.Echo('</Row>') self.Echo('</Page>')