// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xbf3e=['get','isArray','tags','[CmContact][merge]\x20to\x20%s\x20from\x20%s','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','OpenchannelMessage','CmContactHasItem','CmHopperFinal','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','OpenchannelQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappMessage','isNil','dialTimezone','timezones','utcOffset','additionalPhones','each','duplicates','where','$or','push','ListId','spread','contact','all','show','Tags','tag','ContactItemType','ItemType','sequelize','literal','Phones.OrderBy','$and','omit','format','cf_%d','pickBy','isEmpty','cm_contacts','id\x20=\x20?','toParam','text','phone','getTags','findOne','Tag','filters','model','attributes','intersection','fields','order','sort','pick','filter','map','hasOwnProperty','ids','OrderBy','items','item_types','ItemTypeId','description','contact\x20phone\x20exists','CmHopper','item','PHONE','CmHopperId','CmHopperAdditionalPhone','getAdditionalPhones','duplicateAdditionalPhones','CmContactId','toContactId','bulkCreate','rescheduleAdditionalPhones','hopperId','rawAttributes','nolimit','ContactId','options','include','rows','CmHopperHistory','getHopperFinals','includeAll','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','socket_timestamp','Incorrect\x20binding\x20parameters\x20passed!','zipObject','firstName','No\x20firstName\x20column\x20specified','join','root','server/files/tmp','file','chmodSync','0777','child_process','fork','CompanyId','File\x20uploaded\x20correctly!','pid','upload','createReadStream','parse','meta','import','User','agent','binding','stringify','message','start\x20child\x20process\x20correctly!','exit','error\x20child\x20process','importUpdates','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','../../components/import/cm/csvUpdates','mail','chat','fax','whatsapp','voice','resolve','includes','channel','toLowerCase','Invalid\x20channel','range','isValid','Invalid\x20date\x20for\x20range\x20from\x20filter','Invalid\x20date\x20for\x20range\x20to\x20filter','Invalid\x20createdAt\x20filter','destination','callerid','starttime','endtime','duration','note','createdAt','userDisposition','userSecondDisposition','fullname','DESC','startCase','Account','closed','closedAt','disposition','secondDisposition','UserId','key','browserName','customerIp','customerPort','deviceModel','osName','ratingMessage','ratingValue','referer','subject','substatus','openchannel','externalUrl','threadId','Owner','flatten','sortBy','reverse','value','slice','moment','util','path','lodash','squel','papaparse','ioredis','../../components/contacts','../../config/environment','../../mysqldb','redis','localhost','socket.io-emitter','./cmContact.socket','status','json','offset','undefined','count','limit','set','Content-Range','update','then','destroy','end','error','stack','name','send','describe','findAll','user','catch','CmContact','find','params','keys','startsWith','cf_','query','CmCustomField','length','columnName','displayName','alias','custom','type','values','info','Custom\x20field\x20%s\x20not\x20found\x20on\x20cm_contacts\x20table','forEach','merge','body','from'];(function(_0x57207d,_0x1edb04){var _0x35166a=function(_0x57067a){while(--_0x57067a){_0x57207d['push'](_0x57207d['shift']());}};_0x35166a(++_0x1edb04);}(_0xbf3e,0xc0));var _0xebf3=function(_0x1bd1c3,_0x1ed2d9){_0x1bd1c3=_0x1bd1c3-0x0;var _0x5a1e76=_0xbf3e[_0x1bd1c3];return _0x5a1e76;};'use strict';var moment=require(_0xebf3('0x0'));var BPromise=require('bluebird');var util=require(_0xebf3('0x1'));var path=require(_0xebf3('0x2'));var fs=require('fs');var _=require(_0xebf3('0x3'));var squel=require(_0xebf3('0x4'));var Papa=require(_0xebf3('0x5'));var Redis=require(_0xebf3('0x6'));var contacts=require(_0xebf3('0x7'));var qs=require('../../components/parsers/qs');var logger=require('../../config/logger')('api');var config=require(_0xebf3('0x8'));var shared=require('../../config/environment/shared');var db=require(_0xebf3('0x9'))['db'];config['redis']=_['defaults'](config[_0xebf3('0xa')],{'host':_0xebf3('0xb'),'port':0x18eb});var socket=require(_0xebf3('0xc'))(new Redis(config[_0xebf3('0xa')]));require(_0xebf3('0xd'))['register'](socket);function respondWithResult(_0x476b21,_0x24348f){_0x24348f=_0x24348f||0xc8;return function(_0x3578e1){if(_0x3578e1){return _0x476b21[_0xebf3('0xe')](_0x24348f)[_0xebf3('0xf')](_0x3578e1);}};}function respondWithFilteredResult(_0x2c0d1f,_0x12da59){return function(_0x2c7b9e){if(_0x2c7b9e){var _0x300e30=typeof _0x12da59[_0xebf3('0x10')]===_0xebf3('0x11')&&typeof _0x12da59['limit']===_0xebf3('0x11');var _0x420daf=_0x2c7b9e['count'];var _0x26e2a2=_0x300e30?0x0:_0x12da59[_0xebf3('0x10')];var _0xe2f0db=_0x300e30?_0x2c7b9e[_0xebf3('0x12')]:_0x12da59[_0xebf3('0x10')]+_0x12da59[_0xebf3('0x13')];var _0x2a64c2;if(_0xe2f0db>=_0x420daf){_0xe2f0db=_0x420daf;_0x2a64c2=0xc8;}else{_0x2a64c2=0xce;}_0x2c0d1f[_0xebf3('0xe')](_0x2a64c2);return _0x2c0d1f[_0xebf3('0x14')](_0xebf3('0x15'),_0x26e2a2+'-'+_0xe2f0db+'/'+_0x420daf)[_0xebf3('0xf')](_0x2c7b9e);}return null;};}function saveUpdates(_0xbb562a){return function(_0x3c4d83){if(_0x3c4d83){return _0x3c4d83[_0xebf3('0x16')](_0xbb562a)[_0xebf3('0x17')](function(_0x154799){return _0x154799;});}return null;};}function removeEntity(_0x3fa349){return function(_0x2140ce){if(_0x2140ce){return _0x2140ce[_0xebf3('0x18')]()[_0xebf3('0x17')](function(){_0x3fa349[_0xebf3('0xe')](0xcc)[_0xebf3('0x19')]();});}};}function handleEntityNotFound(_0x2c2db9){return function(_0x3e57fe){if(!_0x3e57fe){_0x2c2db9['sendStatus'](0x194);}return _0x3e57fe;};}function handleError(_0x1c9622,_0x29e7fb){_0x29e7fb=_0x29e7fb||0x1f4;return function(_0x2e1dfa){logger[_0xebf3('0x1a')](_0x2e1dfa[_0xebf3('0x1b')]);if(_0x2e1dfa[_0xebf3('0x1c')]){delete _0x2e1dfa[_0xebf3('0x1c')];}_0x1c9622[_0xebf3('0xe')](_0x29e7fb)[_0xebf3('0x1d')](_0x2e1dfa);};}exports['index']=function(_0x391861,_0x2d43cf){var _0x2c9dc9={};return contacts[_0xebf3('0x1e')]()[_0xebf3('0x17')](function(_0x2d4bf3){_0x2c9dc9=qs['getOptions'](_0x2d4bf3,_0x391861);return contacts[_0xebf3('0x1f')](_0x391861['query'],_0x391861[_0xebf3('0x20')],_0x2c9dc9,_0x2d4bf3);})['then'](respondWithFilteredResult(_0x2d43cf,_0x2c9dc9))[_0xebf3('0x21')](handleError(_0x2d43cf,null));};exports[_0xebf3('0x18')]=function(_0x333671,_0x253276){return db[_0xebf3('0x22')][_0xebf3('0x23')]({'where':{'id':_0x333671[_0xebf3('0x24')]['id']}})[_0xebf3('0x17')](handleEntityNotFound(_0x253276,null))[_0xebf3('0x17')](removeEntity(_0x253276,null))[_0xebf3('0x21')](handleError(_0x253276,null));};exports['describe']=function(_0x31592d,_0x2c72cc){return db[_0xebf3('0x22')][_0xebf3('0x1e')]()[_0xebf3('0x17')](function(_0x1d607d){delete _0x1d607d['tags'];for(var _0x4c2e52=0x0;_0x4c2e52<Object[_0xebf3('0x25')](_0x1d607d)['length'];_0x4c2e52++){var _0x3251ba=Object['keys'](_0x1d607d)[_0x4c2e52];if(!_[_0xebf3('0x26')](_0x3251ba,_0xebf3('0x27'))){_0x1d607d[_0x3251ba]['columnName']=_0x3251ba;_0x1d607d[_0x3251ba]['displayName']=_0x3251ba;}}return _0x1d607d;})[_0xebf3('0x17')](function(_0x34943d){var _0x2484c6={'where':Boolean(_0x31592d[_0xebf3('0x28')]['analytics'])===!![]?undefined:{'$or':[{'ListId':_0x31592d['query']['id']},{'ListId':null}]},'raw':!![]};return db[_0xebf3('0x29')][_0xebf3('0x1f')](_0x2484c6)['then'](function(_0x1ab88f){for(var _0x1da4a6=0x0;_0x1da4a6<_0x1ab88f[_0xebf3('0x2a')];_0x1da4a6++){var _0x23df4e=_0xebf3('0x27')+_0x1ab88f[_0x1da4a6]['id'];if(_0x34943d[_0x23df4e]){_0x34943d[_0x23df4e][_0xebf3('0x2b')]=_0x23df4e;_0x34943d[_0x23df4e][_0xebf3('0x2c')]=_0x1ab88f[_0x1da4a6][_0xebf3('0x2d')];_0x34943d[_0x23df4e][_0xebf3('0x2e')]={'type':_0x1ab88f[_0x1da4a6][_0xebf3('0x2f')],'values':_0x1ab88f[_0x1da4a6][_0xebf3('0x30')]};}else{logger[_0xebf3('0x31')](_0xebf3('0x32'),_0x23df4e);}}Object[_0xebf3('0x25')](_0x34943d)[_0xebf3('0x33')](function(_0x13af5f){if(!_0x34943d[_0x13af5f]['hasOwnProperty'](_0xebf3('0x2b'))){delete _0x34943d[_0x13af5f];}});return _0x34943d;});})[_0xebf3('0x17')](respondWithResult(_0x2c72cc,null))[_0xebf3('0x21')](handleError(_0x2c72cc,null));};exports[_0xebf3('0x34')]=function(_0x55b812,_0x434c5f){var _0x134b06;var _0x2b58b1;var _0x37ec69;if(_0x55b812[_0xebf3('0x35')]['id']){delete _0x55b812['body']['id'];}return db[_0xebf3('0x22')][_0xebf3('0x1f')]({'where':{'id':[_0x55b812['body']['to'],_0x55b812[_0xebf3('0x35')][_0xebf3('0x36')]]}})[_0xebf3('0x17')](function(_0x5b01dd){if(_0x5b01dd){if(_0x5b01dd[_0xebf3('0x2a')]!==0x2){return null;}_0x5b01dd[0x0]=_0x5b01dd[0x0]['get']({'plain':!![]});_0x5b01dd[0x1]=_0x5b01dd[0x1][_0xebf3('0x37')]({'plain':!![]});delete _0x5b01dd[0x0]['id'];delete _0x5b01dd[0x1]['id'];return _['mergeWith'](_0x5b01dd[0x0],_0x5b01dd[0x1],function(_0xc138d5,_0x3a1488){if(Array[_0xebf3('0x38')](_0x3a1488)&&!_0x3a1488[_0xebf3('0x2a')]){return _0xc138d5;}else if(!_0x3a1488){return _0xc138d5;}});}})[_0xebf3('0x17')](handleEntityNotFound(_0x434c5f,null))[_0xebf3('0x17')](function(_0x271f17){if(_0x271f17){if(_0x271f17['tags']&&_['isArray'](_0x271f17['tags'])){_0x271f17[_0xebf3('0x39')]=_0x271f17[_0xebf3('0x39')]['join']();}logger[_0xebf3('0x31')](_0xebf3('0x3a'),_0x55b812[_0xebf3('0x35')]['to'],_0x55b812[_0xebf3('0x35')]['from']);return db['CmHopper']['destroy']({'where':{'ContactId':[_0x55b812[_0xebf3('0x35')]['to'],_0x55b812[_0xebf3('0x35')]['from']]}})[_0xebf3('0x17')](function(_0x166c94){logger['info'](_0xebf3('0x3b'),_0x166c94);return db[_0xebf3('0x3c')][_0xebf3('0x18')]({'where':{'ContactId':[_0x55b812['body']['to'],_0x55b812[_0xebf3('0x35')][_0xebf3('0x36')]]}})[_0xebf3('0x17')](function(_0x5ee1a7){logger['info'](_0xebf3('0x3d'),_0x5ee1a7);return db[_0xebf3('0x22')][_0xebf3('0x3e')](_0x271f17);});});}})[_0xebf3('0x17')](function(_0x213abd){if(_0x213abd){_0x134b06=_0x213abd;_0x2b58b1={'ContactId':_0x134b06['id']};_0x37ec69={'where':{'ContactId':[_0x55b812[_0xebf3('0x35')]['to'],_0x55b812[_0xebf3('0x35')][_0xebf3('0x36')]]}};return db[_0xebf3('0x3f')][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})[_0xebf3('0x17')](function(){if(_0x134b06){return db[_0xebf3('0x40')][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})[_0xebf3('0x17')](function(){if(_0x134b06){return db[_0xebf3('0x41')][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})['then'](function(){if(_0x134b06){return db[_0xebf3('0x42')][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})[_0xebf3('0x17')](function(){if(_0x134b06){return db[_0xebf3('0x43')][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})[_0xebf3('0x17')](function(){if(_0x134b06){return db[_0xebf3('0x42')][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})[_0xebf3('0x17')](function(){if(_0x134b06){return db[_0xebf3('0x43')][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})['then'](function(){if(_0x134b06){return db[_0xebf3('0x44')][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})[_0xebf3('0x17')](function(){if(_0x134b06){return db[_0xebf3('0x45')][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})[_0xebf3('0x17')](function(){if(_0x134b06){return db['FaxInteraction'][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})[_0xebf3('0x17')](function(){if(_0x134b06){return db['FaxMessage'][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})[_0xebf3('0x17')](function(){if(_0x134b06){return db['OpenchannelInteraction'][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})[_0xebf3('0x17')](function(){if(_0x134b06){return db[_0xebf3('0x46')][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})['then'](function(){if(_0x134b06){return db[_0xebf3('0x47')][_0xebf3('0x16')]({'CmContactId':_0x134b06['id']},{'where':{'CmContactId':[_0x55b812[_0xebf3('0x35')]['to'],_0x55b812[_0xebf3('0x35')][_0xebf3('0x36')]]}});}})[_0xebf3('0x17')](function(){if(_0x134b06){return db[_0xebf3('0x48')]['update'](_0x2b58b1,_0x37ec69);}})[_0xebf3('0x17')](function(){if(_0x134b06){return db['CmHopperHistory'][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})[_0xebf3('0x17')](function(){if(_0x134b06){return db[_0xebf3('0x49')]['update'](_0x2b58b1,_0x37ec69);}})[_0xebf3('0x17')](function(){if(_0x134b06){return db[_0xebf3('0x4a')][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})[_0xebf3('0x17')](function(){if(_0x134b06){return db[_0xebf3('0x4b')][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})[_0xebf3('0x17')](function(){if(_0x134b06){return db[_0xebf3('0x4c')][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})[_0xebf3('0x17')](function(){if(_0x134b06){return db['MailQueueReport'][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})['then'](function(){if(_0x134b06){return db[_0xebf3('0x4d')][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})['then'](function(){if(_0x134b06){return db['SmsQueueReport'][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})[_0xebf3('0x17')](function(){if(_0x134b06){return db[_0xebf3('0x4e')][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})[_0xebf3('0x17')](function(){if(_0x134b06){return db[_0xebf3('0x4f')][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})['then'](function(){if(_0x134b06){return db[_0xebf3('0x50')][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})[_0xebf3('0x17')](function(){if(_0x134b06){return db['WhatsappQueueReport'][_0xebf3('0x16')](_0x2b58b1,_0x37ec69);}})[_0xebf3('0x17')](function(){if(_0x134b06){return db['CmContact'][_0xebf3('0x18')]({'where':{'id':[_0x55b812[_0xebf3('0x35')]['to'],_0x55b812['body'][_0xebf3('0x36')]]}});}})['then'](function(){if(_0x134b06){return _0x134b06;}})['then'](respondWithResult(_0x434c5f,null))[_0xebf3('0x21')](handleError(_0x434c5f,null));};exports[_0xebf3('0x3e')]=function(_0x3b9ae1,_0xb516ba){return db[_0xebf3('0x22')]['describe']()['then'](function(_0x34aa4b){if(_0x3b9ae1[_0xebf3('0x35')]['tags']&&_['isArray'](_0x3b9ae1['body']['tags'])){if(_0x3b9ae1['body'][_0xebf3('0x39')]['length']){_0x3b9ae1[_0xebf3('0x35')][_0xebf3('0x39')]=_0x3b9ae1[_0xebf3('0x35')][_0xebf3('0x39')]['join'](';')+';';}else{_0x3b9ae1[_0xebf3('0x35')][_0xebf3('0x39')]=null;}}else{_0x3b9ae1[_0xebf3('0x35')][_0xebf3('0x39')]=null;}if(!_[_0xebf3('0x51')](_0x3b9ae1[_0xebf3('0x35')]['dialTimezone'])){var _0x50ebfd=_0x3b9ae1[_0xebf3('0x35')][_0xebf3('0x52')];if(!_[_0xebf3('0x51')](shared['timezones'][_0x50ebfd]))_0x3b9ae1[_0xebf3('0x35')]['utcOffset']=shared[_0xebf3('0x53')][_0x50ebfd][_0xebf3('0x54')];}return db[_0xebf3('0x22')]['create'](_0x3b9ae1[_0xebf3('0x35')],{'fields':_[_0xebf3('0x25')](_0x34aa4b),'raw':!![]});})[_0xebf3('0x17')](function(_0x42698a){if(_0x3b9ae1['body'][_0xebf3('0x55')]){return insertAdditionalPhones(_0x42698a,_0x3b9ae1[_0xebf3('0x35')]['additionalPhones']);}else{return _0x42698a;}})[_0xebf3('0x17')](respondWithResult(_0xb516ba,0xc9))[_0xebf3('0x21')](handleError(_0xb516ba,null));};exports['bulkCreate']=function(_0x38ace9,_0x1bf9c8){var _0x9bc837=0x0;var _0x482460=0x0;var _0x2e3718=0x0;var _0x11f7ca=[];return db[_0xebf3('0x22')][_0xebf3('0x1e')]()[_0xebf3('0x17')](function(_0x5afdbc){return BPromise[_0xebf3('0x56')](_0x38ace9[_0xebf3('0x35')],function(_0x2dbbe5){var _0x4e03fa={'where':{'$or':[]},'defaults':_0x2dbbe5,'fields':_[_0xebf3('0x25')](_0x5afdbc),'raw':!![]};if(_0x2dbbe5['duplicates']){for(var _0xfe5566=0x0;_0xfe5566<_0x2dbbe5[_0xebf3('0x57')][_0xebf3('0x2a')];_0xfe5566++){var _0x241477={};_0x241477[_0x2dbbe5[_0xebf3('0x57')][_0xfe5566]]=_0x2dbbe5[_0x2dbbe5[_0xebf3('0x57')][_0xfe5566]];_0x4e03fa[_0xebf3('0x58')][_0xebf3('0x59')][_0xebf3('0x5a')](_0x241477);}_0x4e03fa[_0xebf3('0x58')]['ListId']=_0x2dbbe5[_0xebf3('0x5b')];}return db[_0xebf3('0x22')]['findOrCreate'](_0x4e03fa)[_0xebf3('0x5c')](function(_0x490f62,_0x1b6254){if(_0x1b6254){if(_0x2dbbe5['hasOwnProperty']('additionalPhones')){_0x11f7ca[_0xebf3('0x5a')]({'contact':_0x490f62,'additionalPhones':_0x2dbbe5[_0xebf3('0x55')]});}_0x9bc837++;}else{_0x2e3718++;}})[_0xebf3('0x21')](function(){_0x482460++;});});})['then'](function(_0x2ef71e){if(_0x2ef71e){if(_0x11f7ca['length']>0x0){return new Promise(function(_0x234073){var _0x5d0656=[];for(var _0x255466=0x0;_0x255466<_0x11f7ca[_0xebf3('0x2a')];_0x255466++){_0x5d0656['push'](insertAdditionalPhones(_0x11f7ca[_0x255466][_0xebf3('0x5d')],_0x11f7ca[_0x255466]['additionalPhones']));}Promise[_0xebf3('0x5e')](_0x5d0656)[_0xebf3('0x17')](function(){_0x234073(0x1);});})[_0xebf3('0x17')](function(){return{'success':_0x9bc837,'failure':_0x482460,'duplicates':_0x2e3718};});}else{return{'success':_0x9bc837,'failure':_0x482460,'duplicates':_0x2e3718};}}})[_0xebf3('0x17')](respondWithResult(_0x1bf9c8,0xc9))[_0xebf3('0x21')](handleError(_0x1bf9c8,null));};exports[_0xebf3('0x5f')]=function(_0x24bbbc,_0x4c66aa){var _0x47f210;return db[_0xebf3('0x22')][_0xebf3('0x1e')]()['then'](function(_0x3349c9){return db[_0xebf3('0x22')][_0xebf3('0x23')]({'where':{'id':_0x24bbbc[_0xebf3('0x24')]['id']},'include':[{'model':db['Tag'],'as':_0xebf3('0x60'),'attributes':['id',_0xebf3('0x1c'),'color'],'required':_0x24bbbc[_0xebf3('0x28')][_0xebf3('0x61')]?!![]:![]},{'model':db['CmContactHasItem'],'as':'Phones','where':{'CmContactId':_0x24bbbc[_0xebf3('0x24')]['id']},'required':![],'include':[{'model':db[_0xebf3('0x62')],'as':_0xebf3('0x63')}]}],'order':[db[_0xebf3('0x64')][_0xebf3('0x65')](_0xebf3('0x66'))],'attributes':_['keys'](_0x3349c9)});})[_0xebf3('0x17')](function(_0x34f7d6){if(!_['isNil'](_0x34f7d6)){_0x47f210=_0x34f7d6['get']({'plain':!![]});var _0x4bba2a={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x34f7d6&&_0x34f7d6[_0xebf3('0x5b')]){if(_0x34f7d6[_0xebf3('0x5b')]){_0x4bba2a[_0xebf3('0x58')][_0xebf3('0x67')][_0xebf3('0x5a')]({'ListId':{'$ne':_0x34f7d6[_0xebf3('0x5b')]}});}}return db[_0xebf3('0x29')][_0xebf3('0x1f')](_0x4bba2a);}})[_0xebf3('0x17')](function(_0x18b2b7){if(!_[_0xebf3('0x51')](_0x18b2b7)){return _[_0xebf3('0x68')](_0x47f210,_['map'](_0x18b2b7,function(_0x162dac){return util[_0xebf3('0x69')](_0xebf3('0x6a'),_0x162dac['id']);}));}})['then'](handleEntityNotFound(_0x4c66aa,null))[_0xebf3('0x17')](respondWithResult(_0x4c66aa,null))[_0xebf3('0x21')](handleError(_0x4c66aa,null));};exports[_0xebf3('0x16')]=function(_0x10f860,_0x5145bb){var _0x1d6b10;if(_0x10f860['body']['id']){delete _0x10f860['body']['id'];}if(!_[_0xebf3('0x51')](_0x10f860[_0xebf3('0x35')][_0xebf3('0x52')])){var _0x28db14=_0x10f860['body'][_0xebf3('0x52')];if(!_[_0xebf3('0x51')](shared[_0xebf3('0x53')][_0x28db14]))_0x10f860[_0xebf3('0x35')][_0xebf3('0x54')]=shared[_0xebf3('0x53')][_0x28db14]['utcOffset'];}return db[_0xebf3('0x22')][_0xebf3('0x23')]({'where':{'id':_0x10f860[_0xebf3('0x24')]['id']}})[_0xebf3('0x17')](handleEntityNotFound(_0x5145bb,null))[_0xebf3('0x17')](saveUpdates(_0x10f860[_0xebf3('0x35')],null))[_0xebf3('0x17')](function(_0x10b42f){_0x1d6b10=_0x10b42f;var _0x3693b0={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x10b42f&&_0x10b42f[_0xebf3('0x5b')]){if(_0x10b42f[_0xebf3('0x5b')]){_0x3693b0[_0xebf3('0x58')][_0xebf3('0x67')][_0xebf3('0x5a')]({'ListId':{'$ne':_0x10b42f['ListId']}});}}return db[_0xebf3('0x29')]['findAll'](_0x3693b0);})[_0xebf3('0x17')](function(_0xd26603){if(_0xd26603){return _['omit'](_[_0xebf3('0x6b')](_0x10f860['body'],function(_0x423417,_0x73f8bf){return _[_0xebf3('0x26')](_0x73f8bf,_0xebf3('0x27'));}),_['map'](_0xd26603,function(_0x1fc970){return util[_0xebf3('0x69')](_0xebf3('0x6a'),_0x1fc970['id']);}));}})['then'](function(_0x3cc70a){if(_0x3cc70a&&!_[_0xebf3('0x6c')](_0x3cc70a)){var _0x316625=squel[_0xebf3('0x16')]()['table'](_0xebf3('0x6d'))['setFields'](_0x3cc70a)['where'](_0xebf3('0x6e'),_0x10f860[_0xebf3('0x24')]['id'])[_0xebf3('0x6f')]();return db['sequelize']['query'](_0x316625[_0xebf3('0x70')],{'replacements':_0x316625['values']});}})['then'](function(){if(_0x10f860[_0xebf3('0x35')][_0xebf3('0x71')]&&_0x1d6b10){return db['CmHopper'][_0xebf3('0x16')]({'phone':_0x10f860[_0xebf3('0x35')][_0xebf3('0x71')],'OrderBy':0x0},{'where':{'ContactId':_0x1d6b10['id']}});}})[_0xebf3('0x17')](function(){return _0x1d6b10;})[_0xebf3('0x17')](respondWithResult(_0x5145bb,null))[_0xebf3('0x21')](handleError(_0x5145bb,null));};exports[_0xebf3('0x72')]=function(_0x11b5c0,_0x7e1dd2){var _0x4a971d={};var _0x3fabd6={};var _0x45f6c5;var _0x4b443e;return db[_0xebf3('0x22')][_0xebf3('0x73')]({'where':{'id':_0x11b5c0[_0xebf3('0x24')]['id']}})['then'](handleEntityNotFound(_0x7e1dd2,null))['then'](function(_0x50761c){if(_0x50761c){_0x45f6c5=_0x50761c;_0x3fabd6['model']=_[_0xebf3('0x25')](db[_0xebf3('0x74')]['rawAttributes']);_0x3fabd6[_0xebf3('0x28')]=_[_0xebf3('0x25')](_0x11b5c0[_0xebf3('0x28')]);_0x3fabd6[_0xebf3('0x75')]=_['intersection'](_0x3fabd6[_0xebf3('0x76')],_0x3fabd6['query']);_0x4a971d[_0xebf3('0x77')]=_[_0xebf3('0x78')](_0x3fabd6['model'],qs['fields'](_0x11b5c0[_0xebf3('0x28')][_0xebf3('0x79')]));_0x4a971d['attributes']=_0x4a971d['attributes'][_0xebf3('0x2a')]?_0x4a971d[_0xebf3('0x77')]:_0x3fabd6[_0xebf3('0x76')];_0x4a971d[_0xebf3('0x7a')]=qs[_0xebf3('0x7b')](_0x11b5c0[_0xebf3('0x28')][_0xebf3('0x7b')]);_0x4a971d[_0xebf3('0x58')]=qs[_0xebf3('0x75')](_[_0xebf3('0x7c')](_0x11b5c0['query'],_0x3fabd6[_0xebf3('0x75')]));if(_0x11b5c0['query'][_0xebf3('0x7d')]){_0x4a971d[_0xebf3('0x58')]=_[_0xebf3('0x34')](_0x4a971d['where'],{'$or':_[_0xebf3('0x7e')](_0x4a971d[_0xebf3('0x77')],function(_0x1ca5fa){var _0x39cb10={};_0x39cb10[_0x1ca5fa]={'$like':'%'+_0x11b5c0[_0xebf3('0x28')][_0xebf3('0x7d')]+'%'};return _0x39cb10;})});}_0x4a971d=_['merge']({},_0x4a971d,_0x11b5c0['options']);return _0x45f6c5[_0xebf3('0x72')](_0x4a971d);}})['then'](function(_0xfb3866){if(_0xfb3866){_0x4b443e=_0xfb3866['length'];if(!_0x11b5c0['query'][_0xebf3('0x7f')]('nolimit')){_0x4a971d[_0xebf3('0x13')]=qs['limit'](_0x11b5c0[_0xebf3('0x28')][_0xebf3('0x13')]);_0x4a971d['offset']=qs['offset'](_0x11b5c0[_0xebf3('0x28')][_0xebf3('0x10')]);}return _0x45f6c5[_0xebf3('0x72')](_0x4a971d);}})[_0xebf3('0x17')](function(_0x160e52){if(_0x160e52){return _0x160e52?{'count':_0x4b443e,'rows':_0x160e52}:null;}})[_0xebf3('0x17')](respondWithResult(_0x7e1dd2,null))[_0xebf3('0x21')](handleError(_0x7e1dd2,null));};exports['setTags']=function(_0x4ba4cb,_0x57e1bd){if(_0x4ba4cb[_0xebf3('0x35')]['id']){delete _0x4ba4cb['body']['id'];}return db[_0xebf3('0x22')]['findOne']({'where':{'id':_0x4ba4cb[_0xebf3('0x24')]['id']}})[_0xebf3('0x17')](handleEntityNotFound(_0x57e1bd,null))[_0xebf3('0x17')](function(_0x282f3f){if(_0x282f3f){return _0x282f3f['setTags'](_0x4ba4cb[_0xebf3('0x35')][_0xebf3('0x80')]||[]);}return null;})['then'](respondWithResult(_0x57e1bd,null))['catch'](handleError(_0x57e1bd,null));};exports['setAdditionalPhones']=function(_0x5be720,_0x3d5f27){var _0x160fdb=[];_0x160fdb[_0xebf3('0x5a')](addAdditionalPhones(_0x5be720[_0xebf3('0x35')]));Promise[_0xebf3('0x5e')](_0x160fdb)['then'](function(){_0x160fdb=[];_0x160fdb[_0xebf3('0x5a')](deleteCmHopperPhones(_0x5be720[_0xebf3('0x35')]['id']));_0x160fdb['push'](addCmHopperPhones(_0x5be720['body']['id']));Promise[_0xebf3('0x5e')](_0x160fdb)[_0xebf3('0x17')](function(){return[0x1];})['then'](respondWithResult(_0x3d5f27,null));});};function addAdditionalPhones(_0x41b366){var _0x3e04ab;return new Promise(function(_0x31321a){return db['CmContactHasItem']['destroy']({'where':{'CmContactId':_0x41b366['id']}})[_0xebf3('0x17')](function(){db['ContactItemType'][_0xebf3('0x1f')]({'raw':!![],'attributes':['id',_0xebf3('0x81')]})[_0xebf3('0x17')](function(_0x263a16){var _0x28ed2d=[];for(var _0x3052f8=0x0;_0x3052f8<_0x41b366[_0xebf3('0x82')][_0xebf3('0x2a')];_0x3052f8++){var _0x126d7d=_0x41b366[_0xebf3('0x83')]?_[_0xebf3('0x51')](_0x41b366[_0xebf3('0x83')][_0x3052f8])?'':_0x41b366['item_types'][_0x3052f8]:_0x41b366[_0xebf3('0x82')][_0x3052f8][_0xebf3('0x84')]?_0x41b366['items'][_0x3052f8][_0xebf3('0x84')]:'';var _0x4759ec=_[_0xebf3('0x51')](_0x41b366[_0xebf3('0x82')][_0x3052f8]['description'])?'':_0x41b366[_0xebf3('0x82')][_0x3052f8][_0xebf3('0x85')];var _0x8c6f04=_0x126d7d+':'+_0x41b366[_0xebf3('0x82')][_0x3052f8][_0xebf3('0x71')]+'§'+_0x4759ec;if(_['isNil'](_0x3e04ab))_0x3e04ab=_0x8c6f04;else _0x3e04ab+=';'+_0x8c6f04;var _0x4b1280=null;var _0x4f8b0b=null;if(_0x41b366[_0xebf3('0x83')]){if(!_['isNil'](_0x41b366[_0xebf3('0x83')][_0x3052f8])){_0x4f8b0b=_['find'](_0x263a16,function(_0xbe4eec){return _0xbe4eec['id']===_0x41b366[_0xebf3('0x83')][_0x3052f8];});if(!_[_0xebf3('0x51')](_0x4f8b0b)){_0x4b1280=_0x4f8b0b[_0xebf3('0x81')];}}}else{if(!_['isNil'](_0x41b366['items'][_0x3052f8])){_0x4f8b0b=_[_0xebf3('0x23')](_0x263a16,function(_0x508922){return _0x508922['id']===_0x41b366[_0xebf3('0x82')][_0x3052f8]['ItemTypeId'];});if(!_[_0xebf3('0x51')](_0x4f8b0b)){_0x4b1280=_0x3052f8;}}}if(_[_0xebf3('0x51')](_0x4b1280)){_0x4b1280=0x64;}_0x28ed2d[_0xebf3('0x5a')](addAdditionalPhone(_0x41b366['id'],_0x41b366[_0xebf3('0x82')][_0x3052f8][_0xebf3('0x71')],_0x41b366[_0xebf3('0x83')]?_[_0xebf3('0x51')](_0x41b366[_0xebf3('0x83')][_0x3052f8])?null:_0x41b366[_0xebf3('0x83')][_0x3052f8]:_0x41b366['items'][_0x3052f8]['ItemTypeId']?_0x41b366[_0xebf3('0x82')][_0x3052f8][_0xebf3('0x84')]:null,_0x4b1280,_0x4759ec));}Promise['all'](_0x28ed2d)[_0xebf3('0x17')](function(){db[_0xebf3('0x22')]['update']({'AdditionalPhones':_0x3e04ab},{'where':{'id':_0x41b366['id']}})[_0xebf3('0x17')](function(){_0x31321a(0x1);});});});});});}function addAdditionalPhone(_0x56fec0,_0x505b7e,_0x17a396,_0x2a2d78,_0x12d455){return db[_0xebf3('0x47')][_0xebf3('0x23')]({'where':{'CmContactId':_0x56fec0,'item':_0x505b7e}})['then'](function(_0x1d24d7){if(_0x1d24d7)logger[_0xebf3('0x31')](_0xebf3('0x86'),_0x1d24d7);else{db['CmContactHasItem'][_0xebf3('0x3e')]({'CmContactId':_0x56fec0,'item':_0x505b7e,'ItemTypeId':_0x17a396,'OrderBy':_0x2a2d78,'ItemClass':'PHONE','description':_0x12d455});}});}function deleteCmHopperPhones(_0x3a3095){return new Promise(function(_0x5213b1){return db[_0xebf3('0x87')][_0xebf3('0x1f')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x3a3095}})[_0xebf3('0x17')](function(_0x429c2f){db['CmHopperAdditionalPhone'][_0xebf3('0x18')]({'where':{'CmHopperId':{'$in':_[_0xebf3('0x7e')](_0x429c2f,'id')}}});})[_0xebf3('0x17')](function(){_0x5213b1(0x1);});});}function addCmHopperPhones(_0x2490ea){return new Promise(function(_0x389ce0){return db[_0xebf3('0x87')][_0xebf3('0x1f')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x2490ea}})[_0xebf3('0x17')](function(_0x44180f){var _0x1172dd=[];_[_0xebf3('0x7e')](_0x44180f,function(_0x2ac68d){_0x1172dd[_0xebf3('0x5a')](createCmHopperPhone(_0x2490ea,_0x2ac68d['id']));});Promise[_0xebf3('0x5e')](_0x1172dd)['then'](function(){_0x389ce0(0x1);});});});}function createCmHopperPhone(_0x1891da,_0x1d912a){return new Promise(function(_0x16991d){db['CmContactHasItem'][_0xebf3('0x1f')]({'raw':!![],'attributes':[_0xebf3('0x88'),'OrderBy'],'where':{'CmContactId':_0x1891da,'ItemClass':_0xebf3('0x89')},'include':[{'model':db[_0xebf3('0x62')],'attributes':[_0xebf3('0x81')],'as':'ItemType'}],'order':[_0xebf3('0x81'),db['sequelize'][_0xebf3('0x65')]('`ItemType`.OrderBy')]})[_0xebf3('0x17')](function(_0x3272de){var _0x5e0cb8=0x1;var _0x39955b=_[_0xebf3('0x7e')](_0x3272de,function(_0x4f296b){_0x4f296b[_0xebf3('0x8a')]=_0x1d912a;_0x4f296b[_0xebf3('0x71')]=_0x4f296b['item'];_0x4f296b['OrderBy']=_0x5e0cb8;delete _0x4f296b['ItemType.OrderBy'];_0x5e0cb8=_0x5e0cb8+0x1;return _0x4f296b;});return db[_0xebf3('0x8b')]['bulkCreate'](_0x39955b,{});})[_0xebf3('0x17')](function(){_0x16991d(0x1);});});}function insertAdditionalPhones(_0x2d51b5,_0xc12da6){return new Promise(function(_0x56e2bc){var _0x4c7458=[];for(var _0x42ce6c=0x0;_0x42ce6c<_0xc12da6[_0xebf3('0x2a')];_0x42ce6c++){var _0x5546d3=_0xc12da6[_0x42ce6c];_0x4c7458[_0xebf3('0x5a')](parseContactItemType(_0x5546d3));}Promise[_0xebf3('0x5e')](_0x4c7458)[_0xebf3('0x17')](function(){var _0x2e9c23={'id':_0x2d51b5['id'],'items':_0xc12da6};return addAdditionalPhones(_0x2e9c23)['then'](function(){return addCmHopperPhones(_0x2d51b5['id']);});})['then'](function(){_0x56e2bc(_0x2d51b5);});});}function parseContactItemType(_0x25f420){return new Promise(function(_0x4be31b){if(_0x25f420[_0xebf3('0x7f')](_0xebf3('0x84'))){_0x4be31b(_0x25f420);}else{return db['ContactItemType'][_0xebf3('0x23')]({'where':{'name':_0x25f420['ItemType']}})[_0xebf3('0x17')](function(_0x42ac1d){if(_[_0xebf3('0x51')](_0x42ac1d))_0x25f420['ItemTypeId']=null;else _0x25f420[_0xebf3('0x84')]=_0x42ac1d['id'];_0x4be31b(_0x25f420);});}});}exports[_0xebf3('0x8c')]=function(_0x489ba9,_0x1333a0){return db['CmContactHasItem']['findAll']({'raw':!![],'where':{'CmContactId':_0x489ba9[_0xebf3('0x24')]['id'],'ItemClass':_0xebf3('0x89')},'include':[{'model':db[_0xebf3('0x62')],'as':_0xebf3('0x63')}],'order':[[_0xebf3('0x81')],[db[_0xebf3('0x64')][_0xebf3('0x65')]('`ItemType`.OrderBy')]]})[_0xebf3('0x17')](function(_0xc9a1fe){return _0xc9a1fe;})[_0xebf3('0x17')](respondWithResult(_0x1333a0,null))[_0xebf3('0x21')](handleError(_0x1333a0,null));};exports[_0xebf3('0x8d')]=function(_0xdd79e4,_0x191873){return db[_0xebf3('0x47')]['findAll']({'raw':!![],'where':{'CmContactId':_0xdd79e4[_0xebf3('0x35')]['fromContactId']}})[_0xebf3('0x17')](function(_0x4cb69d){var _0x4b1a66=_['map'](_0x4cb69d,function(_0x1fe493){_0x1fe493[_0xebf3('0x8e')]=_0xdd79e4['body'][_0xebf3('0x8f')];return _0x1fe493;});return db[_0xebf3('0x47')][_0xebf3('0x90')](_0x4b1a66,{});})[_0xebf3('0x17')](function(){return addCmHopperPhones(_0xdd79e4[_0xebf3('0x35')][_0xebf3('0x8f')]);})[_0xebf3('0x17')](function(){return['ok'];})['then'](respondWithResult(_0x191873,null))[_0xebf3('0x21')](handleError(_0x191873,null));};exports[_0xebf3('0x91')]=function(_0x4906ff,_0x2ad800){var _0x1b53cb=[];_0x1b53cb['push'](createCmHopperPhone(_0x4906ff['body']['id'],_0x4906ff[_0xebf3('0x35')][_0xebf3('0x92')]));Promise[_0xebf3('0x5e')](_0x1b53cb)['then'](function(){return[0x1];})[_0xebf3('0x17')](respondWithResult(_0x2ad800,null));};exports['getHoppers']=function(_0x1093dc,_0x5a0b54){var _0x35c9ad={'raw':![],'where':{}};var _0x28af37={};var _0x23bc4d={'count':0x0,'rows':[]};return db['CmContact'][_0xebf3('0x73')]({'where':{'id':_0x1093dc['params']['id']}})['then'](handleEntityNotFound(_0x5a0b54,null))[_0xebf3('0x17')](function(_0x5a1da8){if(_0x5a1da8){_0x28af37[_0xebf3('0x76')]=_[_0xebf3('0x25')](db[_0xebf3('0x87')][_0xebf3('0x93')]);_0x28af37[_0xebf3('0x28')]=_['keys'](_0x1093dc[_0xebf3('0x28')]);_0x28af37[_0xebf3('0x75')]=_[_0xebf3('0x78')](_0x28af37[_0xebf3('0x76')],_0x28af37[_0xebf3('0x28')]);_0x35c9ad[_0xebf3('0x77')]=_[_0xebf3('0x78')](_0x28af37[_0xebf3('0x76')],qs[_0xebf3('0x79')](_0x1093dc[_0xebf3('0x28')][_0xebf3('0x79')]));_0x35c9ad['attributes']=_0x35c9ad[_0xebf3('0x77')][_0xebf3('0x2a')]?_0x35c9ad[_0xebf3('0x77')]:_0x28af37[_0xebf3('0x76')];if(!_0x1093dc[_0xebf3('0x28')][_0xebf3('0x7f')](_0xebf3('0x94'))){_0x35c9ad['limit']=qs['limit'](_0x1093dc[_0xebf3('0x28')][_0xebf3('0x13')]);_0x35c9ad[_0xebf3('0x10')]=qs['offset'](_0x1093dc[_0xebf3('0x28')][_0xebf3('0x10')]);}_0x35c9ad[_0xebf3('0x7a')]=qs[_0xebf3('0x7b')](_0x1093dc[_0xebf3('0x28')][_0xebf3('0x7b')]);_0x35c9ad[_0xebf3('0x58')]=qs[_0xebf3('0x75')](_[_0xebf3('0x7c')](_0x1093dc[_0xebf3('0x28')],_0x28af37[_0xebf3('0x75')]));_0x35c9ad[_0xebf3('0x58')][_0xebf3('0x95')]=_0x5a1da8['id'];if(_0x1093dc['query'][_0xebf3('0x7d')]){_0x35c9ad[_0xebf3('0x58')]=_[_0xebf3('0x34')](_0x35c9ad['where'],{'$or':_[_0xebf3('0x7e')](_0x35c9ad['attributes'],function(_0x1489c8){var _0xc23d8e={};_0xc23d8e[_0x1489c8]={'$like':'%'+_0x1093dc['query'][_0xebf3('0x7d')]+'%'};return _0xc23d8e;})});}_0x35c9ad=_[_0xebf3('0x34')]({},_0x35c9ad,_0x1093dc[_0xebf3('0x96')]);return db[_0xebf3('0x87')][_0xebf3('0x12')]({'where':_0x35c9ad[_0xebf3('0x58')]})[_0xebf3('0x17')](function(_0xfdba86){_0x23bc4d['count']=_0xfdba86;if(_0x1093dc[_0xebf3('0x28')]['includeAll']){_0x35c9ad[_0xebf3('0x97')]=[{'all':!![]}];}return db[_0xebf3('0x87')]['findAll'](_0x35c9ad);})[_0xebf3('0x17')](function(_0x2e60a7){_0x23bc4d[_0xebf3('0x98')]=_0x2e60a7;return _0x23bc4d;});}})[_0xebf3('0x17')](respondWithFilteredResult(_0x5a0b54,_0x35c9ad))['catch'](handleError(_0x5a0b54,null));};exports['getHopperHistories']=function(_0x32151b,_0x54ae7d){var _0x304b37={'raw':!![],'where':{}};var _0x2728fc={};var _0x2a6e80={'count':0x0,'rows':[]};return db['CmContact']['findOne']({'where':{'id':_0x32151b['params']['id']}})[_0xebf3('0x17')](handleEntityNotFound(_0x54ae7d,null))['then'](function(_0x307c27){if(_0x307c27){_0x2728fc[_0xebf3('0x76')]=_[_0xebf3('0x25')](db[_0xebf3('0x99')][_0xebf3('0x93')]);_0x2728fc[_0xebf3('0x28')]=_[_0xebf3('0x25')](_0x32151b[_0xebf3('0x28')]);_0x2728fc[_0xebf3('0x75')]=_[_0xebf3('0x78')](_0x2728fc[_0xebf3('0x76')],_0x2728fc[_0xebf3('0x28')]);_0x304b37[_0xebf3('0x77')]=_[_0xebf3('0x78')](_0x2728fc[_0xebf3('0x76')],qs[_0xebf3('0x79')](_0x32151b['query'][_0xebf3('0x79')]));_0x304b37[_0xebf3('0x77')]=_0x304b37[_0xebf3('0x77')][_0xebf3('0x2a')]?_0x304b37[_0xebf3('0x77')]:_0x2728fc['model'];if(!_0x32151b['query'][_0xebf3('0x7f')](_0xebf3('0x94'))){_0x304b37['limit']=qs['limit'](_0x32151b[_0xebf3('0x28')]['limit']);_0x304b37[_0xebf3('0x10')]=qs[_0xebf3('0x10')](_0x32151b['query'][_0xebf3('0x10')]);}_0x304b37[_0xebf3('0x7a')]=qs['sort'](_0x32151b[_0xebf3('0x28')]['sort']);_0x304b37[_0xebf3('0x58')]=qs[_0xebf3('0x75')](_[_0xebf3('0x7c')](_0x32151b[_0xebf3('0x28')],_0x2728fc[_0xebf3('0x75')]));_0x304b37[_0xebf3('0x58')]['ContactId']=_0x307c27['id'];if(_0x32151b[_0xebf3('0x28')][_0xebf3('0x7d')]){_0x304b37[_0xebf3('0x58')]=_[_0xebf3('0x34')](_0x304b37[_0xebf3('0x58')],{'$or':_[_0xebf3('0x7e')](_0x304b37[_0xebf3('0x77')],function(_0x459132){var _0x11e055={};_0x11e055[_0x459132]={'$like':'%'+_0x32151b['query'][_0xebf3('0x7d')]+'%'};return _0x11e055;})});}_0x304b37=_[_0xebf3('0x34')]({},_0x304b37,_0x32151b[_0xebf3('0x96')]);return db['CmHopperHistory'][_0xebf3('0x12')]({'where':_0x304b37[_0xebf3('0x58')]})[_0xebf3('0x17')](function(_0x5b97bf){_0x2a6e80[_0xebf3('0x12')]=_0x5b97bf;if(_0x32151b[_0xebf3('0x28')]['includeAll']){_0x304b37[_0xebf3('0x97')]=[{'all':!![]}];}return db[_0xebf3('0x99')][_0xebf3('0x1f')](_0x304b37);})['then'](function(_0x39a8a3){_0x2a6e80[_0xebf3('0x98')]=_0x39a8a3;return _0x2a6e80;});}})[_0xebf3('0x17')](respondWithFilteredResult(_0x54ae7d,_0x304b37))[_0xebf3('0x21')](handleError(_0x54ae7d,null));};exports[_0xebf3('0x9a')]=function(_0x4ca533,_0x5db1a8){var _0x5edda2={'raw':!![],'where':{}};var _0x3f0de8={};var _0x13306d={'count':0x0,'rows':[]};return db[_0xebf3('0x22')][_0xebf3('0x73')]({'where':{'id':_0x4ca533['params']['id']}})[_0xebf3('0x17')](handleEntityNotFound(_0x5db1a8,null))['then'](function(_0x14b493){if(_0x14b493){_0x3f0de8[_0xebf3('0x76')]=_[_0xebf3('0x25')](db['CmHopperFinal'][_0xebf3('0x93')]);_0x3f0de8[_0xebf3('0x28')]=_[_0xebf3('0x25')](_0x4ca533[_0xebf3('0x28')]);_0x3f0de8[_0xebf3('0x75')]=_[_0xebf3('0x78')](_0x3f0de8[_0xebf3('0x76')],_0x3f0de8[_0xebf3('0x28')]);_0x5edda2['attributes']=_['intersection'](_0x3f0de8[_0xebf3('0x76')],qs[_0xebf3('0x79')](_0x4ca533[_0xebf3('0x28')][_0xebf3('0x79')]));_0x5edda2['attributes']=_0x5edda2[_0xebf3('0x77')]['length']?_0x5edda2[_0xebf3('0x77')]:_0x3f0de8['model'];if(!_0x4ca533['query']['hasOwnProperty']('nolimit')){_0x5edda2[_0xebf3('0x13')]=qs['limit'](_0x4ca533[_0xebf3('0x28')]['limit']);_0x5edda2[_0xebf3('0x10')]=qs['offset'](_0x4ca533['query']['offset']);}_0x5edda2['order']=qs[_0xebf3('0x7b')](_0x4ca533[_0xebf3('0x28')][_0xebf3('0x7b')]);_0x5edda2['where']=qs[_0xebf3('0x75')](_[_0xebf3('0x7c')](_0x4ca533[_0xebf3('0x28')],_0x3f0de8[_0xebf3('0x75')]));_0x5edda2[_0xebf3('0x58')][_0xebf3('0x95')]=_0x14b493['id'];if(_0x4ca533[_0xebf3('0x28')][_0xebf3('0x7d')]){_0x5edda2[_0xebf3('0x58')]=_['merge'](_0x5edda2[_0xebf3('0x58')],{'$or':_[_0xebf3('0x7e')](_0x5edda2[_0xebf3('0x77')],function(_0x205e57){var _0x2dab82={};_0x2dab82[_0x205e57]={'$like':'%'+_0x4ca533[_0xebf3('0x28')][_0xebf3('0x7d')]+'%'};return _0x2dab82;})});}_0x5edda2=_[_0xebf3('0x34')]({},_0x5edda2,_0x4ca533[_0xebf3('0x96')]);return db[_0xebf3('0x48')][_0xebf3('0x12')]({'where':_0x5edda2['where']})[_0xebf3('0x17')](function(_0x39656d){_0x13306d[_0xebf3('0x12')]=_0x39656d;if(_0x4ca533[_0xebf3('0x28')][_0xebf3('0x9b')]){_0x5edda2[_0xebf3('0x97')]=[{'all':!![]}];}return db[_0xebf3('0x48')][_0xebf3('0x1f')](_0x5edda2);})['then'](function(_0x265cba){_0x13306d['rows']=_0x265cba;return _0x13306d;});}})['then'](respondWithFilteredResult(_0x5db1a8,_0x5edda2))['catch'](handleError(_0x5db1a8,null));};exports[_0xebf3('0x9c')]=function(_0x5e29e8,_0x5df7cb){var _0x3068b1={'raw':!![],'where':{}};var _0x9db397={};var _0x4deab6={'count':0x0,'rows':[]};return db['CmContact'][_0xebf3('0x73')]({'where':{'id':_0x5e29e8['params']['id']}})[_0xebf3('0x17')](handleEntityNotFound(_0x5df7cb,null))[_0xebf3('0x17')](function(_0x2ae5ba){if(_0x2ae5ba){_0x9db397[_0xebf3('0x76')]=_[_0xebf3('0x25')](db[_0xebf3('0x4e')][_0xebf3('0x93')]);_0x9db397[_0xebf3('0x28')]=_[_0xebf3('0x25')](_0x5e29e8[_0xebf3('0x28')]);_0x9db397['filters']=_[_0xebf3('0x78')](_0x9db397['model'],_0x9db397[_0xebf3('0x28')]);_0x3068b1[_0xebf3('0x77')]=_['intersection'](_0x9db397['model'],qs[_0xebf3('0x79')](_0x5e29e8[_0xebf3('0x28')]['fields']));_0x3068b1[_0xebf3('0x77')]=_0x3068b1[_0xebf3('0x77')][_0xebf3('0x2a')]?_0x3068b1[_0xebf3('0x77')]:_0x9db397['model'];if(!_0x5e29e8[_0xebf3('0x28')][_0xebf3('0x7f')](_0xebf3('0x94'))){_0x3068b1[_0xebf3('0x13')]=qs[_0xebf3('0x13')](_0x5e29e8[_0xebf3('0x28')][_0xebf3('0x13')]);_0x3068b1[_0xebf3('0x10')]=qs[_0xebf3('0x10')](_0x5e29e8[_0xebf3('0x28')][_0xebf3('0x10')]);}_0x3068b1[_0xebf3('0x7a')]=qs[_0xebf3('0x7b')](_0x5e29e8['query'][_0xebf3('0x7b')]);_0x3068b1[_0xebf3('0x58')]=qs[_0xebf3('0x75')](_[_0xebf3('0x7c')](_0x5e29e8[_0xebf3('0x28')],_0x9db397[_0xebf3('0x75')]));_0x3068b1[_0xebf3('0x58')][_0xebf3('0x95')]=_0x2ae5ba['id'];if(_0x5e29e8[_0xebf3('0x28')][_0xebf3('0x7d')]){_0x3068b1[_0xebf3('0x58')]=_[_0xebf3('0x34')](_0x3068b1[_0xebf3('0x58')],{'$or':_[_0xebf3('0x7e')](_0x3068b1[_0xebf3('0x77')],function(_0x56db5f){var _0x399904={};_0x399904[_0x56db5f]={'$like':'%'+_0x5e29e8['query'][_0xebf3('0x7d')]+'%'};return _0x399904;})});}_0x3068b1=_[_0xebf3('0x34')]({},_0x3068b1,_0x5e29e8[_0xebf3('0x96')]);return db[_0xebf3('0x4e')][_0xebf3('0x12')]({'where':_0x3068b1[_0xebf3('0x58')]})[_0xebf3('0x17')](function(_0x1f1058){_0x4deab6[_0xebf3('0x12')]=_0x1f1058;if(_0x5e29e8[_0xebf3('0x28')]['includeAll']){_0x3068b1[_0xebf3('0x97')]=[{'all':!![]}];}return db[_0xebf3('0x4e')][_0xebf3('0x1f')](_0x3068b1);})[_0xebf3('0x17')](function(_0x5ea7d8){_0x4deab6[_0xebf3('0x98')]=_0x5ea7d8;return _0x4deab6;});}})['then'](respondWithFilteredResult(_0x5df7cb,_0x3068b1))[_0xebf3('0x21')](handleError(_0x5df7cb,null));};exports[_0xebf3('0x9d')]=function(_0x286b76,_0x2d0e9e){try{if(!_0x286b76[_0xebf3('0x35')][_0xebf3('0x5b')]){throw new Error(_0xebf3('0x9e'));}if(!_0x286b76[_0xebf3('0x35')][_0xebf3('0x9f')]){throw new Error(_0xebf3('0xa0'));}if(!_0x286b76[_0xebf3('0x35')][_0xebf3('0xa1')]){throw new Error('No\x20association\x20values\x20specified!');}if(!_0x286b76[_0xebf3('0x35')][_0xebf3('0xa2')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x2a0095=_0x286b76[_0xebf3('0x35')][_0xebf3('0x9f')]['split'](',');var _0x36e72c=_0x286b76[_0xebf3('0x35')][_0xebf3('0xa1')]['split'](',');if(!_0x2a0095[_0xebf3('0x2a')]||!_0x36e72c['length']||_0x2a0095[_0xebf3('0x2a')]!==_0x36e72c[_0xebf3('0x2a')]){throw new Error(_0xebf3('0xa3'));}_0x286b76[_0xebf3('0x35')][_0xebf3('0x79')]=_[_0xebf3('0xa4')](_0x2a0095,_0x36e72c);if(!_0x286b76[_0xebf3('0x35')]['fields'][_0xebf3('0x71')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x286b76[_0xebf3('0x35')][_0xebf3('0x79')][_0xebf3('0xa5')]){throw new Error(_0xebf3('0xa6'));}var _0x5aaa77=path[_0xebf3('0xa7')](config[_0xebf3('0xa8')],_0xebf3('0xa9'),_0x286b76[_0xebf3('0xaa')]['filename']);fs[_0xebf3('0xab')](_0x5aaa77,parseInt(_0xebf3('0xac'),0x8));var _0x4025fb=require(_0xebf3('0xad'))[_0xebf3('0xae')](path[_0xebf3('0xa7')](__dirname,'../../components/import/cm/csv'),[_0x5aaa77,_0x286b76['body'][_0xebf3('0x9f')],_0x286b76[_0xebf3('0x35')]['binding_values'],_0x286b76[_0xebf3('0x35')][_0xebf3('0x5b')],_0x286b76[_0xebf3('0x35')][_0xebf3('0xaf')],_0x286b76[_0xebf3('0x35')][_0xebf3('0x57')],_0x286b76[_0xebf3('0x35')]['socket_timestamp']]);return _0x2d0e9e['status'](0xc8)[_0xebf3('0xf')]({'message':_0xebf3('0xb0'),'pid':_0x4025fb[_0xebf3('0xb1')]});}catch(_0x58aaa4){return _0x2d0e9e['status'](0x1f4)['send'](_0x58aaa4);}};exports[_0xebf3('0xb2')]=function(_0x36871f,_0x37918a){var _0x5f2ab1=fs[_0xebf3('0xb3')](_0x36871f[_0xebf3('0xaa')]['path']);Papa[_0xebf3('0xb4')](_0x5f2ab1,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x5d57e6){return _0x37918a[_0xebf3('0xe')](0xc8)[_0xebf3('0xf')]({'file':_0x36871f[_0xebf3('0xaa')],'fields':_0x5d57e6[_0xebf3('0xb5')]['fields']});}});};exports[_0xebf3('0xb6')]=function(_0x4d0805,_0x4853c8){return db[_0xebf3('0xb7')][_0xebf3('0x1f')]({'raw':!![],'attributes':['id'],'where':{'role':_0xebf3('0xb8')}})[_0xebf3('0x17')](function(_0x2c7fd0){var _0x32d992=![];if(!_0x4d0805[_0xebf3('0x35')]['ListId']){throw new Error(_0xebf3('0x9e'));}if(!_0x4d0805[_0xebf3('0x35')][_0xebf3('0xb9')][_0xebf3('0x71')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x4d0805[_0xebf3('0x35')][_0xebf3('0xb9')]['firstName']){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x4d0805['body'][_0xebf3('0xa2')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x46050f=require(_0xebf3('0xad'))[_0xebf3('0xae')](path['join'](__dirname,'../../components/import/cm/csv2'),[_0x4d0805[_0xebf3('0x24')]['id'],JSON[_0xebf3('0xba')](_0x4d0805[_0xebf3('0x35')]),JSON['stringify'](_0x2c7fd0)]);_0x46050f['on'](_0xebf3('0xbb'),function(){_0x32d992=!![];return _0x4853c8[_0xebf3('0xe')](0xc8)[_0xebf3('0xf')]({'message':_0xebf3('0xbc'),'pid':_0x46050f[_0xebf3('0xb1')]});});_0x46050f['on'](_0xebf3('0xbd'),function(_0x5a1753){if(_0x5a1753&&!_0x32d992){return _0x4853c8[_0xebf3('0xe')](0x1f4)[_0xebf3('0xf')]({'message':_0xebf3('0xbe'),'pid':_0x46050f[_0xebf3('0xb1')]});}});})[_0xebf3('0x21')](handleError(_0x4853c8,null));};exports[_0xebf3('0xbf')]=function(_0x21bb14,_0xf322fb){return db[_0xebf3('0xb7')][_0xebf3('0x1f')]({'raw':!![],'attributes':['id'],'where':{'role':_0xebf3('0xb8')}})[_0xebf3('0x17')](function(_0x52e0d9){var _0x1eec61=![];if(!_0x21bb14[_0xebf3('0x35')][_0xebf3('0x5b')]){throw new Error(_0xebf3('0x9e'));}if(!_0x21bb14[_0xebf3('0x35')][_0xebf3('0xb9')][_0xebf3('0x71')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x21bb14[_0xebf3('0x35')][_0xebf3('0xb9')][_0xebf3('0xa5')]){throw new Error(_0xebf3('0xa6'));}if(!_0x21bb14['body']['socket_timestamp']){throw new Error(_0xebf3('0xc0'));}var _0x23666d=require(_0xebf3('0xad'))[_0xebf3('0xae')](path[_0xebf3('0xa7')](__dirname,_0xebf3('0xc1')),[_0x21bb14[_0xebf3('0x24')]['id'],JSON[_0xebf3('0xba')](_0x21bb14[_0xebf3('0x35')]),JSON['stringify'](_0x52e0d9)]);_0x23666d['on'](_0xebf3('0xbb'),function(){_0x1eec61=!![];return _0xf322fb[_0xebf3('0xe')](0xc8)[_0xebf3('0xf')]({'message':_0xebf3('0xbc'),'pid':_0x23666d[_0xebf3('0xb1')]});});_0x23666d['on']('exit',function(_0x25cfb3){if(_0x25cfb3&&!_0x1eec61){return _0xf322fb[_0xebf3('0xe')](0x1f4)['json']({'message':_0xebf3('0xbe'),'pid':_0x23666d[_0xebf3('0xb1')]});}});})['catch'](handleError(_0xf322fb,null));};exports['getJourney']=function(_0x4a1b07,_0x16c6b5){var _0x185b60=[_0xebf3('0xc2'),_0xebf3('0xc3'),'sms','openchannel',_0xebf3('0xc4'),_0xebf3('0xc5'),_0xebf3('0xc6')];var _0x585a6a={'offset':0x0,'order':qs[_0xebf3('0x7b')]('-createdAt')},_0x2864a0={'count':0x0,'rows':[]};Promise[_0xebf3('0xc7')]()[_0xebf3('0x17')](function(){if(_0x4a1b07[_0xebf3('0x28')]['channel']){if(!_[_0xebf3('0xc8')](_0x185b60,_0x4a1b07[_0xebf3('0x28')][_0xebf3('0xc9')][_0xebf3('0xca')]())){throw new Error(_0xebf3('0xcb'));}_0x185b60=[_0x4a1b07[_0xebf3('0x28')]['channel'][_0xebf3('0xca')]()];}if(_0x4a1b07[_0xebf3('0x28')][_0xebf3('0xcc')]){try{var _0x47c45b=JSON[_0xebf3('0xb4')](_0x4a1b07[_0xebf3('0x28')][_0xebf3('0xcc')]);if(!moment(_0x47c45b[_0xebf3('0x36')])[_0xebf3('0xcd')]()){throw new Error(_0xebf3('0xce'));}if(!moment(_0x47c45b['to'])[_0xebf3('0xcd')]()){throw new Error(_0xebf3('0xcf'));}}catch(_0x29f57a){throw new Error(_0xebf3('0xd0'));}}if(!_0x4a1b07[_0xebf3('0x28')][_0xebf3('0x7f')](_0xebf3('0x94'))){_0x585a6a[_0xebf3('0x13')]=qs[_0xebf3('0x13')](_0x4a1b07[_0xebf3('0x28')]['limit']||0xa);_0x585a6a[_0xebf3('0x10')]=qs['offset'](_0x4a1b07[_0xebf3('0x28')]['offset']);}var _0x39ac4d=_0x185b60[_0xebf3('0x7e')](function(_0x18ac83){if(_0x18ac83===_0xebf3('0xc6')){var _0x8f2072={'attributes':['id','uniqueid',_0xebf3('0x2f'),'source',_0xebf3('0xd1'),_0xebf3('0xd2'),_0xebf3('0xd3'),_0xebf3('0xd4'),_0xebf3('0xd5'),_0xebf3('0xd6'),_0xebf3('0xd7'),_0xebf3('0xd8'),_0xebf3('0xd9'),'userThirdDisposition','UserId'],'where':{'ContactId':_0x4a1b07[_0xebf3('0x24')]['id']},'include':[{'model':db[_0xebf3('0xb7')],'as':'User','attributes':['id',_0xebf3('0x1c'),_0xebf3('0xda'),_0xebf3('0x2d')]}],'order':[[_0xebf3('0xd7'),_0xebf3('0xdb')]]};if(_0x4a1b07[_0xebf3('0x28')][_0xebf3('0xcc')]){_0x8f2072[_0xebf3('0x58')][_0xebf3('0xd7')]={'$gte':_0x47c45b[_0xebf3('0x36')],'$lte':_0x47c45b['to']};}return db[_0xebf3('0x4a')]['findAndCountAll'](_0x8f2072)['then'](function(_0x36dff8){_0x2864a0['count']+=_0x36dff8[_0xebf3('0x12')];return _['map'](_0x36dff8['rows'],function(_0x5bd19d){var _0x4ea1eb=_0x5bd19d['get']({'plain':!![]});_0x4ea1eb[_0xebf3('0xc9')]=_0x18ac83;if(_0x4ea1eb[_0xebf3('0xb7')]){_0x4ea1eb[_0xebf3('0xb7')]={'id':_0x4ea1eb['User']['id'],'name':_0x4ea1eb['User']['name'],'fullname':_0x4ea1eb['User'][_0xebf3('0xda')],'alias':_0x4ea1eb['User'][_0xebf3('0x2d')]};}return _0x4ea1eb;});});}else{var _0x135e5f=_[_0xebf3('0xdc')](_0x18ac83)+(_0x18ac83===_0xebf3('0xc3')?'Website':_0xebf3('0xdd'));var _0x30c511={'attributes':['id',_0xebf3('0xde'),_0xebf3('0xdf'),_0xebf3('0xd7'),_0xebf3('0xd6'),_0xebf3('0xe0'),_0xebf3('0xe1'),'thirdDisposition',_0xebf3('0xe2'),_0x135e5f+'Id'],'where':{'ContactId':_0x4a1b07[_0xebf3('0x24')]['id']},'include':[{'model':db[_0x135e5f],'as':_0xebf3('0xdd'),'attributes':['id',_0xebf3('0x1c'),_0xebf3('0xe3')]},{'model':db[_0xebf3('0xb7')],'as':'Owner','attributes':['id',_0xebf3('0x1c'),_0xebf3('0xda')]},{'model':db[_0xebf3('0x74')],'as':_0xebf3('0x60'),'attributes':['id',_0xebf3('0x1c'),'color'],'through':{'attributes':[]}}],'order':[['createdAt','DESC']]};if(_0x4a1b07[_0xebf3('0x28')][_0xebf3('0xcc')]){_0x30c511[_0xebf3('0x58')][_0xebf3('0xd7')]={'$gte':_0x47c45b[_0xebf3('0x36')],'$lte':_0x47c45b['to']};}switch(_0x18ac83){case _0xebf3('0xc3'):_0x30c511[_0xebf3('0x77')][_0xebf3('0x5a')](_0xebf3('0xe4'),_0xebf3('0xe5'),_0xebf3('0xe6'),_0xebf3('0xe7'),_0xebf3('0xe8'),_0xebf3('0xe9'),'ratingType',_0xebf3('0xea'),_0xebf3('0xeb'));break;case _0xebf3('0xc2'):_0x30c511[_0xebf3('0x77')][_0xebf3('0x5a')](_0xebf3('0xec'),_0xebf3('0xed'));break;case _0xebf3('0xee'):_0x30c511['attributes'][_0xebf3('0x5a')](_0xebf3('0xef'),_0xebf3('0xf0'));break;}return db[_[_0xebf3('0xdc')](_0x18ac83)+'Interaction']['findAndCountAll'](_0x30c511)[_0xebf3('0x17')](function(_0x4fadc8){_0x2864a0[_0xebf3('0x12')]+=_0x4fadc8[_0xebf3('0x12')];return _[_0xebf3('0x7e')](_0x4fadc8[_0xebf3('0x98')],function(_0x543952){var _0x3e0077=_0x543952[_0xebf3('0x37')]({'plain':!![]});_0x3e0077[_0xebf3('0xc9')]=_0x18ac83;if(_0x3e0077[_0xebf3('0xf1')]){_0x3e0077[_0xebf3('0xf1')]={'id':_0x3e0077['Owner']['id'],'name':_0x3e0077['Owner'][_0xebf3('0x1c')],'fullname':_0x3e0077[_0xebf3('0xf1')]['fullname']};}return _0x3e0077;});});}});return Promise['all'](_0x39ac4d);})[_0xebf3('0x17')](function(_0x58486c){return _(_0x58486c)[_0xebf3('0xf2')]()[_0xebf3('0xf3')](_0xebf3('0xd7'))[_0xebf3('0xf4')]()[_0xebf3('0xf5')]();})[_0xebf3('0x17')](function(_0x581fa3){_0x2864a0[_0xebf3('0x98')]=_0x585a6a[_0xebf3('0x13')]?_0x581fa3[_0xebf3('0xf6')](_0x585a6a['offset'],_0x585a6a[_0xebf3('0x10')]+_0x585a6a[_0xebf3('0x13')]):_0x581fa3;return _0x2864a0;})[_0xebf3('0x17')](respondWithFilteredResult(_0x16c6b5,_0x585a6a))[_0xebf3('0x21')](handleError(_0x16c6b5,null));};
\ No newline at end of file
+var _0xfee8=['toContactId','order','ContactId','merge','include','rows','getHopperHistories','includeAll','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','root','server/files/tmp','chmodSync','0777','child_process','../../components/import/cm/csv','binding_keys','socket_timestamp','File\x20uploaded\x20correctly!','pid','upload','createReadStream','file','parse','meta','import','User','agent','binding','fork','stringify','message','exit','start\x20child\x20process\x20correctly!','error\x20child\x20process','getJourney','chat','sms','openchannel','fax','whatsapp','-createdAt','resolve','channel','includes','toLowerCase','range','isValid','Invalid\x20date\x20for\x20range\x20to\x20filter','Invalid\x20createdAt\x20filter','voice','uniqueid','type','source','destination','callerid','starttime','endtime','note','createdAt','userDisposition','userSecondDisposition','userThirdDisposition','UserId','DESC','VoiceCallReport','fullname','Website','closed','closedAt','disposition','secondDisposition','thirdDisposition','Account','key','browserName','customerIp','customerPort','osName','ratingMessage','ratingType','ratingValue','referer','mail','subject','substatus','externalUrl','threadId','startCase','Interaction','findAndCountAll','Owner','sortBy','reverse','value','slice','moment','util','path','lodash','squel','papaparse','ioredis','../../components/contacts','../../components/parsers/qs','../../config/logger','../../config/environment','../../config/environment/shared','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./cmContact.socket','register','status','json','offset','limit','undefined','count','set','Content-Range','then','destroy','end','error','stack','name','send','index','describe','query','user','catch','CmContact','find','tags','length','keys','startsWith','cf_','columnName','displayName','analytics','findAll','alias','values','Custom\x20field\x20%s\x20not\x20found\x20on\x20cm_contacts\x20table','hasOwnProperty','body','from','get','mergeWith','isArray','join','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','info','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','update','ChatMessage','MailInteraction','MailMessage','SmsMessage','FaxInteraction','FaxMessage','OpenchannelMessage','CmContactHasItem','CmHopperFinal','CmHopperHistory','ChatQueueReport','FaxQueueReport','MailQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappMessage','WhatsappQueueReport','dialTimezone','isNil','timezones','utcOffset','additionalPhones','bulkCreate','each','duplicates','where','$or','push','ListId','findOrCreate','all','show','params','Tag','Tags','color','tag','Phones','ContactItemType','ItemType','sequelize','literal','Phones.OrderBy','$and','CmCustomField','omit','format','cf_%d','pickBy','map','isEmpty','table','cm_contacts','setFields','id\x20=\x20?','toParam','text','phone','getTags','findOne','rawAttributes','intersection','model','attributes','fields','sort','pick','filters','filter','options','nolimit','ids','setAdditionalPhones','OrderBy','items','item_types','ItemTypeId','description','contact\x20phone\x20exists','CmHopperAdditionalPhone','PHONE','CmHopperId','item','ItemType.OrderBy','getAdditionalPhones','`ItemType`.OrderBy','duplicateAdditionalPhones','fromContactId','CmContactId'];(function(_0x20a584,_0xe384a5){var _0x4b41a8=function(_0x2127c6){while(--_0x2127c6){_0x20a584['push'](_0x20a584['shift']());}};_0x4b41a8(++_0xe384a5);}(_0xfee8,0x6a));var _0x8fee=function(_0x4adad3,_0x202bba){_0x4adad3=_0x4adad3-0x0;var _0x52dae4=_0xfee8[_0x4adad3];return _0x52dae4;};'use strict';var moment=require(_0x8fee('0x0'));var BPromise=require('bluebird');var util=require(_0x8fee('0x1'));var path=require(_0x8fee('0x2'));var fs=require('fs');var _=require(_0x8fee('0x3'));var squel=require(_0x8fee('0x4'));var Papa=require(_0x8fee('0x5'));var Redis=require(_0x8fee('0x6'));var contacts=require(_0x8fee('0x7'));var qs=require(_0x8fee('0x8'));var logger=require(_0x8fee('0x9'))('api');var config=require(_0x8fee('0xa'));var shared=require(_0x8fee('0xb'));var db=require(_0x8fee('0xc'))['db'];config[_0x8fee('0xd')]=_[_0x8fee('0xe')](config[_0x8fee('0xd')],{'host':_0x8fee('0xf'),'port':0x18eb});var socket=require(_0x8fee('0x10'))(new Redis(config[_0x8fee('0xd')]));require(_0x8fee('0x11'))[_0x8fee('0x12')](socket);function respondWithResult(_0x898d9b,_0x1a817c){_0x1a817c=_0x1a817c||0xc8;return function(_0x9f8fa0){if(_0x9f8fa0){return _0x898d9b[_0x8fee('0x13')](_0x1a817c)[_0x8fee('0x14')](_0x9f8fa0);}};}function respondWithFilteredResult(_0x12d873,_0x5ca9c7){return function(_0x1c12ff){if(_0x1c12ff){var _0x1544ba=typeof _0x5ca9c7[_0x8fee('0x15')]==='undefined'&&typeof _0x5ca9c7[_0x8fee('0x16')]===_0x8fee('0x17');var _0x4b313d=_0x1c12ff[_0x8fee('0x18')];var _0x3e7619=_0x1544ba?0x0:_0x5ca9c7[_0x8fee('0x15')];var _0x47bf90=_0x1544ba?_0x1c12ff[_0x8fee('0x18')]:_0x5ca9c7[_0x8fee('0x15')]+_0x5ca9c7['limit'];var _0x135d18;if(_0x47bf90>=_0x4b313d){_0x47bf90=_0x4b313d;_0x135d18=0xc8;}else{_0x135d18=0xce;}_0x12d873[_0x8fee('0x13')](_0x135d18);return _0x12d873[_0x8fee('0x19')](_0x8fee('0x1a'),_0x3e7619+'-'+_0x47bf90+'/'+_0x4b313d)['json'](_0x1c12ff);}return null;};}function saveUpdates(_0x132c12){return function(_0x344bfa){if(_0x344bfa){return _0x344bfa['update'](_0x132c12)[_0x8fee('0x1b')](function(_0x34365f){return _0x34365f;});}return null;};}function removeEntity(_0x36507b){return function(_0x492280){if(_0x492280){return _0x492280[_0x8fee('0x1c')]()[_0x8fee('0x1b')](function(){_0x36507b[_0x8fee('0x13')](0xcc)[_0x8fee('0x1d')]();});}};}function handleEntityNotFound(_0xd9778a){return function(_0x163265){if(!_0x163265){_0xd9778a['sendStatus'](0x194);}return _0x163265;};}function handleError(_0x2945dc,_0xdf6552){_0xdf6552=_0xdf6552||0x1f4;return function(_0x305658){logger[_0x8fee('0x1e')](_0x305658[_0x8fee('0x1f')]);if(_0x305658[_0x8fee('0x20')]){delete _0x305658['name'];}_0x2945dc[_0x8fee('0x13')](_0xdf6552)[_0x8fee('0x21')](_0x305658);};}exports[_0x8fee('0x22')]=function(_0x4f5477,_0x9d40ed){var _0x1bb13e={};return contacts[_0x8fee('0x23')]()[_0x8fee('0x1b')](function(_0x7b97dc){_0x1bb13e=qs['getOptions'](_0x7b97dc,_0x4f5477);return contacts['findAll'](_0x4f5477[_0x8fee('0x24')],_0x4f5477[_0x8fee('0x25')],_0x1bb13e,_0x7b97dc);})[_0x8fee('0x1b')](respondWithFilteredResult(_0x9d40ed,_0x1bb13e))[_0x8fee('0x26')](handleError(_0x9d40ed,null));};exports[_0x8fee('0x1c')]=function(_0x5e7b5e,_0x4e1da8){return db[_0x8fee('0x27')][_0x8fee('0x28')]({'where':{'id':_0x5e7b5e['params']['id']}})[_0x8fee('0x1b')](handleEntityNotFound(_0x4e1da8,null))[_0x8fee('0x1b')](removeEntity(_0x4e1da8,null))['catch'](handleError(_0x4e1da8,null));};exports['describe']=function(_0x839cfc,_0x134779){return db[_0x8fee('0x27')]['describe']()['then'](function(_0x1a8b4a){delete _0x1a8b4a[_0x8fee('0x29')];for(var _0x4e15fd=0x0;_0x4e15fd<Object['keys'](_0x1a8b4a)[_0x8fee('0x2a')];_0x4e15fd++){var _0x544157=Object[_0x8fee('0x2b')](_0x1a8b4a)[_0x4e15fd];if(!_[_0x8fee('0x2c')](_0x544157,_0x8fee('0x2d'))){_0x1a8b4a[_0x544157][_0x8fee('0x2e')]=_0x544157;_0x1a8b4a[_0x544157][_0x8fee('0x2f')]=_0x544157;}}return _0x1a8b4a;})[_0x8fee('0x1b')](function(_0x5a2cac){var _0x1ef1e7={'where':Boolean(_0x839cfc['query'][_0x8fee('0x30')])===!![]?undefined:{'$or':[{'ListId':_0x839cfc[_0x8fee('0x24')]['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField'][_0x8fee('0x31')](_0x1ef1e7)['then'](function(_0x38bf09){for(var _0x532354=0x0;_0x532354<_0x38bf09[_0x8fee('0x2a')];_0x532354++){var _0x3e788f=_0x8fee('0x2d')+_0x38bf09[_0x532354]['id'];if(_0x5a2cac[_0x3e788f]){_0x5a2cac[_0x3e788f][_0x8fee('0x2e')]=_0x3e788f;_0x5a2cac[_0x3e788f]['displayName']=_0x38bf09[_0x532354][_0x8fee('0x32')];_0x5a2cac[_0x3e788f]['custom']={'type':_0x38bf09[_0x532354]['type'],'values':_0x38bf09[_0x532354][_0x8fee('0x33')]};}else{logger['info'](_0x8fee('0x34'),_0x3e788f);}}Object['keys'](_0x5a2cac)['forEach'](function(_0x4c88e1){if(!_0x5a2cac[_0x4c88e1][_0x8fee('0x35')]('columnName')){delete _0x5a2cac[_0x4c88e1];}});return _0x5a2cac;});})[_0x8fee('0x1b')](respondWithResult(_0x134779,null))['catch'](handleError(_0x134779,null));};exports['merge']=function(_0x230986,_0x2d8232){var _0x19b663;var _0x449935;var _0x53e1bb;if(_0x230986[_0x8fee('0x36')]['id']){delete _0x230986[_0x8fee('0x36')]['id'];}return db[_0x8fee('0x27')][_0x8fee('0x31')]({'where':{'id':[_0x230986[_0x8fee('0x36')]['to'],_0x230986[_0x8fee('0x36')][_0x8fee('0x37')]]}})[_0x8fee('0x1b')](function(_0x359fe3){if(_0x359fe3){if(_0x359fe3[_0x8fee('0x2a')]!==0x2){return null;}_0x359fe3[0x0]=_0x359fe3[0x0][_0x8fee('0x38')]({'plain':!![]});_0x359fe3[0x1]=_0x359fe3[0x1][_0x8fee('0x38')]({'plain':!![]});delete _0x359fe3[0x0]['id'];delete _0x359fe3[0x1]['id'];return _[_0x8fee('0x39')](_0x359fe3[0x0],_0x359fe3[0x1],function(_0x4e83fb,_0x1f0db7){if(Array['isArray'](_0x1f0db7)&&!_0x1f0db7[_0x8fee('0x2a')]){return _0x4e83fb;}else if(!_0x1f0db7){return _0x4e83fb;}});}})['then'](handleEntityNotFound(_0x2d8232,null))['then'](function(_0x5f0272){if(_0x5f0272){if(_0x5f0272[_0x8fee('0x29')]&&_[_0x8fee('0x3a')](_0x5f0272[_0x8fee('0x29')])){_0x5f0272[_0x8fee('0x29')]=_0x5f0272[_0x8fee('0x29')][_0x8fee('0x3b')]();}logger['info'](_0x8fee('0x3c'),_0x230986[_0x8fee('0x36')]['to'],_0x230986[_0x8fee('0x36')][_0x8fee('0x37')]);return db[_0x8fee('0x3d')]['destroy']({'where':{'ContactId':[_0x230986[_0x8fee('0x36')]['to'],_0x230986[_0x8fee('0x36')][_0x8fee('0x37')]]}})[_0x8fee('0x1b')](function(_0x5a11a3){logger[_0x8fee('0x3e')](_0x8fee('0x3f'),_0x5a11a3);return db[_0x8fee('0x40')][_0x8fee('0x1c')]({'where':{'ContactId':[_0x230986[_0x8fee('0x36')]['to'],_0x230986[_0x8fee('0x36')][_0x8fee('0x37')]]}})[_0x8fee('0x1b')](function(_0x283ab5){logger[_0x8fee('0x3e')](_0x8fee('0x41'),_0x283ab5);return db[_0x8fee('0x27')][_0x8fee('0x42')](_0x5f0272);});});}})[_0x8fee('0x1b')](function(_0x26c34d){if(_0x26c34d){_0x19b663=_0x26c34d;_0x449935={'ContactId':_0x19b663['id']};_0x53e1bb={'where':{'ContactId':[_0x230986[_0x8fee('0x36')]['to'],_0x230986['body'][_0x8fee('0x37')]]}};return db['ChatInteraction'][_0x8fee('0x43')](_0x449935,_0x53e1bb);}})['then'](function(){if(_0x19b663){return db[_0x8fee('0x44')][_0x8fee('0x43')](_0x449935,_0x53e1bb);}})[_0x8fee('0x1b')](function(){if(_0x19b663){return db['ChatOfflineMessage'][_0x8fee('0x43')](_0x449935,_0x53e1bb);}})[_0x8fee('0x1b')](function(){if(_0x19b663){return db[_0x8fee('0x45')][_0x8fee('0x43')](_0x449935,_0x53e1bb);}})[_0x8fee('0x1b')](function(){if(_0x19b663){return db[_0x8fee('0x46')][_0x8fee('0x43')](_0x449935,_0x53e1bb);}})[_0x8fee('0x1b')](function(){if(_0x19b663){return db[_0x8fee('0x45')][_0x8fee('0x43')](_0x449935,_0x53e1bb);}})[_0x8fee('0x1b')](function(){if(_0x19b663){return db[_0x8fee('0x46')][_0x8fee('0x43')](_0x449935,_0x53e1bb);}})[_0x8fee('0x1b')](function(){if(_0x19b663){return db['SmsInteraction'][_0x8fee('0x43')](_0x449935,_0x53e1bb);}})['then'](function(){if(_0x19b663){return db[_0x8fee('0x47')][_0x8fee('0x43')](_0x449935,_0x53e1bb);}})[_0x8fee('0x1b')](function(){if(_0x19b663){return db[_0x8fee('0x48')]['update'](_0x449935,_0x53e1bb);}})[_0x8fee('0x1b')](function(){if(_0x19b663){return db[_0x8fee('0x49')][_0x8fee('0x43')](_0x449935,_0x53e1bb);}})[_0x8fee('0x1b')](function(){if(_0x19b663){return db['OpenchannelInteraction'][_0x8fee('0x43')](_0x449935,_0x53e1bb);}})['then'](function(){if(_0x19b663){return db[_0x8fee('0x4a')][_0x8fee('0x43')](_0x449935,_0x53e1bb);}})[_0x8fee('0x1b')](function(){if(_0x19b663){return db[_0x8fee('0x4b')]['update']({'CmContactId':_0x19b663['id']},{'where':{'CmContactId':[_0x230986[_0x8fee('0x36')]['to'],_0x230986[_0x8fee('0x36')][_0x8fee('0x37')]]}});}})[_0x8fee('0x1b')](function(){if(_0x19b663){return db[_0x8fee('0x4c')][_0x8fee('0x43')](_0x449935,_0x53e1bb);}})['then'](function(){if(_0x19b663){return db[_0x8fee('0x4d')][_0x8fee('0x43')](_0x449935,_0x53e1bb);}})[_0x8fee('0x1b')](function(){if(_0x19b663){return db['ReportAgentPreview'][_0x8fee('0x43')](_0x449935,_0x53e1bb);}})[_0x8fee('0x1b')](function(){if(_0x19b663){return db['VoiceCallReport'][_0x8fee('0x43')](_0x449935,_0x53e1bb);}})[_0x8fee('0x1b')](function(){if(_0x19b663){return db[_0x8fee('0x4e')][_0x8fee('0x43')](_0x449935,_0x53e1bb);}})[_0x8fee('0x1b')](function(){if(_0x19b663){return db[_0x8fee('0x4f')][_0x8fee('0x43')](_0x449935,_0x53e1bb);}})['then'](function(){if(_0x19b663){return db[_0x8fee('0x50')]['update'](_0x449935,_0x53e1bb);}})['then'](function(){if(_0x19b663){return db['OpenchannelQueueReport']['update'](_0x449935,_0x53e1bb);}})[_0x8fee('0x1b')](function(){if(_0x19b663){return db[_0x8fee('0x51')]['update'](_0x449935,_0x53e1bb);}})[_0x8fee('0x1b')](function(){if(_0x19b663){return db[_0x8fee('0x52')][_0x8fee('0x43')](_0x449935,_0x53e1bb);}})[_0x8fee('0x1b')](function(){if(_0x19b663){return db[_0x8fee('0x53')]['update'](_0x449935,_0x53e1bb);}})[_0x8fee('0x1b')](function(){if(_0x19b663){return db[_0x8fee('0x54')][_0x8fee('0x43')](_0x449935,_0x53e1bb);}})[_0x8fee('0x1b')](function(){if(_0x19b663){return db[_0x8fee('0x55')][_0x8fee('0x43')](_0x449935,_0x53e1bb);}})[_0x8fee('0x1b')](function(){if(_0x19b663){return db[_0x8fee('0x27')][_0x8fee('0x1c')]({'where':{'id':[_0x230986[_0x8fee('0x36')]['to'],_0x230986[_0x8fee('0x36')][_0x8fee('0x37')]]}});}})['then'](function(){if(_0x19b663){return _0x19b663;}})['then'](respondWithResult(_0x2d8232,null))[_0x8fee('0x26')](handleError(_0x2d8232,null));};exports['create']=function(_0x3b8f72,_0x373e6a){return db[_0x8fee('0x27')][_0x8fee('0x23')]()[_0x8fee('0x1b')](function(_0x7a87c8){if(_0x3b8f72[_0x8fee('0x36')][_0x8fee('0x29')]&&_[_0x8fee('0x3a')](_0x3b8f72[_0x8fee('0x36')][_0x8fee('0x29')])){if(_0x3b8f72['body']['tags'][_0x8fee('0x2a')]){_0x3b8f72[_0x8fee('0x36')][_0x8fee('0x29')]=_0x3b8f72[_0x8fee('0x36')]['tags'][_0x8fee('0x3b')](';')+';';}else{_0x3b8f72[_0x8fee('0x36')][_0x8fee('0x29')]=null;}}else{_0x3b8f72['body'][_0x8fee('0x29')]=null;}if(!_['isNil'](_0x3b8f72['body'][_0x8fee('0x56')])){var _0x579a6a=_0x3b8f72[_0x8fee('0x36')][_0x8fee('0x56')];if(!_[_0x8fee('0x57')](shared[_0x8fee('0x58')][_0x579a6a]))_0x3b8f72[_0x8fee('0x36')][_0x8fee('0x59')]=shared['timezones'][_0x579a6a]['utcOffset'];}return db[_0x8fee('0x27')][_0x8fee('0x42')](_0x3b8f72[_0x8fee('0x36')],{'fields':_[_0x8fee('0x2b')](_0x7a87c8),'raw':!![]});})[_0x8fee('0x1b')](function(_0x570b88){if(_0x3b8f72[_0x8fee('0x36')][_0x8fee('0x5a')]){return insertAdditionalPhones(_0x570b88,_0x3b8f72['body'][_0x8fee('0x5a')]);}else{return _0x570b88;}})['then'](respondWithResult(_0x373e6a,0xc9))[_0x8fee('0x26')](handleError(_0x373e6a,null));};exports[_0x8fee('0x5b')]=function(_0x597149,_0x18fb55){var _0x252154=0x0;var _0x352190=0x0;var _0x48b8fa=0x0;var _0x50bee9=[];return db[_0x8fee('0x27')][_0x8fee('0x23')]()['then'](function(_0xb68931){return BPromise[_0x8fee('0x5c')](_0x597149[_0x8fee('0x36')],function(_0x3d5527){var _0x3e66ad={'where':{'$or':[]},'defaults':_0x3d5527,'fields':_[_0x8fee('0x2b')](_0xb68931),'raw':!![]};if(_0x3d5527[_0x8fee('0x5d')]){for(var _0x3e0648=0x0;_0x3e0648<_0x3d5527['duplicates']['length'];_0x3e0648++){var _0x23e314={};_0x23e314[_0x3d5527[_0x8fee('0x5d')][_0x3e0648]]=_0x3d5527[_0x3d5527['duplicates'][_0x3e0648]];_0x3e66ad[_0x8fee('0x5e')][_0x8fee('0x5f')][_0x8fee('0x60')](_0x23e314);}_0x3e66ad['where'][_0x8fee('0x61')]=_0x3d5527[_0x8fee('0x61')];}return db[_0x8fee('0x27')][_0x8fee('0x62')](_0x3e66ad)['spread'](function(_0x49649f,_0x177233){if(_0x177233){if(_0x3d5527[_0x8fee('0x35')](_0x8fee('0x5a'))){_0x50bee9['push']({'contact':_0x49649f,'additionalPhones':_0x3d5527[_0x8fee('0x5a')]});}_0x252154++;}else{_0x48b8fa++;}})['catch'](function(){_0x352190++;});});})[_0x8fee('0x1b')](function(_0x2fc163){if(_0x2fc163){if(_0x50bee9[_0x8fee('0x2a')]>0x0){return new Promise(function(_0x585c0c){var _0x2b76fd=[];for(var _0x56c531=0x0;_0x56c531<_0x50bee9[_0x8fee('0x2a')];_0x56c531++){_0x2b76fd[_0x8fee('0x60')](insertAdditionalPhones(_0x50bee9[_0x56c531]['contact'],_0x50bee9[_0x56c531][_0x8fee('0x5a')]));}Promise[_0x8fee('0x63')](_0x2b76fd)[_0x8fee('0x1b')](function(){_0x585c0c(0x1);});})[_0x8fee('0x1b')](function(){return{'success':_0x252154,'failure':_0x352190,'duplicates':_0x48b8fa};});}else{return{'success':_0x252154,'failure':_0x352190,'duplicates':_0x48b8fa};}}})[_0x8fee('0x1b')](respondWithResult(_0x18fb55,0xc9))['catch'](handleError(_0x18fb55,null));};exports[_0x8fee('0x64')]=function(_0x5b2895,_0x3715c6){var _0x169475;return db[_0x8fee('0x27')][_0x8fee('0x23')]()[_0x8fee('0x1b')](function(_0x88b638){return db['CmContact'][_0x8fee('0x28')]({'where':{'id':_0x5b2895[_0x8fee('0x65')]['id']},'include':[{'model':db[_0x8fee('0x66')],'as':_0x8fee('0x67'),'attributes':['id','name',_0x8fee('0x68')],'required':_0x5b2895[_0x8fee('0x24')][_0x8fee('0x69')]?!![]:![]},{'model':db[_0x8fee('0x4b')],'as':_0x8fee('0x6a'),'where':{'CmContactId':_0x5b2895[_0x8fee('0x65')]['id']},'required':![],'include':[{'model':db[_0x8fee('0x6b')],'as':_0x8fee('0x6c')}]}],'order':[db[_0x8fee('0x6d')][_0x8fee('0x6e')](_0x8fee('0x6f'))],'attributes':_[_0x8fee('0x2b')](_0x88b638)});})['then'](function(_0xb5346d){if(!_[_0x8fee('0x57')](_0xb5346d)){_0x169475=_0xb5346d[_0x8fee('0x38')]({'plain':!![]});var _0x4107e9={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0xb5346d&&_0xb5346d[_0x8fee('0x61')]){if(_0xb5346d[_0x8fee('0x61')]){_0x4107e9[_0x8fee('0x5e')][_0x8fee('0x70')][_0x8fee('0x60')]({'ListId':{'$ne':_0xb5346d['ListId']}});}}return db[_0x8fee('0x71')][_0x8fee('0x31')](_0x4107e9);}})[_0x8fee('0x1b')](function(_0x549e01){if(!_[_0x8fee('0x57')](_0x549e01)){return _[_0x8fee('0x72')](_0x169475,_['map'](_0x549e01,function(_0x5895af){return util[_0x8fee('0x73')](_0x8fee('0x74'),_0x5895af['id']);}));}})[_0x8fee('0x1b')](handleEntityNotFound(_0x3715c6,null))[_0x8fee('0x1b')](respondWithResult(_0x3715c6,null))['catch'](handleError(_0x3715c6,null));};exports[_0x8fee('0x43')]=function(_0x14271c,_0x1127be){var _0x4dba75;if(_0x14271c[_0x8fee('0x36')]['id']){delete _0x14271c[_0x8fee('0x36')]['id'];}if(!_[_0x8fee('0x57')](_0x14271c[_0x8fee('0x36')]['dialTimezone'])){var _0x170e7c=_0x14271c['body']['dialTimezone'];if(!_[_0x8fee('0x57')](shared[_0x8fee('0x58')][_0x170e7c]))_0x14271c[_0x8fee('0x36')][_0x8fee('0x59')]=shared[_0x8fee('0x58')][_0x170e7c][_0x8fee('0x59')];}return db[_0x8fee('0x27')][_0x8fee('0x28')]({'where':{'id':_0x14271c['params']['id']}})[_0x8fee('0x1b')](handleEntityNotFound(_0x1127be,null))[_0x8fee('0x1b')](saveUpdates(_0x14271c[_0x8fee('0x36')],null))[_0x8fee('0x1b')](function(_0x71956c){_0x4dba75=_0x71956c;var _0x2671fc={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x71956c&&_0x71956c[_0x8fee('0x61')]){if(_0x71956c[_0x8fee('0x61')]){_0x2671fc[_0x8fee('0x5e')]['$and'][_0x8fee('0x60')]({'ListId':{'$ne':_0x71956c[_0x8fee('0x61')]}});}}return db[_0x8fee('0x71')][_0x8fee('0x31')](_0x2671fc);})['then'](function(_0x19390e){if(_0x19390e){return _[_0x8fee('0x72')](_[_0x8fee('0x75')](_0x14271c['body'],function(_0x15442d,_0x3c2633){return _[_0x8fee('0x2c')](_0x3c2633,_0x8fee('0x2d'));}),_[_0x8fee('0x76')](_0x19390e,function(_0x244d48){return util[_0x8fee('0x73')](_0x8fee('0x74'),_0x244d48['id']);}));}})[_0x8fee('0x1b')](function(_0x31843f){if(_0x31843f&&!_[_0x8fee('0x77')](_0x31843f)){var _0x5885dc=squel[_0x8fee('0x43')]()[_0x8fee('0x78')](_0x8fee('0x79'))[_0x8fee('0x7a')](_0x31843f)[_0x8fee('0x5e')](_0x8fee('0x7b'),_0x14271c['params']['id'])[_0x8fee('0x7c')]();return db[_0x8fee('0x6d')][_0x8fee('0x24')](_0x5885dc[_0x8fee('0x7d')],{'replacements':_0x5885dc['values']});}})[_0x8fee('0x1b')](function(){if(_0x14271c[_0x8fee('0x36')][_0x8fee('0x7e')]&&_0x4dba75){return db[_0x8fee('0x3d')][_0x8fee('0x43')]({'phone':_0x14271c[_0x8fee('0x36')][_0x8fee('0x7e')],'OrderBy':0x0},{'where':{'ContactId':_0x4dba75['id']}});}})['then'](function(){return _0x4dba75;})[_0x8fee('0x1b')](respondWithResult(_0x1127be,null))[_0x8fee('0x26')](handleError(_0x1127be,null));};exports[_0x8fee('0x7f')]=function(_0x34c4dd,_0x510153){var _0x3cda57={};var _0xd3ad4c={};var _0x322372;var _0x31e524;return db[_0x8fee('0x27')][_0x8fee('0x80')]({'where':{'id':_0x34c4dd[_0x8fee('0x65')]['id']}})[_0x8fee('0x1b')](handleEntityNotFound(_0x510153,null))[_0x8fee('0x1b')](function(_0x56dc2e){if(_0x56dc2e){_0x322372=_0x56dc2e;_0xd3ad4c['model']=_[_0x8fee('0x2b')](db['Tag'][_0x8fee('0x81')]);_0xd3ad4c[_0x8fee('0x24')]=_[_0x8fee('0x2b')](_0x34c4dd['query']);_0xd3ad4c['filters']=_[_0x8fee('0x82')](_0xd3ad4c[_0x8fee('0x83')],_0xd3ad4c[_0x8fee('0x24')]);_0x3cda57[_0x8fee('0x84')]=_[_0x8fee('0x82')](_0xd3ad4c[_0x8fee('0x83')],qs[_0x8fee('0x85')](_0x34c4dd[_0x8fee('0x24')][_0x8fee('0x85')]));_0x3cda57['attributes']=_0x3cda57[_0x8fee('0x84')][_0x8fee('0x2a')]?_0x3cda57[_0x8fee('0x84')]:_0xd3ad4c[_0x8fee('0x83')];_0x3cda57['order']=qs[_0x8fee('0x86')](_0x34c4dd[_0x8fee('0x24')][_0x8fee('0x86')]);_0x3cda57[_0x8fee('0x5e')]=qs['filters'](_[_0x8fee('0x87')](_0x34c4dd[_0x8fee('0x24')],_0xd3ad4c[_0x8fee('0x88')]));if(_0x34c4dd['query']['filter']){_0x3cda57[_0x8fee('0x5e')]=_['merge'](_0x3cda57['where'],{'$or':_['map'](_0x3cda57[_0x8fee('0x84')],function(_0x28ef94){var _0x31988a={};_0x31988a[_0x28ef94]={'$like':'%'+_0x34c4dd['query'][_0x8fee('0x89')]+'%'};return _0x31988a;})});}_0x3cda57=_['merge']({},_0x3cda57,_0x34c4dd[_0x8fee('0x8a')]);return _0x322372['getTags'](_0x3cda57);}})[_0x8fee('0x1b')](function(_0x16a3dd){if(_0x16a3dd){_0x31e524=_0x16a3dd['length'];if(!_0x34c4dd['query']['hasOwnProperty'](_0x8fee('0x8b'))){_0x3cda57[_0x8fee('0x16')]=qs[_0x8fee('0x16')](_0x34c4dd[_0x8fee('0x24')][_0x8fee('0x16')]);_0x3cda57[_0x8fee('0x15')]=qs[_0x8fee('0x15')](_0x34c4dd['query'][_0x8fee('0x15')]);}return _0x322372[_0x8fee('0x7f')](_0x3cda57);}})[_0x8fee('0x1b')](function(_0x39e44e){if(_0x39e44e){return _0x39e44e?{'count':_0x31e524,'rows':_0x39e44e}:null;}})['then'](respondWithResult(_0x510153,null))[_0x8fee('0x26')](handleError(_0x510153,null));};exports['setTags']=function(_0x551e82,_0x2617a7){if(_0x551e82[_0x8fee('0x36')]['id']){delete _0x551e82[_0x8fee('0x36')]['id'];}return db['CmContact'][_0x8fee('0x80')]({'where':{'id':_0x551e82[_0x8fee('0x65')]['id']}})[_0x8fee('0x1b')](handleEntityNotFound(_0x2617a7,null))[_0x8fee('0x1b')](function(_0x57da26){if(_0x57da26){return _0x57da26['setTags'](_0x551e82[_0x8fee('0x36')][_0x8fee('0x8c')]||[]);}return null;})['then'](respondWithResult(_0x2617a7,null))['catch'](handleError(_0x2617a7,null));};exports[_0x8fee('0x8d')]=function(_0x4f3205,_0x35beb0){var _0x413829=[];_0x413829[_0x8fee('0x60')](addAdditionalPhones(_0x4f3205['body']));Promise['all'](_0x413829)['then'](function(){_0x413829=[];_0x413829[_0x8fee('0x60')](deleteCmHopperPhones(_0x4f3205['body']['id']));_0x413829[_0x8fee('0x60')](addCmHopperPhones(_0x4f3205[_0x8fee('0x36')]['id']));Promise[_0x8fee('0x63')](_0x413829)['then'](function(){return[0x1];})[_0x8fee('0x1b')](respondWithResult(_0x35beb0,null));});};function addAdditionalPhones(_0x5eada8){var _0xf90d98;return new Promise(function(_0xe6220a){return db[_0x8fee('0x4b')][_0x8fee('0x1c')]({'where':{'CmContactId':_0x5eada8['id']}})[_0x8fee('0x1b')](function(){db[_0x8fee('0x6b')][_0x8fee('0x31')]({'raw':!![],'attributes':['id',_0x8fee('0x8e')]})[_0x8fee('0x1b')](function(_0x45b615){var _0x3e0fee=[];for(var _0x46d75e=0x0;_0x46d75e<_0x5eada8[_0x8fee('0x8f')][_0x8fee('0x2a')];_0x46d75e++){var _0x469f1d=_0x5eada8['item_types']?_['isNil'](_0x5eada8[_0x8fee('0x90')][_0x46d75e])?'':_0x5eada8[_0x8fee('0x90')][_0x46d75e]:_0x5eada8[_0x8fee('0x8f')][_0x46d75e][_0x8fee('0x91')]?_0x5eada8[_0x8fee('0x8f')][_0x46d75e][_0x8fee('0x91')]:'';var _0x3e2b35=_['isNil'](_0x5eada8[_0x8fee('0x8f')][_0x46d75e][_0x8fee('0x92')])?'':_0x5eada8['items'][_0x46d75e][_0x8fee('0x92')];var _0x369978=_0x469f1d+':'+_0x5eada8[_0x8fee('0x8f')][_0x46d75e][_0x8fee('0x7e')]+'§'+_0x3e2b35;if(_[_0x8fee('0x57')](_0xf90d98))_0xf90d98=_0x369978;else _0xf90d98+=';'+_0x369978;var _0x281dcb=null;var _0x377c31=null;if(_0x5eada8[_0x8fee('0x90')]){if(!_[_0x8fee('0x57')](_0x5eada8[_0x8fee('0x90')][_0x46d75e])){_0x377c31=_['find'](_0x45b615,function(_0x15ebe6){return _0x15ebe6['id']===_0x5eada8[_0x8fee('0x90')][_0x46d75e];});if(!_[_0x8fee('0x57')](_0x377c31)){_0x281dcb=_0x377c31[_0x8fee('0x8e')];}}}else{if(!_[_0x8fee('0x57')](_0x5eada8[_0x8fee('0x8f')][_0x46d75e])){_0x377c31=_['find'](_0x45b615,function(_0x448cc2){return _0x448cc2['id']===_0x5eada8[_0x8fee('0x8f')][_0x46d75e][_0x8fee('0x91')];});if(!_[_0x8fee('0x57')](_0x377c31)){_0x281dcb=_0x46d75e;}}}if(_['isNil'](_0x281dcb)){_0x281dcb=0x64;}_0x3e0fee[_0x8fee('0x60')](addAdditionalPhone(_0x5eada8['id'],_0x5eada8[_0x8fee('0x8f')][_0x46d75e][_0x8fee('0x7e')],_0x5eada8[_0x8fee('0x90')]?_[_0x8fee('0x57')](_0x5eada8[_0x8fee('0x90')][_0x46d75e])?null:_0x5eada8[_0x8fee('0x90')][_0x46d75e]:_0x5eada8['items'][_0x46d75e][_0x8fee('0x91')]?_0x5eada8[_0x8fee('0x8f')][_0x46d75e][_0x8fee('0x91')]:null,_0x281dcb,_0x3e2b35));}Promise[_0x8fee('0x63')](_0x3e0fee)[_0x8fee('0x1b')](function(){db['CmContact']['update']({'AdditionalPhones':_0xf90d98},{'where':{'id':_0x5eada8['id']}})[_0x8fee('0x1b')](function(){_0xe6220a(0x1);});});});});});}function addAdditionalPhone(_0x2d24ae,_0x3788a6,_0x173eae,_0x5773dd,_0x2c011a){return db[_0x8fee('0x4b')][_0x8fee('0x28')]({'where':{'CmContactId':_0x2d24ae,'item':_0x3788a6}})[_0x8fee('0x1b')](function(_0x4b9752){if(_0x4b9752)logger[_0x8fee('0x3e')](_0x8fee('0x93'),_0x4b9752);else{db[_0x8fee('0x4b')]['create']({'CmContactId':_0x2d24ae,'item':_0x3788a6,'ItemTypeId':_0x173eae,'OrderBy':_0x5773dd,'ItemClass':'PHONE','description':_0x2c011a});}});}function deleteCmHopperPhones(_0x6a9a5a){return new Promise(function(_0x3cd0a6){return db[_0x8fee('0x3d')]['findAll']({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x6a9a5a}})[_0x8fee('0x1b')](function(_0x1e582c){db[_0x8fee('0x94')][_0x8fee('0x1c')]({'where':{'CmHopperId':{'$in':_[_0x8fee('0x76')](_0x1e582c,'id')}}});})[_0x8fee('0x1b')](function(){_0x3cd0a6(0x1);});});}function addCmHopperPhones(_0x24aff9){return new Promise(function(_0xa9efa7){return db[_0x8fee('0x3d')]['findAll']({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x24aff9}})[_0x8fee('0x1b')](function(_0x2e4d4b){var _0x3868df=[];_['map'](_0x2e4d4b,function(_0x30840f){_0x3868df[_0x8fee('0x60')](createCmHopperPhone(_0x24aff9,_0x30840f['id']));});Promise[_0x8fee('0x63')](_0x3868df)['then'](function(){_0xa9efa7(0x1);});});});}function createCmHopperPhone(_0x2f1633,_0x386df5){return new Promise(function(_0x3def64){db[_0x8fee('0x4b')]['findAll']({'raw':!![],'attributes':['item',_0x8fee('0x8e')],'where':{'CmContactId':_0x2f1633,'ItemClass':_0x8fee('0x95')},'include':[{'model':db[_0x8fee('0x6b')],'attributes':[_0x8fee('0x8e')],'as':_0x8fee('0x6c')}],'order':[_0x8fee('0x8e'),db[_0x8fee('0x6d')]['literal']('`ItemType`.OrderBy')]})[_0x8fee('0x1b')](function(_0x3501e6){var _0x5458d0=0x1;var _0x4432ee=_['map'](_0x3501e6,function(_0x29e096){_0x29e096[_0x8fee('0x96')]=_0x386df5;_0x29e096[_0x8fee('0x7e')]=_0x29e096[_0x8fee('0x97')];_0x29e096[_0x8fee('0x8e')]=_0x5458d0;delete _0x29e096[_0x8fee('0x98')];_0x5458d0=_0x5458d0+0x1;return _0x29e096;});return db[_0x8fee('0x94')][_0x8fee('0x5b')](_0x4432ee,{});})[_0x8fee('0x1b')](function(){_0x3def64(0x1);});});}function insertAdditionalPhones(_0x406cca,_0x83eda3){return new Promise(function(_0x2508f7){var _0x14c446=[];for(var _0x5a604b=0x0;_0x5a604b<_0x83eda3[_0x8fee('0x2a')];_0x5a604b++){var _0x5c3899=_0x83eda3[_0x5a604b];_0x14c446[_0x8fee('0x60')](parseContactItemType(_0x5c3899));}Promise[_0x8fee('0x63')](_0x14c446)[_0x8fee('0x1b')](function(){var _0x324a90={'id':_0x406cca['id'],'items':_0x83eda3};return addAdditionalPhones(_0x324a90)['then'](function(){return addCmHopperPhones(_0x406cca['id']);});})['then'](function(){_0x2508f7(_0x406cca);});});}function parseContactItemType(_0x6a5874){return new Promise(function(_0x5a2559){if(_0x6a5874['hasOwnProperty'](_0x8fee('0x91'))){_0x5a2559(_0x6a5874);}else{return db[_0x8fee('0x6b')][_0x8fee('0x28')]({'where':{'name':_0x6a5874['ItemType']}})[_0x8fee('0x1b')](function(_0x3d6c11){if(_['isNil'](_0x3d6c11))_0x6a5874[_0x8fee('0x91')]=null;else _0x6a5874[_0x8fee('0x91')]=_0x3d6c11['id'];_0x5a2559(_0x6a5874);});}});}exports[_0x8fee('0x99')]=function(_0x3a4890,_0x4dcd14){return db[_0x8fee('0x4b')][_0x8fee('0x31')]({'raw':!![],'where':{'CmContactId':_0x3a4890[_0x8fee('0x65')]['id'],'ItemClass':'PHONE'},'include':[{'model':db[_0x8fee('0x6b')],'as':'ItemType'}],'order':[['OrderBy'],[db[_0x8fee('0x6d')]['literal'](_0x8fee('0x9a'))]]})['then'](function(_0x297f9b){return _0x297f9b;})[_0x8fee('0x1b')](respondWithResult(_0x4dcd14,null))[_0x8fee('0x26')](handleError(_0x4dcd14,null));};exports[_0x8fee('0x9b')]=function(_0x1b7887,_0x44f71f){return db['CmContactHasItem'][_0x8fee('0x31')]({'raw':!![],'where':{'CmContactId':_0x1b7887[_0x8fee('0x36')][_0x8fee('0x9c')]}})[_0x8fee('0x1b')](function(_0x1a46ad){var _0x1a5ff0=_[_0x8fee('0x76')](_0x1a46ad,function(_0x507ec8){_0x507ec8[_0x8fee('0x9d')]=_0x1b7887[_0x8fee('0x36')][_0x8fee('0x9e')];return _0x507ec8;});return db[_0x8fee('0x4b')][_0x8fee('0x5b')](_0x1a5ff0,{});})['then'](function(){return addCmHopperPhones(_0x1b7887[_0x8fee('0x36')][_0x8fee('0x9e')]);})[_0x8fee('0x1b')](function(){return['ok'];})[_0x8fee('0x1b')](respondWithResult(_0x44f71f,null))[_0x8fee('0x26')](handleError(_0x44f71f,null));};exports['rescheduleAdditionalPhones']=function(_0xd9c37d,_0x5ac64e){var _0x1fa767=[];_0x1fa767[_0x8fee('0x60')](createCmHopperPhone(_0xd9c37d[_0x8fee('0x36')]['id'],_0xd9c37d[_0x8fee('0x36')]['hopperId']));Promise[_0x8fee('0x63')](_0x1fa767)['then'](function(){return[0x1];})[_0x8fee('0x1b')](respondWithResult(_0x5ac64e,null));};exports['getHoppers']=function(_0x1c4f1d,_0x2db1ab){var _0x3a5457={'raw':![],'where':{}};var _0x31fa6a={};var _0x2108c2={'count':0x0,'rows':[]};return db[_0x8fee('0x27')][_0x8fee('0x80')]({'where':{'id':_0x1c4f1d[_0x8fee('0x65')]['id']}})[_0x8fee('0x1b')](handleEntityNotFound(_0x2db1ab,null))[_0x8fee('0x1b')](function(_0x3622f5){if(_0x3622f5){_0x31fa6a[_0x8fee('0x83')]=_['keys'](db['CmHopper'][_0x8fee('0x81')]);_0x31fa6a[_0x8fee('0x24')]=_['keys'](_0x1c4f1d[_0x8fee('0x24')]);_0x31fa6a['filters']=_[_0x8fee('0x82')](_0x31fa6a[_0x8fee('0x83')],_0x31fa6a[_0x8fee('0x24')]);_0x3a5457[_0x8fee('0x84')]=_[_0x8fee('0x82')](_0x31fa6a[_0x8fee('0x83')],qs[_0x8fee('0x85')](_0x1c4f1d[_0x8fee('0x24')][_0x8fee('0x85')]));_0x3a5457[_0x8fee('0x84')]=_0x3a5457[_0x8fee('0x84')][_0x8fee('0x2a')]?_0x3a5457['attributes']:_0x31fa6a[_0x8fee('0x83')];if(!_0x1c4f1d['query']['hasOwnProperty'](_0x8fee('0x8b'))){_0x3a5457[_0x8fee('0x16')]=qs[_0x8fee('0x16')](_0x1c4f1d[_0x8fee('0x24')]['limit']);_0x3a5457[_0x8fee('0x15')]=qs['offset'](_0x1c4f1d['query'][_0x8fee('0x15')]);}_0x3a5457[_0x8fee('0x9f')]=qs[_0x8fee('0x86')](_0x1c4f1d[_0x8fee('0x24')]['sort']);_0x3a5457[_0x8fee('0x5e')]=qs['filters'](_[_0x8fee('0x87')](_0x1c4f1d[_0x8fee('0x24')],_0x31fa6a[_0x8fee('0x88')]));_0x3a5457['where'][_0x8fee('0xa0')]=_0x3622f5['id'];if(_0x1c4f1d[_0x8fee('0x24')][_0x8fee('0x89')]){_0x3a5457[_0x8fee('0x5e')]=_['merge'](_0x3a5457[_0x8fee('0x5e')],{'$or':_['map'](_0x3a5457[_0x8fee('0x84')],function(_0x562c03){var _0x1a5ec4={};_0x1a5ec4[_0x562c03]={'$like':'%'+_0x1c4f1d[_0x8fee('0x24')]['filter']+'%'};return _0x1a5ec4;})});}_0x3a5457=_[_0x8fee('0xa1')]({},_0x3a5457,_0x1c4f1d[_0x8fee('0x8a')]);return db[_0x8fee('0x3d')][_0x8fee('0x18')]({'where':_0x3a5457[_0x8fee('0x5e')]})['then'](function(_0x2cbe84){_0x2108c2[_0x8fee('0x18')]=_0x2cbe84;if(_0x1c4f1d[_0x8fee('0x24')]['includeAll']){_0x3a5457[_0x8fee('0xa2')]=[{'all':!![]}];}return db[_0x8fee('0x3d')][_0x8fee('0x31')](_0x3a5457);})[_0x8fee('0x1b')](function(_0x37230d){_0x2108c2[_0x8fee('0xa3')]=_0x37230d;return _0x2108c2;});}})[_0x8fee('0x1b')](respondWithFilteredResult(_0x2db1ab,_0x3a5457))[_0x8fee('0x26')](handleError(_0x2db1ab,null));};exports[_0x8fee('0xa4')]=function(_0x4414cd,_0x1b570c){var _0x20a2fc={'raw':!![],'where':{}};var _0x4e1b8f={};var _0x2a6ea7={'count':0x0,'rows':[]};return db[_0x8fee('0x27')][_0x8fee('0x80')]({'where':{'id':_0x4414cd[_0x8fee('0x65')]['id']}})[_0x8fee('0x1b')](handleEntityNotFound(_0x1b570c,null))[_0x8fee('0x1b')](function(_0x5d0092){if(_0x5d0092){_0x4e1b8f[_0x8fee('0x83')]=_[_0x8fee('0x2b')](db[_0x8fee('0x4d')][_0x8fee('0x81')]);_0x4e1b8f[_0x8fee('0x24')]=_[_0x8fee('0x2b')](_0x4414cd[_0x8fee('0x24')]);_0x4e1b8f[_0x8fee('0x88')]=_[_0x8fee('0x82')](_0x4e1b8f[_0x8fee('0x83')],_0x4e1b8f[_0x8fee('0x24')]);_0x20a2fc[_0x8fee('0x84')]=_[_0x8fee('0x82')](_0x4e1b8f[_0x8fee('0x83')],qs[_0x8fee('0x85')](_0x4414cd[_0x8fee('0x24')][_0x8fee('0x85')]));_0x20a2fc[_0x8fee('0x84')]=_0x20a2fc[_0x8fee('0x84')][_0x8fee('0x2a')]?_0x20a2fc[_0x8fee('0x84')]:_0x4e1b8f[_0x8fee('0x83')];if(!_0x4414cd[_0x8fee('0x24')]['hasOwnProperty'](_0x8fee('0x8b'))){_0x20a2fc[_0x8fee('0x16')]=qs['limit'](_0x4414cd[_0x8fee('0x24')]['limit']);_0x20a2fc[_0x8fee('0x15')]=qs['offset'](_0x4414cd[_0x8fee('0x24')][_0x8fee('0x15')]);}_0x20a2fc['order']=qs['sort'](_0x4414cd['query']['sort']);_0x20a2fc['where']=qs[_0x8fee('0x88')](_[_0x8fee('0x87')](_0x4414cd[_0x8fee('0x24')],_0x4e1b8f['filters']));_0x20a2fc[_0x8fee('0x5e')][_0x8fee('0xa0')]=_0x5d0092['id'];if(_0x4414cd[_0x8fee('0x24')][_0x8fee('0x89')]){_0x20a2fc[_0x8fee('0x5e')]=_[_0x8fee('0xa1')](_0x20a2fc[_0x8fee('0x5e')],{'$or':_[_0x8fee('0x76')](_0x20a2fc[_0x8fee('0x84')],function(_0x3f76d0){var _0xf4aca8={};_0xf4aca8[_0x3f76d0]={'$like':'%'+_0x4414cd[_0x8fee('0x24')][_0x8fee('0x89')]+'%'};return _0xf4aca8;})});}_0x20a2fc=_[_0x8fee('0xa1')]({},_0x20a2fc,_0x4414cd[_0x8fee('0x8a')]);return db[_0x8fee('0x4d')]['count']({'where':_0x20a2fc[_0x8fee('0x5e')]})[_0x8fee('0x1b')](function(_0x242922){_0x2a6ea7[_0x8fee('0x18')]=_0x242922;if(_0x4414cd['query'][_0x8fee('0xa5')]){_0x20a2fc[_0x8fee('0xa2')]=[{'all':!![]}];}return db[_0x8fee('0x4d')][_0x8fee('0x31')](_0x20a2fc);})[_0x8fee('0x1b')](function(_0x35dbe3){_0x2a6ea7[_0x8fee('0xa3')]=_0x35dbe3;return _0x2a6ea7;});}})[_0x8fee('0x1b')](respondWithFilteredResult(_0x1b570c,_0x20a2fc))[_0x8fee('0x26')](handleError(_0x1b570c,null));};exports['getHopperFinals']=function(_0x4d7a27,_0x50e298){var _0x443cd9={'raw':!![],'where':{}};var _0x56627a={};var _0x446a68={'count':0x0,'rows':[]};return db[_0x8fee('0x27')]['findOne']({'where':{'id':_0x4d7a27[_0x8fee('0x65')]['id']}})['then'](handleEntityNotFound(_0x50e298,null))[_0x8fee('0x1b')](function(_0x4e0521){if(_0x4e0521){_0x56627a[_0x8fee('0x83')]=_['keys'](db[_0x8fee('0x4c')][_0x8fee('0x81')]);_0x56627a[_0x8fee('0x24')]=_[_0x8fee('0x2b')](_0x4d7a27[_0x8fee('0x24')]);_0x56627a[_0x8fee('0x88')]=_['intersection'](_0x56627a[_0x8fee('0x83')],_0x56627a[_0x8fee('0x24')]);_0x443cd9[_0x8fee('0x84')]=_['intersection'](_0x56627a[_0x8fee('0x83')],qs[_0x8fee('0x85')](_0x4d7a27[_0x8fee('0x24')][_0x8fee('0x85')]));_0x443cd9['attributes']=_0x443cd9[_0x8fee('0x84')]['length']?_0x443cd9[_0x8fee('0x84')]:_0x56627a['model'];if(!_0x4d7a27[_0x8fee('0x24')]['hasOwnProperty'](_0x8fee('0x8b'))){_0x443cd9['limit']=qs[_0x8fee('0x16')](_0x4d7a27[_0x8fee('0x24')]['limit']);_0x443cd9[_0x8fee('0x15')]=qs[_0x8fee('0x15')](_0x4d7a27['query'][_0x8fee('0x15')]);}_0x443cd9['order']=qs['sort'](_0x4d7a27[_0x8fee('0x24')][_0x8fee('0x86')]);_0x443cd9['where']=qs[_0x8fee('0x88')](_[_0x8fee('0x87')](_0x4d7a27[_0x8fee('0x24')],_0x56627a['filters']));_0x443cd9[_0x8fee('0x5e')][_0x8fee('0xa0')]=_0x4e0521['id'];if(_0x4d7a27[_0x8fee('0x24')]['filter']){_0x443cd9[_0x8fee('0x5e')]=_[_0x8fee('0xa1')](_0x443cd9['where'],{'$or':_[_0x8fee('0x76')](_0x443cd9['attributes'],function(_0x2b3fe0){var _0x361667={};_0x361667[_0x2b3fe0]={'$like':'%'+_0x4d7a27[_0x8fee('0x24')][_0x8fee('0x89')]+'%'};return _0x361667;})});}_0x443cd9=_[_0x8fee('0xa1')]({},_0x443cd9,_0x4d7a27['options']);return db[_0x8fee('0x4c')]['count']({'where':_0x443cd9['where']})[_0x8fee('0x1b')](function(_0x5f530e){_0x446a68['count']=_0x5f530e;if(_0x4d7a27['query'][_0x8fee('0xa5')]){_0x443cd9[_0x8fee('0xa2')]=[{'all':!![]}];}return db[_0x8fee('0x4c')][_0x8fee('0x31')](_0x443cd9);})[_0x8fee('0x1b')](function(_0x190159){_0x446a68[_0x8fee('0xa3')]=_0x190159;return _0x446a68;});}})[_0x8fee('0x1b')](respondWithFilteredResult(_0x50e298,_0x443cd9))['catch'](handleError(_0x50e298,null));};exports[_0x8fee('0xa6')]=function(_0x322772,_0x12b226){var _0x2677b9={'raw':!![],'where':{}};var _0x530164={};var _0x13260f={'count':0x0,'rows':[]};return db[_0x8fee('0x27')][_0x8fee('0x80')]({'where':{'id':_0x322772[_0x8fee('0x65')]['id']}})[_0x8fee('0x1b')](handleEntityNotFound(_0x12b226,null))[_0x8fee('0x1b')](function(_0x20fde3){if(_0x20fde3){_0x530164[_0x8fee('0x83')]=_[_0x8fee('0x2b')](db['JscriptySessionReport'][_0x8fee('0x81')]);_0x530164[_0x8fee('0x24')]=_[_0x8fee('0x2b')](_0x322772[_0x8fee('0x24')]);_0x530164[_0x8fee('0x88')]=_[_0x8fee('0x82')](_0x530164['model'],_0x530164[_0x8fee('0x24')]);_0x2677b9[_0x8fee('0x84')]=_[_0x8fee('0x82')](_0x530164[_0x8fee('0x83')],qs[_0x8fee('0x85')](_0x322772[_0x8fee('0x24')]['fields']));_0x2677b9['attributes']=_0x2677b9[_0x8fee('0x84')]['length']?_0x2677b9[_0x8fee('0x84')]:_0x530164[_0x8fee('0x83')];if(!_0x322772['query'][_0x8fee('0x35')](_0x8fee('0x8b'))){_0x2677b9[_0x8fee('0x16')]=qs[_0x8fee('0x16')](_0x322772[_0x8fee('0x24')][_0x8fee('0x16')]);_0x2677b9[_0x8fee('0x15')]=qs[_0x8fee('0x15')](_0x322772['query']['offset']);}_0x2677b9['order']=qs[_0x8fee('0x86')](_0x322772[_0x8fee('0x24')][_0x8fee('0x86')]);_0x2677b9[_0x8fee('0x5e')]=qs[_0x8fee('0x88')](_['pick'](_0x322772['query'],_0x530164['filters']));_0x2677b9[_0x8fee('0x5e')]['ContactId']=_0x20fde3['id'];if(_0x322772['query'][_0x8fee('0x89')]){_0x2677b9['where']=_[_0x8fee('0xa1')](_0x2677b9[_0x8fee('0x5e')],{'$or':_['map'](_0x2677b9[_0x8fee('0x84')],function(_0x41888c){var _0x1a3eec={};_0x1a3eec[_0x41888c]={'$like':'%'+_0x322772[_0x8fee('0x24')][_0x8fee('0x89')]+'%'};return _0x1a3eec;})});}_0x2677b9=_[_0x8fee('0xa1')]({},_0x2677b9,_0x322772[_0x8fee('0x8a')]);return db[_0x8fee('0x52')][_0x8fee('0x18')]({'where':_0x2677b9[_0x8fee('0x5e')]})['then'](function(_0x1d46bc){_0x13260f[_0x8fee('0x18')]=_0x1d46bc;if(_0x322772[_0x8fee('0x24')][_0x8fee('0xa5')]){_0x2677b9['include']=[{'all':!![]}];}return db[_0x8fee('0x52')][_0x8fee('0x31')](_0x2677b9);})[_0x8fee('0x1b')](function(_0x2f2dad){_0x13260f['rows']=_0x2f2dad;return _0x13260f;});}})['then'](respondWithFilteredResult(_0x12b226,_0x2677b9))[_0x8fee('0x26')](handleError(_0x12b226,null));};exports[_0x8fee('0xa7')]=function(_0x59699c,_0x4f0fb9){try{if(!_0x59699c[_0x8fee('0x36')][_0x8fee('0x61')]){throw new Error(_0x8fee('0xa8'));}if(!_0x59699c[_0x8fee('0x36')]['binding_keys']){throw new Error(_0x8fee('0xa9'));}if(!_0x59699c[_0x8fee('0x36')][_0x8fee('0xaa')]){throw new Error(_0x8fee('0xab'));}if(!_0x59699c[_0x8fee('0x36')]['socket_timestamp']){throw new Error(_0x8fee('0xac'));}var _0x36043c=_0x59699c[_0x8fee('0x36')]['binding_keys']['split'](',');var _0x3fdd00=_0x59699c[_0x8fee('0x36')][_0x8fee('0xaa')]['split'](',');if(!_0x36043c[_0x8fee('0x2a')]||!_0x3fdd00[_0x8fee('0x2a')]||_0x36043c[_0x8fee('0x2a')]!==_0x3fdd00[_0x8fee('0x2a')]){throw new Error(_0x8fee('0xad'));}_0x59699c[_0x8fee('0x36')][_0x8fee('0x85')]=_[_0x8fee('0xae')](_0x36043c,_0x3fdd00);if(!_0x59699c[_0x8fee('0x36')][_0x8fee('0x85')][_0x8fee('0x7e')]){throw new Error(_0x8fee('0xaf'));}if(!_0x59699c[_0x8fee('0x36')][_0x8fee('0x85')][_0x8fee('0xb0')]){throw new Error(_0x8fee('0xb1'));}var _0x5e8f22=path[_0x8fee('0x3b')](config[_0x8fee('0xb2')],_0x8fee('0xb3'),_0x59699c['file']['filename']);fs[_0x8fee('0xb4')](_0x5e8f22,parseInt(_0x8fee('0xb5'),0x8));var _0x3eebb8=require(_0x8fee('0xb6'))['fork'](path[_0x8fee('0x3b')](__dirname,_0x8fee('0xb7')),[_0x5e8f22,_0x59699c[_0x8fee('0x36')][_0x8fee('0xb8')],_0x59699c[_0x8fee('0x36')]['binding_values'],_0x59699c[_0x8fee('0x36')]['ListId'],_0x59699c[_0x8fee('0x36')]['CompanyId'],_0x59699c[_0x8fee('0x36')]['duplicates'],_0x59699c[_0x8fee('0x36')][_0x8fee('0xb9')]]);return _0x4f0fb9[_0x8fee('0x13')](0xc8)['json']({'message':_0x8fee('0xba'),'pid':_0x3eebb8[_0x8fee('0xbb')]});}catch(_0x2a231d){return _0x4f0fb9['status'](0x1f4)[_0x8fee('0x21')](_0x2a231d);}};exports[_0x8fee('0xbc')]=function(_0x30b005,_0x371ca2){var _0x30b057=fs[_0x8fee('0xbd')](_0x30b005[_0x8fee('0xbe')][_0x8fee('0x2')]);Papa[_0x8fee('0xbf')](_0x30b057,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x1502ca){return _0x371ca2[_0x8fee('0x13')](0xc8)['json']({'file':_0x30b005['file'],'fields':_0x1502ca[_0x8fee('0xc0')][_0x8fee('0x85')]});}});};exports[_0x8fee('0xc1')]=function(_0x3b8c7f,_0x174886){return db[_0x8fee('0xc2')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0x8fee('0xc3')}})[_0x8fee('0x1b')](function(_0x3ca8c2){var _0x21e3de=![];if(!_0x3b8c7f[_0x8fee('0x36')]['ListId']){throw new Error(_0x8fee('0xa8'));}if(!_0x3b8c7f[_0x8fee('0x36')][_0x8fee('0xc4')]['phone']){throw new Error(_0x8fee('0xaf'));}if(!_0x3b8c7f['body'][_0x8fee('0xc4')][_0x8fee('0xb0')]){throw new Error(_0x8fee('0xb1'));}if(!_0x3b8c7f[_0x8fee('0x36')][_0x8fee('0xb9')]){throw new Error(_0x8fee('0xac'));}var _0x45b52a=require('child_process')[_0x8fee('0xc5')](path[_0x8fee('0x3b')](__dirname,'../../components/import/cm/csv2'),[_0x3b8c7f[_0x8fee('0x65')]['id'],JSON[_0x8fee('0xc6')](_0x3b8c7f[_0x8fee('0x36')]),JSON[_0x8fee('0xc6')](_0x3ca8c2)]);_0x45b52a['on'](_0x8fee('0xc7'),function(){_0x21e3de=!![];return _0x174886[_0x8fee('0x13')](0xc8)[_0x8fee('0x14')]({'message':'start\x20child\x20process\x20correctly!','pid':_0x45b52a[_0x8fee('0xbb')]});});_0x45b52a['on'](_0x8fee('0xc8'),function(_0x57a15c){if(_0x57a15c&&!_0x21e3de){return _0x174886[_0x8fee('0x13')](0x1f4)['json']({'message':'error\x20child\x20process','pid':_0x45b52a[_0x8fee('0xbb')]});}});})['catch'](handleError(_0x174886,null));};exports['importUpdates']=function(_0x527e51,_0x396801){return db['User']['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0x8fee('0xc3')}})[_0x8fee('0x1b')](function(_0x2c3a8c){var _0xb808ce=![];if(!_0x527e51[_0x8fee('0x36')][_0x8fee('0x61')]){throw new Error(_0x8fee('0xa8'));}if(!_0x527e51['body'][_0x8fee('0xc4')][_0x8fee('0x7e')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x527e51[_0x8fee('0x36')][_0x8fee('0xc4')][_0x8fee('0xb0')]){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x527e51[_0x8fee('0x36')][_0x8fee('0xb9')]){throw new Error(_0x8fee('0xac'));}var _0x5e0c71=require(_0x8fee('0xb6'))[_0x8fee('0xc5')](path[_0x8fee('0x3b')](__dirname,'../../components/import/cm/csvUpdates'),[_0x527e51[_0x8fee('0x65')]['id'],JSON[_0x8fee('0xc6')](_0x527e51['body']),JSON['stringify'](_0x2c3a8c)]);_0x5e0c71['on'](_0x8fee('0xc7'),function(){_0xb808ce=!![];return _0x396801[_0x8fee('0x13')](0xc8)[_0x8fee('0x14')]({'message':_0x8fee('0xc9'),'pid':_0x5e0c71[_0x8fee('0xbb')]});});_0x5e0c71['on'](_0x8fee('0xc8'),function(_0x5d9baa){if(_0x5d9baa&&!_0xb808ce){return _0x396801['status'](0x1f4)['json']({'message':_0x8fee('0xca'),'pid':_0x5e0c71['pid']});}});})[_0x8fee('0x26')](handleError(_0x396801,null));};exports[_0x8fee('0xcb')]=function(_0x50bbb9,_0x47712a){var _0x2fe5a1=['mail',_0x8fee('0xcc'),_0x8fee('0xcd'),_0x8fee('0xce'),_0x8fee('0xcf'),_0x8fee('0xd0'),'voice'];var _0x3c00ff={'offset':0x0,'order':qs[_0x8fee('0x86')](_0x8fee('0xd1'))},_0x4fe9d2={'count':0x0,'rows':[]};Promise[_0x8fee('0xd2')]()[_0x8fee('0x1b')](function(){if(_0x50bbb9[_0x8fee('0x24')][_0x8fee('0xd3')]){if(!_[_0x8fee('0xd4')](_0x2fe5a1,_0x50bbb9[_0x8fee('0x24')][_0x8fee('0xd3')][_0x8fee('0xd5')]())){throw new Error('Invalid\x20channel');}_0x2fe5a1=[_0x50bbb9[_0x8fee('0x24')][_0x8fee('0xd3')][_0x8fee('0xd5')]()];}if(_0x50bbb9[_0x8fee('0x24')][_0x8fee('0xd6')]){try{var _0x503f35=JSON['parse'](_0x50bbb9['query'][_0x8fee('0xd6')]);if(!moment(_0x503f35[_0x8fee('0x37')])[_0x8fee('0xd7')]()){throw new Error('Invalid\x20date\x20for\x20range\x20from\x20filter');}if(!moment(_0x503f35['to'])['isValid']()){throw new Error(_0x8fee('0xd8'));}}catch(_0x559bc9){throw new Error(_0x8fee('0xd9'));}}if(!_0x50bbb9[_0x8fee('0x24')][_0x8fee('0x35')](_0x8fee('0x8b'))){_0x3c00ff[_0x8fee('0x16')]=qs[_0x8fee('0x16')](_0x50bbb9[_0x8fee('0x24')][_0x8fee('0x16')]||0xa);_0x3c00ff[_0x8fee('0x15')]=qs[_0x8fee('0x15')](_0x50bbb9[_0x8fee('0x24')][_0x8fee('0x15')]);}var _0x2d8c7e=_0x2fe5a1[_0x8fee('0x76')](function(_0x494e74){if(_0x494e74===_0x8fee('0xda')){var _0x4b995e={'attributes':['id',_0x8fee('0xdb'),_0x8fee('0xdc'),_0x8fee('0xdd'),_0x8fee('0xde'),_0x8fee('0xdf'),_0x8fee('0xe0'),_0x8fee('0xe1'),'duration',_0x8fee('0xe2'),_0x8fee('0xe3'),_0x8fee('0xe4'),_0x8fee('0xe5'),_0x8fee('0xe6'),_0x8fee('0xe7')],'where':{'ContactId':_0x50bbb9['params']['id']},'include':[{'model':db[_0x8fee('0xc2')],'as':_0x8fee('0xc2'),'attributes':['id',_0x8fee('0x20'),'fullname','alias']}],'order':[[_0x8fee('0xe3'),_0x8fee('0xe8')]]};if(_0x50bbb9[_0x8fee('0x24')][_0x8fee('0xd6')]){_0x4b995e[_0x8fee('0x5e')][_0x8fee('0xe3')]={'$gte':_0x503f35['from'],'$lte':_0x503f35['to']};}return db[_0x8fee('0xe9')]['findAndCountAll'](_0x4b995e)[_0x8fee('0x1b')](function(_0x48014b){_0x4fe9d2[_0x8fee('0x18')]+=_0x48014b[_0x8fee('0x18')];return _['map'](_0x48014b[_0x8fee('0xa3')],function(_0x5e0c0d){var _0x3225eb=_0x5e0c0d[_0x8fee('0x38')]({'plain':!![]});_0x3225eb['channel']=_0x494e74;if(_0x3225eb[_0x8fee('0xc2')]){_0x3225eb['User']={'id':_0x3225eb['User']['id'],'name':_0x3225eb[_0x8fee('0xc2')][_0x8fee('0x20')],'fullname':_0x3225eb[_0x8fee('0xc2')][_0x8fee('0xea')],'alias':_0x3225eb[_0x8fee('0xc2')][_0x8fee('0x32')]};}return _0x3225eb;});});}else{var _0x10003d=_['startCase'](_0x494e74)+(_0x494e74===_0x8fee('0xcc')?_0x8fee('0xeb'):'Account');var _0x44ddd2={'attributes':['id',_0x8fee('0xec'),_0x8fee('0xed'),_0x8fee('0xe3'),_0x8fee('0xe2'),_0x8fee('0xee'),_0x8fee('0xef'),_0x8fee('0xf0'),_0x8fee('0xe7'),_0x10003d+'Id'],'where':{'ContactId':_0x50bbb9[_0x8fee('0x65')]['id']},'include':[{'model':db[_0x10003d],'as':_0x8fee('0xf1'),'attributes':['id',_0x8fee('0x20'),_0x8fee('0xf2')]},{'model':db[_0x8fee('0xc2')],'as':'Owner','attributes':['id',_0x8fee('0x20'),_0x8fee('0xea')]},{'model':db[_0x8fee('0x66')],'as':'Tags','attributes':['id',_0x8fee('0x20'),_0x8fee('0x68')],'through':{'attributes':[]}}],'order':[['createdAt',_0x8fee('0xe8')]]};if(_0x50bbb9[_0x8fee('0x24')][_0x8fee('0xd6')]){_0x44ddd2[_0x8fee('0x5e')][_0x8fee('0xe3')]={'$gte':_0x503f35[_0x8fee('0x37')],'$lte':_0x503f35['to']};}switch(_0x494e74){case'chat':_0x44ddd2['attributes']['push'](_0x8fee('0xf3'),_0x8fee('0xf4'),_0x8fee('0xf5'),'deviceModel',_0x8fee('0xf6'),_0x8fee('0xf7'),_0x8fee('0xf8'),_0x8fee('0xf9'),_0x8fee('0xfa'));break;case _0x8fee('0xfb'):_0x44ddd2['attributes']['push'](_0x8fee('0xfc'),_0x8fee('0xfd'));break;case _0x8fee('0xce'):_0x44ddd2[_0x8fee('0x84')]['push'](_0x8fee('0xfe'),_0x8fee('0xff'));break;}return db[_[_0x8fee('0x100')](_0x494e74)+_0x8fee('0x101')][_0x8fee('0x102')](_0x44ddd2)['then'](function(_0x2f4b29){_0x4fe9d2['count']+=_0x2f4b29['count'];return _['map'](_0x2f4b29[_0x8fee('0xa3')],function(_0x333e28){var _0x1d80e5=_0x333e28[_0x8fee('0x38')]({'plain':!![]});_0x1d80e5[_0x8fee('0xd3')]=_0x494e74;if(_0x1d80e5[_0x8fee('0x103')]){_0x1d80e5[_0x8fee('0x103')]={'id':_0x1d80e5[_0x8fee('0x103')]['id'],'name':_0x1d80e5[_0x8fee('0x103')]['name'],'fullname':_0x1d80e5['Owner']['fullname']};}return _0x1d80e5;});});}});return Promise[_0x8fee('0x63')](_0x2d8c7e);})[_0x8fee('0x1b')](function(_0x435b5b){return _(_0x435b5b)['flatten']()[_0x8fee('0x104')](_0x8fee('0xe3'))[_0x8fee('0x105')]()[_0x8fee('0x106')]();})[_0x8fee('0x1b')](function(_0x4937d4){_0x4fe9d2['rows']=_0x3c00ff[_0x8fee('0x16')]?_0x4937d4[_0x8fee('0x107')](_0x3c00ff[_0x8fee('0x15')],_0x3c00ff[_0x8fee('0x15')]+_0x3c00ff['limit']):_0x4937d4;return _0x4fe9d2;})[_0x8fee('0x1b')](respondWithFilteredResult(_0x47712a,_0x3c00ff))['catch'](handleError(_0x47712a,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff