Built motion from commit a679711e.|2.6.15
[motion2.git] / server / api / cmList / cmList.controller.js
index a564d57..06ea9f4 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x0247=['fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/license/util','../../mysqldb','redis','localhost','socket.io-emitter','./cmList.socket','register','sendStatus','status','end','json','undefined','limit','count','offset','set','Content-Range','apply','reject','save','update','get','Lists','UserProfileResource','destroy','then','error','stack','send','index','map','rawAttributes','type','key','name','query','filters','intersection','attributes','model','fields','length','hasOwnProperty','nolimit','order','sort','pick','filter','where','VIRTUAL','includeAll','include','CmList','findAll','rows','catch','show','params','keys','merge','options','find','create','Unable\x20to\x20retrieve\x20the\x20current\x20user','user','UserProfileSection','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','describe','addDisposition','ListId','Disposition','getDispositions','findOne','removeDispositions','ids','addContacts','tags','isArray','CmContact','omit','success','push','errors','message','Malformed\x20request\x20syntax','getContacts','format','cf_%d','raw','getContactsCsv','ContactItemType','OrderBy','CmCustomField','alias','select','cm_contacts','c.ListId\x20=\x20?','distinct','field','item','from','cm_contact_has_items','ItemTypeId\x20=\x20?','CmContactId\x20=\x20c.id','additionalPhone_','description','description_additionalPhone_','toString','each','isEmpty','writeFileSync','/tmp/list_%d_%s.csv','setHeader','Content-disposition','attachment;\x20filename=','list_%d_%s.csv','Content-type','sequelize','transaction','addCustomFields','Sequelize','text','number','switch','defaultValue','queryInterface','addColumn','cf_%s','getCustomFields','findAndCountAll','addAgents','spread','emit','userCmList:save','removeAgents','userCmList:remove','getAgents','info','eml-format','rimraf','zip-dir'];(function(_0x42bd6c,_0xcd4c6e){var _0x4442ad=function(_0x151282){while(--_0x151282){_0x42bd6c['push'](_0x42bd6c['shift']());}};_0x4442ad(++_0xcd4c6e);}(_0x0247,0x147));var _0x7024=function(_0xa92bf7,_0x118280){_0xa92bf7=_0xa92bf7-0x0;var _0x42734d=_0x0247[_0xa92bf7];return _0x42734d;};'use strict';var emlformat=require(_0x7024('0x0'));var rimraf=require(_0x7024('0x1'));var zipdir=require(_0x7024('0x2'));var jsonpatch=require(_0x7024('0x3'));var rp=require(_0x7024('0x4'));var moment=require(_0x7024('0x5'));var BPromise=require(_0x7024('0x6'));var Mustache=require(_0x7024('0x7'));var util=require(_0x7024('0x8'));var path=require('path');var sox=require(_0x7024('0x9'));var csv=require(_0x7024('0xa'));var ejs=require(_0x7024('0xb'));var fs=require('fs');var fs_extra=require(_0x7024('0xc'));var _=require(_0x7024('0xd'));var squel=require(_0x7024('0xe'));var crypto=require(_0x7024('0xf'));var jsforce=require(_0x7024('0x10'));var deskjs=require(_0x7024('0x11'));var toCsv=require('to-csv');var querystring=require(_0x7024('0x12'));var Papa=require(_0x7024('0x13'));var Redis=require(_0x7024('0x14'));var authService=require(_0x7024('0x15'));var qs=require(_0x7024('0x16'));var as=require(_0x7024('0x17'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x7024('0x18'))(_0x7024('0x19'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0x7024('0x1a'));var db=require(_0x7024('0x1b'))['db'];var csv_results;config[_0x7024('0x1c')]=_['defaults'](config[_0x7024('0x1c')],{'host':_0x7024('0x1d'),'port':0x18eb});var socket=require(_0x7024('0x1e'))(new Redis(config[_0x7024('0x1c')]));require(_0x7024('0x1f'))[_0x7024('0x20')](socket);function respondWithStatusCode(_0x2c471b,_0x1273b5){_0x1273b5=_0x1273b5||0xcc;return function(_0x36a988){if(_0x36a988){return _0x2c471b[_0x7024('0x21')](_0x1273b5);}return _0x2c471b[_0x7024('0x22')](_0x1273b5)[_0x7024('0x23')]();};}function respondWithResult(_0xbaae6a,_0x1bc8e2){_0x1bc8e2=_0x1bc8e2||0xc8;return function(_0xeabd5e){if(_0xeabd5e){return _0xbaae6a['status'](_0x1bc8e2)[_0x7024('0x24')](_0xeabd5e);}};}function respondWithFilteredResult(_0x454546,_0x3da9c9){return function(_0x28b4ea){if(_0x28b4ea){var _0x2d0f62=typeof _0x3da9c9['offset']===_0x7024('0x25')&&typeof _0x3da9c9[_0x7024('0x26')]===_0x7024('0x25');var _0x2375a2=_0x28b4ea['count'];var _0x3dbe49=_0x2d0f62?0x0:_0x3da9c9['offset'];var _0x53e4bc=_0x2d0f62?_0x28b4ea[_0x7024('0x27')]:_0x3da9c9[_0x7024('0x28')]+_0x3da9c9[_0x7024('0x26')];var _0x420aed;if(_0x53e4bc>=_0x2375a2){_0x53e4bc=_0x2375a2;_0x420aed=0xc8;}else{_0x420aed=0xce;}_0x454546[_0x7024('0x22')](_0x420aed);return _0x454546[_0x7024('0x29')](_0x7024('0x2a'),_0x3dbe49+'-'+_0x53e4bc+'/'+_0x2375a2)[_0x7024('0x24')](_0x28b4ea);}return null;};}function patchUpdates(_0x55e9b6){return function(_0x59313f){try{jsonpatch[_0x7024('0x2b')](_0x59313f,_0x55e9b6,!![]);}catch(_0x2d853e){return BPromise[_0x7024('0x2c')](_0x2d853e);}return _0x59313f[_0x7024('0x2d')]();};}function saveUpdates(_0x38b91f,_0x1ce16e){return function(_0x1ac345){if(_0x1ac345){return _0x1ac345[_0x7024('0x2e')](_0x38b91f)['then'](function(_0x37a101){return _0x37a101;});}return null;};}function removeEntity(_0xd77fb0,_0x2b97fa){return function(_0x2edb1a){if(_0x2edb1a){return _0x2edb1a['destroy']()['then'](function(){var _0x50bd93=_0x2edb1a[_0x7024('0x2f')]({'plain':!![]});var _0x21ea7e=_0x7024('0x30');return db[_0x7024('0x31')][_0x7024('0x32')]({'where':{'type':_0x21ea7e,'resourceId':_0x50bd93['id']}})['then'](function(){return _0x2edb1a;});})[_0x7024('0x33')](function(){_0xd77fb0[_0x7024('0x22')](0xcc)[_0x7024('0x23')]();});}};}function handleEntityNotFound(_0x2cbbd4,_0x81eea){return function(_0x3a9a6b){if(!_0x3a9a6b){_0x2cbbd4['sendStatus'](0x194);}return _0x3a9a6b;};}function handleError(_0x4604eb,_0x21a78a){_0x21a78a=_0x21a78a||0x1f4;return function(_0x398099){logger[_0x7024('0x34')](_0x398099[_0x7024('0x35')]);if(_0x398099['name']){delete _0x398099['name'];}_0x4604eb[_0x7024('0x22')](_0x21a78a)[_0x7024('0x36')](_0x398099);};}exports[_0x7024('0x37')]=function(_0xc6cbd0,_0x44dbae){var _0x36da6c={},_0x16c8a9={},_0x5f21ae={'count':0x0,'rows':[]};var _0xfe9db9=_[_0x7024('0x38')](db['CmList'][_0x7024('0x39')],function(_0x249ef3){return{'name':_0x249ef3['fieldName'],'type':_0x249ef3[_0x7024('0x3a')][_0x7024('0x3b')]};});_0x16c8a9['model']=_['map'](_0xfe9db9,_0x7024('0x3c'));_0x16c8a9[_0x7024('0x3d')]=_['keys'](_0xc6cbd0[_0x7024('0x3d')]);_0x16c8a9[_0x7024('0x3e')]=_[_0x7024('0x3f')](_0x16c8a9['model'],_0x16c8a9[_0x7024('0x3d')]);_0x36da6c[_0x7024('0x40')]=_[_0x7024('0x3f')](_0x16c8a9[_0x7024('0x41')],qs['fields'](_0xc6cbd0['query'][_0x7024('0x42')]));_0x36da6c[_0x7024('0x40')]=_0x36da6c[_0x7024('0x40')][_0x7024('0x43')]?_0x36da6c['attributes']:_0x16c8a9[_0x7024('0x41')];if(!_0xc6cbd0[_0x7024('0x3d')][_0x7024('0x44')](_0x7024('0x45'))){_0x36da6c[_0x7024('0x26')]=qs[_0x7024('0x26')](_0xc6cbd0['query'][_0x7024('0x26')]);_0x36da6c['offset']=qs[_0x7024('0x28')](_0xc6cbd0[_0x7024('0x3d')][_0x7024('0x28')]);}_0x36da6c[_0x7024('0x46')]=qs[_0x7024('0x47')](_0xc6cbd0[_0x7024('0x3d')][_0x7024('0x47')]);_0x36da6c['where']=qs[_0x7024('0x3e')](_[_0x7024('0x48')](_0xc6cbd0['query'],_0x16c8a9[_0x7024('0x3e')]),_0xfe9db9);if(_0xc6cbd0['query'][_0x7024('0x49')]){_0x36da6c[_0x7024('0x4a')]=_['merge'](_0x36da6c['where'],{'$or':_[_0x7024('0x38')](_0xfe9db9,function(_0x3431ee){if(_0x3431ee[_0x7024('0x3a')]!==_0x7024('0x4b')){var _0xea984f={};_0xea984f[_0x3431ee[_0x7024('0x3c')]]={'$like':'%'+_0xc6cbd0[_0x7024('0x3d')][_0x7024('0x49')]+'%'};return _0xea984f;}})});}_0x36da6c=_['merge']({},_0x36da6c,_0xc6cbd0['options']);var _0x27681e={'where':_0x36da6c[_0x7024('0x4a')]};return db['CmList'][_0x7024('0x27')](_0x27681e)[_0x7024('0x33')](function(_0x31e023){_0x5f21ae['count']=_0x31e023;if(_0xc6cbd0['query'][_0x7024('0x4c')]){_0x36da6c[_0x7024('0x4d')]=[{'all':!![]}];}return db[_0x7024('0x4e')][_0x7024('0x4f')](_0x36da6c);})[_0x7024('0x33')](function(_0x531d90){_0x5f21ae[_0x7024('0x50')]=_0x531d90;return _0x5f21ae;})[_0x7024('0x33')](respondWithFilteredResult(_0x44dbae,_0x36da6c))[_0x7024('0x51')](handleError(_0x44dbae,null));};exports[_0x7024('0x52')]=function(_0x4a3489,_0xbac910){var _0x25a427={'raw':![],'where':{'id':_0x4a3489[_0x7024('0x53')]['id']}},_0x54cd97={};_0x54cd97[_0x7024('0x41')]=_[_0x7024('0x54')](db['CmList'][_0x7024('0x39')]);_0x54cd97[_0x7024('0x3d')]=_['keys'](_0x4a3489[_0x7024('0x3d')]);_0x54cd97[_0x7024('0x3e')]=_['intersection'](_0x54cd97[_0x7024('0x41')],_0x54cd97[_0x7024('0x3d')]);_0x25a427['attributes']=_[_0x7024('0x3f')](_0x54cd97[_0x7024('0x41')],qs[_0x7024('0x42')](_0x4a3489[_0x7024('0x3d')][_0x7024('0x42')]));_0x25a427['attributes']=_0x25a427[_0x7024('0x40')][_0x7024('0x43')]?_0x25a427[_0x7024('0x40')]:_0x54cd97['model'];if(_0x4a3489['query'][_0x7024('0x4c')]){_0x25a427[_0x7024('0x4d')]=[{'all':!![]}];}_0x25a427=_[_0x7024('0x55')]({},_0x25a427,_0x4a3489[_0x7024('0x56')]);return db[_0x7024('0x4e')][_0x7024('0x57')](_0x25a427)['then'](handleEntityNotFound(_0xbac910,null))[_0x7024('0x33')](respondWithResult(_0xbac910,null))[_0x7024('0x51')](handleError(_0xbac910,null));};exports[_0x7024('0x58')]=function(_0x55fcff,_0xb07ea){return db[_0x7024('0x4e')]['create'](_0x55fcff['body'],{})[_0x7024('0x33')](function(_0x437c38){var _0x1502a7=_0x55fcff['user']['get']({'plain':!![]});if(!_0x1502a7)throw new Error(_0x7024('0x59'));if(_0x1502a7['role']===_0x7024('0x5a')){var _0x2e3bd5=_0x437c38[_0x7024('0x2f')]({'plain':!![]});var _0x310217=_0x7024('0x30');return db[_0x7024('0x5b')][_0x7024('0x57')]({'where':{'name':_0x310217,'userProfileId':_0x1502a7['userProfileId']},'raw':!![]})[_0x7024('0x33')](function(_0x4ca6d5){if(_0x4ca6d5&&_0x4ca6d5['autoAssociation']===0x0){return db[_0x7024('0x31')][_0x7024('0x58')]({'name':_0x2e3bd5[_0x7024('0x3c')],'resourceId':_0x2e3bd5['id'],'type':_0x4ca6d5[_0x7024('0x3c')],'sectionId':_0x4ca6d5['id']},{})[_0x7024('0x33')](function(){return _0x437c38;});}else{return _0x437c38;}})[_0x7024('0x51')](function(_0xc58d09){logger[_0x7024('0x34')](_0x7024('0x5c'),_0xc58d09);throw _0xc58d09;});}return _0x437c38;})[_0x7024('0x33')](respondWithResult(_0xb07ea,0xc9))[_0x7024('0x51')](handleError(_0xb07ea,null));};exports[_0x7024('0x2e')]=function(_0x3f5478,_0x21cd1c){if(_0x3f5478[_0x7024('0x5d')]['id']){delete _0x3f5478['body']['id'];}return db['CmList'][_0x7024('0x57')]({'where':{'id':_0x3f5478['params']['id']}})[_0x7024('0x33')](handleEntityNotFound(_0x21cd1c,null))['then'](saveUpdates(_0x3f5478[_0x7024('0x5d')],null))[_0x7024('0x33')](respondWithResult(_0x21cd1c,null))[_0x7024('0x51')](handleError(_0x21cd1c,null));};exports[_0x7024('0x32')]=function(_0xf5ecfb,_0x1d8dd4){return db[_0x7024('0x4e')][_0x7024('0x57')]({'where':{'id':_0xf5ecfb['params']['id']}})[_0x7024('0x33')](handleEntityNotFound(_0x1d8dd4,null))[_0x7024('0x33')](removeEntity(_0x1d8dd4,null))[_0x7024('0x51')](handleError(_0x1d8dd4,null));};exports[_0x7024('0x5e')]=function(_0x4d7450,_0x3e35fa){return db[_0x7024('0x4e')]['describe']()['then'](respondWithResult(_0x3e35fa,null))[_0x7024('0x51')](handleError(_0x3e35fa,null));};exports[_0x7024('0x5f')]=function(_0x37044f,_0x2d43d7,_0x33fc0b){if(_0x37044f['body']['id']){delete _0x37044f[_0x7024('0x5d')]['id'];}return db[_0x7024('0x4e')][_0x7024('0x57')]({'where':{'id':_0x37044f[_0x7024('0x53')]['id']}})[_0x7024('0x33')](handleEntityNotFound(_0x2d43d7,null))[_0x7024('0x33')](function(_0x5ef0a6){if(_0x5ef0a6){_0x37044f[_0x7024('0x5d')][_0x7024('0x60')]=_0x5ef0a6['id'];return db[_0x7024('0x61')][_0x7024('0x58')](_0x37044f[_0x7024('0x5d')]);}})['then'](respondWithResult(_0x2d43d7,null))[_0x7024('0x51')](handleError(_0x2d43d7,null));};exports[_0x7024('0x62')]=function(_0x16d6d9,_0x3648a9,_0x2fc521){var _0x2a75c0={'raw':![],'where':{}};var _0x32058e={};var _0x43d8e9={'count':0x0,'rows':[]};return db[_0x7024('0x4e')][_0x7024('0x63')]({'where':{'id':_0x16d6d9[_0x7024('0x53')]['id']}})[_0x7024('0x33')](handleEntityNotFound(_0x3648a9,null))[_0x7024('0x33')](function(_0x2279cc){if(_0x2279cc){_0x32058e[_0x7024('0x41')]=_[_0x7024('0x54')](db[_0x7024('0x61')]['rawAttributes']);_0x32058e[_0x7024('0x3d')]=_['keys'](_0x16d6d9['query']);_0x32058e[_0x7024('0x3e')]=_[_0x7024('0x3f')](_0x32058e[_0x7024('0x41')],_0x32058e[_0x7024('0x3d')]);_0x2a75c0[_0x7024('0x40')]=_[_0x7024('0x3f')](_0x32058e[_0x7024('0x41')],qs['fields'](_0x16d6d9[_0x7024('0x3d')][_0x7024('0x42')]));_0x2a75c0[_0x7024('0x40')]=_0x2a75c0[_0x7024('0x40')][_0x7024('0x43')]?_0x2a75c0[_0x7024('0x40')]:_0x32058e[_0x7024('0x41')];if(!_0x16d6d9[_0x7024('0x3d')][_0x7024('0x44')](_0x7024('0x45'))){_0x2a75c0[_0x7024('0x26')]=qs[_0x7024('0x26')](_0x16d6d9[_0x7024('0x3d')][_0x7024('0x26')]);_0x2a75c0['offset']=qs[_0x7024('0x28')](_0x16d6d9['query']['offset']);}_0x2a75c0[_0x7024('0x46')]=qs[_0x7024('0x47')](_0x16d6d9[_0x7024('0x3d')][_0x7024('0x47')]);_0x2a75c0['where']=qs['filters'](_[_0x7024('0x48')](_0x16d6d9[_0x7024('0x3d')],_0x32058e[_0x7024('0x3e')]));_0x2a75c0['where'][_0x7024('0x60')]=_0x2279cc['id'];if(_0x16d6d9[_0x7024('0x3d')][_0x7024('0x49')]){_0x2a75c0[_0x7024('0x4a')]=_['merge'](_0x2a75c0['where'],{'$or':_[_0x7024('0x38')](_0x2a75c0[_0x7024('0x40')],function(_0x9249d3){var _0x49eef3={};_0x49eef3[_0x9249d3]={'$like':'%'+_0x16d6d9['query'][_0x7024('0x49')]+'%'};return _0x49eef3;})});}_0x2a75c0=_[_0x7024('0x55')]({},_0x2a75c0,_0x16d6d9[_0x7024('0x56')]);return db[_0x7024('0x61')][_0x7024('0x27')]({'where':_0x2a75c0[_0x7024('0x4a')]})[_0x7024('0x33')](function(_0x2cbba5){_0x43d8e9[_0x7024('0x27')]=_0x2cbba5;if(_0x16d6d9[_0x7024('0x3d')][_0x7024('0x4c')]){_0x2a75c0[_0x7024('0x4d')]=[{'all':!![]}];}return db['Disposition'][_0x7024('0x4f')](_0x2a75c0);})[_0x7024('0x33')](function(_0x1426b0){_0x43d8e9[_0x7024('0x50')]=_0x1426b0;return _0x43d8e9;});}})[_0x7024('0x33')](respondWithFilteredResult(_0x3648a9,_0x2a75c0))[_0x7024('0x51')](handleError(_0x3648a9,null));};exports[_0x7024('0x64')]=function(_0x4a8f06,_0x1fc246,_0x24e2cb){return db[_0x7024('0x4e')][_0x7024('0x57')]({'where':{'id':_0x4a8f06['params']['id']}})['then'](handleEntityNotFound(_0x1fc246,null))['then'](function(_0x5bbec6){if(_0x5bbec6){return _0x5bbec6['removeDispositions'](_0x4a8f06[_0x7024('0x3d')][_0x7024('0x65')]);}})[_0x7024('0x33')](respondWithStatusCode(_0x1fc246,null))[_0x7024('0x51')](handleError(_0x1fc246,null));};exports[_0x7024('0x66')]=function(_0x18797d,_0x44adb2,_0x5522c2){return db['CmList']['find']({'where':{'id':_0x18797d[_0x7024('0x53')]['id']}})['then'](handleEntityNotFound(_0x44adb2,null))['then'](function(_0x11bb90){if(_0x11bb90){var _0x1fc91f=[];var _0x5c029a={'success':[],'errors':[]};return db['CmContact']['describe']()[_0x7024('0x33')](function(_0x48dab2){if(_0x18797d[_0x7024('0x5d')][_0x7024('0x67')]&&_['isArray'](_0x18797d[_0x7024('0x5d')][_0x7024('0x67')])){if(_0x18797d[_0x7024('0x5d')][_0x7024('0x67')][_0x7024('0x43')]){_0x18797d[_0x7024('0x5d')][_0x7024('0x67')]=_0x18797d['body'][_0x7024('0x67')]['join'](';')+';';}else{_0x18797d[_0x7024('0x5d')]['tags']=null;}}else{_0x18797d[_0x7024('0x5d')][_0x7024('0x67')]=null;}if(_0x18797d[_0x7024('0x5d')]&&_[_0x7024('0x68')](_0x18797d[_0x7024('0x5d')])){for(var _0x55816c=0x0;_0x55816c<_0x18797d[_0x7024('0x5d')][_0x7024('0x43')];_0x55816c+=0x1){_0x18797d[_0x7024('0x5d')][_0x55816c][_0x7024('0x60')]=_0x18797d[_0x7024('0x53')]['id'];_0x1fc91f['push'](_0x18797d['body'][_0x55816c]);}return BPromise['each'](_0x1fc91f,function(_0xdd53d1){return db[_0x7024('0x69')][_0x7024('0x58')](_[_0x7024('0x6a')](_0xdd53d1,[_0x7024('0x65'),'id'])||{},{'fields':_[_0x7024('0x54')](_0x48dab2),'raw':!![]})['then'](function(_0x31074a){_0x5c029a[_0x7024('0x6b')][_0x7024('0x6c')](_0x31074a['dataValues']);})['catch'](function(_0x2f25d2){_0x5c029a[_0x7024('0x6d')][_0x7024('0x6c')]({'data':_0xdd53d1,'error':_0x2f25d2[_0x7024('0x6e')]});});})[_0x7024('0x33')](function(_0x468ef1){return _0x5c029a;})[_0x7024('0x51')](function(_0x56b6da){return _0x56b6da;});}else{_0x44adb2[_0x7024('0x22')](0x190)[_0x7024('0x24')]({'message':_0x7024('0x6f')});}});}})['then'](respondWithResult(_0x44adb2,null))['catch'](handleError(_0x44adb2,null));};exports[_0x7024('0x70')]=function(_0x307352,_0x21563c,_0x3bf608){var _0x27240d;return db['CmList'][_0x7024('0x57')]({'where':{'id':_0x307352[_0x7024('0x53')]['id']},'include':[{'model':db['CmCustomField'],'as':'CustomFields'}]})[_0x7024('0x33')](handleEntityNotFound(_0x21563c,null))[_0x7024('0x33')](function(_0x1f1747){if(_0x1f1747){_0x27240d=_0x1f1747;return db[_0x7024('0x69')][_0x7024('0x39')];}})[_0x7024('0x33')](function(_0x24ec86){if(_0x24ec86){var _0x4ef482={};var _0x314a76={};_0x314a76[_0x7024('0x41')]=_['concat'](_[_0x7024('0x54')](_0x24ec86),_[_0x7024('0x38')](_0x27240d['CustomFields'],function(_0x8c31b9){return util[_0x7024('0x71')](_0x7024('0x72'),_0x8c31b9['id']);}));_0x314a76['query']=_['keys'](_0x307352[_0x7024('0x3d')]);_0x314a76[_0x7024('0x3e')]=_[_0x7024('0x3f')](_0x314a76[_0x7024('0x41')],_0x314a76['query']);_0x4ef482[_0x7024('0x40')]=_['intersection'](_0x314a76[_0x7024('0x41')],qs[_0x7024('0x42')](_0x307352['query']['fields']));_0x4ef482['attributes']=_0x4ef482['attributes']['length']?_0x4ef482[_0x7024('0x40')]:_0x314a76[_0x7024('0x41')];if(!_0x307352['query'][_0x7024('0x44')](_0x7024('0x45'))){_0x4ef482[_0x7024('0x26')]=qs['limit'](_0x307352['query'][_0x7024('0x26')]);_0x4ef482[_0x7024('0x28')]=qs[_0x7024('0x28')](_0x307352[_0x7024('0x3d')][_0x7024('0x28')]);}_0x4ef482[_0x7024('0x46')]=qs[_0x7024('0x47')](_0x307352[_0x7024('0x3d')]['sort']);_0x4ef482[_0x7024('0x4a')]=qs[_0x7024('0x3e')](_['pick'](_0x307352[_0x7024('0x3d')],_0x314a76['filters']));_0x4ef482[_0x7024('0x73')]=!![];if(_0x307352[_0x7024('0x3d')][_0x7024('0x49')]){_0x4ef482['where']=_[_0x7024('0x55')](_0x4ef482['where'],{'$or':_[_0x7024('0x38')](_0x4ef482['attributes'],function(_0xd583ca){var _0x3ca120={};_0x3ca120[_0xd583ca]={'$like':'%'+_0x307352['query'][_0x7024('0x49')]+'%'};return _0x3ca120;})});}_0x4ef482=_[_0x7024('0x55')]({},_0x4ef482,_0x307352[_0x7024('0x56')]);return _0x27240d[_0x7024('0x70')](_0x4ef482);}})['then'](respondWithResult(_0x21563c,null))[_0x7024('0x51')](handleError(_0x21563c,null));};exports[_0x7024('0x74')]=function(_0x412ed7,_0x5c5247,_0x51f102){var _0x18e114;var _0x2b3c67;var _0x2cb40e;var _0x310080=_0x412ed7[_0x7024('0x53')]['id'];csv_results=[];return db[_0x7024('0x75')][_0x7024('0x4f')]({'attributes':['id',_0x7024('0x3c')],'raw':!![],'order':[_0x7024('0x76')]})[_0x7024('0x33')](function(_0x452c45){_0x18e114=_0x452c45;var _0x4e9633=_[_0x7024('0x54')](db[_0x7024('0x69')][_0x7024('0x39')]);return db[_0x7024('0x77')][_0x7024('0x4f')]({'raw':!![],'attributes':['id',_0x7024('0x78')]})[_0x7024('0x33')](function(_0x389e93){_0x2b3c67=_0x389e93;var _0x4fba15=squel[_0x7024('0x79')]()['fields'](_0x4e9633)['from'](_0x7024('0x7a'),'c')[_0x7024('0x4a')](_0x7024('0x7b'),_0x310080)['where']('c.deletedAt\x20is\x20null')[_0x7024('0x7c')]();for(var _0x3d4d2f=0x0;_0x3d4d2f<_0x2b3c67[_0x7024('0x43')];_0x3d4d2f++){_0x4fba15[_0x7024('0x7d')]('c.cf_'+_0x2b3c67[_0x3d4d2f]['id'],'customField_'+_0x2b3c67[_0x3d4d2f][_0x7024('0x78')]);}for(var _0x3d4d2f=0x0;_0x3d4d2f<_0x18e114[_0x7024('0x43')];_0x3d4d2f++){_0x4fba15[_0x7024('0x7d')](squel['select']()[_0x7024('0x7d')](_0x7024('0x7e'))[_0x7024('0x7f')](_0x7024('0x80'))['where'](_0x7024('0x81'),_0x18e114[_0x3d4d2f]['id'])[_0x7024('0x4a')](_0x7024('0x82')),_0x7024('0x83')+_0x18e114[_0x3d4d2f][_0x7024('0x3c')]);_0x4fba15[_0x7024('0x7d')](squel[_0x7024('0x79')]()[_0x7024('0x7d')](_0x7024('0x84'))[_0x7024('0x7f')](_0x7024('0x80'))['where'](_0x7024('0x81'),_0x18e114[_0x3d4d2f]['id'])[_0x7024('0x4a')](_0x7024('0x82')),_0x7024('0x85')+_0x18e114[_0x3d4d2f][_0x7024('0x3c')]);}var _0xb5dd7e=[];_0xb5dd7e[_0x7024('0x6c')](_0x4fba15[_0x7024('0x86')]());BPromise[_0x7024('0x87')](_0xb5dd7e,handleQuery)['then'](function(_0x1788c3){handleQuery(_0x4fba15[_0x7024('0x86')]());var _0x254c54=csv_results[0x0];if(!_[_0x7024('0x88')](_0x254c54)){var _0x269863=toCsv(_0x254c54);var _0x15c406=Date['now']();fs[_0x7024('0x89')](util[_0x7024('0x71')](_0x7024('0x8a'),_0x310080,_0x15c406),_0x269863);_0x5c5247[_0x7024('0x8b')](_0x7024('0x8c'),_0x7024('0x8d')+util['format'](_0x7024('0x8e'),_0x310080,_0x15c406));_0x5c5247[_0x7024('0x8b')](_0x7024('0x8f'),'text/csv');return _0x5c5247['download'](util[_0x7024('0x71')](_0x7024('0x8a'),_0x310080,_0x15c406));}else{return _0x5c5247['sendStatus'](0xcc);}});});});};exports['addCustomField']=function(_0x2ae9e5,_0x1f3f7c,_0x54c38d){var _0x36173c;delete _0x2ae9e5['body']['id'];return db[_0x7024('0x4e')][_0x7024('0x63')]({'where':{'id':_0x2ae9e5[_0x7024('0x53')]['id']}})[_0x7024('0x33')](handleEntityNotFound(_0x1f3f7c,null))[_0x7024('0x33')](function(_0x3c8c28){if(_0x3c8c28){return db[_0x7024('0x90')][_0x7024('0x91')](function(_0x11216e){return db[_0x7024('0x77')][_0x7024('0x58')](_0x2ae9e5['body'],{'transaction':_0x11216e})[_0x7024('0x33')](function(_0x300eb5){_0x36173c=_0x300eb5;return _0x3c8c28[_0x7024('0x92')](_0x300eb5,{'transaction':_0x11216e});})['then'](function(){var _0x58740b={'type':db[_0x7024('0x93')]['TEXT'],'transaction':_0x11216e};switch(_0x2ae9e5[_0x7024('0x5d')][_0x7024('0x3a')]){case _0x7024('0x94'):_0x58740b[_0x7024('0x3a')]=db['Sequelize']['TEXT'];break;case _0x7024('0x95'):_0x58740b[_0x7024('0x3a')]=db['Sequelize']['INTEGER'];break;case _0x7024('0x96'):_0x58740b[_0x7024('0x3a')]=db['Sequelize']['BOOLEAN'];_0x58740b[_0x7024('0x97')]=![];break;default:}return db[_0x7024('0x90')][_0x7024('0x98')][_0x7024('0x99')](_0x7024('0x7a'),util['format'](_0x7024('0x9a'),_0x36173c['id']),_0x58740b);})[_0x7024('0x33')](function(){return _0x36173c;});});}})[_0x7024('0x33')](respondWithResult(_0x1f3f7c,null))[_0x7024('0x51')](handleError(_0x1f3f7c,null));};exports[_0x7024('0x9b')]=function(_0x32c1c0,_0x191205,_0x415dc5){var _0xc9f0d9={};var _0x55bdae={};var _0x2b3f9c;var _0x4fe49f;return db[_0x7024('0x4e')][_0x7024('0x63')]({'where':{'id':_0x32c1c0[_0x7024('0x53')]['id']}})[_0x7024('0x33')](handleEntityNotFound(_0x191205,null))['then'](function(_0x22fcd8){if(_0x22fcd8){_0x2b3f9c=_0x22fcd8;_0x55bdae['model']=_[_0x7024('0x54')](db['CmCustomField'][_0x7024('0x39')]);_0x55bdae[_0x7024('0x3d')]=_[_0x7024('0x54')](_0x32c1c0[_0x7024('0x3d')]);_0x55bdae[_0x7024('0x3e')]=_[_0x7024('0x3f')](_0x55bdae['model'],_0x55bdae[_0x7024('0x3d')]);_0xc9f0d9['attributes']=_[_0x7024('0x3f')](_0x55bdae['model'],qs[_0x7024('0x42')](_0x32c1c0['query']['fields']));_0xc9f0d9[_0x7024('0x40')]=_0xc9f0d9[_0x7024('0x40')][_0x7024('0x43')]?_0xc9f0d9[_0x7024('0x40')]:_0x55bdae['model'];_0xc9f0d9['order']=qs['sort'](_0x32c1c0[_0x7024('0x3d')]['sort']);_0xc9f0d9['where']=qs[_0x7024('0x3e')](_[_0x7024('0x48')](_0x32c1c0[_0x7024('0x3d')],_0x55bdae[_0x7024('0x3e')]));_0xc9f0d9[_0x7024('0x4a')]=_['merge'](_0xc9f0d9[_0x7024('0x4a')],{'$or':[{'ListId':_0x22fcd8['id']},{'ListId':null}]});if(_0x32c1c0[_0x7024('0x3d')][_0x7024('0x49')]){_0xc9f0d9[_0x7024('0x4a')]=_[_0x7024('0x55')](_0xc9f0d9[_0x7024('0x4a')],{'$or':_[_0x7024('0x38')](_0xc9f0d9[_0x7024('0x40')],function(_0x39da62){var _0x1c4b9e={};_0x1c4b9e[_0x39da62]={'$like':'%'+_0x32c1c0[_0x7024('0x3d')][_0x7024('0x49')]+'%'};return _0x1c4b9e;})});}_0xc9f0d9=_[_0x7024('0x55')]({},_0xc9f0d9,_0x32c1c0[_0x7024('0x56')]);return db['CmCustomField'][_0x7024('0x9c')](_0xc9f0d9);}})[_0x7024('0x33')](respondWithResult(_0x191205,null))[_0x7024('0x51')](handleError(_0x191205,null));};exports['getGlobalCustomFields']=function(_0x998ca7,_0x27d1d1){return db['CmCustomField']['findAndCountAll']({'where':{'ListId':null}})[_0x7024('0x33')](handleEntityNotFound(_0x27d1d1,null))[_0x7024('0x33')](function(_0x5c704d){return _0x5c704d;})[_0x7024('0x33')](respondWithResult(_0x27d1d1,null))[_0x7024('0x51')](handleError(_0x27d1d1,null));};exports[_0x7024('0x9d')]=function(_0x4ec090,_0x592732,_0x2ed533){return db[_0x7024('0x4e')][_0x7024('0x57')]({'where':{'id':_0x4ec090['params']['id']}})[_0x7024('0x33')](handleEntityNotFound(_0x592732,null))['then'](function(_0x2c850f){if(_0x2c850f){return _0x2c850f[_0x7024('0x9d')](_0x4ec090[_0x7024('0x5d')][_0x7024('0x65')],_[_0x7024('0x6a')](_0x4ec090[_0x7024('0x5d')],[_0x7024('0x65'),'id'])||{})[_0x7024('0x9e')](function(_0x50cc0c){for(var _0x8ab1c1=0x0;_0x8ab1c1<_0x4ec090[_0x7024('0x5d')][_0x7024('0x65')][_0x7024('0x43')];_0x8ab1c1+=0x1){socket[_0x7024('0x9f')](_0x7024('0xa0'),{'UserId':Number(_0x4ec090[_0x7024('0x5d')][_0x7024('0x65')][_0x8ab1c1]),'CmListId':Number(_0x4ec090[_0x7024('0x53')]['id'])});}return _0x50cc0c;});}})['then'](respondWithResult(_0x592732,null))[_0x7024('0x51')](handleError(_0x592732,null));};exports['removeAgents']=function(_0x50332f,_0x59f7fd,_0x4af478){return db['CmList'][_0x7024('0x57')]({'where':{'id':_0x50332f[_0x7024('0x53')]['id']}})[_0x7024('0x33')](handleEntityNotFound(_0x59f7fd,null))[_0x7024('0x33')](function(_0x3d42e4){if(_0x3d42e4){return _0x3d42e4[_0x7024('0xa1')](_0x50332f[_0x7024('0x3d')][_0x7024('0x65')])[_0x7024('0x33')](function(){if(_[_0x7024('0x68')](_0x50332f['query']['ids'])){for(var _0x1baab0=0x0;_0x1baab0<_0x50332f[_0x7024('0x3d')]['ids']['length'];_0x1baab0+=0x1){socket[_0x7024('0x9f')]('userCmList:remove',{'UserId':Number(_0x50332f[_0x7024('0x3d')][_0x7024('0x65')][_0x1baab0]),'CmListId':Number(_0x50332f['params']['id'])});}}else{socket[_0x7024('0x9f')](_0x7024('0xa2'),{'UserId':Number(_0x50332f[_0x7024('0x3d')][_0x7024('0x65')]),'CmListId':Number(_0x50332f[_0x7024('0x53')]['id'])});}});}})['then'](respondWithStatusCode(_0x59f7fd,null))[_0x7024('0x51')](handleError(_0x59f7fd,null));};exports[_0x7024('0xa3')]=function(_0x4229db,_0x459534,_0x45c72d){var _0x139c4e={};var _0x5aeea2={};var _0x286217;var _0x102d03;return db[_0x7024('0x4e')][_0x7024('0x63')]({'where':{'id':_0x4229db[_0x7024('0x53')]['id']}})[_0x7024('0x33')](handleEntityNotFound(_0x459534,null))['then'](function(_0x37117f){if(_0x37117f){_0x286217=_0x37117f;_0x5aeea2[_0x7024('0x41')]=_[_0x7024('0x54')](db['User']['rawAttributes']);_0x5aeea2[_0x7024('0x3d')]=_[_0x7024('0x54')](_0x4229db['query']);_0x5aeea2[_0x7024('0x3e')]=_[_0x7024('0x3f')](_0x5aeea2[_0x7024('0x41')],_0x5aeea2['query']);_0x139c4e['attributes']=_[_0x7024('0x3f')](_0x5aeea2[_0x7024('0x41')],qs['fields'](_0x4229db[_0x7024('0x3d')][_0x7024('0x42')]));_0x139c4e[_0x7024('0x40')]=_0x139c4e[_0x7024('0x40')]['length']?_0x139c4e[_0x7024('0x40')]:_0x5aeea2[_0x7024('0x41')];_0x139c4e[_0x7024('0x46')]=qs[_0x7024('0x47')](_0x4229db[_0x7024('0x3d')]['sort']);_0x139c4e[_0x7024('0x4a')]=qs[_0x7024('0x3e')](_['pick'](_0x4229db['query'],_0x5aeea2['filters']));if(_0x4229db[_0x7024('0x3d')][_0x7024('0x49')]){_0x139c4e[_0x7024('0x4a')]=_[_0x7024('0x55')](_0x139c4e[_0x7024('0x4a')],{'$or':_[_0x7024('0x38')](_0x139c4e[_0x7024('0x40')],function(_0x2c9a29){var _0x495724={};_0x495724[_0x2c9a29]={'$like':'%'+_0x4229db[_0x7024('0x3d')]['filter']+'%'};return _0x495724;})});}_0x139c4e=_[_0x7024('0x55')]({},_0x139c4e,_0x4229db[_0x7024('0x56')]);return _0x286217['getAgents'](_0x139c4e);}})['then'](function(_0x2af2b6){if(_0x2af2b6){_0x102d03=_0x2af2b6[_0x7024('0x43')];if(!_0x4229db[_0x7024('0x3d')][_0x7024('0x44')](_0x7024('0x45'))){_0x139c4e[_0x7024('0x26')]=qs[_0x7024('0x26')](_0x4229db['query']['limit']);_0x139c4e[_0x7024('0x28')]=qs[_0x7024('0x28')](_0x4229db['query'][_0x7024('0x28')]);}return _0x286217[_0x7024('0xa3')](_0x139c4e);}})[_0x7024('0x33')](function(_0x572e3e){if(_0x572e3e){return _0x572e3e?{'count':_0x102d03,'rows':_0x572e3e}:null;}})[_0x7024('0x33')](respondWithResult(_0x459534,null))[_0x7024('0x51')](handleError(_0x459534,null));};function handleQuery(_0x5a1fed){logger[_0x7024('0xa4')](_0x5a1fed);return db['sequelize']['query'](_0x5a1fed)[_0x7024('0x9e')](function(_0x26d1e4){csv_results[_0x7024('0x6c')](_0x26d1e4);})[_0x7024('0x51')](function(_0x456cca){logger[_0x7024('0x34')](_0x456cca['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