// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x3c63=['length','get','mergeWith','isArray','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','from','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappMessage','WhatsappQueueReport','join','dialTimezone','isNil','timezones','utcOffset','additionalPhones','bulkCreate','each','duplicates','push','where','ListId','findOrCreate','contact','all','show','Tag','color','tag','CmContactHasItem','Phones','ContactItemType','ItemType','sequelize','literal','Phones.OrderBy','$and','omit','map','cf_%d','pickBy','format','setFields','id\x20=\x20?','toParam','text','phone','getTags','findOne','model','rawAttributes','filters','intersection','fields','attributes','sort','pick','filter','options','setTags','OrderBy','items','item_types','ItemTypeId','description','contact\x20phone\x20exists','PHONE','item','`ItemType`.OrderBy','CmHopperId','ItemType.OrderBy','CmHopperAdditionalPhone','getAdditionalPhones','fromContactId','toContactId','rescheduleAdditionalPhones','hopperId','getHoppers','nolimit','order','ContactId','includeAll','include','rows','CmHopperFinal','getJscriptySessions','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','socket_timestamp','split','No\x20phone\x20column\x20specified','firstName','server/files/tmp','file','filename','chmodSync','0777','child_process','fork','CompanyId','File\x20uploaded\x20correctly!','send','upload','createReadStream','parse','meta','User','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','../../components/import/cm/csv2','stringify','start\x20child\x20process\x20correctly!','pid','error\x20child\x20process','binding','No\x20firstName\x20column\x20specified','../../components/import/cm/csvUpdates','exit','getJourney','sms','openchannel','fax','whatsapp','voice','-createdAt','resolve','channel','includes','toLowerCase','Invalid\x20channel','range','Invalid\x20date\x20for\x20range\x20from\x20filter','isValid','Invalid\x20createdAt\x20filter','source','callerid','starttime','duration','note','createdAt','userDisposition','userSecondDisposition','userThirdDisposition','UserId','fullname','findAndCountAll','chat','Website','Account','closed','closedAt','thirdDisposition','key','Tags','DESC','browserName','customerIp','customerPort','deviceModel','osName','ratingMessage','ratingType','ratingValue','referer','mail','externalUrl','threadId','startCase','Interaction','Owner','flatten','sortBy','reverse','slice','moment','util','path','lodash','squel','ioredis','../../components/contacts','../../config/logger','api','../../config/environment','../../config/environment/shared','redis','defaults','localhost','./cmContact.socket','register','status','offset','undefined','limit','count','set','Content-Range','json','update','then','end','sendStatus','error','name','index','describe','getOptions','findAll','user','catch','destroy','CmContact','find','params','tags','keys','startsWith','columnName','displayName','query','analytics','CmCustomField','cf_','alias','type','values','info','Custom\x20field\x20%s\x20not\x20found\x20on\x20cm_contacts\x20table','forEach','hasOwnProperty','merge','body'];(function(_0xe96487,_0x36c816){var _0x500779=function(_0x97b53f){while(--_0x97b53f){_0xe96487['push'](_0xe96487['shift']());}};_0x500779(++_0x36c816);}(_0x3c63,0x1c0));var _0x33c6=function(_0x47aa64,_0xfb8a07){_0x47aa64=_0x47aa64-0x0;var _0x549c7a=_0x3c63[_0x47aa64];return _0x549c7a;};'use strict';var moment=require(_0x33c6('0x0'));var BPromise=require('bluebird');var util=require(_0x33c6('0x1'));var path=require(_0x33c6('0x2'));var fs=require('fs');var _=require(_0x33c6('0x3'));var squel=require(_0x33c6('0x4'));var Papa=require('papaparse');var Redis=require(_0x33c6('0x5'));var contacts=require(_0x33c6('0x6'));var qs=require('../../components/parsers/qs');var logger=require(_0x33c6('0x7'))(_0x33c6('0x8'));var config=require(_0x33c6('0x9'));var shared=require(_0x33c6('0xa'));var db=require('../../mysqldb')['db'];config[_0x33c6('0xb')]=_[_0x33c6('0xc')](config['redis'],{'host':_0x33c6('0xd'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x33c6('0xb')]));require(_0x33c6('0xe'))[_0x33c6('0xf')](socket);function respondWithResult(_0x345f10,_0xe20be6){_0xe20be6=_0xe20be6||0xc8;return function(_0x25b1b3){if(_0x25b1b3){return _0x345f10[_0x33c6('0x10')](_0xe20be6)['json'](_0x25b1b3);}};}function respondWithFilteredResult(_0x25cbe1,_0x27b773){return function(_0x1ed86f){if(_0x1ed86f){var _0x394e9d=typeof _0x27b773[_0x33c6('0x11')]===_0x33c6('0x12')&&typeof _0x27b773[_0x33c6('0x13')]===_0x33c6('0x12');var _0x122750=_0x1ed86f['count'];var _0x5a1be6=_0x394e9d?0x0:_0x27b773[_0x33c6('0x11')];var _0xa94506=_0x394e9d?_0x1ed86f[_0x33c6('0x14')]:_0x27b773[_0x33c6('0x11')]+_0x27b773[_0x33c6('0x13')];var _0x291ec0;if(_0xa94506>=_0x122750){_0xa94506=_0x122750;_0x291ec0=0xc8;}else{_0x291ec0=0xce;}_0x25cbe1[_0x33c6('0x10')](_0x291ec0);return _0x25cbe1[_0x33c6('0x15')](_0x33c6('0x16'),_0x5a1be6+'-'+_0xa94506+'/'+_0x122750)[_0x33c6('0x17')](_0x1ed86f);}return null;};}function saveUpdates(_0x1867c2){return function(_0x19f0f6){if(_0x19f0f6){return _0x19f0f6[_0x33c6('0x18')](_0x1867c2)[_0x33c6('0x19')](function(_0x58f8e3){return _0x58f8e3;});}return null;};}function removeEntity(_0x37bed2){return function(_0x31cda1){if(_0x31cda1){return _0x31cda1['destroy']()['then'](function(){_0x37bed2[_0x33c6('0x10')](0xcc)[_0x33c6('0x1a')]();});}};}function handleEntityNotFound(_0x170ae3){return function(_0x348ccb){if(!_0x348ccb){_0x170ae3[_0x33c6('0x1b')](0x194);}return _0x348ccb;};}function handleError(_0x10e66b,_0x48ed25){_0x48ed25=_0x48ed25||0x1f4;return function(_0x2b09e8){logger[_0x33c6('0x1c')](_0x2b09e8['stack']);if(_0x2b09e8[_0x33c6('0x1d')]){delete _0x2b09e8[_0x33c6('0x1d')];}_0x10e66b[_0x33c6('0x10')](_0x48ed25)['send'](_0x2b09e8);};}exports[_0x33c6('0x1e')]=function(_0x2629d0,_0x24aa33){var _0x38cd68={};return contacts[_0x33c6('0x1f')]()[_0x33c6('0x19')](function(_0x49471e){_0x38cd68=qs[_0x33c6('0x20')](_0x49471e,_0x2629d0);return contacts[_0x33c6('0x21')](_0x2629d0['query'],_0x2629d0[_0x33c6('0x22')],_0x38cd68,_0x49471e);})['then'](respondWithFilteredResult(_0x24aa33,_0x38cd68))[_0x33c6('0x23')](handleError(_0x24aa33,null));};exports[_0x33c6('0x24')]=function(_0x4c2aa9,_0x57cf25){return db[_0x33c6('0x25')][_0x33c6('0x26')]({'where':{'id':_0x4c2aa9[_0x33c6('0x27')]['id']}})[_0x33c6('0x19')](handleEntityNotFound(_0x57cf25,null))[_0x33c6('0x19')](removeEntity(_0x57cf25,null))['catch'](handleError(_0x57cf25,null));};exports[_0x33c6('0x1f')]=function(_0x5243cd,_0x5ef1f5){return db[_0x33c6('0x25')][_0x33c6('0x1f')]()['then'](function(_0x35d6c2){delete _0x35d6c2[_0x33c6('0x28')];for(var _0x44834c=0x0;_0x44834c<Object[_0x33c6('0x29')](_0x35d6c2)['length'];_0x44834c++){var _0x4fddbb=Object['keys'](_0x35d6c2)[_0x44834c];if(!_[_0x33c6('0x2a')](_0x4fddbb,'cf_')){_0x35d6c2[_0x4fddbb][_0x33c6('0x2b')]=_0x4fddbb;_0x35d6c2[_0x4fddbb][_0x33c6('0x2c')]=_0x4fddbb;}}return _0x35d6c2;})['then'](function(_0x59fa6b){var _0x43b513={'where':Boolean(_0x5243cd[_0x33c6('0x2d')][_0x33c6('0x2e')])===!![]?undefined:{'$or':[{'ListId':_0x5243cd[_0x33c6('0x2d')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x33c6('0x2f')][_0x33c6('0x21')](_0x43b513)[_0x33c6('0x19')](function(_0x429852){for(var _0x162be1=0x0;_0x162be1<_0x429852['length'];_0x162be1++){var _0x4ee415=_0x33c6('0x30')+_0x429852[_0x162be1]['id'];if(_0x59fa6b[_0x4ee415]){_0x59fa6b[_0x4ee415]['columnName']=_0x4ee415;_0x59fa6b[_0x4ee415][_0x33c6('0x2c')]=_0x429852[_0x162be1][_0x33c6('0x31')];_0x59fa6b[_0x4ee415]['custom']={'type':_0x429852[_0x162be1][_0x33c6('0x32')],'values':_0x429852[_0x162be1][_0x33c6('0x33')]};}else{logger[_0x33c6('0x34')](_0x33c6('0x35'),_0x4ee415);}}Object[_0x33c6('0x29')](_0x59fa6b)[_0x33c6('0x36')](function(_0x201b0b){if(!_0x59fa6b[_0x201b0b][_0x33c6('0x37')](_0x33c6('0x2b'))){delete _0x59fa6b[_0x201b0b];}});return _0x59fa6b;});})['then'](respondWithResult(_0x5ef1f5,null))[_0x33c6('0x23')](handleError(_0x5ef1f5,null));};exports[_0x33c6('0x38')]=function(_0x36659b,_0x5f0039){var _0x2c963f;var _0x17f3e6;var _0x4042ea;if(_0x36659b[_0x33c6('0x39')]['id']){delete _0x36659b[_0x33c6('0x39')]['id'];}return db[_0x33c6('0x25')][_0x33c6('0x21')]({'where':{'id':[_0x36659b['body']['to'],_0x36659b['body']['from']]}})['then'](function(_0x261a45){if(_0x261a45){if(_0x261a45[_0x33c6('0x3a')]!==0x2){return null;}_0x261a45[0x0]=_0x261a45[0x0][_0x33c6('0x3b')]({'plain':!![]});_0x261a45[0x1]=_0x261a45[0x1][_0x33c6('0x3b')]({'plain':!![]});delete _0x261a45[0x0]['id'];delete _0x261a45[0x1]['id'];return _[_0x33c6('0x3c')](_0x261a45[0x0],_0x261a45[0x1],function(_0x3cee74,_0x40eb33){if(Array[_0x33c6('0x3d')](_0x40eb33)&&!_0x40eb33[_0x33c6('0x3a')]){return _0x3cee74;}else if(!_0x40eb33){return _0x3cee74;}});}})['then'](handleEntityNotFound(_0x5f0039,null))['then'](function(_0x22b670){if(_0x22b670){if(_0x22b670[_0x33c6('0x28')]&&_[_0x33c6('0x3d')](_0x22b670[_0x33c6('0x28')])){_0x22b670[_0x33c6('0x28')]=_0x22b670[_0x33c6('0x28')]['join']();}logger['info'](_0x33c6('0x3e'),_0x36659b[_0x33c6('0x39')]['to'],_0x36659b[_0x33c6('0x39')]['from']);return db[_0x33c6('0x3f')][_0x33c6('0x24')]({'where':{'ContactId':[_0x36659b['body']['to'],_0x36659b[_0x33c6('0x39')][_0x33c6('0x40')]]}})['then'](function(_0x49b480){logger['info'](_0x33c6('0x41'),_0x49b480);return db[_0x33c6('0x42')][_0x33c6('0x24')]({'where':{'ContactId':[_0x36659b[_0x33c6('0x39')]['to'],_0x36659b['body'][_0x33c6('0x40')]]}})['then'](function(_0x39e4ae){logger[_0x33c6('0x34')]('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x39e4ae);return db[_0x33c6('0x25')][_0x33c6('0x43')](_0x22b670);});});}})['then'](function(_0x51945b){if(_0x51945b){_0x2c963f=_0x51945b;_0x17f3e6={'ContactId':_0x2c963f['id']};_0x4042ea={'where':{'ContactId':[_0x36659b[_0x33c6('0x39')]['to'],_0x36659b[_0x33c6('0x39')][_0x33c6('0x40')]]}};return db[_0x33c6('0x44')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x45')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x46')]['update'](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x47')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db['MailMessage'][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x47')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})['then'](function(){if(_0x2c963f){return db[_0x33c6('0x48')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})['then'](function(){if(_0x2c963f){return db['SmsInteraction'][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x49')]['update'](_0x17f3e6,_0x4042ea);}})['then'](function(){if(_0x2c963f){return db[_0x33c6('0x4a')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x4b')]['update'](_0x17f3e6,_0x4042ea);}})['then'](function(){if(_0x2c963f){return db[_0x33c6('0x4c')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})['then'](function(){if(_0x2c963f){return db[_0x33c6('0x4d')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db['CmContactHasItem'][_0x33c6('0x18')]({'CmContactId':_0x2c963f['id']},{'where':{'CmContactId':[_0x36659b[_0x33c6('0x39')]['to'],_0x36659b[_0x33c6('0x39')][_0x33c6('0x40')]]}});}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db['CmHopperFinal']['update'](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x4e')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x4f')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x50')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x51')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x52')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db['MailQueueReport'][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})['then'](function(){if(_0x2c963f){return db['OpenchannelQueueReport'][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db['SmsQueueReport'][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x53')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})['then'](function(){if(_0x2c963f){return db[_0x33c6('0x54')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x55')][_0x33c6('0x18')](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x56')]['update'](_0x17f3e6,_0x4042ea);}})[_0x33c6('0x19')](function(){if(_0x2c963f){return db[_0x33c6('0x25')][_0x33c6('0x24')]({'where':{'id':[_0x36659b[_0x33c6('0x39')]['to'],_0x36659b[_0x33c6('0x39')]['from']]}});}})[_0x33c6('0x19')](function(){if(_0x2c963f){return _0x2c963f;}})[_0x33c6('0x19')](respondWithResult(_0x5f0039,null))[_0x33c6('0x23')](handleError(_0x5f0039,null));};exports[_0x33c6('0x43')]=function(_0x1f935a,_0x1e8ec8){return db['CmContact'][_0x33c6('0x1f')]()[_0x33c6('0x19')](function(_0x36f1de){if(_0x1f935a['body'][_0x33c6('0x28')]&&_['isArray'](_0x1f935a[_0x33c6('0x39')][_0x33c6('0x28')])){if(_0x1f935a[_0x33c6('0x39')][_0x33c6('0x28')][_0x33c6('0x3a')]){_0x1f935a[_0x33c6('0x39')][_0x33c6('0x28')]=_0x1f935a[_0x33c6('0x39')][_0x33c6('0x28')][_0x33c6('0x57')](';')+';';}else{_0x1f935a[_0x33c6('0x39')]['tags']=null;}}else{_0x1f935a[_0x33c6('0x39')][_0x33c6('0x28')]=null;}if(!_['isNil'](_0x1f935a['body'][_0x33c6('0x58')])){var _0x3a4b0c=_0x1f935a['body'][_0x33c6('0x58')];if(!_[_0x33c6('0x59')](shared[_0x33c6('0x5a')][_0x3a4b0c]))_0x1f935a[_0x33c6('0x39')][_0x33c6('0x5b')]=shared[_0x33c6('0x5a')][_0x3a4b0c][_0x33c6('0x5b')];}return db[_0x33c6('0x25')][_0x33c6('0x43')](_0x1f935a[_0x33c6('0x39')],{'fields':_[_0x33c6('0x29')](_0x36f1de),'raw':!![]});})[_0x33c6('0x19')](function(_0x3cbd05){if(_0x1f935a[_0x33c6('0x39')][_0x33c6('0x5c')]){return insertAdditionalPhones(_0x3cbd05,_0x1f935a['body'][_0x33c6('0x5c')]);}else{return _0x3cbd05;}})[_0x33c6('0x19')](respondWithResult(_0x1e8ec8,0xc9))[_0x33c6('0x23')](handleError(_0x1e8ec8,null));};exports[_0x33c6('0x5d')]=function(_0x368176,_0x3ba84b){var _0x26f30b=0x0;var _0x298d03=0x0;var _0x4109c7=0x0;var _0x532537=[];return db[_0x33c6('0x25')][_0x33c6('0x1f')]()[_0x33c6('0x19')](function(_0x598898){return BPromise[_0x33c6('0x5e')](_0x368176[_0x33c6('0x39')],function(_0x1a98e9){var _0x35a8ec={'where':{'$or':[]},'defaults':_0x1a98e9,'fields':_[_0x33c6('0x29')](_0x598898),'raw':!![]};if(_0x1a98e9[_0x33c6('0x5f')]){for(var _0xbde114=0x0;_0xbde114<_0x1a98e9['duplicates'][_0x33c6('0x3a')];_0xbde114++){var _0xe91a8e={};_0xe91a8e[_0x1a98e9[_0x33c6('0x5f')][_0xbde114]]=_0x1a98e9[_0x1a98e9[_0x33c6('0x5f')][_0xbde114]];_0x35a8ec['where']['$or'][_0x33c6('0x60')](_0xe91a8e);}_0x35a8ec[_0x33c6('0x61')][_0x33c6('0x62')]=_0x1a98e9[_0x33c6('0x62')];}return db[_0x33c6('0x25')][_0x33c6('0x63')](_0x35a8ec)['spread'](function(_0x9a769d,_0xd8b16b){if(_0xd8b16b){if(_0x1a98e9[_0x33c6('0x37')]('additionalPhones')){_0x532537[_0x33c6('0x60')]({'contact':_0x9a769d,'additionalPhones':_0x1a98e9['additionalPhones']});}_0x26f30b++;}else{_0x4109c7++;}})[_0x33c6('0x23')](function(){_0x298d03++;});});})[_0x33c6('0x19')](function(_0x5eb861){if(_0x5eb861){if(_0x532537[_0x33c6('0x3a')]>0x0){return new Promise(function(_0x46fae3){var _0x4d4fee=[];for(var _0x3cb914=0x0;_0x3cb914<_0x532537[_0x33c6('0x3a')];_0x3cb914++){_0x4d4fee[_0x33c6('0x60')](insertAdditionalPhones(_0x532537[_0x3cb914][_0x33c6('0x64')],_0x532537[_0x3cb914][_0x33c6('0x5c')]));}Promise[_0x33c6('0x65')](_0x4d4fee)[_0x33c6('0x19')](function(){_0x46fae3(0x1);});})[_0x33c6('0x19')](function(){return{'success':_0x26f30b,'failure':_0x298d03,'duplicates':_0x4109c7};});}else{return{'success':_0x26f30b,'failure':_0x298d03,'duplicates':_0x4109c7};}}})[_0x33c6('0x19')](respondWithResult(_0x3ba84b,0xc9))['catch'](handleError(_0x3ba84b,null));};exports[_0x33c6('0x66')]=function(_0x2d6b1e,_0x157fc3){var _0x20fdf2;return db[_0x33c6('0x25')][_0x33c6('0x1f')]()[_0x33c6('0x19')](function(_0x45a217){return db[_0x33c6('0x25')]['find']({'where':{'id':_0x2d6b1e[_0x33c6('0x27')]['id']},'include':[{'model':db[_0x33c6('0x67')],'as':'Tags','attributes':['id','name',_0x33c6('0x68')],'required':_0x2d6b1e['query'][_0x33c6('0x69')]?!![]:![]},{'model':db[_0x33c6('0x6a')],'as':_0x33c6('0x6b'),'where':{'CmContactId':_0x2d6b1e[_0x33c6('0x27')]['id']},'required':![],'include':[{'model':db[_0x33c6('0x6c')],'as':_0x33c6('0x6d')}]}],'order':[db[_0x33c6('0x6e')][_0x33c6('0x6f')](_0x33c6('0x70'))],'attributes':_['keys'](_0x45a217)});})['then'](function(_0x19d8b6){if(!_[_0x33c6('0x59')](_0x19d8b6)){_0x20fdf2=_0x19d8b6['get']({'plain':!![]});var _0x571372={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x19d8b6&&_0x19d8b6[_0x33c6('0x62')]){if(_0x19d8b6['ListId']){_0x571372[_0x33c6('0x61')][_0x33c6('0x71')][_0x33c6('0x60')]({'ListId':{'$ne':_0x19d8b6[_0x33c6('0x62')]}});}}return db[_0x33c6('0x2f')][_0x33c6('0x21')](_0x571372);}})[_0x33c6('0x19')](function(_0x58e729){if(!_['isNil'](_0x58e729)){return _[_0x33c6('0x72')](_0x20fdf2,_[_0x33c6('0x73')](_0x58e729,function(_0x527f10){return util['format'](_0x33c6('0x74'),_0x527f10['id']);}));}})[_0x33c6('0x19')](handleEntityNotFound(_0x157fc3,null))[_0x33c6('0x19')](respondWithResult(_0x157fc3,null))[_0x33c6('0x23')](handleError(_0x157fc3,null));};exports[_0x33c6('0x18')]=function(_0x23e996,_0x25130d){var _0x3f246e;if(_0x23e996['body']['id']){delete _0x23e996['body']['id'];}if(!_['isNil'](_0x23e996[_0x33c6('0x39')][_0x33c6('0x58')])){var _0x5c2ddd=_0x23e996[_0x33c6('0x39')][_0x33c6('0x58')];if(!_['isNil'](shared['timezones'][_0x5c2ddd]))_0x23e996[_0x33c6('0x39')][_0x33c6('0x5b')]=shared[_0x33c6('0x5a')][_0x5c2ddd][_0x33c6('0x5b')];}return db[_0x33c6('0x25')][_0x33c6('0x26')]({'where':{'id':_0x23e996[_0x33c6('0x27')]['id']}})[_0x33c6('0x19')](handleEntityNotFound(_0x25130d,null))['then'](saveUpdates(_0x23e996[_0x33c6('0x39')],null))[_0x33c6('0x19')](function(_0x57fcbe){_0x3f246e=_0x57fcbe;var _0x4ae5c5={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x57fcbe&&_0x57fcbe[_0x33c6('0x62')]){if(_0x57fcbe['ListId']){_0x4ae5c5[_0x33c6('0x61')]['$and'][_0x33c6('0x60')]({'ListId':{'$ne':_0x57fcbe['ListId']}});}}return db['CmCustomField']['findAll'](_0x4ae5c5);})[_0x33c6('0x19')](function(_0x56ebd5){if(_0x56ebd5){return _[_0x33c6('0x72')](_[_0x33c6('0x75')](_0x23e996['body'],function(_0x5906cf,_0x329b6a){return _[_0x33c6('0x2a')](_0x329b6a,_0x33c6('0x30'));}),_['map'](_0x56ebd5,function(_0x365ab3){return util[_0x33c6('0x76')](_0x33c6('0x74'),_0x365ab3['id']);}));}})[_0x33c6('0x19')](function(_0x50b0c7){if(_0x50b0c7&&!_['isEmpty'](_0x50b0c7)){var _0x316d8c=squel[_0x33c6('0x18')]()['table']('cm_contacts')[_0x33c6('0x77')](_0x50b0c7)[_0x33c6('0x61')](_0x33c6('0x78'),_0x23e996[_0x33c6('0x27')]['id'])[_0x33c6('0x79')]();return db[_0x33c6('0x6e')]['query'](_0x316d8c[_0x33c6('0x7a')],{'replacements':_0x316d8c[_0x33c6('0x33')]});}})['then'](function(){if(_0x23e996[_0x33c6('0x39')]['phone']&&_0x3f246e){return db[_0x33c6('0x3f')][_0x33c6('0x18')]({'phone':_0x23e996[_0x33c6('0x39')][_0x33c6('0x7b')],'OrderBy':0x0},{'where':{'ContactId':_0x3f246e['id']}});}})[_0x33c6('0x19')](function(){return _0x3f246e;})['then'](respondWithResult(_0x25130d,null))['catch'](handleError(_0x25130d,null));};exports[_0x33c6('0x7c')]=function(_0x578f07,_0x2ef105){var _0x4739cc={};var _0x35068c={};var _0x473745;var _0x6bcdb0;return db[_0x33c6('0x25')][_0x33c6('0x7d')]({'where':{'id':_0x578f07['params']['id']}})[_0x33c6('0x19')](handleEntityNotFound(_0x2ef105,null))[_0x33c6('0x19')](function(_0x17bcc9){if(_0x17bcc9){_0x473745=_0x17bcc9;_0x35068c[_0x33c6('0x7e')]=_[_0x33c6('0x29')](db[_0x33c6('0x67')][_0x33c6('0x7f')]);_0x35068c['query']=_['keys'](_0x578f07[_0x33c6('0x2d')]);_0x35068c[_0x33c6('0x80')]=_[_0x33c6('0x81')](_0x35068c[_0x33c6('0x7e')],_0x35068c[_0x33c6('0x2d')]);_0x4739cc['attributes']=_[_0x33c6('0x81')](_0x35068c[_0x33c6('0x7e')],qs[_0x33c6('0x82')](_0x578f07['query'][_0x33c6('0x82')]));_0x4739cc[_0x33c6('0x83')]=_0x4739cc[_0x33c6('0x83')][_0x33c6('0x3a')]?_0x4739cc[_0x33c6('0x83')]:_0x35068c['model'];_0x4739cc['order']=qs[_0x33c6('0x84')](_0x578f07[_0x33c6('0x2d')][_0x33c6('0x84')]);_0x4739cc[_0x33c6('0x61')]=qs[_0x33c6('0x80')](_[_0x33c6('0x85')](_0x578f07['query'],_0x35068c[_0x33c6('0x80')]));if(_0x578f07[_0x33c6('0x2d')][_0x33c6('0x86')]){_0x4739cc['where']=_[_0x33c6('0x38')](_0x4739cc[_0x33c6('0x61')],{'$or':_[_0x33c6('0x73')](_0x4739cc['attributes'],function(_0x260107){var _0x5cc06a={};_0x5cc06a[_0x260107]={'$like':'%'+_0x578f07[_0x33c6('0x2d')][_0x33c6('0x86')]+'%'};return _0x5cc06a;})});}_0x4739cc=_[_0x33c6('0x38')]({},_0x4739cc,_0x578f07[_0x33c6('0x87')]);return _0x473745['getTags'](_0x4739cc);}})[_0x33c6('0x19')](function(_0x3037c5){if(_0x3037c5){_0x6bcdb0=_0x3037c5[_0x33c6('0x3a')];if(!_0x578f07[_0x33c6('0x2d')][_0x33c6('0x37')]('nolimit')){_0x4739cc[_0x33c6('0x13')]=qs[_0x33c6('0x13')](_0x578f07[_0x33c6('0x2d')][_0x33c6('0x13')]);_0x4739cc['offset']=qs[_0x33c6('0x11')](_0x578f07[_0x33c6('0x2d')][_0x33c6('0x11')]);}return _0x473745[_0x33c6('0x7c')](_0x4739cc);}})[_0x33c6('0x19')](function(_0x7ec66c){if(_0x7ec66c){return _0x7ec66c?{'count':_0x6bcdb0,'rows':_0x7ec66c}:null;}})[_0x33c6('0x19')](respondWithResult(_0x2ef105,null))[_0x33c6('0x23')](handleError(_0x2ef105,null));};exports[_0x33c6('0x88')]=function(_0x19a212,_0x112edf){if(_0x19a212[_0x33c6('0x39')]['id']){delete _0x19a212[_0x33c6('0x39')]['id'];}return db[_0x33c6('0x25')][_0x33c6('0x7d')]({'where':{'id':_0x19a212[_0x33c6('0x27')]['id']}})['then'](handleEntityNotFound(_0x112edf,null))[_0x33c6('0x19')](function(_0x23fa2e){if(_0x23fa2e){return _0x23fa2e[_0x33c6('0x88')](_0x19a212['body']['ids']||[]);}return null;})[_0x33c6('0x19')](respondWithResult(_0x112edf,null))[_0x33c6('0x23')](handleError(_0x112edf,null));};exports['setAdditionalPhones']=function(_0x5268a6,_0x421a4a){var _0x369f30=[];_0x369f30[_0x33c6('0x60')](addAdditionalPhones(_0x5268a6['body']));Promise[_0x33c6('0x65')](_0x369f30)['then'](function(){_0x369f30=[];_0x369f30['push'](deleteCmHopperPhones(_0x5268a6[_0x33c6('0x39')]['id']));_0x369f30['push'](addCmHopperPhones(_0x5268a6[_0x33c6('0x39')]['id']));Promise[_0x33c6('0x65')](_0x369f30)[_0x33c6('0x19')](function(){return[0x1];})[_0x33c6('0x19')](respondWithResult(_0x421a4a,null));});};function addAdditionalPhones(_0x1b80c0){var _0x21a239;return new Promise(function(_0x3d5861){return db[_0x33c6('0x6a')][_0x33c6('0x24')]({'where':{'CmContactId':_0x1b80c0['id']}})[_0x33c6('0x19')](function(){db['ContactItemType'][_0x33c6('0x21')]({'raw':!![],'attributes':['id',_0x33c6('0x89')]})['then'](function(_0x1621b3){var _0x249aa9=[];for(var _0x1c0d22=0x0;_0x1c0d22<_0x1b80c0[_0x33c6('0x8a')][_0x33c6('0x3a')];_0x1c0d22++){var _0x5ea8d8=_0x1b80c0[_0x33c6('0x8b')]?_['isNil'](_0x1b80c0[_0x33c6('0x8b')][_0x1c0d22])?'':_0x1b80c0[_0x33c6('0x8b')][_0x1c0d22]:_0x1b80c0[_0x33c6('0x8a')][_0x1c0d22][_0x33c6('0x8c')]?_0x1b80c0['items'][_0x1c0d22][_0x33c6('0x8c')]:'';var _0x40818a=_[_0x33c6('0x59')](_0x1b80c0['items'][_0x1c0d22]['description'])?'':_0x1b80c0[_0x33c6('0x8a')][_0x1c0d22][_0x33c6('0x8d')];var _0x328963=_0x5ea8d8+':'+_0x1b80c0[_0x33c6('0x8a')][_0x1c0d22][_0x33c6('0x7b')]+'§'+_0x40818a;if(_[_0x33c6('0x59')](_0x21a239))_0x21a239=_0x328963;else _0x21a239+=';'+_0x328963;var _0x56f73b=null;var _0x3505bc=null;if(_0x1b80c0[_0x33c6('0x8b')]){if(!_[_0x33c6('0x59')](_0x1b80c0[_0x33c6('0x8b')][_0x1c0d22])){_0x3505bc=_['find'](_0x1621b3,function(_0x169b48){return _0x169b48['id']===_0x1b80c0[_0x33c6('0x8b')][_0x1c0d22];});if(!_[_0x33c6('0x59')](_0x3505bc)){_0x56f73b=_0x3505bc['OrderBy'];}}}else{if(!_[_0x33c6('0x59')](_0x1b80c0[_0x33c6('0x8a')][_0x1c0d22])){_0x3505bc=_['find'](_0x1621b3,function(_0xb165b7){return _0xb165b7['id']===_0x1b80c0['items'][_0x1c0d22][_0x33c6('0x8c')];});if(!_[_0x33c6('0x59')](_0x3505bc)){_0x56f73b=_0x1c0d22;}}}if(_[_0x33c6('0x59')](_0x56f73b)){_0x56f73b=0x64;}_0x249aa9[_0x33c6('0x60')](addAdditionalPhone(_0x1b80c0['id'],_0x1b80c0['items'][_0x1c0d22][_0x33c6('0x7b')],_0x1b80c0[_0x33c6('0x8b')]?_[_0x33c6('0x59')](_0x1b80c0['item_types'][_0x1c0d22])?null:_0x1b80c0[_0x33c6('0x8b')][_0x1c0d22]:_0x1b80c0['items'][_0x1c0d22][_0x33c6('0x8c')]?_0x1b80c0['items'][_0x1c0d22][_0x33c6('0x8c')]:null,_0x56f73b,_0x40818a));}Promise[_0x33c6('0x65')](_0x249aa9)[_0x33c6('0x19')](function(){db[_0x33c6('0x25')]['update']({'AdditionalPhones':_0x21a239},{'where':{'id':_0x1b80c0['id']}})[_0x33c6('0x19')](function(){_0x3d5861(0x1);});});});});});}function addAdditionalPhone(_0x971165,_0x25b1ac,_0x4e8f86,_0x4d37d5,_0x17c9f1){return db['CmContactHasItem'][_0x33c6('0x26')]({'where':{'CmContactId':_0x971165,'item':_0x25b1ac}})[_0x33c6('0x19')](function(_0x21d248){if(_0x21d248)logger[_0x33c6('0x34')](_0x33c6('0x8e'),_0x21d248);else{db[_0x33c6('0x6a')][_0x33c6('0x43')]({'CmContactId':_0x971165,'item':_0x25b1ac,'ItemTypeId':_0x4e8f86,'OrderBy':_0x4d37d5,'ItemClass':_0x33c6('0x8f'),'description':_0x17c9f1});}});}function deleteCmHopperPhones(_0x53b844){return new Promise(function(_0x41497e){return db[_0x33c6('0x3f')][_0x33c6('0x21')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x53b844}})[_0x33c6('0x19')](function(_0x143334){db['CmHopperAdditionalPhone'][_0x33c6('0x24')]({'where':{'CmHopperId':{'$in':_[_0x33c6('0x73')](_0x143334,'id')}}});})[_0x33c6('0x19')](function(){_0x41497e(0x1);});});}function addCmHopperPhones(_0x3213fc){return new Promise(function(_0x436e3b){return db[_0x33c6('0x3f')][_0x33c6('0x21')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x3213fc}})[_0x33c6('0x19')](function(_0x39aa0d){var _0x13a00d=[];_['map'](_0x39aa0d,function(_0x295a31){_0x13a00d[_0x33c6('0x60')](createCmHopperPhone(_0x3213fc,_0x295a31['id']));});Promise[_0x33c6('0x65')](_0x13a00d)[_0x33c6('0x19')](function(){_0x436e3b(0x1);});});});}function createCmHopperPhone(_0x4fb21d,_0x1b1a0a){return new Promise(function(_0x1ba890){db['CmContactHasItem'][_0x33c6('0x21')]({'raw':!![],'attributes':[_0x33c6('0x90'),'OrderBy'],'where':{'CmContactId':_0x4fb21d,'ItemClass':_0x33c6('0x8f')},'include':[{'model':db[_0x33c6('0x6c')],'attributes':[_0x33c6('0x89')],'as':_0x33c6('0x6d')}],'order':['OrderBy',db[_0x33c6('0x6e')][_0x33c6('0x6f')](_0x33c6('0x91'))]})[_0x33c6('0x19')](function(_0x3688b1){var _0x131521=0x1;var _0xa4b8e3=_[_0x33c6('0x73')](_0x3688b1,function(_0x3969b5){_0x3969b5[_0x33c6('0x92')]=_0x1b1a0a;_0x3969b5[_0x33c6('0x7b')]=_0x3969b5[_0x33c6('0x90')];_0x3969b5[_0x33c6('0x89')]=_0x131521;delete _0x3969b5[_0x33c6('0x93')];_0x131521=_0x131521+0x1;return _0x3969b5;});return db[_0x33c6('0x94')]['bulkCreate'](_0xa4b8e3,{});})[_0x33c6('0x19')](function(){_0x1ba890(0x1);});});}function insertAdditionalPhones(_0x38e6ac,_0x50ecb1){return new Promise(function(_0x505107){var _0x17a2e5=[];for(var _0x3e710f=0x0;_0x3e710f<_0x50ecb1['length'];_0x3e710f++){var _0x27c114=_0x50ecb1[_0x3e710f];_0x17a2e5['push'](parseContactItemType(_0x27c114));}Promise[_0x33c6('0x65')](_0x17a2e5)['then'](function(){var _0x5f407a={'id':_0x38e6ac['id'],'items':_0x50ecb1};return addAdditionalPhones(_0x5f407a)[_0x33c6('0x19')](function(){return addCmHopperPhones(_0x38e6ac['id']);});})[_0x33c6('0x19')](function(){_0x505107(_0x38e6ac);});});}function parseContactItemType(_0x4cfa55){return new Promise(function(_0x1d3f1b){if(_0x4cfa55[_0x33c6('0x37')]('ItemTypeId')){_0x1d3f1b(_0x4cfa55);}else{return db[_0x33c6('0x6c')]['find']({'where':{'name':_0x4cfa55['ItemType']}})['then'](function(_0x2252fd){if(_['isNil'](_0x2252fd))_0x4cfa55[_0x33c6('0x8c')]=null;else _0x4cfa55[_0x33c6('0x8c')]=_0x2252fd['id'];_0x1d3f1b(_0x4cfa55);});}});}exports[_0x33c6('0x95')]=function(_0x1d7e3a,_0x54c1bc){return db['CmContactHasItem'][_0x33c6('0x21')]({'raw':!![],'where':{'CmContactId':_0x1d7e3a[_0x33c6('0x27')]['id'],'ItemClass':_0x33c6('0x8f')},'include':[{'model':db[_0x33c6('0x6c')],'as':'ItemType'}],'order':[['OrderBy'],[db['sequelize'][_0x33c6('0x6f')](_0x33c6('0x91'))]]})[_0x33c6('0x19')](function(_0x16cea1){return _0x16cea1;})[_0x33c6('0x19')](respondWithResult(_0x54c1bc,null))[_0x33c6('0x23')](handleError(_0x54c1bc,null));};exports['duplicateAdditionalPhones']=function(_0x3afd93,_0x2da6fe){return db['CmContactHasItem'][_0x33c6('0x21')]({'raw':!![],'where':{'CmContactId':_0x3afd93['body'][_0x33c6('0x96')]}})[_0x33c6('0x19')](function(_0x54b765){var _0x323420=_[_0x33c6('0x73')](_0x54b765,function(_0x4f2f15){_0x4f2f15['CmContactId']=_0x3afd93['body'][_0x33c6('0x97')];return _0x4f2f15;});return db['CmContactHasItem'][_0x33c6('0x5d')](_0x323420,{});})[_0x33c6('0x19')](function(){return addCmHopperPhones(_0x3afd93[_0x33c6('0x39')][_0x33c6('0x97')]);})[_0x33c6('0x19')](function(){return['ok'];})[_0x33c6('0x19')](respondWithResult(_0x2da6fe,null))[_0x33c6('0x23')](handleError(_0x2da6fe,null));};exports[_0x33c6('0x98')]=function(_0x4aeef3,_0xfcdd51){var _0x2faa27=[];_0x2faa27[_0x33c6('0x60')](createCmHopperPhone(_0x4aeef3['body']['id'],_0x4aeef3[_0x33c6('0x39')][_0x33c6('0x99')]));Promise[_0x33c6('0x65')](_0x2faa27)[_0x33c6('0x19')](function(){return[0x1];})[_0x33c6('0x19')](respondWithResult(_0xfcdd51,null));};exports[_0x33c6('0x9a')]=function(_0xa455a0,_0x8c3de5){var _0x3c11a7={'raw':![],'where':{}};var _0x91b354={};var _0x1b3025={'count':0x0,'rows':[]};return db['CmContact'][_0x33c6('0x7d')]({'where':{'id':_0xa455a0[_0x33c6('0x27')]['id']}})[_0x33c6('0x19')](handleEntityNotFound(_0x8c3de5,null))['then'](function(_0x18c712){if(_0x18c712){_0x91b354['model']=_[_0x33c6('0x29')](db[_0x33c6('0x3f')][_0x33c6('0x7f')]);_0x91b354[_0x33c6('0x2d')]=_[_0x33c6('0x29')](_0xa455a0[_0x33c6('0x2d')]);_0x91b354['filters']=_['intersection'](_0x91b354[_0x33c6('0x7e')],_0x91b354['query']);_0x3c11a7['attributes']=_[_0x33c6('0x81')](_0x91b354['model'],qs[_0x33c6('0x82')](_0xa455a0[_0x33c6('0x2d')][_0x33c6('0x82')]));_0x3c11a7[_0x33c6('0x83')]=_0x3c11a7[_0x33c6('0x83')][_0x33c6('0x3a')]?_0x3c11a7[_0x33c6('0x83')]:_0x91b354[_0x33c6('0x7e')];if(!_0xa455a0['query'][_0x33c6('0x37')](_0x33c6('0x9b'))){_0x3c11a7['limit']=qs[_0x33c6('0x13')](_0xa455a0[_0x33c6('0x2d')]['limit']);_0x3c11a7[_0x33c6('0x11')]=qs[_0x33c6('0x11')](_0xa455a0['query']['offset']);}_0x3c11a7[_0x33c6('0x9c')]=qs['sort'](_0xa455a0[_0x33c6('0x2d')][_0x33c6('0x84')]);_0x3c11a7[_0x33c6('0x61')]=qs[_0x33c6('0x80')](_[_0x33c6('0x85')](_0xa455a0[_0x33c6('0x2d')],_0x91b354[_0x33c6('0x80')]));_0x3c11a7[_0x33c6('0x61')][_0x33c6('0x9d')]=_0x18c712['id'];if(_0xa455a0[_0x33c6('0x2d')][_0x33c6('0x86')]){_0x3c11a7[_0x33c6('0x61')]=_[_0x33c6('0x38')](_0x3c11a7[_0x33c6('0x61')],{'$or':_[_0x33c6('0x73')](_0x3c11a7['attributes'],function(_0x234ddc){var _0x1587ee={};_0x1587ee[_0x234ddc]={'$like':'%'+_0xa455a0['query']['filter']+'%'};return _0x1587ee;})});}_0x3c11a7=_[_0x33c6('0x38')]({},_0x3c11a7,_0xa455a0['options']);return db['CmHopper'][_0x33c6('0x14')]({'where':_0x3c11a7[_0x33c6('0x61')]})['then'](function(_0x45cca3){_0x1b3025['count']=_0x45cca3;if(_0xa455a0[_0x33c6('0x2d')][_0x33c6('0x9e')]){_0x3c11a7[_0x33c6('0x9f')]=[{'all':!![]}];}return db[_0x33c6('0x3f')][_0x33c6('0x21')](_0x3c11a7);})[_0x33c6('0x19')](function(_0xcd6e21){_0x1b3025[_0x33c6('0xa0')]=_0xcd6e21;return _0x1b3025;});}})[_0x33c6('0x19')](respondWithFilteredResult(_0x8c3de5,_0x3c11a7))[_0x33c6('0x23')](handleError(_0x8c3de5,null));};exports['getHopperHistories']=function(_0x5d05fe,_0x1c40cc){var _0x186f50={'raw':!![],'where':{}};var _0x13d50e={};var _0x27d090={'count':0x0,'rows':[]};return db['CmContact'][_0x33c6('0x7d')]({'where':{'id':_0x5d05fe[_0x33c6('0x27')]['id']}})[_0x33c6('0x19')](handleEntityNotFound(_0x1c40cc,null))[_0x33c6('0x19')](function(_0x4bb04c){if(_0x4bb04c){_0x13d50e[_0x33c6('0x7e')]=_[_0x33c6('0x29')](db[_0x33c6('0x4e')]['rawAttributes']);_0x13d50e[_0x33c6('0x2d')]=_[_0x33c6('0x29')](_0x5d05fe[_0x33c6('0x2d')]);_0x13d50e[_0x33c6('0x80')]=_[_0x33c6('0x81')](_0x13d50e['model'],_0x13d50e[_0x33c6('0x2d')]);_0x186f50['attributes']=_[_0x33c6('0x81')](_0x13d50e[_0x33c6('0x7e')],qs[_0x33c6('0x82')](_0x5d05fe[_0x33c6('0x2d')][_0x33c6('0x82')]));_0x186f50[_0x33c6('0x83')]=_0x186f50[_0x33c6('0x83')][_0x33c6('0x3a')]?_0x186f50['attributes']:_0x13d50e['model'];if(!_0x5d05fe[_0x33c6('0x2d')]['hasOwnProperty']('nolimit')){_0x186f50['limit']=qs[_0x33c6('0x13')](_0x5d05fe[_0x33c6('0x2d')]['limit']);_0x186f50[_0x33c6('0x11')]=qs['offset'](_0x5d05fe[_0x33c6('0x2d')][_0x33c6('0x11')]);}_0x186f50[_0x33c6('0x9c')]=qs[_0x33c6('0x84')](_0x5d05fe['query'][_0x33c6('0x84')]);_0x186f50[_0x33c6('0x61')]=qs[_0x33c6('0x80')](_[_0x33c6('0x85')](_0x5d05fe[_0x33c6('0x2d')],_0x13d50e[_0x33c6('0x80')]));_0x186f50['where']['ContactId']=_0x4bb04c['id'];if(_0x5d05fe[_0x33c6('0x2d')][_0x33c6('0x86')]){_0x186f50[_0x33c6('0x61')]=_[_0x33c6('0x38')](_0x186f50[_0x33c6('0x61')],{'$or':_[_0x33c6('0x73')](_0x186f50[_0x33c6('0x83')],function(_0x1e36fc){var _0x55f245={};_0x55f245[_0x1e36fc]={'$like':'%'+_0x5d05fe[_0x33c6('0x2d')][_0x33c6('0x86')]+'%'};return _0x55f245;})});}_0x186f50=_[_0x33c6('0x38')]({},_0x186f50,_0x5d05fe[_0x33c6('0x87')]);return db[_0x33c6('0x4e')][_0x33c6('0x14')]({'where':_0x186f50[_0x33c6('0x61')]})[_0x33c6('0x19')](function(_0x2e7872){_0x27d090[_0x33c6('0x14')]=_0x2e7872;if(_0x5d05fe[_0x33c6('0x2d')][_0x33c6('0x9e')]){_0x186f50['include']=[{'all':!![]}];}return db[_0x33c6('0x4e')][_0x33c6('0x21')](_0x186f50);})[_0x33c6('0x19')](function(_0x46458c){_0x27d090['rows']=_0x46458c;return _0x27d090;});}})[_0x33c6('0x19')](respondWithFilteredResult(_0x1c40cc,_0x186f50))[_0x33c6('0x23')](handleError(_0x1c40cc,null));};exports['getHopperFinals']=function(_0x2f1dba,_0x136de8){var _0x5cfdac={'raw':!![],'where':{}};var _0x966bf={};var _0xc127b0={'count':0x0,'rows':[]};return db[_0x33c6('0x25')][_0x33c6('0x7d')]({'where':{'id':_0x2f1dba['params']['id']}})['then'](handleEntityNotFound(_0x136de8,null))['then'](function(_0x794083){if(_0x794083){_0x966bf[_0x33c6('0x7e')]=_['keys'](db[_0x33c6('0xa1')][_0x33c6('0x7f')]);_0x966bf[_0x33c6('0x2d')]=_['keys'](_0x2f1dba[_0x33c6('0x2d')]);_0x966bf['filters']=_[_0x33c6('0x81')](_0x966bf[_0x33c6('0x7e')],_0x966bf[_0x33c6('0x2d')]);_0x5cfdac['attributes']=_[_0x33c6('0x81')](_0x966bf[_0x33c6('0x7e')],qs[_0x33c6('0x82')](_0x2f1dba['query'][_0x33c6('0x82')]));_0x5cfdac[_0x33c6('0x83')]=_0x5cfdac[_0x33c6('0x83')][_0x33c6('0x3a')]?_0x5cfdac[_0x33c6('0x83')]:_0x966bf[_0x33c6('0x7e')];if(!_0x2f1dba['query'][_0x33c6('0x37')](_0x33c6('0x9b'))){_0x5cfdac['limit']=qs['limit'](_0x2f1dba[_0x33c6('0x2d')][_0x33c6('0x13')]);_0x5cfdac[_0x33c6('0x11')]=qs[_0x33c6('0x11')](_0x2f1dba['query'][_0x33c6('0x11')]);}_0x5cfdac[_0x33c6('0x9c')]=qs['sort'](_0x2f1dba[_0x33c6('0x2d')]['sort']);_0x5cfdac[_0x33c6('0x61')]=qs[_0x33c6('0x80')](_[_0x33c6('0x85')](_0x2f1dba[_0x33c6('0x2d')],_0x966bf[_0x33c6('0x80')]));_0x5cfdac[_0x33c6('0x61')]['ContactId']=_0x794083['id'];if(_0x2f1dba[_0x33c6('0x2d')][_0x33c6('0x86')]){_0x5cfdac['where']=_[_0x33c6('0x38')](_0x5cfdac[_0x33c6('0x61')],{'$or':_[_0x33c6('0x73')](_0x5cfdac['attributes'],function(_0x25ab7d){var _0x3cbcf4={};_0x3cbcf4[_0x25ab7d]={'$like':'%'+_0x2f1dba[_0x33c6('0x2d')][_0x33c6('0x86')]+'%'};return _0x3cbcf4;})});}_0x5cfdac=_['merge']({},_0x5cfdac,_0x2f1dba[_0x33c6('0x87')]);return db[_0x33c6('0xa1')][_0x33c6('0x14')]({'where':_0x5cfdac[_0x33c6('0x61')]})['then'](function(_0x129b70){_0xc127b0['count']=_0x129b70;if(_0x2f1dba[_0x33c6('0x2d')][_0x33c6('0x9e')]){_0x5cfdac[_0x33c6('0x9f')]=[{'all':!![]}];}return db['CmHopperFinal'][_0x33c6('0x21')](_0x5cfdac);})[_0x33c6('0x19')](function(_0x53e14b){_0xc127b0[_0x33c6('0xa0')]=_0x53e14b;return _0xc127b0;});}})[_0x33c6('0x19')](respondWithFilteredResult(_0x136de8,_0x5cfdac))[_0x33c6('0x23')](handleError(_0x136de8,null));};exports[_0x33c6('0xa2')]=function(_0xeb3204,_0x10cdd9){var _0x15ca2a={'raw':!![],'where':{}};var _0x461896={};var _0x4b06c3={'count':0x0,'rows':[]};return db[_0x33c6('0x25')][_0x33c6('0x7d')]({'where':{'id':_0xeb3204['params']['id']}})[_0x33c6('0x19')](handleEntityNotFound(_0x10cdd9,null))['then'](function(_0x1bbdba){if(_0x1bbdba){_0x461896['model']=_[_0x33c6('0x29')](db['JscriptySessionReport'][_0x33c6('0x7f')]);_0x461896[_0x33c6('0x2d')]=_[_0x33c6('0x29')](_0xeb3204[_0x33c6('0x2d')]);_0x461896[_0x33c6('0x80')]=_['intersection'](_0x461896[_0x33c6('0x7e')],_0x461896[_0x33c6('0x2d')]);_0x15ca2a['attributes']=_['intersection'](_0x461896[_0x33c6('0x7e')],qs[_0x33c6('0x82')](_0xeb3204['query']['fields']));_0x15ca2a[_0x33c6('0x83')]=_0x15ca2a[_0x33c6('0x83')]['length']?_0x15ca2a[_0x33c6('0x83')]:_0x461896[_0x33c6('0x7e')];if(!_0xeb3204[_0x33c6('0x2d')][_0x33c6('0x37')](_0x33c6('0x9b'))){_0x15ca2a[_0x33c6('0x13')]=qs['limit'](_0xeb3204[_0x33c6('0x2d')][_0x33c6('0x13')]);_0x15ca2a[_0x33c6('0x11')]=qs[_0x33c6('0x11')](_0xeb3204[_0x33c6('0x2d')][_0x33c6('0x11')]);}_0x15ca2a['order']=qs[_0x33c6('0x84')](_0xeb3204['query'][_0x33c6('0x84')]);_0x15ca2a[_0x33c6('0x61')]=qs[_0x33c6('0x80')](_[_0x33c6('0x85')](_0xeb3204['query'],_0x461896[_0x33c6('0x80')]));_0x15ca2a[_0x33c6('0x61')][_0x33c6('0x9d')]=_0x1bbdba['id'];if(_0xeb3204[_0x33c6('0x2d')]['filter']){_0x15ca2a[_0x33c6('0x61')]=_['merge'](_0x15ca2a['where'],{'$or':_[_0x33c6('0x73')](_0x15ca2a[_0x33c6('0x83')],function(_0x11b0b8){var _0x40e0cd={};_0x40e0cd[_0x11b0b8]={'$like':'%'+_0xeb3204[_0x33c6('0x2d')][_0x33c6('0x86')]+'%'};return _0x40e0cd;})});}_0x15ca2a=_[_0x33c6('0x38')]({},_0x15ca2a,_0xeb3204[_0x33c6('0x87')]);return db[_0x33c6('0x53')][_0x33c6('0x14')]({'where':_0x15ca2a['where']})[_0x33c6('0x19')](function(_0x34dc5e){_0x4b06c3['count']=_0x34dc5e;if(_0xeb3204[_0x33c6('0x2d')][_0x33c6('0x9e')]){_0x15ca2a['include']=[{'all':!![]}];}return db[_0x33c6('0x53')][_0x33c6('0x21')](_0x15ca2a);})[_0x33c6('0x19')](function(_0x4dc593){_0x4b06c3['rows']=_0x4dc593;return _0x4b06c3;});}})[_0x33c6('0x19')](respondWithFilteredResult(_0x10cdd9,_0x15ca2a))[_0x33c6('0x23')](handleError(_0x10cdd9,null));};exports['uploadCsv']=function(_0x3b26ad,_0x298e15){try{if(!_0x3b26ad[_0x33c6('0x39')][_0x33c6('0x62')]){throw new Error(_0x33c6('0xa3'));}if(!_0x3b26ad[_0x33c6('0x39')][_0x33c6('0xa4')]){throw new Error(_0x33c6('0xa5'));}if(!_0x3b26ad[_0x33c6('0x39')][_0x33c6('0xa6')]){throw new Error(_0x33c6('0xa7'));}if(!_0x3b26ad['body'][_0x33c6('0xa8')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x4672ae=_0x3b26ad['body'][_0x33c6('0xa4')][_0x33c6('0xa9')](',');var _0x13968a=_0x3b26ad[_0x33c6('0x39')][_0x33c6('0xa6')]['split'](',');if(!_0x4672ae['length']||!_0x13968a[_0x33c6('0x3a')]||_0x4672ae[_0x33c6('0x3a')]!==_0x13968a['length']){throw new Error('Incorrect\x20binding\x20parameters\x20passed!');}_0x3b26ad['body'][_0x33c6('0x82')]=_['zipObject'](_0x4672ae,_0x13968a);if(!_0x3b26ad[_0x33c6('0x39')][_0x33c6('0x82')]['phone']){throw new Error(_0x33c6('0xaa'));}if(!_0x3b26ad[_0x33c6('0x39')][_0x33c6('0x82')][_0x33c6('0xab')]){throw new Error('No\x20firstName\x20column\x20specified');}var _0x448fc6=path[_0x33c6('0x57')](config['root'],_0x33c6('0xac'),_0x3b26ad[_0x33c6('0xad')][_0x33c6('0xae')]);fs[_0x33c6('0xaf')](_0x448fc6,parseInt(_0x33c6('0xb0'),0x8));var _0x41b8cc=require(_0x33c6('0xb1'))[_0x33c6('0xb2')](path[_0x33c6('0x57')](__dirname,'../../components/import/cm/csv'),[_0x448fc6,_0x3b26ad[_0x33c6('0x39')]['binding_keys'],_0x3b26ad[_0x33c6('0x39')][_0x33c6('0xa6')],_0x3b26ad['body'][_0x33c6('0x62')],_0x3b26ad['body'][_0x33c6('0xb3')],_0x3b26ad[_0x33c6('0x39')][_0x33c6('0x5f')],_0x3b26ad[_0x33c6('0x39')][_0x33c6('0xa8')]]);return _0x298e15['status'](0xc8)['json']({'message':_0x33c6('0xb4'),'pid':_0x41b8cc['pid']});}catch(_0x222246){return _0x298e15[_0x33c6('0x10')](0x1f4)[_0x33c6('0xb5')](_0x222246);}};exports[_0x33c6('0xb6')]=function(_0x548a1a,_0x45c410){var _0x3819c8=fs[_0x33c6('0xb7')](_0x548a1a[_0x33c6('0xad')][_0x33c6('0x2')]);Papa[_0x33c6('0xb8')](_0x3819c8,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x14958a){return _0x45c410['status'](0xc8)[_0x33c6('0x17')]({'file':_0x548a1a[_0x33c6('0xad')],'fields':_0x14958a[_0x33c6('0xb9')][_0x33c6('0x82')]});}});};exports['import']=function(_0x7fa710,_0x2b15d1){return db[_0x33c6('0xba')][_0x33c6('0x21')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0x33c6('0x19')](function(_0x26803e){var _0x3631a6=![];if(!_0x7fa710[_0x33c6('0x39')]['ListId']){throw new Error(_0x33c6('0xa3'));}if(!_0x7fa710[_0x33c6('0x39')]['binding'][_0x33c6('0x7b')]){throw new Error(_0x33c6('0xaa'));}if(!_0x7fa710[_0x33c6('0x39')]['binding'][_0x33c6('0xab')]){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x7fa710[_0x33c6('0x39')][_0x33c6('0xa8')]){throw new Error(_0x33c6('0xbb'));}var _0x108b64=require(_0x33c6('0xb1'))[_0x33c6('0xb2')](path['join'](__dirname,_0x33c6('0xbc')),[_0x7fa710[_0x33c6('0x27')]['id'],JSON[_0x33c6('0xbd')](_0x7fa710[_0x33c6('0x39')]),JSON['stringify'](_0x26803e)]);_0x108b64['on']('message',function(){_0x3631a6=!![];return _0x2b15d1[_0x33c6('0x10')](0xc8)['json']({'message':_0x33c6('0xbe'),'pid':_0x108b64[_0x33c6('0xbf')]});});_0x108b64['on']('exit',function(_0x3c673b){if(_0x3c673b&&!_0x3631a6){return _0x2b15d1[_0x33c6('0x10')](0x1f4)['json']({'message':_0x33c6('0xc0'),'pid':_0x108b64[_0x33c6('0xbf')]});}});})['catch'](handleError(_0x2b15d1,null));};exports['importUpdates']=function(_0xd3d647,_0x8a70a4){return db[_0x33c6('0xba')][_0x33c6('0x21')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0x33c6('0x19')](function(_0x59e4a1){var _0x1d34f7=![];if(!_0xd3d647[_0x33c6('0x39')][_0x33c6('0x62')]){throw new Error(_0x33c6('0xa3'));}if(!_0xd3d647[_0x33c6('0x39')][_0x33c6('0xc1')][_0x33c6('0x7b')]){throw new Error(_0x33c6('0xaa'));}if(!_0xd3d647[_0x33c6('0x39')][_0x33c6('0xc1')][_0x33c6('0xab')]){throw new Error(_0x33c6('0xc2'));}if(!_0xd3d647['body']['socket_timestamp']){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x1b3618=require(_0x33c6('0xb1'))[_0x33c6('0xb2')](path[_0x33c6('0x57')](__dirname,_0x33c6('0xc3')),[_0xd3d647['params']['id'],JSON[_0x33c6('0xbd')](_0xd3d647[_0x33c6('0x39')]),JSON[_0x33c6('0xbd')](_0x59e4a1)]);_0x1b3618['on']('message',function(){_0x1d34f7=!![];return _0x8a70a4[_0x33c6('0x10')](0xc8)[_0x33c6('0x17')]({'message':_0x33c6('0xbe'),'pid':_0x1b3618[_0x33c6('0xbf')]});});_0x1b3618['on'](_0x33c6('0xc4'),function(_0x321254){if(_0x321254&&!_0x1d34f7){return _0x8a70a4[_0x33c6('0x10')](0x1f4)[_0x33c6('0x17')]({'message':_0x33c6('0xc0'),'pid':_0x1b3618[_0x33c6('0xbf')]});}});})['catch'](handleError(_0x8a70a4,null));};exports[_0x33c6('0xc5')]=function(_0x53fecc,_0x2b27cf){var _0x266392=['mail','chat',_0x33c6('0xc6'),_0x33c6('0xc7'),_0x33c6('0xc8'),_0x33c6('0xc9'),_0x33c6('0xca')];var _0x3f6579={'offset':0x0,'order':qs['sort'](_0x33c6('0xcb'))},_0x564abc={'count':0x0,'rows':[]};Promise[_0x33c6('0xcc')]()[_0x33c6('0x19')](function(){if(_0x53fecc[_0x33c6('0x2d')][_0x33c6('0xcd')]){if(!_[_0x33c6('0xce')](_0x266392,_0x53fecc[_0x33c6('0x2d')][_0x33c6('0xcd')][_0x33c6('0xcf')]())){throw new Error(_0x33c6('0xd0'));}_0x266392=[_0x53fecc['query'][_0x33c6('0xcd')][_0x33c6('0xcf')]()];}if(_0x53fecc[_0x33c6('0x2d')][_0x33c6('0xd1')]){try{var _0x4275db=JSON[_0x33c6('0xb8')](_0x53fecc[_0x33c6('0x2d')][_0x33c6('0xd1')]);if(!moment(_0x4275db[_0x33c6('0x40')])['isValid']()){throw new Error(_0x33c6('0xd2'));}if(!moment(_0x4275db['to'])[_0x33c6('0xd3')]()){throw new Error('Invalid\x20date\x20for\x20range\x20to\x20filter');}}catch(_0x5b3d3b){throw new Error(_0x33c6('0xd4'));}}if(!_0x53fecc[_0x33c6('0x2d')]['hasOwnProperty']('nolimit')){_0x3f6579[_0x33c6('0x13')]=qs[_0x33c6('0x13')](_0x53fecc[_0x33c6('0x2d')]['limit']||0xa);_0x3f6579[_0x33c6('0x11')]=qs['offset'](_0x53fecc[_0x33c6('0x2d')]['offset']);}var _0x179cd6=_0x266392[_0x33c6('0x73')](function(_0xd3dfef){if(_0xd3dfef===_0x33c6('0xca')){var _0xe29d4b={'attributes':['id','uniqueid','type',_0x33c6('0xd5'),'destination',_0x33c6('0xd6'),_0x33c6('0xd7'),'endtime',_0x33c6('0xd8'),_0x33c6('0xd9'),_0x33c6('0xda'),_0x33c6('0xdb'),_0x33c6('0xdc'),_0x33c6('0xdd'),_0x33c6('0xde')],'where':{'ContactId':_0x53fecc['params']['id']},'include':[{'model':db['User'],'as':_0x33c6('0xba'),'attributes':['id',_0x33c6('0x1d'),_0x33c6('0xdf'),_0x33c6('0x31')]}],'order':[[_0x33c6('0xda'),'DESC']]};if(_0x53fecc[_0x33c6('0x2d')][_0x33c6('0xd1')]){_0xe29d4b[_0x33c6('0x61')][_0x33c6('0xda')]={'$gte':_0x4275db[_0x33c6('0x40')],'$lte':_0x4275db['to']};}return db[_0x33c6('0x50')][_0x33c6('0xe0')](_0xe29d4b)[_0x33c6('0x19')](function(_0x363025){_0x564abc[_0x33c6('0x14')]+=_0x363025[_0x33c6('0x14')];return _[_0x33c6('0x73')](_0x363025[_0x33c6('0xa0')],function(_0x1d1621){var _0x4b4265=_0x1d1621[_0x33c6('0x3b')]({'plain':!![]});_0x4b4265[_0x33c6('0xcd')]=_0xd3dfef;if(_0x4b4265['User']){_0x4b4265[_0x33c6('0xba')]={'id':_0x4b4265[_0x33c6('0xba')]['id'],'name':_0x4b4265[_0x33c6('0xba')]['name'],'fullname':_0x4b4265[_0x33c6('0xba')][_0x33c6('0xdf')],'alias':_0x4b4265[_0x33c6('0xba')]['alias']};}return _0x4b4265;});});}else{var _0x2511a2=_['startCase'](_0xd3dfef)+(_0xd3dfef===_0x33c6('0xe1')?_0x33c6('0xe2'):_0x33c6('0xe3'));var _0x5e71d6={'attributes':['id',_0x33c6('0xe4'),_0x33c6('0xe5'),_0x33c6('0xda'),'note','disposition','secondDisposition',_0x33c6('0xe6'),_0x33c6('0xde'),_0x2511a2+'Id'],'where':{'ContactId':_0x53fecc[_0x33c6('0x27')]['id']},'include':[{'model':db[_0x2511a2],'as':_0x33c6('0xe3'),'attributes':['id',_0x33c6('0x1d'),_0x33c6('0xe7')]},{'model':db[_0x33c6('0xba')],'as':'Owner','attributes':['id',_0x33c6('0x1d'),'fullname']},{'model':db[_0x33c6('0x67')],'as':_0x33c6('0xe8'),'attributes':['id',_0x33c6('0x1d'),_0x33c6('0x68')],'through':{'attributes':[]}}],'order':[[_0x33c6('0xda'),_0x33c6('0xe9')]]};if(_0x53fecc[_0x33c6('0x2d')][_0x33c6('0xd1')]){_0x5e71d6['where']['createdAt']={'$gte':_0x4275db['from'],'$lte':_0x4275db['to']};}switch(_0xd3dfef){case _0x33c6('0xe1'):_0x5e71d6[_0x33c6('0x83')]['push'](_0x33c6('0xea'),_0x33c6('0xeb'),_0x33c6('0xec'),_0x33c6('0xed'),_0x33c6('0xee'),_0x33c6('0xef'),_0x33c6('0xf0'),_0x33c6('0xf1'),_0x33c6('0xf2'));break;case _0x33c6('0xf3'):_0x5e71d6[_0x33c6('0x83')][_0x33c6('0x60')]('subject','substatus');break;case _0x33c6('0xc7'):_0x5e71d6['attributes'][_0x33c6('0x60')](_0x33c6('0xf4'),_0x33c6('0xf5'));break;}return db[_[_0x33c6('0xf6')](_0xd3dfef)+_0x33c6('0xf7')]['findAndCountAll'](_0x5e71d6)[_0x33c6('0x19')](function(_0x109c65){_0x564abc[_0x33c6('0x14')]+=_0x109c65[_0x33c6('0x14')];return _[_0x33c6('0x73')](_0x109c65[_0x33c6('0xa0')],function(_0x51991e){var _0x5712a4=_0x51991e[_0x33c6('0x3b')]({'plain':!![]});_0x5712a4[_0x33c6('0xcd')]=_0xd3dfef;if(_0x5712a4[_0x33c6('0xf8')]){_0x5712a4[_0x33c6('0xf8')]={'id':_0x5712a4[_0x33c6('0xf8')]['id'],'name':_0x5712a4[_0x33c6('0xf8')]['name'],'fullname':_0x5712a4[_0x33c6('0xf8')][_0x33c6('0xdf')]};}return _0x5712a4;});});}});return Promise['all'](_0x179cd6);})['then'](function(_0x4bea51){return _(_0x4bea51)[_0x33c6('0xf9')]()[_0x33c6('0xfa')](_0x33c6('0xda'))[_0x33c6('0xfb')]()['value']();})[_0x33c6('0x19')](function(_0x1f97c2){_0x564abc[_0x33c6('0xa0')]=_0x3f6579[_0x33c6('0x13')]?_0x1f97c2[_0x33c6('0xfc')](_0x3f6579['offset'],_0x3f6579[_0x33c6('0x11')]+_0x3f6579[_0x33c6('0x13')]):_0x1f97c2;return _0x564abc;})[_0x33c6('0x19')](respondWithFilteredResult(_0x2b27cf,_0x3f6579))[_0x33c6('0x23')](handleError(_0x2b27cf,null));};
\ No newline at end of file
+var _0x7b06=['ratingType','ratingValue','referer','subject','substatus','openchannel','externalUrl','threadId','Interaction','flatten','sortBy','reverse','value','slice','moment','util','path','lodash','ioredis','../../components/contacts','../../components/parsers/qs','../../config/logger','api','../../config/environment','../../config/environment/shared','defaults','redis','socket.io-emitter','register','json','undefined','limit','count','offset','set','Content-Range','update','then','destroy','status','end','sendStatus','name','send','index','getOptions','catch','find','params','describe','tags','keys','length','cf_','displayName','query','analytics','CmCustomField','findAll','columnName','alias','custom','type','values','forEach','body','from','get','mergeWith','isArray','join','[CmContact][merge]\x20to\x20%s\x20from\x20%s','info','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','CmContact','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxMessage','OpenchannelInteraction','CmContactHasItem','CmHopperHistory','ReportAgentPreview','ChatQueueReport','FaxQueueReport','MailQueueReport','JscriptySessionReport','WhatsappMessage','WhatsappQueueReport','isNil','timezones','additionalPhones','each','duplicates','where','$or','push','ListId','spread','hasOwnProperty','all','show','Tag','color','tag','Phones','ContactItemType','literal','Phones.OrderBy','$and','omit','format','dialTimezone','utcOffset','pickBy','map','cf_%d','isEmpty','setFields','toParam','sequelize','text','phone','getTags','findOne','filters','intersection','attributes','model','fields','order','sort','filter','merge','options','setTags','setAdditionalPhones','OrderBy','items','item_types','ItemTypeId','description','contact\x20phone\x20exists','PHONE','CmHopperAdditionalPhone','CmHopper','ItemType','`ItemType`.OrderBy','item','ItemType.OrderBy','bulkCreate','getAdditionalPhones','fromContactId','CmContactId','toContactId','rescheduleAdditionalPhones','hopperId','getHoppers','nolimit','pick','ContactId','includeAll','rows','include','getHopperFinals','CmHopperFinal','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','split','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20firstName\x20column\x20specified','server/files/tmp','file','chmodSync','0777','../../components/import/cm/csv','binding_keys','pid','meta','import','User','binding','No\x20phone\x20column\x20specified','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','exit','error\x20child\x20process','firstName','child_process','fork','getJourney','mail','chat','fax','whatsapp','voice','-createdAt','channel','includes','toLowerCase','Invalid\x20channel','parse','range','isValid','Invalid\x20date\x20for\x20range\x20to\x20filter','Invalid\x20createdAt\x20filter','uniqueid','source','callerid','starttime','endtime','note','createdAt','userThirdDisposition','UserId','fullname','DESC','VoiceCallReport','findAndCountAll','startCase','closed','closedAt','disposition','secondDisposition','thirdDisposition','Account','Owner','Tags','browserName','deviceModel','osName','ratingMessage'];(function(_0x4251fc,_0x45a6be){var _0x43f5b0=function(_0x783a5){while(--_0x783a5){_0x4251fc['push'](_0x4251fc['shift']());}};_0x43f5b0(++_0x45a6be);}(_0x7b06,0x106));var _0x67b0=function(_0x4afdce,_0x2d1a6a){_0x4afdce=_0x4afdce-0x0;var _0x5a163f=_0x7b06[_0x4afdce];return _0x5a163f;};'use strict';var moment=require(_0x67b0('0x0'));var BPromise=require('bluebird');var util=require(_0x67b0('0x1'));var path=require(_0x67b0('0x2'));var fs=require('fs');var _=require(_0x67b0('0x3'));var squel=require('squel');var Papa=require('papaparse');var Redis=require(_0x67b0('0x4'));var contacts=require(_0x67b0('0x5'));var qs=require(_0x67b0('0x6'));var logger=require(_0x67b0('0x7'))(_0x67b0('0x8'));var config=require(_0x67b0('0x9'));var shared=require(_0x67b0('0xa'));var db=require('../../mysqldb')['db'];config['redis']=_[_0x67b0('0xb')](config[_0x67b0('0xc')],{'host':'localhost','port':0x18eb});var socket=require(_0x67b0('0xd'))(new Redis(config[_0x67b0('0xc')]));require('./cmContact.socket')[_0x67b0('0xe')](socket);function respondWithResult(_0x458539,_0x1441ab){_0x1441ab=_0x1441ab||0xc8;return function(_0x56245c){if(_0x56245c){return _0x458539['status'](_0x1441ab)[_0x67b0('0xf')](_0x56245c);}};}function respondWithFilteredResult(_0x1749a1,_0x2113f4){return function(_0xe38ac8){if(_0xe38ac8){var _0x35cab7=typeof _0x2113f4['offset']===_0x67b0('0x10')&&typeof _0x2113f4[_0x67b0('0x11')]===_0x67b0('0x10');var _0x4121dc=_0xe38ac8[_0x67b0('0x12')];var _0x1e4903=_0x35cab7?0x0:_0x2113f4[_0x67b0('0x13')];var _0x38ca68=_0x35cab7?_0xe38ac8[_0x67b0('0x12')]:_0x2113f4[_0x67b0('0x13')]+_0x2113f4[_0x67b0('0x11')];var _0x589786;if(_0x38ca68>=_0x4121dc){_0x38ca68=_0x4121dc;_0x589786=0xc8;}else{_0x589786=0xce;}_0x1749a1['status'](_0x589786);return _0x1749a1[_0x67b0('0x14')](_0x67b0('0x15'),_0x1e4903+'-'+_0x38ca68+'/'+_0x4121dc)['json'](_0xe38ac8);}return null;};}function saveUpdates(_0x17962b){return function(_0x3d67f6){if(_0x3d67f6){return _0x3d67f6[_0x67b0('0x16')](_0x17962b)[_0x67b0('0x17')](function(_0x26e1b5){return _0x26e1b5;});}return null;};}function removeEntity(_0x51b7c3){return function(_0x55ef96){if(_0x55ef96){return _0x55ef96[_0x67b0('0x18')]()[_0x67b0('0x17')](function(){_0x51b7c3[_0x67b0('0x19')](0xcc)[_0x67b0('0x1a')]();});}};}function handleEntityNotFound(_0x217046){return function(_0x333dfa){if(!_0x333dfa){_0x217046[_0x67b0('0x1b')](0x194);}return _0x333dfa;};}function handleError(_0x1fc99b,_0x293197){_0x293197=_0x293197||0x1f4;return function(_0xac55e2){logger['error'](_0xac55e2['stack']);if(_0xac55e2[_0x67b0('0x1c')]){delete _0xac55e2[_0x67b0('0x1c')];}_0x1fc99b['status'](_0x293197)[_0x67b0('0x1d')](_0xac55e2);};}exports[_0x67b0('0x1e')]=function(_0x4582dd,_0x46d678){var _0x2f7e68={};return contacts['describe']()['then'](function(_0x24c5d8){_0x2f7e68=qs[_0x67b0('0x1f')](_0x24c5d8,_0x4582dd);return contacts['findAll'](_0x4582dd['query'],_0x4582dd['user'],_0x2f7e68,_0x24c5d8);})[_0x67b0('0x17')](respondWithFilteredResult(_0x46d678,_0x2f7e68))[_0x67b0('0x20')](handleError(_0x46d678,null));};exports[_0x67b0('0x18')]=function(_0x2f66f6,_0x4772e9){return db['CmContact'][_0x67b0('0x21')]({'where':{'id':_0x2f66f6[_0x67b0('0x22')]['id']}})[_0x67b0('0x17')](handleEntityNotFound(_0x4772e9,null))[_0x67b0('0x17')](removeEntity(_0x4772e9,null))[_0x67b0('0x20')](handleError(_0x4772e9,null));};exports[_0x67b0('0x23')]=function(_0x1b6c97,_0x96bd71){return db['CmContact'][_0x67b0('0x23')]()[_0x67b0('0x17')](function(_0x6427a4){delete _0x6427a4[_0x67b0('0x24')];for(var _0x4ce243=0x0;_0x4ce243<Object[_0x67b0('0x25')](_0x6427a4)[_0x67b0('0x26')];_0x4ce243++){var _0x5789d1=Object['keys'](_0x6427a4)[_0x4ce243];if(!_['startsWith'](_0x5789d1,_0x67b0('0x27'))){_0x6427a4[_0x5789d1]['columnName']=_0x5789d1;_0x6427a4[_0x5789d1][_0x67b0('0x28')]=_0x5789d1;}}return _0x6427a4;})[_0x67b0('0x17')](function(_0x356f0a){var _0x55d098={'where':Boolean(_0x1b6c97[_0x67b0('0x29')][_0x67b0('0x2a')])===!![]?undefined:{'$or':[{'ListId':_0x1b6c97[_0x67b0('0x29')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x67b0('0x2b')][_0x67b0('0x2c')](_0x55d098)['then'](function(_0x4e42c4){for(var _0x387f64=0x0;_0x387f64<_0x4e42c4[_0x67b0('0x26')];_0x387f64++){var _0x6780a5=_0x67b0('0x27')+_0x4e42c4[_0x387f64]['id'];if(_0x356f0a[_0x6780a5]){_0x356f0a[_0x6780a5][_0x67b0('0x2d')]=_0x6780a5;_0x356f0a[_0x6780a5][_0x67b0('0x28')]=_0x4e42c4[_0x387f64][_0x67b0('0x2e')];_0x356f0a[_0x6780a5][_0x67b0('0x2f')]={'type':_0x4e42c4[_0x387f64][_0x67b0('0x30')],'values':_0x4e42c4[_0x387f64][_0x67b0('0x31')]};}else{logger['info']('Custom\x20field\x20%s\x20not\x20found\x20on\x20cm_contacts\x20table',_0x6780a5);}}Object['keys'](_0x356f0a)[_0x67b0('0x32')](function(_0x2b0c52){if(!_0x356f0a[_0x2b0c52]['hasOwnProperty'](_0x67b0('0x2d'))){delete _0x356f0a[_0x2b0c52];}});return _0x356f0a;});})['then'](respondWithResult(_0x96bd71,null))[_0x67b0('0x20')](handleError(_0x96bd71,null));};exports['merge']=function(_0x35a3c6,_0x52ccf0){var _0xbda945;var _0x2e4434;var _0x5e7050;if(_0x35a3c6[_0x67b0('0x33')]['id']){delete _0x35a3c6[_0x67b0('0x33')]['id'];}return db['CmContact'][_0x67b0('0x2c')]({'where':{'id':[_0x35a3c6[_0x67b0('0x33')]['to'],_0x35a3c6['body'][_0x67b0('0x34')]]}})[_0x67b0('0x17')](function(_0x5f2955){if(_0x5f2955){if(_0x5f2955[_0x67b0('0x26')]!==0x2){return null;}_0x5f2955[0x0]=_0x5f2955[0x0]['get']({'plain':!![]});_0x5f2955[0x1]=_0x5f2955[0x1][_0x67b0('0x35')]({'plain':!![]});delete _0x5f2955[0x0]['id'];delete _0x5f2955[0x1]['id'];return _[_0x67b0('0x36')](_0x5f2955[0x0],_0x5f2955[0x1],function(_0x474539,_0x4c0094){if(Array[_0x67b0('0x37')](_0x4c0094)&&!_0x4c0094[_0x67b0('0x26')]){return _0x474539;}else if(!_0x4c0094){return _0x474539;}});}})['then'](handleEntityNotFound(_0x52ccf0,null))['then'](function(_0x4ea10f){if(_0x4ea10f){if(_0x4ea10f[_0x67b0('0x24')]&&_[_0x67b0('0x37')](_0x4ea10f[_0x67b0('0x24')])){_0x4ea10f[_0x67b0('0x24')]=_0x4ea10f[_0x67b0('0x24')][_0x67b0('0x38')]();}logger['info'](_0x67b0('0x39'),_0x35a3c6['body']['to'],_0x35a3c6[_0x67b0('0x33')]['from']);return db['CmHopper'][_0x67b0('0x18')]({'where':{'ContactId':[_0x35a3c6[_0x67b0('0x33')]['to'],_0x35a3c6[_0x67b0('0x33')][_0x67b0('0x34')]]}})[_0x67b0('0x17')](function(_0x29a883){logger[_0x67b0('0x3a')](_0x67b0('0x3b'),_0x29a883);return db[_0x67b0('0x3c')]['destroy']({'where':{'ContactId':[_0x35a3c6[_0x67b0('0x33')]['to'],_0x35a3c6[_0x67b0('0x33')][_0x67b0('0x34')]]}})[_0x67b0('0x17')](function(_0x2afcf9){logger[_0x67b0('0x3a')](_0x67b0('0x3d'),_0x2afcf9);return db[_0x67b0('0x3e')][_0x67b0('0x3f')](_0x4ea10f);});});}})['then'](function(_0x340aa5){if(_0x340aa5){_0xbda945=_0x340aa5;_0x2e4434={'ContactId':_0xbda945['id']};_0x5e7050={'where':{'ContactId':[_0x35a3c6['body']['to'],_0x35a3c6[_0x67b0('0x33')][_0x67b0('0x34')]]}};return db[_0x67b0('0x40')]['update'](_0x2e4434,_0x5e7050);}})[_0x67b0('0x17')](function(){if(_0xbda945){return db[_0x67b0('0x41')][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})[_0x67b0('0x17')](function(){if(_0xbda945){return db[_0x67b0('0x42')][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})[_0x67b0('0x17')](function(){if(_0xbda945){return db[_0x67b0('0x43')][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})[_0x67b0('0x17')](function(){if(_0xbda945){return db[_0x67b0('0x44')][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})[_0x67b0('0x17')](function(){if(_0xbda945){return db[_0x67b0('0x43')]['update'](_0x2e4434,_0x5e7050);}})['then'](function(){if(_0xbda945){return db[_0x67b0('0x44')][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})[_0x67b0('0x17')](function(){if(_0xbda945){return db[_0x67b0('0x45')][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})[_0x67b0('0x17')](function(){if(_0xbda945){return db[_0x67b0('0x46')][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})['then'](function(){if(_0xbda945){return db['FaxInteraction'][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})[_0x67b0('0x17')](function(){if(_0xbda945){return db[_0x67b0('0x47')][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})['then'](function(){if(_0xbda945){return db[_0x67b0('0x48')][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})['then'](function(){if(_0xbda945){return db['OpenchannelMessage']['update'](_0x2e4434,_0x5e7050);}})[_0x67b0('0x17')](function(){if(_0xbda945){return db[_0x67b0('0x49')]['update']({'CmContactId':_0xbda945['id']},{'where':{'CmContactId':[_0x35a3c6[_0x67b0('0x33')]['to'],_0x35a3c6[_0x67b0('0x33')]['from']]}});}})[_0x67b0('0x17')](function(){if(_0xbda945){return db['CmHopperFinal'][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})['then'](function(){if(_0xbda945){return db[_0x67b0('0x4a')][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})[_0x67b0('0x17')](function(){if(_0xbda945){return db[_0x67b0('0x4b')][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})[_0x67b0('0x17')](function(){if(_0xbda945){return db['VoiceCallReport']['update'](_0x2e4434,_0x5e7050);}})['then'](function(){if(_0xbda945){return db[_0x67b0('0x4c')][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})[_0x67b0('0x17')](function(){if(_0xbda945){return db[_0x67b0('0x4d')][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})[_0x67b0('0x17')](function(){if(_0xbda945){return db[_0x67b0('0x4e')][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})[_0x67b0('0x17')](function(){if(_0xbda945){return db['OpenchannelQueueReport'][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})['then'](function(){if(_0xbda945){return db['SmsQueueReport'][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})[_0x67b0('0x17')](function(){if(_0xbda945){return db[_0x67b0('0x4f')][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})[_0x67b0('0x17')](function(){if(_0xbda945){return db['WhatsappInteraction'][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})[_0x67b0('0x17')](function(){if(_0xbda945){return db[_0x67b0('0x50')][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})['then'](function(){if(_0xbda945){return db[_0x67b0('0x51')][_0x67b0('0x16')](_0x2e4434,_0x5e7050);}})[_0x67b0('0x17')](function(){if(_0xbda945){return db[_0x67b0('0x3e')][_0x67b0('0x18')]({'where':{'id':[_0x35a3c6['body']['to'],_0x35a3c6[_0x67b0('0x33')]['from']]}});}})[_0x67b0('0x17')](function(){if(_0xbda945){return _0xbda945;}})[_0x67b0('0x17')](respondWithResult(_0x52ccf0,null))['catch'](handleError(_0x52ccf0,null));};exports[_0x67b0('0x3f')]=function(_0x3fce18,_0x1793f9){return db[_0x67b0('0x3e')][_0x67b0('0x23')]()['then'](function(_0x220466){if(_0x3fce18[_0x67b0('0x33')][_0x67b0('0x24')]&&_[_0x67b0('0x37')](_0x3fce18[_0x67b0('0x33')][_0x67b0('0x24')])){if(_0x3fce18['body'][_0x67b0('0x24')][_0x67b0('0x26')]){_0x3fce18[_0x67b0('0x33')][_0x67b0('0x24')]=_0x3fce18[_0x67b0('0x33')]['tags'][_0x67b0('0x38')](';')+';';}else{_0x3fce18[_0x67b0('0x33')]['tags']=null;}}else{_0x3fce18[_0x67b0('0x33')][_0x67b0('0x24')]=null;}if(!_['isNil'](_0x3fce18['body']['dialTimezone'])){var _0x241d0e=_0x3fce18[_0x67b0('0x33')]['dialTimezone'];if(!_[_0x67b0('0x52')](shared[_0x67b0('0x53')][_0x241d0e]))_0x3fce18[_0x67b0('0x33')]['utcOffset']=shared[_0x67b0('0x53')][_0x241d0e]['utcOffset'];}return db['CmContact'][_0x67b0('0x3f')](_0x3fce18['body'],{'fields':_['keys'](_0x220466),'raw':!![]});})[_0x67b0('0x17')](function(_0x56e6aa){if(_0x3fce18[_0x67b0('0x33')][_0x67b0('0x54')]){return insertAdditionalPhones(_0x56e6aa,_0x3fce18[_0x67b0('0x33')][_0x67b0('0x54')]);}else{return _0x56e6aa;}})[_0x67b0('0x17')](respondWithResult(_0x1793f9,0xc9))[_0x67b0('0x20')](handleError(_0x1793f9,null));};exports['bulkCreate']=function(_0x227e0f,_0x2b59a1){var _0x5b0e6f=0x0;var _0x5db313=0x0;var _0xde6266=0x0;var _0x5063e8=[];return db['CmContact']['describe']()['then'](function(_0x276544){return BPromise[_0x67b0('0x55')](_0x227e0f['body'],function(_0x4aa8e7){var _0x2c4ae2={'where':{'$or':[]},'defaults':_0x4aa8e7,'fields':_[_0x67b0('0x25')](_0x276544),'raw':!![]};if(_0x4aa8e7[_0x67b0('0x56')]){for(var _0x2559c8=0x0;_0x2559c8<_0x4aa8e7['duplicates'][_0x67b0('0x26')];_0x2559c8++){var _0x41d6f3={};_0x41d6f3[_0x4aa8e7[_0x67b0('0x56')][_0x2559c8]]=_0x4aa8e7[_0x4aa8e7[_0x67b0('0x56')][_0x2559c8]];_0x2c4ae2[_0x67b0('0x57')][_0x67b0('0x58')][_0x67b0('0x59')](_0x41d6f3);}_0x2c4ae2[_0x67b0('0x57')][_0x67b0('0x5a')]=_0x4aa8e7['ListId'];}return db['CmContact']['findOrCreate'](_0x2c4ae2)[_0x67b0('0x5b')](function(_0x170fee,_0x1cdad8){if(_0x1cdad8){if(_0x4aa8e7[_0x67b0('0x5c')]('additionalPhones')){_0x5063e8[_0x67b0('0x59')]({'contact':_0x170fee,'additionalPhones':_0x4aa8e7[_0x67b0('0x54')]});}_0x5b0e6f++;}else{_0xde6266++;}})[_0x67b0('0x20')](function(){_0x5db313++;});});})[_0x67b0('0x17')](function(_0x3beba7){if(_0x3beba7){if(_0x5063e8[_0x67b0('0x26')]>0x0){return new Promise(function(_0xc0f918){var _0x2b59b4=[];for(var _0x4fc352=0x0;_0x4fc352<_0x5063e8[_0x67b0('0x26')];_0x4fc352++){_0x2b59b4['push'](insertAdditionalPhones(_0x5063e8[_0x4fc352]['contact'],_0x5063e8[_0x4fc352]['additionalPhones']));}Promise[_0x67b0('0x5d')](_0x2b59b4)[_0x67b0('0x17')](function(){_0xc0f918(0x1);});})['then'](function(){return{'success':_0x5b0e6f,'failure':_0x5db313,'duplicates':_0xde6266};});}else{return{'success':_0x5b0e6f,'failure':_0x5db313,'duplicates':_0xde6266};}}})['then'](respondWithResult(_0x2b59a1,0xc9))['catch'](handleError(_0x2b59a1,null));};exports[_0x67b0('0x5e')]=function(_0x39701c,_0x2ff9c0){var _0x272a3c;return db[_0x67b0('0x3e')][_0x67b0('0x23')]()[_0x67b0('0x17')](function(_0x199857){return db['CmContact'][_0x67b0('0x21')]({'where':{'id':_0x39701c[_0x67b0('0x22')]['id']},'include':[{'model':db[_0x67b0('0x5f')],'as':'Tags','attributes':['id',_0x67b0('0x1c'),_0x67b0('0x60')],'required':_0x39701c['query'][_0x67b0('0x61')]?!![]:![]},{'model':db[_0x67b0('0x49')],'as':_0x67b0('0x62'),'where':{'CmContactId':_0x39701c[_0x67b0('0x22')]['id']},'required':![],'include':[{'model':db[_0x67b0('0x63')],'as':'ItemType'}]}],'order':[db['sequelize'][_0x67b0('0x64')](_0x67b0('0x65'))],'attributes':_[_0x67b0('0x25')](_0x199857)});})[_0x67b0('0x17')](function(_0x5dd6f6){if(!_['isNil'](_0x5dd6f6)){_0x272a3c=_0x5dd6f6[_0x67b0('0x35')]({'plain':!![]});var _0x18fa1f={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x5dd6f6&&_0x5dd6f6['ListId']){if(_0x5dd6f6['ListId']){_0x18fa1f[_0x67b0('0x57')][_0x67b0('0x66')]['push']({'ListId':{'$ne':_0x5dd6f6[_0x67b0('0x5a')]}});}}return db['CmCustomField'][_0x67b0('0x2c')](_0x18fa1f);}})[_0x67b0('0x17')](function(_0x535d24){if(!_[_0x67b0('0x52')](_0x535d24)){return _[_0x67b0('0x67')](_0x272a3c,_['map'](_0x535d24,function(_0x1e9b86){return util[_0x67b0('0x68')]('cf_%d',_0x1e9b86['id']);}));}})[_0x67b0('0x17')](handleEntityNotFound(_0x2ff9c0,null))[_0x67b0('0x17')](respondWithResult(_0x2ff9c0,null))[_0x67b0('0x20')](handleError(_0x2ff9c0,null));};exports[_0x67b0('0x16')]=function(_0x48ff25,_0xca7818){var _0xd5a0c6;if(_0x48ff25[_0x67b0('0x33')]['id']){delete _0x48ff25[_0x67b0('0x33')]['id'];}if(!_[_0x67b0('0x52')](_0x48ff25['body'][_0x67b0('0x69')])){var _0x1793c4=_0x48ff25['body'][_0x67b0('0x69')];if(!_['isNil'](shared['timezones'][_0x1793c4]))_0x48ff25[_0x67b0('0x33')][_0x67b0('0x6a')]=shared['timezones'][_0x1793c4][_0x67b0('0x6a')];}return db[_0x67b0('0x3e')]['find']({'where':{'id':_0x48ff25['params']['id']}})[_0x67b0('0x17')](handleEntityNotFound(_0xca7818,null))[_0x67b0('0x17')](saveUpdates(_0x48ff25[_0x67b0('0x33')],null))[_0x67b0('0x17')](function(_0x55d3f1){_0xd5a0c6=_0x55d3f1;var _0xf42e99={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x55d3f1&&_0x55d3f1[_0x67b0('0x5a')]){if(_0x55d3f1[_0x67b0('0x5a')]){_0xf42e99[_0x67b0('0x57')][_0x67b0('0x66')][_0x67b0('0x59')]({'ListId':{'$ne':_0x55d3f1[_0x67b0('0x5a')]}});}}return db[_0x67b0('0x2b')][_0x67b0('0x2c')](_0xf42e99);})[_0x67b0('0x17')](function(_0x252685){if(_0x252685){return _[_0x67b0('0x67')](_[_0x67b0('0x6b')](_0x48ff25[_0x67b0('0x33')],function(_0x3f01f2,_0x3df275){return _['startsWith'](_0x3df275,'cf_');}),_[_0x67b0('0x6c')](_0x252685,function(_0x5b30a5){return util[_0x67b0('0x68')](_0x67b0('0x6d'),_0x5b30a5['id']);}));}})['then'](function(_0x1ebbc9){if(_0x1ebbc9&&!_[_0x67b0('0x6e')](_0x1ebbc9)){var _0x5e300d=squel[_0x67b0('0x16')]()['table']('cm_contacts')[_0x67b0('0x6f')](_0x1ebbc9)[_0x67b0('0x57')]('id\x20=\x20?',_0x48ff25['params']['id'])[_0x67b0('0x70')]();return db[_0x67b0('0x71')][_0x67b0('0x29')](_0x5e300d[_0x67b0('0x72')],{'replacements':_0x5e300d[_0x67b0('0x31')]});}})[_0x67b0('0x17')](function(){if(_0x48ff25[_0x67b0('0x33')][_0x67b0('0x73')]&&_0xd5a0c6){return db['CmHopper'][_0x67b0('0x16')]({'phone':_0x48ff25['body'][_0x67b0('0x73')],'OrderBy':0x0},{'where':{'ContactId':_0xd5a0c6['id']}});}})[_0x67b0('0x17')](function(){return _0xd5a0c6;})[_0x67b0('0x17')](respondWithResult(_0xca7818,null))['catch'](handleError(_0xca7818,null));};exports[_0x67b0('0x74')]=function(_0x553a60,_0x28ffec){var _0x4e14ed={};var _0x3bef4e={};var _0x51f7d0;var _0x5e8fb1;return db[_0x67b0('0x3e')][_0x67b0('0x75')]({'where':{'id':_0x553a60[_0x67b0('0x22')]['id']}})['then'](handleEntityNotFound(_0x28ffec,null))['then'](function(_0x2ef0dc){if(_0x2ef0dc){_0x51f7d0=_0x2ef0dc;_0x3bef4e['model']=_[_0x67b0('0x25')](db['Tag']['rawAttributes']);_0x3bef4e[_0x67b0('0x29')]=_[_0x67b0('0x25')](_0x553a60[_0x67b0('0x29')]);_0x3bef4e[_0x67b0('0x76')]=_[_0x67b0('0x77')](_0x3bef4e['model'],_0x3bef4e[_0x67b0('0x29')]);_0x4e14ed[_0x67b0('0x78')]=_[_0x67b0('0x77')](_0x3bef4e[_0x67b0('0x79')],qs[_0x67b0('0x7a')](_0x553a60[_0x67b0('0x29')][_0x67b0('0x7a')]));_0x4e14ed[_0x67b0('0x78')]=_0x4e14ed[_0x67b0('0x78')][_0x67b0('0x26')]?_0x4e14ed['attributes']:_0x3bef4e[_0x67b0('0x79')];_0x4e14ed[_0x67b0('0x7b')]=qs[_0x67b0('0x7c')](_0x553a60[_0x67b0('0x29')]['sort']);_0x4e14ed[_0x67b0('0x57')]=qs[_0x67b0('0x76')](_['pick'](_0x553a60['query'],_0x3bef4e[_0x67b0('0x76')]));if(_0x553a60['query'][_0x67b0('0x7d')]){_0x4e14ed[_0x67b0('0x57')]=_[_0x67b0('0x7e')](_0x4e14ed[_0x67b0('0x57')],{'$or':_[_0x67b0('0x6c')](_0x4e14ed[_0x67b0('0x78')],function(_0x2a4635){var _0x137681={};_0x137681[_0x2a4635]={'$like':'%'+_0x553a60[_0x67b0('0x29')]['filter']+'%'};return _0x137681;})});}_0x4e14ed=_['merge']({},_0x4e14ed,_0x553a60[_0x67b0('0x7f')]);return _0x51f7d0['getTags'](_0x4e14ed);}})[_0x67b0('0x17')](function(_0x39e8bf){if(_0x39e8bf){_0x5e8fb1=_0x39e8bf[_0x67b0('0x26')];if(!_0x553a60[_0x67b0('0x29')][_0x67b0('0x5c')]('nolimit')){_0x4e14ed['limit']=qs['limit'](_0x553a60['query'][_0x67b0('0x11')]);_0x4e14ed[_0x67b0('0x13')]=qs[_0x67b0('0x13')](_0x553a60[_0x67b0('0x29')]['offset']);}return _0x51f7d0['getTags'](_0x4e14ed);}})[_0x67b0('0x17')](function(_0x35fb80){if(_0x35fb80){return _0x35fb80?{'count':_0x5e8fb1,'rows':_0x35fb80}:null;}})[_0x67b0('0x17')](respondWithResult(_0x28ffec,null))[_0x67b0('0x20')](handleError(_0x28ffec,null));};exports[_0x67b0('0x80')]=function(_0x13f625,_0x2fad23){if(_0x13f625[_0x67b0('0x33')]['id']){delete _0x13f625[_0x67b0('0x33')]['id'];}return db[_0x67b0('0x3e')][_0x67b0('0x75')]({'where':{'id':_0x13f625[_0x67b0('0x22')]['id']}})['then'](handleEntityNotFound(_0x2fad23,null))[_0x67b0('0x17')](function(_0x2fbd37){if(_0x2fbd37){return _0x2fbd37[_0x67b0('0x80')](_0x13f625[_0x67b0('0x33')]['ids']||[]);}return null;})[_0x67b0('0x17')](respondWithResult(_0x2fad23,null))[_0x67b0('0x20')](handleError(_0x2fad23,null));};exports[_0x67b0('0x81')]=function(_0x129e57,_0x25196b){var _0x5adaf7=[];_0x5adaf7[_0x67b0('0x59')](addAdditionalPhones(_0x129e57[_0x67b0('0x33')]));Promise['all'](_0x5adaf7)[_0x67b0('0x17')](function(){_0x5adaf7=[];_0x5adaf7[_0x67b0('0x59')](deleteCmHopperPhones(_0x129e57[_0x67b0('0x33')]['id']));_0x5adaf7[_0x67b0('0x59')](addCmHopperPhones(_0x129e57['body']['id']));Promise[_0x67b0('0x5d')](_0x5adaf7)[_0x67b0('0x17')](function(){return[0x1];})[_0x67b0('0x17')](respondWithResult(_0x25196b,null));});};function addAdditionalPhones(_0x3ba201){var _0x3d32bc;return new Promise(function(_0x5e561d){return db[_0x67b0('0x49')]['destroy']({'where':{'CmContactId':_0x3ba201['id']}})[_0x67b0('0x17')](function(){db['ContactItemType'][_0x67b0('0x2c')]({'raw':!![],'attributes':['id',_0x67b0('0x82')]})[_0x67b0('0x17')](function(_0x56a7cb){var _0x2406af=[];for(var _0x1d0c4b=0x0;_0x1d0c4b<_0x3ba201[_0x67b0('0x83')]['length'];_0x1d0c4b++){var _0x55b67a=_0x3ba201[_0x67b0('0x84')]?_[_0x67b0('0x52')](_0x3ba201[_0x67b0('0x84')][_0x1d0c4b])?'':_0x3ba201[_0x67b0('0x84')][_0x1d0c4b]:_0x3ba201[_0x67b0('0x83')][_0x1d0c4b]['ItemTypeId']?_0x3ba201[_0x67b0('0x83')][_0x1d0c4b][_0x67b0('0x85')]:'';var _0x46275f=_['isNil'](_0x3ba201['items'][_0x1d0c4b][_0x67b0('0x86')])?'':_0x3ba201[_0x67b0('0x83')][_0x1d0c4b]['description'];var _0x13fcf2=_0x55b67a+':'+_0x3ba201['items'][_0x1d0c4b][_0x67b0('0x73')]+'§'+_0x46275f;if(_[_0x67b0('0x52')](_0x3d32bc))_0x3d32bc=_0x13fcf2;else _0x3d32bc+=';'+_0x13fcf2;var _0x27e2d6=null;var _0x12a137=null;if(_0x3ba201[_0x67b0('0x84')]){if(!_['isNil'](_0x3ba201[_0x67b0('0x84')][_0x1d0c4b])){_0x12a137=_[_0x67b0('0x21')](_0x56a7cb,function(_0x412f2c){return _0x412f2c['id']===_0x3ba201[_0x67b0('0x84')][_0x1d0c4b];});if(!_['isNil'](_0x12a137)){_0x27e2d6=_0x12a137['OrderBy'];}}}else{if(!_[_0x67b0('0x52')](_0x3ba201['items'][_0x1d0c4b])){_0x12a137=_[_0x67b0('0x21')](_0x56a7cb,function(_0x3cecf4){return _0x3cecf4['id']===_0x3ba201['items'][_0x1d0c4b][_0x67b0('0x85')];});if(!_[_0x67b0('0x52')](_0x12a137)){_0x27e2d6=_0x1d0c4b;}}}if(_[_0x67b0('0x52')](_0x27e2d6)){_0x27e2d6=0x64;}_0x2406af[_0x67b0('0x59')](addAdditionalPhone(_0x3ba201['id'],_0x3ba201['items'][_0x1d0c4b][_0x67b0('0x73')],_0x3ba201[_0x67b0('0x84')]?_[_0x67b0('0x52')](_0x3ba201['item_types'][_0x1d0c4b])?null:_0x3ba201[_0x67b0('0x84')][_0x1d0c4b]:_0x3ba201[_0x67b0('0x83')][_0x1d0c4b][_0x67b0('0x85')]?_0x3ba201[_0x67b0('0x83')][_0x1d0c4b]['ItemTypeId']:null,_0x27e2d6,_0x46275f));}Promise['all'](_0x2406af)[_0x67b0('0x17')](function(){db[_0x67b0('0x3e')][_0x67b0('0x16')]({'AdditionalPhones':_0x3d32bc},{'where':{'id':_0x3ba201['id']}})['then'](function(){_0x5e561d(0x1);});});});});});}function addAdditionalPhone(_0x42ce26,_0x1f7426,_0x38c8ac,_0x2e4ec1,_0x5aab8d){return db['CmContactHasItem']['find']({'where':{'CmContactId':_0x42ce26,'item':_0x1f7426}})[_0x67b0('0x17')](function(_0x296c23){if(_0x296c23)logger['info'](_0x67b0('0x87'),_0x296c23);else{db['CmContactHasItem'][_0x67b0('0x3f')]({'CmContactId':_0x42ce26,'item':_0x1f7426,'ItemTypeId':_0x38c8ac,'OrderBy':_0x2e4ec1,'ItemClass':_0x67b0('0x88'),'description':_0x5aab8d});}});}function deleteCmHopperPhones(_0x67dcbd){return new Promise(function(_0x19736f){return db['CmHopper'][_0x67b0('0x2c')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x67dcbd}})[_0x67b0('0x17')](function(_0x2759f6){db[_0x67b0('0x89')][_0x67b0('0x18')]({'where':{'CmHopperId':{'$in':_[_0x67b0('0x6c')](_0x2759f6,'id')}}});})[_0x67b0('0x17')](function(){_0x19736f(0x1);});});}function addCmHopperPhones(_0xfe5add){return new Promise(function(_0x52a8d5){return db[_0x67b0('0x8a')][_0x67b0('0x2c')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0xfe5add}})[_0x67b0('0x17')](function(_0xb52af9){var _0x135c5b=[];_['map'](_0xb52af9,function(_0x370c36){_0x135c5b[_0x67b0('0x59')](createCmHopperPhone(_0xfe5add,_0x370c36['id']));});Promise[_0x67b0('0x5d')](_0x135c5b)[_0x67b0('0x17')](function(){_0x52a8d5(0x1);});});});}function createCmHopperPhone(_0x46c558,_0x17cf1c){return new Promise(function(_0x1e1d6b){db[_0x67b0('0x49')][_0x67b0('0x2c')]({'raw':!![],'attributes':['item',_0x67b0('0x82')],'where':{'CmContactId':_0x46c558,'ItemClass':_0x67b0('0x88')},'include':[{'model':db['ContactItemType'],'attributes':['OrderBy'],'as':_0x67b0('0x8b')}],'order':[_0x67b0('0x82'),db[_0x67b0('0x71')][_0x67b0('0x64')](_0x67b0('0x8c'))]})[_0x67b0('0x17')](function(_0x4120fd){var _0x568d20=0x1;var _0x14fba5=_[_0x67b0('0x6c')](_0x4120fd,function(_0x2e297f){_0x2e297f['CmHopperId']=_0x17cf1c;_0x2e297f[_0x67b0('0x73')]=_0x2e297f[_0x67b0('0x8d')];_0x2e297f[_0x67b0('0x82')]=_0x568d20;delete _0x2e297f[_0x67b0('0x8e')];_0x568d20=_0x568d20+0x1;return _0x2e297f;});return db[_0x67b0('0x89')][_0x67b0('0x8f')](_0x14fba5,{});})[_0x67b0('0x17')](function(){_0x1e1d6b(0x1);});});}function insertAdditionalPhones(_0x2ad70b,_0x5a5d1b){return new Promise(function(_0x2805f4){var _0x28f1ce=[];for(var _0x104a26=0x0;_0x104a26<_0x5a5d1b[_0x67b0('0x26')];_0x104a26++){var _0x33964a=_0x5a5d1b[_0x104a26];_0x28f1ce[_0x67b0('0x59')](parseContactItemType(_0x33964a));}Promise[_0x67b0('0x5d')](_0x28f1ce)[_0x67b0('0x17')](function(){var _0x260813={'id':_0x2ad70b['id'],'items':_0x5a5d1b};return addAdditionalPhones(_0x260813)[_0x67b0('0x17')](function(){return addCmHopperPhones(_0x2ad70b['id']);});})[_0x67b0('0x17')](function(){_0x2805f4(_0x2ad70b);});});}function parseContactItemType(_0x2d366c){return new Promise(function(_0x3e7035){if(_0x2d366c[_0x67b0('0x5c')](_0x67b0('0x85'))){_0x3e7035(_0x2d366c);}else{return db[_0x67b0('0x63')][_0x67b0('0x21')]({'where':{'name':_0x2d366c['ItemType']}})['then'](function(_0x2be753){if(_[_0x67b0('0x52')](_0x2be753))_0x2d366c[_0x67b0('0x85')]=null;else _0x2d366c[_0x67b0('0x85')]=_0x2be753['id'];_0x3e7035(_0x2d366c);});}});}exports[_0x67b0('0x90')]=function(_0x1c1569,_0x57a04f){return db[_0x67b0('0x49')][_0x67b0('0x2c')]({'raw':!![],'where':{'CmContactId':_0x1c1569[_0x67b0('0x22')]['id'],'ItemClass':_0x67b0('0x88')},'include':[{'model':db[_0x67b0('0x63')],'as':_0x67b0('0x8b')}],'order':[['OrderBy'],[db[_0x67b0('0x71')][_0x67b0('0x64')]('`ItemType`.OrderBy')]]})[_0x67b0('0x17')](function(_0x2fb9a0){return _0x2fb9a0;})[_0x67b0('0x17')](respondWithResult(_0x57a04f,null))[_0x67b0('0x20')](handleError(_0x57a04f,null));};exports['duplicateAdditionalPhones']=function(_0x1bfa2d,_0x7e7b7f){return db[_0x67b0('0x49')]['findAll']({'raw':!![],'where':{'CmContactId':_0x1bfa2d[_0x67b0('0x33')][_0x67b0('0x91')]}})[_0x67b0('0x17')](function(_0x277492){var _0x364e16=_[_0x67b0('0x6c')](_0x277492,function(_0x476a4e){_0x476a4e[_0x67b0('0x92')]=_0x1bfa2d[_0x67b0('0x33')][_0x67b0('0x93')];return _0x476a4e;});return db[_0x67b0('0x49')][_0x67b0('0x8f')](_0x364e16,{});})['then'](function(){return addCmHopperPhones(_0x1bfa2d[_0x67b0('0x33')][_0x67b0('0x93')]);})[_0x67b0('0x17')](function(){return['ok'];})['then'](respondWithResult(_0x7e7b7f,null))[_0x67b0('0x20')](handleError(_0x7e7b7f,null));};exports[_0x67b0('0x94')]=function(_0x630933,_0x1d2227){var _0xf23972=[];_0xf23972[_0x67b0('0x59')](createCmHopperPhone(_0x630933['body']['id'],_0x630933['body'][_0x67b0('0x95')]));Promise['all'](_0xf23972)[_0x67b0('0x17')](function(){return[0x1];})[_0x67b0('0x17')](respondWithResult(_0x1d2227,null));};exports[_0x67b0('0x96')]=function(_0xb51ae5,_0x40ce30){var _0x557e32={'raw':![],'where':{}};var _0xeef656={};var _0x6fba86={'count':0x0,'rows':[]};return db['CmContact'][_0x67b0('0x75')]({'where':{'id':_0xb51ae5[_0x67b0('0x22')]['id']}})[_0x67b0('0x17')](handleEntityNotFound(_0x40ce30,null))['then'](function(_0x4281a0){if(_0x4281a0){_0xeef656[_0x67b0('0x79')]=_['keys'](db[_0x67b0('0x8a')]['rawAttributes']);_0xeef656[_0x67b0('0x29')]=_[_0x67b0('0x25')](_0xb51ae5[_0x67b0('0x29')]);_0xeef656[_0x67b0('0x76')]=_['intersection'](_0xeef656[_0x67b0('0x79')],_0xeef656['query']);_0x557e32[_0x67b0('0x78')]=_[_0x67b0('0x77')](_0xeef656[_0x67b0('0x79')],qs[_0x67b0('0x7a')](_0xb51ae5[_0x67b0('0x29')][_0x67b0('0x7a')]));_0x557e32[_0x67b0('0x78')]=_0x557e32[_0x67b0('0x78')][_0x67b0('0x26')]?_0x557e32[_0x67b0('0x78')]:_0xeef656[_0x67b0('0x79')];if(!_0xb51ae5[_0x67b0('0x29')][_0x67b0('0x5c')](_0x67b0('0x97'))){_0x557e32['limit']=qs[_0x67b0('0x11')](_0xb51ae5[_0x67b0('0x29')][_0x67b0('0x11')]);_0x557e32[_0x67b0('0x13')]=qs[_0x67b0('0x13')](_0xb51ae5[_0x67b0('0x29')][_0x67b0('0x13')]);}_0x557e32['order']=qs[_0x67b0('0x7c')](_0xb51ae5[_0x67b0('0x29')][_0x67b0('0x7c')]);_0x557e32[_0x67b0('0x57')]=qs[_0x67b0('0x76')](_[_0x67b0('0x98')](_0xb51ae5[_0x67b0('0x29')],_0xeef656[_0x67b0('0x76')]));_0x557e32[_0x67b0('0x57')][_0x67b0('0x99')]=_0x4281a0['id'];if(_0xb51ae5['query'][_0x67b0('0x7d')]){_0x557e32['where']=_['merge'](_0x557e32[_0x67b0('0x57')],{'$or':_[_0x67b0('0x6c')](_0x557e32[_0x67b0('0x78')],function(_0xdc1bcf){var _0x122567={};_0x122567[_0xdc1bcf]={'$like':'%'+_0xb51ae5[_0x67b0('0x29')][_0x67b0('0x7d')]+'%'};return _0x122567;})});}_0x557e32=_['merge']({},_0x557e32,_0xb51ae5[_0x67b0('0x7f')]);return db[_0x67b0('0x8a')][_0x67b0('0x12')]({'where':_0x557e32[_0x67b0('0x57')]})[_0x67b0('0x17')](function(_0x3d904e){_0x6fba86['count']=_0x3d904e;if(_0xb51ae5[_0x67b0('0x29')][_0x67b0('0x9a')]){_0x557e32['include']=[{'all':!![]}];}return db['CmHopper'][_0x67b0('0x2c')](_0x557e32);})[_0x67b0('0x17')](function(_0x2230a9){_0x6fba86[_0x67b0('0x9b')]=_0x2230a9;return _0x6fba86;});}})[_0x67b0('0x17')](respondWithFilteredResult(_0x40ce30,_0x557e32))[_0x67b0('0x20')](handleError(_0x40ce30,null));};exports['getHopperHistories']=function(_0xfce4c,_0x27a8c3){var _0x5a66c1={'raw':!![],'where':{}};var _0x3c04d9={};var _0x2f98e6={'count':0x0,'rows':[]};return db[_0x67b0('0x3e')][_0x67b0('0x75')]({'where':{'id':_0xfce4c[_0x67b0('0x22')]['id']}})[_0x67b0('0x17')](handleEntityNotFound(_0x27a8c3,null))[_0x67b0('0x17')](function(_0x1072f9){if(_0x1072f9){_0x3c04d9['model']=_[_0x67b0('0x25')](db[_0x67b0('0x4a')]['rawAttributes']);_0x3c04d9['query']=_['keys'](_0xfce4c[_0x67b0('0x29')]);_0x3c04d9[_0x67b0('0x76')]=_[_0x67b0('0x77')](_0x3c04d9[_0x67b0('0x79')],_0x3c04d9[_0x67b0('0x29')]);_0x5a66c1[_0x67b0('0x78')]=_[_0x67b0('0x77')](_0x3c04d9['model'],qs[_0x67b0('0x7a')](_0xfce4c['query'][_0x67b0('0x7a')]));_0x5a66c1[_0x67b0('0x78')]=_0x5a66c1[_0x67b0('0x78')]['length']?_0x5a66c1[_0x67b0('0x78')]:_0x3c04d9[_0x67b0('0x79')];if(!_0xfce4c[_0x67b0('0x29')][_0x67b0('0x5c')](_0x67b0('0x97'))){_0x5a66c1[_0x67b0('0x11')]=qs['limit'](_0xfce4c[_0x67b0('0x29')][_0x67b0('0x11')]);_0x5a66c1[_0x67b0('0x13')]=qs[_0x67b0('0x13')](_0xfce4c['query'][_0x67b0('0x13')]);}_0x5a66c1[_0x67b0('0x7b')]=qs[_0x67b0('0x7c')](_0xfce4c[_0x67b0('0x29')][_0x67b0('0x7c')]);_0x5a66c1[_0x67b0('0x57')]=qs['filters'](_['pick'](_0xfce4c[_0x67b0('0x29')],_0x3c04d9[_0x67b0('0x76')]));_0x5a66c1[_0x67b0('0x57')][_0x67b0('0x99')]=_0x1072f9['id'];if(_0xfce4c[_0x67b0('0x29')]['filter']){_0x5a66c1[_0x67b0('0x57')]=_[_0x67b0('0x7e')](_0x5a66c1['where'],{'$or':_[_0x67b0('0x6c')](_0x5a66c1[_0x67b0('0x78')],function(_0x23f91d){var _0x4e8367={};_0x4e8367[_0x23f91d]={'$like':'%'+_0xfce4c[_0x67b0('0x29')]['filter']+'%'};return _0x4e8367;})});}_0x5a66c1=_[_0x67b0('0x7e')]({},_0x5a66c1,_0xfce4c[_0x67b0('0x7f')]);return db[_0x67b0('0x4a')][_0x67b0('0x12')]({'where':_0x5a66c1[_0x67b0('0x57')]})[_0x67b0('0x17')](function(_0x1f2cdd){_0x2f98e6[_0x67b0('0x12')]=_0x1f2cdd;if(_0xfce4c[_0x67b0('0x29')][_0x67b0('0x9a')]){_0x5a66c1[_0x67b0('0x9c')]=[{'all':!![]}];}return db[_0x67b0('0x4a')]['findAll'](_0x5a66c1);})[_0x67b0('0x17')](function(_0x49c35a){_0x2f98e6[_0x67b0('0x9b')]=_0x49c35a;return _0x2f98e6;});}})[_0x67b0('0x17')](respondWithFilteredResult(_0x27a8c3,_0x5a66c1))[_0x67b0('0x20')](handleError(_0x27a8c3,null));};exports[_0x67b0('0x9d')]=function(_0x50488b,_0x1f05a6){var _0xdee3a4={'raw':!![],'where':{}};var _0x5d152d={};var _0x1bcb46={'count':0x0,'rows':[]};return db[_0x67b0('0x3e')][_0x67b0('0x75')]({'where':{'id':_0x50488b['params']['id']}})[_0x67b0('0x17')](handleEntityNotFound(_0x1f05a6,null))[_0x67b0('0x17')](function(_0x4fdeaf){if(_0x4fdeaf){_0x5d152d[_0x67b0('0x79')]=_[_0x67b0('0x25')](db[_0x67b0('0x9e')]['rawAttributes']);_0x5d152d['query']=_[_0x67b0('0x25')](_0x50488b[_0x67b0('0x29')]);_0x5d152d['filters']=_['intersection'](_0x5d152d[_0x67b0('0x79')],_0x5d152d[_0x67b0('0x29')]);_0xdee3a4['attributes']=_[_0x67b0('0x77')](_0x5d152d['model'],qs[_0x67b0('0x7a')](_0x50488b[_0x67b0('0x29')][_0x67b0('0x7a')]));_0xdee3a4[_0x67b0('0x78')]=_0xdee3a4[_0x67b0('0x78')][_0x67b0('0x26')]?_0xdee3a4['attributes']:_0x5d152d[_0x67b0('0x79')];if(!_0x50488b[_0x67b0('0x29')][_0x67b0('0x5c')](_0x67b0('0x97'))){_0xdee3a4[_0x67b0('0x11')]=qs['limit'](_0x50488b[_0x67b0('0x29')][_0x67b0('0x11')]);_0xdee3a4[_0x67b0('0x13')]=qs[_0x67b0('0x13')](_0x50488b[_0x67b0('0x29')]['offset']);}_0xdee3a4[_0x67b0('0x7b')]=qs[_0x67b0('0x7c')](_0x50488b[_0x67b0('0x29')][_0x67b0('0x7c')]);_0xdee3a4['where']=qs[_0x67b0('0x76')](_[_0x67b0('0x98')](_0x50488b[_0x67b0('0x29')],_0x5d152d[_0x67b0('0x76')]));_0xdee3a4[_0x67b0('0x57')]['ContactId']=_0x4fdeaf['id'];if(_0x50488b[_0x67b0('0x29')][_0x67b0('0x7d')]){_0xdee3a4['where']=_['merge'](_0xdee3a4[_0x67b0('0x57')],{'$or':_[_0x67b0('0x6c')](_0xdee3a4[_0x67b0('0x78')],function(_0x57db51){var _0x367a5e={};_0x367a5e[_0x57db51]={'$like':'%'+_0x50488b[_0x67b0('0x29')]['filter']+'%'};return _0x367a5e;})});}_0xdee3a4=_[_0x67b0('0x7e')]({},_0xdee3a4,_0x50488b[_0x67b0('0x7f')]);return db[_0x67b0('0x9e')][_0x67b0('0x12')]({'where':_0xdee3a4['where']})[_0x67b0('0x17')](function(_0x3de922){_0x1bcb46['count']=_0x3de922;if(_0x50488b[_0x67b0('0x29')][_0x67b0('0x9a')]){_0xdee3a4[_0x67b0('0x9c')]=[{'all':!![]}];}return db[_0x67b0('0x9e')][_0x67b0('0x2c')](_0xdee3a4);})[_0x67b0('0x17')](function(_0x347def){_0x1bcb46['rows']=_0x347def;return _0x1bcb46;});}})[_0x67b0('0x17')](respondWithFilteredResult(_0x1f05a6,_0xdee3a4))['catch'](handleError(_0x1f05a6,null));};exports[_0x67b0('0x9f')]=function(_0x32ce61,_0x5d62b1){var _0x168917={'raw':!![],'where':{}};var _0x41a74d={};var _0x2b5b31={'count':0x0,'rows':[]};return db['CmContact']['findOne']({'where':{'id':_0x32ce61[_0x67b0('0x22')]['id']}})[_0x67b0('0x17')](handleEntityNotFound(_0x5d62b1,null))[_0x67b0('0x17')](function(_0x3a0ddf){if(_0x3a0ddf){_0x41a74d['model']=_['keys'](db[_0x67b0('0x4f')]['rawAttributes']);_0x41a74d[_0x67b0('0x29')]=_[_0x67b0('0x25')](_0x32ce61[_0x67b0('0x29')]);_0x41a74d[_0x67b0('0x76')]=_[_0x67b0('0x77')](_0x41a74d[_0x67b0('0x79')],_0x41a74d[_0x67b0('0x29')]);_0x168917[_0x67b0('0x78')]=_[_0x67b0('0x77')](_0x41a74d[_0x67b0('0x79')],qs[_0x67b0('0x7a')](_0x32ce61[_0x67b0('0x29')][_0x67b0('0x7a')]));_0x168917[_0x67b0('0x78')]=_0x168917[_0x67b0('0x78')][_0x67b0('0x26')]?_0x168917[_0x67b0('0x78')]:_0x41a74d[_0x67b0('0x79')];if(!_0x32ce61[_0x67b0('0x29')][_0x67b0('0x5c')](_0x67b0('0x97'))){_0x168917[_0x67b0('0x11')]=qs['limit'](_0x32ce61[_0x67b0('0x29')]['limit']);_0x168917[_0x67b0('0x13')]=qs[_0x67b0('0x13')](_0x32ce61[_0x67b0('0x29')][_0x67b0('0x13')]);}_0x168917['order']=qs[_0x67b0('0x7c')](_0x32ce61[_0x67b0('0x29')]['sort']);_0x168917[_0x67b0('0x57')]=qs[_0x67b0('0x76')](_[_0x67b0('0x98')](_0x32ce61['query'],_0x41a74d[_0x67b0('0x76')]));_0x168917[_0x67b0('0x57')][_0x67b0('0x99')]=_0x3a0ddf['id'];if(_0x32ce61[_0x67b0('0x29')]['filter']){_0x168917['where']=_[_0x67b0('0x7e')](_0x168917[_0x67b0('0x57')],{'$or':_[_0x67b0('0x6c')](_0x168917[_0x67b0('0x78')],function(_0x2e7c66){var _0x373f25={};_0x373f25[_0x2e7c66]={'$like':'%'+_0x32ce61[_0x67b0('0x29')][_0x67b0('0x7d')]+'%'};return _0x373f25;})});}_0x168917=_['merge']({},_0x168917,_0x32ce61[_0x67b0('0x7f')]);return db[_0x67b0('0x4f')][_0x67b0('0x12')]({'where':_0x168917[_0x67b0('0x57')]})[_0x67b0('0x17')](function(_0x4d0f90){_0x2b5b31[_0x67b0('0x12')]=_0x4d0f90;if(_0x32ce61['query']['includeAll']){_0x168917[_0x67b0('0x9c')]=[{'all':!![]}];}return db[_0x67b0('0x4f')][_0x67b0('0x2c')](_0x168917);})[_0x67b0('0x17')](function(_0x25c188){_0x2b5b31[_0x67b0('0x9b')]=_0x25c188;return _0x2b5b31;});}})['then'](respondWithFilteredResult(_0x5d62b1,_0x168917))[_0x67b0('0x20')](handleError(_0x5d62b1,null));};exports[_0x67b0('0xa0')]=function(_0x4e2933,_0x4c4230){try{if(!_0x4e2933[_0x67b0('0x33')][_0x67b0('0x5a')]){throw new Error(_0x67b0('0xa1'));}if(!_0x4e2933[_0x67b0('0x33')]['binding_keys']){throw new Error(_0x67b0('0xa2'));}if(!_0x4e2933['body'][_0x67b0('0xa3')]){throw new Error(_0x67b0('0xa4'));}if(!_0x4e2933[_0x67b0('0x33')][_0x67b0('0xa5')]){throw new Error(_0x67b0('0xa6'));}var _0x533619=_0x4e2933['body']['binding_keys'][_0x67b0('0xa7')](',');var _0x440bf5=_0x4e2933['body'][_0x67b0('0xa3')]['split'](',');if(!_0x533619[_0x67b0('0x26')]||!_0x440bf5[_0x67b0('0x26')]||_0x533619[_0x67b0('0x26')]!==_0x440bf5[_0x67b0('0x26')]){throw new Error(_0x67b0('0xa8'));}_0x4e2933['body']['fields']=_[_0x67b0('0xa9')](_0x533619,_0x440bf5);if(!_0x4e2933[_0x67b0('0x33')][_0x67b0('0x7a')][_0x67b0('0x73')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x4e2933[_0x67b0('0x33')][_0x67b0('0x7a')]['firstName']){throw new Error(_0x67b0('0xaa'));}var _0x39a133=path[_0x67b0('0x38')](config['root'],_0x67b0('0xab'),_0x4e2933[_0x67b0('0xac')]['filename']);fs[_0x67b0('0xad')](_0x39a133,parseInt(_0x67b0('0xae'),0x8));var _0x569878=require('child_process')['fork'](path[_0x67b0('0x38')](__dirname,_0x67b0('0xaf')),[_0x39a133,_0x4e2933[_0x67b0('0x33')][_0x67b0('0xb0')],_0x4e2933[_0x67b0('0x33')][_0x67b0('0xa3')],_0x4e2933[_0x67b0('0x33')][_0x67b0('0x5a')],_0x4e2933['body']['CompanyId'],_0x4e2933[_0x67b0('0x33')]['duplicates'],_0x4e2933[_0x67b0('0x33')][_0x67b0('0xa5')]]);return _0x4c4230['status'](0xc8)[_0x67b0('0xf')]({'message':'File\x20uploaded\x20correctly!','pid':_0x569878[_0x67b0('0xb1')]});}catch(_0x353731){return _0x4c4230[_0x67b0('0x19')](0x1f4)[_0x67b0('0x1d')](_0x353731);}};exports['upload']=function(_0x56fd42,_0x4f067d){var _0x2efe27=fs['createReadStream'](_0x56fd42['file'][_0x67b0('0x2')]);Papa['parse'](_0x2efe27,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x23ea17){return _0x4f067d[_0x67b0('0x19')](0xc8)[_0x67b0('0xf')]({'file':_0x56fd42['file'],'fields':_0x23ea17[_0x67b0('0xb2')][_0x67b0('0x7a')]});}});};exports[_0x67b0('0xb3')]=function(_0x5e2f0b,_0x2a23d7){return db[_0x67b0('0xb4')][_0x67b0('0x2c')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0x67b0('0x17')](function(_0x5195dd){var _0x1237fa=![];if(!_0x5e2f0b[_0x67b0('0x33')]['ListId']){throw new Error('No\x20ListId\x20specified');}if(!_0x5e2f0b[_0x67b0('0x33')][_0x67b0('0xb5')][_0x67b0('0x73')]){throw new Error(_0x67b0('0xb6'));}if(!_0x5e2f0b[_0x67b0('0x33')]['binding']['firstName']){throw new Error(_0x67b0('0xaa'));}if(!_0x5e2f0b[_0x67b0('0x33')][_0x67b0('0xa5')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x206f6e=require('child_process')['fork'](path[_0x67b0('0x38')](__dirname,_0x67b0('0xb7')),[_0x5e2f0b[_0x67b0('0x22')]['id'],JSON[_0x67b0('0xb8')](_0x5e2f0b[_0x67b0('0x33')]),JSON[_0x67b0('0xb8')](_0x5195dd)]);_0x206f6e['on'](_0x67b0('0xb9'),function(){_0x1237fa=!![];return _0x2a23d7[_0x67b0('0x19')](0xc8)[_0x67b0('0xf')]({'message':_0x67b0('0xba'),'pid':_0x206f6e[_0x67b0('0xb1')]});});_0x206f6e['on'](_0x67b0('0xbb'),function(_0x44657f){if(_0x44657f&&!_0x1237fa){return _0x2a23d7['status'](0x1f4)[_0x67b0('0xf')]({'message':_0x67b0('0xbc'),'pid':_0x206f6e[_0x67b0('0xb1')]});}});})[_0x67b0('0x20')](handleError(_0x2a23d7,null));};exports['importUpdates']=function(_0x57af8e,_0x40f96f){return db[_0x67b0('0xb4')][_0x67b0('0x2c')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0x67b0('0x17')](function(_0x577aa5){var _0x4917cb=![];if(!_0x57af8e[_0x67b0('0x33')]['ListId']){throw new Error('No\x20ListId\x20specified');}if(!_0x57af8e[_0x67b0('0x33')][_0x67b0('0xb5')][_0x67b0('0x73')]){throw new Error(_0x67b0('0xb6'));}if(!_0x57af8e['body'][_0x67b0('0xb5')][_0x67b0('0xbd')]){throw new Error(_0x67b0('0xaa'));}if(!_0x57af8e[_0x67b0('0x33')][_0x67b0('0xa5')]){throw new Error(_0x67b0('0xa6'));}var _0x228258=require(_0x67b0('0xbe'))[_0x67b0('0xbf')](path[_0x67b0('0x38')](__dirname,'../../components/import/cm/csvUpdates'),[_0x57af8e[_0x67b0('0x22')]['id'],JSON['stringify'](_0x57af8e[_0x67b0('0x33')]),JSON[_0x67b0('0xb8')](_0x577aa5)]);_0x228258['on'](_0x67b0('0xb9'),function(){_0x4917cb=!![];return _0x40f96f[_0x67b0('0x19')](0xc8)[_0x67b0('0xf')]({'message':_0x67b0('0xba'),'pid':_0x228258[_0x67b0('0xb1')]});});_0x228258['on']('exit',function(_0x27674e){if(_0x27674e&&!_0x4917cb){return _0x40f96f[_0x67b0('0x19')](0x1f4)[_0x67b0('0xf')]({'message':'error\x20child\x20process','pid':_0x228258[_0x67b0('0xb1')]});}});})[_0x67b0('0x20')](handleError(_0x40f96f,null));};exports[_0x67b0('0xc0')]=function(_0x220b38,_0x32c182){var _0x99d7b5=[_0x67b0('0xc1'),_0x67b0('0xc2'),'sms','openchannel',_0x67b0('0xc3'),_0x67b0('0xc4'),_0x67b0('0xc5')];var _0x231823={'offset':0x0,'order':qs[_0x67b0('0x7c')](_0x67b0('0xc6'))},_0x2afa90={'count':0x0,'rows':[]};Promise['resolve']()[_0x67b0('0x17')](function(){if(_0x220b38['query'][_0x67b0('0xc7')]){if(!_[_0x67b0('0xc8')](_0x99d7b5,_0x220b38[_0x67b0('0x29')][_0x67b0('0xc7')][_0x67b0('0xc9')]())){throw new Error(_0x67b0('0xca'));}_0x99d7b5=[_0x220b38[_0x67b0('0x29')][_0x67b0('0xc7')]['toLowerCase']()];}if(_0x220b38[_0x67b0('0x29')]['range']){try{var _0x2454c9=JSON[_0x67b0('0xcb')](_0x220b38['query'][_0x67b0('0xcc')]);if(!moment(_0x2454c9[_0x67b0('0x34')])[_0x67b0('0xcd')]()){throw new Error('Invalid\x20date\x20for\x20range\x20from\x20filter');}if(!moment(_0x2454c9['to'])[_0x67b0('0xcd')]()){throw new Error(_0x67b0('0xce'));}}catch(_0x48476f){throw new Error(_0x67b0('0xcf'));}}if(!_0x220b38[_0x67b0('0x29')][_0x67b0('0x5c')](_0x67b0('0x97'))){_0x231823[_0x67b0('0x11')]=qs[_0x67b0('0x11')](_0x220b38[_0x67b0('0x29')]['limit']||0xa);_0x231823['offset']=qs[_0x67b0('0x13')](_0x220b38[_0x67b0('0x29')][_0x67b0('0x13')]);}var _0x47ef74=_0x99d7b5[_0x67b0('0x6c')](function(_0xf916bb){if(_0xf916bb===_0x67b0('0xc5')){var _0x5ca274={'attributes':['id',_0x67b0('0xd0'),_0x67b0('0x30'),_0x67b0('0xd1'),'destination',_0x67b0('0xd2'),_0x67b0('0xd3'),_0x67b0('0xd4'),'duration',_0x67b0('0xd5'),_0x67b0('0xd6'),'userDisposition','userSecondDisposition',_0x67b0('0xd7'),_0x67b0('0xd8')],'where':{'ContactId':_0x220b38['params']['id']},'include':[{'model':db[_0x67b0('0xb4')],'as':_0x67b0('0xb4'),'attributes':['id',_0x67b0('0x1c'),_0x67b0('0xd9'),'alias']}],'order':[[_0x67b0('0xd6'),_0x67b0('0xda')]]};if(_0x220b38[_0x67b0('0x29')][_0x67b0('0xcc')]){_0x5ca274[_0x67b0('0x57')][_0x67b0('0xd6')]={'$gte':_0x2454c9[_0x67b0('0x34')],'$lte':_0x2454c9['to']};}return db[_0x67b0('0xdb')][_0x67b0('0xdc')](_0x5ca274)[_0x67b0('0x17')](function(_0x5334c5){_0x2afa90[_0x67b0('0x12')]+=_0x5334c5[_0x67b0('0x12')];return _[_0x67b0('0x6c')](_0x5334c5[_0x67b0('0x9b')],function(_0x452fe6){var _0x397c94=_0x452fe6[_0x67b0('0x35')]({'plain':!![]});_0x397c94[_0x67b0('0xc7')]=_0xf916bb;if(_0x397c94['User']){_0x397c94['User']={'id':_0x397c94[_0x67b0('0xb4')]['id'],'name':_0x397c94['User'][_0x67b0('0x1c')],'fullname':_0x397c94[_0x67b0('0xb4')]['fullname'],'alias':_0x397c94[_0x67b0('0xb4')]['alias']};}return _0x397c94;});});}else{var _0xc63a06=_[_0x67b0('0xdd')](_0xf916bb)+(_0xf916bb===_0x67b0('0xc2')?'Website':'Account');var _0x31be10={'attributes':['id',_0x67b0('0xde'),_0x67b0('0xdf'),_0x67b0('0xd6'),_0x67b0('0xd5'),_0x67b0('0xe0'),_0x67b0('0xe1'),_0x67b0('0xe2'),'UserId',_0xc63a06+'Id'],'where':{'ContactId':_0x220b38['params']['id']},'include':[{'model':db[_0xc63a06],'as':_0x67b0('0xe3'),'attributes':['id',_0x67b0('0x1c'),'key']},{'model':db[_0x67b0('0xb4')],'as':_0x67b0('0xe4'),'attributes':['id',_0x67b0('0x1c'),'fullname']},{'model':db[_0x67b0('0x5f')],'as':_0x67b0('0xe5'),'attributes':['id','name',_0x67b0('0x60')],'through':{'attributes':[]}}],'order':[[_0x67b0('0xd6'),_0x67b0('0xda')]]};if(_0x220b38[_0x67b0('0x29')][_0x67b0('0xcc')]){_0x31be10['where']['createdAt']={'$gte':_0x2454c9['from'],'$lte':_0x2454c9['to']};}switch(_0xf916bb){case _0x67b0('0xc2'):_0x31be10['attributes']['push'](_0x67b0('0xe6'),'customerIp','customerPort',_0x67b0('0xe7'),_0x67b0('0xe8'),_0x67b0('0xe9'),_0x67b0('0xea'),_0x67b0('0xeb'),_0x67b0('0xec'));break;case _0x67b0('0xc1'):_0x31be10[_0x67b0('0x78')][_0x67b0('0x59')](_0x67b0('0xed'),_0x67b0('0xee'));break;case _0x67b0('0xef'):_0x31be10[_0x67b0('0x78')][_0x67b0('0x59')](_0x67b0('0xf0'),_0x67b0('0xf1'));break;}return db[_[_0x67b0('0xdd')](_0xf916bb)+_0x67b0('0xf2')][_0x67b0('0xdc')](_0x31be10)[_0x67b0('0x17')](function(_0x24a49f){_0x2afa90[_0x67b0('0x12')]+=_0x24a49f[_0x67b0('0x12')];return _['map'](_0x24a49f[_0x67b0('0x9b')],function(_0x15adba){var _0xef8f69=_0x15adba['get']({'plain':!![]});_0xef8f69[_0x67b0('0xc7')]=_0xf916bb;if(_0xef8f69['Owner']){_0xef8f69[_0x67b0('0xe4')]={'id':_0xef8f69[_0x67b0('0xe4')]['id'],'name':_0xef8f69[_0x67b0('0xe4')]['name'],'fullname':_0xef8f69[_0x67b0('0xe4')][_0x67b0('0xd9')]};}return _0xef8f69;});});}});return Promise[_0x67b0('0x5d')](_0x47ef74);})[_0x67b0('0x17')](function(_0x630c42){return _(_0x630c42)[_0x67b0('0xf3')]()[_0x67b0('0xf4')](_0x67b0('0xd6'))[_0x67b0('0xf5')]()[_0x67b0('0xf6')]();})[_0x67b0('0x17')](function(_0x4004b7){_0x2afa90[_0x67b0('0x9b')]=_0x231823[_0x67b0('0x11')]?_0x4004b7[_0x67b0('0xf7')](_0x231823[_0x67b0('0x13')],_0x231823[_0x67b0('0x13')]+_0x231823[_0x67b0('0x11')]):_0x4004b7;return _0x2afa90;})['then'](respondWithFilteredResult(_0x32c182,_0x231823))[_0x67b0('0x20')](handleError(_0x32c182,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff