18 var _0x5fa5=['customerIp','deviceModel','ratingValue','referer','subject','substatus','openchannel','externalUrl','threadId','Interaction','Owner','flatten','reverse','slice','moment','bluebird','path','lodash','papaparse','../../components/parsers/qs','../../config/logger','api','../../config/environment','../../config/environment/shared','redis','defaults','localhost','./cmContact.socket','json','offset','undefined','limit','count','status','set','update','then','sendStatus','error','name','index','describe','findAll','query','user','catch','destroy','CmContact','params','tags','keys','length','startsWith','cf_','columnName','displayName','alias','custom','values','info','Custom\x20field\x20%s\x20not\x20found\x20on\x20cm_contacts\x20table','forEach','hasOwnProperty','merge','body','get','mergeWith','isArray','join','[CmContact][merge]\x20to\x20%s\x20from\x20%s','from','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxMessage','OpenchannelInteraction','CmHopperFinal','CmHopperHistory','ReportAgentPreview','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','WhatsappInteraction','isNil','dialTimezone','utcOffset','additionalPhones','duplicates','where','$or','ListId','spread','push','all','show','find','Tag','Tags','Phones','ItemType','sequelize','Phones.OrderBy','$and','CmCustomField','omit','map','format','timezones','pickBy','table','cm_contacts','setFields','id\x20=\x20?','phone','CmHopper','getTags','findOne','model','rawAttributes','filters','attributes','intersection','fields','order','sort','pick','filter','options','setTags','ids','setAdditionalPhones','CmContactHasItem','OrderBy','item_types','items','ItemTypeId','description','item','PHONE','ContactItemType','literal','`ItemType`.OrderBy','CmHopperId','CmHopperAdditionalPhone','fromContactId','CmContactId','toContactId','bulkCreate','rescheduleAdditionalPhones','hopperId','getHoppers','nolimit','ContactId','includeAll','include','rows','getHopperFinals','getJscriptySessions','JscriptySessionReport','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','root','file','filename','chmodSync','0777','child_process','fork','../../components/import/cm/csv','CompanyId','socket_timestamp','pid','send','meta','User','binding','firstName','No\x20firstName\x20column\x20specified','stringify','message','start\x20child\x20process\x20correctly!','exit','error\x20child\x20process','agent','../../components/import/cm/csvUpdates','getJourney','sms','fax','whatsapp','resolve','includes','toLowerCase','Invalid\x20channel','range','parse','isValid','Invalid\x20date\x20for\x20range\x20to\x20filter','voice','source','destination','callerid','starttime','duration','userSecondDisposition','UserId','fullname','createdAt','DESC','findAndCountAll','channel','startCase','chat','Website','Account','note','disposition','secondDisposition','thirdDisposition','key','color'];(function(_0x3e4fa5,_0x2cbc12){var _0x1141ff=function(_0x295dce){while(--_0x295dce){_0x3e4fa5['push'](_0x3e4fa5['shift']());}};_0x1141ff(++_0x2cbc12);}(_0x5fa5,0x1e8));var _0x55fa=function(_0x45d55e,_0x2fede3){_0x45d55e=_0x45d55e-0x0;var _0x29812a=_0x5fa5[_0x45d55e];return _0x29812a;};'use strict';var moment=require(_0x55fa('0x0'));var BPromise=require(_0x55fa('0x1'));var util=require('util');var path=require(_0x55fa('0x2'));var fs=require('fs');var _=require(_0x55fa('0x3'));var squel=require('squel');var Papa=require(_0x55fa('0x4'));var Redis=require('ioredis');var contacts=require('../../components/contacts');var qs=require(_0x55fa('0x5'));var logger=require(_0x55fa('0x6'))(_0x55fa('0x7'));var config=require(_0x55fa('0x8'));var shared=require(_0x55fa('0x9'));var db=require('../../mysqldb')['db'];config[_0x55fa('0xa')]=_[_0x55fa('0xb')](config['redis'],{'host':_0x55fa('0xc'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x55fa('0xa')]));require(_0x55fa('0xd'))['register'](socket);function respondWithResult(_0x4b692d,_0x4e24e3){_0x4e24e3=_0x4e24e3||0xc8;return function(_0x3fac89){if(_0x3fac89){return _0x4b692d['status'](_0x4e24e3)[_0x55fa('0xe')](_0x3fac89);}};}function respondWithFilteredResult(_0xaae41b,_0x572a61){return function(_0x11abef){if(_0x11abef){var _0x16c58f=typeof _0x572a61[_0x55fa('0xf')]===_0x55fa('0x10')&&typeof _0x572a61[_0x55fa('0x11')]===_0x55fa('0x10');var _0x2081a5=_0x11abef[_0x55fa('0x12')];var _0x57f2d9=_0x16c58f?0x0:_0x572a61[_0x55fa('0xf')];var _0x46cbe6=_0x16c58f?_0x11abef['count']:_0x572a61[_0x55fa('0xf')]+_0x572a61['limit'];var _0x5d7fa3;if(_0x46cbe6>=_0x2081a5){_0x46cbe6=_0x2081a5;_0x5d7fa3=0xc8;}else{_0x5d7fa3=0xce;}_0xaae41b[_0x55fa('0x13')](_0x5d7fa3);return _0xaae41b[_0x55fa('0x14')]('Content-Range',_0x57f2d9+'-'+_0x46cbe6+'/'+_0x2081a5)[_0x55fa('0xe')](_0x11abef);}return null;};}function saveUpdates(_0x4b0ff2){return function(_0x30549e){if(_0x30549e){return _0x30549e[_0x55fa('0x15')](_0x4b0ff2)[_0x55fa('0x16')](function(_0x22d942){return _0x22d942;});}return null;};}function removeEntity(_0x17eb47){return function(_0x576152){if(_0x576152){return _0x576152['destroy']()[_0x55fa('0x16')](function(){_0x17eb47['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x4bceaa){return function(_0x5e55d3){if(!_0x5e55d3){_0x4bceaa[_0x55fa('0x17')](0x194);}return _0x5e55d3;};}function handleError(_0x3b626f,_0x426c79){_0x426c79=_0x426c79||0x1f4;return function(_0x535f92){logger[_0x55fa('0x18')](_0x535f92['stack']);if(_0x535f92[_0x55fa('0x19')]){delete _0x535f92['name'];}_0x3b626f[_0x55fa('0x13')](_0x426c79)['send'](_0x535f92);};}exports[_0x55fa('0x1a')]=function(_0xcaad16,_0x49cc60){var _0x29f16b={};return contacts[_0x55fa('0x1b')]()['then'](function(_0x25dc26){_0x29f16b=qs['getOptions'](_0x25dc26,_0xcaad16);return contacts[_0x55fa('0x1c')](_0xcaad16[_0x55fa('0x1d')],_0xcaad16[_0x55fa('0x1e')],_0x29f16b,_0x25dc26);})[_0x55fa('0x16')](respondWithFilteredResult(_0x49cc60,_0x29f16b))[_0x55fa('0x1f')](handleError(_0x49cc60,null));};exports[_0x55fa('0x20')]=function(_0x33aae8,_0x3d5768){return db[_0x55fa('0x21')]['find']({'where':{'id':_0x33aae8[_0x55fa('0x22')]['id']}})[_0x55fa('0x16')](handleEntityNotFound(_0x3d5768,null))[_0x55fa('0x16')](removeEntity(_0x3d5768,null))[_0x55fa('0x1f')](handleError(_0x3d5768,null));};exports[_0x55fa('0x1b')]=function(_0x3f95fc,_0x2d9b35){return db[_0x55fa('0x21')][_0x55fa('0x1b')]()[_0x55fa('0x16')](function(_0xd01917){delete _0xd01917[_0x55fa('0x23')];for(var _0x203791=0x0;_0x203791<Object[_0x55fa('0x24')](_0xd01917)[_0x55fa('0x25')];_0x203791++){var _0x490774=Object['keys'](_0xd01917)[_0x203791];if(!_[_0x55fa('0x26')](_0x490774,_0x55fa('0x27'))){_0xd01917[_0x490774][_0x55fa('0x28')]=_0x490774;_0xd01917[_0x490774][_0x55fa('0x29')]=_0x490774;}}return _0xd01917;})[_0x55fa('0x16')](function(_0x3db1a8){var _0x53e0a1={'where':Boolean(_0x3f95fc['query']['analytics'])===!![]?undefined:{'$or':[{'ListId':_0x3f95fc[_0x55fa('0x1d')]['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField'][_0x55fa('0x1c')](_0x53e0a1)[_0x55fa('0x16')](function(_0x425c72){for(var _0x533053=0x0;_0x533053<_0x425c72[_0x55fa('0x25')];_0x533053++){var _0x290d6e=_0x55fa('0x27')+_0x425c72[_0x533053]['id'];if(_0x3db1a8[_0x290d6e]){_0x3db1a8[_0x290d6e][_0x55fa('0x28')]=_0x290d6e;_0x3db1a8[_0x290d6e][_0x55fa('0x29')]=_0x425c72[_0x533053][_0x55fa('0x2a')];_0x3db1a8[_0x290d6e][_0x55fa('0x2b')]={'type':_0x425c72[_0x533053]['type'],'values':_0x425c72[_0x533053][_0x55fa('0x2c')]};}else{logger[_0x55fa('0x2d')](_0x55fa('0x2e'),_0x290d6e);}}Object[_0x55fa('0x24')](_0x3db1a8)[_0x55fa('0x2f')](function(_0x2ca557){if(!_0x3db1a8[_0x2ca557][_0x55fa('0x30')](_0x55fa('0x28'))){delete _0x3db1a8[_0x2ca557];}});return _0x3db1a8;});})[_0x55fa('0x16')](respondWithResult(_0x2d9b35,null))['catch'](handleError(_0x2d9b35,null));};exports[_0x55fa('0x31')]=function(_0x3b32f3,_0x1851ed){var _0x144d4c;var _0x15daf4;var _0x531fb2;if(_0x3b32f3[_0x55fa('0x32')]['id']){delete _0x3b32f3[_0x55fa('0x32')]['id'];}return db[_0x55fa('0x21')]['findAll']({'where':{'id':[_0x3b32f3[_0x55fa('0x32')]['to'],_0x3b32f3[_0x55fa('0x32')]['from']]}})[_0x55fa('0x16')](function(_0x5e198d){if(_0x5e198d){if(_0x5e198d[_0x55fa('0x25')]!==0x2){return null;}_0x5e198d[0x0]=_0x5e198d[0x0][_0x55fa('0x33')]({'plain':!![]});_0x5e198d[0x1]=_0x5e198d[0x1][_0x55fa('0x33')]({'plain':!![]});delete _0x5e198d[0x0]['id'];delete _0x5e198d[0x1]['id'];return _[_0x55fa('0x34')](_0x5e198d[0x0],_0x5e198d[0x1],function(_0x57d5af,_0x26a565){if(Array['isArray'](_0x26a565)&&!_0x26a565[_0x55fa('0x25')]){return _0x57d5af;}else if(!_0x26a565){return _0x57d5af;}});}})[_0x55fa('0x16')](handleEntityNotFound(_0x1851ed,null))[_0x55fa('0x16')](function(_0x28b6c5){if(_0x28b6c5){if(_0x28b6c5['tags']&&_[_0x55fa('0x35')](_0x28b6c5[_0x55fa('0x23')])){_0x28b6c5['tags']=_0x28b6c5['tags'][_0x55fa('0x36')]();}logger[_0x55fa('0x2d')](_0x55fa('0x37'),_0x3b32f3['body']['to'],_0x3b32f3[_0x55fa('0x32')]['from']);return db['CmHopper'][_0x55fa('0x20')]({'where':{'ContactId':[_0x3b32f3[_0x55fa('0x32')]['to'],_0x3b32f3[_0x55fa('0x32')][_0x55fa('0x38')]]}})['then'](function(_0x3641aa){logger[_0x55fa('0x2d')]('[CmContact][merge][destroy][CmHopper],\x20%s',_0x3641aa);return db[_0x55fa('0x39')]['destroy']({'where':{'ContactId':[_0x3b32f3[_0x55fa('0x32')]['to'],_0x3b32f3[_0x55fa('0x32')][_0x55fa('0x38')]]}})[_0x55fa('0x16')](function(_0x4105e6){logger[_0x55fa('0x2d')](_0x55fa('0x3a'),_0x4105e6);return db[_0x55fa('0x21')][_0x55fa('0x3b')](_0x28b6c5);});});}})[_0x55fa('0x16')](function(_0x4a5e11){if(_0x4a5e11){_0x144d4c=_0x4a5e11;_0x15daf4={'ContactId':_0x144d4c['id']};_0x531fb2={'where':{'ContactId':[_0x3b32f3['body']['to'],_0x3b32f3['body']['from']]}};return db[_0x55fa('0x3c')][_0x55fa('0x15')](_0x15daf4,_0x531fb2);}})['then'](function(){if(_0x144d4c){return db[_0x55fa('0x3d')][_0x55fa('0x15')](_0x15daf4,_0x531fb2);}})[_0x55fa('0x16')](function(){if(_0x144d4c){return db[_0x55fa('0x3e')][_0x55fa('0x15')](_0x15daf4,_0x531fb2);}})[_0x55fa('0x16')](function(){if(_0x144d4c){return db[_0x55fa('0x3f')][_0x55fa('0x15')](_0x15daf4,_0x531fb2);}})[_0x55fa('0x16')](function(){if(_0x144d4c){return db[_0x55fa('0x40')][_0x55fa('0x15')](_0x15daf4,_0x531fb2);}})[_0x55fa('0x16')](function(){if(_0x144d4c){return db['MailInteraction']['update'](_0x15daf4,_0x531fb2);}})[_0x55fa('0x16')](function(){if(_0x144d4c){return db[_0x55fa('0x40')][_0x55fa('0x15')](_0x15daf4,_0x531fb2);}})[_0x55fa('0x16')](function(){if(_0x144d4c){return db[_0x55fa('0x41')][_0x55fa('0x15')](_0x15daf4,_0x531fb2);}})[_0x55fa('0x16')](function(){if(_0x144d4c){return db[_0x55fa('0x42')]['update'](_0x15daf4,_0x531fb2);}})[_0x55fa('0x16')](function(){if(_0x144d4c){return db['FaxInteraction'][_0x55fa('0x15')](_0x15daf4,_0x531fb2);}})[_0x55fa('0x16')](function(){if(_0x144d4c){return db[_0x55fa('0x43')]['update'](_0x15daf4,_0x531fb2);}})[_0x55fa('0x16')](function(){if(_0x144d4c){return db[_0x55fa('0x44')][_0x55fa('0x15')](_0x15daf4,_0x531fb2);}})['then'](function(){if(_0x144d4c){return db['OpenchannelMessage'][_0x55fa('0x15')](_0x15daf4,_0x531fb2);}})[_0x55fa('0x16')](function(){if(_0x144d4c){return db['CmContactHasItem'][_0x55fa('0x15')]({'CmContactId':_0x144d4c['id']},{'where':{'CmContactId':[_0x3b32f3[_0x55fa('0x32')]['to'],_0x3b32f3['body'][_0x55fa('0x38')]]}});}})['then'](function(){if(_0x144d4c){return db[_0x55fa('0x45')]['update'](_0x15daf4,_0x531fb2);}})[_0x55fa('0x16')](function(){if(_0x144d4c){return db[_0x55fa('0x46')][_0x55fa('0x15')](_0x15daf4,_0x531fb2);}})[_0x55fa('0x16')](function(){if(_0x144d4c){return db[_0x55fa('0x47')][_0x55fa('0x15')](_0x15daf4,_0x531fb2);}})[_0x55fa('0x16')](function(){if(_0x144d4c){return db['VoiceCallReport']['update'](_0x15daf4,_0x531fb2);}})[_0x55fa('0x16')](function(){if(_0x144d4c){return db[_0x55fa('0x48')]['update'](_0x15daf4,_0x531fb2);}})['then'](function(){if(_0x144d4c){return db[_0x55fa('0x49')][_0x55fa('0x15')](_0x15daf4,_0x531fb2);}})[_0x55fa('0x16')](function(){if(_0x144d4c){return db[_0x55fa('0x4a')]['update'](_0x15daf4,_0x531fb2);}})[_0x55fa('0x16')](function(){if(_0x144d4c){return db[_0x55fa('0x4b')]['update'](_0x15daf4,_0x531fb2);}})['then'](function(){if(_0x144d4c){return db['SmsQueueReport']['update'](_0x15daf4,_0x531fb2);}})[_0x55fa('0x16')](function(){if(_0x144d4c){return db['JscriptySessionReport'][_0x55fa('0x15')](_0x15daf4,_0x531fb2);}})[_0x55fa('0x16')](function(){if(_0x144d4c){return db[_0x55fa('0x4c')][_0x55fa('0x15')](_0x15daf4,_0x531fb2);}})[_0x55fa('0x16')](function(){if(_0x144d4c){return db['WhatsappMessage']['update'](_0x15daf4,_0x531fb2);}})[_0x55fa('0x16')](function(){if(_0x144d4c){return db['WhatsappQueueReport'][_0x55fa('0x15')](_0x15daf4,_0x531fb2);}})['then'](function(){if(_0x144d4c){return db['CmContact'][_0x55fa('0x20')]({'where':{'id':[_0x3b32f3['body']['to'],_0x3b32f3[_0x55fa('0x32')][_0x55fa('0x38')]]}});}})[_0x55fa('0x16')](function(){if(_0x144d4c){return _0x144d4c;}})[_0x55fa('0x16')](respondWithResult(_0x1851ed,null))[_0x55fa('0x1f')](handleError(_0x1851ed,null));};exports[_0x55fa('0x3b')]=function(_0x500974,_0x32cd2b){return db['CmContact'][_0x55fa('0x1b')]()[_0x55fa('0x16')](function(_0x2ffafa){if(_0x500974[_0x55fa('0x32')][_0x55fa('0x23')]&&_[_0x55fa('0x35')](_0x500974[_0x55fa('0x32')][_0x55fa('0x23')])){if(_0x500974[_0x55fa('0x32')]['tags'][_0x55fa('0x25')]){_0x500974[_0x55fa('0x32')][_0x55fa('0x23')]=_0x500974[_0x55fa('0x32')]['tags'][_0x55fa('0x36')](';')+';';}else{_0x500974[_0x55fa('0x32')][_0x55fa('0x23')]=null;}}else{_0x500974['body'][_0x55fa('0x23')]=null;}if(!_[_0x55fa('0x4d')](_0x500974[_0x55fa('0x32')][_0x55fa('0x4e')])){var _0x4ea4bb=_0x500974[_0x55fa('0x32')][_0x55fa('0x4e')];if(!_[_0x55fa('0x4d')](shared['timezones'][_0x4ea4bb]))_0x500974[_0x55fa('0x32')][_0x55fa('0x4f')]=shared['timezones'][_0x4ea4bb][_0x55fa('0x4f')];}return db[_0x55fa('0x21')][_0x55fa('0x3b')](_0x500974[_0x55fa('0x32')],{'fields':_[_0x55fa('0x24')](_0x2ffafa),'raw':!![]});})[_0x55fa('0x16')](function(_0x3a388b){if(_0x500974[_0x55fa('0x32')][_0x55fa('0x50')]){return insertAdditionalPhones(_0x3a388b,_0x500974[_0x55fa('0x32')][_0x55fa('0x50')]);}else{return _0x3a388b;}})[_0x55fa('0x16')](respondWithResult(_0x32cd2b,0xc9))['catch'](handleError(_0x32cd2b,null));};exports['bulkCreate']=function(_0x3349af,_0x42235e){var _0x142d4f=0x0;var _0x2044fd=0x0;var _0x2a66c9=0x0;var _0x2abe20=[];return db[_0x55fa('0x21')][_0x55fa('0x1b')]()[_0x55fa('0x16')](function(_0x4b3101){return BPromise['each'](_0x3349af['body'],function(_0x1f7b53){var _0x3e3c04={'where':{'$or':[]},'defaults':_0x1f7b53,'fields':_[_0x55fa('0x24')](_0x4b3101),'raw':!![]};if(_0x1f7b53['duplicates']){for(var _0x367742=0x0;_0x367742<_0x1f7b53[_0x55fa('0x51')][_0x55fa('0x25')];_0x367742++){var _0x505d70={};_0x505d70[_0x1f7b53[_0x55fa('0x51')][_0x367742]]=_0x1f7b53[_0x1f7b53[_0x55fa('0x51')][_0x367742]];_0x3e3c04[_0x55fa('0x52')][_0x55fa('0x53')]['push'](_0x505d70);}_0x3e3c04[_0x55fa('0x52')][_0x55fa('0x54')]=_0x1f7b53[_0x55fa('0x54')];}return db[_0x55fa('0x21')]['findOrCreate'](_0x3e3c04)[_0x55fa('0x55')](function(_0x16b69f,_0x5a814b){if(_0x5a814b){if(_0x1f7b53[_0x55fa('0x30')](_0x55fa('0x50'))){_0x2abe20['push']({'contact':_0x16b69f,'additionalPhones':_0x1f7b53['additionalPhones']});}_0x142d4f++;}else{_0x2a66c9++;}})[_0x55fa('0x1f')](function(){_0x2044fd++;});});})[_0x55fa('0x16')](function(_0x145386){if(_0x145386){if(_0x2abe20['length']>0x0){return new Promise(function(_0xfe4c6a){var _0x4b404a=[];for(var _0x4305f3=0x0;_0x4305f3<_0x2abe20[_0x55fa('0x25')];_0x4305f3++){_0x4b404a[_0x55fa('0x56')](insertAdditionalPhones(_0x2abe20[_0x4305f3]['contact'],_0x2abe20[_0x4305f3][_0x55fa('0x50')]));}Promise[_0x55fa('0x57')](_0x4b404a)[_0x55fa('0x16')](function(){_0xfe4c6a(0x1);});})[_0x55fa('0x16')](function(){return{'success':_0x142d4f,'failure':_0x2044fd,'duplicates':_0x2a66c9};});}else{return{'success':_0x142d4f,'failure':_0x2044fd,'duplicates':_0x2a66c9};}}})['then'](respondWithResult(_0x42235e,0xc9))['catch'](handleError(_0x42235e,null));};exports[_0x55fa('0x58')]=function(_0x49e574,_0x48826c){var _0x28a3ea;return db[_0x55fa('0x21')][_0x55fa('0x1b')]()[_0x55fa('0x16')](function(_0x201146){return db[_0x55fa('0x21')][_0x55fa('0x59')]({'where':{'id':_0x49e574[_0x55fa('0x22')]['id']},'include':[{'model':db[_0x55fa('0x5a')],'as':_0x55fa('0x5b'),'attributes':['id',_0x55fa('0x19'),'color'],'required':_0x49e574[_0x55fa('0x1d')]['tag']?!![]:![]},{'model':db['CmContactHasItem'],'as':_0x55fa('0x5c'),'where':{'CmContactId':_0x49e574[_0x55fa('0x22')]['id']},'required':![],'include':[{'model':db['ContactItemType'],'as':_0x55fa('0x5d')}]}],'order':[db[_0x55fa('0x5e')]['literal'](_0x55fa('0x5f'))],'attributes':_[_0x55fa('0x24')](_0x201146)});})[_0x55fa('0x16')](function(_0x301299){if(!_[_0x55fa('0x4d')](_0x301299)){_0x28a3ea=_0x301299['get']({'plain':!![]});var _0xb3433c={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x301299&&_0x301299[_0x55fa('0x54')]){if(_0x301299[_0x55fa('0x54')]){_0xb3433c[_0x55fa('0x52')][_0x55fa('0x60')][_0x55fa('0x56')]({'ListId':{'$ne':_0x301299[_0x55fa('0x54')]}});}}return db[_0x55fa('0x61')][_0x55fa('0x1c')](_0xb3433c);}})['then'](function(_0x40455f){if(!_[_0x55fa('0x4d')](_0x40455f)){return _[_0x55fa('0x62')](_0x28a3ea,_[_0x55fa('0x63')](_0x40455f,function(_0x4305a8){return util[_0x55fa('0x64')]('cf_%d',_0x4305a8['id']);}));}})[_0x55fa('0x16')](handleEntityNotFound(_0x48826c,null))[_0x55fa('0x16')](respondWithResult(_0x48826c,null))[_0x55fa('0x1f')](handleError(_0x48826c,null));};exports[_0x55fa('0x15')]=function(_0x54aec7,_0x180d5d){var _0x55326d;if(_0x54aec7[_0x55fa('0x32')]['id']){delete _0x54aec7[_0x55fa('0x32')]['id'];}if(!_[_0x55fa('0x4d')](_0x54aec7[_0x55fa('0x32')][_0x55fa('0x4e')])){var _0x43abd9=_0x54aec7[_0x55fa('0x32')][_0x55fa('0x4e')];if(!_[_0x55fa('0x4d')](shared[_0x55fa('0x65')][_0x43abd9]))_0x54aec7[_0x55fa('0x32')][_0x55fa('0x4f')]=shared[_0x55fa('0x65')][_0x43abd9][_0x55fa('0x4f')];}return db['CmContact'][_0x55fa('0x59')]({'where':{'id':_0x54aec7[_0x55fa('0x22')]['id']}})[_0x55fa('0x16')](handleEntityNotFound(_0x180d5d,null))['then'](saveUpdates(_0x54aec7[_0x55fa('0x32')],null))[_0x55fa('0x16')](function(_0x4f1194){_0x55326d=_0x4f1194;var _0x16c9e7={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x4f1194&&_0x4f1194[_0x55fa('0x54')]){if(_0x4f1194[_0x55fa('0x54')]){_0x16c9e7['where'][_0x55fa('0x60')][_0x55fa('0x56')]({'ListId':{'$ne':_0x4f1194['ListId']}});}}return db[_0x55fa('0x61')][_0x55fa('0x1c')](_0x16c9e7);})[_0x55fa('0x16')](function(_0xcfbd10){if(_0xcfbd10){return _[_0x55fa('0x62')](_[_0x55fa('0x66')](_0x54aec7[_0x55fa('0x32')],function(_0x3f758c,_0x568ce5){return _[_0x55fa('0x26')](_0x568ce5,'cf_');}),_[_0x55fa('0x63')](_0xcfbd10,function(_0x57c9b7){return util[_0x55fa('0x64')]('cf_%d',_0x57c9b7['id']);}));}})[_0x55fa('0x16')](function(_0x198a5b){if(_0x198a5b&&!_['isEmpty'](_0x198a5b)){var _0x147429=squel['update']()[_0x55fa('0x67')](_0x55fa('0x68'))[_0x55fa('0x69')](_0x198a5b)['where'](_0x55fa('0x6a'),_0x54aec7[_0x55fa('0x22')]['id'])['toParam']();return db[_0x55fa('0x5e')][_0x55fa('0x1d')](_0x147429['text'],{'replacements':_0x147429[_0x55fa('0x2c')]});}})[_0x55fa('0x16')](function(){if(_0x54aec7['body'][_0x55fa('0x6b')]&&_0x55326d){return db[_0x55fa('0x6c')][_0x55fa('0x15')]({'phone':_0x54aec7[_0x55fa('0x32')]['phone'],'OrderBy':0x0},{'where':{'ContactId':_0x55326d['id']}});}})[_0x55fa('0x16')](function(){return _0x55326d;})[_0x55fa('0x16')](respondWithResult(_0x180d5d,null))[_0x55fa('0x1f')](handleError(_0x180d5d,null));};exports[_0x55fa('0x6d')]=function(_0x729670,_0x5c3bbc){var _0x57d0fc={};var _0x25c5a9={};var _0x5b0f15;var _0x246040;return db[_0x55fa('0x21')][_0x55fa('0x6e')]({'where':{'id':_0x729670[_0x55fa('0x22')]['id']}})['then'](handleEntityNotFound(_0x5c3bbc,null))[_0x55fa('0x16')](function(_0x5b9dcd){if(_0x5b9dcd){_0x5b0f15=_0x5b9dcd;_0x25c5a9[_0x55fa('0x6f')]=_[_0x55fa('0x24')](db[_0x55fa('0x5a')][_0x55fa('0x70')]);_0x25c5a9['query']=_[_0x55fa('0x24')](_0x729670['query']);_0x25c5a9[_0x55fa('0x71')]=_['intersection'](_0x25c5a9['model'],_0x25c5a9['query']);_0x57d0fc[_0x55fa('0x72')]=_[_0x55fa('0x73')](_0x25c5a9[_0x55fa('0x6f')],qs[_0x55fa('0x74')](_0x729670[_0x55fa('0x1d')][_0x55fa('0x74')]));_0x57d0fc[_0x55fa('0x72')]=_0x57d0fc['attributes']['length']?_0x57d0fc[_0x55fa('0x72')]:_0x25c5a9['model'];_0x57d0fc[_0x55fa('0x75')]=qs['sort'](_0x729670[_0x55fa('0x1d')][_0x55fa('0x76')]);_0x57d0fc[_0x55fa('0x52')]=qs[_0x55fa('0x71')](_[_0x55fa('0x77')](_0x729670[_0x55fa('0x1d')],_0x25c5a9[_0x55fa('0x71')]));if(_0x729670['query'][_0x55fa('0x78')]){_0x57d0fc[_0x55fa('0x52')]=_[_0x55fa('0x31')](_0x57d0fc[_0x55fa('0x52')],{'$or':_['map'](_0x57d0fc['attributes'],function(_0x4ce744){var _0x126c3f={};_0x126c3f[_0x4ce744]={'$like':'%'+_0x729670[_0x55fa('0x1d')]['filter']+'%'};return _0x126c3f;})});}_0x57d0fc=_[_0x55fa('0x31')]({},_0x57d0fc,_0x729670[_0x55fa('0x79')]);return _0x5b0f15[_0x55fa('0x6d')](_0x57d0fc);}})[_0x55fa('0x16')](function(_0x4cf8b8){if(_0x4cf8b8){_0x246040=_0x4cf8b8[_0x55fa('0x25')];if(!_0x729670[_0x55fa('0x1d')][_0x55fa('0x30')]('nolimit')){_0x57d0fc['limit']=qs[_0x55fa('0x11')](_0x729670['query'][_0x55fa('0x11')]);_0x57d0fc[_0x55fa('0xf')]=qs[_0x55fa('0xf')](_0x729670['query'][_0x55fa('0xf')]);}return _0x5b0f15[_0x55fa('0x6d')](_0x57d0fc);}})[_0x55fa('0x16')](function(_0x353c7e){if(_0x353c7e){return _0x353c7e?{'count':_0x246040,'rows':_0x353c7e}:null;}})[_0x55fa('0x16')](respondWithResult(_0x5c3bbc,null))[_0x55fa('0x1f')](handleError(_0x5c3bbc,null));};exports[_0x55fa('0x7a')]=function(_0x1196b3,_0x591c97){if(_0x1196b3[_0x55fa('0x32')]['id']){delete _0x1196b3['body']['id'];}return db['CmContact']['findOne']({'where':{'id':_0x1196b3['params']['id']}})[_0x55fa('0x16')](handleEntityNotFound(_0x591c97,null))[_0x55fa('0x16')](function(_0x1ba218){if(_0x1ba218){return _0x1ba218[_0x55fa('0x7a')](_0x1196b3[_0x55fa('0x32')][_0x55fa('0x7b')]||[]);}return null;})[_0x55fa('0x16')](respondWithResult(_0x591c97,null))['catch'](handleError(_0x591c97,null));};exports[_0x55fa('0x7c')]=function(_0x55cafc,_0x44aa9e){var _0x5268ca=[];_0x5268ca[_0x55fa('0x56')](addAdditionalPhones(_0x55cafc[_0x55fa('0x32')]));Promise[_0x55fa('0x57')](_0x5268ca)['then'](function(){_0x5268ca=[];_0x5268ca[_0x55fa('0x56')](deleteCmHopperPhones(_0x55cafc['body']['id']));_0x5268ca[_0x55fa('0x56')](addCmHopperPhones(_0x55cafc[_0x55fa('0x32')]['id']));Promise[_0x55fa('0x57')](_0x5268ca)['then'](function(){return[0x1];})[_0x55fa('0x16')](respondWithResult(_0x44aa9e,null));});};function addAdditionalPhones(_0x45791d){var _0x57d0e7;return new Promise(function(_0x4fcc18){return db[_0x55fa('0x7d')]['destroy']({'where':{'CmContactId':_0x45791d['id']}})['then'](function(){db['ContactItemType']['findAll']({'raw':!![],'attributes':['id',_0x55fa('0x7e')]})[_0x55fa('0x16')](function(_0x36cc15){var _0x520b09=[];for(var _0x1581a3=0x0;_0x1581a3<_0x45791d['items'][_0x55fa('0x25')];_0x1581a3++){var _0x5d8140=_0x45791d[_0x55fa('0x7f')]?_[_0x55fa('0x4d')](_0x45791d[_0x55fa('0x7f')][_0x1581a3])?'':_0x45791d['item_types'][_0x1581a3]:_0x45791d[_0x55fa('0x80')][_0x1581a3][_0x55fa('0x81')]?_0x45791d[_0x55fa('0x80')][_0x1581a3][_0x55fa('0x81')]:'';var _0x33e8d3=_[_0x55fa('0x4d')](_0x45791d['items'][_0x1581a3][_0x55fa('0x82')])?'':_0x45791d[_0x55fa('0x80')][_0x1581a3]['description'];var _0x5c834d=_0x5d8140+':'+_0x45791d[_0x55fa('0x80')][_0x1581a3][_0x55fa('0x6b')]+'ยง'+_0x33e8d3;if(_['isNil'](_0x57d0e7))_0x57d0e7=_0x5c834d;else _0x57d0e7+=';'+_0x5c834d;var _0x3a1e4d=null;var _0x5b4d89=null;if(_0x45791d[_0x55fa('0x7f')]){if(!_[_0x55fa('0x4d')](_0x45791d[_0x55fa('0x7f')][_0x1581a3])){_0x5b4d89=_[_0x55fa('0x59')](_0x36cc15,function(_0x346209){return _0x346209['id']===_0x45791d['item_types'][_0x1581a3];});if(!_['isNil'](_0x5b4d89)){_0x3a1e4d=_0x5b4d89['OrderBy'];}}}else{if(!_[_0x55fa('0x4d')](_0x45791d['items'][_0x1581a3])){_0x5b4d89=_[_0x55fa('0x59')](_0x36cc15,function(_0x3f6413){return _0x3f6413['id']===_0x45791d[_0x55fa('0x80')][_0x1581a3][_0x55fa('0x81')];});if(!_[_0x55fa('0x4d')](_0x5b4d89)){_0x3a1e4d=_0x1581a3;}}}if(_['isNil'](_0x3a1e4d)){_0x3a1e4d=0x64;}_0x520b09[_0x55fa('0x56')](addAdditionalPhone(_0x45791d['id'],_0x45791d['items'][_0x1581a3]['phone'],_0x45791d[_0x55fa('0x7f')]?_[_0x55fa('0x4d')](_0x45791d[_0x55fa('0x7f')][_0x1581a3])?null:_0x45791d[_0x55fa('0x7f')][_0x1581a3]:_0x45791d['items'][_0x1581a3][_0x55fa('0x81')]?_0x45791d[_0x55fa('0x80')][_0x1581a3][_0x55fa('0x81')]:null,_0x3a1e4d,_0x33e8d3));}Promise[_0x55fa('0x57')](_0x520b09)[_0x55fa('0x16')](function(){db['CmContact'][_0x55fa('0x15')]({'AdditionalPhones':_0x57d0e7},{'where':{'id':_0x45791d['id']}})[_0x55fa('0x16')](function(){_0x4fcc18(0x1);});});});});});}function addAdditionalPhone(_0x410ff2,_0x57f712,_0x1ac234,_0x553430,_0x1ef9b6){return db[_0x55fa('0x7d')][_0x55fa('0x59')]({'where':{'CmContactId':_0x410ff2,'item':_0x57f712}})[_0x55fa('0x16')](function(_0x43167e){if(_0x43167e)logger[_0x55fa('0x2d')]('contact\x20phone\x20exists',_0x43167e);else{db[_0x55fa('0x7d')][_0x55fa('0x3b')]({'CmContactId':_0x410ff2,'item':_0x57f712,'ItemTypeId':_0x1ac234,'OrderBy':_0x553430,'ItemClass':'PHONE','description':_0x1ef9b6});}});}function deleteCmHopperPhones(_0x401e99){return new Promise(function(_0x8ce4d1){return db['CmHopper']['findAll']({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x401e99}})['then'](function(_0x4b52af){db['CmHopperAdditionalPhone'][_0x55fa('0x20')]({'where':{'CmHopperId':{'$in':_[_0x55fa('0x63')](_0x4b52af,'id')}}});})[_0x55fa('0x16')](function(){_0x8ce4d1(0x1);});});}function addCmHopperPhones(_0x449f67){return new Promise(function(_0x9e8865){return db[_0x55fa('0x6c')][_0x55fa('0x1c')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x449f67}})[_0x55fa('0x16')](function(_0x51a06b){var _0x196ca8=[];_['map'](_0x51a06b,function(_0x36ab00){_0x196ca8[_0x55fa('0x56')](createCmHopperPhone(_0x449f67,_0x36ab00['id']));});Promise['all'](_0x196ca8)[_0x55fa('0x16')](function(){_0x9e8865(0x1);});});});}function createCmHopperPhone(_0x27f52b,_0x28d775){return new Promise(function(_0x4b0bee){db['CmContactHasItem'][_0x55fa('0x1c')]({'raw':!![],'attributes':[_0x55fa('0x83'),_0x55fa('0x7e')],'where':{'CmContactId':_0x27f52b,'ItemClass':_0x55fa('0x84')},'include':[{'model':db[_0x55fa('0x85')],'attributes':[_0x55fa('0x7e')],'as':'ItemType'}],'order':['OrderBy',db[_0x55fa('0x5e')][_0x55fa('0x86')](_0x55fa('0x87'))]})['then'](function(_0x4c9ff8){var _0x22bb00=0x1;var _0x4aa9f0=_['map'](_0x4c9ff8,function(_0x46fa77){_0x46fa77[_0x55fa('0x88')]=_0x28d775;_0x46fa77['phone']=_0x46fa77[_0x55fa('0x83')];_0x46fa77[_0x55fa('0x7e')]=_0x22bb00;delete _0x46fa77['ItemType.OrderBy'];_0x22bb00=_0x22bb00+0x1;return _0x46fa77;});return db[_0x55fa('0x89')]['bulkCreate'](_0x4aa9f0,{});})[_0x55fa('0x16')](function(){_0x4b0bee(0x1);});});}function insertAdditionalPhones(_0x33078c,_0x1fd0db){return new Promise(function(_0x15e42b){var _0x4c7c87=[];for(var _0x275d0c=0x0;_0x275d0c<_0x1fd0db['length'];_0x275d0c++){var _0x2cf226=_0x1fd0db[_0x275d0c];_0x4c7c87[_0x55fa('0x56')](parseContactItemType(_0x2cf226));}Promise['all'](_0x4c7c87)[_0x55fa('0x16')](function(){var _0x4b9a17={'id':_0x33078c['id'],'items':_0x1fd0db};return addAdditionalPhones(_0x4b9a17)['then'](function(){return addCmHopperPhones(_0x33078c['id']);});})[_0x55fa('0x16')](function(){_0x15e42b(_0x33078c);});});}function parseContactItemType(_0x5763e6){return new Promise(function(_0x510130){if(_0x5763e6[_0x55fa('0x30')](_0x55fa('0x81'))){_0x510130(_0x5763e6);}else{return db[_0x55fa('0x85')]['find']({'where':{'name':_0x5763e6[_0x55fa('0x5d')]}})['then'](function(_0x5516f9){if(_['isNil'](_0x5516f9))_0x5763e6[_0x55fa('0x81')]=null;else _0x5763e6[_0x55fa('0x81')]=_0x5516f9['id'];_0x510130(_0x5763e6);});}});}exports['getAdditionalPhones']=function(_0x340841,_0x56dbc5){return db[_0x55fa('0x7d')][_0x55fa('0x1c')]({'raw':!![],'where':{'CmContactId':_0x340841[_0x55fa('0x22')]['id'],'ItemClass':_0x55fa('0x84')},'include':[{'model':db['ContactItemType'],'as':_0x55fa('0x5d')}],'order':[['OrderBy'],[db[_0x55fa('0x5e')][_0x55fa('0x86')](_0x55fa('0x87'))]]})[_0x55fa('0x16')](function(_0x345352){return _0x345352;})[_0x55fa('0x16')](respondWithResult(_0x56dbc5,null))[_0x55fa('0x1f')](handleError(_0x56dbc5,null));};exports['duplicateAdditionalPhones']=function(_0x531a8f,_0xdbb0e7){return db[_0x55fa('0x7d')][_0x55fa('0x1c')]({'raw':!![],'where':{'CmContactId':_0x531a8f[_0x55fa('0x32')][_0x55fa('0x8a')]}})[_0x55fa('0x16')](function(_0x379542){var _0x492dc6=_[_0x55fa('0x63')](_0x379542,function(_0x4825ac){_0x4825ac[_0x55fa('0x8b')]=_0x531a8f['body'][_0x55fa('0x8c')];return _0x4825ac;});return db[_0x55fa('0x7d')][_0x55fa('0x8d')](_0x492dc6,{});})[_0x55fa('0x16')](function(){return addCmHopperPhones(_0x531a8f[_0x55fa('0x32')][_0x55fa('0x8c')]);})[_0x55fa('0x16')](function(){return['ok'];})[_0x55fa('0x16')](respondWithResult(_0xdbb0e7,null))[_0x55fa('0x1f')](handleError(_0xdbb0e7,null));};exports[_0x55fa('0x8e')]=function(_0x3aeb91,_0x12e59e){var _0xb6a6c9=[];_0xb6a6c9['push'](createCmHopperPhone(_0x3aeb91['body']['id'],_0x3aeb91[_0x55fa('0x32')][_0x55fa('0x8f')]));Promise[_0x55fa('0x57')](_0xb6a6c9)['then'](function(){return[0x1];})['then'](respondWithResult(_0x12e59e,null));};exports[_0x55fa('0x90')]=function(_0x21461d,_0x4a78a3){var _0x5222ae={'raw':![],'where':{}};var _0x3a88ab={};var _0x4211c7={'count':0x0,'rows':[]};return db[_0x55fa('0x21')][_0x55fa('0x6e')]({'where':{'id':_0x21461d['params']['id']}})[_0x55fa('0x16')](handleEntityNotFound(_0x4a78a3,null))['then'](function(_0x46e970){if(_0x46e970){_0x3a88ab[_0x55fa('0x6f')]=_[_0x55fa('0x24')](db[_0x55fa('0x6c')][_0x55fa('0x70')]);_0x3a88ab[_0x55fa('0x1d')]=_[_0x55fa('0x24')](_0x21461d['query']);_0x3a88ab[_0x55fa('0x71')]=_[_0x55fa('0x73')](_0x3a88ab[_0x55fa('0x6f')],_0x3a88ab[_0x55fa('0x1d')]);_0x5222ae[_0x55fa('0x72')]=_['intersection'](_0x3a88ab['model'],qs[_0x55fa('0x74')](_0x21461d[_0x55fa('0x1d')][_0x55fa('0x74')]));_0x5222ae[_0x55fa('0x72')]=_0x5222ae[_0x55fa('0x72')][_0x55fa('0x25')]?_0x5222ae[_0x55fa('0x72')]:_0x3a88ab[_0x55fa('0x6f')];if(!_0x21461d[_0x55fa('0x1d')]['hasOwnProperty'](_0x55fa('0x91'))){_0x5222ae[_0x55fa('0x11')]=qs[_0x55fa('0x11')](_0x21461d[_0x55fa('0x1d')][_0x55fa('0x11')]);_0x5222ae[_0x55fa('0xf')]=qs[_0x55fa('0xf')](_0x21461d[_0x55fa('0x1d')][_0x55fa('0xf')]);}_0x5222ae[_0x55fa('0x75')]=qs[_0x55fa('0x76')](_0x21461d[_0x55fa('0x1d')][_0x55fa('0x76')]);_0x5222ae[_0x55fa('0x52')]=qs['filters'](_['pick'](_0x21461d['query'],_0x3a88ab[_0x55fa('0x71')]));_0x5222ae[_0x55fa('0x52')][_0x55fa('0x92')]=_0x46e970['id'];if(_0x21461d[_0x55fa('0x1d')]['filter']){_0x5222ae[_0x55fa('0x52')]=_['merge'](_0x5222ae[_0x55fa('0x52')],{'$or':_[_0x55fa('0x63')](_0x5222ae[_0x55fa('0x72')],function(_0x49b826){var _0xececbe={};_0xececbe[_0x49b826]={'$like':'%'+_0x21461d[_0x55fa('0x1d')][_0x55fa('0x78')]+'%'};return _0xececbe;})});}_0x5222ae=_[_0x55fa('0x31')]({},_0x5222ae,_0x21461d[_0x55fa('0x79')]);return db[_0x55fa('0x6c')][_0x55fa('0x12')]({'where':_0x5222ae[_0x55fa('0x52')]})[_0x55fa('0x16')](function(_0x521ea2){_0x4211c7[_0x55fa('0x12')]=_0x521ea2;if(_0x21461d['query'][_0x55fa('0x93')]){_0x5222ae[_0x55fa('0x94')]=[{'all':!![]}];}return db['CmHopper'][_0x55fa('0x1c')](_0x5222ae);})[_0x55fa('0x16')](function(_0x3567d2){_0x4211c7[_0x55fa('0x95')]=_0x3567d2;return _0x4211c7;});}})[_0x55fa('0x16')](respondWithFilteredResult(_0x4a78a3,_0x5222ae))[_0x55fa('0x1f')](handleError(_0x4a78a3,null));};exports['getHopperHistories']=function(_0x5b2705,_0x16a177){var _0x28f7f7={'raw':!![],'where':{}};var _0x274818={};var _0x5cd28f={'count':0x0,'rows':[]};return db[_0x55fa('0x21')]['findOne']({'where':{'id':_0x5b2705[_0x55fa('0x22')]['id']}})['then'](handleEntityNotFound(_0x16a177,null))['then'](function(_0x37e7a4){if(_0x37e7a4){_0x274818[_0x55fa('0x6f')]=_[_0x55fa('0x24')](db['CmHopperHistory']['rawAttributes']);_0x274818['query']=_['keys'](_0x5b2705['query']);_0x274818[_0x55fa('0x71')]=_[_0x55fa('0x73')](_0x274818[_0x55fa('0x6f')],_0x274818[_0x55fa('0x1d')]);_0x28f7f7[_0x55fa('0x72')]=_[_0x55fa('0x73')](_0x274818['model'],qs['fields'](_0x5b2705[_0x55fa('0x1d')][_0x55fa('0x74')]));_0x28f7f7[_0x55fa('0x72')]=_0x28f7f7['attributes'][_0x55fa('0x25')]?_0x28f7f7[_0x55fa('0x72')]:_0x274818[_0x55fa('0x6f')];if(!_0x5b2705[_0x55fa('0x1d')][_0x55fa('0x30')]('nolimit')){_0x28f7f7[_0x55fa('0x11')]=qs[_0x55fa('0x11')](_0x5b2705['query'][_0x55fa('0x11')]);_0x28f7f7[_0x55fa('0xf')]=qs[_0x55fa('0xf')](_0x5b2705[_0x55fa('0x1d')][_0x55fa('0xf')]);}_0x28f7f7[_0x55fa('0x75')]=qs[_0x55fa('0x76')](_0x5b2705[_0x55fa('0x1d')][_0x55fa('0x76')]);_0x28f7f7['where']=qs[_0x55fa('0x71')](_[_0x55fa('0x77')](_0x5b2705[_0x55fa('0x1d')],_0x274818[_0x55fa('0x71')]));_0x28f7f7[_0x55fa('0x52')]['ContactId']=_0x37e7a4['id'];if(_0x5b2705[_0x55fa('0x1d')][_0x55fa('0x78')]){_0x28f7f7[_0x55fa('0x52')]=_[_0x55fa('0x31')](_0x28f7f7['where'],{'$or':_['map'](_0x28f7f7['attributes'],function(_0x2c1cd9){var _0x2b938b={};_0x2b938b[_0x2c1cd9]={'$like':'%'+_0x5b2705[_0x55fa('0x1d')][_0x55fa('0x78')]+'%'};return _0x2b938b;})});}_0x28f7f7=_[_0x55fa('0x31')]({},_0x28f7f7,_0x5b2705[_0x55fa('0x79')]);return db['CmHopperHistory'][_0x55fa('0x12')]({'where':_0x28f7f7[_0x55fa('0x52')]})[_0x55fa('0x16')](function(_0x2151ca){_0x5cd28f[_0x55fa('0x12')]=_0x2151ca;if(_0x5b2705[_0x55fa('0x1d')][_0x55fa('0x93')]){_0x28f7f7[_0x55fa('0x94')]=[{'all':!![]}];}return db[_0x55fa('0x46')][_0x55fa('0x1c')](_0x28f7f7);})[_0x55fa('0x16')](function(_0x3d4242){_0x5cd28f[_0x55fa('0x95')]=_0x3d4242;return _0x5cd28f;});}})[_0x55fa('0x16')](respondWithFilteredResult(_0x16a177,_0x28f7f7))[_0x55fa('0x1f')](handleError(_0x16a177,null));};exports[_0x55fa('0x96')]=function(_0x53bd4a,_0x4f054a){var _0x1a99e1={'raw':!![],'where':{}};var _0x1dc8f0={};var _0x1d27b6={'count':0x0,'rows':[]};return db[_0x55fa('0x21')]['findOne']({'where':{'id':_0x53bd4a[_0x55fa('0x22')]['id']}})[_0x55fa('0x16')](handleEntityNotFound(_0x4f054a,null))[_0x55fa('0x16')](function(_0x15e94e){if(_0x15e94e){_0x1dc8f0[_0x55fa('0x6f')]=_[_0x55fa('0x24')](db['CmHopperFinal'][_0x55fa('0x70')]);_0x1dc8f0[_0x55fa('0x1d')]=_[_0x55fa('0x24')](_0x53bd4a[_0x55fa('0x1d')]);_0x1dc8f0['filters']=_[_0x55fa('0x73')](_0x1dc8f0[_0x55fa('0x6f')],_0x1dc8f0[_0x55fa('0x1d')]);_0x1a99e1[_0x55fa('0x72')]=_[_0x55fa('0x73')](_0x1dc8f0[_0x55fa('0x6f')],qs[_0x55fa('0x74')](_0x53bd4a['query'][_0x55fa('0x74')]));_0x1a99e1[_0x55fa('0x72')]=_0x1a99e1[_0x55fa('0x72')][_0x55fa('0x25')]?_0x1a99e1[_0x55fa('0x72')]:_0x1dc8f0[_0x55fa('0x6f')];if(!_0x53bd4a['query'][_0x55fa('0x30')]('nolimit')){_0x1a99e1['limit']=qs[_0x55fa('0x11')](_0x53bd4a['query'][_0x55fa('0x11')]);_0x1a99e1['offset']=qs[_0x55fa('0xf')](_0x53bd4a['query']['offset']);}_0x1a99e1[_0x55fa('0x75')]=qs[_0x55fa('0x76')](_0x53bd4a[_0x55fa('0x1d')][_0x55fa('0x76')]);_0x1a99e1[_0x55fa('0x52')]=qs['filters'](_['pick'](_0x53bd4a[_0x55fa('0x1d')],_0x1dc8f0[_0x55fa('0x71')]));_0x1a99e1[_0x55fa('0x52')][_0x55fa('0x92')]=_0x15e94e['id'];if(_0x53bd4a['query'][_0x55fa('0x78')]){_0x1a99e1[_0x55fa('0x52')]=_[_0x55fa('0x31')](_0x1a99e1['where'],{'$or':_['map'](_0x1a99e1[_0x55fa('0x72')],function(_0x2555d0){var _0xcd2749={};_0xcd2749[_0x2555d0]={'$like':'%'+_0x53bd4a[_0x55fa('0x1d')][_0x55fa('0x78')]+'%'};return _0xcd2749;})});}_0x1a99e1=_[_0x55fa('0x31')]({},_0x1a99e1,_0x53bd4a[_0x55fa('0x79')]);return db[_0x55fa('0x45')][_0x55fa('0x12')]({'where':_0x1a99e1[_0x55fa('0x52')]})['then'](function(_0x362e3c){_0x1d27b6[_0x55fa('0x12')]=_0x362e3c;if(_0x53bd4a[_0x55fa('0x1d')][_0x55fa('0x93')]){_0x1a99e1[_0x55fa('0x94')]=[{'all':!![]}];}return db[_0x55fa('0x45')]['findAll'](_0x1a99e1);})[_0x55fa('0x16')](function(_0x3a8ec4){_0x1d27b6[_0x55fa('0x95')]=_0x3a8ec4;return _0x1d27b6;});}})[_0x55fa('0x16')](respondWithFilteredResult(_0x4f054a,_0x1a99e1))['catch'](handleError(_0x4f054a,null));};exports[_0x55fa('0x97')]=function(_0x1ed98f,_0x2c78b9){var _0xff0bba={'raw':!![],'where':{}};var _0x177b47={};var _0x56f160={'count':0x0,'rows':[]};return db['CmContact'][_0x55fa('0x6e')]({'where':{'id':_0x1ed98f[_0x55fa('0x22')]['id']}})['then'](handleEntityNotFound(_0x2c78b9,null))['then'](function(_0x59d7ce){if(_0x59d7ce){_0x177b47[_0x55fa('0x6f')]=_[_0x55fa('0x24')](db['JscriptySessionReport'][_0x55fa('0x70')]);_0x177b47[_0x55fa('0x1d')]=_[_0x55fa('0x24')](_0x1ed98f[_0x55fa('0x1d')]);_0x177b47['filters']=_['intersection'](_0x177b47[_0x55fa('0x6f')],_0x177b47[_0x55fa('0x1d')]);_0xff0bba[_0x55fa('0x72')]=_[_0x55fa('0x73')](_0x177b47['model'],qs[_0x55fa('0x74')](_0x1ed98f['query'][_0x55fa('0x74')]));_0xff0bba['attributes']=_0xff0bba[_0x55fa('0x72')][_0x55fa('0x25')]?_0xff0bba[_0x55fa('0x72')]:_0x177b47[_0x55fa('0x6f')];if(!_0x1ed98f[_0x55fa('0x1d')][_0x55fa('0x30')]('nolimit')){_0xff0bba[_0x55fa('0x11')]=qs[_0x55fa('0x11')](_0x1ed98f[_0x55fa('0x1d')][_0x55fa('0x11')]);_0xff0bba[_0x55fa('0xf')]=qs[_0x55fa('0xf')](_0x1ed98f[_0x55fa('0x1d')][_0x55fa('0xf')]);}_0xff0bba[_0x55fa('0x75')]=qs[_0x55fa('0x76')](_0x1ed98f[_0x55fa('0x1d')][_0x55fa('0x76')]);_0xff0bba['where']=qs[_0x55fa('0x71')](_['pick'](_0x1ed98f[_0x55fa('0x1d')],_0x177b47[_0x55fa('0x71')]));_0xff0bba[_0x55fa('0x52')][_0x55fa('0x92')]=_0x59d7ce['id'];if(_0x1ed98f[_0x55fa('0x1d')][_0x55fa('0x78')]){_0xff0bba[_0x55fa('0x52')]=_[_0x55fa('0x31')](_0xff0bba['where'],{'$or':_[_0x55fa('0x63')](_0xff0bba[_0x55fa('0x72')],function(_0x2f8869){var _0x4008b4={};_0x4008b4[_0x2f8869]={'$like':'%'+_0x1ed98f[_0x55fa('0x1d')][_0x55fa('0x78')]+'%'};return _0x4008b4;})});}_0xff0bba=_[_0x55fa('0x31')]({},_0xff0bba,_0x1ed98f['options']);return db[_0x55fa('0x98')][_0x55fa('0x12')]({'where':_0xff0bba[_0x55fa('0x52')]})['then'](function(_0x22b792){_0x56f160[_0x55fa('0x12')]=_0x22b792;if(_0x1ed98f[_0x55fa('0x1d')]['includeAll']){_0xff0bba[_0x55fa('0x94')]=[{'all':!![]}];}return db[_0x55fa('0x98')]['findAll'](_0xff0bba);})[_0x55fa('0x16')](function(_0x3a14ab){_0x56f160[_0x55fa('0x95')]=_0x3a14ab;return _0x56f160;});}})[_0x55fa('0x16')](respondWithFilteredResult(_0x2c78b9,_0xff0bba))[_0x55fa('0x1f')](handleError(_0x2c78b9,null));};exports[_0x55fa('0x99')]=function(_0x18a86a,_0x3b3ac9){try{if(!_0x18a86a['body']['ListId']){throw new Error(_0x55fa('0x9a'));}if(!_0x18a86a[_0x55fa('0x32')][_0x55fa('0x9b')]){throw new Error(_0x55fa('0x9c'));}if(!_0x18a86a[_0x55fa('0x32')][_0x55fa('0x9d')]){throw new Error(_0x55fa('0x9e'));}if(!_0x18a86a[_0x55fa('0x32')]['socket_timestamp']){throw new Error(_0x55fa('0x9f'));}var _0x4b720a=_0x18a86a['body'][_0x55fa('0x9b')][_0x55fa('0xa0')](',');var _0x3b4f3f=_0x18a86a['body'][_0x55fa('0x9d')]['split'](',');if(!_0x4b720a[_0x55fa('0x25')]||!_0x3b4f3f[_0x55fa('0x25')]||_0x4b720a[_0x55fa('0x25')]!==_0x3b4f3f[_0x55fa('0x25')]){throw new Error(_0x55fa('0xa1'));}_0x18a86a[_0x55fa('0x32')][_0x55fa('0x74')]=_[_0x55fa('0xa2')](_0x4b720a,_0x3b4f3f);if(!_0x18a86a[_0x55fa('0x32')][_0x55fa('0x74')]['phone']){throw new Error(_0x55fa('0xa3'));}if(!_0x18a86a[_0x55fa('0x32')]['fields']['firstName']){throw new Error('No\x20firstName\x20column\x20specified');}var _0x42b6c8=path[_0x55fa('0x36')](config[_0x55fa('0xa4')],'server/files/tmp',_0x18a86a[_0x55fa('0xa5')][_0x55fa('0xa6')]);fs[_0x55fa('0xa7')](_0x42b6c8,parseInt(_0x55fa('0xa8'),0x8));var _0xb0b63d=require(_0x55fa('0xa9'))[_0x55fa('0xaa')](path['join'](__dirname,_0x55fa('0xab')),[_0x42b6c8,_0x18a86a['body']['binding_keys'],_0x18a86a[_0x55fa('0x32')]['binding_values'],_0x18a86a[_0x55fa('0x32')][_0x55fa('0x54')],_0x18a86a['body'][_0x55fa('0xac')],_0x18a86a[_0x55fa('0x32')][_0x55fa('0x51')],_0x18a86a[_0x55fa('0x32')][_0x55fa('0xad')]]);return _0x3b3ac9[_0x55fa('0x13')](0xc8)[_0x55fa('0xe')]({'message':'File\x20uploaded\x20correctly!','pid':_0xb0b63d[_0x55fa('0xae')]});}catch(_0x5596b7){return _0x3b3ac9[_0x55fa('0x13')](0x1f4)[_0x55fa('0xaf')](_0x5596b7);}};exports['upload']=function(_0x349d3d,_0x29630b){var _0x584cac=fs['createReadStream'](_0x349d3d[_0x55fa('0xa5')][_0x55fa('0x2')]);Papa['parse'](_0x584cac,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x3f036a){return _0x29630b[_0x55fa('0x13')](0xc8)[_0x55fa('0xe')]({'file':_0x349d3d[_0x55fa('0xa5')],'fields':_0x3f036a[_0x55fa('0xb0')][_0x55fa('0x74')]});}});};exports['import']=function(_0x547648,_0x38aa33){return db[_0x55fa('0xb1')][_0x55fa('0x1c')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0x55fa('0x16')](function(_0x320aa2){var _0x2d5124=![];if(!_0x547648[_0x55fa('0x32')][_0x55fa('0x54')]){throw new Error(_0x55fa('0x9a'));}if(!_0x547648[_0x55fa('0x32')]['binding'][_0x55fa('0x6b')]){throw new Error(_0x55fa('0xa3'));}if(!_0x547648[_0x55fa('0x32')][_0x55fa('0xb2')][_0x55fa('0xb3')]){throw new Error(_0x55fa('0xb4'));}if(!_0x547648[_0x55fa('0x32')]['socket_timestamp']){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x22b684=require('child_process')[_0x55fa('0xaa')](path[_0x55fa('0x36')](__dirname,'../../components/import/cm/csv2'),[_0x547648['params']['id'],JSON[_0x55fa('0xb5')](_0x547648['body']),JSON[_0x55fa('0xb5')](_0x320aa2)]);_0x22b684['on'](_0x55fa('0xb6'),function(){_0x2d5124=!![];return _0x38aa33[_0x55fa('0x13')](0xc8)[_0x55fa('0xe')]({'message':_0x55fa('0xb7'),'pid':_0x22b684['pid']});});_0x22b684['on'](_0x55fa('0xb8'),function(_0x9c6ac4){if(_0x9c6ac4&&!_0x2d5124){return _0x38aa33[_0x55fa('0x13')](0x1f4)[_0x55fa('0xe')]({'message':_0x55fa('0xb9'),'pid':_0x22b684[_0x55fa('0xae')]});}});})[_0x55fa('0x1f')](handleError(_0x38aa33,null));};exports['importUpdates']=function(_0xc23580,_0x47d0c3){return db[_0x55fa('0xb1')][_0x55fa('0x1c')]({'raw':!![],'attributes':['id'],'where':{'role':_0x55fa('0xba')}})[_0x55fa('0x16')](function(_0x1c5a1f){var _0x5c1293=![];if(!_0xc23580[_0x55fa('0x32')][_0x55fa('0x54')]){throw new Error('No\x20ListId\x20specified');}if(!_0xc23580[_0x55fa('0x32')][_0x55fa('0xb2')]['phone']){throw new Error(_0x55fa('0xa3'));}if(!_0xc23580[_0x55fa('0x32')][_0x55fa('0xb2')][_0x55fa('0xb3')]){throw new Error(_0x55fa('0xb4'));}if(!_0xc23580['body'][_0x55fa('0xad')]){throw new Error(_0x55fa('0x9f'));}var _0x5c1ccc=require('child_process')[_0x55fa('0xaa')](path[_0x55fa('0x36')](__dirname,_0x55fa('0xbb')),[_0xc23580['params']['id'],JSON[_0x55fa('0xb5')](_0xc23580['body']),JSON[_0x55fa('0xb5')](_0x1c5a1f)]);_0x5c1ccc['on'](_0x55fa('0xb6'),function(){_0x5c1293=!![];return _0x47d0c3['status'](0xc8)[_0x55fa('0xe')]({'message':'start\x20child\x20process\x20correctly!','pid':_0x5c1ccc[_0x55fa('0xae')]});});_0x5c1ccc['on']('exit',function(_0x2b50ee){if(_0x2b50ee&&!_0x5c1293){return _0x47d0c3[_0x55fa('0x13')](0x1f4)[_0x55fa('0xe')]({'message':'error\x20child\x20process','pid':_0x5c1ccc['pid']});}});})[_0x55fa('0x1f')](handleError(_0x47d0c3,null));};exports[_0x55fa('0xbc')]=function(_0x3a2755,_0x4726e6){var _0x23a1a8=['mail','chat',_0x55fa('0xbd'),'openchannel',_0x55fa('0xbe'),_0x55fa('0xbf'),'voice'];var _0x5d5b01={'offset':0x0,'order':qs[_0x55fa('0x76')]('-createdAt')},_0x566c83={'count':0x0,'rows':[]};Promise[_0x55fa('0xc0')]()['then'](function(){if(_0x3a2755[_0x55fa('0x1d')]['channel']){if(!_[_0x55fa('0xc1')](_0x23a1a8,_0x3a2755[_0x55fa('0x1d')]['channel'][_0x55fa('0xc2')]())){throw new Error(_0x55fa('0xc3'));}_0x23a1a8=[_0x3a2755[_0x55fa('0x1d')]['channel'][_0x55fa('0xc2')]()];}if(_0x3a2755['query'][_0x55fa('0xc4')]){try{var _0x3f5865=JSON[_0x55fa('0xc5')](_0x3a2755[_0x55fa('0x1d')]['range']);if(!moment(_0x3f5865['from'])[_0x55fa('0xc6')]()){throw new Error('Invalid\x20date\x20for\x20range\x20from\x20filter');}if(!moment(_0x3f5865['to'])['isValid']()){throw new Error(_0x55fa('0xc7'));}}catch(_0x5326bf){throw new Error('Invalid\x20createdAt\x20filter');}}if(!_0x3a2755[_0x55fa('0x1d')][_0x55fa('0x30')](_0x55fa('0x91'))){_0x5d5b01[_0x55fa('0x11')]=qs[_0x55fa('0x11')](_0x3a2755['query'][_0x55fa('0x11')]||0xa);_0x5d5b01[_0x55fa('0xf')]=qs['offset'](_0x3a2755['query'][_0x55fa('0xf')]);}var _0x320924=_0x23a1a8[_0x55fa('0x63')](function(_0x31aaef){if(_0x31aaef===_0x55fa('0xc8')){var _0x904bae={'attributes':['id','uniqueid','type',_0x55fa('0xc9'),_0x55fa('0xca'),_0x55fa('0xcb'),_0x55fa('0xcc'),'endtime',_0x55fa('0xcd'),'note','createdAt','userDisposition',_0x55fa('0xce'),'userThirdDisposition',_0x55fa('0xcf')],'where':{'ContactId':_0x3a2755[_0x55fa('0x22')]['id']},'include':[{'model':db[_0x55fa('0xb1')],'as':_0x55fa('0xb1'),'attributes':['id',_0x55fa('0x19'),_0x55fa('0xd0'),'alias']}],'order':[[_0x55fa('0xd1'),_0x55fa('0xd2')]]};if(_0x3a2755['query'][_0x55fa('0xc4')]){_0x904bae[_0x55fa('0x52')][_0x55fa('0xd1')]={'$gte':_0x3f5865[_0x55fa('0x38')],'$lte':_0x3f5865['to']};}return db['VoiceCallReport'][_0x55fa('0xd3')](_0x904bae)[_0x55fa('0x16')](function(_0x369eb9){_0x566c83[_0x55fa('0x12')]+=_0x369eb9[_0x55fa('0x12')];return _[_0x55fa('0x63')](_0x369eb9[_0x55fa('0x95')],function(_0x589efb){var _0x4365f9=_0x589efb[_0x55fa('0x33')]({'plain':!![]});_0x4365f9[_0x55fa('0xd4')]=_0x31aaef;if(_0x4365f9[_0x55fa('0xb1')]){_0x4365f9[_0x55fa('0xb1')]={'id':_0x4365f9[_0x55fa('0xb1')]['id'],'name':_0x4365f9[_0x55fa('0xb1')][_0x55fa('0x19')],'fullname':_0x4365f9[_0x55fa('0xb1')][_0x55fa('0xd0')],'alias':_0x4365f9[_0x55fa('0xb1')]['alias']};}return _0x4365f9;});});}else{var _0x29fc64=_[_0x55fa('0xd5')](_0x31aaef)+(_0x31aaef===_0x55fa('0xd6')?_0x55fa('0xd7'):_0x55fa('0xd8'));var _0x431a61={'attributes':['id','closed','closedAt',_0x55fa('0xd1'),_0x55fa('0xd9'),_0x55fa('0xda'),_0x55fa('0xdb'),_0x55fa('0xdc'),_0x55fa('0xcf'),_0x29fc64+'Id'],'where':{'ContactId':_0x3a2755[_0x55fa('0x22')]['id']},'include':[{'model':db[_0x29fc64],'as':_0x55fa('0xd8'),'attributes':['id','name',_0x55fa('0xdd')]},{'model':db[_0x55fa('0xb1')],'as':'Owner','attributes':['id','name',_0x55fa('0xd0')]},{'model':db[_0x55fa('0x5a')],'as':_0x55fa('0x5b'),'attributes':['id','name',_0x55fa('0xde')],'through':{'attributes':[]}}],'order':[[_0x55fa('0xd1'),_0x55fa('0xd2')]]};if(_0x3a2755['query'][_0x55fa('0xc4')]){_0x431a61['where']['createdAt']={'$gte':_0x3f5865[_0x55fa('0x38')],'$lte':_0x3f5865['to']};}switch(_0x31aaef){case _0x55fa('0xd6'):_0x431a61[_0x55fa('0x72')][_0x55fa('0x56')]('browserName',_0x55fa('0xdf'),'customerPort',_0x55fa('0xe0'),'osName','ratingMessage','ratingType',_0x55fa('0xe1'),_0x55fa('0xe2'));break;case'mail':_0x431a61['attributes'][_0x55fa('0x56')](_0x55fa('0xe3'),_0x55fa('0xe4'));break;case _0x55fa('0xe5'):_0x431a61[_0x55fa('0x72')]['push'](_0x55fa('0xe6'),_0x55fa('0xe7'));break;}return db[_[_0x55fa('0xd5')](_0x31aaef)+_0x55fa('0xe8')]['findAndCountAll'](_0x431a61)[_0x55fa('0x16')](function(_0xbe29ed){_0x566c83[_0x55fa('0x12')]+=_0xbe29ed[_0x55fa('0x12')];return _[_0x55fa('0x63')](_0xbe29ed[_0x55fa('0x95')],function(_0x316681){var _0xa76463=_0x316681['get']({'plain':!![]});_0xa76463['channel']=_0x31aaef;if(_0xa76463[_0x55fa('0xe9')]){_0xa76463['Owner']={'id':_0xa76463[_0x55fa('0xe9')]['id'],'name':_0xa76463[_0x55fa('0xe9')]['name'],'fullname':_0xa76463[_0x55fa('0xe9')][_0x55fa('0xd0')]};}return _0xa76463;});});}});return Promise['all'](_0x320924);})[_0x55fa('0x16')](function(_0x4d3c6c){return _(_0x4d3c6c)[_0x55fa('0xea')]()['sortBy'](_0x55fa('0xd1'))[_0x55fa('0xeb')]()['value']();})[_0x55fa('0x16')](function(_0x18ca69){_0x566c83[_0x55fa('0x95')]=_0x5d5b01['limit']?_0x18ca69[_0x55fa('0xec')](_0x5d5b01[_0x55fa('0xf')],_0x5d5b01[_0x55fa('0xf')]+_0x5d5b01[_0x55fa('0x11')]):_0x18ca69;return _0x566c83;})[_0x55fa('0x16')](respondWithFilteredResult(_0x4726e6,_0x5d5b01))[_0x55fa('0x1f')](handleError(_0x4726e6,null));};
git://repos.xcallymotion.com / motion2.git / blob