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>')