// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x544f=['custom','type','values','Custom\x20field\x20%s\x20not\x20found\x20on\x20cm_contacts\x20table','forEach','hasOwnProperty','merge','body','from','get','mergeWith','isArray','tags','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','OpenchannelInteraction','CmHopperFinal','CmHopperHistory','ReportAgentPreview','ChatQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','create','join','dialTimezone','isNil','timezones','utcOffset','additionalPhones','bulkCreate','duplicates','$or','push','where','ListId','findOrCreate','contact','all','Tag','Tags','color','tag','Phones','ContactItemType','ItemType','literal','Phones.OrderBy','$and','omit','map','format','cf_%d','pickBy','setFields','id\x20=\x20?','toParam','sequelize','text','phone','getTags','findOne','model','rawAttributes','attributes','intersection','fields','order','sort','filters','pick','filter','options','setTags','ids','CmContactHasItem','OrderBy','items','item_types','ItemTypeId','description','contact\x20phone\x20exists','CmHopperAdditionalPhone','item','PHONE','CmHopperId','ItemType.OrderBy','getAdditionalPhones','duplicateAdditionalPhones','fromContactId','toContactId','rescheduleAdditionalPhones','hopperId','getHoppers','nolimit','ContactId','includeAll','include','rows','getHopperHistories','getHopperFinals','getJscriptySessions','No\x20ListId\x20specified','binding_keys','binding_values','No\x20association\x20values\x20specified!','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','split','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','root','server/files/tmp','file','chmodSync','0777','child_process','fork','File\x20uploaded\x20correctly!','pid','send','upload','createReadStream','parse','meta','import','User','agent','binding','No\x20firstName\x20column\x20specified','../../components/import/cm/csv2','stringify','start\x20child\x20process\x20correctly!','exit','error\x20child\x20process','importUpdates','firstName','socket_timestamp','../../components/import/cm/csvUpdates','message','getJourney','mail','chat','sms','openchannel','fax','voice','-createdAt','resolve','channel','includes','toLowerCase','range','isValid','Invalid\x20date\x20for\x20range\x20to\x20filter','uniqueid','source','destination','starttime','endtime','duration','note','createdAt','userDisposition','fullname','alias','DESC','findAndCountAll','startCase','Website','Account','closed','closedAt','disposition','thirdDisposition','key','Owner','browserName','customerIp','customerPort','deviceModel','osName','ratingMessage','ratingValue','referer','subject','substatus','externalUrl','Interaction','flatten','reverse','value','moment','util','path','lodash','squel','papaparse','ioredis','../../components/contacts','../../components/parsers/qs','../../config/logger','api','../../config/environment','../../config/environment/shared','redis','defaults','socket.io-emitter','register','status','json','undefined','limit','count','offset','set','Content-Range','update','then','destroy','sendStatus','error','stack','name','index','describe','getOptions','findAll','query','CmContact','find','params','catch','keys','length','startsWith','cf_','columnName','displayName','analytics','CmCustomField'];(function(_0x3dd15e,_0x1f0015){var _0x231fd0=function(_0x4f680a){while(--_0x4f680a){_0x3dd15e['push'](_0x3dd15e['shift']());}};_0x231fd0(++_0x1f0015);}(_0x544f,0x1cd));var _0xf544=function(_0x46698a,_0x8de1e4){_0x46698a=_0x46698a-0x0;var _0x356db0=_0x544f[_0x46698a];return _0x356db0;};'use strict';var moment=require(_0xf544('0x0'));var BPromise=require('bluebird');var util=require(_0xf544('0x1'));var path=require(_0xf544('0x2'));var fs=require('fs');var _=require(_0xf544('0x3'));var squel=require(_0xf544('0x4'));var Papa=require(_0xf544('0x5'));var Redis=require(_0xf544('0x6'));var contacts=require(_0xf544('0x7'));var qs=require(_0xf544('0x8'));var logger=require(_0xf544('0x9'))(_0xf544('0xa'));var config=require(_0xf544('0xb'));var shared=require(_0xf544('0xc'));var db=require('../../mysqldb')['db'];config[_0xf544('0xd')]=_[_0xf544('0xe')](config[_0xf544('0xd')],{'host':'localhost','port':0x18eb});var socket=require(_0xf544('0xf'))(new Redis(config[_0xf544('0xd')]));require('./cmContact.socket')[_0xf544('0x10')](socket);function respondWithResult(_0x3c2f00,_0x38df05){_0x38df05=_0x38df05||0xc8;return function(_0x11cbf7){if(_0x11cbf7){return _0x3c2f00[_0xf544('0x11')](_0x38df05)[_0xf544('0x12')](_0x11cbf7);}};}function respondWithFilteredResult(_0x265a80,_0xb96a0f){return function(_0x138ad6){if(_0x138ad6){var _0x241ca8=typeof _0xb96a0f['offset']===_0xf544('0x13')&&typeof _0xb96a0f[_0xf544('0x14')]==='undefined';var _0x4fb7cd=_0x138ad6[_0xf544('0x15')];var _0x3c7e94=_0x241ca8?0x0:_0xb96a0f[_0xf544('0x16')];var _0x55b37a=_0x241ca8?_0x138ad6[_0xf544('0x15')]:_0xb96a0f[_0xf544('0x16')]+_0xb96a0f[_0xf544('0x14')];var _0x4266c7;if(_0x55b37a>=_0x4fb7cd){_0x55b37a=_0x4fb7cd;_0x4266c7=0xc8;}else{_0x4266c7=0xce;}_0x265a80[_0xf544('0x11')](_0x4266c7);return _0x265a80[_0xf544('0x17')](_0xf544('0x18'),_0x3c7e94+'-'+_0x55b37a+'/'+_0x4fb7cd)[_0xf544('0x12')](_0x138ad6);}return null;};}function saveUpdates(_0x43a93a){return function(_0x2c6ac6){if(_0x2c6ac6){return _0x2c6ac6[_0xf544('0x19')](_0x43a93a)[_0xf544('0x1a')](function(_0x48d441){return _0x48d441;});}return null;};}function removeEntity(_0x350243){return function(_0x5c909f){if(_0x5c909f){return _0x5c909f[_0xf544('0x1b')]()[_0xf544('0x1a')](function(){_0x350243['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x3a8914){return function(_0xeda7b2){if(!_0xeda7b2){_0x3a8914[_0xf544('0x1c')](0x194);}return _0xeda7b2;};}function handleError(_0x235325,_0xf5e5a1){_0xf5e5a1=_0xf5e5a1||0x1f4;return function(_0x9a908){logger[_0xf544('0x1d')](_0x9a908[_0xf544('0x1e')]);if(_0x9a908[_0xf544('0x1f')]){delete _0x9a908[_0xf544('0x1f')];}_0x235325[_0xf544('0x11')](_0xf5e5a1)['send'](_0x9a908);};}exports[_0xf544('0x20')]=function(_0x3598cf,_0x453a9d){var _0x2278b4={};return contacts[_0xf544('0x21')]()['then'](function(_0x20afcd){_0x2278b4=qs[_0xf544('0x22')](_0x20afcd,_0x3598cf);return contacts[_0xf544('0x23')](_0x3598cf[_0xf544('0x24')],_0x3598cf['user'],_0x2278b4,_0x20afcd);})[_0xf544('0x1a')](respondWithFilteredResult(_0x453a9d,_0x2278b4))['catch'](handleError(_0x453a9d,null));};exports['destroy']=function(_0x2c4e96,_0x5d5e2c){return db[_0xf544('0x25')][_0xf544('0x26')]({'where':{'id':_0x2c4e96[_0xf544('0x27')]['id']}})[_0xf544('0x1a')](handleEntityNotFound(_0x5d5e2c,null))['then'](removeEntity(_0x5d5e2c,null))[_0xf544('0x28')](handleError(_0x5d5e2c,null));};exports[_0xf544('0x21')]=function(_0x3e748c,_0x42bdc4){return db[_0xf544('0x25')][_0xf544('0x21')]()[_0xf544('0x1a')](function(_0x5b81a4){delete _0x5b81a4['tags'];for(var _0x3c0599=0x0;_0x3c0599<Object[_0xf544('0x29')](_0x5b81a4)[_0xf544('0x2a')];_0x3c0599++){var _0x12a379=Object['keys'](_0x5b81a4)[_0x3c0599];if(!_[_0xf544('0x2b')](_0x12a379,_0xf544('0x2c'))){_0x5b81a4[_0x12a379][_0xf544('0x2d')]=_0x12a379;_0x5b81a4[_0x12a379][_0xf544('0x2e')]=_0x12a379;}}return _0x5b81a4;})['then'](function(_0xbfc1b0){var _0xd8df58={'where':Boolean(_0x3e748c['query'][_0xf544('0x2f')])===!![]?undefined:{'$or':[{'ListId':_0x3e748c[_0xf544('0x24')]['id']},{'ListId':null}]},'raw':!![]};return db[_0xf544('0x30')][_0xf544('0x23')](_0xd8df58)[_0xf544('0x1a')](function(_0x4cbcca){for(var _0x164333=0x0;_0x164333<_0x4cbcca[_0xf544('0x2a')];_0x164333++){var _0x28b4ce=_0xf544('0x2c')+_0x4cbcca[_0x164333]['id'];if(_0xbfc1b0[_0x28b4ce]){_0xbfc1b0[_0x28b4ce]['columnName']=_0x28b4ce;_0xbfc1b0[_0x28b4ce]['displayName']=_0x4cbcca[_0x164333]['alias'];_0xbfc1b0[_0x28b4ce][_0xf544('0x31')]={'type':_0x4cbcca[_0x164333][_0xf544('0x32')],'values':_0x4cbcca[_0x164333][_0xf544('0x33')]};}else{logger['info'](_0xf544('0x34'),_0x28b4ce);}}Object['keys'](_0xbfc1b0)[_0xf544('0x35')](function(_0x57faf0){if(!_0xbfc1b0[_0x57faf0][_0xf544('0x36')](_0xf544('0x2d'))){delete _0xbfc1b0[_0x57faf0];}});return _0xbfc1b0;});})[_0xf544('0x1a')](respondWithResult(_0x42bdc4,null))[_0xf544('0x28')](handleError(_0x42bdc4,null));};exports[_0xf544('0x37')]=function(_0x158aa1,_0x41d1c3){var _0x2b5ea2;var _0x484993;var _0x44e5d;if(_0x158aa1['body']['id']){delete _0x158aa1[_0xf544('0x38')]['id'];}return db[_0xf544('0x25')]['findAll']({'where':{'id':[_0x158aa1['body']['to'],_0x158aa1['body'][_0xf544('0x39')]]}})[_0xf544('0x1a')](function(_0x4b93b1){if(_0x4b93b1){if(_0x4b93b1[_0xf544('0x2a')]!==0x2){return null;}_0x4b93b1[0x0]=_0x4b93b1[0x0][_0xf544('0x3a')]({'plain':!![]});_0x4b93b1[0x1]=_0x4b93b1[0x1][_0xf544('0x3a')]({'plain':!![]});delete _0x4b93b1[0x0]['id'];delete _0x4b93b1[0x1]['id'];return _[_0xf544('0x3b')](_0x4b93b1[0x0],_0x4b93b1[0x1],function(_0x22274a,_0x47bd77){if(Array[_0xf544('0x3c')](_0x47bd77)&&!_0x47bd77['length']){return _0x22274a;}else if(!_0x47bd77){return _0x22274a;}});}})[_0xf544('0x1a')](handleEntityNotFound(_0x41d1c3,null))[_0xf544('0x1a')](function(_0x2cdbfe){if(_0x2cdbfe){if(_0x2cdbfe['tags']&&_['isArray'](_0x2cdbfe[_0xf544('0x3d')])){_0x2cdbfe[_0xf544('0x3d')]=_0x2cdbfe[_0xf544('0x3d')]['join']();}logger[_0xf544('0x3e')](_0xf544('0x3f'),_0x158aa1[_0xf544('0x38')]['to'],_0x158aa1[_0xf544('0x38')][_0xf544('0x39')]);return db[_0xf544('0x40')][_0xf544('0x1b')]({'where':{'ContactId':[_0x158aa1[_0xf544('0x38')]['to'],_0x158aa1[_0xf544('0x38')]['from']]}})[_0xf544('0x1a')](function(_0x308a10){logger[_0xf544('0x3e')](_0xf544('0x41'),_0x308a10);return db[_0xf544('0x42')]['destroy']({'where':{'ContactId':[_0x158aa1[_0xf544('0x38')]['to'],_0x158aa1[_0xf544('0x38')][_0xf544('0x39')]]}})[_0xf544('0x1a')](function(_0xdff13f){logger[_0xf544('0x3e')](_0xf544('0x43'),_0xdff13f);return db['CmContact']['create'](_0x2cdbfe);});});}})['then'](function(_0x1e5dcd){if(_0x1e5dcd){_0x2b5ea2=_0x1e5dcd;_0x484993={'ContactId':_0x2b5ea2['id']};_0x44e5d={'where':{'ContactId':[_0x158aa1['body']['to'],_0x158aa1['body']['from']]}};return db[_0xf544('0x44')][_0xf544('0x19')](_0x484993,_0x44e5d);}})[_0xf544('0x1a')](function(){if(_0x2b5ea2){return db[_0xf544('0x45')]['update'](_0x484993,_0x44e5d);}})[_0xf544('0x1a')](function(){if(_0x2b5ea2){return db[_0xf544('0x46')][_0xf544('0x19')](_0x484993,_0x44e5d);}})[_0xf544('0x1a')](function(){if(_0x2b5ea2){return db[_0xf544('0x47')][_0xf544('0x19')](_0x484993,_0x44e5d);}})['then'](function(){if(_0x2b5ea2){return db[_0xf544('0x48')][_0xf544('0x19')](_0x484993,_0x44e5d);}})['then'](function(){if(_0x2b5ea2){return db['MailInteraction'][_0xf544('0x19')](_0x484993,_0x44e5d);}})['then'](function(){if(_0x2b5ea2){return db['MailMessage'][_0xf544('0x19')](_0x484993,_0x44e5d);}})[_0xf544('0x1a')](function(){if(_0x2b5ea2){return db[_0xf544('0x49')][_0xf544('0x19')](_0x484993,_0x44e5d);}})['then'](function(){if(_0x2b5ea2){return db[_0xf544('0x4a')][_0xf544('0x19')](_0x484993,_0x44e5d);}})[_0xf544('0x1a')](function(){if(_0x2b5ea2){return db[_0xf544('0x4b')]['update'](_0x484993,_0x44e5d);}})['then'](function(){if(_0x2b5ea2){return db['FaxMessage'][_0xf544('0x19')](_0x484993,_0x44e5d);}})['then'](function(){if(_0x2b5ea2){return db[_0xf544('0x4c')][_0xf544('0x19')](_0x484993,_0x44e5d);}})[_0xf544('0x1a')](function(){if(_0x2b5ea2){return db['OpenchannelMessage'][_0xf544('0x19')](_0x484993,_0x44e5d);}})[_0xf544('0x1a')](function(){if(_0x2b5ea2){return db['CmContactHasItem'][_0xf544('0x19')]({'CmContactId':_0x2b5ea2['id']},{'where':{'CmContactId':[_0x158aa1['body']['to'],_0x158aa1['body'][_0xf544('0x39')]]}});}})[_0xf544('0x1a')](function(){if(_0x2b5ea2){return db[_0xf544('0x4d')][_0xf544('0x19')](_0x484993,_0x44e5d);}})[_0xf544('0x1a')](function(){if(_0x2b5ea2){return db[_0xf544('0x4e')][_0xf544('0x19')](_0x484993,_0x44e5d);}})[_0xf544('0x1a')](function(){if(_0x2b5ea2){return db[_0xf544('0x4f')][_0xf544('0x19')](_0x484993,_0x44e5d);}})['then'](function(){if(_0x2b5ea2){return db['VoiceCallReport'][_0xf544('0x19')](_0x484993,_0x44e5d);}})[_0xf544('0x1a')](function(){if(_0x2b5ea2){return db[_0xf544('0x50')][_0xf544('0x19')](_0x484993,_0x44e5d);}})[_0xf544('0x1a')](function(){if(_0x2b5ea2){return db['FaxQueueReport']['update'](_0x484993,_0x44e5d);}})[_0xf544('0x1a')](function(){if(_0x2b5ea2){return db[_0xf544('0x51')][_0xf544('0x19')](_0x484993,_0x44e5d);}})[_0xf544('0x1a')](function(){if(_0x2b5ea2){return db[_0xf544('0x52')]['update'](_0x484993,_0x44e5d);}})[_0xf544('0x1a')](function(){if(_0x2b5ea2){return db[_0xf544('0x53')][_0xf544('0x19')](_0x484993,_0x44e5d);}})[_0xf544('0x1a')](function(){if(_0x2b5ea2){return db[_0xf544('0x54')][_0xf544('0x19')](_0x484993,_0x44e5d);}})[_0xf544('0x1a')](function(){if(_0x2b5ea2){return db[_0xf544('0x55')][_0xf544('0x19')](_0x484993,_0x44e5d);}})['then'](function(){if(_0x2b5ea2){return db['WhatsappMessage']['update'](_0x484993,_0x44e5d);}})['then'](function(){if(_0x2b5ea2){return db['WhatsappQueueReport'][_0xf544('0x19')](_0x484993,_0x44e5d);}})[_0xf544('0x1a')](function(){if(_0x2b5ea2){return db[_0xf544('0x25')]['destroy']({'where':{'id':[_0x158aa1['body']['to'],_0x158aa1['body'][_0xf544('0x39')]]}});}})[_0xf544('0x1a')](function(){if(_0x2b5ea2){return _0x2b5ea2;}})[_0xf544('0x1a')](respondWithResult(_0x41d1c3,null))[_0xf544('0x28')](handleError(_0x41d1c3,null));};exports[_0xf544('0x56')]=function(_0x203aa2,_0x5747ea){return db[_0xf544('0x25')][_0xf544('0x21')]()[_0xf544('0x1a')](function(_0x136bdf){if(_0x203aa2[_0xf544('0x38')]['tags']&&_[_0xf544('0x3c')](_0x203aa2['body']['tags'])){if(_0x203aa2[_0xf544('0x38')][_0xf544('0x3d')][_0xf544('0x2a')]){_0x203aa2[_0xf544('0x38')][_0xf544('0x3d')]=_0x203aa2[_0xf544('0x38')]['tags'][_0xf544('0x57')](';')+';';}else{_0x203aa2[_0xf544('0x38')][_0xf544('0x3d')]=null;}}else{_0x203aa2['body'][_0xf544('0x3d')]=null;}if(!_['isNil'](_0x203aa2[_0xf544('0x38')]['dialTimezone'])){var _0x56408f=_0x203aa2[_0xf544('0x38')][_0xf544('0x58')];if(!_[_0xf544('0x59')](shared[_0xf544('0x5a')][_0x56408f]))_0x203aa2['body']['utcOffset']=shared[_0xf544('0x5a')][_0x56408f][_0xf544('0x5b')];}return db[_0xf544('0x25')][_0xf544('0x56')](_0x203aa2[_0xf544('0x38')],{'fields':_[_0xf544('0x29')](_0x136bdf),'raw':!![]});})[_0xf544('0x1a')](function(_0x43cbbc){if(_0x203aa2[_0xf544('0x38')][_0xf544('0x5c')]){return insertAdditionalPhones(_0x43cbbc,_0x203aa2['body'][_0xf544('0x5c')]);}else{return _0x43cbbc;}})[_0xf544('0x1a')](respondWithResult(_0x5747ea,0xc9))['catch'](handleError(_0x5747ea,null));};exports[_0xf544('0x5d')]=function(_0x4b8024,_0x18457b){var _0x171ed3=0x0;var _0x2223e2=0x0;var _0xea5743=0x0;var _0x42a4a6=[];return db[_0xf544('0x25')][_0xf544('0x21')]()[_0xf544('0x1a')](function(_0x1e46ef){return BPromise['each'](_0x4b8024[_0xf544('0x38')],function(_0x3415a5){var _0x11638b={'where':{'$or':[]},'defaults':_0x3415a5,'fields':_[_0xf544('0x29')](_0x1e46ef),'raw':!![]};if(_0x3415a5['duplicates']){for(var _0x5b1424=0x0;_0x5b1424<_0x3415a5['duplicates']['length'];_0x5b1424++){var _0x7f15a0={};_0x7f15a0[_0x3415a5[_0xf544('0x5e')][_0x5b1424]]=_0x3415a5[_0x3415a5['duplicates'][_0x5b1424]];_0x11638b['where'][_0xf544('0x5f')][_0xf544('0x60')](_0x7f15a0);}_0x11638b[_0xf544('0x61')]['ListId']=_0x3415a5[_0xf544('0x62')];}return db[_0xf544('0x25')][_0xf544('0x63')](_0x11638b)['spread'](function(_0x45db2e,_0x5267db){if(_0x5267db){if(_0x3415a5[_0xf544('0x36')](_0xf544('0x5c'))){_0x42a4a6['push']({'contact':_0x45db2e,'additionalPhones':_0x3415a5[_0xf544('0x5c')]});}_0x171ed3++;}else{_0xea5743++;}})[_0xf544('0x28')](function(){_0x2223e2++;});});})[_0xf544('0x1a')](function(_0x212671){if(_0x212671){if(_0x42a4a6[_0xf544('0x2a')]>0x0){return new Promise(function(_0x369eed){var _0x6ea18c=[];for(var _0x4a98f4=0x0;_0x4a98f4<_0x42a4a6[_0xf544('0x2a')];_0x4a98f4++){_0x6ea18c[_0xf544('0x60')](insertAdditionalPhones(_0x42a4a6[_0x4a98f4][_0xf544('0x64')],_0x42a4a6[_0x4a98f4][_0xf544('0x5c')]));}Promise[_0xf544('0x65')](_0x6ea18c)[_0xf544('0x1a')](function(){_0x369eed(0x1);});})[_0xf544('0x1a')](function(){return{'success':_0x171ed3,'failure':_0x2223e2,'duplicates':_0xea5743};});}else{return{'success':_0x171ed3,'failure':_0x2223e2,'duplicates':_0xea5743};}}})[_0xf544('0x1a')](respondWithResult(_0x18457b,0xc9))['catch'](handleError(_0x18457b,null));};exports['show']=function(_0x4f4fd8,_0x4aae20){var _0x42719b;return db['CmContact'][_0xf544('0x21')]()[_0xf544('0x1a')](function(_0x4a4895){return db[_0xf544('0x25')][_0xf544('0x26')]({'where':{'id':_0x4f4fd8[_0xf544('0x27')]['id']},'include':[{'model':db[_0xf544('0x66')],'as':_0xf544('0x67'),'attributes':['id',_0xf544('0x1f'),_0xf544('0x68')],'required':_0x4f4fd8[_0xf544('0x24')][_0xf544('0x69')]?!![]:![]},{'model':db['CmContactHasItem'],'as':_0xf544('0x6a'),'where':{'CmContactId':_0x4f4fd8[_0xf544('0x27')]['id']},'required':![],'include':[{'model':db[_0xf544('0x6b')],'as':_0xf544('0x6c')}]}],'order':[db['sequelize'][_0xf544('0x6d')](_0xf544('0x6e'))],'attributes':_['keys'](_0x4a4895)});})[_0xf544('0x1a')](function(_0x5a9357){if(!_[_0xf544('0x59')](_0x5a9357)){_0x42719b=_0x5a9357[_0xf544('0x3a')]({'plain':!![]});var _0xc15fe5={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x5a9357&&_0x5a9357['ListId']){if(_0x5a9357[_0xf544('0x62')]){_0xc15fe5['where'][_0xf544('0x6f')][_0xf544('0x60')]({'ListId':{'$ne':_0x5a9357[_0xf544('0x62')]}});}}return db[_0xf544('0x30')][_0xf544('0x23')](_0xc15fe5);}})['then'](function(_0x5bab53){if(!_[_0xf544('0x59')](_0x5bab53)){return _[_0xf544('0x70')](_0x42719b,_[_0xf544('0x71')](_0x5bab53,function(_0x26830f){return util[_0xf544('0x72')](_0xf544('0x73'),_0x26830f['id']);}));}})[_0xf544('0x1a')](handleEntityNotFound(_0x4aae20,null))['then'](respondWithResult(_0x4aae20,null))['catch'](handleError(_0x4aae20,null));};exports[_0xf544('0x19')]=function(_0x4b63c1,_0x3cc301){var _0x179a26;if(_0x4b63c1[_0xf544('0x38')]['id']){delete _0x4b63c1[_0xf544('0x38')]['id'];}if(!_[_0xf544('0x59')](_0x4b63c1[_0xf544('0x38')][_0xf544('0x58')])){var _0x58a6a4=_0x4b63c1['body'][_0xf544('0x58')];if(!_[_0xf544('0x59')](shared[_0xf544('0x5a')][_0x58a6a4]))_0x4b63c1['body'][_0xf544('0x5b')]=shared[_0xf544('0x5a')][_0x58a6a4][_0xf544('0x5b')];}return db[_0xf544('0x25')][_0xf544('0x26')]({'where':{'id':_0x4b63c1['params']['id']}})[_0xf544('0x1a')](handleEntityNotFound(_0x3cc301,null))[_0xf544('0x1a')](saveUpdates(_0x4b63c1[_0xf544('0x38')],null))['then'](function(_0x45863d){_0x179a26=_0x45863d;var _0x55ec7c={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x45863d&&_0x45863d[_0xf544('0x62')]){if(_0x45863d[_0xf544('0x62')]){_0x55ec7c[_0xf544('0x61')][_0xf544('0x6f')]['push']({'ListId':{'$ne':_0x45863d[_0xf544('0x62')]}});}}return db['CmCustomField'][_0xf544('0x23')](_0x55ec7c);})[_0xf544('0x1a')](function(_0x5348dd){if(_0x5348dd){return _[_0xf544('0x70')](_[_0xf544('0x74')](_0x4b63c1[_0xf544('0x38')],function(_0x542233,_0x4a8fb0){return _[_0xf544('0x2b')](_0x4a8fb0,_0xf544('0x2c'));}),_[_0xf544('0x71')](_0x5348dd,function(_0x2ca0ba){return util[_0xf544('0x72')]('cf_%d',_0x2ca0ba['id']);}));}})[_0xf544('0x1a')](function(_0x3a0f87){if(_0x3a0f87&&!_['isEmpty'](_0x3a0f87)){var _0x13662f=squel['update']()['table']('cm_contacts')[_0xf544('0x75')](_0x3a0f87)[_0xf544('0x61')](_0xf544('0x76'),_0x4b63c1[_0xf544('0x27')]['id'])[_0xf544('0x77')]();return db[_0xf544('0x78')]['query'](_0x13662f[_0xf544('0x79')],{'replacements':_0x13662f[_0xf544('0x33')]});}})[_0xf544('0x1a')](function(){if(_0x4b63c1[_0xf544('0x38')][_0xf544('0x7a')]&&_0x179a26){return db[_0xf544('0x40')][_0xf544('0x19')]({'phone':_0x4b63c1[_0xf544('0x38')][_0xf544('0x7a')],'OrderBy':0x0},{'where':{'ContactId':_0x179a26['id']}});}})[_0xf544('0x1a')](function(){return _0x179a26;})['then'](respondWithResult(_0x3cc301,null))[_0xf544('0x28')](handleError(_0x3cc301,null));};exports[_0xf544('0x7b')]=function(_0x5338bb,_0xa23214){var _0x1a5ef3={};var _0x45718f={};var _0x1dc3d3;var _0x59aafa;return db['CmContact'][_0xf544('0x7c')]({'where':{'id':_0x5338bb[_0xf544('0x27')]['id']}})['then'](handleEntityNotFound(_0xa23214,null))['then'](function(_0x50ee24){if(_0x50ee24){_0x1dc3d3=_0x50ee24;_0x45718f[_0xf544('0x7d')]=_[_0xf544('0x29')](db[_0xf544('0x66')][_0xf544('0x7e')]);_0x45718f[_0xf544('0x24')]=_[_0xf544('0x29')](_0x5338bb[_0xf544('0x24')]);_0x45718f['filters']=_['intersection'](_0x45718f['model'],_0x45718f[_0xf544('0x24')]);_0x1a5ef3[_0xf544('0x7f')]=_[_0xf544('0x80')](_0x45718f[_0xf544('0x7d')],qs[_0xf544('0x81')](_0x5338bb[_0xf544('0x24')]['fields']));_0x1a5ef3[_0xf544('0x7f')]=_0x1a5ef3[_0xf544('0x7f')][_0xf544('0x2a')]?_0x1a5ef3[_0xf544('0x7f')]:_0x45718f[_0xf544('0x7d')];_0x1a5ef3[_0xf544('0x82')]=qs[_0xf544('0x83')](_0x5338bb[_0xf544('0x24')][_0xf544('0x83')]);_0x1a5ef3[_0xf544('0x61')]=qs[_0xf544('0x84')](_[_0xf544('0x85')](_0x5338bb[_0xf544('0x24')],_0x45718f[_0xf544('0x84')]));if(_0x5338bb['query'][_0xf544('0x86')]){_0x1a5ef3[_0xf544('0x61')]=_[_0xf544('0x37')](_0x1a5ef3[_0xf544('0x61')],{'$or':_[_0xf544('0x71')](_0x1a5ef3[_0xf544('0x7f')],function(_0x2542df){var _0x2b71e7={};_0x2b71e7[_0x2542df]={'$like':'%'+_0x5338bb['query']['filter']+'%'};return _0x2b71e7;})});}_0x1a5ef3=_[_0xf544('0x37')]({},_0x1a5ef3,_0x5338bb[_0xf544('0x87')]);return _0x1dc3d3[_0xf544('0x7b')](_0x1a5ef3);}})['then'](function(_0x2a6c4d){if(_0x2a6c4d){_0x59aafa=_0x2a6c4d[_0xf544('0x2a')];if(!_0x5338bb[_0xf544('0x24')]['hasOwnProperty']('nolimit')){_0x1a5ef3[_0xf544('0x14')]=qs[_0xf544('0x14')](_0x5338bb[_0xf544('0x24')][_0xf544('0x14')]);_0x1a5ef3[_0xf544('0x16')]=qs[_0xf544('0x16')](_0x5338bb[_0xf544('0x24')][_0xf544('0x16')]);}return _0x1dc3d3[_0xf544('0x7b')](_0x1a5ef3);}})['then'](function(_0x58bb18){if(_0x58bb18){return _0x58bb18?{'count':_0x59aafa,'rows':_0x58bb18}:null;}})[_0xf544('0x1a')](respondWithResult(_0xa23214,null))[_0xf544('0x28')](handleError(_0xa23214,null));};exports[_0xf544('0x88')]=function(_0x5f3c33,_0x3bb5f2){if(_0x5f3c33[_0xf544('0x38')]['id']){delete _0x5f3c33[_0xf544('0x38')]['id'];}return db[_0xf544('0x25')][_0xf544('0x7c')]({'where':{'id':_0x5f3c33[_0xf544('0x27')]['id']}})[_0xf544('0x1a')](handleEntityNotFound(_0x3bb5f2,null))[_0xf544('0x1a')](function(_0x35c7c7){if(_0x35c7c7){return _0x35c7c7[_0xf544('0x88')](_0x5f3c33[_0xf544('0x38')][_0xf544('0x89')]||[]);}return null;})['then'](respondWithResult(_0x3bb5f2,null))['catch'](handleError(_0x3bb5f2,null));};exports['setAdditionalPhones']=function(_0x2c0a9e,_0x36417c){var _0x230d9c=[];_0x230d9c['push'](addAdditionalPhones(_0x2c0a9e['body']));Promise['all'](_0x230d9c)[_0xf544('0x1a')](function(){_0x230d9c=[];_0x230d9c[_0xf544('0x60')](deleteCmHopperPhones(_0x2c0a9e[_0xf544('0x38')]['id']));_0x230d9c[_0xf544('0x60')](addCmHopperPhones(_0x2c0a9e[_0xf544('0x38')]['id']));Promise[_0xf544('0x65')](_0x230d9c)['then'](function(){return[0x1];})[_0xf544('0x1a')](respondWithResult(_0x36417c,null));});};function addAdditionalPhones(_0x5be731){var _0x5457e0;return new Promise(function(_0x3184f3){return db[_0xf544('0x8a')][_0xf544('0x1b')]({'where':{'CmContactId':_0x5be731['id']}})[_0xf544('0x1a')](function(){db[_0xf544('0x6b')]['findAll']({'raw':!![],'attributes':['id',_0xf544('0x8b')]})[_0xf544('0x1a')](function(_0x45ef48){var _0x1ea216=[];for(var _0x4ae69c=0x0;_0x4ae69c<_0x5be731[_0xf544('0x8c')][_0xf544('0x2a')];_0x4ae69c++){var _0x4a466b=_0x5be731[_0xf544('0x8d')]?_[_0xf544('0x59')](_0x5be731[_0xf544('0x8d')][_0x4ae69c])?'':_0x5be731[_0xf544('0x8d')][_0x4ae69c]:_0x5be731[_0xf544('0x8c')][_0x4ae69c][_0xf544('0x8e')]?_0x5be731[_0xf544('0x8c')][_0x4ae69c]['ItemTypeId']:'';var _0x30c1b7=_['isNil'](_0x5be731[_0xf544('0x8c')][_0x4ae69c]['description'])?'':_0x5be731[_0xf544('0x8c')][_0x4ae69c][_0xf544('0x8f')];var _0x1382e5=_0x4a466b+':'+_0x5be731[_0xf544('0x8c')][_0x4ae69c]['phone']+'§'+_0x30c1b7;if(_[_0xf544('0x59')](_0x5457e0))_0x5457e0=_0x1382e5;else _0x5457e0+=';'+_0x1382e5;var _0x2ee894=null;var _0x52f96d=null;if(_0x5be731[_0xf544('0x8d')]){if(!_[_0xf544('0x59')](_0x5be731[_0xf544('0x8d')][_0x4ae69c])){_0x52f96d=_[_0xf544('0x26')](_0x45ef48,function(_0x4ff713){return _0x4ff713['id']===_0x5be731[_0xf544('0x8d')][_0x4ae69c];});if(!_[_0xf544('0x59')](_0x52f96d)){_0x2ee894=_0x52f96d[_0xf544('0x8b')];}}}else{if(!_[_0xf544('0x59')](_0x5be731['items'][_0x4ae69c])){_0x52f96d=_['find'](_0x45ef48,function(_0xbab3bb){return _0xbab3bb['id']===_0x5be731[_0xf544('0x8c')][_0x4ae69c][_0xf544('0x8e')];});if(!_[_0xf544('0x59')](_0x52f96d)){_0x2ee894=_0x4ae69c;}}}if(_['isNil'](_0x2ee894)){_0x2ee894=0x64;}_0x1ea216[_0xf544('0x60')](addAdditionalPhone(_0x5be731['id'],_0x5be731[_0xf544('0x8c')][_0x4ae69c][_0xf544('0x7a')],_0x5be731[_0xf544('0x8d')]?_['isNil'](_0x5be731[_0xf544('0x8d')][_0x4ae69c])?null:_0x5be731[_0xf544('0x8d')][_0x4ae69c]:_0x5be731[_0xf544('0x8c')][_0x4ae69c][_0xf544('0x8e')]?_0x5be731[_0xf544('0x8c')][_0x4ae69c][_0xf544('0x8e')]:null,_0x2ee894,_0x30c1b7));}Promise[_0xf544('0x65')](_0x1ea216)[_0xf544('0x1a')](function(){db['CmContact'][_0xf544('0x19')]({'AdditionalPhones':_0x5457e0},{'where':{'id':_0x5be731['id']}})['then'](function(){_0x3184f3(0x1);});});});});});}function addAdditionalPhone(_0x23369e,_0xaa6413,_0x5366c1,_0x234866,_0x499577){return db[_0xf544('0x8a')][_0xf544('0x26')]({'where':{'CmContactId':_0x23369e,'item':_0xaa6413}})[_0xf544('0x1a')](function(_0x2fe537){if(_0x2fe537)logger['info'](_0xf544('0x90'),_0x2fe537);else{db[_0xf544('0x8a')][_0xf544('0x56')]({'CmContactId':_0x23369e,'item':_0xaa6413,'ItemTypeId':_0x5366c1,'OrderBy':_0x234866,'ItemClass':'PHONE','description':_0x499577});}});}function deleteCmHopperPhones(_0x209688){return new Promise(function(_0x33a9c5){return db[_0xf544('0x40')][_0xf544('0x23')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x209688}})[_0xf544('0x1a')](function(_0x597783){db[_0xf544('0x91')][_0xf544('0x1b')]({'where':{'CmHopperId':{'$in':_[_0xf544('0x71')](_0x597783,'id')}}});})[_0xf544('0x1a')](function(){_0x33a9c5(0x1);});});}function addCmHopperPhones(_0x4970fc){return new Promise(function(_0x264cb3){return db[_0xf544('0x40')][_0xf544('0x23')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x4970fc}})[_0xf544('0x1a')](function(_0x55180c){var _0x3244b0=[];_[_0xf544('0x71')](_0x55180c,function(_0x59dcea){_0x3244b0[_0xf544('0x60')](createCmHopperPhone(_0x4970fc,_0x59dcea['id']));});Promise['all'](_0x3244b0)['then'](function(){_0x264cb3(0x1);});});});}function createCmHopperPhone(_0x12a2c3,_0x53e0ab){return new Promise(function(_0x227028){db[_0xf544('0x8a')][_0xf544('0x23')]({'raw':!![],'attributes':[_0xf544('0x92'),_0xf544('0x8b')],'where':{'CmContactId':_0x12a2c3,'ItemClass':_0xf544('0x93')},'include':[{'model':db[_0xf544('0x6b')],'attributes':[_0xf544('0x8b')],'as':'ItemType'}],'order':[_0xf544('0x8b'),db[_0xf544('0x78')][_0xf544('0x6d')]('`ItemType`.OrderBy')]})['then'](function(_0x39f54b){var _0xcfa1a5=0x1;var _0x57697d=_[_0xf544('0x71')](_0x39f54b,function(_0x1faf9b){_0x1faf9b[_0xf544('0x94')]=_0x53e0ab;_0x1faf9b[_0xf544('0x7a')]=_0x1faf9b[_0xf544('0x92')];_0x1faf9b[_0xf544('0x8b')]=_0xcfa1a5;delete _0x1faf9b[_0xf544('0x95')];_0xcfa1a5=_0xcfa1a5+0x1;return _0x1faf9b;});return db[_0xf544('0x91')][_0xf544('0x5d')](_0x57697d,{});})['then'](function(){_0x227028(0x1);});});}function insertAdditionalPhones(_0x5b30ed,_0x4ff8f8){return new Promise(function(_0x3911d7){var _0x327721=[];for(var _0x39f66a=0x0;_0x39f66a<_0x4ff8f8['length'];_0x39f66a++){var _0x303ac9=_0x4ff8f8[_0x39f66a];_0x327721[_0xf544('0x60')](parseContactItemType(_0x303ac9));}Promise[_0xf544('0x65')](_0x327721)['then'](function(){var _0x48f17d={'id':_0x5b30ed['id'],'items':_0x4ff8f8};return addAdditionalPhones(_0x48f17d)[_0xf544('0x1a')](function(){return addCmHopperPhones(_0x5b30ed['id']);});})[_0xf544('0x1a')](function(){_0x3911d7(_0x5b30ed);});});}function parseContactItemType(_0x58ea43){return new Promise(function(_0x175ed4){if(_0x58ea43[_0xf544('0x36')](_0xf544('0x8e'))){_0x175ed4(_0x58ea43);}else{return db['ContactItemType'][_0xf544('0x26')]({'where':{'name':_0x58ea43[_0xf544('0x6c')]}})[_0xf544('0x1a')](function(_0x796721){if(_[_0xf544('0x59')](_0x796721))_0x58ea43[_0xf544('0x8e')]=null;else _0x58ea43[_0xf544('0x8e')]=_0x796721['id'];_0x175ed4(_0x58ea43);});}});}exports[_0xf544('0x96')]=function(_0x3a6cd2,_0x5cbde9){return db[_0xf544('0x8a')][_0xf544('0x23')]({'raw':!![],'where':{'CmContactId':_0x3a6cd2[_0xf544('0x27')]['id'],'ItemClass':_0xf544('0x93')},'include':[{'model':db[_0xf544('0x6b')],'as':_0xf544('0x6c')}],'order':[[_0xf544('0x8b')],[db[_0xf544('0x78')][_0xf544('0x6d')]('`ItemType`.OrderBy')]]})['then'](function(_0x15984d){return _0x15984d;})[_0xf544('0x1a')](respondWithResult(_0x5cbde9,null))[_0xf544('0x28')](handleError(_0x5cbde9,null));};exports[_0xf544('0x97')]=function(_0x3da223,_0x37a6e3){return db[_0xf544('0x8a')][_0xf544('0x23')]({'raw':!![],'where':{'CmContactId':_0x3da223['body'][_0xf544('0x98')]}})[_0xf544('0x1a')](function(_0x1e3b20){var _0x1ad0ce=_[_0xf544('0x71')](_0x1e3b20,function(_0x2b5bae){_0x2b5bae['CmContactId']=_0x3da223[_0xf544('0x38')][_0xf544('0x99')];return _0x2b5bae;});return db['CmContactHasItem']['bulkCreate'](_0x1ad0ce,{});})[_0xf544('0x1a')](function(){return addCmHopperPhones(_0x3da223[_0xf544('0x38')][_0xf544('0x99')]);})[_0xf544('0x1a')](function(){return['ok'];})[_0xf544('0x1a')](respondWithResult(_0x37a6e3,null))[_0xf544('0x28')](handleError(_0x37a6e3,null));};exports[_0xf544('0x9a')]=function(_0x153399,_0x25fe64){var _0x8b28fb=[];_0x8b28fb[_0xf544('0x60')](createCmHopperPhone(_0x153399['body']['id'],_0x153399[_0xf544('0x38')][_0xf544('0x9b')]));Promise[_0xf544('0x65')](_0x8b28fb)[_0xf544('0x1a')](function(){return[0x1];})['then'](respondWithResult(_0x25fe64,null));};exports[_0xf544('0x9c')]=function(_0x33c96d,_0xaf437e){var _0x51afbb={'raw':![],'where':{}};var _0x505471={};var _0x27c99b={'count':0x0,'rows':[]};return db[_0xf544('0x25')][_0xf544('0x7c')]({'where':{'id':_0x33c96d[_0xf544('0x27')]['id']}})[_0xf544('0x1a')](handleEntityNotFound(_0xaf437e,null))[_0xf544('0x1a')](function(_0x5da7ea){if(_0x5da7ea){_0x505471[_0xf544('0x7d')]=_[_0xf544('0x29')](db[_0xf544('0x40')][_0xf544('0x7e')]);_0x505471[_0xf544('0x24')]=_['keys'](_0x33c96d['query']);_0x505471[_0xf544('0x84')]=_[_0xf544('0x80')](_0x505471['model'],_0x505471['query']);_0x51afbb[_0xf544('0x7f')]=_[_0xf544('0x80')](_0x505471[_0xf544('0x7d')],qs[_0xf544('0x81')](_0x33c96d[_0xf544('0x24')]['fields']));_0x51afbb['attributes']=_0x51afbb['attributes'][_0xf544('0x2a')]?_0x51afbb[_0xf544('0x7f')]:_0x505471[_0xf544('0x7d')];if(!_0x33c96d[_0xf544('0x24')][_0xf544('0x36')](_0xf544('0x9d'))){_0x51afbb['limit']=qs[_0xf544('0x14')](_0x33c96d[_0xf544('0x24')]['limit']);_0x51afbb[_0xf544('0x16')]=qs[_0xf544('0x16')](_0x33c96d['query'][_0xf544('0x16')]);}_0x51afbb[_0xf544('0x82')]=qs['sort'](_0x33c96d['query'][_0xf544('0x83')]);_0x51afbb[_0xf544('0x61')]=qs[_0xf544('0x84')](_['pick'](_0x33c96d[_0xf544('0x24')],_0x505471[_0xf544('0x84')]));_0x51afbb[_0xf544('0x61')][_0xf544('0x9e')]=_0x5da7ea['id'];if(_0x33c96d[_0xf544('0x24')][_0xf544('0x86')]){_0x51afbb[_0xf544('0x61')]=_[_0xf544('0x37')](_0x51afbb[_0xf544('0x61')],{'$or':_[_0xf544('0x71')](_0x51afbb[_0xf544('0x7f')],function(_0xb481d3){var _0x25ac19={};_0x25ac19[_0xb481d3]={'$like':'%'+_0x33c96d[_0xf544('0x24')][_0xf544('0x86')]+'%'};return _0x25ac19;})});}_0x51afbb=_[_0xf544('0x37')]({},_0x51afbb,_0x33c96d[_0xf544('0x87')]);return db[_0xf544('0x40')][_0xf544('0x15')]({'where':_0x51afbb['where']})[_0xf544('0x1a')](function(_0x52f8f6){_0x27c99b['count']=_0x52f8f6;if(_0x33c96d['query'][_0xf544('0x9f')]){_0x51afbb[_0xf544('0xa0')]=[{'all':!![]}];}return db['CmHopper']['findAll'](_0x51afbb);})[_0xf544('0x1a')](function(_0x318682){_0x27c99b[_0xf544('0xa1')]=_0x318682;return _0x27c99b;});}})['then'](respondWithFilteredResult(_0xaf437e,_0x51afbb))[_0xf544('0x28')](handleError(_0xaf437e,null));};exports[_0xf544('0xa2')]=function(_0xc14583,_0x3811e2){var _0x478b57={'raw':!![],'where':{}};var _0x4d64d8={};var _0x432769={'count':0x0,'rows':[]};return db[_0xf544('0x25')][_0xf544('0x7c')]({'where':{'id':_0xc14583['params']['id']}})[_0xf544('0x1a')](handleEntityNotFound(_0x3811e2,null))[_0xf544('0x1a')](function(_0x3e6f09){if(_0x3e6f09){_0x4d64d8[_0xf544('0x7d')]=_[_0xf544('0x29')](db[_0xf544('0x4e')][_0xf544('0x7e')]);_0x4d64d8[_0xf544('0x24')]=_[_0xf544('0x29')](_0xc14583[_0xf544('0x24')]);_0x4d64d8[_0xf544('0x84')]=_[_0xf544('0x80')](_0x4d64d8[_0xf544('0x7d')],_0x4d64d8[_0xf544('0x24')]);_0x478b57['attributes']=_[_0xf544('0x80')](_0x4d64d8[_0xf544('0x7d')],qs['fields'](_0xc14583['query'][_0xf544('0x81')]));_0x478b57[_0xf544('0x7f')]=_0x478b57[_0xf544('0x7f')][_0xf544('0x2a')]?_0x478b57[_0xf544('0x7f')]:_0x4d64d8[_0xf544('0x7d')];if(!_0xc14583[_0xf544('0x24')][_0xf544('0x36')](_0xf544('0x9d'))){_0x478b57[_0xf544('0x14')]=qs[_0xf544('0x14')](_0xc14583[_0xf544('0x24')][_0xf544('0x14')]);_0x478b57[_0xf544('0x16')]=qs['offset'](_0xc14583[_0xf544('0x24')][_0xf544('0x16')]);}_0x478b57[_0xf544('0x82')]=qs[_0xf544('0x83')](_0xc14583[_0xf544('0x24')][_0xf544('0x83')]);_0x478b57['where']=qs[_0xf544('0x84')](_[_0xf544('0x85')](_0xc14583['query'],_0x4d64d8[_0xf544('0x84')]));_0x478b57[_0xf544('0x61')][_0xf544('0x9e')]=_0x3e6f09['id'];if(_0xc14583[_0xf544('0x24')]['filter']){_0x478b57[_0xf544('0x61')]=_[_0xf544('0x37')](_0x478b57['where'],{'$or':_[_0xf544('0x71')](_0x478b57['attributes'],function(_0x3ec87e){var _0x2972f2={};_0x2972f2[_0x3ec87e]={'$like':'%'+_0xc14583['query'][_0xf544('0x86')]+'%'};return _0x2972f2;})});}_0x478b57=_['merge']({},_0x478b57,_0xc14583[_0xf544('0x87')]);return db['CmHopperHistory'][_0xf544('0x15')]({'where':_0x478b57[_0xf544('0x61')]})[_0xf544('0x1a')](function(_0x4fbf1a){_0x432769['count']=_0x4fbf1a;if(_0xc14583[_0xf544('0x24')][_0xf544('0x9f')]){_0x478b57['include']=[{'all':!![]}];}return db[_0xf544('0x4e')][_0xf544('0x23')](_0x478b57);})[_0xf544('0x1a')](function(_0xc59676){_0x432769[_0xf544('0xa1')]=_0xc59676;return _0x432769;});}})[_0xf544('0x1a')](respondWithFilteredResult(_0x3811e2,_0x478b57))[_0xf544('0x28')](handleError(_0x3811e2,null));};exports[_0xf544('0xa3')]=function(_0x51112f,_0x52e3fe){var _0x41a7ab={'raw':!![],'where':{}};var _0x27bbb1={};var _0x5ec8b8={'count':0x0,'rows':[]};return db['CmContact'][_0xf544('0x7c')]({'where':{'id':_0x51112f[_0xf544('0x27')]['id']}})['then'](handleEntityNotFound(_0x52e3fe,null))[_0xf544('0x1a')](function(_0xe7e4e9){if(_0xe7e4e9){_0x27bbb1[_0xf544('0x7d')]=_['keys'](db[_0xf544('0x4d')][_0xf544('0x7e')]);_0x27bbb1['query']=_[_0xf544('0x29')](_0x51112f[_0xf544('0x24')]);_0x27bbb1[_0xf544('0x84')]=_['intersection'](_0x27bbb1[_0xf544('0x7d')],_0x27bbb1[_0xf544('0x24')]);_0x41a7ab[_0xf544('0x7f')]=_['intersection'](_0x27bbb1[_0xf544('0x7d')],qs[_0xf544('0x81')](_0x51112f['query']['fields']));_0x41a7ab['attributes']=_0x41a7ab['attributes'][_0xf544('0x2a')]?_0x41a7ab[_0xf544('0x7f')]:_0x27bbb1[_0xf544('0x7d')];if(!_0x51112f[_0xf544('0x24')][_0xf544('0x36')]('nolimit')){_0x41a7ab[_0xf544('0x14')]=qs[_0xf544('0x14')](_0x51112f['query'][_0xf544('0x14')]);_0x41a7ab[_0xf544('0x16')]=qs['offset'](_0x51112f['query'][_0xf544('0x16')]);}_0x41a7ab[_0xf544('0x82')]=qs['sort'](_0x51112f['query'][_0xf544('0x83')]);_0x41a7ab[_0xf544('0x61')]=qs[_0xf544('0x84')](_[_0xf544('0x85')](_0x51112f['query'],_0x27bbb1[_0xf544('0x84')]));_0x41a7ab[_0xf544('0x61')][_0xf544('0x9e')]=_0xe7e4e9['id'];if(_0x51112f[_0xf544('0x24')]['filter']){_0x41a7ab[_0xf544('0x61')]=_[_0xf544('0x37')](_0x41a7ab[_0xf544('0x61')],{'$or':_[_0xf544('0x71')](_0x41a7ab[_0xf544('0x7f')],function(_0x1a4826){var _0x2d5ac8={};_0x2d5ac8[_0x1a4826]={'$like':'%'+_0x51112f[_0xf544('0x24')][_0xf544('0x86')]+'%'};return _0x2d5ac8;})});}_0x41a7ab=_[_0xf544('0x37')]({},_0x41a7ab,_0x51112f[_0xf544('0x87')]);return db[_0xf544('0x4d')][_0xf544('0x15')]({'where':_0x41a7ab[_0xf544('0x61')]})[_0xf544('0x1a')](function(_0x4eef30){_0x5ec8b8[_0xf544('0x15')]=_0x4eef30;if(_0x51112f['query'][_0xf544('0x9f')]){_0x41a7ab[_0xf544('0xa0')]=[{'all':!![]}];}return db[_0xf544('0x4d')]['findAll'](_0x41a7ab);})[_0xf544('0x1a')](function(_0x6376c5){_0x5ec8b8[_0xf544('0xa1')]=_0x6376c5;return _0x5ec8b8;});}})['then'](respondWithFilteredResult(_0x52e3fe,_0x41a7ab))[_0xf544('0x28')](handleError(_0x52e3fe,null));};exports[_0xf544('0xa4')]=function(_0x98b7db,_0x35376b){var _0x5a2d15={'raw':!![],'where':{}};var _0x4ef714={};var _0x4bff5c={'count':0x0,'rows':[]};return db[_0xf544('0x25')][_0xf544('0x7c')]({'where':{'id':_0x98b7db[_0xf544('0x27')]['id']}})[_0xf544('0x1a')](handleEntityNotFound(_0x35376b,null))[_0xf544('0x1a')](function(_0x3301e8){if(_0x3301e8){_0x4ef714[_0xf544('0x7d')]=_['keys'](db['JscriptySessionReport'][_0xf544('0x7e')]);_0x4ef714[_0xf544('0x24')]=_[_0xf544('0x29')](_0x98b7db[_0xf544('0x24')]);_0x4ef714['filters']=_['intersection'](_0x4ef714[_0xf544('0x7d')],_0x4ef714[_0xf544('0x24')]);_0x5a2d15[_0xf544('0x7f')]=_[_0xf544('0x80')](_0x4ef714[_0xf544('0x7d')],qs[_0xf544('0x81')](_0x98b7db[_0xf544('0x24')][_0xf544('0x81')]));_0x5a2d15['attributes']=_0x5a2d15[_0xf544('0x7f')][_0xf544('0x2a')]?_0x5a2d15[_0xf544('0x7f')]:_0x4ef714['model'];if(!_0x98b7db['query'][_0xf544('0x36')](_0xf544('0x9d'))){_0x5a2d15[_0xf544('0x14')]=qs['limit'](_0x98b7db[_0xf544('0x24')][_0xf544('0x14')]);_0x5a2d15[_0xf544('0x16')]=qs[_0xf544('0x16')](_0x98b7db[_0xf544('0x24')][_0xf544('0x16')]);}_0x5a2d15[_0xf544('0x82')]=qs[_0xf544('0x83')](_0x98b7db[_0xf544('0x24')]['sort']);_0x5a2d15['where']=qs[_0xf544('0x84')](_[_0xf544('0x85')](_0x98b7db[_0xf544('0x24')],_0x4ef714['filters']));_0x5a2d15['where'][_0xf544('0x9e')]=_0x3301e8['id'];if(_0x98b7db[_0xf544('0x24')]['filter']){_0x5a2d15['where']=_['merge'](_0x5a2d15[_0xf544('0x61')],{'$or':_[_0xf544('0x71')](_0x5a2d15[_0xf544('0x7f')],function(_0x372cd0){var _0x861ba0={};_0x861ba0[_0x372cd0]={'$like':'%'+_0x98b7db[_0xf544('0x24')][_0xf544('0x86')]+'%'};return _0x861ba0;})});}_0x5a2d15=_[_0xf544('0x37')]({},_0x5a2d15,_0x98b7db[_0xf544('0x87')]);return db[_0xf544('0x54')][_0xf544('0x15')]({'where':_0x5a2d15[_0xf544('0x61')]})[_0xf544('0x1a')](function(_0x1718ed){_0x4bff5c['count']=_0x1718ed;if(_0x98b7db[_0xf544('0x24')][_0xf544('0x9f')]){_0x5a2d15[_0xf544('0xa0')]=[{'all':!![]}];}return db['JscriptySessionReport']['findAll'](_0x5a2d15);})[_0xf544('0x1a')](function(_0x3900f8){_0x4bff5c[_0xf544('0xa1')]=_0x3900f8;return _0x4bff5c;});}})[_0xf544('0x1a')](respondWithFilteredResult(_0x35376b,_0x5a2d15))[_0xf544('0x28')](handleError(_0x35376b,null));};exports['uploadCsv']=function(_0x3dd560,_0x2c2586){try{if(!_0x3dd560[_0xf544('0x38')][_0xf544('0x62')]){throw new Error(_0xf544('0xa5'));}if(!_0x3dd560[_0xf544('0x38')][_0xf544('0xa6')]){throw new Error('No\x20association\x20keys\x20specified!');}if(!_0x3dd560[_0xf544('0x38')][_0xf544('0xa7')]){throw new Error(_0xf544('0xa8'));}if(!_0x3dd560['body']['socket_timestamp']){throw new Error(_0xf544('0xa9'));}var _0x3197ac=_0x3dd560[_0xf544('0x38')][_0xf544('0xa6')][_0xf544('0xaa')](',');var _0x312703=_0x3dd560[_0xf544('0x38')][_0xf544('0xa7')]['split'](',');if(!_0x3197ac['length']||!_0x312703[_0xf544('0x2a')]||_0x3197ac[_0xf544('0x2a')]!==_0x312703['length']){throw new Error(_0xf544('0xab'));}_0x3dd560[_0xf544('0x38')][_0xf544('0x81')]=_[_0xf544('0xac')](_0x3197ac,_0x312703);if(!_0x3dd560[_0xf544('0x38')][_0xf544('0x81')][_0xf544('0x7a')]){throw new Error(_0xf544('0xad'));}if(!_0x3dd560[_0xf544('0x38')][_0xf544('0x81')]['firstName']){throw new Error('No\x20firstName\x20column\x20specified');}var _0x3d7918=path[_0xf544('0x57')](config[_0xf544('0xae')],_0xf544('0xaf'),_0x3dd560[_0xf544('0xb0')]['filename']);fs[_0xf544('0xb1')](_0x3d7918,parseInt(_0xf544('0xb2'),0x8));var _0x3c83de=require(_0xf544('0xb3'))[_0xf544('0xb4')](path[_0xf544('0x57')](__dirname,'../../components/import/cm/csv'),[_0x3d7918,_0x3dd560[_0xf544('0x38')][_0xf544('0xa6')],_0x3dd560[_0xf544('0x38')][_0xf544('0xa7')],_0x3dd560['body'][_0xf544('0x62')],_0x3dd560['body']['CompanyId'],_0x3dd560[_0xf544('0x38')][_0xf544('0x5e')],_0x3dd560[_0xf544('0x38')]['socket_timestamp']]);return _0x2c2586['status'](0xc8)[_0xf544('0x12')]({'message':_0xf544('0xb5'),'pid':_0x3c83de[_0xf544('0xb6')]});}catch(_0x24a0b2){return _0x2c2586[_0xf544('0x11')](0x1f4)[_0xf544('0xb7')](_0x24a0b2);}};exports[_0xf544('0xb8')]=function(_0x24d1f9,_0x3e6b08){var _0x155102=fs[_0xf544('0xb9')](_0x24d1f9['file'][_0xf544('0x2')]);Papa[_0xf544('0xba')](_0x155102,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x708b31){return _0x3e6b08[_0xf544('0x11')](0xc8)[_0xf544('0x12')]({'file':_0x24d1f9[_0xf544('0xb0')],'fields':_0x708b31[_0xf544('0xbb')][_0xf544('0x81')]});}});};exports[_0xf544('0xbc')]=function(_0x18c527,_0x48bb12){return db[_0xf544('0xbd')][_0xf544('0x23')]({'raw':!![],'attributes':['id'],'where':{'role':_0xf544('0xbe')}})[_0xf544('0x1a')](function(_0x1fa9e5){var _0x10df7f=![];if(!_0x18c527['body']['ListId']){throw new Error(_0xf544('0xa5'));}if(!_0x18c527[_0xf544('0x38')][_0xf544('0xbf')][_0xf544('0x7a')]){throw new Error(_0xf544('0xad'));}if(!_0x18c527[_0xf544('0x38')]['binding']['firstName']){throw new Error(_0xf544('0xc0'));}if(!_0x18c527['body']['socket_timestamp']){throw new Error(_0xf544('0xa9'));}var _0x50993e=require(_0xf544('0xb3'))[_0xf544('0xb4')](path[_0xf544('0x57')](__dirname,_0xf544('0xc1')),[_0x18c527['params']['id'],JSON['stringify'](_0x18c527[_0xf544('0x38')]),JSON[_0xf544('0xc2')](_0x1fa9e5)]);_0x50993e['on']('message',function(){_0x10df7f=!![];return _0x48bb12[_0xf544('0x11')](0xc8)['json']({'message':_0xf544('0xc3'),'pid':_0x50993e['pid']});});_0x50993e['on'](_0xf544('0xc4'),function(_0x16432e){if(_0x16432e&&!_0x10df7f){return _0x48bb12[_0xf544('0x11')](0x1f4)['json']({'message':_0xf544('0xc5'),'pid':_0x50993e['pid']});}});})[_0xf544('0x28')](handleError(_0x48bb12,null));};exports[_0xf544('0xc6')]=function(_0x141aa3,_0xc63f22){return db['User'][_0xf544('0x23')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0xf544('0x1a')](function(_0xf82ec5){var _0x2bf7e6=![];if(!_0x141aa3[_0xf544('0x38')]['ListId']){throw new Error(_0xf544('0xa5'));}if(!_0x141aa3[_0xf544('0x38')]['binding'][_0xf544('0x7a')]){throw new Error(_0xf544('0xad'));}if(!_0x141aa3[_0xf544('0x38')][_0xf544('0xbf')][_0xf544('0xc7')]){throw new Error(_0xf544('0xc0'));}if(!_0x141aa3['body'][_0xf544('0xc8')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x3bc341=require(_0xf544('0xb3'))[_0xf544('0xb4')](path[_0xf544('0x57')](__dirname,_0xf544('0xc9')),[_0x141aa3[_0xf544('0x27')]['id'],JSON[_0xf544('0xc2')](_0x141aa3[_0xf544('0x38')]),JSON['stringify'](_0xf82ec5)]);_0x3bc341['on'](_0xf544('0xca'),function(){_0x2bf7e6=!![];return _0xc63f22['status'](0xc8)[_0xf544('0x12')]({'message':_0xf544('0xc3'),'pid':_0x3bc341['pid']});});_0x3bc341['on'](_0xf544('0xc4'),function(_0x4481ed){if(_0x4481ed&&!_0x2bf7e6){return _0xc63f22['status'](0x1f4)[_0xf544('0x12')]({'message':_0xf544('0xc5'),'pid':_0x3bc341[_0xf544('0xb6')]});}});})[_0xf544('0x28')](handleError(_0xc63f22,null));};exports[_0xf544('0xcb')]=function(_0x395e32,_0x16f5ca){var _0x425ae9=[_0xf544('0xcc'),_0xf544('0xcd'),_0xf544('0xce'),_0xf544('0xcf'),_0xf544('0xd0'),'whatsapp',_0xf544('0xd1')];var _0x178aa7={'offset':0x0,'order':qs[_0xf544('0x83')](_0xf544('0xd2'))},_0x3a87ce={'count':0x0,'rows':[]};Promise[_0xf544('0xd3')]()[_0xf544('0x1a')](function(){if(_0x395e32['query'][_0xf544('0xd4')]){if(!_[_0xf544('0xd5')](_0x425ae9,_0x395e32[_0xf544('0x24')][_0xf544('0xd4')][_0xf544('0xd6')]())){throw new Error('Invalid\x20channel');}_0x425ae9=[_0x395e32[_0xf544('0x24')][_0xf544('0xd4')]['toLowerCase']()];}if(_0x395e32[_0xf544('0x24')][_0xf544('0xd7')]){try{var _0xe0402c=JSON['parse'](_0x395e32[_0xf544('0x24')][_0xf544('0xd7')]);if(!moment(_0xe0402c[_0xf544('0x39')])[_0xf544('0xd8')]()){throw new Error('Invalid\x20date\x20for\x20range\x20from\x20filter');}if(!moment(_0xe0402c['to'])[_0xf544('0xd8')]()){throw new Error(_0xf544('0xd9'));}}catch(_0x5bb631){throw new Error('Invalid\x20createdAt\x20filter');}}if(!_0x395e32[_0xf544('0x24')][_0xf544('0x36')](_0xf544('0x9d'))){_0x178aa7[_0xf544('0x14')]=qs[_0xf544('0x14')](_0x395e32[_0xf544('0x24')][_0xf544('0x14')]||0xa);_0x178aa7[_0xf544('0x16')]=qs[_0xf544('0x16')](_0x395e32[_0xf544('0x24')]['offset']);}var _0x4c1155=_0x425ae9['map'](function(_0x49f785){if(_0x49f785===_0xf544('0xd1')){var _0x59141d={'attributes':['id',_0xf544('0xda'),_0xf544('0x32'),_0xf544('0xdb'),_0xf544('0xdc'),'callerid',_0xf544('0xdd'),_0xf544('0xde'),_0xf544('0xdf'),_0xf544('0xe0'),_0xf544('0xe1'),_0xf544('0xe2'),'userSecondDisposition','userThirdDisposition','UserId'],'where':{'ContactId':_0x395e32['params']['id']},'include':[{'model':db[_0xf544('0xbd')],'as':'User','attributes':['id',_0xf544('0x1f'),_0xf544('0xe3'),_0xf544('0xe4')]}],'order':[[_0xf544('0xe1'),_0xf544('0xe5')]]};if(_0x395e32[_0xf544('0x24')][_0xf544('0xd7')]){_0x59141d[_0xf544('0x61')]['createdAt']={'$gte':_0xe0402c[_0xf544('0x39')],'$lte':_0xe0402c['to']};}return db['VoiceCallReport'][_0xf544('0xe6')](_0x59141d)[_0xf544('0x1a')](function(_0x21c3cd){_0x3a87ce['count']+=_0x21c3cd[_0xf544('0x15')];return _[_0xf544('0x71')](_0x21c3cd[_0xf544('0xa1')],function(_0x5013a0){var _0x19eb82=_0x5013a0[_0xf544('0x3a')]({'plain':!![]});_0x19eb82['channel']=_0x49f785;if(_0x19eb82[_0xf544('0xbd')]){_0x19eb82['User']={'id':_0x19eb82[_0xf544('0xbd')]['id'],'name':_0x19eb82['User'][_0xf544('0x1f')],'fullname':_0x19eb82[_0xf544('0xbd')][_0xf544('0xe3')],'alias':_0x19eb82[_0xf544('0xbd')][_0xf544('0xe4')]};}return _0x19eb82;});});}else{var _0x330df9=_[_0xf544('0xe7')](_0x49f785)+(_0x49f785===_0xf544('0xcd')?_0xf544('0xe8'):_0xf544('0xe9'));var _0x3085b3={'attributes':['id',_0xf544('0xea'),_0xf544('0xeb'),'createdAt',_0xf544('0xe0'),_0xf544('0xec'),'secondDisposition',_0xf544('0xed'),'UserId',_0x330df9+'Id'],'where':{'ContactId':_0x395e32[_0xf544('0x27')]['id']},'include':[{'model':db[_0x330df9],'as':_0xf544('0xe9'),'attributes':['id','name',_0xf544('0xee')]},{'model':db[_0xf544('0xbd')],'as':_0xf544('0xef'),'attributes':['id',_0xf544('0x1f'),_0xf544('0xe3')]},{'model':db[_0xf544('0x66')],'as':_0xf544('0x67'),'attributes':['id','name',_0xf544('0x68')],'through':{'attributes':[]}}],'order':[[_0xf544('0xe1'),_0xf544('0xe5')]]};if(_0x395e32['query'][_0xf544('0xd7')]){_0x3085b3[_0xf544('0x61')][_0xf544('0xe1')]={'$gte':_0xe0402c['from'],'$lte':_0xe0402c['to']};}switch(_0x49f785){case _0xf544('0xcd'):_0x3085b3[_0xf544('0x7f')][_0xf544('0x60')](_0xf544('0xf0'),_0xf544('0xf1'),_0xf544('0xf2'),_0xf544('0xf3'),_0xf544('0xf4'),_0xf544('0xf5'),'ratingType',_0xf544('0xf6'),_0xf544('0xf7'));break;case _0xf544('0xcc'):_0x3085b3['attributes']['push'](_0xf544('0xf8'),_0xf544('0xf9'));break;case'openchannel':_0x3085b3[_0xf544('0x7f')][_0xf544('0x60')](_0xf544('0xfa'),'threadId');break;}return db[_[_0xf544('0xe7')](_0x49f785)+_0xf544('0xfb')]['findAndCountAll'](_0x3085b3)[_0xf544('0x1a')](function(_0x19f619){_0x3a87ce[_0xf544('0x15')]+=_0x19f619[_0xf544('0x15')];return _['map'](_0x19f619[_0xf544('0xa1')],function(_0x5d8498){var _0x2183c1=_0x5d8498[_0xf544('0x3a')]({'plain':!![]});_0x2183c1[_0xf544('0xd4')]=_0x49f785;if(_0x2183c1['Owner']){_0x2183c1[_0xf544('0xef')]={'id':_0x2183c1['Owner']['id'],'name':_0x2183c1[_0xf544('0xef')][_0xf544('0x1f')],'fullname':_0x2183c1['Owner']['fullname']};}return _0x2183c1;});});}});return Promise[_0xf544('0x65')](_0x4c1155);})[_0xf544('0x1a')](function(_0x518636){return _(_0x518636)[_0xf544('0xfc')]()['sortBy']('createdAt')[_0xf544('0xfd')]()[_0xf544('0xfe')]();})['then'](function(_0x4224a4){_0x3a87ce[_0xf544('0xa1')]=_0x178aa7['limit']?_0x4224a4['slice'](_0x178aa7['offset'],_0x178aa7[_0xf544('0x16')]+_0x178aa7[_0xf544('0x14')]):_0x4224a4;return _0x3a87ce;})[_0xf544('0x1a')](respondWithFilteredResult(_0x16f5ca,_0x178aa7))[_0xf544('0x28')](handleError(_0x16f5ca,null));};
\ No newline at end of file
+var _0x2e0b=['MailMessage','SmsInteraction','SmsMessage','FaxInteraction','CmContactHasItem','CmHopperFinal','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappQueueReport','create','isNil','dialTimezone','timezones','utcOffset','bulkCreate','each','duplicates','where','$or','push','ListId','findOrCreate','spread','hasOwnProperty','additionalPhones','contact','all','show','Tag','Tags','color','tag','Phones','ContactItemType','ItemType','sequelize','Phones.OrderBy','omit','map','cf_%d','$and','pickBy','format','isEmpty','table','cm_contacts','setFields','id\x20=\x20?','toParam','text','values','phone','getTags','findOne','filters','intersection','attributes','fields','model','order','sort','pick','filter','options','nolimit','limit','setTags','ids','setAdditionalPhones','OrderBy','item_types','items','ItemTypeId','description','contact\x20phone\x20exists','PHONE','CmHopperAdditionalPhone','item','literal','`ItemType`.OrderBy','CmHopperId','ItemType.OrderBy','getAdditionalPhones','duplicateAdditionalPhones','fromContactId','toContactId','rescheduleAdditionalPhones','hopperId','getHoppers','rawAttributes','ContactId','include','rows','getHopperHistories','CmHopperHistory','includeAll','getHopperFinals','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','split','binding_values','Incorrect\x20binding\x20parameters\x20passed!','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','join','root','server/files/tmp','filename','chmodSync','child_process','fork','../../components/import/cm/csv','CompanyId','File\x20uploaded\x20correctly!','createReadStream','parse','meta','import','User','agent','binding','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','pid','exit','error\x20child\x20process','importUpdates','getJourney','mail','chat','sms','openchannel','fax','voice','-createdAt','resolve','channel','includes','toLowerCase','Invalid\x20channel','range','isValid','Invalid\x20date\x20for\x20range\x20from\x20filter','Invalid\x20createdAt\x20filter','uniqueid','source','destination','callerid','starttime','endtime','duration','note','createdAt','userDisposition','userSecondDisposition','userThirdDisposition','UserId','fullname','alias','findAndCountAll','startCase','Website','closed','closedAt','disposition','secondDisposition','thirdDisposition','Account','key','DESC','browserName','customerIp','customerPort','osName','ratingMessage','ratingType','ratingValue','subject','substatus','externalUrl','Interaction','Owner','flatten','sortBy','reverse','value','slice','bluebird','util','path','ioredis','../../components/contacts','../../components/parsers/qs','../../config/logger','api','../../config/environment','../../config/environment/shared','../../mysqldb','defaults','redis','localhost','socket.io-emitter','./cmContact.socket','register','status','undefined','offset','count','set','json','update','then','destroy','error','stack','name','send','describe','getOptions','query','user','catch','CmContact','find','params','tags','keys','cf_','columnName','displayName','CmCustomField','findAll','length','custom','type','info','Custom\x20field\x20%s\x20not\x20found\x20on\x20cm_contacts\x20table','forEach','merge','body','from','get','mergeWith','isArray','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','ChatOfflineMessage','MailInteraction'];(function(_0x4828f3,_0x5774b6){var _0x8a2a6=function(_0x5d82dd){while(--_0x5d82dd){_0x4828f3['push'](_0x4828f3['shift']());}};_0x8a2a6(++_0x5774b6);}(_0x2e0b,0xc8));var _0xb2e0=function(_0x243cca,_0x514c2d){_0x243cca=_0x243cca-0x0;var _0xf94771=_0x2e0b[_0x243cca];return _0xf94771;};'use strict';var moment=require('moment');var BPromise=require(_0xb2e0('0x0'));var util=require(_0xb2e0('0x1'));var path=require(_0xb2e0('0x2'));var fs=require('fs');var _=require('lodash');var squel=require('squel');var Papa=require('papaparse');var Redis=require(_0xb2e0('0x3'));var contacts=require(_0xb2e0('0x4'));var qs=require(_0xb2e0('0x5'));var logger=require(_0xb2e0('0x6'))(_0xb2e0('0x7'));var config=require(_0xb2e0('0x8'));var shared=require(_0xb2e0('0x9'));var db=require(_0xb2e0('0xa'))['db'];config['redis']=_[_0xb2e0('0xb')](config[_0xb2e0('0xc')],{'host':_0xb2e0('0xd'),'port':0x18eb});var socket=require(_0xb2e0('0xe'))(new Redis(config[_0xb2e0('0xc')]));require(_0xb2e0('0xf'))[_0xb2e0('0x10')](socket);function respondWithResult(_0x403c3b,_0x38431e){_0x38431e=_0x38431e||0xc8;return function(_0x48d827){if(_0x48d827){return _0x403c3b[_0xb2e0('0x11')](_0x38431e)['json'](_0x48d827);}};}function respondWithFilteredResult(_0x1dd361,_0x4d193b){return function(_0x15dc3f){if(_0x15dc3f){var _0x443a6c=typeof _0x4d193b['offset']==='undefined'&&typeof _0x4d193b['limit']===_0xb2e0('0x12');var _0x501f5e=_0x15dc3f['count'];var _0x25a0a4=_0x443a6c?0x0:_0x4d193b[_0xb2e0('0x13')];var _0x4073a0=_0x443a6c?_0x15dc3f[_0xb2e0('0x14')]:_0x4d193b[_0xb2e0('0x13')]+_0x4d193b['limit'];var _0x3b35f0;if(_0x4073a0>=_0x501f5e){_0x4073a0=_0x501f5e;_0x3b35f0=0xc8;}else{_0x3b35f0=0xce;}_0x1dd361[_0xb2e0('0x11')](_0x3b35f0);return _0x1dd361[_0xb2e0('0x15')]('Content-Range',_0x25a0a4+'-'+_0x4073a0+'/'+_0x501f5e)[_0xb2e0('0x16')](_0x15dc3f);}return null;};}function saveUpdates(_0x3c2e3f){return function(_0x3cbeea){if(_0x3cbeea){return _0x3cbeea[_0xb2e0('0x17')](_0x3c2e3f)[_0xb2e0('0x18')](function(_0x1c6228){return _0x1c6228;});}return null;};}function removeEntity(_0x491c3d){return function(_0xaa3c25){if(_0xaa3c25){return _0xaa3c25[_0xb2e0('0x19')]()[_0xb2e0('0x18')](function(){_0x491c3d[_0xb2e0('0x11')](0xcc)['end']();});}};}function handleEntityNotFound(_0xdbe8e7){return function(_0x530991){if(!_0x530991){_0xdbe8e7['sendStatus'](0x194);}return _0x530991;};}function handleError(_0x3caf19,_0x3eb989){_0x3eb989=_0x3eb989||0x1f4;return function(_0x2f4bee){logger[_0xb2e0('0x1a')](_0x2f4bee[_0xb2e0('0x1b')]);if(_0x2f4bee[_0xb2e0('0x1c')]){delete _0x2f4bee['name'];}_0x3caf19[_0xb2e0('0x11')](_0x3eb989)[_0xb2e0('0x1d')](_0x2f4bee);};}exports['index']=function(_0x407aae,_0x1fadce){var _0xd15daf={};return contacts[_0xb2e0('0x1e')]()[_0xb2e0('0x18')](function(_0xb931bd){_0xd15daf=qs[_0xb2e0('0x1f')](_0xb931bd,_0x407aae);return contacts['findAll'](_0x407aae[_0xb2e0('0x20')],_0x407aae[_0xb2e0('0x21')],_0xd15daf,_0xb931bd);})[_0xb2e0('0x18')](respondWithFilteredResult(_0x1fadce,_0xd15daf))[_0xb2e0('0x22')](handleError(_0x1fadce,null));};exports[_0xb2e0('0x19')]=function(_0x54a678,_0x58e7e5){return db[_0xb2e0('0x23')][_0xb2e0('0x24')]({'where':{'id':_0x54a678[_0xb2e0('0x25')]['id']}})['then'](handleEntityNotFound(_0x58e7e5,null))[_0xb2e0('0x18')](removeEntity(_0x58e7e5,null))[_0xb2e0('0x22')](handleError(_0x58e7e5,null));};exports[_0xb2e0('0x1e')]=function(_0xa1e3a8,_0x42890e){return db[_0xb2e0('0x23')][_0xb2e0('0x1e')]()[_0xb2e0('0x18')](function(_0x407e15){delete _0x407e15[_0xb2e0('0x26')];for(var _0x3e8e85=0x0;_0x3e8e85<Object[_0xb2e0('0x27')](_0x407e15)['length'];_0x3e8e85++){var _0x220056=Object['keys'](_0x407e15)[_0x3e8e85];if(!_['startsWith'](_0x220056,_0xb2e0('0x28'))){_0x407e15[_0x220056][_0xb2e0('0x29')]=_0x220056;_0x407e15[_0x220056][_0xb2e0('0x2a')]=_0x220056;}}return _0x407e15;})['then'](function(_0x4c1f43){var _0x216d93={'where':Boolean(_0xa1e3a8[_0xb2e0('0x20')]['analytics'])===!![]?undefined:{'$or':[{'ListId':_0xa1e3a8['query']['id']},{'ListId':null}]},'raw':!![]};return db[_0xb2e0('0x2b')][_0xb2e0('0x2c')](_0x216d93)[_0xb2e0('0x18')](function(_0x562642){for(var _0x2b8e15=0x0;_0x2b8e15<_0x562642[_0xb2e0('0x2d')];_0x2b8e15++){var _0x1f6915=_0xb2e0('0x28')+_0x562642[_0x2b8e15]['id'];if(_0x4c1f43[_0x1f6915]){_0x4c1f43[_0x1f6915][_0xb2e0('0x29')]=_0x1f6915;_0x4c1f43[_0x1f6915][_0xb2e0('0x2a')]=_0x562642[_0x2b8e15]['alias'];_0x4c1f43[_0x1f6915][_0xb2e0('0x2e')]={'type':_0x562642[_0x2b8e15][_0xb2e0('0x2f')],'values':_0x562642[_0x2b8e15]['values']};}else{logger[_0xb2e0('0x30')](_0xb2e0('0x31'),_0x1f6915);}}Object[_0xb2e0('0x27')](_0x4c1f43)[_0xb2e0('0x32')](function(_0x4048e5){if(!_0x4c1f43[_0x4048e5]['hasOwnProperty']('columnName')){delete _0x4c1f43[_0x4048e5];}});return _0x4c1f43;});})[_0xb2e0('0x18')](respondWithResult(_0x42890e,null))[_0xb2e0('0x22')](handleError(_0x42890e,null));};exports[_0xb2e0('0x33')]=function(_0x391900,_0x223c8c){var _0x4652d9;var _0x3a0076;var _0xb7ee0c;if(_0x391900['body']['id']){delete _0x391900['body']['id'];}return db[_0xb2e0('0x23')][_0xb2e0('0x2c')]({'where':{'id':[_0x391900[_0xb2e0('0x34')]['to'],_0x391900[_0xb2e0('0x34')][_0xb2e0('0x35')]]}})[_0xb2e0('0x18')](function(_0x3da7b7){if(_0x3da7b7){if(_0x3da7b7[_0xb2e0('0x2d')]!==0x2){return null;}_0x3da7b7[0x0]=_0x3da7b7[0x0]['get']({'plain':!![]});_0x3da7b7[0x1]=_0x3da7b7[0x1][_0xb2e0('0x36')]({'plain':!![]});delete _0x3da7b7[0x0]['id'];delete _0x3da7b7[0x1]['id'];return _[_0xb2e0('0x37')](_0x3da7b7[0x0],_0x3da7b7[0x1],function(_0x3b9b25,_0x43b2f8){if(Array[_0xb2e0('0x38')](_0x43b2f8)&&!_0x43b2f8['length']){return _0x3b9b25;}else if(!_0x43b2f8){return _0x3b9b25;}});}})[_0xb2e0('0x18')](handleEntityNotFound(_0x223c8c,null))[_0xb2e0('0x18')](function(_0x517621){if(_0x517621){if(_0x517621['tags']&&_[_0xb2e0('0x38')](_0x517621[_0xb2e0('0x26')])){_0x517621[_0xb2e0('0x26')]=_0x517621['tags']['join']();}logger[_0xb2e0('0x30')](_0xb2e0('0x39'),_0x391900['body']['to'],_0x391900[_0xb2e0('0x34')]['from']);return db[_0xb2e0('0x3a')][_0xb2e0('0x19')]({'where':{'ContactId':[_0x391900[_0xb2e0('0x34')]['to'],_0x391900[_0xb2e0('0x34')]['from']]}})[_0xb2e0('0x18')](function(_0x3b2752){logger[_0xb2e0('0x30')](_0xb2e0('0x3b'),_0x3b2752);return db[_0xb2e0('0x3c')][_0xb2e0('0x19')]({'where':{'ContactId':[_0x391900[_0xb2e0('0x34')]['to'],_0x391900[_0xb2e0('0x34')]['from']]}})[_0xb2e0('0x18')](function(_0x28a8fc){logger['info'](_0xb2e0('0x3d'),_0x28a8fc);return db[_0xb2e0('0x23')]['create'](_0x517621);});});}})[_0xb2e0('0x18')](function(_0x39dd9e){if(_0x39dd9e){_0x4652d9=_0x39dd9e;_0x3a0076={'ContactId':_0x4652d9['id']};_0xb7ee0c={'where':{'ContactId':[_0x391900[_0xb2e0('0x34')]['to'],_0x391900[_0xb2e0('0x34')][_0xb2e0('0x35')]]}};return db['ChatInteraction'][_0xb2e0('0x17')](_0x3a0076,_0xb7ee0c);}})['then'](function(){if(_0x4652d9){return db['ChatMessage'][_0xb2e0('0x17')](_0x3a0076,_0xb7ee0c);}})['then'](function(){if(_0x4652d9){return db[_0xb2e0('0x3e')][_0xb2e0('0x17')](_0x3a0076,_0xb7ee0c);}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return db[_0xb2e0('0x3f')][_0xb2e0('0x17')](_0x3a0076,_0xb7ee0c);}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return db[_0xb2e0('0x40')][_0xb2e0('0x17')](_0x3a0076,_0xb7ee0c);}})['then'](function(){if(_0x4652d9){return db[_0xb2e0('0x3f')][_0xb2e0('0x17')](_0x3a0076,_0xb7ee0c);}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return db[_0xb2e0('0x40')]['update'](_0x3a0076,_0xb7ee0c);}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return db[_0xb2e0('0x41')]['update'](_0x3a0076,_0xb7ee0c);}})['then'](function(){if(_0x4652d9){return db[_0xb2e0('0x42')]['update'](_0x3a0076,_0xb7ee0c);}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return db[_0xb2e0('0x43')]['update'](_0x3a0076,_0xb7ee0c);}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return db['FaxMessage'][_0xb2e0('0x17')](_0x3a0076,_0xb7ee0c);}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return db['OpenchannelInteraction'][_0xb2e0('0x17')](_0x3a0076,_0xb7ee0c);}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return db['OpenchannelMessage'][_0xb2e0('0x17')](_0x3a0076,_0xb7ee0c);}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return db[_0xb2e0('0x44')][_0xb2e0('0x17')]({'CmContactId':_0x4652d9['id']},{'where':{'CmContactId':[_0x391900['body']['to'],_0x391900[_0xb2e0('0x34')][_0xb2e0('0x35')]]}});}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return db[_0xb2e0('0x45')]['update'](_0x3a0076,_0xb7ee0c);}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return db['CmHopperHistory'][_0xb2e0('0x17')](_0x3a0076,_0xb7ee0c);}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return db['ReportAgentPreview'][_0xb2e0('0x17')](_0x3a0076,_0xb7ee0c);}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return db[_0xb2e0('0x46')][_0xb2e0('0x17')](_0x3a0076,_0xb7ee0c);}})['then'](function(){if(_0x4652d9){return db[_0xb2e0('0x47')]['update'](_0x3a0076,_0xb7ee0c);}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return db[_0xb2e0('0x48')][_0xb2e0('0x17')](_0x3a0076,_0xb7ee0c);}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return db[_0xb2e0('0x49')][_0xb2e0('0x17')](_0x3a0076,_0xb7ee0c);}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return db[_0xb2e0('0x4a')][_0xb2e0('0x17')](_0x3a0076,_0xb7ee0c);}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return db[_0xb2e0('0x4b')][_0xb2e0('0x17')](_0x3a0076,_0xb7ee0c);}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return db[_0xb2e0('0x4c')]['update'](_0x3a0076,_0xb7ee0c);}})['then'](function(){if(_0x4652d9){return db['WhatsappInteraction']['update'](_0x3a0076,_0xb7ee0c);}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return db['WhatsappMessage'][_0xb2e0('0x17')](_0x3a0076,_0xb7ee0c);}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return db[_0xb2e0('0x4d')][_0xb2e0('0x17')](_0x3a0076,_0xb7ee0c);}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return db[_0xb2e0('0x23')][_0xb2e0('0x19')]({'where':{'id':[_0x391900[_0xb2e0('0x34')]['to'],_0x391900['body'][_0xb2e0('0x35')]]}});}})[_0xb2e0('0x18')](function(){if(_0x4652d9){return _0x4652d9;}})[_0xb2e0('0x18')](respondWithResult(_0x223c8c,null))[_0xb2e0('0x22')](handleError(_0x223c8c,null));};exports[_0xb2e0('0x4e')]=function(_0x25c6cc,_0x400f91){return db['CmContact'][_0xb2e0('0x1e')]()['then'](function(_0x21c642){if(_0x25c6cc[_0xb2e0('0x34')][_0xb2e0('0x26')]&&_[_0xb2e0('0x38')](_0x25c6cc[_0xb2e0('0x34')][_0xb2e0('0x26')])){if(_0x25c6cc[_0xb2e0('0x34')][_0xb2e0('0x26')]['length']){_0x25c6cc[_0xb2e0('0x34')]['tags']=_0x25c6cc[_0xb2e0('0x34')][_0xb2e0('0x26')]['join'](';')+';';}else{_0x25c6cc[_0xb2e0('0x34')]['tags']=null;}}else{_0x25c6cc[_0xb2e0('0x34')][_0xb2e0('0x26')]=null;}if(!_[_0xb2e0('0x4f')](_0x25c6cc[_0xb2e0('0x34')][_0xb2e0('0x50')])){var _0x490ae0=_0x25c6cc['body']['dialTimezone'];if(!_['isNil'](shared[_0xb2e0('0x51')][_0x490ae0]))_0x25c6cc[_0xb2e0('0x34')]['utcOffset']=shared[_0xb2e0('0x51')][_0x490ae0][_0xb2e0('0x52')];}return db['CmContact'][_0xb2e0('0x4e')](_0x25c6cc[_0xb2e0('0x34')],{'fields':_[_0xb2e0('0x27')](_0x21c642),'raw':!![]});})[_0xb2e0('0x18')](function(_0x39557a){if(_0x25c6cc[_0xb2e0('0x34')]['additionalPhones']){return insertAdditionalPhones(_0x39557a,_0x25c6cc['body']['additionalPhones']);}else{return _0x39557a;}})['then'](respondWithResult(_0x400f91,0xc9))[_0xb2e0('0x22')](handleError(_0x400f91,null));};exports[_0xb2e0('0x53')]=function(_0x51890f,_0x56d6c0){var _0x2b6092=0x0;var _0x1d5b7e=0x0;var _0x201775=0x0;var _0x56bd11=[];return db[_0xb2e0('0x23')][_0xb2e0('0x1e')]()[_0xb2e0('0x18')](function(_0x3a9ff4){return BPromise[_0xb2e0('0x54')](_0x51890f[_0xb2e0('0x34')],function(_0x4fb602){var _0x5a1dce={'where':{'$or':[]},'defaults':_0x4fb602,'fields':_[_0xb2e0('0x27')](_0x3a9ff4),'raw':!![]};if(_0x4fb602[_0xb2e0('0x55')]){for(var _0x5f57f2=0x0;_0x5f57f2<_0x4fb602[_0xb2e0('0x55')][_0xb2e0('0x2d')];_0x5f57f2++){var _0x5e4213={};_0x5e4213[_0x4fb602['duplicates'][_0x5f57f2]]=_0x4fb602[_0x4fb602[_0xb2e0('0x55')][_0x5f57f2]];_0x5a1dce[_0xb2e0('0x56')][_0xb2e0('0x57')][_0xb2e0('0x58')](_0x5e4213);}_0x5a1dce[_0xb2e0('0x56')][_0xb2e0('0x59')]=_0x4fb602[_0xb2e0('0x59')];}return db[_0xb2e0('0x23')][_0xb2e0('0x5a')](_0x5a1dce)[_0xb2e0('0x5b')](function(_0x475e24,_0x104b9e){if(_0x104b9e){if(_0x4fb602[_0xb2e0('0x5c')](_0xb2e0('0x5d'))){_0x56bd11[_0xb2e0('0x58')]({'contact':_0x475e24,'additionalPhones':_0x4fb602['additionalPhones']});}_0x2b6092++;}else{_0x201775++;}})[_0xb2e0('0x22')](function(){_0x1d5b7e++;});});})[_0xb2e0('0x18')](function(_0x44bdfe){if(_0x44bdfe){if(_0x56bd11[_0xb2e0('0x2d')]>0x0){return new Promise(function(_0x323ace){var _0x3a2feb=[];for(var _0xb0e7c8=0x0;_0xb0e7c8<_0x56bd11[_0xb2e0('0x2d')];_0xb0e7c8++){_0x3a2feb[_0xb2e0('0x58')](insertAdditionalPhones(_0x56bd11[_0xb0e7c8][_0xb2e0('0x5e')],_0x56bd11[_0xb0e7c8][_0xb2e0('0x5d')]));}Promise[_0xb2e0('0x5f')](_0x3a2feb)[_0xb2e0('0x18')](function(){_0x323ace(0x1);});})[_0xb2e0('0x18')](function(){return{'success':_0x2b6092,'failure':_0x1d5b7e,'duplicates':_0x201775};});}else{return{'success':_0x2b6092,'failure':_0x1d5b7e,'duplicates':_0x201775};}}})[_0xb2e0('0x18')](respondWithResult(_0x56d6c0,0xc9))[_0xb2e0('0x22')](handleError(_0x56d6c0,null));};exports[_0xb2e0('0x60')]=function(_0x493258,_0x4fb72f){var _0x283854;return db[_0xb2e0('0x23')][_0xb2e0('0x1e')]()['then'](function(_0x33b9af){return db[_0xb2e0('0x23')][_0xb2e0('0x24')]({'where':{'id':_0x493258[_0xb2e0('0x25')]['id']},'include':[{'model':db[_0xb2e0('0x61')],'as':_0xb2e0('0x62'),'attributes':['id','name',_0xb2e0('0x63')],'required':_0x493258[_0xb2e0('0x20')][_0xb2e0('0x64')]?!![]:![]},{'model':db[_0xb2e0('0x44')],'as':_0xb2e0('0x65'),'where':{'CmContactId':_0x493258[_0xb2e0('0x25')]['id']},'required':![],'include':[{'model':db[_0xb2e0('0x66')],'as':_0xb2e0('0x67')}]}],'order':[db[_0xb2e0('0x68')]['literal'](_0xb2e0('0x69'))],'attributes':_[_0xb2e0('0x27')](_0x33b9af)});})[_0xb2e0('0x18')](function(_0x3c0688){if(!_['isNil'](_0x3c0688)){_0x283854=_0x3c0688[_0xb2e0('0x36')]({'plain':!![]});var _0x298cc9={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x3c0688&&_0x3c0688[_0xb2e0('0x59')]){if(_0x3c0688['ListId']){_0x298cc9[_0xb2e0('0x56')]['$and'][_0xb2e0('0x58')]({'ListId':{'$ne':_0x3c0688['ListId']}});}}return db['CmCustomField'][_0xb2e0('0x2c')](_0x298cc9);}})['then'](function(_0x206371){if(!_[_0xb2e0('0x4f')](_0x206371)){return _[_0xb2e0('0x6a')](_0x283854,_[_0xb2e0('0x6b')](_0x206371,function(_0x44ec32){return util['format'](_0xb2e0('0x6c'),_0x44ec32['id']);}));}})[_0xb2e0('0x18')](handleEntityNotFound(_0x4fb72f,null))[_0xb2e0('0x18')](respondWithResult(_0x4fb72f,null))[_0xb2e0('0x22')](handleError(_0x4fb72f,null));};exports[_0xb2e0('0x17')]=function(_0x553946,_0x5cc164){var _0x5ca3d0;if(_0x553946[_0xb2e0('0x34')]['id']){delete _0x553946[_0xb2e0('0x34')]['id'];}if(!_[_0xb2e0('0x4f')](_0x553946['body'][_0xb2e0('0x50')])){var _0x4e6e8f=_0x553946[_0xb2e0('0x34')]['dialTimezone'];if(!_[_0xb2e0('0x4f')](shared[_0xb2e0('0x51')][_0x4e6e8f]))_0x553946[_0xb2e0('0x34')][_0xb2e0('0x52')]=shared[_0xb2e0('0x51')][_0x4e6e8f]['utcOffset'];}return db['CmContact'][_0xb2e0('0x24')]({'where':{'id':_0x553946[_0xb2e0('0x25')]['id']}})[_0xb2e0('0x18')](handleEntityNotFound(_0x5cc164,null))[_0xb2e0('0x18')](saveUpdates(_0x553946[_0xb2e0('0x34')],null))['then'](function(_0x15f028){_0x5ca3d0=_0x15f028;var _0x70f369={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x15f028&&_0x15f028[_0xb2e0('0x59')]){if(_0x15f028[_0xb2e0('0x59')]){_0x70f369[_0xb2e0('0x56')][_0xb2e0('0x6d')][_0xb2e0('0x58')]({'ListId':{'$ne':_0x15f028[_0xb2e0('0x59')]}});}}return db['CmCustomField']['findAll'](_0x70f369);})[_0xb2e0('0x18')](function(_0x22747f){if(_0x22747f){return _[_0xb2e0('0x6a')](_[_0xb2e0('0x6e')](_0x553946['body'],function(_0x470ab6,_0x7e7064){return _['startsWith'](_0x7e7064,'cf_');}),_['map'](_0x22747f,function(_0xe63336){return util[_0xb2e0('0x6f')](_0xb2e0('0x6c'),_0xe63336['id']);}));}})['then'](function(_0x2ed2f7){if(_0x2ed2f7&&!_[_0xb2e0('0x70')](_0x2ed2f7)){var _0x220e2f=squel[_0xb2e0('0x17')]()[_0xb2e0('0x71')](_0xb2e0('0x72'))[_0xb2e0('0x73')](_0x2ed2f7)['where'](_0xb2e0('0x74'),_0x553946[_0xb2e0('0x25')]['id'])[_0xb2e0('0x75')]();return db[_0xb2e0('0x68')]['query'](_0x220e2f[_0xb2e0('0x76')],{'replacements':_0x220e2f[_0xb2e0('0x77')]});}})[_0xb2e0('0x18')](function(){if(_0x553946[_0xb2e0('0x34')][_0xb2e0('0x78')]&&_0x5ca3d0){return db[_0xb2e0('0x3a')]['update']({'phone':_0x553946[_0xb2e0('0x34')][_0xb2e0('0x78')],'OrderBy':0x0},{'where':{'ContactId':_0x5ca3d0['id']}});}})[_0xb2e0('0x18')](function(){return _0x5ca3d0;})[_0xb2e0('0x18')](respondWithResult(_0x5cc164,null))['catch'](handleError(_0x5cc164,null));};exports[_0xb2e0('0x79')]=function(_0x47361c,_0x1a99f5){var _0x3bf51c={};var _0x12bdc9={};var _0x3f45f8;var _0x4c22d5;return db[_0xb2e0('0x23')][_0xb2e0('0x7a')]({'where':{'id':_0x47361c[_0xb2e0('0x25')]['id']}})[_0xb2e0('0x18')](handleEntityNotFound(_0x1a99f5,null))[_0xb2e0('0x18')](function(_0x4a662a){if(_0x4a662a){_0x3f45f8=_0x4a662a;_0x12bdc9['model']=_['keys'](db[_0xb2e0('0x61')]['rawAttributes']);_0x12bdc9[_0xb2e0('0x20')]=_['keys'](_0x47361c[_0xb2e0('0x20')]);_0x12bdc9[_0xb2e0('0x7b')]=_[_0xb2e0('0x7c')](_0x12bdc9['model'],_0x12bdc9[_0xb2e0('0x20')]);_0x3bf51c[_0xb2e0('0x7d')]=_['intersection'](_0x12bdc9['model'],qs[_0xb2e0('0x7e')](_0x47361c['query'][_0xb2e0('0x7e')]));_0x3bf51c[_0xb2e0('0x7d')]=_0x3bf51c[_0xb2e0('0x7d')]['length']?_0x3bf51c[_0xb2e0('0x7d')]:_0x12bdc9[_0xb2e0('0x7f')];_0x3bf51c[_0xb2e0('0x80')]=qs[_0xb2e0('0x81')](_0x47361c[_0xb2e0('0x20')][_0xb2e0('0x81')]);_0x3bf51c[_0xb2e0('0x56')]=qs[_0xb2e0('0x7b')](_[_0xb2e0('0x82')](_0x47361c[_0xb2e0('0x20')],_0x12bdc9[_0xb2e0('0x7b')]));if(_0x47361c[_0xb2e0('0x20')][_0xb2e0('0x83')]){_0x3bf51c['where']=_[_0xb2e0('0x33')](_0x3bf51c[_0xb2e0('0x56')],{'$or':_[_0xb2e0('0x6b')](_0x3bf51c[_0xb2e0('0x7d')],function(_0x6fe8a2){var _0x1b4bbf={};_0x1b4bbf[_0x6fe8a2]={'$like':'%'+_0x47361c['query'][_0xb2e0('0x83')]+'%'};return _0x1b4bbf;})});}_0x3bf51c=_[_0xb2e0('0x33')]({},_0x3bf51c,_0x47361c[_0xb2e0('0x84')]);return _0x3f45f8['getTags'](_0x3bf51c);}})[_0xb2e0('0x18')](function(_0x4a561c){if(_0x4a561c){_0x4c22d5=_0x4a561c[_0xb2e0('0x2d')];if(!_0x47361c[_0xb2e0('0x20')][_0xb2e0('0x5c')](_0xb2e0('0x85'))){_0x3bf51c[_0xb2e0('0x86')]=qs['limit'](_0x47361c[_0xb2e0('0x20')][_0xb2e0('0x86')]);_0x3bf51c[_0xb2e0('0x13')]=qs[_0xb2e0('0x13')](_0x47361c['query'][_0xb2e0('0x13')]);}return _0x3f45f8[_0xb2e0('0x79')](_0x3bf51c);}})[_0xb2e0('0x18')](function(_0x57e928){if(_0x57e928){return _0x57e928?{'count':_0x4c22d5,'rows':_0x57e928}:null;}})['then'](respondWithResult(_0x1a99f5,null))[_0xb2e0('0x22')](handleError(_0x1a99f5,null));};exports[_0xb2e0('0x87')]=function(_0x51f62d,_0x282a96){if(_0x51f62d[_0xb2e0('0x34')]['id']){delete _0x51f62d['body']['id'];}return db['CmContact'][_0xb2e0('0x7a')]({'where':{'id':_0x51f62d[_0xb2e0('0x25')]['id']}})['then'](handleEntityNotFound(_0x282a96,null))[_0xb2e0('0x18')](function(_0x78ac77){if(_0x78ac77){return _0x78ac77[_0xb2e0('0x87')](_0x51f62d[_0xb2e0('0x34')][_0xb2e0('0x88')]||[]);}return null;})[_0xb2e0('0x18')](respondWithResult(_0x282a96,null))[_0xb2e0('0x22')](handleError(_0x282a96,null));};exports[_0xb2e0('0x89')]=function(_0x26be4c,_0xe577e4){var _0x2b82b2=[];_0x2b82b2['push'](addAdditionalPhones(_0x26be4c[_0xb2e0('0x34')]));Promise[_0xb2e0('0x5f')](_0x2b82b2)[_0xb2e0('0x18')](function(){_0x2b82b2=[];_0x2b82b2[_0xb2e0('0x58')](deleteCmHopperPhones(_0x26be4c[_0xb2e0('0x34')]['id']));_0x2b82b2[_0xb2e0('0x58')](addCmHopperPhones(_0x26be4c[_0xb2e0('0x34')]['id']));Promise[_0xb2e0('0x5f')](_0x2b82b2)[_0xb2e0('0x18')](function(){return[0x1];})[_0xb2e0('0x18')](respondWithResult(_0xe577e4,null));});};function addAdditionalPhones(_0x2c9521){var _0x4ed9a3;return new Promise(function(_0x3ddef8){return db[_0xb2e0('0x44')]['destroy']({'where':{'CmContactId':_0x2c9521['id']}})['then'](function(){db['ContactItemType']['findAll']({'raw':!![],'attributes':['id',_0xb2e0('0x8a')]})['then'](function(_0x1d03eb){var _0x2917c3=[];for(var _0x1493b6=0x0;_0x1493b6<_0x2c9521['items'][_0xb2e0('0x2d')];_0x1493b6++){var _0x51a29e=_0x2c9521['item_types']?_[_0xb2e0('0x4f')](_0x2c9521['item_types'][_0x1493b6])?'':_0x2c9521[_0xb2e0('0x8b')][_0x1493b6]:_0x2c9521[_0xb2e0('0x8c')][_0x1493b6][_0xb2e0('0x8d')]?_0x2c9521[_0xb2e0('0x8c')][_0x1493b6]['ItemTypeId']:'';var _0x5d64d2=_[_0xb2e0('0x4f')](_0x2c9521[_0xb2e0('0x8c')][_0x1493b6][_0xb2e0('0x8e')])?'':_0x2c9521[_0xb2e0('0x8c')][_0x1493b6][_0xb2e0('0x8e')];var _0x498931=_0x51a29e+':'+_0x2c9521['items'][_0x1493b6][_0xb2e0('0x78')]+'§'+_0x5d64d2;if(_[_0xb2e0('0x4f')](_0x4ed9a3))_0x4ed9a3=_0x498931;else _0x4ed9a3+=';'+_0x498931;var _0xe3b543=null;var _0x5d0fc2=null;if(_0x2c9521['item_types']){if(!_[_0xb2e0('0x4f')](_0x2c9521[_0xb2e0('0x8b')][_0x1493b6])){_0x5d0fc2=_[_0xb2e0('0x24')](_0x1d03eb,function(_0x3b9bd7){return _0x3b9bd7['id']===_0x2c9521[_0xb2e0('0x8b')][_0x1493b6];});if(!_[_0xb2e0('0x4f')](_0x5d0fc2)){_0xe3b543=_0x5d0fc2['OrderBy'];}}}else{if(!_[_0xb2e0('0x4f')](_0x2c9521[_0xb2e0('0x8c')][_0x1493b6])){_0x5d0fc2=_['find'](_0x1d03eb,function(_0x328032){return _0x328032['id']===_0x2c9521[_0xb2e0('0x8c')][_0x1493b6][_0xb2e0('0x8d')];});if(!_[_0xb2e0('0x4f')](_0x5d0fc2)){_0xe3b543=_0x1493b6;}}}if(_[_0xb2e0('0x4f')](_0xe3b543)){_0xe3b543=0x64;}_0x2917c3[_0xb2e0('0x58')](addAdditionalPhone(_0x2c9521['id'],_0x2c9521[_0xb2e0('0x8c')][_0x1493b6][_0xb2e0('0x78')],_0x2c9521[_0xb2e0('0x8b')]?_['isNil'](_0x2c9521['item_types'][_0x1493b6])?null:_0x2c9521[_0xb2e0('0x8b')][_0x1493b6]:_0x2c9521[_0xb2e0('0x8c')][_0x1493b6]['ItemTypeId']?_0x2c9521[_0xb2e0('0x8c')][_0x1493b6][_0xb2e0('0x8d')]:null,_0xe3b543,_0x5d64d2));}Promise[_0xb2e0('0x5f')](_0x2917c3)['then'](function(){db[_0xb2e0('0x23')]['update']({'AdditionalPhones':_0x4ed9a3},{'where':{'id':_0x2c9521['id']}})[_0xb2e0('0x18')](function(){_0x3ddef8(0x1);});});});});});}function addAdditionalPhone(_0x5daa9c,_0x17683a,_0x23b447,_0x3d698e,_0x34d7e0){return db[_0xb2e0('0x44')]['find']({'where':{'CmContactId':_0x5daa9c,'item':_0x17683a}})[_0xb2e0('0x18')](function(_0x2fd95f){if(_0x2fd95f)logger[_0xb2e0('0x30')](_0xb2e0('0x8f'),_0x2fd95f);else{db[_0xb2e0('0x44')][_0xb2e0('0x4e')]({'CmContactId':_0x5daa9c,'item':_0x17683a,'ItemTypeId':_0x23b447,'OrderBy':_0x3d698e,'ItemClass':_0xb2e0('0x90'),'description':_0x34d7e0});}});}function deleteCmHopperPhones(_0x2558eb){return new Promise(function(_0x5a9e31){return db[_0xb2e0('0x3a')][_0xb2e0('0x2c')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x2558eb}})['then'](function(_0x1fc90f){db[_0xb2e0('0x91')][_0xb2e0('0x19')]({'where':{'CmHopperId':{'$in':_[_0xb2e0('0x6b')](_0x1fc90f,'id')}}});})['then'](function(){_0x5a9e31(0x1);});});}function addCmHopperPhones(_0xd51bf5){return new Promise(function(_0x3b2213){return db[_0xb2e0('0x3a')][_0xb2e0('0x2c')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0xd51bf5}})[_0xb2e0('0x18')](function(_0x26a9ed){var _0x580083=[];_[_0xb2e0('0x6b')](_0x26a9ed,function(_0x2ec758){_0x580083[_0xb2e0('0x58')](createCmHopperPhone(_0xd51bf5,_0x2ec758['id']));});Promise['all'](_0x580083)[_0xb2e0('0x18')](function(){_0x3b2213(0x1);});});});}function createCmHopperPhone(_0x50ca0d,_0x119f92){return new Promise(function(_0x160975){db[_0xb2e0('0x44')][_0xb2e0('0x2c')]({'raw':!![],'attributes':[_0xb2e0('0x92'),'OrderBy'],'where':{'CmContactId':_0x50ca0d,'ItemClass':_0xb2e0('0x90')},'include':[{'model':db[_0xb2e0('0x66')],'attributes':['OrderBy'],'as':_0xb2e0('0x67')}],'order':[_0xb2e0('0x8a'),db[_0xb2e0('0x68')][_0xb2e0('0x93')](_0xb2e0('0x94'))]})[_0xb2e0('0x18')](function(_0x59a0cd){var _0x5db98c=0x1;var _0x5221a0=_[_0xb2e0('0x6b')](_0x59a0cd,function(_0x20094a){_0x20094a[_0xb2e0('0x95')]=_0x119f92;_0x20094a['phone']=_0x20094a[_0xb2e0('0x92')];_0x20094a[_0xb2e0('0x8a')]=_0x5db98c;delete _0x20094a[_0xb2e0('0x96')];_0x5db98c=_0x5db98c+0x1;return _0x20094a;});return db[_0xb2e0('0x91')][_0xb2e0('0x53')](_0x5221a0,{});})[_0xb2e0('0x18')](function(){_0x160975(0x1);});});}function insertAdditionalPhones(_0x4e8cf9,_0x121c2c){return new Promise(function(_0x2395e5){var _0x42f073=[];for(var _0x739298=0x0;_0x739298<_0x121c2c[_0xb2e0('0x2d')];_0x739298++){var _0xcc2e0c=_0x121c2c[_0x739298];_0x42f073[_0xb2e0('0x58')](parseContactItemType(_0xcc2e0c));}Promise[_0xb2e0('0x5f')](_0x42f073)[_0xb2e0('0x18')](function(){var _0x28c4d8={'id':_0x4e8cf9['id'],'items':_0x121c2c};return addAdditionalPhones(_0x28c4d8)[_0xb2e0('0x18')](function(){return addCmHopperPhones(_0x4e8cf9['id']);});})['then'](function(){_0x2395e5(_0x4e8cf9);});});}function parseContactItemType(_0x2f1227){return new Promise(function(_0x427a24){if(_0x2f1227[_0xb2e0('0x5c')]('ItemTypeId')){_0x427a24(_0x2f1227);}else{return db[_0xb2e0('0x66')][_0xb2e0('0x24')]({'where':{'name':_0x2f1227[_0xb2e0('0x67')]}})[_0xb2e0('0x18')](function(_0x3ecb53){if(_[_0xb2e0('0x4f')](_0x3ecb53))_0x2f1227['ItemTypeId']=null;else _0x2f1227[_0xb2e0('0x8d')]=_0x3ecb53['id'];_0x427a24(_0x2f1227);});}});}exports[_0xb2e0('0x97')]=function(_0x2d50c4,_0x4c48fe){return db[_0xb2e0('0x44')][_0xb2e0('0x2c')]({'raw':!![],'where':{'CmContactId':_0x2d50c4[_0xb2e0('0x25')]['id'],'ItemClass':'PHONE'},'include':[{'model':db[_0xb2e0('0x66')],'as':'ItemType'}],'order':[[_0xb2e0('0x8a')],[db['sequelize']['literal'](_0xb2e0('0x94'))]]})[_0xb2e0('0x18')](function(_0x1ab45b){return _0x1ab45b;})[_0xb2e0('0x18')](respondWithResult(_0x4c48fe,null))[_0xb2e0('0x22')](handleError(_0x4c48fe,null));};exports[_0xb2e0('0x98')]=function(_0x2550f6,_0x2ef3f5){return db[_0xb2e0('0x44')][_0xb2e0('0x2c')]({'raw':!![],'where':{'CmContactId':_0x2550f6[_0xb2e0('0x34')][_0xb2e0('0x99')]}})[_0xb2e0('0x18')](function(_0x5f396a){var _0x4a6426=_[_0xb2e0('0x6b')](_0x5f396a,function(_0x592ce0){_0x592ce0['CmContactId']=_0x2550f6[_0xb2e0('0x34')][_0xb2e0('0x9a')];return _0x592ce0;});return db[_0xb2e0('0x44')][_0xb2e0('0x53')](_0x4a6426,{});})['then'](function(){return addCmHopperPhones(_0x2550f6[_0xb2e0('0x34')][_0xb2e0('0x9a')]);})[_0xb2e0('0x18')](function(){return['ok'];})[_0xb2e0('0x18')](respondWithResult(_0x2ef3f5,null))['catch'](handleError(_0x2ef3f5,null));};exports[_0xb2e0('0x9b')]=function(_0x586adf,_0x4d3301){var _0x57757f=[];_0x57757f[_0xb2e0('0x58')](createCmHopperPhone(_0x586adf[_0xb2e0('0x34')]['id'],_0x586adf[_0xb2e0('0x34')][_0xb2e0('0x9c')]));Promise['all'](_0x57757f)[_0xb2e0('0x18')](function(){return[0x1];})['then'](respondWithResult(_0x4d3301,null));};exports[_0xb2e0('0x9d')]=function(_0xd275dd,_0x4ac9d7){var _0x256bb3={'raw':![],'where':{}};var _0x8c8fd4={};var _0x47bf0e={'count':0x0,'rows':[]};return db[_0xb2e0('0x23')][_0xb2e0('0x7a')]({'where':{'id':_0xd275dd['params']['id']}})[_0xb2e0('0x18')](handleEntityNotFound(_0x4ac9d7,null))['then'](function(_0x4e65c8){if(_0x4e65c8){_0x8c8fd4['model']=_[_0xb2e0('0x27')](db[_0xb2e0('0x3a')][_0xb2e0('0x9e')]);_0x8c8fd4[_0xb2e0('0x20')]=_[_0xb2e0('0x27')](_0xd275dd['query']);_0x8c8fd4['filters']=_['intersection'](_0x8c8fd4[_0xb2e0('0x7f')],_0x8c8fd4['query']);_0x256bb3[_0xb2e0('0x7d')]=_[_0xb2e0('0x7c')](_0x8c8fd4[_0xb2e0('0x7f')],qs[_0xb2e0('0x7e')](_0xd275dd[_0xb2e0('0x20')][_0xb2e0('0x7e')]));_0x256bb3[_0xb2e0('0x7d')]=_0x256bb3['attributes'][_0xb2e0('0x2d')]?_0x256bb3['attributes']:_0x8c8fd4[_0xb2e0('0x7f')];if(!_0xd275dd[_0xb2e0('0x20')][_0xb2e0('0x5c')](_0xb2e0('0x85'))){_0x256bb3[_0xb2e0('0x86')]=qs[_0xb2e0('0x86')](_0xd275dd[_0xb2e0('0x20')][_0xb2e0('0x86')]);_0x256bb3[_0xb2e0('0x13')]=qs[_0xb2e0('0x13')](_0xd275dd[_0xb2e0('0x20')]['offset']);}_0x256bb3['order']=qs[_0xb2e0('0x81')](_0xd275dd[_0xb2e0('0x20')][_0xb2e0('0x81')]);_0x256bb3[_0xb2e0('0x56')]=qs['filters'](_[_0xb2e0('0x82')](_0xd275dd[_0xb2e0('0x20')],_0x8c8fd4[_0xb2e0('0x7b')]));_0x256bb3[_0xb2e0('0x56')][_0xb2e0('0x9f')]=_0x4e65c8['id'];if(_0xd275dd[_0xb2e0('0x20')][_0xb2e0('0x83')]){_0x256bb3['where']=_[_0xb2e0('0x33')](_0x256bb3[_0xb2e0('0x56')],{'$or':_[_0xb2e0('0x6b')](_0x256bb3[_0xb2e0('0x7d')],function(_0x4205cf){var _0x5d5eb4={};_0x5d5eb4[_0x4205cf]={'$like':'%'+_0xd275dd[_0xb2e0('0x20')][_0xb2e0('0x83')]+'%'};return _0x5d5eb4;})});}_0x256bb3=_['merge']({},_0x256bb3,_0xd275dd['options']);return db[_0xb2e0('0x3a')][_0xb2e0('0x14')]({'where':_0x256bb3[_0xb2e0('0x56')]})['then'](function(_0x29c087){_0x47bf0e['count']=_0x29c087;if(_0xd275dd[_0xb2e0('0x20')]['includeAll']){_0x256bb3[_0xb2e0('0xa0')]=[{'all':!![]}];}return db['CmHopper'][_0xb2e0('0x2c')](_0x256bb3);})['then'](function(_0x71b21e){_0x47bf0e[_0xb2e0('0xa1')]=_0x71b21e;return _0x47bf0e;});}})[_0xb2e0('0x18')](respondWithFilteredResult(_0x4ac9d7,_0x256bb3))[_0xb2e0('0x22')](handleError(_0x4ac9d7,null));};exports[_0xb2e0('0xa2')]=function(_0x26abc3,_0x532a01){var _0x388b0a={'raw':!![],'where':{}};var _0x254abd={};var _0x4bfc6d={'count':0x0,'rows':[]};return db[_0xb2e0('0x23')][_0xb2e0('0x7a')]({'where':{'id':_0x26abc3[_0xb2e0('0x25')]['id']}})['then'](handleEntityNotFound(_0x532a01,null))['then'](function(_0x2d1ca0){if(_0x2d1ca0){_0x254abd[_0xb2e0('0x7f')]=_['keys'](db['CmHopperHistory'][_0xb2e0('0x9e')]);_0x254abd[_0xb2e0('0x20')]=_['keys'](_0x26abc3['query']);_0x254abd[_0xb2e0('0x7b')]=_[_0xb2e0('0x7c')](_0x254abd[_0xb2e0('0x7f')],_0x254abd['query']);_0x388b0a[_0xb2e0('0x7d')]=_[_0xb2e0('0x7c')](_0x254abd[_0xb2e0('0x7f')],qs['fields'](_0x26abc3[_0xb2e0('0x20')][_0xb2e0('0x7e')]));_0x388b0a[_0xb2e0('0x7d')]=_0x388b0a['attributes'][_0xb2e0('0x2d')]?_0x388b0a['attributes']:_0x254abd[_0xb2e0('0x7f')];if(!_0x26abc3[_0xb2e0('0x20')]['hasOwnProperty']('nolimit')){_0x388b0a['limit']=qs[_0xb2e0('0x86')](_0x26abc3[_0xb2e0('0x20')][_0xb2e0('0x86')]);_0x388b0a[_0xb2e0('0x13')]=qs[_0xb2e0('0x13')](_0x26abc3[_0xb2e0('0x20')][_0xb2e0('0x13')]);}_0x388b0a[_0xb2e0('0x80')]=qs[_0xb2e0('0x81')](_0x26abc3[_0xb2e0('0x20')][_0xb2e0('0x81')]);_0x388b0a[_0xb2e0('0x56')]=qs[_0xb2e0('0x7b')](_[_0xb2e0('0x82')](_0x26abc3['query'],_0x254abd[_0xb2e0('0x7b')]));_0x388b0a[_0xb2e0('0x56')][_0xb2e0('0x9f')]=_0x2d1ca0['id'];if(_0x26abc3[_0xb2e0('0x20')][_0xb2e0('0x83')]){_0x388b0a[_0xb2e0('0x56')]=_[_0xb2e0('0x33')](_0x388b0a[_0xb2e0('0x56')],{'$or':_[_0xb2e0('0x6b')](_0x388b0a['attributes'],function(_0x742cd7){var _0x329c0b={};_0x329c0b[_0x742cd7]={'$like':'%'+_0x26abc3[_0xb2e0('0x20')][_0xb2e0('0x83')]+'%'};return _0x329c0b;})});}_0x388b0a=_[_0xb2e0('0x33')]({},_0x388b0a,_0x26abc3[_0xb2e0('0x84')]);return db[_0xb2e0('0xa3')][_0xb2e0('0x14')]({'where':_0x388b0a[_0xb2e0('0x56')]})[_0xb2e0('0x18')](function(_0x10d88f){_0x4bfc6d['count']=_0x10d88f;if(_0x26abc3['query'][_0xb2e0('0xa4')]){_0x388b0a[_0xb2e0('0xa0')]=[{'all':!![]}];}return db['CmHopperHistory'][_0xb2e0('0x2c')](_0x388b0a);})[_0xb2e0('0x18')](function(_0x26775f){_0x4bfc6d[_0xb2e0('0xa1')]=_0x26775f;return _0x4bfc6d;});}})[_0xb2e0('0x18')](respondWithFilteredResult(_0x532a01,_0x388b0a))[_0xb2e0('0x22')](handleError(_0x532a01,null));};exports[_0xb2e0('0xa5')]=function(_0x785be2,_0x174d54){var _0x34f14e={'raw':!![],'where':{}};var _0x429855={};var _0x426e12={'count':0x0,'rows':[]};return db[_0xb2e0('0x23')][_0xb2e0('0x7a')]({'where':{'id':_0x785be2[_0xb2e0('0x25')]['id']}})[_0xb2e0('0x18')](handleEntityNotFound(_0x174d54,null))[_0xb2e0('0x18')](function(_0xf5bac7){if(_0xf5bac7){_0x429855[_0xb2e0('0x7f')]=_[_0xb2e0('0x27')](db[_0xb2e0('0x45')]['rawAttributes']);_0x429855[_0xb2e0('0x20')]=_['keys'](_0x785be2[_0xb2e0('0x20')]);_0x429855[_0xb2e0('0x7b')]=_[_0xb2e0('0x7c')](_0x429855[_0xb2e0('0x7f')],_0x429855[_0xb2e0('0x20')]);_0x34f14e[_0xb2e0('0x7d')]=_[_0xb2e0('0x7c')](_0x429855[_0xb2e0('0x7f')],qs[_0xb2e0('0x7e')](_0x785be2[_0xb2e0('0x20')][_0xb2e0('0x7e')]));_0x34f14e[_0xb2e0('0x7d')]=_0x34f14e[_0xb2e0('0x7d')]['length']?_0x34f14e['attributes']:_0x429855['model'];if(!_0x785be2['query'][_0xb2e0('0x5c')](_0xb2e0('0x85'))){_0x34f14e[_0xb2e0('0x86')]=qs[_0xb2e0('0x86')](_0x785be2['query']['limit']);_0x34f14e[_0xb2e0('0x13')]=qs[_0xb2e0('0x13')](_0x785be2[_0xb2e0('0x20')][_0xb2e0('0x13')]);}_0x34f14e[_0xb2e0('0x80')]=qs['sort'](_0x785be2[_0xb2e0('0x20')][_0xb2e0('0x81')]);_0x34f14e[_0xb2e0('0x56')]=qs['filters'](_['pick'](_0x785be2[_0xb2e0('0x20')],_0x429855['filters']));_0x34f14e['where'][_0xb2e0('0x9f')]=_0xf5bac7['id'];if(_0x785be2[_0xb2e0('0x20')][_0xb2e0('0x83')]){_0x34f14e[_0xb2e0('0x56')]=_['merge'](_0x34f14e[_0xb2e0('0x56')],{'$or':_[_0xb2e0('0x6b')](_0x34f14e[_0xb2e0('0x7d')],function(_0x33ec5c){var _0x26de0b={};_0x26de0b[_0x33ec5c]={'$like':'%'+_0x785be2[_0xb2e0('0x20')]['filter']+'%'};return _0x26de0b;})});}_0x34f14e=_['merge']({},_0x34f14e,_0x785be2[_0xb2e0('0x84')]);return db['CmHopperFinal'][_0xb2e0('0x14')]({'where':_0x34f14e[_0xb2e0('0x56')]})[_0xb2e0('0x18')](function(_0x1dc8e3){_0x426e12[_0xb2e0('0x14')]=_0x1dc8e3;if(_0x785be2[_0xb2e0('0x20')][_0xb2e0('0xa4')]){_0x34f14e[_0xb2e0('0xa0')]=[{'all':!![]}];}return db[_0xb2e0('0x45')][_0xb2e0('0x2c')](_0x34f14e);})['then'](function(_0x268a50){_0x426e12['rows']=_0x268a50;return _0x426e12;});}})[_0xb2e0('0x18')](respondWithFilteredResult(_0x174d54,_0x34f14e))[_0xb2e0('0x22')](handleError(_0x174d54,null));};exports['getJscriptySessions']=function(_0x3b7d42,_0x3234e6){var _0x286f1e={'raw':!![],'where':{}};var _0x5a0271={};var _0x504959={'count':0x0,'rows':[]};return db[_0xb2e0('0x23')][_0xb2e0('0x7a')]({'where':{'id':_0x3b7d42['params']['id']}})[_0xb2e0('0x18')](handleEntityNotFound(_0x3234e6,null))[_0xb2e0('0x18')](function(_0x5c749d){if(_0x5c749d){_0x5a0271['model']=_[_0xb2e0('0x27')](db[_0xb2e0('0x4c')]['rawAttributes']);_0x5a0271['query']=_[_0xb2e0('0x27')](_0x3b7d42['query']);_0x5a0271[_0xb2e0('0x7b')]=_['intersection'](_0x5a0271[_0xb2e0('0x7f')],_0x5a0271[_0xb2e0('0x20')]);_0x286f1e['attributes']=_[_0xb2e0('0x7c')](_0x5a0271[_0xb2e0('0x7f')],qs['fields'](_0x3b7d42[_0xb2e0('0x20')][_0xb2e0('0x7e')]));_0x286f1e[_0xb2e0('0x7d')]=_0x286f1e[_0xb2e0('0x7d')][_0xb2e0('0x2d')]?_0x286f1e[_0xb2e0('0x7d')]:_0x5a0271[_0xb2e0('0x7f')];if(!_0x3b7d42[_0xb2e0('0x20')][_0xb2e0('0x5c')]('nolimit')){_0x286f1e[_0xb2e0('0x86')]=qs['limit'](_0x3b7d42[_0xb2e0('0x20')]['limit']);_0x286f1e[_0xb2e0('0x13')]=qs[_0xb2e0('0x13')](_0x3b7d42[_0xb2e0('0x20')]['offset']);}_0x286f1e[_0xb2e0('0x80')]=qs[_0xb2e0('0x81')](_0x3b7d42['query'][_0xb2e0('0x81')]);_0x286f1e['where']=qs[_0xb2e0('0x7b')](_['pick'](_0x3b7d42[_0xb2e0('0x20')],_0x5a0271[_0xb2e0('0x7b')]));_0x286f1e[_0xb2e0('0x56')][_0xb2e0('0x9f')]=_0x5c749d['id'];if(_0x3b7d42[_0xb2e0('0x20')][_0xb2e0('0x83')]){_0x286f1e[_0xb2e0('0x56')]=_[_0xb2e0('0x33')](_0x286f1e[_0xb2e0('0x56')],{'$or':_[_0xb2e0('0x6b')](_0x286f1e[_0xb2e0('0x7d')],function(_0x2d7d06){var _0x466f8a={};_0x466f8a[_0x2d7d06]={'$like':'%'+_0x3b7d42[_0xb2e0('0x20')][_0xb2e0('0x83')]+'%'};return _0x466f8a;})});}_0x286f1e=_['merge']({},_0x286f1e,_0x3b7d42[_0xb2e0('0x84')]);return db['JscriptySessionReport'][_0xb2e0('0x14')]({'where':_0x286f1e['where']})['then'](function(_0x49ee8b){_0x504959[_0xb2e0('0x14')]=_0x49ee8b;if(_0x3b7d42[_0xb2e0('0x20')][_0xb2e0('0xa4')]){_0x286f1e['include']=[{'all':!![]}];}return db['JscriptySessionReport'][_0xb2e0('0x2c')](_0x286f1e);})[_0xb2e0('0x18')](function(_0xa2e6f4){_0x504959[_0xb2e0('0xa1')]=_0xa2e6f4;return _0x504959;});}})[_0xb2e0('0x18')](respondWithFilteredResult(_0x3234e6,_0x286f1e))[_0xb2e0('0x22')](handleError(_0x3234e6,null));};exports[_0xb2e0('0xa6')]=function(_0x3ae10d,_0x2656ac){try{if(!_0x3ae10d[_0xb2e0('0x34')][_0xb2e0('0x59')]){throw new Error(_0xb2e0('0xa7'));}if(!_0x3ae10d[_0xb2e0('0x34')][_0xb2e0('0xa8')]){throw new Error(_0xb2e0('0xa9'));}if(!_0x3ae10d[_0xb2e0('0x34')]['binding_values']){throw new Error(_0xb2e0('0xaa'));}if(!_0x3ae10d[_0xb2e0('0x34')][_0xb2e0('0xab')]){throw new Error(_0xb2e0('0xac'));}var _0x48c238=_0x3ae10d[_0xb2e0('0x34')]['binding_keys'][_0xb2e0('0xad')](',');var _0x1d0075=_0x3ae10d[_0xb2e0('0x34')][_0xb2e0('0xae')][_0xb2e0('0xad')](',');if(!_0x48c238['length']||!_0x1d0075[_0xb2e0('0x2d')]||_0x48c238[_0xb2e0('0x2d')]!==_0x1d0075[_0xb2e0('0x2d')]){throw new Error(_0xb2e0('0xaf'));}_0x3ae10d[_0xb2e0('0x34')][_0xb2e0('0x7e')]=_['zipObject'](_0x48c238,_0x1d0075);if(!_0x3ae10d['body']['fields'][_0xb2e0('0x78')]){throw new Error(_0xb2e0('0xb0'));}if(!_0x3ae10d['body']['fields'][_0xb2e0('0xb1')]){throw new Error(_0xb2e0('0xb2'));}var _0x57ccfe=path[_0xb2e0('0xb3')](config[_0xb2e0('0xb4')],_0xb2e0('0xb5'),_0x3ae10d['file'][_0xb2e0('0xb6')]);fs[_0xb2e0('0xb7')](_0x57ccfe,parseInt('0777',0x8));var _0xd1a1d6=require(_0xb2e0('0xb8'))[_0xb2e0('0xb9')](path[_0xb2e0('0xb3')](__dirname,_0xb2e0('0xba')),[_0x57ccfe,_0x3ae10d[_0xb2e0('0x34')]['binding_keys'],_0x3ae10d['body'][_0xb2e0('0xae')],_0x3ae10d[_0xb2e0('0x34')]['ListId'],_0x3ae10d[_0xb2e0('0x34')][_0xb2e0('0xbb')],_0x3ae10d[_0xb2e0('0x34')]['duplicates'],_0x3ae10d[_0xb2e0('0x34')][_0xb2e0('0xab')]]);return _0x2656ac[_0xb2e0('0x11')](0xc8)[_0xb2e0('0x16')]({'message':_0xb2e0('0xbc'),'pid':_0xd1a1d6['pid']});}catch(_0x55e260){return _0x2656ac[_0xb2e0('0x11')](0x1f4)[_0xb2e0('0x1d')](_0x55e260);}};exports['upload']=function(_0x31d3d7,_0x8ecd5f){var _0xaabfb2=fs[_0xb2e0('0xbd')](_0x31d3d7['file'][_0xb2e0('0x2')]);Papa[_0xb2e0('0xbe')](_0xaabfb2,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x171523){return _0x8ecd5f[_0xb2e0('0x11')](0xc8)[_0xb2e0('0x16')]({'file':_0x31d3d7['file'],'fields':_0x171523[_0xb2e0('0xbf')]['fields']});}});};exports[_0xb2e0('0xc0')]=function(_0x165a2b,_0x1e52f0){return db[_0xb2e0('0xc1')][_0xb2e0('0x2c')]({'raw':!![],'attributes':['id'],'where':{'role':_0xb2e0('0xc2')}})['then'](function(_0x57cd65){var _0x1d344c=![];if(!_0x165a2b['body'][_0xb2e0('0x59')]){throw new Error(_0xb2e0('0xa7'));}if(!_0x165a2b[_0xb2e0('0x34')][_0xb2e0('0xc3')][_0xb2e0('0x78')]){throw new Error(_0xb2e0('0xb0'));}if(!_0x165a2b['body']['binding'][_0xb2e0('0xb1')]){throw new Error(_0xb2e0('0xb2'));}if(!_0x165a2b['body'][_0xb2e0('0xab')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x2b5dad=require(_0xb2e0('0xb8'))[_0xb2e0('0xb9')](path['join'](__dirname,_0xb2e0('0xc4')),[_0x165a2b[_0xb2e0('0x25')]['id'],JSON[_0xb2e0('0xc5')](_0x165a2b['body']),JSON['stringify'](_0x57cd65)]);_0x2b5dad['on'](_0xb2e0('0xc6'),function(){_0x1d344c=!![];return _0x1e52f0[_0xb2e0('0x11')](0xc8)[_0xb2e0('0x16')]({'message':_0xb2e0('0xc7'),'pid':_0x2b5dad[_0xb2e0('0xc8')]});});_0x2b5dad['on'](_0xb2e0('0xc9'),function(_0x5e6403){if(_0x5e6403&&!_0x1d344c){return _0x1e52f0[_0xb2e0('0x11')](0x1f4)['json']({'message':_0xb2e0('0xca'),'pid':_0x2b5dad['pid']});}});})[_0xb2e0('0x22')](handleError(_0x1e52f0,null));};exports[_0xb2e0('0xcb')]=function(_0x32398d,_0x54052f){return db[_0xb2e0('0xc1')][_0xb2e0('0x2c')]({'raw':!![],'attributes':['id'],'where':{'role':_0xb2e0('0xc2')}})[_0xb2e0('0x18')](function(_0xcdc326){var _0x5d03b2=![];if(!_0x32398d['body'][_0xb2e0('0x59')]){throw new Error('No\x20ListId\x20specified');}if(!_0x32398d[_0xb2e0('0x34')]['binding'][_0xb2e0('0x78')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x32398d[_0xb2e0('0x34')][_0xb2e0('0xc3')]['firstName']){throw new Error(_0xb2e0('0xb2'));}if(!_0x32398d[_0xb2e0('0x34')][_0xb2e0('0xab')]){throw new Error(_0xb2e0('0xac'));}var _0x4ab722=require(_0xb2e0('0xb8'))['fork'](path[_0xb2e0('0xb3')](__dirname,'../../components/import/cm/csvUpdates'),[_0x32398d['params']['id'],JSON[_0xb2e0('0xc5')](_0x32398d[_0xb2e0('0x34')]),JSON[_0xb2e0('0xc5')](_0xcdc326)]);_0x4ab722['on'](_0xb2e0('0xc6'),function(){_0x5d03b2=!![];return _0x54052f[_0xb2e0('0x11')](0xc8)[_0xb2e0('0x16')]({'message':_0xb2e0('0xc7'),'pid':_0x4ab722['pid']});});_0x4ab722['on'](_0xb2e0('0xc9'),function(_0x5bb97a){if(_0x5bb97a&&!_0x5d03b2){return _0x54052f[_0xb2e0('0x11')](0x1f4)[_0xb2e0('0x16')]({'message':_0xb2e0('0xca'),'pid':_0x4ab722[_0xb2e0('0xc8')]});}});})['catch'](handleError(_0x54052f,null));};exports[_0xb2e0('0xcc')]=function(_0xca365a,_0x62a073){var _0x1adbc9=[_0xb2e0('0xcd'),_0xb2e0('0xce'),_0xb2e0('0xcf'),_0xb2e0('0xd0'),_0xb2e0('0xd1'),'whatsapp',_0xb2e0('0xd2')];var _0x3392e5={'offset':0x0,'order':qs[_0xb2e0('0x81')](_0xb2e0('0xd3'))},_0x191ee3={'count':0x0,'rows':[]};Promise[_0xb2e0('0xd4')]()[_0xb2e0('0x18')](function(){if(_0xca365a[_0xb2e0('0x20')][_0xb2e0('0xd5')]){if(!_[_0xb2e0('0xd6')](_0x1adbc9,_0xca365a[_0xb2e0('0x20')][_0xb2e0('0xd5')][_0xb2e0('0xd7')]())){throw new Error(_0xb2e0('0xd8'));}_0x1adbc9=[_0xca365a[_0xb2e0('0x20')][_0xb2e0('0xd5')][_0xb2e0('0xd7')]()];}if(_0xca365a[_0xb2e0('0x20')][_0xb2e0('0xd9')]){try{var _0x5696c1=JSON['parse'](_0xca365a[_0xb2e0('0x20')][_0xb2e0('0xd9')]);if(!moment(_0x5696c1[_0xb2e0('0x35')])[_0xb2e0('0xda')]()){throw new Error(_0xb2e0('0xdb'));}if(!moment(_0x5696c1['to'])[_0xb2e0('0xda')]()){throw new Error('Invalid\x20date\x20for\x20range\x20to\x20filter');}}catch(_0xb3af0b){throw new Error(_0xb2e0('0xdc'));}}if(!_0xca365a[_0xb2e0('0x20')]['hasOwnProperty'](_0xb2e0('0x85'))){_0x3392e5['limit']=qs[_0xb2e0('0x86')](_0xca365a[_0xb2e0('0x20')]['limit']||0xa);_0x3392e5['offset']=qs[_0xb2e0('0x13')](_0xca365a[_0xb2e0('0x20')][_0xb2e0('0x13')]);}var _0x5aaba0=_0x1adbc9[_0xb2e0('0x6b')](function(_0x59c452){if(_0x59c452===_0xb2e0('0xd2')){var _0x5941f3={'attributes':['id',_0xb2e0('0xdd'),_0xb2e0('0x2f'),_0xb2e0('0xde'),_0xb2e0('0xdf'),_0xb2e0('0xe0'),_0xb2e0('0xe1'),_0xb2e0('0xe2'),_0xb2e0('0xe3'),_0xb2e0('0xe4'),_0xb2e0('0xe5'),_0xb2e0('0xe6'),_0xb2e0('0xe7'),_0xb2e0('0xe8'),_0xb2e0('0xe9')],'where':{'ContactId':_0xca365a[_0xb2e0('0x25')]['id']},'include':[{'model':db[_0xb2e0('0xc1')],'as':_0xb2e0('0xc1'),'attributes':['id',_0xb2e0('0x1c'),_0xb2e0('0xea'),_0xb2e0('0xeb')]}],'order':[[_0xb2e0('0xe5'),'DESC']]};if(_0xca365a['query'][_0xb2e0('0xd9')]){_0x5941f3[_0xb2e0('0x56')][_0xb2e0('0xe5')]={'$gte':_0x5696c1[_0xb2e0('0x35')],'$lte':_0x5696c1['to']};}return db[_0xb2e0('0x46')][_0xb2e0('0xec')](_0x5941f3)['then'](function(_0x1ecef5){_0x191ee3['count']+=_0x1ecef5[_0xb2e0('0x14')];return _[_0xb2e0('0x6b')](_0x1ecef5[_0xb2e0('0xa1')],function(_0x4e32c7){var _0x1baf31=_0x4e32c7[_0xb2e0('0x36')]({'plain':!![]});_0x1baf31[_0xb2e0('0xd5')]=_0x59c452;if(_0x1baf31[_0xb2e0('0xc1')]){_0x1baf31[_0xb2e0('0xc1')]={'id':_0x1baf31[_0xb2e0('0xc1')]['id'],'name':_0x1baf31[_0xb2e0('0xc1')][_0xb2e0('0x1c')],'fullname':_0x1baf31['User'][_0xb2e0('0xea')],'alias':_0x1baf31['User'][_0xb2e0('0xeb')]};}return _0x1baf31;});});}else{var _0x556521=_[_0xb2e0('0xed')](_0x59c452)+(_0x59c452===_0xb2e0('0xce')?_0xb2e0('0xee'):'Account');var _0x56f277={'attributes':['id',_0xb2e0('0xef'),_0xb2e0('0xf0'),_0xb2e0('0xe5'),_0xb2e0('0xe4'),_0xb2e0('0xf1'),_0xb2e0('0xf2'),_0xb2e0('0xf3'),_0xb2e0('0xe9'),_0x556521+'Id'],'where':{'ContactId':_0xca365a[_0xb2e0('0x25')]['id']},'include':[{'model':db[_0x556521],'as':_0xb2e0('0xf4'),'attributes':['id',_0xb2e0('0x1c'),_0xb2e0('0xf5')]},{'model':db[_0xb2e0('0xc1')],'as':'Owner','attributes':['id',_0xb2e0('0x1c'),_0xb2e0('0xea')]},{'model':db[_0xb2e0('0x61')],'as':_0xb2e0('0x62'),'attributes':['id',_0xb2e0('0x1c'),_0xb2e0('0x63')],'through':{'attributes':[]}}],'order':[[_0xb2e0('0xe5'),_0xb2e0('0xf6')]]};if(_0xca365a[_0xb2e0('0x20')]['range']){_0x56f277[_0xb2e0('0x56')]['createdAt']={'$gte':_0x5696c1[_0xb2e0('0x35')],'$lte':_0x5696c1['to']};}switch(_0x59c452){case'chat':_0x56f277[_0xb2e0('0x7d')]['push'](_0xb2e0('0xf7'),_0xb2e0('0xf8'),_0xb2e0('0xf9'),'deviceModel',_0xb2e0('0xfa'),_0xb2e0('0xfb'),_0xb2e0('0xfc'),_0xb2e0('0xfd'),'referer');break;case _0xb2e0('0xcd'):_0x56f277[_0xb2e0('0x7d')]['push'](_0xb2e0('0xfe'),_0xb2e0('0xff'));break;case _0xb2e0('0xd0'):_0x56f277[_0xb2e0('0x7d')]['push'](_0xb2e0('0x100'),'threadId');break;}return db[_[_0xb2e0('0xed')](_0x59c452)+_0xb2e0('0x101')][_0xb2e0('0xec')](_0x56f277)[_0xb2e0('0x18')](function(_0x32ee4e){_0x191ee3[_0xb2e0('0x14')]+=_0x32ee4e[_0xb2e0('0x14')];return _['map'](_0x32ee4e['rows'],function(_0x258e7f){var _0x2bc281=_0x258e7f[_0xb2e0('0x36')]({'plain':!![]});_0x2bc281[_0xb2e0('0xd5')]=_0x59c452;if(_0x2bc281[_0xb2e0('0x102')]){_0x2bc281[_0xb2e0('0x102')]={'id':_0x2bc281[_0xb2e0('0x102')]['id'],'name':_0x2bc281[_0xb2e0('0x102')]['name'],'fullname':_0x2bc281[_0xb2e0('0x102')]['fullname']};}return _0x2bc281;});});}});return Promise[_0xb2e0('0x5f')](_0x5aaba0);})[_0xb2e0('0x18')](function(_0x24caea){return _(_0x24caea)[_0xb2e0('0x103')]()[_0xb2e0('0x104')](_0xb2e0('0xe5'))[_0xb2e0('0x105')]()[_0xb2e0('0x106')]();})[_0xb2e0('0x18')](function(_0x1baddf){_0x191ee3[_0xb2e0('0xa1')]=_0x3392e5[_0xb2e0('0x86')]?_0x1baddf[_0xb2e0('0x107')](_0x3392e5['offset'],_0x3392e5['offset']+_0x3392e5['limit']):_0x1baddf;return _0x191ee3;})['then'](respondWithFilteredResult(_0x62a073,_0x3392e5))[_0xb2e0('0x22')](handleError(_0x62a073,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff