X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fsearch%2Felements%2Freport_cust_pay_or_refund.html;h=1cc77f728df54dcb598686d6f6f54757f21c3b61;hp=9af4e33dce570aa40e46c84f1ccd165d7ab07ad4;hb=41fc6d0a8aa5921638ac2767265a7528855a5251;hpb=b5c4237a34aef94976bc343c8d9e138664fc3984 diff --git a/httemplate/search/elements/report_cust_pay_or_refund.html b/httemplate/search/elements/report_cust_pay_or_refund.html index 9af4e33dc..1cc77f728 100644 --- a/httemplate/search/elements/report_cust_pay_or_refund.html +++ b/httemplate/search/elements/report_cust_pay_or_refund.html @@ -13,7 +13,7 @@ Examples: ) -<% include('/elements/header.html', $title ) %> +<& /elements/header.html, mt($title) &>
@@ -23,112 +23,150 @@ Examples: - Search options + <% mt('[_1] search options', ucfirst($name_singular)) |h %> + <& /elements/tr-select.html, + label => ucfirst(PL($name_singular)) . ' of type:', + field => 'payby', + options => [ keys %payby ], + labels => \%payby, + multiple => 1, + size => 18, + &> + - <% ucfirst(PL($name_singular)) %> of type: + <% mt('Check #:') |h %> - + - - - - Check #: + <% mt('Transaction #:') |h %> - + - <% include( '/elements/tr-select-agent.html', - 'curr_value' => scalar($cgi->param('agentnum')), - 'label' => 'for agent: ', - 'disable_empty' => 0, - ) - %> - - <% include( '/elements/tr-select-user.html' ) %> + <& /elements/tr-select-user.html &> + +% if ( $has_reason ) { +% # limit to reasons that are in use for the table being reported on +% # (maybe order by count(*) desc?) + <& /elements/tr-select-table.html, + label => emt('Reason'), + field => 'reasonnum', + id => 'reasonnum', + table => 'reason', + name_col => 'reason', + extra_sql => " WHERE EXISTS(SELECT 1 FROM $table WHERE $table.reasonnum = reason.reasonnum) ", + empty_label => emt('any'), + &> +% } - Payment + <% mt(ucfirst($name_singular). ' date') |h %> - <% include( '/elements/tr-input-beginning_ending.html', - layout => 'horiz', - ) - %> + <& /elements/tr-input-beginning_ending.html, + layout => 'horiz', + input_time => $conf->exists('report-cust_pay-select_time'), + &>
% if ( $void ) { - Voided + <% mt('Voided') |h %> - <% include( '/elements/tr-input-beginning_ending.html', + <& /elements/tr-input-beginning_ending.html, prefix => 'void', layout => 'horiz', - ) - %> + &>
% } - <% include( '/elements/tr-input-lessthan_greaterthan.html', - 'label' => 'Amount', - 'field' => 'paid', - ) - %> +% if ( $table eq 'cust_pay' ) { + +% # payment batch +% # <& /elements/tr-select-batchnum.html &> + +% #payment "entry" batch (should probably just all become the same thing) + <& /elements/tr-select-paybatch.html &> + +% } + + <& /elements/tr-input-lessthan_greaterthan.html, + 'label' => emt('Amount'), + 'field' => 'paid', + &> + + + +
+ + + + + + + + + <& /elements/tr-select-agent.html, + 'curr_value' => scalar($cgi->param('agentnum')), + 'label' => emt('Agent'), + 'disable_empty' => 0, + &> + + <& /elements/tr-select-cust_class.html, + 'label' => emt('Customer class'), + 'field' => 'cust_classnum', + 'multiple' => 1, + 'pre_options' => [ 0 => emt('(none)') ], + &> + +
+ <% mt('Customer search options') |h %> +
% if ( $table eq 'cust_pay' ) { - <% include( '/elements/tr-checkbox.html', - 'label' => 'Include tax names', - 'field' => 'tax_names', + +
+ + + + + + + <& /elements/tr-checkbox.html, + 'label' => emt('Include tax names'), + 'field' => 'tax_names', 'value' => 1, - ) - %> -% } + &> + + <& /elements/tr-checkbox.html, + 'label' => emt('Include order number'), + 'field' => 'show_order_number', + 'value' => 1, + &>
+ <% mt('Display options') |h %> +
+% } +
- +
-<% include('/elements/footer.html') %> +<& /elements/footer.html &> <%init> my %opt = @_; @@ -138,6 +176,8 @@ my $name_singular = $opt{'name_singular'}; die "access denied" unless $FS::CurrentUser::CurrentUser->access_right('Financial reports'); +my $conf = new FS::Conf; + my $void = $cgi->param('void') ? 1 : 0; my $unapplied = $cgi->param('unapplied') ? 1 : 0; @@ -146,4 +186,29 @@ my $title = $void ? "Voided $name_singular report" : "\u$name_singular report" ; $table .= '_void' if $void; +my $has_reason = dbdef->table($table)->column('reasonnum'); + +tie (my %payby, 'Tie::IxHash', + 'CARD-VisaMC' => 'credit card (Visa/MasterCard)', + 'CARD-Amex' => 'credit card (American Express)', + 'CARD-Discover' => 'credit card (Discover)', + 'CARD-Maestro' => 'credit card (Maestro/Switch/Solo)', + 'CARD-Tokenized' => 'credit card (Tokenized)', + + 'CHEK' => 'electronic check / ACH', + 'BILL' => 'check', + 'CASH' => 'cash', + 'PPAL' => 'Paypal', + 'APPL' => 'Apple Store', + 'ANRD' => 'Android Market', + + 'PREP' => 'prepaid card', + 'WIRE' => 'wire transfer', + 'WEST' => 'Western Union', + 'IDTP' => 'IDT Payment Services', + 'EDI' => 'Electronic Debit (EDI)', + 'MCRD' => 'manual credit card', + 'MCHK' => 'manual electronic check', +); +