def _group_by_user_monthly(self, data, user_id): result = {} _excuses = excuses.wrongtime() for date, incorrect_count in data: day_data = result.setdefault(date.day, [0, '']) excuse = '-' if date.strftime('%Y-%m-%d') in _excuses.get(user_id, {}).keys(): excuse = _excuses[user_id][date.strftime('%Y-%m-%d')] day_data[0] = incorrect_count day_data[1] = excuse return result
def _annually_report(self, year): year_start = datetime.date(year, 1, 1) year_end = datetime.date(year, 12, 31) excuses_error = None config_obj = ApplicationConfig.get_current_config() entries = DBSession.query('user_id', 'date').from_statement(""" SELECT date_trunc('day', s.date) as date, s.user_id as user_id FROM time_entry s WHERE DATE(s.modified_ts) > s.date AND s.date >= :year_start AND s.date <= :year_end GROUP BY date_trunc('day', s.date), s.user_id """).params(year_start=year_start, year_end=year_end) users = User.query.filter(User.is_active==True)\ .filter(User.is_not_client())\ .order_by(User.is_freelancer(), User.name) entries_grouped = {} _excuses = excuses.wrongtime() for user_id, date in entries: month = date.month - 1 entry = entries_grouped.setdefault(user_id, [0] * 12) if date.strftime('%Y-%m-%d') not in _excuses.get(user_id, {}).keys(): entry[month] += 1 stats = {} for user_id, entry in entries_grouped.iteritems(): stats_entry = stats.setdefault(user_id, [0]) stats_entry[0] = sum(entry) return dict( entries=entries_grouped, stats=stats, users=users, year_start=year_start, limit=config_obj.monthly_incorrect_time_record_limit, excuses_error=excuses_error, )
def _annually_report(self, year): year_start = datetime.date(year, 1, 1) year_end = datetime.date(year, 12, 31) excuses_error = None config_obj = ApplicationConfig.get_current_config() entries = DBSession.query('user_id', 'date').from_statement(""" SELECT date_trunc('day', s.date) as date, s.user_id as user_id FROM time_entry s WHERE DATE(s.modified_ts) > s.date AND s.date >= :year_start AND s.date <= :year_end GROUP BY date_trunc('day', s.date), s.user_id """).params(year_start=year_start, year_end=year_end) users = User.query.filter(User.is_active==True)\ .filter(User.is_not_client())\ .order_by(User.is_freelancer(), User.name) entries_grouped = {} _excuses = excuses.wrongtime() for user_id, date in entries: month = date.month - 1 entry = entries_grouped.setdefault(user_id, [0]*12) if date.strftime('%Y-%m-%d') not in _excuses.get(user_id, {}).keys(): entry[month] += 1 stats = {} for user_id, entry in entries_grouped.iteritems(): stats_entry = stats.setdefault(user_id, [0]) stats_entry[0] = sum(entry) return dict( entries=entries_grouped, stats=stats, users=users, year_start=year_start, limit=config_obj.monthly_incorrect_time_record_limit, excuses_error=excuses_error, )
def get(self): month_start, month_end = self._get_month() entries = self.session.query('user_id', 'date', 'time', 'late_count').from_statement(""" SELECT t.user_id as "user_id", t.date as "date", ( SELECT COALESCE(SUM(h.time), 0.0) FROM time_entry h WHERE h.user_id = t.user_id AND h.date = t.date AND h.deleted = FALSE ) as "time", ( SELECT COUNT(*) FROM time_entry s WHERE s.user_id = t.user_id AND s.date = t.date AND DATE(s.modified_ts) > s.date ) as "late_count" FROM time_entry t WHERE t.date >= :month_start AND t.date <= :month_end GROUP BY t.user_id, t.date; """).params(month_start=month_start, month_end=month_end) if not self.request.has_perm('view'): users = [self.request.user] # TODO do we need to constrain entries also? locations= { self.request.user.location: ('', 1) } else: users_w = User.query.filter(User.is_not_client()) \ .filter(User.is_active==True) \ .filter(User.location=='wroclaw') \ .order_by(User.freelancer, User.name) \ .all() users_p = User.query.filter(User.is_not_client()) \ .filter(User.is_active==True) \ .filter(User.location=='poznan') \ .order_by(User.freelancer, User.name) \ .all() locations = { 'wroclaw': [u'Wrocław', len(users_w)], 'poznan': [u'Poznań', len(users_p)], } locations[self.request.user.location][1] -= 1 if self.request.user.location == 'wroclaw': users = users_w users.extend(users_p) else: users = users_p users.extend(users_w) today = datetime.date.today() grouped = defaultdict(lambda: defaultdict(lambda: 0.0)) late = defaultdict(lambda: defaultdict(lambda: False)) sums = defaultdict(lambda: 0.0) daily_sums = defaultdict(lambda: 0.0) for user_id, date, time, late_count in entries: grouped[user_id][date] = time if date <= today: sums[user_id] += time daily_sums[date] += time late[user_id][date] = late_count > 0 holidays = Holiday.all() count_of_required_month_hours = {} count_of_required_hours_to_today = {} for user in users: sftw = user.start_full_time_work or datetime.date(1970, 1, 1) if sftw > month_end: start_work = datetime.date(today.year+10, 1, 1) elif sftw < month_start: start_work = month_start else: start_work = sftw count_of_required_month_hours[user.id] = h.get_working_days(start_work, month_end) * 8 count_of_required_hours_to_today[user.id] = h.get_working_days(start_work, today if today < month_end else month_end) * 8 # move current user to the front of the list current_user_index = None for i, user in enumerate(users): if user.id == self.request.user.id: current_user_index = i users.insert(0, users.pop(current_user_index)) return dict( entries=grouped, users=users, sums=sums, late=late, excuses=excuses.wrongtime(), daily_sums=daily_sums, monthly_sum=sum(daily_sums.values()), dates=__builtin__.list(dates_between(month_start, month_end)), is_holiday=lambda date: Holiday.is_holiday(date, holidays=holidays), month_start=month_start, prev_date=previous_month(month_start), next_date=next_month(month_start), today=today, count_of_required_month_hours=count_of_required_month_hours, count_of_required_hours_to_today=count_of_required_hours_to_today, locations=locations, )
def get(self): month_start, month_end = self._get_month() entries = ( DBSession.query("user_id", "date", "time", "late_count") .from_statement( """ SELECT t.user_id as "user_id", t.date as "date", ( SELECT COALESCE(SUM(h.time), 0.0) FROM time_entry h WHERE h.user_id = t.user_id AND h.date = t.date AND h.deleted = FALSE ) as "time", ( SELECT COUNT(*) FROM time_entry s WHERE s.user_id = t.user_id AND s.date = t.date AND DATE(s.modified_ts) > s.date ) as "late_count" FROM time_entry t WHERE t.date >= :month_start AND t.date <= :month_end GROUP BY t.user_id, t.date; """ ) .params(month_start=month_start, month_end=month_end) ) if not self.request.has_perm("can_see_users_times"): users = [self.request.user] # TODO do we need to constrain entries also? locations = {self.request.user.location: ("", 1)} else: location_names = self.request.user.get_locations() users = {} for name, (fullname, shortcut) in location_names: usersq = ( User.query.filter(User.is_not_client()) .filter(User.is_active == True) .filter(User.location == name) .order_by(User.is_freelancer(), User.name) ) users[name] = usersq.all() locations = {name: [User.LOCATIONS[name][0], len(users)] for name, users in users.iteritems()} locations[self.request.user.location][1] -= 1 ordered_users = [] for name, (fullname, shortcut) in location_names: ordered_users.extend(users[name]) users = ordered_users # move current user to the front of the list current_user_index = None for i, user in enumerate(users): if user.id == self.request.user.id: current_user_index = i users.insert(0, users.pop(current_user_index)) today = datetime.date.today() grouped = defaultdict(lambda: defaultdict(lambda: 0.0)) late = defaultdict(lambda: defaultdict(lambda: False)) sums = defaultdict(lambda: 0.0) daily_sums = defaultdict(lambda: 0.0) for user_id, date, time, late_count in entries: grouped[user_id][date] = time if date <= today: sums[user_id] += time daily_sums[date] += time late[user_id][date] = late_count > 0 holidays = Holiday.all() count_of_required_month_hours = {} count_of_required_hours_to_today = {} for user in users: sftw = user.start_full_time_work if sftw: if sftw > month_end: start_work = datetime.date(today.year + 10, 1, 1) elif sftw < month_start: start_work = month_start else: start_work = sftw month_hours = h.get_working_days(start_work, month_end) * 8 today_ = today if today < month_end else month_end hours_to_today = h.get_working_days(start_work, today_) * 8 count_of_required_month_hours[user.id] = month_hours count_of_required_hours_to_today[user.id] = hours_to_today else: count_of_required_month_hours[user.id] = 0 count_of_required_hours_to_today[user.id] = 0 return dict( entries=grouped, users=users, sums=sums, late=late, excuses=excuses.wrongtime(), daily_sums=daily_sums, monthly_sum=sum(daily_sums.values()), dates=__builtin__.list(dates_between(month_start, month_end)), is_holiday=lambda date: Holiday.is_holiday(date, holidays=holidays), month_start=month_start, prev_date=previous_month(month_start), next_date=next_month(month_start), today=today, count_of_required_month_hours=count_of_required_month_hours, count_of_required_hours_to_today=count_of_required_hours_to_today, locations=locations, )