// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xe170=['tags','startsWith','columnName','CmCustomField','findAll','alias','custom','values','get','join','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','ChatMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappQueueReport','bulkCreate','each','duplicates','$or','show','Tag','$and','format','cf_%d','pickBy','table','setFields','id\x20=\x20?','sequelize','CmHopper','phone','getTags','setTags','ids','getHoppers','ContactId','options','include','getHopperHistories','rawAttributes','includeAll','getHopperFinals','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','filename','0777','child_process','fork','CompanyId','File\x20uploaded\x20correctly!','pid','file','parse','meta','import','binding','../../components/import/cm/csv2','stringify','error\x20child\x20process','chat','sms','fax','voice','-createdAt','channel','toLowerCase','Invalid\x20channel','range','isValid','Invalid\x20date\x20for\x20range\x20from\x20filter','Invalid\x20createdAt\x20filter','uniqueid','source','callerid','starttime','endtime','duration','createdAt','userDisposition','userSecondDisposition','userThirdDisposition','UserId','fullname','findAndCountAll','Website','Account','closed','closedAt','note','disposition','thirdDisposition','key','Owner','browserName','customerIp','customerPort','ratingMessage','ratingType','mail','subject','substatus','openchannel','externalUrl','threadId','Interaction','all','flatten','sortBy','reverse','slice','eml-format','rimraf','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/license/util','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./cmContact.socket','register','sendStatus','status','end','json','offset','undefined','count','limit','set','Content-Range','apply','reject','save','update','then','name','send','merge','body','contact','interaction','index','CmContact','describe','keys','cf_','push','findOne','trimStart','length','fieldType','type','model','filters','intersection','query','attributes','fields','hasOwnProperty','nolimit','order','sort','pick','select','field','color','from','cm_contacts','left_join','cm_user_has_contacts','cm_contact_has_tags','where','c.deletedAt\x20IS\x20NULL','expr','parseSearch','find','value','split','map','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','and','uc.UserId\x20=\x20?','dateOfBirth','datetime','castTo','DATE','buildExpression','text','filter','isNil','Contact','isEmpty','ListId','c.ListId\x20IN\x20?','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','isArray','tag','replace','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','isNumeric','c.id\x20LIKE\x20?','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','c.lastName\x20LIKE\x20?','c.id','Sequelize','QueryTypes','SELECT','DESC','having','resolve','user','some','conditions','getLists','c.ListId\x20IS\x20NULL','role','agent','toString','c.firstName','c.lastName','c.mobile','c.fax','c.email','c.createdAt','c.deletedAt','c.CompanyId','TagIds','Tags','rows','destroy','params','catch'];(function(_0x8891a1,_0x4fdaf8){var _0x5ac2d9=function(_0x3a5872){while(--_0x3a5872){_0x8891a1['push'](_0x8891a1['shift']());}};_0x5ac2d9(++_0x4fdaf8);}(_0xe170,0x1b3));var _0x0e17=function(_0x8f371d,_0x5b146a){_0x8f371d=_0x8f371d-0x0;var _0x3bcc37=_0xe170[_0x8f371d];return _0x3bcc37;};'use strict';var emlformat=require(_0x0e17('0x0'));var rimraf=require(_0x0e17('0x1'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0x0e17('0x2'));var Mustache=require(_0x0e17('0x3'));var util=require(_0x0e17('0x4'));var path=require(_0x0e17('0x5'));var sox=require(_0x0e17('0x6'));var csv=require(_0x0e17('0x7'));var ejs=require(_0x0e17('0x8'));var fs=require('fs');var fs_extra=require(_0x0e17('0x9'));var _=require(_0x0e17('0xa'));var squel=require(_0x0e17('0xb'));var crypto=require('crypto');var jsforce=require(_0x0e17('0xc'));var deskjs=require(_0x0e17('0xd'));var toCsv=require(_0x0e17('0x7'));var querystring=require(_0x0e17('0xe'));var Papa=require(_0x0e17('0xf'));var Redis=require('ioredis');var authService=require(_0x0e17('0x10'));var qs=require(_0x0e17('0x11'));var as=require(_0x0e17('0x12'));var hardwareService=require(_0x0e17('0x13'));var logger=require(_0x0e17('0x14'))(_0x0e17('0x15'));var utils=require(_0x0e17('0x16'));var config=require('../../config/environment');var licenseUtil=require(_0x0e17('0x17'));var db=require(_0x0e17('0x18'))['db'];config[_0x0e17('0x19')]=_[_0x0e17('0x1a')](config[_0x0e17('0x19')],{'host':_0x0e17('0x1b'),'port':0x18eb});var socket=require(_0x0e17('0x1c'))(new Redis(config[_0x0e17('0x19')]));require(_0x0e17('0x1d'))[_0x0e17('0x1e')](socket);function respondWithStatusCode(_0x54b198,_0x4b8666){_0x4b8666=_0x4b8666||0xcc;return function(_0x1fb392){if(_0x1fb392){return _0x54b198[_0x0e17('0x1f')](_0x4b8666);}return _0x54b198[_0x0e17('0x20')](_0x4b8666)[_0x0e17('0x21')]();};}function respondWithResult(_0x2bea9b,_0x31bf3f){_0x31bf3f=_0x31bf3f||0xc8;return function(_0x2d64d3){if(_0x2d64d3){return _0x2bea9b[_0x0e17('0x20')](_0x31bf3f)[_0x0e17('0x22')](_0x2d64d3);}};}function respondWithFilteredResult(_0x5a0292,_0x2be6f9){return function(_0x3c8341){if(_0x3c8341){var _0x208915=typeof _0x2be6f9[_0x0e17('0x23')]===_0x0e17('0x24')&&typeof _0x2be6f9['limit']===_0x0e17('0x24');var _0xf760a5=_0x3c8341[_0x0e17('0x25')];var _0x5821fe=_0x208915?0x0:_0x2be6f9['offset'];var _0x3394d5=_0x208915?_0x3c8341['count']:_0x2be6f9['offset']+_0x2be6f9[_0x0e17('0x26')];var _0x8da1fa;if(_0x3394d5>=_0xf760a5){_0x3394d5=_0xf760a5;_0x8da1fa=0xc8;}else{_0x8da1fa=0xce;}_0x5a0292[_0x0e17('0x20')](_0x8da1fa);return _0x5a0292[_0x0e17('0x27')](_0x0e17('0x28'),_0x5821fe+'-'+_0x3394d5+'/'+_0xf760a5)[_0x0e17('0x22')](_0x3c8341);}return null;};}function patchUpdates(_0x57fd57){return function(_0x2e0332){try{jsonpatch[_0x0e17('0x29')](_0x2e0332,_0x57fd57,!![]);}catch(_0x19168f){return BPromise[_0x0e17('0x2a')](_0x19168f);}return _0x2e0332[_0x0e17('0x2b')]();};}function saveUpdates(_0x386afc,_0x4f9715){return function(_0x193ab9){if(_0x193ab9){return _0x193ab9[_0x0e17('0x2c')](_0x386afc)[_0x0e17('0x2d')](function(_0x4d6bef){return _0x4d6bef;});}return null;};}function removeEntity(_0x98497b,_0x5b897a){return function(_0x532661){if(_0x532661){return _0x532661['destroy']()['then'](function(){_0x98497b[_0x0e17('0x20')](0xcc)[_0x0e17('0x21')]();});}};}function handleEntityNotFound(_0x517277,_0x5f5aaa){return function(_0x22b6cd){if(!_0x22b6cd){_0x517277[_0x0e17('0x1f')](0x194);}return _0x22b6cd;};}function handleError(_0x5bc00b,_0x56ddba){_0x56ddba=_0x56ddba||0x1f4;return function(_0x14801a){logger['error'](_0x14801a['stack']);if(_0x14801a[_0x0e17('0x2e')]){delete _0x14801a[_0x0e17('0x2e')];}_0x5bc00b[_0x0e17('0x20')](_0x56ddba)[_0x0e17('0x2f')](_0x14801a);};}function getMustacheRender(_0x4943d4,_0x3b2976){return Mustache['render'](_0x4943d4,_[_0x0e17('0x30')](_0x3b2976[_0x0e17('0x31')],{'contact':_0x3b2976[_0x0e17('0x32')],'message':_0x3b2976['message'],'agent':_0x3b2976['agent'],'interaction':_0x3b2976[_0x0e17('0x33')],'account':_0x3b2976['account']}))||'';}exports[_0x0e17('0x34')]=function(_0x5805ca,_0xc364d2){var _0x405801={},_0x483c64={},_0x4fa7d5={'count':0x0,'rows':[]};return db[_0x0e17('0x35')][_0x0e17('0x36')]()[_0x0e17('0x2d')](function(_0xdf5b07){var _0x360acf=[];for(var _0x432d1b=0x0;_0x432d1b<Object['keys'](_0xdf5b07)['length'];_0x432d1b++){var _0x387774=Object[_0x0e17('0x37')](_0xdf5b07)[_0x432d1b];if(_['startsWith'](_0x387774,_0x0e17('0x38'))){_0x360acf[_0x0e17('0x39')](db['CmCustomField'][_0x0e17('0x3a')]({'where':{'id':_[_0x0e17('0x3b')](_0x387774,_0x0e17('0x38'))},'raw':!![]}));}}return BPromise['all'](_0x360acf)['then'](function(_0x2a1f1d){for(var _0x1e63d2=0x0;_0x1e63d2<_0x2a1f1d[_0x0e17('0x3c')];_0x1e63d2++){if(_0x2a1f1d[_0x1e63d2]){var _0x3c6444=_0x0e17('0x38')+_0x2a1f1d[_0x1e63d2]['id'];var _0x5504f9=_0xdf5b07[_0x3c6444];_0x5504f9[_0x0e17('0x3d')]=_0x2a1f1d[_0x1e63d2][_0x0e17('0x3e')];}}return _0xdf5b07;});})[_0x0e17('0x2d')](function(_0x2f89b3){_0x483c64[_0x0e17('0x3f')]=_['keys'](_0x2f89b3);_0x483c64['query']=_['keys'](_0x5805ca['query']);_0x483c64[_0x0e17('0x40')]=_[_0x0e17('0x41')](_0x483c64[_0x0e17('0x3f')],_0x483c64[_0x0e17('0x42')]);_0x405801[_0x0e17('0x43')]=_[_0x0e17('0x41')](_0x483c64[_0x0e17('0x3f')],qs[_0x0e17('0x44')](_0x5805ca[_0x0e17('0x42')][_0x0e17('0x44')]));_0x405801['attributes']=_0x405801[_0x0e17('0x43')][_0x0e17('0x3c')]?_0x405801[_0x0e17('0x43')]:_0x483c64[_0x0e17('0x3f')];if(!_0x5805ca[_0x0e17('0x42')][_0x0e17('0x45')](_0x0e17('0x46'))){_0x405801[_0x0e17('0x26')]=qs[_0x0e17('0x26')](_0x5805ca[_0x0e17('0x42')][_0x0e17('0x26')]);_0x405801['offset']=qs[_0x0e17('0x23')](_0x5805ca[_0x0e17('0x42')][_0x0e17('0x23')]);}_0x405801[_0x0e17('0x47')]=qs[_0x0e17('0x48')](_0x5805ca[_0x0e17('0x42')]['sort']);_0x405801['where']=qs['filters'](_[_0x0e17('0x49')](_0x5805ca[_0x0e17('0x42')],_0x483c64[_0x0e17('0x40')]),_0x2f89b3);var _0x4b9554=[];var _0x2d9881=squel[_0x0e17('0x4a')]()[_0x0e17('0x4b')]('id')[_0x0e17('0x4b')]('name')['field'](_0x0e17('0x4c'))[_0x0e17('0x4d')]('tools_tags');var _0x240e2a=squel[_0x0e17('0x4a')]()['from'](_0x0e17('0x4e'),'c')[_0x0e17('0x4f')](_0x0e17('0x50'),'uc','uc.CmContactId\x20=\x20c.id')[_0x0e17('0x4f')](_0x0e17('0x51'),'ct','ct.CmContactId\x20=\x20c.id')[_0x0e17('0x4f')]('tools_tags','t','t.id\x20=\x20ct.TagId')[_0x0e17('0x52')](_0x0e17('0x53'));var _0x96f12e=squel[_0x0e17('0x54')]();var _0x4eeb2f=[];var _0x340858=squel[_0x0e17('0x54')]();var _0x1751a3;if(_0x5805ca[_0x0e17('0x42')]['search']){_0x1751a3=as[_0x0e17('0x55')](_0x5805ca[_0x0e17('0x42')]['search']);var _0x5a6f4a=_0x1751a3['sqlOperator'];for(var _0x366381=0x0;_0x366381<_0x1751a3['conditions'][_0x0e17('0x3c')];_0x366381++){var _0x41ca26=_0x1751a3['conditions'][_0x366381];var _0x1a990c='c';var _0x157878=_(_0x2f89b3)['keys']()[_0x0e17('0x56')](function(_0x2d68be){return _0x2d68be===_0x41ca26[_0x0e17('0x4b')];});if(_0x157878)_0x157878=_0x2f89b3[_0x41ca26[_0x0e17('0x4b')]];if(!_0x157878){if(_0x41ca26[_0x0e17('0x4b')]==='Tag'){var _0x2a225a=_0x41ca26[_0x0e17('0x57')][_0x0e17('0x58')](',')[_0x0e17('0x59')](function(_0x176cd8){return Number(_0x176cd8);});_0x2a225a[_0x0e17('0x5a')](function(_0x2f56f6){_0x340858['or'](_0x0e17('0x5b'),'%,'+_0x2f56f6+',%');});_0x4eeb2f=_[_0x0e17('0x5c')](_0x4eeb2f,_0x2a225a);}else if(_0x41ca26[_0x0e17('0x4b')]===_0x0e17('0x5d')){_0x96f12e[_0x0e17('0x5e')](_0x0e17('0x5f'),_0x41ca26[_0x0e17('0x57')]);}}else{if(_0x41ca26[_0x0e17('0x4b')]===_0x0e17('0x60')||_0x157878[_0x0e17('0x3d')]===_0x0e17('0x61'))_0x41ca26[_0x0e17('0x62')]=_0x0e17('0x63');var _0x524195=as[_0x0e17('0x64')](_0x1a990c,_0x157878[_0x0e17('0x3e')],_0x41ca26);_0x96f12e[_0x5a6f4a](_0x524195[_0x0e17('0x65')],_0x524195[_0x0e17('0x57')]['start'],_0x524195[_0x0e17('0x57')][_0x0e17('0x21')]);}}}else{var _0x6b3fab=_(Object[_0x0e17('0x37')](_0x5805ca['query']))[_0x0e17('0x59')](function(_0x4c3375){return _0x2f89b3['hasOwnProperty'](_0x4c3375)?_0x4c3375:undefined;})[_0x0e17('0x66')](function(_0x248fd0){return!_[_0x0e17('0x67')](_0x248fd0);})[_0x0e17('0x57')]();if(_0x5805ca[_0x0e17('0x42')][_0x0e17('0x68')])_0x6b3fab[_0x0e17('0x39')](_0x0e17('0x68'));if(!_[_0x0e17('0x69')](_0x6b3fab)){_0x6b3fab[_0x0e17('0x5a')](function(_0x11e937){if(_0x11e937===_0x0e17('0x6a')){_0x240e2a[_0x0e17('0x52')](_0x0e17('0x6b'),[]['concat'](_0x5805ca['query'][_0x11e937]));}else if(_0x11e937===_0x0e17('0x68')){var _0xbf5a49='%'+_0x5805ca[_0x0e17('0x42')][_0x11e937]+'%';_0x240e2a[_0x0e17('0x52')](_0x0e17('0x6c'),_0xbf5a49);}else{_0x240e2a[_0x0e17('0x52')]('c.'+_0x11e937+_0x0e17('0x6d'),_0x5805ca['query'][_0x11e937]);}});}if(_0x5805ca[_0x0e17('0x42')]['tag']){_0x4eeb2f=_[_0x0e17('0x6e')](_0x5805ca['query'][_0x0e17('0x6f')])?_0x5805ca[_0x0e17('0x42')][_0x0e17('0x6f')]:new Array(_0x5805ca[_0x0e17('0x42')][_0x0e17('0x6f')]);_0x4eeb2f[_0x0e17('0x5a')](function(_0xf80254){_0x340858['or'](_0x0e17('0x5b'),'%,'+_0xf80254+',%');});}if(_0x5805ca[_0x0e17('0x42')]['filter']){var _0x143f22=_0x5805ca[_0x0e17('0x42')][_0x0e17('0x66')]['replace']('\x5c','\x5c\x5c')[_0x0e17('0x70')](/'/g,'\x27\x27');if(_0x143f22[_0x0e17('0x58')]('\x20')[_0x0e17('0x3c')]>0x1){_0x96f12e['or'](_0x0e17('0x71'),qs['getFullTextValue'](_0x143f22),null);}else{if(qs[_0x0e17('0x72')](_0x143f22)){_0x96f12e['or'](_0x0e17('0x73'),_0x143f22+'%');_0x96f12e['or'](_0x0e17('0x74'),_0x143f22+'%');_0x96f12e['or'](_0x0e17('0x75'),_0x143f22+'%');_0x96f12e['or'](_0x0e17('0x76'),_0x143f22+'%');}else if(qs[_0x0e17('0x77')](_0x143f22)){_0x96f12e['or'](_0x0e17('0x78'),_0x143f22+'%');}else{_0x96f12e['or']('c.firstName\x20LIKE\x20?','%'+_0x143f22+'%');_0x96f12e['or'](_0x0e17('0x79'),'%'+_0x143f22+'%');_0x96f12e['or'](_0x0e17('0x78'),'%'+_0x143f22+'%');}}}}_0x240e2a[_0x0e17('0x52')](_0x96f12e);_0x240e2a['group'](_0x0e17('0x7a'));var _0x49fa45={'type':db[_0x0e17('0x7b')][_0x0e17('0x7c')][_0x0e17('0x7d')],'raw':!![]};var _0x312072=_0x240e2a['clone']()[_0x0e17('0x4b')](_0x0e17('0x7a'));if(_0x405801[_0x0e17('0x47')]){_0x405801[_0x0e17('0x47')][_0x0e17('0x5a')](function(_0x522682){_0x240e2a[_0x0e17('0x47')]('c.'+_0x522682[0x0],_0x522682[0x1]===_0x0e17('0x7e')?![]:!![]);});}if(!_[_0x0e17('0x69')](_0x4eeb2f)){_0x240e2a[_0x0e17('0x7f')](_0x340858);_0x312072[_0x0e17('0x52')]('t.id\x20IN\x20?',_0x4eeb2f);}BPromise[_0x0e17('0x80')]()[_0x0e17('0x2d')](function(){if(!_0x1751a3)return;if(_0x5805ca[_0x0e17('0x81')]['role']!=='agent')return;if(!_[_0x0e17('0x82')](_0x1751a3[_0x0e17('0x83')],[_0x0e17('0x4b'),_0x0e17('0x5d')])){return _0x5805ca['user'][_0x0e17('0x84')]({'attributes':['id'],'raw':!![]})[_0x0e17('0x2d')](function(_0x589884){if(_[_0x0e17('0x69')](_0x589884)){_0x312072[_0x0e17('0x52')]('c.ListId\x20IS\x20NULL');_0x240e2a['where'](_0x0e17('0x85'));}else{_0x312072[_0x0e17('0x52')](_0x0e17('0x6b'),_[_0x0e17('0x59')](_0x589884,'id'));_0x240e2a[_0x0e17('0x52')](_0x0e17('0x6b'),_[_0x0e17('0x59')](_0x589884,'id'));}});}})[_0x0e17('0x2d')](function(){if(_0x5805ca[_0x0e17('0x81')][_0x0e17('0x86')]===_0x0e17('0x87')&&!_0x1751a3&&!_0x5805ca['query'][_0x0e17('0x6a')])return[];return db['sequelize']['query'](_0x312072[_0x0e17('0x88')](),_0x49fa45);})[_0x0e17('0x2d')](function(_0x57ab20){_0x4fa7d5[_0x0e17('0x25')]=_0x57ab20[_0x0e17('0x3c')];if(_0x4fa7d5[_0x0e17('0x25')]===0x0)return[];return db['sequelize'][_0x0e17('0x42')](_0x2d9881[_0x0e17('0x88')](),_0x49fa45)[_0x0e17('0x2d')](function(_0x141354){_0x4b9554=_['keyBy'](_0x141354,'id');_0x49fa45=_['merge'](_0x49fa45,{'model':db[_0x0e17('0x35')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x5805ca[_0x0e17('0x42')][_0x0e17('0x44')]){_0x405801['attributes'][_0x0e17('0x5a')](function(_0x5160b9){_0x240e2a['field']('c.'+_0x5160b9);});}else{_0x240e2a[_0x0e17('0x4b')](_0x0e17('0x7a'));_0x240e2a[_0x0e17('0x4b')](_0x0e17('0x89'));_0x240e2a[_0x0e17('0x4b')](_0x0e17('0x8a'));_0x240e2a[_0x0e17('0x4b')]('c.phone');_0x240e2a[_0x0e17('0x4b')](_0x0e17('0x8b'));_0x240e2a['field'](_0x0e17('0x8c'));_0x240e2a[_0x0e17('0x4b')](_0x0e17('0x8d'));_0x240e2a['field']('c.ListId');_0x240e2a[_0x0e17('0x4b')](_0x0e17('0x8e'));_0x240e2a['field'](_0x0e17('0x8f'));_0x240e2a[_0x0e17('0x4b')](_0x0e17('0x90'));_0x240e2a['field']('GROUP_CONCAT(DISTINCT\x20t.id)','TagIds');}if(_0x405801[_0x0e17('0x26')])_0x240e2a['limit'](_0x405801[_0x0e17('0x26')]);if(_0x405801[_0x0e17('0x23')])_0x240e2a[_0x0e17('0x23')](_0x405801[_0x0e17('0x23')]);return db['sequelize'][_0x0e17('0x42')](_0x240e2a[_0x0e17('0x88')](),_0x49fa45);});})[_0x0e17('0x2d')](function(_0x34d6b2){_0x34d6b2['forEach'](function(_0x33c246){if(_0x33c246[_0x0e17('0x91')]){_0x33c246[_0x0e17('0x92')]=[];_0x33c246['TagIds']['split'](',')[_0x0e17('0x5a')](function(_0x2609cd){_0x33c246[_0x0e17('0x92')][_0x0e17('0x39')](_0x4b9554[_0x2609cd]);});}delete _0x33c246[_0x0e17('0x91')];});_0x4fa7d5[_0x0e17('0x93')]=_0x34d6b2;return _0x4fa7d5;})[_0x0e17('0x2d')](respondWithFilteredResult(_0xc364d2,_0x405801));})['catch'](handleError(_0xc364d2,null));};exports[_0x0e17('0x94')]=function(_0x51532f,_0x3f652e){return db[_0x0e17('0x35')][_0x0e17('0x56')]({'where':{'id':_0x51532f[_0x0e17('0x95')]['id']}})[_0x0e17('0x2d')](handleEntityNotFound(_0x3f652e,null))[_0x0e17('0x2d')](removeEntity(_0x3f652e,null))[_0x0e17('0x96')](handleError(_0x3f652e,null));};exports[_0x0e17('0x36')]=function(_0x446d21,_0x57f289){return db[_0x0e17('0x35')][_0x0e17('0x36')]()[_0x0e17('0x2d')](function(_0x5efc5c){delete _0x5efc5c[_0x0e17('0x97')];for(var _0x23c4e1=0x0;_0x23c4e1<Object[_0x0e17('0x37')](_0x5efc5c)[_0x0e17('0x3c')];_0x23c4e1++){var _0x12c168=Object[_0x0e17('0x37')](_0x5efc5c)[_0x23c4e1];if(!_[_0x0e17('0x98')](_0x12c168,_0x0e17('0x38'))){_0x5efc5c[_0x12c168][_0x0e17('0x99')]=_0x12c168;_0x5efc5c[_0x12c168]['displayName']=_0x12c168;}}return _0x5efc5c;})[_0x0e17('0x2d')](function(_0x286921){var _0x27165b={'where':{'$or':[{'ListId':_0x446d21[_0x0e17('0x42')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x0e17('0x9a')][_0x0e17('0x9b')](_0x27165b)[_0x0e17('0x2d')](function(_0x3e7457){for(var _0x2f93a5=0x0;_0x2f93a5<_0x3e7457[_0x0e17('0x3c')];_0x2f93a5++){var _0x18e676=_0x0e17('0x38')+_0x3e7457[_0x2f93a5]['id'];_0x286921[_0x18e676][_0x0e17('0x99')]=_0x18e676;_0x286921[_0x18e676]['displayName']=_0x3e7457[_0x2f93a5][_0x0e17('0x9c')];_0x286921[_0x18e676][_0x0e17('0x9d')]={'type':_0x3e7457[_0x2f93a5][_0x0e17('0x3e')],'values':_0x3e7457[_0x2f93a5][_0x0e17('0x9e')]};}Object[_0x0e17('0x37')](_0x286921)[_0x0e17('0x5a')](function(_0x1d8d8c){if(!_0x286921[_0x1d8d8c][_0x0e17('0x45')](_0x0e17('0x99'))){delete _0x286921[_0x1d8d8c];}});return _0x286921;});})[_0x0e17('0x2d')](respondWithResult(_0x57f289,null))[_0x0e17('0x96')](handleError(_0x57f289,null));};exports[_0x0e17('0x30')]=function(_0x36cee0,_0x224e0b){var _0x371bcc;var _0x3a6903;var _0x30d43b;if(_0x36cee0[_0x0e17('0x31')]['id']){delete _0x36cee0[_0x0e17('0x31')]['id'];}return db[_0x0e17('0x35')][_0x0e17('0x9b')]({'where':{'id':[_0x36cee0[_0x0e17('0x31')]['to'],_0x36cee0[_0x0e17('0x31')]['from']]}})[_0x0e17('0x2d')](function(_0x59f990){if(_0x59f990){if(_0x59f990[_0x0e17('0x3c')]!==0x2){return null;}_0x59f990[0x0]=_0x59f990[0x0][_0x0e17('0x9f')]({'plain':!![]});_0x59f990[0x1]=_0x59f990[0x1][_0x0e17('0x9f')]({'plain':!![]});delete _0x59f990[0x0]['id'];delete _0x59f990[0x1]['id'];return _['mergeWith'](_0x59f990[0x0],_0x59f990[0x1],function(_0x552981,_0x4227c6){if(Array['isArray'](_0x4227c6)&&!_0x4227c6['length']){return _0x552981;}else if(!_0x4227c6){return _0x552981;}});}})[_0x0e17('0x2d')](handleEntityNotFound(_0x224e0b,null))[_0x0e17('0x2d')](function(_0x16e5d9){if(_0x16e5d9){if(_0x16e5d9['tags']&&_[_0x0e17('0x6e')](_0x16e5d9[_0x0e17('0x97')])){_0x16e5d9['tags']=_0x16e5d9[_0x0e17('0x97')][_0x0e17('0xa0')]();}logger[_0x0e17('0xa1')](_0x0e17('0xa2'),_0x36cee0[_0x0e17('0x31')]['to'],_0x36cee0[_0x0e17('0x31')]['from']);return db['CmHopper'][_0x0e17('0x94')]({'where':{'ContactId':[_0x36cee0[_0x0e17('0x31')]['to'],_0x36cee0[_0x0e17('0x31')]['from']]}})[_0x0e17('0x2d')](function(_0x141ace){logger[_0x0e17('0xa1')](_0x0e17('0xa3'),_0x141ace);return db[_0x0e17('0xa4')][_0x0e17('0x94')]({'where':{'ContactId':[_0x36cee0[_0x0e17('0x31')]['to'],_0x36cee0['body']['from']]}})[_0x0e17('0x2d')](function(_0x2a0ebf){logger[_0x0e17('0xa1')](_0x0e17('0xa5'),_0x2a0ebf);return db['CmContact'][_0x0e17('0xa6')](_0x16e5d9);});});}})[_0x0e17('0x2d')](function(_0x7dcb9d){if(_0x7dcb9d){_0x371bcc=_0x7dcb9d;_0x3a6903={'ContactId':_0x371bcc['id']};_0x30d43b={'where':{'ContactId':[_0x36cee0[_0x0e17('0x31')]['to'],_0x36cee0[_0x0e17('0x31')][_0x0e17('0x4d')]]}};return db[_0x0e17('0xa7')]['update'](_0x3a6903,_0x30d43b);}})[_0x0e17('0x2d')](function(){if(_0x371bcc){return db[_0x0e17('0xa8')][_0x0e17('0x2c')](_0x3a6903,_0x30d43b);}})[_0x0e17('0x2d')](function(){if(_0x371bcc){return db['ChatOfflineMessage']['update'](_0x3a6903,_0x30d43b);}})[_0x0e17('0x2d')](function(){if(_0x371bcc){return db[_0x0e17('0xa9')]['update'](_0x3a6903,_0x30d43b);}})['then'](function(){if(_0x371bcc){return db[_0x0e17('0xaa')][_0x0e17('0x2c')](_0x3a6903,_0x30d43b);}})[_0x0e17('0x2d')](function(){if(_0x371bcc){return db[_0x0e17('0xa9')][_0x0e17('0x2c')](_0x3a6903,_0x30d43b);}})[_0x0e17('0x2d')](function(){if(_0x371bcc){return db[_0x0e17('0xaa')][_0x0e17('0x2c')](_0x3a6903,_0x30d43b);}})['then'](function(){if(_0x371bcc){return db[_0x0e17('0xab')][_0x0e17('0x2c')](_0x3a6903,_0x30d43b);}})[_0x0e17('0x2d')](function(){if(_0x371bcc){return db[_0x0e17('0xac')][_0x0e17('0x2c')](_0x3a6903,_0x30d43b);}})[_0x0e17('0x2d')](function(){if(_0x371bcc){return db[_0x0e17('0xad')][_0x0e17('0x2c')](_0x3a6903,_0x30d43b);}})[_0x0e17('0x2d')](function(){if(_0x371bcc){return db[_0x0e17('0xae')][_0x0e17('0x2c')](_0x3a6903,_0x30d43b);}})[_0x0e17('0x2d')](function(){if(_0x371bcc){return db[_0x0e17('0xaf')][_0x0e17('0x2c')](_0x3a6903,_0x30d43b);}})[_0x0e17('0x2d')](function(){if(_0x371bcc){return db[_0x0e17('0xb0')]['update'](_0x3a6903,_0x30d43b);}})[_0x0e17('0x2d')](function(){if(_0x371bcc){return db[_0x0e17('0xb1')][_0x0e17('0x2c')](_0x3a6903,_0x30d43b);}})[_0x0e17('0x2d')](function(){if(_0x371bcc){return db[_0x0e17('0xb2')][_0x0e17('0x2c')](_0x3a6903,_0x30d43b);}})[_0x0e17('0x2d')](function(){if(_0x371bcc){return db[_0x0e17('0xb3')][_0x0e17('0x2c')](_0x3a6903,_0x30d43b);}})[_0x0e17('0x2d')](function(){if(_0x371bcc){return db[_0x0e17('0xb4')][_0x0e17('0x2c')](_0x3a6903,_0x30d43b);}})[_0x0e17('0x2d')](function(){if(_0x371bcc){return db[_0x0e17('0xb5')][_0x0e17('0x2c')](_0x3a6903,_0x30d43b);}})[_0x0e17('0x2d')](function(){if(_0x371bcc){return db['FaxQueueReport']['update'](_0x3a6903,_0x30d43b);}})[_0x0e17('0x2d')](function(){if(_0x371bcc){return db['MailQueueReport']['update'](_0x3a6903,_0x30d43b);}})[_0x0e17('0x2d')](function(){if(_0x371bcc){return db[_0x0e17('0xb6')][_0x0e17('0x2c')](_0x3a6903,_0x30d43b);}})['then'](function(){if(_0x371bcc){return db[_0x0e17('0xb7')][_0x0e17('0x2c')](_0x3a6903,_0x30d43b);}})['then'](function(){if(_0x371bcc){return db[_0x0e17('0xb8')][_0x0e17('0x2c')](_0x3a6903,_0x30d43b);}})[_0x0e17('0x2d')](function(){if(_0x371bcc){return db[_0x0e17('0xb9')][_0x0e17('0x2c')](_0x3a6903,_0x30d43b);}})[_0x0e17('0x2d')](function(){if(_0x371bcc){return db['WhatsappMessage'][_0x0e17('0x2c')](_0x3a6903,_0x30d43b);}})[_0x0e17('0x2d')](function(){if(_0x371bcc){return db[_0x0e17('0xba')]['update'](_0x3a6903,_0x30d43b);}})['then'](function(){if(_0x371bcc){return db[_0x0e17('0x35')][_0x0e17('0x94')]({'where':{'id':[_0x36cee0[_0x0e17('0x31')]['to'],_0x36cee0[_0x0e17('0x31')][_0x0e17('0x4d')]]}});}})['then'](function(){if(_0x371bcc){return _0x371bcc;}})['then'](respondWithResult(_0x224e0b,null))[_0x0e17('0x96')](handleError(_0x224e0b,null));};exports[_0x0e17('0xa6')]=function(_0x3915f3,_0x1b749b){return db['CmContact'][_0x0e17('0x36')]()['then'](function(_0x4874fa){if(_0x3915f3[_0x0e17('0x31')][_0x0e17('0x97')]&&_[_0x0e17('0x6e')](_0x3915f3[_0x0e17('0x31')]['tags'])){if(_0x3915f3[_0x0e17('0x31')][_0x0e17('0x97')][_0x0e17('0x3c')]){_0x3915f3[_0x0e17('0x31')][_0x0e17('0x97')]=_0x3915f3[_0x0e17('0x31')]['tags'][_0x0e17('0xa0')](';')+';';}else{_0x3915f3[_0x0e17('0x31')][_0x0e17('0x97')]=null;}}else{_0x3915f3['body'][_0x0e17('0x97')]=null;}return db['CmContact']['create'](_0x3915f3['body'],{'fields':_[_0x0e17('0x37')](_0x4874fa),'raw':!![]});})[_0x0e17('0x2d')](respondWithResult(_0x1b749b,0xc9))[_0x0e17('0x96')](handleError(_0x1b749b,null));};exports[_0x0e17('0xbb')]=function(_0x59fb64,_0x5c9189){var _0x283499=[];var _0x480e62=0x0;var _0x5f3ff3=0x0;var _0x5b9c3d=0x0;return db[_0x0e17('0x35')][_0x0e17('0x36')]()[_0x0e17('0x2d')](function(_0x21d69d){return BPromise[_0x0e17('0xbc')](_0x59fb64[_0x0e17('0x31')],function(_0x4c66f3){var _0x3755e1={'where':{'$or':[]},'defaults':_0x4c66f3,'fields':_[_0x0e17('0x37')](_0x21d69d),'raw':!![]};if(_0x4c66f3[_0x0e17('0xbd')]){for(var _0x4837f3=0x0;_0x4837f3<_0x4c66f3[_0x0e17('0xbd')][_0x0e17('0x3c')];_0x4837f3++){var _0x4976eb={};_0x4976eb[_0x4c66f3[_0x0e17('0xbd')][_0x4837f3]]=_0x4c66f3[_0x4c66f3['duplicates'][_0x4837f3]];_0x3755e1[_0x0e17('0x52')][_0x0e17('0xbe')]['push'](_0x4976eb);}_0x3755e1[_0x0e17('0x52')][_0x0e17('0x6a')]=_0x4c66f3['ListId'];}return db[_0x0e17('0x35')]['findOrCreate'](_0x3755e1)['spread'](function(_0x38c147,_0x3c858f){if(_0x3c858f){_0x480e62++;}else{_0x5b9c3d++;}})[_0x0e17('0x96')](function(_0x3bb901){console['error'](_0x3bb901);_0x5f3ff3++;});});})[_0x0e17('0x2d')](function(_0x34db9b){if(_0x34db9b){return{'success':_0x480e62,'failure':_0x5f3ff3,'duplicates':_0x5b9c3d};}})[_0x0e17('0x2d')](respondWithResult(_0x5c9189,0xc9))[_0x0e17('0x96')](handleError(_0x5c9189,null));};exports[_0x0e17('0xbf')]=function(_0x4919d6,_0x4f9138,_0x31c07f){var _0x118665;return db[_0x0e17('0x35')][_0x0e17('0x36')]()[_0x0e17('0x2d')](function(_0x4a9379){return db[_0x0e17('0x35')][_0x0e17('0x56')]({'where':{'id':_0x4919d6[_0x0e17('0x95')]['id']},'include':[{'model':db[_0x0e17('0xc0')],'as':_0x0e17('0x92'),'attributes':['id',_0x0e17('0x2e'),'color'],'required':_0x4919d6[_0x0e17('0x42')][_0x0e17('0x6f')]?!![]:![]}],'attributes':_[_0x0e17('0x37')](_0x4a9379)});})[_0x0e17('0x2d')](function(_0x532775){_0x118665=_0x532775[_0x0e17('0x9f')]({'plain':!![]});var _0x230996={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x532775&&_0x532775[_0x0e17('0x6a')]){if(_0x532775[_0x0e17('0x6a')]){_0x230996[_0x0e17('0x52')][_0x0e17('0xc1')][_0x0e17('0x39')]({'ListId':{'$ne':_0x532775['ListId']}});}}return db[_0x0e17('0x9a')]['findAll'](_0x230996);})['then'](function(_0x8f3758){return _['omit'](_0x118665,_[_0x0e17('0x59')](_0x8f3758,function(_0x5ed8ee){return util[_0x0e17('0xc2')](_0x0e17('0xc3'),_0x5ed8ee['id']);}));})['then'](handleEntityNotFound(_0x4f9138,null))['then'](respondWithResult(_0x4f9138,null))['catch'](handleError(_0x4f9138,null));};exports[_0x0e17('0x2c')]=function(_0x4516f9,_0x188892){var _0x3d3b1e;if(_0x4516f9[_0x0e17('0x31')]['id']){delete _0x4516f9['body']['id'];}return db[_0x0e17('0x35')][_0x0e17('0x56')]({'where':{'id':_0x4516f9[_0x0e17('0x95')]['id']}})[_0x0e17('0x2d')](handleEntityNotFound(_0x188892,null))[_0x0e17('0x2d')](saveUpdates(_0x4516f9[_0x0e17('0x31')],null))[_0x0e17('0x2d')](function(_0x2a78ca){_0x3d3b1e=_0x2a78ca;var _0x48e2b7={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x2a78ca&&_0x2a78ca['ListId']){if(_0x2a78ca[_0x0e17('0x6a')]){_0x48e2b7['where']['$and'][_0x0e17('0x39')]({'ListId':{'$ne':_0x2a78ca[_0x0e17('0x6a')]}});}}return db[_0x0e17('0x9a')][_0x0e17('0x9b')](_0x48e2b7);})[_0x0e17('0x2d')](function(_0x473239){if(_0x473239){return _['omit'](_[_0x0e17('0xc4')](_0x4516f9[_0x0e17('0x31')],function(_0x384ebb,_0x4c1c05){return _[_0x0e17('0x98')](_0x4c1c05,_0x0e17('0x38'));}),_['map'](_0x473239,function(_0x3c08ba){return util[_0x0e17('0xc2')]('cf_%d',_0x3c08ba['id']);}));}})[_0x0e17('0x2d')](function(_0x59550c){if(_0x59550c&&!_[_0x0e17('0x69')](_0x59550c)){var _0x51002a=squel['update']()[_0x0e17('0xc5')]('cm_contacts')[_0x0e17('0xc6')](_0x59550c)[_0x0e17('0x52')](_0x0e17('0xc7'),_0x4516f9[_0x0e17('0x95')]['id'])['toParam']();return db[_0x0e17('0xc8')][_0x0e17('0x42')](_0x51002a['text'],{'replacements':_0x51002a[_0x0e17('0x9e')]});}})[_0x0e17('0x2d')](function(){if(_0x4516f9[_0x0e17('0x31')]['phone']&&_0x3d3b1e){return db[_0x0e17('0xc9')][_0x0e17('0x2c')]({'phone':_0x4516f9[_0x0e17('0x31')][_0x0e17('0xca')]},{'where':{'ContactId':_0x3d3b1e['id']}});}})[_0x0e17('0x2d')](function(){return _0x3d3b1e;})['then'](respondWithResult(_0x188892,null))['catch'](handleError(_0x188892,null));};exports[_0x0e17('0xcb')]=function(_0x3b85ab,_0x31ae70,_0xf49994){var _0x2ff5a3={};var _0x40c9c3={};var _0x37b6b9;var _0x56b445;return db[_0x0e17('0x35')][_0x0e17('0x3a')]({'where':{'id':_0x3b85ab['params']['id']}})[_0x0e17('0x2d')](handleEntityNotFound(_0x31ae70,null))[_0x0e17('0x2d')](function(_0x5e2c55){if(_0x5e2c55){_0x37b6b9=_0x5e2c55;_0x40c9c3['model']=_[_0x0e17('0x37')](db['Tag']['rawAttributes']);_0x40c9c3['query']=_[_0x0e17('0x37')](_0x3b85ab['query']);_0x40c9c3[_0x0e17('0x40')]=_[_0x0e17('0x41')](_0x40c9c3['model'],_0x40c9c3[_0x0e17('0x42')]);_0x2ff5a3[_0x0e17('0x43')]=_[_0x0e17('0x41')](_0x40c9c3['model'],qs['fields'](_0x3b85ab[_0x0e17('0x42')][_0x0e17('0x44')]));_0x2ff5a3['attributes']=_0x2ff5a3[_0x0e17('0x43')][_0x0e17('0x3c')]?_0x2ff5a3[_0x0e17('0x43')]:_0x40c9c3[_0x0e17('0x3f')];_0x2ff5a3[_0x0e17('0x47')]=qs[_0x0e17('0x48')](_0x3b85ab[_0x0e17('0x42')]['sort']);_0x2ff5a3[_0x0e17('0x52')]=qs[_0x0e17('0x40')](_[_0x0e17('0x49')](_0x3b85ab['query'],_0x40c9c3['filters']));if(_0x3b85ab['query']['filter']){_0x2ff5a3['where']=_['merge'](_0x2ff5a3[_0x0e17('0x52')],{'$or':_[_0x0e17('0x59')](_0x2ff5a3[_0x0e17('0x43')],function(_0x44df82){var _0x243c6b={};_0x243c6b[_0x44df82]={'$like':'%'+_0x3b85ab[_0x0e17('0x42')][_0x0e17('0x66')]+'%'};return _0x243c6b;})});}_0x2ff5a3=_[_0x0e17('0x30')]({},_0x2ff5a3,_0x3b85ab['options']);return _0x37b6b9[_0x0e17('0xcb')](_0x2ff5a3);}})[_0x0e17('0x2d')](function(_0x1f0df5){if(_0x1f0df5){_0x56b445=_0x1f0df5[_0x0e17('0x3c')];if(!_0x3b85ab[_0x0e17('0x42')][_0x0e17('0x45')](_0x0e17('0x46'))){_0x2ff5a3[_0x0e17('0x26')]=qs[_0x0e17('0x26')](_0x3b85ab[_0x0e17('0x42')]['limit']);_0x2ff5a3[_0x0e17('0x23')]=qs[_0x0e17('0x23')](_0x3b85ab[_0x0e17('0x42')]['offset']);}return _0x37b6b9[_0x0e17('0xcb')](_0x2ff5a3);}})[_0x0e17('0x2d')](function(_0x32fc01){if(_0x32fc01){return _0x32fc01?{'count':_0x56b445,'rows':_0x32fc01}:null;}})[_0x0e17('0x2d')](respondWithResult(_0x31ae70,null))[_0x0e17('0x96')](handleError(_0x31ae70,null));};exports[_0x0e17('0xcc')]=function(_0xfe0fd3,_0xd15426,_0x52f089){if(_0xfe0fd3[_0x0e17('0x31')]['id']){delete _0xfe0fd3[_0x0e17('0x31')]['id'];}return db['CmContact']['findOne']({'where':{'id':_0xfe0fd3[_0x0e17('0x95')]['id']}})['then'](handleEntityNotFound(_0xd15426,null))['then'](function(_0x35378b){if(_0x35378b){return _0x35378b[_0x0e17('0xcc')](_0xfe0fd3[_0x0e17('0x31')][_0x0e17('0xcd')]||[]);}return null;})[_0x0e17('0x2d')](respondWithResult(_0xd15426,null))[_0x0e17('0x96')](handleError(_0xd15426,null));};exports[_0x0e17('0xce')]=function(_0x62adce,_0x225bdc,_0x4034cd){var _0x23bd58={'raw':![],'where':{}};var _0x3ca85e={};var _0x496676={'count':0x0,'rows':[]};return db[_0x0e17('0x35')][_0x0e17('0x3a')]({'where':{'id':_0x62adce[_0x0e17('0x95')]['id']}})[_0x0e17('0x2d')](handleEntityNotFound(_0x225bdc,null))[_0x0e17('0x2d')](function(_0x18fe78){if(_0x18fe78){_0x3ca85e[_0x0e17('0x3f')]=_[_0x0e17('0x37')](db[_0x0e17('0xc9')]['rawAttributes']);_0x3ca85e[_0x0e17('0x42')]=_[_0x0e17('0x37')](_0x62adce[_0x0e17('0x42')]);_0x3ca85e[_0x0e17('0x40')]=_[_0x0e17('0x41')](_0x3ca85e[_0x0e17('0x3f')],_0x3ca85e[_0x0e17('0x42')]);_0x23bd58['attributes']=_[_0x0e17('0x41')](_0x3ca85e[_0x0e17('0x3f')],qs[_0x0e17('0x44')](_0x62adce['query'][_0x0e17('0x44')]));_0x23bd58['attributes']=_0x23bd58[_0x0e17('0x43')][_0x0e17('0x3c')]?_0x23bd58[_0x0e17('0x43')]:_0x3ca85e['model'];if(!_0x62adce[_0x0e17('0x42')][_0x0e17('0x45')](_0x0e17('0x46'))){_0x23bd58[_0x0e17('0x26')]=qs[_0x0e17('0x26')](_0x62adce[_0x0e17('0x42')]['limit']);_0x23bd58[_0x0e17('0x23')]=qs[_0x0e17('0x23')](_0x62adce[_0x0e17('0x42')][_0x0e17('0x23')]);}_0x23bd58[_0x0e17('0x47')]=qs['sort'](_0x62adce['query']['sort']);_0x23bd58[_0x0e17('0x52')]=qs[_0x0e17('0x40')](_[_0x0e17('0x49')](_0x62adce[_0x0e17('0x42')],_0x3ca85e[_0x0e17('0x40')]));_0x23bd58[_0x0e17('0x52')][_0x0e17('0xcf')]=_0x18fe78['id'];if(_0x62adce[_0x0e17('0x42')][_0x0e17('0x66')]){_0x23bd58[_0x0e17('0x52')]=_[_0x0e17('0x30')](_0x23bd58[_0x0e17('0x52')],{'$or':_[_0x0e17('0x59')](_0x23bd58[_0x0e17('0x43')],function(_0x4e3fd9){var _0xb952c4={};_0xb952c4[_0x4e3fd9]={'$like':'%'+_0x62adce[_0x0e17('0x42')][_0x0e17('0x66')]+'%'};return _0xb952c4;})});}_0x23bd58=_['merge']({},_0x23bd58,_0x62adce[_0x0e17('0xd0')]);return db[_0x0e17('0xc9')]['count']({'where':_0x23bd58['where']})[_0x0e17('0x2d')](function(_0x32344e){_0x496676[_0x0e17('0x25')]=_0x32344e;if(_0x62adce[_0x0e17('0x42')]['includeAll']){_0x23bd58[_0x0e17('0xd1')]=[{'all':!![]}];}return db[_0x0e17('0xc9')][_0x0e17('0x9b')](_0x23bd58);})[_0x0e17('0x2d')](function(_0x1224c2){_0x496676[_0x0e17('0x93')]=_0x1224c2;return _0x496676;});}})[_0x0e17('0x2d')](respondWithFilteredResult(_0x225bdc,_0x23bd58))[_0x0e17('0x96')](handleError(_0x225bdc,null));};exports[_0x0e17('0xd2')]=function(_0x1e4db1,_0x59b51e,_0x168f61){var _0x478769={'raw':!![],'where':{}};var _0x95d4e4={};var _0x41e912={'count':0x0,'rows':[]};return db[_0x0e17('0x35')][_0x0e17('0x3a')]({'where':{'id':_0x1e4db1[_0x0e17('0x95')]['id']}})[_0x0e17('0x2d')](handleEntityNotFound(_0x59b51e,null))['then'](function(_0x5904d5){if(_0x5904d5){_0x95d4e4['model']=_[_0x0e17('0x37')](db['CmHopperHistory'][_0x0e17('0xd3')]);_0x95d4e4[_0x0e17('0x42')]=_[_0x0e17('0x37')](_0x1e4db1[_0x0e17('0x42')]);_0x95d4e4[_0x0e17('0x40')]=_[_0x0e17('0x41')](_0x95d4e4['model'],_0x95d4e4[_0x0e17('0x42')]);_0x478769[_0x0e17('0x43')]=_[_0x0e17('0x41')](_0x95d4e4['model'],qs[_0x0e17('0x44')](_0x1e4db1[_0x0e17('0x42')]['fields']));_0x478769[_0x0e17('0x43')]=_0x478769[_0x0e17('0x43')][_0x0e17('0x3c')]?_0x478769['attributes']:_0x95d4e4[_0x0e17('0x3f')];if(!_0x1e4db1[_0x0e17('0x42')][_0x0e17('0x45')](_0x0e17('0x46'))){_0x478769['limit']=qs['limit'](_0x1e4db1[_0x0e17('0x42')][_0x0e17('0x26')]);_0x478769['offset']=qs[_0x0e17('0x23')](_0x1e4db1[_0x0e17('0x42')][_0x0e17('0x23')]);}_0x478769[_0x0e17('0x47')]=qs['sort'](_0x1e4db1[_0x0e17('0x42')][_0x0e17('0x48')]);_0x478769[_0x0e17('0x52')]=qs[_0x0e17('0x40')](_['pick'](_0x1e4db1[_0x0e17('0x42')],_0x95d4e4[_0x0e17('0x40')]));_0x478769[_0x0e17('0x52')][_0x0e17('0xcf')]=_0x5904d5['id'];if(_0x1e4db1[_0x0e17('0x42')][_0x0e17('0x66')]){_0x478769['where']=_[_0x0e17('0x30')](_0x478769[_0x0e17('0x52')],{'$or':_[_0x0e17('0x59')](_0x478769[_0x0e17('0x43')],function(_0x53b6d0){var _0x414db0={};_0x414db0[_0x53b6d0]={'$like':'%'+_0x1e4db1['query'][_0x0e17('0x66')]+'%'};return _0x414db0;})});}_0x478769=_['merge']({},_0x478769,_0x1e4db1[_0x0e17('0xd0')]);return db[_0x0e17('0xb2')]['count']({'where':_0x478769['where']})[_0x0e17('0x2d')](function(_0x1847ac){_0x41e912[_0x0e17('0x25')]=_0x1847ac;if(_0x1e4db1[_0x0e17('0x42')][_0x0e17('0xd4')]){_0x478769[_0x0e17('0xd1')]=[{'all':!![]}];}return db[_0x0e17('0xb2')]['findAll'](_0x478769);})[_0x0e17('0x2d')](function(_0xe83197){_0x41e912['rows']=_0xe83197;return _0x41e912;});}})[_0x0e17('0x2d')](respondWithFilteredResult(_0x59b51e,_0x478769))[_0x0e17('0x96')](handleError(_0x59b51e,null));};exports[_0x0e17('0xd5')]=function(_0x3999ff,_0x51822f,_0x1755b7){var _0x4aec4e={'raw':!![],'where':{}};var _0x51f69a={};var _0x3dacde={'count':0x0,'rows':[]};return db[_0x0e17('0x35')][_0x0e17('0x3a')]({'where':{'id':_0x3999ff[_0x0e17('0x95')]['id']}})[_0x0e17('0x2d')](handleEntityNotFound(_0x51822f,null))[_0x0e17('0x2d')](function(_0x2ebd22){if(_0x2ebd22){_0x51f69a[_0x0e17('0x3f')]=_[_0x0e17('0x37')](db[_0x0e17('0xb1')]['rawAttributes']);_0x51f69a[_0x0e17('0x42')]=_['keys'](_0x3999ff['query']);_0x51f69a[_0x0e17('0x40')]=_['intersection'](_0x51f69a['model'],_0x51f69a[_0x0e17('0x42')]);_0x4aec4e['attributes']=_[_0x0e17('0x41')](_0x51f69a['model'],qs[_0x0e17('0x44')](_0x3999ff[_0x0e17('0x42')][_0x0e17('0x44')]));_0x4aec4e[_0x0e17('0x43')]=_0x4aec4e[_0x0e17('0x43')]['length']?_0x4aec4e['attributes']:_0x51f69a[_0x0e17('0x3f')];if(!_0x3999ff[_0x0e17('0x42')][_0x0e17('0x45')](_0x0e17('0x46'))){_0x4aec4e[_0x0e17('0x26')]=qs[_0x0e17('0x26')](_0x3999ff[_0x0e17('0x42')]['limit']);_0x4aec4e[_0x0e17('0x23')]=qs[_0x0e17('0x23')](_0x3999ff['query']['offset']);}_0x4aec4e[_0x0e17('0x47')]=qs['sort'](_0x3999ff[_0x0e17('0x42')]['sort']);_0x4aec4e['where']=qs[_0x0e17('0x40')](_[_0x0e17('0x49')](_0x3999ff[_0x0e17('0x42')],_0x51f69a[_0x0e17('0x40')]));_0x4aec4e[_0x0e17('0x52')][_0x0e17('0xcf')]=_0x2ebd22['id'];if(_0x3999ff[_0x0e17('0x42')]['filter']){_0x4aec4e['where']=_[_0x0e17('0x30')](_0x4aec4e[_0x0e17('0x52')],{'$or':_[_0x0e17('0x59')](_0x4aec4e['attributes'],function(_0x5d113f){var _0x2e6b70={};_0x2e6b70[_0x5d113f]={'$like':'%'+_0x3999ff['query']['filter']+'%'};return _0x2e6b70;})});}_0x4aec4e=_[_0x0e17('0x30')]({},_0x4aec4e,_0x3999ff[_0x0e17('0xd0')]);return db[_0x0e17('0xb1')][_0x0e17('0x25')]({'where':_0x4aec4e['where']})[_0x0e17('0x2d')](function(_0x877d57){_0x3dacde[_0x0e17('0x25')]=_0x877d57;if(_0x3999ff[_0x0e17('0x42')][_0x0e17('0xd4')]){_0x4aec4e[_0x0e17('0xd1')]=[{'all':!![]}];}return db[_0x0e17('0xb1')]['findAll'](_0x4aec4e);})[_0x0e17('0x2d')](function(_0x4d9baa){_0x3dacde[_0x0e17('0x93')]=_0x4d9baa;return _0x3dacde;});}})[_0x0e17('0x2d')](respondWithFilteredResult(_0x51822f,_0x4aec4e))['catch'](handleError(_0x51822f,null));};exports['getJscriptySessions']=function(_0x41ccf6,_0x2d67e6,_0x43cb05){var _0x3de163={'raw':!![],'where':{}};var _0x32fb65={};var _0x335d7f={'count':0x0,'rows':[]};return db[_0x0e17('0x35')][_0x0e17('0x3a')]({'where':{'id':_0x41ccf6[_0x0e17('0x95')]['id']}})['then'](handleEntityNotFound(_0x2d67e6,null))[_0x0e17('0x2d')](function(_0x360582){if(_0x360582){_0x32fb65['model']=_[_0x0e17('0x37')](db['JscriptySessionReport'][_0x0e17('0xd3')]);_0x32fb65[_0x0e17('0x42')]=_[_0x0e17('0x37')](_0x41ccf6[_0x0e17('0x42')]);_0x32fb65[_0x0e17('0x40')]=_['intersection'](_0x32fb65[_0x0e17('0x3f')],_0x32fb65[_0x0e17('0x42')]);_0x3de163['attributes']=_['intersection'](_0x32fb65[_0x0e17('0x3f')],qs[_0x0e17('0x44')](_0x41ccf6[_0x0e17('0x42')][_0x0e17('0x44')]));_0x3de163[_0x0e17('0x43')]=_0x3de163[_0x0e17('0x43')]['length']?_0x3de163[_0x0e17('0x43')]:_0x32fb65['model'];if(!_0x41ccf6[_0x0e17('0x42')]['hasOwnProperty'](_0x0e17('0x46'))){_0x3de163['limit']=qs[_0x0e17('0x26')](_0x41ccf6[_0x0e17('0x42')][_0x0e17('0x26')]);_0x3de163[_0x0e17('0x23')]=qs[_0x0e17('0x23')](_0x41ccf6['query'][_0x0e17('0x23')]);}_0x3de163['order']=qs[_0x0e17('0x48')](_0x41ccf6[_0x0e17('0x42')][_0x0e17('0x48')]);_0x3de163[_0x0e17('0x52')]=qs[_0x0e17('0x40')](_[_0x0e17('0x49')](_0x41ccf6[_0x0e17('0x42')],_0x32fb65['filters']));_0x3de163[_0x0e17('0x52')][_0x0e17('0xcf')]=_0x360582['id'];if(_0x41ccf6['query']['filter']){_0x3de163[_0x0e17('0x52')]=_[_0x0e17('0x30')](_0x3de163[_0x0e17('0x52')],{'$or':_[_0x0e17('0x59')](_0x3de163[_0x0e17('0x43')],function(_0x37c48d){var _0x1e31f6={};_0x1e31f6[_0x37c48d]={'$like':'%'+_0x41ccf6['query']['filter']+'%'};return _0x1e31f6;})});}_0x3de163=_['merge']({},_0x3de163,_0x41ccf6[_0x0e17('0xd0')]);return db[_0x0e17('0xb8')][_0x0e17('0x25')]({'where':_0x3de163[_0x0e17('0x52')]})['then'](function(_0x35ed64){_0x335d7f[_0x0e17('0x25')]=_0x35ed64;if(_0x41ccf6[_0x0e17('0x42')][_0x0e17('0xd4')]){_0x3de163[_0x0e17('0xd1')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0x0e17('0x9b')](_0x3de163);})[_0x0e17('0x2d')](function(_0x546e8e){_0x335d7f[_0x0e17('0x93')]=_0x546e8e;return _0x335d7f;});}})[_0x0e17('0x2d')](respondWithFilteredResult(_0x2d67e6,_0x3de163))[_0x0e17('0x96')](handleError(_0x2d67e6,null));};exports[_0x0e17('0xd6')]=function(_0x3d14d8,_0x33729e,_0x5f33c3){try{if(!_0x3d14d8[_0x0e17('0x31')][_0x0e17('0x6a')]){throw new Error(_0x0e17('0xd7'));}if(!_0x3d14d8[_0x0e17('0x31')][_0x0e17('0xd8')]){throw new Error(_0x0e17('0xd9'));}if(!_0x3d14d8[_0x0e17('0x31')][_0x0e17('0xda')]){throw new Error(_0x0e17('0xdb'));}if(!_0x3d14d8[_0x0e17('0x31')][_0x0e17('0xdc')]){throw new Error(_0x0e17('0xdd'));}var _0x57ad2d=_0x3d14d8[_0x0e17('0x31')][_0x0e17('0xd8')][_0x0e17('0x58')](',');var _0x5abd0c=_0x3d14d8[_0x0e17('0x31')][_0x0e17('0xda')][_0x0e17('0x58')](',');if(!_0x57ad2d[_0x0e17('0x3c')]||!_0x5abd0c[_0x0e17('0x3c')]||_0x57ad2d[_0x0e17('0x3c')]!==_0x5abd0c['length']){throw new Error(_0x0e17('0xde'));}_0x3d14d8[_0x0e17('0x31')][_0x0e17('0x44')]=_[_0x0e17('0xdf')](_0x57ad2d,_0x5abd0c);if(!_0x3d14d8[_0x0e17('0x31')][_0x0e17('0x44')][_0x0e17('0xca')]){throw new Error(_0x0e17('0xe0'));}if(!_0x3d14d8[_0x0e17('0x31')]['fields'][_0x0e17('0xe1')]){throw new Error(_0x0e17('0xe2'));}var _0x6aff77=path[_0x0e17('0xa0')](config['root'],'server/files/tmp',_0x3d14d8['file'][_0x0e17('0xe3')]);fs['chmodSync'](_0x6aff77,parseInt(_0x0e17('0xe4'),0x8));var _0x37b565=require(_0x0e17('0xe5'))[_0x0e17('0xe6')](path[_0x0e17('0xa0')](__dirname,'../../components/import/cm/csv'),[_0x6aff77,_0x3d14d8[_0x0e17('0x31')][_0x0e17('0xd8')],_0x3d14d8[_0x0e17('0x31')][_0x0e17('0xda')],_0x3d14d8[_0x0e17('0x31')][_0x0e17('0x6a')],_0x3d14d8['body'][_0x0e17('0xe7')],_0x3d14d8['body'][_0x0e17('0xbd')],_0x3d14d8['body'][_0x0e17('0xdc')]]);return _0x33729e[_0x0e17('0x20')](0xc8)[_0x0e17('0x22')]({'message':_0x0e17('0xe8'),'pid':_0x37b565[_0x0e17('0xe9')]});}catch(_0x1645dc){return _0x33729e[_0x0e17('0x20')](0x1f4)[_0x0e17('0x2f')](_0x1645dc);}};exports['upload']=function(_0x1a2245,_0x358d8f,_0x42b279){var _0x2b23f9=fs['createReadStream'](_0x1a2245[_0x0e17('0xea')][_0x0e17('0x5')]);Papa[_0x0e17('0xeb')](_0x2b23f9,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x5f57e3){return _0x358d8f[_0x0e17('0x20')](0xc8)[_0x0e17('0x22')]({'file':_0x1a2245['file'],'fields':_0x5f57e3[_0x0e17('0xec')]['fields']});}});};exports[_0x0e17('0xed')]=function(_0x1e58d1,_0x3d9f42,_0x19ef70){return db[_0x0e17('0x5d')][_0x0e17('0x9b')]({'raw':!![],'attributes':['id'],'where':{'role':_0x0e17('0x87')}})['then'](function(_0x306893){var _0x5ac5fe=![];if(!_0x1e58d1[_0x0e17('0x31')][_0x0e17('0x6a')]){throw new Error(_0x0e17('0xd7'));}if(!_0x1e58d1[_0x0e17('0x31')][_0x0e17('0xee')][_0x0e17('0xca')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x1e58d1[_0x0e17('0x31')][_0x0e17('0xee')][_0x0e17('0xe1')]){throw new Error(_0x0e17('0xe2'));}if(!_0x1e58d1[_0x0e17('0x31')]['socket_timestamp']){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x22ab52=require(_0x0e17('0xe5'))[_0x0e17('0xe6')](path[_0x0e17('0xa0')](__dirname,_0x0e17('0xef')),[_0x1e58d1[_0x0e17('0x95')]['id'],JSON[_0x0e17('0xf0')](_0x1e58d1[_0x0e17('0x31')]),JSON['stringify'](_0x306893)]);_0x22ab52['on']('message',function(_0x5aa63d){_0x5ac5fe=!![];return _0x3d9f42[_0x0e17('0x20')](0xc8)[_0x0e17('0x22')]({'message':'start\x20child\x20process\x20correctly!','pid':_0x22ab52[_0x0e17('0xe9')]});});_0x22ab52['on']('exit',function(_0x460633){if(_0x460633&&!_0x5ac5fe){return _0x3d9f42['status'](0x1f4)[_0x0e17('0x22')]({'message':_0x0e17('0xf1'),'pid':_0x22ab52['pid']});}});})['catch'](handleError(_0x3d9f42,null));};exports['getJourney']=function(_0x530678,_0x5441f2){var _0xcb6559=['mail',_0x0e17('0xf2'),_0x0e17('0xf3'),'openchannel',_0x0e17('0xf4'),'whatsapp',_0x0e17('0xf5')];var _0x59128a={'offset':0x0,'order':qs[_0x0e17('0x48')](_0x0e17('0xf6'))},_0x20eaf7={'count':0x0,'rows':[]};Promise[_0x0e17('0x80')]()[_0x0e17('0x2d')](function(){if(_0x530678['query'][_0x0e17('0xf7')]){if(!_['includes'](_0xcb6559,_0x530678[_0x0e17('0x42')][_0x0e17('0xf7')][_0x0e17('0xf8')]())){throw new Error(_0x0e17('0xf9'));}_0xcb6559=[_0x530678['query'][_0x0e17('0xf7')][_0x0e17('0xf8')]()];}if(_0x530678[_0x0e17('0x42')]['range']){try{var _0x39b036=JSON[_0x0e17('0xeb')](_0x530678['query'][_0x0e17('0xfa')]);if(!moment(_0x39b036['from'])[_0x0e17('0xfb')]()){throw new Error(_0x0e17('0xfc'));}if(!moment(_0x39b036['to'])['isValid']()){throw new Error('Invalid\x20date\x20for\x20range\x20to\x20filter');}}catch(_0x476f4b){throw new Error(_0x0e17('0xfd'));}}if(!_0x530678[_0x0e17('0x42')]['hasOwnProperty'](_0x0e17('0x46'))){_0x59128a[_0x0e17('0x26')]=qs[_0x0e17('0x26')](_0x530678['query'][_0x0e17('0x26')]||0xa);_0x59128a[_0x0e17('0x23')]=qs[_0x0e17('0x23')](_0x530678['query'][_0x0e17('0x23')]);}var _0x18e5af=_0xcb6559['map'](function(_0x3258f2){if(_0x3258f2===_0x0e17('0xf5')){var _0x224bfb={'attributes':['id',_0x0e17('0xfe'),_0x0e17('0x3e'),_0x0e17('0xff'),'destination',_0x0e17('0x100'),_0x0e17('0x101'),_0x0e17('0x102'),_0x0e17('0x103'),'note',_0x0e17('0x104'),_0x0e17('0x105'),_0x0e17('0x106'),_0x0e17('0x107'),_0x0e17('0x108')],'where':{'ContactId':_0x530678[_0x0e17('0x95')]['id']},'include':[{'model':db[_0x0e17('0x5d')],'as':_0x0e17('0x5d'),'attributes':['id',_0x0e17('0x2e'),_0x0e17('0x109'),_0x0e17('0x9c')]}],'order':[[_0x0e17('0x104'),_0x0e17('0x7e')]]};if(_0x530678[_0x0e17('0x42')]['range']){_0x224bfb[_0x0e17('0x52')][_0x0e17('0x104')]={'$gte':_0x39b036[_0x0e17('0x4d')],'$lte':_0x39b036['to']};}return db[_0x0e17('0xb4')][_0x0e17('0x10a')](_0x224bfb)[_0x0e17('0x2d')](function(_0x488599){_0x20eaf7[_0x0e17('0x25')]+=_0x488599[_0x0e17('0x25')];return _[_0x0e17('0x59')](_0x488599[_0x0e17('0x93')],function(_0x38c7f3){var _0x1f52c2=_0x38c7f3['get']({'plain':!![]});_0x1f52c2['channel']=_0x3258f2;if(_0x1f52c2[_0x0e17('0x5d')]){_0x1f52c2[_0x0e17('0x5d')]={'id':_0x1f52c2['User']['id'],'name':_0x1f52c2[_0x0e17('0x5d')][_0x0e17('0x2e')],'fullname':_0x1f52c2[_0x0e17('0x5d')][_0x0e17('0x109')],'alias':_0x1f52c2[_0x0e17('0x5d')][_0x0e17('0x9c')]};}return _0x1f52c2;});});}else{var _0x3c2fd7=_['startCase'](_0x3258f2)+(_0x3258f2===_0x0e17('0xf2')?_0x0e17('0x10b'):_0x0e17('0x10c'));var _0x18dbca={'attributes':['id',_0x0e17('0x10d'),_0x0e17('0x10e'),_0x0e17('0x104'),_0x0e17('0x10f'),_0x0e17('0x110'),'secondDisposition',_0x0e17('0x111'),_0x0e17('0x108'),_0x3c2fd7+'Id'],'where':{'ContactId':_0x530678[_0x0e17('0x95')]['id']},'include':[{'model':db[_0x3c2fd7],'as':_0x0e17('0x10c'),'attributes':['id',_0x0e17('0x2e'),_0x0e17('0x112')]},{'model':db[_0x0e17('0x5d')],'as':_0x0e17('0x113'),'attributes':['id',_0x0e17('0x2e'),_0x0e17('0x109')]},{'model':db[_0x0e17('0xc0')],'as':_0x0e17('0x92'),'attributes':['id','name',_0x0e17('0x4c')],'through':{'attributes':[]}}],'order':[[_0x0e17('0x104'),'DESC']]};if(_0x530678[_0x0e17('0x42')]['range']){_0x18dbca['where'][_0x0e17('0x104')]={'$gte':_0x39b036[_0x0e17('0x4d')],'$lte':_0x39b036['to']};}switch(_0x3258f2){case _0x0e17('0xf2'):_0x18dbca[_0x0e17('0x43')]['push'](_0x0e17('0x114'),_0x0e17('0x115'),_0x0e17('0x116'),'deviceModel','osName',_0x0e17('0x117'),_0x0e17('0x118'),'ratingValue','referer');break;case _0x0e17('0x119'):_0x18dbca['attributes'][_0x0e17('0x39')](_0x0e17('0x11a'),_0x0e17('0x11b'));break;case _0x0e17('0x11c'):_0x18dbca[_0x0e17('0x43')][_0x0e17('0x39')](_0x0e17('0x11d'),_0x0e17('0x11e'));break;}return db[_['startCase'](_0x3258f2)+_0x0e17('0x11f')][_0x0e17('0x10a')](_0x18dbca)[_0x0e17('0x2d')](function(_0x5a353b){_0x20eaf7[_0x0e17('0x25')]+=_0x5a353b[_0x0e17('0x25')];return _[_0x0e17('0x59')](_0x5a353b[_0x0e17('0x93')],function(_0x340f0f){var _0x40cc38=_0x340f0f[_0x0e17('0x9f')]({'plain':!![]});_0x40cc38[_0x0e17('0xf7')]=_0x3258f2;if(_0x40cc38[_0x0e17('0x113')]){_0x40cc38[_0x0e17('0x113')]={'id':_0x40cc38[_0x0e17('0x113')]['id'],'name':_0x40cc38['Owner'][_0x0e17('0x2e')],'fullname':_0x40cc38[_0x0e17('0x113')]['fullname']};}return _0x40cc38;});});}});return Promise[_0x0e17('0x120')](_0x18e5af);})[_0x0e17('0x2d')](function(_0x67ce38){return _(_0x67ce38)[_0x0e17('0x121')]()[_0x0e17('0x122')](_0x0e17('0x104'))[_0x0e17('0x123')]()[_0x0e17('0x57')]();})[_0x0e17('0x2d')](function(_0x158c42){_0x20eaf7[_0x0e17('0x93')]=_0x59128a[_0x0e17('0x26')]?_0x158c42[_0x0e17('0x124')](_0x59128a['offset'],_0x59128a[_0x0e17('0x23')]+_0x59128a['limit']):_0x158c42;return _0x20eaf7;})[_0x0e17('0x2d')](respondWithFilteredResult(_0x5441f2,_0x59128a))['catch'](handleError(_0x5441f2,null));};
\ No newline at end of file
+var _0xe9e7=['hasOwnProperty','filter','push','Contact','ListId','c.ListId\x20IN\x20?','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','tag','isArray','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','group','c.id','Sequelize','QueryTypes','SELECT','isEmpty','having','t.id\x20IN\x20?','resolve','user','role','getLists','c.ListId\x20IS\x20NULL','sequelize','toString','keyBy','merge','c.lastName','c.mobile','c.fax','c.email','c.ListId','c.createdAt','c.deletedAt','c.CompanyId','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','Tags','rows','params','catch','columnName','displayName','findAll','custom','values','get','tags','join','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappMessage','create','bulkCreate','duplicates','$or','Tag','omit','format','cf_%d','pickBy','startsWith','table','setFields','id\x20=\x20?','toParam','phone','getTags','rawAttributes','intersection','pick','options','setTags','ids','getHoppers','ContactId','includeAll','include','getHopperFinals','getJscriptySessions','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','zipObject','No\x20phone\x20column\x20specified','root','server/files/tmp','file','filename','chmodSync','child_process','fork','CompanyId','pid','upload','createReadStream','parse','meta','import','binding','firstName','No\x20firstName\x20column\x20specified','../../components/import/cm/csv2','stringify','start\x20child\x20process\x20correctly!','exit','error\x20child\x20process','getJourney','chat','sms','openchannel','fax','whatsapp','voice','-createdAt','channel','toLowerCase','Invalid\x20channel','range','isValid','Invalid\x20createdAt\x20filter','uniqueid','source','destination','callerid','starttime','endtime','note','userDisposition','userSecondDisposition','userThirdDisposition','UserId','fullname','alias','createdAt','DESC','startCase','Website','Account','closed','closedAt','disposition','secondDisposition','key','browserName','customerPort','deviceModel','ratingType','ratingValue','mail','subject','substatus','externalUrl','threadId','Interaction','findAndCountAll','Owner','flatten','reverse','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','ejs','fs-extra','lodash','crypto','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','redis','defaults','localhost','./cmContact.socket','register','sendStatus','status','json','undefined','limit','count','offset','set','Content-Range','apply','reject','update','then','destroy','error','stack','name','send','body','message','agent','index','CmContact','describe','keys','length','cf_','CmCustomField','findOne','trimStart','all','model','query','attributes','fields','nolimit','order','sort','where','filters','select','field','color','from','cm_contacts','left_join','cm_user_has_contacts','uc.CmContactId\x20=\x20c.id','ct.CmContactId\x20=\x20c.id','tools_tags','c.deletedAt\x20IS\x20NULL','expr','search','parseSearch','conditions','find','value','split','map','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','uc.UserId\x20=\x20?','fieldType','datetime','castTo','DATE','buildExpression','type','text','start','end'];(function(_0x53b53e,_0x498437){var _0xbb6179=function(_0x3975eb){while(--_0x3975eb){_0x53b53e['push'](_0x53b53e['shift']());}};_0xbb6179(++_0x498437);}(_0xe9e7,0x1f0));var _0x7e9e=function(_0x55eeac,_0x130d98){_0x55eeac=_0x55eeac-0x0;var _0x8d592=_0xe9e7[_0x55eeac];return _0x8d592;};'use strict';var emlformat=require(_0x7e9e('0x0'));var rimraf=require(_0x7e9e('0x1'));var zipdir=require(_0x7e9e('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x7e9e('0x3'));var moment=require(_0x7e9e('0x4'));var BPromise=require(_0x7e9e('0x5'));var Mustache=require(_0x7e9e('0x6'));var util=require(_0x7e9e('0x7'));var path=require(_0x7e9e('0x8'));var sox=require(_0x7e9e('0x9'));var csv=require('to-csv');var ejs=require(_0x7e9e('0xa'));var fs=require('fs');var fs_extra=require(_0x7e9e('0xb'));var _=require(_0x7e9e('0xc'));var squel=require('squel');var crypto=require(_0x7e9e('0xd'));var jsforce=require('jsforce');var deskjs=require(_0x7e9e('0xe'));var toCsv=require(_0x7e9e('0xf'));var querystring=require(_0x7e9e('0x10'));var Papa=require(_0x7e9e('0x11'));var Redis=require(_0x7e9e('0x12'));var authService=require(_0x7e9e('0x13'));var qs=require(_0x7e9e('0x14'));var as=require(_0x7e9e('0x15'));var hardwareService=require(_0x7e9e('0x16'));var logger=require(_0x7e9e('0x17'))(_0x7e9e('0x18'));var utils=require(_0x7e9e('0x19'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];config[_0x7e9e('0x1a')]=_[_0x7e9e('0x1b')](config[_0x7e9e('0x1a')],{'host':_0x7e9e('0x1c'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config['redis']));require(_0x7e9e('0x1d'))[_0x7e9e('0x1e')](socket);function respondWithStatusCode(_0x1b59d1,_0x299be7){_0x299be7=_0x299be7||0xcc;return function(_0x3eeae2){if(_0x3eeae2){return _0x1b59d1[_0x7e9e('0x1f')](_0x299be7);}return _0x1b59d1[_0x7e9e('0x20')](_0x299be7)['end']();};}function respondWithResult(_0x428312,_0x4f38d5){_0x4f38d5=_0x4f38d5||0xc8;return function(_0x3a1a89){if(_0x3a1a89){return _0x428312[_0x7e9e('0x20')](_0x4f38d5)[_0x7e9e('0x21')](_0x3a1a89);}};}function respondWithFilteredResult(_0x1d973c,_0x35af37){return function(_0x11f414){if(_0x11f414){var _0x15cd67=typeof _0x35af37['offset']===_0x7e9e('0x22')&&typeof _0x35af37[_0x7e9e('0x23')]==='undefined';var _0x52358b=_0x11f414[_0x7e9e('0x24')];var _0x58eef4=_0x15cd67?0x0:_0x35af37['offset'];var _0x21a466=_0x15cd67?_0x11f414[_0x7e9e('0x24')]:_0x35af37[_0x7e9e('0x25')]+_0x35af37[_0x7e9e('0x23')];var _0x2654d3;if(_0x21a466>=_0x52358b){_0x21a466=_0x52358b;_0x2654d3=0xc8;}else{_0x2654d3=0xce;}_0x1d973c[_0x7e9e('0x20')](_0x2654d3);return _0x1d973c[_0x7e9e('0x26')](_0x7e9e('0x27'),_0x58eef4+'-'+_0x21a466+'/'+_0x52358b)[_0x7e9e('0x21')](_0x11f414);}return null;};}function patchUpdates(_0x5206df){return function(_0x3d7d43){try{jsonpatch[_0x7e9e('0x28')](_0x3d7d43,_0x5206df,!![]);}catch(_0x1dc4c9){return BPromise[_0x7e9e('0x29')](_0x1dc4c9);}return _0x3d7d43['save']();};}function saveUpdates(_0x15bb40,_0x10910d){return function(_0x1e0a32){if(_0x1e0a32){return _0x1e0a32[_0x7e9e('0x2a')](_0x15bb40)[_0x7e9e('0x2b')](function(_0xeaa799){return _0xeaa799;});}return null;};}function removeEntity(_0x3df586,_0x54f7b5){return function(_0x2b4df6){if(_0x2b4df6){return _0x2b4df6[_0x7e9e('0x2c')]()[_0x7e9e('0x2b')](function(){_0x3df586[_0x7e9e('0x20')](0xcc)['end']();});}};}function handleEntityNotFound(_0x1b61b4,_0x3f6655){return function(_0x1e7ece){if(!_0x1e7ece){_0x1b61b4[_0x7e9e('0x1f')](0x194);}return _0x1e7ece;};}function handleError(_0x4a2a1c,_0x398025){_0x398025=_0x398025||0x1f4;return function(_0x5da39e){logger[_0x7e9e('0x2d')](_0x5da39e[_0x7e9e('0x2e')]);if(_0x5da39e[_0x7e9e('0x2f')]){delete _0x5da39e[_0x7e9e('0x2f')];}_0x4a2a1c[_0x7e9e('0x20')](_0x398025)[_0x7e9e('0x30')](_0x5da39e);};}function getMustacheRender(_0x3ef7a0,_0x25774c){return Mustache['render'](_0x3ef7a0,_['merge'](_0x25774c[_0x7e9e('0x31')],{'contact':_0x25774c['contact'],'message':_0x25774c[_0x7e9e('0x32')],'agent':_0x25774c[_0x7e9e('0x33')],'interaction':_0x25774c['interaction'],'account':_0x25774c['account']}))||'';}exports[_0x7e9e('0x34')]=function(_0x3e6040,_0x4d5597){var _0x4b66a3={},_0x37981c={},_0x4e7087={'count':0x0,'rows':[]};return db[_0x7e9e('0x35')][_0x7e9e('0x36')]()['then'](function(_0x133834){var _0x39191f=[];for(var _0x583e1f=0x0;_0x583e1f<Object[_0x7e9e('0x37')](_0x133834)[_0x7e9e('0x38')];_0x583e1f++){var _0x16a10b=Object[_0x7e9e('0x37')](_0x133834)[_0x583e1f];if(_['startsWith'](_0x16a10b,_0x7e9e('0x39'))){_0x39191f['push'](db[_0x7e9e('0x3a')][_0x7e9e('0x3b')]({'where':{'id':_[_0x7e9e('0x3c')](_0x16a10b,_0x7e9e('0x39'))},'raw':!![]}));}}return BPromise[_0x7e9e('0x3d')](_0x39191f)[_0x7e9e('0x2b')](function(_0x56583c){for(var _0x17b57f=0x0;_0x17b57f<_0x56583c['length'];_0x17b57f++){if(_0x56583c[_0x17b57f]){var _0x26317c=_0x7e9e('0x39')+_0x56583c[_0x17b57f]['id'];var _0x19fb3b=_0x133834[_0x26317c];_0x19fb3b['fieldType']=_0x56583c[_0x17b57f]['type'];}}return _0x133834;});})['then'](function(_0x2655e7){_0x37981c[_0x7e9e('0x3e')]=_[_0x7e9e('0x37')](_0x2655e7);_0x37981c[_0x7e9e('0x3f')]=_['keys'](_0x3e6040[_0x7e9e('0x3f')]);_0x37981c['filters']=_['intersection'](_0x37981c[_0x7e9e('0x3e')],_0x37981c[_0x7e9e('0x3f')]);_0x4b66a3[_0x7e9e('0x40')]=_['intersection'](_0x37981c[_0x7e9e('0x3e')],qs[_0x7e9e('0x41')](_0x3e6040[_0x7e9e('0x3f')]['fields']));_0x4b66a3[_0x7e9e('0x40')]=_0x4b66a3[_0x7e9e('0x40')][_0x7e9e('0x38')]?_0x4b66a3[_0x7e9e('0x40')]:_0x37981c[_0x7e9e('0x3e')];if(!_0x3e6040['query']['hasOwnProperty'](_0x7e9e('0x42'))){_0x4b66a3[_0x7e9e('0x23')]=qs['limit'](_0x3e6040[_0x7e9e('0x3f')][_0x7e9e('0x23')]);_0x4b66a3[_0x7e9e('0x25')]=qs[_0x7e9e('0x25')](_0x3e6040['query'][_0x7e9e('0x25')]);}_0x4b66a3[_0x7e9e('0x43')]=qs['sort'](_0x3e6040[_0x7e9e('0x3f')][_0x7e9e('0x44')]);_0x4b66a3[_0x7e9e('0x45')]=qs[_0x7e9e('0x46')](_['pick'](_0x3e6040['query'],_0x37981c[_0x7e9e('0x46')]),_0x2655e7);var _0x3eba14=[];var _0x29edfb=squel[_0x7e9e('0x47')]()['field']('id')[_0x7e9e('0x48')](_0x7e9e('0x2f'))[_0x7e9e('0x48')](_0x7e9e('0x49'))['from']('tools_tags');var _0x5026cc=squel[_0x7e9e('0x47')]()[_0x7e9e('0x4a')](_0x7e9e('0x4b'),'c')[_0x7e9e('0x4c')](_0x7e9e('0x4d'),'uc',_0x7e9e('0x4e'))[_0x7e9e('0x4c')]('cm_contact_has_tags','ct',_0x7e9e('0x4f'))[_0x7e9e('0x4c')](_0x7e9e('0x50'),'t','t.id\x20=\x20ct.TagId')['where'](_0x7e9e('0x51'));var _0x34c319=squel[_0x7e9e('0x52')]();var _0xc96ace=[];var _0x3f0456=squel[_0x7e9e('0x52')]();var _0x184c9c;if(_0x3e6040[_0x7e9e('0x3f')][_0x7e9e('0x53')]){_0x184c9c=as[_0x7e9e('0x54')](_0x3e6040[_0x7e9e('0x3f')][_0x7e9e('0x53')]);var _0x10f92e=_0x184c9c['sqlOperator'];for(var _0x174537=0x0;_0x174537<_0x184c9c[_0x7e9e('0x55')][_0x7e9e('0x38')];_0x174537++){var _0x26dc29=_0x184c9c[_0x7e9e('0x55')][_0x174537];var _0x3a07e0='c';var _0x1af3eb=_(_0x2655e7)[_0x7e9e('0x37')]()[_0x7e9e('0x56')](function(_0x328ddd){return _0x328ddd===_0x26dc29['field'];});if(_0x1af3eb)_0x1af3eb=_0x2655e7[_0x26dc29[_0x7e9e('0x48')]];if(!_0x1af3eb){if(_0x26dc29[_0x7e9e('0x48')]==='Tag'){var _0x424271=_0x26dc29[_0x7e9e('0x57')][_0x7e9e('0x58')](',')[_0x7e9e('0x59')](function(_0x3071ec){return Number(_0x3071ec);});_0x424271[_0x7e9e('0x5a')](function(_0x1f9418){_0x3f0456['or'](_0x7e9e('0x5b'),'%,'+_0x1f9418+',%');});_0xc96ace=_[_0x7e9e('0x5c')](_0xc96ace,_0x424271);}else if(_0x26dc29[_0x7e9e('0x48')]===_0x7e9e('0x5d')){_0x34c319['and'](_0x7e9e('0x5e'),_0x26dc29[_0x7e9e('0x57')]);}}else{if(_0x26dc29[_0x7e9e('0x48')]==='dateOfBirth'||_0x1af3eb[_0x7e9e('0x5f')]===_0x7e9e('0x60'))_0x26dc29[_0x7e9e('0x61')]=_0x7e9e('0x62');var _0x468e57=as[_0x7e9e('0x63')](_0x3a07e0,_0x1af3eb[_0x7e9e('0x64')],_0x26dc29);_0x34c319[_0x10f92e](_0x468e57[_0x7e9e('0x65')],_0x468e57[_0x7e9e('0x57')][_0x7e9e('0x66')],_0x468e57[_0x7e9e('0x57')][_0x7e9e('0x67')]);}}}else{var _0x5c28f5=_(Object[_0x7e9e('0x37')](_0x3e6040[_0x7e9e('0x3f')]))[_0x7e9e('0x59')](function(_0x1870a1){return _0x2655e7[_0x7e9e('0x68')](_0x1870a1)?_0x1870a1:undefined;})[_0x7e9e('0x69')](function(_0x426d54){return!_['isNil'](_0x426d54);})[_0x7e9e('0x57')]();if(_0x3e6040['query']['Contact'])_0x5c28f5[_0x7e9e('0x6a')](_0x7e9e('0x6b'));if(!_['isEmpty'](_0x5c28f5)){_0x5c28f5[_0x7e9e('0x5a')](function(_0x333a39){if(_0x333a39===_0x7e9e('0x6c')){_0x5026cc[_0x7e9e('0x45')](_0x7e9e('0x6d'),[]['concat'](_0x3e6040['query'][_0x333a39]));}else if(_0x333a39==='Contact'){var _0x2670b0='%'+_0x3e6040[_0x7e9e('0x3f')][_0x333a39]+'%';_0x5026cc[_0x7e9e('0x45')](_0x7e9e('0x6e'),_0x2670b0);}else{_0x5026cc[_0x7e9e('0x45')]('c.'+_0x333a39+'\x20=\x20?',_0x3e6040[_0x7e9e('0x3f')][_0x333a39]);}});}if(_0x3e6040[_0x7e9e('0x3f')][_0x7e9e('0x6f')]){_0xc96ace=_[_0x7e9e('0x70')](_0x3e6040['query']['tag'])?_0x3e6040['query'][_0x7e9e('0x6f')]:new Array(_0x3e6040[_0x7e9e('0x3f')][_0x7e9e('0x6f')]);_0xc96ace['forEach'](function(_0x2a43e6){_0x3f0456['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x2a43e6+',%');});}if(_0x3e6040[_0x7e9e('0x3f')][_0x7e9e('0x69')]){var _0x44f6b0=_0x3e6040[_0x7e9e('0x3f')][_0x7e9e('0x69')]['replace']('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(_0x44f6b0[_0x7e9e('0x58')]('\x20')[_0x7e9e('0x38')]>0x1){_0x34c319['or'](_0x7e9e('0x71'),qs[_0x7e9e('0x72')](_0x44f6b0),null);}else{if(qs['isNumeric'](_0x44f6b0)){_0x34c319['or']('c.id\x20LIKE\x20?',_0x44f6b0+'%');_0x34c319['or'](_0x7e9e('0x73'),_0x44f6b0+'%');_0x34c319['or'](_0x7e9e('0x74'),_0x44f6b0+'%');_0x34c319['or'](_0x7e9e('0x75'),_0x44f6b0+'%');}else if(qs[_0x7e9e('0x76')](_0x44f6b0)){_0x34c319['or'](_0x7e9e('0x77'),_0x44f6b0+'%');}else{_0x34c319['or'](_0x7e9e('0x78'),'%'+_0x44f6b0+'%');_0x34c319['or'](_0x7e9e('0x79'),'%'+_0x44f6b0+'%');_0x34c319['or'](_0x7e9e('0x77'),'%'+_0x44f6b0+'%');}}}}_0x5026cc[_0x7e9e('0x45')](_0x34c319);_0x5026cc[_0x7e9e('0x7a')](_0x7e9e('0x7b'));var _0x464532={'type':db[_0x7e9e('0x7c')][_0x7e9e('0x7d')][_0x7e9e('0x7e')],'raw':!![]};var _0x38db63=_0x5026cc['clone']()[_0x7e9e('0x48')](_0x7e9e('0x7b'));if(_0x4b66a3['order']){_0x4b66a3[_0x7e9e('0x43')][_0x7e9e('0x5a')](function(_0x2d8ebc){_0x5026cc['order']('c.'+_0x2d8ebc[0x0],_0x2d8ebc[0x1]==='DESC'?![]:!![]);});}if(!_[_0x7e9e('0x7f')](_0xc96ace)){_0x5026cc[_0x7e9e('0x80')](_0x3f0456);_0x38db63[_0x7e9e('0x45')](_0x7e9e('0x81'),_0xc96ace);}BPromise[_0x7e9e('0x82')]()[_0x7e9e('0x2b')](function(){if(!_0x184c9c)return;if(_0x3e6040[_0x7e9e('0x83')][_0x7e9e('0x84')]!==_0x7e9e('0x33'))return;if(!_['some'](_0x184c9c[_0x7e9e('0x55')],[_0x7e9e('0x48'),_0x7e9e('0x5d')])){return _0x3e6040[_0x7e9e('0x83')][_0x7e9e('0x85')]({'attributes':['id'],'raw':!![]})[_0x7e9e('0x2b')](function(_0x5ca5a4){if(_[_0x7e9e('0x7f')](_0x5ca5a4)){_0x38db63['where'](_0x7e9e('0x86'));_0x5026cc[_0x7e9e('0x45')](_0x7e9e('0x86'));}else{_0x38db63[_0x7e9e('0x45')](_0x7e9e('0x6d'),_['map'](_0x5ca5a4,'id'));_0x5026cc[_0x7e9e('0x45')](_0x7e9e('0x6d'),_['map'](_0x5ca5a4,'id'));}});}})[_0x7e9e('0x2b')](function(){if(_0x3e6040[_0x7e9e('0x83')][_0x7e9e('0x84')]===_0x7e9e('0x33')&&!_0x184c9c&&!_0x3e6040[_0x7e9e('0x3f')][_0x7e9e('0x6c')])return[];return db[_0x7e9e('0x87')][_0x7e9e('0x3f')](_0x38db63[_0x7e9e('0x88')](),_0x464532);})[_0x7e9e('0x2b')](function(_0x1f0af9){_0x4e7087[_0x7e9e('0x24')]=_0x1f0af9[_0x7e9e('0x38')];if(_0x4e7087['count']===0x0)return[];return db[_0x7e9e('0x87')]['query'](_0x29edfb[_0x7e9e('0x88')](),_0x464532)[_0x7e9e('0x2b')](function(_0x3693b1){_0x3eba14=_[_0x7e9e('0x89')](_0x3693b1,'id');_0x464532=_[_0x7e9e('0x8a')](_0x464532,{'model':db[_0x7e9e('0x35')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x3e6040[_0x7e9e('0x3f')]['fields']){_0x4b66a3['attributes'][_0x7e9e('0x5a')](function(_0x3eed32){_0x5026cc[_0x7e9e('0x48')]('c.'+_0x3eed32);});}else{_0x5026cc[_0x7e9e('0x48')](_0x7e9e('0x7b'));_0x5026cc['field']('c.firstName');_0x5026cc[_0x7e9e('0x48')](_0x7e9e('0x8b'));_0x5026cc[_0x7e9e('0x48')]('c.phone');_0x5026cc['field'](_0x7e9e('0x8c'));_0x5026cc[_0x7e9e('0x48')](_0x7e9e('0x8d'));_0x5026cc[_0x7e9e('0x48')](_0x7e9e('0x8e'));_0x5026cc['field'](_0x7e9e('0x8f'));_0x5026cc[_0x7e9e('0x48')](_0x7e9e('0x90'));_0x5026cc[_0x7e9e('0x48')](_0x7e9e('0x91'));_0x5026cc[_0x7e9e('0x48')](_0x7e9e('0x92'));_0x5026cc['field'](_0x7e9e('0x93'),_0x7e9e('0x94'));}if(_0x4b66a3['limit'])_0x5026cc['limit'](_0x4b66a3[_0x7e9e('0x23')]);if(_0x4b66a3['offset'])_0x5026cc['offset'](_0x4b66a3[_0x7e9e('0x25')]);return db['sequelize'][_0x7e9e('0x3f')](_0x5026cc['toString'](),_0x464532);});})[_0x7e9e('0x2b')](function(_0x1e473f){_0x1e473f['forEach'](function(_0x7a332b){if(_0x7a332b['TagIds']){_0x7a332b[_0x7e9e('0x95')]=[];_0x7a332b['TagIds']['split'](',')[_0x7e9e('0x5a')](function(_0x2fcd09){_0x7a332b['Tags'][_0x7e9e('0x6a')](_0x3eba14[_0x2fcd09]);});}delete _0x7a332b['TagIds'];});_0x4e7087[_0x7e9e('0x96')]=_0x1e473f;return _0x4e7087;})[_0x7e9e('0x2b')](respondWithFilteredResult(_0x4d5597,_0x4b66a3));})['catch'](handleError(_0x4d5597,null));};exports[_0x7e9e('0x2c')]=function(_0xa1c9ef,_0x49ea91){return db['CmContact'][_0x7e9e('0x56')]({'where':{'id':_0xa1c9ef[_0x7e9e('0x97')]['id']}})[_0x7e9e('0x2b')](handleEntityNotFound(_0x49ea91,null))[_0x7e9e('0x2b')](removeEntity(_0x49ea91,null))[_0x7e9e('0x98')](handleError(_0x49ea91,null));};exports[_0x7e9e('0x36')]=function(_0x4f2563,_0x36453c){return db[_0x7e9e('0x35')][_0x7e9e('0x36')]()['then'](function(_0x56f76a){delete _0x56f76a['tags'];for(var _0x1d33a7=0x0;_0x1d33a7<Object[_0x7e9e('0x37')](_0x56f76a)['length'];_0x1d33a7++){var _0x5a7de2=Object['keys'](_0x56f76a)[_0x1d33a7];if(!_['startsWith'](_0x5a7de2,'cf_')){_0x56f76a[_0x5a7de2][_0x7e9e('0x99')]=_0x5a7de2;_0x56f76a[_0x5a7de2][_0x7e9e('0x9a')]=_0x5a7de2;}}return _0x56f76a;})[_0x7e9e('0x2b')](function(_0x3c9820){var _0xd2673c={'where':{'$or':[{'ListId':_0x4f2563['query']['id']},{'ListId':null}]},'raw':!![]};return db[_0x7e9e('0x3a')][_0x7e9e('0x9b')](_0xd2673c)[_0x7e9e('0x2b')](function(_0x32ad72){for(var _0x4dee39=0x0;_0x4dee39<_0x32ad72[_0x7e9e('0x38')];_0x4dee39++){var _0x2f6e24=_0x7e9e('0x39')+_0x32ad72[_0x4dee39]['id'];_0x3c9820[_0x2f6e24][_0x7e9e('0x99')]=_0x2f6e24;_0x3c9820[_0x2f6e24][_0x7e9e('0x9a')]=_0x32ad72[_0x4dee39]['alias'];_0x3c9820[_0x2f6e24][_0x7e9e('0x9c')]={'type':_0x32ad72[_0x4dee39][_0x7e9e('0x64')],'values':_0x32ad72[_0x4dee39][_0x7e9e('0x9d')]};}Object['keys'](_0x3c9820)[_0x7e9e('0x5a')](function(_0x7c7e11){if(!_0x3c9820[_0x7c7e11][_0x7e9e('0x68')](_0x7e9e('0x99'))){delete _0x3c9820[_0x7c7e11];}});return _0x3c9820;});})['then'](respondWithResult(_0x36453c,null))[_0x7e9e('0x98')](handleError(_0x36453c,null));};exports[_0x7e9e('0x8a')]=function(_0x278721,_0x2c4b11){var _0x2ed8fe;var _0x3cd6a0;var _0x1c5215;if(_0x278721[_0x7e9e('0x31')]['id']){delete _0x278721[_0x7e9e('0x31')]['id'];}return db[_0x7e9e('0x35')][_0x7e9e('0x9b')]({'where':{'id':[_0x278721['body']['to'],_0x278721[_0x7e9e('0x31')][_0x7e9e('0x4a')]]}})[_0x7e9e('0x2b')](function(_0x2d984b){if(_0x2d984b){if(_0x2d984b['length']!==0x2){return null;}_0x2d984b[0x0]=_0x2d984b[0x0]['get']({'plain':!![]});_0x2d984b[0x1]=_0x2d984b[0x1][_0x7e9e('0x9e')]({'plain':!![]});delete _0x2d984b[0x0]['id'];delete _0x2d984b[0x1]['id'];return _['mergeWith'](_0x2d984b[0x0],_0x2d984b[0x1],function(_0x1cd14d,_0x2acf25){if(Array['isArray'](_0x2acf25)&&!_0x2acf25[_0x7e9e('0x38')]){return _0x1cd14d;}else if(!_0x2acf25){return _0x1cd14d;}});}})['then'](handleEntityNotFound(_0x2c4b11,null))['then'](function(_0x228b14){if(_0x228b14){if(_0x228b14[_0x7e9e('0x9f')]&&_[_0x7e9e('0x70')](_0x228b14[_0x7e9e('0x9f')])){_0x228b14[_0x7e9e('0x9f')]=_0x228b14['tags'][_0x7e9e('0xa0')]();}logger[_0x7e9e('0xa1')](_0x7e9e('0xa2'),_0x278721[_0x7e9e('0x31')]['to'],_0x278721[_0x7e9e('0x31')][_0x7e9e('0x4a')]);return db[_0x7e9e('0xa3')]['destroy']({'where':{'ContactId':[_0x278721['body']['to'],_0x278721[_0x7e9e('0x31')][_0x7e9e('0x4a')]]}})['then'](function(_0x4e1588){logger[_0x7e9e('0xa1')](_0x7e9e('0xa4'),_0x4e1588);return db[_0x7e9e('0xa5')]['destroy']({'where':{'ContactId':[_0x278721[_0x7e9e('0x31')]['to'],_0x278721[_0x7e9e('0x31')][_0x7e9e('0x4a')]]}})['then'](function(_0x37c667){logger['info'](_0x7e9e('0xa6'),_0x37c667);return db[_0x7e9e('0x35')]['create'](_0x228b14);});});}})['then'](function(_0x183dad){if(_0x183dad){_0x2ed8fe=_0x183dad;_0x3cd6a0={'ContactId':_0x2ed8fe['id']};_0x1c5215={'where':{'ContactId':[_0x278721['body']['to'],_0x278721[_0x7e9e('0x31')][_0x7e9e('0x4a')]]}};return db[_0x7e9e('0xa7')]['update'](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db[_0x7e9e('0xa8')]['update'](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db[_0x7e9e('0xa9')][_0x7e9e('0x2a')](_0x3cd6a0,_0x1c5215);}})['then'](function(){if(_0x2ed8fe){return db[_0x7e9e('0xaa')]['update'](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db[_0x7e9e('0xab')][_0x7e9e('0x2a')](_0x3cd6a0,_0x1c5215);}})['then'](function(){if(_0x2ed8fe){return db['MailInteraction']['update'](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db[_0x7e9e('0xab')][_0x7e9e('0x2a')](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db[_0x7e9e('0xac')][_0x7e9e('0x2a')](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db[_0x7e9e('0xad')][_0x7e9e('0x2a')](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db[_0x7e9e('0xae')][_0x7e9e('0x2a')](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db[_0x7e9e('0xaf')]['update'](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db[_0x7e9e('0xb0')][_0x7e9e('0x2a')](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db[_0x7e9e('0xb1')][_0x7e9e('0x2a')](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db[_0x7e9e('0xb2')][_0x7e9e('0x2a')](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db[_0x7e9e('0xb3')][_0x7e9e('0x2a')](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db[_0x7e9e('0xb4')][_0x7e9e('0x2a')](_0x3cd6a0,_0x1c5215);}})['then'](function(){if(_0x2ed8fe){return db[_0x7e9e('0xb5')]['update'](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db[_0x7e9e('0xb6')]['update'](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db['FaxQueueReport'][_0x7e9e('0x2a')](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db[_0x7e9e('0xb7')][_0x7e9e('0x2a')](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db[_0x7e9e('0xb8')][_0x7e9e('0x2a')](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db[_0x7e9e('0xb9')][_0x7e9e('0x2a')](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db[_0x7e9e('0xba')][_0x7e9e('0x2a')](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db[_0x7e9e('0xbb')][_0x7e9e('0x2a')](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db[_0x7e9e('0xbc')]['update'](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db['WhatsappQueueReport']['update'](_0x3cd6a0,_0x1c5215);}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return db[_0x7e9e('0x35')][_0x7e9e('0x2c')]({'where':{'id':[_0x278721[_0x7e9e('0x31')]['to'],_0x278721[_0x7e9e('0x31')][_0x7e9e('0x4a')]]}});}})[_0x7e9e('0x2b')](function(){if(_0x2ed8fe){return _0x2ed8fe;}})[_0x7e9e('0x2b')](respondWithResult(_0x2c4b11,null))[_0x7e9e('0x98')](handleError(_0x2c4b11,null));};exports[_0x7e9e('0xbd')]=function(_0x550fac,_0x41e5be){return db[_0x7e9e('0x35')]['describe']()[_0x7e9e('0x2b')](function(_0x4bf653){if(_0x550fac[_0x7e9e('0x31')][_0x7e9e('0x9f')]&&_[_0x7e9e('0x70')](_0x550fac[_0x7e9e('0x31')][_0x7e9e('0x9f')])){if(_0x550fac['body'][_0x7e9e('0x9f')][_0x7e9e('0x38')]){_0x550fac[_0x7e9e('0x31')][_0x7e9e('0x9f')]=_0x550fac[_0x7e9e('0x31')][_0x7e9e('0x9f')][_0x7e9e('0xa0')](';')+';';}else{_0x550fac[_0x7e9e('0x31')]['tags']=null;}}else{_0x550fac['body'][_0x7e9e('0x9f')]=null;}return db[_0x7e9e('0x35')][_0x7e9e('0xbd')](_0x550fac[_0x7e9e('0x31')],{'fields':_['keys'](_0x4bf653),'raw':!![]});})[_0x7e9e('0x2b')](respondWithResult(_0x41e5be,0xc9))[_0x7e9e('0x98')](handleError(_0x41e5be,null));};exports[_0x7e9e('0xbe')]=function(_0xbdd98d,_0x3d427a){var _0x5c78e4=[];var _0xbd4766=0x0;var _0x4aba6e=0x0;var _0x182ec7=0x0;return db[_0x7e9e('0x35')][_0x7e9e('0x36')]()[_0x7e9e('0x2b')](function(_0x5f4b25){return BPromise['each'](_0xbdd98d[_0x7e9e('0x31')],function(_0xb6b1a){var _0x448053={'where':{'$or':[]},'defaults':_0xb6b1a,'fields':_[_0x7e9e('0x37')](_0x5f4b25),'raw':!![]};if(_0xb6b1a[_0x7e9e('0xbf')]){for(var _0x5773cf=0x0;_0x5773cf<_0xb6b1a[_0x7e9e('0xbf')][_0x7e9e('0x38')];_0x5773cf++){var _0xa61450={};_0xa61450[_0xb6b1a[_0x7e9e('0xbf')][_0x5773cf]]=_0xb6b1a[_0xb6b1a[_0x7e9e('0xbf')][_0x5773cf]];_0x448053[_0x7e9e('0x45')][_0x7e9e('0xc0')][_0x7e9e('0x6a')](_0xa61450);}_0x448053[_0x7e9e('0x45')][_0x7e9e('0x6c')]=_0xb6b1a[_0x7e9e('0x6c')];}return db['CmContact']['findOrCreate'](_0x448053)['spread'](function(_0x3ac663,_0x475ac9){if(_0x475ac9){_0xbd4766++;}else{_0x182ec7++;}})[_0x7e9e('0x98')](function(_0x2506a5){console[_0x7e9e('0x2d')](_0x2506a5);_0x4aba6e++;});});})[_0x7e9e('0x2b')](function(_0x1f30cc){if(_0x1f30cc){return{'success':_0xbd4766,'failure':_0x4aba6e,'duplicates':_0x182ec7};}})[_0x7e9e('0x2b')](respondWithResult(_0x3d427a,0xc9))[_0x7e9e('0x98')](handleError(_0x3d427a,null));};exports['show']=function(_0x319e26,_0x45acd2,_0x51f689){var _0x2833f9;return db[_0x7e9e('0x35')][_0x7e9e('0x36')]()['then'](function(_0x5a7545){return db[_0x7e9e('0x35')][_0x7e9e('0x56')]({'where':{'id':_0x319e26[_0x7e9e('0x97')]['id']},'include':[{'model':db[_0x7e9e('0xc1')],'as':_0x7e9e('0x95'),'attributes':['id',_0x7e9e('0x2f'),_0x7e9e('0x49')],'required':_0x319e26[_0x7e9e('0x3f')][_0x7e9e('0x6f')]?!![]:![]}],'attributes':_[_0x7e9e('0x37')](_0x5a7545)});})[_0x7e9e('0x2b')](function(_0x5573f5){_0x2833f9=_0x5573f5[_0x7e9e('0x9e')]({'plain':!![]});var _0x4fac33={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x5573f5&&_0x5573f5[_0x7e9e('0x6c')]){if(_0x5573f5[_0x7e9e('0x6c')]){_0x4fac33['where']['$and']['push']({'ListId':{'$ne':_0x5573f5[_0x7e9e('0x6c')]}});}}return db[_0x7e9e('0x3a')][_0x7e9e('0x9b')](_0x4fac33);})[_0x7e9e('0x2b')](function(_0x2cf598){return _[_0x7e9e('0xc2')](_0x2833f9,_['map'](_0x2cf598,function(_0x5827d5){return util[_0x7e9e('0xc3')](_0x7e9e('0xc4'),_0x5827d5['id']);}));})[_0x7e9e('0x2b')](handleEntityNotFound(_0x45acd2,null))['then'](respondWithResult(_0x45acd2,null))[_0x7e9e('0x98')](handleError(_0x45acd2,null));};exports[_0x7e9e('0x2a')]=function(_0x4656d9,_0x2420f1){var _0xd2a9b8;if(_0x4656d9['body']['id']){delete _0x4656d9[_0x7e9e('0x31')]['id'];}return db[_0x7e9e('0x35')][_0x7e9e('0x56')]({'where':{'id':_0x4656d9['params']['id']}})[_0x7e9e('0x2b')](handleEntityNotFound(_0x2420f1,null))[_0x7e9e('0x2b')](saveUpdates(_0x4656d9[_0x7e9e('0x31')],null))['then'](function(_0x186a80){_0xd2a9b8=_0x186a80;var _0x1c116a={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x186a80&&_0x186a80[_0x7e9e('0x6c')]){if(_0x186a80[_0x7e9e('0x6c')]){_0x1c116a[_0x7e9e('0x45')]['$and']['push']({'ListId':{'$ne':_0x186a80[_0x7e9e('0x6c')]}});}}return db[_0x7e9e('0x3a')][_0x7e9e('0x9b')](_0x1c116a);})[_0x7e9e('0x2b')](function(_0x184032){if(_0x184032){return _[_0x7e9e('0xc2')](_[_0x7e9e('0xc5')](_0x4656d9['body'],function(_0x5335a4,_0x24e826){return _[_0x7e9e('0xc6')](_0x24e826,_0x7e9e('0x39'));}),_[_0x7e9e('0x59')](_0x184032,function(_0x4cd566){return util[_0x7e9e('0xc3')](_0x7e9e('0xc4'),_0x4cd566['id']);}));}})[_0x7e9e('0x2b')](function(_0xe541d2){if(_0xe541d2&&!_[_0x7e9e('0x7f')](_0xe541d2)){var _0x2e478c=squel[_0x7e9e('0x2a')]()[_0x7e9e('0xc7')]('cm_contacts')[_0x7e9e('0xc8')](_0xe541d2)[_0x7e9e('0x45')](_0x7e9e('0xc9'),_0x4656d9[_0x7e9e('0x97')]['id'])[_0x7e9e('0xca')]();return db[_0x7e9e('0x87')][_0x7e9e('0x3f')](_0x2e478c[_0x7e9e('0x65')],{'replacements':_0x2e478c[_0x7e9e('0x9d')]});}})[_0x7e9e('0x2b')](function(){if(_0x4656d9[_0x7e9e('0x31')][_0x7e9e('0xcb')]&&_0xd2a9b8){return db[_0x7e9e('0xa3')][_0x7e9e('0x2a')]({'phone':_0x4656d9[_0x7e9e('0x31')][_0x7e9e('0xcb')]},{'where':{'ContactId':_0xd2a9b8['id']}});}})[_0x7e9e('0x2b')](function(){return _0xd2a9b8;})[_0x7e9e('0x2b')](respondWithResult(_0x2420f1,null))[_0x7e9e('0x98')](handleError(_0x2420f1,null));};exports[_0x7e9e('0xcc')]=function(_0x12b219,_0x4ec02b,_0x18bf59){var _0x35f38b={};var _0x34dadc={};var _0x438d62;var _0x48a161;return db['CmContact'][_0x7e9e('0x3b')]({'where':{'id':_0x12b219[_0x7e9e('0x97')]['id']}})['then'](handleEntityNotFound(_0x4ec02b,null))[_0x7e9e('0x2b')](function(_0x3cd448){if(_0x3cd448){_0x438d62=_0x3cd448;_0x34dadc[_0x7e9e('0x3e')]=_[_0x7e9e('0x37')](db[_0x7e9e('0xc1')][_0x7e9e('0xcd')]);_0x34dadc[_0x7e9e('0x3f')]=_[_0x7e9e('0x37')](_0x12b219['query']);_0x34dadc[_0x7e9e('0x46')]=_[_0x7e9e('0xce')](_0x34dadc[_0x7e9e('0x3e')],_0x34dadc[_0x7e9e('0x3f')]);_0x35f38b['attributes']=_[_0x7e9e('0xce')](_0x34dadc[_0x7e9e('0x3e')],qs[_0x7e9e('0x41')](_0x12b219['query'][_0x7e9e('0x41')]));_0x35f38b[_0x7e9e('0x40')]=_0x35f38b[_0x7e9e('0x40')][_0x7e9e('0x38')]?_0x35f38b['attributes']:_0x34dadc[_0x7e9e('0x3e')];_0x35f38b[_0x7e9e('0x43')]=qs[_0x7e9e('0x44')](_0x12b219['query']['sort']);_0x35f38b[_0x7e9e('0x45')]=qs[_0x7e9e('0x46')](_[_0x7e9e('0xcf')](_0x12b219['query'],_0x34dadc[_0x7e9e('0x46')]));if(_0x12b219[_0x7e9e('0x3f')]['filter']){_0x35f38b[_0x7e9e('0x45')]=_[_0x7e9e('0x8a')](_0x35f38b[_0x7e9e('0x45')],{'$or':_['map'](_0x35f38b['attributes'],function(_0x23273b){var _0x41e391={};_0x41e391[_0x23273b]={'$like':'%'+_0x12b219[_0x7e9e('0x3f')]['filter']+'%'};return _0x41e391;})});}_0x35f38b=_['merge']({},_0x35f38b,_0x12b219[_0x7e9e('0xd0')]);return _0x438d62[_0x7e9e('0xcc')](_0x35f38b);}})[_0x7e9e('0x2b')](function(_0x2ee5b4){if(_0x2ee5b4){_0x48a161=_0x2ee5b4[_0x7e9e('0x38')];if(!_0x12b219[_0x7e9e('0x3f')][_0x7e9e('0x68')](_0x7e9e('0x42'))){_0x35f38b['limit']=qs['limit'](_0x12b219[_0x7e9e('0x3f')][_0x7e9e('0x23')]);_0x35f38b[_0x7e9e('0x25')]=qs['offset'](_0x12b219[_0x7e9e('0x3f')]['offset']);}return _0x438d62[_0x7e9e('0xcc')](_0x35f38b);}})[_0x7e9e('0x2b')](function(_0x52f6b1){if(_0x52f6b1){return _0x52f6b1?{'count':_0x48a161,'rows':_0x52f6b1}:null;}})['then'](respondWithResult(_0x4ec02b,null))[_0x7e9e('0x98')](handleError(_0x4ec02b,null));};exports[_0x7e9e('0xd1')]=function(_0x43238c,_0x45145f,_0x2cc68d){if(_0x43238c[_0x7e9e('0x31')]['id']){delete _0x43238c['body']['id'];}return db[_0x7e9e('0x35')]['findOne']({'where':{'id':_0x43238c['params']['id']}})[_0x7e9e('0x2b')](handleEntityNotFound(_0x45145f,null))['then'](function(_0x53243f){if(_0x53243f){return _0x53243f[_0x7e9e('0xd1')](_0x43238c[_0x7e9e('0x31')][_0x7e9e('0xd2')]||[]);}return null;})[_0x7e9e('0x2b')](respondWithResult(_0x45145f,null))[_0x7e9e('0x98')](handleError(_0x45145f,null));};exports[_0x7e9e('0xd3')]=function(_0x110d4d,_0x2a24de,_0x265ff6){var _0xbc7ec8={'raw':![],'where':{}};var _0x2e434b={};var _0x1c0738={'count':0x0,'rows':[]};return db[_0x7e9e('0x35')][_0x7e9e('0x3b')]({'where':{'id':_0x110d4d[_0x7e9e('0x97')]['id']}})['then'](handleEntityNotFound(_0x2a24de,null))['then'](function(_0x9cb8cc){if(_0x9cb8cc){_0x2e434b[_0x7e9e('0x3e')]=_[_0x7e9e('0x37')](db['CmHopper'][_0x7e9e('0xcd')]);_0x2e434b['query']=_[_0x7e9e('0x37')](_0x110d4d[_0x7e9e('0x3f')]);_0x2e434b['filters']=_[_0x7e9e('0xce')](_0x2e434b['model'],_0x2e434b[_0x7e9e('0x3f')]);_0xbc7ec8['attributes']=_[_0x7e9e('0xce')](_0x2e434b['model'],qs[_0x7e9e('0x41')](_0x110d4d[_0x7e9e('0x3f')]['fields']));_0xbc7ec8[_0x7e9e('0x40')]=_0xbc7ec8[_0x7e9e('0x40')][_0x7e9e('0x38')]?_0xbc7ec8[_0x7e9e('0x40')]:_0x2e434b['model'];if(!_0x110d4d['query'][_0x7e9e('0x68')](_0x7e9e('0x42'))){_0xbc7ec8[_0x7e9e('0x23')]=qs['limit'](_0x110d4d[_0x7e9e('0x3f')]['limit']);_0xbc7ec8[_0x7e9e('0x25')]=qs[_0x7e9e('0x25')](_0x110d4d[_0x7e9e('0x3f')][_0x7e9e('0x25')]);}_0xbc7ec8[_0x7e9e('0x43')]=qs[_0x7e9e('0x44')](_0x110d4d['query']['sort']);_0xbc7ec8[_0x7e9e('0x45')]=qs['filters'](_[_0x7e9e('0xcf')](_0x110d4d[_0x7e9e('0x3f')],_0x2e434b[_0x7e9e('0x46')]));_0xbc7ec8[_0x7e9e('0x45')][_0x7e9e('0xd4')]=_0x9cb8cc['id'];if(_0x110d4d['query']['filter']){_0xbc7ec8[_0x7e9e('0x45')]=_[_0x7e9e('0x8a')](_0xbc7ec8[_0x7e9e('0x45')],{'$or':_[_0x7e9e('0x59')](_0xbc7ec8[_0x7e9e('0x40')],function(_0x4a5555){var _0xf8a266={};_0xf8a266[_0x4a5555]={'$like':'%'+_0x110d4d[_0x7e9e('0x3f')][_0x7e9e('0x69')]+'%'};return _0xf8a266;})});}_0xbc7ec8=_[_0x7e9e('0x8a')]({},_0xbc7ec8,_0x110d4d[_0x7e9e('0xd0')]);return db['CmHopper']['count']({'where':_0xbc7ec8[_0x7e9e('0x45')]})[_0x7e9e('0x2b')](function(_0xbe5134){_0x1c0738['count']=_0xbe5134;if(_0x110d4d[_0x7e9e('0x3f')][_0x7e9e('0xd5')]){_0xbc7ec8[_0x7e9e('0xd6')]=[{'all':!![]}];}return db[_0x7e9e('0xa3')]['findAll'](_0xbc7ec8);})[_0x7e9e('0x2b')](function(_0x45dbdb){_0x1c0738['rows']=_0x45dbdb;return _0x1c0738;});}})[_0x7e9e('0x2b')](respondWithFilteredResult(_0x2a24de,_0xbc7ec8))['catch'](handleError(_0x2a24de,null));};exports['getHopperHistories']=function(_0x1cb5cd,_0x1c96ea,_0x52dd95){var _0x49b92a={'raw':!![],'where':{}};var _0x5d7ab6={};var _0x52d859={'count':0x0,'rows':[]};return db[_0x7e9e('0x35')]['findOne']({'where':{'id':_0x1cb5cd[_0x7e9e('0x97')]['id']}})['then'](handleEntityNotFound(_0x1c96ea,null))[_0x7e9e('0x2b')](function(_0xf7fdbd){if(_0xf7fdbd){_0x5d7ab6[_0x7e9e('0x3e')]=_['keys'](db[_0x7e9e('0xb3')][_0x7e9e('0xcd')]);_0x5d7ab6['query']=_[_0x7e9e('0x37')](_0x1cb5cd[_0x7e9e('0x3f')]);_0x5d7ab6[_0x7e9e('0x46')]=_['intersection'](_0x5d7ab6[_0x7e9e('0x3e')],_0x5d7ab6[_0x7e9e('0x3f')]);_0x49b92a['attributes']=_[_0x7e9e('0xce')](_0x5d7ab6['model'],qs[_0x7e9e('0x41')](_0x1cb5cd[_0x7e9e('0x3f')]['fields']));_0x49b92a[_0x7e9e('0x40')]=_0x49b92a[_0x7e9e('0x40')]['length']?_0x49b92a['attributes']:_0x5d7ab6[_0x7e9e('0x3e')];if(!_0x1cb5cd[_0x7e9e('0x3f')][_0x7e9e('0x68')](_0x7e9e('0x42'))){_0x49b92a['limit']=qs[_0x7e9e('0x23')](_0x1cb5cd['query'][_0x7e9e('0x23')]);_0x49b92a[_0x7e9e('0x25')]=qs[_0x7e9e('0x25')](_0x1cb5cd[_0x7e9e('0x3f')][_0x7e9e('0x25')]);}_0x49b92a[_0x7e9e('0x43')]=qs['sort'](_0x1cb5cd['query'][_0x7e9e('0x44')]);_0x49b92a['where']=qs[_0x7e9e('0x46')](_['pick'](_0x1cb5cd[_0x7e9e('0x3f')],_0x5d7ab6[_0x7e9e('0x46')]));_0x49b92a[_0x7e9e('0x45')][_0x7e9e('0xd4')]=_0xf7fdbd['id'];if(_0x1cb5cd[_0x7e9e('0x3f')][_0x7e9e('0x69')]){_0x49b92a[_0x7e9e('0x45')]=_[_0x7e9e('0x8a')](_0x49b92a[_0x7e9e('0x45')],{'$or':_[_0x7e9e('0x59')](_0x49b92a[_0x7e9e('0x40')],function(_0x573dc4){var _0x32bb42={};_0x32bb42[_0x573dc4]={'$like':'%'+_0x1cb5cd[_0x7e9e('0x3f')][_0x7e9e('0x69')]+'%'};return _0x32bb42;})});}_0x49b92a=_[_0x7e9e('0x8a')]({},_0x49b92a,_0x1cb5cd[_0x7e9e('0xd0')]);return db['CmHopperHistory'][_0x7e9e('0x24')]({'where':_0x49b92a['where']})[_0x7e9e('0x2b')](function(_0x2dfcb9){_0x52d859[_0x7e9e('0x24')]=_0x2dfcb9;if(_0x1cb5cd[_0x7e9e('0x3f')]['includeAll']){_0x49b92a['include']=[{'all':!![]}];}return db['CmHopperHistory'][_0x7e9e('0x9b')](_0x49b92a);})[_0x7e9e('0x2b')](function(_0x2a3082){_0x52d859[_0x7e9e('0x96')]=_0x2a3082;return _0x52d859;});}})[_0x7e9e('0x2b')](respondWithFilteredResult(_0x1c96ea,_0x49b92a))[_0x7e9e('0x98')](handleError(_0x1c96ea,null));};exports[_0x7e9e('0xd7')]=function(_0x21de07,_0x10a2c2,_0x12e65f){var _0x3a3e0c={'raw':!![],'where':{}};var _0x2e930f={};var _0x3d1d04={'count':0x0,'rows':[]};return db[_0x7e9e('0x35')][_0x7e9e('0x3b')]({'where':{'id':_0x21de07[_0x7e9e('0x97')]['id']}})[_0x7e9e('0x2b')](handleEntityNotFound(_0x10a2c2,null))[_0x7e9e('0x2b')](function(_0x576bd9){if(_0x576bd9){_0x2e930f[_0x7e9e('0x3e')]=_[_0x7e9e('0x37')](db['CmHopperFinal']['rawAttributes']);_0x2e930f[_0x7e9e('0x3f')]=_[_0x7e9e('0x37')](_0x21de07[_0x7e9e('0x3f')]);_0x2e930f[_0x7e9e('0x46')]=_[_0x7e9e('0xce')](_0x2e930f[_0x7e9e('0x3e')],_0x2e930f[_0x7e9e('0x3f')]);_0x3a3e0c['attributes']=_[_0x7e9e('0xce')](_0x2e930f[_0x7e9e('0x3e')],qs[_0x7e9e('0x41')](_0x21de07[_0x7e9e('0x3f')][_0x7e9e('0x41')]));_0x3a3e0c[_0x7e9e('0x40')]=_0x3a3e0c[_0x7e9e('0x40')]['length']?_0x3a3e0c['attributes']:_0x2e930f['model'];if(!_0x21de07[_0x7e9e('0x3f')][_0x7e9e('0x68')](_0x7e9e('0x42'))){_0x3a3e0c[_0x7e9e('0x23')]=qs[_0x7e9e('0x23')](_0x21de07[_0x7e9e('0x3f')][_0x7e9e('0x23')]);_0x3a3e0c['offset']=qs['offset'](_0x21de07[_0x7e9e('0x3f')][_0x7e9e('0x25')]);}_0x3a3e0c['order']=qs[_0x7e9e('0x44')](_0x21de07[_0x7e9e('0x3f')][_0x7e9e('0x44')]);_0x3a3e0c[_0x7e9e('0x45')]=qs[_0x7e9e('0x46')](_[_0x7e9e('0xcf')](_0x21de07[_0x7e9e('0x3f')],_0x2e930f[_0x7e9e('0x46')]));_0x3a3e0c[_0x7e9e('0x45')]['ContactId']=_0x576bd9['id'];if(_0x21de07[_0x7e9e('0x3f')][_0x7e9e('0x69')]){_0x3a3e0c[_0x7e9e('0x45')]=_[_0x7e9e('0x8a')](_0x3a3e0c['where'],{'$or':_[_0x7e9e('0x59')](_0x3a3e0c[_0x7e9e('0x40')],function(_0x40f304){var _0x5ddd52={};_0x5ddd52[_0x40f304]={'$like':'%'+_0x21de07[_0x7e9e('0x3f')]['filter']+'%'};return _0x5ddd52;})});}_0x3a3e0c=_[_0x7e9e('0x8a')]({},_0x3a3e0c,_0x21de07['options']);return db['CmHopperFinal']['count']({'where':_0x3a3e0c[_0x7e9e('0x45')]})[_0x7e9e('0x2b')](function(_0xeb5d71){_0x3d1d04[_0x7e9e('0x24')]=_0xeb5d71;if(_0x21de07[_0x7e9e('0x3f')][_0x7e9e('0xd5')]){_0x3a3e0c[_0x7e9e('0xd6')]=[{'all':!![]}];}return db['CmHopperFinal'][_0x7e9e('0x9b')](_0x3a3e0c);})[_0x7e9e('0x2b')](function(_0x31fc11){_0x3d1d04[_0x7e9e('0x96')]=_0x31fc11;return _0x3d1d04;});}})[_0x7e9e('0x2b')](respondWithFilteredResult(_0x10a2c2,_0x3a3e0c))[_0x7e9e('0x98')](handleError(_0x10a2c2,null));};exports[_0x7e9e('0xd8')]=function(_0xd455a2,_0x3483f1,_0x56f383){var _0x3580d0={'raw':!![],'where':{}};var _0x228008={};var _0x64e747={'count':0x0,'rows':[]};return db[_0x7e9e('0x35')][_0x7e9e('0x3b')]({'where':{'id':_0xd455a2['params']['id']}})['then'](handleEntityNotFound(_0x3483f1,null))[_0x7e9e('0x2b')](function(_0x54a88f){if(_0x54a88f){_0x228008['model']=_['keys'](db[_0x7e9e('0xba')][_0x7e9e('0xcd')]);_0x228008['query']=_[_0x7e9e('0x37')](_0xd455a2[_0x7e9e('0x3f')]);_0x228008[_0x7e9e('0x46')]=_[_0x7e9e('0xce')](_0x228008[_0x7e9e('0x3e')],_0x228008[_0x7e9e('0x3f')]);_0x3580d0[_0x7e9e('0x40')]=_['intersection'](_0x228008[_0x7e9e('0x3e')],qs[_0x7e9e('0x41')](_0xd455a2[_0x7e9e('0x3f')][_0x7e9e('0x41')]));_0x3580d0[_0x7e9e('0x40')]=_0x3580d0[_0x7e9e('0x40')][_0x7e9e('0x38')]?_0x3580d0['attributes']:_0x228008['model'];if(!_0xd455a2[_0x7e9e('0x3f')][_0x7e9e('0x68')]('nolimit')){_0x3580d0[_0x7e9e('0x23')]=qs['limit'](_0xd455a2['query'][_0x7e9e('0x23')]);_0x3580d0[_0x7e9e('0x25')]=qs[_0x7e9e('0x25')](_0xd455a2[_0x7e9e('0x3f')][_0x7e9e('0x25')]);}_0x3580d0[_0x7e9e('0x43')]=qs[_0x7e9e('0x44')](_0xd455a2['query'][_0x7e9e('0x44')]);_0x3580d0['where']=qs[_0x7e9e('0x46')](_['pick'](_0xd455a2['query'],_0x228008[_0x7e9e('0x46')]));_0x3580d0[_0x7e9e('0x45')][_0x7e9e('0xd4')]=_0x54a88f['id'];if(_0xd455a2[_0x7e9e('0x3f')][_0x7e9e('0x69')]){_0x3580d0[_0x7e9e('0x45')]=_[_0x7e9e('0x8a')](_0x3580d0['where'],{'$or':_['map'](_0x3580d0[_0x7e9e('0x40')],function(_0x15a128){var _0x47e33b={};_0x47e33b[_0x15a128]={'$like':'%'+_0xd455a2[_0x7e9e('0x3f')][_0x7e9e('0x69')]+'%'};return _0x47e33b;})});}_0x3580d0=_[_0x7e9e('0x8a')]({},_0x3580d0,_0xd455a2[_0x7e9e('0xd0')]);return db[_0x7e9e('0xba')][_0x7e9e('0x24')]({'where':_0x3580d0[_0x7e9e('0x45')]})[_0x7e9e('0x2b')](function(_0x120705){_0x64e747[_0x7e9e('0x24')]=_0x120705;if(_0xd455a2[_0x7e9e('0x3f')][_0x7e9e('0xd5')]){_0x3580d0[_0x7e9e('0xd6')]=[{'all':!![]}];}return db[_0x7e9e('0xba')][_0x7e9e('0x9b')](_0x3580d0);})[_0x7e9e('0x2b')](function(_0x2bb8ed){_0x64e747['rows']=_0x2bb8ed;return _0x64e747;});}})[_0x7e9e('0x2b')](respondWithFilteredResult(_0x3483f1,_0x3580d0))['catch'](handleError(_0x3483f1,null));};exports['uploadCsv']=function(_0x588184,_0x1ccba9,_0x20a483){try{if(!_0x588184[_0x7e9e('0x31')][_0x7e9e('0x6c')]){throw new Error(_0x7e9e('0xd9'));}if(!_0x588184[_0x7e9e('0x31')][_0x7e9e('0xda')]){throw new Error(_0x7e9e('0xdb'));}if(!_0x588184['body'][_0x7e9e('0xdc')]){throw new Error(_0x7e9e('0xdd'));}if(!_0x588184['body'][_0x7e9e('0xde')]){throw new Error(_0x7e9e('0xdf'));}var _0x38d974=_0x588184[_0x7e9e('0x31')][_0x7e9e('0xda')]['split'](',');var _0x3edf27=_0x588184[_0x7e9e('0x31')][_0x7e9e('0xdc')][_0x7e9e('0x58')](',');if(!_0x38d974[_0x7e9e('0x38')]||!_0x3edf27['length']||_0x38d974[_0x7e9e('0x38')]!==_0x3edf27[_0x7e9e('0x38')]){throw new Error('Incorrect\x20binding\x20parameters\x20passed!');}_0x588184[_0x7e9e('0x31')][_0x7e9e('0x41')]=_[_0x7e9e('0xe0')](_0x38d974,_0x3edf27);if(!_0x588184[_0x7e9e('0x31')][_0x7e9e('0x41')]['phone']){throw new Error(_0x7e9e('0xe1'));}if(!_0x588184['body'][_0x7e9e('0x41')]['firstName']){throw new Error('No\x20firstName\x20column\x20specified');}var _0x670f72=path[_0x7e9e('0xa0')](config[_0x7e9e('0xe2')],_0x7e9e('0xe3'),_0x588184[_0x7e9e('0xe4')][_0x7e9e('0xe5')]);fs[_0x7e9e('0xe6')](_0x670f72,parseInt('0777',0x8));var _0x26540d=require(_0x7e9e('0xe7'))[_0x7e9e('0xe8')](path[_0x7e9e('0xa0')](__dirname,'../../components/import/cm/csv'),[_0x670f72,_0x588184[_0x7e9e('0x31')]['binding_keys'],_0x588184[_0x7e9e('0x31')][_0x7e9e('0xdc')],_0x588184[_0x7e9e('0x31')][_0x7e9e('0x6c')],_0x588184[_0x7e9e('0x31')][_0x7e9e('0xe9')],_0x588184[_0x7e9e('0x31')]['duplicates'],_0x588184['body'][_0x7e9e('0xde')]]);return _0x1ccba9[_0x7e9e('0x20')](0xc8)['json']({'message':'File\x20uploaded\x20correctly!','pid':_0x26540d[_0x7e9e('0xea')]});}catch(_0x3de56f){return _0x1ccba9[_0x7e9e('0x20')](0x1f4)[_0x7e9e('0x30')](_0x3de56f);}};exports[_0x7e9e('0xeb')]=function(_0x16c536,_0x476a7e,_0x5b5a4a){var _0x39de08=fs[_0x7e9e('0xec')](_0x16c536[_0x7e9e('0xe4')][_0x7e9e('0x8')]);Papa[_0x7e9e('0xed')](_0x39de08,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x1f1368){return _0x476a7e['status'](0xc8)['json']({'file':_0x16c536[_0x7e9e('0xe4')],'fields':_0x1f1368[_0x7e9e('0xee')]['fields']});}});};exports[_0x7e9e('0xef')]=function(_0x31e14f,_0x5a0606,_0x5c2988){return db[_0x7e9e('0x5d')][_0x7e9e('0x9b')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})['then'](function(_0x25fe2d){var _0x531104=![];if(!_0x31e14f[_0x7e9e('0x31')]['ListId']){throw new Error(_0x7e9e('0xd9'));}if(!_0x31e14f[_0x7e9e('0x31')][_0x7e9e('0xf0')]['phone']){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x31e14f['body'][_0x7e9e('0xf0')][_0x7e9e('0xf1')]){throw new Error(_0x7e9e('0xf2'));}if(!_0x31e14f['body']['socket_timestamp']){throw new Error(_0x7e9e('0xdf'));}var _0x85288=require(_0x7e9e('0xe7'))[_0x7e9e('0xe8')](path[_0x7e9e('0xa0')](__dirname,_0x7e9e('0xf3')),[_0x31e14f[_0x7e9e('0x97')]['id'],JSON[_0x7e9e('0xf4')](_0x31e14f['body']),JSON[_0x7e9e('0xf4')](_0x25fe2d)]);_0x85288['on'](_0x7e9e('0x32'),function(_0x580d6c){_0x531104=!![];return _0x5a0606['status'](0xc8)['json']({'message':_0x7e9e('0xf5'),'pid':_0x85288[_0x7e9e('0xea')]});});_0x85288['on'](_0x7e9e('0xf6'),function(_0x49f2db){if(_0x49f2db&&!_0x531104){return _0x5a0606[_0x7e9e('0x20')](0x1f4)[_0x7e9e('0x21')]({'message':_0x7e9e('0xf7'),'pid':_0x85288['pid']});}});})[_0x7e9e('0x98')](handleError(_0x5a0606,null));};exports[_0x7e9e('0xf8')]=function(_0x23e6d8,_0x21666d){var _0x23a1a3=['mail',_0x7e9e('0xf9'),_0x7e9e('0xfa'),_0x7e9e('0xfb'),_0x7e9e('0xfc'),_0x7e9e('0xfd'),_0x7e9e('0xfe')];var _0x178cdb={'offset':0x0,'order':qs[_0x7e9e('0x44')](_0x7e9e('0xff'))},_0x27b43e={'count':0x0,'rows':[]};Promise[_0x7e9e('0x82')]()['then'](function(){if(_0x23e6d8['query'][_0x7e9e('0x100')]){if(!_['includes'](_0x23a1a3,_0x23e6d8['query'][_0x7e9e('0x100')][_0x7e9e('0x101')]())){throw new Error(_0x7e9e('0x102'));}_0x23a1a3=[_0x23e6d8[_0x7e9e('0x3f')]['channel']['toLowerCase']()];}if(_0x23e6d8[_0x7e9e('0x3f')]['range']){try{var _0x506434=JSON[_0x7e9e('0xed')](_0x23e6d8[_0x7e9e('0x3f')][_0x7e9e('0x103')]);if(!moment(_0x506434['from'])[_0x7e9e('0x104')]()){throw new Error('Invalid\x20date\x20for\x20range\x20from\x20filter');}if(!moment(_0x506434['to'])[_0x7e9e('0x104')]()){throw new Error('Invalid\x20date\x20for\x20range\x20to\x20filter');}}catch(_0x34b08b){throw new Error(_0x7e9e('0x105'));}}if(!_0x23e6d8['query'][_0x7e9e('0x68')](_0x7e9e('0x42'))){_0x178cdb['limit']=qs[_0x7e9e('0x23')](_0x23e6d8[_0x7e9e('0x3f')]['limit']||0xa);_0x178cdb[_0x7e9e('0x25')]=qs[_0x7e9e('0x25')](_0x23e6d8[_0x7e9e('0x3f')]['offset']);}var _0xe59d23=_0x23a1a3['map'](function(_0x412e4a){if(_0x412e4a===_0x7e9e('0xfe')){var _0x10b6b4={'attributes':['id',_0x7e9e('0x106'),_0x7e9e('0x64'),_0x7e9e('0x107'),_0x7e9e('0x108'),_0x7e9e('0x109'),_0x7e9e('0x10a'),_0x7e9e('0x10b'),'duration',_0x7e9e('0x10c'),'createdAt',_0x7e9e('0x10d'),_0x7e9e('0x10e'),_0x7e9e('0x10f'),_0x7e9e('0x110')],'where':{'ContactId':_0x23e6d8['params']['id']},'include':[{'model':db[_0x7e9e('0x5d')],'as':'User','attributes':['id',_0x7e9e('0x2f'),_0x7e9e('0x111'),_0x7e9e('0x112')]}],'order':[[_0x7e9e('0x113'),_0x7e9e('0x114')]]};if(_0x23e6d8[_0x7e9e('0x3f')][_0x7e9e('0x103')]){_0x10b6b4['where'][_0x7e9e('0x113')]={'$gte':_0x506434[_0x7e9e('0x4a')],'$lte':_0x506434['to']};}return db[_0x7e9e('0xb5')]['findAndCountAll'](_0x10b6b4)['then'](function(_0x556ede){_0x27b43e[_0x7e9e('0x24')]+=_0x556ede[_0x7e9e('0x24')];return _['map'](_0x556ede[_0x7e9e('0x96')],function(_0x5cc3fc){var _0x3d43c9=_0x5cc3fc[_0x7e9e('0x9e')]({'plain':!![]});_0x3d43c9[_0x7e9e('0x100')]=_0x412e4a;if(_0x3d43c9[_0x7e9e('0x5d')]){_0x3d43c9[_0x7e9e('0x5d')]={'id':_0x3d43c9[_0x7e9e('0x5d')]['id'],'name':_0x3d43c9[_0x7e9e('0x5d')][_0x7e9e('0x2f')],'fullname':_0x3d43c9['User']['fullname'],'alias':_0x3d43c9[_0x7e9e('0x5d')][_0x7e9e('0x112')]};}return _0x3d43c9;});});}else{var _0x4f563a=_[_0x7e9e('0x115')](_0x412e4a)+(_0x412e4a===_0x7e9e('0xf9')?_0x7e9e('0x116'):_0x7e9e('0x117'));var _0x5781b3={'attributes':['id',_0x7e9e('0x118'),_0x7e9e('0x119'),_0x7e9e('0x113'),_0x7e9e('0x10c'),_0x7e9e('0x11a'),_0x7e9e('0x11b'),'thirdDisposition','UserId',_0x4f563a+'Id'],'where':{'ContactId':_0x23e6d8[_0x7e9e('0x97')]['id']},'include':[{'model':db[_0x4f563a],'as':_0x7e9e('0x117'),'attributes':['id',_0x7e9e('0x2f'),_0x7e9e('0x11c')]},{'model':db[_0x7e9e('0x5d')],'as':'Owner','attributes':['id','name',_0x7e9e('0x111')]},{'model':db['Tag'],'as':'Tags','attributes':['id',_0x7e9e('0x2f'),_0x7e9e('0x49')],'through':{'attributes':[]}}],'order':[[_0x7e9e('0x113'),_0x7e9e('0x114')]]};if(_0x23e6d8['query'][_0x7e9e('0x103')]){_0x5781b3[_0x7e9e('0x45')][_0x7e9e('0x113')]={'$gte':_0x506434[_0x7e9e('0x4a')],'$lte':_0x506434['to']};}switch(_0x412e4a){case _0x7e9e('0xf9'):_0x5781b3[_0x7e9e('0x40')][_0x7e9e('0x6a')](_0x7e9e('0x11d'),'customerIp',_0x7e9e('0x11e'),_0x7e9e('0x11f'),'osName','ratingMessage',_0x7e9e('0x120'),_0x7e9e('0x121'),'referer');break;case _0x7e9e('0x122'):_0x5781b3['attributes'][_0x7e9e('0x6a')](_0x7e9e('0x123'),_0x7e9e('0x124'));break;case _0x7e9e('0xfb'):_0x5781b3[_0x7e9e('0x40')]['push'](_0x7e9e('0x125'),_0x7e9e('0x126'));break;}return db[_['startCase'](_0x412e4a)+_0x7e9e('0x127')][_0x7e9e('0x128')](_0x5781b3)[_0x7e9e('0x2b')](function(_0x55ec97){_0x27b43e[_0x7e9e('0x24')]+=_0x55ec97[_0x7e9e('0x24')];return _[_0x7e9e('0x59')](_0x55ec97[_0x7e9e('0x96')],function(_0x35ce56){var _0x1233b9=_0x35ce56[_0x7e9e('0x9e')]({'plain':!![]});_0x1233b9[_0x7e9e('0x100')]=_0x412e4a;if(_0x1233b9['Owner']){_0x1233b9[_0x7e9e('0x129')]={'id':_0x1233b9[_0x7e9e('0x129')]['id'],'name':_0x1233b9[_0x7e9e('0x129')][_0x7e9e('0x2f')],'fullname':_0x1233b9[_0x7e9e('0x129')]['fullname']};}return _0x1233b9;});});}});return Promise[_0x7e9e('0x3d')](_0xe59d23);})[_0x7e9e('0x2b')](function(_0x131828){return _(_0x131828)[_0x7e9e('0x12a')]()['sortBy'](_0x7e9e('0x113'))[_0x7e9e('0x12b')]()[_0x7e9e('0x57')]();})[_0x7e9e('0x2b')](function(_0x4bd67c){_0x27b43e[_0x7e9e('0x96')]=_0x178cdb['limit']?_0x4bd67c['slice'](_0x178cdb[_0x7e9e('0x25')],_0x178cdb['offset']+_0x178cdb['limit']):_0x4bd67c;return _0x27b43e;})[_0x7e9e('0x2b')](respondWithFilteredResult(_0x21666d,_0x178cdb))[_0x7e9e('0x98')](handleError(_0x21666d,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff