# -*- coding: utf-8 -*- import datetime from gluon import * class TeachersPaymentClasses: """ Class that gathers useful functions for db.teachers_payments_attendance """ def check_missing(self, date_from, date_until): """ :param date_from: :param date_until: :return: """ from date_tools import DateTools from .os_class import Class from .os_class_schedule import ClassSchedule T = current.T db = current.db dt = DateTools() error = False message = '' classes_added = 0 days_between = dt.days_between_dates(date_from, date_until) if days_between == False: error = True message = T("From date has to be smaller then until date.") if days_between > 92: error = True message = T("Gap between dates can not be more then 3 months") if not error: date = date_from while date <= date_until: cs = ClassSchedule(date) classes = cs.get_day_list() for cls in classes: if not cls['Cancelled'] or cls['Holiday']: # Check if item in db.teachers_payment_classes query = (db.teachers_payment_classes.classes_id == cls['ClassesID']) & \ (db.teachers_payment_classes.ClassDate == date) & \ ((db.teachers_payment_classes.Status == 'verified') | (db.teachers_payment_classes.Status == 'processed')) if db(query).count() == 0: os_cls = Class( cls['ClassesID'], date ) # This inserts or updates the class data with status not_verified result = os_cls.get_teacher_payment() if not result['error']: classes_added += 1 date += datetime.timedelta(days=1) message = classes_added return dict( error=error, message=message ) def get_rows(self, status='not_verified', sorting='time', date_from=None, date_until=None, formatted=False, all=False, items_per_page = 100, page = 0): db = current.db limitby = None if not all: limitby = (page * items_per_page, (page + 1) * items_per_page + 1) left = [ db.classes.on( db.teachers_payment_classes.classes_id == db.classes.id ), db.invoices_items_teachers_payment_classes.on( db.invoices_items_teachers_payment_classes.teachers_payment_classes_id == db.teachers_payment_classes.id ), db.invoices_items.on( db.invoices_items_teachers_payment_classes.invoices_items_id == db.invoices_items.id ), db.invoices.on( db.invoices_items.invoices_id == db.invoices.id ) ] if sorting == 'time': orderby = ~db.teachers_payment_classes.ClassDate | \ db.classes.Starttime elif sorting == 'teacher': orderby = db.teachers_payment_classes.auth_teacher_id | \ db.teachers_payment_classes.ClassDate | \ db.classes.Starttime query = (db.teachers_payment_classes.Status == status) if date_from: query &= (db.teachers_payment_classes.ClassDate >= date_from) if date_until: query &= (db.teachers_payment_classes.ClassDate <= date_until) rows = db(query).select( db.teachers_payment_classes.ALL, db.classes.ALL, db.invoices_items_teachers_payment_classes.ALL, db.invoices.ALL, left=left, limitby=limitby, orderby=orderby ) if not formatted: return rows else: return self.rows_to_table(rows, status, items_per_page, page) def rows_to_table(self, rows, status, items_per_page, page): """ turn rows object into an html table :param rows: gluon.dal.rows with all fields of db.teachers_payment_classes and db.classes :return: html table """ from .os_gui import OsGui T = current.T auth = current.auth os_gui = OsGui() header = THEAD(TR( TH(), TH(T("Class date")), TH(T("Time")), TH(T("Location")), TH(T("Class type")), TH(T("Teacher")), TH(T("Type")), TH(T("Attendance")), TH(T("Payment")), TH(os_gui.get_fa_icon('fa-subway')), TH(T("Invoice")), TH() # Actions )) table = TABLE(header, _class="table table-striped table-hover small_font") permissions = self._rows_to_table_button_permissions() for i, row in enumerate(rows): repr_row = list(rows[i:i + 1].render())[0] if status == 'not_verified': buttons = self._rows_to_table_get_not_verified_buttons(row, os_gui, permissions) elif status == 'verified': buttons = self._rows_to_table_get_verified_buttons(row, os_gui, permissions) else: buttons = '' tr = TR( TD(repr_row.teachers_payment_classes.Status), TD(repr_row.teachers_payment_classes.ClassDate), TD(repr_row.classes.Starttime), TD(repr_row.classes.school_locations_id), TD(repr_row.classes.school_classtypes_id), TD(repr_row.teachers_payment_classes.auth_teacher_id, BR(), repr_row.teachers_payment_classes.auth_teacher_id2), TD(repr_row.teachers_payment_classes.RateType, BR(), SPAN(repr_row.teachers_payment_classes.teachers_payment_attendance_list_id or '', _class='grey')), TD(repr_row.teachers_payment_classes.AttendanceCount), TD(repr_row.teachers_payment_classes.ClassRate, BR(), SPAN(repr_row.teachers_payment_classes.tax_rates_id, _class='grey')), TD(repr_row.teachers_payment_classes.TravelAllowance, BR(), SPAN(repr_row.teachers_payment_classes.tax_rates_id_travel_allowance or '', _class='grey')), TD(self._rows_to_table_get_invoice_link(row, os_gui)), TD(buttons) ) table.append(tr) pager = self._rows_to_table_get_navigation(rows, items_per_page, page) return DIV(table, pager) def _rows_to_table_get_invoice_link(self, row, os_gui): """ Display claim attachments in a modal """ if not row.invoices_items_teachers_payment_classes.id: return '' T = current.T invoice_url = URL('invoices', 'edit', vars={'iID': row.invoices.id}) return A( row.invoices.InvoiceID, _href=invoice_url ) def _rows_to_table_get_navigation(self, rows, items_per_page, page): from .os_gui import OsGui os_gui = OsGui() request = current.request # Navigation previous = '' url_previous = None if page: url_previous = URL(args=[page - 1], vars=request.vars) previous = A(SPAN(_class='glyphicon glyphicon-chevron-left'), _href=url_previous) nxt = '' url_next = None if len(rows) > items_per_page: url_next = URL(args=[page + 1], vars=request.vars) nxt = A(SPAN(_class='glyphicon glyphicon-chevron-right'), _href=url_next) navigation = os_gui.get_page_navigation_simple(url_previous, url_next, page + 1) if previous or nxt: pass else: navigation = '' return DIV(navigation) def _rows_to_table_button_permissions(self): """ :return: dict containing button permissions for a user """ auth = current.auth permissions = {} if auth.has_membership(group_id='Admins') or \ auth.has_permission('read', 'classes_attendance'): permissions['classes_attendance'] = True if auth.has_membership(group_id='Admins') or \ auth.has_permission('update', 'teachers_payment_classes'): permissions['teachers_payment_classes'] = True return permissions def _rows_to_table_get_not_verified_buttons(self, row, os_gui, permissions): """ Returns buttons for schedule - one button group for edit & attendance buttons - separate button for delete """ T = current.T DATE_FORMAT = current.DATE_FORMAT buttons = DIV(_class='pull-right') links = [] links.append(['header', T('Actions')]) # Check Update teachers payment attendance classes if permissions.get('teachers_payment_classes', False): links.append(A(os_gui.get_fa_icon('fa-check'), T('Verify'), _href=URL('finance', 'teachers_payment_attendance_class_verify', vars={'tpcID': row.teachers_payment_classes.id}), _class='text-green')) links.append('divider') # Check Attendance permission if permissions.get('classes_attendance', False): links.append(['header', T('Go to')]) links.append(A(os_gui.get_fa_icon('fa-chevron-right'), T('Attendance'), _href=URL('classes', 'attendance', vars={'clsID': row.classes.id, 'date': row.teachers_payment_classes.ClassDate.strftime(DATE_FORMAT)}))) tpc_menu = os_gui.get_dropdown_menu( links=links, btn_text=T('Actions'), btn_size='btn-sm', btn_icon='actions', menu_class='btn-group pull-right') return DIV(tpc_menu, _class='pull-right') def _rows_to_table_get_verified_buttons(self, row, os_gui, permissions): """ Returns buttons for schedule - one button group for edit & attendance buttons - separate button for delete """ T = current.T DATE_FORMAT = current.DATE_FORMAT buttons = DIV(_class='pull-right') links = [] links.append(['header', T('Actions')]) # Check Update teachers payment attendance classes if permissions.get('teachers_payment_classes', False): links.append(A(os_gui.get_fa_icon('fa-ban'), T("Move to 'Not verified'"), _href=URL('finance', 'teachers_payment_attendance_class_unverify', vars={'tpcID': row.teachers_payment_classes.id}), _class='')) links.append('divider') # Check Attendance permission if permissions.get('classes_attendance', False): links.append(['header', T('Go to')]) links.append(A(os_gui.get_fa_icon('fa-chevron-right'), T('Attendance'), _href=URL('classes', 'attendance', vars={'clsID': row.classes.id, 'date':row.teachers_payment_classes.ClassDate.strftime(DATE_FORMAT)}))) tpc_menu = os_gui.get_dropdown_menu( links=links, btn_text=T('Actions'), btn_size='btn-sm', btn_icon='actions', menu_class='btn-group pull-right') return DIV(tpc_menu, _class='pull-right') def get_not_verified(self, page=0, formatted=False): """ All classes not :return: gluon.dal.rows or html table """ return self.get_rows( status='not_verified', formatted=formatted, page=page ) def get_verified(self, page=0, formatted=False): """ All classes verified :return: gluon.dal.rows or html table """ return self.get_rows( status='verified', formatted=formatted, page=page ) def get_processed(self, page=0, formatted=False): """ All processed classes :param formatted: Bool :return: gluon.dal.rows or html table """ return self.get_rows( status='processed', formatted=formatted, page=page ) def verify_all(self): """ Change status of all not_verified classes to verified :return: Int - number of classes where status has been changed to verified """ db = current.db auth = current.auth query = (db.teachers_payment_classes.Status == 'not_verified') updated = db(query).update(Status = 'verified', VerifiedBy = auth.user.id, VerifiedOn = datetime.datetime.now()) return updated def process_verified(self, date_from=None, date_until=None): """ Create credit invoices for verified classes :return: """ from .os_invoice import Invoice from .os_teachers_payment_class import TeachersPaymentClass T = current.T db = current.db DATE_FORMAT = current.DATE_FORMAT error = False message = '' # Sort verified classes by teacher rows = self.get_rows( status='verified', sorting='teacher', formatted=False, date_from=date_from, date_until=date_until, all=True ) previous_teacher = None current_teacher = None processed = 0 invoices_created = 0 # For each teacher, create credit invoice and add all verified classes for i, row in enumerate(rows): teID = row.teachers_payment_classes.auth_teacher_id if i == 0 or not previous_teacher == teID: current_teacher = teID description = T("Classes") if date_from and date_until: description = T("Classes") + ' ' + \ date_from.strftime(DATE_FORMAT) + ' - ' + \ date_until.strftime(DATE_FORMAT) igpt = db.invoices_groups_product_types(ProductType='teacher_payments') iID = db.invoices.insert( invoices_groups_id=igpt.invoices_groups_id, TeacherPayment=True, Description=description, Status='sent' ) invoice = Invoice(iID) invoice.link_to_customer(teID) invoices_created += 1 tpcID = row.teachers_payment_classes.id invoice.item_add_teacher_class_attendance_credit_payment(tpcID) # Add travel allowance if row.teachers_payment_classes.TravelAllowance: invoice.item_add_teacher_class_credit_travel_allowance( row.teachers_payment_classes.classes_id, row.teachers_payment_classes.ClassDate, row.teachers_payment_classes.TravelAllowance, row.teachers_payment_classes.tax_rates_id_travel_allowance ) # Set status processed tpc = TeachersPaymentClass(tpcID) tpc.set_status_processed() previous_teacher = current_teacher processed += 1 # Calculate total return dict( error=error, message=processed )