Built motion from commit c116dc8b.|2.6.30
[motion2.git] / server / api / cmList / cmList.controller.js
index b153b0e..9e2ed6f 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x76c1=['queryInterface','addColumn','getCustomFields','findAndCountAll','addAgents','emit','userCmList:save','removeAgents','userCmList:remove','getAgents','User','info','message','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','util','path','sox','fs-extra','lodash','crypto','jsforce','desk.js','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/license/util','redis','defaults','localhost','./cmList.socket','register','status','end','json','undefined','limit','count','offset','set','Content-Range','apply','reject','save','update','then','destroy','Lists','UserProfileResource','sendStatus','error','stack','name','send','index','CmList','type','key','model','map','query','keys','filters','intersection','fields','attributes','hasOwnProperty','nolimit','order','sort','where','filter','merge','VIRTUAL','options','includeAll','findAll','rows','show','params','rawAttributes','include','find','catch','create','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','describe','addDisposition','ListId','Disposition','getDispositions','findOne','length','pick','removeDispositions','ids','addContacts','CmContact','tags','join','isArray','omit','success','dataValues','push','Malformed\x20request\x20syntax','getContacts','CmCustomField','concat','CustomFields','format','cf_%d','getContactsCsv','ContactItemType','OrderBy','alias','select','from','cm_contacts','c.ListId\x20=\x20?','distinct','field','c.cf_','customField_','item','cm_contact_has_items','ItemTypeId\x20=\x20?','CmContactId\x20=\x20c.id','additionalPhone_','description','description_additionalPhone_','toString','each','isEmpty','/tmp/list_%d_%s.csv','setHeader','Content-disposition','attachment;\x20filename=','list_%d_%s.csv','Content-type','text/csv','download','sequelize','transaction','addCustomFields','Sequelize','TEXT','text','number','INTEGER','switch','BOOLEAN'];(function(_0x46e418,_0x5c4d24){var _0x5e1be5=function(_0x170bd4){while(--_0x170bd4){_0x46e418['push'](_0x46e418['shift']());}};_0x5e1be5(++_0x5c4d24);}(_0x76c1,0x15b));var _0x176c=function(_0x576d8a,_0x2d7bde){_0x576d8a=_0x576d8a-0x0;var _0x3dc3ef=_0x76c1[_0x576d8a];return _0x3dc3ef;};'use strict';var emlformat=require(_0x176c('0x0'));var rimraf=require(_0x176c('0x1'));var zipdir=require(_0x176c('0x2'));var jsonpatch=require(_0x176c('0x3'));var rp=require(_0x176c('0x4'));var moment=require(_0x176c('0x5'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x176c('0x6'));var path=require(_0x176c('0x7'));var sox=require(_0x176c('0x8'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x176c('0x9'));var _=require(_0x176c('0xa'));var squel=require('squel');var crypto=require(_0x176c('0xb'));var jsforce=require(_0x176c('0xc'));var deskjs=require(_0x176c('0xd'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x176c('0xe'));var Redis=require(_0x176c('0xf'));var authService=require('../../components/auth/service');var qs=require(_0x176c('0x10'));var as=require(_0x176c('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x176c('0x12'))(_0x176c('0x13'));var utils=require(_0x176c('0x14'));var config=require('../../config/environment');var licenseUtil=require(_0x176c('0x15'));var db=require('../../mysqldb')['db'];var csv_results;config[_0x176c('0x16')]=_[_0x176c('0x17')](config['redis'],{'host':_0x176c('0x18'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x176c('0x16')]));require(_0x176c('0x19'))[_0x176c('0x1a')](socket);function respondWithStatusCode(_0x701920,_0x5bf5ca){_0x5bf5ca=_0x5bf5ca||0xcc;return function(_0x1b9f08){if(_0x1b9f08){return _0x701920['sendStatus'](_0x5bf5ca);}return _0x701920[_0x176c('0x1b')](_0x5bf5ca)[_0x176c('0x1c')]();};}function respondWithResult(_0x27693f,_0x62000e){_0x62000e=_0x62000e||0xc8;return function(_0x2a7f32){if(_0x2a7f32){return _0x27693f[_0x176c('0x1b')](_0x62000e)[_0x176c('0x1d')](_0x2a7f32);}};}function respondWithFilteredResult(_0x4cbad3,_0x1ab71f){return function(_0x2b33c3){if(_0x2b33c3){var _0x4301fc=typeof _0x1ab71f['offset']===_0x176c('0x1e')&&typeof _0x1ab71f[_0x176c('0x1f')]==='undefined';var _0x5cd3c5=_0x2b33c3[_0x176c('0x20')];var _0x20f856=_0x4301fc?0x0:_0x1ab71f[_0x176c('0x21')];var _0x16b1c0=_0x4301fc?_0x2b33c3['count']:_0x1ab71f[_0x176c('0x21')]+_0x1ab71f[_0x176c('0x1f')];var _0xd9b48d;if(_0x16b1c0>=_0x5cd3c5){_0x16b1c0=_0x5cd3c5;_0xd9b48d=0xc8;}else{_0xd9b48d=0xce;}_0x4cbad3[_0x176c('0x1b')](_0xd9b48d);return _0x4cbad3[_0x176c('0x22')](_0x176c('0x23'),_0x20f856+'-'+_0x16b1c0+'/'+_0x5cd3c5)[_0x176c('0x1d')](_0x2b33c3);}return null;};}function patchUpdates(_0x1c83a0){return function(_0x2fee46){try{jsonpatch[_0x176c('0x24')](_0x2fee46,_0x1c83a0,!![]);}catch(_0x15e442){return BPromise[_0x176c('0x25')](_0x15e442);}return _0x2fee46[_0x176c('0x26')]();};}function saveUpdates(_0x2b8f1a,_0x54038f){return function(_0x2b8724){if(_0x2b8724){return _0x2b8724[_0x176c('0x27')](_0x2b8f1a)[_0x176c('0x28')](function(_0x1e9815){return _0x1e9815;});}return null;};}function removeEntity(_0x49e882,_0x5b8b92){return function(_0x5956b2){if(_0x5956b2){return _0x5956b2[_0x176c('0x29')]()[_0x176c('0x28')](function(){var _0x482bb8=_0x5956b2['get']({'plain':!![]});var _0x162f26=_0x176c('0x2a');return db[_0x176c('0x2b')][_0x176c('0x29')]({'where':{'type':_0x162f26,'resourceId':_0x482bb8['id']}})['then'](function(){return _0x5956b2;});})[_0x176c('0x28')](function(){_0x49e882[_0x176c('0x1b')](0xcc)['end']();});}};}function handleEntityNotFound(_0x16e3ee,_0x1132f5){return function(_0x51df1e){if(!_0x51df1e){_0x16e3ee[_0x176c('0x2c')](0x194);}return _0x51df1e;};}function handleError(_0x4eb170,_0x347512){_0x347512=_0x347512||0x1f4;return function(_0x362261){logger[_0x176c('0x2d')](_0x362261[_0x176c('0x2e')]);if(_0x362261[_0x176c('0x2f')]){delete _0x362261[_0x176c('0x2f')];}_0x4eb170[_0x176c('0x1b')](_0x347512)[_0x176c('0x30')](_0x362261);};}exports[_0x176c('0x31')]=function(_0x465052,_0x5e2fa3){var _0xecc3cb={},_0x1a547c={},_0x58b16d={'count':0x0,'rows':[]};var _0x357820=_['map'](db[_0x176c('0x32')]['rawAttributes'],function(_0x451231){return{'name':_0x451231['fieldName'],'type':_0x451231[_0x176c('0x33')][_0x176c('0x34')]};});_0x1a547c[_0x176c('0x35')]=_[_0x176c('0x36')](_0x357820,_0x176c('0x2f'));_0x1a547c[_0x176c('0x37')]=_[_0x176c('0x38')](_0x465052[_0x176c('0x37')]);_0x1a547c[_0x176c('0x39')]=_[_0x176c('0x3a')](_0x1a547c['model'],_0x1a547c['query']);_0xecc3cb['attributes']=_['intersection'](_0x1a547c['model'],qs[_0x176c('0x3b')](_0x465052[_0x176c('0x37')][_0x176c('0x3b')]));_0xecc3cb[_0x176c('0x3c')]=_0xecc3cb[_0x176c('0x3c')]['length']?_0xecc3cb[_0x176c('0x3c')]:_0x1a547c[_0x176c('0x35')];if(!_0x465052[_0x176c('0x37')][_0x176c('0x3d')](_0x176c('0x3e'))){_0xecc3cb['limit']=qs[_0x176c('0x1f')](_0x465052[_0x176c('0x37')][_0x176c('0x1f')]);_0xecc3cb[_0x176c('0x21')]=qs['offset'](_0x465052[_0x176c('0x37')][_0x176c('0x21')]);}_0xecc3cb[_0x176c('0x3f')]=qs[_0x176c('0x40')](_0x465052[_0x176c('0x37')][_0x176c('0x40')]);_0xecc3cb[_0x176c('0x41')]=qs[_0x176c('0x39')](_['pick'](_0x465052[_0x176c('0x37')],_0x1a547c['filters']),_0x357820);if(_0x465052[_0x176c('0x37')][_0x176c('0x42')]){_0xecc3cb[_0x176c('0x41')]=_[_0x176c('0x43')](_0xecc3cb[_0x176c('0x41')],{'$or':_[_0x176c('0x36')](_0x357820,function(_0x49c19f){if(_0x49c19f[_0x176c('0x33')]!==_0x176c('0x44')){var _0x5298b5={};_0x5298b5[_0x49c19f['name']]={'$like':'%'+_0x465052[_0x176c('0x37')][_0x176c('0x42')]+'%'};return _0x5298b5;}})});}_0xecc3cb=_[_0x176c('0x43')]({},_0xecc3cb,_0x465052[_0x176c('0x45')]);var _0xa9fca4={'where':_0xecc3cb['where']};return db[_0x176c('0x32')]['count'](_0xa9fca4)['then'](function(_0x26f489){_0x58b16d[_0x176c('0x20')]=_0x26f489;if(_0x465052[_0x176c('0x37')][_0x176c('0x46')]){_0xecc3cb['include']=[{'all':!![]}];}return db[_0x176c('0x32')][_0x176c('0x47')](_0xecc3cb);})['then'](function(_0x22698c){_0x58b16d[_0x176c('0x48')]=_0x22698c;return _0x58b16d;})[_0x176c('0x28')](respondWithFilteredResult(_0x5e2fa3,_0xecc3cb))['catch'](handleError(_0x5e2fa3,null));};exports[_0x176c('0x49')]=function(_0x28e385,_0x101a9f){var _0x5d966a={'raw':![],'where':{'id':_0x28e385[_0x176c('0x4a')]['id']}},_0x490086={};_0x490086[_0x176c('0x35')]=_[_0x176c('0x38')](db[_0x176c('0x32')][_0x176c('0x4b')]);_0x490086[_0x176c('0x37')]=_[_0x176c('0x38')](_0x28e385[_0x176c('0x37')]);_0x490086[_0x176c('0x39')]=_['intersection'](_0x490086[_0x176c('0x35')],_0x490086['query']);_0x5d966a[_0x176c('0x3c')]=_[_0x176c('0x3a')](_0x490086[_0x176c('0x35')],qs[_0x176c('0x3b')](_0x28e385[_0x176c('0x37')][_0x176c('0x3b')]));_0x5d966a[_0x176c('0x3c')]=_0x5d966a[_0x176c('0x3c')]['length']?_0x5d966a[_0x176c('0x3c')]:_0x490086[_0x176c('0x35')];if(_0x28e385[_0x176c('0x37')][_0x176c('0x46')]){_0x5d966a[_0x176c('0x4c')]=[{'all':!![]}];}_0x5d966a=_[_0x176c('0x43')]({},_0x5d966a,_0x28e385[_0x176c('0x45')]);return db[_0x176c('0x32')][_0x176c('0x4d')](_0x5d966a)['then'](handleEntityNotFound(_0x101a9f,null))['then'](respondWithResult(_0x101a9f,null))[_0x176c('0x4e')](handleError(_0x101a9f,null));};exports[_0x176c('0x4f')]=function(_0x21b909,_0x45e692){return db['CmList'][_0x176c('0x4f')](_0x21b909['body'],{})[_0x176c('0x28')](function(_0x41b690){var _0x24a518=_0x21b909[_0x176c('0x50')][_0x176c('0x51')]({'plain':!![]});if(!_0x24a518)throw new Error(_0x176c('0x52'));if(_0x24a518[_0x176c('0x53')]===_0x176c('0x50')){var _0x424533=_0x41b690[_0x176c('0x51')]({'plain':!![]});var _0x1992ab='Lists';return db[_0x176c('0x54')]['find']({'where':{'name':_0x1992ab,'userProfileId':_0x24a518[_0x176c('0x55')]},'raw':!![]})[_0x176c('0x28')](function(_0x52cc40){if(_0x52cc40&&_0x52cc40['autoAssociation']===0x0){return db[_0x176c('0x2b')]['create']({'name':_0x424533[_0x176c('0x2f')],'resourceId':_0x424533['id'],'type':_0x52cc40[_0x176c('0x2f')],'sectionId':_0x52cc40['id']},{})[_0x176c('0x28')](function(){return _0x41b690;});}else{return _0x41b690;}})[_0x176c('0x4e')](function(_0x2e489f){logger[_0x176c('0x2d')](_0x176c('0x56'),_0x2e489f);throw _0x2e489f;});}return _0x41b690;})[_0x176c('0x28')](respondWithResult(_0x45e692,0xc9))[_0x176c('0x4e')](handleError(_0x45e692,null));};exports['update']=function(_0xf1ab1d,_0x23eedf){if(_0xf1ab1d['body']['id']){delete _0xf1ab1d[_0x176c('0x57')]['id'];}return db[_0x176c('0x32')]['find']({'where':{'id':_0xf1ab1d['params']['id']}})[_0x176c('0x28')](handleEntityNotFound(_0x23eedf,null))[_0x176c('0x28')](saveUpdates(_0xf1ab1d[_0x176c('0x57')],null))[_0x176c('0x28')](respondWithResult(_0x23eedf,null))['catch'](handleError(_0x23eedf,null));};exports[_0x176c('0x29')]=function(_0x27d037,_0x217fda){return db['CmList']['find']({'where':{'id':_0x27d037['params']['id']}})['then'](handleEntityNotFound(_0x217fda,null))[_0x176c('0x28')](removeEntity(_0x217fda,null))[_0x176c('0x4e')](handleError(_0x217fda,null));};exports[_0x176c('0x58')]=function(_0x245032,_0x13b526){return db[_0x176c('0x32')]['describe']()['then'](respondWithResult(_0x13b526,null))['catch'](handleError(_0x13b526,null));};exports[_0x176c('0x59')]=function(_0x4b868b,_0x39a821,_0x24a2e7){if(_0x4b868b['body']['id']){delete _0x4b868b[_0x176c('0x57')]['id'];}return db[_0x176c('0x32')][_0x176c('0x4d')]({'where':{'id':_0x4b868b[_0x176c('0x4a')]['id']}})[_0x176c('0x28')](handleEntityNotFound(_0x39a821,null))[_0x176c('0x28')](function(_0x78fa08){if(_0x78fa08){_0x4b868b[_0x176c('0x57')][_0x176c('0x5a')]=_0x78fa08['id'];return db[_0x176c('0x5b')][_0x176c('0x4f')](_0x4b868b[_0x176c('0x57')]);}})[_0x176c('0x28')](respondWithResult(_0x39a821,null))[_0x176c('0x4e')](handleError(_0x39a821,null));};exports[_0x176c('0x5c')]=function(_0x2247bb,_0x26bd26,_0x165a45){var _0x44ec11={'raw':![],'where':{}};var _0x4df801={};var _0x1949e1={'count':0x0,'rows':[]};return db[_0x176c('0x32')][_0x176c('0x5d')]({'where':{'id':_0x2247bb[_0x176c('0x4a')]['id']}})[_0x176c('0x28')](handleEntityNotFound(_0x26bd26,null))[_0x176c('0x28')](function(_0x16bbe2){if(_0x16bbe2){_0x4df801[_0x176c('0x35')]=_[_0x176c('0x38')](db[_0x176c('0x5b')][_0x176c('0x4b')]);_0x4df801[_0x176c('0x37')]=_[_0x176c('0x38')](_0x2247bb[_0x176c('0x37')]);_0x4df801['filters']=_[_0x176c('0x3a')](_0x4df801[_0x176c('0x35')],_0x4df801[_0x176c('0x37')]);_0x44ec11['attributes']=_[_0x176c('0x3a')](_0x4df801['model'],qs[_0x176c('0x3b')](_0x2247bb[_0x176c('0x37')]['fields']));_0x44ec11[_0x176c('0x3c')]=_0x44ec11[_0x176c('0x3c')][_0x176c('0x5e')]?_0x44ec11[_0x176c('0x3c')]:_0x4df801[_0x176c('0x35')];if(!_0x2247bb[_0x176c('0x37')][_0x176c('0x3d')](_0x176c('0x3e'))){_0x44ec11[_0x176c('0x1f')]=qs['limit'](_0x2247bb[_0x176c('0x37')][_0x176c('0x1f')]);_0x44ec11[_0x176c('0x21')]=qs[_0x176c('0x21')](_0x2247bb[_0x176c('0x37')][_0x176c('0x21')]);}_0x44ec11['order']=qs[_0x176c('0x40')](_0x2247bb[_0x176c('0x37')][_0x176c('0x40')]);_0x44ec11['where']=qs['filters'](_[_0x176c('0x5f')](_0x2247bb[_0x176c('0x37')],_0x4df801[_0x176c('0x39')]));_0x44ec11[_0x176c('0x41')][_0x176c('0x5a')]=_0x16bbe2['id'];if(_0x2247bb[_0x176c('0x37')]['filter']){_0x44ec11[_0x176c('0x41')]=_[_0x176c('0x43')](_0x44ec11['where'],{'$or':_[_0x176c('0x36')](_0x44ec11[_0x176c('0x3c')],function(_0x455b8d){var _0xec1386={};_0xec1386[_0x455b8d]={'$like':'%'+_0x2247bb['query'][_0x176c('0x42')]+'%'};return _0xec1386;})});}_0x44ec11=_['merge']({},_0x44ec11,_0x2247bb['options']);return db[_0x176c('0x5b')][_0x176c('0x20')]({'where':_0x44ec11[_0x176c('0x41')]})[_0x176c('0x28')](function(_0x1a1194){_0x1949e1[_0x176c('0x20')]=_0x1a1194;if(_0x2247bb[_0x176c('0x37')][_0x176c('0x46')]){_0x44ec11[_0x176c('0x4c')]=[{'all':!![]}];}return db[_0x176c('0x5b')][_0x176c('0x47')](_0x44ec11);})['then'](function(_0x2783de){_0x1949e1[_0x176c('0x48')]=_0x2783de;return _0x1949e1;});}})[_0x176c('0x28')](respondWithFilteredResult(_0x26bd26,_0x44ec11))[_0x176c('0x4e')](handleError(_0x26bd26,null));};exports['removeDispositions']=function(_0x207206,_0x490cf8,_0x26594e){return db['CmList']['find']({'where':{'id':_0x207206[_0x176c('0x4a')]['id']}})['then'](handleEntityNotFound(_0x490cf8,null))[_0x176c('0x28')](function(_0x55bfd4){if(_0x55bfd4){return _0x55bfd4[_0x176c('0x60')](_0x207206[_0x176c('0x37')][_0x176c('0x61')]);}})[_0x176c('0x28')](respondWithStatusCode(_0x490cf8,null))[_0x176c('0x4e')](handleError(_0x490cf8,null));};exports[_0x176c('0x62')]=function(_0x115850,_0x6ef15c,_0x494375){return db['CmList'][_0x176c('0x4d')]({'where':{'id':_0x115850[_0x176c('0x4a')]['id']}})[_0x176c('0x28')](handleEntityNotFound(_0x6ef15c,null))['then'](function(_0x987f75){if(_0x987f75){var _0x32fdff=[];var _0x11c8e2={'success':[],'errors':[]};return db[_0x176c('0x63')][_0x176c('0x58')]()[_0x176c('0x28')](function(_0x2161de){if(_0x115850[_0x176c('0x57')]['tags']&&_['isArray'](_0x115850[_0x176c('0x57')][_0x176c('0x64')])){if(_0x115850[_0x176c('0x57')][_0x176c('0x64')][_0x176c('0x5e')]){_0x115850[_0x176c('0x57')][_0x176c('0x64')]=_0x115850[_0x176c('0x57')][_0x176c('0x64')][_0x176c('0x65')](';')+';';}else{_0x115850[_0x176c('0x57')][_0x176c('0x64')]=null;}}else{_0x115850['body'][_0x176c('0x64')]=null;}if(_0x115850[_0x176c('0x57')]&&_[_0x176c('0x66')](_0x115850[_0x176c('0x57')])){for(var _0x41ce6f=0x0;_0x41ce6f<_0x115850['body']['length'];_0x41ce6f+=0x1){_0x115850[_0x176c('0x57')][_0x41ce6f][_0x176c('0x5a')]=_0x115850[_0x176c('0x4a')]['id'];_0x32fdff['push'](_0x115850[_0x176c('0x57')][_0x41ce6f]);}return BPromise['each'](_0x32fdff,function(_0x2c3857){return db[_0x176c('0x63')][_0x176c('0x4f')](_[_0x176c('0x67')](_0x2c3857,[_0x176c('0x61'),'id'])||{},{'fields':_[_0x176c('0x38')](_0x2161de),'raw':!![]})[_0x176c('0x28')](function(_0x212194){_0x11c8e2[_0x176c('0x68')]['push'](_0x212194[_0x176c('0x69')]);})[_0x176c('0x4e')](function(_0x288050){_0x11c8e2['errors'][_0x176c('0x6a')]({'data':_0x2c3857,'error':_0x288050['message']});});})[_0x176c('0x28')](function(_0xc6779d){return _0x11c8e2;})[_0x176c('0x4e')](function(_0x1fea6a){return _0x1fea6a;});}else{_0x6ef15c[_0x176c('0x1b')](0x190)[_0x176c('0x1d')]({'message':_0x176c('0x6b')});}});}})[_0x176c('0x28')](respondWithResult(_0x6ef15c,null))['catch'](handleError(_0x6ef15c,null));};exports[_0x176c('0x6c')]=function(_0x18e0f7,_0x10f3d8,_0x1df7c7){var _0x22bb4b;return db['CmList'][_0x176c('0x4d')]({'where':{'id':_0x18e0f7[_0x176c('0x4a')]['id']},'include':[{'model':db[_0x176c('0x6d')],'as':'CustomFields'}]})[_0x176c('0x28')](handleEntityNotFound(_0x10f3d8,null))[_0x176c('0x28')](function(_0x5be476){if(_0x5be476){_0x22bb4b=_0x5be476;return db[_0x176c('0x63')][_0x176c('0x4b')];}})[_0x176c('0x28')](function(_0x4f76bf){if(_0x4f76bf){var _0x215ce8={};var _0x1b285e={};_0x1b285e['model']=_[_0x176c('0x6e')](_[_0x176c('0x38')](_0x4f76bf),_[_0x176c('0x36')](_0x22bb4b[_0x176c('0x6f')],function(_0x5b88a7){return util[_0x176c('0x70')](_0x176c('0x71'),_0x5b88a7['id']);}));_0x1b285e[_0x176c('0x37')]=_[_0x176c('0x38')](_0x18e0f7[_0x176c('0x37')]);_0x1b285e[_0x176c('0x39')]=_[_0x176c('0x3a')](_0x1b285e['model'],_0x1b285e[_0x176c('0x37')]);_0x215ce8[_0x176c('0x3c')]=_[_0x176c('0x3a')](_0x1b285e[_0x176c('0x35')],qs['fields'](_0x18e0f7[_0x176c('0x37')][_0x176c('0x3b')]));_0x215ce8[_0x176c('0x3c')]=_0x215ce8[_0x176c('0x3c')][_0x176c('0x5e')]?_0x215ce8['attributes']:_0x1b285e['model'];if(!_0x18e0f7['query'][_0x176c('0x3d')](_0x176c('0x3e'))){_0x215ce8[_0x176c('0x1f')]=qs[_0x176c('0x1f')](_0x18e0f7[_0x176c('0x37')][_0x176c('0x1f')]);_0x215ce8['offset']=qs[_0x176c('0x21')](_0x18e0f7[_0x176c('0x37')][_0x176c('0x21')]);}_0x215ce8[_0x176c('0x3f')]=qs[_0x176c('0x40')](_0x18e0f7[_0x176c('0x37')][_0x176c('0x40')]);_0x215ce8[_0x176c('0x41')]=qs[_0x176c('0x39')](_['pick'](_0x18e0f7[_0x176c('0x37')],_0x1b285e[_0x176c('0x39')]));_0x215ce8['raw']=!![];if(_0x18e0f7[_0x176c('0x37')][_0x176c('0x42')]){_0x215ce8['where']=_[_0x176c('0x43')](_0x215ce8[_0x176c('0x41')],{'$or':_[_0x176c('0x36')](_0x215ce8[_0x176c('0x3c')],function(_0x1942db){var _0x4e2cb5={};_0x4e2cb5[_0x1942db]={'$like':'%'+_0x18e0f7[_0x176c('0x37')][_0x176c('0x42')]+'%'};return _0x4e2cb5;})});}_0x215ce8=_[_0x176c('0x43')]({},_0x215ce8,_0x18e0f7['options']);return _0x22bb4b[_0x176c('0x6c')](_0x215ce8);}})[_0x176c('0x28')](respondWithResult(_0x10f3d8,null))[_0x176c('0x4e')](handleError(_0x10f3d8,null));};exports[_0x176c('0x72')]=function(_0x1010cb,_0x1e329c,_0x267c0b){var _0x335645;var _0x5b0f34;var _0x5a9db0;var _0x31ba97=_0x1010cb[_0x176c('0x4a')]['id'];csv_results=[];return db[_0x176c('0x73')][_0x176c('0x47')]({'attributes':['id','name'],'raw':!![],'order':[_0x176c('0x74')]})[_0x176c('0x28')](function(_0x35bfee){_0x335645=_0x35bfee;var _0x589e09=_[_0x176c('0x38')](db[_0x176c('0x63')]['rawAttributes']);return db[_0x176c('0x6d')][_0x176c('0x47')]({'raw':!![],'attributes':['id',_0x176c('0x75')]})['then'](function(_0x4d3bd1){_0x5b0f34=_0x4d3bd1;var _0x346144=squel[_0x176c('0x76')]()[_0x176c('0x3b')](_0x589e09)[_0x176c('0x77')](_0x176c('0x78'),'c')[_0x176c('0x41')](_0x176c('0x79'),_0x31ba97)['where']('c.deletedAt\x20is\x20null')[_0x176c('0x7a')]();for(var _0x249c5c=0x0;_0x249c5c<_0x5b0f34[_0x176c('0x5e')];_0x249c5c++){_0x346144[_0x176c('0x7b')](_0x176c('0x7c')+_0x5b0f34[_0x249c5c]['id'],_0x176c('0x7d')+_0x5b0f34[_0x249c5c][_0x176c('0x75')]);}for(var _0x249c5c=0x0;_0x249c5c<_0x335645[_0x176c('0x5e')];_0x249c5c++){_0x346144[_0x176c('0x7b')](squel[_0x176c('0x76')]()['field'](_0x176c('0x7e'))[_0x176c('0x77')](_0x176c('0x7f'))[_0x176c('0x41')](_0x176c('0x80'),_0x335645[_0x249c5c]['id'])[_0x176c('0x41')](_0x176c('0x81')),_0x176c('0x82')+_0x335645[_0x249c5c][_0x176c('0x2f')]);_0x346144[_0x176c('0x7b')](squel[_0x176c('0x76')]()[_0x176c('0x7b')](_0x176c('0x83'))[_0x176c('0x77')]('cm_contact_has_items')['where'](_0x176c('0x80'),_0x335645[_0x249c5c]['id'])[_0x176c('0x41')](_0x176c('0x81')),_0x176c('0x84')+_0x335645[_0x249c5c][_0x176c('0x2f')]);}var _0xca83cd=[];_0xca83cd[_0x176c('0x6a')](_0x346144[_0x176c('0x85')]());BPromise[_0x176c('0x86')](_0xca83cd,handleQuery)[_0x176c('0x28')](function(_0x5cf33c){handleQuery(_0x346144[_0x176c('0x85')]());var _0xbed520=csv_results[0x0];if(!_[_0x176c('0x87')](_0xbed520)){var _0x371d54=toCsv(_0xbed520);var _0x19f84f=Date['now']();fs['writeFileSync'](util[_0x176c('0x70')](_0x176c('0x88'),_0x31ba97,_0x19f84f),_0x371d54);_0x1e329c[_0x176c('0x89')](_0x176c('0x8a'),_0x176c('0x8b')+util['format'](_0x176c('0x8c'),_0x31ba97,_0x19f84f));_0x1e329c[_0x176c('0x89')](_0x176c('0x8d'),_0x176c('0x8e'));return _0x1e329c[_0x176c('0x8f')](util[_0x176c('0x70')](_0x176c('0x88'),_0x31ba97,_0x19f84f));}else{return _0x1e329c[_0x176c('0x2c')](0xcc);}});});});};exports['addCustomField']=function(_0x12059f,_0x3aedb9,_0x1abd59){var _0x1ad4a3;delete _0x12059f['body']['id'];return db[_0x176c('0x32')]['findOne']({'where':{'id':_0x12059f[_0x176c('0x4a')]['id']}})[_0x176c('0x28')](handleEntityNotFound(_0x3aedb9,null))[_0x176c('0x28')](function(_0x22418a){if(_0x22418a){return db[_0x176c('0x90')][_0x176c('0x91')](function(_0x5449bc){return db['CmCustomField'][_0x176c('0x4f')](_0x12059f[_0x176c('0x57')],{'transaction':_0x5449bc})['then'](function(_0x20a4c1){_0x1ad4a3=_0x20a4c1;return _0x22418a[_0x176c('0x92')](_0x20a4c1,{'transaction':_0x5449bc});})['then'](function(){var _0x45be4d={'type':db[_0x176c('0x93')][_0x176c('0x94')],'transaction':_0x5449bc};switch(_0x12059f['body'][_0x176c('0x33')]){case _0x176c('0x95'):_0x45be4d['type']=db['Sequelize'][_0x176c('0x94')];break;case _0x176c('0x96'):_0x45be4d[_0x176c('0x33')]=db['Sequelize'][_0x176c('0x97')];break;case _0x176c('0x98'):_0x45be4d[_0x176c('0x33')]=db[_0x176c('0x93')][_0x176c('0x99')];_0x45be4d['defaultValue']=![];break;default:}return db[_0x176c('0x90')][_0x176c('0x9a')][_0x176c('0x9b')](_0x176c('0x78'),util[_0x176c('0x70')]('cf_%s',_0x1ad4a3['id']),_0x45be4d);})['then'](function(){return _0x1ad4a3;});});}})[_0x176c('0x28')](respondWithResult(_0x3aedb9,null))[_0x176c('0x4e')](handleError(_0x3aedb9,null));};exports[_0x176c('0x9c')]=function(_0xedba98,_0x264717,_0x41c87b){var _0x47d429={};var _0x31eedd={};var _0x1ddaa0;var _0x547273;return db[_0x176c('0x32')][_0x176c('0x5d')]({'where':{'id':_0xedba98['params']['id']}})[_0x176c('0x28')](handleEntityNotFound(_0x264717,null))[_0x176c('0x28')](function(_0x1a2710){if(_0x1a2710){_0x1ddaa0=_0x1a2710;_0x31eedd[_0x176c('0x35')]=_['keys'](db[_0x176c('0x6d')][_0x176c('0x4b')]);_0x31eedd[_0x176c('0x37')]=_['keys'](_0xedba98['query']);_0x31eedd[_0x176c('0x39')]=_[_0x176c('0x3a')](_0x31eedd[_0x176c('0x35')],_0x31eedd[_0x176c('0x37')]);_0x47d429[_0x176c('0x3c')]=_[_0x176c('0x3a')](_0x31eedd[_0x176c('0x35')],qs[_0x176c('0x3b')](_0xedba98[_0x176c('0x37')][_0x176c('0x3b')]));_0x47d429['attributes']=_0x47d429[_0x176c('0x3c')]['length']?_0x47d429[_0x176c('0x3c')]:_0x31eedd[_0x176c('0x35')];_0x47d429[_0x176c('0x3f')]=qs['sort'](_0xedba98['query']['sort']);_0x47d429[_0x176c('0x41')]=qs[_0x176c('0x39')](_[_0x176c('0x5f')](_0xedba98[_0x176c('0x37')],_0x31eedd[_0x176c('0x39')]));_0x47d429['where']=_['merge'](_0x47d429[_0x176c('0x41')],{'$or':[{'ListId':_0x1a2710['id']},{'ListId':null}]});if(_0xedba98[_0x176c('0x37')]['filter']){_0x47d429['where']=_['merge'](_0x47d429[_0x176c('0x41')],{'$or':_[_0x176c('0x36')](_0x47d429['attributes'],function(_0x464d70){var _0x32e0a5={};_0x32e0a5[_0x464d70]={'$like':'%'+_0xedba98[_0x176c('0x37')][_0x176c('0x42')]+'%'};return _0x32e0a5;})});}_0x47d429=_[_0x176c('0x43')]({},_0x47d429,_0xedba98[_0x176c('0x45')]);return db[_0x176c('0x6d')][_0x176c('0x9d')](_0x47d429);}})[_0x176c('0x28')](respondWithResult(_0x264717,null))['catch'](handleError(_0x264717,null));};exports['getGlobalCustomFields']=function(_0x1359af,_0x3082df){return db[_0x176c('0x6d')]['findAndCountAll']({'where':{'ListId':null}})['then'](handleEntityNotFound(_0x3082df,null))[_0x176c('0x28')](function(_0x19b2cd){return _0x19b2cd;})[_0x176c('0x28')](respondWithResult(_0x3082df,null))[_0x176c('0x4e')](handleError(_0x3082df,null));};exports[_0x176c('0x9e')]=function(_0x5b5f29,_0x393ca2,_0x20c529){return db[_0x176c('0x32')][_0x176c('0x4d')]({'where':{'id':_0x5b5f29['params']['id']}})['then'](handleEntityNotFound(_0x393ca2,null))[_0x176c('0x28')](function(_0x297601){if(_0x297601){return _0x297601['addAgents'](_0x5b5f29[_0x176c('0x57')][_0x176c('0x61')],_[_0x176c('0x67')](_0x5b5f29[_0x176c('0x57')],[_0x176c('0x61'),'id'])||{})['spread'](function(_0x1e2423){for(var _0x1922b8=0x0;_0x1922b8<_0x5b5f29[_0x176c('0x57')][_0x176c('0x61')][_0x176c('0x5e')];_0x1922b8+=0x1){socket[_0x176c('0x9f')](_0x176c('0xa0'),{'UserId':Number(_0x5b5f29[_0x176c('0x57')][_0x176c('0x61')][_0x1922b8]),'CmListId':Number(_0x5b5f29[_0x176c('0x4a')]['id'])});}return _0x1e2423;});}})[_0x176c('0x28')](respondWithResult(_0x393ca2,null))[_0x176c('0x4e')](handleError(_0x393ca2,null));};exports[_0x176c('0xa1')]=function(_0xd9debd,_0xf1f0e6,_0x10a130){return db['CmList'][_0x176c('0x4d')]({'where':{'id':_0xd9debd[_0x176c('0x4a')]['id']}})[_0x176c('0x28')](handleEntityNotFound(_0xf1f0e6,null))['then'](function(_0x55faa8){if(_0x55faa8){return _0x55faa8[_0x176c('0xa1')](_0xd9debd[_0x176c('0x37')][_0x176c('0x61')])[_0x176c('0x28')](function(){if(_[_0x176c('0x66')](_0xd9debd[_0x176c('0x37')][_0x176c('0x61')])){for(var _0x46f16b=0x0;_0x46f16b<_0xd9debd[_0x176c('0x37')][_0x176c('0x61')][_0x176c('0x5e')];_0x46f16b+=0x1){socket[_0x176c('0x9f')](_0x176c('0xa2'),{'UserId':Number(_0xd9debd[_0x176c('0x37')]['ids'][_0x46f16b]),'CmListId':Number(_0xd9debd['params']['id'])});}}else{socket['emit'](_0x176c('0xa2'),{'UserId':Number(_0xd9debd[_0x176c('0x37')][_0x176c('0x61')]),'CmListId':Number(_0xd9debd['params']['id'])});}});}})[_0x176c('0x28')](respondWithStatusCode(_0xf1f0e6,null))['catch'](handleError(_0xf1f0e6,null));};exports[_0x176c('0xa3')]=function(_0x4ba669,_0x548280,_0x2fccb9){var _0x4beb5c={};var _0x279ecb={};var _0x32cc4f;var _0x2f7255;return db[_0x176c('0x32')][_0x176c('0x5d')]({'where':{'id':_0x4ba669['params']['id']}})['then'](handleEntityNotFound(_0x548280,null))['then'](function(_0x9f6abe){if(_0x9f6abe){_0x32cc4f=_0x9f6abe;_0x279ecb[_0x176c('0x35')]=_[_0x176c('0x38')](db[_0x176c('0xa4')][_0x176c('0x4b')]);_0x279ecb[_0x176c('0x37')]=_[_0x176c('0x38')](_0x4ba669['query']);_0x279ecb[_0x176c('0x39')]=_[_0x176c('0x3a')](_0x279ecb[_0x176c('0x35')],_0x279ecb[_0x176c('0x37')]);_0x4beb5c['attributes']=_[_0x176c('0x3a')](_0x279ecb[_0x176c('0x35')],qs[_0x176c('0x3b')](_0x4ba669[_0x176c('0x37')]['fields']));_0x4beb5c[_0x176c('0x3c')]=_0x4beb5c['attributes'][_0x176c('0x5e')]?_0x4beb5c[_0x176c('0x3c')]:_0x279ecb[_0x176c('0x35')];_0x4beb5c[_0x176c('0x3f')]=qs[_0x176c('0x40')](_0x4ba669[_0x176c('0x37')][_0x176c('0x40')]);_0x4beb5c['where']=qs[_0x176c('0x39')](_['pick'](_0x4ba669[_0x176c('0x37')],_0x279ecb['filters']));if(_0x4ba669[_0x176c('0x37')]['filter']){_0x4beb5c[_0x176c('0x41')]=_['merge'](_0x4beb5c[_0x176c('0x41')],{'$or':_['map'](_0x4beb5c[_0x176c('0x3c')],function(_0x2db8cc){var _0x360e92={};_0x360e92[_0x2db8cc]={'$like':'%'+_0x4ba669[_0x176c('0x37')][_0x176c('0x42')]+'%'};return _0x360e92;})});}_0x4beb5c=_['merge']({},_0x4beb5c,_0x4ba669[_0x176c('0x45')]);return _0x32cc4f['getAgents'](_0x4beb5c);}})['then'](function(_0xc2ab87){if(_0xc2ab87){_0x2f7255=_0xc2ab87[_0x176c('0x5e')];if(!_0x4ba669[_0x176c('0x37')][_0x176c('0x3d')](_0x176c('0x3e'))){_0x4beb5c[_0x176c('0x1f')]=qs[_0x176c('0x1f')](_0x4ba669['query'][_0x176c('0x1f')]);_0x4beb5c['offset']=qs[_0x176c('0x21')](_0x4ba669[_0x176c('0x37')][_0x176c('0x21')]);}return _0x32cc4f['getAgents'](_0x4beb5c);}})[_0x176c('0x28')](function(_0x316c1e){if(_0x316c1e){return _0x316c1e?{'count':_0x2f7255,'rows':_0x316c1e}:null;}})[_0x176c('0x28')](respondWithResult(_0x548280,null))[_0x176c('0x4e')](handleError(_0x548280,null));};function handleQuery(_0x4e71ec){logger[_0x176c('0xa5')](_0x4e71ec);return db[_0x176c('0x90')][_0x176c('0x37')](_0x4e71ec)['spread'](function(_0x2fae01){csv_results[_0x176c('0x6a')](_0x2fae01);})[_0x176c('0x4e')](function(_0x5d6fdd){logger[_0x176c('0x2d')](_0x5d6fdd[_0x176c('0xa6')]);});}
\ No newline at end of file
+var _0xad95=['keys','filters','intersection','query','attributes','length','hasOwnProperty','nolimit','sort','where','pick','filter','VIRTUAL','merge','options','includeAll','include','findAll','rows','catch','show','fields','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','UserProfileSection','find','userProfileId','UserProfileResource','create','error','body','params','describe','addDisposition','ListId','Disposition','getDispositions','findOne','order','removeDispositions','ids','addContacts','CmContact','tags','isArray','join','each','omit','success','push','errors','message','Malformed\x20request\x20syntax','getContacts','CmCustomField','CustomFields','concat','getContactsCsv','OrderBy','alias','select','cm_contacts','c.ListId\x20=\x20?','field','c.cf_','item','from','cm_contact_has_items','ItemTypeId\x20=\x20?','CmContactId\x20=\x20c.id','additionalPhone_','description','description_additionalPhone_','toString','isEmpty','now','writeFileSync','format','/tmp/list_%d_%s.csv','list_%d_%s.csv','setHeader','Content-type','text/csv','download','transaction','addCustomFields','text','Sequelize','TEXT','number','INTEGER','defaultValue','sequelize','queryInterface','addColumn','cf_%s','getCustomFields','findAndCountAll','getGlobalCustomFields','addAgents','spread','emit','userCmList:save','removeAgents','userCmList:remove','getAgents','User','eml-format','zip-dir','bluebird','mustache','util','path','sox','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','to-csv','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../mysqldb','redis','defaults','socket.io-emitter','./cmList.socket','register','sendStatus','end','status','offset','limit','undefined','count','set','Content-Range','json','apply','update','then','destroy','get','Lists','stack','name','send','index','map','CmList','rawAttributes','fieldName','type','key','model'];(function(_0x2a4fe2,_0x3ec53a){var _0x225c4a=function(_0x1eccfa){while(--_0x1eccfa){_0x2a4fe2['push'](_0x2a4fe2['shift']());}};_0x225c4a(++_0x3ec53a);}(_0xad95,0x1b1));var _0x5ad9=function(_0x2bc34d,_0x6c5eef){_0x2bc34d=_0x2bc34d-0x0;var _0x18ce7d=_0xad95[_0x2bc34d];return _0x18ce7d;};'use strict';var emlformat=require(_0x5ad9('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x5ad9('0x1'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0x5ad9('0x2'));var Mustache=require(_0x5ad9('0x3'));var util=require(_0x5ad9('0x4'));var path=require(_0x5ad9('0x5'));var sox=require(_0x5ad9('0x6'));var csv=require('to-csv');var ejs=require(_0x5ad9('0x7'));var fs=require('fs');var fs_extra=require(_0x5ad9('0x8'));var _=require(_0x5ad9('0x9'));var squel=require(_0x5ad9('0xa'));var crypto=require(_0x5ad9('0xb'));var jsforce=require(_0x5ad9('0xc'));var deskjs=require(_0x5ad9('0xd'));var toCsv=require(_0x5ad9('0xe'));var querystring=require('querystring');var Papa=require(_0x5ad9('0xf'));var Redis=require('ioredis');var authService=require(_0x5ad9('0x10'));var qs=require(_0x5ad9('0x11'));var as=require(_0x5ad9('0x12'));var hardwareService=require(_0x5ad9('0x13'));var logger=require(_0x5ad9('0x14'))(_0x5ad9('0x15'));var utils=require('../../config/utils');var config=require(_0x5ad9('0x16'));var licenseUtil=require('../../config/license/util');var db=require(_0x5ad9('0x17'))['db'];var csv_results;config[_0x5ad9('0x18')]=_[_0x5ad9('0x19')](config['redis'],{'host':'localhost','port':0x18eb});var socket=require(_0x5ad9('0x1a'))(new Redis(config[_0x5ad9('0x18')]));require(_0x5ad9('0x1b'))[_0x5ad9('0x1c')](socket);function respondWithStatusCode(_0x4ade7f,_0x1e7d86){_0x1e7d86=_0x1e7d86||0xcc;return function(_0x3d70ee){if(_0x3d70ee){return _0x4ade7f[_0x5ad9('0x1d')](_0x1e7d86);}return _0x4ade7f['status'](_0x1e7d86)[_0x5ad9('0x1e')]();};}function respondWithResult(_0x219490,_0x489832){_0x489832=_0x489832||0xc8;return function(_0x20025f){if(_0x20025f){return _0x219490[_0x5ad9('0x1f')](_0x489832)['json'](_0x20025f);}};}function respondWithFilteredResult(_0x410830,_0x3d54de){return function(_0x2693b1){if(_0x2693b1){var _0x20e6f6=typeof _0x3d54de[_0x5ad9('0x20')]==='undefined'&&typeof _0x3d54de[_0x5ad9('0x21')]===_0x5ad9('0x22');var _0x5efa03=_0x2693b1[_0x5ad9('0x23')];var _0x585f7e=_0x20e6f6?0x0:_0x3d54de[_0x5ad9('0x20')];var _0x52688a=_0x20e6f6?_0x2693b1[_0x5ad9('0x23')]:_0x3d54de[_0x5ad9('0x20')]+_0x3d54de[_0x5ad9('0x21')];var _0x624a6;if(_0x52688a>=_0x5efa03){_0x52688a=_0x5efa03;_0x624a6=0xc8;}else{_0x624a6=0xce;}_0x410830[_0x5ad9('0x1f')](_0x624a6);return _0x410830[_0x5ad9('0x24')](_0x5ad9('0x25'),_0x585f7e+'-'+_0x52688a+'/'+_0x5efa03)[_0x5ad9('0x26')](_0x2693b1);}return null;};}function patchUpdates(_0x449971){return function(_0x2327ea){try{jsonpatch[_0x5ad9('0x27')](_0x2327ea,_0x449971,!![]);}catch(_0x1a4e55){return BPromise['reject'](_0x1a4e55);}return _0x2327ea['save']();};}function saveUpdates(_0x361ee1,_0x2e1cc8){return function(_0x3cf29f){if(_0x3cf29f){return _0x3cf29f[_0x5ad9('0x28')](_0x361ee1)[_0x5ad9('0x29')](function(_0x483081){return _0x483081;});}return null;};}function removeEntity(_0x2e1a55,_0x36ba95){return function(_0x3a4980){if(_0x3a4980){return _0x3a4980[_0x5ad9('0x2a')]()['then'](function(){var _0x264be8=_0x3a4980[_0x5ad9('0x2b')]({'plain':!![]});var _0x385de7=_0x5ad9('0x2c');return db['UserProfileResource'][_0x5ad9('0x2a')]({'where':{'type':_0x385de7,'resourceId':_0x264be8['id']}})[_0x5ad9('0x29')](function(){return _0x3a4980;});})[_0x5ad9('0x29')](function(){_0x2e1a55[_0x5ad9('0x1f')](0xcc)[_0x5ad9('0x1e')]();});}};}function handleEntityNotFound(_0x32f79b,_0x4688f8){return function(_0x3417e5){if(!_0x3417e5){_0x32f79b['sendStatus'](0x194);}return _0x3417e5;};}function handleError(_0x3692ee,_0x4f86c9){_0x4f86c9=_0x4f86c9||0x1f4;return function(_0x3d38dd){logger['error'](_0x3d38dd[_0x5ad9('0x2d')]);if(_0x3d38dd[_0x5ad9('0x2e')]){delete _0x3d38dd['name'];}_0x3692ee['status'](_0x4f86c9)[_0x5ad9('0x2f')](_0x3d38dd);};}exports[_0x5ad9('0x30')]=function(_0x1f8130,_0x546a4b){var _0x3b171f={},_0x9d4bef={},_0x3c5ae2={'count':0x0,'rows':[]};var _0x4f3e68=_[_0x5ad9('0x31')](db[_0x5ad9('0x32')][_0x5ad9('0x33')],function(_0x86b044){return{'name':_0x86b044[_0x5ad9('0x34')],'type':_0x86b044[_0x5ad9('0x35')][_0x5ad9('0x36')]};});_0x9d4bef[_0x5ad9('0x37')]=_[_0x5ad9('0x31')](_0x4f3e68,_0x5ad9('0x2e'));_0x9d4bef['query']=_[_0x5ad9('0x38')](_0x1f8130['query']);_0x9d4bef[_0x5ad9('0x39')]=_[_0x5ad9('0x3a')](_0x9d4bef[_0x5ad9('0x37')],_0x9d4bef[_0x5ad9('0x3b')]);_0x3b171f[_0x5ad9('0x3c')]=_[_0x5ad9('0x3a')](_0x9d4bef[_0x5ad9('0x37')],qs['fields'](_0x1f8130[_0x5ad9('0x3b')]['fields']));_0x3b171f[_0x5ad9('0x3c')]=_0x3b171f['attributes'][_0x5ad9('0x3d')]?_0x3b171f[_0x5ad9('0x3c')]:_0x9d4bef[_0x5ad9('0x37')];if(!_0x1f8130['query'][_0x5ad9('0x3e')](_0x5ad9('0x3f'))){_0x3b171f[_0x5ad9('0x21')]=qs[_0x5ad9('0x21')](_0x1f8130[_0x5ad9('0x3b')][_0x5ad9('0x21')]);_0x3b171f[_0x5ad9('0x20')]=qs[_0x5ad9('0x20')](_0x1f8130['query']['offset']);}_0x3b171f['order']=qs[_0x5ad9('0x40')](_0x1f8130[_0x5ad9('0x3b')]['sort']);_0x3b171f[_0x5ad9('0x41')]=qs[_0x5ad9('0x39')](_[_0x5ad9('0x42')](_0x1f8130[_0x5ad9('0x3b')],_0x9d4bef['filters']),_0x4f3e68);if(_0x1f8130[_0x5ad9('0x3b')][_0x5ad9('0x43')]){_0x3b171f[_0x5ad9('0x41')]=_['merge'](_0x3b171f[_0x5ad9('0x41')],{'$or':_[_0x5ad9('0x31')](_0x4f3e68,function(_0x44273){if(_0x44273[_0x5ad9('0x35')]!==_0x5ad9('0x44')){var _0x3991b6={};_0x3991b6[_0x44273[_0x5ad9('0x2e')]]={'$like':'%'+_0x1f8130[_0x5ad9('0x3b')][_0x5ad9('0x43')]+'%'};return _0x3991b6;}})});}_0x3b171f=_[_0x5ad9('0x45')]({},_0x3b171f,_0x1f8130[_0x5ad9('0x46')]);var _0x20502f={'where':_0x3b171f['where']};return db['CmList'][_0x5ad9('0x23')](_0x20502f)[_0x5ad9('0x29')](function(_0x2ab120){_0x3c5ae2[_0x5ad9('0x23')]=_0x2ab120;if(_0x1f8130[_0x5ad9('0x3b')][_0x5ad9('0x47')]){_0x3b171f[_0x5ad9('0x48')]=[{'all':!![]}];}return db['CmList'][_0x5ad9('0x49')](_0x3b171f);})[_0x5ad9('0x29')](function(_0x2bfc39){_0x3c5ae2[_0x5ad9('0x4a')]=_0x2bfc39;return _0x3c5ae2;})['then'](respondWithFilteredResult(_0x546a4b,_0x3b171f))[_0x5ad9('0x4b')](handleError(_0x546a4b,null));};exports[_0x5ad9('0x4c')]=function(_0x4fbf8f,_0x1e37f5){var _0x1155dc={'raw':![],'where':{'id':_0x4fbf8f['params']['id']}},_0x1c9952={};_0x1c9952['model']=_[_0x5ad9('0x38')](db[_0x5ad9('0x32')][_0x5ad9('0x33')]);_0x1c9952[_0x5ad9('0x3b')]=_[_0x5ad9('0x38')](_0x4fbf8f[_0x5ad9('0x3b')]);_0x1c9952['filters']=_[_0x5ad9('0x3a')](_0x1c9952[_0x5ad9('0x37')],_0x1c9952[_0x5ad9('0x3b')]);_0x1155dc[_0x5ad9('0x3c')]=_[_0x5ad9('0x3a')](_0x1c9952[_0x5ad9('0x37')],qs[_0x5ad9('0x4d')](_0x4fbf8f[_0x5ad9('0x3b')]['fields']));_0x1155dc[_0x5ad9('0x3c')]=_0x1155dc[_0x5ad9('0x3c')][_0x5ad9('0x3d')]?_0x1155dc[_0x5ad9('0x3c')]:_0x1c9952[_0x5ad9('0x37')];if(_0x4fbf8f[_0x5ad9('0x3b')][_0x5ad9('0x47')]){_0x1155dc[_0x5ad9('0x48')]=[{'all':!![]}];}_0x1155dc=_[_0x5ad9('0x45')]({},_0x1155dc,_0x4fbf8f[_0x5ad9('0x46')]);return db[_0x5ad9('0x32')]['find'](_0x1155dc)['then'](handleEntityNotFound(_0x1e37f5,null))['then'](respondWithResult(_0x1e37f5,null))[_0x5ad9('0x4b')](handleError(_0x1e37f5,null));};exports['create']=function(_0xea5641,_0x17f0bb){return db[_0x5ad9('0x32')]['create'](_0xea5641['body'],{})[_0x5ad9('0x29')](function(_0x548557){var _0x13f315=_0xea5641[_0x5ad9('0x4e')][_0x5ad9('0x2b')]({'plain':!![]});if(!_0x13f315)throw new Error(_0x5ad9('0x4f'));if(_0x13f315['role']===_0x5ad9('0x4e')){var _0x25c076=_0x548557['get']({'plain':!![]});var _0x2e48e7=_0x5ad9('0x2c');return db[_0x5ad9('0x50')][_0x5ad9('0x51')]({'where':{'name':_0x2e48e7,'userProfileId':_0x13f315[_0x5ad9('0x52')]},'raw':!![]})[_0x5ad9('0x29')](function(_0x3d95a6){if(_0x3d95a6&&_0x3d95a6['autoAssociation']===0x0){return db[_0x5ad9('0x53')][_0x5ad9('0x54')]({'name':_0x25c076[_0x5ad9('0x2e')],'resourceId':_0x25c076['id'],'type':_0x3d95a6['name'],'sectionId':_0x3d95a6['id']},{})[_0x5ad9('0x29')](function(){return _0x548557;});}else{return _0x548557;}})['catch'](function(_0x1c8abb){logger[_0x5ad9('0x55')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x1c8abb);throw _0x1c8abb;});}return _0x548557;})[_0x5ad9('0x29')](respondWithResult(_0x17f0bb,0xc9))[_0x5ad9('0x4b')](handleError(_0x17f0bb,null));};exports[_0x5ad9('0x28')]=function(_0x13fe71,_0x5c1c4d){if(_0x13fe71[_0x5ad9('0x56')]['id']){delete _0x13fe71[_0x5ad9('0x56')]['id'];}return db['CmList'][_0x5ad9('0x51')]({'where':{'id':_0x13fe71[_0x5ad9('0x57')]['id']}})[_0x5ad9('0x29')](handleEntityNotFound(_0x5c1c4d,null))[_0x5ad9('0x29')](saveUpdates(_0x13fe71['body'],null))['then'](respondWithResult(_0x5c1c4d,null))[_0x5ad9('0x4b')](handleError(_0x5c1c4d,null));};exports[_0x5ad9('0x2a')]=function(_0x99314a,_0xff3722){return db[_0x5ad9('0x32')][_0x5ad9('0x51')]({'where':{'id':_0x99314a['params']['id']}})[_0x5ad9('0x29')](handleEntityNotFound(_0xff3722,null))['then'](removeEntity(_0xff3722,null))['catch'](handleError(_0xff3722,null));};exports['describe']=function(_0x20a1a4,_0x3b2649){return db[_0x5ad9('0x32')][_0x5ad9('0x58')]()[_0x5ad9('0x29')](respondWithResult(_0x3b2649,null))[_0x5ad9('0x4b')](handleError(_0x3b2649,null));};exports[_0x5ad9('0x59')]=function(_0x2dcb9f,_0x165079,_0x534fb7){if(_0x2dcb9f[_0x5ad9('0x56')]['id']){delete _0x2dcb9f['body']['id'];}return db[_0x5ad9('0x32')][_0x5ad9('0x51')]({'where':{'id':_0x2dcb9f['params']['id']}})['then'](handleEntityNotFound(_0x165079,null))['then'](function(_0x2f09cd){if(_0x2f09cd){_0x2dcb9f['body'][_0x5ad9('0x5a')]=_0x2f09cd['id'];return db[_0x5ad9('0x5b')]['create'](_0x2dcb9f[_0x5ad9('0x56')]);}})['then'](respondWithResult(_0x165079,null))['catch'](handleError(_0x165079,null));};exports[_0x5ad9('0x5c')]=function(_0x2215a0,_0x436df6,_0x3008aa){var _0xd393d9={'raw':![],'where':{}};var _0xba7981={};var _0x5e4284={'count':0x0,'rows':[]};return db[_0x5ad9('0x32')][_0x5ad9('0x5d')]({'where':{'id':_0x2215a0[_0x5ad9('0x57')]['id']}})[_0x5ad9('0x29')](handleEntityNotFound(_0x436df6,null))[_0x5ad9('0x29')](function(_0x38ee0a){if(_0x38ee0a){_0xba7981[_0x5ad9('0x37')]=_[_0x5ad9('0x38')](db[_0x5ad9('0x5b')][_0x5ad9('0x33')]);_0xba7981[_0x5ad9('0x3b')]=_['keys'](_0x2215a0[_0x5ad9('0x3b')]);_0xba7981[_0x5ad9('0x39')]=_[_0x5ad9('0x3a')](_0xba7981[_0x5ad9('0x37')],_0xba7981['query']);_0xd393d9[_0x5ad9('0x3c')]=_[_0x5ad9('0x3a')](_0xba7981[_0x5ad9('0x37')],qs['fields'](_0x2215a0[_0x5ad9('0x3b')]['fields']));_0xd393d9['attributes']=_0xd393d9[_0x5ad9('0x3c')][_0x5ad9('0x3d')]?_0xd393d9[_0x5ad9('0x3c')]:_0xba7981[_0x5ad9('0x37')];if(!_0x2215a0[_0x5ad9('0x3b')][_0x5ad9('0x3e')](_0x5ad9('0x3f'))){_0xd393d9[_0x5ad9('0x21')]=qs[_0x5ad9('0x21')](_0x2215a0[_0x5ad9('0x3b')][_0x5ad9('0x21')]);_0xd393d9[_0x5ad9('0x20')]=qs['offset'](_0x2215a0[_0x5ad9('0x3b')][_0x5ad9('0x20')]);}_0xd393d9[_0x5ad9('0x5e')]=qs[_0x5ad9('0x40')](_0x2215a0['query']['sort']);_0xd393d9[_0x5ad9('0x41')]=qs['filters'](_[_0x5ad9('0x42')](_0x2215a0[_0x5ad9('0x3b')],_0xba7981[_0x5ad9('0x39')]));_0xd393d9[_0x5ad9('0x41')][_0x5ad9('0x5a')]=_0x38ee0a['id'];if(_0x2215a0['query'][_0x5ad9('0x43')]){_0xd393d9[_0x5ad9('0x41')]=_[_0x5ad9('0x45')](_0xd393d9[_0x5ad9('0x41')],{'$or':_[_0x5ad9('0x31')](_0xd393d9['attributes'],function(_0x4f635f){var _0x8cd69f={};_0x8cd69f[_0x4f635f]={'$like':'%'+_0x2215a0[_0x5ad9('0x3b')]['filter']+'%'};return _0x8cd69f;})});}_0xd393d9=_[_0x5ad9('0x45')]({},_0xd393d9,_0x2215a0[_0x5ad9('0x46')]);return db[_0x5ad9('0x5b')][_0x5ad9('0x23')]({'where':_0xd393d9[_0x5ad9('0x41')]})[_0x5ad9('0x29')](function(_0x4966ca){_0x5e4284['count']=_0x4966ca;if(_0x2215a0[_0x5ad9('0x3b')][_0x5ad9('0x47')]){_0xd393d9['include']=[{'all':!![]}];}return db['Disposition'][_0x5ad9('0x49')](_0xd393d9);})[_0x5ad9('0x29')](function(_0x5a082b){_0x5e4284['rows']=_0x5a082b;return _0x5e4284;});}})[_0x5ad9('0x29')](respondWithFilteredResult(_0x436df6,_0xd393d9))[_0x5ad9('0x4b')](handleError(_0x436df6,null));};exports[_0x5ad9('0x5f')]=function(_0x326688,_0x2efe1e,_0x4df4c4){return db[_0x5ad9('0x32')]['find']({'where':{'id':_0x326688[_0x5ad9('0x57')]['id']}})[_0x5ad9('0x29')](handleEntityNotFound(_0x2efe1e,null))[_0x5ad9('0x29')](function(_0x30f354){if(_0x30f354){return _0x30f354['removeDispositions'](_0x326688[_0x5ad9('0x3b')][_0x5ad9('0x60')]);}})[_0x5ad9('0x29')](respondWithStatusCode(_0x2efe1e,null))[_0x5ad9('0x4b')](handleError(_0x2efe1e,null));};exports[_0x5ad9('0x61')]=function(_0x60efc1,_0xddc989,_0x561342){return db[_0x5ad9('0x32')][_0x5ad9('0x51')]({'where':{'id':_0x60efc1[_0x5ad9('0x57')]['id']}})[_0x5ad9('0x29')](handleEntityNotFound(_0xddc989,null))[_0x5ad9('0x29')](function(_0x595114){if(_0x595114){var _0x4155c6=[];var _0x5404af={'success':[],'errors':[]};return db[_0x5ad9('0x62')][_0x5ad9('0x58')]()[_0x5ad9('0x29')](function(_0x330784){if(_0x60efc1['body'][_0x5ad9('0x63')]&&_[_0x5ad9('0x64')](_0x60efc1[_0x5ad9('0x56')]['tags'])){if(_0x60efc1[_0x5ad9('0x56')][_0x5ad9('0x63')]['length']){_0x60efc1[_0x5ad9('0x56')]['tags']=_0x60efc1[_0x5ad9('0x56')]['tags'][_0x5ad9('0x65')](';')+';';}else{_0x60efc1[_0x5ad9('0x56')]['tags']=null;}}else{_0x60efc1['body']['tags']=null;}if(_0x60efc1[_0x5ad9('0x56')]&&_[_0x5ad9('0x64')](_0x60efc1['body'])){for(var _0x4ff148=0x0;_0x4ff148<_0x60efc1['body']['length'];_0x4ff148+=0x1){_0x60efc1[_0x5ad9('0x56')][_0x4ff148][_0x5ad9('0x5a')]=_0x60efc1[_0x5ad9('0x57')]['id'];_0x4155c6['push'](_0x60efc1[_0x5ad9('0x56')][_0x4ff148]);}return BPromise[_0x5ad9('0x66')](_0x4155c6,function(_0x15ff10){return db[_0x5ad9('0x62')][_0x5ad9('0x54')](_[_0x5ad9('0x67')](_0x15ff10,[_0x5ad9('0x60'),'id'])||{},{'fields':_[_0x5ad9('0x38')](_0x330784),'raw':!![]})['then'](function(_0x1391fe){_0x5404af[_0x5ad9('0x68')][_0x5ad9('0x69')](_0x1391fe['dataValues']);})['catch'](function(_0x43da5e){_0x5404af[_0x5ad9('0x6a')][_0x5ad9('0x69')]({'data':_0x15ff10,'error':_0x43da5e[_0x5ad9('0x6b')]});});})[_0x5ad9('0x29')](function(_0x200ff9){return _0x5404af;})[_0x5ad9('0x4b')](function(_0x540b88){return _0x540b88;});}else{_0xddc989[_0x5ad9('0x1f')](0x190)['json']({'message':_0x5ad9('0x6c')});}});}})[_0x5ad9('0x29')](respondWithResult(_0xddc989,null))[_0x5ad9('0x4b')](handleError(_0xddc989,null));};exports[_0x5ad9('0x6d')]=function(_0x49b8e7,_0x50dc78,_0x390a65){var _0x2c80ac;return db[_0x5ad9('0x32')][_0x5ad9('0x51')]({'where':{'id':_0x49b8e7['params']['id']},'include':[{'model':db[_0x5ad9('0x6e')],'as':_0x5ad9('0x6f')}]})[_0x5ad9('0x29')](handleEntityNotFound(_0x50dc78,null))[_0x5ad9('0x29')](function(_0x55d7d5){if(_0x55d7d5){_0x2c80ac=_0x55d7d5;return db[_0x5ad9('0x62')][_0x5ad9('0x33')];}})[_0x5ad9('0x29')](function(_0x2c3f71){if(_0x2c3f71){var _0x357e9f={};var _0x33e63c={};_0x33e63c[_0x5ad9('0x37')]=_[_0x5ad9('0x70')](_[_0x5ad9('0x38')](_0x2c3f71),_[_0x5ad9('0x31')](_0x2c80ac[_0x5ad9('0x6f')],function(_0x3e5496){return util['format']('cf_%d',_0x3e5496['id']);}));_0x33e63c['query']=_[_0x5ad9('0x38')](_0x49b8e7[_0x5ad9('0x3b')]);_0x33e63c['filters']=_['intersection'](_0x33e63c[_0x5ad9('0x37')],_0x33e63c[_0x5ad9('0x3b')]);_0x357e9f[_0x5ad9('0x3c')]=_[_0x5ad9('0x3a')](_0x33e63c['model'],qs[_0x5ad9('0x4d')](_0x49b8e7[_0x5ad9('0x3b')][_0x5ad9('0x4d')]));_0x357e9f[_0x5ad9('0x3c')]=_0x357e9f['attributes'][_0x5ad9('0x3d')]?_0x357e9f[_0x5ad9('0x3c')]:_0x33e63c[_0x5ad9('0x37')];if(!_0x49b8e7[_0x5ad9('0x3b')][_0x5ad9('0x3e')](_0x5ad9('0x3f'))){_0x357e9f[_0x5ad9('0x21')]=qs['limit'](_0x49b8e7[_0x5ad9('0x3b')]['limit']);_0x357e9f['offset']=qs[_0x5ad9('0x20')](_0x49b8e7[_0x5ad9('0x3b')]['offset']);}_0x357e9f['order']=qs[_0x5ad9('0x40')](_0x49b8e7['query'][_0x5ad9('0x40')]);_0x357e9f[_0x5ad9('0x41')]=qs['filters'](_[_0x5ad9('0x42')](_0x49b8e7[_0x5ad9('0x3b')],_0x33e63c['filters']));_0x357e9f['raw']=!![];if(_0x49b8e7['query'][_0x5ad9('0x43')]){_0x357e9f[_0x5ad9('0x41')]=_[_0x5ad9('0x45')](_0x357e9f['where'],{'$or':_[_0x5ad9('0x31')](_0x357e9f[_0x5ad9('0x3c')],function(_0x276870){var _0x2523ec={};_0x2523ec[_0x276870]={'$like':'%'+_0x49b8e7['query'][_0x5ad9('0x43')]+'%'};return _0x2523ec;})});}_0x357e9f=_[_0x5ad9('0x45')]({},_0x357e9f,_0x49b8e7['options']);return _0x2c80ac[_0x5ad9('0x6d')](_0x357e9f);}})[_0x5ad9('0x29')](respondWithResult(_0x50dc78,null))[_0x5ad9('0x4b')](handleError(_0x50dc78,null));};exports[_0x5ad9('0x71')]=function(_0x37e5ea,_0x29885d,_0x472ee7){var _0x495321;var _0x3064f0;var _0x42c796;var _0x74d691=_0x37e5ea['params']['id'];csv_results=[];return db['ContactItemType'][_0x5ad9('0x49')]({'attributes':['id','name'],'raw':!![],'order':[_0x5ad9('0x72')]})[_0x5ad9('0x29')](function(_0x3cdc0c){_0x495321=_0x3cdc0c;var _0x49c0db=_['keys'](db[_0x5ad9('0x62')]['rawAttributes']);return db[_0x5ad9('0x6e')]['findAll']({'raw':!![],'attributes':['id',_0x5ad9('0x73')]})[_0x5ad9('0x29')](function(_0x157c36){_0x3064f0=_0x157c36;var _0x42a285=squel[_0x5ad9('0x74')]()['fields'](_0x49c0db)['from'](_0x5ad9('0x75'),'c')[_0x5ad9('0x41')](_0x5ad9('0x76'),_0x74d691)[_0x5ad9('0x41')]('c.deletedAt\x20is\x20null')['distinct']();for(var _0x1b9b4a=0x0;_0x1b9b4a<_0x3064f0[_0x5ad9('0x3d')];_0x1b9b4a++){_0x42a285[_0x5ad9('0x77')](_0x5ad9('0x78')+_0x3064f0[_0x1b9b4a]['id'],'customField_'+_0x3064f0[_0x1b9b4a][_0x5ad9('0x73')]);}for(var _0x1b9b4a=0x0;_0x1b9b4a<_0x495321['length'];_0x1b9b4a++){_0x42a285['field'](squel[_0x5ad9('0x74')]()[_0x5ad9('0x77')](_0x5ad9('0x79'))[_0x5ad9('0x7a')](_0x5ad9('0x7b'))['where'](_0x5ad9('0x7c'),_0x495321[_0x1b9b4a]['id'])[_0x5ad9('0x41')](_0x5ad9('0x7d')),_0x5ad9('0x7e')+_0x495321[_0x1b9b4a][_0x5ad9('0x2e')]);_0x42a285['field'](squel['select']()[_0x5ad9('0x77')](_0x5ad9('0x7f'))[_0x5ad9('0x7a')](_0x5ad9('0x7b'))[_0x5ad9('0x41')](_0x5ad9('0x7c'),_0x495321[_0x1b9b4a]['id'])[_0x5ad9('0x41')](_0x5ad9('0x7d')),_0x5ad9('0x80')+_0x495321[_0x1b9b4a][_0x5ad9('0x2e')]);}var _0x4a8965=[];_0x4a8965['push'](_0x42a285[_0x5ad9('0x81')]());BPromise[_0x5ad9('0x66')](_0x4a8965,handleQuery)[_0x5ad9('0x29')](function(_0x28c24b){handleQuery(_0x42a285[_0x5ad9('0x81')]());var _0x520239=csv_results[0x0];if(!_[_0x5ad9('0x82')](_0x520239)){var _0x382ece=toCsv(_0x520239);var _0x5a7388=Date[_0x5ad9('0x83')]();fs[_0x5ad9('0x84')](util[_0x5ad9('0x85')](_0x5ad9('0x86'),_0x74d691,_0x5a7388),_0x382ece);_0x29885d['setHeader']('Content-disposition','attachment;\x20filename='+util[_0x5ad9('0x85')](_0x5ad9('0x87'),_0x74d691,_0x5a7388));_0x29885d[_0x5ad9('0x88')](_0x5ad9('0x89'),_0x5ad9('0x8a'));return _0x29885d[_0x5ad9('0x8b')](util[_0x5ad9('0x85')](_0x5ad9('0x86'),_0x74d691,_0x5a7388));}else{return _0x29885d[_0x5ad9('0x1d')](0xcc);}});});});};exports['addCustomField']=function(_0xa358ef,_0xe9f757,_0x2dcf61){var _0x5da1a5;delete _0xa358ef[_0x5ad9('0x56')]['id'];return db[_0x5ad9('0x32')][_0x5ad9('0x5d')]({'where':{'id':_0xa358ef[_0x5ad9('0x57')]['id']}})[_0x5ad9('0x29')](handleEntityNotFound(_0xe9f757,null))[_0x5ad9('0x29')](function(_0x45f17c){if(_0x45f17c){return db['sequelize'][_0x5ad9('0x8c')](function(_0x1f32c3){return db[_0x5ad9('0x6e')][_0x5ad9('0x54')](_0xa358ef[_0x5ad9('0x56')],{'transaction':_0x1f32c3})[_0x5ad9('0x29')](function(_0x13ec36){_0x5da1a5=_0x13ec36;return _0x45f17c[_0x5ad9('0x8d')](_0x13ec36,{'transaction':_0x1f32c3});})['then'](function(){var _0x23509e={'type':db['Sequelize']['TEXT'],'transaction':_0x1f32c3};switch(_0xa358ef['body'][_0x5ad9('0x35')]){case _0x5ad9('0x8e'):_0x23509e[_0x5ad9('0x35')]=db[_0x5ad9('0x8f')][_0x5ad9('0x90')];break;case _0x5ad9('0x91'):_0x23509e[_0x5ad9('0x35')]=db['Sequelize'][_0x5ad9('0x92')];break;case'switch':_0x23509e[_0x5ad9('0x35')]=db[_0x5ad9('0x8f')]['BOOLEAN'];_0x23509e[_0x5ad9('0x93')]=![];break;default:}return db[_0x5ad9('0x94')][_0x5ad9('0x95')][_0x5ad9('0x96')](_0x5ad9('0x75'),util['format'](_0x5ad9('0x97'),_0x5da1a5['id']),_0x23509e);})[_0x5ad9('0x29')](function(){return _0x5da1a5;});});}})[_0x5ad9('0x29')](respondWithResult(_0xe9f757,null))[_0x5ad9('0x4b')](handleError(_0xe9f757,null));};exports[_0x5ad9('0x98')]=function(_0x5aad61,_0xbbebbd,_0x38412a){var _0x553e82={};var _0x40e641={};var _0x2f5082;var _0x1c82db;return db[_0x5ad9('0x32')][_0x5ad9('0x5d')]({'where':{'id':_0x5aad61['params']['id']}})[_0x5ad9('0x29')](handleEntityNotFound(_0xbbebbd,null))[_0x5ad9('0x29')](function(_0x4edff5){if(_0x4edff5){_0x2f5082=_0x4edff5;_0x40e641[_0x5ad9('0x37')]=_[_0x5ad9('0x38')](db[_0x5ad9('0x6e')][_0x5ad9('0x33')]);_0x40e641[_0x5ad9('0x3b')]=_[_0x5ad9('0x38')](_0x5aad61[_0x5ad9('0x3b')]);_0x40e641['filters']=_[_0x5ad9('0x3a')](_0x40e641[_0x5ad9('0x37')],_0x40e641['query']);_0x553e82[_0x5ad9('0x3c')]=_['intersection'](_0x40e641['model'],qs[_0x5ad9('0x4d')](_0x5aad61[_0x5ad9('0x3b')][_0x5ad9('0x4d')]));_0x553e82[_0x5ad9('0x3c')]=_0x553e82[_0x5ad9('0x3c')][_0x5ad9('0x3d')]?_0x553e82[_0x5ad9('0x3c')]:_0x40e641[_0x5ad9('0x37')];_0x553e82[_0x5ad9('0x5e')]=qs[_0x5ad9('0x40')](_0x5aad61[_0x5ad9('0x3b')][_0x5ad9('0x40')]);_0x553e82[_0x5ad9('0x41')]=qs['filters'](_[_0x5ad9('0x42')](_0x5aad61[_0x5ad9('0x3b')],_0x40e641[_0x5ad9('0x39')]));_0x553e82['where']=_['merge'](_0x553e82[_0x5ad9('0x41')],{'$or':[{'ListId':_0x4edff5['id']},{'ListId':null}]});if(_0x5aad61[_0x5ad9('0x3b')][_0x5ad9('0x43')]){_0x553e82['where']=_['merge'](_0x553e82[_0x5ad9('0x41')],{'$or':_['map'](_0x553e82[_0x5ad9('0x3c')],function(_0x3bc8c8){var _0x1781fa={};_0x1781fa[_0x3bc8c8]={'$like':'%'+_0x5aad61[_0x5ad9('0x3b')][_0x5ad9('0x43')]+'%'};return _0x1781fa;})});}_0x553e82=_[_0x5ad9('0x45')]({},_0x553e82,_0x5aad61[_0x5ad9('0x46')]);return db[_0x5ad9('0x6e')][_0x5ad9('0x99')](_0x553e82);}})[_0x5ad9('0x29')](respondWithResult(_0xbbebbd,null))['catch'](handleError(_0xbbebbd,null));};exports[_0x5ad9('0x9a')]=function(_0x3fc293,_0x1407f0){return db[_0x5ad9('0x6e')][_0x5ad9('0x99')]({'where':{'ListId':null}})[_0x5ad9('0x29')](handleEntityNotFound(_0x1407f0,null))['then'](function(_0x4a69a7){return _0x4a69a7;})[_0x5ad9('0x29')](respondWithResult(_0x1407f0,null))['catch'](handleError(_0x1407f0,null));};exports[_0x5ad9('0x9b')]=function(_0x5e13a0,_0x57d657,_0x230935){return db['CmList']['find']({'where':{'id':_0x5e13a0[_0x5ad9('0x57')]['id']}})[_0x5ad9('0x29')](handleEntityNotFound(_0x57d657,null))['then'](function(_0x408730){if(_0x408730){return _0x408730[_0x5ad9('0x9b')](_0x5e13a0['body']['ids'],_[_0x5ad9('0x67')](_0x5e13a0[_0x5ad9('0x56')],[_0x5ad9('0x60'),'id'])||{})[_0x5ad9('0x9c')](function(_0x19aaf0){for(var _0x1aaf1e=0x0;_0x1aaf1e<_0x5e13a0['body']['ids'][_0x5ad9('0x3d')];_0x1aaf1e+=0x1){socket[_0x5ad9('0x9d')](_0x5ad9('0x9e'),{'UserId':Number(_0x5e13a0['body'][_0x5ad9('0x60')][_0x1aaf1e]),'CmListId':Number(_0x5e13a0[_0x5ad9('0x57')]['id'])});}return _0x19aaf0;});}})['then'](respondWithResult(_0x57d657,null))[_0x5ad9('0x4b')](handleError(_0x57d657,null));};exports[_0x5ad9('0x9f')]=function(_0x5db655,_0x4548b8,_0x1843a5){return db[_0x5ad9('0x32')][_0x5ad9('0x51')]({'where':{'id':_0x5db655[_0x5ad9('0x57')]['id']}})[_0x5ad9('0x29')](handleEntityNotFound(_0x4548b8,null))[_0x5ad9('0x29')](function(_0x39afe5){if(_0x39afe5){return _0x39afe5['removeAgents'](_0x5db655[_0x5ad9('0x3b')][_0x5ad9('0x60')])[_0x5ad9('0x29')](function(){if(_['isArray'](_0x5db655[_0x5ad9('0x3b')][_0x5ad9('0x60')])){for(var _0xcabea8=0x0;_0xcabea8<_0x5db655[_0x5ad9('0x3b')][_0x5ad9('0x60')]['length'];_0xcabea8+=0x1){socket[_0x5ad9('0x9d')]('userCmList:remove',{'UserId':Number(_0x5db655[_0x5ad9('0x3b')][_0x5ad9('0x60')][_0xcabea8]),'CmListId':Number(_0x5db655['params']['id'])});}}else{socket[_0x5ad9('0x9d')](_0x5ad9('0xa0'),{'UserId':Number(_0x5db655[_0x5ad9('0x3b')][_0x5ad9('0x60')]),'CmListId':Number(_0x5db655['params']['id'])});}});}})['then'](respondWithStatusCode(_0x4548b8,null))[_0x5ad9('0x4b')](handleError(_0x4548b8,null));};exports[_0x5ad9('0xa1')]=function(_0x462538,_0x345532,_0x11eaa3){var _0x3dd2ad={};var _0x1e074e={};var _0x19425d;var _0x12f6d5;return db['CmList'][_0x5ad9('0x5d')]({'where':{'id':_0x462538[_0x5ad9('0x57')]['id']}})[_0x5ad9('0x29')](handleEntityNotFound(_0x345532,null))['then'](function(_0x27859b){if(_0x27859b){_0x19425d=_0x27859b;_0x1e074e['model']=_[_0x5ad9('0x38')](db[_0x5ad9('0xa2')][_0x5ad9('0x33')]);_0x1e074e[_0x5ad9('0x3b')]=_['keys'](_0x462538[_0x5ad9('0x3b')]);_0x1e074e[_0x5ad9('0x39')]=_[_0x5ad9('0x3a')](_0x1e074e['model'],_0x1e074e[_0x5ad9('0x3b')]);_0x3dd2ad[_0x5ad9('0x3c')]=_[_0x5ad9('0x3a')](_0x1e074e[_0x5ad9('0x37')],qs[_0x5ad9('0x4d')](_0x462538[_0x5ad9('0x3b')][_0x5ad9('0x4d')]));_0x3dd2ad['attributes']=_0x3dd2ad[_0x5ad9('0x3c')]['length']?_0x3dd2ad[_0x5ad9('0x3c')]:_0x1e074e[_0x5ad9('0x37')];_0x3dd2ad[_0x5ad9('0x5e')]=qs[_0x5ad9('0x40')](_0x462538[_0x5ad9('0x3b')][_0x5ad9('0x40')]);_0x3dd2ad[_0x5ad9('0x41')]=qs[_0x5ad9('0x39')](_[_0x5ad9('0x42')](_0x462538[_0x5ad9('0x3b')],_0x1e074e['filters']));if(_0x462538[_0x5ad9('0x3b')][_0x5ad9('0x43')]){_0x3dd2ad['where']=_[_0x5ad9('0x45')](_0x3dd2ad[_0x5ad9('0x41')],{'$or':_[_0x5ad9('0x31')](_0x3dd2ad[_0x5ad9('0x3c')],function(_0x5a213e){var _0x151c46={};_0x151c46[_0x5a213e]={'$like':'%'+_0x462538[_0x5ad9('0x3b')]['filter']+'%'};return _0x151c46;})});}_0x3dd2ad=_['merge']({},_0x3dd2ad,_0x462538[_0x5ad9('0x46')]);return _0x19425d[_0x5ad9('0xa1')](_0x3dd2ad);}})[_0x5ad9('0x29')](function(_0xd09953){if(_0xd09953){_0x12f6d5=_0xd09953[_0x5ad9('0x3d')];if(!_0x462538[_0x5ad9('0x3b')][_0x5ad9('0x3e')](_0x5ad9('0x3f'))){_0x3dd2ad['limit']=qs[_0x5ad9('0x21')](_0x462538['query'][_0x5ad9('0x21')]);_0x3dd2ad['offset']=qs[_0x5ad9('0x20')](_0x462538[_0x5ad9('0x3b')]['offset']);}return _0x19425d['getAgents'](_0x3dd2ad);}})[_0x5ad9('0x29')](function(_0x441947){if(_0x441947){return _0x441947?{'count':_0x12f6d5,'rows':_0x441947}:null;}})['then'](respondWithResult(_0x345532,null))[_0x5ad9('0x4b')](handleError(_0x345532,null));};function handleQuery(_0x115ebc){logger['info'](_0x115ebc);return db[_0x5ad9('0x94')]['query'](_0x115ebc)[_0x5ad9('0x9c')](function(_0x461ebe){csv_results['push'](_0x461ebe);})[_0x5ad9('0x4b')](function(_0xb66c5e){logger[_0x5ad9('0x55')](_0xb66c5e[_0x5ad9('0x6b')]);});}
\ No newline at end of file