def get_display(self): filter_data = FilterData.get_from_cgi() values = filter_data.get_values("custom", "year") year = 0 for value in values: if value: try: year = int(value) except: pass if not year: date = Date() year = int(date.get_year()) sobject = self.get_current_sobject() id = sobject.get_id() column = self.get_option("column") month = int(self.get_option('month')) end_year = year end_month = month + 1 if end_month > 12: end_month = 1 end_year += 1 search_type = 'MMS/personal_time_log' if year: search = Search(search_type) search.add_filter('login_id', id) search.add_filter('work_performed_date', '%s-%0.2d-01' % (year, month), '>') search.add_filter('work_performed_date', '%s-%0.2d-01' % (end_year, end_month), '<') sobjects = search.get_sobjects() else: sobjects = [] if sobjects: parser = ExpressionParser() sum = parser.eval("@SUM(%s.%s)" % (search_type, column), sobjects=sobjects) else: sum = 0 div = DivWdg() div.add(sum) return div
def get_display(my): filter_data = FilterData.get_from_cgi() values = filter_data.get_values("custom", "year") year = 0 for value in values: if value: try: year = int(value) except: pass if not year: date = Date() year = int(date.get_year()) sobject = my.get_current_sobject() id = sobject.get_id() column = my.get_option("column") month = int( my.get_option('month') ) end_year = year end_month = month + 1 if end_month > 12: end_month = 1 end_year += 1 search_type = 'MMS/personal_time_log' if year: search = Search(search_type) search.add_filter('login_id', id) search.add_filter('work_performed_date', '%s-%0.2d-01' % (year,month), '>') search.add_filter('work_performed_date', '%s-%0.2d-01' % (end_year,end_month), '<') sobjects = search.get_sobjects() else: sobjects = [] if sobjects: parser = ExpressionParser() sum = parser.eval("@SUM(%s.%s)" % (search_type,column),sobjects=sobjects) else: sum = 0 div = DivWdg() div.add(sum) return div
def get_display(my): today = Date() cur_year = int(today.get_year()) limit = my.get_option('limit') if limit: limit = int(limit) else: limit = 10 years = [i for i in xrange(cur_year-limit + 1, cur_year + 1)] years.reverse() my.set_option('values', years) return super(YearSelectWdg, my).get_display()
def get_display(self): today = Date() cur_year = int(today.get_year()) limit = self.get_option('limit') if limit: limit = int(limit) else: limit = 10 years = [i for i in xrange(cur_year - limit + 1, cur_year + 1)] years.reverse() self.set_option('values', years) return super(YearSelectWdg, self).get_display()