freeside.git
10 years agoFS RT #27208 - using field names specified by ivan for customer / phone in AR aging...
C.J. Adams-Collier [Fri, 12 Sep 2014 21:46:26 +0000 (14:46 -0700)]
FS RT #27208 - using field names specified by ivan for customer / phone in AR aging report

10 years ago28105: factored out units and references to units and defined a bunch of constants...
David Houghton [Thu, 11 Sep 2014 15:20:24 +0000 (11:20 -0400)]
28105: factored out units and references to units and defined a bunch of constants in the head of the file

10 years agoFS RT #27189 - only printing 'each' if package quantity > 1 ; removed now-obsolete...
C.J. Adams-Collier [Thu, 11 Sep 2014 20:14:50 +0000 (13:14 -0700)]
FS RT #27189 - only printing 'each' if package quantity > 1 ; removed now-obsolete checks for pluralization of 'month'

10 years agoFS RT #27208 - adding Mobile phone to FS::ConfDefaults::cust_fields_avail and related...
C.J. Adams-Collier [Thu, 11 Sep 2014 19:12:44 +0000 (12:12 -0700)]
FS RT #27208 - adding Mobile phone to FS::ConfDefaults::cust_fields_avail and related FS::UI::Web::cust_header / ::cust_sql_fields

10 years agoticket: 27309; use dbh->quote
David Houghton [Wed, 10 Sep 2014 20:54:37 +0000 (16:54 -0400)]
ticket: 27309; use dbh->quote

Sorry, I shouldn't have missed this. I've gotten used to using either
DBIx::Class to construct queries for me or using whole prepared statements,
which handle the quoting automagically.  I've gotten out of practice with
SQL created piecemeal.

10 years agoMerge branch 'master' of git+ssh://git.freeside.biz/home/git/freeside
David Houghton [Wed, 10 Sep 2014 19:54:31 +0000 (15:54 -0400)]
Merge branch 'master' of git+ssh://git.freeside.biz/home/git/freeside

Making my local master match the remote.

10 years agoticket: 28287; adding parens to sprintf
David Houghton [Wed, 10 Sep 2014 19:52:31 +0000 (15:52 -0400)]
ticket: 28287; adding parens to sprintf

Mark didn't like the sprintf without parens, so I'm fixing it.

10 years agounbreak cust_main search, fallout from cust_payby work, #23741
Mark Wells [Wed, 10 Sep 2014 19:52:14 +0000 (12:52 -0700)]
unbreak cust_main search, fallout from cust_payby work, #23741

10 years agodebugging aid
Mark Wells [Wed, 10 Sep 2014 05:34:28 +0000 (22:34 -0700)]
debugging aid

10 years agoticket: 27309; add accountcode
David Houghton [Wed, 10 Sep 2014 16:09:40 +0000 (12:09 -0400)]
ticket: 27309; add accountcode

I tested this as best I could. I worked with my fake data. I accounted
for ' and blank lines, assuming terminal whitespace was irrelevant.

10 years agoticket: 28287; rolling back mystery deletion
David Houghton [Wed, 10 Sep 2014 14:16:54 +0000 (10:16 -0400)]
ticket: 28287; rolling back mystery deletion

I'm not sure how these two lines got ditched, but they're back.

10 years agoaltered FS::UI::Web::cust_sort_fields() and cust_sql_fields() so that ->param('cust_f...
C.J. Adams-Collier [Wed, 10 Sep 2014 00:42:19 +0000 (17:42 -0700)]
altered FS::UI::Web::cust_sort_fields() and cust_sql_fields() so that ->param('cust_fields') argument is no longer required
when the parameter is not passed, the initial value previously passed to cust_header() is used
if @cust_fields is empty, cust_header() is called with no arguments

10 years agocalling FS::UI::Web::cust_sql_fields() with ->param('cust_fields'); reduced number...
C.J. Adams-Collier [Wed, 10 Sep 2014 00:18:41 +0000 (17:18 -0700)]
calling FS::UI::Web::cust_sql_fields() with ->param('cust_fields'); reduced number of calls to FS::UI::Web::cust_header() by 3 in this component

10 years agorepaired a compile error I caused in cust_main_dayranges.html
C.J. Adams-Collier [Tue, 9 Sep 2014 23:53:13 +0000 (16:53 -0700)]
repaired a compile error I caused in cust_main_dayranges.html

10 years agopayment history reverse order balance quirk with two check payments in same batch...
Ivan Kohler [Tue, 9 Sep 2014 22:31:09 +0000 (15:31 -0700)]
payment history reverse order balance quirk with two check payments in same batch, RT#30309

10 years agoticket: 28287; add undiscounted monthly amount
David Houghton [Tue, 9 Sep 2014 20:46:29 +0000 (16:46 -0400)]
ticket: 28287; add undiscounted monthly amount

I figured this need only parallel the discount report. That is, the discount
only is reported and applied if the period of recurrence is some whole number
of months. From my exploration of discounts it appeared that one could specify
discounts for other periods, but they did not appear on invoices.

10 years agohave expanded the AR aging summary to include other fields. Have not yet populated...
C.J. Adams-Collier [Tue, 9 Sep 2014 20:16:21 +0000 (13:16 -0700)]
have expanded the AR aging summary to include other fields.  Have not yet populated the fields.  FS RT #27208

10 years ago#29052 Pass domain to Aradial
Jeremy Davis [Tue, 9 Sep 2014 19:47:22 +0000 (15:47 -0400)]
#29052 Pass domain to Aradial

10 years ago#29052 Fix Aradial replace operations
Jeremy Davis [Tue, 9 Sep 2014 16:48:50 +0000 (12:48 -0400)]
#29052 Fix Aradial replace operations

10 years ago#29052 Fix Aradial user deletion
Jeremy Davis [Tue, 9 Sep 2014 16:34:28 +0000 (12:34 -0400)]
#29052 Fix Aradial user deletion

10 years agomoved WHERE/AND logic in to calling code. FS RT #884
C.J. Adams-Collier [Mon, 8 Sep 2014 21:14:20 +0000 (14:14 -0700)]
moved WHERE/AND logic in to calling code.  FS RT #884

10 years agoensuring that WHERE or AND is correctly used in "$extra_sql" snippit - FS RT #884
C.J. Adams-Collier [Mon, 8 Sep 2014 20:25:10 +0000 (13:25 -0700)]
ensuring that WHERE or AND is correctly used in "$extra_sql" snippit - FS RT #884

10 years agofor one-time discounts, print line item in different format - FS RT #27189
C.J. Adams-Collier [Mon, 8 Sep 2014 18:56:13 +0000 (11:56 -0700)]
for one-time discounts, print line item in different format - FS RT #27189

10 years agocorrected POD syntax which was causing error
C.J. Adams-Collier [Mon, 8 Sep 2014 18:56:53 +0000 (11:56 -0700)]
corrected POD syntax which was causing error

10 years ago#29053 -d needs to pass an argument
Jeremy Davis [Mon, 8 Sep 2014 19:17:13 +0000 (15:17 -0400)]
#29053 -d needs to pass an argument

10 years ago#14049 Fix error
Jeremy Davis [Mon, 8 Sep 2014 14:12:14 +0000 (10:12 -0400)]
#14049 Fix error

10 years agobetter error page when re-emailing bad addresses or other SMTP errorsm, RT#25834
Ivan Kohler [Sat, 6 Sep 2014 21:47:01 +0000 (14:47 -0700)]
better error page when re-emailing bad addresses or other SMTP errorsm, RT#25834

10 years agodouble process / back button protection for self-service payments, RT#29168
Ivan Kohler [Sat, 6 Sep 2014 21:35:53 +0000 (14:35 -0700)]
double process / back button protection for self-service payments, RT#29168

10 years agoadd invnum to payment import, RT#29673
Ivan Kohler [Sat, 6 Sep 2014 01:22:46 +0000 (18:22 -0700)]
add invnum to payment import, RT#29673

10 years agocompat with old Pg used for RADIUS: use str2time_sql_closing
Ivan Kohler [Sat, 6 Sep 2014 00:21:45 +0000 (17:21 -0700)]
compat with old Pg used for RADIUS: use str2time_sql_closing

10 years agoshow Calling-Station-Id on RADIUS reports (as a MAC address w/vendor), RT#29154
Ivan Kohler [Sat, 6 Sep 2014 00:19:24 +0000 (17:19 -0700)]
show Calling-Station-Id on RADIUS reports (as a MAC address w/vendor), RT#29154

10 years agoMerge branch 'master' of git.freeside.biz:/home/git/freeside
Ivan Kohler [Fri, 5 Sep 2014 18:45:48 +0000 (11:45 -0700)]
Merge branch 'master' of git.freeside.biz:/home/git/freeside

10 years agoFS RT #884; correcting date comparison logic for signup by date report
C.J. Adams-Collier [Fri, 5 Sep 2014 17:17:16 +0000 (10:17 -0700)]
FS RT #884; correcting date comparison logic for signup by date report

10 years agothe two necessary changes to get Cable to show up in the history table
David Houghton [Fri, 5 Sep 2014 17:17:15 +0000 (13:17 -0400)]
the two necessary changes to get Cable to show up in the history table

10 years ago#14049 fix regex
Jeremy Davis [Fri, 5 Sep 2014 16:01:09 +0000 (12:01 -0400)]
#14049 fix regex

10 years ago#14049 Add default area code for 7 digit numbers
Jeremy Davis [Fri, 5 Sep 2014 15:41:26 +0000 (11:41 -0400)]
#14049 Add default area code for 7 digit numbers

10 years ago#29052 Aradial provisioning change of path
Jeremy Davis [Fri, 5 Sep 2014 14:52:13 +0000 (10:52 -0400)]
#29052 Aradial provisioning change of path

10 years agocredit
Ivan Kohler [Fri, 5 Sep 2014 06:59:36 +0000 (23:59 -0700)]
credit

10 years agodon't try to download the -d done dir, RT#29053
Ivan Kohler [Fri, 5 Sep 2014 05:04:16 +0000 (22:04 -0700)]
don't try to download the -d done dir, RT#29053

10 years agofix for lack of input validation - RT#15405
C.J. Adams-Collier [Fri, 5 Sep 2014 00:24:49 +0000 (17:24 -0700)]
fix for lack of input validation - RT#15405

10 years agoFS RT #884 code review recommendations per mwells
C.J. Adams-Collier [Wed, 3 Sep 2014 22:24:58 +0000 (15:24 -0700)]
FS RT #884 code review recommendations per mwells

10 years agoFS RT ticket #884
C.J. Adams-Collier [Wed, 3 Sep 2014 19:21:43 +0000 (12:21 -0700)]
FS RT ticket #884

10 years agoadd customer code field, #14049
Mark Wells [Wed, 3 Sep 2014 18:51:07 +0000 (11:51 -0700)]
add customer code field, #14049

10 years ago#30315 Fixing sales2agent
Jeremy Davis [Wed, 3 Sep 2014 14:56:25 +0000 (10:56 -0400)]
#30315 Fixing sales2agent

10 years agoMerge branch 'h_cust_main_index_fix' of https://github.com/Jayceh/Freeside
Ivan Kohler [Tue, 2 Sep 2014 22:22:56 +0000 (15:22 -0700)]
Merge branch 'h_cust_main_index_fix' of https://github.com/Jayceh/Freeside

10 years agoduh, user, not username
Jason (Jayce^) Hall [Tue, 2 Sep 2014 19:29:33 +0000 (13:29 -0600)]
duh, user, not username

10 years agoMerge branch 'h_cust_main_index_fix' of https://github.com/Jayceh/Freeside
Ivan Kohler [Tue, 2 Sep 2014 17:21:15 +0000 (10:21 -0700)]
Merge branch 'h_cust_main_index_fix' of https://github.com/Jayceh/Freeside

10 years agofix new installs vs. FKs, RT#13971
Ivan Kohler [Tue, 2 Sep 2014 17:16:12 +0000 (10:16 -0700)]
fix new installs vs. FKs, RT#13971

10 years agoAdd in history_usernum and history_username indices. This allows for
Jason (Jayce^) Hall [Tue, 2 Sep 2014 17:00:08 +0000 (11:00 -0600)]
Add in history_usernum and history_username indices. This allows for
searches on *who* made changes to run faster. The best example of this
is on the homepage when it looks for the last modified customers by the
current user. On our system that query could take 5 minutes across so
many history records. Now takes a manageable amount of time with this
index

10 years agoallow - in user pref email, RT#30664
Ivan Kohler [Tue, 2 Sep 2014 15:42:19 +0000 (08:42 -0700)]
allow - in user pref email, RT#30664

10 years agofix inserts and don't generate extra noise on trailing blanks, RT#29053
Ivan Kohler [Sun, 31 Aug 2014 20:11:33 +0000 (13:11 -0700)]
fix inserts and don't generate extra noise on trailing blanks, RT#29053

10 years agoenable CCH update to remove tax classes, #30670
Mark Wells [Sun, 31 Aug 2014 01:20:52 +0000 (18:20 -0700)]
enable CCH update to remove tax classes, #30670

10 years agodoc
Ivan Kohler [Sat, 30 Aug 2014 22:02:36 +0000 (15:02 -0700)]
doc

10 years agoconvert sales persons to agents, R#30315
Ivan Kohler [Sat, 30 Aug 2014 22:01:08 +0000 (15:01 -0700)]
convert sales persons to agents, R#30315

10 years ago#30616 Fix AU toll-free
Jeremy Davis [Thu, 28 Aug 2014 16:11:20 +0000 (12:11 -0400)]
#30616 Fix AU toll-free

10 years ago3.x upgrade vs. tax-pkg_address, #30413
Mark Wells [Wed, 27 Aug 2014 04:38:13 +0000 (23:38 -0500)]
3.x upgrade vs. tax-pkg_address, #30413

10 years agofix js quirk, #30643, #24047
Mark Wells [Mon, 25 Aug 2014 23:33:38 +0000 (16:33 -0700)]
fix js quirk, #30643, #24047

10 years ago3.x upgrade needs to deal with more than one cust_main_exemption per customer, #30413
Mark Wells [Fri, 22 Aug 2014 00:54:58 +0000 (19:54 -0500)]
3.x upgrade needs to deal with more than one cust_main_exemption per customer, #30413

10 years agobootstrap users with passwords
Ivan Kohler [Thu, 21 Aug 2014 22:46:17 +0000 (15:46 -0700)]
bootstrap users with passwords

10 years agort 4.0.21 (RT#13852)
Ivan Kohler [Thu, 21 Aug 2014 07:48:07 +0000 (00:48 -0700)]
rt 4.0.21 (RT#13852)

10 years agohow Calling-Station-Id on RADIUS reports (as a MAC address w/vendor), RT#29154
Ivan Kohler [Thu, 21 Aug 2014 07:35:26 +0000 (00:35 -0700)]
how Calling-Station-Id on RADIUS reports (as a MAC address w/vendor), RT#29154

10 years agoat least document it to fix later
Ivan Kohler [Thu, 21 Aug 2014 07:33:54 +0000 (00:33 -0700)]
at least document it to fix later

10 years agodoc
Ivan Kohler [Thu, 21 Aug 2014 07:33:21 +0000 (00:33 -0700)]
doc

10 years agopod
Ivan Kohler [Thu, 21 Aug 2014 07:32:40 +0000 (00:32 -0700)]
pod

10 years agodoc
Ivan Kohler [Thu, 21 Aug 2014 07:32:10 +0000 (00:32 -0700)]
doc

10 years agowhitespace
Ivan Kohler [Thu, 21 Aug 2014 07:31:08 +0000 (00:31 -0700)]
whitespace

10 years agobetter error
Ivan Kohler [Thu, 21 Aug 2014 07:30:38 +0000 (00:30 -0700)]
better error

10 years agofull backtrace
Ivan Kohler [Thu, 21 Aug 2014 07:29:13 +0000 (00:29 -0700)]
full backtrace

10 years agoextraneous example comments
Ivan Kohler [Thu, 21 Aug 2014 07:28:36 +0000 (00:28 -0700)]
extraneous example comments

10 years agodoc
Ivan Kohler [Thu, 21 Aug 2014 07:27:31 +0000 (00:27 -0700)]
doc

10 years agocleanup
Ivan Kohler [Thu, 21 Aug 2014 07:27:19 +0000 (00:27 -0700)]
cleanup

10 years agoallow any text for log context
Ivan Kohler [Thu, 21 Aug 2014 07:18:45 +0000 (00:18 -0700)]
allow any text for log context

10 years agofix company_logo link under RT, RT#28457
Ivan Kohler [Thu, 21 Aug 2014 07:13:22 +0000 (00:13 -0700)]
fix company_logo link under RT, RT#28457

10 years ago#30518 Add 011 to international calls
Jeremy Davis [Fri, 25 Jul 2014 10:41:30 +0000 (06:41 -0400)]
#30518 Add 011 to international calls

10 years agouser pref for # of customers on dashboard, RT#29794
Ivan Kohler [Sun, 17 Aug 2014 23:26:41 +0000 (16:26 -0700)]
user pref for # of customers on dashboard, RT#29794

10 years agoMerge branch 'master' of git.freeside.biz:/home/git/freeside
Ivan Kohler [Sun, 17 Aug 2014 22:38:22 +0000 (15:38 -0700)]
Merge branch 'master' of git.freeside.biz:/home/git/freeside

10 years agocleanup
Ivan Kohler [Sun, 17 Aug 2014 22:38:19 +0000 (15:38 -0700)]
cleanup

10 years agoshow last Calling-Station-Id on RADIUS summary, RT#29154
Ivan Kohler [Sun, 17 Aug 2014 22:37:12 +0000 (15:37 -0700)]
show last Calling-Station-Id on RADIUS summary, RT#29154

10 years agoSNMP export: allow manually entering OIDs, #20945
Mark Wells [Fri, 15 Aug 2014 23:08:24 +0000 (16:08 -0700)]
SNMP export: allow manually entering OIDs, #20945

10 years agoadjust calculation of upload date, #20384
Mark Wells [Fri, 15 Aug 2014 03:14:55 +0000 (20:14 -0700)]
adjust calculation of upload date, #20384

10 years agoand show the warning in the batch-fixed_format case, #20384
Mark Wells [Fri, 15 Aug 2014 02:48:28 +0000 (19:48 -0700)]
and show the warning in the batch-fixed_format case, #20384

10 years agoadjust EFT Canada processing delay based on time of day, and warn the user, #20384
Mark Wells [Fri, 15 Aug 2014 02:42:39 +0000 (19:42 -0700)]
adjust EFT Canada processing delay based on time of day, and warn the user, #20384

10 years agoavoid counting location-changed packages in total canceled packages
Mark Wells [Thu, 14 Aug 2014 02:19:18 +0000 (19:19 -0700)]
avoid counting location-changed packages in total canceled packages

10 years agopopup view for collapsed packages, #25130, #27305
Mark Wells [Tue, 12 Aug 2014 23:52:09 +0000 (16:52 -0700)]
popup view for collapsed packages, #25130, #27305

10 years agosvc_cable unique serialnum and mac_addr, RT#
Ivan Kohler [Tue, 12 Aug 2014 23:41:11 +0000 (16:41 -0700)]
svc_cable unique serialnum and mac_addr, RT#

10 years agoagent wholesale bulk billing: respect date_format setting for details, RT#30484
Ivan Kohler [Tue, 12 Aug 2014 22:31:00 +0000 (15:31 -0700)]
agent wholesale bulk billing: respect date_format setting for details, RT#30484

10 years agofix router/block unlinking, #29829, from #20742
Mark Wells [Tue, 12 Aug 2014 20:46:44 +0000 (13:46 -0700)]
fix router/block unlinking, #29829, from #20742

10 years ago477 tweaks, #24047
Mark Wells [Tue, 12 Aug 2014 19:59:36 +0000 (12:59 -0700)]
477 tweaks, #24047

10 years agofix log contexts, RT#30238
Ivan Kohler [Tue, 12 Aug 2014 19:39:02 +0000 (12:39 -0700)]
fix log contexts, RT#30238

10 years agoimprove convert-477-options script, #24047
Mark Wells [Tue, 12 Aug 2014 19:31:28 +0000 (12:31 -0700)]
improve convert-477-options script, #24047

10 years agofix log contexts, RT#30238
Ivan Kohler [Tue, 12 Aug 2014 19:28:45 +0000 (12:28 -0700)]
fix log contexts, RT#30238

10 years agofix status page
Ivan Kohler [Tue, 12 Aug 2014 04:38:18 +0000 (21:38 -0700)]
fix status page

10 years agofix status page
Ivan Kohler [Tue, 12 Aug 2014 04:36:32 +0000 (21:36 -0700)]
fix status page

10 years agofix status page
Ivan Kohler [Tue, 12 Aug 2014 04:32:34 +0000 (21:32 -0700)]
fix status page

10 years agodoc line got out of place
Ivan Kohler [Tue, 12 Aug 2014 02:09:39 +0000 (19:09 -0700)]
doc line got out of place

10 years agosome more status info for CDR processing
Ivan Kohler [Sun, 10 Aug 2014 21:17:40 +0000 (14:17 -0700)]
some more status info for CDR processing

10 years agoadditional debugging/profiling info for billing, RT#30238
Ivan Kohler [Sun, 10 Aug 2014 21:14:10 +0000 (14:14 -0700)]
additional debugging/profiling info for billing, RT#30238

10 years agoadditional debugging/profiling info for billing, RT#30238
Ivan Kohler [Sun, 10 Aug 2014 21:04:16 +0000 (14:04 -0700)]
additional debugging/profiling info for billing, RT#30238

10 years agoquiet overzealous debugging
Ivan Kohler [Sun, 10 Aug 2014 20:43:47 +0000 (13:43 -0700)]
quiet overzealous debugging

10 years agotyop
Ivan Kohler [Sun, 10 Aug 2014 20:21:03 +0000 (13:21 -0700)]
tyop