
S›P`  ã               @   sb   d  Z  d Z d Z d Z d Z d Z d Z d Z e d Z d	 Z	 d
 Z
 d Z d Z d Z d Z d S)zhtml/api.quiits.com/static/aØ  SELECT ch.`call_from`,ch.`call_to_did`,dd.`did_name`,ch.`call_to`,e.`extension_name`,ch.`call_start_date`,ch.`call_start_time`,ch.`call_duration`,ch.`status`,ch.`call_cost` FROM `call_history` ch LEFT JOIN `did_details` dd ON ch.`call_to_did` = dd.`did_number` LEFT JOIN `extensions` e ON ch.`call_to` = e.`extension_number`WHERE ch.`account_number` = {0} AND ch.`call_start_date`>= '{1}' AND ch.`call_start_date`<= '{2}' ORDER BY ch.`history_id` DESC LIMIT {3} OFFSET {4}zŽSELECT `file_path`,`created_epoch` FROM `voicemail_msgs` WHERE `username` = '{0}' AND `email_status` = 0 ORDER BY `created_epoch` DESC LIMIT 3zcUPDATE `voicemail_msgs` SET `email_status` = {0} WHERE `username` = '{1}' AND `created_epoch` = {2}z„SELECT `member_email_id` FROM `members` WHERE `extension` = ( SELECT `extension_id` FROM `extensions` WHERE `sip_user_name` = '{0}')z¡SELECT `member_email_id` FROM `members` where mbr_role_id IN ( SELECT `mbr_role_id` FROM `member_role` WHERE `account_number` = {0} AND `mbr_role_name`= 'admin')z& ORDER BY {0} {1} LIMIT {2} OFFSET {3}aš  SELECT v.`created_epoch`,v.`username`,e.extension_name,v.`cid_name`,v.`cid_number`,v.`email_status`, v.`file_path` FROM `voicemail_msgs` v INNER JOIN `extensions` e ON e.sip_user_name = v.username WHERE v.`username` IN (SELECT `sip_user_name` FROM `extensions` e WHERE e.extn_group_id IN (SELECT extn_group_id FROM extension_group WHERE account_number={0}) ) AND `created_epoch` >= {1} AND created_epoch <= {2}z AND v.cid_name LIKE '%({3})%'a  	SELECT `created_epoch`,`read_epoch`,`username`,`domain`,`uuid`,`cid_name`,`cid_number`,`in_folder`,`file_path`,`message_len`,`flags`,`read_flags`,`forwarded_by`,`email_status`,`update_status` FROM `voicemail_msgs` WHERE `username`='{0}' AND `cid_name` LIKE '%|%' AND `update_status` = 0zdUPDATE `voicemail_msgs` SET `update_status` = {0} WHERE `created_epoch` = {1} AND `username` = '{2}'zODELETE FROM `voicemail_msgs` WHERE `created_epoch` = {0} AND `username` = '{1}'a=  SELECT `call_from`,`call_to_did`,`call_to`,`call_start_date`,`call_get_time`,`call_start_time`,`call_end_time`,`call_duration`,`call_rate_per_min`,`call_cost` FROM `call_history` WHERE `account_number` = {0} AND `call_start_date` >= '{1}' AND `call_end_date` <= '{2}' AND `call_duration` > 0 AND `status` ={3} LIMIT 5zASELECT `account_number` FROM `account` WHERE `account_status` > 0a   SELECT `call_from` AS 'Source',`call_to_did` as 'Incoming DID',`call_to` as 'Destination',`call_start_date` AS 'Start Date',`call_get_time` AS 'Start Time',`call_start_time` AS 'Answered Time',`call_end_time` AS 'End Time',`call_duration` AS 'Duration (in sec)', `call_rate_per_min` AS 'Call Rate / min (in GBP)',`call_cost` AS 'Call Cost (in GBP)',`call_area_code` AS 'Area Code',`call_location` AS 'Destination Details', (CASE WHEN `status`=1 THEN 'INBOUND' WHEN `status`=2 THEN 'OUTBOUND' END) AS 'Call Direction' FROM `call_history` WHERE `call_start_date`>= '{0}' AND `call_start_date`<= '{1}' AND `account_number`={2} AND `call_duration`>0  AND `status` LIKE '%{3}%'N)ÚCALL_LOG_XL_PATHZSQL_CALL_LOGSZSQL_GET_VM_FILEZSQL_EMAIL_STATUS_UPDATEZSQL_GET_EMAIL_FROM_SIPZSQL_GET_EMAIL_FROM_ACCZSQL_ORDER_BYZSQL_FETCH_VM_LISTZSQL_FETCH_VM_LIST_FILTEREDZSQL_VM_TO_GROUPZSQL_UPDATE_VM_GROUPZSQL_DELETE_VMZSQL_CALL_REPORTZSQL_ACTIVE_ACCOUNTÚSQL_CALL_LOGS_XLS© r   r   ú//var/www/html/sampleapi.quiits.com/constants.pyÚ<module>   s   		
