// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xeebe=['reject','save','update','then','destroy','error','stack','name','send','index','CmContact','describe','length','keys','startsWith','cf_','push','trimStart','all','fieldType','type','query','filters','intersection','model','fields','attributes','nolimit','limit','order','sort','where','pick','field','color','tools_tags','select','from','left_join','cm_contact_has_tags','ct.CmContactId\x20=\x20c.id','t.id\x20=\x20ct.TagId','c.deletedAt\x20IS\x20NULL','expr','parseSearch','sqlOperator','conditions','find','Tag','value','split','map','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','and','datetime','castTo','DATE','buildExpression','text','start','isNil','Contact','isEmpty','concat','tag','isArray','filter','replace','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','isNumeric','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','group','c.id','Sequelize','QueryTypes','clone','DESC','having','resolve','user','role','c.ListId\x20IS\x20NULL','c.ListId\x20IN\x20?','agent','ListId','sequelize','toString','keyBy','c.firstName','c.phone','c.mobile','c.fax','c.ListId','c.createdAt','c.CompanyId','TagIds','Tags','rows','params','catch','tags','findAll','columnName','displayName','alias','custom','values','hasOwnProperty','merge','body','get','mergeWith','[CmContact][merge]\x20to\x20%s\x20from\x20%s','info','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','ChatOfflineMessage','MailMessage','MailInteraction','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','ReportAgentPreview','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappQueueReport','create','join','each','duplicates','$or','findOrCreate','$and','omit','cf_%d','pickBy','format','table','cm_contacts','setFields','toParam','phone','CmHopper','rawAttributes','options','getTags','findOne','setTags','ids','getHoppers','ContactId','includeAll','include','getHopperHistories','CmHopperHistory','getHopperFinals','getJscriptySessions','binding_keys','No\x20association\x20keys\x20specified!','binding_values','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','Incorrect\x20binding\x20parameters\x20passed!','firstName','root','server/files/tmp','file','filename','chmodSync','0777','fork','../../components/import/cm/csv','File\x20uploaded\x20correctly!','pid','upload','createReadStream','meta','import','No\x20ListId\x20specified','binding','No\x20phone\x20column\x20specified','child_process','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','exit','getJourney','mail','sms','openchannel','fax','whatsapp','voice','-createdAt','includes','channel','Invalid\x20channel','range','isValid','Invalid\x20date\x20for\x20range\x20to\x20filter','uniqueid','source','destination','callerid','starttime','endtime','duration','note','userSecondDisposition','userThirdDisposition','fullname','createdAt','VoiceCallReport','findAndCountAll','startCase','chat','Website','Account','closed','closedAt','disposition','secondDisposition','thirdDisposition','UserId','Owner','browserName','customerPort','osName','ratingMessage','ratingType','ratingValue','referer','substatus','threadId','Interaction','sortBy','reverse','html-pdf','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../mysqldb','redis','localhost','socket.io-emitter','./cmContact.socket','register','sendStatus','status','end','json','count','offset','apply'];(function(_0x1b8d87,_0x4168fb){var _0x182b74=function(_0x12b570){while(--_0x12b570){_0x1b8d87['push'](_0x1b8d87['shift']());}};_0x182b74(++_0x4168fb);}(_0xeebe,0xff));var _0xeeeb=function(_0x5d4607,_0x6b5e7b){_0x5d4607=_0x5d4607-0x0;var _0x5e4a86=_0xeebe[_0x5d4607];return _0x5e4a86;};'use strict';var pdf=require(_0xeeeb('0x0'));var emlformat=require('eml-format');var rimraf=require(_0xeeeb('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xeeeb('0x2'));var rp=require(_0xeeeb('0x3'));var moment=require(_0xeeeb('0x4'));var BPromise=require(_0xeeeb('0x5'));var Mustache=require(_0xeeeb('0x6'));var util=require(_0xeeeb('0x7'));var path=require(_0xeeeb('0x8'));var sox=require(_0xeeeb('0x9'));var csv=require(_0xeeeb('0xa'));var ejs=require(_0xeeeb('0xb'));var fs=require('fs');var _=require(_0xeeeb('0xc'));var squel=require(_0xeeeb('0xd'));var crypto=require(_0xeeeb('0xe'));var jsforce=require(_0xeeeb('0xf'));var deskjs=require(_0xeeeb('0x10'));var toCsv=require(_0xeeeb('0xa'));var querystring=require(_0xeeeb('0x11'));var Papa=require(_0xeeeb('0x12'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0xeeeb('0x13'));var as=require(_0xeeeb('0x14'));var hardwareService=require(_0xeeeb('0x15'));var logger=require('../../config/logger')(_0xeeeb('0x16'));var utils=require(_0xeeeb('0x17'));var config=require(_0xeeeb('0x18'));var licenseUtil=require('../../config/license/util');var db=require(_0xeeeb('0x19'))['db'];config['redis']=_['defaults'](config[_0xeeeb('0x1a')],{'host':_0xeeeb('0x1b'),'port':0x18eb});var socket=require(_0xeeeb('0x1c'))(new Redis(config[_0xeeeb('0x1a')]));require(_0xeeeb('0x1d'))[_0xeeeb('0x1e')](socket);function respondWithStatusCode(_0x17a038,_0x2ebb9a){_0x2ebb9a=_0x2ebb9a||0xcc;return function(_0x40b8e8){if(_0x40b8e8){return _0x17a038[_0xeeeb('0x1f')](_0x2ebb9a);}return _0x17a038[_0xeeeb('0x20')](_0x2ebb9a)[_0xeeeb('0x21')]();};}function respondWithResult(_0x1cbbbc,_0x25a5be){_0x25a5be=_0x25a5be||0xc8;return function(_0x253cf4){if(_0x253cf4){return _0x1cbbbc[_0xeeeb('0x20')](_0x25a5be)[_0xeeeb('0x22')](_0x253cf4);}};}function respondWithFilteredResult(_0x192efe,_0x106a84){return function(_0x2db8b1){if(_0x2db8b1){var _0x37efe6=_0x2db8b1[_0xeeeb('0x23')],_0x1af658=_0x106a84[_0xeeeb('0x24')],_0x2dba71=_0x106a84[_0xeeeb('0x24')]+_0x106a84['limit'],_0x313862;if(_0x2dba71>=_0x37efe6){_0x2dba71=_0x37efe6;_0x313862=0xc8;}else{_0x313862=0xce;}_0x192efe[_0xeeeb('0x20')](_0x313862);return _0x192efe['set']('Content-Range',_0x1af658+'-'+_0x2dba71+'/'+_0x37efe6)['json'](_0x2db8b1);}return null;};}function patchUpdates(_0x5b3cc8){return function(_0x9bf651){try{jsonpatch[_0xeeeb('0x25')](_0x9bf651,_0x5b3cc8,!![]);}catch(_0x506519){return BPromise[_0xeeeb('0x26')](_0x506519);}return _0x9bf651[_0xeeeb('0x27')]();};}function saveUpdates(_0x4acdc7,_0x4d4281){return function(_0x3409aa){if(_0x3409aa){return _0x3409aa[_0xeeeb('0x28')](_0x4acdc7)[_0xeeeb('0x29')](function(_0x70ce3c){return _0x70ce3c;});}return null;};}function removeEntity(_0x15aa09,_0x52db77){return function(_0x163471){if(_0x163471){return _0x163471[_0xeeeb('0x2a')]()['then'](function(){_0x15aa09['status'](0xcc)[_0xeeeb('0x21')]();});}};}function handleEntityNotFound(_0x3df022,_0x20ee2d){return function(_0xf0b577){if(!_0xf0b577){_0x3df022[_0xeeeb('0x1f')](0x194);}return _0xf0b577;};}function handleError(_0x192698,_0x22a67c){_0x22a67c=_0x22a67c||0x1f4;return function(_0x2f5854){logger[_0xeeeb('0x2b')](_0x2f5854[_0xeeeb('0x2c')]);if(_0x2f5854[_0xeeeb('0x2d')]){delete _0x2f5854['name'];}_0x192698['status'](_0x22a67c)[_0xeeeb('0x2e')](_0x2f5854);};}exports[_0xeeeb('0x2f')]=function(_0xc79799,_0x49e349){var _0x1d7c1e={},_0x210acb={},_0x5862bd={'count':0x0,'rows':[]};return db[_0xeeeb('0x30')][_0xeeeb('0x31')]()[_0xeeeb('0x29')](function(_0x230d38){var _0x725b79=[];for(var _0x1db147=0x0;_0x1db147<Object['keys'](_0x230d38)[_0xeeeb('0x32')];_0x1db147++){var _0x5023eb=Object[_0xeeeb('0x33')](_0x230d38)[_0x1db147];if(_[_0xeeeb('0x34')](_0x5023eb,_0xeeeb('0x35'))){_0x725b79[_0xeeeb('0x36')](db['CmCustomField']['findOne']({'where':{'id':_[_0xeeeb('0x37')](_0x5023eb,_0xeeeb('0x35'))},'raw':!![]}));}}return BPromise[_0xeeeb('0x38')](_0x725b79)[_0xeeeb('0x29')](function(_0x36c76a){for(var _0x29b3bb=0x0;_0x29b3bb<_0x36c76a['length'];_0x29b3bb++){if(_0x36c76a[_0x29b3bb]){var _0x2e0100='cf_'+_0x36c76a[_0x29b3bb]['id'];var _0x2073b4=_0x230d38[_0x2e0100];_0x2073b4[_0xeeeb('0x39')]=_0x36c76a[_0x29b3bb][_0xeeeb('0x3a')];}}return _0x230d38;});})[_0xeeeb('0x29')](function(_0x59572e){_0x210acb['model']=_[_0xeeeb('0x33')](_0x59572e);_0x210acb[_0xeeeb('0x3b')]=_[_0xeeeb('0x33')](_0xc79799[_0xeeeb('0x3b')]);_0x210acb[_0xeeeb('0x3c')]=_[_0xeeeb('0x3d')](_0x210acb[_0xeeeb('0x3e')],_0x210acb[_0xeeeb('0x3b')]);_0x1d7c1e['attributes']=_[_0xeeeb('0x3d')](_0x210acb[_0xeeeb('0x3e')],qs[_0xeeeb('0x3f')](_0xc79799['query']['fields']));_0x1d7c1e[_0xeeeb('0x40')]=_0x1d7c1e['attributes'][_0xeeeb('0x32')]?_0x1d7c1e['attributes']:_0x210acb[_0xeeeb('0x3e')];if(!_0xc79799['query']['hasOwnProperty'](_0xeeeb('0x41'))){_0x1d7c1e['limit']=qs[_0xeeeb('0x42')](_0xc79799['query'][_0xeeeb('0x42')]);_0x1d7c1e[_0xeeeb('0x24')]=qs[_0xeeeb('0x24')](_0xc79799['query'][_0xeeeb('0x24')]);}_0x1d7c1e[_0xeeeb('0x43')]=qs['sort'](_0xc79799[_0xeeeb('0x3b')][_0xeeeb('0x44')]);_0x1d7c1e[_0xeeeb('0x45')]=qs[_0xeeeb('0x3c')](_[_0xeeeb('0x46')](_0xc79799['query'],_0x210acb[_0xeeeb('0x3c')]),_0x59572e);var _0x4df294=[];var _0x5ebea3=squel['select']()['field']('id')[_0xeeeb('0x47')](_0xeeeb('0x2d'))[_0xeeeb('0x47')](_0xeeeb('0x48'))['from'](_0xeeeb('0x49'));var _0x2ce956=squel[_0xeeeb('0x4a')]()[_0xeeeb('0x4b')]('cm_contacts','c')['left_join']('cm_user_has_contacts','uc','uc.CmContactId\x20=\x20c.id')[_0xeeeb('0x4c')](_0xeeeb('0x4d'),'ct',_0xeeeb('0x4e'))[_0xeeeb('0x4c')](_0xeeeb('0x49'),'t',_0xeeeb('0x4f'))['where'](_0xeeeb('0x50'));var _0x62dd6d=squel[_0xeeeb('0x51')]();var _0x37d7a0=[];var _0x52d9a6=squel[_0xeeeb('0x51')]();var _0x7de8de;if(_0xc79799[_0xeeeb('0x3b')]['search']){_0x7de8de=as[_0xeeeb('0x52')](_0xc79799[_0xeeeb('0x3b')]['search']);var _0x15de13=_0x7de8de[_0xeeeb('0x53')];for(var _0x1b7d0b=0x0;_0x1b7d0b<_0x7de8de[_0xeeeb('0x54')][_0xeeeb('0x32')];_0x1b7d0b++){var _0x19f204=_0x7de8de['conditions'][_0x1b7d0b];var _0x1e3c3c='c';var _0x5e894d=_(_0x59572e)[_0xeeeb('0x33')]()[_0xeeeb('0x55')](function(_0x235e6b){return _0x235e6b===_0x19f204[_0xeeeb('0x47')];});if(_0x5e894d)_0x5e894d=_0x59572e[_0x19f204['field']];if(!_0x5e894d){if(_0x19f204[_0xeeeb('0x47')]===_0xeeeb('0x56')){var _0x2289bb=_0x19f204[_0xeeeb('0x57')][_0xeeeb('0x58')](',')[_0xeeeb('0x59')](function(_0x58b935){return Number(_0x58b935);});_0x2289bb[_0xeeeb('0x5a')](function(_0x275cd0){_0x52d9a6['or'](_0xeeeb('0x5b'),'%,'+_0x275cd0+',%');});_0x37d7a0=_[_0xeeeb('0x5c')](_0x37d7a0,_0x2289bb);}else if(_0x19f204[_0xeeeb('0x47')]===_0xeeeb('0x5d')){_0x62dd6d[_0xeeeb('0x5e')]('uc.UserId\x20=\x20?',_0x19f204[_0xeeeb('0x57')]);}}else{if(_0x19f204[_0xeeeb('0x47')]==='dateOfBirth'||_0x5e894d[_0xeeeb('0x39')]===_0xeeeb('0x5f'))_0x19f204[_0xeeeb('0x60')]=_0xeeeb('0x61');var _0x31b100=as[_0xeeeb('0x62')](_0x1e3c3c,_0x5e894d[_0xeeeb('0x3a')],_0x19f204);_0x62dd6d[_0x15de13](_0x31b100[_0xeeeb('0x63')],_0x31b100[_0xeeeb('0x57')][_0xeeeb('0x64')],_0x31b100['value'][_0xeeeb('0x21')]);}}}else{var _0x29075b=_(Object[_0xeeeb('0x33')](_0xc79799['query']))['map'](function(_0x1cc95b){return _0x59572e['hasOwnProperty'](_0x1cc95b)?_0x1cc95b:undefined;})['filter'](function(_0xf0cee3){return!_[_0xeeeb('0x65')](_0xf0cee3);})[_0xeeeb('0x57')]();if(_0xc79799['query'][_0xeeeb('0x66')])_0x29075b[_0xeeeb('0x36')](_0xeeeb('0x66'));if(!_[_0xeeeb('0x67')](_0x29075b)){_0x29075b[_0xeeeb('0x5a')](function(_0x43320b){if(_0x43320b==='ListId'){_0x2ce956[_0xeeeb('0x45')]('c.ListId\x20IN\x20?',[][_0xeeeb('0x68')](_0xc79799[_0xeeeb('0x3b')][_0x43320b]));}else if(_0x43320b===_0xeeeb('0x66')){var _0x30fb7d='%'+_0xc79799[_0xeeeb('0x3b')][_0x43320b]+'%';_0x2ce956[_0xeeeb('0x45')]('CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?',_0x30fb7d);}else{_0x2ce956['where']('c.'+_0x43320b+'\x20=\x20?',_0xc79799['query'][_0x43320b]);}});}if(_0xc79799[_0xeeeb('0x3b')][_0xeeeb('0x69')]){_0x37d7a0=_[_0xeeeb('0x6a')](_0xc79799[_0xeeeb('0x3b')][_0xeeeb('0x69')])?_0xc79799[_0xeeeb('0x3b')][_0xeeeb('0x69')]:new Array(_0xc79799[_0xeeeb('0x3b')]['tag']);_0x37d7a0['forEach'](function(_0x51e327){_0x52d9a6['or'](_0xeeeb('0x5b'),'%,'+_0x51e327+',%');});}if(_0xc79799[_0xeeeb('0x3b')]['filter']){var _0x2299a9=_0xc79799['query'][_0xeeeb('0x6b')][_0xeeeb('0x6c')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(_0x2299a9['split']('\x20')[_0xeeeb('0x32')]>0x1){_0x62dd6d['or'](_0xeeeb('0x6d'),qs[_0xeeeb('0x6e')](_0x2299a9),null);}else{if(qs[_0xeeeb('0x6f')](_0x2299a9)){_0x62dd6d['or']('c.id\x20LIKE\x20?',_0x2299a9+'%');_0x62dd6d['or'](_0xeeeb('0x70'),_0x2299a9+'%');_0x62dd6d['or'](_0xeeeb('0x71'),_0x2299a9+'%');_0x62dd6d['or'](_0xeeeb('0x72'),_0x2299a9+'%');}else if(qs[_0xeeeb('0x73')](_0x2299a9)){_0x62dd6d['or']('c.email\x20LIKE\x20?',_0x2299a9+'%');}else{_0x62dd6d['or'](_0xeeeb('0x74'),'%'+_0x2299a9+'%');_0x62dd6d['or'](_0xeeeb('0x75'),'%'+_0x2299a9+'%');_0x62dd6d['or']('c.email\x20LIKE\x20?','%'+_0x2299a9+'%');}}}}_0x2ce956[_0xeeeb('0x45')](_0x62dd6d);_0x2ce956[_0xeeeb('0x76')](_0xeeeb('0x77'));var _0x12dc4f={'type':db[_0xeeeb('0x78')][_0xeeeb('0x79')]['SELECT'],'raw':!![]};var _0x261761=_0x2ce956[_0xeeeb('0x7a')]()['field'](_0xeeeb('0x77'));if(_0x1d7c1e[_0xeeeb('0x43')]){_0x1d7c1e[_0xeeeb('0x43')][_0xeeeb('0x5a')](function(_0x1672a7){_0x2ce956[_0xeeeb('0x43')]('c.'+_0x1672a7[0x0],_0x1672a7[0x1]===_0xeeeb('0x7b')?![]:!![]);});}if(!_[_0xeeeb('0x67')](_0x37d7a0)){_0x2ce956[_0xeeeb('0x7c')](_0x52d9a6);_0x261761[_0xeeeb('0x45')]('t.id\x20IN\x20?',_0x37d7a0);}BPromise[_0xeeeb('0x7d')]()['then'](function(){if(!_0x7de8de)return;if(_0xc79799[_0xeeeb('0x7e')][_0xeeeb('0x7f')]!=='agent')return;if(!_['some'](_0x7de8de[_0xeeeb('0x54')],['field',_0xeeeb('0x5d')])){return _0xc79799[_0xeeeb('0x7e')]['getLists']({'attributes':['id'],'raw':!![]})[_0xeeeb('0x29')](function(_0x1655f6){if(_[_0xeeeb('0x67')](_0x1655f6)){_0x261761[_0xeeeb('0x45')](_0xeeeb('0x80'));_0x2ce956[_0xeeeb('0x45')](_0xeeeb('0x80'));}else{_0x261761[_0xeeeb('0x45')]('c.ListId\x20IN\x20?',_[_0xeeeb('0x59')](_0x1655f6,'id'));_0x2ce956[_0xeeeb('0x45')](_0xeeeb('0x81'),_[_0xeeeb('0x59')](_0x1655f6,'id'));}});}})[_0xeeeb('0x29')](function(){if(_0xc79799[_0xeeeb('0x7e')]['role']===_0xeeeb('0x82')&&!_0x7de8de&&!_0xc79799[_0xeeeb('0x3b')][_0xeeeb('0x83')])return[];return db[_0xeeeb('0x84')][_0xeeeb('0x3b')](_0x261761[_0xeeeb('0x85')](),_0x12dc4f);})[_0xeeeb('0x29')](function(_0x5b4d5c){_0x5862bd['count']=_0x5b4d5c[_0xeeeb('0x32')];if(_0x5862bd['count']===0x0)return[];return db[_0xeeeb('0x84')][_0xeeeb('0x3b')](_0x5ebea3[_0xeeeb('0x85')](),_0x12dc4f)['then'](function(_0x206a5f){_0x4df294=_[_0xeeeb('0x86')](_0x206a5f,'id');_0x12dc4f=_['merge'](_0x12dc4f,{'model':db[_0xeeeb('0x30')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0xc79799['query'][_0xeeeb('0x3f')]){_0x1d7c1e['attributes'][_0xeeeb('0x5a')](function(_0xbca82b){_0x2ce956[_0xeeeb('0x47')]('c.'+_0xbca82b);});}else{_0x2ce956['field'](_0xeeeb('0x77'));_0x2ce956['field'](_0xeeeb('0x87'));_0x2ce956['field']('c.lastName');_0x2ce956['field'](_0xeeeb('0x88'));_0x2ce956[_0xeeeb('0x47')](_0xeeeb('0x89'));_0x2ce956['field'](_0xeeeb('0x8a'));_0x2ce956[_0xeeeb('0x47')]('c.email');_0x2ce956[_0xeeeb('0x47')](_0xeeeb('0x8b'));_0x2ce956[_0xeeeb('0x47')](_0xeeeb('0x8c'));_0x2ce956['field']('c.deletedAt');_0x2ce956[_0xeeeb('0x47')](_0xeeeb('0x8d'));_0x2ce956[_0xeeeb('0x47')]('GROUP_CONCAT(DISTINCT\x20t.id)',_0xeeeb('0x8e'));}if(_0x1d7c1e['limit'])_0x2ce956[_0xeeeb('0x42')](_0x1d7c1e['limit']);if(_0x1d7c1e[_0xeeeb('0x24')])_0x2ce956[_0xeeeb('0x24')](_0x1d7c1e[_0xeeeb('0x24')]);return db[_0xeeeb('0x84')][_0xeeeb('0x3b')](_0x2ce956[_0xeeeb('0x85')](),_0x12dc4f);});})['then'](function(_0x476b32){_0x476b32[_0xeeeb('0x5a')](function(_0x468f1c){if(_0x468f1c[_0xeeeb('0x8e')]){_0x468f1c[_0xeeeb('0x8f')]=[];_0x468f1c['TagIds'][_0xeeeb('0x58')](',')['forEach'](function(_0x251a65){_0x468f1c['Tags'][_0xeeeb('0x36')](_0x4df294[_0x251a65]);});}delete _0x468f1c['TagIds'];});_0x5862bd[_0xeeeb('0x90')]=_0x476b32;return _0x5862bd;})[_0xeeeb('0x29')](respondWithFilteredResult(_0x49e349,_0x1d7c1e));})['catch'](handleError(_0x49e349,null));};exports[_0xeeeb('0x2a')]=function(_0x56fbdc,_0x49e49c){return db[_0xeeeb('0x30')][_0xeeeb('0x55')]({'where':{'id':_0x56fbdc[_0xeeeb('0x91')]['id']}})['then'](handleEntityNotFound(_0x49e49c,null))['then'](removeEntity(_0x49e49c,null))[_0xeeeb('0x92')](handleError(_0x49e49c,null));};exports['describe']=function(_0x20dd64,_0x449f8a){return db[_0xeeeb('0x30')][_0xeeeb('0x31')]()[_0xeeeb('0x29')](function(_0x4192a3){delete _0x4192a3[_0xeeeb('0x93')];for(var _0x4931cb=0x0;_0x4931cb<Object[_0xeeeb('0x33')](_0x4192a3)[_0xeeeb('0x32')];_0x4931cb++){var _0x3ece6a=Object[_0xeeeb('0x33')](_0x4192a3)[_0x4931cb];if(!_[_0xeeeb('0x34')](_0x3ece6a,_0xeeeb('0x35'))){_0x4192a3[_0x3ece6a]['columnName']=_0x3ece6a;_0x4192a3[_0x3ece6a]['displayName']=_0x3ece6a;}}return _0x4192a3;})[_0xeeeb('0x29')](function(_0x152098){var _0x44109e={'where':{'$or':[{'ListId':_0x20dd64[_0xeeeb('0x3b')]['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField'][_0xeeeb('0x94')](_0x44109e)[_0xeeeb('0x29')](function(_0x14394c){for(var _0x142d3f=0x0;_0x142d3f<_0x14394c[_0xeeeb('0x32')];_0x142d3f++){var _0xd21fba=_0xeeeb('0x35')+_0x14394c[_0x142d3f]['id'];_0x152098[_0xd21fba][_0xeeeb('0x95')]=_0xd21fba;_0x152098[_0xd21fba][_0xeeeb('0x96')]=_0x14394c[_0x142d3f][_0xeeeb('0x97')];_0x152098[_0xd21fba][_0xeeeb('0x98')]={'type':_0x14394c[_0x142d3f][_0xeeeb('0x3a')],'values':_0x14394c[_0x142d3f][_0xeeeb('0x99')]};}Object[_0xeeeb('0x33')](_0x152098)[_0xeeeb('0x5a')](function(_0x47d725){if(!_0x152098[_0x47d725][_0xeeeb('0x9a')](_0xeeeb('0x95'))){delete _0x152098[_0x47d725];}});return _0x152098;});})[_0xeeeb('0x29')](respondWithResult(_0x449f8a,null))[_0xeeeb('0x92')](handleError(_0x449f8a,null));};exports[_0xeeeb('0x9b')]=function(_0x1c9bc4,_0x4eee21){var _0x347183;var _0x185523;var _0x29ba81;if(_0x1c9bc4['body']['id']){delete _0x1c9bc4['body']['id'];}return db[_0xeeeb('0x30')]['findAll']({'where':{'id':[_0x1c9bc4['body']['to'],_0x1c9bc4[_0xeeeb('0x9c')][_0xeeeb('0x4b')]]}})['then'](function(_0x282c04){if(_0x282c04){if(_0x282c04[_0xeeeb('0x32')]!==0x2){return null;}_0x282c04[0x0]=_0x282c04[0x0]['get']({'plain':!![]});_0x282c04[0x1]=_0x282c04[0x1][_0xeeeb('0x9d')]({'plain':!![]});delete _0x282c04[0x0]['id'];delete _0x282c04[0x1]['id'];return _[_0xeeeb('0x9e')](_0x282c04[0x0],_0x282c04[0x1],function(_0xe68c87,_0x4f0127){if(Array['isArray'](_0x4f0127)&&!_0x4f0127['length']){return _0xe68c87;}else if(!_0x4f0127){return _0xe68c87;}});}})['then'](handleEntityNotFound(_0x4eee21,null))[_0xeeeb('0x29')](function(_0x412de1){if(_0x412de1){if(_0x412de1[_0xeeeb('0x93')]&&_['isArray'](_0x412de1['tags'])){_0x412de1[_0xeeeb('0x93')]=_0x412de1[_0xeeeb('0x93')]['join']();}logger['info'](_0xeeeb('0x9f'),_0x1c9bc4['body']['to'],_0x1c9bc4[_0xeeeb('0x9c')][_0xeeeb('0x4b')]);return db['CmHopper'][_0xeeeb('0x2a')]({'where':{'ContactId':[_0x1c9bc4[_0xeeeb('0x9c')]['to'],_0x1c9bc4[_0xeeeb('0x9c')][_0xeeeb('0x4b')]]}})[_0xeeeb('0x29')](function(_0x5a2732){logger[_0xeeeb('0xa0')](_0xeeeb('0xa1'),_0x5a2732);return db[_0xeeeb('0xa2')][_0xeeeb('0x2a')]({'where':{'ContactId':[_0x1c9bc4['body']['to'],_0x1c9bc4[_0xeeeb('0x9c')][_0xeeeb('0x4b')]]}})['then'](function(_0x3c4d7c){logger[_0xeeeb('0xa0')](_0xeeeb('0xa3'),_0x3c4d7c);return db[_0xeeeb('0x30')]['create'](_0x412de1);});});}})[_0xeeeb('0x29')](function(_0x49978c){if(_0x49978c){_0x347183=_0x49978c;_0x185523={'ContactId':_0x347183['id']};_0x29ba81={'where':{'ContactId':[_0x1c9bc4[_0xeeeb('0x9c')]['to'],_0x1c9bc4[_0xeeeb('0x9c')]['from']]}};return db['ChatInteraction'][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})[_0xeeeb('0x29')](function(){if(_0x347183){return db['ChatMessage']['update'](_0x185523,_0x29ba81);}})[_0xeeeb('0x29')](function(){if(_0x347183){return db[_0xeeeb('0xa4')][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})[_0xeeeb('0x29')](function(){if(_0x347183){return db['MailInteraction'][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})[_0xeeeb('0x29')](function(){if(_0x347183){return db[_0xeeeb('0xa5')][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})[_0xeeeb('0x29')](function(){if(_0x347183){return db[_0xeeeb('0xa6')]['update'](_0x185523,_0x29ba81);}})['then'](function(){if(_0x347183){return db[_0xeeeb('0xa5')][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})[_0xeeeb('0x29')](function(){if(_0x347183){return db['SmsInteraction'][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})[_0xeeeb('0x29')](function(){if(_0x347183){return db['SmsMessage'][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})[_0xeeeb('0x29')](function(){if(_0x347183){return db[_0xeeeb('0xa7')][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})['then'](function(){if(_0x347183){return db[_0xeeeb('0xa8')][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})['then'](function(){if(_0x347183){return db[_0xeeeb('0xa9')][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})[_0xeeeb('0x29')](function(){if(_0x347183){return db[_0xeeeb('0xaa')][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})[_0xeeeb('0x29')](function(){if(_0x347183){return db[_0xeeeb('0xab')][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})['then'](function(){if(_0x347183){return db['CmHopperHistory'][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})[_0xeeeb('0x29')](function(){if(_0x347183){return db[_0xeeeb('0xac')][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})['then'](function(){if(_0x347183){return db['VoiceCallReport'][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})[_0xeeeb('0x29')](function(){if(_0x347183){return db[_0xeeeb('0xad')][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})[_0xeeeb('0x29')](function(){if(_0x347183){return db[_0xeeeb('0xae')][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})[_0xeeeb('0x29')](function(){if(_0x347183){return db[_0xeeeb('0xaf')][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})[_0xeeeb('0x29')](function(){if(_0x347183){return db[_0xeeeb('0xb0')][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})[_0xeeeb('0x29')](function(){if(_0x347183){return db[_0xeeeb('0xb1')][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})[_0xeeeb('0x29')](function(){if(_0x347183){return db[_0xeeeb('0xb2')][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})[_0xeeeb('0x29')](function(){if(_0x347183){return db[_0xeeeb('0xb3')]['update'](_0x185523,_0x29ba81);}})['then'](function(){if(_0x347183){return db['WhatsappMessage'][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})[_0xeeeb('0x29')](function(){if(_0x347183){return db[_0xeeeb('0xb4')][_0xeeeb('0x28')](_0x185523,_0x29ba81);}})[_0xeeeb('0x29')](function(){if(_0x347183){return db[_0xeeeb('0x30')][_0xeeeb('0x2a')]({'where':{'id':[_0x1c9bc4[_0xeeeb('0x9c')]['to'],_0x1c9bc4[_0xeeeb('0x9c')][_0xeeeb('0x4b')]]}});}})['then'](function(){if(_0x347183){return _0x347183;}})[_0xeeeb('0x29')](respondWithResult(_0x4eee21,null))[_0xeeeb('0x92')](handleError(_0x4eee21,null));};exports[_0xeeeb('0xb5')]=function(_0x46a880,_0x123c75){return db[_0xeeeb('0x30')][_0xeeeb('0x31')]()[_0xeeeb('0x29')](function(_0x27b3ba){if(_0x46a880[_0xeeeb('0x9c')][_0xeeeb('0x93')]&&_[_0xeeeb('0x6a')](_0x46a880[_0xeeeb('0x9c')]['tags'])){if(_0x46a880['body'][_0xeeeb('0x93')][_0xeeeb('0x32')]){_0x46a880[_0xeeeb('0x9c')]['tags']=_0x46a880[_0xeeeb('0x9c')]['tags'][_0xeeeb('0xb6')](';')+';';}else{_0x46a880[_0xeeeb('0x9c')][_0xeeeb('0x93')]=null;}}else{_0x46a880[_0xeeeb('0x9c')][_0xeeeb('0x93')]=null;}return db['CmContact'][_0xeeeb('0xb5')](_0x46a880[_0xeeeb('0x9c')],{'fields':_['keys'](_0x27b3ba),'raw':!![]});})[_0xeeeb('0x29')](respondWithResult(_0x123c75,0xc9))[_0xeeeb('0x92')](handleError(_0x123c75,null));};exports['bulkCreate']=function(_0x300854,_0x133454){var _0x277856=[];var _0x3c8716=0x0;var _0x2dbc56=0x0;var _0x3f2b4d=0x0;return db['CmContact'][_0xeeeb('0x31')]()[_0xeeeb('0x29')](function(_0x36a79d){return BPromise[_0xeeeb('0xb7')](_0x300854[_0xeeeb('0x9c')],function(_0x3f5daf){var _0x5005de={'where':{'$or':[]},'defaults':_0x3f5daf,'fields':_[_0xeeeb('0x33')](_0x36a79d),'raw':!![]};if(_0x3f5daf['duplicates']){for(var _0x43e57d=0x0;_0x43e57d<_0x3f5daf[_0xeeeb('0xb8')][_0xeeeb('0x32')];_0x43e57d++){var _0x207121={};_0x207121[_0x3f5daf[_0xeeeb('0xb8')][_0x43e57d]]=_0x3f5daf[_0x3f5daf[_0xeeeb('0xb8')][_0x43e57d]];_0x5005de[_0xeeeb('0x45')][_0xeeeb('0xb9')][_0xeeeb('0x36')](_0x207121);}_0x5005de[_0xeeeb('0x45')][_0xeeeb('0x83')]=_0x3f5daf[_0xeeeb('0x83')];}return db['CmContact'][_0xeeeb('0xba')](_0x5005de)['spread'](function(_0x1545fb,_0x15d29b){if(_0x15d29b){_0x3c8716++;}else{_0x3f2b4d++;}})[_0xeeeb('0x92')](function(_0x4e10e8){console[_0xeeeb('0x2b')](_0x4e10e8);_0x2dbc56++;});});})['then'](function(_0x1e16ed){if(_0x1e16ed){return{'success':_0x3c8716,'failure':_0x2dbc56,'duplicates':_0x3f2b4d};}})[_0xeeeb('0x29')](respondWithResult(_0x133454,0xc9))['catch'](handleError(_0x133454,null));};exports['show']=function(_0x4a9047,_0xd87cca,_0xb8afc9){var _0x4ff656;return db[_0xeeeb('0x30')]['describe']()[_0xeeeb('0x29')](function(_0x5f3d72){return db[_0xeeeb('0x30')][_0xeeeb('0x55')]({'where':{'id':_0x4a9047['params']['id']},'include':[{'model':db[_0xeeeb('0x56')],'as':'Tags','attributes':['id',_0xeeeb('0x2d'),'color'],'required':_0x4a9047[_0xeeeb('0x3b')][_0xeeeb('0x69')]?!![]:![]}],'attributes':_[_0xeeeb('0x33')](_0x5f3d72)});})[_0xeeeb('0x29')](function(_0x328f59){_0x4ff656=_0x328f59['get']({'plain':!![]});var _0x4813d4={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x328f59&&_0x328f59['ListId']){if(_0x328f59[_0xeeeb('0x83')]){_0x4813d4[_0xeeeb('0x45')][_0xeeeb('0xbb')][_0xeeeb('0x36')]({'ListId':{'$ne':_0x328f59[_0xeeeb('0x83')]}});}}return db['CmCustomField'][_0xeeeb('0x94')](_0x4813d4);})[_0xeeeb('0x29')](function(_0x2919a5){return _[_0xeeeb('0xbc')](_0x4ff656,_[_0xeeeb('0x59')](_0x2919a5,function(_0x46f603){return util['format'](_0xeeeb('0xbd'),_0x46f603['id']);}));})['then'](handleEntityNotFound(_0xd87cca,null))[_0xeeeb('0x29')](respondWithResult(_0xd87cca,null))['catch'](handleError(_0xd87cca,null));};exports[_0xeeeb('0x28')]=function(_0x3c966b,_0x4089ce){var _0x54a674;if(_0x3c966b[_0xeeeb('0x9c')]['id']){delete _0x3c966b[_0xeeeb('0x9c')]['id'];}return db['CmContact'][_0xeeeb('0x55')]({'where':{'id':_0x3c966b[_0xeeeb('0x91')]['id']}})[_0xeeeb('0x29')](handleEntityNotFound(_0x4089ce,null))['then'](saveUpdates(_0x3c966b[_0xeeeb('0x9c')],null))[_0xeeeb('0x29')](function(_0x50ab93){_0x54a674=_0x50ab93;var _0x615b52={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x50ab93&&_0x50ab93[_0xeeeb('0x83')]){if(_0x50ab93[_0xeeeb('0x83')]){_0x615b52[_0xeeeb('0x45')]['$and'][_0xeeeb('0x36')]({'ListId':{'$ne':_0x50ab93[_0xeeeb('0x83')]}});}}return db['CmCustomField']['findAll'](_0x615b52);})[_0xeeeb('0x29')](function(_0x3dc693){if(_0x3dc693){return _[_0xeeeb('0xbc')](_[_0xeeeb('0xbe')](_0x3c966b[_0xeeeb('0x9c')],function(_0x2e7229,_0x7c7f0e){return _[_0xeeeb('0x34')](_0x7c7f0e,_0xeeeb('0x35'));}),_[_0xeeeb('0x59')](_0x3dc693,function(_0x4d045e){return util[_0xeeeb('0xbf')](_0xeeeb('0xbd'),_0x4d045e['id']);}));}})[_0xeeeb('0x29')](function(_0x3f2bd3){if(_0x3f2bd3&&!_[_0xeeeb('0x67')](_0x3f2bd3)){var _0x13ecf2=squel['update']()[_0xeeeb('0xc0')](_0xeeeb('0xc1'))[_0xeeeb('0xc2')](_0x3f2bd3)[_0xeeeb('0x45')]('id\x20=\x20?',_0x3c966b[_0xeeeb('0x91')]['id'])[_0xeeeb('0xc3')]();return db[_0xeeeb('0x84')][_0xeeeb('0x3b')](_0x13ecf2[_0xeeeb('0x63')],{'replacements':_0x13ecf2['values']});}})[_0xeeeb('0x29')](function(){if(_0x3c966b['body'][_0xeeeb('0xc4')]&&_0x54a674){return db[_0xeeeb('0xc5')][_0xeeeb('0x28')]({'phone':_0x3c966b['body'][_0xeeeb('0xc4')]},{'where':{'ContactId':_0x54a674['id']}});}})[_0xeeeb('0x29')](function(){return _0x54a674;})['then'](respondWithResult(_0x4089ce,null))[_0xeeeb('0x92')](handleError(_0x4089ce,null));};exports['getTags']=function(_0x266e66,_0x4dace1,_0x38030f){var _0x240d31={};var _0x2f9d78={};var _0x39c749;var _0xf779ed;return db['CmContact']['findOne']({'where':{'id':_0x266e66[_0xeeeb('0x91')]['id']}})[_0xeeeb('0x29')](handleEntityNotFound(_0x4dace1,null))[_0xeeeb('0x29')](function(_0x38a47a){if(_0x38a47a){_0x39c749=_0x38a47a;_0x2f9d78[_0xeeeb('0x3e')]=_[_0xeeeb('0x33')](db[_0xeeeb('0x56')][_0xeeeb('0xc6')]);_0x2f9d78['query']=_[_0xeeeb('0x33')](_0x266e66[_0xeeeb('0x3b')]);_0x2f9d78[_0xeeeb('0x3c')]=_[_0xeeeb('0x3d')](_0x2f9d78['model'],_0x2f9d78[_0xeeeb('0x3b')]);_0x240d31['attributes']=_[_0xeeeb('0x3d')](_0x2f9d78[_0xeeeb('0x3e')],qs[_0xeeeb('0x3f')](_0x266e66['query'][_0xeeeb('0x3f')]));_0x240d31[_0xeeeb('0x40')]=_0x240d31[_0xeeeb('0x40')][_0xeeeb('0x32')]?_0x240d31[_0xeeeb('0x40')]:_0x2f9d78[_0xeeeb('0x3e')];_0x240d31[_0xeeeb('0x43')]=qs[_0xeeeb('0x44')](_0x266e66[_0xeeeb('0x3b')][_0xeeeb('0x44')]);_0x240d31[_0xeeeb('0x45')]=qs[_0xeeeb('0x3c')](_['pick'](_0x266e66[_0xeeeb('0x3b')],_0x2f9d78[_0xeeeb('0x3c')]));if(_0x266e66[_0xeeeb('0x3b')][_0xeeeb('0x6b')]){_0x240d31[_0xeeeb('0x45')]=_[_0xeeeb('0x9b')](_0x240d31[_0xeeeb('0x45')],{'$or':_[_0xeeeb('0x59')](_0x240d31[_0xeeeb('0x40')],function(_0x2bafe3){var _0x19a395={};_0x19a395[_0x2bafe3]={'$like':'%'+_0x266e66[_0xeeeb('0x3b')][_0xeeeb('0x6b')]+'%'};return _0x19a395;})});}_0x240d31=_['merge']({},_0x240d31,_0x266e66[_0xeeeb('0xc7')]);return _0x39c749[_0xeeeb('0xc8')](_0x240d31);}})[_0xeeeb('0x29')](function(_0x5785e5){if(_0x5785e5){_0xf779ed=_0x5785e5[_0xeeeb('0x32')];if(!_0x266e66[_0xeeeb('0x3b')][_0xeeeb('0x9a')](_0xeeeb('0x41'))){_0x240d31[_0xeeeb('0x42')]=qs[_0xeeeb('0x42')](_0x266e66['query'][_0xeeeb('0x42')]);_0x240d31[_0xeeeb('0x24')]=qs[_0xeeeb('0x24')](_0x266e66[_0xeeeb('0x3b')][_0xeeeb('0x24')]);}return _0x39c749[_0xeeeb('0xc8')](_0x240d31);}})[_0xeeeb('0x29')](function(_0x5b740b){if(_0x5b740b){return _0x5b740b?{'count':_0xf779ed,'rows':_0x5b740b}:null;}})[_0xeeeb('0x29')](respondWithResult(_0x4dace1,null))[_0xeeeb('0x92')](handleError(_0x4dace1,null));};exports['setTags']=function(_0x3b8d08,_0x3e611c,_0x2d549b){if(_0x3b8d08[_0xeeeb('0x9c')]['id']){delete _0x3b8d08[_0xeeeb('0x9c')]['id'];}return db[_0xeeeb('0x30')][_0xeeeb('0xc9')]({'where':{'id':_0x3b8d08[_0xeeeb('0x91')]['id']}})[_0xeeeb('0x29')](handleEntityNotFound(_0x3e611c,null))[_0xeeeb('0x29')](function(_0x2a50a0){if(_0x2a50a0){return _0x2a50a0[_0xeeeb('0xca')](_0x3b8d08[_0xeeeb('0x9c')][_0xeeeb('0xcb')]||[]);}return null;})['then'](respondWithResult(_0x3e611c,null))[_0xeeeb('0x92')](handleError(_0x3e611c,null));};exports[_0xeeeb('0xcc')]=function(_0x24afd0,_0x3ca32b,_0x5dd2d0){var _0x46c3d4={'raw':![],'where':{}};var _0xfd842d={};var _0x5aa68b={'count':0x0,'rows':[]};return db[_0xeeeb('0x30')][_0xeeeb('0xc9')]({'where':{'id':_0x24afd0[_0xeeeb('0x91')]['id']}})[_0xeeeb('0x29')](handleEntityNotFound(_0x3ca32b,null))[_0xeeeb('0x29')](function(_0x2f5a50){if(_0x2f5a50){_0xfd842d['model']=_[_0xeeeb('0x33')](db['CmHopper'][_0xeeeb('0xc6')]);_0xfd842d[_0xeeeb('0x3b')]=_[_0xeeeb('0x33')](_0x24afd0['query']);_0xfd842d[_0xeeeb('0x3c')]=_['intersection'](_0xfd842d[_0xeeeb('0x3e')],_0xfd842d[_0xeeeb('0x3b')]);_0x46c3d4[_0xeeeb('0x40')]=_[_0xeeeb('0x3d')](_0xfd842d['model'],qs['fields'](_0x24afd0['query'][_0xeeeb('0x3f')]));_0x46c3d4[_0xeeeb('0x40')]=_0x46c3d4[_0xeeeb('0x40')][_0xeeeb('0x32')]?_0x46c3d4[_0xeeeb('0x40')]:_0xfd842d['model'];if(!_0x24afd0['query'][_0xeeeb('0x9a')](_0xeeeb('0x41'))){_0x46c3d4[_0xeeeb('0x42')]=qs[_0xeeeb('0x42')](_0x24afd0[_0xeeeb('0x3b')][_0xeeeb('0x42')]);_0x46c3d4[_0xeeeb('0x24')]=qs[_0xeeeb('0x24')](_0x24afd0[_0xeeeb('0x3b')][_0xeeeb('0x24')]);}_0x46c3d4[_0xeeeb('0x43')]=qs[_0xeeeb('0x44')](_0x24afd0[_0xeeeb('0x3b')][_0xeeeb('0x44')]);_0x46c3d4['where']=qs['filters'](_[_0xeeeb('0x46')](_0x24afd0['query'],_0xfd842d[_0xeeeb('0x3c')]));_0x46c3d4[_0xeeeb('0x45')][_0xeeeb('0xcd')]=_0x2f5a50['id'];if(_0x24afd0[_0xeeeb('0x3b')][_0xeeeb('0x6b')]){_0x46c3d4['where']=_[_0xeeeb('0x9b')](_0x46c3d4[_0xeeeb('0x45')],{'$or':_[_0xeeeb('0x59')](_0x46c3d4[_0xeeeb('0x40')],function(_0x117b08){var _0x40bde0={};_0x40bde0[_0x117b08]={'$like':'%'+_0x24afd0[_0xeeeb('0x3b')]['filter']+'%'};return _0x40bde0;})});}_0x46c3d4=_[_0xeeeb('0x9b')]({},_0x46c3d4,_0x24afd0[_0xeeeb('0xc7')]);return db[_0xeeeb('0xc5')]['count']({'where':_0x46c3d4['where']})[_0xeeeb('0x29')](function(_0x36100f){_0x5aa68b[_0xeeeb('0x23')]=_0x36100f;if(_0x24afd0['query'][_0xeeeb('0xce')]){_0x46c3d4[_0xeeeb('0xcf')]=[{'all':!![]}];}return db[_0xeeeb('0xc5')]['findAll'](_0x46c3d4);})[_0xeeeb('0x29')](function(_0x4f5da1){_0x5aa68b[_0xeeeb('0x90')]=_0x4f5da1;return _0x5aa68b;});}})[_0xeeeb('0x29')](respondWithFilteredResult(_0x3ca32b,_0x46c3d4))['catch'](handleError(_0x3ca32b,null));};exports[_0xeeeb('0xd0')]=function(_0x315c89,_0x3d54c3,_0x24e3b5){var _0x12b5a2={'raw':!![],'where':{}};var _0x5843cc={};var _0x169488={'count':0x0,'rows':[]};return db['CmContact'][_0xeeeb('0xc9')]({'where':{'id':_0x315c89[_0xeeeb('0x91')]['id']}})[_0xeeeb('0x29')](handleEntityNotFound(_0x3d54c3,null))[_0xeeeb('0x29')](function(_0x35c009){if(_0x35c009){_0x5843cc['model']=_[_0xeeeb('0x33')](db['CmHopperHistory']['rawAttributes']);_0x5843cc[_0xeeeb('0x3b')]=_[_0xeeeb('0x33')](_0x315c89[_0xeeeb('0x3b')]);_0x5843cc[_0xeeeb('0x3c')]=_[_0xeeeb('0x3d')](_0x5843cc[_0xeeeb('0x3e')],_0x5843cc[_0xeeeb('0x3b')]);_0x12b5a2[_0xeeeb('0x40')]=_[_0xeeeb('0x3d')](_0x5843cc['model'],qs[_0xeeeb('0x3f')](_0x315c89[_0xeeeb('0x3b')][_0xeeeb('0x3f')]));_0x12b5a2[_0xeeeb('0x40')]=_0x12b5a2['attributes'][_0xeeeb('0x32')]?_0x12b5a2[_0xeeeb('0x40')]:_0x5843cc[_0xeeeb('0x3e')];if(!_0x315c89[_0xeeeb('0x3b')][_0xeeeb('0x9a')]('nolimit')){_0x12b5a2[_0xeeeb('0x42')]=qs['limit'](_0x315c89[_0xeeeb('0x3b')]['limit']);_0x12b5a2['offset']=qs[_0xeeeb('0x24')](_0x315c89['query'][_0xeeeb('0x24')]);}_0x12b5a2[_0xeeeb('0x43')]=qs[_0xeeeb('0x44')](_0x315c89[_0xeeeb('0x3b')][_0xeeeb('0x44')]);_0x12b5a2[_0xeeeb('0x45')]=qs['filters'](_[_0xeeeb('0x46')](_0x315c89[_0xeeeb('0x3b')],_0x5843cc[_0xeeeb('0x3c')]));_0x12b5a2[_0xeeeb('0x45')][_0xeeeb('0xcd')]=_0x35c009['id'];if(_0x315c89[_0xeeeb('0x3b')][_0xeeeb('0x6b')]){_0x12b5a2['where']=_[_0xeeeb('0x9b')](_0x12b5a2[_0xeeeb('0x45')],{'$or':_[_0xeeeb('0x59')](_0x12b5a2[_0xeeeb('0x40')],function(_0x2992b3){var _0x342a3e={};_0x342a3e[_0x2992b3]={'$like':'%'+_0x315c89['query'][_0xeeeb('0x6b')]+'%'};return _0x342a3e;})});}_0x12b5a2=_[_0xeeeb('0x9b')]({},_0x12b5a2,_0x315c89[_0xeeeb('0xc7')]);return db[_0xeeeb('0xd1')]['count']({'where':_0x12b5a2[_0xeeeb('0x45')]})[_0xeeeb('0x29')](function(_0x3080a3){_0x169488[_0xeeeb('0x23')]=_0x3080a3;if(_0x315c89[_0xeeeb('0x3b')][_0xeeeb('0xce')]){_0x12b5a2[_0xeeeb('0xcf')]=[{'all':!![]}];}return db[_0xeeeb('0xd1')][_0xeeeb('0x94')](_0x12b5a2);})[_0xeeeb('0x29')](function(_0x5c6e6b){_0x169488['rows']=_0x5c6e6b;return _0x169488;});}})[_0xeeeb('0x29')](respondWithFilteredResult(_0x3d54c3,_0x12b5a2))[_0xeeeb('0x92')](handleError(_0x3d54c3,null));};exports[_0xeeeb('0xd2')]=function(_0x4d9cdf,_0x2ff0fe,_0x470c29){var _0xa091ac={'raw':!![],'where':{}};var _0x2dcf17={};var _0xbef570={'count':0x0,'rows':[]};return db['CmContact'][_0xeeeb('0xc9')]({'where':{'id':_0x4d9cdf[_0xeeeb('0x91')]['id']}})['then'](handleEntityNotFound(_0x2ff0fe,null))[_0xeeeb('0x29')](function(_0x29d58d){if(_0x29d58d){_0x2dcf17[_0xeeeb('0x3e')]=_[_0xeeeb('0x33')](db[_0xeeeb('0xab')][_0xeeeb('0xc6')]);_0x2dcf17[_0xeeeb('0x3b')]=_[_0xeeeb('0x33')](_0x4d9cdf[_0xeeeb('0x3b')]);_0x2dcf17[_0xeeeb('0x3c')]=_[_0xeeeb('0x3d')](_0x2dcf17['model'],_0x2dcf17['query']);_0xa091ac[_0xeeeb('0x40')]=_[_0xeeeb('0x3d')](_0x2dcf17[_0xeeeb('0x3e')],qs[_0xeeeb('0x3f')](_0x4d9cdf['query'][_0xeeeb('0x3f')]));_0xa091ac['attributes']=_0xa091ac[_0xeeeb('0x40')]['length']?_0xa091ac['attributes']:_0x2dcf17[_0xeeeb('0x3e')];if(!_0x4d9cdf[_0xeeeb('0x3b')][_0xeeeb('0x9a')](_0xeeeb('0x41'))){_0xa091ac[_0xeeeb('0x42')]=qs['limit'](_0x4d9cdf[_0xeeeb('0x3b')][_0xeeeb('0x42')]);_0xa091ac['offset']=qs[_0xeeeb('0x24')](_0x4d9cdf[_0xeeeb('0x3b')][_0xeeeb('0x24')]);}_0xa091ac[_0xeeeb('0x43')]=qs[_0xeeeb('0x44')](_0x4d9cdf[_0xeeeb('0x3b')][_0xeeeb('0x44')]);_0xa091ac[_0xeeeb('0x45')]=qs[_0xeeeb('0x3c')](_[_0xeeeb('0x46')](_0x4d9cdf[_0xeeeb('0x3b')],_0x2dcf17[_0xeeeb('0x3c')]));_0xa091ac[_0xeeeb('0x45')][_0xeeeb('0xcd')]=_0x29d58d['id'];if(_0x4d9cdf['query']['filter']){_0xa091ac[_0xeeeb('0x45')]=_[_0xeeeb('0x9b')](_0xa091ac['where'],{'$or':_[_0xeeeb('0x59')](_0xa091ac[_0xeeeb('0x40')],function(_0x242470){var _0x4b5ecd={};_0x4b5ecd[_0x242470]={'$like':'%'+_0x4d9cdf[_0xeeeb('0x3b')]['filter']+'%'};return _0x4b5ecd;})});}_0xa091ac=_[_0xeeeb('0x9b')]({},_0xa091ac,_0x4d9cdf['options']);return db['CmHopperFinal'][_0xeeeb('0x23')]({'where':_0xa091ac['where']})[_0xeeeb('0x29')](function(_0x5e5cb6){_0xbef570[_0xeeeb('0x23')]=_0x5e5cb6;if(_0x4d9cdf['query'][_0xeeeb('0xce')]){_0xa091ac['include']=[{'all':!![]}];}return db[_0xeeeb('0xab')][_0xeeeb('0x94')](_0xa091ac);})[_0xeeeb('0x29')](function(_0x34de3d){_0xbef570[_0xeeeb('0x90')]=_0x34de3d;return _0xbef570;});}})[_0xeeeb('0x29')](respondWithFilteredResult(_0x2ff0fe,_0xa091ac))[_0xeeeb('0x92')](handleError(_0x2ff0fe,null));};exports[_0xeeeb('0xd3')]=function(_0x41d376,_0x18d147,_0x1965c7){var _0x5f2810={'raw':!![],'where':{}};var _0x573a49={};var _0x21d8ad={'count':0x0,'rows':[]};return db[_0xeeeb('0x30')][_0xeeeb('0xc9')]({'where':{'id':_0x41d376['params']['id']}})[_0xeeeb('0x29')](handleEntityNotFound(_0x18d147,null))[_0xeeeb('0x29')](function(_0x5a21d0){if(_0x5a21d0){_0x573a49['model']=_[_0xeeeb('0x33')](db[_0xeeeb('0xb2')][_0xeeeb('0xc6')]);_0x573a49[_0xeeeb('0x3b')]=_['keys'](_0x41d376[_0xeeeb('0x3b')]);_0x573a49['filters']=_['intersection'](_0x573a49['model'],_0x573a49['query']);_0x5f2810[_0xeeeb('0x40')]=_[_0xeeeb('0x3d')](_0x573a49['model'],qs[_0xeeeb('0x3f')](_0x41d376['query'][_0xeeeb('0x3f')]));_0x5f2810['attributes']=_0x5f2810[_0xeeeb('0x40')]['length']?_0x5f2810[_0xeeeb('0x40')]:_0x573a49[_0xeeeb('0x3e')];if(!_0x41d376[_0xeeeb('0x3b')][_0xeeeb('0x9a')](_0xeeeb('0x41'))){_0x5f2810[_0xeeeb('0x42')]=qs[_0xeeeb('0x42')](_0x41d376[_0xeeeb('0x3b')][_0xeeeb('0x42')]);_0x5f2810[_0xeeeb('0x24')]=qs[_0xeeeb('0x24')](_0x41d376[_0xeeeb('0x3b')][_0xeeeb('0x24')]);}_0x5f2810[_0xeeeb('0x43')]=qs['sort'](_0x41d376['query'][_0xeeeb('0x44')]);_0x5f2810[_0xeeeb('0x45')]=qs[_0xeeeb('0x3c')](_['pick'](_0x41d376[_0xeeeb('0x3b')],_0x573a49[_0xeeeb('0x3c')]));_0x5f2810[_0xeeeb('0x45')][_0xeeeb('0xcd')]=_0x5a21d0['id'];if(_0x41d376[_0xeeeb('0x3b')][_0xeeeb('0x6b')]){_0x5f2810['where']=_['merge'](_0x5f2810[_0xeeeb('0x45')],{'$or':_['map'](_0x5f2810[_0xeeeb('0x40')],function(_0xc1927c){var _0x55933f={};_0x55933f[_0xc1927c]={'$like':'%'+_0x41d376['query']['filter']+'%'};return _0x55933f;})});}_0x5f2810=_[_0xeeeb('0x9b')]({},_0x5f2810,_0x41d376[_0xeeeb('0xc7')]);return db[_0xeeeb('0xb2')][_0xeeeb('0x23')]({'where':_0x5f2810[_0xeeeb('0x45')]})['then'](function(_0xab5287){_0x21d8ad[_0xeeeb('0x23')]=_0xab5287;if(_0x41d376['query'][_0xeeeb('0xce')]){_0x5f2810[_0xeeeb('0xcf')]=[{'all':!![]}];}return db[_0xeeeb('0xb2')][_0xeeeb('0x94')](_0x5f2810);})['then'](function(_0x5b531f){_0x21d8ad[_0xeeeb('0x90')]=_0x5b531f;return _0x21d8ad;});}})[_0xeeeb('0x29')](respondWithFilteredResult(_0x18d147,_0x5f2810))[_0xeeeb('0x92')](handleError(_0x18d147,null));};exports['uploadCsv']=function(_0x2f53ba,_0x20f0c7,_0x42fa5c){try{if(!_0x2f53ba[_0xeeeb('0x9c')][_0xeeeb('0x83')]){throw new Error('No\x20ListId\x20specified');}if(!_0x2f53ba[_0xeeeb('0x9c')][_0xeeeb('0xd4')]){throw new Error(_0xeeeb('0xd5'));}if(!_0x2f53ba['body'][_0xeeeb('0xd6')]){throw new Error('No\x20association\x20values\x20specified!');}if(!_0x2f53ba[_0xeeeb('0x9c')][_0xeeeb('0xd7')]){throw new Error(_0xeeeb('0xd8'));}var _0x1e9370=_0x2f53ba[_0xeeeb('0x9c')][_0xeeeb('0xd4')][_0xeeeb('0x58')](',');var _0x35504e=_0x2f53ba[_0xeeeb('0x9c')][_0xeeeb('0xd6')]['split'](',');if(!_0x1e9370['length']||!_0x35504e[_0xeeeb('0x32')]||_0x1e9370[_0xeeeb('0x32')]!==_0x35504e[_0xeeeb('0x32')]){throw new Error(_0xeeeb('0xd9'));}_0x2f53ba[_0xeeeb('0x9c')][_0xeeeb('0x3f')]=_['zipObject'](_0x1e9370,_0x35504e);if(!_0x2f53ba[_0xeeeb('0x9c')][_0xeeeb('0x3f')][_0xeeeb('0xc4')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x2f53ba[_0xeeeb('0x9c')][_0xeeeb('0x3f')][_0xeeeb('0xda')]){throw new Error('No\x20firstName\x20column\x20specified');}var _0x202bda=path[_0xeeeb('0xb6')](config[_0xeeeb('0xdb')],_0xeeeb('0xdc'),_0x2f53ba[_0xeeeb('0xdd')][_0xeeeb('0xde')]);fs[_0xeeeb('0xdf')](_0x202bda,parseInt(_0xeeeb('0xe0'),0x8));var _0x3b1ad9=require('child_process')[_0xeeeb('0xe1')](path[_0xeeeb('0xb6')](__dirname,_0xeeeb('0xe2')),[_0x202bda,_0x2f53ba['body'][_0xeeeb('0xd4')],_0x2f53ba['body'][_0xeeeb('0xd6')],_0x2f53ba[_0xeeeb('0x9c')]['ListId'],_0x2f53ba[_0xeeeb('0x9c')]['CompanyId'],_0x2f53ba[_0xeeeb('0x9c')][_0xeeeb('0xb8')],_0x2f53ba[_0xeeeb('0x9c')][_0xeeeb('0xd7')]]);return _0x20f0c7['status'](0xc8)[_0xeeeb('0x22')]({'message':_0xeeeb('0xe3'),'pid':_0x3b1ad9[_0xeeeb('0xe4')]});}catch(_0x24ce70){return _0x20f0c7[_0xeeeb('0x20')](0x1f4)['send'](_0x24ce70);}};exports[_0xeeeb('0xe5')]=function(_0x2b9211,_0x4e7c32,_0x4b2930){var _0x36eff1=fs[_0xeeeb('0xe6')](_0x2b9211[_0xeeeb('0xdd')]['path']);Papa['parse'](_0x36eff1,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x4c359f){return _0x4e7c32['status'](0xc8)[_0xeeeb('0x22')]({'file':_0x2b9211[_0xeeeb('0xdd')],'fields':_0x4c359f[_0xeeeb('0xe7')][_0xeeeb('0x3f')]});}});};exports[_0xeeeb('0xe8')]=function(_0xfeb729,_0x12a2db,_0xd8030d){return db['User'][_0xeeeb('0x94')]({'raw':!![],'attributes':['id'],'where':{'role':_0xeeeb('0x82')}})[_0xeeeb('0x29')](function(_0x3a5d25){var _0x2b7c88=![];if(!_0xfeb729[_0xeeeb('0x9c')]['ListId']){throw new Error(_0xeeeb('0xe9'));}if(!_0xfeb729[_0xeeeb('0x9c')][_0xeeeb('0xea')][_0xeeeb('0xc4')]){throw new Error(_0xeeeb('0xeb'));}if(!_0xfeb729[_0xeeeb('0x9c')][_0xeeeb('0xea')][_0xeeeb('0xda')]){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0xfeb729[_0xeeeb('0x9c')][_0xeeeb('0xd7')]){throw new Error(_0xeeeb('0xd8'));}var _0x591f92=require(_0xeeeb('0xec'))[_0xeeeb('0xe1')](path[_0xeeeb('0xb6')](__dirname,_0xeeeb('0xed')),[_0xfeb729[_0xeeeb('0x91')]['id'],JSON[_0xeeeb('0xee')](_0xfeb729[_0xeeeb('0x9c')]),JSON['stringify'](_0x3a5d25)]);_0x591f92['on'](_0xeeeb('0xef'),function(_0x481887){_0x2b7c88=!![];return _0x12a2db['status'](0xc8)['json']({'message':_0xeeeb('0xf0'),'pid':_0x591f92['pid']});});_0x591f92['on'](_0xeeeb('0xf1'),function(_0x42d856){if(_0x42d856&&!_0x2b7c88){return _0x12a2db['status'](0x1f4)[_0xeeeb('0x22')]({'message':'error\x20child\x20process','pid':_0x591f92['pid']});}});})[_0xeeeb('0x92')](handleError(_0x12a2db,null));};exports[_0xeeeb('0xf2')]=function(_0x3db627,_0x20e934){var _0x2c11d3=[_0xeeeb('0xf3'),'chat',_0xeeeb('0xf4'),_0xeeeb('0xf5'),_0xeeeb('0xf6'),_0xeeeb('0xf7'),_0xeeeb('0xf8')];var _0x33ab13={'offset':0x0,'order':qs[_0xeeeb('0x44')](_0xeeeb('0xf9'))},_0x3679ce={'count':0x0,'rows':[]};Promise[_0xeeeb('0x7d')]()[_0xeeeb('0x29')](function(){if(_0x3db627[_0xeeeb('0x3b')]['channel']){if(!_[_0xeeeb('0xfa')](_0x2c11d3,_0x3db627[_0xeeeb('0x3b')][_0xeeeb('0xfb')]['toLowerCase']())){throw new Error(_0xeeeb('0xfc'));}_0x2c11d3=[_0x3db627[_0xeeeb('0x3b')][_0xeeeb('0xfb')]['toLowerCase']()];}if(_0x3db627[_0xeeeb('0x3b')][_0xeeeb('0xfd')]){try{var _0x802bbb=JSON['parse'](_0x3db627[_0xeeeb('0x3b')][_0xeeeb('0xfd')]);if(!moment(_0x802bbb[_0xeeeb('0x4b')])[_0xeeeb('0xfe')]()){throw new Error('Invalid\x20date\x20for\x20range\x20from\x20filter');}if(!moment(_0x802bbb['to'])[_0xeeeb('0xfe')]()){throw new Error(_0xeeeb('0xff'));}}catch(_0x587182){throw new Error('Invalid\x20createdAt\x20filter');}}if(!_0x3db627[_0xeeeb('0x3b')][_0xeeeb('0x9a')]('nolimit')){_0x33ab13[_0xeeeb('0x42')]=qs['limit'](_0x3db627[_0xeeeb('0x3b')][_0xeeeb('0x42')]||0xa);_0x33ab13[_0xeeeb('0x24')]=qs[_0xeeeb('0x24')](_0x3db627[_0xeeeb('0x3b')]['offset']);}var _0x2ab5f1=_0x2c11d3[_0xeeeb('0x59')](function(_0x579828){if(_0x579828===_0xeeeb('0xf8')){var _0x4c72ab={'attributes':['id',_0xeeeb('0x100'),_0xeeeb('0x3a'),_0xeeeb('0x101'),_0xeeeb('0x102'),_0xeeeb('0x103'),_0xeeeb('0x104'),_0xeeeb('0x105'),_0xeeeb('0x106'),_0xeeeb('0x107'),'createdAt','userDisposition',_0xeeeb('0x108'),_0xeeeb('0x109')],'where':{'ContactId':_0x3db627[_0xeeeb('0x91')]['id']},'include':[{'model':db[_0xeeeb('0x5d')],'as':_0xeeeb('0x5d'),'attributes':['id','name',_0xeeeb('0x10a'),_0xeeeb('0x97')]}],'order':[[_0xeeeb('0x10b'),_0xeeeb('0x7b')]]};if(_0x3db627[_0xeeeb('0x3b')][_0xeeeb('0xfd')]){_0x4c72ab[_0xeeeb('0x45')][_0xeeeb('0x10b')]={'$gte':_0x802bbb[_0xeeeb('0x4b')],'$lte':_0x802bbb['to']};}return db[_0xeeeb('0x10c')][_0xeeeb('0x10d')](_0x4c72ab)[_0xeeeb('0x29')](function(_0x2ef2a2){_0x3679ce['count']+=_0x2ef2a2['count'];return _['map'](_0x2ef2a2[_0xeeeb('0x90')],function(_0x15803e){var _0x5e36ac=_0x15803e['get']({'plain':!![]});_0x5e36ac[_0xeeeb('0xfb')]=_0x579828;if(_0x5e36ac[_0xeeeb('0x5d')]){_0x5e36ac[_0xeeeb('0x5d')]={'id':_0x5e36ac[_0xeeeb('0x5d')]['id'],'name':_0x5e36ac[_0xeeeb('0x5d')][_0xeeeb('0x2d')],'fullname':_0x5e36ac[_0xeeeb('0x5d')][_0xeeeb('0x10a')],'alias':_0x5e36ac['User'][_0xeeeb('0x97')]};}return _0x5e36ac;});});}else{var _0x353405=_[_0xeeeb('0x10e')](_0x579828)+(_0x579828===_0xeeeb('0x10f')?_0xeeeb('0x110'):_0xeeeb('0x111'));var _0x9b3623={'attributes':['id',_0xeeeb('0x112'),_0xeeeb('0x113'),_0xeeeb('0x10b'),_0xeeeb('0x107'),_0xeeeb('0x114'),_0xeeeb('0x115'),_0xeeeb('0x116'),_0xeeeb('0x117'),_0x353405+'Id'],'where':{'ContactId':_0x3db627[_0xeeeb('0x91')]['id']},'include':[{'model':db[_0x353405],'as':_0xeeeb('0x111'),'attributes':['id',_0xeeeb('0x2d'),'key']},{'model':db[_0xeeeb('0x5d')],'as':_0xeeeb('0x118'),'attributes':['id',_0xeeeb('0x2d'),_0xeeeb('0x10a')]},{'model':db[_0xeeeb('0x56')],'as':_0xeeeb('0x8f'),'attributes':['id',_0xeeeb('0x2d'),_0xeeeb('0x48')],'through':{'attributes':[]}}],'order':[[_0xeeeb('0x10b'),_0xeeeb('0x7b')]]};if(_0x3db627[_0xeeeb('0x3b')][_0xeeeb('0xfd')]){_0x9b3623[_0xeeeb('0x45')]['createdAt']={'$gte':_0x802bbb['from'],'$lte':_0x802bbb['to']};}switch(_0x579828){case _0xeeeb('0x10f'):_0x9b3623[_0xeeeb('0x40')][_0xeeeb('0x36')](_0xeeeb('0x119'),'customerIp',_0xeeeb('0x11a'),'deviceModel',_0xeeeb('0x11b'),_0xeeeb('0x11c'),_0xeeeb('0x11d'),_0xeeeb('0x11e'),_0xeeeb('0x11f'));break;case _0xeeeb('0xf3'):_0x9b3623[_0xeeeb('0x40')]['push']('subject',_0xeeeb('0x120'));break;case _0xeeeb('0xf5'):_0x9b3623[_0xeeeb('0x40')][_0xeeeb('0x36')]('externalUrl',_0xeeeb('0x121'));break;}return db[_[_0xeeeb('0x10e')](_0x579828)+_0xeeeb('0x122')][_0xeeeb('0x10d')](_0x9b3623)['then'](function(_0x88a380){_0x3679ce[_0xeeeb('0x23')]+=_0x88a380['count'];return _[_0xeeeb('0x59')](_0x88a380[_0xeeeb('0x90')],function(_0x5713fa){var _0x1c0209=_0x5713fa[_0xeeeb('0x9d')]({'plain':!![]});_0x1c0209['channel']=_0x579828;if(_0x1c0209['Owner']){_0x1c0209[_0xeeeb('0x118')]={'id':_0x1c0209['Owner']['id'],'name':_0x1c0209[_0xeeeb('0x118')][_0xeeeb('0x2d')],'fullname':_0x1c0209[_0xeeeb('0x118')][_0xeeeb('0x10a')]};}return _0x1c0209;});});}});return Promise[_0xeeeb('0x38')](_0x2ab5f1);})[_0xeeeb('0x29')](function(_0x522020){return _(_0x522020)['flatten']()[_0xeeeb('0x123')](_0xeeeb('0x10b'))[_0xeeeb('0x124')]()['value']();})[_0xeeeb('0x29')](function(_0x4d8a17){_0x3679ce['rows']=_0x33ab13[_0xeeeb('0x42')]?_0x4d8a17['slice'](_0x33ab13['offset'],_0x33ab13['offset']+_0x33ab13[_0xeeeb('0x42')]):_0x4d8a17;return _0x3679ce;})[_0xeeeb('0x29')](respondWithFilteredResult(_0x20e934,_0x33ab13))['catch'](handleError(_0x20e934,null));};
\ No newline at end of file
+var _0x1948=['userSecondDisposition','DESC','findAndCountAll','fullname','startCase','Website','Account','closed','closedAt','secondDisposition','thirdDisposition','UserId','Owner','browserName','customerPort','deviceModel','osName','ratingMessage','ratingType','ratingValue','referer','substatus','threadId','Interaction','all','flatten','sortBy','reverse','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','ejs','squel','crypto','desk.js','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./cmContact.socket','register','sendStatus','status','end','count','offset','set','json','reject','save','update','then','name','send','index','describe','keys','startsWith','cf_','push','findOne','fieldType','type','query','filters','intersection','attributes','model','fields','length','hasOwnProperty','limit','order','sort','pick','select','field','from','tools_tags','cm_contacts','left_join','uc.CmContactId\x20=\x20c.id','cm_contact_has_tags','ct.CmContactId\x20=\x20c.id','t.id\x20=\x20ct.TagId','c.deletedAt\x20IS\x20NULL','expr','parseSearch','search','sqlOperator','conditions','find','Tag','value','split','map','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','uc.UserId\x20=\x20?','datetime','castTo','DATE','buildExpression','text','start','filter','isNil','Contact','isEmpty','ListId','where','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','tag','isArray','replace','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','isNumeric','c.id\x20LIKE\x20?','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','group','c.id','SELECT','clone','having','t.id\x20IN\x20?','resolve','user','role','agent','some','getLists','c.ListId\x20IS\x20NULL','c.ListId\x20IN\x20?','sequelize','toString','merge','CmContact','c.lastName','c.phone','c.mobile','c.fax','c.email','c.deletedAt','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','Tags','rows','destroy','columnName','displayName','CmCustomField','findAll','alias','body','get','mergeWith','tags','join','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','CmHopperBlack','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','FaxMessage','CmHopperFinal','ReportAgentPreview','VoiceCallReport','FaxQueueReport','MailQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappMessage','WhatsappQueueReport','catch','bulkCreate','each','duplicates','$or','findOrCreate','error','show','params','color','$and','omit','format','cf_%d','setFields','id\x20=\x20?','toParam','values','phone','getTags','rawAttributes','options','nolimit','setTags','getHoppers','ContactId','getHopperHistories','CmHopperHistory','includeAll','include','getHopperFinals','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','Incorrect\x20binding\x20parameters\x20passed!','zipObject','firstName','No\x20firstName\x20column\x20specified','root','server/files/tmp','file','filename','0777','fork','../../components/import/cm/csv','CompanyId','socket_timestamp','File\x20uploaded\x20correctly!','pid','upload','createReadStream','meta','import','binding','No\x20phone\x20column\x20specified','child_process','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','exit','getJourney','mail','chat','fax','whatsapp','-createdAt','channel','includes','toLowerCase','Invalid\x20channel','range','parse','isValid','Invalid\x20date\x20for\x20range\x20from\x20filter','Invalid\x20createdAt\x20filter','uniqueid','destination','endtime','duration','note','createdAt','userDisposition'];(function(_0x2d64fc,_0x42b2a7){var _0x2c8556=function(_0x4b29da){while(--_0x4b29da){_0x2d64fc['push'](_0x2d64fc['shift']());}};_0x2c8556(++_0x42b2a7);}(_0x1948,0x145));var _0x8194=function(_0x1ef912,_0xe60aa9){_0x1ef912=_0x1ef912-0x0;var _0x4b7aff=_0x1948[_0x1ef912];return _0x4b7aff;};'use strict';var pdf=require(_0x8194('0x0'));var emlformat=require(_0x8194('0x1'));var rimraf=require(_0x8194('0x2'));var zipdir=require(_0x8194('0x3'));var jsonpatch=require(_0x8194('0x4'));var rp=require('request-promise');var moment=require(_0x8194('0x5'));var BPromise=require(_0x8194('0x6'));var Mustache=require(_0x8194('0x7'));var util=require(_0x8194('0x8'));var path=require(_0x8194('0x9'));var sox=require(_0x8194('0xa'));var csv=require(_0x8194('0xb'));var ejs=require(_0x8194('0xc'));var fs=require('fs');var _=require('lodash');var squel=require(_0x8194('0xd'));var crypto=require(_0x8194('0xe'));var jsforce=require('jsforce');var deskjs=require(_0x8194('0xf'));var toCsv=require(_0x8194('0xb'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0x8194('0x10'));var authService=require(_0x8194('0x11'));var qs=require(_0x8194('0x12'));var as=require(_0x8194('0x13'));var hardwareService=require(_0x8194('0x14'));var logger=require('../../config/logger')(_0x8194('0x15'));var utils=require(_0x8194('0x16'));var config=require(_0x8194('0x17'));var licenseUtil=require('../../config/license/util');var db=require(_0x8194('0x18'))['db'];config[_0x8194('0x19')]=_[_0x8194('0x1a')](config[_0x8194('0x19')],{'host':_0x8194('0x1b'),'port':0x18eb});var socket=require(_0x8194('0x1c'))(new Redis(config['redis']));require(_0x8194('0x1d'))[_0x8194('0x1e')](socket);function respondWithStatusCode(_0xfd031c,_0x2ab425){_0x2ab425=_0x2ab425||0xcc;return function(_0x2d4463){if(_0x2d4463){return _0xfd031c[_0x8194('0x1f')](_0x2ab425);}return _0xfd031c[_0x8194('0x20')](_0x2ab425)[_0x8194('0x21')]();};}function respondWithResult(_0x19c23e,_0x5abd09){_0x5abd09=_0x5abd09||0xc8;return function(_0x49731d){if(_0x49731d){return _0x19c23e[_0x8194('0x20')](_0x5abd09)['json'](_0x49731d);}};}function respondWithFilteredResult(_0x41a11e,_0x4afbe3){return function(_0x55e4c2){if(_0x55e4c2){var _0x5f2172=_0x55e4c2[_0x8194('0x22')],_0x37b048=_0x4afbe3[_0x8194('0x23')],_0x43a192=_0x4afbe3[_0x8194('0x23')]+_0x4afbe3['limit'],_0x48421e;if(_0x43a192>=_0x5f2172){_0x43a192=_0x5f2172;_0x48421e=0xc8;}else{_0x48421e=0xce;}_0x41a11e['status'](_0x48421e);return _0x41a11e[_0x8194('0x24')]('Content-Range',_0x37b048+'-'+_0x43a192+'/'+_0x5f2172)[_0x8194('0x25')](_0x55e4c2);}return null;};}function patchUpdates(_0x24d1ff){return function(_0x9421f5){try{jsonpatch['apply'](_0x9421f5,_0x24d1ff,!![]);}catch(_0x3cdb81){return BPromise[_0x8194('0x26')](_0x3cdb81);}return _0x9421f5[_0x8194('0x27')]();};}function saveUpdates(_0x28df4f,_0x1babf1){return function(_0x17dcde){if(_0x17dcde){return _0x17dcde[_0x8194('0x28')](_0x28df4f)[_0x8194('0x29')](function(_0x269a22){return _0x269a22;});}return null;};}function removeEntity(_0x263093,_0xbb64b7){return function(_0x300491){if(_0x300491){return _0x300491['destroy']()[_0x8194('0x29')](function(){_0x263093[_0x8194('0x20')](0xcc)[_0x8194('0x21')]();});}};}function handleEntityNotFound(_0x46a242,_0x55b0d9){return function(_0x34c430){if(!_0x34c430){_0x46a242[_0x8194('0x1f')](0x194);}return _0x34c430;};}function handleError(_0x425a1d,_0x42c3b0){_0x42c3b0=_0x42c3b0||0x1f4;return function(_0x3e8cb3){logger['error'](_0x3e8cb3['stack']);if(_0x3e8cb3[_0x8194('0x2a')]){delete _0x3e8cb3[_0x8194('0x2a')];}_0x425a1d[_0x8194('0x20')](_0x42c3b0)[_0x8194('0x2b')](_0x3e8cb3);};}exports[_0x8194('0x2c')]=function(_0x56c512,_0x4af9cc){var _0x5624a0={},_0x1ea1f={},_0x56b5bc={'count':0x0,'rows':[]};return db['CmContact'][_0x8194('0x2d')]()[_0x8194('0x29')](function(_0x4ee84e){var _0x1ef19a=[];for(var _0x58f209=0x0;_0x58f209<Object[_0x8194('0x2e')](_0x4ee84e)['length'];_0x58f209++){var _0x2fa6ff=Object[_0x8194('0x2e')](_0x4ee84e)[_0x58f209];if(_[_0x8194('0x2f')](_0x2fa6ff,_0x8194('0x30'))){_0x1ef19a[_0x8194('0x31')](db['CmCustomField'][_0x8194('0x32')]({'where':{'id':_['trimStart'](_0x2fa6ff,_0x8194('0x30'))},'raw':!![]}));}}return BPromise['all'](_0x1ef19a)[_0x8194('0x29')](function(_0x275dac){for(var _0x371daf=0x0;_0x371daf<_0x275dac['length'];_0x371daf++){if(_0x275dac[_0x371daf]){var _0x56ac52=_0x8194('0x30')+_0x275dac[_0x371daf]['id'];var _0x2582ea=_0x4ee84e[_0x56ac52];_0x2582ea[_0x8194('0x33')]=_0x275dac[_0x371daf][_0x8194('0x34')];}}return _0x4ee84e;});})['then'](function(_0x52d0d2){_0x1ea1f['model']=_[_0x8194('0x2e')](_0x52d0d2);_0x1ea1f[_0x8194('0x35')]=_[_0x8194('0x2e')](_0x56c512[_0x8194('0x35')]);_0x1ea1f[_0x8194('0x36')]=_[_0x8194('0x37')](_0x1ea1f['model'],_0x1ea1f[_0x8194('0x35')]);_0x5624a0[_0x8194('0x38')]=_[_0x8194('0x37')](_0x1ea1f[_0x8194('0x39')],qs[_0x8194('0x3a')](_0x56c512[_0x8194('0x35')][_0x8194('0x3a')]));_0x5624a0[_0x8194('0x38')]=_0x5624a0[_0x8194('0x38')][_0x8194('0x3b')]?_0x5624a0[_0x8194('0x38')]:_0x1ea1f[_0x8194('0x39')];if(!_0x56c512['query'][_0x8194('0x3c')]('nolimit')){_0x5624a0['limit']=qs[_0x8194('0x3d')](_0x56c512[_0x8194('0x35')]['limit']);_0x5624a0['offset']=qs['offset'](_0x56c512['query']['offset']);}_0x5624a0[_0x8194('0x3e')]=qs[_0x8194('0x3f')](_0x56c512[_0x8194('0x35')]['sort']);_0x5624a0['where']=qs['filters'](_[_0x8194('0x40')](_0x56c512[_0x8194('0x35')],_0x1ea1f[_0x8194('0x36')]),_0x52d0d2);var _0x2256d8=[];var _0x4aa53a=squel[_0x8194('0x41')]()[_0x8194('0x42')]('id')[_0x8194('0x42')](_0x8194('0x2a'))[_0x8194('0x42')]('color')[_0x8194('0x43')](_0x8194('0x44'));var _0x369856=squel[_0x8194('0x41')]()[_0x8194('0x43')](_0x8194('0x45'),'c')[_0x8194('0x46')]('cm_user_has_contacts','uc',_0x8194('0x47'))[_0x8194('0x46')](_0x8194('0x48'),'ct',_0x8194('0x49'))['left_join']('tools_tags','t',_0x8194('0x4a'))['where'](_0x8194('0x4b'));var _0x4c0350=squel[_0x8194('0x4c')]();var _0x573003=[];var _0x1200c8=squel[_0x8194('0x4c')]();var _0x958766;if(_0x56c512[_0x8194('0x35')]['search']){_0x958766=as[_0x8194('0x4d')](_0x56c512[_0x8194('0x35')][_0x8194('0x4e')]);var _0x4b05ae=_0x958766[_0x8194('0x4f')];for(var _0x200273=0x0;_0x200273<_0x958766[_0x8194('0x50')][_0x8194('0x3b')];_0x200273++){var _0x251d29=_0x958766['conditions'][_0x200273];var _0x27b4cb='c';var _0x51f8d5=_(_0x52d0d2)[_0x8194('0x2e')]()[_0x8194('0x51')](function(_0xeef7db){return _0xeef7db===_0x251d29[_0x8194('0x42')];});if(_0x51f8d5)_0x51f8d5=_0x52d0d2[_0x251d29[_0x8194('0x42')]];if(!_0x51f8d5){if(_0x251d29[_0x8194('0x42')]===_0x8194('0x52')){var _0x4ac75e=_0x251d29[_0x8194('0x53')][_0x8194('0x54')](',')[_0x8194('0x55')](function(_0x98c012){return Number(_0x98c012);});_0x4ac75e[_0x8194('0x56')](function(_0x349e27){_0x1200c8['or'](_0x8194('0x57'),'%,'+_0x349e27+',%');});_0x573003=_[_0x8194('0x58')](_0x573003,_0x4ac75e);}else if(_0x251d29[_0x8194('0x42')]===_0x8194('0x59')){_0x4c0350['and'](_0x8194('0x5a'),_0x251d29[_0x8194('0x53')]);}}else{if(_0x251d29['field']==='dateOfBirth'||_0x51f8d5[_0x8194('0x33')]===_0x8194('0x5b'))_0x251d29[_0x8194('0x5c')]=_0x8194('0x5d');var _0x3f85af=as[_0x8194('0x5e')](_0x27b4cb,_0x51f8d5[_0x8194('0x34')],_0x251d29);_0x4c0350[_0x4b05ae](_0x3f85af[_0x8194('0x5f')],_0x3f85af[_0x8194('0x53')][_0x8194('0x60')],_0x3f85af['value']['end']);}}}else{var _0x510f6d=_(Object['keys'](_0x56c512[_0x8194('0x35')]))[_0x8194('0x55')](function(_0x899688){return _0x52d0d2[_0x8194('0x3c')](_0x899688)?_0x899688:undefined;})[_0x8194('0x61')](function(_0x4631b6){return!_[_0x8194('0x62')](_0x4631b6);})[_0x8194('0x53')]();if(_0x56c512[_0x8194('0x35')]['Contact'])_0x510f6d['push'](_0x8194('0x63'));if(!_[_0x8194('0x64')](_0x510f6d)){_0x510f6d[_0x8194('0x56')](function(_0x250651){if(_0x250651===_0x8194('0x65')){_0x369856[_0x8194('0x66')]('c.ListId\x20IN\x20?',[][_0x8194('0x67')](_0x56c512[_0x8194('0x35')][_0x250651]));}else if(_0x250651===_0x8194('0x63')){var _0x1c02cd='%'+_0x56c512[_0x8194('0x35')][_0x250651]+'%';_0x369856[_0x8194('0x66')](_0x8194('0x68'),_0x1c02cd);}else{_0x369856[_0x8194('0x66')]('c.'+_0x250651+'\x20=\x20?',_0x56c512[_0x8194('0x35')][_0x250651]);}});}if(_0x56c512[_0x8194('0x35')][_0x8194('0x69')]){_0x573003=_[_0x8194('0x6a')](_0x56c512[_0x8194('0x35')][_0x8194('0x69')])?_0x56c512[_0x8194('0x35')][_0x8194('0x69')]:new Array(_0x56c512[_0x8194('0x35')][_0x8194('0x69')]);_0x573003[_0x8194('0x56')](function(_0x52d4ec){_0x1200c8['or'](_0x8194('0x57'),'%,'+_0x52d4ec+',%');});}if(_0x56c512[_0x8194('0x35')][_0x8194('0x61')]){var _0xfaa533=_0x56c512['query']['filter'][_0x8194('0x6b')]('\x5c','\x5c\x5c')[_0x8194('0x6b')](/'/g,'\x27\x27');if(_0xfaa533[_0x8194('0x54')]('\x20')[_0x8194('0x3b')]>0x1){_0x4c0350['or'](_0x8194('0x6c'),qs['getFullTextValue'](_0xfaa533),null);}else{if(qs[_0x8194('0x6d')](_0xfaa533)){_0x4c0350['or'](_0x8194('0x6e'),_0xfaa533+'%');_0x4c0350['or'](_0x8194('0x6f'),_0xfaa533+'%');_0x4c0350['or'](_0x8194('0x70'),_0xfaa533+'%');_0x4c0350['or'](_0x8194('0x71'),_0xfaa533+'%');}else if(qs[_0x8194('0x72')](_0xfaa533)){_0x4c0350['or'](_0x8194('0x73'),_0xfaa533+'%');}else{_0x4c0350['or'](_0x8194('0x74'),'%'+_0xfaa533+'%');_0x4c0350['or'](_0x8194('0x75'),'%'+_0xfaa533+'%');_0x4c0350['or'](_0x8194('0x73'),'%'+_0xfaa533+'%');}}}}_0x369856[_0x8194('0x66')](_0x4c0350);_0x369856[_0x8194('0x76')](_0x8194('0x77'));var _0x545068={'type':db['Sequelize']['QueryTypes'][_0x8194('0x78')],'raw':!![]};var _0x42f541=_0x369856[_0x8194('0x79')]()['field'](_0x8194('0x77'));if(_0x5624a0[_0x8194('0x3e')]){_0x5624a0['order'][_0x8194('0x56')](function(_0x494f0f){_0x369856['order']('c.'+_0x494f0f[0x0],_0x494f0f[0x1]==='DESC'?![]:!![]);});}if(!_['isEmpty'](_0x573003)){_0x369856[_0x8194('0x7a')](_0x1200c8);_0x42f541[_0x8194('0x66')](_0x8194('0x7b'),_0x573003);}BPromise[_0x8194('0x7c')]()['then'](function(){if(!_0x958766)return;if(_0x56c512[_0x8194('0x7d')][_0x8194('0x7e')]!==_0x8194('0x7f'))return;if(!_[_0x8194('0x80')](_0x958766[_0x8194('0x50')],[_0x8194('0x42'),_0x8194('0x59')])){return _0x56c512[_0x8194('0x7d')][_0x8194('0x81')]({'attributes':['id'],'raw':!![]})[_0x8194('0x29')](function(_0x4b4c70){if(_['isEmpty'](_0x4b4c70)){_0x42f541['where'](_0x8194('0x82'));_0x369856[_0x8194('0x66')]('c.ListId\x20IS\x20NULL');}else{_0x42f541[_0x8194('0x66')](_0x8194('0x83'),_['map'](_0x4b4c70,'id'));_0x369856['where'](_0x8194('0x83'),_[_0x8194('0x55')](_0x4b4c70,'id'));}});}})[_0x8194('0x29')](function(){if(_0x56c512[_0x8194('0x7d')][_0x8194('0x7e')]==='agent'&&!_0x958766&&!_0x56c512['query']['ListId'])return[];return db[_0x8194('0x84')][_0x8194('0x35')](_0x42f541[_0x8194('0x85')](),_0x545068);})['then'](function(_0x24b6f9){_0x56b5bc['count']=_0x24b6f9[_0x8194('0x3b')];if(_0x56b5bc[_0x8194('0x22')]===0x0)return[];return db[_0x8194('0x84')]['query'](_0x4aa53a[_0x8194('0x85')](),_0x545068)['then'](function(_0x5e0778){_0x2256d8=_['keyBy'](_0x5e0778,'id');_0x545068=_[_0x8194('0x86')](_0x545068,{'model':db[_0x8194('0x87')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x56c512[_0x8194('0x35')][_0x8194('0x3a')]){_0x5624a0['attributes'][_0x8194('0x56')](function(_0x5a3a29){_0x369856[_0x8194('0x42')]('c.'+_0x5a3a29);});}else{_0x369856[_0x8194('0x42')](_0x8194('0x77'));_0x369856['field']('c.firstName');_0x369856[_0x8194('0x42')](_0x8194('0x88'));_0x369856[_0x8194('0x42')](_0x8194('0x89'));_0x369856[_0x8194('0x42')](_0x8194('0x8a'));_0x369856[_0x8194('0x42')](_0x8194('0x8b'));_0x369856[_0x8194('0x42')](_0x8194('0x8c'));_0x369856[_0x8194('0x42')]('c.ListId');_0x369856['field']('c.createdAt');_0x369856[_0x8194('0x42')](_0x8194('0x8d'));_0x369856[_0x8194('0x42')]('c.CompanyId');_0x369856[_0x8194('0x42')](_0x8194('0x8e'),_0x8194('0x8f'));}if(_0x5624a0['limit'])_0x369856[_0x8194('0x3d')](_0x5624a0[_0x8194('0x3d')]);if(_0x5624a0[_0x8194('0x23')])_0x369856[_0x8194('0x23')](_0x5624a0[_0x8194('0x23')]);return db['sequelize'][_0x8194('0x35')](_0x369856[_0x8194('0x85')](),_0x545068);});})['then'](function(_0x3ee59e){_0x3ee59e['forEach'](function(_0x1a2062){if(_0x1a2062[_0x8194('0x8f')]){_0x1a2062[_0x8194('0x90')]=[];_0x1a2062[_0x8194('0x8f')][_0x8194('0x54')](',')[_0x8194('0x56')](function(_0x29aaa6){_0x1a2062[_0x8194('0x90')]['push'](_0x2256d8[_0x29aaa6]);});}delete _0x1a2062[_0x8194('0x8f')];});_0x56b5bc[_0x8194('0x91')]=_0x3ee59e;return _0x56b5bc;})['then'](respondWithFilteredResult(_0x4af9cc,_0x5624a0));})['catch'](handleError(_0x4af9cc,null));};exports[_0x8194('0x92')]=function(_0x1c92d8,_0x8b3c28){return db[_0x8194('0x87')][_0x8194('0x51')]({'where':{'id':_0x1c92d8['params']['id']}})[_0x8194('0x29')](handleEntityNotFound(_0x8b3c28,null))[_0x8194('0x29')](removeEntity(_0x8b3c28,null))['catch'](handleError(_0x8b3c28,null));};exports[_0x8194('0x2d')]=function(_0x5acb38,_0x345cd7){return db['CmContact'][_0x8194('0x2d')]()[_0x8194('0x29')](function(_0x286d9d){delete _0x286d9d['tags'];for(var _0x55a34d=0x0;_0x55a34d<Object[_0x8194('0x2e')](_0x286d9d)[_0x8194('0x3b')];_0x55a34d++){var _0xe5e303=Object[_0x8194('0x2e')](_0x286d9d)[_0x55a34d];if(!_[_0x8194('0x2f')](_0xe5e303,_0x8194('0x30'))){_0x286d9d[_0xe5e303][_0x8194('0x93')]=_0xe5e303;_0x286d9d[_0xe5e303][_0x8194('0x94')]=_0xe5e303;}}return _0x286d9d;})[_0x8194('0x29')](function(_0x2f5661){var _0x469dfa={'where':{'$or':[{'ListId':_0x5acb38[_0x8194('0x35')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x8194('0x95')][_0x8194('0x96')](_0x469dfa)[_0x8194('0x29')](function(_0x21b389){for(var _0x4dea3d=0x0;_0x4dea3d<_0x21b389[_0x8194('0x3b')];_0x4dea3d++){var _0x2bb3c0='cf_'+_0x21b389[_0x4dea3d]['id'];_0x2f5661[_0x2bb3c0][_0x8194('0x93')]=_0x2bb3c0;_0x2f5661[_0x2bb3c0][_0x8194('0x94')]=_0x21b389[_0x4dea3d][_0x8194('0x97')];_0x2f5661[_0x2bb3c0]['custom']={'type':_0x21b389[_0x4dea3d][_0x8194('0x34')],'values':_0x21b389[_0x4dea3d]['values']};}Object[_0x8194('0x2e')](_0x2f5661)[_0x8194('0x56')](function(_0x14e3bd){if(!_0x2f5661[_0x14e3bd]['hasOwnProperty']('columnName')){delete _0x2f5661[_0x14e3bd];}});return _0x2f5661;});})[_0x8194('0x29')](respondWithResult(_0x345cd7,null))['catch'](handleError(_0x345cd7,null));};exports[_0x8194('0x86')]=function(_0x9b910d,_0x4afaf4){var _0x56244b;var _0x4ea67f;var _0x529a7b;if(_0x9b910d[_0x8194('0x98')]['id']){delete _0x9b910d[_0x8194('0x98')]['id'];}return db[_0x8194('0x87')]['findAll']({'where':{'id':[_0x9b910d[_0x8194('0x98')]['to'],_0x9b910d[_0x8194('0x98')][_0x8194('0x43')]]}})[_0x8194('0x29')](function(_0x849234){if(_0x849234){if(_0x849234['length']!==0x2){return null;}_0x849234[0x0]=_0x849234[0x0][_0x8194('0x99')]({'plain':!![]});_0x849234[0x1]=_0x849234[0x1][_0x8194('0x99')]({'plain':!![]});delete _0x849234[0x0]['id'];delete _0x849234[0x1]['id'];return _[_0x8194('0x9a')](_0x849234[0x0],_0x849234[0x1],function(_0x17f5cf,_0x415d1e){if(Array[_0x8194('0x6a')](_0x415d1e)&&!_0x415d1e['length']){return _0x17f5cf;}else if(!_0x415d1e){return _0x17f5cf;}});}})['then'](handleEntityNotFound(_0x4afaf4,null))[_0x8194('0x29')](function(_0x2169c2){if(_0x2169c2){if(_0x2169c2['tags']&&_['isArray'](_0x2169c2[_0x8194('0x9b')])){_0x2169c2['tags']=_0x2169c2[_0x8194('0x9b')][_0x8194('0x9c')]();}logger[_0x8194('0x9d')](_0x8194('0x9e'),_0x9b910d['body']['to'],_0x9b910d['body'][_0x8194('0x43')]);return db[_0x8194('0x9f')]['destroy']({'where':{'ContactId':[_0x9b910d[_0x8194('0x98')]['to'],_0x9b910d[_0x8194('0x98')][_0x8194('0x43')]]}})['then'](function(_0x12a516){logger['info']('[CmContact][merge][destroy][CmHopper],\x20%s',_0x12a516);return db[_0x8194('0xa0')][_0x8194('0x92')]({'where':{'ContactId':[_0x9b910d[_0x8194('0x98')]['to'],_0x9b910d[_0x8194('0x98')]['from']]}})[_0x8194('0x29')](function(_0x240324){logger[_0x8194('0x9d')]('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x240324);return db[_0x8194('0x87')][_0x8194('0xa1')](_0x2169c2);});});}})[_0x8194('0x29')](function(_0x56bd44){if(_0x56bd44){_0x56244b=_0x56bd44;_0x4ea67f={'ContactId':_0x56244b['id']};_0x529a7b={'where':{'ContactId':[_0x9b910d[_0x8194('0x98')]['to'],_0x9b910d[_0x8194('0x98')]['from']]}};return db[_0x8194('0xa2')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xa3')]['update'](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xa4')]['update'](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xa5')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xa6')]['update'](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db['MailInteraction']['update'](_0x4ea67f,_0x529a7b);}})['then'](function(){if(_0x56244b){return db[_0x8194('0xa6')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xa7')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xa8')]['update'](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xa9')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})['then'](function(){if(_0x56244b){return db[_0x8194('0xaa')]['update'](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db['OpenchannelInteraction'][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})['then'](function(){if(_0x56244b){return db['OpenchannelMessage'][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xab')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db['CmHopperHistory'][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})['then'](function(){if(_0x56244b){return db[_0x8194('0xac')]['update'](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xad')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})['then'](function(){if(_0x56244b){return db['ChatQueueReport']['update'](_0x4ea67f,_0x529a7b);}})['then'](function(){if(_0x56244b){return db[_0x8194('0xae')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})['then'](function(){if(_0x56244b){return db[_0x8194('0xaf')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db['OpenchannelQueueReport'][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})['then'](function(){if(_0x56244b){return db[_0x8194('0xb0')]['update'](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xb1')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xb2')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xb3')]['update'](_0x4ea67f,_0x529a7b);}})['then'](function(){if(_0x56244b){return db[_0x8194('0xb4')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0x87')]['destroy']({'where':{'id':[_0x9b910d[_0x8194('0x98')]['to'],_0x9b910d[_0x8194('0x98')][_0x8194('0x43')]]}});}})['then'](function(){if(_0x56244b){return _0x56244b;}})[_0x8194('0x29')](respondWithResult(_0x4afaf4,null))[_0x8194('0xb5')](handleError(_0x4afaf4,null));};exports[_0x8194('0xa1')]=function(_0x4749e0,_0x5b38cc){return db[_0x8194('0x87')][_0x8194('0x2d')]()[_0x8194('0x29')](function(_0x2d3f75){if(_0x4749e0[_0x8194('0x98')]['tags']&&_[_0x8194('0x6a')](_0x4749e0['body']['tags'])){if(_0x4749e0[_0x8194('0x98')][_0x8194('0x9b')][_0x8194('0x3b')]){_0x4749e0[_0x8194('0x98')][_0x8194('0x9b')]=_0x4749e0[_0x8194('0x98')][_0x8194('0x9b')][_0x8194('0x9c')](';')+';';}else{_0x4749e0['body']['tags']=null;}}else{_0x4749e0['body'][_0x8194('0x9b')]=null;}return db[_0x8194('0x87')][_0x8194('0xa1')](_0x4749e0[_0x8194('0x98')],{'fields':_[_0x8194('0x2e')](_0x2d3f75),'raw':!![]});})['then'](respondWithResult(_0x5b38cc,0xc9))[_0x8194('0xb5')](handleError(_0x5b38cc,null));};exports[_0x8194('0xb6')]=function(_0x17f8b1,_0x29590e){var _0x5174a7=[];var _0x5d388c=0x0;var _0x53296a=0x0;var _0xef8b0e=0x0;return db[_0x8194('0x87')]['describe']()[_0x8194('0x29')](function(_0x32f7bb){return BPromise[_0x8194('0xb7')](_0x17f8b1[_0x8194('0x98')],function(_0x82e7e9){var _0x38bca1={'where':{'$or':[]},'defaults':_0x82e7e9,'fields':_[_0x8194('0x2e')](_0x32f7bb),'raw':!![]};if(_0x82e7e9['duplicates']){for(var _0x475486=0x0;_0x475486<_0x82e7e9[_0x8194('0xb8')][_0x8194('0x3b')];_0x475486++){var _0x27a583={};_0x27a583[_0x82e7e9[_0x8194('0xb8')][_0x475486]]=_0x82e7e9[_0x82e7e9[_0x8194('0xb8')][_0x475486]];_0x38bca1['where'][_0x8194('0xb9')]['push'](_0x27a583);}_0x38bca1['where'][_0x8194('0x65')]=_0x82e7e9[_0x8194('0x65')];}return db[_0x8194('0x87')][_0x8194('0xba')](_0x38bca1)['spread'](function(_0xabdad,_0xff0777){if(_0xff0777){_0x5d388c++;}else{_0xef8b0e++;}})[_0x8194('0xb5')](function(_0x2af28e){console[_0x8194('0xbb')](_0x2af28e);_0x53296a++;});});})['then'](function(_0x22a2ee){if(_0x22a2ee){return{'success':_0x5d388c,'failure':_0x53296a,'duplicates':_0xef8b0e};}})[_0x8194('0x29')](respondWithResult(_0x29590e,0xc9))[_0x8194('0xb5')](handleError(_0x29590e,null));};exports[_0x8194('0xbc')]=function(_0x40f76a,_0x5c8e96,_0x1b41fc){var _0x20edc7;return db[_0x8194('0x87')][_0x8194('0x2d')]()['then'](function(_0x131176){return db[_0x8194('0x87')][_0x8194('0x51')]({'where':{'id':_0x40f76a[_0x8194('0xbd')]['id']},'include':[{'model':db[_0x8194('0x52')],'as':'Tags','attributes':['id','name',_0x8194('0xbe')],'required':_0x40f76a['query'][_0x8194('0x69')]?!![]:![]}],'attributes':_['keys'](_0x131176)});})[_0x8194('0x29')](function(_0x298bfc){_0x20edc7=_0x298bfc[_0x8194('0x99')]({'plain':!![]});var _0x328b06={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x298bfc&&_0x298bfc[_0x8194('0x65')]){if(_0x298bfc[_0x8194('0x65')]){_0x328b06[_0x8194('0x66')][_0x8194('0xbf')]['push']({'ListId':{'$ne':_0x298bfc[_0x8194('0x65')]}});}}return db[_0x8194('0x95')][_0x8194('0x96')](_0x328b06);})[_0x8194('0x29')](function(_0x47c0a6){return _[_0x8194('0xc0')](_0x20edc7,_[_0x8194('0x55')](_0x47c0a6,function(_0x23f8cf){return util[_0x8194('0xc1')](_0x8194('0xc2'),_0x23f8cf['id']);}));})['then'](handleEntityNotFound(_0x5c8e96,null))[_0x8194('0x29')](respondWithResult(_0x5c8e96,null))[_0x8194('0xb5')](handleError(_0x5c8e96,null));};exports[_0x8194('0x28')]=function(_0x352bb4,_0x3af3f8){var _0x19ba7f;if(_0x352bb4[_0x8194('0x98')]['id']){delete _0x352bb4[_0x8194('0x98')]['id'];}return db[_0x8194('0x87')][_0x8194('0x51')]({'where':{'id':_0x352bb4[_0x8194('0xbd')]['id']}})['then'](handleEntityNotFound(_0x3af3f8,null))['then'](saveUpdates(_0x352bb4['body'],null))['then'](function(_0x40371a){_0x19ba7f=_0x40371a;var _0x4e2a1e={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x40371a&&_0x40371a[_0x8194('0x65')]){if(_0x40371a[_0x8194('0x65')]){_0x4e2a1e[_0x8194('0x66')][_0x8194('0xbf')][_0x8194('0x31')]({'ListId':{'$ne':_0x40371a[_0x8194('0x65')]}});}}return db[_0x8194('0x95')]['findAll'](_0x4e2a1e);})[_0x8194('0x29')](function(_0x5a0fd3){if(_0x5a0fd3){return _[_0x8194('0xc0')](_['pickBy'](_0x352bb4['body'],function(_0x5c6101,_0x26726c){return _[_0x8194('0x2f')](_0x26726c,_0x8194('0x30'));}),_[_0x8194('0x55')](_0x5a0fd3,function(_0x136498){return util[_0x8194('0xc1')](_0x8194('0xc2'),_0x136498['id']);}));}})['then'](function(_0x4e5b5d){if(_0x4e5b5d&&!_['isEmpty'](_0x4e5b5d)){var _0x3dc66d=squel['update']()['table'](_0x8194('0x45'))[_0x8194('0xc3')](_0x4e5b5d)[_0x8194('0x66')](_0x8194('0xc4'),_0x352bb4[_0x8194('0xbd')]['id'])[_0x8194('0xc5')]();return db[_0x8194('0x84')][_0x8194('0x35')](_0x3dc66d[_0x8194('0x5f')],{'replacements':_0x3dc66d[_0x8194('0xc6')]});}})[_0x8194('0x29')](function(){if(_0x352bb4[_0x8194('0x98')][_0x8194('0xc7')]&&_0x19ba7f){return db[_0x8194('0x9f')][_0x8194('0x28')]({'phone':_0x352bb4['body']['phone']},{'where':{'ContactId':_0x19ba7f['id']}});}})[_0x8194('0x29')](function(){return _0x19ba7f;})[_0x8194('0x29')](respondWithResult(_0x3af3f8,null))[_0x8194('0xb5')](handleError(_0x3af3f8,null));};exports[_0x8194('0xc8')]=function(_0x19bef0,_0x29d3ac,_0x1dc18d){var _0xa1457d={};var _0x58f083={};var _0x4d8f53;var _0x40aacd;return db[_0x8194('0x87')][_0x8194('0x32')]({'where':{'id':_0x19bef0[_0x8194('0xbd')]['id']}})[_0x8194('0x29')](handleEntityNotFound(_0x29d3ac,null))[_0x8194('0x29')](function(_0x5bfddb){if(_0x5bfddb){_0x4d8f53=_0x5bfddb;_0x58f083[_0x8194('0x39')]=_[_0x8194('0x2e')](db[_0x8194('0x52')][_0x8194('0xc9')]);_0x58f083[_0x8194('0x35')]=_[_0x8194('0x2e')](_0x19bef0[_0x8194('0x35')]);_0x58f083['filters']=_[_0x8194('0x37')](_0x58f083['model'],_0x58f083[_0x8194('0x35')]);_0xa1457d[_0x8194('0x38')]=_[_0x8194('0x37')](_0x58f083['model'],qs['fields'](_0x19bef0[_0x8194('0x35')][_0x8194('0x3a')]));_0xa1457d[_0x8194('0x38')]=_0xa1457d['attributes'][_0x8194('0x3b')]?_0xa1457d['attributes']:_0x58f083[_0x8194('0x39')];_0xa1457d[_0x8194('0x3e')]=qs[_0x8194('0x3f')](_0x19bef0[_0x8194('0x35')]['sort']);_0xa1457d[_0x8194('0x66')]=qs['filters'](_[_0x8194('0x40')](_0x19bef0['query'],_0x58f083[_0x8194('0x36')]));if(_0x19bef0[_0x8194('0x35')][_0x8194('0x61')]){_0xa1457d[_0x8194('0x66')]=_[_0x8194('0x86')](_0xa1457d[_0x8194('0x66')],{'$or':_['map'](_0xa1457d[_0x8194('0x38')],function(_0xf53e74){var _0x659183={};_0x659183[_0xf53e74]={'$like':'%'+_0x19bef0['query'][_0x8194('0x61')]+'%'};return _0x659183;})});}_0xa1457d=_[_0x8194('0x86')]({},_0xa1457d,_0x19bef0[_0x8194('0xca')]);return _0x4d8f53[_0x8194('0xc8')](_0xa1457d);}})[_0x8194('0x29')](function(_0x163d66){if(_0x163d66){_0x40aacd=_0x163d66[_0x8194('0x3b')];if(!_0x19bef0[_0x8194('0x35')][_0x8194('0x3c')](_0x8194('0xcb'))){_0xa1457d[_0x8194('0x3d')]=qs[_0x8194('0x3d')](_0x19bef0[_0x8194('0x35')][_0x8194('0x3d')]);_0xa1457d[_0x8194('0x23')]=qs['offset'](_0x19bef0['query']['offset']);}return _0x4d8f53[_0x8194('0xc8')](_0xa1457d);}})[_0x8194('0x29')](function(_0x13a5c3){if(_0x13a5c3){return _0x13a5c3?{'count':_0x40aacd,'rows':_0x13a5c3}:null;}})['then'](respondWithResult(_0x29d3ac,null))['catch'](handleError(_0x29d3ac,null));};exports[_0x8194('0xcc')]=function(_0x4852c1,_0x1dba1c,_0x47b273){if(_0x4852c1[_0x8194('0x98')]['id']){delete _0x4852c1['body']['id'];}return db[_0x8194('0x87')][_0x8194('0x32')]({'where':{'id':_0x4852c1[_0x8194('0xbd')]['id']}})[_0x8194('0x29')](handleEntityNotFound(_0x1dba1c,null))[_0x8194('0x29')](function(_0x2f77ea){if(_0x2f77ea){return _0x2f77ea[_0x8194('0xcc')](_0x4852c1[_0x8194('0x98')]['ids']||[]);}return null;})[_0x8194('0x29')](respondWithResult(_0x1dba1c,null))[_0x8194('0xb5')](handleError(_0x1dba1c,null));};exports[_0x8194('0xcd')]=function(_0xf317a0,_0x51825d,_0x35532a){var _0x48558e={'raw':![],'where':{}};var _0x1c4647={};var _0x109f4a={'count':0x0,'rows':[]};return db[_0x8194('0x87')][_0x8194('0x32')]({'where':{'id':_0xf317a0[_0x8194('0xbd')]['id']}})[_0x8194('0x29')](handleEntityNotFound(_0x51825d,null))['then'](function(_0x575612){if(_0x575612){_0x1c4647[_0x8194('0x39')]=_['keys'](db[_0x8194('0x9f')][_0x8194('0xc9')]);_0x1c4647[_0x8194('0x35')]=_[_0x8194('0x2e')](_0xf317a0[_0x8194('0x35')]);_0x1c4647[_0x8194('0x36')]=_[_0x8194('0x37')](_0x1c4647[_0x8194('0x39')],_0x1c4647[_0x8194('0x35')]);_0x48558e[_0x8194('0x38')]=_[_0x8194('0x37')](_0x1c4647['model'],qs['fields'](_0xf317a0[_0x8194('0x35')][_0x8194('0x3a')]));_0x48558e['attributes']=_0x48558e[_0x8194('0x38')][_0x8194('0x3b')]?_0x48558e['attributes']:_0x1c4647[_0x8194('0x39')];if(!_0xf317a0[_0x8194('0x35')]['hasOwnProperty'](_0x8194('0xcb'))){_0x48558e[_0x8194('0x3d')]=qs[_0x8194('0x3d')](_0xf317a0[_0x8194('0x35')][_0x8194('0x3d')]);_0x48558e[_0x8194('0x23')]=qs[_0x8194('0x23')](_0xf317a0[_0x8194('0x35')][_0x8194('0x23')]);}_0x48558e[_0x8194('0x3e')]=qs['sort'](_0xf317a0['query'][_0x8194('0x3f')]);_0x48558e['where']=qs[_0x8194('0x36')](_[_0x8194('0x40')](_0xf317a0[_0x8194('0x35')],_0x1c4647[_0x8194('0x36')]));_0x48558e[_0x8194('0x66')][_0x8194('0xce')]=_0x575612['id'];if(_0xf317a0[_0x8194('0x35')]['filter']){_0x48558e['where']=_[_0x8194('0x86')](_0x48558e['where'],{'$or':_['map'](_0x48558e['attributes'],function(_0x265629){var _0x4881f5={};_0x4881f5[_0x265629]={'$like':'%'+_0xf317a0[_0x8194('0x35')][_0x8194('0x61')]+'%'};return _0x4881f5;})});}_0x48558e=_[_0x8194('0x86')]({},_0x48558e,_0xf317a0['options']);return db[_0x8194('0x9f')][_0x8194('0x22')]({'where':_0x48558e[_0x8194('0x66')]})['then'](function(_0xa1a2d5){_0x109f4a['count']=_0xa1a2d5;if(_0xf317a0[_0x8194('0x35')]['includeAll']){_0x48558e['include']=[{'all':!![]}];}return db['CmHopper']['findAll'](_0x48558e);})[_0x8194('0x29')](function(_0x1c8473){_0x109f4a[_0x8194('0x91')]=_0x1c8473;return _0x109f4a;});}})[_0x8194('0x29')](respondWithFilteredResult(_0x51825d,_0x48558e))[_0x8194('0xb5')](handleError(_0x51825d,null));};exports[_0x8194('0xcf')]=function(_0x9c7419,_0x818812,_0x554c28){var _0x43f2ff={'raw':!![],'where':{}};var _0x47f38e={};var _0x227854={'count':0x0,'rows':[]};return db['CmContact'][_0x8194('0x32')]({'where':{'id':_0x9c7419[_0x8194('0xbd')]['id']}})[_0x8194('0x29')](handleEntityNotFound(_0x818812,null))[_0x8194('0x29')](function(_0x130d94){if(_0x130d94){_0x47f38e[_0x8194('0x39')]=_[_0x8194('0x2e')](db[_0x8194('0xd0')][_0x8194('0xc9')]);_0x47f38e[_0x8194('0x35')]=_['keys'](_0x9c7419[_0x8194('0x35')]);_0x47f38e[_0x8194('0x36')]=_['intersection'](_0x47f38e[_0x8194('0x39')],_0x47f38e[_0x8194('0x35')]);_0x43f2ff['attributes']=_[_0x8194('0x37')](_0x47f38e['model'],qs[_0x8194('0x3a')](_0x9c7419[_0x8194('0x35')][_0x8194('0x3a')]));_0x43f2ff[_0x8194('0x38')]=_0x43f2ff[_0x8194('0x38')][_0x8194('0x3b')]?_0x43f2ff['attributes']:_0x47f38e[_0x8194('0x39')];if(!_0x9c7419[_0x8194('0x35')]['hasOwnProperty']('nolimit')){_0x43f2ff[_0x8194('0x3d')]=qs[_0x8194('0x3d')](_0x9c7419[_0x8194('0x35')]['limit']);_0x43f2ff['offset']=qs[_0x8194('0x23')](_0x9c7419[_0x8194('0x35')][_0x8194('0x23')]);}_0x43f2ff['order']=qs[_0x8194('0x3f')](_0x9c7419[_0x8194('0x35')][_0x8194('0x3f')]);_0x43f2ff[_0x8194('0x66')]=qs[_0x8194('0x36')](_['pick'](_0x9c7419[_0x8194('0x35')],_0x47f38e['filters']));_0x43f2ff['where']['ContactId']=_0x130d94['id'];if(_0x9c7419['query'][_0x8194('0x61')]){_0x43f2ff[_0x8194('0x66')]=_[_0x8194('0x86')](_0x43f2ff[_0x8194('0x66')],{'$or':_[_0x8194('0x55')](_0x43f2ff[_0x8194('0x38')],function(_0xff419b){var _0x3d4b3f={};_0x3d4b3f[_0xff419b]={'$like':'%'+_0x9c7419[_0x8194('0x35')][_0x8194('0x61')]+'%'};return _0x3d4b3f;})});}_0x43f2ff=_['merge']({},_0x43f2ff,_0x9c7419[_0x8194('0xca')]);return db[_0x8194('0xd0')][_0x8194('0x22')]({'where':_0x43f2ff[_0x8194('0x66')]})['then'](function(_0x274e85){_0x227854[_0x8194('0x22')]=_0x274e85;if(_0x9c7419['query'][_0x8194('0xd1')]){_0x43f2ff[_0x8194('0xd2')]=[{'all':!![]}];}return db['CmHopperHistory'][_0x8194('0x96')](_0x43f2ff);})['then'](function(_0x2d595a){_0x227854['rows']=_0x2d595a;return _0x227854;});}})[_0x8194('0x29')](respondWithFilteredResult(_0x818812,_0x43f2ff))[_0x8194('0xb5')](handleError(_0x818812,null));};exports[_0x8194('0xd3')]=function(_0xa9c437,_0x30bd35,_0x496530){var _0xd283f4={'raw':!![],'where':{}};var _0x21d63c={};var _0x5cac6d={'count':0x0,'rows':[]};return db[_0x8194('0x87')][_0x8194('0x32')]({'where':{'id':_0xa9c437['params']['id']}})[_0x8194('0x29')](handleEntityNotFound(_0x30bd35,null))[_0x8194('0x29')](function(_0x500029){if(_0x500029){_0x21d63c['model']=_[_0x8194('0x2e')](db[_0x8194('0xab')][_0x8194('0xc9')]);_0x21d63c[_0x8194('0x35')]=_['keys'](_0xa9c437[_0x8194('0x35')]);_0x21d63c[_0x8194('0x36')]=_[_0x8194('0x37')](_0x21d63c[_0x8194('0x39')],_0x21d63c[_0x8194('0x35')]);_0xd283f4[_0x8194('0x38')]=_[_0x8194('0x37')](_0x21d63c[_0x8194('0x39')],qs['fields'](_0xa9c437[_0x8194('0x35')][_0x8194('0x3a')]));_0xd283f4[_0x8194('0x38')]=_0xd283f4['attributes']['length']?_0xd283f4[_0x8194('0x38')]:_0x21d63c[_0x8194('0x39')];if(!_0xa9c437[_0x8194('0x35')][_0x8194('0x3c')]('nolimit')){_0xd283f4[_0x8194('0x3d')]=qs[_0x8194('0x3d')](_0xa9c437[_0x8194('0x35')][_0x8194('0x3d')]);_0xd283f4[_0x8194('0x23')]=qs[_0x8194('0x23')](_0xa9c437[_0x8194('0x35')][_0x8194('0x23')]);}_0xd283f4[_0x8194('0x3e')]=qs[_0x8194('0x3f')](_0xa9c437[_0x8194('0x35')][_0x8194('0x3f')]);_0xd283f4[_0x8194('0x66')]=qs[_0x8194('0x36')](_[_0x8194('0x40')](_0xa9c437['query'],_0x21d63c[_0x8194('0x36')]));_0xd283f4['where'][_0x8194('0xce')]=_0x500029['id'];if(_0xa9c437[_0x8194('0x35')][_0x8194('0x61')]){_0xd283f4['where']=_[_0x8194('0x86')](_0xd283f4[_0x8194('0x66')],{'$or':_[_0x8194('0x55')](_0xd283f4['attributes'],function(_0x5e46b9){var _0x426fc9={};_0x426fc9[_0x5e46b9]={'$like':'%'+_0xa9c437[_0x8194('0x35')][_0x8194('0x61')]+'%'};return _0x426fc9;})});}_0xd283f4=_['merge']({},_0xd283f4,_0xa9c437[_0x8194('0xca')]);return db[_0x8194('0xab')][_0x8194('0x22')]({'where':_0xd283f4['where']})['then'](function(_0x390a32){_0x5cac6d[_0x8194('0x22')]=_0x390a32;if(_0xa9c437['query'][_0x8194('0xd1')]){_0xd283f4[_0x8194('0xd2')]=[{'all':!![]}];}return db['CmHopperFinal'][_0x8194('0x96')](_0xd283f4);})[_0x8194('0x29')](function(_0x2042f3){_0x5cac6d[_0x8194('0x91')]=_0x2042f3;return _0x5cac6d;});}})[_0x8194('0x29')](respondWithFilteredResult(_0x30bd35,_0xd283f4))[_0x8194('0xb5')](handleError(_0x30bd35,null));};exports[_0x8194('0xd4')]=function(_0xc048ad,_0x525358,_0x416c77){var _0x2270af={'raw':!![],'where':{}};var _0x9637ea={};var _0x3e7311={'count':0x0,'rows':[]};return db[_0x8194('0x87')]['findOne']({'where':{'id':_0xc048ad[_0x8194('0xbd')]['id']}})[_0x8194('0x29')](handleEntityNotFound(_0x525358,null))[_0x8194('0x29')](function(_0x38109e){if(_0x38109e){_0x9637ea[_0x8194('0x39')]=_['keys'](db[_0x8194('0xb1')][_0x8194('0xc9')]);_0x9637ea[_0x8194('0x35')]=_['keys'](_0xc048ad[_0x8194('0x35')]);_0x9637ea[_0x8194('0x36')]=_[_0x8194('0x37')](_0x9637ea[_0x8194('0x39')],_0x9637ea[_0x8194('0x35')]);_0x2270af[_0x8194('0x38')]=_[_0x8194('0x37')](_0x9637ea['model'],qs['fields'](_0xc048ad['query']['fields']));_0x2270af['attributes']=_0x2270af[_0x8194('0x38')][_0x8194('0x3b')]?_0x2270af[_0x8194('0x38')]:_0x9637ea[_0x8194('0x39')];if(!_0xc048ad[_0x8194('0x35')][_0x8194('0x3c')]('nolimit')){_0x2270af[_0x8194('0x3d')]=qs[_0x8194('0x3d')](_0xc048ad[_0x8194('0x35')]['limit']);_0x2270af[_0x8194('0x23')]=qs[_0x8194('0x23')](_0xc048ad[_0x8194('0x35')][_0x8194('0x23')]);}_0x2270af[_0x8194('0x3e')]=qs[_0x8194('0x3f')](_0xc048ad[_0x8194('0x35')]['sort']);_0x2270af[_0x8194('0x66')]=qs[_0x8194('0x36')](_['pick'](_0xc048ad[_0x8194('0x35')],_0x9637ea[_0x8194('0x36')]));_0x2270af['where'][_0x8194('0xce')]=_0x38109e['id'];if(_0xc048ad[_0x8194('0x35')][_0x8194('0x61')]){_0x2270af[_0x8194('0x66')]=_['merge'](_0x2270af[_0x8194('0x66')],{'$or':_[_0x8194('0x55')](_0x2270af[_0x8194('0x38')],function(_0x5218be){var _0x6a0670={};_0x6a0670[_0x5218be]={'$like':'%'+_0xc048ad['query']['filter']+'%'};return _0x6a0670;})});}_0x2270af=_['merge']({},_0x2270af,_0xc048ad[_0x8194('0xca')]);return db[_0x8194('0xb1')][_0x8194('0x22')]({'where':_0x2270af[_0x8194('0x66')]})['then'](function(_0x2715b1){_0x3e7311[_0x8194('0x22')]=_0x2715b1;if(_0xc048ad[_0x8194('0x35')][_0x8194('0xd1')]){_0x2270af[_0x8194('0xd2')]=[{'all':!![]}];}return db[_0x8194('0xb1')]['findAll'](_0x2270af);})[_0x8194('0x29')](function(_0x40e596){_0x3e7311[_0x8194('0x91')]=_0x40e596;return _0x3e7311;});}})[_0x8194('0x29')](respondWithFilteredResult(_0x525358,_0x2270af))['catch'](handleError(_0x525358,null));};exports[_0x8194('0xd5')]=function(_0x3f8cd8,_0x192c75,_0x1d0141){try{if(!_0x3f8cd8[_0x8194('0x98')]['ListId']){throw new Error(_0x8194('0xd6'));}if(!_0x3f8cd8[_0x8194('0x98')][_0x8194('0xd7')]){throw new Error(_0x8194('0xd8'));}if(!_0x3f8cd8[_0x8194('0x98')][_0x8194('0xd9')]){throw new Error(_0x8194('0xda'));}if(!_0x3f8cd8['body']['socket_timestamp']){throw new Error(_0x8194('0xdb'));}var _0x418ad5=_0x3f8cd8[_0x8194('0x98')][_0x8194('0xd7')]['split'](',');var _0x508350=_0x3f8cd8[_0x8194('0x98')][_0x8194('0xd9')]['split'](',');if(!_0x418ad5[_0x8194('0x3b')]||!_0x508350['length']||_0x418ad5[_0x8194('0x3b')]!==_0x508350[_0x8194('0x3b')]){throw new Error(_0x8194('0xdc'));}_0x3f8cd8['body'][_0x8194('0x3a')]=_[_0x8194('0xdd')](_0x418ad5,_0x508350);if(!_0x3f8cd8[_0x8194('0x98')][_0x8194('0x3a')]['phone']){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x3f8cd8[_0x8194('0x98')][_0x8194('0x3a')][_0x8194('0xde')]){throw new Error(_0x8194('0xdf'));}var _0x279f67=path[_0x8194('0x9c')](config[_0x8194('0xe0')],_0x8194('0xe1'),_0x3f8cd8[_0x8194('0xe2')][_0x8194('0xe3')]);fs['chmodSync'](_0x279f67,parseInt(_0x8194('0xe4'),0x8));var _0x5e15cf=require('child_process')[_0x8194('0xe5')](path[_0x8194('0x9c')](__dirname,_0x8194('0xe6')),[_0x279f67,_0x3f8cd8[_0x8194('0x98')][_0x8194('0xd7')],_0x3f8cd8[_0x8194('0x98')]['binding_values'],_0x3f8cd8[_0x8194('0x98')][_0x8194('0x65')],_0x3f8cd8[_0x8194('0x98')][_0x8194('0xe7')],_0x3f8cd8['body'][_0x8194('0xb8')],_0x3f8cd8[_0x8194('0x98')][_0x8194('0xe8')]]);return _0x192c75['status'](0xc8)[_0x8194('0x25')]({'message':_0x8194('0xe9'),'pid':_0x5e15cf[_0x8194('0xea')]});}catch(_0x33eca2){return _0x192c75[_0x8194('0x20')](0x1f4)[_0x8194('0x2b')](_0x33eca2);}};exports[_0x8194('0xeb')]=function(_0x24925a,_0x10192c,_0xd59e4a){var _0x2d8b56=fs[_0x8194('0xec')](_0x24925a['file'][_0x8194('0x9')]);Papa['parse'](_0x2d8b56,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x1e0c77){return _0x10192c['status'](0xc8)[_0x8194('0x25')]({'file':_0x24925a[_0x8194('0xe2')],'fields':_0x1e0c77[_0x8194('0xed')][_0x8194('0x3a')]});}});};exports[_0x8194('0xee')]=function(_0x59212f,_0x43e9e,_0x47bb92){return db['User'][_0x8194('0x96')]({'raw':!![],'attributes':['id'],'where':{'role':_0x8194('0x7f')}})[_0x8194('0x29')](function(_0x41700c){var _0x4138f3=![];if(!_0x59212f[_0x8194('0x98')]['ListId']){throw new Error(_0x8194('0xd6'));}if(!_0x59212f[_0x8194('0x98')][_0x8194('0xef')][_0x8194('0xc7')]){throw new Error(_0x8194('0xf0'));}if(!_0x59212f[_0x8194('0x98')][_0x8194('0xef')][_0x8194('0xde')]){throw new Error(_0x8194('0xdf'));}if(!_0x59212f[_0x8194('0x98')][_0x8194('0xe8')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x47b2ef=require(_0x8194('0xf1'))['fork'](path['join'](__dirname,_0x8194('0xf2')),[_0x59212f[_0x8194('0xbd')]['id'],JSON[_0x8194('0xf3')](_0x59212f['body']),JSON[_0x8194('0xf3')](_0x41700c)]);_0x47b2ef['on'](_0x8194('0xf4'),function(_0x13fc69){_0x4138f3=!![];return _0x43e9e['status'](0xc8)['json']({'message':_0x8194('0xf5'),'pid':_0x47b2ef[_0x8194('0xea')]});});_0x47b2ef['on'](_0x8194('0xf6'),function(_0x3bb151){if(_0x3bb151&&!_0x4138f3){return _0x43e9e[_0x8194('0x20')](0x1f4)[_0x8194('0x25')]({'message':'error\x20child\x20process','pid':_0x47b2ef[_0x8194('0xea')]});}});})[_0x8194('0xb5')](handleError(_0x43e9e,null));};exports[_0x8194('0xf7')]=function(_0x1de77a,_0x2e4819){var _0x1e1027=[_0x8194('0xf8'),_0x8194('0xf9'),'sms','openchannel',_0x8194('0xfa'),_0x8194('0xfb'),'voice'];var _0x4e627a={'offset':0x0,'order':qs['sort'](_0x8194('0xfc'))},_0x13b4e1={'count':0x0,'rows':[]};Promise[_0x8194('0x7c')]()['then'](function(){if(_0x1de77a[_0x8194('0x35')][_0x8194('0xfd')]){if(!_[_0x8194('0xfe')](_0x1e1027,_0x1de77a[_0x8194('0x35')][_0x8194('0xfd')][_0x8194('0xff')]())){throw new Error(_0x8194('0x100'));}_0x1e1027=[_0x1de77a['query'][_0x8194('0xfd')][_0x8194('0xff')]()];}if(_0x1de77a[_0x8194('0x35')][_0x8194('0x101')]){try{var _0xc62327=JSON[_0x8194('0x102')](_0x1de77a[_0x8194('0x35')]['range']);if(!moment(_0xc62327[_0x8194('0x43')])[_0x8194('0x103')]()){throw new Error(_0x8194('0x104'));}if(!moment(_0xc62327['to'])['isValid']()){throw new Error('Invalid\x20date\x20for\x20range\x20to\x20filter');}}catch(_0x4b20e8){throw new Error(_0x8194('0x105'));}}if(!_0x1de77a['query']['hasOwnProperty']('nolimit')){_0x4e627a[_0x8194('0x3d')]=qs[_0x8194('0x3d')](_0x1de77a[_0x8194('0x35')][_0x8194('0x3d')]||0xa);_0x4e627a[_0x8194('0x23')]=qs['offset'](_0x1de77a[_0x8194('0x35')][_0x8194('0x23')]);}var _0x21b3ac=_0x1e1027['map'](function(_0x73c02b){if(_0x73c02b==='voice'){var _0x3c7faa={'attributes':['id',_0x8194('0x106'),'type','source',_0x8194('0x107'),'callerid','starttime',_0x8194('0x108'),_0x8194('0x109'),_0x8194('0x10a'),_0x8194('0x10b'),_0x8194('0x10c'),_0x8194('0x10d'),'userThirdDisposition'],'where':{'ContactId':_0x1de77a[_0x8194('0xbd')]['id']},'include':[{'model':db['User'],'as':_0x8194('0x59'),'attributes':['id','name','fullname','alias']}],'order':[[_0x8194('0x10b'),_0x8194('0x10e')]]};if(_0x1de77a[_0x8194('0x35')][_0x8194('0x101')]){_0x3c7faa[_0x8194('0x66')]['createdAt']={'$gte':_0xc62327[_0x8194('0x43')],'$lte':_0xc62327['to']};}return db[_0x8194('0xad')][_0x8194('0x10f')](_0x3c7faa)[_0x8194('0x29')](function(_0x41e3f2){_0x13b4e1[_0x8194('0x22')]+=_0x41e3f2['count'];return _[_0x8194('0x55')](_0x41e3f2[_0x8194('0x91')],function(_0x3033a3){var _0x4873fe=_0x3033a3[_0x8194('0x99')]({'plain':!![]});_0x4873fe[_0x8194('0xfd')]=_0x73c02b;if(_0x4873fe[_0x8194('0x59')]){_0x4873fe[_0x8194('0x59')]={'id':_0x4873fe[_0x8194('0x59')]['id'],'name':_0x4873fe[_0x8194('0x59')][_0x8194('0x2a')],'fullname':_0x4873fe['User'][_0x8194('0x110')],'alias':_0x4873fe['User'][_0x8194('0x97')]};}return _0x4873fe;});});}else{var _0x4280fe=_[_0x8194('0x111')](_0x73c02b)+(_0x73c02b===_0x8194('0xf9')?_0x8194('0x112'):_0x8194('0x113'));var _0x323a22={'attributes':['id',_0x8194('0x114'),_0x8194('0x115'),'createdAt',_0x8194('0x10a'),'disposition',_0x8194('0x116'),_0x8194('0x117'),_0x8194('0x118'),_0x4280fe+'Id'],'where':{'ContactId':_0x1de77a[_0x8194('0xbd')]['id']},'include':[{'model':db[_0x4280fe],'as':_0x8194('0x113'),'attributes':['id','name','key']},{'model':db[_0x8194('0x59')],'as':_0x8194('0x119'),'attributes':['id','name',_0x8194('0x110')]},{'model':db['Tag'],'as':_0x8194('0x90'),'attributes':['id',_0x8194('0x2a'),_0x8194('0xbe')],'through':{'attributes':[]}}],'order':[[_0x8194('0x10b'),_0x8194('0x10e')]]};if(_0x1de77a['query'][_0x8194('0x101')]){_0x323a22[_0x8194('0x66')][_0x8194('0x10b')]={'$gte':_0xc62327[_0x8194('0x43')],'$lte':_0xc62327['to']};}switch(_0x73c02b){case _0x8194('0xf9'):_0x323a22[_0x8194('0x38')][_0x8194('0x31')](_0x8194('0x11a'),'customerIp',_0x8194('0x11b'),_0x8194('0x11c'),_0x8194('0x11d'),_0x8194('0x11e'),_0x8194('0x11f'),_0x8194('0x120'),_0x8194('0x121'));break;case _0x8194('0xf8'):_0x323a22[_0x8194('0x38')][_0x8194('0x31')]('subject',_0x8194('0x122'));break;case'openchannel':_0x323a22[_0x8194('0x38')]['push']('externalUrl',_0x8194('0x123'));break;}return db[_[_0x8194('0x111')](_0x73c02b)+_0x8194('0x124')]['findAndCountAll'](_0x323a22)[_0x8194('0x29')](function(_0x1a23fd){_0x13b4e1['count']+=_0x1a23fd[_0x8194('0x22')];return _[_0x8194('0x55')](_0x1a23fd[_0x8194('0x91')],function(_0x5743ee){var _0x36c7a9=_0x5743ee['get']({'plain':!![]});_0x36c7a9[_0x8194('0xfd')]=_0x73c02b;if(_0x36c7a9[_0x8194('0x119')]){_0x36c7a9[_0x8194('0x119')]={'id':_0x36c7a9[_0x8194('0x119')]['id'],'name':_0x36c7a9[_0x8194('0x119')][_0x8194('0x2a')],'fullname':_0x36c7a9[_0x8194('0x119')][_0x8194('0x110')]};}return _0x36c7a9;});});}});return Promise[_0x8194('0x125')](_0x21b3ac);})['then'](function(_0x1dbfb8){return _(_0x1dbfb8)[_0x8194('0x126')]()[_0x8194('0x127')](_0x8194('0x10b'))[_0x8194('0x128')]()[_0x8194('0x53')]();})['then'](function(_0x37a0b1){_0x13b4e1['rows']=_0x4e627a['limit']?_0x37a0b1['slice'](_0x4e627a[_0x8194('0x23')],_0x4e627a[_0x8194('0x23')]+_0x4e627a[_0x8194('0x3d')]):_0x37a0b1;return _0x13b4e1;})[_0x8194('0x29')](respondWithFilteredResult(_0x2e4819,_0x4e627a))[_0x8194('0xb5')](handleError(_0x2e4819,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff