Download

Added

• Add dialed number to recording filename for manual outbound calls in the hotdesk version

Fixed

• Make bitwise comparison with intval to avoid issues editing users (losing level) in modern php versions
• Avoid duplicate clid names in realtime if no channel can be assigned to agent. Fixes show of repeated clid on busy channels.
• Avoid warnings if user does not have queues or agents authorized
• Insert extra closing div for multi report in distribution, and remove it from multireport itself as outbound reports will break the div flow
• Do not export hold/wrapup if they are listed with mixed case

Changed

• Remove trailing slash on void elements to prevent html validation errors
• Plugins compiled with PHP 8.2 ioncube
• Add empty default to info? fields on queue_stats table creation
• Use ~ instead of ; for INSERT and UPDATE for consistencty/match FREEUPDATE
• Change ; to , on the fields table for INSERT an UPDATE in asterniclog because AGI will change commas to pipes

Added

• Add export link to drill down in unanswered reports
• Track automatic campaigns from dialer

Changed

• Do not allow view on edit users
• use set_debug instead of supress_errors in evalmath when debug is on
• Remove incorrect agentsandgroup view definition from mysql-tables.sql install file
• Make pagination %d to %d translatable

Fixed

• Add set_debug function to evalmath class
• show export drill down link even when no pagination is set
• Fix full agent report in scheduled reports
• Make php 8 happy
• If table is queue_stats_mv set condition to real_uniqueid on UPDATE

Added

• Add fill_empty_queues option to include queues with no calls in reports 'by queue'
• Add start and end report dates in CSV filename in scheduled reports
• Support for FOP2 Dialer variables in outbound tracking dialplan. Add support for custom trunks. (hotdesk version)
• Add Summarize plugin

Changed

• FIX ACL to check straight php files without the version tag (.8. .7. .5.) to not break old ACL
• Move outbound disposition events to event_unanswered instead of event_abandoned
• Update outbound tracking dialplan so tag calls work with dialer manual outbound calls
• Modify registration/license routines to be more robust and secure, using SSL
• Add NONE to ajax-search to not filter abandons and the like for users with agent limits
• Install some packages on debian targets via apt

Fixed

• Make php 8.2 happy when editing users or any form with numerical values in a SELET
• Be sure to change working directory in sched_check to not include possible rogue include php files
• Fix outbound tracking context to work with PJSIP
• Fix search when user is using queue groups and has restricted set of queues instead of ALL
• Fix export to PDF when using pdfprint format on some plugins
• Fix whisper transcription on php5, only write debug if debug is enabled
• Force utf8 in mysql connection in update_mix_mixmonitor so we can have proper non ascii chars in recordings
• Fix displaying of license corrupt message when the actual problem is wrong mysql credentials

Added

• New file extensions_custom_asternic version with plus sign for outbound dialing with + at the front
• Add chart_disable_tooltips setting to show chart values directly on graph instead of mouse over tooltips
• Add use_formatted_values_on_export to use formatted output in CSV and JSON (scheduled reports, api access)
• Add SEARCHDEBUG constant to config, to please PHP 8 in search tab
• Add distribution_detail_dates setting to show all dates in distribution detailed report
• Add check-version.php cli so we can verify version from the command line

Changed

• Improved multi PHP version packaging. No need to reinstall when the PHP version changes on the system.
• Unlink uploaded csv file if it does not have valid fields to import. Security
• Update agent field to varchar(100) on update in qagent table
• Set the computed field on some events that were missing
• Check for apcu_xxx functions as in PHP8 it was renamed. The polyfill does not work on php8, the module php-apcu must be installed on php8 for realtime to work

Fixed

• Fixed critical security vulnerability that allowed remote code injection/upload for authenticated users on import function
• Modify .htaccess to prevent php files in uploads, previous one did not work with modern apache
• Code syntax changes to please PHP 8
• Add pjsip dial to extensions custom asternic outbound freepbx. Fixes outbound dialing on pjsip trunks when tracking outbound
• Fixed number of columns in agent availability report
• Added missing TOTAL_TRANSFERRED_RING_TIME to formula fields
• Fixes agent pause report that breaks in some cases when too many pause reasons are set

Added

• Add realtime_fop2_state to check for fop2state astdb entry, requires freepbx_device_user_mode to be enabled. Will count the fop2state as a pause in realtime
• Use dictionary pause in realtime agent status
• Add FREEINSERT and FREEUPDATE events in queue log for free form inserts and updates.
• Added computed field to agent activity sessions so if we compute a start session on outgoing call, we compute an end session on call complete.

Changed

• Use javascript and localstorage instead of cookies to store selected queues and agentes, as cookies are too small and php under fpm might crash when the cookie is large
• Escape double quotes on json export values
• Use klint debug for js console instead of html output
• Set computed bit to 1 for END PAUSES when hold event comes after complete. Add processing AGENT_ custom events in queue_log for future features (AGENT_COUNT to try to report on number of agentes available at any point in time)
• Use ENT_NOQUOTES on htmlspecialchars to preserve single quotes in queue/agent selection as php8 converts them by default and breaks the sql condition

FIXED

• Remove spaces and non alpha chars for pause reason for time_on_xxx variables to avoid errors with regular expressions
• URI Encode value when drilling down so plus signs are preserved and export to CSV works, mostly on distribution by did when the did has a plus sing
• Fix Agent Pause Detail report when there are Hold pauses as it was not removed from the title, breaking the table semantics
• Realtime answered calls column: do not count double if realqueue and dict_queue names are the same. Fix duplicated answered call counts when the queue name and queue number are the same
• Fix distribution drill down sometimes shrinking the view
• Fix custom drill down ajax script for distribution reports

Added

• Add audit_db setting to record audit activity into DB, menu to view audit from setup, add logout audit activity and some other audit fixes
• Export fields that have data-json without breaking the actual json
• Add initial PHP 8 support
• Add uniqueid on connect for dialer preview campaigns and scripter scripts in tracking outbound script

Changed

• Make PHP 8 function declarations changes and fixes
• Do not show wrapup or hold as pause reasons in report.
• Asume local plugins can always be installed
• Custom json format in js updated for unified popover
• Modify popovers to work on focus (click to open , click out to dismiss) and unify popover setup on set_popovers function to change behavior in just one place
• Only show yearly support on perpetual licenses

