// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xeedb=['keys','length','startsWith','cf_','columnName','displayName','CmCustomField','alias','custom','values','info','Custom\x20field\x20%s\x20not\x20found\x20on\x20cm_contacts\x20table','forEach','hasOwnProperty','merge','body','from','get','mergeWith','isArray','tags','join','[CmContact][merge]\x20to\x20%s\x20from\x20%s','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','update','ChatOfflineMessage','MailInteraction','SmsInteraction','SmsMessage','FaxInteraction','OpenchannelInteraction','OpenchannelMessage','CmContactHasItem','CmHopperHistory','ReportAgentPreview','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappMessage','describe','dialTimezone','timezones','utcOffset','additionalPhones','each','duplicates','where','$or','push','ListId','findOrCreate','spread','contact','all','Tag','Tags','color','tag','Phones','ContactItemType','literal','Phones.OrderBy','isNil','omit','format','$and','pickBy','map','cf_%d','isEmpty','table','cm_contacts','id\x20=\x20?','toParam','sequelize','text','phone','CmHopper','getTags','findOne','rawAttributes','filters','intersection','model','attributes','fields','order','sort','pick','filter','options','nolimit','setTags','ids','setAdditionalPhones','OrderBy','items','item_types','ItemTypeId','description','contact\x20phone\x20exists','PHONE','item','ItemType','`ItemType`.OrderBy','CmHopperId','ItemType.OrderBy','CmHopperAdditionalPhone','bulkCreate','getAdditionalPhones','duplicateAdditionalPhones','fromContactId','CmContactId','toContactId','rescheduleAdditionalPhones','hopperId','getHoppers','ContactId','includeAll','include','rows','getHopperHistories','getHopperFinals','CmHopperFinal','getJscriptySessions','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','split','zipObject','root','server/files/tmp','file','filename','chmodSync','0777','child_process','fork','../../components/import/cm/csv','CompanyId','File\x20uploaded\x20correctly!','pid','upload','createReadStream','path','parse','meta','import','User','agent','binding','No\x20phone\x20column\x20specified','firstName','../../components/import/cm/csv2','stringify','start\x20child\x20process\x20correctly!','exit','error\x20child\x20process','importUpdates','No\x20firstName\x20column\x20specified','message','getJourney','sms','openchannel','fax','whatsapp','voice','resolve','channel','includes','toLowerCase','range','isValid','Invalid\x20date\x20for\x20range\x20from\x20filter','Invalid\x20createdAt\x20filter','uniqueid','type','destination','endtime','duration','note','createdAt','userDisposition','userSecondDisposition','userThirdDisposition','UserId','fullname','DESC','VoiceCallReport','startCase','Website','Account','closed','thirdDisposition','Owner','chat','customerIp','customerPort','deviceModel','osName','ratingMessage','ratingValue','referer','substatus','externalUrl','threadId','Interaction','findAndCountAll','flatten','reverse','slice','moment','bluebird','util','lodash','squel','papaparse','../../config/logger','api','../../config/environment','../../config/environment/shared','../../mysqldb','defaults','socket.io-emitter','redis','./cmContact.socket','register','undefined','limit','count','offset','status','set','Content-Range','json','then','end','sendStatus','stack','name','send','getOptions','findAll','query','catch','destroy','find','params','CmContact'];(function(_0x3de8a4,_0x289a5c){var _0x4635cf=function(_0x2bddb8){while(--_0x2bddb8){_0x3de8a4['push'](_0x3de8a4['shift']());}};_0x4635cf(++_0x289a5c);}(_0xeedb,0xdc));var _0xbeed=function(_0x24237f,_0x4cf32c){_0x24237f=_0x24237f-0x0;var _0x48298e=_0xeedb[_0x24237f];return _0x48298e;};'use strict';var moment=require(_0xbeed('0x0'));var BPromise=require(_0xbeed('0x1'));var util=require(_0xbeed('0x2'));var path=require('path');var fs=require('fs');var _=require(_0xbeed('0x3'));var squel=require(_0xbeed('0x4'));var Papa=require(_0xbeed('0x5'));var Redis=require('ioredis');var contacts=require('../../components/contacts');var qs=require('../../components/parsers/qs');var logger=require(_0xbeed('0x6'))(_0xbeed('0x7'));var config=require(_0xbeed('0x8'));var shared=require(_0xbeed('0x9'));var db=require(_0xbeed('0xa'))['db'];config['redis']=_[_0xbeed('0xb')](config['redis'],{'host':'localhost','port':0x18eb});var socket=require(_0xbeed('0xc'))(new Redis(config[_0xbeed('0xd')]));require(_0xbeed('0xe'))[_0xbeed('0xf')](socket);function respondWithResult(_0x20d0d5,_0x463549){_0x463549=_0x463549||0xc8;return function(_0x52ec96){if(_0x52ec96){return _0x20d0d5['status'](_0x463549)['json'](_0x52ec96);}};}function respondWithFilteredResult(_0xb20a12,_0x200d08){return function(_0x46daef){if(_0x46daef){var _0x1ae630=typeof _0x200d08['offset']===_0xbeed('0x10')&&typeof _0x200d08[_0xbeed('0x11')]===_0xbeed('0x10');var _0x54bad5=_0x46daef[_0xbeed('0x12')];var _0x4c525f=_0x1ae630?0x0:_0x200d08[_0xbeed('0x13')];var _0xfc5f94=_0x1ae630?_0x46daef['count']:_0x200d08[_0xbeed('0x13')]+_0x200d08[_0xbeed('0x11')];var _0x52975e;if(_0xfc5f94>=_0x54bad5){_0xfc5f94=_0x54bad5;_0x52975e=0xc8;}else{_0x52975e=0xce;}_0xb20a12[_0xbeed('0x14')](_0x52975e);return _0xb20a12[_0xbeed('0x15')](_0xbeed('0x16'),_0x4c525f+'-'+_0xfc5f94+'/'+_0x54bad5)[_0xbeed('0x17')](_0x46daef);}return null;};}function saveUpdates(_0x1c2759){return function(_0xc33c58){if(_0xc33c58){return _0xc33c58['update'](_0x1c2759)[_0xbeed('0x18')](function(_0x2bbf94){return _0x2bbf94;});}return null;};}function removeEntity(_0x49d15a){return function(_0x25b396){if(_0x25b396){return _0x25b396['destroy']()[_0xbeed('0x18')](function(){_0x49d15a[_0xbeed('0x14')](0xcc)[_0xbeed('0x19')]();});}};}function handleEntityNotFound(_0x31d30b){return function(_0xe99fc0){if(!_0xe99fc0){_0x31d30b[_0xbeed('0x1a')](0x194);}return _0xe99fc0;};}function handleError(_0x190c2a,_0x1b7230){_0x1b7230=_0x1b7230||0x1f4;return function(_0x548284){logger['error'](_0x548284[_0xbeed('0x1b')]);if(_0x548284[_0xbeed('0x1c')]){delete _0x548284[_0xbeed('0x1c')];}_0x190c2a[_0xbeed('0x14')](_0x1b7230)[_0xbeed('0x1d')](_0x548284);};}exports['index']=function(_0x598693,_0x3b2da5){var _0x3e5431={};return contacts['describe']()[_0xbeed('0x18')](function(_0x47a195){_0x3e5431=qs[_0xbeed('0x1e')](_0x47a195,_0x598693);return contacts[_0xbeed('0x1f')](_0x598693[_0xbeed('0x20')],_0x598693['user'],_0x3e5431,_0x47a195);})[_0xbeed('0x18')](respondWithFilteredResult(_0x3b2da5,_0x3e5431))[_0xbeed('0x21')](handleError(_0x3b2da5,null));};exports[_0xbeed('0x22')]=function(_0xcaeef5,_0x5db5d7){return db['CmContact'][_0xbeed('0x23')]({'where':{'id':_0xcaeef5[_0xbeed('0x24')]['id']}})[_0xbeed('0x18')](handleEntityNotFound(_0x5db5d7,null))[_0xbeed('0x18')](removeEntity(_0x5db5d7,null))['catch'](handleError(_0x5db5d7,null));};exports['describe']=function(_0x4f4908,_0x37fcbf){return db[_0xbeed('0x25')]['describe']()[_0xbeed('0x18')](function(_0xa901df){delete _0xa901df['tags'];for(var _0x2d613c=0x0;_0x2d613c<Object[_0xbeed('0x26')](_0xa901df)[_0xbeed('0x27')];_0x2d613c++){var _0x3afaf6=Object['keys'](_0xa901df)[_0x2d613c];if(!_[_0xbeed('0x28')](_0x3afaf6,_0xbeed('0x29'))){_0xa901df[_0x3afaf6][_0xbeed('0x2a')]=_0x3afaf6;_0xa901df[_0x3afaf6][_0xbeed('0x2b')]=_0x3afaf6;}}return _0xa901df;})['then'](function(_0x3d4c5c){var _0x1e1339={'where':Boolean(_0x4f4908[_0xbeed('0x20')]['analytics'])===!![]?undefined:{'$or':[{'ListId':_0x4f4908[_0xbeed('0x20')]['id']},{'ListId':null}]},'raw':!![]};return db[_0xbeed('0x2c')][_0xbeed('0x1f')](_0x1e1339)[_0xbeed('0x18')](function(_0x461fb4){for(var _0x367796=0x0;_0x367796<_0x461fb4['length'];_0x367796++){var _0xe99ad7='cf_'+_0x461fb4[_0x367796]['id'];if(_0x3d4c5c[_0xe99ad7]){_0x3d4c5c[_0xe99ad7][_0xbeed('0x2a')]=_0xe99ad7;_0x3d4c5c[_0xe99ad7][_0xbeed('0x2b')]=_0x461fb4[_0x367796][_0xbeed('0x2d')];_0x3d4c5c[_0xe99ad7][_0xbeed('0x2e')]={'type':_0x461fb4[_0x367796]['type'],'values':_0x461fb4[_0x367796][_0xbeed('0x2f')]};}else{logger[_0xbeed('0x30')](_0xbeed('0x31'),_0xe99ad7);}}Object['keys'](_0x3d4c5c)[_0xbeed('0x32')](function(_0x343d6a){if(!_0x3d4c5c[_0x343d6a][_0xbeed('0x33')](_0xbeed('0x2a'))){delete _0x3d4c5c[_0x343d6a];}});return _0x3d4c5c;});})[_0xbeed('0x18')](respondWithResult(_0x37fcbf,null))[_0xbeed('0x21')](handleError(_0x37fcbf,null));};exports[_0xbeed('0x34')]=function(_0x51ace2,_0x26bfa9){var _0x16c224;var _0xcbb99f;var _0x1d53e9;if(_0x51ace2[_0xbeed('0x35')]['id']){delete _0x51ace2[_0xbeed('0x35')]['id'];}return db[_0xbeed('0x25')][_0xbeed('0x1f')]({'where':{'id':[_0x51ace2[_0xbeed('0x35')]['to'],_0x51ace2[_0xbeed('0x35')][_0xbeed('0x36')]]}})[_0xbeed('0x18')](function(_0x19afb5){if(_0x19afb5){if(_0x19afb5[_0xbeed('0x27')]!==0x2){return null;}_0x19afb5[0x0]=_0x19afb5[0x0][_0xbeed('0x37')]({'plain':!![]});_0x19afb5[0x1]=_0x19afb5[0x1][_0xbeed('0x37')]({'plain':!![]});delete _0x19afb5[0x0]['id'];delete _0x19afb5[0x1]['id'];return _[_0xbeed('0x38')](_0x19afb5[0x0],_0x19afb5[0x1],function(_0xb91231,_0x143ca3){if(Array[_0xbeed('0x39')](_0x143ca3)&&!_0x143ca3['length']){return _0xb91231;}else if(!_0x143ca3){return _0xb91231;}});}})[_0xbeed('0x18')](handleEntityNotFound(_0x26bfa9,null))[_0xbeed('0x18')](function(_0x46dd5d){if(_0x46dd5d){if(_0x46dd5d['tags']&&_[_0xbeed('0x39')](_0x46dd5d[_0xbeed('0x3a')])){_0x46dd5d['tags']=_0x46dd5d[_0xbeed('0x3a')][_0xbeed('0x3b')]();}logger['info'](_0xbeed('0x3c'),_0x51ace2[_0xbeed('0x35')]['to'],_0x51ace2[_0xbeed('0x35')][_0xbeed('0x36')]);return db['CmHopper'][_0xbeed('0x22')]({'where':{'ContactId':[_0x51ace2['body']['to'],_0x51ace2[_0xbeed('0x35')][_0xbeed('0x36')]]}})[_0xbeed('0x18')](function(_0x4143f0){logger[_0xbeed('0x30')]('[CmContact][merge][destroy][CmHopper],\x20%s',_0x4143f0);return db['CmHopperBlack'][_0xbeed('0x22')]({'where':{'ContactId':[_0x51ace2[_0xbeed('0x35')]['to'],_0x51ace2[_0xbeed('0x35')][_0xbeed('0x36')]]}})[_0xbeed('0x18')](function(_0x4906c3){logger[_0xbeed('0x30')](_0xbeed('0x3d'),_0x4906c3);return db[_0xbeed('0x25')][_0xbeed('0x3e')](_0x46dd5d);});});}})['then'](function(_0x50fa44){if(_0x50fa44){_0x16c224=_0x50fa44;_0xcbb99f={'ContactId':_0x16c224['id']};_0x1d53e9={'where':{'ContactId':[_0x51ace2[_0xbeed('0x35')]['to'],_0x51ace2['body'][_0xbeed('0x36')]]}};return db[_0xbeed('0x3f')][_0xbeed('0x40')](_0xcbb99f,_0x1d53e9);}})[_0xbeed('0x18')](function(){if(_0x16c224){return db['ChatMessage'][_0xbeed('0x40')](_0xcbb99f,_0x1d53e9);}})['then'](function(){if(_0x16c224){return db[_0xbeed('0x41')][_0xbeed('0x40')](_0xcbb99f,_0x1d53e9);}})['then'](function(){if(_0x16c224){return db['MailInteraction'][_0xbeed('0x40')](_0xcbb99f,_0x1d53e9);}})['then'](function(){if(_0x16c224){return db['MailMessage'][_0xbeed('0x40')](_0xcbb99f,_0x1d53e9);}})[_0xbeed('0x18')](function(){if(_0x16c224){return db[_0xbeed('0x42')][_0xbeed('0x40')](_0xcbb99f,_0x1d53e9);}})[_0xbeed('0x18')](function(){if(_0x16c224){return db['MailMessage'][_0xbeed('0x40')](_0xcbb99f,_0x1d53e9);}})[_0xbeed('0x18')](function(){if(_0x16c224){return db[_0xbeed('0x43')][_0xbeed('0x40')](_0xcbb99f,_0x1d53e9);}})[_0xbeed('0x18')](function(){if(_0x16c224){return db[_0xbeed('0x44')][_0xbeed('0x40')](_0xcbb99f,_0x1d53e9);}})[_0xbeed('0x18')](function(){if(_0x16c224){return db[_0xbeed('0x45')][_0xbeed('0x40')](_0xcbb99f,_0x1d53e9);}})['then'](function(){if(_0x16c224){return db['FaxMessage'][_0xbeed('0x40')](_0xcbb99f,_0x1d53e9);}})[_0xbeed('0x18')](function(){if(_0x16c224){return db[_0xbeed('0x46')]['update'](_0xcbb99f,_0x1d53e9);}})[_0xbeed('0x18')](function(){if(_0x16c224){return db[_0xbeed('0x47')][_0xbeed('0x40')](_0xcbb99f,_0x1d53e9);}})[_0xbeed('0x18')](function(){if(_0x16c224){return db[_0xbeed('0x48')][_0xbeed('0x40')]({'CmContactId':_0x16c224['id']},{'where':{'CmContactId':[_0x51ace2[_0xbeed('0x35')]['to'],_0x51ace2['body']['from']]}});}})[_0xbeed('0x18')](function(){if(_0x16c224){return db['CmHopperFinal'][_0xbeed('0x40')](_0xcbb99f,_0x1d53e9);}})[_0xbeed('0x18')](function(){if(_0x16c224){return db[_0xbeed('0x49')][_0xbeed('0x40')](_0xcbb99f,_0x1d53e9);}})[_0xbeed('0x18')](function(){if(_0x16c224){return db[_0xbeed('0x4a')]['update'](_0xcbb99f,_0x1d53e9);}})[_0xbeed('0x18')](function(){if(_0x16c224){return db['VoiceCallReport'][_0xbeed('0x40')](_0xcbb99f,_0x1d53e9);}})['then'](function(){if(_0x16c224){return db[_0xbeed('0x4b')][_0xbeed('0x40')](_0xcbb99f,_0x1d53e9);}})[_0xbeed('0x18')](function(){if(_0x16c224){return db[_0xbeed('0x4c')]['update'](_0xcbb99f,_0x1d53e9);}})[_0xbeed('0x18')](function(){if(_0x16c224){return db[_0xbeed('0x4d')]['update'](_0xcbb99f,_0x1d53e9);}})[_0xbeed('0x18')](function(){if(_0x16c224){return db[_0xbeed('0x4e')][_0xbeed('0x40')](_0xcbb99f,_0x1d53e9);}})['then'](function(){if(_0x16c224){return db[_0xbeed('0x4f')]['update'](_0xcbb99f,_0x1d53e9);}})[_0xbeed('0x18')](function(){if(_0x16c224){return db[_0xbeed('0x50')]['update'](_0xcbb99f,_0x1d53e9);}})['then'](function(){if(_0x16c224){return db[_0xbeed('0x51')][_0xbeed('0x40')](_0xcbb99f,_0x1d53e9);}})['then'](function(){if(_0x16c224){return db[_0xbeed('0x52')][_0xbeed('0x40')](_0xcbb99f,_0x1d53e9);}})[_0xbeed('0x18')](function(){if(_0x16c224){return db['WhatsappQueueReport']['update'](_0xcbb99f,_0x1d53e9);}})[_0xbeed('0x18')](function(){if(_0x16c224){return db[_0xbeed('0x25')]['destroy']({'where':{'id':[_0x51ace2['body']['to'],_0x51ace2[_0xbeed('0x35')]['from']]}});}})['then'](function(){if(_0x16c224){return _0x16c224;}})[_0xbeed('0x18')](respondWithResult(_0x26bfa9,null))[_0xbeed('0x21')](handleError(_0x26bfa9,null));};exports[_0xbeed('0x3e')]=function(_0x762609,_0x345ef3){return db['CmContact'][_0xbeed('0x53')]()[_0xbeed('0x18')](function(_0x4596fe){if(_0x762609[_0xbeed('0x35')]['tags']&&_[_0xbeed('0x39')](_0x762609[_0xbeed('0x35')][_0xbeed('0x3a')])){if(_0x762609[_0xbeed('0x35')][_0xbeed('0x3a')][_0xbeed('0x27')]){_0x762609[_0xbeed('0x35')]['tags']=_0x762609[_0xbeed('0x35')][_0xbeed('0x3a')][_0xbeed('0x3b')](';')+';';}else{_0x762609[_0xbeed('0x35')][_0xbeed('0x3a')]=null;}}else{_0x762609[_0xbeed('0x35')][_0xbeed('0x3a')]=null;}if(!_['isNil'](_0x762609[_0xbeed('0x35')][_0xbeed('0x54')])){var _0x5f599f=_0x762609[_0xbeed('0x35')][_0xbeed('0x54')];if(!_['isNil'](shared[_0xbeed('0x55')][_0x5f599f]))_0x762609['body']['utcOffset']=shared['timezones'][_0x5f599f][_0xbeed('0x56')];}return db[_0xbeed('0x25')]['create'](_0x762609[_0xbeed('0x35')],{'fields':_['keys'](_0x4596fe),'raw':!![]});})['then'](function(_0xbad302){if(_0x762609[_0xbeed('0x35')][_0xbeed('0x57')]){return insertAdditionalPhones(_0xbad302,_0x762609['body'][_0xbeed('0x57')]);}else{return _0xbad302;}})[_0xbeed('0x18')](respondWithResult(_0x345ef3,0xc9))['catch'](handleError(_0x345ef3,null));};exports['bulkCreate']=function(_0x24f191,_0x34600d){var _0x578ac6=0x0;var _0x2968f2=0x0;var _0xb9f448=0x0;var _0x1a7204=[];return db[_0xbeed('0x25')][_0xbeed('0x53')]()['then'](function(_0x484baf){return BPromise[_0xbeed('0x58')](_0x24f191[_0xbeed('0x35')],function(_0x543f17){var _0x24c23e={'where':{'$or':[]},'defaults':_0x543f17,'fields':_[_0xbeed('0x26')](_0x484baf),'raw':!![]};if(_0x543f17[_0xbeed('0x59')]){for(var _0x576884=0x0;_0x576884<_0x543f17[_0xbeed('0x59')]['length'];_0x576884++){var _0xda146c={};_0xda146c[_0x543f17[_0xbeed('0x59')][_0x576884]]=_0x543f17[_0x543f17['duplicates'][_0x576884]];_0x24c23e[_0xbeed('0x5a')][_0xbeed('0x5b')][_0xbeed('0x5c')](_0xda146c);}_0x24c23e['where'][_0xbeed('0x5d')]=_0x543f17[_0xbeed('0x5d')];}return db[_0xbeed('0x25')][_0xbeed('0x5e')](_0x24c23e)[_0xbeed('0x5f')](function(_0x5f444e,_0x31059f){if(_0x31059f){if(_0x543f17['hasOwnProperty'](_0xbeed('0x57'))){_0x1a7204[_0xbeed('0x5c')]({'contact':_0x5f444e,'additionalPhones':_0x543f17[_0xbeed('0x57')]});}_0x578ac6++;}else{_0xb9f448++;}})['catch'](function(){_0x2968f2++;});});})[_0xbeed('0x18')](function(_0x2b4150){if(_0x2b4150){if(_0x1a7204[_0xbeed('0x27')]>0x0){return new Promise(function(_0x124fb7){var _0x501b91=[];for(var _0x353242=0x0;_0x353242<_0x1a7204[_0xbeed('0x27')];_0x353242++){_0x501b91[_0xbeed('0x5c')](insertAdditionalPhones(_0x1a7204[_0x353242][_0xbeed('0x60')],_0x1a7204[_0x353242][_0xbeed('0x57')]));}Promise[_0xbeed('0x61')](_0x501b91)[_0xbeed('0x18')](function(){_0x124fb7(0x1);});})[_0xbeed('0x18')](function(){return{'success':_0x578ac6,'failure':_0x2968f2,'duplicates':_0xb9f448};});}else{return{'success':_0x578ac6,'failure':_0x2968f2,'duplicates':_0xb9f448};}}})[_0xbeed('0x18')](respondWithResult(_0x34600d,0xc9))[_0xbeed('0x21')](handleError(_0x34600d,null));};exports['show']=function(_0x52017e,_0x40cce7){var _0x4af432;return db[_0xbeed('0x25')]['describe']()[_0xbeed('0x18')](function(_0x61f9a7){return db[_0xbeed('0x25')][_0xbeed('0x23')]({'where':{'id':_0x52017e[_0xbeed('0x24')]['id']},'include':[{'model':db[_0xbeed('0x62')],'as':_0xbeed('0x63'),'attributes':['id',_0xbeed('0x1c'),_0xbeed('0x64')],'required':_0x52017e['query'][_0xbeed('0x65')]?!![]:![]},{'model':db[_0xbeed('0x48')],'as':_0xbeed('0x66'),'where':{'CmContactId':_0x52017e[_0xbeed('0x24')]['id']},'required':![],'include':[{'model':db[_0xbeed('0x67')],'as':'ItemType'}]}],'order':[db['sequelize'][_0xbeed('0x68')](_0xbeed('0x69'))],'attributes':_['keys'](_0x61f9a7)});})['then'](function(_0x1197e6){if(!_[_0xbeed('0x6a')](_0x1197e6)){_0x4af432=_0x1197e6[_0xbeed('0x37')]({'plain':!![]});var _0x1bb670={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x1197e6&&_0x1197e6[_0xbeed('0x5d')]){if(_0x1197e6[_0xbeed('0x5d')]){_0x1bb670['where']['$and'][_0xbeed('0x5c')]({'ListId':{'$ne':_0x1197e6[_0xbeed('0x5d')]}});}}return db[_0xbeed('0x2c')][_0xbeed('0x1f')](_0x1bb670);}})[_0xbeed('0x18')](function(_0x5c334f){if(!_[_0xbeed('0x6a')](_0x5c334f)){return _[_0xbeed('0x6b')](_0x4af432,_['map'](_0x5c334f,function(_0x2ef238){return util[_0xbeed('0x6c')]('cf_%d',_0x2ef238['id']);}));}})['then'](handleEntityNotFound(_0x40cce7,null))[_0xbeed('0x18')](respondWithResult(_0x40cce7,null))[_0xbeed('0x21')](handleError(_0x40cce7,null));};exports[_0xbeed('0x40')]=function(_0x26871c,_0x4f7237){var _0x1e3f4d;if(_0x26871c[_0xbeed('0x35')]['id']){delete _0x26871c['body']['id'];}if(!_[_0xbeed('0x6a')](_0x26871c[_0xbeed('0x35')][_0xbeed('0x54')])){var _0x30fe3d=_0x26871c['body'][_0xbeed('0x54')];if(!_[_0xbeed('0x6a')](shared['timezones'][_0x30fe3d]))_0x26871c[_0xbeed('0x35')][_0xbeed('0x56')]=shared[_0xbeed('0x55')][_0x30fe3d][_0xbeed('0x56')];}return db[_0xbeed('0x25')]['find']({'where':{'id':_0x26871c['params']['id']}})[_0xbeed('0x18')](handleEntityNotFound(_0x4f7237,null))['then'](saveUpdates(_0x26871c[_0xbeed('0x35')],null))[_0xbeed('0x18')](function(_0x11fe95){_0x1e3f4d=_0x11fe95;var _0x10c2ef={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x11fe95&&_0x11fe95[_0xbeed('0x5d')]){if(_0x11fe95[_0xbeed('0x5d')]){_0x10c2ef[_0xbeed('0x5a')][_0xbeed('0x6d')]['push']({'ListId':{'$ne':_0x11fe95[_0xbeed('0x5d')]}});}}return db[_0xbeed('0x2c')]['findAll'](_0x10c2ef);})['then'](function(_0x551990){if(_0x551990){return _[_0xbeed('0x6b')](_[_0xbeed('0x6e')](_0x26871c[_0xbeed('0x35')],function(_0x303d4d,_0x2ab586){return _[_0xbeed('0x28')](_0x2ab586,_0xbeed('0x29'));}),_[_0xbeed('0x6f')](_0x551990,function(_0x35378d){return util[_0xbeed('0x6c')](_0xbeed('0x70'),_0x35378d['id']);}));}})['then'](function(_0xcdd3b8){if(_0xcdd3b8&&!_[_0xbeed('0x71')](_0xcdd3b8)){var _0x175163=squel[_0xbeed('0x40')]()[_0xbeed('0x72')](_0xbeed('0x73'))['setFields'](_0xcdd3b8)[_0xbeed('0x5a')](_0xbeed('0x74'),_0x26871c[_0xbeed('0x24')]['id'])[_0xbeed('0x75')]();return db[_0xbeed('0x76')]['query'](_0x175163[_0xbeed('0x77')],{'replacements':_0x175163[_0xbeed('0x2f')]});}})['then'](function(){if(_0x26871c[_0xbeed('0x35')][_0xbeed('0x78')]&&_0x1e3f4d){return db[_0xbeed('0x79')]['update']({'phone':_0x26871c[_0xbeed('0x35')][_0xbeed('0x78')],'OrderBy':0x0},{'where':{'ContactId':_0x1e3f4d['id']}});}})[_0xbeed('0x18')](function(){return _0x1e3f4d;})[_0xbeed('0x18')](respondWithResult(_0x4f7237,null))[_0xbeed('0x21')](handleError(_0x4f7237,null));};exports[_0xbeed('0x7a')]=function(_0x273611,_0x53e993){var _0x5a2154={};var _0x223758={};var _0x482e17;var _0x17a928;return db[_0xbeed('0x25')][_0xbeed('0x7b')]({'where':{'id':_0x273611[_0xbeed('0x24')]['id']}})['then'](handleEntityNotFound(_0x53e993,null))[_0xbeed('0x18')](function(_0xb8ddd2){if(_0xb8ddd2){_0x482e17=_0xb8ddd2;_0x223758['model']=_[_0xbeed('0x26')](db[_0xbeed('0x62')][_0xbeed('0x7c')]);_0x223758[_0xbeed('0x20')]=_[_0xbeed('0x26')](_0x273611[_0xbeed('0x20')]);_0x223758[_0xbeed('0x7d')]=_[_0xbeed('0x7e')](_0x223758[_0xbeed('0x7f')],_0x223758[_0xbeed('0x20')]);_0x5a2154[_0xbeed('0x80')]=_[_0xbeed('0x7e')](_0x223758['model'],qs[_0xbeed('0x81')](_0x273611['query']['fields']));_0x5a2154[_0xbeed('0x80')]=_0x5a2154[_0xbeed('0x80')][_0xbeed('0x27')]?_0x5a2154[_0xbeed('0x80')]:_0x223758[_0xbeed('0x7f')];_0x5a2154[_0xbeed('0x82')]=qs['sort'](_0x273611[_0xbeed('0x20')][_0xbeed('0x83')]);_0x5a2154[_0xbeed('0x5a')]=qs[_0xbeed('0x7d')](_[_0xbeed('0x84')](_0x273611['query'],_0x223758[_0xbeed('0x7d')]));if(_0x273611[_0xbeed('0x20')][_0xbeed('0x85')]){_0x5a2154[_0xbeed('0x5a')]=_[_0xbeed('0x34')](_0x5a2154['where'],{'$or':_[_0xbeed('0x6f')](_0x5a2154[_0xbeed('0x80')],function(_0x2eeb43){var _0x1effb1={};_0x1effb1[_0x2eeb43]={'$like':'%'+_0x273611[_0xbeed('0x20')][_0xbeed('0x85')]+'%'};return _0x1effb1;})});}_0x5a2154=_[_0xbeed('0x34')]({},_0x5a2154,_0x273611[_0xbeed('0x86')]);return _0x482e17[_0xbeed('0x7a')](_0x5a2154);}})['then'](function(_0x5e2ebe){if(_0x5e2ebe){_0x17a928=_0x5e2ebe[_0xbeed('0x27')];if(!_0x273611['query'][_0xbeed('0x33')](_0xbeed('0x87'))){_0x5a2154[_0xbeed('0x11')]=qs['limit'](_0x273611['query']['limit']);_0x5a2154[_0xbeed('0x13')]=qs[_0xbeed('0x13')](_0x273611[_0xbeed('0x20')][_0xbeed('0x13')]);}return _0x482e17['getTags'](_0x5a2154);}})[_0xbeed('0x18')](function(_0x210731){if(_0x210731){return _0x210731?{'count':_0x17a928,'rows':_0x210731}:null;}})[_0xbeed('0x18')](respondWithResult(_0x53e993,null))['catch'](handleError(_0x53e993,null));};exports[_0xbeed('0x88')]=function(_0x5d0f77,_0x48a223){if(_0x5d0f77[_0xbeed('0x35')]['id']){delete _0x5d0f77['body']['id'];}return db[_0xbeed('0x25')][_0xbeed('0x7b')]({'where':{'id':_0x5d0f77['params']['id']}})[_0xbeed('0x18')](handleEntityNotFound(_0x48a223,null))[_0xbeed('0x18')](function(_0x134065){if(_0x134065){return _0x134065['setTags'](_0x5d0f77['body'][_0xbeed('0x89')]||[]);}return null;})['then'](respondWithResult(_0x48a223,null))['catch'](handleError(_0x48a223,null));};exports[_0xbeed('0x8a')]=function(_0x5cb948,_0x25cbeb){var _0x54b5b8=[];_0x54b5b8[_0xbeed('0x5c')](addAdditionalPhones(_0x5cb948[_0xbeed('0x35')]));Promise[_0xbeed('0x61')](_0x54b5b8)[_0xbeed('0x18')](function(){_0x54b5b8=[];_0x54b5b8[_0xbeed('0x5c')](deleteCmHopperPhones(_0x5cb948['body']['id']));_0x54b5b8['push'](addCmHopperPhones(_0x5cb948['body']['id']));Promise[_0xbeed('0x61')](_0x54b5b8)[_0xbeed('0x18')](function(){return[0x1];})[_0xbeed('0x18')](respondWithResult(_0x25cbeb,null));});};function addAdditionalPhones(_0x17c043){var _0x60a694;return new Promise(function(_0x5b9f53){return db['CmContactHasItem'][_0xbeed('0x22')]({'where':{'CmContactId':_0x17c043['id']}})[_0xbeed('0x18')](function(){db[_0xbeed('0x67')]['findAll']({'raw':!![],'attributes':['id',_0xbeed('0x8b')]})[_0xbeed('0x18')](function(_0xac63c9){var _0x371738=[];for(var _0x114083=0x0;_0x114083<_0x17c043[_0xbeed('0x8c')][_0xbeed('0x27')];_0x114083++){var _0x55064d=_0x17c043[_0xbeed('0x8d')]?_[_0xbeed('0x6a')](_0x17c043[_0xbeed('0x8d')][_0x114083])?'':_0x17c043[_0xbeed('0x8d')][_0x114083]:_0x17c043[_0xbeed('0x8c')][_0x114083][_0xbeed('0x8e')]?_0x17c043[_0xbeed('0x8c')][_0x114083]['ItemTypeId']:'';var _0xaef794=_[_0xbeed('0x6a')](_0x17c043[_0xbeed('0x8c')][_0x114083][_0xbeed('0x8f')])?'':_0x17c043[_0xbeed('0x8c')][_0x114083][_0xbeed('0x8f')];var _0x52e768=_0x55064d+':'+_0x17c043[_0xbeed('0x8c')][_0x114083][_0xbeed('0x78')]+'§'+_0xaef794;if(_[_0xbeed('0x6a')](_0x60a694))_0x60a694=_0x52e768;else _0x60a694+=';'+_0x52e768;var _0x64c922=null;var _0x1a8cd5=null;if(_0x17c043[_0xbeed('0x8d')]){if(!_[_0xbeed('0x6a')](_0x17c043[_0xbeed('0x8d')][_0x114083])){_0x1a8cd5=_[_0xbeed('0x23')](_0xac63c9,function(_0x2c6514){return _0x2c6514['id']===_0x17c043[_0xbeed('0x8d')][_0x114083];});if(!_[_0xbeed('0x6a')](_0x1a8cd5)){_0x64c922=_0x1a8cd5['OrderBy'];}}}else{if(!_[_0xbeed('0x6a')](_0x17c043[_0xbeed('0x8c')][_0x114083])){_0x1a8cd5=_[_0xbeed('0x23')](_0xac63c9,function(_0x240466){return _0x240466['id']===_0x17c043[_0xbeed('0x8c')][_0x114083][_0xbeed('0x8e')];});if(!_[_0xbeed('0x6a')](_0x1a8cd5)){_0x64c922=_0x114083;}}}if(_['isNil'](_0x64c922)){_0x64c922=0x64;}_0x371738[_0xbeed('0x5c')](addAdditionalPhone(_0x17c043['id'],_0x17c043[_0xbeed('0x8c')][_0x114083]['phone'],_0x17c043[_0xbeed('0x8d')]?_[_0xbeed('0x6a')](_0x17c043['item_types'][_0x114083])?null:_0x17c043[_0xbeed('0x8d')][_0x114083]:_0x17c043[_0xbeed('0x8c')][_0x114083][_0xbeed('0x8e')]?_0x17c043[_0xbeed('0x8c')][_0x114083][_0xbeed('0x8e')]:null,_0x64c922,_0xaef794));}Promise[_0xbeed('0x61')](_0x371738)[_0xbeed('0x18')](function(){db[_0xbeed('0x25')][_0xbeed('0x40')]({'AdditionalPhones':_0x60a694},{'where':{'id':_0x17c043['id']}})[_0xbeed('0x18')](function(){_0x5b9f53(0x1);});});});});});}function addAdditionalPhone(_0x1f68cc,_0x53ee77,_0x30b7e5,_0x454d02,_0x29a2a6){return db['CmContactHasItem'][_0xbeed('0x23')]({'where':{'CmContactId':_0x1f68cc,'item':_0x53ee77}})[_0xbeed('0x18')](function(_0x5e51af){if(_0x5e51af)logger[_0xbeed('0x30')](_0xbeed('0x90'),_0x5e51af);else{db[_0xbeed('0x48')][_0xbeed('0x3e')]({'CmContactId':_0x1f68cc,'item':_0x53ee77,'ItemTypeId':_0x30b7e5,'OrderBy':_0x454d02,'ItemClass':_0xbeed('0x91'),'description':_0x29a2a6});}});}function deleteCmHopperPhones(_0x43b40a){return new Promise(function(_0x33c4eb){return db[_0xbeed('0x79')]['findAll']({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x43b40a}})[_0xbeed('0x18')](function(_0x153d07){db['CmHopperAdditionalPhone']['destroy']({'where':{'CmHopperId':{'$in':_['map'](_0x153d07,'id')}}});})[_0xbeed('0x18')](function(){_0x33c4eb(0x1);});});}function addCmHopperPhones(_0x1b084f){return new Promise(function(_0x45530b){return db[_0xbeed('0x79')][_0xbeed('0x1f')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x1b084f}})['then'](function(_0x499eb6){var _0x350131=[];_[_0xbeed('0x6f')](_0x499eb6,function(_0x41de28){_0x350131[_0xbeed('0x5c')](createCmHopperPhone(_0x1b084f,_0x41de28['id']));});Promise[_0xbeed('0x61')](_0x350131)[_0xbeed('0x18')](function(){_0x45530b(0x1);});});});}function createCmHopperPhone(_0x46b14c,_0x341520){return new Promise(function(_0x4b04f0){db[_0xbeed('0x48')][_0xbeed('0x1f')]({'raw':!![],'attributes':[_0xbeed('0x92'),'OrderBy'],'where':{'CmContactId':_0x46b14c,'ItemClass':_0xbeed('0x91')},'include':[{'model':db[_0xbeed('0x67')],'attributes':['OrderBy'],'as':_0xbeed('0x93')}],'order':['OrderBy',db['sequelize']['literal'](_0xbeed('0x94'))]})[_0xbeed('0x18')](function(_0x1088c1){var _0x45b835=0x1;var _0x4caa7a=_['map'](_0x1088c1,function(_0x17ce16){_0x17ce16[_0xbeed('0x95')]=_0x341520;_0x17ce16[_0xbeed('0x78')]=_0x17ce16['item'];_0x17ce16[_0xbeed('0x8b')]=_0x45b835;delete _0x17ce16[_0xbeed('0x96')];_0x45b835=_0x45b835+0x1;return _0x17ce16;});return db[_0xbeed('0x97')][_0xbeed('0x98')](_0x4caa7a,{});})[_0xbeed('0x18')](function(){_0x4b04f0(0x1);});});}function insertAdditionalPhones(_0x46ccd0,_0xa9862){return new Promise(function(_0x37c179){var _0x1a4f90=[];for(var _0x2f047d=0x0;_0x2f047d<_0xa9862[_0xbeed('0x27')];_0x2f047d++){var _0x301d9e=_0xa9862[_0x2f047d];_0x1a4f90[_0xbeed('0x5c')](parseContactItemType(_0x301d9e));}Promise['all'](_0x1a4f90)[_0xbeed('0x18')](function(){var _0x1ae41f={'id':_0x46ccd0['id'],'items':_0xa9862};return addAdditionalPhones(_0x1ae41f)[_0xbeed('0x18')](function(){return addCmHopperPhones(_0x46ccd0['id']);});})[_0xbeed('0x18')](function(){_0x37c179(_0x46ccd0);});});}function parseContactItemType(_0x28b4d2){return new Promise(function(_0xf21711){if(_0x28b4d2[_0xbeed('0x33')](_0xbeed('0x8e'))){_0xf21711(_0x28b4d2);}else{return db['ContactItemType'][_0xbeed('0x23')]({'where':{'name':_0x28b4d2[_0xbeed('0x93')]}})[_0xbeed('0x18')](function(_0x136063){if(_['isNil'](_0x136063))_0x28b4d2[_0xbeed('0x8e')]=null;else _0x28b4d2['ItemTypeId']=_0x136063['id'];_0xf21711(_0x28b4d2);});}});}exports[_0xbeed('0x99')]=function(_0x25cb9a,_0x8f3dde){return db[_0xbeed('0x48')][_0xbeed('0x1f')]({'raw':!![],'where':{'CmContactId':_0x25cb9a[_0xbeed('0x24')]['id'],'ItemClass':_0xbeed('0x91')},'include':[{'model':db['ContactItemType'],'as':_0xbeed('0x93')}],'order':[[_0xbeed('0x8b')],[db['sequelize']['literal'](_0xbeed('0x94'))]]})['then'](function(_0x47ae0f){return _0x47ae0f;})[_0xbeed('0x18')](respondWithResult(_0x8f3dde,null))['catch'](handleError(_0x8f3dde,null));};exports[_0xbeed('0x9a')]=function(_0x36cd70,_0x43af56){return db[_0xbeed('0x48')][_0xbeed('0x1f')]({'raw':!![],'where':{'CmContactId':_0x36cd70[_0xbeed('0x35')][_0xbeed('0x9b')]}})[_0xbeed('0x18')](function(_0xa98e7b){var _0x3b921a=_['map'](_0xa98e7b,function(_0x28f25f){_0x28f25f[_0xbeed('0x9c')]=_0x36cd70[_0xbeed('0x35')][_0xbeed('0x9d')];return _0x28f25f;});return db['CmContactHasItem']['bulkCreate'](_0x3b921a,{});})[_0xbeed('0x18')](function(){return addCmHopperPhones(_0x36cd70[_0xbeed('0x35')][_0xbeed('0x9d')]);})[_0xbeed('0x18')](function(){return['ok'];})['then'](respondWithResult(_0x43af56,null))[_0xbeed('0x21')](handleError(_0x43af56,null));};exports[_0xbeed('0x9e')]=function(_0x4e3c75,_0x53b15e){var _0x5443f6=[];_0x5443f6[_0xbeed('0x5c')](createCmHopperPhone(_0x4e3c75[_0xbeed('0x35')]['id'],_0x4e3c75[_0xbeed('0x35')][_0xbeed('0x9f')]));Promise[_0xbeed('0x61')](_0x5443f6)[_0xbeed('0x18')](function(){return[0x1];})['then'](respondWithResult(_0x53b15e,null));};exports[_0xbeed('0xa0')]=function(_0x58885f,_0x2fe8c1){var _0x4b7752={'raw':![],'where':{}};var _0x22be5c={};var _0x1ecc2e={'count':0x0,'rows':[]};return db['CmContact'][_0xbeed('0x7b')]({'where':{'id':_0x58885f[_0xbeed('0x24')]['id']}})[_0xbeed('0x18')](handleEntityNotFound(_0x2fe8c1,null))['then'](function(_0x19cf42){if(_0x19cf42){_0x22be5c[_0xbeed('0x7f')]=_['keys'](db['CmHopper']['rawAttributes']);_0x22be5c[_0xbeed('0x20')]=_[_0xbeed('0x26')](_0x58885f[_0xbeed('0x20')]);_0x22be5c[_0xbeed('0x7d')]=_[_0xbeed('0x7e')](_0x22be5c['model'],_0x22be5c[_0xbeed('0x20')]);_0x4b7752[_0xbeed('0x80')]=_[_0xbeed('0x7e')](_0x22be5c[_0xbeed('0x7f')],qs[_0xbeed('0x81')](_0x58885f[_0xbeed('0x20')]['fields']));_0x4b7752[_0xbeed('0x80')]=_0x4b7752[_0xbeed('0x80')]['length']?_0x4b7752[_0xbeed('0x80')]:_0x22be5c[_0xbeed('0x7f')];if(!_0x58885f[_0xbeed('0x20')][_0xbeed('0x33')](_0xbeed('0x87'))){_0x4b7752[_0xbeed('0x11')]=qs[_0xbeed('0x11')](_0x58885f[_0xbeed('0x20')][_0xbeed('0x11')]);_0x4b7752[_0xbeed('0x13')]=qs[_0xbeed('0x13')](_0x58885f['query'][_0xbeed('0x13')]);}_0x4b7752[_0xbeed('0x82')]=qs[_0xbeed('0x83')](_0x58885f[_0xbeed('0x20')][_0xbeed('0x83')]);_0x4b7752[_0xbeed('0x5a')]=qs[_0xbeed('0x7d')](_[_0xbeed('0x84')](_0x58885f[_0xbeed('0x20')],_0x22be5c[_0xbeed('0x7d')]));_0x4b7752[_0xbeed('0x5a')][_0xbeed('0xa1')]=_0x19cf42['id'];if(_0x58885f['query']['filter']){_0x4b7752['where']=_[_0xbeed('0x34')](_0x4b7752[_0xbeed('0x5a')],{'$or':_['map'](_0x4b7752['attributes'],function(_0x135d55){var _0x19a36a={};_0x19a36a[_0x135d55]={'$like':'%'+_0x58885f[_0xbeed('0x20')][_0xbeed('0x85')]+'%'};return _0x19a36a;})});}_0x4b7752=_[_0xbeed('0x34')]({},_0x4b7752,_0x58885f['options']);return db[_0xbeed('0x79')][_0xbeed('0x12')]({'where':_0x4b7752[_0xbeed('0x5a')]})[_0xbeed('0x18')](function(_0x2bb06f){_0x1ecc2e[_0xbeed('0x12')]=_0x2bb06f;if(_0x58885f[_0xbeed('0x20')][_0xbeed('0xa2')]){_0x4b7752[_0xbeed('0xa3')]=[{'all':!![]}];}return db[_0xbeed('0x79')]['findAll'](_0x4b7752);})[_0xbeed('0x18')](function(_0x4bc1f4){_0x1ecc2e[_0xbeed('0xa4')]=_0x4bc1f4;return _0x1ecc2e;});}})[_0xbeed('0x18')](respondWithFilteredResult(_0x2fe8c1,_0x4b7752))[_0xbeed('0x21')](handleError(_0x2fe8c1,null));};exports[_0xbeed('0xa5')]=function(_0x42b03a,_0x1efd66){var _0x46ca60={'raw':!![],'where':{}};var _0x13cdd1={};var _0x203690={'count':0x0,'rows':[]};return db[_0xbeed('0x25')][_0xbeed('0x7b')]({'where':{'id':_0x42b03a['params']['id']}})['then'](handleEntityNotFound(_0x1efd66,null))[_0xbeed('0x18')](function(_0x47f96d){if(_0x47f96d){_0x13cdd1[_0xbeed('0x7f')]=_['keys'](db[_0xbeed('0x49')][_0xbeed('0x7c')]);_0x13cdd1[_0xbeed('0x20')]=_[_0xbeed('0x26')](_0x42b03a[_0xbeed('0x20')]);_0x13cdd1[_0xbeed('0x7d')]=_[_0xbeed('0x7e')](_0x13cdd1['model'],_0x13cdd1['query']);_0x46ca60['attributes']=_[_0xbeed('0x7e')](_0x13cdd1[_0xbeed('0x7f')],qs['fields'](_0x42b03a[_0xbeed('0x20')][_0xbeed('0x81')]));_0x46ca60[_0xbeed('0x80')]=_0x46ca60['attributes'][_0xbeed('0x27')]?_0x46ca60[_0xbeed('0x80')]:_0x13cdd1['model'];if(!_0x42b03a[_0xbeed('0x20')][_0xbeed('0x33')](_0xbeed('0x87'))){_0x46ca60[_0xbeed('0x11')]=qs['limit'](_0x42b03a[_0xbeed('0x20')][_0xbeed('0x11')]);_0x46ca60[_0xbeed('0x13')]=qs[_0xbeed('0x13')](_0x42b03a[_0xbeed('0x20')][_0xbeed('0x13')]);}_0x46ca60['order']=qs['sort'](_0x42b03a[_0xbeed('0x20')][_0xbeed('0x83')]);_0x46ca60['where']=qs[_0xbeed('0x7d')](_[_0xbeed('0x84')](_0x42b03a[_0xbeed('0x20')],_0x13cdd1[_0xbeed('0x7d')]));_0x46ca60['where']['ContactId']=_0x47f96d['id'];if(_0x42b03a[_0xbeed('0x20')][_0xbeed('0x85')]){_0x46ca60[_0xbeed('0x5a')]=_['merge'](_0x46ca60[_0xbeed('0x5a')],{'$or':_[_0xbeed('0x6f')](_0x46ca60[_0xbeed('0x80')],function(_0x4e7c2e){var _0xe586db={};_0xe586db[_0x4e7c2e]={'$like':'%'+_0x42b03a[_0xbeed('0x20')][_0xbeed('0x85')]+'%'};return _0xe586db;})});}_0x46ca60=_['merge']({},_0x46ca60,_0x42b03a[_0xbeed('0x86')]);return db['CmHopperHistory'][_0xbeed('0x12')]({'where':_0x46ca60[_0xbeed('0x5a')]})['then'](function(_0x2001c1){_0x203690[_0xbeed('0x12')]=_0x2001c1;if(_0x42b03a[_0xbeed('0x20')][_0xbeed('0xa2')]){_0x46ca60['include']=[{'all':!![]}];}return db[_0xbeed('0x49')][_0xbeed('0x1f')](_0x46ca60);})['then'](function(_0x59ea60){_0x203690[_0xbeed('0xa4')]=_0x59ea60;return _0x203690;});}})['then'](respondWithFilteredResult(_0x1efd66,_0x46ca60))[_0xbeed('0x21')](handleError(_0x1efd66,null));};exports[_0xbeed('0xa6')]=function(_0x5ebc73,_0x325243){var _0x4f4d38={'raw':!![],'where':{}};var _0x179f44={};var _0x5536b5={'count':0x0,'rows':[]};return db[_0xbeed('0x25')][_0xbeed('0x7b')]({'where':{'id':_0x5ebc73[_0xbeed('0x24')]['id']}})[_0xbeed('0x18')](handleEntityNotFound(_0x325243,null))[_0xbeed('0x18')](function(_0x3622de){if(_0x3622de){_0x179f44[_0xbeed('0x7f')]=_[_0xbeed('0x26')](db[_0xbeed('0xa7')]['rawAttributes']);_0x179f44[_0xbeed('0x20')]=_[_0xbeed('0x26')](_0x5ebc73[_0xbeed('0x20')]);_0x179f44[_0xbeed('0x7d')]=_['intersection'](_0x179f44[_0xbeed('0x7f')],_0x179f44['query']);_0x4f4d38[_0xbeed('0x80')]=_[_0xbeed('0x7e')](_0x179f44[_0xbeed('0x7f')],qs['fields'](_0x5ebc73[_0xbeed('0x20')][_0xbeed('0x81')]));_0x4f4d38['attributes']=_0x4f4d38[_0xbeed('0x80')][_0xbeed('0x27')]?_0x4f4d38['attributes']:_0x179f44[_0xbeed('0x7f')];if(!_0x5ebc73[_0xbeed('0x20')][_0xbeed('0x33')](_0xbeed('0x87'))){_0x4f4d38['limit']=qs['limit'](_0x5ebc73[_0xbeed('0x20')][_0xbeed('0x11')]);_0x4f4d38[_0xbeed('0x13')]=qs[_0xbeed('0x13')](_0x5ebc73['query'][_0xbeed('0x13')]);}_0x4f4d38['order']=qs['sort'](_0x5ebc73[_0xbeed('0x20')]['sort']);_0x4f4d38[_0xbeed('0x5a')]=qs['filters'](_[_0xbeed('0x84')](_0x5ebc73['query'],_0x179f44[_0xbeed('0x7d')]));_0x4f4d38[_0xbeed('0x5a')][_0xbeed('0xa1')]=_0x3622de['id'];if(_0x5ebc73[_0xbeed('0x20')][_0xbeed('0x85')]){_0x4f4d38[_0xbeed('0x5a')]=_[_0xbeed('0x34')](_0x4f4d38[_0xbeed('0x5a')],{'$or':_[_0xbeed('0x6f')](_0x4f4d38[_0xbeed('0x80')],function(_0x486dad){var _0x5826b0={};_0x5826b0[_0x486dad]={'$like':'%'+_0x5ebc73[_0xbeed('0x20')][_0xbeed('0x85')]+'%'};return _0x5826b0;})});}_0x4f4d38=_[_0xbeed('0x34')]({},_0x4f4d38,_0x5ebc73[_0xbeed('0x86')]);return db[_0xbeed('0xa7')]['count']({'where':_0x4f4d38['where']})[_0xbeed('0x18')](function(_0x3933dd){_0x5536b5['count']=_0x3933dd;if(_0x5ebc73['query'][_0xbeed('0xa2')]){_0x4f4d38[_0xbeed('0xa3')]=[{'all':!![]}];}return db['CmHopperFinal']['findAll'](_0x4f4d38);})[_0xbeed('0x18')](function(_0x4f1828){_0x5536b5[_0xbeed('0xa4')]=_0x4f1828;return _0x5536b5;});}})[_0xbeed('0x18')](respondWithFilteredResult(_0x325243,_0x4f4d38))[_0xbeed('0x21')](handleError(_0x325243,null));};exports[_0xbeed('0xa8')]=function(_0x5da5fb,_0x315ba3){var _0x19874f={'raw':!![],'where':{}};var _0x5920a9={};var _0x54e972={'count':0x0,'rows':[]};return db[_0xbeed('0x25')]['findOne']({'where':{'id':_0x5da5fb[_0xbeed('0x24')]['id']}})[_0xbeed('0x18')](handleEntityNotFound(_0x315ba3,null))[_0xbeed('0x18')](function(_0x8fc476){if(_0x8fc476){_0x5920a9[_0xbeed('0x7f')]=_[_0xbeed('0x26')](db[_0xbeed('0x50')][_0xbeed('0x7c')]);_0x5920a9['query']=_[_0xbeed('0x26')](_0x5da5fb[_0xbeed('0x20')]);_0x5920a9[_0xbeed('0x7d')]=_[_0xbeed('0x7e')](_0x5920a9[_0xbeed('0x7f')],_0x5920a9[_0xbeed('0x20')]);_0x19874f[_0xbeed('0x80')]=_[_0xbeed('0x7e')](_0x5920a9[_0xbeed('0x7f')],qs['fields'](_0x5da5fb[_0xbeed('0x20')]['fields']));_0x19874f[_0xbeed('0x80')]=_0x19874f[_0xbeed('0x80')]['length']?_0x19874f[_0xbeed('0x80')]:_0x5920a9[_0xbeed('0x7f')];if(!_0x5da5fb[_0xbeed('0x20')][_0xbeed('0x33')]('nolimit')){_0x19874f[_0xbeed('0x11')]=qs[_0xbeed('0x11')](_0x5da5fb['query']['limit']);_0x19874f[_0xbeed('0x13')]=qs['offset'](_0x5da5fb['query'][_0xbeed('0x13')]);}_0x19874f[_0xbeed('0x82')]=qs[_0xbeed('0x83')](_0x5da5fb[_0xbeed('0x20')][_0xbeed('0x83')]);_0x19874f[_0xbeed('0x5a')]=qs['filters'](_[_0xbeed('0x84')](_0x5da5fb[_0xbeed('0x20')],_0x5920a9['filters']));_0x19874f[_0xbeed('0x5a')][_0xbeed('0xa1')]=_0x8fc476['id'];if(_0x5da5fb[_0xbeed('0x20')][_0xbeed('0x85')]){_0x19874f['where']=_['merge'](_0x19874f[_0xbeed('0x5a')],{'$or':_[_0xbeed('0x6f')](_0x19874f[_0xbeed('0x80')],function(_0x5610ec){var _0x530c71={};_0x530c71[_0x5610ec]={'$like':'%'+_0x5da5fb[_0xbeed('0x20')][_0xbeed('0x85')]+'%'};return _0x530c71;})});}_0x19874f=_[_0xbeed('0x34')]({},_0x19874f,_0x5da5fb[_0xbeed('0x86')]);return db[_0xbeed('0x50')][_0xbeed('0x12')]({'where':_0x19874f['where']})['then'](function(_0x1b829e){_0x54e972[_0xbeed('0x12')]=_0x1b829e;if(_0x5da5fb[_0xbeed('0x20')][_0xbeed('0xa2')]){_0x19874f[_0xbeed('0xa3')]=[{'all':!![]}];}return db[_0xbeed('0x50')][_0xbeed('0x1f')](_0x19874f);})[_0xbeed('0x18')](function(_0x37612f){_0x54e972[_0xbeed('0xa4')]=_0x37612f;return _0x54e972;});}})[_0xbeed('0x18')](respondWithFilteredResult(_0x315ba3,_0x19874f))['catch'](handleError(_0x315ba3,null));};exports['uploadCsv']=function(_0x2446af,_0x403a74){try{if(!_0x2446af[_0xbeed('0x35')][_0xbeed('0x5d')]){throw new Error(_0xbeed('0xa9'));}if(!_0x2446af[_0xbeed('0x35')][_0xbeed('0xaa')]){throw new Error(_0xbeed('0xab'));}if(!_0x2446af[_0xbeed('0x35')][_0xbeed('0xac')]){throw new Error('No\x20association\x20values\x20specified!');}if(!_0x2446af['body'][_0xbeed('0xad')]){throw new Error(_0xbeed('0xae'));}var _0x5253b6=_0x2446af[_0xbeed('0x35')]['binding_keys'][_0xbeed('0xaf')](',');var _0x470d72=_0x2446af[_0xbeed('0x35')]['binding_values'][_0xbeed('0xaf')](',');if(!_0x5253b6[_0xbeed('0x27')]||!_0x470d72[_0xbeed('0x27')]||_0x5253b6['length']!==_0x470d72[_0xbeed('0x27')]){throw new Error('Incorrect\x20binding\x20parameters\x20passed!');}_0x2446af[_0xbeed('0x35')]['fields']=_[_0xbeed('0xb0')](_0x5253b6,_0x470d72);if(!_0x2446af[_0xbeed('0x35')][_0xbeed('0x81')][_0xbeed('0x78')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x2446af['body'][_0xbeed('0x81')]['firstName']){throw new Error('No\x20firstName\x20column\x20specified');}var _0x230b27=path[_0xbeed('0x3b')](config[_0xbeed('0xb1')],_0xbeed('0xb2'),_0x2446af[_0xbeed('0xb3')][_0xbeed('0xb4')]);fs[_0xbeed('0xb5')](_0x230b27,parseInt(_0xbeed('0xb6'),0x8));var _0x12bc69=require(_0xbeed('0xb7'))[_0xbeed('0xb8')](path[_0xbeed('0x3b')](__dirname,_0xbeed('0xb9')),[_0x230b27,_0x2446af[_0xbeed('0x35')][_0xbeed('0xaa')],_0x2446af[_0xbeed('0x35')]['binding_values'],_0x2446af[_0xbeed('0x35')][_0xbeed('0x5d')],_0x2446af['body'][_0xbeed('0xba')],_0x2446af[_0xbeed('0x35')][_0xbeed('0x59')],_0x2446af[_0xbeed('0x35')][_0xbeed('0xad')]]);return _0x403a74['status'](0xc8)[_0xbeed('0x17')]({'message':_0xbeed('0xbb'),'pid':_0x12bc69[_0xbeed('0xbc')]});}catch(_0x1f0561){return _0x403a74[_0xbeed('0x14')](0x1f4)[_0xbeed('0x1d')](_0x1f0561);}};exports[_0xbeed('0xbd')]=function(_0x101e4f,_0x153f5a){var _0x401de1=fs[_0xbeed('0xbe')](_0x101e4f[_0xbeed('0xb3')][_0xbeed('0xbf')]);Papa[_0xbeed('0xc0')](_0x401de1,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x2aa79){return _0x153f5a[_0xbeed('0x14')](0xc8)[_0xbeed('0x17')]({'file':_0x101e4f['file'],'fields':_0x2aa79[_0xbeed('0xc1')]['fields']});}});};exports[_0xbeed('0xc2')]=function(_0x32feec,_0x346619){return db[_0xbeed('0xc3')][_0xbeed('0x1f')]({'raw':!![],'attributes':['id'],'where':{'role':_0xbeed('0xc4')}})[_0xbeed('0x18')](function(_0x5c68e4){var _0x16feda=![];if(!_0x32feec[_0xbeed('0x35')][_0xbeed('0x5d')]){throw new Error(_0xbeed('0xa9'));}if(!_0x32feec[_0xbeed('0x35')][_0xbeed('0xc5')][_0xbeed('0x78')]){throw new Error(_0xbeed('0xc6'));}if(!_0x32feec[_0xbeed('0x35')][_0xbeed('0xc5')][_0xbeed('0xc7')]){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x32feec[_0xbeed('0x35')][_0xbeed('0xad')]){throw new Error(_0xbeed('0xae'));}var _0xb169a4=require(_0xbeed('0xb7'))['fork'](path[_0xbeed('0x3b')](__dirname,_0xbeed('0xc8')),[_0x32feec[_0xbeed('0x24')]['id'],JSON['stringify'](_0x32feec['body']),JSON[_0xbeed('0xc9')](_0x5c68e4)]);_0xb169a4['on']('message',function(){_0x16feda=!![];return _0x346619[_0xbeed('0x14')](0xc8)[_0xbeed('0x17')]({'message':_0xbeed('0xca'),'pid':_0xb169a4['pid']});});_0xb169a4['on'](_0xbeed('0xcb'),function(_0x15a750){if(_0x15a750&&!_0x16feda){return _0x346619['status'](0x1f4)['json']({'message':_0xbeed('0xcc'),'pid':_0xb169a4[_0xbeed('0xbc')]});}});})[_0xbeed('0x21')](handleError(_0x346619,null));};exports[_0xbeed('0xcd')]=function(_0x38b0a2,_0x1f50b2){return db[_0xbeed('0xc3')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0xbeed('0xc4')}})[_0xbeed('0x18')](function(_0x3ef2b5){var _0xde4c63=![];if(!_0x38b0a2[_0xbeed('0x35')][_0xbeed('0x5d')]){throw new Error(_0xbeed('0xa9'));}if(!_0x38b0a2[_0xbeed('0x35')][_0xbeed('0xc5')][_0xbeed('0x78')]){throw new Error(_0xbeed('0xc6'));}if(!_0x38b0a2[_0xbeed('0x35')][_0xbeed('0xc5')]['firstName']){throw new Error(_0xbeed('0xce'));}if(!_0x38b0a2[_0xbeed('0x35')][_0xbeed('0xad')]){throw new Error(_0xbeed('0xae'));}var _0x474ce3=require('child_process')[_0xbeed('0xb8')](path[_0xbeed('0x3b')](__dirname,'../../components/import/cm/csvUpdates'),[_0x38b0a2[_0xbeed('0x24')]['id'],JSON[_0xbeed('0xc9')](_0x38b0a2[_0xbeed('0x35')]),JSON[_0xbeed('0xc9')](_0x3ef2b5)]);_0x474ce3['on'](_0xbeed('0xcf'),function(){_0xde4c63=!![];return _0x1f50b2[_0xbeed('0x14')](0xc8)[_0xbeed('0x17')]({'message':'start\x20child\x20process\x20correctly!','pid':_0x474ce3[_0xbeed('0xbc')]});});_0x474ce3['on'](_0xbeed('0xcb'),function(_0x2c359a){if(_0x2c359a&&!_0xde4c63){return _0x1f50b2[_0xbeed('0x14')](0x1f4)[_0xbeed('0x17')]({'message':_0xbeed('0xcc'),'pid':_0x474ce3[_0xbeed('0xbc')]});}});})[_0xbeed('0x21')](handleError(_0x1f50b2,null));};exports[_0xbeed('0xd0')]=function(_0x36bfb8,_0x18ba56){var _0x438909=['mail','chat',_0xbeed('0xd1'),_0xbeed('0xd2'),_0xbeed('0xd3'),_0xbeed('0xd4'),_0xbeed('0xd5')];var _0xa24b46={'offset':0x0,'order':qs[_0xbeed('0x83')]('-createdAt')},_0x2e5092={'count':0x0,'rows':[]};Promise[_0xbeed('0xd6')]()[_0xbeed('0x18')](function(){if(_0x36bfb8[_0xbeed('0x20')][_0xbeed('0xd7')]){if(!_[_0xbeed('0xd8')](_0x438909,_0x36bfb8[_0xbeed('0x20')][_0xbeed('0xd7')][_0xbeed('0xd9')]())){throw new Error('Invalid\x20channel');}_0x438909=[_0x36bfb8['query'][_0xbeed('0xd7')][_0xbeed('0xd9')]()];}if(_0x36bfb8['query'][_0xbeed('0xda')]){try{var _0x160e31=JSON['parse'](_0x36bfb8[_0xbeed('0x20')][_0xbeed('0xda')]);if(!moment(_0x160e31[_0xbeed('0x36')])[_0xbeed('0xdb')]()){throw new Error(_0xbeed('0xdc'));}if(!moment(_0x160e31['to'])[_0xbeed('0xdb')]()){throw new Error('Invalid\x20date\x20for\x20range\x20to\x20filter');}}catch(_0x430632){throw new Error(_0xbeed('0xdd'));}}if(!_0x36bfb8[_0xbeed('0x20')][_0xbeed('0x33')]('nolimit')){_0xa24b46[_0xbeed('0x11')]=qs[_0xbeed('0x11')](_0x36bfb8[_0xbeed('0x20')][_0xbeed('0x11')]||0xa);_0xa24b46[_0xbeed('0x13')]=qs['offset'](_0x36bfb8['query']['offset']);}var _0x43b4a8=_0x438909['map'](function(_0x467613){if(_0x467613===_0xbeed('0xd5')){var _0x3ecc97={'attributes':['id',_0xbeed('0xde'),_0xbeed('0xdf'),'source',_0xbeed('0xe0'),'callerid','starttime',_0xbeed('0xe1'),_0xbeed('0xe2'),_0xbeed('0xe3'),_0xbeed('0xe4'),_0xbeed('0xe5'),_0xbeed('0xe6'),_0xbeed('0xe7'),_0xbeed('0xe8')],'where':{'ContactId':_0x36bfb8[_0xbeed('0x24')]['id']},'include':[{'model':db['User'],'as':'User','attributes':['id',_0xbeed('0x1c'),_0xbeed('0xe9'),'alias']}],'order':[[_0xbeed('0xe4'),_0xbeed('0xea')]]};if(_0x36bfb8[_0xbeed('0x20')][_0xbeed('0xda')]){_0x3ecc97[_0xbeed('0x5a')][_0xbeed('0xe4')]={'$gte':_0x160e31[_0xbeed('0x36')],'$lte':_0x160e31['to']};}return db[_0xbeed('0xeb')]['findAndCountAll'](_0x3ecc97)[_0xbeed('0x18')](function(_0x51830d){_0x2e5092['count']+=_0x51830d[_0xbeed('0x12')];return _[_0xbeed('0x6f')](_0x51830d['rows'],function(_0x24b580){var _0x45fff7=_0x24b580[_0xbeed('0x37')]({'plain':!![]});_0x45fff7[_0xbeed('0xd7')]=_0x467613;if(_0x45fff7['User']){_0x45fff7[_0xbeed('0xc3')]={'id':_0x45fff7[_0xbeed('0xc3')]['id'],'name':_0x45fff7[_0xbeed('0xc3')][_0xbeed('0x1c')],'fullname':_0x45fff7['User'][_0xbeed('0xe9')],'alias':_0x45fff7[_0xbeed('0xc3')][_0xbeed('0x2d')]};}return _0x45fff7;});});}else{var _0x1a3bda=_[_0xbeed('0xec')](_0x467613)+(_0x467613==='chat'?_0xbeed('0xed'):_0xbeed('0xee'));var _0x1d781d={'attributes':['id',_0xbeed('0xef'),'closedAt',_0xbeed('0xe4'),'note','disposition','secondDisposition',_0xbeed('0xf0'),'UserId',_0x1a3bda+'Id'],'where':{'ContactId':_0x36bfb8[_0xbeed('0x24')]['id']},'include':[{'model':db[_0x1a3bda],'as':_0xbeed('0xee'),'attributes':['id',_0xbeed('0x1c'),'key']},{'model':db['User'],'as':_0xbeed('0xf1'),'attributes':['id',_0xbeed('0x1c'),_0xbeed('0xe9')]},{'model':db[_0xbeed('0x62')],'as':'Tags','attributes':['id',_0xbeed('0x1c'),_0xbeed('0x64')],'through':{'attributes':[]}}],'order':[['createdAt','DESC']]};if(_0x36bfb8[_0xbeed('0x20')]['range']){_0x1d781d[_0xbeed('0x5a')]['createdAt']={'$gte':_0x160e31['from'],'$lte':_0x160e31['to']};}switch(_0x467613){case _0xbeed('0xf2'):_0x1d781d['attributes']['push']('browserName',_0xbeed('0xf3'),_0xbeed('0xf4'),_0xbeed('0xf5'),_0xbeed('0xf6'),_0xbeed('0xf7'),'ratingType',_0xbeed('0xf8'),_0xbeed('0xf9'));break;case'mail':_0x1d781d[_0xbeed('0x80')]['push']('subject',_0xbeed('0xfa'));break;case _0xbeed('0xd2'):_0x1d781d[_0xbeed('0x80')][_0xbeed('0x5c')](_0xbeed('0xfb'),_0xbeed('0xfc'));break;}return db[_[_0xbeed('0xec')](_0x467613)+_0xbeed('0xfd')][_0xbeed('0xfe')](_0x1d781d)['then'](function(_0x570d61){_0x2e5092['count']+=_0x570d61[_0xbeed('0x12')];return _[_0xbeed('0x6f')](_0x570d61[_0xbeed('0xa4')],function(_0x113149){var _0x303a98=_0x113149[_0xbeed('0x37')]({'plain':!![]});_0x303a98[_0xbeed('0xd7')]=_0x467613;if(_0x303a98[_0xbeed('0xf1')]){_0x303a98['Owner']={'id':_0x303a98[_0xbeed('0xf1')]['id'],'name':_0x303a98['Owner'][_0xbeed('0x1c')],'fullname':_0x303a98['Owner'][_0xbeed('0xe9')]};}return _0x303a98;});});}});return Promise[_0xbeed('0x61')](_0x43b4a8);})[_0xbeed('0x18')](function(_0x3e9154){return _(_0x3e9154)[_0xbeed('0xff')]()['sortBy'](_0xbeed('0xe4'))[_0xbeed('0x100')]()['value']();})[_0xbeed('0x18')](function(_0x1673cd){_0x2e5092[_0xbeed('0xa4')]=_0xa24b46[_0xbeed('0x11')]?_0x1673cd[_0xbeed('0x101')](_0xa24b46['offset'],_0xa24b46['offset']+_0xa24b46['limit']):_0x1673cd;return _0x2e5092;})['then'](respondWithFilteredResult(_0x18ba56,_0xa24b46))['catch'](handleError(_0x18ba56,null));};
\ No newline at end of file
+var _0xe5b9=['getOptions','findAll','user','catch','CmContact','params','tags','length','keys','startsWith','displayName','query','analytics','cf_','columnName','alias','custom','type','values','forEach','merge','body','from','get','mergeWith','isArray','info','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','ChatMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','OpenchannelInteraction','OpenchannelMessage','CmContactHasItem','CmHopperFinal','ReportAgentPreview','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappMessage','WhatsappQueueReport','join','dialTimezone','isNil','timezones','utcOffset','additionalPhones','each','duplicates','where','push','ListId','findOrCreate','spread','hasOwnProperty','contact','all','show','Tag','color','tag','ContactItemType','ItemType','sequelize','literal','Phones.OrderBy','$and','omit','map','cf_%d','find','CmCustomField','pickBy','format','isEmpty','table','id\x20=\x20?','toParam','text','phone','getTags','findOne','model','rawAttributes','filters','intersection','attributes','fields','order','sort','pick','filter','options','nolimit','setTags','ids','setAdditionalPhones','OrderBy','items','item_types','ItemTypeId','description','contact\x20phone\x20exists','PHONE','CmHopperAdditionalPhone','item','`ItemType`.OrderBy','bulkCreate','getAdditionalPhones','duplicateAdditionalPhones','fromContactId','CmContactId','toContactId','rescheduleAdditionalPhones','hopperId','getHoppers','includeAll','include','rows','getHopperHistories','CmHopperHistory','ContactId','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','split','binding_values','Incorrect\x20binding\x20parameters\x20passed!','zipObject','firstName','No\x20firstName\x20column\x20specified','root','server/files/tmp','file','filename','0777','child_process','fork','../../components/import/cm/csv','CompanyId','File\x20uploaded\x20correctly!','pid','upload','createReadStream','path','meta','User','binding','No\x20phone\x20column\x20specified','../../components/import/cm/csv2','stringify','message','exit','error\x20child\x20process','agent','../../components/import/cm/csvUpdates','getJourney','chat','sms','openchannel','fax','whatsapp','voice','-createdAt','resolve','channel','includes','toLowerCase','Invalid\x20channel','range','Invalid\x20date\x20for\x20range\x20from\x20filter','Invalid\x20date\x20for\x20range\x20to\x20filter','Invalid\x20createdAt\x20filter','uniqueid','source','destination','callerid','starttime','endtime','note','createdAt','userSecondDisposition','userThirdDisposition','fullname','Website','closed','closedAt','disposition','secondDisposition','thirdDisposition','key','Tags','DESC','browserName','customerIp','customerPort','deviceModel','osName','ratingMessage','ratingType','ratingValue','referer','mail','subject','externalUrl','startCase','Interaction','findAndCountAll','Owner','flatten','sortBy','value','slice','moment','util','lodash','squel','papaparse','ioredis','../../components/contacts','../../components/parsers/qs','../../config/logger','api','../../config/environment/shared','redis','defaults','localhost','./cmContact.socket','register','status','json','offset','limit','undefined','count','set','update','destroy','then','end','sendStatus','error','stack','name','send','index','describe'];(function(_0x1f3ce3,_0xa5ebec){var _0x16fd8c=function(_0x2eb724){while(--_0x2eb724){_0x1f3ce3['push'](_0x1f3ce3['shift']());}};_0x16fd8c(++_0xa5ebec);}(_0xe5b9,0x1e8));var _0x9e5b=function(_0x5ab012,_0x450b13){_0x5ab012=_0x5ab012-0x0;var _0x3585dd=_0xe5b9[_0x5ab012];return _0x3585dd;};'use strict';var moment=require(_0x9e5b('0x0'));var BPromise=require('bluebird');var util=require(_0x9e5b('0x1'));var path=require('path');var fs=require('fs');var _=require(_0x9e5b('0x2'));var squel=require(_0x9e5b('0x3'));var Papa=require(_0x9e5b('0x4'));var Redis=require(_0x9e5b('0x5'));var contacts=require(_0x9e5b('0x6'));var qs=require(_0x9e5b('0x7'));var logger=require(_0x9e5b('0x8'))(_0x9e5b('0x9'));var config=require('../../config/environment');var shared=require(_0x9e5b('0xa'));var db=require('../../mysqldb')['db'];config[_0x9e5b('0xb')]=_[_0x9e5b('0xc')](config[_0x9e5b('0xb')],{'host':_0x9e5b('0xd'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config['redis']));require(_0x9e5b('0xe'))[_0x9e5b('0xf')](socket);function respondWithResult(_0xc97c62,_0x32cd08){_0x32cd08=_0x32cd08||0xc8;return function(_0x313cd7){if(_0x313cd7){return _0xc97c62[_0x9e5b('0x10')](_0x32cd08)[_0x9e5b('0x11')](_0x313cd7);}};}function respondWithFilteredResult(_0x44bb70,_0x500447){return function(_0x525c68){if(_0x525c68){var _0x1f32d9=typeof _0x500447[_0x9e5b('0x12')]==='undefined'&&typeof _0x500447[_0x9e5b('0x13')]===_0x9e5b('0x14');var _0x536068=_0x525c68[_0x9e5b('0x15')];var _0x27eb9f=_0x1f32d9?0x0:_0x500447[_0x9e5b('0x12')];var _0x9f794e=_0x1f32d9?_0x525c68['count']:_0x500447[_0x9e5b('0x12')]+_0x500447[_0x9e5b('0x13')];var _0x13cd1e;if(_0x9f794e>=_0x536068){_0x9f794e=_0x536068;_0x13cd1e=0xc8;}else{_0x13cd1e=0xce;}_0x44bb70[_0x9e5b('0x10')](_0x13cd1e);return _0x44bb70[_0x9e5b('0x16')]('Content-Range',_0x27eb9f+'-'+_0x9f794e+'/'+_0x536068)[_0x9e5b('0x11')](_0x525c68);}return null;};}function saveUpdates(_0x45365d){return function(_0x16662c){if(_0x16662c){return _0x16662c[_0x9e5b('0x17')](_0x45365d)['then'](function(_0x4e558b){return _0x4e558b;});}return null;};}function removeEntity(_0x540a64){return function(_0x2c2ea8){if(_0x2c2ea8){return _0x2c2ea8[_0x9e5b('0x18')]()[_0x9e5b('0x19')](function(){_0x540a64[_0x9e5b('0x10')](0xcc)[_0x9e5b('0x1a')]();});}};}function handleEntityNotFound(_0x4d6a0b){return function(_0x50f2fe){if(!_0x50f2fe){_0x4d6a0b[_0x9e5b('0x1b')](0x194);}return _0x50f2fe;};}function handleError(_0x518e82,_0x241450){_0x241450=_0x241450||0x1f4;return function(_0x4ee073){logger[_0x9e5b('0x1c')](_0x4ee073[_0x9e5b('0x1d')]);if(_0x4ee073[_0x9e5b('0x1e')]){delete _0x4ee073[_0x9e5b('0x1e')];}_0x518e82[_0x9e5b('0x10')](_0x241450)[_0x9e5b('0x1f')](_0x4ee073);};}exports[_0x9e5b('0x20')]=function(_0x25579d,_0x21315c){var _0xf1b3fc={};return contacts[_0x9e5b('0x21')]()['then'](function(_0xaf935c){_0xf1b3fc=qs[_0x9e5b('0x22')](_0xaf935c,_0x25579d);return contacts[_0x9e5b('0x23')](_0x25579d['query'],_0x25579d[_0x9e5b('0x24')],_0xf1b3fc,_0xaf935c);})[_0x9e5b('0x19')](respondWithFilteredResult(_0x21315c,_0xf1b3fc))[_0x9e5b('0x25')](handleError(_0x21315c,null));};exports[_0x9e5b('0x18')]=function(_0xa29151,_0x7121f5){return db[_0x9e5b('0x26')]['find']({'where':{'id':_0xa29151[_0x9e5b('0x27')]['id']}})[_0x9e5b('0x19')](handleEntityNotFound(_0x7121f5,null))['then'](removeEntity(_0x7121f5,null))[_0x9e5b('0x25')](handleError(_0x7121f5,null));};exports[_0x9e5b('0x21')]=function(_0x881030,_0x1d0253){return db[_0x9e5b('0x26')][_0x9e5b('0x21')]()[_0x9e5b('0x19')](function(_0x3e8211){delete _0x3e8211[_0x9e5b('0x28')];for(var _0x46bd3f=0x0;_0x46bd3f<Object['keys'](_0x3e8211)[_0x9e5b('0x29')];_0x46bd3f++){var _0xd02d58=Object[_0x9e5b('0x2a')](_0x3e8211)[_0x46bd3f];if(!_[_0x9e5b('0x2b')](_0xd02d58,'cf_')){_0x3e8211[_0xd02d58]['columnName']=_0xd02d58;_0x3e8211[_0xd02d58][_0x9e5b('0x2c')]=_0xd02d58;}}return _0x3e8211;})[_0x9e5b('0x19')](function(_0x42aac8){var _0x4b4ae1={'where':Boolean(_0x881030[_0x9e5b('0x2d')][_0x9e5b('0x2e')])===!![]?undefined:{'$or':[{'ListId':_0x881030[_0x9e5b('0x2d')]['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField'][_0x9e5b('0x23')](_0x4b4ae1)['then'](function(_0x13eb6b){for(var _0x3391d7=0x0;_0x3391d7<_0x13eb6b[_0x9e5b('0x29')];_0x3391d7++){var _0x253337=_0x9e5b('0x2f')+_0x13eb6b[_0x3391d7]['id'];if(_0x42aac8[_0x253337]){_0x42aac8[_0x253337][_0x9e5b('0x30')]=_0x253337;_0x42aac8[_0x253337]['displayName']=_0x13eb6b[_0x3391d7][_0x9e5b('0x31')];_0x42aac8[_0x253337][_0x9e5b('0x32')]={'type':_0x13eb6b[_0x3391d7][_0x9e5b('0x33')],'values':_0x13eb6b[_0x3391d7][_0x9e5b('0x34')]};}else{logger['info']('Custom\x20field\x20%s\x20not\x20found\x20on\x20cm_contacts\x20table',_0x253337);}}Object[_0x9e5b('0x2a')](_0x42aac8)[_0x9e5b('0x35')](function(_0x36c5c0){if(!_0x42aac8[_0x36c5c0]['hasOwnProperty'](_0x9e5b('0x30'))){delete _0x42aac8[_0x36c5c0];}});return _0x42aac8;});})['then'](respondWithResult(_0x1d0253,null))[_0x9e5b('0x25')](handleError(_0x1d0253,null));};exports[_0x9e5b('0x36')]=function(_0x4bc95c,_0x2cd410){var _0xae4d01;var _0x5301f2;var _0x386e31;if(_0x4bc95c['body']['id']){delete _0x4bc95c[_0x9e5b('0x37')]['id'];}return db[_0x9e5b('0x26')][_0x9e5b('0x23')]({'where':{'id':[_0x4bc95c['body']['to'],_0x4bc95c[_0x9e5b('0x37')][_0x9e5b('0x38')]]}})['then'](function(_0x1cb55b){if(_0x1cb55b){if(_0x1cb55b[_0x9e5b('0x29')]!==0x2){return null;}_0x1cb55b[0x0]=_0x1cb55b[0x0][_0x9e5b('0x39')]({'plain':!![]});_0x1cb55b[0x1]=_0x1cb55b[0x1]['get']({'plain':!![]});delete _0x1cb55b[0x0]['id'];delete _0x1cb55b[0x1]['id'];return _[_0x9e5b('0x3a')](_0x1cb55b[0x0],_0x1cb55b[0x1],function(_0x41ca64,_0x53bbd1){if(Array[_0x9e5b('0x3b')](_0x53bbd1)&&!_0x53bbd1[_0x9e5b('0x29')]){return _0x41ca64;}else if(!_0x53bbd1){return _0x41ca64;}});}})[_0x9e5b('0x19')](handleEntityNotFound(_0x2cd410,null))[_0x9e5b('0x19')](function(_0x196a52){if(_0x196a52){if(_0x196a52[_0x9e5b('0x28')]&&_[_0x9e5b('0x3b')](_0x196a52['tags'])){_0x196a52[_0x9e5b('0x28')]=_0x196a52['tags']['join']();}logger[_0x9e5b('0x3c')]('[CmContact][merge]\x20to\x20%s\x20from\x20%s',_0x4bc95c[_0x9e5b('0x37')]['to'],_0x4bc95c[_0x9e5b('0x37')][_0x9e5b('0x38')]);return db[_0x9e5b('0x3d')][_0x9e5b('0x18')]({'where':{'ContactId':[_0x4bc95c[_0x9e5b('0x37')]['to'],_0x4bc95c[_0x9e5b('0x37')][_0x9e5b('0x38')]]}})[_0x9e5b('0x19')](function(_0x1eaa47){logger[_0x9e5b('0x3c')](_0x9e5b('0x3e'),_0x1eaa47);return db[_0x9e5b('0x3f')]['destroy']({'where':{'ContactId':[_0x4bc95c[_0x9e5b('0x37')]['to'],_0x4bc95c[_0x9e5b('0x37')]['from']]}})[_0x9e5b('0x19')](function(_0x29ae53){logger[_0x9e5b('0x3c')](_0x9e5b('0x40'),_0x29ae53);return db[_0x9e5b('0x26')][_0x9e5b('0x41')](_0x196a52);});});}})[_0x9e5b('0x19')](function(_0x1883f5){if(_0x1883f5){_0xae4d01=_0x1883f5;_0x5301f2={'ContactId':_0xae4d01['id']};_0x386e31={'where':{'ContactId':[_0x4bc95c['body']['to'],_0x4bc95c[_0x9e5b('0x37')][_0x9e5b('0x38')]]}};return db[_0x9e5b('0x42')][_0x9e5b('0x17')](_0x5301f2,_0x386e31);}})['then'](function(){if(_0xae4d01){return db[_0x9e5b('0x43')][_0x9e5b('0x17')](_0x5301f2,_0x386e31);}})[_0x9e5b('0x19')](function(){if(_0xae4d01){return db['ChatOfflineMessage'][_0x9e5b('0x17')](_0x5301f2,_0x386e31);}})['then'](function(){if(_0xae4d01){return db[_0x9e5b('0x44')]['update'](_0x5301f2,_0x386e31);}})[_0x9e5b('0x19')](function(){if(_0xae4d01){return db[_0x9e5b('0x45')]['update'](_0x5301f2,_0x386e31);}})['then'](function(){if(_0xae4d01){return db[_0x9e5b('0x44')]['update'](_0x5301f2,_0x386e31);}})[_0x9e5b('0x19')](function(){if(_0xae4d01){return db[_0x9e5b('0x45')][_0x9e5b('0x17')](_0x5301f2,_0x386e31);}})['then'](function(){if(_0xae4d01){return db[_0x9e5b('0x46')][_0x9e5b('0x17')](_0x5301f2,_0x386e31);}})[_0x9e5b('0x19')](function(){if(_0xae4d01){return db[_0x9e5b('0x47')][_0x9e5b('0x17')](_0x5301f2,_0x386e31);}})[_0x9e5b('0x19')](function(){if(_0xae4d01){return db[_0x9e5b('0x48')][_0x9e5b('0x17')](_0x5301f2,_0x386e31);}})[_0x9e5b('0x19')](function(){if(_0xae4d01){return db['FaxMessage'][_0x9e5b('0x17')](_0x5301f2,_0x386e31);}})['then'](function(){if(_0xae4d01){return db[_0x9e5b('0x49')][_0x9e5b('0x17')](_0x5301f2,_0x386e31);}})[_0x9e5b('0x19')](function(){if(_0xae4d01){return db[_0x9e5b('0x4a')][_0x9e5b('0x17')](_0x5301f2,_0x386e31);}})[_0x9e5b('0x19')](function(){if(_0xae4d01){return db[_0x9e5b('0x4b')][_0x9e5b('0x17')]({'CmContactId':_0xae4d01['id']},{'where':{'CmContactId':[_0x4bc95c[_0x9e5b('0x37')]['to'],_0x4bc95c[_0x9e5b('0x37')][_0x9e5b('0x38')]]}});}})['then'](function(){if(_0xae4d01){return db[_0x9e5b('0x4c')][_0x9e5b('0x17')](_0x5301f2,_0x386e31);}})[_0x9e5b('0x19')](function(){if(_0xae4d01){return db['CmHopperHistory']['update'](_0x5301f2,_0x386e31);}})[_0x9e5b('0x19')](function(){if(_0xae4d01){return db[_0x9e5b('0x4d')][_0x9e5b('0x17')](_0x5301f2,_0x386e31);}})[_0x9e5b('0x19')](function(){if(_0xae4d01){return db['VoiceCallReport']['update'](_0x5301f2,_0x386e31);}})['then'](function(){if(_0xae4d01){return db[_0x9e5b('0x4e')][_0x9e5b('0x17')](_0x5301f2,_0x386e31);}})[_0x9e5b('0x19')](function(){if(_0xae4d01){return db[_0x9e5b('0x4f')]['update'](_0x5301f2,_0x386e31);}})['then'](function(){if(_0xae4d01){return db[_0x9e5b('0x50')][_0x9e5b('0x17')](_0x5301f2,_0x386e31);}})['then'](function(){if(_0xae4d01){return db[_0x9e5b('0x51')][_0x9e5b('0x17')](_0x5301f2,_0x386e31);}})['then'](function(){if(_0xae4d01){return db[_0x9e5b('0x52')][_0x9e5b('0x17')](_0x5301f2,_0x386e31);}})[_0x9e5b('0x19')](function(){if(_0xae4d01){return db[_0x9e5b('0x53')][_0x9e5b('0x17')](_0x5301f2,_0x386e31);}})[_0x9e5b('0x19')](function(){if(_0xae4d01){return db['WhatsappInteraction'][_0x9e5b('0x17')](_0x5301f2,_0x386e31);}})['then'](function(){if(_0xae4d01){return db[_0x9e5b('0x54')][_0x9e5b('0x17')](_0x5301f2,_0x386e31);}})[_0x9e5b('0x19')](function(){if(_0xae4d01){return db[_0x9e5b('0x55')][_0x9e5b('0x17')](_0x5301f2,_0x386e31);}})[_0x9e5b('0x19')](function(){if(_0xae4d01){return db[_0x9e5b('0x26')][_0x9e5b('0x18')]({'where':{'id':[_0x4bc95c[_0x9e5b('0x37')]['to'],_0x4bc95c['body']['from']]}});}})[_0x9e5b('0x19')](function(){if(_0xae4d01){return _0xae4d01;}})[_0x9e5b('0x19')](respondWithResult(_0x2cd410,null))[_0x9e5b('0x25')](handleError(_0x2cd410,null));};exports[_0x9e5b('0x41')]=function(_0x5b409f,_0x22e8b){return db[_0x9e5b('0x26')]['describe']()[_0x9e5b('0x19')](function(_0x340e5b){if(_0x5b409f[_0x9e5b('0x37')]['tags']&&_[_0x9e5b('0x3b')](_0x5b409f['body']['tags'])){if(_0x5b409f['body'][_0x9e5b('0x28')][_0x9e5b('0x29')]){_0x5b409f[_0x9e5b('0x37')][_0x9e5b('0x28')]=_0x5b409f[_0x9e5b('0x37')][_0x9e5b('0x28')][_0x9e5b('0x56')](';')+';';}else{_0x5b409f[_0x9e5b('0x37')][_0x9e5b('0x28')]=null;}}else{_0x5b409f[_0x9e5b('0x37')]['tags']=null;}if(!_['isNil'](_0x5b409f[_0x9e5b('0x37')]['dialTimezone'])){var _0x132bd0=_0x5b409f[_0x9e5b('0x37')][_0x9e5b('0x57')];if(!_[_0x9e5b('0x58')](shared[_0x9e5b('0x59')][_0x132bd0]))_0x5b409f['body'][_0x9e5b('0x5a')]=shared[_0x9e5b('0x59')][_0x132bd0][_0x9e5b('0x5a')];}return db[_0x9e5b('0x26')][_0x9e5b('0x41')](_0x5b409f[_0x9e5b('0x37')],{'fields':_[_0x9e5b('0x2a')](_0x340e5b),'raw':!![]});})['then'](function(_0x60d143){if(_0x5b409f['body'][_0x9e5b('0x5b')]){return insertAdditionalPhones(_0x60d143,_0x5b409f[_0x9e5b('0x37')][_0x9e5b('0x5b')]);}else{return _0x60d143;}})[_0x9e5b('0x19')](respondWithResult(_0x22e8b,0xc9))['catch'](handleError(_0x22e8b,null));};exports['bulkCreate']=function(_0x281f61,_0x4c0f0b){var _0x1812cd=0x0;var _0x106ecd=0x0;var _0x193994=0x0;var _0x1a3e5f=[];return db[_0x9e5b('0x26')][_0x9e5b('0x21')]()['then'](function(_0x3f3749){return BPromise[_0x9e5b('0x5c')](_0x281f61[_0x9e5b('0x37')],function(_0x2512fb){var _0x1ed76b={'where':{'$or':[]},'defaults':_0x2512fb,'fields':_['keys'](_0x3f3749),'raw':!![]};if(_0x2512fb[_0x9e5b('0x5d')]){for(var _0x9affa7=0x0;_0x9affa7<_0x2512fb[_0x9e5b('0x5d')]['length'];_0x9affa7++){var _0x161776={};_0x161776[_0x2512fb[_0x9e5b('0x5d')][_0x9affa7]]=_0x2512fb[_0x2512fb[_0x9e5b('0x5d')][_0x9affa7]];_0x1ed76b[_0x9e5b('0x5e')]['$or'][_0x9e5b('0x5f')](_0x161776);}_0x1ed76b['where'][_0x9e5b('0x60')]=_0x2512fb['ListId'];}return db[_0x9e5b('0x26')][_0x9e5b('0x61')](_0x1ed76b)[_0x9e5b('0x62')](function(_0x19f640,_0x4c5b08){if(_0x4c5b08){if(_0x2512fb[_0x9e5b('0x63')](_0x9e5b('0x5b'))){_0x1a3e5f[_0x9e5b('0x5f')]({'contact':_0x19f640,'additionalPhones':_0x2512fb[_0x9e5b('0x5b')]});}_0x1812cd++;}else{_0x193994++;}})[_0x9e5b('0x25')](function(){_0x106ecd++;});});})[_0x9e5b('0x19')](function(_0x4dca61){if(_0x4dca61){if(_0x1a3e5f[_0x9e5b('0x29')]>0x0){return new Promise(function(_0x532be5){var _0x5dfd4c=[];for(var _0x464f5c=0x0;_0x464f5c<_0x1a3e5f[_0x9e5b('0x29')];_0x464f5c++){_0x5dfd4c['push'](insertAdditionalPhones(_0x1a3e5f[_0x464f5c][_0x9e5b('0x64')],_0x1a3e5f[_0x464f5c]['additionalPhones']));}Promise[_0x9e5b('0x65')](_0x5dfd4c)['then'](function(){_0x532be5(0x1);});})[_0x9e5b('0x19')](function(){return{'success':_0x1812cd,'failure':_0x106ecd,'duplicates':_0x193994};});}else{return{'success':_0x1812cd,'failure':_0x106ecd,'duplicates':_0x193994};}}})['then'](respondWithResult(_0x4c0f0b,0xc9))[_0x9e5b('0x25')](handleError(_0x4c0f0b,null));};exports[_0x9e5b('0x66')]=function(_0x11d275,_0x2f5e73){var _0x130e64;return db[_0x9e5b('0x26')][_0x9e5b('0x21')]()[_0x9e5b('0x19')](function(_0x42886b){return db[_0x9e5b('0x26')]['find']({'where':{'id':_0x11d275[_0x9e5b('0x27')]['id']},'include':[{'model':db[_0x9e5b('0x67')],'as':'Tags','attributes':['id',_0x9e5b('0x1e'),_0x9e5b('0x68')],'required':_0x11d275['query'][_0x9e5b('0x69')]?!![]:![]},{'model':db['CmContactHasItem'],'as':'Phones','where':{'CmContactId':_0x11d275[_0x9e5b('0x27')]['id']},'required':![],'include':[{'model':db[_0x9e5b('0x6a')],'as':_0x9e5b('0x6b')}]}],'order':[db[_0x9e5b('0x6c')][_0x9e5b('0x6d')](_0x9e5b('0x6e'))],'attributes':_[_0x9e5b('0x2a')](_0x42886b)});})[_0x9e5b('0x19')](function(_0x1ab98b){if(!_['isNil'](_0x1ab98b)){_0x130e64=_0x1ab98b['get']({'plain':!![]});var _0x5b98ae={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x1ab98b&&_0x1ab98b[_0x9e5b('0x60')]){if(_0x1ab98b['ListId']){_0x5b98ae['where'][_0x9e5b('0x6f')][_0x9e5b('0x5f')]({'ListId':{'$ne':_0x1ab98b[_0x9e5b('0x60')]}});}}return db['CmCustomField'][_0x9e5b('0x23')](_0x5b98ae);}})[_0x9e5b('0x19')](function(_0x1261a7){if(!_['isNil'](_0x1261a7)){return _[_0x9e5b('0x70')](_0x130e64,_[_0x9e5b('0x71')](_0x1261a7,function(_0x2b93da){return util['format'](_0x9e5b('0x72'),_0x2b93da['id']);}));}})[_0x9e5b('0x19')](handleEntityNotFound(_0x2f5e73,null))[_0x9e5b('0x19')](respondWithResult(_0x2f5e73,null))[_0x9e5b('0x25')](handleError(_0x2f5e73,null));};exports[_0x9e5b('0x17')]=function(_0x15c11c,_0x434f66){var _0x2e28a0;if(_0x15c11c['body']['id']){delete _0x15c11c['body']['id'];}if(!_[_0x9e5b('0x58')](_0x15c11c[_0x9e5b('0x37')][_0x9e5b('0x57')])){var _0x59e8c1=_0x15c11c[_0x9e5b('0x37')][_0x9e5b('0x57')];if(!_[_0x9e5b('0x58')](shared[_0x9e5b('0x59')][_0x59e8c1]))_0x15c11c[_0x9e5b('0x37')][_0x9e5b('0x5a')]=shared[_0x9e5b('0x59')][_0x59e8c1][_0x9e5b('0x5a')];}return db[_0x9e5b('0x26')][_0x9e5b('0x73')]({'where':{'id':_0x15c11c[_0x9e5b('0x27')]['id']}})[_0x9e5b('0x19')](handleEntityNotFound(_0x434f66,null))[_0x9e5b('0x19')](saveUpdates(_0x15c11c[_0x9e5b('0x37')],null))['then'](function(_0x243164){_0x2e28a0=_0x243164;var _0x1da800={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x243164&&_0x243164[_0x9e5b('0x60')]){if(_0x243164[_0x9e5b('0x60')]){_0x1da800[_0x9e5b('0x5e')]['$and']['push']({'ListId':{'$ne':_0x243164[_0x9e5b('0x60')]}});}}return db[_0x9e5b('0x74')][_0x9e5b('0x23')](_0x1da800);})[_0x9e5b('0x19')](function(_0x2a8ef5){if(_0x2a8ef5){return _['omit'](_[_0x9e5b('0x75')](_0x15c11c['body'],function(_0x48d640,_0x21e424){return _[_0x9e5b('0x2b')](_0x21e424,'cf_');}),_['map'](_0x2a8ef5,function(_0x533b85){return util[_0x9e5b('0x76')](_0x9e5b('0x72'),_0x533b85['id']);}));}})[_0x9e5b('0x19')](function(_0xd64ada){if(_0xd64ada&&!_[_0x9e5b('0x77')](_0xd64ada)){var _0xf96f3b=squel[_0x9e5b('0x17')]()[_0x9e5b('0x78')]('cm_contacts')['setFields'](_0xd64ada)[_0x9e5b('0x5e')](_0x9e5b('0x79'),_0x15c11c['params']['id'])[_0x9e5b('0x7a')]();return db[_0x9e5b('0x6c')][_0x9e5b('0x2d')](_0xf96f3b[_0x9e5b('0x7b')],{'replacements':_0xf96f3b[_0x9e5b('0x34')]});}})[_0x9e5b('0x19')](function(){if(_0x15c11c[_0x9e5b('0x37')][_0x9e5b('0x7c')]&&_0x2e28a0){return db[_0x9e5b('0x3d')][_0x9e5b('0x17')]({'phone':_0x15c11c['body'][_0x9e5b('0x7c')],'OrderBy':0x0},{'where':{'ContactId':_0x2e28a0['id']}});}})[_0x9e5b('0x19')](function(){return _0x2e28a0;})[_0x9e5b('0x19')](respondWithResult(_0x434f66,null))[_0x9e5b('0x25')](handleError(_0x434f66,null));};exports[_0x9e5b('0x7d')]=function(_0x4c6286,_0x4f59ba){var _0x4f86b7={};var _0x593f53={};var _0x23a243;var _0x5f44db;return db[_0x9e5b('0x26')][_0x9e5b('0x7e')]({'where':{'id':_0x4c6286[_0x9e5b('0x27')]['id']}})[_0x9e5b('0x19')](handleEntityNotFound(_0x4f59ba,null))['then'](function(_0x4089c9){if(_0x4089c9){_0x23a243=_0x4089c9;_0x593f53[_0x9e5b('0x7f')]=_[_0x9e5b('0x2a')](db[_0x9e5b('0x67')][_0x9e5b('0x80')]);_0x593f53['query']=_[_0x9e5b('0x2a')](_0x4c6286['query']);_0x593f53[_0x9e5b('0x81')]=_[_0x9e5b('0x82')](_0x593f53[_0x9e5b('0x7f')],_0x593f53[_0x9e5b('0x2d')]);_0x4f86b7[_0x9e5b('0x83')]=_[_0x9e5b('0x82')](_0x593f53[_0x9e5b('0x7f')],qs[_0x9e5b('0x84')](_0x4c6286[_0x9e5b('0x2d')][_0x9e5b('0x84')]));_0x4f86b7[_0x9e5b('0x83')]=_0x4f86b7['attributes'][_0x9e5b('0x29')]?_0x4f86b7['attributes']:_0x593f53['model'];_0x4f86b7[_0x9e5b('0x85')]=qs['sort'](_0x4c6286[_0x9e5b('0x2d')][_0x9e5b('0x86')]);_0x4f86b7[_0x9e5b('0x5e')]=qs[_0x9e5b('0x81')](_[_0x9e5b('0x87')](_0x4c6286[_0x9e5b('0x2d')],_0x593f53['filters']));if(_0x4c6286[_0x9e5b('0x2d')][_0x9e5b('0x88')]){_0x4f86b7[_0x9e5b('0x5e')]=_[_0x9e5b('0x36')](_0x4f86b7['where'],{'$or':_[_0x9e5b('0x71')](_0x4f86b7['attributes'],function(_0x38c68b){var _0xc410da={};_0xc410da[_0x38c68b]={'$like':'%'+_0x4c6286['query'][_0x9e5b('0x88')]+'%'};return _0xc410da;})});}_0x4f86b7=_[_0x9e5b('0x36')]({},_0x4f86b7,_0x4c6286[_0x9e5b('0x89')]);return _0x23a243['getTags'](_0x4f86b7);}})['then'](function(_0x36f050){if(_0x36f050){_0x5f44db=_0x36f050['length'];if(!_0x4c6286[_0x9e5b('0x2d')]['hasOwnProperty'](_0x9e5b('0x8a'))){_0x4f86b7['limit']=qs[_0x9e5b('0x13')](_0x4c6286['query']['limit']);_0x4f86b7[_0x9e5b('0x12')]=qs[_0x9e5b('0x12')](_0x4c6286[_0x9e5b('0x2d')][_0x9e5b('0x12')]);}return _0x23a243[_0x9e5b('0x7d')](_0x4f86b7);}})[_0x9e5b('0x19')](function(_0x34724a){if(_0x34724a){return _0x34724a?{'count':_0x5f44db,'rows':_0x34724a}:null;}})[_0x9e5b('0x19')](respondWithResult(_0x4f59ba,null))['catch'](handleError(_0x4f59ba,null));};exports[_0x9e5b('0x8b')]=function(_0x3d8e91,_0x156cf4){if(_0x3d8e91[_0x9e5b('0x37')]['id']){delete _0x3d8e91[_0x9e5b('0x37')]['id'];}return db[_0x9e5b('0x26')][_0x9e5b('0x7e')]({'where':{'id':_0x3d8e91[_0x9e5b('0x27')]['id']}})[_0x9e5b('0x19')](handleEntityNotFound(_0x156cf4,null))[_0x9e5b('0x19')](function(_0x38e6ef){if(_0x38e6ef){return _0x38e6ef[_0x9e5b('0x8b')](_0x3d8e91[_0x9e5b('0x37')][_0x9e5b('0x8c')]||[]);}return null;})[_0x9e5b('0x19')](respondWithResult(_0x156cf4,null))[_0x9e5b('0x25')](handleError(_0x156cf4,null));};exports[_0x9e5b('0x8d')]=function(_0x518310,_0x2a43e7){var _0x480043=[];_0x480043[_0x9e5b('0x5f')](addAdditionalPhones(_0x518310['body']));Promise[_0x9e5b('0x65')](_0x480043)[_0x9e5b('0x19')](function(){_0x480043=[];_0x480043[_0x9e5b('0x5f')](deleteCmHopperPhones(_0x518310[_0x9e5b('0x37')]['id']));_0x480043[_0x9e5b('0x5f')](addCmHopperPhones(_0x518310[_0x9e5b('0x37')]['id']));Promise[_0x9e5b('0x65')](_0x480043)['then'](function(){return[0x1];})[_0x9e5b('0x19')](respondWithResult(_0x2a43e7,null));});};function addAdditionalPhones(_0x1d9a4f){var _0x49e0e1;return new Promise(function(_0x55aaed){return db[_0x9e5b('0x4b')][_0x9e5b('0x18')]({'where':{'CmContactId':_0x1d9a4f['id']}})['then'](function(){db[_0x9e5b('0x6a')][_0x9e5b('0x23')]({'raw':!![],'attributes':['id',_0x9e5b('0x8e')]})[_0x9e5b('0x19')](function(_0x20d361){var _0x173535=[];for(var _0x500b6d=0x0;_0x500b6d<_0x1d9a4f[_0x9e5b('0x8f')][_0x9e5b('0x29')];_0x500b6d++){var _0x39c579=_0x1d9a4f[_0x9e5b('0x90')]?_['isNil'](_0x1d9a4f[_0x9e5b('0x90')][_0x500b6d])?'':_0x1d9a4f[_0x9e5b('0x90')][_0x500b6d]:_0x1d9a4f[_0x9e5b('0x8f')][_0x500b6d][_0x9e5b('0x91')]?_0x1d9a4f[_0x9e5b('0x8f')][_0x500b6d][_0x9e5b('0x91')]:'';var _0x5138bf=_['isNil'](_0x1d9a4f[_0x9e5b('0x8f')][_0x500b6d]['description'])?'':_0x1d9a4f[_0x9e5b('0x8f')][_0x500b6d][_0x9e5b('0x92')];var _0x4bad8a=_0x39c579+':'+_0x1d9a4f[_0x9e5b('0x8f')][_0x500b6d][_0x9e5b('0x7c')]+'§'+_0x5138bf;if(_[_0x9e5b('0x58')](_0x49e0e1))_0x49e0e1=_0x4bad8a;else _0x49e0e1+=';'+_0x4bad8a;var _0x21e8c4=null;var _0x6f42a1=null;if(_0x1d9a4f[_0x9e5b('0x90')]){if(!_[_0x9e5b('0x58')](_0x1d9a4f[_0x9e5b('0x90')][_0x500b6d])){_0x6f42a1=_[_0x9e5b('0x73')](_0x20d361,function(_0x5c3703){return _0x5c3703['id']===_0x1d9a4f[_0x9e5b('0x90')][_0x500b6d];});if(!_['isNil'](_0x6f42a1)){_0x21e8c4=_0x6f42a1['OrderBy'];}}}else{if(!_[_0x9e5b('0x58')](_0x1d9a4f['items'][_0x500b6d])){_0x6f42a1=_[_0x9e5b('0x73')](_0x20d361,function(_0x6c7ca){return _0x6c7ca['id']===_0x1d9a4f[_0x9e5b('0x8f')][_0x500b6d][_0x9e5b('0x91')];});if(!_['isNil'](_0x6f42a1)){_0x21e8c4=_0x500b6d;}}}if(_['isNil'](_0x21e8c4)){_0x21e8c4=0x64;}_0x173535[_0x9e5b('0x5f')](addAdditionalPhone(_0x1d9a4f['id'],_0x1d9a4f[_0x9e5b('0x8f')][_0x500b6d][_0x9e5b('0x7c')],_0x1d9a4f[_0x9e5b('0x90')]?_[_0x9e5b('0x58')](_0x1d9a4f[_0x9e5b('0x90')][_0x500b6d])?null:_0x1d9a4f[_0x9e5b('0x90')][_0x500b6d]:_0x1d9a4f['items'][_0x500b6d][_0x9e5b('0x91')]?_0x1d9a4f[_0x9e5b('0x8f')][_0x500b6d]['ItemTypeId']:null,_0x21e8c4,_0x5138bf));}Promise['all'](_0x173535)[_0x9e5b('0x19')](function(){db[_0x9e5b('0x26')][_0x9e5b('0x17')]({'AdditionalPhones':_0x49e0e1},{'where':{'id':_0x1d9a4f['id']}})[_0x9e5b('0x19')](function(){_0x55aaed(0x1);});});});});});}function addAdditionalPhone(_0x55c317,_0x3277df,_0x209bc0,_0x4edccb,_0x5a64c7){return db['CmContactHasItem'][_0x9e5b('0x73')]({'where':{'CmContactId':_0x55c317,'item':_0x3277df}})['then'](function(_0x25a670){if(_0x25a670)logger['info'](_0x9e5b('0x93'),_0x25a670);else{db[_0x9e5b('0x4b')][_0x9e5b('0x41')]({'CmContactId':_0x55c317,'item':_0x3277df,'ItemTypeId':_0x209bc0,'OrderBy':_0x4edccb,'ItemClass':_0x9e5b('0x94'),'description':_0x5a64c7});}});}function deleteCmHopperPhones(_0x13e922){return new Promise(function(_0x1b2795){return db[_0x9e5b('0x3d')][_0x9e5b('0x23')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x13e922}})[_0x9e5b('0x19')](function(_0x353dc5){db[_0x9e5b('0x95')][_0x9e5b('0x18')]({'where':{'CmHopperId':{'$in':_[_0x9e5b('0x71')](_0x353dc5,'id')}}});})[_0x9e5b('0x19')](function(){_0x1b2795(0x1);});});}function addCmHopperPhones(_0x5c8b3b){return new Promise(function(_0x41633b){return db['CmHopper']['findAll']({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x5c8b3b}})['then'](function(_0x3895f7){var _0x11d1f2=[];_[_0x9e5b('0x71')](_0x3895f7,function(_0x2fe68b){_0x11d1f2[_0x9e5b('0x5f')](createCmHopperPhone(_0x5c8b3b,_0x2fe68b['id']));});Promise[_0x9e5b('0x65')](_0x11d1f2)['then'](function(){_0x41633b(0x1);});});});}function createCmHopperPhone(_0x5b6198,_0x4c7c49){return new Promise(function(_0x519ab9){db['CmContactHasItem'][_0x9e5b('0x23')]({'raw':!![],'attributes':[_0x9e5b('0x96'),_0x9e5b('0x8e')],'where':{'CmContactId':_0x5b6198,'ItemClass':'PHONE'},'include':[{'model':db['ContactItemType'],'attributes':['OrderBy'],'as':_0x9e5b('0x6b')}],'order':[_0x9e5b('0x8e'),db[_0x9e5b('0x6c')][_0x9e5b('0x6d')](_0x9e5b('0x97'))]})['then'](function(_0x216fb5){var _0x24af61=0x1;var _0x5deea5=_['map'](_0x216fb5,function(_0x246e2b){_0x246e2b['CmHopperId']=_0x4c7c49;_0x246e2b['phone']=_0x246e2b[_0x9e5b('0x96')];_0x246e2b[_0x9e5b('0x8e')]=_0x24af61;delete _0x246e2b['ItemType.OrderBy'];_0x24af61=_0x24af61+0x1;return _0x246e2b;});return db[_0x9e5b('0x95')][_0x9e5b('0x98')](_0x5deea5,{});})[_0x9e5b('0x19')](function(){_0x519ab9(0x1);});});}function insertAdditionalPhones(_0x10dfa8,_0x21060a){return new Promise(function(_0x293cda){var _0x358fb5=[];for(var _0x59789d=0x0;_0x59789d<_0x21060a['length'];_0x59789d++){var _0x3bba19=_0x21060a[_0x59789d];_0x358fb5['push'](parseContactItemType(_0x3bba19));}Promise[_0x9e5b('0x65')](_0x358fb5)[_0x9e5b('0x19')](function(){var _0xc7cba7={'id':_0x10dfa8['id'],'items':_0x21060a};return addAdditionalPhones(_0xc7cba7)[_0x9e5b('0x19')](function(){return addCmHopperPhones(_0x10dfa8['id']);});})[_0x9e5b('0x19')](function(){_0x293cda(_0x10dfa8);});});}function parseContactItemType(_0x5b02d2){return new Promise(function(_0x11bc90){if(_0x5b02d2[_0x9e5b('0x63')]('ItemTypeId')){_0x11bc90(_0x5b02d2);}else{return db[_0x9e5b('0x6a')][_0x9e5b('0x73')]({'where':{'name':_0x5b02d2[_0x9e5b('0x6b')]}})[_0x9e5b('0x19')](function(_0x5ebe94){if(_[_0x9e5b('0x58')](_0x5ebe94))_0x5b02d2[_0x9e5b('0x91')]=null;else _0x5b02d2[_0x9e5b('0x91')]=_0x5ebe94['id'];_0x11bc90(_0x5b02d2);});}});}exports[_0x9e5b('0x99')]=function(_0xfcd3a7,_0x49a98b){return db['CmContactHasItem'][_0x9e5b('0x23')]({'raw':!![],'where':{'CmContactId':_0xfcd3a7['params']['id'],'ItemClass':_0x9e5b('0x94')},'include':[{'model':db['ContactItemType'],'as':_0x9e5b('0x6b')}],'order':[['OrderBy'],[db['sequelize'][_0x9e5b('0x6d')](_0x9e5b('0x97'))]]})[_0x9e5b('0x19')](function(_0x39e50a){return _0x39e50a;})[_0x9e5b('0x19')](respondWithResult(_0x49a98b,null))[_0x9e5b('0x25')](handleError(_0x49a98b,null));};exports[_0x9e5b('0x9a')]=function(_0x278055,_0x325f16){return db[_0x9e5b('0x4b')][_0x9e5b('0x23')]({'raw':!![],'where':{'CmContactId':_0x278055[_0x9e5b('0x37')][_0x9e5b('0x9b')]}})['then'](function(_0x238088){var _0x4e86f1=_['map'](_0x238088,function(_0x299653){_0x299653[_0x9e5b('0x9c')]=_0x278055[_0x9e5b('0x37')][_0x9e5b('0x9d')];return _0x299653;});return db[_0x9e5b('0x4b')]['bulkCreate'](_0x4e86f1,{});})[_0x9e5b('0x19')](function(){return addCmHopperPhones(_0x278055['body'][_0x9e5b('0x9d')]);})[_0x9e5b('0x19')](function(){return['ok'];})[_0x9e5b('0x19')](respondWithResult(_0x325f16,null))[_0x9e5b('0x25')](handleError(_0x325f16,null));};exports[_0x9e5b('0x9e')]=function(_0x2bf9c8,_0x9dd8ab){var _0x348562=[];_0x348562[_0x9e5b('0x5f')](createCmHopperPhone(_0x2bf9c8[_0x9e5b('0x37')]['id'],_0x2bf9c8[_0x9e5b('0x37')][_0x9e5b('0x9f')]));Promise[_0x9e5b('0x65')](_0x348562)[_0x9e5b('0x19')](function(){return[0x1];})[_0x9e5b('0x19')](respondWithResult(_0x9dd8ab,null));};exports[_0x9e5b('0xa0')]=function(_0x5a1c8c,_0x1a4f6e){var _0x413a3f={'raw':![],'where':{}};var _0x1573bf={};var _0x401eee={'count':0x0,'rows':[]};return db[_0x9e5b('0x26')][_0x9e5b('0x7e')]({'where':{'id':_0x5a1c8c['params']['id']}})['then'](handleEntityNotFound(_0x1a4f6e,null))['then'](function(_0x1d52a1){if(_0x1d52a1){_0x1573bf[_0x9e5b('0x7f')]=_[_0x9e5b('0x2a')](db['CmHopper']['rawAttributes']);_0x1573bf[_0x9e5b('0x2d')]=_[_0x9e5b('0x2a')](_0x5a1c8c['query']);_0x1573bf[_0x9e5b('0x81')]=_[_0x9e5b('0x82')](_0x1573bf['model'],_0x1573bf[_0x9e5b('0x2d')]);_0x413a3f['attributes']=_[_0x9e5b('0x82')](_0x1573bf[_0x9e5b('0x7f')],qs[_0x9e5b('0x84')](_0x5a1c8c[_0x9e5b('0x2d')][_0x9e5b('0x84')]));_0x413a3f[_0x9e5b('0x83')]=_0x413a3f[_0x9e5b('0x83')][_0x9e5b('0x29')]?_0x413a3f[_0x9e5b('0x83')]:_0x1573bf['model'];if(!_0x5a1c8c[_0x9e5b('0x2d')][_0x9e5b('0x63')]('nolimit')){_0x413a3f[_0x9e5b('0x13')]=qs[_0x9e5b('0x13')](_0x5a1c8c['query'][_0x9e5b('0x13')]);_0x413a3f[_0x9e5b('0x12')]=qs[_0x9e5b('0x12')](_0x5a1c8c[_0x9e5b('0x2d')][_0x9e5b('0x12')]);}_0x413a3f['order']=qs[_0x9e5b('0x86')](_0x5a1c8c['query'][_0x9e5b('0x86')]);_0x413a3f[_0x9e5b('0x5e')]=qs[_0x9e5b('0x81')](_[_0x9e5b('0x87')](_0x5a1c8c['query'],_0x1573bf['filters']));_0x413a3f[_0x9e5b('0x5e')]['ContactId']=_0x1d52a1['id'];if(_0x5a1c8c[_0x9e5b('0x2d')][_0x9e5b('0x88')]){_0x413a3f['where']=_[_0x9e5b('0x36')](_0x413a3f[_0x9e5b('0x5e')],{'$or':_[_0x9e5b('0x71')](_0x413a3f[_0x9e5b('0x83')],function(_0xc426cf){var _0xa68de5={};_0xa68de5[_0xc426cf]={'$like':'%'+_0x5a1c8c['query']['filter']+'%'};return _0xa68de5;})});}_0x413a3f=_[_0x9e5b('0x36')]({},_0x413a3f,_0x5a1c8c[_0x9e5b('0x89')]);return db['CmHopper'][_0x9e5b('0x15')]({'where':_0x413a3f[_0x9e5b('0x5e')]})[_0x9e5b('0x19')](function(_0x5eb73f){_0x401eee[_0x9e5b('0x15')]=_0x5eb73f;if(_0x5a1c8c[_0x9e5b('0x2d')][_0x9e5b('0xa1')]){_0x413a3f[_0x9e5b('0xa2')]=[{'all':!![]}];}return db[_0x9e5b('0x3d')][_0x9e5b('0x23')](_0x413a3f);})[_0x9e5b('0x19')](function(_0x7fc36){_0x401eee[_0x9e5b('0xa3')]=_0x7fc36;return _0x401eee;});}})[_0x9e5b('0x19')](respondWithFilteredResult(_0x1a4f6e,_0x413a3f))['catch'](handleError(_0x1a4f6e,null));};exports[_0x9e5b('0xa4')]=function(_0x450a82,_0xc3580f){var _0x160024={'raw':!![],'where':{}};var _0x3a8e9e={};var _0xb9cdfb={'count':0x0,'rows':[]};return db[_0x9e5b('0x26')][_0x9e5b('0x7e')]({'where':{'id':_0x450a82[_0x9e5b('0x27')]['id']}})[_0x9e5b('0x19')](handleEntityNotFound(_0xc3580f,null))[_0x9e5b('0x19')](function(_0x4974a7){if(_0x4974a7){_0x3a8e9e[_0x9e5b('0x7f')]=_[_0x9e5b('0x2a')](db[_0x9e5b('0xa5')][_0x9e5b('0x80')]);_0x3a8e9e[_0x9e5b('0x2d')]=_[_0x9e5b('0x2a')](_0x450a82[_0x9e5b('0x2d')]);_0x3a8e9e['filters']=_[_0x9e5b('0x82')](_0x3a8e9e['model'],_0x3a8e9e[_0x9e5b('0x2d')]);_0x160024['attributes']=_[_0x9e5b('0x82')](_0x3a8e9e[_0x9e5b('0x7f')],qs[_0x9e5b('0x84')](_0x450a82[_0x9e5b('0x2d')][_0x9e5b('0x84')]));_0x160024[_0x9e5b('0x83')]=_0x160024[_0x9e5b('0x83')][_0x9e5b('0x29')]?_0x160024[_0x9e5b('0x83')]:_0x3a8e9e[_0x9e5b('0x7f')];if(!_0x450a82[_0x9e5b('0x2d')]['hasOwnProperty']('nolimit')){_0x160024[_0x9e5b('0x13')]=qs[_0x9e5b('0x13')](_0x450a82['query'][_0x9e5b('0x13')]);_0x160024['offset']=qs[_0x9e5b('0x12')](_0x450a82[_0x9e5b('0x2d')][_0x9e5b('0x12')]);}_0x160024[_0x9e5b('0x85')]=qs[_0x9e5b('0x86')](_0x450a82[_0x9e5b('0x2d')][_0x9e5b('0x86')]);_0x160024['where']=qs['filters'](_[_0x9e5b('0x87')](_0x450a82['query'],_0x3a8e9e[_0x9e5b('0x81')]));_0x160024[_0x9e5b('0x5e')]['ContactId']=_0x4974a7['id'];if(_0x450a82[_0x9e5b('0x2d')][_0x9e5b('0x88')]){_0x160024[_0x9e5b('0x5e')]=_[_0x9e5b('0x36')](_0x160024[_0x9e5b('0x5e')],{'$or':_['map'](_0x160024[_0x9e5b('0x83')],function(_0x96d295){var _0x49edbd={};_0x49edbd[_0x96d295]={'$like':'%'+_0x450a82[_0x9e5b('0x2d')][_0x9e5b('0x88')]+'%'};return _0x49edbd;})});}_0x160024=_[_0x9e5b('0x36')]({},_0x160024,_0x450a82[_0x9e5b('0x89')]);return db[_0x9e5b('0xa5')]['count']({'where':_0x160024['where']})[_0x9e5b('0x19')](function(_0x3dbf06){_0xb9cdfb[_0x9e5b('0x15')]=_0x3dbf06;if(_0x450a82[_0x9e5b('0x2d')][_0x9e5b('0xa1')]){_0x160024[_0x9e5b('0xa2')]=[{'all':!![]}];}return db[_0x9e5b('0xa5')]['findAll'](_0x160024);})['then'](function(_0x1dfbed){_0xb9cdfb[_0x9e5b('0xa3')]=_0x1dfbed;return _0xb9cdfb;});}})['then'](respondWithFilteredResult(_0xc3580f,_0x160024))[_0x9e5b('0x25')](handleError(_0xc3580f,null));};exports['getHopperFinals']=function(_0x366636,_0x4a0f98){var _0x541309={'raw':!![],'where':{}};var _0x288ca9={};var _0x4bcc79={'count':0x0,'rows':[]};return db[_0x9e5b('0x26')][_0x9e5b('0x7e')]({'where':{'id':_0x366636[_0x9e5b('0x27')]['id']}})[_0x9e5b('0x19')](handleEntityNotFound(_0x4a0f98,null))[_0x9e5b('0x19')](function(_0x3b076f){if(_0x3b076f){_0x288ca9['model']=_[_0x9e5b('0x2a')](db[_0x9e5b('0x4c')][_0x9e5b('0x80')]);_0x288ca9[_0x9e5b('0x2d')]=_[_0x9e5b('0x2a')](_0x366636[_0x9e5b('0x2d')]);_0x288ca9[_0x9e5b('0x81')]=_['intersection'](_0x288ca9[_0x9e5b('0x7f')],_0x288ca9[_0x9e5b('0x2d')]);_0x541309['attributes']=_['intersection'](_0x288ca9[_0x9e5b('0x7f')],qs[_0x9e5b('0x84')](_0x366636['query']['fields']));_0x541309[_0x9e5b('0x83')]=_0x541309[_0x9e5b('0x83')][_0x9e5b('0x29')]?_0x541309[_0x9e5b('0x83')]:_0x288ca9[_0x9e5b('0x7f')];if(!_0x366636['query']['hasOwnProperty'](_0x9e5b('0x8a'))){_0x541309[_0x9e5b('0x13')]=qs[_0x9e5b('0x13')](_0x366636['query'][_0x9e5b('0x13')]);_0x541309['offset']=qs[_0x9e5b('0x12')](_0x366636['query'][_0x9e5b('0x12')]);}_0x541309['order']=qs[_0x9e5b('0x86')](_0x366636[_0x9e5b('0x2d')][_0x9e5b('0x86')]);_0x541309['where']=qs[_0x9e5b('0x81')](_[_0x9e5b('0x87')](_0x366636['query'],_0x288ca9[_0x9e5b('0x81')]));_0x541309['where'][_0x9e5b('0xa6')]=_0x3b076f['id'];if(_0x366636['query'][_0x9e5b('0x88')]){_0x541309[_0x9e5b('0x5e')]=_['merge'](_0x541309[_0x9e5b('0x5e')],{'$or':_[_0x9e5b('0x71')](_0x541309[_0x9e5b('0x83')],function(_0x4f2185){var _0x52203e={};_0x52203e[_0x4f2185]={'$like':'%'+_0x366636[_0x9e5b('0x2d')][_0x9e5b('0x88')]+'%'};return _0x52203e;})});}_0x541309=_['merge']({},_0x541309,_0x366636[_0x9e5b('0x89')]);return db[_0x9e5b('0x4c')][_0x9e5b('0x15')]({'where':_0x541309[_0x9e5b('0x5e')]})[_0x9e5b('0x19')](function(_0x329845){_0x4bcc79[_0x9e5b('0x15')]=_0x329845;if(_0x366636['query']['includeAll']){_0x541309['include']=[{'all':!![]}];}return db[_0x9e5b('0x4c')][_0x9e5b('0x23')](_0x541309);})[_0x9e5b('0x19')](function(_0x55be6d){_0x4bcc79[_0x9e5b('0xa3')]=_0x55be6d;return _0x4bcc79;});}})[_0x9e5b('0x19')](respondWithFilteredResult(_0x4a0f98,_0x541309))['catch'](handleError(_0x4a0f98,null));};exports['getJscriptySessions']=function(_0x5c2061,_0x29930a){var _0x4a530e={'raw':!![],'where':{}};var _0x153f25={};var _0x36f850={'count':0x0,'rows':[]};return db[_0x9e5b('0x26')][_0x9e5b('0x7e')]({'where':{'id':_0x5c2061[_0x9e5b('0x27')]['id']}})[_0x9e5b('0x19')](handleEntityNotFound(_0x29930a,null))[_0x9e5b('0x19')](function(_0x4d43af){if(_0x4d43af){_0x153f25['model']=_['keys'](db[_0x9e5b('0x53')][_0x9e5b('0x80')]);_0x153f25[_0x9e5b('0x2d')]=_[_0x9e5b('0x2a')](_0x5c2061[_0x9e5b('0x2d')]);_0x153f25['filters']=_[_0x9e5b('0x82')](_0x153f25[_0x9e5b('0x7f')],_0x153f25[_0x9e5b('0x2d')]);_0x4a530e[_0x9e5b('0x83')]=_[_0x9e5b('0x82')](_0x153f25[_0x9e5b('0x7f')],qs[_0x9e5b('0x84')](_0x5c2061[_0x9e5b('0x2d')][_0x9e5b('0x84')]));_0x4a530e[_0x9e5b('0x83')]=_0x4a530e['attributes']['length']?_0x4a530e[_0x9e5b('0x83')]:_0x153f25[_0x9e5b('0x7f')];if(!_0x5c2061[_0x9e5b('0x2d')]['hasOwnProperty']('nolimit')){_0x4a530e[_0x9e5b('0x13')]=qs[_0x9e5b('0x13')](_0x5c2061['query'][_0x9e5b('0x13')]);_0x4a530e[_0x9e5b('0x12')]=qs[_0x9e5b('0x12')](_0x5c2061[_0x9e5b('0x2d')][_0x9e5b('0x12')]);}_0x4a530e['order']=qs[_0x9e5b('0x86')](_0x5c2061['query'][_0x9e5b('0x86')]);_0x4a530e[_0x9e5b('0x5e')]=qs['filters'](_[_0x9e5b('0x87')](_0x5c2061[_0x9e5b('0x2d')],_0x153f25[_0x9e5b('0x81')]));_0x4a530e[_0x9e5b('0x5e')][_0x9e5b('0xa6')]=_0x4d43af['id'];if(_0x5c2061[_0x9e5b('0x2d')][_0x9e5b('0x88')]){_0x4a530e[_0x9e5b('0x5e')]=_[_0x9e5b('0x36')](_0x4a530e[_0x9e5b('0x5e')],{'$or':_[_0x9e5b('0x71')](_0x4a530e[_0x9e5b('0x83')],function(_0x151f5b){var _0x59389b={};_0x59389b[_0x151f5b]={'$like':'%'+_0x5c2061[_0x9e5b('0x2d')][_0x9e5b('0x88')]+'%'};return _0x59389b;})});}_0x4a530e=_[_0x9e5b('0x36')]({},_0x4a530e,_0x5c2061[_0x9e5b('0x89')]);return db[_0x9e5b('0x53')]['count']({'where':_0x4a530e['where']})['then'](function(_0x171118){_0x36f850['count']=_0x171118;if(_0x5c2061['query']['includeAll']){_0x4a530e[_0x9e5b('0xa2')]=[{'all':!![]}];}return db[_0x9e5b('0x53')]['findAll'](_0x4a530e);})['then'](function(_0x4c99c2){_0x36f850['rows']=_0x4c99c2;return _0x36f850;});}})[_0x9e5b('0x19')](respondWithFilteredResult(_0x29930a,_0x4a530e))['catch'](handleError(_0x29930a,null));};exports[_0x9e5b('0xa7')]=function(_0x4503c0,_0x489a91){try{if(!_0x4503c0['body'][_0x9e5b('0x60')]){throw new Error(_0x9e5b('0xa8'));}if(!_0x4503c0[_0x9e5b('0x37')][_0x9e5b('0xa9')]){throw new Error('No\x20association\x20keys\x20specified!');}if(!_0x4503c0[_0x9e5b('0x37')]['binding_values']){throw new Error(_0x9e5b('0xaa'));}if(!_0x4503c0[_0x9e5b('0x37')][_0x9e5b('0xab')]){throw new Error(_0x9e5b('0xac'));}var _0x484fb0=_0x4503c0[_0x9e5b('0x37')][_0x9e5b('0xa9')][_0x9e5b('0xad')](',');var _0x227649=_0x4503c0[_0x9e5b('0x37')][_0x9e5b('0xae')]['split'](',');if(!_0x484fb0[_0x9e5b('0x29')]||!_0x227649[_0x9e5b('0x29')]||_0x484fb0[_0x9e5b('0x29')]!==_0x227649[_0x9e5b('0x29')]){throw new Error(_0x9e5b('0xaf'));}_0x4503c0[_0x9e5b('0x37')]['fields']=_[_0x9e5b('0xb0')](_0x484fb0,_0x227649);if(!_0x4503c0[_0x9e5b('0x37')][_0x9e5b('0x84')][_0x9e5b('0x7c')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x4503c0[_0x9e5b('0x37')][_0x9e5b('0x84')][_0x9e5b('0xb1')]){throw new Error(_0x9e5b('0xb2'));}var _0x11f252=path[_0x9e5b('0x56')](config[_0x9e5b('0xb3')],_0x9e5b('0xb4'),_0x4503c0[_0x9e5b('0xb5')][_0x9e5b('0xb6')]);fs['chmodSync'](_0x11f252,parseInt(_0x9e5b('0xb7'),0x8));var _0x3ba0bb=require(_0x9e5b('0xb8'))[_0x9e5b('0xb9')](path['join'](__dirname,_0x9e5b('0xba')),[_0x11f252,_0x4503c0[_0x9e5b('0x37')]['binding_keys'],_0x4503c0[_0x9e5b('0x37')][_0x9e5b('0xae')],_0x4503c0[_0x9e5b('0x37')][_0x9e5b('0x60')],_0x4503c0[_0x9e5b('0x37')][_0x9e5b('0xbb')],_0x4503c0[_0x9e5b('0x37')][_0x9e5b('0x5d')],_0x4503c0[_0x9e5b('0x37')][_0x9e5b('0xab')]]);return _0x489a91[_0x9e5b('0x10')](0xc8)[_0x9e5b('0x11')]({'message':_0x9e5b('0xbc'),'pid':_0x3ba0bb[_0x9e5b('0xbd')]});}catch(_0x5fc239){return _0x489a91[_0x9e5b('0x10')](0x1f4)['send'](_0x5fc239);}};exports[_0x9e5b('0xbe')]=function(_0x1456f8,_0x4b90f4){var _0x317a78=fs[_0x9e5b('0xbf')](_0x1456f8['file'][_0x9e5b('0xc0')]);Papa['parse'](_0x317a78,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x509775){return _0x4b90f4['status'](0xc8)['json']({'file':_0x1456f8[_0x9e5b('0xb5')],'fields':_0x509775[_0x9e5b('0xc1')][_0x9e5b('0x84')]});}});};exports['import']=function(_0x4e3e8c,_0xb75846){return db[_0x9e5b('0xc2')][_0x9e5b('0x23')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})['then'](function(_0x96cc10){var _0x2420d7=![];if(!_0x4e3e8c[_0x9e5b('0x37')]['ListId']){throw new Error('No\x20ListId\x20specified');}if(!_0x4e3e8c[_0x9e5b('0x37')][_0x9e5b('0xc3')][_0x9e5b('0x7c')]){throw new Error(_0x9e5b('0xc4'));}if(!_0x4e3e8c['body'][_0x9e5b('0xc3')]['firstName']){throw new Error(_0x9e5b('0xb2'));}if(!_0x4e3e8c['body']['socket_timestamp']){throw new Error(_0x9e5b('0xac'));}var _0x25af9f=require(_0x9e5b('0xb8'))[_0x9e5b('0xb9')](path[_0x9e5b('0x56')](__dirname,_0x9e5b('0xc5')),[_0x4e3e8c[_0x9e5b('0x27')]['id'],JSON[_0x9e5b('0xc6')](_0x4e3e8c[_0x9e5b('0x37')]),JSON[_0x9e5b('0xc6')](_0x96cc10)]);_0x25af9f['on'](_0x9e5b('0xc7'),function(){_0x2420d7=!![];return _0xb75846['status'](0xc8)[_0x9e5b('0x11')]({'message':'start\x20child\x20process\x20correctly!','pid':_0x25af9f[_0x9e5b('0xbd')]});});_0x25af9f['on'](_0x9e5b('0xc8'),function(_0x4fe9a1){if(_0x4fe9a1&&!_0x2420d7){return _0xb75846[_0x9e5b('0x10')](0x1f4)[_0x9e5b('0x11')]({'message':_0x9e5b('0xc9'),'pid':_0x25af9f[_0x9e5b('0xbd')]});}});})[_0x9e5b('0x25')](handleError(_0xb75846,null));};exports['importUpdates']=function(_0x4eea3f,_0x35f195){return db['User'][_0x9e5b('0x23')]({'raw':!![],'attributes':['id'],'where':{'role':_0x9e5b('0xca')}})[_0x9e5b('0x19')](function(_0x16b388){var _0x591e80=![];if(!_0x4eea3f[_0x9e5b('0x37')]['ListId']){throw new Error(_0x9e5b('0xa8'));}if(!_0x4eea3f[_0x9e5b('0x37')][_0x9e5b('0xc3')]['phone']){throw new Error(_0x9e5b('0xc4'));}if(!_0x4eea3f['body'][_0x9e5b('0xc3')][_0x9e5b('0xb1')]){throw new Error(_0x9e5b('0xb2'));}if(!_0x4eea3f[_0x9e5b('0x37')][_0x9e5b('0xab')]){throw new Error(_0x9e5b('0xac'));}var _0x4e070=require(_0x9e5b('0xb8'))[_0x9e5b('0xb9')](path[_0x9e5b('0x56')](__dirname,_0x9e5b('0xcb')),[_0x4eea3f[_0x9e5b('0x27')]['id'],JSON[_0x9e5b('0xc6')](_0x4eea3f['body']),JSON[_0x9e5b('0xc6')](_0x16b388)]);_0x4e070['on']('message',function(){_0x591e80=!![];return _0x35f195[_0x9e5b('0x10')](0xc8)[_0x9e5b('0x11')]({'message':'start\x20child\x20process\x20correctly!','pid':_0x4e070['pid']});});_0x4e070['on']('exit',function(_0x2b2e71){if(_0x2b2e71&&!_0x591e80){return _0x35f195[_0x9e5b('0x10')](0x1f4)[_0x9e5b('0x11')]({'message':_0x9e5b('0xc9'),'pid':_0x4e070['pid']});}});})[_0x9e5b('0x25')](handleError(_0x35f195,null));};exports[_0x9e5b('0xcc')]=function(_0x3a1f29,_0x181ced){var _0xaa2b98=['mail',_0x9e5b('0xcd'),_0x9e5b('0xce'),_0x9e5b('0xcf'),_0x9e5b('0xd0'),_0x9e5b('0xd1'),_0x9e5b('0xd2')];var _0x13be92={'offset':0x0,'order':qs[_0x9e5b('0x86')](_0x9e5b('0xd3'))},_0x2c624d={'count':0x0,'rows':[]};Promise[_0x9e5b('0xd4')]()[_0x9e5b('0x19')](function(){if(_0x3a1f29[_0x9e5b('0x2d')][_0x9e5b('0xd5')]){if(!_[_0x9e5b('0xd6')](_0xaa2b98,_0x3a1f29['query'][_0x9e5b('0xd5')][_0x9e5b('0xd7')]())){throw new Error(_0x9e5b('0xd8'));}_0xaa2b98=[_0x3a1f29['query'][_0x9e5b('0xd5')][_0x9e5b('0xd7')]()];}if(_0x3a1f29[_0x9e5b('0x2d')][_0x9e5b('0xd9')]){try{var _0x424ba9=JSON['parse'](_0x3a1f29[_0x9e5b('0x2d')][_0x9e5b('0xd9')]);if(!moment(_0x424ba9['from'])['isValid']()){throw new Error(_0x9e5b('0xda'));}if(!moment(_0x424ba9['to'])['isValid']()){throw new Error(_0x9e5b('0xdb'));}}catch(_0x52ae9f){throw new Error(_0x9e5b('0xdc'));}}if(!_0x3a1f29[_0x9e5b('0x2d')]['hasOwnProperty'](_0x9e5b('0x8a'))){_0x13be92[_0x9e5b('0x13')]=qs[_0x9e5b('0x13')](_0x3a1f29[_0x9e5b('0x2d')][_0x9e5b('0x13')]||0xa);_0x13be92[_0x9e5b('0x12')]=qs[_0x9e5b('0x12')](_0x3a1f29[_0x9e5b('0x2d')][_0x9e5b('0x12')]);}var _0x8f2125=_0xaa2b98[_0x9e5b('0x71')](function(_0x322193){if(_0x322193===_0x9e5b('0xd2')){var _0x4e58f1={'attributes':['id',_0x9e5b('0xdd'),_0x9e5b('0x33'),_0x9e5b('0xde'),_0x9e5b('0xdf'),_0x9e5b('0xe0'),_0x9e5b('0xe1'),_0x9e5b('0xe2'),'duration',_0x9e5b('0xe3'),_0x9e5b('0xe4'),'userDisposition',_0x9e5b('0xe5'),_0x9e5b('0xe6'),'UserId'],'where':{'ContactId':_0x3a1f29['params']['id']},'include':[{'model':db[_0x9e5b('0xc2')],'as':'User','attributes':['id','name',_0x9e5b('0xe7'),'alias']}],'order':[[_0x9e5b('0xe4'),'DESC']]};if(_0x3a1f29[_0x9e5b('0x2d')][_0x9e5b('0xd9')]){_0x4e58f1[_0x9e5b('0x5e')][_0x9e5b('0xe4')]={'$gte':_0x424ba9[_0x9e5b('0x38')],'$lte':_0x424ba9['to']};}return db['VoiceCallReport']['findAndCountAll'](_0x4e58f1)[_0x9e5b('0x19')](function(_0x38cec1){_0x2c624d[_0x9e5b('0x15')]+=_0x38cec1[_0x9e5b('0x15')];return _[_0x9e5b('0x71')](_0x38cec1[_0x9e5b('0xa3')],function(_0x1fe088){var _0x53d84f=_0x1fe088[_0x9e5b('0x39')]({'plain':!![]});_0x53d84f[_0x9e5b('0xd5')]=_0x322193;if(_0x53d84f['User']){_0x53d84f['User']={'id':_0x53d84f['User']['id'],'name':_0x53d84f[_0x9e5b('0xc2')][_0x9e5b('0x1e')],'fullname':_0x53d84f['User'][_0x9e5b('0xe7')],'alias':_0x53d84f[_0x9e5b('0xc2')]['alias']};}return _0x53d84f;});});}else{var _0x33d38a=_['startCase'](_0x322193)+(_0x322193===_0x9e5b('0xcd')?_0x9e5b('0xe8'):'Account');var _0x2ab6a8={'attributes':['id',_0x9e5b('0xe9'),_0x9e5b('0xea'),_0x9e5b('0xe4'),'note',_0x9e5b('0xeb'),_0x9e5b('0xec'),_0x9e5b('0xed'),'UserId',_0x33d38a+'Id'],'where':{'ContactId':_0x3a1f29[_0x9e5b('0x27')]['id']},'include':[{'model':db[_0x33d38a],'as':'Account','attributes':['id',_0x9e5b('0x1e'),_0x9e5b('0xee')]},{'model':db[_0x9e5b('0xc2')],'as':'Owner','attributes':['id',_0x9e5b('0x1e'),'fullname']},{'model':db['Tag'],'as':_0x9e5b('0xef'),'attributes':['id',_0x9e5b('0x1e'),_0x9e5b('0x68')],'through':{'attributes':[]}}],'order':[[_0x9e5b('0xe4'),_0x9e5b('0xf0')]]};if(_0x3a1f29[_0x9e5b('0x2d')][_0x9e5b('0xd9')]){_0x2ab6a8[_0x9e5b('0x5e')][_0x9e5b('0xe4')]={'$gte':_0x424ba9[_0x9e5b('0x38')],'$lte':_0x424ba9['to']};}switch(_0x322193){case _0x9e5b('0xcd'):_0x2ab6a8[_0x9e5b('0x83')][_0x9e5b('0x5f')](_0x9e5b('0xf1'),_0x9e5b('0xf2'),_0x9e5b('0xf3'),_0x9e5b('0xf4'),_0x9e5b('0xf5'),_0x9e5b('0xf6'),_0x9e5b('0xf7'),_0x9e5b('0xf8'),_0x9e5b('0xf9'));break;case _0x9e5b('0xfa'):_0x2ab6a8[_0x9e5b('0x83')][_0x9e5b('0x5f')](_0x9e5b('0xfb'),'substatus');break;case _0x9e5b('0xcf'):_0x2ab6a8['attributes'][_0x9e5b('0x5f')](_0x9e5b('0xfc'),'threadId');break;}return db[_[_0x9e5b('0xfd')](_0x322193)+_0x9e5b('0xfe')][_0x9e5b('0xff')](_0x2ab6a8)[_0x9e5b('0x19')](function(_0x52d735){_0x2c624d['count']+=_0x52d735[_0x9e5b('0x15')];return _[_0x9e5b('0x71')](_0x52d735[_0x9e5b('0xa3')],function(_0x4f926f){var _0x12473a=_0x4f926f[_0x9e5b('0x39')]({'plain':!![]});_0x12473a[_0x9e5b('0xd5')]=_0x322193;if(_0x12473a[_0x9e5b('0x100')]){_0x12473a[_0x9e5b('0x100')]={'id':_0x12473a[_0x9e5b('0x100')]['id'],'name':_0x12473a[_0x9e5b('0x100')][_0x9e5b('0x1e')],'fullname':_0x12473a['Owner']['fullname']};}return _0x12473a;});});}});return Promise['all'](_0x8f2125);})[_0x9e5b('0x19')](function(_0x3f0ba5){return _(_0x3f0ba5)[_0x9e5b('0x101')]()[_0x9e5b('0x102')](_0x9e5b('0xe4'))['reverse']()[_0x9e5b('0x103')]();})[_0x9e5b('0x19')](function(_0x1a5a62){_0x2c624d['rows']=_0x13be92['limit']?_0x1a5a62[_0x9e5b('0x104')](_0x13be92[_0x9e5b('0x12')],_0x13be92[_0x9e5b('0x12')]+_0x13be92[_0x9e5b('0x13')]):_0x1a5a62;return _0x2c624d;})[_0x9e5b('0x19')](respondWithFilteredResult(_0x181ced,_0x13be92))['catch'](handleError(_0x181ced,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff