server/api/cmList/cmList.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 _0x0707=['name','send','index','map','CmList','rawAttributes','fieldName','type','key','model','intersection','query','fields','attributes','length','order','sort','where','filters','pick','filter','VIRTUAL','merge','options','include','catch','show','params','keys','find','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','userProfileId','autoAssociation','describe','ListId','getDispositions','hasOwnProperty','nolimit','Disposition','findAll','rows','removeDispositions','addContacts','tags','isArray','join','push','each','omit','ids','success','dataValues','message','Malformed\x20request\x20syntax','CmCustomField','CmContact','concat','CustomFields','raw','getContacts','getContactsCsv','format','cf_%d','isEmpty','now','writeFileSync','/tmp/list_%d_%s.csv','setHeader','Content-disposition','attachment;\x20filename=','Content-type','download','addCustomField','findOne','sequelize','transaction','addCustomFields','TEXT','text','Sequelize','number','INTEGER','switch','BOOLEAN','defaultValue','queryInterface','addColumn','cm_contacts','cf_%s','getCustomFields','addAgents','spread','userCmList:save','removeAgents','userCmList:remove','emit','getAgents','User','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','path','to-csv','ejs','squel','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/logger','../../config/environment','../../config/license/util','../../mysqldb','defaults','localhost','redis','./cmList.socket','register','sendStatus','status','json','offset','undefined','count','limit','Content-Range','reject','save','update','then','get','Lists','UserProfileResource','stack'];(function(_0x3b6652,_0x32486d){var _0x14d39f=function(_0x3a595a){while(--_0x3a595a){_0x3b6652['push'](_0x3b6652['shift']());}};_0x14d39f(++_0x32486d);}(_0x0707,0x65));var _0x7070=function(_0x329e5b,_0x3866bb){_0x329e5b=_0x329e5b-0x0;var _0x4ce156=_0x0707[_0x329e5b];return _0x4ce156;};'use strict';var emlformat=require(_0x7070('0x0'));var rimraf=require(_0x7070('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x7070('0x2'));var rp=require(_0x7070('0x3'));var moment=require(_0x7070('0x4'));var BPromise=require(_0x7070('0x5'));var Mustache=require(_0x7070('0x6'));var util=require('util');var path=require(_0x7070('0x7'));var sox=require('sox');var csv=require(_0x7070('0x8'));var ejs=require(_0x7070('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require('lodash');var squel=require(_0x7070('0xa'));var crypto=require('crypto');var jsforce=require(_0x7070('0xb'));var deskjs=require('desk.js');var toCsv=require(_0x7070('0x8'));var querystring=require(_0x7070('0xc'));var Papa=require(_0x7070('0xd'));var Redis=require(_0x7070('0xe'));var authService=require(_0x7070('0xf'));var qs=require(_0x7070('0x10'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x7070('0x11'))('api');var utils=require('../../config/utils');var config=require(_0x7070('0x12'));var licenseUtil=require(_0x7070('0x13'));var db=require(_0x7070('0x14'))['db'];config['redis']=_[_0x7070('0x15')](config['redis'],{'host':_0x7070('0x16'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x7070('0x17')]));require(_0x7070('0x18'))[_0x7070('0x19')](socket);function respondWithStatusCode(_0x33cd3a,_0x410f58){_0x410f58=_0x410f58||0xcc;return function(_0x493ecc){if(_0x493ecc){return _0x33cd3a[_0x7070('0x1a')](_0x410f58);}return _0x33cd3a[_0x7070('0x1b')](_0x410f58)['end']();};}function respondWithResult(_0x5ad511,_0x5ee410){_0x5ee410=_0x5ee410||0xc8;return function(_0x64a9c5){if(_0x64a9c5){return _0x5ad511[_0x7070('0x1b')](_0x5ee410)[_0x7070('0x1c')](_0x64a9c5);}};}function respondWithFilteredResult(_0x46c555,_0x50be2d){return function(_0x3c16c5){if(_0x3c16c5){var _0x3e130d=typeof _0x50be2d[_0x7070('0x1d')]===_0x7070('0x1e')&&typeof _0x50be2d['limit']===_0x7070('0x1e');var _0x4da769=_0x3c16c5[_0x7070('0x1f')];var _0x1f5521=_0x3e130d?0x0:_0x50be2d['offset'];var _0x4d75ad=_0x3e130d?_0x3c16c5[_0x7070('0x1f')]:_0x50be2d[_0x7070('0x1d')]+_0x50be2d[_0x7070('0x20')];var _0x16a63e;if(_0x4d75ad>=_0x4da769){_0x4d75ad=_0x4da769;_0x16a63e=0xc8;}else{_0x16a63e=0xce;}_0x46c555[_0x7070('0x1b')](_0x16a63e);return _0x46c555['set'](_0x7070('0x21'),_0x1f5521+'-'+_0x4d75ad+'/'+_0x4da769)['json'](_0x3c16c5);}return null;};}function patchUpdates(_0x315f0f){return function(_0x468fe2){try{jsonpatch['apply'](_0x468fe2,_0x315f0f,!![]);}catch(_0x2a4d5a){return BPromise[_0x7070('0x22')](_0x2a4d5a);}return _0x468fe2[_0x7070('0x23')]();};}function saveUpdates(_0x199e2c,_0x1721bc){return function(_0x41cfab){if(_0x41cfab){return _0x41cfab[_0x7070('0x24')](_0x199e2c)[_0x7070('0x25')](function(_0x295742){return _0x295742;});}return null;};}function removeEntity(_0x4c375a,_0x342f6f){return function(_0x5e252f){if(_0x5e252f){return _0x5e252f['destroy']()[_0x7070('0x25')](function(){var _0x1f477d=_0x5e252f[_0x7070('0x26')]({'plain':!![]});var _0x44aa4f=_0x7070('0x27');return db[_0x7070('0x28')]['destroy']({'where':{'type':_0x44aa4f,'resourceId':_0x1f477d['id']}})[_0x7070('0x25')](function(){return _0x5e252f;});})[_0x7070('0x25')](function(){_0x4c375a[_0x7070('0x1b')](0xcc)['end']();});}};}function handleEntityNotFound(_0x593246,_0xcd7340){return function(_0x567499){if(!_0x567499){_0x593246['sendStatus'](0x194);}return _0x567499;};}function handleError(_0x14a1c5,_0x55b02e){_0x55b02e=_0x55b02e||0x1f4;return function(_0x545808){logger['error'](_0x545808[_0x7070('0x29')]);if(_0x545808[_0x7070('0x2a')]){delete _0x545808[_0x7070('0x2a')];}_0x14a1c5[_0x7070('0x1b')](_0x55b02e)[_0x7070('0x2b')](_0x545808);};}exports[_0x7070('0x2c')]=function(_0xb32d81,_0x29c43b){var _0x15fe7f={},_0xb08470={},_0x4838ed={'count':0x0,'rows':[]};var _0x3e6787=_[_0x7070('0x2d')](db[_0x7070('0x2e')][_0x7070('0x2f')],function(_0x33ce18){return{'name':_0x33ce18[_0x7070('0x30')],'type':_0x33ce18[_0x7070('0x31')][_0x7070('0x32')]};});_0xb08470[_0x7070('0x33')]=_[_0x7070('0x2d')](_0x3e6787,_0x7070('0x2a'));_0xb08470['query']=_['keys'](_0xb32d81['query']);_0xb08470['filters']=_[_0x7070('0x34')](_0xb08470[_0x7070('0x33')],_0xb08470[_0x7070('0x35')]);_0x15fe7f['attributes']=_[_0x7070('0x34')](_0xb08470[_0x7070('0x33')],qs[_0x7070('0x36')](_0xb32d81[_0x7070('0x35')][_0x7070('0x36')]));_0x15fe7f[_0x7070('0x37')]=_0x15fe7f[_0x7070('0x37')][_0x7070('0x38')]?_0x15fe7f[_0x7070('0x37')]:_0xb08470[_0x7070('0x33')];if(!_0xb32d81[_0x7070('0x35')]['hasOwnProperty']('nolimit')){_0x15fe7f[_0x7070('0x20')]=qs[_0x7070('0x20')](_0xb32d81['query']['limit']);_0x15fe7f['offset']=qs['offset'](_0xb32d81[_0x7070('0x35')]['offset']);}_0x15fe7f[_0x7070('0x39')]=qs[_0x7070('0x3a')](_0xb32d81['query'][_0x7070('0x3a')]);_0x15fe7f[_0x7070('0x3b')]=qs[_0x7070('0x3c')](_[_0x7070('0x3d')](_0xb32d81[_0x7070('0x35')],_0xb08470[_0x7070('0x3c')]),_0x3e6787);if(_0xb32d81['query'][_0x7070('0x3e')]){_0x15fe7f[_0x7070('0x3b')]=_['merge'](_0x15fe7f[_0x7070('0x3b')],{'$or':_[_0x7070('0x2d')](_0x3e6787,function(_0x55ae1a){if(_0x55ae1a[_0x7070('0x31')]!==_0x7070('0x3f')){var _0x27f88c={};_0x27f88c[_0x55ae1a[_0x7070('0x2a')]]={'$like':'%'+_0xb32d81[_0x7070('0x35')][_0x7070('0x3e')]+'%'};return _0x27f88c;}})});}_0x15fe7f=_[_0x7070('0x40')]({},_0x15fe7f,_0xb32d81[_0x7070('0x41')]);var _0xe62cdd={'where':_0x15fe7f[_0x7070('0x3b')]};return db[_0x7070('0x2e')][_0x7070('0x1f')](_0xe62cdd)[_0x7070('0x25')](function(_0x8da6c9){_0x4838ed['count']=_0x8da6c9;if(_0xb32d81[_0x7070('0x35')]['includeAll']){_0x15fe7f[_0x7070('0x42')]=[{'all':!![]}];}return db['CmList']['findAll'](_0x15fe7f);})[_0x7070('0x25')](function(_0x49a480){_0x4838ed['rows']=_0x49a480;return _0x4838ed;})['then'](respondWithFilteredResult(_0x29c43b,_0x15fe7f))[_0x7070('0x43')](handleError(_0x29c43b,null));};exports[_0x7070('0x44')]=function(_0x290be4,_0x5bc1bb){var _0x1921a5={'raw':![],'where':{'id':_0x290be4[_0x7070('0x45')]['id']}},_0x54ab68={};_0x54ab68[_0x7070('0x33')]=_[_0x7070('0x46')](db[_0x7070('0x2e')][_0x7070('0x2f')]);_0x54ab68[_0x7070('0x35')]=_[_0x7070('0x46')](_0x290be4['query']);_0x54ab68[_0x7070('0x3c')]=_[_0x7070('0x34')](_0x54ab68['model'],_0x54ab68['query']);_0x1921a5['attributes']=_[_0x7070('0x34')](_0x54ab68[_0x7070('0x33')],qs[_0x7070('0x36')](_0x290be4[_0x7070('0x35')][_0x7070('0x36')]));_0x1921a5[_0x7070('0x37')]=_0x1921a5['attributes'][_0x7070('0x38')]?_0x1921a5['attributes']:_0x54ab68[_0x7070('0x33')];if(_0x290be4[_0x7070('0x35')]['includeAll']){_0x1921a5['include']=[{'all':!![]}];}_0x1921a5=_['merge']({},_0x1921a5,_0x290be4[_0x7070('0x41')]);return db[_0x7070('0x2e')][_0x7070('0x47')](_0x1921a5)[_0x7070('0x25')](handleEntityNotFound(_0x5bc1bb,null))[_0x7070('0x25')](respondWithResult(_0x5bc1bb,null))['catch'](handleError(_0x5bc1bb,null));};exports[_0x7070('0x48')]=function(_0x27995c,_0x1cc18b){return db[_0x7070('0x2e')][_0x7070('0x48')](_0x27995c[_0x7070('0x49')],{})[_0x7070('0x25')](function(_0x558b06){var _0x558656=_0x27995c['user'][_0x7070('0x26')]({'plain':!![]});if(!_0x558656)throw new Error(_0x7070('0x4a'));if(_0x558656[_0x7070('0x4b')]==='user'){var _0x3c348b=_0x558b06[_0x7070('0x26')]({'plain':!![]});var _0x5bebb5=_0x7070('0x27');return db['UserProfileSection'][_0x7070('0x47')]({'where':{'name':_0x5bebb5,'userProfileId':_0x558656[_0x7070('0x4c')]},'raw':!![]})[_0x7070('0x25')](function(_0x5d586e){if(_0x5d586e&&_0x5d586e[_0x7070('0x4d')]===0x0){return db[_0x7070('0x28')][_0x7070('0x48')]({'name':_0x3c348b[_0x7070('0x2a')],'resourceId':_0x3c348b['id'],'type':_0x5d586e[_0x7070('0x2a')],'sectionId':_0x5d586e['id']},{})[_0x7070('0x25')](function(){return _0x558b06;});}else{return _0x558b06;}})[_0x7070('0x43')](function(_0x2e0f20){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x2e0f20);throw _0x2e0f20;});}return _0x558b06;})[_0x7070('0x25')](respondWithResult(_0x1cc18b,0xc9))[_0x7070('0x43')](handleError(_0x1cc18b,null));};exports[_0x7070('0x24')]=function(_0x5da616,_0x5a093e){if(_0x5da616[_0x7070('0x49')]['id']){delete _0x5da616[_0x7070('0x49')]['id'];}return db['CmList'][_0x7070('0x47')]({'where':{'id':_0x5da616[_0x7070('0x45')]['id']}})[_0x7070('0x25')](handleEntityNotFound(_0x5a093e,null))['then'](saveUpdates(_0x5da616[_0x7070('0x49')],null))[_0x7070('0x25')](respondWithResult(_0x5a093e,null))[_0x7070('0x43')](handleError(_0x5a093e,null));};exports['destroy']=function(_0x588725,_0x19db9d){return db[_0x7070('0x2e')]['find']({'where':{'id':_0x588725[_0x7070('0x45')]['id']}})[_0x7070('0x25')](handleEntityNotFound(_0x19db9d,null))['then'](removeEntity(_0x19db9d,null))[_0x7070('0x43')](handleError(_0x19db9d,null));};exports['describe']=function(_0x5c1fb7,_0x2e52b4){return db[_0x7070('0x2e')][_0x7070('0x4e')]()[_0x7070('0x25')](respondWithResult(_0x2e52b4,null))[_0x7070('0x43')](handleError(_0x2e52b4,null));};exports['addDisposition']=function(_0x18a8a8,_0x3a0c13,_0x343f9a){if(_0x18a8a8['body']['id']){delete _0x18a8a8[_0x7070('0x49')]['id'];}return db[_0x7070('0x2e')][_0x7070('0x47')]({'where':{'id':_0x18a8a8[_0x7070('0x45')]['id']}})[_0x7070('0x25')](handleEntityNotFound(_0x3a0c13,null))[_0x7070('0x25')](function(_0x213d0c){if(_0x213d0c){_0x18a8a8[_0x7070('0x49')][_0x7070('0x4f')]=_0x213d0c['id'];return db['Disposition']['create'](_0x18a8a8[_0x7070('0x49')]);}})[_0x7070('0x25')](respondWithResult(_0x3a0c13,null))[_0x7070('0x43')](handleError(_0x3a0c13,null));};exports[_0x7070('0x50')]=function(_0x3e8228,_0x29db29,_0x39b253){var _0x33dc56={'raw':![],'where':{}};var _0x2fbedb={};var _0x2e7d6a={'count':0x0,'rows':[]};return db[_0x7070('0x2e')]['findOne']({'where':{'id':_0x3e8228['params']['id']}})[_0x7070('0x25')](handleEntityNotFound(_0x29db29,null))[_0x7070('0x25')](function(_0x311b4a){if(_0x311b4a){_0x2fbedb['model']=_[_0x7070('0x46')](db['Disposition'][_0x7070('0x2f')]);_0x2fbedb[_0x7070('0x35')]=_[_0x7070('0x46')](_0x3e8228['query']);_0x2fbedb[_0x7070('0x3c')]=_[_0x7070('0x34')](_0x2fbedb[_0x7070('0x33')],_0x2fbedb[_0x7070('0x35')]);_0x33dc56[_0x7070('0x37')]=_[_0x7070('0x34')](_0x2fbedb[_0x7070('0x33')],qs['fields'](_0x3e8228[_0x7070('0x35')]['fields']));_0x33dc56['attributes']=_0x33dc56[_0x7070('0x37')]['length']?_0x33dc56['attributes']:_0x2fbedb[_0x7070('0x33')];if(!_0x3e8228[_0x7070('0x35')][_0x7070('0x51')](_0x7070('0x52'))){_0x33dc56[_0x7070('0x20')]=qs[_0x7070('0x20')](_0x3e8228[_0x7070('0x35')][_0x7070('0x20')]);_0x33dc56[_0x7070('0x1d')]=qs['offset'](_0x3e8228[_0x7070('0x35')][_0x7070('0x1d')]);}_0x33dc56['order']=qs[_0x7070('0x3a')](_0x3e8228[_0x7070('0x35')][_0x7070('0x3a')]);_0x33dc56[_0x7070('0x3b')]=qs['filters'](_['pick'](_0x3e8228[_0x7070('0x35')],_0x2fbedb['filters']));_0x33dc56[_0x7070('0x3b')][_0x7070('0x4f')]=_0x311b4a['id'];if(_0x3e8228[_0x7070('0x35')][_0x7070('0x3e')]){_0x33dc56[_0x7070('0x3b')]=_[_0x7070('0x40')](_0x33dc56[_0x7070('0x3b')],{'$or':_[_0x7070('0x2d')](_0x33dc56['attributes'],function(_0x54d042){var _0x3811e0={};_0x3811e0[_0x54d042]={'$like':'%'+_0x3e8228['query'][_0x7070('0x3e')]+'%'};return _0x3811e0;})});}_0x33dc56=_[_0x7070('0x40')]({},_0x33dc56,_0x3e8228[_0x7070('0x41')]);return db[_0x7070('0x53')][_0x7070('0x1f')]({'where':_0x33dc56[_0x7070('0x3b')]})['then'](function(_0x4e3373){_0x2e7d6a[_0x7070('0x1f')]=_0x4e3373;if(_0x3e8228[_0x7070('0x35')]['includeAll']){_0x33dc56['include']=[{'all':!![]}];}return db['Disposition'][_0x7070('0x54')](_0x33dc56);})[_0x7070('0x25')](function(_0x1f425f){_0x2e7d6a[_0x7070('0x55')]=_0x1f425f;return _0x2e7d6a;});}})[_0x7070('0x25')](respondWithFilteredResult(_0x29db29,_0x33dc56))[_0x7070('0x43')](handleError(_0x29db29,null));};exports[_0x7070('0x56')]=function(_0x2d85a7,_0x5d4272,_0x32c5bc){return db[_0x7070('0x2e')][_0x7070('0x47')]({'where':{'id':_0x2d85a7[_0x7070('0x45')]['id']}})[_0x7070('0x25')](handleEntityNotFound(_0x5d4272,null))[_0x7070('0x25')](function(_0x1b298c){if(_0x1b298c){return _0x1b298c['removeDispositions'](_0x2d85a7['query']['ids']);}})[_0x7070('0x25')](respondWithStatusCode(_0x5d4272,null))[_0x7070('0x43')](handleError(_0x5d4272,null));};exports[_0x7070('0x57')]=function(_0x10b831,_0x4c34a4,_0x4dfb2c){return db[_0x7070('0x2e')][_0x7070('0x47')]({'where':{'id':_0x10b831[_0x7070('0x45')]['id']}})[_0x7070('0x25')](handleEntityNotFound(_0x4c34a4,null))[_0x7070('0x25')](function(_0x46671a){if(_0x46671a){var _0x4915d0=[];var _0x45aca4={'success':[],'errors':[]};return db['CmContact'][_0x7070('0x4e')]()['then'](function(_0x4551d2){if(_0x10b831[_0x7070('0x49')][_0x7070('0x58')]&&_[_0x7070('0x59')](_0x10b831['body'][_0x7070('0x58')])){if(_0x10b831[_0x7070('0x49')][_0x7070('0x58')][_0x7070('0x38')]){_0x10b831['body'][_0x7070('0x58')]=_0x10b831['body'][_0x7070('0x58')][_0x7070('0x5a')](';')+';';}else{_0x10b831['body'][_0x7070('0x58')]=null;}}else{_0x10b831[_0x7070('0x49')]['tags']=null;}if(_0x10b831[_0x7070('0x49')]&&_['isArray'](_0x10b831[_0x7070('0x49')])){for(var _0xadf7f6=0x0;_0xadf7f6<_0x10b831[_0x7070('0x49')][_0x7070('0x38')];_0xadf7f6+=0x1){_0x10b831[_0x7070('0x49')][_0xadf7f6]['ListId']=_0x10b831['params']['id'];_0x4915d0[_0x7070('0x5b')](_0x10b831[_0x7070('0x49')][_0xadf7f6]);}return BPromise[_0x7070('0x5c')](_0x4915d0,function(_0x15a79e){return db['CmContact'][_0x7070('0x48')](_[_0x7070('0x5d')](_0x15a79e,[_0x7070('0x5e'),'id'])||{},{'fields':_[_0x7070('0x46')](_0x4551d2),'raw':!![]})[_0x7070('0x25')](function(_0x2225cc){_0x45aca4[_0x7070('0x5f')][_0x7070('0x5b')](_0x2225cc[_0x7070('0x60')]);})[_0x7070('0x43')](function(_0x1d3ac8){_0x45aca4['errors'][_0x7070('0x5b')]({'data':_0x15a79e,'error':_0x1d3ac8[_0x7070('0x61')]});});})[_0x7070('0x25')](function(_0x292ebd){return _0x45aca4;})['catch'](function(_0x4ef9f1){return _0x4ef9f1;});}else{_0x4c34a4['status'](0x190)[_0x7070('0x1c')]({'message':_0x7070('0x62')});}});}})['then'](respondWithResult(_0x4c34a4,null))['catch'](handleError(_0x4c34a4,null));};exports['getContacts']=function(_0x3d5f10,_0x4fc43b,_0x516373){var _0x4cb461;return db[_0x7070('0x2e')][_0x7070('0x47')]({'where':{'id':_0x3d5f10[_0x7070('0x45')]['id']},'include':[{'model':db[_0x7070('0x63')],'as':'CustomFields'}]})[_0x7070('0x25')](handleEntityNotFound(_0x4fc43b,null))['then'](function(_0x15ee8a){if(_0x15ee8a){_0x4cb461=_0x15ee8a;return db[_0x7070('0x64')][_0x7070('0x2f')];}})['then'](function(_0x1d027a){if(_0x1d027a){var _0x8fe20f={};var _0x2fa029={};_0x2fa029['model']=_[_0x7070('0x65')](_['keys'](_0x1d027a),_[_0x7070('0x2d')](_0x4cb461[_0x7070('0x66')],function(_0x2fd41b){return util['format']('cf_%d',_0x2fd41b['id']);}));_0x2fa029[_0x7070('0x35')]=_[_0x7070('0x46')](_0x3d5f10[_0x7070('0x35')]);_0x2fa029['filters']=_['intersection'](_0x2fa029[_0x7070('0x33')],_0x2fa029[_0x7070('0x35')]);_0x8fe20f[_0x7070('0x37')]=_['intersection'](_0x2fa029[_0x7070('0x33')],qs['fields'](_0x3d5f10[_0x7070('0x35')][_0x7070('0x36')]));_0x8fe20f[_0x7070('0x37')]=_0x8fe20f[_0x7070('0x37')][_0x7070('0x38')]?_0x8fe20f['attributes']:_0x2fa029[_0x7070('0x33')];if(!_0x3d5f10[_0x7070('0x35')]['hasOwnProperty'](_0x7070('0x52'))){_0x8fe20f['limit']=qs[_0x7070('0x20')](_0x3d5f10[_0x7070('0x35')]['limit']);_0x8fe20f[_0x7070('0x1d')]=qs[_0x7070('0x1d')](_0x3d5f10['query']['offset']);}_0x8fe20f[_0x7070('0x39')]=qs['sort'](_0x3d5f10['query'][_0x7070('0x3a')]);_0x8fe20f[_0x7070('0x3b')]=qs[_0x7070('0x3c')](_[_0x7070('0x3d')](_0x3d5f10[_0x7070('0x35')],_0x2fa029[_0x7070('0x3c')]));_0x8fe20f[_0x7070('0x67')]=!![];if(_0x3d5f10[_0x7070('0x35')][_0x7070('0x3e')]){_0x8fe20f['where']=_[_0x7070('0x40')](_0x8fe20f['where'],{'$or':_['map'](_0x8fe20f[_0x7070('0x37')],function(_0x12272f){var _0x3fd74d={};_0x3fd74d[_0x12272f]={'$like':'%'+_0x3d5f10[_0x7070('0x35')][_0x7070('0x3e')]+'%'};return _0x3fd74d;})});}_0x8fe20f=_[_0x7070('0x40')]({},_0x8fe20f,_0x3d5f10[_0x7070('0x41')]);return _0x4cb461[_0x7070('0x68')](_0x8fe20f);}})[_0x7070('0x25')](respondWithResult(_0x4fc43b,null))[_0x7070('0x43')](handleError(_0x4fc43b,null));};exports[_0x7070('0x69')]=function(_0x2cfea2,_0x44b3fa,_0x6e8607){var _0x2a3e07;return db[_0x7070('0x2e')][_0x7070('0x47')]({'where':{'id':_0x2cfea2['params']['id']},'include':[{'model':db[_0x7070('0x63')],'as':_0x7070('0x66')}]})[_0x7070('0x25')](handleEntityNotFound(_0x44b3fa,null))['then'](function(_0x24ae1a){if(_0x24ae1a){_0x2a3e07=_0x24ae1a;return db['CmContact'][_0x7070('0x2f')];}})[_0x7070('0x25')](function(_0x4812f4){if(_0x4812f4){var _0x3fcd3e={};var _0x57ee54={};_0x57ee54['model']=_[_0x7070('0x65')](_['keys'](_0x4812f4),_[_0x7070('0x2d')](_0x2a3e07[_0x7070('0x66')],function(_0x4b1cda){return util[_0x7070('0x6a')](_0x7070('0x6b'),_0x4b1cda['id']);}));_0x57ee54[_0x7070('0x35')]=_[_0x7070('0x46')](_0x2cfea2[_0x7070('0x35')]);_0x57ee54[_0x7070('0x3c')]=_['intersection'](_0x57ee54[_0x7070('0x33')],_0x57ee54[_0x7070('0x35')]);_0x3fcd3e['attributes']=_['intersection'](_0x57ee54[_0x7070('0x33')],qs['fields'](_0x2cfea2[_0x7070('0x35')]['fields']));_0x3fcd3e[_0x7070('0x37')]=_0x3fcd3e[_0x7070('0x37')][_0x7070('0x38')]?_0x3fcd3e[_0x7070('0x37')]:_0x57ee54['model'];if(!_0x2cfea2[_0x7070('0x35')][_0x7070('0x51')](_0x7070('0x52'))){_0x3fcd3e[_0x7070('0x20')]=qs[_0x7070('0x20')](_0x2cfea2[_0x7070('0x35')][_0x7070('0x20')]);_0x3fcd3e['offset']=qs[_0x7070('0x1d')](_0x2cfea2['query'][_0x7070('0x1d')]);}_0x3fcd3e[_0x7070('0x39')]=qs[_0x7070('0x3a')](_0x2cfea2[_0x7070('0x35')]['sort']);_0x3fcd3e[_0x7070('0x3b')]=qs[_0x7070('0x3c')](_['pick'](_0x2cfea2[_0x7070('0x35')],_0x57ee54[_0x7070('0x3c')]));_0x3fcd3e['raw']=!![];if(_0x2cfea2[_0x7070('0x35')][_0x7070('0x3e')]){_0x3fcd3e[_0x7070('0x3b')]=_[_0x7070('0x40')](_0x3fcd3e[_0x7070('0x3b')],{'$or':_[_0x7070('0x2d')](_0x3fcd3e[_0x7070('0x37')],function(_0x2f6144){var _0x18af0d={};_0x18af0d[_0x2f6144]={'$like':'%'+_0x2cfea2[_0x7070('0x35')][_0x7070('0x3e')]+'%'};return _0x18af0d;})});}_0x3fcd3e=_['merge']({},_0x3fcd3e,_0x2cfea2[_0x7070('0x41')]);return _0x2a3e07[_0x7070('0x68')](_0x3fcd3e);}})[_0x7070('0x25')](function(_0x2117f2){if(!_[_0x7070('0x6c')](_0x2117f2)){var _0xbda673=toCsv(_0x2117f2);var _0x5d48fd=Date[_0x7070('0x6d')]();fs[_0x7070('0x6e')](util[_0x7070('0x6a')](_0x7070('0x6f'),_0x2a3e07['id'],_0x5d48fd),_0xbda673);_0x44b3fa[_0x7070('0x70')](_0x7070('0x71'),_0x7070('0x72')+util[_0x7070('0x6a')]('list_%d_%s.csv',_0x2a3e07['id'],_0x5d48fd));_0x44b3fa[_0x7070('0x70')](_0x7070('0x73'),'text/csv');return _0x44b3fa[_0x7070('0x74')](util[_0x7070('0x6a')]('/tmp/list_%d_%s.csv',_0x2a3e07['id'],_0x5d48fd));}else{return _0x44b3fa['sendStatus'](0xcc);}})[_0x7070('0x43')](handleError(_0x44b3fa,null));};exports[_0x7070('0x75')]=function(_0x4b255b,_0x257a85,_0x1a3b1f){var _0x3a6cfb;delete _0x4b255b[_0x7070('0x49')]['id'];return db[_0x7070('0x2e')][_0x7070('0x76')]({'where':{'id':_0x4b255b[_0x7070('0x45')]['id']}})[_0x7070('0x25')](handleEntityNotFound(_0x257a85,null))[_0x7070('0x25')](function(_0x46ff98){if(_0x46ff98){return db[_0x7070('0x77')][_0x7070('0x78')](function(_0x1d5c67){return db[_0x7070('0x63')][_0x7070('0x48')](_0x4b255b['body'],{'transaction':_0x1d5c67})['then'](function(_0x48691a){_0x3a6cfb=_0x48691a;return _0x46ff98[_0x7070('0x79')](_0x48691a,{'transaction':_0x1d5c67});})[_0x7070('0x25')](function(){var _0x539c02={'type':db['Sequelize'][_0x7070('0x7a')],'transaction':_0x1d5c67};switch(_0x4b255b[_0x7070('0x49')][_0x7070('0x31')]){case _0x7070('0x7b'):_0x539c02[_0x7070('0x31')]=db[_0x7070('0x7c')]['TEXT'];break;case _0x7070('0x7d'):_0x539c02['type']=db[_0x7070('0x7c')][_0x7070('0x7e')];break;case _0x7070('0x7f'):_0x539c02[_0x7070('0x31')]=db[_0x7070('0x7c')][_0x7070('0x80')];_0x539c02[_0x7070('0x81')]=![];break;default:}return db[_0x7070('0x77')][_0x7070('0x82')][_0x7070('0x83')](_0x7070('0x84'),util[_0x7070('0x6a')](_0x7070('0x85'),_0x3a6cfb['id']),_0x539c02);})[_0x7070('0x25')](function(){return _0x3a6cfb;});});}})['then'](respondWithResult(_0x257a85,null))[_0x7070('0x43')](handleError(_0x257a85,null));};exports[_0x7070('0x86')]=function(_0x5d33dd,_0x190df9,_0x1c9a32){var _0x539c31={};var _0x4f031c={};var _0x396a1f;var _0x32b247;return db[_0x7070('0x2e')][_0x7070('0x76')]({'where':{'id':_0x5d33dd[_0x7070('0x45')]['id']}})['then'](handleEntityNotFound(_0x190df9,null))['then'](function(_0x5bdcd5){if(_0x5bdcd5){_0x396a1f=_0x5bdcd5;_0x4f031c[_0x7070('0x33')]=_[_0x7070('0x46')](db[_0x7070('0x63')][_0x7070('0x2f')]);_0x4f031c['query']=_[_0x7070('0x46')](_0x5d33dd[_0x7070('0x35')]);_0x4f031c[_0x7070('0x3c')]=_[_0x7070('0x34')](_0x4f031c[_0x7070('0x33')],_0x4f031c[_0x7070('0x35')]);_0x539c31[_0x7070('0x37')]=_['intersection'](_0x4f031c[_0x7070('0x33')],qs[_0x7070('0x36')](_0x5d33dd[_0x7070('0x35')]['fields']));_0x539c31[_0x7070('0x37')]=_0x539c31[_0x7070('0x37')][_0x7070('0x38')]?_0x539c31['attributes']:_0x4f031c[_0x7070('0x33')];_0x539c31['order']=qs[_0x7070('0x3a')](_0x5d33dd[_0x7070('0x35')][_0x7070('0x3a')]);_0x539c31['where']=qs['filters'](_[_0x7070('0x3d')](_0x5d33dd['query'],_0x4f031c['filters']));_0x539c31[_0x7070('0x3b')]=_[_0x7070('0x40')](_0x539c31[_0x7070('0x3b')],{'$or':[{'ListId':_0x5bdcd5['id']},{'ListId':null}]});if(_0x5d33dd[_0x7070('0x35')][_0x7070('0x3e')]){_0x539c31['where']=_[_0x7070('0x40')](_0x539c31[_0x7070('0x3b')],{'$or':_[_0x7070('0x2d')](_0x539c31['attributes'],function(_0x52560b){var _0x2737cf={};_0x2737cf[_0x52560b]={'$like':'%'+_0x5d33dd[_0x7070('0x35')][_0x7070('0x3e')]+'%'};return _0x2737cf;})});}_0x539c31=_[_0x7070('0x40')]({},_0x539c31,_0x5d33dd['options']);return db[_0x7070('0x63')]['findAndCountAll'](_0x539c31);}})[_0x7070('0x25')](respondWithResult(_0x190df9,null))[_0x7070('0x43')](handleError(_0x190df9,null));};exports[_0x7070('0x87')]=function(_0x36e6b9,_0xb28362,_0xd19519){return db[_0x7070('0x2e')][_0x7070('0x47')]({'where':{'id':_0x36e6b9[_0x7070('0x45')]['id']}})[_0x7070('0x25')](handleEntityNotFound(_0xb28362,null))[_0x7070('0x25')](function(_0x43963e){if(_0x43963e){return _0x43963e['addAgents'](_0x36e6b9[_0x7070('0x49')]['ids'],_[_0x7070('0x5d')](_0x36e6b9[_0x7070('0x49')],[_0x7070('0x5e'),'id'])||{})[_0x7070('0x88')](function(_0x869780){for(var _0x33f525=0x0;_0x33f525<_0x36e6b9[_0x7070('0x49')][_0x7070('0x5e')]['length'];_0x33f525+=0x1){socket['emit'](_0x7070('0x89'),{'UserId':_0x36e6b9[_0x7070('0x49')][_0x7070('0x5e')][_0x33f525],'CmListId':_0x36e6b9[_0x7070('0x45')]['id']});}return _0x869780;});}})[_0x7070('0x25')](respondWithResult(_0xb28362,null))['catch'](handleError(_0xb28362,null));};exports[_0x7070('0x8a')]=function(_0x158cdf,_0x3377f2,_0x5ce38b){return db[_0x7070('0x2e')][_0x7070('0x47')]({'where':{'id':_0x158cdf[_0x7070('0x45')]['id']}})[_0x7070('0x25')](handleEntityNotFound(_0x3377f2,null))[_0x7070('0x25')](function(_0x42abaa){if(_0x42abaa){return _0x42abaa[_0x7070('0x8a')](_0x158cdf[_0x7070('0x35')][_0x7070('0x5e')])[_0x7070('0x25')](function(){if(_[_0x7070('0x59')](_0x158cdf['query'][_0x7070('0x5e')])){for(var _0x241413=0x0;_0x241413<_0x158cdf[_0x7070('0x35')]['ids'][_0x7070('0x38')];_0x241413+=0x1){socket['emit'](_0x7070('0x8b'),{'UserId':Number(_0x158cdf['query'][_0x7070('0x5e')][_0x241413]),'CmListId':Number(_0x158cdf[_0x7070('0x45')]['id'])});}}else{socket[_0x7070('0x8c')](_0x7070('0x8b'),{'UserId':Number(_0x158cdf[_0x7070('0x35')][_0x7070('0x5e')]),'CmListId':Number(_0x158cdf[_0x7070('0x45')]['id'])});}});}})['then'](respondWithStatusCode(_0x3377f2,null))[_0x7070('0x43')](handleError(_0x3377f2,null));};exports[_0x7070('0x8d')]=function(_0x23d09e,_0x4e45f4,_0x54fa7f){var _0x249f94={};var _0x10dbf1={};var _0x555dc7;var _0xcee460;return db[_0x7070('0x2e')][_0x7070('0x76')]({'where':{'id':_0x23d09e[_0x7070('0x45')]['id']}})[_0x7070('0x25')](handleEntityNotFound(_0x4e45f4,null))[_0x7070('0x25')](function(_0x25a77b){if(_0x25a77b){_0x555dc7=_0x25a77b;_0x10dbf1[_0x7070('0x33')]=_['keys'](db[_0x7070('0x8e')][_0x7070('0x2f')]);_0x10dbf1[_0x7070('0x35')]=_[_0x7070('0x46')](_0x23d09e['query']);_0x10dbf1['filters']=_[_0x7070('0x34')](_0x10dbf1[_0x7070('0x33')],_0x10dbf1[_0x7070('0x35')]);_0x249f94[_0x7070('0x37')]=_[_0x7070('0x34')](_0x10dbf1[_0x7070('0x33')],qs['fields'](_0x23d09e['query'][_0x7070('0x36')]));_0x249f94[_0x7070('0x37')]=_0x249f94['attributes'][_0x7070('0x38')]?_0x249f94[_0x7070('0x37')]:_0x10dbf1[_0x7070('0x33')];_0x249f94[_0x7070('0x39')]=qs['sort'](_0x23d09e[_0x7070('0x35')]['sort']);_0x249f94[_0x7070('0x3b')]=qs[_0x7070('0x3c')](_[_0x7070('0x3d')](_0x23d09e[_0x7070('0x35')],_0x10dbf1[_0x7070('0x3c')]));if(_0x23d09e[_0x7070('0x35')]['filter']){_0x249f94['where']=_[_0x7070('0x40')](_0x249f94[_0x7070('0x3b')],{'$or':_[_0x7070('0x2d')](_0x249f94[_0x7070('0x37')],function(_0x5beb64){var _0x5cae7e={};_0x5cae7e[_0x5beb64]={'$like':'%'+_0x23d09e[_0x7070('0x35')]['filter']+'%'};return _0x5cae7e;})});}_0x249f94=_[_0x7070('0x40')]({},_0x249f94,_0x23d09e[_0x7070('0x41')]);return _0x555dc7[_0x7070('0x8d')](_0x249f94);}})[_0x7070('0x25')](function(_0x4a4c9a){if(_0x4a4c9a){_0xcee460=_0x4a4c9a[_0x7070('0x38')];if(!_0x23d09e[_0x7070('0x35')]['hasOwnProperty'](_0x7070('0x52'))){_0x249f94[_0x7070('0x20')]=qs[_0x7070('0x20')](_0x23d09e[_0x7070('0x35')][_0x7070('0x20')]);_0x249f94[_0x7070('0x1d')]=qs[_0x7070('0x1d')](_0x23d09e[_0x7070('0x35')][_0x7070('0x1d')]);}return _0x555dc7['getAgents'](_0x249f94);}})['then'](function(_0x166104){if(_0x166104){return _0x166104?{'count':_0xcee460,'rows':_0x166104}:null;}})[_0x7070('0x25')](respondWithResult(_0x4e45f4,null))['catch'](handleError(_0x4e45f4,null));};