def test_generate_xls_data_with_an_admission(self):
a_form = CommonFilterForm({"faculty": self.entity_version.id})
self.assertTrue(a_form.is_valid())
found_admissions = a_form.get_admissions()
create_xls(self.user, found_admissions, None)
xls_data = [[
self.admission.person_information.person.first_name,
self.admission.person_information.person.last_name,
self.admission.email, self.admission.formation,
self.entity_version.entity,
_(SUBMITTED)
]]
expected_argument = _generate_xls_build_parameter(xls_data, self.user)
self.assertEqual(expected_argument['list_description'],
_('Admissions list'))
self.assertEqual(expected_argument['filename'], _('Admissions_list'))
self.assertEqual(expected_argument['username'], self.user.username)
self.assertEqual(expected_argument['data'][0]['content'], xls_data)
self.assertEqual(expected_argument['data'][0]['header_titles'],
get_titles_admission())
self.assertEqual(expected_argument['data'][0]['worksheet_title'],
_('Admissions list'))
def create_xls(user, admission_list, form):
filters = form_filters(form)
working_sheets_data = prepare_xls_content(admission_list)
parameters = {
xls_build.DESCRIPTION: XLS_DESCRIPTION,
xls_build.USER: get_name_or_username(user),
xls_build.FILENAME: XLS_FILENAME,
xls_build.HEADER_TITLES: get_titles_admission(),
xls_build.WS_TITLE: WORKSHEET_TITLE
}
return xls_build.generate_xls(
xls_build.prepare_xls_parameters_list(working_sheets_data, parameters),
filters)
def _generate_xls_build_parameter(xls_data, user):
return {
xls_build.LIST_DESCRIPTION_KEY:
XLS_DESCRIPTION,
xls_build.FILENAME_KEY:
XLS_FILENAME,
xls_build.USER_KEY:
user.username,
xls_build.WORKSHEETS_DATA: [{
xls_build.CONTENT_KEY:
xls_data,
xls_build.HEADER_TITLES_KEY:
get_titles_admission(),
xls_build.WORKSHEET_TITLE_KEY:
WORKSHEET_TITLE,
xls_build.STYLED_CELLS:
None,
xls_build.FONT_ROWS:
None,
}]
}
def _get_titles():
return get_titles_admission() + get_titles_registration()