def __json_filings(cls, filings): filings_json_list = [] for filing in filings: d = { 'completionDate': format_date(filing._completion_date), # pylint: disable=protected-access 'filingDate': format_date(filing._filing_date), # pylint: disable=protected-access 'filingId': filing.id, 'filingType': format_non_date(filing._filing_type), # pylint: disable=protected-access 'effectiveDate': format_date(filing.effective_date), 'paymentToken': format_non_date(filing._payment_token), # pylint: disable=protected-access 'paymentCompletionDate': format_date(filing._payment_completion_date), # pylint: disable=protected-access 'colinEventIds': [x.colin_event_id for x in filing.colin_event_ids], 'status': format_non_date(filing._status), # pylint: disable=protected-access 'paperOnly': format_boolean(filing.paper_only), # Don't want to use format_json here because we're # running jsonify later and it will get all escaped 'filingJson': format_non_date(filing._filing_json) # pylint: disable=protected-access } filings_json_list.append(d) return filings_json_list
def __json_directors(self, directors): directors_json_list = [] for director in directors: d = { 'firstName': format_non_date(director.party.first_name), 'middleInitial': format_non_date(director.party.middle_initial), 'lastName': format_non_date(director.party.last_name), 'title': format_non_date(director.party.title), 'appointmentDate': format_date(director.appointment_date), 'cessationDate': format_date(director.cessation_date), 'deliveryAddress': self.__format_address(director.party.delivery_address), 'mailingAddress': self.__format_address(director.party.mailing_address) } directors_json_list.append(d) return directors_json_list
def __write_filing_to_excel(self, business_identifier, filing): self.__filing_sheet.write(self.__filing_sheet_row_index, 0, format_non_date(business_identifier)) self.__filing_sheet.write(self.__filing_sheet_row_index, 1, format_json(filing._filing_json)) # pylint: disable=protected-access self.__filing_sheet.write(self.__filing_sheet_row_index, 2, format_date(filing._completion_date)) # pylint: disable=protected-access self.__filing_sheet.write(self.__filing_sheet_row_index, 3, format_date(filing._filing_date)) # pylint: disable=protected-access self.__filing_sheet.write(self.__filing_sheet_row_index, 4, format_non_date(filing._filing_type)) # pylint: disable=protected-access self.__filing_sheet.write(self.__filing_sheet_row_index, 5, format_date(filing.effective_date)) self.__filing_sheet.write(self.__filing_sheet_row_index, 6, format_non_date(filing._payment_token)) # pylint: disable=protected-access self.__filing_sheet.write(self.__filing_sheet_row_index, 7, format_date(filing._payment_completion_date)) # pylint: disable=protected-access self.__filing_sheet.write( self.__filing_sheet_row_index, 8, format_json([x.colin_event_id for x in filing.colin_event_ids])) self.__filing_sheet.write(self.__filing_sheet_row_index, 9, format_non_date(filing.status)) self.__filing_sheet.write(self.__filing_sheet_row_index, 10, format_boolean(filing.paper_only)) self.__filing_sheet_row_index += 1
def __write_director_to_excel(self, business_identifier, director): self.__director_sheet.write(self.__director_sheet_row_index, 0, format_non_date(business_identifier)) self.__director_sheet.write(self.__director_sheet_row_index, 1, format_non_date(director.first_name)) self.__director_sheet.write(self.__director_sheet_row_index, 2, format_non_date(director.middle_initial)) self.__director_sheet.write(self.__director_sheet_row_index, 3, format_non_date(director.last_name)) self.__director_sheet.write(self.__director_sheet_row_index, 4, format_non_date(director.title)) self.__director_sheet.write(self.__director_sheet_row_index, 5, format_date(director.appointment_date)) self.__director_sheet.write(self.__director_sheet_row_index, 6, format_date(director.cessation_date)) delivery_address = director.delivery_address if delivery_address: self.__write_director_address_to_excel( business_identifier, director, delivery_address, self.__director_sheet_row_index) mailing_address = director.mailing_address if mailing_address: self.__write_director_address_to_excel( business_identifier, director, mailing_address, self.__director_sheet_row_index) self.__director_sheet_row_index += 1
def __json_filings(self, filings): filings_json_list = [] for filing in filings: d = { 'completionDate': format_date(filing._completion_date), 'filingDate': format_date(filing._filing_date), 'filingType': format_non_date(filing._filing_type), 'effectiveDate': format_date(filing.effective_date), 'paymentToken': format_non_date(filing._payment_token), 'paymentCompletionDate': format_date(filing._payment_completion_date), 'colinEventId': format_non_date(filing.colin_event_id), 'status': format_non_date(filing._status), 'paperOnly': format_boolean(filing.paper_only), # Don't want to use format_json here because we're # running jsonify later and it will get all escaped 'filingJson': format_non_date(filing._filing_json) } filings_json_list.append(d) return filings_json_list
def __json_business(self, business): offices = business.offices.all() registered_office = self.__create_office_addresses(offices, OfficeType.REGISTERED) records_office = self.__create_office_addresses(offices, OfficeType.RECORDS) d = { 'identifier': format_non_date(business.identifier), 'legalName': format_non_date(business.legal_name), 'legalType': format_non_date(business.legal_type), 'foundingDate': format_date(business.founding_date), 'dissolutionDate': format_date(business.dissolution_date), 'lastAnnualReport': format_date(business.last_ar_date), 'lastAnnualGeneralMeetingDate': format_date(business.last_agm_date), 'fiscalYearEndDate': format_date(business.fiscal_year_end_date), 'taxId': format_non_date(business.tax_id), 'lastLedgerId': format_non_date(business.last_ledger_id), 'lastRemoteLedgerId': format_non_date(business.last_remote_ledger_id), 'lastLedgerTimestamp': format_date(business.last_ledger_timestamp), 'submitterUserId': format_non_date(business.submitter_userid), 'lastModified': format_date(business.last_modified), 'directors': self.__json_directors(business.directors), 'registeredOffice': registered_office, OfficeType.REGISTERED: format_non_date(registered_office), OfficeType.RECORDS: format_non_date(records_office), 'filings': self.__json_filings(business.filings) } return d
def __write_business_to_excel(self, business): self.__business_sheet.write(self.__business_sheet_row_index, 0, format_non_date(business.identifier)) self.__business_sheet.write(self.__business_sheet_row_index, 1, format_non_date(business.legal_name)) self.__business_sheet.write(self.__business_sheet_row_index, 2, format_non_date(business.legal_type)) self.__business_sheet.write(self.__business_sheet_row_index, 3, format_date(business.founding_date)) self.__business_sheet.write(self.__business_sheet_row_index, 4, format_date(business.dissolution_date)) self.__business_sheet.write(self.__business_sheet_row_index, 5, format_date(business.last_ar_date)) self.__business_sheet.write(self.__business_sheet_row_index, 6, format_date(business.last_agm_date)) self.__business_sheet.write(self.__business_sheet_row_index, 7, format_date(business.fiscal_year_end_date)) self.__business_sheet.write(self.__business_sheet_row_index, 8, format_non_date(business.tax_id)) self.__business_sheet.write(self.__business_sheet_row_index, 9, format_non_date(business.last_ledger_id)) self.__business_sheet.write( self.__business_sheet_row_index, 10, format_non_date(business.last_remote_ledger_id)) self.__business_sheet.write( self.__business_sheet_row_index, 11, format_date(business.last_ledger_timestamp)) self.__business_sheet.write(self.__business_sheet_row_index, 12, format_date(business.last_modified)) self.__business_sheet_row_index += 1 directors = business.directors.all() for director in directors: self.__write_director_to_excel(business.identifier, director) offices = business.offices.all() for office in offices: office_addresses = office.addresses.all() for office_address in office_addresses: self.__write_business_address_to_excel(business.identifier, office.office_type, office_address) filings = business.filings.all() for filing in filings: self.__write_filing_to_excel(business.identifier, filing)