freeside.git
15 years agooptimize total query in receivables report. very significant speedup for large DBs
ivan [Wed, 25 Jun 2008 20:14:00 +0000 (20:14 +0000)]
optimize total query in receivables report.  very significant speedup for large DBs

15 years agodon't show error messages about FreesideStatus index already existing either
ivan [Wed, 25 Jun 2008 18:14:51 +0000 (18:14 +0000)]
don't show error messages about FreesideStatus index already existing either

15 years agofinish adding str2time_sql_closing
ivan [Wed, 25 Jun 2008 00:29:31 +0000 (00:29 +0000)]
finish adding str2time_sql_closing

15 years agopostal invoice fees
jeff [Tue, 24 Jun 2008 16:39:10 +0000 (16:39 +0000)]
postal invoice fees

15 years agoprevent decrementing time/bandwidth for old RADIUS records
ivan [Tue, 24 Jun 2008 02:09:38 +0000 (02:09 +0000)]
prevent decrementing time/bandwidth for old RADIUS records

15 years agoinvoice service address modifications
jeff [Mon, 23 Jun 2008 15:36:25 +0000 (15:36 +0000)]
invoice service address modifications

15 years agoadding report on legacy tax exemptions to assist in enet migraiton
ivan [Mon, 23 Jun 2008 00:41:08 +0000 (00:41 +0000)]
adding report on legacy tax exemptions to assist in enet migraiton

15 years agolegacy tax exemption report fix, no _date
ivan [Mon, 23 Jun 2008 00:37:08 +0000 (00:37 +0000)]
legacy tax exemption report fix, no _date

15 years agoadding report on legacy tax exemptions to assist in enet migraiton
ivan [Mon, 23 Jun 2008 00:34:26 +0000 (00:34 +0000)]
adding report on legacy tax exemptions to assist in enet migraiton

15 years agobackport freeside-dbdef-create from HEAD
ivan [Sat, 21 Jun 2008 20:07:06 +0000 (20:07 +0000)]
backport freeside-dbdef-create from HEAD

15 years agoextra values for invoices
jeff [Fri, 20 Jun 2008 05:47:19 +0000 (05:47 +0000)]
extra values for invoices

15 years agoVoxLineSystems are lying scum who charged back their customization work and then...
ivan [Fri, 20 Jun 2008 03:36:36 +0000 (03:36 +0000)]
VoxLineSystems are lying scum who charged back their customization work and then used the software anyway

15 years agoabout time everything defaulted to apache2
ivan [Fri, 20 Jun 2008 03:13:14 +0000 (03:13 +0000)]
about time everything defaulted to apache2

15 years agowelcome to the future already. default to apache 2
ivan [Fri, 20 Jun 2008 03:00:18 +0000 (03:00 +0000)]
welcome to the future already.  default to apache 2

15 years agofix regression caused by use of IPC::Run to run pslatex: send STDOUT and STDERR from...
ivan [Wed, 18 Jun 2008 21:18:41 +0000 (21:18 +0000)]
fix regression caused by use of IPC::Run to run pslatex: send STDOUT and STDERR from pslatex to /dev/null, we don't want them

15 years agoand lastly, add select-cust_main-status.html to _1_7_BRANCH
ivan [Wed, 18 Jun 2008 05:27:15 +0000 (05:27 +0000)]
and lastly, add select-cust_main-status.html to _1_7_BRANCH

15 years agobackport cust_main::statuses from HEAD for /elements/tr-select-cust_main-statuses...
ivan [Wed, 18 Jun 2008 05:23:56 +0000 (05:23 +0000)]
backport cust_main::statuses from HEAD for /elements/tr-select-cust_main-statuses.html

15 years agosomehow missed tr-select-cust_main-status.html on _1_7_BRANCH
ivan [Wed, 18 Jun 2008 05:18:25 +0000 (05:18 +0000)]
somehow missed tr-select-cust_main-status.html on _1_7_BRANCH

15 years agothis module, also, has no need to import qsearch/qsearchs, and is causing dependency...
ivan [Wed, 18 Jun 2008 00:49:12 +0000 (00:49 +0000)]
this module, also, has no need to import qsearch/qsearchs, and is causing dependency loop problems (Record->part_virtual_field->Record)

15 years agoREALLY, don't use FS::Conf from Msgcat until runtime... should hopefully FINALLY...
ivan [Wed, 18 Jun 2008 00:42:39 +0000 (00:42 +0000)]
REALLY, don't use FS::Conf from Msgcat until runtime... should hopefully FINALLY eliminate the Record->Msgcat->Conf->Record loop

15 years agomsgcat.pm doesn't actually need qsearch/qsearchs... hopefully this is the last of...
ivan [Wed, 18 Jun 2008 00:36:52 +0000 (00:36 +0000)]
msgcat.pm doesn't actually need qsearch/qsearchs... hopefully this is the last of the weird dependency loops (this one is Record->Msgcat->msgcat->Record)

15 years agofixup damage from quantity addition
jeff [Tue, 17 Jun 2008 19:30:07 +0000 (19:30 +0000)]
fixup damage from quantity addition

15 years agocredits for FCKeditor on _1_7_BRANCH
ivan [Tue, 17 Jun 2008 04:03:13 +0000 (04:03 +0000)]
credits for FCKeditor on _1_7_BRANCH

15 years agoadding fckeditor on _17_BRANCH, for customer notices
ivan [Tue, 17 Jun 2008 03:58:49 +0000 (03:58 +0000)]
adding fckeditor on _17_BRANCH, for customer notices

15 years agofinish adding a feature to easily list all email addresses for an agent & send them...
ivan [Tue, 17 Jun 2008 03:36:10 +0000 (03:36 +0000)]
finish adding a feature to easily list all email addresses for an agent & send them email

15 years agonot forgetting to add fax and old customer id
jeff [Tue, 17 Jun 2008 03:13:51 +0000 (03:13 +0000)]
not forgetting to add fax and old customer id

15 years agohave agent_custid editing now
ivan [Tue, 17 Jun 2008 01:44:00 +0000 (01:44 +0000)]
have agent_custid editing now

15 years agomissing stuff from HEAD
ivan [Mon, 16 Jun 2008 07:04:43 +0000 (07:04 +0000)]
missing stuff from HEAD

15 years agoadd (with config) ability to edit agent_custid
ivan [Mon, 16 Jun 2008 06:53:50 +0000 (06:53 +0000)]
add (with config) ability to edit agent_custid

15 years agofix visual regression not displaying package and comment on date editing
ivan [Thu, 12 Jun 2008 23:15:58 +0000 (23:15 +0000)]
fix visual regression not displaying package and comment on date editing

15 years agostart of better error reporting for RADIUS upgrade errors
ivan [Tue, 10 Jun 2008 23:26:15 +0000 (23:26 +0000)]
start of better error reporting for RADIUS upgrade errors

15 years agostart of better error reporting for RADIUS upgrade errors
ivan [Tue, 10 Jun 2008 23:24:17 +0000 (23:24 +0000)]
start of better error reporting for RADIUS upgrade errors

15 years agoturn off debugging that got left on by accident
ivan [Tue, 10 Jun 2008 17:39:21 +0000 (17:39 +0000)]
turn off debugging that got left on by accident

15 years agofix up application of things to refunds, RT#3606/RT#3545
ivan [Tue, 10 Jun 2008 02:15:17 +0000 (02:15 +0000)]
fix up application of things to refunds, RT#3606/RT#3545

15 years agoremove name from voxlinesystems2, really
ivan [Mon, 9 Jun 2008 18:32:28 +0000 (18:32 +0000)]
remove name from voxlinesystems2, really

15 years ago1.7 needed money_typen
ivan [Fri, 6 Jun 2008 00:10:50 +0000 (00:10 +0000)]
1.7 needed money_typen

15 years agoadd am/pm to voxlinesystems2 display format, remove name, revsere src/dst
ivan [Thu, 5 Jun 2008 22:44:43 +0000 (22:44 +0000)]
add am/pm to voxlinesystems2 display format, remove name, revsere src/dst

15 years agofix one-time charge quantities &
ivan [Thu, 5 Jun 2008 20:09:34 +0000 (20:09 +0000)]
fix one-time charge quantities &

15 years agodisable_src fixes
ivan [Thu, 5 Jun 2008 19:44:30 +0000 (19:44 +0000)]
disable_src fixes

15 years agounit pricing didn't exist before, so it can be NULL
ivan [Thu, 5 Jun 2008 19:29:03 +0000 (19:29 +0000)]
unit pricing didn't exist before, so it can be NULL

