Format: 1.8 Date: Tue, 25 Jan 2022 16:18:43 -0800 Source: freeside Binary: freeside freeside-lib freeside-webui freeside-selfservice-lib freeside-torrus freeside-selfservice-ui freeside-ng-selfservice Architecture: all Version: 4.3~git-2022012515 Distribution: unstable Urgency: medium Maintainer: Ivan Kohler Changed-By: Jim Lucas Description: freeside - Billing and trouble ticketing for service providers freeside-lib - Libraries for Freeside billing and trouble ticketing freeside-ng-selfservice - Next Generation Self-service portal for Freeside billing and trou freeside-selfservice-lib - Self-service portal for Freeside billing and trouble ticketing freeside-selfservice-ui - Self-service portal html/cgi filesfor Freeside billing and troubl freeside-torrus - Integrated network monitoring and billing freeside-webui - Web interface for Freeside billing and trouble ticketing Changes: freeside (4.3~git-2022012515) unstable; urgency=medium . [ Ivan Kohler ] * don't add an autobuild changelog to stable releases * permissions * 4.3~git * asterisk v12 CDRs, RT#71704 . [ Christopher Burger ] * Updated two screen shots the menu-top-example and the menu-left-example from current version Cosmetic change to pref.html, just added a space. Tested and working. * Reverted menu-left-example.png back to original and cleaned up menu-top-example to be bigger. * RT# 37099, Updated Post payment button to have an id, and updated javascript to disable submit button when multiple customers found . [ Ivan Kohler ] * fix upgrade for dangling cust_main_invoice, RT#75271 * visual nit: fix stray | * visual nit: fix stray | . [ root ] * RT# 21110 Unparsable age error. Added javascript to validate field prior to submitting the form. Also place checked prior entry in database. * RT# 21110 Unparsable age error. Added javascript to validate field prior to submitting the form. Also place checked prior entry in database. * RT# 21110 Unparsable age error. Added javascript to validate field prior to submitting the form. Also place checked prior entry in database. * RT# 21110 Unparsable age error. Added documentation to the footer to show how to validate a form. . [ Christopher Burger ] * RT# 21110, Updated files to use jquery-validate jquery plugin. This allows for field validation instead of just form validation. Also updated footer so it does not use experimental keys on scalar. Dereferenced hash ref prior to using keys. * RT# 21110 - fixed bad link on license.html . [ Ivan Kohler ] * asterisk v12 CDRs, RT#71704 * fix self-service contact logins, RT#74798 * UI improvments porting in when there's an inventory selector: can enter a phone number instead of selecting from inventory, RT#73618 * extend vitelity integration: start and complete port-in, RT#73618 * fix connection errors to print service under deb 8 ? RT#75293 . [ Christopher Burger ] * RT# 21110 - cleaned up jQuery Validate link to be compatible with other links. . [ Ivan Kohler ] * add omit_cust_main_county flag to payment_info API call, RT#75124 * add omit_cust_main_county flag to payment_info API call, RT#75124 * doc * add option to disable backup so two runs of freeside-daily with -m don't write to the same file * order package 4.x styling * fix broken apach restarts * discounts on one-time charges< RT#75448 * discounts on one-time charges< RT#75448 * configure "Please pay by" string per agent, RT#75372 * configure "Please pay by" string per agent, RT#75372 * rate import for login, RT#72091 * respect license notice in brand-agent logo size * add duedate_long to invoice template substitutions, RT#75066 * set document title for PDF viewers * svc_cable SQL export, RT#75250 * start of wordpress plugin, RT#75279 * wordpress plugin, RT#75279 * wordpress plugin, RT#75279 * wordpress plugin, RT#75279 * wordpress plugin, RT#75279 * clean up example wordpress self-service, RT#75279 * add logout to example wordpress self-service, RT#75279 * invoice logo for wordpress plugin, RT#75279 * customer links on customer class browse * expose invoice_lines() to invoice_html template for legacy mailbug use, RT#71087 * optimize legacy CCH taxation, RT#74494 * fix occasional bad query planning searching for CDRs, RT#74494 * add list_payments and payment_receipt self-service API calls, RT#75517 * fix freeside-daily error checking LNP status, RT#75736, RT#73618 * fix customer searching with "List customers" right but not "List all customers", RT#75012 * add a separate ACL for churn report, RT#75012 * now that quotations in v4 simulate a real billing, need a workaround for packages that start on hold, RT#75646 * don't allow two character substring searches, RT#75012 * don't allow three character substring searches, RT#75012 * clarify where rights are granted * access control for List all customers, RT#75012 * customer referral report, RT#75757 * add condition on number of referred customers, RT#75356 * discount action UI improvements: don't show 'Custom discount' which we can't add on the fly, RT#75536 * email referring customers on cancellation, RT#75756 * add condition on number of referred customers, RT#75356 * discount action improvements: package class selection and once per customer flag, RT#75536 * don't error out with a vitely export disconnected from any services, RT#75736 * add residential/commercial conditions, RT#75886 * fix customer importing vs v4 schema, RT#75964 * test billing events, RT#73949 * test billing events, RT#73949 . [ Christopher Burger ] * RT# 74523 Added fusionpbx import script, updated Import.pm to handle different import scripts. updated ivr_import to use new Import.pm . [ Ivan Kohler ] * clarify description for current reality * fix address stickiness on errors, RT#76000 * cleanup * separate edit and delete rights for customer notes, RT#76001 * add notes to change history, RT#76002 * better filename with quotation # for PDF quotation attachments, RT#76003 * PDF quotation fixes, RT#75991 * start billing link for one-time charge packages ordered on hold, RT#75813 * no need for a one-choice "Add new location" location dropdown on prospect add, RT#76000 * prospect add/edit: order fields more like customer add/edit, hide company in residential mode, only have a single contact in residential mode, RT#75990 * show a name on residential prospect quotations, RT#75990 * fix prospect state dropdown, RT#76043, fallout from #76000 * cancel one-time packages that have not yet billed with v4 package actions menu, RT#76057 * threshold rate import, RT#75897 * better vitelity error messages, just depend on Net::Vitelity, RT#75901 * fix DID selection dropdowns, RT#75901 * fix DID selection dropdowns, RT#75901 * fix multi-level data structures via XMLRPC API, RT#38254, RT#75279 * fix mason_comp via FS::SelfService . [ Christopher Burger ] * RT# 74523 - Moved bin/cdr-fusionpbx.import to FS/bin/freeside-cdr-freeswitch . [ Ivan Kohler ] * render first_acct svc_acct._password fields are HTML password fields * don't echo back a password in the error message * order package/service in example wordpress self-service, RT#75279 * add debug flag, RT#73618 * threshold rate import, RT#75897 * nt lightnet rate import, RT#76013 * throw a better, pre-vitelity error message if we're missing any of their required fields, RT#73618 . [ Christopher Burger ] * RT# 74122 - Updated Change History to be more user friendly. Tags are now color coded user readable. * RT# 74666, Added quotation description to customer quotation list and quotation view * RT# 71419 Updated Advanced wireless broadband report with new option to display package name. * RT# 71419 Added Cancel date option, and updated package name * RT# 74523 - added command line option to use a status table * RT# 74523 - added check for status table argument for /bin/cdr-ivr.import compatibility . [ Ivan Kohler ] * error on batch insert is returned to user, not fatal, RT#75998 * check AU postal codes, RT#75998 * additional vitelity debugging, RT#73618 * allow self-service logins with a + in email address * better error importing credits with unknown customer numbers, RT#76184 * fix self-service info edit turning off self-service contact access, RT#76209 * fix vitelity addport via API? RT#73618 * separate ACL for editing customer invoice terms, RT#75759 * separate ACL for editing customer invoice terms, RT#75759 * separate ACL for editing customer invoice terms, RT#75759 * document shipping address fields in new_customer self-service API, RT#74008 * perform 3 character substring searches if you have 'List all customers', RT#75012, RT#76155 * don't error out displaying customer reocrd if tax vendor is configured and customer has no address . [ Christopher Burger ] * RT# 76028 - Added search field Card Last 4#: to allow the filtering of payment report by last four of credit card used. Only shows when card_masking_method is set to display last 4 . [ Ivan Kohler ] * charge for printing usage * fix error on changing customer when there isn't an implicit contact, RT#76405 * include domains * add e911 to vitelity integration, RT#73618, RT#76262 . [ Christopher Burger ] * RT# 74122 - updated change history to not show data with out a description * RT# 76308 - Added action Sent HTTP or HTTPS post to event types Package, Customer, Batch Payment, Statement, Account service * RT# 76171 - Added new svc_circuit field internal_circuit_id, updated label for existing svc_circuit field circuit_id to Provider Circuit ID. * RT# 76171 - updated POD documentation . [ Ivan Kohler ] * change is * Compliance Solutions integration, RT#75262 . [ Christopher Burger ] * RT# 76171 - Added Interal Circuit Id to view circuit service page. . [ Ivan Kohler ] * fix RT vs v4-style location-less customers . [ Christopher Burger ] * RT# 75817 - Added the ability to set contacts password on the backend . [ Ivan Kohler ] * fix times on appointments list (RT stores dates in UTC), RT#76486 * fix fees vs. tax refactor, RT#76366 * when debug is on, always show vitelity result from every command, RT#76262 * correctly parse CNAM response, RT#76262, RT#73618 . [ Christopher Burger ] * RT# 76312 - added customer tags to search options for payment report. * RT# 76312 - improved code by using an array datatype rather than a string that is then later manipulated. . [ Ivan Kohler ] * fix country code browser on subsequent selections and add country name * show a total range for prorate quotations * show a total range for prorate quotations * fix RT iCal feed, RT#75581 * prevent unnecessary wrapping * prefixes should be unique * fix email on contact report . [ Christopher Burger ] * RT# 74666 - fixed vulnerability by escaping quotation_description var . [ Ivan Kohler ] * fix outgoing email with commas in company name, RT#76449 * fix card signup in v4 * at least get an error in the log . [ Christopher Burger ] * RT# 74665 - set a default close date if global config quotation_disable_after_days is set * RT# 74665 - small cleanup of code, removed text value * RT# 74666 - updated some UI and description field location. * RT# 76303 - added tag options to payments, batch payments, and statement billing event types * RT# 76303 - fixed bug with tags not saving when selected * RT# 76307 - Added billing event action to add a tag * RT# 76307 - changed from returning an error to die on error. . [ Ivan Kohler ] * correctly parse error response from e911 provisioning, RT#76262 . [ Justin DeVuyst ] * Add configurable daily auto-disable for quotations. See RT#74665. . [ Christopher Burger ] * RT# 74665 - set a default close date if global config quotation_disable_after_days is set * RT# 74665 - small cleanup of code, removed text value . [ Ivan Kohler ] * cant go back and cant stand still * optimize rate display, RT#72030 * add ext and cdrtype options to Bicom PBXware CDR download, RT#76756 * CDR import scripts converted to real commands * CDR import scripts converted to real commands * change voip innovations CDR retrieval hostname, RT#76784 * set suretax DataYear and DataMonth to the invoice year and month, RT#76786 * 4.x style reports * not in 4.x style * search for payments by customer location, RT#76691 . [ Christopher Burger ] * RT#73993 - updated selfservice and ngselfservice to allow for the control of changes packages by agent. * RT# 73993 updated ngselfservice to allow for package change. . [ Ivan Kohler ] * fix inadvertant breakage in mason_comp, RT#73993, RT#75279 * remove debugging while fixing nadvertant breakage in mason_comp, RT#73993, RT#75279 . [ Christopher Burger ] * RT# 73993 - Updated process to display only packages customer has access to. * RT# 73993 - updated ng_selfservice/services.php and ng_selfservice/packages_change.php to only pass one cgi param pkgnum and escaped pkg_label * RT# 73993 - cleaned up code as requested, and created new call to get package info * RT# 73993 - added new API call to list and documented it. . [ Ivan Kohler ] * fix fees vs. tax refactor, RT#76366, RT#76490 * start of placeholder code path, type binding not working right yet * PG_BYTEA seems to be working nowadays, and uses much less memory than our alternative, RT#76731 * scalar param . [ Christopher Burger ] * RT# 38517 - added auto create of customer contact, if requestor is not a contact yet when adding a company to ticket. * RT# 38517 - Added Lingua::EN::NameParse to parse real name into first and last name. . [ Ivan Kohler ] * compliance solutions integration: import and use produce/service code catalog, RT#75262 * remove debugging * new backoffice API call customer_list_svcs * compliance solutions integration: import and use produce/service code catalog, RT#75262 . [ Christopher Burger ] * RT# 76309 - Updated 3 email notices to use more billing event types . [ Ivan Kohler ] * increase max inline message size from ~12k to ~120k, because HTML and 2017, RT#76879 * update fix-sequences for current DB . [ Christopher Burger ] * RT# 38517 - fixed small error causing perl warning on start. * RT# 74537 - Added new selfservice config option to make ECHECK readonly on selfservice, updated selfservice and NGselfservice to look for this option * RT# 74537 - added checks in MyAccount.pm for config option ach read only * RT# 74537 - added check for config option selfservice-ACH_info_readonly to deletepayby method * RT# 76905 - Created ability to delete payment account thru NG selfservice to test API change in ticket 74537 * RT# 74537 - removed link to list payment accounts page in ng_selfservice . [ Ivan Kohler ] * VoIP innovations CDR import using SSL, RT#76784 * enable all debugging when you turn on the checkbox, RT#76756 * fix agent-specific invoice_default_terms on new customer add, RT#76862 . [ Christopher Burger ] * RT# 75595 - Add billing event condition that will trigger when the contract end date is coming up * RT# 75595 - made it only available for cust_pkg . [ Ivan Kohler ] * voip innovations CDR import: don't cd / anymore, RT#76784 * fix agent display on reports when set in conf setting cust-fields, RT#76948 * have base freeside deb package depend on same versions . [ Christopher Burger ] * RT# 74715 - fixed saving of census tract to actually save. . [ Ivan Kohler ] * missing a use B:OP causes an error in rare edge cases with batching, RT#77003 * rt 4.2.14 (#13852) * show database size detail * add tilde to allowable punctuation, RT#77086 * add fulltexrt indexing to RT daily tasks * exclude big non-operational history tables from backup * voip innovations FTPS should be passive, RT#76784 * SureTax: use less memory, provide additional debugging, RT#76987 * have base freeside deb package depend on same versions . [ Christopher Burger ] * RT# 73490 - added global configuration to check if RT activity alert should be displayed. * RT # 73490 - removed global conf and user pref check for hide tickets and added group access control. * RT# 73490 - updated group access right with better name, and set one time migration to update all groups. * RT# 76992 - Added 3 new import formats that combine Location and Phone Service * RT# 76992 - removed some development code . [ Ivan Kohler ] * document fields . [ Christopher Burger ] * RT# 75817 - updated set contact password to use popup window. fixes break in first contact. * RT# 75817 - fixed contact password page to be more consistant with svc password page, updated javascript to check password as you type rather than when you leave the field. * RT# 75817 - fixed enable selection to send password reset and to allow you to set password in one step * RT# 75817 - fixed bug to only send email out to contact that is being enabled not to all enabled contacts . [ Justin DeVuyst ] * Add warning of svc unprovisioning on pkg cancel. See RT#29087. * Put each svc listing on its own line. See RT#29087. . [ Ivan Kohler ] * fix cancel message verb for suspensions, RT#29087 * expect-style ssh interaction, for interation w/cisco and other networking eqipment, RT#77180 . [ Christopher Burger ] * RT# 27969 - created 3 new api functions to add, edit and list advertising sources * RT# 27969 - added documentation for advertising_sources api functions . [ Ivan Kohler ] * correctly parse error response from e911 provisioning, RT#76262 * fix 4.x cust_payby vs legacy customer import, RT#77221 * fix 4.x cust_payby vs legacy customer import, RT#77221 * fix 4.x cust_payby vs legacy customer import, RT#77221 * restore void tooltip on v4, RT#77279 * separate access control for payment reports, RT#77007 * condition to consider referred customers base recurring, RT#75356 * referral count search, RT#75757 * referral status search, RT#75757 * add 54-g agent_custid format, RT#77110 * SureTax: additional debugging, RT#76987 . [ Christopher Burger ] * RT# 77200 - Changed fixed active date to a user input date * RT# 77021 - fixed advanced report criteria so agent and other fileds with a . in them now work. * RT# 76952 - fixed error that would save a duplicate ACH or credit card account * RT# 77245 - fixed bug when adding router, now services are added. . [ Ivan Kohler ] * quick script to add armed forces USPS "state" abbrivations, RT#77312 * fix upgrade error, RT#77099, RT#76171 * fix prorate_day without force_prorate_day for recur_Common packages configured as subscription or prorate, RT#77140, RT#38191 . [ Christopher Burger ] * RT# 76171 - Added error check on field internal_circuit_id . [ Ivan Kohler ] * if a single entry has bad UTF-8 chars, error out on that entry only instead of the whole conf page * display usage fields in deterministic order * warning if product/service code import wasn't run, RT#77163, RT#75262 . [ Christopher Burger ] * RT# 77167 - Added the ability to import a list of contacts * RT# 77167 - removed change as not needed. . [ Ivan Kohler ] * current census year selection * no longer supporting deb7 in new builds * check more of the build infrastrcture in * compliance solutions import * Locale::SubCountry v1 * stretch-happy Releases files * stretch-happy Releases files * remove conflicts on libparams-classify-perl so we can install the version from our stretch repo * apache2-mpm-prefork is gone in debian 8+ (jessie+) * alas * spacing . [ Christopher Burger ] * RT# 77504 - Fixed error display issue, and javascript to prevent error. * RT# 77504 - Documented javascript. . [ Ivan Kohler ] * better documentation for UIA's API needs, RT#76831 * fiber and DSL http exports, RT#75932 * Revert "remove conflicts on libparams-classify-perl so we can install the version from our stretch repo" * employee access stats: fix dates and remove web path * employee statistics: omit common components * add quantity, setup and recur to package import, RT#76992 * more room for package change popup * more room for package change popup * fix stickiness of address fields on errors, when entering new address * 4.x style change package popup * fix package change vs. v4 discount refactor, RT#77513, RT#14092 * don't error out if there aren't any bz2 files anymore * don't send zip+4 to vitelity e911, RT#76262 * compliance solutions, RT#77676 * compliance solutions, RT#77676 * compliance solutions, RT#77676 * vitelity: send customer name instead of requiring company, RT#73618 * tax refactor vs. internal taxation, RT#77679 * fix field order in docs for new import formats, RT#77747, RT#76992 * added invoice details to package import, RT#76992 * added invoice details to package import, RT#76992 * fix field order in docs for new import formats, RT#77747, RT#76992 * fix import of 0 custom price, RT#76992 * new backoffice API to add a package, RT#77484 * move \begin{document} earlier to prevent a large summary from pushing things off the bottom of the page, RT#77899. ref https://tex.stackexchange.com/questions/55331/text-is-going-below-the-page-bottom : "need to place any contents that is actually typeset within ghte document environment" * sort by referral count, RT#75757 * sort by referral count, RT#75757 . [ Christopher Burger ] * RT# 76968 - Created new interactive map to select census tract * rt# 76968 - updated Map service module link * RT# 76968 - added header logo and css to map page, fixed address look up error, added leaflet to license * RT# 76968 - Added logo only header file * RT# 77193 - Fixed default layer not displaying * RT# 77193 - updated selfservice change payment accounts to work with version 4 * RT# 77193 - Added files to alter creditcard or check information via selfservice * RT# 77193 - fixed error when inserting new ach payby thru selfservice on V4. Now works * RT# 77193 - fixed error updating ACH payby thru selfservice, not saving changed account or aba number on V4. Now works . [ Ivan Kohler ] * show compliance solutions JSON, RT#77789 * fix MIME::Entity usage for perl 5.18+, RT#77890 . [ Christopher Burger ] * RT# 77160 - created new customer time span report * RT# 77332 - Fixed error where all packages updated with new next bill date, instead of just selected ones. * RT# 77332 - updated new search option name to make it more clear. . [ Ivan Kohler ] * fix package import custom pricing vs. services, RT#78291, RT#76992 * don't abort upgrade if a customer doesn't have an echeck cust_main.paytype. if it's not there, it's not there. * fix custom pricing vs. services issue in API order_package call too, RT#77484 * more v4 taxes vs. fees, RT#78395 * scalability: always reap children, RT#78270 * compliance solutions integration: always send a zip, whatever zip we have, RT#78660, RT#75262 . [ Mitch Jackson ] * RT# 73211 - Add billing event: remove customer tag . [ Ivan Kohler ] * add hour to timestamp; don't build packages needlessly * better error handling when a package change fails, RT#78504 * no longer supporting deb7 * doc * clean up encryption module use * doc * fix autobuild change detection for two OS trees . [ Christopher Burger ] * RT# 24643, added waive setup fee option to change package screen. * RT# 24643 - fixed error in saving waive setup fee flag when not selected . [ Ivan Kohler ] * chris level up, add mitch . [ Christopher Burger ] * Revert "RT# 24643 - fixed error in saving waive setup fee flag when not selected" * RT# 24643 - fixed error in saving waive setup fee flag when not selected * RT# 29295 - added package_list and package_status to backend API. Also added two new test files in bin to test new apis . [ Ivan Kohler ] * sha512 crypt() export * keeping up with the times * add card processing to example self-service, RT#75279 . [ Christopher Burger ] * RT# 75095 - Added Ooma integration to one time charges * RT# 75095 - Fixed use of a constant warning. . [ Ivan Kohler ] * add "trunkdst" to pbxware export, RT#78550 * add card processing to example wordpress self-service, RT#75279 * fix logo encoding over xml-api for all functions that call skin_info internally, RT#75279 * add forgot password functionality to example wordpress self-service, RT#75279 . [ Mitch Jackson ] * whitespace only * Added option for Credit Report to include Voided Credits RT#73200 * Change selectbox to checkbox on Credit Report form RT#73200 * Add crednum (id) field to Credit Report RT#73200 * RT# 73200 Show voided credits on Credit Report - backport fixes . [ Christopher Burger ] * RT# 78681 - fixed error where setup fee was being charged when prorate_defer_bill was set even though wave setup fee was selected. * RT# 74959 - Fixed edit location link to acually save location . [ Ivan Kohler ] * Net::SSLglue never worked, need deb9 Net::FTP for this to work * added warning to invoice_default_terms concerning changing it after going live, RT#78536 . [ Christopher Burger ] * RT# 78019 - Added total revenue line to Package churn report * RT# 78019 - Added revenue difference to package churn report * RT# 78019 - updated csv and excel export to set two decimal for revenue columns. * RT# 74845 - fixed report to allow downloading even if there are errors. . [ Ivan Kohler ] * fix changing employee password, RT#78939 * clean up old RT sessions . [ Christopher Burger ] * RT# 78450 - Fixed error with cdr import of AAPT CTOP format. Changed regex to ignore white space at beginning. . [ Ivan Kohler ] * add -u custnum_filename, -k skip_pkgpart and -v verbose, RT#79001 . [ Christopher Burger ] * RT# 71364 - Added group total to top of payment report . [ Ivan Kohler ] * add -k skip_pkgpart, RT#79001 * added -f flag to continue voiding even if an error is received, RT#78977 . [ Christopher Burger ] * RT# 76878 - Fixed installer checkbox to be sticky on error. . [ Ivan Kohler ] * fix reports for 2018, RT#79090 * add "bill_only_pkg_dates" option to inbound voip billing, RT#79001 * happy new year * doc * fix employee pw change, RT#79010, RT#32456 * extend vitelity integration: start and complete port-in, RT#73618, RT#78929 * fix direct use of customer_view_emails pref, RT#78617 * no need for a one-choice "Add new location" location dropdown on prospect add, RT#76000 . [ Christopher Burger ] * RT# 79121 - Added new cdr import format for ani networks, and cron script for same . [ Ivan Kohler ] * 4.x style employee edit . [ Christopher Burger ] * RT# 79121 - added flag to store public key in known host file * RT# 78617 - fixed preference field customer_view_emails to only except whole numbers, also added redirection back to preference page after edit. * RT# 78617 - added alert code that can be placed on any page. * RT# 78617 - removed some test code * RT# 78617 - updated redirect to freeside_status to show update message . [ Ivan Kohler ] * set employee password CLI * 2018 * fix postinst? * fix postinst? * don't escape twice * don't leave quotation side effects around, eek, RT#79310, RT#32489 * fix initial employee add w/password, RT#32456 * fix initial employee add w/password, RT#32456 * fix initial employee add w/password, RT#32456 * no need for errors decrypting inadvertantly encrypted payinfo to be fatal, RT#76385 * fix billing error with intro rate packages when billing dates have been edited non-sensically (bill date set even though package is not billing yet), RT#78349 . [ Christopher Burger ] * RT#79121 - added POD documentation * RT# 79121 - fixed error with loading files with option a . [ Ivan Kohler ] * ng selfservice deb9 packages . [ Christopher Burger ] * RT# 76398 - Added auto status field or status table creation * RT# 76398 - fixed sybase query for detecting tables and adding columns * RT# 76398 - Fixed sybase connection and cleaned up code . [ Ivan Kohler ] * quiet warnings * torrus * fix masondata perm bs . [ Mitch Jackson ] * RT# 78592 CDR Import for Acme Packet VOIP Switches * RT# 78952 CDR Import for Acme Packet Improved caller-id parsing . [ Ivan Kohler ] * alpha sort CDR formats, weight has lost all usefulness * option to reprocess CDRs when voiding an invoice, RT#79001 . [ Christopher Burger ] * RT# 75095 - updated mapping of ooma import file format * RT# 75095 - added comment * RT# 75095 - fixed ooma format to import all charges, and unified import process to allow new formats to be added quickly. consistant with cdr imports . [ Ivan Kohler ] * journal cdrbatch -> cdrbatchnum upgrade * capitalization * don't barf displaying invoices for location-less customers, RT#79312 * auto-create package class from string name on import, RT#79383 . [ Christopher Burger ] * RT# 79507 - enabled GCET import format * RT# 78356 - broadband svc export to saisei * RT# 78356 - cleaned up code and added debug code * RT# 78356 - added ability to remove service thru api when service is unprovisioned. * RT# 78356 - Added user documentation . [ Ivan Kohler ] * fix broadband reporting with giant query URLs (large numbers of package defs, etc.), RT#76765 * hide tickets with selfservice priority indicating closure, RT#79444 . [ Mitch Jackson ] * RT# 79284 Option to set/carry recur discount at Change Package * RT# 79284 Updated discounts UI for Change Package screen * RT# 79284 Fix UI bug for Change Package screen . [ Christopher Burger ] * RT# 79497 - Changed email address check to all emails to be seperated by a space. Added contacts to change history. * RT# 79497 - removed test code . [ Ivan Kohler ] * duplicate tax rates from one state to others, RT#79635 . [ Mitch Jackson ] * RT# 77144 replace bytes_substr with Unicode::Truncate . [ Christopher Burger ] * RT# 79239 - added option to prorate first month to synchronize with customers other packages with sql_export plan . [ Mitch Jackson ] * RT# 79353 Update discount report - include waived setup fees . [ Ivan Kohler ] * doc . [ Christopher Burger ] * RT# 79780 - added a 60 second pause when there is a connection failure, then retry. Do this for 20 hours . [ Ivan Kohler ] * save logging information so we have a historical record of exactly when problems happened, RT#79780 * more room for imported package names, RT#79383 * save logging information so we have a historical record of exactly when problems happened, RT#79780 . [ Christopher Burger ] * RT# 78356 - updated documentation and added ability to create access points as Saisei thru api * RT# 78356 - added ability to create and modify rateplans and access point when changed on freeside. cleanded up documentation. * RT78356 - fixed exportname error added missing file * RT# 78356 - fixed error where no export existed. * RT# 78356 - fix for saisei integration . [ Mitch Jackson ] * RT# 79636 Add conf flag invoice_sections_multilocation * RT# 79636 Update label for conf flag invoice_sections * RT# 79636 Taxes per section when using invoice_sections . [ Christopher Burger ] * RT# 79239 - updated code to use existing sub routine * RT# 79239 - cleaned up code * RT# 33362 - fixed discount_mixin to not throw perl error when trying to discount non monthly recuring. * RT# 33362 - fixed Argument 1d is not numeric when trying to discount daily recuring packages * RT 37817 - created new billing event condition, invoice has not been sent. . [ Ivan Kohler ] * invoice_sections_with_taxes per-agent, RT#79636 . [ Christopher Burger ] * RT# 80114 - added the population of startdate and billsec from ani cdr * RT#39115 - added a optional display name for oid . [ Ivan Kohler ] * invoice_usesummary is already agent virt, just need to be able to set it, RT#79636 * and turn it back off as an agent override, RT#79636 * rendering time with lots of locations, RT#80177 * optimize invoice rendering, RT#80177 . [ Christopher Burger ] * RT# 75680 - Added date parse, and display insert error. . [ Ivan Kohler ] * optimize invoice display with sections, RT#80177 * fix deployment zone error when there are no blocks yet, RT#78339, github-pr#66, thanks to sushrutp for the patch . [ Mitch Jackson ] * RT# 79353 Update discount graph - include waived setup fees * RT# 79353 Update discount reports * RT# 79353 Update discount reports * RT# 79636,42357 Suppress $0.00 summary line items * RT# 79636,42357 invoice_sections_with_taxes bugfix * RT# 78190 Fix format bug for invoices sectioned by location . [ Ivan Kohler ] * log pid in our log, RT#80211 * ip allocation mutex for high-traffic implementations, RT#79825 * restore masked card info on batched payment report, RT#78166 . [ Mitch Jackson ] * RT# 79636 Location Summary Invoice Footer . [ Ivan Kohler ] * bulk customer package edit from multiple source package definitions, RT#79885 . [ Christopher Burger ] * RT# 78356 - Updated documentation * RT# 77160 - fixed report error when multiple canceled packages had they same datetime * RT# 78131 - added ability to use message template for auto payment receipt and fixed NaN error when selecting nothing for config items with type select. * RT# 77964 - fixed so deferring date now works when waive setup fee is set * RT# 77964 - Placed waive setup fee check back to billing.pm, and added check for prorate package in billing.pm . [ Ivan Kohler ] * termination fields * show account services in address block list too, RT#79825 . [ Christopher Burger ] * Revert "RT# 77964 - Placed waive setup fee check back to billing.pm, and added check for prorate package in billing.pm" * Revert "RT# 77964 - fixed so deferring date now works when waive setup fee is set" . [ Ivan Kohler ] * include batch payment and statement events in reports, RT#80156 * 4.x style . [ Christopher Burger ] * RT78131 - Created new method to send message receipts so code does not have to be duplicated. * RT# 78131 - added documentation for new method. * RT# 77792 - fixed RBC format to display company name with business checking or savings is used * RT# 77792 - Created method to decide if batch payname should be name on card or personal name or business name. . [ Mitch Jackson ] * Fixed invoice inconsistencies with various conf flags RT#78190 * RT# 78190 Remove debug statements * RT# 78190 Update totals for latex summary * POD Documentation * RT# 42357,78190 Fix Fees appearing twice within sectioned invoices * RT# 78190,42357 Correct layout discrepancies for bill summary * RT# 78190 Fix billing event/late fee on sectioned invoices * RT# 78190 Fix taxes on fees for sectioned invoices * RT# 79363 Hide empty tax section, invoice_sections_with_taxes * RT# 78190 Fix bill summary missing taxes or fees . [ Christopher Burger ] * RT# 77964 - Fixed error where deferring date did not work when waive setup fee was set. * RT# 77964 - refined code to defer dates when waiving setup fee for prorated packages. . [ Mitch Jackson ] * RT# 73421 Simulated SMTP server for testing E-Mail . [ Christopher Burger ] * RT# 79737 - Added ability to us a cc surcharge of a flat fee. * RT# 79737 - fixed error in code . [ Mitch Jackson ] * RT# 79549 Requre a Rate Plan to use voip_cdr Price Plan * RT# 79549 Requre a Rate Plan to use voip_cdr Price Plan * RT# 80268 Fix RADIUS usergroup UI bug . [ Ivan Kohler ] * add warning to flat fee description too, RT#79737 . [ Christopher Burger ] * RT# 77917 - Updated event option Agent to allow for selection of multiple agents. * RT# 77917 - fixed upgrade to work when all agents were selected. * RT# 74435 - Adding option to allow refunds using electronic check batch with RBC format. * RT# 74435 - fixed errors in posting a echeck refund when no account is listed. * RT# 73964 - Added biling event action to send an email to phone nunber, and updated email a notice to customer to allow emailing to phone number for email_to_voice service. * RT# 73964 - Changed global config send-to-domain to email-to-voice_domain * RT# 73964 - updated config description to better explain the email-to-voice_domain configuration option * RT# 73964 - updated config description again to an even better description of the email-to-voice_domain configuration option * RT# 77498 - Customer Import now uses contact/Import.pm rather than contact_import.pm * RT# 77532 - updated customer search bar to search contacts for info. * RT# 77532 - Updated customer contact reports to display contact phone numers * RT# 77532 - Updated advanced customer report to search contacts * RT# 77532 - fixed search to use phone type from database . [ Mitch Jackson ] * RT# 32233 Mask ssn and stateid in selfservice . [ Ivan Kohler ] * fix error w/current perl - can't call keys on a scalar hashref anymore, RT#77532 * further optimize condition_sql for "Invoice eligible for automatic collection" condition, RT#74451 . [ Mitch Jackson ] * RT# 80543 Crash creating new quotation . [ Christopher Burger ] * RT# 80175 - readded the ability for payment gateway overrides to have an option to be for just ACH * RT# 80175 - fixed error in payment gateway where ACH cardtype was always selected. * RT# 80175 - fixed error with ACH gateway not being selected. * RT# 80175 - changed gateway selection to select either ACH or NULL for echeck payments * RT# 77470 - added reason option to advanced package report with suspended status is selected. Also added links to suspend and unsuspend when status active or suspended is used. * RT# 77470 - Fixed error with select reason drop down box, not working when no pre_options listed * RT# 29974 - Added ability to show invoice_pay_by_message on total new charges line rather than balance due line * RT# 34134 - removed payment amount field from payment screen, added 3 payment options (pay full balance, pay specific invoice, pay another amount) which will prefill the payment amount field. * RT# 34134 - added open invoices selection when selecting pay specific invoice * RT# 34134 - removed config option manual_process-single_invoice_amount from config and payment page that used it. * RT# 34134 - added documentation for new feature * RT# 34134 - fixed error where payment amount field is hidden in self service. * RT# 34134 - fixed error with credit surchage not attached to total * RT# 34134 - Fixed error with amount not being sent when field disabled. * RT# 34134 - fixed initial display of surcharge amount * RT# 34134 - readded config option and move to deprecated section . [ Mitch Jackson ] * RT# 31208,80543 Issue converting quotation . [ Christopher Burger ] * RT# 74435 - Fixed error with refund link on payment history page not allowing batch refund when batch payment was made. * RT# 74435 - added check, to make sure batch format can handle refunds . [ Ivan Kohler ] * harmless, but don't do a string comparison on numbers anyway, RT#79825 * whitespace, RT#79825 * fix phantom customer links . [ Mitch Jackson ] * RT# 32234 Allow unmask of SSN/DL# * RT# 32234 Show unmask widget only if a value exists to unmask * RT# 32234 Change unmask_ss from global conf to group access right * freeside-upgrade - fix uninitalized value warnings * RT# 32234 unmask_ss deprecated - drop from templates . [ Ivan Kohler ] * fix phantom customer links . [ Mitch Jackson ] * RT# 79705 Correct UTF-8 output for generated E-Mail * RT# 79705 fakesmtpserver - saved messages viewable with e-mail client . [ Ivan Kohler ] * fix phantom customer links * fix phantom customer links * fix phantom customer links (fix user links) . [ Christopher Burger ] * RT# 34134 - updated UI experience . [ Mitch Jackson ] * RT# 80624 Selfservice workaround for Bug on Win10 Edge Browser * RT# 80624 Selfservice workaround for Bug on Win10 Edge Browser . [ Christopher Burger ] * RT# 77160 - added date search on customer timespan report * RT# 80898 - added config option to allow for the changing of the name for credit card surcharge on invoice. * RT# 78356 - added speed test fields for broadband service and new modifier to get speed from fcc_477 form in package * RT# 78356 - made status bar more responsive on export. Changed svc update to only happen when up and down speeds change. * RT# 78356 - created import format for broadband service . [ Ivan Kohler ] * fix search failures, RT#77532 * wording * spacing, and order like sql, RT#77532 * cust_main fields only * spacing * cust_main fields only * cust_main fields only * add labels * stop incrementing usage for CF accounts * stop incrementing usage for CF accounts . [ Christopher Burger ] * RT# 78356 - created script to cycle thru svc_broadband and move speed field values. * RT# 78356 - sped up update query . [ Ivan Kohler ] * fix editing employee pw, RT#32456 * fix editing employee pw, RT#32456 * fix editing employee pw, RT#32456 . [ Mitch Jackson ] * RT# 78356 keys on hashref deprecated in perl 5.24 . [ Christopher Burger ] * RT# 77160 - fixed sql when joing cust_location * RT# 77160 - updated date selection sql to make sure last cancel date falls with in range * RT# 34134 - updated select invoice to actually pay the invoice being selected not the oldest one. . [ Ivan Kohler ] * fix deps for deb9, RT#81056 . [ Christopher Burger ] * RT# 78356 - updated script to allow for null values when moving. . [ Mitch Jackson ] * RT# 81150 Google now requires api key for drawing api * RT# 81150 Google now requires api key for drawing api . [ Ivan Kohler ] * v4 styling . [ Mitch Jackson ] * RT# 80669 Cancelled customers on customer churn report * RT# 81183 Fix crash processing payment with new payment method * RT# 80869 Harden process payment screen against Edge browser bug * RT# 80869 Improve cust_payby.paydate validation * RT# 80869 freeside_upgrade fix for bad payment expiration dates * RT# 80869 Improve cust_payby.paydate validation . [ Christopher Burger ] * RT# 75817 - updated UI to be more intuitive * RT# 75817 - removed change password link as it is not needed anymore * RT# 75817 - Added password change link to cust main page * RT# 75817 - added new file to hold javascript for password validation * RT# 75817 - fixed saving of password for new contacts, and password validation on dynamicly created rows * RT# 75817 - cleaned up password validation error message * RT# 75817 - fixed redirect error * RT# 81131 - updated Saisei export to create a virtual ap for multiple ips per customer * RT# 39340 - Created minimal selfservice that only allows payments to be made, authorization is based on ip and mac address. This is not done yet need to write routine to get mac address from radius server based on ip address. * RT# 39340 - configured the minimal selfservice to get mac address from radius account table . [ Ivan Kohler ] * add condition_sql optimization to "Package definitions" condition, RT#74456 . [ Nick Logan ] * RT# 74452 Optimize referral billing event condition * RT# 74452 - address code format change request . [ Ivan Kohler ] * Optimize "Customer has a referring customer" condition, RT#74452 * add condition_sql optimization to "Customer has a referring customer with uncancelled specific package(s)" condition, RT#74456 * optimize declined payment event condition, RT#81305 . [ Christopher Burger ] * RT# 39340 - removed min_selfservice dir and merged into ng_selfservice * RT# 39340 - fixed skin_info caching issue . [ Mitch Jackson ] * rt# 78547 Implement report listing future auto-bill charges * RT# 78547 - Flag to disable email/print/fax/etc during tests or reports * RT# 78547 - consolidate noexport_hack * RT# 78547 - consolidate noexport_hack * RT# 78547 noexport_hack - part_svc::broadworks * RT# 78547 noexport_hack - part_svc::grandstream * RT# 78547 noexport_hack part_svc::http_status * RT# 78547 noexport_hack part_export::ikano * RT# 78547 noexport_hack part_svc::netsapiens * RT# 78547 noexport_hack part_export::phone_shellcommands * RT# 78547 noexport_hack part_svc::saisei * RT# 78547 noexport_hack part_export::shellcommands * RT# 78547 noexport_hack part_svc::sipwise * RT# 78547 noexport_hack part_svc::sqlradius * RT# 78547 bill_and_collect() small optimization * RT# 78547 Library for SQL savepoints * RT# 78547 Allow for simulated billing within a transaction * RT# 78547 Upcoming Auto-Bill Transaction Report * RT# 78547 Future autobill report - agent virt, dynamic title * RT# 78547 Future autobill report - dynamic navigation * RT# 78547 Future autobill report - report runs in job queue * RT# 78547 Future autobill report - sql bugfix * RT# 78547 Future autobill report - report totals * RT# 78547 Future autobill report - report totals * RT# 80624 FS::access_user methods for access_user_pref relation * RT# 80624 Detect and warn for bad MS Edge version * RT# 80624 Browser check repeats if session changes . [ Christopher Burger ] * RT# 80511 - fixed error with sybase db connection * RT# 75817 - fixed selecting random password on custmain page . [ Ivan Kohler ] * fix paymentech batch approval status processing, RT#80622 . [ Mitch Jackson ] * RT# 73421 Add allow messages flag message_dest to contact_email * RT# 73421 Fixed E-Mail pipeline to obey contact opt-in flags * RT# 73421 Fix bug on some "Email customers" report links, docs . [ Ivan Kohler ] * increase paymentech timeout, RT#81278 . [ Christopher Burger ] * RT# 75817 - fixed issue with contact edit on edit customer page . [ Mitch Jackson ] * RT# 79705 Correct UTF-8 output for generated E-Mail . [ Ivan Kohler ] * doc ancient functions as deprecated . [ Christopher Burger ] * Revert "RT# 39340 - fixed skin_info caching issue" * Revert "RT# 39340 - removed min_selfservice dir and merged into ng_selfservice" * Revert "RT# 39340 - configured the minimal selfservice to get mac address from radius account table" * Revert "RT# 39340 - Created minimal selfservice that only allows payments to be made, authorization is based on ip and mac address. This is not done yet need to write routine to get mac address from radius server based on ip address." . [ Ivan Kohler ] * CDR maximum duration, RT#81475 * Import Freeside format CDRs with * in number, RT#81404 * add date to quick payment entry, RT#73382 . [ Christopher Burger ] * RT# 73382 - fixed formatting issue with calendar . [ Ivan Kohler ] * omitting "Detach customer package" from default superuser group, its an obscure specialty feature, RT#81059 . [ Mitch Jackson ] * RT# 31208 Fix Browse Discounts sorting error * RT# 31208 Docs $FS::Record::qsearch_qualify_columns * RT# 80555 Sanitize leading 0's from ip addr input * RT# 80555 freeside_upgrade for invalid ip addresses * RT# 80555 freeside_upgrade for invalid ip addresses * RT# 80555 Clean up code removing leading 0's from ip addr input . [ Christopher Burger ] * RT# 71289 - add contact changes to customer change history * RT# 71289 - fixed duplicate contact changes in customer history * RT# 71289 - fixed error of saving duplicate data when editing contacts . [ Mitch Jackson ] * RT# 30783 Add network block enumerating utils * RT# 30783 Improve speed of ip address auto-assignment * RT# 30783 Selectbox of available IPs when provisioning * RT# 30783 Clean up IP utility code * RT# 30783 Clean up json code for free_addrs * RT# 30783 js fix for ip selection . [ Ivan Kohler ] * fix upgrade: clear bad cust_refund.source_paynum before encrypting, RT#81508 . [ Christopher Burger ] * RT# 38844 - Added customer number and name to commission credit event * RT# 76722 - added option to search on tags not selected in advanced customer report . [ Mitch Jackson ] * RT# 79353 Fix XSS * RT# 31964 Fix XSS * RT# 38217 Fix substitutions for System Log email template * RT# 73422 Changes to report Customer Contacts * RT# 73422 Fix report Customer Contacts * RT# 73422 Agent virt update for report Customer Contacts * RT# 73422 Fix XSS * RT# 73422 Fix XSS * RT# 73422 Contact report - fix customer link . [ Ivan Kohler ] * svc_hardware uniqueness checks, RT#81534 * svc_hardware dup checking, RT#81534 * svc_hardware dup checking, RT#81534 * fix svc_acct->replace on bill, RT#81529 * fix missing plaintext invoice alternative, RT#81486 * make it clearer on the void popup it isn't going to the gateway, RT#81582 * add option to limit automatic unsuspensions to a specific suspension reason type, RT#74448, RT#81634 * doc . [ Christopher Burger ] * RT# 79902 - fixed so change payment information link will still work when upgraded from V3 to V4 and restores functionality in V3 . [ Ivan Kohler ] * textarea for SQL external statements, RT#78543 * more efficient invoice voiding, RT#80366 . [ Christopher Burger ] * RT# 76093 - Added ability to charge a processing fee when taking a payment on the back end * RT# 76093 - added ability for processing fee to be used with batch processing. . [ Ivan Kohler ] * fix pod nits in doc, RT81515 . [ Christopher Burger ] * RT# 74435 - fixed so payment would auto unapply when doing a batch refund * RT# 74435 - fixed error where payment account no longer exists . [ Ivan Kohler ] * doc, RT#81686 * add option for multi-process billing to queue additional jobs for the same customer instead of skipping them, RT#81698 * add option for multi-process billing to queue additional jobs for the same customer instead of skipping them, RT#81698 . [ Mitch Jackson ] * RT# 81608 Improved error msg for Bill Now . [ Ivan Kohler ] * remove debug * Event fee reporting, RT#81713 * Event fee reporting, RT#81713 * delete fees, RT#81713 . [ Mitch Jackson ] * RT# 81712 Reduce unnecessary xmlhttp calls * RT# 81712 Disallow empty feepart for pkg_fee billing event action . [ Ivan Kohler ] * fix pending/invoiced selection, RT#81713 . [ Christopher Burger ] * RT# 81594 - fix package churn report to properly get future revenue value of changed packages . [ Ivan Kohler ] * delete fees, RT#81713 * Option to ignore old CDRs, RT#81480 * add option for multi-process billing to queue additional jobs for the same customer instead of skipping them, RT#81698 . [ Christopher Burger ] * RT# 80138 - Added config option to display/edit customer option to send or not send payment receipts . [ Ivan Kohler ] * doc ship address, RT#33417 . [ Christopher Burger ] * RT# 81730 - fixed XMLHttpRequest async issue, and fixed changed .gov api link. * RT# 81730 - added code to fix possible cross origin request error * RT# 75628 - Added AutoreplyOrCorrespondence template to freeside core RT. . [ Ivan Kohler ] * self-xss, RT#81757 . [ Christopher Burger ] * RT# 81752 - set RBC pay batch import options to use payment date from file rather than file processing date * RT# 79902 - restored functionality to selfservice change_pay so it does not break on v3 to v4 upgrade. . [ Ivan Kohler ] * select agent and customer fields on attachment report, RT#81809 . [ Mitch Jackson ] * RT# 81706 jQuery upgrade * RT# 81706 CSS Menu Fix for jQuery-ui upgrade * RT# 81706 CSS Sub-Menu Fix for jQuery-ui upgrade * RT# 81706 CSS arrow placement Fix for jQuery-ui upgrade * RT# 32243 Implement Selectize.js library * RT# 32243 Package Bulk Edit UI Update . [ Ivan Kohler ] * menu link, RT#81809 . [ Christopher Burger ] * RT# 81126 - IP address field now shows required when required, IP address and Radius Group sticky on error when provisioning svc broadband * RT# 81126 - fixed require svc_broadband ip check . [ Mitch Jackson ] * RT# 76309 E-Mail validation methods * RT# 76309 Add validation for part_event_option.optionvalue * RT# 76309 Validate E-Mail address on billing event action notice_to * RT# 76309 Fix typo . [ Ivan Kohler ] * fix error linking legacy services, RT#81818 * Option to ignore old CDRs, RT#81480 . [ Mitch Jackson ] * RT# 32241 E911 Fee Report - Include fees bundled with packages * RT# 32238 Billing Event cust_birthdate * RT# 32238 Billing Event cust_birthdate - Amended labels * RT# 32238 Billing Event cust_birthdate - Cleaner date compare window . [ Ivan Kohler ] * svc_group, RT#81628 . [ Christopher Burger ] * RT# 81557 - Added checkbox to validate cc on import, and cc validation. . [ Mitch Jackson ] * Revert "RT# 79636,42357 Suppress $0.00 summary line items" . [ Christopher Burger ] * RT# 71289 - now shows contact email and phone changes while attached to customer . [ Mitch Jackson ] * RT# 81830 Critical log event for corrupted invoice data * RT# 81574 Update Google Geocode API that sets location coordinates . [ Christopher Burger ] * RT# 81822 - Added new config for remittance coupon location, updated invoice_latex and invoice_latexcoupon to use new config * RT# 81822 - cleanup footer display when coupon on top . [ Mitch Jackson ] * RT# 81574 Fix FS::GeocodeCache error with set_coord() . [ Christopher Burger ] * RT# 77532 - search count is now correct . [ Mitch Jackson ] * RT# 80514 Selfservice can update ssn/stateid payment info * RT# 80514 Selfservice can update ssn/stateid payment info * RT# 81706 Fix for transparent customer menu tabs * RT# 79916 Makefile copies latex .sty files . [ Christopher Burger ] * RT# 74693 - Added Bulk edit of rates only * RT# 74693 - Added city select when using tax classes * RT# 81596 - fixed freeside-upgrade to not drop custom fields . [ Mitch Jackson ] * RT# 80488 Utility to populate WA tax district table * RT# 80488 Find tax districts for WA addresses using official API * RT# 80488 Allow city select for tax_district_method=wa_sales * RT# 80488 WA tax tables maintained with Cron * RT# 80488 Prevent rollback of system log messages * RT# 80488 Add dependency libspreadsheet-parsexlsx-perl * RT# 80488 Correct typo * RT# 80488 Suppress warnings, disambiguate columns . [ Christopher Burger ] * RT# - added Holidays thru 2025 . [ Mitch Jackson ] * RT# 40206 Add logging to freeside-cdr-mysql . [ Christopher Burger ] * RT# 74537 - fixes error where paytype is blank in V3 . [ Ivan Kohler ] * http exports for additional service types, RT#81945 * pod * pod . [ Christopher Burger ] * RT# 32917 - updated tax report to show pre discount estimated tax * RT# 32917 - Added ability for taxes to be charged prior to applying the discount * RT 81913 - fixed error with batch email from advanced customer reports and contacts report * RT# 37817 - Updated to set condition to check for invoice sending action * RT# 37817 - Added more invoice sending actions * RT# 35259 - Added option to attach a file thru quick ticket creation . [ Mitch Jackson ] * RT# 81706 Remove redundant loads of jquery.js * RT# 81706 Version numbers in js library files jquery, selectize * RT# 81706 Browser reloads CSS after Freeside upgrade . [ Christopher Burger ] * RT# - updated payment gateway override to not drop ACH overrides on upgrade * Revert "RT# - updated payment gateway override to not drop ACH overrides on upgrade" * RT# 80175 - readded the ability for payment gateway overrides to have an option to be for just ACH * RT# 80175 - fixed error in payment gateway where ACH cardtype was always selected. * RT# 80175 - fixed error with ACH gateway not being selected. * RT# 80175 - changed gateway selection to select either ACH or NULL for echeck payments * RT# 80175 - restored ability to set override to ACH only. * RT# 80175 - updated payment gateway override to not drop ACH overrides on upgrade * RT# 81853 - updated contact replace to only add or delete email if it is changed. . [ Mitch Jackson ] * RT# 38217 Log context list includes all contexts, not just predefined * RT# 38217 Improve delete button on log email page * RT# 81706 Include jQuery libraries in header-popup.html . [ Christopher Burger ] * RT# 81249 - added ability to validate price plan option fields * RT# 81249 - Fixed error where empty field becomes 0. * RT# 37817 - added a declaration to cust bill event actions that send out invoices . [ Mitch Jackson ] * RT# 80488 Live look up of WA state tax district * RT# 80488 Validation on cust_location.district values * RT# 80488 Block billing for customer missing tax district * RT# 80488 Banner on customer page when missing tax districts * RT# 32234 Use eye icon for link-replace_element_text widget * RT# 32234 Use eye icon for link-replace_element_text widget . [ Christopher Burger ] * RT# 79352 - updated contact replace to attach existing contact to customer * RT# 79352 - update contact insert to search email list for existing contacts and attach those contacts to current customer on insert * RT# 79352 - fixed so contact replace would not add duplicate cust_contacts. * RT# 79352 - keep original email if all new emails are attached to other contacts on contact replace. . [ Mitch Jackson ] * RT# 82010 Selfservice retries failed socket connection * RT# 81701 Add system log lines for EFT Canada upload/download * RT# 81701 Add system log lines for EFT Canada upload/download . [ Christopher Burger ] * RT# 79352 - fixed insert error where new contacts not tied to customer on insert. . [ Mitch Jackson ] * RT# 30783 Clarify UI checkbox label * RT# 82010 Fix bug where selfservice payment form may not appear * RT# 82010 Disable a debug flag, improve speed of selfservice . [ Christopher Burger ] * RT# 78356 - fixed root path error, and the display of 404 status returns * RT 78356 - fixed display of error on tower and sector exports * RT# 78356 - fix sector issue * RT# 78356 - cleaned up error message display . [ Mitch Jackson ] * RT# 82010 Fix bug where selfservice payment form may not appear * RT# 76181 Invoice date format can set locale from Freeside conf . [ Ivan Kohler ] * fix API new_customer call, RT#82062, RT#28181 . [ Mitch Jackson ] * RT# 81941 Broadsoft R22.0 cdr module * RT# 81961 Include HTML for POD documentation * RT# 81961 Move POD to HTML code into FS::Misc::Pod2Html module * RT# 81961 Generate HTML from POD during debian package install * RT# 81961 Pod to HTML from Makefile . [ Ivan Kohler ] * 2019 * remove out-of-date repeat author info * save skip reason for CDR, RT#81480 . [ Christopher Burger ] * RT# 82087 - added logging for decode json error . [ Ivan Kohler ] * restore fallback to customer billing address for CC transactions, RT#77641, RT#71513 * fix skip_old when date has leading 0, RT#81480 * clarify CDR skipping options only work with prefix rating, RT#81480 . [ Christopher Burger ] * RT# 82087 - updated saisei documentation . [ Ivan Kohler ] * restore fallback to customer billing address for CC transactions, RT#77641, RT#71513 . [ Christopher Burger ] * RT# 82854 - fixed pagination error . [ Mitch Jackson ] * RT# 81961 Repair broken links in POD documentation * RT# 81961 Pod2Html can use installed libs, or Freeside source * RT# 81961 Pod2Html make docs during build, instead of install . [ Christopher Burger ] * RT# 82092 - custom fields now save and fixed so name label is displayed insted of actual field name * RT# 82092 - added field validation * RT# 82092 - Updated text to remind customer to restart apache after creating custom field * RT# 82092 - Removed reload of DB Schema . [ Mitch Jackson ] * RT# 81961 Fix POD error . [ Christopher Burger ] * RT# 82092 - updated escaping html to use encode-entities . [ Mitch Jackson ] * RT# 81961 Pod2Html remove hard-coded perl src dirs . [ Ivan Kohler ] * add classnum exclusion and setup/recur fee multiplication, RT#82943 * fix -C, RT#82943 . [ Christopher Burger ] * RT# 82955 - add script to un refund electronic refunds in batch file * RT# 82955 - fixed batch delete error . [ Mitch Jackson ] * RT# 82955 Fix egc_truncate error in FS::pay_batch::paymentech * RT# 82942 Add FS::DBI, to fix database connection encoding bug * RT# 82942 Force UTF8 client_encoding for Pg in RT::Handle * RT# 82942 Replace DBI->connect() with FS::DBI->connect() . [ Christopher Burger ] * RT# 82087 - updated error messages * RT# 82988 - Fixed so only formats that can handle electronic refunds can download those files * RT# 82988 - fixed resolve credit batches from RBC . [ Ivan Kohler ] * fix svc_group service search fallout, RT#83002, RT#81628 . [ Mitch Jackson ] * RT# 82942 Fix typo . [ Christopher Burger ] * RT# 82988 - added check for batch payment upload scripts to make sure they can handle credit batches. * RT# 82988 - updated paybatch upgrade to move credits from combined batch file to credit batch file * RT# 83044 - fixed cc refund issues * RT# 83044 - fixed so open empty batches not created on upgrade * RT# 82992 - Added new cdr import format ThinQ * RT# 82992 - added documentation to thinq cdr import * RT# 82959 - added agent virtualization to unprovisioned services report. * RT# 82992 - updated documentation . [ Ivan Kohler ] * we're at now now * don't include stack backtrace with email errors, RT#83078, RT#83088 . [ Christopher Burger ] * RT# 83082 - fixed so CC refunds cant go to batch * RT# 83091 - fixed selfserivce to insert payment account if one does not exits . [ Mitch Jackson ] * RT# 81706 CSS arrow placement fix for Mozilla * RT# 81692 Update deprecated syntax in a RT search call * RT# 81692 Update use of deprecated callback element in RT * RT# 81692 Update use of deprecated widgets in RT . [ Christopher Burger ] * RT# 74789 - updated format to handle credits in seperated batch files * RT# 74789 - Updated electronic check batch td_eft1464 format to except refunds (bank credit). . [ Mitch Jackson ] * RT# 81946 Rename conf agent-disable_counts as config-disable_counts * RT# 81946 Implement conf-disable_counts on Package Definitions page * RT# 81946 Implement conf-disable_counts on Service Definitions page . [ Christopher Burger ] * RT# 83057 - Added check for duplicate entry to avoid sql error * RT# 83090 - updated customer search to allow multiple orderbys * RT# 75357 - Prospects can now be disabled * RT# 83075 - fixed sorting by referrals error . [ Ivan Kohler ] * no need for old desktop telephony stuff to show on default new install . [ Christopher Burger ] * RT# 79913 - added ability to mass transfer customers to new agent * RT# 79913 - Mass agent transfer files * RT# 75357 - now new contact row in created in correct place * RT# 75357 - added rows now have same style as original row * RT# 83039 - only towers with sectors shown on provisioning page when export requires sectors * RT# 82087 - added up and down speeds to report * RT# 83203 - made Tower/Sector, speed_up, speed_down required . [ Ivan Kohler ] * no run-time CPAN deps, RT#83178 * fix northern-911 and other unsuspend operations when exports override export_replace, RT#83178 * fix error display un-holding a package, RT#83178 . [ Christopher Burger ] * RT# 83204 - added link to service or tower causing error. * RT# 83211 - Added service export error test report * RT# 83211 - added new report * RT# 83250 - added expected data description to sector fields * RT# 83205 - fixed error with fields being sticky on error * RT# 83259 - adding/editing tower sector will no check for required fields prior to exporting if able to export . [ Mitch Jackson ] * RT# 83122 Update method to merge dupe tax records * RT# 83122 fix dupes on wa_sales tax table updates * RT# 83122 Move wa_tax_rate_update for dist * RT# 83122 Utility to issue credits against taxnums * RT# 83122 Utility to issue credits against taxnums - fix typo . [ Christopher Burger ] * RT# 82132 - updated selfservice login to use config username-uppercase * RT# 82132 - updated password reset by mail to use username-uppercase config * RT# 83147 - Added new error message when email does not match because of case sensitivity * RT# 83251 - created script to update service speeds * RT# 83251 - added documentation * RT# 83251 - added option to only update null fields * RT# 82949 - added the ability to bulk increase package fees (setup and/or recurring) by a percentage * RT# 82949 - changes section name from fees to pricing, better opiton * RT# 82949 - fixed error where form submits on cancel * RT# 83251 - added option to update tower/sector * RT# 83306 - fixed realtime refunds * RT 83251 - moved script * RT# 83341 - added ability to sort by name in advanced customer reports * RT# 83179 - set agent num to use default agentnum if configured, and fixed adding contact rows . [ Ivan Kohler ] * restore our time-tracking hack, RT#83379, RT#81529 * Revert "restore our time-tracking hack, RT#83379, RT#81529" . [ Mitch Jackson ] * RT# 83401 Send country field to B::OP on tokenize * RT# 83401 Catch exception and display suitable error . [ Christopher Burger ] * RT 77532 - added contact phone numbers to advanced customer report * RT# 77532 - created method to display phone types * RT# 75680 - fixed telapi_voip cdr csv import . [ Mitch Jackson ] * RT# 83402 CLI tool to repair wa state tax tables * RT# 82906 Fix typos in script help text * RT# 83320 Fix UI bug managing taxes * RT# 83122 Do not auto-repair wa state sales tax rows * RT# 83122 Fix update tool to properly display caught error . [ Christopher Burger ] * RT# 77532 - can search cust main phone numbers in advanced customer search * RT# 77532 - fixed error where cust main fax not showing, and fixed checking of phonetypenum * RT# 83365 - Added city select to work like back end * RT# 83251 - changed name of script in documentation * RT# 83436 - fixed Advanced Broadband Service Report when displaying phone numbers * RT# 83251 - removed search for unprovisioned services . [ Mitch Jackson ] * RT# 83460 Fix validation bug on part_event_option . [ Christopher Burger ] * RT# 83450 - added fields interface and map_location to export . [ Mitch Jackson ] * RT# 83402 Fix typo * RT# 80488 freeside-wa-tax-table-resolve --merge-all and --fix-usf * RT# 80488 Improve WA tax table update utility * RT# 80488 Ensure WA distrct taxes are properly applied * RT# 80488 Current city value always exists in cities selectbox . [ Christopher Burger ] * RT# 83450 - added location to virtual ap and added script to force update of all virtual ap * RT# 83450 - fixed rateplan export * RT# 82137 - Added ability for processing fee to be pain on seperate invoice. * RT# 82137 - fixed problem with form submit before selecting payment amount * RT# 82137 - default payment amount now has processing fee in total if processing fee exists. * RT# 82137 - added processing fee template substitution. . [ Ivan Kohler ] * fix intro rates packages vs discounts, RT#83503 * clarify interface difference between calc_setup and calc_recur: calc_setup takes a start time, calc_recur takes a start time scalar reference, RT#83503 * spacing, RT#83503 * clarify interface difference between calc_setup and calc_recur: calc_setup takes a start time, calc_recur takes a start time scalar reference, RT#83503 * fix invoicing prorate packages when bill date is edited manually before first billing, RT#83503 * buster (deb 10) * debug * place to track an imported rateid, RT#83146 * planet telecom rate import, RT#83146 * place to track an imported regionid, RT#83146 * show imported region and rate #s, RT#83146 * planet telecom rate import, RT#83146 * infinite CDR update: use billingcode field for dst instead of calltype, RT#83560 * spelling and time * quoting fix for asterisk v12+ CDRs stored in Pg, RT#83146 * work around missing id, RT#83146 * avoid errors trying to import v12-style amaflags to our int field, RT#83146 * use uniqueid if id is missing in v12, RT#83146 * these errors are fatal for now, and fix them, RT#83146, RT#40206 * spacing * CDR efficiency * more efficient invoice voiding, RT#80366 * fix slave IP display * show deb pkg version * catch bad SMTP settings before they error out sending mail, RT#83775 * 4.x style * bulk package cancellation * common element for cust_pkg search form fields * release held packages when automatically unsuspending, RT#83847 * release held packages when automatically unsuspending, RT#83847 * suspend event option to skip packages with a start_date, RT#83847 * add dsl, circuit and fiber services to email and RT ticket exports, RT#84345 * enable mpm_prefork, deb 9+ * clarification * deb 10 * drop apache <2.4 support * remove need for old Locale::SubCountry * just the relevant Pg info * CGI::param called in list context * buster (deb 10) * enable mpm_prefork, deb 9+ * smtp 2525 * no need for FS calendar buttons in RT 4.2 * v4 style * search svc_acct by service def * Email::Sender::Transport::SMTP::TLS no longer needed * deposit slips * fix top subtotals on refund reports * deposit slips * svc_hardware: better error messages for bad hw_addr when not validating as a MAC address, improve label display, RT#84773 * doc: return fields for customer_info, RT#84796 * skip RT sessions table * XMLRPC::Lite split from SOAP::Lite * deb 9 * deb 9 * scrub agent payment gateways * fix rare FP rounding errors on void, RT#84904 * doc/presets for libnss-pgsql use, add sha512crypt option, RT#84826 * add credit reason selection, RT#85046 * ACL for hardware class config, RT#85057 * ACL for hardware class config, RT#85057 * add config to display note at top, RT#84990 * Email::Sender::Transport::SMTP::TLS no longer needed * eliminate some false laziness in FS::Misc::send_email vs. msg_template/email.pm send_prepared :/ * avoid bad libparams-classify-perl * eliminate some false laziness in FS::Misc::send_email vs. msg_template/email.pm send_prepared :/ * eliminate some false laziness in FS::Misc::send_email vs. msg_template/email.pm send_prepared :/ * 4.x-style * 4.x -style * disable fcc 477 deployment zones, RT#85668 * contractually guaranteed speed no longer required as of 2020, RT#85671 * manually enter a paypal payment, RT#85603 * manually enter a paypal payment, RT#85603 * eliminate dups, RT#85671 * 4.x style * 4.x style * fix TeleAPI import (what kind of crack was Christopher smoking that he couldn't fix this for years?), RT#85784 * better height for pkg order popup * 4.x style * bulk change GID, RT#86006 * bulk change GID, RT#86006 * backup the schema for tables we don't need the data from. RT#85959 * quiet warnings about CGI::param in list context . [ James Lucas III ] * Remove orphaned closing . [ Jim Lucas ] * Added support for collecting censustract data from U.S. Census Bureau. Checksums-Sha1: c4201f40bfae317a91d0aa98fa8b1fa89a603c22 5409212 freeside-lib_4.3~git-2022012515_all.deb 860c33577cffced6ada8f4bd2f1ef6627f3668c7 60622 freeside-ng-selfservice_4.3~git-2022012515_all.deb da749475986947d17be30012cac00e0fbe73764c 29080 freeside-selfservice-lib_4.3~git-2022012515_all.deb 93ab15626b2aa6c0b3e67a34aa2e295189d5a676 81768 freeside-selfservice-ui_4.3~git-2022012515_all.deb b9d959cacd091f49893ad7bdff9a6086936ae0b1 343546 freeside-torrus_4.3~git-2022012515_all.deb 1f9676c6b4fa8621b7166e80b5cb41d30a3275e9 5560230 freeside-webui_4.3~git-2022012515_all.deb a9074c356a2f7853e0b69fcee49f8d26561162a8 591808 freeside_4.3~git-2022012515_all.deb 4728830ed5b8f4682d4ae4a94965bf61ef57a86b 10856 freeside_4.3~git-2022012515_amd64.buildinfo Checksums-Sha256: 1bc808576a60ee796cbe6e42f8d135fc90b9ad7392fd670f447457e198524d5c 5409212 freeside-lib_4.3~git-2022012515_all.deb ab31fab07fdd5beb915064f03a82d7b7c9a19d1ab0791f2b5c71138684e970ed 60622 freeside-ng-selfservice_4.3~git-2022012515_all.deb ddafde86914f4a5050be08163c3058b77f8b2e84795b1e650ec33f8b46e59f37 29080 freeside-selfservice-lib_4.3~git-2022012515_all.deb 30ead8a9940a283c5255852ca87d00b433693957740eb95310d4cfb4f31e5e14 81768 freeside-selfservice-ui_4.3~git-2022012515_all.deb 952b78be2353d9144b385ae05a7a50df48dcaa6d2a39eaa2f54d53991976f393 343546 freeside-torrus_4.3~git-2022012515_all.deb 4f87a00703c26de5cb398313931875fb956ee91869e9a72504487e040ae9e3eb 5560230 freeside-webui_4.3~git-2022012515_all.deb 8acf7ba08d04924dd72106f8ca2b3def7fbe600ff794ccb6d57810a13260ef6d 591808 freeside_4.3~git-2022012515_all.deb 18747e466682982fd8bbba2fc8b66fef7b2960a05caacd8a1c2f3b514c216561 10856 freeside_4.3~git-2022012515_amd64.buildinfo Files: ee30402e500083b8a2da80647b7df2b0 5409212 misc extra freeside-lib_4.3~git-2022012515_all.deb 598db43b8c9c1bdd1dbee88d0c2111b3 60622 misc extra freeside-ng-selfservice_4.3~git-2022012515_all.deb 0cf8e845a8dd0bd3c484c0d54322abd5 29080 misc extra freeside-selfservice-lib_4.3~git-2022012515_all.deb a4503bc8ff011344622f027071baabec 81768 misc extra freeside-selfservice-ui_4.3~git-2022012515_all.deb a39f34e160e974713e9d4229c6822c18 343546 misc extra freeside-torrus_4.3~git-2022012515_all.deb 0e9005d4bb0838eec9f61a5909ebf624 5560230 misc extra freeside-webui_4.3~git-2022012515_all.deb 462b2d54b5ce2c8aba4348813125fb5b 591808 misc extra freeside_4.3~git-2022012515_all.deb f8f8530a736fa017286148471b4f5ee6 10856 misc extra freeside_4.3~git-2022012515_amd64.buildinfo