1. 使用odbc.ini配置的数据源:dsn:user:pass或者dns
2. 不配置数据源直接连接方法:odbc://DRIVER=driver;SERVER=host;UID=username;PWD=password;DATABASE=db;OPTION=67108864 。 driver(驱
动，windows系统在ODBC数据源可以看到如“MySQL ODBC 5.3 Unicode Driver”,linux系统odbcinst.ini里面配置),host(数据库主机IP，本机：
localhost),username(数据库用户名),password(数据库密码),db(数据库名)。
dbname
This is to specify a different name or path and name of the SQLite database. Useful to put into a ram disk for better performance.
使用SQLite数据库时，用来设置SQLite 数据库文件路径。如果odbc-dsn和dbname都不设置，会使用SQLite数据库，默认路径是.\db\callcenter 。
reserve-agents
If defined to true, agent state is changed to Reserved if the old state is Receiving, the call will only be sent to him if the state get's changed.
This is useful if you're manipulating agent state external to mod_callcenter. false by default.
这个参数的作用是在呼叫坐席之前把agents.state 设置为Reserved。默认值是false，就是不启动这个功能。
truncate-tiers-on-load
If defined to true, we'll delete all the agents when the module is loaded. false by default.
默认false,设置true时,load的时候清空数据库里的tiers表。
truncate-agents-on-load
If defined to true, we'll delete all the tiers when the module is loaded. false by default.
默认false,设置true时load的时候清空数据量里的agetns表。
queues 配置详解配置详解
strategy
The strategy defines how calls are distributed in a queue. A table of different strategies can be found below.
ring-all: Rings all agents simultaneously.（全响）
全部坐席响铃。
longest-idle-agent: Rings the agent who has been idle the longest taking into account tier level.（空闲时间）
下面是longest-idle-agent 模式派话使用的SQL，通过分析下面的SQL，可以看出是 根据 tiers.level , agents.last_bridge_end ,
tiers.position 这3个参数来排序的。last_bridge_end 是坐席最后通话结束时间。
SELECT system, name, status, contact, no_answer_count, max_no_answer, reject_delay_time, busy_delay_time, no_answer_delay_time, tiers.state, agents.last_bridge_end, agents.wrap_up_time, agents.state, agents.ready_time, tiers.position, tiers.level, agents.type, agents.uuid, external_calls_count FROM agents LEFT JOIN tiers ON (agents.name = tiers.agent) WHERE tiers.queue = 'support@default' AND (agents.status = 'Available' OR agents.status = 'On Break' OR agents.status = 'Available (On Demand)') ORDER BY level, agents.last_bridge_end, position
round-robin: Rings the agent in position but remember last tried agent.（循环）
下面是round-robin 模式派话使用的SQL，通过分析下面的SQL，可以看出是按照 tiers_level 从小到大, tiers_position 从小到
大,agents_last_offered_call 从小到大 循环分配坐席的。 。agents.last_offered_call 是最近一次呼叫坐席的时间。
SELECT system, name, status, contact, no_answer_count, max_no_answer, reject_delay_time, busy_delay_time, no_answer_delay_time, tiers.state, agents.last_bridge_end, agents.wrap_up_time, agents.state, agents.ready_time, tiers.position as tiers_position, tiers.level as tiers_level, agents.type, agents.uuid, external_calls_count, agents.last_offered_call as agents_last_offered_call, 1 as dyn_order FROM agents LEFT JOIN tiers ON (agents.name = tiers.agent) WHERE tiers.queue = 'support@default' AND (agents.status = 'Available' OR agents.status = 'On Break' OR agents.status = 'Available (On Demand)') AND tiers.position > (SELECT tiers.position FROM agents LEFT JOIN tiers ON (agents.name = tiers.agent) WHERE tiers.queue = 'support@default' AND agents.last_offered_call > 0 ORDER BY agents.last_offered_call DESC LIMIT 1) AND tiers.level = (SELECT tiers.level FROM agents LEFT JOIN tiers ON (agents.name = tiers.agent) WHERE tiers.queue = 'support@default' AND agents.last_offered_call > 0 ORDER BY agents.last_offered_call DESC LIMIT 1) UNION SELECT system, name, status, contact, no_answer_count, max_no_answer, reject_delay_time, busy_delay_time, no_answer_delay_time, tiers.state, agents.last_bridge_end, agents.wrap_up_time, agents.state, agents.ready_time, tiers.position as tiers_position, tiers.level as tiers_level, agents.type, agents.uuid, external_calls_count, agents.last_offered_call as agents_last_offered_call, 2 as dyn_order FROM agents LEFT JOIN tiers ON (agents.name = tiers.agent) WHERE tiers.queue = 'support@default' AND (agents.status = 'Available' OR agents.status = 'On Break' OR agents.status = 'Available (On Demand)') ORDER BY dyn_order asc, tiers_level, tiers_position, agents_last_offered_call
top-down: Rings the agent in order position starting from 1 for every member.（指定开始位置）
通道变量cc_last_agent_tier_level和cc_last_agent_tier_position默认值为0.
查找座席的排序算法为，先查找 level 等于 cc_last_agent_tier_level，position 大于 cc_last_agent_tier_position 的坐席，然后按照tiers_level,
tiers_position, agents_last_offered_call 排序所有坐席。
SELECT system, name, status, contact, no_answer_count, max_no_answer, reject_delay_time, busy_delay_time, no_answer_delay_time, tiers.state, agents.last_bridge_end, agents.wrap_up_time, agents.state, agents.ready_time, tiers.position as tiers_position, tiers.level as tiers_level, agents.type, agents.uuid, external_calls_count, agents.last_offered_call as agents_last_offered_call, 1 as dyn_order FROM agents LEFT JOIN tiers ON (agents.name = tiers.agent) WHERE tiers.queue = 'support@default' AND (agents.status = 'Available' OR agents.status = 'On Break' OR agents.status = 'Available (On Demand)') AND tiers.position > 0 AND tiers.level = 0 UNION SELECT system, name, status, contact, no_answer_count, max_no_answer, reject_delay_time, busy_delay_time, no_answer_delay_time, tiers.state, agents.last_bridge_end, agents.wrap_up_time, agents.state, agents.ready_time, tiers.position as tiers_position, tiers.level as tiers_level, agents.type, agents.uuid, external_calls_count, agents.last_offered_call as agents_last_offered_call, 2 as dyn_order FROM agents LEFT JOIN tiers ON (agents.name = tiers.agent) WHERE tiers.queue = 'support@default' AND (agents.status = 'Available' OR agents.status = 'On Break' OR agents.status = 'Available (On Demand)') ORDER BY dyn_order asc, tiers_level, tiers_position, agents_last_offered_call
评论0