18 var _0x2619=['model','query','filters','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','where','select','field','from','tools_tags','cm_user_has_contacts','left_join','cm_contact_has_tags','t.id\x20=\x20ct.TagId','c.deletedAt\x20IS\x20NULL','expr','search','parseSearch','conditions','find','Tag','value','split','map','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','and','dateOfBirth','datetime','castTo','DATE','buildExpression','text','start','filter','isNil','Contact','isEmpty','ListId','c.ListId\x20IN\x20?','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','isArray','tag','replace','\x27\x27\x27\x27','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','c.id\x20LIKE\x20?','c.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','c.email\x20LIKE\x20?','group','QueryTypes','SELECT','having','t.id\x20IN\x20?','resolve','some','c.ListId\x20IS\x20NULL','sequelize','toString','keyBy','merge','c.id','c.firstName','c.phone','c.mobile','c.fax','c.ListId','c.deletedAt','TagIds','catch','CmContact','params','tags','columnName','displayName','CmCustomField','findAll','custom','values','body','get','mergeWith','join','info','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','create','ChatInteraction','update','ChatOfflineMessage','MailMessage','MailInteraction','SmsInteraction','FaxInteraction','FaxMessage','OpenchannelMessage','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','bulkCreate','duplicates','findOrCreate','spread','color','omit','format','cf_%d','$and','pickBy','table','cm_contacts','setFields','id\x20=\x20?','toParam','phone','rawAttributes','pick','options','getTags','setTags','getHoppers','include','getHopperHistories','CmHopperHistory','ContactId','rows','getHopperFinals','CmHopperFinal','includeAll','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','binding_values','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','firstName','root','server/files/tmp','file','filename','chmodSync','0777','child_process','../../components/import/cm/csv','CompanyId','File\x20uploaded\x20correctly!','pid','upload','createReadStream','meta','import','agent','binding','fork','../../components/import/cm/csv2','stringify','message','exit','error\x20child\x20process','html-pdf','eml-format','rimraf','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','socket.io-emitter','./cmContact.socket','register','sendStatus','status','end','json','count','offset','limit','set','Content-Range','apply','reject','save','then','destroy','error','stack','name','send','index','describe','keys','length','startsWith','cf_','push','findOne','trimStart','all','fieldType','type'];(function(_0x25e24d,_0x2850dd){var _0x1e50f9=function(_0x1f721d){while(--_0x1f721d){_0x25e24d['push'](_0x25e24d['shift']());}};_0x1e50f9(++_0x2850dd);}(_0x2619,0xb5));var _0x9261=function(_0x351577,_0x124ab2){_0x351577=_0x351577-0x0;var _0xbf59c5=_0x2619[_0x351577];return _0xbf59c5;};'use strict';var pdf=require(_0x9261('0x0'));var emlformat=require(_0x9261('0x1'));var rimraf=require(_0x9261('0x2'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0x9261('0x3'));var BPromise=require(_0x9261('0x4'));var Mustache=require(_0x9261('0x5'));var util=require(_0x9261('0x6'));var path=require(_0x9261('0x7'));var sox=require(_0x9261('0x8'));var csv=require(_0x9261('0x9'));var ejs=require(_0x9261('0xa'));var fs=require('fs');var _=require(_0x9261('0xb'));var squel=require(_0x9261('0xc'));var crypto=require(_0x9261('0xd'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x9261('0x9'));var querystring=require(_0x9261('0xe'));var Papa=require(_0x9261('0xf'));var Redis=require(_0x9261('0x10'));var authService=require(_0x9261('0x11'));var qs=require(_0x9261('0x12'));var as=require(_0x9261('0x13'));var hardwareService=require(_0x9261('0x14'));var logger=require(_0x9261('0x15'))(_0x9261('0x16'));var utils=require(_0x9261('0x17'));var config=require(_0x9261('0x18'));var db=require(_0x9261('0x19'))['db'];config[_0x9261('0x1a')]=_[_0x9261('0x1b')](config[_0x9261('0x1a')],{'host':'localhost','port':0x18eb});var socket=require(_0x9261('0x1c'))(new Redis(config['redis']));require(_0x9261('0x1d'))[_0x9261('0x1e')](socket);function respondWithStatusCode(_0x296cd6,_0x403235){_0x403235=_0x403235||0xcc;return function(_0x59f95a){if(_0x59f95a){return _0x296cd6[_0x9261('0x1f')](_0x403235);}return _0x296cd6[_0x9261('0x20')](_0x403235)[_0x9261('0x21')]();};}function respondWithResult(_0x436e31,_0xad957f){_0xad957f=_0xad957f||0xc8;return function(_0x35efdb){if(_0x35efdb){return _0x436e31[_0x9261('0x20')](_0xad957f)[_0x9261('0x22')](_0x35efdb);}};}function respondWithFilteredResult(_0x2fe109,_0x1711ba){return function(_0x45f857){if(_0x45f857){var _0x171fb6=_0x45f857[_0x9261('0x23')],_0xc944f2=_0x1711ba[_0x9261('0x24')],_0xe4d51=_0x1711ba[_0x9261('0x24')]+_0x1711ba[_0x9261('0x25')],_0x9867df;if(_0xe4d51>=_0x171fb6){_0xe4d51=_0x171fb6;_0x9867df=0xc8;}else{_0x9867df=0xce;}_0x2fe109[_0x9261('0x20')](_0x9867df);return _0x2fe109[_0x9261('0x26')](_0x9261('0x27'),_0xc944f2+'-'+_0xe4d51+'/'+_0x171fb6)['json'](_0x45f857);}return null;};}function patchUpdates(_0x544ecd){return function(_0x2922d6){try{jsonpatch[_0x9261('0x28')](_0x2922d6,_0x544ecd,!![]);}catch(_0x35cbed){return BPromise[_0x9261('0x29')](_0x35cbed);}return _0x2922d6[_0x9261('0x2a')]();};}function saveUpdates(_0x4a385e,_0x1a4d7f){return function(_0x2155d8){if(_0x2155d8){return _0x2155d8['update'](_0x4a385e)[_0x9261('0x2b')](function(_0xedc50c){return _0xedc50c;});}return null;};}function removeEntity(_0x5710c7,_0x30c400){return function(_0x5e4148){if(_0x5e4148){return _0x5e4148[_0x9261('0x2c')]()[_0x9261('0x2b')](function(){_0x5710c7['status'](0xcc)[_0x9261('0x21')]();});}};}function handleEntityNotFound(_0x3ab69a,_0xc989ec){return function(_0x62ade0){if(!_0x62ade0){_0x3ab69a['sendStatus'](0x194);}return _0x62ade0;};}function handleError(_0x5f1079,_0x36d59c){_0x36d59c=_0x36d59c||0x1f4;return function(_0x5542fd){logger[_0x9261('0x2d')](_0x5542fd[_0x9261('0x2e')]);if(_0x5542fd[_0x9261('0x2f')]){delete _0x5542fd[_0x9261('0x2f')];}_0x5f1079[_0x9261('0x20')](_0x36d59c)[_0x9261('0x30')](_0x5542fd);};}exports[_0x9261('0x31')]=function(_0x4f0fb4,_0x4331c8){var _0x302d20={},_0x3743dd={},_0x3560c2={'count':0x0,'rows':[]};return db['CmContact'][_0x9261('0x32')]()[_0x9261('0x2b')](function(_0x1bf1be){var _0x3dda0d=[];for(var _0x5c7dac=0x0;_0x5c7dac<Object[_0x9261('0x33')](_0x1bf1be)[_0x9261('0x34')];_0x5c7dac++){var _0x3fd372=Object[_0x9261('0x33')](_0x1bf1be)[_0x5c7dac];if(_[_0x9261('0x35')](_0x3fd372,_0x9261('0x36'))){_0x3dda0d[_0x9261('0x37')](db['CmCustomField'][_0x9261('0x38')]({'where':{'id':_[_0x9261('0x39')](_0x3fd372,_0x9261('0x36'))},'raw':!![]}));}}return BPromise[_0x9261('0x3a')](_0x3dda0d)[_0x9261('0x2b')](function(_0x703267){for(var _0xdae449=0x0;_0xdae449<_0x703267[_0x9261('0x34')];_0xdae449++){if(_0x703267[_0xdae449]){var _0x16809f=_0x9261('0x36')+_0x703267[_0xdae449]['id'];var _0x3bd4a0=_0x1bf1be[_0x16809f];_0x3bd4a0[_0x9261('0x3b')]=_0x703267[_0xdae449][_0x9261('0x3c')];}}return _0x1bf1be;});})[_0x9261('0x2b')](function(_0x1f4bef){_0x3743dd[_0x9261('0x3d')]=_['keys'](_0x1f4bef);_0x3743dd[_0x9261('0x3e')]=_[_0x9261('0x33')](_0x4f0fb4[_0x9261('0x3e')]);_0x3743dd[_0x9261('0x3f')]=_[_0x9261('0x40')](_0x3743dd[_0x9261('0x3d')],_0x3743dd[_0x9261('0x3e')]);_0x302d20[_0x9261('0x41')]=_[_0x9261('0x40')](_0x3743dd[_0x9261('0x3d')],qs[_0x9261('0x42')](_0x4f0fb4[_0x9261('0x3e')]['fields']));_0x302d20[_0x9261('0x41')]=_0x302d20['attributes']['length']?_0x302d20[_0x9261('0x41')]:_0x3743dd[_0x9261('0x3d')];if(!_0x4f0fb4[_0x9261('0x3e')][_0x9261('0x43')](_0x9261('0x44'))){_0x302d20['limit']=qs[_0x9261('0x25')](_0x4f0fb4[_0x9261('0x3e')][_0x9261('0x25')]);_0x302d20[_0x9261('0x24')]=qs['offset'](_0x4f0fb4[_0x9261('0x3e')]['offset']);}_0x302d20[_0x9261('0x45')]=qs[_0x9261('0x46')](_0x4f0fb4[_0x9261('0x3e')][_0x9261('0x46')]);_0x302d20[_0x9261('0x47')]=qs[_0x9261('0x3f')](_['pick'](_0x4f0fb4[_0x9261('0x3e')],_0x3743dd['filters']),_0x1f4bef);var _0x368b50=[];var _0x3cc8be=squel[_0x9261('0x48')]()[_0x9261('0x49')]('id')['field'](_0x9261('0x2f'))[_0x9261('0x49')]('color')[_0x9261('0x4a')](_0x9261('0x4b'));var _0x4e1bc4=squel[_0x9261('0x48')]()[_0x9261('0x4a')]('cm_contacts','c')['left_join'](_0x9261('0x4c'),'uc','uc.CmContactId\x20=\x20c.id')[_0x9261('0x4d')](_0x9261('0x4e'),'ct','ct.CmContactId\x20=\x20c.id')[_0x9261('0x4d')]('tools_tags','t',_0x9261('0x4f'))[_0x9261('0x47')](_0x9261('0x50'));var _0x256f5a=squel[_0x9261('0x51')]();var _0x106c52=[];var _0x565698=squel[_0x9261('0x51')]();var _0x298255;if(_0x4f0fb4[_0x9261('0x3e')][_0x9261('0x52')]){_0x298255=as[_0x9261('0x53')](_0x4f0fb4[_0x9261('0x3e')]['search']);var _0x11eb0d=_0x298255['sqlOperator'];for(var _0x3fecf5=0x0;_0x3fecf5<_0x298255[_0x9261('0x54')]['length'];_0x3fecf5++){var _0xe81839=_0x298255['conditions'][_0x3fecf5];var _0x5af870='c';var _0x43db9d=_(_0x1f4bef)[_0x9261('0x33')]()[_0x9261('0x55')](function(_0x5f344e){return _0x5f344e===_0xe81839[_0x9261('0x49')];});if(_0x43db9d)_0x43db9d=_0x1f4bef[_0xe81839[_0x9261('0x49')]];if(!_0x43db9d){if(_0xe81839[_0x9261('0x49')]===_0x9261('0x56')){var _0x2abb9c=_0xe81839[_0x9261('0x57')][_0x9261('0x58')](',')[_0x9261('0x59')](function(_0x3b9c56){return Number(_0x3b9c56);});_0x2abb9c[_0x9261('0x5a')](function(_0x368d92){_0x565698['or'](_0x9261('0x5b'),'%,'+_0x368d92+',%');});_0x106c52=_['union'](_0x106c52,_0x2abb9c);}else if(_0xe81839[_0x9261('0x49')]==='User'){_0x256f5a[_0x9261('0x5c')]('uc.UserId\x20=\x20?',_0xe81839['value']);}}else{if(_0xe81839[_0x9261('0x49')]===_0x9261('0x5d')||_0x43db9d[_0x9261('0x3b')]===_0x9261('0x5e'))_0xe81839[_0x9261('0x5f')]=_0x9261('0x60');var _0x5c5a71=as[_0x9261('0x61')](_0x5af870,_0x43db9d['type'],_0xe81839);_0x256f5a[_0x11eb0d](_0x5c5a71[_0x9261('0x62')],_0x5c5a71[_0x9261('0x57')][_0x9261('0x63')],_0x5c5a71[_0x9261('0x57')][_0x9261('0x21')]);}}}else{var _0x4c78b1=_(Object[_0x9261('0x33')](_0x4f0fb4[_0x9261('0x3e')]))[_0x9261('0x59')](function(_0x202aa5){return _0x1f4bef[_0x9261('0x43')](_0x202aa5)?_0x202aa5:undefined;})[_0x9261('0x64')](function(_0xb4b4e0){return!_[_0x9261('0x65')](_0xb4b4e0);})['value']();if(_0x4f0fb4['query'][_0x9261('0x66')])_0x4c78b1['push']('Contact');if(!_[_0x9261('0x67')](_0x4c78b1)){_0x4c78b1[_0x9261('0x5a')](function(_0x22ba49){if(_0x22ba49===_0x9261('0x68')){_0x4e1bc4[_0x9261('0x47')](_0x9261('0x69'),[]['concat'](_0x4f0fb4['query'][_0x22ba49]));}else if(_0x22ba49===_0x9261('0x66')){var _0x3425fc='%'+_0x4f0fb4[_0x9261('0x3e')][_0x22ba49]+'%';_0x4e1bc4[_0x9261('0x47')](_0x9261('0x6a'),_0x3425fc);}else{_0x4e1bc4['where']('c.'+_0x22ba49+_0x9261('0x6b'),_0x4f0fb4[_0x9261('0x3e')][_0x22ba49]);}});}if(_0x4f0fb4[_0x9261('0x3e')]['tag']){_0x106c52=_[_0x9261('0x6c')](_0x4f0fb4['query']['tag'])?_0x4f0fb4[_0x9261('0x3e')][_0x9261('0x6d')]:new Array(_0x4f0fb4['query'][_0x9261('0x6d')]);_0x106c52[_0x9261('0x5a')](function(_0x13115d){_0x565698['or'](_0x9261('0x5b'),'%,'+_0x13115d+',%');});}if(_0x4f0fb4[_0x9261('0x3e')][_0x9261('0x64')]){var _0x201ce2=_0x4f0fb4[_0x9261('0x3e')][_0x9261('0x64')]['replace']('\x5c','\x5c\x5c')[_0x9261('0x6e')]('\x27\x27',_0x9261('0x6f'));if(_0x201ce2[_0x9261('0x58')]('\x20')['length']>0x1){_0x256f5a['or'](_0x9261('0x70'),qs[_0x9261('0x71')](_0x201ce2),null);}else{if(qs['isNumeric'](_0x201ce2)){_0x256f5a['or'](_0x9261('0x72'),_0x201ce2+'%');_0x256f5a['or']('c.phone\x20LIKE\x20?',_0x201ce2+'%');_0x256f5a['or'](_0x9261('0x73'),_0x201ce2+'%');_0x256f5a['or'](_0x9261('0x74'),_0x201ce2+'%');}else if(qs[_0x9261('0x75')](_0x201ce2)){_0x256f5a['or']('c.email\x20LIKE\x20?',_0x201ce2+'%');}else{_0x256f5a['or'](_0x9261('0x76'),'%'+_0x201ce2+'%');_0x256f5a['or'](_0x9261('0x77'),'%'+_0x201ce2+'%');_0x256f5a['or'](_0x9261('0x78'),'%'+_0x201ce2+'%');}}}}_0x4e1bc4[_0x9261('0x47')](_0x256f5a);_0x4e1bc4[_0x9261('0x79')]('c.id');var _0x54e7f7={'type':db['Sequelize'][_0x9261('0x7a')][_0x9261('0x7b')],'raw':!![]};var _0x3a6bfb=_0x4e1bc4['clone']()[_0x9261('0x49')]('c.id');if(_0x302d20[_0x9261('0x45')]){_0x302d20[_0x9261('0x45')][_0x9261('0x5a')](function(_0x5a7c91){_0x4e1bc4[_0x9261('0x45')]('c.'+_0x5a7c91[0x0],_0x5a7c91[0x1]==='DESC'?![]:!![]);});}if(!_[_0x9261('0x67')](_0x106c52)){_0x4e1bc4[_0x9261('0x7c')](_0x565698);_0x3a6bfb[_0x9261('0x47')](_0x9261('0x7d'),_0x106c52);}BPromise[_0x9261('0x7e')]()[_0x9261('0x2b')](function(){if(_0x298255&&!_[_0x9261('0x7f')](_0x298255[_0x9261('0x54')],[_0x9261('0x49'),'User'])){return _0x4f0fb4['user']['getLists']({'attributes':['id'],'raw':!![]})[_0x9261('0x2b')](function(_0x21ea68){if(_['isEmpty'](_0x21ea68)){_0x3a6bfb[_0x9261('0x47')](_0x9261('0x80'));_0x4e1bc4[_0x9261('0x47')](_0x9261('0x80'));}else{_0x3a6bfb[_0x9261('0x47')]('c.ListId\x20IN\x20?',_[_0x9261('0x59')](_0x21ea68,'id'));_0x4e1bc4['where'](_0x9261('0x69'),_[_0x9261('0x59')](_0x21ea68,'id'));}});}else{return;}})[_0x9261('0x2b')](function(){db[_0x9261('0x81')][_0x9261('0x3e')](_0x3a6bfb[_0x9261('0x82')](),_0x54e7f7)['then'](function(_0x457d73){_0x3560c2[_0x9261('0x23')]=_0x457d73[_0x9261('0x34')];if(_0x3560c2[_0x9261('0x23')]===0x0)return[];return db[_0x9261('0x81')][_0x9261('0x3e')](_0x3cc8be[_0x9261('0x82')](),_0x54e7f7);})['then'](function(_0x2f3912){_0x368b50=_[_0x9261('0x83')](_0x2f3912,'id');_0x54e7f7=_[_0x9261('0x84')](_0x54e7f7,{'model':db['CmContact'],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x4f0fb4[_0x9261('0x3e')][_0x9261('0x42')]){_0x302d20[_0x9261('0x41')]['forEach'](function(_0x4530f3){_0x4e1bc4[_0x9261('0x49')]('c.'+_0x4530f3);});}else{_0x4e1bc4['field'](_0x9261('0x85'));_0x4e1bc4[_0x9261('0x49')](_0x9261('0x86'));_0x4e1bc4[_0x9261('0x49')]('c.lastName');_0x4e1bc4[_0x9261('0x49')](_0x9261('0x87'));_0x4e1bc4[_0x9261('0x49')](_0x9261('0x88'));_0x4e1bc4[_0x9261('0x49')](_0x9261('0x89'));_0x4e1bc4[_0x9261('0x49')]('c.email');_0x4e1bc4['field'](_0x9261('0x8a'));_0x4e1bc4[_0x9261('0x49')](_0x9261('0x8b'));_0x4e1bc4[_0x9261('0x49')]('GROUP_CONCAT(DISTINCT\x20t.id)','TagIds');}if(_0x302d20[_0x9261('0x25')])_0x4e1bc4[_0x9261('0x25')](_0x302d20['limit']);if(_0x302d20['offset'])_0x4e1bc4[_0x9261('0x24')](_0x302d20[_0x9261('0x24')]);return db[_0x9261('0x81')][_0x9261('0x3e')](_0x4e1bc4[_0x9261('0x82')](),_0x54e7f7);})[_0x9261('0x2b')](function(_0x3097c1){_0x3097c1[_0x9261('0x5a')](function(_0x5aa514){if(_0x5aa514[_0x9261('0x8c')]){_0x5aa514['Tags']=[];_0x5aa514['TagIds'][_0x9261('0x58')](',')[_0x9261('0x5a')](function(_0xfd0852){_0x5aa514['Tags'][_0x9261('0x37')](_0x368b50[_0xfd0852]);});}delete _0x5aa514['TagIds'];});_0x3560c2['rows']=_0x3097c1;return _0x3560c2;})['then'](respondWithFilteredResult(_0x4331c8,_0x302d20));});})[_0x9261('0x8d')](handleError(_0x4331c8,null));};exports[_0x9261('0x2c')]=function(_0x32861e,_0x5f0ccc){return db[_0x9261('0x8e')]['find']({'where':{'id':_0x32861e[_0x9261('0x8f')]['id']}})['then'](handleEntityNotFound(_0x5f0ccc,null))[_0x9261('0x2b')](removeEntity(_0x5f0ccc,null))['catch'](handleError(_0x5f0ccc,null));};exports[_0x9261('0x32')]=function(_0x8afb5f,_0x287eb1){return db[_0x9261('0x8e')]['describe']()[_0x9261('0x2b')](function(_0xdadfdb){delete _0xdadfdb[_0x9261('0x90')];for(var _0x3b167c=0x0;_0x3b167c<Object[_0x9261('0x33')](_0xdadfdb)[_0x9261('0x34')];_0x3b167c++){var _0x2ccbc0=Object['keys'](_0xdadfdb)[_0x3b167c];if(!_['startsWith'](_0x2ccbc0,_0x9261('0x36'))){_0xdadfdb[_0x2ccbc0][_0x9261('0x91')]=_0x2ccbc0;_0xdadfdb[_0x2ccbc0][_0x9261('0x92')]=_0x2ccbc0;}}return _0xdadfdb;})[_0x9261('0x2b')](function(_0x5b9d4e){var _0x9a73e1={'where':{'$or':[{'ListId':_0x8afb5f['query']['id']},{'ListId':null}]},'raw':!![]};return db[_0x9261('0x93')][_0x9261('0x94')](_0x9a73e1)['then'](function(_0x2074f6){for(var _0x1430c0=0x0;_0x1430c0<_0x2074f6[_0x9261('0x34')];_0x1430c0++){var _0x12d70f='cf_'+_0x2074f6[_0x1430c0]['id'];_0x5b9d4e[_0x12d70f][_0x9261('0x91')]=_0x12d70f;_0x5b9d4e[_0x12d70f][_0x9261('0x92')]=_0x2074f6[_0x1430c0]['alias'];_0x5b9d4e[_0x12d70f][_0x9261('0x95')]={'type':_0x2074f6[_0x1430c0][_0x9261('0x3c')],'values':_0x2074f6[_0x1430c0][_0x9261('0x96')]};}Object[_0x9261('0x33')](_0x5b9d4e)['forEach'](function(_0x2e4ffa){if(!_0x5b9d4e[_0x2e4ffa]['hasOwnProperty']('columnName')){delete _0x5b9d4e[_0x2e4ffa];}});return _0x5b9d4e;});})['then'](respondWithResult(_0x287eb1,null))[_0x9261('0x8d')](handleError(_0x287eb1,null));};exports['merge']=function(_0x588d16,_0x441709){var _0x52d66e;var _0x58743b;var _0x2a9dad;if(_0x588d16[_0x9261('0x97')]['id']){delete _0x588d16[_0x9261('0x97')]['id'];}return db[_0x9261('0x8e')][_0x9261('0x94')]({'where':{'id':[_0x588d16[_0x9261('0x97')]['to'],_0x588d16[_0x9261('0x97')][_0x9261('0x4a')]]}})[_0x9261('0x2b')](function(_0xc44ea1){if(_0xc44ea1){if(_0xc44ea1[_0x9261('0x34')]!==0x2){return null;}_0xc44ea1[0x0]=_0xc44ea1[0x0][_0x9261('0x98')]({'plain':!![]});_0xc44ea1[0x1]=_0xc44ea1[0x1][_0x9261('0x98')]({'plain':!![]});delete _0xc44ea1[0x0]['id'];delete _0xc44ea1[0x1]['id'];return _[_0x9261('0x99')](_0xc44ea1[0x0],_0xc44ea1[0x1],function(_0x4126f2,_0x141e23){if(Array[_0x9261('0x6c')](_0x141e23)&&!_0x141e23[_0x9261('0x34')]){return _0x4126f2;}else if(!_0x141e23){return _0x4126f2;}});}})['then'](handleEntityNotFound(_0x441709,null))['then'](function(_0x13b4c4){if(_0x13b4c4){if(_0x13b4c4[_0x9261('0x90')]&&_['isArray'](_0x13b4c4[_0x9261('0x90')])){_0x13b4c4['tags']=_0x13b4c4[_0x9261('0x90')][_0x9261('0x9a')]();}logger[_0x9261('0x9b')]('[CmContact][merge]\x20to\x20%s\x20from\x20%s',_0x588d16[_0x9261('0x97')]['to'],_0x588d16['body'][_0x9261('0x4a')]);return db[_0x9261('0x9c')]['destroy']({'where':{'ContactId':[_0x588d16[_0x9261('0x97')]['to'],_0x588d16[_0x9261('0x97')][_0x9261('0x4a')]]}})['then'](function(_0xc48e7f){logger['info'](_0x9261('0x9d'),_0xc48e7f);return db[_0x9261('0x9e')]['destroy']({'where':{'ContactId':[_0x588d16['body']['to'],_0x588d16[_0x9261('0x97')][_0x9261('0x4a')]]}})[_0x9261('0x2b')](function(_0x26cc5c){logger['info']('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x26cc5c);return db[_0x9261('0x8e')][_0x9261('0x9f')](_0x13b4c4);});});}})[_0x9261('0x2b')](function(_0x5039c5){if(_0x5039c5){_0x52d66e=_0x5039c5;_0x58743b={'ContactId':_0x52d66e['id']};_0x2a9dad={'where':{'ContactId':[_0x588d16[_0x9261('0x97')]['to'],_0x588d16[_0x9261('0x97')][_0x9261('0x4a')]]}};return db[_0x9261('0xa0')][_0x9261('0xa1')](_0x58743b,_0x2a9dad);}})['then'](function(){if(_0x52d66e){return db['ChatMessage'][_0x9261('0xa1')](_0x58743b,_0x2a9dad);}})['then'](function(){if(_0x52d66e){return db[_0x9261('0xa2')][_0x9261('0xa1')](_0x58743b,_0x2a9dad);}})[_0x9261('0x2b')](function(){if(_0x52d66e){return db['MailInteraction']['update'](_0x58743b,_0x2a9dad);}})[_0x9261('0x2b')](function(){if(_0x52d66e){return db[_0x9261('0xa3')][_0x9261('0xa1')](_0x58743b,_0x2a9dad);}})['then'](function(){if(_0x52d66e){return db[_0x9261('0xa4')][_0x9261('0xa1')](_0x58743b,_0x2a9dad);}})[_0x9261('0x2b')](function(){if(_0x52d66e){return db[_0x9261('0xa3')]['update'](_0x58743b,_0x2a9dad);}})[_0x9261('0x2b')](function(){if(_0x52d66e){return db[_0x9261('0xa5')][_0x9261('0xa1')](_0x58743b,_0x2a9dad);}})[_0x9261('0x2b')](function(){if(_0x52d66e){return db['SmsMessage'][_0x9261('0xa1')](_0x58743b,_0x2a9dad);}})[_0x9261('0x2b')](function(){if(_0x52d66e){return db[_0x9261('0xa6')]['update'](_0x58743b,_0x2a9dad);}})[_0x9261('0x2b')](function(){if(_0x52d66e){return db[_0x9261('0xa7')][_0x9261('0xa1')](_0x58743b,_0x2a9dad);}})[_0x9261('0x2b')](function(){if(_0x52d66e){return db['OpenchannelInteraction'][_0x9261('0xa1')](_0x58743b,_0x2a9dad);}})[_0x9261('0x2b')](function(){if(_0x52d66e){return db[_0x9261('0xa8')][_0x9261('0xa1')](_0x58743b,_0x2a9dad);}})[_0x9261('0x2b')](function(){if(_0x52d66e){return db['CmHopperFinal'][_0x9261('0xa1')](_0x58743b,_0x2a9dad);}})[_0x9261('0x2b')](function(){if(_0x52d66e){return db['CmHopperHistory'][_0x9261('0xa1')](_0x58743b,_0x2a9dad);}})[_0x9261('0x2b')](function(){if(_0x52d66e){return db['ReportAgentPreview'][_0x9261('0xa1')](_0x58743b,_0x2a9dad);}})['then'](function(){if(_0x52d66e){return db[_0x9261('0xa9')][_0x9261('0xa1')](_0x58743b,_0x2a9dad);}})[_0x9261('0x2b')](function(){if(_0x52d66e){return db[_0x9261('0xaa')][_0x9261('0xa1')](_0x58743b,_0x2a9dad);}})[_0x9261('0x2b')](function(){if(_0x52d66e){return db[_0x9261('0xab')][_0x9261('0xa1')](_0x58743b,_0x2a9dad);}})[_0x9261('0x2b')](function(){if(_0x52d66e){return db[_0x9261('0xac')]['update'](_0x58743b,_0x2a9dad);}})[_0x9261('0x2b')](function(){if(_0x52d66e){return db[_0x9261('0xad')][_0x9261('0xa1')](_0x58743b,_0x2a9dad);}})[_0x9261('0x2b')](function(){if(_0x52d66e){return db[_0x9261('0xae')][_0x9261('0xa1')](_0x58743b,_0x2a9dad);}})['then'](function(){if(_0x52d66e){return db[_0x9261('0xaf')][_0x9261('0xa1')](_0x58743b,_0x2a9dad);}})[_0x9261('0x2b')](function(){if(_0x52d66e){return db[_0x9261('0x8e')][_0x9261('0x2c')]({'where':{'id':[_0x588d16[_0x9261('0x97')]['to'],_0x588d16[_0x9261('0x97')][_0x9261('0x4a')]]}});}})[_0x9261('0x2b')](function(){if(_0x52d66e){return _0x52d66e;}})[_0x9261('0x2b')](respondWithResult(_0x441709,null))['catch'](handleError(_0x441709,null));};exports[_0x9261('0x9f')]=function(_0x5a761b,_0x3f8b3f){return db['CmContact'][_0x9261('0x32')]()[_0x9261('0x2b')](function(_0x44c78a){if(_0x5a761b[_0x9261('0x97')][_0x9261('0x90')]&&_[_0x9261('0x6c')](_0x5a761b[_0x9261('0x97')]['tags'])){if(_0x5a761b['body'][_0x9261('0x90')][_0x9261('0x34')]){_0x5a761b['body'][_0x9261('0x90')]=_0x5a761b[_0x9261('0x97')]['tags'][_0x9261('0x9a')](';')+';';}else{_0x5a761b[_0x9261('0x97')][_0x9261('0x90')]=null;}}else{_0x5a761b[_0x9261('0x97')][_0x9261('0x90')]=null;}return db[_0x9261('0x8e')][_0x9261('0x9f')](_0x5a761b[_0x9261('0x97')],{'fields':_[_0x9261('0x33')](_0x44c78a),'raw':!![]});})[_0x9261('0x2b')](respondWithResult(_0x3f8b3f,0xc9))[_0x9261('0x8d')](handleError(_0x3f8b3f,null));};exports[_0x9261('0xb0')]=function(_0x4287c4,_0x12f1d2){var _0x14bf51=[];var _0x2d9ac9=0x0;var _0x249908=0x0;var _0x333f8e=0x0;return db[_0x9261('0x8e')][_0x9261('0x32')]()[_0x9261('0x2b')](function(_0x7f3b1e){return BPromise['each'](_0x4287c4[_0x9261('0x97')],function(_0x3dd9e4){var _0x3ba94d={'where':{'$or':[]},'defaults':_0x3dd9e4,'fields':_[_0x9261('0x33')](_0x7f3b1e),'raw':!![]};if(_0x3dd9e4['duplicates']){for(var _0x362afd=0x0;_0x362afd<_0x3dd9e4['duplicates']['length'];_0x362afd++){var _0x1f0858={};_0x1f0858[_0x3dd9e4[_0x9261('0xb1')][_0x362afd]]=_0x3dd9e4[_0x3dd9e4[_0x9261('0xb1')][_0x362afd]];_0x3ba94d[_0x9261('0x47')]['$or'][_0x9261('0x37')](_0x1f0858);}_0x3ba94d['where'][_0x9261('0x68')]=_0x3dd9e4[_0x9261('0x68')];}return db['CmContact'][_0x9261('0xb2')](_0x3ba94d)[_0x9261('0xb3')](function(_0x52c786,_0x9b1ad5){if(_0x9b1ad5){_0x2d9ac9++;}else{_0x333f8e++;}})['catch'](function(_0x349966){console['error'](_0x349966);_0x249908++;});});})[_0x9261('0x2b')](function(_0x11de69){if(_0x11de69){return{'success':_0x2d9ac9,'failure':_0x249908,'duplicates':_0x333f8e};}})[_0x9261('0x2b')](respondWithResult(_0x12f1d2,0xc9))['catch'](handleError(_0x12f1d2,null));};exports['show']=function(_0x1ffb04,_0x52c4e5,_0x260fc7){var _0x375ba7;return db[_0x9261('0x8e')][_0x9261('0x32')]()[_0x9261('0x2b')](function(_0x2bac25){return db[_0x9261('0x8e')][_0x9261('0x55')]({'where':{'id':_0x1ffb04[_0x9261('0x8f')]['id']},'include':[{'model':db[_0x9261('0x56')],'as':'Tags','attributes':['id',_0x9261('0x2f'),_0x9261('0xb4')],'required':_0x1ffb04['query'][_0x9261('0x6d')]?!![]:![]}],'attributes':_[_0x9261('0x33')](_0x2bac25)});})['then'](function(_0x1a5d03){_0x375ba7=_0x1a5d03[_0x9261('0x98')]({'plain':!![]});var _0x322604={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x1a5d03&&_0x1a5d03[_0x9261('0x68')]){if(_0x1a5d03[_0x9261('0x68')]){_0x322604[_0x9261('0x47')]['$and'][_0x9261('0x37')]({'ListId':{'$ne':_0x1a5d03[_0x9261('0x68')]}});}}return db[_0x9261('0x93')][_0x9261('0x94')](_0x322604);})['then'](function(_0x1d897c){return _[_0x9261('0xb5')](_0x375ba7,_[_0x9261('0x59')](_0x1d897c,function(_0x1a686d){return util[_0x9261('0xb6')](_0x9261('0xb7'),_0x1a686d['id']);}));})[_0x9261('0x2b')](handleEntityNotFound(_0x52c4e5,null))[_0x9261('0x2b')](respondWithResult(_0x52c4e5,null))[_0x9261('0x8d')](handleError(_0x52c4e5,null));};exports['update']=function(_0x5a1610,_0x414094){var _0x1c85ee;if(_0x5a1610[_0x9261('0x97')]['id']){delete _0x5a1610['body']['id'];}return db[_0x9261('0x8e')][_0x9261('0x55')]({'where':{'id':_0x5a1610[_0x9261('0x8f')]['id']}})['then'](handleEntityNotFound(_0x414094,null))['then'](saveUpdates(_0x5a1610[_0x9261('0x97')],null))[_0x9261('0x2b')](function(_0x38b9f5){_0x1c85ee=_0x38b9f5;var _0x1e70cd={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x38b9f5&&_0x38b9f5[_0x9261('0x68')]){if(_0x38b9f5[_0x9261('0x68')]){_0x1e70cd[_0x9261('0x47')][_0x9261('0xb8')][_0x9261('0x37')]({'ListId':{'$ne':_0x38b9f5[_0x9261('0x68')]}});}}return db[_0x9261('0x93')][_0x9261('0x94')](_0x1e70cd);})[_0x9261('0x2b')](function(_0x335393){if(_0x335393){return _[_0x9261('0xb5')](_[_0x9261('0xb9')](_0x5a1610[_0x9261('0x97')],function(_0x406961,_0x381f4b){return _[_0x9261('0x35')](_0x381f4b,'cf_');}),_[_0x9261('0x59')](_0x335393,function(_0x2d26e3){return util[_0x9261('0xb6')](_0x9261('0xb7'),_0x2d26e3['id']);}));}})['then'](function(_0x4e65ae){if(_0x4e65ae&&!_[_0x9261('0x67')](_0x4e65ae)){var _0x1881b7=squel[_0x9261('0xa1')]()[_0x9261('0xba')](_0x9261('0xbb'))[_0x9261('0xbc')](_0x4e65ae)['where'](_0x9261('0xbd'),_0x5a1610[_0x9261('0x8f')]['id'])[_0x9261('0xbe')]();return db['sequelize'][_0x9261('0x3e')](_0x1881b7[_0x9261('0x62')],{'replacements':_0x1881b7[_0x9261('0x96')]});}})['then'](function(){if(_0x5a1610[_0x9261('0x97')]['phone']&&_0x1c85ee){return db[_0x9261('0x9c')][_0x9261('0xa1')]({'phone':_0x5a1610['body'][_0x9261('0xbf')]},{'where':{'ContactId':_0x1c85ee['id']}});}})[_0x9261('0x2b')](function(){return _0x1c85ee;})[_0x9261('0x2b')](respondWithResult(_0x414094,null))['catch'](handleError(_0x414094,null));};exports['getTags']=function(_0x3d1e20,_0x261095,_0x5c03c1){var _0x4de299={};var _0x2c1039={};var _0x231ca1;var _0x2a4f1a;return db[_0x9261('0x8e')][_0x9261('0x38')]({'where':{'id':_0x3d1e20[_0x9261('0x8f')]['id']}})[_0x9261('0x2b')](handleEntityNotFound(_0x261095,null))[_0x9261('0x2b')](function(_0x51cf90){if(_0x51cf90){_0x231ca1=_0x51cf90;_0x2c1039[_0x9261('0x3d')]=_['keys'](db[_0x9261('0x56')][_0x9261('0xc0')]);_0x2c1039[_0x9261('0x3e')]=_[_0x9261('0x33')](_0x3d1e20['query']);_0x2c1039[_0x9261('0x3f')]=_['intersection'](_0x2c1039['model'],_0x2c1039[_0x9261('0x3e')]);_0x4de299['attributes']=_[_0x9261('0x40')](_0x2c1039['model'],qs[_0x9261('0x42')](_0x3d1e20[_0x9261('0x3e')][_0x9261('0x42')]));_0x4de299['attributes']=_0x4de299['attributes'][_0x9261('0x34')]?_0x4de299['attributes']:_0x2c1039[_0x9261('0x3d')];_0x4de299[_0x9261('0x45')]=qs[_0x9261('0x46')](_0x3d1e20[_0x9261('0x3e')]['sort']);_0x4de299['where']=qs['filters'](_[_0x9261('0xc1')](_0x3d1e20[_0x9261('0x3e')],_0x2c1039['filters']));if(_0x3d1e20[_0x9261('0x3e')][_0x9261('0x64')]){_0x4de299[_0x9261('0x47')]=_[_0x9261('0x84')](_0x4de299['where'],{'$or':_[_0x9261('0x59')](_0x4de299[_0x9261('0x41')],function(_0x77399){var _0xfa949e={};_0xfa949e[_0x77399]={'$like':'%'+_0x3d1e20['query'][_0x9261('0x64')]+'%'};return _0xfa949e;})});}_0x4de299=_[_0x9261('0x84')]({},_0x4de299,_0x3d1e20[_0x9261('0xc2')]);return _0x231ca1[_0x9261('0xc3')](_0x4de299);}})[_0x9261('0x2b')](function(_0x3adff7){if(_0x3adff7){_0x2a4f1a=_0x3adff7[_0x9261('0x34')];if(!_0x3d1e20[_0x9261('0x3e')][_0x9261('0x43')](_0x9261('0x44'))){_0x4de299[_0x9261('0x25')]=qs[_0x9261('0x25')](_0x3d1e20[_0x9261('0x3e')][_0x9261('0x25')]);_0x4de299[_0x9261('0x24')]=qs[_0x9261('0x24')](_0x3d1e20[_0x9261('0x3e')][_0x9261('0x24')]);}return _0x231ca1['getTags'](_0x4de299);}})[_0x9261('0x2b')](function(_0x2e5cca){if(_0x2e5cca){return _0x2e5cca?{'count':_0x2a4f1a,'rows':_0x2e5cca}:null;}})['then'](respondWithResult(_0x261095,null))[_0x9261('0x8d')](handleError(_0x261095,null));};exports[_0x9261('0xc4')]=function(_0x55c649,_0x49ba86,_0x846122){if(_0x55c649[_0x9261('0x97')]['id']){delete _0x55c649['body']['id'];}return db['CmContact']['findOne']({'where':{'id':_0x55c649[_0x9261('0x8f')]['id']}})[_0x9261('0x2b')](handleEntityNotFound(_0x49ba86,null))[_0x9261('0x2b')](function(_0x1da73d){if(_0x1da73d){return _0x1da73d[_0x9261('0xc4')](_0x55c649['body']['ids']||[]);}return null;})[_0x9261('0x2b')](respondWithResult(_0x49ba86,null))[_0x9261('0x8d')](handleError(_0x49ba86,null));};exports[_0x9261('0xc5')]=function(_0x194aa6,_0x570ca0,_0x3488e8){var _0xf74b87={'raw':![],'where':{}};var _0xf06e0c={};var _0x84ef6a={'count':0x0,'rows':[]};return db[_0x9261('0x8e')][_0x9261('0x38')]({'where':{'id':_0x194aa6[_0x9261('0x8f')]['id']}})['then'](handleEntityNotFound(_0x570ca0,null))[_0x9261('0x2b')](function(_0x516c04){if(_0x516c04){_0xf06e0c[_0x9261('0x3d')]=_[_0x9261('0x33')](db[_0x9261('0x9c')][_0x9261('0xc0')]);_0xf06e0c[_0x9261('0x3e')]=_[_0x9261('0x33')](_0x194aa6[_0x9261('0x3e')]);_0xf06e0c[_0x9261('0x3f')]=_[_0x9261('0x40')](_0xf06e0c[_0x9261('0x3d')],_0xf06e0c[_0x9261('0x3e')]);_0xf74b87['attributes']=_['intersection'](_0xf06e0c[_0x9261('0x3d')],qs[_0x9261('0x42')](_0x194aa6[_0x9261('0x3e')]['fields']));_0xf74b87['attributes']=_0xf74b87[_0x9261('0x41')][_0x9261('0x34')]?_0xf74b87['attributes']:_0xf06e0c['model'];if(!_0x194aa6[_0x9261('0x3e')]['hasOwnProperty'](_0x9261('0x44'))){_0xf74b87[_0x9261('0x25')]=qs[_0x9261('0x25')](_0x194aa6[_0x9261('0x3e')][_0x9261('0x25')]);_0xf74b87[_0x9261('0x24')]=qs[_0x9261('0x24')](_0x194aa6[_0x9261('0x3e')][_0x9261('0x24')]);}_0xf74b87['order']=qs['sort'](_0x194aa6[_0x9261('0x3e')][_0x9261('0x46')]);_0xf74b87[_0x9261('0x47')]=qs[_0x9261('0x3f')](_[_0x9261('0xc1')](_0x194aa6[_0x9261('0x3e')],_0xf06e0c[_0x9261('0x3f')]));_0xf74b87['where']['ContactId']=_0x516c04['id'];if(_0x194aa6[_0x9261('0x3e')]['filter']){_0xf74b87[_0x9261('0x47')]=_[_0x9261('0x84')](_0xf74b87[_0x9261('0x47')],{'$or':_[_0x9261('0x59')](_0xf74b87[_0x9261('0x41')],function(_0x352e83){var _0x14752f={};_0x14752f[_0x352e83]={'$like':'%'+_0x194aa6[_0x9261('0x3e')][_0x9261('0x64')]+'%'};return _0x14752f;})});}_0xf74b87=_[_0x9261('0x84')]({},_0xf74b87,_0x194aa6['options']);return db[_0x9261('0x9c')][_0x9261('0x23')]({'where':_0xf74b87[_0x9261('0x47')]})[_0x9261('0x2b')](function(_0x544e92){_0x84ef6a[_0x9261('0x23')]=_0x544e92;if(_0x194aa6['query']['includeAll']){_0xf74b87[_0x9261('0xc6')]=[{'all':!![]}];}return db[_0x9261('0x9c')][_0x9261('0x94')](_0xf74b87);})[_0x9261('0x2b')](function(_0x25053f){_0x84ef6a['rows']=_0x25053f;return _0x84ef6a;});}})[_0x9261('0x2b')](respondWithFilteredResult(_0x570ca0,_0xf74b87))[_0x9261('0x8d')](handleError(_0x570ca0,null));};exports[_0x9261('0xc7')]=function(_0x21d821,_0x49c34e,_0x1c5092){var _0x5cf64c={'raw':!![],'where':{}};var _0x16234a={};var _0x3c619d={'count':0x0,'rows':[]};return db['CmContact'][_0x9261('0x38')]({'where':{'id':_0x21d821[_0x9261('0x8f')]['id']}})[_0x9261('0x2b')](handleEntityNotFound(_0x49c34e,null))['then'](function(_0x18d699){if(_0x18d699){_0x16234a[_0x9261('0x3d')]=_[_0x9261('0x33')](db[_0x9261('0xc8')][_0x9261('0xc0')]);_0x16234a[_0x9261('0x3e')]=_[_0x9261('0x33')](_0x21d821[_0x9261('0x3e')]);_0x16234a[_0x9261('0x3f')]=_[_0x9261('0x40')](_0x16234a[_0x9261('0x3d')],_0x16234a[_0x9261('0x3e')]);_0x5cf64c[_0x9261('0x41')]=_[_0x9261('0x40')](_0x16234a['model'],qs['fields'](_0x21d821['query'][_0x9261('0x42')]));_0x5cf64c[_0x9261('0x41')]=_0x5cf64c[_0x9261('0x41')][_0x9261('0x34')]?_0x5cf64c[_0x9261('0x41')]:_0x16234a['model'];if(!_0x21d821['query'][_0x9261('0x43')]('nolimit')){_0x5cf64c[_0x9261('0x25')]=qs['limit'](_0x21d821[_0x9261('0x3e')][_0x9261('0x25')]);_0x5cf64c['offset']=qs[_0x9261('0x24')](_0x21d821[_0x9261('0x3e')]['offset']);}_0x5cf64c[_0x9261('0x45')]=qs[_0x9261('0x46')](_0x21d821['query']['sort']);_0x5cf64c[_0x9261('0x47')]=qs[_0x9261('0x3f')](_[_0x9261('0xc1')](_0x21d821[_0x9261('0x3e')],_0x16234a[_0x9261('0x3f')]));_0x5cf64c['where'][_0x9261('0xc9')]=_0x18d699['id'];if(_0x21d821[_0x9261('0x3e')][_0x9261('0x64')]){_0x5cf64c[_0x9261('0x47')]=_[_0x9261('0x84')](_0x5cf64c['where'],{'$or':_[_0x9261('0x59')](_0x5cf64c[_0x9261('0x41')],function(_0x4a974c){var _0x5b4a3d={};_0x5b4a3d[_0x4a974c]={'$like':'%'+_0x21d821[_0x9261('0x3e')][_0x9261('0x64')]+'%'};return _0x5b4a3d;})});}_0x5cf64c=_[_0x9261('0x84')]({},_0x5cf64c,_0x21d821[_0x9261('0xc2')]);return db[_0x9261('0xc8')][_0x9261('0x23')]({'where':_0x5cf64c['where']})['then'](function(_0x37da8d){_0x3c619d[_0x9261('0x23')]=_0x37da8d;if(_0x21d821[_0x9261('0x3e')]['includeAll']){_0x5cf64c[_0x9261('0xc6')]=[{'all':!![]}];}return db['CmHopperHistory'][_0x9261('0x94')](_0x5cf64c);})[_0x9261('0x2b')](function(_0x69b17b){_0x3c619d[_0x9261('0xca')]=_0x69b17b;return _0x3c619d;});}})[_0x9261('0x2b')](respondWithFilteredResult(_0x49c34e,_0x5cf64c))[_0x9261('0x8d')](handleError(_0x49c34e,null));};exports[_0x9261('0xcb')]=function(_0x36f210,_0x5e941a,_0x19fb13){var _0x5d3905={'raw':!![],'where':{}};var _0x398614={};var _0x4162e4={'count':0x0,'rows':[]};return db[_0x9261('0x8e')][_0x9261('0x38')]({'where':{'id':_0x36f210[_0x9261('0x8f')]['id']}})[_0x9261('0x2b')](handleEntityNotFound(_0x5e941a,null))[_0x9261('0x2b')](function(_0xb6f628){if(_0xb6f628){_0x398614[_0x9261('0x3d')]=_[_0x9261('0x33')](db[_0x9261('0xcc')][_0x9261('0xc0')]);_0x398614['query']=_[_0x9261('0x33')](_0x36f210[_0x9261('0x3e')]);_0x398614[_0x9261('0x3f')]=_[_0x9261('0x40')](_0x398614[_0x9261('0x3d')],_0x398614[_0x9261('0x3e')]);_0x5d3905[_0x9261('0x41')]=_[_0x9261('0x40')](_0x398614[_0x9261('0x3d')],qs[_0x9261('0x42')](_0x36f210[_0x9261('0x3e')][_0x9261('0x42')]));_0x5d3905[_0x9261('0x41')]=_0x5d3905[_0x9261('0x41')][_0x9261('0x34')]?_0x5d3905[_0x9261('0x41')]:_0x398614[_0x9261('0x3d')];if(!_0x36f210[_0x9261('0x3e')][_0x9261('0x43')](_0x9261('0x44'))){_0x5d3905['limit']=qs['limit'](_0x36f210['query'][_0x9261('0x25')]);_0x5d3905['offset']=qs['offset'](_0x36f210['query'][_0x9261('0x24')]);}_0x5d3905[_0x9261('0x45')]=qs[_0x9261('0x46')](_0x36f210[_0x9261('0x3e')][_0x9261('0x46')]);_0x5d3905['where']=qs[_0x9261('0x3f')](_[_0x9261('0xc1')](_0x36f210['query'],_0x398614['filters']));_0x5d3905['where']['ContactId']=_0xb6f628['id'];if(_0x36f210[_0x9261('0x3e')][_0x9261('0x64')]){_0x5d3905['where']=_[_0x9261('0x84')](_0x5d3905[_0x9261('0x47')],{'$or':_[_0x9261('0x59')](_0x5d3905[_0x9261('0x41')],function(_0x16cec7){var _0x41d77f={};_0x41d77f[_0x16cec7]={'$like':'%'+_0x36f210[_0x9261('0x3e')][_0x9261('0x64')]+'%'};return _0x41d77f;})});}_0x5d3905=_[_0x9261('0x84')]({},_0x5d3905,_0x36f210[_0x9261('0xc2')]);return db['CmHopperFinal'][_0x9261('0x23')]({'where':_0x5d3905[_0x9261('0x47')]})[_0x9261('0x2b')](function(_0x273ae6){_0x4162e4[_0x9261('0x23')]=_0x273ae6;if(_0x36f210[_0x9261('0x3e')][_0x9261('0xcd')]){_0x5d3905[_0x9261('0xc6')]=[{'all':!![]}];}return db[_0x9261('0xcc')][_0x9261('0x94')](_0x5d3905);})[_0x9261('0x2b')](function(_0xb4183f){_0x4162e4[_0x9261('0xca')]=_0xb4183f;return _0x4162e4;});}})[_0x9261('0x2b')](respondWithFilteredResult(_0x5e941a,_0x5d3905))[_0x9261('0x8d')](handleError(_0x5e941a,null));};exports[_0x9261('0xce')]=function(_0x3f43b2,_0x46c99c,_0x54955c){var _0x294ca4={'raw':!![],'where':{}};var _0x2832f5={};var _0x9294bd={'count':0x0,'rows':[]};return db[_0x9261('0x8e')][_0x9261('0x38')]({'where':{'id':_0x3f43b2[_0x9261('0x8f')]['id']}})[_0x9261('0x2b')](handleEntityNotFound(_0x46c99c,null))[_0x9261('0x2b')](function(_0x225e3d){if(_0x225e3d){_0x2832f5[_0x9261('0x3d')]=_['keys'](db[_0x9261('0xaf')][_0x9261('0xc0')]);_0x2832f5['query']=_[_0x9261('0x33')](_0x3f43b2[_0x9261('0x3e')]);_0x2832f5['filters']=_[_0x9261('0x40')](_0x2832f5['model'],_0x2832f5['query']);_0x294ca4[_0x9261('0x41')]=_[_0x9261('0x40')](_0x2832f5[_0x9261('0x3d')],qs['fields'](_0x3f43b2[_0x9261('0x3e')][_0x9261('0x42')]));_0x294ca4[_0x9261('0x41')]=_0x294ca4[_0x9261('0x41')][_0x9261('0x34')]?_0x294ca4[_0x9261('0x41')]:_0x2832f5[_0x9261('0x3d')];if(!_0x3f43b2[_0x9261('0x3e')][_0x9261('0x43')](_0x9261('0x44'))){_0x294ca4[_0x9261('0x25')]=qs[_0x9261('0x25')](_0x3f43b2[_0x9261('0x3e')][_0x9261('0x25')]);_0x294ca4[_0x9261('0x24')]=qs[_0x9261('0x24')](_0x3f43b2[_0x9261('0x3e')][_0x9261('0x24')]);}_0x294ca4['order']=qs[_0x9261('0x46')](_0x3f43b2['query']['sort']);_0x294ca4[_0x9261('0x47')]=qs[_0x9261('0x3f')](_[_0x9261('0xc1')](_0x3f43b2[_0x9261('0x3e')],_0x2832f5[_0x9261('0x3f')]));_0x294ca4['where'][_0x9261('0xc9')]=_0x225e3d['id'];if(_0x3f43b2['query'][_0x9261('0x64')]){_0x294ca4[_0x9261('0x47')]=_[_0x9261('0x84')](_0x294ca4[_0x9261('0x47')],{'$or':_[_0x9261('0x59')](_0x294ca4['attributes'],function(_0x13bd7c){var _0x4f8838={};_0x4f8838[_0x13bd7c]={'$like':'%'+_0x3f43b2[_0x9261('0x3e')]['filter']+'%'};return _0x4f8838;})});}_0x294ca4=_[_0x9261('0x84')]({},_0x294ca4,_0x3f43b2[_0x9261('0xc2')]);return db[_0x9261('0xaf')]['count']({'where':_0x294ca4[_0x9261('0x47')]})[_0x9261('0x2b')](function(_0x3d7f8b){_0x9294bd[_0x9261('0x23')]=_0x3d7f8b;if(_0x3f43b2[_0x9261('0x3e')][_0x9261('0xcd')]){_0x294ca4[_0x9261('0xc6')]=[{'all':!![]}];}return db[_0x9261('0xaf')][_0x9261('0x94')](_0x294ca4);})[_0x9261('0x2b')](function(_0x235c37){_0x9294bd[_0x9261('0xca')]=_0x235c37;return _0x9294bd;});}})[_0x9261('0x2b')](respondWithFilteredResult(_0x46c99c,_0x294ca4))[_0x9261('0x8d')](handleError(_0x46c99c,null));};exports[_0x9261('0xcf')]=function(_0x476b2c,_0xf0b087,_0x3b3be9){try{if(!_0x476b2c[_0x9261('0x97')][_0x9261('0x68')]){throw new Error(_0x9261('0xd0'));}if(!_0x476b2c[_0x9261('0x97')][_0x9261('0xd1')]){throw new Error(_0x9261('0xd2'));}if(!_0x476b2c[_0x9261('0x97')]['binding_values']){throw new Error(_0x9261('0xd3'));}if(!_0x476b2c['body'][_0x9261('0xd4')]){throw new Error(_0x9261('0xd5'));}var _0x47f14f=_0x476b2c[_0x9261('0x97')][_0x9261('0xd1')]['split'](',');var _0x81db44=_0x476b2c['body'][_0x9261('0xd6')][_0x9261('0x58')](',');if(!_0x47f14f[_0x9261('0x34')]||!_0x81db44['length']||_0x47f14f[_0x9261('0x34')]!==_0x81db44[_0x9261('0x34')]){throw new Error(_0x9261('0xd7'));}_0x476b2c['body'][_0x9261('0x42')]=_[_0x9261('0xd8')](_0x47f14f,_0x81db44);if(!_0x476b2c[_0x9261('0x97')][_0x9261('0x42')][_0x9261('0xbf')]){throw new Error(_0x9261('0xd9'));}if(!_0x476b2c[_0x9261('0x97')][_0x9261('0x42')][_0x9261('0xda')]){throw new Error('No\x20firstName\x20column\x20specified');}var _0x530b34=path[_0x9261('0x9a')](config[_0x9261('0xdb')],_0x9261('0xdc'),_0x476b2c[_0x9261('0xdd')][_0x9261('0xde')]);fs[_0x9261('0xdf')](_0x530b34,parseInt(_0x9261('0xe0'),0x8));var _0x1a9ec4=require(_0x9261('0xe1'))['fork'](path['join'](__dirname,_0x9261('0xe2')),[_0x530b34,_0x476b2c[_0x9261('0x97')]['binding_keys'],_0x476b2c['body'][_0x9261('0xd6')],_0x476b2c[_0x9261('0x97')][_0x9261('0x68')],_0x476b2c[_0x9261('0x97')][_0x9261('0xe3')],_0x476b2c[_0x9261('0x97')][_0x9261('0xb1')],_0x476b2c['body']['socket_timestamp']]);return _0xf0b087[_0x9261('0x20')](0xc8)['json']({'message':_0x9261('0xe4'),'pid':_0x1a9ec4[_0x9261('0xe5')]});}catch(_0x46ab58){return _0xf0b087['status'](0x1f4)['send'](_0x46ab58);}};exports[_0x9261('0xe6')]=function(_0x2da04f,_0x230835,_0x384aee){var _0x3bb9e6=fs[_0x9261('0xe7')](_0x2da04f[_0x9261('0xdd')][_0x9261('0x7')]);Papa['parse'](_0x3bb9e6,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x517eef){return _0x230835[_0x9261('0x20')](0xc8)[_0x9261('0x22')]({'file':_0x2da04f[_0x9261('0xdd')],'fields':_0x517eef[_0x9261('0xe8')][_0x9261('0x42')]});}});};exports[_0x9261('0xe9')]=function(_0x28185a,_0x3bbb41,_0x4a3be3){return db['User']['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0x9261('0xea')}})['then'](function(_0x3b6c16){var _0x4ae2e2=![];if(!_0x28185a['body'][_0x9261('0x68')]){throw new Error(_0x9261('0xd0'));}if(!_0x28185a[_0x9261('0x97')][_0x9261('0xeb')][_0x9261('0xbf')]){throw new Error(_0x9261('0xd9'));}if(!_0x28185a[_0x9261('0x97')]['binding'][_0x9261('0xda')]){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x28185a['body'][_0x9261('0xd4')]){throw new Error(_0x9261('0xd5'));}var _0x57ef1a=require(_0x9261('0xe1'))[_0x9261('0xec')](path[_0x9261('0x9a')](__dirname,_0x9261('0xed')),[_0x28185a[_0x9261('0x8f')]['id'],JSON[_0x9261('0xee')](_0x28185a[_0x9261('0x97')]),JSON[_0x9261('0xee')](_0x3b6c16)]);_0x57ef1a['on'](_0x9261('0xef'),function(_0x3806c0){_0x4ae2e2=!![];return _0x3bbb41[_0x9261('0x20')](0xc8)['json']({'message':'start\x20child\x20process\x20correctly!','pid':_0x57ef1a[_0x9261('0xe5')]});});_0x57ef1a['on'](_0x9261('0xf0'),function(_0x4eeb8b){if(_0x4eeb8b&&!_0x4ae2e2){return _0x3bbb41['status'](0x1f4)[_0x9261('0x22')]({'message':_0x9261('0xf1'),'pid':_0x57ef1a[_0x9261('0xe5')]});}});})[_0x9261('0x8d')](handleError(_0x3bbb41,null));};
git://repos.xcallymotion.com / motion2.git / blob