From 26526fa81966352ded1b480138096c39f25523de Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Wed, 19 Apr 2017 10:53:51 -0700 Subject: wordpress plugin, RT#75279 --- FS/FS/ClientAPI/MyAccount.pm | 1 + FS/FS/cust_main.pm | 14 ++++++++++++++ 2 files changed, 15 insertions(+) (limited to 'FS') diff --git a/FS/FS/ClientAPI/MyAccount.pm b/FS/FS/ClientAPI/MyAccount.pm index e69122bcf..807200603 100644 --- a/FS/FS/ClientAPI/MyAccount.pm +++ b/FS/FS/ClientAPI/MyAccount.pm @@ -593,6 +593,7 @@ sub customer_info_short { or return { 'error' => "customer_info_short: unknown custnum $custnum" }; $return{display_custnum} = $cust_main->display_custnum; + $return{max_invnum} = $cust_main->max_invnum; if ( $session->{'pkgnum'} ) { $return{balance} = $cust_main->balance_pkgnum( $session->{'pkgnum'} ); diff --git a/FS/FS/cust_main.pm b/FS/FS/cust_main.pm index 44faa273d..61ecdc8ba 100644 --- a/FS/FS/cust_main.pm +++ b/FS/FS/cust_main.pm @@ -3646,6 +3646,20 @@ sub num_cust_attachments_deleted { ); } +=item max_invnum + +Returns the most recent invnum (invoice number) for this customer. + +=cut + +sub max_invnum { + my $self = shift; + $self->scalar_sql( + " SELECT MAX(invnum) FROM cust_bill WHERE custnum = ?", + $self->custnum + ); +} + =item cust_bill [ OPTION => VALUE... | EXTRA_QSEARCH_PARAMS_HASHREF ] Returns all the invoices (see L) for this customer. -- cgit v1.2.1