Lines 112-117
sub cashup_summary {
Link Here
|
112 |
{ |
112 |
{ |
113 |
join => { 'debit' => 'debit_type_code' }, |
113 |
join => { 'debit' => 'debit_type_code' }, |
114 |
group_by => [ 'debit.debit_type_code', 'debit_type_code.description' ], |
114 |
group_by => [ 'debit.debit_type_code', 'debit_type_code.description' ], |
|
|
115 |
order_by => { '-asc' => 'debit.debit_type_code' }, |
115 |
'select' => [ { sum => 'me.amount' }, 'debit.debit_type_code', 'debit_type_code.description' ], |
116 |
'select' => [ { sum => 'me.amount' }, 'debit.debit_type_code', 'debit_type_code.description' ], |
116 |
'as' => [ 'total', 'debit_type_code', 'debit_description' ], |
117 |
'as' => [ 'total', 'debit_type_code', 'debit_description' ], |
117 |
} |
118 |
} |
Lines 126-131
sub cashup_summary {
Link Here
|
126 |
{ |
127 |
{ |
127 |
join => { 'credit' => 'credit_type_code' }, |
128 |
join => { 'credit' => 'credit_type_code' }, |
128 |
group_by => [ 'credit.credit_type_code', 'credit_type_code.description' ], |
129 |
group_by => [ 'credit.credit_type_code', 'credit_type_code.description' ], |
|
|
130 |
order_by => { '-asc' => 'credit.credit_type_code' }, |
129 |
'select' => [ { sum => 'me.amount' }, 'credit.credit_type_code', 'credit_type_code.description' ], |
131 |
'select' => [ { sum => 'me.amount' }, 'credit.credit_type_code', 'credit_type_code.description' ], |
130 |
'as' => [ 'total', 'credit_type_code', 'credit_description' ], |
132 |
'as' => [ 'total', 'credit_type_code', 'credit_description' ], |
131 |
} |
133 |
} |
132 |
- |
|
|