def burning_data(self): burnings = Burning.query.filter( Burning.team == self, Burning.day >= utils.get_current_monday(), Burning.day < utils.get_next_monday()) today_remaining = Task.query.session.query(func.sum(Task.price).label('remaining')).filter( or_(Task.status == 'READY', Task.status == 'PROGRESS'), Task.team == self).one().remaining or 0 today_burning = Task.query.session.query(func.sum(Task.price).label( 'burning')).filter(Task.status == 'DONE', Task.last_updated > utils.today(), Task.team == self).one().burning or 0 return json.dumps([[b.remaining for b in burnings] + [today_remaining], [b.burning for b in burnings] + [today_burning]])
def burning_data(self): burnings = Burning.query.filter( Burning.team == self, Burning.day >= utils.get_current_monday(), Burning.day < utils.get_next_monday()) today_remaining = Task.query.session.query( func.sum(Task.price).label('remaining')).filter( or_(Task.status == 'READY', Task.status == 'PROGRESS'), Task.team == self).one().remaining or 0 today_burning = Task.query.session.query( func.sum(Task.price).label('burning')).filter( Task.status == 'DONE', Task.last_updated > utils.today(), Task.team == self).one().burning or 0 return json.dumps([[b.remaining for b in burnings] + [today_remaining], [b.burning for b in burnings] + [today_burning]])
def daily_meeting_tasks(self): return Task.query.filter(Task.team == self, Task.start_time >= utils.yestoday(), Task.start_time < utils.today())