def table_resource(): _table_title = 'Resource' _field_arrangement = ['res_type', 'res_type_class', 'agency_ref_num', 'res_emp_num', 'res_fullname', 'res_job_title', 'grade_level', 'date_of_joining', 'mobile_num', 'email', 'manager', 'cost_center', 'division', 'section', 'sub_section', 'job_class', 'work_base', 'nationality', 'remarks', 'status' ] _field_dictionary = key_label(_field_arrangement) _template = '_table.html' _add_link_func_name = 'resource_mgt.add_resource' data = resource_table() # data = VendorSchema(vendor, many=True).data return render_template(_template, data=data, columns=_field_dictionary, keys=_field_arrangement, add_link_func=_add_link_func_name, table_title = _table_title )
def table_pl(): _table_title = 'Purchase Order Line' _field_arrangement = [ 'line_num', 'line_duration', 'line_value', 'line_r_value', 'line_rate', 'line_status', 'line_actuals', 'cpx_percent', 'opx_percent', 'rev_percent', 'division', 'section', 'sub_section', 'director_name', ] _field_dictionary = key_label(_field_arrangement) _template = '_table.html' _add_link_func_name = 'resource_mgt.add_po' data = resource_table() # data = VendorSchema(vendor, many=True).data return render_template(_template, data=data, columns=_field_dictionary, keys=_field_arrangement, add_link_func=_add_link_func_name, table_title = _table_title )
def table_po(): _table_title = 'Purchase Order' _field_arrangement = [ 'po_number', 'po_number_renew', 'po_date', 'po_value', 'contractor', 'budget_type', 'cpx_commitment_value', 'cpx_expenditure_value', 'opx_value', 'revenue_value', 'task_num', 'status', 'status_renew', ] _field_dictionary = key_label(_field_arrangement) _template = '_table.html' _add_link_func_name = 'resource_mgt.add_po' data = resource_table() # data = VendorSchema(vendor, many=True).data return render_template(_template, data=data, columns=_field_dictionary, keys=_field_arrangement, add_link_func=_add_link_func_name, table_title = _table_title )