Download Asternic CDR Reports

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 pass user/pass in url string
• Display the timezone in the admin page for user reference and fix the next run dates
• Add MAILDEBUG option to set mail debug level: 1,2,3,4
• Add SKIP_ENGINE_DETECTION to relay on config parameters instead of config files from known backends

Changed

• Update phpmailer version for security fixes, be sure to add smtp debug to /tmp if debug is enabled in config
• Allow + signs on recording file names, to not strip it
• Add DETERMINISTIC to split_str function to please newer mysql versions

Fixed

• Parse correctly empty lines when parsing buttons_custom.php from fucntions-custom.php
• Try to fix hour match on cron schedules when php timezone is not set by setting timezone programatically,

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
• Add debug on file /tmp/cdr_schedule_error.log

Fixed

• Make several libraries constructors compatible with PHP 7
• Fixed export on 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

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

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
• Add db creation without specifying encoding
• Fix average duration in combined reports

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

Fixed

• Fix warnings on detailed reports and allow > on config file
• Fix collation for user limit range
• 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
• Replace ereg_replace deprecated for preg_replace
• Add money format and symbol to detailed 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
• Fix scheduled reports for groups with spaces in the group name

Added

• Allow grant groups to users, not only extensions
• Added SNEP compatibility
• Add source_field setup option
• Add ignore_short_billable_duration setting
• Add exclude_destination_regexp parameter

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

Fixed

• Fix setConfigDefault for smtp password in admin schedule
• Fix Makefile so it does not overwrite config.php on upgrade
• Fix upgrade table acdschedule
• Force collate to utf8_unicode_ci on channel queries

Added

• Add group filter for API/Scheduled reports
• Add db_charset_collation setting
• Allow to request trial directly from registration form
• Added MySQL upgrade to make upgrade script
• Added MySQL trigger for non session channel insertion
• Add admin license page

Changed

• Modify dashboard to use combined query instead of own query
• Update style for registration tabs page
• Update translations
• New trunk charts with Dynamic resize feature

Fixed

• Update SQL queries to do collate convertion
• Make general functions-astdb better for pjsip conf
• Prevent datetime warnings
• Fix Makefile
• Prefix table acdrcost for destination field
• Update dblib.php with table_exists, column_exists
• Calculate timestamps using timezone configuration

Added

• New 'make upgrade' option for installer
• New feature: scheduled reports via email
• Insert custom javascript code at the end of page
• New configuration parameter exclude_extension_range
• New api.php to extract reports programatically
• New configuration parameter hide_trunk_chart
• Make calldate field configurable
• New configuration parameter hide_cost_column

Changed

• Updated style on registration form
• Updated translations
• Convert Local/xxx- channels to SIP/xxx on queries
• Update functions-astdb.php to read configuration from multiple files
• Update trunks chart with yyyy-mm-dd dates
• Configuration parser more resilient

Fixed

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