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
)
