// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x1cfc=['phone','getTags','rawAttributes','pick','nolimit','ids','ContactId','includeAll','include','getHopperHistories','CmHopperHistory','options','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','firstName','root','server/files/tmp','file','filename','chmodSync','0777','child_process','fork','../../components/import/cm/csv','CompanyId','pid','upload','createReadStream','parse','import','binding','No\x20firstName\x20column\x20specified','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','exit','error\x20child\x20process','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','to-csv','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','redis','localhost','./cmContact.socket','register','sendStatus','status','offset','set','json','apply','reject','save','update','then','end','error','stack','name','send','describe','keys','startsWith','cf_','push','CmCustomField','findOne','trimStart','all','length','type','model','query','filters','intersection','attributes','fields','hasOwnProperty','limit','order','sort','field','from','tools_tags','select','cm_contacts','cm_user_has_contacts','cm_contact_has_tags','ct.CmContactId\x20=\x20c.id','left_join','t.id\x20=\x20ct.TagId','c.deletedAt\x20IS\x20NULL','expr','search','parseSearch','sqlOperator','conditions','find','Tag','value','split','map','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','User','and','uc.UserId\x20=\x20?','dateOfBirth','fieldType','castTo','buildExpression','text','filter','isNil','Contact','ListId','where','c.ListId\x20IN\x20?','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','tag','replace','getFullTextValue','c.phone\x20LIKE\x20?','c.fax\x20LIKE\x20?','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?','group','c.id','Sequelize','QueryTypes','SELECT','clone','DESC','having','t.id\x20IN\x20?','resolve','user','role','agent','some','getLists','isEmpty','c.ListId\x20IS\x20NULL','sequelize','toString','count','keyBy','merge','CmContact','c.firstName','c.phone','c.mobile','c.email','c.ListId','c.createdAt','c.deletedAt','c.CompanyId','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','Tags','rows','catch','destroy','tags','findAll','columnName','displayName','alias','custom','values','body','get','mergeWith','isArray','join','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','info','[CmContact][merge][destroy][CmHopper],\x20%s','[CmContact][merge][destroy][CmHopperBlack],\x20%s','ChatInteraction','ChatMessage','ChatOfflineMessage','MailMessage','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','ReportAgentPreview','VoiceCallReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','create','bulkCreate','each','duplicates','$or','findOrCreate','show','params','color','$and','format','cf_%d','setFields','id\x20=\x20?','toParam'];(function(_0x58dc25,_0x49b9d5){var _0x21b0a7=function(_0x38a186){while(--_0x38a186){_0x58dc25['push'](_0x58dc25['shift']());}};_0x21b0a7(++_0x49b9d5);}(_0x1cfc,0x122));var _0xc1cf=function(_0x4fb164,_0x4c4cf5){_0x4fb164=_0x4fb164-0x0;var _0x12a90e=_0x1cfc[_0x4fb164];return _0x12a90e;};'use strict';var pdf=require(_0xc1cf('0x0'));var emlformat=require(_0xc1cf('0x1'));var rimraf=require(_0xc1cf('0x2'));var zipdir=require(_0xc1cf('0x3'));var jsonpatch=require(_0xc1cf('0x4'));var rp=require(_0xc1cf('0x5'));var moment=require(_0xc1cf('0x6'));var BPromise=require(_0xc1cf('0x7'));var Mustache=require('mustache');var util=require(_0xc1cf('0x8'));var path=require(_0xc1cf('0x9'));var sox=require('sox');var csv=require(_0xc1cf('0xa'));var ejs=require('ejs');var fs=require('fs');var _=require('lodash');var squel=require('squel');var crypto=require(_0xc1cf('0xb'));var jsforce=require(_0xc1cf('0xc'));var deskjs=require(_0xc1cf('0xd'));var toCsv=require(_0xc1cf('0xa'));var querystring=require(_0xc1cf('0xe'));var Papa=require(_0xc1cf('0xf'));var Redis=require(_0xc1cf('0x10'));var authService=require(_0xc1cf('0x11'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xc1cf('0x12'));var logger=require(_0xc1cf('0x13'))(_0xc1cf('0x14'));var utils=require('../../config/utils');var config=require(_0xc1cf('0x15'));var licenseUtil=require(_0xc1cf('0x16'));var db=require(_0xc1cf('0x17'))['db'];config[_0xc1cf('0x18')]=_['defaults'](config['redis'],{'host':_0xc1cf('0x19'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0xc1cf('0x18')]));require(_0xc1cf('0x1a'))[_0xc1cf('0x1b')](socket);function respondWithStatusCode(_0x2b6ace,_0x37d70d){_0x37d70d=_0x37d70d||0xcc;return function(_0x50dc9a){if(_0x50dc9a){return _0x2b6ace[_0xc1cf('0x1c')](_0x37d70d);}return _0x2b6ace['status'](_0x37d70d)['end']();};}function respondWithResult(_0x4ba3d9,_0x1d12dc){_0x1d12dc=_0x1d12dc||0xc8;return function(_0x207c48){if(_0x207c48){return _0x4ba3d9[_0xc1cf('0x1d')](_0x1d12dc)['json'](_0x207c48);}};}function respondWithFilteredResult(_0x41445a,_0x2e98e6){return function(_0x229ab8){if(_0x229ab8){var _0x1817eb=_0x229ab8['count'],_0x2bf5f9=_0x2e98e6[_0xc1cf('0x1e')],_0x5cc195=_0x2e98e6[_0xc1cf('0x1e')]+_0x2e98e6['limit'],_0x10712a;if(_0x5cc195>=_0x1817eb){_0x5cc195=_0x1817eb;_0x10712a=0xc8;}else{_0x10712a=0xce;}_0x41445a['status'](_0x10712a);return _0x41445a[_0xc1cf('0x1f')]('Content-Range',_0x2bf5f9+'-'+_0x5cc195+'/'+_0x1817eb)[_0xc1cf('0x20')](_0x229ab8);}return null;};}function patchUpdates(_0x2c91bb){return function(_0x1e37fc){try{jsonpatch[_0xc1cf('0x21')](_0x1e37fc,_0x2c91bb,!![]);}catch(_0xbfe869){return BPromise[_0xc1cf('0x22')](_0xbfe869);}return _0x1e37fc[_0xc1cf('0x23')]();};}function saveUpdates(_0xfe8a0e,_0x20ef6d){return function(_0x25adbd){if(_0x25adbd){return _0x25adbd[_0xc1cf('0x24')](_0xfe8a0e)['then'](function(_0x54d190){return _0x54d190;});}return null;};}function removeEntity(_0x132bdc,_0x1acf0c){return function(_0x526fa4){if(_0x526fa4){return _0x526fa4['destroy']()[_0xc1cf('0x25')](function(){_0x132bdc[_0xc1cf('0x1d')](0xcc)[_0xc1cf('0x26')]();});}};}function handleEntityNotFound(_0x46a99a,_0x279f07){return function(_0x2c3027){if(!_0x2c3027){_0x46a99a[_0xc1cf('0x1c')](0x194);}return _0x2c3027;};}function handleError(_0x30f247,_0x5012af){_0x5012af=_0x5012af||0x1f4;return function(_0x18825d){logger[_0xc1cf('0x27')](_0x18825d[_0xc1cf('0x28')]);if(_0x18825d[_0xc1cf('0x29')]){delete _0x18825d[_0xc1cf('0x29')];}_0x30f247[_0xc1cf('0x1d')](_0x5012af)[_0xc1cf('0x2a')](_0x18825d);};}exports['index']=function(_0x5bd81d,_0x396f8c){var _0xfec5d2={},_0x265422={},_0xab6099={'count':0x0,'rows':[]};return db['CmContact'][_0xc1cf('0x2b')]()[_0xc1cf('0x25')](function(_0x414cab){var _0x4c3884=[];for(var _0x8327e2=0x0;_0x8327e2<Object[_0xc1cf('0x2c')](_0x414cab)['length'];_0x8327e2++){var _0x3b76ac=Object[_0xc1cf('0x2c')](_0x414cab)[_0x8327e2];if(_[_0xc1cf('0x2d')](_0x3b76ac,_0xc1cf('0x2e'))){_0x4c3884[_0xc1cf('0x2f')](db[_0xc1cf('0x30')][_0xc1cf('0x31')]({'where':{'id':_[_0xc1cf('0x32')](_0x3b76ac,_0xc1cf('0x2e'))},'raw':!![]}));}}return BPromise[_0xc1cf('0x33')](_0x4c3884)[_0xc1cf('0x25')](function(_0x466ced){for(var _0x325ff6=0x0;_0x325ff6<_0x466ced[_0xc1cf('0x34')];_0x325ff6++){if(_0x466ced[_0x325ff6]){var _0x57f325=_0xc1cf('0x2e')+_0x466ced[_0x325ff6]['id'];var _0x45eb91=_0x414cab[_0x57f325];_0x45eb91['fieldType']=_0x466ced[_0x325ff6][_0xc1cf('0x35')];}}return _0x414cab;});})[_0xc1cf('0x25')](function(_0x13d1be){_0x265422[_0xc1cf('0x36')]=_['keys'](_0x13d1be);_0x265422[_0xc1cf('0x37')]=_['keys'](_0x5bd81d[_0xc1cf('0x37')]);_0x265422[_0xc1cf('0x38')]=_[_0xc1cf('0x39')](_0x265422[_0xc1cf('0x36')],_0x265422[_0xc1cf('0x37')]);_0xfec5d2[_0xc1cf('0x3a')]=_['intersection'](_0x265422[_0xc1cf('0x36')],qs['fields'](_0x5bd81d[_0xc1cf('0x37')][_0xc1cf('0x3b')]));_0xfec5d2[_0xc1cf('0x3a')]=_0xfec5d2[_0xc1cf('0x3a')][_0xc1cf('0x34')]?_0xfec5d2['attributes']:_0x265422['model'];if(!_0x5bd81d['query'][_0xc1cf('0x3c')]('nolimit')){_0xfec5d2[_0xc1cf('0x3d')]=qs['limit'](_0x5bd81d[_0xc1cf('0x37')][_0xc1cf('0x3d')]);_0xfec5d2['offset']=qs[_0xc1cf('0x1e')](_0x5bd81d[_0xc1cf('0x37')]['offset']);}_0xfec5d2[_0xc1cf('0x3e')]=qs['sort'](_0x5bd81d[_0xc1cf('0x37')][_0xc1cf('0x3f')]);_0xfec5d2['where']=qs[_0xc1cf('0x38')](_['pick'](_0x5bd81d[_0xc1cf('0x37')],_0x265422[_0xc1cf('0x38')]),_0x13d1be);var _0x537168=[];var _0x1d9f22=squel['select']()['field']('id')[_0xc1cf('0x40')](_0xc1cf('0x29'))[_0xc1cf('0x40')]('color')[_0xc1cf('0x41')](_0xc1cf('0x42'));var _0x953d01=squel[_0xc1cf('0x43')]()['from'](_0xc1cf('0x44'),'c')['left_join'](_0xc1cf('0x45'),'uc','uc.CmContactId\x20=\x20c.id')['left_join'](_0xc1cf('0x46'),'ct',_0xc1cf('0x47'))[_0xc1cf('0x48')](_0xc1cf('0x42'),'t',_0xc1cf('0x49'))['where'](_0xc1cf('0x4a'));var _0x4d3b9e=squel[_0xc1cf('0x4b')]();var _0x1f48d1=[];var _0x56a1bb=squel[_0xc1cf('0x4b')]();var _0x375b4f;if(_0x5bd81d[_0xc1cf('0x37')][_0xc1cf('0x4c')]){_0x375b4f=as[_0xc1cf('0x4d')](_0x5bd81d[_0xc1cf('0x37')][_0xc1cf('0x4c')]);var _0x5d53fe=_0x375b4f[_0xc1cf('0x4e')];for(var _0x52d850=0x0;_0x52d850<_0x375b4f[_0xc1cf('0x4f')][_0xc1cf('0x34')];_0x52d850++){var _0x59d170=_0x375b4f[_0xc1cf('0x4f')][_0x52d850];var _0x278073='c';var _0x45e261=_(_0x13d1be)[_0xc1cf('0x2c')]()[_0xc1cf('0x50')](function(_0x4c443f){return _0x4c443f===_0x59d170[_0xc1cf('0x40')];});if(_0x45e261)_0x45e261=_0x13d1be[_0x59d170[_0xc1cf('0x40')]];if(!_0x45e261){if(_0x59d170[_0xc1cf('0x40')]===_0xc1cf('0x51')){var _0x5f2999=_0x59d170[_0xc1cf('0x52')][_0xc1cf('0x53')](',')[_0xc1cf('0x54')](function(_0x2b5381){return Number(_0x2b5381);});_0x5f2999[_0xc1cf('0x55')](function(_0x5c3d0f){_0x56a1bb['or'](_0xc1cf('0x56'),'%,'+_0x5c3d0f+',%');});_0x1f48d1=_['union'](_0x1f48d1,_0x5f2999);}else if(_0x59d170['field']===_0xc1cf('0x57')){_0x4d3b9e[_0xc1cf('0x58')](_0xc1cf('0x59'),_0x59d170[_0xc1cf('0x52')]);}}else{if(_0x59d170[_0xc1cf('0x40')]===_0xc1cf('0x5a')||_0x45e261[_0xc1cf('0x5b')]==='datetime')_0x59d170[_0xc1cf('0x5c')]='DATE';var _0xbe5d2c=as[_0xc1cf('0x5d')](_0x278073,_0x45e261[_0xc1cf('0x35')],_0x59d170);_0x4d3b9e[_0x5d53fe](_0xbe5d2c[_0xc1cf('0x5e')],_0xbe5d2c['value']['start'],_0xbe5d2c['value'][_0xc1cf('0x26')]);}}}else{var _0x38c950=_(Object[_0xc1cf('0x2c')](_0x5bd81d['query']))['map'](function(_0x131f55){return _0x13d1be[_0xc1cf('0x3c')](_0x131f55)?_0x131f55:undefined;})[_0xc1cf('0x5f')](function(_0x5bcaa2){return!_[_0xc1cf('0x60')](_0x5bcaa2);})[_0xc1cf('0x52')]();if(_0x5bd81d['query'][_0xc1cf('0x61')])_0x38c950[_0xc1cf('0x2f')](_0xc1cf('0x61'));if(!_['isEmpty'](_0x38c950)){_0x38c950[_0xc1cf('0x55')](function(_0x1dfc76){if(_0x1dfc76===_0xc1cf('0x62')){_0x953d01[_0xc1cf('0x63')](_0xc1cf('0x64'),[][_0xc1cf('0x65')](_0x5bd81d[_0xc1cf('0x37')][_0x1dfc76]));}else if(_0x1dfc76==='Contact'){var _0x590d00='%'+_0x5bd81d[_0xc1cf('0x37')][_0x1dfc76]+'%';_0x953d01[_0xc1cf('0x63')](_0xc1cf('0x66'),_0x590d00);}else{_0x953d01[_0xc1cf('0x63')]('c.'+_0x1dfc76+'\x20=\x20?',_0x5bd81d['query'][_0x1dfc76]);}});}if(_0x5bd81d[_0xc1cf('0x37')][_0xc1cf('0x67')]){_0x1f48d1=_['isArray'](_0x5bd81d[_0xc1cf('0x37')][_0xc1cf('0x67')])?_0x5bd81d[_0xc1cf('0x37')][_0xc1cf('0x67')]:new Array(_0x5bd81d[_0xc1cf('0x37')][_0xc1cf('0x67')]);_0x1f48d1[_0xc1cf('0x55')](function(_0x22faa0){_0x56a1bb['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x22faa0+',%');});}if(_0x5bd81d[_0xc1cf('0x37')]['filter']){var _0x5b24e4=_0x5bd81d[_0xc1cf('0x37')]['filter'][_0xc1cf('0x68')]('\x5c','\x5c\x5c')[_0xc1cf('0x68')](/'/g,'\x27\x27');if(_0x5b24e4['split']('\x20')[_0xc1cf('0x34')]>0x1){_0x4d3b9e['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xc1cf('0x69')](_0x5b24e4),null);}else{if(qs['isNumeric'](_0x5b24e4)){_0x4d3b9e['or']('c.id\x20LIKE\x20?',_0x5b24e4+'%');_0x4d3b9e['or'](_0xc1cf('0x6a'),_0x5b24e4+'%');_0x4d3b9e['or']('c.mobile\x20LIKE\x20?',_0x5b24e4+'%');_0x4d3b9e['or'](_0xc1cf('0x6b'),_0x5b24e4+'%');}else if(qs['isEmail'](_0x5b24e4)){_0x4d3b9e['or'](_0xc1cf('0x6c'),_0x5b24e4+'%');}else{_0x4d3b9e['or'](_0xc1cf('0x6d'),'%'+_0x5b24e4+'%');_0x4d3b9e['or']('c.lastName\x20LIKE\x20?','%'+_0x5b24e4+'%');_0x4d3b9e['or'](_0xc1cf('0x6c'),'%'+_0x5b24e4+'%');}}}}_0x953d01[_0xc1cf('0x63')](_0x4d3b9e);_0x953d01[_0xc1cf('0x6e')](_0xc1cf('0x6f'));var _0x36574d={'type':db[_0xc1cf('0x70')][_0xc1cf('0x71')][_0xc1cf('0x72')],'raw':!![]};var _0x2cc3c4=_0x953d01[_0xc1cf('0x73')]()['field'](_0xc1cf('0x6f'));if(_0xfec5d2[_0xc1cf('0x3e')]){_0xfec5d2[_0xc1cf('0x3e')]['forEach'](function(_0x534011){_0x953d01['order']('c.'+_0x534011[0x0],_0x534011[0x1]===_0xc1cf('0x74')?![]:!![]);});}if(!_['isEmpty'](_0x1f48d1)){_0x953d01[_0xc1cf('0x75')](_0x56a1bb);_0x2cc3c4[_0xc1cf('0x63')](_0xc1cf('0x76'),_0x1f48d1);}BPromise[_0xc1cf('0x77')]()['then'](function(){if(!_0x375b4f)return;if(_0x5bd81d[_0xc1cf('0x78')][_0xc1cf('0x79')]!==_0xc1cf('0x7a'))return;if(!_[_0xc1cf('0x7b')](_0x375b4f[_0xc1cf('0x4f')],[_0xc1cf('0x40'),_0xc1cf('0x57')])){return _0x5bd81d[_0xc1cf('0x78')][_0xc1cf('0x7c')]({'attributes':['id'],'raw':!![]})[_0xc1cf('0x25')](function(_0x3b13a6){if(_[_0xc1cf('0x7d')](_0x3b13a6)){_0x2cc3c4[_0xc1cf('0x63')](_0xc1cf('0x7e'));_0x953d01[_0xc1cf('0x63')](_0xc1cf('0x7e'));}else{_0x2cc3c4['where'](_0xc1cf('0x64'),_[_0xc1cf('0x54')](_0x3b13a6,'id'));_0x953d01[_0xc1cf('0x63')]('c.ListId\x20IN\x20?',_[_0xc1cf('0x54')](_0x3b13a6,'id'));}});}})[_0xc1cf('0x25')](function(){if(_0x5bd81d[_0xc1cf('0x78')][_0xc1cf('0x79')]===_0xc1cf('0x7a')&&!_0x375b4f&&!_0x5bd81d[_0xc1cf('0x37')][_0xc1cf('0x62')])return[];return db[_0xc1cf('0x7f')][_0xc1cf('0x37')](_0x2cc3c4[_0xc1cf('0x80')](),_0x36574d);})[_0xc1cf('0x25')](function(_0x4bd952){_0xab6099[_0xc1cf('0x81')]=_0x4bd952[_0xc1cf('0x34')];if(_0xab6099[_0xc1cf('0x81')]===0x0)return[];return db['sequelize'][_0xc1cf('0x37')](_0x1d9f22[_0xc1cf('0x80')](),_0x36574d)[_0xc1cf('0x25')](function(_0x15dfe5){_0x537168=_[_0xc1cf('0x82')](_0x15dfe5,'id');_0x36574d=_[_0xc1cf('0x83')](_0x36574d,{'model':db[_0xc1cf('0x84')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x5bd81d[_0xc1cf('0x37')][_0xc1cf('0x3b')]){_0xfec5d2['attributes'][_0xc1cf('0x55')](function(_0xb57ada){_0x953d01[_0xc1cf('0x40')]('c.'+_0xb57ada);});}else{_0x953d01['field'](_0xc1cf('0x6f'));_0x953d01[_0xc1cf('0x40')](_0xc1cf('0x85'));_0x953d01[_0xc1cf('0x40')]('c.lastName');_0x953d01[_0xc1cf('0x40')](_0xc1cf('0x86'));_0x953d01[_0xc1cf('0x40')](_0xc1cf('0x87'));_0x953d01['field']('c.fax');_0x953d01['field'](_0xc1cf('0x88'));_0x953d01[_0xc1cf('0x40')](_0xc1cf('0x89'));_0x953d01[_0xc1cf('0x40')](_0xc1cf('0x8a'));_0x953d01[_0xc1cf('0x40')](_0xc1cf('0x8b'));_0x953d01[_0xc1cf('0x40')](_0xc1cf('0x8c'));_0x953d01[_0xc1cf('0x40')](_0xc1cf('0x8d'),_0xc1cf('0x8e'));}if(_0xfec5d2[_0xc1cf('0x3d')])_0x953d01['limit'](_0xfec5d2[_0xc1cf('0x3d')]);if(_0xfec5d2[_0xc1cf('0x1e')])_0x953d01[_0xc1cf('0x1e')](_0xfec5d2[_0xc1cf('0x1e')]);return db[_0xc1cf('0x7f')][_0xc1cf('0x37')](_0x953d01[_0xc1cf('0x80')](),_0x36574d);});})[_0xc1cf('0x25')](function(_0x277afe){_0x277afe[_0xc1cf('0x55')](function(_0x15bcda){if(_0x15bcda[_0xc1cf('0x8e')]){_0x15bcda['Tags']=[];_0x15bcda[_0xc1cf('0x8e')][_0xc1cf('0x53')](',')[_0xc1cf('0x55')](function(_0x39d139){_0x15bcda[_0xc1cf('0x8f')]['push'](_0x537168[_0x39d139]);});}delete _0x15bcda[_0xc1cf('0x8e')];});_0xab6099[_0xc1cf('0x90')]=_0x277afe;return _0xab6099;})[_0xc1cf('0x25')](respondWithFilteredResult(_0x396f8c,_0xfec5d2));})[_0xc1cf('0x91')](handleError(_0x396f8c,null));};exports[_0xc1cf('0x92')]=function(_0x2cdf31,_0x30da33){return db[_0xc1cf('0x84')][_0xc1cf('0x50')]({'where':{'id':_0x2cdf31['params']['id']}})[_0xc1cf('0x25')](handleEntityNotFound(_0x30da33,null))['then'](removeEntity(_0x30da33,null))[_0xc1cf('0x91')](handleError(_0x30da33,null));};exports[_0xc1cf('0x2b')]=function(_0x56a918,_0x57881e){return db['CmContact'][_0xc1cf('0x2b')]()['then'](function(_0x32d08f){delete _0x32d08f[_0xc1cf('0x93')];for(var _0x406544=0x0;_0x406544<Object['keys'](_0x32d08f)['length'];_0x406544++){var _0x4cfc06=Object['keys'](_0x32d08f)[_0x406544];if(!_[_0xc1cf('0x2d')](_0x4cfc06,_0xc1cf('0x2e'))){_0x32d08f[_0x4cfc06]['columnName']=_0x4cfc06;_0x32d08f[_0x4cfc06]['displayName']=_0x4cfc06;}}return _0x32d08f;})[_0xc1cf('0x25')](function(_0x196fc3){var _0x3f837d={'where':{'$or':[{'ListId':_0x56a918[_0xc1cf('0x37')]['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField'][_0xc1cf('0x94')](_0x3f837d)['then'](function(_0x507b5b){for(var _0x1d57fe=0x0;_0x1d57fe<_0x507b5b['length'];_0x1d57fe++){var _0x2fb141=_0xc1cf('0x2e')+_0x507b5b[_0x1d57fe]['id'];_0x196fc3[_0x2fb141][_0xc1cf('0x95')]=_0x2fb141;_0x196fc3[_0x2fb141][_0xc1cf('0x96')]=_0x507b5b[_0x1d57fe][_0xc1cf('0x97')];_0x196fc3[_0x2fb141][_0xc1cf('0x98')]={'type':_0x507b5b[_0x1d57fe]['type'],'values':_0x507b5b[_0x1d57fe][_0xc1cf('0x99')]};}Object['keys'](_0x196fc3)['forEach'](function(_0x59b991){if(!_0x196fc3[_0x59b991]['hasOwnProperty'](_0xc1cf('0x95'))){delete _0x196fc3[_0x59b991];}});return _0x196fc3;});})['then'](respondWithResult(_0x57881e,null))['catch'](handleError(_0x57881e,null));};exports[_0xc1cf('0x83')]=function(_0x35c81b,_0x586b43){var _0x174d22;var _0x1eb8b5;var _0x3079ff;if(_0x35c81b[_0xc1cf('0x9a')]['id']){delete _0x35c81b[_0xc1cf('0x9a')]['id'];}return db[_0xc1cf('0x84')][_0xc1cf('0x94')]({'where':{'id':[_0x35c81b[_0xc1cf('0x9a')]['to'],_0x35c81b[_0xc1cf('0x9a')][_0xc1cf('0x41')]]}})['then'](function(_0x1e5752){if(_0x1e5752){if(_0x1e5752[_0xc1cf('0x34')]!==0x2){return null;}_0x1e5752[0x0]=_0x1e5752[0x0][_0xc1cf('0x9b')]({'plain':!![]});_0x1e5752[0x1]=_0x1e5752[0x1][_0xc1cf('0x9b')]({'plain':!![]});delete _0x1e5752[0x0]['id'];delete _0x1e5752[0x1]['id'];return _[_0xc1cf('0x9c')](_0x1e5752[0x0],_0x1e5752[0x1],function(_0x1233e7,_0x19b4eb){if(Array['isArray'](_0x19b4eb)&&!_0x19b4eb[_0xc1cf('0x34')]){return _0x1233e7;}else if(!_0x19b4eb){return _0x1233e7;}});}})[_0xc1cf('0x25')](handleEntityNotFound(_0x586b43,null))[_0xc1cf('0x25')](function(_0xf1bea8){if(_0xf1bea8){if(_0xf1bea8[_0xc1cf('0x93')]&&_[_0xc1cf('0x9d')](_0xf1bea8['tags'])){_0xf1bea8[_0xc1cf('0x93')]=_0xf1bea8['tags'][_0xc1cf('0x9e')]();}logger['info'](_0xc1cf('0x9f'),_0x35c81b[_0xc1cf('0x9a')]['to'],_0x35c81b[_0xc1cf('0x9a')]['from']);return db[_0xc1cf('0xa0')][_0xc1cf('0x92')]({'where':{'ContactId':[_0x35c81b[_0xc1cf('0x9a')]['to'],_0x35c81b['body'][_0xc1cf('0x41')]]}})['then'](function(_0x583245){logger[_0xc1cf('0xa1')](_0xc1cf('0xa2'),_0x583245);return db['CmHopperBlack']['destroy']({'where':{'ContactId':[_0x35c81b['body']['to'],_0x35c81b['body'][_0xc1cf('0x41')]]}})[_0xc1cf('0x25')](function(_0x171b42){logger[_0xc1cf('0xa1')](_0xc1cf('0xa3'),_0x171b42);return db[_0xc1cf('0x84')]['create'](_0xf1bea8);});});}})[_0xc1cf('0x25')](function(_0x4d7f2c){if(_0x4d7f2c){_0x174d22=_0x4d7f2c;_0x1eb8b5={'ContactId':_0x174d22['id']};_0x3079ff={'where':{'ContactId':[_0x35c81b[_0xc1cf('0x9a')]['to'],_0x35c81b[_0xc1cf('0x9a')][_0xc1cf('0x41')]]}};return db[_0xc1cf('0xa4')]['update'](_0x1eb8b5,_0x3079ff);}})[_0xc1cf('0x25')](function(){if(_0x174d22){return db[_0xc1cf('0xa5')][_0xc1cf('0x24')](_0x1eb8b5,_0x3079ff);}})[_0xc1cf('0x25')](function(){if(_0x174d22){return db[_0xc1cf('0xa6')][_0xc1cf('0x24')](_0x1eb8b5,_0x3079ff);}})[_0xc1cf('0x25')](function(){if(_0x174d22){return db['MailInteraction'][_0xc1cf('0x24')](_0x1eb8b5,_0x3079ff);}})[_0xc1cf('0x25')](function(){if(_0x174d22){return db[_0xc1cf('0xa7')][_0xc1cf('0x24')](_0x1eb8b5,_0x3079ff);}})[_0xc1cf('0x25')](function(){if(_0x174d22){return db['MailInteraction'][_0xc1cf('0x24')](_0x1eb8b5,_0x3079ff);}})['then'](function(){if(_0x174d22){return db[_0xc1cf('0xa7')]['update'](_0x1eb8b5,_0x3079ff);}})[_0xc1cf('0x25')](function(){if(_0x174d22){return db['SmsInteraction'][_0xc1cf('0x24')](_0x1eb8b5,_0x3079ff);}})['then'](function(){if(_0x174d22){return db[_0xc1cf('0xa8')][_0xc1cf('0x24')](_0x1eb8b5,_0x3079ff);}})['then'](function(){if(_0x174d22){return db[_0xc1cf('0xa9')]['update'](_0x1eb8b5,_0x3079ff);}})[_0xc1cf('0x25')](function(){if(_0x174d22){return db[_0xc1cf('0xaa')][_0xc1cf('0x24')](_0x1eb8b5,_0x3079ff);}})[_0xc1cf('0x25')](function(){if(_0x174d22){return db[_0xc1cf('0xab')][_0xc1cf('0x24')](_0x1eb8b5,_0x3079ff);}})[_0xc1cf('0x25')](function(){if(_0x174d22){return db[_0xc1cf('0xac')][_0xc1cf('0x24')](_0x1eb8b5,_0x3079ff);}})[_0xc1cf('0x25')](function(){if(_0x174d22){return db[_0xc1cf('0xad')][_0xc1cf('0x24')](_0x1eb8b5,_0x3079ff);}})['then'](function(){if(_0x174d22){return db['CmHopperHistory'][_0xc1cf('0x24')](_0x1eb8b5,_0x3079ff);}})['then'](function(){if(_0x174d22){return db[_0xc1cf('0xae')][_0xc1cf('0x24')](_0x1eb8b5,_0x3079ff);}})['then'](function(){if(_0x174d22){return db[_0xc1cf('0xaf')][_0xc1cf('0x24')](_0x1eb8b5,_0x3079ff);}})[_0xc1cf('0x25')](function(){if(_0x174d22){return db['ChatQueueReport'][_0xc1cf('0x24')](_0x1eb8b5,_0x3079ff);}})[_0xc1cf('0x25')](function(){if(_0x174d22){return db[_0xc1cf('0xb0')][_0xc1cf('0x24')](_0x1eb8b5,_0x3079ff);}})[_0xc1cf('0x25')](function(){if(_0x174d22){return db[_0xc1cf('0xb1')]['update'](_0x1eb8b5,_0x3079ff);}})[_0xc1cf('0x25')](function(){if(_0x174d22){return db[_0xc1cf('0xb2')][_0xc1cf('0x24')](_0x1eb8b5,_0x3079ff);}})[_0xc1cf('0x25')](function(){if(_0x174d22){return db[_0xc1cf('0xb3')]['update'](_0x1eb8b5,_0x3079ff);}})[_0xc1cf('0x25')](function(){if(_0x174d22){return db[_0xc1cf('0xb4')][_0xc1cf('0x24')](_0x1eb8b5,_0x3079ff);}})[_0xc1cf('0x25')](function(){if(_0x174d22){return db[_0xc1cf('0x84')][_0xc1cf('0x92')]({'where':{'id':[_0x35c81b['body']['to'],_0x35c81b[_0xc1cf('0x9a')]['from']]}});}})[_0xc1cf('0x25')](function(){if(_0x174d22){return _0x174d22;}})[_0xc1cf('0x25')](respondWithResult(_0x586b43,null))[_0xc1cf('0x91')](handleError(_0x586b43,null));};exports[_0xc1cf('0xb5')]=function(_0x26d2c5,_0x31f3f8){return db[_0xc1cf('0x84')][_0xc1cf('0x2b')]()[_0xc1cf('0x25')](function(_0x16abff){if(_0x26d2c5[_0xc1cf('0x9a')][_0xc1cf('0x93')]&&_['isArray'](_0x26d2c5[_0xc1cf('0x9a')][_0xc1cf('0x93')])){if(_0x26d2c5['body']['tags'][_0xc1cf('0x34')]){_0x26d2c5['body'][_0xc1cf('0x93')]=_0x26d2c5[_0xc1cf('0x9a')][_0xc1cf('0x93')][_0xc1cf('0x9e')](';')+';';}else{_0x26d2c5[_0xc1cf('0x9a')][_0xc1cf('0x93')]=null;}}else{_0x26d2c5[_0xc1cf('0x9a')][_0xc1cf('0x93')]=null;}return db[_0xc1cf('0x84')]['create'](_0x26d2c5[_0xc1cf('0x9a')],{'fields':_[_0xc1cf('0x2c')](_0x16abff),'raw':!![]});})['then'](respondWithResult(_0x31f3f8,0xc9))['catch'](handleError(_0x31f3f8,null));};exports[_0xc1cf('0xb6')]=function(_0x533344,_0x13c5ac){var _0x2c932d=[];var _0x572e9c=0x0;var _0x5dac52=0x0;var _0x20ec39=0x0;return db[_0xc1cf('0x84')][_0xc1cf('0x2b')]()['then'](function(_0x3b9e6e){return BPromise[_0xc1cf('0xb7')](_0x533344['body'],function(_0x94a951){var _0x18c24f={'where':{'$or':[]},'defaults':_0x94a951,'fields':_['keys'](_0x3b9e6e),'raw':!![]};if(_0x94a951[_0xc1cf('0xb8')]){for(var _0x33d91e=0x0;_0x33d91e<_0x94a951[_0xc1cf('0xb8')]['length'];_0x33d91e++){var _0x4e33a0={};_0x4e33a0[_0x94a951[_0xc1cf('0xb8')][_0x33d91e]]=_0x94a951[_0x94a951[_0xc1cf('0xb8')][_0x33d91e]];_0x18c24f['where'][_0xc1cf('0xb9')][_0xc1cf('0x2f')](_0x4e33a0);}_0x18c24f[_0xc1cf('0x63')]['ListId']=_0x94a951[_0xc1cf('0x62')];}return db[_0xc1cf('0x84')][_0xc1cf('0xba')](_0x18c24f)['spread'](function(_0x1c3350,_0x1cc38f){if(_0x1cc38f){_0x572e9c++;}else{_0x20ec39++;}})[_0xc1cf('0x91')](function(_0x3417a1){console[_0xc1cf('0x27')](_0x3417a1);_0x5dac52++;});});})['then'](function(_0x2bb3f3){if(_0x2bb3f3){return{'success':_0x572e9c,'failure':_0x5dac52,'duplicates':_0x20ec39};}})[_0xc1cf('0x25')](respondWithResult(_0x13c5ac,0xc9))['catch'](handleError(_0x13c5ac,null));};exports[_0xc1cf('0xbb')]=function(_0x2ed113,_0x17abe7,_0x1fbdaf){var _0x39f94f;return db[_0xc1cf('0x84')][_0xc1cf('0x2b')]()[_0xc1cf('0x25')](function(_0x4ff709){return db['CmContact']['find']({'where':{'id':_0x2ed113[_0xc1cf('0xbc')]['id']},'include':[{'model':db[_0xc1cf('0x51')],'as':'Tags','attributes':['id',_0xc1cf('0x29'),_0xc1cf('0xbd')],'required':_0x2ed113[_0xc1cf('0x37')][_0xc1cf('0x67')]?!![]:![]}],'attributes':_[_0xc1cf('0x2c')](_0x4ff709)});})[_0xc1cf('0x25')](function(_0x2e4d5b){_0x39f94f=_0x2e4d5b[_0xc1cf('0x9b')]({'plain':!![]});var _0x147cd8={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x2e4d5b&&_0x2e4d5b[_0xc1cf('0x62')]){if(_0x2e4d5b[_0xc1cf('0x62')]){_0x147cd8[_0xc1cf('0x63')][_0xc1cf('0xbe')]['push']({'ListId':{'$ne':_0x2e4d5b[_0xc1cf('0x62')]}});}}return db[_0xc1cf('0x30')][_0xc1cf('0x94')](_0x147cd8);})['then'](function(_0xdc191){return _['omit'](_0x39f94f,_['map'](_0xdc191,function(_0x498d87){return util[_0xc1cf('0xbf')](_0xc1cf('0xc0'),_0x498d87['id']);}));})['then'](handleEntityNotFound(_0x17abe7,null))[_0xc1cf('0x25')](respondWithResult(_0x17abe7,null))[_0xc1cf('0x91')](handleError(_0x17abe7,null));};exports[_0xc1cf('0x24')]=function(_0x5b76ad,_0x54893a){var _0x4916fd;if(_0x5b76ad[_0xc1cf('0x9a')]['id']){delete _0x5b76ad[_0xc1cf('0x9a')]['id'];}return db[_0xc1cf('0x84')][_0xc1cf('0x50')]({'where':{'id':_0x5b76ad[_0xc1cf('0xbc')]['id']}})[_0xc1cf('0x25')](handleEntityNotFound(_0x54893a,null))['then'](saveUpdates(_0x5b76ad[_0xc1cf('0x9a')],null))[_0xc1cf('0x25')](function(_0x165626){_0x4916fd=_0x165626;var _0x1c64ab={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x165626&&_0x165626[_0xc1cf('0x62')]){if(_0x165626[_0xc1cf('0x62')]){_0x1c64ab[_0xc1cf('0x63')][_0xc1cf('0xbe')]['push']({'ListId':{'$ne':_0x165626[_0xc1cf('0x62')]}});}}return db[_0xc1cf('0x30')][_0xc1cf('0x94')](_0x1c64ab);})[_0xc1cf('0x25')](function(_0x18103a){if(_0x18103a){return _['omit'](_['pickBy'](_0x5b76ad['body'],function(_0x54b7cc,_0x414b31){return _[_0xc1cf('0x2d')](_0x414b31,'cf_');}),_[_0xc1cf('0x54')](_0x18103a,function(_0x3ef3e6){return util[_0xc1cf('0xbf')](_0xc1cf('0xc0'),_0x3ef3e6['id']);}));}})[_0xc1cf('0x25')](function(_0x46dc01){if(_0x46dc01&&!_[_0xc1cf('0x7d')](_0x46dc01)){var _0x30a5e3=squel[_0xc1cf('0x24')]()['table'](_0xc1cf('0x44'))[_0xc1cf('0xc1')](_0x46dc01)[_0xc1cf('0x63')](_0xc1cf('0xc2'),_0x5b76ad[_0xc1cf('0xbc')]['id'])[_0xc1cf('0xc3')]();return db[_0xc1cf('0x7f')][_0xc1cf('0x37')](_0x30a5e3[_0xc1cf('0x5e')],{'replacements':_0x30a5e3[_0xc1cf('0x99')]});}})[_0xc1cf('0x25')](function(){if(_0x5b76ad[_0xc1cf('0x9a')][_0xc1cf('0xc4')]&&_0x4916fd){return db['CmHopper'][_0xc1cf('0x24')]({'phone':_0x5b76ad[_0xc1cf('0x9a')]['phone']},{'where':{'ContactId':_0x4916fd['id']}});}})['then'](function(){return _0x4916fd;})[_0xc1cf('0x25')](respondWithResult(_0x54893a,null))[_0xc1cf('0x91')](handleError(_0x54893a,null));};exports[_0xc1cf('0xc5')]=function(_0x3f5cb0,_0x128b66,_0x26bfa2){var _0x2bf95a={};var _0x49bd6e={};var _0x90599a;var _0x3bb982;return db['CmContact'][_0xc1cf('0x31')]({'where':{'id':_0x3f5cb0[_0xc1cf('0xbc')]['id']}})['then'](handleEntityNotFound(_0x128b66,null))['then'](function(_0x53aae1){if(_0x53aae1){_0x90599a=_0x53aae1;_0x49bd6e[_0xc1cf('0x36')]=_['keys'](db[_0xc1cf('0x51')][_0xc1cf('0xc6')]);_0x49bd6e[_0xc1cf('0x37')]=_[_0xc1cf('0x2c')](_0x3f5cb0[_0xc1cf('0x37')]);_0x49bd6e[_0xc1cf('0x38')]=_[_0xc1cf('0x39')](_0x49bd6e[_0xc1cf('0x36')],_0x49bd6e[_0xc1cf('0x37')]);_0x2bf95a['attributes']=_[_0xc1cf('0x39')](_0x49bd6e[_0xc1cf('0x36')],qs[_0xc1cf('0x3b')](_0x3f5cb0[_0xc1cf('0x37')]['fields']));_0x2bf95a[_0xc1cf('0x3a')]=_0x2bf95a['attributes'][_0xc1cf('0x34')]?_0x2bf95a[_0xc1cf('0x3a')]:_0x49bd6e['model'];_0x2bf95a['order']=qs[_0xc1cf('0x3f')](_0x3f5cb0[_0xc1cf('0x37')][_0xc1cf('0x3f')]);_0x2bf95a[_0xc1cf('0x63')]=qs[_0xc1cf('0x38')](_[_0xc1cf('0xc7')](_0x3f5cb0[_0xc1cf('0x37')],_0x49bd6e['filters']));if(_0x3f5cb0[_0xc1cf('0x37')][_0xc1cf('0x5f')]){_0x2bf95a[_0xc1cf('0x63')]=_[_0xc1cf('0x83')](_0x2bf95a[_0xc1cf('0x63')],{'$or':_[_0xc1cf('0x54')](_0x2bf95a[_0xc1cf('0x3a')],function(_0x5beeaa){var _0x2a9fca={};_0x2a9fca[_0x5beeaa]={'$like':'%'+_0x3f5cb0[_0xc1cf('0x37')]['filter']+'%'};return _0x2a9fca;})});}_0x2bf95a=_[_0xc1cf('0x83')]({},_0x2bf95a,_0x3f5cb0['options']);return _0x90599a[_0xc1cf('0xc5')](_0x2bf95a);}})[_0xc1cf('0x25')](function(_0x225a96){if(_0x225a96){_0x3bb982=_0x225a96[_0xc1cf('0x34')];if(!_0x3f5cb0[_0xc1cf('0x37')]['hasOwnProperty'](_0xc1cf('0xc8'))){_0x2bf95a['limit']=qs[_0xc1cf('0x3d')](_0x3f5cb0[_0xc1cf('0x37')][_0xc1cf('0x3d')]);_0x2bf95a['offset']=qs[_0xc1cf('0x1e')](_0x3f5cb0[_0xc1cf('0x37')][_0xc1cf('0x1e')]);}return _0x90599a[_0xc1cf('0xc5')](_0x2bf95a);}})['then'](function(_0x4312bd){if(_0x4312bd){return _0x4312bd?{'count':_0x3bb982,'rows':_0x4312bd}:null;}})[_0xc1cf('0x25')](respondWithResult(_0x128b66,null))[_0xc1cf('0x91')](handleError(_0x128b66,null));};exports['setTags']=function(_0xd41d02,_0x5464d9,_0x5271a0){if(_0xd41d02[_0xc1cf('0x9a')]['id']){delete _0xd41d02['body']['id'];}return db[_0xc1cf('0x84')][_0xc1cf('0x31')]({'where':{'id':_0xd41d02[_0xc1cf('0xbc')]['id']}})[_0xc1cf('0x25')](handleEntityNotFound(_0x5464d9,null))[_0xc1cf('0x25')](function(_0x2fc6fb){if(_0x2fc6fb){return _0x2fc6fb['setTags'](_0xd41d02['body'][_0xc1cf('0xc9')]||[]);}return null;})['then'](respondWithResult(_0x5464d9,null))[_0xc1cf('0x91')](handleError(_0x5464d9,null));};exports['getHoppers']=function(_0x25ab32,_0xf28279,_0x19ebdb){var _0x2fde18={'raw':![],'where':{}};var _0x444e57={};var _0x11d018={'count':0x0,'rows':[]};return db[_0xc1cf('0x84')][_0xc1cf('0x31')]({'where':{'id':_0x25ab32[_0xc1cf('0xbc')]['id']}})[_0xc1cf('0x25')](handleEntityNotFound(_0xf28279,null))[_0xc1cf('0x25')](function(_0x15f460){if(_0x15f460){_0x444e57[_0xc1cf('0x36')]=_['keys'](db[_0xc1cf('0xa0')][_0xc1cf('0xc6')]);_0x444e57[_0xc1cf('0x37')]=_[_0xc1cf('0x2c')](_0x25ab32[_0xc1cf('0x37')]);_0x444e57['filters']=_[_0xc1cf('0x39')](_0x444e57[_0xc1cf('0x36')],_0x444e57[_0xc1cf('0x37')]);_0x2fde18[_0xc1cf('0x3a')]=_['intersection'](_0x444e57[_0xc1cf('0x36')],qs[_0xc1cf('0x3b')](_0x25ab32[_0xc1cf('0x37')]['fields']));_0x2fde18[_0xc1cf('0x3a')]=_0x2fde18['attributes']['length']?_0x2fde18[_0xc1cf('0x3a')]:_0x444e57['model'];if(!_0x25ab32[_0xc1cf('0x37')][_0xc1cf('0x3c')](_0xc1cf('0xc8'))){_0x2fde18[_0xc1cf('0x3d')]=qs['limit'](_0x25ab32['query']['limit']);_0x2fde18['offset']=qs[_0xc1cf('0x1e')](_0x25ab32[_0xc1cf('0x37')][_0xc1cf('0x1e')]);}_0x2fde18['order']=qs[_0xc1cf('0x3f')](_0x25ab32[_0xc1cf('0x37')]['sort']);_0x2fde18[_0xc1cf('0x63')]=qs[_0xc1cf('0x38')](_[_0xc1cf('0xc7')](_0x25ab32['query'],_0x444e57[_0xc1cf('0x38')]));_0x2fde18[_0xc1cf('0x63')][_0xc1cf('0xca')]=_0x15f460['id'];if(_0x25ab32['query']['filter']){_0x2fde18[_0xc1cf('0x63')]=_[_0xc1cf('0x83')](_0x2fde18[_0xc1cf('0x63')],{'$or':_[_0xc1cf('0x54')](_0x2fde18['attributes'],function(_0xff6ec5){var _0x1428b1={};_0x1428b1[_0xff6ec5]={'$like':'%'+_0x25ab32[_0xc1cf('0x37')][_0xc1cf('0x5f')]+'%'};return _0x1428b1;})});}_0x2fde18=_[_0xc1cf('0x83')]({},_0x2fde18,_0x25ab32['options']);return db['CmHopper'][_0xc1cf('0x81')]({'where':_0x2fde18[_0xc1cf('0x63')]})[_0xc1cf('0x25')](function(_0x3bc0b3){_0x11d018['count']=_0x3bc0b3;if(_0x25ab32[_0xc1cf('0x37')][_0xc1cf('0xcb')]){_0x2fde18[_0xc1cf('0xcc')]=[{'all':!![]}];}return db[_0xc1cf('0xa0')][_0xc1cf('0x94')](_0x2fde18);})[_0xc1cf('0x25')](function(_0x56924a){_0x11d018[_0xc1cf('0x90')]=_0x56924a;return _0x11d018;});}})['then'](respondWithFilteredResult(_0xf28279,_0x2fde18))[_0xc1cf('0x91')](handleError(_0xf28279,null));};exports[_0xc1cf('0xcd')]=function(_0x161cbf,_0x43db5f,_0x49df05){var _0x48761b={'raw':!![],'where':{}};var _0x59b395={};var _0x8f07ad={'count':0x0,'rows':[]};return db[_0xc1cf('0x84')][_0xc1cf('0x31')]({'where':{'id':_0x161cbf[_0xc1cf('0xbc')]['id']}})['then'](handleEntityNotFound(_0x43db5f,null))[_0xc1cf('0x25')](function(_0x346f2a){if(_0x346f2a){_0x59b395[_0xc1cf('0x36')]=_[_0xc1cf('0x2c')](db[_0xc1cf('0xce')][_0xc1cf('0xc6')]);_0x59b395[_0xc1cf('0x37')]=_[_0xc1cf('0x2c')](_0x161cbf[_0xc1cf('0x37')]);_0x59b395['filters']=_[_0xc1cf('0x39')](_0x59b395[_0xc1cf('0x36')],_0x59b395['query']);_0x48761b[_0xc1cf('0x3a')]=_[_0xc1cf('0x39')](_0x59b395[_0xc1cf('0x36')],qs[_0xc1cf('0x3b')](_0x161cbf[_0xc1cf('0x37')]['fields']));_0x48761b['attributes']=_0x48761b[_0xc1cf('0x3a')][_0xc1cf('0x34')]?_0x48761b[_0xc1cf('0x3a')]:_0x59b395['model'];if(!_0x161cbf[_0xc1cf('0x37')]['hasOwnProperty'](_0xc1cf('0xc8'))){_0x48761b[_0xc1cf('0x3d')]=qs[_0xc1cf('0x3d')](_0x161cbf[_0xc1cf('0x37')][_0xc1cf('0x3d')]);_0x48761b[_0xc1cf('0x1e')]=qs[_0xc1cf('0x1e')](_0x161cbf[_0xc1cf('0x37')][_0xc1cf('0x1e')]);}_0x48761b[_0xc1cf('0x3e')]=qs[_0xc1cf('0x3f')](_0x161cbf[_0xc1cf('0x37')][_0xc1cf('0x3f')]);_0x48761b[_0xc1cf('0x63')]=qs[_0xc1cf('0x38')](_[_0xc1cf('0xc7')](_0x161cbf[_0xc1cf('0x37')],_0x59b395['filters']));_0x48761b['where'][_0xc1cf('0xca')]=_0x346f2a['id'];if(_0x161cbf[_0xc1cf('0x37')][_0xc1cf('0x5f')]){_0x48761b[_0xc1cf('0x63')]=_['merge'](_0x48761b['where'],{'$or':_[_0xc1cf('0x54')](_0x48761b[_0xc1cf('0x3a')],function(_0x341513){var _0x4b8878={};_0x4b8878[_0x341513]={'$like':'%'+_0x161cbf[_0xc1cf('0x37')][_0xc1cf('0x5f')]+'%'};return _0x4b8878;})});}_0x48761b=_[_0xc1cf('0x83')]({},_0x48761b,_0x161cbf['options']);return db[_0xc1cf('0xce')][_0xc1cf('0x81')]({'where':_0x48761b['where']})['then'](function(_0x2e7a2d){_0x8f07ad['count']=_0x2e7a2d;if(_0x161cbf['query']['includeAll']){_0x48761b[_0xc1cf('0xcc')]=[{'all':!![]}];}return db[_0xc1cf('0xce')][_0xc1cf('0x94')](_0x48761b);})[_0xc1cf('0x25')](function(_0x4301f6){_0x8f07ad['rows']=_0x4301f6;return _0x8f07ad;});}})[_0xc1cf('0x25')](respondWithFilteredResult(_0x43db5f,_0x48761b))[_0xc1cf('0x91')](handleError(_0x43db5f,null));};exports['getHopperFinals']=function(_0x1b89c8,_0x5201ff,_0x215ade){var _0x2732de={'raw':!![],'where':{}};var _0x4b2b44={};var _0x159a57={'count':0x0,'rows':[]};return db[_0xc1cf('0x84')]['findOne']({'where':{'id':_0x1b89c8[_0xc1cf('0xbc')]['id']}})[_0xc1cf('0x25')](handleEntityNotFound(_0x5201ff,null))[_0xc1cf('0x25')](function(_0x1d9e4c){if(_0x1d9e4c){_0x4b2b44[_0xc1cf('0x36')]=_['keys'](db[_0xc1cf('0xad')][_0xc1cf('0xc6')]);_0x4b2b44['query']=_['keys'](_0x1b89c8[_0xc1cf('0x37')]);_0x4b2b44['filters']=_[_0xc1cf('0x39')](_0x4b2b44[_0xc1cf('0x36')],_0x4b2b44[_0xc1cf('0x37')]);_0x2732de[_0xc1cf('0x3a')]=_[_0xc1cf('0x39')](_0x4b2b44[_0xc1cf('0x36')],qs[_0xc1cf('0x3b')](_0x1b89c8[_0xc1cf('0x37')][_0xc1cf('0x3b')]));_0x2732de[_0xc1cf('0x3a')]=_0x2732de[_0xc1cf('0x3a')][_0xc1cf('0x34')]?_0x2732de[_0xc1cf('0x3a')]:_0x4b2b44[_0xc1cf('0x36')];if(!_0x1b89c8[_0xc1cf('0x37')][_0xc1cf('0x3c')](_0xc1cf('0xc8'))){_0x2732de[_0xc1cf('0x3d')]=qs[_0xc1cf('0x3d')](_0x1b89c8[_0xc1cf('0x37')][_0xc1cf('0x3d')]);_0x2732de['offset']=qs['offset'](_0x1b89c8[_0xc1cf('0x37')][_0xc1cf('0x1e')]);}_0x2732de[_0xc1cf('0x3e')]=qs[_0xc1cf('0x3f')](_0x1b89c8[_0xc1cf('0x37')]['sort']);_0x2732de[_0xc1cf('0x63')]=qs['filters'](_['pick'](_0x1b89c8[_0xc1cf('0x37')],_0x4b2b44['filters']));_0x2732de['where'][_0xc1cf('0xca')]=_0x1d9e4c['id'];if(_0x1b89c8[_0xc1cf('0x37')]['filter']){_0x2732de['where']=_[_0xc1cf('0x83')](_0x2732de[_0xc1cf('0x63')],{'$or':_[_0xc1cf('0x54')](_0x2732de[_0xc1cf('0x3a')],function(_0x434b79){var _0x5d065={};_0x5d065[_0x434b79]={'$like':'%'+_0x1b89c8[_0xc1cf('0x37')][_0xc1cf('0x5f')]+'%'};return _0x5d065;})});}_0x2732de=_[_0xc1cf('0x83')]({},_0x2732de,_0x1b89c8[_0xc1cf('0xcf')]);return db[_0xc1cf('0xad')][_0xc1cf('0x81')]({'where':_0x2732de[_0xc1cf('0x63')]})[_0xc1cf('0x25')](function(_0x3bd75b){_0x159a57['count']=_0x3bd75b;if(_0x1b89c8[_0xc1cf('0x37')][_0xc1cf('0xcb')]){_0x2732de[_0xc1cf('0xcc')]=[{'all':!![]}];}return db[_0xc1cf('0xad')]['findAll'](_0x2732de);})[_0xc1cf('0x25')](function(_0x20ef0f){_0x159a57[_0xc1cf('0x90')]=_0x20ef0f;return _0x159a57;});}})[_0xc1cf('0x25')](respondWithFilteredResult(_0x5201ff,_0x2732de))[_0xc1cf('0x91')](handleError(_0x5201ff,null));};exports[_0xc1cf('0xd0')]=function(_0x248917,_0x34e22b,_0x1f44fc){var _0x5c3201={'raw':!![],'where':{}};var _0x17e2b6={};var _0xadd2c3={'count':0x0,'rows':[]};return db[_0xc1cf('0x84')][_0xc1cf('0x31')]({'where':{'id':_0x248917['params']['id']}})[_0xc1cf('0x25')](handleEntityNotFound(_0x34e22b,null))[_0xc1cf('0x25')](function(_0x33c701){if(_0x33c701){_0x17e2b6[_0xc1cf('0x36')]=_[_0xc1cf('0x2c')](db[_0xc1cf('0xb4')][_0xc1cf('0xc6')]);_0x17e2b6[_0xc1cf('0x37')]=_[_0xc1cf('0x2c')](_0x248917[_0xc1cf('0x37')]);_0x17e2b6[_0xc1cf('0x38')]=_[_0xc1cf('0x39')](_0x17e2b6[_0xc1cf('0x36')],_0x17e2b6['query']);_0x5c3201[_0xc1cf('0x3a')]=_['intersection'](_0x17e2b6['model'],qs['fields'](_0x248917[_0xc1cf('0x37')][_0xc1cf('0x3b')]));_0x5c3201[_0xc1cf('0x3a')]=_0x5c3201[_0xc1cf('0x3a')]['length']?_0x5c3201[_0xc1cf('0x3a')]:_0x17e2b6[_0xc1cf('0x36')];if(!_0x248917[_0xc1cf('0x37')][_0xc1cf('0x3c')](_0xc1cf('0xc8'))){_0x5c3201[_0xc1cf('0x3d')]=qs['limit'](_0x248917[_0xc1cf('0x37')][_0xc1cf('0x3d')]);_0x5c3201[_0xc1cf('0x1e')]=qs[_0xc1cf('0x1e')](_0x248917['query'][_0xc1cf('0x1e')]);}_0x5c3201['order']=qs[_0xc1cf('0x3f')](_0x248917['query'][_0xc1cf('0x3f')]);_0x5c3201[_0xc1cf('0x63')]=qs[_0xc1cf('0x38')](_[_0xc1cf('0xc7')](_0x248917[_0xc1cf('0x37')],_0x17e2b6[_0xc1cf('0x38')]));_0x5c3201['where'][_0xc1cf('0xca')]=_0x33c701['id'];if(_0x248917[_0xc1cf('0x37')][_0xc1cf('0x5f')]){_0x5c3201[_0xc1cf('0x63')]=_[_0xc1cf('0x83')](_0x5c3201[_0xc1cf('0x63')],{'$or':_[_0xc1cf('0x54')](_0x5c3201['attributes'],function(_0x4ccf36){var _0x579dfc={};_0x579dfc[_0x4ccf36]={'$like':'%'+_0x248917[_0xc1cf('0x37')]['filter']+'%'};return _0x579dfc;})});}_0x5c3201=_[_0xc1cf('0x83')]({},_0x5c3201,_0x248917['options']);return db[_0xc1cf('0xb4')][_0xc1cf('0x81')]({'where':_0x5c3201[_0xc1cf('0x63')]})[_0xc1cf('0x25')](function(_0x239d0c){_0xadd2c3[_0xc1cf('0x81')]=_0x239d0c;if(_0x248917[_0xc1cf('0x37')][_0xc1cf('0xcb')]){_0x5c3201['include']=[{'all':!![]}];}return db[_0xc1cf('0xb4')]['findAll'](_0x5c3201);})['then'](function(_0x477c93){_0xadd2c3[_0xc1cf('0x90')]=_0x477c93;return _0xadd2c3;});}})['then'](respondWithFilteredResult(_0x34e22b,_0x5c3201))[_0xc1cf('0x91')](handleError(_0x34e22b,null));};exports[_0xc1cf('0xd1')]=function(_0x1d09ce,_0x56ee71,_0x26293b){try{if(!_0x1d09ce[_0xc1cf('0x9a')]['ListId']){throw new Error(_0xc1cf('0xd2'));}if(!_0x1d09ce[_0xc1cf('0x9a')][_0xc1cf('0xd3')]){throw new Error(_0xc1cf('0xd4'));}if(!_0x1d09ce[_0xc1cf('0x9a')][_0xc1cf('0xd5')]){throw new Error('No\x20association\x20values\x20specified!');}if(!_0x1d09ce[_0xc1cf('0x9a')][_0xc1cf('0xd6')]){throw new Error(_0xc1cf('0xd7'));}var _0x56596c=_0x1d09ce['body'][_0xc1cf('0xd3')][_0xc1cf('0x53')](',');var _0x3ce8f=_0x1d09ce[_0xc1cf('0x9a')][_0xc1cf('0xd5')][_0xc1cf('0x53')](',');if(!_0x56596c[_0xc1cf('0x34')]||!_0x3ce8f[_0xc1cf('0x34')]||_0x56596c['length']!==_0x3ce8f[_0xc1cf('0x34')]){throw new Error(_0xc1cf('0xd8'));}_0x1d09ce[_0xc1cf('0x9a')][_0xc1cf('0x3b')]=_[_0xc1cf('0xd9')](_0x56596c,_0x3ce8f);if(!_0x1d09ce[_0xc1cf('0x9a')][_0xc1cf('0x3b')][_0xc1cf('0xc4')]){throw new Error(_0xc1cf('0xda'));}if(!_0x1d09ce['body'][_0xc1cf('0x3b')][_0xc1cf('0xdb')]){throw new Error('No\x20firstName\x20column\x20specified');}var _0xc7d645=path[_0xc1cf('0x9e')](config[_0xc1cf('0xdc')],_0xc1cf('0xdd'),_0x1d09ce[_0xc1cf('0xde')][_0xc1cf('0xdf')]);fs[_0xc1cf('0xe0')](_0xc7d645,parseInt(_0xc1cf('0xe1'),0x8));var _0x4ca69c=require(_0xc1cf('0xe2'))[_0xc1cf('0xe3')](path[_0xc1cf('0x9e')](__dirname,_0xc1cf('0xe4')),[_0xc7d645,_0x1d09ce['body']['binding_keys'],_0x1d09ce[_0xc1cf('0x9a')]['binding_values'],_0x1d09ce['body']['ListId'],_0x1d09ce['body'][_0xc1cf('0xe5')],_0x1d09ce[_0xc1cf('0x9a')]['duplicates'],_0x1d09ce[_0xc1cf('0x9a')][_0xc1cf('0xd6')]]);return _0x56ee71[_0xc1cf('0x1d')](0xc8)[_0xc1cf('0x20')]({'message':'File\x20uploaded\x20correctly!','pid':_0x4ca69c[_0xc1cf('0xe6')]});}catch(_0xff8359){return _0x56ee71['status'](0x1f4)[_0xc1cf('0x2a')](_0xff8359);}};exports[_0xc1cf('0xe7')]=function(_0x106d18,_0x1a16c1,_0x3876ef){var _0x2bbc27=fs[_0xc1cf('0xe8')](_0x106d18[_0xc1cf('0xde')]['path']);Papa[_0xc1cf('0xe9')](_0x2bbc27,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0xdab271){return _0x1a16c1['status'](0xc8)['json']({'file':_0x106d18[_0xc1cf('0xde')],'fields':_0xdab271['meta'][_0xc1cf('0x3b')]});}});};exports[_0xc1cf('0xea')]=function(_0x249dad,_0x3588ef,_0x4773e8){return db[_0xc1cf('0x57')][_0xc1cf('0x94')]({'raw':!![],'attributes':['id'],'where':{'role':_0xc1cf('0x7a')}})[_0xc1cf('0x25')](function(_0x4fc772){var _0x354f90=![];if(!_0x249dad['body'][_0xc1cf('0x62')]){throw new Error(_0xc1cf('0xd2'));}if(!_0x249dad['body'][_0xc1cf('0xeb')]['phone']){throw new Error(_0xc1cf('0xda'));}if(!_0x249dad[_0xc1cf('0x9a')][_0xc1cf('0xeb')]['firstName']){throw new Error(_0xc1cf('0xec'));}if(!_0x249dad['body'][_0xc1cf('0xd6')]){throw new Error(_0xc1cf('0xd7'));}var _0x35507b=require(_0xc1cf('0xe2'))[_0xc1cf('0xe3')](path[_0xc1cf('0x9e')](__dirname,_0xc1cf('0xed')),[_0x249dad['params']['id'],JSON[_0xc1cf('0xee')](_0x249dad[_0xc1cf('0x9a')]),JSON['stringify'](_0x4fc772)]);_0x35507b['on'](_0xc1cf('0xef'),function(_0x1f38e3){_0x354f90=!![];return _0x3588ef['status'](0xc8)['json']({'message':_0xc1cf('0xf0'),'pid':_0x35507b[_0xc1cf('0xe6')]});});_0x35507b['on'](_0xc1cf('0xf1'),function(_0x5d6dc0){if(_0x5d6dc0&&!_0x354f90){return _0x3588ef['status'](0x1f4)[_0xc1cf('0x20')]({'message':_0xc1cf('0xf2'),'pid':_0x35507b['pid']});}});})[_0xc1cf('0x91')](handleError(_0x3588ef,null));};
\ No newline at end of file
+var _0x984b=['push','CmCustomField','findOne','trimStart','all','fieldType','type','model','query','intersection','attributes','hasOwnProperty','nolimit','order','sort','where','filters','pick','select','field','color','from','cm_contacts','left_join','cm_user_has_contacts','cm_contact_has_tags','tools_tags','t.id\x20=\x20ct.TagId','c.deletedAt\x20IS\x20NULL','expr','search','parseSearch','conditions','find','value','split','map','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','and','uc.UserId\x20=\x20?','dateOfBirth','datetime','castTo','DATE','buildExpression','text','start','filter','isNil','isEmpty','c.ListId\x20IN\x20?','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','tag','isArray','replace','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','c.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?','group','Sequelize','c.id','DESC','having','t.id\x20IN\x20?','resolve','user','agent','some','getLists','c.ListId\x20IS\x20NULL','role','sequelize','toString','keyBy','merge','fields','c.mobile','c.fax','c.ListId','c.createdAt','c.CompanyId','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','Tags','rows','catch','CmContact','describe','tags','cf_','columnName','displayName','findAll','custom','values','body','get','join','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','info','[CmContact][merge][destroy][CmHopper],\x20%s','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatOfflineMessage','MailInteraction','MailMessage','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappMessage','WhatsappQueueReport','destroy','bulkCreate','each','duplicates','ListId','findOrCreate','spread','show','params','Tag','$and','format','cf_%d','omit','pickBy','startsWith','table','toParam','phone','rawAttributes','getTags','setTags','ContactId','options','includeAll','include','getHopperHistories','CmHopperFinal','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','binding_keys','binding_values','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','server/files/tmp','0777','File\x20uploaded\x20correctly!','upload','createReadStream','file','path','parse','import','User','binding','child_process','fork','../../components/import/cm/csv2','message','start\x20child\x20process\x20correctly!','pid','getJourney','mail','chat','sms','openchannel','fax','whatsapp','voice','-createdAt','channel','includes','Invalid\x20channel','toLowerCase','range','isValid','Invalid\x20date\x20for\x20range\x20from\x20filter','Invalid\x20date\x20for\x20range\x20to\x20filter','Invalid\x20createdAt\x20filter','uniqueid','source','starttime','duration','note','userDisposition','userSecondDisposition','userThirdDisposition','fullname','alias','createdAt','findAndCountAll','closed','closedAt','disposition','thirdDisposition','UserId','Account','key','Owner','browserName','customerIp','deviceModel','osName','ratingMessage','substatus','externalUrl','threadId','startCase','sortBy','slice','zip-dir','fast-json-patch','request-promise','mustache','util','to-csv','ejs','squel','crypto','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','redis','localhost','./cmContact.socket','sendStatus','status','json','count','offset','limit','set','Content-Range','apply','reject','save','update','then','end','error','stack','name','send','index','keys','length'];(function(_0x3d42d8,_0x4cffaa){var _0x27fc41=function(_0x3a363b){while(--_0x3a363b){_0x3d42d8['push'](_0x3d42d8['shift']());}};_0x27fc41(++_0x4cffaa);}(_0x984b,0xee));var _0xb984=function(_0x28382e,_0x92fc02){_0x28382e=_0x28382e-0x0;var _0x49a909=_0x984b[_0x28382e];return _0x49a909;};'use strict';var pdf=require('html-pdf');var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0xb984('0x0'));var jsonpatch=require(_0xb984('0x1'));var rp=require(_0xb984('0x2'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0xb984('0x3'));var util=require(_0xb984('0x4'));var path=require('path');var sox=require('sox');var csv=require(_0xb984('0x5'));var ejs=require(_0xb984('0x6'));var fs=require('fs');var _=require('lodash');var squel=require(_0xb984('0x7'));var crypto=require(_0xb984('0x8'));var jsforce=require('jsforce');var deskjs=require(_0xb984('0x9'));var toCsv=require('to-csv');var querystring=require(_0xb984('0xa'));var Papa=require(_0xb984('0xb'));var Redis=require(_0xb984('0xc'));var authService=require(_0xb984('0xd'));var qs=require(_0xb984('0xe'));var as=require(_0xb984('0xf'));var hardwareService=require(_0xb984('0x10'));var logger=require(_0xb984('0x11'))(_0xb984('0x12'));var utils=require(_0xb984('0x13'));var config=require(_0xb984('0x14'));var licenseUtil=require(_0xb984('0x15'));var db=require('../../mysqldb')['db'];config[_0xb984('0x16')]=_['defaults'](config[_0xb984('0x16')],{'host':_0xb984('0x17'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0xb984('0x16')]));require(_0xb984('0x18'))['register'](socket);function respondWithStatusCode(_0x203dba,_0x7a1b60){_0x7a1b60=_0x7a1b60||0xcc;return function(_0x549791){if(_0x549791){return _0x203dba[_0xb984('0x19')](_0x7a1b60);}return _0x203dba[_0xb984('0x1a')](_0x7a1b60)['end']();};}function respondWithResult(_0x6fae41,_0x5cd1aa){_0x5cd1aa=_0x5cd1aa||0xc8;return function(_0x3b8241){if(_0x3b8241){return _0x6fae41[_0xb984('0x1a')](_0x5cd1aa)[_0xb984('0x1b')](_0x3b8241);}};}function respondWithFilteredResult(_0x3f7cff,_0x59dcb7){return function(_0x396c36){if(_0x396c36){var _0x35bd75=_0x396c36[_0xb984('0x1c')],_0x3a5c96=_0x59dcb7['offset'],_0x9afbee=_0x59dcb7[_0xb984('0x1d')]+_0x59dcb7[_0xb984('0x1e')],_0x229a40;if(_0x9afbee>=_0x35bd75){_0x9afbee=_0x35bd75;_0x229a40=0xc8;}else{_0x229a40=0xce;}_0x3f7cff[_0xb984('0x1a')](_0x229a40);return _0x3f7cff[_0xb984('0x1f')](_0xb984('0x20'),_0x3a5c96+'-'+_0x9afbee+'/'+_0x35bd75)[_0xb984('0x1b')](_0x396c36);}return null;};}function patchUpdates(_0x54dd81){return function(_0x39d16f){try{jsonpatch[_0xb984('0x21')](_0x39d16f,_0x54dd81,!![]);}catch(_0x551ad4){return BPromise[_0xb984('0x22')](_0x551ad4);}return _0x39d16f[_0xb984('0x23')]();};}function saveUpdates(_0x14734a,_0x932579){return function(_0x3ad8d7){if(_0x3ad8d7){return _0x3ad8d7[_0xb984('0x24')](_0x14734a)[_0xb984('0x25')](function(_0x52c581){return _0x52c581;});}return null;};}function removeEntity(_0x391a1e,_0x25de23){return function(_0x1b6be3){if(_0x1b6be3){return _0x1b6be3['destroy']()[_0xb984('0x25')](function(){_0x391a1e[_0xb984('0x1a')](0xcc)[_0xb984('0x26')]();});}};}function handleEntityNotFound(_0x2d0450,_0x1f7b62){return function(_0x24b278){if(!_0x24b278){_0x2d0450[_0xb984('0x19')](0x194);}return _0x24b278;};}function handleError(_0x4b3da0,_0x5d93d9){_0x5d93d9=_0x5d93d9||0x1f4;return function(_0x249d47){logger[_0xb984('0x27')](_0x249d47[_0xb984('0x28')]);if(_0x249d47[_0xb984('0x29')]){delete _0x249d47['name'];}_0x4b3da0[_0xb984('0x1a')](_0x5d93d9)[_0xb984('0x2a')](_0x249d47);};}exports[_0xb984('0x2b')]=function(_0x482a9f,_0x363e33){var _0x311e22={},_0x2012ca={},_0x3d2757={'count':0x0,'rows':[]};return db['CmContact']['describe']()['then'](function(_0x10b9ac){var _0x23ecf6=[];for(var _0x58a98c=0x0;_0x58a98c<Object[_0xb984('0x2c')](_0x10b9ac)[_0xb984('0x2d')];_0x58a98c++){var _0x30d338=Object[_0xb984('0x2c')](_0x10b9ac)[_0x58a98c];if(_['startsWith'](_0x30d338,'cf_')){_0x23ecf6[_0xb984('0x2e')](db[_0xb984('0x2f')][_0xb984('0x30')]({'where':{'id':_[_0xb984('0x31')](_0x30d338,'cf_')},'raw':!![]}));}}return BPromise[_0xb984('0x32')](_0x23ecf6)[_0xb984('0x25')](function(_0x1805e4){for(var _0x3c4687=0x0;_0x3c4687<_0x1805e4[_0xb984('0x2d')];_0x3c4687++){if(_0x1805e4[_0x3c4687]){var _0xaf5cca='cf_'+_0x1805e4[_0x3c4687]['id'];var _0x54a293=_0x10b9ac[_0xaf5cca];_0x54a293[_0xb984('0x33')]=_0x1805e4[_0x3c4687][_0xb984('0x34')];}}return _0x10b9ac;});})[_0xb984('0x25')](function(_0x371c6a){_0x2012ca[_0xb984('0x35')]=_['keys'](_0x371c6a);_0x2012ca[_0xb984('0x36')]=_[_0xb984('0x2c')](_0x482a9f['query']);_0x2012ca['filters']=_[_0xb984('0x37')](_0x2012ca['model'],_0x2012ca[_0xb984('0x36')]);_0x311e22[_0xb984('0x38')]=_['intersection'](_0x2012ca[_0xb984('0x35')],qs['fields'](_0x482a9f[_0xb984('0x36')]['fields']));_0x311e22[_0xb984('0x38')]=_0x311e22['attributes']['length']?_0x311e22[_0xb984('0x38')]:_0x2012ca[_0xb984('0x35')];if(!_0x482a9f['query'][_0xb984('0x39')](_0xb984('0x3a'))){_0x311e22['limit']=qs[_0xb984('0x1e')](_0x482a9f[_0xb984('0x36')][_0xb984('0x1e')]);_0x311e22[_0xb984('0x1d')]=qs['offset'](_0x482a9f[_0xb984('0x36')][_0xb984('0x1d')]);}_0x311e22[_0xb984('0x3b')]=qs[_0xb984('0x3c')](_0x482a9f[_0xb984('0x36')][_0xb984('0x3c')]);_0x311e22[_0xb984('0x3d')]=qs[_0xb984('0x3e')](_[_0xb984('0x3f')](_0x482a9f[_0xb984('0x36')],_0x2012ca['filters']),_0x371c6a);var _0x134ba5=[];var _0xd10521=squel[_0xb984('0x40')]()[_0xb984('0x41')]('id')[_0xb984('0x41')](_0xb984('0x29'))[_0xb984('0x41')](_0xb984('0x42'))['from']('tools_tags');var _0x1037fd=squel['select']()[_0xb984('0x43')](_0xb984('0x44'),'c')[_0xb984('0x45')](_0xb984('0x46'),'uc','uc.CmContactId\x20=\x20c.id')[_0xb984('0x45')](_0xb984('0x47'),'ct','ct.CmContactId\x20=\x20c.id')[_0xb984('0x45')](_0xb984('0x48'),'t',_0xb984('0x49'))[_0xb984('0x3d')](_0xb984('0x4a'));var _0x3c8401=squel[_0xb984('0x4b')]();var _0x587c19=[];var _0xbca7cd=squel[_0xb984('0x4b')]();var _0x4f6f2b;if(_0x482a9f['query'][_0xb984('0x4c')]){_0x4f6f2b=as[_0xb984('0x4d')](_0x482a9f[_0xb984('0x36')][_0xb984('0x4c')]);var _0x1acc7a=_0x4f6f2b['sqlOperator'];for(var _0x664cb1=0x0;_0x664cb1<_0x4f6f2b[_0xb984('0x4e')][_0xb984('0x2d')];_0x664cb1++){var _0x25413d=_0x4f6f2b[_0xb984('0x4e')][_0x664cb1];var _0x44865b='c';var _0x2097e6=_(_0x371c6a)[_0xb984('0x2c')]()[_0xb984('0x4f')](function(_0x271c48){return _0x271c48===_0x25413d['field'];});if(_0x2097e6)_0x2097e6=_0x371c6a[_0x25413d[_0xb984('0x41')]];if(!_0x2097e6){if(_0x25413d[_0xb984('0x41')]==='Tag'){var _0x1ba546=_0x25413d[_0xb984('0x50')][_0xb984('0x51')](',')[_0xb984('0x52')](function(_0x2052f0){return Number(_0x2052f0);});_0x1ba546[_0xb984('0x53')](function(_0x10f813){_0xbca7cd['or'](_0xb984('0x54'),'%,'+_0x10f813+',%');});_0x587c19=_[_0xb984('0x55')](_0x587c19,_0x1ba546);}else if(_0x25413d[_0xb984('0x41')]==='User'){_0x3c8401[_0xb984('0x56')](_0xb984('0x57'),_0x25413d[_0xb984('0x50')]);}}else{if(_0x25413d[_0xb984('0x41')]===_0xb984('0x58')||_0x2097e6[_0xb984('0x33')]===_0xb984('0x59'))_0x25413d[_0xb984('0x5a')]=_0xb984('0x5b');var _0x5c3d82=as[_0xb984('0x5c')](_0x44865b,_0x2097e6[_0xb984('0x34')],_0x25413d);_0x3c8401[_0x1acc7a](_0x5c3d82[_0xb984('0x5d')],_0x5c3d82['value'][_0xb984('0x5e')],_0x5c3d82[_0xb984('0x50')]['end']);}}}else{var _0xdb477=_(Object['keys'](_0x482a9f[_0xb984('0x36')]))[_0xb984('0x52')](function(_0x5a1a34){return _0x371c6a[_0xb984('0x39')](_0x5a1a34)?_0x5a1a34:undefined;})[_0xb984('0x5f')](function(_0x22afea){return!_[_0xb984('0x60')](_0x22afea);})[_0xb984('0x50')]();if(_0x482a9f[_0xb984('0x36')]['Contact'])_0xdb477[_0xb984('0x2e')]('Contact');if(!_[_0xb984('0x61')](_0xdb477)){_0xdb477[_0xb984('0x53')](function(_0x260825){if(_0x260825==='ListId'){_0x1037fd['where'](_0xb984('0x62'),[][_0xb984('0x63')](_0x482a9f['query'][_0x260825]));}else if(_0x260825==='Contact'){var _0x1e8847='%'+_0x482a9f[_0xb984('0x36')][_0x260825]+'%';_0x1037fd[_0xb984('0x3d')](_0xb984('0x64'),_0x1e8847);}else{_0x1037fd[_0xb984('0x3d')]('c.'+_0x260825+_0xb984('0x65'),_0x482a9f['query'][_0x260825]);}});}if(_0x482a9f['query'][_0xb984('0x66')]){_0x587c19=_[_0xb984('0x67')](_0x482a9f['query'][_0xb984('0x66')])?_0x482a9f[_0xb984('0x36')][_0xb984('0x66')]:new Array(_0x482a9f[_0xb984('0x36')]['tag']);_0x587c19['forEach'](function(_0x226db2){_0xbca7cd['or'](_0xb984('0x54'),'%,'+_0x226db2+',%');});}if(_0x482a9f[_0xb984('0x36')][_0xb984('0x5f')]){var _0x3bdadc=_0x482a9f[_0xb984('0x36')]['filter'][_0xb984('0x68')]('\x5c','\x5c\x5c')[_0xb984('0x68')](/'/g,'\x27\x27');if(_0x3bdadc[_0xb984('0x51')]('\x20')[_0xb984('0x2d')]>0x1){_0x3c8401['or'](_0xb984('0x69'),qs[_0xb984('0x6a')](_0x3bdadc),null);}else{if(qs['isNumeric'](_0x3bdadc)){_0x3c8401['or']('c.id\x20LIKE\x20?',_0x3bdadc+'%');_0x3c8401['or']('c.phone\x20LIKE\x20?',_0x3bdadc+'%');_0x3c8401['or'](_0xb984('0x6b'),_0x3bdadc+'%');_0x3c8401['or'](_0xb984('0x6c'),_0x3bdadc+'%');}else if(qs[_0xb984('0x6d')](_0x3bdadc)){_0x3c8401['or'](_0xb984('0x6e'),_0x3bdadc+'%');}else{_0x3c8401['or'](_0xb984('0x6f'),'%'+_0x3bdadc+'%');_0x3c8401['or']('c.lastName\x20LIKE\x20?','%'+_0x3bdadc+'%');_0x3c8401['or'](_0xb984('0x6e'),'%'+_0x3bdadc+'%');}}}}_0x1037fd[_0xb984('0x3d')](_0x3c8401);_0x1037fd[_0xb984('0x70')]('c.id');var _0x935abe={'type':db[_0xb984('0x71')]['QueryTypes']['SELECT'],'raw':!![]};var _0xaa9894=_0x1037fd['clone']()['field'](_0xb984('0x72'));if(_0x311e22['order']){_0x311e22[_0xb984('0x3b')][_0xb984('0x53')](function(_0x3a2d1a){_0x1037fd[_0xb984('0x3b')]('c.'+_0x3a2d1a[0x0],_0x3a2d1a[0x1]===_0xb984('0x73')?![]:!![]);});}if(!_[_0xb984('0x61')](_0x587c19)){_0x1037fd[_0xb984('0x74')](_0xbca7cd);_0xaa9894[_0xb984('0x3d')](_0xb984('0x75'),_0x587c19);}BPromise[_0xb984('0x76')]()[_0xb984('0x25')](function(){if(!_0x4f6f2b)return;if(_0x482a9f[_0xb984('0x77')]['role']!==_0xb984('0x78'))return;if(!_[_0xb984('0x79')](_0x4f6f2b[_0xb984('0x4e')],['field','User'])){return _0x482a9f[_0xb984('0x77')][_0xb984('0x7a')]({'attributes':['id'],'raw':!![]})[_0xb984('0x25')](function(_0x531c9f){if(_[_0xb984('0x61')](_0x531c9f)){_0xaa9894[_0xb984('0x3d')](_0xb984('0x7b'));_0x1037fd[_0xb984('0x3d')](_0xb984('0x7b'));}else{_0xaa9894[_0xb984('0x3d')](_0xb984('0x62'),_[_0xb984('0x52')](_0x531c9f,'id'));_0x1037fd[_0xb984('0x3d')](_0xb984('0x62'),_[_0xb984('0x52')](_0x531c9f,'id'));}});}})[_0xb984('0x25')](function(){if(_0x482a9f[_0xb984('0x77')][_0xb984('0x7c')]==='agent'&&!_0x4f6f2b&&!_0x482a9f[_0xb984('0x36')]['ListId'])return[];return db[_0xb984('0x7d')]['query'](_0xaa9894[_0xb984('0x7e')](),_0x935abe);})[_0xb984('0x25')](function(_0x278a0d){_0x3d2757[_0xb984('0x1c')]=_0x278a0d[_0xb984('0x2d')];if(_0x3d2757[_0xb984('0x1c')]===0x0)return[];return db[_0xb984('0x7d')][_0xb984('0x36')](_0xd10521[_0xb984('0x7e')](),_0x935abe)[_0xb984('0x25')](function(_0x2976f1){_0x134ba5=_[_0xb984('0x7f')](_0x2976f1,'id');_0x935abe=_[_0xb984('0x80')](_0x935abe,{'model':db['CmContact'],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x482a9f['query'][_0xb984('0x81')]){_0x311e22[_0xb984('0x38')][_0xb984('0x53')](function(_0x48f52d){_0x1037fd[_0xb984('0x41')]('c.'+_0x48f52d);});}else{_0x1037fd[_0xb984('0x41')]('c.id');_0x1037fd['field']('c.firstName');_0x1037fd[_0xb984('0x41')]('c.lastName');_0x1037fd['field']('c.phone');_0x1037fd[_0xb984('0x41')](_0xb984('0x82'));_0x1037fd[_0xb984('0x41')](_0xb984('0x83'));_0x1037fd['field']('c.email');_0x1037fd[_0xb984('0x41')](_0xb984('0x84'));_0x1037fd[_0xb984('0x41')](_0xb984('0x85'));_0x1037fd[_0xb984('0x41')]('c.deletedAt');_0x1037fd[_0xb984('0x41')](_0xb984('0x86'));_0x1037fd[_0xb984('0x41')](_0xb984('0x87'),_0xb984('0x88'));}if(_0x311e22[_0xb984('0x1e')])_0x1037fd['limit'](_0x311e22[_0xb984('0x1e')]);if(_0x311e22['offset'])_0x1037fd[_0xb984('0x1d')](_0x311e22[_0xb984('0x1d')]);return db[_0xb984('0x7d')][_0xb984('0x36')](_0x1037fd[_0xb984('0x7e')](),_0x935abe);});})['then'](function(_0x218f6f){_0x218f6f[_0xb984('0x53')](function(_0x1f0e09){if(_0x1f0e09['TagIds']){_0x1f0e09[_0xb984('0x89')]=[];_0x1f0e09[_0xb984('0x88')][_0xb984('0x51')](',')[_0xb984('0x53')](function(_0x20c803){_0x1f0e09['Tags']['push'](_0x134ba5[_0x20c803]);});}delete _0x1f0e09[_0xb984('0x88')];});_0x3d2757[_0xb984('0x8a')]=_0x218f6f;return _0x3d2757;})[_0xb984('0x25')](respondWithFilteredResult(_0x363e33,_0x311e22));})[_0xb984('0x8b')](handleError(_0x363e33,null));};exports['destroy']=function(_0x24f309,_0x34ce92){return db[_0xb984('0x8c')][_0xb984('0x4f')]({'where':{'id':_0x24f309['params']['id']}})[_0xb984('0x25')](handleEntityNotFound(_0x34ce92,null))[_0xb984('0x25')](removeEntity(_0x34ce92,null))[_0xb984('0x8b')](handleError(_0x34ce92,null));};exports[_0xb984('0x8d')]=function(_0x484a35,_0x14cd2c){return db[_0xb984('0x8c')][_0xb984('0x8d')]()[_0xb984('0x25')](function(_0x46e5c7){delete _0x46e5c7[_0xb984('0x8e')];for(var _0x540ce=0x0;_0x540ce<Object[_0xb984('0x2c')](_0x46e5c7)[_0xb984('0x2d')];_0x540ce++){var _0xed7c82=Object[_0xb984('0x2c')](_0x46e5c7)[_0x540ce];if(!_['startsWith'](_0xed7c82,_0xb984('0x8f'))){_0x46e5c7[_0xed7c82][_0xb984('0x90')]=_0xed7c82;_0x46e5c7[_0xed7c82][_0xb984('0x91')]=_0xed7c82;}}return _0x46e5c7;})[_0xb984('0x25')](function(_0x15aef0){var _0x204730={'where':{'$or':[{'ListId':_0x484a35['query']['id']},{'ListId':null}]},'raw':!![]};return db[_0xb984('0x2f')][_0xb984('0x92')](_0x204730)[_0xb984('0x25')](function(_0x3d94fc){for(var _0x504ab9=0x0;_0x504ab9<_0x3d94fc[_0xb984('0x2d')];_0x504ab9++){var _0x13479b='cf_'+_0x3d94fc[_0x504ab9]['id'];_0x15aef0[_0x13479b][_0xb984('0x90')]=_0x13479b;_0x15aef0[_0x13479b]['displayName']=_0x3d94fc[_0x504ab9]['alias'];_0x15aef0[_0x13479b][_0xb984('0x93')]={'type':_0x3d94fc[_0x504ab9][_0xb984('0x34')],'values':_0x3d94fc[_0x504ab9][_0xb984('0x94')]};}Object[_0xb984('0x2c')](_0x15aef0)[_0xb984('0x53')](function(_0x3ce085){if(!_0x15aef0[_0x3ce085][_0xb984('0x39')](_0xb984('0x90'))){delete _0x15aef0[_0x3ce085];}});return _0x15aef0;});})[_0xb984('0x25')](respondWithResult(_0x14cd2c,null))['catch'](handleError(_0x14cd2c,null));};exports['merge']=function(_0x390b58,_0x4b76f6){var _0x1e65dc;var _0x24558c;var _0x486013;if(_0x390b58[_0xb984('0x95')]['id']){delete _0x390b58[_0xb984('0x95')]['id'];}return db[_0xb984('0x8c')][_0xb984('0x92')]({'where':{'id':[_0x390b58[_0xb984('0x95')]['to'],_0x390b58[_0xb984('0x95')]['from']]}})[_0xb984('0x25')](function(_0x5cb351){if(_0x5cb351){if(_0x5cb351[_0xb984('0x2d')]!==0x2){return null;}_0x5cb351[0x0]=_0x5cb351[0x0]['get']({'plain':!![]});_0x5cb351[0x1]=_0x5cb351[0x1][_0xb984('0x96')]({'plain':!![]});delete _0x5cb351[0x0]['id'];delete _0x5cb351[0x1]['id'];return _['mergeWith'](_0x5cb351[0x0],_0x5cb351[0x1],function(_0x55d92d,_0x28b95d){if(Array[_0xb984('0x67')](_0x28b95d)&&!_0x28b95d['length']){return _0x55d92d;}else if(!_0x28b95d){return _0x55d92d;}});}})[_0xb984('0x25')](handleEntityNotFound(_0x4b76f6,null))[_0xb984('0x25')](function(_0x1eecfd){if(_0x1eecfd){if(_0x1eecfd[_0xb984('0x8e')]&&_[_0xb984('0x67')](_0x1eecfd['tags'])){_0x1eecfd['tags']=_0x1eecfd[_0xb984('0x8e')][_0xb984('0x97')]();}logger['info'](_0xb984('0x98'),_0x390b58[_0xb984('0x95')]['to'],_0x390b58[_0xb984('0x95')]['from']);return db[_0xb984('0x99')]['destroy']({'where':{'ContactId':[_0x390b58[_0xb984('0x95')]['to'],_0x390b58[_0xb984('0x95')]['from']]}})[_0xb984('0x25')](function(_0x1f13cf){logger[_0xb984('0x9a')](_0xb984('0x9b'),_0x1f13cf);return db['CmHopperBlack']['destroy']({'where':{'ContactId':[_0x390b58['body']['to'],_0x390b58['body']['from']]}})[_0xb984('0x25')](function(_0x431b44){logger[_0xb984('0x9a')](_0xb984('0x9c'),_0x431b44);return db[_0xb984('0x8c')][_0xb984('0x9d')](_0x1eecfd);});});}})['then'](function(_0x1e738b){if(_0x1e738b){_0x1e65dc=_0x1e738b;_0x24558c={'ContactId':_0x1e65dc['id']};_0x486013={'where':{'ContactId':[_0x390b58['body']['to'],_0x390b58['body'][_0xb984('0x43')]]}};return db['ChatInteraction'][_0xb984('0x24')](_0x24558c,_0x486013);}})[_0xb984('0x25')](function(){if(_0x1e65dc){return db['ChatMessage'][_0xb984('0x24')](_0x24558c,_0x486013);}})[_0xb984('0x25')](function(){if(_0x1e65dc){return db[_0xb984('0x9e')][_0xb984('0x24')](_0x24558c,_0x486013);}})[_0xb984('0x25')](function(){if(_0x1e65dc){return db[_0xb984('0x9f')][_0xb984('0x24')](_0x24558c,_0x486013);}})[_0xb984('0x25')](function(){if(_0x1e65dc){return db[_0xb984('0xa0')][_0xb984('0x24')](_0x24558c,_0x486013);}})[_0xb984('0x25')](function(){if(_0x1e65dc){return db[_0xb984('0x9f')][_0xb984('0x24')](_0x24558c,_0x486013);}})['then'](function(){if(_0x1e65dc){return db[_0xb984('0xa0')]['update'](_0x24558c,_0x486013);}})[_0xb984('0x25')](function(){if(_0x1e65dc){return db['SmsInteraction'][_0xb984('0x24')](_0x24558c,_0x486013);}})[_0xb984('0x25')](function(){if(_0x1e65dc){return db[_0xb984('0xa1')][_0xb984('0x24')](_0x24558c,_0x486013);}})[_0xb984('0x25')](function(){if(_0x1e65dc){return db[_0xb984('0xa2')][_0xb984('0x24')](_0x24558c,_0x486013);}})['then'](function(){if(_0x1e65dc){return db[_0xb984('0xa3')][_0xb984('0x24')](_0x24558c,_0x486013);}})[_0xb984('0x25')](function(){if(_0x1e65dc){return db[_0xb984('0xa4')][_0xb984('0x24')](_0x24558c,_0x486013);}})[_0xb984('0x25')](function(){if(_0x1e65dc){return db[_0xb984('0xa5')][_0xb984('0x24')](_0x24558c,_0x486013);}})[_0xb984('0x25')](function(){if(_0x1e65dc){return db['CmHopperFinal'][_0xb984('0x24')](_0x24558c,_0x486013);}})[_0xb984('0x25')](function(){if(_0x1e65dc){return db[_0xb984('0xa6')][_0xb984('0x24')](_0x24558c,_0x486013);}})[_0xb984('0x25')](function(){if(_0x1e65dc){return db[_0xb984('0xa7')][_0xb984('0x24')](_0x24558c,_0x486013);}})[_0xb984('0x25')](function(){if(_0x1e65dc){return db[_0xb984('0xa8')][_0xb984('0x24')](_0x24558c,_0x486013);}})['then'](function(){if(_0x1e65dc){return db[_0xb984('0xa9')]['update'](_0x24558c,_0x486013);}})[_0xb984('0x25')](function(){if(_0x1e65dc){return db[_0xb984('0xaa')][_0xb984('0x24')](_0x24558c,_0x486013);}})[_0xb984('0x25')](function(){if(_0x1e65dc){return db[_0xb984('0xab')]['update'](_0x24558c,_0x486013);}})[_0xb984('0x25')](function(){if(_0x1e65dc){return db[_0xb984('0xac')]['update'](_0x24558c,_0x486013);}})[_0xb984('0x25')](function(){if(_0x1e65dc){return db[_0xb984('0xad')][_0xb984('0x24')](_0x24558c,_0x486013);}})['then'](function(){if(_0x1e65dc){return db[_0xb984('0xae')][_0xb984('0x24')](_0x24558c,_0x486013);}})[_0xb984('0x25')](function(){if(_0x1e65dc){return db[_0xb984('0xaf')][_0xb984('0x24')](_0x24558c,_0x486013);}})[_0xb984('0x25')](function(){if(_0x1e65dc){return db[_0xb984('0xb0')][_0xb984('0x24')](_0x24558c,_0x486013);}})[_0xb984('0x25')](function(){if(_0x1e65dc){return db[_0xb984('0xb1')]['update'](_0x24558c,_0x486013);}})['then'](function(){if(_0x1e65dc){return db['CmContact'][_0xb984('0xb2')]({'where':{'id':[_0x390b58[_0xb984('0x95')]['to'],_0x390b58[_0xb984('0x95')][_0xb984('0x43')]]}});}})['then'](function(){if(_0x1e65dc){return _0x1e65dc;}})['then'](respondWithResult(_0x4b76f6,null))['catch'](handleError(_0x4b76f6,null));};exports[_0xb984('0x9d')]=function(_0x1c8731,_0x5e9fa1){return db[_0xb984('0x8c')]['describe']()[_0xb984('0x25')](function(_0x47b5a5){if(_0x1c8731[_0xb984('0x95')]['tags']&&_[_0xb984('0x67')](_0x1c8731[_0xb984('0x95')]['tags'])){if(_0x1c8731[_0xb984('0x95')]['tags'][_0xb984('0x2d')]){_0x1c8731[_0xb984('0x95')][_0xb984('0x8e')]=_0x1c8731[_0xb984('0x95')]['tags'][_0xb984('0x97')](';')+';';}else{_0x1c8731['body'][_0xb984('0x8e')]=null;}}else{_0x1c8731[_0xb984('0x95')][_0xb984('0x8e')]=null;}return db[_0xb984('0x8c')][_0xb984('0x9d')](_0x1c8731[_0xb984('0x95')],{'fields':_['keys'](_0x47b5a5),'raw':!![]});})[_0xb984('0x25')](respondWithResult(_0x5e9fa1,0xc9))[_0xb984('0x8b')](handleError(_0x5e9fa1,null));};exports[_0xb984('0xb3')]=function(_0x4d9ea7,_0x112867){var _0x27262c=[];var _0x314572=0x0;var _0x5e5999=0x0;var _0x26b0bf=0x0;return db[_0xb984('0x8c')][_0xb984('0x8d')]()[_0xb984('0x25')](function(_0x2060c6){return BPromise[_0xb984('0xb4')](_0x4d9ea7[_0xb984('0x95')],function(_0x4256e4){var _0x12d0ad={'where':{'$or':[]},'defaults':_0x4256e4,'fields':_['keys'](_0x2060c6),'raw':!![]};if(_0x4256e4[_0xb984('0xb5')]){for(var _0x200b2d=0x0;_0x200b2d<_0x4256e4[_0xb984('0xb5')][_0xb984('0x2d')];_0x200b2d++){var _0x2e17f4={};_0x2e17f4[_0x4256e4[_0xb984('0xb5')][_0x200b2d]]=_0x4256e4[_0x4256e4['duplicates'][_0x200b2d]];_0x12d0ad['where']['$or']['push'](_0x2e17f4);}_0x12d0ad['where'][_0xb984('0xb6')]=_0x4256e4[_0xb984('0xb6')];}return db[_0xb984('0x8c')][_0xb984('0xb7')](_0x12d0ad)[_0xb984('0xb8')](function(_0x37838e,_0xa20462){if(_0xa20462){_0x314572++;}else{_0x26b0bf++;}})[_0xb984('0x8b')](function(_0x3b777f){console[_0xb984('0x27')](_0x3b777f);_0x5e5999++;});});})[_0xb984('0x25')](function(_0x2ce13b){if(_0x2ce13b){return{'success':_0x314572,'failure':_0x5e5999,'duplicates':_0x26b0bf};}})[_0xb984('0x25')](respondWithResult(_0x112867,0xc9))[_0xb984('0x8b')](handleError(_0x112867,null));};exports[_0xb984('0xb9')]=function(_0x47229c,_0x1bdebe,_0x187ca9){var _0x2ac7fe;return db[_0xb984('0x8c')]['describe']()[_0xb984('0x25')](function(_0x340f60){return db['CmContact'][_0xb984('0x4f')]({'where':{'id':_0x47229c[_0xb984('0xba')]['id']},'include':[{'model':db[_0xb984('0xbb')],'as':_0xb984('0x89'),'attributes':['id',_0xb984('0x29'),_0xb984('0x42')],'required':_0x47229c[_0xb984('0x36')][_0xb984('0x66')]?!![]:![]}],'attributes':_[_0xb984('0x2c')](_0x340f60)});})[_0xb984('0x25')](function(_0xfd7823){_0x2ac7fe=_0xfd7823[_0xb984('0x96')]({'plain':!![]});var _0x1145e1={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0xfd7823&&_0xfd7823[_0xb984('0xb6')]){if(_0xfd7823[_0xb984('0xb6')]){_0x1145e1[_0xb984('0x3d')][_0xb984('0xbc')][_0xb984('0x2e')]({'ListId':{'$ne':_0xfd7823[_0xb984('0xb6')]}});}}return db[_0xb984('0x2f')][_0xb984('0x92')](_0x1145e1);})['then'](function(_0x3b9d2a){return _['omit'](_0x2ac7fe,_['map'](_0x3b9d2a,function(_0x3bed49){return util[_0xb984('0xbd')](_0xb984('0xbe'),_0x3bed49['id']);}));})['then'](handleEntityNotFound(_0x1bdebe,null))[_0xb984('0x25')](respondWithResult(_0x1bdebe,null))[_0xb984('0x8b')](handleError(_0x1bdebe,null));};exports[_0xb984('0x24')]=function(_0x3a55b6,_0x5d5f4e){var _0x4354c3;if(_0x3a55b6[_0xb984('0x95')]['id']){delete _0x3a55b6[_0xb984('0x95')]['id'];}return db[_0xb984('0x8c')]['find']({'where':{'id':_0x3a55b6[_0xb984('0xba')]['id']}})['then'](handleEntityNotFound(_0x5d5f4e,null))['then'](saveUpdates(_0x3a55b6[_0xb984('0x95')],null))[_0xb984('0x25')](function(_0x54b9f3){_0x4354c3=_0x54b9f3;var _0x4489d5={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x54b9f3&&_0x54b9f3[_0xb984('0xb6')]){if(_0x54b9f3[_0xb984('0xb6')]){_0x4489d5[_0xb984('0x3d')][_0xb984('0xbc')]['push']({'ListId':{'$ne':_0x54b9f3['ListId']}});}}return db['CmCustomField']['findAll'](_0x4489d5);})[_0xb984('0x25')](function(_0x261bf2){if(_0x261bf2){return _[_0xb984('0xbf')](_[_0xb984('0xc0')](_0x3a55b6[_0xb984('0x95')],function(_0x2656a6,_0x40cf23){return _[_0xb984('0xc1')](_0x40cf23,'cf_');}),_[_0xb984('0x52')](_0x261bf2,function(_0x364971){return util[_0xb984('0xbd')]('cf_%d',_0x364971['id']);}));}})[_0xb984('0x25')](function(_0x2b5452){if(_0x2b5452&&!_[_0xb984('0x61')](_0x2b5452)){var _0x461384=squel['update']()[_0xb984('0xc2')](_0xb984('0x44'))['setFields'](_0x2b5452)[_0xb984('0x3d')]('id\x20=\x20?',_0x3a55b6[_0xb984('0xba')]['id'])[_0xb984('0xc3')]();return db[_0xb984('0x7d')][_0xb984('0x36')](_0x461384[_0xb984('0x5d')],{'replacements':_0x461384[_0xb984('0x94')]});}})[_0xb984('0x25')](function(){if(_0x3a55b6[_0xb984('0x95')][_0xb984('0xc4')]&&_0x4354c3){return db['CmHopper'][_0xb984('0x24')]({'phone':_0x3a55b6[_0xb984('0x95')][_0xb984('0xc4')]},{'where':{'ContactId':_0x4354c3['id']}});}})[_0xb984('0x25')](function(){return _0x4354c3;})['then'](respondWithResult(_0x5d5f4e,null))[_0xb984('0x8b')](handleError(_0x5d5f4e,null));};exports['getTags']=function(_0x1b9c9b,_0x178bc5,_0x5f455b){var _0x1c3c00={};var _0x2c7a65={};var _0x3ea17b;var _0x33b724;return db[_0xb984('0x8c')][_0xb984('0x30')]({'where':{'id':_0x1b9c9b[_0xb984('0xba')]['id']}})[_0xb984('0x25')](handleEntityNotFound(_0x178bc5,null))[_0xb984('0x25')](function(_0x18dda5){if(_0x18dda5){_0x3ea17b=_0x18dda5;_0x2c7a65[_0xb984('0x35')]=_['keys'](db[_0xb984('0xbb')][_0xb984('0xc5')]);_0x2c7a65[_0xb984('0x36')]=_[_0xb984('0x2c')](_0x1b9c9b[_0xb984('0x36')]);_0x2c7a65[_0xb984('0x3e')]=_[_0xb984('0x37')](_0x2c7a65['model'],_0x2c7a65['query']);_0x1c3c00[_0xb984('0x38')]=_[_0xb984('0x37')](_0x2c7a65[_0xb984('0x35')],qs[_0xb984('0x81')](_0x1b9c9b[_0xb984('0x36')][_0xb984('0x81')]));_0x1c3c00['attributes']=_0x1c3c00[_0xb984('0x38')][_0xb984('0x2d')]?_0x1c3c00[_0xb984('0x38')]:_0x2c7a65[_0xb984('0x35')];_0x1c3c00[_0xb984('0x3b')]=qs[_0xb984('0x3c')](_0x1b9c9b['query']['sort']);_0x1c3c00[_0xb984('0x3d')]=qs[_0xb984('0x3e')](_[_0xb984('0x3f')](_0x1b9c9b[_0xb984('0x36')],_0x2c7a65[_0xb984('0x3e')]));if(_0x1b9c9b[_0xb984('0x36')][_0xb984('0x5f')]){_0x1c3c00[_0xb984('0x3d')]=_[_0xb984('0x80')](_0x1c3c00[_0xb984('0x3d')],{'$or':_['map'](_0x1c3c00['attributes'],function(_0x50d821){var _0x33c2f7={};_0x33c2f7[_0x50d821]={'$like':'%'+_0x1b9c9b[_0xb984('0x36')][_0xb984('0x5f')]+'%'};return _0x33c2f7;})});}_0x1c3c00=_['merge']({},_0x1c3c00,_0x1b9c9b['options']);return _0x3ea17b[_0xb984('0xc6')](_0x1c3c00);}})['then'](function(_0x5408f0){if(_0x5408f0){_0x33b724=_0x5408f0[_0xb984('0x2d')];if(!_0x1b9c9b[_0xb984('0x36')][_0xb984('0x39')]('nolimit')){_0x1c3c00['limit']=qs[_0xb984('0x1e')](_0x1b9c9b[_0xb984('0x36')][_0xb984('0x1e')]);_0x1c3c00['offset']=qs[_0xb984('0x1d')](_0x1b9c9b[_0xb984('0x36')][_0xb984('0x1d')]);}return _0x3ea17b[_0xb984('0xc6')](_0x1c3c00);}})[_0xb984('0x25')](function(_0xe1e4e1){if(_0xe1e4e1){return _0xe1e4e1?{'count':_0x33b724,'rows':_0xe1e4e1}:null;}})['then'](respondWithResult(_0x178bc5,null))[_0xb984('0x8b')](handleError(_0x178bc5,null));};exports[_0xb984('0xc7')]=function(_0x3cd609,_0x5f1130,_0x10d9eb){if(_0x3cd609[_0xb984('0x95')]['id']){delete _0x3cd609[_0xb984('0x95')]['id'];}return db['CmContact'][_0xb984('0x30')]({'where':{'id':_0x3cd609[_0xb984('0xba')]['id']}})[_0xb984('0x25')](handleEntityNotFound(_0x5f1130,null))[_0xb984('0x25')](function(_0x4bc073){if(_0x4bc073){return _0x4bc073['setTags'](_0x3cd609[_0xb984('0x95')]['ids']||[]);}return null;})[_0xb984('0x25')](respondWithResult(_0x5f1130,null))[_0xb984('0x8b')](handleError(_0x5f1130,null));};exports['getHoppers']=function(_0x1ac51b,_0x51471c,_0xc59a73){var _0x52793a={'raw':![],'where':{}};var _0x5a3c7a={};var _0x52de33={'count':0x0,'rows':[]};return db[_0xb984('0x8c')][_0xb984('0x30')]({'where':{'id':_0x1ac51b[_0xb984('0xba')]['id']}})['then'](handleEntityNotFound(_0x51471c,null))[_0xb984('0x25')](function(_0x49f484){if(_0x49f484){_0x5a3c7a[_0xb984('0x35')]=_[_0xb984('0x2c')](db[_0xb984('0x99')]['rawAttributes']);_0x5a3c7a[_0xb984('0x36')]=_[_0xb984('0x2c')](_0x1ac51b[_0xb984('0x36')]);_0x5a3c7a[_0xb984('0x3e')]=_[_0xb984('0x37')](_0x5a3c7a[_0xb984('0x35')],_0x5a3c7a[_0xb984('0x36')]);_0x52793a[_0xb984('0x38')]=_['intersection'](_0x5a3c7a[_0xb984('0x35')],qs['fields'](_0x1ac51b[_0xb984('0x36')][_0xb984('0x81')]));_0x52793a[_0xb984('0x38')]=_0x52793a[_0xb984('0x38')]['length']?_0x52793a[_0xb984('0x38')]:_0x5a3c7a['model'];if(!_0x1ac51b[_0xb984('0x36')][_0xb984('0x39')]('nolimit')){_0x52793a[_0xb984('0x1e')]=qs['limit'](_0x1ac51b[_0xb984('0x36')][_0xb984('0x1e')]);_0x52793a[_0xb984('0x1d')]=qs[_0xb984('0x1d')](_0x1ac51b[_0xb984('0x36')][_0xb984('0x1d')]);}_0x52793a[_0xb984('0x3b')]=qs[_0xb984('0x3c')](_0x1ac51b[_0xb984('0x36')][_0xb984('0x3c')]);_0x52793a[_0xb984('0x3d')]=qs[_0xb984('0x3e')](_[_0xb984('0x3f')](_0x1ac51b['query'],_0x5a3c7a[_0xb984('0x3e')]));_0x52793a['where'][_0xb984('0xc8')]=_0x49f484['id'];if(_0x1ac51b[_0xb984('0x36')]['filter']){_0x52793a['where']=_[_0xb984('0x80')](_0x52793a[_0xb984('0x3d')],{'$or':_[_0xb984('0x52')](_0x52793a[_0xb984('0x38')],function(_0x4a2b32){var _0x432575={};_0x432575[_0x4a2b32]={'$like':'%'+_0x1ac51b[_0xb984('0x36')][_0xb984('0x5f')]+'%'};return _0x432575;})});}_0x52793a=_['merge']({},_0x52793a,_0x1ac51b[_0xb984('0xc9')]);return db[_0xb984('0x99')][_0xb984('0x1c')]({'where':_0x52793a[_0xb984('0x3d')]})[_0xb984('0x25')](function(_0x54ea8e){_0x52de33[_0xb984('0x1c')]=_0x54ea8e;if(_0x1ac51b[_0xb984('0x36')][_0xb984('0xca')]){_0x52793a[_0xb984('0xcb')]=[{'all':!![]}];}return db[_0xb984('0x99')][_0xb984('0x92')](_0x52793a);})[_0xb984('0x25')](function(_0x3489fe){_0x52de33[_0xb984('0x8a')]=_0x3489fe;return _0x52de33;});}})['then'](respondWithFilteredResult(_0x51471c,_0x52793a))[_0xb984('0x8b')](handleError(_0x51471c,null));};exports[_0xb984('0xcc')]=function(_0x569f7e,_0x46d041,_0x4ec71f){var _0x4d3fcb={'raw':!![],'where':{}};var _0x1d1d8b={};var _0x38e1de={'count':0x0,'rows':[]};return db[_0xb984('0x8c')][_0xb984('0x30')]({'where':{'id':_0x569f7e[_0xb984('0xba')]['id']}})[_0xb984('0x25')](handleEntityNotFound(_0x46d041,null))['then'](function(_0x87fb63){if(_0x87fb63){_0x1d1d8b['model']=_[_0xb984('0x2c')](db[_0xb984('0xa6')][_0xb984('0xc5')]);_0x1d1d8b[_0xb984('0x36')]=_[_0xb984('0x2c')](_0x569f7e[_0xb984('0x36')]);_0x1d1d8b[_0xb984('0x3e')]=_[_0xb984('0x37')](_0x1d1d8b['model'],_0x1d1d8b[_0xb984('0x36')]);_0x4d3fcb[_0xb984('0x38')]=_[_0xb984('0x37')](_0x1d1d8b['model'],qs[_0xb984('0x81')](_0x569f7e['query'][_0xb984('0x81')]));_0x4d3fcb[_0xb984('0x38')]=_0x4d3fcb[_0xb984('0x38')]['length']?_0x4d3fcb['attributes']:_0x1d1d8b[_0xb984('0x35')];if(!_0x569f7e['query'][_0xb984('0x39')](_0xb984('0x3a'))){_0x4d3fcb['limit']=qs[_0xb984('0x1e')](_0x569f7e[_0xb984('0x36')][_0xb984('0x1e')]);_0x4d3fcb[_0xb984('0x1d')]=qs[_0xb984('0x1d')](_0x569f7e[_0xb984('0x36')][_0xb984('0x1d')]);}_0x4d3fcb[_0xb984('0x3b')]=qs['sort'](_0x569f7e[_0xb984('0x36')][_0xb984('0x3c')]);_0x4d3fcb[_0xb984('0x3d')]=qs[_0xb984('0x3e')](_[_0xb984('0x3f')](_0x569f7e[_0xb984('0x36')],_0x1d1d8b[_0xb984('0x3e')]));_0x4d3fcb[_0xb984('0x3d')][_0xb984('0xc8')]=_0x87fb63['id'];if(_0x569f7e[_0xb984('0x36')][_0xb984('0x5f')]){_0x4d3fcb[_0xb984('0x3d')]=_[_0xb984('0x80')](_0x4d3fcb[_0xb984('0x3d')],{'$or':_['map'](_0x4d3fcb[_0xb984('0x38')],function(_0x4bef26){var _0x63baf7={};_0x63baf7[_0x4bef26]={'$like':'%'+_0x569f7e[_0xb984('0x36')][_0xb984('0x5f')]+'%'};return _0x63baf7;})});}_0x4d3fcb=_[_0xb984('0x80')]({},_0x4d3fcb,_0x569f7e[_0xb984('0xc9')]);return db['CmHopperHistory'][_0xb984('0x1c')]({'where':_0x4d3fcb['where']})[_0xb984('0x25')](function(_0x2433c4){_0x38e1de['count']=_0x2433c4;if(_0x569f7e[_0xb984('0x36')][_0xb984('0xca')]){_0x4d3fcb[_0xb984('0xcb')]=[{'all':!![]}];}return db[_0xb984('0xa6')][_0xb984('0x92')](_0x4d3fcb);})[_0xb984('0x25')](function(_0x442a91){_0x38e1de['rows']=_0x442a91;return _0x38e1de;});}})['then'](respondWithFilteredResult(_0x46d041,_0x4d3fcb))['catch'](handleError(_0x46d041,null));};exports['getHopperFinals']=function(_0x3983f2,_0x4f2a22,_0x5f48c0){var _0x20d0e8={'raw':!![],'where':{}};var _0x35cd4c={};var _0x35cb7e={'count':0x0,'rows':[]};return db[_0xb984('0x8c')][_0xb984('0x30')]({'where':{'id':_0x3983f2[_0xb984('0xba')]['id']}})[_0xb984('0x25')](handleEntityNotFound(_0x4f2a22,null))[_0xb984('0x25')](function(_0x4dc6df){if(_0x4dc6df){_0x35cd4c['model']=_[_0xb984('0x2c')](db[_0xb984('0xcd')][_0xb984('0xc5')]);_0x35cd4c[_0xb984('0x36')]=_['keys'](_0x3983f2[_0xb984('0x36')]);_0x35cd4c[_0xb984('0x3e')]=_[_0xb984('0x37')](_0x35cd4c[_0xb984('0x35')],_0x35cd4c[_0xb984('0x36')]);_0x20d0e8['attributes']=_[_0xb984('0x37')](_0x35cd4c[_0xb984('0x35')],qs[_0xb984('0x81')](_0x3983f2[_0xb984('0x36')]['fields']));_0x20d0e8[_0xb984('0x38')]=_0x20d0e8[_0xb984('0x38')]['length']?_0x20d0e8[_0xb984('0x38')]:_0x35cd4c[_0xb984('0x35')];if(!_0x3983f2[_0xb984('0x36')]['hasOwnProperty']('nolimit')){_0x20d0e8[_0xb984('0x1e')]=qs['limit'](_0x3983f2[_0xb984('0x36')][_0xb984('0x1e')]);_0x20d0e8[_0xb984('0x1d')]=qs[_0xb984('0x1d')](_0x3983f2[_0xb984('0x36')][_0xb984('0x1d')]);}_0x20d0e8['order']=qs['sort'](_0x3983f2[_0xb984('0x36')][_0xb984('0x3c')]);_0x20d0e8[_0xb984('0x3d')]=qs[_0xb984('0x3e')](_[_0xb984('0x3f')](_0x3983f2[_0xb984('0x36')],_0x35cd4c['filters']));_0x20d0e8[_0xb984('0x3d')]['ContactId']=_0x4dc6df['id'];if(_0x3983f2[_0xb984('0x36')][_0xb984('0x5f')]){_0x20d0e8[_0xb984('0x3d')]=_[_0xb984('0x80')](_0x20d0e8[_0xb984('0x3d')],{'$or':_[_0xb984('0x52')](_0x20d0e8[_0xb984('0x38')],function(_0x437ac1){var _0x15759e={};_0x15759e[_0x437ac1]={'$like':'%'+_0x3983f2[_0xb984('0x36')][_0xb984('0x5f')]+'%'};return _0x15759e;})});}_0x20d0e8=_['merge']({},_0x20d0e8,_0x3983f2[_0xb984('0xc9')]);return db['CmHopperFinal'][_0xb984('0x1c')]({'where':_0x20d0e8[_0xb984('0x3d')]})[_0xb984('0x25')](function(_0xf55fde){_0x35cb7e[_0xb984('0x1c')]=_0xf55fde;if(_0x3983f2[_0xb984('0x36')][_0xb984('0xca')]){_0x20d0e8['include']=[{'all':!![]}];}return db['CmHopperFinal'][_0xb984('0x92')](_0x20d0e8);})['then'](function(_0x5441b9){_0x35cb7e[_0xb984('0x8a')]=_0x5441b9;return _0x35cb7e;});}})[_0xb984('0x25')](respondWithFilteredResult(_0x4f2a22,_0x20d0e8))[_0xb984('0x8b')](handleError(_0x4f2a22,null));};exports[_0xb984('0xce')]=function(_0x39573f,_0x4f6b25,_0x2014f0){var _0x1230a3={'raw':!![],'where':{}};var _0x5405ad={};var _0x5d6cdd={'count':0x0,'rows':[]};return db[_0xb984('0x8c')][_0xb984('0x30')]({'where':{'id':_0x39573f[_0xb984('0xba')]['id']}})[_0xb984('0x25')](handleEntityNotFound(_0x4f6b25,null))['then'](function(_0x57caf9){if(_0x57caf9){_0x5405ad['model']=_[_0xb984('0x2c')](db[_0xb984('0xae')]['rawAttributes']);_0x5405ad[_0xb984('0x36')]=_[_0xb984('0x2c')](_0x39573f[_0xb984('0x36')]);_0x5405ad[_0xb984('0x3e')]=_[_0xb984('0x37')](_0x5405ad[_0xb984('0x35')],_0x5405ad[_0xb984('0x36')]);_0x1230a3[_0xb984('0x38')]=_[_0xb984('0x37')](_0x5405ad[_0xb984('0x35')],qs['fields'](_0x39573f[_0xb984('0x36')][_0xb984('0x81')]));_0x1230a3['attributes']=_0x1230a3[_0xb984('0x38')][_0xb984('0x2d')]?_0x1230a3[_0xb984('0x38')]:_0x5405ad['model'];if(!_0x39573f[_0xb984('0x36')][_0xb984('0x39')](_0xb984('0x3a'))){_0x1230a3['limit']=qs[_0xb984('0x1e')](_0x39573f[_0xb984('0x36')][_0xb984('0x1e')]);_0x1230a3[_0xb984('0x1d')]=qs[_0xb984('0x1d')](_0x39573f['query']['offset']);}_0x1230a3[_0xb984('0x3b')]=qs[_0xb984('0x3c')](_0x39573f[_0xb984('0x36')][_0xb984('0x3c')]);_0x1230a3[_0xb984('0x3d')]=qs[_0xb984('0x3e')](_['pick'](_0x39573f[_0xb984('0x36')],_0x5405ad[_0xb984('0x3e')]));_0x1230a3[_0xb984('0x3d')][_0xb984('0xc8')]=_0x57caf9['id'];if(_0x39573f[_0xb984('0x36')]['filter']){_0x1230a3[_0xb984('0x3d')]=_[_0xb984('0x80')](_0x1230a3[_0xb984('0x3d')],{'$or':_[_0xb984('0x52')](_0x1230a3[_0xb984('0x38')],function(_0x2280ec){var _0x46278f={};_0x46278f[_0x2280ec]={'$like':'%'+_0x39573f[_0xb984('0x36')][_0xb984('0x5f')]+'%'};return _0x46278f;})});}_0x1230a3=_[_0xb984('0x80')]({},_0x1230a3,_0x39573f[_0xb984('0xc9')]);return db[_0xb984('0xae')][_0xb984('0x1c')]({'where':_0x1230a3[_0xb984('0x3d')]})[_0xb984('0x25')](function(_0x3e9239){_0x5d6cdd[_0xb984('0x1c')]=_0x3e9239;if(_0x39573f[_0xb984('0x36')]['includeAll']){_0x1230a3[_0xb984('0xcb')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0xb984('0x92')](_0x1230a3);})[_0xb984('0x25')](function(_0x1453de){_0x5d6cdd[_0xb984('0x8a')]=_0x1453de;return _0x5d6cdd;});}})['then'](respondWithFilteredResult(_0x4f6b25,_0x1230a3))['catch'](handleError(_0x4f6b25,null));};exports[_0xb984('0xcf')]=function(_0x5d8303,_0x3f914a,_0x3152f2){try{if(!_0x5d8303[_0xb984('0x95')][_0xb984('0xb6')]){throw new Error(_0xb984('0xd0'));}if(!_0x5d8303[_0xb984('0x95')][_0xb984('0xd1')]){throw new Error('No\x20association\x20keys\x20specified!');}if(!_0x5d8303[_0xb984('0x95')][_0xb984('0xd2')]){throw new Error('No\x20association\x20values\x20specified!');}if(!_0x5d8303[_0xb984('0x95')][_0xb984('0xd3')]){throw new Error(_0xb984('0xd4'));}var _0x4e8149=_0x5d8303['body']['binding_keys']['split'](',');var _0x5144b9=_0x5d8303['body']['binding_values'][_0xb984('0x51')](',');if(!_0x4e8149[_0xb984('0x2d')]||!_0x5144b9[_0xb984('0x2d')]||_0x4e8149[_0xb984('0x2d')]!==_0x5144b9['length']){throw new Error(_0xb984('0xd5'));}_0x5d8303[_0xb984('0x95')]['fields']=_[_0xb984('0xd6')](_0x4e8149,_0x5144b9);if(!_0x5d8303['body'][_0xb984('0x81')]['phone']){throw new Error(_0xb984('0xd7'));}if(!_0x5d8303['body'][_0xb984('0x81')][_0xb984('0xd8')]){throw new Error(_0xb984('0xd9'));}var _0x1cf6ed=path[_0xb984('0x97')](config['root'],_0xb984('0xda'),_0x5d8303['file']['filename']);fs['chmodSync'](_0x1cf6ed,parseInt(_0xb984('0xdb'),0x8));var _0x23e813=require('child_process')['fork'](path[_0xb984('0x97')](__dirname,'../../components/import/cm/csv'),[_0x1cf6ed,_0x5d8303['body'][_0xb984('0xd1')],_0x5d8303[_0xb984('0x95')][_0xb984('0xd2')],_0x5d8303[_0xb984('0x95')][_0xb984('0xb6')],_0x5d8303[_0xb984('0x95')]['CompanyId'],_0x5d8303[_0xb984('0x95')][_0xb984('0xb5')],_0x5d8303[_0xb984('0x95')][_0xb984('0xd3')]]);return _0x3f914a['status'](0xc8)[_0xb984('0x1b')]({'message':_0xb984('0xdc'),'pid':_0x23e813['pid']});}catch(_0x2bc86f){return _0x3f914a['status'](0x1f4)[_0xb984('0x2a')](_0x2bc86f);}};exports[_0xb984('0xdd')]=function(_0x315fae,_0x37a97c,_0xa5a46c){var _0x3be532=fs[_0xb984('0xde')](_0x315fae[_0xb984('0xdf')][_0xb984('0xe0')]);Papa[_0xb984('0xe1')](_0x3be532,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0xa2e6b7){return _0x37a97c[_0xb984('0x1a')](0xc8)['json']({'file':_0x315fae[_0xb984('0xdf')],'fields':_0xa2e6b7['meta'][_0xb984('0x81')]});}});};exports[_0xb984('0xe2')]=function(_0x4a2abb,_0x1dc7cf,_0x37f179){return db[_0xb984('0xe3')][_0xb984('0x92')]({'raw':!![],'attributes':['id'],'where':{'role':_0xb984('0x78')}})[_0xb984('0x25')](function(_0x2e94a0){var _0x194b7d=![];if(!_0x4a2abb[_0xb984('0x95')][_0xb984('0xb6')]){throw new Error(_0xb984('0xd0'));}if(!_0x4a2abb[_0xb984('0x95')][_0xb984('0xe4')][_0xb984('0xc4')]){throw new Error(_0xb984('0xd7'));}if(!_0x4a2abb['body']['binding'][_0xb984('0xd8')]){throw new Error(_0xb984('0xd9'));}if(!_0x4a2abb['body'][_0xb984('0xd3')]){throw new Error(_0xb984('0xd4'));}var _0x42ba0d=require(_0xb984('0xe5'))[_0xb984('0xe6')](path['join'](__dirname,_0xb984('0xe7')),[_0x4a2abb[_0xb984('0xba')]['id'],JSON['stringify'](_0x4a2abb[_0xb984('0x95')]),JSON['stringify'](_0x2e94a0)]);_0x42ba0d['on'](_0xb984('0xe8'),function(_0x1c1af6){_0x194b7d=!![];return _0x1dc7cf[_0xb984('0x1a')](0xc8)[_0xb984('0x1b')]({'message':_0xb984('0xe9'),'pid':_0x42ba0d[_0xb984('0xea')]});});_0x42ba0d['on']('exit',function(_0x382c23){if(_0x382c23&&!_0x194b7d){return _0x1dc7cf['status'](0x1f4)['json']({'message':'error\x20child\x20process','pid':_0x42ba0d[_0xb984('0xea')]});}});})[_0xb984('0x8b')](handleError(_0x1dc7cf,null));};exports[_0xb984('0xeb')]=function(_0xa78ecf,_0x1c5cf0){var _0x430c68=[_0xb984('0xec'),_0xb984('0xed'),_0xb984('0xee'),_0xb984('0xef'),_0xb984('0xf0'),_0xb984('0xf1'),_0xb984('0xf2')];var _0x1d5634={'offset':0x0,'order':qs[_0xb984('0x3c')](_0xb984('0xf3'))},_0x205852={'count':0x0,'rows':[]};Promise[_0xb984('0x76')]()[_0xb984('0x25')](function(){if(_0xa78ecf[_0xb984('0x36')][_0xb984('0xf4')]){if(!_[_0xb984('0xf5')](_0x430c68,_0xa78ecf['query']['channel']['toLowerCase']())){throw new Error(_0xb984('0xf6'));}_0x430c68=[_0xa78ecf[_0xb984('0x36')][_0xb984('0xf4')][_0xb984('0xf7')]()];}if(_0xa78ecf[_0xb984('0x36')][_0xb984('0xf8')]){try{var _0x441031=JSON['parse'](_0xa78ecf[_0xb984('0x36')][_0xb984('0xf8')]);if(!moment(_0x441031[_0xb984('0x43')])[_0xb984('0xf9')]()){throw new Error(_0xb984('0xfa'));}if(!moment(_0x441031['to'])[_0xb984('0xf9')]()){throw new Error(_0xb984('0xfb'));}}catch(_0x86780d){throw new Error(_0xb984('0xfc'));}}if(!_0xa78ecf[_0xb984('0x36')][_0xb984('0x39')](_0xb984('0x3a'))){_0x1d5634[_0xb984('0x1e')]=qs[_0xb984('0x1e')](_0xa78ecf[_0xb984('0x36')][_0xb984('0x1e')]||0xa);_0x1d5634[_0xb984('0x1d')]=qs[_0xb984('0x1d')](_0xa78ecf[_0xb984('0x36')][_0xb984('0x1d')]);}var _0x33dd08=_0x430c68[_0xb984('0x52')](function(_0x5514d0){if(_0x5514d0===_0xb984('0xf2')){var _0x258277={'attributes':['id',_0xb984('0xfd'),'type',_0xb984('0xfe'),'destination','callerid',_0xb984('0xff'),'endtime',_0xb984('0x100'),_0xb984('0x101'),'createdAt',_0xb984('0x102'),_0xb984('0x103'),_0xb984('0x104')],'where':{'ContactId':_0xa78ecf['params']['id']},'include':[{'model':db[_0xb984('0xe3')],'as':_0xb984('0xe3'),'attributes':['id',_0xb984('0x29'),_0xb984('0x105'),_0xb984('0x106')]}],'order':[[_0xb984('0x107'),_0xb984('0x73')]]};if(_0xa78ecf[_0xb984('0x36')][_0xb984('0xf8')]){_0x258277[_0xb984('0x3d')]['createdAt']={'$gte':_0x441031['from'],'$lte':_0x441031['to']};}return db[_0xb984('0xa8')][_0xb984('0x108')](_0x258277)[_0xb984('0x25')](function(_0x4bd400){_0x205852[_0xb984('0x1c')]+=_0x4bd400[_0xb984('0x1c')];return _[_0xb984('0x52')](_0x4bd400['rows'],function(_0x50cc24){var _0x408a0f=_0x50cc24['get']({'plain':!![]});_0x408a0f[_0xb984('0xf4')]=_0x5514d0;if(_0x408a0f['User']){_0x408a0f[_0xb984('0xe3')]={'id':_0x408a0f[_0xb984('0xe3')]['id'],'name':_0x408a0f[_0xb984('0xe3')][_0xb984('0x29')],'fullname':_0x408a0f[_0xb984('0xe3')][_0xb984('0x105')],'alias':_0x408a0f[_0xb984('0xe3')]['alias']};}return _0x408a0f;});});}else{var _0x2b2d2f=_['startCase'](_0x5514d0)+(_0x5514d0===_0xb984('0xed')?'Website':'Account');var _0x11e889={'attributes':['id',_0xb984('0x109'),_0xb984('0x10a'),_0xb984('0x107'),'note',_0xb984('0x10b'),'secondDisposition',_0xb984('0x10c'),_0xb984('0x10d'),_0x2b2d2f+'Id'],'where':{'ContactId':_0xa78ecf[_0xb984('0xba')]['id']},'include':[{'model':db[_0x2b2d2f],'as':_0xb984('0x10e'),'attributes':['id',_0xb984('0x29'),_0xb984('0x10f')]},{'model':db[_0xb984('0xe3')],'as':_0xb984('0x110'),'attributes':['id',_0xb984('0x29'),_0xb984('0x105')]},{'model':db[_0xb984('0xbb')],'as':'Tags','attributes':['id',_0xb984('0x29'),'color'],'through':{'attributes':[]}}],'order':[[_0xb984('0x107'),_0xb984('0x73')]]};if(_0xa78ecf[_0xb984('0x36')]['range']){_0x11e889[_0xb984('0x3d')][_0xb984('0x107')]={'$gte':_0x441031[_0xb984('0x43')],'$lte':_0x441031['to']};}switch(_0x5514d0){case _0xb984('0xed'):_0x11e889['attributes'][_0xb984('0x2e')](_0xb984('0x111'),_0xb984('0x112'),'customerPort',_0xb984('0x113'),_0xb984('0x114'),_0xb984('0x115'),'ratingType','ratingValue','referer');break;case _0xb984('0xec'):_0x11e889['attributes']['push']('subject',_0xb984('0x116'));break;case _0xb984('0xef'):_0x11e889['attributes'][_0xb984('0x2e')](_0xb984('0x117'),_0xb984('0x118'));break;}return db[_[_0xb984('0x119')](_0x5514d0)+'Interaction'][_0xb984('0x108')](_0x11e889)[_0xb984('0x25')](function(_0x47de4f){_0x205852[_0xb984('0x1c')]+=_0x47de4f[_0xb984('0x1c')];return _[_0xb984('0x52')](_0x47de4f[_0xb984('0x8a')],function(_0x4aa76f){var _0x3f9ad2=_0x4aa76f['get']({'plain':!![]});_0x3f9ad2[_0xb984('0xf4')]=_0x5514d0;if(_0x3f9ad2['Owner']){_0x3f9ad2['Owner']={'id':_0x3f9ad2[_0xb984('0x110')]['id'],'name':_0x3f9ad2['Owner'][_0xb984('0x29')],'fullname':_0x3f9ad2[_0xb984('0x110')][_0xb984('0x105')]};}return _0x3f9ad2;});});}});return Promise['all'](_0x33dd08);})[_0xb984('0x25')](function(_0x23fea7){return _(_0x23fea7)['flatten']()[_0xb984('0x11a')]('createdAt')['reverse']()[_0xb984('0x50')]();})['then'](function(_0x3c82be){_0x205852['rows']=_0x1d5634[_0xb984('0x1e')]?_0x3c82be[_0xb984('0x11b')](_0x1d5634[_0xb984('0x1d')],_0x1d5634['offset']+_0x1d5634[_0xb984('0x1e')]):_0x3c82be;return _0x205852;})['then'](respondWithFilteredResult(_0x1c5cf0,_0x1d5634))[_0xb984('0x8b')](handleError(_0x1c5cf0,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff