def orders(self, **kw):
orders = Order.query.find().sort('creation_date', -1).limit(250)
grouped_orders = groupby(orders, lambda o: o.creation_date.strftime('%d/%m/%Y'))
all_the_vats = Order.all_the_vats()
return dict(orders=grouped_orders, form=OrderFilterForm, value=kw, action=self.mount_point+'/submit_orders',
bill_issue=self.mount_point+'/bill_issue/%s', notes=self.mount_point+'/notes/%s',
edit=self.mount_point+'/edit?order_id=%s', all_the_vats=all_the_vats)
def submit_orders(self, **kw):
if kw['field'] == 'user':
orders = Order.query.find({kw['field']: {'$regex': kw['filt'], '$options': 'i'}})
elif kw['field'] == 'status_changes.changed_at':
date_ = kw['filt']
day_start = datetime(date_.year, date_.month, date_.day)
day_end = datetime(date_.year, date_.month, date_.day, 23, 59, 59)
orders = Order.query.find({kw['field']: {'$gte': day_start, '$lte': day_end}})
else:
orders = Order.query.find({kw['field']: kw['filt']})
orders = orders.sort('status_changes.changed_at', -1).limit(250)
grouped_orders = groupby(orders, lambda o: o.status_changes[-1].changed_at.strftime('%d/%m/%Y'))
all_the_vats = Order.all_the_vats()
return dict(orders=grouped_orders, form=OrderFilterForm, value=kw, action=self.mount_point+'/submit_orders',
bill_issue=self.mount_point+'/bill_issue/%s', notes=self.mount_point+'/notes/%s',
all_the_vats=all_the_vats)