Fixed

• Collect all TIME_ON_XX from designer formulas. Fixes compute formula errors in some cases
• Show proper error instead of blank page when there are missing PHP modules on the server
• Fixes slow realtime updates because of lack of apc_fetch on FreePBX distro with PHP 7
• Add notification/error when online plugin repositories cannot be reached
• Reset realtime cache when loading realtime.php, keep call count per queue when grouped by group so Calls column on agent shows count in each queue regardless group
• Add csvseparator and quote to realtime to prevent warning on datatables
• Set correct search fields in admin audit page
• Fix realtime limit servers not being read properly
• Prevent warning undef variable session_start
• Set mysql reports off so php 8.1 does not crash on mysql warnings

Added

• Add installed and online versions in plugin administration page
• Add option ot upgrade plugins to new versions from plugins administration page
• Add wkhtmltopdf for Debian 11 to install script
• Add Agent Gantt Diagram plugin
• Add Transcription plugin via Deepgram
• Add Call notes plugin
• Add realtime_spy_leave_local_alone setting to not alter active channel on spy when its local, useful for systems with multiple pjsip devices with 98 and 99 prefix
• Add AGENT_ text variables to compute formula to avoid errors if using them
• Add COLUMN_REALTIME_AGENT support with variables to have custom agent availability reports fields: AGENT_CALLS_TAKEN,AGENT_CALLS_OFFERED,AGENT_CALLS_MISSED,AGENT_ACTIVE_CALL_DURATION,AGENT_ACTIVE_CALL_FROMQUEUE, AGENT_LASTCALL,AGENT_PAUSED_SINCE,AGENT_PAUSED,AGENT_PAUSE_REASON,AGENT_PENALTY, AGENT_QUEUENAME,AGENT_QUEUEMEMBER,AGENT_SESSION_START,AGENT_ACTIVE_CHANNEL,AGENT_CLID_NUMBER,AGENT_CLID_NAME,'NOW'
• Add {SINCE} format to use momentjs time ago for values with unix timestamps
• Add failed_calls and session_start to realtime agent status structure

Changed

• Update menu for agent ranking , agent chart and multi report plugins
• do reload on admin plugin when enabling/disabling
• Create a polyfill for cache for system with no apc available
• Update Agent Ranking and Multireport plugins menu configs to match new version
• Updated bootstrap.css and boostrap.js to latest 3.x version available
• Remove defer pauses when closing session to avoid stray computed unpauses on the following day
• Use EffectiveConnected callerid num and names if available for realtime display
• Allow to add realtime agent status columns based only on the queue member struct variables returned (no formulas), we can show for example 'pausetype'. To do: improve to use full variables and formulas, perhaps add session info to struct to calculate times
• Update style on download/play and action buttons on ajax
• Update style on custom actions buttons, allowed to use fontawesome/tooltips, etc.
• Load enabled plugins plugin/plugin.js files automatically. This way we can have custom js code for plugins in an automated fashion

Fixed

• Allow TIME_ON_XX to be used on formulas on Agent Availability report
• Fix several undfined variable warnings (not errors)
• Added missing dict_transfer description for Admin/Setup page
• Fix typo on setdate
• Allow password with ampersand and other symbols to be used (again)
• Fix drill down on reports group by CLID
• Fix drill down on multi report plugin
• Fix realtime when no apc cache is set
• Fix when loading license related pages in systems without plugins
• Fix on plugin administration page when using pagination

Added

• Add duplicate_import_field so we can do updates on CSV import, not just inserts
• Add agent groups administration, translations and selection
• Add -z (destructive reparse) to asterniclog to reparse deleting newer events from DB, something that is advisable on 2.3.x but requires having complete queue_logs since the moment you want to reprase
• Add realtime_spy_localmap setting to map Local/xxx active channels to SIP/xxx , PJSIP/xxx, etc
• Show subscription on license page
• Add support for scheduled reports with last X hours of data. Selection can be done between days or hours.
• Allow export on Admin/ACL and use the resource for duplicate key imports so we can safely export and import ACL sets

Changed

• Sort pause reasons in agent pause details report
• Honour disabled agents on user edit/add page
• Do not connect to AMI in realtime if values are on APC cache, reduces AMI connection hammering on realtime. Also added MANAGERDEBUG config entry to log manager actions into /tmp/asmanager.log
• Do not allow view on admin queuegroup as dbgrid cannot show them properly (library bug). User can just edit to see if they want
• Update README.outbound documentation to log DialStatus disposition on failed calls instead of ABANDON

Fixed

• Use dictionary queues on queue names in Alert mails
• Fix alert subject not being populated when editing entry in scheduled reports for alerts
• Fix show contents of url and did on CSV export on Answered Calls Details
• Be sure cronhour is large enough to be able to specify multiple hours separated by commans for the full day
• Add default values for datetimeconnect and datetimeend on queue_stats_mv schema to please strict mysql versions
• Update jquery.mark plugin so searches with plus sign do not break the search
• Fixed Alert Subject email not being honored in certain situations
• Fix session times for agent reports when using queue groups
• Be sure to not send disabled scheduled reports
• Fix some typos on mysql-tables.sql to please newer versions of MySQL and MariaDB that are stricter
• Do not try to install php562-pecl-apcu if FreePBX 16 that lacks that package and uses PHP 7. Fixed warning on make install
• Be sure to clear reports array so other jobs in same hour do not send previous reports

Added

• Add override_variables to distribution so we can create specific distribution reports with altered/modified variables
• Add subject to the grid list of scheduled reports to simplify identification
• Add sort for drill down tables on distribution tab, only for queue, agent and datetime fields
• Add primary key to all tables to please DB clustering solutions
• Add CSV export to answered drill down details
• Make last call format configurable via designer COLUMN_REALTIME_FORMAT[lastcall]
• Add configurable subject to scheduled email reports
• Add plugin support to alter queue_log fields, like using pauses for start/end sessions
• Add -o parameter to asterniclog to specify offset seconds, useful when monitoring multiple servers in one database to not lose events when restarting the service after a while
• Allow to specify custom script for drill down without making it serverside (used only on full agent reports)

Changed

• Optimize search a little when using join didname
• Update offline agent check for FreePBX/Issabel with support for SIP and PJSIP agents

Fixed

