def _get_ar(cls, identifier: str = None, filing_event_info: dict = None):
"""Return annual report filing."""
# get directors and registered office as of this filing
director_events = cls._get_events(
identifier=identifier,
filing_type_code=filing_event_info['filing_type_code'])
office_events = cls._get_events(
identifier=identifier,
filing_type_code=filing_event_info['filing_type_code'])
director_event_id = None
office_event_id = None
tmp_timestamp = datetime.datetime.fromtimestamp(0)
for event in director_events:
if filing_event_info['event_timestmp'] >= event[
'date'] > tmp_timestamp:
director_event_id = event['id']
tmp_timestamp = event['date']
tmp_timestamp = datetime.datetime.fromtimestamp(0)
for event in office_events:
if filing_event_info['event_timestmp'] >= event[
'date'] > tmp_timestamp:
office_event_id = event['id']
tmp_timestamp = event['date']
if director_event_id:
try:
directors = Director.get_by_event(identifier=identifier,
event_id=director_event_id)
except: # noqa B901; pylint: disable=bare-except;
# should only get here if event was before the bob date
directors = Director.get_current(identifier=identifier)
else:
directors = Director.get_current(identifier=identifier)
directors = [x.as_dict() for x in directors]
if office_event_id:
try:
reg_office = Office.get_by_event(event_id=office_event_id)
except: # noqa B901; pylint: disable=bare-except;
# should only get here if event was before the bob date
reg_office = Office.get_current(identifier=identifier)
else:
reg_office = Office.get_current(identifier=identifier)
reg_office = reg_office.as_dict()
# convert dates and date-times to correct json format
agm_date = convert_to_json_date(filing_event_info.get(
'agm_date', None))
ar_date = convert_to_json_date(filing_event_info['period_end_dt'])
filing_obj = Filing()
filing_obj.body = {
'annualGeneralMeetingDate': agm_date,
'annualReportDate': ar_date,
'directors': directors,
'eventId': filing_event_info['event_id'],
**reg_office
}
filing_obj.filing_type = 'annualReport'
return filing_obj
def _get_cod(cls,
cursor,
identifier: str = None,
filing_event_info: dict = None):
"""Get change of directors filing."""
director_objs = Director.get_by_event(cursor, identifier,
filing_event_info['event_id'])
if len(director_objs) < 3:
current_app.logger.error(
'Less than 3 directors for {}'.format(identifier))
# check to see if this filing was made with an AR -> if it was then set the AR date as the effective date
effective_date = filing_event_info['event_timestmp']
annual_reports = cls._get_events(cursor=cursor,
identifier=identifier,
filing_type_code='OTANN')
for filing in annual_reports:
if convert_to_json_date(
filing['date']) == convert_to_json_date(effective_date):
effective_date = filing['annualReportDate']
break
filing_obj = Filing()
filing_obj.body = {
'directors': [x.as_dict() for x in director_objs],
'eventId': filing_event_info['event_id']
}
filing_obj.filing_type = 'changeOfDirectors'
filing_obj.paper_only = False
filing_obj.effective_date = effective_date
return filing_obj
def get(identifier):
"""Return the current directors for a business."""
if not identifier:
return jsonify({'message': 'Identifier required'}), 404
try:
directors = Director.get_current(identifier)
if not directors:
return jsonify(
{'message': f'directors for {identifier} not found'}), 404
if len(directors) < 3:
current_app.logger.error(
'Less than 3 directors for {}'.format(identifier))
return jsonify({'directors': [x.as_dict() for x in directors]})
except GenericException as err: # pylint: disable=duplicate-code
return jsonify({'message': err.error}), err.status_code
except Exception as err: # pylint: disable=broad-except; want to catch all errors
# general catch-all exception
current_app.logger.error(err.with_traceback(None))
return jsonify({
'message':
'Error when trying to retrieve directors from COLIN'
}), 500
def _get_cod(cls, identifier: str = None, filing_event_info: dict = None):
"""Get change of directors filing."""
director_objs = Director.get_by_event(identifier, filing_event_info['event_id'])
if len(director_objs) < 3:
current_app.logger.error('Less than 3 directors for {}'.format(identifier))
filing_obj = Filing()
filing_obj.body = {
'directors': [x.as_dict() for x in director_objs],
'eventId': filing_event_info['event_id']
}
filing_obj.filing_type = 'changeOfDirectors'
return filing_obj
def _get_cod(cls,
identifier: str = None,
event_id: str = None,
year: int = None): # pylint: disable=unused-argument; will use year later
"""Get change of directors filing."""
filing_obj = Filing()
if event_id:
filing_event_info = cls._get_filing_event_info(
identifier=identifier,
event_id=event_id,
filing_type_cd1='OTCDR',
filing_type_cd2='OTADR')
else:
filing_event_info = cls._get_filing_event_info(
identifier=identifier,
filing_type_cd1='OTCDR',
filing_type_cd2='OTADR')
director_objs = Director.get_by_event(identifier,
filing_event_info['event_id'])
if len(director_objs) < 3:
current_app.logger.error(
'Less than 3 directors for {}'.format(identifier))
filing_obj.header = {
'date': convert_to_json_date(filing_event_info['event_timestmp']),
'name': 'changeOfDirectors',
'certifiedBy': filing_event_info['certifiedBy'],
'email': filing_event_info['email']
}
filing_obj.body = {
'directors': [x.as_dict() for x in director_objs],
'eventId': filing_event_info['event_id']
}
filing_obj.filing_type = 'changeOfDirectors'
return filing_obj
def add_filing(cls, filing): # pylint: disable=too-many-locals,too-many-statements,too-many-branches;
"""Add new filing to COLIN tables.
:param filing: Filing dict.
:returns (int): the filing ID of the new filing.
"""
try:
corp_num = filing.get_corp_num()
# get db connection and start a session, in case we need to roll back
con = DB.connection
con.begin()
cursor = con.cursor()
# create new event record, return event ID
event_id = cls._get_event_id(cursor, corp_num, 'FILE')
# create new filing user
cls._create_filing_user(cursor, event_id, filing)
if filing.filing_type == 'annualReport':
ar_date = filing.body['annualReportDate']
agm_date = filing.body['annualGeneralMeetingDate']
filing_type_cd = 'OTANN'
# create new filing
cls._create_filing(cursor, event_id, corp_num, ar_date,
agm_date, filing_type_cd)
# update corporation record
Business.update_corporation(cursor, corp_num, agm_date)
# update corp_state TO ACT (active) if it is in good standing. From CRUD:
# - the current corp_state != 'ACT' and,
# - they just filed the last outstanding ARs
if filing.business.business['corpState'] != 'ACT':
agm_year = int(ar_date[:4])
last_year = datetime.datetime.now().year - 1
if agm_year >= last_year:
Business.update_corp_state(cursor,
event_id,
corp_num,
state='ACT')
elif filing.filing_type == 'changeOfAddress':
# set date to last ar date + 1
last_ar_date = filing.business.business['lastArDate']
day = int(last_ar_date[-2:]) + 1
try:
date = str(
datetime.datetime.strptime(
last_ar_date[:-2] + ('0' + str(day))[1:],
'%Y-%m-%d'))[:10]
except ValueError:
try:
day = '-01'
month = int(last_ar_date[5:7]) + 1
date = str(
datetime.datetime.strptime(
last_ar_date[:5] + ('0' + str(month))[1:] +
day, '%Y-%m-%d'))[:10]
except ValueError:
mm_dd = '-01-01'
yyyy = int(last_ar_date[:4]) + 1
date = str(
datetime.datetime.strptime(
str(yyyy) + mm_dd, '%Y-%m-%d'))[:10]
# create new filing
filing_type_cd = 'OTADD'
cls._create_filing(cursor, event_id, corp_num, date, None,
filing_type_cd)
# create new addresses for delivery + mailing, return address ids
delivery_addr_id = Address.create_new_address(
cursor, filing.body['deliveryAddress'])
mailing_addr_id = Address.create_new_address(
cursor, filing.body['mailingAddress'])
# update office table to include new addresses
Office.update_office(cursor, event_id, corp_num,
delivery_addr_id, mailing_addr_id, 'RG')
# create new ledger text for address change
cls._add_ledger_text(
cursor, event_id,
f'Change to the Registered Office, effective on {date}')
# update corporation record
Business.update_corporation(cursor, corp_num)
elif filing.filing_type == 'changeOfDirectors':
# create new filing
date = filing.business.business['lastArDate']
filing_type_cd = 'OTCDR'
cls._create_filing(cursor, event_id, corp_num, date, None,
filing_type_cd)
# create, cease, change directors
changed_dirs = []
for director in filing.body['directors']:
if 'appointed' in director['actions']:
Director.create_new_director(
cursor=cursor,
event_id=event_id,
director=director,
business=filing.business.as_dict())
if 'ceased' in director['actions'] and not any(
elem in ['nameChanged', 'addressChanged']
for elem in director['actions']):
Director.end_by_name(cursor=cursor,
director=director,
event_id=event_id,
corp_num=corp_num)
elif 'nameChanged' in director[
'actions'] or 'addressChanged' in director[
'actions']:
if 'appointed' in director['actions']:
current_app.logger.error(
f'Director appointed with name/address change: {director}'
)
changed_dirs.append(director)
# end tmp copy of director with no cessation date (will be recreated with changes and cessation
# date - otherwise end up with two copies of ended director)
tmp = director.copy()
tmp['cessationDate'] = ''
Director.end_by_name(cursor=cursor,
director=tmp,
event_id=event_id,
corp_num=corp_num)
# add back changed directors as new row - if ceased director with changes this will add them with
# cessation date + end event id filled
for director in changed_dirs:
Director.create_new_director(
cursor=cursor,
event_id=event_id,
director=director,
business=filing.business.as_dict())
# create new ledger text for address change
cls._add_ledger_text(cursor=cursor,
event_id=event_id,
text=f'Director change.')
# update corporation record
Business.update_corporation(cursor=cursor, corp_num=corp_num)
else:
raise InvalidFilingTypeException(
filing_type=filing.filing_type)
# success! commit the db changes
con.commit()
return event_id
except Exception as err:
# something went wrong, roll it all back
current_app.logger.error(err.with_traceback(None))
if con:
con.rollback()
raise err
def _get_ar(
cls,
identifier: str = None,
event_id: str = None, # pylint: disable=too-many-locals,too-many-branches;
year: int = None):
"""Return annual report filing."""
if event_id:
filing_event_info = cls._get_filing_event_info(
identifier=identifier,
event_id=event_id,
filing_type_cd1='OTANN',
year=year)
else:
filing_event_info = cls._get_filing_event_info(
identifier=identifier, filing_type_cd1='OTANN', year=year)
if not filing_event_info:
raise FilingNotFoundException(identifier=identifier,
filing_type='annualReport',
event_id=event_id)
# get directors and registered office as of this filing
director_events = Director.get_events(identifier=identifier)
office_events = Office.get_events(identifier=identifier)
director_event_id = None
office_event_id = None
tmp_timestamp = datetime.datetime.fromtimestamp(0)
for event in director_events:
if filing_event_info['event_timestmp'] >= event[
'date'] > tmp_timestamp:
director_event_id = event['id']
tmp_timestamp = event['date']
tmp_timestamp = datetime.datetime.fromtimestamp(0)
for event in office_events:
if filing_event_info['event_timestmp'] >= event[
'date'] > tmp_timestamp:
office_event_id = event['id']
tmp_timestamp = event['date']
if director_event_id:
try:
directors = Director.get_by_event(identifier=identifier,
event_id=director_event_id)
except: # noqa B901; pylint: disable=bare-except;
# should only get here if event was before the bob date
directors = Director.get_current(identifier=identifier)
else:
directors = Director.get_current(identifier=identifier)
directors = [x.as_dict() for x in directors]
if office_event_id:
try:
reg_office = Office.get_by_event(event_id=office_event_id)
except: # noqa B901; pylint: disable=bare-except;
# should only get here if event was before the bob date
reg_office = Office.get_current(identifier=identifier)
else:
reg_office = Office.get_current(identifier=identifier)
reg_office = reg_office.as_dict()
# convert dates and date-times to correct json format
filing_event_info['event_timestmp'] = convert_to_json_date(
filing_event_info['event_timestmp'])
agm_date = convert_to_json_date(filing_event_info.get(
'agm_date', None))
ar_date = convert_to_json_date(filing_event_info['period_end_dt'])
filing_obj = Filing()
filing_obj.header = {
'date': filing_event_info['event_timestmp'],
'name': 'annualReport',
'certifiedBy': filing_event_info['certifiedBy'],
'email': filing_event_info['email']
}
filing_obj.body = {
'annualGeneralMeetingDate': agm_date,
'annualReportDate': ar_date,
'directors': directors,
'eventId': filing_event_info['event_id'],
**reg_office
}
filing_obj.filing_type = 'annualReport'
filing_obj.event_id = filing_event_info['event_id'] # pylint: disable=attribute-defined-outside-init
return filing_obj
def add_filing(cls, con, filing): # pylint: disable=too-many-locals,too-many-statements,too-many-branches;
"""Add new filing to COLIN tables.
:param con: DB connection
:param filing: Filing dict.
:returns (int): the filing ID of the new filing.
"""
try:
corp_num = filing.get_corp_num()
legal_type = corp_num[:2]
user_id = Filing.USERS[legal_type] if legal_type in (
'CP', 'BC') else None
cursor = con.cursor()
# create new event record, return event ID
event_id = cls._get_event_id(cursor, corp_num, 'FILE')
# create new filing user
cls._create_filing_user(cursor, event_id, filing, user_id)
if filing.filing_type == 'annualReport':
ar_date = filing.body['annualReportDate']
agm_date = filing.body['annualGeneralMeetingDate']
filing_type_cd = 'OTANN'
# create new filing
cls._create_filing(cursor, event_id, corp_num, ar_date,
agm_date, filing_type_cd)
# update corporation record
Business.update_corporation(cursor, corp_num, agm_date, True)
# update corp_state TO ACT (active) if it is in good standing. From CRUD:
# - the current corp_state != 'ACT' and,
# - they just filed the last outstanding ARs
agm_year = int(ar_date[:4])
if filing.business.business['corpState'] != 'ACT':
last_year = datetime.datetime.now().year - 1
if agm_year >= last_year:
Business.update_corp_state(cursor,
event_id,
corp_num,
state='ACT')
# create new ledger text for annual report
text = agm_date if agm_date else f'NO AGM HELD IN {agm_year}'
cls._add_ledger_text(cursor=cursor,
event_id=event_id,
text=f'ANNUAL REPORT - {text}',
user_id=user_id)
elif filing.filing_type == 'changeOfAddress':
# set date to last ar date + 1 -- Bob wants this to be set to null
# last_ar_date = filing.business.business['lastArDate']
# day = int(last_ar_date[-2:]) + 1
# try:
# date = str(datetime.datetime.strptime(last_ar_date[:-2] + ('0' + str(day))[1:], '%Y-%m-%d'))[:10]
# except ValueError:
# try:
# day = '-01'
# month = int(last_ar_date[5:7]) + 1
# date = str(datetime.datetime.strptime(last_ar_date[:5] + ('0' + str(month))[1:] + day,
# '%Y-%m-%d')
# )[:10]
# except ValueError:
# mm_dd = '-01-01'
# yyyy = int(last_ar_date[:4]) + 1
# date = str(datetime.datetime.strptime(str(yyyy) + mm_dd, '%Y-%m-%d'))[:10]
date = None
# create new filing
filing_type_cd = 'OTADD'
cls._create_filing(cursor, event_id, corp_num, date, None,
filing_type_cd)
# create new addresses for delivery + mailing, return address ids
cls._add_office_from_filing(cursor, event_id, corp_num,
user_id, filing)
# update corporation record
Business.update_corporation(cursor, corp_num)
elif filing.filing_type == 'changeOfDirectors':
# create new filing
# bob wants this to be null
# date = filing.business.business['lastArDate']
date = None
filing_type_cd = 'OTCDR'
cls._create_filing(cursor, event_id, corp_num, date, None,
filing_type_cd)
# create, cease, change directors
changed_dirs = []
for director in filing.body['directors']:
if 'appointed' in director['actions']:
Director.create_new_director(
cursor=cursor,
event_id=event_id,
director=director,
business=filing.business.as_dict())
if 'ceased' in director['actions'] and not any(
elem in ['nameChanged', 'addressChanged']
for elem in director['actions']):
Director.end_by_name(cursor=cursor,
director=director,
event_id=event_id,
corp_num=corp_num)
elif 'nameChanged' in director[
'actions'] or 'addressChanged' in director[
'actions']:
if 'appointed' in director['actions']:
current_app.logger.error(
f'Director appointed with name/address change: {director}'
)
changed_dirs.append(director)
# end tmp copy of director with no cessation date (will be recreated with changes and cessation
# date - otherwise end up with two copies of ended director)
tmp = director.copy()
tmp['cessationDate'] = ''
Director.end_by_name(cursor=cursor,
director=tmp,
event_id=event_id,
corp_num=corp_num)
# add back changed directors as new row - if ceased director with changes this will add them with
# cessation date + end event id filled
for director in changed_dirs:
Director.create_new_director(
cursor=cursor,
event_id=event_id,
director=director,
business=filing.business.as_dict())
# create new ledger text for address change
cls._add_ledger_text(cursor=cursor,
event_id=event_id,
text=f'Director change.',
user_id=user_id)
# update corporation record
Business.update_corporation(cursor=cursor, corp_num=corp_num)
elif filing.filing_type == 'incorporationApplication':
# Add business, update business info
# Add offices
date = None
filing_type_cd = 'OTINC'
cls._create_filing(cursor, event_id, corp_num, date, None,
filing_type_cd)
# Do incorporation here
Business.create_corp_name(cursor, corp_num, 'test name',
event_id)
Business.create_corp_state(cursor, corp_num, event_id)
cls._add_office_from_filing(cursor, event_id, corp_num,
user_id, filing)
else:
raise InvalidFilingTypeException(
filing_type=filing.filing_type)
return event_id
except Exception as err:
# something went wrong, roll it all back
current_app.logger.error(err.with_traceback(None))
raise err
def _get_ar(cls,
cursor,
identifier: str = None,
filing_event_info: dict = None):
"""Return annual report filing."""
# get directors and registered office as of this filing
director_events = cls._get_events(identifier=identifier,
filing_type_code='OTCDR',
cursor=cursor)
office_events = cls._get_events(identifier=identifier,
filing_type_code='OTADD',
cursor=cursor)
director_event_id = None
office_event_id = None
tmp_timestamp = datetime.datetime.fromtimestamp(0)
for event in director_events:
if filing_event_info['event_timestmp'] >= event[
'date'] > tmp_timestamp:
director_event_id = event['id']
tmp_timestamp = event['date']
tmp_timestamp = datetime.datetime.fromtimestamp(0)
for event in office_events:
if filing_event_info['event_timestmp'] >= event[
'date'] > tmp_timestamp:
office_event_id = event['id']
tmp_timestamp = event['date']
recreated_dirs_and_office = True
if director_event_id:
try:
directors = Director.get_by_event(identifier=identifier,
event_id=director_event_id,
cursor=cursor)
except: # noqa B901; pylint: disable=bare-except;
# should only get here if agm was before the bob date
recreated_dirs_and_office = False
directors = Director.get_current(identifier=identifier,
cursor=cursor)
else:
directors = Director.get_current(identifier=identifier,
cursor=cursor)
directors = [x.as_dict() for x in directors]
if office_event_id:
try:
office_obj_list = (Office.get_by_event(
event_id=office_event_id, cursor=cursor)).as_dict()
offices = Office.convert_obj_list(office_obj_list)
except: # noqa B901; pylint: disable=bare-except;
# should only get here if agm was before the bob date
recreated_dirs_and_office = False
office_obj_list = Office.get_current(identifier=identifier,
cursor=cursor)
offices = Office.convert_obj_list(office_obj_list)
else:
office_obj_list = Office.get_current(identifier=identifier,
cursor=cursor)
offices = Office.convert_obj_list(office_obj_list)
filing_obj = Filing()
filing_obj.body = {
'annualGeneralMeetingDate':
convert_to_json_date(filing_event_info.get('agm_date', None)),
'annualReportDate':
convert_to_json_date(filing_event_info['period_end_dt']),
'directors':
directors,
'eventId':
filing_event_info['event_id'],
'offices':
offices
}
filing_obj.filing_type = 'annualReport'
filing_obj.paper_only = not recreated_dirs_and_office
filing_obj.effective_date = filing_event_info['period_end_dt']
return filing_obj
def _get_ar(cls, identifier: str = None, filing_event_info: dict = None):
"""Return annual report filing."""
# get directors and registered office as of this filing
director_events = cls._get_events(identifier=identifier,
filing_type_code='OTCDR')
office_events = cls._get_events(identifier=identifier,
filing_type_code='OTADD')
director_event_id = None
office_event_id = None
tmp_timestamp = datetime.datetime.fromtimestamp(0)
for event in director_events:
if filing_event_info['event_timestmp'] >= event[
'date'] > tmp_timestamp:
director_event_id = event['id']
tmp_timestamp = event['date']
tmp_timestamp = datetime.datetime.fromtimestamp(0)
for event in office_events:
if filing_event_info['event_timestmp'] >= event[
'date'] > tmp_timestamp:
office_event_id = event['id']
tmp_timestamp = event['date']
recreated_dirs_and_office = True
if director_event_id:
try:
directors = Director.get_by_event(identifier=identifier,
event_id=director_event_id)
except: # noqa B901; pylint: disable=bare-except;
# should only get here if agm was before the bob date
recreated_dirs_and_office = False
directors = Director.get_current(identifier=identifier)
else:
directors = Director.get_current(identifier=identifier)
directors = [x.as_dict() for x in directors]
if office_event_id:
try:
reg_office = Office.get_by_event(event_id=office_event_id)
except: # noqa B901; pylint: disable=bare-except;
# should only get here if agm was before the bob date
recreated_dirs_and_office = False
reg_office = Office.get_current(identifier=identifier)
else:
reg_office = Office.get_current(identifier=identifier)
reg_office = reg_office.as_dict()
# convert dates and date-times to correct json format
agm_date = convert_to_json_date(filing_event_info.get(
'agm_date', None))
ar_date = convert_to_json_date(filing_event_info['period_end_dt'])
# paper filings from colin don't enter in the agm_date and don't have no agm filings in the filings table
if filing_event_info['user_id'] != 'COOPER' and not agm_date:
agm_date = ar_date
filing_obj = Filing()
filing_obj.body = {
'annualGeneralMeetingDate': agm_date,
'annualReportDate': ar_date,
'directors': directors,
'eventId': filing_event_info['event_id'],
**reg_office
}
filing_obj.filing_type = 'annualReport'
filing_obj.paper_only = not recreated_dirs_and_office
filing_obj.effective_date = filing_event_info['period_end_dt']
return filing_obj
