��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧�

��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧� - ��֧էѧܧ�ڧ��ӧѧ�� - /home/alphpwcp/public_html/us/alphachat/modules/lhgroupchat/startchatwithoperator.php

��ѧ٧ѧ�
<?php header ( 'content-type: application/json; charset=utf-8' ); $operators = array( (int)$Params['user_parameters']['id'], (int)$currentUser->getUserID() ); $db = ezcDbInstance::get(); $db->beginTransaction(); try { if (!isset($_SERVER['HTTP_X_CSRFTOKEN']) \|\| !$currentUser->validateCSFRToken($_SERVER['HTTP_X_CSRFTOKEN'])) { throw new Exception('Invalid CSRF token!'); } // We need to find a private chat where only we are the members with another operator $sql = "SELECT DISTINCT `lh_group_chat`.`id`,count(`lh_group_chat_member`.`id`) as `tm_live` FROM `lh_group_chat` INNER JOIN lh_group_chat_member ON `lh_group_chat_member`.`group_id` = `lh_group_chat`.`id` WHERE `lh_group_chat_member`.`user_id` IN (". implode(',',$operators) . ") AND `lh_group_chat`.`type` = 1 AND `lh_group_chat`.`tm` = 2 GROUP BY `lh_group_chat`.`id` HAVING `tm_live` = 2"; $stmt = $db->prepare($sql); $stmt->execute(); $chatId = $stmt->fetch(PDO::FETCH_COLUMN); if (is_numeric($chatId)) { $groupChat = erLhcoreClassModelGroupChat::fetch($chatId); } else { $operator = erLhcoreClassModelUser::fetch((int)$Params['user_parameters']['id']); function getLetters($word) { $letters = ''; $inviter = explode(' ',trim($word)); if (isset($inviter[0])) { $letters .= mb_strtoupper($inviter[0][0]); if (!isset($inviter[1])) { $letters .= mb_strtoupper($inviter[0][1]); } if (isset($inviter[1])) { $letters .= mb_strtoupper($inviter[1][0]); } } return $letters; } $letterName[] = getLetters($operator->name_official); $letterName[] = ','; $letterName[] = getLetters($currentUser->getUserData()->name_official); // Create a group chat $groupChat = new erLhcoreClassModelGroupChat(); $groupChat->name = implode('',$letterName); $groupChat->type = 1; $groupChat->user_id = $currentUser->getUserID(); $groupChat->time = time(); $groupChat->tm = 2; $groupChat->saveThis(); erLhcoreClassChatEventDispatcher::getInstance()->dispatch('group_chat.new_group_chat_room', array('chat' => & $groupChat)); // Create a member $newMember = new erLhcoreClassModelGroupChatMember(); $newMember->user_id = $groupChat->user_id; $newMember->group_id = $groupChat->id; $newMember->last_activity = time(); $newMember->jtime = time(); $newMember->saveThis(); erLhcoreClassChatEventDispatcher::getInstance()->dispatch('group_chat.new_group_chat_member', array('member' => & $newMember)); // Invite another operator $newMember = new erLhcoreClassModelGroupChatMember(); $newMember->user_id = $operator->id; $newMember->group_id = $groupChat->id; $newMember->last_activity = time(); $newMember->jtime = 0; $newMember->saveThis(); erLhcoreClassChatEventDispatcher::getInstance()->dispatch('group_chat.new_group_chat_member', array('member' => & $newMember)); // Send invite message $msg = new erLhcoreClassModelGroupMsg(); $msg->msg = (string)$currentUser->getUserData(true)->name_official . ' ' . erTranslationClassLhTranslation::getInstance()->getTranslation('chat/adminchat','has invited') . ' ' . $operator->name_official . ' ' . erTranslationClassLhTranslation::getInstance()->getTranslation('chat/adminchat','for the private chat.'); $msg->chat_id = $groupChat->id; $msg->user_id = -1; $msg->time = time(); $msg->saveThis(); erLhcoreClassChatEventDispatcher::getInstance()->dispatch('group_chat.new_group_chat_message', array('member' => & $newMember)); $groupChat->last_msg_id = $msg->id; $groupChat->updateThis(array('update' => array('last_msg_id'))); } $db->commit(); echo json_encode($groupChat->getState()); } catch (Exception $e) { http_response_code(400); echo json_encode($e->getMessage()); $db->rollback(); } exit; ?>

| ver. 1.4 | Github | . | PHP 8.2.30 | ��֧ߧ֧�ѧ�ڧ� ��ѧߧڧ��: 0 | proxy | phpinfo | ��ѧ��ۧܧ