[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

retrieve the preference and last modification of the rates from the billing



Add in the php script and in your database information the preference and last modification date for the destinations concerned by ACD routing.
This information will be in the "Rates" table in porta-billing. I need to check how to obtain the most recent rate, ask me before writing the sql request.

Preference will be needed for calculation of the routing probability, as described in the "ACD routing rejection rate calculator" task. Before this is done, use fixed preferences in the php script and kamailio configuration. The last modification date will be required later.

Store all information in the same table, for example:

id destination vendor acd   preference     modification
1  37410       55     2.8   8              2009-10-20 12:00:00
1  37410       61     2.0   7              2009-10-15 12:00:00