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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
|
from django import forms
from django.core.exceptions import ValidationError
from django.forms.models import BaseInlineFormSet
from .models import JournalEntry, JournalItem, Object, JournalUrl, Account
class JournalEntryForm(forms.ModelForm):
def __init__(self, *args, **kwargs):
super(JournalEntryForm, self).__init__(*args, **kwargs)
self.fields['date'].widget.attrs['class'] = 'datepicker'
self.fields['date'].widget.attrs['autofocus'] = 'autofocus'
class Meta:
model = JournalEntry
exclude = ('year', 'seq', )
def PositiveValidator(v):
if v <= 0:
raise ValidationError("Value must be a positive integer")
class JournalItemForm(forms.ModelForm):
debit = forms.DecimalField(max_digits=10, decimal_places=2, validators=[PositiveValidator, ], required=False)
credit = forms.DecimalField(max_digits=10, decimal_places=2, validators=[PositiveValidator, ], required=False)
def __init__(self, *args, **kwargs):
super(JournalItemForm, self).__init__(*args, **kwargs)
if self.instance.amount:
if self.instance.amount > 0:
self.fields['debit'].initial = self.instance.amount
elif self.instance.amount < 0:
self.fields['credit'].initial = -self.instance.amount
self.fields['account'].widget.attrs['class'] = 'dropdownbox'
self.fields['object'].widget.attrs['class'] = 'dropdownbox'
self.fields['object'].queryset = Object.objects.filter(active=True)
self.fields['description'].widget.attrs['class'] = 'descriptionbox form-control'
self.fields['debit'].widget.attrs['class'] = 'debitbox form-control'
self.fields['credit'].widget.attrs['class'] = 'creditbox form-control'
class Meta:
model = JournalItem
exclude = ('amount', )
def clean(self):
if not self.cleaned_data:
return
if 'debit' not in self.cleaned_data or 'credit' not in self.cleaned_data:
# This means there is an error elsewhere!
return self.cleaned_data
if self.cleaned_data['debit'] and self.cleaned_data['credit']:
raise ValidationError("Can't specify both debit and credit!")
if not self.cleaned_data['debit'] and not self.cleaned_data['credit']:
raise ValidationError("Must specify either debit or credit!")
return self.cleaned_data
def clean_object(self):
if 'account' in self.cleaned_data:
if self.cleaned_data['account'].objectrequirement == 1:
# object is required
if not self.cleaned_data['object']:
raise ValidationError("Account %s requires an object to be specified" % self.cleaned_data['account'].num)
elif self.cleaned_data['account'].objectrequirement == 2:
# object is forbidden
if self.cleaned_data['object']:
raise ValidationError("Account %s does not allow an object to be specified" % self.cleaned_data['account'].num)
return self.cleaned_data['object']
def save(self, commit=True):
instance = super(JournalItemForm, self).save(commit=False)
if self.cleaned_data['debit']:
instance.amount = self.cleaned_data['debit']
else:
instance.amount = -self.cleaned_data['credit']
if commit:
instance.save()
return instance
def get_amount(self):
if not hasattr(self, 'cleaned_data'):
return 0
if not self.cleaned_data:
return 0
if self.cleaned_data['DELETE']:
return 0
debit = self.cleaned_data.get('debit', 0) or 0
credit = self.cleaned_data.get('credit', 0) or 0
return debit - credit
class JournalItemFormset(BaseInlineFormSet):
def clean(self):
super(JournalItemFormset, self).clean()
if len(self.forms) == 0:
raise ValidationError("Cannot save with no entries")
s = sum([f.get_amount() for f in self.forms])
if s != 0:
raise ValidationError("Journal entry does not balance, sum is %s!" % s)
n = sum([1 for f in self.forms if f.get_amount() != 0])
if n == 0:
raise ValidationError("Journal entry must have at least one item!")
class JournalUrlForm(forms.ModelForm):
class Meta:
model = JournalUrl
exclude = ()
def __init__(self, *args, **kwargs):
super(JournalUrlForm, self).__init__(*args, **kwargs)
self.fields['url'].widget.attrs['class'] = 'form-control'
class CloseYearForm(forms.Form):
account = forms.ModelChoiceField(Account.objects.filter(group__accountclass__inbalance=True),
label="Balance account", required=True,
help_text="Results for this year will be posted to this account, typically 'last years profit'")
confirm = forms.BooleanField(label="Confirm", required=True,
help_text="Confirm that you want to close this year, transferring the results to the selected balance account")
def __init__(self, balance, *args, **kwargs):
super(CloseYearForm, self).__init__(*args, **kwargs)
self.balance = balance
def clean_account(self):
account = self.cleaned_data['account']
for b in self.balance:
if b['anum'] == account.num and b['outgoingamount'] != 0:
raise ValidationError("Account {0} has an outgoing balance of {1}, should be empty!".format(account.num, b['outgoingamount']))
return account
|
