18 var _0x03c1=['../../mysqldb','redis','defaults','localhost','socket.io-emitter','./cmList.socket','status','json','offset','undefined','limit','count','set','Content-Range','save','update','then','destroy','get','Lists','UserProfileResource','end','sendStatus','stack','name','send','index','map','CmList','rawAttributes','fieldName','type','key','query','keys','filters','intersection','attributes','model','fields','nolimit','order','sort','pick','filter','where','merge','VIRTUAL','options','include','rows','catch','params','length','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','describe','addDisposition','ListId','getDispositions','findOne','Disposition','hasOwnProperty','findAll','removeDispositions','CmContact','tags','isArray','join','push','each','ids','success','dataValues','errors','Malformed\x20request\x20syntax','getContacts','CmCustomField','CustomFields','format','raw','getContactsCsv','ContactItemType','OrderBy','alias','select','from','cm_contacts','c.deletedAt\x20is\x20null','distinct','c.cf_','customField_','field','item','cm_contact_has_items','CmContactId\x20=\x20c.id','additionalPhone_','description','ItemTypeId\x20=\x20?','description_additionalPhone_','toString','isEmpty','writeFileSync','setHeader','Content-disposition','attachment;\x20filename=','list_%d_%s.csv','Content-type','text/csv','download','/tmp/list_%d_%s.csv','addCustomField','sequelize','transaction','addCustomFields','TEXT','text','number','Sequelize','INTEGER','BOOLEAN','defaultValue','queryInterface','addColumn','cf_%s','getCustomFields','getGlobalCustomFields','findAndCountAll','addAgents','omit','spread','emit','userCmList:save','removeAgents','userCmList:remove','getAgents','info','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','sox','fs-extra','crypto','jsforce','desk.js','to-csv','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment'];(function(_0x53ccf2,_0x13cb67){var _0x5a2964=function(_0x3b0514){while(--_0x3b0514){_0x53ccf2['push'](_0x53ccf2['shift']());}};_0x5a2964(++_0x13cb67);}(_0x03c1,0x92));var _0x103c=function(_0x4b5813,_0x5769de){_0x4b5813=_0x4b5813-0x0;var _0x423465=_0x03c1[_0x4b5813];return _0x423465;};'use strict';var emlformat=require(_0x103c('0x0'));var rimraf=require(_0x103c('0x1'));var zipdir=require(_0x103c('0x2'));var jsonpatch=require(_0x103c('0x3'));var rp=require(_0x103c('0x4'));var moment=require('moment');var BPromise=require(_0x103c('0x5'));var Mustache=require(_0x103c('0x6'));var util=require(_0x103c('0x7'));var path=require('path');var sox=require(_0x103c('0x8'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x103c('0x9'));var _=require('lodash');var squel=require('squel');var crypto=require(_0x103c('0xa'));var jsforce=require(_0x103c('0xb'));var deskjs=require(_0x103c('0xc'));var toCsv=require(_0x103c('0xd'));var querystring=require(_0x103c('0xe'));var Papa=require(_0x103c('0xf'));var Redis=require('ioredis');var authService=require(_0x103c('0x10'));var qs=require(_0x103c('0x11'));var as=require(_0x103c('0x12'));var hardwareService=require(_0x103c('0x13'));var logger=require(_0x103c('0x14'))(_0x103c('0x15'));var utils=require(_0x103c('0x16'));var config=require(_0x103c('0x17'));var licenseUtil=require('../../config/license/util');var db=require(_0x103c('0x18'))['db'];var csv_results;config[_0x103c('0x19')]=_[_0x103c('0x1a')](config['redis'],{'host':_0x103c('0x1b'),'port':0x18eb});var socket=require(_0x103c('0x1c'))(new Redis(config[_0x103c('0x19')]));require(_0x103c('0x1d'))['register'](socket);function respondWithStatusCode(_0x330d33,_0x394cde){_0x394cde=_0x394cde||0xcc;return function(_0x547e7b){if(_0x547e7b){return _0x330d33['sendStatus'](_0x394cde);}return _0x330d33[_0x103c('0x1e')](_0x394cde)['end']();};}function respondWithResult(_0x4012a2,_0x6cf7e7){_0x6cf7e7=_0x6cf7e7||0xc8;return function(_0x1606b8){if(_0x1606b8){return _0x4012a2['status'](_0x6cf7e7)[_0x103c('0x1f')](_0x1606b8);}};}function respondWithFilteredResult(_0x22df4e,_0x1b6324){return function(_0x116760){if(_0x116760){var _0x580050=typeof _0x1b6324[_0x103c('0x20')]===_0x103c('0x21')&&typeof _0x1b6324[_0x103c('0x22')]==='undefined';var _0xd85203=_0x116760[_0x103c('0x23')];var _0x1c482e=_0x580050?0x0:_0x1b6324['offset'];var _0x4e73c8=_0x580050?_0x116760[_0x103c('0x23')]:_0x1b6324['offset']+_0x1b6324[_0x103c('0x22')];var _0x10c466;if(_0x4e73c8>=_0xd85203){_0x4e73c8=_0xd85203;_0x10c466=0xc8;}else{_0x10c466=0xce;}_0x22df4e['status'](_0x10c466);return _0x22df4e[_0x103c('0x24')](_0x103c('0x25'),_0x1c482e+'-'+_0x4e73c8+'/'+_0xd85203)[_0x103c('0x1f')](_0x116760);}return null;};}function patchUpdates(_0x1341b3){return function(_0x578dcb){try{jsonpatch['apply'](_0x578dcb,_0x1341b3,!![]);}catch(_0x1a57ec){return BPromise['reject'](_0x1a57ec);}return _0x578dcb[_0x103c('0x26')]();};}function saveUpdates(_0x51baaa,_0x5101e1){return function(_0x417781){if(_0x417781){return _0x417781[_0x103c('0x27')](_0x51baaa)[_0x103c('0x28')](function(_0x24b894){return _0x24b894;});}return null;};}function removeEntity(_0x160c62,_0x99c73a){return function(_0x3c171c){if(_0x3c171c){return _0x3c171c[_0x103c('0x29')]()['then'](function(){var _0x496673=_0x3c171c[_0x103c('0x2a')]({'plain':!![]});var _0x49effb=_0x103c('0x2b');return db[_0x103c('0x2c')][_0x103c('0x29')]({'where':{'type':_0x49effb,'resourceId':_0x496673['id']}})[_0x103c('0x28')](function(){return _0x3c171c;});})[_0x103c('0x28')](function(){_0x160c62[_0x103c('0x1e')](0xcc)[_0x103c('0x2d')]();});}};}function handleEntityNotFound(_0x22c767,_0x34330b){return function(_0x4b9870){if(!_0x4b9870){_0x22c767[_0x103c('0x2e')](0x194);}return _0x4b9870;};}function handleError(_0x2ad079,_0x4b53c2){_0x4b53c2=_0x4b53c2||0x1f4;return function(_0x196f23){logger['error'](_0x196f23[_0x103c('0x2f')]);if(_0x196f23['name']){delete _0x196f23[_0x103c('0x30')];}_0x2ad079['status'](_0x4b53c2)[_0x103c('0x31')](_0x196f23);};}exports[_0x103c('0x32')]=function(_0x5baaed,_0x2c2f22){var _0x249e58={},_0x4afe66={},_0x178cc9={'count':0x0,'rows':[]};var _0x8743ed=_[_0x103c('0x33')](db[_0x103c('0x34')][_0x103c('0x35')],function(_0x182c95){return{'name':_0x182c95[_0x103c('0x36')],'type':_0x182c95[_0x103c('0x37')][_0x103c('0x38')]};});_0x4afe66['model']=_[_0x103c('0x33')](_0x8743ed,_0x103c('0x30'));_0x4afe66[_0x103c('0x39')]=_[_0x103c('0x3a')](_0x5baaed[_0x103c('0x39')]);_0x4afe66[_0x103c('0x3b')]=_[_0x103c('0x3c')](_0x4afe66['model'],_0x4afe66[_0x103c('0x39')]);_0x249e58[_0x103c('0x3d')]=_[_0x103c('0x3c')](_0x4afe66[_0x103c('0x3e')],qs['fields'](_0x5baaed[_0x103c('0x39')][_0x103c('0x3f')]));_0x249e58[_0x103c('0x3d')]=_0x249e58[_0x103c('0x3d')]['length']?_0x249e58[_0x103c('0x3d')]:_0x4afe66[_0x103c('0x3e')];if(!_0x5baaed[_0x103c('0x39')]['hasOwnProperty'](_0x103c('0x40'))){_0x249e58[_0x103c('0x22')]=qs[_0x103c('0x22')](_0x5baaed[_0x103c('0x39')][_0x103c('0x22')]);_0x249e58['offset']=qs[_0x103c('0x20')](_0x5baaed[_0x103c('0x39')]['offset']);}_0x249e58[_0x103c('0x41')]=qs[_0x103c('0x42')](_0x5baaed[_0x103c('0x39')][_0x103c('0x42')]);_0x249e58['where']=qs[_0x103c('0x3b')](_[_0x103c('0x43')](_0x5baaed[_0x103c('0x39')],_0x4afe66[_0x103c('0x3b')]),_0x8743ed);if(_0x5baaed[_0x103c('0x39')][_0x103c('0x44')]){_0x249e58[_0x103c('0x45')]=_[_0x103c('0x46')](_0x249e58[_0x103c('0x45')],{'$or':_[_0x103c('0x33')](_0x8743ed,function(_0x47201b){if(_0x47201b[_0x103c('0x37')]!==_0x103c('0x47')){var _0x549375={};_0x549375[_0x47201b[_0x103c('0x30')]]={'$like':'%'+_0x5baaed[_0x103c('0x39')]['filter']+'%'};return _0x549375;}})});}_0x249e58=_[_0x103c('0x46')]({},_0x249e58,_0x5baaed[_0x103c('0x48')]);var _0x587a58={'where':_0x249e58['where']};return db[_0x103c('0x34')][_0x103c('0x23')](_0x587a58)[_0x103c('0x28')](function(_0x42c5ff){_0x178cc9[_0x103c('0x23')]=_0x42c5ff;if(_0x5baaed[_0x103c('0x39')]['includeAll']){_0x249e58[_0x103c('0x49')]=[{'all':!![]}];}return db['CmList']['findAll'](_0x249e58);})[_0x103c('0x28')](function(_0x2ca61b){_0x178cc9[_0x103c('0x4a')]=_0x2ca61b;return _0x178cc9;})['then'](respondWithFilteredResult(_0x2c2f22,_0x249e58))[_0x103c('0x4b')](handleError(_0x2c2f22,null));};exports['show']=function(_0x2c8c9a,_0x47c6f4){var _0x3c6e95={'raw':![],'where':{'id':_0x2c8c9a[_0x103c('0x4c')]['id']}},_0x40c57b={};_0x40c57b[_0x103c('0x3e')]=_['keys'](db[_0x103c('0x34')][_0x103c('0x35')]);_0x40c57b[_0x103c('0x39')]=_[_0x103c('0x3a')](_0x2c8c9a[_0x103c('0x39')]);_0x40c57b[_0x103c('0x3b')]=_[_0x103c('0x3c')](_0x40c57b[_0x103c('0x3e')],_0x40c57b[_0x103c('0x39')]);_0x3c6e95[_0x103c('0x3d')]=_[_0x103c('0x3c')](_0x40c57b['model'],qs[_0x103c('0x3f')](_0x2c8c9a[_0x103c('0x39')]['fields']));_0x3c6e95[_0x103c('0x3d')]=_0x3c6e95[_0x103c('0x3d')][_0x103c('0x4d')]?_0x3c6e95[_0x103c('0x3d')]:_0x40c57b['model'];if(_0x2c8c9a[_0x103c('0x39')]['includeAll']){_0x3c6e95[_0x103c('0x49')]=[{'all':!![]}];}_0x3c6e95=_[_0x103c('0x46')]({},_0x3c6e95,_0x2c8c9a[_0x103c('0x48')]);return db[_0x103c('0x34')][_0x103c('0x4e')](_0x3c6e95)[_0x103c('0x28')](handleEntityNotFound(_0x47c6f4,null))[_0x103c('0x28')](respondWithResult(_0x47c6f4,null))[_0x103c('0x4b')](handleError(_0x47c6f4,null));};exports[_0x103c('0x4f')]=function(_0x1b8188,_0x398695){return db[_0x103c('0x34')][_0x103c('0x4f')](_0x1b8188[_0x103c('0x50')],{})[_0x103c('0x28')](function(_0x2a73bc){var _0x125d5f=_0x1b8188[_0x103c('0x51')][_0x103c('0x2a')]({'plain':!![]});if(!_0x125d5f)throw new Error(_0x103c('0x52'));if(_0x125d5f[_0x103c('0x53')]===_0x103c('0x51')){var _0x33fcd5=_0x2a73bc[_0x103c('0x2a')]({'plain':!![]});var _0x4811b8=_0x103c('0x2b');return db[_0x103c('0x54')][_0x103c('0x4e')]({'where':{'name':_0x4811b8,'userProfileId':_0x125d5f[_0x103c('0x55')]},'raw':!![]})[_0x103c('0x28')](function(_0x51b881){if(_0x51b881&&_0x51b881[_0x103c('0x56')]===0x0){return db[_0x103c('0x2c')][_0x103c('0x4f')]({'name':_0x33fcd5['name'],'resourceId':_0x33fcd5['id'],'type':_0x51b881[_0x103c('0x30')],'sectionId':_0x51b881['id']},{})[_0x103c('0x28')](function(){return _0x2a73bc;});}else{return _0x2a73bc;}})[_0x103c('0x4b')](function(_0xa1216f){logger[_0x103c('0x57')](_0x103c('0x58'),_0xa1216f);throw _0xa1216f;});}return _0x2a73bc;})[_0x103c('0x28')](respondWithResult(_0x398695,0xc9))['catch'](handleError(_0x398695,null));};exports['update']=function(_0x34a049,_0x5177cc){if(_0x34a049['body']['id']){delete _0x34a049[_0x103c('0x50')]['id'];}return db[_0x103c('0x34')][_0x103c('0x4e')]({'where':{'id':_0x34a049[_0x103c('0x4c')]['id']}})['then'](handleEntityNotFound(_0x5177cc,null))[_0x103c('0x28')](saveUpdates(_0x34a049[_0x103c('0x50')],null))[_0x103c('0x28')](respondWithResult(_0x5177cc,null))[_0x103c('0x4b')](handleError(_0x5177cc,null));};exports['destroy']=function(_0x570a8c,_0x19626d){return db['CmList'][_0x103c('0x4e')]({'where':{'id':_0x570a8c['params']['id']}})['then'](handleEntityNotFound(_0x19626d,null))[_0x103c('0x28')](removeEntity(_0x19626d,null))['catch'](handleError(_0x19626d,null));};exports[_0x103c('0x59')]=function(_0x3f0f6e,_0x56a4d8){return db[_0x103c('0x34')][_0x103c('0x59')]()['then'](respondWithResult(_0x56a4d8,null))['catch'](handleError(_0x56a4d8,null));};exports[_0x103c('0x5a')]=function(_0x4ba517,_0x1db73b,_0x2442ef){if(_0x4ba517[_0x103c('0x50')]['id']){delete _0x4ba517[_0x103c('0x50')]['id'];}return db[_0x103c('0x34')][_0x103c('0x4e')]({'where':{'id':_0x4ba517['params']['id']}})['then'](handleEntityNotFound(_0x1db73b,null))['then'](function(_0x53dcc5){if(_0x53dcc5){_0x4ba517[_0x103c('0x50')][_0x103c('0x5b')]=_0x53dcc5['id'];return db['Disposition']['create'](_0x4ba517['body']);}})[_0x103c('0x28')](respondWithResult(_0x1db73b,null))['catch'](handleError(_0x1db73b,null));};exports[_0x103c('0x5c')]=function(_0x4965bf,_0x16b045,_0x4285b1){var _0x5018d0={'raw':![],'where':{}};var _0x53b3a4={};var _0xe422a7={'count':0x0,'rows':[]};return db[_0x103c('0x34')][_0x103c('0x5d')]({'where':{'id':_0x4965bf[_0x103c('0x4c')]['id']}})[_0x103c('0x28')](handleEntityNotFound(_0x16b045,null))[_0x103c('0x28')](function(_0x27d827){if(_0x27d827){_0x53b3a4[_0x103c('0x3e')]=_[_0x103c('0x3a')](db[_0x103c('0x5e')]['rawAttributes']);_0x53b3a4[_0x103c('0x39')]=_['keys'](_0x4965bf[_0x103c('0x39')]);_0x53b3a4[_0x103c('0x3b')]=_[_0x103c('0x3c')](_0x53b3a4[_0x103c('0x3e')],_0x53b3a4[_0x103c('0x39')]);_0x5018d0[_0x103c('0x3d')]=_[_0x103c('0x3c')](_0x53b3a4['model'],qs[_0x103c('0x3f')](_0x4965bf[_0x103c('0x39')]['fields']));_0x5018d0[_0x103c('0x3d')]=_0x5018d0[_0x103c('0x3d')][_0x103c('0x4d')]?_0x5018d0[_0x103c('0x3d')]:_0x53b3a4['model'];if(!_0x4965bf[_0x103c('0x39')][_0x103c('0x5f')]('nolimit')){_0x5018d0[_0x103c('0x22')]=qs['limit'](_0x4965bf[_0x103c('0x39')][_0x103c('0x22')]);_0x5018d0[_0x103c('0x20')]=qs['offset'](_0x4965bf[_0x103c('0x39')][_0x103c('0x20')]);}_0x5018d0[_0x103c('0x41')]=qs[_0x103c('0x42')](_0x4965bf[_0x103c('0x39')][_0x103c('0x42')]);_0x5018d0[_0x103c('0x45')]=qs[_0x103c('0x3b')](_['pick'](_0x4965bf[_0x103c('0x39')],_0x53b3a4[_0x103c('0x3b')]));_0x5018d0[_0x103c('0x45')][_0x103c('0x5b')]=_0x27d827['id'];if(_0x4965bf[_0x103c('0x39')]['filter']){_0x5018d0[_0x103c('0x45')]=_[_0x103c('0x46')](_0x5018d0['where'],{'$or':_[_0x103c('0x33')](_0x5018d0[_0x103c('0x3d')],function(_0x3d111e){var _0x1088fe={};_0x1088fe[_0x3d111e]={'$like':'%'+_0x4965bf[_0x103c('0x39')]['filter']+'%'};return _0x1088fe;})});}_0x5018d0=_['merge']({},_0x5018d0,_0x4965bf['options']);return db[_0x103c('0x5e')][_0x103c('0x23')]({'where':_0x5018d0[_0x103c('0x45')]})[_0x103c('0x28')](function(_0x2f126f){_0xe422a7[_0x103c('0x23')]=_0x2f126f;if(_0x4965bf[_0x103c('0x39')]['includeAll']){_0x5018d0[_0x103c('0x49')]=[{'all':!![]}];}return db[_0x103c('0x5e')][_0x103c('0x60')](_0x5018d0);})['then'](function(_0x240ef4){_0xe422a7[_0x103c('0x4a')]=_0x240ef4;return _0xe422a7;});}})[_0x103c('0x28')](respondWithFilteredResult(_0x16b045,_0x5018d0))['catch'](handleError(_0x16b045,null));};exports[_0x103c('0x61')]=function(_0x19a92e,_0x2799bc,_0x5500e6){return db[_0x103c('0x34')][_0x103c('0x4e')]({'where':{'id':_0x19a92e[_0x103c('0x4c')]['id']}})[_0x103c('0x28')](handleEntityNotFound(_0x2799bc,null))[_0x103c('0x28')](function(_0xcbbc8d){if(_0xcbbc8d){return _0xcbbc8d[_0x103c('0x61')](_0x19a92e[_0x103c('0x39')]['ids']);}})[_0x103c('0x28')](respondWithStatusCode(_0x2799bc,null))['catch'](handleError(_0x2799bc,null));};exports['addContacts']=function(_0xca9628,_0x3e5f82,_0x477fcd){return db[_0x103c('0x34')][_0x103c('0x4e')]({'where':{'id':_0xca9628[_0x103c('0x4c')]['id']}})[_0x103c('0x28')](handleEntityNotFound(_0x3e5f82,null))[_0x103c('0x28')](function(_0xc091bb){if(_0xc091bb){var _0x282450=[];var _0x40bcf2={'success':[],'errors':[]};return db[_0x103c('0x62')][_0x103c('0x59')]()['then'](function(_0x1e5896){if(_0xca9628[_0x103c('0x50')][_0x103c('0x63')]&&_[_0x103c('0x64')](_0xca9628[_0x103c('0x50')]['tags'])){if(_0xca9628['body']['tags']['length']){_0xca9628['body'][_0x103c('0x63')]=_0xca9628['body'][_0x103c('0x63')][_0x103c('0x65')](';')+';';}else{_0xca9628[_0x103c('0x50')][_0x103c('0x63')]=null;}}else{_0xca9628['body']['tags']=null;}if(_0xca9628[_0x103c('0x50')]&&_[_0x103c('0x64')](_0xca9628['body'])){for(var _0xc96d96=0x0;_0xc96d96<_0xca9628[_0x103c('0x50')]['length'];_0xc96d96+=0x1){_0xca9628[_0x103c('0x50')][_0xc96d96][_0x103c('0x5b')]=_0xca9628[_0x103c('0x4c')]['id'];_0x282450[_0x103c('0x66')](_0xca9628['body'][_0xc96d96]);}return BPromise[_0x103c('0x67')](_0x282450,function(_0x344ff4){return db['CmContact'][_0x103c('0x4f')](_['omit'](_0x344ff4,[_0x103c('0x68'),'id'])||{},{'fields':_[_0x103c('0x3a')](_0x1e5896),'raw':!![]})['then'](function(_0x4ca9d0){_0x40bcf2[_0x103c('0x69')]['push'](_0x4ca9d0[_0x103c('0x6a')]);})[_0x103c('0x4b')](function(_0x317d12){_0x40bcf2[_0x103c('0x6b')][_0x103c('0x66')]({'data':_0x344ff4,'error':_0x317d12['message']});});})[_0x103c('0x28')](function(_0x14e3d8){return _0x40bcf2;})[_0x103c('0x4b')](function(_0x2cc9d9){return _0x2cc9d9;});}else{_0x3e5f82['status'](0x190)[_0x103c('0x1f')]({'message':_0x103c('0x6c')});}});}})[_0x103c('0x28')](respondWithResult(_0x3e5f82,null))[_0x103c('0x4b')](handleError(_0x3e5f82,null));};exports[_0x103c('0x6d')]=function(_0x36aaad,_0x4c67b9,_0xe9e2fc){var _0xa1a166;return db[_0x103c('0x34')]['find']({'where':{'id':_0x36aaad[_0x103c('0x4c')]['id']},'include':[{'model':db[_0x103c('0x6e')],'as':_0x103c('0x6f')}]})[_0x103c('0x28')](handleEntityNotFound(_0x4c67b9,null))[_0x103c('0x28')](function(_0x596ab2){if(_0x596ab2){_0xa1a166=_0x596ab2;return db[_0x103c('0x62')]['rawAttributes'];}})[_0x103c('0x28')](function(_0x303dcd){if(_0x303dcd){var _0x1614d1={};var _0x36d306={};_0x36d306[_0x103c('0x3e')]=_['concat'](_[_0x103c('0x3a')](_0x303dcd),_[_0x103c('0x33')](_0xa1a166[_0x103c('0x6f')],function(_0x1d9089){return util[_0x103c('0x70')]('cf_%d',_0x1d9089['id']);}));_0x36d306[_0x103c('0x39')]=_['keys'](_0x36aaad[_0x103c('0x39')]);_0x36d306['filters']=_[_0x103c('0x3c')](_0x36d306[_0x103c('0x3e')],_0x36d306[_0x103c('0x39')]);_0x1614d1[_0x103c('0x3d')]=_['intersection'](_0x36d306['model'],qs[_0x103c('0x3f')](_0x36aaad[_0x103c('0x39')][_0x103c('0x3f')]));_0x1614d1[_0x103c('0x3d')]=_0x1614d1['attributes']['length']?_0x1614d1[_0x103c('0x3d')]:_0x36d306[_0x103c('0x3e')];if(!_0x36aaad[_0x103c('0x39')][_0x103c('0x5f')]('nolimit')){_0x1614d1['limit']=qs['limit'](_0x36aaad[_0x103c('0x39')][_0x103c('0x22')]);_0x1614d1[_0x103c('0x20')]=qs[_0x103c('0x20')](_0x36aaad[_0x103c('0x39')]['offset']);}_0x1614d1[_0x103c('0x41')]=qs[_0x103c('0x42')](_0x36aaad[_0x103c('0x39')][_0x103c('0x42')]);_0x1614d1[_0x103c('0x45')]=qs[_0x103c('0x3b')](_[_0x103c('0x43')](_0x36aaad[_0x103c('0x39')],_0x36d306[_0x103c('0x3b')]));_0x1614d1[_0x103c('0x71')]=!![];if(_0x36aaad[_0x103c('0x39')][_0x103c('0x44')]){_0x1614d1['where']=_[_0x103c('0x46')](_0x1614d1['where'],{'$or':_['map'](_0x1614d1[_0x103c('0x3d')],function(_0x38e508){var _0x363d2a={};_0x363d2a[_0x38e508]={'$like':'%'+_0x36aaad[_0x103c('0x39')]['filter']+'%'};return _0x363d2a;})});}_0x1614d1=_[_0x103c('0x46')]({},_0x1614d1,_0x36aaad[_0x103c('0x48')]);return _0xa1a166[_0x103c('0x6d')](_0x1614d1);}})['then'](respondWithResult(_0x4c67b9,null))[_0x103c('0x4b')](handleError(_0x4c67b9,null));};exports[_0x103c('0x72')]=function(_0xca8e48,_0x252b78,_0x544bc5){var _0x171560;var _0x1992aa;var _0x5bb799;var _0x23609e=_0xca8e48[_0x103c('0x4c')]['id'];csv_results=[];return db[_0x103c('0x73')]['findAll']({'attributes':['id',_0x103c('0x30')],'raw':!![],'order':[_0x103c('0x74')]})[_0x103c('0x28')](function(_0x59e1ea){_0x171560=_0x59e1ea;var _0x502a4d=_[_0x103c('0x3a')](db[_0x103c('0x62')]['rawAttributes']);return db['CmCustomField']['findAll']({'raw':!![],'attributes':['id',_0x103c('0x75')]})[_0x103c('0x28')](function(_0x587898){_0x1992aa=_0x587898;var _0x2376d3=squel[_0x103c('0x76')]()[_0x103c('0x3f')](_0x502a4d)[_0x103c('0x77')](_0x103c('0x78'),'c')[_0x103c('0x45')]('c.ListId\x20=\x20?',_0x23609e)['where'](_0x103c('0x79'))[_0x103c('0x7a')]();for(var _0x4337b4=0x0;_0x4337b4<_0x1992aa[_0x103c('0x4d')];_0x4337b4++){_0x2376d3['field'](_0x103c('0x7b')+_0x1992aa[_0x4337b4]['id'],_0x103c('0x7c')+_0x1992aa[_0x4337b4][_0x103c('0x75')]);}for(var _0x4337b4=0x0;_0x4337b4<_0x171560[_0x103c('0x4d')];_0x4337b4++){_0x2376d3[_0x103c('0x7d')](squel[_0x103c('0x76')]()[_0x103c('0x7d')](_0x103c('0x7e'))[_0x103c('0x77')](_0x103c('0x7f'))['where']('ItemTypeId\x20=\x20?',_0x171560[_0x4337b4]['id'])['where'](_0x103c('0x80')),_0x103c('0x81')+_0x171560[_0x4337b4][_0x103c('0x30')]);_0x2376d3[_0x103c('0x7d')](squel[_0x103c('0x76')]()[_0x103c('0x7d')](_0x103c('0x82'))[_0x103c('0x77')](_0x103c('0x7f'))[_0x103c('0x45')](_0x103c('0x83'),_0x171560[_0x4337b4]['id'])['where'](_0x103c('0x80')),_0x103c('0x84')+_0x171560[_0x4337b4][_0x103c('0x30')]);}var _0x4d45c0=[];_0x4d45c0[_0x103c('0x66')](_0x2376d3[_0x103c('0x85')]());BPromise[_0x103c('0x67')](_0x4d45c0,handleQuery)[_0x103c('0x28')](function(_0x354ea9){handleQuery(_0x2376d3[_0x103c('0x85')]());var _0x329cb1=csv_results[0x0];if(!_[_0x103c('0x86')](_0x329cb1)){var _0x2bb3d3=toCsv(_0x329cb1);var _0x5be4b2=Date['now']();fs[_0x103c('0x87')](util['format']('/tmp/list_%d_%s.csv',_0x23609e,_0x5be4b2),_0x2bb3d3);_0x252b78[_0x103c('0x88')](_0x103c('0x89'),_0x103c('0x8a')+util[_0x103c('0x70')](_0x103c('0x8b'),_0x23609e,_0x5be4b2));_0x252b78[_0x103c('0x88')](_0x103c('0x8c'),_0x103c('0x8d'));return _0x252b78[_0x103c('0x8e')](util[_0x103c('0x70')](_0x103c('0x8f'),_0x23609e,_0x5be4b2));}else{return _0x252b78[_0x103c('0x2e')](0xcc);}});});});};exports[_0x103c('0x90')]=function(_0x3e941c,_0xd8281a,_0x15ad8f){var _0x5e8d8f;delete _0x3e941c[_0x103c('0x50')]['id'];return db[_0x103c('0x34')]['findOne']({'where':{'id':_0x3e941c[_0x103c('0x4c')]['id']}})[_0x103c('0x28')](handleEntityNotFound(_0xd8281a,null))['then'](function(_0x517fe9){if(_0x517fe9){return db[_0x103c('0x91')][_0x103c('0x92')](function(_0x3d4953){return db[_0x103c('0x6e')][_0x103c('0x4f')](_0x3e941c['body'],{'transaction':_0x3d4953})[_0x103c('0x28')](function(_0x5e35b4){_0x5e8d8f=_0x5e35b4;return _0x517fe9[_0x103c('0x93')](_0x5e35b4,{'transaction':_0x3d4953});})[_0x103c('0x28')](function(){var _0x58f484={'type':db['Sequelize'][_0x103c('0x94')],'transaction':_0x3d4953};switch(_0x3e941c[_0x103c('0x50')][_0x103c('0x37')]){case _0x103c('0x95'):_0x58f484[_0x103c('0x37')]=db['Sequelize'][_0x103c('0x94')];break;case _0x103c('0x96'):_0x58f484[_0x103c('0x37')]=db[_0x103c('0x97')][_0x103c('0x98')];break;case'switch':_0x58f484[_0x103c('0x37')]=db[_0x103c('0x97')][_0x103c('0x99')];_0x58f484[_0x103c('0x9a')]=![];break;default:}return db[_0x103c('0x91')][_0x103c('0x9b')][_0x103c('0x9c')]('cm_contacts',util[_0x103c('0x70')](_0x103c('0x9d'),_0x5e8d8f['id']),_0x58f484);})['then'](function(){return _0x5e8d8f;});});}})['then'](respondWithResult(_0xd8281a,null))['catch'](handleError(_0xd8281a,null));};exports[_0x103c('0x9e')]=function(_0x436253,_0x11fcec,_0x462490){var _0x27c4a6={};var _0x1fd077={};var _0x551431;var _0x48ff61;return db[_0x103c('0x34')][_0x103c('0x5d')]({'where':{'id':_0x436253[_0x103c('0x4c')]['id']}})[_0x103c('0x28')](handleEntityNotFound(_0x11fcec,null))[_0x103c('0x28')](function(_0x4e395f){if(_0x4e395f){_0x551431=_0x4e395f;_0x1fd077[_0x103c('0x3e')]=_[_0x103c('0x3a')](db[_0x103c('0x6e')][_0x103c('0x35')]);_0x1fd077[_0x103c('0x39')]=_['keys'](_0x436253[_0x103c('0x39')]);_0x1fd077[_0x103c('0x3b')]=_[_0x103c('0x3c')](_0x1fd077['model'],_0x1fd077[_0x103c('0x39')]);_0x27c4a6[_0x103c('0x3d')]=_[_0x103c('0x3c')](_0x1fd077[_0x103c('0x3e')],qs['fields'](_0x436253[_0x103c('0x39')][_0x103c('0x3f')]));_0x27c4a6[_0x103c('0x3d')]=_0x27c4a6[_0x103c('0x3d')][_0x103c('0x4d')]?_0x27c4a6[_0x103c('0x3d')]:_0x1fd077[_0x103c('0x3e')];_0x27c4a6[_0x103c('0x41')]=qs['sort'](_0x436253['query'][_0x103c('0x42')]);_0x27c4a6[_0x103c('0x45')]=qs[_0x103c('0x3b')](_[_0x103c('0x43')](_0x436253[_0x103c('0x39')],_0x1fd077[_0x103c('0x3b')]));_0x27c4a6[_0x103c('0x45')]=_[_0x103c('0x46')](_0x27c4a6[_0x103c('0x45')],{'$or':[{'ListId':_0x4e395f['id']},{'ListId':null}]});if(_0x436253['query'][_0x103c('0x44')]){_0x27c4a6[_0x103c('0x45')]=_['merge'](_0x27c4a6[_0x103c('0x45')],{'$or':_[_0x103c('0x33')](_0x27c4a6['attributes'],function(_0x1fba35){var _0x3858a1={};_0x3858a1[_0x1fba35]={'$like':'%'+_0x436253[_0x103c('0x39')][_0x103c('0x44')]+'%'};return _0x3858a1;})});}_0x27c4a6=_[_0x103c('0x46')]({},_0x27c4a6,_0x436253[_0x103c('0x48')]);return db['CmCustomField']['findAndCountAll'](_0x27c4a6);}})['then'](respondWithResult(_0x11fcec,null))[_0x103c('0x4b')](handleError(_0x11fcec,null));};exports[_0x103c('0x9f')]=function(_0x41b182,_0x8ac3cf){return db[_0x103c('0x6e')][_0x103c('0xa0')]({'where':{'ListId':null}})[_0x103c('0x28')](handleEntityNotFound(_0x8ac3cf,null))[_0x103c('0x28')](function(_0x3fc31b){return _0x3fc31b;})[_0x103c('0x28')](respondWithResult(_0x8ac3cf,null))[_0x103c('0x4b')](handleError(_0x8ac3cf,null));};exports[_0x103c('0xa1')]=function(_0x194ae5,_0x27fc18,_0x3be544){return db[_0x103c('0x34')][_0x103c('0x4e')]({'where':{'id':_0x194ae5[_0x103c('0x4c')]['id']}})['then'](handleEntityNotFound(_0x27fc18,null))[_0x103c('0x28')](function(_0x448a71){if(_0x448a71){return _0x448a71[_0x103c('0xa1')](_0x194ae5[_0x103c('0x50')]['ids'],_[_0x103c('0xa2')](_0x194ae5[_0x103c('0x50')],['ids','id'])||{})[_0x103c('0xa3')](function(_0x292ae8){for(var _0x399ab5=0x0;_0x399ab5<_0x194ae5[_0x103c('0x50')][_0x103c('0x68')]['length'];_0x399ab5+=0x1){socket[_0x103c('0xa4')](_0x103c('0xa5'),{'UserId':Number(_0x194ae5['body']['ids'][_0x399ab5]),'CmListId':Number(_0x194ae5[_0x103c('0x4c')]['id'])});}return _0x292ae8;});}})[_0x103c('0x28')](respondWithResult(_0x27fc18,null))['catch'](handleError(_0x27fc18,null));};exports[_0x103c('0xa6')]=function(_0x36f31c,_0x5f1a62,_0x1e79d2){return db['CmList'][_0x103c('0x4e')]({'where':{'id':_0x36f31c[_0x103c('0x4c')]['id']}})[_0x103c('0x28')](handleEntityNotFound(_0x5f1a62,null))[_0x103c('0x28')](function(_0x11b006){if(_0x11b006){return _0x11b006[_0x103c('0xa6')](_0x36f31c[_0x103c('0x39')]['ids'])[_0x103c('0x28')](function(){if(_[_0x103c('0x64')](_0x36f31c[_0x103c('0x39')][_0x103c('0x68')])){for(var _0x4283ef=0x0;_0x4283ef<_0x36f31c['query'][_0x103c('0x68')]['length'];_0x4283ef+=0x1){socket['emit']('userCmList:remove',{'UserId':Number(_0x36f31c[_0x103c('0x39')][_0x103c('0x68')][_0x4283ef]),'CmListId':Number(_0x36f31c[_0x103c('0x4c')]['id'])});}}else{socket[_0x103c('0xa4')](_0x103c('0xa7'),{'UserId':Number(_0x36f31c[_0x103c('0x39')]['ids']),'CmListId':Number(_0x36f31c[_0x103c('0x4c')]['id'])});}});}})[_0x103c('0x28')](respondWithStatusCode(_0x5f1a62,null))[_0x103c('0x4b')](handleError(_0x5f1a62,null));};exports[_0x103c('0xa8')]=function(_0x2dadc1,_0x711871,_0x577cf4){var _0x503d3b={};var _0xa284a5={};var _0x5bec57;var _0x1a8a52;return db['CmList'][_0x103c('0x5d')]({'where':{'id':_0x2dadc1[_0x103c('0x4c')]['id']}})[_0x103c('0x28')](handleEntityNotFound(_0x711871,null))[_0x103c('0x28')](function(_0x25e4c8){if(_0x25e4c8){_0x5bec57=_0x25e4c8;_0xa284a5[_0x103c('0x3e')]=_[_0x103c('0x3a')](db['User'][_0x103c('0x35')]);_0xa284a5[_0x103c('0x39')]=_[_0x103c('0x3a')](_0x2dadc1[_0x103c('0x39')]);_0xa284a5[_0x103c('0x3b')]=_[_0x103c('0x3c')](_0xa284a5[_0x103c('0x3e')],_0xa284a5[_0x103c('0x39')]);_0x503d3b['attributes']=_[_0x103c('0x3c')](_0xa284a5[_0x103c('0x3e')],qs[_0x103c('0x3f')](_0x2dadc1['query'][_0x103c('0x3f')]));_0x503d3b[_0x103c('0x3d')]=_0x503d3b[_0x103c('0x3d')]['length']?_0x503d3b['attributes']:_0xa284a5[_0x103c('0x3e')];_0x503d3b[_0x103c('0x41')]=qs[_0x103c('0x42')](_0x2dadc1[_0x103c('0x39')][_0x103c('0x42')]);_0x503d3b['where']=qs['filters'](_[_0x103c('0x43')](_0x2dadc1[_0x103c('0x39')],_0xa284a5[_0x103c('0x3b')]));if(_0x2dadc1[_0x103c('0x39')][_0x103c('0x44')]){_0x503d3b[_0x103c('0x45')]=_['merge'](_0x503d3b[_0x103c('0x45')],{'$or':_['map'](_0x503d3b[_0x103c('0x3d')],function(_0x1e310e){var _0x51d5c0={};_0x51d5c0[_0x1e310e]={'$like':'%'+_0x2dadc1[_0x103c('0x39')]['filter']+'%'};return _0x51d5c0;})});}_0x503d3b=_['merge']({},_0x503d3b,_0x2dadc1[_0x103c('0x48')]);return _0x5bec57['getAgents'](_0x503d3b);}})['then'](function(_0x1b9b70){if(_0x1b9b70){_0x1a8a52=_0x1b9b70[_0x103c('0x4d')];if(!_0x2dadc1[_0x103c('0x39')][_0x103c('0x5f')](_0x103c('0x40'))){_0x503d3b[_0x103c('0x22')]=qs[_0x103c('0x22')](_0x2dadc1[_0x103c('0x39')]['limit']);_0x503d3b[_0x103c('0x20')]=qs['offset'](_0x2dadc1[_0x103c('0x39')][_0x103c('0x20')]);}return _0x5bec57[_0x103c('0xa8')](_0x503d3b);}})[_0x103c('0x28')](function(_0x36ecd6){if(_0x36ecd6){return _0x36ecd6?{'count':_0x1a8a52,'rows':_0x36ecd6}:null;}})['then'](respondWithResult(_0x711871,null))[_0x103c('0x4b')](handleError(_0x711871,null));};function handleQuery(_0x44fa2c){logger[_0x103c('0xa9')](_0x44fa2c);return db[_0x103c('0x91')]['query'](_0x44fa2c)['spread'](function(_0x4d434a){csv_results[_0x103c('0x66')](_0x4d434a);})[_0x103c('0x4b')](function(_0x5e6030){logger['error'](_0x5e6030['message']);});}
git://repos.xcallymotion.com / motion2.git / blob