Events.php 63 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771
  1. <?php
  2. /**
  3. * This file is part of workerman.
  4. *
  5. * Licensed under The MIT License
  6. * For full copyright and license information, please see the MIT-LICENSE.txt
  7. * Redistributions of files must retain the above copyright notice.
  8. *
  9. * @author walkor<walkor@workerman.net>
  10. * @copyright walkor<walkor@workerman.net>
  11. * @link http://www.workerman.net/
  12. * @license http://www.opensource.org/licenses/mit-license.php MIT License
  13. */
  14. /**
  15. * 用于检测业务代码死循环或者长时间阻塞等问题
  16. * 如果发现业务卡死,可以将下面declare打开(去掉//注释),并执行php start.php reload
  17. * 然后观察一段时间workerman.log看是否有process_timeout异常
  18. */
  19. //declare(ticks=1);
  20. use \GatewayWorker\Lib\Gateway;
  21. use Workerman\Lib\Timer;
  22. use Workerman\Worker;
  23. /**
  24. * 主逻辑
  25. * 主要是处理 onConnect onMessage onClose 三个方法
  26. * onConnect 和 onClose 如果不需要可以不用实现并删除
  27. */
  28. class Events
  29. {
  30. /**
  31. * 新建一个类的静态成员,用来保存数据库实例
  32. */
  33. public static $db = null;
  34. public static $global = null;
  35. public static $redis = null;
  36. public static $logic = null;
  37. const KFINFOKEY = 'KFINFO'; //客服信息hash表
  38. const USERINFOKEY = 'USERINFO'; //用户信息hash表
  39. const USERLIST = 'USERLIST'; //用户排队表
  40. const SERVICELOG = 'SERVICELOG'; //工单信息
  41. const WEBSOCKALLUSER = 'WEBSOCKALLUSER'; //所有连接
  42. /**
  43. * 进程启动后初始化数据库连接
  44. */
  45. public static function onWorkerStart($worker)
  46. {
  47. include_once(__DIR__ . DIRECTORY_SEPARATOR . "Mlogic.php");
  48. self::$logic = Mlogic::GetInstance();
  49. self::$db = self::$logic->getDb();
  50. self::$redis = self::$logic->getRedis();
  51. self::$global = self::$logic->getGlbData();
  52. self::TimerThing($worker);
  53. }
  54. /**
  55. * 每分钟定时向客服发送一次排队情况
  56. */
  57. public static function lineup()
  58. {
  59. $group = self::$global->groupmap;
  60. foreach ($group as $groupid => $gname) {
  61. $users = self::getUselistData($groupid);
  62. if (!empty($users)) {
  63. Gateway::sendToGroup('group_' . $groupid, json_encode(['type' => 'lineupCount', count($users)], 256));
  64. }
  65. }
  66. }
  67. /**
  68. * 当客户端连接时触发
  69. * 如果业务不需此回调可以删除onConnect
  70. *
  71. * @param int $client_id 连接id
  72. */
  73. public static function onConnect($client_id)
  74. {
  75. // 检测是否开启自动应答
  76. $sayHello = self::$global->replay['1'];
  77. if (!empty($sayHello) && 1 == $sayHello['status']) {
  78. $hello = [
  79. 'message_type' => 'helloMessage',
  80. 'data' => [
  81. 'name' => '智能助手',
  82. 'time' => date('H:i'),
  83. 'content' => $sayHello['word']
  84. ]
  85. ];
  86. Gateway::sendToClient($client_id, json_encode($hello, 256));
  87. unset($hello);
  88. }
  89. unset($sayHello);
  90. // 检测是否开启广告
  91. $advertisement = self::$db->query('select * from `ws_advertisement` where `advertisement_status` = 1');
  92. if (!empty($advertisement)) {
  93. $chat_message = [
  94. 'message_type' => 'advertisement',
  95. 'data' => $advertisement
  96. ];
  97. Gateway::sendToClient($client_id, json_encode($chat_message, 256));
  98. unset($chat_message);
  99. }
  100. unset($advertisement);
  101. self::$redis->hset(self::WEBSOCKALLUSER, $client_id, json_encode(array_merge($_SERVER, ['time' => date('H:i:s')])));
  102. }
  103. /**
  104. * 当客户端发来消息时触发
  105. * @param int $client_id 连接id
  106. * @param mixed $message 具体消息
  107. */
  108. public static function onMessage($client_id, $message)
  109. {
  110. if ($message == '{"type":"ping"}') {
  111. Gateway::sendToCurrentClient('{"type":"pong"}');
  112. return;
  113. } else {
  114. self::DebugOut($message, "OnMessage");
  115. }
  116. //echo(Gateway::getAllClientCount());
  117. $message = json_decode($message, true);
  118. if (isset($message['type'])) {
  119. switch ($message['type']) {
  120. case 'mydebug':
  121. self::mydebug($client_id, $message['data']);
  122. break;
  123. // 管理员初始化
  124. case 'adminInit':
  125. $token = $message['token'];
  126. self::adminInit($client_id, $token);
  127. break;
  128. // 客服初始化
  129. case 'init':
  130. $data = $message['data'];
  131. self::Kfinit($client_id, $data);
  132. break;
  133. // 顾客初始化
  134. case 'userInit';
  135. $data = $message['data'];
  136. self::userInitEnt($client_id, $data);
  137. break;
  138. //在线客服信息
  139. case 'getkfonlines':
  140. Gateway::sendToCurrentClient(json_encode(self::getkfonlines(), 256));
  141. break;
  142. //客服获取用户详细信息
  143. case 'kfgetuserinfo':
  144. $tmp_id = isset($message['data']['id']) ? $message['data']['id'] : 0;
  145. self::kfgetuserinfo($client_id, intval($tmp_id));
  146. break;
  147. // 客服聊天
  148. case 'chatMessage':
  149. self::chatMessage($message['data']);
  150. break;
  151. // 机器人问答.
  152. case 'toRobot':
  153. self::toRobot($client_id, $message);
  154. break;
  155. // 评价.
  156. case 'evaluate':
  157. self::evaluate($message['data']);
  158. break;
  159. // 客服关闭会话.
  160. case 'kfCloseUser':
  161. self::serverClose($message['data']['conversationId'], 3);
  162. break;
  163. // 客服更改状态.
  164. case 'kfOnline':
  165. self::KFStatusCg($client_id, $message);
  166. break;
  167. case 'changeOtherhKeFu';
  168. self::changeOtherhKeFu($client_id, $message);
  169. break;
  170. // 弹出评价.
  171. case 'getEvaluate';
  172. self::getEvaluate($message['data']);
  173. break;
  174. }
  175. }
  176. return true;
  177. }
  178. // 弹出评价.
  179. public static function getEvaluate($message)
  180. {
  181. // 获取当前会话工单.
  182. $data = json_decode(self::$redis->HGET('SERVICELOG', $message['conversationId']), true);
  183. if (empty($data)) {
  184. return;
  185. }
  186. $chat_message = [
  187. 'message_type' => 'getEvaluate',
  188. 'data' => [
  189. 'content' => '欢迎你的咨询,请对我们的服务做出评价',
  190. ]
  191. ];
  192. Gateway::sendToClient($data['client_id'], json_encode($chat_message, 256));
  193. }
  194. //客服聊天
  195. public static function chatMessage($message)
  196. {
  197. // 获取当前会话工单.
  198. $data = json_decode(self::$redis->HGET('SERVICELOG', $message['conversationId']), true);
  199. if (empty($data)) {
  200. return;
  201. }
  202. $chat_message = [
  203. 'message_type' => 'chatMessage',
  204. 'data' => [
  205. 'name' => $message['from_name'],
  206. 'id' => $message['from_id'],
  207. 'time' => date('H:i'),
  208. 'content' => $message['content'],
  209. ]
  210. ];
  211. // 是否为第一次回复.
  212. if (isset($message['isFirst']) && $message['isFirst']) {
  213. $data['alarm_corresponding'] = time() - $data['start_time'];
  214. $data['alarm_respond'] = 2;
  215. }
  216. // 发送消息.
  217. if (substr($message['from_id'], 0, 2) === 'KF') {
  218. // 统计敏感词.
  219. $data['alarm_serverSensitive'] += $message['sensitiveNumber'];
  220. $data['serverLastTime'] = time();
  221. Gateway::sendToClient($data['client_id'], json_encode($chat_message, 256));
  222. } else {
  223. // 统计敏感词.
  224. $data['alarm_userSensitive'] += $message['sensitiveNumber'];
  225. $data['userLastTime'] = time();
  226. Gateway::sendToClient($data['kf_client_id'], json_encode($chat_message, 256));
  227. }
  228. // 返回当前时间
  229. $chat_message = [
  230. 'message_type' => 'webTime',
  231. 'data' => [
  232. 'webTime' => date('H:i'),
  233. ]
  234. ];
  235. Gateway::sendToCurrentClient(json_encode($chat_message, 256));
  236. // 保存修改后的工单信息.
  237. self::$redis->HSET('SERVICELOG', $message['conversationId'], json_encode($data, 256));
  238. // 聊天信息入库
  239. $insertChatData = [
  240. 'from_id' => $message['from_id'],
  241. 'from_name' => $message['from_name'],
  242. 'to_id' => $message['to_id'],
  243. 'to_name' => $message['to_name'],
  244. 'content' => $message['content'],
  245. 'servicelog_id' => $message['conversationId'],
  246. 'time_line' => time()
  247. ];
  248. self::$db->insert('ws_chat_log')->cols($insertChatData)->query();
  249. }
  250. //得到一个用户详细信息
  251. public static function kfgetuserinfo($clientid, $id)
  252. {
  253. $ret = self::$db->select('*')->from('ws_account')->where('id=:id')->bindValues(['id' => $id])->row();
  254. Gateway::sendToClient($clientid, json_encode(['message_type' => 'userdetailinfo', 'data' => $ret]));
  255. return;
  256. }
  257. //获取在线客服列表
  258. public static function getkfonlines()
  259. {
  260. $return = [
  261. 'message_type' => 'onlinekfs',
  262. 'data' => [],
  263. ];
  264. $nowkfid = isset($_SESSION['uid']) ? $_SESSION['uid'] : 0;
  265. $fromgrouupid = isset($_SESSION['group']) ? $_SESSION['group'] : 0;
  266. if (empty($fromgrouupid) || empty($nowkfid)) {
  267. return $return;
  268. }
  269. $online = self::getOnlineKfData(0, 1);
  270. if (empty($online)) {
  271. return $return;
  272. }
  273. $groupnamemap = self::$global->groupmap;
  274. $ret = [];
  275. foreach ($online as $uinfo) {
  276. if ($nowkfid == $uinfo['id']) {
  277. continue;
  278. }
  279. $ret[] = ['groupid' => $uinfo['group'], 'groupname' => $groupnamemap[$uinfo['group']], 'kfuid' => $uinfo['id'], 'kfname' => $uinfo['name'], 'kfjobname' => $uinfo['job_name']];
  280. }
  281. $return['data'] = $ret;
  282. return $return;
  283. }
  284. public static function KFStatusCg($client_id, $message)
  285. {
  286. if (!isset($_SESSION['iskefu']) || $_SESSION['iskefu'] != 1) {
  287. return;
  288. }
  289. $userId = $message['data']['uid'];
  290. $status = intval($message['data']['status']);
  291. if (!in_array($status, [1, 2, 3])) {
  292. return false;
  293. }
  294. $oldstatus = '';
  295. $kfinfo = self::$redis->hget(self::KFINFOKEY, $userId);
  296. if (empty($kfinfo)) {
  297. return false;
  298. }
  299. $kfinfo = json_decode($kfinfo, true);
  300. if (!$kfinfo) {
  301. return false;
  302. }
  303. if ($kfinfo['status'] != $status) {
  304. $oldstatus = $kfinfo['status'];
  305. $kfinfo['status'] = $status;
  306. self::$redis->hset(self::KFINFOKEY, $userId, json_encode($kfinfo, 256));
  307. }
  308. self::writeLogKfStatus($userId, $status);
  309. Gateway::sendToCurrentClient(json_encode(['message_type' => 'cgstatus', 'data' => ['new_status' => $status, 'old_status' => $oldstatus]]));
  310. return;
  311. }
  312. //获取某个用户全部信息
  313. public static function getClientIndo($id)
  314. {
  315. $ret = self::$db->from('ws_accounts')->select("*")->where(['id' => $id])->row();
  316. return $ret;
  317. }
  318. //客服接入sock,及初始化
  319. public static function Kfinit($client_id, $message)
  320. {
  321. $uid = self::getPars($message, 'uid');
  322. $group = intval(self::getPars($message, 'group', 0));
  323. if (empty($uid) || empty($group) || !isset(self::$global->groupmap[$group])) {
  324. self::MySendMsg($client_id, json_encode(["message_type" => 'checkfalse', 'data' => "客服登陆参数错误"], 256));
  325. Gateway::closeCurrentClient();
  326. return;
  327. }
  328. $loginstate = self::$logic->userIsLogin($client_id, $uid, $group);
  329. if ($loginstate == 1) {
  330. self::MySendMsg($client_id, (json_encode(['message_type' => 'reLoginErr', 'msg' => '正在登陆中,请稍后...'], 256)));
  331. Gateway::closeClient($client_id);
  332. return;
  333. }
  334. //客服登陆验证 不符合的直接断掉
  335. $kfinfo = self::KfloginCheck($client_id, $message);
  336. if (empty($kfinfo)) {
  337. self::MySendMsg($client_id, json_encode(["message_type" => 'checkfalse', 'data' => "验证失败"], 256));
  338. Gateway::closeCurrentClient();
  339. return true;
  340. } elseif ($kfinfo['status'] != 1) {
  341. self::MySendMsg($client_id, json_encode(["message_type" => 'checkfalse', 'data' => "禁用中..."], 256));
  342. Gateway::closeCurrentClient();
  343. return true;
  344. }
  345. if ($loginstate == 2) {
  346. $oldcontids = Gateway::getClientIdByUid($uid);
  347. Gateway::sendToClient($oldcontids['0'], (json_encode(['message_type' => 'reLoginErr', 'msg' => '你的账号在其它登陆,本次下线'], 256)));
  348. Gateway::closeClient($oldcontids['0']);
  349. sleep(2);
  350. }
  351. self::$redis->hset('loginTmp:' . $uid, 'uid', time());
  352. self::$redis->expire('loginTmp:' . $uid, 5);
  353. $newinfo =
  354. [
  355. 'id' => 'KF' . $kfinfo['id'],
  356. 'name' => $kfinfo['user_name'],
  357. 'job_name' => $kfinfo['user_job_number'],
  358. 'avatar' => $kfinfo['user_avatar'],
  359. 'group' => $group,
  360. 'client_id' => $client_id,
  361. 'task' => 0,
  362. 'intime' => time(),
  363. 'signature' => $kfinfo['signature'],
  364. 'status' => 2, // 1为在线(接收分配、接收消息)2为隐身(不接收分配、只接收消息)3、休息
  365. 'user_info' => [], //在会话的用户cid key为clientid ,值为工单号
  366. ];
  367. self::$redis->hset(self::KFINFOKEY, $uid, json_encode($newinfo, 256));
  368. $_SESSION['info'] = $newinfo;
  369. // 绑定 client_id 和 uid
  370. Gateway::bindUid($client_id, $message['uid']);
  371. $_SESSION['group'] = $message['group'];
  372. $_SESSION['iskefu'] = 1;
  373. $_SESSION['uid'] = $message['uid'];
  374. $_SESSION['name'] = $message['name'];
  375. Gateway::joinGroup($client_id, 'group_' . $message['group']);
  376. $chat_message = [
  377. 'message_type' => 'loginSuccess',
  378. ];
  379. self::MySendMsg($client_id, json_encode($chat_message, 256));
  380. unset($chat_message);
  381. self::writeLogKfStatus($message['uid'], 2);
  382. return;
  383. }
  384. /**
  385. * 管理员登陆验证
  386. * @param $client_id 服务ID
  387. * @param $message 数据
  388. */
  389. public static function adminInit($client_id, $token)
  390. {
  391. // 查询token是否存在.
  392. $systemConfigData = self::$db->query("SELECT `id` FROM `ws_admins` where `token`= '$token'");
  393. if ($systemConfigData) {
  394. self::$redis->sadd('adminList', $client_id);
  395. self::systemMonitoring([$client_id]);
  396. } else {
  397. $chat_message = [
  398. 'message_type' => 'tips',
  399. 'data' => '管理员不存在'
  400. ];
  401. Gateway::sendToClient($client_id, json_encode($chat_message, 256));
  402. Gateway::closeClient($client_id);
  403. }
  404. }
  405. //客服登陆验证
  406. public static function KfloginCheck($client, $messageArray)
  407. {
  408. $uid = isset($messageArray['uid']) ? $messageArray['uid'] : '';
  409. $token = isset($messageArray['token']) ? $messageArray['token'] : '';
  410. if (empty($uid) || empty($token)) {
  411. return false;
  412. }
  413. $expire_time_vali = time() - 60 * 60 * 24;
  414. $kfid = intval(substr($uid, 2));
  415. $ret = self::$db->select('*')->from('ws_users')->where('id=:id and token=:token and expire_time>=:expire_time')->bindValues(array('id' => $kfid, 'token' => $token, 'expire_time' => $expire_time_vali))->row();
  416. if ($ret) {
  417. self::$db->update('ws_users')->cols(array('online_status' => 1, 'online_connectid' => $client))->where('id=' . $kfid)->query();
  418. return $ret;
  419. }
  420. return false;
  421. }
  422. //用户发送邦定用户事件
  423. public static function userInitEnt($client_id, $message)
  424. {
  425. $uid = intval($message['uid']);
  426. $group = intval($message['group']);
  427. if (!isset(self::$global->groupmap[$group])) {
  428. self::MySendMsg($client_id, (json_encode(['message_type' => 'reLoginErr', 'msg' => '不存在客服组....'], 256)));
  429. return true;
  430. //Gateway::closeCurrentClient();
  431. }
  432. $loginstate = self::$logic->userIsLogin($client_id, $uid, $group);
  433. if ($loginstate == 1) {
  434. self::MySendMsg($client_id, (json_encode(['message_type' => 'reLoginErr', 'msg' => '正在登陆中,请稍后...'], 256)));
  435. Gateway::closeCurrentClient();
  436. return;
  437. }
  438. $hisdata = self::$redis->hget(self::USERINFOKEY, $uid);
  439. if ($hisdata) {
  440. $hisdata = json_decode($hisdata, true);
  441. $oldclientid = $hisdata['client_id'];
  442. self::MySendMsg($oldclientid, json_encode(['type' => 'reLoginErr', 'msg' => '相同账号登陆1,本次退出'], 256));
  443. self::MySendMsg($client_id, json_encode(['type' => 'reLoginErr', 'msg' => '相同账号登陆2,本次退出'], 256));
  444. Gateway::closeClient($oldclientid);
  445. Gateway::closeCurrentClient();
  446. return;
  447. }
  448. $last = self::UserHasOldTalk($uid);
  449. $onlinekf = self::getOnlineKfData($group, 1);
  450. if (empty($onlinekf) && empty($last)) {
  451. Gateway::sendToClient($client_id, json_encode(['message_type' => 'notice', 'content' => '暂时没有客服上班,请稍后再咨询。'], 256));
  452. //Gateway::closeClient($client_id);
  453. return;
  454. }
  455. self::$redis->hset('loginTmp:' . $uid, 'uid', time());
  456. self::$redis->expire('loginTmp:' . $uid, 5);
  457. $data = [
  458. 'id' => $uid,
  459. 'name' => $message['name'],
  460. 'avatar' => $message['avatar'],
  461. 'website' => $_SESSION['origin'],//$message['website'],
  462. 'browse' => Gateway::browse_info(),
  463. 'system' => Gateway::get_os(),//$message['system'],
  464. 'ip' => isset($_SERVER['REMOTE_ADDR']) ? $_SERVER['REMOTE_ADDR'] : '',//message['ip'],
  465. 'group' => $message['group'],
  466. 'intime' => time(),
  467. 'kfuid' => '',
  468. 'ip' => $_SESSION['remotip'],
  469. 'serverid' => 0,
  470. 'client_id' => $client_id
  471. ];
  472. self::$redis->hset(self::USERLIST, $uid, json_encode($data, 256));
  473. self::$redis->hset(self::USERINFOKEY, $uid, json_encode($data, 256));
  474. // 写入接入值
  475. $key = date('Ymd') . 'total_in';
  476. self::$global->increment($key);
  477. // 绑定 client_id 和 uid
  478. Gateway::bindUid($client_id, $uid);
  479. $_SESSION['iskefu'] = 0;
  480. $_SESSION['uid'] = $message['uid'];
  481. // 尝试分配新会员进入服务
  482. self::userOnlineTask($group, $uid, $last, $client_id);
  483. }
  484. /**
  485. * 当用户断开连接时触发
  486. * @param int $client_id 连接id
  487. *
  488. * tips: 当服务端主动退出的时候,会出现 exit status 9.原因是:服务端主动断开之后,连接的客户端会走这个方法,而短时间内进程
  489. * 需要处理这多的逻辑,又有cas操作,导致进程退出会超时,然后会被内核杀死,从而报出错误 9.实际对真正的业务没有任何的影响。
  490. */
  491. public static function onClose($client_id)
  492. {
  493. self::$redis->hdel(self::WEBSOCKALLUSER, $client_id);
  494. $isKefuoff = isset($_SESSION['iskefu']) ? $_SESSION['iskefu'] : 0;
  495. $uid = isset($_SESSION['uid']) ? $_SESSION['uid'] : false;
  496. echo "下线:uid: $uid - cid: $client_id - iskf: $isKefuoff \n";
  497. $isAdmin = self::$redis->sismember('adminList', $client_id);
  498. if ($isAdmin) {
  499. self::$redis->srem('adminList', $client_id);
  500. }
  501. if (empty($uid)) {
  502. return true;
  503. }
  504. if ($isKefuoff) {
  505. self::serviceOffline($client_id, $uid);
  506. } else {
  507. self::guestOffline($client_id, $uid);
  508. }
  509. return true;
  510. }
  511. //客服下线了 系统调用,不能手动调用
  512. public static function serviceOffline($client_id, $uid)
  513. {
  514. $group = $_SESSION['group'];
  515. $uinfo = self::$redis->hget(self::KFINFOKEY, $uid);
  516. self::$redis->hdel(self::KFINFOKEY, $uid);
  517. $uinfo = json_decode($uinfo, true);
  518. if (empty($uinfo)) {
  519. echo "客服发生异常退出\n";
  520. return;
  521. }
  522. $user_info = $uinfo['user_info'];
  523. $kfid = self::getkfid($uid);
  524. $now = time();
  525. $starttime = $now - 86400 * 7;
  526. self::$redis->hset('loginTmp:' . $uid, 'uid', time());
  527. self::$redis->expire('loginTmp:' . $uid, 5);
  528. if (!empty($user_info)) {
  529. foreach ($user_info as $val => $serverid) {
  530. self::insertServerLog($serverid, 4);
  531. self::$redis->hdel(self::SERVICELOG, intval($serverid));
  532. self::MySendMsg($val, json_encode(['message_type' => 'serviceoffline', 'msg' => '客户人员下线!'], 256));
  533. Gateway::closeClient($val);
  534. }
  535. }
  536. $sql = "update `ws_service_log` set `status` = '2',end_time=$now,`servicelog_close_type` = 4 where start_time>=$starttime and kf_id=$kfid and group_id=$group and `status`!=2 ";
  537. echo "客服退出: " . $uid . "\n";
  538. self::$db->query($sql);
  539. self::$db->update('ws_users')->cols(array('online_status' => 0, 'online_connectid' => ''))->where('id=' . $kfid)->query();
  540. self::writeLogKfStatus($uid, 0);
  541. return;
  542. }
  543. //用户下线了 系统调用,不能手动调用
  544. public static function guestOffline($client_id, $uid)
  545. {
  546. self::$redis->hset('loginTmp:' . $uid, 'uid', time());
  547. self::$redis->expire('loginTmp:' . $uid, 3);
  548. $uid = intval($uid);
  549. $krclient_id = 0;
  550. $data = self::$redis->hget(self::USERINFOKEY, $uid);
  551. if (empty($data)) {
  552. return;
  553. }
  554. $info = json_decode($data, true);
  555. self::$redis->hdel(self::USERLIST, $uid);
  556. self::$redis->hdel(self::USERINFOKEY, $uid);
  557. if (!empty($info['kfuid'])) {
  558. $kfinfo = self::$redis->hget(self::KFINFOKEY, $info['kfuid']);
  559. if (!empty($kfinfo)) {
  560. $kfinfoArr = json_decode($kfinfo, true);
  561. $krclient_id = $kfinfoArr['client_id'];
  562. /*$kfinfoArr['user_info'] = self::ArrayDataopt($kfinfoArr['user_info'], $client_id, 0);
  563. $kfinfoArr['task'] = count($kfinfoArr['user_info']);
  564. self::$redis->hset(self::KFINFOKEY, $info['kfuid'], json_encode($kfinfoArr, 256));*/
  565. }
  566. }
  567. $chat_message = [
  568. 'message_type' => 'userClose',
  569. 'data' => [
  570. 'content' => '用户连接已断开',
  571. 'id' => $uid,
  572. 'time' => date('H:i'),
  573. ]
  574. ];
  575. $now = time();
  576. $serverid = intval($info['serverid']);
  577. if ($serverid) {
  578. $sql = "update `ws_service_log` set `status` = '3' where servicelog_id=$serverid and `status` !=2 ";
  579. self::$db->query($sql);
  580. }
  581. if ($krclient_id) {
  582. Gateway::sendToClient($krclient_id, json_encode($chat_message, 256));
  583. }
  584. return;
  585. }
  586. /**
  587. * 客服结束会话
  588. *
  589. * tips: 未有$client_id的关闭
  590. */
  591. public static function closeUser($servicelog_id, $userId, $kf_id, $groupId)
  592. {
  593. }
  594. /**
  595. * 工单结束
  596. * @param int $client_id 连接id
  597. *
  598. * tips: 当服务端主动退出的时候,会出现 exit status 9.原因是:服务端主动断开之后,连接的客户端会走这个方法,而短时间内进程
  599. * 需要处理这多的逻辑,又有cas操作,导致进程退出会超时,然后会被内核杀死,从而报出错误 9.实际对真正的业务没有任何的影响。
  600. */
  601. public static function serverClose($servicelogId, $closeBy = 0)
  602. {
  603. // 获取当前工单数据.
  604. $data = json_decode(self::$redis->HGET('SERVICELOG', $servicelogId), true);
  605. if (empty($data)) {
  606. return;
  607. }
  608. // 获取当前客服.
  609. $kfInfo = json_decode(self::$redis->HGET('KFINFO', 'KF' . $data['kf_id']), true);
  610. if (empty($kfInfo)) {
  611. return;
  612. }
  613. // 删除当前工单.
  614. self::$redis->hdel('SERVICELOG', $servicelogId);
  615. // 当前服务客服删除当前人员.
  616. $kfUserList = self::ArrayDataopt($kfInfo['user_info'], $data['client_id'], 0);
  617. // 删除当前人员信息.
  618. self::$redis->hdel('USERINFO', $data['user_id']);
  619. // 当前客服所接待人员.
  620. $kfInfo['user_info'] = $kfUserList;
  621. $kfInfo['task'] = count($kfUserList);
  622. // 存入客服信息.
  623. self::$redis->HSET('KFINFO', 'KF' . $data['kf_id'], json_encode($kfInfo, 256));
  624. // 发送消息给用户.
  625. $chat_message = [
  626. 'message_type' => 'closeBysever',
  627. 'data' => [
  628. 'content' => '客服停止了该会话',
  629. 'time' => date('H:i'),
  630. ]
  631. ];
  632. Gateway::sendToClient($data['client_id'], json_encode($chat_message, 256));
  633. // 关闭用户连接.
  634. Gateway::closeClient($data['client_id']);
  635. // 发送消息给客服.
  636. $del_message = [
  637. 'message_type' => 'delUser',
  638. 'data' => [
  639. 'id' => $data['user_id']
  640. ]
  641. ];
  642. Gateway::sendToClient($data['kf_client_id'], json_encode($del_message, 256));
  643. // 查询工单会话总数.
  644. $chatCount = self::$db->select('count(*) as count')->from('ws_chat_log')->where("servicelog_id=$servicelogId")->row();
  645. // 将数据存入数据库.
  646. $updateServiceLogData = [
  647. 'status' => 2,
  648. 'evaluate_id' => isset($data['evaluate_id']) ? $data['evaluate_id'] : 0,
  649. 'evaluate_content' => isset($data['evaluate_content']) ? $data['evaluate_content'] : '',
  650. 'servicelog_close_type' => $closeBy,
  651. 'end_time' => time(),
  652. ];
  653. $updataAlarmData = [
  654. 'alarm_userSensitive' => $data['alarm_userSensitive'],
  655. 'alarm_serverSensitive' => $data['alarm_serverSensitive'],
  656. 'alarm_corresponding' => $data['alarm_corresponding'],
  657. 'alarm_cvtOvertime' => time() - $data['start_time'],
  658. 'alarm_respond' => $data['alarm_respond'],
  659. 'alarm_lineTime' => $data['start_time'] - $data['intime'],
  660. 'alarm_count' => $chatCount['count'],
  661. ];
  662. self::$db->update('ws_service_log')->cols($updateServiceLogData)->where("servicelog_id=$servicelogId")->query();
  663. self::$db->update('ws_alarm')->cols($updataAlarmData)->where("servicelog_id=$servicelogId")->query();
  664. }
  665. /**
  666. * 修改工单数据库数据
  667. * @param int $client_id 连接id
  668. *
  669. * tips: 当服务端主动退出的时候,会出现 exit status 9.原因是:服务端主动断开之后,连接的客户端会走这个方法,而短时间内进程
  670. * 需要处理这多的逻辑,又有cas操作,导致进程退出会超时,然后会被内核杀死,从而报出错误 9.实际对真正的业务没有任何的影响。
  671. */
  672. public static function insertServerLog($servicelogId, $closeBy = 0)
  673. {
  674. // 获取当前工单数据.
  675. $data = json_decode(self::$redis->HGET('SERVICELOG', $servicelogId), true);
  676. if (empty($data)) {
  677. return;
  678. }
  679. // 查询工单会话总数.
  680. $chatCount = self::$db->select('count(*) as count')->from('ws_chat_log')->where("servicelog_id=$servicelogId")->row();
  681. // 将数据存入数据库.
  682. $updateServiceLogData = [
  683. 'status' => 2,
  684. 'evaluate_id' => isset($data['evaluate_id']) ? $data['evaluate_id'] : 0,
  685. 'evaluate_content' => isset($data['evaluate_content']) ? $data['evaluate_content'] : '',
  686. 'servicelog_close_type' => $closeBy,
  687. 'end_time' => time(),
  688. ];
  689. $updataAlarmData = [
  690. 'alarm_userSensitive' => $data['alarm_userSensitive'],
  691. 'alarm_serverSensitive' => $data['alarm_serverSensitive'],
  692. 'alarm_corresponding' => $data['alarm_corresponding'],
  693. 'alarm_cvtOvertime' => time() - $data['start_time'],
  694. 'alarm_respond' => $data['alarm_respond'],
  695. 'alarm_lineTime' => $data['start_time'] - $data['intime'],
  696. 'alarm_count' => $chatCount['count'],
  697. ];
  698. self::$db->update('ws_service_log')->cols($updateServiceLogData)->where("servicelog_id=$servicelogId")->query();
  699. self::$db->update('ws_alarm')->cols($updataAlarmData)->where("servicelog_id=$servicelogId")->query();
  700. }
  701. /**
  702. * 有人退出
  703. * @param $group
  704. */
  705. private static function userOfflineTask($group)
  706. {
  707. }
  708. /**
  709. * 有人进入执行分配
  710. * @param $client_id
  711. * @param $group
  712. * @param $uid
  713. */
  714. private static function userOnlineTask($group = 0, $uid = 0, $last = [], $client_id = '')
  715. {
  716. $allusergkarr = self::getUserListData();
  717. if (empty($allusergkarr)) {
  718. return;
  719. }
  720. $allkfgkarr = self::getWorkKfData();
  721. if (empty($allkfgkarr)) {
  722. return;
  723. }
  724. $maxset = (self::$global->systemconfig)['KFMaxServices'] ?? 5;
  725. $maxset = intval($maxset);
  726. if ($group && $uid) {
  727. // 指定用指定组 [可能存在断线重连的情况] 如果存在旧的会话,直接连线客服和用户
  728. //否则按先到后到以及客服最大服务数限制
  729. if ($last) {
  730. self::BeginOldTalk(self::getkfuid($last['kf_id']), $uid, $last['group_id'], $last['servicelog_id']);
  731. $toOld_message = [
  732. 'message_type' => 'toOld',
  733. 'data' => [
  734. 'content' => '接入至未结束的会话'
  735. ]
  736. ];
  737. Gateway::sendToCurrentClient(json_encode($toOld_message, 256));
  738. return;
  739. }
  740. }
  741. //系统定时调用时,无组,无用户
  742. foreach ($allusergkarr as $group => $gusersArr) {
  743. if (!isset($allkfgkarr[$group]) || count($allkfgkarr[$group]) <= 0) {
  744. //所属客服组无人在线
  745. continue;
  746. }
  747. $nowkfs = $allkfgkarr[$group];
  748. $count = count($nowkfs);
  749. $i = 0;
  750. foreach ($gusersArr as $user) {
  751. if ($nowkfs[$i]['task'] > $maxset) {
  752. break;
  753. }
  754. $nowkfs[$i]['task']++;
  755. self::BeginTalk($nowkfs[$i]['id'], $user['id'], $group, 0, $user);
  756. self::$redis->hdel(self::USERLIST, $user['id']);
  757. $i++;
  758. if ($i >= $count) {
  759. $i = 0;
  760. }
  761. }
  762. }
  763. return;
  764. }
  765. //开启一个会话
  766. private static function BeginTalk($kfuid, $uid, $group, $serviceid = 0, $userInfo = false)
  767. {
  768. $serviceid = intval($serviceid);
  769. if (!$userInfo) {
  770. $userInfo = json_decode(self::$redis->hget(self::USERINFOKEY, $uid), true);
  771. }
  772. $kfinfo = json_decode(self::$redis->hget(self::KFINFOKEY, $kfuid), true);
  773. if (empty($userInfo) || empty($kfinfo)) {
  774. return false;
  775. }
  776. $server = [];
  777. $armarr = [];
  778. if ($serviceid) {
  779. $server = self::$db->select('*')->from('ws_service_log')->where("servicelog_id=$serviceid ")->row();
  780. if ($server) {
  781. $armarr = self::$db->select('*')->from('ws_alarm')->where("servicelog_id=$serviceid ")->row();
  782. }
  783. }
  784. if (empty($server)) {
  785. $array = [
  786. 'user_id' => intval($uid),
  787. 'client_id' => $userInfo['client_id'],
  788. 'user_name' => $userInfo['name'],
  789. 'user_avatar' => $userInfo['avatar'],
  790. 'user_ip' => $userInfo['ip'],
  791. 'kf_id' => self::getkfid($kfuid),
  792. 'start_time' => time(),
  793. 'group_id' => $group ? $group : $userInfo['group'],
  794. 'website' => $userInfo['website'],
  795. 'system' => $userInfo['system'],
  796. 'browse' => $userInfo['browse'],
  797. 'intime' => $userInfo['intime'],
  798. 'status' => 1,
  799. 'evaluate_id' => 0,
  800. 'servicelog_close_type' => 0
  801. ];
  802. $serviceid = self::$db->insert('ws_service_log')->cols($array)->query();
  803. $server = array_merge(['servicelog_id' => $serviceid], $array);
  804. $armid = self::$db->insert('ws_alarm')->cols(['servicelog_id' => $serviceid])->query();
  805. $armarr = self::$db->select('*')->from('ws_alarm')->where("alarm_id=$armid")->row();
  806. }
  807. $redisData = array_merge($server, $armarr, ['kf_client_id' => $kfinfo['client_id'], 'server_name' => $kfinfo['name']]);
  808. self::$redis->hset(self::SERVICELOG, $serviceid, json_encode($redisData, 256));
  809. $kfinfo['user_info'] = array_merge($kfinfo['user_info'], [$userInfo['client_id'] => $serviceid]);
  810. $kfinfo['task'] = count($kfinfo['user_info']);
  811. self::$redis->hset(self::KFINFOKEY, $kfuid, json_encode($kfinfo, 256));
  812. $userInfo['serverid'] = $serviceid;
  813. $userInfo['kfuid'] = $kfuid;
  814. self::$redis->hset(self::USERINFOKEY, $uid, json_encode($userInfo, 256));
  815. // 通知会员发送信息绑定客服的id
  816. $noticeUser = [
  817. 'message_type' => 'connect',
  818. 'data' => [
  819. 'kf_id' => $kfuid,
  820. 'conversationId' => $serviceid,
  821. 'serverInfo' => $kfinfo,
  822. 'kf_name' => $kfinfo['job_name']
  823. ]
  824. ];
  825. self::MySendMsg($userInfo['client_id'], json_encode($noticeUser, 256));
  826. $sayHello = (self::$global->replay)['2'];
  827. if (!empty($sayHello) && 1 == $sayHello['status']) {
  828. $chat_message = [
  829. 'message_type' => 'chatMessage',
  830. 'data' => [
  831. 'id' => self::getkfuid($kfinfo['id']),
  832. 'name' => $kfinfo['name'],
  833. 'time' => date('H:i'),
  834. 'content' => $sayHello['word']
  835. ]
  836. ];
  837. self::MySendMsg($userInfo['client_id'], json_encode($chat_message, 256));
  838. unset($chat_message);
  839. }
  840. $noticeKf = [
  841. 'message_type' => 'connect',
  842. 'data' => [
  843. 'user_info' => $userInfo,
  844. 'conversationId' => $serviceid,
  845. ]
  846. ];
  847. self::MySendMsg($kfinfo['client_id'], json_encode($noticeKf, 256));
  848. unset($noticeKf);
  849. $key = date('Ymd') . 'success_in';
  850. self::$global->increment($key);
  851. return;
  852. }
  853. //连接至上一个会话
  854. private static function BeginOldTalk($kfuid, $uid, $group, $serviceid = 0, $userInfo = false)
  855. {
  856. $serviceid = intval($serviceid);
  857. $userInfo = json_decode(self::$redis->hget(self::USERINFOKEY, $uid), true);
  858. $kfinfo = json_decode(self::$redis->hget(self::KFINFOKEY, $kfuid), true);
  859. if (empty($userInfo) || empty($kfinfo)) {
  860. return false;
  861. }
  862. // 获取旧工单信息.
  863. $data = json_decode(self::$redis->HGET('SERVICELOG', $serviceid), true);
  864. if (empty($data)) {
  865. return;
  866. }
  867. // 修改工单数据.
  868. $data['user_avatar'] = $userInfo['avatar'];
  869. $data['client_id'] = $userInfo['client_id'];
  870. $data['user_ip'] = $userInfo['ip'];
  871. $data['website'] = $userInfo['website'];
  872. $data['system'] = $userInfo['system'];
  873. $data['browse'] = $userInfo['browse'];
  874. $data['status'] = $userInfo['status'];
  875. self::$redis->hset(self::SERVICELOG, $serviceid, json_encode($data, 256));
  876. // 更改用户连接客服信息
  877. $userInfo['serverid'] = $serviceid;
  878. $userInfo['kfuid'] = $kfuid;
  879. self::$redis->hset(self::USERINFOKEY, $uid, json_encode($userInfo, 256));
  880. // 更改客服连接信息.
  881. $kfinfo = json_decode(self::$redis->hget(self::KFINFOKEY, $kfuid), true);
  882. $kfUsers = json_decode($kfinfo['user_info'], true);
  883. foreach ($kfUsers as $key => $value) {
  884. if ($value == $uid) {
  885. // 删除之前的当前用户连接
  886. unset($kfUsers[$key]);
  887. }
  888. }
  889. // 增加现在用户的连接到客服
  890. $kfUsers[$userInfo['client_id']] = $uid;
  891. $kfinfo['user_info'] = $kfUsers;
  892. // 将数据存入redis
  893. self::$redis->hset('KFINFO', $kfuid, json_encode($kfinfo, 256));
  894. // 通知会员发送信息绑定客服的id
  895. $noticeUser = [
  896. 'message_type' => 'connect',
  897. 'data' => [
  898. 'kf_id' => $kfuid,
  899. 'conversationId' => $serviceid,
  900. 'serverInfo' => $kfinfo,
  901. 'kf_name' => $kfinfo['job_name']
  902. ]
  903. ];
  904. self::MySendMsg($userInfo['client_id'], json_encode($noticeUser, 256));
  905. // 发送给客服用户信息.
  906. $noticeKf = [
  907. 'message_type' => 'connect',
  908. 'data' => [
  909. 'user_info' => $userInfo,
  910. 'conversationId' => $serviceid,
  911. ]
  912. ];
  913. self::MySendMsg($kfinfo['client_id'], json_encode($noticeKf, 256));
  914. unset($noticeKf);
  915. $key = date('Ymd') . 'success_in';
  916. self::$global->increment($key);
  917. return;
  918. }
  919. //用户排队数据 按组
  920. private static function getUserListData()
  921. {
  922. $alluser = self::$redis->hgetall(self::USERLIST);
  923. if (empty($alluser)) {
  924. return false;
  925. }
  926. $allusergkarr = [];
  927. foreach ($alluser as $val) {
  928. $now = json_decode($val, true);
  929. if ($now) {
  930. //用户分组后的数组
  931. $allusergkarr[$now['group']][] = $now;
  932. }
  933. }
  934. foreach ($allusergkarr as $group => $nowgroups) {
  935. usort($allusergkarr[$group], function ($a, $b) {
  936. if ($a['intime'] == $b['intime']) {
  937. return 0;
  938. }
  939. return ($a['intime'] > $b['intime']) ? 1 : -1;
  940. });
  941. }
  942. if (!$allusergkarr) {
  943. return false;
  944. }
  945. unset($alluser);
  946. return $allusergkarr;
  947. }
  948. //找到可以接工单的客服 按组
  949. private static function getWorkKfData()
  950. {
  951. $allkfs = self::$redis->hgetall(self::KFINFOKEY);
  952. if (empty($allkfs)) {
  953. return false;
  954. }
  955. $allkfgkarr = [];
  956. foreach ($allkfs as $val) {
  957. $now = json_decode($val, true);
  958. if ($now && $now['status'] == 1) {
  959. //客分组后的数组
  960. $allkfgkarr[$now['group']][] = $now;
  961. }
  962. }
  963. if (!$allkfgkarr) {
  964. return false;
  965. }
  966. //客服每组按任务数由小到大排序 任务相同时按时间先后顺序
  967. foreach ($allkfgkarr as $group => $nowgroups) {
  968. usort($allkfgkarr[$group], function ($a, $b) {
  969. if ($a['task'] == $b['task']) {
  970. if ($a['intime'] == $b['intime']) {
  971. return 0;
  972. }
  973. return ($a['intime'] > $b['intime']) ? 1 : -1;
  974. }
  975. return ($a['task'] > $b['task']) ? 1 : -1;
  976. });
  977. }
  978. unset($allkfs);
  979. return $allkfgkarr;
  980. }
  981. //找到用户是否有一条未关闭的会话
  982. private static function UserHasOldTalk($uid)
  983. {
  984. $uid = intval($uid);
  985. $start_time = time() - 86400;
  986. $ret = self::$db->select('*')->from('ws_service_log')->where("start_time>=$start_time and user_id=$uid and status!=2 ")->orderByDESC(['servicelog_id'])->row();
  987. return $ret;
  988. }
  989. //今天排序累加
  990. private static function todayqueuelength()
  991. {
  992. $dtype = 'user.queue.day.length';
  993. $today = date("Y-m-d");
  994. $sret = self::$db->select('*')->from('ws_countmidtable')->where('dtype=:dtype and mdate=:mdate')->bindValues(array('dtype' => $dtype, 'mdate' => $today))->row();
  995. if ($sret) {
  996. self::$db->update('ws_countmidtable')->cols(array('dcontent' => intval($sret['dcontent']) + 1))->where('id=' . $sret['id'])->query();
  997. } else {
  998. self::$db->insert('ws_countmidtable')->cols(array(
  999. 'dtype' => $dtype,
  1000. 'mdate' => $today,
  1001. 'datatype' => 1,
  1002. 'dcontent' => 1))->query();
  1003. }
  1004. }
  1005. //客服工单转单
  1006. private static function servicetrutoother($type, $owen, $otherkfid, $serverid, $clientuid)
  1007. {
  1008. $owen = intval(substr($owen, 2));
  1009. $otherkfid = intval(substr($otherkfid, 2));
  1010. self::$db->insert('ws_serviceturn_log')->cols(array(
  1011. 'stype' => $type,
  1012. 'uid' => $owen,
  1013. 'tuid' => $otherkfid,
  1014. 'serverid' => $serverid,
  1015. 'guestuid' => $clientuid
  1016. ))->query();
  1017. }
  1018. /**
  1019. * 给客服分配会员【均分策略】
  1020. * @param $kfList
  1021. * @param $userList
  1022. * @param $group
  1023. * @param $total
  1024. */
  1025. private static function assignmentTask($kfList, $userList, $group, $total, $uid = 0)
  1026. {
  1027. }
  1028. /**
  1029. * 获取最大的服务人数
  1030. * @return int
  1031. */
  1032. private static function getMaxServiceNum()
  1033. {
  1034. $maxNumber = self::$db->query('select `max_service` from `ws_kf_config` where `id` = 1');
  1035. if (!empty($maxNumber)) {
  1036. $maxNumber = 5;
  1037. } else {
  1038. $maxNumber = $maxNumber['0']['max_service'];
  1039. }
  1040. return $maxNumber;
  1041. }
  1042. /**
  1043. * 将内存中的数据写入统计表
  1044. * @param int $flag
  1045. */
  1046. private static function writeLog($flag = 1)
  1047. {
  1048. // 上午 8点 到 22 点开始统计
  1049. if (date('H') < 8 || date('H') > 22) {
  1050. return;
  1051. }
  1052. $inQueue_1 = self::$redis->hgetall(self::USERLIST);
  1053. $inQueue = empty($inQueue_1) ? 0 : count($inQueue_1);
  1054. $allkf = self::$redis->hgetall(self::KFINFOKEY);
  1055. $nowTalking = $onlineKf = 0;
  1056. if (!empty($allkf)) {
  1057. foreach ($allkf as $kfuid => $val) {
  1058. $tmp = json_decode($val, true);
  1059. $onlineKf++;
  1060. $nowTalking += count($tmp['user_info']);
  1061. }
  1062. }
  1063. $key = date('Ymd') . 'total_in';
  1064. $key2 = date('Ymd') . 'success_in';
  1065. $param = [
  1066. 'is_talking' => $nowTalking,
  1067. 'in_queue' => $inQueue,
  1068. 'online_kf' => $onlineKf,
  1069. 'success_in' => self::$global->$key2,
  1070. 'total_in' => self::$global->$key,
  1071. 'now_date' => date('Y-m-d')
  1072. ];
  1073. self::$db->update('ws_now_data')->cols($param)->where('id=1')->query();
  1074. if (2 == $flag) {
  1075. $param = [
  1076. 'is_talking' => $nowTalking,
  1077. 'in_queue' => $inQueue,
  1078. 'online_kf' => $onlineKf,
  1079. 'success_in' => self::$global->$key2,
  1080. 'total_in' => self::$global->$key,
  1081. 'add_date' => date('Y-m-d'),
  1082. 'add_hour' => date('H'),
  1083. 'add_minute' => date('i'),
  1084. ];
  1085. self::$db->insert('ws_service_data')->cols($param)->query();
  1086. }
  1087. unset($allkf, $nowTalking, $inQueue, $onlineKf, $key, $key2, $param);
  1088. }
  1089. /**
  1090. * 机器人问答
  1091. * @param $client_id 服务ID
  1092. * @param $message 数据
  1093. */
  1094. private static function toRobot($client_id, $message)
  1095. {
  1096. $groups_id = $message['data']['groups_id'];
  1097. $robot_name = $message['data']['robot_name'];
  1098. $robotgroups_id = $message['data']['robotgroups_id'];
  1099. // 查询问题.
  1100. $getRobot = self::$db->query("select `robot_content` from `ws_robot` where `robot_status`= 1 and `groups_id`= '" . $groups_id . "' and `robot_name`= '" . $robot_name . "' and `robotgroups_id`= '" . $robotgroups_id . "'");
  1101. $chat_message = [
  1102. 'message_type' => 'robotMessage',
  1103. //'message_type' => 'chatMessage',
  1104. 'data' => [
  1105. 'name' => '智能助手',
  1106. 'time' => date('H:i'),
  1107. 'content' => $getRobot ? $getRobot[0]['robot_content'] : 'error',
  1108. ]
  1109. ];
  1110. Gateway::sendToClient($client_id, json_encode($chat_message, 256));
  1111. }
  1112. /**
  1113. * 评价
  1114. * @param $client_id 服务ID
  1115. * @param $message 数据
  1116. */
  1117. private static function evaluate($message)
  1118. {
  1119. // 获取当前会话工单.
  1120. $data = json_decode(self::$redis->HGET('SERVICELOG', $message['conversationId']), true);
  1121. if (empty($data)) {
  1122. return;
  1123. }
  1124. $data['evaluate_id'] = $message['evaluate_id'];
  1125. $data['evaluate_content'] = $message['evaluate_content'];
  1126. self::$redis->HSET('SERVICELOG', $data['client_id'], json_encode($data, 256));
  1127. $chat_message = [
  1128. 'message_type' => 'evaluate',
  1129. 'data' => [
  1130. 'status' => 1,
  1131. 'time' => date('H:i'),
  1132. ]
  1133. ];
  1134. Gateway::sendToClient($message['client_id'], json_encode($chat_message, 256));
  1135. }
  1136. //获取系统配置
  1137. private static function upsystemconfig()
  1138. {
  1139. $systemConfigData = self::$db->query("SELECT * FROM `ws_systemconfig`");
  1140. $arr = [];
  1141. if ($systemConfigData) {
  1142. foreach ($systemConfigData as $item) {
  1143. $arr[$item['systemconfig_enName']] = $item;
  1144. }
  1145. self::$global->systemconfig = $arr;
  1146. }
  1147. $group = self::$db->query("SELECT * FROM `ws_groups`");
  1148. $arr = [];
  1149. if ($group) {
  1150. foreach ($group as $val) {
  1151. $arr[$val['id']] = $val['name'];
  1152. }
  1153. self::$global->groupmap = $arr;
  1154. }
  1155. $arr = [];
  1156. $replay = self::$db->query('select * from `ws_reply`');
  1157. if ($replay) {
  1158. foreach ($replay as $val) {
  1159. $arr[$val['id']] = $val;
  1160. }
  1161. self::$global->replay = $arr;
  1162. }
  1163. }
  1164. /**
  1165. * 超时
  1166. * @param $client_id 服务ID
  1167. * @param $message 数据
  1168. */
  1169. private static function overTime()
  1170. {
  1171. // 查询对话时效设置.
  1172. $systemConfigData = self::$db->query("SELECT `systemconfig_data`,`systemconfig_enName`,`systemconfig_content` FROM `ws_systemconfig`");
  1173. foreach ($systemConfigData as $k => $v) {
  1174. if ($v['systemconfig_enName'] == 'overtime') {
  1175. $configOvertime = $v;
  1176. } elseif ($v['systemconfig_enName'] == 'unoperated') {
  1177. $configUnoperated = $v;
  1178. }
  1179. }
  1180. // 查询未断开的工单.
  1181. $serviceLog = self::$redis->hGetall('SERVICELOG');
  1182. $setOvertime = strtotime('-' . ($configOvertime['systemconfig_data'] - 60) . ' second');
  1183. $overtime = strtotime('-' . ($configOvertime['systemconfig_data']) . ' second');
  1184. $setUnoperated = strtotime('-' . ($configUnoperated['systemconfig_data'] - 60) . ' second');
  1185. $unoperated = strtotime('-' . ($configUnoperated['systemconfig_data']) . ' second');
  1186. foreach ($serviceLog as $k => $v) {
  1187. // 无效会话关闭.如果没有说一句话.
  1188. $data = json_decode($v, true);
  1189. if (!isset($data['userLastTime'])) {
  1190. if ($data['start_time'] <= $unoperated) {
  1191. self::serverClose($k, 1);
  1192. // 如果小于设定时间前一分钟则给出提示.
  1193. } elseif ($data['start_time'] <= $setUnoperated) {
  1194. $chat_message = [
  1195. 'message_type' => 'overtime',
  1196. 'data' => [
  1197. 'content' => $configUnoperated['systemconfig_content'],
  1198. ]
  1199. ];
  1200. Gateway::sendToClient($data['client_id'], json_encode($chat_message, 256));
  1201. }
  1202. // 双方静默超时.
  1203. } elseif ($data['userLastTime'] <= $overtime && $data['serverLastTime'] <= $overtime) {
  1204. self::serverClose($k, 2);
  1205. // 如果小于设定时间前一分钟则给出提示.
  1206. } elseif ($data['userLastTime'] <= $setOvertime && $data['serverLastTime'] <= $setOvertime) {
  1207. $chat_message = [
  1208. 'message_type' => 'overtime',
  1209. 'data' => [
  1210. 'content' => $configOvertime['systemconfig_content'],
  1211. ]
  1212. ];
  1213. Gateway::sendToClient($data['client_id'], json_encode($chat_message, 256));
  1214. }
  1215. }
  1216. }
  1217. /**
  1218. * 系统监控
  1219. * @param $message 数据
  1220. */
  1221. private static function systemMonitoring($adminList)
  1222. {
  1223. // 查询正进行的工单.
  1224. $serviceLog = self::$redis->hGetall('SERVICELOG');
  1225. // 查询系统设置表.
  1226. $systemconfig = self::$db->query("SELECT `systemconfig_data`,`systemconfig_enName` FROM `ws_systemconfig` WHERE `systemconfig_enName`='verifyReturnTime' or `systemconfig_enName`='verifyAllTime'");
  1227. // 质检会话响应时长.
  1228. $returnTimeKey = array_search('verifyReturnTime', array_column($systemconfig, 'systemconfig_enName'));
  1229. $verifyReturnTime = $systemconfig[$returnTimeKey]['systemconfig_data'];
  1230. // 质检会话时长.
  1231. $allTimeKey = array_search('verifyAllTime', array_column($systemconfig, 'systemconfig_enName'));
  1232. $verifyAllTime = $systemconfig[$allTimeKey]['systemconfig_data'];
  1233. $evaluateCount = 0; // 差评总次数.
  1234. $overtimeNumber = 0; // 会话超时总次数.
  1235. $overtimeTime = []; // 每次会话超时时间.
  1236. $userSensitive = 0; // 用户敏感词报警总次数.
  1237. $serverSensitive = 0; // 客服敏感词报警总次数.
  1238. $csdNumber = 0; // 响应超时总次数.
  1239. $csdTime = []; // 每次响应超时时间.
  1240. foreach ($serviceLog as $k => $v) {
  1241. $data = json_decode($v, true);
  1242. // 工单报警次数.
  1243. $allCount = 0;
  1244. if ($data['evaluate_id'] == 3) {
  1245. $evaluateCount++; // 差评次数.
  1246. $allCount++; // 工单报警次数.
  1247. }
  1248. // 会话超时.
  1249. $duration = time() - $data['start_time'];
  1250. if ($duration > $verifyAllTime) {
  1251. $overtimeNumber++; // 会话超时总次数.
  1252. $allCount++; // 工单报警次数.
  1253. $overtimeTime[] = $duration; // 响应超时时间.
  1254. }
  1255. // 敏感词报警.
  1256. $userSensitive += $data['alarm_userSensitive'];
  1257. $allCount += $data['alarm_userSensitive'];
  1258. $serverSensitive += $data['alarm_serverSensitive'];
  1259. $allCount += $data['alarm_serverSensitive'];
  1260. // 响应超时.
  1261. if ($data['alarm_corresponding'] > $verifyReturnTime) {
  1262. $csdTime[] = $data['alarm_corresponding']; // 响应超时时间.
  1263. $csdNumber++; // 响应超时总次数.
  1264. $allCount++; // 工单报警次数.
  1265. }
  1266. $serviceLog[$k] = $data;
  1267. $serviceLog[$k]['allCount'] = $allCount; // 工单报警次数.
  1268. }
  1269. self::DebugOut([$serviceLog, $csdTime, $verifyReturnTime], 'systemMonitoring');
  1270. $chat_message = [
  1271. 'message_type' => 'monitor',
  1272. 'data' => [
  1273. 'cvtList' => $serviceLog,
  1274. 'userSensitive' => $userSensitive,
  1275. 'serverSensitive' => $serverSensitive,
  1276. 'csdNumber' => $csdNumber,
  1277. 'csdTime' => $csdTime,
  1278. 'overtimeNumber' => $overtimeNumber,
  1279. 'overtimeTime' => $overtimeTime,
  1280. 'evaluateCount' => $evaluateCount,
  1281. ]
  1282. ];
  1283. // 查询对话时效设置.
  1284. foreach ($adminList as $v) {
  1285. Gateway::sendToClient($v, json_encode($chat_message, 256));
  1286. }
  1287. }
  1288. //客户工单内部组转接
  1289. public static function changeOtherhKeFu($client_id, $smessage)
  1290. {
  1291. $message = $smessage['data'];
  1292. $groupid = isset($message['fromgroup']) ? intval($message['fromgroup']) : 0;
  1293. $groupidto = isset($message['togroup']) ? intval($message['togroup']) : 0;
  1294. $toukfid = isset($message['toukfuid']) ? $message['toukfuid'] : 0;
  1295. $fromkfuid = isset($message['fromkfuid']) ? $message['fromkfuid'] : 0;
  1296. $uid = isset($message['uid']) ? intval($message['uid']) : 0;
  1297. $word = isset($message['word']) ? $message['word'] : '';
  1298. if (empty($groupid) || empty($groupidto) || empty($toukfid) || empty($fromkfuid) || empty($uid) || ($toukfid == $fromkfuid)) {
  1299. self::DebugOut('changeOtherhKeFu exit1...');
  1300. return false;
  1301. }
  1302. if (!Gateway::isUidOnline($toukfid) || !Gateway::isUidOnline($uid)) {
  1303. self::DebugOut('changeOtherhKeFu exit2...');
  1304. return false;
  1305. }
  1306. $kf_info_from = json_decode(self::$redis->hget(self::KFINFOKEY, $fromkfuid), true);
  1307. $kf_info_to = json_decode(self::$redis->hget(self::KFINFOKEY, $toukfid), true);
  1308. $user_info = json_decode(self::$redis->hget(self::USERINFOKEY, $uid), true);
  1309. $serviceid = intval($user_info['serverid']);
  1310. if (empty($kf_info_from) || empty($kf_info_to) || empty($user_info) || empty($serviceid)) {
  1311. self::DebugOut('changeOtherhKeFu exit23...');
  1312. return false;
  1313. }
  1314. if ($kf_info_to['status'] != 1) {
  1315. self::DebugOut('changeOtherhKeFu exit4...');
  1316. return false;
  1317. }
  1318. /////////取消原有会话,开启新会话
  1319. $oldlog = self::$db->select('*')->from('ws_service_log')->where('servicelog_id=:servicelog_id ')->bindValues(['servicelog_id' => $serviceid])->orderByDESC(['servicelog_id'])->row();
  1320. if (!$oldlog) {
  1321. self::DebugOut('changeOtherhKeFu exit5...');
  1322. return false;
  1323. }
  1324. self::insertServerLog($serviceid, 5);
  1325. self::$redis->hdel(self::SERVICELOG, $serviceid);
  1326. unset($oldlog['servicelog_id']);
  1327. ///更新redis数据
  1328. $kf_info_from['user_info'] = self::ArrayDataopt($kf_info_from['user_info'], $user_info['client_id'], 0);
  1329. $kf_info_from['task'] = count($kf_info_from['user_info']);
  1330. self::$redis->hset(self::KFINFOKEY, $fromkfuid, json_encode($kf_info_from, 256));
  1331. ///////旧工单部分数据更新回库
  1332. /// 查询工单会话总数.
  1333. self:: BeginTalk($toukfid, $uid, $groupidto, 0, $user_info);
  1334. self::servicetrutoother('OUT', $fromkfuid, $toukfid, $serviceid, $uid);
  1335. $newUserInfo = json_decode(self::$redis->hget(self::USERINFOKEY, $uid), true);
  1336. self::servicetrutoother('IN', $toukfid, $fromkfuid, $newUserInfo['serverid'], $uid);
  1337. //回转接人,转接成功
  1338. Gateway::sendToCurrentClient(json_encode(['message_type' => 'trunconnect', 'data' => ['status' => 1]], 256));
  1339. // 发送给用户转接消息
  1340. Gateway::sendToClient($user_info['client_id'], json_encode(['message_type' => 'changeKeFuSuccess', 'data' => ['content' => "会话转接成功"]], 256));
  1341. self::DebugOut('changekf 转换成功!');
  1342. return;
  1343. }
  1344. //客服在线状态写组
  1345. private static function writeLogKfStatus($kf, $status, $flag = 1)
  1346. {
  1347. if ($flag == 1) {
  1348. $status = intval($status);
  1349. if ($status == 0) {
  1350. self::$db->delete('ws_kfonline')->where("uid='$kf'")->query();
  1351. } else {
  1352. $now = date('Y-m-d H:i;s');
  1353. $ip = isset($_SESSION['remotip']) ? $_SESSION['remotip'] : '';
  1354. $sql = "insert into ws_kfonline(uid,status,uptime,ip) values('$kf',$status,'$now','$ip') ON DUPLICATE KEY UPDATE status=$status,uptime='$now' ";
  1355. self::$db->query($sql);
  1356. }
  1357. } else {
  1358. self::$db->query("delete from ws_kfonline ");
  1359. }
  1360. }
  1361. public static function resetServiceLog($kfid = 0)
  1362. {
  1363. $t = time() - 24 * 3600 * 7;
  1364. $now = time();
  1365. if ($kfid) {
  1366. if ((substr($kfid, 0, 2) == 'KF')) {
  1367. $kfid = intval(substr($kfid, 2));
  1368. }
  1369. $kfid = intval($kfid);
  1370. self::$db->query("update ws_service_log set status=2,end_time=$now where start_time>=$t and kf_id=$kfid and status!=2");
  1371. self::$redis->hdel(self::KFINFOKEY, 'KF' . $kfid);
  1372. } else {
  1373. self::$redis->del(self::KFINFOKEY);
  1374. self::$redis->del(self::USERLIST);
  1375. self::$redis->del(self::USERINFOKEY);
  1376. self::$redis->del('adminList');
  1377. self::$redis->del(self::WEBSOCKALLUSER);
  1378. self::$redis->del('SERVICELOG');
  1379. self::$db->query("update ws_service_log set status=2,end_time=$now where start_time>=$t and status!=2");
  1380. }
  1381. }
  1382. public static function onWorkerStop($businessWorker)
  1383. {
  1384. if ($businessWorker->id == 1) {
  1385. self::resetServiceLog();
  1386. }
  1387. }
  1388. //用户下线通知
  1389. private static function userCloseNotice($client_id, $cuid, $group)
  1390. {
  1391. }
  1392. //踢掉同一用户的旧用户
  1393. private static function tickOlduser($uid)
  1394. {
  1395. }
  1396. private static function DebugOut($msg, $title = '', $type = 'info')
  1397. {
  1398. $config = self::$global->systemconfig;
  1399. if (!isset($config['isdebug']) || empty($config['isdebug']['systemconfig_data'])) {
  1400. return;
  1401. }
  1402. if (!is_string($msg)) {
  1403. $msg = json_encode([$msg], 256);
  1404. }
  1405. $msg = date("Y-m-d H:i:s") . ' - ' . $type . ' - ' . $title . ' - ' . $msg . "\n";
  1406. echo $msg;
  1407. }
  1408. //定时器相关
  1409. private static function TimerThing($worker)
  1410. {
  1411. // 当天的累积接入值
  1412. $key = date('Ymd') . 'total_in';
  1413. if (is_null(self::$global->$key)) {
  1414. self::$global->$key = 0;
  1415. $oldKey = date('Ymd', strtotime('-1 day')); // 删除前一天的统计值
  1416. unset(self::$global->$oldKey);
  1417. unset($oldKey, $key);
  1418. }
  1419. // 成功接入值
  1420. $key = date('Ymd') . 'success_in';
  1421. if (is_null(self::$global->$key)) {
  1422. self::$global->$key = 0;
  1423. $oldKey = date('Ymd', strtotime('-1 day')); // 删除前一天的统计值
  1424. unset(self::$global->$oldKey);
  1425. unset($oldKey, $key);
  1426. }
  1427. // 定时统计数据
  1428. if (0 == $worker->id) {
  1429. self::writeLogKfStatus(0, 0, 0);
  1430. //每5秒更新进行一次人员分配
  1431. Timer::add(5, function () {
  1432. self::userOnlineTask();
  1433. });
  1434. //每1分钟报告一次本组排列人员(如果有人排队)
  1435. Timer::add(60, function () {
  1436. self::lineup();
  1437. });
  1438. // 1分钟统计一次实时数据
  1439. Timer::add(60 * 1, function () {
  1440. self::writeLog(1);
  1441. });
  1442. // 40分钟写一次当前日期点数的log数据
  1443. Timer::add(60 * 40, function () {
  1444. self::writeLog(2);
  1445. });
  1446. //初始化.....
  1447. self::upsystemconfig();
  1448. //每3分钟更新一次系统配置文件
  1449. Timer::add(60 * 3, function () {
  1450. self::upsystemconfig();
  1451. });
  1452. // 删除前一天的统计值
  1453. Timer::add(60 * 60 * 12, function () {
  1454. $oldKey = date('Ymd', strtotime('-1 day'));
  1455. unset(self::$global->$oldKey);
  1456. });
  1457. // 管理员实时监控.
  1458. Timer::add(20, function () {
  1459. // 获取在线管理员
  1460. $adminList = self::$redis->smembers('adminList');
  1461. if ($adminList) {
  1462. self::systemMonitoring($adminList);
  1463. }
  1464. });
  1465. // 检查对话时效给出.
  1466. Timer::add(40, function () {
  1467. self::overTime();
  1468. });
  1469. self::resetServiceLog();
  1470. }
  1471. }
  1472. //调试使用
  1473. public static function mydebug($client_id, $message)
  1474. {
  1475. }
  1476. public static function MySendMsg($clientId, $msg)
  1477. {
  1478. Gateway::sendToClient($clientId, $msg);
  1479. }
  1480. //得到客服的UID字符值
  1481. public static function getkfuid($uid)
  1482. {
  1483. if (substr($uid, 0, 2) == 'KF') {
  1484. return $uid;
  1485. } else {
  1486. return 'KF' . intval($uid);
  1487. }
  1488. }
  1489. //得到客服的ID整数值
  1490. public static function getkfid($id)
  1491. {
  1492. if (strtolower(substr($id, 0, 2)) == 'kf') {
  1493. return intval(substr($id, 2));
  1494. }
  1495. return intval($id);
  1496. }
  1497. //从数组中获取参数
  1498. public static function getPars($array, $key, $default = '')
  1499. {
  1500. if (isset($array[$key])) {
  1501. return $array[$key];
  1502. }
  1503. return $default;
  1504. }
  1505. //获取在线客服信息
  1506. public static function getOnlineKfData($group = 0, $status = 0)
  1507. {
  1508. $all = self::$redis->hgetall(self::KFINFOKEY);
  1509. if (!$all) {
  1510. return false;
  1511. }
  1512. $return = [];
  1513. foreach ($all as $val) {
  1514. $now = json_decode($val, true);
  1515. if ($group) {
  1516. if ($now['group'] != $group) {
  1517. continue;
  1518. }
  1519. }
  1520. if ($status) {
  1521. if ($now['status'] != $status) {
  1522. continue;
  1523. }
  1524. }
  1525. $return[$now['id']] = $now;
  1526. }
  1527. return $return;
  1528. }
  1529. //找到在排队的用户按时间先后顺序
  1530. public static function getUselistData($group)
  1531. {
  1532. $all = self::$redis->hgetall(self::USERLIST);
  1533. if (!$all) {
  1534. return false;
  1535. }
  1536. $return = [];
  1537. foreach ($all as $val) {
  1538. $now = json_decode($val, true);
  1539. if ($group == $now['group']) {
  1540. $return[] = $now;
  1541. }
  1542. }
  1543. usort($return, function ($a, $b) {
  1544. if ($a['intime'] == $b['intime']) {
  1545. return 0;
  1546. }
  1547. return $a['intime'] > $b['intime'] ? 1 : -1;
  1548. });
  1549. return $return;
  1550. }
  1551. //对客服的用户user_info数组进行加减操作 $clientid用户连接号 opt=1添加 0删除 $serverid服务工单号
  1552. public static function ArrayDataopt($array, $clientid, $opt, $serverid = 0)
  1553. {
  1554. if (!is_array($array)) {
  1555. return [];
  1556. }
  1557. if ($opt == 0) {
  1558. if (isset($array[$clientid])) {
  1559. unset($array[$clientid]);
  1560. }
  1561. return $array;
  1562. } else {
  1563. $array[$clientid] = $serverid;
  1564. return $array;
  1565. }
  1566. }
  1567. }