// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x0f67=['update','then','end','sendStatus','error','stack','name','send','index','describe','getOptions','query','user','catch','destroy','CmContact','find','params','tags','keys','length','cf_','columnName','displayName','analytics','CmCustomField','findAll','alias','custom','info','Custom\x20field\x20%s\x20not\x20found\x20on\x20cm_contacts\x20table','merge','body','from','get','mergeWith','isArray','join','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsMessage','FaxInteraction','FaxMessage','OpenchannelMessage','CmHopperFinal','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappMessage','WhatsappQueueReport','dialTimezone','isNil','timezones','utcOffset','additionalPhones','bulkCreate','each','duplicates','where','$or','ListId','findOrCreate','spread','hasOwnProperty','push','contact','all','Tag','Tags','color','tag','CmContactHasItem','Phones','ItemType','sequelize','literal','$and','omit','map','format','pickBy','cf_%d','isEmpty','table','setFields','id\x20=\x20?','toParam','text','values','phone','getTags','findOne','model','rawAttributes','intersection','fields','attributes','order','sort','filters','pick','filter','options','nolimit','setTags','ids','setAdditionalPhones','ContactItemType','OrderBy','items','item_types','ItemTypeId','description','contact\x20phone\x20exists','CmHopperAdditionalPhone','item','PHONE','`ItemType`.OrderBy','ItemType.OrderBy','getAdditionalPhones','duplicateAdditionalPhones','fromContactId','CmContactId','toContactId','rescheduleAdditionalPhones','hopperId','getHoppers','includeAll','include','rows','getHopperHistories','ContactId','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','split','Incorrect\x20binding\x20parameters\x20passed!','No\x20phone\x20column\x20specified','firstName','server/files/tmp','filename','chmodSync','0777','child_process','fork','../../components/import/cm/csv','CompanyId','File\x20uploaded\x20correctly!','pid','upload','createReadStream','file','parse','import','agent','binding','No\x20firstName\x20column\x20specified','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','exit','error\x20child\x20process','../../components/import/cm/csvUpdates','mail','chat','sms','openchannel','fax','-createdAt','resolve','channel','includes','toLowerCase','Invalid\x20channel','range','isValid','Invalid\x20date\x20for\x20range\x20to\x20filter','Invalid\x20createdAt\x20filter','uniqueid','source','destination','callerid','starttime','endtime','duration','userThirdDisposition','UserId','User','createdAt','DESC','findAndCountAll','startCase','Account','closed','closedAt','note','disposition','thirdDisposition','key','Owner','fullname','browserName','customerIp','customerPort','deviceModel','osName','ratingMessage','ratingType','ratingValue','subject','substatus','externalUrl','threadId','Interaction','flatten','sortBy','reverse','value','moment','bluebird','util','lodash','squel','papaparse','ioredis','../../components/contacts','../../components/parsers/qs','../../config/logger','api','../../config/environment','../../config/environment/shared','redis','localhost','socket.io-emitter','./cmContact.socket','status','json','offset','limit','undefined','count','Content-Range'];(function(_0x160434,_0xc59a7f){var _0x323683=function(_0x202646){while(--_0x202646){_0x160434['push'](_0x160434['shift']());}};_0x323683(++_0xc59a7f);}(_0x0f67,0xf1));var _0x70f6=function(_0x2a34ec,_0x5a9e67){_0x2a34ec=_0x2a34ec-0x0;var _0x2cf324=_0x0f67[_0x2a34ec];return _0x2cf324;};'use strict';var moment=require(_0x70f6('0x0'));var BPromise=require(_0x70f6('0x1'));var util=require(_0x70f6('0x2'));var path=require('path');var fs=require('fs');var _=require(_0x70f6('0x3'));var squel=require(_0x70f6('0x4'));var Papa=require(_0x70f6('0x5'));var Redis=require(_0x70f6('0x6'));var contacts=require(_0x70f6('0x7'));var qs=require(_0x70f6('0x8'));var logger=require(_0x70f6('0x9'))(_0x70f6('0xa'));var config=require(_0x70f6('0xb'));var shared=require(_0x70f6('0xc'));var db=require('../../mysqldb')['db'];config[_0x70f6('0xd')]=_['defaults'](config[_0x70f6('0xd')],{'host':_0x70f6('0xe'),'port':0x18eb});var socket=require(_0x70f6('0xf'))(new Redis(config[_0x70f6('0xd')]));require(_0x70f6('0x10'))['register'](socket);function respondWithResult(_0x1fabdb,_0x5a91b7){_0x5a91b7=_0x5a91b7||0xc8;return function(_0x425ea7){if(_0x425ea7){return _0x1fabdb[_0x70f6('0x11')](_0x5a91b7)[_0x70f6('0x12')](_0x425ea7);}};}function respondWithFilteredResult(_0x5d3594,_0xd1873c){return function(_0x2b3240){if(_0x2b3240){var _0xf98c46=typeof _0xd1873c[_0x70f6('0x13')]==='undefined'&&typeof _0xd1873c[_0x70f6('0x14')]===_0x70f6('0x15');var _0x1919d1=_0x2b3240[_0x70f6('0x16')];var _0x106888=_0xf98c46?0x0:_0xd1873c['offset'];var _0x3bbaf3=_0xf98c46?_0x2b3240[_0x70f6('0x16')]:_0xd1873c['offset']+_0xd1873c[_0x70f6('0x14')];var _0x3f58d0;if(_0x3bbaf3>=_0x1919d1){_0x3bbaf3=_0x1919d1;_0x3f58d0=0xc8;}else{_0x3f58d0=0xce;}_0x5d3594['status'](_0x3f58d0);return _0x5d3594['set'](_0x70f6('0x17'),_0x106888+'-'+_0x3bbaf3+'/'+_0x1919d1)['json'](_0x2b3240);}return null;};}function saveUpdates(_0xfde511){return function(_0x485636){if(_0x485636){return _0x485636[_0x70f6('0x18')](_0xfde511)[_0x70f6('0x19')](function(_0x2784a3){return _0x2784a3;});}return null;};}function removeEntity(_0x13255d){return function(_0x2bbebd){if(_0x2bbebd){return _0x2bbebd['destroy']()[_0x70f6('0x19')](function(){_0x13255d[_0x70f6('0x11')](0xcc)[_0x70f6('0x1a')]();});}};}function handleEntityNotFound(_0x1f9620){return function(_0xcb6233){if(!_0xcb6233){_0x1f9620[_0x70f6('0x1b')](0x194);}return _0xcb6233;};}function handleError(_0x1520af,_0x8a98f){_0x8a98f=_0x8a98f||0x1f4;return function(_0x150632){logger[_0x70f6('0x1c')](_0x150632[_0x70f6('0x1d')]);if(_0x150632[_0x70f6('0x1e')]){delete _0x150632[_0x70f6('0x1e')];}_0x1520af[_0x70f6('0x11')](_0x8a98f)[_0x70f6('0x1f')](_0x150632);};}exports[_0x70f6('0x20')]=function(_0x58811c,_0x12defe){var _0x53c091={};return contacts[_0x70f6('0x21')]()[_0x70f6('0x19')](function(_0x3d35a4){_0x53c091=qs[_0x70f6('0x22')](_0x3d35a4,_0x58811c);return contacts['findAll'](_0x58811c[_0x70f6('0x23')],_0x58811c[_0x70f6('0x24')],_0x53c091,_0x3d35a4);})[_0x70f6('0x19')](respondWithFilteredResult(_0x12defe,_0x53c091))[_0x70f6('0x25')](handleError(_0x12defe,null));};exports[_0x70f6('0x26')]=function(_0x5cb283,_0x3311ec){return db[_0x70f6('0x27')][_0x70f6('0x28')]({'where':{'id':_0x5cb283[_0x70f6('0x29')]['id']}})[_0x70f6('0x19')](handleEntityNotFound(_0x3311ec,null))[_0x70f6('0x19')](removeEntity(_0x3311ec,null))[_0x70f6('0x25')](handleError(_0x3311ec,null));};exports[_0x70f6('0x21')]=function(_0x442656,_0x5cef16){return db[_0x70f6('0x27')][_0x70f6('0x21')]()[_0x70f6('0x19')](function(_0x2214d3){delete _0x2214d3[_0x70f6('0x2a')];for(var _0x76c57c=0x0;_0x76c57c<Object[_0x70f6('0x2b')](_0x2214d3)[_0x70f6('0x2c')];_0x76c57c++){var _0x4a3971=Object[_0x70f6('0x2b')](_0x2214d3)[_0x76c57c];if(!_['startsWith'](_0x4a3971,_0x70f6('0x2d'))){_0x2214d3[_0x4a3971][_0x70f6('0x2e')]=_0x4a3971;_0x2214d3[_0x4a3971][_0x70f6('0x2f')]=_0x4a3971;}}return _0x2214d3;})[_0x70f6('0x19')](function(_0x158549){var _0x3c880a={'where':Boolean(_0x442656[_0x70f6('0x23')][_0x70f6('0x30')])===!![]?undefined:{'$or':[{'ListId':_0x442656['query']['id']},{'ListId':null}]},'raw':!![]};return db[_0x70f6('0x31')][_0x70f6('0x32')](_0x3c880a)['then'](function(_0x2b15a8){for(var _0x51ae1e=0x0;_0x51ae1e<_0x2b15a8[_0x70f6('0x2c')];_0x51ae1e++){var _0x2367ea=_0x70f6('0x2d')+_0x2b15a8[_0x51ae1e]['id'];if(_0x158549[_0x2367ea]){_0x158549[_0x2367ea]['columnName']=_0x2367ea;_0x158549[_0x2367ea]['displayName']=_0x2b15a8[_0x51ae1e][_0x70f6('0x33')];_0x158549[_0x2367ea][_0x70f6('0x34')]={'type':_0x2b15a8[_0x51ae1e]['type'],'values':_0x2b15a8[_0x51ae1e]['values']};}else{logger[_0x70f6('0x35')](_0x70f6('0x36'),_0x2367ea);}}Object[_0x70f6('0x2b')](_0x158549)['forEach'](function(_0x28e47f){if(!_0x158549[_0x28e47f]['hasOwnProperty']('columnName')){delete _0x158549[_0x28e47f];}});return _0x158549;});})[_0x70f6('0x19')](respondWithResult(_0x5cef16,null))[_0x70f6('0x25')](handleError(_0x5cef16,null));};exports[_0x70f6('0x37')]=function(_0x38102a,_0x324bb0){var _0x35b8b2;var _0x14d29b;var _0x1c99db;if(_0x38102a[_0x70f6('0x38')]['id']){delete _0x38102a[_0x70f6('0x38')]['id'];}return db[_0x70f6('0x27')][_0x70f6('0x32')]({'where':{'id':[_0x38102a['body']['to'],_0x38102a['body'][_0x70f6('0x39')]]}})[_0x70f6('0x19')](function(_0x3b54a3){if(_0x3b54a3){if(_0x3b54a3['length']!==0x2){return null;}_0x3b54a3[0x0]=_0x3b54a3[0x0][_0x70f6('0x3a')]({'plain':!![]});_0x3b54a3[0x1]=_0x3b54a3[0x1]['get']({'plain':!![]});delete _0x3b54a3[0x0]['id'];delete _0x3b54a3[0x1]['id'];return _[_0x70f6('0x3b')](_0x3b54a3[0x0],_0x3b54a3[0x1],function(_0x470e4d,_0x5297a4){if(Array[_0x70f6('0x3c')](_0x5297a4)&&!_0x5297a4[_0x70f6('0x2c')]){return _0x470e4d;}else if(!_0x5297a4){return _0x470e4d;}});}})[_0x70f6('0x19')](handleEntityNotFound(_0x324bb0,null))[_0x70f6('0x19')](function(_0x19e699){if(_0x19e699){if(_0x19e699[_0x70f6('0x2a')]&&_[_0x70f6('0x3c')](_0x19e699['tags'])){_0x19e699[_0x70f6('0x2a')]=_0x19e699[_0x70f6('0x2a')][_0x70f6('0x3d')]();}logger['info'](_0x70f6('0x3e'),_0x38102a[_0x70f6('0x38')]['to'],_0x38102a['body'][_0x70f6('0x39')]);return db[_0x70f6('0x3f')][_0x70f6('0x26')]({'where':{'ContactId':[_0x38102a[_0x70f6('0x38')]['to'],_0x38102a[_0x70f6('0x38')][_0x70f6('0x39')]]}})[_0x70f6('0x19')](function(_0x50e581){logger['info'](_0x70f6('0x40'),_0x50e581);return db[_0x70f6('0x41')][_0x70f6('0x26')]({'where':{'ContactId':[_0x38102a[_0x70f6('0x38')]['to'],_0x38102a[_0x70f6('0x38')][_0x70f6('0x39')]]}})['then'](function(_0xa7e412){logger[_0x70f6('0x35')](_0x70f6('0x42'),_0xa7e412);return db['CmContact'][_0x70f6('0x43')](_0x19e699);});});}})[_0x70f6('0x19')](function(_0x8edbc7){if(_0x8edbc7){_0x35b8b2=_0x8edbc7;_0x14d29b={'ContactId':_0x35b8b2['id']};_0x1c99db={'where':{'ContactId':[_0x38102a['body']['to'],_0x38102a[_0x70f6('0x38')][_0x70f6('0x39')]]}};return db[_0x70f6('0x44')]['update'](_0x14d29b,_0x1c99db);}})[_0x70f6('0x19')](function(){if(_0x35b8b2){return db[_0x70f6('0x45')][_0x70f6('0x18')](_0x14d29b,_0x1c99db);}})['then'](function(){if(_0x35b8b2){return db[_0x70f6('0x46')][_0x70f6('0x18')](_0x14d29b,_0x1c99db);}})[_0x70f6('0x19')](function(){if(_0x35b8b2){return db[_0x70f6('0x47')][_0x70f6('0x18')](_0x14d29b,_0x1c99db);}})[_0x70f6('0x19')](function(){if(_0x35b8b2){return db[_0x70f6('0x48')][_0x70f6('0x18')](_0x14d29b,_0x1c99db);}})[_0x70f6('0x19')](function(){if(_0x35b8b2){return db[_0x70f6('0x47')]['update'](_0x14d29b,_0x1c99db);}})['then'](function(){if(_0x35b8b2){return db['MailMessage'][_0x70f6('0x18')](_0x14d29b,_0x1c99db);}})[_0x70f6('0x19')](function(){if(_0x35b8b2){return db['SmsInteraction'][_0x70f6('0x18')](_0x14d29b,_0x1c99db);}})[_0x70f6('0x19')](function(){if(_0x35b8b2){return db[_0x70f6('0x49')]['update'](_0x14d29b,_0x1c99db);}})['then'](function(){if(_0x35b8b2){return db[_0x70f6('0x4a')][_0x70f6('0x18')](_0x14d29b,_0x1c99db);}})['then'](function(){if(_0x35b8b2){return db[_0x70f6('0x4b')][_0x70f6('0x18')](_0x14d29b,_0x1c99db);}})[_0x70f6('0x19')](function(){if(_0x35b8b2){return db['OpenchannelInteraction']['update'](_0x14d29b,_0x1c99db);}})[_0x70f6('0x19')](function(){if(_0x35b8b2){return db[_0x70f6('0x4c')][_0x70f6('0x18')](_0x14d29b,_0x1c99db);}})[_0x70f6('0x19')](function(){if(_0x35b8b2){return db['CmContactHasItem'][_0x70f6('0x18')]({'CmContactId':_0x35b8b2['id']},{'where':{'CmContactId':[_0x38102a[_0x70f6('0x38')]['to'],_0x38102a[_0x70f6('0x38')][_0x70f6('0x39')]]}});}})[_0x70f6('0x19')](function(){if(_0x35b8b2){return db[_0x70f6('0x4d')][_0x70f6('0x18')](_0x14d29b,_0x1c99db);}})['then'](function(){if(_0x35b8b2){return db[_0x70f6('0x4e')]['update'](_0x14d29b,_0x1c99db);}})[_0x70f6('0x19')](function(){if(_0x35b8b2){return db[_0x70f6('0x4f')][_0x70f6('0x18')](_0x14d29b,_0x1c99db);}})[_0x70f6('0x19')](function(){if(_0x35b8b2){return db[_0x70f6('0x50')][_0x70f6('0x18')](_0x14d29b,_0x1c99db);}})[_0x70f6('0x19')](function(){if(_0x35b8b2){return db[_0x70f6('0x51')][_0x70f6('0x18')](_0x14d29b,_0x1c99db);}})[_0x70f6('0x19')](function(){if(_0x35b8b2){return db[_0x70f6('0x52')][_0x70f6('0x18')](_0x14d29b,_0x1c99db);}})['then'](function(){if(_0x35b8b2){return db[_0x70f6('0x53')][_0x70f6('0x18')](_0x14d29b,_0x1c99db);}})[_0x70f6('0x19')](function(){if(_0x35b8b2){return db[_0x70f6('0x54')][_0x70f6('0x18')](_0x14d29b,_0x1c99db);}})[_0x70f6('0x19')](function(){if(_0x35b8b2){return db[_0x70f6('0x55')]['update'](_0x14d29b,_0x1c99db);}})[_0x70f6('0x19')](function(){if(_0x35b8b2){return db[_0x70f6('0x56')][_0x70f6('0x18')](_0x14d29b,_0x1c99db);}})[_0x70f6('0x19')](function(){if(_0x35b8b2){return db[_0x70f6('0x57')][_0x70f6('0x18')](_0x14d29b,_0x1c99db);}})[_0x70f6('0x19')](function(){if(_0x35b8b2){return db[_0x70f6('0x58')][_0x70f6('0x18')](_0x14d29b,_0x1c99db);}})['then'](function(){if(_0x35b8b2){return db[_0x70f6('0x59')]['update'](_0x14d29b,_0x1c99db);}})[_0x70f6('0x19')](function(){if(_0x35b8b2){return db[_0x70f6('0x27')][_0x70f6('0x26')]({'where':{'id':[_0x38102a[_0x70f6('0x38')]['to'],_0x38102a[_0x70f6('0x38')][_0x70f6('0x39')]]}});}})['then'](function(){if(_0x35b8b2){return _0x35b8b2;}})[_0x70f6('0x19')](respondWithResult(_0x324bb0,null))['catch'](handleError(_0x324bb0,null));};exports['create']=function(_0x44ed83,_0x3d3412){return db[_0x70f6('0x27')]['describe']()[_0x70f6('0x19')](function(_0x14d6c4){if(_0x44ed83[_0x70f6('0x38')][_0x70f6('0x2a')]&&_[_0x70f6('0x3c')](_0x44ed83[_0x70f6('0x38')][_0x70f6('0x2a')])){if(_0x44ed83[_0x70f6('0x38')]['tags'][_0x70f6('0x2c')]){_0x44ed83['body']['tags']=_0x44ed83[_0x70f6('0x38')][_0x70f6('0x2a')][_0x70f6('0x3d')](';')+';';}else{_0x44ed83[_0x70f6('0x38')]['tags']=null;}}else{_0x44ed83[_0x70f6('0x38')][_0x70f6('0x2a')]=null;}if(!_['isNil'](_0x44ed83[_0x70f6('0x38')][_0x70f6('0x5a')])){var _0xb14279=_0x44ed83['body']['dialTimezone'];if(!_[_0x70f6('0x5b')](shared[_0x70f6('0x5c')][_0xb14279]))_0x44ed83['body']['utcOffset']=shared[_0x70f6('0x5c')][_0xb14279][_0x70f6('0x5d')];}return db[_0x70f6('0x27')][_0x70f6('0x43')](_0x44ed83[_0x70f6('0x38')],{'fields':_[_0x70f6('0x2b')](_0x14d6c4),'raw':!![]});})['then'](function(_0x212bcc){if(_0x44ed83[_0x70f6('0x38')][_0x70f6('0x5e')]){return insertAdditionalPhones(_0x212bcc,_0x44ed83['body'][_0x70f6('0x5e')]);}else{return _0x212bcc;}})[_0x70f6('0x19')](respondWithResult(_0x3d3412,0xc9))['catch'](handleError(_0x3d3412,null));};exports[_0x70f6('0x5f')]=function(_0x463c81,_0x288dc4){var _0x4738d0=0x0;var _0x123f39=0x0;var _0x5047eb=0x0;var _0x37573e=[];return db['CmContact'][_0x70f6('0x21')]()['then'](function(_0x22d062){return BPromise[_0x70f6('0x60')](_0x463c81[_0x70f6('0x38')],function(_0x16b594){var _0x20280a={'where':{'$or':[]},'defaults':_0x16b594,'fields':_[_0x70f6('0x2b')](_0x22d062),'raw':!![]};if(_0x16b594[_0x70f6('0x61')]){for(var _0x47a8f0=0x0;_0x47a8f0<_0x16b594[_0x70f6('0x61')][_0x70f6('0x2c')];_0x47a8f0++){var _0x26c3b6={};_0x26c3b6[_0x16b594[_0x70f6('0x61')][_0x47a8f0]]=_0x16b594[_0x16b594['duplicates'][_0x47a8f0]];_0x20280a[_0x70f6('0x62')][_0x70f6('0x63')]['push'](_0x26c3b6);}_0x20280a[_0x70f6('0x62')]['ListId']=_0x16b594[_0x70f6('0x64')];}return db[_0x70f6('0x27')][_0x70f6('0x65')](_0x20280a)[_0x70f6('0x66')](function(_0x24cb2c,_0x5f05f6){if(_0x5f05f6){if(_0x16b594[_0x70f6('0x67')]('additionalPhones')){_0x37573e[_0x70f6('0x68')]({'contact':_0x24cb2c,'additionalPhones':_0x16b594[_0x70f6('0x5e')]});}_0x4738d0++;}else{_0x5047eb++;}})[_0x70f6('0x25')](function(){_0x123f39++;});});})[_0x70f6('0x19')](function(_0x243d49){if(_0x243d49){if(_0x37573e[_0x70f6('0x2c')]>0x0){return new Promise(function(_0x6e677b){var _0x3c014b=[];for(var _0x230c8f=0x0;_0x230c8f<_0x37573e[_0x70f6('0x2c')];_0x230c8f++){_0x3c014b[_0x70f6('0x68')](insertAdditionalPhones(_0x37573e[_0x230c8f][_0x70f6('0x69')],_0x37573e[_0x230c8f][_0x70f6('0x5e')]));}Promise[_0x70f6('0x6a')](_0x3c014b)[_0x70f6('0x19')](function(){_0x6e677b(0x1);});})[_0x70f6('0x19')](function(){return{'success':_0x4738d0,'failure':_0x123f39,'duplicates':_0x5047eb};});}else{return{'success':_0x4738d0,'failure':_0x123f39,'duplicates':_0x5047eb};}}})[_0x70f6('0x19')](respondWithResult(_0x288dc4,0xc9))[_0x70f6('0x25')](handleError(_0x288dc4,null));};exports['show']=function(_0x3401bf,_0x4e9793){var _0x299d84;return db[_0x70f6('0x27')][_0x70f6('0x21')]()[_0x70f6('0x19')](function(_0xce035c){return db['CmContact'][_0x70f6('0x28')]({'where':{'id':_0x3401bf['params']['id']},'include':[{'model':db[_0x70f6('0x6b')],'as':_0x70f6('0x6c'),'attributes':['id','name',_0x70f6('0x6d')],'required':_0x3401bf[_0x70f6('0x23')][_0x70f6('0x6e')]?!![]:![]},{'model':db[_0x70f6('0x6f')],'as':_0x70f6('0x70'),'where':{'CmContactId':_0x3401bf[_0x70f6('0x29')]['id']},'required':![],'include':[{'model':db['ContactItemType'],'as':_0x70f6('0x71')}]}],'order':[db[_0x70f6('0x72')][_0x70f6('0x73')]('Phones.OrderBy')],'attributes':_['keys'](_0xce035c)});})[_0x70f6('0x19')](function(_0xd9a462){if(!_[_0x70f6('0x5b')](_0xd9a462)){_0x299d84=_0xd9a462[_0x70f6('0x3a')]({'plain':!![]});var _0x5a2856={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0xd9a462&&_0xd9a462[_0x70f6('0x64')]){if(_0xd9a462[_0x70f6('0x64')]){_0x5a2856[_0x70f6('0x62')][_0x70f6('0x74')][_0x70f6('0x68')]({'ListId':{'$ne':_0xd9a462[_0x70f6('0x64')]}});}}return db[_0x70f6('0x31')]['findAll'](_0x5a2856);}})['then'](function(_0x5eed5a){if(!_[_0x70f6('0x5b')](_0x5eed5a)){return _[_0x70f6('0x75')](_0x299d84,_[_0x70f6('0x76')](_0x5eed5a,function(_0x452a63){return util[_0x70f6('0x77')]('cf_%d',_0x452a63['id']);}));}})[_0x70f6('0x19')](handleEntityNotFound(_0x4e9793,null))[_0x70f6('0x19')](respondWithResult(_0x4e9793,null))['catch'](handleError(_0x4e9793,null));};exports['update']=function(_0x31d1c0,_0x4d6193){var _0x49a860;if(_0x31d1c0[_0x70f6('0x38')]['id']){delete _0x31d1c0[_0x70f6('0x38')]['id'];}if(!_[_0x70f6('0x5b')](_0x31d1c0['body'][_0x70f6('0x5a')])){var _0x1e999b=_0x31d1c0[_0x70f6('0x38')][_0x70f6('0x5a')];if(!_[_0x70f6('0x5b')](shared['timezones'][_0x1e999b]))_0x31d1c0[_0x70f6('0x38')][_0x70f6('0x5d')]=shared[_0x70f6('0x5c')][_0x1e999b][_0x70f6('0x5d')];}return db[_0x70f6('0x27')][_0x70f6('0x28')]({'where':{'id':_0x31d1c0[_0x70f6('0x29')]['id']}})[_0x70f6('0x19')](handleEntityNotFound(_0x4d6193,null))[_0x70f6('0x19')](saveUpdates(_0x31d1c0[_0x70f6('0x38')],null))['then'](function(_0x50418b){_0x49a860=_0x50418b;var _0x279aa0={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x50418b&&_0x50418b['ListId']){if(_0x50418b[_0x70f6('0x64')]){_0x279aa0[_0x70f6('0x62')][_0x70f6('0x74')][_0x70f6('0x68')]({'ListId':{'$ne':_0x50418b[_0x70f6('0x64')]}});}}return db[_0x70f6('0x31')][_0x70f6('0x32')](_0x279aa0);})[_0x70f6('0x19')](function(_0x1dcdc0){if(_0x1dcdc0){return _[_0x70f6('0x75')](_[_0x70f6('0x78')](_0x31d1c0[_0x70f6('0x38')],function(_0xa70abf,_0x931dc5){return _['startsWith'](_0x931dc5,_0x70f6('0x2d'));}),_[_0x70f6('0x76')](_0x1dcdc0,function(_0xd3ba06){return util[_0x70f6('0x77')](_0x70f6('0x79'),_0xd3ba06['id']);}));}})[_0x70f6('0x19')](function(_0x28248b){if(_0x28248b&&!_[_0x70f6('0x7a')](_0x28248b)){var _0x2f606b=squel[_0x70f6('0x18')]()[_0x70f6('0x7b')]('cm_contacts')[_0x70f6('0x7c')](_0x28248b)[_0x70f6('0x62')](_0x70f6('0x7d'),_0x31d1c0[_0x70f6('0x29')]['id'])[_0x70f6('0x7e')]();return db[_0x70f6('0x72')][_0x70f6('0x23')](_0x2f606b[_0x70f6('0x7f')],{'replacements':_0x2f606b[_0x70f6('0x80')]});}})['then'](function(){if(_0x31d1c0[_0x70f6('0x38')][_0x70f6('0x81')]&&_0x49a860){return db[_0x70f6('0x3f')][_0x70f6('0x18')]({'phone':_0x31d1c0[_0x70f6('0x38')][_0x70f6('0x81')],'OrderBy':0x0},{'where':{'ContactId':_0x49a860['id']}});}})[_0x70f6('0x19')](function(){return _0x49a860;})[_0x70f6('0x19')](respondWithResult(_0x4d6193,null))[_0x70f6('0x25')](handleError(_0x4d6193,null));};exports[_0x70f6('0x82')]=function(_0x33258f,_0xecbcce){var _0x21c6ea={};var _0x49a79b={};var _0x262c22;var _0x345540;return db[_0x70f6('0x27')][_0x70f6('0x83')]({'where':{'id':_0x33258f[_0x70f6('0x29')]['id']}})[_0x70f6('0x19')](handleEntityNotFound(_0xecbcce,null))[_0x70f6('0x19')](function(_0xc11c14){if(_0xc11c14){_0x262c22=_0xc11c14;_0x49a79b[_0x70f6('0x84')]=_[_0x70f6('0x2b')](db['Tag'][_0x70f6('0x85')]);_0x49a79b[_0x70f6('0x23')]=_[_0x70f6('0x2b')](_0x33258f[_0x70f6('0x23')]);_0x49a79b['filters']=_[_0x70f6('0x86')](_0x49a79b[_0x70f6('0x84')],_0x49a79b['query']);_0x21c6ea['attributes']=_[_0x70f6('0x86')](_0x49a79b[_0x70f6('0x84')],qs['fields'](_0x33258f[_0x70f6('0x23')][_0x70f6('0x87')]));_0x21c6ea[_0x70f6('0x88')]=_0x21c6ea[_0x70f6('0x88')][_0x70f6('0x2c')]?_0x21c6ea[_0x70f6('0x88')]:_0x49a79b[_0x70f6('0x84')];_0x21c6ea[_0x70f6('0x89')]=qs['sort'](_0x33258f[_0x70f6('0x23')][_0x70f6('0x8a')]);_0x21c6ea['where']=qs[_0x70f6('0x8b')](_[_0x70f6('0x8c')](_0x33258f[_0x70f6('0x23')],_0x49a79b[_0x70f6('0x8b')]));if(_0x33258f['query'][_0x70f6('0x8d')]){_0x21c6ea[_0x70f6('0x62')]=_[_0x70f6('0x37')](_0x21c6ea[_0x70f6('0x62')],{'$or':_[_0x70f6('0x76')](_0x21c6ea[_0x70f6('0x88')],function(_0x2767d0){var _0x19f543={};_0x19f543[_0x2767d0]={'$like':'%'+_0x33258f[_0x70f6('0x23')][_0x70f6('0x8d')]+'%'};return _0x19f543;})});}_0x21c6ea=_[_0x70f6('0x37')]({},_0x21c6ea,_0x33258f[_0x70f6('0x8e')]);return _0x262c22[_0x70f6('0x82')](_0x21c6ea);}})[_0x70f6('0x19')](function(_0x314b32){if(_0x314b32){_0x345540=_0x314b32[_0x70f6('0x2c')];if(!_0x33258f[_0x70f6('0x23')][_0x70f6('0x67')](_0x70f6('0x8f'))){_0x21c6ea[_0x70f6('0x14')]=qs[_0x70f6('0x14')](_0x33258f[_0x70f6('0x23')][_0x70f6('0x14')]);_0x21c6ea[_0x70f6('0x13')]=qs[_0x70f6('0x13')](_0x33258f[_0x70f6('0x23')][_0x70f6('0x13')]);}return _0x262c22[_0x70f6('0x82')](_0x21c6ea);}})[_0x70f6('0x19')](function(_0x5c53e5){if(_0x5c53e5){return _0x5c53e5?{'count':_0x345540,'rows':_0x5c53e5}:null;}})['then'](respondWithResult(_0xecbcce,null))['catch'](handleError(_0xecbcce,null));};exports[_0x70f6('0x90')]=function(_0x1641b8,_0x31b6e7){if(_0x1641b8['body']['id']){delete _0x1641b8[_0x70f6('0x38')]['id'];}return db[_0x70f6('0x27')][_0x70f6('0x83')]({'where':{'id':_0x1641b8[_0x70f6('0x29')]['id']}})['then'](handleEntityNotFound(_0x31b6e7,null))[_0x70f6('0x19')](function(_0x4357d5){if(_0x4357d5){return _0x4357d5[_0x70f6('0x90')](_0x1641b8[_0x70f6('0x38')][_0x70f6('0x91')]||[]);}return null;})[_0x70f6('0x19')](respondWithResult(_0x31b6e7,null))[_0x70f6('0x25')](handleError(_0x31b6e7,null));};exports[_0x70f6('0x92')]=function(_0xc78547,_0x17a7b6){var _0x578586=[];_0x578586[_0x70f6('0x68')](addAdditionalPhones(_0xc78547[_0x70f6('0x38')]));Promise['all'](_0x578586)[_0x70f6('0x19')](function(){_0x578586=[];_0x578586['push'](deleteCmHopperPhones(_0xc78547[_0x70f6('0x38')]['id']));_0x578586[_0x70f6('0x68')](addCmHopperPhones(_0xc78547[_0x70f6('0x38')]['id']));Promise[_0x70f6('0x6a')](_0x578586)[_0x70f6('0x19')](function(){return[0x1];})['then'](respondWithResult(_0x17a7b6,null));});};function addAdditionalPhones(_0x4e627d){var _0x56c7aa;return new Promise(function(_0x30bd3a){return db[_0x70f6('0x6f')][_0x70f6('0x26')]({'where':{'CmContactId':_0x4e627d['id']}})[_0x70f6('0x19')](function(){db[_0x70f6('0x93')][_0x70f6('0x32')]({'raw':!![],'attributes':['id',_0x70f6('0x94')]})[_0x70f6('0x19')](function(_0x530955){var _0x313cfb=[];for(var _0x1ce6b8=0x0;_0x1ce6b8<_0x4e627d[_0x70f6('0x95')][_0x70f6('0x2c')];_0x1ce6b8++){var _0x4e2346=_0x4e627d['item_types']?_[_0x70f6('0x5b')](_0x4e627d[_0x70f6('0x96')][_0x1ce6b8])?'':_0x4e627d[_0x70f6('0x96')][_0x1ce6b8]:_0x4e627d[_0x70f6('0x95')][_0x1ce6b8]['ItemTypeId']?_0x4e627d[_0x70f6('0x95')][_0x1ce6b8][_0x70f6('0x97')]:'';var _0x51bd4c=_[_0x70f6('0x5b')](_0x4e627d[_0x70f6('0x95')][_0x1ce6b8][_0x70f6('0x98')])?'':_0x4e627d[_0x70f6('0x95')][_0x1ce6b8][_0x70f6('0x98')];var _0x229900=_0x4e2346+':'+_0x4e627d[_0x70f6('0x95')][_0x1ce6b8]['phone']+'§'+_0x51bd4c;if(_['isNil'](_0x56c7aa))_0x56c7aa=_0x229900;else _0x56c7aa+=';'+_0x229900;var _0x1c4f28=null;var _0x29f2c0=null;if(_0x4e627d[_0x70f6('0x96')]){if(!_[_0x70f6('0x5b')](_0x4e627d[_0x70f6('0x96')][_0x1ce6b8])){_0x29f2c0=_[_0x70f6('0x28')](_0x530955,function(_0x3a7557){return _0x3a7557['id']===_0x4e627d[_0x70f6('0x96')][_0x1ce6b8];});if(!_[_0x70f6('0x5b')](_0x29f2c0)){_0x1c4f28=_0x29f2c0[_0x70f6('0x94')];}}}else{if(!_[_0x70f6('0x5b')](_0x4e627d[_0x70f6('0x95')][_0x1ce6b8])){_0x29f2c0=_[_0x70f6('0x28')](_0x530955,function(_0x187e9e){return _0x187e9e['id']===_0x4e627d[_0x70f6('0x95')][_0x1ce6b8][_0x70f6('0x97')];});if(!_[_0x70f6('0x5b')](_0x29f2c0)){_0x1c4f28=_0x1ce6b8;}}}if(_[_0x70f6('0x5b')](_0x1c4f28)){_0x1c4f28=0x64;}_0x313cfb[_0x70f6('0x68')](addAdditionalPhone(_0x4e627d['id'],_0x4e627d[_0x70f6('0x95')][_0x1ce6b8]['phone'],_0x4e627d['item_types']?_[_0x70f6('0x5b')](_0x4e627d[_0x70f6('0x96')][_0x1ce6b8])?null:_0x4e627d['item_types'][_0x1ce6b8]:_0x4e627d['items'][_0x1ce6b8]['ItemTypeId']?_0x4e627d['items'][_0x1ce6b8][_0x70f6('0x97')]:null,_0x1c4f28,_0x51bd4c));}Promise[_0x70f6('0x6a')](_0x313cfb)[_0x70f6('0x19')](function(){db[_0x70f6('0x27')]['update']({'AdditionalPhones':_0x56c7aa},{'where':{'id':_0x4e627d['id']}})[_0x70f6('0x19')](function(){_0x30bd3a(0x1);});});});});});}function addAdditionalPhone(_0x35ab12,_0x72f25f,_0x3d320d,_0x467a6b,_0x263032){return db[_0x70f6('0x6f')]['find']({'where':{'CmContactId':_0x35ab12,'item':_0x72f25f}})[_0x70f6('0x19')](function(_0x35b9db){if(_0x35b9db)logger['info'](_0x70f6('0x99'),_0x35b9db);else{db[_0x70f6('0x6f')][_0x70f6('0x43')]({'CmContactId':_0x35ab12,'item':_0x72f25f,'ItemTypeId':_0x3d320d,'OrderBy':_0x467a6b,'ItemClass':'PHONE','description':_0x263032});}});}function deleteCmHopperPhones(_0x3399f4){return new Promise(function(_0x8f2a54){return db['CmHopper']['findAll']({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x3399f4}})[_0x70f6('0x19')](function(_0x531b16){db[_0x70f6('0x9a')][_0x70f6('0x26')]({'where':{'CmHopperId':{'$in':_[_0x70f6('0x76')](_0x531b16,'id')}}});})['then'](function(){_0x8f2a54(0x1);});});}function addCmHopperPhones(_0x2d7a31){return new Promise(function(_0x4ab359){return db['CmHopper'][_0x70f6('0x32')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x2d7a31}})['then'](function(_0x1e43dd){var _0x777f61=[];_[_0x70f6('0x76')](_0x1e43dd,function(_0xb7fe89){_0x777f61[_0x70f6('0x68')](createCmHopperPhone(_0x2d7a31,_0xb7fe89['id']));});Promise[_0x70f6('0x6a')](_0x777f61)[_0x70f6('0x19')](function(){_0x4ab359(0x1);});});});}function createCmHopperPhone(_0x30298c,_0x236a5e){return new Promise(function(_0x1f84e8){db[_0x70f6('0x6f')]['findAll']({'raw':!![],'attributes':[_0x70f6('0x9b'),'OrderBy'],'where':{'CmContactId':_0x30298c,'ItemClass':_0x70f6('0x9c')},'include':[{'model':db[_0x70f6('0x93')],'attributes':[_0x70f6('0x94')],'as':'ItemType'}],'order':['OrderBy',db[_0x70f6('0x72')][_0x70f6('0x73')](_0x70f6('0x9d'))]})['then'](function(_0x30f10e){var _0x1f9d03=0x1;var _0x134fe8=_[_0x70f6('0x76')](_0x30f10e,function(_0x1622b6){_0x1622b6['CmHopperId']=_0x236a5e;_0x1622b6[_0x70f6('0x81')]=_0x1622b6[_0x70f6('0x9b')];_0x1622b6[_0x70f6('0x94')]=_0x1f9d03;delete _0x1622b6[_0x70f6('0x9e')];_0x1f9d03=_0x1f9d03+0x1;return _0x1622b6;});return db['CmHopperAdditionalPhone'][_0x70f6('0x5f')](_0x134fe8,{});})[_0x70f6('0x19')](function(){_0x1f84e8(0x1);});});}function insertAdditionalPhones(_0x5549bd,_0x3846f4){return new Promise(function(_0x44a8f8){var _0x1bc9fd=[];for(var _0x57f235=0x0;_0x57f235<_0x3846f4[_0x70f6('0x2c')];_0x57f235++){var _0x243777=_0x3846f4[_0x57f235];_0x1bc9fd['push'](parseContactItemType(_0x243777));}Promise[_0x70f6('0x6a')](_0x1bc9fd)['then'](function(){var _0x440f73={'id':_0x5549bd['id'],'items':_0x3846f4};return addAdditionalPhones(_0x440f73)[_0x70f6('0x19')](function(){return addCmHopperPhones(_0x5549bd['id']);});})[_0x70f6('0x19')](function(){_0x44a8f8(_0x5549bd);});});}function parseContactItemType(_0x12a292){return new Promise(function(_0x14f86b){if(_0x12a292[_0x70f6('0x67')](_0x70f6('0x97'))){_0x14f86b(_0x12a292);}else{return db[_0x70f6('0x93')][_0x70f6('0x28')]({'where':{'name':_0x12a292[_0x70f6('0x71')]}})[_0x70f6('0x19')](function(_0x461608){if(_[_0x70f6('0x5b')](_0x461608))_0x12a292[_0x70f6('0x97')]=null;else _0x12a292[_0x70f6('0x97')]=_0x461608['id'];_0x14f86b(_0x12a292);});}});}exports[_0x70f6('0x9f')]=function(_0x59446c,_0x53e16b){return db[_0x70f6('0x6f')]['findAll']({'raw':!![],'where':{'CmContactId':_0x59446c[_0x70f6('0x29')]['id'],'ItemClass':'PHONE'},'include':[{'model':db[_0x70f6('0x93')],'as':_0x70f6('0x71')}],'order':[[_0x70f6('0x94')],[db['sequelize'][_0x70f6('0x73')](_0x70f6('0x9d'))]]})[_0x70f6('0x19')](function(_0xd23c36){return _0xd23c36;})[_0x70f6('0x19')](respondWithResult(_0x53e16b,null))[_0x70f6('0x25')](handleError(_0x53e16b,null));};exports[_0x70f6('0xa0')]=function(_0x502824,_0x35437b){return db[_0x70f6('0x6f')][_0x70f6('0x32')]({'raw':!![],'where':{'CmContactId':_0x502824[_0x70f6('0x38')][_0x70f6('0xa1')]}})[_0x70f6('0x19')](function(_0x256642){var _0x373935=_[_0x70f6('0x76')](_0x256642,function(_0x22bbac){_0x22bbac[_0x70f6('0xa2')]=_0x502824['body'][_0x70f6('0xa3')];return _0x22bbac;});return db[_0x70f6('0x6f')][_0x70f6('0x5f')](_0x373935,{});})['then'](function(){return addCmHopperPhones(_0x502824[_0x70f6('0x38')][_0x70f6('0xa3')]);})[_0x70f6('0x19')](function(){return['ok'];})['then'](respondWithResult(_0x35437b,null))[_0x70f6('0x25')](handleError(_0x35437b,null));};exports[_0x70f6('0xa4')]=function(_0x56685d,_0x356794){var _0x7b4542=[];_0x7b4542[_0x70f6('0x68')](createCmHopperPhone(_0x56685d[_0x70f6('0x38')]['id'],_0x56685d[_0x70f6('0x38')][_0x70f6('0xa5')]));Promise[_0x70f6('0x6a')](_0x7b4542)[_0x70f6('0x19')](function(){return[0x1];})[_0x70f6('0x19')](respondWithResult(_0x356794,null));};exports[_0x70f6('0xa6')]=function(_0x26e727,_0x40a8be){var _0x22f743={'raw':![],'where':{}};var _0x5b7d65={};var _0x1edb06={'count':0x0,'rows':[]};return db['CmContact'][_0x70f6('0x83')]({'where':{'id':_0x26e727[_0x70f6('0x29')]['id']}})[_0x70f6('0x19')](handleEntityNotFound(_0x40a8be,null))[_0x70f6('0x19')](function(_0x30d417){if(_0x30d417){_0x5b7d65[_0x70f6('0x84')]=_[_0x70f6('0x2b')](db[_0x70f6('0x3f')]['rawAttributes']);_0x5b7d65[_0x70f6('0x23')]=_[_0x70f6('0x2b')](_0x26e727[_0x70f6('0x23')]);_0x5b7d65['filters']=_[_0x70f6('0x86')](_0x5b7d65[_0x70f6('0x84')],_0x5b7d65[_0x70f6('0x23')]);_0x22f743['attributes']=_['intersection'](_0x5b7d65[_0x70f6('0x84')],qs[_0x70f6('0x87')](_0x26e727[_0x70f6('0x23')][_0x70f6('0x87')]));_0x22f743[_0x70f6('0x88')]=_0x22f743[_0x70f6('0x88')][_0x70f6('0x2c')]?_0x22f743[_0x70f6('0x88')]:_0x5b7d65[_0x70f6('0x84')];if(!_0x26e727[_0x70f6('0x23')][_0x70f6('0x67')](_0x70f6('0x8f'))){_0x22f743[_0x70f6('0x14')]=qs[_0x70f6('0x14')](_0x26e727[_0x70f6('0x23')][_0x70f6('0x14')]);_0x22f743[_0x70f6('0x13')]=qs[_0x70f6('0x13')](_0x26e727['query'][_0x70f6('0x13')]);}_0x22f743[_0x70f6('0x89')]=qs[_0x70f6('0x8a')](_0x26e727[_0x70f6('0x23')][_0x70f6('0x8a')]);_0x22f743[_0x70f6('0x62')]=qs[_0x70f6('0x8b')](_[_0x70f6('0x8c')](_0x26e727['query'],_0x5b7d65[_0x70f6('0x8b')]));_0x22f743[_0x70f6('0x62')]['ContactId']=_0x30d417['id'];if(_0x26e727['query'][_0x70f6('0x8d')]){_0x22f743[_0x70f6('0x62')]=_[_0x70f6('0x37')](_0x22f743[_0x70f6('0x62')],{'$or':_['map'](_0x22f743[_0x70f6('0x88')],function(_0x9e7bab){var _0x1e4fff={};_0x1e4fff[_0x9e7bab]={'$like':'%'+_0x26e727[_0x70f6('0x23')]['filter']+'%'};return _0x1e4fff;})});}_0x22f743=_[_0x70f6('0x37')]({},_0x22f743,_0x26e727['options']);return db[_0x70f6('0x3f')]['count']({'where':_0x22f743[_0x70f6('0x62')]})['then'](function(_0x64e89a){_0x1edb06['count']=_0x64e89a;if(_0x26e727[_0x70f6('0x23')][_0x70f6('0xa7')]){_0x22f743[_0x70f6('0xa8')]=[{'all':!![]}];}return db['CmHopper'][_0x70f6('0x32')](_0x22f743);})[_0x70f6('0x19')](function(_0xdc6fa0){_0x1edb06[_0x70f6('0xa9')]=_0xdc6fa0;return _0x1edb06;});}})['then'](respondWithFilteredResult(_0x40a8be,_0x22f743))[_0x70f6('0x25')](handleError(_0x40a8be,null));};exports[_0x70f6('0xaa')]=function(_0x2f0eb1,_0x1abf03){var _0x4f2444={'raw':!![],'where':{}};var _0x31fbf2={};var _0x141e90={'count':0x0,'rows':[]};return db[_0x70f6('0x27')][_0x70f6('0x83')]({'where':{'id':_0x2f0eb1[_0x70f6('0x29')]['id']}})[_0x70f6('0x19')](handleEntityNotFound(_0x1abf03,null))[_0x70f6('0x19')](function(_0xb4bcde){if(_0xb4bcde){_0x31fbf2[_0x70f6('0x84')]=_['keys'](db[_0x70f6('0x4e')][_0x70f6('0x85')]);_0x31fbf2[_0x70f6('0x23')]=_['keys'](_0x2f0eb1['query']);_0x31fbf2['filters']=_[_0x70f6('0x86')](_0x31fbf2[_0x70f6('0x84')],_0x31fbf2[_0x70f6('0x23')]);_0x4f2444[_0x70f6('0x88')]=_[_0x70f6('0x86')](_0x31fbf2['model'],qs[_0x70f6('0x87')](_0x2f0eb1[_0x70f6('0x23')][_0x70f6('0x87')]));_0x4f2444['attributes']=_0x4f2444[_0x70f6('0x88')][_0x70f6('0x2c')]?_0x4f2444[_0x70f6('0x88')]:_0x31fbf2[_0x70f6('0x84')];if(!_0x2f0eb1['query'][_0x70f6('0x67')](_0x70f6('0x8f'))){_0x4f2444[_0x70f6('0x14')]=qs[_0x70f6('0x14')](_0x2f0eb1[_0x70f6('0x23')][_0x70f6('0x14')]);_0x4f2444['offset']=qs['offset'](_0x2f0eb1[_0x70f6('0x23')]['offset']);}_0x4f2444[_0x70f6('0x89')]=qs['sort'](_0x2f0eb1[_0x70f6('0x23')]['sort']);_0x4f2444['where']=qs[_0x70f6('0x8b')](_[_0x70f6('0x8c')](_0x2f0eb1['query'],_0x31fbf2[_0x70f6('0x8b')]));_0x4f2444['where']['ContactId']=_0xb4bcde['id'];if(_0x2f0eb1['query'][_0x70f6('0x8d')]){_0x4f2444['where']=_['merge'](_0x4f2444[_0x70f6('0x62')],{'$or':_[_0x70f6('0x76')](_0x4f2444[_0x70f6('0x88')],function(_0x214077){var _0x511246={};_0x511246[_0x214077]={'$like':'%'+_0x2f0eb1[_0x70f6('0x23')]['filter']+'%'};return _0x511246;})});}_0x4f2444=_[_0x70f6('0x37')]({},_0x4f2444,_0x2f0eb1[_0x70f6('0x8e')]);return db[_0x70f6('0x4e')][_0x70f6('0x16')]({'where':_0x4f2444[_0x70f6('0x62')]})[_0x70f6('0x19')](function(_0x4ac224){_0x141e90['count']=_0x4ac224;if(_0x2f0eb1[_0x70f6('0x23')][_0x70f6('0xa7')]){_0x4f2444['include']=[{'all':!![]}];}return db[_0x70f6('0x4e')][_0x70f6('0x32')](_0x4f2444);})[_0x70f6('0x19')](function(_0x431f83){_0x141e90[_0x70f6('0xa9')]=_0x431f83;return _0x141e90;});}})[_0x70f6('0x19')](respondWithFilteredResult(_0x1abf03,_0x4f2444))[_0x70f6('0x25')](handleError(_0x1abf03,null));};exports['getHopperFinals']=function(_0x6a6465,_0x21904e){var _0xb2e144={'raw':!![],'where':{}};var _0x7e9a23={};var _0x9e649b={'count':0x0,'rows':[]};return db['CmContact'][_0x70f6('0x83')]({'where':{'id':_0x6a6465[_0x70f6('0x29')]['id']}})[_0x70f6('0x19')](handleEntityNotFound(_0x21904e,null))[_0x70f6('0x19')](function(_0x27316b){if(_0x27316b){_0x7e9a23[_0x70f6('0x84')]=_[_0x70f6('0x2b')](db['CmHopperFinal']['rawAttributes']);_0x7e9a23['query']=_[_0x70f6('0x2b')](_0x6a6465['query']);_0x7e9a23[_0x70f6('0x8b')]=_['intersection'](_0x7e9a23[_0x70f6('0x84')],_0x7e9a23[_0x70f6('0x23')]);_0xb2e144['attributes']=_['intersection'](_0x7e9a23[_0x70f6('0x84')],qs[_0x70f6('0x87')](_0x6a6465['query'][_0x70f6('0x87')]));_0xb2e144[_0x70f6('0x88')]=_0xb2e144[_0x70f6('0x88')][_0x70f6('0x2c')]?_0xb2e144[_0x70f6('0x88')]:_0x7e9a23[_0x70f6('0x84')];if(!_0x6a6465['query'][_0x70f6('0x67')](_0x70f6('0x8f'))){_0xb2e144[_0x70f6('0x14')]=qs[_0x70f6('0x14')](_0x6a6465[_0x70f6('0x23')][_0x70f6('0x14')]);_0xb2e144[_0x70f6('0x13')]=qs[_0x70f6('0x13')](_0x6a6465['query']['offset']);}_0xb2e144[_0x70f6('0x89')]=qs[_0x70f6('0x8a')](_0x6a6465[_0x70f6('0x23')][_0x70f6('0x8a')]);_0xb2e144['where']=qs[_0x70f6('0x8b')](_[_0x70f6('0x8c')](_0x6a6465[_0x70f6('0x23')],_0x7e9a23['filters']));_0xb2e144[_0x70f6('0x62')][_0x70f6('0xab')]=_0x27316b['id'];if(_0x6a6465[_0x70f6('0x23')][_0x70f6('0x8d')]){_0xb2e144[_0x70f6('0x62')]=_[_0x70f6('0x37')](_0xb2e144['where'],{'$or':_[_0x70f6('0x76')](_0xb2e144[_0x70f6('0x88')],function(_0x1bb41b){var _0x2927e0={};_0x2927e0[_0x1bb41b]={'$like':'%'+_0x6a6465['query'][_0x70f6('0x8d')]+'%'};return _0x2927e0;})});}_0xb2e144=_[_0x70f6('0x37')]({},_0xb2e144,_0x6a6465[_0x70f6('0x8e')]);return db[_0x70f6('0x4d')][_0x70f6('0x16')]({'where':_0xb2e144[_0x70f6('0x62')]})['then'](function(_0x3f339d){_0x9e649b[_0x70f6('0x16')]=_0x3f339d;if(_0x6a6465[_0x70f6('0x23')][_0x70f6('0xa7')]){_0xb2e144['include']=[{'all':!![]}];}return db['CmHopperFinal'][_0x70f6('0x32')](_0xb2e144);})[_0x70f6('0x19')](function(_0x5e5059){_0x9e649b[_0x70f6('0xa9')]=_0x5e5059;return _0x9e649b;});}})[_0x70f6('0x19')](respondWithFilteredResult(_0x21904e,_0xb2e144))[_0x70f6('0x25')](handleError(_0x21904e,null));};exports[_0x70f6('0xac')]=function(_0x3be884,_0x3664f4){var _0x1c4c33={'raw':!![],'where':{}};var _0x4c7cf4={};var _0x48b805={'count':0x0,'rows':[]};return db[_0x70f6('0x27')]['findOne']({'where':{'id':_0x3be884['params']['id']}})['then'](handleEntityNotFound(_0x3664f4,null))[_0x70f6('0x19')](function(_0x30e5b0){if(_0x30e5b0){_0x4c7cf4['model']=_['keys'](db[_0x70f6('0x56')][_0x70f6('0x85')]);_0x4c7cf4[_0x70f6('0x23')]=_[_0x70f6('0x2b')](_0x3be884[_0x70f6('0x23')]);_0x4c7cf4['filters']=_['intersection'](_0x4c7cf4['model'],_0x4c7cf4[_0x70f6('0x23')]);_0x1c4c33['attributes']=_[_0x70f6('0x86')](_0x4c7cf4['model'],qs[_0x70f6('0x87')](_0x3be884[_0x70f6('0x23')]['fields']));_0x1c4c33[_0x70f6('0x88')]=_0x1c4c33['attributes'][_0x70f6('0x2c')]?_0x1c4c33[_0x70f6('0x88')]:_0x4c7cf4['model'];if(!_0x3be884['query'][_0x70f6('0x67')](_0x70f6('0x8f'))){_0x1c4c33[_0x70f6('0x14')]=qs[_0x70f6('0x14')](_0x3be884[_0x70f6('0x23')][_0x70f6('0x14')]);_0x1c4c33[_0x70f6('0x13')]=qs[_0x70f6('0x13')](_0x3be884[_0x70f6('0x23')][_0x70f6('0x13')]);}_0x1c4c33[_0x70f6('0x89')]=qs[_0x70f6('0x8a')](_0x3be884['query']['sort']);_0x1c4c33[_0x70f6('0x62')]=qs[_0x70f6('0x8b')](_['pick'](_0x3be884[_0x70f6('0x23')],_0x4c7cf4[_0x70f6('0x8b')]));_0x1c4c33[_0x70f6('0x62')][_0x70f6('0xab')]=_0x30e5b0['id'];if(_0x3be884[_0x70f6('0x23')]['filter']){_0x1c4c33[_0x70f6('0x62')]=_[_0x70f6('0x37')](_0x1c4c33[_0x70f6('0x62')],{'$or':_[_0x70f6('0x76')](_0x1c4c33[_0x70f6('0x88')],function(_0x27cfc7){var _0x407d5b={};_0x407d5b[_0x27cfc7]={'$like':'%'+_0x3be884['query'][_0x70f6('0x8d')]+'%'};return _0x407d5b;})});}_0x1c4c33=_[_0x70f6('0x37')]({},_0x1c4c33,_0x3be884[_0x70f6('0x8e')]);return db[_0x70f6('0x56')][_0x70f6('0x16')]({'where':_0x1c4c33[_0x70f6('0x62')]})[_0x70f6('0x19')](function(_0x528b73){_0x48b805[_0x70f6('0x16')]=_0x528b73;if(_0x3be884[_0x70f6('0x23')][_0x70f6('0xa7')]){_0x1c4c33[_0x70f6('0xa8')]=[{'all':!![]}];}return db[_0x70f6('0x56')][_0x70f6('0x32')](_0x1c4c33);})[_0x70f6('0x19')](function(_0x10b06b){_0x48b805[_0x70f6('0xa9')]=_0x10b06b;return _0x48b805;});}})[_0x70f6('0x19')](respondWithFilteredResult(_0x3664f4,_0x1c4c33))[_0x70f6('0x25')](handleError(_0x3664f4,null));};exports[_0x70f6('0xad')]=function(_0x250346,_0x574966){try{if(!_0x250346[_0x70f6('0x38')][_0x70f6('0x64')]){throw new Error(_0x70f6('0xae'));}if(!_0x250346[_0x70f6('0x38')][_0x70f6('0xaf')]){throw new Error(_0x70f6('0xb0'));}if(!_0x250346[_0x70f6('0x38')][_0x70f6('0xb1')]){throw new Error(_0x70f6('0xb2'));}if(!_0x250346['body'][_0x70f6('0xb3')]){throw new Error(_0x70f6('0xb4'));}var _0x4b0563=_0x250346['body']['binding_keys']['split'](',');var _0x50b6de=_0x250346[_0x70f6('0x38')]['binding_values'][_0x70f6('0xb5')](',');if(!_0x4b0563[_0x70f6('0x2c')]||!_0x50b6de[_0x70f6('0x2c')]||_0x4b0563[_0x70f6('0x2c')]!==_0x50b6de['length']){throw new Error(_0x70f6('0xb6'));}_0x250346[_0x70f6('0x38')][_0x70f6('0x87')]=_['zipObject'](_0x4b0563,_0x50b6de);if(!_0x250346[_0x70f6('0x38')]['fields']['phone']){throw new Error(_0x70f6('0xb7'));}if(!_0x250346[_0x70f6('0x38')][_0x70f6('0x87')][_0x70f6('0xb8')]){throw new Error('No\x20firstName\x20column\x20specified');}var _0x1feaa8=path[_0x70f6('0x3d')](config['root'],_0x70f6('0xb9'),_0x250346['file'][_0x70f6('0xba')]);fs[_0x70f6('0xbb')](_0x1feaa8,parseInt(_0x70f6('0xbc'),0x8));var _0x20cf03=require(_0x70f6('0xbd'))[_0x70f6('0xbe')](path[_0x70f6('0x3d')](__dirname,_0x70f6('0xbf')),[_0x1feaa8,_0x250346[_0x70f6('0x38')]['binding_keys'],_0x250346[_0x70f6('0x38')][_0x70f6('0xb1')],_0x250346[_0x70f6('0x38')][_0x70f6('0x64')],_0x250346[_0x70f6('0x38')][_0x70f6('0xc0')],_0x250346[_0x70f6('0x38')][_0x70f6('0x61')],_0x250346[_0x70f6('0x38')][_0x70f6('0xb3')]]);return _0x574966[_0x70f6('0x11')](0xc8)[_0x70f6('0x12')]({'message':_0x70f6('0xc1'),'pid':_0x20cf03[_0x70f6('0xc2')]});}catch(_0x52db17){return _0x574966[_0x70f6('0x11')](0x1f4)['send'](_0x52db17);}};exports[_0x70f6('0xc3')]=function(_0x3cfb47,_0x181d86){var _0x257b4b=fs[_0x70f6('0xc4')](_0x3cfb47[_0x70f6('0xc5')]['path']);Papa[_0x70f6('0xc6')](_0x257b4b,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x5f4c27){return _0x181d86['status'](0xc8)[_0x70f6('0x12')]({'file':_0x3cfb47[_0x70f6('0xc5')],'fields':_0x5f4c27['meta'][_0x70f6('0x87')]});}});};exports[_0x70f6('0xc7')]=function(_0xd17086,_0x22fad1){return db['User'][_0x70f6('0x32')]({'raw':!![],'attributes':['id'],'where':{'role':_0x70f6('0xc8')}})[_0x70f6('0x19')](function(_0x14f627){var _0x4840cf=![];if(!_0xd17086[_0x70f6('0x38')][_0x70f6('0x64')]){throw new Error(_0x70f6('0xae'));}if(!_0xd17086['body'][_0x70f6('0xc9')][_0x70f6('0x81')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0xd17086[_0x70f6('0x38')][_0x70f6('0xc9')][_0x70f6('0xb8')]){throw new Error(_0x70f6('0xca'));}if(!_0xd17086['body'][_0x70f6('0xb3')]){throw new Error(_0x70f6('0xb4'));}var _0xb3ff84=require(_0x70f6('0xbd'))[_0x70f6('0xbe')](path[_0x70f6('0x3d')](__dirname,_0x70f6('0xcb')),[_0xd17086[_0x70f6('0x29')]['id'],JSON[_0x70f6('0xcc')](_0xd17086[_0x70f6('0x38')]),JSON[_0x70f6('0xcc')](_0x14f627)]);_0xb3ff84['on'](_0x70f6('0xcd'),function(){_0x4840cf=!![];return _0x22fad1[_0x70f6('0x11')](0xc8)[_0x70f6('0x12')]({'message':_0x70f6('0xce'),'pid':_0xb3ff84[_0x70f6('0xc2')]});});_0xb3ff84['on'](_0x70f6('0xcf'),function(_0x5c893f){if(_0x5c893f&&!_0x4840cf){return _0x22fad1[_0x70f6('0x11')](0x1f4)[_0x70f6('0x12')]({'message':_0x70f6('0xd0'),'pid':_0xb3ff84[_0x70f6('0xc2')]});}});})[_0x70f6('0x25')](handleError(_0x22fad1,null));};exports['importUpdates']=function(_0x4e3b1f,_0x28d8d4){return db['User'][_0x70f6('0x32')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0x70f6('0x19')](function(_0x2946e7){var _0x5a145e=![];if(!_0x4e3b1f[_0x70f6('0x38')]['ListId']){throw new Error(_0x70f6('0xae'));}if(!_0x4e3b1f['body'][_0x70f6('0xc9')][_0x70f6('0x81')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x4e3b1f[_0x70f6('0x38')][_0x70f6('0xc9')][_0x70f6('0xb8')]){throw new Error(_0x70f6('0xca'));}if(!_0x4e3b1f[_0x70f6('0x38')][_0x70f6('0xb3')]){throw new Error(_0x70f6('0xb4'));}var _0x25efdf=require('child_process')['fork'](path[_0x70f6('0x3d')](__dirname,_0x70f6('0xd1')),[_0x4e3b1f['params']['id'],JSON[_0x70f6('0xcc')](_0x4e3b1f[_0x70f6('0x38')]),JSON[_0x70f6('0xcc')](_0x2946e7)]);_0x25efdf['on'](_0x70f6('0xcd'),function(){_0x5a145e=!![];return _0x28d8d4[_0x70f6('0x11')](0xc8)[_0x70f6('0x12')]({'message':_0x70f6('0xce'),'pid':_0x25efdf[_0x70f6('0xc2')]});});_0x25efdf['on'](_0x70f6('0xcf'),function(_0x12f8f5){if(_0x12f8f5&&!_0x5a145e){return _0x28d8d4['status'](0x1f4)[_0x70f6('0x12')]({'message':_0x70f6('0xd0'),'pid':_0x25efdf[_0x70f6('0xc2')]});}});})[_0x70f6('0x25')](handleError(_0x28d8d4,null));};exports['getJourney']=function(_0x446de2,_0x518140){var _0x33a247=[_0x70f6('0xd2'),_0x70f6('0xd3'),_0x70f6('0xd4'),_0x70f6('0xd5'),_0x70f6('0xd6'),'whatsapp','voice'];var _0x43bd12={'offset':0x0,'order':qs['sort'](_0x70f6('0xd7'))},_0x516c8d={'count':0x0,'rows':[]};Promise[_0x70f6('0xd8')]()['then'](function(){if(_0x446de2['query'][_0x70f6('0xd9')]){if(!_[_0x70f6('0xda')](_0x33a247,_0x446de2['query'][_0x70f6('0xd9')][_0x70f6('0xdb')]())){throw new Error(_0x70f6('0xdc'));}_0x33a247=[_0x446de2['query'][_0x70f6('0xd9')]['toLowerCase']()];}if(_0x446de2[_0x70f6('0x23')][_0x70f6('0xdd')]){try{var _0xcd26f8=JSON[_0x70f6('0xc6')](_0x446de2[_0x70f6('0x23')][_0x70f6('0xdd')]);if(!moment(_0xcd26f8['from'])[_0x70f6('0xde')]()){throw new Error('Invalid\x20date\x20for\x20range\x20from\x20filter');}if(!moment(_0xcd26f8['to'])['isValid']()){throw new Error(_0x70f6('0xdf'));}}catch(_0x68c0af){throw new Error(_0x70f6('0xe0'));}}if(!_0x446de2['query'][_0x70f6('0x67')](_0x70f6('0x8f'))){_0x43bd12[_0x70f6('0x14')]=qs[_0x70f6('0x14')](_0x446de2[_0x70f6('0x23')][_0x70f6('0x14')]||0xa);_0x43bd12['offset']=qs['offset'](_0x446de2['query']['offset']);}var _0xa08929=_0x33a247[_0x70f6('0x76')](function(_0x370622){if(_0x370622==='voice'){var _0x2264dd={'attributes':['id',_0x70f6('0xe1'),'type',_0x70f6('0xe2'),_0x70f6('0xe3'),_0x70f6('0xe4'),_0x70f6('0xe5'),_0x70f6('0xe6'),_0x70f6('0xe7'),'note','createdAt','userDisposition','userSecondDisposition',_0x70f6('0xe8'),_0x70f6('0xe9')],'where':{'ContactId':_0x446de2['params']['id']},'include':[{'model':db[_0x70f6('0xea')],'as':_0x70f6('0xea'),'attributes':['id',_0x70f6('0x1e'),'fullname',_0x70f6('0x33')]}],'order':[[_0x70f6('0xeb'),_0x70f6('0xec')]]};if(_0x446de2[_0x70f6('0x23')][_0x70f6('0xdd')]){_0x2264dd[_0x70f6('0x62')]['createdAt']={'$gte':_0xcd26f8['from'],'$lte':_0xcd26f8['to']};}return db['VoiceCallReport'][_0x70f6('0xed')](_0x2264dd)[_0x70f6('0x19')](function(_0x115520){_0x516c8d['count']+=_0x115520[_0x70f6('0x16')];return _[_0x70f6('0x76')](_0x115520[_0x70f6('0xa9')],function(_0x2c1471){var _0xd52400=_0x2c1471['get']({'plain':!![]});_0xd52400[_0x70f6('0xd9')]=_0x370622;if(_0xd52400[_0x70f6('0xea')]){_0xd52400['User']={'id':_0xd52400['User']['id'],'name':_0xd52400['User'][_0x70f6('0x1e')],'fullname':_0xd52400['User']['fullname'],'alias':_0xd52400[_0x70f6('0xea')]['alias']};}return _0xd52400;});});}else{var _0x273561=_[_0x70f6('0xee')](_0x370622)+(_0x370622===_0x70f6('0xd3')?'Website':_0x70f6('0xef'));var _0x30cf83={'attributes':['id',_0x70f6('0xf0'),_0x70f6('0xf1'),_0x70f6('0xeb'),_0x70f6('0xf2'),_0x70f6('0xf3'),'secondDisposition',_0x70f6('0xf4'),_0x70f6('0xe9'),_0x273561+'Id'],'where':{'ContactId':_0x446de2[_0x70f6('0x29')]['id']},'include':[{'model':db[_0x273561],'as':_0x70f6('0xef'),'attributes':['id',_0x70f6('0x1e'),_0x70f6('0xf5')]},{'model':db[_0x70f6('0xea')],'as':_0x70f6('0xf6'),'attributes':['id',_0x70f6('0x1e'),_0x70f6('0xf7')]},{'model':db[_0x70f6('0x6b')],'as':_0x70f6('0x6c'),'attributes':['id',_0x70f6('0x1e'),_0x70f6('0x6d')],'through':{'attributes':[]}}],'order':[[_0x70f6('0xeb'),_0x70f6('0xec')]]};if(_0x446de2[_0x70f6('0x23')][_0x70f6('0xdd')]){_0x30cf83[_0x70f6('0x62')][_0x70f6('0xeb')]={'$gte':_0xcd26f8['from'],'$lte':_0xcd26f8['to']};}switch(_0x370622){case _0x70f6('0xd3'):_0x30cf83[_0x70f6('0x88')][_0x70f6('0x68')](_0x70f6('0xf8'),_0x70f6('0xf9'),_0x70f6('0xfa'),_0x70f6('0xfb'),_0x70f6('0xfc'),_0x70f6('0xfd'),_0x70f6('0xfe'),_0x70f6('0xff'),'referer');break;case _0x70f6('0xd2'):_0x30cf83['attributes'][_0x70f6('0x68')](_0x70f6('0x100'),_0x70f6('0x101'));break;case'openchannel':_0x30cf83[_0x70f6('0x88')][_0x70f6('0x68')](_0x70f6('0x102'),_0x70f6('0x103'));break;}return db[_[_0x70f6('0xee')](_0x370622)+_0x70f6('0x104')]['findAndCountAll'](_0x30cf83)['then'](function(_0x356c91){_0x516c8d[_0x70f6('0x16')]+=_0x356c91[_0x70f6('0x16')];return _[_0x70f6('0x76')](_0x356c91[_0x70f6('0xa9')],function(_0x34cc9d){var _0x27949a=_0x34cc9d[_0x70f6('0x3a')]({'plain':!![]});_0x27949a[_0x70f6('0xd9')]=_0x370622;if(_0x27949a['Owner']){_0x27949a[_0x70f6('0xf6')]={'id':_0x27949a['Owner']['id'],'name':_0x27949a[_0x70f6('0xf6')]['name'],'fullname':_0x27949a[_0x70f6('0xf6')]['fullname']};}return _0x27949a;});});}});return Promise['all'](_0xa08929);})[_0x70f6('0x19')](function(_0x59830d){return _(_0x59830d)[_0x70f6('0x105')]()[_0x70f6('0x106')](_0x70f6('0xeb'))[_0x70f6('0x107')]()[_0x70f6('0x108')]();})['then'](function(_0x4275eb){_0x516c8d['rows']=_0x43bd12[_0x70f6('0x14')]?_0x4275eb['slice'](_0x43bd12[_0x70f6('0x13')],_0x43bd12['offset']+_0x43bd12['limit']):_0x4275eb;return _0x516c8d;})[_0x70f6('0x19')](respondWithFilteredResult(_0x518140,_0x43bd12))[_0x70f6('0x25')](handleError(_0x518140,null));};
\ No newline at end of file
+var _0x297f=['Interaction','sortBy','reverse','value','slice','moment','bluebird','util','lodash','papaparse','ioredis','../../components/contacts','../../components/parsers/qs','api','../../config/environment','../../mysqldb','redis','localhost','socket.io-emitter','register','status','json','offset','limit','undefined','count','set','update','then','destroy','end','sendStatus','stack','name','send','index','describe','getOptions','findAll','query','user','catch','CmContact','find','params','tags','keys','length','cf_','displayName','analytics','columnName','alias','custom','values','info','Custom\x20field\x20%s\x20not\x20found\x20on\x20cm_contacts\x20table','forEach','body','from','get','mergeWith','isArray','join','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatMessage','MailInteraction','MailMessage','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappMessage','WhatsappQueueReport','isNil','dialTimezone','utcOffset','timezones','additionalPhones','duplicates','where','$or','push','ListId','findOrCreate','spread','hasOwnProperty','contact','all','show','Tag','Tags','color','CmContactHasItem','ItemType','sequelize','literal','Phones.OrderBy','$and','CmCustomField','omit','map','format','cf_%d','pickBy','startsWith','isEmpty','table','cm_contacts','setFields','toParam','phone','getTags','findOne','model','rawAttributes','filters','intersection','fields','attributes','order','sort','pick','filter','merge','options','nolimit','setTags','ContactItemType','OrderBy','items','item_types','ItemTypeId','description','contact\x20phone\x20exists','item','PHONE','`ItemType`.OrderBy','CmHopperId','ItemType.OrderBy','CmHopperAdditionalPhone','duplicateAdditionalPhones','fromContactId','CmContactId','toContactId','bulkCreate','rescheduleAdditionalPhones','hopperId','ContactId','includeAll','include','rows','getHopperFinals','CmHopperFinal','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','binding_keys','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','split','binding_values','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','root','server/files/tmp','file','filename','0777','child_process','fork','../../components/import/cm/csv','CompanyId','pid','createReadStream','path','parse','meta','import','User','agent','binding','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','exit','error\x20child\x20process','../../components/import/cm/csvUpdates','getJourney','mail','chat','sms','openchannel','fax','whatsapp','voice','-createdAt','resolve','channel','toLowerCase','range','isValid','Invalid\x20date\x20for\x20range\x20from\x20filter','Invalid\x20date\x20for\x20range\x20to\x20filter','Invalid\x20createdAt\x20filter','type','source','callerid','endtime','note','createdAt','userSecondDisposition','userThirdDisposition','UserId','fullname','findAndCountAll','startCase','Account','closed','closedAt','disposition','secondDisposition','thirdDisposition','key','Owner','DESC','customerIp','customerPort','deviceModel','osName','ratingType','ratingValue','referer','subject','substatus','externalUrl','threadId'];(function(_0x5b6eb2,_0x495e9d){var _0x1c6bc7=function(_0x577701){while(--_0x577701){_0x5b6eb2['push'](_0x5b6eb2['shift']());}};_0x1c6bc7(++_0x495e9d);}(_0x297f,0x105));var _0xf297=function(_0x112bd1,_0x5f43fa){_0x112bd1=_0x112bd1-0x0;var _0x2c132e=_0x297f[_0x112bd1];return _0x2c132e;};'use strict';var moment=require(_0xf297('0x0'));var BPromise=require(_0xf297('0x1'));var util=require(_0xf297('0x2'));var path=require('path');var fs=require('fs');var _=require(_0xf297('0x3'));var squel=require('squel');var Papa=require(_0xf297('0x4'));var Redis=require(_0xf297('0x5'));var contacts=require(_0xf297('0x6'));var qs=require(_0xf297('0x7'));var logger=require('../../config/logger')(_0xf297('0x8'));var config=require(_0xf297('0x9'));var shared=require('../../config/environment/shared');var db=require(_0xf297('0xa'))['db'];config[_0xf297('0xb')]=_['defaults'](config[_0xf297('0xb')],{'host':_0xf297('0xc'),'port':0x18eb});var socket=require(_0xf297('0xd'))(new Redis(config[_0xf297('0xb')]));require('./cmContact.socket')[_0xf297('0xe')](socket);function respondWithResult(_0x228d20,_0x49c687){_0x49c687=_0x49c687||0xc8;return function(_0x51deb3){if(_0x51deb3){return _0x228d20[_0xf297('0xf')](_0x49c687)[_0xf297('0x10')](_0x51deb3);}};}function respondWithFilteredResult(_0x3985e3,_0x34b739){return function(_0x539721){if(_0x539721){var _0x46f3db=typeof _0x34b739[_0xf297('0x11')]==='undefined'&&typeof _0x34b739[_0xf297('0x12')]===_0xf297('0x13');var _0x2d47a6=_0x539721[_0xf297('0x14')];var _0x361727=_0x46f3db?0x0:_0x34b739['offset'];var _0x103d3d=_0x46f3db?_0x539721[_0xf297('0x14')]:_0x34b739[_0xf297('0x11')]+_0x34b739[_0xf297('0x12')];var _0x51870a;if(_0x103d3d>=_0x2d47a6){_0x103d3d=_0x2d47a6;_0x51870a=0xc8;}else{_0x51870a=0xce;}_0x3985e3[_0xf297('0xf')](_0x51870a);return _0x3985e3[_0xf297('0x15')]('Content-Range',_0x361727+'-'+_0x103d3d+'/'+_0x2d47a6)[_0xf297('0x10')](_0x539721);}return null;};}function saveUpdates(_0x4ebe61){return function(_0x1c18eb){if(_0x1c18eb){return _0x1c18eb[_0xf297('0x16')](_0x4ebe61)[_0xf297('0x17')](function(_0x48ee08){return _0x48ee08;});}return null;};}function removeEntity(_0x1be708){return function(_0x2acc5b){if(_0x2acc5b){return _0x2acc5b[_0xf297('0x18')]()[_0xf297('0x17')](function(){_0x1be708['status'](0xcc)[_0xf297('0x19')]();});}};}function handleEntityNotFound(_0x322fca){return function(_0x59c360){if(!_0x59c360){_0x322fca[_0xf297('0x1a')](0x194);}return _0x59c360;};}function handleError(_0x10ffc9,_0x5df93f){_0x5df93f=_0x5df93f||0x1f4;return function(_0x18c128){logger['error'](_0x18c128[_0xf297('0x1b')]);if(_0x18c128[_0xf297('0x1c')]){delete _0x18c128[_0xf297('0x1c')];}_0x10ffc9[_0xf297('0xf')](_0x5df93f)[_0xf297('0x1d')](_0x18c128);};}exports[_0xf297('0x1e')]=function(_0x1c7b00,_0x5a9945){var _0xfa1762={};return contacts[_0xf297('0x1f')]()['then'](function(_0x3db65a){_0xfa1762=qs[_0xf297('0x20')](_0x3db65a,_0x1c7b00);return contacts[_0xf297('0x21')](_0x1c7b00[_0xf297('0x22')],_0x1c7b00[_0xf297('0x23')],_0xfa1762,_0x3db65a);})['then'](respondWithFilteredResult(_0x5a9945,_0xfa1762))[_0xf297('0x24')](handleError(_0x5a9945,null));};exports[_0xf297('0x18')]=function(_0x19b30e,_0x5e2574){return db[_0xf297('0x25')][_0xf297('0x26')]({'where':{'id':_0x19b30e[_0xf297('0x27')]['id']}})[_0xf297('0x17')](handleEntityNotFound(_0x5e2574,null))[_0xf297('0x17')](removeEntity(_0x5e2574,null))[_0xf297('0x24')](handleError(_0x5e2574,null));};exports['describe']=function(_0x13e968,_0xc132f3){return db[_0xf297('0x25')][_0xf297('0x1f')]()['then'](function(_0x4d5f04){delete _0x4d5f04[_0xf297('0x28')];for(var _0xb70acb=0x0;_0xb70acb<Object[_0xf297('0x29')](_0x4d5f04)[_0xf297('0x2a')];_0xb70acb++){var _0x50f6a6=Object[_0xf297('0x29')](_0x4d5f04)[_0xb70acb];if(!_['startsWith'](_0x50f6a6,_0xf297('0x2b'))){_0x4d5f04[_0x50f6a6]['columnName']=_0x50f6a6;_0x4d5f04[_0x50f6a6][_0xf297('0x2c')]=_0x50f6a6;}}return _0x4d5f04;})['then'](function(_0x58dc30){var _0x1a5c28={'where':Boolean(_0x13e968[_0xf297('0x22')][_0xf297('0x2d')])===!![]?undefined:{'$or':[{'ListId':_0x13e968['query']['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField'][_0xf297('0x21')](_0x1a5c28)[_0xf297('0x17')](function(_0x44523e){for(var _0x36cad4=0x0;_0x36cad4<_0x44523e[_0xf297('0x2a')];_0x36cad4++){var _0x81c600=_0xf297('0x2b')+_0x44523e[_0x36cad4]['id'];if(_0x58dc30[_0x81c600]){_0x58dc30[_0x81c600][_0xf297('0x2e')]=_0x81c600;_0x58dc30[_0x81c600][_0xf297('0x2c')]=_0x44523e[_0x36cad4][_0xf297('0x2f')];_0x58dc30[_0x81c600][_0xf297('0x30')]={'type':_0x44523e[_0x36cad4]['type'],'values':_0x44523e[_0x36cad4][_0xf297('0x31')]};}else{logger[_0xf297('0x32')](_0xf297('0x33'),_0x81c600);}}Object['keys'](_0x58dc30)[_0xf297('0x34')](function(_0x50e3b5){if(!_0x58dc30[_0x50e3b5]['hasOwnProperty'](_0xf297('0x2e'))){delete _0x58dc30[_0x50e3b5];}});return _0x58dc30;});})[_0xf297('0x17')](respondWithResult(_0xc132f3,null))[_0xf297('0x24')](handleError(_0xc132f3,null));};exports['merge']=function(_0x4bc42f,_0x18bb1a){var _0xb010f4;var _0x47cb6f;var _0x28366d;if(_0x4bc42f[_0xf297('0x35')]['id']){delete _0x4bc42f['body']['id'];}return db[_0xf297('0x25')]['findAll']({'where':{'id':[_0x4bc42f['body']['to'],_0x4bc42f[_0xf297('0x35')][_0xf297('0x36')]]}})['then'](function(_0x412f61){if(_0x412f61){if(_0x412f61[_0xf297('0x2a')]!==0x2){return null;}_0x412f61[0x0]=_0x412f61[0x0][_0xf297('0x37')]({'plain':!![]});_0x412f61[0x1]=_0x412f61[0x1]['get']({'plain':!![]});delete _0x412f61[0x0]['id'];delete _0x412f61[0x1]['id'];return _[_0xf297('0x38')](_0x412f61[0x0],_0x412f61[0x1],function(_0x12973e,_0x22742d){if(Array[_0xf297('0x39')](_0x22742d)&&!_0x22742d['length']){return _0x12973e;}else if(!_0x22742d){return _0x12973e;}});}})[_0xf297('0x17')](handleEntityNotFound(_0x18bb1a,null))[_0xf297('0x17')](function(_0x5b29cb){if(_0x5b29cb){if(_0x5b29cb[_0xf297('0x28')]&&_[_0xf297('0x39')](_0x5b29cb[_0xf297('0x28')])){_0x5b29cb[_0xf297('0x28')]=_0x5b29cb[_0xf297('0x28')][_0xf297('0x3a')]();}logger[_0xf297('0x32')](_0xf297('0x3b'),_0x4bc42f['body']['to'],_0x4bc42f[_0xf297('0x35')][_0xf297('0x36')]);return db[_0xf297('0x3c')][_0xf297('0x18')]({'where':{'ContactId':[_0x4bc42f[_0xf297('0x35')]['to'],_0x4bc42f[_0xf297('0x35')][_0xf297('0x36')]]}})[_0xf297('0x17')](function(_0x3460af){logger['info'](_0xf297('0x3d'),_0x3460af);return db['CmHopperBlack'][_0xf297('0x18')]({'where':{'ContactId':[_0x4bc42f['body']['to'],_0x4bc42f[_0xf297('0x35')][_0xf297('0x36')]]}})[_0xf297('0x17')](function(_0x4f06f1){logger['info'](_0xf297('0x3e'),_0x4f06f1);return db[_0xf297('0x25')][_0xf297('0x3f')](_0x5b29cb);});});}})[_0xf297('0x17')](function(_0x5dc24b){if(_0x5dc24b){_0xb010f4=_0x5dc24b;_0x47cb6f={'ContactId':_0xb010f4['id']};_0x28366d={'where':{'ContactId':[_0x4bc42f[_0xf297('0x35')]['to'],_0x4bc42f[_0xf297('0x35')][_0xf297('0x36')]]}};return db['ChatInteraction']['update'](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db[_0xf297('0x40')][_0xf297('0x16')](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db['ChatOfflineMessage'][_0xf297('0x16')](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db[_0xf297('0x41')][_0xf297('0x16')](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db[_0xf297('0x42')][_0xf297('0x16')](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db[_0xf297('0x41')][_0xf297('0x16')](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db[_0xf297('0x42')][_0xf297('0x16')](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db['SmsInteraction']['update'](_0x47cb6f,_0x28366d);}})['then'](function(){if(_0xb010f4){return db[_0xf297('0x43')][_0xf297('0x16')](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db[_0xf297('0x44')][_0xf297('0x16')](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db[_0xf297('0x45')][_0xf297('0x16')](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db[_0xf297('0x46')][_0xf297('0x16')](_0x47cb6f,_0x28366d);}})['then'](function(){if(_0xb010f4){return db[_0xf297('0x47')][_0xf297('0x16')](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db['CmContactHasItem'][_0xf297('0x16')]({'CmContactId':_0xb010f4['id']},{'where':{'CmContactId':[_0x4bc42f[_0xf297('0x35')]['to'],_0x4bc42f['body'][_0xf297('0x36')]]}});}})['then'](function(){if(_0xb010f4){return db['CmHopperFinal'][_0xf297('0x16')](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db[_0xf297('0x48')][_0xf297('0x16')](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db[_0xf297('0x49')][_0xf297('0x16')](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db[_0xf297('0x4a')][_0xf297('0x16')](_0x47cb6f,_0x28366d);}})['then'](function(){if(_0xb010f4){return db[_0xf297('0x4b')][_0xf297('0x16')](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db[_0xf297('0x4c')][_0xf297('0x16')](_0x47cb6f,_0x28366d);}})['then'](function(){if(_0xb010f4){return db[_0xf297('0x4d')]['update'](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db[_0xf297('0x4e')]['update'](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db[_0xf297('0x4f')][_0xf297('0x16')](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db[_0xf297('0x50')][_0xf297('0x16')](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db[_0xf297('0x51')]['update'](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db[_0xf297('0x52')]['update'](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db[_0xf297('0x53')]['update'](_0x47cb6f,_0x28366d);}})[_0xf297('0x17')](function(){if(_0xb010f4){return db[_0xf297('0x25')][_0xf297('0x18')]({'where':{'id':[_0x4bc42f[_0xf297('0x35')]['to'],_0x4bc42f[_0xf297('0x35')][_0xf297('0x36')]]}});}})['then'](function(){if(_0xb010f4){return _0xb010f4;}})[_0xf297('0x17')](respondWithResult(_0x18bb1a,null))[_0xf297('0x24')](handleError(_0x18bb1a,null));};exports[_0xf297('0x3f')]=function(_0x3cb792,_0x3135eb){return db[_0xf297('0x25')][_0xf297('0x1f')]()[_0xf297('0x17')](function(_0x77915d){if(_0x3cb792['body'][_0xf297('0x28')]&&_[_0xf297('0x39')](_0x3cb792[_0xf297('0x35')][_0xf297('0x28')])){if(_0x3cb792[_0xf297('0x35')][_0xf297('0x28')][_0xf297('0x2a')]){_0x3cb792[_0xf297('0x35')][_0xf297('0x28')]=_0x3cb792['body'][_0xf297('0x28')][_0xf297('0x3a')](';')+';';}else{_0x3cb792['body'][_0xf297('0x28')]=null;}}else{_0x3cb792[_0xf297('0x35')][_0xf297('0x28')]=null;}if(!_[_0xf297('0x54')](_0x3cb792[_0xf297('0x35')][_0xf297('0x55')])){var _0x13666c=_0x3cb792[_0xf297('0x35')]['dialTimezone'];if(!_[_0xf297('0x54')](shared['timezones'][_0x13666c]))_0x3cb792['body'][_0xf297('0x56')]=shared[_0xf297('0x57')][_0x13666c][_0xf297('0x56')];}return db[_0xf297('0x25')]['create'](_0x3cb792[_0xf297('0x35')],{'fields':_['keys'](_0x77915d),'raw':!![]});})['then'](function(_0x5bca57){if(_0x3cb792[_0xf297('0x35')][_0xf297('0x58')]){return insertAdditionalPhones(_0x5bca57,_0x3cb792[_0xf297('0x35')][_0xf297('0x58')]);}else{return _0x5bca57;}})[_0xf297('0x17')](respondWithResult(_0x3135eb,0xc9))[_0xf297('0x24')](handleError(_0x3135eb,null));};exports['bulkCreate']=function(_0x1deedf,_0x65f20c){var _0x35abc3=0x0;var _0x19591=0x0;var _0x19480b=0x0;var _0x32ec20=[];return db[_0xf297('0x25')]['describe']()[_0xf297('0x17')](function(_0x2772d9){return BPromise['each'](_0x1deedf[_0xf297('0x35')],function(_0x2dc421){var _0x2caea2={'where':{'$or':[]},'defaults':_0x2dc421,'fields':_['keys'](_0x2772d9),'raw':!![]};if(_0x2dc421['duplicates']){for(var _0x100374=0x0;_0x100374<_0x2dc421[_0xf297('0x59')][_0xf297('0x2a')];_0x100374++){var _0x1662f1={};_0x1662f1[_0x2dc421[_0xf297('0x59')][_0x100374]]=_0x2dc421[_0x2dc421['duplicates'][_0x100374]];_0x2caea2[_0xf297('0x5a')][_0xf297('0x5b')][_0xf297('0x5c')](_0x1662f1);}_0x2caea2[_0xf297('0x5a')][_0xf297('0x5d')]=_0x2dc421[_0xf297('0x5d')];}return db[_0xf297('0x25')][_0xf297('0x5e')](_0x2caea2)[_0xf297('0x5f')](function(_0x21da59,_0x94c2ec){if(_0x94c2ec){if(_0x2dc421[_0xf297('0x60')](_0xf297('0x58'))){_0x32ec20[_0xf297('0x5c')]({'contact':_0x21da59,'additionalPhones':_0x2dc421[_0xf297('0x58')]});}_0x35abc3++;}else{_0x19480b++;}})['catch'](function(){_0x19591++;});});})['then'](function(_0x15df98){if(_0x15df98){if(_0x32ec20[_0xf297('0x2a')]>0x0){return new Promise(function(_0x5f06c3){var _0x4c81f2=[];for(var _0x49a309=0x0;_0x49a309<_0x32ec20[_0xf297('0x2a')];_0x49a309++){_0x4c81f2[_0xf297('0x5c')](insertAdditionalPhones(_0x32ec20[_0x49a309][_0xf297('0x61')],_0x32ec20[_0x49a309]['additionalPhones']));}Promise[_0xf297('0x62')](_0x4c81f2)[_0xf297('0x17')](function(){_0x5f06c3(0x1);});})['then'](function(){return{'success':_0x35abc3,'failure':_0x19591,'duplicates':_0x19480b};});}else{return{'success':_0x35abc3,'failure':_0x19591,'duplicates':_0x19480b};}}})[_0xf297('0x17')](respondWithResult(_0x65f20c,0xc9))['catch'](handleError(_0x65f20c,null));};exports[_0xf297('0x63')]=function(_0x314196,_0x13e0d0){var _0x17cd1c;return db[_0xf297('0x25')][_0xf297('0x1f')]()[_0xf297('0x17')](function(_0x44b7a0){return db[_0xf297('0x25')][_0xf297('0x26')]({'where':{'id':_0x314196[_0xf297('0x27')]['id']},'include':[{'model':db[_0xf297('0x64')],'as':_0xf297('0x65'),'attributes':['id','name',_0xf297('0x66')],'required':_0x314196[_0xf297('0x22')]['tag']?!![]:![]},{'model':db[_0xf297('0x67')],'as':'Phones','where':{'CmContactId':_0x314196['params']['id']},'required':![],'include':[{'model':db['ContactItemType'],'as':_0xf297('0x68')}]}],'order':[db[_0xf297('0x69')][_0xf297('0x6a')](_0xf297('0x6b'))],'attributes':_[_0xf297('0x29')](_0x44b7a0)});})[_0xf297('0x17')](function(_0x4d2ef6){if(!_[_0xf297('0x54')](_0x4d2ef6)){_0x17cd1c=_0x4d2ef6[_0xf297('0x37')]({'plain':!![]});var _0x5b0401={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x4d2ef6&&_0x4d2ef6[_0xf297('0x5d')]){if(_0x4d2ef6['ListId']){_0x5b0401['where'][_0xf297('0x6c')]['push']({'ListId':{'$ne':_0x4d2ef6[_0xf297('0x5d')]}});}}return db[_0xf297('0x6d')][_0xf297('0x21')](_0x5b0401);}})[_0xf297('0x17')](function(_0x14d770){if(!_[_0xf297('0x54')](_0x14d770)){return _[_0xf297('0x6e')](_0x17cd1c,_[_0xf297('0x6f')](_0x14d770,function(_0x12603e){return util[_0xf297('0x70')](_0xf297('0x71'),_0x12603e['id']);}));}})[_0xf297('0x17')](handleEntityNotFound(_0x13e0d0,null))['then'](respondWithResult(_0x13e0d0,null))[_0xf297('0x24')](handleError(_0x13e0d0,null));};exports[_0xf297('0x16')]=function(_0xa01a71,_0x597ebf){var _0x45924c;if(_0xa01a71['body']['id']){delete _0xa01a71[_0xf297('0x35')]['id'];}if(!_[_0xf297('0x54')](_0xa01a71[_0xf297('0x35')][_0xf297('0x55')])){var _0x134dbd=_0xa01a71[_0xf297('0x35')]['dialTimezone'];if(!_['isNil'](shared[_0xf297('0x57')][_0x134dbd]))_0xa01a71[_0xf297('0x35')]['utcOffset']=shared[_0xf297('0x57')][_0x134dbd][_0xf297('0x56')];}return db[_0xf297('0x25')][_0xf297('0x26')]({'where':{'id':_0xa01a71[_0xf297('0x27')]['id']}})[_0xf297('0x17')](handleEntityNotFound(_0x597ebf,null))[_0xf297('0x17')](saveUpdates(_0xa01a71['body'],null))[_0xf297('0x17')](function(_0x27f811){_0x45924c=_0x27f811;var _0x288fed={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x27f811&&_0x27f811['ListId']){if(_0x27f811[_0xf297('0x5d')]){_0x288fed['where'][_0xf297('0x6c')][_0xf297('0x5c')]({'ListId':{'$ne':_0x27f811[_0xf297('0x5d')]}});}}return db[_0xf297('0x6d')][_0xf297('0x21')](_0x288fed);})[_0xf297('0x17')](function(_0xd77390){if(_0xd77390){return _['omit'](_[_0xf297('0x72')](_0xa01a71[_0xf297('0x35')],function(_0x468b9d,_0xe3bbdd){return _[_0xf297('0x73')](_0xe3bbdd,_0xf297('0x2b'));}),_[_0xf297('0x6f')](_0xd77390,function(_0x98566d){return util[_0xf297('0x70')](_0xf297('0x71'),_0x98566d['id']);}));}})['then'](function(_0xe3095d){if(_0xe3095d&&!_[_0xf297('0x74')](_0xe3095d)){var _0x54e48b=squel[_0xf297('0x16')]()[_0xf297('0x75')](_0xf297('0x76'))[_0xf297('0x77')](_0xe3095d)['where']('id\x20=\x20?',_0xa01a71[_0xf297('0x27')]['id'])[_0xf297('0x78')]();return db[_0xf297('0x69')][_0xf297('0x22')](_0x54e48b['text'],{'replacements':_0x54e48b['values']});}})[_0xf297('0x17')](function(){if(_0xa01a71[_0xf297('0x35')][_0xf297('0x79')]&&_0x45924c){return db[_0xf297('0x3c')]['update']({'phone':_0xa01a71['body'][_0xf297('0x79')],'OrderBy':0x0},{'where':{'ContactId':_0x45924c['id']}});}})[_0xf297('0x17')](function(){return _0x45924c;})[_0xf297('0x17')](respondWithResult(_0x597ebf,null))['catch'](handleError(_0x597ebf,null));};exports[_0xf297('0x7a')]=function(_0x58abc3,_0x4196a1){var _0x4444e8={};var _0x1026b4={};var _0x542354;var _0x8af30e;return db[_0xf297('0x25')][_0xf297('0x7b')]({'where':{'id':_0x58abc3[_0xf297('0x27')]['id']}})[_0xf297('0x17')](handleEntityNotFound(_0x4196a1,null))[_0xf297('0x17')](function(_0x570900){if(_0x570900){_0x542354=_0x570900;_0x1026b4[_0xf297('0x7c')]=_[_0xf297('0x29')](db[_0xf297('0x64')][_0xf297('0x7d')]);_0x1026b4[_0xf297('0x22')]=_[_0xf297('0x29')](_0x58abc3[_0xf297('0x22')]);_0x1026b4[_0xf297('0x7e')]=_[_0xf297('0x7f')](_0x1026b4[_0xf297('0x7c')],_0x1026b4[_0xf297('0x22')]);_0x4444e8['attributes']=_[_0xf297('0x7f')](_0x1026b4[_0xf297('0x7c')],qs[_0xf297('0x80')](_0x58abc3[_0xf297('0x22')][_0xf297('0x80')]));_0x4444e8[_0xf297('0x81')]=_0x4444e8[_0xf297('0x81')][_0xf297('0x2a')]?_0x4444e8[_0xf297('0x81')]:_0x1026b4['model'];_0x4444e8[_0xf297('0x82')]=qs[_0xf297('0x83')](_0x58abc3[_0xf297('0x22')]['sort']);_0x4444e8[_0xf297('0x5a')]=qs[_0xf297('0x7e')](_[_0xf297('0x84')](_0x58abc3[_0xf297('0x22')],_0x1026b4['filters']));if(_0x58abc3[_0xf297('0x22')][_0xf297('0x85')]){_0x4444e8['where']=_[_0xf297('0x86')](_0x4444e8[_0xf297('0x5a')],{'$or':_['map'](_0x4444e8[_0xf297('0x81')],function(_0x2c578c){var _0x552943={};_0x552943[_0x2c578c]={'$like':'%'+_0x58abc3[_0xf297('0x22')][_0xf297('0x85')]+'%'};return _0x552943;})});}_0x4444e8=_[_0xf297('0x86')]({},_0x4444e8,_0x58abc3[_0xf297('0x87')]);return _0x542354['getTags'](_0x4444e8);}})[_0xf297('0x17')](function(_0x3bc2c1){if(_0x3bc2c1){_0x8af30e=_0x3bc2c1['length'];if(!_0x58abc3['query']['hasOwnProperty'](_0xf297('0x88'))){_0x4444e8[_0xf297('0x12')]=qs[_0xf297('0x12')](_0x58abc3['query'][_0xf297('0x12')]);_0x4444e8['offset']=qs[_0xf297('0x11')](_0x58abc3[_0xf297('0x22')]['offset']);}return _0x542354[_0xf297('0x7a')](_0x4444e8);}})[_0xf297('0x17')](function(_0x2ada3e){if(_0x2ada3e){return _0x2ada3e?{'count':_0x8af30e,'rows':_0x2ada3e}:null;}})[_0xf297('0x17')](respondWithResult(_0x4196a1,null))[_0xf297('0x24')](handleError(_0x4196a1,null));};exports[_0xf297('0x89')]=function(_0x42e903,_0x379877){if(_0x42e903['body']['id']){delete _0x42e903['body']['id'];}return db['CmContact'][_0xf297('0x7b')]({'where':{'id':_0x42e903['params']['id']}})['then'](handleEntityNotFound(_0x379877,null))[_0xf297('0x17')](function(_0x3b7cec){if(_0x3b7cec){return _0x3b7cec[_0xf297('0x89')](_0x42e903['body']['ids']||[]);}return null;})[_0xf297('0x17')](respondWithResult(_0x379877,null))[_0xf297('0x24')](handleError(_0x379877,null));};exports['setAdditionalPhones']=function(_0x46fa35,_0x13982c){var _0xcb366f=[];_0xcb366f['push'](addAdditionalPhones(_0x46fa35['body']));Promise[_0xf297('0x62')](_0xcb366f)['then'](function(){_0xcb366f=[];_0xcb366f[_0xf297('0x5c')](deleteCmHopperPhones(_0x46fa35['body']['id']));_0xcb366f['push'](addCmHopperPhones(_0x46fa35['body']['id']));Promise[_0xf297('0x62')](_0xcb366f)[_0xf297('0x17')](function(){return[0x1];})['then'](respondWithResult(_0x13982c,null));});};function addAdditionalPhones(_0x13d695){var _0x362baf;return new Promise(function(_0x20b390){return db[_0xf297('0x67')][_0xf297('0x18')]({'where':{'CmContactId':_0x13d695['id']}})[_0xf297('0x17')](function(){db[_0xf297('0x8a')][_0xf297('0x21')]({'raw':!![],'attributes':['id',_0xf297('0x8b')]})[_0xf297('0x17')](function(_0x5a10eb){var _0x35de35=[];for(var _0x5a55a4=0x0;_0x5a55a4<_0x13d695[_0xf297('0x8c')][_0xf297('0x2a')];_0x5a55a4++){var _0x2773c0=_0x13d695[_0xf297('0x8d')]?_[_0xf297('0x54')](_0x13d695['item_types'][_0x5a55a4])?'':_0x13d695[_0xf297('0x8d')][_0x5a55a4]:_0x13d695['items'][_0x5a55a4]['ItemTypeId']?_0x13d695[_0xf297('0x8c')][_0x5a55a4][_0xf297('0x8e')]:'';var _0x309d76=_['isNil'](_0x13d695['items'][_0x5a55a4][_0xf297('0x8f')])?'':_0x13d695[_0xf297('0x8c')][_0x5a55a4][_0xf297('0x8f')];var _0xd938e=_0x2773c0+':'+_0x13d695[_0xf297('0x8c')][_0x5a55a4][_0xf297('0x79')]+'§'+_0x309d76;if(_[_0xf297('0x54')](_0x362baf))_0x362baf=_0xd938e;else _0x362baf+=';'+_0xd938e;var _0x1c1bbe=null;var _0x26c5d5=null;if(_0x13d695[_0xf297('0x8d')]){if(!_[_0xf297('0x54')](_0x13d695[_0xf297('0x8d')][_0x5a55a4])){_0x26c5d5=_['find'](_0x5a10eb,function(_0x2af8b1){return _0x2af8b1['id']===_0x13d695[_0xf297('0x8d')][_0x5a55a4];});if(!_[_0xf297('0x54')](_0x26c5d5)){_0x1c1bbe=_0x26c5d5[_0xf297('0x8b')];}}}else{if(!_[_0xf297('0x54')](_0x13d695['items'][_0x5a55a4])){_0x26c5d5=_[_0xf297('0x26')](_0x5a10eb,function(_0x376b22){return _0x376b22['id']===_0x13d695[_0xf297('0x8c')][_0x5a55a4][_0xf297('0x8e')];});if(!_[_0xf297('0x54')](_0x26c5d5)){_0x1c1bbe=_0x5a55a4;}}}if(_[_0xf297('0x54')](_0x1c1bbe)){_0x1c1bbe=0x64;}_0x35de35[_0xf297('0x5c')](addAdditionalPhone(_0x13d695['id'],_0x13d695[_0xf297('0x8c')][_0x5a55a4][_0xf297('0x79')],_0x13d695['item_types']?_[_0xf297('0x54')](_0x13d695['item_types'][_0x5a55a4])?null:_0x13d695[_0xf297('0x8d')][_0x5a55a4]:_0x13d695[_0xf297('0x8c')][_0x5a55a4][_0xf297('0x8e')]?_0x13d695[_0xf297('0x8c')][_0x5a55a4][_0xf297('0x8e')]:null,_0x1c1bbe,_0x309d76));}Promise[_0xf297('0x62')](_0x35de35)[_0xf297('0x17')](function(){db[_0xf297('0x25')][_0xf297('0x16')]({'AdditionalPhones':_0x362baf},{'where':{'id':_0x13d695['id']}})[_0xf297('0x17')](function(){_0x20b390(0x1);});});});});});}function addAdditionalPhone(_0x394969,_0x48b590,_0x5aec99,_0xa7403d,_0x274f51){return db[_0xf297('0x67')][_0xf297('0x26')]({'where':{'CmContactId':_0x394969,'item':_0x48b590}})['then'](function(_0x555810){if(_0x555810)logger[_0xf297('0x32')](_0xf297('0x90'),_0x555810);else{db[_0xf297('0x67')][_0xf297('0x3f')]({'CmContactId':_0x394969,'item':_0x48b590,'ItemTypeId':_0x5aec99,'OrderBy':_0xa7403d,'ItemClass':'PHONE','description':_0x274f51});}});}function deleteCmHopperPhones(_0x2527b2){return new Promise(function(_0x5be607){return db[_0xf297('0x3c')][_0xf297('0x21')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x2527b2}})[_0xf297('0x17')](function(_0x36d188){db['CmHopperAdditionalPhone'][_0xf297('0x18')]({'where':{'CmHopperId':{'$in':_[_0xf297('0x6f')](_0x36d188,'id')}}});})[_0xf297('0x17')](function(){_0x5be607(0x1);});});}function addCmHopperPhones(_0x185d72){return new Promise(function(_0x4d7b2d){return db[_0xf297('0x3c')][_0xf297('0x21')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x185d72}})[_0xf297('0x17')](function(_0x4ae777){var _0x166f74=[];_[_0xf297('0x6f')](_0x4ae777,function(_0x10ea7b){_0x166f74[_0xf297('0x5c')](createCmHopperPhone(_0x185d72,_0x10ea7b['id']));});Promise['all'](_0x166f74)[_0xf297('0x17')](function(){_0x4d7b2d(0x1);});});});}function createCmHopperPhone(_0x544177,_0x3ca9cb){return new Promise(function(_0x3514a9){db[_0xf297('0x67')][_0xf297('0x21')]({'raw':!![],'attributes':[_0xf297('0x91'),_0xf297('0x8b')],'where':{'CmContactId':_0x544177,'ItemClass':_0xf297('0x92')},'include':[{'model':db[_0xf297('0x8a')],'attributes':['OrderBy'],'as':_0xf297('0x68')}],'order':[_0xf297('0x8b'),db[_0xf297('0x69')][_0xf297('0x6a')](_0xf297('0x93'))]})[_0xf297('0x17')](function(_0x11049d){var _0x2f6ade=0x1;var _0x1d9672=_['map'](_0x11049d,function(_0x36ddc0){_0x36ddc0[_0xf297('0x94')]=_0x3ca9cb;_0x36ddc0[_0xf297('0x79')]=_0x36ddc0[_0xf297('0x91')];_0x36ddc0[_0xf297('0x8b')]=_0x2f6ade;delete _0x36ddc0[_0xf297('0x95')];_0x2f6ade=_0x2f6ade+0x1;return _0x36ddc0;});return db[_0xf297('0x96')]['bulkCreate'](_0x1d9672,{});})[_0xf297('0x17')](function(){_0x3514a9(0x1);});});}function insertAdditionalPhones(_0x8f16a0,_0x310613){return new Promise(function(_0x48b2de){var _0x3f8cbf=[];for(var _0x1bc567=0x0;_0x1bc567<_0x310613[_0xf297('0x2a')];_0x1bc567++){var _0x43c1f5=_0x310613[_0x1bc567];_0x3f8cbf[_0xf297('0x5c')](parseContactItemType(_0x43c1f5));}Promise['all'](_0x3f8cbf)[_0xf297('0x17')](function(){var _0x5b92ab={'id':_0x8f16a0['id'],'items':_0x310613};return addAdditionalPhones(_0x5b92ab)[_0xf297('0x17')](function(){return addCmHopperPhones(_0x8f16a0['id']);});})['then'](function(){_0x48b2de(_0x8f16a0);});});}function parseContactItemType(_0x34ce70){return new Promise(function(_0x2a0d86){if(_0x34ce70[_0xf297('0x60')](_0xf297('0x8e'))){_0x2a0d86(_0x34ce70);}else{return db[_0xf297('0x8a')][_0xf297('0x26')]({'where':{'name':_0x34ce70[_0xf297('0x68')]}})[_0xf297('0x17')](function(_0x1296eb){if(_[_0xf297('0x54')](_0x1296eb))_0x34ce70[_0xf297('0x8e')]=null;else _0x34ce70[_0xf297('0x8e')]=_0x1296eb['id'];_0x2a0d86(_0x34ce70);});}});}exports['getAdditionalPhones']=function(_0x52514f,_0x2ce788){return db[_0xf297('0x67')][_0xf297('0x21')]({'raw':!![],'where':{'CmContactId':_0x52514f[_0xf297('0x27')]['id'],'ItemClass':_0xf297('0x92')},'include':[{'model':db[_0xf297('0x8a')],'as':_0xf297('0x68')}],'order':[['OrderBy'],[db[_0xf297('0x69')][_0xf297('0x6a')](_0xf297('0x93'))]]})[_0xf297('0x17')](function(_0x355462){return _0x355462;})[_0xf297('0x17')](respondWithResult(_0x2ce788,null))['catch'](handleError(_0x2ce788,null));};exports[_0xf297('0x97')]=function(_0x57429e,_0x45adef){return db[_0xf297('0x67')][_0xf297('0x21')]({'raw':!![],'where':{'CmContactId':_0x57429e['body'][_0xf297('0x98')]}})[_0xf297('0x17')](function(_0x2c3b9e){var _0x4e5de7=_['map'](_0x2c3b9e,function(_0x378e6b){_0x378e6b[_0xf297('0x99')]=_0x57429e[_0xf297('0x35')][_0xf297('0x9a')];return _0x378e6b;});return db['CmContactHasItem'][_0xf297('0x9b')](_0x4e5de7,{});})[_0xf297('0x17')](function(){return addCmHopperPhones(_0x57429e[_0xf297('0x35')][_0xf297('0x9a')]);})[_0xf297('0x17')](function(){return['ok'];})[_0xf297('0x17')](respondWithResult(_0x45adef,null))['catch'](handleError(_0x45adef,null));};exports[_0xf297('0x9c')]=function(_0x4c6006,_0x1631c7){var _0x37fc5a=[];_0x37fc5a[_0xf297('0x5c')](createCmHopperPhone(_0x4c6006['body']['id'],_0x4c6006[_0xf297('0x35')][_0xf297('0x9d')]));Promise[_0xf297('0x62')](_0x37fc5a)[_0xf297('0x17')](function(){return[0x1];})[_0xf297('0x17')](respondWithResult(_0x1631c7,null));};exports['getHoppers']=function(_0x54e539,_0x284eb0){var _0x3cd9d1={'raw':![],'where':{}};var _0x369b56={};var _0x49913b={'count':0x0,'rows':[]};return db[_0xf297('0x25')][_0xf297('0x7b')]({'where':{'id':_0x54e539['params']['id']}})[_0xf297('0x17')](handleEntityNotFound(_0x284eb0,null))[_0xf297('0x17')](function(_0x44014a){if(_0x44014a){_0x369b56[_0xf297('0x7c')]=_['keys'](db[_0xf297('0x3c')][_0xf297('0x7d')]);_0x369b56[_0xf297('0x22')]=_[_0xf297('0x29')](_0x54e539[_0xf297('0x22')]);_0x369b56[_0xf297('0x7e')]=_[_0xf297('0x7f')](_0x369b56[_0xf297('0x7c')],_0x369b56[_0xf297('0x22')]);_0x3cd9d1[_0xf297('0x81')]=_[_0xf297('0x7f')](_0x369b56['model'],qs[_0xf297('0x80')](_0x54e539[_0xf297('0x22')][_0xf297('0x80')]));_0x3cd9d1[_0xf297('0x81')]=_0x3cd9d1[_0xf297('0x81')][_0xf297('0x2a')]?_0x3cd9d1[_0xf297('0x81')]:_0x369b56[_0xf297('0x7c')];if(!_0x54e539['query']['hasOwnProperty']('nolimit')){_0x3cd9d1['limit']=qs[_0xf297('0x12')](_0x54e539[_0xf297('0x22')][_0xf297('0x12')]);_0x3cd9d1[_0xf297('0x11')]=qs[_0xf297('0x11')](_0x54e539[_0xf297('0x22')][_0xf297('0x11')]);}_0x3cd9d1[_0xf297('0x82')]=qs[_0xf297('0x83')](_0x54e539[_0xf297('0x22')][_0xf297('0x83')]);_0x3cd9d1[_0xf297('0x5a')]=qs['filters'](_[_0xf297('0x84')](_0x54e539[_0xf297('0x22')],_0x369b56[_0xf297('0x7e')]));_0x3cd9d1[_0xf297('0x5a')][_0xf297('0x9e')]=_0x44014a['id'];if(_0x54e539[_0xf297('0x22')][_0xf297('0x85')]){_0x3cd9d1[_0xf297('0x5a')]=_[_0xf297('0x86')](_0x3cd9d1['where'],{'$or':_[_0xf297('0x6f')](_0x3cd9d1[_0xf297('0x81')],function(_0x59eb4a){var _0x479713={};_0x479713[_0x59eb4a]={'$like':'%'+_0x54e539[_0xf297('0x22')][_0xf297('0x85')]+'%'};return _0x479713;})});}_0x3cd9d1=_['merge']({},_0x3cd9d1,_0x54e539[_0xf297('0x87')]);return db[_0xf297('0x3c')][_0xf297('0x14')]({'where':_0x3cd9d1['where']})[_0xf297('0x17')](function(_0xfb3ad9){_0x49913b[_0xf297('0x14')]=_0xfb3ad9;if(_0x54e539[_0xf297('0x22')][_0xf297('0x9f')]){_0x3cd9d1[_0xf297('0xa0')]=[{'all':!![]}];}return db['CmHopper'][_0xf297('0x21')](_0x3cd9d1);})[_0xf297('0x17')](function(_0x199e77){_0x49913b[_0xf297('0xa1')]=_0x199e77;return _0x49913b;});}})[_0xf297('0x17')](respondWithFilteredResult(_0x284eb0,_0x3cd9d1))['catch'](handleError(_0x284eb0,null));};exports['getHopperHistories']=function(_0x3d3f18,_0x438eb2){var _0x1b2bce={'raw':!![],'where':{}};var _0x5b5cb0={};var _0x453dbb={'count':0x0,'rows':[]};return db['CmContact'][_0xf297('0x7b')]({'where':{'id':_0x3d3f18[_0xf297('0x27')]['id']}})[_0xf297('0x17')](handleEntityNotFound(_0x438eb2,null))[_0xf297('0x17')](function(_0x2a60b2){if(_0x2a60b2){_0x5b5cb0['model']=_['keys'](db['CmHopperHistory'][_0xf297('0x7d')]);_0x5b5cb0[_0xf297('0x22')]=_[_0xf297('0x29')](_0x3d3f18[_0xf297('0x22')]);_0x5b5cb0['filters']=_[_0xf297('0x7f')](_0x5b5cb0[_0xf297('0x7c')],_0x5b5cb0[_0xf297('0x22')]);_0x1b2bce[_0xf297('0x81')]=_[_0xf297('0x7f')](_0x5b5cb0[_0xf297('0x7c')],qs[_0xf297('0x80')](_0x3d3f18['query'][_0xf297('0x80')]));_0x1b2bce[_0xf297('0x81')]=_0x1b2bce[_0xf297('0x81')][_0xf297('0x2a')]?_0x1b2bce[_0xf297('0x81')]:_0x5b5cb0[_0xf297('0x7c')];if(!_0x3d3f18[_0xf297('0x22')]['hasOwnProperty']('nolimit')){_0x1b2bce[_0xf297('0x12')]=qs[_0xf297('0x12')](_0x3d3f18[_0xf297('0x22')][_0xf297('0x12')]);_0x1b2bce[_0xf297('0x11')]=qs[_0xf297('0x11')](_0x3d3f18['query'][_0xf297('0x11')]);}_0x1b2bce[_0xf297('0x82')]=qs[_0xf297('0x83')](_0x3d3f18[_0xf297('0x22')][_0xf297('0x83')]);_0x1b2bce[_0xf297('0x5a')]=qs['filters'](_[_0xf297('0x84')](_0x3d3f18['query'],_0x5b5cb0['filters']));_0x1b2bce[_0xf297('0x5a')]['ContactId']=_0x2a60b2['id'];if(_0x3d3f18['query'][_0xf297('0x85')]){_0x1b2bce['where']=_[_0xf297('0x86')](_0x1b2bce['where'],{'$or':_[_0xf297('0x6f')](_0x1b2bce['attributes'],function(_0x45cbb4){var _0x3d01fd={};_0x3d01fd[_0x45cbb4]={'$like':'%'+_0x3d3f18[_0xf297('0x22')][_0xf297('0x85')]+'%'};return _0x3d01fd;})});}_0x1b2bce=_['merge']({},_0x1b2bce,_0x3d3f18[_0xf297('0x87')]);return db['CmHopperHistory'][_0xf297('0x14')]({'where':_0x1b2bce[_0xf297('0x5a')]})[_0xf297('0x17')](function(_0x171fc8){_0x453dbb[_0xf297('0x14')]=_0x171fc8;if(_0x3d3f18['query'][_0xf297('0x9f')]){_0x1b2bce[_0xf297('0xa0')]=[{'all':!![]}];}return db['CmHopperHistory']['findAll'](_0x1b2bce);})['then'](function(_0x5768ef){_0x453dbb['rows']=_0x5768ef;return _0x453dbb;});}})['then'](respondWithFilteredResult(_0x438eb2,_0x1b2bce))['catch'](handleError(_0x438eb2,null));};exports[_0xf297('0xa2')]=function(_0x184d62,_0xa0666b){var _0x12d3b1={'raw':!![],'where':{}};var _0x2ed16a={};var _0x5ce97b={'count':0x0,'rows':[]};return db[_0xf297('0x25')][_0xf297('0x7b')]({'where':{'id':_0x184d62[_0xf297('0x27')]['id']}})[_0xf297('0x17')](handleEntityNotFound(_0xa0666b,null))['then'](function(_0x5968b9){if(_0x5968b9){_0x2ed16a['model']=_[_0xf297('0x29')](db['CmHopperFinal'][_0xf297('0x7d')]);_0x2ed16a[_0xf297('0x22')]=_[_0xf297('0x29')](_0x184d62['query']);_0x2ed16a[_0xf297('0x7e')]=_[_0xf297('0x7f')](_0x2ed16a[_0xf297('0x7c')],_0x2ed16a[_0xf297('0x22')]);_0x12d3b1['attributes']=_[_0xf297('0x7f')](_0x2ed16a[_0xf297('0x7c')],qs['fields'](_0x184d62[_0xf297('0x22')][_0xf297('0x80')]));_0x12d3b1[_0xf297('0x81')]=_0x12d3b1[_0xf297('0x81')]['length']?_0x12d3b1[_0xf297('0x81')]:_0x2ed16a[_0xf297('0x7c')];if(!_0x184d62[_0xf297('0x22')][_0xf297('0x60')](_0xf297('0x88'))){_0x12d3b1[_0xf297('0x12')]=qs[_0xf297('0x12')](_0x184d62[_0xf297('0x22')]['limit']);_0x12d3b1[_0xf297('0x11')]=qs[_0xf297('0x11')](_0x184d62['query'][_0xf297('0x11')]);}_0x12d3b1['order']=qs[_0xf297('0x83')](_0x184d62[_0xf297('0x22')][_0xf297('0x83')]);_0x12d3b1[_0xf297('0x5a')]=qs[_0xf297('0x7e')](_[_0xf297('0x84')](_0x184d62[_0xf297('0x22')],_0x2ed16a[_0xf297('0x7e')]));_0x12d3b1[_0xf297('0x5a')][_0xf297('0x9e')]=_0x5968b9['id'];if(_0x184d62[_0xf297('0x22')][_0xf297('0x85')]){_0x12d3b1[_0xf297('0x5a')]=_[_0xf297('0x86')](_0x12d3b1[_0xf297('0x5a')],{'$or':_[_0xf297('0x6f')](_0x12d3b1[_0xf297('0x81')],function(_0x2d6aa8){var _0x20bf3f={};_0x20bf3f[_0x2d6aa8]={'$like':'%'+_0x184d62['query'][_0xf297('0x85')]+'%'};return _0x20bf3f;})});}_0x12d3b1=_[_0xf297('0x86')]({},_0x12d3b1,_0x184d62[_0xf297('0x87')]);return db['CmHopperFinal'][_0xf297('0x14')]({'where':_0x12d3b1[_0xf297('0x5a')]})[_0xf297('0x17')](function(_0x67388a){_0x5ce97b['count']=_0x67388a;if(_0x184d62[_0xf297('0x22')][_0xf297('0x9f')]){_0x12d3b1[_0xf297('0xa0')]=[{'all':!![]}];}return db[_0xf297('0xa3')]['findAll'](_0x12d3b1);})[_0xf297('0x17')](function(_0x35ea58){_0x5ce97b[_0xf297('0xa1')]=_0x35ea58;return _0x5ce97b;});}})[_0xf297('0x17')](respondWithFilteredResult(_0xa0666b,_0x12d3b1))[_0xf297('0x24')](handleError(_0xa0666b,null));};exports[_0xf297('0xa4')]=function(_0x3da231,_0x53d81a){var _0x413f30={'raw':!![],'where':{}};var _0x426186={};var _0x84f41c={'count':0x0,'rows':[]};return db[_0xf297('0x25')]['findOne']({'where':{'id':_0x3da231[_0xf297('0x27')]['id']}})[_0xf297('0x17')](handleEntityNotFound(_0x53d81a,null))['then'](function(_0xa928c1){if(_0xa928c1){_0x426186[_0xf297('0x7c')]=_['keys'](db['JscriptySessionReport'][_0xf297('0x7d')]);_0x426186[_0xf297('0x22')]=_['keys'](_0x3da231['query']);_0x426186[_0xf297('0x7e')]=_[_0xf297('0x7f')](_0x426186[_0xf297('0x7c')],_0x426186[_0xf297('0x22')]);_0x413f30[_0xf297('0x81')]=_[_0xf297('0x7f')](_0x426186[_0xf297('0x7c')],qs[_0xf297('0x80')](_0x3da231['query'][_0xf297('0x80')]));_0x413f30[_0xf297('0x81')]=_0x413f30[_0xf297('0x81')][_0xf297('0x2a')]?_0x413f30[_0xf297('0x81')]:_0x426186[_0xf297('0x7c')];if(!_0x3da231[_0xf297('0x22')]['hasOwnProperty'](_0xf297('0x88'))){_0x413f30[_0xf297('0x12')]=qs[_0xf297('0x12')](_0x3da231[_0xf297('0x22')]['limit']);_0x413f30[_0xf297('0x11')]=qs[_0xf297('0x11')](_0x3da231[_0xf297('0x22')][_0xf297('0x11')]);}_0x413f30[_0xf297('0x82')]=qs[_0xf297('0x83')](_0x3da231[_0xf297('0x22')]['sort']);_0x413f30[_0xf297('0x5a')]=qs[_0xf297('0x7e')](_[_0xf297('0x84')](_0x3da231[_0xf297('0x22')],_0x426186[_0xf297('0x7e')]));_0x413f30[_0xf297('0x5a')][_0xf297('0x9e')]=_0xa928c1['id'];if(_0x3da231[_0xf297('0x22')][_0xf297('0x85')]){_0x413f30[_0xf297('0x5a')]=_[_0xf297('0x86')](_0x413f30[_0xf297('0x5a')],{'$or':_['map'](_0x413f30[_0xf297('0x81')],function(_0xf6dea3){var _0x36e999={};_0x36e999[_0xf6dea3]={'$like':'%'+_0x3da231[_0xf297('0x22')][_0xf297('0x85')]+'%'};return _0x36e999;})});}_0x413f30=_[_0xf297('0x86')]({},_0x413f30,_0x3da231['options']);return db[_0xf297('0x50')]['count']({'where':_0x413f30['where']})[_0xf297('0x17')](function(_0x4b7827){_0x84f41c[_0xf297('0x14')]=_0x4b7827;if(_0x3da231['query'][_0xf297('0x9f')]){_0x413f30[_0xf297('0xa0')]=[{'all':!![]}];}return db[_0xf297('0x50')][_0xf297('0x21')](_0x413f30);})['then'](function(_0x204f0a){_0x84f41c[_0xf297('0xa1')]=_0x204f0a;return _0x84f41c;});}})[_0xf297('0x17')](respondWithFilteredResult(_0x53d81a,_0x413f30))[_0xf297('0x24')](handleError(_0x53d81a,null));};exports[_0xf297('0xa5')]=function(_0x492ad7,_0x6fdaa8){try{if(!_0x492ad7[_0xf297('0x35')][_0xf297('0x5d')]){throw new Error(_0xf297('0xa6'));}if(!_0x492ad7[_0xf297('0x35')][_0xf297('0xa7')]){throw new Error('No\x20association\x20keys\x20specified!');}if(!_0x492ad7[_0xf297('0x35')]['binding_values']){throw new Error('No\x20association\x20values\x20specified!');}if(!_0x492ad7[_0xf297('0x35')][_0xf297('0xa8')]){throw new Error(_0xf297('0xa9'));}var _0xf05551=_0x492ad7[_0xf297('0x35')][_0xf297('0xa7')][_0xf297('0xaa')](',');var _0x49d741=_0x492ad7[_0xf297('0x35')][_0xf297('0xab')][_0xf297('0xaa')](',');if(!_0xf05551['length']||!_0x49d741[_0xf297('0x2a')]||_0xf05551[_0xf297('0x2a')]!==_0x49d741['length']){throw new Error(_0xf297('0xac'));}_0x492ad7[_0xf297('0x35')][_0xf297('0x80')]=_[_0xf297('0xad')](_0xf05551,_0x49d741);if(!_0x492ad7[_0xf297('0x35')][_0xf297('0x80')][_0xf297('0x79')]){throw new Error(_0xf297('0xae'));}if(!_0x492ad7[_0xf297('0x35')][_0xf297('0x80')][_0xf297('0xaf')]){throw new Error(_0xf297('0xb0'));}var _0x18856c=path[_0xf297('0x3a')](config[_0xf297('0xb1')],_0xf297('0xb2'),_0x492ad7[_0xf297('0xb3')][_0xf297('0xb4')]);fs['chmodSync'](_0x18856c,parseInt(_0xf297('0xb5'),0x8));var _0x18019b=require(_0xf297('0xb6'))[_0xf297('0xb7')](path[_0xf297('0x3a')](__dirname,_0xf297('0xb8')),[_0x18856c,_0x492ad7['body'][_0xf297('0xa7')],_0x492ad7[_0xf297('0x35')][_0xf297('0xab')],_0x492ad7[_0xf297('0x35')][_0xf297('0x5d')],_0x492ad7[_0xf297('0x35')][_0xf297('0xb9')],_0x492ad7[_0xf297('0x35')][_0xf297('0x59')],_0x492ad7[_0xf297('0x35')][_0xf297('0xa8')]]);return _0x6fdaa8['status'](0xc8)['json']({'message':'File\x20uploaded\x20correctly!','pid':_0x18019b[_0xf297('0xba')]});}catch(_0x561577){return _0x6fdaa8[_0xf297('0xf')](0x1f4)['send'](_0x561577);}};exports['upload']=function(_0x4e1a45,_0x5525cd){var _0x4fb08b=fs[_0xf297('0xbb')](_0x4e1a45[_0xf297('0xb3')][_0xf297('0xbc')]);Papa[_0xf297('0xbd')](_0x4fb08b,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x1780c9){return _0x5525cd[_0xf297('0xf')](0xc8)[_0xf297('0x10')]({'file':_0x4e1a45['file'],'fields':_0x1780c9[_0xf297('0xbe')][_0xf297('0x80')]});}});};exports[_0xf297('0xbf')]=function(_0x5d577d,_0x3bb09a){return db[_0xf297('0xc0')][_0xf297('0x21')]({'raw':!![],'attributes':['id'],'where':{'role':_0xf297('0xc1')}})[_0xf297('0x17')](function(_0x52458a){var _0x123d2b=![];if(!_0x5d577d[_0xf297('0x35')][_0xf297('0x5d')]){throw new Error(_0xf297('0xa6'));}if(!_0x5d577d['body'][_0xf297('0xc2')][_0xf297('0x79')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x5d577d[_0xf297('0x35')]['binding'][_0xf297('0xaf')]){throw new Error(_0xf297('0xb0'));}if(!_0x5d577d[_0xf297('0x35')][_0xf297('0xa8')]){throw new Error(_0xf297('0xa9'));}var _0x2c3946=require(_0xf297('0xb6'))[_0xf297('0xb7')](path[_0xf297('0x3a')](__dirname,_0xf297('0xc3')),[_0x5d577d['params']['id'],JSON[_0xf297('0xc4')](_0x5d577d[_0xf297('0x35')]),JSON[_0xf297('0xc4')](_0x52458a)]);_0x2c3946['on'](_0xf297('0xc5'),function(){_0x123d2b=!![];return _0x3bb09a[_0xf297('0xf')](0xc8)[_0xf297('0x10')]({'message':_0xf297('0xc6'),'pid':_0x2c3946[_0xf297('0xba')]});});_0x2c3946['on'](_0xf297('0xc7'),function(_0xa8372f){if(_0xa8372f&&!_0x123d2b){return _0x3bb09a['status'](0x1f4)['json']({'message':_0xf297('0xc8'),'pid':_0x2c3946[_0xf297('0xba')]});}});})[_0xf297('0x24')](handleError(_0x3bb09a,null));};exports['importUpdates']=function(_0x456abe,_0xc48245){return db[_0xf297('0xc0')][_0xf297('0x21')]({'raw':!![],'attributes':['id'],'where':{'role':_0xf297('0xc1')}})['then'](function(_0x3b8563){var _0x3dd159=![];if(!_0x456abe[_0xf297('0x35')]['ListId']){throw new Error(_0xf297('0xa6'));}if(!_0x456abe[_0xf297('0x35')][_0xf297('0xc2')][_0xf297('0x79')]){throw new Error(_0xf297('0xae'));}if(!_0x456abe[_0xf297('0x35')][_0xf297('0xc2')][_0xf297('0xaf')]){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x456abe[_0xf297('0x35')][_0xf297('0xa8')]){throw new Error(_0xf297('0xa9'));}var _0x4a2b26=require(_0xf297('0xb6'))[_0xf297('0xb7')](path[_0xf297('0x3a')](__dirname,_0xf297('0xc9')),[_0x456abe[_0xf297('0x27')]['id'],JSON[_0xf297('0xc4')](_0x456abe['body']),JSON[_0xf297('0xc4')](_0x3b8563)]);_0x4a2b26['on'](_0xf297('0xc5'),function(){_0x3dd159=!![];return _0xc48245['status'](0xc8)[_0xf297('0x10')]({'message':'start\x20child\x20process\x20correctly!','pid':_0x4a2b26[_0xf297('0xba')]});});_0x4a2b26['on'](_0xf297('0xc7'),function(_0x4992d4){if(_0x4992d4&&!_0x3dd159){return _0xc48245[_0xf297('0xf')](0x1f4)[_0xf297('0x10')]({'message':_0xf297('0xc8'),'pid':_0x4a2b26['pid']});}});})[_0xf297('0x24')](handleError(_0xc48245,null));};exports[_0xf297('0xca')]=function(_0x4760b4,_0x2a1c8b){var _0xca5208=[_0xf297('0xcb'),_0xf297('0xcc'),_0xf297('0xcd'),_0xf297('0xce'),_0xf297('0xcf'),_0xf297('0xd0'),_0xf297('0xd1')];var _0x30b78d={'offset':0x0,'order':qs[_0xf297('0x83')](_0xf297('0xd2'))},_0xcd6968={'count':0x0,'rows':[]};Promise[_0xf297('0xd3')]()[_0xf297('0x17')](function(){if(_0x4760b4[_0xf297('0x22')][_0xf297('0xd4')]){if(!_['includes'](_0xca5208,_0x4760b4[_0xf297('0x22')][_0xf297('0xd4')][_0xf297('0xd5')]())){throw new Error('Invalid\x20channel');}_0xca5208=[_0x4760b4[_0xf297('0x22')][_0xf297('0xd4')][_0xf297('0xd5')]()];}if(_0x4760b4['query'][_0xf297('0xd6')]){try{var _0x6ed5df=JSON[_0xf297('0xbd')](_0x4760b4[_0xf297('0x22')]['range']);if(!moment(_0x6ed5df['from'])[_0xf297('0xd7')]()){throw new Error(_0xf297('0xd8'));}if(!moment(_0x6ed5df['to'])['isValid']()){throw new Error(_0xf297('0xd9'));}}catch(_0x20fe90){throw new Error(_0xf297('0xda'));}}if(!_0x4760b4['query'][_0xf297('0x60')](_0xf297('0x88'))){_0x30b78d[_0xf297('0x12')]=qs['limit'](_0x4760b4['query']['limit']||0xa);_0x30b78d['offset']=qs['offset'](_0x4760b4[_0xf297('0x22')][_0xf297('0x11')]);}var _0x26edc0=_0xca5208[_0xf297('0x6f')](function(_0x4c210c){if(_0x4c210c===_0xf297('0xd1')){var _0x4cbddd={'attributes':['id','uniqueid',_0xf297('0xdb'),_0xf297('0xdc'),'destination',_0xf297('0xdd'),'starttime',_0xf297('0xde'),'duration',_0xf297('0xdf'),_0xf297('0xe0'),'userDisposition',_0xf297('0xe1'),_0xf297('0xe2'),_0xf297('0xe3')],'where':{'ContactId':_0x4760b4[_0xf297('0x27')]['id']},'include':[{'model':db['User'],'as':_0xf297('0xc0'),'attributes':['id','name',_0xf297('0xe4'),'alias']}],'order':[[_0xf297('0xe0'),'DESC']]};if(_0x4760b4[_0xf297('0x22')][_0xf297('0xd6')]){_0x4cbddd[_0xf297('0x5a')]['createdAt']={'$gte':_0x6ed5df[_0xf297('0x36')],'$lte':_0x6ed5df['to']};}return db['VoiceCallReport'][_0xf297('0xe5')](_0x4cbddd)[_0xf297('0x17')](function(_0x24ef8a){_0xcd6968['count']+=_0x24ef8a[_0xf297('0x14')];return _[_0xf297('0x6f')](_0x24ef8a['rows'],function(_0x1c029a){var _0x1f1591=_0x1c029a[_0xf297('0x37')]({'plain':!![]});_0x1f1591[_0xf297('0xd4')]=_0x4c210c;if(_0x1f1591[_0xf297('0xc0')]){_0x1f1591[_0xf297('0xc0')]={'id':_0x1f1591[_0xf297('0xc0')]['id'],'name':_0x1f1591[_0xf297('0xc0')][_0xf297('0x1c')],'fullname':_0x1f1591[_0xf297('0xc0')][_0xf297('0xe4')],'alias':_0x1f1591[_0xf297('0xc0')][_0xf297('0x2f')]};}return _0x1f1591;});});}else{var _0x3b6c20=_[_0xf297('0xe6')](_0x4c210c)+(_0x4c210c==='chat'?'Website':_0xf297('0xe7'));var _0x389836={'attributes':['id',_0xf297('0xe8'),_0xf297('0xe9'),_0xf297('0xe0'),_0xf297('0xdf'),_0xf297('0xea'),_0xf297('0xeb'),_0xf297('0xec'),_0xf297('0xe3'),_0x3b6c20+'Id'],'where':{'ContactId':_0x4760b4[_0xf297('0x27')]['id']},'include':[{'model':db[_0x3b6c20],'as':_0xf297('0xe7'),'attributes':['id','name',_0xf297('0xed')]},{'model':db[_0xf297('0xc0')],'as':_0xf297('0xee'),'attributes':['id','name',_0xf297('0xe4')]},{'model':db[_0xf297('0x64')],'as':_0xf297('0x65'),'attributes':['id',_0xf297('0x1c'),'color'],'through':{'attributes':[]}}],'order':[['createdAt',_0xf297('0xef')]]};if(_0x4760b4['query']['range']){_0x389836['where'][_0xf297('0xe0')]={'$gte':_0x6ed5df[_0xf297('0x36')],'$lte':_0x6ed5df['to']};}switch(_0x4c210c){case _0xf297('0xcc'):_0x389836['attributes'][_0xf297('0x5c')]('browserName',_0xf297('0xf0'),_0xf297('0xf1'),_0xf297('0xf2'),_0xf297('0xf3'),'ratingMessage',_0xf297('0xf4'),_0xf297('0xf5'),_0xf297('0xf6'));break;case _0xf297('0xcb'):_0x389836['attributes'][_0xf297('0x5c')](_0xf297('0xf7'),_0xf297('0xf8'));break;case _0xf297('0xce'):_0x389836[_0xf297('0x81')]['push'](_0xf297('0xf9'),_0xf297('0xfa'));break;}return db[_[_0xf297('0xe6')](_0x4c210c)+_0xf297('0xfb')][_0xf297('0xe5')](_0x389836)[_0xf297('0x17')](function(_0x2f0ae1){_0xcd6968['count']+=_0x2f0ae1['count'];return _[_0xf297('0x6f')](_0x2f0ae1[_0xf297('0xa1')],function(_0x35d8e9){var _0x1b9662=_0x35d8e9[_0xf297('0x37')]({'plain':!![]});_0x1b9662[_0xf297('0xd4')]=_0x4c210c;if(_0x1b9662[_0xf297('0xee')]){_0x1b9662['Owner']={'id':_0x1b9662[_0xf297('0xee')]['id'],'name':_0x1b9662['Owner'][_0xf297('0x1c')],'fullname':_0x1b9662[_0xf297('0xee')][_0xf297('0xe4')]};}return _0x1b9662;});});}});return Promise[_0xf297('0x62')](_0x26edc0);})['then'](function(_0x5191b0){return _(_0x5191b0)['flatten']()[_0xf297('0xfc')](_0xf297('0xe0'))[_0xf297('0xfd')]()[_0xf297('0xfe')]();})[_0xf297('0x17')](function(_0x1f6499){_0xcd6968['rows']=_0x30b78d[_0xf297('0x12')]?_0x1f6499[_0xf297('0xff')](_0x30b78d[_0xf297('0x11')],_0x30b78d[_0xf297('0x11')]+_0x30b78d[_0xf297('0x12')]):_0x1f6499;return _0xcd6968;})[_0xf297('0x17')](respondWithFilteredResult(_0x2a1c8b,_0x30b78d))[_0xf297('0x24')](handleError(_0x2a1c8b,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff