// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x3791=['userThirdDisposition','UserId','fullname','startCase','Account','closed','closedAt','disposition','secondDisposition','thirdDisposition','key','Owner','browserName','customerPort','osName','ratingMessage','ratingType','referer','subject','externalUrl','threadId','Interaction','findAndCountAll','flatten','reverse','eml-format','zip-dir','fast-json-patch','request-promise','mustache','util','path','sox','to-csv','ejs','fs-extra','squel','crypto','jsforce','desk.js','papaparse','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','api','../../config/environment','../../config/license/util','../../mysqldb','defaults','redis','localhost','./cmContact.socket','register','sendStatus','status','end','json','offset','limit','undefined','count','set','apply','reject','save','update','destroy','name','send','CmContact','then','keys','length','startsWith','cf_','push','CmCustomField','findOne','trimStart','all','fieldType','type','model','query','filters','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','where','pick','select','field','color','from','tools_tags','left_join','cm_user_has_contacts','uc.CmContactId\x20=\x20c.id','ct.CmContactId\x20=\x20c.id','t.id\x20=\x20ct.TagId','expr','search','sqlOperator','conditions','find','Tag','map','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','User','uc.UserId\x20=\x20?','value','dateOfBirth','castTo','DATE','buildExpression','text','isNil','Contact','isEmpty','ListId','c.ListId\x20IN\x20?','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','tag','isArray','filter','replace','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','isNumeric','c.id\x20LIKE\x20?','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','group','c.id','Sequelize','QueryTypes','SELECT','clone','DESC','having','t.id\x20IN\x20?','user','role','agent','some','getLists','c.ListId\x20IS\x20NULL','toString','sequelize','keyBy','merge','c.phone','c.fax','c.email','c.ListId','c.createdAt','c.deletedAt','c.CompanyId','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','Tags','catch','describe','tags','columnName','displayName','findAll','alias','custom','values','body','get','mergeWith','join','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','ChatInteraction','ChatMessage','ChatOfflineMessage','MailMessage','SmsInteraction','SmsMessage','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','JscriptySessionReport','WhatsappMessage','WhatsappQueueReport','create','each','duplicates','$or','error','show','params','$and','omit','format','cf_%d','pickBy','table','cm_contacts','setFields','toParam','phone','getTags','rawAttributes','options','setTags','ContactId','includeAll','include','rows','getHopperHistories','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','binding_keys','split','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','root','file','filename','chmodSync','../../components/import/cm/csv','CompanyId','pid','upload','createReadStream','parse','meta','binding','fork','stringify','message','start\x20child\x20process\x20correctly!','exit','getJourney','mail','chat','sms','openchannel','fax','voice','-createdAt','resolve','channel','toLowerCase','range','isValid','Invalid\x20date\x20for\x20range\x20to\x20filter','uniqueid','source','destination','callerid','starttime','endtime','duration','note','createdAt','userSecondDisposition'];(function(_0x57b54c,_0x54ce0d){var _0x59cc19=function(_0xa33bc6){while(--_0xa33bc6){_0x57b54c['push'](_0x57b54c['shift']());}};_0x59cc19(++_0x54ce0d);}(_0x3791,0x13b));var _0x1379=function(_0x599254,_0x300034){_0x599254=_0x599254-0x0;var _0x14e70f=_0x3791[_0x599254];return _0x14e70f;};'use strict';var emlformat=require(_0x1379('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x1379('0x1'));var jsonpatch=require(_0x1379('0x2'));var rp=require(_0x1379('0x3'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x1379('0x4'));var util=require(_0x1379('0x5'));var path=require(_0x1379('0x6'));var sox=require(_0x1379('0x7'));var csv=require(_0x1379('0x8'));var ejs=require(_0x1379('0x9'));var fs=require('fs');var fs_extra=require(_0x1379('0xa'));var _=require('lodash');var squel=require(_0x1379('0xb'));var crypto=require(_0x1379('0xc'));var jsforce=require(_0x1379('0xd'));var deskjs=require(_0x1379('0xe'));var toCsv=require(_0x1379('0x8'));var querystring=require('querystring');var Papa=require(_0x1379('0xf'));var Redis=require('ioredis');var authService=require(_0x1379('0x10'));var qs=require(_0x1379('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x1379('0x12'));var logger=require('../../config/logger')(_0x1379('0x13'));var utils=require('../../config/utils');var config=require(_0x1379('0x14'));var licenseUtil=require(_0x1379('0x15'));var db=require(_0x1379('0x16'))['db'];config['redis']=_[_0x1379('0x17')](config[_0x1379('0x18')],{'host':_0x1379('0x19'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x1379('0x18')]));require(_0x1379('0x1a'))[_0x1379('0x1b')](socket);function respondWithStatusCode(_0x294e09,_0x50f05c){_0x50f05c=_0x50f05c||0xcc;return function(_0x156ce7){if(_0x156ce7){return _0x294e09[_0x1379('0x1c')](_0x50f05c);}return _0x294e09[_0x1379('0x1d')](_0x50f05c)[_0x1379('0x1e')]();};}function respondWithResult(_0x103d7a,_0x136cf0){_0x136cf0=_0x136cf0||0xc8;return function(_0xf201c1){if(_0xf201c1){return _0x103d7a[_0x1379('0x1d')](_0x136cf0)[_0x1379('0x1f')](_0xf201c1);}};}function respondWithFilteredResult(_0x484de7,_0x579345){return function(_0x58f55a){if(_0x58f55a){var _0x3b03c7=typeof _0x579345[_0x1379('0x20')]==='undefined'&&typeof _0x579345[_0x1379('0x21')]===_0x1379('0x22');var _0x1bb794=_0x58f55a[_0x1379('0x23')];var _0x575e21=_0x3b03c7?0x0:_0x579345['offset'];var _0x1e7602=_0x3b03c7?_0x58f55a[_0x1379('0x23')]:_0x579345[_0x1379('0x20')]+_0x579345['limit'];var _0x50c8f0;if(_0x1e7602>=_0x1bb794){_0x1e7602=_0x1bb794;_0x50c8f0=0xc8;}else{_0x50c8f0=0xce;}_0x484de7['status'](_0x50c8f0);return _0x484de7[_0x1379('0x24')]('Content-Range',_0x575e21+'-'+_0x1e7602+'/'+_0x1bb794)[_0x1379('0x1f')](_0x58f55a);}return null;};}function patchUpdates(_0x46fdd7){return function(_0x5c2cdb){try{jsonpatch[_0x1379('0x25')](_0x5c2cdb,_0x46fdd7,!![]);}catch(_0x1dc98d){return BPromise[_0x1379('0x26')](_0x1dc98d);}return _0x5c2cdb[_0x1379('0x27')]();};}function saveUpdates(_0x28a49d,_0xe44cc8){return function(_0xf45d96){if(_0xf45d96){return _0xf45d96[_0x1379('0x28')](_0x28a49d)['then'](function(_0x16ff8e){return _0x16ff8e;});}return null;};}function removeEntity(_0x3e97fe,_0x22d685){return function(_0x1090c8){if(_0x1090c8){return _0x1090c8[_0x1379('0x29')]()['then'](function(){_0x3e97fe[_0x1379('0x1d')](0xcc)[_0x1379('0x1e')]();});}};}function handleEntityNotFound(_0x4fa598,_0x2ecad2){return function(_0x127250){if(!_0x127250){_0x4fa598[_0x1379('0x1c')](0x194);}return _0x127250;};}function handleError(_0x4832d2,_0x24a710){_0x24a710=_0x24a710||0x1f4;return function(_0x3b0230){logger['error'](_0x3b0230['stack']);if(_0x3b0230['name']){delete _0x3b0230[_0x1379('0x2a')];}_0x4832d2[_0x1379('0x1d')](_0x24a710)[_0x1379('0x2b')](_0x3b0230);};}exports['index']=function(_0x5c3451,_0x3a9adc){var _0xcefe72={},_0x2f97a4={},_0x33e668={'count':0x0,'rows':[]};return db[_0x1379('0x2c')]['describe']()[_0x1379('0x2d')](function(_0x19c241){var _0x1ef7e3=[];for(var _0x2eee84=0x0;_0x2eee84<Object[_0x1379('0x2e')](_0x19c241)[_0x1379('0x2f')];_0x2eee84++){var _0x2653e5=Object[_0x1379('0x2e')](_0x19c241)[_0x2eee84];if(_[_0x1379('0x30')](_0x2653e5,_0x1379('0x31'))){_0x1ef7e3[_0x1379('0x32')](db[_0x1379('0x33')][_0x1379('0x34')]({'where':{'id':_[_0x1379('0x35')](_0x2653e5,'cf_')},'raw':!![]}));}}return BPromise[_0x1379('0x36')](_0x1ef7e3)[_0x1379('0x2d')](function(_0x29fd1c){for(var _0x330849=0x0;_0x330849<_0x29fd1c['length'];_0x330849++){if(_0x29fd1c[_0x330849]){var _0x10729a=_0x1379('0x31')+_0x29fd1c[_0x330849]['id'];var _0x18230d=_0x19c241[_0x10729a];_0x18230d[_0x1379('0x37')]=_0x29fd1c[_0x330849][_0x1379('0x38')];}}return _0x19c241;});})[_0x1379('0x2d')](function(_0x486c14){_0x2f97a4[_0x1379('0x39')]=_[_0x1379('0x2e')](_0x486c14);_0x2f97a4[_0x1379('0x3a')]=_[_0x1379('0x2e')](_0x5c3451[_0x1379('0x3a')]);_0x2f97a4[_0x1379('0x3b')]=_[_0x1379('0x3c')](_0x2f97a4[_0x1379('0x39')],_0x2f97a4[_0x1379('0x3a')]);_0xcefe72[_0x1379('0x3d')]=_[_0x1379('0x3c')](_0x2f97a4[_0x1379('0x39')],qs[_0x1379('0x3e')](_0x5c3451[_0x1379('0x3a')][_0x1379('0x3e')]));_0xcefe72[_0x1379('0x3d')]=_0xcefe72[_0x1379('0x3d')][_0x1379('0x2f')]?_0xcefe72[_0x1379('0x3d')]:_0x2f97a4[_0x1379('0x39')];if(!_0x5c3451[_0x1379('0x3a')][_0x1379('0x3f')](_0x1379('0x40'))){_0xcefe72[_0x1379('0x21')]=qs['limit'](_0x5c3451[_0x1379('0x3a')][_0x1379('0x21')]);_0xcefe72['offset']=qs[_0x1379('0x20')](_0x5c3451[_0x1379('0x3a')][_0x1379('0x20')]);}_0xcefe72[_0x1379('0x41')]=qs[_0x1379('0x42')](_0x5c3451[_0x1379('0x3a')]['sort']);_0xcefe72[_0x1379('0x43')]=qs['filters'](_[_0x1379('0x44')](_0x5c3451['query'],_0x2f97a4[_0x1379('0x3b')]),_0x486c14);var _0x515d00=[];var _0x46a059=squel[_0x1379('0x45')]()[_0x1379('0x46')]('id')['field']('name')['field'](_0x1379('0x47'))[_0x1379('0x48')](_0x1379('0x49'));var _0x31d058=squel['select']()[_0x1379('0x48')]('cm_contacts','c')[_0x1379('0x4a')](_0x1379('0x4b'),'uc',_0x1379('0x4c'))[_0x1379('0x4a')]('cm_contact_has_tags','ct',_0x1379('0x4d'))['left_join'](_0x1379('0x49'),'t',_0x1379('0x4e'))[_0x1379('0x43')]('c.deletedAt\x20IS\x20NULL');var _0xc661e=squel[_0x1379('0x4f')]();var _0xe487e6=[];var _0x576ce1=squel['expr']();var _0x103d04;if(_0x5c3451['query'][_0x1379('0x50')]){_0x103d04=as['parseSearch'](_0x5c3451[_0x1379('0x3a')]['search']);var _0x10492d=_0x103d04[_0x1379('0x51')];for(var _0x535798=0x0;_0x535798<_0x103d04[_0x1379('0x52')]['length'];_0x535798++){var _0x3527f1=_0x103d04[_0x1379('0x52')][_0x535798];var _0x2a14f7='c';var _0x344345=_(_0x486c14)['keys']()[_0x1379('0x53')](function(_0x27d811){return _0x27d811===_0x3527f1['field'];});if(_0x344345)_0x344345=_0x486c14[_0x3527f1[_0x1379('0x46')]];if(!_0x344345){if(_0x3527f1['field']===_0x1379('0x54')){var _0x3b6959=_0x3527f1['value']['split'](',')[_0x1379('0x55')](function(_0x1d164f){return Number(_0x1d164f);});_0x3b6959[_0x1379('0x56')](function(_0x2216ce){_0x576ce1['or'](_0x1379('0x57'),'%,'+_0x2216ce+',%');});_0xe487e6=_['union'](_0xe487e6,_0x3b6959);}else if(_0x3527f1[_0x1379('0x46')]===_0x1379('0x58')){_0xc661e['and'](_0x1379('0x59'),_0x3527f1[_0x1379('0x5a')]);}}else{if(_0x3527f1[_0x1379('0x46')]===_0x1379('0x5b')||_0x344345['fieldType']==='datetime')_0x3527f1[_0x1379('0x5c')]=_0x1379('0x5d');var _0x5cfa7f=as[_0x1379('0x5e')](_0x2a14f7,_0x344345['type'],_0x3527f1);_0xc661e[_0x10492d](_0x5cfa7f[_0x1379('0x5f')],_0x5cfa7f[_0x1379('0x5a')]['start'],_0x5cfa7f['value']['end']);}}}else{var _0x272e60=_(Object[_0x1379('0x2e')](_0x5c3451[_0x1379('0x3a')]))[_0x1379('0x55')](function(_0xc04bc4){return _0x486c14[_0x1379('0x3f')](_0xc04bc4)?_0xc04bc4:undefined;})['filter'](function(_0x2f8f40){return!_[_0x1379('0x60')](_0x2f8f40);})[_0x1379('0x5a')]();if(_0x5c3451[_0x1379('0x3a')][_0x1379('0x61')])_0x272e60['push'](_0x1379('0x61'));if(!_[_0x1379('0x62')](_0x272e60)){_0x272e60[_0x1379('0x56')](function(_0x543514){if(_0x543514===_0x1379('0x63')){_0x31d058['where'](_0x1379('0x64'),[]['concat'](_0x5c3451[_0x1379('0x3a')][_0x543514]));}else if(_0x543514===_0x1379('0x61')){var _0x9e58b9='%'+_0x5c3451[_0x1379('0x3a')][_0x543514]+'%';_0x31d058['where'](_0x1379('0x65'),_0x9e58b9);}else{_0x31d058['where']('c.'+_0x543514+_0x1379('0x66'),_0x5c3451[_0x1379('0x3a')][_0x543514]);}});}if(_0x5c3451[_0x1379('0x3a')][_0x1379('0x67')]){_0xe487e6=_[_0x1379('0x68')](_0x5c3451['query']['tag'])?_0x5c3451[_0x1379('0x3a')][_0x1379('0x67')]:new Array(_0x5c3451[_0x1379('0x3a')][_0x1379('0x67')]);_0xe487e6[_0x1379('0x56')](function(_0x28983f){_0x576ce1['or'](_0x1379('0x57'),'%,'+_0x28983f+',%');});}if(_0x5c3451[_0x1379('0x3a')][_0x1379('0x69')]){var _0x310212=_0x5c3451['query'][_0x1379('0x69')][_0x1379('0x6a')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(_0x310212['split']('\x20')[_0x1379('0x2f')]>0x1){_0xc661e['or'](_0x1379('0x6b'),qs[_0x1379('0x6c')](_0x310212),null);}else{if(qs[_0x1379('0x6d')](_0x310212)){_0xc661e['or'](_0x1379('0x6e'),_0x310212+'%');_0xc661e['or'](_0x1379('0x6f'),_0x310212+'%');_0xc661e['or'](_0x1379('0x70'),_0x310212+'%');_0xc661e['or'](_0x1379('0x71'),_0x310212+'%');}else if(qs[_0x1379('0x72')](_0x310212)){_0xc661e['or'](_0x1379('0x73'),_0x310212+'%');}else{_0xc661e['or'](_0x1379('0x74'),'%'+_0x310212+'%');_0xc661e['or'](_0x1379('0x75'),'%'+_0x310212+'%');_0xc661e['or'](_0x1379('0x73'),'%'+_0x310212+'%');}}}}_0x31d058['where'](_0xc661e);_0x31d058[_0x1379('0x76')](_0x1379('0x77'));var _0x2e6833={'type':db[_0x1379('0x78')][_0x1379('0x79')][_0x1379('0x7a')],'raw':!![]};var _0xdbbe5b=_0x31d058[_0x1379('0x7b')]()[_0x1379('0x46')](_0x1379('0x77'));if(_0xcefe72[_0x1379('0x41')]){_0xcefe72['order'][_0x1379('0x56')](function(_0x1f1789){_0x31d058['order']('c.'+_0x1f1789[0x0],_0x1f1789[0x1]===_0x1379('0x7c')?![]:!![]);});}if(!_[_0x1379('0x62')](_0xe487e6)){_0x31d058[_0x1379('0x7d')](_0x576ce1);_0xdbbe5b[_0x1379('0x43')](_0x1379('0x7e'),_0xe487e6);}BPromise['resolve']()[_0x1379('0x2d')](function(){if(!_0x103d04)return;if(_0x5c3451[_0x1379('0x7f')][_0x1379('0x80')]!==_0x1379('0x81'))return;if(!_[_0x1379('0x82')](_0x103d04['conditions'],[_0x1379('0x46'),_0x1379('0x58')])){return _0x5c3451['user'][_0x1379('0x83')]({'attributes':['id'],'raw':!![]})['then'](function(_0x197c62){if(_[_0x1379('0x62')](_0x197c62)){_0xdbbe5b['where'](_0x1379('0x84'));_0x31d058[_0x1379('0x43')]('c.ListId\x20IS\x20NULL');}else{_0xdbbe5b[_0x1379('0x43')](_0x1379('0x64'),_['map'](_0x197c62,'id'));_0x31d058['where']('c.ListId\x20IN\x20?',_['map'](_0x197c62,'id'));}});}})[_0x1379('0x2d')](function(){if(_0x5c3451[_0x1379('0x7f')][_0x1379('0x80')]==='agent'&&!_0x103d04&&!_0x5c3451['query'][_0x1379('0x63')])return[];return db['sequelize'][_0x1379('0x3a')](_0xdbbe5b[_0x1379('0x85')](),_0x2e6833);})[_0x1379('0x2d')](function(_0x491624){_0x33e668[_0x1379('0x23')]=_0x491624['length'];if(_0x33e668[_0x1379('0x23')]===0x0)return[];return db[_0x1379('0x86')][_0x1379('0x3a')](_0x46a059[_0x1379('0x85')](),_0x2e6833)[_0x1379('0x2d')](function(_0x6e0aed){_0x515d00=_[_0x1379('0x87')](_0x6e0aed,'id');_0x2e6833=_[_0x1379('0x88')](_0x2e6833,{'model':db[_0x1379('0x2c')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x5c3451[_0x1379('0x3a')][_0x1379('0x3e')]){_0xcefe72[_0x1379('0x3d')]['forEach'](function(_0x1c63a1){_0x31d058[_0x1379('0x46')]('c.'+_0x1c63a1);});}else{_0x31d058[_0x1379('0x46')](_0x1379('0x77'));_0x31d058[_0x1379('0x46')]('c.firstName');_0x31d058[_0x1379('0x46')]('c.lastName');_0x31d058[_0x1379('0x46')](_0x1379('0x89'));_0x31d058['field']('c.mobile');_0x31d058[_0x1379('0x46')](_0x1379('0x8a'));_0x31d058[_0x1379('0x46')](_0x1379('0x8b'));_0x31d058['field'](_0x1379('0x8c'));_0x31d058[_0x1379('0x46')](_0x1379('0x8d'));_0x31d058[_0x1379('0x46')](_0x1379('0x8e'));_0x31d058['field'](_0x1379('0x8f'));_0x31d058['field'](_0x1379('0x90'),_0x1379('0x91'));}if(_0xcefe72[_0x1379('0x21')])_0x31d058[_0x1379('0x21')](_0xcefe72['limit']);if(_0xcefe72['offset'])_0x31d058[_0x1379('0x20')](_0xcefe72[_0x1379('0x20')]);return db[_0x1379('0x86')][_0x1379('0x3a')](_0x31d058[_0x1379('0x85')](),_0x2e6833);});})['then'](function(_0x243b93){_0x243b93[_0x1379('0x56')](function(_0x44648f){if(_0x44648f[_0x1379('0x91')]){_0x44648f[_0x1379('0x92')]=[];_0x44648f[_0x1379('0x91')]['split'](',')[_0x1379('0x56')](function(_0x2322cd){_0x44648f['Tags']['push'](_0x515d00[_0x2322cd]);});}delete _0x44648f[_0x1379('0x91')];});_0x33e668['rows']=_0x243b93;return _0x33e668;})['then'](respondWithFilteredResult(_0x3a9adc,_0xcefe72));})[_0x1379('0x93')](handleError(_0x3a9adc,null));};exports[_0x1379('0x29')]=function(_0x4e9273,_0x22b9c6){return db[_0x1379('0x2c')][_0x1379('0x53')]({'where':{'id':_0x4e9273['params']['id']}})[_0x1379('0x2d')](handleEntityNotFound(_0x22b9c6,null))[_0x1379('0x2d')](removeEntity(_0x22b9c6,null))[_0x1379('0x93')](handleError(_0x22b9c6,null));};exports['describe']=function(_0x4af0f1,_0x1be8d0){return db[_0x1379('0x2c')][_0x1379('0x94')]()[_0x1379('0x2d')](function(_0x38c50a){delete _0x38c50a[_0x1379('0x95')];for(var _0x1a11ec=0x0;_0x1a11ec<Object[_0x1379('0x2e')](_0x38c50a)['length'];_0x1a11ec++){var _0x5aa822=Object[_0x1379('0x2e')](_0x38c50a)[_0x1a11ec];if(!_[_0x1379('0x30')](_0x5aa822,'cf_')){_0x38c50a[_0x5aa822][_0x1379('0x96')]=_0x5aa822;_0x38c50a[_0x5aa822][_0x1379('0x97')]=_0x5aa822;}}return _0x38c50a;})['then'](function(_0x40af6d){var _0x11cfb3={'where':{'$or':[{'ListId':_0x4af0f1[_0x1379('0x3a')]['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField'][_0x1379('0x98')](_0x11cfb3)[_0x1379('0x2d')](function(_0x5c8f88){for(var _0x467f3b=0x0;_0x467f3b<_0x5c8f88[_0x1379('0x2f')];_0x467f3b++){var _0x3f8f8d=_0x1379('0x31')+_0x5c8f88[_0x467f3b]['id'];_0x40af6d[_0x3f8f8d][_0x1379('0x96')]=_0x3f8f8d;_0x40af6d[_0x3f8f8d][_0x1379('0x97')]=_0x5c8f88[_0x467f3b][_0x1379('0x99')];_0x40af6d[_0x3f8f8d][_0x1379('0x9a')]={'type':_0x5c8f88[_0x467f3b][_0x1379('0x38')],'values':_0x5c8f88[_0x467f3b][_0x1379('0x9b')]};}Object[_0x1379('0x2e')](_0x40af6d)['forEach'](function(_0x2f1879){if(!_0x40af6d[_0x2f1879]['hasOwnProperty']('columnName')){delete _0x40af6d[_0x2f1879];}});return _0x40af6d;});})[_0x1379('0x2d')](respondWithResult(_0x1be8d0,null))[_0x1379('0x93')](handleError(_0x1be8d0,null));};exports[_0x1379('0x88')]=function(_0x615624,_0x525724){var _0x1d1c27;var _0x5db5dc;var _0x1648f0;if(_0x615624[_0x1379('0x9c')]['id']){delete _0x615624['body']['id'];}return db[_0x1379('0x2c')]['findAll']({'where':{'id':[_0x615624[_0x1379('0x9c')]['to'],_0x615624[_0x1379('0x9c')][_0x1379('0x48')]]}})[_0x1379('0x2d')](function(_0x2c89e3){if(_0x2c89e3){if(_0x2c89e3['length']!==0x2){return null;}_0x2c89e3[0x0]=_0x2c89e3[0x0][_0x1379('0x9d')]({'plain':!![]});_0x2c89e3[0x1]=_0x2c89e3[0x1]['get']({'plain':!![]});delete _0x2c89e3[0x0]['id'];delete _0x2c89e3[0x1]['id'];return _[_0x1379('0x9e')](_0x2c89e3[0x0],_0x2c89e3[0x1],function(_0x35c6f1,_0x3a940a){if(Array[_0x1379('0x68')](_0x3a940a)&&!_0x3a940a[_0x1379('0x2f')]){return _0x35c6f1;}else if(!_0x3a940a){return _0x35c6f1;}});}})[_0x1379('0x2d')](handleEntityNotFound(_0x525724,null))[_0x1379('0x2d')](function(_0x36f547){if(_0x36f547){if(_0x36f547[_0x1379('0x95')]&&_['isArray'](_0x36f547[_0x1379('0x95')])){_0x36f547[_0x1379('0x95')]=_0x36f547[_0x1379('0x95')][_0x1379('0x9f')]();}logger[_0x1379('0xa0')](_0x1379('0xa1'),_0x615624[_0x1379('0x9c')]['to'],_0x615624[_0x1379('0x9c')][_0x1379('0x48')]);return db[_0x1379('0xa2')][_0x1379('0x29')]({'where':{'ContactId':[_0x615624[_0x1379('0x9c')]['to'],_0x615624[_0x1379('0x9c')]['from']]}})[_0x1379('0x2d')](function(_0x3dbee3){logger[_0x1379('0xa0')](_0x1379('0xa3'),_0x3dbee3);return db[_0x1379('0xa4')]['destroy']({'where':{'ContactId':[_0x615624['body']['to'],_0x615624[_0x1379('0x9c')]['from']]}})[_0x1379('0x2d')](function(_0x28792e){logger['info']('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x28792e);return db[_0x1379('0x2c')]['create'](_0x36f547);});});}})[_0x1379('0x2d')](function(_0x3a87b5){if(_0x3a87b5){_0x1d1c27=_0x3a87b5;_0x5db5dc={'ContactId':_0x1d1c27['id']};_0x1648f0={'where':{'ContactId':[_0x615624[_0x1379('0x9c')]['to'],_0x615624['body'][_0x1379('0x48')]]}};return db[_0x1379('0xa5')][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})[_0x1379('0x2d')](function(){if(_0x1d1c27){return db[_0x1379('0xa6')][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})[_0x1379('0x2d')](function(){if(_0x1d1c27){return db[_0x1379('0xa7')][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})['then'](function(){if(_0x1d1c27){return db['MailInteraction'][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})[_0x1379('0x2d')](function(){if(_0x1d1c27){return db['MailMessage'][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})['then'](function(){if(_0x1d1c27){return db['MailInteraction'][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})[_0x1379('0x2d')](function(){if(_0x1d1c27){return db[_0x1379('0xa8')][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})[_0x1379('0x2d')](function(){if(_0x1d1c27){return db[_0x1379('0xa9')][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})['then'](function(){if(_0x1d1c27){return db[_0x1379('0xaa')][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})[_0x1379('0x2d')](function(){if(_0x1d1c27){return db['FaxInteraction'][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})['then'](function(){if(_0x1d1c27){return db[_0x1379('0xab')][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})[_0x1379('0x2d')](function(){if(_0x1d1c27){return db[_0x1379('0xac')]['update'](_0x5db5dc,_0x1648f0);}})['then'](function(){if(_0x1d1c27){return db[_0x1379('0xad')][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})[_0x1379('0x2d')](function(){if(_0x1d1c27){return db[_0x1379('0xae')]['update'](_0x5db5dc,_0x1648f0);}})[_0x1379('0x2d')](function(){if(_0x1d1c27){return db[_0x1379('0xaf')][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})[_0x1379('0x2d')](function(){if(_0x1d1c27){return db[_0x1379('0xb0')][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})[_0x1379('0x2d')](function(){if(_0x1d1c27){return db[_0x1379('0xb1')][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})[_0x1379('0x2d')](function(){if(_0x1d1c27){return db[_0x1379('0xb2')][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})[_0x1379('0x2d')](function(){if(_0x1d1c27){return db[_0x1379('0xb3')]['update'](_0x5db5dc,_0x1648f0);}})[_0x1379('0x2d')](function(){if(_0x1d1c27){return db['MailQueueReport']['update'](_0x5db5dc,_0x1648f0);}})[_0x1379('0x2d')](function(){if(_0x1d1c27){return db['OpenchannelQueueReport'][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})[_0x1379('0x2d')](function(){if(_0x1d1c27){return db['SmsQueueReport'][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})[_0x1379('0x2d')](function(){if(_0x1d1c27){return db[_0x1379('0xb4')][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})['then'](function(){if(_0x1d1c27){return db['WhatsappInteraction'][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})['then'](function(){if(_0x1d1c27){return db[_0x1379('0xb5')][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})['then'](function(){if(_0x1d1c27){return db[_0x1379('0xb6')][_0x1379('0x28')](_0x5db5dc,_0x1648f0);}})[_0x1379('0x2d')](function(){if(_0x1d1c27){return db[_0x1379('0x2c')][_0x1379('0x29')]({'where':{'id':[_0x615624['body']['to'],_0x615624[_0x1379('0x9c')][_0x1379('0x48')]]}});}})[_0x1379('0x2d')](function(){if(_0x1d1c27){return _0x1d1c27;}})[_0x1379('0x2d')](respondWithResult(_0x525724,null))[_0x1379('0x93')](handleError(_0x525724,null));};exports['create']=function(_0x56a07d,_0x3a0ca5){return db[_0x1379('0x2c')][_0x1379('0x94')]()[_0x1379('0x2d')](function(_0x4eda9b){if(_0x56a07d['body']['tags']&&_['isArray'](_0x56a07d[_0x1379('0x9c')][_0x1379('0x95')])){if(_0x56a07d[_0x1379('0x9c')][_0x1379('0x95')][_0x1379('0x2f')]){_0x56a07d[_0x1379('0x9c')]['tags']=_0x56a07d[_0x1379('0x9c')][_0x1379('0x95')][_0x1379('0x9f')](';')+';';}else{_0x56a07d[_0x1379('0x9c')][_0x1379('0x95')]=null;}}else{_0x56a07d['body']['tags']=null;}return db[_0x1379('0x2c')][_0x1379('0xb7')](_0x56a07d[_0x1379('0x9c')],{'fields':_[_0x1379('0x2e')](_0x4eda9b),'raw':!![]});})[_0x1379('0x2d')](respondWithResult(_0x3a0ca5,0xc9))['catch'](handleError(_0x3a0ca5,null));};exports['bulkCreate']=function(_0x2ce07c,_0x51f595){var _0x3066d4=[];var _0x5dc579=0x0;var _0x49e0f9=0x0;var _0x1c7d7d=0x0;return db['CmContact'][_0x1379('0x94')]()[_0x1379('0x2d')](function(_0xf148c1){return BPromise[_0x1379('0xb8')](_0x2ce07c[_0x1379('0x9c')],function(_0x206b6f){var _0x48faef={'where':{'$or':[]},'defaults':_0x206b6f,'fields':_[_0x1379('0x2e')](_0xf148c1),'raw':!![]};if(_0x206b6f[_0x1379('0xb9')]){for(var _0x3b3135=0x0;_0x3b3135<_0x206b6f[_0x1379('0xb9')][_0x1379('0x2f')];_0x3b3135++){var _0x5d237a={};_0x5d237a[_0x206b6f['duplicates'][_0x3b3135]]=_0x206b6f[_0x206b6f[_0x1379('0xb9')][_0x3b3135]];_0x48faef['where'][_0x1379('0xba')]['push'](_0x5d237a);}_0x48faef[_0x1379('0x43')]['ListId']=_0x206b6f[_0x1379('0x63')];}return db[_0x1379('0x2c')]['findOrCreate'](_0x48faef)['spread'](function(_0x3c7d62,_0x120926){if(_0x120926){_0x5dc579++;}else{_0x1c7d7d++;}})[_0x1379('0x93')](function(_0x339ba2){console[_0x1379('0xbb')](_0x339ba2);_0x49e0f9++;});});})[_0x1379('0x2d')](function(_0x35d703){if(_0x35d703){return{'success':_0x5dc579,'failure':_0x49e0f9,'duplicates':_0x1c7d7d};}})['then'](respondWithResult(_0x51f595,0xc9))[_0x1379('0x93')](handleError(_0x51f595,null));};exports[_0x1379('0xbc')]=function(_0x34c286,_0x4c56ad,_0x3a03c2){var _0x4d892e;return db[_0x1379('0x2c')][_0x1379('0x94')]()['then'](function(_0x26dec9){return db['CmContact'][_0x1379('0x53')]({'where':{'id':_0x34c286[_0x1379('0xbd')]['id']},'include':[{'model':db['Tag'],'as':'Tags','attributes':['id',_0x1379('0x2a'),_0x1379('0x47')],'required':_0x34c286['query'][_0x1379('0x67')]?!![]:![]}],'attributes':_[_0x1379('0x2e')](_0x26dec9)});})['then'](function(_0x20eaf){_0x4d892e=_0x20eaf[_0x1379('0x9d')]({'plain':!![]});var _0x3b824a={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x20eaf&&_0x20eaf[_0x1379('0x63')]){if(_0x20eaf[_0x1379('0x63')]){_0x3b824a[_0x1379('0x43')][_0x1379('0xbe')][_0x1379('0x32')]({'ListId':{'$ne':_0x20eaf[_0x1379('0x63')]}});}}return db[_0x1379('0x33')]['findAll'](_0x3b824a);})[_0x1379('0x2d')](function(_0x13b1ae){return _[_0x1379('0xbf')](_0x4d892e,_[_0x1379('0x55')](_0x13b1ae,function(_0x12da42){return util[_0x1379('0xc0')](_0x1379('0xc1'),_0x12da42['id']);}));})['then'](handleEntityNotFound(_0x4c56ad,null))[_0x1379('0x2d')](respondWithResult(_0x4c56ad,null))[_0x1379('0x93')](handleError(_0x4c56ad,null));};exports[_0x1379('0x28')]=function(_0x4fa6d9,_0x309897){var _0x2ab418;if(_0x4fa6d9['body']['id']){delete _0x4fa6d9[_0x1379('0x9c')]['id'];}return db['CmContact'][_0x1379('0x53')]({'where':{'id':_0x4fa6d9[_0x1379('0xbd')]['id']}})[_0x1379('0x2d')](handleEntityNotFound(_0x309897,null))[_0x1379('0x2d')](saveUpdates(_0x4fa6d9[_0x1379('0x9c')],null))[_0x1379('0x2d')](function(_0x3a46a2){_0x2ab418=_0x3a46a2;var _0x366dbe={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x3a46a2&&_0x3a46a2['ListId']){if(_0x3a46a2[_0x1379('0x63')]){_0x366dbe['where'][_0x1379('0xbe')][_0x1379('0x32')]({'ListId':{'$ne':_0x3a46a2[_0x1379('0x63')]}});}}return db[_0x1379('0x33')]['findAll'](_0x366dbe);})[_0x1379('0x2d')](function(_0x282bd5){if(_0x282bd5){return _[_0x1379('0xbf')](_[_0x1379('0xc2')](_0x4fa6d9[_0x1379('0x9c')],function(_0x18130e,_0x2a4f25){return _[_0x1379('0x30')](_0x2a4f25,_0x1379('0x31'));}),_[_0x1379('0x55')](_0x282bd5,function(_0x564375){return util[_0x1379('0xc0')](_0x1379('0xc1'),_0x564375['id']);}));}})['then'](function(_0x5b5134){if(_0x5b5134&&!_[_0x1379('0x62')](_0x5b5134)){var _0x2cf732=squel[_0x1379('0x28')]()[_0x1379('0xc3')](_0x1379('0xc4'))[_0x1379('0xc5')](_0x5b5134)[_0x1379('0x43')]('id\x20=\x20?',_0x4fa6d9[_0x1379('0xbd')]['id'])[_0x1379('0xc6')]();return db[_0x1379('0x86')][_0x1379('0x3a')](_0x2cf732[_0x1379('0x5f')],{'replacements':_0x2cf732[_0x1379('0x9b')]});}})[_0x1379('0x2d')](function(){if(_0x4fa6d9[_0x1379('0x9c')][_0x1379('0xc7')]&&_0x2ab418){return db[_0x1379('0xa2')][_0x1379('0x28')]({'phone':_0x4fa6d9[_0x1379('0x9c')][_0x1379('0xc7')]},{'where':{'ContactId':_0x2ab418['id']}});}})[_0x1379('0x2d')](function(){return _0x2ab418;})[_0x1379('0x2d')](respondWithResult(_0x309897,null))['catch'](handleError(_0x309897,null));};exports[_0x1379('0xc8')]=function(_0x5124fe,_0x49075e,_0x19a675){var _0x59ce29={};var _0x428352={};var _0x5b5148;var _0x4d3301;return db[_0x1379('0x2c')]['findOne']({'where':{'id':_0x5124fe[_0x1379('0xbd')]['id']}})['then'](handleEntityNotFound(_0x49075e,null))[_0x1379('0x2d')](function(_0x39151c){if(_0x39151c){_0x5b5148=_0x39151c;_0x428352['model']=_[_0x1379('0x2e')](db['Tag'][_0x1379('0xc9')]);_0x428352[_0x1379('0x3a')]=_[_0x1379('0x2e')](_0x5124fe[_0x1379('0x3a')]);_0x428352['filters']=_[_0x1379('0x3c')](_0x428352[_0x1379('0x39')],_0x428352[_0x1379('0x3a')]);_0x59ce29[_0x1379('0x3d')]=_['intersection'](_0x428352[_0x1379('0x39')],qs[_0x1379('0x3e')](_0x5124fe[_0x1379('0x3a')]['fields']));_0x59ce29[_0x1379('0x3d')]=_0x59ce29[_0x1379('0x3d')][_0x1379('0x2f')]?_0x59ce29['attributes']:_0x428352[_0x1379('0x39')];_0x59ce29['order']=qs[_0x1379('0x42')](_0x5124fe[_0x1379('0x3a')][_0x1379('0x42')]);_0x59ce29['where']=qs[_0x1379('0x3b')](_[_0x1379('0x44')](_0x5124fe['query'],_0x428352[_0x1379('0x3b')]));if(_0x5124fe['query'][_0x1379('0x69')]){_0x59ce29[_0x1379('0x43')]=_[_0x1379('0x88')](_0x59ce29[_0x1379('0x43')],{'$or':_[_0x1379('0x55')](_0x59ce29['attributes'],function(_0x2061d4){var _0x8aa315={};_0x8aa315[_0x2061d4]={'$like':'%'+_0x5124fe[_0x1379('0x3a')][_0x1379('0x69')]+'%'};return _0x8aa315;})});}_0x59ce29=_['merge']({},_0x59ce29,_0x5124fe[_0x1379('0xca')]);return _0x5b5148['getTags'](_0x59ce29);}})[_0x1379('0x2d')](function(_0x4f467c){if(_0x4f467c){_0x4d3301=_0x4f467c[_0x1379('0x2f')];if(!_0x5124fe['query'][_0x1379('0x3f')]('nolimit')){_0x59ce29['limit']=qs['limit'](_0x5124fe[_0x1379('0x3a')][_0x1379('0x21')]);_0x59ce29['offset']=qs[_0x1379('0x20')](_0x5124fe[_0x1379('0x3a')][_0x1379('0x20')]);}return _0x5b5148[_0x1379('0xc8')](_0x59ce29);}})[_0x1379('0x2d')](function(_0x399939){if(_0x399939){return _0x399939?{'count':_0x4d3301,'rows':_0x399939}:null;}})[_0x1379('0x2d')](respondWithResult(_0x49075e,null))[_0x1379('0x93')](handleError(_0x49075e,null));};exports[_0x1379('0xcb')]=function(_0x7c1960,_0x4ad749,_0x2cae9a){if(_0x7c1960[_0x1379('0x9c')]['id']){delete _0x7c1960[_0x1379('0x9c')]['id'];}return db[_0x1379('0x2c')][_0x1379('0x34')]({'where':{'id':_0x7c1960[_0x1379('0xbd')]['id']}})[_0x1379('0x2d')](handleEntityNotFound(_0x4ad749,null))[_0x1379('0x2d')](function(_0x36fe92){if(_0x36fe92){return _0x36fe92['setTags'](_0x7c1960[_0x1379('0x9c')]['ids']||[]);}return null;})[_0x1379('0x2d')](respondWithResult(_0x4ad749,null))['catch'](handleError(_0x4ad749,null));};exports['getHoppers']=function(_0x952ccd,_0x5258aa,_0x3f0d42){var _0x5cd0f0={'raw':![],'where':{}};var _0xea4114={};var _0x492d2e={'count':0x0,'rows':[]};return db[_0x1379('0x2c')][_0x1379('0x34')]({'where':{'id':_0x952ccd[_0x1379('0xbd')]['id']}})['then'](handleEntityNotFound(_0x5258aa,null))[_0x1379('0x2d')](function(_0x23b5ec){if(_0x23b5ec){_0xea4114['model']=_[_0x1379('0x2e')](db['CmHopper'][_0x1379('0xc9')]);_0xea4114[_0x1379('0x3a')]=_['keys'](_0x952ccd[_0x1379('0x3a')]);_0xea4114[_0x1379('0x3b')]=_[_0x1379('0x3c')](_0xea4114[_0x1379('0x39')],_0xea4114[_0x1379('0x3a')]);_0x5cd0f0['attributes']=_[_0x1379('0x3c')](_0xea4114[_0x1379('0x39')],qs[_0x1379('0x3e')](_0x952ccd[_0x1379('0x3a')][_0x1379('0x3e')]));_0x5cd0f0['attributes']=_0x5cd0f0[_0x1379('0x3d')][_0x1379('0x2f')]?_0x5cd0f0[_0x1379('0x3d')]:_0xea4114['model'];if(!_0x952ccd[_0x1379('0x3a')][_0x1379('0x3f')]('nolimit')){_0x5cd0f0['limit']=qs[_0x1379('0x21')](_0x952ccd[_0x1379('0x3a')][_0x1379('0x21')]);_0x5cd0f0[_0x1379('0x20')]=qs[_0x1379('0x20')](_0x952ccd[_0x1379('0x3a')][_0x1379('0x20')]);}_0x5cd0f0[_0x1379('0x41')]=qs[_0x1379('0x42')](_0x952ccd[_0x1379('0x3a')][_0x1379('0x42')]);_0x5cd0f0[_0x1379('0x43')]=qs[_0x1379('0x3b')](_[_0x1379('0x44')](_0x952ccd[_0x1379('0x3a')],_0xea4114[_0x1379('0x3b')]));_0x5cd0f0[_0x1379('0x43')][_0x1379('0xcc')]=_0x23b5ec['id'];if(_0x952ccd['query']['filter']){_0x5cd0f0['where']=_[_0x1379('0x88')](_0x5cd0f0[_0x1379('0x43')],{'$or':_[_0x1379('0x55')](_0x5cd0f0['attributes'],function(_0x26c925){var _0x3ab2b6={};_0x3ab2b6[_0x26c925]={'$like':'%'+_0x952ccd['query'][_0x1379('0x69')]+'%'};return _0x3ab2b6;})});}_0x5cd0f0=_[_0x1379('0x88')]({},_0x5cd0f0,_0x952ccd['options']);return db[_0x1379('0xa2')][_0x1379('0x23')]({'where':_0x5cd0f0[_0x1379('0x43')]})[_0x1379('0x2d')](function(_0x483356){_0x492d2e['count']=_0x483356;if(_0x952ccd[_0x1379('0x3a')][_0x1379('0xcd')]){_0x5cd0f0[_0x1379('0xce')]=[{'all':!![]}];}return db['CmHopper'][_0x1379('0x98')](_0x5cd0f0);})['then'](function(_0x4e5de3){_0x492d2e[_0x1379('0xcf')]=_0x4e5de3;return _0x492d2e;});}})[_0x1379('0x2d')](respondWithFilteredResult(_0x5258aa,_0x5cd0f0))[_0x1379('0x93')](handleError(_0x5258aa,null));};exports[_0x1379('0xd0')]=function(_0x1b2963,_0x5c69a9,_0x142c1d){var _0x49a1a2={'raw':!![],'where':{}};var _0xec2087={};var _0x16e276={'count':0x0,'rows':[]};return db['CmContact']['findOne']({'where':{'id':_0x1b2963[_0x1379('0xbd')]['id']}})[_0x1379('0x2d')](handleEntityNotFound(_0x5c69a9,null))[_0x1379('0x2d')](function(_0x9ff8db){if(_0x9ff8db){_0xec2087['model']=_[_0x1379('0x2e')](db[_0x1379('0xaf')][_0x1379('0xc9')]);_0xec2087['query']=_[_0x1379('0x2e')](_0x1b2963[_0x1379('0x3a')]);_0xec2087[_0x1379('0x3b')]=_[_0x1379('0x3c')](_0xec2087[_0x1379('0x39')],_0xec2087[_0x1379('0x3a')]);_0x49a1a2['attributes']=_['intersection'](_0xec2087[_0x1379('0x39')],qs['fields'](_0x1b2963['query']['fields']));_0x49a1a2[_0x1379('0x3d')]=_0x49a1a2[_0x1379('0x3d')][_0x1379('0x2f')]?_0x49a1a2['attributes']:_0xec2087['model'];if(!_0x1b2963[_0x1379('0x3a')][_0x1379('0x3f')]('nolimit')){_0x49a1a2['limit']=qs[_0x1379('0x21')](_0x1b2963[_0x1379('0x3a')]['limit']);_0x49a1a2['offset']=qs[_0x1379('0x20')](_0x1b2963[_0x1379('0x3a')][_0x1379('0x20')]);}_0x49a1a2[_0x1379('0x41')]=qs['sort'](_0x1b2963[_0x1379('0x3a')][_0x1379('0x42')]);_0x49a1a2[_0x1379('0x43')]=qs[_0x1379('0x3b')](_[_0x1379('0x44')](_0x1b2963[_0x1379('0x3a')],_0xec2087[_0x1379('0x3b')]));_0x49a1a2[_0x1379('0x43')][_0x1379('0xcc')]=_0x9ff8db['id'];if(_0x1b2963[_0x1379('0x3a')][_0x1379('0x69')]){_0x49a1a2['where']=_[_0x1379('0x88')](_0x49a1a2[_0x1379('0x43')],{'$or':_[_0x1379('0x55')](_0x49a1a2[_0x1379('0x3d')],function(_0x5e8e3e){var _0x233c35={};_0x233c35[_0x5e8e3e]={'$like':'%'+_0x1b2963[_0x1379('0x3a')]['filter']+'%'};return _0x233c35;})});}_0x49a1a2=_[_0x1379('0x88')]({},_0x49a1a2,_0x1b2963[_0x1379('0xca')]);return db[_0x1379('0xaf')][_0x1379('0x23')]({'where':_0x49a1a2['where']})['then'](function(_0x1b25ac){_0x16e276[_0x1379('0x23')]=_0x1b25ac;if(_0x1b2963['query']['includeAll']){_0x49a1a2[_0x1379('0xce')]=[{'all':!![]}];}return db['CmHopperHistory'][_0x1379('0x98')](_0x49a1a2);})[_0x1379('0x2d')](function(_0x504acd){_0x16e276[_0x1379('0xcf')]=_0x504acd;return _0x16e276;});}})[_0x1379('0x2d')](respondWithFilteredResult(_0x5c69a9,_0x49a1a2))[_0x1379('0x93')](handleError(_0x5c69a9,null));};exports['getHopperFinals']=function(_0x437b15,_0x626ce0,_0x1c332a){var _0x56a44f={'raw':!![],'where':{}};var _0x8e2715={};var _0x1aead1={'count':0x0,'rows':[]};return db[_0x1379('0x2c')][_0x1379('0x34')]({'where':{'id':_0x437b15[_0x1379('0xbd')]['id']}})[_0x1379('0x2d')](handleEntityNotFound(_0x626ce0,null))[_0x1379('0x2d')](function(_0x5e4198){if(_0x5e4198){_0x8e2715[_0x1379('0x39')]=_[_0x1379('0x2e')](db[_0x1379('0xae')][_0x1379('0xc9')]);_0x8e2715[_0x1379('0x3a')]=_[_0x1379('0x2e')](_0x437b15['query']);_0x8e2715[_0x1379('0x3b')]=_[_0x1379('0x3c')](_0x8e2715['model'],_0x8e2715[_0x1379('0x3a')]);_0x56a44f['attributes']=_['intersection'](_0x8e2715[_0x1379('0x39')],qs[_0x1379('0x3e')](_0x437b15['query']['fields']));_0x56a44f[_0x1379('0x3d')]=_0x56a44f['attributes']['length']?_0x56a44f[_0x1379('0x3d')]:_0x8e2715['model'];if(!_0x437b15[_0x1379('0x3a')][_0x1379('0x3f')](_0x1379('0x40'))){_0x56a44f['limit']=qs[_0x1379('0x21')](_0x437b15[_0x1379('0x3a')][_0x1379('0x21')]);_0x56a44f[_0x1379('0x20')]=qs['offset'](_0x437b15[_0x1379('0x3a')][_0x1379('0x20')]);}_0x56a44f[_0x1379('0x41')]=qs[_0x1379('0x42')](_0x437b15[_0x1379('0x3a')]['sort']);_0x56a44f['where']=qs[_0x1379('0x3b')](_[_0x1379('0x44')](_0x437b15['query'],_0x8e2715['filters']));_0x56a44f['where'][_0x1379('0xcc')]=_0x5e4198['id'];if(_0x437b15[_0x1379('0x3a')][_0x1379('0x69')]){_0x56a44f[_0x1379('0x43')]=_['merge'](_0x56a44f['where'],{'$or':_['map'](_0x56a44f[_0x1379('0x3d')],function(_0x431034){var _0x386fc5={};_0x386fc5[_0x431034]={'$like':'%'+_0x437b15[_0x1379('0x3a')][_0x1379('0x69')]+'%'};return _0x386fc5;})});}_0x56a44f=_['merge']({},_0x56a44f,_0x437b15['options']);return db[_0x1379('0xae')][_0x1379('0x23')]({'where':_0x56a44f[_0x1379('0x43')]})[_0x1379('0x2d')](function(_0x2064e7){_0x1aead1[_0x1379('0x23')]=_0x2064e7;if(_0x437b15['query'][_0x1379('0xcd')]){_0x56a44f['include']=[{'all':!![]}];}return db[_0x1379('0xae')][_0x1379('0x98')](_0x56a44f);})[_0x1379('0x2d')](function(_0x301b15){_0x1aead1[_0x1379('0xcf')]=_0x301b15;return _0x1aead1;});}})[_0x1379('0x2d')](respondWithFilteredResult(_0x626ce0,_0x56a44f))['catch'](handleError(_0x626ce0,null));};exports[_0x1379('0xd1')]=function(_0x3b26cf,_0x305266,_0x35b3dd){var _0xe882e0={'raw':!![],'where':{}};var _0x95ad13={};var _0x39a36a={'count':0x0,'rows':[]};return db['CmContact']['findOne']({'where':{'id':_0x3b26cf['params']['id']}})[_0x1379('0x2d')](handleEntityNotFound(_0x305266,null))[_0x1379('0x2d')](function(_0x3d13cc){if(_0x3d13cc){_0x95ad13['model']=_[_0x1379('0x2e')](db[_0x1379('0xb4')]['rawAttributes']);_0x95ad13[_0x1379('0x3a')]=_['keys'](_0x3b26cf['query']);_0x95ad13[_0x1379('0x3b')]=_[_0x1379('0x3c')](_0x95ad13['model'],_0x95ad13[_0x1379('0x3a')]);_0xe882e0[_0x1379('0x3d')]=_[_0x1379('0x3c')](_0x95ad13[_0x1379('0x39')],qs[_0x1379('0x3e')](_0x3b26cf[_0x1379('0x3a')][_0x1379('0x3e')]));_0xe882e0[_0x1379('0x3d')]=_0xe882e0[_0x1379('0x3d')][_0x1379('0x2f')]?_0xe882e0[_0x1379('0x3d')]:_0x95ad13[_0x1379('0x39')];if(!_0x3b26cf[_0x1379('0x3a')][_0x1379('0x3f')](_0x1379('0x40'))){_0xe882e0['limit']=qs['limit'](_0x3b26cf[_0x1379('0x3a')][_0x1379('0x21')]);_0xe882e0['offset']=qs[_0x1379('0x20')](_0x3b26cf[_0x1379('0x3a')][_0x1379('0x20')]);}_0xe882e0[_0x1379('0x41')]=qs['sort'](_0x3b26cf[_0x1379('0x3a')]['sort']);_0xe882e0['where']=qs[_0x1379('0x3b')](_[_0x1379('0x44')](_0x3b26cf['query'],_0x95ad13[_0x1379('0x3b')]));_0xe882e0[_0x1379('0x43')][_0x1379('0xcc')]=_0x3d13cc['id'];if(_0x3b26cf[_0x1379('0x3a')]['filter']){_0xe882e0['where']=_['merge'](_0xe882e0['where'],{'$or':_['map'](_0xe882e0[_0x1379('0x3d')],function(_0x2f61ed){var _0x2179f5={};_0x2179f5[_0x2f61ed]={'$like':'%'+_0x3b26cf[_0x1379('0x3a')]['filter']+'%'};return _0x2179f5;})});}_0xe882e0=_['merge']({},_0xe882e0,_0x3b26cf['options']);return db[_0x1379('0xb4')][_0x1379('0x23')]({'where':_0xe882e0[_0x1379('0x43')]})['then'](function(_0x5066c2){_0x39a36a[_0x1379('0x23')]=_0x5066c2;if(_0x3b26cf[_0x1379('0x3a')][_0x1379('0xcd')]){_0xe882e0['include']=[{'all':!![]}];}return db[_0x1379('0xb4')]['findAll'](_0xe882e0);})[_0x1379('0x2d')](function(_0x386f73){_0x39a36a['rows']=_0x386f73;return _0x39a36a;});}})['then'](respondWithFilteredResult(_0x305266,_0xe882e0))[_0x1379('0x93')](handleError(_0x305266,null));};exports[_0x1379('0xd2')]=function(_0x4195a8,_0x39382d,_0x22239f){try{if(!_0x4195a8[_0x1379('0x9c')]['ListId']){throw new Error(_0x1379('0xd3'));}if(!_0x4195a8['body']['binding_keys']){throw new Error(_0x1379('0xd4'));}if(!_0x4195a8['body'][_0x1379('0xd5')]){throw new Error(_0x1379('0xd6'));}if(!_0x4195a8['body'][_0x1379('0xd7')]){throw new Error(_0x1379('0xd8'));}var _0x3ddb74=_0x4195a8[_0x1379('0x9c')][_0x1379('0xd9')][_0x1379('0xda')](',');var _0x205f5d=_0x4195a8['body'][_0x1379('0xd5')][_0x1379('0xda')](',');if(!_0x3ddb74[_0x1379('0x2f')]||!_0x205f5d['length']||_0x3ddb74[_0x1379('0x2f')]!==_0x205f5d[_0x1379('0x2f')]){throw new Error(_0x1379('0xdb'));}_0x4195a8['body'][_0x1379('0x3e')]=_[_0x1379('0xdc')](_0x3ddb74,_0x205f5d);if(!_0x4195a8[_0x1379('0x9c')][_0x1379('0x3e')][_0x1379('0xc7')]){throw new Error(_0x1379('0xdd'));}if(!_0x4195a8[_0x1379('0x9c')][_0x1379('0x3e')][_0x1379('0xde')]){throw new Error(_0x1379('0xdf'));}var _0x47ddf6=path[_0x1379('0x9f')](config[_0x1379('0xe0')],'server/files/tmp',_0x4195a8[_0x1379('0xe1')][_0x1379('0xe2')]);fs[_0x1379('0xe3')](_0x47ddf6,parseInt('0777',0x8));var _0x4582b2=require('child_process')['fork'](path['join'](__dirname,_0x1379('0xe4')),[_0x47ddf6,_0x4195a8['body']['binding_keys'],_0x4195a8['body'][_0x1379('0xd5')],_0x4195a8[_0x1379('0x9c')][_0x1379('0x63')],_0x4195a8[_0x1379('0x9c')][_0x1379('0xe5')],_0x4195a8[_0x1379('0x9c')]['duplicates'],_0x4195a8['body'][_0x1379('0xd7')]]);return _0x39382d[_0x1379('0x1d')](0xc8)[_0x1379('0x1f')]({'message':'File\x20uploaded\x20correctly!','pid':_0x4582b2[_0x1379('0xe6')]});}catch(_0x4b7e4d){return _0x39382d['status'](0x1f4)[_0x1379('0x2b')](_0x4b7e4d);}};exports[_0x1379('0xe7')]=function(_0x110f24,_0x1af1ee,_0x3ae06b){var _0x44f48e=fs[_0x1379('0xe8')](_0x110f24[_0x1379('0xe1')][_0x1379('0x6')]);Papa[_0x1379('0xe9')](_0x44f48e,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x3a6624){return _0x1af1ee[_0x1379('0x1d')](0xc8)[_0x1379('0x1f')]({'file':_0x110f24[_0x1379('0xe1')],'fields':_0x3a6624[_0x1379('0xea')][_0x1379('0x3e')]});}});};exports['import']=function(_0x2a3178,_0x57d0f9,_0x541c6e){return db['User']['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0x1379('0x81')}})[_0x1379('0x2d')](function(_0x16c7fd){var _0x3fb3f9=![];if(!_0x2a3178[_0x1379('0x9c')][_0x1379('0x63')]){throw new Error(_0x1379('0xd3'));}if(!_0x2a3178[_0x1379('0x9c')][_0x1379('0xeb')]['phone']){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x2a3178[_0x1379('0x9c')][_0x1379('0xeb')]['firstName']){throw new Error(_0x1379('0xdf'));}if(!_0x2a3178[_0x1379('0x9c')]['socket_timestamp']){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x2025c1=require('child_process')[_0x1379('0xec')](path[_0x1379('0x9f')](__dirname,'../../components/import/cm/csv2'),[_0x2a3178[_0x1379('0xbd')]['id'],JSON[_0x1379('0xed')](_0x2a3178['body']),JSON['stringify'](_0x16c7fd)]);_0x2025c1['on'](_0x1379('0xee'),function(_0x256f5d){_0x3fb3f9=!![];return _0x57d0f9[_0x1379('0x1d')](0xc8)[_0x1379('0x1f')]({'message':_0x1379('0xef'),'pid':_0x2025c1['pid']});});_0x2025c1['on'](_0x1379('0xf0'),function(_0x313fa2){if(_0x313fa2&&!_0x3fb3f9){return _0x57d0f9['status'](0x1f4)['json']({'message':'error\x20child\x20process','pid':_0x2025c1[_0x1379('0xe6')]});}});})[_0x1379('0x93')](handleError(_0x57d0f9,null));};exports[_0x1379('0xf1')]=function(_0x251b95,_0x2f8444){var _0x4efc04=[_0x1379('0xf2'),_0x1379('0xf3'),_0x1379('0xf4'),_0x1379('0xf5'),_0x1379('0xf6'),'whatsapp',_0x1379('0xf7')];var _0x11e090={'offset':0x0,'order':qs['sort'](_0x1379('0xf8'))},_0x41ec1b={'count':0x0,'rows':[]};Promise[_0x1379('0xf9')]()[_0x1379('0x2d')](function(){if(_0x251b95['query']['channel']){if(!_['includes'](_0x4efc04,_0x251b95[_0x1379('0x3a')][_0x1379('0xfa')][_0x1379('0xfb')]())){throw new Error('Invalid\x20channel');}_0x4efc04=[_0x251b95[_0x1379('0x3a')]['channel'][_0x1379('0xfb')]()];}if(_0x251b95[_0x1379('0x3a')][_0x1379('0xfc')]){try{var _0x5dc924=JSON['parse'](_0x251b95['query'][_0x1379('0xfc')]);if(!moment(_0x5dc924[_0x1379('0x48')])['isValid']()){throw new Error('Invalid\x20date\x20for\x20range\x20from\x20filter');}if(!moment(_0x5dc924['to'])[_0x1379('0xfd')]()){throw new Error(_0x1379('0xfe'));}}catch(_0x511060){throw new Error('Invalid\x20createdAt\x20filter');}}if(!_0x251b95[_0x1379('0x3a')][_0x1379('0x3f')](_0x1379('0x40'))){_0x11e090[_0x1379('0x21')]=qs[_0x1379('0x21')](_0x251b95[_0x1379('0x3a')][_0x1379('0x21')]||0xa);_0x11e090['offset']=qs[_0x1379('0x20')](_0x251b95[_0x1379('0x3a')][_0x1379('0x20')]);}var _0x140242=_0x4efc04['map'](function(_0x30188c){if(_0x30188c===_0x1379('0xf7')){var _0x5d8c1f={'attributes':['id',_0x1379('0xff'),_0x1379('0x38'),_0x1379('0x100'),_0x1379('0x101'),_0x1379('0x102'),_0x1379('0x103'),_0x1379('0x104'),_0x1379('0x105'),_0x1379('0x106'),_0x1379('0x107'),'userDisposition',_0x1379('0x108'),_0x1379('0x109'),_0x1379('0x10a')],'where':{'ContactId':_0x251b95[_0x1379('0xbd')]['id']},'include':[{'model':db[_0x1379('0x58')],'as':_0x1379('0x58'),'attributes':['id',_0x1379('0x2a'),_0x1379('0x10b'),_0x1379('0x99')]}],'order':[[_0x1379('0x107'),_0x1379('0x7c')]]};if(_0x251b95[_0x1379('0x3a')][_0x1379('0xfc')]){_0x5d8c1f[_0x1379('0x43')][_0x1379('0x107')]={'$gte':_0x5dc924[_0x1379('0x48')],'$lte':_0x5dc924['to']};}return db[_0x1379('0xb1')]['findAndCountAll'](_0x5d8c1f)[_0x1379('0x2d')](function(_0x2dd1aa){_0x41ec1b[_0x1379('0x23')]+=_0x2dd1aa['count'];return _[_0x1379('0x55')](_0x2dd1aa[_0x1379('0xcf')],function(_0x2d8657){var _0x3ee492=_0x2d8657[_0x1379('0x9d')]({'plain':!![]});_0x3ee492[_0x1379('0xfa')]=_0x30188c;if(_0x3ee492[_0x1379('0x58')]){_0x3ee492['User']={'id':_0x3ee492[_0x1379('0x58')]['id'],'name':_0x3ee492[_0x1379('0x58')][_0x1379('0x2a')],'fullname':_0x3ee492[_0x1379('0x58')]['fullname'],'alias':_0x3ee492['User']['alias']};}return _0x3ee492;});});}else{var _0x2c6c83=_[_0x1379('0x10c')](_0x30188c)+(_0x30188c===_0x1379('0xf3')?'Website':_0x1379('0x10d'));var _0x4f8a9d={'attributes':['id',_0x1379('0x10e'),_0x1379('0x10f'),'createdAt',_0x1379('0x106'),_0x1379('0x110'),_0x1379('0x111'),_0x1379('0x112'),_0x1379('0x10a'),_0x2c6c83+'Id'],'where':{'ContactId':_0x251b95[_0x1379('0xbd')]['id']},'include':[{'model':db[_0x2c6c83],'as':_0x1379('0x10d'),'attributes':['id',_0x1379('0x2a'),_0x1379('0x113')]},{'model':db[_0x1379('0x58')],'as':_0x1379('0x114'),'attributes':['id','name',_0x1379('0x10b')]},{'model':db[_0x1379('0x54')],'as':_0x1379('0x92'),'attributes':['id',_0x1379('0x2a'),_0x1379('0x47')],'through':{'attributes':[]}}],'order':[['createdAt',_0x1379('0x7c')]]};if(_0x251b95[_0x1379('0x3a')][_0x1379('0xfc')]){_0x4f8a9d[_0x1379('0x43')][_0x1379('0x107')]={'$gte':_0x5dc924[_0x1379('0x48')],'$lte':_0x5dc924['to']};}switch(_0x30188c){case _0x1379('0xf3'):_0x4f8a9d[_0x1379('0x3d')][_0x1379('0x32')](_0x1379('0x115'),'customerIp',_0x1379('0x116'),'deviceModel',_0x1379('0x117'),_0x1379('0x118'),_0x1379('0x119'),'ratingValue',_0x1379('0x11a'));break;case _0x1379('0xf2'):_0x4f8a9d[_0x1379('0x3d')]['push'](_0x1379('0x11b'),'substatus');break;case _0x1379('0xf5'):_0x4f8a9d['attributes'][_0x1379('0x32')](_0x1379('0x11c'),_0x1379('0x11d'));break;}return db[_[_0x1379('0x10c')](_0x30188c)+_0x1379('0x11e')][_0x1379('0x11f')](_0x4f8a9d)[_0x1379('0x2d')](function(_0x113ddb){_0x41ec1b['count']+=_0x113ddb['count'];return _[_0x1379('0x55')](_0x113ddb['rows'],function(_0xc81e8c){var _0x5d0d6c=_0xc81e8c[_0x1379('0x9d')]({'plain':!![]});_0x5d0d6c[_0x1379('0xfa')]=_0x30188c;if(_0x5d0d6c[_0x1379('0x114')]){_0x5d0d6c[_0x1379('0x114')]={'id':_0x5d0d6c[_0x1379('0x114')]['id'],'name':_0x5d0d6c['Owner'][_0x1379('0x2a')],'fullname':_0x5d0d6c[_0x1379('0x114')]['fullname']};}return _0x5d0d6c;});});}});return Promise['all'](_0x140242);})[_0x1379('0x2d')](function(_0x371945){return _(_0x371945)[_0x1379('0x120')]()['sortBy']('createdAt')[_0x1379('0x121')]()[_0x1379('0x5a')]();})[_0x1379('0x2d')](function(_0x5a1bc6){_0x41ec1b[_0x1379('0xcf')]=_0x11e090['limit']?_0x5a1bc6['slice'](_0x11e090[_0x1379('0x20')],_0x11e090[_0x1379('0x20')]+_0x11e090[_0x1379('0x21')]):_0x5a1bc6;return _0x41ec1b;})[_0x1379('0x2d')](respondWithFilteredResult(_0x2f8444,_0x11e090))['catch'](handleError(_0x2f8444,null));};
\ No newline at end of file
+var _0x3a0f=['createdAt','findAndCountAll','fullname','startCase','Account','closed','closedAt','disposition','thirdDisposition','Owner','customerIp','customerPort','deviceModel','osName','ratingMessage','ratingType','ratingValue','referer','subject','substatus','externalUrl','threadId','Interaction','flatten','sortBy','reverse','slice','zip-dir','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','socket.io-emitter','./cmContact.socket','register','sendStatus','status','end','offset','undefined','count','limit','set','Content-Range','json','apply','reject','save','update','then','destroy','error','name','send','merge','body','contact','message','agent','interaction','index','CmContact','keys','length','startsWith','push','CmCustomField','findOne','cf_','all','fieldType','type','query','filters','intersection','model','attributes','fields','nolimit','order','sort','pick','select','field','color','from','tools_tags','cm_contacts','cm_user_has_contacts','uc.CmContactId\x20=\x20c.id','left_join','cm_contact_has_tags','where','c.deletedAt\x20IS\x20NULL','expr','search','parseSearch','sqlOperator','conditions','Tag','map','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','and','uc.UserId\x20=\x20?','value','dateOfBirth','datetime','castTo','DATE','buildExpression','hasOwnProperty','filter','isNil','Contact','isEmpty','ListId','c.ListId\x20IN\x20?','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','tag','isArray','replace','split','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','isNumeric','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','group','Sequelize','QueryTypes','SELECT','c.id','having','t.id\x20IN\x20?','resolve','user','role','some','getLists','sequelize','keyBy','c.firstName','c.lastName','c.phone','c.fax','c.ListId','c.createdAt','c.CompanyId','TagIds','toString','Tags','rows','find','catch','describe','tags','columnName','findAll','alias','custom','get','mergeWith','join','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','ReportAgentPreview','VoiceCallReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappMessage','bulkCreate','duplicates','$or','findOrCreate','spread','show','params','$and','omit','format','table','id\x20=\x20?','values','phone','getTags','options','setTags','ids','getHoppers','rawAttributes','includeAll','include','getHopperHistories','CmHopperHistory','getHopperFinals','CmHopperFinal','getJscriptySessions','ContactId','uploadCsv','No\x20ListId\x20specified','binding_keys','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','server/files/tmp','file','chmodSync','0777','fork','../../components/import/cm/csv','CompanyId','File\x20uploaded\x20correctly!','pid','upload','parse','meta','binding','child_process','stringify','start\x20child\x20process\x20correctly!','exit','getJourney','mail','chat','openchannel','whatsapp','voice','-createdAt','channel','toLowerCase','Invalid\x20channel','range','Invalid\x20date\x20for\x20range\x20from\x20filter','Invalid\x20date\x20for\x20range\x20to\x20filter','Invalid\x20createdAt\x20filter','uniqueid','source','callerid','starttime','endtime','duration','note','userDisposition','userSecondDisposition','userThirdDisposition','UserId'];(function(_0x57b54c,_0x54ce0d){var _0x59cc19=function(_0xa33bc6){while(--_0xa33bc6){_0x57b54c['push'](_0x57b54c['shift']());}};_0x59cc19(++_0x54ce0d);}(_0x3a0f,0x145));var _0xf3a0=function(_0x122ee8,_0x3134d4){_0x122ee8=_0x122ee8-0x0;var _0x5b6118=_0x3a0f[_0x122ee8];return _0x5b6118;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0xf3a0('0x0'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0xf3a0('0x1'));var BPromise=require(_0xf3a0('0x2'));var Mustache=require(_0xf3a0('0x3'));var util=require(_0xf3a0('0x4'));var path=require(_0xf3a0('0x5'));var sox=require(_0xf3a0('0x6'));var csv=require(_0xf3a0('0x7'));var ejs=require(_0xf3a0('0x8'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xf3a0('0x9'));var squel=require(_0xf3a0('0xa'));var crypto=require(_0xf3a0('0xb'));var jsforce=require(_0xf3a0('0xc'));var deskjs=require('desk.js');var toCsv=require(_0xf3a0('0x7'));var querystring=require(_0xf3a0('0xd'));var Papa=require(_0xf3a0('0xe'));var Redis=require(_0xf3a0('0xf'));var authService=require(_0xf3a0('0x10'));var qs=require(_0xf3a0('0x11'));var as=require(_0xf3a0('0x12'));var hardwareService=require(_0xf3a0('0x13'));var logger=require('../../config/logger')(_0xf3a0('0x14'));var utils=require(_0xf3a0('0x15'));var config=require(_0xf3a0('0x16'));var licenseUtil=require('../../config/license/util');var db=require(_0xf3a0('0x17'))['db'];config[_0xf3a0('0x18')]=_[_0xf3a0('0x19')](config['redis'],{'host':'localhost','port':0x18eb});var socket=require(_0xf3a0('0x1a'))(new Redis(config[_0xf3a0('0x18')]));require(_0xf3a0('0x1b'))[_0xf3a0('0x1c')](socket);function respondWithStatusCode(_0x49b5ff,_0x287e7e){_0x287e7e=_0x287e7e||0xcc;return function(_0x204cf9){if(_0x204cf9){return _0x49b5ff[_0xf3a0('0x1d')](_0x287e7e);}return _0x49b5ff[_0xf3a0('0x1e')](_0x287e7e)[_0xf3a0('0x1f')]();};}function respondWithResult(_0x239a70,_0x39f039){_0x39f039=_0x39f039||0xc8;return function(_0x3e4926){if(_0x3e4926){return _0x239a70['status'](_0x39f039)['json'](_0x3e4926);}};}function respondWithFilteredResult(_0x1be8b9,_0x358916){return function(_0x2c3eba){if(_0x2c3eba){var _0x2c721c=typeof _0x358916[_0xf3a0('0x20')]===_0xf3a0('0x21')&&typeof _0x358916['limit']==='undefined';var _0x29d478=_0x2c3eba[_0xf3a0('0x22')];var _0x66660c=_0x2c721c?0x0:_0x358916[_0xf3a0('0x20')];var _0x25c2f4=_0x2c721c?_0x2c3eba['count']:_0x358916['offset']+_0x358916[_0xf3a0('0x23')];var _0x4bc714;if(_0x25c2f4>=_0x29d478){_0x25c2f4=_0x29d478;_0x4bc714=0xc8;}else{_0x4bc714=0xce;}_0x1be8b9[_0xf3a0('0x1e')](_0x4bc714);return _0x1be8b9[_0xf3a0('0x24')](_0xf3a0('0x25'),_0x66660c+'-'+_0x25c2f4+'/'+_0x29d478)[_0xf3a0('0x26')](_0x2c3eba);}return null;};}function patchUpdates(_0x2de459){return function(_0x1659eb){try{jsonpatch[_0xf3a0('0x27')](_0x1659eb,_0x2de459,!![]);}catch(_0xe7926){return BPromise[_0xf3a0('0x28')](_0xe7926);}return _0x1659eb[_0xf3a0('0x29')]();};}function saveUpdates(_0x422601,_0x21ca14){return function(_0x1804ad){if(_0x1804ad){return _0x1804ad[_0xf3a0('0x2a')](_0x422601)[_0xf3a0('0x2b')](function(_0x5569a9){return _0x5569a9;});}return null;};}function removeEntity(_0x2c4f45,_0x182ce6){return function(_0x36c24e){if(_0x36c24e){return _0x36c24e[_0xf3a0('0x2c')]()[_0xf3a0('0x2b')](function(){_0x2c4f45[_0xf3a0('0x1e')](0xcc)[_0xf3a0('0x1f')]();});}};}function handleEntityNotFound(_0x7f90dd,_0x48953e){return function(_0x5270da){if(!_0x5270da){_0x7f90dd['sendStatus'](0x194);}return _0x5270da;};}function handleError(_0x2a720a,_0x26efe7){_0x26efe7=_0x26efe7||0x1f4;return function(_0x252f89){logger[_0xf3a0('0x2d')](_0x252f89['stack']);if(_0x252f89[_0xf3a0('0x2e')]){delete _0x252f89[_0xf3a0('0x2e')];}_0x2a720a[_0xf3a0('0x1e')](_0x26efe7)[_0xf3a0('0x2f')](_0x252f89);};}function getMustacheRender(_0x268242,_0x13eddf){return Mustache['render'](_0x268242,_[_0xf3a0('0x30')](_0x13eddf[_0xf3a0('0x31')],{'contact':_0x13eddf[_0xf3a0('0x32')],'message':_0x13eddf[_0xf3a0('0x33')],'agent':_0x13eddf[_0xf3a0('0x34')],'interaction':_0x13eddf[_0xf3a0('0x35')],'account':_0x13eddf['account']}))||'';}exports[_0xf3a0('0x36')]=function(_0x3d8325,_0x183bb6){var _0x309d3a={},_0x364177={},_0x40b58f={'count':0x0,'rows':[]};return db[_0xf3a0('0x37')]['describe']()['then'](function(_0x289ecf){var _0x31542e=[];for(var _0x426d85=0x0;_0x426d85<Object[_0xf3a0('0x38')](_0x289ecf)[_0xf3a0('0x39')];_0x426d85++){var _0x2f8d3f=Object[_0xf3a0('0x38')](_0x289ecf)[_0x426d85];if(_[_0xf3a0('0x3a')](_0x2f8d3f,'cf_')){_0x31542e[_0xf3a0('0x3b')](db[_0xf3a0('0x3c')][_0xf3a0('0x3d')]({'where':{'id':_['trimStart'](_0x2f8d3f,_0xf3a0('0x3e'))},'raw':!![]}));}}return BPromise[_0xf3a0('0x3f')](_0x31542e)[_0xf3a0('0x2b')](function(_0x41534b){for(var _0x57341b=0x0;_0x57341b<_0x41534b[_0xf3a0('0x39')];_0x57341b++){if(_0x41534b[_0x57341b]){var _0x3f27f8='cf_'+_0x41534b[_0x57341b]['id'];var _0x5cf5ae=_0x289ecf[_0x3f27f8];_0x5cf5ae[_0xf3a0('0x40')]=_0x41534b[_0x57341b][_0xf3a0('0x41')];}}return _0x289ecf;});})[_0xf3a0('0x2b')](function(_0x438375){_0x364177['model']=_[_0xf3a0('0x38')](_0x438375);_0x364177[_0xf3a0('0x42')]=_['keys'](_0x3d8325[_0xf3a0('0x42')]);_0x364177[_0xf3a0('0x43')]=_[_0xf3a0('0x44')](_0x364177[_0xf3a0('0x45')],_0x364177[_0xf3a0('0x42')]);_0x309d3a[_0xf3a0('0x46')]=_[_0xf3a0('0x44')](_0x364177[_0xf3a0('0x45')],qs['fields'](_0x3d8325[_0xf3a0('0x42')][_0xf3a0('0x47')]));_0x309d3a[_0xf3a0('0x46')]=_0x309d3a[_0xf3a0('0x46')][_0xf3a0('0x39')]?_0x309d3a[_0xf3a0('0x46')]:_0x364177[_0xf3a0('0x45')];if(!_0x3d8325['query']['hasOwnProperty'](_0xf3a0('0x48'))){_0x309d3a[_0xf3a0('0x23')]=qs[_0xf3a0('0x23')](_0x3d8325['query'][_0xf3a0('0x23')]);_0x309d3a['offset']=qs[_0xf3a0('0x20')](_0x3d8325['query'][_0xf3a0('0x20')]);}_0x309d3a[_0xf3a0('0x49')]=qs[_0xf3a0('0x4a')](_0x3d8325[_0xf3a0('0x42')]['sort']);_0x309d3a['where']=qs[_0xf3a0('0x43')](_[_0xf3a0('0x4b')](_0x3d8325[_0xf3a0('0x42')],_0x364177[_0xf3a0('0x43')]),_0x438375);var _0xe1b3aa=[];var _0xb92bad=squel[_0xf3a0('0x4c')]()['field']('id')[_0xf3a0('0x4d')](_0xf3a0('0x2e'))[_0xf3a0('0x4d')](_0xf3a0('0x4e'))[_0xf3a0('0x4f')](_0xf3a0('0x50'));var _0x2c164c=squel[_0xf3a0('0x4c')]()['from'](_0xf3a0('0x51'),'c')['left_join'](_0xf3a0('0x52'),'uc',_0xf3a0('0x53'))[_0xf3a0('0x54')](_0xf3a0('0x55'),'ct','ct.CmContactId\x20=\x20c.id')[_0xf3a0('0x54')](_0xf3a0('0x50'),'t','t.id\x20=\x20ct.TagId')[_0xf3a0('0x56')](_0xf3a0('0x57'));var _0x4cd775=squel[_0xf3a0('0x58')]();var _0x5568a2=[];var _0x927cb7=squel[_0xf3a0('0x58')]();var _0x29da13;if(_0x3d8325['query'][_0xf3a0('0x59')]){_0x29da13=as[_0xf3a0('0x5a')](_0x3d8325[_0xf3a0('0x42')][_0xf3a0('0x59')]);var _0x2af79b=_0x29da13[_0xf3a0('0x5b')];for(var _0x2d9e18=0x0;_0x2d9e18<_0x29da13['conditions']['length'];_0x2d9e18++){var _0x458295=_0x29da13[_0xf3a0('0x5c')][_0x2d9e18];var _0x3d0b2d='c';var _0x1dbdb2=_(_0x438375)[_0xf3a0('0x38')]()['find'](function(_0x5b9962){return _0x5b9962===_0x458295[_0xf3a0('0x4d')];});if(_0x1dbdb2)_0x1dbdb2=_0x438375[_0x458295[_0xf3a0('0x4d')]];if(!_0x1dbdb2){if(_0x458295['field']===_0xf3a0('0x5d')){var _0x473441=_0x458295['value']['split'](',')[_0xf3a0('0x5e')](function(_0x10f672){return Number(_0x10f672);});_0x473441[_0xf3a0('0x5f')](function(_0x3ac7c9){_0x927cb7['or'](_0xf3a0('0x60'),'%,'+_0x3ac7c9+',%');});_0x5568a2=_[_0xf3a0('0x61')](_0x5568a2,_0x473441);}else if(_0x458295[_0xf3a0('0x4d')]===_0xf3a0('0x62')){_0x4cd775[_0xf3a0('0x63')](_0xf3a0('0x64'),_0x458295[_0xf3a0('0x65')]);}}else{if(_0x458295[_0xf3a0('0x4d')]===_0xf3a0('0x66')||_0x1dbdb2[_0xf3a0('0x40')]===_0xf3a0('0x67'))_0x458295[_0xf3a0('0x68')]=_0xf3a0('0x69');var _0x2d7ce5=as[_0xf3a0('0x6a')](_0x3d0b2d,_0x1dbdb2[_0xf3a0('0x41')],_0x458295);_0x4cd775[_0x2af79b](_0x2d7ce5['text'],_0x2d7ce5[_0xf3a0('0x65')]['start'],_0x2d7ce5[_0xf3a0('0x65')]['end']);}}}else{var _0x8728ce=_(Object['keys'](_0x3d8325['query']))[_0xf3a0('0x5e')](function(_0x332deb){return _0x438375[_0xf3a0('0x6b')](_0x332deb)?_0x332deb:undefined;})[_0xf3a0('0x6c')](function(_0x2f90ef){return!_[_0xf3a0('0x6d')](_0x2f90ef);})[_0xf3a0('0x65')]();if(_0x3d8325[_0xf3a0('0x42')]['Contact'])_0x8728ce['push'](_0xf3a0('0x6e'));if(!_[_0xf3a0('0x6f')](_0x8728ce)){_0x8728ce[_0xf3a0('0x5f')](function(_0x542199){if(_0x542199===_0xf3a0('0x70')){_0x2c164c[_0xf3a0('0x56')](_0xf3a0('0x71'),[][_0xf3a0('0x72')](_0x3d8325[_0xf3a0('0x42')][_0x542199]));}else if(_0x542199===_0xf3a0('0x6e')){var _0x1187b4='%'+_0x3d8325[_0xf3a0('0x42')][_0x542199]+'%';_0x2c164c[_0xf3a0('0x56')](_0xf3a0('0x73'),_0x1187b4);}else{_0x2c164c[_0xf3a0('0x56')]('c.'+_0x542199+'\x20=\x20?',_0x3d8325['query'][_0x542199]);}});}if(_0x3d8325[_0xf3a0('0x42')][_0xf3a0('0x74')]){_0x5568a2=_[_0xf3a0('0x75')](_0x3d8325[_0xf3a0('0x42')][_0xf3a0('0x74')])?_0x3d8325[_0xf3a0('0x42')][_0xf3a0('0x74')]:new Array(_0x3d8325[_0xf3a0('0x42')][_0xf3a0('0x74')]);_0x5568a2[_0xf3a0('0x5f')](function(_0x2676b4){_0x927cb7['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x2676b4+',%');});}if(_0x3d8325[_0xf3a0('0x42')]['filter']){var _0x24725b=_0x3d8325['query'][_0xf3a0('0x6c')]['replace']('\x5c','\x5c\x5c')[_0xf3a0('0x76')](/'/g,'\x27\x27');if(_0x24725b[_0xf3a0('0x77')]('\x20')[_0xf3a0('0x39')]>0x1){_0x4cd775['or'](_0xf3a0('0x78'),qs['getFullTextValue'](_0x24725b),null);}else{if(qs[_0xf3a0('0x79')](_0x24725b)){_0x4cd775['or']('c.id\x20LIKE\x20?',_0x24725b+'%');_0x4cd775['or'](_0xf3a0('0x7a'),_0x24725b+'%');_0x4cd775['or'](_0xf3a0('0x7b'),_0x24725b+'%');_0x4cd775['or']('c.fax\x20LIKE\x20?',_0x24725b+'%');}else if(qs[_0xf3a0('0x7c')](_0x24725b)){_0x4cd775['or'](_0xf3a0('0x7d'),_0x24725b+'%');}else{_0x4cd775['or'](_0xf3a0('0x7e'),'%'+_0x24725b+'%');_0x4cd775['or'](_0xf3a0('0x7f'),'%'+_0x24725b+'%');_0x4cd775['or'](_0xf3a0('0x7d'),'%'+_0x24725b+'%');}}}}_0x2c164c[_0xf3a0('0x56')](_0x4cd775);_0x2c164c[_0xf3a0('0x80')]('c.id');var _0x32ccfa={'type':db[_0xf3a0('0x81')][_0xf3a0('0x82')][_0xf3a0('0x83')],'raw':!![]};var _0x50d5f2=_0x2c164c['clone']()[_0xf3a0('0x4d')](_0xf3a0('0x84'));if(_0x309d3a[_0xf3a0('0x49')]){_0x309d3a['order'][_0xf3a0('0x5f')](function(_0xfeff43){_0x2c164c[_0xf3a0('0x49')]('c.'+_0xfeff43[0x0],_0xfeff43[0x1]==='DESC'?![]:!![]);});}if(!_['isEmpty'](_0x5568a2)){_0x2c164c[_0xf3a0('0x85')](_0x927cb7);_0x50d5f2[_0xf3a0('0x56')](_0xf3a0('0x86'),_0x5568a2);}BPromise[_0xf3a0('0x87')]()[_0xf3a0('0x2b')](function(){if(!_0x29da13)return;if(_0x3d8325[_0xf3a0('0x88')][_0xf3a0('0x89')]!==_0xf3a0('0x34'))return;if(!_[_0xf3a0('0x8a')](_0x29da13[_0xf3a0('0x5c')],[_0xf3a0('0x4d'),_0xf3a0('0x62')])){return _0x3d8325[_0xf3a0('0x88')][_0xf3a0('0x8b')]({'attributes':['id'],'raw':!![]})[_0xf3a0('0x2b')](function(_0x2bdd49){if(_['isEmpty'](_0x2bdd49)){_0x50d5f2[_0xf3a0('0x56')]('c.ListId\x20IS\x20NULL');_0x2c164c[_0xf3a0('0x56')]('c.ListId\x20IS\x20NULL');}else{_0x50d5f2['where']('c.ListId\x20IN\x20?',_[_0xf3a0('0x5e')](_0x2bdd49,'id'));_0x2c164c[_0xf3a0('0x56')](_0xf3a0('0x71'),_[_0xf3a0('0x5e')](_0x2bdd49,'id'));}});}})[_0xf3a0('0x2b')](function(){if(_0x3d8325['user']['role']===_0xf3a0('0x34')&&!_0x29da13&&!_0x3d8325[_0xf3a0('0x42')]['ListId'])return[];return db[_0xf3a0('0x8c')][_0xf3a0('0x42')](_0x50d5f2['toString'](),_0x32ccfa);})[_0xf3a0('0x2b')](function(_0xd4837a){_0x40b58f[_0xf3a0('0x22')]=_0xd4837a[_0xf3a0('0x39')];if(_0x40b58f['count']===0x0)return[];return db[_0xf3a0('0x8c')][_0xf3a0('0x42')](_0xb92bad['toString'](),_0x32ccfa)[_0xf3a0('0x2b')](function(_0x2d53fa){_0xe1b3aa=_[_0xf3a0('0x8d')](_0x2d53fa,'id');_0x32ccfa=_[_0xf3a0('0x30')](_0x32ccfa,{'model':db[_0xf3a0('0x37')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x3d8325[_0xf3a0('0x42')][_0xf3a0('0x47')]){_0x309d3a[_0xf3a0('0x46')][_0xf3a0('0x5f')](function(_0x141627){_0x2c164c[_0xf3a0('0x4d')]('c.'+_0x141627);});}else{_0x2c164c[_0xf3a0('0x4d')](_0xf3a0('0x84'));_0x2c164c[_0xf3a0('0x4d')](_0xf3a0('0x8e'));_0x2c164c[_0xf3a0('0x4d')](_0xf3a0('0x8f'));_0x2c164c[_0xf3a0('0x4d')](_0xf3a0('0x90'));_0x2c164c[_0xf3a0('0x4d')]('c.mobile');_0x2c164c['field'](_0xf3a0('0x91'));_0x2c164c[_0xf3a0('0x4d')]('c.email');_0x2c164c[_0xf3a0('0x4d')](_0xf3a0('0x92'));_0x2c164c[_0xf3a0('0x4d')](_0xf3a0('0x93'));_0x2c164c[_0xf3a0('0x4d')]('c.deletedAt');_0x2c164c['field'](_0xf3a0('0x94'));_0x2c164c['field']('GROUP_CONCAT(DISTINCT\x20t.id)',_0xf3a0('0x95'));}if(_0x309d3a['limit'])_0x2c164c[_0xf3a0('0x23')](_0x309d3a['limit']);if(_0x309d3a[_0xf3a0('0x20')])_0x2c164c[_0xf3a0('0x20')](_0x309d3a[_0xf3a0('0x20')]);return db[_0xf3a0('0x8c')]['query'](_0x2c164c[_0xf3a0('0x96')](),_0x32ccfa);});})[_0xf3a0('0x2b')](function(_0x4632b1){_0x4632b1[_0xf3a0('0x5f')](function(_0x575031){if(_0x575031[_0xf3a0('0x95')]){_0x575031[_0xf3a0('0x97')]=[];_0x575031[_0xf3a0('0x95')][_0xf3a0('0x77')](',')['forEach'](function(_0x1294aa){_0x575031[_0xf3a0('0x97')][_0xf3a0('0x3b')](_0xe1b3aa[_0x1294aa]);});}delete _0x575031['TagIds'];});_0x40b58f[_0xf3a0('0x98')]=_0x4632b1;return _0x40b58f;})[_0xf3a0('0x2b')](respondWithFilteredResult(_0x183bb6,_0x309d3a));})['catch'](handleError(_0x183bb6,null));};exports['destroy']=function(_0xbe9100,_0x38965a){return db[_0xf3a0('0x37')][_0xf3a0('0x99')]({'where':{'id':_0xbe9100['params']['id']}})[_0xf3a0('0x2b')](handleEntityNotFound(_0x38965a,null))['then'](removeEntity(_0x38965a,null))[_0xf3a0('0x9a')](handleError(_0x38965a,null));};exports[_0xf3a0('0x9b')]=function(_0x28621c,_0x4855e1){return db[_0xf3a0('0x37')][_0xf3a0('0x9b')]()[_0xf3a0('0x2b')](function(_0x3d43b0){delete _0x3d43b0[_0xf3a0('0x9c')];for(var _0x1e03d8=0x0;_0x1e03d8<Object['keys'](_0x3d43b0)[_0xf3a0('0x39')];_0x1e03d8++){var _0x38229f=Object[_0xf3a0('0x38')](_0x3d43b0)[_0x1e03d8];if(!_['startsWith'](_0x38229f,'cf_')){_0x3d43b0[_0x38229f][_0xf3a0('0x9d')]=_0x38229f;_0x3d43b0[_0x38229f]['displayName']=_0x38229f;}}return _0x3d43b0;})[_0xf3a0('0x2b')](function(_0x4acc5c){var _0xb1c8d0={'where':{'$or':[{'ListId':_0x28621c[_0xf3a0('0x42')]['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField'][_0xf3a0('0x9e')](_0xb1c8d0)[_0xf3a0('0x2b')](function(_0x51e5af){for(var _0x15a0c2=0x0;_0x15a0c2<_0x51e5af[_0xf3a0('0x39')];_0x15a0c2++){var _0x341c76=_0xf3a0('0x3e')+_0x51e5af[_0x15a0c2]['id'];_0x4acc5c[_0x341c76][_0xf3a0('0x9d')]=_0x341c76;_0x4acc5c[_0x341c76]['displayName']=_0x51e5af[_0x15a0c2][_0xf3a0('0x9f')];_0x4acc5c[_0x341c76][_0xf3a0('0xa0')]={'type':_0x51e5af[_0x15a0c2][_0xf3a0('0x41')],'values':_0x51e5af[_0x15a0c2]['values']};}Object['keys'](_0x4acc5c)['forEach'](function(_0x399fa7){if(!_0x4acc5c[_0x399fa7]['hasOwnProperty'](_0xf3a0('0x9d'))){delete _0x4acc5c[_0x399fa7];}});return _0x4acc5c;});})[_0xf3a0('0x2b')](respondWithResult(_0x4855e1,null))[_0xf3a0('0x9a')](handleError(_0x4855e1,null));};exports[_0xf3a0('0x30')]=function(_0x1263ba,_0x260509){var _0x1bd566;var _0x1bbf07;var _0x17949;if(_0x1263ba[_0xf3a0('0x31')]['id']){delete _0x1263ba['body']['id'];}return db[_0xf3a0('0x37')][_0xf3a0('0x9e')]({'where':{'id':[_0x1263ba['body']['to'],_0x1263ba['body'][_0xf3a0('0x4f')]]}})['then'](function(_0x54e75d){if(_0x54e75d){if(_0x54e75d[_0xf3a0('0x39')]!==0x2){return null;}_0x54e75d[0x0]=_0x54e75d[0x0][_0xf3a0('0xa1')]({'plain':!![]});_0x54e75d[0x1]=_0x54e75d[0x1][_0xf3a0('0xa1')]({'plain':!![]});delete _0x54e75d[0x0]['id'];delete _0x54e75d[0x1]['id'];return _[_0xf3a0('0xa2')](_0x54e75d[0x0],_0x54e75d[0x1],function(_0x218413,_0x3053ef){if(Array['isArray'](_0x3053ef)&&!_0x3053ef[_0xf3a0('0x39')]){return _0x218413;}else if(!_0x3053ef){return _0x218413;}});}})[_0xf3a0('0x2b')](handleEntityNotFound(_0x260509,null))[_0xf3a0('0x2b')](function(_0x2c8fb6){if(_0x2c8fb6){if(_0x2c8fb6[_0xf3a0('0x9c')]&&_[_0xf3a0('0x75')](_0x2c8fb6[_0xf3a0('0x9c')])){_0x2c8fb6['tags']=_0x2c8fb6['tags'][_0xf3a0('0xa3')]();}logger[_0xf3a0('0xa4')](_0xf3a0('0xa5'),_0x1263ba[_0xf3a0('0x31')]['to'],_0x1263ba[_0xf3a0('0x31')][_0xf3a0('0x4f')]);return db[_0xf3a0('0xa6')]['destroy']({'where':{'ContactId':[_0x1263ba['body']['to'],_0x1263ba[_0xf3a0('0x31')]['from']]}})[_0xf3a0('0x2b')](function(_0x182249){logger[_0xf3a0('0xa4')](_0xf3a0('0xa7'),_0x182249);return db['CmHopperBlack'][_0xf3a0('0x2c')]({'where':{'ContactId':[_0x1263ba[_0xf3a0('0x31')]['to'],_0x1263ba[_0xf3a0('0x31')]['from']]}})[_0xf3a0('0x2b')](function(_0x46e525){logger[_0xf3a0('0xa4')]('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x46e525);return db[_0xf3a0('0x37')][_0xf3a0('0xa8')](_0x2c8fb6);});});}})[_0xf3a0('0x2b')](function(_0x2b866d){if(_0x2b866d){_0x1bd566=_0x2b866d;_0x1bbf07={'ContactId':_0x1bd566['id']};_0x17949={'where':{'ContactId':[_0x1263ba[_0xf3a0('0x31')]['to'],_0x1263ba[_0xf3a0('0x31')][_0xf3a0('0x4f')]]}};return db[_0xf3a0('0xa9')][_0xf3a0('0x2a')](_0x1bbf07,_0x17949);}})[_0xf3a0('0x2b')](function(){if(_0x1bd566){return db[_0xf3a0('0xaa')][_0xf3a0('0x2a')](_0x1bbf07,_0x17949);}})['then'](function(){if(_0x1bd566){return db[_0xf3a0('0xab')][_0xf3a0('0x2a')](_0x1bbf07,_0x17949);}})['then'](function(){if(_0x1bd566){return db[_0xf3a0('0xac')]['update'](_0x1bbf07,_0x17949);}})[_0xf3a0('0x2b')](function(){if(_0x1bd566){return db[_0xf3a0('0xad')]['update'](_0x1bbf07,_0x17949);}})['then'](function(){if(_0x1bd566){return db['MailInteraction']['update'](_0x1bbf07,_0x17949);}})['then'](function(){if(_0x1bd566){return db[_0xf3a0('0xad')][_0xf3a0('0x2a')](_0x1bbf07,_0x17949);}})[_0xf3a0('0x2b')](function(){if(_0x1bd566){return db[_0xf3a0('0xae')][_0xf3a0('0x2a')](_0x1bbf07,_0x17949);}})['then'](function(){if(_0x1bd566){return db[_0xf3a0('0xaf')][_0xf3a0('0x2a')](_0x1bbf07,_0x17949);}})[_0xf3a0('0x2b')](function(){if(_0x1bd566){return db[_0xf3a0('0xb0')]['update'](_0x1bbf07,_0x17949);}})['then'](function(){if(_0x1bd566){return db[_0xf3a0('0xb1')][_0xf3a0('0x2a')](_0x1bbf07,_0x17949);}})[_0xf3a0('0x2b')](function(){if(_0x1bd566){return db[_0xf3a0('0xb2')]['update'](_0x1bbf07,_0x17949);}})['then'](function(){if(_0x1bd566){return db[_0xf3a0('0xb3')][_0xf3a0('0x2a')](_0x1bbf07,_0x17949);}})[_0xf3a0('0x2b')](function(){if(_0x1bd566){return db['CmHopperFinal'][_0xf3a0('0x2a')](_0x1bbf07,_0x17949);}})['then'](function(){if(_0x1bd566){return db['CmHopperHistory'][_0xf3a0('0x2a')](_0x1bbf07,_0x17949);}})[_0xf3a0('0x2b')](function(){if(_0x1bd566){return db[_0xf3a0('0xb4')][_0xf3a0('0x2a')](_0x1bbf07,_0x17949);}})[_0xf3a0('0x2b')](function(){if(_0x1bd566){return db[_0xf3a0('0xb5')][_0xf3a0('0x2a')](_0x1bbf07,_0x17949);}})[_0xf3a0('0x2b')](function(){if(_0x1bd566){return db['ChatQueueReport'][_0xf3a0('0x2a')](_0x1bbf07,_0x17949);}})[_0xf3a0('0x2b')](function(){if(_0x1bd566){return db[_0xf3a0('0xb6')][_0xf3a0('0x2a')](_0x1bbf07,_0x17949);}})[_0xf3a0('0x2b')](function(){if(_0x1bd566){return db[_0xf3a0('0xb7')][_0xf3a0('0x2a')](_0x1bbf07,_0x17949);}})[_0xf3a0('0x2b')](function(){if(_0x1bd566){return db[_0xf3a0('0xb8')]['update'](_0x1bbf07,_0x17949);}})['then'](function(){if(_0x1bd566){return db[_0xf3a0('0xb9')][_0xf3a0('0x2a')](_0x1bbf07,_0x17949);}})[_0xf3a0('0x2b')](function(){if(_0x1bd566){return db[_0xf3a0('0xba')]['update'](_0x1bbf07,_0x17949);}})[_0xf3a0('0x2b')](function(){if(_0x1bd566){return db[_0xf3a0('0xbb')][_0xf3a0('0x2a')](_0x1bbf07,_0x17949);}})[_0xf3a0('0x2b')](function(){if(_0x1bd566){return db[_0xf3a0('0xbc')][_0xf3a0('0x2a')](_0x1bbf07,_0x17949);}})[_0xf3a0('0x2b')](function(){if(_0x1bd566){return db['WhatsappQueueReport'][_0xf3a0('0x2a')](_0x1bbf07,_0x17949);}})[_0xf3a0('0x2b')](function(){if(_0x1bd566){return db[_0xf3a0('0x37')][_0xf3a0('0x2c')]({'where':{'id':[_0x1263ba['body']['to'],_0x1263ba[_0xf3a0('0x31')][_0xf3a0('0x4f')]]}});}})[_0xf3a0('0x2b')](function(){if(_0x1bd566){return _0x1bd566;}})[_0xf3a0('0x2b')](respondWithResult(_0x260509,null))[_0xf3a0('0x9a')](handleError(_0x260509,null));};exports[_0xf3a0('0xa8')]=function(_0x3f6296,_0x402da5){return db[_0xf3a0('0x37')][_0xf3a0('0x9b')]()[_0xf3a0('0x2b')](function(_0xb02667){if(_0x3f6296[_0xf3a0('0x31')][_0xf3a0('0x9c')]&&_['isArray'](_0x3f6296[_0xf3a0('0x31')][_0xf3a0('0x9c')])){if(_0x3f6296[_0xf3a0('0x31')][_0xf3a0('0x9c')][_0xf3a0('0x39')]){_0x3f6296[_0xf3a0('0x31')][_0xf3a0('0x9c')]=_0x3f6296[_0xf3a0('0x31')][_0xf3a0('0x9c')]['join'](';')+';';}else{_0x3f6296[_0xf3a0('0x31')][_0xf3a0('0x9c')]=null;}}else{_0x3f6296['body'][_0xf3a0('0x9c')]=null;}return db[_0xf3a0('0x37')][_0xf3a0('0xa8')](_0x3f6296['body'],{'fields':_[_0xf3a0('0x38')](_0xb02667),'raw':!![]});})[_0xf3a0('0x2b')](respondWithResult(_0x402da5,0xc9))[_0xf3a0('0x9a')](handleError(_0x402da5,null));};exports[_0xf3a0('0xbd')]=function(_0x2b7de1,_0x1961b5){var _0x4b9394=[];var _0x3aa8c0=0x0;var _0x588b19=0x0;var _0x3a1365=0x0;return db[_0xf3a0('0x37')][_0xf3a0('0x9b')]()[_0xf3a0('0x2b')](function(_0x5811a9){return BPromise['each'](_0x2b7de1[_0xf3a0('0x31')],function(_0xdc15ff){var _0x49cb9c={'where':{'$or':[]},'defaults':_0xdc15ff,'fields':_[_0xf3a0('0x38')](_0x5811a9),'raw':!![]};if(_0xdc15ff[_0xf3a0('0xbe')]){for(var _0x296465=0x0;_0x296465<_0xdc15ff[_0xf3a0('0xbe')][_0xf3a0('0x39')];_0x296465++){var _0x1c7438={};_0x1c7438[_0xdc15ff['duplicates'][_0x296465]]=_0xdc15ff[_0xdc15ff[_0xf3a0('0xbe')][_0x296465]];_0x49cb9c[_0xf3a0('0x56')][_0xf3a0('0xbf')]['push'](_0x1c7438);}_0x49cb9c[_0xf3a0('0x56')][_0xf3a0('0x70')]=_0xdc15ff[_0xf3a0('0x70')];}return db['CmContact'][_0xf3a0('0xc0')](_0x49cb9c)[_0xf3a0('0xc1')](function(_0x5b1420,_0x17e0b4){if(_0x17e0b4){_0x3aa8c0++;}else{_0x3a1365++;}})[_0xf3a0('0x9a')](function(_0x55d2bc){console[_0xf3a0('0x2d')](_0x55d2bc);_0x588b19++;});});})[_0xf3a0('0x2b')](function(_0x1e75a4){if(_0x1e75a4){return{'success':_0x3aa8c0,'failure':_0x588b19,'duplicates':_0x3a1365};}})[_0xf3a0('0x2b')](respondWithResult(_0x1961b5,0xc9))[_0xf3a0('0x9a')](handleError(_0x1961b5,null));};exports[_0xf3a0('0xc2')]=function(_0x253a2e,_0x5ccbe2,_0x182fc9){var _0x2c3456;return db['CmContact'][_0xf3a0('0x9b')]()[_0xf3a0('0x2b')](function(_0x27e6d4){return db[_0xf3a0('0x37')]['find']({'where':{'id':_0x253a2e[_0xf3a0('0xc3')]['id']},'include':[{'model':db[_0xf3a0('0x5d')],'as':_0xf3a0('0x97'),'attributes':['id',_0xf3a0('0x2e'),_0xf3a0('0x4e')],'required':_0x253a2e[_0xf3a0('0x42')][_0xf3a0('0x74')]?!![]:![]}],'attributes':_['keys'](_0x27e6d4)});})[_0xf3a0('0x2b')](function(_0x764557){_0x2c3456=_0x764557[_0xf3a0('0xa1')]({'plain':!![]});var _0xc07a98={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x764557&&_0x764557['ListId']){if(_0x764557[_0xf3a0('0x70')]){_0xc07a98[_0xf3a0('0x56')][_0xf3a0('0xc4')][_0xf3a0('0x3b')]({'ListId':{'$ne':_0x764557[_0xf3a0('0x70')]}});}}return db[_0xf3a0('0x3c')][_0xf3a0('0x9e')](_0xc07a98);})[_0xf3a0('0x2b')](function(_0x18a073){return _[_0xf3a0('0xc5')](_0x2c3456,_['map'](_0x18a073,function(_0x14ce34){return util[_0xf3a0('0xc6')]('cf_%d',_0x14ce34['id']);}));})[_0xf3a0('0x2b')](handleEntityNotFound(_0x5ccbe2,null))[_0xf3a0('0x2b')](respondWithResult(_0x5ccbe2,null))[_0xf3a0('0x9a')](handleError(_0x5ccbe2,null));};exports['update']=function(_0x534e07,_0x43c12e){var _0x16f9a0;if(_0x534e07['body']['id']){delete _0x534e07[_0xf3a0('0x31')]['id'];}return db[_0xf3a0('0x37')][_0xf3a0('0x99')]({'where':{'id':_0x534e07['params']['id']}})[_0xf3a0('0x2b')](handleEntityNotFound(_0x43c12e,null))[_0xf3a0('0x2b')](saveUpdates(_0x534e07[_0xf3a0('0x31')],null))[_0xf3a0('0x2b')](function(_0x22c840){_0x16f9a0=_0x22c840;var _0xaedaad={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x22c840&&_0x22c840['ListId']){if(_0x22c840[_0xf3a0('0x70')]){_0xaedaad[_0xf3a0('0x56')]['$and'][_0xf3a0('0x3b')]({'ListId':{'$ne':_0x22c840[_0xf3a0('0x70')]}});}}return db[_0xf3a0('0x3c')][_0xf3a0('0x9e')](_0xaedaad);})[_0xf3a0('0x2b')](function(_0x47f34b){if(_0x47f34b){return _[_0xf3a0('0xc5')](_['pickBy'](_0x534e07[_0xf3a0('0x31')],function(_0x4aba73,_0x5e7f1d){return _[_0xf3a0('0x3a')](_0x5e7f1d,_0xf3a0('0x3e'));}),_['map'](_0x47f34b,function(_0x2ca479){return util[_0xf3a0('0xc6')]('cf_%d',_0x2ca479['id']);}));}})[_0xf3a0('0x2b')](function(_0x4e337c){if(_0x4e337c&&!_[_0xf3a0('0x6f')](_0x4e337c)){var _0x2aad39=squel[_0xf3a0('0x2a')]()[_0xf3a0('0xc7')](_0xf3a0('0x51'))['setFields'](_0x4e337c)['where'](_0xf3a0('0xc8'),_0x534e07[_0xf3a0('0xc3')]['id'])['toParam']();return db[_0xf3a0('0x8c')]['query'](_0x2aad39['text'],{'replacements':_0x2aad39[_0xf3a0('0xc9')]});}})[_0xf3a0('0x2b')](function(){if(_0x534e07['body'][_0xf3a0('0xca')]&&_0x16f9a0){return db[_0xf3a0('0xa6')][_0xf3a0('0x2a')]({'phone':_0x534e07[_0xf3a0('0x31')][_0xf3a0('0xca')]},{'where':{'ContactId':_0x16f9a0['id']}});}})[_0xf3a0('0x2b')](function(){return _0x16f9a0;})[_0xf3a0('0x2b')](respondWithResult(_0x43c12e,null))[_0xf3a0('0x9a')](handleError(_0x43c12e,null));};exports[_0xf3a0('0xcb')]=function(_0x3c5f72,_0x4f127f,_0x286308){var _0x157185={};var _0x316ced={};var _0x12f6ab;var _0x509746;return db[_0xf3a0('0x37')][_0xf3a0('0x3d')]({'where':{'id':_0x3c5f72[_0xf3a0('0xc3')]['id']}})['then'](handleEntityNotFound(_0x4f127f,null))['then'](function(_0x3ab076){if(_0x3ab076){_0x12f6ab=_0x3ab076;_0x316ced[_0xf3a0('0x45')]=_[_0xf3a0('0x38')](db[_0xf3a0('0x5d')]['rawAttributes']);_0x316ced[_0xf3a0('0x42')]=_[_0xf3a0('0x38')](_0x3c5f72['query']);_0x316ced[_0xf3a0('0x43')]=_['intersection'](_0x316ced[_0xf3a0('0x45')],_0x316ced[_0xf3a0('0x42')]);_0x157185['attributes']=_['intersection'](_0x316ced[_0xf3a0('0x45')],qs[_0xf3a0('0x47')](_0x3c5f72[_0xf3a0('0x42')][_0xf3a0('0x47')]));_0x157185['attributes']=_0x157185[_0xf3a0('0x46')][_0xf3a0('0x39')]?_0x157185['attributes']:_0x316ced[_0xf3a0('0x45')];_0x157185['order']=qs[_0xf3a0('0x4a')](_0x3c5f72['query'][_0xf3a0('0x4a')]);_0x157185[_0xf3a0('0x56')]=qs[_0xf3a0('0x43')](_['pick'](_0x3c5f72[_0xf3a0('0x42')],_0x316ced['filters']));if(_0x3c5f72[_0xf3a0('0x42')][_0xf3a0('0x6c')]){_0x157185[_0xf3a0('0x56')]=_[_0xf3a0('0x30')](_0x157185['where'],{'$or':_[_0xf3a0('0x5e')](_0x157185[_0xf3a0('0x46')],function(_0x338d7c){var _0x3e791f={};_0x3e791f[_0x338d7c]={'$like':'%'+_0x3c5f72[_0xf3a0('0x42')][_0xf3a0('0x6c')]+'%'};return _0x3e791f;})});}_0x157185=_['merge']({},_0x157185,_0x3c5f72[_0xf3a0('0xcc')]);return _0x12f6ab[_0xf3a0('0xcb')](_0x157185);}})['then'](function(_0x5a14ea){if(_0x5a14ea){_0x509746=_0x5a14ea[_0xf3a0('0x39')];if(!_0x3c5f72[_0xf3a0('0x42')][_0xf3a0('0x6b')](_0xf3a0('0x48'))){_0x157185[_0xf3a0('0x23')]=qs['limit'](_0x3c5f72[_0xf3a0('0x42')]['limit']);_0x157185['offset']=qs[_0xf3a0('0x20')](_0x3c5f72[_0xf3a0('0x42')][_0xf3a0('0x20')]);}return _0x12f6ab[_0xf3a0('0xcb')](_0x157185);}})['then'](function(_0x21a5a2){if(_0x21a5a2){return _0x21a5a2?{'count':_0x509746,'rows':_0x21a5a2}:null;}})[_0xf3a0('0x2b')](respondWithResult(_0x4f127f,null))[_0xf3a0('0x9a')](handleError(_0x4f127f,null));};exports[_0xf3a0('0xcd')]=function(_0x34f52a,_0x17ac92,_0x224e12){if(_0x34f52a[_0xf3a0('0x31')]['id']){delete _0x34f52a[_0xf3a0('0x31')]['id'];}return db['CmContact']['findOne']({'where':{'id':_0x34f52a[_0xf3a0('0xc3')]['id']}})[_0xf3a0('0x2b')](handleEntityNotFound(_0x17ac92,null))[_0xf3a0('0x2b')](function(_0x4348f1){if(_0x4348f1){return _0x4348f1[_0xf3a0('0xcd')](_0x34f52a[_0xf3a0('0x31')][_0xf3a0('0xce')]||[]);}return null;})[_0xf3a0('0x2b')](respondWithResult(_0x17ac92,null))[_0xf3a0('0x9a')](handleError(_0x17ac92,null));};exports[_0xf3a0('0xcf')]=function(_0x204c0e,_0x446b79,_0x330484){var _0x5ee6aa={'raw':![],'where':{}};var _0x3e7261={};var _0x55dca9={'count':0x0,'rows':[]};return db[_0xf3a0('0x37')][_0xf3a0('0x3d')]({'where':{'id':_0x204c0e['params']['id']}})[_0xf3a0('0x2b')](handleEntityNotFound(_0x446b79,null))[_0xf3a0('0x2b')](function(_0x3d2725){if(_0x3d2725){_0x3e7261[_0xf3a0('0x45')]=_[_0xf3a0('0x38')](db[_0xf3a0('0xa6')][_0xf3a0('0xd0')]);_0x3e7261[_0xf3a0('0x42')]=_['keys'](_0x204c0e[_0xf3a0('0x42')]);_0x3e7261[_0xf3a0('0x43')]=_[_0xf3a0('0x44')](_0x3e7261[_0xf3a0('0x45')],_0x3e7261['query']);_0x5ee6aa[_0xf3a0('0x46')]=_[_0xf3a0('0x44')](_0x3e7261['model'],qs[_0xf3a0('0x47')](_0x204c0e[_0xf3a0('0x42')]['fields']));_0x5ee6aa[_0xf3a0('0x46')]=_0x5ee6aa[_0xf3a0('0x46')][_0xf3a0('0x39')]?_0x5ee6aa[_0xf3a0('0x46')]:_0x3e7261[_0xf3a0('0x45')];if(!_0x204c0e[_0xf3a0('0x42')][_0xf3a0('0x6b')](_0xf3a0('0x48'))){_0x5ee6aa[_0xf3a0('0x23')]=qs[_0xf3a0('0x23')](_0x204c0e['query']['limit']);_0x5ee6aa[_0xf3a0('0x20')]=qs[_0xf3a0('0x20')](_0x204c0e[_0xf3a0('0x42')][_0xf3a0('0x20')]);}_0x5ee6aa[_0xf3a0('0x49')]=qs[_0xf3a0('0x4a')](_0x204c0e[_0xf3a0('0x42')][_0xf3a0('0x4a')]);_0x5ee6aa[_0xf3a0('0x56')]=qs[_0xf3a0('0x43')](_[_0xf3a0('0x4b')](_0x204c0e['query'],_0x3e7261[_0xf3a0('0x43')]));_0x5ee6aa['where']['ContactId']=_0x3d2725['id'];if(_0x204c0e[_0xf3a0('0x42')][_0xf3a0('0x6c')]){_0x5ee6aa[_0xf3a0('0x56')]=_[_0xf3a0('0x30')](_0x5ee6aa[_0xf3a0('0x56')],{'$or':_[_0xf3a0('0x5e')](_0x5ee6aa[_0xf3a0('0x46')],function(_0x656a84){var _0x2072d5={};_0x2072d5[_0x656a84]={'$like':'%'+_0x204c0e[_0xf3a0('0x42')][_0xf3a0('0x6c')]+'%'};return _0x2072d5;})});}_0x5ee6aa=_[_0xf3a0('0x30')]({},_0x5ee6aa,_0x204c0e[_0xf3a0('0xcc')]);return db[_0xf3a0('0xa6')]['count']({'where':_0x5ee6aa['where']})[_0xf3a0('0x2b')](function(_0x594a8a){_0x55dca9[_0xf3a0('0x22')]=_0x594a8a;if(_0x204c0e[_0xf3a0('0x42')][_0xf3a0('0xd1')]){_0x5ee6aa[_0xf3a0('0xd2')]=[{'all':!![]}];}return db['CmHopper'][_0xf3a0('0x9e')](_0x5ee6aa);})['then'](function(_0x73d107){_0x55dca9[_0xf3a0('0x98')]=_0x73d107;return _0x55dca9;});}})[_0xf3a0('0x2b')](respondWithFilteredResult(_0x446b79,_0x5ee6aa))[_0xf3a0('0x9a')](handleError(_0x446b79,null));};exports[_0xf3a0('0xd3')]=function(_0x429891,_0xa98035,_0x13009f){var _0x564960={'raw':!![],'where':{}};var _0x914811={};var _0x4ac234={'count':0x0,'rows':[]};return db[_0xf3a0('0x37')][_0xf3a0('0x3d')]({'where':{'id':_0x429891[_0xf3a0('0xc3')]['id']}})[_0xf3a0('0x2b')](handleEntityNotFound(_0xa98035,null))['then'](function(_0x1f677f){if(_0x1f677f){_0x914811['model']=_[_0xf3a0('0x38')](db['CmHopperHistory'][_0xf3a0('0xd0')]);_0x914811[_0xf3a0('0x42')]=_[_0xf3a0('0x38')](_0x429891[_0xf3a0('0x42')]);_0x914811[_0xf3a0('0x43')]=_[_0xf3a0('0x44')](_0x914811[_0xf3a0('0x45')],_0x914811[_0xf3a0('0x42')]);_0x564960[_0xf3a0('0x46')]=_[_0xf3a0('0x44')](_0x914811[_0xf3a0('0x45')],qs['fields'](_0x429891[_0xf3a0('0x42')][_0xf3a0('0x47')]));_0x564960[_0xf3a0('0x46')]=_0x564960['attributes'][_0xf3a0('0x39')]?_0x564960[_0xf3a0('0x46')]:_0x914811[_0xf3a0('0x45')];if(!_0x429891[_0xf3a0('0x42')][_0xf3a0('0x6b')](_0xf3a0('0x48'))){_0x564960['limit']=qs[_0xf3a0('0x23')](_0x429891[_0xf3a0('0x42')]['limit']);_0x564960[_0xf3a0('0x20')]=qs[_0xf3a0('0x20')](_0x429891[_0xf3a0('0x42')]['offset']);}_0x564960[_0xf3a0('0x49')]=qs[_0xf3a0('0x4a')](_0x429891[_0xf3a0('0x42')][_0xf3a0('0x4a')]);_0x564960['where']=qs['filters'](_['pick'](_0x429891[_0xf3a0('0x42')],_0x914811[_0xf3a0('0x43')]));_0x564960[_0xf3a0('0x56')]['ContactId']=_0x1f677f['id'];if(_0x429891[_0xf3a0('0x42')][_0xf3a0('0x6c')]){_0x564960[_0xf3a0('0x56')]=_[_0xf3a0('0x30')](_0x564960[_0xf3a0('0x56')],{'$or':_[_0xf3a0('0x5e')](_0x564960[_0xf3a0('0x46')],function(_0x1ce74a){var _0x23b170={};_0x23b170[_0x1ce74a]={'$like':'%'+_0x429891[_0xf3a0('0x42')]['filter']+'%'};return _0x23b170;})});}_0x564960=_[_0xf3a0('0x30')]({},_0x564960,_0x429891['options']);return db[_0xf3a0('0xd4')][_0xf3a0('0x22')]({'where':_0x564960[_0xf3a0('0x56')]})[_0xf3a0('0x2b')](function(_0x3c047a){_0x4ac234[_0xf3a0('0x22')]=_0x3c047a;if(_0x429891[_0xf3a0('0x42')][_0xf3a0('0xd1')]){_0x564960[_0xf3a0('0xd2')]=[{'all':!![]}];}return db[_0xf3a0('0xd4')][_0xf3a0('0x9e')](_0x564960);})[_0xf3a0('0x2b')](function(_0x5cfc36){_0x4ac234[_0xf3a0('0x98')]=_0x5cfc36;return _0x4ac234;});}})[_0xf3a0('0x2b')](respondWithFilteredResult(_0xa98035,_0x564960))[_0xf3a0('0x9a')](handleError(_0xa98035,null));};exports[_0xf3a0('0xd5')]=function(_0x55f5fe,_0x4af790,_0x5c7872){var _0xcaaa9e={'raw':!![],'where':{}};var _0x37e5f4={};var _0x3d9ca6={'count':0x0,'rows':[]};return db[_0xf3a0('0x37')][_0xf3a0('0x3d')]({'where':{'id':_0x55f5fe['params']['id']}})[_0xf3a0('0x2b')](handleEntityNotFound(_0x4af790,null))[_0xf3a0('0x2b')](function(_0x4a8072){if(_0x4a8072){_0x37e5f4[_0xf3a0('0x45')]=_[_0xf3a0('0x38')](db[_0xf3a0('0xd6')]['rawAttributes']);_0x37e5f4[_0xf3a0('0x42')]=_[_0xf3a0('0x38')](_0x55f5fe[_0xf3a0('0x42')]);_0x37e5f4[_0xf3a0('0x43')]=_[_0xf3a0('0x44')](_0x37e5f4[_0xf3a0('0x45')],_0x37e5f4[_0xf3a0('0x42')]);_0xcaaa9e[_0xf3a0('0x46')]=_[_0xf3a0('0x44')](_0x37e5f4[_0xf3a0('0x45')],qs[_0xf3a0('0x47')](_0x55f5fe[_0xf3a0('0x42')][_0xf3a0('0x47')]));_0xcaaa9e[_0xf3a0('0x46')]=_0xcaaa9e[_0xf3a0('0x46')][_0xf3a0('0x39')]?_0xcaaa9e[_0xf3a0('0x46')]:_0x37e5f4['model'];if(!_0x55f5fe[_0xf3a0('0x42')][_0xf3a0('0x6b')](_0xf3a0('0x48'))){_0xcaaa9e[_0xf3a0('0x23')]=qs[_0xf3a0('0x23')](_0x55f5fe[_0xf3a0('0x42')][_0xf3a0('0x23')]);_0xcaaa9e[_0xf3a0('0x20')]=qs['offset'](_0x55f5fe[_0xf3a0('0x42')]['offset']);}_0xcaaa9e[_0xf3a0('0x49')]=qs[_0xf3a0('0x4a')](_0x55f5fe[_0xf3a0('0x42')][_0xf3a0('0x4a')]);_0xcaaa9e[_0xf3a0('0x56')]=qs[_0xf3a0('0x43')](_[_0xf3a0('0x4b')](_0x55f5fe[_0xf3a0('0x42')],_0x37e5f4[_0xf3a0('0x43')]));_0xcaaa9e['where']['ContactId']=_0x4a8072['id'];if(_0x55f5fe['query'][_0xf3a0('0x6c')]){_0xcaaa9e[_0xf3a0('0x56')]=_['merge'](_0xcaaa9e['where'],{'$or':_[_0xf3a0('0x5e')](_0xcaaa9e[_0xf3a0('0x46')],function(_0x1ce298){var _0x2c55ba={};_0x2c55ba[_0x1ce298]={'$like':'%'+_0x55f5fe['query']['filter']+'%'};return _0x2c55ba;})});}_0xcaaa9e=_[_0xf3a0('0x30')]({},_0xcaaa9e,_0x55f5fe[_0xf3a0('0xcc')]);return db[_0xf3a0('0xd6')][_0xf3a0('0x22')]({'where':_0xcaaa9e[_0xf3a0('0x56')]})[_0xf3a0('0x2b')](function(_0x3e30e8){_0x3d9ca6['count']=_0x3e30e8;if(_0x55f5fe[_0xf3a0('0x42')]['includeAll']){_0xcaaa9e['include']=[{'all':!![]}];}return db['CmHopperFinal']['findAll'](_0xcaaa9e);})['then'](function(_0x278a9b){_0x3d9ca6[_0xf3a0('0x98')]=_0x278a9b;return _0x3d9ca6;});}})[_0xf3a0('0x2b')](respondWithFilteredResult(_0x4af790,_0xcaaa9e))[_0xf3a0('0x9a')](handleError(_0x4af790,null));};exports[_0xf3a0('0xd7')]=function(_0x69837b,_0x2d3397,_0x8c1347){var _0x3ccff7={'raw':!![],'where':{}};var _0x279384={};var _0xef800={'count':0x0,'rows':[]};return db[_0xf3a0('0x37')][_0xf3a0('0x3d')]({'where':{'id':_0x69837b[_0xf3a0('0xc3')]['id']}})[_0xf3a0('0x2b')](handleEntityNotFound(_0x2d3397,null))[_0xf3a0('0x2b')](function(_0x2b23e4){if(_0x2b23e4){_0x279384[_0xf3a0('0x45')]=_[_0xf3a0('0x38')](db[_0xf3a0('0xba')][_0xf3a0('0xd0')]);_0x279384[_0xf3a0('0x42')]=_[_0xf3a0('0x38')](_0x69837b['query']);_0x279384['filters']=_['intersection'](_0x279384[_0xf3a0('0x45')],_0x279384[_0xf3a0('0x42')]);_0x3ccff7['attributes']=_['intersection'](_0x279384[_0xf3a0('0x45')],qs[_0xf3a0('0x47')](_0x69837b['query'][_0xf3a0('0x47')]));_0x3ccff7[_0xf3a0('0x46')]=_0x3ccff7[_0xf3a0('0x46')][_0xf3a0('0x39')]?_0x3ccff7[_0xf3a0('0x46')]:_0x279384[_0xf3a0('0x45')];if(!_0x69837b[_0xf3a0('0x42')]['hasOwnProperty'](_0xf3a0('0x48'))){_0x3ccff7[_0xf3a0('0x23')]=qs[_0xf3a0('0x23')](_0x69837b['query'][_0xf3a0('0x23')]);_0x3ccff7[_0xf3a0('0x20')]=qs[_0xf3a0('0x20')](_0x69837b[_0xf3a0('0x42')]['offset']);}_0x3ccff7[_0xf3a0('0x49')]=qs[_0xf3a0('0x4a')](_0x69837b[_0xf3a0('0x42')][_0xf3a0('0x4a')]);_0x3ccff7[_0xf3a0('0x56')]=qs[_0xf3a0('0x43')](_['pick'](_0x69837b[_0xf3a0('0x42')],_0x279384[_0xf3a0('0x43')]));_0x3ccff7[_0xf3a0('0x56')][_0xf3a0('0xd8')]=_0x2b23e4['id'];if(_0x69837b[_0xf3a0('0x42')][_0xf3a0('0x6c')]){_0x3ccff7[_0xf3a0('0x56')]=_[_0xf3a0('0x30')](_0x3ccff7[_0xf3a0('0x56')],{'$or':_['map'](_0x3ccff7[_0xf3a0('0x46')],function(_0x860fa7){var _0x2b8d10={};_0x2b8d10[_0x860fa7]={'$like':'%'+_0x69837b[_0xf3a0('0x42')][_0xf3a0('0x6c')]+'%'};return _0x2b8d10;})});}_0x3ccff7=_['merge']({},_0x3ccff7,_0x69837b['options']);return db[_0xf3a0('0xba')][_0xf3a0('0x22')]({'where':_0x3ccff7[_0xf3a0('0x56')]})[_0xf3a0('0x2b')](function(_0x924469){_0xef800[_0xf3a0('0x22')]=_0x924469;if(_0x69837b[_0xf3a0('0x42')][_0xf3a0('0xd1')]){_0x3ccff7[_0xf3a0('0xd2')]=[{'all':!![]}];}return db[_0xf3a0('0xba')][_0xf3a0('0x9e')](_0x3ccff7);})['then'](function(_0x2e3c24){_0xef800[_0xf3a0('0x98')]=_0x2e3c24;return _0xef800;});}})[_0xf3a0('0x2b')](respondWithFilteredResult(_0x2d3397,_0x3ccff7))['catch'](handleError(_0x2d3397,null));};exports[_0xf3a0('0xd9')]=function(_0x47db3c,_0x43c272,_0x440665){try{if(!_0x47db3c[_0xf3a0('0x31')][_0xf3a0('0x70')]){throw new Error(_0xf3a0('0xda'));}if(!_0x47db3c[_0xf3a0('0x31')][_0xf3a0('0xdb')]){throw new Error('No\x20association\x20keys\x20specified!');}if(!_0x47db3c[_0xf3a0('0x31')][_0xf3a0('0xdc')]){throw new Error(_0xf3a0('0xdd'));}if(!_0x47db3c[_0xf3a0('0x31')][_0xf3a0('0xde')]){throw new Error(_0xf3a0('0xdf'));}var _0x48ecff=_0x47db3c[_0xf3a0('0x31')][_0xf3a0('0xdb')][_0xf3a0('0x77')](',');var _0x38e918=_0x47db3c[_0xf3a0('0x31')]['binding_values'][_0xf3a0('0x77')](',');if(!_0x48ecff[_0xf3a0('0x39')]||!_0x38e918[_0xf3a0('0x39')]||_0x48ecff['length']!==_0x38e918[_0xf3a0('0x39')]){throw new Error(_0xf3a0('0xe0'));}_0x47db3c[_0xf3a0('0x31')][_0xf3a0('0x47')]=_[_0xf3a0('0xe1')](_0x48ecff,_0x38e918);if(!_0x47db3c[_0xf3a0('0x31')]['fields'][_0xf3a0('0xca')]){throw new Error(_0xf3a0('0xe2'));}if(!_0x47db3c[_0xf3a0('0x31')][_0xf3a0('0x47')][_0xf3a0('0xe3')]){throw new Error(_0xf3a0('0xe4'));}var _0x121e2e=path[_0xf3a0('0xa3')](config['root'],_0xf3a0('0xe5'),_0x47db3c[_0xf3a0('0xe6')]['filename']);fs[_0xf3a0('0xe7')](_0x121e2e,parseInt(_0xf3a0('0xe8'),0x8));var _0x494378=require('child_process')[_0xf3a0('0xe9')](path[_0xf3a0('0xa3')](__dirname,_0xf3a0('0xea')),[_0x121e2e,_0x47db3c['body'][_0xf3a0('0xdb')],_0x47db3c['body'][_0xf3a0('0xdc')],_0x47db3c[_0xf3a0('0x31')][_0xf3a0('0x70')],_0x47db3c[_0xf3a0('0x31')][_0xf3a0('0xeb')],_0x47db3c[_0xf3a0('0x31')]['duplicates'],_0x47db3c[_0xf3a0('0x31')]['socket_timestamp']]);return _0x43c272[_0xf3a0('0x1e')](0xc8)[_0xf3a0('0x26')]({'message':_0xf3a0('0xec'),'pid':_0x494378[_0xf3a0('0xed')]});}catch(_0x12188a){return _0x43c272[_0xf3a0('0x1e')](0x1f4)[_0xf3a0('0x2f')](_0x12188a);}};exports[_0xf3a0('0xee')]=function(_0x3d9e36,_0x15d1e3,_0x20dd42){var _0x795fd4=fs['createReadStream'](_0x3d9e36[_0xf3a0('0xe6')][_0xf3a0('0x5')]);Papa[_0xf3a0('0xef')](_0x795fd4,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x48d017){return _0x15d1e3['status'](0xc8)[_0xf3a0('0x26')]({'file':_0x3d9e36[_0xf3a0('0xe6')],'fields':_0x48d017[_0xf3a0('0xf0')][_0xf3a0('0x47')]});}});};exports['import']=function(_0x12673e,_0x59343b,_0x5b96b7){return db[_0xf3a0('0x62')][_0xf3a0('0x9e')]({'raw':!![],'attributes':['id'],'where':{'role':_0xf3a0('0x34')}})[_0xf3a0('0x2b')](function(_0x553534){var _0x505785=![];if(!_0x12673e[_0xf3a0('0x31')][_0xf3a0('0x70')]){throw new Error('No\x20ListId\x20specified');}if(!_0x12673e['body'][_0xf3a0('0xf1')][_0xf3a0('0xca')]){throw new Error(_0xf3a0('0xe2'));}if(!_0x12673e[_0xf3a0('0x31')][_0xf3a0('0xf1')]['firstName']){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x12673e[_0xf3a0('0x31')][_0xf3a0('0xde')]){throw new Error(_0xf3a0('0xdf'));}var _0x2db4a9=require(_0xf3a0('0xf2'))[_0xf3a0('0xe9')](path['join'](__dirname,'../../components/import/cm/csv2'),[_0x12673e[_0xf3a0('0xc3')]['id'],JSON[_0xf3a0('0xf3')](_0x12673e[_0xf3a0('0x31')]),JSON[_0xf3a0('0xf3')](_0x553534)]);_0x2db4a9['on'](_0xf3a0('0x33'),function(_0x4febcd){_0x505785=!![];return _0x59343b[_0xf3a0('0x1e')](0xc8)[_0xf3a0('0x26')]({'message':_0xf3a0('0xf4'),'pid':_0x2db4a9[_0xf3a0('0xed')]});});_0x2db4a9['on'](_0xf3a0('0xf5'),function(_0x288598){if(_0x288598&&!_0x505785){return _0x59343b[_0xf3a0('0x1e')](0x1f4)[_0xf3a0('0x26')]({'message':'error\x20child\x20process','pid':_0x2db4a9[_0xf3a0('0xed')]});}});})[_0xf3a0('0x9a')](handleError(_0x59343b,null));};exports[_0xf3a0('0xf6')]=function(_0x4012f0,_0x20efec){var _0x4a75c7=[_0xf3a0('0xf7'),_0xf3a0('0xf8'),'sms',_0xf3a0('0xf9'),'fax',_0xf3a0('0xfa'),_0xf3a0('0xfb')];var _0x35e92f={'offset':0x0,'order':qs[_0xf3a0('0x4a')](_0xf3a0('0xfc'))},_0x45c50f={'count':0x0,'rows':[]};Promise['resolve']()[_0xf3a0('0x2b')](function(){if(_0x4012f0['query']['channel']){if(!_['includes'](_0x4a75c7,_0x4012f0[_0xf3a0('0x42')][_0xf3a0('0xfd')][_0xf3a0('0xfe')]())){throw new Error(_0xf3a0('0xff'));}_0x4a75c7=[_0x4012f0['query']['channel'][_0xf3a0('0xfe')]()];}if(_0x4012f0[_0xf3a0('0x42')][_0xf3a0('0x100')]){try{var _0x33092f=JSON[_0xf3a0('0xef')](_0x4012f0[_0xf3a0('0x42')]['range']);if(!moment(_0x33092f[_0xf3a0('0x4f')])['isValid']()){throw new Error(_0xf3a0('0x101'));}if(!moment(_0x33092f['to'])['isValid']()){throw new Error(_0xf3a0('0x102'));}}catch(_0x50b54b){throw new Error(_0xf3a0('0x103'));}}if(!_0x4012f0[_0xf3a0('0x42')][_0xf3a0('0x6b')]('nolimit')){_0x35e92f[_0xf3a0('0x23')]=qs[_0xf3a0('0x23')](_0x4012f0[_0xf3a0('0x42')][_0xf3a0('0x23')]||0xa);_0x35e92f[_0xf3a0('0x20')]=qs[_0xf3a0('0x20')](_0x4012f0['query'][_0xf3a0('0x20')]);}var _0x46b7d8=_0x4a75c7['map'](function(_0x792272){if(_0x792272===_0xf3a0('0xfb')){var _0x2fa728={'attributes':['id',_0xf3a0('0x104'),_0xf3a0('0x41'),_0xf3a0('0x105'),'destination',_0xf3a0('0x106'),_0xf3a0('0x107'),_0xf3a0('0x108'),_0xf3a0('0x109'),_0xf3a0('0x10a'),'createdAt',_0xf3a0('0x10b'),_0xf3a0('0x10c'),_0xf3a0('0x10d'),_0xf3a0('0x10e')],'where':{'ContactId':_0x4012f0[_0xf3a0('0xc3')]['id']},'include':[{'model':db[_0xf3a0('0x62')],'as':'User','attributes':['id',_0xf3a0('0x2e'),'fullname',_0xf3a0('0x9f')]}],'order':[[_0xf3a0('0x10f'),'DESC']]};if(_0x4012f0[_0xf3a0('0x42')][_0xf3a0('0x100')]){_0x2fa728[_0xf3a0('0x56')][_0xf3a0('0x10f')]={'$gte':_0x33092f['from'],'$lte':_0x33092f['to']};}return db[_0xf3a0('0xb5')][_0xf3a0('0x110')](_0x2fa728)[_0xf3a0('0x2b')](function(_0x158871){_0x45c50f[_0xf3a0('0x22')]+=_0x158871[_0xf3a0('0x22')];return _[_0xf3a0('0x5e')](_0x158871[_0xf3a0('0x98')],function(_0x174488){var _0x429250=_0x174488[_0xf3a0('0xa1')]({'plain':!![]});_0x429250[_0xf3a0('0xfd')]=_0x792272;if(_0x429250['User']){_0x429250[_0xf3a0('0x62')]={'id':_0x429250[_0xf3a0('0x62')]['id'],'name':_0x429250[_0xf3a0('0x62')][_0xf3a0('0x2e')],'fullname':_0x429250[_0xf3a0('0x62')][_0xf3a0('0x111')],'alias':_0x429250[_0xf3a0('0x62')][_0xf3a0('0x9f')]};}return _0x429250;});});}else{var _0x13c859=_[_0xf3a0('0x112')](_0x792272)+(_0x792272===_0xf3a0('0xf8')?'Website':_0xf3a0('0x113'));var _0x536f1e={'attributes':['id',_0xf3a0('0x114'),_0xf3a0('0x115'),_0xf3a0('0x10f'),'note',_0xf3a0('0x116'),'secondDisposition',_0xf3a0('0x117'),_0xf3a0('0x10e'),_0x13c859+'Id'],'where':{'ContactId':_0x4012f0[_0xf3a0('0xc3')]['id']},'include':[{'model':db[_0x13c859],'as':'Account','attributes':['id',_0xf3a0('0x2e'),'key']},{'model':db['User'],'as':_0xf3a0('0x118'),'attributes':['id',_0xf3a0('0x2e'),'fullname']},{'model':db[_0xf3a0('0x5d')],'as':_0xf3a0('0x97'),'attributes':['id',_0xf3a0('0x2e'),_0xf3a0('0x4e')],'through':{'attributes':[]}}],'order':[[_0xf3a0('0x10f'),'DESC']]};if(_0x4012f0[_0xf3a0('0x42')][_0xf3a0('0x100')]){_0x536f1e[_0xf3a0('0x56')][_0xf3a0('0x10f')]={'$gte':_0x33092f[_0xf3a0('0x4f')],'$lte':_0x33092f['to']};}switch(_0x792272){case _0xf3a0('0xf8'):_0x536f1e[_0xf3a0('0x46')]['push']('browserName',_0xf3a0('0x119'),_0xf3a0('0x11a'),_0xf3a0('0x11b'),_0xf3a0('0x11c'),_0xf3a0('0x11d'),_0xf3a0('0x11e'),_0xf3a0('0x11f'),_0xf3a0('0x120'));break;case'mail':_0x536f1e['attributes'][_0xf3a0('0x3b')](_0xf3a0('0x121'),_0xf3a0('0x122'));break;case _0xf3a0('0xf9'):_0x536f1e[_0xf3a0('0x46')][_0xf3a0('0x3b')](_0xf3a0('0x123'),_0xf3a0('0x124'));break;}return db[_[_0xf3a0('0x112')](_0x792272)+_0xf3a0('0x125')][_0xf3a0('0x110')](_0x536f1e)[_0xf3a0('0x2b')](function(_0x9bf8b0){_0x45c50f[_0xf3a0('0x22')]+=_0x9bf8b0['count'];return _[_0xf3a0('0x5e')](_0x9bf8b0[_0xf3a0('0x98')],function(_0x45e627){var _0x36351d=_0x45e627[_0xf3a0('0xa1')]({'plain':!![]});_0x36351d[_0xf3a0('0xfd')]=_0x792272;if(_0x36351d[_0xf3a0('0x118')]){_0x36351d['Owner']={'id':_0x36351d[_0xf3a0('0x118')]['id'],'name':_0x36351d[_0xf3a0('0x118')]['name'],'fullname':_0x36351d[_0xf3a0('0x118')][_0xf3a0('0x111')]};}return _0x36351d;});});}});return Promise['all'](_0x46b7d8);})[_0xf3a0('0x2b')](function(_0x300b2d){return _(_0x300b2d)[_0xf3a0('0x126')]()[_0xf3a0('0x127')]('createdAt')[_0xf3a0('0x128')]()[_0xf3a0('0x65')]();})[_0xf3a0('0x2b')](function(_0x20aa92){_0x45c50f[_0xf3a0('0x98')]=_0x35e92f[_0xf3a0('0x23')]?_0x20aa92[_0xf3a0('0x129')](_0x35e92f[_0xf3a0('0x20')],_0x35e92f[_0xf3a0('0x20')]+_0x35e92f[_0xf3a0('0x23')]):_0x20aa92;return _0x45c50f;})['then'](respondWithFilteredResult(_0x20efec,_0x35e92f))[_0xf3a0('0x9a')](handleError(_0x20efec,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff