def test_filter_form(self):
# filter form test was needed before we changed client so that it always uses the filter form
# so testing here a user input into the form
p = PurchaseHeader.objects.create(type="pi",
supplier=self.supplier,
ref="1",
period=self.period,
date=date.today(),
due_date=date.today(),
due=100,
total=100,
paid=0,
status="c")
self.client.force_login(self.user)
# the url is turned into a dict within the enquiry views
# here we start with a dict because it is easier to understand
url_as_dict = {
'draw': '1',
'columns': {
0: {
'data': '',
'name': '',
'searchable': 'false',
'orderable': 'false',
'search': {
'value': '',
'regex': 'false'
}
},
1: {
'data': 'supplier__name',
'name': '',
'searchable': 'true',
'orderable': 'true',
'search': {
'value': '',
'regex': 'false'
}
},
2: {
'data': 'ref',
'name': '',
'searchable': 'true',
'orderable': 'true',
'search': {
'value': '',
'regex': 'false'
}
},
3: {
'data': 'period__fy_and_period',
'name': '',
'searchable': 'true',
'orderable': 'true',
'search': {
'value': '',
'regex': 'false'
}
},
4: {
'data': 'date',
'name': '',
'searchable': 'true',
'orderable': 'true',
'search': {
'value': '',
'regex': 'false'
}
},
5: {
'data': 'due_date',
'name': '',
'searchable': 'true',
'orderable': 'true',
'search': {
'value': '',
'regex': 'false'
}
},
6: {
'data': 'total',
'name': '',
'searchable': 'true',
'orderable': 'true',
'search': {
'value': '',
'regex': 'false'
}
},
7: {
'data': 'paid',
'name': '',
'searchable': 'true',
'orderable': 'true',
'search': {
'value': '',
'regex': 'false'
}
},
8: {
'data': 'due',
'name': '',
'searchable': 'true',
'orderable': 'true',
'search': {
'value': '',
'regex': 'false'
}
}
},
'order': {
0: {
'column': '1',
'dir': 'asc'
}
},
'start': '0',
'length': '10',
'search': {
'value': '',
'regex': 'false'
},
'supplier': str(self.supplier.pk),
'reference': '',
'total': '',
'period': '',
'search_within': 'any',
'start_date': '',
'end_date': '',
'use_adv_search': 'True'
}
q = dict_to_url(url_as_dict)
# would be nice to pass url_as_dict as the data keyword argument to self.client.get
# but django does not deal with the nested dict the way we want
response = self.client.get(self.url + "?" + q,
HTTP_X_REQUESTED_WITH='XMLHttpRequest')
content = response.content.decode("utf")
d = json.loads(content)
self.assertEqual(d['draw'], 1)
self.assertEqual(d['recordsTotal'], 1)
self.assertEqual(len(d['data']), 1)
tran = d['data'][0]
self.assertEqual(tran['id'], p.pk)
self.assertEqual(tran['supplier__name'], p.supplier.name)
self.assertEqual(tran['ref'], p.ref)
self.assertEqual(
tran['period__fy_and_period'],
p.period.fy_and_period[4:] + " " + p.period.fy_and_period[:4])
self.assertEqual(tran['date'], p.date.strftime(DATE_OUTPUT_FORMAT))
self.assertEqual(tran['due_date'],
p.due_date.strftime(DATE_OUTPUT_FORMAT))
self.assertEqual(tran['total'], str(p.total))
self.assertEqual(tran['paid'], str(p.paid))
self.assertEqual(tran['due'], str(p.due))
row_data = tran['DT_RowData']
self.assertEqual(row_data['pk'], p.pk)
self.assertEqual(row_data['href'], '/purchases/view/' + str(p.pk))
self.assertIsNotNone(d["form"])
def test_default(self):
t = CashBookTransaction.objects.create(
module="PL",
header=1,
line=1,
cash_book=self.cash_book,
value=Decimal(100).quantize(TWO_PLACES),
period=self.period,
date=date(2020,1,31),
type="pp",
ref="123"
)
self.client.force_login(self.user)
# the url is turned into a dict within the enquiry views
# here we start with a dict because it is easier to understand
url_as_dict = {
'draw': '1',
'columns': {
0: {'data': '', 'name': '', 'searchable': 'false', 'orderable': 'false', 'search': {'value': '', 'regex': 'false'}},
1: {'data': 'module', 'name': '', 'searchable': 'true', 'orderable': 'true', 'search': {'value': '', 'regex': 'false'}},
2: {'data': 'header', 'name': '', 'searchable': 'true', 'orderable': 'true', 'search': {'value': '', 'regex': 'false'}},
3: {'data': 'ref', 'name': '', 'searchable': 'true', 'orderable': 'true', 'search': {'value': '', 'regex': 'false'}},
4: {'data': 'cash_book__name', 'name': '', 'searchable': 'true', 'orderable': 'true', 'search': {'value': '', 'regex': 'false'}},
5: {'data': 'period__fy_and_period', 'name': '', 'searchable': 'true', 'orderable': 'true', 'search': {'value': '', 'regex': 'false'}},
6: {'data': 'date', 'name': '', 'searchable': 'true', 'orderable': 'true', 'search': {'value': '', 'regex': 'false'}},
7: {'data': 'total', 'name': '', 'searchable': 'true', 'orderable': 'true', 'search': {'value': '', 'regex': 'false'}}
},
'order': {0: {'column': '1', 'dir': 'asc'}},
'start': '0',
'length': '10',
'search': {'value': '', 'regex': 'false'},
'cash_book': '',
'reference': '',
'total': '',
'period': '',
'start_date': '',
'end_date': '',
'use_adv_search': 'True'
}
q = dict_to_url(url_as_dict)
# would be nice to pass url_as_dict as the data keyword argument to self.client.get
# but django does not deal with the nested dict the way we want
response = self.client.get(
self.url + "?" + q,
HTTP_X_REQUESTED_WITH='XMLHttpRequest'
)
content = response.content.decode("utf")
d = json.loads(content)
self.assertEqual(
d['draw'],
1
)
self.assertEqual(
d['recordsTotal'],
1
)
self.assertEqual(
len(d['data']),
1
)
tran = d['data'][0]
self.assertEqual(
tran['cash_book__name'],
t.cash_book.name
)
self.assertEqual(
tran['ref'],
t.ref
)
self.assertEqual(
tran['period__fy_and_period'],
t.period.fy_and_period[4:] + " " + t.period.fy_and_period[:4]
)
self.assertEqual(
tran['date'],
t.date.strftime(DATE_OUTPUT_FORMAT)
)
self.assertEqual(
tran['total'],
str(t.value)
)
row_data = tran['DT_RowData']
# client uses the module and the DT_RowData pk which is actually the header attribute
self.assertEqual(
row_data['pk'],
t.header
)
self.assertEqual(
row_data['href'],
f'/purchases/view/{t.header}'
)
self.assertIsNotNone(
d["form"]
)
def test_void_not_included(self):
p = PurchaseHeader.objects.create(type="pi",
supplier=self.supplier,
ref="1",
period=self.period,
date=date.today(),
due_date=date.today(),
due=100,
total=100,
paid=0,
status="v")
self.client.force_login(self.user)
# the url is turned into a dict within the enquiry views
# here we start with a dict because it is easier to understand
url_as_dict = {
'draw': '1',
'columns': {
0: {
'data': '',
'name': '',
'searchable': 'false',
'orderable': 'false',
'search': {
'value': '',
'regex': 'false'
}
},
1: {
'data': 'supplier__name',
'name': '',
'searchable': 'true',
'orderable': 'true',
'search': {
'value': '',
'regex': 'false'
}
},
2: {
'data': 'ref',
'name': '',
'searchable': 'true',
'orderable': 'true',
'search': {
'value': '',
'regex': 'false'
}
},
3: {
'data': 'period__fy_and_period',
'name': '',
'searchable': 'true',
'orderable': 'true',
'search': {
'value': '',
'regex': 'false'
}
},
4: {
'data': 'date',
'name': '',
'searchable': 'true',
'orderable': 'true',
'search': {
'value': '',
'regex': 'false'
}
},
5: {
'data': 'due_date',
'name': '',
'searchable': 'true',
'orderable': 'true',
'search': {
'value': '',
'regex': 'false'
}
},
6: {
'data': 'total',
'name': '',
'searchable': 'true',
'orderable': 'true',
'search': {
'value': '',
'regex': 'false'
}
},
7: {
'data': 'paid',
'name': '',
'searchable': 'true',
'orderable': 'true',
'search': {
'value': '',
'regex': 'false'
}
},
8: {
'data': 'due',
'name': '',
'searchable': 'true',
'orderable': 'true',
'search': {
'value': '',
'regex': 'false'
}
}
},
'order': {
0: {
'column': '1',
'dir': 'asc'
}
},
'start': '0',
'length': '10',
'search': {
'value': '',
'regex': 'false'
},
'supplier': '',
'reference': '',
'total': '',
'period': '',
'search_within': 'any',
'start_date': '',
'end_date': '',
'use_adv_search': 'True'
}
q = dict_to_url(url_as_dict)
# would be nice to pass url_as_dict as the data keyword argument to self.client.get
# but django does not deal with the nested dict the way we want
response = self.client.get(self.url + "?" + q,
HTTP_X_REQUESTED_WITH='XMLHttpRequest')
content = response.content.decode("utf")
d = json.loads(content)
self.assertEqual(d['draw'], 1)
self.assertEqual(d['recordsTotal'], 1)
self.assertEqual(len(d['data']), 0)
self.assertIsNotNone(d["form"])