15 years agoimplement quantity charging for setup fees
ivan [Thu, 5 Jun 2008 19:25:33 +0000 (19:25 +0000)]
implement quantity charging for setup fees

15 years agovoxlinesystems CDRs and quantity bs
ivan [Thu, 5 Jun 2008 19:24:37 +0000 (19:24 +0000)]
voxlinesystems CDRs and quantity bs

15 years agodash removal
jeff [Thu, 5 Jun 2008 19:07:21 +0000 (19:07 +0000)]
dash removal

15 years agoadd customer status to adv. customer report, template customer search for future...
ivan [Thu, 5 Jun 2008 10:36:43 +0000 (10:36 +0000)]
add customer status to adv. customer report, template customer search for future use in emailing notices, RT#2731

15 years agodocs for search_sql
ivan [Thu, 5 Jun 2008 10:34:20 +0000 (10:34 +0000)]
docs for search_sql

15 years agodocs for search_sql
ivan [Thu, 5 Jun 2008 10:34:06 +0000 (10:34 +0000)]
docs for search_sql

15 years agominor invoice report UI
ivan [Thu, 5 Jun 2008 08:54:36 +0000 (08:54 +0000)]
minor invoice report UI

15 years agopayment and credit applications have separate "apply to refund" choices now, and...
ivan [Thu, 5 Jun 2008 05:07:55 +0000 (05:07 +0000)]
payment and credit applications have separate "apply to refund" choices now, and no auto-refund choice in the invoice dropdown.  RT#3545

15 years agothis should fix the random "HylaFax support has not been configured" error, caused...
ivan [Wed, 4 Jun 2008 18:51:43 +0000 (18:51 +0000)]
this should fix the random "HylaFax support has not been configured" error, caused by cust_bill->fax getting called instead of cust_main->fax field

15 years agomore voxline invoice formatting
jeff [Wed, 4 Jun 2008 18:41:38 +0000 (18:41 +0000)]
more voxline invoice formatting

15 years agovoxline invoice formatting
jeff [Wed, 4 Jun 2008 18:05:02 +0000 (18:05 +0000)]
voxline invoice formatting

15 years agoservice address on invoice
jeff [Wed, 4 Jun 2008 13:27:43 +0000 (13:27 +0000)]
service address on invoice

15 years agovery basic start at adding quantities
ivan [Tue, 3 Jun 2008 21:06:39 +0000 (21:06 +0000)]
very basic start at adding quantities

15 years agofix payinfo_transaction
ivan [Mon, 2 Jun 2008 18:59:38 +0000 (18:59 +0000)]
fix payinfo_transaction

15 years agofix ntable calls
ivan [Mon, 2 Jun 2008 18:31:08 +0000 (18:31 +0000)]
fix ntable calls

15 years agooops, missed 1.7
ivan [Mon, 2 Jun 2008 17:22:46 +0000 (17:22 +0000)]
oops, missed 1.7

15 years agodoh!
ivan [Mon, 2 Jun 2008 17:14:31 +0000 (17:14 +0000)]
doh!

15 years agobadly placed small_custview all of a sudden causing fatal errors?! wtf
ivan [Mon, 2 Jun 2008 17:06:10 +0000 (17:06 +0000)]
badly placed small_custview all of a sudden causing fatal errors?!  wtf

15 years agotypeset tear-off remittance coupon
jeff [Mon, 2 Jun 2008 11:17:20 +0000 (11:17 +0000)]
typeset tear-off remittance coupon

16 years agoand batchmode was probably right
ivan [Mon, 2 Jun 2008 02:47:33 +0000 (02:47 +0000)]
and batchmode was probably right

16 years agoyow, don't want everything to waitt until the timeout
ivan [Mon, 2 Jun 2008 02:45:57 +0000 (02:45 +0000)]
yow, don't want everything to waitt until the timeout

16 years agouse IPC::Run to run pslatex & add a timeout, this should prevent hanging on template...
ivan [Mon, 2 Jun 2008 02:16:20 +0000 (02:16 +0000)]
use IPC::Run to run pslatex & add a timeout, this should prevent hanging on template errors

16 years agorefactor payment history slightly, add refund receipts, have "unapplied" refunds...
ivan [Sun, 1 Jun 2008 22:49:00 +0000 (22:49 +0000)]
refactor payment history slightly, add refund receipts, have "unapplied" refunds show like other unapplied/open things, RT#3545

