def compare_result_for_customer_group(self):
filters = {
'doc_type': 'Sales Order',
'range': 'Monthly',
'to_date': '2018-03-31',
'tree_type': 'Customer Group',
'company': '_Test Company 2',
'from_date': '2017-04-01',
'value_quantity': 'Value'
}
report = execute(filters)
expected_first_row = {
"entity": "All Customer Groups",
"indent": 0,
"apr_2017": 0.0,
"may_2017": 0.0,
"jun_2017": 2000.0,
"jul_2017": 1000.0,
"aug_2017": 0.0,
"sep_2017": 1500.0,
"oct_2017": 1000.0,
"nov_2017": 0.0,
"dec_2017": 0.0,
"jan_2018": 0.0,
"feb_2018": 2000.0,
"mar_2018": 0.0,
"total":7500.0
}
self.assertEqual(expected_first_row, report[1][0])
def compare_result_for_customer_group(self):
filters = {
'doc_type': 'Sales Order',
'range': 'Monthly',
'to_date': '2018-03-31',
'tree_type': 'Customer Group',
'company': '_Test Company 2',
'from_date': '2017-04-01',
'value_quantity': 'Value'
}
report = execute(filters)
expected_first_row = {
"entity": "All Customer Groups",
"indent": 0,
"apr_2017": 0.0,
"may_2017": 0.0,
"jun_2017": 2000.0,
"jul_2017": 1000.0,
"aug_2017": 0.0,
"sep_2017": 1500.0,
"oct_2017": 1000.0,
"nov_2017": 0.0,
"dec_2017": 0.0,
"jan_2018": 0.0,
"feb_2018": 2000.0,
"mar_2018": 0.0,
"total":7500.0
}
self.assertEqual(expected_first_row, report[1][0])
def compare_result_for_customer(self):
filters = {
'doc_type': 'Sales Order',
'range': 'Monthly',
'to_date': '2018-03-31',
'tree_type': 'Customer',
'company': '_Test Company 2',
'from_date': '2017-04-01',
'value_quantity': 'Value'
}
report = execute(filters)
expected_data = [
{
"entity": "_Test Customer 1",
"entity_name": "_Test Customer 1",
"apr_2017": 0.0,
"may_2017": 0.0,
"jun_2017": 0.0,
"jul_2017": 0.0,
"aug_2017": 0.0,
"oct_2017": 0.0,
"sep_2017": 0.0,
"nov_2017": 0.0,
"dec_2017": 0.0,
"jan_2018": 0.0,
"feb_2018": 2000.0,
"mar_2018": 0.0,
"total":2000.0
},
{
"entity": "_Test Customer 2",
"entity_name": "_Test Customer 2",
"apr_2017": 0.0,
"may_2017": 0.0,
"jun_2017": 0.0,
"jul_2017": 0.0,
"aug_2017": 0.0,
"sep_2017": 1500.0,
"oct_2017": 1000.0,
"nov_2017": 0.0,
"dec_2017": 0.0,
"jan_2018": 0.0,
"feb_2018": 0.0,
"mar_2018": 0.0,
"total":2500.0
},
{
"entity": "_Test Customer 3",
"entity_name": "_Test Customer 3",
"apr_2017": 0.0,
"may_2017": 0.0,
"jun_2017": 2000.0,
"jul_2017": 1000.0,
"aug_2017": 0.0,
"sep_2017": 0.0,
"oct_2017": 0.0,
"nov_2017": 0.0,
"dec_2017": 0.0,
"jan_2018": 0.0,
"feb_2018": 0.0,
"mar_2018": 0.0,
"total": 3000.0
}
]
result = sorted(report[1], key=lambda k: k['entity'])
self.assertEqual(expected_data, result)
def compare_result_for_customer_based_on_quantity(self):
filters = {
'doc_type': 'Sales Order',
'range': 'Monthly',
'to_date': '2018-03-31',
'tree_type': 'Customer',
'company': '_Test Company 2',
'from_date': '2017-04-01',
'value_quantity': 'Quantity'
}
report = execute(filters)
expected_data = [{
'entity': 'Total',
'apr_2017': 0.0,
'may_2017': 0.0,
'jun_2017': 20.0,
'jul_2017': 10.0,
'aug_2017': 0.0,
'sep_2017': 15.0,
'oct_2017': 10.0,
'nov_2017': 0.0,
'dec_2017': 0.0,
'jan_2018': 0.0,
'feb_2018': 20.0,
'mar_2018': 0.0
}, {
"entity": "_Test Customer 1",
"entity_name": "_Test Customer 1",
'city': None,
'sales_partner': None,
"apr_2017": 0.0,
"may_2017": 0.0,
"jun_2017": 0.0,
"jul_2017": 0.0,
"aug_2017": 0.0,
"sep_2017": 0.0,
"oct_2017": 0.0,
"nov_2017": 0.0,
"dec_2017": 0.0,
"jan_2018": 0.0,
"feb_2018": 20.0,
"mar_2018": 0.0,
"total": 20.0
}, {
"entity": "_Test Customer 2",
"entity_name": "_Test Customer 2",
'city': None,
'sales_partner': None,
"apr_2017": 0.0,
"may_2017": 0.0,
"jun_2017": 0.0,
"jul_2017": 0.0,
"aug_2017": 0.0,
"sep_2017": 15.0,
"oct_2017": 10.0,
"nov_2017": 0.0,
"dec_2017": 0.0,
"jan_2018": 0.0,
"feb_2018": 0.0,
"mar_2018": 0.0,
"total": 25.0
}, {
"entity": "_Test Customer 3",
"entity_name": "_Test Customer 3",
'city': None,
'sales_partner': None,
"apr_2017": 0.0,
"may_2017": 0.0,
"jun_2017": 20.0,
"jul_2017": 10.0,
"aug_2017": 0.0,
"sep_2017": 0.0,
"oct_2017": 0.0,
"nov_2017": 0.0,
"dec_2017": 0.0,
"jan_2018": 0.0,
"feb_2018": 0.0,
"mar_2018": 0.0,
"total": 30.0
}]
result = sorted(report[1], key=lambda k: k['entity'])
self.assertEqual(expected_data, result)
def compare_result_for_customer(self):
filters = {
'doc_type': 'Sales Order',
'range': 'Monthly',
'to_date': '2018-03-31',
'tree_type': 'Customer',
'company': '_Test Company 2',
'from_date': '2017-04-01',
'value_quantity': 'Value'
}
report = execute(filters)
expected_data = [
{
"entity": "_Test Customer 1",
"entity_name": "_Test Customer 1",
"apr_2017": 0.0,
"may_2017": 0.0,
"jun_2017": 0.0,
"jul_2017": 0.0,
"aug_2017": 0.0,
"oct_2017": 0.0,
"sep_2017": 0.0,
"nov_2017": 0.0,
"dec_2017": 0.0,
"jan_2018": 0.0,
"feb_2018": 2000.0,
"mar_2018": 0.0,
"total":2000.0
},
{
"entity": "_Test Customer 2",
"entity_name": "_Test Customer 2",
"apr_2017": 0.0,
"may_2017": 0.0,
"jun_2017": 0.0,
"jul_2017": 0.0,
"aug_2017": 0.0,
"sep_2017": 1500.0,
"oct_2017": 1000.0,
"nov_2017": 0.0,
"dec_2017": 0.0,
"jan_2018": 0.0,
"feb_2018": 0.0,
"mar_2018": 0.0,
"total":2500.0
},
{
"entity": "_Test Customer 3",
"entity_name": "_Test Customer 3",
"apr_2017": 0.0,
"may_2017": 0.0,
"jun_2017": 2000.0,
"jul_2017": 1000.0,
"aug_2017": 0.0,
"sep_2017": 0.0,
"oct_2017": 0.0,
"nov_2017": 0.0,
"dec_2017": 0.0,
"jan_2018": 0.0,
"feb_2018": 0.0,
"mar_2018": 0.0,
"total": 3000.0
}
]
result = sorted(report[1], key=lambda k: k['entity'])
self.assertEqual(expected_data, result)
