|
Lines 108-114
sub summary {
Link Here
|
| 108 |
{ sum => 'me.amount' }, 'debit.debit_type_code', |
108 |
{ sum => 'me.amount' }, 'debit.debit_type_code', |
| 109 |
'debit_type_code.description' |
109 |
'debit_type_code.description' |
| 110 |
], |
110 |
], |
| 111 |
'as' => [ 'total', 'debit_type_code', 'debit_description' ], |
111 |
'as' => [ 'total', 'debit_type_code', 'debit_description' ], |
| 112 |
order_by => { '-asc' => 'debit_type_code.description' }, |
112 |
order_by => { '-asc' => 'debit_type_code.description' }, |
| 113 |
} |
113 |
} |
| 114 |
); |
114 |
); |
|
Lines 119-136
sub summary {
Link Here
|
| 119 |
'-in' => $payout_transactions->_resultset->get_column( |
119 |
'-in' => $payout_transactions->_resultset->get_column( |
| 120 |
'accountlines_id')->as_query |
120 |
'accountlines_id')->as_query |
| 121 |
}, |
121 |
}, |
| 122 |
'me.credit_id' => { '!=' => undef } |
122 |
'me.credit_id' => { '!=' => undef }, |
|
|
123 |
'account_offsets_credits.debit_id' => { |
| 124 |
'-not_in' => $payout_transactions->_resultset->get_column( |
| 125 |
'accountlines_id')->as_query |
| 126 |
} |
| 123 |
}, |
127 |
}, |
| 124 |
{ |
128 |
{ |
| 125 |
join => { 'credit' => 'credit_type_code' }, |
129 |
join => { |
| 126 |
group_by => |
130 |
'credit' => [ |
| 127 |
[ 'credit.credit_type_code', 'credit_type_code.description' ], |
131 |
'credit_type_code', |
|
|
132 |
{ |
| 133 |
'account_offsets_credits' => |
| 134 |
{ 'debit' => 'debit_type_code' } |
| 135 |
} |
| 136 |
] |
| 137 |
}, |
| 138 |
group_by => [ |
| 139 |
'credit.credit_type_code', 'credit_type_code.description', |
| 140 |
'debit.debit_type_code', 'debit_type_code.description' |
| 141 |
], |
| 128 |
'select' => [ |
142 |
'select' => [ |
| 129 |
{ sum => 'me.amount' }, 'credit.credit_type_code', |
143 |
{ sum => 'me.amount' }, 'credit.credit_type_code', |
| 130 |
'credit_type_code.description' |
144 |
'credit_type_code.description', 'debit.debit_type_code', |
|
|
145 |
'debit_type_code.description' |
| 146 |
], |
| 147 |
'as' => [ |
| 148 |
'total', 'credit_type_code', |
| 149 |
'credit_description', 'debit_type_code', |
| 150 |
'debit_description' |
| 131 |
], |
151 |
], |
| 132 |
'as' => [ 'total', 'credit_type_code', 'credit_description' ], |
152 |
order_by => { |
| 133 |
order_by => { '-asc' => 'credit_type_code.description' }, |
153 |
'-asc' => |
|
|
154 |
[ 'credit_type_code.description', 'debit_type_code.description' ] |
| 155 |
}, |
| 134 |
} |
156 |
} |
| 135 |
); |
157 |
); |
| 136 |
|
158 |
|
|
Lines 146-152
sub summary {
Link Here
|
| 146 |
total => $_->get_column('total') * -1, |
168 |
total => $_->get_column('total') * -1, |
| 147 |
credit_type_code => $_->get_column('credit_type_code'), |
169 |
credit_type_code => $_->get_column('credit_type_code'), |
| 148 |
credit_type => |
170 |
credit_type => |
| 149 |
{ description => $_->get_column('credit_description') } |
171 |
{ description => $_->get_column('credit_description') }, |
|
|
172 |
related_debit => { |
| 173 |
debit_type_code => $_->get_column('debit_type_code'), |
| 174 |
debit_type => |
| 175 |
{ description => $_->get_column('debit_description') } |
| 176 |
} |
| 150 |
} |
177 |
} |
| 151 |
} $payout_summary->as_list; |
178 |
} $payout_summary->as_list; |
| 152 |
|
179 |
|