16 years agosync with HEAD (add ability to modify refund records)
ivan [Sun, 1 Jun 2008 21:25:51 +0000 (21:25 +0000)]
sync with HEAD (add ability to modify refund records)

16 years agobackport cust_bill_ApplicationCommon::applied_to_invoice and cust_bill::invnum_date_p...
ivan [Sun, 1 Jun 2008 20:16:03 +0000 (20:16 +0000)]
backport cust_bill_ApplicationCommon::applied_to_invoice and cust_bill::invnum_date_pretty to 1.7

16 years agoshow "Check #" on payment receipts instead of "Billing #"
ivan [Sun, 1 Jun 2008 07:08:48 +0000 (07:08 +0000)]
show "Check #" on payment receipts instead of "Billing #"

16 years agodepend on CGI.pm 3.29 to fix RT attachment problems
ivan [Sun, 1 Jun 2008 01:23:37 +0000 (01:23 +0000)]
depend on CGI.pm 3.29 to fix RT attachment problems

16 years agofix problems when service definition names contain chars that need to be latex escaped
ivan [Sun, 1 Jun 2008 00:12:19 +0000 (00:12 +0000)]
fix problems when service definition names contain chars that need to be latex escaped

16 years ago1.7 sucks. but people are still going to be editing old-style invoice events for...
ivan [Fri, 30 May 2008 04:04:42 +0000 (04:04 +0000)]
1.7 sucks.  but people are still going to be editing old-style invoice events for a little while more yet, so space them out better (so options don't run together)

16 years ago1.7 sucks. add a "balance over" option to the 1.7 style agent-specific invoice send...
ivan [Fri, 30 May 2008 03:55:52 +0000 (03:55 +0000)]
1.7 sucks.  add a "balance over" option to the 1.7 style agent-specific invoice send event

16 years agofix a missing semicolon bug only triggered when running prune_applications not in...
ivan [Fri, 30 May 2008 01:38:03 +0000 (01:38 +0000)]
fix a missing semicolon bug only triggered when running prune_applications not in debug mode...

16 years agodon't print out warnings about SQL RADIUS FreesideStatus every time either. really?
ivan [Fri, 30 May 2008 01:34:30 +0000 (01:34 +0000)]
don't print out warnings about SQL RADIUS FreesideStatus every time either.  really?

16 years agodon't print out the cust_credit_refund pruning every time
ivan [Fri, 30 May 2008 01:33:51 +0000 (01:33 +0000)]
don't print out the cust_credit_refund pruning every time

16 years agodon't print out the cust_credit_refund pruning every time
ivan [Fri, 30 May 2008 01:28:22 +0000 (01:28 +0000)]
don't print out the cust_credit_refund pruning every time

16 years agoclean up any stray/old cust_pay_pending records causing problems
ivan [Fri, 30 May 2008 01:02:13 +0000 (01:02 +0000)]
clean up any stray/old cust_pay_pending records causing problems

16 years agoclean up any stray/old cust_pay_pending records causing problems
ivan [Fri, 30 May 2008 00:53:05 +0000 (00:53 +0000)]
clean up any stray/old cust_pay_pending records causing problems

16 years agoline things up better on the 12mo report (prevent labels from taking up most of the...
ivan [Thu, 29 May 2008 00:11:59 +0000 (00:11 +0000)]
line things up better on the 12mo report (prevent labels from taking up most of the graph

16 years agomailgate realiability fix: don't bomb out when FS dbdef hasn't been initialized yet...
ivan [Wed, 28 May 2008 10:45:43 +0000 (10:45 +0000)]
mailgate realiability fix: don't bomb out when FS dbdef hasn't been initialized yet (& need to import adminsuidsetup)

16 years agomailgate realiability fix: don't bomb out when FS dbdef hasn't been initialized yet
ivan [Wed, 28 May 2008 10:42:28 +0000 (10:42 +0000)]
mailgate realiability fix: don't bomb out when FS dbdef hasn't been initialized yet

16 years agomailgate realiability fix: don't bomb out when FS dbdef hasn't been initialized yet
ivan [Wed, 28 May 2008 10:41:22 +0000 (10:41 +0000)]
mailgate realiability fix: don't bomb out when FS dbdef hasn't been initialized yet

16 years agomailgate realiability fix: don't bomb out when FS dbdef hasn't been initialized yet
ivan [Wed, 28 May 2008 10:14:53 +0000 (10:14 +0000)]
mailgate realiability fix: don't bomb out when FS dbdef hasn't been initialized yet

16 years agoautomatically create an index on the new radacct.FreesideStatus column
ivan [Tue, 20 May 2008 03:52:06 +0000 (03:52 +0000)]
automatically create an index on the new radacct.FreesideStatus column

16 years agofix broken pagenation
jeff [Mon, 19 May 2008 22:31:17 +0000 (22:31 +0000)]
fix broken pagenation

16 years agoa better link to the T:T docs
ivan [Mon, 19 May 2008 18:51:01 +0000 (18:51 +0000)]
a better link to the T:T docs

16 years agoadd a key on ( history_action, $primary_key ) to the h_ tables. this should speed...
ivan [Mon, 19 May 2008 04:29:03 +0000 (04:29 +0000)]
add a key on ( history_action, $primary_key ) to the h_ tables.  this should speed up the cust_pay upgrade??

16 years agobackport voip_cdr's upstream_simple, and the columnization features
jeff [Mon, 19 May 2008 04:07:45 +0000 (04:07 +0000)]
backport voip_cdr's upstream_simple, and the columnization features

16 years agomake net receipts clickable... and netreceipts != cashflow, really, so separate those...
ivan [Mon, 19 May 2008 04:07:07 +0000 (04:07 +0000)]
make net receipts clickable... and netreceipts != cashflow, really, so separate those concepts, and cashflow gets gross & net variants.  also add gross/net refunds.  #3012

16 years agofix auto sqlradius upgrade: module include/import
ivan [Sun, 18 May 2008 22:57:55 +0000 (22:57 +0000)]
fix auto sqlradius upgrade: module include/import

16 years agooops, fix minor refactoring of auto sqlradius upgrade
ivan [Sun, 18 May 2008 22:55:43 +0000 (22:55 +0000)]
oops, fix minor refactoring of auto sqlradius upgrade

16 years agofix the auto sqlradiusupgrade
ivan [Sun, 18 May 2008 22:53:13 +0000 (22:53 +0000)]
fix the auto sqlradiusupgrade

16 years agoon upgrade, automatically seed from sqlradius databases, and start freeside-sqlradius...
ivan [Sun, 18 May 2008 22:42:57 +0000 (22:42 +0000)]
on upgrade, automatically seed from sqlradius databases, and start freeside-sqlradius-radacctd by default

16 years agoadd a config value for disabling the ACLs... this should be good for a demo in 1...
ivan [Sun, 18 May 2008 06:50:35 +0000 (06:50 +0000)]
add a config value for disabling the ACLs... this should be good for a demo in 1.7, 1.9 will need some way to disable ACL changes from OUTSIDE the db

16 years agofix minor problem with ship_zip not showing up in small_custview
ivan [Thu, 15 May 2008 22:48:54 +0000 (22:48 +0000)]
fix minor problem with ship_zip not showing up in small_custview

16 years agoconfig option to omit statement type items from invoices
jeff [Wed, 14 May 2008 21:21:17 +0000 (21:21 +0000)]
config option to omit statement type items from invoices

16 years agotyop
ivan [Tue, 13 May 2008 23:36:26 +0000 (23:36 +0000)]
tyop

16 years agoensure new self-service libs are installed
ivan [Tue, 13 May 2008 19:13:36 +0000 (19:13 +0000)]
ensure new self-service libs are installed

16 years agore-drag address and router even farther into the century
jeff [Fri, 9 May 2008 21:51:59 +0000 (21:51 +0000)]
re-drag address and router even farther into the century

16 years agofix customer cancellation, sort of a side effect of #2872, fixes #3480, #3481
ivan [Wed, 7 May 2008 21:36:36 +0000 (21:36 +0000)]
fix customer cancellation, sort of a side effect of #2872, fixes #3480, #3481

16 years agoagent-virtualize customer # portion of quick payment entry
ivan [Tue, 6 May 2008 01:14:56 +0000 (01:14 +0000)]
agent-virtualize customer # portion of quick payment entry

16 years agohopefully really a better fix for using new payment duplicate stuff with cc encryption :/
ivan [Mon, 5 May 2008 02:11:24 +0000 (02:11 +0000)]
hopefully really a better fix for using new payment duplicate stuff with cc encryption :/