public static function GetConfigBySearchId($searchId)
{
if (strlen($searchId) <= 0) {
return array('ERROR' => 'Config is`t found for undefined number');
}
$orm = VI\ConfigTable::getList(array('filter' => array('=SEARCH_ID' => (string) $searchId)));
$config = $orm->fetch();
if (!$config) {
$result = array('ERROR' => 'Config is`t found for number: ' . $searchId);
} else {
$result = $config;
$result['PHONE_TITLE'] = $result['PHONE_NAME'];
if ($result['PORTAL_MODE'] == self::MODE_SIP) {
$viSip = new CVoxImplantSip();
$sipResult = $viSip->Get($config["ID"]);
$result['PHONE_NAME'] = preg_replace("/[^0-9\\#\\*]/i", "", $result['PHONE_NAME']);
$result['PHONE_NAME'] = strlen($result['PHONE_NAME']) >= 4 ? $result['PHONE_NAME'] : '';
$result['SIP_SERVER'] = $sipResult ? $sipResult['SERVER'] : '';
$result['SIP_LOGIN'] = $sipResult ? $sipResult['LOGIN'] : '';
$result['SIP_PASSWORD'] = $sipResult ? $sipResult['PASSWORD'] : '';
}
if (strlen($result['FORWARD_NUMBER']) > 0) {
$result["FORWARD_NUMBER"] = NormalizePhone($result['FORWARD_NUMBER'], 1);
}
if (strlen($result['WORKTIME_DAYOFF_NUMBER']) > 0) {
$result["WORKTIME_DAYOFF_NUMBER"] = NormalizePhone($result['WORKTIME_DAYOFF_NUMBER'], 1);
}
// check work time
$result['WORKTIME_SKIP_CALL'] = 'N';
if ($config['WORKTIME_ENABLE'] == 'Y') {
$timezone = !empty($config["WORKTIME_TIMEZONE"]) ? new DateTimeZone($config["WORKTIME_TIMEZONE"]) : null;
$numberDate = new Bitrix\Main\Type\DateTime(null, null, $timezone);
if (!empty($config['WORKTIME_DAYOFF'])) {
$daysOff = explode(",", $config['WORKTIME_DAYOFF']);
$allWeekDays = array('MO' => 1, 'TU' => 2, 'WE' => 3, 'TH' => 4, 'FR' => 5, 'SA' => 6, 'SU' => 7);
$currentWeekDay = $numberDate->format('N');
foreach ($daysOff as $day) {
if ($currentWeekDay == $allWeekDays[$day]) {
$result['WORKTIME_SKIP_CALL'] = "Y";
}
}
}
if ($result['WORKTIME_SKIP_CALL'] !== "Y" && !empty($config['WORKTIME_HOLIDAYS'])) {
$holidays = explode(",", $config['WORKTIME_HOLIDAYS']);
$currentDay = $numberDate->format('d.m');
foreach ($holidays as $holiday) {
if ($currentDay == $holiday) {
$result['WORKTIME_SKIP_CALL'] = "Y";
}
}
}
if ($result['WORKTIME_SKIP_CALL'] !== "Y" && !empty($config['WORKTIME_FROM']) && !empty($config['WORKTIME_TO'])) {
$currentTime = $numberDate->format('G.i');
if (!($currentTime >= $config['WORKTIME_FROM'] && $currentTime <= $config['WORKTIME_TO'])) {
$result['WORKTIME_SKIP_CALL'] = "Y";
}
}
if ($result['WORKTIME_SKIP_CALL'] === "Y") {
$result['WORKTIME_DAYOFF_MELODY'] = CVoxImplantConfig::GetMelody('WORKTIME_DAYOFF_MELODY', $config['MELODY_LANG'], $config['WORKTIME_DAYOFF_MELODY']);
}
}
if (CVoxImplantHttp::GetPortalType() == CVoxImplantHttp::TYPE_BITRIX24) {
$result['PORTAL_URL'] = CVoxImplantHttp::GetServerAddress() . '/settings/info_receiver.php?b24_action=phone&b24_direct=y';
} else {
$result['PORTAL_URL'] = CVoxImplantHttp::GetServerAddress() . '/services/telephony/info_receiver.php?b24_direct=y';
}
$result['PORTAL_SIGN'] = CVoxImplantHttp::GetPortalSign();
$result['MELODY_WELCOME'] = CVoxImplantConfig::GetMelody('MELODY_WELCOME', $config['MELODY_LANG'], $config['MELODY_WELCOME']);
$result['MELODY_VOICEMAIL'] = CVoxImplantConfig::GetMelody('MELODY_VOICEMAIL', $config['MELODY_LANG'], $config['MELODY_VOICEMAIL']);
$result['MELODY_HOLD'] = CVoxImplantConfig::GetMelody('MELODY_HOLD', $config['MELODY_LANG'], $config['MELODY_HOLD']);
$result['MELODY_WAIT'] = CVoxImplantConfig::GetMelody('MELODY_WAIT', $config['MELODY_LANG'], $config['MELODY_WAIT']);
}
return $result;
}
public static function normalizePhoneNumber($phone)
{
$phone = preg_replace('/[^\\d]/', '', $phone);
$cleanPhone = \NormalizePhone($phone, 6);
if (strlen($cleanPhone) == 10) {
$cleanPhone = '7' . $cleanPhone;
}
return $cleanPhone;
}
public static function GetQueue($params)
{
$loadQueue = !isset($params['LOAD_QUEUE']) || $params['LOAD_QUEUE'] == 'Y';
$sendInvite = !isset($params['SEND_INVITE']) || $params['SEND_INVITE'] == 'Y';
// TODO check $params
$result = array('COMMAND' => CVoxImplantIncoming::RULE_HUNGUP);
if (isset($params['CONFIG'])) {
$config = $params['CONFIG'];
} else {
$config = self::GetConfigBySearchId($params['SEARCH_ID']);
if (!$config) {
$result['COMMAND'] = CVoxImplantIncoming::RULE_HUNGUP;
return $result;
}
$params['CONFIG'] = $config;
}
if (isset($params['LAST_USER_ID']) && $params['LAST_USER_ID'] > 0) {
self::SendPullEvent(array('COMMAND' => 'timeout', 'USER_ID' => intval($params['LAST_USER_ID']), 'CALL_ID' => $params['CALL_ID'], 'MARK' => 'timeout_inc_3'));
}
$res = CVoxImplantUser::QueuedGetList(array('select' => array('ID', 'USER_ID', 'IS_ONLINE_CUSTOM', 'UF_VI_PHONE' => 'USER.UF_VI_PHONE', 'ACTIVE' => 'USER.ACTIVE'), 'filter' => array('=CONFIG_ID' => $config['ID']), 'order' => array('LAST_ACTIVITY_DATE' => 'asc')));
$findUserId = 0;
if ($loadQueue) {
CModule::IncludeModule('pull');
while ($queueUser = $res->fetch()) {
$orm = \Bitrix\Pull\PushTable::getList(array('select' => array('ID'), 'filter' => array('=USER_ID' => $queueUser['USER_ID'])));
$queueUser['USER_HAVE_MOBILE'] = $orm->fetch() ? 'Y' : 'N';
if ($queueUser['IS_ONLINE_CUSTOM'] != 'Y' && $queueUser['UF_VI_PHONE'] != 'Y' && $queueUser['USER_HAVE_MOBILE'] != 'Y' || $queueUser['ACTIVE'] != 'Y') {
continue;
}
if ($config['TIMEMAN'] == "Y" && !CVoxImplantUser::GetActiveStatusByTimeman($queueUser['USER_ID'])) {
continue;
} else {
if (!$findUserId) {
VI\QueueTable::update($queueUser['ID'], array('LAST_ACTIVITY_DATE' => new FieldType\DateTime()));
$findUserId = $queueUser['ID'];
$result['USER_ID'] = $queueUser['USER_ID'];
}
$result['COMMAND'] = CVoxImplantIncoming::RULE_WAIT;
$result['TYPE_CONNECT'] = self::TYPE_CONNECT_QUEUE;
$result['USERS'][] = array('USER_ID' => $queueUser['USER_ID'], 'USER_HAVE_PHONE' => $queueUser['UF_VI_PHONE'] == 'Y' ? 'Y' : 'N', 'USER_HAVE_MOBILE' => $queueUser['USER_HAVE_MOBILE']);
}
}
} else {
while ($queueUser = $res->fetch()) {
if (intval($params['LAST_USER_ID']) == $queueUser['USER_ID']) {
continue;
} else {
self::SendPullEvent(array('COMMAND' => 'timeout', 'USER_ID' => $queueUser['USER_ID'], 'CALL_ID' => $params['CALL_ID'], 'MARK' => 'timeout_inc_4'));
}
}
}
if ($findUserId) {
if ($sendInvite) {
$crmData = array();
foreach ($result['USERS'] as $queueUser) {
if ($config['CRM'] == 'Y') {
$crmData = CVoxImplantCrmHelper::GetDataForPopup($params['CALL_ID'], $params['CALLER_ID'], $queueUser['USER_ID']);
}
self::SendPullEvent(array('COMMAND' => 'invite', 'USER_ID' => $queueUser['USER_ID'], 'CALL_ID' => $params['CALL_ID'], 'CALLER_ID' => $params['CALLER_ID'], 'PHONE_NAME' => $config['PHONE_TITLE'], 'TYPE_CONNECT' => $result['TYPE_CONNECT'], 'CONFIG' => array('RECORDING' => $config['RECORDING']), 'CRM' => $crmData));
}
}
} else {
$userId = intval($params['LAST_USER_ID']);
if ($userId <= 0) {
$res = VI\QueueTable::getList(array('select' => array('ID', 'USER_ID', 'ACTIVE' => 'USER.ACTIVE'), 'order' => array('LAST_ACTIVITY_DATE' => 'asc'), 'filter' => array('=CONFIG_ID' => $config['ID']), 'limit' => 1));
$queueUser = $res->fetch();
if ($queueUser && $queueUser['ACTIVE']) {
VI\QueueTable::update($queueUser['ID'], array('LAST_ACTIVITY_DATE' => new FieldType\DateTime()));
$userId = $queueUser['USER_ID'];
}
}
if ($config['NO_ANSWER_RULE'] == CVoxImplantIncoming::RULE_PSTN_SPECIFIC) {
if (strlen($config['FORWARD_NUMBER']) > 0) {
$result['COMMAND'] = CVoxImplantIncoming::RULE_PSTN;
$result['PHONE_NUMBER'] = NormalizePhone($config['FORWARD_NUMBER'], 1);
$result['USER_ID'] = $userId;
}
} else {
if ($config['NO_ANSWER_RULE'] != CVoxImplantIncoming::RULE_HUNGUP) {
$result['COMMAND'] = CVoxImplantIncoming::RULE_VOICEMAIL;
$result['USER_ID'] = $userId;
if ($config['NO_ANSWER_RULE'] == CVoxImplantIncoming::RULE_PSTN && $userId > 0) {
$userPhone = CVoxImplantPhone::GetUserPhone($userId);
if ($userPhone) {
$result['COMMAND'] = CVoxImplantIncoming::RULE_PSTN;
$result['PHONE_NUMBER'] = $userPhone;
$result['USER_ID'] = $userId;
}
}
} else {
$result['COMMAND'] = CVoxImplantIncoming::RULE_HUNGUP;
}
}
}
return $result;
}
public static function PrepareEntityInfoBatch($typeID, $entityID, array &$entityInfos, array $options = null)
{
global $DB;
if (empty($entityInfos)) {
return;
}
$enableNormalization = is_array($options) && isset($options['ENABLE_NORMALIZATION']) && $options['ENABLE_NORMALIZATION'];
$elementIDs = array_keys($entityInfos);
$elementSql = implode(',', $elementIDs);
$sql = "SELECT m1.ELEMENT_ID AS ELEMENT_ID, m1.VALUE AS VALUE, m2.CNT AS CNT FROM b_crm_field_multi m1 INNER JOIN (SELECT MIN(ID) AS MIN_ID, COUNT(*) AS CNT FROM b_crm_field_multi m0 WHERE ENTITY_ID = '{$entityID}' AND ELEMENT_ID IN ({$elementSql}) AND TYPE_ID = '{$typeID}' GROUP BY ENTITY_ID, ELEMENT_ID) m2 ON m1.ID = m2.MIN_ID";
$err_mess = self::err_mess() . '<br />Function: GetInfoBatch<br>Line: ';
$dbResult = $DB->Query($sql, false, $err_mess . __LINE__);
if (is_object($dbResult)) {
while ($fields = $dbResult->Fetch()) {
$elementID = (int) $fields['ELEMENT_ID'];
if (isset($entityInfos[$elementID])) {
$value = $fields['VALUE'];
if ($enableNormalization && $typeID === 'PHONE') {
$value = NormalizePhone($value, 1);
}
$entityInfos[$elementID][$typeID] = array('FIRST_VALUE' => $value, 'TOTAL' => (int) $fields['CNT']);
}
}
}
}
public static function normalizePhone($value)
{
if (!is_string($value) || $value === '') {
return '';
}
$result = \NormalizePhone($value, 1);
if (is_string($result) && $result !== '') {
return $result;
}
// Is not valid phone - just clear value
$result = preg_replace("/[^0-9\\#\\*]/i", "", $value);
return is_string($result) ? $result : '';
}
public static function GetNextInQueue($params)
{
CVoxImplantHistory::WriteToLog($params, '!!!GetNextInQueue');
$fistInQueue = isset($params['FIRST_IN_QUEUE']) && $params['FIRST_IN_QUEUE'] == 'Y';
// TODO check $params
$result = array('COMMAND' => CVoxImplantIncoming::RULE_HUNGUP);
if (!$fistInQueue) {
$res = VI\CallTable::getList(array('select' => array('ID', 'STATUS'), 'filter' => array('=CALL_ID' => $params['CALL_ID'])));
$call = $res->fetch();
if ($call['STATUS'] == VI\CallTable::STATUS_CONNECTED) {
$result['COMMAND'] = CVoxImplantIncoming::RULE_TALK;
return $result;
}
}
if (isset($params['CONFIG'])) {
$config = $params['CONFIG'];
} else {
$config = self::GetConfigBySearchId($params['SEARCH_ID']);
if (!$config) {
$result['COMMAND'] = CVoxImplantIncoming::RULE_HUNGUP;
return $result;
}
$params['CONFIG'] = $config;
}
if (isset($params['LAST_USER_ID']) && $params['LAST_USER_ID'] > 0) {
self::SendPullEvent(array('COMMAND' => 'timeout', 'USER_ID' => intval($params['LAST_USER_ID']), 'CALL_ID' => $params['CALL_ID']));
}
$filter = array('=CONFIG_ID' => $config['ID']);
if (isset($params['EXCLUDE_USERS'])) {
$excludeUsers = $params['EXCLUDE_USERS'];
if (!empty($excludeUsers)) {
$filter['!=USER_ID'] = $excludeUsers;
}
}
$res = CVoxImplantUser::QueuedGetList(array('select' => array('ID', 'USER_ID', 'IS_ONLINE_CUSTOM', 'UF_VI_PHONE' => 'USER.UF_VI_PHONE', 'ACTIVE' => 'USER.ACTIVE'), 'filter' => $filter, 'order' => array('LAST_ACTIVITY_DATE' => 'asc')));
$findActiveUser = false;
while ($queueUser = $res->fetch()) {
if ($queueUser['IS_ONLINE_CUSTOM'] != 'Y' && $queueUser['UF_VI_PHONE'] != 'Y' || $queueUser['ACTIVE'] != 'Y') {
continue;
}
$findActiveUser = true;
if ($config['TIMEMAN'] == "Y" && !CVoxImplantUser::GetActiveStatusByTimeman($queueUser['USER_ID'])) {
$params['EXCLUDE_USERS'][] = $queueUser['USER_ID'];
$params['LAST_USER_ID'] = 0;
$result = self::GetNextInQueue($params);
} else {
VI\QueueTable::update($queueUser['ID'], array('LAST_ACTIVITY_DATE' => new FieldType\DateTime()));
$result['COMMAND'] = CVoxImplantIncoming::RULE_WAIT;
$result['TYPE_CONNECT'] = self::TYPE_CONNECT_QUEUE;
$result['USER_ID'] = $queueUser['USER_ID'];
$result['USER_HAVE_PHONE'] = $queueUser['UF_VI_PHONE'] == 'Y' ? 'Y' : 'N';
if (!$fistInQueue) {
$crmData = array();
if ($config['CRM'] == 'Y') {
$crmData = CVoxImplantCrmHelper::GetDataForPopup($params['CALL_ID'], $params['CALLER_ID'], $queueUser['USER_ID']);
}
self::SendPullEvent(array('COMMAND' => 'invite', 'USER_ID' => $queueUser['USER_ID'], 'CALL_ID' => $params['CALL_ID'], 'CALLER_ID' => $params['CALLER_ID'], 'PHONE_NAME' => $config['PHONE_TITLE'], 'CRM' => $crmData));
}
}
break;
}
if (!$findActiveUser) {
$userId = intval($params['LAST_ANSWER_USER_ID']) > 0 ? intval($params['LAST_ANSWER_USER_ID']) : intval($params['LAST_USER_ID']);
if ($userId <= 0) {
$res = VI\QueueTable::getList(array('select' => array('ID', 'USER_ID', 'ACTIVE' => 'USER.ACTIVE'), 'order' => array('LAST_ACTIVITY_DATE' => 'asc'), 'filter' => array('=CONFIG_ID' => $config['ID']), 'limit' => 1));
$queueUser = $res->fetch();
if ($queueUser && $queueUser['ACTIVE']) {
VI\QueueTable::update($queueUser['ID'], array('LAST_ACTIVITY_DATE' => new FieldType\DateTime()));
$userId = $queueUser['USER_ID'];
}
}
if ($config['NO_ANSWER_RULE'] != CVoxImplantIncoming::RULE_HUNGUP && (isset($params['LAST_ANSWER_USER_ID']) || isset($params['LAST_USER_ID']))) {
$result['COMMAND'] = CVoxImplantIncoming::RULE_VOICEMAIL;
$result['USER_ID'] = $userId;
if ($config['NO_ANSWER_RULE'] == CVoxImplantIncoming::RULE_PSTN_SPECIFIC) {
if (strlen($config['FORWARD_NUMBER']) <= 0) {
$config['NO_ANSWER_RULE'] == CVoxImplantIncoming::RULE_PSTN;
} else {
$result['COMMAND'] = CVoxImplantIncoming::RULE_PSTN;
$result['PHONE_NUMBER'] = NormalizePhone($config['FORWARD_NUMBER'], 1);
$result['USER_ID'] = $userId;
}
}
if ($config['NO_ANSWER_RULE'] == CVoxImplantIncoming::RULE_PSTN) {
$userPhone = CVoxImplantPhone::GetUserPhone($userId);
if ($userPhone) {
$result['COMMAND'] = CVoxImplantIncoming::RULE_PSTN;
$result['PHONE_NUMBER'] = $userPhone;
$result['USER_ID'] = $userId;
}
}
} else {
$result['COMMAND'] = CVoxImplantIncoming::RULE_HUNGUP;
}
}
return $result;
}
