// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x28e3=['hopperId','getHoppers','pick','ContactId','filter','includeAll','include','rows','getHopperHistories','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','No\x20firstName\x20column\x20specified','root','server/files/tmp','file','filename','0777','fork','CompanyId','socket_timestamp','json','File\x20uploaded\x20correctly!','pid','upload','createReadStream','parse','meta','import','User','agent','binding','No\x20phone\x20column\x20specified','firstName','child_process','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','exit','error\x20child\x20process','importUpdates','../../components/import/cm/csvUpdates','getJourney','mail','openchannel','fax','whatsapp','-createdAt','resolve','includes','channel','toLowerCase','range','Invalid\x20date\x20for\x20range\x20from\x20filter','isValid','Invalid\x20createdAt\x20filter','voice','uniqueid','source','destination','callerid','endtime','duration','note','createdAt','userSecondDisposition','userThirdDisposition','UserId','fullname','alias','DESC','startCase','chat','Website','Account','closed','closedAt','disposition','secondDisposition','thirdDisposition','key','Owner','browserName','customerIp','deviceModel','ratingMessage','ratingValue','referer','subject','substatus','externalUrl','threadId','Interaction','findAndCountAll','sortBy','reverse','slice','bluebird','path','lodash','squel','papaparse','ioredis','../../components/contacts','../../components/parsers/qs','api','../../config/environment','redis','defaults','localhost','socket.io-emitter','./cmContact.socket','register','status','offset','limit','undefined','count','set','Content-Range','update','then','destroy','end','error','stack','name','send','describe','getOptions','query','user','catch','params','CmContact','keys','length','startsWith','columnName','displayName','analytics','CmCustomField','findAll','custom','type','values','Custom\x20field\x20%s\x20not\x20found\x20on\x20cm_contacts\x20table','forEach','merge','body','from','get','isArray','tags','join','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','MailQueueReport','SmsQueueReport','WhatsappInteraction','WhatsappMessage','WhatsappQueueReport','dialTimezone','isNil','timezones','utcOffset','additionalPhones','bulkCreate','each','duplicates','where','$or','push','ListId','spread','hasOwnProperty','contact','all','show','find','Tag','Tags','color','CmContactHasItem','Phones','ContactItemType','sequelize','Phones.OrderBy','$and','map','cf_%d','omit','pickBy','cf_','table','cm_contacts','setFields','text','phone','CmHopper','findOne','model','rawAttributes','filters','intersection','attributes','fields','order','sort','options','getTags','nolimit','setTags','items','item_types','ItemTypeId','description','OrderBy','PHONE','literal','CmHopperId','item','ItemType.OrderBy','CmHopperAdditionalPhone','ItemType','getAdditionalPhones','`ItemType`.OrderBy','duplicateAdditionalPhones','fromContactId','CmContactId','toContactId'];(function(_0x4131e6,_0x5f4a78){var _0x1f02b3=function(_0x23379e){while(--_0x23379e){_0x4131e6['push'](_0x4131e6['shift']());}};_0x1f02b3(++_0x5f4a78);}(_0x28e3,0x16b));var _0x328e=function(_0x543084,_0x4337f5){_0x543084=_0x543084-0x0;var _0x306a57=_0x28e3[_0x543084];return _0x306a57;};'use strict';var moment=require('moment');var BPromise=require(_0x328e('0x0'));var util=require('util');var path=require(_0x328e('0x1'));var fs=require('fs');var _=require(_0x328e('0x2'));var squel=require(_0x328e('0x3'));var Papa=require(_0x328e('0x4'));var Redis=require(_0x328e('0x5'));var contacts=require(_0x328e('0x6'));var qs=require(_0x328e('0x7'));var logger=require('../../config/logger')(_0x328e('0x8'));var config=require(_0x328e('0x9'));var shared=require('../../config/environment/shared');var db=require('../../mysqldb')['db'];config[_0x328e('0xa')]=_[_0x328e('0xb')](config[_0x328e('0xa')],{'host':_0x328e('0xc'),'port':0x18eb});var socket=require(_0x328e('0xd'))(new Redis(config[_0x328e('0xa')]));require(_0x328e('0xe'))[_0x328e('0xf')](socket);function respondWithResult(_0x23be81,_0x19cb57){_0x19cb57=_0x19cb57||0xc8;return function(_0x4caf4f){if(_0x4caf4f){return _0x23be81[_0x328e('0x10')](_0x19cb57)['json'](_0x4caf4f);}};}function respondWithFilteredResult(_0xbc92e9,_0x36151a){return function(_0x271537){if(_0x271537){var _0x930f21=typeof _0x36151a[_0x328e('0x11')]==='undefined'&&typeof _0x36151a[_0x328e('0x12')]===_0x328e('0x13');var _0x1ed7b4=_0x271537[_0x328e('0x14')];var _0x1ef2da=_0x930f21?0x0:_0x36151a[_0x328e('0x11')];var _0x1e226d=_0x930f21?_0x271537[_0x328e('0x14')]:_0x36151a[_0x328e('0x11')]+_0x36151a[_0x328e('0x12')];var _0xa09a3f;if(_0x1e226d>=_0x1ed7b4){_0x1e226d=_0x1ed7b4;_0xa09a3f=0xc8;}else{_0xa09a3f=0xce;}_0xbc92e9[_0x328e('0x10')](_0xa09a3f);return _0xbc92e9[_0x328e('0x15')](_0x328e('0x16'),_0x1ef2da+'-'+_0x1e226d+'/'+_0x1ed7b4)['json'](_0x271537);}return null;};}function saveUpdates(_0x32f1ad){return function(_0x44d50b){if(_0x44d50b){return _0x44d50b[_0x328e('0x17')](_0x32f1ad)[_0x328e('0x18')](function(_0x23a963){return _0x23a963;});}return null;};}function removeEntity(_0x230991){return function(_0x29053b){if(_0x29053b){return _0x29053b[_0x328e('0x19')]()['then'](function(){_0x230991['status'](0xcc)[_0x328e('0x1a')]();});}};}function handleEntityNotFound(_0x2852a5){return function(_0x456754){if(!_0x456754){_0x2852a5['sendStatus'](0x194);}return _0x456754;};}function handleError(_0x5c8eff,_0x10fd69){_0x10fd69=_0x10fd69||0x1f4;return function(_0x3d3b03){logger[_0x328e('0x1b')](_0x3d3b03[_0x328e('0x1c')]);if(_0x3d3b03['name']){delete _0x3d3b03[_0x328e('0x1d')];}_0x5c8eff[_0x328e('0x10')](_0x10fd69)[_0x328e('0x1e')](_0x3d3b03);};}exports['index']=function(_0x3f762d,_0x47275d){var _0x13eb35={};return contacts[_0x328e('0x1f')]()['then'](function(_0x1a0141){_0x13eb35=qs[_0x328e('0x20')](_0x1a0141,_0x3f762d);return contacts['findAll'](_0x3f762d[_0x328e('0x21')],_0x3f762d[_0x328e('0x22')],_0x13eb35,_0x1a0141);})[_0x328e('0x18')](respondWithFilteredResult(_0x47275d,_0x13eb35))[_0x328e('0x23')](handleError(_0x47275d,null));};exports[_0x328e('0x19')]=function(_0x2adcef,_0x3bf812){return db['CmContact']['find']({'where':{'id':_0x2adcef[_0x328e('0x24')]['id']}})[_0x328e('0x18')](handleEntityNotFound(_0x3bf812,null))[_0x328e('0x18')](removeEntity(_0x3bf812,null))[_0x328e('0x23')](handleError(_0x3bf812,null));};exports[_0x328e('0x1f')]=function(_0x65a865,_0x36d844){return db[_0x328e('0x25')][_0x328e('0x1f')]()[_0x328e('0x18')](function(_0x5b2a58){delete _0x5b2a58['tags'];for(var _0x4d022a=0x0;_0x4d022a<Object[_0x328e('0x26')](_0x5b2a58)[_0x328e('0x27')];_0x4d022a++){var _0x12b39f=Object[_0x328e('0x26')](_0x5b2a58)[_0x4d022a];if(!_[_0x328e('0x28')](_0x12b39f,'cf_')){_0x5b2a58[_0x12b39f][_0x328e('0x29')]=_0x12b39f;_0x5b2a58[_0x12b39f][_0x328e('0x2a')]=_0x12b39f;}}return _0x5b2a58;})[_0x328e('0x18')](function(_0xb3bbaa){var _0x532281={'where':Boolean(_0x65a865[_0x328e('0x21')][_0x328e('0x2b')])===!![]?undefined:{'$or':[{'ListId':_0x65a865[_0x328e('0x21')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x328e('0x2c')][_0x328e('0x2d')](_0x532281)[_0x328e('0x18')](function(_0x10c1b0){for(var _0x34ddcc=0x0;_0x34ddcc<_0x10c1b0['length'];_0x34ddcc++){var _0x1d5c1a='cf_'+_0x10c1b0[_0x34ddcc]['id'];if(_0xb3bbaa[_0x1d5c1a]){_0xb3bbaa[_0x1d5c1a]['columnName']=_0x1d5c1a;_0xb3bbaa[_0x1d5c1a][_0x328e('0x2a')]=_0x10c1b0[_0x34ddcc]['alias'];_0xb3bbaa[_0x1d5c1a][_0x328e('0x2e')]={'type':_0x10c1b0[_0x34ddcc][_0x328e('0x2f')],'values':_0x10c1b0[_0x34ddcc][_0x328e('0x30')]};}else{logger['info'](_0x328e('0x31'),_0x1d5c1a);}}Object['keys'](_0xb3bbaa)[_0x328e('0x32')](function(_0x2d79df){if(!_0xb3bbaa[_0x2d79df]['hasOwnProperty'](_0x328e('0x29'))){delete _0xb3bbaa[_0x2d79df];}});return _0xb3bbaa;});})[_0x328e('0x18')](respondWithResult(_0x36d844,null))[_0x328e('0x23')](handleError(_0x36d844,null));};exports[_0x328e('0x33')]=function(_0x502dd4,_0x1e37e9){var _0xb726b5;var _0x748c42;var _0x3ba886;if(_0x502dd4[_0x328e('0x34')]['id']){delete _0x502dd4[_0x328e('0x34')]['id'];}return db[_0x328e('0x25')][_0x328e('0x2d')]({'where':{'id':[_0x502dd4[_0x328e('0x34')]['to'],_0x502dd4[_0x328e('0x34')][_0x328e('0x35')]]}})[_0x328e('0x18')](function(_0x167b94){if(_0x167b94){if(_0x167b94['length']!==0x2){return null;}_0x167b94[0x0]=_0x167b94[0x0][_0x328e('0x36')]({'plain':!![]});_0x167b94[0x1]=_0x167b94[0x1][_0x328e('0x36')]({'plain':!![]});delete _0x167b94[0x0]['id'];delete _0x167b94[0x1]['id'];return _['mergeWith'](_0x167b94[0x0],_0x167b94[0x1],function(_0xcec4e8,_0x26956d){if(Array[_0x328e('0x37')](_0x26956d)&&!_0x26956d['length']){return _0xcec4e8;}else if(!_0x26956d){return _0xcec4e8;}});}})[_0x328e('0x18')](handleEntityNotFound(_0x1e37e9,null))[_0x328e('0x18')](function(_0x4ff26c){if(_0x4ff26c){if(_0x4ff26c[_0x328e('0x38')]&&_['isArray'](_0x4ff26c[_0x328e('0x38')])){_0x4ff26c[_0x328e('0x38')]=_0x4ff26c[_0x328e('0x38')][_0x328e('0x39')]();}logger[_0x328e('0x3a')](_0x328e('0x3b'),_0x502dd4[_0x328e('0x34')]['to'],_0x502dd4[_0x328e('0x34')][_0x328e('0x35')]);return db['CmHopper']['destroy']({'where':{'ContactId':[_0x502dd4[_0x328e('0x34')]['to'],_0x502dd4[_0x328e('0x34')][_0x328e('0x35')]]}})[_0x328e('0x18')](function(_0x233847){logger[_0x328e('0x3a')](_0x328e('0x3c'),_0x233847);return db[_0x328e('0x3d')][_0x328e('0x19')]({'where':{'ContactId':[_0x502dd4[_0x328e('0x34')]['to'],_0x502dd4[_0x328e('0x34')][_0x328e('0x35')]]}})[_0x328e('0x18')](function(_0x2bbfb4){logger[_0x328e('0x3a')](_0x328e('0x3e'),_0x2bbfb4);return db[_0x328e('0x25')][_0x328e('0x3f')](_0x4ff26c);});});}})[_0x328e('0x18')](function(_0x156443){if(_0x156443){_0xb726b5=_0x156443;_0x748c42={'ContactId':_0xb726b5['id']};_0x3ba886={'where':{'ContactId':[_0x502dd4['body']['to'],_0x502dd4[_0x328e('0x34')][_0x328e('0x35')]]}};return db[_0x328e('0x40')][_0x328e('0x17')](_0x748c42,_0x3ba886);}})[_0x328e('0x18')](function(){if(_0xb726b5){return db['ChatMessage'][_0x328e('0x17')](_0x748c42,_0x3ba886);}})[_0x328e('0x18')](function(){if(_0xb726b5){return db[_0x328e('0x41')]['update'](_0x748c42,_0x3ba886);}})['then'](function(){if(_0xb726b5){return db[_0x328e('0x42')]['update'](_0x748c42,_0x3ba886);}})[_0x328e('0x18')](function(){if(_0xb726b5){return db[_0x328e('0x43')][_0x328e('0x17')](_0x748c42,_0x3ba886);}})[_0x328e('0x18')](function(){if(_0xb726b5){return db[_0x328e('0x42')][_0x328e('0x17')](_0x748c42,_0x3ba886);}})['then'](function(){if(_0xb726b5){return db[_0x328e('0x43')][_0x328e('0x17')](_0x748c42,_0x3ba886);}})[_0x328e('0x18')](function(){if(_0xb726b5){return db[_0x328e('0x44')]['update'](_0x748c42,_0x3ba886);}})[_0x328e('0x18')](function(){if(_0xb726b5){return db[_0x328e('0x45')][_0x328e('0x17')](_0x748c42,_0x3ba886);}})[_0x328e('0x18')](function(){if(_0xb726b5){return db[_0x328e('0x46')][_0x328e('0x17')](_0x748c42,_0x3ba886);}})[_0x328e('0x18')](function(){if(_0xb726b5){return db[_0x328e('0x47')]['update'](_0x748c42,_0x3ba886);}})[_0x328e('0x18')](function(){if(_0xb726b5){return db[_0x328e('0x48')]['update'](_0x748c42,_0x3ba886);}})['then'](function(){if(_0xb726b5){return db[_0x328e('0x49')]['update'](_0x748c42,_0x3ba886);}})[_0x328e('0x18')](function(){if(_0xb726b5){return db['CmContactHasItem'][_0x328e('0x17')]({'CmContactId':_0xb726b5['id']},{'where':{'CmContactId':[_0x502dd4[_0x328e('0x34')]['to'],_0x502dd4['body'][_0x328e('0x35')]]}});}})['then'](function(){if(_0xb726b5){return db[_0x328e('0x4a')][_0x328e('0x17')](_0x748c42,_0x3ba886);}})[_0x328e('0x18')](function(){if(_0xb726b5){return db[_0x328e('0x4b')][_0x328e('0x17')](_0x748c42,_0x3ba886);}})[_0x328e('0x18')](function(){if(_0xb726b5){return db[_0x328e('0x4c')][_0x328e('0x17')](_0x748c42,_0x3ba886);}})[_0x328e('0x18')](function(){if(_0xb726b5){return db[_0x328e('0x4d')][_0x328e('0x17')](_0x748c42,_0x3ba886);}})['then'](function(){if(_0xb726b5){return db[_0x328e('0x4e')][_0x328e('0x17')](_0x748c42,_0x3ba886);}})[_0x328e('0x18')](function(){if(_0xb726b5){return db['FaxQueueReport'][_0x328e('0x17')](_0x748c42,_0x3ba886);}})[_0x328e('0x18')](function(){if(_0xb726b5){return db[_0x328e('0x4f')][_0x328e('0x17')](_0x748c42,_0x3ba886);}})[_0x328e('0x18')](function(){if(_0xb726b5){return db['OpenchannelQueueReport']['update'](_0x748c42,_0x3ba886);}})[_0x328e('0x18')](function(){if(_0xb726b5){return db[_0x328e('0x50')]['update'](_0x748c42,_0x3ba886);}})[_0x328e('0x18')](function(){if(_0xb726b5){return db['JscriptySessionReport'][_0x328e('0x17')](_0x748c42,_0x3ba886);}})[_0x328e('0x18')](function(){if(_0xb726b5){return db[_0x328e('0x51')][_0x328e('0x17')](_0x748c42,_0x3ba886);}})['then'](function(){if(_0xb726b5){return db[_0x328e('0x52')][_0x328e('0x17')](_0x748c42,_0x3ba886);}})['then'](function(){if(_0xb726b5){return db[_0x328e('0x53')]['update'](_0x748c42,_0x3ba886);}})[_0x328e('0x18')](function(){if(_0xb726b5){return db[_0x328e('0x25')][_0x328e('0x19')]({'where':{'id':[_0x502dd4[_0x328e('0x34')]['to'],_0x502dd4[_0x328e('0x34')][_0x328e('0x35')]]}});}})[_0x328e('0x18')](function(){if(_0xb726b5){return _0xb726b5;}})['then'](respondWithResult(_0x1e37e9,null))['catch'](handleError(_0x1e37e9,null));};exports[_0x328e('0x3f')]=function(_0x2f067b,_0x1e1dcb){return db[_0x328e('0x25')][_0x328e('0x1f')]()['then'](function(_0x34e744){if(_0x2f067b[_0x328e('0x34')][_0x328e('0x38')]&&_[_0x328e('0x37')](_0x2f067b[_0x328e('0x34')][_0x328e('0x38')])){if(_0x2f067b[_0x328e('0x34')][_0x328e('0x38')][_0x328e('0x27')]){_0x2f067b[_0x328e('0x34')][_0x328e('0x38')]=_0x2f067b[_0x328e('0x34')][_0x328e('0x38')]['join'](';')+';';}else{_0x2f067b['body'][_0x328e('0x38')]=null;}}else{_0x2f067b[_0x328e('0x34')][_0x328e('0x38')]=null;}if(!_['isNil'](_0x2f067b[_0x328e('0x34')]['dialTimezone'])){var _0x53bde5=_0x2f067b[_0x328e('0x34')][_0x328e('0x54')];if(!_[_0x328e('0x55')](shared[_0x328e('0x56')][_0x53bde5]))_0x2f067b[_0x328e('0x34')][_0x328e('0x57')]=shared[_0x328e('0x56')][_0x53bde5][_0x328e('0x57')];}return db[_0x328e('0x25')][_0x328e('0x3f')](_0x2f067b[_0x328e('0x34')],{'fields':_[_0x328e('0x26')](_0x34e744),'raw':!![]});})[_0x328e('0x18')](function(_0x27463e){if(_0x2f067b['body'][_0x328e('0x58')]){return insertAdditionalPhones(_0x27463e,_0x2f067b['body'][_0x328e('0x58')]);}else{return _0x27463e;}})['then'](respondWithResult(_0x1e1dcb,0xc9))['catch'](handleError(_0x1e1dcb,null));};exports[_0x328e('0x59')]=function(_0x33024d,_0x36c544){var _0x11ce43=0x0;var _0x54e23d=0x0;var _0x1386ba=0x0;var _0x7e512d=[];return db[_0x328e('0x25')][_0x328e('0x1f')]()[_0x328e('0x18')](function(_0x432aef){return BPromise[_0x328e('0x5a')](_0x33024d[_0x328e('0x34')],function(_0x34d4f2){var _0x313127={'where':{'$or':[]},'defaults':_0x34d4f2,'fields':_[_0x328e('0x26')](_0x432aef),'raw':!![]};if(_0x34d4f2['duplicates']){for(var _0x390737=0x0;_0x390737<_0x34d4f2[_0x328e('0x5b')][_0x328e('0x27')];_0x390737++){var _0x4dcb69={};_0x4dcb69[_0x34d4f2[_0x328e('0x5b')][_0x390737]]=_0x34d4f2[_0x34d4f2['duplicates'][_0x390737]];_0x313127[_0x328e('0x5c')][_0x328e('0x5d')][_0x328e('0x5e')](_0x4dcb69);}_0x313127['where'][_0x328e('0x5f')]=_0x34d4f2[_0x328e('0x5f')];}return db[_0x328e('0x25')]['findOrCreate'](_0x313127)[_0x328e('0x60')](function(_0x1b241c,_0x392521){if(_0x392521){if(_0x34d4f2[_0x328e('0x61')](_0x328e('0x58'))){_0x7e512d[_0x328e('0x5e')]({'contact':_0x1b241c,'additionalPhones':_0x34d4f2[_0x328e('0x58')]});}_0x11ce43++;}else{_0x1386ba++;}})[_0x328e('0x23')](function(){_0x54e23d++;});});})[_0x328e('0x18')](function(_0x39dad1){if(_0x39dad1){if(_0x7e512d[_0x328e('0x27')]>0x0){return new Promise(function(_0x4fe8dd){var _0x2debce=[];for(var _0x1bdd8c=0x0;_0x1bdd8c<_0x7e512d[_0x328e('0x27')];_0x1bdd8c++){_0x2debce[_0x328e('0x5e')](insertAdditionalPhones(_0x7e512d[_0x1bdd8c][_0x328e('0x62')],_0x7e512d[_0x1bdd8c][_0x328e('0x58')]));}Promise[_0x328e('0x63')](_0x2debce)[_0x328e('0x18')](function(){_0x4fe8dd(0x1);});})[_0x328e('0x18')](function(){return{'success':_0x11ce43,'failure':_0x54e23d,'duplicates':_0x1386ba};});}else{return{'success':_0x11ce43,'failure':_0x54e23d,'duplicates':_0x1386ba};}}})[_0x328e('0x18')](respondWithResult(_0x36c544,0xc9))['catch'](handleError(_0x36c544,null));};exports[_0x328e('0x64')]=function(_0x339782,_0x43f2ff){var _0x5945b5;return db[_0x328e('0x25')][_0x328e('0x1f')]()[_0x328e('0x18')](function(_0x482984){return db[_0x328e('0x25')][_0x328e('0x65')]({'where':{'id':_0x339782[_0x328e('0x24')]['id']},'include':[{'model':db[_0x328e('0x66')],'as':_0x328e('0x67'),'attributes':['id',_0x328e('0x1d'),_0x328e('0x68')],'required':_0x339782[_0x328e('0x21')]['tag']?!![]:![]},{'model':db[_0x328e('0x69')],'as':_0x328e('0x6a'),'where':{'CmContactId':_0x339782[_0x328e('0x24')]['id']},'required':![],'include':[{'model':db[_0x328e('0x6b')],'as':'ItemType'}]}],'order':[db[_0x328e('0x6c')]['literal'](_0x328e('0x6d'))],'attributes':_[_0x328e('0x26')](_0x482984)});})[_0x328e('0x18')](function(_0x5bfb81){if(!_['isNil'](_0x5bfb81)){_0x5945b5=_0x5bfb81[_0x328e('0x36')]({'plain':!![]});var _0x31ed09={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x5bfb81&&_0x5bfb81[_0x328e('0x5f')]){if(_0x5bfb81[_0x328e('0x5f')]){_0x31ed09[_0x328e('0x5c')][_0x328e('0x6e')]['push']({'ListId':{'$ne':_0x5bfb81['ListId']}});}}return db['CmCustomField']['findAll'](_0x31ed09);}})[_0x328e('0x18')](function(_0x5d7558){if(!_['isNil'](_0x5d7558)){return _['omit'](_0x5945b5,_[_0x328e('0x6f')](_0x5d7558,function(_0x5f1804){return util['format'](_0x328e('0x70'),_0x5f1804['id']);}));}})['then'](handleEntityNotFound(_0x43f2ff,null))['then'](respondWithResult(_0x43f2ff,null))['catch'](handleError(_0x43f2ff,null));};exports[_0x328e('0x17')]=function(_0x2fae34,_0x7e3ce6){var _0x1524e8;if(_0x2fae34[_0x328e('0x34')]['id']){delete _0x2fae34['body']['id'];}if(!_[_0x328e('0x55')](_0x2fae34[_0x328e('0x34')][_0x328e('0x54')])){var _0x528d67=_0x2fae34['body'][_0x328e('0x54')];if(!_[_0x328e('0x55')](shared[_0x328e('0x56')][_0x528d67]))_0x2fae34['body']['utcOffset']=shared['timezones'][_0x528d67][_0x328e('0x57')];}return db[_0x328e('0x25')][_0x328e('0x65')]({'where':{'id':_0x2fae34['params']['id']}})[_0x328e('0x18')](handleEntityNotFound(_0x7e3ce6,null))['then'](saveUpdates(_0x2fae34[_0x328e('0x34')],null))[_0x328e('0x18')](function(_0x1bf6c8){_0x1524e8=_0x1bf6c8;var _0x3d33e5={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x1bf6c8&&_0x1bf6c8[_0x328e('0x5f')]){if(_0x1bf6c8[_0x328e('0x5f')]){_0x3d33e5[_0x328e('0x5c')][_0x328e('0x6e')][_0x328e('0x5e')]({'ListId':{'$ne':_0x1bf6c8['ListId']}});}}return db[_0x328e('0x2c')]['findAll'](_0x3d33e5);})[_0x328e('0x18')](function(_0x4c7769){if(_0x4c7769){return _[_0x328e('0x71')](_[_0x328e('0x72')](_0x2fae34[_0x328e('0x34')],function(_0x2bfd8b,_0x267eb5){return _[_0x328e('0x28')](_0x267eb5,_0x328e('0x73'));}),_[_0x328e('0x6f')](_0x4c7769,function(_0x33e8b3){return util['format'](_0x328e('0x70'),_0x33e8b3['id']);}));}})[_0x328e('0x18')](function(_0x4c08){if(_0x4c08&&!_['isEmpty'](_0x4c08)){var _0x32b83e=squel[_0x328e('0x17')]()[_0x328e('0x74')](_0x328e('0x75'))[_0x328e('0x76')](_0x4c08)[_0x328e('0x5c')]('id\x20=\x20?',_0x2fae34[_0x328e('0x24')]['id'])['toParam']();return db[_0x328e('0x6c')][_0x328e('0x21')](_0x32b83e[_0x328e('0x77')],{'replacements':_0x32b83e[_0x328e('0x30')]});}})['then'](function(){if(_0x2fae34[_0x328e('0x34')][_0x328e('0x78')]&&_0x1524e8){return db[_0x328e('0x79')][_0x328e('0x17')]({'phone':_0x2fae34['body']['phone'],'OrderBy':0x0},{'where':{'ContactId':_0x1524e8['id']}});}})['then'](function(){return _0x1524e8;})['then'](respondWithResult(_0x7e3ce6,null))[_0x328e('0x23')](handleError(_0x7e3ce6,null));};exports['getTags']=function(_0x369873,_0x11d65b){var _0x49d802={};var _0x3cbd3e={};var _0x33d619;var _0x208afd;return db['CmContact'][_0x328e('0x7a')]({'where':{'id':_0x369873['params']['id']}})[_0x328e('0x18')](handleEntityNotFound(_0x11d65b,null))[_0x328e('0x18')](function(_0x1a5fb4){if(_0x1a5fb4){_0x33d619=_0x1a5fb4;_0x3cbd3e[_0x328e('0x7b')]=_['keys'](db[_0x328e('0x66')][_0x328e('0x7c')]);_0x3cbd3e[_0x328e('0x21')]=_[_0x328e('0x26')](_0x369873[_0x328e('0x21')]);_0x3cbd3e[_0x328e('0x7d')]=_[_0x328e('0x7e')](_0x3cbd3e[_0x328e('0x7b')],_0x3cbd3e['query']);_0x49d802[_0x328e('0x7f')]=_[_0x328e('0x7e')](_0x3cbd3e['model'],qs['fields'](_0x369873['query'][_0x328e('0x80')]));_0x49d802['attributes']=_0x49d802[_0x328e('0x7f')][_0x328e('0x27')]?_0x49d802['attributes']:_0x3cbd3e[_0x328e('0x7b')];_0x49d802[_0x328e('0x81')]=qs['sort'](_0x369873[_0x328e('0x21')][_0x328e('0x82')]);_0x49d802[_0x328e('0x5c')]=qs[_0x328e('0x7d')](_['pick'](_0x369873['query'],_0x3cbd3e['filters']));if(_0x369873[_0x328e('0x21')]['filter']){_0x49d802['where']=_[_0x328e('0x33')](_0x49d802['where'],{'$or':_['map'](_0x49d802[_0x328e('0x7f')],function(_0x1b1bde){var _0x4380f1={};_0x4380f1[_0x1b1bde]={'$like':'%'+_0x369873[_0x328e('0x21')]['filter']+'%'};return _0x4380f1;})});}_0x49d802=_[_0x328e('0x33')]({},_0x49d802,_0x369873[_0x328e('0x83')]);return _0x33d619[_0x328e('0x84')](_0x49d802);}})[_0x328e('0x18')](function(_0x2f511a){if(_0x2f511a){_0x208afd=_0x2f511a[_0x328e('0x27')];if(!_0x369873[_0x328e('0x21')]['hasOwnProperty'](_0x328e('0x85'))){_0x49d802[_0x328e('0x12')]=qs[_0x328e('0x12')](_0x369873[_0x328e('0x21')][_0x328e('0x12')]);_0x49d802[_0x328e('0x11')]=qs[_0x328e('0x11')](_0x369873['query'][_0x328e('0x11')]);}return _0x33d619[_0x328e('0x84')](_0x49d802);}})[_0x328e('0x18')](function(_0x399c7d){if(_0x399c7d){return _0x399c7d?{'count':_0x208afd,'rows':_0x399c7d}:null;}})[_0x328e('0x18')](respondWithResult(_0x11d65b,null))[_0x328e('0x23')](handleError(_0x11d65b,null));};exports[_0x328e('0x86')]=function(_0x3f5c73,_0x15072e){if(_0x3f5c73['body']['id']){delete _0x3f5c73[_0x328e('0x34')]['id'];}return db[_0x328e('0x25')]['findOne']({'where':{'id':_0x3f5c73['params']['id']}})[_0x328e('0x18')](handleEntityNotFound(_0x15072e,null))[_0x328e('0x18')](function(_0x504634){if(_0x504634){return _0x504634[_0x328e('0x86')](_0x3f5c73[_0x328e('0x34')]['ids']||[]);}return null;})[_0x328e('0x18')](respondWithResult(_0x15072e,null))[_0x328e('0x23')](handleError(_0x15072e,null));};exports['setAdditionalPhones']=function(_0x3f5c47,_0x19bda7){var _0x310cd3=[];_0x310cd3['push'](addAdditionalPhones(_0x3f5c47['body']));Promise[_0x328e('0x63')](_0x310cd3)[_0x328e('0x18')](function(){_0x310cd3=[];_0x310cd3['push'](deleteCmHopperPhones(_0x3f5c47['body']['id']));_0x310cd3[_0x328e('0x5e')](addCmHopperPhones(_0x3f5c47['body']['id']));Promise[_0x328e('0x63')](_0x310cd3)[_0x328e('0x18')](function(){return[0x1];})[_0x328e('0x18')](respondWithResult(_0x19bda7,null));});};function addAdditionalPhones(_0x5a35bf){var _0x3f9cc8;return new Promise(function(_0x48148b){return db[_0x328e('0x69')][_0x328e('0x19')]({'where':{'CmContactId':_0x5a35bf['id']}})[_0x328e('0x18')](function(){db[_0x328e('0x6b')][_0x328e('0x2d')]({'raw':!![],'attributes':['id','OrderBy']})[_0x328e('0x18')](function(_0x1cd60f){var _0x3fe65f=[];for(var _0x3b753c=0x0;_0x3b753c<_0x5a35bf[_0x328e('0x87')][_0x328e('0x27')];_0x3b753c++){var _0x16ce8e=_0x5a35bf[_0x328e('0x88')]?_['isNil'](_0x5a35bf[_0x328e('0x88')][_0x3b753c])?'':_0x5a35bf[_0x328e('0x88')][_0x3b753c]:_0x5a35bf[_0x328e('0x87')][_0x3b753c][_0x328e('0x89')]?_0x5a35bf[_0x328e('0x87')][_0x3b753c][_0x328e('0x89')]:'';var _0x440195=_[_0x328e('0x55')](_0x5a35bf[_0x328e('0x87')][_0x3b753c][_0x328e('0x8a')])?'':_0x5a35bf['items'][_0x3b753c][_0x328e('0x8a')];var _0x49af00=_0x16ce8e+':'+_0x5a35bf['items'][_0x3b753c][_0x328e('0x78')]+'§'+_0x440195;if(_[_0x328e('0x55')](_0x3f9cc8))_0x3f9cc8=_0x49af00;else _0x3f9cc8+=';'+_0x49af00;var _0x266579=null;var _0x5709f6=null;if(_0x5a35bf['item_types']){if(!_[_0x328e('0x55')](_0x5a35bf[_0x328e('0x88')][_0x3b753c])){_0x5709f6=_[_0x328e('0x65')](_0x1cd60f,function(_0x2ee254){return _0x2ee254['id']===_0x5a35bf['item_types'][_0x3b753c];});if(!_[_0x328e('0x55')](_0x5709f6)){_0x266579=_0x5709f6[_0x328e('0x8b')];}}}else{if(!_[_0x328e('0x55')](_0x5a35bf[_0x328e('0x87')][_0x3b753c])){_0x5709f6=_[_0x328e('0x65')](_0x1cd60f,function(_0x3dff8b){return _0x3dff8b['id']===_0x5a35bf['items'][_0x3b753c][_0x328e('0x89')];});if(!_[_0x328e('0x55')](_0x5709f6)){_0x266579=_0x3b753c;}}}if(_[_0x328e('0x55')](_0x266579)){_0x266579=0x64;}_0x3fe65f['push'](addAdditionalPhone(_0x5a35bf['id'],_0x5a35bf[_0x328e('0x87')][_0x3b753c]['phone'],_0x5a35bf[_0x328e('0x88')]?_['isNil'](_0x5a35bf[_0x328e('0x88')][_0x3b753c])?null:_0x5a35bf['item_types'][_0x3b753c]:_0x5a35bf['items'][_0x3b753c][_0x328e('0x89')]?_0x5a35bf[_0x328e('0x87')][_0x3b753c][_0x328e('0x89')]:null,_0x266579,_0x440195));}Promise[_0x328e('0x63')](_0x3fe65f)[_0x328e('0x18')](function(){db[_0x328e('0x25')][_0x328e('0x17')]({'AdditionalPhones':_0x3f9cc8},{'where':{'id':_0x5a35bf['id']}})['then'](function(){_0x48148b(0x1);});});});});});}function addAdditionalPhone(_0xd3ab18,_0x271763,_0x43d339,_0x5e3fd,_0x40e107){return db[_0x328e('0x69')]['find']({'where':{'CmContactId':_0xd3ab18,'item':_0x271763}})[_0x328e('0x18')](function(_0x272b64){if(_0x272b64)logger['info']('contact\x20phone\x20exists',_0x272b64);else{db[_0x328e('0x69')][_0x328e('0x3f')]({'CmContactId':_0xd3ab18,'item':_0x271763,'ItemTypeId':_0x43d339,'OrderBy':_0x5e3fd,'ItemClass':_0x328e('0x8c'),'description':_0x40e107});}});}function deleteCmHopperPhones(_0x35948f){return new Promise(function(_0x597843){return db['CmHopper'][_0x328e('0x2d')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x35948f}})[_0x328e('0x18')](function(_0x3cb470){db['CmHopperAdditionalPhone']['destroy']({'where':{'CmHopperId':{'$in':_['map'](_0x3cb470,'id')}}});})[_0x328e('0x18')](function(){_0x597843(0x1);});});}function addCmHopperPhones(_0x4e549f){return new Promise(function(_0x495f4b){return db[_0x328e('0x79')][_0x328e('0x2d')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x4e549f}})[_0x328e('0x18')](function(_0x4e9b38){var _0xf838e4=[];_[_0x328e('0x6f')](_0x4e9b38,function(_0x38254d){_0xf838e4['push'](createCmHopperPhone(_0x4e549f,_0x38254d['id']));});Promise['all'](_0xf838e4)[_0x328e('0x18')](function(){_0x495f4b(0x1);});});});}function createCmHopperPhone(_0x24fe33,_0x228ecc){return new Promise(function(_0x22a139){db[_0x328e('0x69')][_0x328e('0x2d')]({'raw':!![],'attributes':['item',_0x328e('0x8b')],'where':{'CmContactId':_0x24fe33,'ItemClass':'PHONE'},'include':[{'model':db['ContactItemType'],'attributes':['OrderBy'],'as':'ItemType'}],'order':[_0x328e('0x8b'),db['sequelize'][_0x328e('0x8d')]('`ItemType`.OrderBy')]})[_0x328e('0x18')](function(_0x25b91c){var _0x2d6969=0x1;var _0xd6e1a6=_[_0x328e('0x6f')](_0x25b91c,function(_0x5a931b){_0x5a931b[_0x328e('0x8e')]=_0x228ecc;_0x5a931b[_0x328e('0x78')]=_0x5a931b[_0x328e('0x8f')];_0x5a931b[_0x328e('0x8b')]=_0x2d6969;delete _0x5a931b[_0x328e('0x90')];_0x2d6969=_0x2d6969+0x1;return _0x5a931b;});return db[_0x328e('0x91')][_0x328e('0x59')](_0xd6e1a6,{});})[_0x328e('0x18')](function(){_0x22a139(0x1);});});}function insertAdditionalPhones(_0x84f601,_0x2282ab){return new Promise(function(_0x3fbf7b){var _0x548531=[];for(var _0x272f4=0x0;_0x272f4<_0x2282ab['length'];_0x272f4++){var _0x240e6e=_0x2282ab[_0x272f4];_0x548531['push'](parseContactItemType(_0x240e6e));}Promise[_0x328e('0x63')](_0x548531)[_0x328e('0x18')](function(){var _0x2b2a78={'id':_0x84f601['id'],'items':_0x2282ab};return addAdditionalPhones(_0x2b2a78)['then'](function(){return addCmHopperPhones(_0x84f601['id']);});})['then'](function(){_0x3fbf7b(_0x84f601);});});}function parseContactItemType(_0x221959){return new Promise(function(_0x549065){if(_0x221959[_0x328e('0x61')](_0x328e('0x89'))){_0x549065(_0x221959);}else{return db[_0x328e('0x6b')][_0x328e('0x65')]({'where':{'name':_0x221959[_0x328e('0x92')]}})['then'](function(_0xccee5){if(_['isNil'](_0xccee5))_0x221959[_0x328e('0x89')]=null;else _0x221959[_0x328e('0x89')]=_0xccee5['id'];_0x549065(_0x221959);});}});}exports[_0x328e('0x93')]=function(_0x15e1a6,_0x1402c2){return db['CmContactHasItem'][_0x328e('0x2d')]({'raw':!![],'where':{'CmContactId':_0x15e1a6[_0x328e('0x24')]['id'],'ItemClass':_0x328e('0x8c')},'include':[{'model':db['ContactItemType'],'as':'ItemType'}],'order':[[_0x328e('0x8b')],[db[_0x328e('0x6c')][_0x328e('0x8d')](_0x328e('0x94'))]]})[_0x328e('0x18')](function(_0x19e389){return _0x19e389;})[_0x328e('0x18')](respondWithResult(_0x1402c2,null))[_0x328e('0x23')](handleError(_0x1402c2,null));};exports[_0x328e('0x95')]=function(_0x45527d,_0x4f2f19){return db[_0x328e('0x69')][_0x328e('0x2d')]({'raw':!![],'where':{'CmContactId':_0x45527d[_0x328e('0x34')][_0x328e('0x96')]}})['then'](function(_0x52c0a9){var _0x1ae7ef=_[_0x328e('0x6f')](_0x52c0a9,function(_0x5c2f6){_0x5c2f6[_0x328e('0x97')]=_0x45527d[_0x328e('0x34')][_0x328e('0x98')];return _0x5c2f6;});return db[_0x328e('0x69')][_0x328e('0x59')](_0x1ae7ef,{});})[_0x328e('0x18')](function(){return addCmHopperPhones(_0x45527d['body'][_0x328e('0x98')]);})['then'](function(){return['ok'];})[_0x328e('0x18')](respondWithResult(_0x4f2f19,null))[_0x328e('0x23')](handleError(_0x4f2f19,null));};exports['rescheduleAdditionalPhones']=function(_0x19af7f,_0x3d6aef){var _0x3451d1=[];_0x3451d1['push'](createCmHopperPhone(_0x19af7f[_0x328e('0x34')]['id'],_0x19af7f[_0x328e('0x34')][_0x328e('0x99')]));Promise[_0x328e('0x63')](_0x3451d1)[_0x328e('0x18')](function(){return[0x1];})[_0x328e('0x18')](respondWithResult(_0x3d6aef,null));};exports[_0x328e('0x9a')]=function(_0x3c68a2,_0x3e5b2b){var _0x44fc32={'raw':![],'where':{}};var _0x5a90dd={};var _0xbdca2a={'count':0x0,'rows':[]};return db[_0x328e('0x25')][_0x328e('0x7a')]({'where':{'id':_0x3c68a2['params']['id']}})[_0x328e('0x18')](handleEntityNotFound(_0x3e5b2b,null))['then'](function(_0x519da0){if(_0x519da0){_0x5a90dd[_0x328e('0x7b')]=_[_0x328e('0x26')](db[_0x328e('0x79')][_0x328e('0x7c')]);_0x5a90dd[_0x328e('0x21')]=_[_0x328e('0x26')](_0x3c68a2[_0x328e('0x21')]);_0x5a90dd[_0x328e('0x7d')]=_[_0x328e('0x7e')](_0x5a90dd[_0x328e('0x7b')],_0x5a90dd['query']);_0x44fc32[_0x328e('0x7f')]=_['intersection'](_0x5a90dd[_0x328e('0x7b')],qs['fields'](_0x3c68a2['query'][_0x328e('0x80')]));_0x44fc32[_0x328e('0x7f')]=_0x44fc32[_0x328e('0x7f')]['length']?_0x44fc32[_0x328e('0x7f')]:_0x5a90dd[_0x328e('0x7b')];if(!_0x3c68a2[_0x328e('0x21')][_0x328e('0x61')]('nolimit')){_0x44fc32['limit']=qs[_0x328e('0x12')](_0x3c68a2[_0x328e('0x21')][_0x328e('0x12')]);_0x44fc32[_0x328e('0x11')]=qs[_0x328e('0x11')](_0x3c68a2[_0x328e('0x21')][_0x328e('0x11')]);}_0x44fc32[_0x328e('0x81')]=qs[_0x328e('0x82')](_0x3c68a2[_0x328e('0x21')]['sort']);_0x44fc32[_0x328e('0x5c')]=qs[_0x328e('0x7d')](_[_0x328e('0x9b')](_0x3c68a2[_0x328e('0x21')],_0x5a90dd[_0x328e('0x7d')]));_0x44fc32[_0x328e('0x5c')][_0x328e('0x9c')]=_0x519da0['id'];if(_0x3c68a2[_0x328e('0x21')]['filter']){_0x44fc32[_0x328e('0x5c')]=_[_0x328e('0x33')](_0x44fc32[_0x328e('0x5c')],{'$or':_[_0x328e('0x6f')](_0x44fc32['attributes'],function(_0x33db97){var _0x1bd469={};_0x1bd469[_0x33db97]={'$like':'%'+_0x3c68a2[_0x328e('0x21')][_0x328e('0x9d')]+'%'};return _0x1bd469;})});}_0x44fc32=_[_0x328e('0x33')]({},_0x44fc32,_0x3c68a2[_0x328e('0x83')]);return db['CmHopper'][_0x328e('0x14')]({'where':_0x44fc32[_0x328e('0x5c')]})[_0x328e('0x18')](function(_0x2e819a){_0xbdca2a[_0x328e('0x14')]=_0x2e819a;if(_0x3c68a2[_0x328e('0x21')][_0x328e('0x9e')]){_0x44fc32[_0x328e('0x9f')]=[{'all':!![]}];}return db[_0x328e('0x79')][_0x328e('0x2d')](_0x44fc32);})[_0x328e('0x18')](function(_0x2a8261){_0xbdca2a[_0x328e('0xa0')]=_0x2a8261;return _0xbdca2a;});}})[_0x328e('0x18')](respondWithFilteredResult(_0x3e5b2b,_0x44fc32))['catch'](handleError(_0x3e5b2b,null));};exports[_0x328e('0xa1')]=function(_0x1b25a2,_0x3dbcf4){var _0x13e603={'raw':!![],'where':{}};var _0x38c8fe={};var _0x36a046={'count':0x0,'rows':[]};return db['CmContact'][_0x328e('0x7a')]({'where':{'id':_0x1b25a2['params']['id']}})[_0x328e('0x18')](handleEntityNotFound(_0x3dbcf4,null))[_0x328e('0x18')](function(_0x191fe1){if(_0x191fe1){_0x38c8fe[_0x328e('0x7b')]=_[_0x328e('0x26')](db['CmHopperHistory'][_0x328e('0x7c')]);_0x38c8fe[_0x328e('0x21')]=_[_0x328e('0x26')](_0x1b25a2[_0x328e('0x21')]);_0x38c8fe[_0x328e('0x7d')]=_[_0x328e('0x7e')](_0x38c8fe['model'],_0x38c8fe[_0x328e('0x21')]);_0x13e603[_0x328e('0x7f')]=_[_0x328e('0x7e')](_0x38c8fe[_0x328e('0x7b')],qs[_0x328e('0x80')](_0x1b25a2[_0x328e('0x21')][_0x328e('0x80')]));_0x13e603[_0x328e('0x7f')]=_0x13e603[_0x328e('0x7f')]['length']?_0x13e603['attributes']:_0x38c8fe['model'];if(!_0x1b25a2[_0x328e('0x21')]['hasOwnProperty'](_0x328e('0x85'))){_0x13e603[_0x328e('0x12')]=qs[_0x328e('0x12')](_0x1b25a2[_0x328e('0x21')][_0x328e('0x12')]);_0x13e603[_0x328e('0x11')]=qs['offset'](_0x1b25a2['query'][_0x328e('0x11')]);}_0x13e603['order']=qs[_0x328e('0x82')](_0x1b25a2['query'][_0x328e('0x82')]);_0x13e603[_0x328e('0x5c')]=qs[_0x328e('0x7d')](_['pick'](_0x1b25a2['query'],_0x38c8fe[_0x328e('0x7d')]));_0x13e603[_0x328e('0x5c')]['ContactId']=_0x191fe1['id'];if(_0x1b25a2[_0x328e('0x21')][_0x328e('0x9d')]){_0x13e603['where']=_[_0x328e('0x33')](_0x13e603['where'],{'$or':_['map'](_0x13e603['attributes'],function(_0xa28360){var _0x3e19ee={};_0x3e19ee[_0xa28360]={'$like':'%'+_0x1b25a2['query'][_0x328e('0x9d')]+'%'};return _0x3e19ee;})});}_0x13e603=_[_0x328e('0x33')]({},_0x13e603,_0x1b25a2[_0x328e('0x83')]);return db[_0x328e('0x4b')][_0x328e('0x14')]({'where':_0x13e603[_0x328e('0x5c')]})['then'](function(_0x5d4a22){_0x36a046['count']=_0x5d4a22;if(_0x1b25a2[_0x328e('0x21')][_0x328e('0x9e')]){_0x13e603[_0x328e('0x9f')]=[{'all':!![]}];}return db[_0x328e('0x4b')][_0x328e('0x2d')](_0x13e603);})[_0x328e('0x18')](function(_0x2b1e5b){_0x36a046[_0x328e('0xa0')]=_0x2b1e5b;return _0x36a046;});}})[_0x328e('0x18')](respondWithFilteredResult(_0x3dbcf4,_0x13e603))[_0x328e('0x23')](handleError(_0x3dbcf4,null));};exports['getHopperFinals']=function(_0x294a3d,_0x7b7b68){var _0x5e9b59={'raw':!![],'where':{}};var _0x35ffc6={};var _0x3f0c6a={'count':0x0,'rows':[]};return db['CmContact'][_0x328e('0x7a')]({'where':{'id':_0x294a3d[_0x328e('0x24')]['id']}})[_0x328e('0x18')](handleEntityNotFound(_0x7b7b68,null))['then'](function(_0x183ec2){if(_0x183ec2){_0x35ffc6['model']=_[_0x328e('0x26')](db[_0x328e('0x4a')][_0x328e('0x7c')]);_0x35ffc6[_0x328e('0x21')]=_[_0x328e('0x26')](_0x294a3d[_0x328e('0x21')]);_0x35ffc6[_0x328e('0x7d')]=_[_0x328e('0x7e')](_0x35ffc6[_0x328e('0x7b')],_0x35ffc6['query']);_0x5e9b59[_0x328e('0x7f')]=_[_0x328e('0x7e')](_0x35ffc6[_0x328e('0x7b')],qs[_0x328e('0x80')](_0x294a3d[_0x328e('0x21')][_0x328e('0x80')]));_0x5e9b59[_0x328e('0x7f')]=_0x5e9b59[_0x328e('0x7f')][_0x328e('0x27')]?_0x5e9b59[_0x328e('0x7f')]:_0x35ffc6['model'];if(!_0x294a3d['query']['hasOwnProperty'](_0x328e('0x85'))){_0x5e9b59['limit']=qs['limit'](_0x294a3d[_0x328e('0x21')][_0x328e('0x12')]);_0x5e9b59[_0x328e('0x11')]=qs['offset'](_0x294a3d[_0x328e('0x21')]['offset']);}_0x5e9b59[_0x328e('0x81')]=qs[_0x328e('0x82')](_0x294a3d[_0x328e('0x21')][_0x328e('0x82')]);_0x5e9b59['where']=qs[_0x328e('0x7d')](_[_0x328e('0x9b')](_0x294a3d[_0x328e('0x21')],_0x35ffc6[_0x328e('0x7d')]));_0x5e9b59[_0x328e('0x5c')][_0x328e('0x9c')]=_0x183ec2['id'];if(_0x294a3d[_0x328e('0x21')][_0x328e('0x9d')]){_0x5e9b59[_0x328e('0x5c')]=_['merge'](_0x5e9b59[_0x328e('0x5c')],{'$or':_[_0x328e('0x6f')](_0x5e9b59[_0x328e('0x7f')],function(_0x45c0db){var _0x3d5a06={};_0x3d5a06[_0x45c0db]={'$like':'%'+_0x294a3d['query'][_0x328e('0x9d')]+'%'};return _0x3d5a06;})});}_0x5e9b59=_[_0x328e('0x33')]({},_0x5e9b59,_0x294a3d[_0x328e('0x83')]);return db[_0x328e('0x4a')][_0x328e('0x14')]({'where':_0x5e9b59[_0x328e('0x5c')]})[_0x328e('0x18')](function(_0x153ad2){_0x3f0c6a['count']=_0x153ad2;if(_0x294a3d[_0x328e('0x21')][_0x328e('0x9e')]){_0x5e9b59[_0x328e('0x9f')]=[{'all':!![]}];}return db['CmHopperFinal'][_0x328e('0x2d')](_0x5e9b59);})['then'](function(_0xc37d4f){_0x3f0c6a[_0x328e('0xa0')]=_0xc37d4f;return _0x3f0c6a;});}})[_0x328e('0x18')](respondWithFilteredResult(_0x7b7b68,_0x5e9b59))[_0x328e('0x23')](handleError(_0x7b7b68,null));};exports[_0x328e('0xa2')]=function(_0x25b4a5,_0x40824a){var _0x179ff1={'raw':!![],'where':{}};var _0x2a5948={};var _0xe561af={'count':0x0,'rows':[]};return db['CmContact'][_0x328e('0x7a')]({'where':{'id':_0x25b4a5[_0x328e('0x24')]['id']}})[_0x328e('0x18')](handleEntityNotFound(_0x40824a,null))[_0x328e('0x18')](function(_0x114929){if(_0x114929){_0x2a5948['model']=_['keys'](db[_0x328e('0xa3')]['rawAttributes']);_0x2a5948[_0x328e('0x21')]=_[_0x328e('0x26')](_0x25b4a5[_0x328e('0x21')]);_0x2a5948[_0x328e('0x7d')]=_['intersection'](_0x2a5948[_0x328e('0x7b')],_0x2a5948['query']);_0x179ff1[_0x328e('0x7f')]=_[_0x328e('0x7e')](_0x2a5948[_0x328e('0x7b')],qs[_0x328e('0x80')](_0x25b4a5[_0x328e('0x21')][_0x328e('0x80')]));_0x179ff1[_0x328e('0x7f')]=_0x179ff1[_0x328e('0x7f')][_0x328e('0x27')]?_0x179ff1[_0x328e('0x7f')]:_0x2a5948[_0x328e('0x7b')];if(!_0x25b4a5[_0x328e('0x21')]['hasOwnProperty'](_0x328e('0x85'))){_0x179ff1['limit']=qs[_0x328e('0x12')](_0x25b4a5[_0x328e('0x21')][_0x328e('0x12')]);_0x179ff1[_0x328e('0x11')]=qs[_0x328e('0x11')](_0x25b4a5[_0x328e('0x21')][_0x328e('0x11')]);}_0x179ff1[_0x328e('0x81')]=qs[_0x328e('0x82')](_0x25b4a5['query'][_0x328e('0x82')]);_0x179ff1[_0x328e('0x5c')]=qs[_0x328e('0x7d')](_['pick'](_0x25b4a5[_0x328e('0x21')],_0x2a5948[_0x328e('0x7d')]));_0x179ff1[_0x328e('0x5c')][_0x328e('0x9c')]=_0x114929['id'];if(_0x25b4a5[_0x328e('0x21')]['filter']){_0x179ff1[_0x328e('0x5c')]=_[_0x328e('0x33')](_0x179ff1[_0x328e('0x5c')],{'$or':_[_0x328e('0x6f')](_0x179ff1[_0x328e('0x7f')],function(_0x182277){var _0x31fd62={};_0x31fd62[_0x182277]={'$like':'%'+_0x25b4a5[_0x328e('0x21')][_0x328e('0x9d')]+'%'};return _0x31fd62;})});}_0x179ff1=_[_0x328e('0x33')]({},_0x179ff1,_0x25b4a5['options']);return db[_0x328e('0xa3')][_0x328e('0x14')]({'where':_0x179ff1[_0x328e('0x5c')]})['then'](function(_0x2dbb45){_0xe561af[_0x328e('0x14')]=_0x2dbb45;if(_0x25b4a5[_0x328e('0x21')]['includeAll']){_0x179ff1[_0x328e('0x9f')]=[{'all':!![]}];}return db[_0x328e('0xa3')][_0x328e('0x2d')](_0x179ff1);})[_0x328e('0x18')](function(_0xd56270){_0xe561af[_0x328e('0xa0')]=_0xd56270;return _0xe561af;});}})[_0x328e('0x18')](respondWithFilteredResult(_0x40824a,_0x179ff1))[_0x328e('0x23')](handleError(_0x40824a,null));};exports[_0x328e('0xa4')]=function(_0x219858,_0x445464){try{if(!_0x219858[_0x328e('0x34')][_0x328e('0x5f')]){throw new Error(_0x328e('0xa5'));}if(!_0x219858[_0x328e('0x34')][_0x328e('0xa6')]){throw new Error(_0x328e('0xa7'));}if(!_0x219858[_0x328e('0x34')][_0x328e('0xa8')]){throw new Error(_0x328e('0xa9'));}if(!_0x219858[_0x328e('0x34')]['socket_timestamp']){throw new Error(_0x328e('0xaa'));}var _0x2bd508=_0x219858[_0x328e('0x34')][_0x328e('0xa6')][_0x328e('0xab')](',');var _0x4641f6=_0x219858['body']['binding_values'][_0x328e('0xab')](',');if(!_0x2bd508[_0x328e('0x27')]||!_0x4641f6[_0x328e('0x27')]||_0x2bd508[_0x328e('0x27')]!==_0x4641f6[_0x328e('0x27')]){throw new Error('Incorrect\x20binding\x20parameters\x20passed!');}_0x219858['body'][_0x328e('0x80')]=_['zipObject'](_0x2bd508,_0x4641f6);if(!_0x219858['body'][_0x328e('0x80')][_0x328e('0x78')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x219858[_0x328e('0x34')]['fields']['firstName']){throw new Error(_0x328e('0xac'));}var _0x5eb971=path['join'](config[_0x328e('0xad')],_0x328e('0xae'),_0x219858[_0x328e('0xaf')][_0x328e('0xb0')]);fs['chmodSync'](_0x5eb971,parseInt(_0x328e('0xb1'),0x8));var _0x2c0bbc=require('child_process')[_0x328e('0xb2')](path['join'](__dirname,'../../components/import/cm/csv'),[_0x5eb971,_0x219858['body'][_0x328e('0xa6')],_0x219858[_0x328e('0x34')]['binding_values'],_0x219858[_0x328e('0x34')][_0x328e('0x5f')],_0x219858[_0x328e('0x34')][_0x328e('0xb3')],_0x219858['body'][_0x328e('0x5b')],_0x219858[_0x328e('0x34')][_0x328e('0xb4')]]);return _0x445464['status'](0xc8)[_0x328e('0xb5')]({'message':_0x328e('0xb6'),'pid':_0x2c0bbc[_0x328e('0xb7')]});}catch(_0x14c0fa){return _0x445464[_0x328e('0x10')](0x1f4)[_0x328e('0x1e')](_0x14c0fa);}};exports[_0x328e('0xb8')]=function(_0x17b3f0,_0xe06fe5){var _0x3696ee=fs[_0x328e('0xb9')](_0x17b3f0[_0x328e('0xaf')][_0x328e('0x1')]);Papa[_0x328e('0xba')](_0x3696ee,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x226821){return _0xe06fe5[_0x328e('0x10')](0xc8)[_0x328e('0xb5')]({'file':_0x17b3f0[_0x328e('0xaf')],'fields':_0x226821[_0x328e('0xbb')][_0x328e('0x80')]});}});};exports[_0x328e('0xbc')]=function(_0x1eef28,_0x4d4998){return db[_0x328e('0xbd')][_0x328e('0x2d')]({'raw':!![],'attributes':['id'],'where':{'role':_0x328e('0xbe')}})['then'](function(_0x2080a7){var _0x409ee4=![];if(!_0x1eef28[_0x328e('0x34')]['ListId']){throw new Error(_0x328e('0xa5'));}if(!_0x1eef28[_0x328e('0x34')][_0x328e('0xbf')][_0x328e('0x78')]){throw new Error(_0x328e('0xc0'));}if(!_0x1eef28['body'][_0x328e('0xbf')][_0x328e('0xc1')]){throw new Error(_0x328e('0xac'));}if(!_0x1eef28[_0x328e('0x34')][_0x328e('0xb4')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x1b5317=require(_0x328e('0xc2'))[_0x328e('0xb2')](path[_0x328e('0x39')](__dirname,_0x328e('0xc3')),[_0x1eef28[_0x328e('0x24')]['id'],JSON['stringify'](_0x1eef28['body']),JSON[_0x328e('0xc4')](_0x2080a7)]);_0x1b5317['on'](_0x328e('0xc5'),function(){_0x409ee4=!![];return _0x4d4998[_0x328e('0x10')](0xc8)[_0x328e('0xb5')]({'message':_0x328e('0xc6'),'pid':_0x1b5317[_0x328e('0xb7')]});});_0x1b5317['on'](_0x328e('0xc7'),function(_0x138f0b){if(_0x138f0b&&!_0x409ee4){return _0x4d4998[_0x328e('0x10')](0x1f4)[_0x328e('0xb5')]({'message':_0x328e('0xc8'),'pid':_0x1b5317[_0x328e('0xb7')]});}});})[_0x328e('0x23')](handleError(_0x4d4998,null));};exports[_0x328e('0xc9')]=function(_0x55b8fc,_0x1c8f7c){return db[_0x328e('0xbd')][_0x328e('0x2d')]({'raw':!![],'attributes':['id'],'where':{'role':_0x328e('0xbe')}})[_0x328e('0x18')](function(_0x169b3f){var _0x2383a2=![];if(!_0x55b8fc[_0x328e('0x34')]['ListId']){throw new Error('No\x20ListId\x20specified');}if(!_0x55b8fc[_0x328e('0x34')][_0x328e('0xbf')]['phone']){throw new Error(_0x328e('0xc0'));}if(!_0x55b8fc['body'][_0x328e('0xbf')]['firstName']){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x55b8fc[_0x328e('0x34')][_0x328e('0xb4')]){throw new Error(_0x328e('0xaa'));}var _0x581c6c=require(_0x328e('0xc2'))[_0x328e('0xb2')](path[_0x328e('0x39')](__dirname,_0x328e('0xca')),[_0x55b8fc[_0x328e('0x24')]['id'],JSON[_0x328e('0xc4')](_0x55b8fc[_0x328e('0x34')]),JSON[_0x328e('0xc4')](_0x169b3f)]);_0x581c6c['on']('message',function(){_0x2383a2=!![];return _0x1c8f7c[_0x328e('0x10')](0xc8)[_0x328e('0xb5')]({'message':_0x328e('0xc6'),'pid':_0x581c6c['pid']});});_0x581c6c['on'](_0x328e('0xc7'),function(_0x1997e0){if(_0x1997e0&&!_0x2383a2){return _0x1c8f7c[_0x328e('0x10')](0x1f4)['json']({'message':_0x328e('0xc8'),'pid':_0x581c6c['pid']});}});})[_0x328e('0x23')](handleError(_0x1c8f7c,null));};exports[_0x328e('0xcb')]=function(_0x5828cd,_0x58d1eb){var _0x35562f=[_0x328e('0xcc'),'chat','sms',_0x328e('0xcd'),_0x328e('0xce'),_0x328e('0xcf'),'voice'];var _0x3ecaa6={'offset':0x0,'order':qs[_0x328e('0x82')](_0x328e('0xd0'))},_0x3981fc={'count':0x0,'rows':[]};Promise[_0x328e('0xd1')]()[_0x328e('0x18')](function(){if(_0x5828cd['query']['channel']){if(!_[_0x328e('0xd2')](_0x35562f,_0x5828cd[_0x328e('0x21')][_0x328e('0xd3')][_0x328e('0xd4')]())){throw new Error('Invalid\x20channel');}_0x35562f=[_0x5828cd[_0x328e('0x21')][_0x328e('0xd3')][_0x328e('0xd4')]()];}if(_0x5828cd['query'][_0x328e('0xd5')]){try{var _0x43ac06=JSON[_0x328e('0xba')](_0x5828cd[_0x328e('0x21')]['range']);if(!moment(_0x43ac06[_0x328e('0x35')])['isValid']()){throw new Error(_0x328e('0xd6'));}if(!moment(_0x43ac06['to'])[_0x328e('0xd7')]()){throw new Error('Invalid\x20date\x20for\x20range\x20to\x20filter');}}catch(_0x255c09){throw new Error(_0x328e('0xd8'));}}if(!_0x5828cd[_0x328e('0x21')]['hasOwnProperty'](_0x328e('0x85'))){_0x3ecaa6[_0x328e('0x12')]=qs[_0x328e('0x12')](_0x5828cd['query'][_0x328e('0x12')]||0xa);_0x3ecaa6[_0x328e('0x11')]=qs[_0x328e('0x11')](_0x5828cd['query'][_0x328e('0x11')]);}var _0x51fa4b=_0x35562f['map'](function(_0x51c70c){if(_0x51c70c===_0x328e('0xd9')){var _0x428842={'attributes':['id',_0x328e('0xda'),_0x328e('0x2f'),_0x328e('0xdb'),_0x328e('0xdc'),_0x328e('0xdd'),'starttime',_0x328e('0xde'),_0x328e('0xdf'),_0x328e('0xe0'),_0x328e('0xe1'),'userDisposition',_0x328e('0xe2'),_0x328e('0xe3'),_0x328e('0xe4')],'where':{'ContactId':_0x5828cd[_0x328e('0x24')]['id']},'include':[{'model':db[_0x328e('0xbd')],'as':_0x328e('0xbd'),'attributes':['id','name',_0x328e('0xe5'),_0x328e('0xe6')]}],'order':[[_0x328e('0xe1'),_0x328e('0xe7')]]};if(_0x5828cd[_0x328e('0x21')][_0x328e('0xd5')]){_0x428842[_0x328e('0x5c')][_0x328e('0xe1')]={'$gte':_0x43ac06[_0x328e('0x35')],'$lte':_0x43ac06['to']};}return db['VoiceCallReport']['findAndCountAll'](_0x428842)['then'](function(_0xb3cb71){_0x3981fc['count']+=_0xb3cb71[_0x328e('0x14')];return _['map'](_0xb3cb71['rows'],function(_0x3e5846){var _0x4a5709=_0x3e5846[_0x328e('0x36')]({'plain':!![]});_0x4a5709[_0x328e('0xd3')]=_0x51c70c;if(_0x4a5709[_0x328e('0xbd')]){_0x4a5709[_0x328e('0xbd')]={'id':_0x4a5709['User']['id'],'name':_0x4a5709['User']['name'],'fullname':_0x4a5709['User'][_0x328e('0xe5')],'alias':_0x4a5709[_0x328e('0xbd')][_0x328e('0xe6')]};}return _0x4a5709;});});}else{var _0x46edda=_[_0x328e('0xe8')](_0x51c70c)+(_0x51c70c===_0x328e('0xe9')?_0x328e('0xea'):_0x328e('0xeb'));var _0x52fa1b={'attributes':['id',_0x328e('0xec'),_0x328e('0xed'),_0x328e('0xe1'),_0x328e('0xe0'),_0x328e('0xee'),_0x328e('0xef'),_0x328e('0xf0'),_0x328e('0xe4'),_0x46edda+'Id'],'where':{'ContactId':_0x5828cd['params']['id']},'include':[{'model':db[_0x46edda],'as':_0x328e('0xeb'),'attributes':['id',_0x328e('0x1d'),_0x328e('0xf1')]},{'model':db[_0x328e('0xbd')],'as':_0x328e('0xf2'),'attributes':['id',_0x328e('0x1d'),_0x328e('0xe5')]},{'model':db['Tag'],'as':_0x328e('0x67'),'attributes':['id',_0x328e('0x1d'),_0x328e('0x68')],'through':{'attributes':[]}}],'order':[[_0x328e('0xe1'),_0x328e('0xe7')]]};if(_0x5828cd[_0x328e('0x21')][_0x328e('0xd5')]){_0x52fa1b[_0x328e('0x5c')][_0x328e('0xe1')]={'$gte':_0x43ac06['from'],'$lte':_0x43ac06['to']};}switch(_0x51c70c){case _0x328e('0xe9'):_0x52fa1b[_0x328e('0x7f')][_0x328e('0x5e')](_0x328e('0xf3'),_0x328e('0xf4'),'customerPort',_0x328e('0xf5'),'osName',_0x328e('0xf6'),'ratingType',_0x328e('0xf7'),_0x328e('0xf8'));break;case'mail':_0x52fa1b[_0x328e('0x7f')][_0x328e('0x5e')](_0x328e('0xf9'),_0x328e('0xfa'));break;case _0x328e('0xcd'):_0x52fa1b[_0x328e('0x7f')][_0x328e('0x5e')](_0x328e('0xfb'),_0x328e('0xfc'));break;}return db[_['startCase'](_0x51c70c)+_0x328e('0xfd')][_0x328e('0xfe')](_0x52fa1b)[_0x328e('0x18')](function(_0x3e370c){_0x3981fc[_0x328e('0x14')]+=_0x3e370c['count'];return _[_0x328e('0x6f')](_0x3e370c[_0x328e('0xa0')],function(_0x31e1fb){var _0x3531a8=_0x31e1fb[_0x328e('0x36')]({'plain':!![]});_0x3531a8[_0x328e('0xd3')]=_0x51c70c;if(_0x3531a8[_0x328e('0xf2')]){_0x3531a8[_0x328e('0xf2')]={'id':_0x3531a8[_0x328e('0xf2')]['id'],'name':_0x3531a8[_0x328e('0xf2')][_0x328e('0x1d')],'fullname':_0x3531a8[_0x328e('0xf2')][_0x328e('0xe5')]};}return _0x3531a8;});});}});return Promise['all'](_0x51fa4b);})['then'](function(_0x2a1c8a){return _(_0x2a1c8a)['flatten']()[_0x328e('0xff')]('createdAt')[_0x328e('0x100')]()['value']();})[_0x328e('0x18')](function(_0x177b1e){_0x3981fc[_0x328e('0xa0')]=_0x3ecaa6[_0x328e('0x12')]?_0x177b1e[_0x328e('0x101')](_0x3ecaa6[_0x328e('0x11')],_0x3ecaa6['offset']+_0x3ecaa6[_0x328e('0x12')]):_0x177b1e;return _0x3981fc;})['then'](respondWithFilteredResult(_0x58d1eb,_0x3ecaa6))['catch'](handleError(_0x58d1eb,null));};
\ No newline at end of file
+var _0x3c63=['length','get','mergeWith','isArray','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','from','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappMessage','WhatsappQueueReport','join','dialTimezone','isNil','timezones','utcOffset','additionalPhones','bulkCreate','each','duplicates','push','where','ListId','findOrCreate','contact','all','show','Tag','color','tag','CmContactHasItem','Phones','ContactItemType','ItemType','sequelize','literal','Phones.OrderBy','$and','omit','map','cf_%d','pickBy','format','setFields','id\x20=\x20?','toParam','text','phone','getTags','findOne','model','rawAttributes','filters','intersection','fields','attributes','sort','pick','filter','options','setTags','OrderBy','items','item_types','ItemTypeId','description','contact\x20phone\x20exists','PHONE','item','`ItemType`.OrderBy','CmHopperId','ItemType.OrderBy','CmHopperAdditionalPhone','getAdditionalPhones','fromContactId','toContactId','rescheduleAdditionalPhones','hopperId','getHoppers','nolimit','order','ContactId','includeAll','include','rows','CmHopperFinal','getJscriptySessions','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','socket_timestamp','split','No\x20phone\x20column\x20specified','firstName','server/files/tmp','file','filename','chmodSync','0777','child_process','fork','CompanyId','File\x20uploaded\x20correctly!','send','upload','createReadStream','parse','meta','User','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','../../components/import/cm/csv2','stringify','start\x20child\x20process\x20correctly!','pid','error\x20child\x20process','binding','No\x20firstName\x20column\x20specified','../../components/import/cm/csvUpdates','exit','getJourney','sms','openchannel','fax','whatsapp','voice','-createdAt','resolve','channel','includes','toLowerCase','Invalid\x20channel','range','Invalid\x20date\x20for\x20range\x20from\x20filter','isValid','Invalid\x20createdAt\x20filter','source','callerid','starttime','duration','note','createdAt','userDisposition','userSecondDisposition','userThirdDisposition','UserId','fullname','findAndCountAll','chat','Website','Account','closed','closedAt','thirdDisposition','key','Tags','DESC','browserName','customerIp','customerPort','deviceModel','osName','ratingMessage','ratingType','ratingValue','referer','mail','externalUrl','threadId','startCase','Interaction','Owner','flatten','sortBy','reverse','slice','moment','util','path','lodash','squel','ioredis','../../components/contacts','../../config/logger','api','../../config/environment','../../config/environment/shared','redis','defaults','localhost','./cmContact.socket','register','status','offset','undefined','limit','count','set','Content-Range','json','update','then','end','sendStatus','error','name','index','describe','getOptions','findAll','user','catch','destroy','CmContact','find','params','tags','keys','startsWith','columnName','displayName','query','analytics','CmCustomField','cf_','alias','type','values','info','Custom\x20field\x20%s\x20not\x20found\x20on\x20cm_contacts\x20table','forEach','hasOwnProperty','merge','body'];(function(_0xe96487,_0x36c816){var _0x500779=function(_0x97b53f){while(--_0x97b53f){_0xe96487['push'](_0xe96487['shift']());}};_0x500779(++_0x36c816);}(_0x3c63,0x1c0));var _0x33c6=function(_0x47aa64,_0xfb8a07){_0x47aa64=_0x47aa64-0x0;var _0x549c7a=_0x3c63[_0x47aa64];return _0x549c7a;};'use strict';var moment=require(_0x33c6('0x0'));var BPromise=require('bluebird');var util=require(_0x33c6('0x1'));var path=require(_0x33c6('0x2'));var fs=require('fs');var _=require(_0x33c6('0x3'));var squel=require(_0x33c6('0x4'));var Papa=require('papaparse');var Redis=require(_0x33c6('0x5'));var contacts=require(_0x33c6('0x6'));var qs=require('../../components/parsers/qs');var logger=require(_0x33c6('0x7'))(_0x33c6('0x8'));var config=require(_0x33c6('0x9'));var shared=require(_0x33c6('0xa'));var db=require('../../mysqldb')['db'];config[_0x33c6('0xb')]=_[_0x33c6('0xc')](config['redis'],{'host':_0x33c6('0xd'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x33c6('0xb')]));require(_0x33c6('0xe'))[_0x33c6('0xf')](socket);function respondWithResult(_0x345f10,_0xe20be6){_0xe20be6=_0xe20be6||0xc8;return function(_0x25b1b3){if(_0x25b1b3){return _0x345f10[_0x33c6('0x10')](_0xe20be6)['json'](_0x25b1b3);}};}function respondWithFilteredResult(_0x25cbe1,_0x27b773){return function(_0x1ed86f){if(_0x1ed86f){var _0x394e9d=typeof _0x27b773[_0x33c6('0x11')]===_0x33c6('0x12')&&typeof _0x27b773[_0x33c6('0x13')]===_0x33c6('0x12');var _0x122750=_0x1ed86f['count'];var _0x5a1be6=_0x394e9d?0x0:_0x27b773[_0x33c6('0x11')];var _0xa94506=_0x394e9d?_0x1ed86f[_0x33c6('0x14')]:_0x27b773[_0x33c6('0x11')]+_0x27b773[_0x33c6('0x13')];var _0x291ec0;if(_0xa94506>=_0x122750){_0xa94506=_0x122750;_0x291ec0=0xc8;}else{_0x291ec0=0xce;}_0x25cbe1[_0x33c6('0x10')](_0x291ec0);return _0x25cbe1[_0x33c6('0x15')](_0x33c6('0x16'),_0x5a1be6+'-'+_0xa94506+'/'+_0x122750)[_0x33c6('0x17')](_0x1ed86f);}return null;};}function saveUpdates(_0x1867c2){return function(_0x19f0f6){if(_0x19f0f6){return _0x19f0f6[_0x33c6('0x18')](_0x1867c2)[_0x33c6('0x19')](function(_0x58f8e3){return _0x58f8e3;});}return null;};}function removeEntity(_0x37bed2){return function(_0x31cda1){if(_0x31cda1){return _0x31cda1['destroy']()['then'](function(){_0x37bed2[_0x33c6('0x10')](0xcc)[_0x33c6('0x1a')]();});}};}function handleEntityNotFound(_0x170ae3){return function(_0x348ccb){if(!_0x348ccb){_0x170ae3[_0x33c6('0x1b')](0x194);}return _0x348ccb;};}function handleError(_0x10e66b,_0x48ed25){_0x48ed25=_0x48ed25||0x1f4;return function(_0x2b09e8){logger[_0x33c6('0x1c')](_0x2b09e8['stack']);if(_0x2b09e8[_0x33c6('0x1d')]){delete _0x2b09e8[_0x33c6('0x1d')];}_0x10e66b[_0x33c6('0x10')](_0x48ed25)['send'](_0x2b09e8);};}exports[_0x33c6('0x1e')]=function(_0x2629d0,_0x24aa33){var _0x38cd68={};return contacts[_0x33c6('0x1f')]()[_0x33c6('0x19')](function(_0x49471e){_0x38cd68=qs[_0x33c6('0x20')](_0x49471e,_0x2629d0);return contacts[_0x33c6('0x21')](_0x2629d0['query'],_0x2629d0[_0x33c6('0x22')],_0x38cd68,_0x49471e);})['then'](respondWithFilteredResult(_0x24aa33,_0x38cd68))[_0x33c6('0x23')](handleError(_0x24aa33,null));};exports[_0x33c6('0x24')]=function(_0x4c2aa9,_0x57cf25){return db[_0x33c6('0x25')][_0x33c6('0x26')]({'where':{'id':_0x4c2aa9[_0x33c6('0x27')]['id']}})[_0x33c6('0x19')](handleEntityNotFound(_0x57cf25,null))[_0x33c6('0x19')](removeEntity(_0x57cf25,null))['catch'](handleError(_0x57cf25,null));};exports[_0x33c6('0x1f')]=function(_0x5243cd,_0x5ef1f5){return db[_0x33c6('0x25')][_0x33c6('0x1f')]()['then'](function(_0x35d6c2){delete _0x35d6c2[_0x33c6('0x28')];for(var _0x44834c=0x0;_0x44834c<Object[_0x33c6('0x29')](_0x35d6c2)['length'];_0x44834c++){var _0x4fddbb=Object['keys'](_0x35d6c2)[_0x44834c];if(!_[_0x33c6('0x2a')](_0x4fddbb,'cf_')){_0x35d6c2[_0x4fddbb][_0x33c6('0x2b')]=_0x4fddbb;_0x35d6c2[_0x4fddbb][_0x33c6('0x2c')]=_0x4fddbb;}}return _0x35d6c2;})['then'](function(_0x59fa6b){var _0x43b513={'where':Boolean(_0x5243cd[_0x33c6('0x2d')][_0x33c6('0x2e')])===!![]?undefined:{'$or':[{'ListId':_0x5243cd[_0x33c6('0x2d')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x33c6('0x2f')][_0x33c6('0x21')](_0x43b513)[_0x33c6('0x19')](function(_0x429852){for(var _0x162be1=0x0;_0x162be1<_0x429852['length'];_0x162be1++){var _0x4ee415=_0x33c6('0x30')+_0x429852[_0x162be1]['id'];if(_0x59fa6b[_0x4ee415]){_0x59fa6b[_0x4ee415]['columnName']=_0x4ee415;_0x59fa6b[_0x4ee415][_0x33c6('0x2c')]=_0x429852[_0x162be1][_0x33c6('0x31')];_0x59fa6b[_0x4ee415]['custom']={'type':_0x429852[_0x162be1][_0x33c6('0x32')],'values':_0x429852[_0x162be1][_0x33c6('0x33')]};}else{logger[_0x33c6('0x34')](_0x33c6('0x35'),_0x4ee415);}}Object[_0x33c6('0x29')](_0x59fa6b)[_0x33c6('0x36')](function(_0x201b0b){if(!_0x59fa6b[_0x201b0b][_0x33c6('0x37')](_0x33c6('0x2b'))){delete _0x59fa6b[_0x201b0b];}});return _0x59fa6b;});})['then'](respondWithResult(_0x5ef1f5,null))[_0x33c6('0x23')](handleError(_0x5ef1f5,null));};exports[_0x33c6('0x38')]=function(_0x36659b,_0x5f0039){var _0x2c963f;var _0x17f3e6;var _0x4042ea;if(_0x36659b[_0x33c6('0x39')]['id']){delete _0x36659b[_0x33c6('0x39')]['id'];}return db[_0x33c6('0x25')][_0x33c6('0x21')]({'where':{'id':[_0x36659b['body']['to'],_0x36659b['body']['from']]}})['then'](function(_0x261a45){if(_0x261a45){if(_0x261a45[_0x33c6('0x3a')]!==0x2){return null;}_0x261a45[0x0]=_0x261a45[0x0][_0x33c6('0x3b')]({'plain':!![]});_0x261a45[0x1]=_0x261a45[0x1][_0x33c6('0x3b')]({'plain':!![]});delete _0x261a45[0x0]['id'];delete _0x261a45[0x1]['id'];return _[_0x33c6('0x3c')](_0x261a45[0x0],_0x261a45[0x1],function(_0x3cee74,_0x40eb33){if(Array[_0x33c6('0x3d')](_0x40eb33)&&!_0x40eb33[_0x33c6('0x3a')]){return _0x3cee74;}else if(!_0x40eb33){return _0x3cee74;}});}})['then'](handleEntityNotFound(_0x5f0039,null))['then'](function(_0x22b670){if(_0x22b670){if(_0x22b670[_0x33c6('0x28')]&&_[_0x33c6('0x3d')](_0x22b670[_0x33c6('0x28')])){_0x22b670[_0x33c6('0x28')]=_0x22b670[_0x33c6('0x28')]['join']();}logger['info'](_0x33c6('0x3e'),_0x36659b[_0x33c6('0x39')]['to'],_0x36659b[_0x33c6('0x39')]['from']);return db[_0x33c6('0x3f')][_0x33c6('0x24')]({'where':{'ContactId':[_0x36659b['body']['to'],_0x36659b[_0x33c6('0x39')][_0x33c6('0x40')]]}})['then'](function(_0x49b480){logger['info'](_0x33c6('0x41'),_0x49b480);return db[_0x33c6('0x42')][_0x33c6('0x24')]({'where':{'ContactId':[_0x36659b[_0x33c6('0x39')]['to'],_0x36659b['body'][_0x33c6('0x40')]]}})['then'](function(_0x39e4ae){logger[_0x33c6('0x34')]('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x39e4ae);return db[_0x33c6('0x25')][_0x33c6('0x43')](_0x22b670);});});}})['then'](function(_0x51945b){if(_0x51945b){_0x2c963f=_0x51945b;_0x17f3e6={'ContactId':_0x2c963f['id']};_0x4042ea={'where':{'ContactId':[_0x36659b[_0x33c6('0x39')]['to'],_0x36659b[_0x33c6('0x39')][_0x33c6('0x40')]]}};return db[_0x33c6('0x44')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x45')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x46')]['update'](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x47')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db['MailMessage'][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x47')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})['then'](function(){if(_0x2c963f){return db[_0x33c6('0x48')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})['then'](function(){if(_0x2c963f){return db['SmsInteraction'][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x49')]['update'](_0x17f3e6,_0x4042ea);}})['then'](function(){if(_0x2c963f){return db[_0x33c6('0x4a')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x4b')]['update'](_0x17f3e6,_0x4042ea);}})['then'](function(){if(_0x2c963f){return db[_0x33c6('0x4c')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})['then'](function(){if(_0x2c963f){return db[_0x33c6('0x4d')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db['CmContactHasItem'][_0x33c6('0x18')]({'CmContactId':_0x2c963f['id']},{'where':{'CmContactId':[_0x36659b[_0x33c6('0x39')]['to'],_0x36659b[_0x33c6('0x39')][_0x33c6('0x40')]]}});}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db['CmHopperFinal']['update'](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x4e')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x4f')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x50')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x51')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x52')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db['MailQueueReport'][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})['then'](function(){if(_0x2c963f){return db['OpenchannelQueueReport'][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db['SmsQueueReport'][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x53')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})['then'](function(){if(_0x2c963f){return db[_0x33c6('0x54')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x55')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x56')]['update'](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x25')][_0x33c6('0x24')]({'where':{'id':[_0x36659b[_0x33c6('0x39')]['to'],_0x36659b[_0x33c6('0x39')]['from']]}});}})[_0x33c6('0x19')](function(){if(_0x2c963f){return _0x2c963f;}})[_0x33c6('0x19')](respondWithResult(_0x5f0039,null))[_0x33c6('0x23')](handleError(_0x5f0039,null));};exports[_0x33c6('0x43')]=function(_0x1f935a,_0x1e8ec8){return db['CmContact'][_0x33c6('0x1f')]()[_0x33c6('0x19')](function(_0x36f1de){if(_0x1f935a['body'][_0x33c6('0x28')]&&_['isArray'](_0x1f935a[_0x33c6('0x39')][_0x33c6('0x28')])){if(_0x1f935a[_0x33c6('0x39')][_0x33c6('0x28')][_0x33c6('0x3a')]){_0x1f935a[_0x33c6('0x39')][_0x33c6('0x28')]=_0x1f935a[_0x33c6('0x39')][_0x33c6('0x28')][_0x33c6('0x57')](';')+';';}else{_0x1f935a[_0x33c6('0x39')]['tags']=null;}}else{_0x1f935a[_0x33c6('0x39')][_0x33c6('0x28')]=null;}if(!_['isNil'](_0x1f935a['body'][_0x33c6('0x58')])){var _0x3a4b0c=_0x1f935a['body'][_0x33c6('0x58')];if(!_[_0x33c6('0x59')](shared[_0x33c6('0x5a')][_0x3a4b0c]))_0x1f935a[_0x33c6('0x39')][_0x33c6('0x5b')]=shared[_0x33c6('0x5a')][_0x3a4b0c][_0x33c6('0x5b')];}return db[_0x33c6('0x25')][_0x33c6('0x43')](_0x1f935a[_0x33c6('0x39')],{'fields':_[_0x33c6('0x29')](_0x36f1de),'raw':!![]});})[_0x33c6('0x19')](function(_0x3cbd05){if(_0x1f935a[_0x33c6('0x39')][_0x33c6('0x5c')]){return insertAdditionalPhones(_0x3cbd05,_0x1f935a['body'][_0x33c6('0x5c')]);}else{return _0x3cbd05;}})[_0x33c6('0x19')](respondWithResult(_0x1e8ec8,0xc9))[_0x33c6('0x23')](handleError(_0x1e8ec8,null));};exports[_0x33c6('0x5d')]=function(_0x368176,_0x3ba84b){var _0x26f30b=0x0;var _0x298d03=0x0;var _0x4109c7=0x0;var _0x532537=[];return db[_0x33c6('0x25')][_0x33c6('0x1f')]()[_0x33c6('0x19')](function(_0x598898){return BPromise[_0x33c6('0x5e')](_0x368176[_0x33c6('0x39')],function(_0x1a98e9){var _0x35a8ec={'where':{'$or':[]},'defaults':_0x1a98e9,'fields':_[_0x33c6('0x29')](_0x598898),'raw':!![]};if(_0x1a98e9[_0x33c6('0x5f')]){for(var _0xbde114=0x0;_0xbde114<_0x1a98e9['duplicates'][_0x33c6('0x3a')];_0xbde114++){var _0xe91a8e={};_0xe91a8e[_0x1a98e9[_0x33c6('0x5f')][_0xbde114]]=_0x1a98e9[_0x1a98e9[_0x33c6('0x5f')][_0xbde114]];_0x35a8ec['where']['$or'][_0x33c6('0x60')](_0xe91a8e);}_0x35a8ec[_0x33c6('0x61')][_0x33c6('0x62')]=_0x1a98e9[_0x33c6('0x62')];}return db[_0x33c6('0x25')][_0x33c6('0x63')](_0x35a8ec)['spread'](function(_0x9a769d,_0xd8b16b){if(_0xd8b16b){if(_0x1a98e9[_0x33c6('0x37')]('additionalPhones')){_0x532537[_0x33c6('0x60')]({'contact':_0x9a769d,'additionalPhones':_0x1a98e9['additionalPhones']});}_0x26f30b++;}else{_0x4109c7++;}})[_0x33c6('0x23')](function(){_0x298d03++;});});})[_0x33c6('0x19')](function(_0x5eb861){if(_0x5eb861){if(_0x532537[_0x33c6('0x3a')]>0x0){return new Promise(function(_0x46fae3){var _0x4d4fee=[];for(var _0x3cb914=0x0;_0x3cb914<_0x532537[_0x33c6('0x3a')];_0x3cb914++){_0x4d4fee[_0x33c6('0x60')](insertAdditionalPhones(_0x532537[_0x3cb914][_0x33c6('0x64')],_0x532537[_0x3cb914][_0x33c6('0x5c')]));}Promise[_0x33c6('0x65')](_0x4d4fee)[_0x33c6('0x19')](function(){_0x46fae3(0x1);});})[_0x33c6('0x19')](function(){return{'success':_0x26f30b,'failure':_0x298d03,'duplicates':_0x4109c7};});}else{return{'success':_0x26f30b,'failure':_0x298d03,'duplicates':_0x4109c7};}}})[_0x33c6('0x19')](respondWithResult(_0x3ba84b,0xc9))['catch'](handleError(_0x3ba84b,null));};exports[_0x33c6('0x66')]=function(_0x2d6b1e,_0x157fc3){var _0x20fdf2;return db[_0x33c6('0x25')][_0x33c6('0x1f')]()[_0x33c6('0x19')](function(_0x45a217){return db[_0x33c6('0x25')]['find']({'where':{'id':_0x2d6b1e[_0x33c6('0x27')]['id']},'include':[{'model':db[_0x33c6('0x67')],'as':'Tags','attributes':['id','name',_0x33c6('0x68')],'required':_0x2d6b1e['query'][_0x33c6('0x69')]?!![]:![]},{'model':db[_0x33c6('0x6a')],'as':_0x33c6('0x6b'),'where':{'CmContactId':_0x2d6b1e[_0x33c6('0x27')]['id']},'required':![],'include':[{'model':db[_0x33c6('0x6c')],'as':_0x33c6('0x6d')}]}],'order':[db[_0x33c6('0x6e')][_0x33c6('0x6f')](_0x33c6('0x70'))],'attributes':_['keys'](_0x45a217)});})['then'](function(_0x19d8b6){if(!_[_0x33c6('0x59')](_0x19d8b6)){_0x20fdf2=_0x19d8b6['get']({'plain':!![]});var _0x571372={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x19d8b6&&_0x19d8b6[_0x33c6('0x62')]){if(_0x19d8b6['ListId']){_0x571372[_0x33c6('0x61')][_0x33c6('0x71')][_0x33c6('0x60')]({'ListId':{'$ne':_0x19d8b6[_0x33c6('0x62')]}});}}return db[_0x33c6('0x2f')][_0x33c6('0x21')](_0x571372);}})[_0x33c6('0x19')](function(_0x58e729){if(!_['isNil'](_0x58e729)){return _[_0x33c6('0x72')](_0x20fdf2,_[_0x33c6('0x73')](_0x58e729,function(_0x527f10){return util['format'](_0x33c6('0x74'),_0x527f10['id']);}));}})[_0x33c6('0x19')](handleEntityNotFound(_0x157fc3,null))[_0x33c6('0x19')](respondWithResult(_0x157fc3,null))[_0x33c6('0x23')](handleError(_0x157fc3,null));};exports[_0x33c6('0x18')]=function(_0x23e996,_0x25130d){var _0x3f246e;if(_0x23e996['body']['id']){delete _0x23e996['body']['id'];}if(!_['isNil'](_0x23e996[_0x33c6('0x39')][_0x33c6('0x58')])){var _0x5c2ddd=_0x23e996[_0x33c6('0x39')][_0x33c6('0x58')];if(!_['isNil'](shared['timezones'][_0x5c2ddd]))_0x23e996[_0x33c6('0x39')][_0x33c6('0x5b')]=shared[_0x33c6('0x5a')][_0x5c2ddd][_0x33c6('0x5b')];}return db[_0x33c6('0x25')][_0x33c6('0x26')]({'where':{'id':_0x23e996[_0x33c6('0x27')]['id']}})[_0x33c6('0x19')](handleEntityNotFound(_0x25130d,null))['then'](saveUpdates(_0x23e996[_0x33c6('0x39')],null))[_0x33c6('0x19')](function(_0x57fcbe){_0x3f246e=_0x57fcbe;var _0x4ae5c5={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x57fcbe&&_0x57fcbe[_0x33c6('0x62')]){if(_0x57fcbe['ListId']){_0x4ae5c5[_0x33c6('0x61')]['$and'][_0x33c6('0x60')]({'ListId':{'$ne':_0x57fcbe['ListId']}});}}return db['CmCustomField']['findAll'](_0x4ae5c5);})[_0x33c6('0x19')](function(_0x56ebd5){if(_0x56ebd5){return _[_0x33c6('0x72')](_[_0x33c6('0x75')](_0x23e996['body'],function(_0x5906cf,_0x329b6a){return _[_0x33c6('0x2a')](_0x329b6a,_0x33c6('0x30'));}),_['map'](_0x56ebd5,function(_0x365ab3){return util[_0x33c6('0x76')](_0x33c6('0x74'),_0x365ab3['id']);}));}})[_0x33c6('0x19')](function(_0x50b0c7){if(_0x50b0c7&&!_['isEmpty'](_0x50b0c7)){var _0x316d8c=squel[_0x33c6('0x18')]()['table']('cm_contacts')[_0x33c6('0x77')](_0x50b0c7)[_0x33c6('0x61')](_0x33c6('0x78'),_0x23e996[_0x33c6('0x27')]['id'])[_0x33c6('0x79')]();return db[_0x33c6('0x6e')]['query'](_0x316d8c[_0x33c6('0x7a')],{'replacements':_0x316d8c[_0x33c6('0x33')]});}})['then'](function(){if(_0x23e996[_0x33c6('0x39')]['phone']&&_0x3f246e){return db[_0x33c6('0x3f')][_0x33c6('0x18')]({'phone':_0x23e996[_0x33c6('0x39')][_0x33c6('0x7b')],'OrderBy':0x0},{'where':{'ContactId':_0x3f246e['id']}});}})[_0x33c6('0x19')](function(){return _0x3f246e;})['then'](respondWithResult(_0x25130d,null))['catch'](handleError(_0x25130d,null));};exports[_0x33c6('0x7c')]=function(_0x578f07,_0x2ef105){var _0x4739cc={};var _0x35068c={};var _0x473745;var _0x6bcdb0;return db[_0x33c6('0x25')][_0x33c6('0x7d')]({'where':{'id':_0x578f07['params']['id']}})[_0x33c6('0x19')](handleEntityNotFound(_0x2ef105,null))[_0x33c6('0x19')](function(_0x17bcc9){if(_0x17bcc9){_0x473745=_0x17bcc9;_0x35068c[_0x33c6('0x7e')]=_[_0x33c6('0x29')](db[_0x33c6('0x67')][_0x33c6('0x7f')]);_0x35068c['query']=_['keys'](_0x578f07[_0x33c6('0x2d')]);_0x35068c[_0x33c6('0x80')]=_[_0x33c6('0x81')](_0x35068c[_0x33c6('0x7e')],_0x35068c[_0x33c6('0x2d')]);_0x4739cc['attributes']=_[_0x33c6('0x81')](_0x35068c[_0x33c6('0x7e')],qs[_0x33c6('0x82')](_0x578f07['query'][_0x33c6('0x82')]));_0x4739cc[_0x33c6('0x83')]=_0x4739cc[_0x33c6('0x83')][_0x33c6('0x3a')]?_0x4739cc[_0x33c6('0x83')]:_0x35068c['model'];_0x4739cc['order']=qs[_0x33c6('0x84')](_0x578f07[_0x33c6('0x2d')][_0x33c6('0x84')]);_0x4739cc[_0x33c6('0x61')]=qs[_0x33c6('0x80')](_[_0x33c6('0x85')](_0x578f07['query'],_0x35068c[_0x33c6('0x80')]));if(_0x578f07[_0x33c6('0x2d')][_0x33c6('0x86')]){_0x4739cc['where']=_[_0x33c6('0x38')](_0x4739cc[_0x33c6('0x61')],{'$or':_[_0x33c6('0x73')](_0x4739cc['attributes'],function(_0x260107){var _0x5cc06a={};_0x5cc06a[_0x260107]={'$like':'%'+_0x578f07[_0x33c6('0x2d')][_0x33c6('0x86')]+'%'};return _0x5cc06a;})});}_0x4739cc=_[_0x33c6('0x38')]({},_0x4739cc,_0x578f07[_0x33c6('0x87')]);return _0x473745['getTags'](_0x4739cc);}})[_0x33c6('0x19')](function(_0x3037c5){if(_0x3037c5){_0x6bcdb0=_0x3037c5[_0x33c6('0x3a')];if(!_0x578f07[_0x33c6('0x2d')][_0x33c6('0x37')]('nolimit')){_0x4739cc[_0x33c6('0x13')]=qs[_0x33c6('0x13')](_0x578f07[_0x33c6('0x2d')][_0x33c6('0x13')]);_0x4739cc['offset']=qs[_0x33c6('0x11')](_0x578f07[_0x33c6('0x2d')][_0x33c6('0x11')]);}return _0x473745[_0x33c6('0x7c')](_0x4739cc);}})[_0x33c6('0x19')](function(_0x7ec66c){if(_0x7ec66c){return _0x7ec66c?{'count':_0x6bcdb0,'rows':_0x7ec66c}:null;}})[_0x33c6('0x19')](respondWithResult(_0x2ef105,null))[_0x33c6('0x23')](handleError(_0x2ef105,null));};exports[_0x33c6('0x88')]=function(_0x19a212,_0x112edf){if(_0x19a212[_0x33c6('0x39')]['id']){delete _0x19a212[_0x33c6('0x39')]['id'];}return db[_0x33c6('0x25')][_0x33c6('0x7d')]({'where':{'id':_0x19a212[_0x33c6('0x27')]['id']}})['then'](handleEntityNotFound(_0x112edf,null))[_0x33c6('0x19')](function(_0x23fa2e){if(_0x23fa2e){return _0x23fa2e[_0x33c6('0x88')](_0x19a212['body']['ids']||[]);}return null;})[_0x33c6('0x19')](respondWithResult(_0x112edf,null))[_0x33c6('0x23')](handleError(_0x112edf,null));};exports['setAdditionalPhones']=function(_0x5268a6,_0x421a4a){var _0x369f30=[];_0x369f30[_0x33c6('0x60')](addAdditionalPhones(_0x5268a6['body']));Promise[_0x33c6('0x65')](_0x369f30)['then'](function(){_0x369f30=[];_0x369f30['push'](deleteCmHopperPhones(_0x5268a6[_0x33c6('0x39')]['id']));_0x369f30['push'](addCmHopperPhones(_0x5268a6[_0x33c6('0x39')]['id']));Promise[_0x33c6('0x65')](_0x369f30)[_0x33c6('0x19')](function(){return[0x1];})[_0x33c6('0x19')](respondWithResult(_0x421a4a,null));});};function addAdditionalPhones(_0x1b80c0){var _0x21a239;return new Promise(function(_0x3d5861){return db[_0x33c6('0x6a')][_0x33c6('0x24')]({'where':{'CmContactId':_0x1b80c0['id']}})[_0x33c6('0x19')](function(){db['ContactItemType'][_0x33c6('0x21')]({'raw':!![],'attributes':['id',_0x33c6('0x89')]})['then'](function(_0x1621b3){var _0x249aa9=[];for(var _0x1c0d22=0x0;_0x1c0d22<_0x1b80c0[_0x33c6('0x8a')][_0x33c6('0x3a')];_0x1c0d22++){var _0x5ea8d8=_0x1b80c0[_0x33c6('0x8b')]?_['isNil'](_0x1b80c0[_0x33c6('0x8b')][_0x1c0d22])?'':_0x1b80c0[_0x33c6('0x8b')][_0x1c0d22]:_0x1b80c0[_0x33c6('0x8a')][_0x1c0d22][_0x33c6('0x8c')]?_0x1b80c0['items'][_0x1c0d22][_0x33c6('0x8c')]:'';var _0x40818a=_[_0x33c6('0x59')](_0x1b80c0['items'][_0x1c0d22]['description'])?'':_0x1b80c0[_0x33c6('0x8a')][_0x1c0d22][_0x33c6('0x8d')];var _0x328963=_0x5ea8d8+':'+_0x1b80c0[_0x33c6('0x8a')][_0x1c0d22][_0x33c6('0x7b')]+'§'+_0x40818a;if(_[_0x33c6('0x59')](_0x21a239))_0x21a239=_0x328963;else _0x21a239+=';'+_0x328963;var _0x56f73b=null;var _0x3505bc=null;if(_0x1b80c0[_0x33c6('0x8b')]){if(!_[_0x33c6('0x59')](_0x1b80c0[_0x33c6('0x8b')][_0x1c0d22])){_0x3505bc=_['find'](_0x1621b3,function(_0x169b48){return _0x169b48['id']===_0x1b80c0[_0x33c6('0x8b')][_0x1c0d22];});if(!_[_0x33c6('0x59')](_0x3505bc)){_0x56f73b=_0x3505bc['OrderBy'];}}}else{if(!_[_0x33c6('0x59')](_0x1b80c0[_0x33c6('0x8a')][_0x1c0d22])){_0x3505bc=_['find'](_0x1621b3,function(_0xb165b7){return _0xb165b7['id']===_0x1b80c0['items'][_0x1c0d22][_0x33c6('0x8c')];});if(!_[_0x33c6('0x59')](_0x3505bc)){_0x56f73b=_0x1c0d22;}}}if(_[_0x33c6('0x59')](_0x56f73b)){_0x56f73b=0x64;}_0x249aa9[_0x33c6('0x60')](addAdditionalPhone(_0x1b80c0['id'],_0x1b80c0['items'][_0x1c0d22][_0x33c6('0x7b')],_0x1b80c0[_0x33c6('0x8b')]?_[_0x33c6('0x59')](_0x1b80c0['item_types'][_0x1c0d22])?null:_0x1b80c0[_0x33c6('0x8b')][_0x1c0d22]:_0x1b80c0['items'][_0x1c0d22][_0x33c6('0x8c')]?_0x1b80c0['items'][_0x1c0d22][_0x33c6('0x8c')]:null,_0x56f73b,_0x40818a));}Promise[_0x33c6('0x65')](_0x249aa9)[_0x33c6('0x19')](function(){db[_0x33c6('0x25')]['update']({'AdditionalPhones':_0x21a239},{'where':{'id':_0x1b80c0['id']}})[_0x33c6('0x19')](function(){_0x3d5861(0x1);});});});});});}function addAdditionalPhone(_0x971165,_0x25b1ac,_0x4e8f86,_0x4d37d5,_0x17c9f1){return db['CmContactHasItem'][_0x33c6('0x26')]({'where':{'CmContactId':_0x971165,'item':_0x25b1ac}})[_0x33c6('0x19')](function(_0x21d248){if(_0x21d248)logger[_0x33c6('0x34')](_0x33c6('0x8e'),_0x21d248);else{db[_0x33c6('0x6a')][_0x33c6('0x43')]({'CmContactId':_0x971165,'item':_0x25b1ac,'ItemTypeId':_0x4e8f86,'OrderBy':_0x4d37d5,'ItemClass':_0x33c6('0x8f'),'description':_0x17c9f1});}});}function deleteCmHopperPhones(_0x53b844){return new Promise(function(_0x41497e){return db[_0x33c6('0x3f')][_0x33c6('0x21')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x53b844}})[_0x33c6('0x19')](function(_0x143334){db['CmHopperAdditionalPhone'][_0x33c6('0x24')]({'where':{'CmHopperId':{'$in':_[_0x33c6('0x73')](_0x143334,'id')}}});})[_0x33c6('0x19')](function(){_0x41497e(0x1);});});}function addCmHopperPhones(_0x3213fc){return new Promise(function(_0x436e3b){return db[_0x33c6('0x3f')][_0x33c6('0x21')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x3213fc}})[_0x33c6('0x19')](function(_0x39aa0d){var _0x13a00d=[];_['map'](_0x39aa0d,function(_0x295a31){_0x13a00d[_0x33c6('0x60')](createCmHopperPhone(_0x3213fc,_0x295a31['id']));});Promise[_0x33c6('0x65')](_0x13a00d)[_0x33c6('0x19')](function(){_0x436e3b(0x1);});});});}function createCmHopperPhone(_0x4fb21d,_0x1b1a0a){return new Promise(function(_0x1ba890){db['CmContactHasItem'][_0x33c6('0x21')]({'raw':!![],'attributes':[_0x33c6('0x90'),'OrderBy'],'where':{'CmContactId':_0x4fb21d,'ItemClass':_0x33c6('0x8f')},'include':[{'model':db[_0x33c6('0x6c')],'attributes':[_0x33c6('0x89')],'as':_0x33c6('0x6d')}],'order':['OrderBy',db[_0x33c6('0x6e')][_0x33c6('0x6f')](_0x33c6('0x91'))]})[_0x33c6('0x19')](function(_0x3688b1){var _0x131521=0x1;var _0xa4b8e3=_[_0x33c6('0x73')](_0x3688b1,function(_0x3969b5){_0x3969b5[_0x33c6('0x92')]=_0x1b1a0a;_0x3969b5[_0x33c6('0x7b')]=_0x3969b5[_0x33c6('0x90')];_0x3969b5[_0x33c6('0x89')]=_0x131521;delete _0x3969b5[_0x33c6('0x93')];_0x131521=_0x131521+0x1;return _0x3969b5;});return db[_0x33c6('0x94')]['bulkCreate'](_0xa4b8e3,{});})[_0x33c6('0x19')](function(){_0x1ba890(0x1);});});}function insertAdditionalPhones(_0x38e6ac,_0x50ecb1){return new Promise(function(_0x505107){var _0x17a2e5=[];for(var _0x3e710f=0x0;_0x3e710f<_0x50ecb1['length'];_0x3e710f++){var _0x27c114=_0x50ecb1[_0x3e710f];_0x17a2e5['push'](parseContactItemType(_0x27c114));}Promise[_0x33c6('0x65')](_0x17a2e5)['then'](function(){var _0x5f407a={'id':_0x38e6ac['id'],'items':_0x50ecb1};return addAdditionalPhones(_0x5f407a)[_0x33c6('0x19')](function(){return addCmHopperPhones(_0x38e6ac['id']);});})[_0x33c6('0x19')](function(){_0x505107(_0x38e6ac);});});}function parseContactItemType(_0x4cfa55){return new Promise(function(_0x1d3f1b){if(_0x4cfa55[_0x33c6('0x37')]('ItemTypeId')){_0x1d3f1b(_0x4cfa55);}else{return db[_0x33c6('0x6c')]['find']({'where':{'name':_0x4cfa55['ItemType']}})['then'](function(_0x2252fd){if(_['isNil'](_0x2252fd))_0x4cfa55[_0x33c6('0x8c')]=null;else _0x4cfa55[_0x33c6('0x8c')]=_0x2252fd['id'];_0x1d3f1b(_0x4cfa55);});}});}exports[_0x33c6('0x95')]=function(_0x1d7e3a,_0x54c1bc){return db['CmContactHasItem'][_0x33c6('0x21')]({'raw':!![],'where':{'CmContactId':_0x1d7e3a[_0x33c6('0x27')]['id'],'ItemClass':_0x33c6('0x8f')},'include':[{'model':db[_0x33c6('0x6c')],'as':'ItemType'}],'order':[['OrderBy'],[db['sequelize'][_0x33c6('0x6f')](_0x33c6('0x91'))]]})[_0x33c6('0x19')](function(_0x16cea1){return _0x16cea1;})[_0x33c6('0x19')](respondWithResult(_0x54c1bc,null))[_0x33c6('0x23')](handleError(_0x54c1bc,null));};exports['duplicateAdditionalPhones']=function(_0x3afd93,_0x2da6fe){return db['CmContactHasItem'][_0x33c6('0x21')]({'raw':!![],'where':{'CmContactId':_0x3afd93['body'][_0x33c6('0x96')]}})[_0x33c6('0x19')](function(_0x54b765){var _0x323420=_[_0x33c6('0x73')](_0x54b765,function(_0x4f2f15){_0x4f2f15['CmContactId']=_0x3afd93['body'][_0x33c6('0x97')];return _0x4f2f15;});return db['CmContactHasItem'][_0x33c6('0x5d')](_0x323420,{});})[_0x33c6('0x19')](function(){return addCmHopperPhones(_0x3afd93[_0x33c6('0x39')][_0x33c6('0x97')]);})[_0x33c6('0x19')](function(){return['ok'];})[_0x33c6('0x19')](respondWithResult(_0x2da6fe,null))[_0x33c6('0x23')](handleError(_0x2da6fe,null));};exports[_0x33c6('0x98')]=function(_0x4aeef3,_0xfcdd51){var _0x2faa27=[];_0x2faa27[_0x33c6('0x60')](createCmHopperPhone(_0x4aeef3['body']['id'],_0x4aeef3[_0x33c6('0x39')][_0x33c6('0x99')]));Promise[_0x33c6('0x65')](_0x2faa27)[_0x33c6('0x19')](function(){return[0x1];})[_0x33c6('0x19')](respondWithResult(_0xfcdd51,null));};exports[_0x33c6('0x9a')]=function(_0xa455a0,_0x8c3de5){var _0x3c11a7={'raw':![],'where':{}};var _0x91b354={};var _0x1b3025={'count':0x0,'rows':[]};return db['CmContact'][_0x33c6('0x7d')]({'where':{'id':_0xa455a0[_0x33c6('0x27')]['id']}})[_0x33c6('0x19')](handleEntityNotFound(_0x8c3de5,null))['then'](function(_0x18c712){if(_0x18c712){_0x91b354['model']=_[_0x33c6('0x29')](db[_0x33c6('0x3f')][_0x33c6('0x7f')]);_0x91b354[_0x33c6('0x2d')]=_[_0x33c6('0x29')](_0xa455a0[_0x33c6('0x2d')]);_0x91b354['filters']=_['intersection'](_0x91b354[_0x33c6('0x7e')],_0x91b354['query']);_0x3c11a7['attributes']=_[_0x33c6('0x81')](_0x91b354['model'],qs[_0x33c6('0x82')](_0xa455a0[_0x33c6('0x2d')][_0x33c6('0x82')]));_0x3c11a7[_0x33c6('0x83')]=_0x3c11a7[_0x33c6('0x83')][_0x33c6('0x3a')]?_0x3c11a7[_0x33c6('0x83')]:_0x91b354[_0x33c6('0x7e')];if(!_0xa455a0['query'][_0x33c6('0x37')](_0x33c6('0x9b'))){_0x3c11a7['limit']=qs[_0x33c6('0x13')](_0xa455a0[_0x33c6('0x2d')]['limit']);_0x3c11a7[_0x33c6('0x11')]=qs[_0x33c6('0x11')](_0xa455a0['query']['offset']);}_0x3c11a7[_0x33c6('0x9c')]=qs['sort'](_0xa455a0[_0x33c6('0x2d')][_0x33c6('0x84')]);_0x3c11a7[_0x33c6('0x61')]=qs[_0x33c6('0x80')](_[_0x33c6('0x85')](_0xa455a0[_0x33c6('0x2d')],_0x91b354[_0x33c6('0x80')]));_0x3c11a7[_0x33c6('0x61')][_0x33c6('0x9d')]=_0x18c712['id'];if(_0xa455a0[_0x33c6('0x2d')][_0x33c6('0x86')]){_0x3c11a7[_0x33c6('0x61')]=_[_0x33c6('0x38')](_0x3c11a7[_0x33c6('0x61')],{'$or':_[_0x33c6('0x73')](_0x3c11a7['attributes'],function(_0x234ddc){var _0x1587ee={};_0x1587ee[_0x234ddc]={'$like':'%'+_0xa455a0['query']['filter']+'%'};return _0x1587ee;})});}_0x3c11a7=_[_0x33c6('0x38')]({},_0x3c11a7,_0xa455a0['options']);return db['CmHopper'][_0x33c6('0x14')]({'where':_0x3c11a7[_0x33c6('0x61')]})['then'](function(_0x45cca3){_0x1b3025['count']=_0x45cca3;if(_0xa455a0[_0x33c6('0x2d')][_0x33c6('0x9e')]){_0x3c11a7[_0x33c6('0x9f')]=[{'all':!![]}];}return db[_0x33c6('0x3f')][_0x33c6('0x21')](_0x3c11a7);})[_0x33c6('0x19')](function(_0xcd6e21){_0x1b3025[_0x33c6('0xa0')]=_0xcd6e21;return _0x1b3025;});}})[_0x33c6('0x19')](respondWithFilteredResult(_0x8c3de5,_0x3c11a7))[_0x33c6('0x23')](handleError(_0x8c3de5,null));};exports['getHopperHistories']=function(_0x5d05fe,_0x1c40cc){var _0x186f50={'raw':!![],'where':{}};var _0x13d50e={};var _0x27d090={'count':0x0,'rows':[]};return db['CmContact'][_0x33c6('0x7d')]({'where':{'id':_0x5d05fe[_0x33c6('0x27')]['id']}})[_0x33c6('0x19')](handleEntityNotFound(_0x1c40cc,null))[_0x33c6('0x19')](function(_0x4bb04c){if(_0x4bb04c){_0x13d50e[_0x33c6('0x7e')]=_[_0x33c6('0x29')](db[_0x33c6('0x4e')]['rawAttributes']);_0x13d50e[_0x33c6('0x2d')]=_[_0x33c6('0x29')](_0x5d05fe[_0x33c6('0x2d')]);_0x13d50e[_0x33c6('0x80')]=_[_0x33c6('0x81')](_0x13d50e['model'],_0x13d50e[_0x33c6('0x2d')]);_0x186f50['attributes']=_[_0x33c6('0x81')](_0x13d50e[_0x33c6('0x7e')],qs[_0x33c6('0x82')](_0x5d05fe[_0x33c6('0x2d')][_0x33c6('0x82')]));_0x186f50[_0x33c6('0x83')]=_0x186f50[_0x33c6('0x83')][_0x33c6('0x3a')]?_0x186f50['attributes']:_0x13d50e['model'];if(!_0x5d05fe[_0x33c6('0x2d')]['hasOwnProperty']('nolimit')){_0x186f50['limit']=qs[_0x33c6('0x13')](_0x5d05fe[_0x33c6('0x2d')]['limit']);_0x186f50[_0x33c6('0x11')]=qs['offset'](_0x5d05fe[_0x33c6('0x2d')][_0x33c6('0x11')]);}_0x186f50[_0x33c6('0x9c')]=qs[_0x33c6('0x84')](_0x5d05fe['query'][_0x33c6('0x84')]);_0x186f50[_0x33c6('0x61')]=qs[_0x33c6('0x80')](_[_0x33c6('0x85')](_0x5d05fe[_0x33c6('0x2d')],_0x13d50e[_0x33c6('0x80')]));_0x186f50['where']['ContactId']=_0x4bb04c['id'];if(_0x5d05fe[_0x33c6('0x2d')][_0x33c6('0x86')]){_0x186f50[_0x33c6('0x61')]=_[_0x33c6('0x38')](_0x186f50[_0x33c6('0x61')],{'$or':_[_0x33c6('0x73')](_0x186f50[_0x33c6('0x83')],function(_0x1e36fc){var _0x55f245={};_0x55f245[_0x1e36fc]={'$like':'%'+_0x5d05fe[_0x33c6('0x2d')][_0x33c6('0x86')]+'%'};return _0x55f245;})});}_0x186f50=_[_0x33c6('0x38')]({},_0x186f50,_0x5d05fe[_0x33c6('0x87')]);return db[_0x33c6('0x4e')][_0x33c6('0x14')]({'where':_0x186f50[_0x33c6('0x61')]})[_0x33c6('0x19')](function(_0x2e7872){_0x27d090[_0x33c6('0x14')]=_0x2e7872;if(_0x5d05fe[_0x33c6('0x2d')][_0x33c6('0x9e')]){_0x186f50['include']=[{'all':!![]}];}return db[_0x33c6('0x4e')][_0x33c6('0x21')](_0x186f50);})[_0x33c6('0x19')](function(_0x46458c){_0x27d090['rows']=_0x46458c;return _0x27d090;});}})[_0x33c6('0x19')](respondWithFilteredResult(_0x1c40cc,_0x186f50))[_0x33c6('0x23')](handleError(_0x1c40cc,null));};exports['getHopperFinals']=function(_0x2f1dba,_0x136de8){var _0x5cfdac={'raw':!![],'where':{}};var _0x966bf={};var _0xc127b0={'count':0x0,'rows':[]};return db[_0x33c6('0x25')][_0x33c6('0x7d')]({'where':{'id':_0x2f1dba['params']['id']}})['then'](handleEntityNotFound(_0x136de8,null))['then'](function(_0x794083){if(_0x794083){_0x966bf[_0x33c6('0x7e')]=_['keys'](db[_0x33c6('0xa1')][_0x33c6('0x7f')]);_0x966bf[_0x33c6('0x2d')]=_['keys'](_0x2f1dba[_0x33c6('0x2d')]);_0x966bf['filters']=_[_0x33c6('0x81')](_0x966bf[_0x33c6('0x7e')],_0x966bf[_0x33c6('0x2d')]);_0x5cfdac['attributes']=_[_0x33c6('0x81')](_0x966bf[_0x33c6('0x7e')],qs[_0x33c6('0x82')](_0x2f1dba['query'][_0x33c6('0x82')]));_0x5cfdac[_0x33c6('0x83')]=_0x5cfdac[_0x33c6('0x83')][_0x33c6('0x3a')]?_0x5cfdac[_0x33c6('0x83')]:_0x966bf[_0x33c6('0x7e')];if(!_0x2f1dba['query'][_0x33c6('0x37')](_0x33c6('0x9b'))){_0x5cfdac['limit']=qs['limit'](_0x2f1dba[_0x33c6('0x2d')][_0x33c6('0x13')]);_0x5cfdac[_0x33c6('0x11')]=qs[_0x33c6('0x11')](_0x2f1dba['query'][_0x33c6('0x11')]);}_0x5cfdac[_0x33c6('0x9c')]=qs['sort'](_0x2f1dba[_0x33c6('0x2d')]['sort']);_0x5cfdac[_0x33c6('0x61')]=qs[_0x33c6('0x80')](_[_0x33c6('0x85')](_0x2f1dba[_0x33c6('0x2d')],_0x966bf[_0x33c6('0x80')]));_0x5cfdac[_0x33c6('0x61')]['ContactId']=_0x794083['id'];if(_0x2f1dba[_0x33c6('0x2d')][_0x33c6('0x86')]){_0x5cfdac['where']=_[_0x33c6('0x38')](_0x5cfdac[_0x33c6('0x61')],{'$or':_[_0x33c6('0x73')](_0x5cfdac['attributes'],function(_0x25ab7d){var _0x3cbcf4={};_0x3cbcf4[_0x25ab7d]={'$like':'%'+_0x2f1dba[_0x33c6('0x2d')][_0x33c6('0x86')]+'%'};return _0x3cbcf4;})});}_0x5cfdac=_['merge']({},_0x5cfdac,_0x2f1dba[_0x33c6('0x87')]);return db[_0x33c6('0xa1')][_0x33c6('0x14')]({'where':_0x5cfdac[_0x33c6('0x61')]})['then'](function(_0x129b70){_0xc127b0['count']=_0x129b70;if(_0x2f1dba[_0x33c6('0x2d')][_0x33c6('0x9e')]){_0x5cfdac[_0x33c6('0x9f')]=[{'all':!![]}];}return db['CmHopperFinal'][_0x33c6('0x21')](_0x5cfdac);})[_0x33c6('0x19')](function(_0x53e14b){_0xc127b0[_0x33c6('0xa0')]=_0x53e14b;return _0xc127b0;});}})[_0x33c6('0x19')](respondWithFilteredResult(_0x136de8,_0x5cfdac))[_0x33c6('0x23')](handleError(_0x136de8,null));};exports[_0x33c6('0xa2')]=function(_0xeb3204,_0x10cdd9){var _0x15ca2a={'raw':!![],'where':{}};var _0x461896={};var _0x4b06c3={'count':0x0,'rows':[]};return db[_0x33c6('0x25')][_0x33c6('0x7d')]({'where':{'id':_0xeb3204['params']['id']}})[_0x33c6('0x19')](handleEntityNotFound(_0x10cdd9,null))['then'](function(_0x1bbdba){if(_0x1bbdba){_0x461896['model']=_[_0x33c6('0x29')](db['JscriptySessionReport'][_0x33c6('0x7f')]);_0x461896[_0x33c6('0x2d')]=_[_0x33c6('0x29')](_0xeb3204[_0x33c6('0x2d')]);_0x461896[_0x33c6('0x80')]=_['intersection'](_0x461896[_0x33c6('0x7e')],_0x461896[_0x33c6('0x2d')]);_0x15ca2a['attributes']=_['intersection'](_0x461896[_0x33c6('0x7e')],qs[_0x33c6('0x82')](_0xeb3204['query']['fields']));_0x15ca2a[_0x33c6('0x83')]=_0x15ca2a[_0x33c6('0x83')]['length']?_0x15ca2a[_0x33c6('0x83')]:_0x461896[_0x33c6('0x7e')];if(!_0xeb3204[_0x33c6('0x2d')][_0x33c6('0x37')](_0x33c6('0x9b'))){_0x15ca2a[_0x33c6('0x13')]=qs['limit'](_0xeb3204[_0x33c6('0x2d')][_0x33c6('0x13')]);_0x15ca2a[_0x33c6('0x11')]=qs[_0x33c6('0x11')](_0xeb3204[_0x33c6('0x2d')][_0x33c6('0x11')]);}_0x15ca2a['order']=qs[_0x33c6('0x84')](_0xeb3204['query'][_0x33c6('0x84')]);_0x15ca2a[_0x33c6('0x61')]=qs[_0x33c6('0x80')](_[_0x33c6('0x85')](_0xeb3204['query'],_0x461896[_0x33c6('0x80')]));_0x15ca2a[_0x33c6('0x61')][_0x33c6('0x9d')]=_0x1bbdba['id'];if(_0xeb3204[_0x33c6('0x2d')]['filter']){_0x15ca2a[_0x33c6('0x61')]=_['merge'](_0x15ca2a['where'],{'$or':_[_0x33c6('0x73')](_0x15ca2a[_0x33c6('0x83')],function(_0x11b0b8){var _0x40e0cd={};_0x40e0cd[_0x11b0b8]={'$like':'%'+_0xeb3204[_0x33c6('0x2d')][_0x33c6('0x86')]+'%'};return _0x40e0cd;})});}_0x15ca2a=_[_0x33c6('0x38')]({},_0x15ca2a,_0xeb3204[_0x33c6('0x87')]);return db[_0x33c6('0x53')][_0x33c6('0x14')]({'where':_0x15ca2a['where']})[_0x33c6('0x19')](function(_0x34dc5e){_0x4b06c3['count']=_0x34dc5e;if(_0xeb3204[_0x33c6('0x2d')][_0x33c6('0x9e')]){_0x15ca2a['include']=[{'all':!![]}];}return db[_0x33c6('0x53')][_0x33c6('0x21')](_0x15ca2a);})[_0x33c6('0x19')](function(_0x4dc593){_0x4b06c3['rows']=_0x4dc593;return _0x4b06c3;});}})[_0x33c6('0x19')](respondWithFilteredResult(_0x10cdd9,_0x15ca2a))[_0x33c6('0x23')](handleError(_0x10cdd9,null));};exports['uploadCsv']=function(_0x3b26ad,_0x298e15){try{if(!_0x3b26ad[_0x33c6('0x39')][_0x33c6('0x62')]){throw new Error(_0x33c6('0xa3'));}if(!_0x3b26ad[_0x33c6('0x39')][_0x33c6('0xa4')]){throw new Error(_0x33c6('0xa5'));}if(!_0x3b26ad[_0x33c6('0x39')][_0x33c6('0xa6')]){throw new Error(_0x33c6('0xa7'));}if(!_0x3b26ad['body'][_0x33c6('0xa8')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x4672ae=_0x3b26ad['body'][_0x33c6('0xa4')][_0x33c6('0xa9')](',');var _0x13968a=_0x3b26ad[_0x33c6('0x39')][_0x33c6('0xa6')]['split'](',');if(!_0x4672ae['length']||!_0x13968a[_0x33c6('0x3a')]||_0x4672ae[_0x33c6('0x3a')]!==_0x13968a['length']){throw new Error('Incorrect\x20binding\x20parameters\x20passed!');}_0x3b26ad['body'][_0x33c6('0x82')]=_['zipObject'](_0x4672ae,_0x13968a);if(!_0x3b26ad[_0x33c6('0x39')][_0x33c6('0x82')]['phone']){throw new Error(_0x33c6('0xaa'));}if(!_0x3b26ad[_0x33c6('0x39')][_0x33c6('0x82')][_0x33c6('0xab')]){throw new Error('No\x20firstName\x20column\x20specified');}var _0x448fc6=path[_0x33c6('0x57')](config['root'],_0x33c6('0xac'),_0x3b26ad[_0x33c6('0xad')][_0x33c6('0xae')]);fs[_0x33c6('0xaf')](_0x448fc6,parseInt(_0x33c6('0xb0'),0x8));var _0x41b8cc=require(_0x33c6('0xb1'))[_0x33c6('0xb2')](path[_0x33c6('0x57')](__dirname,'../../components/import/cm/csv'),[_0x448fc6,_0x3b26ad[_0x33c6('0x39')]['binding_keys'],_0x3b26ad[_0x33c6('0x39')][_0x33c6('0xa6')],_0x3b26ad['body'][_0x33c6('0x62')],_0x3b26ad['body'][_0x33c6('0xb3')],_0x3b26ad[_0x33c6('0x39')][_0x33c6('0x5f')],_0x3b26ad[_0x33c6('0x39')][_0x33c6('0xa8')]]);return _0x298e15['status'](0xc8)['json']({'message':_0x33c6('0xb4'),'pid':_0x41b8cc['pid']});}catch(_0x222246){return _0x298e15[_0x33c6('0x10')](0x1f4)[_0x33c6('0xb5')](_0x222246);}};exports[_0x33c6('0xb6')]=function(_0x548a1a,_0x45c410){var _0x3819c8=fs[_0x33c6('0xb7')](_0x548a1a[_0x33c6('0xad')][_0x33c6('0x2')]);Papa[_0x33c6('0xb8')](_0x3819c8,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x14958a){return _0x45c410['status'](0xc8)[_0x33c6('0x17')]({'file':_0x548a1a[_0x33c6('0xad')],'fields':_0x14958a[_0x33c6('0xb9')][_0x33c6('0x82')]});}});};exports['import']=function(_0x7fa710,_0x2b15d1){return db[_0x33c6('0xba')][_0x33c6('0x21')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0x33c6('0x19')](function(_0x26803e){var _0x3631a6=![];if(!_0x7fa710[_0x33c6('0x39')]['ListId']){throw new Error(_0x33c6('0xa3'));}if(!_0x7fa710[_0x33c6('0x39')]['binding'][_0x33c6('0x7b')]){throw new Error(_0x33c6('0xaa'));}if(!_0x7fa710[_0x33c6('0x39')]['binding'][_0x33c6('0xab')]){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x7fa710[_0x33c6('0x39')][_0x33c6('0xa8')]){throw new Error(_0x33c6('0xbb'));}var _0x108b64=require(_0x33c6('0xb1'))[_0x33c6('0xb2')](path['join'](__dirname,_0x33c6('0xbc')),[_0x7fa710[_0x33c6('0x27')]['id'],JSON[_0x33c6('0xbd')](_0x7fa710[_0x33c6('0x39')]),JSON['stringify'](_0x26803e)]);_0x108b64['on']('message',function(){_0x3631a6=!![];return _0x2b15d1[_0x33c6('0x10')](0xc8)['json']({'message':_0x33c6('0xbe'),'pid':_0x108b64[_0x33c6('0xbf')]});});_0x108b64['on']('exit',function(_0x3c673b){if(_0x3c673b&&!_0x3631a6){return _0x2b15d1[_0x33c6('0x10')](0x1f4)['json']({'message':_0x33c6('0xc0'),'pid':_0x108b64[_0x33c6('0xbf')]});}});})['catch'](handleError(_0x2b15d1,null));};exports['importUpdates']=function(_0xd3d647,_0x8a70a4){return db[_0x33c6('0xba')][_0x33c6('0x21')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0x33c6('0x19')](function(_0x59e4a1){var _0x1d34f7=![];if(!_0xd3d647[_0x33c6('0x39')][_0x33c6('0x62')]){throw new Error(_0x33c6('0xa3'));}if(!_0xd3d647[_0x33c6('0x39')][_0x33c6('0xc1')][_0x33c6('0x7b')]){throw new Error(_0x33c6('0xaa'));}if(!_0xd3d647[_0x33c6('0x39')][_0x33c6('0xc1')][_0x33c6('0xab')]){throw new Error(_0x33c6('0xc2'));}if(!_0xd3d647['body']['socket_timestamp']){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x1b3618=require(_0x33c6('0xb1'))[_0x33c6('0xb2')](path[_0x33c6('0x57')](__dirname,_0x33c6('0xc3')),[_0xd3d647['params']['id'],JSON[_0x33c6('0xbd')](_0xd3d647[_0x33c6('0x39')]),JSON[_0x33c6('0xbd')](_0x59e4a1)]);_0x1b3618['on']('message',function(){_0x1d34f7=!![];return _0x8a70a4[_0x33c6('0x10')](0xc8)[_0x33c6('0x17')]({'message':_0x33c6('0xbe'),'pid':_0x1b3618[_0x33c6('0xbf')]});});_0x1b3618['on'](_0x33c6('0xc4'),function(_0x321254){if(_0x321254&&!_0x1d34f7){return _0x8a70a4[_0x33c6('0x10')](0x1f4)[_0x33c6('0x17')]({'message':_0x33c6('0xc0'),'pid':_0x1b3618[_0x33c6('0xbf')]});}});})['catch'](handleError(_0x8a70a4,null));};exports[_0x33c6('0xc5')]=function(_0x53fecc,_0x2b27cf){var _0x266392=['mail','chat',_0x33c6('0xc6'),_0x33c6('0xc7'),_0x33c6('0xc8'),_0x33c6('0xc9'),_0x33c6('0xca')];var _0x3f6579={'offset':0x0,'order':qs['sort'](_0x33c6('0xcb'))},_0x564abc={'count':0x0,'rows':[]};Promise[_0x33c6('0xcc')]()[_0x33c6('0x19')](function(){if(_0x53fecc[_0x33c6('0x2d')][_0x33c6('0xcd')]){if(!_[_0x33c6('0xce')](_0x266392,_0x53fecc[_0x33c6('0x2d')][_0x33c6('0xcd')][_0x33c6('0xcf')]())){throw new Error(_0x33c6('0xd0'));}_0x266392=[_0x53fecc['query'][_0x33c6('0xcd')][_0x33c6('0xcf')]()];}if(_0x53fecc[_0x33c6('0x2d')][_0x33c6('0xd1')]){try{var _0x4275db=JSON[_0x33c6('0xb8')](_0x53fecc[_0x33c6('0x2d')][_0x33c6('0xd1')]);if(!moment(_0x4275db[_0x33c6('0x40')])['isValid']()){throw new Error(_0x33c6('0xd2'));}if(!moment(_0x4275db['to'])[_0x33c6('0xd3')]()){throw new Error('Invalid\x20date\x20for\x20range\x20to\x20filter');}}catch(_0x5b3d3b){throw new Error(_0x33c6('0xd4'));}}if(!_0x53fecc[_0x33c6('0x2d')]['hasOwnProperty']('nolimit')){_0x3f6579[_0x33c6('0x13')]=qs[_0x33c6('0x13')](_0x53fecc[_0x33c6('0x2d')]['limit']||0xa);_0x3f6579[_0x33c6('0x11')]=qs['offset'](_0x53fecc[_0x33c6('0x2d')]['offset']);}var _0x179cd6=_0x266392[_0x33c6('0x73')](function(_0xd3dfef){if(_0xd3dfef===_0x33c6('0xca')){var _0xe29d4b={'attributes':['id','uniqueid','type',_0x33c6('0xd5'),'destination',_0x33c6('0xd6'),_0x33c6('0xd7'),'endtime',_0x33c6('0xd8'),_0x33c6('0xd9'),_0x33c6('0xda'),_0x33c6('0xdb'),_0x33c6('0xdc'),_0x33c6('0xdd'),_0x33c6('0xde')],'where':{'ContactId':_0x53fecc['params']['id']},'include':[{'model':db['User'],'as':_0x33c6('0xba'),'attributes':['id',_0x33c6('0x1d'),_0x33c6('0xdf'),_0x33c6('0x31')]}],'order':[[_0x33c6('0xda'),'DESC']]};if(_0x53fecc[_0x33c6('0x2d')][_0x33c6('0xd1')]){_0xe29d4b[_0x33c6('0x61')][_0x33c6('0xda')]={'$gte':_0x4275db[_0x33c6('0x40')],'$lte':_0x4275db['to']};}return db[_0x33c6('0x50')][_0x33c6('0xe0')](_0xe29d4b)[_0x33c6('0x19')](function(_0x363025){_0x564abc[_0x33c6('0x14')]+=_0x363025[_0x33c6('0x14')];return _[_0x33c6('0x73')](_0x363025[_0x33c6('0xa0')],function(_0x1d1621){var _0x4b4265=_0x1d1621[_0x33c6('0x3b')]({'plain':!![]});_0x4b4265[_0x33c6('0xcd')]=_0xd3dfef;if(_0x4b4265['User']){_0x4b4265[_0x33c6('0xba')]={'id':_0x4b4265[_0x33c6('0xba')]['id'],'name':_0x4b4265[_0x33c6('0xba')]['name'],'fullname':_0x4b4265[_0x33c6('0xba')][_0x33c6('0xdf')],'alias':_0x4b4265[_0x33c6('0xba')]['alias']};}return _0x4b4265;});});}else{var _0x2511a2=_['startCase'](_0xd3dfef)+(_0xd3dfef===_0x33c6('0xe1')?_0x33c6('0xe2'):_0x33c6('0xe3'));var _0x5e71d6={'attributes':['id',_0x33c6('0xe4'),_0x33c6('0xe5'),_0x33c6('0xda'),'note','disposition','secondDisposition',_0x33c6('0xe6'),_0x33c6('0xde'),_0x2511a2+'Id'],'where':{'ContactId':_0x53fecc[_0x33c6('0x27')]['id']},'include':[{'model':db[_0x2511a2],'as':_0x33c6('0xe3'),'attributes':['id',_0x33c6('0x1d'),_0x33c6('0xe7')]},{'model':db[_0x33c6('0xba')],'as':'Owner','attributes':['id',_0x33c6('0x1d'),'fullname']},{'model':db[_0x33c6('0x67')],'as':_0x33c6('0xe8'),'attributes':['id',_0x33c6('0x1d'),_0x33c6('0x68')],'through':{'attributes':[]}}],'order':[[_0x33c6('0xda'),_0x33c6('0xe9')]]};if(_0x53fecc[_0x33c6('0x2d')][_0x33c6('0xd1')]){_0x5e71d6['where']['createdAt']={'$gte':_0x4275db['from'],'$lte':_0x4275db['to']};}switch(_0xd3dfef){case _0x33c6('0xe1'):_0x5e71d6[_0x33c6('0x83')]['push'](_0x33c6('0xea'),_0x33c6('0xeb'),_0x33c6('0xec'),_0x33c6('0xed'),_0x33c6('0xee'),_0x33c6('0xef'),_0x33c6('0xf0'),_0x33c6('0xf1'),_0x33c6('0xf2'));break;case _0x33c6('0xf3'):_0x5e71d6[_0x33c6('0x83')][_0x33c6('0x60')]('subject','substatus');break;case _0x33c6('0xc7'):_0x5e71d6['attributes'][_0x33c6('0x60')](_0x33c6('0xf4'),_0x33c6('0xf5'));break;}return db[_[_0x33c6('0xf6')](_0xd3dfef)+_0x33c6('0xf7')]['findAndCountAll'](_0x5e71d6)[_0x33c6('0x19')](function(_0x109c65){_0x564abc[_0x33c6('0x14')]+=_0x109c65[_0x33c6('0x14')];return _[_0x33c6('0x73')](_0x109c65[_0x33c6('0xa0')],function(_0x51991e){var _0x5712a4=_0x51991e[_0x33c6('0x3b')]({'plain':!![]});_0x5712a4[_0x33c6('0xcd')]=_0xd3dfef;if(_0x5712a4[_0x33c6('0xf8')]){_0x5712a4[_0x33c6('0xf8')]={'id':_0x5712a4[_0x33c6('0xf8')]['id'],'name':_0x5712a4[_0x33c6('0xf8')]['name'],'fullname':_0x5712a4[_0x33c6('0xf8')][_0x33c6('0xdf')]};}return _0x5712a4;});});}});return Promise['all'](_0x179cd6);})['then'](function(_0x4bea51){return _(_0x4bea51)[_0x33c6('0xf9')]()[_0x33c6('0xfa')](_0x33c6('0xda'))[_0x33c6('0xfb')]()['value']();})[_0x33c6('0x19')](function(_0x1f97c2){_0x564abc[_0x33c6('0xa0')]=_0x3f6579[_0x33c6('0x13')]?_0x1f97c2[_0x33c6('0xfc')](_0x3f6579['offset'],_0x3f6579[_0x33c6('0x11')]+_0x3f6579[_0x33c6('0x13')]):_0x1f97c2;return _0x564abc;})[_0x33c6('0x19')](respondWithFilteredResult(_0x2b27cf,_0x3f6579))[_0x33c6('0x23')](handleError(_0x2b27cf,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff