// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-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
+var _0x0bb5=['Invalid\x20date\x20for\x20range\x20from\x20filter','isValid','Invalid\x20date\x20for\x20range\x20to\x20filter','uniqueid','source','callerid','endtime','duration','note','userDisposition','userSecondDisposition','fullname','createdAt','startCase','Website','Account','closed','UserId','key','Owner','browserName','customerPort','osName','ratingMessage','ratingType','ratingValue','referer','subject','substatus','externalUrl','threadId','Interaction','findAndCountAll','flatten','sortBy','slice','html-pdf','eml-format','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','lodash','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','redis','localhost','socket.io-emitter','./cmContact.socket','register','status','end','json','offset','limit','Content-Range','apply','reject','update','then','destroy','error','stack','name','send','index','CmContact','keys','length','startsWith','cf_','push','CmCustomField','trimStart','all','fieldType','model','query','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','where','filters','pick','field','from','select','cm_contacts','left_join','cm_user_has_contacts','uc.CmContactId\x20=\x20c.id','cm_contact_has_tags','ct.CmContactId\x20=\x20c.id','tools_tags','t.id\x20=\x20ct.TagId','c.deletedAt\x20IS\x20NULL','expr','search','parseSearch','sqlOperator','conditions','find','Tag','value','map','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','User','and','uc.UserId\x20=\x20?','castTo','buildExpression','type','start','filter','isNil','c.ListId\x20IN\x20?','concat','Contact','\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','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?','c.id','QueryTypes','SELECT','clone','DESC','having','t.id\x20IN\x20?','resolve','user','agent','some','isEmpty','c.ListId\x20IS\x20NULL','role','ListId','count','sequelize','merge','c.firstName','c.phone','c.mobile','c.fax','c.ListId','c.deletedAt','c.CompanyId','toString','TagIds','split','Tags','catch','params','describe','tags','columnName','displayName','findAll','alias','custom','values','body','get','mergeWith','join','info','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsMessage','FaxInteraction','FaxMessage','OpenchannelMessage','CmHopperFinal','CmHopperHistory','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappQueueReport','create','each','duplicates','$or','findOrCreate','show','color','$and','format','cf_%d','omit','pickBy','table','setFields','id\x20=\x20?','toParam','phone','getTags','findOne','rawAttributes','options','setTags','ContactId','includeAll','rows','include','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','binding_values','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','binding_keys','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','No\x20firstName\x20column\x20specified','root','server/files/tmp','file','filename','chmodSync','0777','child_process','fork','../../components/import/cm/csv','CompanyId','upload','createReadStream','parse','meta','import','binding','firstName','stringify','start\x20child\x20process\x20correctly!','pid','getJourney','mail','chat','sms','openchannel','fax','whatsapp','-createdAt','channel','includes','toLowerCase','Invalid\x20channel','range'];(function(_0xa148b7,_0x2f3eb2){var _0x51efd3=function(_0x34bcec){while(--_0x34bcec){_0xa148b7['push'](_0xa148b7['shift']());}};_0x51efd3(++_0x2f3eb2);}(_0x0bb5,0x148));var _0x50bb=function(_0xeeae02,_0x344533){_0xeeae02=_0xeeae02-0x0;var _0x987866=_0x0bb5[_0xeeae02];return _0x987866;};'use strict';var pdf=require(_0x50bb('0x0'));var emlformat=require(_0x50bb('0x1'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0x50bb('0x2'));var rp=require(_0x50bb('0x3'));var moment=require(_0x50bb('0x4'));var BPromise=require(_0x50bb('0x5'));var Mustache=require(_0x50bb('0x6'));var util=require(_0x50bb('0x7'));var path=require(_0x50bb('0x8'));var sox=require(_0x50bb('0x9'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var _=require(_0x50bb('0xa'));var squel=require(_0x50bb('0xb'));var crypto=require(_0x50bb('0xc'));var jsforce=require(_0x50bb('0xd'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0x50bb('0xe'));var Papa=require(_0x50bb('0xf'));var Redis=require(_0x50bb('0x10'));var authService=require(_0x50bb('0x11'));var qs=require('../../components/parsers/qs');var as=require(_0x50bb('0x12'));var hardwareService=require(_0x50bb('0x13'));var logger=require(_0x50bb('0x14'))(_0x50bb('0x15'));var utils=require(_0x50bb('0x16'));var config=require(_0x50bb('0x17'));var licenseUtil=require(_0x50bb('0x18'));var db=require('../../mysqldb')['db'];config[_0x50bb('0x19')]=_['defaults'](config[_0x50bb('0x19')],{'host':_0x50bb('0x1a'),'port':0x18eb});var socket=require(_0x50bb('0x1b'))(new Redis(config['redis']));require(_0x50bb('0x1c'))[_0x50bb('0x1d')](socket);function respondWithStatusCode(_0x3094f2,_0x5244b0){_0x5244b0=_0x5244b0||0xcc;return function(_0xbbc6a0){if(_0xbbc6a0){return _0x3094f2['sendStatus'](_0x5244b0);}return _0x3094f2[_0x50bb('0x1e')](_0x5244b0)[_0x50bb('0x1f')]();};}function respondWithResult(_0x253073,_0x42ffab){_0x42ffab=_0x42ffab||0xc8;return function(_0x908950){if(_0x908950){return _0x253073['status'](_0x42ffab)[_0x50bb('0x20')](_0x908950);}};}function respondWithFilteredResult(_0x174065,_0x4b1f5f){return function(_0x24ba19){if(_0x24ba19){var _0x4796ec=_0x24ba19['count'],_0x301f61=_0x4b1f5f[_0x50bb('0x21')],_0x431ed4=_0x4b1f5f[_0x50bb('0x21')]+_0x4b1f5f[_0x50bb('0x22')],_0x4b06f5;if(_0x431ed4>=_0x4796ec){_0x431ed4=_0x4796ec;_0x4b06f5=0xc8;}else{_0x4b06f5=0xce;}_0x174065[_0x50bb('0x1e')](_0x4b06f5);return _0x174065['set'](_0x50bb('0x23'),_0x301f61+'-'+_0x431ed4+'/'+_0x4796ec)[_0x50bb('0x20')](_0x24ba19);}return null;};}function patchUpdates(_0x4020a0){return function(_0x597e95){try{jsonpatch[_0x50bb('0x24')](_0x597e95,_0x4020a0,!![]);}catch(_0x879fea){return BPromise[_0x50bb('0x25')](_0x879fea);}return _0x597e95['save']();};}function saveUpdates(_0x1dbba2,_0x4cc7f9){return function(_0x1c81a1){if(_0x1c81a1){return _0x1c81a1[_0x50bb('0x26')](_0x1dbba2)[_0x50bb('0x27')](function(_0x2ee87a){return _0x2ee87a;});}return null;};}function removeEntity(_0x846311,_0x342078){return function(_0x4f7f73){if(_0x4f7f73){return _0x4f7f73[_0x50bb('0x28')]()[_0x50bb('0x27')](function(){_0x846311[_0x50bb('0x1e')](0xcc)[_0x50bb('0x1f')]();});}};}function handleEntityNotFound(_0x5234d7,_0x75fea6){return function(_0x4d38f7){if(!_0x4d38f7){_0x5234d7['sendStatus'](0x194);}return _0x4d38f7;};}function handleError(_0x2befd9,_0x491632){_0x491632=_0x491632||0x1f4;return function(_0x5cfe4b){logger[_0x50bb('0x29')](_0x5cfe4b[_0x50bb('0x2a')]);if(_0x5cfe4b[_0x50bb('0x2b')]){delete _0x5cfe4b[_0x50bb('0x2b')];}_0x2befd9[_0x50bb('0x1e')](_0x491632)[_0x50bb('0x2c')](_0x5cfe4b);};}exports[_0x50bb('0x2d')]=function(_0x41d479,_0x4f7514){var _0x44ce86={},_0x461cf3={},_0x15ee2e={'count':0x0,'rows':[]};return db[_0x50bb('0x2e')]['describe']()[_0x50bb('0x27')](function(_0x1a62fb){var _0xc38da5=[];for(var _0xb3c3ba=0x0;_0xb3c3ba<Object[_0x50bb('0x2f')](_0x1a62fb)[_0x50bb('0x30')];_0xb3c3ba++){var _0x51aa81=Object[_0x50bb('0x2f')](_0x1a62fb)[_0xb3c3ba];if(_[_0x50bb('0x31')](_0x51aa81,_0x50bb('0x32'))){_0xc38da5[_0x50bb('0x33')](db[_0x50bb('0x34')]['findOne']({'where':{'id':_[_0x50bb('0x35')](_0x51aa81,_0x50bb('0x32'))},'raw':!![]}));}}return BPromise[_0x50bb('0x36')](_0xc38da5)[_0x50bb('0x27')](function(_0x2bea60){for(var _0x2db122=0x0;_0x2db122<_0x2bea60[_0x50bb('0x30')];_0x2db122++){if(_0x2bea60[_0x2db122]){var _0x1ef7ed=_0x50bb('0x32')+_0x2bea60[_0x2db122]['id'];var _0x1cc4e2=_0x1a62fb[_0x1ef7ed];_0x1cc4e2[_0x50bb('0x37')]=_0x2bea60[_0x2db122]['type'];}}return _0x1a62fb;});})[_0x50bb('0x27')](function(_0xdb38e1){_0x461cf3[_0x50bb('0x38')]=_[_0x50bb('0x2f')](_0xdb38e1);_0x461cf3[_0x50bb('0x39')]=_[_0x50bb('0x2f')](_0x41d479['query']);_0x461cf3['filters']=_[_0x50bb('0x3a')](_0x461cf3['model'],_0x461cf3[_0x50bb('0x39')]);_0x44ce86[_0x50bb('0x3b')]=_[_0x50bb('0x3a')](_0x461cf3[_0x50bb('0x38')],qs[_0x50bb('0x3c')](_0x41d479['query'][_0x50bb('0x3c')]));_0x44ce86['attributes']=_0x44ce86[_0x50bb('0x3b')][_0x50bb('0x30')]?_0x44ce86[_0x50bb('0x3b')]:_0x461cf3['model'];if(!_0x41d479['query'][_0x50bb('0x3d')](_0x50bb('0x3e'))){_0x44ce86[_0x50bb('0x22')]=qs[_0x50bb('0x22')](_0x41d479['query'][_0x50bb('0x22')]);_0x44ce86['offset']=qs['offset'](_0x41d479[_0x50bb('0x39')]['offset']);}_0x44ce86[_0x50bb('0x3f')]=qs[_0x50bb('0x40')](_0x41d479[_0x50bb('0x39')][_0x50bb('0x40')]);_0x44ce86[_0x50bb('0x41')]=qs[_0x50bb('0x42')](_[_0x50bb('0x43')](_0x41d479[_0x50bb('0x39')],_0x461cf3[_0x50bb('0x42')]),_0xdb38e1);var _0x718128=[];var _0x594f16=squel['select']()[_0x50bb('0x44')]('id')[_0x50bb('0x44')](_0x50bb('0x2b'))[_0x50bb('0x44')]('color')[_0x50bb('0x45')]('tools_tags');var _0x8a0b28=squel[_0x50bb('0x46')]()[_0x50bb('0x45')](_0x50bb('0x47'),'c')[_0x50bb('0x48')](_0x50bb('0x49'),'uc',_0x50bb('0x4a'))[_0x50bb('0x48')](_0x50bb('0x4b'),'ct',_0x50bb('0x4c'))[_0x50bb('0x48')](_0x50bb('0x4d'),'t',_0x50bb('0x4e'))[_0x50bb('0x41')](_0x50bb('0x4f'));var _0x2a17e1=squel['expr']();var _0x3ab814=[];var _0x57c335=squel[_0x50bb('0x50')]();var _0xc88ad2;if(_0x41d479[_0x50bb('0x39')][_0x50bb('0x51')]){_0xc88ad2=as[_0x50bb('0x52')](_0x41d479[_0x50bb('0x39')][_0x50bb('0x51')]);var _0x67c519=_0xc88ad2[_0x50bb('0x53')];for(var _0x3fe267=0x0;_0x3fe267<_0xc88ad2[_0x50bb('0x54')][_0x50bb('0x30')];_0x3fe267++){var _0x2b7484=_0xc88ad2[_0x50bb('0x54')][_0x3fe267];var _0x5880df='c';var _0x3eb429=_(_0xdb38e1)['keys']()[_0x50bb('0x55')](function(_0x141aee){return _0x141aee===_0x2b7484[_0x50bb('0x44')];});if(_0x3eb429)_0x3eb429=_0xdb38e1[_0x2b7484[_0x50bb('0x44')]];if(!_0x3eb429){if(_0x2b7484[_0x50bb('0x44')]===_0x50bb('0x56')){var _0x133dd9=_0x2b7484[_0x50bb('0x57')]['split'](',')[_0x50bb('0x58')](function(_0x262a12){return Number(_0x262a12);});_0x133dd9[_0x50bb('0x59')](function(_0x13afe2){_0x57c335['or'](_0x50bb('0x5a'),'%,'+_0x13afe2+',%');});_0x3ab814=_['union'](_0x3ab814,_0x133dd9);}else if(_0x2b7484[_0x50bb('0x44')]===_0x50bb('0x5b')){_0x2a17e1[_0x50bb('0x5c')](_0x50bb('0x5d'),_0x2b7484[_0x50bb('0x57')]);}}else{if(_0x2b7484['field']==='dateOfBirth'||_0x3eb429[_0x50bb('0x37')]==='datetime')_0x2b7484[_0x50bb('0x5e')]='DATE';var _0x4316e4=as[_0x50bb('0x5f')](_0x5880df,_0x3eb429[_0x50bb('0x60')],_0x2b7484);_0x2a17e1[_0x67c519](_0x4316e4['text'],_0x4316e4[_0x50bb('0x57')][_0x50bb('0x61')],_0x4316e4['value'][_0x50bb('0x1f')]);}}}else{var _0x1dff6a=_(Object[_0x50bb('0x2f')](_0x41d479[_0x50bb('0x39')]))['map'](function(_0x33e71f){return _0xdb38e1[_0x50bb('0x3d')](_0x33e71f)?_0x33e71f:undefined;})[_0x50bb('0x62')](function(_0x460d93){return!_[_0x50bb('0x63')](_0x460d93);})['value']();if(_0x41d479[_0x50bb('0x39')]['Contact'])_0x1dff6a[_0x50bb('0x33')]('Contact');if(!_['isEmpty'](_0x1dff6a)){_0x1dff6a[_0x50bb('0x59')](function(_0x5131ea){if(_0x5131ea==='ListId'){_0x8a0b28[_0x50bb('0x41')](_0x50bb('0x64'),[][_0x50bb('0x65')](_0x41d479[_0x50bb('0x39')][_0x5131ea]));}else if(_0x5131ea===_0x50bb('0x66')){var _0x3b78bd='%'+_0x41d479[_0x50bb('0x39')][_0x5131ea]+'%';_0x8a0b28[_0x50bb('0x41')]('CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?',_0x3b78bd);}else{_0x8a0b28['where']('c.'+_0x5131ea+_0x50bb('0x67'),_0x41d479[_0x50bb('0x39')][_0x5131ea]);}});}if(_0x41d479[_0x50bb('0x39')][_0x50bb('0x68')]){_0x3ab814=_[_0x50bb('0x69')](_0x41d479[_0x50bb('0x39')][_0x50bb('0x68')])?_0x41d479['query'][_0x50bb('0x68')]:new Array(_0x41d479[_0x50bb('0x39')][_0x50bb('0x68')]);_0x3ab814[_0x50bb('0x59')](function(_0x201c1f){_0x57c335['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x201c1f+',%');});}if(_0x41d479[_0x50bb('0x39')][_0x50bb('0x62')]){var _0x1da5cd=_0x41d479[_0x50bb('0x39')][_0x50bb('0x62')]['replace']('\x5c','\x5c\x5c')[_0x50bb('0x6a')](/'/g,'\x27\x27');if(_0x1da5cd['split']('\x20')['length']>0x1){_0x2a17e1['or'](_0x50bb('0x6b'),qs[_0x50bb('0x6c')](_0x1da5cd),null);}else{if(qs[_0x50bb('0x6d')](_0x1da5cd)){_0x2a17e1['or'](_0x50bb('0x6e'),_0x1da5cd+'%');_0x2a17e1['or'](_0x50bb('0x6f'),_0x1da5cd+'%');_0x2a17e1['or'](_0x50bb('0x70'),_0x1da5cd+'%');_0x2a17e1['or'](_0x50bb('0x71'),_0x1da5cd+'%');}else if(qs[_0x50bb('0x72')](_0x1da5cd)){_0x2a17e1['or'](_0x50bb('0x73'),_0x1da5cd+'%');}else{_0x2a17e1['or'](_0x50bb('0x74'),'%'+_0x1da5cd+'%');_0x2a17e1['or'](_0x50bb('0x75'),'%'+_0x1da5cd+'%');_0x2a17e1['or']('c.email\x20LIKE\x20?','%'+_0x1da5cd+'%');}}}}_0x8a0b28[_0x50bb('0x41')](_0x2a17e1);_0x8a0b28['group'](_0x50bb('0x76'));var _0x2b9deb={'type':db['Sequelize'][_0x50bb('0x77')][_0x50bb('0x78')],'raw':!![]};var _0xafa1b7=_0x8a0b28[_0x50bb('0x79')]()[_0x50bb('0x44')](_0x50bb('0x76'));if(_0x44ce86[_0x50bb('0x3f')]){_0x44ce86[_0x50bb('0x3f')]['forEach'](function(_0x342644){_0x8a0b28[_0x50bb('0x3f')]('c.'+_0x342644[0x0],_0x342644[0x1]===_0x50bb('0x7a')?![]:!![]);});}if(!_['isEmpty'](_0x3ab814)){_0x8a0b28[_0x50bb('0x7b')](_0x57c335);_0xafa1b7[_0x50bb('0x41')](_0x50bb('0x7c'),_0x3ab814);}BPromise[_0x50bb('0x7d')]()[_0x50bb('0x27')](function(){if(!_0xc88ad2)return;if(_0x41d479[_0x50bb('0x7e')]['role']!==_0x50bb('0x7f'))return;if(!_[_0x50bb('0x80')](_0xc88ad2[_0x50bb('0x54')],[_0x50bb('0x44'),_0x50bb('0x5b')])){return _0x41d479[_0x50bb('0x7e')]['getLists']({'attributes':['id'],'raw':!![]})[_0x50bb('0x27')](function(_0xa85833){if(_[_0x50bb('0x81')](_0xa85833)){_0xafa1b7[_0x50bb('0x41')](_0x50bb('0x82'));_0x8a0b28[_0x50bb('0x41')](_0x50bb('0x82'));}else{_0xafa1b7[_0x50bb('0x41')](_0x50bb('0x64'),_['map'](_0xa85833,'id'));_0x8a0b28[_0x50bb('0x41')](_0x50bb('0x64'),_[_0x50bb('0x58')](_0xa85833,'id'));}});}})[_0x50bb('0x27')](function(){if(_0x41d479[_0x50bb('0x7e')][_0x50bb('0x83')]===_0x50bb('0x7f')&&!_0xc88ad2&&!_0x41d479[_0x50bb('0x39')][_0x50bb('0x84')])return[];return db['sequelize']['query'](_0xafa1b7['toString'](),_0x2b9deb);})[_0x50bb('0x27')](function(_0x5ba597){_0x15ee2e['count']=_0x5ba597[_0x50bb('0x30')];if(_0x15ee2e[_0x50bb('0x85')]===0x0)return[];return db[_0x50bb('0x86')][_0x50bb('0x39')](_0x594f16['toString'](),_0x2b9deb)[_0x50bb('0x27')](function(_0x16a500){_0x718128=_['keyBy'](_0x16a500,'id');_0x2b9deb=_[_0x50bb('0x87')](_0x2b9deb,{'model':db['CmContact'],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x41d479[_0x50bb('0x39')][_0x50bb('0x3c')]){_0x44ce86['attributes'][_0x50bb('0x59')](function(_0x52c882){_0x8a0b28[_0x50bb('0x44')]('c.'+_0x52c882);});}else{_0x8a0b28[_0x50bb('0x44')]('c.id');_0x8a0b28[_0x50bb('0x44')](_0x50bb('0x88'));_0x8a0b28[_0x50bb('0x44')]('c.lastName');_0x8a0b28[_0x50bb('0x44')](_0x50bb('0x89'));_0x8a0b28[_0x50bb('0x44')](_0x50bb('0x8a'));_0x8a0b28['field'](_0x50bb('0x8b'));_0x8a0b28[_0x50bb('0x44')]('c.email');_0x8a0b28['field'](_0x50bb('0x8c'));_0x8a0b28[_0x50bb('0x44')]('c.createdAt');_0x8a0b28[_0x50bb('0x44')](_0x50bb('0x8d'));_0x8a0b28[_0x50bb('0x44')](_0x50bb('0x8e'));_0x8a0b28[_0x50bb('0x44')]('GROUP_CONCAT(DISTINCT\x20t.id)','TagIds');}if(_0x44ce86[_0x50bb('0x22')])_0x8a0b28[_0x50bb('0x22')](_0x44ce86[_0x50bb('0x22')]);if(_0x44ce86[_0x50bb('0x21')])_0x8a0b28['offset'](_0x44ce86[_0x50bb('0x21')]);return db['sequelize'][_0x50bb('0x39')](_0x8a0b28[_0x50bb('0x8f')](),_0x2b9deb);});})[_0x50bb('0x27')](function(_0xbcfdba){_0xbcfdba[_0x50bb('0x59')](function(_0x217170){if(_0x217170[_0x50bb('0x90')]){_0x217170['Tags']=[];_0x217170[_0x50bb('0x90')][_0x50bb('0x91')](',')[_0x50bb('0x59')](function(_0x170923){_0x217170[_0x50bb('0x92')][_0x50bb('0x33')](_0x718128[_0x170923]);});}delete _0x217170[_0x50bb('0x90')];});_0x15ee2e['rows']=_0xbcfdba;return _0x15ee2e;})[_0x50bb('0x27')](respondWithFilteredResult(_0x4f7514,_0x44ce86));})[_0x50bb('0x93')](handleError(_0x4f7514,null));};exports[_0x50bb('0x28')]=function(_0x3bd57a,_0x469435){return db['CmContact']['find']({'where':{'id':_0x3bd57a[_0x50bb('0x94')]['id']}})['then'](handleEntityNotFound(_0x469435,null))[_0x50bb('0x27')](removeEntity(_0x469435,null))[_0x50bb('0x93')](handleError(_0x469435,null));};exports['describe']=function(_0x498b88,_0x5e6545){return db[_0x50bb('0x2e')][_0x50bb('0x95')]()['then'](function(_0x75dc05){delete _0x75dc05[_0x50bb('0x96')];for(var _0x1b88f5=0x0;_0x1b88f5<Object[_0x50bb('0x2f')](_0x75dc05)[_0x50bb('0x30')];_0x1b88f5++){var _0x3a25a4=Object[_0x50bb('0x2f')](_0x75dc05)[_0x1b88f5];if(!_['startsWith'](_0x3a25a4,'cf_')){_0x75dc05[_0x3a25a4][_0x50bb('0x97')]=_0x3a25a4;_0x75dc05[_0x3a25a4][_0x50bb('0x98')]=_0x3a25a4;}}return _0x75dc05;})[_0x50bb('0x27')](function(_0x2c5eda){var _0x2b9d24={'where':{'$or':[{'ListId':_0x498b88[_0x50bb('0x39')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x50bb('0x34')][_0x50bb('0x99')](_0x2b9d24)[_0x50bb('0x27')](function(_0x2d01ec){for(var _0x484402=0x0;_0x484402<_0x2d01ec[_0x50bb('0x30')];_0x484402++){var _0x847c4f=_0x50bb('0x32')+_0x2d01ec[_0x484402]['id'];_0x2c5eda[_0x847c4f][_0x50bb('0x97')]=_0x847c4f;_0x2c5eda[_0x847c4f][_0x50bb('0x98')]=_0x2d01ec[_0x484402][_0x50bb('0x9a')];_0x2c5eda[_0x847c4f][_0x50bb('0x9b')]={'type':_0x2d01ec[_0x484402][_0x50bb('0x60')],'values':_0x2d01ec[_0x484402][_0x50bb('0x9c')]};}Object[_0x50bb('0x2f')](_0x2c5eda)[_0x50bb('0x59')](function(_0x20d662){if(!_0x2c5eda[_0x20d662][_0x50bb('0x3d')](_0x50bb('0x97'))){delete _0x2c5eda[_0x20d662];}});return _0x2c5eda;});})[_0x50bb('0x27')](respondWithResult(_0x5e6545,null))['catch'](handleError(_0x5e6545,null));};exports[_0x50bb('0x87')]=function(_0x28c4ca,_0x348a6e){var _0x54ed3f;var _0xcd752;var _0x2a3376;if(_0x28c4ca[_0x50bb('0x9d')]['id']){delete _0x28c4ca[_0x50bb('0x9d')]['id'];}return db[_0x50bb('0x2e')][_0x50bb('0x99')]({'where':{'id':[_0x28c4ca[_0x50bb('0x9d')]['to'],_0x28c4ca[_0x50bb('0x9d')][_0x50bb('0x45')]]}})[_0x50bb('0x27')](function(_0x4ec601){if(_0x4ec601){if(_0x4ec601[_0x50bb('0x30')]!==0x2){return null;}_0x4ec601[0x0]=_0x4ec601[0x0][_0x50bb('0x9e')]({'plain':!![]});_0x4ec601[0x1]=_0x4ec601[0x1][_0x50bb('0x9e')]({'plain':!![]});delete _0x4ec601[0x0]['id'];delete _0x4ec601[0x1]['id'];return _[_0x50bb('0x9f')](_0x4ec601[0x0],_0x4ec601[0x1],function(_0x23b9b9,_0xbb4698){if(Array[_0x50bb('0x69')](_0xbb4698)&&!_0xbb4698[_0x50bb('0x30')]){return _0x23b9b9;}else if(!_0xbb4698){return _0x23b9b9;}});}})[_0x50bb('0x27')](handleEntityNotFound(_0x348a6e,null))[_0x50bb('0x27')](function(_0x3824f9){if(_0x3824f9){if(_0x3824f9['tags']&&_[_0x50bb('0x69')](_0x3824f9[_0x50bb('0x96')])){_0x3824f9[_0x50bb('0x96')]=_0x3824f9[_0x50bb('0x96')][_0x50bb('0xa0')]();}logger[_0x50bb('0xa1')]('[CmContact][merge]\x20to\x20%s\x20from\x20%s',_0x28c4ca[_0x50bb('0x9d')]['to'],_0x28c4ca['body'][_0x50bb('0x45')]);return db[_0x50bb('0xa2')]['destroy']({'where':{'ContactId':[_0x28c4ca['body']['to'],_0x28c4ca['body'][_0x50bb('0x45')]]}})[_0x50bb('0x27')](function(_0x31561f){logger[_0x50bb('0xa1')](_0x50bb('0xa3'),_0x31561f);return db[_0x50bb('0xa4')][_0x50bb('0x28')]({'where':{'ContactId':[_0x28c4ca['body']['to'],_0x28c4ca[_0x50bb('0x9d')]['from']]}})[_0x50bb('0x27')](function(_0x2c41f7){logger['info']('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x2c41f7);return db[_0x50bb('0x2e')]['create'](_0x3824f9);});});}})[_0x50bb('0x27')](function(_0xb67a4b){if(_0xb67a4b){_0x54ed3f=_0xb67a4b;_0xcd752={'ContactId':_0x54ed3f['id']};_0x2a3376={'where':{'ContactId':[_0x28c4ca[_0x50bb('0x9d')]['to'],_0x28c4ca[_0x50bb('0x9d')][_0x50bb('0x45')]]}};return db[_0x50bb('0xa5')]['update'](_0xcd752,_0x2a3376);}})[_0x50bb('0x27')](function(){if(_0x54ed3f){return db[_0x50bb('0xa6')][_0x50bb('0x26')](_0xcd752,_0x2a3376);}})[_0x50bb('0x27')](function(){if(_0x54ed3f){return db[_0x50bb('0xa7')][_0x50bb('0x26')](_0xcd752,_0x2a3376);}})[_0x50bb('0x27')](function(){if(_0x54ed3f){return db[_0x50bb('0xa8')][_0x50bb('0x26')](_0xcd752,_0x2a3376);}})['then'](function(){if(_0x54ed3f){return db['MailMessage']['update'](_0xcd752,_0x2a3376);}})[_0x50bb('0x27')](function(){if(_0x54ed3f){return db[_0x50bb('0xa8')][_0x50bb('0x26')](_0xcd752,_0x2a3376);}})['then'](function(){if(_0x54ed3f){return db[_0x50bb('0xa9')][_0x50bb('0x26')](_0xcd752,_0x2a3376);}})[_0x50bb('0x27')](function(){if(_0x54ed3f){return db['SmsInteraction'][_0x50bb('0x26')](_0xcd752,_0x2a3376);}})['then'](function(){if(_0x54ed3f){return db[_0x50bb('0xaa')][_0x50bb('0x26')](_0xcd752,_0x2a3376);}})[_0x50bb('0x27')](function(){if(_0x54ed3f){return db[_0x50bb('0xab')][_0x50bb('0x26')](_0xcd752,_0x2a3376);}})[_0x50bb('0x27')](function(){if(_0x54ed3f){return db[_0x50bb('0xac')]['update'](_0xcd752,_0x2a3376);}})[_0x50bb('0x27')](function(){if(_0x54ed3f){return db['OpenchannelInteraction'][_0x50bb('0x26')](_0xcd752,_0x2a3376);}})[_0x50bb('0x27')](function(){if(_0x54ed3f){return db[_0x50bb('0xad')][_0x50bb('0x26')](_0xcd752,_0x2a3376);}})['then'](function(){if(_0x54ed3f){return db[_0x50bb('0xae')][_0x50bb('0x26')](_0xcd752,_0x2a3376);}})[_0x50bb('0x27')](function(){if(_0x54ed3f){return db[_0x50bb('0xaf')][_0x50bb('0x26')](_0xcd752,_0x2a3376);}})['then'](function(){if(_0x54ed3f){return db['ReportAgentPreview'][_0x50bb('0x26')](_0xcd752,_0x2a3376);}})[_0x50bb('0x27')](function(){if(_0x54ed3f){return db[_0x50bb('0xb0')][_0x50bb('0x26')](_0xcd752,_0x2a3376);}})[_0x50bb('0x27')](function(){if(_0x54ed3f){return db[_0x50bb('0xb1')][_0x50bb('0x26')](_0xcd752,_0x2a3376);}})[_0x50bb('0x27')](function(){if(_0x54ed3f){return db[_0x50bb('0xb2')]['update'](_0xcd752,_0x2a3376);}})[_0x50bb('0x27')](function(){if(_0x54ed3f){return db[_0x50bb('0xb3')]['update'](_0xcd752,_0x2a3376);}})[_0x50bb('0x27')](function(){if(_0x54ed3f){return db[_0x50bb('0xb4')][_0x50bb('0x26')](_0xcd752,_0x2a3376);}})['then'](function(){if(_0x54ed3f){return db[_0x50bb('0xb5')][_0x50bb('0x26')](_0xcd752,_0x2a3376);}})['then'](function(){if(_0x54ed3f){return db[_0x50bb('0xb6')][_0x50bb('0x26')](_0xcd752,_0x2a3376);}})[_0x50bb('0x27')](function(){if(_0x54ed3f){return db[_0x50bb('0xb7')]['update'](_0xcd752,_0x2a3376);}})['then'](function(){if(_0x54ed3f){return db['WhatsappMessage'][_0x50bb('0x26')](_0xcd752,_0x2a3376);}})[_0x50bb('0x27')](function(){if(_0x54ed3f){return db[_0x50bb('0xb8')][_0x50bb('0x26')](_0xcd752,_0x2a3376);}})[_0x50bb('0x27')](function(){if(_0x54ed3f){return db['CmContact'][_0x50bb('0x28')]({'where':{'id':[_0x28c4ca[_0x50bb('0x9d')]['to'],_0x28c4ca['body'][_0x50bb('0x45')]]}});}})['then'](function(){if(_0x54ed3f){return _0x54ed3f;}})[_0x50bb('0x27')](respondWithResult(_0x348a6e,null))[_0x50bb('0x93')](handleError(_0x348a6e,null));};exports[_0x50bb('0xb9')]=function(_0x3a3c79,_0x250487){return db[_0x50bb('0x2e')]['describe']()[_0x50bb('0x27')](function(_0x1ef857){if(_0x3a3c79[_0x50bb('0x9d')][_0x50bb('0x96')]&&_[_0x50bb('0x69')](_0x3a3c79['body'][_0x50bb('0x96')])){if(_0x3a3c79['body']['tags']['length']){_0x3a3c79[_0x50bb('0x9d')][_0x50bb('0x96')]=_0x3a3c79[_0x50bb('0x9d')][_0x50bb('0x96')][_0x50bb('0xa0')](';')+';';}else{_0x3a3c79[_0x50bb('0x9d')][_0x50bb('0x96')]=null;}}else{_0x3a3c79[_0x50bb('0x9d')][_0x50bb('0x96')]=null;}return db[_0x50bb('0x2e')][_0x50bb('0xb9')](_0x3a3c79['body'],{'fields':_[_0x50bb('0x2f')](_0x1ef857),'raw':!![]});})[_0x50bb('0x27')](respondWithResult(_0x250487,0xc9))['catch'](handleError(_0x250487,null));};exports['bulkCreate']=function(_0x3ad1ad,_0x3c3095){var _0x2cbec9=[];var _0x5593dd=0x0;var _0x451cbe=0x0;var _0xd1e294=0x0;return db['CmContact'][_0x50bb('0x95')]()['then'](function(_0x4590cb){return BPromise[_0x50bb('0xba')](_0x3ad1ad['body'],function(_0x4210a3){var _0x2ed595={'where':{'$or':[]},'defaults':_0x4210a3,'fields':_[_0x50bb('0x2f')](_0x4590cb),'raw':!![]};if(_0x4210a3[_0x50bb('0xbb')]){for(var _0xad2296=0x0;_0xad2296<_0x4210a3[_0x50bb('0xbb')][_0x50bb('0x30')];_0xad2296++){var _0x514c8c={};_0x514c8c[_0x4210a3[_0x50bb('0xbb')][_0xad2296]]=_0x4210a3[_0x4210a3[_0x50bb('0xbb')][_0xad2296]];_0x2ed595[_0x50bb('0x41')][_0x50bb('0xbc')][_0x50bb('0x33')](_0x514c8c);}_0x2ed595[_0x50bb('0x41')][_0x50bb('0x84')]=_0x4210a3[_0x50bb('0x84')];}return db['CmContact'][_0x50bb('0xbd')](_0x2ed595)['spread'](function(_0x2e2141,_0x2e8d86){if(_0x2e8d86){_0x5593dd++;}else{_0xd1e294++;}})[_0x50bb('0x93')](function(_0x2112c4){console[_0x50bb('0x29')](_0x2112c4);_0x451cbe++;});});})[_0x50bb('0x27')](function(_0x4e476c){if(_0x4e476c){return{'success':_0x5593dd,'failure':_0x451cbe,'duplicates':_0xd1e294};}})['then'](respondWithResult(_0x3c3095,0xc9))[_0x50bb('0x93')](handleError(_0x3c3095,null));};exports[_0x50bb('0xbe')]=function(_0x265307,_0xaa483a,_0x1ad320){var _0x436bf9;return db[_0x50bb('0x2e')][_0x50bb('0x95')]()[_0x50bb('0x27')](function(_0x49e12a){return db['CmContact'][_0x50bb('0x55')]({'where':{'id':_0x265307[_0x50bb('0x94')]['id']},'include':[{'model':db[_0x50bb('0x56')],'as':_0x50bb('0x92'),'attributes':['id',_0x50bb('0x2b'),_0x50bb('0xbf')],'required':_0x265307['query'][_0x50bb('0x68')]?!![]:![]}],'attributes':_[_0x50bb('0x2f')](_0x49e12a)});})[_0x50bb('0x27')](function(_0x2e7350){_0x436bf9=_0x2e7350[_0x50bb('0x9e')]({'plain':!![]});var _0x40be29={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x2e7350&&_0x2e7350['ListId']){if(_0x2e7350['ListId']){_0x40be29[_0x50bb('0x41')][_0x50bb('0xc0')][_0x50bb('0x33')]({'ListId':{'$ne':_0x2e7350[_0x50bb('0x84')]}});}}return db['CmCustomField'][_0x50bb('0x99')](_0x40be29);})['then'](function(_0x1af7f6){return _['omit'](_0x436bf9,_[_0x50bb('0x58')](_0x1af7f6,function(_0x2db9df){return util[_0x50bb('0xc1')](_0x50bb('0xc2'),_0x2db9df['id']);}));})[_0x50bb('0x27')](handleEntityNotFound(_0xaa483a,null))[_0x50bb('0x27')](respondWithResult(_0xaa483a,null))['catch'](handleError(_0xaa483a,null));};exports[_0x50bb('0x26')]=function(_0x448a15,_0x743cb4){var _0x1e3700;if(_0x448a15[_0x50bb('0x9d')]['id']){delete _0x448a15[_0x50bb('0x9d')]['id'];}return db['CmContact']['find']({'where':{'id':_0x448a15['params']['id']}})['then'](handleEntityNotFound(_0x743cb4,null))[_0x50bb('0x27')](saveUpdates(_0x448a15[_0x50bb('0x9d')],null))['then'](function(_0x8888c7){_0x1e3700=_0x8888c7;var _0x65182f={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x8888c7&&_0x8888c7[_0x50bb('0x84')]){if(_0x8888c7[_0x50bb('0x84')]){_0x65182f['where'][_0x50bb('0xc0')][_0x50bb('0x33')]({'ListId':{'$ne':_0x8888c7[_0x50bb('0x84')]}});}}return db[_0x50bb('0x34')][_0x50bb('0x99')](_0x65182f);})[_0x50bb('0x27')](function(_0x303dfa){if(_0x303dfa){return _[_0x50bb('0xc3')](_[_0x50bb('0xc4')](_0x448a15[_0x50bb('0x9d')],function(_0x184b15,_0x117563){return _['startsWith'](_0x117563,_0x50bb('0x32'));}),_[_0x50bb('0x58')](_0x303dfa,function(_0x21a064){return util[_0x50bb('0xc1')]('cf_%d',_0x21a064['id']);}));}})['then'](function(_0x24d0ac){if(_0x24d0ac&&!_[_0x50bb('0x81')](_0x24d0ac)){var _0x1d7dbc=squel[_0x50bb('0x26')]()[_0x50bb('0xc5')](_0x50bb('0x47'))[_0x50bb('0xc6')](_0x24d0ac)[_0x50bb('0x41')](_0x50bb('0xc7'),_0x448a15['params']['id'])[_0x50bb('0xc8')]();return db[_0x50bb('0x86')][_0x50bb('0x39')](_0x1d7dbc['text'],{'replacements':_0x1d7dbc['values']});}})[_0x50bb('0x27')](function(){if(_0x448a15['body'][_0x50bb('0xc9')]&&_0x1e3700){return db[_0x50bb('0xa2')][_0x50bb('0x26')]({'phone':_0x448a15[_0x50bb('0x9d')]['phone']},{'where':{'ContactId':_0x1e3700['id']}});}})[_0x50bb('0x27')](function(){return _0x1e3700;})['then'](respondWithResult(_0x743cb4,null))[_0x50bb('0x93')](handleError(_0x743cb4,null));};exports[_0x50bb('0xca')]=function(_0x1581bb,_0x1ab69,_0x5da94b){var _0xea779={};var _0x5e4243={};var _0x5090d3;var _0x461785;return db[_0x50bb('0x2e')][_0x50bb('0xcb')]({'where':{'id':_0x1581bb['params']['id']}})[_0x50bb('0x27')](handleEntityNotFound(_0x1ab69,null))[_0x50bb('0x27')](function(_0x25fc6a){if(_0x25fc6a){_0x5090d3=_0x25fc6a;_0x5e4243[_0x50bb('0x38')]=_[_0x50bb('0x2f')](db['Tag'][_0x50bb('0xcc')]);_0x5e4243[_0x50bb('0x39')]=_['keys'](_0x1581bb['query']);_0x5e4243[_0x50bb('0x42')]=_[_0x50bb('0x3a')](_0x5e4243['model'],_0x5e4243['query']);_0xea779[_0x50bb('0x3b')]=_[_0x50bb('0x3a')](_0x5e4243[_0x50bb('0x38')],qs[_0x50bb('0x3c')](_0x1581bb[_0x50bb('0x39')][_0x50bb('0x3c')]));_0xea779[_0x50bb('0x3b')]=_0xea779[_0x50bb('0x3b')][_0x50bb('0x30')]?_0xea779[_0x50bb('0x3b')]:_0x5e4243['model'];_0xea779[_0x50bb('0x3f')]=qs[_0x50bb('0x40')](_0x1581bb[_0x50bb('0x39')][_0x50bb('0x40')]);_0xea779[_0x50bb('0x41')]=qs[_0x50bb('0x42')](_['pick'](_0x1581bb['query'],_0x5e4243[_0x50bb('0x42')]));if(_0x1581bb['query'][_0x50bb('0x62')]){_0xea779[_0x50bb('0x41')]=_[_0x50bb('0x87')](_0xea779[_0x50bb('0x41')],{'$or':_[_0x50bb('0x58')](_0xea779[_0x50bb('0x3b')],function(_0x289104){var _0xff1e3a={};_0xff1e3a[_0x289104]={'$like':'%'+_0x1581bb[_0x50bb('0x39')][_0x50bb('0x62')]+'%'};return _0xff1e3a;})});}_0xea779=_[_0x50bb('0x87')]({},_0xea779,_0x1581bb[_0x50bb('0xcd')]);return _0x5090d3[_0x50bb('0xca')](_0xea779);}})[_0x50bb('0x27')](function(_0x21f068){if(_0x21f068){_0x461785=_0x21f068['length'];if(!_0x1581bb['query'][_0x50bb('0x3d')](_0x50bb('0x3e'))){_0xea779[_0x50bb('0x22')]=qs[_0x50bb('0x22')](_0x1581bb['query']['limit']);_0xea779[_0x50bb('0x21')]=qs[_0x50bb('0x21')](_0x1581bb[_0x50bb('0x39')][_0x50bb('0x21')]);}return _0x5090d3[_0x50bb('0xca')](_0xea779);}})[_0x50bb('0x27')](function(_0x323bfe){if(_0x323bfe){return _0x323bfe?{'count':_0x461785,'rows':_0x323bfe}:null;}})['then'](respondWithResult(_0x1ab69,null))['catch'](handleError(_0x1ab69,null));};exports['setTags']=function(_0x2f485f,_0x241521,_0xf3e7f1){if(_0x2f485f[_0x50bb('0x9d')]['id']){delete _0x2f485f['body']['id'];}return db[_0x50bb('0x2e')][_0x50bb('0xcb')]({'where':{'id':_0x2f485f[_0x50bb('0x94')]['id']}})['then'](handleEntityNotFound(_0x241521,null))[_0x50bb('0x27')](function(_0x2ca26a){if(_0x2ca26a){return _0x2ca26a[_0x50bb('0xce')](_0x2f485f[_0x50bb('0x9d')]['ids']||[]);}return null;})[_0x50bb('0x27')](respondWithResult(_0x241521,null))[_0x50bb('0x93')](handleError(_0x241521,null));};exports['getHoppers']=function(_0x81aa35,_0x525411,_0x3eeec5){var _0x3e7f00={'raw':![],'where':{}};var _0x355c85={};var _0x259c3d={'count':0x0,'rows':[]};return db[_0x50bb('0x2e')][_0x50bb('0xcb')]({'where':{'id':_0x81aa35[_0x50bb('0x94')]['id']}})[_0x50bb('0x27')](handleEntityNotFound(_0x525411,null))[_0x50bb('0x27')](function(_0x371cef){if(_0x371cef){_0x355c85[_0x50bb('0x38')]=_['keys'](db[_0x50bb('0xa2')]['rawAttributes']);_0x355c85[_0x50bb('0x39')]=_[_0x50bb('0x2f')](_0x81aa35[_0x50bb('0x39')]);_0x355c85['filters']=_[_0x50bb('0x3a')](_0x355c85['model'],_0x355c85[_0x50bb('0x39')]);_0x3e7f00[_0x50bb('0x3b')]=_[_0x50bb('0x3a')](_0x355c85[_0x50bb('0x38')],qs[_0x50bb('0x3c')](_0x81aa35[_0x50bb('0x39')][_0x50bb('0x3c')]));_0x3e7f00[_0x50bb('0x3b')]=_0x3e7f00[_0x50bb('0x3b')][_0x50bb('0x30')]?_0x3e7f00['attributes']:_0x355c85[_0x50bb('0x38')];if(!_0x81aa35[_0x50bb('0x39')][_0x50bb('0x3d')](_0x50bb('0x3e'))){_0x3e7f00[_0x50bb('0x22')]=qs[_0x50bb('0x22')](_0x81aa35[_0x50bb('0x39')][_0x50bb('0x22')]);_0x3e7f00[_0x50bb('0x21')]=qs[_0x50bb('0x21')](_0x81aa35[_0x50bb('0x39')][_0x50bb('0x21')]);}_0x3e7f00['order']=qs[_0x50bb('0x40')](_0x81aa35[_0x50bb('0x39')][_0x50bb('0x40')]);_0x3e7f00['where']=qs[_0x50bb('0x42')](_[_0x50bb('0x43')](_0x81aa35['query'],_0x355c85[_0x50bb('0x42')]));_0x3e7f00['where'][_0x50bb('0xcf')]=_0x371cef['id'];if(_0x81aa35['query']['filter']){_0x3e7f00[_0x50bb('0x41')]=_[_0x50bb('0x87')](_0x3e7f00['where'],{'$or':_[_0x50bb('0x58')](_0x3e7f00[_0x50bb('0x3b')],function(_0x3adcfc){var _0x752476={};_0x752476[_0x3adcfc]={'$like':'%'+_0x81aa35['query'][_0x50bb('0x62')]+'%'};return _0x752476;})});}_0x3e7f00=_[_0x50bb('0x87')]({},_0x3e7f00,_0x81aa35[_0x50bb('0xcd')]);return db[_0x50bb('0xa2')][_0x50bb('0x85')]({'where':_0x3e7f00[_0x50bb('0x41')]})[_0x50bb('0x27')](function(_0xcd75dc){_0x259c3d['count']=_0xcd75dc;if(_0x81aa35['query'][_0x50bb('0xd0')]){_0x3e7f00['include']=[{'all':!![]}];}return db['CmHopper'][_0x50bb('0x99')](_0x3e7f00);})[_0x50bb('0x27')](function(_0x675c0e){_0x259c3d[_0x50bb('0xd1')]=_0x675c0e;return _0x259c3d;});}})[_0x50bb('0x27')](respondWithFilteredResult(_0x525411,_0x3e7f00))[_0x50bb('0x93')](handleError(_0x525411,null));};exports['getHopperHistories']=function(_0x55a7fa,_0x485709,_0x123ecc){var _0xd042fa={'raw':!![],'where':{}};var _0x4ab459={};var _0x4aade3={'count':0x0,'rows':[]};return db['CmContact'][_0x50bb('0xcb')]({'where':{'id':_0x55a7fa[_0x50bb('0x94')]['id']}})['then'](handleEntityNotFound(_0x485709,null))[_0x50bb('0x27')](function(_0x5bce29){if(_0x5bce29){_0x4ab459[_0x50bb('0x38')]=_[_0x50bb('0x2f')](db['CmHopperHistory'][_0x50bb('0xcc')]);_0x4ab459[_0x50bb('0x39')]=_[_0x50bb('0x2f')](_0x55a7fa[_0x50bb('0x39')]);_0x4ab459[_0x50bb('0x42')]=_[_0x50bb('0x3a')](_0x4ab459['model'],_0x4ab459[_0x50bb('0x39')]);_0xd042fa['attributes']=_[_0x50bb('0x3a')](_0x4ab459[_0x50bb('0x38')],qs[_0x50bb('0x3c')](_0x55a7fa[_0x50bb('0x39')][_0x50bb('0x3c')]));_0xd042fa[_0x50bb('0x3b')]=_0xd042fa[_0x50bb('0x3b')][_0x50bb('0x30')]?_0xd042fa[_0x50bb('0x3b')]:_0x4ab459[_0x50bb('0x38')];if(!_0x55a7fa[_0x50bb('0x39')]['hasOwnProperty'](_0x50bb('0x3e'))){_0xd042fa[_0x50bb('0x22')]=qs['limit'](_0x55a7fa[_0x50bb('0x39')][_0x50bb('0x22')]);_0xd042fa[_0x50bb('0x21')]=qs[_0x50bb('0x21')](_0x55a7fa[_0x50bb('0x39')]['offset']);}_0xd042fa[_0x50bb('0x3f')]=qs[_0x50bb('0x40')](_0x55a7fa[_0x50bb('0x39')][_0x50bb('0x40')]);_0xd042fa[_0x50bb('0x41')]=qs['filters'](_[_0x50bb('0x43')](_0x55a7fa[_0x50bb('0x39')],_0x4ab459['filters']));_0xd042fa[_0x50bb('0x41')][_0x50bb('0xcf')]=_0x5bce29['id'];if(_0x55a7fa[_0x50bb('0x39')]['filter']){_0xd042fa['where']=_[_0x50bb('0x87')](_0xd042fa[_0x50bb('0x41')],{'$or':_[_0x50bb('0x58')](_0xd042fa['attributes'],function(_0x4c695a){var _0x2eb530={};_0x2eb530[_0x4c695a]={'$like':'%'+_0x55a7fa[_0x50bb('0x39')][_0x50bb('0x62')]+'%'};return _0x2eb530;})});}_0xd042fa=_[_0x50bb('0x87')]({},_0xd042fa,_0x55a7fa['options']);return db[_0x50bb('0xaf')][_0x50bb('0x85')]({'where':_0xd042fa[_0x50bb('0x41')]})[_0x50bb('0x27')](function(_0x4b3ef3){_0x4aade3[_0x50bb('0x85')]=_0x4b3ef3;if(_0x55a7fa[_0x50bb('0x39')]['includeAll']){_0xd042fa['include']=[{'all':!![]}];}return db[_0x50bb('0xaf')][_0x50bb('0x99')](_0xd042fa);})[_0x50bb('0x27')](function(_0x587416){_0x4aade3[_0x50bb('0xd1')]=_0x587416;return _0x4aade3;});}})[_0x50bb('0x27')](respondWithFilteredResult(_0x485709,_0xd042fa))['catch'](handleError(_0x485709,null));};exports['getHopperFinals']=function(_0x26171f,_0x2b5ddb,_0x9594f0){var _0x584668={'raw':!![],'where':{}};var _0x2977d2={};var _0x4a9988={'count':0x0,'rows':[]};return db[_0x50bb('0x2e')][_0x50bb('0xcb')]({'where':{'id':_0x26171f[_0x50bb('0x94')]['id']}})[_0x50bb('0x27')](handleEntityNotFound(_0x2b5ddb,null))['then'](function(_0x3b5279){if(_0x3b5279){_0x2977d2['model']=_[_0x50bb('0x2f')](db[_0x50bb('0xae')][_0x50bb('0xcc')]);_0x2977d2[_0x50bb('0x39')]=_[_0x50bb('0x2f')](_0x26171f['query']);_0x2977d2[_0x50bb('0x42')]=_[_0x50bb('0x3a')](_0x2977d2[_0x50bb('0x38')],_0x2977d2['query']);_0x584668[_0x50bb('0x3b')]=_[_0x50bb('0x3a')](_0x2977d2[_0x50bb('0x38')],qs[_0x50bb('0x3c')](_0x26171f[_0x50bb('0x39')][_0x50bb('0x3c')]));_0x584668[_0x50bb('0x3b')]=_0x584668[_0x50bb('0x3b')][_0x50bb('0x30')]?_0x584668[_0x50bb('0x3b')]:_0x2977d2[_0x50bb('0x38')];if(!_0x26171f['query'][_0x50bb('0x3d')](_0x50bb('0x3e'))){_0x584668[_0x50bb('0x22')]=qs[_0x50bb('0x22')](_0x26171f[_0x50bb('0x39')][_0x50bb('0x22')]);_0x584668['offset']=qs[_0x50bb('0x21')](_0x26171f[_0x50bb('0x39')][_0x50bb('0x21')]);}_0x584668['order']=qs[_0x50bb('0x40')](_0x26171f[_0x50bb('0x39')][_0x50bb('0x40')]);_0x584668['where']=qs[_0x50bb('0x42')](_[_0x50bb('0x43')](_0x26171f[_0x50bb('0x39')],_0x2977d2[_0x50bb('0x42')]));_0x584668[_0x50bb('0x41')][_0x50bb('0xcf')]=_0x3b5279['id'];if(_0x26171f[_0x50bb('0x39')][_0x50bb('0x62')]){_0x584668['where']=_[_0x50bb('0x87')](_0x584668[_0x50bb('0x41')],{'$or':_['map'](_0x584668[_0x50bb('0x3b')],function(_0x39a088){var _0x10dd44={};_0x10dd44[_0x39a088]={'$like':'%'+_0x26171f[_0x50bb('0x39')][_0x50bb('0x62')]+'%'};return _0x10dd44;})});}_0x584668=_[_0x50bb('0x87')]({},_0x584668,_0x26171f[_0x50bb('0xcd')]);return db['CmHopperFinal'][_0x50bb('0x85')]({'where':_0x584668['where']})[_0x50bb('0x27')](function(_0xbac79a){_0x4a9988[_0x50bb('0x85')]=_0xbac79a;if(_0x26171f[_0x50bb('0x39')][_0x50bb('0xd0')]){_0x584668[_0x50bb('0xd2')]=[{'all':!![]}];}return db['CmHopperFinal']['findAll'](_0x584668);})[_0x50bb('0x27')](function(_0x382d5a){_0x4a9988[_0x50bb('0xd1')]=_0x382d5a;return _0x4a9988;});}})[_0x50bb('0x27')](respondWithFilteredResult(_0x2b5ddb,_0x584668))['catch'](handleError(_0x2b5ddb,null));};exports[_0x50bb('0xd3')]=function(_0x44e266,_0x59cb65,_0xf22240){var _0x25c453={'raw':!![],'where':{}};var _0x1d65c5={};var _0x2536c3={'count':0x0,'rows':[]};return db[_0x50bb('0x2e')][_0x50bb('0xcb')]({'where':{'id':_0x44e266[_0x50bb('0x94')]['id']}})['then'](handleEntityNotFound(_0x59cb65,null))[_0x50bb('0x27')](function(_0x2edff3){if(_0x2edff3){_0x1d65c5[_0x50bb('0x38')]=_[_0x50bb('0x2f')](db[_0x50bb('0xb6')]['rawAttributes']);_0x1d65c5[_0x50bb('0x39')]=_[_0x50bb('0x2f')](_0x44e266[_0x50bb('0x39')]);_0x1d65c5[_0x50bb('0x42')]=_[_0x50bb('0x3a')](_0x1d65c5[_0x50bb('0x38')],_0x1d65c5[_0x50bb('0x39')]);_0x25c453[_0x50bb('0x3b')]=_[_0x50bb('0x3a')](_0x1d65c5[_0x50bb('0x38')],qs['fields'](_0x44e266[_0x50bb('0x39')][_0x50bb('0x3c')]));_0x25c453['attributes']=_0x25c453['attributes'][_0x50bb('0x30')]?_0x25c453['attributes']:_0x1d65c5[_0x50bb('0x38')];if(!_0x44e266['query'][_0x50bb('0x3d')]('nolimit')){_0x25c453['limit']=qs[_0x50bb('0x22')](_0x44e266[_0x50bb('0x39')]['limit']);_0x25c453[_0x50bb('0x21')]=qs[_0x50bb('0x21')](_0x44e266[_0x50bb('0x39')][_0x50bb('0x21')]);}_0x25c453[_0x50bb('0x3f')]=qs['sort'](_0x44e266[_0x50bb('0x39')]['sort']);_0x25c453[_0x50bb('0x41')]=qs[_0x50bb('0x42')](_[_0x50bb('0x43')](_0x44e266[_0x50bb('0x39')],_0x1d65c5[_0x50bb('0x42')]));_0x25c453[_0x50bb('0x41')][_0x50bb('0xcf')]=_0x2edff3['id'];if(_0x44e266[_0x50bb('0x39')][_0x50bb('0x62')]){_0x25c453[_0x50bb('0x41')]=_['merge'](_0x25c453[_0x50bb('0x41')],{'$or':_[_0x50bb('0x58')](_0x25c453[_0x50bb('0x3b')],function(_0x522b73){var _0x2dccbb={};_0x2dccbb[_0x522b73]={'$like':'%'+_0x44e266['query'][_0x50bb('0x62')]+'%'};return _0x2dccbb;})});}_0x25c453=_[_0x50bb('0x87')]({},_0x25c453,_0x44e266[_0x50bb('0xcd')]);return db['JscriptySessionReport'][_0x50bb('0x85')]({'where':_0x25c453[_0x50bb('0x41')]})['then'](function(_0x3fff44){_0x2536c3['count']=_0x3fff44;if(_0x44e266[_0x50bb('0x39')][_0x50bb('0xd0')]){_0x25c453[_0x50bb('0xd2')]=[{'all':!![]}];}return db[_0x50bb('0xb6')][_0x50bb('0x99')](_0x25c453);})['then'](function(_0x5e05e7){_0x2536c3['rows']=_0x5e05e7;return _0x2536c3;});}})['then'](respondWithFilteredResult(_0x59cb65,_0x25c453))[_0x50bb('0x93')](handleError(_0x59cb65,null));};exports[_0x50bb('0xd4')]=function(_0x3d83f8,_0x4b4048,_0xdad53c){try{if(!_0x3d83f8['body']['ListId']){throw new Error(_0x50bb('0xd5'));}if(!_0x3d83f8[_0x50bb('0x9d')]['binding_keys']){throw new Error('No\x20association\x20keys\x20specified!');}if(!_0x3d83f8[_0x50bb('0x9d')][_0x50bb('0xd6')]){throw new Error(_0x50bb('0xd7'));}if(!_0x3d83f8[_0x50bb('0x9d')][_0x50bb('0xd8')]){throw new Error(_0x50bb('0xd9'));}var _0x2d9502=_0x3d83f8[_0x50bb('0x9d')][_0x50bb('0xda')][_0x50bb('0x91')](',');var _0x5821c7=_0x3d83f8[_0x50bb('0x9d')][_0x50bb('0xd6')][_0x50bb('0x91')](',');if(!_0x2d9502[_0x50bb('0x30')]||!_0x5821c7[_0x50bb('0x30')]||_0x2d9502[_0x50bb('0x30')]!==_0x5821c7[_0x50bb('0x30')]){throw new Error(_0x50bb('0xdb'));}_0x3d83f8[_0x50bb('0x9d')][_0x50bb('0x3c')]=_[_0x50bb('0xdc')](_0x2d9502,_0x5821c7);if(!_0x3d83f8['body']['fields'][_0x50bb('0xc9')]){throw new Error(_0x50bb('0xdd'));}if(!_0x3d83f8[_0x50bb('0x9d')][_0x50bb('0x3c')]['firstName']){throw new Error(_0x50bb('0xde'));}var _0x4b06bf=path[_0x50bb('0xa0')](config[_0x50bb('0xdf')],_0x50bb('0xe0'),_0x3d83f8[_0x50bb('0xe1')][_0x50bb('0xe2')]);fs[_0x50bb('0xe3')](_0x4b06bf,parseInt(_0x50bb('0xe4'),0x8));var _0x2df730=require(_0x50bb('0xe5'))[_0x50bb('0xe6')](path[_0x50bb('0xa0')](__dirname,_0x50bb('0xe7')),[_0x4b06bf,_0x3d83f8['body'][_0x50bb('0xda')],_0x3d83f8['body']['binding_values'],_0x3d83f8[_0x50bb('0x9d')]['ListId'],_0x3d83f8['body'][_0x50bb('0xe8')],_0x3d83f8['body']['duplicates'],_0x3d83f8[_0x50bb('0x9d')][_0x50bb('0xd8')]]);return _0x4b4048[_0x50bb('0x1e')](0xc8)[_0x50bb('0x20')]({'message':'File\x20uploaded\x20correctly!','pid':_0x2df730['pid']});}catch(_0x5d0ea3){return _0x4b4048[_0x50bb('0x1e')](0x1f4)[_0x50bb('0x2c')](_0x5d0ea3);}};exports[_0x50bb('0xe9')]=function(_0xeef5c6,_0x2ec79c,_0x3bb76f){var _0x3b423d=fs[_0x50bb('0xea')](_0xeef5c6[_0x50bb('0xe1')][_0x50bb('0x8')]);Papa[_0x50bb('0xeb')](_0x3b423d,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x3972a5){return _0x2ec79c[_0x50bb('0x1e')](0xc8)['json']({'file':_0xeef5c6['file'],'fields':_0x3972a5[_0x50bb('0xec')][_0x50bb('0x3c')]});}});};exports[_0x50bb('0xed')]=function(_0x2fa106,_0x18aba7,_0x41ec13){return db['User'][_0x50bb('0x99')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0x50bb('0x27')](function(_0xa380b7){var _0x1a6d97=![];if(!_0x2fa106[_0x50bb('0x9d')][_0x50bb('0x84')]){throw new Error(_0x50bb('0xd5'));}if(!_0x2fa106[_0x50bb('0x9d')][_0x50bb('0xee')]['phone']){throw new Error(_0x50bb('0xdd'));}if(!_0x2fa106[_0x50bb('0x9d')][_0x50bb('0xee')][_0x50bb('0xef')]){throw new Error(_0x50bb('0xde'));}if(!_0x2fa106[_0x50bb('0x9d')][_0x50bb('0xd8')]){throw new Error(_0x50bb('0xd9'));}var _0x12fd05=require(_0x50bb('0xe5'))[_0x50bb('0xe6')](path[_0x50bb('0xa0')](__dirname,'../../components/import/cm/csv2'),[_0x2fa106[_0x50bb('0x94')]['id'],JSON[_0x50bb('0xf0')](_0x2fa106[_0x50bb('0x9d')]),JSON[_0x50bb('0xf0')](_0xa380b7)]);_0x12fd05['on']('message',function(_0xaf2cdb){_0x1a6d97=!![];return _0x18aba7[_0x50bb('0x1e')](0xc8)['json']({'message':_0x50bb('0xf1'),'pid':_0x12fd05[_0x50bb('0xf2')]});});_0x12fd05['on']('exit',function(_0x14127c){if(_0x14127c&&!_0x1a6d97){return _0x18aba7[_0x50bb('0x1e')](0x1f4)['json']({'message':'error\x20child\x20process','pid':_0x12fd05[_0x50bb('0xf2')]});}});})[_0x50bb('0x93')](handleError(_0x18aba7,null));};exports[_0x50bb('0xf3')]=function(_0x5a986b,_0x1b7dea){var _0x4e87c7=[_0x50bb('0xf4'),_0x50bb('0xf5'),_0x50bb('0xf6'),_0x50bb('0xf7'),_0x50bb('0xf8'),_0x50bb('0xf9'),'voice'];var _0x5b84fe={'offset':0x0,'order':qs['sort'](_0x50bb('0xfa'))},_0x2a4bc0={'count':0x0,'rows':[]};Promise[_0x50bb('0x7d')]()[_0x50bb('0x27')](function(){if(_0x5a986b['query'][_0x50bb('0xfb')]){if(!_[_0x50bb('0xfc')](_0x4e87c7,_0x5a986b[_0x50bb('0x39')][_0x50bb('0xfb')][_0x50bb('0xfd')]())){throw new Error(_0x50bb('0xfe'));}_0x4e87c7=[_0x5a986b[_0x50bb('0x39')][_0x50bb('0xfb')][_0x50bb('0xfd')]()];}if(_0x5a986b[_0x50bb('0x39')][_0x50bb('0xff')]){try{var _0xe70b26=JSON[_0x50bb('0xeb')](_0x5a986b[_0x50bb('0x39')][_0x50bb('0xff')]);if(!moment(_0xe70b26[_0x50bb('0x45')])['isValid']()){throw new Error(_0x50bb('0x100'));}if(!moment(_0xe70b26['to'])[_0x50bb('0x101')]()){throw new Error(_0x50bb('0x102'));}}catch(_0x273dc7){throw new Error('Invalid\x20createdAt\x20filter');}}if(!_0x5a986b[_0x50bb('0x39')][_0x50bb('0x3d')](_0x50bb('0x3e'))){_0x5b84fe[_0x50bb('0x22')]=qs[_0x50bb('0x22')](_0x5a986b[_0x50bb('0x39')]['limit']||0xa);_0x5b84fe[_0x50bb('0x21')]=qs['offset'](_0x5a986b['query']['offset']);}var _0x5894a0=_0x4e87c7[_0x50bb('0x58')](function(_0x4d2ecf){if(_0x4d2ecf==='voice'){var _0x130aca={'attributes':['id',_0x50bb('0x103'),_0x50bb('0x60'),_0x50bb('0x104'),'destination',_0x50bb('0x105'),'starttime',_0x50bb('0x106'),_0x50bb('0x107'),_0x50bb('0x108'),'createdAt',_0x50bb('0x109'),_0x50bb('0x10a'),'userThirdDisposition'],'where':{'ContactId':_0x5a986b[_0x50bb('0x94')]['id']},'include':[{'model':db[_0x50bb('0x5b')],'as':_0x50bb('0x5b'),'attributes':['id',_0x50bb('0x2b'),_0x50bb('0x10b'),_0x50bb('0x9a')]}],'order':[[_0x50bb('0x10c'),_0x50bb('0x7a')]]};if(_0x5a986b[_0x50bb('0x39')][_0x50bb('0xff')]){_0x130aca['where'][_0x50bb('0x10c')]={'$gte':_0xe70b26[_0x50bb('0x45')],'$lte':_0xe70b26['to']};}return db[_0x50bb('0xb0')]['findAndCountAll'](_0x130aca)['then'](function(_0x520efb){_0x2a4bc0[_0x50bb('0x85')]+=_0x520efb[_0x50bb('0x85')];return _['map'](_0x520efb[_0x50bb('0xd1')],function(_0x499b20){var _0x20abf0=_0x499b20[_0x50bb('0x9e')]({'plain':!![]});_0x20abf0[_0x50bb('0xfb')]=_0x4d2ecf;if(_0x20abf0[_0x50bb('0x5b')]){_0x20abf0[_0x50bb('0x5b')]={'id':_0x20abf0[_0x50bb('0x5b')]['id'],'name':_0x20abf0[_0x50bb('0x5b')][_0x50bb('0x2b')],'fullname':_0x20abf0[_0x50bb('0x5b')]['fullname'],'alias':_0x20abf0[_0x50bb('0x5b')][_0x50bb('0x9a')]};}return _0x20abf0;});});}else{var _0x18503c=_[_0x50bb('0x10d')](_0x4d2ecf)+(_0x4d2ecf==='chat'?_0x50bb('0x10e'):_0x50bb('0x10f'));var _0x49cb0d={'attributes':['id',_0x50bb('0x110'),'closedAt',_0x50bb('0x10c'),'note','disposition','secondDisposition','thirdDisposition',_0x50bb('0x111'),_0x18503c+'Id'],'where':{'ContactId':_0x5a986b['params']['id']},'include':[{'model':db[_0x18503c],'as':_0x50bb('0x10f'),'attributes':['id',_0x50bb('0x2b'),_0x50bb('0x112')]},{'model':db[_0x50bb('0x5b')],'as':_0x50bb('0x113'),'attributes':['id',_0x50bb('0x2b'),_0x50bb('0x10b')]},{'model':db[_0x50bb('0x56')],'as':_0x50bb('0x92'),'attributes':['id',_0x50bb('0x2b'),_0x50bb('0xbf')],'through':{'attributes':[]}}],'order':[['createdAt','DESC']]};if(_0x5a986b['query']['range']){_0x49cb0d[_0x50bb('0x41')]['createdAt']={'$gte':_0xe70b26[_0x50bb('0x45')],'$lte':_0xe70b26['to']};}switch(_0x4d2ecf){case _0x50bb('0xf5'):_0x49cb0d[_0x50bb('0x3b')][_0x50bb('0x33')](_0x50bb('0x114'),'customerIp',_0x50bb('0x115'),'deviceModel',_0x50bb('0x116'),_0x50bb('0x117'),_0x50bb('0x118'),_0x50bb('0x119'),_0x50bb('0x11a'));break;case _0x50bb('0xf4'):_0x49cb0d['attributes'][_0x50bb('0x33')](_0x50bb('0x11b'),_0x50bb('0x11c'));break;case _0x50bb('0xf7'):_0x49cb0d['attributes'][_0x50bb('0x33')](_0x50bb('0x11d'),_0x50bb('0x11e'));break;}return db[_[_0x50bb('0x10d')](_0x4d2ecf)+_0x50bb('0x11f')][_0x50bb('0x120')](_0x49cb0d)[_0x50bb('0x27')](function(_0x25e4e6){_0x2a4bc0['count']+=_0x25e4e6[_0x50bb('0x85')];return _['map'](_0x25e4e6['rows'],function(_0x57e16a){var _0x1de5f9=_0x57e16a['get']({'plain':!![]});_0x1de5f9[_0x50bb('0xfb')]=_0x4d2ecf;if(_0x1de5f9[_0x50bb('0x113')]){_0x1de5f9[_0x50bb('0x113')]={'id':_0x1de5f9[_0x50bb('0x113')]['id'],'name':_0x1de5f9[_0x50bb('0x113')][_0x50bb('0x2b')],'fullname':_0x1de5f9[_0x50bb('0x113')][_0x50bb('0x10b')]};}return _0x1de5f9;});});}});return Promise[_0x50bb('0x36')](_0x5894a0);})[_0x50bb('0x27')](function(_0x3d5889){return _(_0x3d5889)[_0x50bb('0x121')]()[_0x50bb('0x122')](_0x50bb('0x10c'))['reverse']()[_0x50bb('0x57')]();})['then'](function(_0x3153b3){_0x2a4bc0[_0x50bb('0xd1')]=_0x5b84fe[_0x50bb('0x22')]?_0x3153b3[_0x50bb('0x123')](_0x5b84fe[_0x50bb('0x21')],_0x5b84fe[_0x50bb('0x21')]+_0x5b84fe[_0x50bb('0x22')]):_0x3153b3;return _0x2a4bc0;})[_0x50bb('0x27')](respondWithFilteredResult(_0x1b7dea,_0x5b84fe))[_0x50bb('0x93')](handleError(_0x1b7dea,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff