Built motion from commit a679711e.|2.6.15
[motion2.git] / server / api / cmList / cmList.controller.js
index 8732979..06ea9f4 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x30d5=['findAll','catch','show','rawAttributes','find','create','body','role','Lists','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','describe','addDisposition','Disposition','getDispositions','findOne','ListId','includeAll','rows','removeDispositions','addContacts','CmContact','tags','isArray','join','push','omit','ids','success','dataValues','errors','message','Malformed\x20request\x20syntax','getContacts','CmCustomField','CustomFields','concat','format','cf_%d','raw','ContactItemType','alias','from','cm_contacts','c.ListId\x20=\x20?','c.deletedAt\x20is\x20null','distinct','field','customField_','item','cm_contact_has_items','ItemTypeId\x20=\x20?','CmContactId\x20=\x20c.id','select','description','description_additionalPhone_','toString','each','isEmpty','now','writeFileSync','/tmp/list_%d_%s.csv','setHeader','Content-disposition','attachment;\x20filename=','download','sequelize','addCustomFields','Sequelize','TEXT','text','number','INTEGER','switch','BOOLEAN','defaultValue','queryInterface','addColumn','cf_%s','getCustomFields','findAndCountAll','getGlobalCustomFields','addAgents','spread','emit','userCmList:save','removeAgents','userCmList:remove','getAgents','User','info','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','crypto','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','localhost','./cmList.socket','register','sendStatus','status','end','json','undefined','limit','count','offset','set','Content-Range','apply','save','then','get','UserProfileResource','destroy','error','stack','name','send','index','fieldName','type','model','keys','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','map','VIRTUAL','options','CmList','include'];(function(_0x3f7ebc,_0x291344){var _0x319c10=function(_0x1227ad){while(--_0x1227ad){_0x3f7ebc['push'](_0x3f7ebc['shift']());}};_0x319c10(++_0x291344);}(_0x30d5,0x1ae));var _0x530d=function(_0x321bb2,_0x202794){_0x321bb2=_0x321bb2-0x0;var _0x9c12ed=_0x30d5[_0x321bb2];return _0x9c12ed;};'use strict';var emlformat=require(_0x530d('0x0'));var rimraf=require(_0x530d('0x1'));var zipdir=require(_0x530d('0x2'));var jsonpatch=require(_0x530d('0x3'));var rp=require(_0x530d('0x4'));var moment=require(_0x530d('0x5'));var BPromise=require(_0x530d('0x6'));var Mustache=require(_0x530d('0x7'));var util=require(_0x530d('0x8'));var path=require(_0x530d('0x9'));var sox=require(_0x530d('0xa'));var csv=require(_0x530d('0xb'));var ejs=require(_0x530d('0xc'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require('lodash');var squel=require('squel');var crypto=require(_0x530d('0xd'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x530d('0xb'));var querystring=require(_0x530d('0xe'));var Papa=require(_0x530d('0xf'));var Redis=require('ioredis');var authService=require(_0x530d('0x10'));var qs=require(_0x530d('0x11'));var as=require(_0x530d('0x12'));var hardwareService=require(_0x530d('0x13'));var logger=require(_0x530d('0x14'))(_0x530d('0x15'));var utils=require('../../config/utils');var config=require(_0x530d('0x16'));var licenseUtil=require(_0x530d('0x17'));var db=require(_0x530d('0x18'))['db'];var csv_results;config[_0x530d('0x19')]=_[_0x530d('0x1a')](config[_0x530d('0x19')],{'host':_0x530d('0x1b'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config['redis']));require(_0x530d('0x1c'))[_0x530d('0x1d')](socket);function respondWithStatusCode(_0x5b0cdc,_0x482e7b){_0x482e7b=_0x482e7b||0xcc;return function(_0x1f28f4){if(_0x1f28f4){return _0x5b0cdc[_0x530d('0x1e')](_0x482e7b);}return _0x5b0cdc[_0x530d('0x1f')](_0x482e7b)[_0x530d('0x20')]();};}function respondWithResult(_0x21c7d8,_0x612ae4){_0x612ae4=_0x612ae4||0xc8;return function(_0x5eb442){if(_0x5eb442){return _0x21c7d8[_0x530d('0x1f')](_0x612ae4)[_0x530d('0x21')](_0x5eb442);}};}function respondWithFilteredResult(_0x35118e,_0x510d4d){return function(_0x444e46){if(_0x444e46){var _0x3a69f4=typeof _0x510d4d['offset']===_0x530d('0x22')&&typeof _0x510d4d[_0x530d('0x23')]===_0x530d('0x22');var _0x2ccab8=_0x444e46[_0x530d('0x24')];var _0x1411b0=_0x3a69f4?0x0:_0x510d4d[_0x530d('0x25')];var _0x19e63e=_0x3a69f4?_0x444e46[_0x530d('0x24')]:_0x510d4d[_0x530d('0x25')]+_0x510d4d[_0x530d('0x23')];var _0x3b9d15;if(_0x19e63e>=_0x2ccab8){_0x19e63e=_0x2ccab8;_0x3b9d15=0xc8;}else{_0x3b9d15=0xce;}_0x35118e[_0x530d('0x1f')](_0x3b9d15);return _0x35118e[_0x530d('0x26')](_0x530d('0x27'),_0x1411b0+'-'+_0x19e63e+'/'+_0x2ccab8)[_0x530d('0x21')](_0x444e46);}return null;};}function patchUpdates(_0x1d947e){return function(_0x263037){try{jsonpatch[_0x530d('0x28')](_0x263037,_0x1d947e,!![]);}catch(_0x39a2b0){return BPromise['reject'](_0x39a2b0);}return _0x263037[_0x530d('0x29')]();};}function saveUpdates(_0x4be33b,_0x3e94a5){return function(_0x3cf582){if(_0x3cf582){return _0x3cf582['update'](_0x4be33b)[_0x530d('0x2a')](function(_0x30912d){return _0x30912d;});}return null;};}function removeEntity(_0xa41ad0,_0x40c049){return function(_0x4021cd){if(_0x4021cd){return _0x4021cd['destroy']()['then'](function(){var _0x81594e=_0x4021cd[_0x530d('0x2b')]({'plain':!![]});var _0x115e98='Lists';return db[_0x530d('0x2c')][_0x530d('0x2d')]({'where':{'type':_0x115e98,'resourceId':_0x81594e['id']}})['then'](function(){return _0x4021cd;});})[_0x530d('0x2a')](function(){_0xa41ad0[_0x530d('0x1f')](0xcc)[_0x530d('0x20')]();});}};}function handleEntityNotFound(_0x48dc4e,_0x1ff5a4){return function(_0x3d2657){if(!_0x3d2657){_0x48dc4e[_0x530d('0x1e')](0x194);}return _0x3d2657;};}function handleError(_0x31627e,_0x49bc63){_0x49bc63=_0x49bc63||0x1f4;return function(_0xf59f7){logger[_0x530d('0x2e')](_0xf59f7[_0x530d('0x2f')]);if(_0xf59f7[_0x530d('0x30')]){delete _0xf59f7['name'];}_0x31627e[_0x530d('0x1f')](_0x49bc63)[_0x530d('0x31')](_0xf59f7);};}exports[_0x530d('0x32')]=function(_0xc1381c,_0x5010a4){var _0x284b0f={},_0x235d67={},_0x2addba={'count':0x0,'rows':[]};var _0x36f656=_['map'](db['CmList']['rawAttributes'],function(_0x2ea090){return{'name':_0x2ea090[_0x530d('0x33')],'type':_0x2ea090[_0x530d('0x34')]['key']};});_0x235d67[_0x530d('0x35')]=_['map'](_0x36f656,_0x530d('0x30'));_0x235d67['query']=_[_0x530d('0x36')](_0xc1381c[_0x530d('0x37')]);_0x235d67[_0x530d('0x38')]=_[_0x530d('0x39')](_0x235d67[_0x530d('0x35')],_0x235d67[_0x530d('0x37')]);_0x284b0f[_0x530d('0x3a')]=_[_0x530d('0x39')](_0x235d67[_0x530d('0x35')],qs[_0x530d('0x3b')](_0xc1381c[_0x530d('0x37')][_0x530d('0x3b')]));_0x284b0f[_0x530d('0x3a')]=_0x284b0f[_0x530d('0x3a')][_0x530d('0x3c')]?_0x284b0f[_0x530d('0x3a')]:_0x235d67['model'];if(!_0xc1381c[_0x530d('0x37')][_0x530d('0x3d')](_0x530d('0x3e'))){_0x284b0f[_0x530d('0x23')]=qs[_0x530d('0x23')](_0xc1381c[_0x530d('0x37')][_0x530d('0x23')]);_0x284b0f[_0x530d('0x25')]=qs[_0x530d('0x25')](_0xc1381c[_0x530d('0x37')]['offset']);}_0x284b0f[_0x530d('0x3f')]=qs[_0x530d('0x40')](_0xc1381c[_0x530d('0x37')][_0x530d('0x40')]);_0x284b0f[_0x530d('0x41')]=qs[_0x530d('0x38')](_[_0x530d('0x42')](_0xc1381c[_0x530d('0x37')],_0x235d67['filters']),_0x36f656);if(_0xc1381c[_0x530d('0x37')][_0x530d('0x43')]){_0x284b0f['where']=_[_0x530d('0x44')](_0x284b0f[_0x530d('0x41')],{'$or':_[_0x530d('0x45')](_0x36f656,function(_0x59fd4f){if(_0x59fd4f[_0x530d('0x34')]!==_0x530d('0x46')){var _0x3bd534={};_0x3bd534[_0x59fd4f['name']]={'$like':'%'+_0xc1381c[_0x530d('0x37')][_0x530d('0x43')]+'%'};return _0x3bd534;}})});}_0x284b0f=_[_0x530d('0x44')]({},_0x284b0f,_0xc1381c[_0x530d('0x47')]);var _0xcef6bd={'where':_0x284b0f[_0x530d('0x41')]};return db[_0x530d('0x48')]['count'](_0xcef6bd)[_0x530d('0x2a')](function(_0x537590){_0x2addba[_0x530d('0x24')]=_0x537590;if(_0xc1381c[_0x530d('0x37')]['includeAll']){_0x284b0f[_0x530d('0x49')]=[{'all':!![]}];}return db[_0x530d('0x48')][_0x530d('0x4a')](_0x284b0f);})['then'](function(_0x25caac){_0x2addba['rows']=_0x25caac;return _0x2addba;})[_0x530d('0x2a')](respondWithFilteredResult(_0x5010a4,_0x284b0f))[_0x530d('0x4b')](handleError(_0x5010a4,null));};exports[_0x530d('0x4c')]=function(_0x2e592f,_0x123898){var _0x4e39ea={'raw':![],'where':{'id':_0x2e592f['params']['id']}},_0x39fecb={};_0x39fecb[_0x530d('0x35')]=_[_0x530d('0x36')](db['CmList'][_0x530d('0x4d')]);_0x39fecb[_0x530d('0x37')]=_[_0x530d('0x36')](_0x2e592f[_0x530d('0x37')]);_0x39fecb[_0x530d('0x38')]=_[_0x530d('0x39')](_0x39fecb[_0x530d('0x35')],_0x39fecb[_0x530d('0x37')]);_0x4e39ea['attributes']=_[_0x530d('0x39')](_0x39fecb[_0x530d('0x35')],qs['fields'](_0x2e592f[_0x530d('0x37')][_0x530d('0x3b')]));_0x4e39ea['attributes']=_0x4e39ea['attributes']['length']?_0x4e39ea[_0x530d('0x3a')]:_0x39fecb[_0x530d('0x35')];if(_0x2e592f[_0x530d('0x37')]['includeAll']){_0x4e39ea[_0x530d('0x49')]=[{'all':!![]}];}_0x4e39ea=_[_0x530d('0x44')]({},_0x4e39ea,_0x2e592f[_0x530d('0x47')]);return db[_0x530d('0x48')][_0x530d('0x4e')](_0x4e39ea)[_0x530d('0x2a')](handleEntityNotFound(_0x123898,null))[_0x530d('0x2a')](respondWithResult(_0x123898,null))['catch'](handleError(_0x123898,null));};exports[_0x530d('0x4f')]=function(_0x2b7fad,_0x36bc27){return db[_0x530d('0x48')][_0x530d('0x4f')](_0x2b7fad[_0x530d('0x50')],{})[_0x530d('0x2a')](function(_0x15bdb3){var _0x2542cb=_0x2b7fad['user'][_0x530d('0x2b')]({'plain':!![]});if(!_0x2542cb)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x2542cb[_0x530d('0x51')]==='user'){var _0x2245b0=_0x15bdb3[_0x530d('0x2b')]({'plain':!![]});var _0x11ad43=_0x530d('0x52');return db[_0x530d('0x53')]['find']({'where':{'name':_0x11ad43,'userProfileId':_0x2542cb[_0x530d('0x54')]},'raw':!![]})[_0x530d('0x2a')](function(_0x5b7622){if(_0x5b7622&&_0x5b7622[_0x530d('0x55')]===0x0){return db[_0x530d('0x2c')]['create']({'name':_0x2245b0['name'],'resourceId':_0x2245b0['id'],'type':_0x5b7622['name'],'sectionId':_0x5b7622['id']},{})['then'](function(){return _0x15bdb3;});}else{return _0x15bdb3;}})[_0x530d('0x4b')](function(_0x30eb4f){logger[_0x530d('0x2e')](_0x530d('0x56'),_0x30eb4f);throw _0x30eb4f;});}return _0x15bdb3;})[_0x530d('0x2a')](respondWithResult(_0x36bc27,0xc9))['catch'](handleError(_0x36bc27,null));};exports['update']=function(_0x3c97f1,_0x516d83){if(_0x3c97f1[_0x530d('0x50')]['id']){delete _0x3c97f1[_0x530d('0x50')]['id'];}return db[_0x530d('0x48')][_0x530d('0x4e')]({'where':{'id':_0x3c97f1[_0x530d('0x57')]['id']}})[_0x530d('0x2a')](handleEntityNotFound(_0x516d83,null))['then'](saveUpdates(_0x3c97f1[_0x530d('0x50')],null))[_0x530d('0x2a')](respondWithResult(_0x516d83,null))[_0x530d('0x4b')](handleError(_0x516d83,null));};exports[_0x530d('0x2d')]=function(_0x39d5f5,_0x31af73){return db[_0x530d('0x48')][_0x530d('0x4e')]({'where':{'id':_0x39d5f5[_0x530d('0x57')]['id']}})[_0x530d('0x2a')](handleEntityNotFound(_0x31af73,null))[_0x530d('0x2a')](removeEntity(_0x31af73,null))[_0x530d('0x4b')](handleError(_0x31af73,null));};exports['describe']=function(_0x2edf9e,_0x44335){return db[_0x530d('0x48')][_0x530d('0x58')]()['then'](respondWithResult(_0x44335,null))[_0x530d('0x4b')](handleError(_0x44335,null));};exports[_0x530d('0x59')]=function(_0x20b2dd,_0x1a2bb5,_0x4f2757){if(_0x20b2dd['body']['id']){delete _0x20b2dd[_0x530d('0x50')]['id'];}return db[_0x530d('0x48')]['find']({'where':{'id':_0x20b2dd[_0x530d('0x57')]['id']}})[_0x530d('0x2a')](handleEntityNotFound(_0x1a2bb5,null))[_0x530d('0x2a')](function(_0x4e5d6e){if(_0x4e5d6e){_0x20b2dd[_0x530d('0x50')]['ListId']=_0x4e5d6e['id'];return db[_0x530d('0x5a')][_0x530d('0x4f')](_0x20b2dd[_0x530d('0x50')]);}})[_0x530d('0x2a')](respondWithResult(_0x1a2bb5,null))[_0x530d('0x4b')](handleError(_0x1a2bb5,null));};exports[_0x530d('0x5b')]=function(_0x27ad78,_0x5a6c06,_0x5edf18){var _0x57452c={'raw':![],'where':{}};var _0x481964={};var _0x3bd70e={'count':0x0,'rows':[]};return db[_0x530d('0x48')][_0x530d('0x5c')]({'where':{'id':_0x27ad78[_0x530d('0x57')]['id']}})[_0x530d('0x2a')](handleEntityNotFound(_0x5a6c06,null))[_0x530d('0x2a')](function(_0x40039a){if(_0x40039a){_0x481964[_0x530d('0x35')]=_[_0x530d('0x36')](db['Disposition'][_0x530d('0x4d')]);_0x481964[_0x530d('0x37')]=_['keys'](_0x27ad78[_0x530d('0x37')]);_0x481964[_0x530d('0x38')]=_[_0x530d('0x39')](_0x481964[_0x530d('0x35')],_0x481964[_0x530d('0x37')]);_0x57452c[_0x530d('0x3a')]=_['intersection'](_0x481964[_0x530d('0x35')],qs[_0x530d('0x3b')](_0x27ad78['query'][_0x530d('0x3b')]));_0x57452c[_0x530d('0x3a')]=_0x57452c[_0x530d('0x3a')]['length']?_0x57452c[_0x530d('0x3a')]:_0x481964['model'];if(!_0x27ad78[_0x530d('0x37')][_0x530d('0x3d')](_0x530d('0x3e'))){_0x57452c[_0x530d('0x23')]=qs[_0x530d('0x23')](_0x27ad78[_0x530d('0x37')][_0x530d('0x23')]);_0x57452c[_0x530d('0x25')]=qs[_0x530d('0x25')](_0x27ad78[_0x530d('0x37')]['offset']);}_0x57452c[_0x530d('0x3f')]=qs[_0x530d('0x40')](_0x27ad78[_0x530d('0x37')]['sort']);_0x57452c['where']=qs[_0x530d('0x38')](_[_0x530d('0x42')](_0x27ad78['query'],_0x481964['filters']));_0x57452c[_0x530d('0x41')][_0x530d('0x5d')]=_0x40039a['id'];if(_0x27ad78[_0x530d('0x37')][_0x530d('0x43')]){_0x57452c[_0x530d('0x41')]=_[_0x530d('0x44')](_0x57452c[_0x530d('0x41')],{'$or':_[_0x530d('0x45')](_0x57452c[_0x530d('0x3a')],function(_0x2e646a){var _0x2ed014={};_0x2ed014[_0x2e646a]={'$like':'%'+_0x27ad78[_0x530d('0x37')][_0x530d('0x43')]+'%'};return _0x2ed014;})});}_0x57452c=_[_0x530d('0x44')]({},_0x57452c,_0x27ad78[_0x530d('0x47')]);return db[_0x530d('0x5a')]['count']({'where':_0x57452c[_0x530d('0x41')]})[_0x530d('0x2a')](function(_0x104a67){_0x3bd70e['count']=_0x104a67;if(_0x27ad78[_0x530d('0x37')][_0x530d('0x5e')]){_0x57452c[_0x530d('0x49')]=[{'all':!![]}];}return db['Disposition'][_0x530d('0x4a')](_0x57452c);})[_0x530d('0x2a')](function(_0x2cf605){_0x3bd70e[_0x530d('0x5f')]=_0x2cf605;return _0x3bd70e;});}})[_0x530d('0x2a')](respondWithFilteredResult(_0x5a6c06,_0x57452c))[_0x530d('0x4b')](handleError(_0x5a6c06,null));};exports['removeDispositions']=function(_0x326951,_0x4a6024,_0x483982){return db[_0x530d('0x48')][_0x530d('0x4e')]({'where':{'id':_0x326951[_0x530d('0x57')]['id']}})[_0x530d('0x2a')](handleEntityNotFound(_0x4a6024,null))[_0x530d('0x2a')](function(_0x3c4528){if(_0x3c4528){return _0x3c4528[_0x530d('0x60')](_0x326951[_0x530d('0x37')]['ids']);}})[_0x530d('0x2a')](respondWithStatusCode(_0x4a6024,null))['catch'](handleError(_0x4a6024,null));};exports[_0x530d('0x61')]=function(_0x395277,_0x5973c1,_0x3d5036){return db[_0x530d('0x48')][_0x530d('0x4e')]({'where':{'id':_0x395277[_0x530d('0x57')]['id']}})[_0x530d('0x2a')](handleEntityNotFound(_0x5973c1,null))[_0x530d('0x2a')](function(_0xb7cc2a){if(_0xb7cc2a){var _0x315f2e=[];var _0x2ba57b={'success':[],'errors':[]};return db[_0x530d('0x62')][_0x530d('0x58')]()[_0x530d('0x2a')](function(_0x50a4e0){if(_0x395277['body'][_0x530d('0x63')]&&_[_0x530d('0x64')](_0x395277[_0x530d('0x50')][_0x530d('0x63')])){if(_0x395277[_0x530d('0x50')][_0x530d('0x63')][_0x530d('0x3c')]){_0x395277[_0x530d('0x50')][_0x530d('0x63')]=_0x395277[_0x530d('0x50')]['tags'][_0x530d('0x65')](';')+';';}else{_0x395277[_0x530d('0x50')][_0x530d('0x63')]=null;}}else{_0x395277[_0x530d('0x50')][_0x530d('0x63')]=null;}if(_0x395277[_0x530d('0x50')]&&_['isArray'](_0x395277[_0x530d('0x50')])){for(var _0x51475c=0x0;_0x51475c<_0x395277['body'][_0x530d('0x3c')];_0x51475c+=0x1){_0x395277[_0x530d('0x50')][_0x51475c][_0x530d('0x5d')]=_0x395277[_0x530d('0x57')]['id'];_0x315f2e[_0x530d('0x66')](_0x395277[_0x530d('0x50')][_0x51475c]);}return BPromise['each'](_0x315f2e,function(_0x2e9e6e){return db[_0x530d('0x62')][_0x530d('0x4f')](_[_0x530d('0x67')](_0x2e9e6e,[_0x530d('0x68'),'id'])||{},{'fields':_[_0x530d('0x36')](_0x50a4e0),'raw':!![]})[_0x530d('0x2a')](function(_0xb52a0d){_0x2ba57b[_0x530d('0x69')][_0x530d('0x66')](_0xb52a0d[_0x530d('0x6a')]);})[_0x530d('0x4b')](function(_0x1a849c){_0x2ba57b[_0x530d('0x6b')]['push']({'data':_0x2e9e6e,'error':_0x1a849c[_0x530d('0x6c')]});});})[_0x530d('0x2a')](function(_0x5d4b92){return _0x2ba57b;})[_0x530d('0x4b')](function(_0x26c00b){return _0x26c00b;});}else{_0x5973c1[_0x530d('0x1f')](0x190)['json']({'message':_0x530d('0x6d')});}});}})[_0x530d('0x2a')](respondWithResult(_0x5973c1,null))[_0x530d('0x4b')](handleError(_0x5973c1,null));};exports[_0x530d('0x6e')]=function(_0x17385d,_0x1f6fe5,_0x519dcc){var _0x508ef3;return db['CmList'][_0x530d('0x4e')]({'where':{'id':_0x17385d[_0x530d('0x57')]['id']},'include':[{'model':db[_0x530d('0x6f')],'as':_0x530d('0x70')}]})[_0x530d('0x2a')](handleEntityNotFound(_0x1f6fe5,null))[_0x530d('0x2a')](function(_0x3474f1){if(_0x3474f1){_0x508ef3=_0x3474f1;return db[_0x530d('0x62')]['rawAttributes'];}})[_0x530d('0x2a')](function(_0x292886){if(_0x292886){var _0xf98b5={};var _0x395773={};_0x395773[_0x530d('0x35')]=_[_0x530d('0x71')](_[_0x530d('0x36')](_0x292886),_[_0x530d('0x45')](_0x508ef3[_0x530d('0x70')],function(_0x360fd2){return util[_0x530d('0x72')](_0x530d('0x73'),_0x360fd2['id']);}));_0x395773[_0x530d('0x37')]=_[_0x530d('0x36')](_0x17385d[_0x530d('0x37')]);_0x395773[_0x530d('0x38')]=_['intersection'](_0x395773['model'],_0x395773[_0x530d('0x37')]);_0xf98b5[_0x530d('0x3a')]=_[_0x530d('0x39')](_0x395773['model'],qs[_0x530d('0x3b')](_0x17385d[_0x530d('0x37')][_0x530d('0x3b')]));_0xf98b5['attributes']=_0xf98b5['attributes'][_0x530d('0x3c')]?_0xf98b5[_0x530d('0x3a')]:_0x395773[_0x530d('0x35')];if(!_0x17385d[_0x530d('0x37')][_0x530d('0x3d')](_0x530d('0x3e'))){_0xf98b5[_0x530d('0x23')]=qs[_0x530d('0x23')](_0x17385d[_0x530d('0x37')][_0x530d('0x23')]);_0xf98b5[_0x530d('0x25')]=qs[_0x530d('0x25')](_0x17385d['query'][_0x530d('0x25')]);}_0xf98b5[_0x530d('0x3f')]=qs[_0x530d('0x40')](_0x17385d['query'][_0x530d('0x40')]);_0xf98b5[_0x530d('0x41')]=qs['filters'](_[_0x530d('0x42')](_0x17385d['query'],_0x395773[_0x530d('0x38')]));_0xf98b5[_0x530d('0x74')]=!![];if(_0x17385d[_0x530d('0x37')]['filter']){_0xf98b5[_0x530d('0x41')]=_['merge'](_0xf98b5[_0x530d('0x41')],{'$or':_[_0x530d('0x45')](_0xf98b5[_0x530d('0x3a')],function(_0x4ef072){var _0xe6f262={};_0xe6f262[_0x4ef072]={'$like':'%'+_0x17385d[_0x530d('0x37')][_0x530d('0x43')]+'%'};return _0xe6f262;})});}_0xf98b5=_[_0x530d('0x44')]({},_0xf98b5,_0x17385d[_0x530d('0x47')]);return _0x508ef3[_0x530d('0x6e')](_0xf98b5);}})[_0x530d('0x2a')](respondWithResult(_0x1f6fe5,null))['catch'](handleError(_0x1f6fe5,null));};exports['getContactsCsv']=function(_0x1517e8,_0x1ce305,_0x1ec043){var _0x5d3666;var _0x3608d9;var _0x12391a;var _0x2ad29d=_0x1517e8[_0x530d('0x57')]['id'];csv_results=[];return db[_0x530d('0x75')][_0x530d('0x4a')]({'attributes':['id','name'],'raw':!![],'order':['OrderBy']})[_0x530d('0x2a')](function(_0x561fd5){_0x5d3666=_0x561fd5;var _0x5b1bf2=_[_0x530d('0x36')](db[_0x530d('0x62')]['rawAttributes']);return db[_0x530d('0x6f')][_0x530d('0x4a')]({'raw':!![],'attributes':['id',_0x530d('0x76')]})['then'](function(_0x102181){_0x3608d9=_0x102181;var _0x2237f3=squel['select']()[_0x530d('0x3b')](_0x5b1bf2)[_0x530d('0x77')](_0x530d('0x78'),'c')[_0x530d('0x41')](_0x530d('0x79'),_0x2ad29d)[_0x530d('0x41')](_0x530d('0x7a'))[_0x530d('0x7b')]();for(var _0x43849c=0x0;_0x43849c<_0x3608d9[_0x530d('0x3c')];_0x43849c++){_0x2237f3[_0x530d('0x7c')]('c.cf_'+_0x3608d9[_0x43849c]['id'],_0x530d('0x7d')+_0x3608d9[_0x43849c][_0x530d('0x76')]);}for(var _0x43849c=0x0;_0x43849c<_0x5d3666[_0x530d('0x3c')];_0x43849c++){_0x2237f3['field'](squel['select']()['field'](_0x530d('0x7e'))[_0x530d('0x77')](_0x530d('0x7f'))[_0x530d('0x41')](_0x530d('0x80'),_0x5d3666[_0x43849c]['id'])['where'](_0x530d('0x81')),'additionalPhone_'+_0x5d3666[_0x43849c][_0x530d('0x30')]);_0x2237f3[_0x530d('0x7c')](squel[_0x530d('0x82')]()[_0x530d('0x7c')](_0x530d('0x83'))[_0x530d('0x77')](_0x530d('0x7f'))[_0x530d('0x41')](_0x530d('0x80'),_0x5d3666[_0x43849c]['id'])[_0x530d('0x41')](_0x530d('0x81')),_0x530d('0x84')+_0x5d3666[_0x43849c][_0x530d('0x30')]);}var _0x568511=[];_0x568511[_0x530d('0x66')](_0x2237f3[_0x530d('0x85')]());BPromise[_0x530d('0x86')](_0x568511,handleQuery)[_0x530d('0x2a')](function(_0x1a4719){handleQuery(_0x2237f3[_0x530d('0x85')]());var _0x3a526a=csv_results[0x0];if(!_[_0x530d('0x87')](_0x3a526a)){var _0x340c3e=toCsv(_0x3a526a);var _0x2390fa=Date[_0x530d('0x88')]();fs[_0x530d('0x89')](util[_0x530d('0x72')](_0x530d('0x8a'),_0x2ad29d,_0x2390fa),_0x340c3e);_0x1ce305[_0x530d('0x8b')](_0x530d('0x8c'),_0x530d('0x8d')+util[_0x530d('0x72')]('list_%d_%s.csv',_0x2ad29d,_0x2390fa));_0x1ce305[_0x530d('0x8b')]('Content-type','text/csv');return _0x1ce305[_0x530d('0x8e')](util['format'](_0x530d('0x8a'),_0x2ad29d,_0x2390fa));}else{return _0x1ce305[_0x530d('0x1e')](0xcc);}});});});};exports['addCustomField']=function(_0x1c8e7f,_0x4e6efb,_0x5dc1af){var _0x3ea432;delete _0x1c8e7f[_0x530d('0x50')]['id'];return db[_0x530d('0x48')][_0x530d('0x5c')]({'where':{'id':_0x1c8e7f[_0x530d('0x57')]['id']}})[_0x530d('0x2a')](handleEntityNotFound(_0x4e6efb,null))['then'](function(_0x32285a){if(_0x32285a){return db[_0x530d('0x8f')]['transaction'](function(_0x1a43a0){return db['CmCustomField'][_0x530d('0x4f')](_0x1c8e7f['body'],{'transaction':_0x1a43a0})['then'](function(_0x442183){_0x3ea432=_0x442183;return _0x32285a[_0x530d('0x90')](_0x442183,{'transaction':_0x1a43a0});})[_0x530d('0x2a')](function(){var _0xb807f2={'type':db[_0x530d('0x91')][_0x530d('0x92')],'transaction':_0x1a43a0};switch(_0x1c8e7f[_0x530d('0x50')][_0x530d('0x34')]){case _0x530d('0x93'):_0xb807f2[_0x530d('0x34')]=db['Sequelize'][_0x530d('0x92')];break;case _0x530d('0x94'):_0xb807f2['type']=db['Sequelize'][_0x530d('0x95')];break;case _0x530d('0x96'):_0xb807f2[_0x530d('0x34')]=db['Sequelize'][_0x530d('0x97')];_0xb807f2[_0x530d('0x98')]=![];break;default:}return db[_0x530d('0x8f')][_0x530d('0x99')][_0x530d('0x9a')](_0x530d('0x78'),util['format'](_0x530d('0x9b'),_0x3ea432['id']),_0xb807f2);})[_0x530d('0x2a')](function(){return _0x3ea432;});});}})[_0x530d('0x2a')](respondWithResult(_0x4e6efb,null))[_0x530d('0x4b')](handleError(_0x4e6efb,null));};exports[_0x530d('0x9c')]=function(_0x34c257,_0x1bc8e9,_0x4ee12d){var _0x31dd82={};var _0x4e7728={};var _0x4b8253;var _0x1057e4;return db[_0x530d('0x48')][_0x530d('0x5c')]({'where':{'id':_0x34c257[_0x530d('0x57')]['id']}})[_0x530d('0x2a')](handleEntityNotFound(_0x1bc8e9,null))[_0x530d('0x2a')](function(_0x60cff){if(_0x60cff){_0x4b8253=_0x60cff;_0x4e7728[_0x530d('0x35')]=_[_0x530d('0x36')](db[_0x530d('0x6f')]['rawAttributes']);_0x4e7728[_0x530d('0x37')]=_[_0x530d('0x36')](_0x34c257[_0x530d('0x37')]);_0x4e7728[_0x530d('0x38')]=_[_0x530d('0x39')](_0x4e7728[_0x530d('0x35')],_0x4e7728['query']);_0x31dd82[_0x530d('0x3a')]=_[_0x530d('0x39')](_0x4e7728[_0x530d('0x35')],qs[_0x530d('0x3b')](_0x34c257[_0x530d('0x37')][_0x530d('0x3b')]));_0x31dd82[_0x530d('0x3a')]=_0x31dd82[_0x530d('0x3a')]['length']?_0x31dd82[_0x530d('0x3a')]:_0x4e7728['model'];_0x31dd82[_0x530d('0x3f')]=qs[_0x530d('0x40')](_0x34c257[_0x530d('0x37')][_0x530d('0x40')]);_0x31dd82[_0x530d('0x41')]=qs['filters'](_[_0x530d('0x42')](_0x34c257['query'],_0x4e7728['filters']));_0x31dd82[_0x530d('0x41')]=_[_0x530d('0x44')](_0x31dd82[_0x530d('0x41')],{'$or':[{'ListId':_0x60cff['id']},{'ListId':null}]});if(_0x34c257[_0x530d('0x37')]['filter']){_0x31dd82['where']=_[_0x530d('0x44')](_0x31dd82[_0x530d('0x41')],{'$or':_[_0x530d('0x45')](_0x31dd82['attributes'],function(_0x1977d6){var _0xe1ca00={};_0xe1ca00[_0x1977d6]={'$like':'%'+_0x34c257[_0x530d('0x37')]['filter']+'%'};return _0xe1ca00;})});}_0x31dd82=_['merge']({},_0x31dd82,_0x34c257[_0x530d('0x47')]);return db['CmCustomField'][_0x530d('0x9d')](_0x31dd82);}})['then'](respondWithResult(_0x1bc8e9,null))[_0x530d('0x4b')](handleError(_0x1bc8e9,null));};exports[_0x530d('0x9e')]=function(_0x11ba2c,_0x305aa3){return db[_0x530d('0x6f')][_0x530d('0x9d')]({'where':{'ListId':null}})[_0x530d('0x2a')](handleEntityNotFound(_0x305aa3,null))[_0x530d('0x2a')](function(_0x3e03a3){return _0x3e03a3;})[_0x530d('0x2a')](respondWithResult(_0x305aa3,null))[_0x530d('0x4b')](handleError(_0x305aa3,null));};exports[_0x530d('0x9f')]=function(_0x5cd9b5,_0x24d63f,_0x3fd6aa){return db[_0x530d('0x48')]['find']({'where':{'id':_0x5cd9b5[_0x530d('0x57')]['id']}})['then'](handleEntityNotFound(_0x24d63f,null))[_0x530d('0x2a')](function(_0x2509ab){if(_0x2509ab){return _0x2509ab[_0x530d('0x9f')](_0x5cd9b5[_0x530d('0x50')]['ids'],_[_0x530d('0x67')](_0x5cd9b5['body'],[_0x530d('0x68'),'id'])||{})[_0x530d('0xa0')](function(_0x72dead){for(var _0x18a7f1=0x0;_0x18a7f1<_0x5cd9b5[_0x530d('0x50')][_0x530d('0x68')][_0x530d('0x3c')];_0x18a7f1+=0x1){socket[_0x530d('0xa1')](_0x530d('0xa2'),{'UserId':Number(_0x5cd9b5[_0x530d('0x50')]['ids'][_0x18a7f1]),'CmListId':Number(_0x5cd9b5[_0x530d('0x57')]['id'])});}return _0x72dead;});}})['then'](respondWithResult(_0x24d63f,null))[_0x530d('0x4b')](handleError(_0x24d63f,null));};exports['removeAgents']=function(_0x410f1e,_0x1dedb6,_0x171e7c){return db[_0x530d('0x48')][_0x530d('0x4e')]({'where':{'id':_0x410f1e[_0x530d('0x57')]['id']}})[_0x530d('0x2a')](handleEntityNotFound(_0x1dedb6,null))[_0x530d('0x2a')](function(_0x2a6c9d){if(_0x2a6c9d){return _0x2a6c9d[_0x530d('0xa3')](_0x410f1e[_0x530d('0x37')]['ids'])[_0x530d('0x2a')](function(){if(_[_0x530d('0x64')](_0x410f1e[_0x530d('0x37')][_0x530d('0x68')])){for(var _0x53848b=0x0;_0x53848b<_0x410f1e['query']['ids']['length'];_0x53848b+=0x1){socket['emit'](_0x530d('0xa4'),{'UserId':Number(_0x410f1e[_0x530d('0x37')][_0x530d('0x68')][_0x53848b]),'CmListId':Number(_0x410f1e[_0x530d('0x57')]['id'])});}}else{socket['emit'](_0x530d('0xa4'),{'UserId':Number(_0x410f1e[_0x530d('0x37')][_0x530d('0x68')]),'CmListId':Number(_0x410f1e[_0x530d('0x57')]['id'])});}});}})[_0x530d('0x2a')](respondWithStatusCode(_0x1dedb6,null))['catch'](handleError(_0x1dedb6,null));};exports[_0x530d('0xa5')]=function(_0x13e4f8,_0xee6f0e,_0x146b35){var _0x98f5ee={};var _0x2d1146={};var _0x17a754;var _0x469d85;return db[_0x530d('0x48')][_0x530d('0x5c')]({'where':{'id':_0x13e4f8[_0x530d('0x57')]['id']}})[_0x530d('0x2a')](handleEntityNotFound(_0xee6f0e,null))[_0x530d('0x2a')](function(_0x25283b){if(_0x25283b){_0x17a754=_0x25283b;_0x2d1146[_0x530d('0x35')]=_[_0x530d('0x36')](db[_0x530d('0xa6')]['rawAttributes']);_0x2d1146[_0x530d('0x37')]=_[_0x530d('0x36')](_0x13e4f8[_0x530d('0x37')]);_0x2d1146[_0x530d('0x38')]=_[_0x530d('0x39')](_0x2d1146[_0x530d('0x35')],_0x2d1146[_0x530d('0x37')]);_0x98f5ee[_0x530d('0x3a')]=_[_0x530d('0x39')](_0x2d1146[_0x530d('0x35')],qs[_0x530d('0x3b')](_0x13e4f8[_0x530d('0x37')][_0x530d('0x3b')]));_0x98f5ee[_0x530d('0x3a')]=_0x98f5ee['attributes'][_0x530d('0x3c')]?_0x98f5ee[_0x530d('0x3a')]:_0x2d1146[_0x530d('0x35')];_0x98f5ee[_0x530d('0x3f')]=qs[_0x530d('0x40')](_0x13e4f8[_0x530d('0x37')][_0x530d('0x40')]);_0x98f5ee['where']=qs[_0x530d('0x38')](_['pick'](_0x13e4f8[_0x530d('0x37')],_0x2d1146[_0x530d('0x38')]));if(_0x13e4f8[_0x530d('0x37')][_0x530d('0x43')]){_0x98f5ee[_0x530d('0x41')]=_[_0x530d('0x44')](_0x98f5ee[_0x530d('0x41')],{'$or':_[_0x530d('0x45')](_0x98f5ee['attributes'],function(_0x17d05f){var _0x221abd={};_0x221abd[_0x17d05f]={'$like':'%'+_0x13e4f8[_0x530d('0x37')][_0x530d('0x43')]+'%'};return _0x221abd;})});}_0x98f5ee=_[_0x530d('0x44')]({},_0x98f5ee,_0x13e4f8['options']);return _0x17a754['getAgents'](_0x98f5ee);}})[_0x530d('0x2a')](function(_0xf48752){if(_0xf48752){_0x469d85=_0xf48752[_0x530d('0x3c')];if(!_0x13e4f8['query'][_0x530d('0x3d')](_0x530d('0x3e'))){_0x98f5ee[_0x530d('0x23')]=qs['limit'](_0x13e4f8[_0x530d('0x37')][_0x530d('0x23')]);_0x98f5ee[_0x530d('0x25')]=qs['offset'](_0x13e4f8[_0x530d('0x37')][_0x530d('0x25')]);}return _0x17a754[_0x530d('0xa5')](_0x98f5ee);}})['then'](function(_0x385615){if(_0x385615){return _0x385615?{'count':_0x469d85,'rows':_0x385615}:null;}})['then'](respondWithResult(_0xee6f0e,null))['catch'](handleError(_0xee6f0e,null));};function handleQuery(_0xe3555d){logger[_0x530d('0xa7')](_0xe3555d);return db[_0x530d('0x8f')][_0x530d('0x37')](_0xe3555d)[_0x530d('0xa0')](function(_0x11a091){csv_results[_0x530d('0x66')](_0x11a091);})[_0x530d('0x4b')](function(_0x53775e){logger[_0x530d('0x2e')](_0x53775e['message']);});}
\ 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