class Lead(models.SalesforceModel):
name = models.CharField(max_length=121,
verbose_name='Full Name',
sf_read_only=models.READ_ONLY)
last_name = models.CharField(max_length=80)
first_name = models.CharField(max_length=40, blank=True)
company = models.CharField(max_length=255)
phone = models.CharField(max_length=40, blank=True)
mobile_phone = models.CharField(max_length=40, blank=True)
other_phone = models.CharField(custom=True,
db_column='Other_Phone__c',
max_length=40,
verbose_name='Other Phone',
blank=True)
email = models.EmailField(blank=True, null=True)
alternate_email = models.EmailField(custom=True,
db_column='Alternate_email__c',
verbose_name='Alternate email',
blank=True,
null=True)
country = models.CharField(max_length=80, blank=True)
street = models.CharField(max_length=255, blank=True)
city = models.CharField(max_length=40, blank=True)
state = models.CharField(max_length=80,
verbose_name='State/Province',
blank=True)
postal_code = models.CharField(max_length=20,
verbose_name='Zip/Postal Code',
blank=True)
created_date = models.DateTimeField(sf_read_only=models.READ_ONLY)
class Meta(models.Model.Meta):
db_table = 'Lead'
verbose_name = 'Lead'
verbose_name_plural = 'Leads'
class Contact(models.Model):
is_deleted = models.BooleanField(verbose_name='Deleted',
sf_read_only=models.READ_ONLY)
master_record = models.ForeignKey('self',
models.DO_NOTHING,
related_name='contact_masterrecord_set',
sf_read_only=models.READ_ONLY,
blank=True,
null=True)
account = models.ForeignKey(
Account,
models.DO_NOTHING,
blank=True,
null=True,
related_name='contacts',
related_query_name='contact') # Master Detail Relationship *
last_name = models.CharField(max_length=80)
first_name = models.CharField(max_length=40, blank=True, null=True)
salutation = models.CharField(max_length=40,
choices=[('Mr.', 'Mr.'), ('Ms.', 'Ms.'),
('Mrs.', 'Mrs.'), ('Dr.', 'Dr.'),
('Prof.', 'Prof.')],
blank=True,
null=True)
name = models.CharField(max_length=121,
verbose_name='Full Name',
sf_read_only=models.READ_ONLY)
email = models.EmailField(blank=True, null=True)
used_by_e_commerce = models.BooleanField(default=True,
custom=True,
db_column='Used_by_eCommerce__c',
max_length=255,
verbose_name='Used by eCommerce')
class Contact(SalesforceModel): # Example that db_column is not necessary for most of fields even with # lower case names and for ForeignKey account = models.ForeignKey(Account, on_delete=models.DO_NOTHING, blank=True, null=True) # db_column: 'AccountId' last_name = models.CharField(max_length=80) first_name = models.CharField(max_length=40, blank=True) name = models.CharField(max_length=121, sf_read_only=models.READ_ONLY, verbose_name='Full Name') email = models.EmailField(blank=True, null=True) email_bounced_date = models.DateTimeField(blank=True, null=True) # The `default=` with lambda function is easy readable, but can be # problematic with migrations in the future because it is not serializable. # It can be replaced by normal function. owner = models.ForeignKey(User, on_delete=models.DO_NOTHING, default=models.DEFAULTED_ON_CREATE, related_name='contact_owner_set') def __str__(self): return self.name
class Contact(SalesforceModel):
Account = models.ForeignKey(Account,
on_delete=models.DO_NOTHING,
db_column='AccountId',
blank=True,
null=True)
LastName = models.CharField(max_length=80)
FirstName = models.CharField(max_length=40, blank=True)
Name = models.CharField(max_length=121,
sf_read_only=models.READ_ONLY,
verbose_name='Full Name')
Email = models.EmailField(blank=True, null=True)
EmailBouncedDate = models.DateTimeField(blank=True, null=True)
Owner = models.ForeignKey(User,
on_delete=models.DO_NOTHING,
default=lambda: User(Id='DEFAULT'),
db_column='OwnerId',
related_name='contact_owner_set')
def __unicode__(self):
return self.Name
class Contact(models.Model):
"""Model that maps to Salesforce Contact object."""
account = models.ForeignKey(Account,
models.DO_NOTHING,
blank=True,
null=True)
last_name = models.CharField(max_length=80)
first_name = models.CharField(max_length=40, blank=True, null=True)
name = models.CharField(max_length=121,
verbose_name='Full Name',
sf_read_only=models.READ_ONLY)
email = models.EmailField()
year_of_birth = models.CharField(custom=True,
db_column='Year_of_Birth__c',
max_length=255,
verbose_name='Year of Birth',
blank=True,
null=True)
language = models.CharField(custom=True,
max_length=255,
blank=True,
null=True)
country = models.CharField(custom=True,
max_length=255,
choices=COUNTRIES,
blank=True,
null=True)
pi_utm_campaign = models.CharField(
db_column='pi__utm_campaign__c',
custom=True,
max_length=255,
verbose_name='Google Analytics Campaign',
blank=True,
null=True)
pi_utm_content = models.CharField(db_column='pi__utm_content__c',
custom=True,
max_length=255,
verbose_name='Google Analytics Content',
blank=True,
null=True)
pi_utm_medium = models.CharField(db_column='pi__utm_medium__c',
custom=True,
max_length=255,
verbose_name='Google Analytics Medium',
blank=True,
null=True)
pi_utm_source = models.CharField(db_column='pi__utm_source__c',
custom=True,
max_length=255,
verbose_name='Google Analytics Source',
blank=True,
null=True)
pi_utm_term = models.CharField(db_column='pi__utm_term__c',
custom=True,
max_length=255,
verbose_name='Google Analytics Term',
blank=True,
null=True)
registration_date = models.DateTimeField(custom=True,
db_column='Registration_Date__c',
verbose_name='Registration Date',
blank=True,
null=True)
level_of_education = models.CharField(custom=True,
db_column='Level_of_Education__c',
max_length=255,
verbose_name='Level of Education',
blank=True,
null=True)
interest = models.TextField(custom=True, blank=True)
gender = models.CharField(custom=True,
max_length=255,
blank=True,
null=True)
class Meta(models.Model.Meta):
db_table = 'Contact'
verbose_name = 'Contact'
verbose_name_plural = 'Contacts'
def __unicode__(self):
"""Return unicode representation of object."""
return self.name
class Lead(models.Model):
"""Model that maps to Salesforce Lead object."""
last_name = models.CharField(max_length=80)
first_name = models.CharField(max_length=40, blank=True, null=True)
company = models.CharField(max_length=255, verbose_name='Organization')
email = models.EmailField()
status = models.CharField(max_length=40,
default=models.DEFAULTED_ON_CREATE)
is_converted = models.BooleanField(verbose_name='Converted',
sf_read_only=models.NOT_UPDATEABLE,
default=models.DEFAULTED_ON_CREATE)
converted_account = models.ForeignKey(Account,
models.DO_NOTHING,
sf_read_only=models.READ_ONLY,
blank=True,
null=True)
converted_contact = models.ForeignKey(Contact,
models.DO_NOTHING,
sf_read_only=models.READ_ONLY,
blank=True,
null=True)
username = models.CharField(custom=True, max_length=100)
year_of_birth = models.CharField(custom=True,
db_column='Year_of_Birth__c',
max_length=255,
verbose_name='Year of Birth',
blank=True,
null=True)
language = models.CharField(custom=True,
max_length=255,
blank=True,
null=True)
country = models.CharField(db_column='Country__c',
custom=True,
max_length=255,
choices=COUNTRIES,
blank=True,
null=True)
pi_utm_campaign = models.CharField(
db_column='pi__utm_campaign__c',
custom=True,
max_length=255,
verbose_name='Google Analytics Campaign',
blank=True,
null=True)
pi_utm_content = models.CharField(db_column='pi__utm_content__c',
custom=True,
max_length=255,
verbose_name='Google Analytics Content',
blank=True,
null=True)
pi_utm_medium = models.CharField(db_column='pi__utm_medium__c',
custom=True,
max_length=255,
verbose_name='Google Analytics Medium',
blank=True,
null=True)
pi_utm_source = models.CharField(db_column='pi__utm_source__c',
custom=True,
max_length=255,
verbose_name='Google Analytics Source',
blank=True,
null=True)
pi_utm_term = models.CharField(db_column='pi__utm_term__c',
custom=True,
max_length=255,
verbose_name='Google Analytics Term',
blank=True,
null=True)
programs = models.CharField(custom=True,
max_length=4099,
default='OpenClassroom')
registration_date = models.DateTimeField(custom=True,
db_column='Registration_Date__c',
verbose_name='Registration Date',
blank=True,
null=True)
level_of_education = models.CharField(custom=True,
db_column='Level_of_Education__c',
max_length=255,
verbose_name='Level of Education',
blank=True,
null=True)
interest = models.TextField(custom=True, blank=True)
gender = models.CharField(custom=True,
max_length=255,
blank=True,
null=True)
class Meta(models.Model.Meta):
db_table = 'Lead'
verbose_name = 'Lead'
verbose_name_plural = 'Leads'
def __unicode__(self):
"""Return unicode representation of object."""
return self.username
class Contact(models.Model):
is_deleted = models.BooleanField(db_column='IsDeleted',
verbose_name='Eliminado',
sf_read_only=models.READ_ONLY,
default=False)
master_record = models.ForeignKey('self',
models.DO_NOTHING,
db_column='MasterRecordId',
related_name='contact_masterrecord_set',
verbose_name='Id. de registro principal',
sf_read_only=models.READ_ONLY,
blank=True,
null=True)
account = models.ForeignKey('Account',
models.DO_NOTHING,
db_column='AccountId',
related_name='contact_account_set',
verbose_name='Id. de la cuenta',
blank=True,
null=True) # Master Detail Relationship *
last_name = models.CharField(db_column='LastName',
max_length=80,
verbose_name='Apellidos')
first_name = models.CharField(db_column='FirstName',
max_length=40,
verbose_name='Nombre',
blank=True,
null=True)
name = models.CharField(db_column='Name',
max_length=121,
verbose_name='Nombre completo',
sf_read_only=models.READ_ONLY)
record_type = models.ForeignKey('RecordType',
models.DO_NOTHING,
db_column='RecordTypeId',
verbose_name='Id. de tipo de registro',
blank=True,
null=True)
other_street = models.TextField(db_column='OtherStreet',
verbose_name='Otra calle',
blank=True,
null=True)
other_city = models.CharField(db_column='OtherCity',
max_length=40,
verbose_name='Otra ciudad',
blank=True,
null=True)
other_state = models.CharField(db_column='OtherState',
max_length=80,
verbose_name='Otro estado o provincia',
blank=True,
null=True)
other_postal_code = models.CharField(db_column='OtherPostalCode',
max_length=20,
verbose_name='Otro código postal',
blank=True,
null=True)
mailing_street = models.TextField(db_column='MailingStreet',
verbose_name='Calle de correo',
blank=True,
null=True)
mailing_city = models.CharField(db_column='MailingCity',
max_length=40,
verbose_name='Ciudad de correo',
blank=True,
null=True)
mailing_state = models.CharField(
db_column='MailingState',
max_length=80,
verbose_name='Estado o provincia de correo',
blank=True,
null=True)
mailing_postal_code = models.CharField(
db_column='MailingPostalCode',
max_length=20,
verbose_name='Código postal de correo',
blank=True,
null=True)
home_phone = models.CharField(db_column='HomePhone',
max_length=40,
verbose_name='Teléfono particular',
blank=True,
null=True)
email = models.EmailField(db_column='Email',
verbose_name='Correo electrónico',
blank=True,
null=True)
birthdate = models.DateField(db_column='Birthdate',
verbose_name='Fecha de nacimiento',
blank=True,
null=True)
gender = models.CharField(db_column='Gender__c',
max_length=255,
choices=[('Male', 'Male'), ('Female', 'Female'),
('Other', 'Other')],
blank=True,
null=True)
n_mero_de_documento = models.CharField(
db_column='N_mero_de_Documento__c',
max_length=18,
verbose_name='Número de Documento',
help_text=
'Debe introducir un DNI valido con 8 dígitos. En caso de que el DNI tenga 7 digitos debe introducirlo con un 0 delante',
blank=True,
null=True)
sexo = models.CharField(db_column='Sexo__c',
max_length=255,
choices=[('Hombre', 'Hombre'), ('Mujer', 'Mujer'),
('Otro', 'Otro')],
blank=True,
null=True)
cuit_cuil = models.DecimalField(
db_column='Cuit_Cuil__c',
unique=True,
max_digits=11,
decimal_places=0,
verbose_name='Cuit/Cuil',
help_text='Se debe introducir el número sin guiones ni puntos',
blank=True,
null=True)
necesita_recibo = models.CharField(db_column='Necesita_recibo__c',
max_length=255,
verbose_name='¿Necesita recibo?',
choices=[('Sí', 'Sí'), ('No', 'No')],
blank=True,
null=True)
tipo_de_documento = models.CharField(db_column='Tipo_de_documento__c',
max_length=255,
verbose_name='Tipo de documento',
choices=[('DNI', 'DNI'),
('Pasaporte', 'Pasaporte')],
blank=True,
null=True)
class Meta(models.Model.Meta):
db_table = 'Contact'
verbose_name = 'Contacto'
verbose_name_plural = 'Contactos'
class A(SalesforceModel):
email = models.EmailField(custom=True)
class Meta:
db_table = 'A__c'
class Contact(models.Model):
is_deleted = models.BooleanField(verbose_name="Deleted",
sf_read_only=models.READ_ONLY,
default=False)
master_record = models.ForeignKey(
"self",
models.DO_NOTHING,
related_name="contact_masterrecord_set",
sf_read_only=models.READ_ONLY,
blank=True,
null=True,
)
account = models.ForeignKey(
Account,
models.DO_NOTHING,
related_name="contact_account_set",
blank=True,
null=True,
) # Master Detail Relationship *
last_name = models.CharField(max_length=80)
first_name = models.CharField(max_length=40, blank=True, null=True)
salutation = models.CharField(max_length=40,
choices=SALUTATION_CHOICES,
blank=True,
null=True)
middle_name = models.CharField(max_length=40, blank=True, null=True)
suffix = models.CharField(max_length=40, blank=True, null=True)
name = models.CharField(max_length=121,
verbose_name="Full Name",
sf_read_only=models.READ_ONLY)
mailing_street = models.TextField(blank=True, null=True)
mailing_city = models.CharField(max_length=40, blank=True, null=True)
mailing_state = models.CharField(max_length=80,
verbose_name="Mailing State/Province",
blank=True,
null=True)
mailing_postal_code = models.CharField(
max_length=20,
verbose_name="Mailing Zip/Postal Code",
blank=True,
null=True)
mailing_country = models.CharField(max_length=80, blank=True, null=True)
mailing_state_code = models.CharField(
max_length=10,
verbose_name="Mailing State/Province Code",
choices=STATE_CHOICES,
blank=True,
null=True,
)
mailing_country_code = models.CharField(
max_length=10,
default=models.DEFAULTED_ON_CREATE,
choices=STATE_CHOICES,
blank=True,
null=True,
)
mobile_phone = models.CharField(max_length=40, blank=True, null=True)
home_phone = models.CharField(max_length=40, blank=True, null=True)
other_phone = models.CharField(max_length=40, blank=True, null=True)
email = models.EmailField(blank=True, null=True)
title = models.CharField(max_length=128, blank=True, null=True)
department = models.CharField(max_length=80, blank=True, null=True)
birthdate = models.DateField(blank=True, null=True)
owner = models.ForeignKey("User",
models.DO_NOTHING,
related_name="contact_owner_set",
blank=True)
created_date = models.DateTimeField(sf_read_only=models.READ_ONLY)
created_by = models.ForeignKey(
"User",
models.DO_NOTHING,
related_name="contact_createdby_set",
sf_read_only=models.READ_ONLY,
)
last_modified_date = models.DateTimeField(sf_read_only=models.READ_ONLY)
last_modified_by = models.ForeignKey(
"User",
models.DO_NOTHING,
related_name="contact_lastmodifiedby_set",
sf_read_only=models.READ_ONLY,
)
system_modstamp = models.DateTimeField(sf_read_only=models.READ_ONLY)
last_activity_date = models.DateField(
verbose_name="Last Activity",
sf_read_only=models.READ_ONLY,
blank=True,
null=True,
)
last_curequest_date = models.DateTimeField(
db_column="LastCURequestDate",
verbose_name="Last Stay-in-Touch Request Date",
sf_read_only=models.READ_ONLY,
blank=True,
null=True,
)
last_cuupdate_date = models.DateTimeField(
db_column="LastCUUpdateDate",
verbose_name="Last Stay-in-Touch Save Date",
sf_read_only=models.READ_ONLY,
blank=True,
null=True,
)
last_viewed_date = models.DateTimeField(sf_read_only=models.READ_ONLY,
blank=True,
null=True)
last_referenced_date = models.DateTimeField(sf_read_only=models.READ_ONLY,
blank=True,
null=True)
email_bounced_reason = models.CharField(max_length=255,
blank=True,
null=True)
email_bounced_date = models.DateTimeField(blank=True, null=True)
is_email_bounced = models.BooleanField(sf_read_only=models.READ_ONLY,
default=False)
photo_url = models.URLField(verbose_name="Photo URL",
sf_read_only=models.READ_ONLY,
blank=True,
null=True)
jigsaw_contact_id = models.CharField(
max_length=20,
verbose_name="Jigsaw Contact ID",
sf_read_only=models.READ_ONLY,
blank=True,
null=True,
)
individual = models.ForeignKey("Individual",
models.DO_NOTHING,
blank=True,
null=True)
race = models.CharField(
custom=True,
max_length=255,
verbose_name="Which best describes your race?",
choices=RACE_CHOICES,
blank=True,
null=True,
)
gender = models.CharField(custom=True,
max_length=255,
choices=GENDER_CHOICES,
blank=True,
null=True)
which_best_describes_your_ethnicity = models.CharField(
custom=True,
db_column="Which_best_describes_your_ethnicity__c",
max_length=255,
verbose_name="Which best describes your ethnicity?",
choices=ETHNICITY_CHOICES,
blank=True,
null=True,
)
expected_graduation_year = models.CharField(
custom=True,
db_column="Expected_graduation_year__c",
max_length=4,
verbose_name="Expected graduation year",
help_text=
"Enter the year this contact is expected to graduate. For example, 2020",
blank=True,
null=True,
)
current_grade_level = models.CharField(
custom=True,
db_column="Current_grade_level__c",
max_length=1300,
verbose_name="Current grade level",
sf_read_only=models.READ_ONLY,
blank=True,
null=True,
)
volunteer_area_s_of_interest = models.CharField(
custom=True,
db_column="Volunteer_area_s_of_interest__c",
max_length=4099,
verbose_name="Volunteer area(s) of interest",
choices=[("Classroom", "Classroom"), ("Event", "Event"),
("Other", "Other")],
blank=True,
null=True,
)
enrollments_this_semester_applied = models.DecimalField(
custom=True,
db_column="enrollments_this_semester_Applied__c",
max_digits=2,
decimal_places=0,
verbose_name="# enrollments this semester - Applied",
help_text="DO NOT EDIT - AUTO-POPULATED BY SYSTEM",
blank=True,
null=True,
)
enrollments_this_semester_waitlisted = models.DecimalField(
custom=True,
db_column="enrollments_this_semester_Waitlisted__c",
max_digits=2,
decimal_places=0,
verbose_name="# enrollments this semester - Waitlisted",
help_text="DO NOT EDIT - AUTO-POPULATED BY SYSTEM",
blank=True,
null=True,
)
enrollments_this_semester_rejected = models.DecimalField(
custom=True,
db_column="enrollments_this_semester_Rejected__c",
max_digits=2,
decimal_places=0,
verbose_name="# enrollments this semester - Rejected",
help_text="DO NOT EDIT - AUTO-POPULATED BY SYSTEM",
blank=True,
null=True,
)
enrollments_this_semester_drop_out = models.DecimalField(
custom=True,
db_column="enrollments_this_semester_Drop_out__c",
max_digits=2,
decimal_places=0,
verbose_name="# enrollments this semester - Drop out",
help_text="DO NOT EDIT - AUTO-POPULATED BY SYSTEM",
blank=True,
null=True,
)
race_other = models.CharField(
custom=True,
db_column="Race_Other__c",
max_length=100,
verbose_name="Which best describes your race? (Other)",
blank=True,
null=True,
)
gender_other = models.CharField(
custom=True,
db_column="Gender_Other__c",
max_length=50,
verbose_name="Gender (Other)",
blank=True,
null=True,
)
parent_guardian_first_name = models.CharField(
custom=True,
db_column="Parent_Guardian_first_name__c",
max_length=100,
verbose_name="Parent/Guardian first name",
blank=True,
null=True,
)
parent_guardian_last_name = models.CharField(
custom=True,
db_column="Parent_Guardian_last_name__c",
max_length=100,
verbose_name="Parent/Guardian last name",
blank=True,
null=True,
)
parent_guardian_phone = models.CharField(
custom=True,
db_column="Parent_Guardian_phone__c",
max_length=40,
verbose_name="Parent/Guardian phone",
blank=True,
null=True,
)
parent_guardian_email = models.EmailField(
custom=True,
db_column="Parent_Guardian_email__c",
verbose_name="Parent/Guardian email",
blank=True,
null=True,
)
dm_current_grade = models.CharField(
custom=True,
db_column="DM_Current_grade__c",
max_length=255,
verbose_name="DM - Current grade",
help_text=
"Need this for data migration to calculate Expected Graduation Year? If not, delete this field.",
choices=CURRENT_GRADE_CHOICES,
blank=True,
null=True,
)
client_id = models.CharField(
custom=True,
db_column="Client_ID__c",
max_length=14,
verbose_name="Client ID",
help_text=
'3 first letters of first name, 3 first letters of last name, and birthdate "AAABBB00000000" (Only used for students and parents). This field is auto-populated by FormAssembly.',
blank=True,
null=True,
)
npsp_primary_affiliation = models.ForeignKey(
Account,
models.DO_NOTHING,
db_column="npsp__Primary_Affiliation__c",
custom=True,
related_name="contact_npspprimaryaffiliation_set",
blank=True,
null=True,
)
class Meta(models.Model.Meta):
db_table = "Contact"
verbose_name = "Contact"
verbose_name_plural = "Contacts"
# keyPrefix = '003'
def __str__(self):
return "%s %s" % (self.first_name, self.last_name)
class Contact(models.Model):
is_deleted = models.BooleanField(verbose_name='Deleted',
sf_read_only=models.READ_ONLY)
master_record = models.ForeignKey('self',
related_name='contact_masterrecord_set',
sf_read_only=models.READ_ONLY,
on_delete=models.DO_NOTHING,
blank=True,
null=True)
#account = models.ForeignKey('Account', on_delete=models.DO_NOTHING, blank=True, null=True)
last_name = models.CharField(max_length=80, verbose_name='Last Name')
first_name = models.CharField(max_length=40,
verbose_name='First Name',
blank=True)
salutation = models.CharField(max_length=40,
verbose_name='Salutation',
choices=[(u'Mr.', u'Mr.'), (u'Ms.', u'Ms.'),
(u'Mrs.', u'Mrs.'),
(u'Dr.', u'Dr.'),
(u'Prof.', u'Prof.')],
blank=True)
name = models.CharField(max_length=121,
verbose_name='Full Name',
sf_read_only=models.READ_ONLY)
other_street = models.TextField(verbose_name='Other Street', blank=True)
other_city = models.CharField(max_length=40,
verbose_name='Other City',
blank=True)
other_state = models.CharField(max_length=80,
verbose_name='Other State/Province',
blank=True)
other_postal_code = models.CharField(max_length=20,
verbose_name='Other Zip/Postal Code',
blank=True)
other_country = models.CharField(max_length=80,
verbose_name='Other Country',
blank=True)
other_latitude = models.DecimalField(max_digits=18,
decimal_places=15,
verbose_name='Other Latitude',
blank=True,
null=True)
other_longitude = models.DecimalField(max_digits=18,
decimal_places=15,
verbose_name='Other Longitude',
blank=True,
null=True)
other_address = models.TextField(verbose_name='Other Address',
sf_read_only=models.READ_ONLY,
blank=True) # This field type is a guess.
mailing_street = models.TextField(verbose_name='Mailing Street',
blank=True)
mailing_city = models.CharField(max_length=40,
verbose_name='Mailing City',
blank=True)
mailing_state = models.CharField(max_length=80,
verbose_name='Mailing State/Province',
blank=True)
mailing_postal_code = models.CharField(
max_length=20, verbose_name='Mailing Zip/Postal Code', blank=True)
mailing_country = models.CharField(max_length=80,
verbose_name='Mailing Country',
blank=True)
mailing_latitude = models.DecimalField(max_digits=18,
decimal_places=15,
verbose_name='Mailing Latitude',
blank=True,
null=True)
mailing_longitude = models.DecimalField(max_digits=18,
decimal_places=15,
verbose_name='Mailing Longitude',
blank=True,
null=True)
mailing_address = models.TextField(
verbose_name='Mailing Address',
sf_read_only=models.READ_ONLY,
blank=True) # This field type is a guess.
phone = models.CharField(max_length=40,
verbose_name='Business Phone',
blank=True)
fax = models.CharField(max_length=40,
verbose_name='Business Fax',
blank=True)
mobile_phone = models.CharField(max_length=40,
verbose_name='Mobile Phone',
blank=True)
home_phone = models.CharField(max_length=40,
verbose_name='Home Phone',
blank=True)
other_phone = models.CharField(max_length=40,
verbose_name='Other Phone',
blank=True)
assistant_phone = models.CharField(max_length=40,
verbose_name='Asst. Phone',
blank=True)
reports_to = models.ForeignKey('self',
related_name='contact_reportsto_set',
on_delete=models.DO_NOTHING,
blank=True,
null=True)
email = models.EmailField(verbose_name='Email', blank=True, null=True)
title = models.CharField(max_length=128, verbose_name='Title', blank=True)
department = models.CharField(max_length=80,
verbose_name='Department',
blank=True)
assistant_name = models.CharField(max_length=40,
verbose_name=u"Assistant's Name",
blank=True)
lead_source = models.CharField(max_length=40,
verbose_name='Lead Source',
choices=[
(u'Web', u'Web'),
(u'Phone Inquiry', u'Phone Inquiry'),
(u'Partner Referral',
u'Partner Referral'),
(u'Purchased List', u'Purchased List'),
(u'Other', u'Other')
],
blank=True)
birthdate = models.DateField(verbose_name='Birthdate',
blank=True,
null=True)
description = models.TextField(verbose_name='Contact Description',
blank=True)
#owner = models.ForeignKey('User', related_name='contact_owner_set', on_delete=models.DO_NOTHING)
#created_date = models.DateTimeField(verbose_name='Created Date', sf_read_only=models.READ_ONLY)
#created_by = models.ForeignKey('User', related_name='contact_createdby_set', sf_read_only=models.READ_ONLY, on_delete=models.DO_NOTHING)
last_modified_date = models.DateTimeField(
verbose_name='Last Modified Date', sf_read_only=models.READ_ONLY)
#last_modified_by = models.ForeignKey('User', related_name='contact_lastmodifiedby_set', sf_read_only=models.READ_ONLY, on_delete=models.DO_NOTHING)
system_modstamp = models.DateTimeField(verbose_name='System Modstamp',
sf_read_only=models.READ_ONLY)
last_activity_date = models.DateField(verbose_name='Last Activity',
sf_read_only=models.READ_ONLY,
blank=True,
null=True)
last_curequest_date = models.DateTimeField(
db_column='LastCURequestDate',
verbose_name='Last Stay-in-Touch Request Date',
sf_read_only=models.READ_ONLY,
blank=True,
null=True)
last_cuupdate_date = models.DateTimeField(
db_column='LastCUUpdateDate',
verbose_name='Last Stay-in-Touch Save Date',
sf_read_only=models.READ_ONLY,
blank=True,
null=True)
last_viewed_date = models.DateTimeField(verbose_name='Last Viewed Date',
sf_read_only=models.READ_ONLY,
blank=True,
null=True)
last_referenced_date = models.DateTimeField(
verbose_name='Last Referenced Date',
sf_read_only=models.READ_ONLY,
blank=True,
null=True)
email_bounced_reason = models.CharField(
max_length=255, verbose_name='Email Bounced Reason', blank=True)
email_bounced_date = models.DateTimeField(
verbose_name='Email Bounced Date', blank=True, null=True)
is_email_bounced = models.BooleanField(verbose_name='Is Email Bounced',
sf_read_only=models.READ_ONLY)
class Meta(models.Model.Meta):
db_table = 'Contact'
verbose_name = 'Contact'
verbose_name_plural = 'Contacts'