topics.js 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513
  1. /**
  2. * 议题模型。
  3. */
  4. "use strict";
  5. let RedisClient = require('../../repository/redis/redis.client.js');
  6. let TopicsRepo = require('../../repository/mysql/topics.repo');
  7. let SessionRepo = require('../../repository/mysql/session.repo');
  8. let TopicRepo = require('../../repository/mysql/topics.repo');
  9. let ParticipantRepo = require('../../repository/mysql/participant.repo');
  10. let RedisModel = require('./../redis.model.js');
  11. let ModelUtil = require('../../util/model.util');
  12. let Sessions = require("./sessions");
  13. let log = require('../../util/log.js');
  14. let redis = RedisClient.redisClient().connection;
  15. let configFile = require('../../include/commons').CONFIG_FILE;
  16. let config = require('../../resources/config/' + configFile);
  17. const REDIS_KEYS = require('../../include/commons').REDIS_KEYS;
  18. const TOPIC_STATUS = require('../../include/commons').TOPIC_STATUS;
  19. const SESSION_STATUS = require('../../include/commons').SESSION_STATUS;
  20. const SESSION_TYPES = require('../../include/commons').SESSION_TYPES;
  21. class Topics extends RedisModel {
  22. constructor() {
  23. super();
  24. }
  25. getTopics(user, status, page, pagesize, sessionType) {
  26. let self = this;
  27. let session = new Sessions();
  28. page = (page - 1 < 0 ? 0 : page - 1) * pagesize;
  29. if (!pagesize) pagesize = 10;
  30. pagesize = parseInt(pagesize);
  31. if (!sessionType) sessionType = SESSION_TYPES.MUC;
  32. SessionRepo.findAllByType(user, sessionType, function (err, res) {
  33. if (err) {
  34. ModelUtil.emitError(self.eventEmitter, "获取列表失败" + err);
  35. } else if (res && res.length == 0) {
  36. ModelUtil.emitOK(self.eventEmitter, []);
  37. }
  38. var sessionIds = [];
  39. for (var j in res) {
  40. sessionIds.push(res[j].id);
  41. }
  42. TopicsRepo.findAllBySessionIdsAndStatus(sessionIds, status, page, pagesize, function (err, res) {
  43. if (err) {
  44. ModelUtil.emitError(self.eventEmitter, "获取列表失败" + err);
  45. }
  46. else if (res && res.length == 0) {
  47. ModelUtil.emitOK(self.eventEmitter, []);
  48. } else {
  49. for (var j = 0; j < res.length; j++) {
  50. callAmount(j, res, res[j]);
  51. }
  52. }
  53. function callAmount(i, res, r) {
  54. session.getSessionUnreadMessageCount(res[i].session_id, user, function (err, msgcount) {
  55. if (err) {
  56. log.error("getSessionUnreadMessageCount is error:" + err);
  57. ModelUtil.emitError(self.eventEmitter, "获取未读消息失败!" + err);
  58. } else {
  59. callGetImg(i, res, r, msgcount);
  60. }
  61. })
  62. }
  63. var result = [];
  64. function callGetImg(i, res, r, msgcount) {
  65. ParticipantRepo.findAll(res[i].session_id, function (err, p) {
  66. if (err) {
  67. log.error("获取头像失败:" + err);
  68. } else {
  69. r.create_time = r.create_time.getTime();
  70. for (var j in p) {
  71. if (p[j].is_patient) {
  72. r.avatar = p[j].avatar;
  73. r.patient = p[j].id;
  74. r.patient_name = p[j].name;
  75. r.sex = p[j].sex;
  76. r.birthdate = p[j].birthdate.getTime();
  77. if (r.status != TOPIC_STATUS.ENDED) {
  78. r.msg_count = msgcount;
  79. }
  80. }
  81. }
  82. result.push(r);
  83. if (result.length == res.length) {
  84. ModelUtil.emitOK(self.eventEmitter, res);
  85. }
  86. }
  87. })
  88. }
  89. })
  90. })
  91. }
  92. /**
  93. * 根据状态和回复获取列表,已结束的不关心是否回复,所以传入status=10不reply无效
  94. * @param user
  95. * @param reply
  96. * @param status
  97. * @param page
  98. * @param pagesize
  99. */
  100. findAllByUserAndReplyAndStatus(users,reply, status, page, pagesize) {
  101. let self = this;
  102. page = (page - 1 < 0 ? 0 : page - 1) * pagesize;
  103. if (!pagesize) pagesize = 10;
  104. pagesize = parseInt(pagesize);
  105. TopicsRepo.findAllByUserAndReplyAndStatus(users,reply,status, page, pagesize, function (err, res) {
  106. if (err) {
  107. ModelUtil.emitError(self.eventEmitter, "获取列表失败" + err);
  108. }
  109. ModelUtil.emitOK(self.eventEmitter, res);
  110. })
  111. }
  112. /**
  113. * 根据状态和回复获取列表,(过滤名医咨询)
  114. * @param user
  115. * @param reply
  116. * @param status
  117. * @param page
  118. * @param pagesize
  119. */
  120. findAllByUserAndReplyAndStatusHealthTopic(users,reply, status, page, pagesize) {
  121. let self = this;
  122. page = (page - 1 < 0 ? 0 : page - 1) * pagesize;
  123. if (!pagesize) pagesize = 10;
  124. pagesize = parseInt(pagesize);
  125. TopicsRepo.findAllByUserAndReplyAndStatusHealthTopic(users,reply,status, page, pagesize, function (err, res) {
  126. if (err) {
  127. ModelUtil.emitError(self.eventEmitter, "获取列表失败" + err);
  128. }
  129. ModelUtil.emitOK(self.eventEmitter, res);
  130. })
  131. }
  132. /**
  133. * 根据状态和回复及行政团队code获取列表,(过滤名医咨询)
  134. * @param user
  135. * @param reply
  136. * @param status
  137. * @param page
  138. * @param pagesize
  139. */
  140. findAllByUserAndReplyAndStatusHealthTeamTopic(users,reply, status,adminTeamCode, page, pagesize) {
  141. let self = this;
  142. page = (page - 1 < 0 ? 0 : page - 1) * pagesize;
  143. if (!pagesize) pagesize = 10;
  144. pagesize = parseInt(pagesize);
  145. TopicsRepo.findAllByUserAndReplyAndStatusHealthTeamTopic(users,reply,status,adminTeamCode, page, pagesize, function (err, res) {
  146. if (err) {
  147. ModelUtil.emitError(self.eventEmitter, "获取列表失败" + err);
  148. }
  149. ModelUtil.emitOK(self.eventEmitter, res);
  150. })
  151. }
  152. findReplyCount(users,reply, status,adminTeamCode) {
  153. let self = this;
  154. TopicsRepo.findReplyCount(users,reply,status,adminTeamCode, function (err, res) {
  155. if (err) {
  156. ModelUtil.emitError(self.eventEmitter, "获取列表失败" + err);
  157. }
  158. ModelUtil.emitOK(self.eventEmitter, res);
  159. })
  160. }
  161. /**
  162. * 根据topicId获取对应的消息
  163. * @param topicId
  164. * @param user
  165. * @param startMsgId
  166. * @param endMsgId
  167. * @param page
  168. * @param pagesize
  169. */
  170. getTopicMessages(topicId, user, startMsgId, endMsgId, page, pagesize) {
  171. let self = this;
  172. TopicsRepo.findAllByTopicId(topicId, function (err, res) {
  173. if (err || res.length == 0) {
  174. ModelUtil.emitOK(self.eventEmitter, {status: -1, message: "找不到对应的会话记录!"});
  175. }
  176. if(!res[0]||!res[0].session_id){
  177. ModelUtil.emitOK(self.eventEmitter, {status: -1, message: err});
  178. }
  179. let sessions = new Sessions();
  180. sessions.getMessages(res[0].session_id, user, startMsgId, endMsgId, page, pagesize, 0, function (err, messages) {
  181. if (err) {
  182. ModelUtil.emitOK(self.eventEmitter, {status: 200, data: {"list":[],"users":[]}});
  183. } else {
  184. if (messages && messages.length > 0) {
  185. ParticipantRepo.findAll(res[0].session_id, function (err, users) {
  186. if (err) {
  187. ModelUtil.emitOK(self.eventEmitter, {status: -1, message: err});
  188. } else {
  189. ModelUtil.emitOK(self.eventEmitter, {status: 200, data: {"list": messages, "users": users}});
  190. }
  191. })
  192. } else {
  193. ModelUtil.emitOK(self.eventEmitter, {status: 200, data: []});
  194. }
  195. }
  196. });
  197. })
  198. }
  199. /**
  200. * 创建议题。
  201. *
  202. * @param topicName 发起议题的名称
  203. * @param topicId
  204. * @param sessionId
  205. * @param users 发起议题的患者,格式:{"userId1:role", "userId2:role"}
  206. * @param messages 发送的消息对象,格式:{description:"",title:"",img:"image1,image2",sender_id:"",sender_name:""},多个图片用逗号隔开
  207. */
  208. createTopic(topicName, topicId, sessionId, users, messages, sessionType) {
  209. let self = this;
  210. if (!sessionId && (sessionType == SESSION_TYPES.MUC|| sessionType == SESSION_TYPES.PRESCRIPTION)) {
  211. ModelUtil.emitOK(self.eventEmitter, {status: -1, message: "会话ID为空,请先生成会话ID"});
  212. return;
  213. }
  214. if (!topicId) {
  215. ModelUtil.emitOK(self.eventEmitter, {status: -1, message: "议题ID为空,请先生成议题ID"});
  216. return;
  217. }
  218. var pars = [];
  219. for (var j in users) {
  220. pars.push(j + ":" + users[j]);
  221. }
  222. let sessions = new Sessions();
  223. sessions.createSession(sessionId, messages.sender_name, sessionType, pars, function (err, session) {
  224. sessionId = session.id;
  225. let datetime = session.create_date;
  226. //新增判断是否有未结束的咨询,用户网络差,会多次点击造成同时存在多个咨询
  227. TopicRepo.findLastBySessionId(sessionId,function(err,res){
  228. if(res&&res.length>0&&res[0].status!=10){
  229. ModelUtil.emitOK(self.eventEmitter, {status: -1, message: "还有咨询未结束,不允许再次提交咨询!"});
  230. return;
  231. }else{
  232. self.saveTopicToRedis(topicName, topicId, sessionId, messages, datetime, function (err, startMsgId) {
  233. if (err) {
  234. ModelUtil.emitOK(self.eventEmitter, {status: -1, message: "议题创建失败!"});
  235. return;
  236. }
  237. //返回给前端
  238. ModelUtil.emitOK(self.eventEmitter, {status: 200, message: "议题创建成功!", start_msg_id: startMsgId});
  239. sessions.updateSessionStatus(sessionId,SESSION_STATUS.PROCEEDINGS,function(err,res){});
  240. //执行数据库操作
  241. self.saveTopicToMySQL(topicName, topicId, sessionId, startMsgId, new Date(datetime), messages.description, TOPIC_STATUS.NEW, messages.agent, function (err, res) {
  242. if (err) {
  243. ModelUtil.logError("Save topic to mysql failed", err);
  244. }
  245. })
  246. })
  247. }
  248. })
  249. });
  250. }
  251. saveTopicToRedis(topicName, topicId, sessionId, messages, datetime, handler) {
  252. let topics_key = RedisModel.makeRedisKey(REDIS_KEYS.Topics, sessionId);
  253. let topic_key = RedisModel.makeRedisKey(REDIS_KEYS.Topic, topicId);
  254. let sessions = new Sessions();
  255. //step1:创建topic到redis
  256. redis.zaddAsync(topics_key, datetime, topicId).then(function (res) {
  257. redis.hmsetAsync(topic_key, "name", topicName,
  258. "session_id", sessionId, "create_time", datetime,
  259. "description", messages.description, "status", TOPIC_STATUS.NEW,
  260. "end_time", "", "end_by", ""
  261. ).then(function (res) {
  262. sendBeginMsg();
  263. }).catch(function (err) {
  264. handler(err, null);
  265. return;
  266. });
  267. }).catch(function (err) {
  268. handler(err, null);
  269. return;
  270. });
  271. //step2:发送开始会话
  272. function sendBeginMsg() {
  273. let msg = {};
  274. msg.sender_id = messages.sender_id;
  275. msg.sender_name = "系统";//messages.sender_name;发起和结束咨询的消息由系统发出,发送者ID记录操作人!
  276. msg.content_type = 10;
  277. msg.content = messages.sender_name + "发起了咨询";
  278. msg.agent = null;
  279. msg.timestamp = new Date(datetime);
  280. sessions.saveMessageByTopic(msg, sessionId, function (err, msgId) {
  281. if (err) {
  282. handler(err, null);
  283. } else {
  284. sendQuesionMsg();
  285. handler(null, msgId);
  286. }
  287. })
  288. }
  289. //step3:发送求助内容的文本
  290. function sendQuesionMsg() {
  291. let msg = {};
  292. msg.sender_id = messages.sender_id;
  293. msg.sender_name = messages.sender_name;
  294. msg.content_type = 6;
  295. msg.content = messages.description;
  296. msg.agent = messages.agent;
  297. msg.timestamp = new Date(datetime+200);
  298. sessions.saveMessageByTopic(msg, sessionId, function (err, msgId) {
  299. if (messages.img) {
  300. setTimeout(function(){
  301. sendQuesionImg();
  302. },100);
  303. }
  304. if (err) {
  305. log.info("send create message error " + msg);
  306. }
  307. });
  308. }
  309. //step4:发送求助内容的图片
  310. function sendQuesionImg() {
  311. let imgs = messages.img.split(",");
  312. for (var j in imgs) {
  313. let msgimg = {};
  314. msgimg.sender_id = messages.sender_id;
  315. msgimg.sender_name = messages.sender_name;
  316. msgimg.content_type = 2;
  317. msgimg.content = imgs[j];
  318. msgimg.agent = messages.agent;
  319. msgimg.timestamp = new Date(datetime+(200*j));
  320. sessions.saveMessageByTopic(msgimg, sessionId, function (err, msgId) {
  321. if (err) {
  322. log.info("send create img error " + imgs[j]);
  323. }
  324. })
  325. }
  326. }
  327. }
  328. saveTopicToMySQL(topicName, topicId, sessionId, messageId, date, description, status, agent, handler) {
  329. TopicsRepo.saveTopic(topicName, topicId, sessionId, messageId, date, description, status, agent, handler);
  330. }
  331. /**
  332. * 议题是否已结束。
  333. *
  334. * @param sessionId
  335. * @param topicId
  336. * @param handler
  337. */
  338. isTopicEnded(sessionId, topicId, handler) {
  339. let self = this;
  340. if (topicId == "current") {
  341. TopicsRepo.findLastTopicStatus(sessionId, callback);
  342. } else {
  343. TopicsRepo.findTopicStatus(topicId, callback);
  344. }
  345. function callback(err, res) {
  346. if (err) {
  347. handler != null ? handler(err, res) : ModelUtil.emitError(self.eventEmitter, err);
  348. } else {
  349. if (null == res) {
  350. handler != null ? handler(err, res) : ModelUtil.emitOK(self.eventEmitter, {});
  351. } else {
  352. let ended = res[0].status == TOPIC_STATUS.ENDED;
  353. handler != null ? handler(err, res) : ModelUtil.emitOK(self.eventEmitter, res[0]);
  354. }
  355. }
  356. }
  357. }
  358. /**
  359. * 结束议题
  360. * @param topicId
  361. * @param endUser
  362. * @param endUserName
  363. */
  364. endTopic(topicId, endUser, endUserName,agent) {
  365. let endDate = new Date();
  366. let self = this;
  367. let topic_key = RedisModel.makeRedisKey(REDIS_KEYS.Topic, topicId);
  368. redis.hmsetAsync(topic_key, "end_time", endDate.getTime(), "end_by", endUser, "status", TOPIC_STATUS.ENDED).then(function (res) {
  369. redis.hgetallAsync(topic_key).then(function (topic) {
  370. callEnd(topic.session_id);
  371. })
  372. });
  373. /**
  374. * 结束消息发送
  375. */
  376. function callEnd(sessionId) {
  377. let msg = {
  378. sender_id: endUser,
  379. sender_name: "系统",//endUserName,发起和结束咨询的消息由系统发出,发送者ID记录操作人!
  380. agent: agent,
  381. content_type: 7,
  382. content: endUserName + "结束了咨询",
  383. timestamp: new Date()
  384. };
  385. let sessions = new Sessions();
  386. sessions.saveMessageByTopic(msg, sessionId, function (err, msgId) {
  387. if (err) {
  388. ModelUtil.emitOK(self.eventEmitter, {status: -1, "message": err});
  389. } else {
  390. ModelUtil.emitOK(self.eventEmitter, {status: 200, "id": msgId, "message": "结束成功!"});
  391. TopicsRepo.endTopic(topicId, endUser, msg.timestamp, msgId, TOPIC_STATUS.ENDED);
  392. sessions.updateSessionStatus(sessionId,SESSION_STATUS.ENDED,function(err,res){
  393. log.info("update session end is success!");
  394. });
  395. }
  396. })
  397. }
  398. }
  399. /**
  400. * 进入议题(发送提示医生,医生不在线就不发送)
  401. * @param topicId
  402. * @param intoUser
  403. * @param intoUserName
  404. */
  405. intoTopic(topicId,intoUser,intoUserName,senderId,content){
  406. let intoDate = new Date();
  407. let self = this;
  408. let topic_key = RedisModel.makeRedisKey(REDIS_KEYS.Topic, topicId);
  409. redis.hmsetAsync(topic_key, "into_time", intoDate.getTime(), "into_by", intoUser).then(function (res) {
  410. redis.hgetallAsync(topic_key).then(function (topic) {
  411. callEnd(topic.session_id);
  412. })
  413. });
  414. let agent = null;
  415. if(senderId!=intoUser){
  416. agent = intoUser;
  417. }
  418. /**
  419. * 进入消息发送
  420. */
  421. function callEnd(sessionId) {
  422. let msg = {
  423. sender_id: senderId,
  424. sender_name: "系统",//endUserName,发起和结束(进入)咨询的消息由系统发出,发送者ID记录操作人!
  425. content_type: 14,
  426. //content: intoUserName + "进入了咨询",
  427. content: content,
  428. agent: agent,
  429. timestamp: new Date()
  430. };
  431. let sessions = new Sessions();
  432. sessions.saveIntoMessageByTopic(msg, sessionId, function (err, msgId) {
  433. if (err) {
  434. ModelUtil.emitOK(self.eventEmitter, {status: -1, "message": err});
  435. } else {
  436. ModelUtil.emitOK(self.eventEmitter, {status: 200, "id": msgId, "message": "进入成功!"});
  437. }
  438. })
  439. }
  440. }
  441. updateTopic(topicId, valueJson) {
  442. let self = this;
  443. let topickey = RedisModel.makeRedisKey(REDIS_KEYS.Topic, topicId);
  444. var dataArray = [];
  445. for (var j in valueJson) {
  446. dataArray.push(j);
  447. dataArray.push(valueJson[j]);
  448. }
  449. redis.hmsetAsync(topickey, dataArray).then(function (res) {
  450. TopicsRepo.updateTopics(topicId, valueJson, function (err, res) {
  451. if (!err) {
  452. ModelUtil.emitOK(self.eventEmitter, {"status": 200});
  453. } else {
  454. ModelUtil.emitOK(self.eventEmitter, {"status": -1});
  455. }
  456. });
  457. });
  458. }
  459. getTopicByTopicId(topicId){
  460. let self = this;
  461. TopicsRepo.findAllByTopicId(topicId,function (err,res) {
  462. if (!err) {
  463. ModelUtil.emitOK(self.eventEmitter, {"status": 200,"data":res});
  464. } else {
  465. ModelUtil.emitOK(self.eventEmitter, {"status": -1});
  466. }
  467. })
  468. }
  469. }
  470. // Expose class
  471. module.exports = Topics;