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