// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xc7b4=['duplicates','where','$or','ListId','findOrCreate','spread','push','contact','all','show','find','Tags','color','Phones','ContactItemType','ItemType','sequelize','literal','$and','map','format','cf_%d','omit','startsWith','isEmpty','table','cm_contacts','setFields','id\x20=\x20?','toParam','text','phone','findOne','model','Tag','rawAttributes','attributes','intersection','fields','order','sort','pick','filter','merge','options','getTags','setTags','ids','setAdditionalPhones','OrderBy','item_types','items','ItemTypeId','description','contact\x20phone\x20exists','PHONE','CmHopper','item','`ItemType`.OrderBy','CmHopperId','bulkCreate','getAdditionalPhones','duplicateAdditionalPhones','fromContactId','CmContactId','toContactId','rescheduleAdditionalPhones','hopperId','getHoppers','filters','nolimit','ContactId','includeAll','rows','getHopperHistories','CmHopperHistory','include','CmHopperFinal','getJscriptySessions','uploadCsv','binding_keys','No\x20association\x20keys\x20specified!','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','Incorrect\x20binding\x20parameters\x20passed!','firstName','No\x20firstName\x20column\x20specified','root','server/files/tmp','file','filename','chmodSync','child_process','fork','../../components/import/cm/csv','binding_values','CompanyId','socket_timestamp','File\x20uploaded\x20correctly!','pid','send','parse','meta','import','No\x20ListId\x20specified','binding','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','exit','error\x20child\x20process','importUpdates','agent','No\x20phone\x20column\x20specified','../../components/import/cm/csvUpdates','getJourney','chat','sms','openchannel','whatsapp','voice','-createdAt','resolve','channel','includes','toLowerCase','range','isValid','Invalid\x20date\x20for\x20range\x20from\x20filter','Invalid\x20date\x20for\x20range\x20to\x20filter','Invalid\x20createdAt\x20filter','uniqueid','source','destination','endtime','duration','note','createdAt','userThirdDisposition','User','fullname','DESC','startCase','Website','Account','closed','closedAt','disposition','thirdDisposition','UserId','key','Owner','browserName','customerPort','deviceModel','ratingMessage','ratingValue','referer','mail','subject','substatus','externalUrl','Interaction','findAndCountAll','sortBy','value','slice','moment','util','path','lodash','squel','papaparse','ioredis','../../components/parsers/qs','../../config/logger','api','../../config/environment/shared','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./cmContact.socket','register','status','json','offset','limit','undefined','count','set','Content-Range','update','then','destroy','error','stack','name','index','getOptions','findAll','user','CmContact','params','catch','describe','tags','keys','length','cf_','displayName','query','analytics','CmCustomField','alias','type','values','info','Custom\x20field\x20%s\x20not\x20found\x20on\x20cm_contacts\x20table','forEach','hasOwnProperty','columnName','body','get','mergeWith','isArray','join','from','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','FaxInteraction','FaxMessage','OpenchannelMessage','CmContactHasItem','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappMessage','isNil','dialTimezone','utcOffset','timezones','additionalPhones','each'];(function(_0x3dd15e,_0x1f0015){var _0x231fd0=function(_0x4f680a){while(--_0x4f680a){_0x3dd15e['push'](_0x3dd15e['shift']());}};_0x231fd0(++_0x1f0015);}(_0xc7b4,0xa7));var _0x4c7b=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0xc7b4[_0x3dd15e];return _0x231fd0;};'use strict';var moment=require(_0x4c7b('0x0'));var BPromise=require('bluebird');var util=require(_0x4c7b('0x1'));var path=require(_0x4c7b('0x2'));var fs=require('fs');var _=require(_0x4c7b('0x3'));var squel=require(_0x4c7b('0x4'));var Papa=require(_0x4c7b('0x5'));var Redis=require(_0x4c7b('0x6'));var contacts=require('../../components/contacts');var qs=require(_0x4c7b('0x7'));var logger=require(_0x4c7b('0x8'))(_0x4c7b('0x9'));var config=require('../../config/environment');var shared=require(_0x4c7b('0xa'));var db=require(_0x4c7b('0xb'))['db'];config[_0x4c7b('0xc')]=_[_0x4c7b('0xd')](config[_0x4c7b('0xc')],{'host':_0x4c7b('0xe'),'port':0x18eb});var socket=require(_0x4c7b('0xf'))(new Redis(config[_0x4c7b('0xc')]));require(_0x4c7b('0x10'))[_0x4c7b('0x11')](socket);function respondWithResult(_0x205888,_0x2abd2b){_0x2abd2b=_0x2abd2b||0xc8;return function(_0x2cfed5){if(_0x2cfed5){return _0x205888[_0x4c7b('0x12')](_0x2abd2b)[_0x4c7b('0x13')](_0x2cfed5);}};}function respondWithFilteredResult(_0x1d54e7,_0x46ede7){return function(_0x1667d7){if(_0x1667d7){var _0x44ae37=typeof _0x46ede7[_0x4c7b('0x14')]==='undefined'&&typeof _0x46ede7[_0x4c7b('0x15')]===_0x4c7b('0x16');var _0xe3e91c=_0x1667d7[_0x4c7b('0x17')];var _0x259831=_0x44ae37?0x0:_0x46ede7[_0x4c7b('0x14')];var _0x59cff2=_0x44ae37?_0x1667d7[_0x4c7b('0x17')]:_0x46ede7[_0x4c7b('0x14')]+_0x46ede7['limit'];var _0x2dd2f2;if(_0x59cff2>=_0xe3e91c){_0x59cff2=_0xe3e91c;_0x2dd2f2=0xc8;}else{_0x2dd2f2=0xce;}_0x1d54e7['status'](_0x2dd2f2);return _0x1d54e7[_0x4c7b('0x18')](_0x4c7b('0x19'),_0x259831+'-'+_0x59cff2+'/'+_0xe3e91c)[_0x4c7b('0x13')](_0x1667d7);}return null;};}function saveUpdates(_0x215b2c){return function(_0x48ab53){if(_0x48ab53){return _0x48ab53[_0x4c7b('0x1a')](_0x215b2c)[_0x4c7b('0x1b')](function(_0x30c5e1){return _0x30c5e1;});}return null;};}function removeEntity(_0x217faa){return function(_0x551dc7){if(_0x551dc7){return _0x551dc7[_0x4c7b('0x1c')]()['then'](function(){_0x217faa[_0x4c7b('0x12')](0xcc)['end']();});}};}function handleEntityNotFound(_0x27286e){return function(_0x49be55){if(!_0x49be55){_0x27286e['sendStatus'](0x194);}return _0x49be55;};}function handleError(_0x5609b7,_0x563d08){_0x563d08=_0x563d08||0x1f4;return function(_0x1dac80){logger[_0x4c7b('0x1d')](_0x1dac80[_0x4c7b('0x1e')]);if(_0x1dac80[_0x4c7b('0x1f')]){delete _0x1dac80[_0x4c7b('0x1f')];}_0x5609b7[_0x4c7b('0x12')](_0x563d08)['send'](_0x1dac80);};}exports[_0x4c7b('0x20')]=function(_0x256b9f,_0x4d6fc6){var _0x52f433={};return contacts['describe']()[_0x4c7b('0x1b')](function(_0x18322e){_0x52f433=qs[_0x4c7b('0x21')](_0x18322e,_0x256b9f);return contacts[_0x4c7b('0x22')](_0x256b9f['query'],_0x256b9f[_0x4c7b('0x23')],_0x52f433,_0x18322e);})['then'](respondWithFilteredResult(_0x4d6fc6,_0x52f433))['catch'](handleError(_0x4d6fc6,null));};exports[_0x4c7b('0x1c')]=function(_0x4f73be,_0x3e909f){return db[_0x4c7b('0x24')]['find']({'where':{'id':_0x4f73be[_0x4c7b('0x25')]['id']}})[_0x4c7b('0x1b')](handleEntityNotFound(_0x3e909f,null))['then'](removeEntity(_0x3e909f,null))[_0x4c7b('0x26')](handleError(_0x3e909f,null));};exports[_0x4c7b('0x27')]=function(_0x9964b9,_0xec8728){return db[_0x4c7b('0x24')][_0x4c7b('0x27')]()[_0x4c7b('0x1b')](function(_0x1dfbd8){delete _0x1dfbd8[_0x4c7b('0x28')];for(var _0x183d6f=0x0;_0x183d6f<Object[_0x4c7b('0x29')](_0x1dfbd8)[_0x4c7b('0x2a')];_0x183d6f++){var _0x138a22=Object[_0x4c7b('0x29')](_0x1dfbd8)[_0x183d6f];if(!_['startsWith'](_0x138a22,_0x4c7b('0x2b'))){_0x1dfbd8[_0x138a22]['columnName']=_0x138a22;_0x1dfbd8[_0x138a22][_0x4c7b('0x2c')]=_0x138a22;}}return _0x1dfbd8;})[_0x4c7b('0x1b')](function(_0x7a9f17){var _0x1d5022={'where':Boolean(_0x9964b9[_0x4c7b('0x2d')][_0x4c7b('0x2e')])===!![]?undefined:{'$or':[{'ListId':_0x9964b9[_0x4c7b('0x2d')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x4c7b('0x2f')][_0x4c7b('0x22')](_0x1d5022)['then'](function(_0x363ea1){for(var _0x3b641f=0x0;_0x3b641f<_0x363ea1[_0x4c7b('0x2a')];_0x3b641f++){var _0x4599db=_0x4c7b('0x2b')+_0x363ea1[_0x3b641f]['id'];if(_0x7a9f17[_0x4599db]){_0x7a9f17[_0x4599db]['columnName']=_0x4599db;_0x7a9f17[_0x4599db][_0x4c7b('0x2c')]=_0x363ea1[_0x3b641f][_0x4c7b('0x30')];_0x7a9f17[_0x4599db]['custom']={'type':_0x363ea1[_0x3b641f][_0x4c7b('0x31')],'values':_0x363ea1[_0x3b641f][_0x4c7b('0x32')]};}else{logger[_0x4c7b('0x33')](_0x4c7b('0x34'),_0x4599db);}}Object['keys'](_0x7a9f17)[_0x4c7b('0x35')](function(_0x29e404){if(!_0x7a9f17[_0x29e404][_0x4c7b('0x36')](_0x4c7b('0x37'))){delete _0x7a9f17[_0x29e404];}});return _0x7a9f17;});})[_0x4c7b('0x1b')](respondWithResult(_0xec8728,null))['catch'](handleError(_0xec8728,null));};exports['merge']=function(_0x4b1453,_0x4eb02d){var _0x1f9544;var _0x2917bc;var _0x45556c;if(_0x4b1453[_0x4c7b('0x38')]['id']){delete _0x4b1453[_0x4c7b('0x38')]['id'];}return db[_0x4c7b('0x24')]['findAll']({'where':{'id':[_0x4b1453[_0x4c7b('0x38')]['to'],_0x4b1453[_0x4c7b('0x38')]['from']]}})[_0x4c7b('0x1b')](function(_0x28abaf){if(_0x28abaf){if(_0x28abaf['length']!==0x2){return null;}_0x28abaf[0x0]=_0x28abaf[0x0][_0x4c7b('0x39')]({'plain':!![]});_0x28abaf[0x1]=_0x28abaf[0x1][_0x4c7b('0x39')]({'plain':!![]});delete _0x28abaf[0x0]['id'];delete _0x28abaf[0x1]['id'];return _[_0x4c7b('0x3a')](_0x28abaf[0x0],_0x28abaf[0x1],function(_0x156e09,_0x2b6401){if(Array[_0x4c7b('0x3b')](_0x2b6401)&&!_0x2b6401['length']){return _0x156e09;}else if(!_0x2b6401){return _0x156e09;}});}})[_0x4c7b('0x1b')](handleEntityNotFound(_0x4eb02d,null))[_0x4c7b('0x1b')](function(_0x2de667){if(_0x2de667){if(_0x2de667[_0x4c7b('0x28')]&&_[_0x4c7b('0x3b')](_0x2de667['tags'])){_0x2de667['tags']=_0x2de667['tags'][_0x4c7b('0x3c')]();}logger[_0x4c7b('0x33')]('[CmContact][merge]\x20to\x20%s\x20from\x20%s',_0x4b1453[_0x4c7b('0x38')]['to'],_0x4b1453[_0x4c7b('0x38')][_0x4c7b('0x3d')]);return db['CmHopper'][_0x4c7b('0x1c')]({'where':{'ContactId':[_0x4b1453[_0x4c7b('0x38')]['to'],_0x4b1453[_0x4c7b('0x38')][_0x4c7b('0x3d')]]}})['then'](function(_0x3e6809){logger[_0x4c7b('0x33')](_0x4c7b('0x3e'),_0x3e6809);return db[_0x4c7b('0x3f')][_0x4c7b('0x1c')]({'where':{'ContactId':[_0x4b1453['body']['to'],_0x4b1453[_0x4c7b('0x38')][_0x4c7b('0x3d')]]}})[_0x4c7b('0x1b')](function(_0x191fda){logger[_0x4c7b('0x33')](_0x4c7b('0x40'),_0x191fda);return db[_0x4c7b('0x24')][_0x4c7b('0x41')](_0x2de667);});});}})[_0x4c7b('0x1b')](function(_0x39e6a3){if(_0x39e6a3){_0x1f9544=_0x39e6a3;_0x2917bc={'ContactId':_0x1f9544['id']};_0x45556c={'where':{'ContactId':[_0x4b1453[_0x4c7b('0x38')]['to'],_0x4b1453[_0x4c7b('0x38')]['from']]}};return db[_0x4c7b('0x42')]['update'](_0x2917bc,_0x45556c);}})['then'](function(){if(_0x1f9544){return db[_0x4c7b('0x43')][_0x4c7b('0x1a')](_0x2917bc,_0x45556c);}})[_0x4c7b('0x1b')](function(){if(_0x1f9544){return db[_0x4c7b('0x44')][_0x4c7b('0x1a')](_0x2917bc,_0x45556c);}})[_0x4c7b('0x1b')](function(){if(_0x1f9544){return db[_0x4c7b('0x45')][_0x4c7b('0x1a')](_0x2917bc,_0x45556c);}})['then'](function(){if(_0x1f9544){return db[_0x4c7b('0x46')]['update'](_0x2917bc,_0x45556c);}})[_0x4c7b('0x1b')](function(){if(_0x1f9544){return db[_0x4c7b('0x45')][_0x4c7b('0x1a')](_0x2917bc,_0x45556c);}})[_0x4c7b('0x1b')](function(){if(_0x1f9544){return db[_0x4c7b('0x46')][_0x4c7b('0x1a')](_0x2917bc,_0x45556c);}})['then'](function(){if(_0x1f9544){return db[_0x4c7b('0x47')][_0x4c7b('0x1a')](_0x2917bc,_0x45556c);}})['then'](function(){if(_0x1f9544){return db['SmsMessage'][_0x4c7b('0x1a')](_0x2917bc,_0x45556c);}})['then'](function(){if(_0x1f9544){return db[_0x4c7b('0x48')][_0x4c7b('0x1a')](_0x2917bc,_0x45556c);}})['then'](function(){if(_0x1f9544){return db[_0x4c7b('0x49')][_0x4c7b('0x1a')](_0x2917bc,_0x45556c);}})[_0x4c7b('0x1b')](function(){if(_0x1f9544){return db['OpenchannelInteraction'][_0x4c7b('0x1a')](_0x2917bc,_0x45556c);}})[_0x4c7b('0x1b')](function(){if(_0x1f9544){return db[_0x4c7b('0x4a')][_0x4c7b('0x1a')](_0x2917bc,_0x45556c);}})[_0x4c7b('0x1b')](function(){if(_0x1f9544){return db[_0x4c7b('0x4b')][_0x4c7b('0x1a')]({'CmContactId':_0x1f9544['id']},{'where':{'CmContactId':[_0x4b1453[_0x4c7b('0x38')]['to'],_0x4b1453[_0x4c7b('0x38')][_0x4c7b('0x3d')]]}});}})[_0x4c7b('0x1b')](function(){if(_0x1f9544){return db['CmHopperFinal'][_0x4c7b('0x1a')](_0x2917bc,_0x45556c);}})[_0x4c7b('0x1b')](function(){if(_0x1f9544){return db['CmHopperHistory'][_0x4c7b('0x1a')](_0x2917bc,_0x45556c);}})[_0x4c7b('0x1b')](function(){if(_0x1f9544){return db[_0x4c7b('0x4c')]['update'](_0x2917bc,_0x45556c);}})['then'](function(){if(_0x1f9544){return db[_0x4c7b('0x4d')]['update'](_0x2917bc,_0x45556c);}})[_0x4c7b('0x1b')](function(){if(_0x1f9544){return db[_0x4c7b('0x4e')]['update'](_0x2917bc,_0x45556c);}})[_0x4c7b('0x1b')](function(){if(_0x1f9544){return db[_0x4c7b('0x4f')][_0x4c7b('0x1a')](_0x2917bc,_0x45556c);}})[_0x4c7b('0x1b')](function(){if(_0x1f9544){return db[_0x4c7b('0x50')][_0x4c7b('0x1a')](_0x2917bc,_0x45556c);}})[_0x4c7b('0x1b')](function(){if(_0x1f9544){return db[_0x4c7b('0x51')][_0x4c7b('0x1a')](_0x2917bc,_0x45556c);}})[_0x4c7b('0x1b')](function(){if(_0x1f9544){return db[_0x4c7b('0x52')][_0x4c7b('0x1a')](_0x2917bc,_0x45556c);}})[_0x4c7b('0x1b')](function(){if(_0x1f9544){return db[_0x4c7b('0x53')][_0x4c7b('0x1a')](_0x2917bc,_0x45556c);}})[_0x4c7b('0x1b')](function(){if(_0x1f9544){return db[_0x4c7b('0x54')]['update'](_0x2917bc,_0x45556c);}})[_0x4c7b('0x1b')](function(){if(_0x1f9544){return db[_0x4c7b('0x55')]['update'](_0x2917bc,_0x45556c);}})[_0x4c7b('0x1b')](function(){if(_0x1f9544){return db['WhatsappQueueReport'][_0x4c7b('0x1a')](_0x2917bc,_0x45556c);}})['then'](function(){if(_0x1f9544){return db['CmContact'][_0x4c7b('0x1c')]({'where':{'id':[_0x4b1453[_0x4c7b('0x38')]['to'],_0x4b1453[_0x4c7b('0x38')][_0x4c7b('0x3d')]]}});}})['then'](function(){if(_0x1f9544){return _0x1f9544;}})[_0x4c7b('0x1b')](respondWithResult(_0x4eb02d,null))[_0x4c7b('0x26')](handleError(_0x4eb02d,null));};exports[_0x4c7b('0x41')]=function(_0x21d133,_0x52563a){return db[_0x4c7b('0x24')][_0x4c7b('0x27')]()[_0x4c7b('0x1b')](function(_0x34a4f1){if(_0x21d133[_0x4c7b('0x38')][_0x4c7b('0x28')]&&_[_0x4c7b('0x3b')](_0x21d133[_0x4c7b('0x38')]['tags'])){if(_0x21d133['body'][_0x4c7b('0x28')][_0x4c7b('0x2a')]){_0x21d133[_0x4c7b('0x38')][_0x4c7b('0x28')]=_0x21d133[_0x4c7b('0x38')][_0x4c7b('0x28')]['join'](';')+';';}else{_0x21d133[_0x4c7b('0x38')][_0x4c7b('0x28')]=null;}}else{_0x21d133[_0x4c7b('0x38')][_0x4c7b('0x28')]=null;}if(!_[_0x4c7b('0x56')](_0x21d133[_0x4c7b('0x38')][_0x4c7b('0x57')])){var _0x2a7c44=_0x21d133[_0x4c7b('0x38')][_0x4c7b('0x57')];if(!_[_0x4c7b('0x56')](shared['timezones'][_0x2a7c44]))_0x21d133[_0x4c7b('0x38')][_0x4c7b('0x58')]=shared[_0x4c7b('0x59')][_0x2a7c44][_0x4c7b('0x58')];}return db[_0x4c7b('0x24')][_0x4c7b('0x41')](_0x21d133[_0x4c7b('0x38')],{'fields':_[_0x4c7b('0x29')](_0x34a4f1),'raw':!![]});})[_0x4c7b('0x1b')](function(_0x3018ee){if(_0x21d133[_0x4c7b('0x38')][_0x4c7b('0x5a')]){return insertAdditionalPhones(_0x3018ee,_0x21d133['body'][_0x4c7b('0x5a')]);}else{return _0x3018ee;}})['then'](respondWithResult(_0x52563a,0xc9))[_0x4c7b('0x26')](handleError(_0x52563a,null));};exports['bulkCreate']=function(_0x3fe7cb,_0x5df7b4){var _0x5b62fc=0x0;var _0xe3af5b=0x0;var _0x46c84a=0x0;var _0x1f599d=[];return db[_0x4c7b('0x24')][_0x4c7b('0x27')]()[_0x4c7b('0x1b')](function(_0x2ddfe4){return BPromise[_0x4c7b('0x5b')](_0x3fe7cb['body'],function(_0x246bac){var _0x1fa74c={'where':{'$or':[]},'defaults':_0x246bac,'fields':_[_0x4c7b('0x29')](_0x2ddfe4),'raw':!![]};if(_0x246bac[_0x4c7b('0x5c')]){for(var _0x512f15=0x0;_0x512f15<_0x246bac[_0x4c7b('0x5c')][_0x4c7b('0x2a')];_0x512f15++){var _0x16b0ed={};_0x16b0ed[_0x246bac[_0x4c7b('0x5c')][_0x512f15]]=_0x246bac[_0x246bac[_0x4c7b('0x5c')][_0x512f15]];_0x1fa74c[_0x4c7b('0x5d')][_0x4c7b('0x5e')]['push'](_0x16b0ed);}_0x1fa74c['where'][_0x4c7b('0x5f')]=_0x246bac[_0x4c7b('0x5f')];}return db[_0x4c7b('0x24')][_0x4c7b('0x60')](_0x1fa74c)[_0x4c7b('0x61')](function(_0x1985e6,_0x2fa104){if(_0x2fa104){if(_0x246bac[_0x4c7b('0x36')](_0x4c7b('0x5a'))){_0x1f599d[_0x4c7b('0x62')]({'contact':_0x1985e6,'additionalPhones':_0x246bac['additionalPhones']});}_0x5b62fc++;}else{_0x46c84a++;}})[_0x4c7b('0x26')](function(){_0xe3af5b++;});});})[_0x4c7b('0x1b')](function(_0xd880c1){if(_0xd880c1){if(_0x1f599d[_0x4c7b('0x2a')]>0x0){return new Promise(function(_0x360f0e){var _0x3c0b45=[];for(var _0x411aed=0x0;_0x411aed<_0x1f599d[_0x4c7b('0x2a')];_0x411aed++){_0x3c0b45[_0x4c7b('0x62')](insertAdditionalPhones(_0x1f599d[_0x411aed][_0x4c7b('0x63')],_0x1f599d[_0x411aed]['additionalPhones']));}Promise[_0x4c7b('0x64')](_0x3c0b45)[_0x4c7b('0x1b')](function(){_0x360f0e(0x1);});})[_0x4c7b('0x1b')](function(){return{'success':_0x5b62fc,'failure':_0xe3af5b,'duplicates':_0x46c84a};});}else{return{'success':_0x5b62fc,'failure':_0xe3af5b,'duplicates':_0x46c84a};}}})[_0x4c7b('0x1b')](respondWithResult(_0x5df7b4,0xc9))[_0x4c7b('0x26')](handleError(_0x5df7b4,null));};exports[_0x4c7b('0x65')]=function(_0x3550cc,_0x5917f5){var _0x3ae6a7;return db['CmContact'][_0x4c7b('0x27')]()[_0x4c7b('0x1b')](function(_0x164616){return db[_0x4c7b('0x24')][_0x4c7b('0x66')]({'where':{'id':_0x3550cc['params']['id']},'include':[{'model':db['Tag'],'as':_0x4c7b('0x67'),'attributes':['id','name',_0x4c7b('0x68')],'required':_0x3550cc[_0x4c7b('0x2d')]['tag']?!![]:![]},{'model':db['CmContactHasItem'],'as':_0x4c7b('0x69'),'where':{'CmContactId':_0x3550cc[_0x4c7b('0x25')]['id']},'required':![],'include':[{'model':db[_0x4c7b('0x6a')],'as':_0x4c7b('0x6b')}]}],'order':[db[_0x4c7b('0x6c')][_0x4c7b('0x6d')]('Phones.OrderBy')],'attributes':_[_0x4c7b('0x29')](_0x164616)});})[_0x4c7b('0x1b')](function(_0x5459c2){if(!_['isNil'](_0x5459c2)){_0x3ae6a7=_0x5459c2[_0x4c7b('0x39')]({'plain':!![]});var _0x1c1cb6={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x5459c2&&_0x5459c2[_0x4c7b('0x5f')]){if(_0x5459c2[_0x4c7b('0x5f')]){_0x1c1cb6[_0x4c7b('0x5d')][_0x4c7b('0x6e')][_0x4c7b('0x62')]({'ListId':{'$ne':_0x5459c2[_0x4c7b('0x5f')]}});}}return db[_0x4c7b('0x2f')][_0x4c7b('0x22')](_0x1c1cb6);}})[_0x4c7b('0x1b')](function(_0x283a65){if(!_[_0x4c7b('0x56')](_0x283a65)){return _['omit'](_0x3ae6a7,_[_0x4c7b('0x6f')](_0x283a65,function(_0x36558b){return util[_0x4c7b('0x70')](_0x4c7b('0x71'),_0x36558b['id']);}));}})[_0x4c7b('0x1b')](handleEntityNotFound(_0x5917f5,null))[_0x4c7b('0x1b')](respondWithResult(_0x5917f5,null))[_0x4c7b('0x26')](handleError(_0x5917f5,null));};exports[_0x4c7b('0x1a')]=function(_0x4f4df1,_0x28a854){var _0x5f59f8;if(_0x4f4df1[_0x4c7b('0x38')]['id']){delete _0x4f4df1[_0x4c7b('0x38')]['id'];}if(!_[_0x4c7b('0x56')](_0x4f4df1[_0x4c7b('0x38')]['dialTimezone'])){var _0x474e6c=_0x4f4df1[_0x4c7b('0x38')][_0x4c7b('0x57')];if(!_[_0x4c7b('0x56')](shared[_0x4c7b('0x59')][_0x474e6c]))_0x4f4df1[_0x4c7b('0x38')][_0x4c7b('0x58')]=shared[_0x4c7b('0x59')][_0x474e6c][_0x4c7b('0x58')];}return db['CmContact']['find']({'where':{'id':_0x4f4df1[_0x4c7b('0x25')]['id']}})[_0x4c7b('0x1b')](handleEntityNotFound(_0x28a854,null))[_0x4c7b('0x1b')](saveUpdates(_0x4f4df1[_0x4c7b('0x38')],null))[_0x4c7b('0x1b')](function(_0x156839){_0x5f59f8=_0x156839;var _0xc2e5b3={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x156839&&_0x156839['ListId']){if(_0x156839[_0x4c7b('0x5f')]){_0xc2e5b3[_0x4c7b('0x5d')][_0x4c7b('0x6e')][_0x4c7b('0x62')]({'ListId':{'$ne':_0x156839[_0x4c7b('0x5f')]}});}}return db[_0x4c7b('0x2f')][_0x4c7b('0x22')](_0xc2e5b3);})[_0x4c7b('0x1b')](function(_0x4620ec){if(_0x4620ec){return _[_0x4c7b('0x72')](_['pickBy'](_0x4f4df1[_0x4c7b('0x38')],function(_0x406e2e,_0x11a2f8){return _[_0x4c7b('0x73')](_0x11a2f8,'cf_');}),_[_0x4c7b('0x6f')](_0x4620ec,function(_0x54150e){return util['format'](_0x4c7b('0x71'),_0x54150e['id']);}));}})[_0x4c7b('0x1b')](function(_0x296f46){if(_0x296f46&&!_[_0x4c7b('0x74')](_0x296f46)){var _0x516211=squel['update']()[_0x4c7b('0x75')](_0x4c7b('0x76'))[_0x4c7b('0x77')](_0x296f46)[_0x4c7b('0x5d')](_0x4c7b('0x78'),_0x4f4df1[_0x4c7b('0x25')]['id'])[_0x4c7b('0x79')]();return db[_0x4c7b('0x6c')]['query'](_0x516211[_0x4c7b('0x7a')],{'replacements':_0x516211[_0x4c7b('0x32')]});}})[_0x4c7b('0x1b')](function(){if(_0x4f4df1[_0x4c7b('0x38')][_0x4c7b('0x7b')]&&_0x5f59f8){return db['CmHopper'][_0x4c7b('0x1a')]({'phone':_0x4f4df1[_0x4c7b('0x38')][_0x4c7b('0x7b')],'OrderBy':0x0},{'where':{'ContactId':_0x5f59f8['id']}});}})['then'](function(){return _0x5f59f8;})[_0x4c7b('0x1b')](respondWithResult(_0x28a854,null))['catch'](handleError(_0x28a854,null));};exports['getTags']=function(_0x275cf4,_0x3b3d16){var _0x2233b6={};var _0x1858e9={};var _0x46c4e7;var _0x3fbfb4;return db[_0x4c7b('0x24')][_0x4c7b('0x7c')]({'where':{'id':_0x275cf4['params']['id']}})['then'](handleEntityNotFound(_0x3b3d16,null))[_0x4c7b('0x1b')](function(_0x3c4932){if(_0x3c4932){_0x46c4e7=_0x3c4932;_0x1858e9[_0x4c7b('0x7d')]=_[_0x4c7b('0x29')](db[_0x4c7b('0x7e')][_0x4c7b('0x7f')]);_0x1858e9[_0x4c7b('0x2d')]=_[_0x4c7b('0x29')](_0x275cf4[_0x4c7b('0x2d')]);_0x1858e9['filters']=_['intersection'](_0x1858e9[_0x4c7b('0x7d')],_0x1858e9['query']);_0x2233b6[_0x4c7b('0x80')]=_[_0x4c7b('0x81')](_0x1858e9['model'],qs[_0x4c7b('0x82')](_0x275cf4[_0x4c7b('0x2d')][_0x4c7b('0x82')]));_0x2233b6['attributes']=_0x2233b6[_0x4c7b('0x80')][_0x4c7b('0x2a')]?_0x2233b6[_0x4c7b('0x80')]:_0x1858e9['model'];_0x2233b6[_0x4c7b('0x83')]=qs['sort'](_0x275cf4[_0x4c7b('0x2d')][_0x4c7b('0x84')]);_0x2233b6[_0x4c7b('0x5d')]=qs['filters'](_[_0x4c7b('0x85')](_0x275cf4['query'],_0x1858e9['filters']));if(_0x275cf4['query'][_0x4c7b('0x86')]){_0x2233b6['where']=_['merge'](_0x2233b6[_0x4c7b('0x5d')],{'$or':_[_0x4c7b('0x6f')](_0x2233b6[_0x4c7b('0x80')],function(_0x1dee66){var _0x13a48f={};_0x13a48f[_0x1dee66]={'$like':'%'+_0x275cf4['query'][_0x4c7b('0x86')]+'%'};return _0x13a48f;})});}_0x2233b6=_[_0x4c7b('0x87')]({},_0x2233b6,_0x275cf4[_0x4c7b('0x88')]);return _0x46c4e7[_0x4c7b('0x89')](_0x2233b6);}})[_0x4c7b('0x1b')](function(_0x4d85d0){if(_0x4d85d0){_0x3fbfb4=_0x4d85d0[_0x4c7b('0x2a')];if(!_0x275cf4['query'][_0x4c7b('0x36')]('nolimit')){_0x2233b6[_0x4c7b('0x15')]=qs[_0x4c7b('0x15')](_0x275cf4[_0x4c7b('0x2d')][_0x4c7b('0x15')]);_0x2233b6[_0x4c7b('0x14')]=qs[_0x4c7b('0x14')](_0x275cf4[_0x4c7b('0x2d')][_0x4c7b('0x14')]);}return _0x46c4e7[_0x4c7b('0x89')](_0x2233b6);}})[_0x4c7b('0x1b')](function(_0x466469){if(_0x466469){return _0x466469?{'count':_0x3fbfb4,'rows':_0x466469}:null;}})[_0x4c7b('0x1b')](respondWithResult(_0x3b3d16,null))[_0x4c7b('0x26')](handleError(_0x3b3d16,null));};exports[_0x4c7b('0x8a')]=function(_0x3330eb,_0x45dff6){if(_0x3330eb['body']['id']){delete _0x3330eb['body']['id'];}return db[_0x4c7b('0x24')][_0x4c7b('0x7c')]({'where':{'id':_0x3330eb['params']['id']}})[_0x4c7b('0x1b')](handleEntityNotFound(_0x45dff6,null))[_0x4c7b('0x1b')](function(_0x2ab5ef){if(_0x2ab5ef){return _0x2ab5ef['setTags'](_0x3330eb[_0x4c7b('0x38')][_0x4c7b('0x8b')]||[]);}return null;})[_0x4c7b('0x1b')](respondWithResult(_0x45dff6,null))[_0x4c7b('0x26')](handleError(_0x45dff6,null));};exports[_0x4c7b('0x8c')]=function(_0x458f76,_0x14f63e){var _0x39209b=[];_0x39209b[_0x4c7b('0x62')](addAdditionalPhones(_0x458f76[_0x4c7b('0x38')]));Promise[_0x4c7b('0x64')](_0x39209b)[_0x4c7b('0x1b')](function(){_0x39209b=[];_0x39209b[_0x4c7b('0x62')](deleteCmHopperPhones(_0x458f76[_0x4c7b('0x38')]['id']));_0x39209b[_0x4c7b('0x62')](addCmHopperPhones(_0x458f76[_0x4c7b('0x38')]['id']));Promise[_0x4c7b('0x64')](_0x39209b)[_0x4c7b('0x1b')](function(){return[0x1];})[_0x4c7b('0x1b')](respondWithResult(_0x14f63e,null));});};function addAdditionalPhones(_0x385cde){var _0x26521b;return new Promise(function(_0x4707ab){return db[_0x4c7b('0x4b')][_0x4c7b('0x1c')]({'where':{'CmContactId':_0x385cde['id']}})[_0x4c7b('0x1b')](function(){db[_0x4c7b('0x6a')]['findAll']({'raw':!![],'attributes':['id',_0x4c7b('0x8d')]})['then'](function(_0x3c121c){var _0x5f1d42=[];for(var _0x1977f4=0x0;_0x1977f4<_0x385cde['items'][_0x4c7b('0x2a')];_0x1977f4++){var _0x489a55=_0x385cde[_0x4c7b('0x8e')]?_[_0x4c7b('0x56')](_0x385cde[_0x4c7b('0x8e')][_0x1977f4])?'':_0x385cde[_0x4c7b('0x8e')][_0x1977f4]:_0x385cde[_0x4c7b('0x8f')][_0x1977f4][_0x4c7b('0x90')]?_0x385cde[_0x4c7b('0x8f')][_0x1977f4]['ItemTypeId']:'';var _0x55280d=_[_0x4c7b('0x56')](_0x385cde[_0x4c7b('0x8f')][_0x1977f4][_0x4c7b('0x91')])?'':_0x385cde[_0x4c7b('0x8f')][_0x1977f4][_0x4c7b('0x91')];var _0x5c3ff6=_0x489a55+':'+_0x385cde[_0x4c7b('0x8f')][_0x1977f4][_0x4c7b('0x7b')]+'§'+_0x55280d;if(_[_0x4c7b('0x56')](_0x26521b))_0x26521b=_0x5c3ff6;else _0x26521b+=';'+_0x5c3ff6;var _0x35b633=null;var _0x55614b=null;if(_0x385cde[_0x4c7b('0x8e')]){if(!_[_0x4c7b('0x56')](_0x385cde['item_types'][_0x1977f4])){_0x55614b=_['find'](_0x3c121c,function(_0x25b57f){return _0x25b57f['id']===_0x385cde[_0x4c7b('0x8e')][_0x1977f4];});if(!_[_0x4c7b('0x56')](_0x55614b)){_0x35b633=_0x55614b['OrderBy'];}}}else{if(!_[_0x4c7b('0x56')](_0x385cde[_0x4c7b('0x8f')][_0x1977f4])){_0x55614b=_[_0x4c7b('0x66')](_0x3c121c,function(_0x5a2e3c){return _0x5a2e3c['id']===_0x385cde['items'][_0x1977f4][_0x4c7b('0x90')];});if(!_[_0x4c7b('0x56')](_0x55614b)){_0x35b633=_0x1977f4;}}}if(_['isNil'](_0x35b633)){_0x35b633=0x64;}_0x5f1d42[_0x4c7b('0x62')](addAdditionalPhone(_0x385cde['id'],_0x385cde[_0x4c7b('0x8f')][_0x1977f4][_0x4c7b('0x7b')],_0x385cde[_0x4c7b('0x8e')]?_[_0x4c7b('0x56')](_0x385cde['item_types'][_0x1977f4])?null:_0x385cde[_0x4c7b('0x8e')][_0x1977f4]:_0x385cde['items'][_0x1977f4][_0x4c7b('0x90')]?_0x385cde[_0x4c7b('0x8f')][_0x1977f4]['ItemTypeId']:null,_0x35b633,_0x55280d));}Promise[_0x4c7b('0x64')](_0x5f1d42)['then'](function(){db[_0x4c7b('0x24')]['update']({'AdditionalPhones':_0x26521b},{'where':{'id':_0x385cde['id']}})[_0x4c7b('0x1b')](function(){_0x4707ab(0x1);});});});});});}function addAdditionalPhone(_0x1feaca,_0x36bf93,_0x5776cb,_0x35a8e2,_0x4790b5){return db[_0x4c7b('0x4b')]['find']({'where':{'CmContactId':_0x1feaca,'item':_0x36bf93}})['then'](function(_0x5ce501){if(_0x5ce501)logger[_0x4c7b('0x33')](_0x4c7b('0x92'),_0x5ce501);else{db[_0x4c7b('0x4b')][_0x4c7b('0x41')]({'CmContactId':_0x1feaca,'item':_0x36bf93,'ItemTypeId':_0x5776cb,'OrderBy':_0x35a8e2,'ItemClass':_0x4c7b('0x93'),'description':_0x4790b5});}});}function deleteCmHopperPhones(_0x22f730){return new Promise(function(_0xccf905){return db[_0x4c7b('0x94')][_0x4c7b('0x22')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x22f730}})['then'](function(_0x4db0b7){db['CmHopperAdditionalPhone'][_0x4c7b('0x1c')]({'where':{'CmHopperId':{'$in':_[_0x4c7b('0x6f')](_0x4db0b7,'id')}}});})['then'](function(){_0xccf905(0x1);});});}function addCmHopperPhones(_0x5acc01){return new Promise(function(_0x291c87){return db[_0x4c7b('0x94')][_0x4c7b('0x22')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x5acc01}})[_0x4c7b('0x1b')](function(_0x5ecd1a){var _0x479ef8=[];_[_0x4c7b('0x6f')](_0x5ecd1a,function(_0x306006){_0x479ef8[_0x4c7b('0x62')](createCmHopperPhone(_0x5acc01,_0x306006['id']));});Promise[_0x4c7b('0x64')](_0x479ef8)['then'](function(){_0x291c87(0x1);});});});}function createCmHopperPhone(_0x2a35b1,_0x372355){return new Promise(function(_0x250a07){db[_0x4c7b('0x4b')]['findAll']({'raw':!![],'attributes':[_0x4c7b('0x95'),'OrderBy'],'where':{'CmContactId':_0x2a35b1,'ItemClass':_0x4c7b('0x93')},'include':[{'model':db['ContactItemType'],'attributes':['OrderBy'],'as':_0x4c7b('0x6b')}],'order':[_0x4c7b('0x8d'),db['sequelize']['literal'](_0x4c7b('0x96'))]})[_0x4c7b('0x1b')](function(_0x3f1303){var _0xdd752a=0x1;var _0x1e19f0=_[_0x4c7b('0x6f')](_0x3f1303,function(_0x3c1157){_0x3c1157[_0x4c7b('0x97')]=_0x372355;_0x3c1157[_0x4c7b('0x7b')]=_0x3c1157[_0x4c7b('0x95')];_0x3c1157[_0x4c7b('0x8d')]=_0xdd752a;delete _0x3c1157['ItemType.OrderBy'];_0xdd752a=_0xdd752a+0x1;return _0x3c1157;});return db['CmHopperAdditionalPhone'][_0x4c7b('0x98')](_0x1e19f0,{});})['then'](function(){_0x250a07(0x1);});});}function insertAdditionalPhones(_0x37022d,_0xf4ba41){return new Promise(function(_0x3e600e){var _0x122c57=[];for(var _0x395c7e=0x0;_0x395c7e<_0xf4ba41[_0x4c7b('0x2a')];_0x395c7e++){var _0x5e0f95=_0xf4ba41[_0x395c7e];_0x122c57[_0x4c7b('0x62')](parseContactItemType(_0x5e0f95));}Promise[_0x4c7b('0x64')](_0x122c57)[_0x4c7b('0x1b')](function(){var _0x137989={'id':_0x37022d['id'],'items':_0xf4ba41};return addAdditionalPhones(_0x137989)[_0x4c7b('0x1b')](function(){return addCmHopperPhones(_0x37022d['id']);});})[_0x4c7b('0x1b')](function(){_0x3e600e(_0x37022d);});});}function parseContactItemType(_0x5ee9f2){return new Promise(function(_0xc2fabe){if(_0x5ee9f2[_0x4c7b('0x36')]('ItemTypeId')){_0xc2fabe(_0x5ee9f2);}else{return db[_0x4c7b('0x6a')]['find']({'where':{'name':_0x5ee9f2[_0x4c7b('0x6b')]}})['then'](function(_0x57c9fb){if(_[_0x4c7b('0x56')](_0x57c9fb))_0x5ee9f2['ItemTypeId']=null;else _0x5ee9f2[_0x4c7b('0x90')]=_0x57c9fb['id'];_0xc2fabe(_0x5ee9f2);});}});}exports[_0x4c7b('0x99')]=function(_0x569f5b,_0x45f9f2){return db[_0x4c7b('0x4b')][_0x4c7b('0x22')]({'raw':!![],'where':{'CmContactId':_0x569f5b[_0x4c7b('0x25')]['id'],'ItemClass':_0x4c7b('0x93')},'include':[{'model':db[_0x4c7b('0x6a')],'as':_0x4c7b('0x6b')}],'order':[[_0x4c7b('0x8d')],[db['sequelize'][_0x4c7b('0x6d')](_0x4c7b('0x96'))]]})[_0x4c7b('0x1b')](function(_0x199b5f){return _0x199b5f;})[_0x4c7b('0x1b')](respondWithResult(_0x45f9f2,null))[_0x4c7b('0x26')](handleError(_0x45f9f2,null));};exports[_0x4c7b('0x9a')]=function(_0x31b418,_0x360b96){return db['CmContactHasItem'][_0x4c7b('0x22')]({'raw':!![],'where':{'CmContactId':_0x31b418[_0x4c7b('0x38')][_0x4c7b('0x9b')]}})[_0x4c7b('0x1b')](function(_0x76e9c5){var _0x53fb85=_[_0x4c7b('0x6f')](_0x76e9c5,function(_0x416c4f){_0x416c4f[_0x4c7b('0x9c')]=_0x31b418[_0x4c7b('0x38')][_0x4c7b('0x9d')];return _0x416c4f;});return db['CmContactHasItem'][_0x4c7b('0x98')](_0x53fb85,{});})[_0x4c7b('0x1b')](function(){return addCmHopperPhones(_0x31b418[_0x4c7b('0x38')][_0x4c7b('0x9d')]);})['then'](function(){return['ok'];})[_0x4c7b('0x1b')](respondWithResult(_0x360b96,null))[_0x4c7b('0x26')](handleError(_0x360b96,null));};exports[_0x4c7b('0x9e')]=function(_0x263ff8,_0xd2ea21){var _0x2ace04=[];_0x2ace04[_0x4c7b('0x62')](createCmHopperPhone(_0x263ff8[_0x4c7b('0x38')]['id'],_0x263ff8['body'][_0x4c7b('0x9f')]));Promise[_0x4c7b('0x64')](_0x2ace04)['then'](function(){return[0x1];})[_0x4c7b('0x1b')](respondWithResult(_0xd2ea21,null));};exports[_0x4c7b('0xa0')]=function(_0x31dea6,_0x27629a){var _0x3cf7e4={'raw':![],'where':{}};var _0x46af86={};var _0x2201ed={'count':0x0,'rows':[]};return db[_0x4c7b('0x24')][_0x4c7b('0x7c')]({'where':{'id':_0x31dea6[_0x4c7b('0x25')]['id']}})[_0x4c7b('0x1b')](handleEntityNotFound(_0x27629a,null))[_0x4c7b('0x1b')](function(_0x19c959){if(_0x19c959){_0x46af86[_0x4c7b('0x7d')]=_[_0x4c7b('0x29')](db['CmHopper'][_0x4c7b('0x7f')]);_0x46af86[_0x4c7b('0x2d')]=_[_0x4c7b('0x29')](_0x31dea6[_0x4c7b('0x2d')]);_0x46af86[_0x4c7b('0xa1')]=_[_0x4c7b('0x81')](_0x46af86[_0x4c7b('0x7d')],_0x46af86['query']);_0x3cf7e4[_0x4c7b('0x80')]=_[_0x4c7b('0x81')](_0x46af86[_0x4c7b('0x7d')],qs[_0x4c7b('0x82')](_0x31dea6['query'][_0x4c7b('0x82')]));_0x3cf7e4[_0x4c7b('0x80')]=_0x3cf7e4[_0x4c7b('0x80')][_0x4c7b('0x2a')]?_0x3cf7e4['attributes']:_0x46af86[_0x4c7b('0x7d')];if(!_0x31dea6[_0x4c7b('0x2d')][_0x4c7b('0x36')](_0x4c7b('0xa2'))){_0x3cf7e4[_0x4c7b('0x15')]=qs['limit'](_0x31dea6['query'][_0x4c7b('0x15')]);_0x3cf7e4[_0x4c7b('0x14')]=qs[_0x4c7b('0x14')](_0x31dea6[_0x4c7b('0x2d')][_0x4c7b('0x14')]);}_0x3cf7e4[_0x4c7b('0x83')]=qs[_0x4c7b('0x84')](_0x31dea6[_0x4c7b('0x2d')][_0x4c7b('0x84')]);_0x3cf7e4['where']=qs['filters'](_[_0x4c7b('0x85')](_0x31dea6['query'],_0x46af86['filters']));_0x3cf7e4['where'][_0x4c7b('0xa3')]=_0x19c959['id'];if(_0x31dea6[_0x4c7b('0x2d')][_0x4c7b('0x86')]){_0x3cf7e4[_0x4c7b('0x5d')]=_['merge'](_0x3cf7e4[_0x4c7b('0x5d')],{'$or':_[_0x4c7b('0x6f')](_0x3cf7e4[_0x4c7b('0x80')],function(_0x195d8f){var _0x1ed03c={};_0x1ed03c[_0x195d8f]={'$like':'%'+_0x31dea6[_0x4c7b('0x2d')][_0x4c7b('0x86')]+'%'};return _0x1ed03c;})});}_0x3cf7e4=_[_0x4c7b('0x87')]({},_0x3cf7e4,_0x31dea6[_0x4c7b('0x88')]);return db['CmHopper'][_0x4c7b('0x17')]({'where':_0x3cf7e4['where']})[_0x4c7b('0x1b')](function(_0x4258b2){_0x2201ed[_0x4c7b('0x17')]=_0x4258b2;if(_0x31dea6[_0x4c7b('0x2d')][_0x4c7b('0xa4')]){_0x3cf7e4['include']=[{'all':!![]}];}return db[_0x4c7b('0x94')]['findAll'](_0x3cf7e4);})[_0x4c7b('0x1b')](function(_0x581e4e){_0x2201ed[_0x4c7b('0xa5')]=_0x581e4e;return _0x2201ed;});}})['then'](respondWithFilteredResult(_0x27629a,_0x3cf7e4))[_0x4c7b('0x26')](handleError(_0x27629a,null));};exports[_0x4c7b('0xa6')]=function(_0x22b848,_0x112675){var _0x19db0b={'raw':!![],'where':{}};var _0x42c513={};var _0x1270ce={'count':0x0,'rows':[]};return db[_0x4c7b('0x24')]['findOne']({'where':{'id':_0x22b848['params']['id']}})[_0x4c7b('0x1b')](handleEntityNotFound(_0x112675,null))[_0x4c7b('0x1b')](function(_0x2fc076){if(_0x2fc076){_0x42c513[_0x4c7b('0x7d')]=_[_0x4c7b('0x29')](db[_0x4c7b('0xa7')][_0x4c7b('0x7f')]);_0x42c513['query']=_[_0x4c7b('0x29')](_0x22b848[_0x4c7b('0x2d')]);_0x42c513['filters']=_[_0x4c7b('0x81')](_0x42c513[_0x4c7b('0x7d')],_0x42c513[_0x4c7b('0x2d')]);_0x19db0b[_0x4c7b('0x80')]=_[_0x4c7b('0x81')](_0x42c513[_0x4c7b('0x7d')],qs['fields'](_0x22b848[_0x4c7b('0x2d')][_0x4c7b('0x82')]));_0x19db0b[_0x4c7b('0x80')]=_0x19db0b[_0x4c7b('0x80')][_0x4c7b('0x2a')]?_0x19db0b['attributes']:_0x42c513['model'];if(!_0x22b848['query'][_0x4c7b('0x36')]('nolimit')){_0x19db0b['limit']=qs['limit'](_0x22b848[_0x4c7b('0x2d')]['limit']);_0x19db0b[_0x4c7b('0x14')]=qs['offset'](_0x22b848['query'][_0x4c7b('0x14')]);}_0x19db0b['order']=qs[_0x4c7b('0x84')](_0x22b848[_0x4c7b('0x2d')][_0x4c7b('0x84')]);_0x19db0b[_0x4c7b('0x5d')]=qs[_0x4c7b('0xa1')](_[_0x4c7b('0x85')](_0x22b848['query'],_0x42c513[_0x4c7b('0xa1')]));_0x19db0b[_0x4c7b('0x5d')][_0x4c7b('0xa3')]=_0x2fc076['id'];if(_0x22b848[_0x4c7b('0x2d')][_0x4c7b('0x86')]){_0x19db0b[_0x4c7b('0x5d')]=_[_0x4c7b('0x87')](_0x19db0b[_0x4c7b('0x5d')],{'$or':_['map'](_0x19db0b[_0x4c7b('0x80')],function(_0x2bd175){var _0x2b7e3a={};_0x2b7e3a[_0x2bd175]={'$like':'%'+_0x22b848[_0x4c7b('0x2d')][_0x4c7b('0x86')]+'%'};return _0x2b7e3a;})});}_0x19db0b=_[_0x4c7b('0x87')]({},_0x19db0b,_0x22b848['options']);return db['CmHopperHistory'][_0x4c7b('0x17')]({'where':_0x19db0b['where']})[_0x4c7b('0x1b')](function(_0xe32e3c){_0x1270ce[_0x4c7b('0x17')]=_0xe32e3c;if(_0x22b848[_0x4c7b('0x2d')]['includeAll']){_0x19db0b[_0x4c7b('0xa8')]=[{'all':!![]}];}return db[_0x4c7b('0xa7')][_0x4c7b('0x22')](_0x19db0b);})[_0x4c7b('0x1b')](function(_0x20d23b){_0x1270ce[_0x4c7b('0xa5')]=_0x20d23b;return _0x1270ce;});}})[_0x4c7b('0x1b')](respondWithFilteredResult(_0x112675,_0x19db0b))[_0x4c7b('0x26')](handleError(_0x112675,null));};exports['getHopperFinals']=function(_0x19d29f,_0x4e40b0){var _0x4d53a3={'raw':!![],'where':{}};var _0x184f1d={};var _0x465efd={'count':0x0,'rows':[]};return db[_0x4c7b('0x24')][_0x4c7b('0x7c')]({'where':{'id':_0x19d29f[_0x4c7b('0x25')]['id']}})[_0x4c7b('0x1b')](handleEntityNotFound(_0x4e40b0,null))[_0x4c7b('0x1b')](function(_0x38abed){if(_0x38abed){_0x184f1d[_0x4c7b('0x7d')]=_[_0x4c7b('0x29')](db[_0x4c7b('0xa9')][_0x4c7b('0x7f')]);_0x184f1d[_0x4c7b('0x2d')]=_[_0x4c7b('0x29')](_0x19d29f[_0x4c7b('0x2d')]);_0x184f1d[_0x4c7b('0xa1')]=_[_0x4c7b('0x81')](_0x184f1d[_0x4c7b('0x7d')],_0x184f1d[_0x4c7b('0x2d')]);_0x4d53a3[_0x4c7b('0x80')]=_[_0x4c7b('0x81')](_0x184f1d[_0x4c7b('0x7d')],qs[_0x4c7b('0x82')](_0x19d29f['query']['fields']));_0x4d53a3[_0x4c7b('0x80')]=_0x4d53a3['attributes'][_0x4c7b('0x2a')]?_0x4d53a3[_0x4c7b('0x80')]:_0x184f1d[_0x4c7b('0x7d')];if(!_0x19d29f[_0x4c7b('0x2d')][_0x4c7b('0x36')](_0x4c7b('0xa2'))){_0x4d53a3[_0x4c7b('0x15')]=qs[_0x4c7b('0x15')](_0x19d29f[_0x4c7b('0x2d')][_0x4c7b('0x15')]);_0x4d53a3[_0x4c7b('0x14')]=qs[_0x4c7b('0x14')](_0x19d29f[_0x4c7b('0x2d')][_0x4c7b('0x14')]);}_0x4d53a3[_0x4c7b('0x83')]=qs[_0x4c7b('0x84')](_0x19d29f[_0x4c7b('0x2d')][_0x4c7b('0x84')]);_0x4d53a3[_0x4c7b('0x5d')]=qs['filters'](_[_0x4c7b('0x85')](_0x19d29f['query'],_0x184f1d[_0x4c7b('0xa1')]));_0x4d53a3[_0x4c7b('0x5d')][_0x4c7b('0xa3')]=_0x38abed['id'];if(_0x19d29f['query'][_0x4c7b('0x86')]){_0x4d53a3['where']=_[_0x4c7b('0x87')](_0x4d53a3['where'],{'$or':_['map'](_0x4d53a3[_0x4c7b('0x80')],function(_0x3fe0f0){var _0x453d0c={};_0x453d0c[_0x3fe0f0]={'$like':'%'+_0x19d29f[_0x4c7b('0x2d')]['filter']+'%'};return _0x453d0c;})});}_0x4d53a3=_['merge']({},_0x4d53a3,_0x19d29f[_0x4c7b('0x88')]);return db[_0x4c7b('0xa9')][_0x4c7b('0x17')]({'where':_0x4d53a3['where']})[_0x4c7b('0x1b')](function(_0x403071){_0x465efd[_0x4c7b('0x17')]=_0x403071;if(_0x19d29f['query'][_0x4c7b('0xa4')]){_0x4d53a3['include']=[{'all':!![]}];}return db[_0x4c7b('0xa9')][_0x4c7b('0x22')](_0x4d53a3);})['then'](function(_0x164168){_0x465efd[_0x4c7b('0xa5')]=_0x164168;return _0x465efd;});}})['then'](respondWithFilteredResult(_0x4e40b0,_0x4d53a3))[_0x4c7b('0x26')](handleError(_0x4e40b0,null));};exports[_0x4c7b('0xaa')]=function(_0x3e5811,_0x2b1255){var _0x898fc7={'raw':!![],'where':{}};var _0x9e43d1={};var _0x4398dd={'count':0x0,'rows':[]};return db[_0x4c7b('0x24')]['findOne']({'where':{'id':_0x3e5811[_0x4c7b('0x25')]['id']}})['then'](handleEntityNotFound(_0x2b1255,null))['then'](function(_0x961209){if(_0x961209){_0x9e43d1[_0x4c7b('0x7d')]=_[_0x4c7b('0x29')](db[_0x4c7b('0x53')][_0x4c7b('0x7f')]);_0x9e43d1[_0x4c7b('0x2d')]=_[_0x4c7b('0x29')](_0x3e5811[_0x4c7b('0x2d')]);_0x9e43d1['filters']=_[_0x4c7b('0x81')](_0x9e43d1['model'],_0x9e43d1[_0x4c7b('0x2d')]);_0x898fc7['attributes']=_[_0x4c7b('0x81')](_0x9e43d1[_0x4c7b('0x7d')],qs[_0x4c7b('0x82')](_0x3e5811[_0x4c7b('0x2d')]['fields']));_0x898fc7['attributes']=_0x898fc7[_0x4c7b('0x80')]['length']?_0x898fc7[_0x4c7b('0x80')]:_0x9e43d1['model'];if(!_0x3e5811[_0x4c7b('0x2d')][_0x4c7b('0x36')](_0x4c7b('0xa2'))){_0x898fc7[_0x4c7b('0x15')]=qs[_0x4c7b('0x15')](_0x3e5811['query'][_0x4c7b('0x15')]);_0x898fc7[_0x4c7b('0x14')]=qs[_0x4c7b('0x14')](_0x3e5811['query'][_0x4c7b('0x14')]);}_0x898fc7[_0x4c7b('0x83')]=qs[_0x4c7b('0x84')](_0x3e5811['query'][_0x4c7b('0x84')]);_0x898fc7[_0x4c7b('0x5d')]=qs[_0x4c7b('0xa1')](_[_0x4c7b('0x85')](_0x3e5811['query'],_0x9e43d1[_0x4c7b('0xa1')]));_0x898fc7[_0x4c7b('0x5d')][_0x4c7b('0xa3')]=_0x961209['id'];if(_0x3e5811[_0x4c7b('0x2d')][_0x4c7b('0x86')]){_0x898fc7[_0x4c7b('0x5d')]=_[_0x4c7b('0x87')](_0x898fc7[_0x4c7b('0x5d')],{'$or':_[_0x4c7b('0x6f')](_0x898fc7[_0x4c7b('0x80')],function(_0x3b6f29){var _0x5caa08={};_0x5caa08[_0x3b6f29]={'$like':'%'+_0x3e5811[_0x4c7b('0x2d')][_0x4c7b('0x86')]+'%'};return _0x5caa08;})});}_0x898fc7=_['merge']({},_0x898fc7,_0x3e5811[_0x4c7b('0x88')]);return db['JscriptySessionReport'][_0x4c7b('0x17')]({'where':_0x898fc7['where']})[_0x4c7b('0x1b')](function(_0x3b50ff){_0x4398dd['count']=_0x3b50ff;if(_0x3e5811[_0x4c7b('0x2d')]['includeAll']){_0x898fc7['include']=[{'all':!![]}];}return db[_0x4c7b('0x53')][_0x4c7b('0x22')](_0x898fc7);})[_0x4c7b('0x1b')](function(_0x120871){_0x4398dd[_0x4c7b('0xa5')]=_0x120871;return _0x4398dd;});}})[_0x4c7b('0x1b')](respondWithFilteredResult(_0x2b1255,_0x898fc7))[_0x4c7b('0x26')](handleError(_0x2b1255,null));};exports[_0x4c7b('0xab')]=function(_0x3ad48e,_0x406a1f){try{if(!_0x3ad48e[_0x4c7b('0x38')][_0x4c7b('0x5f')]){throw new Error('No\x20ListId\x20specified');}if(!_0x3ad48e[_0x4c7b('0x38')][_0x4c7b('0xac')]){throw new Error(_0x4c7b('0xad'));}if(!_0x3ad48e[_0x4c7b('0x38')]['binding_values']){throw new Error('No\x20association\x20values\x20specified!');}if(!_0x3ad48e[_0x4c7b('0x38')]['socket_timestamp']){throw new Error(_0x4c7b('0xae'));}var _0x4b69c9=_0x3ad48e[_0x4c7b('0x38')][_0x4c7b('0xac')]['split'](',');var _0x32711d=_0x3ad48e[_0x4c7b('0x38')]['binding_values']['split'](',');if(!_0x4b69c9[_0x4c7b('0x2a')]||!_0x32711d[_0x4c7b('0x2a')]||_0x4b69c9[_0x4c7b('0x2a')]!==_0x32711d['length']){throw new Error(_0x4c7b('0xaf'));}_0x3ad48e[_0x4c7b('0x38')][_0x4c7b('0x82')]=_['zipObject'](_0x4b69c9,_0x32711d);if(!_0x3ad48e[_0x4c7b('0x38')][_0x4c7b('0x82')]['phone']){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x3ad48e['body']['fields'][_0x4c7b('0xb0')]){throw new Error(_0x4c7b('0xb1'));}var _0x531911=path[_0x4c7b('0x3c')](config[_0x4c7b('0xb2')],_0x4c7b('0xb3'),_0x3ad48e[_0x4c7b('0xb4')][_0x4c7b('0xb5')]);fs[_0x4c7b('0xb6')](_0x531911,parseInt('0777',0x8));var _0x50578c=require(_0x4c7b('0xb7'))[_0x4c7b('0xb8')](path[_0x4c7b('0x3c')](__dirname,_0x4c7b('0xb9')),[_0x531911,_0x3ad48e[_0x4c7b('0x38')][_0x4c7b('0xac')],_0x3ad48e['body'][_0x4c7b('0xba')],_0x3ad48e[_0x4c7b('0x38')][_0x4c7b('0x5f')],_0x3ad48e[_0x4c7b('0x38')][_0x4c7b('0xbb')],_0x3ad48e[_0x4c7b('0x38')]['duplicates'],_0x3ad48e[_0x4c7b('0x38')][_0x4c7b('0xbc')]]);return _0x406a1f[_0x4c7b('0x12')](0xc8)[_0x4c7b('0x13')]({'message':_0x4c7b('0xbd'),'pid':_0x50578c[_0x4c7b('0xbe')]});}catch(_0x2bdf5a){return _0x406a1f[_0x4c7b('0x12')](0x1f4)[_0x4c7b('0xbf')](_0x2bdf5a);}};exports['upload']=function(_0x4fea54,_0x4c6045){var _0x10523f=fs['createReadStream'](_0x4fea54[_0x4c7b('0xb4')][_0x4c7b('0x2')]);Papa[_0x4c7b('0xc0')](_0x10523f,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x4d5e8b){return _0x4c6045[_0x4c7b('0x12')](0xc8)[_0x4c7b('0x13')]({'file':_0x4fea54[_0x4c7b('0xb4')],'fields':_0x4d5e8b[_0x4c7b('0xc1')][_0x4c7b('0x82')]});}});};exports[_0x4c7b('0xc2')]=function(_0x3fce19,_0x16651c){return db['User'][_0x4c7b('0x22')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0x4c7b('0x1b')](function(_0x530e8f){var _0x857c07=![];if(!_0x3fce19['body'][_0x4c7b('0x5f')]){throw new Error(_0x4c7b('0xc3'));}if(!_0x3fce19[_0x4c7b('0x38')][_0x4c7b('0xc4')][_0x4c7b('0x7b')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x3fce19[_0x4c7b('0x38')][_0x4c7b('0xc4')][_0x4c7b('0xb0')]){throw new Error(_0x4c7b('0xb1'));}if(!_0x3fce19[_0x4c7b('0x38')][_0x4c7b('0xbc')]){throw new Error(_0x4c7b('0xae'));}var _0x2743f8=require(_0x4c7b('0xb7'))[_0x4c7b('0xb8')](path[_0x4c7b('0x3c')](__dirname,_0x4c7b('0xc5')),[_0x3fce19[_0x4c7b('0x25')]['id'],JSON[_0x4c7b('0xc6')](_0x3fce19[_0x4c7b('0x38')]),JSON[_0x4c7b('0xc6')](_0x530e8f)]);_0x2743f8['on'](_0x4c7b('0xc7'),function(){_0x857c07=!![];return _0x16651c['status'](0xc8)['json']({'message':_0x4c7b('0xc8'),'pid':_0x2743f8['pid']});});_0x2743f8['on'](_0x4c7b('0xc9'),function(_0x452c22){if(_0x452c22&&!_0x857c07){return _0x16651c[_0x4c7b('0x12')](0x1f4)[_0x4c7b('0x13')]({'message':_0x4c7b('0xca'),'pid':_0x2743f8[_0x4c7b('0xbe')]});}});})[_0x4c7b('0x26')](handleError(_0x16651c,null));};exports[_0x4c7b('0xcb')]=function(_0x4f5449,_0x4229a6){return db['User']['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0x4c7b('0xcc')}})[_0x4c7b('0x1b')](function(_0xdea32a){var _0x456be7=![];if(!_0x4f5449[_0x4c7b('0x38')][_0x4c7b('0x5f')]){throw new Error(_0x4c7b('0xc3'));}if(!_0x4f5449[_0x4c7b('0x38')]['binding'][_0x4c7b('0x7b')]){throw new Error(_0x4c7b('0xcd'));}if(!_0x4f5449[_0x4c7b('0x38')][_0x4c7b('0xc4')]['firstName']){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x4f5449[_0x4c7b('0x38')]['socket_timestamp']){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x38d87d=require(_0x4c7b('0xb7'))[_0x4c7b('0xb8')](path[_0x4c7b('0x3c')](__dirname,_0x4c7b('0xce')),[_0x4f5449[_0x4c7b('0x25')]['id'],JSON[_0x4c7b('0xc6')](_0x4f5449['body']),JSON[_0x4c7b('0xc6')](_0xdea32a)]);_0x38d87d['on'](_0x4c7b('0xc7'),function(){_0x456be7=!![];return _0x4229a6['status'](0xc8)[_0x4c7b('0x13')]({'message':_0x4c7b('0xc8'),'pid':_0x38d87d['pid']});});_0x38d87d['on']('exit',function(_0x16272d){if(_0x16272d&&!_0x456be7){return _0x4229a6['status'](0x1f4)[_0x4c7b('0x13')]({'message':_0x4c7b('0xca'),'pid':_0x38d87d[_0x4c7b('0xbe')]});}});})[_0x4c7b('0x26')](handleError(_0x4229a6,null));};exports[_0x4c7b('0xcf')]=function(_0x4425ea,_0x5b84c9){var _0x262889=['mail',_0x4c7b('0xd0'),_0x4c7b('0xd1'),_0x4c7b('0xd2'),'fax',_0x4c7b('0xd3'),_0x4c7b('0xd4')];var _0xc2fda0={'offset':0x0,'order':qs[_0x4c7b('0x84')](_0x4c7b('0xd5'))},_0x58bcfc={'count':0x0,'rows':[]};Promise[_0x4c7b('0xd6')]()[_0x4c7b('0x1b')](function(){if(_0x4425ea[_0x4c7b('0x2d')][_0x4c7b('0xd7')]){if(!_[_0x4c7b('0xd8')](_0x262889,_0x4425ea[_0x4c7b('0x2d')][_0x4c7b('0xd7')]['toLowerCase']())){throw new Error('Invalid\x20channel');}_0x262889=[_0x4425ea['query']['channel'][_0x4c7b('0xd9')]()];}if(_0x4425ea[_0x4c7b('0x2d')][_0x4c7b('0xda')]){try{var _0x242017=JSON[_0x4c7b('0xc0')](_0x4425ea[_0x4c7b('0x2d')]['range']);if(!moment(_0x242017[_0x4c7b('0x3d')])[_0x4c7b('0xdb')]()){throw new Error(_0x4c7b('0xdc'));}if(!moment(_0x242017['to'])['isValid']()){throw new Error(_0x4c7b('0xdd'));}}catch(_0x1ccb41){throw new Error(_0x4c7b('0xde'));}}if(!_0x4425ea['query']['hasOwnProperty'](_0x4c7b('0xa2'))){_0xc2fda0[_0x4c7b('0x15')]=qs[_0x4c7b('0x15')](_0x4425ea[_0x4c7b('0x2d')][_0x4c7b('0x15')]||0xa);_0xc2fda0[_0x4c7b('0x14')]=qs[_0x4c7b('0x14')](_0x4425ea[_0x4c7b('0x2d')]['offset']);}var _0x5553e7=_0x262889[_0x4c7b('0x6f')](function(_0x12c4b3){if(_0x12c4b3===_0x4c7b('0xd4')){var _0xf1f67b={'attributes':['id',_0x4c7b('0xdf'),'type',_0x4c7b('0xe0'),_0x4c7b('0xe1'),'callerid','starttime',_0x4c7b('0xe2'),_0x4c7b('0xe3'),_0x4c7b('0xe4'),_0x4c7b('0xe5'),'userDisposition','userSecondDisposition',_0x4c7b('0xe6'),'UserId'],'where':{'ContactId':_0x4425ea[_0x4c7b('0x25')]['id']},'include':[{'model':db[_0x4c7b('0xe7')],'as':_0x4c7b('0xe7'),'attributes':['id',_0x4c7b('0x1f'),_0x4c7b('0xe8'),_0x4c7b('0x30')]}],'order':[[_0x4c7b('0xe5'),_0x4c7b('0xe9')]]};if(_0x4425ea[_0x4c7b('0x2d')][_0x4c7b('0xda')]){_0xf1f67b[_0x4c7b('0x5d')]['createdAt']={'$gte':_0x242017[_0x4c7b('0x3d')],'$lte':_0x242017['to']};}return db[_0x4c7b('0x4d')]['findAndCountAll'](_0xf1f67b)[_0x4c7b('0x1b')](function(_0x2196f9){_0x58bcfc[_0x4c7b('0x17')]+=_0x2196f9['count'];return _[_0x4c7b('0x6f')](_0x2196f9[_0x4c7b('0xa5')],function(_0x1f4594){var _0x2a7036=_0x1f4594[_0x4c7b('0x39')]({'plain':!![]});_0x2a7036[_0x4c7b('0xd7')]=_0x12c4b3;if(_0x2a7036['User']){_0x2a7036[_0x4c7b('0xe7')]={'id':_0x2a7036[_0x4c7b('0xe7')]['id'],'name':_0x2a7036[_0x4c7b('0xe7')][_0x4c7b('0x1f')],'fullname':_0x2a7036[_0x4c7b('0xe7')][_0x4c7b('0xe8')],'alias':_0x2a7036['User'][_0x4c7b('0x30')]};}return _0x2a7036;});});}else{var _0x573365=_[_0x4c7b('0xea')](_0x12c4b3)+(_0x12c4b3===_0x4c7b('0xd0')?_0x4c7b('0xeb'):_0x4c7b('0xec'));var _0x402968={'attributes':['id',_0x4c7b('0xed'),_0x4c7b('0xee'),'createdAt',_0x4c7b('0xe4'),_0x4c7b('0xef'),'secondDisposition',_0x4c7b('0xf0'),_0x4c7b('0xf1'),_0x573365+'Id'],'where':{'ContactId':_0x4425ea['params']['id']},'include':[{'model':db[_0x573365],'as':'Account','attributes':['id','name',_0x4c7b('0xf2')]},{'model':db[_0x4c7b('0xe7')],'as':_0x4c7b('0xf3'),'attributes':['id',_0x4c7b('0x1f'),_0x4c7b('0xe8')]},{'model':db[_0x4c7b('0x7e')],'as':'Tags','attributes':['id',_0x4c7b('0x1f'),_0x4c7b('0x68')],'through':{'attributes':[]}}],'order':[[_0x4c7b('0xe5'),_0x4c7b('0xe9')]]};if(_0x4425ea[_0x4c7b('0x2d')][_0x4c7b('0xda')]){_0x402968[_0x4c7b('0x5d')][_0x4c7b('0xe5')]={'$gte':_0x242017[_0x4c7b('0x3d')],'$lte':_0x242017['to']};}switch(_0x12c4b3){case _0x4c7b('0xd0'):_0x402968['attributes'][_0x4c7b('0x62')](_0x4c7b('0xf4'),'customerIp',_0x4c7b('0xf5'),_0x4c7b('0xf6'),'osName',_0x4c7b('0xf7'),'ratingType',_0x4c7b('0xf8'),_0x4c7b('0xf9'));break;case _0x4c7b('0xfa'):_0x402968[_0x4c7b('0x80')][_0x4c7b('0x62')](_0x4c7b('0xfb'),_0x4c7b('0xfc'));break;case'openchannel':_0x402968[_0x4c7b('0x80')]['push'](_0x4c7b('0xfd'),'threadId');break;}return db[_[_0x4c7b('0xea')](_0x12c4b3)+_0x4c7b('0xfe')][_0x4c7b('0xff')](_0x402968)[_0x4c7b('0x1b')](function(_0x4ee251){_0x58bcfc[_0x4c7b('0x17')]+=_0x4ee251[_0x4c7b('0x17')];return _[_0x4c7b('0x6f')](_0x4ee251['rows'],function(_0x2a76ec){var _0x12f584=_0x2a76ec['get']({'plain':!![]});_0x12f584[_0x4c7b('0xd7')]=_0x12c4b3;if(_0x12f584[_0x4c7b('0xf3')]){_0x12f584[_0x4c7b('0xf3')]={'id':_0x12f584[_0x4c7b('0xf3')]['id'],'name':_0x12f584[_0x4c7b('0xf3')][_0x4c7b('0x1f')],'fullname':_0x12f584[_0x4c7b('0xf3')][_0x4c7b('0xe8')]};}return _0x12f584;});});}});return Promise[_0x4c7b('0x64')](_0x5553e7);})[_0x4c7b('0x1b')](function(_0x16958c){return _(_0x16958c)['flatten']()[_0x4c7b('0x100')](_0x4c7b('0xe5'))['reverse']()[_0x4c7b('0x101')]();})[_0x4c7b('0x1b')](function(_0x56a454){_0x58bcfc['rows']=_0xc2fda0[_0x4c7b('0x15')]?_0x56a454[_0x4c7b('0x102')](_0xc2fda0['offset'],_0xc2fda0[_0x4c7b('0x14')]+_0xc2fda0['limit']):_0x56a454;return _0x58bcfc;})[_0x4c7b('0x1b')](respondWithFilteredResult(_0x5b84c9,_0xc2fda0))[_0x4c7b('0x26')](handleError(_0x5b84c9,null));};
\ No newline at end of file
+var _0x5b25=['from','get','mergeWith','isArray','join','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','CmHopperHistory','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappMessage','create','isNil','dialTimezone','utcOffset','additionalPhones','bulkCreate','each','duplicates','$or','push','where','ListId','spread','hasOwnProperty','all','show','params','Tag','Tags','color','tag','CmContactHasItem','Phones','ContactItemType','ItemType','sequelize','literal','$and','omit','map','format','cf_%d','timezones','isEmpty','table','phone','getTags','findOne','rawAttributes','intersection','model','fields','attributes','order','sort','filters','pick','filter','merge','options','nolimit','setTags','ids','setAdditionalPhones','OrderBy','item_types','items','ItemTypeId','description','contact\x20phone\x20exists','PHONE','CmHopperAdditionalPhone','`ItemType`.OrderBy','CmHopperId','getAdditionalPhones','duplicateAdditionalPhones','fromContactId','CmContactId','toContactId','getHoppers','ContactId','count','includeAll','include','rows','getHopperFinals','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','split','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','root','server/files/tmp','filename','chmodSync','child_process','fork','socket_timestamp','File\x20uploaded\x20correctly!','pid','upload','createReadStream','file','parse','import','User','agent','binding','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','exit','error\x20child\x20process','importUpdates','../../components/import/cm/csvUpdates','mail','chat','openchannel','fax','whatsapp','-createdAt','resolve','channel','toLowerCase','Invalid\x20channel','range','isValid','Invalid\x20date\x20for\x20range\x20from\x20filter','Invalid\x20date\x20for\x20range\x20to\x20filter','Invalid\x20createdAt\x20filter','voice','uniqueid','source','destination','callerid','endtime','createdAt','userDisposition','userSecondDisposition','UserId','fullname','alias','DESC','startCase','Website','Account','closed','note','disposition','thirdDisposition','key','browserName','customerIp','customerPort','deviceModel','osName','ratingMessage','ratingType','ratingValue','referer','subject','substatus','externalUrl','threadId','Interaction','Owner','flatten','sortBy','reverse','value','slice','moment','util','path','lodash','squel','ioredis','../../components/contacts','../../components/parsers/qs','../../config/logger','api','../../config/environment/shared','../../mysqldb','redis','defaults','localhost','./cmContact.socket','register','json','offset','undefined','limit','status','set','Content-Range','update','then','destroy','end','error','stack','name','send','index','findAll','query','user','find','catch','CmContact','describe','tags','keys','startsWith','cf_','columnName','analytics','CmCustomField','length','displayName','values','info','Custom\x20field\x20%s\x20not\x20found\x20on\x20cm_contacts\x20table','forEach','body'];(function(_0x539277,_0x2ea1dc){var _0x2ac9c7=function(_0x191bac){while(--_0x191bac){_0x539277['push'](_0x539277['shift']());}};_0x2ac9c7(++_0x2ea1dc);}(_0x5b25,0xc9));var _0x55b2=function(_0x2a0421,_0x2530ae){_0x2a0421=_0x2a0421-0x0;var _0x2fd8de=_0x5b25[_0x2a0421];return _0x2fd8de;};'use strict';var moment=require(_0x55b2('0x0'));var BPromise=require('bluebird');var util=require(_0x55b2('0x1'));var path=require(_0x55b2('0x2'));var fs=require('fs');var _=require(_0x55b2('0x3'));var squel=require(_0x55b2('0x4'));var Papa=require('papaparse');var Redis=require(_0x55b2('0x5'));var contacts=require(_0x55b2('0x6'));var qs=require(_0x55b2('0x7'));var logger=require(_0x55b2('0x8'))(_0x55b2('0x9'));var config=require('../../config/environment');var shared=require(_0x55b2('0xa'));var db=require(_0x55b2('0xb'))['db'];config[_0x55b2('0xc')]=_[_0x55b2('0xd')](config[_0x55b2('0xc')],{'host':_0x55b2('0xe'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x55b2('0xc')]));require(_0x55b2('0xf'))[_0x55b2('0x10')](socket);function respondWithResult(_0x3b51f4,_0x1ad0b2){_0x1ad0b2=_0x1ad0b2||0xc8;return function(_0x103ece){if(_0x103ece){return _0x3b51f4['status'](_0x1ad0b2)[_0x55b2('0x11')](_0x103ece);}};}function respondWithFilteredResult(_0x330c00,_0x16c00c){return function(_0x2d1488){if(_0x2d1488){var _0x483ef=typeof _0x16c00c[_0x55b2('0x12')]===_0x55b2('0x13')&&typeof _0x16c00c[_0x55b2('0x14')]===_0x55b2('0x13');var _0x28664a=_0x2d1488['count'];var _0x27d3d4=_0x483ef?0x0:_0x16c00c[_0x55b2('0x12')];var _0xbbd47d=_0x483ef?_0x2d1488['count']:_0x16c00c['offset']+_0x16c00c['limit'];var _0x2dd24d;if(_0xbbd47d>=_0x28664a){_0xbbd47d=_0x28664a;_0x2dd24d=0xc8;}else{_0x2dd24d=0xce;}_0x330c00[_0x55b2('0x15')](_0x2dd24d);return _0x330c00[_0x55b2('0x16')](_0x55b2('0x17'),_0x27d3d4+'-'+_0xbbd47d+'/'+_0x28664a)[_0x55b2('0x11')](_0x2d1488);}return null;};}function saveUpdates(_0x1fa58f){return function(_0x87920){if(_0x87920){return _0x87920[_0x55b2('0x18')](_0x1fa58f)[_0x55b2('0x19')](function(_0x503f54){return _0x503f54;});}return null;};}function removeEntity(_0xb4c097){return function(_0x645aff){if(_0x645aff){return _0x645aff[_0x55b2('0x1a')]()['then'](function(){_0xb4c097[_0x55b2('0x15')](0xcc)[_0x55b2('0x1b')]();});}};}function handleEntityNotFound(_0x14e5e9){return function(_0x53e25e){if(!_0x53e25e){_0x14e5e9['sendStatus'](0x194);}return _0x53e25e;};}function handleError(_0x1b13fa,_0x444245){_0x444245=_0x444245||0x1f4;return function(_0x48f7c4){logger[_0x55b2('0x1c')](_0x48f7c4[_0x55b2('0x1d')]);if(_0x48f7c4[_0x55b2('0x1e')]){delete _0x48f7c4['name'];}_0x1b13fa['status'](_0x444245)[_0x55b2('0x1f')](_0x48f7c4);};}exports[_0x55b2('0x20')]=function(_0x4ad2ea,_0x39807f){var _0x13fbb0={};return contacts['describe']()[_0x55b2('0x19')](function(_0xa1f013){_0x13fbb0=qs['getOptions'](_0xa1f013,_0x4ad2ea);return contacts[_0x55b2('0x21')](_0x4ad2ea[_0x55b2('0x22')],_0x4ad2ea[_0x55b2('0x23')],_0x13fbb0,_0xa1f013);})[_0x55b2('0x19')](respondWithFilteredResult(_0x39807f,_0x13fbb0))['catch'](handleError(_0x39807f,null));};exports['destroy']=function(_0x37af3b,_0x12a375){return db['CmContact'][_0x55b2('0x24')]({'where':{'id':_0x37af3b['params']['id']}})[_0x55b2('0x19')](handleEntityNotFound(_0x12a375,null))[_0x55b2('0x19')](removeEntity(_0x12a375,null))[_0x55b2('0x25')](handleError(_0x12a375,null));};exports['describe']=function(_0x1a1d99,_0x4594c8){return db[_0x55b2('0x26')][_0x55b2('0x27')]()[_0x55b2('0x19')](function(_0x2d229e){delete _0x2d229e[_0x55b2('0x28')];for(var _0x1ea3d4=0x0;_0x1ea3d4<Object[_0x55b2('0x29')](_0x2d229e)['length'];_0x1ea3d4++){var _0x50155a=Object['keys'](_0x2d229e)[_0x1ea3d4];if(!_[_0x55b2('0x2a')](_0x50155a,_0x55b2('0x2b'))){_0x2d229e[_0x50155a][_0x55b2('0x2c')]=_0x50155a;_0x2d229e[_0x50155a]['displayName']=_0x50155a;}}return _0x2d229e;})[_0x55b2('0x19')](function(_0x533071){var _0x25839b={'where':Boolean(_0x1a1d99[_0x55b2('0x22')][_0x55b2('0x2d')])===!![]?undefined:{'$or':[{'ListId':_0x1a1d99[_0x55b2('0x22')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x55b2('0x2e')][_0x55b2('0x21')](_0x25839b)[_0x55b2('0x19')](function(_0x428288){for(var _0x4709a2=0x0;_0x4709a2<_0x428288[_0x55b2('0x2f')];_0x4709a2++){var _0x5b822a=_0x55b2('0x2b')+_0x428288[_0x4709a2]['id'];if(_0x533071[_0x5b822a]){_0x533071[_0x5b822a][_0x55b2('0x2c')]=_0x5b822a;_0x533071[_0x5b822a][_0x55b2('0x30')]=_0x428288[_0x4709a2]['alias'];_0x533071[_0x5b822a]['custom']={'type':_0x428288[_0x4709a2]['type'],'values':_0x428288[_0x4709a2][_0x55b2('0x31')]};}else{logger[_0x55b2('0x32')](_0x55b2('0x33'),_0x5b822a);}}Object[_0x55b2('0x29')](_0x533071)[_0x55b2('0x34')](function(_0x5db6e5){if(!_0x533071[_0x5db6e5]['hasOwnProperty'](_0x55b2('0x2c'))){delete _0x533071[_0x5db6e5];}});return _0x533071;});})['then'](respondWithResult(_0x4594c8,null))[_0x55b2('0x25')](handleError(_0x4594c8,null));};exports['merge']=function(_0x31d9a1,_0xaafd4e){var _0x3b5c57;var _0x5d6dce;var _0x225d78;if(_0x31d9a1[_0x55b2('0x35')]['id']){delete _0x31d9a1['body']['id'];}return db[_0x55b2('0x26')][_0x55b2('0x21')]({'where':{'id':[_0x31d9a1['body']['to'],_0x31d9a1[_0x55b2('0x35')][_0x55b2('0x36')]]}})[_0x55b2('0x19')](function(_0x375402){if(_0x375402){if(_0x375402[_0x55b2('0x2f')]!==0x2){return null;}_0x375402[0x0]=_0x375402[0x0][_0x55b2('0x37')]({'plain':!![]});_0x375402[0x1]=_0x375402[0x1][_0x55b2('0x37')]({'plain':!![]});delete _0x375402[0x0]['id'];delete _0x375402[0x1]['id'];return _[_0x55b2('0x38')](_0x375402[0x0],_0x375402[0x1],function(_0x1853fc,_0x145d50){if(Array[_0x55b2('0x39')](_0x145d50)&&!_0x145d50[_0x55b2('0x2f')]){return _0x1853fc;}else if(!_0x145d50){return _0x1853fc;}});}})[_0x55b2('0x19')](handleEntityNotFound(_0xaafd4e,null))[_0x55b2('0x19')](function(_0x5e2cc6){if(_0x5e2cc6){if(_0x5e2cc6[_0x55b2('0x28')]&&_[_0x55b2('0x39')](_0x5e2cc6['tags'])){_0x5e2cc6[_0x55b2('0x28')]=_0x5e2cc6[_0x55b2('0x28')][_0x55b2('0x3a')]();}logger[_0x55b2('0x32')]('[CmContact][merge]\x20to\x20%s\x20from\x20%s',_0x31d9a1['body']['to'],_0x31d9a1['body'][_0x55b2('0x36')]);return db[_0x55b2('0x3b')]['destroy']({'where':{'ContactId':[_0x31d9a1[_0x55b2('0x35')]['to'],_0x31d9a1[_0x55b2('0x35')][_0x55b2('0x36')]]}})[_0x55b2('0x19')](function(_0x25d321){logger[_0x55b2('0x32')](_0x55b2('0x3c'),_0x25d321);return db[_0x55b2('0x3d')]['destroy']({'where':{'ContactId':[_0x31d9a1['body']['to'],_0x31d9a1['body'][_0x55b2('0x36')]]}})['then'](function(_0x3f6278){logger[_0x55b2('0x32')](_0x55b2('0x3e'),_0x3f6278);return db['CmContact']['create'](_0x5e2cc6);});});}})[_0x55b2('0x19')](function(_0x23f8f3){if(_0x23f8f3){_0x3b5c57=_0x23f8f3;_0x5d6dce={'ContactId':_0x3b5c57['id']};_0x225d78={'where':{'ContactId':[_0x31d9a1['body']['to'],_0x31d9a1['body']['from']]}};return db[_0x55b2('0x3f')]['update'](_0x5d6dce,_0x225d78);}})[_0x55b2('0x19')](function(){if(_0x3b5c57){return db[_0x55b2('0x40')]['update'](_0x5d6dce,_0x225d78);}})[_0x55b2('0x19')](function(){if(_0x3b5c57){return db[_0x55b2('0x41')][_0x55b2('0x18')](_0x5d6dce,_0x225d78);}})[_0x55b2('0x19')](function(){if(_0x3b5c57){return db[_0x55b2('0x42')][_0x55b2('0x18')](_0x5d6dce,_0x225d78);}})[_0x55b2('0x19')](function(){if(_0x3b5c57){return db['MailMessage'][_0x55b2('0x18')](_0x5d6dce,_0x225d78);}})[_0x55b2('0x19')](function(){if(_0x3b5c57){return db[_0x55b2('0x42')]['update'](_0x5d6dce,_0x225d78);}})[_0x55b2('0x19')](function(){if(_0x3b5c57){return db[_0x55b2('0x43')][_0x55b2('0x18')](_0x5d6dce,_0x225d78);}})[_0x55b2('0x19')](function(){if(_0x3b5c57){return db[_0x55b2('0x44')][_0x55b2('0x18')](_0x5d6dce,_0x225d78);}})['then'](function(){if(_0x3b5c57){return db[_0x55b2('0x45')][_0x55b2('0x18')](_0x5d6dce,_0x225d78);}})['then'](function(){if(_0x3b5c57){return db[_0x55b2('0x46')]['update'](_0x5d6dce,_0x225d78);}})['then'](function(){if(_0x3b5c57){return db[_0x55b2('0x47')]['update'](_0x5d6dce,_0x225d78);}})['then'](function(){if(_0x3b5c57){return db[_0x55b2('0x48')][_0x55b2('0x18')](_0x5d6dce,_0x225d78);}})['then'](function(){if(_0x3b5c57){return db[_0x55b2('0x49')][_0x55b2('0x18')](_0x5d6dce,_0x225d78);}})[_0x55b2('0x19')](function(){if(_0x3b5c57){return db['CmContactHasItem'][_0x55b2('0x18')]({'CmContactId':_0x3b5c57['id']},{'where':{'CmContactId':[_0x31d9a1[_0x55b2('0x35')]['to'],_0x31d9a1[_0x55b2('0x35')][_0x55b2('0x36')]]}});}})['then'](function(){if(_0x3b5c57){return db[_0x55b2('0x4a')][_0x55b2('0x18')](_0x5d6dce,_0x225d78);}})[_0x55b2('0x19')](function(){if(_0x3b5c57){return db[_0x55b2('0x4b')][_0x55b2('0x18')](_0x5d6dce,_0x225d78);}})[_0x55b2('0x19')](function(){if(_0x3b5c57){return db['ReportAgentPreview']['update'](_0x5d6dce,_0x225d78);}})[_0x55b2('0x19')](function(){if(_0x3b5c57){return db[_0x55b2('0x4c')][_0x55b2('0x18')](_0x5d6dce,_0x225d78);}})['then'](function(){if(_0x3b5c57){return db[_0x55b2('0x4d')][_0x55b2('0x18')](_0x5d6dce,_0x225d78);}})[_0x55b2('0x19')](function(){if(_0x3b5c57){return db[_0x55b2('0x4e')][_0x55b2('0x18')](_0x5d6dce,_0x225d78);}})['then'](function(){if(_0x3b5c57){return db[_0x55b2('0x4f')][_0x55b2('0x18')](_0x5d6dce,_0x225d78);}})[_0x55b2('0x19')](function(){if(_0x3b5c57){return db[_0x55b2('0x50')]['update'](_0x5d6dce,_0x225d78);}})[_0x55b2('0x19')](function(){if(_0x3b5c57){return db['SmsQueueReport'][_0x55b2('0x18')](_0x5d6dce,_0x225d78);}})[_0x55b2('0x19')](function(){if(_0x3b5c57){return db[_0x55b2('0x51')][_0x55b2('0x18')](_0x5d6dce,_0x225d78);}})['then'](function(){if(_0x3b5c57){return db[_0x55b2('0x52')][_0x55b2('0x18')](_0x5d6dce,_0x225d78);}})[_0x55b2('0x19')](function(){if(_0x3b5c57){return db[_0x55b2('0x53')]['update'](_0x5d6dce,_0x225d78);}})[_0x55b2('0x19')](function(){if(_0x3b5c57){return db['WhatsappQueueReport'][_0x55b2('0x18')](_0x5d6dce,_0x225d78);}})['then'](function(){if(_0x3b5c57){return db[_0x55b2('0x26')][_0x55b2('0x1a')]({'where':{'id':[_0x31d9a1[_0x55b2('0x35')]['to'],_0x31d9a1['body'][_0x55b2('0x36')]]}});}})[_0x55b2('0x19')](function(){if(_0x3b5c57){return _0x3b5c57;}})[_0x55b2('0x19')](respondWithResult(_0xaafd4e,null))[_0x55b2('0x25')](handleError(_0xaafd4e,null));};exports[_0x55b2('0x54')]=function(_0x52548b,_0x5b58ac){return db['CmContact'][_0x55b2('0x27')]()[_0x55b2('0x19')](function(_0x4c6fb4){if(_0x52548b[_0x55b2('0x35')][_0x55b2('0x28')]&&_['isArray'](_0x52548b[_0x55b2('0x35')][_0x55b2('0x28')])){if(_0x52548b[_0x55b2('0x35')][_0x55b2('0x28')][_0x55b2('0x2f')]){_0x52548b['body'][_0x55b2('0x28')]=_0x52548b[_0x55b2('0x35')][_0x55b2('0x28')][_0x55b2('0x3a')](';')+';';}else{_0x52548b[_0x55b2('0x35')]['tags']=null;}}else{_0x52548b[_0x55b2('0x35')][_0x55b2('0x28')]=null;}if(!_[_0x55b2('0x55')](_0x52548b[_0x55b2('0x35')][_0x55b2('0x56')])){var _0x3e1131=_0x52548b[_0x55b2('0x35')][_0x55b2('0x56')];if(!_[_0x55b2('0x55')](shared['timezones'][_0x3e1131]))_0x52548b['body'][_0x55b2('0x57')]=shared['timezones'][_0x3e1131]['utcOffset'];}return db[_0x55b2('0x26')][_0x55b2('0x54')](_0x52548b['body'],{'fields':_[_0x55b2('0x29')](_0x4c6fb4),'raw':!![]});})['then'](function(_0x3c412f){if(_0x52548b['body']['additionalPhones']){return insertAdditionalPhones(_0x3c412f,_0x52548b[_0x55b2('0x35')][_0x55b2('0x58')]);}else{return _0x3c412f;}})[_0x55b2('0x19')](respondWithResult(_0x5b58ac,0xc9))['catch'](handleError(_0x5b58ac,null));};exports[_0x55b2('0x59')]=function(_0x1da7b7,_0x182fd6){var _0x3ae698=0x0;var _0x4d8771=0x0;var _0x37b2f7=0x0;var _0x44fe2c=[];return db[_0x55b2('0x26')]['describe']()[_0x55b2('0x19')](function(_0x2bb5f1){return BPromise[_0x55b2('0x5a')](_0x1da7b7['body'],function(_0x4fab68){var _0x1f2116={'where':{'$or':[]},'defaults':_0x4fab68,'fields':_[_0x55b2('0x29')](_0x2bb5f1),'raw':!![]};if(_0x4fab68[_0x55b2('0x5b')]){for(var _0x2de2a8=0x0;_0x2de2a8<_0x4fab68['duplicates'][_0x55b2('0x2f')];_0x2de2a8++){var _0x2a3bbf={};_0x2a3bbf[_0x4fab68[_0x55b2('0x5b')][_0x2de2a8]]=_0x4fab68[_0x4fab68[_0x55b2('0x5b')][_0x2de2a8]];_0x1f2116['where'][_0x55b2('0x5c')][_0x55b2('0x5d')](_0x2a3bbf);}_0x1f2116[_0x55b2('0x5e')][_0x55b2('0x5f')]=_0x4fab68[_0x55b2('0x5f')];}return db[_0x55b2('0x26')]['findOrCreate'](_0x1f2116)[_0x55b2('0x60')](function(_0x332e36,_0x3421a6){if(_0x3421a6){if(_0x4fab68[_0x55b2('0x61')](_0x55b2('0x58'))){_0x44fe2c[_0x55b2('0x5d')]({'contact':_0x332e36,'additionalPhones':_0x4fab68['additionalPhones']});}_0x3ae698++;}else{_0x37b2f7++;}})[_0x55b2('0x25')](function(){_0x4d8771++;});});})[_0x55b2('0x19')](function(_0x57ef9f){if(_0x57ef9f){if(_0x44fe2c[_0x55b2('0x2f')]>0x0){return new Promise(function(_0x7029f1){var _0x249b29=[];for(var _0x1bfa0c=0x0;_0x1bfa0c<_0x44fe2c[_0x55b2('0x2f')];_0x1bfa0c++){_0x249b29['push'](insertAdditionalPhones(_0x44fe2c[_0x1bfa0c]['contact'],_0x44fe2c[_0x1bfa0c]['additionalPhones']));}Promise[_0x55b2('0x62')](_0x249b29)['then'](function(){_0x7029f1(0x1);});})[_0x55b2('0x19')](function(){return{'success':_0x3ae698,'failure':_0x4d8771,'duplicates':_0x37b2f7};});}else{return{'success':_0x3ae698,'failure':_0x4d8771,'duplicates':_0x37b2f7};}}})['then'](respondWithResult(_0x182fd6,0xc9))['catch'](handleError(_0x182fd6,null));};exports[_0x55b2('0x63')]=function(_0x3714f3,_0x448e72){var _0x4c6c9e;return db[_0x55b2('0x26')]['describe']()[_0x55b2('0x19')](function(_0x7dd127){return db[_0x55b2('0x26')]['find']({'where':{'id':_0x3714f3[_0x55b2('0x64')]['id']},'include':[{'model':db[_0x55b2('0x65')],'as':_0x55b2('0x66'),'attributes':['id','name',_0x55b2('0x67')],'required':_0x3714f3[_0x55b2('0x22')][_0x55b2('0x68')]?!![]:![]},{'model':db[_0x55b2('0x69')],'as':_0x55b2('0x6a'),'where':{'CmContactId':_0x3714f3[_0x55b2('0x64')]['id']},'required':![],'include':[{'model':db[_0x55b2('0x6b')],'as':_0x55b2('0x6c')}]}],'order':[db[_0x55b2('0x6d')][_0x55b2('0x6e')]('Phones.OrderBy')],'attributes':_[_0x55b2('0x29')](_0x7dd127)});})[_0x55b2('0x19')](function(_0x4a6213){if(!_[_0x55b2('0x55')](_0x4a6213)){_0x4c6c9e=_0x4a6213[_0x55b2('0x37')]({'plain':!![]});var _0x571397={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x4a6213&&_0x4a6213['ListId']){if(_0x4a6213[_0x55b2('0x5f')]){_0x571397[_0x55b2('0x5e')][_0x55b2('0x6f')][_0x55b2('0x5d')]({'ListId':{'$ne':_0x4a6213[_0x55b2('0x5f')]}});}}return db[_0x55b2('0x2e')][_0x55b2('0x21')](_0x571397);}})[_0x55b2('0x19')](function(_0x4c10db){if(!_[_0x55b2('0x55')](_0x4c10db)){return _[_0x55b2('0x70')](_0x4c6c9e,_[_0x55b2('0x71')](_0x4c10db,function(_0x16cc5b){return util[_0x55b2('0x72')](_0x55b2('0x73'),_0x16cc5b['id']);}));}})[_0x55b2('0x19')](handleEntityNotFound(_0x448e72,null))[_0x55b2('0x19')](respondWithResult(_0x448e72,null))[_0x55b2('0x25')](handleError(_0x448e72,null));};exports['update']=function(_0x14ef7b,_0x23593d){var _0x10542e;if(_0x14ef7b[_0x55b2('0x35')]['id']){delete _0x14ef7b['body']['id'];}if(!_[_0x55b2('0x55')](_0x14ef7b[_0x55b2('0x35')][_0x55b2('0x56')])){var _0x5aa0b6=_0x14ef7b[_0x55b2('0x35')][_0x55b2('0x56')];if(!_[_0x55b2('0x55')](shared[_0x55b2('0x74')][_0x5aa0b6]))_0x14ef7b[_0x55b2('0x35')][_0x55b2('0x57')]=shared[_0x55b2('0x74')][_0x5aa0b6][_0x55b2('0x57')];}return db[_0x55b2('0x26')]['find']({'where':{'id':_0x14ef7b['params']['id']}})['then'](handleEntityNotFound(_0x23593d,null))[_0x55b2('0x19')](saveUpdates(_0x14ef7b['body'],null))[_0x55b2('0x19')](function(_0x1189f){_0x10542e=_0x1189f;var _0x577fea={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x1189f&&_0x1189f[_0x55b2('0x5f')]){if(_0x1189f[_0x55b2('0x5f')]){_0x577fea[_0x55b2('0x5e')]['$and'][_0x55b2('0x5d')]({'ListId':{'$ne':_0x1189f[_0x55b2('0x5f')]}});}}return db[_0x55b2('0x2e')][_0x55b2('0x21')](_0x577fea);})['then'](function(_0x3638a3){if(_0x3638a3){return _['omit'](_['pickBy'](_0x14ef7b[_0x55b2('0x35')],function(_0x38dc34,_0x48f935){return _['startsWith'](_0x48f935,_0x55b2('0x2b'));}),_[_0x55b2('0x71')](_0x3638a3,function(_0x35f54e){return util[_0x55b2('0x72')](_0x55b2('0x73'),_0x35f54e['id']);}));}})[_0x55b2('0x19')](function(_0x2d64a4){if(_0x2d64a4&&!_[_0x55b2('0x75')](_0x2d64a4)){var _0x529097=squel[_0x55b2('0x18')]()[_0x55b2('0x76')]('cm_contacts')['setFields'](_0x2d64a4)[_0x55b2('0x5e')]('id\x20=\x20?',_0x14ef7b[_0x55b2('0x64')]['id'])['toParam']();return db[_0x55b2('0x6d')]['query'](_0x529097['text'],{'replacements':_0x529097['values']});}})[_0x55b2('0x19')](function(){if(_0x14ef7b[_0x55b2('0x35')][_0x55b2('0x77')]&&_0x10542e){return db[_0x55b2('0x3b')][_0x55b2('0x18')]({'phone':_0x14ef7b[_0x55b2('0x35')]['phone'],'OrderBy':0x0},{'where':{'ContactId':_0x10542e['id']}});}})[_0x55b2('0x19')](function(){return _0x10542e;})['then'](respondWithResult(_0x23593d,null))[_0x55b2('0x25')](handleError(_0x23593d,null));};exports[_0x55b2('0x78')]=function(_0x15bb04,_0x5adb97){var _0x997ef9={};var _0x16b14f={};var _0x4f8f75;var _0x544659;return db[_0x55b2('0x26')][_0x55b2('0x79')]({'where':{'id':_0x15bb04[_0x55b2('0x64')]['id']}})['then'](handleEntityNotFound(_0x5adb97,null))[_0x55b2('0x19')](function(_0x4608a4){if(_0x4608a4){_0x4f8f75=_0x4608a4;_0x16b14f['model']=_['keys'](db[_0x55b2('0x65')][_0x55b2('0x7a')]);_0x16b14f[_0x55b2('0x22')]=_[_0x55b2('0x29')](_0x15bb04[_0x55b2('0x22')]);_0x16b14f['filters']=_[_0x55b2('0x7b')](_0x16b14f[_0x55b2('0x7c')],_0x16b14f[_0x55b2('0x22')]);_0x997ef9['attributes']=_[_0x55b2('0x7b')](_0x16b14f['model'],qs[_0x55b2('0x7d')](_0x15bb04[_0x55b2('0x22')][_0x55b2('0x7d')]));_0x997ef9[_0x55b2('0x7e')]=_0x997ef9[_0x55b2('0x7e')][_0x55b2('0x2f')]?_0x997ef9[_0x55b2('0x7e')]:_0x16b14f[_0x55b2('0x7c')];_0x997ef9[_0x55b2('0x7f')]=qs[_0x55b2('0x80')](_0x15bb04[_0x55b2('0x22')][_0x55b2('0x80')]);_0x997ef9[_0x55b2('0x5e')]=qs[_0x55b2('0x81')](_[_0x55b2('0x82')](_0x15bb04[_0x55b2('0x22')],_0x16b14f['filters']));if(_0x15bb04['query'][_0x55b2('0x83')]){_0x997ef9[_0x55b2('0x5e')]=_[_0x55b2('0x84')](_0x997ef9[_0x55b2('0x5e')],{'$or':_[_0x55b2('0x71')](_0x997ef9[_0x55b2('0x7e')],function(_0x2f3133){var _0x2c502d={};_0x2c502d[_0x2f3133]={'$like':'%'+_0x15bb04[_0x55b2('0x22')]['filter']+'%'};return _0x2c502d;})});}_0x997ef9=_[_0x55b2('0x84')]({},_0x997ef9,_0x15bb04[_0x55b2('0x85')]);return _0x4f8f75[_0x55b2('0x78')](_0x997ef9);}})[_0x55b2('0x19')](function(_0x29067a){if(_0x29067a){_0x544659=_0x29067a[_0x55b2('0x2f')];if(!_0x15bb04[_0x55b2('0x22')][_0x55b2('0x61')](_0x55b2('0x86'))){_0x997ef9[_0x55b2('0x14')]=qs[_0x55b2('0x14')](_0x15bb04[_0x55b2('0x22')]['limit']);_0x997ef9['offset']=qs[_0x55b2('0x12')](_0x15bb04['query']['offset']);}return _0x4f8f75[_0x55b2('0x78')](_0x997ef9);}})[_0x55b2('0x19')](function(_0x1cedd1){if(_0x1cedd1){return _0x1cedd1?{'count':_0x544659,'rows':_0x1cedd1}:null;}})[_0x55b2('0x19')](respondWithResult(_0x5adb97,null))[_0x55b2('0x25')](handleError(_0x5adb97,null));};exports[_0x55b2('0x87')]=function(_0x19b7d4,_0x18912c){if(_0x19b7d4[_0x55b2('0x35')]['id']){delete _0x19b7d4['body']['id'];}return db[_0x55b2('0x26')]['findOne']({'where':{'id':_0x19b7d4[_0x55b2('0x64')]['id']}})['then'](handleEntityNotFound(_0x18912c,null))[_0x55b2('0x19')](function(_0x48dabd){if(_0x48dabd){return _0x48dabd['setTags'](_0x19b7d4[_0x55b2('0x35')][_0x55b2('0x88')]||[]);}return null;})['then'](respondWithResult(_0x18912c,null))[_0x55b2('0x25')](handleError(_0x18912c,null));};exports[_0x55b2('0x89')]=function(_0x492e4b,_0x571317){var _0x59ac9a=[];_0x59ac9a[_0x55b2('0x5d')](addAdditionalPhones(_0x492e4b[_0x55b2('0x35')]));Promise[_0x55b2('0x62')](_0x59ac9a)[_0x55b2('0x19')](function(){_0x59ac9a=[];_0x59ac9a[_0x55b2('0x5d')](deleteCmHopperPhones(_0x492e4b[_0x55b2('0x35')]['id']));_0x59ac9a['push'](addCmHopperPhones(_0x492e4b['body']['id']));Promise[_0x55b2('0x62')](_0x59ac9a)[_0x55b2('0x19')](function(){return[0x1];})[_0x55b2('0x19')](respondWithResult(_0x571317,null));});};function addAdditionalPhones(_0x31dba7){var _0x5e20b1;return new Promise(function(_0x5f2e83){return db[_0x55b2('0x69')]['destroy']({'where':{'CmContactId':_0x31dba7['id']}})[_0x55b2('0x19')](function(){db[_0x55b2('0x6b')][_0x55b2('0x21')]({'raw':!![],'attributes':['id',_0x55b2('0x8a')]})[_0x55b2('0x19')](function(_0x26e98b){var _0x1702b8=[];for(var _0x5edb8e=0x0;_0x5edb8e<_0x31dba7['items'][_0x55b2('0x2f')];_0x5edb8e++){var _0x56bd9e=_0x31dba7[_0x55b2('0x8b')]?_[_0x55b2('0x55')](_0x31dba7[_0x55b2('0x8b')][_0x5edb8e])?'':_0x31dba7['item_types'][_0x5edb8e]:_0x31dba7[_0x55b2('0x8c')][_0x5edb8e][_0x55b2('0x8d')]?_0x31dba7[_0x55b2('0x8c')][_0x5edb8e][_0x55b2('0x8d')]:'';var _0x53feeb=_[_0x55b2('0x55')](_0x31dba7['items'][_0x5edb8e]['description'])?'':_0x31dba7[_0x55b2('0x8c')][_0x5edb8e][_0x55b2('0x8e')];var _0x1386a9=_0x56bd9e+':'+_0x31dba7[_0x55b2('0x8c')][_0x5edb8e][_0x55b2('0x77')]+'§'+_0x53feeb;if(_['isNil'](_0x5e20b1))_0x5e20b1=_0x1386a9;else _0x5e20b1+=';'+_0x1386a9;var _0x1870f2=null;var _0x2df00f=null;if(_0x31dba7[_0x55b2('0x8b')]){if(!_[_0x55b2('0x55')](_0x31dba7[_0x55b2('0x8b')][_0x5edb8e])){_0x2df00f=_[_0x55b2('0x24')](_0x26e98b,function(_0x2667ab){return _0x2667ab['id']===_0x31dba7[_0x55b2('0x8b')][_0x5edb8e];});if(!_[_0x55b2('0x55')](_0x2df00f)){_0x1870f2=_0x2df00f[_0x55b2('0x8a')];}}}else{if(!_['isNil'](_0x31dba7[_0x55b2('0x8c')][_0x5edb8e])){_0x2df00f=_['find'](_0x26e98b,function(_0x268d59){return _0x268d59['id']===_0x31dba7['items'][_0x5edb8e][_0x55b2('0x8d')];});if(!_['isNil'](_0x2df00f)){_0x1870f2=_0x5edb8e;}}}if(_[_0x55b2('0x55')](_0x1870f2)){_0x1870f2=0x64;}_0x1702b8[_0x55b2('0x5d')](addAdditionalPhone(_0x31dba7['id'],_0x31dba7[_0x55b2('0x8c')][_0x5edb8e][_0x55b2('0x77')],_0x31dba7[_0x55b2('0x8b')]?_[_0x55b2('0x55')](_0x31dba7['item_types'][_0x5edb8e])?null:_0x31dba7[_0x55b2('0x8b')][_0x5edb8e]:_0x31dba7[_0x55b2('0x8c')][_0x5edb8e][_0x55b2('0x8d')]?_0x31dba7['items'][_0x5edb8e][_0x55b2('0x8d')]:null,_0x1870f2,_0x53feeb));}Promise[_0x55b2('0x62')](_0x1702b8)['then'](function(){db[_0x55b2('0x26')][_0x55b2('0x18')]({'AdditionalPhones':_0x5e20b1},{'where':{'id':_0x31dba7['id']}})[_0x55b2('0x19')](function(){_0x5f2e83(0x1);});});});});});}function addAdditionalPhone(_0x19d803,_0xf5b703,_0x5d58aa,_0x38066b,_0x1d8324){return db['CmContactHasItem'][_0x55b2('0x24')]({'where':{'CmContactId':_0x19d803,'item':_0xf5b703}})['then'](function(_0x5943f9){if(_0x5943f9)logger['info'](_0x55b2('0x8f'),_0x5943f9);else{db[_0x55b2('0x69')]['create']({'CmContactId':_0x19d803,'item':_0xf5b703,'ItemTypeId':_0x5d58aa,'OrderBy':_0x38066b,'ItemClass':_0x55b2('0x90'),'description':_0x1d8324});}});}function deleteCmHopperPhones(_0x5ad46e){return new Promise(function(_0xe6ded4){return db['CmHopper'][_0x55b2('0x21')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x5ad46e}})[_0x55b2('0x19')](function(_0x385634){db[_0x55b2('0x91')]['destroy']({'where':{'CmHopperId':{'$in':_[_0x55b2('0x71')](_0x385634,'id')}}});})[_0x55b2('0x19')](function(){_0xe6ded4(0x1);});});}function addCmHopperPhones(_0x103a1c){return new Promise(function(_0x1903d2){return db['CmHopper'][_0x55b2('0x21')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x103a1c}})[_0x55b2('0x19')](function(_0x595eb2){var _0x3dc589=[];_[_0x55b2('0x71')](_0x595eb2,function(_0x4be71c){_0x3dc589[_0x55b2('0x5d')](createCmHopperPhone(_0x103a1c,_0x4be71c['id']));});Promise[_0x55b2('0x62')](_0x3dc589)['then'](function(){_0x1903d2(0x1);});});});}function createCmHopperPhone(_0x32ff46,_0x18fdaf){return new Promise(function(_0x4b0ac5){db[_0x55b2('0x69')][_0x55b2('0x21')]({'raw':!![],'attributes':['item','OrderBy'],'where':{'CmContactId':_0x32ff46,'ItemClass':_0x55b2('0x90')},'include':[{'model':db['ContactItemType'],'attributes':['OrderBy'],'as':_0x55b2('0x6c')}],'order':[_0x55b2('0x8a'),db['sequelize'][_0x55b2('0x6e')](_0x55b2('0x92'))]})[_0x55b2('0x19')](function(_0x5d4592){var _0x5dd0b3=0x1;var _0x167bfe=_[_0x55b2('0x71')](_0x5d4592,function(_0x5b80fe){_0x5b80fe[_0x55b2('0x93')]=_0x18fdaf;_0x5b80fe[_0x55b2('0x77')]=_0x5b80fe['item'];_0x5b80fe[_0x55b2('0x8a')]=_0x5dd0b3;delete _0x5b80fe['ItemType.OrderBy'];_0x5dd0b3=_0x5dd0b3+0x1;return _0x5b80fe;});return db[_0x55b2('0x91')][_0x55b2('0x59')](_0x167bfe,{});})[_0x55b2('0x19')](function(){_0x4b0ac5(0x1);});});}function insertAdditionalPhones(_0x4c1a4c,_0x7d3f0c){return new Promise(function(_0xa8433d){var _0x4b78cd=[];for(var _0x39dcd6=0x0;_0x39dcd6<_0x7d3f0c['length'];_0x39dcd6++){var _0x431155=_0x7d3f0c[_0x39dcd6];_0x4b78cd['push'](parseContactItemType(_0x431155));}Promise[_0x55b2('0x62')](_0x4b78cd)['then'](function(){var _0x5d858a={'id':_0x4c1a4c['id'],'items':_0x7d3f0c};return addAdditionalPhones(_0x5d858a)[_0x55b2('0x19')](function(){return addCmHopperPhones(_0x4c1a4c['id']);});})[_0x55b2('0x19')](function(){_0xa8433d(_0x4c1a4c);});});}function parseContactItemType(_0x436e75){return new Promise(function(_0x127954){if(_0x436e75[_0x55b2('0x61')]('ItemTypeId')){_0x127954(_0x436e75);}else{return db['ContactItemType'][_0x55b2('0x24')]({'where':{'name':_0x436e75[_0x55b2('0x6c')]}})['then'](function(_0x4441c4){if(_['isNil'](_0x4441c4))_0x436e75[_0x55b2('0x8d')]=null;else _0x436e75[_0x55b2('0x8d')]=_0x4441c4['id'];_0x127954(_0x436e75);});}});}exports[_0x55b2('0x94')]=function(_0x4131a7,_0x5adaa2){return db['CmContactHasItem'][_0x55b2('0x21')]({'raw':!![],'where':{'CmContactId':_0x4131a7[_0x55b2('0x64')]['id'],'ItemClass':_0x55b2('0x90')},'include':[{'model':db[_0x55b2('0x6b')],'as':_0x55b2('0x6c')}],'order':[[_0x55b2('0x8a')],[db['sequelize'][_0x55b2('0x6e')](_0x55b2('0x92'))]]})[_0x55b2('0x19')](function(_0x216dd2){return _0x216dd2;})[_0x55b2('0x19')](respondWithResult(_0x5adaa2,null))[_0x55b2('0x25')](handleError(_0x5adaa2,null));};exports[_0x55b2('0x95')]=function(_0x27fe47,_0x1212e9){return db[_0x55b2('0x69')][_0x55b2('0x21')]({'raw':!![],'where':{'CmContactId':_0x27fe47['body'][_0x55b2('0x96')]}})[_0x55b2('0x19')](function(_0x45638c){var _0x4e125a=_[_0x55b2('0x71')](_0x45638c,function(_0x1d0d88){_0x1d0d88[_0x55b2('0x97')]=_0x27fe47[_0x55b2('0x35')]['toContactId'];return _0x1d0d88;});return db[_0x55b2('0x69')][_0x55b2('0x59')](_0x4e125a,{});})[_0x55b2('0x19')](function(){return addCmHopperPhones(_0x27fe47[_0x55b2('0x35')][_0x55b2('0x98')]);})[_0x55b2('0x19')](function(){return['ok'];})[_0x55b2('0x19')](respondWithResult(_0x1212e9,null))[_0x55b2('0x25')](handleError(_0x1212e9,null));};exports['rescheduleAdditionalPhones']=function(_0x30afd1,_0x5b3f3b){var _0x545679=[];_0x545679['push'](createCmHopperPhone(_0x30afd1[_0x55b2('0x35')]['id'],_0x30afd1['body']['hopperId']));Promise[_0x55b2('0x62')](_0x545679)['then'](function(){return[0x1];})[_0x55b2('0x19')](respondWithResult(_0x5b3f3b,null));};exports[_0x55b2('0x99')]=function(_0x27944a,_0x5253d3){var _0x52376f={'raw':![],'where':{}};var _0x190da1={};var _0x566cef={'count':0x0,'rows':[]};return db[_0x55b2('0x26')][_0x55b2('0x79')]({'where':{'id':_0x27944a[_0x55b2('0x64')]['id']}})[_0x55b2('0x19')](handleEntityNotFound(_0x5253d3,null))[_0x55b2('0x19')](function(_0x1ea232){if(_0x1ea232){_0x190da1[_0x55b2('0x7c')]=_[_0x55b2('0x29')](db[_0x55b2('0x3b')][_0x55b2('0x7a')]);_0x190da1[_0x55b2('0x22')]=_[_0x55b2('0x29')](_0x27944a[_0x55b2('0x22')]);_0x190da1[_0x55b2('0x81')]=_['intersection'](_0x190da1[_0x55b2('0x7c')],_0x190da1['query']);_0x52376f[_0x55b2('0x7e')]=_[_0x55b2('0x7b')](_0x190da1[_0x55b2('0x7c')],qs[_0x55b2('0x7d')](_0x27944a[_0x55b2('0x22')][_0x55b2('0x7d')]));_0x52376f[_0x55b2('0x7e')]=_0x52376f[_0x55b2('0x7e')][_0x55b2('0x2f')]?_0x52376f[_0x55b2('0x7e')]:_0x190da1['model'];if(!_0x27944a[_0x55b2('0x22')][_0x55b2('0x61')](_0x55b2('0x86'))){_0x52376f[_0x55b2('0x14')]=qs['limit'](_0x27944a['query'][_0x55b2('0x14')]);_0x52376f['offset']=qs[_0x55b2('0x12')](_0x27944a[_0x55b2('0x22')]['offset']);}_0x52376f[_0x55b2('0x7f')]=qs['sort'](_0x27944a['query'][_0x55b2('0x80')]);_0x52376f[_0x55b2('0x5e')]=qs['filters'](_[_0x55b2('0x82')](_0x27944a[_0x55b2('0x22')],_0x190da1[_0x55b2('0x81')]));_0x52376f[_0x55b2('0x5e')][_0x55b2('0x9a')]=_0x1ea232['id'];if(_0x27944a[_0x55b2('0x22')][_0x55b2('0x83')]){_0x52376f[_0x55b2('0x5e')]=_[_0x55b2('0x84')](_0x52376f[_0x55b2('0x5e')],{'$or':_[_0x55b2('0x71')](_0x52376f[_0x55b2('0x7e')],function(_0x572e70){var _0x34438b={};_0x34438b[_0x572e70]={'$like':'%'+_0x27944a['query'][_0x55b2('0x83')]+'%'};return _0x34438b;})});}_0x52376f=_['merge']({},_0x52376f,_0x27944a['options']);return db['CmHopper']['count']({'where':_0x52376f[_0x55b2('0x5e')]})[_0x55b2('0x19')](function(_0x17a571){_0x566cef[_0x55b2('0x9b')]=_0x17a571;if(_0x27944a[_0x55b2('0x22')][_0x55b2('0x9c')]){_0x52376f[_0x55b2('0x9d')]=[{'all':!![]}];}return db[_0x55b2('0x3b')][_0x55b2('0x21')](_0x52376f);})[_0x55b2('0x19')](function(_0x26af80){_0x566cef[_0x55b2('0x9e')]=_0x26af80;return _0x566cef;});}})[_0x55b2('0x19')](respondWithFilteredResult(_0x5253d3,_0x52376f))[_0x55b2('0x25')](handleError(_0x5253d3,null));};exports['getHopperHistories']=function(_0x10004b,_0x5c41e1){var _0x494f36={'raw':!![],'where':{}};var _0x59920a={};var _0x20bbb2={'count':0x0,'rows':[]};return db[_0x55b2('0x26')][_0x55b2('0x79')]({'where':{'id':_0x10004b['params']['id']}})[_0x55b2('0x19')](handleEntityNotFound(_0x5c41e1,null))['then'](function(_0x5de4b3){if(_0x5de4b3){_0x59920a[_0x55b2('0x7c')]=_[_0x55b2('0x29')](db[_0x55b2('0x4b')][_0x55b2('0x7a')]);_0x59920a[_0x55b2('0x22')]=_['keys'](_0x10004b[_0x55b2('0x22')]);_0x59920a[_0x55b2('0x81')]=_[_0x55b2('0x7b')](_0x59920a[_0x55b2('0x7c')],_0x59920a[_0x55b2('0x22')]);_0x494f36['attributes']=_[_0x55b2('0x7b')](_0x59920a[_0x55b2('0x7c')],qs['fields'](_0x10004b[_0x55b2('0x22')][_0x55b2('0x7d')]));_0x494f36[_0x55b2('0x7e')]=_0x494f36[_0x55b2('0x7e')]['length']?_0x494f36['attributes']:_0x59920a['model'];if(!_0x10004b['query'][_0x55b2('0x61')]('nolimit')){_0x494f36[_0x55b2('0x14')]=qs['limit'](_0x10004b[_0x55b2('0x22')][_0x55b2('0x14')]);_0x494f36[_0x55b2('0x12')]=qs[_0x55b2('0x12')](_0x10004b[_0x55b2('0x22')][_0x55b2('0x12')]);}_0x494f36[_0x55b2('0x7f')]=qs['sort'](_0x10004b['query'][_0x55b2('0x80')]);_0x494f36[_0x55b2('0x5e')]=qs[_0x55b2('0x81')](_['pick'](_0x10004b['query'],_0x59920a[_0x55b2('0x81')]));_0x494f36[_0x55b2('0x5e')][_0x55b2('0x9a')]=_0x5de4b3['id'];if(_0x10004b[_0x55b2('0x22')][_0x55b2('0x83')]){_0x494f36[_0x55b2('0x5e')]=_[_0x55b2('0x84')](_0x494f36[_0x55b2('0x5e')],{'$or':_['map'](_0x494f36[_0x55b2('0x7e')],function(_0x52a49b){var _0x206f35={};_0x206f35[_0x52a49b]={'$like':'%'+_0x10004b[_0x55b2('0x22')][_0x55b2('0x83')]+'%'};return _0x206f35;})});}_0x494f36=_['merge']({},_0x494f36,_0x10004b[_0x55b2('0x85')]);return db[_0x55b2('0x4b')][_0x55b2('0x9b')]({'where':_0x494f36[_0x55b2('0x5e')]})[_0x55b2('0x19')](function(_0x20afcb){_0x20bbb2[_0x55b2('0x9b')]=_0x20afcb;if(_0x10004b[_0x55b2('0x22')]['includeAll']){_0x494f36[_0x55b2('0x9d')]=[{'all':!![]}];}return db[_0x55b2('0x4b')][_0x55b2('0x21')](_0x494f36);})[_0x55b2('0x19')](function(_0x5cf836){_0x20bbb2[_0x55b2('0x9e')]=_0x5cf836;return _0x20bbb2;});}})[_0x55b2('0x19')](respondWithFilteredResult(_0x5c41e1,_0x494f36))[_0x55b2('0x25')](handleError(_0x5c41e1,null));};exports[_0x55b2('0x9f')]=function(_0x280794,_0x3da3cd){var _0x57146a={'raw':!![],'where':{}};var _0x626507={};var _0x3e9b28={'count':0x0,'rows':[]};return db['CmContact'][_0x55b2('0x79')]({'where':{'id':_0x280794[_0x55b2('0x64')]['id']}})[_0x55b2('0x19')](handleEntityNotFound(_0x3da3cd,null))[_0x55b2('0x19')](function(_0x523272){if(_0x523272){_0x626507[_0x55b2('0x7c')]=_['keys'](db[_0x55b2('0x4a')][_0x55b2('0x7a')]);_0x626507[_0x55b2('0x22')]=_[_0x55b2('0x29')](_0x280794['query']);_0x626507[_0x55b2('0x81')]=_[_0x55b2('0x7b')](_0x626507['model'],_0x626507['query']);_0x57146a[_0x55b2('0x7e')]=_[_0x55b2('0x7b')](_0x626507[_0x55b2('0x7c')],qs[_0x55b2('0x7d')](_0x280794[_0x55b2('0x22')]['fields']));_0x57146a[_0x55b2('0x7e')]=_0x57146a[_0x55b2('0x7e')][_0x55b2('0x2f')]?_0x57146a[_0x55b2('0x7e')]:_0x626507[_0x55b2('0x7c')];if(!_0x280794[_0x55b2('0x22')][_0x55b2('0x61')]('nolimit')){_0x57146a[_0x55b2('0x14')]=qs[_0x55b2('0x14')](_0x280794['query'][_0x55b2('0x14')]);_0x57146a[_0x55b2('0x12')]=qs[_0x55b2('0x12')](_0x280794[_0x55b2('0x22')][_0x55b2('0x12')]);}_0x57146a['order']=qs[_0x55b2('0x80')](_0x280794['query'][_0x55b2('0x80')]);_0x57146a[_0x55b2('0x5e')]=qs[_0x55b2('0x81')](_[_0x55b2('0x82')](_0x280794['query'],_0x626507[_0x55b2('0x81')]));_0x57146a[_0x55b2('0x5e')]['ContactId']=_0x523272['id'];if(_0x280794[_0x55b2('0x22')][_0x55b2('0x83')]){_0x57146a[_0x55b2('0x5e')]=_[_0x55b2('0x84')](_0x57146a[_0x55b2('0x5e')],{'$or':_['map'](_0x57146a['attributes'],function(_0x2db03b){var _0x12915f={};_0x12915f[_0x2db03b]={'$like':'%'+_0x280794['query']['filter']+'%'};return _0x12915f;})});}_0x57146a=_[_0x55b2('0x84')]({},_0x57146a,_0x280794['options']);return db['CmHopperFinal']['count']({'where':_0x57146a[_0x55b2('0x5e')]})[_0x55b2('0x19')](function(_0xbcf0ca){_0x3e9b28['count']=_0xbcf0ca;if(_0x280794[_0x55b2('0x22')]['includeAll']){_0x57146a[_0x55b2('0x9d')]=[{'all':!![]}];}return db['CmHopperFinal'][_0x55b2('0x21')](_0x57146a);})[_0x55b2('0x19')](function(_0x2bd65c){_0x3e9b28[_0x55b2('0x9e')]=_0x2bd65c;return _0x3e9b28;});}})['then'](respondWithFilteredResult(_0x3da3cd,_0x57146a))[_0x55b2('0x25')](handleError(_0x3da3cd,null));};exports[_0x55b2('0xa0')]=function(_0x2186e1,_0x9815d1){var _0x478c00={'raw':!![],'where':{}};var _0x153ab4={};var _0x3a840a={'count':0x0,'rows':[]};return db[_0x55b2('0x26')][_0x55b2('0x79')]({'where':{'id':_0x2186e1[_0x55b2('0x64')]['id']}})['then'](handleEntityNotFound(_0x9815d1,null))[_0x55b2('0x19')](function(_0x2671f7){if(_0x2671f7){_0x153ab4[_0x55b2('0x7c')]=_[_0x55b2('0x29')](db[_0x55b2('0x51')][_0x55b2('0x7a')]);_0x153ab4[_0x55b2('0x22')]=_[_0x55b2('0x29')](_0x2186e1[_0x55b2('0x22')]);_0x153ab4['filters']=_[_0x55b2('0x7b')](_0x153ab4[_0x55b2('0x7c')],_0x153ab4[_0x55b2('0x22')]);_0x478c00['attributes']=_['intersection'](_0x153ab4[_0x55b2('0x7c')],qs['fields'](_0x2186e1[_0x55b2('0x22')][_0x55b2('0x7d')]));_0x478c00[_0x55b2('0x7e')]=_0x478c00[_0x55b2('0x7e')][_0x55b2('0x2f')]?_0x478c00[_0x55b2('0x7e')]:_0x153ab4[_0x55b2('0x7c')];if(!_0x2186e1['query']['hasOwnProperty'](_0x55b2('0x86'))){_0x478c00[_0x55b2('0x14')]=qs[_0x55b2('0x14')](_0x2186e1['query']['limit']);_0x478c00[_0x55b2('0x12')]=qs[_0x55b2('0x12')](_0x2186e1[_0x55b2('0x22')][_0x55b2('0x12')]);}_0x478c00[_0x55b2('0x7f')]=qs[_0x55b2('0x80')](_0x2186e1[_0x55b2('0x22')][_0x55b2('0x80')]);_0x478c00['where']=qs['filters'](_[_0x55b2('0x82')](_0x2186e1[_0x55b2('0x22')],_0x153ab4[_0x55b2('0x81')]));_0x478c00[_0x55b2('0x5e')]['ContactId']=_0x2671f7['id'];if(_0x2186e1['query']['filter']){_0x478c00[_0x55b2('0x5e')]=_[_0x55b2('0x84')](_0x478c00[_0x55b2('0x5e')],{'$or':_['map'](_0x478c00['attributes'],function(_0x373bbf){var _0x57f57c={};_0x57f57c[_0x373bbf]={'$like':'%'+_0x2186e1[_0x55b2('0x22')][_0x55b2('0x83')]+'%'};return _0x57f57c;})});}_0x478c00=_[_0x55b2('0x84')]({},_0x478c00,_0x2186e1[_0x55b2('0x85')]);return db[_0x55b2('0x51')][_0x55b2('0x9b')]({'where':_0x478c00[_0x55b2('0x5e')]})['then'](function(_0x1f4b31){_0x3a840a[_0x55b2('0x9b')]=_0x1f4b31;if(_0x2186e1[_0x55b2('0x22')][_0x55b2('0x9c')]){_0x478c00['include']=[{'all':!![]}];}return db[_0x55b2('0x51')]['findAll'](_0x478c00);})['then'](function(_0x57c342){_0x3a840a[_0x55b2('0x9e')]=_0x57c342;return _0x3a840a;});}})['then'](respondWithFilteredResult(_0x9815d1,_0x478c00))[_0x55b2('0x25')](handleError(_0x9815d1,null));};exports[_0x55b2('0xa1')]=function(_0x26c0f7,_0x122d67){try{if(!_0x26c0f7[_0x55b2('0x35')]['ListId']){throw new Error(_0x55b2('0xa2'));}if(!_0x26c0f7[_0x55b2('0x35')][_0x55b2('0xa3')]){throw new Error(_0x55b2('0xa4'));}if(!_0x26c0f7[_0x55b2('0x35')][_0x55b2('0xa5')]){throw new Error(_0x55b2('0xa6'));}if(!_0x26c0f7[_0x55b2('0x35')]['socket_timestamp']){throw new Error(_0x55b2('0xa7'));}var _0x23809f=_0x26c0f7['body'][_0x55b2('0xa3')][_0x55b2('0xa8')](',');var _0x4c1ed5=_0x26c0f7[_0x55b2('0x35')]['binding_values'][_0x55b2('0xa8')](',');if(!_0x23809f[_0x55b2('0x2f')]||!_0x4c1ed5[_0x55b2('0x2f')]||_0x23809f[_0x55b2('0x2f')]!==_0x4c1ed5['length']){throw new Error(_0x55b2('0xa9'));}_0x26c0f7[_0x55b2('0x35')]['fields']=_[_0x55b2('0xaa')](_0x23809f,_0x4c1ed5);if(!_0x26c0f7[_0x55b2('0x35')]['fields']['phone']){throw new Error(_0x55b2('0xab'));}if(!_0x26c0f7[_0x55b2('0x35')][_0x55b2('0x7d')][_0x55b2('0xac')]){throw new Error(_0x55b2('0xad'));}var _0x4ad2fe=path[_0x55b2('0x3a')](config[_0x55b2('0xae')],_0x55b2('0xaf'),_0x26c0f7['file'][_0x55b2('0xb0')]);fs[_0x55b2('0xb1')](_0x4ad2fe,parseInt('0777',0x8));var _0x35be90=require(_0x55b2('0xb2'))[_0x55b2('0xb3')](path['join'](__dirname,'../../components/import/cm/csv'),[_0x4ad2fe,_0x26c0f7['body'][_0x55b2('0xa3')],_0x26c0f7[_0x55b2('0x35')][_0x55b2('0xa5')],_0x26c0f7[_0x55b2('0x35')]['ListId'],_0x26c0f7[_0x55b2('0x35')]['CompanyId'],_0x26c0f7[_0x55b2('0x35')][_0x55b2('0x5b')],_0x26c0f7['body'][_0x55b2('0xb4')]]);return _0x122d67[_0x55b2('0x15')](0xc8)[_0x55b2('0x11')]({'message':_0x55b2('0xb5'),'pid':_0x35be90[_0x55b2('0xb6')]});}catch(_0x388792){return _0x122d67[_0x55b2('0x15')](0x1f4)[_0x55b2('0x1f')](_0x388792);}};exports[_0x55b2('0xb7')]=function(_0x71c291,_0x3af8cc){var _0x22f413=fs[_0x55b2('0xb8')](_0x71c291[_0x55b2('0xb9')]['path']);Papa[_0x55b2('0xba')](_0x22f413,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x536c70){return _0x3af8cc[_0x55b2('0x15')](0xc8)[_0x55b2('0x11')]({'file':_0x71c291[_0x55b2('0xb9')],'fields':_0x536c70['meta'][_0x55b2('0x7d')]});}});};exports[_0x55b2('0xbb')]=function(_0x48c052,_0x3d89f8){return db[_0x55b2('0xbc')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0x55b2('0xbd')}})[_0x55b2('0x19')](function(_0x4a7130){var _0x385549=![];if(!_0x48c052[_0x55b2('0x35')][_0x55b2('0x5f')]){throw new Error(_0x55b2('0xa2'));}if(!_0x48c052[_0x55b2('0x35')][_0x55b2('0xbe')][_0x55b2('0x77')]){throw new Error(_0x55b2('0xab'));}if(!_0x48c052[_0x55b2('0x35')]['binding'][_0x55b2('0xac')]){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x48c052[_0x55b2('0x35')][_0x55b2('0xb4')]){throw new Error(_0x55b2('0xa7'));}var _0x321e71=require('child_process')[_0x55b2('0xb3')](path['join'](__dirname,_0x55b2('0xbf')),[_0x48c052[_0x55b2('0x64')]['id'],JSON['stringify'](_0x48c052['body']),JSON[_0x55b2('0xc0')](_0x4a7130)]);_0x321e71['on'](_0x55b2('0xc1'),function(){_0x385549=!![];return _0x3d89f8['status'](0xc8)[_0x55b2('0x11')]({'message':_0x55b2('0xc2'),'pid':_0x321e71[_0x55b2('0xb6')]});});_0x321e71['on'](_0x55b2('0xc3'),function(_0x5907cf){if(_0x5907cf&&!_0x385549){return _0x3d89f8['status'](0x1f4)['json']({'message':_0x55b2('0xc4'),'pid':_0x321e71[_0x55b2('0xb6')]});}});})['catch'](handleError(_0x3d89f8,null));};exports[_0x55b2('0xc5')]=function(_0x5be095,_0x27a0d7){return db['User'][_0x55b2('0x21')]({'raw':!![],'attributes':['id'],'where':{'role':_0x55b2('0xbd')}})['then'](function(_0x13930f){var _0x1163ec=![];if(!_0x5be095[_0x55b2('0x35')][_0x55b2('0x5f')]){throw new Error(_0x55b2('0xa2'));}if(!_0x5be095[_0x55b2('0x35')][_0x55b2('0xbe')][_0x55b2('0x77')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x5be095[_0x55b2('0x35')][_0x55b2('0xbe')][_0x55b2('0xac')]){throw new Error(_0x55b2('0xad'));}if(!_0x5be095[_0x55b2('0x35')][_0x55b2('0xb4')]){throw new Error(_0x55b2('0xa7'));}var _0x22e4fb=require('child_process')[_0x55b2('0xb3')](path['join'](__dirname,_0x55b2('0xc6')),[_0x5be095['params']['id'],JSON['stringify'](_0x5be095[_0x55b2('0x35')]),JSON['stringify'](_0x13930f)]);_0x22e4fb['on'](_0x55b2('0xc1'),function(){_0x1163ec=!![];return _0x27a0d7[_0x55b2('0x15')](0xc8)['json']({'message':_0x55b2('0xc2'),'pid':_0x22e4fb[_0x55b2('0xb6')]});});_0x22e4fb['on']('exit',function(_0xf8df41){if(_0xf8df41&&!_0x1163ec){return _0x27a0d7[_0x55b2('0x15')](0x1f4)['json']({'message':'error\x20child\x20process','pid':_0x22e4fb[_0x55b2('0xb6')]});}});})['catch'](handleError(_0x27a0d7,null));};exports['getJourney']=function(_0x2a98da,_0x5e5171){var _0x2b871b=[_0x55b2('0xc7'),_0x55b2('0xc8'),'sms',_0x55b2('0xc9'),_0x55b2('0xca'),_0x55b2('0xcb'),'voice'];var _0x3dbd2b={'offset':0x0,'order':qs[_0x55b2('0x80')](_0x55b2('0xcc'))},_0x33234e={'count':0x0,'rows':[]};Promise[_0x55b2('0xcd')]()['then'](function(){if(_0x2a98da['query']['channel']){if(!_['includes'](_0x2b871b,_0x2a98da['query'][_0x55b2('0xce')][_0x55b2('0xcf')]())){throw new Error(_0x55b2('0xd0'));}_0x2b871b=[_0x2a98da[_0x55b2('0x22')]['channel'][_0x55b2('0xcf')]()];}if(_0x2a98da[_0x55b2('0x22')]['range']){try{var _0x5a7d7b=JSON[_0x55b2('0xba')](_0x2a98da['query'][_0x55b2('0xd1')]);if(!moment(_0x5a7d7b[_0x55b2('0x36')])[_0x55b2('0xd2')]()){throw new Error(_0x55b2('0xd3'));}if(!moment(_0x5a7d7b['to'])[_0x55b2('0xd2')]()){throw new Error(_0x55b2('0xd4'));}}catch(_0x55a37c){throw new Error(_0x55b2('0xd5'));}}if(!_0x2a98da[_0x55b2('0x22')][_0x55b2('0x61')](_0x55b2('0x86'))){_0x3dbd2b[_0x55b2('0x14')]=qs['limit'](_0x2a98da[_0x55b2('0x22')][_0x55b2('0x14')]||0xa);_0x3dbd2b['offset']=qs[_0x55b2('0x12')](_0x2a98da[_0x55b2('0x22')][_0x55b2('0x12')]);}var _0x4fcb58=_0x2b871b['map'](function(_0x20e980){if(_0x20e980===_0x55b2('0xd6')){var _0xd7a674={'attributes':['id',_0x55b2('0xd7'),'type',_0x55b2('0xd8'),_0x55b2('0xd9'),_0x55b2('0xda'),'starttime',_0x55b2('0xdb'),'duration','note',_0x55b2('0xdc'),_0x55b2('0xdd'),_0x55b2('0xde'),'userThirdDisposition',_0x55b2('0xdf')],'where':{'ContactId':_0x2a98da[_0x55b2('0x64')]['id']},'include':[{'model':db[_0x55b2('0xbc')],'as':_0x55b2('0xbc'),'attributes':['id',_0x55b2('0x1e'),_0x55b2('0xe0'),_0x55b2('0xe1')]}],'order':[[_0x55b2('0xdc'),_0x55b2('0xe2')]]};if(_0x2a98da['query']['range']){_0xd7a674['where']['createdAt']={'$gte':_0x5a7d7b['from'],'$lte':_0x5a7d7b['to']};}return db[_0x55b2('0x4c')]['findAndCountAll'](_0xd7a674)[_0x55b2('0x19')](function(_0x8d3d08){_0x33234e[_0x55b2('0x9b')]+=_0x8d3d08['count'];return _[_0x55b2('0x71')](_0x8d3d08[_0x55b2('0x9e')],function(_0xbd48b9){var _0x2b9bc5=_0xbd48b9[_0x55b2('0x37')]({'plain':!![]});_0x2b9bc5['channel']=_0x20e980;if(_0x2b9bc5[_0x55b2('0xbc')]){_0x2b9bc5[_0x55b2('0xbc')]={'id':_0x2b9bc5[_0x55b2('0xbc')]['id'],'name':_0x2b9bc5[_0x55b2('0xbc')][_0x55b2('0x1e')],'fullname':_0x2b9bc5[_0x55b2('0xbc')][_0x55b2('0xe0')],'alias':_0x2b9bc5[_0x55b2('0xbc')]['alias']};}return _0x2b9bc5;});});}else{var _0x1bbcac=_[_0x55b2('0xe3')](_0x20e980)+(_0x20e980==='chat'?_0x55b2('0xe4'):_0x55b2('0xe5'));var _0xa31448={'attributes':['id',_0x55b2('0xe6'),'closedAt',_0x55b2('0xdc'),_0x55b2('0xe7'),_0x55b2('0xe8'),'secondDisposition',_0x55b2('0xe9'),'UserId',_0x1bbcac+'Id'],'where':{'ContactId':_0x2a98da['params']['id']},'include':[{'model':db[_0x1bbcac],'as':_0x55b2('0xe5'),'attributes':['id',_0x55b2('0x1e'),_0x55b2('0xea')]},{'model':db[_0x55b2('0xbc')],'as':'Owner','attributes':['id',_0x55b2('0x1e'),_0x55b2('0xe0')]},{'model':db[_0x55b2('0x65')],'as':_0x55b2('0x66'),'attributes':['id',_0x55b2('0x1e'),_0x55b2('0x67')],'through':{'attributes':[]}}],'order':[['createdAt',_0x55b2('0xe2')]]};if(_0x2a98da[_0x55b2('0x22')]['range']){_0xa31448[_0x55b2('0x5e')][_0x55b2('0xdc')]={'$gte':_0x5a7d7b[_0x55b2('0x36')],'$lte':_0x5a7d7b['to']};}switch(_0x20e980){case _0x55b2('0xc8'):_0xa31448[_0x55b2('0x7e')]['push'](_0x55b2('0xeb'),_0x55b2('0xec'),_0x55b2('0xed'),_0x55b2('0xee'),_0x55b2('0xef'),_0x55b2('0xf0'),_0x55b2('0xf1'),_0x55b2('0xf2'),_0x55b2('0xf3'));break;case _0x55b2('0xc7'):_0xa31448['attributes'][_0x55b2('0x5d')](_0x55b2('0xf4'),_0x55b2('0xf5'));break;case _0x55b2('0xc9'):_0xa31448['attributes']['push'](_0x55b2('0xf6'),_0x55b2('0xf7'));break;}return db[_['startCase'](_0x20e980)+_0x55b2('0xf8')]['findAndCountAll'](_0xa31448)[_0x55b2('0x19')](function(_0x2982b4){_0x33234e['count']+=_0x2982b4[_0x55b2('0x9b')];return _['map'](_0x2982b4[_0x55b2('0x9e')],function(_0x219b2c){var _0x590b36=_0x219b2c[_0x55b2('0x37')]({'plain':!![]});_0x590b36[_0x55b2('0xce')]=_0x20e980;if(_0x590b36['Owner']){_0x590b36['Owner']={'id':_0x590b36[_0x55b2('0xf9')]['id'],'name':_0x590b36['Owner'][_0x55b2('0x1e')],'fullname':_0x590b36[_0x55b2('0xf9')][_0x55b2('0xe0')]};}return _0x590b36;});});}});return Promise['all'](_0x4fcb58);})['then'](function(_0xa3d32a){return _(_0xa3d32a)[_0x55b2('0xfa')]()[_0x55b2('0xfb')](_0x55b2('0xdc'))[_0x55b2('0xfc')]()[_0x55b2('0xfd')]();})['then'](function(_0x4883b1){_0x33234e[_0x55b2('0x9e')]=_0x3dbd2b[_0x55b2('0x14')]?_0x4883b1[_0x55b2('0xfe')](_0x3dbd2b[_0x55b2('0x12')],_0x3dbd2b[_0x55b2('0x12')]+_0x3dbd2b[_0x55b2('0x14')]):_0x4883b1;return _0x33234e;})[_0x55b2('0x19')](respondWithFilteredResult(_0x5e5171,_0x3dbd2b))[_0x55b2('0x25')](handleError(_0x5e5171,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff