def generate_pr_code(self):
"""
Function generates a new password reset code and expiry date.
"""
self.pr_access_code = get_random_string(length=127)
self.pr_expiry_date = get_expiry_date()
self.save()
return self.pr_access_code
def run_import_from_dict(self, row_dict, index=1):
try:
# For debugging purposes.
# print(row_dict)
# Extract the data.
pk = row_dict[0] # CLIENTNO
last_name = row_dict[1] # LNAME
given_name = row_dict[2] # GNAMES
business = row_dict[3] # BUSINESS
is_active = row_dict[4] # ACTIVE?
birthdate = row_dict[5] # BIRTHDATE
address = row_dict[6] # ADDRESS
join_date = row_dict[7] # DATE
phone = row_dict[8] # PHONE
cell = row_dict[9] # CELL
email = row_dict[10] # E-MAIL
city = row_dict[11] # CITY
province = row_dict[12] # PROV
postal_code = row_dict[13] # POSTCODE
ldn_area = row_dict[14] # LONDAREA
hourly_salary_desired = row_dict[15] # HRLYSALDESIR
limit_special = row_dict[16] # LIMITSPECIAL
dues_date = row_dict[17] # DUES PD
commercial_insurance_expiry_date = row_dict[18] # INS DUE
police_check = row_dict[19] # POLCHK
drivers_license_class = row_dict[20] # DRLICCLASS
comments_text = row_dict[21] # COMMENTS
has_car = row_dict[22] # Car?
has_van = row_dict[23] # Van?
has_truck = row_dict[24] # Truck?
is_full_time = row_dict[25] # Full Time
is_part_time = row_dict[26] # Part Time
is_contract_time = row_dict[27] # Contract
is_small_job = row_dict[28] # Small Jobs
how_hear = row_dict[29] # How Hear
# Convert the datetime.
local_birthdate = get_dt_from_toronto_timezone_ms_access_dt_string(birthdate)
local_join_date = get_dt_from_toronto_timezone_ms_access_dt_string(join_date)
local_dues_date = get_dt_from_toronto_timezone_ms_access_dt_string(dues_date)
local_commercial_insurance_expiry_date = get_dt_from_toronto_timezone_ms_access_dt_string(commercial_insurance_expiry_date)
local_police_check = get_dt_from_toronto_timezone_ms_access_dt_string(police_check)
# Minor formatting.
email = email.replace(';', '')
email = email.replace(':', '')
email = email.replace('NONE', '')
email = email.replace('N/A', '')
email = email.replace(' ', '')
email = email.lower()
address = '-' if address is '' else address
address = '-' if address is None else address
province = 'ON' if province is '' else province
province = 'ON' if province is None else province
city = "London" if city is '' else city
phone = phone.replace('(', '')
phone = phone.replace(')', '')
phone = phone.replace('-', '')
phone = phone.replace(' ', '')
phone = phone.replace('.', '')
cell = cell.replace('(', '')
cell = cell.replace(')', '')
cell = cell.replace('-', '')
cell = cell.replace(' ', '')
cell = cell.replace('.', '')
# Convert is active to be python boolean.
if is_active == '0':
is_active = False
if is_active == '1':
is_active = True
# Format the `how_hear` and `how_hear_other`.
how_hear_other = None
if how_hear is not None and how_hear != "" and len(how_hear) > 0:
how_hear_other = how_hear
how_hear = 1 # Other
else:
how_hear_other = None
how_hear = 8 # Prefer not to say.
# Create or update our user.
user = None
created = False
if email is not None:
user, created = SharedUser.objects.update_or_create(
email=email,
defaults={
'first_name': given_name,
'last_name': last_name,
'email': email,
'is_active': False, # By default everyone is de-activate unless activated by O55 staff.
}
)
if created:
# Generate and assign the password.
user.set_password(get_random_string())
user.save()
# Attach our user to the "Executive"
user.groups.add(ASSOCIATE_GROUP_ID)
# Format telephone number(s).
if phone:
phone = phonenumbers.parse(str(phone), "CA")
if cell:
cell = phonenumbers.parse(str(cell), "CA")
# Update or create.
associate, created_associate = Associate.objects.update_or_create(
id=pk,
defaults={
'owner': user,
'last_name':last_name,
'given_name':given_name,
'business':business,
# 'is_active':bool_or_none(is_active),
'birthdate':local_birthdate,
'address_country':'Canada',
'join_date':local_join_date,
'telephone':phone,
'telephone_type_of': TELEPHONE_CONTACT_POINT_TYPE_OF_ID,
'other_telephone': cell,
'other_telephone_type_of': MOBILE_CONTACT_POINT_TYPE_OF_ID,
'email':email,
'address_locality':city,
'address_region':province,
'street_address': address,
'postal_code':postal_code,
'area_served':ldn_area,
'hourly_salary_desired':int_or_none(hourly_salary_desired),
'limit_special':limit_special,
'dues_date':local_dues_date,
'commercial_insurance_expiry_date':local_commercial_insurance_expiry_date,
'police_check':local_police_check,
'drivers_license_class':drivers_license_class,
# 'comments':comments,
'how_hear': how_hear,
'how_hear_other': how_hear_other,
'last_modified_by': None,
'created_by': None,
'is_ok_to_email': False,
'is_ok_to_text': False
}
)
# Create our comments if there is text.
if comments_text is not None and comments_text != "" and len(comments_text) > 0:
comment, created_comment = Comment.objects.update_or_create(
text=comments_text,
defaults={
'text': comments_text
}
)
AssociateComment.objects.update_or_create(
about=associate,
comment=comment,
defaults={
'about': associate,
'comment': comment
}
)
# Attach the `VehicleType` objects with this Associate.
if has_car:
vehicle_type = VehicleType.objects.get(text="Car")
associate.vehicle_types.add(vehicle_type)
if has_van:
vehicle_type = VehicleType.objects.get(text="Van")
associate.vehicle_types.add(vehicle_type)
if has_truck:
vehicle_type = VehicleType.objects.get(text="Truck")
associate.vehicle_types.add(vehicle_type)
# For debugging purposes.
# print(associate, create)
except Exception as e:
self.stdout.write(
self.style.NOTICE(_('Importing Associate Member #%(id)s with exception "%(e)s" for %(email)s.') % {
'e': str(e),
'id': str(index),
'email': str(email)
})
)
def run_import_from_dict(self, row_dict, index=1):
try:
# Fetch our values.
pk = int_or_none(row_dict[0])
project_date = row_dict[1]
last_name = row_dict[2]
first_name = row_dict[3]
home_phone = row_dict[4]
postal_code = row_dict[5]
job_info_read = row_dict[6]
learn_about = row_dict[7]
is_support = bool_or_none(row_dict[8])
is_senior = bool_or_none(row_dict[9])
birthdate = row_dict[10]
job_description = row_dict[11]
address = row_dict[12]
city = row_dict[13]
email = row_dict[14]
url = None
telephone_extension = None
# Minor formatting.
email = email.replace(';', '')
email = email.replace(':', '')
email = email.replace('NONE', '')
email = email.replace('N/A', '')
email = email.replace(' ', '')
email = email.lower()
address = '-' if address is '' else address
address = '-' if address is None else address
city = "London" if city is '' else city
if "www" in email.lower():
url = "http://" + email.lower()
email = ""
if "ext" in email.lower():
telephone_extension = email
email = ""
home_phone = home_phone.replace('(', '')
home_phone = home_phone.replace(')', '')
home_phone = home_phone.replace('-', '')
home_phone = home_phone.replace(' ', '')
home_phone = home_phone.replace('.', '')
home_phone = int_or_none(home_phone)
# Convert the datetime.
local_birthdate = get_utc_dt_from_toronto_dt_string(birthdate)
local_project_date = get_utc_dt_from_toronto_dt_string(
project_date)
# Finally title the words.
if first_name:
first_name = first_name.title()
if last_name:
last_name = last_name.title()
if address:
address = address.title()
if city:
city = city.title()
# Create or update our user if it exists
user = None
email = None
created = False
if email is not None and email != "":
user, created = SharedUser.objects.update_or_create(
first_name=first_name,
last_name=last_name,
email=email,
defaults={
'first_name': first_name,
'last_name': last_name,
'email': email,
'is_active': True,
'date_joined': local_project_date
})
if created:
# Generate and assign the password.
user.set_password(get_random_string())
user.save()
# Attach our user to the "CUSTOMER_GROUP_ID"
user.groups.add(CUSTOMER_GROUP_ID)
# Format telephone number.
if home_phone:
home_phone = phonenumbers.parse(str(home_phone), "CA")
# Insert our extracted data into our database.
customer, create = Customer.objects.update_or_create(
id=pk,
defaults={
'id': pk,
'owner': user,
'last_name': last_name,
'given_name': first_name,
# 'middle_name':middle_name,
'telephone': home_phone,
'telephone_extension': telephone_extension,
'telephone_type_of': TELEPHONE_CONTACT_POINT_TYPE_OF_ID,
'postal_code': postal_code,
'birthdate': local_birthdate,
'street_address': address,
'address_locality': city,
'address_country': 'Canada',
'address_region': 'Ontario',
'email': email,
'join_date': local_project_date,
'job_info_read': job_info_read,
'how_hear': learn_about,
'description': job_description,
'is_senior': bool(is_senior),
'is_support': bool(is_support),
'is_business': False,
'last_modified_by': None,
'created_by': None,
'type_of': RESIDENTIAL_CUSTOMER_TYPE_OF_ID,
'is_ok_to_email': False,
'is_ok_to_text': False
})
# For debugging purposes only.
# self.stdout.write(
# self.style.SUCCESS(_('Imported (Personal) Customer #%(id)s.') % {
# 'id': str(index)
# })
# )
except Exception as e:
self.stdout.write(
self.style.NOTICE(
_('Importing (Personal) Customer #%(id)s with exception "%(e)s" for %(email)s.'
) % {
'e': str(e),
'id': str(index),
'email': str(email)
}))
if "Your email is not unique!" in str(e):
customer = Customer.objects.filter(email=email)
print(customer)
print()