// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x11e7=['limit','count','offset','Content-Range','destroy','sendStatus','error','stack','name','send','index','describe','then','getOptions','findAll','query','user','catch','find','params','CmContact','tags','keys','length','cf_','columnName','displayName','analytics','CmCustomField','custom','type','values','Custom\x20field\x20%s\x20not\x20found\x20on\x20cm_contacts\x20table','forEach','hasOwnProperty','merge','body','from','get','isArray','join','info','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','update','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','FaxMessage','OpenchannelMessage','CmHopperFinal','VoiceCallReport','ChatQueueReport','MailQueueReport','WhatsappMessage','WhatsappQueueReport','isNil','dialTimezone','timezones','utcOffset','additionalPhones','each','duplicates','$or','where','ListId','findOrCreate','spread','push','Tag','color','tag','CmContactHasItem','Phones','ItemType','sequelize','literal','Phones.OrderBy','$and','map','format','cf_%d','pickBy','isEmpty','table','cm_contacts','id\x20=\x20?','toParam','text','phone','getTags','findOne','model','rawAttributes','filters','attributes','intersection','fields','order','sort','filter','nolimit','setTags','ids','setAdditionalPhones','all','ContactItemType','OrderBy','item_types','items','ItemTypeId','description','contact\x20phone\x20exists','PHONE','`ItemType`.OrderBy','CmHopperId','item','ItemType.OrderBy','bulkCreate','getAdditionalPhones','fromContactId','CmContactId','toContactId','rescheduleAdditionalPhones','hopperId','getHoppers','pick','options','includeAll','include','getHopperHistories','CmHopperHistory','rows','getHopperFinals','ContactId','getJscriptySessions','JscriptySessionReport','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','split','zipObject','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','root','file','filename','chmodSync','0777','../../components/import/cm/csv','CompanyId','json','createReadStream','parse','meta','import','User','binding','fork','../../components/import/cm/csv2','stringify','message','pid','exit','error\x20child\x20process','importUpdates','agent','child_process','../../components/import/cm/csvUpdates','start\x20child\x20process\x20correctly!','getJourney','mail','chat','openchannel','fax','voice','channel','includes','toLowerCase','Invalid\x20channel','range','isValid','Invalid\x20date\x20for\x20range\x20from\x20filter','Invalid\x20date\x20for\x20range\x20to\x20filter','Invalid\x20createdAt\x20filter','destination','callerid','starttime','endtime','duration','note','userSecondDisposition','userThirdDisposition','UserId','fullname','DESC','findAndCountAll','alias','startCase','Website','Account','closed','closedAt','disposition','secondDisposition','key','Owner','Tags','createdAt','browserName','customerIp','customerPort','osName','ratingMessage','ratingType','ratingValue','substatus','externalUrl','Interaction','flatten','sortBy','value','slice','bluebird','util','path','lodash','squel','papaparse','../../components/parsers/qs','../../config/logger','api','../../config/environment','../../mysqldb','redis','./cmContact.socket','status'];(function(_0x166742,_0x55520c){var _0xb7814a=function(_0x18feaf){while(--_0x18feaf){_0x166742['push'](_0x166742['shift']());}};_0xb7814a(++_0x55520c);}(_0x11e7,0x1e6));var _0x711e=function(_0x1eb7db,_0xefd783){_0x1eb7db=_0x1eb7db-0x0;var _0x4829f5=_0x11e7[_0x1eb7db];return _0x4829f5;};'use strict';var moment=require('moment');var BPromise=require(_0x711e('0x0'));var util=require(_0x711e('0x1'));var path=require(_0x711e('0x2'));var fs=require('fs');var _=require(_0x711e('0x3'));var squel=require(_0x711e('0x4'));var Papa=require(_0x711e('0x5'));var Redis=require('ioredis');var contacts=require('../../components/contacts');var qs=require(_0x711e('0x6'));var logger=require(_0x711e('0x7'))(_0x711e('0x8'));var config=require(_0x711e('0x9'));var shared=require('../../config/environment/shared');var db=require(_0x711e('0xa'))['db'];config[_0x711e('0xb')]=_['defaults'](config[_0x711e('0xb')],{'host':'localhost','port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config['redis']));require(_0x711e('0xc'))['register'](socket);function respondWithResult(_0x424f17,_0x38fec4){_0x38fec4=_0x38fec4||0xc8;return function(_0x286701){if(_0x286701){return _0x424f17[_0x711e('0xd')](_0x38fec4)['json'](_0x286701);}};}function respondWithFilteredResult(_0x4d7946,_0x4dcd33){return function(_0x256d5e){if(_0x256d5e){var _0x1426ff=typeof _0x4dcd33['offset']==='undefined'&&typeof _0x4dcd33[_0x711e('0xe')]==='undefined';var _0x5f1764=_0x256d5e[_0x711e('0xf')];var _0x420d65=_0x1426ff?0x0:_0x4dcd33[_0x711e('0x10')];var _0x119324=_0x1426ff?_0x256d5e['count']:_0x4dcd33[_0x711e('0x10')]+_0x4dcd33[_0x711e('0xe')];var _0x1105c0;if(_0x119324>=_0x5f1764){_0x119324=_0x5f1764;_0x1105c0=0xc8;}else{_0x1105c0=0xce;}_0x4d7946[_0x711e('0xd')](_0x1105c0);return _0x4d7946['set'](_0x711e('0x11'),_0x420d65+'-'+_0x119324+'/'+_0x5f1764)['json'](_0x256d5e);}return null;};}function saveUpdates(_0x44f6fd){return function(_0x8fc435){if(_0x8fc435){return _0x8fc435['update'](_0x44f6fd)['then'](function(_0x264ed7){return _0x264ed7;});}return null;};}function removeEntity(_0xf79cc8){return function(_0x926d14){if(_0x926d14){return _0x926d14[_0x711e('0x12')]()['then'](function(){_0xf79cc8['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x4a0013){return function(_0x1f7ff2){if(!_0x1f7ff2){_0x4a0013[_0x711e('0x13')](0x194);}return _0x1f7ff2;};}function handleError(_0x5e65ea,_0x1a7aeb){_0x1a7aeb=_0x1a7aeb||0x1f4;return function(_0x2018ed){logger[_0x711e('0x14')](_0x2018ed[_0x711e('0x15')]);if(_0x2018ed[_0x711e('0x16')]){delete _0x2018ed[_0x711e('0x16')];}_0x5e65ea[_0x711e('0xd')](_0x1a7aeb)[_0x711e('0x17')](_0x2018ed);};}exports[_0x711e('0x18')]=function(_0x36f0cc,_0x3fc283){var _0x17fdfc={};return contacts[_0x711e('0x19')]()[_0x711e('0x1a')](function(_0x16f0c6){_0x17fdfc=qs[_0x711e('0x1b')](_0x16f0c6,_0x36f0cc);return contacts[_0x711e('0x1c')](_0x36f0cc[_0x711e('0x1d')],_0x36f0cc[_0x711e('0x1e')],_0x17fdfc,_0x16f0c6);})['then'](respondWithFilteredResult(_0x3fc283,_0x17fdfc))[_0x711e('0x1f')](handleError(_0x3fc283,null));};exports[_0x711e('0x12')]=function(_0x4d1150,_0x1cd535){return db['CmContact'][_0x711e('0x20')]({'where':{'id':_0x4d1150[_0x711e('0x21')]['id']}})[_0x711e('0x1a')](handleEntityNotFound(_0x1cd535,null))[_0x711e('0x1a')](removeEntity(_0x1cd535,null))[_0x711e('0x1f')](handleError(_0x1cd535,null));};exports[_0x711e('0x19')]=function(_0x26ebfa,_0x5ae029){return db[_0x711e('0x22')][_0x711e('0x19')]()[_0x711e('0x1a')](function(_0x4d6ac5){delete _0x4d6ac5[_0x711e('0x23')];for(var _0x4d170d=0x0;_0x4d170d<Object[_0x711e('0x24')](_0x4d6ac5)[_0x711e('0x25')];_0x4d170d++){var _0x17a667=Object['keys'](_0x4d6ac5)[_0x4d170d];if(!_['startsWith'](_0x17a667,_0x711e('0x26'))){_0x4d6ac5[_0x17a667][_0x711e('0x27')]=_0x17a667;_0x4d6ac5[_0x17a667][_0x711e('0x28')]=_0x17a667;}}return _0x4d6ac5;})['then'](function(_0x2d3e2d){var _0x3cfe12={'where':Boolean(_0x26ebfa['query'][_0x711e('0x29')])===!![]?undefined:{'$or':[{'ListId':_0x26ebfa[_0x711e('0x1d')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x711e('0x2a')][_0x711e('0x1c')](_0x3cfe12)['then'](function(_0x54fd74){for(var _0x4d3449=0x0;_0x4d3449<_0x54fd74[_0x711e('0x25')];_0x4d3449++){var _0xb376d8='cf_'+_0x54fd74[_0x4d3449]['id'];if(_0x2d3e2d[_0xb376d8]){_0x2d3e2d[_0xb376d8][_0x711e('0x27')]=_0xb376d8;_0x2d3e2d[_0xb376d8]['displayName']=_0x54fd74[_0x4d3449]['alias'];_0x2d3e2d[_0xb376d8][_0x711e('0x2b')]={'type':_0x54fd74[_0x4d3449][_0x711e('0x2c')],'values':_0x54fd74[_0x4d3449][_0x711e('0x2d')]};}else{logger['info'](_0x711e('0x2e'),_0xb376d8);}}Object[_0x711e('0x24')](_0x2d3e2d)[_0x711e('0x2f')](function(_0x5bb61d){if(!_0x2d3e2d[_0x5bb61d][_0x711e('0x30')](_0x711e('0x27'))){delete _0x2d3e2d[_0x5bb61d];}});return _0x2d3e2d;});})[_0x711e('0x1a')](respondWithResult(_0x5ae029,null))[_0x711e('0x1f')](handleError(_0x5ae029,null));};exports[_0x711e('0x31')]=function(_0x32c809,_0xa75c82){var _0x57c1ef;var _0x266050;var _0x399dd6;if(_0x32c809['body']['id']){delete _0x32c809['body']['id'];}return db[_0x711e('0x22')][_0x711e('0x1c')]({'where':{'id':[_0x32c809[_0x711e('0x32')]['to'],_0x32c809['body'][_0x711e('0x33')]]}})['then'](function(_0x1fb658){if(_0x1fb658){if(_0x1fb658[_0x711e('0x25')]!==0x2){return null;}_0x1fb658[0x0]=_0x1fb658[0x0]['get']({'plain':!![]});_0x1fb658[0x1]=_0x1fb658[0x1][_0x711e('0x34')]({'plain':!![]});delete _0x1fb658[0x0]['id'];delete _0x1fb658[0x1]['id'];return _['mergeWith'](_0x1fb658[0x0],_0x1fb658[0x1],function(_0x131111,_0x3dedc8){if(Array[_0x711e('0x35')](_0x3dedc8)&&!_0x3dedc8['length']){return _0x131111;}else if(!_0x3dedc8){return _0x131111;}});}})[_0x711e('0x1a')](handleEntityNotFound(_0xa75c82,null))[_0x711e('0x1a')](function(_0x12930a){if(_0x12930a){if(_0x12930a[_0x711e('0x23')]&&_['isArray'](_0x12930a[_0x711e('0x23')])){_0x12930a[_0x711e('0x23')]=_0x12930a[_0x711e('0x23')][_0x711e('0x36')]();}logger[_0x711e('0x37')]('[CmContact][merge]\x20to\x20%s\x20from\x20%s',_0x32c809['body']['to'],_0x32c809['body']['from']);return db[_0x711e('0x38')][_0x711e('0x12')]({'where':{'ContactId':[_0x32c809['body']['to'],_0x32c809['body'][_0x711e('0x33')]]}})['then'](function(_0x1c4145){logger['info'](_0x711e('0x39'),_0x1c4145);return db[_0x711e('0x3a')]['destroy']({'where':{'ContactId':[_0x32c809['body']['to'],_0x32c809[_0x711e('0x32')][_0x711e('0x33')]]}})[_0x711e('0x1a')](function(_0xad52d5){logger[_0x711e('0x37')](_0x711e('0x3b'),_0xad52d5);return db[_0x711e('0x22')][_0x711e('0x3c')](_0x12930a);});});}})[_0x711e('0x1a')](function(_0x5133e1){if(_0x5133e1){_0x57c1ef=_0x5133e1;_0x266050={'ContactId':_0x57c1ef['id']};_0x399dd6={'where':{'ContactId':[_0x32c809['body']['to'],_0x32c809[_0x711e('0x32')][_0x711e('0x33')]]}};return db[_0x711e('0x3d')][_0x711e('0x3e')](_0x266050,_0x399dd6);}})['then'](function(){if(_0x57c1ef){return db['ChatMessage'][_0x711e('0x3e')](_0x266050,_0x399dd6);}})[_0x711e('0x1a')](function(){if(_0x57c1ef){return db[_0x711e('0x3f')][_0x711e('0x3e')](_0x266050,_0x399dd6);}})[_0x711e('0x1a')](function(){if(_0x57c1ef){return db[_0x711e('0x40')][_0x711e('0x3e')](_0x266050,_0x399dd6);}})[_0x711e('0x1a')](function(){if(_0x57c1ef){return db[_0x711e('0x41')][_0x711e('0x3e')](_0x266050,_0x399dd6);}})[_0x711e('0x1a')](function(){if(_0x57c1ef){return db[_0x711e('0x40')][_0x711e('0x3e')](_0x266050,_0x399dd6);}})['then'](function(){if(_0x57c1ef){return db[_0x711e('0x41')]['update'](_0x266050,_0x399dd6);}})[_0x711e('0x1a')](function(){if(_0x57c1ef){return db[_0x711e('0x42')][_0x711e('0x3e')](_0x266050,_0x399dd6);}})['then'](function(){if(_0x57c1ef){return db[_0x711e('0x43')]['update'](_0x266050,_0x399dd6);}})[_0x711e('0x1a')](function(){if(_0x57c1ef){return db[_0x711e('0x44')][_0x711e('0x3e')](_0x266050,_0x399dd6);}})[_0x711e('0x1a')](function(){if(_0x57c1ef){return db[_0x711e('0x45')][_0x711e('0x3e')](_0x266050,_0x399dd6);}})['then'](function(){if(_0x57c1ef){return db['OpenchannelInteraction'][_0x711e('0x3e')](_0x266050,_0x399dd6);}})[_0x711e('0x1a')](function(){if(_0x57c1ef){return db[_0x711e('0x46')][_0x711e('0x3e')](_0x266050,_0x399dd6);}})['then'](function(){if(_0x57c1ef){return db['CmContactHasItem'][_0x711e('0x3e')]({'CmContactId':_0x57c1ef['id']},{'where':{'CmContactId':[_0x32c809[_0x711e('0x32')]['to'],_0x32c809[_0x711e('0x32')]['from']]}});}})[_0x711e('0x1a')](function(){if(_0x57c1ef){return db[_0x711e('0x47')][_0x711e('0x3e')](_0x266050,_0x399dd6);}})[_0x711e('0x1a')](function(){if(_0x57c1ef){return db['CmHopperHistory'][_0x711e('0x3e')](_0x266050,_0x399dd6);}})[_0x711e('0x1a')](function(){if(_0x57c1ef){return db['ReportAgentPreview'][_0x711e('0x3e')](_0x266050,_0x399dd6);}})[_0x711e('0x1a')](function(){if(_0x57c1ef){return db[_0x711e('0x48')][_0x711e('0x3e')](_0x266050,_0x399dd6);}})[_0x711e('0x1a')](function(){if(_0x57c1ef){return db[_0x711e('0x49')][_0x711e('0x3e')](_0x266050,_0x399dd6);}})['then'](function(){if(_0x57c1ef){return db['FaxQueueReport'][_0x711e('0x3e')](_0x266050,_0x399dd6);}})['then'](function(){if(_0x57c1ef){return db[_0x711e('0x4a')][_0x711e('0x3e')](_0x266050,_0x399dd6);}})[_0x711e('0x1a')](function(){if(_0x57c1ef){return db['OpenchannelQueueReport'][_0x711e('0x3e')](_0x266050,_0x399dd6);}})[_0x711e('0x1a')](function(){if(_0x57c1ef){return db['SmsQueueReport'][_0x711e('0x3e')](_0x266050,_0x399dd6);}})['then'](function(){if(_0x57c1ef){return db['JscriptySessionReport'][_0x711e('0x3e')](_0x266050,_0x399dd6);}})[_0x711e('0x1a')](function(){if(_0x57c1ef){return db['WhatsappInteraction'][_0x711e('0x3e')](_0x266050,_0x399dd6);}})['then'](function(){if(_0x57c1ef){return db[_0x711e('0x4b')]['update'](_0x266050,_0x399dd6);}})['then'](function(){if(_0x57c1ef){return db[_0x711e('0x4c')][_0x711e('0x3e')](_0x266050,_0x399dd6);}})['then'](function(){if(_0x57c1ef){return db['CmContact'][_0x711e('0x12')]({'where':{'id':[_0x32c809[_0x711e('0x32')]['to'],_0x32c809[_0x711e('0x32')][_0x711e('0x33')]]}});}})['then'](function(){if(_0x57c1ef){return _0x57c1ef;}})[_0x711e('0x1a')](respondWithResult(_0xa75c82,null))['catch'](handleError(_0xa75c82,null));};exports[_0x711e('0x3c')]=function(_0x2219e8,_0x2a839f){return db[_0x711e('0x22')][_0x711e('0x19')]()[_0x711e('0x1a')](function(_0x4f19b4){if(_0x2219e8[_0x711e('0x32')]['tags']&&_[_0x711e('0x35')](_0x2219e8[_0x711e('0x32')][_0x711e('0x23')])){if(_0x2219e8['body'][_0x711e('0x23')][_0x711e('0x25')]){_0x2219e8['body']['tags']=_0x2219e8[_0x711e('0x32')][_0x711e('0x23')][_0x711e('0x36')](';')+';';}else{_0x2219e8['body']['tags']=null;}}else{_0x2219e8[_0x711e('0x32')][_0x711e('0x23')]=null;}if(!_[_0x711e('0x4d')](_0x2219e8['body'][_0x711e('0x4e')])){var _0x5ca70c=_0x2219e8[_0x711e('0x32')][_0x711e('0x4e')];if(!_[_0x711e('0x4d')](shared[_0x711e('0x4f')][_0x5ca70c]))_0x2219e8[_0x711e('0x32')][_0x711e('0x50')]=shared['timezones'][_0x5ca70c][_0x711e('0x50')];}return db['CmContact'][_0x711e('0x3c')](_0x2219e8[_0x711e('0x32')],{'fields':_[_0x711e('0x24')](_0x4f19b4),'raw':!![]});})[_0x711e('0x1a')](function(_0x90723){if(_0x2219e8['body'][_0x711e('0x51')]){return insertAdditionalPhones(_0x90723,_0x2219e8[_0x711e('0x32')][_0x711e('0x51')]);}else{return _0x90723;}})[_0x711e('0x1a')](respondWithResult(_0x2a839f,0xc9))['catch'](handleError(_0x2a839f,null));};exports['bulkCreate']=function(_0x594207,_0x3d4857){var _0x413b52=0x0;var _0x271dae=0x0;var _0x39a61a=0x0;var _0x1bfe1d=[];return db[_0x711e('0x22')][_0x711e('0x19')]()['then'](function(_0x474dd5){return BPromise[_0x711e('0x52')](_0x594207[_0x711e('0x32')],function(_0x281cb7){var _0x472de5={'where':{'$or':[]},'defaults':_0x281cb7,'fields':_['keys'](_0x474dd5),'raw':!![]};if(_0x281cb7['duplicates']){for(var _0x4cf6e1=0x0;_0x4cf6e1<_0x281cb7[_0x711e('0x53')][_0x711e('0x25')];_0x4cf6e1++){var _0x439633={};_0x439633[_0x281cb7[_0x711e('0x53')][_0x4cf6e1]]=_0x281cb7[_0x281cb7[_0x711e('0x53')][_0x4cf6e1]];_0x472de5['where'][_0x711e('0x54')]['push'](_0x439633);}_0x472de5[_0x711e('0x55')][_0x711e('0x56')]=_0x281cb7[_0x711e('0x56')];}return db['CmContact'][_0x711e('0x57')](_0x472de5)[_0x711e('0x58')](function(_0x336f24,_0x7fea6a){if(_0x7fea6a){if(_0x281cb7['hasOwnProperty'](_0x711e('0x51'))){_0x1bfe1d[_0x711e('0x59')]({'contact':_0x336f24,'additionalPhones':_0x281cb7['additionalPhones']});}_0x413b52++;}else{_0x39a61a++;}})[_0x711e('0x1f')](function(){_0x271dae++;});});})[_0x711e('0x1a')](function(_0x107d93){if(_0x107d93){if(_0x1bfe1d[_0x711e('0x25')]>0x0){return new Promise(function(_0x1a48e5){var _0x2cf073=[];for(var _0x56d4ce=0x0;_0x56d4ce<_0x1bfe1d['length'];_0x56d4ce++){_0x2cf073[_0x711e('0x59')](insertAdditionalPhones(_0x1bfe1d[_0x56d4ce]['contact'],_0x1bfe1d[_0x56d4ce][_0x711e('0x51')]));}Promise['all'](_0x2cf073)['then'](function(){_0x1a48e5(0x1);});})[_0x711e('0x1a')](function(){return{'success':_0x413b52,'failure':_0x271dae,'duplicates':_0x39a61a};});}else{return{'success':_0x413b52,'failure':_0x271dae,'duplicates':_0x39a61a};}}})[_0x711e('0x1a')](respondWithResult(_0x3d4857,0xc9))[_0x711e('0x1f')](handleError(_0x3d4857,null));};exports['show']=function(_0x46edf4,_0x3548dd){var _0x314855;return db[_0x711e('0x22')][_0x711e('0x19')]()[_0x711e('0x1a')](function(_0x1492d0){return db['CmContact'][_0x711e('0x20')]({'where':{'id':_0x46edf4[_0x711e('0x21')]['id']},'include':[{'model':db[_0x711e('0x5a')],'as':'Tags','attributes':['id',_0x711e('0x16'),_0x711e('0x5b')],'required':_0x46edf4[_0x711e('0x1d')][_0x711e('0x5c')]?!![]:![]},{'model':db[_0x711e('0x5d')],'as':_0x711e('0x5e'),'where':{'CmContactId':_0x46edf4[_0x711e('0x21')]['id']},'required':![],'include':[{'model':db['ContactItemType'],'as':_0x711e('0x5f')}]}],'order':[db[_0x711e('0x60')][_0x711e('0x61')](_0x711e('0x62'))],'attributes':_['keys'](_0x1492d0)});})[_0x711e('0x1a')](function(_0x3fb06b){if(!_['isNil'](_0x3fb06b)){_0x314855=_0x3fb06b[_0x711e('0x34')]({'plain':!![]});var _0x2451a3={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x3fb06b&&_0x3fb06b[_0x711e('0x56')]){if(_0x3fb06b[_0x711e('0x56')]){_0x2451a3[_0x711e('0x55')][_0x711e('0x63')][_0x711e('0x59')]({'ListId':{'$ne':_0x3fb06b[_0x711e('0x56')]}});}}return db[_0x711e('0x2a')]['findAll'](_0x2451a3);}})['then'](function(_0x23d75d){if(!_[_0x711e('0x4d')](_0x23d75d)){return _['omit'](_0x314855,_[_0x711e('0x64')](_0x23d75d,function(_0xe4f31b){return util[_0x711e('0x65')](_0x711e('0x66'),_0xe4f31b['id']);}));}})['then'](handleEntityNotFound(_0x3548dd,null))[_0x711e('0x1a')](respondWithResult(_0x3548dd,null))[_0x711e('0x1f')](handleError(_0x3548dd,null));};exports[_0x711e('0x3e')]=function(_0x1d1ad6,_0x50e08e){var _0x2fa41b;if(_0x1d1ad6[_0x711e('0x32')]['id']){delete _0x1d1ad6[_0x711e('0x32')]['id'];}if(!_[_0x711e('0x4d')](_0x1d1ad6[_0x711e('0x32')]['dialTimezone'])){var _0x38bd76=_0x1d1ad6['body']['dialTimezone'];if(!_[_0x711e('0x4d')](shared['timezones'][_0x38bd76]))_0x1d1ad6[_0x711e('0x32')]['utcOffset']=shared[_0x711e('0x4f')][_0x38bd76][_0x711e('0x50')];}return db[_0x711e('0x22')]['find']({'where':{'id':_0x1d1ad6[_0x711e('0x21')]['id']}})['then'](handleEntityNotFound(_0x50e08e,null))[_0x711e('0x1a')](saveUpdates(_0x1d1ad6[_0x711e('0x32')],null))[_0x711e('0x1a')](function(_0x1c48d9){_0x2fa41b=_0x1c48d9;var _0x3e92cd={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x1c48d9&&_0x1c48d9[_0x711e('0x56')]){if(_0x1c48d9['ListId']){_0x3e92cd[_0x711e('0x55')]['$and']['push']({'ListId':{'$ne':_0x1c48d9['ListId']}});}}return db[_0x711e('0x2a')][_0x711e('0x1c')](_0x3e92cd);})[_0x711e('0x1a')](function(_0x27a7d9){if(_0x27a7d9){return _['omit'](_[_0x711e('0x67')](_0x1d1ad6[_0x711e('0x32')],function(_0x4463b8,_0x554615){return _['startsWith'](_0x554615,'cf_');}),_['map'](_0x27a7d9,function(_0x3d74d0){return util[_0x711e('0x65')]('cf_%d',_0x3d74d0['id']);}));}})[_0x711e('0x1a')](function(_0x678ea5){if(_0x678ea5&&!_[_0x711e('0x68')](_0x678ea5)){var _0x303b85=squel[_0x711e('0x3e')]()[_0x711e('0x69')](_0x711e('0x6a'))['setFields'](_0x678ea5)[_0x711e('0x55')](_0x711e('0x6b'),_0x1d1ad6[_0x711e('0x21')]['id'])[_0x711e('0x6c')]();return db[_0x711e('0x60')][_0x711e('0x1d')](_0x303b85[_0x711e('0x6d')],{'replacements':_0x303b85[_0x711e('0x2d')]});}})[_0x711e('0x1a')](function(){if(_0x1d1ad6['body'][_0x711e('0x6e')]&&_0x2fa41b){return db[_0x711e('0x38')][_0x711e('0x3e')]({'phone':_0x1d1ad6[_0x711e('0x32')]['phone'],'OrderBy':0x0},{'where':{'ContactId':_0x2fa41b['id']}});}})[_0x711e('0x1a')](function(){return _0x2fa41b;})[_0x711e('0x1a')](respondWithResult(_0x50e08e,null))[_0x711e('0x1f')](handleError(_0x50e08e,null));};exports[_0x711e('0x6f')]=function(_0x16c0b0,_0x337865){var _0x44986c={};var _0x4dced2={};var _0x19d9cc;var _0x35a993;return db[_0x711e('0x22')][_0x711e('0x70')]({'where':{'id':_0x16c0b0['params']['id']}})[_0x711e('0x1a')](handleEntityNotFound(_0x337865,null))[_0x711e('0x1a')](function(_0x3de01e){if(_0x3de01e){_0x19d9cc=_0x3de01e;_0x4dced2[_0x711e('0x71')]=_[_0x711e('0x24')](db[_0x711e('0x5a')][_0x711e('0x72')]);_0x4dced2['query']=_[_0x711e('0x24')](_0x16c0b0['query']);_0x4dced2[_0x711e('0x73')]=_['intersection'](_0x4dced2[_0x711e('0x71')],_0x4dced2[_0x711e('0x1d')]);_0x44986c[_0x711e('0x74')]=_[_0x711e('0x75')](_0x4dced2[_0x711e('0x71')],qs[_0x711e('0x76')](_0x16c0b0[_0x711e('0x1d')][_0x711e('0x76')]));_0x44986c[_0x711e('0x74')]=_0x44986c[_0x711e('0x74')][_0x711e('0x25')]?_0x44986c[_0x711e('0x74')]:_0x4dced2[_0x711e('0x71')];_0x44986c[_0x711e('0x77')]=qs['sort'](_0x16c0b0[_0x711e('0x1d')][_0x711e('0x78')]);_0x44986c[_0x711e('0x55')]=qs[_0x711e('0x73')](_['pick'](_0x16c0b0[_0x711e('0x1d')],_0x4dced2[_0x711e('0x73')]));if(_0x16c0b0[_0x711e('0x1d')][_0x711e('0x79')]){_0x44986c[_0x711e('0x55')]=_[_0x711e('0x31')](_0x44986c['where'],{'$or':_['map'](_0x44986c[_0x711e('0x74')],function(_0x47548b){var _0x22b857={};_0x22b857[_0x47548b]={'$like':'%'+_0x16c0b0[_0x711e('0x1d')]['filter']+'%'};return _0x22b857;})});}_0x44986c=_['merge']({},_0x44986c,_0x16c0b0['options']);return _0x19d9cc[_0x711e('0x6f')](_0x44986c);}})[_0x711e('0x1a')](function(_0x2b6590){if(_0x2b6590){_0x35a993=_0x2b6590['length'];if(!_0x16c0b0['query'][_0x711e('0x30')](_0x711e('0x7a'))){_0x44986c[_0x711e('0xe')]=qs[_0x711e('0xe')](_0x16c0b0[_0x711e('0x1d')][_0x711e('0xe')]);_0x44986c[_0x711e('0x10')]=qs['offset'](_0x16c0b0[_0x711e('0x1d')][_0x711e('0x10')]);}return _0x19d9cc[_0x711e('0x6f')](_0x44986c);}})[_0x711e('0x1a')](function(_0x227fc2){if(_0x227fc2){return _0x227fc2?{'count':_0x35a993,'rows':_0x227fc2}:null;}})[_0x711e('0x1a')](respondWithResult(_0x337865,null))[_0x711e('0x1f')](handleError(_0x337865,null));};exports['setTags']=function(_0x3e5a39,_0x35f0bf){if(_0x3e5a39['body']['id']){delete _0x3e5a39['body']['id'];}return db[_0x711e('0x22')][_0x711e('0x70')]({'where':{'id':_0x3e5a39[_0x711e('0x21')]['id']}})['then'](handleEntityNotFound(_0x35f0bf,null))[_0x711e('0x1a')](function(_0x1ae1b0){if(_0x1ae1b0){return _0x1ae1b0[_0x711e('0x7b')](_0x3e5a39[_0x711e('0x32')][_0x711e('0x7c')]||[]);}return null;})['then'](respondWithResult(_0x35f0bf,null))[_0x711e('0x1f')](handleError(_0x35f0bf,null));};exports[_0x711e('0x7d')]=function(_0x19a88a,_0x84d81e){var _0x3e3b1a=[];_0x3e3b1a[_0x711e('0x59')](addAdditionalPhones(_0x19a88a[_0x711e('0x32')]));Promise[_0x711e('0x7e')](_0x3e3b1a)['then'](function(){_0x3e3b1a=[];_0x3e3b1a[_0x711e('0x59')](deleteCmHopperPhones(_0x19a88a['body']['id']));_0x3e3b1a['push'](addCmHopperPhones(_0x19a88a[_0x711e('0x32')]['id']));Promise[_0x711e('0x7e')](_0x3e3b1a)['then'](function(){return[0x1];})[_0x711e('0x1a')](respondWithResult(_0x84d81e,null));});};function addAdditionalPhones(_0x450646){var _0xb503e2;return new Promise(function(_0x38333f){return db['CmContactHasItem'][_0x711e('0x12')]({'where':{'CmContactId':_0x450646['id']}})['then'](function(){db[_0x711e('0x7f')][_0x711e('0x1c')]({'raw':!![],'attributes':['id',_0x711e('0x80')]})[_0x711e('0x1a')](function(_0x4e74bc){var _0x4ad9c0=[];for(var _0x2264f2=0x0;_0x2264f2<_0x450646['items'][_0x711e('0x25')];_0x2264f2++){var _0x2ffbab=_0x450646[_0x711e('0x81')]?_[_0x711e('0x4d')](_0x450646[_0x711e('0x81')][_0x2264f2])?'':_0x450646[_0x711e('0x81')][_0x2264f2]:_0x450646[_0x711e('0x82')][_0x2264f2][_0x711e('0x83')]?_0x450646['items'][_0x2264f2][_0x711e('0x83')]:'';var _0x530012=_['isNil'](_0x450646[_0x711e('0x82')][_0x2264f2][_0x711e('0x84')])?'':_0x450646[_0x711e('0x82')][_0x2264f2][_0x711e('0x84')];var _0x495378=_0x2ffbab+':'+_0x450646[_0x711e('0x82')][_0x2264f2][_0x711e('0x6e')]+'§'+_0x530012;if(_[_0x711e('0x4d')](_0xb503e2))_0xb503e2=_0x495378;else _0xb503e2+=';'+_0x495378;var _0x5c63ed=null;var _0x1badd8=null;if(_0x450646[_0x711e('0x81')]){if(!_[_0x711e('0x4d')](_0x450646[_0x711e('0x81')][_0x2264f2])){_0x1badd8=_[_0x711e('0x20')](_0x4e74bc,function(_0x346348){return _0x346348['id']===_0x450646['item_types'][_0x2264f2];});if(!_['isNil'](_0x1badd8)){_0x5c63ed=_0x1badd8[_0x711e('0x80')];}}}else{if(!_['isNil'](_0x450646[_0x711e('0x82')][_0x2264f2])){_0x1badd8=_[_0x711e('0x20')](_0x4e74bc,function(_0x10a5c8){return _0x10a5c8['id']===_0x450646[_0x711e('0x82')][_0x2264f2][_0x711e('0x83')];});if(!_['isNil'](_0x1badd8)){_0x5c63ed=_0x2264f2;}}}if(_['isNil'](_0x5c63ed)){_0x5c63ed=0x64;}_0x4ad9c0[_0x711e('0x59')](addAdditionalPhone(_0x450646['id'],_0x450646['items'][_0x2264f2][_0x711e('0x6e')],_0x450646['item_types']?_[_0x711e('0x4d')](_0x450646[_0x711e('0x81')][_0x2264f2])?null:_0x450646[_0x711e('0x81')][_0x2264f2]:_0x450646[_0x711e('0x82')][_0x2264f2]['ItemTypeId']?_0x450646[_0x711e('0x82')][_0x2264f2][_0x711e('0x83')]:null,_0x5c63ed,_0x530012));}Promise['all'](_0x4ad9c0)[_0x711e('0x1a')](function(){db[_0x711e('0x22')][_0x711e('0x3e')]({'AdditionalPhones':_0xb503e2},{'where':{'id':_0x450646['id']}})[_0x711e('0x1a')](function(){_0x38333f(0x1);});});});});});}function addAdditionalPhone(_0x571053,_0x23375e,_0x208f7d,_0xd9a0f4,_0x2a71f0){return db[_0x711e('0x5d')]['find']({'where':{'CmContactId':_0x571053,'item':_0x23375e}})[_0x711e('0x1a')](function(_0x2d8fac){if(_0x2d8fac)logger['info'](_0x711e('0x85'),_0x2d8fac);else{db['CmContactHasItem']['create']({'CmContactId':_0x571053,'item':_0x23375e,'ItemTypeId':_0x208f7d,'OrderBy':_0xd9a0f4,'ItemClass':_0x711e('0x86'),'description':_0x2a71f0});}});}function deleteCmHopperPhones(_0xdee7d0){return new Promise(function(_0x2cb4fb){return db['CmHopper'][_0x711e('0x1c')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0xdee7d0}})[_0x711e('0x1a')](function(_0x33ad7a){db['CmHopperAdditionalPhone'][_0x711e('0x12')]({'where':{'CmHopperId':{'$in':_[_0x711e('0x64')](_0x33ad7a,'id')}}});})['then'](function(){_0x2cb4fb(0x1);});});}function addCmHopperPhones(_0x5e2c62){return new Promise(function(_0x25bdc9){return db[_0x711e('0x38')]['findAll']({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x5e2c62}})[_0x711e('0x1a')](function(_0x52b659){var _0x5e0105=[];_['map'](_0x52b659,function(_0x23ccc0){_0x5e0105[_0x711e('0x59')](createCmHopperPhone(_0x5e2c62,_0x23ccc0['id']));});Promise['all'](_0x5e0105)[_0x711e('0x1a')](function(){_0x25bdc9(0x1);});});});}function createCmHopperPhone(_0x53b218,_0x4def02){return new Promise(function(_0x580bf2){db[_0x711e('0x5d')][_0x711e('0x1c')]({'raw':!![],'attributes':['item',_0x711e('0x80')],'where':{'CmContactId':_0x53b218,'ItemClass':_0x711e('0x86')},'include':[{'model':db[_0x711e('0x7f')],'attributes':['OrderBy'],'as':_0x711e('0x5f')}],'order':[_0x711e('0x80'),db['sequelize']['literal'](_0x711e('0x87'))]})[_0x711e('0x1a')](function(_0x56f8c6){var _0x1b5e51=0x1;var _0x419440=_[_0x711e('0x64')](_0x56f8c6,function(_0x5c3547){_0x5c3547[_0x711e('0x88')]=_0x4def02;_0x5c3547[_0x711e('0x6e')]=_0x5c3547[_0x711e('0x89')];_0x5c3547[_0x711e('0x80')]=_0x1b5e51;delete _0x5c3547[_0x711e('0x8a')];_0x1b5e51=_0x1b5e51+0x1;return _0x5c3547;});return db['CmHopperAdditionalPhone'][_0x711e('0x8b')](_0x419440,{});})[_0x711e('0x1a')](function(){_0x580bf2(0x1);});});}function insertAdditionalPhones(_0x3e2eda,_0x29d454){return new Promise(function(_0x4bc775){var _0x40f18f=[];for(var _0xcce63b=0x0;_0xcce63b<_0x29d454[_0x711e('0x25')];_0xcce63b++){var _0x35593e=_0x29d454[_0xcce63b];_0x40f18f['push'](parseContactItemType(_0x35593e));}Promise[_0x711e('0x7e')](_0x40f18f)[_0x711e('0x1a')](function(){var _0x5f2179={'id':_0x3e2eda['id'],'items':_0x29d454};return addAdditionalPhones(_0x5f2179)[_0x711e('0x1a')](function(){return addCmHopperPhones(_0x3e2eda['id']);});})[_0x711e('0x1a')](function(){_0x4bc775(_0x3e2eda);});});}function parseContactItemType(_0x3b3b4d){return new Promise(function(_0x1f13ef){if(_0x3b3b4d[_0x711e('0x30')](_0x711e('0x83'))){_0x1f13ef(_0x3b3b4d);}else{return db[_0x711e('0x7f')][_0x711e('0x20')]({'where':{'name':_0x3b3b4d[_0x711e('0x5f')]}})[_0x711e('0x1a')](function(_0x27176c){if(_[_0x711e('0x4d')](_0x27176c))_0x3b3b4d[_0x711e('0x83')]=null;else _0x3b3b4d[_0x711e('0x83')]=_0x27176c['id'];_0x1f13ef(_0x3b3b4d);});}});}exports[_0x711e('0x8c')]=function(_0x31cada,_0x31a72b){return db[_0x711e('0x5d')][_0x711e('0x1c')]({'raw':!![],'where':{'CmContactId':_0x31cada[_0x711e('0x21')]['id'],'ItemClass':'PHONE'},'include':[{'model':db[_0x711e('0x7f')],'as':_0x711e('0x5f')}],'order':[[_0x711e('0x80')],[db[_0x711e('0x60')][_0x711e('0x61')](_0x711e('0x87'))]]})['then'](function(_0x38ec56){return _0x38ec56;})[_0x711e('0x1a')](respondWithResult(_0x31a72b,null))[_0x711e('0x1f')](handleError(_0x31a72b,null));};exports['duplicateAdditionalPhones']=function(_0x2defba,_0x45f43e){return db[_0x711e('0x5d')][_0x711e('0x1c')]({'raw':!![],'where':{'CmContactId':_0x2defba[_0x711e('0x32')][_0x711e('0x8d')]}})[_0x711e('0x1a')](function(_0x8f85a3){var _0x49881e=_['map'](_0x8f85a3,function(_0x4b9cfe){_0x4b9cfe[_0x711e('0x8e')]=_0x2defba[_0x711e('0x32')][_0x711e('0x8f')];return _0x4b9cfe;});return db['CmContactHasItem'][_0x711e('0x8b')](_0x49881e,{});})[_0x711e('0x1a')](function(){return addCmHopperPhones(_0x2defba[_0x711e('0x32')][_0x711e('0x8f')]);})[_0x711e('0x1a')](function(){return['ok'];})[_0x711e('0x1a')](respondWithResult(_0x45f43e,null))[_0x711e('0x1f')](handleError(_0x45f43e,null));};exports[_0x711e('0x90')]=function(_0x2ab1b3,_0x5defe9){var _0x55c53b=[];_0x55c53b[_0x711e('0x59')](createCmHopperPhone(_0x2ab1b3['body']['id'],_0x2ab1b3[_0x711e('0x32')][_0x711e('0x91')]));Promise[_0x711e('0x7e')](_0x55c53b)['then'](function(){return[0x1];})[_0x711e('0x1a')](respondWithResult(_0x5defe9,null));};exports[_0x711e('0x92')]=function(_0x19809d,_0x5f3db9){var _0x3d1c6c={'raw':![],'where':{}};var _0x4bc209={};var _0x4fc85={'count':0x0,'rows':[]};return db[_0x711e('0x22')]['findOne']({'where':{'id':_0x19809d[_0x711e('0x21')]['id']}})[_0x711e('0x1a')](handleEntityNotFound(_0x5f3db9,null))[_0x711e('0x1a')](function(_0x52a945){if(_0x52a945){_0x4bc209[_0x711e('0x71')]=_['keys'](db['CmHopper']['rawAttributes']);_0x4bc209[_0x711e('0x1d')]=_[_0x711e('0x24')](_0x19809d['query']);_0x4bc209['filters']=_[_0x711e('0x75')](_0x4bc209[_0x711e('0x71')],_0x4bc209[_0x711e('0x1d')]);_0x3d1c6c[_0x711e('0x74')]=_[_0x711e('0x75')](_0x4bc209[_0x711e('0x71')],qs['fields'](_0x19809d[_0x711e('0x1d')][_0x711e('0x76')]));_0x3d1c6c[_0x711e('0x74')]=_0x3d1c6c[_0x711e('0x74')][_0x711e('0x25')]?_0x3d1c6c['attributes']:_0x4bc209[_0x711e('0x71')];if(!_0x19809d['query']['hasOwnProperty'](_0x711e('0x7a'))){_0x3d1c6c[_0x711e('0xe')]=qs[_0x711e('0xe')](_0x19809d[_0x711e('0x1d')][_0x711e('0xe')]);_0x3d1c6c[_0x711e('0x10')]=qs[_0x711e('0x10')](_0x19809d[_0x711e('0x1d')]['offset']);}_0x3d1c6c[_0x711e('0x77')]=qs[_0x711e('0x78')](_0x19809d[_0x711e('0x1d')][_0x711e('0x78')]);_0x3d1c6c[_0x711e('0x55')]=qs[_0x711e('0x73')](_[_0x711e('0x93')](_0x19809d[_0x711e('0x1d')],_0x4bc209[_0x711e('0x73')]));_0x3d1c6c['where']['ContactId']=_0x52a945['id'];if(_0x19809d['query']['filter']){_0x3d1c6c['where']=_[_0x711e('0x31')](_0x3d1c6c[_0x711e('0x55')],{'$or':_[_0x711e('0x64')](_0x3d1c6c['attributes'],function(_0x42390e){var _0xf0887={};_0xf0887[_0x42390e]={'$like':'%'+_0x19809d[_0x711e('0x1d')][_0x711e('0x79')]+'%'};return _0xf0887;})});}_0x3d1c6c=_['merge']({},_0x3d1c6c,_0x19809d[_0x711e('0x94')]);return db[_0x711e('0x38')][_0x711e('0xf')]({'where':_0x3d1c6c[_0x711e('0x55')]})[_0x711e('0x1a')](function(_0xb3a31b){_0x4fc85[_0x711e('0xf')]=_0xb3a31b;if(_0x19809d[_0x711e('0x1d')][_0x711e('0x95')]){_0x3d1c6c[_0x711e('0x96')]=[{'all':!![]}];}return db['CmHopper']['findAll'](_0x3d1c6c);})[_0x711e('0x1a')](function(_0x388413){_0x4fc85['rows']=_0x388413;return _0x4fc85;});}})[_0x711e('0x1a')](respondWithFilteredResult(_0x5f3db9,_0x3d1c6c))['catch'](handleError(_0x5f3db9,null));};exports[_0x711e('0x97')]=function(_0x53c2de,_0xfafa56){var _0x582242={'raw':!![],'where':{}};var _0x65b310={};var _0x3fbf25={'count':0x0,'rows':[]};return db[_0x711e('0x22')][_0x711e('0x70')]({'where':{'id':_0x53c2de[_0x711e('0x21')]['id']}})['then'](handleEntityNotFound(_0xfafa56,null))[_0x711e('0x1a')](function(_0x175963){if(_0x175963){_0x65b310[_0x711e('0x71')]=_[_0x711e('0x24')](db[_0x711e('0x98')]['rawAttributes']);_0x65b310[_0x711e('0x1d')]=_[_0x711e('0x24')](_0x53c2de[_0x711e('0x1d')]);_0x65b310[_0x711e('0x73')]=_['intersection'](_0x65b310['model'],_0x65b310[_0x711e('0x1d')]);_0x582242['attributes']=_[_0x711e('0x75')](_0x65b310[_0x711e('0x71')],qs[_0x711e('0x76')](_0x53c2de[_0x711e('0x1d')]['fields']));_0x582242[_0x711e('0x74')]=_0x582242['attributes'][_0x711e('0x25')]?_0x582242[_0x711e('0x74')]:_0x65b310[_0x711e('0x71')];if(!_0x53c2de['query'][_0x711e('0x30')]('nolimit')){_0x582242['limit']=qs[_0x711e('0xe')](_0x53c2de[_0x711e('0x1d')][_0x711e('0xe')]);_0x582242[_0x711e('0x10')]=qs['offset'](_0x53c2de[_0x711e('0x1d')][_0x711e('0x10')]);}_0x582242[_0x711e('0x77')]=qs[_0x711e('0x78')](_0x53c2de[_0x711e('0x1d')]['sort']);_0x582242[_0x711e('0x55')]=qs[_0x711e('0x73')](_[_0x711e('0x93')](_0x53c2de[_0x711e('0x1d')],_0x65b310[_0x711e('0x73')]));_0x582242['where']['ContactId']=_0x175963['id'];if(_0x53c2de[_0x711e('0x1d')][_0x711e('0x79')]){_0x582242[_0x711e('0x55')]=_[_0x711e('0x31')](_0x582242[_0x711e('0x55')],{'$or':_[_0x711e('0x64')](_0x582242[_0x711e('0x74')],function(_0x371be1){var _0x43f31b={};_0x43f31b[_0x371be1]={'$like':'%'+_0x53c2de[_0x711e('0x1d')][_0x711e('0x79')]+'%'};return _0x43f31b;})});}_0x582242=_['merge']({},_0x582242,_0x53c2de['options']);return db['CmHopperHistory'][_0x711e('0xf')]({'where':_0x582242[_0x711e('0x55')]})[_0x711e('0x1a')](function(_0x53df8d){_0x3fbf25[_0x711e('0xf')]=_0x53df8d;if(_0x53c2de[_0x711e('0x1d')][_0x711e('0x95')]){_0x582242[_0x711e('0x96')]=[{'all':!![]}];}return db[_0x711e('0x98')][_0x711e('0x1c')](_0x582242);})[_0x711e('0x1a')](function(_0x29a9bc){_0x3fbf25[_0x711e('0x99')]=_0x29a9bc;return _0x3fbf25;});}})[_0x711e('0x1a')](respondWithFilteredResult(_0xfafa56,_0x582242))[_0x711e('0x1f')](handleError(_0xfafa56,null));};exports[_0x711e('0x9a')]=function(_0x5b4d0c,_0x4e2bea){var _0x81ad52={'raw':!![],'where':{}};var _0x40adb7={};var _0x4eaa8a={'count':0x0,'rows':[]};return db[_0x711e('0x22')]['findOne']({'where':{'id':_0x5b4d0c[_0x711e('0x21')]['id']}})['then'](handleEntityNotFound(_0x4e2bea,null))[_0x711e('0x1a')](function(_0x567b0f){if(_0x567b0f){_0x40adb7[_0x711e('0x71')]=_[_0x711e('0x24')](db[_0x711e('0x47')]['rawAttributes']);_0x40adb7[_0x711e('0x1d')]=_[_0x711e('0x24')](_0x5b4d0c[_0x711e('0x1d')]);_0x40adb7[_0x711e('0x73')]=_[_0x711e('0x75')](_0x40adb7[_0x711e('0x71')],_0x40adb7[_0x711e('0x1d')]);_0x81ad52['attributes']=_[_0x711e('0x75')](_0x40adb7[_0x711e('0x71')],qs['fields'](_0x5b4d0c['query'][_0x711e('0x76')]));_0x81ad52['attributes']=_0x81ad52[_0x711e('0x74')][_0x711e('0x25')]?_0x81ad52[_0x711e('0x74')]:_0x40adb7['model'];if(!_0x5b4d0c[_0x711e('0x1d')][_0x711e('0x30')](_0x711e('0x7a'))){_0x81ad52[_0x711e('0xe')]=qs[_0x711e('0xe')](_0x5b4d0c[_0x711e('0x1d')][_0x711e('0xe')]);_0x81ad52[_0x711e('0x10')]=qs[_0x711e('0x10')](_0x5b4d0c['query'][_0x711e('0x10')]);}_0x81ad52[_0x711e('0x77')]=qs['sort'](_0x5b4d0c[_0x711e('0x1d')]['sort']);_0x81ad52[_0x711e('0x55')]=qs[_0x711e('0x73')](_[_0x711e('0x93')](_0x5b4d0c[_0x711e('0x1d')],_0x40adb7[_0x711e('0x73')]));_0x81ad52[_0x711e('0x55')][_0x711e('0x9b')]=_0x567b0f['id'];if(_0x5b4d0c[_0x711e('0x1d')][_0x711e('0x79')]){_0x81ad52['where']=_[_0x711e('0x31')](_0x81ad52[_0x711e('0x55')],{'$or':_[_0x711e('0x64')](_0x81ad52[_0x711e('0x74')],function(_0x26a4e8){var _0x500d84={};_0x500d84[_0x26a4e8]={'$like':'%'+_0x5b4d0c[_0x711e('0x1d')][_0x711e('0x79')]+'%'};return _0x500d84;})});}_0x81ad52=_['merge']({},_0x81ad52,_0x5b4d0c[_0x711e('0x94')]);return db[_0x711e('0x47')][_0x711e('0xf')]({'where':_0x81ad52['where']})[_0x711e('0x1a')](function(_0x22be50){_0x4eaa8a[_0x711e('0xf')]=_0x22be50;if(_0x5b4d0c[_0x711e('0x1d')][_0x711e('0x95')]){_0x81ad52[_0x711e('0x96')]=[{'all':!![]}];}return db['CmHopperFinal'][_0x711e('0x1c')](_0x81ad52);})[_0x711e('0x1a')](function(_0x148885){_0x4eaa8a[_0x711e('0x99')]=_0x148885;return _0x4eaa8a;});}})[_0x711e('0x1a')](respondWithFilteredResult(_0x4e2bea,_0x81ad52))[_0x711e('0x1f')](handleError(_0x4e2bea,null));};exports[_0x711e('0x9c')]=function(_0x6aa404,_0x31892b){var _0x5a12a6={'raw':!![],'where':{}};var _0x5433c5={};var _0x111cb8={'count':0x0,'rows':[]};return db[_0x711e('0x22')][_0x711e('0x70')]({'where':{'id':_0x6aa404[_0x711e('0x21')]['id']}})['then'](handleEntityNotFound(_0x31892b,null))[_0x711e('0x1a')](function(_0x16b68e){if(_0x16b68e){_0x5433c5[_0x711e('0x71')]=_['keys'](db['JscriptySessionReport'][_0x711e('0x72')]);_0x5433c5['query']=_[_0x711e('0x24')](_0x6aa404['query']);_0x5433c5['filters']=_['intersection'](_0x5433c5[_0x711e('0x71')],_0x5433c5['query']);_0x5a12a6[_0x711e('0x74')]=_['intersection'](_0x5433c5[_0x711e('0x71')],qs[_0x711e('0x76')](_0x6aa404[_0x711e('0x1d')][_0x711e('0x76')]));_0x5a12a6[_0x711e('0x74')]=_0x5a12a6[_0x711e('0x74')][_0x711e('0x25')]?_0x5a12a6[_0x711e('0x74')]:_0x5433c5[_0x711e('0x71')];if(!_0x6aa404[_0x711e('0x1d')]['hasOwnProperty'](_0x711e('0x7a'))){_0x5a12a6[_0x711e('0xe')]=qs[_0x711e('0xe')](_0x6aa404[_0x711e('0x1d')]['limit']);_0x5a12a6[_0x711e('0x10')]=qs['offset'](_0x6aa404['query']['offset']);}_0x5a12a6[_0x711e('0x77')]=qs[_0x711e('0x78')](_0x6aa404[_0x711e('0x1d')][_0x711e('0x78')]);_0x5a12a6[_0x711e('0x55')]=qs['filters'](_[_0x711e('0x93')](_0x6aa404['query'],_0x5433c5[_0x711e('0x73')]));_0x5a12a6[_0x711e('0x55')][_0x711e('0x9b')]=_0x16b68e['id'];if(_0x6aa404[_0x711e('0x1d')][_0x711e('0x79')]){_0x5a12a6[_0x711e('0x55')]=_['merge'](_0x5a12a6['where'],{'$or':_[_0x711e('0x64')](_0x5a12a6['attributes'],function(_0x3db039){var _0x5b0641={};_0x5b0641[_0x3db039]={'$like':'%'+_0x6aa404['query'][_0x711e('0x79')]+'%'};return _0x5b0641;})});}_0x5a12a6=_[_0x711e('0x31')]({},_0x5a12a6,_0x6aa404[_0x711e('0x94')]);return db[_0x711e('0x9d')][_0x711e('0xf')]({'where':_0x5a12a6[_0x711e('0x55')]})[_0x711e('0x1a')](function(_0x46a0fa){_0x111cb8['count']=_0x46a0fa;if(_0x6aa404[_0x711e('0x1d')]['includeAll']){_0x5a12a6[_0x711e('0x96')]=[{'all':!![]}];}return db[_0x711e('0x9d')][_0x711e('0x1c')](_0x5a12a6);})[_0x711e('0x1a')](function(_0x94d64f){_0x111cb8[_0x711e('0x99')]=_0x94d64f;return _0x111cb8;});}})[_0x711e('0x1a')](respondWithFilteredResult(_0x31892b,_0x5a12a6))['catch'](handleError(_0x31892b,null));};exports[_0x711e('0x9e')]=function(_0x58e83d,_0x379f16){try{if(!_0x58e83d['body'][_0x711e('0x56')]){throw new Error(_0x711e('0x9f'));}if(!_0x58e83d['body'][_0x711e('0xa0')]){throw new Error(_0x711e('0xa1'));}if(!_0x58e83d[_0x711e('0x32')][_0x711e('0xa2')]){throw new Error(_0x711e('0xa3'));}if(!_0x58e83d[_0x711e('0x32')][_0x711e('0xa4')]){throw new Error(_0x711e('0xa5'));}var _0x3cae16=_0x58e83d['body'][_0x711e('0xa0')]['split'](',');var _0x1b84fc=_0x58e83d[_0x711e('0x32')]['binding_values'][_0x711e('0xa6')](',');if(!_0x3cae16[_0x711e('0x25')]||!_0x1b84fc[_0x711e('0x25')]||_0x3cae16[_0x711e('0x25')]!==_0x1b84fc[_0x711e('0x25')]){throw new Error('Incorrect\x20binding\x20parameters\x20passed!');}_0x58e83d[_0x711e('0x32')][_0x711e('0x76')]=_[_0x711e('0xa7')](_0x3cae16,_0x1b84fc);if(!_0x58e83d[_0x711e('0x32')][_0x711e('0x76')][_0x711e('0x6e')]){throw new Error(_0x711e('0xa8'));}if(!_0x58e83d['body'][_0x711e('0x76')][_0x711e('0xa9')]){throw new Error(_0x711e('0xaa'));}var _0x2715a6=path[_0x711e('0x36')](config[_0x711e('0xab')],'server/files/tmp',_0x58e83d[_0x711e('0xac')][_0x711e('0xad')]);fs[_0x711e('0xae')](_0x2715a6,parseInt(_0x711e('0xaf'),0x8));var _0x14d140=require('child_process')['fork'](path[_0x711e('0x36')](__dirname,_0x711e('0xb0')),[_0x2715a6,_0x58e83d[_0x711e('0x32')][_0x711e('0xa0')],_0x58e83d[_0x711e('0x32')]['binding_values'],_0x58e83d[_0x711e('0x32')]['ListId'],_0x58e83d[_0x711e('0x32')][_0x711e('0xb1')],_0x58e83d[_0x711e('0x32')][_0x711e('0x53')],_0x58e83d[_0x711e('0x32')][_0x711e('0xa4')]]);return _0x379f16[_0x711e('0xd')](0xc8)[_0x711e('0xb2')]({'message':'File\x20uploaded\x20correctly!','pid':_0x14d140['pid']});}catch(_0x3ca055){return _0x379f16[_0x711e('0xd')](0x1f4)['send'](_0x3ca055);}};exports['upload']=function(_0x2af645,_0x298e5f){var _0x4dcd5a=fs[_0x711e('0xb3')](_0x2af645[_0x711e('0xac')][_0x711e('0x2')]);Papa[_0x711e('0xb4')](_0x4dcd5a,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x2e86ec){return _0x298e5f[_0x711e('0xd')](0xc8)['json']({'file':_0x2af645[_0x711e('0xac')],'fields':_0x2e86ec[_0x711e('0xb5')]['fields']});}});};exports[_0x711e('0xb6')]=function(_0x1dfd46,_0x270148){return db[_0x711e('0xb7')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})['then'](function(_0x18a342){var _0x1c5849=![];if(!_0x1dfd46[_0x711e('0x32')]['ListId']){throw new Error(_0x711e('0x9f'));}if(!_0x1dfd46[_0x711e('0x32')][_0x711e('0xb8')]['phone']){throw new Error(_0x711e('0xa8'));}if(!_0x1dfd46[_0x711e('0x32')][_0x711e('0xb8')][_0x711e('0xa9')]){throw new Error(_0x711e('0xaa'));}if(!_0x1dfd46['body'][_0x711e('0xa4')]){throw new Error(_0x711e('0xa5'));}var _0x543374=require('child_process')[_0x711e('0xb9')](path[_0x711e('0x36')](__dirname,_0x711e('0xba')),[_0x1dfd46['params']['id'],JSON[_0x711e('0xbb')](_0x1dfd46[_0x711e('0x32')]),JSON[_0x711e('0xbb')](_0x18a342)]);_0x543374['on'](_0x711e('0xbc'),function(){_0x1c5849=!![];return _0x270148[_0x711e('0xd')](0xc8)[_0x711e('0xb2')]({'message':'start\x20child\x20process\x20correctly!','pid':_0x543374[_0x711e('0xbd')]});});_0x543374['on'](_0x711e('0xbe'),function(_0x2b0f0d){if(_0x2b0f0d&&!_0x1c5849){return _0x270148['status'](0x1f4)['json']({'message':_0x711e('0xbf'),'pid':_0x543374['pid']});}});})[_0x711e('0x1f')](handleError(_0x270148,null));};exports[_0x711e('0xc0')]=function(_0x49ba21,_0x1c2e28){return db[_0x711e('0xb7')][_0x711e('0x1c')]({'raw':!![],'attributes':['id'],'where':{'role':_0x711e('0xc1')}})[_0x711e('0x1a')](function(_0x623fda){var _0x2ac158=![];if(!_0x49ba21[_0x711e('0x32')][_0x711e('0x56')]){throw new Error(_0x711e('0x9f'));}if(!_0x49ba21[_0x711e('0x32')][_0x711e('0xb8')]['phone']){throw new Error(_0x711e('0xa8'));}if(!_0x49ba21[_0x711e('0x32')][_0x711e('0xb8')][_0x711e('0xa9')]){throw new Error(_0x711e('0xaa'));}if(!_0x49ba21[_0x711e('0x32')][_0x711e('0xa4')]){throw new Error(_0x711e('0xa5'));}var _0x2eaf26=require(_0x711e('0xc2'))[_0x711e('0xb9')](path['join'](__dirname,_0x711e('0xc3')),[_0x49ba21[_0x711e('0x21')]['id'],JSON[_0x711e('0xbb')](_0x49ba21[_0x711e('0x32')]),JSON[_0x711e('0xbb')](_0x623fda)]);_0x2eaf26['on']('message',function(){_0x2ac158=!![];return _0x1c2e28[_0x711e('0xd')](0xc8)['json']({'message':_0x711e('0xc4'),'pid':_0x2eaf26['pid']});});_0x2eaf26['on']('exit',function(_0x52989a){if(_0x52989a&&!_0x2ac158){return _0x1c2e28[_0x711e('0xd')](0x1f4)['json']({'message':'error\x20child\x20process','pid':_0x2eaf26[_0x711e('0xbd')]});}});})[_0x711e('0x1f')](handleError(_0x1c2e28,null));};exports[_0x711e('0xc5')]=function(_0x4aa92d,_0x15476c){var _0x5e284a=[_0x711e('0xc6'),_0x711e('0xc7'),'sms',_0x711e('0xc8'),_0x711e('0xc9'),'whatsapp',_0x711e('0xca')];var _0x27a3fb={'offset':0x0,'order':qs['sort']('-createdAt')},_0x3fbf46={'count':0x0,'rows':[]};Promise['resolve']()[_0x711e('0x1a')](function(){if(_0x4aa92d[_0x711e('0x1d')][_0x711e('0xcb')]){if(!_[_0x711e('0xcc')](_0x5e284a,_0x4aa92d[_0x711e('0x1d')][_0x711e('0xcb')][_0x711e('0xcd')]())){throw new Error(_0x711e('0xce'));}_0x5e284a=[_0x4aa92d[_0x711e('0x1d')][_0x711e('0xcb')][_0x711e('0xcd')]()];}if(_0x4aa92d['query'][_0x711e('0xcf')]){try{var _0x1b2873=JSON[_0x711e('0xb4')](_0x4aa92d[_0x711e('0x1d')][_0x711e('0xcf')]);if(!moment(_0x1b2873['from'])[_0x711e('0xd0')]()){throw new Error(_0x711e('0xd1'));}if(!moment(_0x1b2873['to'])['isValid']()){throw new Error(_0x711e('0xd2'));}}catch(_0x472246){throw new Error(_0x711e('0xd3'));}}if(!_0x4aa92d[_0x711e('0x1d')][_0x711e('0x30')](_0x711e('0x7a'))){_0x27a3fb['limit']=qs[_0x711e('0xe')](_0x4aa92d['query'][_0x711e('0xe')]||0xa);_0x27a3fb[_0x711e('0x10')]=qs[_0x711e('0x10')](_0x4aa92d[_0x711e('0x1d')]['offset']);}var _0xead829=_0x5e284a[_0x711e('0x64')](function(_0x26d349){if(_0x26d349===_0x711e('0xca')){var _0x1b1dac={'attributes':['id','uniqueid',_0x711e('0x2c'),'source',_0x711e('0xd4'),_0x711e('0xd5'),_0x711e('0xd6'),_0x711e('0xd7'),_0x711e('0xd8'),_0x711e('0xd9'),'createdAt','userDisposition',_0x711e('0xda'),_0x711e('0xdb'),_0x711e('0xdc')],'where':{'ContactId':_0x4aa92d['params']['id']},'include':[{'model':db['User'],'as':'User','attributes':['id','name',_0x711e('0xdd'),'alias']}],'order':[['createdAt',_0x711e('0xde')]]};if(_0x4aa92d[_0x711e('0x1d')][_0x711e('0xcf')]){_0x1b1dac[_0x711e('0x55')]['createdAt']={'$gte':_0x1b2873[_0x711e('0x33')],'$lte':_0x1b2873['to']};}return db[_0x711e('0x48')][_0x711e('0xdf')](_0x1b1dac)[_0x711e('0x1a')](function(_0x965422){_0x3fbf46[_0x711e('0xf')]+=_0x965422[_0x711e('0xf')];return _[_0x711e('0x64')](_0x965422[_0x711e('0x99')],function(_0x2151d8){var _0x1c15ea=_0x2151d8['get']({'plain':!![]});_0x1c15ea[_0x711e('0xcb')]=_0x26d349;if(_0x1c15ea[_0x711e('0xb7')]){_0x1c15ea[_0x711e('0xb7')]={'id':_0x1c15ea[_0x711e('0xb7')]['id'],'name':_0x1c15ea[_0x711e('0xb7')][_0x711e('0x16')],'fullname':_0x1c15ea[_0x711e('0xb7')]['fullname'],'alias':_0x1c15ea[_0x711e('0xb7')][_0x711e('0xe0')]};}return _0x1c15ea;});});}else{var _0x355020=_[_0x711e('0xe1')](_0x26d349)+(_0x26d349===_0x711e('0xc7')?_0x711e('0xe2'):_0x711e('0xe3'));var _0x2aabe9={'attributes':['id',_0x711e('0xe4'),_0x711e('0xe5'),'createdAt',_0x711e('0xd9'),_0x711e('0xe6'),_0x711e('0xe7'),'thirdDisposition','UserId',_0x355020+'Id'],'where':{'ContactId':_0x4aa92d[_0x711e('0x21')]['id']},'include':[{'model':db[_0x355020],'as':_0x711e('0xe3'),'attributes':['id','name',_0x711e('0xe8')]},{'model':db[_0x711e('0xb7')],'as':_0x711e('0xe9'),'attributes':['id',_0x711e('0x16'),_0x711e('0xdd')]},{'model':db['Tag'],'as':_0x711e('0xea'),'attributes':['id',_0x711e('0x16'),'color'],'through':{'attributes':[]}}],'order':[[_0x711e('0xeb'),_0x711e('0xde')]]};if(_0x4aa92d[_0x711e('0x1d')][_0x711e('0xcf')]){_0x2aabe9[_0x711e('0x55')][_0x711e('0xeb')]={'$gte':_0x1b2873['from'],'$lte':_0x1b2873['to']};}switch(_0x26d349){case _0x711e('0xc7'):_0x2aabe9[_0x711e('0x74')]['push'](_0x711e('0xec'),_0x711e('0xed'),_0x711e('0xee'),'deviceModel',_0x711e('0xef'),_0x711e('0xf0'),_0x711e('0xf1'),_0x711e('0xf2'),'referer');break;case _0x711e('0xc6'):_0x2aabe9[_0x711e('0x74')][_0x711e('0x59')]('subject',_0x711e('0xf3'));break;case'openchannel':_0x2aabe9[_0x711e('0x74')][_0x711e('0x59')](_0x711e('0xf4'),'threadId');break;}return db[_[_0x711e('0xe1')](_0x26d349)+_0x711e('0xf5')][_0x711e('0xdf')](_0x2aabe9)[_0x711e('0x1a')](function(_0xd91ac8){_0x3fbf46[_0x711e('0xf')]+=_0xd91ac8['count'];return _[_0x711e('0x64')](_0xd91ac8[_0x711e('0x99')],function(_0x40310b){var _0x34d6c0=_0x40310b['get']({'plain':!![]});_0x34d6c0[_0x711e('0xcb')]=_0x26d349;if(_0x34d6c0[_0x711e('0xe9')]){_0x34d6c0[_0x711e('0xe9')]={'id':_0x34d6c0[_0x711e('0xe9')]['id'],'name':_0x34d6c0[_0x711e('0xe9')]['name'],'fullname':_0x34d6c0[_0x711e('0xe9')][_0x711e('0xdd')]};}return _0x34d6c0;});});}});return Promise[_0x711e('0x7e')](_0xead829);})[_0x711e('0x1a')](function(_0x49da13){return _(_0x49da13)[_0x711e('0xf6')]()[_0x711e('0xf7')](_0x711e('0xeb'))['reverse']()[_0x711e('0xf8')]();})[_0x711e('0x1a')](function(_0x2da984){_0x3fbf46[_0x711e('0x99')]=_0x27a3fb[_0x711e('0xe')]?_0x2da984[_0x711e('0xf9')](_0x27a3fb[_0x711e('0x10')],_0x27a3fb['offset']+_0x27a3fb[_0x711e('0xe')]):_0x2da984;return _0x3fbf46;})[_0x711e('0x1a')](respondWithFilteredResult(_0x15476c,_0x27a3fb))[_0x711e('0x1f')](handleError(_0x15476c,null));};
\ No newline at end of file
+var _0xcc82=['MailMessage','MailInteraction','SmsInteraction','SmsMessage','OpenchannelInteraction','CmContactHasItem','CmHopperFinal','CmHopperHistory','ReportAgentPreview','ChatQueueReport','FaxQueueReport','MailQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappMessage','WhatsappQueueReport','isNil','dialTimezone','timezones','utcOffset','additionalPhones','bulkCreate','each','duplicates','where','push','ListId','spread','contact','all','Tags','tag','Phones','ItemType','sequelize','literal','Phones.OrderBy','omit','map','format','$and','pickBy','startsWith','cf_%d','table','id\x20=\x20?','toParam','phone','getTags','findOne','model','Tag','filters','intersection','attributes','fields','pick','filter','options','nolimit','setTags','ContactItemType','OrderBy','items','item_types','ItemTypeId','description','contact\x20phone\x20exists','PHONE','CmHopperAdditionalPhone','item','`ItemType`.OrderBy','CmHopperId','ItemType.OrderBy','getAdditionalPhones','duplicateAdditionalPhones','fromContactId','CmContactId','toContactId','rescheduleAdditionalPhones','hopperId','getHoppers','rawAttributes','order','sort','includeAll','include','ContactId','rows','getHopperFinals','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','split','zipObject','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','file','filename','child_process','fork','../../components/import/cm/csv','CompanyId','pid','send','upload','createReadStream','parse','meta','User','binding','stringify','start\x20child\x20process\x20correctly!','exit','importUpdates','../../components/import/cm/csvUpdates','message','error\x20child\x20process','getJourney','chat','sms','openchannel','fax','whatsapp','voice','channel','includes','toLowerCase','Invalid\x20channel','range','Invalid\x20date\x20for\x20range\x20from\x20filter','Invalid\x20createdAt\x20filter','source','destination','callerid','starttime','endtime','note','userDisposition','userThirdDisposition','UserId','fullname','findAndCountAll','startCase','Account','createdAt','key','Owner','DESC','browserName','customerIp','deviceModel','osName','ratingMessage','ratingType','ratingValue','referer','mail','substatus','externalUrl','threadId','Interaction','value','slice','util','path','lodash','squel','papaparse','ioredis','../../components/contacts','../../components/parsers/qs','../../config/logger','api','../../config/environment/shared','../../mysqldb','defaults','redis','socket.io-emitter','register','json','offset','undefined','limit','count','status','set','Content-Range','then','sendStatus','error','stack','name','describe','getOptions','findAll','query','catch','destroy','CmContact','find','params','tags','keys','length','cf_','columnName','displayName','analytics','CmCustomField','alias','custom','type','values','info','Custom\x20field\x20%s\x20not\x20found\x20on\x20cm_contacts\x20table','hasOwnProperty','merge','body','from','get','mergeWith','isArray','join','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','CmHopperBlack','create','ChatInteraction','update','ChatMessage'];(function(_0x167cc1,_0x56ef5a){var _0x10bc4b=function(_0xd6a255){while(--_0xd6a255){_0x167cc1['push'](_0x167cc1['shift']());}};_0x10bc4b(++_0x56ef5a);}(_0xcc82,0xaa));var _0x2cc8=function(_0x132558,_0x521d93){_0x132558=_0x132558-0x0;var _0x34f138=_0xcc82[_0x132558];return _0x34f138;};'use strict';var moment=require('moment');var BPromise=require('bluebird');var util=require(_0x2cc8('0x0'));var path=require(_0x2cc8('0x1'));var fs=require('fs');var _=require(_0x2cc8('0x2'));var squel=require(_0x2cc8('0x3'));var Papa=require(_0x2cc8('0x4'));var Redis=require(_0x2cc8('0x5'));var contacts=require(_0x2cc8('0x6'));var qs=require(_0x2cc8('0x7'));var logger=require(_0x2cc8('0x8'))(_0x2cc8('0x9'));var config=require('../../config/environment');var shared=require(_0x2cc8('0xa'));var db=require(_0x2cc8('0xb'))['db'];config['redis']=_[_0x2cc8('0xc')](config[_0x2cc8('0xd')],{'host':'localhost','port':0x18eb});var socket=require(_0x2cc8('0xe'))(new Redis(config[_0x2cc8('0xd')]));require('./cmContact.socket')[_0x2cc8('0xf')](socket);function respondWithResult(_0x42e9f0,_0x3c1fdb){_0x3c1fdb=_0x3c1fdb||0xc8;return function(_0x4f68a5){if(_0x4f68a5){return _0x42e9f0['status'](_0x3c1fdb)[_0x2cc8('0x10')](_0x4f68a5);}};}function respondWithFilteredResult(_0x5e9452,_0x10b019){return function(_0x3d868b){if(_0x3d868b){var _0xd91dae=typeof _0x10b019[_0x2cc8('0x11')]===_0x2cc8('0x12')&&typeof _0x10b019[_0x2cc8('0x13')]===_0x2cc8('0x12');var _0x11baba=_0x3d868b[_0x2cc8('0x14')];var _0x3d3af8=_0xd91dae?0x0:_0x10b019[_0x2cc8('0x11')];var _0x72ec7b=_0xd91dae?_0x3d868b[_0x2cc8('0x14')]:_0x10b019[_0x2cc8('0x11')]+_0x10b019[_0x2cc8('0x13')];var _0x485240;if(_0x72ec7b>=_0x11baba){_0x72ec7b=_0x11baba;_0x485240=0xc8;}else{_0x485240=0xce;}_0x5e9452[_0x2cc8('0x15')](_0x485240);return _0x5e9452[_0x2cc8('0x16')](_0x2cc8('0x17'),_0x3d3af8+'-'+_0x72ec7b+'/'+_0x11baba)['json'](_0x3d868b);}return null;};}function saveUpdates(_0x813956){return function(_0x1e4679){if(_0x1e4679){return _0x1e4679['update'](_0x813956)['then'](function(_0x5b89bf){return _0x5b89bf;});}return null;};}function removeEntity(_0x4df407){return function(_0x1d4b5e){if(_0x1d4b5e){return _0x1d4b5e['destroy']()[_0x2cc8('0x18')](function(){_0x4df407[_0x2cc8('0x15')](0xcc)['end']();});}};}function handleEntityNotFound(_0x20950c){return function(_0x27ce35){if(!_0x27ce35){_0x20950c[_0x2cc8('0x19')](0x194);}return _0x27ce35;};}function handleError(_0x1519c2,_0x2d84a8){_0x2d84a8=_0x2d84a8||0x1f4;return function(_0x246c9f){logger[_0x2cc8('0x1a')](_0x246c9f[_0x2cc8('0x1b')]);if(_0x246c9f['name']){delete _0x246c9f[_0x2cc8('0x1c')];}_0x1519c2[_0x2cc8('0x15')](_0x2d84a8)['send'](_0x246c9f);};}exports['index']=function(_0xb140b9,_0x57b53e){var _0xc24a65={};return contacts[_0x2cc8('0x1d')]()[_0x2cc8('0x18')](function(_0x5ecca0){_0xc24a65=qs[_0x2cc8('0x1e')](_0x5ecca0,_0xb140b9);return contacts[_0x2cc8('0x1f')](_0xb140b9[_0x2cc8('0x20')],_0xb140b9['user'],_0xc24a65,_0x5ecca0);})['then'](respondWithFilteredResult(_0x57b53e,_0xc24a65))[_0x2cc8('0x21')](handleError(_0x57b53e,null));};exports[_0x2cc8('0x22')]=function(_0x29cb1a,_0xff0f42){return db[_0x2cc8('0x23')][_0x2cc8('0x24')]({'where':{'id':_0x29cb1a[_0x2cc8('0x25')]['id']}})[_0x2cc8('0x18')](handleEntityNotFound(_0xff0f42,null))[_0x2cc8('0x18')](removeEntity(_0xff0f42,null))[_0x2cc8('0x21')](handleError(_0xff0f42,null));};exports['describe']=function(_0x241b5d,_0x4f4217){return db[_0x2cc8('0x23')]['describe']()[_0x2cc8('0x18')](function(_0xff2a69){delete _0xff2a69[_0x2cc8('0x26')];for(var _0x5af4d7=0x0;_0x5af4d7<Object[_0x2cc8('0x27')](_0xff2a69)[_0x2cc8('0x28')];_0x5af4d7++){var _0x34132a=Object[_0x2cc8('0x27')](_0xff2a69)[_0x5af4d7];if(!_['startsWith'](_0x34132a,_0x2cc8('0x29'))){_0xff2a69[_0x34132a][_0x2cc8('0x2a')]=_0x34132a;_0xff2a69[_0x34132a][_0x2cc8('0x2b')]=_0x34132a;}}return _0xff2a69;})[_0x2cc8('0x18')](function(_0x498fd3){var _0xbde7c1={'where':Boolean(_0x241b5d[_0x2cc8('0x20')][_0x2cc8('0x2c')])===!![]?undefined:{'$or':[{'ListId':_0x241b5d[_0x2cc8('0x20')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x2cc8('0x2d')]['findAll'](_0xbde7c1)['then'](function(_0x2d6ea2){for(var _0x5c30fc=0x0;_0x5c30fc<_0x2d6ea2[_0x2cc8('0x28')];_0x5c30fc++){var _0x4cce2e=_0x2cc8('0x29')+_0x2d6ea2[_0x5c30fc]['id'];if(_0x498fd3[_0x4cce2e]){_0x498fd3[_0x4cce2e][_0x2cc8('0x2a')]=_0x4cce2e;_0x498fd3[_0x4cce2e][_0x2cc8('0x2b')]=_0x2d6ea2[_0x5c30fc][_0x2cc8('0x2e')];_0x498fd3[_0x4cce2e][_0x2cc8('0x2f')]={'type':_0x2d6ea2[_0x5c30fc][_0x2cc8('0x30')],'values':_0x2d6ea2[_0x5c30fc][_0x2cc8('0x31')]};}else{logger[_0x2cc8('0x32')](_0x2cc8('0x33'),_0x4cce2e);}}Object[_0x2cc8('0x27')](_0x498fd3)['forEach'](function(_0x499f8f){if(!_0x498fd3[_0x499f8f][_0x2cc8('0x34')]('columnName')){delete _0x498fd3[_0x499f8f];}});return _0x498fd3;});})['then'](respondWithResult(_0x4f4217,null))[_0x2cc8('0x21')](handleError(_0x4f4217,null));};exports[_0x2cc8('0x35')]=function(_0x32ecc1,_0x1d302a){var _0xff4e0;var _0xe0d9f4;var _0x202fd6;if(_0x32ecc1[_0x2cc8('0x36')]['id']){delete _0x32ecc1[_0x2cc8('0x36')]['id'];}return db[_0x2cc8('0x23')]['findAll']({'where':{'id':[_0x32ecc1[_0x2cc8('0x36')]['to'],_0x32ecc1['body'][_0x2cc8('0x37')]]}})[_0x2cc8('0x18')](function(_0x362c88){if(_0x362c88){if(_0x362c88[_0x2cc8('0x28')]!==0x2){return null;}_0x362c88[0x0]=_0x362c88[0x0]['get']({'plain':!![]});_0x362c88[0x1]=_0x362c88[0x1][_0x2cc8('0x38')]({'plain':!![]});delete _0x362c88[0x0]['id'];delete _0x362c88[0x1]['id'];return _[_0x2cc8('0x39')](_0x362c88[0x0],_0x362c88[0x1],function(_0x42ff20,_0x1ba3d9){if(Array[_0x2cc8('0x3a')](_0x1ba3d9)&&!_0x1ba3d9['length']){return _0x42ff20;}else if(!_0x1ba3d9){return _0x42ff20;}});}})['then'](handleEntityNotFound(_0x1d302a,null))['then'](function(_0x10eb23){if(_0x10eb23){if(_0x10eb23[_0x2cc8('0x26')]&&_[_0x2cc8('0x3a')](_0x10eb23['tags'])){_0x10eb23[_0x2cc8('0x26')]=_0x10eb23[_0x2cc8('0x26')][_0x2cc8('0x3b')]();}logger['info'](_0x2cc8('0x3c'),_0x32ecc1[_0x2cc8('0x36')]['to'],_0x32ecc1[_0x2cc8('0x36')][_0x2cc8('0x37')]);return db[_0x2cc8('0x3d')][_0x2cc8('0x22')]({'where':{'ContactId':[_0x32ecc1['body']['to'],_0x32ecc1[_0x2cc8('0x36')][_0x2cc8('0x37')]]}})['then'](function(_0x5f0dca){logger[_0x2cc8('0x32')]('[CmContact][merge][destroy][CmHopper],\x20%s',_0x5f0dca);return db[_0x2cc8('0x3e')][_0x2cc8('0x22')]({'where':{'ContactId':[_0x32ecc1[_0x2cc8('0x36')]['to'],_0x32ecc1[_0x2cc8('0x36')][_0x2cc8('0x37')]]}})['then'](function(_0x14d0d2){logger['info']('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x14d0d2);return db['CmContact'][_0x2cc8('0x3f')](_0x10eb23);});});}})[_0x2cc8('0x18')](function(_0x35d744){if(_0x35d744){_0xff4e0=_0x35d744;_0xe0d9f4={'ContactId':_0xff4e0['id']};_0x202fd6={'where':{'ContactId':[_0x32ecc1['body']['to'],_0x32ecc1['body'][_0x2cc8('0x37')]]}};return db[_0x2cc8('0x40')][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db[_0x2cc8('0x42')][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db['ChatOfflineMessage'][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db['MailInteraction'][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db[_0x2cc8('0x43')][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db[_0x2cc8('0x44')]['update'](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db[_0x2cc8('0x43')][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})['then'](function(){if(_0xff4e0){return db[_0x2cc8('0x45')][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})['then'](function(){if(_0xff4e0){return db[_0x2cc8('0x46')][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db['FaxInteraction'][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db['FaxMessage']['update'](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db[_0x2cc8('0x47')][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db['OpenchannelMessage'][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db[_0x2cc8('0x48')]['update']({'CmContactId':_0xff4e0['id']},{'where':{'CmContactId':[_0x32ecc1[_0x2cc8('0x36')]['to'],_0x32ecc1['body'][_0x2cc8('0x37')]]}});}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db[_0x2cc8('0x49')][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db[_0x2cc8('0x4a')][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db[_0x2cc8('0x4b')][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db['VoiceCallReport'][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db[_0x2cc8('0x4c')][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db[_0x2cc8('0x4d')][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db[_0x2cc8('0x4e')][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db['OpenchannelQueueReport'][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db[_0x2cc8('0x4f')][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db[_0x2cc8('0x50')][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})['then'](function(){if(_0xff4e0){return db['WhatsappInteraction'][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db[_0x2cc8('0x51')][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})[_0x2cc8('0x18')](function(){if(_0xff4e0){return db[_0x2cc8('0x52')][_0x2cc8('0x41')](_0xe0d9f4,_0x202fd6);}})['then'](function(){if(_0xff4e0){return db[_0x2cc8('0x23')][_0x2cc8('0x22')]({'where':{'id':[_0x32ecc1['body']['to'],_0x32ecc1[_0x2cc8('0x36')][_0x2cc8('0x37')]]}});}})['then'](function(){if(_0xff4e0){return _0xff4e0;}})[_0x2cc8('0x18')](respondWithResult(_0x1d302a,null))[_0x2cc8('0x21')](handleError(_0x1d302a,null));};exports[_0x2cc8('0x3f')]=function(_0x346391,_0x4ed0e6){return db[_0x2cc8('0x23')][_0x2cc8('0x1d')]()[_0x2cc8('0x18')](function(_0x376132){if(_0x346391[_0x2cc8('0x36')]['tags']&&_[_0x2cc8('0x3a')](_0x346391['body']['tags'])){if(_0x346391['body'][_0x2cc8('0x26')][_0x2cc8('0x28')]){_0x346391[_0x2cc8('0x36')]['tags']=_0x346391['body'][_0x2cc8('0x26')][_0x2cc8('0x3b')](';')+';';}else{_0x346391[_0x2cc8('0x36')][_0x2cc8('0x26')]=null;}}else{_0x346391[_0x2cc8('0x36')][_0x2cc8('0x26')]=null;}if(!_[_0x2cc8('0x53')](_0x346391[_0x2cc8('0x36')][_0x2cc8('0x54')])){var _0x42f916=_0x346391[_0x2cc8('0x36')][_0x2cc8('0x54')];if(!_[_0x2cc8('0x53')](shared[_0x2cc8('0x55')][_0x42f916]))_0x346391[_0x2cc8('0x36')][_0x2cc8('0x56')]=shared['timezones'][_0x42f916][_0x2cc8('0x56')];}return db['CmContact']['create'](_0x346391['body'],{'fields':_[_0x2cc8('0x27')](_0x376132),'raw':!![]});})[_0x2cc8('0x18')](function(_0x3d8724){if(_0x346391[_0x2cc8('0x36')][_0x2cc8('0x57')]){return insertAdditionalPhones(_0x3d8724,_0x346391[_0x2cc8('0x36')][_0x2cc8('0x57')]);}else{return _0x3d8724;}})[_0x2cc8('0x18')](respondWithResult(_0x4ed0e6,0xc9))[_0x2cc8('0x21')](handleError(_0x4ed0e6,null));};exports[_0x2cc8('0x58')]=function(_0x3fa2f8,_0x3f0f77){var _0x40a8d0=0x0;var _0x263141=0x0;var _0xa09e0d=0x0;var _0x1491b4=[];return db[_0x2cc8('0x23')][_0x2cc8('0x1d')]()['then'](function(_0x5dbeed){return BPromise[_0x2cc8('0x59')](_0x3fa2f8['body'],function(_0x12ca8a){var _0x279f78={'where':{'$or':[]},'defaults':_0x12ca8a,'fields':_[_0x2cc8('0x27')](_0x5dbeed),'raw':!![]};if(_0x12ca8a[_0x2cc8('0x5a')]){for(var _0x55c200=0x0;_0x55c200<_0x12ca8a[_0x2cc8('0x5a')][_0x2cc8('0x28')];_0x55c200++){var _0x505f80={};_0x505f80[_0x12ca8a[_0x2cc8('0x5a')][_0x55c200]]=_0x12ca8a[_0x12ca8a[_0x2cc8('0x5a')][_0x55c200]];_0x279f78[_0x2cc8('0x5b')]['$or'][_0x2cc8('0x5c')](_0x505f80);}_0x279f78[_0x2cc8('0x5b')][_0x2cc8('0x5d')]=_0x12ca8a[_0x2cc8('0x5d')];}return db['CmContact']['findOrCreate'](_0x279f78)[_0x2cc8('0x5e')](function(_0x1d66af,_0x32a909){if(_0x32a909){if(_0x12ca8a[_0x2cc8('0x34')](_0x2cc8('0x57'))){_0x1491b4[_0x2cc8('0x5c')]({'contact':_0x1d66af,'additionalPhones':_0x12ca8a[_0x2cc8('0x57')]});}_0x40a8d0++;}else{_0xa09e0d++;}})['catch'](function(){_0x263141++;});});})[_0x2cc8('0x18')](function(_0x11e3db){if(_0x11e3db){if(_0x1491b4[_0x2cc8('0x28')]>0x0){return new Promise(function(_0x450e46){var _0x359e01=[];for(var _0x377fb1=0x0;_0x377fb1<_0x1491b4['length'];_0x377fb1++){_0x359e01['push'](insertAdditionalPhones(_0x1491b4[_0x377fb1][_0x2cc8('0x5f')],_0x1491b4[_0x377fb1][_0x2cc8('0x57')]));}Promise[_0x2cc8('0x60')](_0x359e01)[_0x2cc8('0x18')](function(){_0x450e46(0x1);});})[_0x2cc8('0x18')](function(){return{'success':_0x40a8d0,'failure':_0x263141,'duplicates':_0xa09e0d};});}else{return{'success':_0x40a8d0,'failure':_0x263141,'duplicates':_0xa09e0d};}}})['then'](respondWithResult(_0x3f0f77,0xc9))[_0x2cc8('0x21')](handleError(_0x3f0f77,null));};exports['show']=function(_0x1b6b8f,_0x5a9378){var _0x18fc93;return db['CmContact'][_0x2cc8('0x1d')]()[_0x2cc8('0x18')](function(_0x505bbe){return db[_0x2cc8('0x23')]['find']({'where':{'id':_0x1b6b8f['params']['id']},'include':[{'model':db['Tag'],'as':_0x2cc8('0x61'),'attributes':['id',_0x2cc8('0x1c'),'color'],'required':_0x1b6b8f[_0x2cc8('0x20')][_0x2cc8('0x62')]?!![]:![]},{'model':db[_0x2cc8('0x48')],'as':_0x2cc8('0x63'),'where':{'CmContactId':_0x1b6b8f[_0x2cc8('0x25')]['id']},'required':![],'include':[{'model':db['ContactItemType'],'as':_0x2cc8('0x64')}]}],'order':[db[_0x2cc8('0x65')][_0x2cc8('0x66')](_0x2cc8('0x67'))],'attributes':_[_0x2cc8('0x27')](_0x505bbe)});})[_0x2cc8('0x18')](function(_0x3daf76){if(!_[_0x2cc8('0x53')](_0x3daf76)){_0x18fc93=_0x3daf76[_0x2cc8('0x38')]({'plain':!![]});var _0x200a7f={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x3daf76&&_0x3daf76[_0x2cc8('0x5d')]){if(_0x3daf76[_0x2cc8('0x5d')]){_0x200a7f['where']['$and'][_0x2cc8('0x5c')]({'ListId':{'$ne':_0x3daf76[_0x2cc8('0x5d')]}});}}return db[_0x2cc8('0x2d')][_0x2cc8('0x1f')](_0x200a7f);}})['then'](function(_0x48f0a5){if(!_[_0x2cc8('0x53')](_0x48f0a5)){return _[_0x2cc8('0x68')](_0x18fc93,_[_0x2cc8('0x69')](_0x48f0a5,function(_0x5b2282){return util[_0x2cc8('0x6a')]('cf_%d',_0x5b2282['id']);}));}})[_0x2cc8('0x18')](handleEntityNotFound(_0x5a9378,null))[_0x2cc8('0x18')](respondWithResult(_0x5a9378,null))[_0x2cc8('0x21')](handleError(_0x5a9378,null));};exports[_0x2cc8('0x41')]=function(_0xb9f6a7,_0x1c992b){var _0x1334b7;if(_0xb9f6a7[_0x2cc8('0x36')]['id']){delete _0xb9f6a7[_0x2cc8('0x36')]['id'];}if(!_[_0x2cc8('0x53')](_0xb9f6a7[_0x2cc8('0x36')]['dialTimezone'])){var _0x1626c5=_0xb9f6a7[_0x2cc8('0x36')]['dialTimezone'];if(!_[_0x2cc8('0x53')](shared[_0x2cc8('0x55')][_0x1626c5]))_0xb9f6a7[_0x2cc8('0x36')]['utcOffset']=shared[_0x2cc8('0x55')][_0x1626c5][_0x2cc8('0x56')];}return db[_0x2cc8('0x23')][_0x2cc8('0x24')]({'where':{'id':_0xb9f6a7['params']['id']}})[_0x2cc8('0x18')](handleEntityNotFound(_0x1c992b,null))['then'](saveUpdates(_0xb9f6a7[_0x2cc8('0x36')],null))[_0x2cc8('0x18')](function(_0x1f9614){_0x1334b7=_0x1f9614;var _0x5f4b51={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x1f9614&&_0x1f9614[_0x2cc8('0x5d')]){if(_0x1f9614['ListId']){_0x5f4b51[_0x2cc8('0x5b')][_0x2cc8('0x6b')][_0x2cc8('0x5c')]({'ListId':{'$ne':_0x1f9614['ListId']}});}}return db[_0x2cc8('0x2d')]['findAll'](_0x5f4b51);})[_0x2cc8('0x18')](function(_0xdda796){if(_0xdda796){return _[_0x2cc8('0x68')](_[_0x2cc8('0x6c')](_0xb9f6a7['body'],function(_0x4d62a4,_0x4a347f){return _[_0x2cc8('0x6d')](_0x4a347f,'cf_');}),_[_0x2cc8('0x69')](_0xdda796,function(_0x64605c){return util[_0x2cc8('0x6a')](_0x2cc8('0x6e'),_0x64605c['id']);}));}})[_0x2cc8('0x18')](function(_0xbe1739){if(_0xbe1739&&!_['isEmpty'](_0xbe1739)){var _0x50063d=squel[_0x2cc8('0x41')]()[_0x2cc8('0x6f')]('cm_contacts')['setFields'](_0xbe1739)[_0x2cc8('0x5b')](_0x2cc8('0x70'),_0xb9f6a7[_0x2cc8('0x25')]['id'])[_0x2cc8('0x71')]();return db[_0x2cc8('0x65')][_0x2cc8('0x20')](_0x50063d['text'],{'replacements':_0x50063d[_0x2cc8('0x31')]});}})[_0x2cc8('0x18')](function(){if(_0xb9f6a7[_0x2cc8('0x36')][_0x2cc8('0x72')]&&_0x1334b7){return db['CmHopper'][_0x2cc8('0x41')]({'phone':_0xb9f6a7[_0x2cc8('0x36')][_0x2cc8('0x72')],'OrderBy':0x0},{'where':{'ContactId':_0x1334b7['id']}});}})[_0x2cc8('0x18')](function(){return _0x1334b7;})[_0x2cc8('0x18')](respondWithResult(_0x1c992b,null))[_0x2cc8('0x21')](handleError(_0x1c992b,null));};exports[_0x2cc8('0x73')]=function(_0x2e365c,_0x33cf14){var _0x2650dc={};var _0xc2adf9={};var _0xb1f1e3;var _0x1d795b;return db['CmContact'][_0x2cc8('0x74')]({'where':{'id':_0x2e365c[_0x2cc8('0x25')]['id']}})['then'](handleEntityNotFound(_0x33cf14,null))[_0x2cc8('0x18')](function(_0x4f2f4b){if(_0x4f2f4b){_0xb1f1e3=_0x4f2f4b;_0xc2adf9[_0x2cc8('0x75')]=_['keys'](db[_0x2cc8('0x76')]['rawAttributes']);_0xc2adf9[_0x2cc8('0x20')]=_[_0x2cc8('0x27')](_0x2e365c['query']);_0xc2adf9[_0x2cc8('0x77')]=_[_0x2cc8('0x78')](_0xc2adf9[_0x2cc8('0x75')],_0xc2adf9[_0x2cc8('0x20')]);_0x2650dc[_0x2cc8('0x79')]=_[_0x2cc8('0x78')](_0xc2adf9[_0x2cc8('0x75')],qs[_0x2cc8('0x7a')](_0x2e365c[_0x2cc8('0x20')]['fields']));_0x2650dc[_0x2cc8('0x79')]=_0x2650dc[_0x2cc8('0x79')][_0x2cc8('0x28')]?_0x2650dc[_0x2cc8('0x79')]:_0xc2adf9['model'];_0x2650dc['order']=qs['sort'](_0x2e365c[_0x2cc8('0x20')]['sort']);_0x2650dc['where']=qs[_0x2cc8('0x77')](_[_0x2cc8('0x7b')](_0x2e365c['query'],_0xc2adf9[_0x2cc8('0x77')]));if(_0x2e365c[_0x2cc8('0x20')][_0x2cc8('0x7c')]){_0x2650dc['where']=_[_0x2cc8('0x35')](_0x2650dc['where'],{'$or':_[_0x2cc8('0x69')](_0x2650dc[_0x2cc8('0x79')],function(_0x5aba48){var _0x3c4dbd={};_0x3c4dbd[_0x5aba48]={'$like':'%'+_0x2e365c['query']['filter']+'%'};return _0x3c4dbd;})});}_0x2650dc=_[_0x2cc8('0x35')]({},_0x2650dc,_0x2e365c[_0x2cc8('0x7d')]);return _0xb1f1e3[_0x2cc8('0x73')](_0x2650dc);}})[_0x2cc8('0x18')](function(_0x2e87d2){if(_0x2e87d2){_0x1d795b=_0x2e87d2['length'];if(!_0x2e365c[_0x2cc8('0x20')]['hasOwnProperty'](_0x2cc8('0x7e'))){_0x2650dc['limit']=qs[_0x2cc8('0x13')](_0x2e365c[_0x2cc8('0x20')][_0x2cc8('0x13')]);_0x2650dc[_0x2cc8('0x11')]=qs[_0x2cc8('0x11')](_0x2e365c['query'][_0x2cc8('0x11')]);}return _0xb1f1e3[_0x2cc8('0x73')](_0x2650dc);}})['then'](function(_0x58c407){if(_0x58c407){return _0x58c407?{'count':_0x1d795b,'rows':_0x58c407}:null;}})['then'](respondWithResult(_0x33cf14,null))[_0x2cc8('0x21')](handleError(_0x33cf14,null));};exports[_0x2cc8('0x7f')]=function(_0x44e7f1,_0x316df8){if(_0x44e7f1[_0x2cc8('0x36')]['id']){delete _0x44e7f1['body']['id'];}return db['CmContact'][_0x2cc8('0x74')]({'where':{'id':_0x44e7f1[_0x2cc8('0x25')]['id']}})[_0x2cc8('0x18')](handleEntityNotFound(_0x316df8,null))[_0x2cc8('0x18')](function(_0x40d8d4){if(_0x40d8d4){return _0x40d8d4[_0x2cc8('0x7f')](_0x44e7f1[_0x2cc8('0x36')]['ids']||[]);}return null;})[_0x2cc8('0x18')](respondWithResult(_0x316df8,null))[_0x2cc8('0x21')](handleError(_0x316df8,null));};exports['setAdditionalPhones']=function(_0x5c22f7,_0x371bef){var _0x29e1d9=[];_0x29e1d9[_0x2cc8('0x5c')](addAdditionalPhones(_0x5c22f7[_0x2cc8('0x36')]));Promise[_0x2cc8('0x60')](_0x29e1d9)[_0x2cc8('0x18')](function(){_0x29e1d9=[];_0x29e1d9[_0x2cc8('0x5c')](deleteCmHopperPhones(_0x5c22f7[_0x2cc8('0x36')]['id']));_0x29e1d9['push'](addCmHopperPhones(_0x5c22f7[_0x2cc8('0x36')]['id']));Promise['all'](_0x29e1d9)[_0x2cc8('0x18')](function(){return[0x1];})[_0x2cc8('0x18')](respondWithResult(_0x371bef,null));});};function addAdditionalPhones(_0x1c3ad2){var _0x51f5a3;return new Promise(function(_0x75047){return db['CmContactHasItem'][_0x2cc8('0x22')]({'where':{'CmContactId':_0x1c3ad2['id']}})[_0x2cc8('0x18')](function(){db[_0x2cc8('0x80')]['findAll']({'raw':!![],'attributes':['id',_0x2cc8('0x81')]})[_0x2cc8('0x18')](function(_0x387cbf){var _0x1414a4=[];for(var _0x2a77cb=0x0;_0x2a77cb<_0x1c3ad2[_0x2cc8('0x82')]['length'];_0x2a77cb++){var _0x32a0b6=_0x1c3ad2[_0x2cc8('0x83')]?_['isNil'](_0x1c3ad2['item_types'][_0x2a77cb])?'':_0x1c3ad2[_0x2cc8('0x83')][_0x2a77cb]:_0x1c3ad2['items'][_0x2a77cb][_0x2cc8('0x84')]?_0x1c3ad2['items'][_0x2a77cb]['ItemTypeId']:'';var _0x18e5cb=_[_0x2cc8('0x53')](_0x1c3ad2[_0x2cc8('0x82')][_0x2a77cb][_0x2cc8('0x85')])?'':_0x1c3ad2[_0x2cc8('0x82')][_0x2a77cb][_0x2cc8('0x85')];var _0x17d6c8=_0x32a0b6+':'+_0x1c3ad2['items'][_0x2a77cb][_0x2cc8('0x72')]+'§'+_0x18e5cb;if(_[_0x2cc8('0x53')](_0x51f5a3))_0x51f5a3=_0x17d6c8;else _0x51f5a3+=';'+_0x17d6c8;var _0x55c978=null;var _0x4cc228=null;if(_0x1c3ad2[_0x2cc8('0x83')]){if(!_[_0x2cc8('0x53')](_0x1c3ad2['item_types'][_0x2a77cb])){_0x4cc228=_[_0x2cc8('0x24')](_0x387cbf,function(_0x198f3c){return _0x198f3c['id']===_0x1c3ad2[_0x2cc8('0x83')][_0x2a77cb];});if(!_[_0x2cc8('0x53')](_0x4cc228)){_0x55c978=_0x4cc228[_0x2cc8('0x81')];}}}else{if(!_[_0x2cc8('0x53')](_0x1c3ad2[_0x2cc8('0x82')][_0x2a77cb])){_0x4cc228=_[_0x2cc8('0x24')](_0x387cbf,function(_0x35e68b){return _0x35e68b['id']===_0x1c3ad2['items'][_0x2a77cb][_0x2cc8('0x84')];});if(!_[_0x2cc8('0x53')](_0x4cc228)){_0x55c978=_0x2a77cb;}}}if(_[_0x2cc8('0x53')](_0x55c978)){_0x55c978=0x64;}_0x1414a4[_0x2cc8('0x5c')](addAdditionalPhone(_0x1c3ad2['id'],_0x1c3ad2[_0x2cc8('0x82')][_0x2a77cb][_0x2cc8('0x72')],_0x1c3ad2[_0x2cc8('0x83')]?_[_0x2cc8('0x53')](_0x1c3ad2[_0x2cc8('0x83')][_0x2a77cb])?null:_0x1c3ad2[_0x2cc8('0x83')][_0x2a77cb]:_0x1c3ad2[_0x2cc8('0x82')][_0x2a77cb]['ItemTypeId']?_0x1c3ad2[_0x2cc8('0x82')][_0x2a77cb]['ItemTypeId']:null,_0x55c978,_0x18e5cb));}Promise['all'](_0x1414a4)['then'](function(){db['CmContact']['update']({'AdditionalPhones':_0x51f5a3},{'where':{'id':_0x1c3ad2['id']}})[_0x2cc8('0x18')](function(){_0x75047(0x1);});});});});});}function addAdditionalPhone(_0x4e26b2,_0x18a4f6,_0x1e0590,_0x506efc,_0x5dc087){return db[_0x2cc8('0x48')][_0x2cc8('0x24')]({'where':{'CmContactId':_0x4e26b2,'item':_0x18a4f6}})[_0x2cc8('0x18')](function(_0x327e95){if(_0x327e95)logger['info'](_0x2cc8('0x86'),_0x327e95);else{db['CmContactHasItem'][_0x2cc8('0x3f')]({'CmContactId':_0x4e26b2,'item':_0x18a4f6,'ItemTypeId':_0x1e0590,'OrderBy':_0x506efc,'ItemClass':_0x2cc8('0x87'),'description':_0x5dc087});}});}function deleteCmHopperPhones(_0x36ad4f){return new Promise(function(_0x49524e){return db[_0x2cc8('0x3d')][_0x2cc8('0x1f')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x36ad4f}})['then'](function(_0x548a14){db[_0x2cc8('0x88')][_0x2cc8('0x22')]({'where':{'CmHopperId':{'$in':_[_0x2cc8('0x69')](_0x548a14,'id')}}});})[_0x2cc8('0x18')](function(){_0x49524e(0x1);});});}function addCmHopperPhones(_0x4e6697){return new Promise(function(_0x498257){return db[_0x2cc8('0x3d')][_0x2cc8('0x1f')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x4e6697}})[_0x2cc8('0x18')](function(_0x54b606){var _0x48afb4=[];_[_0x2cc8('0x69')](_0x54b606,function(_0xfdc7a3){_0x48afb4[_0x2cc8('0x5c')](createCmHopperPhone(_0x4e6697,_0xfdc7a3['id']));});Promise[_0x2cc8('0x60')](_0x48afb4)['then'](function(){_0x498257(0x1);});});});}function createCmHopperPhone(_0x3dce3d,_0x2eb1e5){return new Promise(function(_0x31c327){db[_0x2cc8('0x48')]['findAll']({'raw':!![],'attributes':[_0x2cc8('0x89'),'OrderBy'],'where':{'CmContactId':_0x3dce3d,'ItemClass':_0x2cc8('0x87')},'include':[{'model':db['ContactItemType'],'attributes':[_0x2cc8('0x81')],'as':'ItemType'}],'order':[_0x2cc8('0x81'),db[_0x2cc8('0x65')][_0x2cc8('0x66')](_0x2cc8('0x8a'))]})[_0x2cc8('0x18')](function(_0x5f4fe5){var _0x8199dd=0x1;var _0x1a0fb2=_[_0x2cc8('0x69')](_0x5f4fe5,function(_0x115173){_0x115173[_0x2cc8('0x8b')]=_0x2eb1e5;_0x115173[_0x2cc8('0x72')]=_0x115173['item'];_0x115173[_0x2cc8('0x81')]=_0x8199dd;delete _0x115173[_0x2cc8('0x8c')];_0x8199dd=_0x8199dd+0x1;return _0x115173;});return db['CmHopperAdditionalPhone'][_0x2cc8('0x58')](_0x1a0fb2,{});})[_0x2cc8('0x18')](function(){_0x31c327(0x1);});});}function insertAdditionalPhones(_0x3e2c0a,_0x342af6){return new Promise(function(_0x42ba91){var _0x478f6c=[];for(var _0x149748=0x0;_0x149748<_0x342af6['length'];_0x149748++){var _0x5d61bf=_0x342af6[_0x149748];_0x478f6c[_0x2cc8('0x5c')](parseContactItemType(_0x5d61bf));}Promise[_0x2cc8('0x60')](_0x478f6c)[_0x2cc8('0x18')](function(){var _0x268077={'id':_0x3e2c0a['id'],'items':_0x342af6};return addAdditionalPhones(_0x268077)['then'](function(){return addCmHopperPhones(_0x3e2c0a['id']);});})['then'](function(){_0x42ba91(_0x3e2c0a);});});}function parseContactItemType(_0x172a8c){return new Promise(function(_0x4cdb06){if(_0x172a8c['hasOwnProperty']('ItemTypeId')){_0x4cdb06(_0x172a8c);}else{return db['ContactItemType'][_0x2cc8('0x24')]({'where':{'name':_0x172a8c['ItemType']}})[_0x2cc8('0x18')](function(_0x356114){if(_[_0x2cc8('0x53')](_0x356114))_0x172a8c[_0x2cc8('0x84')]=null;else _0x172a8c['ItemTypeId']=_0x356114['id'];_0x4cdb06(_0x172a8c);});}});}exports[_0x2cc8('0x8d')]=function(_0x3b4a3a,_0x3b2666){return db[_0x2cc8('0x48')][_0x2cc8('0x1f')]({'raw':!![],'where':{'CmContactId':_0x3b4a3a[_0x2cc8('0x25')]['id'],'ItemClass':'PHONE'},'include':[{'model':db[_0x2cc8('0x80')],'as':_0x2cc8('0x64')}],'order':[[_0x2cc8('0x81')],[db[_0x2cc8('0x65')]['literal'](_0x2cc8('0x8a'))]]})[_0x2cc8('0x18')](function(_0x12c3d9){return _0x12c3d9;})['then'](respondWithResult(_0x3b2666,null))[_0x2cc8('0x21')](handleError(_0x3b2666,null));};exports[_0x2cc8('0x8e')]=function(_0x38dc1f,_0x3181d2){return db[_0x2cc8('0x48')][_0x2cc8('0x1f')]({'raw':!![],'where':{'CmContactId':_0x38dc1f['body'][_0x2cc8('0x8f')]}})[_0x2cc8('0x18')](function(_0x39459d){var _0x224722=_['map'](_0x39459d,function(_0x50a012){_0x50a012[_0x2cc8('0x90')]=_0x38dc1f[_0x2cc8('0x36')][_0x2cc8('0x91')];return _0x50a012;});return db[_0x2cc8('0x48')]['bulkCreate'](_0x224722,{});})['then'](function(){return addCmHopperPhones(_0x38dc1f[_0x2cc8('0x36')][_0x2cc8('0x91')]);})[_0x2cc8('0x18')](function(){return['ok'];})[_0x2cc8('0x18')](respondWithResult(_0x3181d2,null))[_0x2cc8('0x21')](handleError(_0x3181d2,null));};exports[_0x2cc8('0x92')]=function(_0x6f235d,_0x446c36){var _0x35407f=[];_0x35407f[_0x2cc8('0x5c')](createCmHopperPhone(_0x6f235d[_0x2cc8('0x36')]['id'],_0x6f235d[_0x2cc8('0x36')][_0x2cc8('0x93')]));Promise[_0x2cc8('0x60')](_0x35407f)['then'](function(){return[0x1];})[_0x2cc8('0x18')](respondWithResult(_0x446c36,null));};exports[_0x2cc8('0x94')]=function(_0x3ae9d5,_0x3857a2){var _0x4939e2={'raw':![],'where':{}};var _0x336063={};var _0x37b916={'count':0x0,'rows':[]};return db[_0x2cc8('0x23')][_0x2cc8('0x74')]({'where':{'id':_0x3ae9d5[_0x2cc8('0x25')]['id']}})[_0x2cc8('0x18')](handleEntityNotFound(_0x3857a2,null))['then'](function(_0x2d8f81){if(_0x2d8f81){_0x336063['model']=_['keys'](db[_0x2cc8('0x3d')][_0x2cc8('0x95')]);_0x336063[_0x2cc8('0x20')]=_['keys'](_0x3ae9d5[_0x2cc8('0x20')]);_0x336063[_0x2cc8('0x77')]=_[_0x2cc8('0x78')](_0x336063[_0x2cc8('0x75')],_0x336063['query']);_0x4939e2['attributes']=_['intersection'](_0x336063[_0x2cc8('0x75')],qs[_0x2cc8('0x7a')](_0x3ae9d5[_0x2cc8('0x20')][_0x2cc8('0x7a')]));_0x4939e2[_0x2cc8('0x79')]=_0x4939e2['attributes'][_0x2cc8('0x28')]?_0x4939e2[_0x2cc8('0x79')]:_0x336063[_0x2cc8('0x75')];if(!_0x3ae9d5[_0x2cc8('0x20')][_0x2cc8('0x34')](_0x2cc8('0x7e'))){_0x4939e2[_0x2cc8('0x13')]=qs[_0x2cc8('0x13')](_0x3ae9d5[_0x2cc8('0x20')][_0x2cc8('0x13')]);_0x4939e2['offset']=qs[_0x2cc8('0x11')](_0x3ae9d5[_0x2cc8('0x20')][_0x2cc8('0x11')]);}_0x4939e2[_0x2cc8('0x96')]=qs[_0x2cc8('0x97')](_0x3ae9d5['query'][_0x2cc8('0x97')]);_0x4939e2['where']=qs['filters'](_[_0x2cc8('0x7b')](_0x3ae9d5[_0x2cc8('0x20')],_0x336063[_0x2cc8('0x77')]));_0x4939e2['where']['ContactId']=_0x2d8f81['id'];if(_0x3ae9d5['query'][_0x2cc8('0x7c')]){_0x4939e2[_0x2cc8('0x5b')]=_['merge'](_0x4939e2[_0x2cc8('0x5b')],{'$or':_[_0x2cc8('0x69')](_0x4939e2['attributes'],function(_0x1c0757){var _0x479ce3={};_0x479ce3[_0x1c0757]={'$like':'%'+_0x3ae9d5['query'][_0x2cc8('0x7c')]+'%'};return _0x479ce3;})});}_0x4939e2=_[_0x2cc8('0x35')]({},_0x4939e2,_0x3ae9d5['options']);return db[_0x2cc8('0x3d')]['count']({'where':_0x4939e2['where']})[_0x2cc8('0x18')](function(_0x8dc782){_0x37b916['count']=_0x8dc782;if(_0x3ae9d5[_0x2cc8('0x20')][_0x2cc8('0x98')]){_0x4939e2[_0x2cc8('0x99')]=[{'all':!![]}];}return db[_0x2cc8('0x3d')]['findAll'](_0x4939e2);})[_0x2cc8('0x18')](function(_0x857cb8){_0x37b916['rows']=_0x857cb8;return _0x37b916;});}})[_0x2cc8('0x18')](respondWithFilteredResult(_0x3857a2,_0x4939e2))[_0x2cc8('0x21')](handleError(_0x3857a2,null));};exports['getHopperHistories']=function(_0x287c33,_0x162255){var _0x1cda71={'raw':!![],'where':{}};var _0xe2b461={};var _0x450b7a={'count':0x0,'rows':[]};return db[_0x2cc8('0x23')]['findOne']({'where':{'id':_0x287c33['params']['id']}})[_0x2cc8('0x18')](handleEntityNotFound(_0x162255,null))[_0x2cc8('0x18')](function(_0x8bb467){if(_0x8bb467){_0xe2b461['model']=_[_0x2cc8('0x27')](db['CmHopperHistory']['rawAttributes']);_0xe2b461[_0x2cc8('0x20')]=_[_0x2cc8('0x27')](_0x287c33[_0x2cc8('0x20')]);_0xe2b461[_0x2cc8('0x77')]=_[_0x2cc8('0x78')](_0xe2b461[_0x2cc8('0x75')],_0xe2b461[_0x2cc8('0x20')]);_0x1cda71[_0x2cc8('0x79')]=_[_0x2cc8('0x78')](_0xe2b461[_0x2cc8('0x75')],qs['fields'](_0x287c33['query'][_0x2cc8('0x7a')]));_0x1cda71[_0x2cc8('0x79')]=_0x1cda71[_0x2cc8('0x79')][_0x2cc8('0x28')]?_0x1cda71['attributes']:_0xe2b461[_0x2cc8('0x75')];if(!_0x287c33[_0x2cc8('0x20')][_0x2cc8('0x34')](_0x2cc8('0x7e'))){_0x1cda71[_0x2cc8('0x13')]=qs[_0x2cc8('0x13')](_0x287c33[_0x2cc8('0x20')][_0x2cc8('0x13')]);_0x1cda71[_0x2cc8('0x11')]=qs[_0x2cc8('0x11')](_0x287c33[_0x2cc8('0x20')][_0x2cc8('0x11')]);}_0x1cda71[_0x2cc8('0x96')]=qs[_0x2cc8('0x97')](_0x287c33[_0x2cc8('0x20')][_0x2cc8('0x97')]);_0x1cda71[_0x2cc8('0x5b')]=qs[_0x2cc8('0x77')](_[_0x2cc8('0x7b')](_0x287c33['query'],_0xe2b461[_0x2cc8('0x77')]));_0x1cda71[_0x2cc8('0x5b')][_0x2cc8('0x9a')]=_0x8bb467['id'];if(_0x287c33[_0x2cc8('0x20')]['filter']){_0x1cda71[_0x2cc8('0x5b')]=_['merge'](_0x1cda71[_0x2cc8('0x5b')],{'$or':_[_0x2cc8('0x69')](_0x1cda71[_0x2cc8('0x79')],function(_0x25fa25){var _0x81d9f6={};_0x81d9f6[_0x25fa25]={'$like':'%'+_0x287c33[_0x2cc8('0x20')][_0x2cc8('0x7c')]+'%'};return _0x81d9f6;})});}_0x1cda71=_[_0x2cc8('0x35')]({},_0x1cda71,_0x287c33[_0x2cc8('0x7d')]);return db[_0x2cc8('0x4a')][_0x2cc8('0x14')]({'where':_0x1cda71[_0x2cc8('0x5b')]})[_0x2cc8('0x18')](function(_0x2fe548){_0x450b7a[_0x2cc8('0x14')]=_0x2fe548;if(_0x287c33[_0x2cc8('0x20')][_0x2cc8('0x98')]){_0x1cda71[_0x2cc8('0x99')]=[{'all':!![]}];}return db[_0x2cc8('0x4a')]['findAll'](_0x1cda71);})['then'](function(_0x6e45cd){_0x450b7a[_0x2cc8('0x9b')]=_0x6e45cd;return _0x450b7a;});}})['then'](respondWithFilteredResult(_0x162255,_0x1cda71))[_0x2cc8('0x21')](handleError(_0x162255,null));};exports[_0x2cc8('0x9c')]=function(_0x111182,_0x26c89d){var _0x885ed8={'raw':!![],'where':{}};var _0x112cbc={};var _0x18d6e0={'count':0x0,'rows':[]};return db['CmContact'][_0x2cc8('0x74')]({'where':{'id':_0x111182[_0x2cc8('0x25')]['id']}})[_0x2cc8('0x18')](handleEntityNotFound(_0x26c89d,null))['then'](function(_0x4cc1ed){if(_0x4cc1ed){_0x112cbc[_0x2cc8('0x75')]=_['keys'](db['CmHopperFinal'][_0x2cc8('0x95')]);_0x112cbc[_0x2cc8('0x20')]=_[_0x2cc8('0x27')](_0x111182[_0x2cc8('0x20')]);_0x112cbc['filters']=_[_0x2cc8('0x78')](_0x112cbc[_0x2cc8('0x75')],_0x112cbc[_0x2cc8('0x20')]);_0x885ed8[_0x2cc8('0x79')]=_['intersection'](_0x112cbc[_0x2cc8('0x75')],qs[_0x2cc8('0x7a')](_0x111182['query'][_0x2cc8('0x7a')]));_0x885ed8[_0x2cc8('0x79')]=_0x885ed8[_0x2cc8('0x79')][_0x2cc8('0x28')]?_0x885ed8[_0x2cc8('0x79')]:_0x112cbc[_0x2cc8('0x75')];if(!_0x111182['query'][_0x2cc8('0x34')]('nolimit')){_0x885ed8[_0x2cc8('0x13')]=qs['limit'](_0x111182[_0x2cc8('0x20')][_0x2cc8('0x13')]);_0x885ed8[_0x2cc8('0x11')]=qs[_0x2cc8('0x11')](_0x111182[_0x2cc8('0x20')]['offset']);}_0x885ed8[_0x2cc8('0x96')]=qs['sort'](_0x111182[_0x2cc8('0x20')]['sort']);_0x885ed8[_0x2cc8('0x5b')]=qs['filters'](_['pick'](_0x111182[_0x2cc8('0x20')],_0x112cbc[_0x2cc8('0x77')]));_0x885ed8[_0x2cc8('0x5b')]['ContactId']=_0x4cc1ed['id'];if(_0x111182['query'][_0x2cc8('0x7c')]){_0x885ed8[_0x2cc8('0x5b')]=_['merge'](_0x885ed8[_0x2cc8('0x5b')],{'$or':_[_0x2cc8('0x69')](_0x885ed8[_0x2cc8('0x79')],function(_0x2c0782){var _0x19c977={};_0x19c977[_0x2c0782]={'$like':'%'+_0x111182[_0x2cc8('0x20')]['filter']+'%'};return _0x19c977;})});}_0x885ed8=_[_0x2cc8('0x35')]({},_0x885ed8,_0x111182[_0x2cc8('0x7d')]);return db['CmHopperFinal'][_0x2cc8('0x14')]({'where':_0x885ed8['where']})[_0x2cc8('0x18')](function(_0x3eaf91){_0x18d6e0[_0x2cc8('0x14')]=_0x3eaf91;if(_0x111182[_0x2cc8('0x20')]['includeAll']){_0x885ed8[_0x2cc8('0x99')]=[{'all':!![]}];}return db[_0x2cc8('0x49')][_0x2cc8('0x1f')](_0x885ed8);})[_0x2cc8('0x18')](function(_0x17e9fb){_0x18d6e0[_0x2cc8('0x9b')]=_0x17e9fb;return _0x18d6e0;});}})['then'](respondWithFilteredResult(_0x26c89d,_0x885ed8))[_0x2cc8('0x21')](handleError(_0x26c89d,null));};exports['getJscriptySessions']=function(_0x37bf53,_0x7f7453){var _0x3dbb9e={'raw':!![],'where':{}};var _0x2a5b38={};var _0x1401fc={'count':0x0,'rows':[]};return db[_0x2cc8('0x23')]['findOne']({'where':{'id':_0x37bf53[_0x2cc8('0x25')]['id']}})[_0x2cc8('0x18')](handleEntityNotFound(_0x7f7453,null))[_0x2cc8('0x18')](function(_0x49f286){if(_0x49f286){_0x2a5b38[_0x2cc8('0x75')]=_[_0x2cc8('0x27')](db['JscriptySessionReport'][_0x2cc8('0x95')]);_0x2a5b38['query']=_['keys'](_0x37bf53[_0x2cc8('0x20')]);_0x2a5b38[_0x2cc8('0x77')]=_['intersection'](_0x2a5b38[_0x2cc8('0x75')],_0x2a5b38[_0x2cc8('0x20')]);_0x3dbb9e['attributes']=_[_0x2cc8('0x78')](_0x2a5b38['model'],qs['fields'](_0x37bf53['query'][_0x2cc8('0x7a')]));_0x3dbb9e['attributes']=_0x3dbb9e[_0x2cc8('0x79')]['length']?_0x3dbb9e[_0x2cc8('0x79')]:_0x2a5b38[_0x2cc8('0x75')];if(!_0x37bf53[_0x2cc8('0x20')][_0x2cc8('0x34')](_0x2cc8('0x7e'))){_0x3dbb9e[_0x2cc8('0x13')]=qs[_0x2cc8('0x13')](_0x37bf53['query'][_0x2cc8('0x13')]);_0x3dbb9e['offset']=qs[_0x2cc8('0x11')](_0x37bf53[_0x2cc8('0x20')]['offset']);}_0x3dbb9e[_0x2cc8('0x96')]=qs[_0x2cc8('0x97')](_0x37bf53['query'][_0x2cc8('0x97')]);_0x3dbb9e[_0x2cc8('0x5b')]=qs[_0x2cc8('0x77')](_['pick'](_0x37bf53['query'],_0x2a5b38['filters']));_0x3dbb9e[_0x2cc8('0x5b')]['ContactId']=_0x49f286['id'];if(_0x37bf53[_0x2cc8('0x20')][_0x2cc8('0x7c')]){_0x3dbb9e[_0x2cc8('0x5b')]=_[_0x2cc8('0x35')](_0x3dbb9e[_0x2cc8('0x5b')],{'$or':_[_0x2cc8('0x69')](_0x3dbb9e[_0x2cc8('0x79')],function(_0x1b1d49){var _0xfd9f45={};_0xfd9f45[_0x1b1d49]={'$like':'%'+_0x37bf53['query'][_0x2cc8('0x7c')]+'%'};return _0xfd9f45;})});}_0x3dbb9e=_['merge']({},_0x3dbb9e,_0x37bf53[_0x2cc8('0x7d')]);return db['JscriptySessionReport']['count']({'where':_0x3dbb9e[_0x2cc8('0x5b')]})['then'](function(_0x9fe8ad){_0x1401fc[_0x2cc8('0x14')]=_0x9fe8ad;if(_0x37bf53[_0x2cc8('0x20')][_0x2cc8('0x98')]){_0x3dbb9e[_0x2cc8('0x99')]=[{'all':!![]}];}return db[_0x2cc8('0x50')]['findAll'](_0x3dbb9e);})[_0x2cc8('0x18')](function(_0x486efd){_0x1401fc[_0x2cc8('0x9b')]=_0x486efd;return _0x1401fc;});}})['then'](respondWithFilteredResult(_0x7f7453,_0x3dbb9e))[_0x2cc8('0x21')](handleError(_0x7f7453,null));};exports[_0x2cc8('0x9d')]=function(_0x141f0a,_0x2ffe36){try{if(!_0x141f0a[_0x2cc8('0x36')][_0x2cc8('0x5d')]){throw new Error(_0x2cc8('0x9e'));}if(!_0x141f0a[_0x2cc8('0x36')][_0x2cc8('0x9f')]){throw new Error(_0x2cc8('0xa0'));}if(!_0x141f0a[_0x2cc8('0x36')][_0x2cc8('0xa1')]){throw new Error(_0x2cc8('0xa2'));}if(!_0x141f0a[_0x2cc8('0x36')][_0x2cc8('0xa3')]){throw new Error(_0x2cc8('0xa4'));}var _0xa32ae3=_0x141f0a[_0x2cc8('0x36')][_0x2cc8('0x9f')][_0x2cc8('0xa5')](',');var _0x4d266c=_0x141f0a[_0x2cc8('0x36')][_0x2cc8('0xa1')]['split'](',');if(!_0xa32ae3[_0x2cc8('0x28')]||!_0x4d266c[_0x2cc8('0x28')]||_0xa32ae3[_0x2cc8('0x28')]!==_0x4d266c['length']){throw new Error('Incorrect\x20binding\x20parameters\x20passed!');}_0x141f0a[_0x2cc8('0x36')]['fields']=_[_0x2cc8('0xa6')](_0xa32ae3,_0x4d266c);if(!_0x141f0a[_0x2cc8('0x36')][_0x2cc8('0x7a')][_0x2cc8('0x72')]){throw new Error(_0x2cc8('0xa7'));}if(!_0x141f0a[_0x2cc8('0x36')]['fields'][_0x2cc8('0xa8')]){throw new Error(_0x2cc8('0xa9'));}var _0x3bb2e3=path[_0x2cc8('0x3b')](config['root'],'server/files/tmp',_0x141f0a[_0x2cc8('0xaa')][_0x2cc8('0xab')]);fs['chmodSync'](_0x3bb2e3,parseInt('0777',0x8));var _0x2a0cbc=require(_0x2cc8('0xac'))[_0x2cc8('0xad')](path[_0x2cc8('0x3b')](__dirname,_0x2cc8('0xae')),[_0x3bb2e3,_0x141f0a[_0x2cc8('0x36')]['binding_keys'],_0x141f0a[_0x2cc8('0x36')][_0x2cc8('0xa1')],_0x141f0a[_0x2cc8('0x36')]['ListId'],_0x141f0a[_0x2cc8('0x36')][_0x2cc8('0xaf')],_0x141f0a[_0x2cc8('0x36')]['duplicates'],_0x141f0a[_0x2cc8('0x36')][_0x2cc8('0xa3')]]);return _0x2ffe36[_0x2cc8('0x15')](0xc8)[_0x2cc8('0x10')]({'message':'File\x20uploaded\x20correctly!','pid':_0x2a0cbc[_0x2cc8('0xb0')]});}catch(_0x487967){return _0x2ffe36[_0x2cc8('0x15')](0x1f4)[_0x2cc8('0xb1')](_0x487967);}};exports[_0x2cc8('0xb2')]=function(_0xf87b60,_0x5c2d40){var _0x39b821=fs[_0x2cc8('0xb3')](_0xf87b60[_0x2cc8('0xaa')][_0x2cc8('0x1')]);Papa[_0x2cc8('0xb4')](_0x39b821,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x448f36){return _0x5c2d40[_0x2cc8('0x15')](0xc8)[_0x2cc8('0x10')]({'file':_0xf87b60[_0x2cc8('0xaa')],'fields':_0x448f36[_0x2cc8('0xb5')]['fields']});}});};exports['import']=function(_0x25d5b6,_0x134070){return db[_0x2cc8('0xb6')][_0x2cc8('0x1f')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})['then'](function(_0x392cc5){var _0x599a87=![];if(!_0x25d5b6[_0x2cc8('0x36')]['ListId']){throw new Error(_0x2cc8('0x9e'));}if(!_0x25d5b6['body'][_0x2cc8('0xb7')][_0x2cc8('0x72')]){throw new Error(_0x2cc8('0xa7'));}if(!_0x25d5b6[_0x2cc8('0x36')]['binding'][_0x2cc8('0xa8')]){throw new Error(_0x2cc8('0xa9'));}if(!_0x25d5b6[_0x2cc8('0x36')][_0x2cc8('0xa3')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x3ea689=require(_0x2cc8('0xac'))['fork'](path[_0x2cc8('0x3b')](__dirname,'../../components/import/cm/csv2'),[_0x25d5b6[_0x2cc8('0x25')]['id'],JSON[_0x2cc8('0xb8')](_0x25d5b6['body']),JSON[_0x2cc8('0xb8')](_0x392cc5)]);_0x3ea689['on']('message',function(){_0x599a87=!![];return _0x134070['status'](0xc8)[_0x2cc8('0x10')]({'message':_0x2cc8('0xb9'),'pid':_0x3ea689[_0x2cc8('0xb0')]});});_0x3ea689['on'](_0x2cc8('0xba'),function(_0x8c958f){if(_0x8c958f&&!_0x599a87){return _0x134070[_0x2cc8('0x15')](0x1f4)[_0x2cc8('0x10')]({'message':'error\x20child\x20process','pid':_0x3ea689['pid']});}});})[_0x2cc8('0x21')](handleError(_0x134070,null));};exports[_0x2cc8('0xbb')]=function(_0x2ed21c,_0x13ee1e){return db[_0x2cc8('0xb6')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0x2cc8('0x18')](function(_0x26f70c){var _0x2abd64=![];if(!_0x2ed21c[_0x2cc8('0x36')]['ListId']){throw new Error(_0x2cc8('0x9e'));}if(!_0x2ed21c[_0x2cc8('0x36')][_0x2cc8('0xb7')][_0x2cc8('0x72')]){throw new Error(_0x2cc8('0xa7'));}if(!_0x2ed21c['body']['binding'][_0x2cc8('0xa8')]){throw new Error(_0x2cc8('0xa9'));}if(!_0x2ed21c[_0x2cc8('0x36')]['socket_timestamp']){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x4060f1=require(_0x2cc8('0xac'))[_0x2cc8('0xad')](path[_0x2cc8('0x3b')](__dirname,_0x2cc8('0xbc')),[_0x2ed21c[_0x2cc8('0x25')]['id'],JSON['stringify'](_0x2ed21c[_0x2cc8('0x36')]),JSON['stringify'](_0x26f70c)]);_0x4060f1['on'](_0x2cc8('0xbd'),function(){_0x2abd64=!![];return _0x13ee1e[_0x2cc8('0x15')](0xc8)['json']({'message':_0x2cc8('0xb9'),'pid':_0x4060f1['pid']});});_0x4060f1['on'](_0x2cc8('0xba'),function(_0x10b7b0){if(_0x10b7b0&&!_0x2abd64){return _0x13ee1e[_0x2cc8('0x15')](0x1f4)[_0x2cc8('0x10')]({'message':_0x2cc8('0xbe'),'pid':_0x4060f1[_0x2cc8('0xb0')]});}});})['catch'](handleError(_0x13ee1e,null));};exports[_0x2cc8('0xbf')]=function(_0x1fc813,_0x206aec){var _0x19ce87=['mail',_0x2cc8('0xc0'),_0x2cc8('0xc1'),_0x2cc8('0xc2'),_0x2cc8('0xc3'),_0x2cc8('0xc4'),_0x2cc8('0xc5')];var _0x5a7344={'offset':0x0,'order':qs['sort']('-createdAt')},_0x21ec2c={'count':0x0,'rows':[]};Promise['resolve']()['then'](function(){if(_0x1fc813['query'][_0x2cc8('0xc6')]){if(!_[_0x2cc8('0xc7')](_0x19ce87,_0x1fc813['query'][_0x2cc8('0xc6')][_0x2cc8('0xc8')]())){throw new Error(_0x2cc8('0xc9'));}_0x19ce87=[_0x1fc813['query'][_0x2cc8('0xc6')][_0x2cc8('0xc8')]()];}if(_0x1fc813['query']['range']){try{var _0x5a3ee0=JSON[_0x2cc8('0xb4')](_0x1fc813['query'][_0x2cc8('0xca')]);if(!moment(_0x5a3ee0['from'])['isValid']()){throw new Error(_0x2cc8('0xcb'));}if(!moment(_0x5a3ee0['to'])['isValid']()){throw new Error('Invalid\x20date\x20for\x20range\x20to\x20filter');}}catch(_0x4ae321){throw new Error(_0x2cc8('0xcc'));}}if(!_0x1fc813['query']['hasOwnProperty'](_0x2cc8('0x7e'))){_0x5a7344[_0x2cc8('0x13')]=qs[_0x2cc8('0x13')](_0x1fc813['query']['limit']||0xa);_0x5a7344[_0x2cc8('0x11')]=qs['offset'](_0x1fc813[_0x2cc8('0x20')][_0x2cc8('0x11')]);}var _0x50efc8=_0x19ce87[_0x2cc8('0x69')](function(_0x5637bb){if(_0x5637bb===_0x2cc8('0xc5')){var _0x28d7c0={'attributes':['id','uniqueid','type',_0x2cc8('0xcd'),_0x2cc8('0xce'),_0x2cc8('0xcf'),_0x2cc8('0xd0'),_0x2cc8('0xd1'),'duration',_0x2cc8('0xd2'),'createdAt',_0x2cc8('0xd3'),'userSecondDisposition',_0x2cc8('0xd4'),_0x2cc8('0xd5')],'where':{'ContactId':_0x1fc813[_0x2cc8('0x25')]['id']},'include':[{'model':db[_0x2cc8('0xb6')],'as':_0x2cc8('0xb6'),'attributes':['id','name',_0x2cc8('0xd6'),_0x2cc8('0x2e')]}],'order':[['createdAt','DESC']]};if(_0x1fc813[_0x2cc8('0x20')]['range']){_0x28d7c0['where']['createdAt']={'$gte':_0x5a3ee0[_0x2cc8('0x37')],'$lte':_0x5a3ee0['to']};}return db['VoiceCallReport'][_0x2cc8('0xd7')](_0x28d7c0)['then'](function(_0x278d5f){_0x21ec2c['count']+=_0x278d5f[_0x2cc8('0x14')];return _[_0x2cc8('0x69')](_0x278d5f[_0x2cc8('0x9b')],function(_0x5b2014){var _0x47e305=_0x5b2014[_0x2cc8('0x38')]({'plain':!![]});_0x47e305[_0x2cc8('0xc6')]=_0x5637bb;if(_0x47e305['User']){_0x47e305[_0x2cc8('0xb6')]={'id':_0x47e305[_0x2cc8('0xb6')]['id'],'name':_0x47e305[_0x2cc8('0xb6')][_0x2cc8('0x1c')],'fullname':_0x47e305['User'][_0x2cc8('0xd6')],'alias':_0x47e305[_0x2cc8('0xb6')][_0x2cc8('0x2e')]};}return _0x47e305;});});}else{var _0x4087c2=_[_0x2cc8('0xd8')](_0x5637bb)+(_0x5637bb===_0x2cc8('0xc0')?'Website':_0x2cc8('0xd9'));var _0x5f994b={'attributes':['id','closed','closedAt',_0x2cc8('0xda'),_0x2cc8('0xd2'),'disposition','secondDisposition','thirdDisposition',_0x2cc8('0xd5'),_0x4087c2+'Id'],'where':{'ContactId':_0x1fc813[_0x2cc8('0x25')]['id']},'include':[{'model':db[_0x4087c2],'as':'Account','attributes':['id','name',_0x2cc8('0xdb')]},{'model':db[_0x2cc8('0xb6')],'as':_0x2cc8('0xdc'),'attributes':['id',_0x2cc8('0x1c'),_0x2cc8('0xd6')]},{'model':db[_0x2cc8('0x76')],'as':'Tags','attributes':['id',_0x2cc8('0x1c'),'color'],'through':{'attributes':[]}}],'order':[['createdAt',_0x2cc8('0xdd')]]};if(_0x1fc813['query'][_0x2cc8('0xca')]){_0x5f994b['where'][_0x2cc8('0xda')]={'$gte':_0x5a3ee0[_0x2cc8('0x37')],'$lte':_0x5a3ee0['to']};}switch(_0x5637bb){case _0x2cc8('0xc0'):_0x5f994b['attributes'][_0x2cc8('0x5c')](_0x2cc8('0xde'),_0x2cc8('0xdf'),'customerPort',_0x2cc8('0xe0'),_0x2cc8('0xe1'),_0x2cc8('0xe2'),_0x2cc8('0xe3'),_0x2cc8('0xe4'),_0x2cc8('0xe5'));break;case _0x2cc8('0xe6'):_0x5f994b[_0x2cc8('0x79')][_0x2cc8('0x5c')]('subject',_0x2cc8('0xe7'));break;case _0x2cc8('0xc2'):_0x5f994b[_0x2cc8('0x79')][_0x2cc8('0x5c')](_0x2cc8('0xe8'),_0x2cc8('0xe9'));break;}return db[_['startCase'](_0x5637bb)+_0x2cc8('0xea')][_0x2cc8('0xd7')](_0x5f994b)[_0x2cc8('0x18')](function(_0x29669f){_0x21ec2c[_0x2cc8('0x14')]+=_0x29669f[_0x2cc8('0x14')];return _[_0x2cc8('0x69')](_0x29669f[_0x2cc8('0x9b')],function(_0x188475){var _0x571603=_0x188475[_0x2cc8('0x38')]({'plain':!![]});_0x571603[_0x2cc8('0xc6')]=_0x5637bb;if(_0x571603[_0x2cc8('0xdc')]){_0x571603['Owner']={'id':_0x571603['Owner']['id'],'name':_0x571603['Owner'][_0x2cc8('0x1c')],'fullname':_0x571603['Owner'][_0x2cc8('0xd6')]};}return _0x571603;});});}});return Promise[_0x2cc8('0x60')](_0x50efc8);})['then'](function(_0x3324ac){return _(_0x3324ac)['flatten']()['sortBy'](_0x2cc8('0xda'))['reverse']()[_0x2cc8('0xeb')]();})['then'](function(_0x2df0c3){_0x21ec2c[_0x2cc8('0x9b')]=_0x5a7344[_0x2cc8('0x13')]?_0x2df0c3[_0x2cc8('0xec')](_0x5a7344[_0x2cc8('0x11')],_0x5a7344['offset']+_0x5a7344[_0x2cc8('0x13')]):_0x2df0c3;return _0x21ec2c;})['then'](respondWithFilteredResult(_0x206aec,_0x5a7344))[_0x2cc8('0x21')](handleError(_0x206aec,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff