// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xa727=['c.lastName','c.phone','c.fax','c.email','c.ListId','c.createdAt','c.deletedAt','c.CompanyId','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','Tags','rows','catch','describe','tags','columnName','analytics','findAll','displayName','alias','custom','values','body','get','isArray','join','info','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','ChatMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','CmHopperFinal','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappMessage','WhatsappQueueReport','bulkCreate','each','duplicates','$or','spread','show','params','$and','omit','format','cf_%d','table','cm_contacts','setFields','id\x20=\x20?','text','phone','getTags','rawAttributes','pick','options','setTags','ids','getHoppers','CmHopper','ContactId','includeAll','include','getHopperHistories','getHopperFinals','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','root','server/files/tmp','file','filename','chmodSync','0777','child_process','fork','../../components/import/cm/csv','CompanyId','socket_timestamp','File\x20uploaded\x20correctly!','pid','upload','createReadStream','meta','import','agent','binding','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','exit','error\x20child\x20process','getJourney','mail','sms','openchannel','fax','whatsapp','voice','channel','toLowerCase','parse','range','Invalid\x20date\x20for\x20range\x20from\x20filter','isValid','Invalid\x20date\x20for\x20range\x20to\x20filter','Invalid\x20createdAt\x20filter','uniqueid','destination','callerid','starttime','endtime','duration','note','createdAt','userDisposition','userSecondDisposition','userThirdDisposition','UserId','DESC','fullname','chat','Website','closed','closedAt','disposition','thirdDisposition','Account','Owner','customerIp','customerPort','osName','ratingType','ratingValue','referer','subject','externalUrl','threadId','startCase','Interaction','findAndCountAll','flatten','reverse','slice','moment','bluebird','util','path','lodash','squel','ioredis','../../components/parsers/advancedSearch','../../config/logger','../../mysqldb','redis','localhost','socket.io-emitter','./cmContact.socket','register','status','json','offset','undefined','count','set','update','then','destroy','end','error','stack','name','send','index','CmContact','keys','length','startsWith','cf_','push','CmCustomField','findOne','trimStart','all','fieldType','type','model','query','filters','attributes','intersection','fields','hasOwnProperty','nolimit','limit','order','sort','where','field','color','from','left_join','cm_user_has_contacts','cm_contact_has_tags','t.id\x20=\x20ct.TagId','c.deletedAt\x20IS\x20NULL','expr','search','parseSearch','conditions','find','Tag','value','split','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','and','uc.UserId\x20=\x20?','dateOfBirth','datetime','castTo','DATE','buildExpression','start','map','filter','isNil','Contact','isEmpty','forEach','ListId','c.ListId\x20IN\x20?','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','tag','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?','isEmail','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','group','c.id','Sequelize','QueryTypes','SELECT','clone','having','t.id\x20IN\x20?','resolve','user','role','some','User','getLists','c.ListId\x20IS\x20NULL','sequelize','toString','keyBy','merge','c.firstName'];(function(_0x122ef9,_0x451d2a){var _0x42fba0=function(_0x17c9d3){while(--_0x17c9d3){_0x122ef9['push'](_0x122ef9['shift']());}};_0x42fba0(++_0x451d2a);}(_0xa727,0x1d0));var _0x7a72=function(_0x55e52a,_0x5db621){_0x55e52a=_0x55e52a-0x0;var _0x4b7634=_0xa727[_0x55e52a];return _0x4b7634;};'use strict';var moment=require(_0x7a72('0x0'));var BPromise=require(_0x7a72('0x1'));var util=require(_0x7a72('0x2'));var path=require(_0x7a72('0x3'));var fs=require('fs');var _=require(_0x7a72('0x4'));var squel=require(_0x7a72('0x5'));var Papa=require('papaparse');var Redis=require(_0x7a72('0x6'));var qs=require('../../components/parsers/qs');var as=require(_0x7a72('0x7'));var logger=require(_0x7a72('0x8'))('api');var config=require('../../config/environment');var db=require(_0x7a72('0x9'))['db'];config[_0x7a72('0xa')]=_['defaults'](config[_0x7a72('0xa')],{'host':_0x7a72('0xb'),'port':0x18eb});var socket=require(_0x7a72('0xc'))(new Redis(config[_0x7a72('0xa')]));require(_0x7a72('0xd'))[_0x7a72('0xe')](socket);function respondWithResult(_0x59126b,_0x572223){_0x572223=_0x572223||0xc8;return function(_0x222f0e){if(_0x222f0e){return _0x59126b[_0x7a72('0xf')](_0x572223)[_0x7a72('0x10')](_0x222f0e);}};}function respondWithFilteredResult(_0x2f84c3,_0x3bb99a){return function(_0x4980ec){if(_0x4980ec){var _0x15e1ff=typeof _0x3bb99a[_0x7a72('0x11')]===_0x7a72('0x12')&&typeof _0x3bb99a['limit']===_0x7a72('0x12');var _0x40d13c=_0x4980ec[_0x7a72('0x13')];var _0x1c720b=_0x15e1ff?0x0:_0x3bb99a[_0x7a72('0x11')];var _0x1d1e6c=_0x15e1ff?_0x4980ec['count']:_0x3bb99a[_0x7a72('0x11')]+_0x3bb99a['limit'];var _0x446987;if(_0x1d1e6c>=_0x40d13c){_0x1d1e6c=_0x40d13c;_0x446987=0xc8;}else{_0x446987=0xce;}_0x2f84c3[_0x7a72('0xf')](_0x446987);return _0x2f84c3[_0x7a72('0x14')]('Content-Range',_0x1c720b+'-'+_0x1d1e6c+'/'+_0x40d13c)[_0x7a72('0x10')](_0x4980ec);}return null;};}function saveUpdates(_0x445419){return function(_0xe8d651){if(_0xe8d651){return _0xe8d651[_0x7a72('0x15')](_0x445419)[_0x7a72('0x16')](function(_0x1bdf54){return _0x1bdf54;});}return null;};}function removeEntity(_0x49b85c){return function(_0x3763eb){if(_0x3763eb){return _0x3763eb[_0x7a72('0x17')]()[_0x7a72('0x16')](function(){_0x49b85c[_0x7a72('0xf')](0xcc)[_0x7a72('0x18')]();});}};}function handleEntityNotFound(_0x591450){return function(_0x2ad5dc){if(!_0x2ad5dc){_0x591450['sendStatus'](0x194);}return _0x2ad5dc;};}function handleError(_0x3bf191,_0x36fff2){_0x36fff2=_0x36fff2||0x1f4;return function(_0x357098){logger[_0x7a72('0x19')](_0x357098[_0x7a72('0x1a')]);if(_0x357098[_0x7a72('0x1b')]){delete _0x357098[_0x7a72('0x1b')];}_0x3bf191['status'](_0x36fff2)[_0x7a72('0x1c')](_0x357098);};}exports[_0x7a72('0x1d')]=function(_0x1d2ef9,_0x2804ac){var _0x9342f2={},_0x3b5454={},_0x69d537={'count':0x0,'rows':[]};return db[_0x7a72('0x1e')]['describe']()['then'](function(_0x82e37){var _0x2f040c=[];for(var _0x43bedc=0x0;_0x43bedc<Object[_0x7a72('0x1f')](_0x82e37)[_0x7a72('0x20')];_0x43bedc++){var _0xcf610=Object[_0x7a72('0x1f')](_0x82e37)[_0x43bedc];if(_[_0x7a72('0x21')](_0xcf610,_0x7a72('0x22'))){_0x2f040c[_0x7a72('0x23')](db[_0x7a72('0x24')][_0x7a72('0x25')]({'where':{'id':_[_0x7a72('0x26')](_0xcf610,_0x7a72('0x22'))},'raw':!![]}));}}return BPromise[_0x7a72('0x27')](_0x2f040c)[_0x7a72('0x16')](function(_0x42ef59){for(var _0x49838e=0x0;_0x49838e<_0x42ef59[_0x7a72('0x20')];_0x49838e++){if(_0x42ef59[_0x49838e]){var _0x1d39eb='cf_'+_0x42ef59[_0x49838e]['id'];var _0x8d7a74=_0x82e37[_0x1d39eb];_0x8d7a74[_0x7a72('0x28')]=_0x42ef59[_0x49838e][_0x7a72('0x29')];}}return _0x82e37;});})[_0x7a72('0x16')](function(_0x40ee1c){_0x3b5454[_0x7a72('0x2a')]=_[_0x7a72('0x1f')](_0x40ee1c);_0x3b5454[_0x7a72('0x2b')]=_[_0x7a72('0x1f')](_0x1d2ef9[_0x7a72('0x2b')]);_0x3b5454[_0x7a72('0x2c')]=_['intersection'](_0x3b5454[_0x7a72('0x2a')],_0x3b5454['query']);_0x9342f2[_0x7a72('0x2d')]=_[_0x7a72('0x2e')](_0x3b5454[_0x7a72('0x2a')],qs['fields'](_0x1d2ef9[_0x7a72('0x2b')][_0x7a72('0x2f')]));_0x9342f2[_0x7a72('0x2d')]=_0x9342f2['attributes']['length']?_0x9342f2[_0x7a72('0x2d')]:_0x3b5454[_0x7a72('0x2a')];if(!_0x1d2ef9[_0x7a72('0x2b')][_0x7a72('0x30')](_0x7a72('0x31'))){_0x9342f2[_0x7a72('0x32')]=qs[_0x7a72('0x32')](_0x1d2ef9['query']['limit']);_0x9342f2[_0x7a72('0x11')]=qs[_0x7a72('0x11')](_0x1d2ef9['query'][_0x7a72('0x11')]);}_0x9342f2[_0x7a72('0x33')]=qs[_0x7a72('0x34')](_0x1d2ef9[_0x7a72('0x2b')][_0x7a72('0x34')]);_0x9342f2[_0x7a72('0x35')]=qs[_0x7a72('0x2c')](_['pick'](_0x1d2ef9['query'],_0x3b5454[_0x7a72('0x2c')]),_0x40ee1c);var _0x52fa7b=[];var _0x39c36c=squel['select']()['field']('id')[_0x7a72('0x36')](_0x7a72('0x1b'))['field'](_0x7a72('0x37'))['from']('tools_tags');var _0x208be4=squel['select']()[_0x7a72('0x38')]('cm_contacts','c')[_0x7a72('0x39')](_0x7a72('0x3a'),'uc','uc.CmContactId\x20=\x20c.id')[_0x7a72('0x39')](_0x7a72('0x3b'),'ct','ct.CmContactId\x20=\x20c.id')[_0x7a72('0x39')]('tools_tags','t',_0x7a72('0x3c'))[_0x7a72('0x35')](_0x7a72('0x3d'));var _0x4a6ff3=squel[_0x7a72('0x3e')]();var _0x68221f=[];var _0x154bc6=squel['expr']();var _0x10b798;if(_0x1d2ef9[_0x7a72('0x2b')][_0x7a72('0x3f')]){_0x10b798=as[_0x7a72('0x40')](_0x1d2ef9['query']['search']);var _0x2fe500=_0x10b798['sqlOperator'];for(var _0x128f79=0x0;_0x128f79<_0x10b798[_0x7a72('0x41')][_0x7a72('0x20')];_0x128f79++){var _0x4fe049=_0x10b798[_0x7a72('0x41')][_0x128f79];var _0x520b78='c';var _0x3dc70d=_(_0x40ee1c)[_0x7a72('0x1f')]()[_0x7a72('0x42')](function(_0xf9fac4){return _0xf9fac4===_0x4fe049[_0x7a72('0x36')];});if(_0x3dc70d)_0x3dc70d=_0x40ee1c[_0x4fe049[_0x7a72('0x36')]];if(!_0x3dc70d){if(_0x4fe049[_0x7a72('0x36')]===_0x7a72('0x43')){var _0x4425e1=_0x4fe049[_0x7a72('0x44')][_0x7a72('0x45')](',')['map'](function(_0x2739ce){return Number(_0x2739ce);});_0x4425e1['forEach'](function(_0x7151d2){_0x154bc6['or'](_0x7a72('0x46'),'%,'+_0x7151d2+',%');});_0x68221f=_[_0x7a72('0x47')](_0x68221f,_0x4425e1);}else if(_0x4fe049[_0x7a72('0x36')]==='User'){_0x4a6ff3[_0x7a72('0x48')](_0x7a72('0x49'),_0x4fe049[_0x7a72('0x44')]);}}else{if(_0x4fe049[_0x7a72('0x36')]===_0x7a72('0x4a')||_0x3dc70d[_0x7a72('0x28')]===_0x7a72('0x4b'))_0x4fe049[_0x7a72('0x4c')]=_0x7a72('0x4d');var _0x5c5a32=as[_0x7a72('0x4e')](_0x520b78,_0x3dc70d[_0x7a72('0x29')],_0x4fe049);_0x4a6ff3[_0x2fe500](_0x5c5a32['text'],_0x5c5a32[_0x7a72('0x44')][_0x7a72('0x4f')],_0x5c5a32[_0x7a72('0x44')][_0x7a72('0x18')]);}}}else{var _0x33b779=_(Object[_0x7a72('0x1f')](_0x1d2ef9[_0x7a72('0x2b')]))[_0x7a72('0x50')](function(_0x2b1c65){return _0x40ee1c['hasOwnProperty'](_0x2b1c65)?_0x2b1c65:undefined;})[_0x7a72('0x51')](function(_0x4b4657){return!_[_0x7a72('0x52')](_0x4b4657);})[_0x7a72('0x44')]();if(_0x1d2ef9['query']['Contact'])_0x33b779[_0x7a72('0x23')](_0x7a72('0x53'));if(!_[_0x7a72('0x54')](_0x33b779)){_0x33b779[_0x7a72('0x55')](function(_0x1d137d){if(_0x1d137d===_0x7a72('0x56')){_0x208be4['where'](_0x7a72('0x57'),[][_0x7a72('0x58')](_0x1d2ef9[_0x7a72('0x2b')][_0x1d137d]));}else if(_0x1d137d===_0x7a72('0x53')){var _0x345406='%'+_0x1d2ef9[_0x7a72('0x2b')][_0x1d137d]+'%';_0x208be4[_0x7a72('0x35')](_0x7a72('0x59'),_0x345406);}else{_0x208be4['where']('c.'+_0x1d137d+_0x7a72('0x5a'),_0x1d2ef9['query'][_0x1d137d]);}});}if(_0x1d2ef9[_0x7a72('0x2b')][_0x7a72('0x5b')]){_0x68221f=_['isArray'](_0x1d2ef9[_0x7a72('0x2b')][_0x7a72('0x5b')])?_0x1d2ef9[_0x7a72('0x2b')][_0x7a72('0x5b')]:new Array(_0x1d2ef9[_0x7a72('0x2b')][_0x7a72('0x5b')]);_0x68221f['forEach'](function(_0xd71797){_0x154bc6['or'](_0x7a72('0x46'),'%,'+_0xd71797+',%');});}if(_0x1d2ef9[_0x7a72('0x2b')][_0x7a72('0x51')]){var _0x3af4a3=_0x1d2ef9['query'][_0x7a72('0x51')][_0x7a72('0x5c')]('\x5c','\x5c\x5c')[_0x7a72('0x5c')](/'/g,'\x27\x27');if(_0x3af4a3[_0x7a72('0x45')]('\x20')[_0x7a72('0x20')]>0x1){_0x4a6ff3['or'](_0x7a72('0x5d'),qs[_0x7a72('0x5e')](_0x3af4a3),null);}else{if(qs[_0x7a72('0x5f')](_0x3af4a3)){_0x4a6ff3['or'](_0x7a72('0x60'),_0x3af4a3+'%');_0x4a6ff3['or'](_0x7a72('0x61'),_0x3af4a3+'%');_0x4a6ff3['or']('c.mobile\x20LIKE\x20?',_0x3af4a3+'%');_0x4a6ff3['or']('c.fax\x20LIKE\x20?',_0x3af4a3+'%');}else if(qs[_0x7a72('0x62')](_0x3af4a3)){_0x4a6ff3['or'](_0x7a72('0x63'),_0x3af4a3+'%');}else{_0x4a6ff3['or'](_0x7a72('0x64'),'%'+_0x3af4a3+'%');_0x4a6ff3['or'](_0x7a72('0x65'),'%'+_0x3af4a3+'%');_0x4a6ff3['or']('c.email\x20LIKE\x20?','%'+_0x3af4a3+'%');}}}}_0x208be4[_0x7a72('0x35')](_0x4a6ff3);_0x208be4[_0x7a72('0x66')](_0x7a72('0x67'));var _0x224857={'type':db[_0x7a72('0x68')][_0x7a72('0x69')][_0x7a72('0x6a')],'raw':!![]};var _0x50439f=_0x208be4[_0x7a72('0x6b')]()[_0x7a72('0x36')](_0x7a72('0x67'));if(_0x9342f2[_0x7a72('0x33')]){_0x9342f2[_0x7a72('0x33')][_0x7a72('0x55')](function(_0x441949){_0x208be4[_0x7a72('0x33')]('c.'+_0x441949[0x0],_0x441949[0x1]==='DESC'?![]:!![]);});}if(!_['isEmpty'](_0x68221f)){_0x208be4[_0x7a72('0x6c')](_0x154bc6);_0x50439f[_0x7a72('0x35')](_0x7a72('0x6d'),_0x68221f);}BPromise[_0x7a72('0x6e')]()[_0x7a72('0x16')](function(){if(!_0x10b798)return;if(_0x1d2ef9[_0x7a72('0x6f')][_0x7a72('0x70')]!=='agent')return;if(!_[_0x7a72('0x71')](_0x10b798[_0x7a72('0x41')],[_0x7a72('0x36'),_0x7a72('0x72')])){return _0x1d2ef9[_0x7a72('0x6f')][_0x7a72('0x73')]({'attributes':['id'],'raw':!![]})['then'](function(_0x59e7d0){if(_['isEmpty'](_0x59e7d0)){_0x50439f[_0x7a72('0x35')](_0x7a72('0x74'));_0x208be4[_0x7a72('0x35')](_0x7a72('0x74'));}else{_0x50439f[_0x7a72('0x35')](_0x7a72('0x57'),_[_0x7a72('0x50')](_0x59e7d0,'id'));_0x208be4['where'](_0x7a72('0x57'),_[_0x7a72('0x50')](_0x59e7d0,'id'));}});}})[_0x7a72('0x16')](function(){if(_0x1d2ef9['user'][_0x7a72('0x70')]==='agent'&&!_0x10b798&&!_0x1d2ef9[_0x7a72('0x2b')]['ListId'])return[];return db[_0x7a72('0x75')][_0x7a72('0x2b')](_0x50439f[_0x7a72('0x76')](),_0x224857);})[_0x7a72('0x16')](function(_0x4e0588){_0x69d537[_0x7a72('0x13')]=_0x4e0588[_0x7a72('0x20')];if(_0x69d537[_0x7a72('0x13')]===0x0)return[];return db[_0x7a72('0x75')][_0x7a72('0x2b')](_0x39c36c[_0x7a72('0x76')](),_0x224857)[_0x7a72('0x16')](function(_0x355b53){_0x52fa7b=_[_0x7a72('0x77')](_0x355b53,'id');_0x224857=_[_0x7a72('0x78')](_0x224857,{'model':db[_0x7a72('0x1e')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x1d2ef9[_0x7a72('0x2b')][_0x7a72('0x2f')]){_0x9342f2['attributes'][_0x7a72('0x55')](function(_0x2d0cb2){_0x208be4[_0x7a72('0x36')]('c.'+_0x2d0cb2);});}else{_0x208be4[_0x7a72('0x36')](_0x7a72('0x67'));_0x208be4[_0x7a72('0x36')](_0x7a72('0x79'));_0x208be4[_0x7a72('0x36')](_0x7a72('0x7a'));_0x208be4['field'](_0x7a72('0x7b'));_0x208be4[_0x7a72('0x36')]('c.mobile');_0x208be4['field'](_0x7a72('0x7c'));_0x208be4[_0x7a72('0x36')](_0x7a72('0x7d'));_0x208be4[_0x7a72('0x36')](_0x7a72('0x7e'));_0x208be4[_0x7a72('0x36')](_0x7a72('0x7f'));_0x208be4[_0x7a72('0x36')](_0x7a72('0x80'));_0x208be4[_0x7a72('0x36')](_0x7a72('0x81'));_0x208be4['field'](_0x7a72('0x82'),_0x7a72('0x83'));}if(_0x9342f2['limit'])_0x208be4[_0x7a72('0x32')](_0x9342f2[_0x7a72('0x32')]);if(_0x9342f2[_0x7a72('0x11')])_0x208be4[_0x7a72('0x11')](_0x9342f2[_0x7a72('0x11')]);return db[_0x7a72('0x75')][_0x7a72('0x2b')](_0x208be4[_0x7a72('0x76')](),_0x224857);});})[_0x7a72('0x16')](function(_0x56b56e){_0x56b56e['forEach'](function(_0x590f43){if(_0x590f43[_0x7a72('0x83')]){_0x590f43[_0x7a72('0x84')]=[];_0x590f43[_0x7a72('0x83')][_0x7a72('0x45')](',')[_0x7a72('0x55')](function(_0x1557c3){_0x590f43[_0x7a72('0x84')][_0x7a72('0x23')](_0x52fa7b[_0x1557c3]);});}delete _0x590f43[_0x7a72('0x83')];});_0x69d537[_0x7a72('0x85')]=_0x56b56e;return _0x69d537;})['then'](respondWithFilteredResult(_0x2804ac,_0x9342f2));})[_0x7a72('0x86')](handleError(_0x2804ac,null));};exports[_0x7a72('0x17')]=function(_0x2c0747,_0x7fb379){return db['CmContact'][_0x7a72('0x42')]({'where':{'id':_0x2c0747['params']['id']}})[_0x7a72('0x16')](handleEntityNotFound(_0x7fb379,null))[_0x7a72('0x16')](removeEntity(_0x7fb379,null))[_0x7a72('0x86')](handleError(_0x7fb379,null));};exports[_0x7a72('0x87')]=function(_0x20217d,_0x5482b9){return db[_0x7a72('0x1e')][_0x7a72('0x87')]()[_0x7a72('0x16')](function(_0x247e70){delete _0x247e70[_0x7a72('0x88')];for(var _0x12d4b5=0x0;_0x12d4b5<Object[_0x7a72('0x1f')](_0x247e70)[_0x7a72('0x20')];_0x12d4b5++){var _0x3505be=Object['keys'](_0x247e70)[_0x12d4b5];if(!_[_0x7a72('0x21')](_0x3505be,_0x7a72('0x22'))){_0x247e70[_0x3505be][_0x7a72('0x89')]=_0x3505be;_0x247e70[_0x3505be]['displayName']=_0x3505be;}}return _0x247e70;})[_0x7a72('0x16')](function(_0x3a4e3c){var _0x56aae3={'where':Boolean(_0x20217d[_0x7a72('0x2b')][_0x7a72('0x8a')])===!![]?undefined:{'$or':[{'ListId':_0x20217d[_0x7a72('0x2b')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x7a72('0x24')][_0x7a72('0x8b')](_0x56aae3)[_0x7a72('0x16')](function(_0x3bd962){for(var _0x577a9b=0x0;_0x577a9b<_0x3bd962[_0x7a72('0x20')];_0x577a9b++){var _0x575999=_0x7a72('0x22')+_0x3bd962[_0x577a9b]['id'];_0x3a4e3c[_0x575999][_0x7a72('0x89')]=_0x575999;_0x3a4e3c[_0x575999][_0x7a72('0x8c')]=_0x3bd962[_0x577a9b][_0x7a72('0x8d')];_0x3a4e3c[_0x575999][_0x7a72('0x8e')]={'type':_0x3bd962[_0x577a9b][_0x7a72('0x29')],'values':_0x3bd962[_0x577a9b][_0x7a72('0x8f')]};}Object['keys'](_0x3a4e3c)[_0x7a72('0x55')](function(_0x3f9001){if(!_0x3a4e3c[_0x3f9001][_0x7a72('0x30')]('columnName')){delete _0x3a4e3c[_0x3f9001];}});return _0x3a4e3c;});})[_0x7a72('0x16')](respondWithResult(_0x5482b9,null))[_0x7a72('0x86')](handleError(_0x5482b9,null));};exports[_0x7a72('0x78')]=function(_0x491b93,_0x4e2778){var _0x28a14b;var _0x5eaf7a;var _0x59d9a9;if(_0x491b93['body']['id']){delete _0x491b93['body']['id'];}return db['CmContact'][_0x7a72('0x8b')]({'where':{'id':[_0x491b93[_0x7a72('0x90')]['to'],_0x491b93[_0x7a72('0x90')]['from']]}})['then'](function(_0x44cf84){if(_0x44cf84){if(_0x44cf84['length']!==0x2){return null;}_0x44cf84[0x0]=_0x44cf84[0x0]['get']({'plain':!![]});_0x44cf84[0x1]=_0x44cf84[0x1][_0x7a72('0x91')]({'plain':!![]});delete _0x44cf84[0x0]['id'];delete _0x44cf84[0x1]['id'];return _['mergeWith'](_0x44cf84[0x0],_0x44cf84[0x1],function(_0x2b4c62,_0x43f4e7){if(Array[_0x7a72('0x92')](_0x43f4e7)&&!_0x43f4e7['length']){return _0x2b4c62;}else if(!_0x43f4e7){return _0x2b4c62;}});}})[_0x7a72('0x16')](handleEntityNotFound(_0x4e2778,null))[_0x7a72('0x16')](function(_0x478644){if(_0x478644){if(_0x478644[_0x7a72('0x88')]&&_[_0x7a72('0x92')](_0x478644[_0x7a72('0x88')])){_0x478644['tags']=_0x478644[_0x7a72('0x88')][_0x7a72('0x93')]();}logger[_0x7a72('0x94')]('[CmContact][merge]\x20to\x20%s\x20from\x20%s',_0x491b93[_0x7a72('0x90')]['to'],_0x491b93[_0x7a72('0x90')][_0x7a72('0x38')]);return db['CmHopper'][_0x7a72('0x17')]({'where':{'ContactId':[_0x491b93[_0x7a72('0x90')]['to'],_0x491b93[_0x7a72('0x90')]['from']]}})['then'](function(_0x9f92e4){logger['info'](_0x7a72('0x95'),_0x9f92e4);return db[_0x7a72('0x96')]['destroy']({'where':{'ContactId':[_0x491b93[_0x7a72('0x90')]['to'],_0x491b93[_0x7a72('0x90')][_0x7a72('0x38')]]}})[_0x7a72('0x16')](function(_0x1459e3){logger['info'](_0x7a72('0x97'),_0x1459e3);return db['CmContact'][_0x7a72('0x98')](_0x478644);});});}})[_0x7a72('0x16')](function(_0x2e657e){if(_0x2e657e){_0x28a14b=_0x2e657e;_0x5eaf7a={'ContactId':_0x28a14b['id']};_0x59d9a9={'where':{'ContactId':[_0x491b93[_0x7a72('0x90')]['to'],_0x491b93[_0x7a72('0x90')]['from']]}};return db[_0x7a72('0x99')][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})[_0x7a72('0x16')](function(){if(_0x28a14b){return db[_0x7a72('0x9a')][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})[_0x7a72('0x16')](function(){if(_0x28a14b){return db['ChatOfflineMessage'][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})[_0x7a72('0x16')](function(){if(_0x28a14b){return db[_0x7a72('0x9b')]['update'](_0x5eaf7a,_0x59d9a9);}})['then'](function(){if(_0x28a14b){return db[_0x7a72('0x9c')]['update'](_0x5eaf7a,_0x59d9a9);}})[_0x7a72('0x16')](function(){if(_0x28a14b){return db[_0x7a72('0x9b')][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})['then'](function(){if(_0x28a14b){return db['MailMessage'][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})[_0x7a72('0x16')](function(){if(_0x28a14b){return db[_0x7a72('0x9d')][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})[_0x7a72('0x16')](function(){if(_0x28a14b){return db[_0x7a72('0x9e')][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})['then'](function(){if(_0x28a14b){return db[_0x7a72('0x9f')][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})[_0x7a72('0x16')](function(){if(_0x28a14b){return db[_0x7a72('0xa0')][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})['then'](function(){if(_0x28a14b){return db[_0x7a72('0xa1')][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})[_0x7a72('0x16')](function(){if(_0x28a14b){return db['OpenchannelMessage'][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})[_0x7a72('0x16')](function(){if(_0x28a14b){return db[_0x7a72('0xa2')][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})[_0x7a72('0x16')](function(){if(_0x28a14b){return db[_0x7a72('0xa3')][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})['then'](function(){if(_0x28a14b){return db[_0x7a72('0xa4')][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})[_0x7a72('0x16')](function(){if(_0x28a14b){return db[_0x7a72('0xa5')][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})[_0x7a72('0x16')](function(){if(_0x28a14b){return db[_0x7a72('0xa6')][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})[_0x7a72('0x16')](function(){if(_0x28a14b){return db[_0x7a72('0xa7')][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})[_0x7a72('0x16')](function(){if(_0x28a14b){return db[_0x7a72('0xa8')][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})[_0x7a72('0x16')](function(){if(_0x28a14b){return db[_0x7a72('0xa9')][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})[_0x7a72('0x16')](function(){if(_0x28a14b){return db[_0x7a72('0xaa')]['update'](_0x5eaf7a,_0x59d9a9);}})[_0x7a72('0x16')](function(){if(_0x28a14b){return db[_0x7a72('0xab')]['update'](_0x5eaf7a,_0x59d9a9);}})[_0x7a72('0x16')](function(){if(_0x28a14b){return db['WhatsappInteraction'][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})[_0x7a72('0x16')](function(){if(_0x28a14b){return db[_0x7a72('0xac')][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})[_0x7a72('0x16')](function(){if(_0x28a14b){return db[_0x7a72('0xad')][_0x7a72('0x15')](_0x5eaf7a,_0x59d9a9);}})[_0x7a72('0x16')](function(){if(_0x28a14b){return db[_0x7a72('0x1e')][_0x7a72('0x17')]({'where':{'id':[_0x491b93['body']['to'],_0x491b93[_0x7a72('0x90')][_0x7a72('0x38')]]}});}})[_0x7a72('0x16')](function(){if(_0x28a14b){return _0x28a14b;}})[_0x7a72('0x16')](respondWithResult(_0x4e2778,null))[_0x7a72('0x86')](handleError(_0x4e2778,null));};exports[_0x7a72('0x98')]=function(_0x467817,_0x453307){return db[_0x7a72('0x1e')][_0x7a72('0x87')]()[_0x7a72('0x16')](function(_0x282759){if(_0x467817['body'][_0x7a72('0x88')]&&_[_0x7a72('0x92')](_0x467817['body']['tags'])){if(_0x467817[_0x7a72('0x90')]['tags'][_0x7a72('0x20')]){_0x467817[_0x7a72('0x90')][_0x7a72('0x88')]=_0x467817[_0x7a72('0x90')][_0x7a72('0x88')][_0x7a72('0x93')](';')+';';}else{_0x467817[_0x7a72('0x90')]['tags']=null;}}else{_0x467817[_0x7a72('0x90')][_0x7a72('0x88')]=null;}return db[_0x7a72('0x1e')][_0x7a72('0x98')](_0x467817['body'],{'fields':_[_0x7a72('0x1f')](_0x282759),'raw':!![]});})[_0x7a72('0x16')](respondWithResult(_0x453307,0xc9))[_0x7a72('0x86')](handleError(_0x453307,null));};exports[_0x7a72('0xae')]=function(_0x5e0a30,_0xfdbd3a){var _0x11b31f=0x0;var _0x2d9cd6=0x0;var _0x3913c0=0x0;return db[_0x7a72('0x1e')][_0x7a72('0x87')]()[_0x7a72('0x16')](function(_0x1bea1e){return BPromise[_0x7a72('0xaf')](_0x5e0a30[_0x7a72('0x90')],function(_0x3fc2dd){var _0x1344d6={'where':{'$or':[]},'defaults':_0x3fc2dd,'fields':_[_0x7a72('0x1f')](_0x1bea1e),'raw':!![]};if(_0x3fc2dd['duplicates']){for(var _0x371f73=0x0;_0x371f73<_0x3fc2dd['duplicates'][_0x7a72('0x20')];_0x371f73++){var _0x5aa742={};_0x5aa742[_0x3fc2dd[_0x7a72('0xb0')][_0x371f73]]=_0x3fc2dd[_0x3fc2dd[_0x7a72('0xb0')][_0x371f73]];_0x1344d6[_0x7a72('0x35')][_0x7a72('0xb1')][_0x7a72('0x23')](_0x5aa742);}_0x1344d6[_0x7a72('0x35')][_0x7a72('0x56')]=_0x3fc2dd[_0x7a72('0x56')];}return db[_0x7a72('0x1e')]['findOrCreate'](_0x1344d6)[_0x7a72('0xb2')](function(_0x2ee11d,_0x536d68){if(_0x536d68){_0x11b31f++;}else{_0x3913c0++;}})[_0x7a72('0x86')](function(){_0x2d9cd6++;});});})[_0x7a72('0x16')](function(_0x98e644){if(_0x98e644){return{'success':_0x11b31f,'failure':_0x2d9cd6,'duplicates':_0x3913c0};}})[_0x7a72('0x16')](respondWithResult(_0xfdbd3a,0xc9))['catch'](handleError(_0xfdbd3a,null));};exports[_0x7a72('0xb3')]=function(_0xe50d76,_0x37aafa){var _0x3e9438;return db[_0x7a72('0x1e')][_0x7a72('0x87')]()['then'](function(_0x62bba9){return db['CmContact'][_0x7a72('0x42')]({'where':{'id':_0xe50d76[_0x7a72('0xb4')]['id']},'include':[{'model':db['Tag'],'as':_0x7a72('0x84'),'attributes':['id',_0x7a72('0x1b'),'color'],'required':_0xe50d76['query'][_0x7a72('0x5b')]?!![]:![]}],'attributes':_['keys'](_0x62bba9)});})[_0x7a72('0x16')](function(_0x111d82){if(!_[_0x7a72('0x52')](_0x111d82)){_0x3e9438=_0x111d82[_0x7a72('0x91')]({'plain':!![]});var _0x5eb8b0={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x111d82&&_0x111d82[_0x7a72('0x56')]){if(_0x111d82['ListId']){_0x5eb8b0[_0x7a72('0x35')][_0x7a72('0xb5')][_0x7a72('0x23')]({'ListId':{'$ne':_0x111d82[_0x7a72('0x56')]}});}}return db[_0x7a72('0x24')][_0x7a72('0x8b')](_0x5eb8b0);}})[_0x7a72('0x16')](function(_0xaf6b71){if(!_['isNil'](_0xaf6b71)){return _[_0x7a72('0xb6')](_0x3e9438,_[_0x7a72('0x50')](_0xaf6b71,function(_0x1c7049){return util[_0x7a72('0xb7')]('cf_%d',_0x1c7049['id']);}));}})[_0x7a72('0x16')](handleEntityNotFound(_0x37aafa,null))['then'](respondWithResult(_0x37aafa,null))['catch'](handleError(_0x37aafa,null));};exports['update']=function(_0x4ece5a,_0x3093e0){var _0x14ea67;if(_0x4ece5a[_0x7a72('0x90')]['id']){delete _0x4ece5a[_0x7a72('0x90')]['id'];}return db['CmContact'][_0x7a72('0x42')]({'where':{'id':_0x4ece5a[_0x7a72('0xb4')]['id']}})['then'](handleEntityNotFound(_0x3093e0,null))['then'](saveUpdates(_0x4ece5a[_0x7a72('0x90')],null))['then'](function(_0x1ab1e2){_0x14ea67=_0x1ab1e2;var _0x5f21a5={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x1ab1e2&&_0x1ab1e2['ListId']){if(_0x1ab1e2[_0x7a72('0x56')]){_0x5f21a5['where'][_0x7a72('0xb5')]['push']({'ListId':{'$ne':_0x1ab1e2[_0x7a72('0x56')]}});}}return db[_0x7a72('0x24')]['findAll'](_0x5f21a5);})[_0x7a72('0x16')](function(_0x5ac6d1){if(_0x5ac6d1){return _[_0x7a72('0xb6')](_['pickBy'](_0x4ece5a[_0x7a72('0x90')],function(_0x27ffb6,_0xc6df1b){return _[_0x7a72('0x21')](_0xc6df1b,_0x7a72('0x22'));}),_[_0x7a72('0x50')](_0x5ac6d1,function(_0x456260){return util[_0x7a72('0xb7')](_0x7a72('0xb8'),_0x456260['id']);}));}})[_0x7a72('0x16')](function(_0x434fe0){if(_0x434fe0&&!_[_0x7a72('0x54')](_0x434fe0)){var _0x219ada=squel[_0x7a72('0x15')]()[_0x7a72('0xb9')](_0x7a72('0xba'))[_0x7a72('0xbb')](_0x434fe0)[_0x7a72('0x35')](_0x7a72('0xbc'),_0x4ece5a[_0x7a72('0xb4')]['id'])['toParam']();return db[_0x7a72('0x75')][_0x7a72('0x2b')](_0x219ada[_0x7a72('0xbd')],{'replacements':_0x219ada[_0x7a72('0x8f')]});}})[_0x7a72('0x16')](function(){if(_0x4ece5a[_0x7a72('0x90')][_0x7a72('0xbe')]&&_0x14ea67){return db['CmHopper'][_0x7a72('0x15')]({'phone':_0x4ece5a[_0x7a72('0x90')][_0x7a72('0xbe')]},{'where':{'ContactId':_0x14ea67['id']}});}})[_0x7a72('0x16')](function(){return _0x14ea67;})['then'](respondWithResult(_0x3093e0,null))[_0x7a72('0x86')](handleError(_0x3093e0,null));};exports[_0x7a72('0xbf')]=function(_0x3ae544,_0x3b76aa){var _0x5b93d9={};var _0x28074b={};var _0x277975;var _0x413966;return db[_0x7a72('0x1e')]['findOne']({'where':{'id':_0x3ae544[_0x7a72('0xb4')]['id']}})[_0x7a72('0x16')](handleEntityNotFound(_0x3b76aa,null))[_0x7a72('0x16')](function(_0x4c45bf){if(_0x4c45bf){_0x277975=_0x4c45bf;_0x28074b[_0x7a72('0x2a')]=_[_0x7a72('0x1f')](db[_0x7a72('0x43')][_0x7a72('0xc0')]);_0x28074b[_0x7a72('0x2b')]=_[_0x7a72('0x1f')](_0x3ae544[_0x7a72('0x2b')]);_0x28074b[_0x7a72('0x2c')]=_['intersection'](_0x28074b[_0x7a72('0x2a')],_0x28074b['query']);_0x5b93d9[_0x7a72('0x2d')]=_[_0x7a72('0x2e')](_0x28074b[_0x7a72('0x2a')],qs[_0x7a72('0x2f')](_0x3ae544[_0x7a72('0x2b')]['fields']));_0x5b93d9['attributes']=_0x5b93d9[_0x7a72('0x2d')]['length']?_0x5b93d9['attributes']:_0x28074b[_0x7a72('0x2a')];_0x5b93d9[_0x7a72('0x33')]=qs['sort'](_0x3ae544[_0x7a72('0x2b')]['sort']);_0x5b93d9[_0x7a72('0x35')]=qs[_0x7a72('0x2c')](_[_0x7a72('0xc1')](_0x3ae544[_0x7a72('0x2b')],_0x28074b[_0x7a72('0x2c')]));if(_0x3ae544[_0x7a72('0x2b')][_0x7a72('0x51')]){_0x5b93d9[_0x7a72('0x35')]=_[_0x7a72('0x78')](_0x5b93d9[_0x7a72('0x35')],{'$or':_[_0x7a72('0x50')](_0x5b93d9['attributes'],function(_0xf1d18e){var _0xf828c5={};_0xf828c5[_0xf1d18e]={'$like':'%'+_0x3ae544[_0x7a72('0x2b')]['filter']+'%'};return _0xf828c5;})});}_0x5b93d9=_['merge']({},_0x5b93d9,_0x3ae544[_0x7a72('0xc2')]);return _0x277975[_0x7a72('0xbf')](_0x5b93d9);}})[_0x7a72('0x16')](function(_0x378412){if(_0x378412){_0x413966=_0x378412[_0x7a72('0x20')];if(!_0x3ae544[_0x7a72('0x2b')]['hasOwnProperty']('nolimit')){_0x5b93d9[_0x7a72('0x32')]=qs[_0x7a72('0x32')](_0x3ae544['query'][_0x7a72('0x32')]);_0x5b93d9[_0x7a72('0x11')]=qs[_0x7a72('0x11')](_0x3ae544[_0x7a72('0x2b')]['offset']);}return _0x277975['getTags'](_0x5b93d9);}})[_0x7a72('0x16')](function(_0x2b974a){if(_0x2b974a){return _0x2b974a?{'count':_0x413966,'rows':_0x2b974a}:null;}})[_0x7a72('0x16')](respondWithResult(_0x3b76aa,null))[_0x7a72('0x86')](handleError(_0x3b76aa,null));};exports[_0x7a72('0xc3')]=function(_0x3cc3dc,_0x2fedf5){if(_0x3cc3dc[_0x7a72('0x90')]['id']){delete _0x3cc3dc[_0x7a72('0x90')]['id'];}return db[_0x7a72('0x1e')][_0x7a72('0x25')]({'where':{'id':_0x3cc3dc['params']['id']}})[_0x7a72('0x16')](handleEntityNotFound(_0x2fedf5,null))[_0x7a72('0x16')](function(_0x1835ee){if(_0x1835ee){return _0x1835ee['setTags'](_0x3cc3dc[_0x7a72('0x90')][_0x7a72('0xc4')]||[]);}return null;})[_0x7a72('0x16')](respondWithResult(_0x2fedf5,null))[_0x7a72('0x86')](handleError(_0x2fedf5,null));};exports[_0x7a72('0xc5')]=function(_0x9cbbbf,_0x4c2bb6){var _0x187cdf={'raw':![],'where':{}};var _0x237a82={};var _0x545ab8={'count':0x0,'rows':[]};return db[_0x7a72('0x1e')][_0x7a72('0x25')]({'where':{'id':_0x9cbbbf[_0x7a72('0xb4')]['id']}})[_0x7a72('0x16')](handleEntityNotFound(_0x4c2bb6,null))[_0x7a72('0x16')](function(_0x5d9b71){if(_0x5d9b71){_0x237a82[_0x7a72('0x2a')]=_[_0x7a72('0x1f')](db[_0x7a72('0xc6')][_0x7a72('0xc0')]);_0x237a82[_0x7a72('0x2b')]=_[_0x7a72('0x1f')](_0x9cbbbf[_0x7a72('0x2b')]);_0x237a82['filters']=_[_0x7a72('0x2e')](_0x237a82[_0x7a72('0x2a')],_0x237a82[_0x7a72('0x2b')]);_0x187cdf[_0x7a72('0x2d')]=_[_0x7a72('0x2e')](_0x237a82[_0x7a72('0x2a')],qs[_0x7a72('0x2f')](_0x9cbbbf['query']['fields']));_0x187cdf[_0x7a72('0x2d')]=_0x187cdf[_0x7a72('0x2d')]['length']?_0x187cdf[_0x7a72('0x2d')]:_0x237a82[_0x7a72('0x2a')];if(!_0x9cbbbf[_0x7a72('0x2b')][_0x7a72('0x30')](_0x7a72('0x31'))){_0x187cdf[_0x7a72('0x32')]=qs[_0x7a72('0x32')](_0x9cbbbf[_0x7a72('0x2b')][_0x7a72('0x32')]);_0x187cdf[_0x7a72('0x11')]=qs[_0x7a72('0x11')](_0x9cbbbf[_0x7a72('0x2b')][_0x7a72('0x11')]);}_0x187cdf[_0x7a72('0x33')]=qs[_0x7a72('0x34')](_0x9cbbbf[_0x7a72('0x2b')][_0x7a72('0x34')]);_0x187cdf['where']=qs[_0x7a72('0x2c')](_[_0x7a72('0xc1')](_0x9cbbbf['query'],_0x237a82[_0x7a72('0x2c')]));_0x187cdf[_0x7a72('0x35')][_0x7a72('0xc7')]=_0x5d9b71['id'];if(_0x9cbbbf[_0x7a72('0x2b')][_0x7a72('0x51')]){_0x187cdf[_0x7a72('0x35')]=_[_0x7a72('0x78')](_0x187cdf[_0x7a72('0x35')],{'$or':_['map'](_0x187cdf[_0x7a72('0x2d')],function(_0x27bb30){var _0x33547e={};_0x33547e[_0x27bb30]={'$like':'%'+_0x9cbbbf[_0x7a72('0x2b')]['filter']+'%'};return _0x33547e;})});}_0x187cdf=_[_0x7a72('0x78')]({},_0x187cdf,_0x9cbbbf['options']);return db['CmHopper'][_0x7a72('0x13')]({'where':_0x187cdf['where']})['then'](function(_0x3b03b4){_0x545ab8[_0x7a72('0x13')]=_0x3b03b4;if(_0x9cbbbf[_0x7a72('0x2b')][_0x7a72('0xc8')]){_0x187cdf[_0x7a72('0xc9')]=[{'all':!![]}];}return db['CmHopper'][_0x7a72('0x8b')](_0x187cdf);})[_0x7a72('0x16')](function(_0x45f715){_0x545ab8[_0x7a72('0x85')]=_0x45f715;return _0x545ab8;});}})['then'](respondWithFilteredResult(_0x4c2bb6,_0x187cdf))['catch'](handleError(_0x4c2bb6,null));};exports[_0x7a72('0xca')]=function(_0x47d9e4,_0x43a303){var _0x2cee93={'raw':!![],'where':{}};var _0x18cf3a={};var _0x2f49aa={'count':0x0,'rows':[]};return db['CmContact']['findOne']({'where':{'id':_0x47d9e4[_0x7a72('0xb4')]['id']}})[_0x7a72('0x16')](handleEntityNotFound(_0x43a303,null))[_0x7a72('0x16')](function(_0x54a122){if(_0x54a122){_0x18cf3a[_0x7a72('0x2a')]=_['keys'](db['CmHopperHistory'][_0x7a72('0xc0')]);_0x18cf3a[_0x7a72('0x2b')]=_['keys'](_0x47d9e4[_0x7a72('0x2b')]);_0x18cf3a[_0x7a72('0x2c')]=_[_0x7a72('0x2e')](_0x18cf3a[_0x7a72('0x2a')],_0x18cf3a[_0x7a72('0x2b')]);_0x2cee93['attributes']=_[_0x7a72('0x2e')](_0x18cf3a[_0x7a72('0x2a')],qs['fields'](_0x47d9e4[_0x7a72('0x2b')][_0x7a72('0x2f')]));_0x2cee93['attributes']=_0x2cee93[_0x7a72('0x2d')][_0x7a72('0x20')]?_0x2cee93[_0x7a72('0x2d')]:_0x18cf3a[_0x7a72('0x2a')];if(!_0x47d9e4['query'][_0x7a72('0x30')](_0x7a72('0x31'))){_0x2cee93[_0x7a72('0x32')]=qs[_0x7a72('0x32')](_0x47d9e4[_0x7a72('0x2b')][_0x7a72('0x32')]);_0x2cee93[_0x7a72('0x11')]=qs[_0x7a72('0x11')](_0x47d9e4['query'][_0x7a72('0x11')]);}_0x2cee93[_0x7a72('0x33')]=qs[_0x7a72('0x34')](_0x47d9e4[_0x7a72('0x2b')][_0x7a72('0x34')]);_0x2cee93[_0x7a72('0x35')]=qs[_0x7a72('0x2c')](_[_0x7a72('0xc1')](_0x47d9e4['query'],_0x18cf3a['filters']));_0x2cee93[_0x7a72('0x35')]['ContactId']=_0x54a122['id'];if(_0x47d9e4['query'][_0x7a72('0x51')]){_0x2cee93[_0x7a72('0x35')]=_[_0x7a72('0x78')](_0x2cee93[_0x7a72('0x35')],{'$or':_[_0x7a72('0x50')](_0x2cee93[_0x7a72('0x2d')],function(_0x27e683){var _0x198c96={};_0x198c96[_0x27e683]={'$like':'%'+_0x47d9e4[_0x7a72('0x2b')]['filter']+'%'};return _0x198c96;})});}_0x2cee93=_['merge']({},_0x2cee93,_0x47d9e4['options']);return db['CmHopperHistory'][_0x7a72('0x13')]({'where':_0x2cee93[_0x7a72('0x35')]})['then'](function(_0x25e933){_0x2f49aa[_0x7a72('0x13')]=_0x25e933;if(_0x47d9e4[_0x7a72('0x2b')][_0x7a72('0xc8')]){_0x2cee93[_0x7a72('0xc9')]=[{'all':!![]}];}return db['CmHopperHistory'][_0x7a72('0x8b')](_0x2cee93);})[_0x7a72('0x16')](function(_0x52cfff){_0x2f49aa['rows']=_0x52cfff;return _0x2f49aa;});}})[_0x7a72('0x16')](respondWithFilteredResult(_0x43a303,_0x2cee93))[_0x7a72('0x86')](handleError(_0x43a303,null));};exports[_0x7a72('0xcb')]=function(_0x1173c4,_0x239b19){var _0xeb13dc={'raw':!![],'where':{}};var _0x54f01c={};var _0x42b8d7={'count':0x0,'rows':[]};return db[_0x7a72('0x1e')][_0x7a72('0x25')]({'where':{'id':_0x1173c4[_0x7a72('0xb4')]['id']}})[_0x7a72('0x16')](handleEntityNotFound(_0x239b19,null))[_0x7a72('0x16')](function(_0x351738){if(_0x351738){_0x54f01c['model']=_[_0x7a72('0x1f')](db[_0x7a72('0xa2')]['rawAttributes']);_0x54f01c[_0x7a72('0x2b')]=_['keys'](_0x1173c4[_0x7a72('0x2b')]);_0x54f01c['filters']=_[_0x7a72('0x2e')](_0x54f01c[_0x7a72('0x2a')],_0x54f01c[_0x7a72('0x2b')]);_0xeb13dc[_0x7a72('0x2d')]=_[_0x7a72('0x2e')](_0x54f01c[_0x7a72('0x2a')],qs['fields'](_0x1173c4['query']['fields']));_0xeb13dc[_0x7a72('0x2d')]=_0xeb13dc[_0x7a72('0x2d')]['length']?_0xeb13dc[_0x7a72('0x2d')]:_0x54f01c[_0x7a72('0x2a')];if(!_0x1173c4[_0x7a72('0x2b')]['hasOwnProperty'](_0x7a72('0x31'))){_0xeb13dc[_0x7a72('0x32')]=qs[_0x7a72('0x32')](_0x1173c4[_0x7a72('0x2b')][_0x7a72('0x32')]);_0xeb13dc['offset']=qs[_0x7a72('0x11')](_0x1173c4[_0x7a72('0x2b')][_0x7a72('0x11')]);}_0xeb13dc[_0x7a72('0x33')]=qs['sort'](_0x1173c4[_0x7a72('0x2b')][_0x7a72('0x34')]);_0xeb13dc[_0x7a72('0x35')]=qs[_0x7a72('0x2c')](_[_0x7a72('0xc1')](_0x1173c4[_0x7a72('0x2b')],_0x54f01c['filters']));_0xeb13dc['where']['ContactId']=_0x351738['id'];if(_0x1173c4['query'][_0x7a72('0x51')]){_0xeb13dc[_0x7a72('0x35')]=_[_0x7a72('0x78')](_0xeb13dc['where'],{'$or':_[_0x7a72('0x50')](_0xeb13dc[_0x7a72('0x2d')],function(_0xa8efe2){var _0x1d0386={};_0x1d0386[_0xa8efe2]={'$like':'%'+_0x1173c4[_0x7a72('0x2b')][_0x7a72('0x51')]+'%'};return _0x1d0386;})});}_0xeb13dc=_['merge']({},_0xeb13dc,_0x1173c4[_0x7a72('0xc2')]);return db[_0x7a72('0xa2')][_0x7a72('0x13')]({'where':_0xeb13dc[_0x7a72('0x35')]})[_0x7a72('0x16')](function(_0x1abba4){_0x42b8d7[_0x7a72('0x13')]=_0x1abba4;if(_0x1173c4[_0x7a72('0x2b')]['includeAll']){_0xeb13dc[_0x7a72('0xc9')]=[{'all':!![]}];}return db[_0x7a72('0xa2')][_0x7a72('0x8b')](_0xeb13dc);})[_0x7a72('0x16')](function(_0x2aba81){_0x42b8d7[_0x7a72('0x85')]=_0x2aba81;return _0x42b8d7;});}})[_0x7a72('0x16')](respondWithFilteredResult(_0x239b19,_0xeb13dc))['catch'](handleError(_0x239b19,null));};exports['getJscriptySessions']=function(_0x525b89,_0x461415){var _0xabde74={'raw':!![],'where':{}};var _0x27f7fd={};var _0x530ea0={'count':0x0,'rows':[]};return db['CmContact']['findOne']({'where':{'id':_0x525b89[_0x7a72('0xb4')]['id']}})[_0x7a72('0x16')](handleEntityNotFound(_0x461415,null))['then'](function(_0x4e227f){if(_0x4e227f){_0x27f7fd['model']=_[_0x7a72('0x1f')](db[_0x7a72('0xab')]['rawAttributes']);_0x27f7fd[_0x7a72('0x2b')]=_[_0x7a72('0x1f')](_0x525b89[_0x7a72('0x2b')]);_0x27f7fd[_0x7a72('0x2c')]=_[_0x7a72('0x2e')](_0x27f7fd[_0x7a72('0x2a')],_0x27f7fd['query']);_0xabde74['attributes']=_[_0x7a72('0x2e')](_0x27f7fd[_0x7a72('0x2a')],qs[_0x7a72('0x2f')](_0x525b89[_0x7a72('0x2b')]['fields']));_0xabde74[_0x7a72('0x2d')]=_0xabde74[_0x7a72('0x2d')][_0x7a72('0x20')]?_0xabde74[_0x7a72('0x2d')]:_0x27f7fd['model'];if(!_0x525b89[_0x7a72('0x2b')]['hasOwnProperty'](_0x7a72('0x31'))){_0xabde74['limit']=qs[_0x7a72('0x32')](_0x525b89[_0x7a72('0x2b')][_0x7a72('0x32')]);_0xabde74[_0x7a72('0x11')]=qs[_0x7a72('0x11')](_0x525b89[_0x7a72('0x2b')][_0x7a72('0x11')]);}_0xabde74[_0x7a72('0x33')]=qs[_0x7a72('0x34')](_0x525b89[_0x7a72('0x2b')]['sort']);_0xabde74['where']=qs[_0x7a72('0x2c')](_['pick'](_0x525b89['query'],_0x27f7fd[_0x7a72('0x2c')]));_0xabde74['where'][_0x7a72('0xc7')]=_0x4e227f['id'];if(_0x525b89[_0x7a72('0x2b')][_0x7a72('0x51')]){_0xabde74[_0x7a72('0x35')]=_[_0x7a72('0x78')](_0xabde74[_0x7a72('0x35')],{'$or':_[_0x7a72('0x50')](_0xabde74[_0x7a72('0x2d')],function(_0x48c6a8){var _0x571848={};_0x571848[_0x48c6a8]={'$like':'%'+_0x525b89['query'][_0x7a72('0x51')]+'%'};return _0x571848;})});}_0xabde74=_['merge']({},_0xabde74,_0x525b89[_0x7a72('0xc2')]);return db[_0x7a72('0xab')][_0x7a72('0x13')]({'where':_0xabde74[_0x7a72('0x35')]})['then'](function(_0x2a5fed){_0x530ea0[_0x7a72('0x13')]=_0x2a5fed;if(_0x525b89['query'][_0x7a72('0xc8')]){_0xabde74[_0x7a72('0xc9')]=[{'all':!![]}];}return db[_0x7a72('0xab')][_0x7a72('0x8b')](_0xabde74);})[_0x7a72('0x16')](function(_0x4dfe3d){_0x530ea0[_0x7a72('0x85')]=_0x4dfe3d;return _0x530ea0;});}})[_0x7a72('0x16')](respondWithFilteredResult(_0x461415,_0xabde74))[_0x7a72('0x86')](handleError(_0x461415,null));};exports[_0x7a72('0xcc')]=function(_0x5940f3,_0x73d72c){try{if(!_0x5940f3[_0x7a72('0x90')]['ListId']){throw new Error(_0x7a72('0xcd'));}if(!_0x5940f3[_0x7a72('0x90')][_0x7a72('0xce')]){throw new Error(_0x7a72('0xcf'));}if(!_0x5940f3[_0x7a72('0x90')][_0x7a72('0xd0')]){throw new Error(_0x7a72('0xd1'));}if(!_0x5940f3[_0x7a72('0x90')]['socket_timestamp']){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0xf2c0a=_0x5940f3['body'][_0x7a72('0xce')][_0x7a72('0x45')](',');var _0x1777e1=_0x5940f3[_0x7a72('0x90')]['binding_values'][_0x7a72('0x45')](',');if(!_0xf2c0a[_0x7a72('0x20')]||!_0x1777e1[_0x7a72('0x20')]||_0xf2c0a[_0x7a72('0x20')]!==_0x1777e1[_0x7a72('0x20')]){throw new Error(_0x7a72('0xd2'));}_0x5940f3['body'][_0x7a72('0x2f')]=_[_0x7a72('0xd3')](_0xf2c0a,_0x1777e1);if(!_0x5940f3[_0x7a72('0x90')]['fields'][_0x7a72('0xbe')]){throw new Error(_0x7a72('0xd4'));}if(!_0x5940f3[_0x7a72('0x90')][_0x7a72('0x2f')][_0x7a72('0xd5')]){throw new Error(_0x7a72('0xd6'));}var _0x507161=path['join'](config[_0x7a72('0xd7')],_0x7a72('0xd8'),_0x5940f3[_0x7a72('0xd9')][_0x7a72('0xda')]);fs[_0x7a72('0xdb')](_0x507161,parseInt(_0x7a72('0xdc'),0x8));var _0x10e1aa=require(_0x7a72('0xdd'))[_0x7a72('0xde')](path[_0x7a72('0x93')](__dirname,_0x7a72('0xdf')),[_0x507161,_0x5940f3[_0x7a72('0x90')]['binding_keys'],_0x5940f3['body'][_0x7a72('0xd0')],_0x5940f3[_0x7a72('0x90')][_0x7a72('0x56')],_0x5940f3['body'][_0x7a72('0xe0')],_0x5940f3['body']['duplicates'],_0x5940f3[_0x7a72('0x90')][_0x7a72('0xe1')]]);return _0x73d72c['status'](0xc8)[_0x7a72('0x10')]({'message':_0x7a72('0xe2'),'pid':_0x10e1aa[_0x7a72('0xe3')]});}catch(_0x43646d){return _0x73d72c[_0x7a72('0xf')](0x1f4)[_0x7a72('0x1c')](_0x43646d);}};exports[_0x7a72('0xe4')]=function(_0x4a75b9,_0x1420de){var _0x1e51ce=fs[_0x7a72('0xe5')](_0x4a75b9[_0x7a72('0xd9')][_0x7a72('0x3')]);Papa['parse'](_0x1e51ce,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x8ab507){return _0x1420de['status'](0xc8)[_0x7a72('0x10')]({'file':_0x4a75b9['file'],'fields':_0x8ab507[_0x7a72('0xe6')][_0x7a72('0x2f')]});}});};exports[_0x7a72('0xe7')]=function(_0x307a40,_0x1136f2){return db[_0x7a72('0x72')][_0x7a72('0x8b')]({'raw':!![],'attributes':['id'],'where':{'role':_0x7a72('0xe8')}})['then'](function(_0x27919c){var _0x163157=![];if(!_0x307a40[_0x7a72('0x90')][_0x7a72('0x56')]){throw new Error(_0x7a72('0xcd'));}if(!_0x307a40[_0x7a72('0x90')][_0x7a72('0xe9')][_0x7a72('0xbe')]){throw new Error(_0x7a72('0xd4'));}if(!_0x307a40[_0x7a72('0x90')][_0x7a72('0xe9')]['firstName']){throw new Error(_0x7a72('0xd6'));}if(!_0x307a40[_0x7a72('0x90')][_0x7a72('0xe1')]){throw new Error(_0x7a72('0xea'));}var _0x4729d9=require(_0x7a72('0xdd'))[_0x7a72('0xde')](path[_0x7a72('0x93')](__dirname,_0x7a72('0xeb')),[_0x307a40['params']['id'],JSON[_0x7a72('0xec')](_0x307a40['body']),JSON[_0x7a72('0xec')](_0x27919c)]);_0x4729d9['on'](_0x7a72('0xed'),function(){_0x163157=!![];return _0x1136f2[_0x7a72('0xf')](0xc8)[_0x7a72('0x10')]({'message':_0x7a72('0xee'),'pid':_0x4729d9[_0x7a72('0xe3')]});});_0x4729d9['on'](_0x7a72('0xef'),function(_0x4e2fac){if(_0x4e2fac&&!_0x163157){return _0x1136f2[_0x7a72('0xf')](0x1f4)[_0x7a72('0x10')]({'message':_0x7a72('0xf0'),'pid':_0x4729d9[_0x7a72('0xe3')]});}});})[_0x7a72('0x86')](handleError(_0x1136f2,null));};exports[_0x7a72('0xf1')]=function(_0x22a542,_0x48e776){var _0x334611=[_0x7a72('0xf2'),'chat',_0x7a72('0xf3'),_0x7a72('0xf4'),_0x7a72('0xf5'),_0x7a72('0xf6'),_0x7a72('0xf7')];var _0x21b196={'offset':0x0,'order':qs[_0x7a72('0x34')]('-createdAt')},_0x2ec529={'count':0x0,'rows':[]};Promise[_0x7a72('0x6e')]()[_0x7a72('0x16')](function(){if(_0x22a542[_0x7a72('0x2b')]['channel']){if(!_['includes'](_0x334611,_0x22a542[_0x7a72('0x2b')][_0x7a72('0xf8')][_0x7a72('0xf9')]())){throw new Error('Invalid\x20channel');}_0x334611=[_0x22a542[_0x7a72('0x2b')][_0x7a72('0xf8')]['toLowerCase']()];}if(_0x22a542[_0x7a72('0x2b')]['range']){try{var _0x5c17c7=JSON[_0x7a72('0xfa')](_0x22a542[_0x7a72('0x2b')][_0x7a72('0xfb')]);if(!moment(_0x5c17c7[_0x7a72('0x38')])['isValid']()){throw new Error(_0x7a72('0xfc'));}if(!moment(_0x5c17c7['to'])[_0x7a72('0xfd')]()){throw new Error(_0x7a72('0xfe'));}}catch(_0x59be5e){throw new Error(_0x7a72('0xff'));}}if(!_0x22a542[_0x7a72('0x2b')][_0x7a72('0x30')](_0x7a72('0x31'))){_0x21b196[_0x7a72('0x32')]=qs[_0x7a72('0x32')](_0x22a542['query'][_0x7a72('0x32')]||0xa);_0x21b196[_0x7a72('0x11')]=qs[_0x7a72('0x11')](_0x22a542[_0x7a72('0x2b')][_0x7a72('0x11')]);}var _0x264e62=_0x334611[_0x7a72('0x50')](function(_0x1ce339){if(_0x1ce339===_0x7a72('0xf7')){var _0x597fbc={'attributes':['id',_0x7a72('0x100'),_0x7a72('0x29'),'source',_0x7a72('0x101'),_0x7a72('0x102'),_0x7a72('0x103'),_0x7a72('0x104'),_0x7a72('0x105'),_0x7a72('0x106'),_0x7a72('0x107'),_0x7a72('0x108'),_0x7a72('0x109'),_0x7a72('0x10a'),_0x7a72('0x10b')],'where':{'ContactId':_0x22a542[_0x7a72('0xb4')]['id']},'include':[{'model':db[_0x7a72('0x72')],'as':_0x7a72('0x72'),'attributes':['id',_0x7a72('0x1b'),'fullname',_0x7a72('0x8d')]}],'order':[[_0x7a72('0x107'),_0x7a72('0x10c')]]};if(_0x22a542[_0x7a72('0x2b')][_0x7a72('0xfb')]){_0x597fbc[_0x7a72('0x35')][_0x7a72('0x107')]={'$gte':_0x5c17c7[_0x7a72('0x38')],'$lte':_0x5c17c7['to']};}return db[_0x7a72('0xa5')]['findAndCountAll'](_0x597fbc)[_0x7a72('0x16')](function(_0x54d4a5){_0x2ec529['count']+=_0x54d4a5['count'];return _[_0x7a72('0x50')](_0x54d4a5[_0x7a72('0x85')],function(_0x3808e2){var _0x1e93c1=_0x3808e2[_0x7a72('0x91')]({'plain':!![]});_0x1e93c1[_0x7a72('0xf8')]=_0x1ce339;if(_0x1e93c1[_0x7a72('0x72')]){_0x1e93c1[_0x7a72('0x72')]={'id':_0x1e93c1['User']['id'],'name':_0x1e93c1[_0x7a72('0x72')][_0x7a72('0x1b')],'fullname':_0x1e93c1[_0x7a72('0x72')][_0x7a72('0x10d')],'alias':_0x1e93c1[_0x7a72('0x72')][_0x7a72('0x8d')]};}return _0x1e93c1;});});}else{var _0x549a25=_['startCase'](_0x1ce339)+(_0x1ce339===_0x7a72('0x10e')?_0x7a72('0x10f'):'Account');var _0x224260={'attributes':['id',_0x7a72('0x110'),_0x7a72('0x111'),_0x7a72('0x107'),_0x7a72('0x106'),_0x7a72('0x112'),'secondDisposition',_0x7a72('0x113'),_0x7a72('0x10b'),_0x549a25+'Id'],'where':{'ContactId':_0x22a542['params']['id']},'include':[{'model':db[_0x549a25],'as':_0x7a72('0x114'),'attributes':['id',_0x7a72('0x1b'),'key']},{'model':db[_0x7a72('0x72')],'as':_0x7a72('0x115'),'attributes':['id',_0x7a72('0x1b'),'fullname']},{'model':db[_0x7a72('0x43')],'as':_0x7a72('0x84'),'attributes':['id',_0x7a72('0x1b'),'color'],'through':{'attributes':[]}}],'order':[['createdAt',_0x7a72('0x10c')]]};if(_0x22a542[_0x7a72('0x2b')][_0x7a72('0xfb')]){_0x224260[_0x7a72('0x35')]['createdAt']={'$gte':_0x5c17c7[_0x7a72('0x38')],'$lte':_0x5c17c7['to']};}switch(_0x1ce339){case _0x7a72('0x10e'):_0x224260[_0x7a72('0x2d')][_0x7a72('0x23')]('browserName',_0x7a72('0x116'),_0x7a72('0x117'),'deviceModel',_0x7a72('0x118'),'ratingMessage',_0x7a72('0x119'),_0x7a72('0x11a'),_0x7a72('0x11b'));break;case _0x7a72('0xf2'):_0x224260['attributes'][_0x7a72('0x23')](_0x7a72('0x11c'),'substatus');break;case _0x7a72('0xf4'):_0x224260[_0x7a72('0x2d')][_0x7a72('0x23')](_0x7a72('0x11d'),_0x7a72('0x11e'));break;}return db[_[_0x7a72('0x11f')](_0x1ce339)+_0x7a72('0x120')][_0x7a72('0x121')](_0x224260)[_0x7a72('0x16')](function(_0x3e2597){_0x2ec529[_0x7a72('0x13')]+=_0x3e2597[_0x7a72('0x13')];return _[_0x7a72('0x50')](_0x3e2597['rows'],function(_0x20a559){var _0x3ee755=_0x20a559[_0x7a72('0x91')]({'plain':!![]});_0x3ee755[_0x7a72('0xf8')]=_0x1ce339;if(_0x3ee755[_0x7a72('0x115')]){_0x3ee755[_0x7a72('0x115')]={'id':_0x3ee755[_0x7a72('0x115')]['id'],'name':_0x3ee755['Owner'][_0x7a72('0x1b')],'fullname':_0x3ee755[_0x7a72('0x115')][_0x7a72('0x10d')]};}return _0x3ee755;});});}});return Promise[_0x7a72('0x27')](_0x264e62);})[_0x7a72('0x16')](function(_0x2c6212){return _(_0x2c6212)[_0x7a72('0x122')]()['sortBy'](_0x7a72('0x107'))[_0x7a72('0x123')]()['value']();})['then'](function(_0x1798fd){_0x2ec529['rows']=_0x21b196['limit']?_0x1798fd[_0x7a72('0x124')](_0x21b196['offset'],_0x21b196[_0x7a72('0x11')]+_0x21b196[_0x7a72('0x32')]):_0x1798fd;return _0x2ec529;})['then'](respondWithFilteredResult(_0x48e776,_0x21b196))['catch'](handleError(_0x48e776,null));};
\ No newline at end of file
+var _0xdaea=['threadId','Interaction','Owner','flatten','sortBy','reverse','value','slice','util','path','squel','ioredis','../../components/contacts','../../config/logger','../../config/environment','../../config/environment/shared','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./cmContact.socket','status','json','offset','undefined','count','update','then','end','sendStatus','error','stack','name','send','describe','getOptions','query','user','catch','CmContact','find','tags','keys','length','startsWith','cf_','analytics','findAll','displayName','alias','type','Custom\x20field\x20%s\x20not\x20found\x20on\x20cm_contacts\x20table','hasOwnProperty','merge','body','from','get','mergeWith','isArray','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','destroy','[CmContact][merge][destroy][CmHopper],\x20%s','create','ChatInteraction','ChatMessage','MailMessage','MailInteraction','SmsInteraction','SmsMessage','FaxInteraction','OpenchannelInteraction','OpenchannelMessage','CmContactHasItem','CmHopperFinal','CmHopperHistory','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','JscriptySessionReport','WhatsappMessage','WhatsappQueueReport','join','isNil','dialTimezone','timezones','utcOffset','additionalPhones','bulkCreate','each','duplicates','where','push','ListId','findOrCreate','contact','all','params','Tag','Tags','color','Phones','ContactItemType','ItemType','sequelize','literal','Phones.OrderBy','CmCustomField','omit','map','format','cf_%d','$and','pickBy','isEmpty','table','setFields','text','values','getTags','findOne','rawAttributes','filters','intersection','model','attributes','fields','order','sort','pick','filter','nolimit','limit','setTags','OrderBy','items','item_types','ItemTypeId','description','contact\x20phone\x20exists','PHONE','CmHopperAdditionalPhone','item','`ItemType`.OrderBy','CmHopperId','phone','ItemType.OrderBy','duplicateAdditionalPhones','CmContactId','toContactId','rescheduleAdditionalPhones','hopperId','ContactId','options','include','getHopperHistories','rows','includeAll','getJscriptySessions','No\x20ListId\x20specified','binding_keys','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','binding_values','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','root','server/files/tmp','file','filename','chmodSync','0777','fork','../../components/import/cm/csv','CompanyId','File\x20uploaded\x20correctly!','pid','upload','createReadStream','meta','User','agent','binding','child_process','../../components/import/cm/csv2','stringify','message','error\x20child\x20process','../../components/import/cm/csvUpdates','start\x20child\x20process\x20correctly!','getJourney','mail','chat','sms','openchannel','fax','whatsapp','-createdAt','channel','includes','toLowerCase','Invalid\x20channel','range','parse','isValid','Invalid\x20date\x20for\x20range\x20from\x20filter','Invalid\x20date\x20for\x20range\x20to\x20filter','Invalid\x20createdAt\x20filter','voice','uniqueid','source','destination','callerid','endtime','note','userDisposition','userSecondDisposition','UserId','fullname','DESC','createdAt','findAndCountAll','startCase','Website','Account','closed','closedAt','disposition','secondDisposition','thirdDisposition','key','deviceModel','osName','ratingMessage','ratingType','referer','subject','externalUrl'];(function(_0x108d5f,_0x33f82d){var _0x456ea3=function(_0x228200){while(--_0x228200){_0x108d5f['push'](_0x108d5f['shift']());}};_0x456ea3(++_0x33f82d);}(_0xdaea,0xfe));var _0xadae=function(_0x2cc0b3,_0x120bf1){_0x2cc0b3=_0x2cc0b3-0x0;var _0x1667ef=_0xdaea[_0x2cc0b3];return _0x1667ef;};'use strict';var moment=require('moment');var BPromise=require('bluebird');var util=require(_0xadae('0x0'));var path=require(_0xadae('0x1'));var fs=require('fs');var _=require('lodash');var squel=require(_0xadae('0x2'));var Papa=require('papaparse');var Redis=require(_0xadae('0x3'));var contacts=require(_0xadae('0x4'));var qs=require('../../components/parsers/qs');var logger=require(_0xadae('0x5'))('api');var config=require(_0xadae('0x6'));var shared=require(_0xadae('0x7'));var db=require(_0xadae('0x8'))['db'];config[_0xadae('0x9')]=_[_0xadae('0xa')](config[_0xadae('0x9')],{'host':_0xadae('0xb'),'port':0x18eb});var socket=require(_0xadae('0xc'))(new Redis(config[_0xadae('0x9')]));require(_0xadae('0xd'))['register'](socket);function respondWithResult(_0x140cfa,_0x16123a){_0x16123a=_0x16123a||0xc8;return function(_0x5052de){if(_0x5052de){return _0x140cfa[_0xadae('0xe')](_0x16123a)[_0xadae('0xf')](_0x5052de);}};}function respondWithFilteredResult(_0x22ded7,_0x534e4f){return function(_0x3b668d){if(_0x3b668d){var _0x44b7cd=typeof _0x534e4f[_0xadae('0x10')]===_0xadae('0x11')&&typeof _0x534e4f['limit']===_0xadae('0x11');var _0x5a03e0=_0x3b668d[_0xadae('0x12')];var _0x248a83=_0x44b7cd?0x0:_0x534e4f[_0xadae('0x10')];var _0x4b4e73=_0x44b7cd?_0x3b668d[_0xadae('0x12')]:_0x534e4f[_0xadae('0x10')]+_0x534e4f['limit'];var _0x4fafaa;if(_0x4b4e73>=_0x5a03e0){_0x4b4e73=_0x5a03e0;_0x4fafaa=0xc8;}else{_0x4fafaa=0xce;}_0x22ded7['status'](_0x4fafaa);return _0x22ded7['set']('Content-Range',_0x248a83+'-'+_0x4b4e73+'/'+_0x5a03e0)[_0xadae('0xf')](_0x3b668d);}return null;};}function saveUpdates(_0x510baf){return function(_0x5d92aa){if(_0x5d92aa){return _0x5d92aa[_0xadae('0x13')](_0x510baf)['then'](function(_0x29971d){return _0x29971d;});}return null;};}function removeEntity(_0xf81e21){return function(_0x2cb6cf){if(_0x2cb6cf){return _0x2cb6cf['destroy']()[_0xadae('0x14')](function(){_0xf81e21['status'](0xcc)[_0xadae('0x15')]();});}};}function handleEntityNotFound(_0x2cb213){return function(_0x554068){if(!_0x554068){_0x2cb213[_0xadae('0x16')](0x194);}return _0x554068;};}function handleError(_0x3a2603,_0x4c09d9){_0x4c09d9=_0x4c09d9||0x1f4;return function(_0x58ecbe){logger[_0xadae('0x17')](_0x58ecbe[_0xadae('0x18')]);if(_0x58ecbe[_0xadae('0x19')]){delete _0x58ecbe[_0xadae('0x19')];}_0x3a2603[_0xadae('0xe')](_0x4c09d9)[_0xadae('0x1a')](_0x58ecbe);};}exports['index']=function(_0x2f6234,_0xb064b1){var _0x5c30ca={};return contacts[_0xadae('0x1b')]()[_0xadae('0x14')](function(_0x4d428c){_0x5c30ca=qs[_0xadae('0x1c')](_0x4d428c,_0x2f6234);return contacts['findAll'](_0x2f6234[_0xadae('0x1d')],_0x2f6234[_0xadae('0x1e')],_0x5c30ca,_0x4d428c);})[_0xadae('0x14')](respondWithFilteredResult(_0xb064b1,_0x5c30ca))[_0xadae('0x1f')](handleError(_0xb064b1,null));};exports['destroy']=function(_0x79f8b3,_0x2620f0){return db[_0xadae('0x20')][_0xadae('0x21')]({'where':{'id':_0x79f8b3['params']['id']}})['then'](handleEntityNotFound(_0x2620f0,null))[_0xadae('0x14')](removeEntity(_0x2620f0,null))[_0xadae('0x1f')](handleError(_0x2620f0,null));};exports[_0xadae('0x1b')]=function(_0x54691c,_0x2d5438){return db[_0xadae('0x20')][_0xadae('0x1b')]()['then'](function(_0x565b33){delete _0x565b33[_0xadae('0x22')];for(var _0x264266=0x0;_0x264266<Object[_0xadae('0x23')](_0x565b33)[_0xadae('0x24')];_0x264266++){var _0x413d8a=Object['keys'](_0x565b33)[_0x264266];if(!_[_0xadae('0x25')](_0x413d8a,_0xadae('0x26'))){_0x565b33[_0x413d8a]['columnName']=_0x413d8a;_0x565b33[_0x413d8a]['displayName']=_0x413d8a;}}return _0x565b33;})['then'](function(_0x484a05){var _0x502097={'where':Boolean(_0x54691c['query'][_0xadae('0x27')])===!![]?undefined:{'$or':[{'ListId':_0x54691c[_0xadae('0x1d')]['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField'][_0xadae('0x28')](_0x502097)[_0xadae('0x14')](function(_0xc48e0){for(var _0x2f19e8=0x0;_0x2f19e8<_0xc48e0['length'];_0x2f19e8++){var _0x3ee189=_0xadae('0x26')+_0xc48e0[_0x2f19e8]['id'];if(_0x484a05[_0x3ee189]){_0x484a05[_0x3ee189]['columnName']=_0x3ee189;_0x484a05[_0x3ee189][_0xadae('0x29')]=_0xc48e0[_0x2f19e8][_0xadae('0x2a')];_0x484a05[_0x3ee189]['custom']={'type':_0xc48e0[_0x2f19e8][_0xadae('0x2b')],'values':_0xc48e0[_0x2f19e8]['values']};}else{logger['info'](_0xadae('0x2c'),_0x3ee189);}}Object[_0xadae('0x23')](_0x484a05)['forEach'](function(_0x1c821d){if(!_0x484a05[_0x1c821d][_0xadae('0x2d')]('columnName')){delete _0x484a05[_0x1c821d];}});return _0x484a05;});})[_0xadae('0x14')](respondWithResult(_0x2d5438,null))[_0xadae('0x1f')](handleError(_0x2d5438,null));};exports[_0xadae('0x2e')]=function(_0x42787b,_0x274fb4){var _0x1069c2;var _0x4ed8b5;var _0x24726a;if(_0x42787b[_0xadae('0x2f')]['id']){delete _0x42787b[_0xadae('0x2f')]['id'];}return db['CmContact'][_0xadae('0x28')]({'where':{'id':[_0x42787b[_0xadae('0x2f')]['to'],_0x42787b[_0xadae('0x2f')][_0xadae('0x30')]]}})[_0xadae('0x14')](function(_0x124160){if(_0x124160){if(_0x124160[_0xadae('0x24')]!==0x2){return null;}_0x124160[0x0]=_0x124160[0x0][_0xadae('0x31')]({'plain':!![]});_0x124160[0x1]=_0x124160[0x1]['get']({'plain':!![]});delete _0x124160[0x0]['id'];delete _0x124160[0x1]['id'];return _[_0xadae('0x32')](_0x124160[0x0],_0x124160[0x1],function(_0x16a7e8,_0x4a61a1){if(Array[_0xadae('0x33')](_0x4a61a1)&&!_0x4a61a1['length']){return _0x16a7e8;}else if(!_0x4a61a1){return _0x16a7e8;}});}})['then'](handleEntityNotFound(_0x274fb4,null))[_0xadae('0x14')](function(_0x168ddd){if(_0x168ddd){if(_0x168ddd[_0xadae('0x22')]&&_['isArray'](_0x168ddd[_0xadae('0x22')])){_0x168ddd['tags']=_0x168ddd[_0xadae('0x22')]['join']();}logger[_0xadae('0x34')](_0xadae('0x35'),_0x42787b[_0xadae('0x2f')]['to'],_0x42787b[_0xadae('0x2f')][_0xadae('0x30')]);return db[_0xadae('0x36')][_0xadae('0x37')]({'where':{'ContactId':[_0x42787b[_0xadae('0x2f')]['to'],_0x42787b['body'][_0xadae('0x30')]]}})[_0xadae('0x14')](function(_0x3149e2){logger[_0xadae('0x34')](_0xadae('0x38'),_0x3149e2);return db['CmHopperBlack'][_0xadae('0x37')]({'where':{'ContactId':[_0x42787b[_0xadae('0x2f')]['to'],_0x42787b[_0xadae('0x2f')][_0xadae('0x30')]]}})[_0xadae('0x14')](function(_0x2189f6){logger[_0xadae('0x34')]('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x2189f6);return db[_0xadae('0x20')][_0xadae('0x39')](_0x168ddd);});});}})[_0xadae('0x14')](function(_0x35dc40){if(_0x35dc40){_0x1069c2=_0x35dc40;_0x4ed8b5={'ContactId':_0x1069c2['id']};_0x24726a={'where':{'ContactId':[_0x42787b[_0xadae('0x2f')]['to'],_0x42787b['body'][_0xadae('0x30')]]}};return db[_0xadae('0x3a')]['update'](_0x4ed8b5,_0x24726a);}})[_0xadae('0x14')](function(){if(_0x1069c2){return db[_0xadae('0x3b')][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})['then'](function(){if(_0x1069c2){return db['ChatOfflineMessage'][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})['then'](function(){if(_0x1069c2){return db['MailInteraction'][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})['then'](function(){if(_0x1069c2){return db[_0xadae('0x3c')]['update'](_0x4ed8b5,_0x24726a);}})[_0xadae('0x14')](function(){if(_0x1069c2){return db[_0xadae('0x3d')][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})['then'](function(){if(_0x1069c2){return db[_0xadae('0x3c')][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})[_0xadae('0x14')](function(){if(_0x1069c2){return db[_0xadae('0x3e')][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})[_0xadae('0x14')](function(){if(_0x1069c2){return db[_0xadae('0x3f')][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})[_0xadae('0x14')](function(){if(_0x1069c2){return db[_0xadae('0x40')][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})[_0xadae('0x14')](function(){if(_0x1069c2){return db['FaxMessage'][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})[_0xadae('0x14')](function(){if(_0x1069c2){return db[_0xadae('0x41')][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})[_0xadae('0x14')](function(){if(_0x1069c2){return db[_0xadae('0x42')][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})[_0xadae('0x14')](function(){if(_0x1069c2){return db[_0xadae('0x43')][_0xadae('0x13')]({'CmContactId':_0x1069c2['id']},{'where':{'CmContactId':[_0x42787b[_0xadae('0x2f')]['to'],_0x42787b[_0xadae('0x2f')][_0xadae('0x30')]]}});}})['then'](function(){if(_0x1069c2){return db[_0xadae('0x44')][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})[_0xadae('0x14')](function(){if(_0x1069c2){return db[_0xadae('0x45')][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})['then'](function(){if(_0x1069c2){return db['ReportAgentPreview'][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})[_0xadae('0x14')](function(){if(_0x1069c2){return db[_0xadae('0x46')][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})[_0xadae('0x14')](function(){if(_0x1069c2){return db[_0xadae('0x47')]['update'](_0x4ed8b5,_0x24726a);}})[_0xadae('0x14')](function(){if(_0x1069c2){return db[_0xadae('0x48')][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})[_0xadae('0x14')](function(){if(_0x1069c2){return db[_0xadae('0x49')][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})[_0xadae('0x14')](function(){if(_0x1069c2){return db[_0xadae('0x4a')][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})[_0xadae('0x14')](function(){if(_0x1069c2){return db['SmsQueueReport'][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})[_0xadae('0x14')](function(){if(_0x1069c2){return db[_0xadae('0x4b')][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})[_0xadae('0x14')](function(){if(_0x1069c2){return db['WhatsappInteraction']['update'](_0x4ed8b5,_0x24726a);}})[_0xadae('0x14')](function(){if(_0x1069c2){return db[_0xadae('0x4c')][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})[_0xadae('0x14')](function(){if(_0x1069c2){return db[_0xadae('0x4d')][_0xadae('0x13')](_0x4ed8b5,_0x24726a);}})[_0xadae('0x14')](function(){if(_0x1069c2){return db[_0xadae('0x20')]['destroy']({'where':{'id':[_0x42787b['body']['to'],_0x42787b[_0xadae('0x2f')][_0xadae('0x30')]]}});}})[_0xadae('0x14')](function(){if(_0x1069c2){return _0x1069c2;}})[_0xadae('0x14')](respondWithResult(_0x274fb4,null))[_0xadae('0x1f')](handleError(_0x274fb4,null));};exports[_0xadae('0x39')]=function(_0x3d7ad1,_0x1174b1){return db['CmContact'][_0xadae('0x1b')]()[_0xadae('0x14')](function(_0x4d1797){if(_0x3d7ad1[_0xadae('0x2f')][_0xadae('0x22')]&&_[_0xadae('0x33')](_0x3d7ad1[_0xadae('0x2f')]['tags'])){if(_0x3d7ad1['body']['tags'][_0xadae('0x24')]){_0x3d7ad1[_0xadae('0x2f')][_0xadae('0x22')]=_0x3d7ad1['body']['tags'][_0xadae('0x4e')](';')+';';}else{_0x3d7ad1[_0xadae('0x2f')][_0xadae('0x22')]=null;}}else{_0x3d7ad1[_0xadae('0x2f')][_0xadae('0x22')]=null;}if(!_[_0xadae('0x4f')](_0x3d7ad1[_0xadae('0x2f')][_0xadae('0x50')])){var _0x3d86dc=_0x3d7ad1[_0xadae('0x2f')]['dialTimezone'];if(!_[_0xadae('0x4f')](shared[_0xadae('0x51')][_0x3d86dc]))_0x3d7ad1['body']['utcOffset']=shared[_0xadae('0x51')][_0x3d86dc][_0xadae('0x52')];}return db[_0xadae('0x20')][_0xadae('0x39')](_0x3d7ad1[_0xadae('0x2f')],{'fields':_[_0xadae('0x23')](_0x4d1797),'raw':!![]});})[_0xadae('0x14')](function(_0xcc9ab3){if(_0x3d7ad1[_0xadae('0x2f')][_0xadae('0x53')]){return insertAdditionalPhones(_0xcc9ab3,_0x3d7ad1[_0xadae('0x2f')][_0xadae('0x53')]);}else{return _0xcc9ab3;}})[_0xadae('0x14')](respondWithResult(_0x1174b1,0xc9))[_0xadae('0x1f')](handleError(_0x1174b1,null));};exports[_0xadae('0x54')]=function(_0x227575,_0x18173b){var _0x3a5092=0x0;var _0x4a51ba=0x0;var _0x3bce7a=0x0;var _0x5426e7=[];return db[_0xadae('0x20')][_0xadae('0x1b')]()[_0xadae('0x14')](function(_0x4ee379){return BPromise[_0xadae('0x55')](_0x227575[_0xadae('0x2f')],function(_0x29fac6){var _0x56d7f0={'where':{'$or':[]},'defaults':_0x29fac6,'fields':_[_0xadae('0x23')](_0x4ee379),'raw':!![]};if(_0x29fac6['duplicates']){for(var _0x20f1de=0x0;_0x20f1de<_0x29fac6[_0xadae('0x56')][_0xadae('0x24')];_0x20f1de++){var _0x3d7ca1={};_0x3d7ca1[_0x29fac6[_0xadae('0x56')][_0x20f1de]]=_0x29fac6[_0x29fac6[_0xadae('0x56')][_0x20f1de]];_0x56d7f0[_0xadae('0x57')]['$or'][_0xadae('0x58')](_0x3d7ca1);}_0x56d7f0[_0xadae('0x57')][_0xadae('0x59')]=_0x29fac6[_0xadae('0x59')];}return db['CmContact'][_0xadae('0x5a')](_0x56d7f0)['spread'](function(_0x7a02fa,_0x35e44f){if(_0x35e44f){if(_0x29fac6[_0xadae('0x2d')]('additionalPhones')){_0x5426e7[_0xadae('0x58')]({'contact':_0x7a02fa,'additionalPhones':_0x29fac6[_0xadae('0x53')]});}_0x3a5092++;}else{_0x3bce7a++;}})[_0xadae('0x1f')](function(){_0x4a51ba++;});});})['then'](function(_0x396297){if(_0x396297){if(_0x5426e7[_0xadae('0x24')]>0x0){return new Promise(function(_0x5ef385){var _0x553fc7=[];for(var _0x118a73=0x0;_0x118a73<_0x5426e7[_0xadae('0x24')];_0x118a73++){_0x553fc7[_0xadae('0x58')](insertAdditionalPhones(_0x5426e7[_0x118a73][_0xadae('0x5b')],_0x5426e7[_0x118a73][_0xadae('0x53')]));}Promise[_0xadae('0x5c')](_0x553fc7)[_0xadae('0x14')](function(){_0x5ef385(0x1);});})['then'](function(){return{'success':_0x3a5092,'failure':_0x4a51ba,'duplicates':_0x3bce7a};});}else{return{'success':_0x3a5092,'failure':_0x4a51ba,'duplicates':_0x3bce7a};}}})['then'](respondWithResult(_0x18173b,0xc9))[_0xadae('0x1f')](handleError(_0x18173b,null));};exports['show']=function(_0x171a5c,_0x1f2c0d){var _0x3824c4;return db[_0xadae('0x20')][_0xadae('0x1b')]()[_0xadae('0x14')](function(_0x43179a){return db[_0xadae('0x20')][_0xadae('0x21')]({'where':{'id':_0x171a5c[_0xadae('0x5d')]['id']},'include':[{'model':db[_0xadae('0x5e')],'as':_0xadae('0x5f'),'attributes':['id',_0xadae('0x19'),_0xadae('0x60')],'required':_0x171a5c[_0xadae('0x1d')]['tag']?!![]:![]},{'model':db['CmContactHasItem'],'as':_0xadae('0x61'),'where':{'CmContactId':_0x171a5c[_0xadae('0x5d')]['id']},'required':![],'include':[{'model':db[_0xadae('0x62')],'as':_0xadae('0x63')}]}],'order':[db[_0xadae('0x64')][_0xadae('0x65')](_0xadae('0x66'))],'attributes':_[_0xadae('0x23')](_0x43179a)});})[_0xadae('0x14')](function(_0x470eaf){if(!_[_0xadae('0x4f')](_0x470eaf)){_0x3824c4=_0x470eaf[_0xadae('0x31')]({'plain':!![]});var _0x26d23a={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x470eaf&&_0x470eaf[_0xadae('0x59')]){if(_0x470eaf[_0xadae('0x59')]){_0x26d23a[_0xadae('0x57')]['$and']['push']({'ListId':{'$ne':_0x470eaf[_0xadae('0x59')]}});}}return db[_0xadae('0x67')][_0xadae('0x28')](_0x26d23a);}})['then'](function(_0xd2b53e){if(!_[_0xadae('0x4f')](_0xd2b53e)){return _[_0xadae('0x68')](_0x3824c4,_[_0xadae('0x69')](_0xd2b53e,function(_0x5a344a){return util[_0xadae('0x6a')](_0xadae('0x6b'),_0x5a344a['id']);}));}})[_0xadae('0x14')](handleEntityNotFound(_0x1f2c0d,null))[_0xadae('0x14')](respondWithResult(_0x1f2c0d,null))[_0xadae('0x1f')](handleError(_0x1f2c0d,null));};exports['update']=function(_0x1d9211,_0x45039a){var _0x1941e9;if(_0x1d9211[_0xadae('0x2f')]['id']){delete _0x1d9211[_0xadae('0x2f')]['id'];}if(!_[_0xadae('0x4f')](_0x1d9211['body']['dialTimezone'])){var _0x51f046=_0x1d9211[_0xadae('0x2f')]['dialTimezone'];if(!_['isNil'](shared[_0xadae('0x51')][_0x51f046]))_0x1d9211[_0xadae('0x2f')][_0xadae('0x52')]=shared[_0xadae('0x51')][_0x51f046]['utcOffset'];}return db[_0xadae('0x20')][_0xadae('0x21')]({'where':{'id':_0x1d9211[_0xadae('0x5d')]['id']}})[_0xadae('0x14')](handleEntityNotFound(_0x45039a,null))[_0xadae('0x14')](saveUpdates(_0x1d9211[_0xadae('0x2f')],null))[_0xadae('0x14')](function(_0x26c7cf){_0x1941e9=_0x26c7cf;var _0x3e14ba={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x26c7cf&&_0x26c7cf[_0xadae('0x59')]){if(_0x26c7cf[_0xadae('0x59')]){_0x3e14ba[_0xadae('0x57')][_0xadae('0x6c')][_0xadae('0x58')]({'ListId':{'$ne':_0x26c7cf[_0xadae('0x59')]}});}}return db['CmCustomField']['findAll'](_0x3e14ba);})[_0xadae('0x14')](function(_0x417a18){if(_0x417a18){return _[_0xadae('0x68')](_[_0xadae('0x6d')](_0x1d9211[_0xadae('0x2f')],function(_0x17e3ee,_0x196b6e){return _[_0xadae('0x25')](_0x196b6e,'cf_');}),_[_0xadae('0x69')](_0x417a18,function(_0x8c12ad){return util['format'](_0xadae('0x6b'),_0x8c12ad['id']);}));}})[_0xadae('0x14')](function(_0x1cc4f8){if(_0x1cc4f8&&!_[_0xadae('0x6e')](_0x1cc4f8)){var _0x2ce668=squel['update']()[_0xadae('0x6f')]('cm_contacts')[_0xadae('0x70')](_0x1cc4f8)[_0xadae('0x57')]('id\x20=\x20?',_0x1d9211[_0xadae('0x5d')]['id'])['toParam']();return db[_0xadae('0x64')][_0xadae('0x1d')](_0x2ce668[_0xadae('0x71')],{'replacements':_0x2ce668[_0xadae('0x72')]});}})[_0xadae('0x14')](function(){if(_0x1d9211[_0xadae('0x2f')]['phone']&&_0x1941e9){return db[_0xadae('0x36')][_0xadae('0x13')]({'phone':_0x1d9211[_0xadae('0x2f')]['phone'],'OrderBy':0x0},{'where':{'ContactId':_0x1941e9['id']}});}})[_0xadae('0x14')](function(){return _0x1941e9;})[_0xadae('0x14')](respondWithResult(_0x45039a,null))[_0xadae('0x1f')](handleError(_0x45039a,null));};exports[_0xadae('0x73')]=function(_0x1649ca,_0x3c8fa6){var _0x2cd694={};var _0x175350={};var _0x46ff15;var _0x1bc7b2;return db[_0xadae('0x20')][_0xadae('0x74')]({'where':{'id':_0x1649ca[_0xadae('0x5d')]['id']}})[_0xadae('0x14')](handleEntityNotFound(_0x3c8fa6,null))[_0xadae('0x14')](function(_0x4a0b4e){if(_0x4a0b4e){_0x46ff15=_0x4a0b4e;_0x175350['model']=_[_0xadae('0x23')](db[_0xadae('0x5e')][_0xadae('0x75')]);_0x175350['query']=_[_0xadae('0x23')](_0x1649ca[_0xadae('0x1d')]);_0x175350[_0xadae('0x76')]=_[_0xadae('0x77')](_0x175350[_0xadae('0x78')],_0x175350[_0xadae('0x1d')]);_0x2cd694[_0xadae('0x79')]=_['intersection'](_0x175350[_0xadae('0x78')],qs[_0xadae('0x7a')](_0x1649ca[_0xadae('0x1d')][_0xadae('0x7a')]));_0x2cd694[_0xadae('0x79')]=_0x2cd694[_0xadae('0x79')][_0xadae('0x24')]?_0x2cd694[_0xadae('0x79')]:_0x175350[_0xadae('0x78')];_0x2cd694[_0xadae('0x7b')]=qs[_0xadae('0x7c')](_0x1649ca['query'][_0xadae('0x7c')]);_0x2cd694['where']=qs[_0xadae('0x76')](_[_0xadae('0x7d')](_0x1649ca[_0xadae('0x1d')],_0x175350['filters']));if(_0x1649ca[_0xadae('0x1d')][_0xadae('0x7e')]){_0x2cd694['where']=_[_0xadae('0x2e')](_0x2cd694[_0xadae('0x57')],{'$or':_[_0xadae('0x69')](_0x2cd694[_0xadae('0x79')],function(_0x1aed26){var _0x201977={};_0x201977[_0x1aed26]={'$like':'%'+_0x1649ca[_0xadae('0x1d')][_0xadae('0x7e')]+'%'};return _0x201977;})});}_0x2cd694=_[_0xadae('0x2e')]({},_0x2cd694,_0x1649ca['options']);return _0x46ff15[_0xadae('0x73')](_0x2cd694);}})[_0xadae('0x14')](function(_0xf3fba7){if(_0xf3fba7){_0x1bc7b2=_0xf3fba7[_0xadae('0x24')];if(!_0x1649ca[_0xadae('0x1d')][_0xadae('0x2d')](_0xadae('0x7f'))){_0x2cd694['limit']=qs[_0xadae('0x80')](_0x1649ca[_0xadae('0x1d')][_0xadae('0x80')]);_0x2cd694[_0xadae('0x10')]=qs[_0xadae('0x10')](_0x1649ca[_0xadae('0x1d')]['offset']);}return _0x46ff15[_0xadae('0x73')](_0x2cd694);}})[_0xadae('0x14')](function(_0x2e924f){if(_0x2e924f){return _0x2e924f?{'count':_0x1bc7b2,'rows':_0x2e924f}:null;}})['then'](respondWithResult(_0x3c8fa6,null))[_0xadae('0x1f')](handleError(_0x3c8fa6,null));};exports[_0xadae('0x81')]=function(_0xe7af06,_0xde2f60){if(_0xe7af06[_0xadae('0x2f')]['id']){delete _0xe7af06[_0xadae('0x2f')]['id'];}return db[_0xadae('0x20')][_0xadae('0x74')]({'where':{'id':_0xe7af06[_0xadae('0x5d')]['id']}})[_0xadae('0x14')](handleEntityNotFound(_0xde2f60,null))[_0xadae('0x14')](function(_0x48e692){if(_0x48e692){return _0x48e692[_0xadae('0x81')](_0xe7af06['body']['ids']||[]);}return null;})['then'](respondWithResult(_0xde2f60,null))['catch'](handleError(_0xde2f60,null));};exports['setAdditionalPhones']=function(_0x1c4ddd,_0x7b1b67){var _0x3886f4=[];_0x3886f4[_0xadae('0x58')](addAdditionalPhones(_0x1c4ddd['body']));Promise[_0xadae('0x5c')](_0x3886f4)[_0xadae('0x14')](function(){_0x3886f4=[];_0x3886f4[_0xadae('0x58')](deleteCmHopperPhones(_0x1c4ddd[_0xadae('0x2f')]['id']));_0x3886f4[_0xadae('0x58')](addCmHopperPhones(_0x1c4ddd['body']['id']));Promise[_0xadae('0x5c')](_0x3886f4)[_0xadae('0x14')](function(){return[0x1];})[_0xadae('0x14')](respondWithResult(_0x7b1b67,null));});};function addAdditionalPhones(_0x182b80){var _0x13e75c;return new Promise(function(_0x66ecb1){return db['CmContactHasItem'][_0xadae('0x37')]({'where':{'CmContactId':_0x182b80['id']}})[_0xadae('0x14')](function(){db[_0xadae('0x62')]['findAll']({'raw':!![],'attributes':['id',_0xadae('0x82')]})[_0xadae('0x14')](function(_0x19b606){var _0x5f1619=[];for(var _0x20389f=0x0;_0x20389f<_0x182b80[_0xadae('0x83')][_0xadae('0x24')];_0x20389f++){var _0x530b0c=_0x182b80[_0xadae('0x84')]?_[_0xadae('0x4f')](_0x182b80[_0xadae('0x84')][_0x20389f])?'':_0x182b80[_0xadae('0x84')][_0x20389f]:_0x182b80['items'][_0x20389f][_0xadae('0x85')]?_0x182b80[_0xadae('0x83')][_0x20389f][_0xadae('0x85')]:'';var _0x24828a=_[_0xadae('0x4f')](_0x182b80[_0xadae('0x83')][_0x20389f]['description'])?'':_0x182b80[_0xadae('0x83')][_0x20389f][_0xadae('0x86')];var _0xf82bcb=_0x530b0c+':'+_0x182b80[_0xadae('0x83')][_0x20389f]['phone']+'ยง'+_0x24828a;if(_[_0xadae('0x4f')](_0x13e75c))_0x13e75c=_0xf82bcb;else _0x13e75c+=';'+_0xf82bcb;var _0xfa01b6=null;var _0x4ca0b1=null;if(_0x182b80[_0xadae('0x84')]){if(!_[_0xadae('0x4f')](_0x182b80[_0xadae('0x84')][_0x20389f])){_0x4ca0b1=_[_0xadae('0x21')](_0x19b606,function(_0x4fc208){return _0x4fc208['id']===_0x182b80[_0xadae('0x84')][_0x20389f];});if(!_[_0xadae('0x4f')](_0x4ca0b1)){_0xfa01b6=_0x4ca0b1['OrderBy'];}}}else{if(!_[_0xadae('0x4f')](_0x182b80[_0xadae('0x83')][_0x20389f])){_0x4ca0b1=_['find'](_0x19b606,function(_0x21b55a){return _0x21b55a['id']===_0x182b80[_0xadae('0x83')][_0x20389f][_0xadae('0x85')];});if(!_[_0xadae('0x4f')](_0x4ca0b1)){_0xfa01b6=_0x20389f;}}}if(_[_0xadae('0x4f')](_0xfa01b6)){_0xfa01b6=0x64;}_0x5f1619[_0xadae('0x58')](addAdditionalPhone(_0x182b80['id'],_0x182b80[_0xadae('0x83')][_0x20389f]['phone'],_0x182b80[_0xadae('0x84')]?_[_0xadae('0x4f')](_0x182b80[_0xadae('0x84')][_0x20389f])?null:_0x182b80[_0xadae('0x84')][_0x20389f]:_0x182b80[_0xadae('0x83')][_0x20389f][_0xadae('0x85')]?_0x182b80[_0xadae('0x83')][_0x20389f]['ItemTypeId']:null,_0xfa01b6,_0x24828a));}Promise[_0xadae('0x5c')](_0x5f1619)[_0xadae('0x14')](function(){db['CmContact'][_0xadae('0x13')]({'AdditionalPhones':_0x13e75c},{'where':{'id':_0x182b80['id']}})[_0xadae('0x14')](function(){_0x66ecb1(0x1);});});});});});}function addAdditionalPhone(_0x402fec,_0xc2a668,_0xdbc80e,_0x1f0744,_0x460a48){return db[_0xadae('0x43')][_0xadae('0x21')]({'where':{'CmContactId':_0x402fec,'item':_0xc2a668}})[_0xadae('0x14')](function(_0x3c3231){if(_0x3c3231)logger[_0xadae('0x34')](_0xadae('0x87'),_0x3c3231);else{db[_0xadae('0x43')][_0xadae('0x39')]({'CmContactId':_0x402fec,'item':_0xc2a668,'ItemTypeId':_0xdbc80e,'OrderBy':_0x1f0744,'ItemClass':_0xadae('0x88'),'description':_0x460a48});}});}function deleteCmHopperPhones(_0x2d01dd){return new Promise(function(_0x35cea2){return db['CmHopper']['findAll']({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x2d01dd}})['then'](function(_0x44b05d){db[_0xadae('0x89')][_0xadae('0x37')]({'where':{'CmHopperId':{'$in':_[_0xadae('0x69')](_0x44b05d,'id')}}});})[_0xadae('0x14')](function(){_0x35cea2(0x1);});});}function addCmHopperPhones(_0x470612){return new Promise(function(_0x596d4d){return db[_0xadae('0x36')][_0xadae('0x28')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x470612}})[_0xadae('0x14')](function(_0x1b2479){var _0x1b3b79=[];_[_0xadae('0x69')](_0x1b2479,function(_0x348d0d){_0x1b3b79[_0xadae('0x58')](createCmHopperPhone(_0x470612,_0x348d0d['id']));});Promise[_0xadae('0x5c')](_0x1b3b79)[_0xadae('0x14')](function(){_0x596d4d(0x1);});});});}function createCmHopperPhone(_0x4fdbd0,_0x49108e){return new Promise(function(_0x10de56){db[_0xadae('0x43')][_0xadae('0x28')]({'raw':!![],'attributes':[_0xadae('0x8a'),'OrderBy'],'where':{'CmContactId':_0x4fdbd0,'ItemClass':_0xadae('0x88')},'include':[{'model':db[_0xadae('0x62')],'attributes':[_0xadae('0x82')],'as':_0xadae('0x63')}],'order':['OrderBy',db['sequelize'][_0xadae('0x65')](_0xadae('0x8b'))]})[_0xadae('0x14')](function(_0x5cf982){var _0xb8ed3c=0x1;var _0x555937=_[_0xadae('0x69')](_0x5cf982,function(_0x42ba87){_0x42ba87[_0xadae('0x8c')]=_0x49108e;_0x42ba87[_0xadae('0x8d')]=_0x42ba87[_0xadae('0x8a')];_0x42ba87['OrderBy']=_0xb8ed3c;delete _0x42ba87[_0xadae('0x8e')];_0xb8ed3c=_0xb8ed3c+0x1;return _0x42ba87;});return db['CmHopperAdditionalPhone']['bulkCreate'](_0x555937,{});})[_0xadae('0x14')](function(){_0x10de56(0x1);});});}function insertAdditionalPhones(_0x37ff7d,_0x382610){return new Promise(function(_0x5d9f09){var _0x217ec2=[];for(var _0x29bb14=0x0;_0x29bb14<_0x382610['length'];_0x29bb14++){var _0x330504=_0x382610[_0x29bb14];_0x217ec2[_0xadae('0x58')](parseContactItemType(_0x330504));}Promise['all'](_0x217ec2)['then'](function(){var _0x5201d1={'id':_0x37ff7d['id'],'items':_0x382610};return addAdditionalPhones(_0x5201d1)[_0xadae('0x14')](function(){return addCmHopperPhones(_0x37ff7d['id']);});})[_0xadae('0x14')](function(){_0x5d9f09(_0x37ff7d);});});}function parseContactItemType(_0x2480ba){return new Promise(function(_0x3ed86c){if(_0x2480ba[_0xadae('0x2d')](_0xadae('0x85'))){_0x3ed86c(_0x2480ba);}else{return db[_0xadae('0x62')][_0xadae('0x21')]({'where':{'name':_0x2480ba[_0xadae('0x63')]}})[_0xadae('0x14')](function(_0x513f2e){if(_[_0xadae('0x4f')](_0x513f2e))_0x2480ba['ItemTypeId']=null;else _0x2480ba[_0xadae('0x85')]=_0x513f2e['id'];_0x3ed86c(_0x2480ba);});}});}exports['getAdditionalPhones']=function(_0x1c6694,_0x15fac1){return db['CmContactHasItem'][_0xadae('0x28')]({'raw':!![],'where':{'CmContactId':_0x1c6694[_0xadae('0x5d')]['id'],'ItemClass':'PHONE'},'include':[{'model':db[_0xadae('0x62')],'as':_0xadae('0x63')}],'order':[[_0xadae('0x82')],[db[_0xadae('0x64')][_0xadae('0x65')](_0xadae('0x8b'))]]})[_0xadae('0x14')](function(_0x1a9532){return _0x1a9532;})['then'](respondWithResult(_0x15fac1,null))[_0xadae('0x1f')](handleError(_0x15fac1,null));};exports[_0xadae('0x8f')]=function(_0x39fc7e,_0x2e0af3){return db[_0xadae('0x43')][_0xadae('0x28')]({'raw':!![],'where':{'CmContactId':_0x39fc7e[_0xadae('0x2f')]['fromContactId']}})[_0xadae('0x14')](function(_0xfcfe8){var _0x2cee3c=_[_0xadae('0x69')](_0xfcfe8,function(_0x570b1a){_0x570b1a[_0xadae('0x90')]=_0x39fc7e[_0xadae('0x2f')][_0xadae('0x91')];return _0x570b1a;});return db['CmContactHasItem'][_0xadae('0x54')](_0x2cee3c,{});})[_0xadae('0x14')](function(){return addCmHopperPhones(_0x39fc7e['body'][_0xadae('0x91')]);})[_0xadae('0x14')](function(){return['ok'];})['then'](respondWithResult(_0x2e0af3,null))['catch'](handleError(_0x2e0af3,null));};exports[_0xadae('0x92')]=function(_0x48bf27,_0x5022e9){var _0x36df16=[];_0x36df16[_0xadae('0x58')](createCmHopperPhone(_0x48bf27['body']['id'],_0x48bf27[_0xadae('0x2f')][_0xadae('0x93')]));Promise['all'](_0x36df16)[_0xadae('0x14')](function(){return[0x1];})['then'](respondWithResult(_0x5022e9,null));};exports['getHoppers']=function(_0x187485,_0x20c8ee){var _0x4dcdb1={'raw':![],'where':{}};var _0x356b44={};var _0x4add9a={'count':0x0,'rows':[]};return db[_0xadae('0x20')][_0xadae('0x74')]({'where':{'id':_0x187485['params']['id']}})[_0xadae('0x14')](handleEntityNotFound(_0x20c8ee,null))[_0xadae('0x14')](function(_0x4bd822){if(_0x4bd822){_0x356b44[_0xadae('0x78')]=_[_0xadae('0x23')](db[_0xadae('0x36')][_0xadae('0x75')]);_0x356b44['query']=_[_0xadae('0x23')](_0x187485[_0xadae('0x1d')]);_0x356b44['filters']=_[_0xadae('0x77')](_0x356b44[_0xadae('0x78')],_0x356b44[_0xadae('0x1d')]);_0x4dcdb1[_0xadae('0x79')]=_[_0xadae('0x77')](_0x356b44[_0xadae('0x78')],qs[_0xadae('0x7a')](_0x187485[_0xadae('0x1d')][_0xadae('0x7a')]));_0x4dcdb1['attributes']=_0x4dcdb1[_0xadae('0x79')][_0xadae('0x24')]?_0x4dcdb1[_0xadae('0x79')]:_0x356b44[_0xadae('0x78')];if(!_0x187485[_0xadae('0x1d')][_0xadae('0x2d')](_0xadae('0x7f'))){_0x4dcdb1[_0xadae('0x80')]=qs[_0xadae('0x80')](_0x187485['query'][_0xadae('0x80')]);_0x4dcdb1[_0xadae('0x10')]=qs[_0xadae('0x10')](_0x187485[_0xadae('0x1d')]['offset']);}_0x4dcdb1[_0xadae('0x7b')]=qs[_0xadae('0x7c')](_0x187485[_0xadae('0x1d')][_0xadae('0x7c')]);_0x4dcdb1[_0xadae('0x57')]=qs['filters'](_['pick'](_0x187485['query'],_0x356b44[_0xadae('0x76')]));_0x4dcdb1[_0xadae('0x57')][_0xadae('0x94')]=_0x4bd822['id'];if(_0x187485[_0xadae('0x1d')][_0xadae('0x7e')]){_0x4dcdb1['where']=_['merge'](_0x4dcdb1[_0xadae('0x57')],{'$or':_[_0xadae('0x69')](_0x4dcdb1[_0xadae('0x79')],function(_0x49f287){var _0x50679d={};_0x50679d[_0x49f287]={'$like':'%'+_0x187485[_0xadae('0x1d')]['filter']+'%'};return _0x50679d;})});}_0x4dcdb1=_[_0xadae('0x2e')]({},_0x4dcdb1,_0x187485[_0xadae('0x95')]);return db[_0xadae('0x36')][_0xadae('0x12')]({'where':_0x4dcdb1[_0xadae('0x57')]})[_0xadae('0x14')](function(_0x4315ed){_0x4add9a[_0xadae('0x12')]=_0x4315ed;if(_0x187485[_0xadae('0x1d')]['includeAll']){_0x4dcdb1[_0xadae('0x96')]=[{'all':!![]}];}return db[_0xadae('0x36')][_0xadae('0x28')](_0x4dcdb1);})[_0xadae('0x14')](function(_0x55c2c4){_0x4add9a['rows']=_0x55c2c4;return _0x4add9a;});}})[_0xadae('0x14')](respondWithFilteredResult(_0x20c8ee,_0x4dcdb1))[_0xadae('0x1f')](handleError(_0x20c8ee,null));};exports[_0xadae('0x97')]=function(_0xaff9e6,_0x4f5471){var _0x20890f={'raw':!![],'where':{}};var _0x3ae0db={};var _0x4f52a6={'count':0x0,'rows':[]};return db['CmContact']['findOne']({'where':{'id':_0xaff9e6[_0xadae('0x5d')]['id']}})[_0xadae('0x14')](handleEntityNotFound(_0x4f5471,null))[_0xadae('0x14')](function(_0x3a2242){if(_0x3a2242){_0x3ae0db['model']=_['keys'](db[_0xadae('0x45')][_0xadae('0x75')]);_0x3ae0db[_0xadae('0x1d')]=_['keys'](_0xaff9e6['query']);_0x3ae0db[_0xadae('0x76')]=_[_0xadae('0x77')](_0x3ae0db[_0xadae('0x78')],_0x3ae0db[_0xadae('0x1d')]);_0x20890f[_0xadae('0x79')]=_[_0xadae('0x77')](_0x3ae0db[_0xadae('0x78')],qs[_0xadae('0x7a')](_0xaff9e6[_0xadae('0x1d')][_0xadae('0x7a')]));_0x20890f[_0xadae('0x79')]=_0x20890f['attributes'][_0xadae('0x24')]?_0x20890f[_0xadae('0x79')]:_0x3ae0db['model'];if(!_0xaff9e6[_0xadae('0x1d')][_0xadae('0x2d')](_0xadae('0x7f'))){_0x20890f['limit']=qs[_0xadae('0x80')](_0xaff9e6['query'][_0xadae('0x80')]);_0x20890f[_0xadae('0x10')]=qs[_0xadae('0x10')](_0xaff9e6[_0xadae('0x1d')][_0xadae('0x10')]);}_0x20890f['order']=qs['sort'](_0xaff9e6[_0xadae('0x1d')]['sort']);_0x20890f[_0xadae('0x57')]=qs[_0xadae('0x76')](_[_0xadae('0x7d')](_0xaff9e6['query'],_0x3ae0db[_0xadae('0x76')]));_0x20890f[_0xadae('0x57')][_0xadae('0x94')]=_0x3a2242['id'];if(_0xaff9e6[_0xadae('0x1d')][_0xadae('0x7e')]){_0x20890f['where']=_[_0xadae('0x2e')](_0x20890f[_0xadae('0x57')],{'$or':_[_0xadae('0x69')](_0x20890f[_0xadae('0x79')],function(_0xb6184f){var _0x7746dc={};_0x7746dc[_0xb6184f]={'$like':'%'+_0xaff9e6[_0xadae('0x1d')][_0xadae('0x7e')]+'%'};return _0x7746dc;})});}_0x20890f=_['merge']({},_0x20890f,_0xaff9e6[_0xadae('0x95')]);return db[_0xadae('0x45')][_0xadae('0x12')]({'where':_0x20890f['where']})[_0xadae('0x14')](function(_0x55395c){_0x4f52a6[_0xadae('0x12')]=_0x55395c;if(_0xaff9e6['query']['includeAll']){_0x20890f[_0xadae('0x96')]=[{'all':!![]}];}return db[_0xadae('0x45')][_0xadae('0x28')](_0x20890f);})[_0xadae('0x14')](function(_0x26e6dc){_0x4f52a6[_0xadae('0x98')]=_0x26e6dc;return _0x4f52a6;});}})[_0xadae('0x14')](respondWithFilteredResult(_0x4f5471,_0x20890f))[_0xadae('0x1f')](handleError(_0x4f5471,null));};exports['getHopperFinals']=function(_0x11c108,_0x19b273){var _0x4512fe={'raw':!![],'where':{}};var _0x43de0a={};var _0x47d4a2={'count':0x0,'rows':[]};return db[_0xadae('0x20')][_0xadae('0x74')]({'where':{'id':_0x11c108[_0xadae('0x5d')]['id']}})['then'](handleEntityNotFound(_0x19b273,null))['then'](function(_0x3a7162){if(_0x3a7162){_0x43de0a[_0xadae('0x78')]=_['keys'](db[_0xadae('0x44')][_0xadae('0x75')]);_0x43de0a[_0xadae('0x1d')]=_['keys'](_0x11c108['query']);_0x43de0a[_0xadae('0x76')]=_[_0xadae('0x77')](_0x43de0a['model'],_0x43de0a[_0xadae('0x1d')]);_0x4512fe['attributes']=_[_0xadae('0x77')](_0x43de0a[_0xadae('0x78')],qs[_0xadae('0x7a')](_0x11c108[_0xadae('0x1d')][_0xadae('0x7a')]));_0x4512fe[_0xadae('0x79')]=_0x4512fe[_0xadae('0x79')][_0xadae('0x24')]?_0x4512fe['attributes']:_0x43de0a[_0xadae('0x78')];if(!_0x11c108[_0xadae('0x1d')][_0xadae('0x2d')](_0xadae('0x7f'))){_0x4512fe[_0xadae('0x80')]=qs[_0xadae('0x80')](_0x11c108['query'][_0xadae('0x80')]);_0x4512fe[_0xadae('0x10')]=qs[_0xadae('0x10')](_0x11c108['query'][_0xadae('0x10')]);}_0x4512fe[_0xadae('0x7b')]=qs[_0xadae('0x7c')](_0x11c108[_0xadae('0x1d')][_0xadae('0x7c')]);_0x4512fe['where']=qs[_0xadae('0x76')](_[_0xadae('0x7d')](_0x11c108[_0xadae('0x1d')],_0x43de0a[_0xadae('0x76')]));_0x4512fe[_0xadae('0x57')][_0xadae('0x94')]=_0x3a7162['id'];if(_0x11c108[_0xadae('0x1d')][_0xadae('0x7e')]){_0x4512fe[_0xadae('0x57')]=_['merge'](_0x4512fe[_0xadae('0x57')],{'$or':_[_0xadae('0x69')](_0x4512fe[_0xadae('0x79')],function(_0x12d060){var _0x487e6a={};_0x487e6a[_0x12d060]={'$like':'%'+_0x11c108[_0xadae('0x1d')][_0xadae('0x7e')]+'%'};return _0x487e6a;})});}_0x4512fe=_['merge']({},_0x4512fe,_0x11c108[_0xadae('0x95')]);return db['CmHopperFinal'][_0xadae('0x12')]({'where':_0x4512fe[_0xadae('0x57')]})[_0xadae('0x14')](function(_0x1b1782){_0x47d4a2[_0xadae('0x12')]=_0x1b1782;if(_0x11c108['query'][_0xadae('0x99')]){_0x4512fe[_0xadae('0x96')]=[{'all':!![]}];}return db[_0xadae('0x44')][_0xadae('0x28')](_0x4512fe);})[_0xadae('0x14')](function(_0x5f2db0){_0x47d4a2['rows']=_0x5f2db0;return _0x47d4a2;});}})[_0xadae('0x14')](respondWithFilteredResult(_0x19b273,_0x4512fe))[_0xadae('0x1f')](handleError(_0x19b273,null));};exports[_0xadae('0x9a')]=function(_0x1e14a5,_0x1fe72b){var _0x4c5327={'raw':!![],'where':{}};var _0x4c9b21={};var _0x27abf1={'count':0x0,'rows':[]};return db['CmContact'][_0xadae('0x74')]({'where':{'id':_0x1e14a5[_0xadae('0x5d')]['id']}})[_0xadae('0x14')](handleEntityNotFound(_0x1fe72b,null))['then'](function(_0x537666){if(_0x537666){_0x4c9b21[_0xadae('0x78')]=_['keys'](db['JscriptySessionReport']['rawAttributes']);_0x4c9b21[_0xadae('0x1d')]=_['keys'](_0x1e14a5[_0xadae('0x1d')]);_0x4c9b21['filters']=_[_0xadae('0x77')](_0x4c9b21[_0xadae('0x78')],_0x4c9b21['query']);_0x4c5327[_0xadae('0x79')]=_[_0xadae('0x77')](_0x4c9b21['model'],qs[_0xadae('0x7a')](_0x1e14a5[_0xadae('0x1d')][_0xadae('0x7a')]));_0x4c5327['attributes']=_0x4c5327[_0xadae('0x79')]['length']?_0x4c5327[_0xadae('0x79')]:_0x4c9b21['model'];if(!_0x1e14a5['query'][_0xadae('0x2d')](_0xadae('0x7f'))){_0x4c5327[_0xadae('0x80')]=qs[_0xadae('0x80')](_0x1e14a5[_0xadae('0x1d')][_0xadae('0x80')]);_0x4c5327[_0xadae('0x10')]=qs[_0xadae('0x10')](_0x1e14a5[_0xadae('0x1d')][_0xadae('0x10')]);}_0x4c5327[_0xadae('0x7b')]=qs[_0xadae('0x7c')](_0x1e14a5[_0xadae('0x1d')][_0xadae('0x7c')]);_0x4c5327[_0xadae('0x57')]=qs['filters'](_[_0xadae('0x7d')](_0x1e14a5[_0xadae('0x1d')],_0x4c9b21['filters']));_0x4c5327[_0xadae('0x57')]['ContactId']=_0x537666['id'];if(_0x1e14a5[_0xadae('0x1d')]['filter']){_0x4c5327['where']=_[_0xadae('0x2e')](_0x4c5327['where'],{'$or':_[_0xadae('0x69')](_0x4c5327[_0xadae('0x79')],function(_0x438ca1){var _0x4d0b66={};_0x4d0b66[_0x438ca1]={'$like':'%'+_0x1e14a5['query'][_0xadae('0x7e')]+'%'};return _0x4d0b66;})});}_0x4c5327=_[_0xadae('0x2e')]({},_0x4c5327,_0x1e14a5['options']);return db[_0xadae('0x4b')][_0xadae('0x12')]({'where':_0x4c5327[_0xadae('0x57')]})[_0xadae('0x14')](function(_0xf69475){_0x27abf1['count']=_0xf69475;if(_0x1e14a5[_0xadae('0x1d')][_0xadae('0x99')]){_0x4c5327[_0xadae('0x96')]=[{'all':!![]}];}return db[_0xadae('0x4b')]['findAll'](_0x4c5327);})[_0xadae('0x14')](function(_0x137a3d){_0x27abf1[_0xadae('0x98')]=_0x137a3d;return _0x27abf1;});}})[_0xadae('0x14')](respondWithFilteredResult(_0x1fe72b,_0x4c5327))['catch'](handleError(_0x1fe72b,null));};exports['uploadCsv']=function(_0x5378e3,_0x1d9471){try{if(!_0x5378e3[_0xadae('0x2f')][_0xadae('0x59')]){throw new Error(_0xadae('0x9b'));}if(!_0x5378e3[_0xadae('0x2f')][_0xadae('0x9c')]){throw new Error('No\x20association\x20keys\x20specified!');}if(!_0x5378e3['body']['binding_values']){throw new Error(_0xadae('0x9d'));}if(!_0x5378e3[_0xadae('0x2f')][_0xadae('0x9e')]){throw new Error(_0xadae('0x9f'));}var _0x6e78f1=_0x5378e3[_0xadae('0x2f')]['binding_keys']['split'](',');var _0x396fed=_0x5378e3['body'][_0xadae('0xa0')]['split'](',');if(!_0x6e78f1[_0xadae('0x24')]||!_0x396fed[_0xadae('0x24')]||_0x6e78f1[_0xadae('0x24')]!==_0x396fed['length']){throw new Error(_0xadae('0xa1'));}_0x5378e3[_0xadae('0x2f')][_0xadae('0x7a')]=_[_0xadae('0xa2')](_0x6e78f1,_0x396fed);if(!_0x5378e3[_0xadae('0x2f')]['fields'][_0xadae('0x8d')]){throw new Error(_0xadae('0xa3'));}if(!_0x5378e3[_0xadae('0x2f')][_0xadae('0x7a')][_0xadae('0xa4')]){throw new Error(_0xadae('0xa5'));}var _0x15114e=path[_0xadae('0x4e')](config[_0xadae('0xa6')],_0xadae('0xa7'),_0x5378e3[_0xadae('0xa8')][_0xadae('0xa9')]);fs[_0xadae('0xaa')](_0x15114e,parseInt(_0xadae('0xab'),0x8));var _0x4104f3=require('child_process')[_0xadae('0xac')](path[_0xadae('0x4e')](__dirname,_0xadae('0xad')),[_0x15114e,_0x5378e3['body'][_0xadae('0x9c')],_0x5378e3[_0xadae('0x2f')][_0xadae('0xa0')],_0x5378e3[_0xadae('0x2f')][_0xadae('0x59')],_0x5378e3['body'][_0xadae('0xae')],_0x5378e3[_0xadae('0x2f')][_0xadae('0x56')],_0x5378e3['body']['socket_timestamp']]);return _0x1d9471[_0xadae('0xe')](0xc8)['json']({'message':_0xadae('0xaf'),'pid':_0x4104f3[_0xadae('0xb0')]});}catch(_0x1e442f){return _0x1d9471[_0xadae('0xe')](0x1f4)['send'](_0x1e442f);}};exports[_0xadae('0xb1')]=function(_0xfa0f,_0x53711c){var _0xd17f4b=fs[_0xadae('0xb2')](_0xfa0f['file'][_0xadae('0x1')]);Papa['parse'](_0xd17f4b,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x1c8277){return _0x53711c[_0xadae('0xe')](0xc8)['json']({'file':_0xfa0f[_0xadae('0xa8')],'fields':_0x1c8277[_0xadae('0xb3')]['fields']});}});};exports['import']=function(_0x46df16,_0x374ef2){return db[_0xadae('0xb4')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0xadae('0xb5')}})[_0xadae('0x14')](function(_0x472756){var _0x3acee7=![];if(!_0x46df16[_0xadae('0x2f')][_0xadae('0x59')]){throw new Error(_0xadae('0x9b'));}if(!_0x46df16[_0xadae('0x2f')][_0xadae('0xb6')][_0xadae('0x8d')]){throw new Error(_0xadae('0xa3'));}if(!_0x46df16[_0xadae('0x2f')]['binding'][_0xadae('0xa4')]){throw new Error(_0xadae('0xa5'));}if(!_0x46df16[_0xadae('0x2f')][_0xadae('0x9e')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x482197=require(_0xadae('0xb7'))[_0xadae('0xac')](path['join'](__dirname,_0xadae('0xb8')),[_0x46df16[_0xadae('0x5d')]['id'],JSON[_0xadae('0xb9')](_0x46df16[_0xadae('0x2f')]),JSON[_0xadae('0xb9')](_0x472756)]);_0x482197['on'](_0xadae('0xba'),function(){_0x3acee7=!![];return _0x374ef2[_0xadae('0xe')](0xc8)['json']({'message':'start\x20child\x20process\x20correctly!','pid':_0x482197[_0xadae('0xb0')]});});_0x482197['on']('exit',function(_0x481fd9){if(_0x481fd9&&!_0x3acee7){return _0x374ef2[_0xadae('0xe')](0x1f4)[_0xadae('0xf')]({'message':_0xadae('0xbb'),'pid':_0x482197[_0xadae('0xb0')]});}});})['catch'](handleError(_0x374ef2,null));};exports['importUpdates']=function(_0x3e5539,_0x487fd9){return db[_0xadae('0xb4')][_0xadae('0x28')]({'raw':!![],'attributes':['id'],'where':{'role':_0xadae('0xb5')}})[_0xadae('0x14')](function(_0x341425){var _0x1b298f=![];if(!_0x3e5539[_0xadae('0x2f')][_0xadae('0x59')]){throw new Error(_0xadae('0x9b'));}if(!_0x3e5539[_0xadae('0x2f')]['binding']['phone']){throw new Error(_0xadae('0xa3'));}if(!_0x3e5539[_0xadae('0x2f')][_0xadae('0xb6')][_0xadae('0xa4')]){throw new Error(_0xadae('0xa5'));}if(!_0x3e5539['body'][_0xadae('0x9e')]){throw new Error(_0xadae('0x9f'));}var _0x33d6fa=require(_0xadae('0xb7'))[_0xadae('0xac')](path[_0xadae('0x4e')](__dirname,_0xadae('0xbc')),[_0x3e5539['params']['id'],JSON[_0xadae('0xb9')](_0x3e5539[_0xadae('0x2f')]),JSON[_0xadae('0xb9')](_0x341425)]);_0x33d6fa['on']('message',function(){_0x1b298f=!![];return _0x487fd9[_0xadae('0xe')](0xc8)[_0xadae('0xf')]({'message':_0xadae('0xbd'),'pid':_0x33d6fa[_0xadae('0xb0')]});});_0x33d6fa['on']('exit',function(_0x4f5e41){if(_0x4f5e41&&!_0x1b298f){return _0x487fd9['status'](0x1f4)[_0xadae('0xf')]({'message':'error\x20child\x20process','pid':_0x33d6fa['pid']});}});})['catch'](handleError(_0x487fd9,null));};exports[_0xadae('0xbe')]=function(_0x2ff949,_0x72e61f){var _0x49ca62=[_0xadae('0xbf'),_0xadae('0xc0'),_0xadae('0xc1'),_0xadae('0xc2'),_0xadae('0xc3'),_0xadae('0xc4'),'voice'];var _0x1fbfcb={'offset':0x0,'order':qs['sort'](_0xadae('0xc5'))},_0x786280={'count':0x0,'rows':[]};Promise['resolve']()[_0xadae('0x14')](function(){if(_0x2ff949['query'][_0xadae('0xc6')]){if(!_[_0xadae('0xc7')](_0x49ca62,_0x2ff949[_0xadae('0x1d')][_0xadae('0xc6')][_0xadae('0xc8')]())){throw new Error(_0xadae('0xc9'));}_0x49ca62=[_0x2ff949[_0xadae('0x1d')]['channel'][_0xadae('0xc8')]()];}if(_0x2ff949[_0xadae('0x1d')][_0xadae('0xca')]){try{var _0x579033=JSON[_0xadae('0xcb')](_0x2ff949[_0xadae('0x1d')][_0xadae('0xca')]);if(!moment(_0x579033['from'])[_0xadae('0xcc')]()){throw new Error(_0xadae('0xcd'));}if(!moment(_0x579033['to'])[_0xadae('0xcc')]()){throw new Error(_0xadae('0xce'));}}catch(_0x4593a9){throw new Error(_0xadae('0xcf'));}}if(!_0x2ff949[_0xadae('0x1d')][_0xadae('0x2d')](_0xadae('0x7f'))){_0x1fbfcb[_0xadae('0x80')]=qs[_0xadae('0x80')](_0x2ff949['query'][_0xadae('0x80')]||0xa);_0x1fbfcb['offset']=qs[_0xadae('0x10')](_0x2ff949[_0xadae('0x1d')][_0xadae('0x10')]);}var _0x2713cb=_0x49ca62[_0xadae('0x69')](function(_0x3a8251){if(_0x3a8251===_0xadae('0xd0')){var _0x4f103f={'attributes':['id',_0xadae('0xd1'),_0xadae('0x2b'),_0xadae('0xd2'),_0xadae('0xd3'),_0xadae('0xd4'),'starttime',_0xadae('0xd5'),'duration',_0xadae('0xd6'),'createdAt',_0xadae('0xd7'),_0xadae('0xd8'),'userThirdDisposition',_0xadae('0xd9')],'where':{'ContactId':_0x2ff949[_0xadae('0x5d')]['id']},'include':[{'model':db[_0xadae('0xb4')],'as':_0xadae('0xb4'),'attributes':['id',_0xadae('0x19'),_0xadae('0xda'),'alias']}],'order':[['createdAt',_0xadae('0xdb')]]};if(_0x2ff949[_0xadae('0x1d')][_0xadae('0xca')]){_0x4f103f[_0xadae('0x57')][_0xadae('0xdc')]={'$gte':_0x579033[_0xadae('0x30')],'$lte':_0x579033['to']};}return db[_0xadae('0x46')][_0xadae('0xdd')](_0x4f103f)[_0xadae('0x14')](function(_0x191e71){_0x786280[_0xadae('0x12')]+=_0x191e71[_0xadae('0x12')];return _[_0xadae('0x69')](_0x191e71['rows'],function(_0x12a92c){var _0x536ef9=_0x12a92c[_0xadae('0x31')]({'plain':!![]});_0x536ef9[_0xadae('0xc6')]=_0x3a8251;if(_0x536ef9[_0xadae('0xb4')]){_0x536ef9[_0xadae('0xb4')]={'id':_0x536ef9[_0xadae('0xb4')]['id'],'name':_0x536ef9['User'][_0xadae('0x19')],'fullname':_0x536ef9[_0xadae('0xb4')][_0xadae('0xda')],'alias':_0x536ef9[_0xadae('0xb4')][_0xadae('0x2a')]};}return _0x536ef9;});});}else{var _0x1620e1=_[_0xadae('0xde')](_0x3a8251)+(_0x3a8251===_0xadae('0xc0')?_0xadae('0xdf'):_0xadae('0xe0'));var _0x401d10={'attributes':['id',_0xadae('0xe1'),_0xadae('0xe2'),_0xadae('0xdc'),_0xadae('0xd6'),_0xadae('0xe3'),_0xadae('0xe4'),_0xadae('0xe5'),'UserId',_0x1620e1+'Id'],'where':{'ContactId':_0x2ff949[_0xadae('0x5d')]['id']},'include':[{'model':db[_0x1620e1],'as':'Account','attributes':['id',_0xadae('0x19'),_0xadae('0xe6')]},{'model':db[_0xadae('0xb4')],'as':'Owner','attributes':['id',_0xadae('0x19'),_0xadae('0xda')]},{'model':db[_0xadae('0x5e')],'as':_0xadae('0x5f'),'attributes':['id','name',_0xadae('0x60')],'through':{'attributes':[]}}],'order':[['createdAt',_0xadae('0xdb')]]};if(_0x2ff949[_0xadae('0x1d')]['range']){_0x401d10[_0xadae('0x57')][_0xadae('0xdc')]={'$gte':_0x579033[_0xadae('0x30')],'$lte':_0x579033['to']};}switch(_0x3a8251){case _0xadae('0xc0'):_0x401d10[_0xadae('0x79')][_0xadae('0x58')]('browserName','customerIp','customerPort',_0xadae('0xe7'),_0xadae('0xe8'),_0xadae('0xe9'),_0xadae('0xea'),'ratingValue',_0xadae('0xeb'));break;case _0xadae('0xbf'):_0x401d10[_0xadae('0x79')][_0xadae('0x58')](_0xadae('0xec'),'substatus');break;case _0xadae('0xc2'):_0x401d10[_0xadae('0x79')][_0xadae('0x58')](_0xadae('0xed'),_0xadae('0xee'));break;}return db[_[_0xadae('0xde')](_0x3a8251)+_0xadae('0xef')][_0xadae('0xdd')](_0x401d10)[_0xadae('0x14')](function(_0x24b116){_0x786280[_0xadae('0x12')]+=_0x24b116[_0xadae('0x12')];return _['map'](_0x24b116[_0xadae('0x98')],function(_0x81826d){var _0x197d28=_0x81826d['get']({'plain':!![]});_0x197d28['channel']=_0x3a8251;if(_0x197d28[_0xadae('0xf0')]){_0x197d28[_0xadae('0xf0')]={'id':_0x197d28[_0xadae('0xf0')]['id'],'name':_0x197d28[_0xadae('0xf0')][_0xadae('0x19')],'fullname':_0x197d28[_0xadae('0xf0')]['fullname']};}return _0x197d28;});});}});return Promise[_0xadae('0x5c')](_0x2713cb);})['then'](function(_0x1c7603){return _(_0x1c7603)[_0xadae('0xf1')]()[_0xadae('0xf2')](_0xadae('0xdc'))[_0xadae('0xf3')]()[_0xadae('0xf4')]();})[_0xadae('0x14')](function(_0x40ecbf){_0x786280[_0xadae('0x98')]=_0x1fbfcb['limit']?_0x40ecbf[_0xadae('0xf5')](_0x1fbfcb[_0xadae('0x10')],_0x1fbfcb[_0xadae('0x10')]+_0x1fbfcb[_0xadae('0x80')]):_0x40ecbf;return _0x786280;})[_0xadae('0x14')](respondWithFilteredResult(_0x72e61f,_0x1fbfcb))[_0xadae('0x1f')](handleError(_0x72e61f,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff