Download

Added

• Add hide_missed_calls setting and honour that setting in all reports and charts
• Add scheduled detailed report
• Add force parameter to cron.php

Changed

• Update ioncube compiler versions. Add PHP 8 version

Fixed

• Only initiate wavesurfer if container exists. Fixes js console warning

Added

• Allow to set hide_recordings per user name or user level to disallow access to recordings

Changed

• Do not calculate cost if hide cost if set
• Do not set autotls for smtp exchange
• Allow to specify multiple email address separated with comma on scheduled reports
• Use week_mode to determine week start on monday or sunday for cron weekly reports, also be sure to not select more than one week or just one day depending on the day the date is set on the scheduled job
• Add debug on file /tmp/cdr_schedule_error.log if there are problems decoding json data on sched report
• Remove convert collation from query as tables should be normalized

Fixed

• Make several libraries constructors compatible with PHP 7
• Fixed export ono PHP 7.4 due to compatibility problems with mpdf library
• Fixed search on admin/users page
• Fix past week dates to select end date to be sunday -1 week as start is monday -1 week, to avoid getting two weeks. Past week must be run on mondays

[1.1.7] - 2021-04-12

Added

• Add missing translation to spanish
• Allow registering via proxy
• Add french, italian and portuguese to repo
• Use apc cache if available for group by account code query

Changed

• Removal of triggers on CDR insertion
• Do not calculate cost if disposition is not ANSWERED
• Install script detects either php5 or php7
• Match/convert asternic tables schema and collations to cdr table
• Hide cost column in summary if hide cost column is set

Fixed

• Fix typos and prevent some debug warnings
• Remove plus sign from download filename
• Cost calculation is fast again after matching table schemas
• Prevent detailed reports to be shown with no channels selected, fixes security vulnerability information disclosure
• Add db creation without specifying encoding
• Fix average duration in combined reports

[1.1.6] - 2020-05-13

Added

• Add debug for smtp email test send in /tmp/mail_debug.log
• Support FreePBX 15 config file /etc/freepbx.conf,

Changed

• Use a better way to remove -SESSION from channel fields optimizing queries
• use res_odbc user/pass as 2nd connection attempt, improving DB credentials detection

Fixed

• Fix warnings on detailed reports and allow > on config file for when parsing odbc.conf
• Fix collation for user limit range and add cached results for group channels query
• Fix typo in schedule email variable
• Fix charts not showing if single quote in name
• Fix empty extension being added when selecting from home
• Fix initial dashboard stats that now includes all extensiones as default instead of none
• Replace ereg_replace deprecated for preg_replace
• Add money format and symbol to deatiled reports

Changed

• Do not perform cost calculations/joins if hide_cost_column is set

Fixed

• Fixed 100% CPU usage on Chrome browser by upgrading jqPlot library
• Fixed footer on DEVEL version

Changed

• Change cost schema to allow for larger numbers than 99.9999
• Improve test email sending and reporting

Fixed

• Create temp dir if not exist in admin-rates, to avoid errors when importing rates
• Fix sheduled reports for groups with spaces in the grouop name

Added

• Allow grant groups to users, not only extensions
• Added SNEP compatibility
• Add source_field setup option and modify queries to use that parameter instead of the stock cdr 'src' field
• Add ignore_short_billable_duration setting to ignore calls with short billable durations
• Add exclude_destination_regexp parameter to exclude dst field by regular expression, can be used to exclude calls to voicemail or similar feature codes

Changed

• Faster queries if hide_cost_column is set

Fixed

• Fix potential missing calls in detailed reports
• Trigger uses replace instead of insert to avoid fails on duplicate uniqueid

Added

• Audio playback via HTML5 wavesurfer instead of flash Tinywav

Changed

• Set correct title for summary combined report
• Allow export to work on PHP < 5.2.0 by disabling the Excel class and using CSV instead

Fixed

• Fix setConfigDefault for smtp password in admin schedule that might produce a warning
• Fix Makefile so it does not overwrite config.php on upgrade
• Fix upgrade table acdschedule to not give error if table already has the field to be added
• Be sure to set config before checking for db_charset_collation
• Force collate to utf8_unicode_ci on channel and dstchannels for outbound, inbound and combined queries

Added

• Add group filter for API/Scheduled reports
• Add db_charset_collation setting to force MySQL collation and avoid invalid mix of collation error. Also take into account the port on API_URL if set
• Allow to request trial directly from registration form
• Added MySQL upgrade to make upgrade script
• Added MySQL trigger for non session channel insertion acdrunichan
• Add dbsetup options to create tables on upgrade if needed
• Add admin license page to handle license revoke/upgrades

Changed

• Modify dashboard to use combined query instead of own query
• Update style for registration tabs page
• wordwrap on debug pre css change
• Update dbsetup to create acdrunichan table and populate it, and set time limit on script
• Be sure to create acdrunichan database and populated it from dbsetup.php, as populating data is conditional for the table not being already created, so we cannot do it from makefile or static sql files
• Update translations
• Use inverse channel for Local replacement/convert to SIP
• New trunk charts with Dynamic resize feature
• Updated style on scheduled reports page
• Updated styles using bootstrap3 on forms

Fixed

• Update SQL queries to do collate convertion and move to main sql install the creationg of split str function as it requires root
• Continue with sql even if error
• Make general functions-astdb better for pjsip conf where there might be more than one repetition of a section
• Prevent datetime warnings
• Fix Makefile, we cannot have @ to supress ouptut if we have a previous one
• Prefix table acdrcost for destination field on queries as some cdr tables could have a destination field setup already.
• Update dblib.php with table_exists, column_exists and some other fixes
• Calculate timestamps using timezone configuration instead of utc, fixes wrong time axis on trunk charts

Added

• New "make upgrade" option for installer, to upgrade existing installations
• New feature: scheduled reports via email using new API and setup of cron job
• Insert custom javascript code at the end of page via variable $customscript
• New configugration parameter exclude_extension_range to exclude some extensions/destinations from reports
• New api.php to extract reports programatically
• New configuration parameter hide_trunk_chart: hides chart on trunk page
• Make calldate field configurable via config.php so we can use it on MiRTA
• Ability to use variables %Y, %m and %d for recordings_path variables
• New configuration parameter hide_cost_column to setup

Changed

• Updated style on registration form
• Updated translations for new scheduled reports and other functions
• Updated russian translations
• config.php now includes API config variables: API_USER, API_PASS, API_HOST
• Convert Local/xxx- channels to SIP/xxx on queries, that way Followme type local construct will be counted/shown
• Update functions-astdb.php to read configuration from multiple files, including PJSIP and IAX2
• Update trunks chart with yyyy-mm-dd dates as jqplot performs timezone offsets based on client timezone if we use unix timestamps
• Configuration parser more resilitent, accepts => for assignment

Fixed

• Honour significant_channel_chars in all queries and functions
• Fix typo: multi select fields now shows selected values correctly
• Fix undefined warnings here and there