// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x1740=['No\x20association\x20values\x20specified!','Incorrect\x20binding\x20parameters\x20passed!','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','root','server/files/tmp','file','filename','0777','child_process','fork','../../components/import/cm/csv','File\x20uploaded\x20correctly!','pid','send','upload','createReadStream','path','meta','import','agent','binding','socket_timestamp','stringify','start\x20child\x20process\x20correctly!','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','sox','to-csv','lodash','squel','jsforce','desk.js','querystring','ioredis','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','redis','defaults','localhost','./cmContact.socket','register','sendStatus','end','status','json','count','offset','limit','set','Content-Range','apply','reject','save','then','destroy','error','stack','name','CmContact','keys','query','intersection','model','attributes','fields','length','hasOwnProperty','order','sort','where','filters','pick','field','from','select','cm_contacts','c.deletedAt\x20IS\x20NULL','advancedFilter','parse','forEach','condition','isArray','value','and','tableAlias','\x20IN\x20?','\x20=\x20?','\x20LIKE\x20?','\x20>\x20?','\x20<\x20?','map','filter','isNil','isEmpty','ListId','c.ListId\x20IN\x20?','replace','\x27\x27\x27\x27','c.id\x20LIKE\x20?','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','c.id','Sequelize','QueryTypes','SELECT','clone','COUNT(*)','tag','expr','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','having','left_join','cm_contact_has_tags','ct.CmContactId\x20=\x20c.id','t.id\x20IN\x20?','toString','sequelize','merge','c.*','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','tools_tags','t.id\x20=\x20ct.TagId','split','Tags','push','rows','catch','find','params','describe','startsWith','columnName','displayName','findAll','cf_','alias','values','Error\x20customFields:\x20filed\x20%s\x20not\x20present\x20in\x20table\x20cm_contact','body','get','tags','join','info','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatMessage','update','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','VoiceCallReport','FaxQueueReport','MailQueueReport','SmsQueueReport','JscriptySessionReport','each','duplicates','spread','show','Tag','color','$and','format','cf_%d','CmCustomField','omit','pickBy','table','setFields','toParam','text','phone','findOne','getTags','nolimit','setTags','options','includeAll','include','getHopperHistories','CmHopperHistory','rawAttributes','ContactId','getJscriptySessions','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values'];(function(_0x57b54c,_0x54ce0d){var _0x59cc19=function(_0xa33bc6){while(--_0xa33bc6){_0x57b54c['push'](_0x57b54c['shift']());}};_0x59cc19(++_0x54ce0d);}(_0x1740,0x1c6));var _0x0174=function(_0x401134,_0x35d034){_0x401134=_0x401134-0x0;var _0x519255=_0x1740[_0x401134];return _0x519255;};'use strict';var pdf=require(_0x0174('0x0'));var emlformat=require(_0x0174('0x1'));var rimraf=require(_0x0174('0x2'));var zipdir=require(_0x0174('0x3'));var jsonpatch=require(_0x0174('0x4'));var rp=require(_0x0174('0x5'));var moment=require('moment');var BPromise=require(_0x0174('0x6'));var Mustache=require(_0x0174('0x7'));var util=require('util');var path=require('path');var sox=require(_0x0174('0x8'));var csv=require(_0x0174('0x9'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x0174('0xa'));var squel=require(_0x0174('0xb'));var crypto=require('crypto');var jsforce=require(_0x0174('0xc'));var deskjs=require(_0x0174('0xd'));var toCsv=require(_0x0174('0x9'));var querystring=require(_0x0174('0xe'));var Papa=require('papaparse');var Redis=require(_0x0174('0xf'));var authService=require('../../components/auth/service');var qs=require(_0x0174('0x10'));var hardwareService=require(_0x0174('0x11'));var logger=require(_0x0174('0x12'))(_0x0174('0x13'));var utils=require(_0x0174('0x14'));var config=require('../../config/environment');var db=require('../../mysqldb')['db'];config[_0x0174('0x15')]=_[_0x0174('0x16')](config[_0x0174('0x15')],{'host':_0x0174('0x17'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config['redis']));require(_0x0174('0x18'))[_0x0174('0x19')](socket);function respondWithStatusCode(_0x179842,_0x10dcc8){_0x10dcc8=_0x10dcc8||0xcc;return function(_0x5951a7){if(_0x5951a7){return _0x179842[_0x0174('0x1a')](_0x10dcc8);}return _0x179842['status'](_0x10dcc8)[_0x0174('0x1b')]();};}function respondWithResult(_0x261b0e,_0xf08fce){_0xf08fce=_0xf08fce||0xc8;return function(_0x59f22a){if(_0x59f22a){return _0x261b0e[_0x0174('0x1c')](_0xf08fce)[_0x0174('0x1d')](_0x59f22a);}};}function respondWithFilteredResult(_0x2f1c34,_0x3618ba){return function(_0x8130e){if(_0x8130e){var _0x495cd3=_0x8130e[_0x0174('0x1e')],_0x12ef40=_0x3618ba[_0x0174('0x1f')],_0x34674d=_0x3618ba[_0x0174('0x1f')]+_0x3618ba[_0x0174('0x20')],_0x44927d;if(_0x34674d>=_0x495cd3){_0x34674d=_0x495cd3;_0x44927d=0xc8;}else{_0x44927d=0xce;}_0x2f1c34['status'](_0x44927d);return _0x2f1c34[_0x0174('0x21')](_0x0174('0x22'),_0x12ef40+'-'+_0x34674d+'/'+_0x495cd3)[_0x0174('0x1d')](_0x8130e);}return null;};}function patchUpdates(_0x39098b){return function(_0x183136){try{jsonpatch[_0x0174('0x23')](_0x183136,_0x39098b,!![]);}catch(_0x57d296){return BPromise[_0x0174('0x24')](_0x57d296);}return _0x183136[_0x0174('0x25')]();};}function saveUpdates(_0xe64fef,_0x36aec5){return function(_0xc5bab9){if(_0xc5bab9){return _0xc5bab9['update'](_0xe64fef)[_0x0174('0x26')](function(_0x563afe){return _0x563afe;});}return null;};}function removeEntity(_0x23022b,_0x33a187){return function(_0x207622){if(_0x207622){return _0x207622[_0x0174('0x27')]()[_0x0174('0x26')](function(){_0x23022b[_0x0174('0x1c')](0xcc)[_0x0174('0x1b')]();});}};}function handleEntityNotFound(_0x3866fd,_0x196c70){return function(_0x3282f4){if(!_0x3282f4){_0x3866fd[_0x0174('0x1a')](0x194);}return _0x3282f4;};}function handleError(_0x29ab29,_0x36c13c){_0x36c13c=_0x36c13c||0x1f4;return function(_0x4aa08e){logger[_0x0174('0x28')](_0x4aa08e[_0x0174('0x29')]);if(_0x4aa08e['name']){delete _0x4aa08e[_0x0174('0x2a')];}_0x29ab29[_0x0174('0x1c')](_0x36c13c)['send'](_0x4aa08e);};}exports['index']=function(_0x3f20b7,_0x10c22a){var _0x33675f={},_0x5094e7={},_0x56968e={'count':0x0,'rows':[]};return db[_0x0174('0x2b')]['describe']()[_0x0174('0x26')](function(_0x4a9501){_0x5094e7['model']=_[_0x0174('0x2c')](_0x4a9501);_0x5094e7['query']=_[_0x0174('0x2c')](_0x3f20b7[_0x0174('0x2d')]);_0x5094e7['filters']=_[_0x0174('0x2e')](_0x5094e7[_0x0174('0x2f')],_0x5094e7['query']);_0x33675f[_0x0174('0x30')]=_[_0x0174('0x2e')](_0x5094e7[_0x0174('0x2f')],qs['fields'](_0x3f20b7[_0x0174('0x2d')][_0x0174('0x31')]));_0x33675f[_0x0174('0x30')]=_0x33675f['attributes'][_0x0174('0x32')]?_0x33675f['attributes']:_0x5094e7[_0x0174('0x2f')];if(!_0x3f20b7[_0x0174('0x2d')][_0x0174('0x33')]('nolimit')){_0x33675f[_0x0174('0x20')]=qs[_0x0174('0x20')](_0x3f20b7['query'][_0x0174('0x20')]);_0x33675f[_0x0174('0x1f')]=qs[_0x0174('0x1f')](_0x3f20b7['query'][_0x0174('0x1f')]);}_0x33675f[_0x0174('0x34')]=qs[_0x0174('0x35')](_0x3f20b7[_0x0174('0x2d')][_0x0174('0x35')]);_0x33675f[_0x0174('0x36')]=qs[_0x0174('0x37')](_[_0x0174('0x38')](_0x3f20b7[_0x0174('0x2d')],_0x5094e7[_0x0174('0x37')]));var _0x299de0=[];var _0x18c4c9=squel['select']()[_0x0174('0x39')]('id')[_0x0174('0x39')](_0x0174('0x2a'))[_0x0174('0x39')]('color')[_0x0174('0x3a')]('tools_tags');var _0xc0fe04=squel[_0x0174('0x3b')]()[_0x0174('0x3a')](_0x0174('0x3c'),'c')[_0x0174('0x36')](_0x0174('0x3d'));var _0x2d7c58=squel['expr']();if(_0x3f20b7['query'][_0x0174('0x3e')]){var _0x576d19=JSON[_0x0174('0x3f')](_0x3f20b7[_0x0174('0x2d')][_0x0174('0x3e')]);_['keys'](_0x576d19)[_0x0174('0x40')](function(_0x533b66){var _0x1c246b=_0x576d19[_0x533b66];switch(_0x1c246b[_0x0174('0x41')]){case'IS':if(_[_0x0174('0x42')](_0x1c246b['value'])&&_0x1c246b[_0x0174('0x43')][_0x0174('0x32')]>0x1){_0x2d7c58[_0x0174('0x44')](_0x1c246b[_0x0174('0x45')]+'.'+_0x533b66+_0x0174('0x46'),_0x1c246b[_0x0174('0x43')]);}else{_0x2d7c58['and'](_0x1c246b[_0x0174('0x45')]+'.'+_0x533b66+'\x20=\x20?',_0x1c246b[_0x0174('0x43')][0x0]);}break;case'=':_0x2d7c58['and'](_0x1c246b['tableAlias']+'.'+_0x533b66+_0x0174('0x47'),_0x1c246b[_0x0174('0x43')]);break;case'LIKE':_0x2d7c58[_0x0174('0x44')](_0x1c246b[_0x0174('0x45')]+'.'+_0x533b66+_0x0174('0x48'),'%'+_0x1c246b[_0x0174('0x43')]+'%');break;case'>':_0x2d7c58[_0x0174('0x44')](_0x1c246b['tableAlias']+'.'+_0x533b66+_0x0174('0x49'),_0x1c246b[_0x0174('0x43')]);break;case'<':_0x2d7c58[_0x0174('0x44')](_0x1c246b[_0x0174('0x45')]+'.'+_0x533b66+_0x0174('0x4a'),_0x1c246b['value']);break;}});}else{var _0x25ef42=_(Object['keys'](_0x3f20b7[_0x0174('0x2d')]))[_0x0174('0x4b')](function(_0x4999ff){return _0x4a9501['hasOwnProperty'](_0x4999ff)?_0x4999ff:undefined;})[_0x0174('0x4c')](function(_0x11105f){return!_[_0x0174('0x4d')](_0x11105f);})[_0x0174('0x43')]();if(!_[_0x0174('0x4e')](_0x25ef42)){_0x25ef42[_0x0174('0x40')](function(_0x954cf4){if(_0x954cf4===_0x0174('0x4f')){_0xc0fe04[_0x0174('0x36')](_0x0174('0x50'),[]['concat'](_0x3f20b7[_0x0174('0x2d')][_0x954cf4]));}else{_0xc0fe04[_0x0174('0x36')]('c.'+_0x954cf4+_0x0174('0x47'),_0x3f20b7[_0x0174('0x2d')][_0x954cf4]);}});}if(_0x3f20b7[_0x0174('0x2d')]['filter']){var _0x3f64a4=_0x3f20b7[_0x0174('0x2d')]['filter'][_0x0174('0x51')]('\x5c','\x5c\x5c')[_0x0174('0x51')]('\x27\x27',_0x0174('0x52'));if(qs['isNumeric'](_0x3f64a4)){_0x2d7c58['or'](_0x0174('0x53'),_0x3f64a4+'%');_0x2d7c58['or'](_0x0174('0x54'),_0x3f64a4+'%');_0x2d7c58['or'](_0x0174('0x55'),_0x3f64a4+'%');_0x2d7c58['or']('c.fax\x20LIKE\x20?',_0x3f64a4+'%');}else if(qs[_0x0174('0x56')](_0x3f64a4)){_0x2d7c58['or'](_0x0174('0x57'),_0x3f64a4+'%');}else{_0x2d7c58['or']('c.email\x20LIKE\x20?',_0x3f64a4+'%');_0x2d7c58['or'](_0x0174('0x58'),_0x3f64a4+'%');_0x2d7c58['or'](_0x0174('0x59'),_0x3f64a4+'%');}}}_0xc0fe04[_0x0174('0x36')](_0x2d7c58);if(_0x33675f['order']){_0x33675f[_0x0174('0x34')][_0x0174('0x40')](function(_0x165e89){_0xc0fe04[_0x0174('0x34')]('c.'+_0x165e89[0x0],_0x165e89[0x1]==='DESC'?![]:!![]);});}_0xc0fe04['group'](_0x0174('0x5a'));var _0x36a189={'type':db[_0x0174('0x5b')][_0x0174('0x5c')][_0x0174('0x5d')],'raw':!![]};var _0x3e6249=_0xc0fe04[_0x0174('0x5e')]()[_0x0174('0x39')](_0x0174('0x5f'));if(!_0x3f20b7[_0x0174('0x2d')][_0x0174('0x3e')]){if(_0x3f20b7[_0x0174('0x2d')]['tag']){var _0x20aa70=_[_0x0174('0x42')](_0x3f20b7[_0x0174('0x2d')]['tag'])?_0x3f20b7['query'][_0x0174('0x60')]:new Array(_0x3f20b7[_0x0174('0x2d')]['tag']);var _0x3007ba=squel[_0x0174('0x61')]();_0x20aa70['forEach'](function(_0x1302e8){_0x3007ba['or'](_0x0174('0x62'),'%,'+_0x1302e8+',%');});_0xc0fe04[_0x0174('0x63')](_0x3007ba);_0x3e6249[_0x0174('0x64')](_0x0174('0x65'),'ct',_0x0174('0x66'));_0x3e6249[_0x0174('0x64')]('tools_tags','t','t.id\x20=\x20ct.TagId');_0x3e6249[_0x0174('0x36')](_0x0174('0x67'),_0x20aa70);}}db['sequelize'][_0x0174('0x2d')](_0x18c4c9[_0x0174('0x68')](),_0x36a189)['then'](function(_0xfe5e16){_0x299de0=_['keyBy'](_0xfe5e16,'id');return db[_0x0174('0x69')]['query'](_0x3e6249['toString'](),_0x36a189);})[_0x0174('0x26')](function(_0x35157d){_0x56968e[_0x0174('0x1e')]=_0x35157d[_0x0174('0x32')];_0x36a189=_[_0x0174('0x6a')](_0x36a189,{'model':db[_0x0174('0x2b')],'mapToModel':!![],'raw':!![],'nest':!![]});_0xc0fe04[_0x0174('0x39')](_0x0174('0x6b'));_0xc0fe04[_0x0174('0x39')](_0x0174('0x6c'),_0x0174('0x6d'));_0xc0fe04['left_join']('cm_contact_has_tags','ct',_0x0174('0x66'));_0xc0fe04[_0x0174('0x64')](_0x0174('0x6e'),'t',_0x0174('0x6f'));if(_0x33675f[_0x0174('0x20')]){_0xc0fe04[_0x0174('0x20')](_0x33675f[_0x0174('0x20')]);}if(_0x33675f[_0x0174('0x1f')]){_0xc0fe04[_0x0174('0x1f')](_0x33675f[_0x0174('0x1f')]);}db[_0x0174('0x69')][_0x0174('0x2d')](_0xc0fe04['toString'](),_0x36a189)[_0x0174('0x26')](function(_0x157eb1){_0x157eb1[_0x0174('0x40')](function(_0x380078){if(_0x380078['TagIds']){_0x380078['Tags']=[];_0x380078['TagIds'][_0x0174('0x70')](',')['forEach'](function(_0x2d1fab){_0x380078[_0x0174('0x71')][_0x0174('0x72')](_0x299de0[_0x2d1fab]);});}delete _0x380078['TagIds'];});_0x56968e[_0x0174('0x73')]=_0x157eb1;return _0x56968e;})[_0x0174('0x26')](respondWithFilteredResult(_0x10c22a,_0x33675f))[_0x0174('0x74')](handleError(_0x10c22a,null));});});};exports['destroy']=function(_0x148555,_0x44cbb0){return db[_0x0174('0x2b')][_0x0174('0x75')]({'where':{'id':_0x148555[_0x0174('0x76')]['id']}})[_0x0174('0x26')](handleEntityNotFound(_0x44cbb0,null))[_0x0174('0x26')](removeEntity(_0x44cbb0,null))[_0x0174('0x74')](handleError(_0x44cbb0,null));};exports[_0x0174('0x77')]=function(_0x524f7e,_0x3b4060){return db[_0x0174('0x2b')][_0x0174('0x77')]()[_0x0174('0x26')](function(_0x358b61){for(var _0x14df88=0x0;_0x14df88<Object['keys'](_0x358b61)[_0x0174('0x32')];_0x14df88++){var _0x2a09d7=Object[_0x0174('0x2c')](_0x358b61)[_0x14df88];if(!_[_0x0174('0x78')](_0x2a09d7,'cf_')){_0x358b61[_0x2a09d7][_0x0174('0x79')]=_0x2a09d7;_0x358b61[_0x2a09d7][_0x0174('0x7a')]=_0x2a09d7;}}return _0x358b61;})[_0x0174('0x26')](function(_0xf391e6){var _0x3f7d33={'where':{'$or':[{'ListId':_0x524f7e[_0x0174('0x2d')]['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField'][_0x0174('0x7b')](_0x3f7d33)[_0x0174('0x26')](function(_0x49cde3){for(var _0x304c04=0x0;_0x304c04<_0x49cde3[_0x0174('0x32')];_0x304c04++){var _0x380d69=_0x0174('0x7c')+_0x49cde3[_0x304c04]['id'];if(_0xf391e6[_0x380d69]){_0xf391e6[_0x380d69][_0x0174('0x79')]=_0x380d69;_0xf391e6[_0x380d69][_0x0174('0x7a')]=_0x49cde3[_0x304c04][_0x0174('0x7d')];_0xf391e6[_0x380d69]['custom']={'type':_0x49cde3[_0x304c04]['type'],'values':_0x49cde3[_0x304c04][_0x0174('0x7e')]};}else{logger[_0x0174('0x28')](_0x0174('0x7f'),_0x380d69);}}Object['keys'](_0xf391e6)[_0x0174('0x40')](function(_0x1c2c69){if(!_0xf391e6[_0x1c2c69][_0x0174('0x33')]('columnName')){delete _0xf391e6[_0x1c2c69];}});return _0xf391e6;});})['then'](respondWithResult(_0x3b4060,null))[_0x0174('0x74')](handleError(_0x3b4060,null));};exports[_0x0174('0x6a')]=function(_0x554b77,_0x5d8698){var _0x4366f3;var _0x3263a9;var _0x281f4f;if(_0x554b77[_0x0174('0x80')]['id']){delete _0x554b77[_0x0174('0x80')]['id'];}return db[_0x0174('0x2b')]['findAll']({'where':{'id':[_0x554b77[_0x0174('0x80')]['to'],_0x554b77['body'][_0x0174('0x3a')]]}})[_0x0174('0x26')](function(_0x24ab3b){if(_0x24ab3b){if(_0x24ab3b['length']!==0x2){return null;}_0x24ab3b[0x0]=_0x24ab3b[0x0][_0x0174('0x81')]({'plain':!![]});_0x24ab3b[0x1]=_0x24ab3b[0x1][_0x0174('0x81')]({'plain':!![]});delete _0x24ab3b[0x0]['id'];delete _0x24ab3b[0x1]['id'];return _['mergeWith'](_0x24ab3b[0x0],_0x24ab3b[0x1],function(_0x15990b,_0xf74f34){if(Array['isArray'](_0xf74f34)&&!_0xf74f34[_0x0174('0x32')]){return _0x15990b;}else if(!_0xf74f34){return _0x15990b;}});}})[_0x0174('0x26')](handleEntityNotFound(_0x5d8698,null))[_0x0174('0x26')](function(_0x1d7966){if(_0x1d7966){if(_0x1d7966[_0x0174('0x82')]&&_[_0x0174('0x42')](_0x1d7966[_0x0174('0x82')])){_0x1d7966[_0x0174('0x82')]=_0x1d7966[_0x0174('0x82')][_0x0174('0x83')]();}logger[_0x0174('0x84')]('[CmContact][merge]\x20to\x20%s\x20from\x20%s',_0x554b77[_0x0174('0x80')]['to'],_0x554b77['body'][_0x0174('0x3a')]);return db[_0x0174('0x85')][_0x0174('0x27')]({'where':{'ContactId':[_0x554b77[_0x0174('0x80')]['to'],_0x554b77[_0x0174('0x80')][_0x0174('0x3a')]]}})[_0x0174('0x26')](function(_0x3a1450){logger['info'](_0x0174('0x86'),_0x3a1450);return db[_0x0174('0x87')][_0x0174('0x27')]({'where':{'ContactId':[_0x554b77[_0x0174('0x80')]['to'],_0x554b77['body'][_0x0174('0x3a')]]}})[_0x0174('0x26')](function(_0x7b9faf){logger[_0x0174('0x84')](_0x0174('0x88'),_0x7b9faf);return db[_0x0174('0x2b')][_0x0174('0x89')](_0x1d7966);});});}})[_0x0174('0x26')](function(_0x5bdb9b){if(_0x5bdb9b){_0x4366f3=_0x5bdb9b;_0x3263a9={'ContactId':_0x4366f3['id']};_0x281f4f={'where':{'ContactId':[_0x554b77[_0x0174('0x80')]['to'],_0x554b77[_0x0174('0x80')][_0x0174('0x3a')]]}};return db['ChatInteraction']['update'](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x8a')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x8c')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x8d')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x8e')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db['MailInteraction'][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x8e')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x8f')]['update'](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x90')]['update'](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x91')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x92')]['update'](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x93')]['update'](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x94')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x95')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})['then'](function(){if(_0x4366f3){return db['CmHopperHistory'][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db['ReportAgentPreview'][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x96')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db['ChatQueueReport'][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x97')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})['then'](function(){if(_0x4366f3){return db[_0x0174('0x98')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db['OpenchannelQueueReport'][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})['then'](function(){if(_0x4366f3){return db[_0x0174('0x99')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x9a')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x2b')][_0x0174('0x27')]({'where':{'id':[_0x554b77['body']['to'],_0x554b77['body'][_0x0174('0x3a')]]}});}})[_0x0174('0x26')](function(){if(_0x4366f3){return _0x4366f3;}})[_0x0174('0x26')](respondWithResult(_0x5d8698,null))[_0x0174('0x74')](handleError(_0x5d8698,null));};exports['create']=function(_0x1c7f08,_0x362cf9){return db[_0x0174('0x2b')]['describe']()[_0x0174('0x26')](function(_0x5ee35b){if(_0x1c7f08[_0x0174('0x80')][_0x0174('0x82')]&&_[_0x0174('0x42')](_0x1c7f08[_0x0174('0x80')][_0x0174('0x82')])){if(_0x1c7f08[_0x0174('0x80')][_0x0174('0x82')][_0x0174('0x32')]){_0x1c7f08['body'][_0x0174('0x82')]=_0x1c7f08[_0x0174('0x80')][_0x0174('0x82')][_0x0174('0x83')](';')+';';}else{_0x1c7f08[_0x0174('0x80')]['tags']=null;}}else{_0x1c7f08['body'][_0x0174('0x82')]=null;}return db[_0x0174('0x2b')][_0x0174('0x89')](_0x1c7f08[_0x0174('0x80')],{'fields':_[_0x0174('0x2c')](_0x5ee35b),'raw':!![]});})['then'](respondWithResult(_0x362cf9,0xc9))['catch'](handleError(_0x362cf9,null));};exports['bulkCreate']=function(_0x4f60a3,_0x48533e){var _0x16a5c2=[];var _0x498bfa=0x0;var _0x3964c3=0x0;var _0x4094e0=0x0;return db[_0x0174('0x2b')][_0x0174('0x77')]()[_0x0174('0x26')](function(_0x18c683){return BPromise[_0x0174('0x9b')](_0x4f60a3['body'],function(_0x1b0b93){var _0x14f40c={'where':{'$or':[]},'defaults':_0x1b0b93,'fields':_[_0x0174('0x2c')](_0x18c683),'raw':!![]};if(_0x1b0b93['duplicates']){for(var _0x49227b=0x0;_0x49227b<_0x1b0b93[_0x0174('0x9c')]['length'];_0x49227b++){var _0x498ab7={};_0x498ab7[_0x1b0b93[_0x0174('0x9c')][_0x49227b]]=_0x1b0b93[_0x1b0b93[_0x0174('0x9c')][_0x49227b]];_0x14f40c[_0x0174('0x36')]['$or'][_0x0174('0x72')](_0x498ab7);}_0x14f40c[_0x0174('0x36')][_0x0174('0x4f')]=_0x1b0b93['ListId'];}return db[_0x0174('0x2b')]['findOrCreate'](_0x14f40c)[_0x0174('0x9d')](function(_0x88580f,_0x192aac){if(_0x192aac){_0x498bfa++;}else{_0x4094e0++;}})['catch'](function(_0x44a2f4){console['error'](_0x44a2f4);_0x3964c3++;});});})[_0x0174('0x26')](function(_0x245915){if(_0x245915){return{'success':_0x498bfa,'failure':_0x3964c3,'duplicates':_0x4094e0};}})[_0x0174('0x26')](respondWithResult(_0x48533e,0xc9))[_0x0174('0x74')](handleError(_0x48533e,null));};exports[_0x0174('0x9e')]=function(_0x2de536,_0xb58536,_0x25133f){var _0x3812cf;return db[_0x0174('0x2b')][_0x0174('0x77')]()[_0x0174('0x26')](function(_0x5d5a60){return db['CmContact'][_0x0174('0x75')]({'where':{'id':_0x2de536[_0x0174('0x76')]['id']},'include':[{'model':db[_0x0174('0x9f')],'as':_0x0174('0x71'),'attributes':['id',_0x0174('0x2a'),_0x0174('0xa0')],'required':_0x2de536['query']['tag']?!![]:![]}],'attributes':_[_0x0174('0x2c')](_0x5d5a60)});})['then'](function(_0x4f5706){_0x3812cf=_0x4f5706[_0x0174('0x81')]({'plain':!![]});var _0x300f0b={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x4f5706&&_0x4f5706[_0x0174('0x4f')]){if(_0x4f5706[_0x0174('0x4f')]){_0x300f0b[_0x0174('0x36')][_0x0174('0xa1')][_0x0174('0x72')]({'ListId':{'$ne':_0x4f5706[_0x0174('0x4f')]}});}}return db['CmCustomField'][_0x0174('0x7b')](_0x300f0b);})['then'](function(_0x5c8581){return _['omit'](_0x3812cf,_[_0x0174('0x4b')](_0x5c8581,function(_0x164ef4){return util[_0x0174('0xa2')](_0x0174('0xa3'),_0x164ef4['id']);}));})['then'](handleEntityNotFound(_0xb58536,null))['then'](respondWithResult(_0xb58536,null))[_0x0174('0x74')](handleError(_0xb58536,null));};exports[_0x0174('0x8b')]=function(_0x195883,_0x4fac9a){var _0x2d05da;if(_0x195883[_0x0174('0x80')]['id']){delete _0x195883['body']['id'];}return db[_0x0174('0x2b')]['find']({'where':{'id':_0x195883[_0x0174('0x76')]['id']}})['then'](handleEntityNotFound(_0x4fac9a,null))[_0x0174('0x26')](saveUpdates(_0x195883[_0x0174('0x80')],null))[_0x0174('0x26')](function(_0x31b6fe){_0x2d05da=_0x31b6fe;var _0xca4802={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x31b6fe&&_0x31b6fe[_0x0174('0x4f')]){if(_0x31b6fe[_0x0174('0x4f')]){_0xca4802[_0x0174('0x36')]['$and']['push']({'ListId':{'$ne':_0x31b6fe[_0x0174('0x4f')]}});}}return db[_0x0174('0xa4')][_0x0174('0x7b')](_0xca4802);})[_0x0174('0x26')](function(_0x20b5b0){if(_0x20b5b0){return _[_0x0174('0xa5')](_[_0x0174('0xa6')](_0x195883[_0x0174('0x80')],function(_0x2aee67,_0x40d3cd){return _['startsWith'](_0x40d3cd,_0x0174('0x7c'));}),_[_0x0174('0x4b')](_0x20b5b0,function(_0x586bf0){return util[_0x0174('0xa2')](_0x0174('0xa3'),_0x586bf0['id']);}));}})[_0x0174('0x26')](function(_0x59c9a6){if(_0x59c9a6&&!_[_0x0174('0x4e')](_0x59c9a6)){var _0x5e85ba=squel[_0x0174('0x8b')]()[_0x0174('0xa7')](_0x0174('0x3c'))[_0x0174('0xa8')](_0x59c9a6)[_0x0174('0x36')]('id\x20=\x20?',_0x195883[_0x0174('0x76')]['id'])[_0x0174('0xa9')]();return db['sequelize'][_0x0174('0x2d')](_0x5e85ba[_0x0174('0xaa')],{'replacements':_0x5e85ba[_0x0174('0x7e')]});}})[_0x0174('0x26')](function(){if(_0x195883['body'][_0x0174('0xab')]&&_0x2d05da){return db[_0x0174('0x85')][_0x0174('0x8b')]({'phone':_0x195883[_0x0174('0x80')]['phone']},{'where':{'ContactId':_0x2d05da['id']}});}})['then'](function(){return _0x2d05da;})[_0x0174('0x26')](respondWithResult(_0x4fac9a,null))['catch'](handleError(_0x4fac9a,null));};exports['getTags']=function(_0xe76a5a,_0xc472db,_0x435858){var _0x11ccbe={};var _0x41c433={};var _0x160653;var _0x3b98d7;return db[_0x0174('0x2b')][_0x0174('0xac')]({'where':{'id':_0xe76a5a['params']['id']}})[_0x0174('0x26')](handleEntityNotFound(_0xc472db,null))[_0x0174('0x26')](function(_0x21c9c2){if(_0x21c9c2){_0x160653=_0x21c9c2;_0x41c433['model']=_[_0x0174('0x2c')](db['Tag']['rawAttributes']);_0x41c433[_0x0174('0x2d')]=_[_0x0174('0x2c')](_0xe76a5a['query']);_0x41c433[_0x0174('0x37')]=_[_0x0174('0x2e')](_0x41c433[_0x0174('0x2f')],_0x41c433['query']);_0x11ccbe[_0x0174('0x30')]=_[_0x0174('0x2e')](_0x41c433[_0x0174('0x2f')],qs[_0x0174('0x31')](_0xe76a5a[_0x0174('0x2d')][_0x0174('0x31')]));_0x11ccbe['attributes']=_0x11ccbe[_0x0174('0x30')][_0x0174('0x32')]?_0x11ccbe[_0x0174('0x30')]:_0x41c433[_0x0174('0x2f')];_0x11ccbe[_0x0174('0x34')]=qs[_0x0174('0x35')](_0xe76a5a['query']['sort']);_0x11ccbe[_0x0174('0x36')]=qs[_0x0174('0x37')](_[_0x0174('0x38')](_0xe76a5a[_0x0174('0x2d')],_0x41c433['filters']));if(_0xe76a5a['query'][_0x0174('0x4c')]){_0x11ccbe[_0x0174('0x36')]=_[_0x0174('0x6a')](_0x11ccbe[_0x0174('0x36')],{'$or':_[_0x0174('0x4b')](_0x11ccbe[_0x0174('0x30')],function(_0x24ad56){var _0x220938={};_0x220938[_0x24ad56]={'$like':'%'+_0xe76a5a[_0x0174('0x2d')][_0x0174('0x4c')]+'%'};return _0x220938;})});}_0x11ccbe=_[_0x0174('0x6a')]({},_0x11ccbe,_0xe76a5a['options']);return _0x160653[_0x0174('0xad')](_0x11ccbe);}})[_0x0174('0x26')](function(_0x14f7c5){if(_0x14f7c5){_0x3b98d7=_0x14f7c5['length'];if(!_0xe76a5a['query']['hasOwnProperty'](_0x0174('0xae'))){_0x11ccbe[_0x0174('0x20')]=qs['limit'](_0xe76a5a['query'][_0x0174('0x20')]);_0x11ccbe[_0x0174('0x1f')]=qs[_0x0174('0x1f')](_0xe76a5a['query'][_0x0174('0x1f')]);}return _0x160653[_0x0174('0xad')](_0x11ccbe);}})[_0x0174('0x26')](function(_0x441207){if(_0x441207){return _0x441207?{'count':_0x3b98d7,'rows':_0x441207}:null;}})['then'](respondWithResult(_0xc472db,null))[_0x0174('0x74')](handleError(_0xc472db,null));};exports[_0x0174('0xaf')]=function(_0x5bac31,_0x20cf3a,_0x5d15b1){if(_0x5bac31[_0x0174('0x80')]['id']){delete _0x5bac31[_0x0174('0x80')]['id'];}return db['CmContact'][_0x0174('0xac')]({'where':{'id':_0x5bac31[_0x0174('0x76')]['id']}})['then'](handleEntityNotFound(_0x20cf3a,null))['then'](function(_0x2a3159){if(_0x2a3159){return _0x2a3159[_0x0174('0xaf')](_0x5bac31['body']['ids']||[]);}return null;})[_0x0174('0x26')](respondWithResult(_0x20cf3a,null))[_0x0174('0x74')](handleError(_0x20cf3a,null));};exports['getHoppers']=function(_0x4e3aa4,_0x3e40e8,_0x5dd2d7){var _0x48722f={'raw':![],'where':{}};var _0x18a419={};var _0x1bdc73={'count':0x0,'rows':[]};return db[_0x0174('0x2b')]['findOne']({'where':{'id':_0x4e3aa4[_0x0174('0x76')]['id']}})[_0x0174('0x26')](handleEntityNotFound(_0x3e40e8,null))[_0x0174('0x26')](function(_0x545e09){if(_0x545e09){_0x18a419['model']=_[_0x0174('0x2c')](db['CmHopper']['rawAttributes']);_0x18a419[_0x0174('0x2d')]=_[_0x0174('0x2c')](_0x4e3aa4['query']);_0x18a419[_0x0174('0x37')]=_['intersection'](_0x18a419[_0x0174('0x2f')],_0x18a419[_0x0174('0x2d')]);_0x48722f[_0x0174('0x30')]=_[_0x0174('0x2e')](_0x18a419[_0x0174('0x2f')],qs['fields'](_0x4e3aa4[_0x0174('0x2d')][_0x0174('0x31')]));_0x48722f[_0x0174('0x30')]=_0x48722f[_0x0174('0x30')][_0x0174('0x32')]?_0x48722f[_0x0174('0x30')]:_0x18a419[_0x0174('0x2f')];if(!_0x4e3aa4[_0x0174('0x2d')][_0x0174('0x33')]('nolimit')){_0x48722f[_0x0174('0x20')]=qs[_0x0174('0x20')](_0x4e3aa4[_0x0174('0x2d')][_0x0174('0x20')]);_0x48722f[_0x0174('0x1f')]=qs[_0x0174('0x1f')](_0x4e3aa4[_0x0174('0x2d')][_0x0174('0x1f')]);}_0x48722f[_0x0174('0x34')]=qs[_0x0174('0x35')](_0x4e3aa4[_0x0174('0x2d')][_0x0174('0x35')]);_0x48722f[_0x0174('0x36')]=qs[_0x0174('0x37')](_[_0x0174('0x38')](_0x4e3aa4[_0x0174('0x2d')],_0x18a419[_0x0174('0x37')]));_0x48722f[_0x0174('0x36')]['ContactId']=_0x545e09['id'];if(_0x4e3aa4[_0x0174('0x2d')][_0x0174('0x4c')]){_0x48722f[_0x0174('0x36')]=_[_0x0174('0x6a')](_0x48722f[_0x0174('0x36')],{'$or':_['map'](_0x48722f['attributes'],function(_0x206146){var _0x2850ec={};_0x2850ec[_0x206146]={'$like':'%'+_0x4e3aa4[_0x0174('0x2d')][_0x0174('0x4c')]+'%'};return _0x2850ec;})});}_0x48722f=_[_0x0174('0x6a')]({},_0x48722f,_0x4e3aa4[_0x0174('0xb0')]);return db['CmHopper'][_0x0174('0x1e')]({'where':_0x48722f[_0x0174('0x36')]})[_0x0174('0x26')](function(_0x1264f4){_0x1bdc73[_0x0174('0x1e')]=_0x1264f4;if(_0x4e3aa4[_0x0174('0x2d')][_0x0174('0xb1')]){_0x48722f[_0x0174('0xb2')]=[{'all':!![]}];}return db[_0x0174('0x85')]['findAll'](_0x48722f);})['then'](function(_0x254661){_0x1bdc73[_0x0174('0x73')]=_0x254661;return _0x1bdc73;});}})['then'](respondWithFilteredResult(_0x3e40e8,_0x48722f))[_0x0174('0x74')](handleError(_0x3e40e8,null));};exports[_0x0174('0xb3')]=function(_0x1a514d,_0x41ff3c,_0x407460){var _0x2e352e={'raw':!![],'where':{}};var _0x43f10c={};var _0x12002a={'count':0x0,'rows':[]};return db['CmContact']['findOne']({'where':{'id':_0x1a514d[_0x0174('0x76')]['id']}})[_0x0174('0x26')](handleEntityNotFound(_0x41ff3c,null))['then'](function(_0x20abf7){if(_0x20abf7){_0x43f10c[_0x0174('0x2f')]=_[_0x0174('0x2c')](db[_0x0174('0xb4')][_0x0174('0xb5')]);_0x43f10c[_0x0174('0x2d')]=_['keys'](_0x1a514d[_0x0174('0x2d')]);_0x43f10c[_0x0174('0x37')]=_[_0x0174('0x2e')](_0x43f10c[_0x0174('0x2f')],_0x43f10c[_0x0174('0x2d')]);_0x2e352e['attributes']=_[_0x0174('0x2e')](_0x43f10c[_0x0174('0x2f')],qs['fields'](_0x1a514d[_0x0174('0x2d')][_0x0174('0x31')]));_0x2e352e['attributes']=_0x2e352e['attributes'][_0x0174('0x32')]?_0x2e352e['attributes']:_0x43f10c['model'];if(!_0x1a514d[_0x0174('0x2d')][_0x0174('0x33')](_0x0174('0xae'))){_0x2e352e[_0x0174('0x20')]=qs[_0x0174('0x20')](_0x1a514d['query'][_0x0174('0x20')]);_0x2e352e[_0x0174('0x1f')]=qs[_0x0174('0x1f')](_0x1a514d[_0x0174('0x2d')][_0x0174('0x1f')]);}_0x2e352e[_0x0174('0x34')]=qs[_0x0174('0x35')](_0x1a514d[_0x0174('0x2d')]['sort']);_0x2e352e['where']=qs[_0x0174('0x37')](_[_0x0174('0x38')](_0x1a514d['query'],_0x43f10c[_0x0174('0x37')]));_0x2e352e[_0x0174('0x36')][_0x0174('0xb6')]=_0x20abf7['id'];if(_0x1a514d[_0x0174('0x2d')][_0x0174('0x4c')]){_0x2e352e['where']=_[_0x0174('0x6a')](_0x2e352e[_0x0174('0x36')],{'$or':_[_0x0174('0x4b')](_0x2e352e[_0x0174('0x30')],function(_0x4da667){var _0x2b5e2d={};_0x2b5e2d[_0x4da667]={'$like':'%'+_0x1a514d[_0x0174('0x2d')][_0x0174('0x4c')]+'%'};return _0x2b5e2d;})});}_0x2e352e=_['merge']({},_0x2e352e,_0x1a514d[_0x0174('0xb0')]);return db[_0x0174('0xb4')][_0x0174('0x1e')]({'where':_0x2e352e[_0x0174('0x36')]})[_0x0174('0x26')](function(_0x4a07d6){_0x12002a[_0x0174('0x1e')]=_0x4a07d6;if(_0x1a514d[_0x0174('0x2d')][_0x0174('0xb1')]){_0x2e352e[_0x0174('0xb2')]=[{'all':!![]}];}return db[_0x0174('0xb4')][_0x0174('0x7b')](_0x2e352e);})['then'](function(_0x25c0e8){_0x12002a[_0x0174('0x73')]=_0x25c0e8;return _0x12002a;});}})[_0x0174('0x26')](respondWithFilteredResult(_0x41ff3c,_0x2e352e))[_0x0174('0x74')](handleError(_0x41ff3c,null));};exports['getHopperFinals']=function(_0x16c3a7,_0xf58ea1,_0x1a5651){var _0x50865b={'raw':!![],'where':{}};var _0x34e433={};var _0xde945a={'count':0x0,'rows':[]};return db[_0x0174('0x2b')][_0x0174('0xac')]({'where':{'id':_0x16c3a7[_0x0174('0x76')]['id']}})['then'](handleEntityNotFound(_0xf58ea1,null))[_0x0174('0x26')](function(_0x5e4e40){if(_0x5e4e40){_0x34e433['model']=_[_0x0174('0x2c')](db['CmHopperFinal'][_0x0174('0xb5')]);_0x34e433['query']=_['keys'](_0x16c3a7[_0x0174('0x2d')]);_0x34e433[_0x0174('0x37')]=_['intersection'](_0x34e433[_0x0174('0x2f')],_0x34e433['query']);_0x50865b[_0x0174('0x30')]=_['intersection'](_0x34e433[_0x0174('0x2f')],qs['fields'](_0x16c3a7['query'][_0x0174('0x31')]));_0x50865b['attributes']=_0x50865b[_0x0174('0x30')][_0x0174('0x32')]?_0x50865b[_0x0174('0x30')]:_0x34e433['model'];if(!_0x16c3a7['query'][_0x0174('0x33')](_0x0174('0xae'))){_0x50865b['limit']=qs[_0x0174('0x20')](_0x16c3a7[_0x0174('0x2d')]['limit']);_0x50865b[_0x0174('0x1f')]=qs[_0x0174('0x1f')](_0x16c3a7[_0x0174('0x2d')][_0x0174('0x1f')]);}_0x50865b[_0x0174('0x34')]=qs[_0x0174('0x35')](_0x16c3a7[_0x0174('0x2d')][_0x0174('0x35')]);_0x50865b[_0x0174('0x36')]=qs[_0x0174('0x37')](_[_0x0174('0x38')](_0x16c3a7[_0x0174('0x2d')],_0x34e433[_0x0174('0x37')]));_0x50865b[_0x0174('0x36')][_0x0174('0xb6')]=_0x5e4e40['id'];if(_0x16c3a7[_0x0174('0x2d')][_0x0174('0x4c')]){_0x50865b[_0x0174('0x36')]=_['merge'](_0x50865b[_0x0174('0x36')],{'$or':_[_0x0174('0x4b')](_0x50865b[_0x0174('0x30')],function(_0x27eb1e){var _0x4d4751={};_0x4d4751[_0x27eb1e]={'$like':'%'+_0x16c3a7[_0x0174('0x2d')][_0x0174('0x4c')]+'%'};return _0x4d4751;})});}_0x50865b=_[_0x0174('0x6a')]({},_0x50865b,_0x16c3a7['options']);return db[_0x0174('0x95')][_0x0174('0x1e')]({'where':_0x50865b[_0x0174('0x36')]})[_0x0174('0x26')](function(_0x123239){_0xde945a['count']=_0x123239;if(_0x16c3a7[_0x0174('0x2d')][_0x0174('0xb1')]){_0x50865b[_0x0174('0xb2')]=[{'all':!![]}];}return db[_0x0174('0x95')][_0x0174('0x7b')](_0x50865b);})['then'](function(_0x56efb0){_0xde945a[_0x0174('0x73')]=_0x56efb0;return _0xde945a;});}})[_0x0174('0x26')](respondWithFilteredResult(_0xf58ea1,_0x50865b))['catch'](handleError(_0xf58ea1,null));};exports[_0x0174('0xb7')]=function(_0x577cdb,_0x4bdc6a,_0x3518fb){var _0xa7570c={'raw':!![],'where':{}};var _0x28575b={};var _0x176133={'count':0x0,'rows':[]};return db['CmContact']['findOne']({'where':{'id':_0x577cdb[_0x0174('0x76')]['id']}})[_0x0174('0x26')](handleEntityNotFound(_0x4bdc6a,null))[_0x0174('0x26')](function(_0x486d54){if(_0x486d54){_0x28575b['model']=_[_0x0174('0x2c')](db['JscriptySessionReport'][_0x0174('0xb5')]);_0x28575b[_0x0174('0x2d')]=_[_0x0174('0x2c')](_0x577cdb['query']);_0x28575b[_0x0174('0x37')]=_[_0x0174('0x2e')](_0x28575b[_0x0174('0x2f')],_0x28575b['query']);_0xa7570c[_0x0174('0x30')]=_['intersection'](_0x28575b[_0x0174('0x2f')],qs[_0x0174('0x31')](_0x577cdb[_0x0174('0x2d')]['fields']));_0xa7570c['attributes']=_0xa7570c[_0x0174('0x30')][_0x0174('0x32')]?_0xa7570c[_0x0174('0x30')]:_0x28575b[_0x0174('0x2f')];if(!_0x577cdb['query'][_0x0174('0x33')]('nolimit')){_0xa7570c['limit']=qs[_0x0174('0x20')](_0x577cdb[_0x0174('0x2d')][_0x0174('0x20')]);_0xa7570c[_0x0174('0x1f')]=qs['offset'](_0x577cdb[_0x0174('0x2d')][_0x0174('0x1f')]);}_0xa7570c[_0x0174('0x34')]=qs[_0x0174('0x35')](_0x577cdb['query'][_0x0174('0x35')]);_0xa7570c[_0x0174('0x36')]=qs[_0x0174('0x37')](_[_0x0174('0x38')](_0x577cdb['query'],_0x28575b[_0x0174('0x37')]));_0xa7570c['where']['ContactId']=_0x486d54['id'];if(_0x577cdb[_0x0174('0x2d')][_0x0174('0x4c')]){_0xa7570c[_0x0174('0x36')]=_[_0x0174('0x6a')](_0xa7570c[_0x0174('0x36')],{'$or':_[_0x0174('0x4b')](_0xa7570c[_0x0174('0x30')],function(_0x95f60a){var _0x214843={};_0x214843[_0x95f60a]={'$like':'%'+_0x577cdb[_0x0174('0x2d')][_0x0174('0x4c')]+'%'};return _0x214843;})});}_0xa7570c=_[_0x0174('0x6a')]({},_0xa7570c,_0x577cdb[_0x0174('0xb0')]);return db[_0x0174('0x9a')][_0x0174('0x1e')]({'where':_0xa7570c[_0x0174('0x36')]})[_0x0174('0x26')](function(_0x1b3593){_0x176133['count']=_0x1b3593;if(_0x577cdb[_0x0174('0x2d')][_0x0174('0xb1')]){_0xa7570c[_0x0174('0xb2')]=[{'all':!![]}];}return db['JscriptySessionReport']['findAll'](_0xa7570c);})[_0x0174('0x26')](function(_0x358367){_0x176133[_0x0174('0x73')]=_0x358367;return _0x176133;});}})[_0x0174('0x26')](respondWithFilteredResult(_0x4bdc6a,_0xa7570c))[_0x0174('0x74')](handleError(_0x4bdc6a,null));};exports['uploadCsv']=function(_0x18193b,_0x1d446a,_0x1e2e6e){try{if(!_0x18193b['body']['ListId']){throw new Error(_0x0174('0xb8'));}if(!_0x18193b[_0x0174('0x80')][_0x0174('0xb9')]){throw new Error(_0x0174('0xba'));}if(!_0x18193b[_0x0174('0x80')][_0x0174('0xbb')]){throw new Error(_0x0174('0xbc'));}if(!_0x18193b[_0x0174('0x80')]['socket_timestamp']){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x415efe=_0x18193b['body'][_0x0174('0xb9')][_0x0174('0x70')](',');var _0x3ed79c=_0x18193b[_0x0174('0x80')][_0x0174('0xbb')][_0x0174('0x70')](',');if(!_0x415efe['length']||!_0x3ed79c[_0x0174('0x32')]||_0x415efe[_0x0174('0x32')]!==_0x3ed79c[_0x0174('0x32')]){throw new Error(_0x0174('0xbd'));}_0x18193b[_0x0174('0x80')][_0x0174('0x31')]=_['zipObject'](_0x415efe,_0x3ed79c);if(!_0x18193b[_0x0174('0x80')][_0x0174('0x31')][_0x0174('0xab')]){throw new Error(_0x0174('0xbe'));}if(!_0x18193b[_0x0174('0x80')][_0x0174('0x31')][_0x0174('0xbf')]){throw new Error(_0x0174('0xc0'));}var _0x304a65=path[_0x0174('0x83')](config[_0x0174('0xc1')],_0x0174('0xc2'),_0x18193b[_0x0174('0xc3')][_0x0174('0xc4')]);fs['chmodSync'](_0x304a65,parseInt(_0x0174('0xc5'),0x8));var _0x2ef3c0=require(_0x0174('0xc6'))[_0x0174('0xc7')](path['join'](__dirname,_0x0174('0xc8')),[_0x304a65,_0x18193b[_0x0174('0x80')][_0x0174('0xb9')],_0x18193b['body'][_0x0174('0xbb')],_0x18193b['body'][_0x0174('0x4f')],_0x18193b[_0x0174('0x80')]['CompanyId'],_0x18193b[_0x0174('0x80')][_0x0174('0x9c')],_0x18193b['body']['socket_timestamp']]);return _0x1d446a[_0x0174('0x1c')](0xc8)[_0x0174('0x1d')]({'message':_0x0174('0xc9'),'pid':_0x2ef3c0[_0x0174('0xca')]});}catch(_0x4f2015){return _0x1d446a['status'](0x1f4)[_0x0174('0xcb')](_0x4f2015);}};exports[_0x0174('0xcc')]=function(_0x1edafe,_0x3f553c,_0x3b981a){var _0x5e2b96=fs[_0x0174('0xcd')](_0x1edafe['file'][_0x0174('0xce')]);Papa['parse'](_0x5e2b96,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x5359aa){return _0x3f553c[_0x0174('0x1c')](0xc8)[_0x0174('0x1d')]({'file':_0x1edafe[_0x0174('0xc3')],'fields':_0x5359aa[_0x0174('0xcf')][_0x0174('0x31')]});}});};exports[_0x0174('0xd0')]=function(_0x1c7de1,_0xe11d4b,_0x5a0375){return db['User']['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0x0174('0xd1')}})['then'](function(_0x3019e7){var _0x4f8733=![];if(!_0x1c7de1['body']['ListId']){throw new Error('No\x20ListId\x20specified');}if(!_0x1c7de1[_0x0174('0x80')][_0x0174('0xd2')][_0x0174('0xab')]){throw new Error(_0x0174('0xbe'));}if(!_0x1c7de1[_0x0174('0x80')][_0x0174('0xd2')][_0x0174('0xbf')]){throw new Error(_0x0174('0xc0'));}if(!_0x1c7de1[_0x0174('0x80')][_0x0174('0xd3')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x8fa868=require(_0x0174('0xc6'))['fork'](path[_0x0174('0x83')](__dirname,'../../components/import/cm/csv2'),[_0x1c7de1['params']['id'],JSON[_0x0174('0xd4')](_0x1c7de1[_0x0174('0x80')]),JSON['stringify'](_0x3019e7)]);_0x8fa868['on']('message',function(_0x16f551){_0x4f8733=!![];return _0xe11d4b[_0x0174('0x1c')](0xc8)[_0x0174('0x1d')]({'message':_0x0174('0xd5'),'pid':_0x8fa868['pid']});});_0x8fa868['on']('exit',function(_0x13062a){if(_0x13062a&&!_0x4f8733){return _0xe11d4b[_0x0174('0x1c')](0x1f4)['json']({'message':'error\x20child\x20process','pid':_0x8fa868[_0x0174('0xca')]});}});})[_0x0174('0x74')](handleError(_0xe11d4b,null));};
\ No newline at end of file
+var _0x8caf=['isEmpty','ListId','concat','replace','\x27\x27\x27\x27','isNumeric','c.id\x20LIKE\x20?','c.phone\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','DESC','group','Sequelize','QueryTypes','clone','COUNT(*)','tag','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','left_join','cm_contact_has_tags','toString','count','merge','c.*','GROUP_CONCAT(DISTINCT\x20t.id)','ct.CmContactId\x20=\x20c.id','t.id\x20=\x20ct.TagId','sequelize','TagIds','Tags','split','rows','catch','find','describe','startsWith','cf_','columnName','displayName','CmCustomField','findAll','alias','values','body','get','mergeWith','tags','join','info','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','CmHopperHistory','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','each','duplicates','$or','findOrCreate','show','color','$and','map','format','cf_%d','params','push','pickBy','table','setFields','id\x20=\x20?','text','phone','getTags','findOne','Tag','rawAttributes','options','nolimit','setTags','ids','CmHopper','ContactId','include','getHopperHistories','includeAll','getHopperFinals','getJscriptySessions','JscriptySessionReport','binding_keys','No\x20association\x20keys\x20specified!','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','root','server/files/tmp','file','filename','chmodSync','0777','child_process','../../components/import/cm/csv','binding_values','File\x20uploaded\x20correctly!','upload','createReadStream','path','parse','meta','import','agent','binding','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','pid','exit','error\x20child\x20process','html-pdf','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','ejs','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../config/license/hardware','api','../../config/utils','../../config/environment','../../mysqldb','defaults','redis','localhost','socket.io-emitter','./cmContact.socket','register','status','end','json','offset','limit','set','Content-Range','apply','reject','save','update','then','destroy','sendStatus','error','stack','name','send','index','CmContact','model','keys','query','intersection','attributes','fields','length','hasOwnProperty','order','sort','filters','pick','select','field','from','tools_tags','cm_contacts','where','c.deletedAt\x20IS\x20NULL','expr','advancedFilter','forEach','isArray','value','and','tableAlias','\x20IN\x20?','\x20=\x20?','LIKE','\x20LIKE\x20?','\x20<\x20?','filter'];(function(_0x5a6f8e,_0x28f638){var _0x49d2a2=function(_0x29466e){while(--_0x29466e){_0x5a6f8e['push'](_0x5a6f8e['shift']());}};_0x49d2a2(++_0x28f638);}(_0x8caf,0x16f));var _0xf8ca=function(_0x1465d4,_0x2d3d48){_0x1465d4=_0x1465d4-0x0;var _0x118a84=_0x8caf[_0x1465d4];return _0x118a84;};'use strict';var pdf=require(_0xf8ca('0x0'));var emlformat=require(_0xf8ca('0x1'));var rimraf=require('rimraf');var zipdir=require(_0xf8ca('0x2'));var jsonpatch=require(_0xf8ca('0x3'));var rp=require(_0xf8ca('0x4'));var moment=require(_0xf8ca('0x5'));var BPromise=require(_0xf8ca('0x6'));var Mustache=require(_0xf8ca('0x7'));var util=require('util');var path=require('path');var sox=require('sox');var csv=require('to-csv');var ejs=require(_0xf8ca('0x8'));var fs=require('fs');var _=require('lodash');var squel=require(_0xf8ca('0x9'));var crypto=require(_0xf8ca('0xa'));var jsforce=require(_0xf8ca('0xb'));var deskjs=require(_0xf8ca('0xc'));var toCsv=require('to-csv');var querystring=require(_0xf8ca('0xd'));var Papa=require(_0xf8ca('0xe'));var Redis=require(_0xf8ca('0xf'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var hardwareService=require(_0xf8ca('0x10'));var logger=require('../../config/logger')(_0xf8ca('0x11'));var utils=require(_0xf8ca('0x12'));var config=require(_0xf8ca('0x13'));var db=require(_0xf8ca('0x14'))['db'];config['redis']=_[_0xf8ca('0x15')](config[_0xf8ca('0x16')],{'host':_0xf8ca('0x17'),'port':0x18eb});var socket=require(_0xf8ca('0x18'))(new Redis(config['redis']));require(_0xf8ca('0x19'))[_0xf8ca('0x1a')](socket);function respondWithStatusCode(_0x214c87,_0x164a75){_0x164a75=_0x164a75||0xcc;return function(_0x5b626d){if(_0x5b626d){return _0x214c87['sendStatus'](_0x164a75);}return _0x214c87[_0xf8ca('0x1b')](_0x164a75)[_0xf8ca('0x1c')]();};}function respondWithResult(_0x5ab64a,_0x5891ac){_0x5891ac=_0x5891ac||0xc8;return function(_0x587318){if(_0x587318){return _0x5ab64a['status'](_0x5891ac)[_0xf8ca('0x1d')](_0x587318);}};}function respondWithFilteredResult(_0x2f3ee7,_0x5897eb){return function(_0x49bbc3){if(_0x49bbc3){var _0x242cf0=_0x49bbc3['count'],_0x5617f9=_0x5897eb[_0xf8ca('0x1e')],_0x36276a=_0x5897eb[_0xf8ca('0x1e')]+_0x5897eb[_0xf8ca('0x1f')],_0x26adc8;if(_0x36276a>=_0x242cf0){_0x36276a=_0x242cf0;_0x26adc8=0xc8;}else{_0x26adc8=0xce;}_0x2f3ee7['status'](_0x26adc8);return _0x2f3ee7[_0xf8ca('0x20')](_0xf8ca('0x21'),_0x5617f9+'-'+_0x36276a+'/'+_0x242cf0)[_0xf8ca('0x1d')](_0x49bbc3);}return null;};}function patchUpdates(_0x5a1514){return function(_0x84d870){try{jsonpatch[_0xf8ca('0x22')](_0x84d870,_0x5a1514,!![]);}catch(_0x6ba561){return BPromise[_0xf8ca('0x23')](_0x6ba561);}return _0x84d870[_0xf8ca('0x24')]();};}function saveUpdates(_0x23de15,_0x3cda80){return function(_0xf56094){if(_0xf56094){return _0xf56094[_0xf8ca('0x25')](_0x23de15)[_0xf8ca('0x26')](function(_0xe83772){return _0xe83772;});}return null;};}function removeEntity(_0x303ecd,_0x148f1d){return function(_0x3dfa68){if(_0x3dfa68){return _0x3dfa68[_0xf8ca('0x27')]()[_0xf8ca('0x26')](function(){_0x303ecd[_0xf8ca('0x1b')](0xcc)[_0xf8ca('0x1c')]();});}};}function handleEntityNotFound(_0x50f5b0,_0x1296f8){return function(_0x1b1d68){if(!_0x1b1d68){_0x50f5b0[_0xf8ca('0x28')](0x194);}return _0x1b1d68;};}function handleError(_0x4a7101,_0x243bfc){_0x243bfc=_0x243bfc||0x1f4;return function(_0x4eae1c){logger[_0xf8ca('0x29')](_0x4eae1c[_0xf8ca('0x2a')]);if(_0x4eae1c[_0xf8ca('0x2b')]){delete _0x4eae1c[_0xf8ca('0x2b')];}_0x4a7101['status'](_0x243bfc)[_0xf8ca('0x2c')](_0x4eae1c);};}exports[_0xf8ca('0x2d')]=function(_0x26fe0a,_0x36760){var _0x32a62a={},_0x462f13={},_0x1d2a0a={'count':0x0,'rows':[]};return db[_0xf8ca('0x2e')]['describe']()[_0xf8ca('0x26')](function(_0x461248){_0x462f13[_0xf8ca('0x2f')]=_[_0xf8ca('0x30')](_0x461248);_0x462f13[_0xf8ca('0x31')]=_['keys'](_0x26fe0a['query']);_0x462f13['filters']=_[_0xf8ca('0x32')](_0x462f13[_0xf8ca('0x2f')],_0x462f13[_0xf8ca('0x31')]);_0x32a62a[_0xf8ca('0x33')]=_['intersection'](_0x462f13[_0xf8ca('0x2f')],qs[_0xf8ca('0x34')](_0x26fe0a[_0xf8ca('0x31')]['fields']));_0x32a62a[_0xf8ca('0x33')]=_0x32a62a[_0xf8ca('0x33')][_0xf8ca('0x35')]?_0x32a62a[_0xf8ca('0x33')]:_0x462f13[_0xf8ca('0x2f')];if(!_0x26fe0a['query'][_0xf8ca('0x36')]('nolimit')){_0x32a62a[_0xf8ca('0x1f')]=qs[_0xf8ca('0x1f')](_0x26fe0a['query']['limit']);_0x32a62a[_0xf8ca('0x1e')]=qs[_0xf8ca('0x1e')](_0x26fe0a['query'][_0xf8ca('0x1e')]);}_0x32a62a[_0xf8ca('0x37')]=qs['sort'](_0x26fe0a[_0xf8ca('0x31')][_0xf8ca('0x38')]);_0x32a62a['where']=qs[_0xf8ca('0x39')](_[_0xf8ca('0x3a')](_0x26fe0a['query'],_0x462f13[_0xf8ca('0x39')]));var _0x2a84d2=[];var _0x19e474=squel[_0xf8ca('0x3b')]()[_0xf8ca('0x3c')]('id')[_0xf8ca('0x3c')](_0xf8ca('0x2b'))['field']('color')[_0xf8ca('0x3d')](_0xf8ca('0x3e'));var _0x31062c=squel[_0xf8ca('0x3b')]()[_0xf8ca('0x3d')](_0xf8ca('0x3f'),'c')[_0xf8ca('0x40')](_0xf8ca('0x41'));var _0x28cb50=squel[_0xf8ca('0x42')]();if(_0x26fe0a[_0xf8ca('0x31')]['advancedFilter']){var _0x486531=JSON['parse'](_0x26fe0a[_0xf8ca('0x31')][_0xf8ca('0x43')]);_[_0xf8ca('0x30')](_0x486531)[_0xf8ca('0x44')](function(_0x11c848){var _0x26749e=_0x486531[_0x11c848];switch(_0x26749e['condition']){case'IS':if(_[_0xf8ca('0x45')](_0x26749e[_0xf8ca('0x46')])&&_0x26749e[_0xf8ca('0x46')][_0xf8ca('0x35')]>0x1){_0x28cb50[_0xf8ca('0x47')](_0x26749e[_0xf8ca('0x48')]+'.'+_0x11c848+_0xf8ca('0x49'),_0x26749e[_0xf8ca('0x46')]);}else{_0x28cb50[_0xf8ca('0x47')](_0x26749e['tableAlias']+'.'+_0x11c848+'\x20=\x20?',_0x26749e['value'][0x0]);}break;case'=':_0x28cb50[_0xf8ca('0x47')](_0x26749e[_0xf8ca('0x48')]+'.'+_0x11c848+_0xf8ca('0x4a'),_0x26749e[_0xf8ca('0x46')]);break;case _0xf8ca('0x4b'):_0x28cb50[_0xf8ca('0x47')](_0x26749e[_0xf8ca('0x48')]+'.'+_0x11c848+_0xf8ca('0x4c'),'%'+_0x26749e[_0xf8ca('0x46')]+'%');break;case'>':_0x28cb50['and'](_0x26749e[_0xf8ca('0x48')]+'.'+_0x11c848+'\x20>\x20?',_0x26749e[_0xf8ca('0x46')]);break;case'<':_0x28cb50[_0xf8ca('0x47')](_0x26749e[_0xf8ca('0x48')]+'.'+_0x11c848+_0xf8ca('0x4d'),_0x26749e[_0xf8ca('0x46')]);break;}});}else{var _0x30591d=_(Object['keys'](_0x26fe0a[_0xf8ca('0x31')]))['map'](function(_0x49110e){return _0x461248[_0xf8ca('0x36')](_0x49110e)?_0x49110e:undefined;})[_0xf8ca('0x4e')](function(_0x149781){return!_['isNil'](_0x149781);})[_0xf8ca('0x46')]();if(!_[_0xf8ca('0x4f')](_0x30591d)){_0x30591d[_0xf8ca('0x44')](function(_0x97124d){if(_0x97124d===_0xf8ca('0x50')){_0x31062c[_0xf8ca('0x40')]('c.ListId\x20IN\x20?',[][_0xf8ca('0x51')](_0x26fe0a[_0xf8ca('0x31')][_0x97124d]));}else{_0x31062c[_0xf8ca('0x40')]('c.'+_0x97124d+'\x20=\x20?',_0x26fe0a[_0xf8ca('0x31')][_0x97124d]);}});}if(_0x26fe0a[_0xf8ca('0x31')]['filter']){var _0x1fa89c=_0x26fe0a[_0xf8ca('0x31')]['filter']['replace']('\x5c','\x5c\x5c')[_0xf8ca('0x52')]('\x27\x27',_0xf8ca('0x53'));if(qs[_0xf8ca('0x54')](_0x1fa89c)){_0x28cb50['or'](_0xf8ca('0x55'),_0x1fa89c+'%');_0x28cb50['or'](_0xf8ca('0x56'),_0x1fa89c+'%');_0x28cb50['or']('c.mobile\x20LIKE\x20?',_0x1fa89c+'%');_0x28cb50['or'](_0xf8ca('0x57'),_0x1fa89c+'%');}else if(qs[_0xf8ca('0x58')](_0x1fa89c)){_0x28cb50['or'](_0xf8ca('0x59'),_0x1fa89c+'%');}else{_0x28cb50['or']('c.email\x20LIKE\x20?',_0x1fa89c+'%');_0x28cb50['or'](_0xf8ca('0x5a'),_0x1fa89c+'%');_0x28cb50['or'](_0xf8ca('0x5b'),_0x1fa89c+'%');}}}_0x31062c[_0xf8ca('0x40')](_0x28cb50);if(_0x32a62a['order']){_0x32a62a[_0xf8ca('0x37')][_0xf8ca('0x44')](function(_0x5400d6){_0x31062c[_0xf8ca('0x37')]('c.'+_0x5400d6[0x0],_0x5400d6[0x1]===_0xf8ca('0x5c')?![]:!![]);});}_0x31062c[_0xf8ca('0x5d')]('c.id');var _0x56ca3e={'type':db[_0xf8ca('0x5e')][_0xf8ca('0x5f')]['SELECT'],'raw':!![]};var _0x29a1ca=_0x31062c[_0xf8ca('0x60')]()[_0xf8ca('0x3c')](_0xf8ca('0x61'));if(!_0x26fe0a[_0xf8ca('0x31')]['advancedFilter']){if(_0x26fe0a[_0xf8ca('0x31')][_0xf8ca('0x62')]){var _0x18ae70=_[_0xf8ca('0x45')](_0x26fe0a['query'][_0xf8ca('0x62')])?_0x26fe0a[_0xf8ca('0x31')][_0xf8ca('0x62')]:new Array(_0x26fe0a[_0xf8ca('0x31')]['tag']);var _0x430a4b=squel[_0xf8ca('0x42')]();_0x18ae70[_0xf8ca('0x44')](function(_0x2f617e){_0x430a4b['or'](_0xf8ca('0x63'),'%,'+_0x2f617e+',%');});_0x31062c['having'](_0x430a4b);_0x29a1ca[_0xf8ca('0x64')](_0xf8ca('0x65'),'ct','ct.CmContactId\x20=\x20c.id');_0x29a1ca[_0xf8ca('0x64')](_0xf8ca('0x3e'),'t','t.id\x20=\x20ct.TagId');_0x29a1ca[_0xf8ca('0x40')]('t.id\x20IN\x20?',_0x18ae70);}}db['sequelize'][_0xf8ca('0x31')](_0x19e474['toString'](),_0x56ca3e)[_0xf8ca('0x26')](function(_0x364846){_0x2a84d2=_['keyBy'](_0x364846,'id');return db['sequelize'][_0xf8ca('0x31')](_0x29a1ca[_0xf8ca('0x66')](),_0x56ca3e);})['then'](function(_0x1c994a){_0x1d2a0a[_0xf8ca('0x67')]=_0x1c994a[_0xf8ca('0x35')];_0x56ca3e=_[_0xf8ca('0x68')](_0x56ca3e,{'model':db[_0xf8ca('0x2e')],'mapToModel':!![],'raw':!![],'nest':!![]});_0x31062c[_0xf8ca('0x3c')](_0xf8ca('0x69'));_0x31062c[_0xf8ca('0x3c')](_0xf8ca('0x6a'),'TagIds');_0x31062c[_0xf8ca('0x64')](_0xf8ca('0x65'),'ct',_0xf8ca('0x6b'));_0x31062c[_0xf8ca('0x64')]('tools_tags','t',_0xf8ca('0x6c'));if(_0x32a62a[_0xf8ca('0x1f')]){_0x31062c[_0xf8ca('0x1f')](_0x32a62a[_0xf8ca('0x1f')]);}if(_0x32a62a[_0xf8ca('0x1e')]){_0x31062c[_0xf8ca('0x1e')](_0x32a62a[_0xf8ca('0x1e')]);}db[_0xf8ca('0x6d')][_0xf8ca('0x31')](_0x31062c[_0xf8ca('0x66')](),_0x56ca3e)['then'](function(_0x5047a0){_0x5047a0[_0xf8ca('0x44')](function(_0x9eec49){if(_0x9eec49[_0xf8ca('0x6e')]){_0x9eec49[_0xf8ca('0x6f')]=[];_0x9eec49['TagIds'][_0xf8ca('0x70')](',')[_0xf8ca('0x44')](function(_0xbefba7){_0x9eec49[_0xf8ca('0x6f')]['push'](_0x2a84d2[_0xbefba7]);});}delete _0x9eec49[_0xf8ca('0x6e')];});_0x1d2a0a[_0xf8ca('0x71')]=_0x5047a0;return _0x1d2a0a;})['then'](respondWithFilteredResult(_0x36760,_0x32a62a))[_0xf8ca('0x72')](handleError(_0x36760,null));});});};exports[_0xf8ca('0x27')]=function(_0x15aaf9,_0x19c45f){return db[_0xf8ca('0x2e')][_0xf8ca('0x73')]({'where':{'id':_0x15aaf9['params']['id']}})[_0xf8ca('0x26')](handleEntityNotFound(_0x19c45f,null))['then'](removeEntity(_0x19c45f,null))[_0xf8ca('0x72')](handleError(_0x19c45f,null));};exports[_0xf8ca('0x74')]=function(_0x41da0a,_0x5499d8){return db[_0xf8ca('0x2e')]['describe']()[_0xf8ca('0x26')](function(_0x1a3c60){for(var _0x4e8c02=0x0;_0x4e8c02<Object[_0xf8ca('0x30')](_0x1a3c60)[_0xf8ca('0x35')];_0x4e8c02++){var _0x4a97da=Object['keys'](_0x1a3c60)[_0x4e8c02];if(!_[_0xf8ca('0x75')](_0x4a97da,_0xf8ca('0x76'))){_0x1a3c60[_0x4a97da][_0xf8ca('0x77')]=_0x4a97da;_0x1a3c60[_0x4a97da][_0xf8ca('0x78')]=_0x4a97da;}}return _0x1a3c60;})[_0xf8ca('0x26')](function(_0x2410bf){var _0x4494ad={'where':{'$or':[{'ListId':_0x41da0a[_0xf8ca('0x31')]['id']},{'ListId':null}]},'raw':!![]};return db[_0xf8ca('0x79')][_0xf8ca('0x7a')](_0x4494ad)['then'](function(_0x1a8ae1){for(var _0xd381c2=0x0;_0xd381c2<_0x1a8ae1[_0xf8ca('0x35')];_0xd381c2++){var _0x1a2d39=_0xf8ca('0x76')+_0x1a8ae1[_0xd381c2]['id'];if(_0x2410bf[_0x1a2d39]){_0x2410bf[_0x1a2d39][_0xf8ca('0x77')]=_0x1a2d39;_0x2410bf[_0x1a2d39][_0xf8ca('0x78')]=_0x1a8ae1[_0xd381c2][_0xf8ca('0x7b')];_0x2410bf[_0x1a2d39]['custom']={'type':_0x1a8ae1[_0xd381c2]['type'],'values':_0x1a8ae1[_0xd381c2][_0xf8ca('0x7c')]};}else{logger[_0xf8ca('0x29')]('Error\x20customFields:\x20filed\x20%s\x20not\x20present\x20in\x20table\x20cm_contact',_0x1a2d39);}}Object['keys'](_0x2410bf)[_0xf8ca('0x44')](function(_0x3a6fc8){if(!_0x2410bf[_0x3a6fc8][_0xf8ca('0x36')](_0xf8ca('0x77'))){delete _0x2410bf[_0x3a6fc8];}});return _0x2410bf;});})[_0xf8ca('0x26')](respondWithResult(_0x5499d8,null))[_0xf8ca('0x72')](handleError(_0x5499d8,null));};exports['merge']=function(_0x337e55,_0x951b67){var _0x5d1b58;var _0x5dcded;var _0x1c0608;if(_0x337e55[_0xf8ca('0x7d')]['id']){delete _0x337e55[_0xf8ca('0x7d')]['id'];}return db[_0xf8ca('0x2e')][_0xf8ca('0x7a')]({'where':{'id':[_0x337e55[_0xf8ca('0x7d')]['to'],_0x337e55['body'][_0xf8ca('0x3d')]]}})[_0xf8ca('0x26')](function(_0x2328ca){if(_0x2328ca){if(_0x2328ca['length']!==0x2){return null;}_0x2328ca[0x0]=_0x2328ca[0x0]['get']({'plain':!![]});_0x2328ca[0x1]=_0x2328ca[0x1][_0xf8ca('0x7e')]({'plain':!![]});delete _0x2328ca[0x0]['id'];delete _0x2328ca[0x1]['id'];return _[_0xf8ca('0x7f')](_0x2328ca[0x0],_0x2328ca[0x1],function(_0x23f103,_0x9645e8){if(Array['isArray'](_0x9645e8)&&!_0x9645e8[_0xf8ca('0x35')]){return _0x23f103;}else if(!_0x9645e8){return _0x23f103;}});}})[_0xf8ca('0x26')](handleEntityNotFound(_0x951b67,null))[_0xf8ca('0x26')](function(_0x1a62b7){if(_0x1a62b7){if(_0x1a62b7[_0xf8ca('0x80')]&&_[_0xf8ca('0x45')](_0x1a62b7[_0xf8ca('0x80')])){_0x1a62b7[_0xf8ca('0x80')]=_0x1a62b7[_0xf8ca('0x80')][_0xf8ca('0x81')]();}logger[_0xf8ca('0x82')]('[CmContact][merge]\x20to\x20%s\x20from\x20%s',_0x337e55[_0xf8ca('0x7d')]['to'],_0x337e55[_0xf8ca('0x7d')][_0xf8ca('0x3d')]);return db['CmHopper'][_0xf8ca('0x27')]({'where':{'ContactId':[_0x337e55[_0xf8ca('0x7d')]['to'],_0x337e55[_0xf8ca('0x7d')][_0xf8ca('0x3d')]]}})[_0xf8ca('0x26')](function(_0x45d345){logger[_0xf8ca('0x82')](_0xf8ca('0x83'),_0x45d345);return db[_0xf8ca('0x84')][_0xf8ca('0x27')]({'where':{'ContactId':[_0x337e55[_0xf8ca('0x7d')]['to'],_0x337e55[_0xf8ca('0x7d')][_0xf8ca('0x3d')]]}})['then'](function(_0x26ae6a){logger[_0xf8ca('0x82')](_0xf8ca('0x85'),_0x26ae6a);return db[_0xf8ca('0x2e')][_0xf8ca('0x86')](_0x1a62b7);});});}})[_0xf8ca('0x26')](function(_0x56883a){if(_0x56883a){_0x5d1b58=_0x56883a;_0x5dcded={'ContactId':_0x5d1b58['id']};_0x1c0608={'where':{'ContactId':[_0x337e55['body']['to'],_0x337e55[_0xf8ca('0x7d')][_0xf8ca('0x3d')]]}};return db[_0xf8ca('0x87')][_0xf8ca('0x25')](_0x5dcded,_0x1c0608);}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return db[_0xf8ca('0x88')][_0xf8ca('0x25')](_0x5dcded,_0x1c0608);}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return db[_0xf8ca('0x89')][_0xf8ca('0x25')](_0x5dcded,_0x1c0608);}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return db[_0xf8ca('0x8a')][_0xf8ca('0x25')](_0x5dcded,_0x1c0608);}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return db[_0xf8ca('0x8b')][_0xf8ca('0x25')](_0x5dcded,_0x1c0608);}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return db[_0xf8ca('0x8a')][_0xf8ca('0x25')](_0x5dcded,_0x1c0608);}})['then'](function(){if(_0x5d1b58){return db[_0xf8ca('0x8b')][_0xf8ca('0x25')](_0x5dcded,_0x1c0608);}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return db[_0xf8ca('0x8c')]['update'](_0x5dcded,_0x1c0608);}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return db[_0xf8ca('0x8d')][_0xf8ca('0x25')](_0x5dcded,_0x1c0608);}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return db[_0xf8ca('0x8e')][_0xf8ca('0x25')](_0x5dcded,_0x1c0608);}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return db[_0xf8ca('0x8f')][_0xf8ca('0x25')](_0x5dcded,_0x1c0608);}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return db[_0xf8ca('0x90')][_0xf8ca('0x25')](_0x5dcded,_0x1c0608);}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return db[_0xf8ca('0x91')]['update'](_0x5dcded,_0x1c0608);}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return db[_0xf8ca('0x92')][_0xf8ca('0x25')](_0x5dcded,_0x1c0608);}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return db[_0xf8ca('0x93')][_0xf8ca('0x25')](_0x5dcded,_0x1c0608);}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return db['ReportAgentPreview']['update'](_0x5dcded,_0x1c0608);}})['then'](function(){if(_0x5d1b58){return db[_0xf8ca('0x94')]['update'](_0x5dcded,_0x1c0608);}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return db[_0xf8ca('0x95')]['update'](_0x5dcded,_0x1c0608);}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return db[_0xf8ca('0x96')][_0xf8ca('0x25')](_0x5dcded,_0x1c0608);}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return db[_0xf8ca('0x97')][_0xf8ca('0x25')](_0x5dcded,_0x1c0608);}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return db[_0xf8ca('0x98')]['update'](_0x5dcded,_0x1c0608);}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return db[_0xf8ca('0x99')]['update'](_0x5dcded,_0x1c0608);}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return db['JscriptySessionReport'][_0xf8ca('0x25')](_0x5dcded,_0x1c0608);}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return db[_0xf8ca('0x2e')][_0xf8ca('0x27')]({'where':{'id':[_0x337e55[_0xf8ca('0x7d')]['to'],_0x337e55['body']['from']]}});}})[_0xf8ca('0x26')](function(){if(_0x5d1b58){return _0x5d1b58;}})[_0xf8ca('0x26')](respondWithResult(_0x951b67,null))[_0xf8ca('0x72')](handleError(_0x951b67,null));};exports[_0xf8ca('0x86')]=function(_0x506792,_0x40cc21){return db[_0xf8ca('0x2e')][_0xf8ca('0x74')]()[_0xf8ca('0x26')](function(_0x12d18a){if(_0x506792[_0xf8ca('0x7d')][_0xf8ca('0x80')]&&_['isArray'](_0x506792['body'][_0xf8ca('0x80')])){if(_0x506792['body'][_0xf8ca('0x80')][_0xf8ca('0x35')]){_0x506792[_0xf8ca('0x7d')][_0xf8ca('0x80')]=_0x506792['body'][_0xf8ca('0x80')][_0xf8ca('0x81')](';')+';';}else{_0x506792['body'][_0xf8ca('0x80')]=null;}}else{_0x506792[_0xf8ca('0x7d')][_0xf8ca('0x80')]=null;}return db[_0xf8ca('0x2e')]['create'](_0x506792[_0xf8ca('0x7d')],{'fields':_[_0xf8ca('0x30')](_0x12d18a),'raw':!![]});})[_0xf8ca('0x26')](respondWithResult(_0x40cc21,0xc9))['catch'](handleError(_0x40cc21,null));};exports['bulkCreate']=function(_0x48aa73,_0x3d227b){var _0x175eef=[];var _0x442926=0x0;var _0x41ba09=0x0;var _0xa3c5b4=0x0;return db[_0xf8ca('0x2e')][_0xf8ca('0x74')]()[_0xf8ca('0x26')](function(_0x378a6b){return BPromise[_0xf8ca('0x9a')](_0x48aa73[_0xf8ca('0x7d')],function(_0xf64bb1){var _0xd281e9={'where':{'$or':[]},'defaults':_0xf64bb1,'fields':_['keys'](_0x378a6b),'raw':!![]};if(_0xf64bb1[_0xf8ca('0x9b')]){for(var _0x11132d=0x0;_0x11132d<_0xf64bb1[_0xf8ca('0x9b')][_0xf8ca('0x35')];_0x11132d++){var _0x3ed26f={};_0x3ed26f[_0xf64bb1[_0xf8ca('0x9b')][_0x11132d]]=_0xf64bb1[_0xf64bb1[_0xf8ca('0x9b')][_0x11132d]];_0xd281e9['where'][_0xf8ca('0x9c')]['push'](_0x3ed26f);}_0xd281e9[_0xf8ca('0x40')]['ListId']=_0xf64bb1[_0xf8ca('0x50')];}return db[_0xf8ca('0x2e')][_0xf8ca('0x9d')](_0xd281e9)['spread'](function(_0x42d200,_0x454b56){if(_0x454b56){_0x442926++;}else{_0xa3c5b4++;}})[_0xf8ca('0x72')](function(_0x43d029){console[_0xf8ca('0x29')](_0x43d029);_0x41ba09++;});});})[_0xf8ca('0x26')](function(_0x4d6318){if(_0x4d6318){return{'success':_0x442926,'failure':_0x41ba09,'duplicates':_0xa3c5b4};}})['then'](respondWithResult(_0x3d227b,0xc9))['catch'](handleError(_0x3d227b,null));};exports[_0xf8ca('0x9e')]=function(_0x4dbb1d,_0x305881,_0x37362c){var _0x4b9a5f;return db[_0xf8ca('0x2e')]['describe']()['then'](function(_0x565c60){return db['CmContact']['find']({'where':{'id':_0x4dbb1d['params']['id']},'include':[{'model':db['Tag'],'as':_0xf8ca('0x6f'),'attributes':['id',_0xf8ca('0x2b'),_0xf8ca('0x9f')],'required':_0x4dbb1d['query'][_0xf8ca('0x62')]?!![]:![]}],'attributes':_[_0xf8ca('0x30')](_0x565c60)});})[_0xf8ca('0x26')](function(_0x19e368){_0x4b9a5f=_0x19e368[_0xf8ca('0x7e')]({'plain':!![]});var _0x3170b8={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x19e368&&_0x19e368['ListId']){if(_0x19e368[_0xf8ca('0x50')]){_0x3170b8[_0xf8ca('0x40')][_0xf8ca('0xa0')]['push']({'ListId':{'$ne':_0x19e368[_0xf8ca('0x50')]}});}}return db['CmCustomField'][_0xf8ca('0x7a')](_0x3170b8);})[_0xf8ca('0x26')](function(_0x1efc8d){return _['omit'](_0x4b9a5f,_[_0xf8ca('0xa1')](_0x1efc8d,function(_0x9c1b19){return util[_0xf8ca('0xa2')](_0xf8ca('0xa3'),_0x9c1b19['id']);}));})[_0xf8ca('0x26')](handleEntityNotFound(_0x305881,null))[_0xf8ca('0x26')](respondWithResult(_0x305881,null))[_0xf8ca('0x72')](handleError(_0x305881,null));};exports[_0xf8ca('0x25')]=function(_0x35e34a,_0x158955){var _0x22306b;if(_0x35e34a[_0xf8ca('0x7d')]['id']){delete _0x35e34a[_0xf8ca('0x7d')]['id'];}return db['CmContact'][_0xf8ca('0x73')]({'where':{'id':_0x35e34a[_0xf8ca('0xa4')]['id']}})[_0xf8ca('0x26')](handleEntityNotFound(_0x158955,null))[_0xf8ca('0x26')](saveUpdates(_0x35e34a[_0xf8ca('0x7d')],null))['then'](function(_0x14d4da){_0x22306b=_0x14d4da;var _0x5062f5={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x14d4da&&_0x14d4da[_0xf8ca('0x50')]){if(_0x14d4da[_0xf8ca('0x50')]){_0x5062f5[_0xf8ca('0x40')][_0xf8ca('0xa0')][_0xf8ca('0xa5')]({'ListId':{'$ne':_0x14d4da[_0xf8ca('0x50')]}});}}return db[_0xf8ca('0x79')][_0xf8ca('0x7a')](_0x5062f5);})['then'](function(_0x2360a2){if(_0x2360a2){return _['omit'](_[_0xf8ca('0xa6')](_0x35e34a['body'],function(_0x40a971,_0x48f9dd){return _[_0xf8ca('0x75')](_0x48f9dd,_0xf8ca('0x76'));}),_[_0xf8ca('0xa1')](_0x2360a2,function(_0x1627f1){return util[_0xf8ca('0xa2')](_0xf8ca('0xa3'),_0x1627f1['id']);}));}})[_0xf8ca('0x26')](function(_0x227a76){if(_0x227a76&&!_[_0xf8ca('0x4f')](_0x227a76)){var _0x3d2cd0=squel['update']()[_0xf8ca('0xa7')](_0xf8ca('0x3f'))[_0xf8ca('0xa8')](_0x227a76)[_0xf8ca('0x40')](_0xf8ca('0xa9'),_0x35e34a[_0xf8ca('0xa4')]['id'])['toParam']();return db[_0xf8ca('0x6d')]['query'](_0x3d2cd0[_0xf8ca('0xaa')],{'replacements':_0x3d2cd0['values']});}})[_0xf8ca('0x26')](function(){if(_0x35e34a[_0xf8ca('0x7d')][_0xf8ca('0xab')]&&_0x22306b){return db['CmHopper']['update']({'phone':_0x35e34a[_0xf8ca('0x7d')][_0xf8ca('0xab')]},{'where':{'ContactId':_0x22306b['id']}});}})[_0xf8ca('0x26')](function(){return _0x22306b;})[_0xf8ca('0x26')](respondWithResult(_0x158955,null))[_0xf8ca('0x72')](handleError(_0x158955,null));};exports[_0xf8ca('0xac')]=function(_0x41d8fe,_0x348355,_0x940509){var _0x5d3ec1={};var _0x5c995f={};var _0x1b7809;var _0x12065c;return db[_0xf8ca('0x2e')][_0xf8ca('0xad')]({'where':{'id':_0x41d8fe[_0xf8ca('0xa4')]['id']}})[_0xf8ca('0x26')](handleEntityNotFound(_0x348355,null))[_0xf8ca('0x26')](function(_0x41e723){if(_0x41e723){_0x1b7809=_0x41e723;_0x5c995f[_0xf8ca('0x2f')]=_[_0xf8ca('0x30')](db[_0xf8ca('0xae')][_0xf8ca('0xaf')]);_0x5c995f[_0xf8ca('0x31')]=_['keys'](_0x41d8fe['query']);_0x5c995f[_0xf8ca('0x39')]=_['intersection'](_0x5c995f[_0xf8ca('0x2f')],_0x5c995f['query']);_0x5d3ec1[_0xf8ca('0x33')]=_[_0xf8ca('0x32')](_0x5c995f[_0xf8ca('0x2f')],qs[_0xf8ca('0x34')](_0x41d8fe['query'][_0xf8ca('0x34')]));_0x5d3ec1['attributes']=_0x5d3ec1[_0xf8ca('0x33')][_0xf8ca('0x35')]?_0x5d3ec1['attributes']:_0x5c995f[_0xf8ca('0x2f')];_0x5d3ec1['order']=qs[_0xf8ca('0x38')](_0x41d8fe[_0xf8ca('0x31')][_0xf8ca('0x38')]);_0x5d3ec1[_0xf8ca('0x40')]=qs[_0xf8ca('0x39')](_['pick'](_0x41d8fe[_0xf8ca('0x31')],_0x5c995f[_0xf8ca('0x39')]));if(_0x41d8fe[_0xf8ca('0x31')][_0xf8ca('0x4e')]){_0x5d3ec1[_0xf8ca('0x40')]=_[_0xf8ca('0x68')](_0x5d3ec1[_0xf8ca('0x40')],{'$or':_[_0xf8ca('0xa1')](_0x5d3ec1[_0xf8ca('0x33')],function(_0x24c0b0){var _0x130a07={};_0x130a07[_0x24c0b0]={'$like':'%'+_0x41d8fe[_0xf8ca('0x31')]['filter']+'%'};return _0x130a07;})});}_0x5d3ec1=_['merge']({},_0x5d3ec1,_0x41d8fe[_0xf8ca('0xb0')]);return _0x1b7809[_0xf8ca('0xac')](_0x5d3ec1);}})[_0xf8ca('0x26')](function(_0x32cc1d){if(_0x32cc1d){_0x12065c=_0x32cc1d[_0xf8ca('0x35')];if(!_0x41d8fe[_0xf8ca('0x31')][_0xf8ca('0x36')](_0xf8ca('0xb1'))){_0x5d3ec1[_0xf8ca('0x1f')]=qs[_0xf8ca('0x1f')](_0x41d8fe[_0xf8ca('0x31')][_0xf8ca('0x1f')]);_0x5d3ec1[_0xf8ca('0x1e')]=qs[_0xf8ca('0x1e')](_0x41d8fe[_0xf8ca('0x31')]['offset']);}return _0x1b7809[_0xf8ca('0xac')](_0x5d3ec1);}})[_0xf8ca('0x26')](function(_0x37ace6){if(_0x37ace6){return _0x37ace6?{'count':_0x12065c,'rows':_0x37ace6}:null;}})['then'](respondWithResult(_0x348355,null))[_0xf8ca('0x72')](handleError(_0x348355,null));};exports[_0xf8ca('0xb2')]=function(_0x45d637,_0x2b29db,_0x5b4f8a){if(_0x45d637[_0xf8ca('0x7d')]['id']){delete _0x45d637[_0xf8ca('0x7d')]['id'];}return db[_0xf8ca('0x2e')][_0xf8ca('0xad')]({'where':{'id':_0x45d637[_0xf8ca('0xa4')]['id']}})[_0xf8ca('0x26')](handleEntityNotFound(_0x2b29db,null))[_0xf8ca('0x26')](function(_0x4fe44f){if(_0x4fe44f){return _0x4fe44f[_0xf8ca('0xb2')](_0x45d637[_0xf8ca('0x7d')][_0xf8ca('0xb3')]||[]);}return null;})[_0xf8ca('0x26')](respondWithResult(_0x2b29db,null))['catch'](handleError(_0x2b29db,null));};exports['getHoppers']=function(_0x10befc,_0x2af32d,_0xaeecd3){var _0x134f7e={'raw':![],'where':{}};var _0x32e7a6={};var _0x1b78ed={'count':0x0,'rows':[]};return db[_0xf8ca('0x2e')]['findOne']({'where':{'id':_0x10befc[_0xf8ca('0xa4')]['id']}})[_0xf8ca('0x26')](handleEntityNotFound(_0x2af32d,null))[_0xf8ca('0x26')](function(_0xeb57b){if(_0xeb57b){_0x32e7a6[_0xf8ca('0x2f')]=_[_0xf8ca('0x30')](db[_0xf8ca('0xb4')]['rawAttributes']);_0x32e7a6[_0xf8ca('0x31')]=_[_0xf8ca('0x30')](_0x10befc['query']);_0x32e7a6[_0xf8ca('0x39')]=_[_0xf8ca('0x32')](_0x32e7a6['model'],_0x32e7a6['query']);_0x134f7e['attributes']=_[_0xf8ca('0x32')](_0x32e7a6[_0xf8ca('0x2f')],qs[_0xf8ca('0x34')](_0x10befc[_0xf8ca('0x31')]['fields']));_0x134f7e[_0xf8ca('0x33')]=_0x134f7e[_0xf8ca('0x33')][_0xf8ca('0x35')]?_0x134f7e[_0xf8ca('0x33')]:_0x32e7a6[_0xf8ca('0x2f')];if(!_0x10befc[_0xf8ca('0x31')]['hasOwnProperty'](_0xf8ca('0xb1'))){_0x134f7e[_0xf8ca('0x1f')]=qs[_0xf8ca('0x1f')](_0x10befc[_0xf8ca('0x31')][_0xf8ca('0x1f')]);_0x134f7e[_0xf8ca('0x1e')]=qs['offset'](_0x10befc[_0xf8ca('0x31')]['offset']);}_0x134f7e[_0xf8ca('0x37')]=qs[_0xf8ca('0x38')](_0x10befc[_0xf8ca('0x31')][_0xf8ca('0x38')]);_0x134f7e[_0xf8ca('0x40')]=qs[_0xf8ca('0x39')](_[_0xf8ca('0x3a')](_0x10befc[_0xf8ca('0x31')],_0x32e7a6[_0xf8ca('0x39')]));_0x134f7e[_0xf8ca('0x40')][_0xf8ca('0xb5')]=_0xeb57b['id'];if(_0x10befc[_0xf8ca('0x31')][_0xf8ca('0x4e')]){_0x134f7e[_0xf8ca('0x40')]=_[_0xf8ca('0x68')](_0x134f7e[_0xf8ca('0x40')],{'$or':_[_0xf8ca('0xa1')](_0x134f7e[_0xf8ca('0x33')],function(_0x2392cb){var _0x3b1969={};_0x3b1969[_0x2392cb]={'$like':'%'+_0x10befc[_0xf8ca('0x31')][_0xf8ca('0x4e')]+'%'};return _0x3b1969;})});}_0x134f7e=_[_0xf8ca('0x68')]({},_0x134f7e,_0x10befc['options']);return db['CmHopper']['count']({'where':_0x134f7e['where']})['then'](function(_0x2106c8){_0x1b78ed[_0xf8ca('0x67')]=_0x2106c8;if(_0x10befc[_0xf8ca('0x31')]['includeAll']){_0x134f7e[_0xf8ca('0xb6')]=[{'all':!![]}];}return db['CmHopper']['findAll'](_0x134f7e);})['then'](function(_0x50a89a){_0x1b78ed[_0xf8ca('0x71')]=_0x50a89a;return _0x1b78ed;});}})[_0xf8ca('0x26')](respondWithFilteredResult(_0x2af32d,_0x134f7e))[_0xf8ca('0x72')](handleError(_0x2af32d,null));};exports[_0xf8ca('0xb7')]=function(_0x515182,_0x44fe32,_0x54f305){var _0xf00809={'raw':!![],'where':{}};var _0x5aaf4={};var _0x36e5bc={'count':0x0,'rows':[]};return db[_0xf8ca('0x2e')]['findOne']({'where':{'id':_0x515182['params']['id']}})[_0xf8ca('0x26')](handleEntityNotFound(_0x44fe32,null))['then'](function(_0xe05882){if(_0xe05882){_0x5aaf4[_0xf8ca('0x2f')]=_[_0xf8ca('0x30')](db[_0xf8ca('0x93')][_0xf8ca('0xaf')]);_0x5aaf4[_0xf8ca('0x31')]=_[_0xf8ca('0x30')](_0x515182['query']);_0x5aaf4[_0xf8ca('0x39')]=_[_0xf8ca('0x32')](_0x5aaf4[_0xf8ca('0x2f')],_0x5aaf4[_0xf8ca('0x31')]);_0xf00809['attributes']=_[_0xf8ca('0x32')](_0x5aaf4[_0xf8ca('0x2f')],qs[_0xf8ca('0x34')](_0x515182['query'][_0xf8ca('0x34')]));_0xf00809[_0xf8ca('0x33')]=_0xf00809[_0xf8ca('0x33')][_0xf8ca('0x35')]?_0xf00809[_0xf8ca('0x33')]:_0x5aaf4[_0xf8ca('0x2f')];if(!_0x515182[_0xf8ca('0x31')][_0xf8ca('0x36')]('nolimit')){_0xf00809[_0xf8ca('0x1f')]=qs[_0xf8ca('0x1f')](_0x515182['query'][_0xf8ca('0x1f')]);_0xf00809[_0xf8ca('0x1e')]=qs[_0xf8ca('0x1e')](_0x515182['query']['offset']);}_0xf00809[_0xf8ca('0x37')]=qs[_0xf8ca('0x38')](_0x515182['query'][_0xf8ca('0x38')]);_0xf00809['where']=qs['filters'](_[_0xf8ca('0x3a')](_0x515182[_0xf8ca('0x31')],_0x5aaf4[_0xf8ca('0x39')]));_0xf00809['where'][_0xf8ca('0xb5')]=_0xe05882['id'];if(_0x515182[_0xf8ca('0x31')]['filter']){_0xf00809['where']=_[_0xf8ca('0x68')](_0xf00809['where'],{'$or':_[_0xf8ca('0xa1')](_0xf00809[_0xf8ca('0x33')],function(_0x1f5513){var _0x5dfeae={};_0x5dfeae[_0x1f5513]={'$like':'%'+_0x515182[_0xf8ca('0x31')][_0xf8ca('0x4e')]+'%'};return _0x5dfeae;})});}_0xf00809=_[_0xf8ca('0x68')]({},_0xf00809,_0x515182['options']);return db[_0xf8ca('0x93')][_0xf8ca('0x67')]({'where':_0xf00809['where']})[_0xf8ca('0x26')](function(_0x2c25ee){_0x36e5bc['count']=_0x2c25ee;if(_0x515182[_0xf8ca('0x31')][_0xf8ca('0xb8')]){_0xf00809[_0xf8ca('0xb6')]=[{'all':!![]}];}return db[_0xf8ca('0x93')][_0xf8ca('0x7a')](_0xf00809);})[_0xf8ca('0x26')](function(_0x49e75c){_0x36e5bc['rows']=_0x49e75c;return _0x36e5bc;});}})[_0xf8ca('0x26')](respondWithFilteredResult(_0x44fe32,_0xf00809))[_0xf8ca('0x72')](handleError(_0x44fe32,null));};exports[_0xf8ca('0xb9')]=function(_0x39ac6c,_0x1bc18a,_0x44704e){var _0x1b5f80={'raw':!![],'where':{}};var _0x103b46={};var _0x2d13b7={'count':0x0,'rows':[]};return db['CmContact']['findOne']({'where':{'id':_0x39ac6c[_0xf8ca('0xa4')]['id']}})[_0xf8ca('0x26')](handleEntityNotFound(_0x1bc18a,null))[_0xf8ca('0x26')](function(_0x9ddf5b){if(_0x9ddf5b){_0x103b46[_0xf8ca('0x2f')]=_[_0xf8ca('0x30')](db['CmHopperFinal']['rawAttributes']);_0x103b46['query']=_[_0xf8ca('0x30')](_0x39ac6c[_0xf8ca('0x31')]);_0x103b46[_0xf8ca('0x39')]=_[_0xf8ca('0x32')](_0x103b46['model'],_0x103b46['query']);_0x1b5f80[_0xf8ca('0x33')]=_[_0xf8ca('0x32')](_0x103b46[_0xf8ca('0x2f')],qs[_0xf8ca('0x34')](_0x39ac6c[_0xf8ca('0x31')][_0xf8ca('0x34')]));_0x1b5f80[_0xf8ca('0x33')]=_0x1b5f80[_0xf8ca('0x33')][_0xf8ca('0x35')]?_0x1b5f80[_0xf8ca('0x33')]:_0x103b46[_0xf8ca('0x2f')];if(!_0x39ac6c[_0xf8ca('0x31')][_0xf8ca('0x36')](_0xf8ca('0xb1'))){_0x1b5f80['limit']=qs[_0xf8ca('0x1f')](_0x39ac6c[_0xf8ca('0x31')]['limit']);_0x1b5f80['offset']=qs[_0xf8ca('0x1e')](_0x39ac6c['query']['offset']);}_0x1b5f80[_0xf8ca('0x37')]=qs[_0xf8ca('0x38')](_0x39ac6c[_0xf8ca('0x31')]['sort']);_0x1b5f80[_0xf8ca('0x40')]=qs['filters'](_[_0xf8ca('0x3a')](_0x39ac6c['query'],_0x103b46[_0xf8ca('0x39')]));_0x1b5f80[_0xf8ca('0x40')][_0xf8ca('0xb5')]=_0x9ddf5b['id'];if(_0x39ac6c[_0xf8ca('0x31')]['filter']){_0x1b5f80[_0xf8ca('0x40')]=_[_0xf8ca('0x68')](_0x1b5f80['where'],{'$or':_[_0xf8ca('0xa1')](_0x1b5f80['attributes'],function(_0x52c465){var _0x4b5c47={};_0x4b5c47[_0x52c465]={'$like':'%'+_0x39ac6c[_0xf8ca('0x31')]['filter']+'%'};return _0x4b5c47;})});}_0x1b5f80=_[_0xf8ca('0x68')]({},_0x1b5f80,_0x39ac6c[_0xf8ca('0xb0')]);return db[_0xf8ca('0x92')]['count']({'where':_0x1b5f80[_0xf8ca('0x40')]})[_0xf8ca('0x26')](function(_0x47a89b){_0x2d13b7['count']=_0x47a89b;if(_0x39ac6c[_0xf8ca('0x31')][_0xf8ca('0xb8')]){_0x1b5f80[_0xf8ca('0xb6')]=[{'all':!![]}];}return db[_0xf8ca('0x92')][_0xf8ca('0x7a')](_0x1b5f80);})[_0xf8ca('0x26')](function(_0x524d7e){_0x2d13b7[_0xf8ca('0x71')]=_0x524d7e;return _0x2d13b7;});}})['then'](respondWithFilteredResult(_0x1bc18a,_0x1b5f80))['catch'](handleError(_0x1bc18a,null));};exports[_0xf8ca('0xba')]=function(_0x5c117c,_0x3f87c7,_0x184f62){var _0x277f85={'raw':!![],'where':{}};var _0x501e62={};var _0xc846be={'count':0x0,'rows':[]};return db[_0xf8ca('0x2e')]['findOne']({'where':{'id':_0x5c117c[_0xf8ca('0xa4')]['id']}})[_0xf8ca('0x26')](handleEntityNotFound(_0x3f87c7,null))[_0xf8ca('0x26')](function(_0x1ddd38){if(_0x1ddd38){_0x501e62['model']=_[_0xf8ca('0x30')](db[_0xf8ca('0xbb')][_0xf8ca('0xaf')]);_0x501e62[_0xf8ca('0x31')]=_['keys'](_0x5c117c['query']);_0x501e62['filters']=_[_0xf8ca('0x32')](_0x501e62[_0xf8ca('0x2f')],_0x501e62[_0xf8ca('0x31')]);_0x277f85['attributes']=_[_0xf8ca('0x32')](_0x501e62[_0xf8ca('0x2f')],qs[_0xf8ca('0x34')](_0x5c117c[_0xf8ca('0x31')][_0xf8ca('0x34')]));_0x277f85['attributes']=_0x277f85[_0xf8ca('0x33')][_0xf8ca('0x35')]?_0x277f85[_0xf8ca('0x33')]:_0x501e62['model'];if(!_0x5c117c[_0xf8ca('0x31')]['hasOwnProperty']('nolimit')){_0x277f85[_0xf8ca('0x1f')]=qs['limit'](_0x5c117c[_0xf8ca('0x31')][_0xf8ca('0x1f')]);_0x277f85[_0xf8ca('0x1e')]=qs[_0xf8ca('0x1e')](_0x5c117c[_0xf8ca('0x31')]['offset']);}_0x277f85['order']=qs[_0xf8ca('0x38')](_0x5c117c[_0xf8ca('0x31')][_0xf8ca('0x38')]);_0x277f85['where']=qs[_0xf8ca('0x39')](_[_0xf8ca('0x3a')](_0x5c117c[_0xf8ca('0x31')],_0x501e62[_0xf8ca('0x39')]));_0x277f85[_0xf8ca('0x40')][_0xf8ca('0xb5')]=_0x1ddd38['id'];if(_0x5c117c[_0xf8ca('0x31')]['filter']){_0x277f85['where']=_[_0xf8ca('0x68')](_0x277f85[_0xf8ca('0x40')],{'$or':_[_0xf8ca('0xa1')](_0x277f85[_0xf8ca('0x33')],function(_0x23c10b){var _0x547d6d={};_0x547d6d[_0x23c10b]={'$like':'%'+_0x5c117c[_0xf8ca('0x31')]['filter']+'%'};return _0x547d6d;})});}_0x277f85=_[_0xf8ca('0x68')]({},_0x277f85,_0x5c117c[_0xf8ca('0xb0')]);return db[_0xf8ca('0xbb')][_0xf8ca('0x67')]({'where':_0x277f85[_0xf8ca('0x40')]})[_0xf8ca('0x26')](function(_0xabe498){_0xc846be[_0xf8ca('0x67')]=_0xabe498;if(_0x5c117c[_0xf8ca('0x31')][_0xf8ca('0xb8')]){_0x277f85[_0xf8ca('0xb6')]=[{'all':!![]}];}return db[_0xf8ca('0xbb')][_0xf8ca('0x7a')](_0x277f85);})['then'](function(_0x557d92){_0xc846be['rows']=_0x557d92;return _0xc846be;});}})[_0xf8ca('0x26')](respondWithFilteredResult(_0x3f87c7,_0x277f85))[_0xf8ca('0x72')](handleError(_0x3f87c7,null));};exports['uploadCsv']=function(_0x467945,_0x1535fd,_0x25aba2){try{if(!_0x467945['body'][_0xf8ca('0x50')]){throw new Error('No\x20ListId\x20specified');}if(!_0x467945[_0xf8ca('0x7d')][_0xf8ca('0xbc')]){throw new Error(_0xf8ca('0xbd'));}if(!_0x467945[_0xf8ca('0x7d')]['binding_values']){throw new Error(_0xf8ca('0xbe'));}if(!_0x467945[_0xf8ca('0x7d')][_0xf8ca('0xbf')]){throw new Error(_0xf8ca('0xc0'));}var _0x30dba0=_0x467945[_0xf8ca('0x7d')][_0xf8ca('0xbc')][_0xf8ca('0x70')](',');var _0x14d143=_0x467945['body']['binding_values'][_0xf8ca('0x70')](',');if(!_0x30dba0[_0xf8ca('0x35')]||!_0x14d143[_0xf8ca('0x35')]||_0x30dba0['length']!==_0x14d143[_0xf8ca('0x35')]){throw new Error(_0xf8ca('0xc1'));}_0x467945[_0xf8ca('0x7d')]['fields']=_[_0xf8ca('0xc2')](_0x30dba0,_0x14d143);if(!_0x467945[_0xf8ca('0x7d')][_0xf8ca('0x34')][_0xf8ca('0xab')]){throw new Error(_0xf8ca('0xc3'));}if(!_0x467945[_0xf8ca('0x7d')][_0xf8ca('0x34')][_0xf8ca('0xc4')]){throw new Error(_0xf8ca('0xc5'));}var _0x5e0867=path['join'](config[_0xf8ca('0xc6')],_0xf8ca('0xc7'),_0x467945[_0xf8ca('0xc8')][_0xf8ca('0xc9')]);fs[_0xf8ca('0xca')](_0x5e0867,parseInt(_0xf8ca('0xcb'),0x8));var _0x25b5f6=require(_0xf8ca('0xcc'))['fork'](path['join'](__dirname,_0xf8ca('0xcd')),[_0x5e0867,_0x467945['body'][_0xf8ca('0xbc')],_0x467945[_0xf8ca('0x7d')][_0xf8ca('0xce')],_0x467945[_0xf8ca('0x7d')][_0xf8ca('0x50')],_0x467945['body']['CompanyId'],_0x467945['body'][_0xf8ca('0x9b')],_0x467945[_0xf8ca('0x7d')][_0xf8ca('0xbf')]]);return _0x1535fd['status'](0xc8)['json']({'message':_0xf8ca('0xcf'),'pid':_0x25b5f6['pid']});}catch(_0x3e3a7a){return _0x1535fd['status'](0x1f4)['send'](_0x3e3a7a);}};exports[_0xf8ca('0xd0')]=function(_0xdb3eb1,_0x595b28,_0x21606a){var _0x5b407a=fs[_0xf8ca('0xd1')](_0xdb3eb1[_0xf8ca('0xc8')][_0xf8ca('0xd2')]);Papa[_0xf8ca('0xd3')](_0x5b407a,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x2d8593){return _0x595b28[_0xf8ca('0x1b')](0xc8)[_0xf8ca('0x1d')]({'file':_0xdb3eb1[_0xf8ca('0xc8')],'fields':_0x2d8593[_0xf8ca('0xd4')]['fields']});}});};exports[_0xf8ca('0xd5')]=function(_0x132026,_0x2f0a4a,_0x3477b3){return db['User'][_0xf8ca('0x7a')]({'raw':!![],'attributes':['id'],'where':{'role':_0xf8ca('0xd6')}})[_0xf8ca('0x26')](function(_0x41822a){var _0x4402a8=![];if(!_0x132026[_0xf8ca('0x7d')][_0xf8ca('0x50')]){throw new Error('No\x20ListId\x20specified');}if(!_0x132026[_0xf8ca('0x7d')]['binding'][_0xf8ca('0xab')]){throw new Error(_0xf8ca('0xc3'));}if(!_0x132026[_0xf8ca('0x7d')][_0xf8ca('0xd7')][_0xf8ca('0xc4')]){throw new Error(_0xf8ca('0xc5'));}if(!_0x132026[_0xf8ca('0x7d')][_0xf8ca('0xbf')]){throw new Error(_0xf8ca('0xc0'));}var _0x380db0=require(_0xf8ca('0xcc'))['fork'](path[_0xf8ca('0x81')](__dirname,_0xf8ca('0xd8')),[_0x132026['params']['id'],JSON[_0xf8ca('0xd9')](_0x132026[_0xf8ca('0x7d')]),JSON[_0xf8ca('0xd9')](_0x41822a)]);_0x380db0['on'](_0xf8ca('0xda'),function(_0x3c8ed0){_0x4402a8=!![];return _0x2f0a4a[_0xf8ca('0x1b')](0xc8)[_0xf8ca('0x1d')]({'message':_0xf8ca('0xdb'),'pid':_0x380db0[_0xf8ca('0xdc')]});});_0x380db0['on'](_0xf8ca('0xdd'),function(_0x551441){if(_0x551441&&!_0x4402a8){return _0x2f0a4a[_0xf8ca('0x1b')](0x1f4)[_0xf8ca('0x1d')]({'message':_0xf8ca('0xde'),'pid':_0x380db0[_0xf8ca('0xdc')]});}});})[_0xf8ca('0x72')](handleError(_0x2f0a4a,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff