1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
from django.db import models
from django.conf import settings
# Create your models here.
class Company(models.Model):
name = models.CharField(max_length=256)
address = models.CharField(max_length=256)
phone_number = models.DecimalField(max_digits=16,decimal_places=0)
email_address = models.CharField(max_length=256)
primary_contact = models.ForeignKey('Contact', blank=True, null=True)
def __str__(self):
return self.name
class Contact(models.Model):
first_name = models.CharField(max_length=64)
last_name = models.CharField(max_length=64)
phone_number = models.DecimalField(max_digits=16,decimal_places=0)
email_address = models.CharField(max_length=256)
works_for = models.ForeignKey(Company)
def __str__(self):
return "{f} {l} ( {c} )".format(c=self.works_for, f=self.first_name, l=self.last_name)
class Load(models.Model):
load_number = models.CharField(max_length=64,default="")
date = models.DateField()
user = models.ForeignKey(settings.AUTH_USER_MODEL)
company = models.ForeignKey(Company)
description = models.CharField(max_length=256)
amount = models.DecimalField(max_digits=10,decimal_places=2)
def __str__(self):
return "{c}, {d} ( {a} )".format(c=self.company, d=self.description, a=self.amount)
# class Paperwork(models.Model):
# company = models.OneToOneField(Company)
# description = models.CharField(max_length=256)
# amount = models.DecimalField(max_digits=10,decimal_places=2)
#
# def __str__(self):
# return "{c}, {d} ( {a} )".format(c=self.company, d=self.description, a=self.amount)
|
