// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xc81b=['create','bulkCreate','duplicates','findOrCreate','spread','show','$and','omit','format','pickBy','cf_%d','table','setFields','id\x20=\x20?','toParam','phone','rawAttributes','fields','options','getTags','setTags','ids','getHoppers','includeAll','getHopperHistories','CmHopperHistory','ContactId','include','getHopperFinals','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','socket_timestamp','Incorrect\x20binding\x20parameters\x20passed!','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','root','server/files/tmp','filename','0777','child_process','fork','../../components/import/cm/csv','CompanyId','File\x20uploaded\x20correctly!','pid','upload','createReadStream','parse','file','meta','binding','../../components/import/cm/csv2','stringify','start\x20child\x20process\x20correctly!','exit','error\x20child\x20process','getJourney','mail','chat','sms','openchannel','whatsapp','-createdAt','resolve','channel','includes','toLowerCase','Invalid\x20channel','range','isValid','Invalid\x20date\x20for\x20range\x20from\x20filter','Invalid\x20date\x20for\x20range\x20to\x20filter','Invalid\x20createdAt\x20filter','uniqueid','source','destination','callerid','starttime','endtime','note','createdAt','userDisposition','userSecondDisposition','userThirdDisposition','UserId','fullname','alias','VoiceCallReport','findAndCountAll','startCase','Account','closed','closedAt','disposition','secondDisposition','thirdDisposition','key','Owner','Tags','customerIp','customerPort','deviceModel','osName','ratingMessage','ratingType','ratingValue','referer','subject','threadId','Interaction','flatten','slice','eml-format','zip-dir','request-promise','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','redis','defaults','localhost','socket.io-emitter','register','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','destroy','error','stack','name','send','merge','body','contact','agent','interaction','account','index','CmContact','then','keys','length','startsWith','cf_','push','CmCustomField','findOne','all','type','model','query','filters','intersection','attributes','hasOwnProperty','nolimit','order','sort','where','pick','select','field','color','tools_tags','from','cm_contacts','uc.CmContactId\x20=\x20c.id','left_join','ct.CmContactId\x20=\x20c.id','t.id\x20=\x20ct.TagId','c.deletedAt\x20IS\x20NULL','expr','search','parseSearch','sqlOperator','conditions','find','Tag','value','split','map','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','dateOfBirth','fieldType','datetime','castTo','DATE','text','start','filter','isNil','Contact','isEmpty','ListId','c.ListId\x20IN\x20?','concat','\x20=\x20?','tag','isArray','replace','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','isNumeric','c.id\x20LIKE\x20?','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?','group','Sequelize','QueryTypes','c.id','DESC','having','role','some','getLists','c.ListId\x20IS\x20NULL','sequelize','toString','keyBy','c.firstName','c.lastName','c.phone','c.mobile','c.fax','c.email','c.ListId','c.createdAt','c.deletedAt','c.CompanyId','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','rows','catch','params','describe','tags','columnName','displayName','findAll','values','get','mergeWith','join','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','[CmContact][merge][destroy][CmHopperBlack],\x20%s','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','ReportAgentPreview','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappQueueReport'];(function(_0x5458f6,_0x3630ba){var _0x5259e2=function(_0x492800){while(--_0x492800){_0x5458f6['push'](_0x5458f6['shift']());}};_0x5259e2(++_0x3630ba);}(_0xc81b,0x1a7));var _0xbc81=function(_0x1082fb,_0x4dc1bc){_0x1082fb=_0x1082fb-0x0;var _0x46a5e3=_0xc81b[_0x1082fb];return _0x46a5e3;};'use strict';var emlformat=require(_0xbc81('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xbc81('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0xbc81('0x2'));var moment=require('moment');var BPromise=require(_0xbc81('0x3'));var Mustache=require(_0xbc81('0x4'));var util=require(_0xbc81('0x5'));var path=require(_0xbc81('0x6'));var sox=require(_0xbc81('0x7'));var csv=require(_0xbc81('0x8'));var ejs=require(_0xbc81('0x9'));var fs=require('fs');var fs_extra=require(_0xbc81('0xa'));var _=require(_0xbc81('0xb'));var squel=require(_0xbc81('0xc'));var crypto=require(_0xbc81('0xd'));var jsforce=require(_0xbc81('0xe'));var deskjs=require(_0xbc81('0xf'));var toCsv=require(_0xbc81('0x8'));var querystring=require('querystring');var Papa=require(_0xbc81('0x10'));var Redis=require(_0xbc81('0x11'));var authService=require(_0xbc81('0x12'));var qs=require(_0xbc81('0x13'));var as=require(_0xbc81('0x14'));var hardwareService=require(_0xbc81('0x15'));var logger=require(_0xbc81('0x16'))(_0xbc81('0x17'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];config[_0xbc81('0x18')]=_[_0xbc81('0x19')](config[_0xbc81('0x18')],{'host':_0xbc81('0x1a'),'port':0x18eb});var socket=require(_0xbc81('0x1b'))(new Redis(config[_0xbc81('0x18')]));require('./cmContact.socket')[_0xbc81('0x1c')](socket);function respondWithStatusCode(_0x3dd4dc,_0x128190){_0x128190=_0x128190||0xcc;return function(_0x3809a1){if(_0x3809a1){return _0x3dd4dc[_0xbc81('0x1d')](_0x128190);}return _0x3dd4dc[_0xbc81('0x1e')](_0x128190)[_0xbc81('0x1f')]();};}function respondWithResult(_0x59d679,_0x7ecbcc){_0x7ecbcc=_0x7ecbcc||0xc8;return function(_0x1371cc){if(_0x1371cc){return _0x59d679['status'](_0x7ecbcc)[_0xbc81('0x20')](_0x1371cc);}};}function respondWithFilteredResult(_0x5eb446,_0xb2a39c){return function(_0x39e431){if(_0x39e431){var _0x49116f=typeof _0xb2a39c[_0xbc81('0x21')]===_0xbc81('0x22')&&typeof _0xb2a39c[_0xbc81('0x23')]===_0xbc81('0x22');var _0x3c7d3f=_0x39e431[_0xbc81('0x24')];var _0x282b54=_0x49116f?0x0:_0xb2a39c[_0xbc81('0x21')];var _0x406dce=_0x49116f?_0x39e431['count']:_0xb2a39c[_0xbc81('0x21')]+_0xb2a39c[_0xbc81('0x23')];var _0x223892;if(_0x406dce>=_0x3c7d3f){_0x406dce=_0x3c7d3f;_0x223892=0xc8;}else{_0x223892=0xce;}_0x5eb446[_0xbc81('0x1e')](_0x223892);return _0x5eb446[_0xbc81('0x25')](_0xbc81('0x26'),_0x282b54+'-'+_0x406dce+'/'+_0x3c7d3f)[_0xbc81('0x20')](_0x39e431);}return null;};}function patchUpdates(_0x36d7fc){return function(_0xc079ac){try{jsonpatch[_0xbc81('0x27')](_0xc079ac,_0x36d7fc,!![]);}catch(_0x5cfe8d){return BPromise[_0xbc81('0x28')](_0x5cfe8d);}return _0xc079ac[_0xbc81('0x29')]();};}function saveUpdates(_0x4bd566,_0x33cc98){return function(_0x51f16f){if(_0x51f16f){return _0x51f16f[_0xbc81('0x2a')](_0x4bd566)['then'](function(_0x422b8f){return _0x422b8f;});}return null;};}function removeEntity(_0xf607dd,_0x5df1fa){return function(_0x26d1ae){if(_0x26d1ae){return _0x26d1ae[_0xbc81('0x2b')]()['then'](function(){_0xf607dd[_0xbc81('0x1e')](0xcc)[_0xbc81('0x1f')]();});}};}function handleEntityNotFound(_0x2b330d,_0x27150a){return function(_0x331300){if(!_0x331300){_0x2b330d[_0xbc81('0x1d')](0x194);}return _0x331300;};}function handleError(_0x2179a4,_0x2e44be){_0x2e44be=_0x2e44be||0x1f4;return function(_0x5b0ec3){logger[_0xbc81('0x2c')](_0x5b0ec3[_0xbc81('0x2d')]);if(_0x5b0ec3[_0xbc81('0x2e')]){delete _0x5b0ec3[_0xbc81('0x2e')];}_0x2179a4[_0xbc81('0x1e')](_0x2e44be)[_0xbc81('0x2f')](_0x5b0ec3);};}function getMustacheRender(_0x104688,_0x286f2e){return Mustache['render'](_0x104688,_[_0xbc81('0x30')](_0x286f2e[_0xbc81('0x31')],{'contact':_0x286f2e[_0xbc81('0x32')],'message':_0x286f2e['message'],'agent':_0x286f2e[_0xbc81('0x33')],'interaction':_0x286f2e[_0xbc81('0x34')],'account':_0x286f2e[_0xbc81('0x35')]}))||'';}exports[_0xbc81('0x36')]=function(_0x1e7ef3,_0x3492af){var _0x4386c1={},_0x2c8f41={},_0x1b8df2={'count':0x0,'rows':[]};return db[_0xbc81('0x37')]['describe']()[_0xbc81('0x38')](function(_0x172533){var _0x4c813b=[];for(var _0x32a679=0x0;_0x32a679<Object[_0xbc81('0x39')](_0x172533)[_0xbc81('0x3a')];_0x32a679++){var _0x29365d=Object[_0xbc81('0x39')](_0x172533)[_0x32a679];if(_[_0xbc81('0x3b')](_0x29365d,_0xbc81('0x3c'))){_0x4c813b[_0xbc81('0x3d')](db[_0xbc81('0x3e')][_0xbc81('0x3f')]({'where':{'id':_['trimStart'](_0x29365d,_0xbc81('0x3c'))},'raw':!![]}));}}return BPromise[_0xbc81('0x40')](_0x4c813b)[_0xbc81('0x38')](function(_0x1acfe0){for(var _0x356c0f=0x0;_0x356c0f<_0x1acfe0[_0xbc81('0x3a')];_0x356c0f++){if(_0x1acfe0[_0x356c0f]){var _0x317411='cf_'+_0x1acfe0[_0x356c0f]['id'];var _0x338dd7=_0x172533[_0x317411];_0x338dd7['fieldType']=_0x1acfe0[_0x356c0f][_0xbc81('0x41')];}}return _0x172533;});})[_0xbc81('0x38')](function(_0x487f4e){_0x2c8f41[_0xbc81('0x42')]=_['keys'](_0x487f4e);_0x2c8f41[_0xbc81('0x43')]=_['keys'](_0x1e7ef3[_0xbc81('0x43')]);_0x2c8f41[_0xbc81('0x44')]=_[_0xbc81('0x45')](_0x2c8f41['model'],_0x2c8f41['query']);_0x4386c1[_0xbc81('0x46')]=_[_0xbc81('0x45')](_0x2c8f41[_0xbc81('0x42')],qs['fields'](_0x1e7ef3[_0xbc81('0x43')]['fields']));_0x4386c1[_0xbc81('0x46')]=_0x4386c1[_0xbc81('0x46')][_0xbc81('0x3a')]?_0x4386c1['attributes']:_0x2c8f41[_0xbc81('0x42')];if(!_0x1e7ef3['query'][_0xbc81('0x47')](_0xbc81('0x48'))){_0x4386c1['limit']=qs['limit'](_0x1e7ef3[_0xbc81('0x43')]['limit']);_0x4386c1[_0xbc81('0x21')]=qs['offset'](_0x1e7ef3[_0xbc81('0x43')][_0xbc81('0x21')]);}_0x4386c1[_0xbc81('0x49')]=qs[_0xbc81('0x4a')](_0x1e7ef3[_0xbc81('0x43')][_0xbc81('0x4a')]);_0x4386c1[_0xbc81('0x4b')]=qs[_0xbc81('0x44')](_[_0xbc81('0x4c')](_0x1e7ef3[_0xbc81('0x43')],_0x2c8f41[_0xbc81('0x44')]),_0x487f4e);var _0x4b493a=[];var _0x91e0c2=squel[_0xbc81('0x4d')]()[_0xbc81('0x4e')]('id')['field']('name')[_0xbc81('0x4e')](_0xbc81('0x4f'))['from'](_0xbc81('0x50'));var _0x4925fa=squel[_0xbc81('0x4d')]()[_0xbc81('0x51')](_0xbc81('0x52'),'c')['left_join']('cm_user_has_contacts','uc',_0xbc81('0x53'))[_0xbc81('0x54')]('cm_contact_has_tags','ct',_0xbc81('0x55'))[_0xbc81('0x54')](_0xbc81('0x50'),'t',_0xbc81('0x56'))[_0xbc81('0x4b')](_0xbc81('0x57'));var _0x2ff792=squel['expr']();var _0x58c6cc=[];var _0x168063=squel[_0xbc81('0x58')]();var _0x2529e6;if(_0x1e7ef3['query'][_0xbc81('0x59')]){_0x2529e6=as[_0xbc81('0x5a')](_0x1e7ef3[_0xbc81('0x43')][_0xbc81('0x59')]);var _0x3292d9=_0x2529e6[_0xbc81('0x5b')];for(var _0x835b3a=0x0;_0x835b3a<_0x2529e6[_0xbc81('0x5c')][_0xbc81('0x3a')];_0x835b3a++){var _0x262295=_0x2529e6[_0xbc81('0x5c')][_0x835b3a];var _0x40b34c='c';var _0x71ee4d=_(_0x487f4e)['keys']()[_0xbc81('0x5d')](function(_0x172864){return _0x172864===_0x262295[_0xbc81('0x4e')];});if(_0x71ee4d)_0x71ee4d=_0x487f4e[_0x262295['field']];if(!_0x71ee4d){if(_0x262295[_0xbc81('0x4e')]===_0xbc81('0x5e')){var _0x23399b=_0x262295[_0xbc81('0x5f')][_0xbc81('0x60')](',')[_0xbc81('0x61')](function(_0x29d955){return Number(_0x29d955);});_0x23399b[_0xbc81('0x62')](function(_0x36c1bd){_0x168063['or'](_0xbc81('0x63'),'%,'+_0x36c1bd+',%');});_0x58c6cc=_[_0xbc81('0x64')](_0x58c6cc,_0x23399b);}else if(_0x262295[_0xbc81('0x4e')]===_0xbc81('0x65')){_0x2ff792['and']('uc.UserId\x20=\x20?',_0x262295[_0xbc81('0x5f')]);}}else{if(_0x262295[_0xbc81('0x4e')]===_0xbc81('0x66')||_0x71ee4d[_0xbc81('0x67')]===_0xbc81('0x68'))_0x262295[_0xbc81('0x69')]=_0xbc81('0x6a');var _0x273180=as['buildExpression'](_0x40b34c,_0x71ee4d[_0xbc81('0x41')],_0x262295);_0x2ff792[_0x3292d9](_0x273180[_0xbc81('0x6b')],_0x273180['value'][_0xbc81('0x6c')],_0x273180[_0xbc81('0x5f')][_0xbc81('0x1f')]);}}}else{var _0x5593ad=_(Object[_0xbc81('0x39')](_0x1e7ef3[_0xbc81('0x43')]))[_0xbc81('0x61')](function(_0x59384a){return _0x487f4e[_0xbc81('0x47')](_0x59384a)?_0x59384a:undefined;})[_0xbc81('0x6d')](function(_0x3d5011){return!_[_0xbc81('0x6e')](_0x3d5011);})[_0xbc81('0x5f')]();if(_0x1e7ef3[_0xbc81('0x43')][_0xbc81('0x6f')])_0x5593ad[_0xbc81('0x3d')](_0xbc81('0x6f'));if(!_[_0xbc81('0x70')](_0x5593ad)){_0x5593ad[_0xbc81('0x62')](function(_0x335c61){if(_0x335c61===_0xbc81('0x71')){_0x4925fa[_0xbc81('0x4b')](_0xbc81('0x72'),[][_0xbc81('0x73')](_0x1e7ef3['query'][_0x335c61]));}else if(_0x335c61==='Contact'){var _0x456d9e='%'+_0x1e7ef3[_0xbc81('0x43')][_0x335c61]+'%';_0x4925fa[_0xbc81('0x4b')]('CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?',_0x456d9e);}else{_0x4925fa[_0xbc81('0x4b')]('c.'+_0x335c61+_0xbc81('0x74'),_0x1e7ef3[_0xbc81('0x43')][_0x335c61]);}});}if(_0x1e7ef3[_0xbc81('0x43')][_0xbc81('0x75')]){_0x58c6cc=_[_0xbc81('0x76')](_0x1e7ef3[_0xbc81('0x43')][_0xbc81('0x75')])?_0x1e7ef3['query'][_0xbc81('0x75')]:new Array(_0x1e7ef3[_0xbc81('0x43')]['tag']);_0x58c6cc[_0xbc81('0x62')](function(_0x1feed3){_0x168063['or'](_0xbc81('0x63'),'%,'+_0x1feed3+',%');});}if(_0x1e7ef3[_0xbc81('0x43')][_0xbc81('0x6d')]){var _0x2672b3=_0x1e7ef3[_0xbc81('0x43')]['filter'][_0xbc81('0x77')]('\x5c','\x5c\x5c')[_0xbc81('0x77')](/'/g,'\x27\x27');if(_0x2672b3[_0xbc81('0x60')]('\x20')[_0xbc81('0x3a')]>0x1){_0x2ff792['or'](_0xbc81('0x78'),qs['getFullTextValue'](_0x2672b3),null);}else{if(qs[_0xbc81('0x79')](_0x2672b3)){_0x2ff792['or'](_0xbc81('0x7a'),_0x2672b3+'%');_0x2ff792['or'](_0xbc81('0x7b'),_0x2672b3+'%');_0x2ff792['or'](_0xbc81('0x7c'),_0x2672b3+'%');_0x2ff792['or']('c.fax\x20LIKE\x20?',_0x2672b3+'%');}else if(qs['isEmail'](_0x2672b3)){_0x2ff792['or'](_0xbc81('0x7d'),_0x2672b3+'%');}else{_0x2ff792['or'](_0xbc81('0x7e'),'%'+_0x2672b3+'%');_0x2ff792['or']('c.lastName\x20LIKE\x20?','%'+_0x2672b3+'%');_0x2ff792['or'](_0xbc81('0x7d'),'%'+_0x2672b3+'%');}}}}_0x4925fa[_0xbc81('0x4b')](_0x2ff792);_0x4925fa[_0xbc81('0x7f')]('c.id');var _0x5eb566={'type':db[_0xbc81('0x80')][_0xbc81('0x81')]['SELECT'],'raw':!![]};var _0xa9f714=_0x4925fa['clone']()[_0xbc81('0x4e')](_0xbc81('0x82'));if(_0x4386c1['order']){_0x4386c1[_0xbc81('0x49')][_0xbc81('0x62')](function(_0xa94733){_0x4925fa[_0xbc81('0x49')]('c.'+_0xa94733[0x0],_0xa94733[0x1]===_0xbc81('0x83')?![]:!![]);});}if(!_[_0xbc81('0x70')](_0x58c6cc)){_0x4925fa[_0xbc81('0x84')](_0x168063);_0xa9f714[_0xbc81('0x4b')]('t.id\x20IN\x20?',_0x58c6cc);}BPromise['resolve']()[_0xbc81('0x38')](function(){if(!_0x2529e6)return;if(_0x1e7ef3['user'][_0xbc81('0x85')]!==_0xbc81('0x33'))return;if(!_[_0xbc81('0x86')](_0x2529e6[_0xbc81('0x5c')],[_0xbc81('0x4e'),_0xbc81('0x65')])){return _0x1e7ef3['user'][_0xbc81('0x87')]({'attributes':['id'],'raw':!![]})['then'](function(_0x1dba70){if(_['isEmpty'](_0x1dba70)){_0xa9f714[_0xbc81('0x4b')](_0xbc81('0x88'));_0x4925fa['where']('c.ListId\x20IS\x20NULL');}else{_0xa9f714[_0xbc81('0x4b')](_0xbc81('0x72'),_[_0xbc81('0x61')](_0x1dba70,'id'));_0x4925fa[_0xbc81('0x4b')](_0xbc81('0x72'),_[_0xbc81('0x61')](_0x1dba70,'id'));}});}})[_0xbc81('0x38')](function(){if(_0x1e7ef3['user'][_0xbc81('0x85')]===_0xbc81('0x33')&&!_0x2529e6&&!_0x1e7ef3[_0xbc81('0x43')][_0xbc81('0x71')])return[];return db[_0xbc81('0x89')][_0xbc81('0x43')](_0xa9f714[_0xbc81('0x8a')](),_0x5eb566);})['then'](function(_0x81275d){_0x1b8df2[_0xbc81('0x24')]=_0x81275d[_0xbc81('0x3a')];if(_0x1b8df2[_0xbc81('0x24')]===0x0)return[];return db[_0xbc81('0x89')][_0xbc81('0x43')](_0x91e0c2[_0xbc81('0x8a')](),_0x5eb566)[_0xbc81('0x38')](function(_0x45ec48){_0x4b493a=_[_0xbc81('0x8b')](_0x45ec48,'id');_0x5eb566=_[_0xbc81('0x30')](_0x5eb566,{'model':db['CmContact'],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x1e7ef3[_0xbc81('0x43')]['fields']){_0x4386c1[_0xbc81('0x46')][_0xbc81('0x62')](function(_0x541e27){_0x4925fa[_0xbc81('0x4e')]('c.'+_0x541e27);});}else{_0x4925fa[_0xbc81('0x4e')](_0xbc81('0x82'));_0x4925fa[_0xbc81('0x4e')](_0xbc81('0x8c'));_0x4925fa['field'](_0xbc81('0x8d'));_0x4925fa[_0xbc81('0x4e')](_0xbc81('0x8e'));_0x4925fa[_0xbc81('0x4e')](_0xbc81('0x8f'));_0x4925fa[_0xbc81('0x4e')](_0xbc81('0x90'));_0x4925fa['field'](_0xbc81('0x91'));_0x4925fa[_0xbc81('0x4e')](_0xbc81('0x92'));_0x4925fa[_0xbc81('0x4e')](_0xbc81('0x93'));_0x4925fa[_0xbc81('0x4e')](_0xbc81('0x94'));_0x4925fa[_0xbc81('0x4e')](_0xbc81('0x95'));_0x4925fa[_0xbc81('0x4e')](_0xbc81('0x96'),'TagIds');}if(_0x4386c1[_0xbc81('0x23')])_0x4925fa[_0xbc81('0x23')](_0x4386c1['limit']);if(_0x4386c1[_0xbc81('0x21')])_0x4925fa[_0xbc81('0x21')](_0x4386c1[_0xbc81('0x21')]);return db[_0xbc81('0x89')][_0xbc81('0x43')](_0x4925fa[_0xbc81('0x8a')](),_0x5eb566);});})[_0xbc81('0x38')](function(_0x55f10c){_0x55f10c['forEach'](function(_0x1a4de3){if(_0x1a4de3[_0xbc81('0x97')]){_0x1a4de3['Tags']=[];_0x1a4de3['TagIds']['split'](',')[_0xbc81('0x62')](function(_0x4c291a){_0x1a4de3['Tags'][_0xbc81('0x3d')](_0x4b493a[_0x4c291a]);});}delete _0x1a4de3[_0xbc81('0x97')];});_0x1b8df2[_0xbc81('0x98')]=_0x55f10c;return _0x1b8df2;})[_0xbc81('0x38')](respondWithFilteredResult(_0x3492af,_0x4386c1));})[_0xbc81('0x99')](handleError(_0x3492af,null));};exports[_0xbc81('0x2b')]=function(_0x125dfc,_0x23dc6c){return db[_0xbc81('0x37')]['find']({'where':{'id':_0x125dfc[_0xbc81('0x9a')]['id']}})[_0xbc81('0x38')](handleEntityNotFound(_0x23dc6c,null))[_0xbc81('0x38')](removeEntity(_0x23dc6c,null))['catch'](handleError(_0x23dc6c,null));};exports[_0xbc81('0x9b')]=function(_0x59b37b,_0x41f137){return db['CmContact'][_0xbc81('0x9b')]()[_0xbc81('0x38')](function(_0xee9f3){delete _0xee9f3[_0xbc81('0x9c')];for(var _0x80edbd=0x0;_0x80edbd<Object['keys'](_0xee9f3)[_0xbc81('0x3a')];_0x80edbd++){var _0x5b2ce9=Object[_0xbc81('0x39')](_0xee9f3)[_0x80edbd];if(!_[_0xbc81('0x3b')](_0x5b2ce9,_0xbc81('0x3c'))){_0xee9f3[_0x5b2ce9][_0xbc81('0x9d')]=_0x5b2ce9;_0xee9f3[_0x5b2ce9][_0xbc81('0x9e')]=_0x5b2ce9;}}return _0xee9f3;})[_0xbc81('0x38')](function(_0x25ea2a){var _0x458c48={'where':{'$or':[{'ListId':_0x59b37b[_0xbc81('0x43')]['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField'][_0xbc81('0x9f')](_0x458c48)[_0xbc81('0x38')](function(_0x33dcc7){for(var _0x83029d=0x0;_0x83029d<_0x33dcc7[_0xbc81('0x3a')];_0x83029d++){var _0x15b692=_0xbc81('0x3c')+_0x33dcc7[_0x83029d]['id'];_0x25ea2a[_0x15b692]['columnName']=_0x15b692;_0x25ea2a[_0x15b692][_0xbc81('0x9e')]=_0x33dcc7[_0x83029d]['alias'];_0x25ea2a[_0x15b692]['custom']={'type':_0x33dcc7[_0x83029d][_0xbc81('0x41')],'values':_0x33dcc7[_0x83029d][_0xbc81('0xa0')]};}Object['keys'](_0x25ea2a)['forEach'](function(_0x134c18){if(!_0x25ea2a[_0x134c18][_0xbc81('0x47')](_0xbc81('0x9d'))){delete _0x25ea2a[_0x134c18];}});return _0x25ea2a;});})[_0xbc81('0x38')](respondWithResult(_0x41f137,null))[_0xbc81('0x99')](handleError(_0x41f137,null));};exports['merge']=function(_0x249608,_0x4bbee8){var _0x42b776;var _0x5d3a83;var _0x1e4338;if(_0x249608['body']['id']){delete _0x249608[_0xbc81('0x31')]['id'];}return db[_0xbc81('0x37')][_0xbc81('0x9f')]({'where':{'id':[_0x249608[_0xbc81('0x31')]['to'],_0x249608[_0xbc81('0x31')][_0xbc81('0x51')]]}})['then'](function(_0x248a65){if(_0x248a65){if(_0x248a65[_0xbc81('0x3a')]!==0x2){return null;}_0x248a65[0x0]=_0x248a65[0x0][_0xbc81('0xa1')]({'plain':!![]});_0x248a65[0x1]=_0x248a65[0x1]['get']({'plain':!![]});delete _0x248a65[0x0]['id'];delete _0x248a65[0x1]['id'];return _[_0xbc81('0xa2')](_0x248a65[0x0],_0x248a65[0x1],function(_0x5b11f0,_0x58915f){if(Array[_0xbc81('0x76')](_0x58915f)&&!_0x58915f[_0xbc81('0x3a')]){return _0x5b11f0;}else if(!_0x58915f){return _0x5b11f0;}});}})[_0xbc81('0x38')](handleEntityNotFound(_0x4bbee8,null))[_0xbc81('0x38')](function(_0x314b15){if(_0x314b15){if(_0x314b15[_0xbc81('0x9c')]&&_[_0xbc81('0x76')](_0x314b15['tags'])){_0x314b15[_0xbc81('0x9c')]=_0x314b15[_0xbc81('0x9c')][_0xbc81('0xa3')]();}logger[_0xbc81('0xa4')](_0xbc81('0xa5'),_0x249608['body']['to'],_0x249608[_0xbc81('0x31')][_0xbc81('0x51')]);return db[_0xbc81('0xa6')][_0xbc81('0x2b')]({'where':{'ContactId':[_0x249608[_0xbc81('0x31')]['to'],_0x249608[_0xbc81('0x31')][_0xbc81('0x51')]]}})[_0xbc81('0x38')](function(_0x59a0ee){logger[_0xbc81('0xa4')](_0xbc81('0xa7'),_0x59a0ee);return db['CmHopperBlack'][_0xbc81('0x2b')]({'where':{'ContactId':[_0x249608[_0xbc81('0x31')]['to'],_0x249608[_0xbc81('0x31')]['from']]}})[_0xbc81('0x38')](function(_0x4d7211){logger['info'](_0xbc81('0xa8'),_0x4d7211);return db[_0xbc81('0x37')]['create'](_0x314b15);});});}})['then'](function(_0x16af04){if(_0x16af04){_0x42b776=_0x16af04;_0x5d3a83={'ContactId':_0x42b776['id']};_0x1e4338={'where':{'ContactId':[_0x249608['body']['to'],_0x249608[_0xbc81('0x31')]['from']]}};return db[_0xbc81('0xa9')][_0xbc81('0x2a')](_0x5d3a83,_0x1e4338);}})['then'](function(){if(_0x42b776){return db[_0xbc81('0xaa')][_0xbc81('0x2a')](_0x5d3a83,_0x1e4338);}})[_0xbc81('0x38')](function(){if(_0x42b776){return db[_0xbc81('0xab')][_0xbc81('0x2a')](_0x5d3a83,_0x1e4338);}})[_0xbc81('0x38')](function(){if(_0x42b776){return db[_0xbc81('0xac')][_0xbc81('0x2a')](_0x5d3a83,_0x1e4338);}})['then'](function(){if(_0x42b776){return db[_0xbc81('0xad')][_0xbc81('0x2a')](_0x5d3a83,_0x1e4338);}})[_0xbc81('0x38')](function(){if(_0x42b776){return db[_0xbc81('0xac')]['update'](_0x5d3a83,_0x1e4338);}})[_0xbc81('0x38')](function(){if(_0x42b776){return db[_0xbc81('0xad')][_0xbc81('0x2a')](_0x5d3a83,_0x1e4338);}})[_0xbc81('0x38')](function(){if(_0x42b776){return db[_0xbc81('0xae')][_0xbc81('0x2a')](_0x5d3a83,_0x1e4338);}})[_0xbc81('0x38')](function(){if(_0x42b776){return db[_0xbc81('0xaf')][_0xbc81('0x2a')](_0x5d3a83,_0x1e4338);}})[_0xbc81('0x38')](function(){if(_0x42b776){return db[_0xbc81('0xb0')][_0xbc81('0x2a')](_0x5d3a83,_0x1e4338);}})[_0xbc81('0x38')](function(){if(_0x42b776){return db['FaxMessage']['update'](_0x5d3a83,_0x1e4338);}})[_0xbc81('0x38')](function(){if(_0x42b776){return db[_0xbc81('0xb1')][_0xbc81('0x2a')](_0x5d3a83,_0x1e4338);}})['then'](function(){if(_0x42b776){return db[_0xbc81('0xb2')][_0xbc81('0x2a')](_0x5d3a83,_0x1e4338);}})['then'](function(){if(_0x42b776){return db[_0xbc81('0xb3')]['update'](_0x5d3a83,_0x1e4338);}})[_0xbc81('0x38')](function(){if(_0x42b776){return db['CmHopperHistory'][_0xbc81('0x2a')](_0x5d3a83,_0x1e4338);}})[_0xbc81('0x38')](function(){if(_0x42b776){return db[_0xbc81('0xb4')]['update'](_0x5d3a83,_0x1e4338);}})[_0xbc81('0x38')](function(){if(_0x42b776){return db['VoiceCallReport'][_0xbc81('0x2a')](_0x5d3a83,_0x1e4338);}})['then'](function(){if(_0x42b776){return db[_0xbc81('0xb5')][_0xbc81('0x2a')](_0x5d3a83,_0x1e4338);}})['then'](function(){if(_0x42b776){return db[_0xbc81('0xb6')]['update'](_0x5d3a83,_0x1e4338);}})[_0xbc81('0x38')](function(){if(_0x42b776){return db[_0xbc81('0xb7')][_0xbc81('0x2a')](_0x5d3a83,_0x1e4338);}})[_0xbc81('0x38')](function(){if(_0x42b776){return db[_0xbc81('0xb8')][_0xbc81('0x2a')](_0x5d3a83,_0x1e4338);}})[_0xbc81('0x38')](function(){if(_0x42b776){return db[_0xbc81('0xb9')][_0xbc81('0x2a')](_0x5d3a83,_0x1e4338);}})[_0xbc81('0x38')](function(){if(_0x42b776){return db[_0xbc81('0xba')][_0xbc81('0x2a')](_0x5d3a83,_0x1e4338);}})[_0xbc81('0x38')](function(){if(_0x42b776){return db[_0xbc81('0xbb')][_0xbc81('0x2a')](_0x5d3a83,_0x1e4338);}})['then'](function(){if(_0x42b776){return db['WhatsappMessage'][_0xbc81('0x2a')](_0x5d3a83,_0x1e4338);}})[_0xbc81('0x38')](function(){if(_0x42b776){return db[_0xbc81('0xbc')][_0xbc81('0x2a')](_0x5d3a83,_0x1e4338);}})[_0xbc81('0x38')](function(){if(_0x42b776){return db['CmContact'][_0xbc81('0x2b')]({'where':{'id':[_0x249608['body']['to'],_0x249608[_0xbc81('0x31')]['from']]}});}})['then'](function(){if(_0x42b776){return _0x42b776;}})[_0xbc81('0x38')](respondWithResult(_0x4bbee8,null))['catch'](handleError(_0x4bbee8,null));};exports[_0xbc81('0xbd')]=function(_0x1a7df7,_0x25e7d2){return db[_0xbc81('0x37')]['describe']()['then'](function(_0xe48695){if(_0x1a7df7[_0xbc81('0x31')]['tags']&&_[_0xbc81('0x76')](_0x1a7df7[_0xbc81('0x31')]['tags'])){if(_0x1a7df7['body'][_0xbc81('0x9c')][_0xbc81('0x3a')]){_0x1a7df7['body'][_0xbc81('0x9c')]=_0x1a7df7[_0xbc81('0x31')][_0xbc81('0x9c')][_0xbc81('0xa3')](';')+';';}else{_0x1a7df7[_0xbc81('0x31')][_0xbc81('0x9c')]=null;}}else{_0x1a7df7[_0xbc81('0x31')][_0xbc81('0x9c')]=null;}return db[_0xbc81('0x37')][_0xbc81('0xbd')](_0x1a7df7[_0xbc81('0x31')],{'fields':_[_0xbc81('0x39')](_0xe48695),'raw':!![]});})[_0xbc81('0x38')](respondWithResult(_0x25e7d2,0xc9))['catch'](handleError(_0x25e7d2,null));};exports[_0xbc81('0xbe')]=function(_0x38b9aa,_0x29c909){var _0x5383db=[];var _0x28f95a=0x0;var _0x226df9=0x0;var _0x262dd5=0x0;return db['CmContact'][_0xbc81('0x9b')]()[_0xbc81('0x38')](function(_0x2ceec1){return BPromise['each'](_0x38b9aa[_0xbc81('0x31')],function(_0x2e8e48){var _0xf5b5d2={'where':{'$or':[]},'defaults':_0x2e8e48,'fields':_[_0xbc81('0x39')](_0x2ceec1),'raw':!![]};if(_0x2e8e48['duplicates']){for(var _0x5a7dd7=0x0;_0x5a7dd7<_0x2e8e48[_0xbc81('0xbf')][_0xbc81('0x3a')];_0x5a7dd7++){var _0x36ed5b={};_0x36ed5b[_0x2e8e48[_0xbc81('0xbf')][_0x5a7dd7]]=_0x2e8e48[_0x2e8e48['duplicates'][_0x5a7dd7]];_0xf5b5d2[_0xbc81('0x4b')]['$or'][_0xbc81('0x3d')](_0x36ed5b);}_0xf5b5d2['where'][_0xbc81('0x71')]=_0x2e8e48['ListId'];}return db[_0xbc81('0x37')][_0xbc81('0xc0')](_0xf5b5d2)[_0xbc81('0xc1')](function(_0x52aa6f,_0x565b47){if(_0x565b47){_0x28f95a++;}else{_0x262dd5++;}})[_0xbc81('0x99')](function(_0x42d3c8){console[_0xbc81('0x2c')](_0x42d3c8);_0x226df9++;});});})['then'](function(_0x5d4c05){if(_0x5d4c05){return{'success':_0x28f95a,'failure':_0x226df9,'duplicates':_0x262dd5};}})[_0xbc81('0x38')](respondWithResult(_0x29c909,0xc9))[_0xbc81('0x99')](handleError(_0x29c909,null));};exports[_0xbc81('0xc2')]=function(_0x386ac7,_0x44a798,_0x1dbbbe){var _0x2cae41;return db[_0xbc81('0x37')][_0xbc81('0x9b')]()['then'](function(_0x49f58c){return db[_0xbc81('0x37')]['find']({'where':{'id':_0x386ac7[_0xbc81('0x9a')]['id']},'include':[{'model':db['Tag'],'as':'Tags','attributes':['id','name','color'],'required':_0x386ac7[_0xbc81('0x43')]['tag']?!![]:![]}],'attributes':_['keys'](_0x49f58c)});})[_0xbc81('0x38')](function(_0x352370){_0x2cae41=_0x352370[_0xbc81('0xa1')]({'plain':!![]});var _0x521b18={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x352370&&_0x352370['ListId']){if(_0x352370['ListId']){_0x521b18[_0xbc81('0x4b')][_0xbc81('0xc3')]['push']({'ListId':{'$ne':_0x352370[_0xbc81('0x71')]}});}}return db[_0xbc81('0x3e')][_0xbc81('0x9f')](_0x521b18);})[_0xbc81('0x38')](function(_0x473296){return _[_0xbc81('0xc4')](_0x2cae41,_[_0xbc81('0x61')](_0x473296,function(_0x488195){return util[_0xbc81('0xc5')]('cf_%d',_0x488195['id']);}));})[_0xbc81('0x38')](handleEntityNotFound(_0x44a798,null))[_0xbc81('0x38')](respondWithResult(_0x44a798,null))['catch'](handleError(_0x44a798,null));};exports[_0xbc81('0x2a')]=function(_0xb11de,_0x135207){var _0x5b48fc;if(_0xb11de[_0xbc81('0x31')]['id']){delete _0xb11de[_0xbc81('0x31')]['id'];}return db[_0xbc81('0x37')][_0xbc81('0x5d')]({'where':{'id':_0xb11de[_0xbc81('0x9a')]['id']}})[_0xbc81('0x38')](handleEntityNotFound(_0x135207,null))[_0xbc81('0x38')](saveUpdates(_0xb11de['body'],null))[_0xbc81('0x38')](function(_0x1b8980){_0x5b48fc=_0x1b8980;var _0x126cb3={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x1b8980&&_0x1b8980[_0xbc81('0x71')]){if(_0x1b8980[_0xbc81('0x71')]){_0x126cb3[_0xbc81('0x4b')][_0xbc81('0xc3')][_0xbc81('0x3d')]({'ListId':{'$ne':_0x1b8980[_0xbc81('0x71')]}});}}return db[_0xbc81('0x3e')]['findAll'](_0x126cb3);})[_0xbc81('0x38')](function(_0x55d4da){if(_0x55d4da){return _[_0xbc81('0xc4')](_[_0xbc81('0xc6')](_0xb11de[_0xbc81('0x31')],function(_0x5bc71e,_0x1e3b43){return _[_0xbc81('0x3b')](_0x1e3b43,_0xbc81('0x3c'));}),_['map'](_0x55d4da,function(_0x9f10b9){return util['format'](_0xbc81('0xc7'),_0x9f10b9['id']);}));}})[_0xbc81('0x38')](function(_0x2107e9){if(_0x2107e9&&!_[_0xbc81('0x70')](_0x2107e9)){var _0x57bf96=squel[_0xbc81('0x2a')]()[_0xbc81('0xc8')](_0xbc81('0x52'))[_0xbc81('0xc9')](_0x2107e9)[_0xbc81('0x4b')](_0xbc81('0xca'),_0xb11de[_0xbc81('0x9a')]['id'])[_0xbc81('0xcb')]();return db[_0xbc81('0x89')][_0xbc81('0x43')](_0x57bf96[_0xbc81('0x6b')],{'replacements':_0x57bf96['values']});}})[_0xbc81('0x38')](function(){if(_0xb11de[_0xbc81('0x31')][_0xbc81('0xcc')]&&_0x5b48fc){return db[_0xbc81('0xa6')]['update']({'phone':_0xb11de[_0xbc81('0x31')]['phone']},{'where':{'ContactId':_0x5b48fc['id']}});}})[_0xbc81('0x38')](function(){return _0x5b48fc;})[_0xbc81('0x38')](respondWithResult(_0x135207,null))[_0xbc81('0x99')](handleError(_0x135207,null));};exports['getTags']=function(_0x58ce3b,_0x4e05d8,_0x276194){var _0x9aed34={};var _0x54de3b={};var _0x31e860;var _0x3b0c44;return db[_0xbc81('0x37')][_0xbc81('0x3f')]({'where':{'id':_0x58ce3b[_0xbc81('0x9a')]['id']}})[_0xbc81('0x38')](handleEntityNotFound(_0x4e05d8,null))[_0xbc81('0x38')](function(_0x306ee1){if(_0x306ee1){_0x31e860=_0x306ee1;_0x54de3b[_0xbc81('0x42')]=_[_0xbc81('0x39')](db[_0xbc81('0x5e')][_0xbc81('0xcd')]);_0x54de3b[_0xbc81('0x43')]=_[_0xbc81('0x39')](_0x58ce3b[_0xbc81('0x43')]);_0x54de3b['filters']=_['intersection'](_0x54de3b[_0xbc81('0x42')],_0x54de3b[_0xbc81('0x43')]);_0x9aed34[_0xbc81('0x46')]=_[_0xbc81('0x45')](_0x54de3b['model'],qs[_0xbc81('0xce')](_0x58ce3b[_0xbc81('0x43')][_0xbc81('0xce')]));_0x9aed34[_0xbc81('0x46')]=_0x9aed34[_0xbc81('0x46')][_0xbc81('0x3a')]?_0x9aed34[_0xbc81('0x46')]:_0x54de3b[_0xbc81('0x42')];_0x9aed34[_0xbc81('0x49')]=qs[_0xbc81('0x4a')](_0x58ce3b['query'][_0xbc81('0x4a')]);_0x9aed34[_0xbc81('0x4b')]=qs[_0xbc81('0x44')](_[_0xbc81('0x4c')](_0x58ce3b[_0xbc81('0x43')],_0x54de3b[_0xbc81('0x44')]));if(_0x58ce3b[_0xbc81('0x43')][_0xbc81('0x6d')]){_0x9aed34['where']=_[_0xbc81('0x30')](_0x9aed34[_0xbc81('0x4b')],{'$or':_[_0xbc81('0x61')](_0x9aed34[_0xbc81('0x46')],function(_0x22d1f0){var _0x12d7cd={};_0x12d7cd[_0x22d1f0]={'$like':'%'+_0x58ce3b[_0xbc81('0x43')]['filter']+'%'};return _0x12d7cd;})});}_0x9aed34=_['merge']({},_0x9aed34,_0x58ce3b[_0xbc81('0xcf')]);return _0x31e860[_0xbc81('0xd0')](_0x9aed34);}})[_0xbc81('0x38')](function(_0x1d359c){if(_0x1d359c){_0x3b0c44=_0x1d359c['length'];if(!_0x58ce3b[_0xbc81('0x43')][_0xbc81('0x47')](_0xbc81('0x48'))){_0x9aed34[_0xbc81('0x23')]=qs[_0xbc81('0x23')](_0x58ce3b[_0xbc81('0x43')][_0xbc81('0x23')]);_0x9aed34[_0xbc81('0x21')]=qs['offset'](_0x58ce3b[_0xbc81('0x43')][_0xbc81('0x21')]);}return _0x31e860[_0xbc81('0xd0')](_0x9aed34);}})[_0xbc81('0x38')](function(_0x424285){if(_0x424285){return _0x424285?{'count':_0x3b0c44,'rows':_0x424285}:null;}})[_0xbc81('0x38')](respondWithResult(_0x4e05d8,null))[_0xbc81('0x99')](handleError(_0x4e05d8,null));};exports[_0xbc81('0xd1')]=function(_0x268d5a,_0x2dbb84,_0x4243aa){if(_0x268d5a[_0xbc81('0x31')]['id']){delete _0x268d5a[_0xbc81('0x31')]['id'];}return db[_0xbc81('0x37')][_0xbc81('0x3f')]({'where':{'id':_0x268d5a[_0xbc81('0x9a')]['id']}})[_0xbc81('0x38')](handleEntityNotFound(_0x2dbb84,null))[_0xbc81('0x38')](function(_0x22e101){if(_0x22e101){return _0x22e101[_0xbc81('0xd1')](_0x268d5a[_0xbc81('0x31')][_0xbc81('0xd2')]||[]);}return null;})[_0xbc81('0x38')](respondWithResult(_0x2dbb84,null))[_0xbc81('0x99')](handleError(_0x2dbb84,null));};exports[_0xbc81('0xd3')]=function(_0x5060ae,_0x1932b2,_0xb8ab39){var _0x4bcc5f={'raw':![],'where':{}};var _0xe25f01={};var _0x54dff8={'count':0x0,'rows':[]};return db[_0xbc81('0x37')][_0xbc81('0x3f')]({'where':{'id':_0x5060ae[_0xbc81('0x9a')]['id']}})['then'](handleEntityNotFound(_0x1932b2,null))[_0xbc81('0x38')](function(_0x3946df){if(_0x3946df){_0xe25f01[_0xbc81('0x42')]=_['keys'](db[_0xbc81('0xa6')][_0xbc81('0xcd')]);_0xe25f01[_0xbc81('0x43')]=_[_0xbc81('0x39')](_0x5060ae[_0xbc81('0x43')]);_0xe25f01[_0xbc81('0x44')]=_[_0xbc81('0x45')](_0xe25f01[_0xbc81('0x42')],_0xe25f01[_0xbc81('0x43')]);_0x4bcc5f[_0xbc81('0x46')]=_[_0xbc81('0x45')](_0xe25f01[_0xbc81('0x42')],qs[_0xbc81('0xce')](_0x5060ae[_0xbc81('0x43')][_0xbc81('0xce')]));_0x4bcc5f['attributes']=_0x4bcc5f['attributes'][_0xbc81('0x3a')]?_0x4bcc5f[_0xbc81('0x46')]:_0xe25f01[_0xbc81('0x42')];if(!_0x5060ae[_0xbc81('0x43')][_0xbc81('0x47')](_0xbc81('0x48'))){_0x4bcc5f['limit']=qs[_0xbc81('0x23')](_0x5060ae[_0xbc81('0x43')]['limit']);_0x4bcc5f[_0xbc81('0x21')]=qs[_0xbc81('0x21')](_0x5060ae[_0xbc81('0x43')][_0xbc81('0x21')]);}_0x4bcc5f['order']=qs['sort'](_0x5060ae[_0xbc81('0x43')][_0xbc81('0x4a')]);_0x4bcc5f[_0xbc81('0x4b')]=qs[_0xbc81('0x44')](_[_0xbc81('0x4c')](_0x5060ae[_0xbc81('0x43')],_0xe25f01[_0xbc81('0x44')]));_0x4bcc5f[_0xbc81('0x4b')]['ContactId']=_0x3946df['id'];if(_0x5060ae[_0xbc81('0x43')]['filter']){_0x4bcc5f[_0xbc81('0x4b')]=_['merge'](_0x4bcc5f[_0xbc81('0x4b')],{'$or':_[_0xbc81('0x61')](_0x4bcc5f[_0xbc81('0x46')],function(_0x58b22d){var _0x17442d={};_0x17442d[_0x58b22d]={'$like':'%'+_0x5060ae[_0xbc81('0x43')][_0xbc81('0x6d')]+'%'};return _0x17442d;})});}_0x4bcc5f=_['merge']({},_0x4bcc5f,_0x5060ae[_0xbc81('0xcf')]);return db[_0xbc81('0xa6')][_0xbc81('0x24')]({'where':_0x4bcc5f[_0xbc81('0x4b')]})[_0xbc81('0x38')](function(_0x18bd2d){_0x54dff8['count']=_0x18bd2d;if(_0x5060ae['query'][_0xbc81('0xd4')]){_0x4bcc5f['include']=[{'all':!![]}];}return db[_0xbc81('0xa6')][_0xbc81('0x9f')](_0x4bcc5f);})[_0xbc81('0x38')](function(_0x496db7){_0x54dff8[_0xbc81('0x98')]=_0x496db7;return _0x54dff8;});}})[_0xbc81('0x38')](respondWithFilteredResult(_0x1932b2,_0x4bcc5f))['catch'](handleError(_0x1932b2,null));};exports[_0xbc81('0xd5')]=function(_0x513867,_0x302a74,_0x2b9592){var _0x842219={'raw':!![],'where':{}};var _0x51d258={};var _0x168b03={'count':0x0,'rows':[]};return db['CmContact']['findOne']({'where':{'id':_0x513867[_0xbc81('0x9a')]['id']}})['then'](handleEntityNotFound(_0x302a74,null))[_0xbc81('0x38')](function(_0x9c54e5){if(_0x9c54e5){_0x51d258[_0xbc81('0x42')]=_['keys'](db[_0xbc81('0xd6')][_0xbc81('0xcd')]);_0x51d258[_0xbc81('0x43')]=_[_0xbc81('0x39')](_0x513867[_0xbc81('0x43')]);_0x51d258['filters']=_[_0xbc81('0x45')](_0x51d258['model'],_0x51d258[_0xbc81('0x43')]);_0x842219[_0xbc81('0x46')]=_['intersection'](_0x51d258[_0xbc81('0x42')],qs['fields'](_0x513867[_0xbc81('0x43')][_0xbc81('0xce')]));_0x842219[_0xbc81('0x46')]=_0x842219['attributes']['length']?_0x842219[_0xbc81('0x46')]:_0x51d258[_0xbc81('0x42')];if(!_0x513867['query'][_0xbc81('0x47')](_0xbc81('0x48'))){_0x842219[_0xbc81('0x23')]=qs[_0xbc81('0x23')](_0x513867[_0xbc81('0x43')][_0xbc81('0x23')]);_0x842219[_0xbc81('0x21')]=qs[_0xbc81('0x21')](_0x513867[_0xbc81('0x43')]['offset']);}_0x842219[_0xbc81('0x49')]=qs['sort'](_0x513867[_0xbc81('0x43')][_0xbc81('0x4a')]);_0x842219[_0xbc81('0x4b')]=qs[_0xbc81('0x44')](_[_0xbc81('0x4c')](_0x513867[_0xbc81('0x43')],_0x51d258[_0xbc81('0x44')]));_0x842219[_0xbc81('0x4b')][_0xbc81('0xd7')]=_0x9c54e5['id'];if(_0x513867[_0xbc81('0x43')]['filter']){_0x842219['where']=_[_0xbc81('0x30')](_0x842219[_0xbc81('0x4b')],{'$or':_[_0xbc81('0x61')](_0x842219[_0xbc81('0x46')],function(_0x131eef){var _0x495a81={};_0x495a81[_0x131eef]={'$like':'%'+_0x513867[_0xbc81('0x43')][_0xbc81('0x6d')]+'%'};return _0x495a81;})});}_0x842219=_[_0xbc81('0x30')]({},_0x842219,_0x513867[_0xbc81('0xcf')]);return db['CmHopperHistory'][_0xbc81('0x24')]({'where':_0x842219[_0xbc81('0x4b')]})[_0xbc81('0x38')](function(_0xe66bfd){_0x168b03[_0xbc81('0x24')]=_0xe66bfd;if(_0x513867['query'][_0xbc81('0xd4')]){_0x842219[_0xbc81('0xd8')]=[{'all':!![]}];}return db[_0xbc81('0xd6')][_0xbc81('0x9f')](_0x842219);})[_0xbc81('0x38')](function(_0x2dcac4){_0x168b03[_0xbc81('0x98')]=_0x2dcac4;return _0x168b03;});}})[_0xbc81('0x38')](respondWithFilteredResult(_0x302a74,_0x842219))[_0xbc81('0x99')](handleError(_0x302a74,null));};exports[_0xbc81('0xd9')]=function(_0x1bac6,_0x25c73d,_0x417af1){var _0x1ba474={'raw':!![],'where':{}};var _0xcb4f77={};var _0x504d73={'count':0x0,'rows':[]};return db[_0xbc81('0x37')]['findOne']({'where':{'id':_0x1bac6[_0xbc81('0x9a')]['id']}})[_0xbc81('0x38')](handleEntityNotFound(_0x25c73d,null))[_0xbc81('0x38')](function(_0x426c21){if(_0x426c21){_0xcb4f77['model']=_[_0xbc81('0x39')](db[_0xbc81('0xb3')][_0xbc81('0xcd')]);_0xcb4f77['query']=_['keys'](_0x1bac6[_0xbc81('0x43')]);_0xcb4f77[_0xbc81('0x44')]=_[_0xbc81('0x45')](_0xcb4f77[_0xbc81('0x42')],_0xcb4f77[_0xbc81('0x43')]);_0x1ba474[_0xbc81('0x46')]=_[_0xbc81('0x45')](_0xcb4f77[_0xbc81('0x42')],qs[_0xbc81('0xce')](_0x1bac6[_0xbc81('0x43')][_0xbc81('0xce')]));_0x1ba474[_0xbc81('0x46')]=_0x1ba474[_0xbc81('0x46')][_0xbc81('0x3a')]?_0x1ba474['attributes']:_0xcb4f77[_0xbc81('0x42')];if(!_0x1bac6[_0xbc81('0x43')][_0xbc81('0x47')](_0xbc81('0x48'))){_0x1ba474[_0xbc81('0x23')]=qs[_0xbc81('0x23')](_0x1bac6[_0xbc81('0x43')][_0xbc81('0x23')]);_0x1ba474[_0xbc81('0x21')]=qs[_0xbc81('0x21')](_0x1bac6['query']['offset']);}_0x1ba474[_0xbc81('0x49')]=qs[_0xbc81('0x4a')](_0x1bac6[_0xbc81('0x43')][_0xbc81('0x4a')]);_0x1ba474[_0xbc81('0x4b')]=qs[_0xbc81('0x44')](_['pick'](_0x1bac6[_0xbc81('0x43')],_0xcb4f77['filters']));_0x1ba474[_0xbc81('0x4b')]['ContactId']=_0x426c21['id'];if(_0x1bac6['query'][_0xbc81('0x6d')]){_0x1ba474['where']=_['merge'](_0x1ba474[_0xbc81('0x4b')],{'$or':_['map'](_0x1ba474[_0xbc81('0x46')],function(_0x4e6a5c){var _0xd528d3={};_0xd528d3[_0x4e6a5c]={'$like':'%'+_0x1bac6['query'][_0xbc81('0x6d')]+'%'};return _0xd528d3;})});}_0x1ba474=_['merge']({},_0x1ba474,_0x1bac6['options']);return db[_0xbc81('0xb3')][_0xbc81('0x24')]({'where':_0x1ba474['where']})[_0xbc81('0x38')](function(_0x1fd786){_0x504d73[_0xbc81('0x24')]=_0x1fd786;if(_0x1bac6[_0xbc81('0x43')][_0xbc81('0xd4')]){_0x1ba474[_0xbc81('0xd8')]=[{'all':!![]}];}return db[_0xbc81('0xb3')]['findAll'](_0x1ba474);})['then'](function(_0x57b728){_0x504d73[_0xbc81('0x98')]=_0x57b728;return _0x504d73;});}})[_0xbc81('0x38')](respondWithFilteredResult(_0x25c73d,_0x1ba474))[_0xbc81('0x99')](handleError(_0x25c73d,null));};exports[_0xbc81('0xda')]=function(_0x3e1312,_0x9be48b,_0x34ac3f){var _0x24df45={'raw':!![],'where':{}};var _0x3cdb39={};var _0x29206b={'count':0x0,'rows':[]};return db[_0xbc81('0x37')][_0xbc81('0x3f')]({'where':{'id':_0x3e1312[_0xbc81('0x9a')]['id']}})['then'](handleEntityNotFound(_0x9be48b,null))[_0xbc81('0x38')](function(_0x2f54e7){if(_0x2f54e7){_0x3cdb39['model']=_[_0xbc81('0x39')](db[_0xbc81('0xba')][_0xbc81('0xcd')]);_0x3cdb39[_0xbc81('0x43')]=_['keys'](_0x3e1312[_0xbc81('0x43')]);_0x3cdb39[_0xbc81('0x44')]=_[_0xbc81('0x45')](_0x3cdb39[_0xbc81('0x42')],_0x3cdb39[_0xbc81('0x43')]);_0x24df45[_0xbc81('0x46')]=_['intersection'](_0x3cdb39[_0xbc81('0x42')],qs[_0xbc81('0xce')](_0x3e1312[_0xbc81('0x43')][_0xbc81('0xce')]));_0x24df45[_0xbc81('0x46')]=_0x24df45[_0xbc81('0x46')][_0xbc81('0x3a')]?_0x24df45[_0xbc81('0x46')]:_0x3cdb39[_0xbc81('0x42')];if(!_0x3e1312['query'][_0xbc81('0x47')](_0xbc81('0x48'))){_0x24df45['limit']=qs[_0xbc81('0x23')](_0x3e1312[_0xbc81('0x43')][_0xbc81('0x23')]);_0x24df45['offset']=qs[_0xbc81('0x21')](_0x3e1312[_0xbc81('0x43')]['offset']);}_0x24df45[_0xbc81('0x49')]=qs['sort'](_0x3e1312[_0xbc81('0x43')][_0xbc81('0x4a')]);_0x24df45[_0xbc81('0x4b')]=qs[_0xbc81('0x44')](_[_0xbc81('0x4c')](_0x3e1312[_0xbc81('0x43')],_0x3cdb39[_0xbc81('0x44')]));_0x24df45[_0xbc81('0x4b')][_0xbc81('0xd7')]=_0x2f54e7['id'];if(_0x3e1312['query'][_0xbc81('0x6d')]){_0x24df45[_0xbc81('0x4b')]=_[_0xbc81('0x30')](_0x24df45[_0xbc81('0x4b')],{'$or':_[_0xbc81('0x61')](_0x24df45['attributes'],function(_0x4581a1){var _0x332941={};_0x332941[_0x4581a1]={'$like':'%'+_0x3e1312[_0xbc81('0x43')][_0xbc81('0x6d')]+'%'};return _0x332941;})});}_0x24df45=_['merge']({},_0x24df45,_0x3e1312[_0xbc81('0xcf')]);return db[_0xbc81('0xba')][_0xbc81('0x24')]({'where':_0x24df45[_0xbc81('0x4b')]})[_0xbc81('0x38')](function(_0x17d8e4){_0x29206b[_0xbc81('0x24')]=_0x17d8e4;if(_0x3e1312[_0xbc81('0x43')][_0xbc81('0xd4')]){_0x24df45['include']=[{'all':!![]}];}return db[_0xbc81('0xba')][_0xbc81('0x9f')](_0x24df45);})[_0xbc81('0x38')](function(_0x35d2b7){_0x29206b[_0xbc81('0x98')]=_0x35d2b7;return _0x29206b;});}})[_0xbc81('0x38')](respondWithFilteredResult(_0x9be48b,_0x24df45))[_0xbc81('0x99')](handleError(_0x9be48b,null));};exports[_0xbc81('0xdb')]=function(_0x2e2157,_0x11ee12,_0x1d02b8){try{if(!_0x2e2157[_0xbc81('0x31')][_0xbc81('0x71')]){throw new Error(_0xbc81('0xdc'));}if(!_0x2e2157[_0xbc81('0x31')][_0xbc81('0xdd')]){throw new Error(_0xbc81('0xde'));}if(!_0x2e2157[_0xbc81('0x31')][_0xbc81('0xdf')]){throw new Error('No\x20association\x20values\x20specified!');}if(!_0x2e2157[_0xbc81('0x31')][_0xbc81('0xe0')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x2694a8=_0x2e2157['body']['binding_keys'][_0xbc81('0x60')](',');var _0x130d9f=_0x2e2157['body']['binding_values']['split'](',');if(!_0x2694a8['length']||!_0x130d9f[_0xbc81('0x3a')]||_0x2694a8['length']!==_0x130d9f[_0xbc81('0x3a')]){throw new Error(_0xbc81('0xe1'));}_0x2e2157[_0xbc81('0x31')][_0xbc81('0xce')]=_['zipObject'](_0x2694a8,_0x130d9f);if(!_0x2e2157[_0xbc81('0x31')]['fields'][_0xbc81('0xcc')]){throw new Error(_0xbc81('0xe2'));}if(!_0x2e2157[_0xbc81('0x31')][_0xbc81('0xce')][_0xbc81('0xe3')]){throw new Error(_0xbc81('0xe4'));}var _0xb23b97=path[_0xbc81('0xa3')](config[_0xbc81('0xe5')],_0xbc81('0xe6'),_0x2e2157['file'][_0xbc81('0xe7')]);fs['chmodSync'](_0xb23b97,parseInt(_0xbc81('0xe8'),0x8));var _0x334e1c=require(_0xbc81('0xe9'))[_0xbc81('0xea')](path['join'](__dirname,_0xbc81('0xeb')),[_0xb23b97,_0x2e2157['body']['binding_keys'],_0x2e2157['body']['binding_values'],_0x2e2157['body']['ListId'],_0x2e2157[_0xbc81('0x31')][_0xbc81('0xec')],_0x2e2157[_0xbc81('0x31')][_0xbc81('0xbf')],_0x2e2157[_0xbc81('0x31')][_0xbc81('0xe0')]]);return _0x11ee12['status'](0xc8)[_0xbc81('0x20')]({'message':_0xbc81('0xed'),'pid':_0x334e1c[_0xbc81('0xee')]});}catch(_0x4695f6){return _0x11ee12['status'](0x1f4)[_0xbc81('0x2f')](_0x4695f6);}};exports[_0xbc81('0xef')]=function(_0x3bf998,_0x48168e,_0x1ab10d){var _0x27b084=fs[_0xbc81('0xf0')](_0x3bf998['file']['path']);Papa[_0xbc81('0xf1')](_0x27b084,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x451cb0){return _0x48168e[_0xbc81('0x1e')](0xc8)[_0xbc81('0x20')]({'file':_0x3bf998[_0xbc81('0xf2')],'fields':_0x451cb0[_0xbc81('0xf3')][_0xbc81('0xce')]});}});};exports['import']=function(_0x4d9d4d,_0x17d740,_0x2adbbc){return db[_0xbc81('0x65')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0xbc81('0x33')}})[_0xbc81('0x38')](function(_0x4366d3){var _0x8df100=![];if(!_0x4d9d4d[_0xbc81('0x31')][_0xbc81('0x71')]){throw new Error(_0xbc81('0xdc'));}if(!_0x4d9d4d['body'][_0xbc81('0xf4')][_0xbc81('0xcc')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x4d9d4d[_0xbc81('0x31')][_0xbc81('0xf4')][_0xbc81('0xe3')]){throw new Error(_0xbc81('0xe4'));}if(!_0x4d9d4d[_0xbc81('0x31')]['socket_timestamp']){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x19d2ee=require(_0xbc81('0xe9'))[_0xbc81('0xea')](path[_0xbc81('0xa3')](__dirname,_0xbc81('0xf5')),[_0x4d9d4d['params']['id'],JSON[_0xbc81('0xf6')](_0x4d9d4d[_0xbc81('0x31')]),JSON[_0xbc81('0xf6')](_0x4366d3)]);_0x19d2ee['on']('message',function(_0x249085){_0x8df100=!![];return _0x17d740[_0xbc81('0x1e')](0xc8)[_0xbc81('0x20')]({'message':_0xbc81('0xf7'),'pid':_0x19d2ee[_0xbc81('0xee')]});});_0x19d2ee['on'](_0xbc81('0xf8'),function(_0x2ebc4d){if(_0x2ebc4d&&!_0x8df100){return _0x17d740[_0xbc81('0x1e')](0x1f4)[_0xbc81('0x20')]({'message':_0xbc81('0xf9'),'pid':_0x19d2ee[_0xbc81('0xee')]});}});})[_0xbc81('0x99')](handleError(_0x17d740,null));};exports[_0xbc81('0xfa')]=function(_0x16f5b4,_0x399994){var _0x27be28=[_0xbc81('0xfb'),_0xbc81('0xfc'),_0xbc81('0xfd'),_0xbc81('0xfe'),'fax',_0xbc81('0xff'),'voice'];var _0x34b96f={'offset':0x0,'order':qs[_0xbc81('0x4a')](_0xbc81('0x100'))},_0x5a2152={'count':0x0,'rows':[]};Promise[_0xbc81('0x101')]()[_0xbc81('0x38')](function(){if(_0x16f5b4[_0xbc81('0x43')][_0xbc81('0x102')]){if(!_[_0xbc81('0x103')](_0x27be28,_0x16f5b4[_0xbc81('0x43')][_0xbc81('0x102')][_0xbc81('0x104')]())){throw new Error(_0xbc81('0x105'));}_0x27be28=[_0x16f5b4['query'][_0xbc81('0x102')][_0xbc81('0x104')]()];}if(_0x16f5b4[_0xbc81('0x43')][_0xbc81('0x106')]){try{var _0x259cfa=JSON['parse'](_0x16f5b4[_0xbc81('0x43')][_0xbc81('0x106')]);if(!moment(_0x259cfa['from'])[_0xbc81('0x107')]()){throw new Error(_0xbc81('0x108'));}if(!moment(_0x259cfa['to'])[_0xbc81('0x107')]()){throw new Error(_0xbc81('0x109'));}}catch(_0x4f4bff){throw new Error(_0xbc81('0x10a'));}}if(!_0x16f5b4[_0xbc81('0x43')]['hasOwnProperty'](_0xbc81('0x48'))){_0x34b96f[_0xbc81('0x23')]=qs['limit'](_0x16f5b4[_0xbc81('0x43')][_0xbc81('0x23')]||0xa);_0x34b96f[_0xbc81('0x21')]=qs['offset'](_0x16f5b4[_0xbc81('0x43')][_0xbc81('0x21')]);}var _0x12eeb3=_0x27be28['map'](function(_0x93b9f){if(_0x93b9f==='voice'){var _0x1da9a0={'attributes':['id',_0xbc81('0x10b'),_0xbc81('0x41'),_0xbc81('0x10c'),_0xbc81('0x10d'),_0xbc81('0x10e'),_0xbc81('0x10f'),_0xbc81('0x110'),'duration',_0xbc81('0x111'),_0xbc81('0x112'),_0xbc81('0x113'),_0xbc81('0x114'),_0xbc81('0x115'),_0xbc81('0x116')],'where':{'ContactId':_0x16f5b4[_0xbc81('0x9a')]['id']},'include':[{'model':db[_0xbc81('0x65')],'as':_0xbc81('0x65'),'attributes':['id',_0xbc81('0x2e'),_0xbc81('0x117'),_0xbc81('0x118')]}],'order':[[_0xbc81('0x112'),'DESC']]};if(_0x16f5b4[_0xbc81('0x43')][_0xbc81('0x106')]){_0x1da9a0[_0xbc81('0x4b')]['createdAt']={'$gte':_0x259cfa[_0xbc81('0x51')],'$lte':_0x259cfa['to']};}return db[_0xbc81('0x119')][_0xbc81('0x11a')](_0x1da9a0)[_0xbc81('0x38')](function(_0x5bc6dd){_0x5a2152[_0xbc81('0x24')]+=_0x5bc6dd[_0xbc81('0x24')];return _[_0xbc81('0x61')](_0x5bc6dd[_0xbc81('0x98')],function(_0x6d6d0c){var _0x4840e0=_0x6d6d0c['get']({'plain':!![]});_0x4840e0[_0xbc81('0x102')]=_0x93b9f;if(_0x4840e0[_0xbc81('0x65')]){_0x4840e0[_0xbc81('0x65')]={'id':_0x4840e0[_0xbc81('0x65')]['id'],'name':_0x4840e0['User']['name'],'fullname':_0x4840e0[_0xbc81('0x65')][_0xbc81('0x117')],'alias':_0x4840e0[_0xbc81('0x65')]['alias']};}return _0x4840e0;});});}else{var _0x2207ed=_[_0xbc81('0x11b')](_0x93b9f)+(_0x93b9f===_0xbc81('0xfc')?'Website':_0xbc81('0x11c'));var _0x142288={'attributes':['id',_0xbc81('0x11d'),_0xbc81('0x11e'),_0xbc81('0x112'),_0xbc81('0x111'),_0xbc81('0x11f'),_0xbc81('0x120'),_0xbc81('0x121'),_0xbc81('0x116'),_0x2207ed+'Id'],'where':{'ContactId':_0x16f5b4[_0xbc81('0x9a')]['id']},'include':[{'model':db[_0x2207ed],'as':_0xbc81('0x11c'),'attributes':['id',_0xbc81('0x2e'),_0xbc81('0x122')]},{'model':db['User'],'as':_0xbc81('0x123'),'attributes':['id','name','fullname']},{'model':db[_0xbc81('0x5e')],'as':_0xbc81('0x124'),'attributes':['id','name','color'],'through':{'attributes':[]}}],'order':[[_0xbc81('0x112'),_0xbc81('0x83')]]};if(_0x16f5b4[_0xbc81('0x43')][_0xbc81('0x106')]){_0x142288[_0xbc81('0x4b')][_0xbc81('0x112')]={'$gte':_0x259cfa[_0xbc81('0x51')],'$lte':_0x259cfa['to']};}switch(_0x93b9f){case _0xbc81('0xfc'):_0x142288[_0xbc81('0x46')][_0xbc81('0x3d')]('browserName',_0xbc81('0x125'),_0xbc81('0x126'),_0xbc81('0x127'),_0xbc81('0x128'),_0xbc81('0x129'),_0xbc81('0x12a'),_0xbc81('0x12b'),_0xbc81('0x12c'));break;case'mail':_0x142288[_0xbc81('0x46')][_0xbc81('0x3d')](_0xbc81('0x12d'),'substatus');break;case _0xbc81('0xfe'):_0x142288[_0xbc81('0x46')][_0xbc81('0x3d')]('externalUrl',_0xbc81('0x12e'));break;}return db[_[_0xbc81('0x11b')](_0x93b9f)+_0xbc81('0x12f')][_0xbc81('0x11a')](_0x142288)[_0xbc81('0x38')](function(_0x3fbed8){_0x5a2152[_0xbc81('0x24')]+=_0x3fbed8[_0xbc81('0x24')];return _['map'](_0x3fbed8[_0xbc81('0x98')],function(_0x2b69f7){var _0x205c44=_0x2b69f7[_0xbc81('0xa1')]({'plain':!![]});_0x205c44[_0xbc81('0x102')]=_0x93b9f;if(_0x205c44[_0xbc81('0x123')]){_0x205c44[_0xbc81('0x123')]={'id':_0x205c44[_0xbc81('0x123')]['id'],'name':_0x205c44['Owner'][_0xbc81('0x2e')],'fullname':_0x205c44[_0xbc81('0x123')][_0xbc81('0x117')]};}return _0x205c44;});});}});return Promise[_0xbc81('0x40')](_0x12eeb3);})[_0xbc81('0x38')](function(_0x19962a){return _(_0x19962a)[_0xbc81('0x130')]()['sortBy'](_0xbc81('0x112'))['reverse']()[_0xbc81('0x5f')]();})[_0xbc81('0x38')](function(_0x5dc567){_0x5a2152[_0xbc81('0x98')]=_0x34b96f[_0xbc81('0x23')]?_0x5dc567[_0xbc81('0x131')](_0x34b96f[_0xbc81('0x21')],_0x34b96f['offset']+_0x34b96f[_0xbc81('0x23')]):_0x5dc567;return _0x5a2152;})[_0xbc81('0x38')](respondWithFilteredResult(_0x399994,_0x34b96f))[_0xbc81('0x99')](handleError(_0x399994,null));};
\ No newline at end of file
+var _0x7969=['ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','OpenchannelInteraction','OpenchannelMessage','CmHopperHistory','ReportAgentPreview','VoiceCallReport','MailQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappMessage','WhatsappQueueReport','bulkCreate','each','duplicates','$or','findOrCreate','show','Tag','$and','CmCustomField','omit','format','find','pickBy','cf_%d','table','setFields','toParam','phone','getTags','options','setTags','ids','getHoppers','CmHopper','ContactId','merge','getHopperHistories','rawAttributes','includeAll','include','CmHopperFinal','getJscriptySessions','uploadCsv','binding_keys','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','Incorrect\x20binding\x20parameters\x20passed!','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','server/files/tmp','filename','chmodSync','child_process','fork','CompanyId','File\x20uploaded\x20correctly!','pid','createReadStream','file','parse','import','No\x20ListId\x20specified','binding','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','exit','getJourney','chat','sms','openchannel','fax','whatsapp','voice','-createdAt','includes','channel','toLowerCase','Invalid\x20channel','range','Invalid\x20date\x20for\x20range\x20from\x20filter','Invalid\x20date\x20for\x20range\x20to\x20filter','Invalid\x20createdAt\x20filter','uniqueid','source','destination','callerid','starttime','endtime','note','createdAt','userDisposition','userThirdDisposition','UserId','fullname','startCase','Account','closed','disposition','secondDisposition','thirdDisposition','key','browserName','customerIp','customerPort','deviceModel','osName','ratingMessage','ratingType','ratingValue','referer','mail','subject','substatus','externalUrl','Owner','flatten','slice','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','sox','to-csv','ejs','lodash','crypto','jsforce','desk.js','querystring','papaparse','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/license/util','../../mysqldb','redis','defaults','localhost','socket.io-emitter','register','end','json','offset','limit','undefined','count','status','set','Content-Range','apply','reject','update','destroy','then','sendStatus','error','stack','name','send','render','contact','agent','interaction','account','index','describe','keys','length','startsWith','cf_','findOne','trimStart','all','fieldType','type','model','query','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','where','filters','pick','select','field','color','tools_tags','cm_contacts','left_join','uc.CmContactId\x20=\x20c.id','cm_contact_has_tags','c.deletedAt\x20IS\x20NULL','expr','search','parseSearch','sqlOperator','conditions','split','map','forEach','union','and','uc.UserId\x20=\x20?','value','dateOfBirth','castTo','buildExpression','text','start','filter','isNil','Contact','push','isEmpty','ListId','c.ListId\x20IN\x20?','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','tag','isArray','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','replace','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','isNumeric','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','group','c.id','Sequelize','QueryTypes','SELECT','clone','DESC','having','t.id\x20IN\x20?','resolve','user','role','some','User','getLists','c.ListId\x20IS\x20NULL','toString','sequelize','keyBy','CmContact','c.firstName','c.lastName','c.phone','c.fax','c.email','c.ListId','c.createdAt','c.CompanyId','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','Tags','rows','catch','params','columnName','findAll','alias','custom','values','body','from','get','mergeWith','tags','join','info','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','create'];(function(_0x507056,_0xe16b72){var _0x4eaecc=function(_0x440b91){while(--_0x440b91){_0x507056['push'](_0x507056['shift']());}};_0x4eaecc(++_0xe16b72);}(_0x7969,0x83));var _0x9796=function(_0x247625,_0x503bc1){_0x247625=_0x247625-0x0;var _0x4bae98=_0x7969[_0x247625];return _0x4bae98;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x9796('0x0'));var zipdir=require(_0x9796('0x1'));var jsonpatch=require(_0x9796('0x2'));var rp=require(_0x9796('0x3'));var moment=require(_0x9796('0x4'));var BPromise=require(_0x9796('0x5'));var Mustache=require(_0x9796('0x6'));var util=require('util');var path=require(_0x9796('0x7'));var sox=require(_0x9796('0x8'));var csv=require(_0x9796('0x9'));var ejs=require(_0x9796('0xa'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x9796('0xb'));var squel=require('squel');var crypto=require(_0x9796('0xc'));var jsforce=require(_0x9796('0xd'));var deskjs=require(_0x9796('0xe'));var toCsv=require(_0x9796('0x9'));var querystring=require(_0x9796('0xf'));var Papa=require(_0x9796('0x10'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0x9796('0x11'));var as=require(_0x9796('0x12'));var hardwareService=require(_0x9796('0x13'));var logger=require(_0x9796('0x14'))(_0x9796('0x15'));var utils=require(_0x9796('0x16'));var config=require('../../config/environment');var licenseUtil=require(_0x9796('0x17'));var db=require(_0x9796('0x18'))['db'];config[_0x9796('0x19')]=_[_0x9796('0x1a')](config[_0x9796('0x19')],{'host':_0x9796('0x1b'),'port':0x18eb});var socket=require(_0x9796('0x1c'))(new Redis(config[_0x9796('0x19')]));require('./cmContact.socket')[_0x9796('0x1d')](socket);function respondWithStatusCode(_0x3f55b0,_0x35731b){_0x35731b=_0x35731b||0xcc;return function(_0xcb38e5){if(_0xcb38e5){return _0x3f55b0['sendStatus'](_0x35731b);}return _0x3f55b0['status'](_0x35731b)[_0x9796('0x1e')]();};}function respondWithResult(_0x5be9dd,_0x1990a2){_0x1990a2=_0x1990a2||0xc8;return function(_0x2e5de5){if(_0x2e5de5){return _0x5be9dd['status'](_0x1990a2)[_0x9796('0x1f')](_0x2e5de5);}};}function respondWithFilteredResult(_0x2c429c,_0x469432){return function(_0x4ab810){if(_0x4ab810){var _0x2d894b=typeof _0x469432[_0x9796('0x20')]==='undefined'&&typeof _0x469432[_0x9796('0x21')]===_0x9796('0x22');var _0x3689f8=_0x4ab810[_0x9796('0x23')];var _0x148005=_0x2d894b?0x0:_0x469432[_0x9796('0x20')];var _0x49c367=_0x2d894b?_0x4ab810[_0x9796('0x23')]:_0x469432[_0x9796('0x20')]+_0x469432['limit'];var _0x59f67e;if(_0x49c367>=_0x3689f8){_0x49c367=_0x3689f8;_0x59f67e=0xc8;}else{_0x59f67e=0xce;}_0x2c429c[_0x9796('0x24')](_0x59f67e);return _0x2c429c[_0x9796('0x25')](_0x9796('0x26'),_0x148005+'-'+_0x49c367+'/'+_0x3689f8)[_0x9796('0x1f')](_0x4ab810);}return null;};}function patchUpdates(_0x318f58){return function(_0x476bee){try{jsonpatch[_0x9796('0x27')](_0x476bee,_0x318f58,!![]);}catch(_0x12491c){return BPromise[_0x9796('0x28')](_0x12491c);}return _0x476bee['save']();};}function saveUpdates(_0x2f0718,_0x2d11d0){return function(_0x2872e6){if(_0x2872e6){return _0x2872e6[_0x9796('0x29')](_0x2f0718)['then'](function(_0x27721b){return _0x27721b;});}return null;};}function removeEntity(_0x40cc68,_0x23105c){return function(_0x131db1){if(_0x131db1){return _0x131db1[_0x9796('0x2a')]()[_0x9796('0x2b')](function(){_0x40cc68[_0x9796('0x24')](0xcc)['end']();});}};}function handleEntityNotFound(_0x1abd0d,_0x2f2c06){return function(_0x5b6bd2){if(!_0x5b6bd2){_0x1abd0d[_0x9796('0x2c')](0x194);}return _0x5b6bd2;};}function handleError(_0x9a8185,_0x22052c){_0x22052c=_0x22052c||0x1f4;return function(_0x32e198){logger[_0x9796('0x2d')](_0x32e198[_0x9796('0x2e')]);if(_0x32e198[_0x9796('0x2f')]){delete _0x32e198[_0x9796('0x2f')];}_0x9a8185[_0x9796('0x24')](_0x22052c)[_0x9796('0x30')](_0x32e198);};}function getMustacheRender(_0x5da9f8,_0x13b55e){return Mustache[_0x9796('0x31')](_0x5da9f8,_['merge'](_0x13b55e['body'],{'contact':_0x13b55e[_0x9796('0x32')],'message':_0x13b55e['message'],'agent':_0x13b55e[_0x9796('0x33')],'interaction':_0x13b55e[_0x9796('0x34')],'account':_0x13b55e[_0x9796('0x35')]}))||'';}exports[_0x9796('0x36')]=function(_0x129307,_0x595929){var _0x56bce4={},_0x33fa6b={},_0x5d84ee={'count':0x0,'rows':[]};return db['CmContact'][_0x9796('0x37')]()[_0x9796('0x2b')](function(_0x3cc153){var _0x1a7bb5=[];for(var _0xb6958d=0x0;_0xb6958d<Object[_0x9796('0x38')](_0x3cc153)[_0x9796('0x39')];_0xb6958d++){var _0x41495d=Object[_0x9796('0x38')](_0x3cc153)[_0xb6958d];if(_[_0x9796('0x3a')](_0x41495d,_0x9796('0x3b'))){_0x1a7bb5['push'](db['CmCustomField'][_0x9796('0x3c')]({'where':{'id':_[_0x9796('0x3d')](_0x41495d,_0x9796('0x3b'))},'raw':!![]}));}}return BPromise[_0x9796('0x3e')](_0x1a7bb5)[_0x9796('0x2b')](function(_0x247bfe){for(var _0x3ca29c=0x0;_0x3ca29c<_0x247bfe[_0x9796('0x39')];_0x3ca29c++){if(_0x247bfe[_0x3ca29c]){var _0x38b390=_0x9796('0x3b')+_0x247bfe[_0x3ca29c]['id'];var _0x3466d6=_0x3cc153[_0x38b390];_0x3466d6[_0x9796('0x3f')]=_0x247bfe[_0x3ca29c][_0x9796('0x40')];}}return _0x3cc153;});})[_0x9796('0x2b')](function(_0x58796d){_0x33fa6b[_0x9796('0x41')]=_[_0x9796('0x38')](_0x58796d);_0x33fa6b[_0x9796('0x42')]=_[_0x9796('0x38')](_0x129307[_0x9796('0x42')]);_0x33fa6b['filters']=_[_0x9796('0x43')](_0x33fa6b[_0x9796('0x41')],_0x33fa6b[_0x9796('0x42')]);_0x56bce4[_0x9796('0x44')]=_[_0x9796('0x43')](_0x33fa6b[_0x9796('0x41')],qs[_0x9796('0x45')](_0x129307[_0x9796('0x42')][_0x9796('0x45')]));_0x56bce4[_0x9796('0x44')]=_0x56bce4[_0x9796('0x44')][_0x9796('0x39')]?_0x56bce4[_0x9796('0x44')]:_0x33fa6b[_0x9796('0x41')];if(!_0x129307['query'][_0x9796('0x46')](_0x9796('0x47'))){_0x56bce4['limit']=qs['limit'](_0x129307[_0x9796('0x42')][_0x9796('0x21')]);_0x56bce4[_0x9796('0x20')]=qs['offset'](_0x129307['query'][_0x9796('0x20')]);}_0x56bce4[_0x9796('0x48')]=qs['sort'](_0x129307[_0x9796('0x42')][_0x9796('0x49')]);_0x56bce4[_0x9796('0x4a')]=qs[_0x9796('0x4b')](_[_0x9796('0x4c')](_0x129307[_0x9796('0x42')],_0x33fa6b[_0x9796('0x4b')]),_0x58796d);var _0x2f6a91=[];var _0x21d217=squel[_0x9796('0x4d')]()[_0x9796('0x4e')]('id')[_0x9796('0x4e')]('name')[_0x9796('0x4e')](_0x9796('0x4f'))['from'](_0x9796('0x50'));var _0x15efe3=squel[_0x9796('0x4d')]()['from'](_0x9796('0x51'),'c')[_0x9796('0x52')]('cm_user_has_contacts','uc',_0x9796('0x53'))[_0x9796('0x52')](_0x9796('0x54'),'ct','ct.CmContactId\x20=\x20c.id')[_0x9796('0x52')](_0x9796('0x50'),'t','t.id\x20=\x20ct.TagId')[_0x9796('0x4a')](_0x9796('0x55'));var _0x2d5e64=squel[_0x9796('0x56')]();var _0x54bcce=[];var _0x55e568=squel[_0x9796('0x56')]();var _0x5eddc6;if(_0x129307['query'][_0x9796('0x57')]){_0x5eddc6=as[_0x9796('0x58')](_0x129307[_0x9796('0x42')][_0x9796('0x57')]);var _0x58c852=_0x5eddc6[_0x9796('0x59')];for(var _0x304973=0x0;_0x304973<_0x5eddc6[_0x9796('0x5a')]['length'];_0x304973++){var _0x50e8d9=_0x5eddc6[_0x9796('0x5a')][_0x304973];var _0x5ca074='c';var _0x34539f=_(_0x58796d)['keys']()['find'](function(_0x14bb67){return _0x14bb67===_0x50e8d9[_0x9796('0x4e')];});if(_0x34539f)_0x34539f=_0x58796d[_0x50e8d9[_0x9796('0x4e')]];if(!_0x34539f){if(_0x50e8d9[_0x9796('0x4e')]==='Tag'){var _0x3cd1c5=_0x50e8d9['value'][_0x9796('0x5b')](',')[_0x9796('0x5c')](function(_0x2b104c){return Number(_0x2b104c);});_0x3cd1c5[_0x9796('0x5d')](function(_0x3e3f7f){_0x55e568['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x3e3f7f+',%');});_0x54bcce=_[_0x9796('0x5e')](_0x54bcce,_0x3cd1c5);}else if(_0x50e8d9[_0x9796('0x4e')]==='User'){_0x2d5e64[_0x9796('0x5f')](_0x9796('0x60'),_0x50e8d9[_0x9796('0x61')]);}}else{if(_0x50e8d9[_0x9796('0x4e')]===_0x9796('0x62')||_0x34539f[_0x9796('0x3f')]==='datetime')_0x50e8d9[_0x9796('0x63')]='DATE';var _0x27e6a6=as[_0x9796('0x64')](_0x5ca074,_0x34539f[_0x9796('0x40')],_0x50e8d9);_0x2d5e64[_0x58c852](_0x27e6a6[_0x9796('0x65')],_0x27e6a6[_0x9796('0x61')][_0x9796('0x66')],_0x27e6a6['value']['end']);}}}else{var _0x17c944=_(Object[_0x9796('0x38')](_0x129307['query']))[_0x9796('0x5c')](function(_0x562b14){return _0x58796d[_0x9796('0x46')](_0x562b14)?_0x562b14:undefined;})[_0x9796('0x67')](function(_0x25099b){return!_[_0x9796('0x68')](_0x25099b);})['value']();if(_0x129307[_0x9796('0x42')][_0x9796('0x69')])_0x17c944[_0x9796('0x6a')](_0x9796('0x69'));if(!_[_0x9796('0x6b')](_0x17c944)){_0x17c944['forEach'](function(_0x518984){if(_0x518984===_0x9796('0x6c')){_0x15efe3[_0x9796('0x4a')](_0x9796('0x6d'),[]['concat'](_0x129307[_0x9796('0x42')][_0x518984]));}else if(_0x518984===_0x9796('0x69')){var _0x3215ca='%'+_0x129307[_0x9796('0x42')][_0x518984]+'%';_0x15efe3[_0x9796('0x4a')](_0x9796('0x6e'),_0x3215ca);}else{_0x15efe3[_0x9796('0x4a')]('c.'+_0x518984+_0x9796('0x6f'),_0x129307[_0x9796('0x42')][_0x518984]);}});}if(_0x129307[_0x9796('0x42')][_0x9796('0x70')]){_0x54bcce=_[_0x9796('0x71')](_0x129307[_0x9796('0x42')]['tag'])?_0x129307[_0x9796('0x42')][_0x9796('0x70')]:new Array(_0x129307[_0x9796('0x42')]['tag']);_0x54bcce['forEach'](function(_0x399548){_0x55e568['or'](_0x9796('0x72'),'%,'+_0x399548+',%');});}if(_0x129307[_0x9796('0x42')][_0x9796('0x67')]){var _0x4efd20=_0x129307[_0x9796('0x42')]['filter'][_0x9796('0x73')]('\x5c','\x5c\x5c')[_0x9796('0x73')](/'/g,'\x27\x27');if(_0x4efd20['split']('\x20')[_0x9796('0x39')]>0x1){_0x2d5e64['or'](_0x9796('0x74'),qs['getFullTextValue'](_0x4efd20),null);}else{if(qs[_0x9796('0x75')](_0x4efd20)){_0x2d5e64['or']('c.id\x20LIKE\x20?',_0x4efd20+'%');_0x2d5e64['or'](_0x9796('0x76'),_0x4efd20+'%');_0x2d5e64['or'](_0x9796('0x77'),_0x4efd20+'%');_0x2d5e64['or'](_0x9796('0x78'),_0x4efd20+'%');}else if(qs[_0x9796('0x79')](_0x4efd20)){_0x2d5e64['or'](_0x9796('0x7a'),_0x4efd20+'%');}else{_0x2d5e64['or'](_0x9796('0x7b'),'%'+_0x4efd20+'%');_0x2d5e64['or'](_0x9796('0x7c'),'%'+_0x4efd20+'%');_0x2d5e64['or'](_0x9796('0x7a'),'%'+_0x4efd20+'%');}}}}_0x15efe3[_0x9796('0x4a')](_0x2d5e64);_0x15efe3[_0x9796('0x7d')](_0x9796('0x7e'));var _0x2d0075={'type':db[_0x9796('0x7f')][_0x9796('0x80')][_0x9796('0x81')],'raw':!![]};var _0x48ec58=_0x15efe3[_0x9796('0x82')]()[_0x9796('0x4e')]('c.id');if(_0x56bce4['order']){_0x56bce4[_0x9796('0x48')][_0x9796('0x5d')](function(_0x22aaa1){_0x15efe3[_0x9796('0x48')]('c.'+_0x22aaa1[0x0],_0x22aaa1[0x1]===_0x9796('0x83')?![]:!![]);});}if(!_[_0x9796('0x6b')](_0x54bcce)){_0x15efe3[_0x9796('0x84')](_0x55e568);_0x48ec58[_0x9796('0x4a')](_0x9796('0x85'),_0x54bcce);}BPromise[_0x9796('0x86')]()['then'](function(){if(!_0x5eddc6)return;if(_0x129307[_0x9796('0x87')][_0x9796('0x88')]!==_0x9796('0x33'))return;if(!_[_0x9796('0x89')](_0x5eddc6[_0x9796('0x5a')],[_0x9796('0x4e'),_0x9796('0x8a')])){return _0x129307[_0x9796('0x87')][_0x9796('0x8b')]({'attributes':['id'],'raw':!![]})[_0x9796('0x2b')](function(_0x4b51af){if(_[_0x9796('0x6b')](_0x4b51af)){_0x48ec58[_0x9796('0x4a')](_0x9796('0x8c'));_0x15efe3[_0x9796('0x4a')](_0x9796('0x8c'));}else{_0x48ec58[_0x9796('0x4a')](_0x9796('0x6d'),_[_0x9796('0x5c')](_0x4b51af,'id'));_0x15efe3[_0x9796('0x4a')](_0x9796('0x6d'),_[_0x9796('0x5c')](_0x4b51af,'id'));}});}})[_0x9796('0x2b')](function(){if(_0x129307['user'][_0x9796('0x88')]===_0x9796('0x33')&&!_0x5eddc6&&!_0x129307[_0x9796('0x42')][_0x9796('0x6c')])return[];return db['sequelize']['query'](_0x48ec58[_0x9796('0x8d')](),_0x2d0075);})['then'](function(_0x3f75a8){_0x5d84ee[_0x9796('0x23')]=_0x3f75a8[_0x9796('0x39')];if(_0x5d84ee[_0x9796('0x23')]===0x0)return[];return db[_0x9796('0x8e')]['query'](_0x21d217[_0x9796('0x8d')](),_0x2d0075)['then'](function(_0x2cf818){_0x2f6a91=_[_0x9796('0x8f')](_0x2cf818,'id');_0x2d0075=_['merge'](_0x2d0075,{'model':db[_0x9796('0x90')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x129307[_0x9796('0x42')]['fields']){_0x56bce4[_0x9796('0x44')]['forEach'](function(_0x11a814){_0x15efe3['field']('c.'+_0x11a814);});}else{_0x15efe3[_0x9796('0x4e')](_0x9796('0x7e'));_0x15efe3[_0x9796('0x4e')](_0x9796('0x91'));_0x15efe3['field'](_0x9796('0x92'));_0x15efe3[_0x9796('0x4e')](_0x9796('0x93'));_0x15efe3[_0x9796('0x4e')]('c.mobile');_0x15efe3[_0x9796('0x4e')](_0x9796('0x94'));_0x15efe3[_0x9796('0x4e')](_0x9796('0x95'));_0x15efe3['field'](_0x9796('0x96'));_0x15efe3[_0x9796('0x4e')](_0x9796('0x97'));_0x15efe3['field']('c.deletedAt');_0x15efe3[_0x9796('0x4e')](_0x9796('0x98'));_0x15efe3[_0x9796('0x4e')](_0x9796('0x99'),'TagIds');}if(_0x56bce4[_0x9796('0x21')])_0x15efe3[_0x9796('0x21')](_0x56bce4[_0x9796('0x21')]);if(_0x56bce4['offset'])_0x15efe3[_0x9796('0x20')](_0x56bce4['offset']);return db[_0x9796('0x8e')][_0x9796('0x42')](_0x15efe3['toString'](),_0x2d0075);});})[_0x9796('0x2b')](function(_0xe548aa){_0xe548aa['forEach'](function(_0x3c75c4){if(_0x3c75c4[_0x9796('0x9a')]){_0x3c75c4[_0x9796('0x9b')]=[];_0x3c75c4[_0x9796('0x9a')][_0x9796('0x5b')](',')[_0x9796('0x5d')](function(_0x2a33ad){_0x3c75c4[_0x9796('0x9b')][_0x9796('0x6a')](_0x2f6a91[_0x2a33ad]);});}delete _0x3c75c4[_0x9796('0x9a')];});_0x5d84ee[_0x9796('0x9c')]=_0xe548aa;return _0x5d84ee;})[_0x9796('0x2b')](respondWithFilteredResult(_0x595929,_0x56bce4));})[_0x9796('0x9d')](handleError(_0x595929,null));};exports[_0x9796('0x2a')]=function(_0x6211dd,_0x1b176b){return db[_0x9796('0x90')]['find']({'where':{'id':_0x6211dd[_0x9796('0x9e')]['id']}})[_0x9796('0x2b')](handleEntityNotFound(_0x1b176b,null))[_0x9796('0x2b')](removeEntity(_0x1b176b,null))[_0x9796('0x9d')](handleError(_0x1b176b,null));};exports[_0x9796('0x37')]=function(_0x332a5f,_0x4bb867){return db['CmContact']['describe']()[_0x9796('0x2b')](function(_0x4e38b4){delete _0x4e38b4['tags'];for(var _0x303fbe=0x0;_0x303fbe<Object[_0x9796('0x38')](_0x4e38b4)[_0x9796('0x39')];_0x303fbe++){var _0x828a73=Object[_0x9796('0x38')](_0x4e38b4)[_0x303fbe];if(!_['startsWith'](_0x828a73,_0x9796('0x3b'))){_0x4e38b4[_0x828a73][_0x9796('0x9f')]=_0x828a73;_0x4e38b4[_0x828a73]['displayName']=_0x828a73;}}return _0x4e38b4;})[_0x9796('0x2b')](function(_0x4c4e34){var _0x272ce1={'where':{'$or':[{'ListId':_0x332a5f[_0x9796('0x42')]['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField'][_0x9796('0xa0')](_0x272ce1)[_0x9796('0x2b')](function(_0x32e8f1){for(var _0x3942e2=0x0;_0x3942e2<_0x32e8f1['length'];_0x3942e2++){var _0xf269d3=_0x9796('0x3b')+_0x32e8f1[_0x3942e2]['id'];_0x4c4e34[_0xf269d3]['columnName']=_0xf269d3;_0x4c4e34[_0xf269d3]['displayName']=_0x32e8f1[_0x3942e2][_0x9796('0xa1')];_0x4c4e34[_0xf269d3][_0x9796('0xa2')]={'type':_0x32e8f1[_0x3942e2][_0x9796('0x40')],'values':_0x32e8f1[_0x3942e2][_0x9796('0xa3')]};}Object['keys'](_0x4c4e34)[_0x9796('0x5d')](function(_0x1618eb){if(!_0x4c4e34[_0x1618eb][_0x9796('0x46')](_0x9796('0x9f'))){delete _0x4c4e34[_0x1618eb];}});return _0x4c4e34;});})[_0x9796('0x2b')](respondWithResult(_0x4bb867,null))[_0x9796('0x9d')](handleError(_0x4bb867,null));};exports['merge']=function(_0x3461f1,_0x5927fd){var _0x3f7822;var _0x3ecdc0;var _0x4b3a88;if(_0x3461f1[_0x9796('0xa4')]['id']){delete _0x3461f1[_0x9796('0xa4')]['id'];}return db['CmContact'][_0x9796('0xa0')]({'where':{'id':[_0x3461f1[_0x9796('0xa4')]['to'],_0x3461f1['body'][_0x9796('0xa5')]]}})['then'](function(_0x58f0f4){if(_0x58f0f4){if(_0x58f0f4['length']!==0x2){return null;}_0x58f0f4[0x0]=_0x58f0f4[0x0][_0x9796('0xa6')]({'plain':!![]});_0x58f0f4[0x1]=_0x58f0f4[0x1][_0x9796('0xa6')]({'plain':!![]});delete _0x58f0f4[0x0]['id'];delete _0x58f0f4[0x1]['id'];return _[_0x9796('0xa7')](_0x58f0f4[0x0],_0x58f0f4[0x1],function(_0x3a46ae,_0x1614c7){if(Array['isArray'](_0x1614c7)&&!_0x1614c7[_0x9796('0x39')]){return _0x3a46ae;}else if(!_0x1614c7){return _0x3a46ae;}});}})['then'](handleEntityNotFound(_0x5927fd,null))['then'](function(_0x5c891f){if(_0x5c891f){if(_0x5c891f[_0x9796('0xa8')]&&_[_0x9796('0x71')](_0x5c891f[_0x9796('0xa8')])){_0x5c891f[_0x9796('0xa8')]=_0x5c891f[_0x9796('0xa8')][_0x9796('0xa9')]();}logger[_0x9796('0xaa')]('[CmContact][merge]\x20to\x20%s\x20from\x20%s',_0x3461f1[_0x9796('0xa4')]['to'],_0x3461f1[_0x9796('0xa4')]['from']);return db['CmHopper']['destroy']({'where':{'ContactId':[_0x3461f1[_0x9796('0xa4')]['to'],_0x3461f1[_0x9796('0xa4')]['from']]}})[_0x9796('0x2b')](function(_0x1077eb){logger['info'](_0x9796('0xab'),_0x1077eb);return db[_0x9796('0xac')][_0x9796('0x2a')]({'where':{'ContactId':[_0x3461f1[_0x9796('0xa4')]['to'],_0x3461f1['body']['from']]}})[_0x9796('0x2b')](function(_0x29a932){logger['info']('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x29a932);return db['CmContact'][_0x9796('0xad')](_0x5c891f);});});}})[_0x9796('0x2b')](function(_0x295d04){if(_0x295d04){_0x3f7822=_0x295d04;_0x3ecdc0={'ContactId':_0x3f7822['id']};_0x4b3a88={'where':{'ContactId':[_0x3461f1[_0x9796('0xa4')]['to'],_0x3461f1[_0x9796('0xa4')][_0x9796('0xa5')]]}};return db[_0x9796('0xae')][_0x9796('0x29')](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db[_0x9796('0xaf')][_0x9796('0x29')](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db[_0x9796('0xb0')][_0x9796('0x29')](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db[_0x9796('0xb1')][_0x9796('0x29')](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db['MailMessage']['update'](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db[_0x9796('0xb1')][_0x9796('0x29')](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db[_0x9796('0xb2')][_0x9796('0x29')](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db[_0x9796('0xb3')][_0x9796('0x29')](_0x3ecdc0,_0x4b3a88);}})['then'](function(){if(_0x3f7822){return db[_0x9796('0xb4')][_0x9796('0x29')](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db[_0x9796('0xb5')]['update'](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db['FaxMessage'][_0x9796('0x29')](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db[_0x9796('0xb6')][_0x9796('0x29')](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db[_0x9796('0xb7')][_0x9796('0x29')](_0x3ecdc0,_0x4b3a88);}})['then'](function(){if(_0x3f7822){return db['CmHopperFinal'][_0x9796('0x29')](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db[_0x9796('0xb8')][_0x9796('0x29')](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db[_0x9796('0xb9')][_0x9796('0x29')](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db[_0x9796('0xba')][_0x9796('0x29')](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db['ChatQueueReport'][_0x9796('0x29')](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db['FaxQueueReport']['update'](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db[_0x9796('0xbb')][_0x9796('0x29')](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db['OpenchannelQueueReport']['update'](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db['SmsQueueReport']['update'](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db[_0x9796('0xbc')][_0x9796('0x29')](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db[_0x9796('0xbd')][_0x9796('0x29')](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db[_0x9796('0xbe')]['update'](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db[_0x9796('0xbf')][_0x9796('0x29')](_0x3ecdc0,_0x4b3a88);}})[_0x9796('0x2b')](function(){if(_0x3f7822){return db[_0x9796('0x90')][_0x9796('0x2a')]({'where':{'id':[_0x3461f1[_0x9796('0xa4')]['to'],_0x3461f1['body']['from']]}});}})[_0x9796('0x2b')](function(){if(_0x3f7822){return _0x3f7822;}})[_0x9796('0x2b')](respondWithResult(_0x5927fd,null))[_0x9796('0x9d')](handleError(_0x5927fd,null));};exports[_0x9796('0xad')]=function(_0x43825c,_0x3ee6a8){return db[_0x9796('0x90')]['describe']()[_0x9796('0x2b')](function(_0xa50687){if(_0x43825c[_0x9796('0xa4')][_0x9796('0xa8')]&&_[_0x9796('0x71')](_0x43825c[_0x9796('0xa4')]['tags'])){if(_0x43825c[_0x9796('0xa4')]['tags'][_0x9796('0x39')]){_0x43825c[_0x9796('0xa4')][_0x9796('0xa8')]=_0x43825c['body']['tags'][_0x9796('0xa9')](';')+';';}else{_0x43825c[_0x9796('0xa4')][_0x9796('0xa8')]=null;}}else{_0x43825c[_0x9796('0xa4')][_0x9796('0xa8')]=null;}return db['CmContact'][_0x9796('0xad')](_0x43825c[_0x9796('0xa4')],{'fields':_[_0x9796('0x38')](_0xa50687),'raw':!![]});})[_0x9796('0x2b')](respondWithResult(_0x3ee6a8,0xc9))[_0x9796('0x9d')](handleError(_0x3ee6a8,null));};exports[_0x9796('0xc0')]=function(_0x11fd8c,_0x2f4111){var _0x2afd3c=[];var _0x1e9a17=0x0;var _0x56fe71=0x0;var _0x163a72=0x0;return db[_0x9796('0x90')][_0x9796('0x37')]()['then'](function(_0x559762){return BPromise[_0x9796('0xc1')](_0x11fd8c['body'],function(_0xd8bf47){var _0x52ebac={'where':{'$or':[]},'defaults':_0xd8bf47,'fields':_[_0x9796('0x38')](_0x559762),'raw':!![]};if(_0xd8bf47['duplicates']){for(var _0xc6b2b=0x0;_0xc6b2b<_0xd8bf47[_0x9796('0xc2')]['length'];_0xc6b2b++){var _0x53257c={};_0x53257c[_0xd8bf47['duplicates'][_0xc6b2b]]=_0xd8bf47[_0xd8bf47['duplicates'][_0xc6b2b]];_0x52ebac[_0x9796('0x4a')][_0x9796('0xc3')][_0x9796('0x6a')](_0x53257c);}_0x52ebac[_0x9796('0x4a')][_0x9796('0x6c')]=_0xd8bf47[_0x9796('0x6c')];}return db[_0x9796('0x90')][_0x9796('0xc4')](_0x52ebac)['spread'](function(_0x5c526d,_0x27b453){if(_0x27b453){_0x1e9a17++;}else{_0x163a72++;}})[_0x9796('0x9d')](function(_0xbabf66){console['error'](_0xbabf66);_0x56fe71++;});});})[_0x9796('0x2b')](function(_0x8bd7ca){if(_0x8bd7ca){return{'success':_0x1e9a17,'failure':_0x56fe71,'duplicates':_0x163a72};}})[_0x9796('0x2b')](respondWithResult(_0x2f4111,0xc9))['catch'](handleError(_0x2f4111,null));};exports[_0x9796('0xc5')]=function(_0x254677,_0x3c0d83,_0x571ee1){var _0xc3ace2;return db['CmContact'][_0x9796('0x37')]()[_0x9796('0x2b')](function(_0x3c8803){return db[_0x9796('0x90')]['find']({'where':{'id':_0x254677[_0x9796('0x9e')]['id']},'include':[{'model':db[_0x9796('0xc6')],'as':'Tags','attributes':['id','name',_0x9796('0x4f')],'required':_0x254677['query']['tag']?!![]:![]}],'attributes':_[_0x9796('0x38')](_0x3c8803)});})[_0x9796('0x2b')](function(_0x4556cb){_0xc3ace2=_0x4556cb[_0x9796('0xa6')]({'plain':!![]});var _0x2949fc={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x4556cb&&_0x4556cb['ListId']){if(_0x4556cb['ListId']){_0x2949fc['where'][_0x9796('0xc7')][_0x9796('0x6a')]({'ListId':{'$ne':_0x4556cb[_0x9796('0x6c')]}});}}return db[_0x9796('0xc8')][_0x9796('0xa0')](_0x2949fc);})[_0x9796('0x2b')](function(_0x3cab37){return _[_0x9796('0xc9')](_0xc3ace2,_['map'](_0x3cab37,function(_0x4049b5){return util[_0x9796('0xca')]('cf_%d',_0x4049b5['id']);}));})[_0x9796('0x2b')](handleEntityNotFound(_0x3c0d83,null))[_0x9796('0x2b')](respondWithResult(_0x3c0d83,null))[_0x9796('0x9d')](handleError(_0x3c0d83,null));};exports[_0x9796('0x29')]=function(_0x4f76e3,_0x46f038){var _0x372a88;if(_0x4f76e3['body']['id']){delete _0x4f76e3[_0x9796('0xa4')]['id'];}return db[_0x9796('0x90')][_0x9796('0xcb')]({'where':{'id':_0x4f76e3[_0x9796('0x9e')]['id']}})['then'](handleEntityNotFound(_0x46f038,null))[_0x9796('0x2b')](saveUpdates(_0x4f76e3['body'],null))[_0x9796('0x2b')](function(_0x54b0c6){_0x372a88=_0x54b0c6;var _0x4201e5={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x54b0c6&&_0x54b0c6[_0x9796('0x6c')]){if(_0x54b0c6[_0x9796('0x6c')]){_0x4201e5['where']['$and'][_0x9796('0x6a')]({'ListId':{'$ne':_0x54b0c6[_0x9796('0x6c')]}});}}return db['CmCustomField'][_0x9796('0xa0')](_0x4201e5);})[_0x9796('0x2b')](function(_0x4989e5){if(_0x4989e5){return _['omit'](_[_0x9796('0xcc')](_0x4f76e3['body'],function(_0x339942,_0x4e6b6a){return _[_0x9796('0x3a')](_0x4e6b6a,_0x9796('0x3b'));}),_[_0x9796('0x5c')](_0x4989e5,function(_0x30f269){return util[_0x9796('0xca')](_0x9796('0xcd'),_0x30f269['id']);}));}})[_0x9796('0x2b')](function(_0x367d91){if(_0x367d91&&!_[_0x9796('0x6b')](_0x367d91)){var _0x1e4e76=squel[_0x9796('0x29')]()[_0x9796('0xce')](_0x9796('0x51'))[_0x9796('0xcf')](_0x367d91)['where']('id\x20=\x20?',_0x4f76e3['params']['id'])[_0x9796('0xd0')]();return db['sequelize'][_0x9796('0x42')](_0x1e4e76[_0x9796('0x65')],{'replacements':_0x1e4e76[_0x9796('0xa3')]});}})[_0x9796('0x2b')](function(){if(_0x4f76e3[_0x9796('0xa4')][_0x9796('0xd1')]&&_0x372a88){return db['CmHopper'][_0x9796('0x29')]({'phone':_0x4f76e3[_0x9796('0xa4')][_0x9796('0xd1')]},{'where':{'ContactId':_0x372a88['id']}});}})['then'](function(){return _0x372a88;})[_0x9796('0x2b')](respondWithResult(_0x46f038,null))['catch'](handleError(_0x46f038,null));};exports[_0x9796('0xd2')]=function(_0x330bb5,_0x19c98,_0x3b7198){var _0x540ec6={};var _0x11f56e={};var _0x379c47;var _0x1d5099;return db['CmContact'][_0x9796('0x3c')]({'where':{'id':_0x330bb5[_0x9796('0x9e')]['id']}})[_0x9796('0x2b')](handleEntityNotFound(_0x19c98,null))[_0x9796('0x2b')](function(_0x274ccf){if(_0x274ccf){_0x379c47=_0x274ccf;_0x11f56e[_0x9796('0x41')]=_[_0x9796('0x38')](db[_0x9796('0xc6')]['rawAttributes']);_0x11f56e[_0x9796('0x42')]=_[_0x9796('0x38')](_0x330bb5[_0x9796('0x42')]);_0x11f56e[_0x9796('0x4b')]=_[_0x9796('0x43')](_0x11f56e[_0x9796('0x41')],_0x11f56e[_0x9796('0x42')]);_0x540ec6[_0x9796('0x44')]=_['intersection'](_0x11f56e['model'],qs[_0x9796('0x45')](_0x330bb5[_0x9796('0x42')]['fields']));_0x540ec6[_0x9796('0x44')]=_0x540ec6[_0x9796('0x44')]['length']?_0x540ec6[_0x9796('0x44')]:_0x11f56e[_0x9796('0x41')];_0x540ec6[_0x9796('0x48')]=qs[_0x9796('0x49')](_0x330bb5['query'][_0x9796('0x49')]);_0x540ec6[_0x9796('0x4a')]=qs['filters'](_[_0x9796('0x4c')](_0x330bb5[_0x9796('0x42')],_0x11f56e['filters']));if(_0x330bb5[_0x9796('0x42')]['filter']){_0x540ec6[_0x9796('0x4a')]=_['merge'](_0x540ec6[_0x9796('0x4a')],{'$or':_['map'](_0x540ec6[_0x9796('0x44')],function(_0x3388d2){var _0x12082f={};_0x12082f[_0x3388d2]={'$like':'%'+_0x330bb5['query'][_0x9796('0x67')]+'%'};return _0x12082f;})});}_0x540ec6=_['merge']({},_0x540ec6,_0x330bb5[_0x9796('0xd3')]);return _0x379c47['getTags'](_0x540ec6);}})[_0x9796('0x2b')](function(_0x55cdbe){if(_0x55cdbe){_0x1d5099=_0x55cdbe[_0x9796('0x39')];if(!_0x330bb5[_0x9796('0x42')][_0x9796('0x46')](_0x9796('0x47'))){_0x540ec6[_0x9796('0x21')]=qs['limit'](_0x330bb5['query'][_0x9796('0x21')]);_0x540ec6['offset']=qs[_0x9796('0x20')](_0x330bb5[_0x9796('0x42')][_0x9796('0x20')]);}return _0x379c47[_0x9796('0xd2')](_0x540ec6);}})[_0x9796('0x2b')](function(_0x4c317b){if(_0x4c317b){return _0x4c317b?{'count':_0x1d5099,'rows':_0x4c317b}:null;}})[_0x9796('0x2b')](respondWithResult(_0x19c98,null))[_0x9796('0x9d')](handleError(_0x19c98,null));};exports[_0x9796('0xd4')]=function(_0x334e74,_0x32cdd9,_0x222584){if(_0x334e74[_0x9796('0xa4')]['id']){delete _0x334e74[_0x9796('0xa4')]['id'];}return db[_0x9796('0x90')]['findOne']({'where':{'id':_0x334e74[_0x9796('0x9e')]['id']}})['then'](handleEntityNotFound(_0x32cdd9,null))[_0x9796('0x2b')](function(_0x2f464a){if(_0x2f464a){return _0x2f464a['setTags'](_0x334e74[_0x9796('0xa4')][_0x9796('0xd5')]||[]);}return null;})[_0x9796('0x2b')](respondWithResult(_0x32cdd9,null))[_0x9796('0x9d')](handleError(_0x32cdd9,null));};exports[_0x9796('0xd6')]=function(_0x290372,_0x465acd,_0x2414b6){var _0x4bd9c1={'raw':![],'where':{}};var _0x4cdc63={};var _0x581c53={'count':0x0,'rows':[]};return db['CmContact'][_0x9796('0x3c')]({'where':{'id':_0x290372[_0x9796('0x9e')]['id']}})[_0x9796('0x2b')](handleEntityNotFound(_0x465acd,null))[_0x9796('0x2b')](function(_0x5c132a){if(_0x5c132a){_0x4cdc63[_0x9796('0x41')]=_[_0x9796('0x38')](db[_0x9796('0xd7')]['rawAttributes']);_0x4cdc63[_0x9796('0x42')]=_[_0x9796('0x38')](_0x290372[_0x9796('0x42')]);_0x4cdc63[_0x9796('0x4b')]=_[_0x9796('0x43')](_0x4cdc63['model'],_0x4cdc63[_0x9796('0x42')]);_0x4bd9c1['attributes']=_[_0x9796('0x43')](_0x4cdc63[_0x9796('0x41')],qs['fields'](_0x290372[_0x9796('0x42')][_0x9796('0x45')]));_0x4bd9c1['attributes']=_0x4bd9c1[_0x9796('0x44')][_0x9796('0x39')]?_0x4bd9c1[_0x9796('0x44')]:_0x4cdc63[_0x9796('0x41')];if(!_0x290372[_0x9796('0x42')][_0x9796('0x46')](_0x9796('0x47'))){_0x4bd9c1[_0x9796('0x21')]=qs[_0x9796('0x21')](_0x290372[_0x9796('0x42')]['limit']);_0x4bd9c1[_0x9796('0x20')]=qs[_0x9796('0x20')](_0x290372[_0x9796('0x42')][_0x9796('0x20')]);}_0x4bd9c1[_0x9796('0x48')]=qs['sort'](_0x290372[_0x9796('0x42')][_0x9796('0x49')]);_0x4bd9c1[_0x9796('0x4a')]=qs[_0x9796('0x4b')](_[_0x9796('0x4c')](_0x290372[_0x9796('0x42')],_0x4cdc63[_0x9796('0x4b')]));_0x4bd9c1[_0x9796('0x4a')][_0x9796('0xd8')]=_0x5c132a['id'];if(_0x290372[_0x9796('0x42')][_0x9796('0x67')]){_0x4bd9c1[_0x9796('0x4a')]=_[_0x9796('0xd9')](_0x4bd9c1['where'],{'$or':_[_0x9796('0x5c')](_0x4bd9c1['attributes'],function(_0x3c66a6){var _0x51e620={};_0x51e620[_0x3c66a6]={'$like':'%'+_0x290372[_0x9796('0x42')]['filter']+'%'};return _0x51e620;})});}_0x4bd9c1=_[_0x9796('0xd9')]({},_0x4bd9c1,_0x290372['options']);return db['CmHopper'][_0x9796('0x23')]({'where':_0x4bd9c1['where']})[_0x9796('0x2b')](function(_0x524ff4){_0x581c53[_0x9796('0x23')]=_0x524ff4;if(_0x290372[_0x9796('0x42')]['includeAll']){_0x4bd9c1['include']=[{'all':!![]}];}return db['CmHopper'][_0x9796('0xa0')](_0x4bd9c1);})['then'](function(_0x17ac4f){_0x581c53[_0x9796('0x9c')]=_0x17ac4f;return _0x581c53;});}})[_0x9796('0x2b')](respondWithFilteredResult(_0x465acd,_0x4bd9c1))['catch'](handleError(_0x465acd,null));};exports[_0x9796('0xda')]=function(_0x51d80a,_0x557cda,_0x63bfed){var _0x528bda={'raw':!![],'where':{}};var _0x2c4549={};var _0x56920f={'count':0x0,'rows':[]};return db[_0x9796('0x90')][_0x9796('0x3c')]({'where':{'id':_0x51d80a['params']['id']}})['then'](handleEntityNotFound(_0x557cda,null))[_0x9796('0x2b')](function(_0x489a9b){if(_0x489a9b){_0x2c4549[_0x9796('0x41')]=_[_0x9796('0x38')](db[_0x9796('0xb8')][_0x9796('0xdb')]);_0x2c4549[_0x9796('0x42')]=_[_0x9796('0x38')](_0x51d80a['query']);_0x2c4549[_0x9796('0x4b')]=_['intersection'](_0x2c4549[_0x9796('0x41')],_0x2c4549[_0x9796('0x42')]);_0x528bda[_0x9796('0x44')]=_[_0x9796('0x43')](_0x2c4549['model'],qs['fields'](_0x51d80a[_0x9796('0x42')]['fields']));_0x528bda[_0x9796('0x44')]=_0x528bda[_0x9796('0x44')]['length']?_0x528bda[_0x9796('0x44')]:_0x2c4549[_0x9796('0x41')];if(!_0x51d80a[_0x9796('0x42')][_0x9796('0x46')](_0x9796('0x47'))){_0x528bda[_0x9796('0x21')]=qs[_0x9796('0x21')](_0x51d80a['query'][_0x9796('0x21')]);_0x528bda[_0x9796('0x20')]=qs[_0x9796('0x20')](_0x51d80a[_0x9796('0x42')][_0x9796('0x20')]);}_0x528bda['order']=qs[_0x9796('0x49')](_0x51d80a['query'][_0x9796('0x49')]);_0x528bda['where']=qs[_0x9796('0x4b')](_[_0x9796('0x4c')](_0x51d80a['query'],_0x2c4549['filters']));_0x528bda['where'][_0x9796('0xd8')]=_0x489a9b['id'];if(_0x51d80a[_0x9796('0x42')][_0x9796('0x67')]){_0x528bda[_0x9796('0x4a')]=_[_0x9796('0xd9')](_0x528bda[_0x9796('0x4a')],{'$or':_['map'](_0x528bda['attributes'],function(_0x5de499){var _0x7d76bd={};_0x7d76bd[_0x5de499]={'$like':'%'+_0x51d80a['query'][_0x9796('0x67')]+'%'};return _0x7d76bd;})});}_0x528bda=_[_0x9796('0xd9')]({},_0x528bda,_0x51d80a[_0x9796('0xd3')]);return db[_0x9796('0xb8')][_0x9796('0x23')]({'where':_0x528bda[_0x9796('0x4a')]})['then'](function(_0x2a579a){_0x56920f[_0x9796('0x23')]=_0x2a579a;if(_0x51d80a[_0x9796('0x42')][_0x9796('0xdc')]){_0x528bda[_0x9796('0xdd')]=[{'all':!![]}];}return db[_0x9796('0xb8')][_0x9796('0xa0')](_0x528bda);})[_0x9796('0x2b')](function(_0x28d458){_0x56920f[_0x9796('0x9c')]=_0x28d458;return _0x56920f;});}})[_0x9796('0x2b')](respondWithFilteredResult(_0x557cda,_0x528bda))[_0x9796('0x9d')](handleError(_0x557cda,null));};exports['getHopperFinals']=function(_0x477206,_0x2a53ed,_0x2724a1){var _0x2deb2f={'raw':!![],'where':{}};var _0xde3503={};var _0x3dbc1a={'count':0x0,'rows':[]};return db[_0x9796('0x90')][_0x9796('0x3c')]({'where':{'id':_0x477206[_0x9796('0x9e')]['id']}})[_0x9796('0x2b')](handleEntityNotFound(_0x2a53ed,null))[_0x9796('0x2b')](function(_0x38e5d0){if(_0x38e5d0){_0xde3503[_0x9796('0x41')]=_['keys'](db[_0x9796('0xde')][_0x9796('0xdb')]);_0xde3503[_0x9796('0x42')]=_[_0x9796('0x38')](_0x477206[_0x9796('0x42')]);_0xde3503[_0x9796('0x4b')]=_[_0x9796('0x43')](_0xde3503[_0x9796('0x41')],_0xde3503[_0x9796('0x42')]);_0x2deb2f[_0x9796('0x44')]=_[_0x9796('0x43')](_0xde3503[_0x9796('0x41')],qs[_0x9796('0x45')](_0x477206[_0x9796('0x42')][_0x9796('0x45')]));_0x2deb2f[_0x9796('0x44')]=_0x2deb2f[_0x9796('0x44')][_0x9796('0x39')]?_0x2deb2f[_0x9796('0x44')]:_0xde3503[_0x9796('0x41')];if(!_0x477206[_0x9796('0x42')]['hasOwnProperty'](_0x9796('0x47'))){_0x2deb2f[_0x9796('0x21')]=qs[_0x9796('0x21')](_0x477206[_0x9796('0x42')][_0x9796('0x21')]);_0x2deb2f[_0x9796('0x20')]=qs['offset'](_0x477206[_0x9796('0x42')]['offset']);}_0x2deb2f[_0x9796('0x48')]=qs['sort'](_0x477206[_0x9796('0x42')][_0x9796('0x49')]);_0x2deb2f[_0x9796('0x4a')]=qs[_0x9796('0x4b')](_[_0x9796('0x4c')](_0x477206[_0x9796('0x42')],_0xde3503[_0x9796('0x4b')]));_0x2deb2f[_0x9796('0x4a')][_0x9796('0xd8')]=_0x38e5d0['id'];if(_0x477206[_0x9796('0x42')][_0x9796('0x67')]){_0x2deb2f['where']=_[_0x9796('0xd9')](_0x2deb2f[_0x9796('0x4a')],{'$or':_[_0x9796('0x5c')](_0x2deb2f[_0x9796('0x44')],function(_0x367f2b){var _0xff14b4={};_0xff14b4[_0x367f2b]={'$like':'%'+_0x477206[_0x9796('0x42')][_0x9796('0x67')]+'%'};return _0xff14b4;})});}_0x2deb2f=_[_0x9796('0xd9')]({},_0x2deb2f,_0x477206['options']);return db['CmHopperFinal'][_0x9796('0x23')]({'where':_0x2deb2f[_0x9796('0x4a')]})[_0x9796('0x2b')](function(_0xe823c){_0x3dbc1a[_0x9796('0x23')]=_0xe823c;if(_0x477206[_0x9796('0x42')][_0x9796('0xdc')]){_0x2deb2f[_0x9796('0xdd')]=[{'all':!![]}];}return db[_0x9796('0xde')][_0x9796('0xa0')](_0x2deb2f);})['then'](function(_0x2b204a){_0x3dbc1a[_0x9796('0x9c')]=_0x2b204a;return _0x3dbc1a;});}})[_0x9796('0x2b')](respondWithFilteredResult(_0x2a53ed,_0x2deb2f))[_0x9796('0x9d')](handleError(_0x2a53ed,null));};exports[_0x9796('0xdf')]=function(_0x57b618,_0x1261bd,_0x3918cc){var _0x11b867={'raw':!![],'where':{}};var _0x346c71={};var _0x5cfa1a={'count':0x0,'rows':[]};return db[_0x9796('0x90')][_0x9796('0x3c')]({'where':{'id':_0x57b618[_0x9796('0x9e')]['id']}})[_0x9796('0x2b')](handleEntityNotFound(_0x1261bd,null))[_0x9796('0x2b')](function(_0x274926){if(_0x274926){_0x346c71[_0x9796('0x41')]=_[_0x9796('0x38')](db[_0x9796('0xbc')][_0x9796('0xdb')]);_0x346c71[_0x9796('0x42')]=_[_0x9796('0x38')](_0x57b618['query']);_0x346c71[_0x9796('0x4b')]=_[_0x9796('0x43')](_0x346c71[_0x9796('0x41')],_0x346c71[_0x9796('0x42')]);_0x11b867[_0x9796('0x44')]=_[_0x9796('0x43')](_0x346c71[_0x9796('0x41')],qs[_0x9796('0x45')](_0x57b618[_0x9796('0x42')][_0x9796('0x45')]));_0x11b867[_0x9796('0x44')]=_0x11b867[_0x9796('0x44')]['length']?_0x11b867['attributes']:_0x346c71[_0x9796('0x41')];if(!_0x57b618[_0x9796('0x42')][_0x9796('0x46')](_0x9796('0x47'))){_0x11b867[_0x9796('0x21')]=qs[_0x9796('0x21')](_0x57b618[_0x9796('0x42')][_0x9796('0x21')]);_0x11b867[_0x9796('0x20')]=qs['offset'](_0x57b618[_0x9796('0x42')]['offset']);}_0x11b867[_0x9796('0x48')]=qs[_0x9796('0x49')](_0x57b618[_0x9796('0x42')][_0x9796('0x49')]);_0x11b867[_0x9796('0x4a')]=qs['filters'](_[_0x9796('0x4c')](_0x57b618[_0x9796('0x42')],_0x346c71[_0x9796('0x4b')]));_0x11b867['where'][_0x9796('0xd8')]=_0x274926['id'];if(_0x57b618[_0x9796('0x42')][_0x9796('0x67')]){_0x11b867[_0x9796('0x4a')]=_[_0x9796('0xd9')](_0x11b867[_0x9796('0x4a')],{'$or':_['map'](_0x11b867[_0x9796('0x44')],function(_0x4715f5){var _0xaf5ab1={};_0xaf5ab1[_0x4715f5]={'$like':'%'+_0x57b618[_0x9796('0x42')]['filter']+'%'};return _0xaf5ab1;})});}_0x11b867=_[_0x9796('0xd9')]({},_0x11b867,_0x57b618[_0x9796('0xd3')]);return db['JscriptySessionReport'][_0x9796('0x23')]({'where':_0x11b867[_0x9796('0x4a')]})[_0x9796('0x2b')](function(_0x42fd71){_0x5cfa1a[_0x9796('0x23')]=_0x42fd71;if(_0x57b618['query'][_0x9796('0xdc')]){_0x11b867['include']=[{'all':!![]}];}return db[_0x9796('0xbc')][_0x9796('0xa0')](_0x11b867);})['then'](function(_0x48d012){_0x5cfa1a[_0x9796('0x9c')]=_0x48d012;return _0x5cfa1a;});}})[_0x9796('0x2b')](respondWithFilteredResult(_0x1261bd,_0x11b867))['catch'](handleError(_0x1261bd,null));};exports[_0x9796('0xe0')]=function(_0xfb1bbb,_0x4cce45,_0x57895b){try{if(!_0xfb1bbb[_0x9796('0xa4')][_0x9796('0x6c')]){throw new Error('No\x20ListId\x20specified');}if(!_0xfb1bbb[_0x9796('0xa4')][_0x9796('0xe1')]){throw new Error(_0x9796('0xe2'));}if(!_0xfb1bbb[_0x9796('0xa4')][_0x9796('0xe3')]){throw new Error(_0x9796('0xe4'));}if(!_0xfb1bbb[_0x9796('0xa4')][_0x9796('0xe5')]){throw new Error(_0x9796('0xe6'));}var _0x31c558=_0xfb1bbb[_0x9796('0xa4')][_0x9796('0xe1')]['split'](',');var _0x115d5d=_0xfb1bbb[_0x9796('0xa4')][_0x9796('0xe3')][_0x9796('0x5b')](',');if(!_0x31c558[_0x9796('0x39')]||!_0x115d5d[_0x9796('0x39')]||_0x31c558['length']!==_0x115d5d[_0x9796('0x39')]){throw new Error(_0x9796('0xe7'));}_0xfb1bbb[_0x9796('0xa4')]['fields']=_['zipObject'](_0x31c558,_0x115d5d);if(!_0xfb1bbb['body'][_0x9796('0x45')][_0x9796('0xd1')]){throw new Error(_0x9796('0xe8'));}if(!_0xfb1bbb['body']['fields'][_0x9796('0xe9')]){throw new Error(_0x9796('0xea'));}var _0x28b42e=path[_0x9796('0xa9')](config['root'],_0x9796('0xeb'),_0xfb1bbb['file'][_0x9796('0xec')]);fs[_0x9796('0xed')](_0x28b42e,parseInt('0777',0x8));var _0x11629c=require(_0x9796('0xee'))[_0x9796('0xef')](path['join'](__dirname,'../../components/import/cm/csv'),[_0x28b42e,_0xfb1bbb['body'][_0x9796('0xe1')],_0xfb1bbb['body'][_0x9796('0xe3')],_0xfb1bbb[_0x9796('0xa4')][_0x9796('0x6c')],_0xfb1bbb['body'][_0x9796('0xf0')],_0xfb1bbb[_0x9796('0xa4')]['duplicates'],_0xfb1bbb[_0x9796('0xa4')]['socket_timestamp']]);return _0x4cce45[_0x9796('0x24')](0xc8)[_0x9796('0x1f')]({'message':_0x9796('0xf1'),'pid':_0x11629c[_0x9796('0xf2')]});}catch(_0x4b9967){return _0x4cce45[_0x9796('0x24')](0x1f4)[_0x9796('0x30')](_0x4b9967);}};exports['upload']=function(_0x1b695d,_0x69ade9,_0x2a2237){var _0x91c867=fs[_0x9796('0xf3')](_0x1b695d[_0x9796('0xf4')][_0x9796('0x7')]);Papa[_0x9796('0xf5')](_0x91c867,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x484a16){return _0x69ade9[_0x9796('0x24')](0xc8)['json']({'file':_0x1b695d['file'],'fields':_0x484a16['meta'][_0x9796('0x45')]});}});};exports[_0x9796('0xf6')]=function(_0x386577,_0x264849,_0x15c500){return db[_0x9796('0x8a')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0x9796('0x33')}})[_0x9796('0x2b')](function(_0x10a6b1){var _0x242834=![];if(!_0x386577[_0x9796('0xa4')][_0x9796('0x6c')]){throw new Error(_0x9796('0xf7'));}if(!_0x386577[_0x9796('0xa4')][_0x9796('0xf8')][_0x9796('0xd1')]){throw new Error(_0x9796('0xe8'));}if(!_0x386577[_0x9796('0xa4')]['binding'][_0x9796('0xe9')]){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x386577[_0x9796('0xa4')][_0x9796('0xe5')]){throw new Error(_0x9796('0xe6'));}var _0x18c8e9=require('child_process')['fork'](path[_0x9796('0xa9')](__dirname,_0x9796('0xf9')),[_0x386577[_0x9796('0x9e')]['id'],JSON[_0x9796('0xfa')](_0x386577[_0x9796('0xa4')]),JSON['stringify'](_0x10a6b1)]);_0x18c8e9['on'](_0x9796('0xfb'),function(_0x2d83ec){_0x242834=!![];return _0x264849[_0x9796('0x24')](0xc8)[_0x9796('0x1f')]({'message':_0x9796('0xfc'),'pid':_0x18c8e9[_0x9796('0xf2')]});});_0x18c8e9['on'](_0x9796('0xfd'),function(_0x383b98){if(_0x383b98&&!_0x242834){return _0x264849[_0x9796('0x24')](0x1f4)[_0x9796('0x1f')]({'message':'error\x20child\x20process','pid':_0x18c8e9[_0x9796('0xf2')]});}});})[_0x9796('0x9d')](handleError(_0x264849,null));};exports[_0x9796('0xfe')]=function(_0x1251ee,_0x189267){var _0x25fff2=['mail',_0x9796('0xff'),_0x9796('0x100'),_0x9796('0x101'),_0x9796('0x102'),_0x9796('0x103'),_0x9796('0x104')];var _0xabba6f={'offset':0x0,'order':qs[_0x9796('0x49')](_0x9796('0x105'))},_0xa27b9c={'count':0x0,'rows':[]};Promise['resolve']()[_0x9796('0x2b')](function(){if(_0x1251ee[_0x9796('0x42')]['channel']){if(!_[_0x9796('0x106')](_0x25fff2,_0x1251ee[_0x9796('0x42')][_0x9796('0x107')][_0x9796('0x108')]())){throw new Error(_0x9796('0x109'));}_0x25fff2=[_0x1251ee[_0x9796('0x42')][_0x9796('0x107')]['toLowerCase']()];}if(_0x1251ee[_0x9796('0x42')][_0x9796('0x10a')]){try{var _0x315ce7=JSON[_0x9796('0xf5')](_0x1251ee['query'][_0x9796('0x10a')]);if(!moment(_0x315ce7['from'])['isValid']()){throw new Error(_0x9796('0x10b'));}if(!moment(_0x315ce7['to'])['isValid']()){throw new Error(_0x9796('0x10c'));}}catch(_0x437cc9){throw new Error(_0x9796('0x10d'));}}if(!_0x1251ee[_0x9796('0x42')][_0x9796('0x46')](_0x9796('0x47'))){_0xabba6f[_0x9796('0x21')]=qs[_0x9796('0x21')](_0x1251ee[_0x9796('0x42')][_0x9796('0x21')]||0xa);_0xabba6f[_0x9796('0x20')]=qs[_0x9796('0x20')](_0x1251ee['query'][_0x9796('0x20')]);}var _0x42b98a=_0x25fff2[_0x9796('0x5c')](function(_0x42a901){if(_0x42a901===_0x9796('0x104')){var _0x171d48={'attributes':['id',_0x9796('0x10e'),'type',_0x9796('0x10f'),_0x9796('0x110'),_0x9796('0x111'),_0x9796('0x112'),_0x9796('0x113'),'duration',_0x9796('0x114'),_0x9796('0x115'),_0x9796('0x116'),'userSecondDisposition',_0x9796('0x117'),_0x9796('0x118')],'where':{'ContactId':_0x1251ee[_0x9796('0x9e')]['id']},'include':[{'model':db[_0x9796('0x8a')],'as':_0x9796('0x8a'),'attributes':['id',_0x9796('0x2f'),_0x9796('0x119'),_0x9796('0xa1')]}],'order':[['createdAt',_0x9796('0x83')]]};if(_0x1251ee[_0x9796('0x42')][_0x9796('0x10a')]){_0x171d48[_0x9796('0x4a')]['createdAt']={'$gte':_0x315ce7['from'],'$lte':_0x315ce7['to']};}return db[_0x9796('0xba')]['findAndCountAll'](_0x171d48)[_0x9796('0x2b')](function(_0x39545f){_0xa27b9c[_0x9796('0x23')]+=_0x39545f[_0x9796('0x23')];return _[_0x9796('0x5c')](_0x39545f[_0x9796('0x9c')],function(_0xc8c6a1){var _0x432ef2=_0xc8c6a1[_0x9796('0xa6')]({'plain':!![]});_0x432ef2[_0x9796('0x107')]=_0x42a901;if(_0x432ef2[_0x9796('0x8a')]){_0x432ef2[_0x9796('0x8a')]={'id':_0x432ef2[_0x9796('0x8a')]['id'],'name':_0x432ef2['User']['name'],'fullname':_0x432ef2[_0x9796('0x8a')][_0x9796('0x119')],'alias':_0x432ef2[_0x9796('0x8a')]['alias']};}return _0x432ef2;});});}else{var _0x563fcc=_[_0x9796('0x11a')](_0x42a901)+(_0x42a901===_0x9796('0xff')?'Website':_0x9796('0x11b'));var _0x1d8606={'attributes':['id',_0x9796('0x11c'),'closedAt',_0x9796('0x115'),_0x9796('0x114'),_0x9796('0x11d'),_0x9796('0x11e'),_0x9796('0x11f'),_0x9796('0x118'),_0x563fcc+'Id'],'where':{'ContactId':_0x1251ee[_0x9796('0x9e')]['id']},'include':[{'model':db[_0x563fcc],'as':_0x9796('0x11b'),'attributes':['id',_0x9796('0x2f'),_0x9796('0x120')]},{'model':db[_0x9796('0x8a')],'as':'Owner','attributes':['id',_0x9796('0x2f'),'fullname']},{'model':db[_0x9796('0xc6')],'as':_0x9796('0x9b'),'attributes':['id','name',_0x9796('0x4f')],'through':{'attributes':[]}}],'order':[['createdAt','DESC']]};if(_0x1251ee[_0x9796('0x42')][_0x9796('0x10a')]){_0x1d8606[_0x9796('0x4a')][_0x9796('0x115')]={'$gte':_0x315ce7['from'],'$lte':_0x315ce7['to']};}switch(_0x42a901){case _0x9796('0xff'):_0x1d8606[_0x9796('0x44')][_0x9796('0x6a')](_0x9796('0x121'),_0x9796('0x122'),_0x9796('0x123'),_0x9796('0x124'),_0x9796('0x125'),_0x9796('0x126'),_0x9796('0x127'),_0x9796('0x128'),_0x9796('0x129'));break;case _0x9796('0x12a'):_0x1d8606[_0x9796('0x44')]['push'](_0x9796('0x12b'),_0x9796('0x12c'));break;case _0x9796('0x101'):_0x1d8606[_0x9796('0x44')][_0x9796('0x6a')](_0x9796('0x12d'),'threadId');break;}return db[_[_0x9796('0x11a')](_0x42a901)+'Interaction']['findAndCountAll'](_0x1d8606)[_0x9796('0x2b')](function(_0x38f824){_0xa27b9c['count']+=_0x38f824[_0x9796('0x23')];return _[_0x9796('0x5c')](_0x38f824[_0x9796('0x9c')],function(_0x4da436){var _0x33e74b=_0x4da436[_0x9796('0xa6')]({'plain':!![]});_0x33e74b['channel']=_0x42a901;if(_0x33e74b[_0x9796('0x12e')]){_0x33e74b[_0x9796('0x12e')]={'id':_0x33e74b[_0x9796('0x12e')]['id'],'name':_0x33e74b[_0x9796('0x12e')][_0x9796('0x2f')],'fullname':_0x33e74b['Owner'][_0x9796('0x119')]};}return _0x33e74b;});});}});return Promise[_0x9796('0x3e')](_0x42b98a);})[_0x9796('0x2b')](function(_0x45a9a6){return _(_0x45a9a6)[_0x9796('0x12f')]()['sortBy'](_0x9796('0x115'))['reverse']()['value']();})['then'](function(_0x147ac0){_0xa27b9c[_0x9796('0x9c')]=_0xabba6f[_0x9796('0x21')]?_0x147ac0[_0x9796('0x130')](_0xabba6f['offset'],_0xabba6f[_0x9796('0x20')]+_0xabba6f[_0x9796('0x21')]):_0x147ac0;return _0xa27b9c;})[_0x9796('0x2b')](respondWithFilteredResult(_0x189267,_0xabba6f))[_0x9796('0x9d')](handleError(_0x189267,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff