Built motion from commit a679711e.|2.6.15
[motion2.git] / server / api / cmList / cmList.controller.js
index a3e3d10..06ea9f4 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x4143=['../../config/license/util','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./cmList.socket','register','status','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','then','get','Lists','destroy','error','stack','name','send','map','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','options','CmList','includeAll','include','findAll','rows','show','catch','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','user','UserProfileSection','find','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','describe','addDisposition','ListId','findOne','Disposition','removeDispositions','ids','addContacts','CmContact','tags','isArray','join','push','each','omit','dataValues','errors','message','CmCustomField','CustomFields','concat','raw','getContacts','getContactsCsv','format','isEmpty','setHeader','Content-disposition','attachment;\x20filename=','list_%d_%s.csv','Content-type','text/csv','download','sendStatus','transaction','addCustomFields','Sequelize','TEXT','number','INTEGER','switch','defaultValue','queryInterface','addColumn','cm_contacts','addAgents','spread','emit','userCmList:save','removeAgents','userCmList:remove','getAgents','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','to-csv','ejs','lodash','squel','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment'];(function(_0x3054be,_0x1bdc8b){var _0x3df150=function(_0x56cfbf){while(--_0x56cfbf){_0x3054be['push'](_0x3054be['shift']());}};_0x3df150(++_0x1bdc8b);}(_0x4143,0x106));var _0x3414=function(_0x1ac595,_0x5d2081){_0x1ac595=_0x1ac595-0x0;var _0x455fff=_0x4143[_0x1ac595];return _0x455fff;};'use strict';var emlformat=require(_0x3414('0x0'));var rimraf=require(_0x3414('0x1'));var zipdir=require(_0x3414('0x2'));var jsonpatch=require(_0x3414('0x3'));var rp=require(_0x3414('0x4'));var moment=require(_0x3414('0x5'));var BPromise=require(_0x3414('0x6'));var Mustache=require(_0x3414('0x7'));var util=require(_0x3414('0x8'));var path=require('path');var sox=require('sox');var csv=require(_0x3414('0x9'));var ejs=require(_0x3414('0xa'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x3414('0xb'));var squel=require(_0x3414('0xc'));var crypto=require('crypto');var jsforce=require(_0x3414('0xd'));var deskjs=require('desk.js');var toCsv=require(_0x3414('0x9'));var querystring=require(_0x3414('0xe'));var Papa=require(_0x3414('0xf'));var Redis=require(_0x3414('0x10'));var authService=require(_0x3414('0x11'));var qs=require('../../components/parsers/qs');var as=require(_0x3414('0x12'));var hardwareService=require(_0x3414('0x13'));var logger=require(_0x3414('0x14'))(_0x3414('0x15'));var utils=require(_0x3414('0x16'));var config=require(_0x3414('0x17'));var licenseUtil=require(_0x3414('0x18'));var db=require(_0x3414('0x19'))['db'];config[_0x3414('0x1a')]=_[_0x3414('0x1b')](config['redis'],{'host':_0x3414('0x1c'),'port':0x18eb});var socket=require(_0x3414('0x1d'))(new Redis(config[_0x3414('0x1a')]));require(_0x3414('0x1e'))[_0x3414('0x1f')](socket);function respondWithStatusCode(_0xe86160,_0x4e7bb3){_0x4e7bb3=_0x4e7bb3||0xcc;return function(_0x19396d){if(_0x19396d){return _0xe86160['sendStatus'](_0x4e7bb3);}return _0xe86160[_0x3414('0x20')](_0x4e7bb3)['end']();};}function respondWithResult(_0x595b27,_0x335cdd){_0x335cdd=_0x335cdd||0xc8;return function(_0x50ea3d){if(_0x50ea3d){return _0x595b27[_0x3414('0x20')](_0x335cdd)[_0x3414('0x21')](_0x50ea3d);}};}function respondWithFilteredResult(_0x656dd9,_0x380903){return function(_0x279733){if(_0x279733){var _0x542762=typeof _0x380903[_0x3414('0x22')]===_0x3414('0x23')&&typeof _0x380903[_0x3414('0x24')]===_0x3414('0x23');var _0x226513=_0x279733['count'];var _0x3e5f54=_0x542762?0x0:_0x380903['offset'];var _0xee09e6=_0x542762?_0x279733[_0x3414('0x25')]:_0x380903[_0x3414('0x22')]+_0x380903[_0x3414('0x24')];var _0x5f2ab3;if(_0xee09e6>=_0x226513){_0xee09e6=_0x226513;_0x5f2ab3=0xc8;}else{_0x5f2ab3=0xce;}_0x656dd9[_0x3414('0x20')](_0x5f2ab3);return _0x656dd9[_0x3414('0x26')](_0x3414('0x27'),_0x3e5f54+'-'+_0xee09e6+'/'+_0x226513)['json'](_0x279733);}return null;};}function patchUpdates(_0x384798){return function(_0x387ea5){try{jsonpatch[_0x3414('0x28')](_0x387ea5,_0x384798,!![]);}catch(_0x284fac){return BPromise[_0x3414('0x29')](_0x284fac);}return _0x387ea5[_0x3414('0x2a')]();};}function saveUpdates(_0x53aacb,_0x321d6e){return function(_0x6f2ff0){if(_0x6f2ff0){return _0x6f2ff0[_0x3414('0x2b')](_0x53aacb)[_0x3414('0x2c')](function(_0x17104e){return _0x17104e;});}return null;};}function removeEntity(_0x3024bd,_0x19dd6f){return function(_0x1ac1a1){if(_0x1ac1a1){return _0x1ac1a1['destroy']()[_0x3414('0x2c')](function(){var _0x3f7df4=_0x1ac1a1[_0x3414('0x2d')]({'plain':!![]});var _0x388c6f=_0x3414('0x2e');return db['UserProfileResource'][_0x3414('0x2f')]({'where':{'type':_0x388c6f,'resourceId':_0x3f7df4['id']}})[_0x3414('0x2c')](function(){return _0x1ac1a1;});})[_0x3414('0x2c')](function(){_0x3024bd[_0x3414('0x20')](0xcc)['end']();});}};}function handleEntityNotFound(_0x850c33,_0x291ae1){return function(_0x2d0fac){if(!_0x2d0fac){_0x850c33['sendStatus'](0x194);}return _0x2d0fac;};}function handleError(_0x35828d,_0xbc46f1){_0xbc46f1=_0xbc46f1||0x1f4;return function(_0x13fc1b){logger[_0x3414('0x30')](_0x13fc1b[_0x3414('0x31')]);if(_0x13fc1b[_0x3414('0x32')]){delete _0x13fc1b[_0x3414('0x32')];}_0x35828d[_0x3414('0x20')](_0xbc46f1)[_0x3414('0x33')](_0x13fc1b);};}exports['index']=function(_0xa13ddf,_0x5dec04){var _0x168d76={},_0x21548c={},_0x2ac19a={'count':0x0,'rows':[]};var _0x34169a=_[_0x3414('0x34')](db['CmList'][_0x3414('0x35')],function(_0x431d03){return{'name':_0x431d03[_0x3414('0x36')],'type':_0x431d03[_0x3414('0x37')][_0x3414('0x38')]};});_0x21548c[_0x3414('0x39')]=_[_0x3414('0x34')](_0x34169a,_0x3414('0x32'));_0x21548c[_0x3414('0x3a')]=_[_0x3414('0x3b')](_0xa13ddf[_0x3414('0x3a')]);_0x21548c[_0x3414('0x3c')]=_[_0x3414('0x3d')](_0x21548c[_0x3414('0x39')],_0x21548c[_0x3414('0x3a')]);_0x168d76[_0x3414('0x3e')]=_[_0x3414('0x3d')](_0x21548c[_0x3414('0x39')],qs[_0x3414('0x3f')](_0xa13ddf[_0x3414('0x3a')][_0x3414('0x3f')]));_0x168d76['attributes']=_0x168d76['attributes'][_0x3414('0x40')]?_0x168d76['attributes']:_0x21548c[_0x3414('0x39')];if(!_0xa13ddf[_0x3414('0x3a')][_0x3414('0x41')](_0x3414('0x42'))){_0x168d76[_0x3414('0x24')]=qs[_0x3414('0x24')](_0xa13ddf[_0x3414('0x3a')][_0x3414('0x24')]);_0x168d76[_0x3414('0x22')]=qs[_0x3414('0x22')](_0xa13ddf[_0x3414('0x3a')]['offset']);}_0x168d76[_0x3414('0x43')]=qs[_0x3414('0x44')](_0xa13ddf[_0x3414('0x3a')][_0x3414('0x44')]);_0x168d76['where']=qs[_0x3414('0x3c')](_[_0x3414('0x45')](_0xa13ddf[_0x3414('0x3a')],_0x21548c[_0x3414('0x3c')]),_0x34169a);if(_0xa13ddf[_0x3414('0x3a')][_0x3414('0x46')]){_0x168d76[_0x3414('0x47')]=_[_0x3414('0x48')](_0x168d76[_0x3414('0x47')],{'$or':_[_0x3414('0x34')](_0x34169a,function(_0x40f8b1){if(_0x40f8b1[_0x3414('0x37')]!=='VIRTUAL'){var _0x5544a5={};_0x5544a5[_0x40f8b1[_0x3414('0x32')]]={'$like':'%'+_0xa13ddf[_0x3414('0x3a')][_0x3414('0x46')]+'%'};return _0x5544a5;}})});}_0x168d76=_[_0x3414('0x48')]({},_0x168d76,_0xa13ddf[_0x3414('0x49')]);var _0x4931e2={'where':_0x168d76[_0x3414('0x47')]};return db[_0x3414('0x4a')][_0x3414('0x25')](_0x4931e2)['then'](function(_0x47dd37){_0x2ac19a[_0x3414('0x25')]=_0x47dd37;if(_0xa13ddf[_0x3414('0x3a')][_0x3414('0x4b')]){_0x168d76[_0x3414('0x4c')]=[{'all':!![]}];}return db[_0x3414('0x4a')][_0x3414('0x4d')](_0x168d76);})['then'](function(_0x532683){_0x2ac19a[_0x3414('0x4e')]=_0x532683;return _0x2ac19a;})[_0x3414('0x2c')](respondWithFilteredResult(_0x5dec04,_0x168d76))['catch'](handleError(_0x5dec04,null));};exports[_0x3414('0x4f')]=function(_0x3864b9,_0x1c26a3){var _0x283ce2={'raw':![],'where':{'id':_0x3864b9['params']['id']}},_0x50fba9={};_0x50fba9[_0x3414('0x39')]=_['keys'](db[_0x3414('0x4a')]['rawAttributes']);_0x50fba9[_0x3414('0x3a')]=_['keys'](_0x3864b9['query']);_0x50fba9[_0x3414('0x3c')]=_['intersection'](_0x50fba9[_0x3414('0x39')],_0x50fba9[_0x3414('0x3a')]);_0x283ce2['attributes']=_['intersection'](_0x50fba9[_0x3414('0x39')],qs[_0x3414('0x3f')](_0x3864b9[_0x3414('0x3a')]['fields']));_0x283ce2[_0x3414('0x3e')]=_0x283ce2[_0x3414('0x3e')][_0x3414('0x40')]?_0x283ce2['attributes']:_0x50fba9['model'];if(_0x3864b9[_0x3414('0x3a')][_0x3414('0x4b')]){_0x283ce2[_0x3414('0x4c')]=[{'all':!![]}];}_0x283ce2=_[_0x3414('0x48')]({},_0x283ce2,_0x3864b9[_0x3414('0x49')]);return db[_0x3414('0x4a')]['find'](_0x283ce2)[_0x3414('0x2c')](handleEntityNotFound(_0x1c26a3,null))[_0x3414('0x2c')](respondWithResult(_0x1c26a3,null))[_0x3414('0x50')](handleError(_0x1c26a3,null));};exports['create']=function(_0x3a4e8b,_0x234fd7){return db['CmList'][_0x3414('0x51')](_0x3a4e8b[_0x3414('0x52')],{})[_0x3414('0x2c')](function(_0x263edd){var _0x346f81=_0x3a4e8b['user'][_0x3414('0x2d')]({'plain':!![]});if(!_0x346f81)throw new Error(_0x3414('0x53'));if(_0x346f81['role']===_0x3414('0x54')){var _0x53e572=_0x263edd[_0x3414('0x2d')]({'plain':!![]});var _0x3216cc='Lists';return db[_0x3414('0x55')][_0x3414('0x56')]({'where':{'name':_0x3216cc,'userProfileId':_0x346f81['userProfileId']},'raw':!![]})[_0x3414('0x2c')](function(_0xcf0033){if(_0xcf0033&&_0xcf0033[_0x3414('0x57')]===0x0){return db[_0x3414('0x58')][_0x3414('0x51')]({'name':_0x53e572['name'],'resourceId':_0x53e572['id'],'type':_0xcf0033[_0x3414('0x32')],'sectionId':_0xcf0033['id']},{})[_0x3414('0x2c')](function(){return _0x263edd;});}else{return _0x263edd;}})[_0x3414('0x50')](function(_0x27c082){logger[_0x3414('0x30')](_0x3414('0x59'),_0x27c082);throw _0x27c082;});}return _0x263edd;})[_0x3414('0x2c')](respondWithResult(_0x234fd7,0xc9))[_0x3414('0x50')](handleError(_0x234fd7,null));};exports[_0x3414('0x2b')]=function(_0x1f0b05,_0x5ef2f7){if(_0x1f0b05[_0x3414('0x52')]['id']){delete _0x1f0b05['body']['id'];}return db[_0x3414('0x4a')][_0x3414('0x56')]({'where':{'id':_0x1f0b05[_0x3414('0x5a')]['id']}})['then'](handleEntityNotFound(_0x5ef2f7,null))['then'](saveUpdates(_0x1f0b05[_0x3414('0x52')],null))['then'](respondWithResult(_0x5ef2f7,null))[_0x3414('0x50')](handleError(_0x5ef2f7,null));};exports[_0x3414('0x2f')]=function(_0x7bbcc5,_0x138a57){return db[_0x3414('0x4a')]['find']({'where':{'id':_0x7bbcc5[_0x3414('0x5a')]['id']}})[_0x3414('0x2c')](handleEntityNotFound(_0x138a57,null))[_0x3414('0x2c')](removeEntity(_0x138a57,null))[_0x3414('0x50')](handleError(_0x138a57,null));};exports[_0x3414('0x5b')]=function(_0x32e11a,_0x3bb56c){return db[_0x3414('0x4a')][_0x3414('0x5b')]()[_0x3414('0x2c')](respondWithResult(_0x3bb56c,null))[_0x3414('0x50')](handleError(_0x3bb56c,null));};exports[_0x3414('0x5c')]=function(_0x1cac64,_0x5aea99,_0x278bf3){if(_0x1cac64[_0x3414('0x52')]['id']){delete _0x1cac64[_0x3414('0x52')]['id'];}return db[_0x3414('0x4a')]['find']({'where':{'id':_0x1cac64[_0x3414('0x5a')]['id']}})['then'](handleEntityNotFound(_0x5aea99,null))[_0x3414('0x2c')](function(_0x176264){if(_0x176264){_0x1cac64['body'][_0x3414('0x5d')]=_0x176264['id'];return db['Disposition'][_0x3414('0x51')](_0x1cac64[_0x3414('0x52')]);}})['then'](respondWithResult(_0x5aea99,null))[_0x3414('0x50')](handleError(_0x5aea99,null));};exports['getDispositions']=function(_0x312395,_0x1c2fbd,_0x2a7de3){var _0x29c6cd={'raw':![],'where':{}};var _0x4bd11e={};var _0x2603c2={'count':0x0,'rows':[]};return db[_0x3414('0x4a')][_0x3414('0x5e')]({'where':{'id':_0x312395[_0x3414('0x5a')]['id']}})[_0x3414('0x2c')](handleEntityNotFound(_0x1c2fbd,null))['then'](function(_0x20cd06){if(_0x20cd06){_0x4bd11e[_0x3414('0x39')]=_[_0x3414('0x3b')](db[_0x3414('0x5f')][_0x3414('0x35')]);_0x4bd11e[_0x3414('0x3a')]=_[_0x3414('0x3b')](_0x312395['query']);_0x4bd11e[_0x3414('0x3c')]=_[_0x3414('0x3d')](_0x4bd11e[_0x3414('0x39')],_0x4bd11e[_0x3414('0x3a')]);_0x29c6cd[_0x3414('0x3e')]=_[_0x3414('0x3d')](_0x4bd11e[_0x3414('0x39')],qs[_0x3414('0x3f')](_0x312395[_0x3414('0x3a')][_0x3414('0x3f')]));_0x29c6cd[_0x3414('0x3e')]=_0x29c6cd[_0x3414('0x3e')][_0x3414('0x40')]?_0x29c6cd[_0x3414('0x3e')]:_0x4bd11e[_0x3414('0x39')];if(!_0x312395[_0x3414('0x3a')][_0x3414('0x41')](_0x3414('0x42'))){_0x29c6cd[_0x3414('0x24')]=qs[_0x3414('0x24')](_0x312395[_0x3414('0x3a')][_0x3414('0x24')]);_0x29c6cd[_0x3414('0x22')]=qs[_0x3414('0x22')](_0x312395[_0x3414('0x3a')][_0x3414('0x22')]);}_0x29c6cd[_0x3414('0x43')]=qs[_0x3414('0x44')](_0x312395[_0x3414('0x3a')][_0x3414('0x44')]);_0x29c6cd[_0x3414('0x47')]=qs[_0x3414('0x3c')](_['pick'](_0x312395['query'],_0x4bd11e['filters']));_0x29c6cd[_0x3414('0x47')][_0x3414('0x5d')]=_0x20cd06['id'];if(_0x312395['query'][_0x3414('0x46')]){_0x29c6cd[_0x3414('0x47')]=_[_0x3414('0x48')](_0x29c6cd[_0x3414('0x47')],{'$or':_[_0x3414('0x34')](_0x29c6cd[_0x3414('0x3e')],function(_0x2e257e){var _0x79348f={};_0x79348f[_0x2e257e]={'$like':'%'+_0x312395[_0x3414('0x3a')][_0x3414('0x46')]+'%'};return _0x79348f;})});}_0x29c6cd=_[_0x3414('0x48')]({},_0x29c6cd,_0x312395[_0x3414('0x49')]);return db[_0x3414('0x5f')][_0x3414('0x25')]({'where':_0x29c6cd['where']})[_0x3414('0x2c')](function(_0xdd0b4d){_0x2603c2[_0x3414('0x25')]=_0xdd0b4d;if(_0x312395[_0x3414('0x3a')]['includeAll']){_0x29c6cd[_0x3414('0x4c')]=[{'all':!![]}];}return db[_0x3414('0x5f')][_0x3414('0x4d')](_0x29c6cd);})[_0x3414('0x2c')](function(_0x1fc357){_0x2603c2[_0x3414('0x4e')]=_0x1fc357;return _0x2603c2;});}})['then'](respondWithFilteredResult(_0x1c2fbd,_0x29c6cd))['catch'](handleError(_0x1c2fbd,null));};exports[_0x3414('0x60')]=function(_0x477f49,_0x4d7853,_0x46555d){return db[_0x3414('0x4a')][_0x3414('0x56')]({'where':{'id':_0x477f49[_0x3414('0x5a')]['id']}})['then'](handleEntityNotFound(_0x4d7853,null))[_0x3414('0x2c')](function(_0x105c9a){if(_0x105c9a){return _0x105c9a[_0x3414('0x60')](_0x477f49[_0x3414('0x3a')][_0x3414('0x61')]);}})[_0x3414('0x2c')](respondWithStatusCode(_0x4d7853,null))['catch'](handleError(_0x4d7853,null));};exports[_0x3414('0x62')]=function(_0x2793c2,_0x47459d,_0x3b5e37){return db[_0x3414('0x4a')][_0x3414('0x56')]({'where':{'id':_0x2793c2[_0x3414('0x5a')]['id']}})[_0x3414('0x2c')](handleEntityNotFound(_0x47459d,null))['then'](function(_0x1944e2){if(_0x1944e2){var _0x71257c=[];var _0x58b0d8={'success':[],'errors':[]};return db[_0x3414('0x63')][_0x3414('0x5b')]()['then'](function(_0x4615c7){if(_0x2793c2[_0x3414('0x52')][_0x3414('0x64')]&&_[_0x3414('0x65')](_0x2793c2[_0x3414('0x52')][_0x3414('0x64')])){if(_0x2793c2['body'][_0x3414('0x64')][_0x3414('0x40')]){_0x2793c2[_0x3414('0x52')][_0x3414('0x64')]=_0x2793c2[_0x3414('0x52')][_0x3414('0x64')][_0x3414('0x66')](';')+';';}else{_0x2793c2[_0x3414('0x52')][_0x3414('0x64')]=null;}}else{_0x2793c2[_0x3414('0x52')]['tags']=null;}if(_0x2793c2[_0x3414('0x52')]&&_[_0x3414('0x65')](_0x2793c2[_0x3414('0x52')])){for(var _0x3d035d=0x0;_0x3d035d<_0x2793c2[_0x3414('0x52')][_0x3414('0x40')];_0x3d035d+=0x1){_0x2793c2[_0x3414('0x52')][_0x3d035d][_0x3414('0x5d')]=_0x2793c2[_0x3414('0x5a')]['id'];_0x71257c[_0x3414('0x67')](_0x2793c2[_0x3414('0x52')][_0x3d035d]);}return BPromise[_0x3414('0x68')](_0x71257c,function(_0x33a8d0){return db[_0x3414('0x63')][_0x3414('0x51')](_[_0x3414('0x69')](_0x33a8d0,[_0x3414('0x61'),'id'])||{},{'fields':_[_0x3414('0x3b')](_0x4615c7),'raw':!![]})[_0x3414('0x2c')](function(_0x30c7b0){_0x58b0d8['success']['push'](_0x30c7b0[_0x3414('0x6a')]);})[_0x3414('0x50')](function(_0x357eba){_0x58b0d8[_0x3414('0x6b')][_0x3414('0x67')]({'data':_0x33a8d0,'error':_0x357eba[_0x3414('0x6c')]});});})[_0x3414('0x2c')](function(_0x10cafe){return _0x58b0d8;})['catch'](function(_0x4f98c2){return _0x4f98c2;});}else{_0x47459d[_0x3414('0x20')](0x190)[_0x3414('0x21')]({'message':'Malformed\x20request\x20syntax'});}});}})[_0x3414('0x2c')](respondWithResult(_0x47459d,null))[_0x3414('0x50')](handleError(_0x47459d,null));};exports['getContacts']=function(_0x2e4288,_0x590a79,_0x329fc2){var _0xe1199f;return db[_0x3414('0x4a')][_0x3414('0x56')]({'where':{'id':_0x2e4288[_0x3414('0x5a')]['id']},'include':[{'model':db[_0x3414('0x6d')],'as':_0x3414('0x6e')}]})[_0x3414('0x2c')](handleEntityNotFound(_0x590a79,null))[_0x3414('0x2c')](function(_0x3e183b){if(_0x3e183b){_0xe1199f=_0x3e183b;return db[_0x3414('0x63')][_0x3414('0x35')];}})[_0x3414('0x2c')](function(_0x4e2b87){if(_0x4e2b87){var _0x48f8f7={};var _0x21362f={};_0x21362f['model']=_[_0x3414('0x6f')](_[_0x3414('0x3b')](_0x4e2b87),_[_0x3414('0x34')](_0xe1199f['CustomFields'],function(_0x3ad494){return util['format']('cf_%d',_0x3ad494['id']);}));_0x21362f[_0x3414('0x3a')]=_[_0x3414('0x3b')](_0x2e4288[_0x3414('0x3a')]);_0x21362f[_0x3414('0x3c')]=_['intersection'](_0x21362f[_0x3414('0x39')],_0x21362f[_0x3414('0x3a')]);_0x48f8f7[_0x3414('0x3e')]=_[_0x3414('0x3d')](_0x21362f['model'],qs['fields'](_0x2e4288[_0x3414('0x3a')][_0x3414('0x3f')]));_0x48f8f7['attributes']=_0x48f8f7[_0x3414('0x3e')][_0x3414('0x40')]?_0x48f8f7[_0x3414('0x3e')]:_0x21362f[_0x3414('0x39')];if(!_0x2e4288[_0x3414('0x3a')][_0x3414('0x41')](_0x3414('0x42'))){_0x48f8f7[_0x3414('0x24')]=qs[_0x3414('0x24')](_0x2e4288[_0x3414('0x3a')][_0x3414('0x24')]);_0x48f8f7[_0x3414('0x22')]=qs['offset'](_0x2e4288[_0x3414('0x3a')][_0x3414('0x22')]);}_0x48f8f7['order']=qs[_0x3414('0x44')](_0x2e4288[_0x3414('0x3a')][_0x3414('0x44')]);_0x48f8f7['where']=qs[_0x3414('0x3c')](_[_0x3414('0x45')](_0x2e4288[_0x3414('0x3a')],_0x21362f[_0x3414('0x3c')]));_0x48f8f7[_0x3414('0x70')]=!![];if(_0x2e4288['query'][_0x3414('0x46')]){_0x48f8f7[_0x3414('0x47')]=_[_0x3414('0x48')](_0x48f8f7['where'],{'$or':_[_0x3414('0x34')](_0x48f8f7[_0x3414('0x3e')],function(_0x44f201){var _0x26e809={};_0x26e809[_0x44f201]={'$like':'%'+_0x2e4288[_0x3414('0x3a')][_0x3414('0x46')]+'%'};return _0x26e809;})});}_0x48f8f7=_[_0x3414('0x48')]({},_0x48f8f7,_0x2e4288[_0x3414('0x49')]);return _0xe1199f[_0x3414('0x71')](_0x48f8f7);}})[_0x3414('0x2c')](respondWithResult(_0x590a79,null))[_0x3414('0x50')](handleError(_0x590a79,null));};exports[_0x3414('0x72')]=function(_0x2edbc8,_0x4804f1,_0x200961){var _0x410790;return db[_0x3414('0x4a')][_0x3414('0x56')]({'where':{'id':_0x2edbc8[_0x3414('0x5a')]['id']},'include':[{'model':db[_0x3414('0x6d')],'as':_0x3414('0x6e')}]})[_0x3414('0x2c')](handleEntityNotFound(_0x4804f1,null))['then'](function(_0x16896f){if(_0x16896f){_0x410790=_0x16896f;return db[_0x3414('0x63')]['rawAttributes'];}})['then'](function(_0x55f724){if(_0x55f724){var _0x3f7fe9={};var _0x2733f6={};_0x2733f6[_0x3414('0x39')]=_['concat'](_[_0x3414('0x3b')](_0x55f724),_[_0x3414('0x34')](_0x410790[_0x3414('0x6e')],function(_0x201be7){return util[_0x3414('0x73')]('cf_%d',_0x201be7['id']);}));_0x2733f6[_0x3414('0x3a')]=_['keys'](_0x2edbc8['query']);_0x2733f6[_0x3414('0x3c')]=_['intersection'](_0x2733f6[_0x3414('0x39')],_0x2733f6[_0x3414('0x3a')]);_0x3f7fe9[_0x3414('0x3e')]=_[_0x3414('0x3d')](_0x2733f6['model'],qs[_0x3414('0x3f')](_0x2edbc8[_0x3414('0x3a')][_0x3414('0x3f')]));_0x3f7fe9[_0x3414('0x3e')]=_0x3f7fe9[_0x3414('0x3e')]['length']?_0x3f7fe9[_0x3414('0x3e')]:_0x2733f6[_0x3414('0x39')];if(!_0x2edbc8[_0x3414('0x3a')][_0x3414('0x41')](_0x3414('0x42'))){_0x3f7fe9['limit']=qs[_0x3414('0x24')](_0x2edbc8['query'][_0x3414('0x24')]);_0x3f7fe9['offset']=qs[_0x3414('0x22')](_0x2edbc8[_0x3414('0x3a')]['offset']);}_0x3f7fe9[_0x3414('0x43')]=qs['sort'](_0x2edbc8[_0x3414('0x3a')][_0x3414('0x44')]);_0x3f7fe9[_0x3414('0x47')]=qs['filters'](_[_0x3414('0x45')](_0x2edbc8[_0x3414('0x3a')],_0x2733f6[_0x3414('0x3c')]));_0x3f7fe9[_0x3414('0x70')]=!![];if(_0x2edbc8[_0x3414('0x3a')][_0x3414('0x46')]){_0x3f7fe9[_0x3414('0x47')]=_[_0x3414('0x48')](_0x3f7fe9[_0x3414('0x47')],{'$or':_[_0x3414('0x34')](_0x3f7fe9['attributes'],function(_0x12f71b){var _0x316b13={};_0x316b13[_0x12f71b]={'$like':'%'+_0x2edbc8[_0x3414('0x3a')]['filter']+'%'};return _0x316b13;})});}_0x3f7fe9=_[_0x3414('0x48')]({},_0x3f7fe9,_0x2edbc8['options']);return _0x410790[_0x3414('0x71')](_0x3f7fe9);}})['then'](function(_0x560d1e){if(!_[_0x3414('0x74')](_0x560d1e)){var _0x9299c9=toCsv(_0x560d1e);var _0x303b38=Date['now']();fs['writeFileSync'](util[_0x3414('0x73')]('/tmp/list_%d_%s.csv',_0x410790['id'],_0x303b38),_0x9299c9);_0x4804f1[_0x3414('0x75')](_0x3414('0x76'),_0x3414('0x77')+util['format'](_0x3414('0x78'),_0x410790['id'],_0x303b38));_0x4804f1['setHeader'](_0x3414('0x79'),_0x3414('0x7a'));return _0x4804f1[_0x3414('0x7b')](util[_0x3414('0x73')]('/tmp/list_%d_%s.csv',_0x410790['id'],_0x303b38));}else{return _0x4804f1[_0x3414('0x7c')](0xcc);}})['catch'](handleError(_0x4804f1,null));};exports['addCustomField']=function(_0x3cedb4,_0x541893,_0x59d32e){var _0x3f0686;delete _0x3cedb4[_0x3414('0x52')]['id'];return db['CmList'][_0x3414('0x5e')]({'where':{'id':_0x3cedb4[_0x3414('0x5a')]['id']}})[_0x3414('0x2c')](handleEntityNotFound(_0x541893,null))['then'](function(_0x14a469){if(_0x14a469){return db['sequelize'][_0x3414('0x7d')](function(_0x5bcb4c){return db[_0x3414('0x6d')][_0x3414('0x51')](_0x3cedb4['body'],{'transaction':_0x5bcb4c})['then'](function(_0x2004dc){_0x3f0686=_0x2004dc;return _0x14a469[_0x3414('0x7e')](_0x2004dc,{'transaction':_0x5bcb4c});})['then'](function(){var _0x176740={'type':db[_0x3414('0x7f')][_0x3414('0x80')],'transaction':_0x5bcb4c};switch(_0x3cedb4[_0x3414('0x52')][_0x3414('0x37')]){case'text':_0x176740[_0x3414('0x37')]=db[_0x3414('0x7f')][_0x3414('0x80')];break;case _0x3414('0x81'):_0x176740[_0x3414('0x37')]=db['Sequelize'][_0x3414('0x82')];break;case _0x3414('0x83'):_0x176740[_0x3414('0x37')]=db[_0x3414('0x7f')]['BOOLEAN'];_0x176740[_0x3414('0x84')]=![];break;default:}return db['sequelize'][_0x3414('0x85')][_0x3414('0x86')](_0x3414('0x87'),util[_0x3414('0x73')]('cf_%s',_0x3f0686['id']),_0x176740);})[_0x3414('0x2c')](function(){return _0x3f0686;});});}})[_0x3414('0x2c')](respondWithResult(_0x541893,null))['catch'](handleError(_0x541893,null));};exports['getCustomFields']=function(_0x3ce07b,_0x1a4cf1,_0x3ed2c0){var _0x1473ee={};var _0x165bbe={};var _0xfb3758;var _0x81d79b;return db[_0x3414('0x4a')][_0x3414('0x5e')]({'where':{'id':_0x3ce07b[_0x3414('0x5a')]['id']}})[_0x3414('0x2c')](handleEntityNotFound(_0x1a4cf1,null))['then'](function(_0xa2d092){if(_0xa2d092){_0xfb3758=_0xa2d092;_0x165bbe[_0x3414('0x39')]=_['keys'](db['CmCustomField']['rawAttributes']);_0x165bbe[_0x3414('0x3a')]=_[_0x3414('0x3b')](_0x3ce07b[_0x3414('0x3a')]);_0x165bbe[_0x3414('0x3c')]=_['intersection'](_0x165bbe[_0x3414('0x39')],_0x165bbe[_0x3414('0x3a')]);_0x1473ee[_0x3414('0x3e')]=_[_0x3414('0x3d')](_0x165bbe[_0x3414('0x39')],qs[_0x3414('0x3f')](_0x3ce07b[_0x3414('0x3a')][_0x3414('0x3f')]));_0x1473ee['attributes']=_0x1473ee[_0x3414('0x3e')]['length']?_0x1473ee[_0x3414('0x3e')]:_0x165bbe['model'];_0x1473ee[_0x3414('0x43')]=qs['sort'](_0x3ce07b[_0x3414('0x3a')][_0x3414('0x44')]);_0x1473ee[_0x3414('0x47')]=qs['filters'](_[_0x3414('0x45')](_0x3ce07b[_0x3414('0x3a')],_0x165bbe['filters']));_0x1473ee['where']=_[_0x3414('0x48')](_0x1473ee[_0x3414('0x47')],{'$or':[{'ListId':_0xa2d092['id']},{'ListId':null}]});if(_0x3ce07b[_0x3414('0x3a')][_0x3414('0x46')]){_0x1473ee['where']=_[_0x3414('0x48')](_0x1473ee[_0x3414('0x47')],{'$or':_[_0x3414('0x34')](_0x1473ee[_0x3414('0x3e')],function(_0xa69167){var _0x4f59bf={};_0x4f59bf[_0xa69167]={'$like':'%'+_0x3ce07b[_0x3414('0x3a')][_0x3414('0x46')]+'%'};return _0x4f59bf;})});}_0x1473ee=_[_0x3414('0x48')]({},_0x1473ee,_0x3ce07b[_0x3414('0x49')]);return db[_0x3414('0x6d')]['findAndCountAll'](_0x1473ee);}})[_0x3414('0x2c')](respondWithResult(_0x1a4cf1,null))[_0x3414('0x50')](handleError(_0x1a4cf1,null));};exports[_0x3414('0x88')]=function(_0x36d7ab,_0x7ca8d0,_0x28adeb){return db[_0x3414('0x4a')][_0x3414('0x56')]({'where':{'id':_0x36d7ab[_0x3414('0x5a')]['id']}})[_0x3414('0x2c')](handleEntityNotFound(_0x7ca8d0,null))[_0x3414('0x2c')](function(_0x4ee73b){if(_0x4ee73b){return _0x4ee73b[_0x3414('0x88')](_0x36d7ab[_0x3414('0x52')]['ids'],_[_0x3414('0x69')](_0x36d7ab['body'],[_0x3414('0x61'),'id'])||{})[_0x3414('0x89')](function(_0x2b7f50){for(var _0x57a0a6=0x0;_0x57a0a6<_0x36d7ab[_0x3414('0x52')][_0x3414('0x61')]['length'];_0x57a0a6+=0x1){socket[_0x3414('0x8a')](_0x3414('0x8b'),{'UserId':Number(_0x36d7ab[_0x3414('0x52')]['ids'][_0x57a0a6]),'CmListId':Number(_0x36d7ab[_0x3414('0x5a')]['id'])});}return _0x2b7f50;});}})[_0x3414('0x2c')](respondWithResult(_0x7ca8d0,null))[_0x3414('0x50')](handleError(_0x7ca8d0,null));};exports[_0x3414('0x8c')]=function(_0x29c080,_0x458552,_0x3e7538){return db[_0x3414('0x4a')][_0x3414('0x56')]({'where':{'id':_0x29c080[_0x3414('0x5a')]['id']}})[_0x3414('0x2c')](handleEntityNotFound(_0x458552,null))['then'](function(_0x214908){if(_0x214908){return _0x214908['removeAgents'](_0x29c080[_0x3414('0x3a')]['ids'])['then'](function(){if(_[_0x3414('0x65')](_0x29c080['query'][_0x3414('0x61')])){for(var _0x177f50=0x0;_0x177f50<_0x29c080[_0x3414('0x3a')][_0x3414('0x61')][_0x3414('0x40')];_0x177f50+=0x1){socket[_0x3414('0x8a')](_0x3414('0x8d'),{'UserId':Number(_0x29c080[_0x3414('0x3a')]['ids'][_0x177f50]),'CmListId':Number(_0x29c080[_0x3414('0x5a')]['id'])});}}else{socket[_0x3414('0x8a')](_0x3414('0x8d'),{'UserId':Number(_0x29c080[_0x3414('0x3a')][_0x3414('0x61')]),'CmListId':Number(_0x29c080[_0x3414('0x5a')]['id'])});}});}})['then'](respondWithStatusCode(_0x458552,null))[_0x3414('0x50')](handleError(_0x458552,null));};exports[_0x3414('0x8e')]=function(_0x1dd946,_0x5c06f3,_0x4c1803){var _0x5cc9ab={};var _0x3dba1c={};var _0x37a906;var _0x35902b;return db['CmList'][_0x3414('0x5e')]({'where':{'id':_0x1dd946[_0x3414('0x5a')]['id']}})['then'](handleEntityNotFound(_0x5c06f3,null))[_0x3414('0x2c')](function(_0x76ff13){if(_0x76ff13){_0x37a906=_0x76ff13;_0x3dba1c[_0x3414('0x39')]=_[_0x3414('0x3b')](db['User'][_0x3414('0x35')]);_0x3dba1c['query']=_[_0x3414('0x3b')](_0x1dd946[_0x3414('0x3a')]);_0x3dba1c[_0x3414('0x3c')]=_[_0x3414('0x3d')](_0x3dba1c[_0x3414('0x39')],_0x3dba1c['query']);_0x5cc9ab['attributes']=_[_0x3414('0x3d')](_0x3dba1c[_0x3414('0x39')],qs[_0x3414('0x3f')](_0x1dd946[_0x3414('0x3a')]['fields']));_0x5cc9ab['attributes']=_0x5cc9ab[_0x3414('0x3e')][_0x3414('0x40')]?_0x5cc9ab[_0x3414('0x3e')]:_0x3dba1c[_0x3414('0x39')];_0x5cc9ab[_0x3414('0x43')]=qs[_0x3414('0x44')](_0x1dd946[_0x3414('0x3a')][_0x3414('0x44')]);_0x5cc9ab['where']=qs[_0x3414('0x3c')](_[_0x3414('0x45')](_0x1dd946[_0x3414('0x3a')],_0x3dba1c[_0x3414('0x3c')]));if(_0x1dd946['query'][_0x3414('0x46')]){_0x5cc9ab['where']=_[_0x3414('0x48')](_0x5cc9ab['where'],{'$or':_['map'](_0x5cc9ab['attributes'],function(_0x41e5d8){var _0x49b223={};_0x49b223[_0x41e5d8]={'$like':'%'+_0x1dd946[_0x3414('0x3a')][_0x3414('0x46')]+'%'};return _0x49b223;})});}_0x5cc9ab=_[_0x3414('0x48')]({},_0x5cc9ab,_0x1dd946[_0x3414('0x49')]);return _0x37a906[_0x3414('0x8e')](_0x5cc9ab);}})['then'](function(_0x7b1e12){if(_0x7b1e12){_0x35902b=_0x7b1e12[_0x3414('0x40')];if(!_0x1dd946[_0x3414('0x3a')][_0x3414('0x41')](_0x3414('0x42'))){_0x5cc9ab[_0x3414('0x24')]=qs[_0x3414('0x24')](_0x1dd946[_0x3414('0x3a')][_0x3414('0x24')]);_0x5cc9ab[_0x3414('0x22')]=qs[_0x3414('0x22')](_0x1dd946[_0x3414('0x3a')][_0x3414('0x22')]);}return _0x37a906[_0x3414('0x8e')](_0x5cc9ab);}})['then'](function(_0x23a393){if(_0x23a393){return _0x23a393?{'count':_0x35902b,'rows':_0x23a393}:null;}})['then'](respondWithResult(_0x5c06f3,null))['catch'](handleError(_0x5c06f3,null));};
\ No newline at end of file
+var _0x0cb9=['select','cm_contacts','c.ListId\x20=\x20?','distinct','field','c.cf_','customField_','alias','item','from','cm_contact_has_items','ItemTypeId\x20=\x20?','additionalPhone_','description','CmContactId\x20=\x20c.id','toString','isEmpty','now','writeFileSync','/tmp/list_%d_%s.csv','setHeader','Content-disposition','attachment;\x20filename=','list_%d_%s.csv','Content-type','text/csv','addCustomField','sequelize','addCustomFields','Sequelize','TEXT','text','number','INTEGER','switch','defaultValue','queryInterface','addColumn','cf_%s','getCustomFields','findAndCountAll','getGlobalCustomFields','addAgents','omit','spread','userCmList:save','removeAgents','isArray','userCmList:remove','emit','getAgents','User','info','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','sox','fs-extra','lodash','crypto','desk.js','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','localhost','socket.io-emitter','./cmList.socket','register','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','then','destroy','get','Lists','UserProfileResource','error','stack','name','send','index','map','CmList','rawAttributes','fieldName','type','model','query','keys','filters','intersection','attributes','length','hasOwnProperty','nolimit','order','sort','filter','merge','options','where','includeAll','rows','params','fields','find','catch','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','describe','addDisposition','Disposition','getDispositions','findOne','pick','include','removeDispositions','ids','addContacts','CmContact','tags','join','ListId','push','each','success','dataValues','errors','message','Malformed\x20request\x20syntax','CustomFields','concat','format','cf_%d','raw','getContactsCsv','ContactItemType','OrderBy','CmCustomField','findAll'];(function(_0x132b04,_0x5ce854){var _0x42dfcd=function(_0x107047){while(--_0x107047){_0x132b04['push'](_0x132b04['shift']());}};_0x42dfcd(++_0x5ce854);}(_0x0cb9,0xdc));var _0x90cb=function(_0x12f4eb,_0x15a8c0){_0x12f4eb=_0x12f4eb-0x0;var _0x2e2011=_0x0cb9[_0x12f4eb];return _0x2e2011;};'use strict';var emlformat=require(_0x90cb('0x0'));var rimraf=require(_0x90cb('0x1'));var zipdir=require(_0x90cb('0x2'));var jsonpatch=require(_0x90cb('0x3'));var rp=require(_0x90cb('0x4'));var moment=require(_0x90cb('0x5'));var BPromise=require(_0x90cb('0x6'));var Mustache=require(_0x90cb('0x7'));var util=require('util');var path=require(_0x90cb('0x8'));var sox=require(_0x90cb('0x9'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x90cb('0xa'));var _=require(_0x90cb('0xb'));var squel=require('squel');var crypto=require(_0x90cb('0xc'));var jsforce=require('jsforce');var deskjs=require(_0x90cb('0xd'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require('papaparse');var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0x90cb('0xe'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x90cb('0xf'))(_0x90cb('0x10'));var utils=require(_0x90cb('0x11'));var config=require(_0x90cb('0x12'));var licenseUtil=require(_0x90cb('0x13'));var db=require(_0x90cb('0x14'))['db'];var csv_results;config[_0x90cb('0x15')]=_['defaults'](config[_0x90cb('0x15')],{'host':_0x90cb('0x16'),'port':0x18eb});var socket=require(_0x90cb('0x17'))(new Redis(config[_0x90cb('0x15')]));require(_0x90cb('0x18'))[_0x90cb('0x19')](socket);function respondWithStatusCode(_0x232f4b,_0x2ceda6){_0x2ceda6=_0x2ceda6||0xcc;return function(_0x59158b){if(_0x59158b){return _0x232f4b[_0x90cb('0x1a')](_0x2ceda6);}return _0x232f4b[_0x90cb('0x1b')](_0x2ceda6)[_0x90cb('0x1c')]();};}function respondWithResult(_0x293c02,_0x3e5e93){_0x3e5e93=_0x3e5e93||0xc8;return function(_0xf2e30b){if(_0xf2e30b){return _0x293c02[_0x90cb('0x1b')](_0x3e5e93)[_0x90cb('0x1d')](_0xf2e30b);}};}function respondWithFilteredResult(_0x4bbdcf,_0x535d44){return function(_0x525bb9){if(_0x525bb9){var _0x5f3e40=typeof _0x535d44[_0x90cb('0x1e')]===_0x90cb('0x1f')&&typeof _0x535d44[_0x90cb('0x20')]==='undefined';var _0x8ec09c=_0x525bb9[_0x90cb('0x21')];var _0x2b15a5=_0x5f3e40?0x0:_0x535d44[_0x90cb('0x1e')];var _0x5d100f=_0x5f3e40?_0x525bb9[_0x90cb('0x21')]:_0x535d44[_0x90cb('0x1e')]+_0x535d44[_0x90cb('0x20')];var _0x69d470;if(_0x5d100f>=_0x8ec09c){_0x5d100f=_0x8ec09c;_0x69d470=0xc8;}else{_0x69d470=0xce;}_0x4bbdcf[_0x90cb('0x1b')](_0x69d470);return _0x4bbdcf[_0x90cb('0x22')](_0x90cb('0x23'),_0x2b15a5+'-'+_0x5d100f+'/'+_0x8ec09c)[_0x90cb('0x1d')](_0x525bb9);}return null;};}function patchUpdates(_0x4d330e){return function(_0x468125){try{jsonpatch[_0x90cb('0x24')](_0x468125,_0x4d330e,!![]);}catch(_0x211f90){return BPromise[_0x90cb('0x25')](_0x211f90);}return _0x468125[_0x90cb('0x26')]();};}function saveUpdates(_0x405a98,_0x462a76){return function(_0x31fed4){if(_0x31fed4){return _0x31fed4['update'](_0x405a98)[_0x90cb('0x27')](function(_0x264222){return _0x264222;});}return null;};}function removeEntity(_0x56991d,_0x11dfe3){return function(_0x362f0a){if(_0x362f0a){return _0x362f0a[_0x90cb('0x28')]()['then'](function(){var _0x4827f2=_0x362f0a[_0x90cb('0x29')]({'plain':!![]});var _0x421927=_0x90cb('0x2a');return db[_0x90cb('0x2b')][_0x90cb('0x28')]({'where':{'type':_0x421927,'resourceId':_0x4827f2['id']}})[_0x90cb('0x27')](function(){return _0x362f0a;});})[_0x90cb('0x27')](function(){_0x56991d['status'](0xcc)[_0x90cb('0x1c')]();});}};}function handleEntityNotFound(_0xaae570,_0x5c6610){return function(_0x106cdc){if(!_0x106cdc){_0xaae570['sendStatus'](0x194);}return _0x106cdc;};}function handleError(_0x58b6bd,_0x2cb4c2){_0x2cb4c2=_0x2cb4c2||0x1f4;return function(_0x51da21){logger[_0x90cb('0x2c')](_0x51da21[_0x90cb('0x2d')]);if(_0x51da21[_0x90cb('0x2e')]){delete _0x51da21[_0x90cb('0x2e')];}_0x58b6bd[_0x90cb('0x1b')](_0x2cb4c2)[_0x90cb('0x2f')](_0x51da21);};}exports[_0x90cb('0x30')]=function(_0x306f4f,_0x160924){var _0x337822={},_0x16cef0={},_0x564d85={'count':0x0,'rows':[]};var _0x59d917=_[_0x90cb('0x31')](db[_0x90cb('0x32')][_0x90cb('0x33')],function(_0x3b5a4c){return{'name':_0x3b5a4c[_0x90cb('0x34')],'type':_0x3b5a4c[_0x90cb('0x35')]['key']};});_0x16cef0[_0x90cb('0x36')]=_[_0x90cb('0x31')](_0x59d917,_0x90cb('0x2e'));_0x16cef0[_0x90cb('0x37')]=_[_0x90cb('0x38')](_0x306f4f['query']);_0x16cef0[_0x90cb('0x39')]=_[_0x90cb('0x3a')](_0x16cef0[_0x90cb('0x36')],_0x16cef0['query']);_0x337822['attributes']=_['intersection'](_0x16cef0[_0x90cb('0x36')],qs['fields'](_0x306f4f[_0x90cb('0x37')]['fields']));_0x337822[_0x90cb('0x3b')]=_0x337822[_0x90cb('0x3b')][_0x90cb('0x3c')]?_0x337822['attributes']:_0x16cef0[_0x90cb('0x36')];if(!_0x306f4f[_0x90cb('0x37')][_0x90cb('0x3d')](_0x90cb('0x3e'))){_0x337822[_0x90cb('0x20')]=qs[_0x90cb('0x20')](_0x306f4f[_0x90cb('0x37')]['limit']);_0x337822[_0x90cb('0x1e')]=qs[_0x90cb('0x1e')](_0x306f4f[_0x90cb('0x37')][_0x90cb('0x1e')]);}_0x337822[_0x90cb('0x3f')]=qs[_0x90cb('0x40')](_0x306f4f[_0x90cb('0x37')][_0x90cb('0x40')]);_0x337822['where']=qs[_0x90cb('0x39')](_['pick'](_0x306f4f[_0x90cb('0x37')],_0x16cef0[_0x90cb('0x39')]),_0x59d917);if(_0x306f4f[_0x90cb('0x37')][_0x90cb('0x41')]){_0x337822['where']=_[_0x90cb('0x42')](_0x337822['where'],{'$or':_[_0x90cb('0x31')](_0x59d917,function(_0x3ad9d4){if(_0x3ad9d4[_0x90cb('0x35')]!=='VIRTUAL'){var _0x185d16={};_0x185d16[_0x3ad9d4[_0x90cb('0x2e')]]={'$like':'%'+_0x306f4f['query']['filter']+'%'};return _0x185d16;}})});}_0x337822=_[_0x90cb('0x42')]({},_0x337822,_0x306f4f[_0x90cb('0x43')]);var _0x3c09b6={'where':_0x337822[_0x90cb('0x44')]};return db['CmList']['count'](_0x3c09b6)['then'](function(_0x4485c5){_0x564d85[_0x90cb('0x21')]=_0x4485c5;if(_0x306f4f[_0x90cb('0x37')][_0x90cb('0x45')]){_0x337822['include']=[{'all':!![]}];}return db[_0x90cb('0x32')]['findAll'](_0x337822);})[_0x90cb('0x27')](function(_0x3b8ab8){_0x564d85[_0x90cb('0x46')]=_0x3b8ab8;return _0x564d85;})[_0x90cb('0x27')](respondWithFilteredResult(_0x160924,_0x337822))['catch'](handleError(_0x160924,null));};exports['show']=function(_0x10d698,_0x3843e0){var _0x5b3605={'raw':![],'where':{'id':_0x10d698[_0x90cb('0x47')]['id']}},_0x9de902={};_0x9de902[_0x90cb('0x36')]=_[_0x90cb('0x38')](db[_0x90cb('0x32')][_0x90cb('0x33')]);_0x9de902['query']=_[_0x90cb('0x38')](_0x10d698[_0x90cb('0x37')]);_0x9de902[_0x90cb('0x39')]=_[_0x90cb('0x3a')](_0x9de902[_0x90cb('0x36')],_0x9de902[_0x90cb('0x37')]);_0x5b3605[_0x90cb('0x3b')]=_['intersection'](_0x9de902[_0x90cb('0x36')],qs[_0x90cb('0x48')](_0x10d698[_0x90cb('0x37')][_0x90cb('0x48')]));_0x5b3605['attributes']=_0x5b3605[_0x90cb('0x3b')][_0x90cb('0x3c')]?_0x5b3605[_0x90cb('0x3b')]:_0x9de902[_0x90cb('0x36')];if(_0x10d698[_0x90cb('0x37')]['includeAll']){_0x5b3605['include']=[{'all':!![]}];}_0x5b3605=_['merge']({},_0x5b3605,_0x10d698['options']);return db['CmList'][_0x90cb('0x49')](_0x5b3605)[_0x90cb('0x27')](handleEntityNotFound(_0x3843e0,null))['then'](respondWithResult(_0x3843e0,null))[_0x90cb('0x4a')](handleError(_0x3843e0,null));};exports['create']=function(_0x46a2a4,_0x4eae27){return db[_0x90cb('0x32')][_0x90cb('0x4b')](_0x46a2a4[_0x90cb('0x4c')],{})[_0x90cb('0x27')](function(_0xfec3ff){var _0x214626=_0x46a2a4[_0x90cb('0x4d')][_0x90cb('0x29')]({'plain':!![]});if(!_0x214626)throw new Error(_0x90cb('0x4e'));if(_0x214626[_0x90cb('0x4f')]===_0x90cb('0x4d')){var _0x2535aa=_0xfec3ff[_0x90cb('0x29')]({'plain':!![]});var _0x229d5d='Lists';return db[_0x90cb('0x50')][_0x90cb('0x49')]({'where':{'name':_0x229d5d,'userProfileId':_0x214626['userProfileId']},'raw':!![]})['then'](function(_0xe95fd8){if(_0xe95fd8&&_0xe95fd8[_0x90cb('0x51')]===0x0){return db['UserProfileResource']['create']({'name':_0x2535aa[_0x90cb('0x2e')],'resourceId':_0x2535aa['id'],'type':_0xe95fd8[_0x90cb('0x2e')],'sectionId':_0xe95fd8['id']},{})['then'](function(){return _0xfec3ff;});}else{return _0xfec3ff;}})[_0x90cb('0x4a')](function(_0xa7fcb6){logger[_0x90cb('0x2c')](_0x90cb('0x52'),_0xa7fcb6);throw _0xa7fcb6;});}return _0xfec3ff;})[_0x90cb('0x27')](respondWithResult(_0x4eae27,0xc9))[_0x90cb('0x4a')](handleError(_0x4eae27,null));};exports['update']=function(_0x131dd8,_0xf199af){if(_0x131dd8[_0x90cb('0x4c')]['id']){delete _0x131dd8[_0x90cb('0x4c')]['id'];}return db[_0x90cb('0x32')][_0x90cb('0x49')]({'where':{'id':_0x131dd8['params']['id']}})['then'](handleEntityNotFound(_0xf199af,null))[_0x90cb('0x27')](saveUpdates(_0x131dd8[_0x90cb('0x4c')],null))['then'](respondWithResult(_0xf199af,null))[_0x90cb('0x4a')](handleError(_0xf199af,null));};exports[_0x90cb('0x28')]=function(_0x4c4ad9,_0x6a6e54){return db[_0x90cb('0x32')][_0x90cb('0x49')]({'where':{'id':_0x4c4ad9[_0x90cb('0x47')]['id']}})['then'](handleEntityNotFound(_0x6a6e54,null))[_0x90cb('0x27')](removeEntity(_0x6a6e54,null))[_0x90cb('0x4a')](handleError(_0x6a6e54,null));};exports[_0x90cb('0x53')]=function(_0x45c7fd,_0x5a73f4){return db[_0x90cb('0x32')]['describe']()[_0x90cb('0x27')](respondWithResult(_0x5a73f4,null))[_0x90cb('0x4a')](handleError(_0x5a73f4,null));};exports[_0x90cb('0x54')]=function(_0x2dffa3,_0x2dda43,_0x5e7fc0){if(_0x2dffa3['body']['id']){delete _0x2dffa3['body']['id'];}return db[_0x90cb('0x32')][_0x90cb('0x49')]({'where':{'id':_0x2dffa3['params']['id']}})[_0x90cb('0x27')](handleEntityNotFound(_0x2dda43,null))[_0x90cb('0x27')](function(_0x50ce4e){if(_0x50ce4e){_0x2dffa3['body']['ListId']=_0x50ce4e['id'];return db[_0x90cb('0x55')][_0x90cb('0x4b')](_0x2dffa3[_0x90cb('0x4c')]);}})[_0x90cb('0x27')](respondWithResult(_0x2dda43,null))[_0x90cb('0x4a')](handleError(_0x2dda43,null));};exports[_0x90cb('0x56')]=function(_0x1c2855,_0x522858,_0x259434){var _0x3b2550={'raw':![],'where':{}};var _0x4c1a07={};var _0x96bb1e={'count':0x0,'rows':[]};return db[_0x90cb('0x32')][_0x90cb('0x57')]({'where':{'id':_0x1c2855[_0x90cb('0x47')]['id']}})['then'](handleEntityNotFound(_0x522858,null))[_0x90cb('0x27')](function(_0x5b3b41){if(_0x5b3b41){_0x4c1a07['model']=_[_0x90cb('0x38')](db[_0x90cb('0x55')][_0x90cb('0x33')]);_0x4c1a07[_0x90cb('0x37')]=_[_0x90cb('0x38')](_0x1c2855['query']);_0x4c1a07['filters']=_[_0x90cb('0x3a')](_0x4c1a07['model'],_0x4c1a07[_0x90cb('0x37')]);_0x3b2550[_0x90cb('0x3b')]=_[_0x90cb('0x3a')](_0x4c1a07['model'],qs[_0x90cb('0x48')](_0x1c2855[_0x90cb('0x37')]['fields']));_0x3b2550[_0x90cb('0x3b')]=_0x3b2550[_0x90cb('0x3b')][_0x90cb('0x3c')]?_0x3b2550[_0x90cb('0x3b')]:_0x4c1a07[_0x90cb('0x36')];if(!_0x1c2855[_0x90cb('0x37')][_0x90cb('0x3d')](_0x90cb('0x3e'))){_0x3b2550[_0x90cb('0x20')]=qs[_0x90cb('0x20')](_0x1c2855[_0x90cb('0x37')][_0x90cb('0x20')]);_0x3b2550[_0x90cb('0x1e')]=qs[_0x90cb('0x1e')](_0x1c2855['query']['offset']);}_0x3b2550['order']=qs[_0x90cb('0x40')](_0x1c2855['query'][_0x90cb('0x40')]);_0x3b2550[_0x90cb('0x44')]=qs[_0x90cb('0x39')](_[_0x90cb('0x58')](_0x1c2855[_0x90cb('0x37')],_0x4c1a07[_0x90cb('0x39')]));_0x3b2550['where']['ListId']=_0x5b3b41['id'];if(_0x1c2855[_0x90cb('0x37')][_0x90cb('0x41')]){_0x3b2550[_0x90cb('0x44')]=_[_0x90cb('0x42')](_0x3b2550[_0x90cb('0x44')],{'$or':_[_0x90cb('0x31')](_0x3b2550[_0x90cb('0x3b')],function(_0x6a290b){var _0x5e1f7b={};_0x5e1f7b[_0x6a290b]={'$like':'%'+_0x1c2855[_0x90cb('0x37')][_0x90cb('0x41')]+'%'};return _0x5e1f7b;})});}_0x3b2550=_[_0x90cb('0x42')]({},_0x3b2550,_0x1c2855[_0x90cb('0x43')]);return db[_0x90cb('0x55')]['count']({'where':_0x3b2550[_0x90cb('0x44')]})['then'](function(_0x2fe107){_0x96bb1e[_0x90cb('0x21')]=_0x2fe107;if(_0x1c2855['query'][_0x90cb('0x45')]){_0x3b2550[_0x90cb('0x59')]=[{'all':!![]}];}return db[_0x90cb('0x55')]['findAll'](_0x3b2550);})[_0x90cb('0x27')](function(_0x2598e6){_0x96bb1e[_0x90cb('0x46')]=_0x2598e6;return _0x96bb1e;});}})[_0x90cb('0x27')](respondWithFilteredResult(_0x522858,_0x3b2550))[_0x90cb('0x4a')](handleError(_0x522858,null));};exports[_0x90cb('0x5a')]=function(_0x4a2eaf,_0x5ceb2c,_0x6c7571){return db[_0x90cb('0x32')]['find']({'where':{'id':_0x4a2eaf[_0x90cb('0x47')]['id']}})[_0x90cb('0x27')](handleEntityNotFound(_0x5ceb2c,null))[_0x90cb('0x27')](function(_0x8bd39c){if(_0x8bd39c){return _0x8bd39c[_0x90cb('0x5a')](_0x4a2eaf[_0x90cb('0x37')][_0x90cb('0x5b')]);}})['then'](respondWithStatusCode(_0x5ceb2c,null))[_0x90cb('0x4a')](handleError(_0x5ceb2c,null));};exports[_0x90cb('0x5c')]=function(_0xa20166,_0x5d74bd,_0x2bb003){return db[_0x90cb('0x32')][_0x90cb('0x49')]({'where':{'id':_0xa20166[_0x90cb('0x47')]['id']}})[_0x90cb('0x27')](handleEntityNotFound(_0x5d74bd,null))[_0x90cb('0x27')](function(_0x147239){if(_0x147239){var _0x2a1c68=[];var _0x160c40={'success':[],'errors':[]};return db[_0x90cb('0x5d')][_0x90cb('0x53')]()[_0x90cb('0x27')](function(_0x5b6b95){if(_0xa20166[_0x90cb('0x4c')]['tags']&&_['isArray'](_0xa20166[_0x90cb('0x4c')][_0x90cb('0x5e')])){if(_0xa20166[_0x90cb('0x4c')][_0x90cb('0x5e')][_0x90cb('0x3c')]){_0xa20166['body'][_0x90cb('0x5e')]=_0xa20166['body']['tags'][_0x90cb('0x5f')](';')+';';}else{_0xa20166['body'][_0x90cb('0x5e')]=null;}}else{_0xa20166[_0x90cb('0x4c')][_0x90cb('0x5e')]=null;}if(_0xa20166[_0x90cb('0x4c')]&&_['isArray'](_0xa20166[_0x90cb('0x4c')])){for(var _0x238b01=0x0;_0x238b01<_0xa20166[_0x90cb('0x4c')]['length'];_0x238b01+=0x1){_0xa20166[_0x90cb('0x4c')][_0x238b01][_0x90cb('0x60')]=_0xa20166[_0x90cb('0x47')]['id'];_0x2a1c68[_0x90cb('0x61')](_0xa20166[_0x90cb('0x4c')][_0x238b01]);}return BPromise[_0x90cb('0x62')](_0x2a1c68,function(_0x395aa4){return db[_0x90cb('0x5d')][_0x90cb('0x4b')](_['omit'](_0x395aa4,[_0x90cb('0x5b'),'id'])||{},{'fields':_['keys'](_0x5b6b95),'raw':!![]})['then'](function(_0x4084dd){_0x160c40[_0x90cb('0x63')][_0x90cb('0x61')](_0x4084dd[_0x90cb('0x64')]);})[_0x90cb('0x4a')](function(_0x42ecb4){_0x160c40[_0x90cb('0x65')][_0x90cb('0x61')]({'data':_0x395aa4,'error':_0x42ecb4[_0x90cb('0x66')]});});})[_0x90cb('0x27')](function(_0x14b87f){return _0x160c40;})[_0x90cb('0x4a')](function(_0x3f78b3){return _0x3f78b3;});}else{_0x5d74bd[_0x90cb('0x1b')](0x190)[_0x90cb('0x1d')]({'message':_0x90cb('0x67')});}});}})[_0x90cb('0x27')](respondWithResult(_0x5d74bd,null))[_0x90cb('0x4a')](handleError(_0x5d74bd,null));};exports['getContacts']=function(_0x90e7d5,_0x3579fc,_0x5f1fd4){var _0x5c9ad9;return db[_0x90cb('0x32')][_0x90cb('0x49')]({'where':{'id':_0x90e7d5[_0x90cb('0x47')]['id']},'include':[{'model':db['CmCustomField'],'as':_0x90cb('0x68')}]})[_0x90cb('0x27')](handleEntityNotFound(_0x3579fc,null))[_0x90cb('0x27')](function(_0x574081){if(_0x574081){_0x5c9ad9=_0x574081;return db[_0x90cb('0x5d')][_0x90cb('0x33')];}})[_0x90cb('0x27')](function(_0x3afc55){if(_0x3afc55){var _0x375082={};var _0x3a83f0={};_0x3a83f0[_0x90cb('0x36')]=_[_0x90cb('0x69')](_[_0x90cb('0x38')](_0x3afc55),_[_0x90cb('0x31')](_0x5c9ad9['CustomFields'],function(_0x40ac8a){return util[_0x90cb('0x6a')](_0x90cb('0x6b'),_0x40ac8a['id']);}));_0x3a83f0[_0x90cb('0x37')]=_[_0x90cb('0x38')](_0x90e7d5[_0x90cb('0x37')]);_0x3a83f0[_0x90cb('0x39')]=_[_0x90cb('0x3a')](_0x3a83f0['model'],_0x3a83f0['query']);_0x375082[_0x90cb('0x3b')]=_[_0x90cb('0x3a')](_0x3a83f0['model'],qs[_0x90cb('0x48')](_0x90e7d5[_0x90cb('0x37')][_0x90cb('0x48')]));_0x375082[_0x90cb('0x3b')]=_0x375082[_0x90cb('0x3b')]['length']?_0x375082['attributes']:_0x3a83f0[_0x90cb('0x36')];if(!_0x90e7d5['query'][_0x90cb('0x3d')](_0x90cb('0x3e'))){_0x375082[_0x90cb('0x20')]=qs[_0x90cb('0x20')](_0x90e7d5[_0x90cb('0x37')][_0x90cb('0x20')]);_0x375082[_0x90cb('0x1e')]=qs[_0x90cb('0x1e')](_0x90e7d5[_0x90cb('0x37')][_0x90cb('0x1e')]);}_0x375082[_0x90cb('0x3f')]=qs['sort'](_0x90e7d5['query'][_0x90cb('0x40')]);_0x375082[_0x90cb('0x44')]=qs['filters'](_[_0x90cb('0x58')](_0x90e7d5['query'],_0x3a83f0['filters']));_0x375082[_0x90cb('0x6c')]=!![];if(_0x90e7d5['query']['filter']){_0x375082[_0x90cb('0x44')]=_[_0x90cb('0x42')](_0x375082['where'],{'$or':_[_0x90cb('0x31')](_0x375082[_0x90cb('0x3b')],function(_0xa47bd8){var _0x55c376={};_0x55c376[_0xa47bd8]={'$like':'%'+_0x90e7d5[_0x90cb('0x37')][_0x90cb('0x41')]+'%'};return _0x55c376;})});}_0x375082=_[_0x90cb('0x42')]({},_0x375082,_0x90e7d5[_0x90cb('0x43')]);return _0x5c9ad9['getContacts'](_0x375082);}})['then'](respondWithResult(_0x3579fc,null))['catch'](handleError(_0x3579fc,null));};exports[_0x90cb('0x6d')]=function(_0x3c81b2,_0x55cb00,_0x153f29){var _0x38dc0f;var _0x96b026;var _0x5722b9;var _0x40fcd6=_0x3c81b2[_0x90cb('0x47')]['id'];csv_results=[];return db[_0x90cb('0x6e')]['findAll']({'attributes':['id','name'],'raw':!![],'order':[_0x90cb('0x6f')]})[_0x90cb('0x27')](function(_0x93e128){_0x38dc0f=_0x93e128;var _0xe5abf3=_['keys'](db[_0x90cb('0x5d')]['rawAttributes']);return db[_0x90cb('0x70')][_0x90cb('0x71')]({'raw':!![],'attributes':['id','alias']})[_0x90cb('0x27')](function(_0x86dd50){_0x96b026=_0x86dd50;var _0x37d639=squel[_0x90cb('0x72')]()['fields'](_0xe5abf3)['from'](_0x90cb('0x73'),'c')[_0x90cb('0x44')](_0x90cb('0x74'),_0x40fcd6)[_0x90cb('0x44')]('c.deletedAt\x20is\x20null')[_0x90cb('0x75')]();for(var _0xa67c49=0x0;_0xa67c49<_0x96b026[_0x90cb('0x3c')];_0xa67c49++){_0x37d639[_0x90cb('0x76')](_0x90cb('0x77')+_0x96b026[_0xa67c49]['id'],_0x90cb('0x78')+_0x96b026[_0xa67c49][_0x90cb('0x79')]);}for(var _0xa67c49=0x0;_0xa67c49<_0x38dc0f[_0x90cb('0x3c')];_0xa67c49++){_0x37d639['field'](squel[_0x90cb('0x72')]()[_0x90cb('0x76')](_0x90cb('0x7a'))[_0x90cb('0x7b')](_0x90cb('0x7c'))[_0x90cb('0x44')](_0x90cb('0x7d'),_0x38dc0f[_0xa67c49]['id'])['where']('CmContactId\x20=\x20c.id'),_0x90cb('0x7e')+_0x38dc0f[_0xa67c49][_0x90cb('0x2e')]);_0x37d639[_0x90cb('0x76')](squel[_0x90cb('0x72')]()[_0x90cb('0x76')](_0x90cb('0x7f'))[_0x90cb('0x7b')]('cm_contact_has_items')[_0x90cb('0x44')](_0x90cb('0x7d'),_0x38dc0f[_0xa67c49]['id'])[_0x90cb('0x44')](_0x90cb('0x80')),'description_additionalPhone_'+_0x38dc0f[_0xa67c49][_0x90cb('0x2e')]);}var _0x5d270a=[];_0x5d270a['push'](_0x37d639[_0x90cb('0x81')]());BPromise['each'](_0x5d270a,handleQuery)[_0x90cb('0x27')](function(_0x49baac){handleQuery(_0x37d639[_0x90cb('0x81')]());var _0x1b04d7=csv_results[0x0];if(!_[_0x90cb('0x82')](_0x1b04d7)){var _0x203a03=toCsv(_0x1b04d7);var _0x1d9976=Date[_0x90cb('0x83')]();fs[_0x90cb('0x84')](util['format'](_0x90cb('0x85'),_0x40fcd6,_0x1d9976),_0x203a03);_0x55cb00[_0x90cb('0x86')](_0x90cb('0x87'),_0x90cb('0x88')+util[_0x90cb('0x6a')](_0x90cb('0x89'),_0x40fcd6,_0x1d9976));_0x55cb00[_0x90cb('0x86')](_0x90cb('0x8a'),_0x90cb('0x8b'));return _0x55cb00['download'](util[_0x90cb('0x6a')](_0x90cb('0x85'),_0x40fcd6,_0x1d9976));}else{return _0x55cb00[_0x90cb('0x1a')](0xcc);}});});});};exports[_0x90cb('0x8c')]=function(_0x8cf5d7,_0x585fae,_0xe607d3){var _0xd829cd;delete _0x8cf5d7['body']['id'];return db['CmList'][_0x90cb('0x57')]({'where':{'id':_0x8cf5d7[_0x90cb('0x47')]['id']}})[_0x90cb('0x27')](handleEntityNotFound(_0x585fae,null))[_0x90cb('0x27')](function(_0x52b24a){if(_0x52b24a){return db[_0x90cb('0x8d')]['transaction'](function(_0x2b81fb){return db['CmCustomField']['create'](_0x8cf5d7['body'],{'transaction':_0x2b81fb})[_0x90cb('0x27')](function(_0x4aa237){_0xd829cd=_0x4aa237;return _0x52b24a[_0x90cb('0x8e')](_0x4aa237,{'transaction':_0x2b81fb});})[_0x90cb('0x27')](function(){var _0x7582a4={'type':db[_0x90cb('0x8f')][_0x90cb('0x90')],'transaction':_0x2b81fb};switch(_0x8cf5d7[_0x90cb('0x4c')][_0x90cb('0x35')]){case _0x90cb('0x91'):_0x7582a4['type']=db[_0x90cb('0x8f')][_0x90cb('0x90')];break;case _0x90cb('0x92'):_0x7582a4[_0x90cb('0x35')]=db[_0x90cb('0x8f')][_0x90cb('0x93')];break;case _0x90cb('0x94'):_0x7582a4['type']=db[_0x90cb('0x8f')]['BOOLEAN'];_0x7582a4[_0x90cb('0x95')]=![];break;default:}return db[_0x90cb('0x8d')][_0x90cb('0x96')][_0x90cb('0x97')](_0x90cb('0x73'),util[_0x90cb('0x6a')](_0x90cb('0x98'),_0xd829cd['id']),_0x7582a4);})[_0x90cb('0x27')](function(){return _0xd829cd;});});}})[_0x90cb('0x27')](respondWithResult(_0x585fae,null))[_0x90cb('0x4a')](handleError(_0x585fae,null));};exports[_0x90cb('0x99')]=function(_0x2f807d,_0x3c7bd7,_0x35ec60){var _0x365f0d={};var _0x478e59={};var _0x507120;var _0x37a3f7;return db[_0x90cb('0x32')][_0x90cb('0x57')]({'where':{'id':_0x2f807d[_0x90cb('0x47')]['id']}})['then'](handleEntityNotFound(_0x3c7bd7,null))[_0x90cb('0x27')](function(_0x213106){if(_0x213106){_0x507120=_0x213106;_0x478e59[_0x90cb('0x36')]=_['keys'](db[_0x90cb('0x70')]['rawAttributes']);_0x478e59['query']=_[_0x90cb('0x38')](_0x2f807d[_0x90cb('0x37')]);_0x478e59[_0x90cb('0x39')]=_[_0x90cb('0x3a')](_0x478e59[_0x90cb('0x36')],_0x478e59[_0x90cb('0x37')]);_0x365f0d[_0x90cb('0x3b')]=_[_0x90cb('0x3a')](_0x478e59[_0x90cb('0x36')],qs[_0x90cb('0x48')](_0x2f807d[_0x90cb('0x37')][_0x90cb('0x48')]));_0x365f0d[_0x90cb('0x3b')]=_0x365f0d['attributes']['length']?_0x365f0d['attributes']:_0x478e59[_0x90cb('0x36')];_0x365f0d[_0x90cb('0x3f')]=qs['sort'](_0x2f807d[_0x90cb('0x37')][_0x90cb('0x40')]);_0x365f0d[_0x90cb('0x44')]=qs['filters'](_[_0x90cb('0x58')](_0x2f807d['query'],_0x478e59[_0x90cb('0x39')]));_0x365f0d[_0x90cb('0x44')]=_[_0x90cb('0x42')](_0x365f0d[_0x90cb('0x44')],{'$or':[{'ListId':_0x213106['id']},{'ListId':null}]});if(_0x2f807d['query'][_0x90cb('0x41')]){_0x365f0d[_0x90cb('0x44')]=_[_0x90cb('0x42')](_0x365f0d['where'],{'$or':_[_0x90cb('0x31')](_0x365f0d['attributes'],function(_0xea845a){var _0x4d0c7a={};_0x4d0c7a[_0xea845a]={'$like':'%'+_0x2f807d[_0x90cb('0x37')][_0x90cb('0x41')]+'%'};return _0x4d0c7a;})});}_0x365f0d=_['merge']({},_0x365f0d,_0x2f807d[_0x90cb('0x43')]);return db[_0x90cb('0x70')][_0x90cb('0x9a')](_0x365f0d);}})[_0x90cb('0x27')](respondWithResult(_0x3c7bd7,null))[_0x90cb('0x4a')](handleError(_0x3c7bd7,null));};exports[_0x90cb('0x9b')]=function(_0x38baaa,_0x2dc7c8){return db[_0x90cb('0x70')][_0x90cb('0x9a')]({'where':{'ListId':null}})[_0x90cb('0x27')](handleEntityNotFound(_0x2dc7c8,null))[_0x90cb('0x27')](function(_0x4bc634){return _0x4bc634;})[_0x90cb('0x27')](respondWithResult(_0x2dc7c8,null))[_0x90cb('0x4a')](handleError(_0x2dc7c8,null));};exports[_0x90cb('0x9c')]=function(_0x27cec9,_0x187972,_0x15b231){return db[_0x90cb('0x32')][_0x90cb('0x49')]({'where':{'id':_0x27cec9[_0x90cb('0x47')]['id']}})['then'](handleEntityNotFound(_0x187972,null))['then'](function(_0x16022c){if(_0x16022c){return _0x16022c['addAgents'](_0x27cec9[_0x90cb('0x4c')]['ids'],_[_0x90cb('0x9d')](_0x27cec9[_0x90cb('0x4c')],[_0x90cb('0x5b'),'id'])||{})[_0x90cb('0x9e')](function(_0x3114d2){for(var _0x321942=0x0;_0x321942<_0x27cec9[_0x90cb('0x4c')][_0x90cb('0x5b')]['length'];_0x321942+=0x1){socket['emit'](_0x90cb('0x9f'),{'UserId':Number(_0x27cec9[_0x90cb('0x4c')][_0x90cb('0x5b')][_0x321942]),'CmListId':Number(_0x27cec9[_0x90cb('0x47')]['id'])});}return _0x3114d2;});}})[_0x90cb('0x27')](respondWithResult(_0x187972,null))['catch'](handleError(_0x187972,null));};exports[_0x90cb('0xa0')]=function(_0x18ec10,_0x1b2eb7,_0x12bbbe){return db[_0x90cb('0x32')][_0x90cb('0x49')]({'where':{'id':_0x18ec10[_0x90cb('0x47')]['id']}})[_0x90cb('0x27')](handleEntityNotFound(_0x1b2eb7,null))['then'](function(_0x43159e){if(_0x43159e){return _0x43159e[_0x90cb('0xa0')](_0x18ec10[_0x90cb('0x37')][_0x90cb('0x5b')])[_0x90cb('0x27')](function(){if(_[_0x90cb('0xa1')](_0x18ec10[_0x90cb('0x37')][_0x90cb('0x5b')])){for(var _0xf93758=0x0;_0xf93758<_0x18ec10[_0x90cb('0x37')][_0x90cb('0x5b')][_0x90cb('0x3c')];_0xf93758+=0x1){socket['emit'](_0x90cb('0xa2'),{'UserId':Number(_0x18ec10['query'][_0x90cb('0x5b')][_0xf93758]),'CmListId':Number(_0x18ec10['params']['id'])});}}else{socket[_0x90cb('0xa3')](_0x90cb('0xa2'),{'UserId':Number(_0x18ec10['query'][_0x90cb('0x5b')]),'CmListId':Number(_0x18ec10[_0x90cb('0x47')]['id'])});}});}})[_0x90cb('0x27')](respondWithStatusCode(_0x1b2eb7,null))[_0x90cb('0x4a')](handleError(_0x1b2eb7,null));};exports[_0x90cb('0xa4')]=function(_0x317078,_0x37b902,_0x8485c4){var _0x205404={};var _0x581c03={};var _0x59a2f6;var _0x15105a;return db[_0x90cb('0x32')]['findOne']({'where':{'id':_0x317078[_0x90cb('0x47')]['id']}})[_0x90cb('0x27')](handleEntityNotFound(_0x37b902,null))['then'](function(_0x3c6ff6){if(_0x3c6ff6){_0x59a2f6=_0x3c6ff6;_0x581c03[_0x90cb('0x36')]=_['keys'](db[_0x90cb('0xa5')][_0x90cb('0x33')]);_0x581c03['query']=_[_0x90cb('0x38')](_0x317078[_0x90cb('0x37')]);_0x581c03[_0x90cb('0x39')]=_['intersection'](_0x581c03['model'],_0x581c03[_0x90cb('0x37')]);_0x205404[_0x90cb('0x3b')]=_[_0x90cb('0x3a')](_0x581c03[_0x90cb('0x36')],qs['fields'](_0x317078[_0x90cb('0x37')]['fields']));_0x205404[_0x90cb('0x3b')]=_0x205404[_0x90cb('0x3b')][_0x90cb('0x3c')]?_0x205404['attributes']:_0x581c03['model'];_0x205404[_0x90cb('0x3f')]=qs[_0x90cb('0x40')](_0x317078[_0x90cb('0x37')][_0x90cb('0x40')]);_0x205404[_0x90cb('0x44')]=qs[_0x90cb('0x39')](_[_0x90cb('0x58')](_0x317078['query'],_0x581c03[_0x90cb('0x39')]));if(_0x317078[_0x90cb('0x37')][_0x90cb('0x41')]){_0x205404[_0x90cb('0x44')]=_['merge'](_0x205404[_0x90cb('0x44')],{'$or':_[_0x90cb('0x31')](_0x205404[_0x90cb('0x3b')],function(_0x3221e4){var _0x2fdf0b={};_0x2fdf0b[_0x3221e4]={'$like':'%'+_0x317078[_0x90cb('0x37')]['filter']+'%'};return _0x2fdf0b;})});}_0x205404=_['merge']({},_0x205404,_0x317078[_0x90cb('0x43')]);return _0x59a2f6[_0x90cb('0xa4')](_0x205404);}})[_0x90cb('0x27')](function(_0x50d5d8){if(_0x50d5d8){_0x15105a=_0x50d5d8[_0x90cb('0x3c')];if(!_0x317078[_0x90cb('0x37')][_0x90cb('0x3d')](_0x90cb('0x3e'))){_0x205404[_0x90cb('0x20')]=qs[_0x90cb('0x20')](_0x317078['query'][_0x90cb('0x20')]);_0x205404[_0x90cb('0x1e')]=qs[_0x90cb('0x1e')](_0x317078['query'][_0x90cb('0x1e')]);}return _0x59a2f6[_0x90cb('0xa4')](_0x205404);}})[_0x90cb('0x27')](function(_0x41171e){if(_0x41171e){return _0x41171e?{'count':_0x15105a,'rows':_0x41171e}:null;}})[_0x90cb('0x27')](respondWithResult(_0x37b902,null))['catch'](handleError(_0x37b902,null));};function handleQuery(_0x443766){logger[_0x90cb('0xa6')](_0x443766);return db[_0x90cb('0x8d')][_0x90cb('0x37')](_0x443766)[_0x90cb('0x9e')](function(_0x2cb580){csv_results[_0x90cb('0x61')](_0x2cb580);})[_0x90cb('0x4a')](function(_0x133f43){logger[_0x90cb('0x2c')](_0x133f43[_0x90cb('0x66')]);});}
\ No newline at end of file