• Fix area code plugin join table to work with Asternic version 2.3.0
• Show correct support days left in license page, based on system clock instead of encoding time
• Fix sending multiple scheduled tasks that share hour and minute
• Specify table to avoid ambiguous field, fixes search not working in admin / users
• Fix lastdial from astdb and pause since from ami events on asterisk 16
• Make sure to compare numeric last call info. Fixed last call on realtime in some situations
• Fix typo in custom pause format in realtime that prevented absolute seconds from working
• Update help text to remove escaped quotes that confuses users
• Get correct table id for getting custom ajax script if set

Added

• Update asterniclog to handle INSERT from ivrflow
• Add Filter by DID on schedule DID reports
• Add unifyagents command line tool to help unify amibuguos agents in DB
• Add support for COLUMN_SEARCH_FORMAT using javascript functions as defined in custom.js file
• Add more debug to scheduled reports
• Add variable so we can add a custom where condition to answer,unanswer and distribution queries. Used for filter by did on scheduled, could be use on future customizations or plugins
• Add complete audit activity including remote ip address

Changed

• Make cache ami server aware to avoid collisions when multiple servers are used
• Set server on connect into config so we can read it and use it as key for apc realtime cache
• Change on agent name on realtime
• Do not requires basic auth if we have a valid web session for sending mails
• Do not paginate when exporting detailed reports in PDF format from scheduled
• Go back to html/wkhtmlpdf to detailed reports via mail/sched instead of tcpdf reserved for web
• Improvement over the larger callerid display, if there is a tie, compare priority , highest win.. if a tie again, do nothing

Fixed

• Set column names on export on agent pauses report and honour call_time_format in agent full report
• Fix typo in css property causing bad rendering sometimes
• Be sure to populate correctly qagent ALL on purge, was causing missing ALL entry from agents
• Proper string comparing in update_mix_mixmonitor.pl, fixes issue where uniqueid has some letters due to asterisk system id set
• Do not fail to insert TRANSFER with empty position on strict mode mysql/mariadb

Added

• Support for queuemetrics info/tag events to work with reports by tag plugin
• Add did and url columns to callback report
• Add callback_dial_prefix setup for adding a dial prefix to callback reports.

Changed

• Prevent empty values in position integer value, to please strict mode versions of mysql
• Allow double quotes in csv field on export answered detail

Fixed

• Fix callerid showing extension number instead of external number in realtime by comparing lenght of both local legs
• Fix extension and context on action callback
• Remove M() from DIAL_TRUNK_OPTION on track outbound context to avoid conflict with dialplan macros on trunk (set music on hold)
• Add QueueLog action to asmanager for callback plugin (regression)
• Fix REST search for including authorized queues and agentes correctly

Added

• Add issabel override context to catch transfers
• Allow realtime_reports in designer be user specific, so some users can see only a subset of realtime reports if neeeded
• Add dictionary transfer feature for showing friendly transfer locations

Changed

• Use dictionary queues in full agent detail report
• If an unhold pause comes After a complete, insert it normally and remove from deferpause table to not carry on pausing at end of following calls
• Do not compute start pause if ringnoanswer comes before 30 seconds of session close
• Make tag popups for manually dialed calls work when using dialer/hotdesk track dialplan
• Update phpmailer to version 5.2.28. Security fixes

Fixed

• Make sure tag plugin inserts correct join on 2.3.x
• Prevent errors/warnings because undef or missing variables
• Use native db class methods instead of old compatibility functions. Fix rest auth on some scenarios
• Honor authorized queues and agents on search
• Be sure to name recordings out so they get processed by update_mix
• Prevent possible XSS
• Validate request input, prevent possible xss
• Replace strip_tags with htmlspecialchars, they say its better for preventing XSS

Added

• Released 2.3.x family Devel package
• old_mysql setting added for systems with really old MySQL servers that will fail when using subselects
• Auto detection of mysql server version to try to automatically set old_mysql if needed

Changed

• Changed field type to timezon for datetime field on queue_stats_mv so timezone settings affect it as it should.
• Do not insert a computed start session if unpause is received within 30 seconds of logoff
• Changed replace for insert on duplicate key on update_mix_mixmonitor as replace is not performant when there are lots of records in oder mysql versions

Fixed

• Fix XSS and CSRF vulnerabilities.
• Fix sql injection on rest authentication.
• Do not reset list of designer defaults if parameter is empty so we can set custom answered,unanswered and distribution reports.
• Fix timezone setting not affecting reports as datetime field must be set to timezone instead of datetime.
• Fix on scheduled report for distribution outbound.
• Fix PDF export on detailed distribution, answered and unanswered reports.
• Fix on reporting unanswered dispositions on overflow calls that end up other than timeout or abandon. So if you select only the timeout queue, it will report its disposition instead of the last queue disposition. As the change involves using subselects, old_mysql setting was added to disable this feature when using buggy and old mysql servers that cannot optimize subselects and freeze.

Added

• Modify makefile to parametrize mysql binary so we can quickly change in case of PBXware that needs the value /opt/pbxware/pw/sh/mysql, also update installation to recognize Pbxware. Still, asterniclog needs to be packed/compiled.
• New settings realtime_astdb_agent_map_key AND realtime_astdb_queue_members. With this settings we can configure ASTDB queries for Local/xxx agent and real channel mapping, and also for queue membership when using AddQueueMember and agent is not logged in, so we can show it as logged off.
• Allow menu entries to be added when using parameters for like xxxxx_custom?field=xxx
• Add updated block to update cdr and cel (commented) if convert mp3 is set in update_mix_mixmonitor.pl
• Add mail_pdf_filename setting to give option to set the attachment filename for PDF
• Add 59 minute end interval, if the intervals are set to larger than one minute, otherwise we cannot select the whole day
• Add recordings_asterisk_spool setting for update_mix_mixmonitor.pl so we can have it fully working when convert to mp3 and move recording is enabled.
• Add updated block to update_mix_mixmonitor.pl to update cdr and cel (commented) if convert mp3 is set

Changed

• Specify fields with table name prefix to avoid ambiguity issues if users decide to alter table schemas for some reason
• Set version 2.3.1 for intermediate/beta build
• Use dictionary agent on realtime agent status display
• Use dictionary agent on agent detail report
• Use dictionary agent on agent availability report
• Update qagent table schema in sql file
• Strip followme and other nuisances from local channel namings in order to try to find metadata correctly on realtime. Improves realtime channel mapping.
• Allow filtering by agent if all agents are allowed on rest answerd by agent
• If cron day month is 1 and last days is 30, run full past month disregarding 30/31,28 day length on scheduled reports
• Give priority to latest metadata when merging channel info on realtime
• Unset callerid when finding active channel in realtime
• Do not insert ABANDON with agent other than none, honor notabandon from FOP2
• Do not use dictionary queue on rest realtime
• Use queue dictionary on rest realtime, and show agents per queue (instead of grouped)
• Specify fields with table name prefix to avoid ambiguity issues if users decide to alter table schemas for some reason

Fixed

• Fix short_ringnoanswer check on agent reports
• Make clid in realtime work for chan_agent (Issabel CallCenter Community Module)
• Prevent undefined variable warnings
• Fix authorized agents in rest realtime
• Fix scheduled reports when some queues are selected instead of one or all
• Fix csv separator in agent detail report scheduled
• Fix on agent activity pauses where a computed unpause was causing repauses on following calls if there was a real unpause after the computed one. Also removes activity pause records on session end to avoid puase lingering and potential unintended repauses
• Fix short ringnoanswer on drill down agent detail
• Refactor asterniclog helper table creation using temporary tables and lef join as older mysql versions do not like subselects. Fixes asterniclog freezing on older MySQL versions
• Force utf8 and collation on union by queue groups to avoid issues on incorrect collation on some mysql installations
• Fix agent drill down sometimes shrinking or messing with the view/display of columns
• Fix realtime in non grouped mode, broken when making json modifications for REST
• Fix on asterniclog parsing ENTERQUEUE events with more than 3 info fields causing an error in log parsing
• Fixes improvements on the schedule report check: try to sched_check on script directory so relative paths work for attach image, also try to find wkhtmltopdf binary in /usr/local/bin if exists disregarding system path
• Fixes in update_mix_mixmonitor.pl script, more tolerant to on/true/enable settings
• Log parser: Make defer pause work for pauses with no reason also. Fix cases where agent pauses without reason just before finishing a call, that gets ignored otherwise

Added

• Ability to select attachment format on scheduled reports: CSV and PDF
• Add agent administration page. Gives administrators the ability to disable agents from reports
• Add 'buttons' and 'list' view modes to realtime agent status page. New setting: realtime_view_mode setting. Default to 'list'
• Add combined_waittime_on_overflow setting, enabled by default, to show combined wait time in reports and search instead of last queue wait time
• Add config option freepbx_sync_queue_names to set dictionary queues automatically on Issabel/FreePBX systems
• Add custom.css support for overriding css styles and create themes. Included custom.sample.css
• Add custom fields on search tab, allowing to search on custom fields
• Add date to report title on PDF export
• Add session times chart on agent availability reports
• Add support for DESTDIR enviornment variable for Makefil/install script to install on a different location than /var/www/html/stats
• Add hide queue summary option in realtime view, improve hide/show response in realtime.
• Add missing translation for several prompts/strings
• Add multi server support in realtime. Added new admin section for add/remove/edit realtime servers. Regular license allows one realtime server.
• Add new CHART_AGENT to designer so a chart can be added to agent reports. Works for availability for now.
• Add new settings for scheduled emails: mail_body with parameter 'report' or 'alert' to customize mail text
• Add new TIME_ON_XXX to designer, so you can add specific reason pauses columns on agent availability reports. Example TIME_ON_BREAK
• Add 'pdf' target to makefile to download/install wkhtmltopdf
• Add percentage migration indication and better descriptive steps on asterniclog so user knows progress when upgrading data from older versions
• Add realtime-show-clid ACL entry to allow hide/show of clid on realtime views
• Add replay_queuelog tool to replay a queue_log file at the same pace it was procuded, useful for testing load
• Add restart on failure to systemd unit, so asterniclog service restarts if it exit with error for some reason
• Add RINGCANCELED event as noanswer for agent reports
• Add settings for post call recording script: recordings_move, recordings_move_destination, recor1dings_convert_mp3.
• Add short_ringnoanswer_threshold to preferences to be able to filter out ringnoanswers based on duration
• Add status for API realtime response to know if manager connection was successful or not directly on JSON response
• Add uninstall target to Makefile to allow uninstallation of the software (it won't remove the database)
• Add WRAPUP_REASON in designer so we can configure the pause reason for Wrapup, by default is set to 'wrapup', same reason as the auto wrapup FOP2 plugin default
• Add HOLD_REASON in designer so we can configure the pause reason for Hold, by default is set to 'hold', same reason as the auto wrapup FOP2 plugin default
• Allow PDF scheduled reports options using wkhtmltopdf that can be installed from Makefile with target pdf
• Improvde debug for troubleshoting realtime actions
• Improved installation script that caters most centos/debian based setups, adds custom.css and custom.js files and installs for specific PHP version
• Install script asks for admin password during installation, no more default password 'admin'
• Make queue selection in admin schedule honour user filter/restrictions
• Make realtime agent availability columns configurable via designer REALTIME_DISPLAY_ROWS/agent_availability
• Set random password for REST user on install
• Update realtime actions to return proper js/browser notifications
• Use js debugger (Developer console in browser instead of echo on page)

Changed

• Add a little more verbose error on eval math for simpler troubleshooting on designer formulas
• Add footer to PDF export and set page size to legal when in landscape
• Add qagent_view table for improved searches with dictionary agent
• Add report columns for the CLID plugin in report designer
• Add server side processing for agent detailed report
• Agent activity is now processed/materialized via triggers, no need to process during query, making it much faster/responsive
• Agent pause reports shows reasons in an horizontal form with ability to switch between count/time via view button
• Alerts in scheduled reports will check fields only for the realtime queue summary page instead of any report
• Allow trial licenses to be revoked, so a user can upgrade to paid version by revoking via Setup/License page
• Changed toggle switches on realtime view to yes/no so they can be translated
• Change 'Outbound Call' text to 'Non Queue Call' in realtime display
• Check agent names with no accents in real time view to avoid filter out agents with similar names
• Deprecate asterisk_12 and asterisk_18 settings. Settle for old_asterisk
• Deprecate ignore_none_abandons, search_without_subquery,agent_pause_breakdown from setup
• Deprecate save.php
• Do not allow drill down on ADD/REMOVE events in distribution detail report
• Do not insert info5 on queue_stats_mv for transfer events so it does not interfere with tag queue calls
• Do not install asterniclog if /var/log/asterisk is not found
• Do not show empty plugins in license page
• Easier to read color for pauses on agent reports
• Fix heading style on realtime waiting calls for 2nd and up tables
• Fix JSON export for agent disposition, pauses and availability using integer instad of string type where appropriate
• Ignore entries with no datetime set in queue_stats_mv as it causes incorrect durations and wait time calculations
• Improve asterniclog agent activity processing tenfold by using helper tables. Update agent availability report for failed out calls counting
• Increase max execution time in potentially long queries
• Insall plugins from repository will look for the corresponding php version
• Last run set for to one hour for reports, 5 minutes for alerts
• Make agent_row_color toggle on/off for simpler setup
• Make area code plugin to work with 2.3.0 schema
• Modify change of idle time formula to show zero instead of negative if session time is not set
• Modify pause color so it has better contrast on white background on agent reports
• Only output to error_log for asmanager events if DEBUG is true
• Pass version to apli.js to avoid caching issues when upgrading
• Remove logins/logoff for distribution by url/did/tag and add answered display rows for tag
• Remove pauses with 0 duration from agent activity results
• Rename lighter_ami setting to realtime_chan_agent
• Restart asterniclog after make upgrade
• Schema changes are done when doing make upgrade instaed of browsing the home/index page after upgrade
• Set default paused color in realtime to grey
• Set proper ringnoanswer default value if not set
• Set sensible default on timeframe_interval if user sets an incorrect value. Prevents infinite loops
• Simplify cron configuration for scheduled report/alerts by using PHP cli, avoiding complex wget line with user/password authentication
• Specify only UTF8 and no collation on queue_stats_mv table creationg. Set character set client to UTF8
• Stop wav reproduction on Player modal close
• Update CSS styles to be more consistent
• Updated realtime_agent_sort in realtime: possible values are name, status and penalty
• Updated sql definition, do not specify engine so it uses the system default, avoiding possible collation issues
• Update js notifications in callback plugin actions responses, also strip +1 if it is there in the number to dial
• Update jquery to version 3.5.1 and jquery-ui to version 1.12.1 and add compatibility js files
• Update area code plugin to work with asternic 2.3.0
• Use 5 decimals on percentage session formula to avoid rounding errores in column total
• Use chartjs instead of jqPlot as chart library
• Use designer events for search instead of hardcoded ones
• Use materialized queries by default, improving trigger, and with individual records per overflow
• Use pausereason and time from Asterisk 16 if available, no need for realtime_custom_pauses any longer!
• Use pointer cursor style in menus now that we removed the empty anchor
• Use truncate table on purge instead of delete as its faster
• When removing agents in realtime while grouped by agent, it will remove them from all queues.
• When using group filtering, realtime_alarm_xxx setups must be set by group name instead of queue

Fixed

• Added all fields on CSV export for agent dispositions report
• Add mising chosen (select boxes) sprite x2
• Add pause reason on END PAUSE event that happened in some situations
• Do not show cookie agents in home agent selection if they are not really available in DB
• Fix drill down distribution by URL
• Fix drill down in most plugin reports
• Fixes on group filtering in the realtime view
• Fix filtering on search page when selecting groups on home page
• Fix search for outbound calls with dispositions other than 'ABANDON'
• Fix sorting of agent availability on time columns where format is hh:mm:ss
• Fix steal and pickup calls from realtime page for Asterisk 16
• Honour dictionary queue and agent names on searches
• Make datatables CSV export respect csv_separator and csv_quote preferences
• Shows correct expiration info on license page
• MultiReport Plugin drill down pagination respects filter/condition
• Outbound fail dipsosition is now set correctly on install
• Pause since time not shown if not resent in asterisk events and PAUSECUSTOM is not set
• Remove several undefined variable warnings
• Search on russian language does not break by escaping proper characters
• Search works when there are no plugins for url, did or tag installed
• Several fixes to avoid warnings on PHP 7 installations
• Tweak search presentation style to avoid extra space on date field when csv exporting
• Update asterisk manager library to work better with Asterisk 16 and up
• Update REST call endpoint to use mysqli driver so it works with PHP 7
• Update sql definitions to work with recent MySQL/MariaDB and strict mode

• Use last agent on unanswered distribution drill down query as there is no guarantee of order by using regular group by and some abandon events might get assigned to an agent instead of none
• Add csv_skip_summary setup keyword to avoid adding the report summary (date range, queues selection) on Scheduled Rerpots CSV files
• Make exclude logins work on distribution and use group_concat agents instead of long string
• Add audit funcionatlity for successful and failed logins, new keyword audit_log
• Remove stray completeXX events from when attended and blind transfer events are involved
• Add fill_empty_days check on distribution report to fill days with empty/zero data when set to 1.
• When using groups on agent reports, join by first entry on field if list of comma separated, to avoid excluding pause records on multiple queues from showing. Left to do something similar with unpause that has the queue field empty in some cases
• Fix admin users for php 7.1 complaining about incorrect number of parameters in function
• Add CANCEL for outbound as valid event, use designer EVENT_OUTBOUND for it
• Fix typo on clid plugin comment
• Set info4 for DID in trigger scripts for Asterniclog
• FIX bad clock on realtime showing always UTC time
• Add a shell script for agent activity table processing from cron
• Fix missing comma on last JSON element for realtime rest agent status
• Fix rest API realtime agent filtering
• Make sure to set thousand separator on number_format otherwise float numbers will appear empty on csv or json/rest export
• Fix group not showing queues when user has ALL on index, Fix realtime waiting call queue name when group selected
• Fix group filter on realtime
• Search for config.php in reports directory if update_mix has incorrect credentials set infile
• Add support for plugins to update_mix_mixmonitor.pl
• Update customm outbound dialplan for queuelogin/callcenter pro
• Encode URL parameters on sched_createcsv for queues with spaces or symbols in names
• Add port support in host string for MySQL connection
• Add pause reason on computed unpause if login/logout, format fixes
• Be sure to get reason in lowercase for matching wrapup or similar
• Prevent negative call times if call duration is zero
• Honour user filter for group names in realtime
• Fix typo Procensing
• Prevent negative talk times on date rollover
• Add support for URL event in Asterniclog to store a URL variable as DID before the ENTERQUEUE takes place, like for capturing info on IVR, etc
• Disable realtime_agent_availability_override function by returning earlier. Do not update current_timestamp on update for queue_stats_mv definition, fixes problems with dates when materialized_view is set to 1
• Check on agent activity computed close session for today, if timestamp is lower than last db entry (should never ever happen, but life is strange), then equal them to avoid negative session times
• Fix database name in general settings in update_mix script
• Return after UPDATE and INSERT so we do not pollute the real queue_stats or queue_stats_mv tables
• Add UPDATE and INSERT event processing where queue field is the table, agent is the table field and info1 the value to either INSERT or UPDATE
• Change agent_activity datetime field to timestamp so it follows timezone config.
• Fix search date range query for max values
• Fix base href on plugins
• Add missing semicolon on Makefile that generated some error at perlfinal stage
• Update sql definition for queue_stats_mv on SQL directory

• Clear realtime cache when using actions for faster status update after performing actions
• Cancel timeout when performing actions in realtime, fix realtime being heavy after actions are performed
• Clear vars on realtime agent status so metadta won't 'leak' for subsequent agents
• Fix waiting calls display in realtime when group filter is set
• Add realtime_hide_agent_unauthorized_queue: will not show status and metadata on agents that are busy on a different queue if that queue is not authorized for the user
• Fix waiting calls and max wait time in realtime queue summary when groups are selected
• Fix permissions display when groups are selected but user has limited queue access on distribution, answered, unanswered and search
• Fix realtime view when group queues are selected, stats in summary show correct now
• Fix drill down distribution on plugin/extra fields
• Fix drill down on distribution when using queue groups
• Set label to None when empty in charts, to avoid using 1 instead
• Do not use formated value in charts if format is not numeric
• Allow having more than one field in parameter inside JOIN_TABLE like 'field AS RATING1, otherfield AS RATING2' to get more than one extra variable in CUSTOM_ reports, good for using with multi questions quality surveys
• Allow to use answered_calls_by_custom.php and friends to work by passing a ?field=xxx to them, and set them up directly on desginer answered_reports and friends, so no actual code modifications are needed when adding table_jo ins for adding extra fields to reports
• Add decimail_point setting to change the character used for decimals on number format
• Use trunk suffix on failover outbound dialplan
• Check for transfer recordings in update mix post processing
• Add cache to realtime, making it lighter for Asterisk. Requires php apc cache module to be installed
• Fix on Makefile that generated an error at the very end
• Add mail_smtp_selfsigned preference to allow self signed certificates in SMTP connections
• Fixes on Agent reports by not counting pauses when agent is on a call, as pause time will overlap talk time and ends ups with negative idle times
• Fixes on Agent reports when some login/logout events were not accounted for
• Track real disposition for outbound calls (BUSY, CANCEL, INVALID) instead of storing them as ABANDON when failed
• Use all enumerated queues for pause events, so if a report includes only one queue of many for pause, event still shows
• Fix Agent Ranking wrarnings

• Do not use info2 as duration on TRANSFER events as BLINDTRANSFER and ATTENDEDTRANSFER use info2 for different purposes. Fix problem with high talk duration on attended or blind transfer events
• Change uniqueid on TRANSFER events to discern from 2nd part of the call and account for them
• Fixed XSS vulnerability in login page.
• Dissallow some extensions from download to prevent leaks in case of misconfigured recordings_path setting
• Use generic dictionary function for dictionary entries, extend dictionary for did and url so now dict_did and dict_url are valid keyword setups
• Update makefile to use systemctl if available
• Allow to Search by dictionary agent name
• Add lighter_ami option to setup/preferences that will reduce the amount of AMI calls in Realtime
• Update relatime to use old_asterisk and manager_show_channels_command to play with different asterisk versions core show channels concise field order and command, replacing asterisk_12, asterisk_16 and asterisk_18 keywords
• Fix drill down on agents with single quote in their name
• Add OUT_FAILED_CALLS and TOTAL_OUT_FAILED calls to agent availability reports and column failed out calls to agent disposition reports
• Set color for agent detail report for start call always instead of inherit last color
• Add autocomplete TOTAL_COLUMN_AGENT to designer
• Fix multireport plugin to work from version 2.2.4
• Count cancel and failed on agent activity individually and after each subsequent event
• Update asterniclog trigger to store outbound dispositions

• Fixed sort by waittime in search orders by number and not text.
• Add lighter_ami setup option that will not poll for agentcallback variables, used only on asterisk 1.4 or older
• Allows to specify uniqueid or clid in search query to have a link to retrieve a particular record (/stats/search.php?uniqueid=1234&start=2018-0701 )
• Fixes for PHP7 compatibility
• Add download icon to distribution drill down details that was missing
• Agent reports reworked, more consistent on edge cases and dirty data
• Fixes trigger for materialized view to not update timstamps on record update
• Added MAILDEBUG option in config.php
• Added realtime_invert_clid to setup to swtich dialed number/callerid, might help if you see own extension instead of clid on realtime view
• Fixes on realtime REST results

• Fixes missing data on agent_activity tables that lead to incorrect numbers on Agent tabs.
• Add discrete_transfer setting to bring back old transfer report functionality if only some queues are selected in answer reports
• Fix possible unaccounted unanswered calls if they have a ringnoanswer disposition at the same moment than abandon or timeout
• Fixes incorrect number of days (period) in report Summaries when daylight savings time happens on the selected date range
• Save agent and queue selection in cookie for remembering on next login
• Modify css styles so large queue lists do word wrap in table cells
• Make action buttons to spy visible but disabled if agent is free or not available

• Automatic dictionariy queue names for Issabel/FPBX on Install.
• Fixes on JSON realtime page that was polluted with js code>
• Fixes on agent limit/filter on detailed agent reports
• UPDATETRANSFER event hack for Asterisk 11 systems where transfers are not logged
• Fix menu duplication when plugins are installed

• Better licensing pages. Allows for automatic trial code request/deliveries.
• Fixes on realtime page, consistent styling, shows Agent/xxxx
• Fix on grid component and multi select boxes, so selection is based on index and not value. Fixes possible bug with ghost selections on system with hundreds/thousands of queues
• Makefile improvements. Even simpler to install
• Search works with queue groups now

• Update styles to use Bootstrap 3 and Datatables component, making possible sort by column, hice column, change pagination, etc.
• Add support for plugins to extend functionality
• Add option to export designer changes, so you can export/import custom reports/layouts
• Improve Scheduled menus to notify users about potential configuration issues with REST
• Update phpmailer to latest version to fix security vulnerability
• Added alternate realtime views for agent availability
• Refactor agent reports using intermediate table agent_activity
• Add a new pseudo materialized view (value 2)
• Updated asterniclog to check consistency of tables and data on startup
• Add License handling options via web GUI
• Unanswered events are now configurable via report designer
• Add distinct ACL entries for realtime actions (spy, coach, steal)
• Improved realtime display on Asterisk >=13
• Improved search page
• Add custom actions to realtime
• Change DB library to use mysqli so it works with newer php versions
• Use wave surfer plugin for recording playback

• Fix csv export on answered call details (added ringtime field that was missing)
• Added yesterday shortcut to Home tab
• Update/Fix generate outbound routes contexts php script to use full prefix
• Use dictionary queue on login/logoff for multiple queues
• Remove ring time subquery that is too slow from distribution queries
• Allow search for clid via rest ?entity=search&clid=1234
• Accept YYYY-MM-DD as 3rd parameter in update_mix_mixmonitor.pl so we can run from batch on old files passing the date instead of using today's date
• Fire userevent on extensions_custom_asternic_outbound so the Tag Queue Call plugin works with outbound calls
• Ability to set status colors via Designer
• Add reports by tag field
• Fix selection of year in home tab from outside default range

• Add reports by did and show_did_field setting (separating them from url reports)
• Rest reports now includes custom reports when using JOIN_TABLE in designer (for call tags or similar reports)
• Refactor Agent reports to have better handling of session time when multiple queues are involved
• Add realtime_alarm_pause_duration_type to alarm pause for reason
• asterniclog will now stop when the complete file is processed when run with --purge option
• Update asterniclog so it converts BLINDTRANSFER and ATTENDEDTRASNFER events as just TRANSFER
• Add -g logdir option to asterniclog to save to asterniclog.log
• Remove plus sign from destination filenames in update_mix_mixmonitor.pl so the web download and play works fine
• Real Time Clock honours the timezone setting
• Fixes for MySQL 5.6 compatibility
• Fix on search query, avoiding subqueries make it faster/work.
• Use the application title on mail body instead of hardcoded 'Asternic'
• Remove stray % sign on csv export for agent dispositions
• Add REALTIME_COLUMN_WIDTH_GROUPED to report designer
• Add ACL queueactions to allow or disallow all actions in realtime
• Add ACL logout-pause-agents to allow or disallow options to logout and pause unapuse in realtime
• Fix basepath so asternic installed on webroot on server works fine
• Add support for grouping queues, so you can run reports by 'group' or individual queues
• Asorted Fixes on REST interface: short_abandon honored, queue filters honored, etc.
• Separate url reports from did reports using info5 field with newer asterniclog, so we can have reports by Tag and by DNID at the same time
• Add trigger script option to asterniclog daemon (-t)
• Add dict_pause setup in order to setup friendly names for pause codes
• Read LASTDIAL ASTDB entry for shared_last_call setting so it updates last call info in realtime for outbound calls
• Add realtime_agent_sort option by name

• Fix showing custom columns/fields only if COLUMN_XXX is set
• Updates to mysql queries to work together with tagQueueCalls FOP2 plugin
• Add reports_by_custom.php
• Updates asterniclog to work with UPDATEFIELD events as set by the tagQueueCalls FOP2 Plugin
• Change some asterniclog references to tailqueuelog
• More verbose license version message
• Add ACTIONDEBUG in config.php to have a debug on spy actions written to /tmp/steal.log
• Fix realtime when having real Agent/xxx and dict_agent not showing
• Fix column name % ses time in agent availability
• Fix typo in asterniclog help for daemon option
• Fix makefile php version
• Be sure to not abort real time status if agent is of kind Agent or SIP for pbxware or asterisk 1.6
• Add restUser to database users sql definition

• Add targets to Makefile so we can install parts of it
• Add option to request individual html reports using url user=xxx\&password=yyy\&start=xxxx\&qeueus=all\&report=xxxx\&nomenu=1 for future ghostjs pdf exporting, also BIG change in session calculation in process_agent_query and process_agent_query_detail
• Fix exporting graphs on pdf for distribution with keyflow
• sanitize filename on save.php
• set uft8 for mysql connetions on asterniclog/tailqueuelog and if we can set charset from php, set it to utf8 also
• Fix autocomplete in admin page that was broken on last version
• Close pipe when querying agent names in tailqueuelog/asterniclog
• Always load english for showing help text in english if there is no native translation
• Add realtime_last_hour_stats to show only last hour stats on realtime view
• Be sure getqueues in rest shows all queues when there is no filter
• Fix schedule reports to use auth context in every rest step
• Fix json and rest agent and queue filters
• Check license for plugins in menu
• Fix json in realtime agent wall
• In realtime set waiting calls to zero instead of null if there is no data
• Fix holdtime in distribution query for events not completecaller/completeagent
• Drill down on answered detail with file recording works now, Fixing uniqueid of div/javascript call. Also be sure to output a comma if json only in realtime.
• Default to ALL in authorized agents/users when no user is set (for rest schedule to work)
• Make asterisk running check for asterniclog service check for asterisk process and not asterisk owned processes
• remove preFix from generate outbound routes for predial hook failover routes
• Allow spaces on agent names in outbound tracking macro
• Try to use subqueries to optimize searches by uniqueid or clid
• Make dbgrid work with multi select on param and value
• Make menus and index and login form relative/absolute path aware for plugins
• Add sorting of agents in realtime agent status
• Add realtime_agent_sort to setup to allow sorting of agentes in realtime view
• Reduce font size to 11
• Add agent logoff action in realtime
• Add location for realtime agent status as title to see it in tooltip over agent name
• Show pause icon on relatime agent status
• Add pause/unpause actions to realtime
• Add queue add/remove/pause to asmanager
• Do not show not selected agents in realtime agent status
• Extra parameter to head_report to pass column width
• Add realtime_tracking_mode to chan spy, so spy sessions do not end when a call is hangup
• Add REALTIME_STATUS_COLOR in designer, to allow changing of color states
• Fix last call info in real time that was inherited to downward agents
• Add custom outbound with failover and php script to generate related dialplan, so outbound track works with failover routes in freepbx
• Add -skip option to asterniclog to sip sip/iax for use with hotdesk
• Add answered call by url / agent
• add filter field and value to answered ajax
• Add filterfield and value to answered_reports function to have extended custom reports (all options drilled down)
• Add AGENTS_INPENALTY in auto complete in designer
• Move mixmonitor in outbound tracking to external leg so it records after transfer
• Add AGENTS_INPENALTY to queue summary variables
• Fix CSV export on distribution, missing url field for drill down export
• Add extensions_custom_outbound for use with the FOP2 hotdesk plugin
• Add option to export the drill down data in distribution reports
• Display agent penalty in realtime
• Format Fix in realtime functions
• Fix json on realtime agent wall
• Add asterniclog start to makefile
• Format Fix in sched createcsv
• Aadd agent pauses, dispositions and details to REST
• Add json exporting to new reports (outgoing) and not show agent none in agent detail report
• Translated text in admin acl
• Avoid duplicate authorized queues and agentes in REST
• Fix safe tailqueuelog typo
• Increase verbosity on error on donwload.php
• Replace # with %23 on filenames
• Add ringcancel and dictionary_custom
• Fix typo in safe_tailqueuelog
• Be sure distribution by url is only shown if show_url_field is set
• Remove old code from agent query
• Fix distribution by agent php and set in mysql sql definition
• Fix max callers when old asterisk log and info2 is null or empty
• Fix search with autocompleted queues
• Add Makefile for easier installation
• Set font for export pdf on search
• Add literal text with initial single quote to evalmath, so it is possible to add text on designer formulas
• Default to position 1 when lack of info2 and info3 in exitwithtimetout, do not use binary comparison on materialized queries
• Make better headers for csv exports in schedule
• Do not use comma as thousand separator in csv export to avoid conflicts with separator
• some Fixes to extensions_custom_dialout de freepbx, agent name with no spaces, check if ampuser exists or otherwise continue normally
• Fix ringnoanswer 0 no insertion in tailqueuelog-source
• Fix in realtime to show outbound calls duration/clid in latest asterisk
• Prevent warnings
• Add mail_report_subject and mail_alert_subject to config and sched send
• Add wrapup setting to admin setup
• Fix agent with magic-gpc off
• Use Rest URL in sched_check
• Do the stripslashes/addslashes to agent string for single quotes in agent names
• Use prepared sql queries on tailqueuelog/parselog/tailcel
• Add mixmonitor transfer to handle recordings of blind transferred calls
• User prepared statements in tailqueuelog
• Add all fields on agent session exports
• Modify include-sesvars to escape agents with quotes

• Fix json export on call flow distribution
• Fix tailcelfreepbx and tailcel when recovering from crash
• Add class to download icon
• Fix warning on footer when oth.php
• Update html2pdf to latest version
• Add call flow to distribution summary (for outbound reports)
• Add pbxware and freepbx device to setup
• Fixes to scheduled reports, image atachment, etc
• Close php session on ajax realtime
• Allow to schedule reports for one specific queue instead of all
• Add freepbx device user check to realtime

• Fix drill down on distribution for call flow
• update mysql-tables to 2.0.6
• Merge again call flow changes to misc.php
• Fix header on realtime display to be able to group even if not all queues are shown, also add debug from localhost
• Pass complete query string when login in with user /pass
• allow set queues in get request to start realtime as wallboard
• Add tailcelfreepbx

• Add trigger.sql to repository
• Fix typo in tailqueuelog for long info events
• Update menu to accomodate distribution outbound reports
• Remove comments
• Updates and improvement in realtime view
• update sql definitions for translations

• Fix mysql-tables sql to avoid duplicates (remove autoincrement in dump)
• use replace instead ot insert in update_mix in order to get last filename when overflow occurs
• Add call flow in distribution in out, improve realtime agent reports
• Fix ringnoanswer 0 in tailqueuelog
• Add materialized to sql queries
• Add autocomplete and uniqueid to search

• Fix agent/queue dict names and selection on admin-user
• Allow literal and or in clid search
• Set general timezone if no user timezone is set
• Fix incorrect grouping in distribution query
• Filter ring no answer zero in agent dispo drill down

• Fix rest export of answered detail to include zero length calls and add uniqueid to csv exporting
• Change agent query to calculate times based on timestamps for errors in info2 field
• Add custom pauses with fop2 support
• add safe_tailqueuelog script
• Fix for asterisk 1.6 in realtime
• insert default qagent and qname when purgin tables in tailqueuelog
• Change default smtp user and pass plus minor bugFixes
• Fix default_start_hour and default_end_hour
• Fix export agent_durations
• Fix realtime to not stop when acl does not include summary
• Update parselog to use info4 field

• Realtime uses designer instead of being hardcoded
• Bug Fixes in Realtime
• Updated noty js library
• Fix export icons when using wide character languages
• Fixed minimum session time in agent summary if there is no data
• Added scheduled reports option
• Added custom_reports in setup to allow custom tabs
• Improved error display when mysql credentials are wrong
• Added SLA variable to realtime reports
• Add patch for recordings on FreePBX 2.10
• Added tailcel script
• SQL Realtime table is now cached per user
• Fixes to avoid warningson PHP 5.3
• Fix on short abandon in unanwered reports
• Fix dict_agent on realtime page
• sla_xxx variables can be set per queue
• Add queuelog action to asmanager.php to fake queue events in log from script
• Add callerid name to realtime page using AMI Status, also added column widht for realtime agent table
• Fix avg metric in unanswered calls summary
• Update tailqueuelog to have variable info field insert and bind values
• Fix realtime agent status markup when grouping by queue
• Update tailqueuelogFreePBX28 to use a better insert in process line
• Built in parse_json when json support is not available in php
• Fix realtime agent display for agents with dash in names
• Make javascript and jqplot ie8 compatible
• Use dictionary names in user setup
• Fix delimiter for old asterisks (asterisk_12) in realtime spy coach
• update sql tables definition to add languages