X-Git-Url: http://repos.xcallymotion.com/?a=blobdiff_plain;f=server%2Fapi%2FcmContact%2FcmContact.controller.js;h=b7f3d988a91e8e1179022148278f35d436dae83b;hb=5bcfff2cfe490b4ab0d0668e644729ef139af2a3;hp=ec0fdc8a2c81392e8c34a97aed02df3e839eaf36;hpb=625a274d7c6c9ea6be043136164c37fd3fc082d8;p=motion2.git

diff --git a/server/api/cmContact/cmContact.controller.js b/server/api/cmContact/cmContact.controller.js
index ec0fdc8..b7f3d98 100644
--- a/server/api/cmContact/cmContact.controller.js
+++ b/server/api/cmContact/cmContact.controller.js
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold. 		           *
 // *                                                                       *
 // *************************************************************************
-var _0x3fa3=['CmHopperBlack','create','ChatInteraction','update','ChatMessage','ChatOfflineMessage','MailMessage','MailInteraction','SmsInteraction','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','CmHopperHistory','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappQueueReport','each','duplicates','$or','findOrCreate','spread','$and','findAll','omit','format','cf_%d','pickBy','cm_contacts','setFields','id\x20=\x20?','toParam','getTags','rawAttributes','intersection','options','ids','getHoppers','ContactId','includeAll','include','rows','getHopperHistories','getHopperFinals','uploadCsv','No\x20ListId\x20specified','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','socket_timestamp','binding_keys','Incorrect\x20binding\x20parameters\x20passed!','phone','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','root','server/files/tmp','file','0777','child_process','fork','../../components/import/cm/csv','CompanyId','File\x20uploaded\x20correctly!','pid','createReadStream','parse','meta','import','binding','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','stringify','message','start\x20child\x20process\x20correctly!','error\x20child\x20process','getJourney','mail','chat','sms','openchannel','fax','-createdAt','channel','toLowerCase','range','isValid','Invalid\x20date\x20for\x20range\x20from\x20filter','Invalid\x20createdAt\x20filter','voice','uniqueid','source','destination','callerid','starttime','endtime','duration','note','createdAt','userDisposition','userSecondDisposition','userThirdDisposition','UserId','findAndCountAll','fullname','startCase','Website','Account','closed','closedAt','disposition','secondDisposition','thirdDisposition','Owner','browserName','customerIp','customerPort','deviceModel','osName','ratingMessage','ratingType','ratingValue','referer','substatus','externalUrl','threadId','Interaction','flatten','sortBy','slice','eml-format','request-promise','moment','bluebird','util','path','sox','to-csv','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','api','../../config/license/util','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./cmContact.socket','register','sendStatus','status','json','count','limit','set','Content-Range','apply','reject','save','then','destroy','end','error','name','send','index','CmContact','describe','keys','length','cf_','CmCustomField','findOne','all','fieldType','type','model','query','attributes','fields','nolimit','offset','order','sort','filters','pick','field','color','uc.CmContactId\x20=\x20c.id','left_join','tools_tags','t.id\x20=\x20ct.TagId','where','expr','search','parseSearch','sqlOperator','conditions','find','Tag','split','map','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','and','uc.UserId\x20=\x20?','value','datetime','castTo','DATE','buildExpression','text','start','hasOwnProperty','filter','isNil','Contact','isEmpty','ListId','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','tag','replace','c.id\x20LIKE\x20?','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','group','Sequelize','SELECT','clone','c.id','DESC','having','t.id\x20IN\x20?','resolve','agent','some','User','getLists','c.ListId\x20IS\x20NULL','c.ListId\x20IN\x20?','user','role','sequelize','toString','keyBy','c.firstName','c.phone','c.mobile','c.fax','c.email','c.ListId','c.createdAt','c.deletedAt','c.CompanyId','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','Tags','push','params','catch','tags','startsWith','displayName','columnName','alias','custom','values','merge','body','get','isArray','join','info','from','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s'];(function(_0xa464c9,_0x7c86d8){var _0x3d73c4=function(_0x5c2056){while(--_0x5c2056){_0xa464c9['push'](_0xa464c9['shift']());}};_0x3d73c4(++_0x7c86d8);}(_0x3fa3,0x89));var _0x33fa=function(_0x20a584,_0xe384a5){_0x20a584=_0x20a584-0x0;var _0x4b41a8=_0x3fa3[_0x20a584];return _0x4b41a8;};'use strict';var emlformat=require(_0x33fa('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0x33fa('0x1'));var moment=require(_0x33fa('0x2'));var BPromise=require(_0x33fa('0x3'));var Mustache=require('mustache');var util=require(_0x33fa('0x4'));var path=require(_0x33fa('0x5'));var sox=require(_0x33fa('0x6'));var csv=require(_0x33fa('0x7'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x33fa('0x8'));var _=require(_0x33fa('0x9'));var squel=require(_0x33fa('0xa'));var crypto=require(_0x33fa('0xb'));var jsforce=require(_0x33fa('0xc'));var deskjs=require(_0x33fa('0xd'));var toCsv=require(_0x33fa('0x7'));var querystring=require(_0x33fa('0xe'));var Papa=require(_0x33fa('0xf'));var Redis=require(_0x33fa('0x10'));var authService=require(_0x33fa('0x11'));var qs=require(_0x33fa('0x12'));var as=require(_0x33fa('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0x33fa('0x14'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0x33fa('0x15'));var db=require(_0x33fa('0x16'))['db'];config[_0x33fa('0x17')]=_[_0x33fa('0x18')](config[_0x33fa('0x17')],{'host':_0x33fa('0x19'),'port':0x18eb});var socket=require(_0x33fa('0x1a'))(new Redis(config[_0x33fa('0x17')]));require(_0x33fa('0x1b'))[_0x33fa('0x1c')](socket);function respondWithStatusCode(_0x49929e,_0xb2570e){_0xb2570e=_0xb2570e||0xcc;return function(_0x5ce2e0){if(_0x5ce2e0){return _0x49929e[_0x33fa('0x1d')](_0xb2570e);}return _0x49929e[_0x33fa('0x1e')](_0xb2570e)['end']();};}function respondWithResult(_0x2b3a80,_0x440cb3){_0x440cb3=_0x440cb3||0xc8;return function(_0x3bbf65){if(_0x3bbf65){return _0x2b3a80[_0x33fa('0x1e')](_0x440cb3)[_0x33fa('0x1f')](_0x3bbf65);}};}function respondWithFilteredResult(_0x50ac17,_0x42f28d){return function(_0x1debc7){if(_0x1debc7){var _0x3e5606=_0x1debc7[_0x33fa('0x20')],_0x26d5de=_0x42f28d['offset'],_0x759143=_0x42f28d['offset']+_0x42f28d[_0x33fa('0x21')],_0x53c717;if(_0x759143>=_0x3e5606){_0x759143=_0x3e5606;_0x53c717=0xc8;}else{_0x53c717=0xce;}_0x50ac17[_0x33fa('0x1e')](_0x53c717);return _0x50ac17[_0x33fa('0x22')](_0x33fa('0x23'),_0x26d5de+'-'+_0x759143+'/'+_0x3e5606)[_0x33fa('0x1f')](_0x1debc7);}return null;};}function patchUpdates(_0x5e4e12){return function(_0xba3c3f){try{jsonpatch[_0x33fa('0x24')](_0xba3c3f,_0x5e4e12,!![]);}catch(_0x22a384){return BPromise[_0x33fa('0x25')](_0x22a384);}return _0xba3c3f[_0x33fa('0x26')]();};}function saveUpdates(_0x3f15d6,_0x39767a){return function(_0x3b04c4){if(_0x3b04c4){return _0x3b04c4['update'](_0x3f15d6)[_0x33fa('0x27')](function(_0x5015b3){return _0x5015b3;});}return null;};}function removeEntity(_0x494af8,_0x3bebf3){return function(_0x43d308){if(_0x43d308){return _0x43d308[_0x33fa('0x28')]()[_0x33fa('0x27')](function(){_0x494af8['status'](0xcc)[_0x33fa('0x29')]();});}};}function handleEntityNotFound(_0x10d125,_0x4a7e09){return function(_0xcc61d0){if(!_0xcc61d0){_0x10d125['sendStatus'](0x194);}return _0xcc61d0;};}function handleError(_0x1ceb15,_0x758d01){_0x758d01=_0x758d01||0x1f4;return function(_0x3301dd){logger[_0x33fa('0x2a')](_0x3301dd['stack']);if(_0x3301dd[_0x33fa('0x2b')]){delete _0x3301dd[_0x33fa('0x2b')];}_0x1ceb15[_0x33fa('0x1e')](_0x758d01)[_0x33fa('0x2c')](_0x3301dd);};}exports[_0x33fa('0x2d')]=function(_0x183ca7,_0x568af7){var _0x590800={},_0x175545={},_0x30e12f={'count':0x0,'rows':[]};return db[_0x33fa('0x2e')][_0x33fa('0x2f')]()['then'](function(_0x52ad50){var _0x14a95c=[];for(var _0x77a2d8=0x0;_0x77a2d8<Object[_0x33fa('0x30')](_0x52ad50)[_0x33fa('0x31')];_0x77a2d8++){var _0x1c3fa6=Object[_0x33fa('0x30')](_0x52ad50)[_0x77a2d8];if(_['startsWith'](_0x1c3fa6,_0x33fa('0x32'))){_0x14a95c['push'](db[_0x33fa('0x33')][_0x33fa('0x34')]({'where':{'id':_['trimStart'](_0x1c3fa6,_0x33fa('0x32'))},'raw':!![]}));}}return BPromise[_0x33fa('0x35')](_0x14a95c)[_0x33fa('0x27')](function(_0x30d8dc){for(var _0x282407=0x0;_0x282407<_0x30d8dc['length'];_0x282407++){if(_0x30d8dc[_0x282407]){var _0x5d3647='cf_'+_0x30d8dc[_0x282407]['id'];var _0x5111d4=_0x52ad50[_0x5d3647];_0x5111d4[_0x33fa('0x36')]=_0x30d8dc[_0x282407][_0x33fa('0x37')];}}return _0x52ad50;});})[_0x33fa('0x27')](function(_0x11d769){_0x175545[_0x33fa('0x38')]=_['keys'](_0x11d769);_0x175545[_0x33fa('0x39')]=_['keys'](_0x183ca7['query']);_0x175545['filters']=_['intersection'](_0x175545[_0x33fa('0x38')],_0x175545[_0x33fa('0x39')]);_0x590800[_0x33fa('0x3a')]=_['intersection'](_0x175545[_0x33fa('0x38')],qs[_0x33fa('0x3b')](_0x183ca7[_0x33fa('0x39')][_0x33fa('0x3b')]));_0x590800[_0x33fa('0x3a')]=_0x590800[_0x33fa('0x3a')][_0x33fa('0x31')]?_0x590800[_0x33fa('0x3a')]:_0x175545['model'];if(!_0x183ca7[_0x33fa('0x39')]['hasOwnProperty'](_0x33fa('0x3c'))){_0x590800[_0x33fa('0x21')]=qs[_0x33fa('0x21')](_0x183ca7[_0x33fa('0x39')][_0x33fa('0x21')]);_0x590800[_0x33fa('0x3d')]=qs[_0x33fa('0x3d')](_0x183ca7[_0x33fa('0x39')][_0x33fa('0x3d')]);}_0x590800[_0x33fa('0x3e')]=qs[_0x33fa('0x3f')](_0x183ca7[_0x33fa('0x39')][_0x33fa('0x3f')]);_0x590800['where']=qs[_0x33fa('0x40')](_[_0x33fa('0x41')](_0x183ca7[_0x33fa('0x39')],_0x175545[_0x33fa('0x40')]),_0x11d769);var _0x1de92a=[];var _0x1b8df7=squel['select']()[_0x33fa('0x42')]('id')[_0x33fa('0x42')]('name')[_0x33fa('0x42')](_0x33fa('0x43'))['from']('tools_tags');var _0x569d72=squel['select']()['from']('cm_contacts','c')['left_join']('cm_user_has_contacts','uc',_0x33fa('0x44'))[_0x33fa('0x45')]('cm_contact_has_tags','ct','ct.CmContactId\x20=\x20c.id')['left_join'](_0x33fa('0x46'),'t',_0x33fa('0x47'))[_0x33fa('0x48')]('c.deletedAt\x20IS\x20NULL');var _0x56ffb0=squel['expr']();var _0x1c9c85=[];var _0x316dcf=squel[_0x33fa('0x49')]();var _0x4e3028;if(_0x183ca7[_0x33fa('0x39')][_0x33fa('0x4a')]){_0x4e3028=as[_0x33fa('0x4b')](_0x183ca7[_0x33fa('0x39')][_0x33fa('0x4a')]);var _0x3c3528=_0x4e3028[_0x33fa('0x4c')];for(var _0x4c97b1=0x0;_0x4c97b1<_0x4e3028[_0x33fa('0x4d')]['length'];_0x4c97b1++){var _0x276e0a=_0x4e3028[_0x33fa('0x4d')][_0x4c97b1];var _0x40e6bc='c';var _0x3d8acb=_(_0x11d769)['keys']()[_0x33fa('0x4e')](function(_0x278bd4){return _0x278bd4===_0x276e0a[_0x33fa('0x42')];});if(_0x3d8acb)_0x3d8acb=_0x11d769[_0x276e0a[_0x33fa('0x42')]];if(!_0x3d8acb){if(_0x276e0a[_0x33fa('0x42')]===_0x33fa('0x4f')){var _0x1e8f30=_0x276e0a['value'][_0x33fa('0x50')](',')[_0x33fa('0x51')](function(_0x10b92a){return Number(_0x10b92a);});_0x1e8f30[_0x33fa('0x52')](function(_0x290178){_0x316dcf['or'](_0x33fa('0x53'),'%,'+_0x290178+',%');});_0x1c9c85=_[_0x33fa('0x54')](_0x1c9c85,_0x1e8f30);}else if(_0x276e0a['field']==='User'){_0x56ffb0[_0x33fa('0x55')](_0x33fa('0x56'),_0x276e0a[_0x33fa('0x57')]);}}else{if(_0x276e0a[_0x33fa('0x42')]==='dateOfBirth'||_0x3d8acb[_0x33fa('0x36')]===_0x33fa('0x58'))_0x276e0a[_0x33fa('0x59')]=_0x33fa('0x5a');var _0x524542=as[_0x33fa('0x5b')](_0x40e6bc,_0x3d8acb[_0x33fa('0x37')],_0x276e0a);_0x56ffb0[_0x3c3528](_0x524542[_0x33fa('0x5c')],_0x524542[_0x33fa('0x57')][_0x33fa('0x5d')],_0x524542[_0x33fa('0x57')][_0x33fa('0x29')]);}}}else{var _0x524fed=_(Object[_0x33fa('0x30')](_0x183ca7[_0x33fa('0x39')]))[_0x33fa('0x51')](function(_0x225e86){return _0x11d769[_0x33fa('0x5e')](_0x225e86)?_0x225e86:undefined;})[_0x33fa('0x5f')](function(_0x483552){return!_[_0x33fa('0x60')](_0x483552);})[_0x33fa('0x57')]();if(_0x183ca7[_0x33fa('0x39')][_0x33fa('0x61')])_0x524fed['push']('Contact');if(!_[_0x33fa('0x62')](_0x524fed)){_0x524fed[_0x33fa('0x52')](function(_0x32cb29){if(_0x32cb29===_0x33fa('0x63')){_0x569d72[_0x33fa('0x48')]('c.ListId\x20IN\x20?',[]['concat'](_0x183ca7['query'][_0x32cb29]));}else if(_0x32cb29===_0x33fa('0x61')){var _0x2d1a4b='%'+_0x183ca7[_0x33fa('0x39')][_0x32cb29]+'%';_0x569d72[_0x33fa('0x48')](_0x33fa('0x64'),_0x2d1a4b);}else{_0x569d72[_0x33fa('0x48')]('c.'+_0x32cb29+_0x33fa('0x65'),_0x183ca7[_0x33fa('0x39')][_0x32cb29]);}});}if(_0x183ca7['query']['tag']){_0x1c9c85=_['isArray'](_0x183ca7['query'][_0x33fa('0x66')])?_0x183ca7[_0x33fa('0x39')][_0x33fa('0x66')]:new Array(_0x183ca7[_0x33fa('0x39')]['tag']);_0x1c9c85[_0x33fa('0x52')](function(_0x1b0ddd){_0x316dcf['or'](_0x33fa('0x53'),'%,'+_0x1b0ddd+',%');});}if(_0x183ca7[_0x33fa('0x39')]['filter']){var _0x52fd15=_0x183ca7['query']['filter'][_0x33fa('0x67')]('\x5c','\x5c\x5c')[_0x33fa('0x67')](/'/g,'\x27\x27');if(_0x52fd15[_0x33fa('0x50')]('\x20')[_0x33fa('0x31')]>0x1){_0x56ffb0['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x52fd15),null);}else{if(qs['isNumeric'](_0x52fd15)){_0x56ffb0['or'](_0x33fa('0x68'),_0x52fd15+'%');_0x56ffb0['or'](_0x33fa('0x69'),_0x52fd15+'%');_0x56ffb0['or'](_0x33fa('0x6a'),_0x52fd15+'%');_0x56ffb0['or'](_0x33fa('0x6b'),_0x52fd15+'%');}else if(qs[_0x33fa('0x6c')](_0x52fd15)){_0x56ffb0['or']('c.email\x20LIKE\x20?',_0x52fd15+'%');}else{_0x56ffb0['or'](_0x33fa('0x6d'),'%'+_0x52fd15+'%');_0x56ffb0['or'](_0x33fa('0x6e'),'%'+_0x52fd15+'%');_0x56ffb0['or']('c.email\x20LIKE\x20?','%'+_0x52fd15+'%');}}}}_0x569d72[_0x33fa('0x48')](_0x56ffb0);_0x569d72[_0x33fa('0x6f')]('c.id');var _0x415061={'type':db[_0x33fa('0x70')]['QueryTypes'][_0x33fa('0x71')],'raw':!![]};var _0x27cc51=_0x569d72[_0x33fa('0x72')]()['field'](_0x33fa('0x73'));if(_0x590800['order']){_0x590800[_0x33fa('0x3e')][_0x33fa('0x52')](function(_0x1917cd){_0x569d72[_0x33fa('0x3e')]('c.'+_0x1917cd[0x0],_0x1917cd[0x1]===_0x33fa('0x74')?![]:!![]);});}if(!_[_0x33fa('0x62')](_0x1c9c85)){_0x569d72[_0x33fa('0x75')](_0x316dcf);_0x27cc51['where'](_0x33fa('0x76'),_0x1c9c85);}BPromise[_0x33fa('0x77')]()[_0x33fa('0x27')](function(){if(!_0x4e3028)return;if(_0x183ca7['user']['role']!==_0x33fa('0x78'))return;if(!_[_0x33fa('0x79')](_0x4e3028[_0x33fa('0x4d')],[_0x33fa('0x42'),_0x33fa('0x7a')])){return _0x183ca7['user'][_0x33fa('0x7b')]({'attributes':['id'],'raw':!![]})[_0x33fa('0x27')](function(_0x473c48){if(_[_0x33fa('0x62')](_0x473c48)){_0x27cc51[_0x33fa('0x48')]('c.ListId\x20IS\x20NULL');_0x569d72[_0x33fa('0x48')](_0x33fa('0x7c'));}else{_0x27cc51[_0x33fa('0x48')](_0x33fa('0x7d'),_[_0x33fa('0x51')](_0x473c48,'id'));_0x569d72[_0x33fa('0x48')](_0x33fa('0x7d'),_[_0x33fa('0x51')](_0x473c48,'id'));}});}})[_0x33fa('0x27')](function(){if(_0x183ca7[_0x33fa('0x7e')][_0x33fa('0x7f')]===_0x33fa('0x78')&&!_0x4e3028&&!_0x183ca7['query']['ListId'])return[];return db[_0x33fa('0x80')][_0x33fa('0x39')](_0x27cc51[_0x33fa('0x81')](),_0x415061);})['then'](function(_0x41cd0d){_0x30e12f['count']=_0x41cd0d[_0x33fa('0x31')];if(_0x30e12f[_0x33fa('0x20')]===0x0)return[];return db['sequelize'][_0x33fa('0x39')](_0x1b8df7[_0x33fa('0x81')](),_0x415061)['then'](function(_0x303237){_0x1de92a=_[_0x33fa('0x82')](_0x303237,'id');_0x415061=_['merge'](_0x415061,{'model':db['CmContact'],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x183ca7[_0x33fa('0x39')][_0x33fa('0x3b')]){_0x590800[_0x33fa('0x3a')]['forEach'](function(_0x5168f7){_0x569d72['field']('c.'+_0x5168f7);});}else{_0x569d72[_0x33fa('0x42')](_0x33fa('0x73'));_0x569d72['field'](_0x33fa('0x83'));_0x569d72[_0x33fa('0x42')]('c.lastName');_0x569d72[_0x33fa('0x42')](_0x33fa('0x84'));_0x569d72[_0x33fa('0x42')](_0x33fa('0x85'));_0x569d72[_0x33fa('0x42')](_0x33fa('0x86'));_0x569d72[_0x33fa('0x42')](_0x33fa('0x87'));_0x569d72[_0x33fa('0x42')](_0x33fa('0x88'));_0x569d72['field'](_0x33fa('0x89'));_0x569d72[_0x33fa('0x42')](_0x33fa('0x8a'));_0x569d72[_0x33fa('0x42')](_0x33fa('0x8b'));_0x569d72[_0x33fa('0x42')](_0x33fa('0x8c'),_0x33fa('0x8d'));}if(_0x590800[_0x33fa('0x21')])_0x569d72['limit'](_0x590800[_0x33fa('0x21')]);if(_0x590800[_0x33fa('0x3d')])_0x569d72[_0x33fa('0x3d')](_0x590800[_0x33fa('0x3d')]);return db['sequelize']['query'](_0x569d72[_0x33fa('0x81')](),_0x415061);});})[_0x33fa('0x27')](function(_0x6f0812){_0x6f0812['forEach'](function(_0x382965){if(_0x382965[_0x33fa('0x8d')]){_0x382965[_0x33fa('0x8e')]=[];_0x382965[_0x33fa('0x8d')][_0x33fa('0x50')](',')[_0x33fa('0x52')](function(_0x1311ad){_0x382965[_0x33fa('0x8e')][_0x33fa('0x8f')](_0x1de92a[_0x1311ad]);});}delete _0x382965[_0x33fa('0x8d')];});_0x30e12f['rows']=_0x6f0812;return _0x30e12f;})[_0x33fa('0x27')](respondWithFilteredResult(_0x568af7,_0x590800));})['catch'](handleError(_0x568af7,null));};exports[_0x33fa('0x28')]=function(_0x3598fd,_0x1e7536){return db[_0x33fa('0x2e')][_0x33fa('0x4e')]({'where':{'id':_0x3598fd[_0x33fa('0x90')]['id']}})[_0x33fa('0x27')](handleEntityNotFound(_0x1e7536,null))['then'](removeEntity(_0x1e7536,null))[_0x33fa('0x91')](handleError(_0x1e7536,null));};exports[_0x33fa('0x2f')]=function(_0x288b71,_0x3ba956){return db[_0x33fa('0x2e')][_0x33fa('0x2f')]()['then'](function(_0x1e4bf0){delete _0x1e4bf0[_0x33fa('0x92')];for(var _0x2d7a1b=0x0;_0x2d7a1b<Object['keys'](_0x1e4bf0)[_0x33fa('0x31')];_0x2d7a1b++){var _0xf58fc8=Object['keys'](_0x1e4bf0)[_0x2d7a1b];if(!_[_0x33fa('0x93')](_0xf58fc8,_0x33fa('0x32'))){_0x1e4bf0[_0xf58fc8]['columnName']=_0xf58fc8;_0x1e4bf0[_0xf58fc8][_0x33fa('0x94')]=_0xf58fc8;}}return _0x1e4bf0;})['then'](function(_0x39e8af){var _0x138664={'where':{'$or':[{'ListId':_0x288b71[_0x33fa('0x39')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x33fa('0x33')]['findAll'](_0x138664)[_0x33fa('0x27')](function(_0x24bfaf){for(var _0x1245e=0x0;_0x1245e<_0x24bfaf[_0x33fa('0x31')];_0x1245e++){var _0x222a4b='cf_'+_0x24bfaf[_0x1245e]['id'];_0x39e8af[_0x222a4b][_0x33fa('0x95')]=_0x222a4b;_0x39e8af[_0x222a4b][_0x33fa('0x94')]=_0x24bfaf[_0x1245e][_0x33fa('0x96')];_0x39e8af[_0x222a4b][_0x33fa('0x97')]={'type':_0x24bfaf[_0x1245e][_0x33fa('0x37')],'values':_0x24bfaf[_0x1245e][_0x33fa('0x98')]};}Object['keys'](_0x39e8af)[_0x33fa('0x52')](function(_0x59e20b){if(!_0x39e8af[_0x59e20b][_0x33fa('0x5e')]('columnName')){delete _0x39e8af[_0x59e20b];}});return _0x39e8af;});})[_0x33fa('0x27')](respondWithResult(_0x3ba956,null))[_0x33fa('0x91')](handleError(_0x3ba956,null));};exports[_0x33fa('0x99')]=function(_0x2693dc,_0x3fa7a4){var _0x35cc8e;var _0xa42aa9;var _0x17684a;if(_0x2693dc['body']['id']){delete _0x2693dc['body']['id'];}return db[_0x33fa('0x2e')]['findAll']({'where':{'id':[_0x2693dc[_0x33fa('0x9a')]['to'],_0x2693dc[_0x33fa('0x9a')]['from']]}})[_0x33fa('0x27')](function(_0x5dcce9){if(_0x5dcce9){if(_0x5dcce9['length']!==0x2){return null;}_0x5dcce9[0x0]=_0x5dcce9[0x0][_0x33fa('0x9b')]({'plain':!![]});_0x5dcce9[0x1]=_0x5dcce9[0x1][_0x33fa('0x9b')]({'plain':!![]});delete _0x5dcce9[0x0]['id'];delete _0x5dcce9[0x1]['id'];return _['mergeWith'](_0x5dcce9[0x0],_0x5dcce9[0x1],function(_0x3768d5,_0x4dd1fb){if(Array[_0x33fa('0x9c')](_0x4dd1fb)&&!_0x4dd1fb['length']){return _0x3768d5;}else if(!_0x4dd1fb){return _0x3768d5;}});}})[_0x33fa('0x27')](handleEntityNotFound(_0x3fa7a4,null))[_0x33fa('0x27')](function(_0x1c97c4){if(_0x1c97c4){if(_0x1c97c4[_0x33fa('0x92')]&&_[_0x33fa('0x9c')](_0x1c97c4[_0x33fa('0x92')])){_0x1c97c4[_0x33fa('0x92')]=_0x1c97c4['tags'][_0x33fa('0x9d')]();}logger[_0x33fa('0x9e')]('[CmContact][merge]\x20to\x20%s\x20from\x20%s',_0x2693dc[_0x33fa('0x9a')]['to'],_0x2693dc[_0x33fa('0x9a')][_0x33fa('0x9f')]);return db[_0x33fa('0xa0')][_0x33fa('0x28')]({'where':{'ContactId':[_0x2693dc['body']['to'],_0x2693dc[_0x33fa('0x9a')][_0x33fa('0x9f')]]}})[_0x33fa('0x27')](function(_0x58cfe5){logger[_0x33fa('0x9e')](_0x33fa('0xa1'),_0x58cfe5);return db[_0x33fa('0xa2')][_0x33fa('0x28')]({'where':{'ContactId':[_0x2693dc[_0x33fa('0x9a')]['to'],_0x2693dc[_0x33fa('0x9a')][_0x33fa('0x9f')]]}})[_0x33fa('0x27')](function(_0x5e69a9){logger[_0x33fa('0x9e')]('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x5e69a9);return db[_0x33fa('0x2e')][_0x33fa('0xa3')](_0x1c97c4);});});}})[_0x33fa('0x27')](function(_0x2a2f16){if(_0x2a2f16){_0x35cc8e=_0x2a2f16;_0xa42aa9={'ContactId':_0x35cc8e['id']};_0x17684a={'where':{'ContactId':[_0x2693dc[_0x33fa('0x9a')]['to'],_0x2693dc['body'][_0x33fa('0x9f')]]}};return db[_0x33fa('0xa4')][_0x33fa('0xa5')](_0xa42aa9,_0x17684a);}})[_0x33fa('0x27')](function(){if(_0x35cc8e){return db[_0x33fa('0xa6')][_0x33fa('0xa5')](_0xa42aa9,_0x17684a);}})['then'](function(){if(_0x35cc8e){return db[_0x33fa('0xa7')][_0x33fa('0xa5')](_0xa42aa9,_0x17684a);}})[_0x33fa('0x27')](function(){if(_0x35cc8e){return db['MailInteraction'][_0x33fa('0xa5')](_0xa42aa9,_0x17684a);}})[_0x33fa('0x27')](function(){if(_0x35cc8e){return db[_0x33fa('0xa8')]['update'](_0xa42aa9,_0x17684a);}})[_0x33fa('0x27')](function(){if(_0x35cc8e){return db[_0x33fa('0xa9')]['update'](_0xa42aa9,_0x17684a);}})[_0x33fa('0x27')](function(){if(_0x35cc8e){return db[_0x33fa('0xa8')]['update'](_0xa42aa9,_0x17684a);}})['then'](function(){if(_0x35cc8e){return db[_0x33fa('0xaa')][_0x33fa('0xa5')](_0xa42aa9,_0x17684a);}})['then'](function(){if(_0x35cc8e){return db['SmsMessage'][_0x33fa('0xa5')](_0xa42aa9,_0x17684a);}})['then'](function(){if(_0x35cc8e){return db[_0x33fa('0xab')][_0x33fa('0xa5')](_0xa42aa9,_0x17684a);}})[_0x33fa('0x27')](function(){if(_0x35cc8e){return db[_0x33fa('0xac')][_0x33fa('0xa5')](_0xa42aa9,_0x17684a);}})['then'](function(){if(_0x35cc8e){return db[_0x33fa('0xad')]['update'](_0xa42aa9,_0x17684a);}})[_0x33fa('0x27')](function(){if(_0x35cc8e){return db[_0x33fa('0xae')][_0x33fa('0xa5')](_0xa42aa9,_0x17684a);}})[_0x33fa('0x27')](function(){if(_0x35cc8e){return db[_0x33fa('0xaf')]['update'](_0xa42aa9,_0x17684a);}})[_0x33fa('0x27')](function(){if(_0x35cc8e){return db[_0x33fa('0xb0')]['update'](_0xa42aa9,_0x17684a);}})[_0x33fa('0x27')](function(){if(_0x35cc8e){return db['ReportAgentPreview']['update'](_0xa42aa9,_0x17684a);}})[_0x33fa('0x27')](function(){if(_0x35cc8e){return db[_0x33fa('0xb1')][_0x33fa('0xa5')](_0xa42aa9,_0x17684a);}})['then'](function(){if(_0x35cc8e){return db[_0x33fa('0xb2')][_0x33fa('0xa5')](_0xa42aa9,_0x17684a);}})[_0x33fa('0x27')](function(){if(_0x35cc8e){return db[_0x33fa('0xb3')][_0x33fa('0xa5')](_0xa42aa9,_0x17684a);}})[_0x33fa('0x27')](function(){if(_0x35cc8e){return db[_0x33fa('0xb4')][_0x33fa('0xa5')](_0xa42aa9,_0x17684a);}})[_0x33fa('0x27')](function(){if(_0x35cc8e){return db[_0x33fa('0xb5')][_0x33fa('0xa5')](_0xa42aa9,_0x17684a);}})[_0x33fa('0x27')](function(){if(_0x35cc8e){return db[_0x33fa('0xb6')][_0x33fa('0xa5')](_0xa42aa9,_0x17684a);}})['then'](function(){if(_0x35cc8e){return db[_0x33fa('0xb7')][_0x33fa('0xa5')](_0xa42aa9,_0x17684a);}})['then'](function(){if(_0x35cc8e){return db[_0x33fa('0xb8')]['update'](_0xa42aa9,_0x17684a);}})[_0x33fa('0x27')](function(){if(_0x35cc8e){return db['WhatsappMessage'][_0x33fa('0xa5')](_0xa42aa9,_0x17684a);}})['then'](function(){if(_0x35cc8e){return db[_0x33fa('0xb9')]['update'](_0xa42aa9,_0x17684a);}})[_0x33fa('0x27')](function(){if(_0x35cc8e){return db[_0x33fa('0x2e')]['destroy']({'where':{'id':[_0x2693dc[_0x33fa('0x9a')]['to'],_0x2693dc[_0x33fa('0x9a')]['from']]}});}})[_0x33fa('0x27')](function(){if(_0x35cc8e){return _0x35cc8e;}})[_0x33fa('0x27')](respondWithResult(_0x3fa7a4,null))['catch'](handleError(_0x3fa7a4,null));};exports[_0x33fa('0xa3')]=function(_0xf73fee,_0x187e5f){return db[_0x33fa('0x2e')][_0x33fa('0x2f')]()[_0x33fa('0x27')](function(_0x3362c2){if(_0xf73fee[_0x33fa('0x9a')][_0x33fa('0x92')]&&_['isArray'](_0xf73fee[_0x33fa('0x9a')][_0x33fa('0x92')])){if(_0xf73fee[_0x33fa('0x9a')]['tags'][_0x33fa('0x31')]){_0xf73fee[_0x33fa('0x9a')][_0x33fa('0x92')]=_0xf73fee[_0x33fa('0x9a')][_0x33fa('0x92')][_0x33fa('0x9d')](';')+';';}else{_0xf73fee[_0x33fa('0x9a')][_0x33fa('0x92')]=null;}}else{_0xf73fee[_0x33fa('0x9a')]['tags']=null;}return db['CmContact'][_0x33fa('0xa3')](_0xf73fee[_0x33fa('0x9a')],{'fields':_[_0x33fa('0x30')](_0x3362c2),'raw':!![]});})[_0x33fa('0x27')](respondWithResult(_0x187e5f,0xc9))[_0x33fa('0x91')](handleError(_0x187e5f,null));};exports['bulkCreate']=function(_0x3b40d2,_0x799c62){var _0x535c3c=[];var _0x28e186=0x0;var _0x505449=0x0;var _0x53a349=0x0;return db[_0x33fa('0x2e')]['describe']()[_0x33fa('0x27')](function(_0xe73e4a){return BPromise[_0x33fa('0xba')](_0x3b40d2[_0x33fa('0x9a')],function(_0xc6608e){var _0x41b513={'where':{'$or':[]},'defaults':_0xc6608e,'fields':_[_0x33fa('0x30')](_0xe73e4a),'raw':!![]};if(_0xc6608e[_0x33fa('0xbb')]){for(var _0x339bbb=0x0;_0x339bbb<_0xc6608e[_0x33fa('0xbb')][_0x33fa('0x31')];_0x339bbb++){var _0x367a3b={};_0x367a3b[_0xc6608e[_0x33fa('0xbb')][_0x339bbb]]=_0xc6608e[_0xc6608e[_0x33fa('0xbb')][_0x339bbb]];_0x41b513[_0x33fa('0x48')][_0x33fa('0xbc')]['push'](_0x367a3b);}_0x41b513['where'][_0x33fa('0x63')]=_0xc6608e[_0x33fa('0x63')];}return db['CmContact'][_0x33fa('0xbd')](_0x41b513)[_0x33fa('0xbe')](function(_0x2c595c,_0x417a2f){if(_0x417a2f){_0x28e186++;}else{_0x53a349++;}})['catch'](function(_0x5f29d8){console[_0x33fa('0x2a')](_0x5f29d8);_0x505449++;});});})[_0x33fa('0x27')](function(_0x3520d8){if(_0x3520d8){return{'success':_0x28e186,'failure':_0x505449,'duplicates':_0x53a349};}})[_0x33fa('0x27')](respondWithResult(_0x799c62,0xc9))['catch'](handleError(_0x799c62,null));};exports['show']=function(_0x154500,_0x5cc9e3,_0x244c69){var _0x4e36b0;return db[_0x33fa('0x2e')]['describe']()['then'](function(_0x55b8fc){return db[_0x33fa('0x2e')]['find']({'where':{'id':_0x154500['params']['id']},'include':[{'model':db[_0x33fa('0x4f')],'as':_0x33fa('0x8e'),'attributes':['id',_0x33fa('0x2b'),_0x33fa('0x43')],'required':_0x154500['query'][_0x33fa('0x66')]?!![]:![]}],'attributes':_[_0x33fa('0x30')](_0x55b8fc)});})['then'](function(_0xdd9d60){_0x4e36b0=_0xdd9d60[_0x33fa('0x9b')]({'plain':!![]});var _0x177359={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0xdd9d60&&_0xdd9d60[_0x33fa('0x63')]){if(_0xdd9d60[_0x33fa('0x63')]){_0x177359['where'][_0x33fa('0xbf')]['push']({'ListId':{'$ne':_0xdd9d60[_0x33fa('0x63')]}});}}return db[_0x33fa('0x33')][_0x33fa('0xc0')](_0x177359);})['then'](function(_0x5add86){return _[_0x33fa('0xc1')](_0x4e36b0,_[_0x33fa('0x51')](_0x5add86,function(_0x34ef04){return util[_0x33fa('0xc2')](_0x33fa('0xc3'),_0x34ef04['id']);}));})[_0x33fa('0x27')](handleEntityNotFound(_0x5cc9e3,null))[_0x33fa('0x27')](respondWithResult(_0x5cc9e3,null))['catch'](handleError(_0x5cc9e3,null));};exports['update']=function(_0x34030f,_0x3faea9){var _0x5b31f6;if(_0x34030f['body']['id']){delete _0x34030f['body']['id'];}return db[_0x33fa('0x2e')][_0x33fa('0x4e')]({'where':{'id':_0x34030f[_0x33fa('0x90')]['id']}})[_0x33fa('0x27')](handleEntityNotFound(_0x3faea9,null))['then'](saveUpdates(_0x34030f[_0x33fa('0x9a')],null))['then'](function(_0x70ff1b){_0x5b31f6=_0x70ff1b;var _0x4033ae={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x70ff1b&&_0x70ff1b[_0x33fa('0x63')]){if(_0x70ff1b[_0x33fa('0x63')]){_0x4033ae['where'][_0x33fa('0xbf')][_0x33fa('0x8f')]({'ListId':{'$ne':_0x70ff1b['ListId']}});}}return db[_0x33fa('0x33')][_0x33fa('0xc0')](_0x4033ae);})['then'](function(_0x345852){if(_0x345852){return _['omit'](_[_0x33fa('0xc4')](_0x34030f['body'],function(_0x1aff67,_0x2742b6){return _[_0x33fa('0x93')](_0x2742b6,_0x33fa('0x32'));}),_[_0x33fa('0x51')](_0x345852,function(_0x5a04f1){return util[_0x33fa('0xc2')](_0x33fa('0xc3'),_0x5a04f1['id']);}));}})[_0x33fa('0x27')](function(_0x39b034){if(_0x39b034&&!_['isEmpty'](_0x39b034)){var _0x505730=squel[_0x33fa('0xa5')]()['table'](_0x33fa('0xc5'))[_0x33fa('0xc6')](_0x39b034)['where'](_0x33fa('0xc7'),_0x34030f['params']['id'])[_0x33fa('0xc8')]();return db[_0x33fa('0x80')]['query'](_0x505730['text'],{'replacements':_0x505730[_0x33fa('0x98')]});}})[_0x33fa('0x27')](function(){if(_0x34030f[_0x33fa('0x9a')]['phone']&&_0x5b31f6){return db[_0x33fa('0xa0')]['update']({'phone':_0x34030f[_0x33fa('0x9a')]['phone']},{'where':{'ContactId':_0x5b31f6['id']}});}})['then'](function(){return _0x5b31f6;})[_0x33fa('0x27')](respondWithResult(_0x3faea9,null))[_0x33fa('0x91')](handleError(_0x3faea9,null));};exports[_0x33fa('0xc9')]=function(_0x35b424,_0x543772,_0x28b759){var _0x4f245e={};var _0x12c51d={};var _0x26155a;var _0x124c23;return db[_0x33fa('0x2e')]['findOne']({'where':{'id':_0x35b424[_0x33fa('0x90')]['id']}})[_0x33fa('0x27')](handleEntityNotFound(_0x543772,null))[_0x33fa('0x27')](function(_0x3bcd7e){if(_0x3bcd7e){_0x26155a=_0x3bcd7e;_0x12c51d[_0x33fa('0x38')]=_[_0x33fa('0x30')](db['Tag'][_0x33fa('0xca')]);_0x12c51d[_0x33fa('0x39')]=_[_0x33fa('0x30')](_0x35b424['query']);_0x12c51d[_0x33fa('0x40')]=_[_0x33fa('0xcb')](_0x12c51d['model'],_0x12c51d[_0x33fa('0x39')]);_0x4f245e[_0x33fa('0x3a')]=_[_0x33fa('0xcb')](_0x12c51d[_0x33fa('0x38')],qs[_0x33fa('0x3b')](_0x35b424[_0x33fa('0x39')][_0x33fa('0x3b')]));_0x4f245e[_0x33fa('0x3a')]=_0x4f245e[_0x33fa('0x3a')][_0x33fa('0x31')]?_0x4f245e[_0x33fa('0x3a')]:_0x12c51d[_0x33fa('0x38')];_0x4f245e[_0x33fa('0x3e')]=qs[_0x33fa('0x3f')](_0x35b424['query'][_0x33fa('0x3f')]);_0x4f245e[_0x33fa('0x48')]=qs[_0x33fa('0x40')](_[_0x33fa('0x41')](_0x35b424[_0x33fa('0x39')],_0x12c51d[_0x33fa('0x40')]));if(_0x35b424[_0x33fa('0x39')][_0x33fa('0x5f')]){_0x4f245e[_0x33fa('0x48')]=_[_0x33fa('0x99')](_0x4f245e['where'],{'$or':_[_0x33fa('0x51')](_0x4f245e[_0x33fa('0x3a')],function(_0x40a5e2){var _0xec5599={};_0xec5599[_0x40a5e2]={'$like':'%'+_0x35b424[_0x33fa('0x39')]['filter']+'%'};return _0xec5599;})});}_0x4f245e=_['merge']({},_0x4f245e,_0x35b424[_0x33fa('0xcc')]);return _0x26155a[_0x33fa('0xc9')](_0x4f245e);}})[_0x33fa('0x27')](function(_0x535061){if(_0x535061){_0x124c23=_0x535061[_0x33fa('0x31')];if(!_0x35b424['query'][_0x33fa('0x5e')]('nolimit')){_0x4f245e[_0x33fa('0x21')]=qs[_0x33fa('0x21')](_0x35b424['query'][_0x33fa('0x21')]);_0x4f245e[_0x33fa('0x3d')]=qs[_0x33fa('0x3d')](_0x35b424['query'][_0x33fa('0x3d')]);}return _0x26155a['getTags'](_0x4f245e);}})[_0x33fa('0x27')](function(_0x1f118c){if(_0x1f118c){return _0x1f118c?{'count':_0x124c23,'rows':_0x1f118c}:null;}})[_0x33fa('0x27')](respondWithResult(_0x543772,null))[_0x33fa('0x91')](handleError(_0x543772,null));};exports['setTags']=function(_0x5ae300,_0x3cc4b1,_0x3a2291){if(_0x5ae300['body']['id']){delete _0x5ae300[_0x33fa('0x9a')]['id'];}return db['CmContact'][_0x33fa('0x34')]({'where':{'id':_0x5ae300['params']['id']}})[_0x33fa('0x27')](handleEntityNotFound(_0x3cc4b1,null))[_0x33fa('0x27')](function(_0x3b0d07){if(_0x3b0d07){return _0x3b0d07['setTags'](_0x5ae300[_0x33fa('0x9a')][_0x33fa('0xcd')]||[]);}return null;})[_0x33fa('0x27')](respondWithResult(_0x3cc4b1,null))[_0x33fa('0x91')](handleError(_0x3cc4b1,null));};exports[_0x33fa('0xce')]=function(_0xae5b6a,_0x19bc40,_0x26f159){var _0x97417b={'raw':![],'where':{}};var _0x246bf2={};var _0x3b117a={'count':0x0,'rows':[]};return db[_0x33fa('0x2e')][_0x33fa('0x34')]({'where':{'id':_0xae5b6a[_0x33fa('0x90')]['id']}})[_0x33fa('0x27')](handleEntityNotFound(_0x19bc40,null))[_0x33fa('0x27')](function(_0x318bd5){if(_0x318bd5){_0x246bf2[_0x33fa('0x38')]=_[_0x33fa('0x30')](db[_0x33fa('0xa0')][_0x33fa('0xca')]);_0x246bf2[_0x33fa('0x39')]=_[_0x33fa('0x30')](_0xae5b6a[_0x33fa('0x39')]);_0x246bf2[_0x33fa('0x40')]=_[_0x33fa('0xcb')](_0x246bf2[_0x33fa('0x38')],_0x246bf2['query']);_0x97417b[_0x33fa('0x3a')]=_[_0x33fa('0xcb')](_0x246bf2[_0x33fa('0x38')],qs['fields'](_0xae5b6a[_0x33fa('0x39')][_0x33fa('0x3b')]));_0x97417b[_0x33fa('0x3a')]=_0x97417b[_0x33fa('0x3a')][_0x33fa('0x31')]?_0x97417b[_0x33fa('0x3a')]:_0x246bf2[_0x33fa('0x38')];if(!_0xae5b6a[_0x33fa('0x39')][_0x33fa('0x5e')](_0x33fa('0x3c'))){_0x97417b[_0x33fa('0x21')]=qs[_0x33fa('0x21')](_0xae5b6a[_0x33fa('0x39')][_0x33fa('0x21')]);_0x97417b[_0x33fa('0x3d')]=qs[_0x33fa('0x3d')](_0xae5b6a['query'][_0x33fa('0x3d')]);}_0x97417b[_0x33fa('0x3e')]=qs[_0x33fa('0x3f')](_0xae5b6a[_0x33fa('0x39')][_0x33fa('0x3f')]);_0x97417b[_0x33fa('0x48')]=qs[_0x33fa('0x40')](_[_0x33fa('0x41')](_0xae5b6a[_0x33fa('0x39')],_0x246bf2['filters']));_0x97417b[_0x33fa('0x48')][_0x33fa('0xcf')]=_0x318bd5['id'];if(_0xae5b6a['query'][_0x33fa('0x5f')]){_0x97417b[_0x33fa('0x48')]=_[_0x33fa('0x99')](_0x97417b['where'],{'$or':_[_0x33fa('0x51')](_0x97417b[_0x33fa('0x3a')],function(_0xf0aaf1){var _0x17680e={};_0x17680e[_0xf0aaf1]={'$like':'%'+_0xae5b6a['query'][_0x33fa('0x5f')]+'%'};return _0x17680e;})});}_0x97417b=_[_0x33fa('0x99')]({},_0x97417b,_0xae5b6a[_0x33fa('0xcc')]);return db['CmHopper'][_0x33fa('0x20')]({'where':_0x97417b[_0x33fa('0x48')]})[_0x33fa('0x27')](function(_0x389f5d){_0x3b117a[_0x33fa('0x20')]=_0x389f5d;if(_0xae5b6a[_0x33fa('0x39')][_0x33fa('0xd0')]){_0x97417b[_0x33fa('0xd1')]=[{'all':!![]}];}return db[_0x33fa('0xa0')][_0x33fa('0xc0')](_0x97417b);})[_0x33fa('0x27')](function(_0x50871){_0x3b117a[_0x33fa('0xd2')]=_0x50871;return _0x3b117a;});}})[_0x33fa('0x27')](respondWithFilteredResult(_0x19bc40,_0x97417b))[_0x33fa('0x91')](handleError(_0x19bc40,null));};exports[_0x33fa('0xd3')]=function(_0xace80d,_0x3f6ed7,_0x566957){var _0x45b280={'raw':!![],'where':{}};var _0x2da323={};var _0x30326d={'count':0x0,'rows':[]};return db[_0x33fa('0x2e')][_0x33fa('0x34')]({'where':{'id':_0xace80d[_0x33fa('0x90')]['id']}})[_0x33fa('0x27')](handleEntityNotFound(_0x3f6ed7,null))[_0x33fa('0x27')](function(_0x560a36){if(_0x560a36){_0x2da323['model']=_[_0x33fa('0x30')](db[_0x33fa('0xb0')]['rawAttributes']);_0x2da323[_0x33fa('0x39')]=_[_0x33fa('0x30')](_0xace80d[_0x33fa('0x39')]);_0x2da323['filters']=_[_0x33fa('0xcb')](_0x2da323[_0x33fa('0x38')],_0x2da323[_0x33fa('0x39')]);_0x45b280[_0x33fa('0x3a')]=_[_0x33fa('0xcb')](_0x2da323[_0x33fa('0x38')],qs[_0x33fa('0x3b')](_0xace80d[_0x33fa('0x39')][_0x33fa('0x3b')]));_0x45b280['attributes']=_0x45b280[_0x33fa('0x3a')][_0x33fa('0x31')]?_0x45b280[_0x33fa('0x3a')]:_0x2da323['model'];if(!_0xace80d[_0x33fa('0x39')][_0x33fa('0x5e')](_0x33fa('0x3c'))){_0x45b280[_0x33fa('0x21')]=qs[_0x33fa('0x21')](_0xace80d[_0x33fa('0x39')][_0x33fa('0x21')]);_0x45b280['offset']=qs[_0x33fa('0x3d')](_0xace80d[_0x33fa('0x39')][_0x33fa('0x3d')]);}_0x45b280[_0x33fa('0x3e')]=qs[_0x33fa('0x3f')](_0xace80d[_0x33fa('0x39')][_0x33fa('0x3f')]);_0x45b280[_0x33fa('0x48')]=qs['filters'](_[_0x33fa('0x41')](_0xace80d[_0x33fa('0x39')],_0x2da323['filters']));_0x45b280[_0x33fa('0x48')]['ContactId']=_0x560a36['id'];if(_0xace80d[_0x33fa('0x39')]['filter']){_0x45b280['where']=_[_0x33fa('0x99')](_0x45b280[_0x33fa('0x48')],{'$or':_[_0x33fa('0x51')](_0x45b280['attributes'],function(_0x169104){var _0x18aea8={};_0x18aea8[_0x169104]={'$like':'%'+_0xace80d[_0x33fa('0x39')][_0x33fa('0x5f')]+'%'};return _0x18aea8;})});}_0x45b280=_['merge']({},_0x45b280,_0xace80d[_0x33fa('0xcc')]);return db['CmHopperHistory'][_0x33fa('0x20')]({'where':_0x45b280[_0x33fa('0x48')]})[_0x33fa('0x27')](function(_0x2d6868){_0x30326d['count']=_0x2d6868;if(_0xace80d[_0x33fa('0x39')][_0x33fa('0xd0')]){_0x45b280[_0x33fa('0xd1')]=[{'all':!![]}];}return db[_0x33fa('0xb0')][_0x33fa('0xc0')](_0x45b280);})[_0x33fa('0x27')](function(_0x5a9606){_0x30326d[_0x33fa('0xd2')]=_0x5a9606;return _0x30326d;});}})['then'](respondWithFilteredResult(_0x3f6ed7,_0x45b280))[_0x33fa('0x91')](handleError(_0x3f6ed7,null));};exports[_0x33fa('0xd4')]=function(_0x34a217,_0x1626f4,_0xf9216){var _0x1c71b8={'raw':!![],'where':{}};var _0x57ed86={};var _0x1f2ea6={'count':0x0,'rows':[]};return db[_0x33fa('0x2e')]['findOne']({'where':{'id':_0x34a217[_0x33fa('0x90')]['id']}})[_0x33fa('0x27')](handleEntityNotFound(_0x1626f4,null))[_0x33fa('0x27')](function(_0x5c6695){if(_0x5c6695){_0x57ed86[_0x33fa('0x38')]=_[_0x33fa('0x30')](db[_0x33fa('0xaf')][_0x33fa('0xca')]);_0x57ed86[_0x33fa('0x39')]=_[_0x33fa('0x30')](_0x34a217[_0x33fa('0x39')]);_0x57ed86[_0x33fa('0x40')]=_[_0x33fa('0xcb')](_0x57ed86[_0x33fa('0x38')],_0x57ed86[_0x33fa('0x39')]);_0x1c71b8[_0x33fa('0x3a')]=_[_0x33fa('0xcb')](_0x57ed86[_0x33fa('0x38')],qs[_0x33fa('0x3b')](_0x34a217['query'][_0x33fa('0x3b')]));_0x1c71b8[_0x33fa('0x3a')]=_0x1c71b8[_0x33fa('0x3a')][_0x33fa('0x31')]?_0x1c71b8[_0x33fa('0x3a')]:_0x57ed86[_0x33fa('0x38')];if(!_0x34a217[_0x33fa('0x39')][_0x33fa('0x5e')](_0x33fa('0x3c'))){_0x1c71b8[_0x33fa('0x21')]=qs['limit'](_0x34a217[_0x33fa('0x39')]['limit']);_0x1c71b8[_0x33fa('0x3d')]=qs[_0x33fa('0x3d')](_0x34a217[_0x33fa('0x39')][_0x33fa('0x3d')]);}_0x1c71b8[_0x33fa('0x3e')]=qs[_0x33fa('0x3f')](_0x34a217[_0x33fa('0x39')][_0x33fa('0x3f')]);_0x1c71b8[_0x33fa('0x48')]=qs['filters'](_[_0x33fa('0x41')](_0x34a217[_0x33fa('0x39')],_0x57ed86[_0x33fa('0x40')]));_0x1c71b8[_0x33fa('0x48')][_0x33fa('0xcf')]=_0x5c6695['id'];if(_0x34a217['query'][_0x33fa('0x5f')]){_0x1c71b8['where']=_['merge'](_0x1c71b8['where'],{'$or':_[_0x33fa('0x51')](_0x1c71b8[_0x33fa('0x3a')],function(_0x537580){var _0x2f376f={};_0x2f376f[_0x537580]={'$like':'%'+_0x34a217[_0x33fa('0x39')][_0x33fa('0x5f')]+'%'};return _0x2f376f;})});}_0x1c71b8=_[_0x33fa('0x99')]({},_0x1c71b8,_0x34a217[_0x33fa('0xcc')]);return db['CmHopperFinal']['count']({'where':_0x1c71b8['where']})[_0x33fa('0x27')](function(_0x1a6a0f){_0x1f2ea6[_0x33fa('0x20')]=_0x1a6a0f;if(_0x34a217[_0x33fa('0x39')]['includeAll']){_0x1c71b8['include']=[{'all':!![]}];}return db[_0x33fa('0xaf')][_0x33fa('0xc0')](_0x1c71b8);})['then'](function(_0x4c8217){_0x1f2ea6[_0x33fa('0xd2')]=_0x4c8217;return _0x1f2ea6;});}})[_0x33fa('0x27')](respondWithFilteredResult(_0x1626f4,_0x1c71b8))[_0x33fa('0x91')](handleError(_0x1626f4,null));};exports['getJscriptySessions']=function(_0x4ba1c6,_0x31cf01,_0x2e9324){var _0x12764b={'raw':!![],'where':{}};var _0x39aa80={};var _0x43dd8f={'count':0x0,'rows':[]};return db['CmContact'][_0x33fa('0x34')]({'where':{'id':_0x4ba1c6[_0x33fa('0x90')]['id']}})[_0x33fa('0x27')](handleEntityNotFound(_0x31cf01,null))[_0x33fa('0x27')](function(_0x125aab){if(_0x125aab){_0x39aa80[_0x33fa('0x38')]=_['keys'](db['JscriptySessionReport'][_0x33fa('0xca')]);_0x39aa80[_0x33fa('0x39')]=_[_0x33fa('0x30')](_0x4ba1c6['query']);_0x39aa80[_0x33fa('0x40')]=_[_0x33fa('0xcb')](_0x39aa80[_0x33fa('0x38')],_0x39aa80[_0x33fa('0x39')]);_0x12764b[_0x33fa('0x3a')]=_['intersection'](_0x39aa80[_0x33fa('0x38')],qs[_0x33fa('0x3b')](_0x4ba1c6['query'][_0x33fa('0x3b')]));_0x12764b[_0x33fa('0x3a')]=_0x12764b[_0x33fa('0x3a')]['length']?_0x12764b[_0x33fa('0x3a')]:_0x39aa80[_0x33fa('0x38')];if(!_0x4ba1c6['query'][_0x33fa('0x5e')](_0x33fa('0x3c'))){_0x12764b[_0x33fa('0x21')]=qs[_0x33fa('0x21')](_0x4ba1c6['query'][_0x33fa('0x21')]);_0x12764b[_0x33fa('0x3d')]=qs[_0x33fa('0x3d')](_0x4ba1c6[_0x33fa('0x39')][_0x33fa('0x3d')]);}_0x12764b['order']=qs['sort'](_0x4ba1c6[_0x33fa('0x39')][_0x33fa('0x3f')]);_0x12764b[_0x33fa('0x48')]=qs[_0x33fa('0x40')](_[_0x33fa('0x41')](_0x4ba1c6[_0x33fa('0x39')],_0x39aa80[_0x33fa('0x40')]));_0x12764b['where'][_0x33fa('0xcf')]=_0x125aab['id'];if(_0x4ba1c6[_0x33fa('0x39')][_0x33fa('0x5f')]){_0x12764b[_0x33fa('0x48')]=_[_0x33fa('0x99')](_0x12764b['where'],{'$or':_[_0x33fa('0x51')](_0x12764b[_0x33fa('0x3a')],function(_0x3939e2){var _0x19c0f9={};_0x19c0f9[_0x3939e2]={'$like':'%'+_0x4ba1c6[_0x33fa('0x39')]['filter']+'%'};return _0x19c0f9;})});}_0x12764b=_[_0x33fa('0x99')]({},_0x12764b,_0x4ba1c6[_0x33fa('0xcc')]);return db[_0x33fa('0xb7')][_0x33fa('0x20')]({'where':_0x12764b[_0x33fa('0x48')]})['then'](function(_0x487a0a){_0x43dd8f[_0x33fa('0x20')]=_0x487a0a;if(_0x4ba1c6[_0x33fa('0x39')]['includeAll']){_0x12764b[_0x33fa('0xd1')]=[{'all':!![]}];}return db[_0x33fa('0xb7')][_0x33fa('0xc0')](_0x12764b);})['then'](function(_0x4665ea){_0x43dd8f[_0x33fa('0xd2')]=_0x4665ea;return _0x43dd8f;});}})[_0x33fa('0x27')](respondWithFilteredResult(_0x31cf01,_0x12764b))['catch'](handleError(_0x31cf01,null));};exports[_0x33fa('0xd5')]=function(_0x55c422,_0x5b7817,_0x3d385b){try{if(!_0x55c422[_0x33fa('0x9a')][_0x33fa('0x63')]){throw new Error(_0x33fa('0xd6'));}if(!_0x55c422['body']['binding_keys']){throw new Error(_0x33fa('0xd7'));}if(!_0x55c422[_0x33fa('0x9a')][_0x33fa('0xd8')]){throw new Error(_0x33fa('0xd9'));}if(!_0x55c422['body'][_0x33fa('0xda')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x832c2e=_0x55c422[_0x33fa('0x9a')][_0x33fa('0xdb')][_0x33fa('0x50')](',');var _0x2a45c8=_0x55c422[_0x33fa('0x9a')][_0x33fa('0xd8')][_0x33fa('0x50')](',');if(!_0x832c2e[_0x33fa('0x31')]||!_0x2a45c8[_0x33fa('0x31')]||_0x832c2e[_0x33fa('0x31')]!==_0x2a45c8[_0x33fa('0x31')]){throw new Error(_0x33fa('0xdc'));}_0x55c422[_0x33fa('0x9a')][_0x33fa('0x3b')]=_['zipObject'](_0x832c2e,_0x2a45c8);if(!_0x55c422[_0x33fa('0x9a')][_0x33fa('0x3b')][_0x33fa('0xdd')]){throw new Error(_0x33fa('0xde'));}if(!_0x55c422[_0x33fa('0x9a')][_0x33fa('0x3b')][_0x33fa('0xdf')]){throw new Error(_0x33fa('0xe0'));}var _0x2469d5=path['join'](config[_0x33fa('0xe1')],_0x33fa('0xe2'),_0x55c422[_0x33fa('0xe3')]['filename']);fs['chmodSync'](_0x2469d5,parseInt(_0x33fa('0xe4'),0x8));var _0x42fe80=require(_0x33fa('0xe5'))[_0x33fa('0xe6')](path['join'](__dirname,_0x33fa('0xe7')),[_0x2469d5,_0x55c422[_0x33fa('0x9a')][_0x33fa('0xdb')],_0x55c422['body']['binding_values'],_0x55c422[_0x33fa('0x9a')][_0x33fa('0x63')],_0x55c422[_0x33fa('0x9a')][_0x33fa('0xe8')],_0x55c422[_0x33fa('0x9a')]['duplicates'],_0x55c422[_0x33fa('0x9a')]['socket_timestamp']]);return _0x5b7817[_0x33fa('0x1e')](0xc8)[_0x33fa('0x1f')]({'message':_0x33fa('0xe9'),'pid':_0x42fe80[_0x33fa('0xea')]});}catch(_0x54d1ed){return _0x5b7817['status'](0x1f4)[_0x33fa('0x2c')](_0x54d1ed);}};exports['upload']=function(_0x4a3e93,_0x4e1337,_0x44648a){var _0x12be5d=fs[_0x33fa('0xeb')](_0x4a3e93[_0x33fa('0xe3')][_0x33fa('0x5')]);Papa[_0x33fa('0xec')](_0x12be5d,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x2582d0){return _0x4e1337[_0x33fa('0x1e')](0xc8)['json']({'file':_0x4a3e93[_0x33fa('0xe3')],'fields':_0x2582d0[_0x33fa('0xed')][_0x33fa('0x3b')]});}});};exports[_0x33fa('0xee')]=function(_0x543944,_0x10912a,_0x483251){return db[_0x33fa('0x7a')][_0x33fa('0xc0')]({'raw':!![],'attributes':['id'],'where':{'role':_0x33fa('0x78')}})['then'](function(_0x11d525){var _0x4ce0aa=![];if(!_0x543944[_0x33fa('0x9a')]['ListId']){throw new Error('No\x20ListId\x20specified');}if(!_0x543944['body'][_0x33fa('0xef')][_0x33fa('0xdd')]){throw new Error(_0x33fa('0xde'));}if(!_0x543944[_0x33fa('0x9a')][_0x33fa('0xef')][_0x33fa('0xdf')]){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x543944[_0x33fa('0x9a')][_0x33fa('0xda')]){throw new Error(_0x33fa('0xf0'));}var _0x1639b7=require('child_process')[_0x33fa('0xe6')](path[_0x33fa('0x9d')](__dirname,'../../components/import/cm/csv2'),[_0x543944['params']['id'],JSON[_0x33fa('0xf1')](_0x543944[_0x33fa('0x9a')]),JSON[_0x33fa('0xf1')](_0x11d525)]);_0x1639b7['on'](_0x33fa('0xf2'),function(_0x118b57){_0x4ce0aa=!![];return _0x10912a[_0x33fa('0x1e')](0xc8)[_0x33fa('0x1f')]({'message':_0x33fa('0xf3'),'pid':_0x1639b7['pid']});});_0x1639b7['on']('exit',function(_0x1735d4){if(_0x1735d4&&!_0x4ce0aa){return _0x10912a['status'](0x1f4)[_0x33fa('0x1f')]({'message':_0x33fa('0xf4'),'pid':_0x1639b7['pid']});}});})[_0x33fa('0x91')](handleError(_0x10912a,null));};exports[_0x33fa('0xf5')]=function(_0xbdca72,_0x52855d){var _0x350cf2=[_0x33fa('0xf6'),_0x33fa('0xf7'),_0x33fa('0xf8'),_0x33fa('0xf9'),_0x33fa('0xfa'),'whatsapp','voice'];var _0xdf06f1={'offset':0x0,'order':qs[_0x33fa('0x3f')](_0x33fa('0xfb'))},_0x4c7620={'count':0x0,'rows':[]};Promise[_0x33fa('0x77')]()[_0x33fa('0x27')](function(){if(_0xbdca72['query']['channel']){if(!_['includes'](_0x350cf2,_0xbdca72[_0x33fa('0x39')][_0x33fa('0xfc')][_0x33fa('0xfd')]())){throw new Error('Invalid\x20channel');}_0x350cf2=[_0xbdca72[_0x33fa('0x39')]['channel'][_0x33fa('0xfd')]()];}if(_0xbdca72[_0x33fa('0x39')][_0x33fa('0xfe')]){try{var _0x2c02d3=JSON[_0x33fa('0xec')](_0xbdca72[_0x33fa('0x39')][_0x33fa('0xfe')]);if(!moment(_0x2c02d3[_0x33fa('0x9f')])[_0x33fa('0xff')]()){throw new Error(_0x33fa('0x100'));}if(!moment(_0x2c02d3['to'])[_0x33fa('0xff')]()){throw new Error('Invalid\x20date\x20for\x20range\x20to\x20filter');}}catch(_0x42de69){throw new Error(_0x33fa('0x101'));}}if(!_0xbdca72[_0x33fa('0x39')]['hasOwnProperty'](_0x33fa('0x3c'))){_0xdf06f1['limit']=qs[_0x33fa('0x21')](_0xbdca72['query'][_0x33fa('0x21')]||0xa);_0xdf06f1[_0x33fa('0x3d')]=qs['offset'](_0xbdca72[_0x33fa('0x39')][_0x33fa('0x3d')]);}var _0xaf425f=_0x350cf2[_0x33fa('0x51')](function(_0xd6cd28){if(_0xd6cd28===_0x33fa('0x102')){var _0x56ecf4={'attributes':['id',_0x33fa('0x103'),_0x33fa('0x37'),_0x33fa('0x104'),_0x33fa('0x105'),_0x33fa('0x106'),_0x33fa('0x107'),_0x33fa('0x108'),_0x33fa('0x109'),_0x33fa('0x10a'),_0x33fa('0x10b'),_0x33fa('0x10c'),_0x33fa('0x10d'),_0x33fa('0x10e'),_0x33fa('0x10f')],'where':{'ContactId':_0xbdca72[_0x33fa('0x90')]['id']},'include':[{'model':db['User'],'as':_0x33fa('0x7a'),'attributes':['id',_0x33fa('0x2b'),'fullname',_0x33fa('0x96')]}],'order':[[_0x33fa('0x10b'),_0x33fa('0x74')]]};if(_0xbdca72[_0x33fa('0x39')]['range']){_0x56ecf4[_0x33fa('0x48')]['createdAt']={'$gte':_0x2c02d3[_0x33fa('0x9f')],'$lte':_0x2c02d3['to']};}return db[_0x33fa('0xb1')][_0x33fa('0x110')](_0x56ecf4)[_0x33fa('0x27')](function(_0x18af6e){_0x4c7620['count']+=_0x18af6e[_0x33fa('0x20')];return _['map'](_0x18af6e['rows'],function(_0xcb777){var _0x335c60=_0xcb777['get']({'plain':!![]});_0x335c60['channel']=_0xd6cd28;if(_0x335c60[_0x33fa('0x7a')]){_0x335c60[_0x33fa('0x7a')]={'id':_0x335c60['User']['id'],'name':_0x335c60[_0x33fa('0x7a')][_0x33fa('0x2b')],'fullname':_0x335c60[_0x33fa('0x7a')][_0x33fa('0x111')],'alias':_0x335c60['User'][_0x33fa('0x96')]};}return _0x335c60;});});}else{var _0x59c7f1=_[_0x33fa('0x112')](_0xd6cd28)+(_0xd6cd28===_0x33fa('0xf7')?_0x33fa('0x113'):_0x33fa('0x114'));var _0x1c43ed={'attributes':['id',_0x33fa('0x115'),_0x33fa('0x116'),_0x33fa('0x10b'),'note',_0x33fa('0x117'),_0x33fa('0x118'),_0x33fa('0x119'),'UserId',_0x59c7f1+'Id'],'where':{'ContactId':_0xbdca72['params']['id']},'include':[{'model':db[_0x59c7f1],'as':'Account','attributes':['id',_0x33fa('0x2b'),'key']},{'model':db[_0x33fa('0x7a')],'as':_0x33fa('0x11a'),'attributes':['id',_0x33fa('0x2b'),'fullname']},{'model':db[_0x33fa('0x4f')],'as':_0x33fa('0x8e'),'attributes':['id',_0x33fa('0x2b'),'color'],'through':{'attributes':[]}}],'order':[[_0x33fa('0x10b'),_0x33fa('0x74')]]};if(_0xbdca72[_0x33fa('0x39')][_0x33fa('0xfe')]){_0x1c43ed[_0x33fa('0x48')]['createdAt']={'$gte':_0x2c02d3[_0x33fa('0x9f')],'$lte':_0x2c02d3['to']};}switch(_0xd6cd28){case _0x33fa('0xf7'):_0x1c43ed[_0x33fa('0x3a')][_0x33fa('0x8f')](_0x33fa('0x11b'),_0x33fa('0x11c'),_0x33fa('0x11d'),_0x33fa('0x11e'),_0x33fa('0x11f'),_0x33fa('0x120'),_0x33fa('0x121'),_0x33fa('0x122'),_0x33fa('0x123'));break;case _0x33fa('0xf6'):_0x1c43ed[_0x33fa('0x3a')][_0x33fa('0x8f')]('subject',_0x33fa('0x124'));break;case'openchannel':_0x1c43ed[_0x33fa('0x3a')][_0x33fa('0x8f')](_0x33fa('0x125'),_0x33fa('0x126'));break;}return db[_[_0x33fa('0x112')](_0xd6cd28)+_0x33fa('0x127')]['findAndCountAll'](_0x1c43ed)[_0x33fa('0x27')](function(_0x3dcd37){_0x4c7620[_0x33fa('0x20')]+=_0x3dcd37[_0x33fa('0x20')];return _[_0x33fa('0x51')](_0x3dcd37[_0x33fa('0xd2')],function(_0x42ef40){var _0x25e59f=_0x42ef40[_0x33fa('0x9b')]({'plain':!![]});_0x25e59f[_0x33fa('0xfc')]=_0xd6cd28;if(_0x25e59f[_0x33fa('0x11a')]){_0x25e59f[_0x33fa('0x11a')]={'id':_0x25e59f[_0x33fa('0x11a')]['id'],'name':_0x25e59f[_0x33fa('0x11a')][_0x33fa('0x2b')],'fullname':_0x25e59f[_0x33fa('0x11a')]['fullname']};}return _0x25e59f;});});}});return Promise[_0x33fa('0x35')](_0xaf425f);})[_0x33fa('0x27')](function(_0x58355d){return _(_0x58355d)[_0x33fa('0x128')]()[_0x33fa('0x129')](_0x33fa('0x10b'))['reverse']()[_0x33fa('0x57')]();})[_0x33fa('0x27')](function(_0x48f946){_0x4c7620[_0x33fa('0xd2')]=_0xdf06f1[_0x33fa('0x21')]?_0x48f946[_0x33fa('0x12a')](_0xdf06f1[_0x33fa('0x3d')],_0xdf06f1[_0x33fa('0x3d')]+_0xdf06f1[_0x33fa('0x21')]):_0x48f946;return _0x4c7620;})[_0x33fa('0x27')](respondWithFilteredResult(_0x52855d,_0xdf06f1))[_0x33fa('0x91')](handleError(_0x52855d,null));};
\ No newline at end of file
+var _0xe479=['and','uc.UserId\x20=\x20?','datetime','castTo','DATE','buildExpression','type','text','start','filter','isNil','Contact','isEmpty','ListId','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','tag','isArray','replace','split','getFullTextValue','isNumeric','c.id\x20LIKE\x20?','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','c.email\x20LIKE\x20?','Sequelize','QueryTypes','SELECT','clone','c.id','DESC','having','resolve','user','role','agent','some','getLists','c.ListId\x20IS\x20NULL','c.ListId\x20IN\x20?','sequelize','toString','keyBy','merge','c.firstName','c.lastName','c.phone','c.email','c.ListId','c.createdAt','c.deletedAt','c.CompanyId','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','Tags','push','rows','params','catch','describe','tags','displayName','findAll','columnName','alias','custom','values','body','get','mergeWith','join','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappMessage','WhatsappQueueReport','duplicates','$or','findOrCreate','spread','error','show','Tag','color','omit','format','cf_%d','$and','pickBy','table','id\x20=\x20?','toParam','phone','getTags','setTags','ids','getHoppers','rawAttributes','ContactId','options','includeAll','include','getHopperHistories','nolimit','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','Incorrect\x20binding\x20parameters\x20passed!','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','server/files/tmp','file','chmodSync','0777','child_process','fork','../../components/import/cm/csv','CompanyId','socket_timestamp','File\x20uploaded\x20correctly!','pid','upload','createReadStream','parse','meta','import','binding','stringify','message','exit','error\x20child\x20process','chat','sms','openchannel','fax','-createdAt','channel','includes','toLowerCase','range','Invalid\x20date\x20for\x20range\x20from\x20filter','isValid','Invalid\x20createdAt\x20filter','voice','uniqueid','source','destination','callerid','starttime','endtime','note','userDisposition','userThirdDisposition','UserId','fullname','createdAt','findAndCountAll','startCase','Website','Account','closed','closedAt','disposition','secondDisposition','thirdDisposition','key','browserName','customerIp','customerPort','deviceModel','osName','ratingMessage','ratingType','ratingValue','threadId','Interaction','Owner','all','flatten','sortBy','reverse','slice','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','redis','defaults','socket.io-emitter','register','sendStatus','status','end','json','offset','undefined','count','limit','set','Content-Range','apply','save','update','then','destroy','stack','name','send','index','CmContact','keys','length','startsWith','cf_','CmCustomField','findOne','trimStart','fieldType','query','intersection','model','attributes','fields','hasOwnProperty','order','sort','where','pick','filters','field','from','tools_tags','select','cm_contacts','left_join','uc.CmContactId\x20=\x20c.id','cm_contact_has_tags','ct.CmContactId\x20=\x20c.id','t.id\x20=\x20ct.TagId','c.deletedAt\x20IS\x20NULL','expr','search','parseSearch','sqlOperator','conditions','find','value','map','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User'];(function(_0x220b5f,_0x10f186){var _0x28389e=function(_0x10de49){while(--_0x10de49){_0x220b5f['push'](_0x220b5f['shift']());}};_0x28389e(++_0x10f186);}(_0xe479,0xda));var _0x9e47=function(_0x5114da,_0x26c5a2){_0x5114da=_0x5114da-0x0;var _0x4846dd=_0xe479[_0x5114da];return _0x4846dd;};'use strict';var emlformat=require(_0x9e47('0x0'));var rimraf=require(_0x9e47('0x1'));var zipdir=require(_0x9e47('0x2'));var jsonpatch=require(_0x9e47('0x3'));var rp=require(_0x9e47('0x4'));var moment=require(_0x9e47('0x5'));var BPromise=require('bluebird');var Mustache=require(_0x9e47('0x6'));var util=require('util');var path=require(_0x9e47('0x7'));var sox=require(_0x9e47('0x8'));var csv=require(_0x9e47('0x9'));var ejs=require(_0x9e47('0xa'));var fs=require('fs');var fs_extra=require(_0x9e47('0xb'));var _=require(_0x9e47('0xc'));var squel=require(_0x9e47('0xd'));var crypto=require(_0x9e47('0xe'));var jsforce=require(_0x9e47('0xf'));var deskjs=require(_0x9e47('0x10'));var toCsv=require(_0x9e47('0x9'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0x9e47('0x11'));var authService=require(_0x9e47('0x12'));var qs=require(_0x9e47('0x13'));var as=require(_0x9e47('0x14'));var hardwareService=require(_0x9e47('0x15'));var logger=require(_0x9e47('0x16'))(_0x9e47('0x17'));var utils=require(_0x9e47('0x18'));var config=require(_0x9e47('0x19'));var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];config[_0x9e47('0x1a')]=_[_0x9e47('0x1b')](config[_0x9e47('0x1a')],{'host':'localhost','port':0x18eb});var socket=require(_0x9e47('0x1c'))(new Redis(config['redis']));require('./cmContact.socket')[_0x9e47('0x1d')](socket);function respondWithStatusCode(_0x40bd5f,_0x1ab15c){_0x1ab15c=_0x1ab15c||0xcc;return function(_0x37a504){if(_0x37a504){return _0x40bd5f[_0x9e47('0x1e')](_0x1ab15c);}return _0x40bd5f[_0x9e47('0x1f')](_0x1ab15c)[_0x9e47('0x20')]();};}function respondWithResult(_0x51cb0d,_0x304ae8){_0x304ae8=_0x304ae8||0xc8;return function(_0x58ee57){if(_0x58ee57){return _0x51cb0d[_0x9e47('0x1f')](_0x304ae8)[_0x9e47('0x21')](_0x58ee57);}};}function respondWithFilteredResult(_0x1e1c97,_0x3fb63e){return function(_0x513102){if(_0x513102){var _0x5e9566=typeof _0x3fb63e[_0x9e47('0x22')]===_0x9e47('0x23')&&typeof _0x3fb63e['limit']===_0x9e47('0x23');var _0x5cc766=_0x513102['count'];var _0x532b98=_0x5e9566?0x0:_0x3fb63e[_0x9e47('0x22')];var _0x1b9916=_0x5e9566?_0x513102[_0x9e47('0x24')]:_0x3fb63e['offset']+_0x3fb63e[_0x9e47('0x25')];var _0x38f48a;if(_0x1b9916>=_0x5cc766){_0x1b9916=_0x5cc766;_0x38f48a=0xc8;}else{_0x38f48a=0xce;}_0x1e1c97['status'](_0x38f48a);return _0x1e1c97[_0x9e47('0x26')](_0x9e47('0x27'),_0x532b98+'-'+_0x1b9916+'/'+_0x5cc766)[_0x9e47('0x21')](_0x513102);}return null;};}function patchUpdates(_0x13d537){return function(_0x29be88){try{jsonpatch[_0x9e47('0x28')](_0x29be88,_0x13d537,!![]);}catch(_0x475e17){return BPromise['reject'](_0x475e17);}return _0x29be88[_0x9e47('0x29')]();};}function saveUpdates(_0x17889e,_0x1ec390){return function(_0x278e3c){if(_0x278e3c){return _0x278e3c[_0x9e47('0x2a')](_0x17889e)[_0x9e47('0x2b')](function(_0x189509){return _0x189509;});}return null;};}function removeEntity(_0x3fb02b,_0x4c1aa1){return function(_0x4a824d){if(_0x4a824d){return _0x4a824d[_0x9e47('0x2c')]()[_0x9e47('0x2b')](function(){_0x3fb02b[_0x9e47('0x1f')](0xcc)[_0x9e47('0x20')]();});}};}function handleEntityNotFound(_0xfe038,_0x670679){return function(_0x2ca83a){if(!_0x2ca83a){_0xfe038[_0x9e47('0x1e')](0x194);}return _0x2ca83a;};}function handleError(_0x1dacb1,_0x1b6ebb){_0x1b6ebb=_0x1b6ebb||0x1f4;return function(_0xcfc443){logger['error'](_0xcfc443[_0x9e47('0x2d')]);if(_0xcfc443[_0x9e47('0x2e')]){delete _0xcfc443[_0x9e47('0x2e')];}_0x1dacb1[_0x9e47('0x1f')](_0x1b6ebb)[_0x9e47('0x2f')](_0xcfc443);};}exports[_0x9e47('0x30')]=function(_0xc1499b,_0x52084f){var _0x22f49f={},_0x45f530={},_0x4ffb88={'count':0x0,'rows':[]};return db[_0x9e47('0x31')]['describe']()[_0x9e47('0x2b')](function(_0x4cbd96){var _0x582be0=[];for(var _0x2ee612=0x0;_0x2ee612<Object[_0x9e47('0x32')](_0x4cbd96)[_0x9e47('0x33')];_0x2ee612++){var _0x239b2c=Object[_0x9e47('0x32')](_0x4cbd96)[_0x2ee612];if(_[_0x9e47('0x34')](_0x239b2c,_0x9e47('0x35'))){_0x582be0['push'](db[_0x9e47('0x36')][_0x9e47('0x37')]({'where':{'id':_[_0x9e47('0x38')](_0x239b2c,_0x9e47('0x35'))},'raw':!![]}));}}return BPromise['all'](_0x582be0)[_0x9e47('0x2b')](function(_0x56a459){for(var _0x3ef971=0x0;_0x3ef971<_0x56a459[_0x9e47('0x33')];_0x3ef971++){if(_0x56a459[_0x3ef971]){var _0xf0c046=_0x9e47('0x35')+_0x56a459[_0x3ef971]['id'];var _0x1b8fee=_0x4cbd96[_0xf0c046];_0x1b8fee[_0x9e47('0x39')]=_0x56a459[_0x3ef971]['type'];}}return _0x4cbd96;});})[_0x9e47('0x2b')](function(_0x3c39f9){_0x45f530['model']=_[_0x9e47('0x32')](_0x3c39f9);_0x45f530[_0x9e47('0x3a')]=_[_0x9e47('0x32')](_0xc1499b[_0x9e47('0x3a')]);_0x45f530['filters']=_[_0x9e47('0x3b')](_0x45f530[_0x9e47('0x3c')],_0x45f530[_0x9e47('0x3a')]);_0x22f49f[_0x9e47('0x3d')]=_[_0x9e47('0x3b')](_0x45f530['model'],qs[_0x9e47('0x3e')](_0xc1499b[_0x9e47('0x3a')]['fields']));_0x22f49f['attributes']=_0x22f49f[_0x9e47('0x3d')][_0x9e47('0x33')]?_0x22f49f[_0x9e47('0x3d')]:_0x45f530['model'];if(!_0xc1499b['query'][_0x9e47('0x3f')]('nolimit')){_0x22f49f[_0x9e47('0x25')]=qs[_0x9e47('0x25')](_0xc1499b[_0x9e47('0x3a')][_0x9e47('0x25')]);_0x22f49f[_0x9e47('0x22')]=qs[_0x9e47('0x22')](_0xc1499b[_0x9e47('0x3a')][_0x9e47('0x22')]);}_0x22f49f[_0x9e47('0x40')]=qs['sort'](_0xc1499b[_0x9e47('0x3a')][_0x9e47('0x41')]);_0x22f49f[_0x9e47('0x42')]=qs['filters'](_[_0x9e47('0x43')](_0xc1499b[_0x9e47('0x3a')],_0x45f530[_0x9e47('0x44')]),_0x3c39f9);var _0x58a530=[];var _0x4e7526=squel['select']()[_0x9e47('0x45')]('id')[_0x9e47('0x45')]('name')['field']('color')[_0x9e47('0x46')](_0x9e47('0x47'));var _0x2969aa=squel[_0x9e47('0x48')]()[_0x9e47('0x46')](_0x9e47('0x49'),'c')[_0x9e47('0x4a')]('cm_user_has_contacts','uc',_0x9e47('0x4b'))['left_join'](_0x9e47('0x4c'),'ct',_0x9e47('0x4d'))[_0x9e47('0x4a')](_0x9e47('0x47'),'t',_0x9e47('0x4e'))[_0x9e47('0x42')](_0x9e47('0x4f'));var _0x23bbb3=squel[_0x9e47('0x50')]();var _0x1094c2=[];var _0x380328=squel[_0x9e47('0x50')]();var _0x572d6d;if(_0xc1499b[_0x9e47('0x3a')][_0x9e47('0x51')]){_0x572d6d=as[_0x9e47('0x52')](_0xc1499b[_0x9e47('0x3a')][_0x9e47('0x51')]);var _0xfe1469=_0x572d6d[_0x9e47('0x53')];for(var _0x24a1b5=0x0;_0x24a1b5<_0x572d6d['conditions'][_0x9e47('0x33')];_0x24a1b5++){var _0x2383c9=_0x572d6d[_0x9e47('0x54')][_0x24a1b5];var _0x210acb='c';var _0x304f59=_(_0x3c39f9)['keys']()[_0x9e47('0x55')](function(_0x9c3c7f){return _0x9c3c7f===_0x2383c9[_0x9e47('0x45')];});if(_0x304f59)_0x304f59=_0x3c39f9[_0x2383c9[_0x9e47('0x45')]];if(!_0x304f59){if(_0x2383c9[_0x9e47('0x45')]==='Tag'){var _0x419a29=_0x2383c9[_0x9e47('0x56')]['split'](',')[_0x9e47('0x57')](function(_0x3dee87){return Number(_0x3dee87);});_0x419a29[_0x9e47('0x58')](function(_0x8fde81){_0x380328['or'](_0x9e47('0x59'),'%,'+_0x8fde81+',%');});_0x1094c2=_[_0x9e47('0x5a')](_0x1094c2,_0x419a29);}else if(_0x2383c9[_0x9e47('0x45')]===_0x9e47('0x5b')){_0x23bbb3[_0x9e47('0x5c')](_0x9e47('0x5d'),_0x2383c9[_0x9e47('0x56')]);}}else{if(_0x2383c9[_0x9e47('0x45')]==='dateOfBirth'||_0x304f59[_0x9e47('0x39')]===_0x9e47('0x5e'))_0x2383c9[_0x9e47('0x5f')]=_0x9e47('0x60');var _0x4ff678=as[_0x9e47('0x61')](_0x210acb,_0x304f59[_0x9e47('0x62')],_0x2383c9);_0x23bbb3[_0xfe1469](_0x4ff678[_0x9e47('0x63')],_0x4ff678['value'][_0x9e47('0x64')],_0x4ff678[_0x9e47('0x56')][_0x9e47('0x20')]);}}}else{var _0xb33800=_(Object['keys'](_0xc1499b['query']))[_0x9e47('0x57')](function(_0xbd7ea2){return _0x3c39f9['hasOwnProperty'](_0xbd7ea2)?_0xbd7ea2:undefined;})[_0x9e47('0x65')](function(_0x509fb8){return!_[_0x9e47('0x66')](_0x509fb8);})[_0x9e47('0x56')]();if(_0xc1499b[_0x9e47('0x3a')][_0x9e47('0x67')])_0xb33800['push'](_0x9e47('0x67'));if(!_[_0x9e47('0x68')](_0xb33800)){_0xb33800[_0x9e47('0x58')](function(_0x30a1e4){if(_0x30a1e4===_0x9e47('0x69')){_0x2969aa[_0x9e47('0x42')]('c.ListId\x20IN\x20?',[][_0x9e47('0x6a')](_0xc1499b[_0x9e47('0x3a')][_0x30a1e4]));}else if(_0x30a1e4==='Contact'){var _0x4017a0='%'+_0xc1499b[_0x9e47('0x3a')][_0x30a1e4]+'%';_0x2969aa[_0x9e47('0x42')](_0x9e47('0x6b'),_0x4017a0);}else{_0x2969aa['where']('c.'+_0x30a1e4+_0x9e47('0x6c'),_0xc1499b['query'][_0x30a1e4]);}});}if(_0xc1499b[_0x9e47('0x3a')][_0x9e47('0x6d')]){_0x1094c2=_[_0x9e47('0x6e')](_0xc1499b['query']['tag'])?_0xc1499b[_0x9e47('0x3a')][_0x9e47('0x6d')]:new Array(_0xc1499b[_0x9e47('0x3a')][_0x9e47('0x6d')]);_0x1094c2[_0x9e47('0x58')](function(_0x2317df){_0x380328['or'](_0x9e47('0x59'),'%,'+_0x2317df+',%');});}if(_0xc1499b['query'][_0x9e47('0x65')]){var _0x5379f9=_0xc1499b[_0x9e47('0x3a')][_0x9e47('0x65')][_0x9e47('0x6f')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(_0x5379f9[_0x9e47('0x70')]('\x20')[_0x9e47('0x33')]>0x1){_0x23bbb3['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x9e47('0x71')](_0x5379f9),null);}else{if(qs[_0x9e47('0x72')](_0x5379f9)){_0x23bbb3['or'](_0x9e47('0x73'),_0x5379f9+'%');_0x23bbb3['or'](_0x9e47('0x74'),_0x5379f9+'%');_0x23bbb3['or'](_0x9e47('0x75'),_0x5379f9+'%');_0x23bbb3['or'](_0x9e47('0x76'),_0x5379f9+'%');}else if(qs[_0x9e47('0x77')](_0x5379f9)){_0x23bbb3['or']('c.email\x20LIKE\x20?',_0x5379f9+'%');}else{_0x23bbb3['or'](_0x9e47('0x78'),'%'+_0x5379f9+'%');_0x23bbb3['or'](_0x9e47('0x79'),'%'+_0x5379f9+'%');_0x23bbb3['or'](_0x9e47('0x7a'),'%'+_0x5379f9+'%');}}}}_0x2969aa[_0x9e47('0x42')](_0x23bbb3);_0x2969aa['group']('c.id');var _0x465f92={'type':db[_0x9e47('0x7b')][_0x9e47('0x7c')][_0x9e47('0x7d')],'raw':!![]};var _0x69ff19=_0x2969aa[_0x9e47('0x7e')]()[_0x9e47('0x45')](_0x9e47('0x7f'));if(_0x22f49f['order']){_0x22f49f[_0x9e47('0x40')][_0x9e47('0x58')](function(_0x12a949){_0x2969aa[_0x9e47('0x40')]('c.'+_0x12a949[0x0],_0x12a949[0x1]===_0x9e47('0x80')?![]:!![]);});}if(!_[_0x9e47('0x68')](_0x1094c2)){_0x2969aa[_0x9e47('0x81')](_0x380328);_0x69ff19['where']('t.id\x20IN\x20?',_0x1094c2);}BPromise[_0x9e47('0x82')]()['then'](function(){if(!_0x572d6d)return;if(_0xc1499b[_0x9e47('0x83')][_0x9e47('0x84')]!==_0x9e47('0x85'))return;if(!_[_0x9e47('0x86')](_0x572d6d[_0x9e47('0x54')],[_0x9e47('0x45'),'User'])){return _0xc1499b['user'][_0x9e47('0x87')]({'attributes':['id'],'raw':!![]})[_0x9e47('0x2b')](function(_0x2f9fb8){if(_[_0x9e47('0x68')](_0x2f9fb8)){_0x69ff19['where']('c.ListId\x20IS\x20NULL');_0x2969aa[_0x9e47('0x42')](_0x9e47('0x88'));}else{_0x69ff19[_0x9e47('0x42')](_0x9e47('0x89'),_[_0x9e47('0x57')](_0x2f9fb8,'id'));_0x2969aa['where'](_0x9e47('0x89'),_['map'](_0x2f9fb8,'id'));}});}})[_0x9e47('0x2b')](function(){if(_0xc1499b[_0x9e47('0x83')][_0x9e47('0x84')]===_0x9e47('0x85')&&!_0x572d6d&&!_0xc1499b[_0x9e47('0x3a')][_0x9e47('0x69')])return[];return db[_0x9e47('0x8a')]['query'](_0x69ff19[_0x9e47('0x8b')](),_0x465f92);})[_0x9e47('0x2b')](function(_0x402c26){_0x4ffb88[_0x9e47('0x24')]=_0x402c26[_0x9e47('0x33')];if(_0x4ffb88[_0x9e47('0x24')]===0x0)return[];return db[_0x9e47('0x8a')][_0x9e47('0x3a')](_0x4e7526[_0x9e47('0x8b')](),_0x465f92)['then'](function(_0x1c2a6e){_0x58a530=_[_0x9e47('0x8c')](_0x1c2a6e,'id');_0x465f92=_[_0x9e47('0x8d')](_0x465f92,{'model':db[_0x9e47('0x31')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0xc1499b[_0x9e47('0x3a')][_0x9e47('0x3e')]){_0x22f49f['attributes'][_0x9e47('0x58')](function(_0x14e46c){_0x2969aa[_0x9e47('0x45')]('c.'+_0x14e46c);});}else{_0x2969aa[_0x9e47('0x45')]('c.id');_0x2969aa[_0x9e47('0x45')](_0x9e47('0x8e'));_0x2969aa[_0x9e47('0x45')](_0x9e47('0x8f'));_0x2969aa[_0x9e47('0x45')](_0x9e47('0x90'));_0x2969aa['field']('c.mobile');_0x2969aa[_0x9e47('0x45')]('c.fax');_0x2969aa[_0x9e47('0x45')](_0x9e47('0x91'));_0x2969aa['field'](_0x9e47('0x92'));_0x2969aa['field'](_0x9e47('0x93'));_0x2969aa[_0x9e47('0x45')](_0x9e47('0x94'));_0x2969aa[_0x9e47('0x45')](_0x9e47('0x95'));_0x2969aa[_0x9e47('0x45')](_0x9e47('0x96'),'TagIds');}if(_0x22f49f[_0x9e47('0x25')])_0x2969aa[_0x9e47('0x25')](_0x22f49f[_0x9e47('0x25')]);if(_0x22f49f[_0x9e47('0x22')])_0x2969aa['offset'](_0x22f49f[_0x9e47('0x22')]);return db['sequelize']['query'](_0x2969aa[_0x9e47('0x8b')](),_0x465f92);});})[_0x9e47('0x2b')](function(_0x55efb6){_0x55efb6['forEach'](function(_0x2973d2){if(_0x2973d2[_0x9e47('0x97')]){_0x2973d2[_0x9e47('0x98')]=[];_0x2973d2[_0x9e47('0x97')]['split'](',')[_0x9e47('0x58')](function(_0x5ccda7){_0x2973d2['Tags'][_0x9e47('0x99')](_0x58a530[_0x5ccda7]);});}delete _0x2973d2[_0x9e47('0x97')];});_0x4ffb88[_0x9e47('0x9a')]=_0x55efb6;return _0x4ffb88;})['then'](respondWithFilteredResult(_0x52084f,_0x22f49f));})['catch'](handleError(_0x52084f,null));};exports['destroy']=function(_0x227cec,_0x3f4a06){return db[_0x9e47('0x31')][_0x9e47('0x55')]({'where':{'id':_0x227cec[_0x9e47('0x9b')]['id']}})[_0x9e47('0x2b')](handleEntityNotFound(_0x3f4a06,null))[_0x9e47('0x2b')](removeEntity(_0x3f4a06,null))[_0x9e47('0x9c')](handleError(_0x3f4a06,null));};exports['describe']=function(_0x207f6a,_0x508123){return db[_0x9e47('0x31')][_0x9e47('0x9d')]()[_0x9e47('0x2b')](function(_0xf25280){delete _0xf25280[_0x9e47('0x9e')];for(var _0x1a3015=0x0;_0x1a3015<Object['keys'](_0xf25280)['length'];_0x1a3015++){var _0x32e925=Object[_0x9e47('0x32')](_0xf25280)[_0x1a3015];if(!_[_0x9e47('0x34')](_0x32e925,_0x9e47('0x35'))){_0xf25280[_0x32e925]['columnName']=_0x32e925;_0xf25280[_0x32e925][_0x9e47('0x9f')]=_0x32e925;}}return _0xf25280;})[_0x9e47('0x2b')](function(_0x3bb896){var _0x3fe613={'where':{'$or':[{'ListId':_0x207f6a[_0x9e47('0x3a')]['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField'][_0x9e47('0xa0')](_0x3fe613)['then'](function(_0x4b939b){for(var _0x1177b9=0x0;_0x1177b9<_0x4b939b['length'];_0x1177b9++){var _0x4d94f2='cf_'+_0x4b939b[_0x1177b9]['id'];_0x3bb896[_0x4d94f2][_0x9e47('0xa1')]=_0x4d94f2;_0x3bb896[_0x4d94f2][_0x9e47('0x9f')]=_0x4b939b[_0x1177b9][_0x9e47('0xa2')];_0x3bb896[_0x4d94f2][_0x9e47('0xa3')]={'type':_0x4b939b[_0x1177b9][_0x9e47('0x62')],'values':_0x4b939b[_0x1177b9][_0x9e47('0xa4')]};}Object['keys'](_0x3bb896)[_0x9e47('0x58')](function(_0x23cbb5){if(!_0x3bb896[_0x23cbb5][_0x9e47('0x3f')](_0x9e47('0xa1'))){delete _0x3bb896[_0x23cbb5];}});return _0x3bb896;});})[_0x9e47('0x2b')](respondWithResult(_0x508123,null))[_0x9e47('0x9c')](handleError(_0x508123,null));};exports[_0x9e47('0x8d')]=function(_0x5e1dbb,_0x4e07fc){var _0x5222e5;var _0x452bab;var _0xe8f06d;if(_0x5e1dbb[_0x9e47('0xa5')]['id']){delete _0x5e1dbb[_0x9e47('0xa5')]['id'];}return db[_0x9e47('0x31')]['findAll']({'where':{'id':[_0x5e1dbb[_0x9e47('0xa5')]['to'],_0x5e1dbb[_0x9e47('0xa5')][_0x9e47('0x46')]]}})[_0x9e47('0x2b')](function(_0x3d4d68){if(_0x3d4d68){if(_0x3d4d68['length']!==0x2){return null;}_0x3d4d68[0x0]=_0x3d4d68[0x0]['get']({'plain':!![]});_0x3d4d68[0x1]=_0x3d4d68[0x1][_0x9e47('0xa6')]({'plain':!![]});delete _0x3d4d68[0x0]['id'];delete _0x3d4d68[0x1]['id'];return _[_0x9e47('0xa7')](_0x3d4d68[0x0],_0x3d4d68[0x1],function(_0x45851e,_0x23bead){if(Array[_0x9e47('0x6e')](_0x23bead)&&!_0x23bead[_0x9e47('0x33')]){return _0x45851e;}else if(!_0x23bead){return _0x45851e;}});}})[_0x9e47('0x2b')](handleEntityNotFound(_0x4e07fc,null))['then'](function(_0x56f9cd){if(_0x56f9cd){if(_0x56f9cd['tags']&&_['isArray'](_0x56f9cd['tags'])){_0x56f9cd[_0x9e47('0x9e')]=_0x56f9cd[_0x9e47('0x9e')][_0x9e47('0xa8')]();}logger[_0x9e47('0xa9')](_0x9e47('0xaa'),_0x5e1dbb[_0x9e47('0xa5')]['to'],_0x5e1dbb[_0x9e47('0xa5')]['from']);return db[_0x9e47('0xab')]['destroy']({'where':{'ContactId':[_0x5e1dbb['body']['to'],_0x5e1dbb[_0x9e47('0xa5')][_0x9e47('0x46')]]}})[_0x9e47('0x2b')](function(_0x9982d1){logger['info'](_0x9e47('0xac'),_0x9982d1);return db[_0x9e47('0xad')][_0x9e47('0x2c')]({'where':{'ContactId':[_0x5e1dbb['body']['to'],_0x5e1dbb[_0x9e47('0xa5')][_0x9e47('0x46')]]}})['then'](function(_0x19d87c){logger[_0x9e47('0xa9')]('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x19d87c);return db[_0x9e47('0x31')][_0x9e47('0xae')](_0x56f9cd);});});}})[_0x9e47('0x2b')](function(_0x44bcb6){if(_0x44bcb6){_0x5222e5=_0x44bcb6;_0x452bab={'ContactId':_0x5222e5['id']};_0xe8f06d={'where':{'ContactId':[_0x5e1dbb[_0x9e47('0xa5')]['to'],_0x5e1dbb['body'][_0x9e47('0x46')]]}};return db[_0x9e47('0xaf')][_0x9e47('0x2a')](_0x452bab,_0xe8f06d);}})[_0x9e47('0x2b')](function(){if(_0x5222e5){return db[_0x9e47('0xb0')][_0x9e47('0x2a')](_0x452bab,_0xe8f06d);}})['then'](function(){if(_0x5222e5){return db[_0x9e47('0xb1')][_0x9e47('0x2a')](_0x452bab,_0xe8f06d);}})[_0x9e47('0x2b')](function(){if(_0x5222e5){return db[_0x9e47('0xb2')][_0x9e47('0x2a')](_0x452bab,_0xe8f06d);}})['then'](function(){if(_0x5222e5){return db['MailMessage'][_0x9e47('0x2a')](_0x452bab,_0xe8f06d);}})[_0x9e47('0x2b')](function(){if(_0x5222e5){return db[_0x9e47('0xb2')]['update'](_0x452bab,_0xe8f06d);}})[_0x9e47('0x2b')](function(){if(_0x5222e5){return db[_0x9e47('0xb3')][_0x9e47('0x2a')](_0x452bab,_0xe8f06d);}})[_0x9e47('0x2b')](function(){if(_0x5222e5){return db[_0x9e47('0xb4')][_0x9e47('0x2a')](_0x452bab,_0xe8f06d);}})[_0x9e47('0x2b')](function(){if(_0x5222e5){return db['SmsMessage'][_0x9e47('0x2a')](_0x452bab,_0xe8f06d);}})['then'](function(){if(_0x5222e5){return db[_0x9e47('0xb5')]['update'](_0x452bab,_0xe8f06d);}})[_0x9e47('0x2b')](function(){if(_0x5222e5){return db[_0x9e47('0xb6')][_0x9e47('0x2a')](_0x452bab,_0xe8f06d);}})[_0x9e47('0x2b')](function(){if(_0x5222e5){return db[_0x9e47('0xb7')][_0x9e47('0x2a')](_0x452bab,_0xe8f06d);}})[_0x9e47('0x2b')](function(){if(_0x5222e5){return db[_0x9e47('0xb8')]['update'](_0x452bab,_0xe8f06d);}})[_0x9e47('0x2b')](function(){if(_0x5222e5){return db[_0x9e47('0xb9')][_0x9e47('0x2a')](_0x452bab,_0xe8f06d);}})[_0x9e47('0x2b')](function(){if(_0x5222e5){return db[_0x9e47('0xba')][_0x9e47('0x2a')](_0x452bab,_0xe8f06d);}})['then'](function(){if(_0x5222e5){return db[_0x9e47('0xbb')]['update'](_0x452bab,_0xe8f06d);}})[_0x9e47('0x2b')](function(){if(_0x5222e5){return db[_0x9e47('0xbc')][_0x9e47('0x2a')](_0x452bab,_0xe8f06d);}})[_0x9e47('0x2b')](function(){if(_0x5222e5){return db[_0x9e47('0xbd')][_0x9e47('0x2a')](_0x452bab,_0xe8f06d);}})[_0x9e47('0x2b')](function(){if(_0x5222e5){return db[_0x9e47('0xbe')][_0x9e47('0x2a')](_0x452bab,_0xe8f06d);}})[_0x9e47('0x2b')](function(){if(_0x5222e5){return db[_0x9e47('0xbf')]['update'](_0x452bab,_0xe8f06d);}})['then'](function(){if(_0x5222e5){return db[_0x9e47('0xc0')]['update'](_0x452bab,_0xe8f06d);}})['then'](function(){if(_0x5222e5){return db[_0x9e47('0xc1')]['update'](_0x452bab,_0xe8f06d);}})[_0x9e47('0x2b')](function(){if(_0x5222e5){return db[_0x9e47('0xc2')][_0x9e47('0x2a')](_0x452bab,_0xe8f06d);}})[_0x9e47('0x2b')](function(){if(_0x5222e5){return db[_0x9e47('0xc3')][_0x9e47('0x2a')](_0x452bab,_0xe8f06d);}})[_0x9e47('0x2b')](function(){if(_0x5222e5){return db[_0x9e47('0xc4')][_0x9e47('0x2a')](_0x452bab,_0xe8f06d);}})['then'](function(){if(_0x5222e5){return db[_0x9e47('0xc5')]['update'](_0x452bab,_0xe8f06d);}})[_0x9e47('0x2b')](function(){if(_0x5222e5){return db[_0x9e47('0x31')]['destroy']({'where':{'id':[_0x5e1dbb['body']['to'],_0x5e1dbb[_0x9e47('0xa5')][_0x9e47('0x46')]]}});}})['then'](function(){if(_0x5222e5){return _0x5222e5;}})['then'](respondWithResult(_0x4e07fc,null))[_0x9e47('0x9c')](handleError(_0x4e07fc,null));};exports[_0x9e47('0xae')]=function(_0x58b510,_0x5d463b){return db['CmContact'][_0x9e47('0x9d')]()['then'](function(_0x4af4ba){if(_0x58b510[_0x9e47('0xa5')]['tags']&&_[_0x9e47('0x6e')](_0x58b510[_0x9e47('0xa5')]['tags'])){if(_0x58b510[_0x9e47('0xa5')]['tags'][_0x9e47('0x33')]){_0x58b510[_0x9e47('0xa5')][_0x9e47('0x9e')]=_0x58b510[_0x9e47('0xa5')][_0x9e47('0x9e')][_0x9e47('0xa8')](';')+';';}else{_0x58b510[_0x9e47('0xa5')][_0x9e47('0x9e')]=null;}}else{_0x58b510[_0x9e47('0xa5')][_0x9e47('0x9e')]=null;}return db[_0x9e47('0x31')][_0x9e47('0xae')](_0x58b510[_0x9e47('0xa5')],{'fields':_['keys'](_0x4af4ba),'raw':!![]});})['then'](respondWithResult(_0x5d463b,0xc9))[_0x9e47('0x9c')](handleError(_0x5d463b,null));};exports['bulkCreate']=function(_0x3f42da,_0x2bb95f){var _0x149bdd=[];var _0x13df0d=0x0;var _0x425695=0x0;var _0x22ffba=0x0;return db[_0x9e47('0x31')][_0x9e47('0x9d')]()[_0x9e47('0x2b')](function(_0x3b1b50){return BPromise['each'](_0x3f42da[_0x9e47('0xa5')],function(_0x258f24){var _0x2d7ce9={'where':{'$or':[]},'defaults':_0x258f24,'fields':_[_0x9e47('0x32')](_0x3b1b50),'raw':!![]};if(_0x258f24[_0x9e47('0xc6')]){for(var _0x415181=0x0;_0x415181<_0x258f24[_0x9e47('0xc6')][_0x9e47('0x33')];_0x415181++){var _0x40f1d1={};_0x40f1d1[_0x258f24[_0x9e47('0xc6')][_0x415181]]=_0x258f24[_0x258f24['duplicates'][_0x415181]];_0x2d7ce9[_0x9e47('0x42')][_0x9e47('0xc7')][_0x9e47('0x99')](_0x40f1d1);}_0x2d7ce9[_0x9e47('0x42')][_0x9e47('0x69')]=_0x258f24[_0x9e47('0x69')];}return db[_0x9e47('0x31')][_0x9e47('0xc8')](_0x2d7ce9)[_0x9e47('0xc9')](function(_0x19ea80,_0x256780){if(_0x256780){_0x13df0d++;}else{_0x22ffba++;}})['catch'](function(_0x18d41d){console[_0x9e47('0xca')](_0x18d41d);_0x425695++;});});})[_0x9e47('0x2b')](function(_0x55740e){if(_0x55740e){return{'success':_0x13df0d,'failure':_0x425695,'duplicates':_0x22ffba};}})[_0x9e47('0x2b')](respondWithResult(_0x2bb95f,0xc9))[_0x9e47('0x9c')](handleError(_0x2bb95f,null));};exports[_0x9e47('0xcb')]=function(_0x49b414,_0x577c36,_0x20cdca){var _0xa1d190;return db[_0x9e47('0x31')][_0x9e47('0x9d')]()[_0x9e47('0x2b')](function(_0xde9503){return db[_0x9e47('0x31')][_0x9e47('0x55')]({'where':{'id':_0x49b414['params']['id']},'include':[{'model':db[_0x9e47('0xcc')],'as':_0x9e47('0x98'),'attributes':['id',_0x9e47('0x2e'),_0x9e47('0xcd')],'required':_0x49b414[_0x9e47('0x3a')]['tag']?!![]:![]}],'attributes':_[_0x9e47('0x32')](_0xde9503)});})[_0x9e47('0x2b')](function(_0x412fbf){_0xa1d190=_0x412fbf[_0x9e47('0xa6')]({'plain':!![]});var _0x50c16f={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x412fbf&&_0x412fbf[_0x9e47('0x69')]){if(_0x412fbf[_0x9e47('0x69')]){_0x50c16f['where']['$and'][_0x9e47('0x99')]({'ListId':{'$ne':_0x412fbf[_0x9e47('0x69')]}});}}return db[_0x9e47('0x36')][_0x9e47('0xa0')](_0x50c16f);})['then'](function(_0x4e65fc){return _[_0x9e47('0xce')](_0xa1d190,_[_0x9e47('0x57')](_0x4e65fc,function(_0x463a60){return util[_0x9e47('0xcf')](_0x9e47('0xd0'),_0x463a60['id']);}));})['then'](handleEntityNotFound(_0x577c36,null))['then'](respondWithResult(_0x577c36,null))[_0x9e47('0x9c')](handleError(_0x577c36,null));};exports['update']=function(_0x220e42,_0x523083){var _0x40af19;if(_0x220e42[_0x9e47('0xa5')]['id']){delete _0x220e42[_0x9e47('0xa5')]['id'];}return db['CmContact']['find']({'where':{'id':_0x220e42[_0x9e47('0x9b')]['id']}})[_0x9e47('0x2b')](handleEntityNotFound(_0x523083,null))['then'](saveUpdates(_0x220e42[_0x9e47('0xa5')],null))[_0x9e47('0x2b')](function(_0x31923d){_0x40af19=_0x31923d;var _0x212a29={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x31923d&&_0x31923d['ListId']){if(_0x31923d[_0x9e47('0x69')]){_0x212a29[_0x9e47('0x42')][_0x9e47('0xd1')]['push']({'ListId':{'$ne':_0x31923d[_0x9e47('0x69')]}});}}return db[_0x9e47('0x36')][_0x9e47('0xa0')](_0x212a29);})[_0x9e47('0x2b')](function(_0x58cf70){if(_0x58cf70){return _[_0x9e47('0xce')](_[_0x9e47('0xd2')](_0x220e42[_0x9e47('0xa5')],function(_0x5db943,_0x5c3ff4){return _[_0x9e47('0x34')](_0x5c3ff4,_0x9e47('0x35'));}),_[_0x9e47('0x57')](_0x58cf70,function(_0x384959){return util['format'](_0x9e47('0xd0'),_0x384959['id']);}));}})['then'](function(_0xdf5faf){if(_0xdf5faf&&!_[_0x9e47('0x68')](_0xdf5faf)){var _0x2fe260=squel[_0x9e47('0x2a')]()[_0x9e47('0xd3')](_0x9e47('0x49'))['setFields'](_0xdf5faf)['where'](_0x9e47('0xd4'),_0x220e42[_0x9e47('0x9b')]['id'])[_0x9e47('0xd5')]();return db[_0x9e47('0x8a')]['query'](_0x2fe260[_0x9e47('0x63')],{'replacements':_0x2fe260[_0x9e47('0xa4')]});}})[_0x9e47('0x2b')](function(){if(_0x220e42[_0x9e47('0xa5')][_0x9e47('0xd6')]&&_0x40af19){return db[_0x9e47('0xab')][_0x9e47('0x2a')]({'phone':_0x220e42[_0x9e47('0xa5')][_0x9e47('0xd6')]},{'where':{'ContactId':_0x40af19['id']}});}})['then'](function(){return _0x40af19;})['then'](respondWithResult(_0x523083,null))[_0x9e47('0x9c')](handleError(_0x523083,null));};exports[_0x9e47('0xd7')]=function(_0x3c3699,_0x58ce6d,_0x46c550){var _0x4b1290={};var _0x1270f1={};var _0x57141a;var _0x3c8fa3;return db[_0x9e47('0x31')][_0x9e47('0x37')]({'where':{'id':_0x3c3699['params']['id']}})[_0x9e47('0x2b')](handleEntityNotFound(_0x58ce6d,null))[_0x9e47('0x2b')](function(_0x1b818d){if(_0x1b818d){_0x57141a=_0x1b818d;_0x1270f1[_0x9e47('0x3c')]=_['keys'](db[_0x9e47('0xcc')]['rawAttributes']);_0x1270f1[_0x9e47('0x3a')]=_[_0x9e47('0x32')](_0x3c3699[_0x9e47('0x3a')]);_0x1270f1[_0x9e47('0x44')]=_[_0x9e47('0x3b')](_0x1270f1[_0x9e47('0x3c')],_0x1270f1['query']);_0x4b1290['attributes']=_[_0x9e47('0x3b')](_0x1270f1[_0x9e47('0x3c')],qs[_0x9e47('0x3e')](_0x3c3699[_0x9e47('0x3a')][_0x9e47('0x3e')]));_0x4b1290[_0x9e47('0x3d')]=_0x4b1290['attributes']['length']?_0x4b1290[_0x9e47('0x3d')]:_0x1270f1['model'];_0x4b1290['order']=qs[_0x9e47('0x41')](_0x3c3699[_0x9e47('0x3a')][_0x9e47('0x41')]);_0x4b1290['where']=qs[_0x9e47('0x44')](_[_0x9e47('0x43')](_0x3c3699[_0x9e47('0x3a')],_0x1270f1['filters']));if(_0x3c3699[_0x9e47('0x3a')][_0x9e47('0x65')]){_0x4b1290['where']=_[_0x9e47('0x8d')](_0x4b1290[_0x9e47('0x42')],{'$or':_[_0x9e47('0x57')](_0x4b1290[_0x9e47('0x3d')],function(_0x5e79e5){var _0x4e0cac={};_0x4e0cac[_0x5e79e5]={'$like':'%'+_0x3c3699[_0x9e47('0x3a')][_0x9e47('0x65')]+'%'};return _0x4e0cac;})});}_0x4b1290=_['merge']({},_0x4b1290,_0x3c3699['options']);return _0x57141a[_0x9e47('0xd7')](_0x4b1290);}})['then'](function(_0x105366){if(_0x105366){_0x3c8fa3=_0x105366[_0x9e47('0x33')];if(!_0x3c3699[_0x9e47('0x3a')][_0x9e47('0x3f')]('nolimit')){_0x4b1290[_0x9e47('0x25')]=qs[_0x9e47('0x25')](_0x3c3699[_0x9e47('0x3a')][_0x9e47('0x25')]);_0x4b1290[_0x9e47('0x22')]=qs[_0x9e47('0x22')](_0x3c3699[_0x9e47('0x3a')]['offset']);}return _0x57141a[_0x9e47('0xd7')](_0x4b1290);}})['then'](function(_0x2c9ff3){if(_0x2c9ff3){return _0x2c9ff3?{'count':_0x3c8fa3,'rows':_0x2c9ff3}:null;}})['then'](respondWithResult(_0x58ce6d,null))['catch'](handleError(_0x58ce6d,null));};exports[_0x9e47('0xd8')]=function(_0x4037fe,_0x29502c,_0x5a7e72){if(_0x4037fe[_0x9e47('0xa5')]['id']){delete _0x4037fe[_0x9e47('0xa5')]['id'];}return db[_0x9e47('0x31')][_0x9e47('0x37')]({'where':{'id':_0x4037fe[_0x9e47('0x9b')]['id']}})[_0x9e47('0x2b')](handleEntityNotFound(_0x29502c,null))[_0x9e47('0x2b')](function(_0x285adf){if(_0x285adf){return _0x285adf[_0x9e47('0xd8')](_0x4037fe[_0x9e47('0xa5')][_0x9e47('0xd9')]||[]);}return null;})[_0x9e47('0x2b')](respondWithResult(_0x29502c,null))['catch'](handleError(_0x29502c,null));};exports[_0x9e47('0xda')]=function(_0x4343a5,_0xe180cf,_0x1c788b){var _0x1d9839={'raw':![],'where':{}};var _0x5af1bf={};var _0x2fd741={'count':0x0,'rows':[]};return db[_0x9e47('0x31')][_0x9e47('0x37')]({'where':{'id':_0x4343a5[_0x9e47('0x9b')]['id']}})['then'](handleEntityNotFound(_0xe180cf,null))[_0x9e47('0x2b')](function(_0x164989){if(_0x164989){_0x5af1bf[_0x9e47('0x3c')]=_['keys'](db[_0x9e47('0xab')][_0x9e47('0xdb')]);_0x5af1bf['query']=_[_0x9e47('0x32')](_0x4343a5[_0x9e47('0x3a')]);_0x5af1bf[_0x9e47('0x44')]=_[_0x9e47('0x3b')](_0x5af1bf['model'],_0x5af1bf['query']);_0x1d9839[_0x9e47('0x3d')]=_[_0x9e47('0x3b')](_0x5af1bf['model'],qs['fields'](_0x4343a5[_0x9e47('0x3a')][_0x9e47('0x3e')]));_0x1d9839[_0x9e47('0x3d')]=_0x1d9839[_0x9e47('0x3d')]['length']?_0x1d9839[_0x9e47('0x3d')]:_0x5af1bf[_0x9e47('0x3c')];if(!_0x4343a5['query'][_0x9e47('0x3f')]('nolimit')){_0x1d9839[_0x9e47('0x25')]=qs[_0x9e47('0x25')](_0x4343a5[_0x9e47('0x3a')][_0x9e47('0x25')]);_0x1d9839[_0x9e47('0x22')]=qs[_0x9e47('0x22')](_0x4343a5[_0x9e47('0x3a')][_0x9e47('0x22')]);}_0x1d9839[_0x9e47('0x40')]=qs[_0x9e47('0x41')](_0x4343a5['query'][_0x9e47('0x41')]);_0x1d9839[_0x9e47('0x42')]=qs[_0x9e47('0x44')](_[_0x9e47('0x43')](_0x4343a5[_0x9e47('0x3a')],_0x5af1bf[_0x9e47('0x44')]));_0x1d9839['where'][_0x9e47('0xdc')]=_0x164989['id'];if(_0x4343a5[_0x9e47('0x3a')][_0x9e47('0x65')]){_0x1d9839[_0x9e47('0x42')]=_[_0x9e47('0x8d')](_0x1d9839[_0x9e47('0x42')],{'$or':_[_0x9e47('0x57')](_0x1d9839['attributes'],function(_0x36391f){var _0x13b3ee={};_0x13b3ee[_0x36391f]={'$like':'%'+_0x4343a5['query'][_0x9e47('0x65')]+'%'};return _0x13b3ee;})});}_0x1d9839=_[_0x9e47('0x8d')]({},_0x1d9839,_0x4343a5[_0x9e47('0xdd')]);return db[_0x9e47('0xab')]['count']({'where':_0x1d9839['where']})[_0x9e47('0x2b')](function(_0x3ac1a1){_0x2fd741[_0x9e47('0x24')]=_0x3ac1a1;if(_0x4343a5[_0x9e47('0x3a')][_0x9e47('0xde')]){_0x1d9839[_0x9e47('0xdf')]=[{'all':!![]}];}return db[_0x9e47('0xab')][_0x9e47('0xa0')](_0x1d9839);})[_0x9e47('0x2b')](function(_0x9aec61){_0x2fd741['rows']=_0x9aec61;return _0x2fd741;});}})['then'](respondWithFilteredResult(_0xe180cf,_0x1d9839))['catch'](handleError(_0xe180cf,null));};exports[_0x9e47('0xe0')]=function(_0x160d5f,_0x4fe67a,_0xa96ecc){var _0x2e15d8={'raw':!![],'where':{}};var _0x161f28={};var _0x4339b4={'count':0x0,'rows':[]};return db['CmContact']['findOne']({'where':{'id':_0x160d5f[_0x9e47('0x9b')]['id']}})[_0x9e47('0x2b')](handleEntityNotFound(_0x4fe67a,null))[_0x9e47('0x2b')](function(_0x13e139){if(_0x13e139){_0x161f28[_0x9e47('0x3c')]=_[_0x9e47('0x32')](db[_0x9e47('0xba')][_0x9e47('0xdb')]);_0x161f28['query']=_[_0x9e47('0x32')](_0x160d5f[_0x9e47('0x3a')]);_0x161f28['filters']=_[_0x9e47('0x3b')](_0x161f28[_0x9e47('0x3c')],_0x161f28[_0x9e47('0x3a')]);_0x2e15d8[_0x9e47('0x3d')]=_[_0x9e47('0x3b')](_0x161f28[_0x9e47('0x3c')],qs['fields'](_0x160d5f['query'][_0x9e47('0x3e')]));_0x2e15d8[_0x9e47('0x3d')]=_0x2e15d8['attributes']['length']?_0x2e15d8[_0x9e47('0x3d')]:_0x161f28[_0x9e47('0x3c')];if(!_0x160d5f[_0x9e47('0x3a')][_0x9e47('0x3f')]('nolimit')){_0x2e15d8[_0x9e47('0x25')]=qs[_0x9e47('0x25')](_0x160d5f[_0x9e47('0x3a')][_0x9e47('0x25')]);_0x2e15d8['offset']=qs[_0x9e47('0x22')](_0x160d5f[_0x9e47('0x3a')][_0x9e47('0x22')]);}_0x2e15d8[_0x9e47('0x40')]=qs[_0x9e47('0x41')](_0x160d5f[_0x9e47('0x3a')]['sort']);_0x2e15d8[_0x9e47('0x42')]=qs['filters'](_['pick'](_0x160d5f[_0x9e47('0x3a')],_0x161f28[_0x9e47('0x44')]));_0x2e15d8[_0x9e47('0x42')][_0x9e47('0xdc')]=_0x13e139['id'];if(_0x160d5f[_0x9e47('0x3a')][_0x9e47('0x65')]){_0x2e15d8[_0x9e47('0x42')]=_[_0x9e47('0x8d')](_0x2e15d8[_0x9e47('0x42')],{'$or':_[_0x9e47('0x57')](_0x2e15d8[_0x9e47('0x3d')],function(_0x2c8a68){var _0x348e88={};_0x348e88[_0x2c8a68]={'$like':'%'+_0x160d5f[_0x9e47('0x3a')][_0x9e47('0x65')]+'%'};return _0x348e88;})});}_0x2e15d8=_['merge']({},_0x2e15d8,_0x160d5f[_0x9e47('0xdd')]);return db['CmHopperHistory'][_0x9e47('0x24')]({'where':_0x2e15d8[_0x9e47('0x42')]})[_0x9e47('0x2b')](function(_0xf84760){_0x4339b4['count']=_0xf84760;if(_0x160d5f[_0x9e47('0x3a')][_0x9e47('0xde')]){_0x2e15d8['include']=[{'all':!![]}];}return db[_0x9e47('0xba')][_0x9e47('0xa0')](_0x2e15d8);})[_0x9e47('0x2b')](function(_0x48f742){_0x4339b4[_0x9e47('0x9a')]=_0x48f742;return _0x4339b4;});}})['then'](respondWithFilteredResult(_0x4fe67a,_0x2e15d8))[_0x9e47('0x9c')](handleError(_0x4fe67a,null));};exports['getHopperFinals']=function(_0x14ffb2,_0xe6b0cd,_0x49505b){var _0x5b6f49={'raw':!![],'where':{}};var _0x435e21={};var _0x24a0f1={'count':0x0,'rows':[]};return db[_0x9e47('0x31')][_0x9e47('0x37')]({'where':{'id':_0x14ffb2[_0x9e47('0x9b')]['id']}})[_0x9e47('0x2b')](handleEntityNotFound(_0xe6b0cd,null))[_0x9e47('0x2b')](function(_0x2d8143){if(_0x2d8143){_0x435e21[_0x9e47('0x3c')]=_[_0x9e47('0x32')](db['CmHopperFinal'][_0x9e47('0xdb')]);_0x435e21[_0x9e47('0x3a')]=_[_0x9e47('0x32')](_0x14ffb2[_0x9e47('0x3a')]);_0x435e21['filters']=_['intersection'](_0x435e21['model'],_0x435e21[_0x9e47('0x3a')]);_0x5b6f49[_0x9e47('0x3d')]=_[_0x9e47('0x3b')](_0x435e21[_0x9e47('0x3c')],qs['fields'](_0x14ffb2[_0x9e47('0x3a')][_0x9e47('0x3e')]));_0x5b6f49['attributes']=_0x5b6f49[_0x9e47('0x3d')]['length']?_0x5b6f49[_0x9e47('0x3d')]:_0x435e21[_0x9e47('0x3c')];if(!_0x14ffb2['query']['hasOwnProperty'](_0x9e47('0xe1'))){_0x5b6f49[_0x9e47('0x25')]=qs[_0x9e47('0x25')](_0x14ffb2[_0x9e47('0x3a')][_0x9e47('0x25')]);_0x5b6f49['offset']=qs['offset'](_0x14ffb2[_0x9e47('0x3a')][_0x9e47('0x22')]);}_0x5b6f49[_0x9e47('0x40')]=qs[_0x9e47('0x41')](_0x14ffb2[_0x9e47('0x3a')]['sort']);_0x5b6f49[_0x9e47('0x42')]=qs['filters'](_['pick'](_0x14ffb2[_0x9e47('0x3a')],_0x435e21[_0x9e47('0x44')]));_0x5b6f49[_0x9e47('0x42')][_0x9e47('0xdc')]=_0x2d8143['id'];if(_0x14ffb2[_0x9e47('0x3a')][_0x9e47('0x65')]){_0x5b6f49[_0x9e47('0x42')]=_['merge'](_0x5b6f49[_0x9e47('0x42')],{'$or':_['map'](_0x5b6f49[_0x9e47('0x3d')],function(_0x2c42cb){var _0x28ecba={};_0x28ecba[_0x2c42cb]={'$like':'%'+_0x14ffb2['query'][_0x9e47('0x65')]+'%'};return _0x28ecba;})});}_0x5b6f49=_['merge']({},_0x5b6f49,_0x14ffb2[_0x9e47('0xdd')]);return db['CmHopperFinal'][_0x9e47('0x24')]({'where':_0x5b6f49[_0x9e47('0x42')]})[_0x9e47('0x2b')](function(_0x1d9259){_0x24a0f1[_0x9e47('0x24')]=_0x1d9259;if(_0x14ffb2['query'][_0x9e47('0xde')]){_0x5b6f49[_0x9e47('0xdf')]=[{'all':!![]}];}return db['CmHopperFinal'][_0x9e47('0xa0')](_0x5b6f49);})[_0x9e47('0x2b')](function(_0x18d035){_0x24a0f1[_0x9e47('0x9a')]=_0x18d035;return _0x24a0f1;});}})[_0x9e47('0x2b')](respondWithFilteredResult(_0xe6b0cd,_0x5b6f49))['catch'](handleError(_0xe6b0cd,null));};exports[_0x9e47('0xe2')]=function(_0x2ba598,_0x5e9778,_0x109e1e){var _0x577308={'raw':!![],'where':{}};var _0x33e16e={};var _0x4c21a5={'count':0x0,'rows':[]};return db[_0x9e47('0x31')][_0x9e47('0x37')]({'where':{'id':_0x2ba598[_0x9e47('0x9b')]['id']}})[_0x9e47('0x2b')](handleEntityNotFound(_0x5e9778,null))[_0x9e47('0x2b')](function(_0x3751ef){if(_0x3751ef){_0x33e16e['model']=_['keys'](db['JscriptySessionReport'][_0x9e47('0xdb')]);_0x33e16e[_0x9e47('0x3a')]=_[_0x9e47('0x32')](_0x2ba598[_0x9e47('0x3a')]);_0x33e16e['filters']=_[_0x9e47('0x3b')](_0x33e16e['model'],_0x33e16e[_0x9e47('0x3a')]);_0x577308[_0x9e47('0x3d')]=_[_0x9e47('0x3b')](_0x33e16e[_0x9e47('0x3c')],qs['fields'](_0x2ba598['query'][_0x9e47('0x3e')]));_0x577308[_0x9e47('0x3d')]=_0x577308['attributes'][_0x9e47('0x33')]?_0x577308['attributes']:_0x33e16e[_0x9e47('0x3c')];if(!_0x2ba598[_0x9e47('0x3a')]['hasOwnProperty'](_0x9e47('0xe1'))){_0x577308['limit']=qs[_0x9e47('0x25')](_0x2ba598[_0x9e47('0x3a')]['limit']);_0x577308[_0x9e47('0x22')]=qs[_0x9e47('0x22')](_0x2ba598[_0x9e47('0x3a')][_0x9e47('0x22')]);}_0x577308['order']=qs['sort'](_0x2ba598[_0x9e47('0x3a')][_0x9e47('0x41')]);_0x577308[_0x9e47('0x42')]=qs[_0x9e47('0x44')](_[_0x9e47('0x43')](_0x2ba598['query'],_0x33e16e[_0x9e47('0x44')]));_0x577308[_0x9e47('0x42')]['ContactId']=_0x3751ef['id'];if(_0x2ba598['query']['filter']){_0x577308[_0x9e47('0x42')]=_[_0x9e47('0x8d')](_0x577308[_0x9e47('0x42')],{'$or':_[_0x9e47('0x57')](_0x577308[_0x9e47('0x3d')],function(_0x5e2a62){var _0x155e98={};_0x155e98[_0x5e2a62]={'$like':'%'+_0x2ba598['query'][_0x9e47('0x65')]+'%'};return _0x155e98;})});}_0x577308=_[_0x9e47('0x8d')]({},_0x577308,_0x2ba598['options']);return db[_0x9e47('0xc2')][_0x9e47('0x24')]({'where':_0x577308[_0x9e47('0x42')]})[_0x9e47('0x2b')](function(_0xf35a71){_0x4c21a5[_0x9e47('0x24')]=_0xf35a71;if(_0x2ba598[_0x9e47('0x3a')][_0x9e47('0xde')]){_0x577308['include']=[{'all':!![]}];}return db['JscriptySessionReport'][_0x9e47('0xa0')](_0x577308);})['then'](function(_0x5b8566){_0x4c21a5[_0x9e47('0x9a')]=_0x5b8566;return _0x4c21a5;});}})[_0x9e47('0x2b')](respondWithFilteredResult(_0x5e9778,_0x577308))[_0x9e47('0x9c')](handleError(_0x5e9778,null));};exports[_0x9e47('0xe3')]=function(_0x2e626b,_0x2eac21,_0x4c3dfa){try{if(!_0x2e626b[_0x9e47('0xa5')][_0x9e47('0x69')]){throw new Error(_0x9e47('0xe4'));}if(!_0x2e626b['body'][_0x9e47('0xe5')]){throw new Error(_0x9e47('0xe6'));}if(!_0x2e626b['body'][_0x9e47('0xe7')]){throw new Error(_0x9e47('0xe8'));}if(!_0x2e626b[_0x9e47('0xa5')]['socket_timestamp']){throw new Error(_0x9e47('0xe9'));}var _0x1e27a5=_0x2e626b[_0x9e47('0xa5')][_0x9e47('0xe5')][_0x9e47('0x70')](',');var _0x5217e1=_0x2e626b[_0x9e47('0xa5')][_0x9e47('0xe7')][_0x9e47('0x70')](',');if(!_0x1e27a5[_0x9e47('0x33')]||!_0x5217e1[_0x9e47('0x33')]||_0x1e27a5[_0x9e47('0x33')]!==_0x5217e1['length']){throw new Error(_0x9e47('0xea'));}_0x2e626b[_0x9e47('0xa5')]['fields']=_['zipObject'](_0x1e27a5,_0x5217e1);if(!_0x2e626b[_0x9e47('0xa5')][_0x9e47('0x3e')][_0x9e47('0xd6')]){throw new Error(_0x9e47('0xeb'));}if(!_0x2e626b[_0x9e47('0xa5')][_0x9e47('0x3e')][_0x9e47('0xec')]){throw new Error(_0x9e47('0xed'));}var _0x49be9e=path[_0x9e47('0xa8')](config['root'],_0x9e47('0xee'),_0x2e626b[_0x9e47('0xef')]['filename']);fs[_0x9e47('0xf0')](_0x49be9e,parseInt(_0x9e47('0xf1'),0x8));var _0x5e9204=require(_0x9e47('0xf2'))[_0x9e47('0xf3')](path['join'](__dirname,_0x9e47('0xf4')),[_0x49be9e,_0x2e626b[_0x9e47('0xa5')][_0x9e47('0xe5')],_0x2e626b[_0x9e47('0xa5')]['binding_values'],_0x2e626b[_0x9e47('0xa5')][_0x9e47('0x69')],_0x2e626b['body'][_0x9e47('0xf5')],_0x2e626b[_0x9e47('0xa5')][_0x9e47('0xc6')],_0x2e626b['body'][_0x9e47('0xf6')]]);return _0x2eac21[_0x9e47('0x1f')](0xc8)[_0x9e47('0x21')]({'message':_0x9e47('0xf7'),'pid':_0x5e9204[_0x9e47('0xf8')]});}catch(_0xd3f16b){return _0x2eac21[_0x9e47('0x1f')](0x1f4)['send'](_0xd3f16b);}};exports[_0x9e47('0xf9')]=function(_0x146335,_0x1c96e3,_0x561506){var _0x5137c6=fs[_0x9e47('0xfa')](_0x146335['file'][_0x9e47('0x7')]);Papa[_0x9e47('0xfb')](_0x5137c6,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x23063f){return _0x1c96e3[_0x9e47('0x1f')](0xc8)['json']({'file':_0x146335[_0x9e47('0xef')],'fields':_0x23063f[_0x9e47('0xfc')][_0x9e47('0x3e')]});}});};exports[_0x9e47('0xfd')]=function(_0x480830,_0x628f37,_0xea4022){return db[_0x9e47('0x5b')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0x9e47('0x85')}})[_0x9e47('0x2b')](function(_0x1cfa00){var _0x2c35fe=![];if(!_0x480830[_0x9e47('0xa5')][_0x9e47('0x69')]){throw new Error(_0x9e47('0xe4'));}if(!_0x480830[_0x9e47('0xa5')][_0x9e47('0xfe')][_0x9e47('0xd6')]){throw new Error(_0x9e47('0xeb'));}if(!_0x480830[_0x9e47('0xa5')][_0x9e47('0xfe')][_0x9e47('0xec')]){throw new Error(_0x9e47('0xed'));}if(!_0x480830[_0x9e47('0xa5')]['socket_timestamp']){throw new Error(_0x9e47('0xe9'));}var _0x26bc04=require(_0x9e47('0xf2'))[_0x9e47('0xf3')](path['join'](__dirname,'../../components/import/cm/csv2'),[_0x480830['params']['id'],JSON[_0x9e47('0xff')](_0x480830['body']),JSON[_0x9e47('0xff')](_0x1cfa00)]);_0x26bc04['on'](_0x9e47('0x100'),function(_0x40402c){_0x2c35fe=!![];return _0x628f37['status'](0xc8)['json']({'message':'start\x20child\x20process\x20correctly!','pid':_0x26bc04['pid']});});_0x26bc04['on'](_0x9e47('0x101'),function(_0x38a8e8){if(_0x38a8e8&&!_0x2c35fe){return _0x628f37[_0x9e47('0x1f')](0x1f4)[_0x9e47('0x21')]({'message':_0x9e47('0x102'),'pid':_0x26bc04[_0x9e47('0xf8')]});}});})['catch'](handleError(_0x628f37,null));};exports['getJourney']=function(_0x3a3c83,_0x28c710){var _0x4b7081=['mail',_0x9e47('0x103'),_0x9e47('0x104'),_0x9e47('0x105'),_0x9e47('0x106'),'whatsapp','voice'];var _0x346ae1={'offset':0x0,'order':qs[_0x9e47('0x41')](_0x9e47('0x107'))},_0x3890ad={'count':0x0,'rows':[]};Promise[_0x9e47('0x82')]()[_0x9e47('0x2b')](function(){if(_0x3a3c83[_0x9e47('0x3a')][_0x9e47('0x108')]){if(!_[_0x9e47('0x109')](_0x4b7081,_0x3a3c83['query'][_0x9e47('0x108')][_0x9e47('0x10a')]())){throw new Error('Invalid\x20channel');}_0x4b7081=[_0x3a3c83[_0x9e47('0x3a')]['channel'][_0x9e47('0x10a')]()];}if(_0x3a3c83[_0x9e47('0x3a')]['range']){try{var _0x469785=JSON[_0x9e47('0xfb')](_0x3a3c83[_0x9e47('0x3a')][_0x9e47('0x10b')]);if(!moment(_0x469785[_0x9e47('0x46')])['isValid']()){throw new Error(_0x9e47('0x10c'));}if(!moment(_0x469785['to'])[_0x9e47('0x10d')]()){throw new Error('Invalid\x20date\x20for\x20range\x20to\x20filter');}}catch(_0x503c8c){throw new Error(_0x9e47('0x10e'));}}if(!_0x3a3c83[_0x9e47('0x3a')][_0x9e47('0x3f')](_0x9e47('0xe1'))){_0x346ae1[_0x9e47('0x25')]=qs['limit'](_0x3a3c83['query'][_0x9e47('0x25')]||0xa);_0x346ae1[_0x9e47('0x22')]=qs['offset'](_0x3a3c83['query']['offset']);}var _0x15a781=_0x4b7081[_0x9e47('0x57')](function(_0x3601af){if(_0x3601af===_0x9e47('0x10f')){var _0x2922ca={'attributes':['id',_0x9e47('0x110'),_0x9e47('0x62'),_0x9e47('0x111'),_0x9e47('0x112'),_0x9e47('0x113'),_0x9e47('0x114'),_0x9e47('0x115'),'duration',_0x9e47('0x116'),'createdAt',_0x9e47('0x117'),'userSecondDisposition',_0x9e47('0x118'),_0x9e47('0x119')],'where':{'ContactId':_0x3a3c83[_0x9e47('0x9b')]['id']},'include':[{'model':db[_0x9e47('0x5b')],'as':_0x9e47('0x5b'),'attributes':['id',_0x9e47('0x2e'),_0x9e47('0x11a'),_0x9e47('0xa2')]}],'order':[[_0x9e47('0x11b'),_0x9e47('0x80')]]};if(_0x3a3c83['query'][_0x9e47('0x10b')]){_0x2922ca['where']['createdAt']={'$gte':_0x469785[_0x9e47('0x46')],'$lte':_0x469785['to']};}return db[_0x9e47('0xbc')][_0x9e47('0x11c')](_0x2922ca)[_0x9e47('0x2b')](function(_0x4c1a20){_0x3890ad[_0x9e47('0x24')]+=_0x4c1a20[_0x9e47('0x24')];return _['map'](_0x4c1a20[_0x9e47('0x9a')],function(_0x3ffb3e){var _0x31039a=_0x3ffb3e[_0x9e47('0xa6')]({'plain':!![]});_0x31039a['channel']=_0x3601af;if(_0x31039a[_0x9e47('0x5b')]){_0x31039a[_0x9e47('0x5b')]={'id':_0x31039a[_0x9e47('0x5b')]['id'],'name':_0x31039a[_0x9e47('0x5b')][_0x9e47('0x2e')],'fullname':_0x31039a[_0x9e47('0x5b')]['fullname'],'alias':_0x31039a[_0x9e47('0x5b')]['alias']};}return _0x31039a;});});}else{var _0x127468=_[_0x9e47('0x11d')](_0x3601af)+(_0x3601af==='chat'?_0x9e47('0x11e'):_0x9e47('0x11f'));var _0x4894b8={'attributes':['id',_0x9e47('0x120'),_0x9e47('0x121'),'createdAt','note',_0x9e47('0x122'),_0x9e47('0x123'),_0x9e47('0x124'),_0x9e47('0x119'),_0x127468+'Id'],'where':{'ContactId':_0x3a3c83[_0x9e47('0x9b')]['id']},'include':[{'model':db[_0x127468],'as':'Account','attributes':['id',_0x9e47('0x2e'),_0x9e47('0x125')]},{'model':db['User'],'as':'Owner','attributes':['id',_0x9e47('0x2e'),_0x9e47('0x11a')]},{'model':db['Tag'],'as':'Tags','attributes':['id',_0x9e47('0x2e'),_0x9e47('0xcd')],'through':{'attributes':[]}}],'order':[[_0x9e47('0x11b'),_0x9e47('0x80')]]};if(_0x3a3c83[_0x9e47('0x3a')][_0x9e47('0x10b')]){_0x4894b8[_0x9e47('0x42')][_0x9e47('0x11b')]={'$gte':_0x469785[_0x9e47('0x46')],'$lte':_0x469785['to']};}switch(_0x3601af){case _0x9e47('0x103'):_0x4894b8[_0x9e47('0x3d')][_0x9e47('0x99')](_0x9e47('0x126'),_0x9e47('0x127'),_0x9e47('0x128'),_0x9e47('0x129'),_0x9e47('0x12a'),_0x9e47('0x12b'),_0x9e47('0x12c'),_0x9e47('0x12d'),'referer');break;case'mail':_0x4894b8['attributes'][_0x9e47('0x99')]('subject','substatus');break;case _0x9e47('0x105'):_0x4894b8[_0x9e47('0x3d')][_0x9e47('0x99')]('externalUrl',_0x9e47('0x12e'));break;}return db[_[_0x9e47('0x11d')](_0x3601af)+_0x9e47('0x12f')]['findAndCountAll'](_0x4894b8)[_0x9e47('0x2b')](function(_0x8b9b73){_0x3890ad[_0x9e47('0x24')]+=_0x8b9b73['count'];return _['map'](_0x8b9b73[_0x9e47('0x9a')],function(_0xdb23fb){var _0x590594=_0xdb23fb[_0x9e47('0xa6')]({'plain':!![]});_0x590594[_0x9e47('0x108')]=_0x3601af;if(_0x590594[_0x9e47('0x130')]){_0x590594[_0x9e47('0x130')]={'id':_0x590594[_0x9e47('0x130')]['id'],'name':_0x590594[_0x9e47('0x130')][_0x9e47('0x2e')],'fullname':_0x590594[_0x9e47('0x130')]['fullname']};}return _0x590594;});});}});return Promise[_0x9e47('0x131')](_0x15a781);})[_0x9e47('0x2b')](function(_0x15ed92){return _(_0x15ed92)[_0x9e47('0x132')]()[_0x9e47('0x133')](_0x9e47('0x11b'))[_0x9e47('0x134')]()[_0x9e47('0x56')]();})[_0x9e47('0x2b')](function(_0x3b9537){_0x3890ad[_0x9e47('0x9a')]=_0x346ae1[_0x9e47('0x25')]?_0x3b9537[_0x9e47('0x135')](_0x346ae1[_0x9e47('0x22')],_0x346ae1[_0x9e47('0x22')]+_0x346ae1[_0x9e47('0x25')]):_0x3b9537;return _0x3890ad;})['then'](respondWithFilteredResult(_0x28c710,_0x346ae1))[_0x9e47('0x9c')](handleError(_0x28c710,null));};
\ No newline at end of file