server/api/chatGroup/chatGroup.controller.js

   1 // *************************************************************************
   2 // *                                                                       *
   3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
   4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
   5 // *                                                                       *
   6 // *************************************************************************
   7 // *                                                                       *
   8 // * Email: info@xcally.com                                                *
   9 // * Website: https://www.xcally.com                                       *
  10 // *                                                                       *
  11 // *************************************************************************
  12 // *                                                                       *
  13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
  14 // * copyright treaties, as well as other intellectual property laws and   *
  15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
  16 // *                                                                       *
  17 // *************************************************************************
  18 var _0x9a39=['socket.io-emitter','register','sendStatus','status','json','offset','undefined','limit','count','set','apply','reject','save','update','then','destroy','end','error','stack','name','send','map','ChatGroup','rawAttributes','fieldName','key','model','query','keys','filters','intersection','attributes','fields','hasOwnProperty','nolimit','sort','where','pick','filter','type','VIRTUAL','merge','options','includeAll','include','findAll','catch','show','params','length','find','create','body','describe','getUnread','ChatInternalMessage','user','addMembers','omit','ids','getMembers','User','order','removeMembers','addMessage','ChatGroupId','getMessages','findOne','$gte','split','format','YYYY-MM-DD\x20HH:mm:ss','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','api','../../config/utils','../../config/license/util','redis','defaults'];(function(_0x2bc579,_0x5a54d1){var _0x88c913=function(_0x56ec98){while(--_0x56ec98){_0x2bc579['push'](_0x2bc579['shift']());}};_0x88c913(++_0x5a54d1);}(_0x9a39,0xaa));var _0x99a3=function(_0x2da15f,_0x5c12fe){_0x2da15f=_0x2da15f-0x0;var _0x49a15f=_0x9a39[_0x2da15f];return _0x49a15f;};'use strict';var emlformat=require(_0x99a3('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x99a3('0x1'));var jsonpatch=require(_0x99a3('0x2'));var rp=require(_0x99a3('0x3'));var moment=require(_0x99a3('0x4'));var BPromise=require(_0x99a3('0x5'));var Mustache=require(_0x99a3('0x6'));var util=require(_0x99a3('0x7'));var path=require(_0x99a3('0x8'));var sox=require(_0x99a3('0x9'));var csv=require(_0x99a3('0xa'));var ejs=require(_0x99a3('0xb'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x99a3('0xc'));var squel=require(_0x99a3('0xd'));var crypto=require('crypto');var jsforce=require(_0x99a3('0xe'));var deskjs=require(_0x99a3('0xf'));var toCsv=require(_0x99a3('0xa'));var querystring=require(_0x99a3('0x10'));var Papa=require(_0x99a3('0x11'));var Redis=require(_0x99a3('0x12'));var authService=require('../../components/auth/service');var qs=require(_0x99a3('0x13'));var as=require(_0x99a3('0x14'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0x99a3('0x15'));var utils=require(_0x99a3('0x16'));var config=require('../../config/environment');var licenseUtil=require(_0x99a3('0x17'));var db=require('../../mysqldb')['db'];config[_0x99a3('0x18')]=_[_0x99a3('0x19')](config[_0x99a3('0x18')],{'host':'localhost','port':0x18eb});var socket=require(_0x99a3('0x1a'))(new Redis(config['redis']));require('./chatGroup.socket')[_0x99a3('0x1b')](socket);function respondWithStatusCode(_0x32e665,_0x2b5bcb){_0x2b5bcb=_0x2b5bcb||0xcc;return function(_0x56a0e7){if(_0x56a0e7){return _0x32e665[_0x99a3('0x1c')](_0x2b5bcb);}return _0x32e665[_0x99a3('0x1d')](_0x2b5bcb)['end']();};}function respondWithResult(_0x43642e,_0x23a048){_0x23a048=_0x23a048||0xc8;return function(_0x36dae4){if(_0x36dae4){return _0x43642e[_0x99a3('0x1d')](_0x23a048)[_0x99a3('0x1e')](_0x36dae4);}};}function respondWithFilteredResult(_0x481629,_0x4d943b){return function(_0x4f976c){if(_0x4f976c){var _0x1036ac=typeof _0x4d943b[_0x99a3('0x1f')]===_0x99a3('0x20')&&typeof _0x4d943b[_0x99a3('0x21')]===_0x99a3('0x20');var _0xd26e9e=_0x4f976c[_0x99a3('0x22')];var _0x633355=_0x1036ac?0x0:_0x4d943b[_0x99a3('0x1f')];var _0x1f5f85=_0x1036ac?_0x4f976c['count']:_0x4d943b[_0x99a3('0x1f')]+_0x4d943b['limit'];var _0x3e651d;if(_0x1f5f85>=_0xd26e9e){_0x1f5f85=_0xd26e9e;_0x3e651d=0xc8;}else{_0x3e651d=0xce;}_0x481629['status'](_0x3e651d);return _0x481629[_0x99a3('0x23')]('Content-Range',_0x633355+'-'+_0x1f5f85+'/'+_0xd26e9e)[_0x99a3('0x1e')](_0x4f976c);}return null;};}function patchUpdates(_0xc0c31){return function(_0x1d66e4){try{jsonpatch[_0x99a3('0x24')](_0x1d66e4,_0xc0c31,!![]);}catch(_0x14ba98){return BPromise[_0x99a3('0x25')](_0x14ba98);}return _0x1d66e4[_0x99a3('0x26')]();};}function saveUpdates(_0x3d3f2d,_0x5219ec){return function(_0x456489){if(_0x456489){return _0x456489[_0x99a3('0x27')](_0x3d3f2d)[_0x99a3('0x28')](function(_0x29e1cd){return _0x29e1cd;});}return null;};}function removeEntity(_0x5f9309,_0x5ef067){return function(_0x18e3d2){if(_0x18e3d2){return _0x18e3d2[_0x99a3('0x29')]()['then'](function(){_0x5f9309[_0x99a3('0x1d')](0xcc)[_0x99a3('0x2a')]();});}};}function handleEntityNotFound(_0x30876f,_0x404266){return function(_0x406741){if(!_0x406741){_0x30876f[_0x99a3('0x1c')](0x194);}return _0x406741;};}function handleError(_0xd4108,_0x15b56e){_0x15b56e=_0x15b56e||0x1f4;return function(_0x4b11b9){logger[_0x99a3('0x2b')](_0x4b11b9[_0x99a3('0x2c')]);if(_0x4b11b9['name']){delete _0x4b11b9[_0x99a3('0x2d')];}_0xd4108[_0x99a3('0x1d')](_0x15b56e)[_0x99a3('0x2e')](_0x4b11b9);};}exports['index']=function(_0x379374,_0x46fb04){var _0x13031c={},_0x89c746={},_0x38360f={'count':0x0,'rows':[]};var _0xc76ae5=_[_0x99a3('0x2f')](db[_0x99a3('0x30')][_0x99a3('0x31')],function(_0x1398f7){return{'name':_0x1398f7[_0x99a3('0x32')],'type':_0x1398f7['type'][_0x99a3('0x33')]};});_0x89c746[_0x99a3('0x34')]=_[_0x99a3('0x2f')](_0xc76ae5,_0x99a3('0x2d'));_0x89c746[_0x99a3('0x35')]=_[_0x99a3('0x36')](_0x379374[_0x99a3('0x35')]);_0x89c746[_0x99a3('0x37')]=_[_0x99a3('0x38')](_0x89c746[_0x99a3('0x34')],_0x89c746[_0x99a3('0x35')]);_0x13031c[_0x99a3('0x39')]=_['intersection'](_0x89c746[_0x99a3('0x34')],qs[_0x99a3('0x3a')](_0x379374[_0x99a3('0x35')]['fields']));_0x13031c[_0x99a3('0x39')]=_0x13031c[_0x99a3('0x39')]['length']?_0x13031c[_0x99a3('0x39')]:_0x89c746[_0x99a3('0x34')];if(!_0x379374[_0x99a3('0x35')][_0x99a3('0x3b')](_0x99a3('0x3c'))){_0x13031c['limit']=qs[_0x99a3('0x21')](_0x379374[_0x99a3('0x35')][_0x99a3('0x21')]);_0x13031c[_0x99a3('0x1f')]=qs['offset'](_0x379374[_0x99a3('0x35')][_0x99a3('0x1f')]);}_0x13031c['order']=qs[_0x99a3('0x3d')](_0x379374[_0x99a3('0x35')][_0x99a3('0x3d')]);_0x13031c[_0x99a3('0x3e')]=qs[_0x99a3('0x37')](_[_0x99a3('0x3f')](_0x379374[_0x99a3('0x35')],_0x89c746[_0x99a3('0x37')]),_0xc76ae5);if(_0x379374[_0x99a3('0x35')][_0x99a3('0x40')]){_0x13031c[_0x99a3('0x3e')]=_['merge'](_0x13031c[_0x99a3('0x3e')],{'$or':_[_0x99a3('0x2f')](_0xc76ae5,function(_0x6b8e60){if(_0x6b8e60[_0x99a3('0x41')]!==_0x99a3('0x42')){var _0x3b1d5c={};_0x3b1d5c[_0x6b8e60['name']]={'$like':'%'+_0x379374[_0x99a3('0x35')][_0x99a3('0x40')]+'%'};return _0x3b1d5c;}})});}_0x13031c=_[_0x99a3('0x43')]({},_0x13031c,_0x379374[_0x99a3('0x44')]);var _0x45a165={'where':_0x13031c[_0x99a3('0x3e')]};return db[_0x99a3('0x30')][_0x99a3('0x22')](_0x45a165)['then'](function(_0xc8d36d){_0x38360f['count']=_0xc8d36d;if(_0x379374[_0x99a3('0x35')][_0x99a3('0x45')]){_0x13031c[_0x99a3('0x46')]=[{'all':!![]}];}return db[_0x99a3('0x30')][_0x99a3('0x47')](_0x13031c);})['then'](function(_0x58f3c9){_0x38360f['rows']=_0x58f3c9;return _0x38360f;})[_0x99a3('0x28')](respondWithFilteredResult(_0x46fb04,_0x13031c))[_0x99a3('0x48')](handleError(_0x46fb04,null));};exports[_0x99a3('0x49')]=function(_0x59a904,_0x4e4a9f){var _0x8ae65a={'raw':!![],'where':{'id':_0x59a904[_0x99a3('0x4a')]['id']}},_0xb9e459={};_0xb9e459[_0x99a3('0x34')]=_[_0x99a3('0x36')](db[_0x99a3('0x30')][_0x99a3('0x31')]);_0xb9e459[_0x99a3('0x35')]=_[_0x99a3('0x36')](_0x59a904[_0x99a3('0x35')]);_0xb9e459[_0x99a3('0x37')]=_['intersection'](_0xb9e459['model'],_0xb9e459[_0x99a3('0x35')]);_0x8ae65a[_0x99a3('0x39')]=_['intersection'](_0xb9e459[_0x99a3('0x34')],qs['fields'](_0x59a904[_0x99a3('0x35')][_0x99a3('0x3a')]));_0x8ae65a[_0x99a3('0x39')]=_0x8ae65a['attributes'][_0x99a3('0x4b')]?_0x8ae65a[_0x99a3('0x39')]:_0xb9e459[_0x99a3('0x34')];if(_0x59a904['query'][_0x99a3('0x45')]){_0x8ae65a['include']=[{'all':!![]}];}_0x8ae65a=_['merge']({},_0x8ae65a,_0x59a904[_0x99a3('0x44')]);return db[_0x99a3('0x30')][_0x99a3('0x4c')](_0x8ae65a)[_0x99a3('0x28')](handleEntityNotFound(_0x4e4a9f,null))[_0x99a3('0x28')](respondWithResult(_0x4e4a9f,null))['catch'](handleError(_0x4e4a9f,null));};exports[_0x99a3('0x4d')]=function(_0x35917c,_0x5abce5){return db[_0x99a3('0x30')][_0x99a3('0x4d')](_0x35917c['body'],{})[_0x99a3('0x28')](respondWithResult(_0x5abce5,0xc9))[_0x99a3('0x48')](handleError(_0x5abce5,null));};exports['update']=function(_0x283d14,_0x3fb05f){if(_0x283d14[_0x99a3('0x4e')]['id']){delete _0x283d14[_0x99a3('0x4e')]['id'];}return db[_0x99a3('0x30')][_0x99a3('0x4c')]({'where':{'id':_0x283d14[_0x99a3('0x4a')]['id']}})['then'](handleEntityNotFound(_0x3fb05f,null))[_0x99a3('0x28')](saveUpdates(_0x283d14['body'],null))[_0x99a3('0x28')](respondWithResult(_0x3fb05f,null))[_0x99a3('0x48')](handleError(_0x3fb05f,null));};exports[_0x99a3('0x29')]=function(_0x302ea4,_0x2b47e4){return db[_0x99a3('0x30')][_0x99a3('0x4c')]({'where':{'id':_0x302ea4[_0x99a3('0x4a')]['id']}})[_0x99a3('0x28')](handleEntityNotFound(_0x2b47e4,null))[_0x99a3('0x28')](removeEntity(_0x2b47e4,null))[_0x99a3('0x48')](handleError(_0x2b47e4,null));};exports[_0x99a3('0x4f')]=function(_0x51dbd7,_0x25977c){return db[_0x99a3('0x30')][_0x99a3('0x4f')]()[_0x99a3('0x28')](respondWithResult(_0x25977c,null))['catch'](handleError(_0x25977c,null));};exports[_0x99a3('0x50')]=function(_0xdd9999,_0x35d7ca,_0x2f81c0){return db[_0x99a3('0x51')][_0x99a3('0x22')]({'where':{'ChatGroupId':_0xdd9999[_0x99a3('0x4a')]['id'],'ToId':_0xdd9999[_0x99a3('0x52')]['id'],'read':![]}})[_0x99a3('0x28')](function(_0x5218fc){return{'id':_['toInteger'](_0xdd9999[_0x99a3('0x4a')]['id']),'count':_0x5218fc};})['then'](respondWithResult(_0x35d7ca,null))[_0x99a3('0x48')](handleError(_0x35d7ca,null));};exports[_0x99a3('0x53')]=function(_0x3a42d0,_0x40c52b,_0x263d7e){return db[_0x99a3('0x30')][_0x99a3('0x4c')]({'where':{'id':_0x3a42d0[_0x99a3('0x4a')]['id']}})[_0x99a3('0x28')](handleEntityNotFound(_0x40c52b,null))[_0x99a3('0x28')](function(_0x29ca4c){if(_0x29ca4c){return _0x29ca4c[_0x99a3('0x53')](_0x3a42d0[_0x99a3('0x4e')]['ids'],_[_0x99a3('0x54')](_0x3a42d0[_0x99a3('0x4e')],[_0x99a3('0x55'),'id'])||{});}})['then'](respondWithResult(_0x40c52b,null))['catch'](handleError(_0x40c52b,null));};exports[_0x99a3('0x56')]=function(_0x5a3397,_0x28aec6,_0x2083d9){var _0x146f43={};var _0x5e153c={};var _0x2f6cad;var _0x3bc653;return db[_0x99a3('0x30')]['findOne']({'where':{'id':_0x5a3397[_0x99a3('0x4a')]['id']}})['then'](handleEntityNotFound(_0x28aec6,null))['then'](function(_0x38bcc9){if(_0x38bcc9){_0x2f6cad=_0x38bcc9;_0x5e153c[_0x99a3('0x34')]=_[_0x99a3('0x36')](db[_0x99a3('0x57')][_0x99a3('0x31')]);_0x5e153c[_0x99a3('0x35')]=_[_0x99a3('0x36')](_0x5a3397[_0x99a3('0x35')]);_0x5e153c['filters']=_[_0x99a3('0x38')](_0x5e153c[_0x99a3('0x34')],_0x5e153c[_0x99a3('0x35')]);_0x146f43[_0x99a3('0x39')]=_['intersection'](_0x5e153c['model'],qs[_0x99a3('0x3a')](_0x5a3397[_0x99a3('0x35')][_0x99a3('0x3a')]));_0x146f43['attributes']=_0x146f43[_0x99a3('0x39')][_0x99a3('0x4b')]?_0x146f43[_0x99a3('0x39')]:_0x5e153c[_0x99a3('0x34')];_0x146f43[_0x99a3('0x58')]=qs[_0x99a3('0x3d')](_0x5a3397[_0x99a3('0x35')][_0x99a3('0x3d')]);_0x146f43[_0x99a3('0x3e')]=qs['filters'](_[_0x99a3('0x3f')](_0x5a3397[_0x99a3('0x35')],_0x5e153c[_0x99a3('0x37')]));if(_0x5a3397['query'][_0x99a3('0x40')]){_0x146f43[_0x99a3('0x3e')]=_['merge'](_0x146f43['where'],{'$or':_[_0x99a3('0x2f')](_0x146f43[_0x99a3('0x39')],function(_0x83e631){var _0xaf58e2={};_0xaf58e2[_0x83e631]={'$like':'%'+_0x5a3397[_0x99a3('0x35')]['filter']+'%'};return _0xaf58e2;})});}_0x146f43=_[_0x99a3('0x43')]({},_0x146f43,_0x5a3397['options']);return _0x2f6cad[_0x99a3('0x56')](_0x146f43);}})['then'](function(_0x2a5960){if(_0x2a5960){_0x3bc653=_0x2a5960[_0x99a3('0x4b')];if(!_0x5a3397['query']['hasOwnProperty']('nolimit')){_0x146f43[_0x99a3('0x21')]=qs[_0x99a3('0x21')](_0x5a3397[_0x99a3('0x35')][_0x99a3('0x21')]);_0x146f43[_0x99a3('0x1f')]=qs[_0x99a3('0x1f')](_0x5a3397[_0x99a3('0x35')]['offset']);}return _0x2f6cad[_0x99a3('0x56')](_0x146f43);}})['then'](function(_0xc4e50c){if(_0xc4e50c){return _0xc4e50c?{'count':_0x3bc653,'rows':_0xc4e50c}:null;}})[_0x99a3('0x28')](respondWithResult(_0x28aec6,null))[_0x99a3('0x48')](handleError(_0x28aec6,null));};exports[_0x99a3('0x59')]=function(_0x58423c,_0x4c8c6e,_0x108dbf){return db['ChatGroup'][_0x99a3('0x4c')]({'where':{'id':_0x58423c['params']['id']}})['then'](handleEntityNotFound(_0x4c8c6e,null))[_0x99a3('0x28')](function(_0x264a23){if(_0x264a23){return _0x264a23[_0x99a3('0x59')](_0x58423c[_0x99a3('0x35')]['ids']);}})['then'](respondWithStatusCode(_0x4c8c6e,null))[_0x99a3('0x48')](handleError(_0x4c8c6e,null));};exports[_0x99a3('0x5a')]=function(_0x112433,_0x1993e5,_0x1bc67b){if(_0x112433[_0x99a3('0x4e')]['id']){delete _0x112433[_0x99a3('0x4e')]['id'];}return db[_0x99a3('0x30')]['find']({'where':{'id':_0x112433[_0x99a3('0x4a')]['id']}})['then'](handleEntityNotFound(_0x1993e5,null))['then'](function(_0x575218){if(_0x575218){_0x112433['body'][_0x99a3('0x5b')]=_0x575218['id'];return db[_0x99a3('0x51')][_0x99a3('0x4d')](_0x112433[_0x99a3('0x4e')]);}})['then'](respondWithResult(_0x1993e5,null))[_0x99a3('0x48')](handleError(_0x1993e5,null));};exports[_0x99a3('0x5c')]=function(_0x79560b,_0x25a320,_0x41eb95){var _0x1ce4b0={};var _0x2c9fd3={};var _0x4a94fe;var _0x4797d3;return db['ChatGroup'][_0x99a3('0x5d')]({'where':{'id':_0x79560b[_0x99a3('0x4a')]['id']}})[_0x99a3('0x28')](handleEntityNotFound(_0x25a320,null))[_0x99a3('0x28')](function(_0x176901){if(_0x176901){_0x4a94fe=_0x176901;_0x2c9fd3[_0x99a3('0x34')]=_[_0x99a3('0x36')](db[_0x99a3('0x51')][_0x99a3('0x31')]);_0x2c9fd3[_0x99a3('0x35')]=_[_0x99a3('0x36')](_0x79560b['query']);_0x2c9fd3['filters']=_[_0x99a3('0x38')](_0x2c9fd3[_0x99a3('0x34')],_0x2c9fd3[_0x99a3('0x35')]);_0x1ce4b0[_0x99a3('0x39')]=_[_0x99a3('0x38')](_0x2c9fd3['model'],qs[_0x99a3('0x3a')](_0x79560b['query'][_0x99a3('0x3a')]));_0x1ce4b0[_0x99a3('0x39')]=_0x1ce4b0[_0x99a3('0x39')]['length']?_0x1ce4b0['attributes']:_0x2c9fd3['model'];_0x1ce4b0['order']=qs['sort'](_0x79560b[_0x99a3('0x35')][_0x99a3('0x3d')]);_0x1ce4b0['where']=qs[_0x99a3('0x37')](_['pick'](_0x79560b[_0x99a3('0x35')],_0x2c9fd3[_0x99a3('0x37')]));if(_0x79560b[_0x99a3('0x35')]['filter']){_0x1ce4b0[_0x99a3('0x3e')]=_[_0x99a3('0x43')](_0x1ce4b0[_0x99a3('0x3e')],{'$or':_[_0x99a3('0x2f')](_0x1ce4b0['attributes'],function(_0x4fc72b){var _0x1f25b8={};_0x1f25b8[_0x4fc72b]={'$like':'%'+_0x79560b[_0x99a3('0x35')][_0x99a3('0x40')]+'%'};return _0x1f25b8;})});}if(_0x79560b[_0x99a3('0x35')][_0x99a3('0x5e')]){var _0x1002c2=_0x79560b[_0x99a3('0x35')]['$gte'][_0x99a3('0x5f')](',');var _0x5adf18={};_0x5adf18[_0x1002c2[0x0]]={'$gte':moment(_0x1002c2[0x1])[_0x99a3('0x60')](_0x99a3('0x61'))};_0x1ce4b0['where']=_['merge'](_0x1ce4b0[_0x99a3('0x3e')],_0x5adf18);}_0x1ce4b0=_['merge']({},_0x1ce4b0,_0x79560b[_0x99a3('0x44')]);return _0x4a94fe['getMessages'](_0x1ce4b0);}})[_0x99a3('0x28')](function(_0x2a996f){if(_0x2a996f){_0x4797d3=_0x2a996f[_0x99a3('0x4b')];if(!_0x79560b[_0x99a3('0x35')][_0x99a3('0x3b')](_0x99a3('0x3c'))){_0x1ce4b0[_0x99a3('0x21')]=qs['limit'](_0x79560b['query']['limit']);_0x1ce4b0[_0x99a3('0x1f')]=qs[_0x99a3('0x1f')](_0x79560b[_0x99a3('0x35')][_0x99a3('0x1f')]);}return _0x4a94fe[_0x99a3('0x5c')](_0x1ce4b0);}})[_0x99a3('0x28')](function(_0x5a0114){if(_0x5a0114){return _0x5a0114?{'count':_0x4797d3,'rows':_0x5a0114}:null;}})[_0x99a3('0x28')](respondWithResult(_0x25a320,null))[_0x99a3('0x48')](handleError(_0x25a320,null));};