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()