// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xc8f1=['order','sort','pick','filter','merge','options','setTags','setAdditionalPhones','OrderBy','items','item_types','description','ItemTypeId','contact\x20phone\x20exists','CmHopperAdditionalPhone','item','PHONE','`ItemType`.OrderBy','CmHopperId','ItemType.OrderBy','getAdditionalPhones','duplicateAdditionalPhones','fromContactId','CmContactId','toContactId','rescheduleAdditionalPhones','hopperId','getHoppers','rawAttributes','nolimit','ContactId','includeAll','include','rows','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','No\x20association\x20keys\x20specified!','No\x20association\x20values\x20specified!','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','binding_keys','split','binding_values','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','firstName','root','server/files/tmp','file','filename','chmodSync','0777','child_process','fork','../../components/import/cm/csv','CompanyId','socket_timestamp','File\x20uploaded\x20correctly!','pid','upload','createReadStream','parse','import','User','agent','binding','../../components/import/cm/csv2','stringify','start\x20child\x20process\x20correctly!','exit','error\x20child\x20process','importUpdates','No\x20firstName\x20column\x20specified','../../components/import/cm/csvUpdates','getJourney','sms','openchannel','fax','whatsapp','voice','resolve','channel','includes','toLowerCase','Invalid\x20channel','range','isValid','Invalid\x20date\x20for\x20range\x20from\x20filter','Invalid\x20createdAt\x20filter','source','destination','callerid','starttime','duration','note','createdAt','userDisposition','userSecondDisposition','userThirdDisposition','UserId','fullname','DESC','findAndCountAll','startCase','chat','Account','closed','closedAt','disposition','secondDisposition','thirdDisposition','key','Owner','Tags','browserName','customerPort','deviceModel','ratingMessage','ratingValue','referer','mail','subject','externalUrl','threadId','Interaction','sortBy','reverse','value','util','path','papaparse','ioredis','../../components/contacts','../../components/parsers/qs','../../config/logger','api','../../config/environment','../../config/environment/shared','../../mysqldb','redis','defaults','localhost','socket.io-emitter','status','json','offset','limit','undefined','count','set','Content-Range','update','then','destroy','end','sendStatus','error','stack','name','send','index','describe','getOptions','findAll','user','CmContact','find','params','catch','tags','keys','length','cf_','displayName','query','analytics','columnName','alias','custom','type','values','info','Custom\x20field\x20%s\x20not\x20found\x20on\x20cm_contacts\x20table','hasOwnProperty','body','from','get','mergeWith','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','create','ChatInteraction','ChatMessage','MailInteraction','MailMessage','FaxInteraction','FaxMessage','CmHopperFinal','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappMessage','WhatsappQueueReport','isArray','join','isNil','dialTimezone','timezones','utcOffset','additionalPhones','bulkCreate','each','duplicates','where','ListId','findOrCreate','spread','push','contact','all','show','Tag','color','tag','CmContactHasItem','Phones','ContactItemType','ItemType','literal','Phones.OrderBy','$and','CmCustomField','omit','format','cf_%d','pickBy','map','cm_contacts','id\x20=\x20?','sequelize','text','phone','getTags','findOne','filters','model','attributes','intersection','fields'];(function(_0x4ed1d4,_0x512d9a){var _0x28e363=function(_0x2bdfb7){while(--_0x2bdfb7){_0x4ed1d4['push'](_0x4ed1d4['shift']());}};_0x28e363(++_0x512d9a);}(_0xc8f1,0x183));var _0x1c8f=function(_0x497d6e,_0x51b011){_0x497d6e=_0x497d6e-0x0;var _0x50347b=_0xc8f1[_0x497d6e];return _0x50347b;};'use strict';var moment=require('moment');var BPromise=require('bluebird');var util=require(_0x1c8f('0x0'));var path=require(_0x1c8f('0x1'));var fs=require('fs');var _=require('lodash');var squel=require('squel');var Papa=require(_0x1c8f('0x2'));var Redis=require(_0x1c8f('0x3'));var contacts=require(_0x1c8f('0x4'));var qs=require(_0x1c8f('0x5'));var logger=require(_0x1c8f('0x6'))(_0x1c8f('0x7'));var config=require(_0x1c8f('0x8'));var shared=require(_0x1c8f('0x9'));var db=require(_0x1c8f('0xa'))['db'];config[_0x1c8f('0xb')]=_[_0x1c8f('0xc')](config[_0x1c8f('0xb')],{'host':_0x1c8f('0xd'),'port':0x18eb});var socket=require(_0x1c8f('0xe'))(new Redis(config[_0x1c8f('0xb')]));require('./cmContact.socket')['register'](socket);function respondWithResult(_0x18db32,_0x3d8844){_0x3d8844=_0x3d8844||0xc8;return function(_0x591408){if(_0x591408){return _0x18db32[_0x1c8f('0xf')](_0x3d8844)[_0x1c8f('0x10')](_0x591408);}};}function respondWithFilteredResult(_0xa75ca7,_0x5410f1){return function(_0x168225){if(_0x168225){var _0x2a726a=typeof _0x5410f1[_0x1c8f('0x11')]==='undefined'&&typeof _0x5410f1[_0x1c8f('0x12')]===_0x1c8f('0x13');var _0xfdbf38=_0x168225[_0x1c8f('0x14')];var _0x5b60f2=_0x2a726a?0x0:_0x5410f1[_0x1c8f('0x11')];var _0x1f59a5=_0x2a726a?_0x168225['count']:_0x5410f1[_0x1c8f('0x11')]+_0x5410f1[_0x1c8f('0x12')];var _0x3c1981;if(_0x1f59a5>=_0xfdbf38){_0x1f59a5=_0xfdbf38;_0x3c1981=0xc8;}else{_0x3c1981=0xce;}_0xa75ca7[_0x1c8f('0xf')](_0x3c1981);return _0xa75ca7[_0x1c8f('0x15')](_0x1c8f('0x16'),_0x5b60f2+'-'+_0x1f59a5+'/'+_0xfdbf38)[_0x1c8f('0x10')](_0x168225);}return null;};}function saveUpdates(_0x4846c5){return function(_0x17fb1d){if(_0x17fb1d){return _0x17fb1d[_0x1c8f('0x17')](_0x4846c5)[_0x1c8f('0x18')](function(_0x4a6f8a){return _0x4a6f8a;});}return null;};}function removeEntity(_0x4a3950){return function(_0x4aad59){if(_0x4aad59){return _0x4aad59[_0x1c8f('0x19')]()[_0x1c8f('0x18')](function(){_0x4a3950[_0x1c8f('0xf')](0xcc)[_0x1c8f('0x1a')]();});}};}function handleEntityNotFound(_0x3727e5){return function(_0x276e19){if(!_0x276e19){_0x3727e5[_0x1c8f('0x1b')](0x194);}return _0x276e19;};}function handleError(_0x5f2895,_0x98b41b){_0x98b41b=_0x98b41b||0x1f4;return function(_0x2b66a2){logger[_0x1c8f('0x1c')](_0x2b66a2[_0x1c8f('0x1d')]);if(_0x2b66a2[_0x1c8f('0x1e')]){delete _0x2b66a2[_0x1c8f('0x1e')];}_0x5f2895[_0x1c8f('0xf')](_0x98b41b)[_0x1c8f('0x1f')](_0x2b66a2);};}exports[_0x1c8f('0x20')]=function(_0x3d31a6,_0x153b66){var _0x268a61={};return contacts[_0x1c8f('0x21')]()[_0x1c8f('0x18')](function(_0x3ee218){_0x268a61=qs[_0x1c8f('0x22')](_0x3ee218,_0x3d31a6);return contacts[_0x1c8f('0x23')](_0x3d31a6['query'],_0x3d31a6[_0x1c8f('0x24')],_0x268a61,_0x3ee218);})[_0x1c8f('0x18')](respondWithFilteredResult(_0x153b66,_0x268a61))['catch'](handleError(_0x153b66,null));};exports[_0x1c8f('0x19')]=function(_0xc0194b,_0x479b4c){return db[_0x1c8f('0x25')][_0x1c8f('0x26')]({'where':{'id':_0xc0194b[_0x1c8f('0x27')]['id']}})[_0x1c8f('0x18')](handleEntityNotFound(_0x479b4c,null))[_0x1c8f('0x18')](removeEntity(_0x479b4c,null))[_0x1c8f('0x28')](handleError(_0x479b4c,null));};exports[_0x1c8f('0x21')]=function(_0xa05d7a,_0x1a4fc5){return db[_0x1c8f('0x25')][_0x1c8f('0x21')]()[_0x1c8f('0x18')](function(_0x27491d){delete _0x27491d[_0x1c8f('0x29')];for(var _0x3d8cf8=0x0;_0x3d8cf8<Object[_0x1c8f('0x2a')](_0x27491d)[_0x1c8f('0x2b')];_0x3d8cf8++){var _0x38d8e6=Object[_0x1c8f('0x2a')](_0x27491d)[_0x3d8cf8];if(!_['startsWith'](_0x38d8e6,_0x1c8f('0x2c'))){_0x27491d[_0x38d8e6]['columnName']=_0x38d8e6;_0x27491d[_0x38d8e6][_0x1c8f('0x2d')]=_0x38d8e6;}}return _0x27491d;})['then'](function(_0x38cdf5){var _0x4107a0={'where':Boolean(_0xa05d7a[_0x1c8f('0x2e')][_0x1c8f('0x2f')])===!![]?undefined:{'$or':[{'ListId':_0xa05d7a['query']['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField'][_0x1c8f('0x23')](_0x4107a0)[_0x1c8f('0x18')](function(_0x31bbea){for(var _0x49394a=0x0;_0x49394a<_0x31bbea[_0x1c8f('0x2b')];_0x49394a++){var _0x353dd0=_0x1c8f('0x2c')+_0x31bbea[_0x49394a]['id'];if(_0x38cdf5[_0x353dd0]){_0x38cdf5[_0x353dd0][_0x1c8f('0x30')]=_0x353dd0;_0x38cdf5[_0x353dd0][_0x1c8f('0x2d')]=_0x31bbea[_0x49394a][_0x1c8f('0x31')];_0x38cdf5[_0x353dd0][_0x1c8f('0x32')]={'type':_0x31bbea[_0x49394a][_0x1c8f('0x33')],'values':_0x31bbea[_0x49394a][_0x1c8f('0x34')]};}else{logger[_0x1c8f('0x35')](_0x1c8f('0x36'),_0x353dd0);}}Object[_0x1c8f('0x2a')](_0x38cdf5)['forEach'](function(_0x494040){if(!_0x38cdf5[_0x494040][_0x1c8f('0x37')](_0x1c8f('0x30'))){delete _0x38cdf5[_0x494040];}});return _0x38cdf5;});})['then'](respondWithResult(_0x1a4fc5,null))['catch'](handleError(_0x1a4fc5,null));};exports['merge']=function(_0x260e9b,_0x5dbdae){var _0x388bef;var _0x4964b4;var _0x18fda5;if(_0x260e9b[_0x1c8f('0x38')]['id']){delete _0x260e9b[_0x1c8f('0x38')]['id'];}return db[_0x1c8f('0x25')][_0x1c8f('0x23')]({'where':{'id':[_0x260e9b[_0x1c8f('0x38')]['to'],_0x260e9b['body'][_0x1c8f('0x39')]]}})[_0x1c8f('0x18')](function(_0x72b915){if(_0x72b915){if(_0x72b915[_0x1c8f('0x2b')]!==0x2){return null;}_0x72b915[0x0]=_0x72b915[0x0][_0x1c8f('0x3a')]({'plain':!![]});_0x72b915[0x1]=_0x72b915[0x1][_0x1c8f('0x3a')]({'plain':!![]});delete _0x72b915[0x0]['id'];delete _0x72b915[0x1]['id'];return _[_0x1c8f('0x3b')](_0x72b915[0x0],_0x72b915[0x1],function(_0x304d51,_0x586ad4){if(Array['isArray'](_0x586ad4)&&!_0x586ad4['length']){return _0x304d51;}else if(!_0x586ad4){return _0x304d51;}});}})[_0x1c8f('0x18')](handleEntityNotFound(_0x5dbdae,null))[_0x1c8f('0x18')](function(_0x4d8ea9){if(_0x4d8ea9){if(_0x4d8ea9[_0x1c8f('0x29')]&&_['isArray'](_0x4d8ea9[_0x1c8f('0x29')])){_0x4d8ea9['tags']=_0x4d8ea9['tags']['join']();}logger[_0x1c8f('0x35')](_0x1c8f('0x3c'),_0x260e9b[_0x1c8f('0x38')]['to'],_0x260e9b[_0x1c8f('0x38')][_0x1c8f('0x39')]);return db[_0x1c8f('0x3d')]['destroy']({'where':{'ContactId':[_0x260e9b[_0x1c8f('0x38')]['to'],_0x260e9b[_0x1c8f('0x38')][_0x1c8f('0x39')]]}})[_0x1c8f('0x18')](function(_0x495471){logger[_0x1c8f('0x35')](_0x1c8f('0x3e'),_0x495471);return db[_0x1c8f('0x3f')][_0x1c8f('0x19')]({'where':{'ContactId':[_0x260e9b['body']['to'],_0x260e9b['body'][_0x1c8f('0x39')]]}})['then'](function(_0x563a40){logger['info']('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x563a40);return db[_0x1c8f('0x25')][_0x1c8f('0x40')](_0x4d8ea9);});});}})[_0x1c8f('0x18')](function(_0xd7101c){if(_0xd7101c){_0x388bef=_0xd7101c;_0x4964b4={'ContactId':_0x388bef['id']};_0x18fda5={'where':{'ContactId':[_0x260e9b[_0x1c8f('0x38')]['to'],_0x260e9b[_0x1c8f('0x38')][_0x1c8f('0x39')]]}};return db[_0x1c8f('0x41')][_0x1c8f('0x17')](_0x4964b4,_0x18fda5);}})[_0x1c8f('0x18')](function(){if(_0x388bef){return db[_0x1c8f('0x42')][_0x1c8f('0x17')](_0x4964b4,_0x18fda5);}})['then'](function(){if(_0x388bef){return db['ChatOfflineMessage'][_0x1c8f('0x17')](_0x4964b4,_0x18fda5);}})[_0x1c8f('0x18')](function(){if(_0x388bef){return db[_0x1c8f('0x43')][_0x1c8f('0x17')](_0x4964b4,_0x18fda5);}})[_0x1c8f('0x18')](function(){if(_0x388bef){return db['MailMessage'][_0x1c8f('0x17')](_0x4964b4,_0x18fda5);}})['then'](function(){if(_0x388bef){return db[_0x1c8f('0x43')][_0x1c8f('0x17')](_0x4964b4,_0x18fda5);}})[_0x1c8f('0x18')](function(){if(_0x388bef){return db[_0x1c8f('0x44')][_0x1c8f('0x17')](_0x4964b4,_0x18fda5);}})[_0x1c8f('0x18')](function(){if(_0x388bef){return db['SmsInteraction']['update'](_0x4964b4,_0x18fda5);}})[_0x1c8f('0x18')](function(){if(_0x388bef){return db['SmsMessage'][_0x1c8f('0x17')](_0x4964b4,_0x18fda5);}})[_0x1c8f('0x18')](function(){if(_0x388bef){return db[_0x1c8f('0x45')]['update'](_0x4964b4,_0x18fda5);}})[_0x1c8f('0x18')](function(){if(_0x388bef){return db[_0x1c8f('0x46')]['update'](_0x4964b4,_0x18fda5);}})['then'](function(){if(_0x388bef){return db['OpenchannelInteraction']['update'](_0x4964b4,_0x18fda5);}})['then'](function(){if(_0x388bef){return db['OpenchannelMessage'][_0x1c8f('0x17')](_0x4964b4,_0x18fda5);}})['then'](function(){if(_0x388bef){return db['CmContactHasItem'][_0x1c8f('0x17')]({'CmContactId':_0x388bef['id']},{'where':{'CmContactId':[_0x260e9b[_0x1c8f('0x38')]['to'],_0x260e9b[_0x1c8f('0x38')][_0x1c8f('0x39')]]}});}})['then'](function(){if(_0x388bef){return db[_0x1c8f('0x47')][_0x1c8f('0x17')](_0x4964b4,_0x18fda5);}})['then'](function(){if(_0x388bef){return db[_0x1c8f('0x48')]['update'](_0x4964b4,_0x18fda5);}})[_0x1c8f('0x18')](function(){if(_0x388bef){return db[_0x1c8f('0x49')]['update'](_0x4964b4,_0x18fda5);}})[_0x1c8f('0x18')](function(){if(_0x388bef){return db[_0x1c8f('0x4a')][_0x1c8f('0x17')](_0x4964b4,_0x18fda5);}})[_0x1c8f('0x18')](function(){if(_0x388bef){return db[_0x1c8f('0x4b')][_0x1c8f('0x17')](_0x4964b4,_0x18fda5);}})[_0x1c8f('0x18')](function(){if(_0x388bef){return db[_0x1c8f('0x4c')][_0x1c8f('0x17')](_0x4964b4,_0x18fda5);}})[_0x1c8f('0x18')](function(){if(_0x388bef){return db[_0x1c8f('0x4d')][_0x1c8f('0x17')](_0x4964b4,_0x18fda5);}})[_0x1c8f('0x18')](function(){if(_0x388bef){return db[_0x1c8f('0x4e')][_0x1c8f('0x17')](_0x4964b4,_0x18fda5);}})[_0x1c8f('0x18')](function(){if(_0x388bef){return db['SmsQueueReport']['update'](_0x4964b4,_0x18fda5);}})[_0x1c8f('0x18')](function(){if(_0x388bef){return db[_0x1c8f('0x4f')][_0x1c8f('0x17')](_0x4964b4,_0x18fda5);}})[_0x1c8f('0x18')](function(){if(_0x388bef){return db[_0x1c8f('0x50')][_0x1c8f('0x17')](_0x4964b4,_0x18fda5);}})[_0x1c8f('0x18')](function(){if(_0x388bef){return db[_0x1c8f('0x51')]['update'](_0x4964b4,_0x18fda5);}})[_0x1c8f('0x18')](function(){if(_0x388bef){return db[_0x1c8f('0x52')][_0x1c8f('0x17')](_0x4964b4,_0x18fda5);}})[_0x1c8f('0x18')](function(){if(_0x388bef){return db['CmContact'][_0x1c8f('0x19')]({'where':{'id':[_0x260e9b[_0x1c8f('0x38')]['to'],_0x260e9b[_0x1c8f('0x38')][_0x1c8f('0x39')]]}});}})['then'](function(){if(_0x388bef){return _0x388bef;}})[_0x1c8f('0x18')](respondWithResult(_0x5dbdae,null))[_0x1c8f('0x28')](handleError(_0x5dbdae,null));};exports[_0x1c8f('0x40')]=function(_0x37a1ed,_0x1ae112){return db['CmContact'][_0x1c8f('0x21')]()[_0x1c8f('0x18')](function(_0x343fa0){if(_0x37a1ed['body']['tags']&&_[_0x1c8f('0x53')](_0x37a1ed[_0x1c8f('0x38')]['tags'])){if(_0x37a1ed[_0x1c8f('0x38')]['tags'][_0x1c8f('0x2b')]){_0x37a1ed[_0x1c8f('0x38')][_0x1c8f('0x29')]=_0x37a1ed[_0x1c8f('0x38')]['tags'][_0x1c8f('0x54')](';')+';';}else{_0x37a1ed[_0x1c8f('0x38')]['tags']=null;}}else{_0x37a1ed[_0x1c8f('0x38')][_0x1c8f('0x29')]=null;}if(!_[_0x1c8f('0x55')](_0x37a1ed[_0x1c8f('0x38')]['dialTimezone'])){var _0x3f0e1b=_0x37a1ed['body'][_0x1c8f('0x56')];if(!_[_0x1c8f('0x55')](shared[_0x1c8f('0x57')][_0x3f0e1b]))_0x37a1ed[_0x1c8f('0x38')][_0x1c8f('0x58')]=shared[_0x1c8f('0x57')][_0x3f0e1b][_0x1c8f('0x58')];}return db[_0x1c8f('0x25')][_0x1c8f('0x40')](_0x37a1ed['body'],{'fields':_[_0x1c8f('0x2a')](_0x343fa0),'raw':!![]});})[_0x1c8f('0x18')](function(_0x35969e){if(_0x37a1ed[_0x1c8f('0x38')][_0x1c8f('0x59')]){return insertAdditionalPhones(_0x35969e,_0x37a1ed[_0x1c8f('0x38')][_0x1c8f('0x59')]);}else{return _0x35969e;}})[_0x1c8f('0x18')](respondWithResult(_0x1ae112,0xc9))[_0x1c8f('0x28')](handleError(_0x1ae112,null));};exports[_0x1c8f('0x5a')]=function(_0x52bae4,_0x34d4e7){var _0x2a6315=0x0;var _0x283f0b=0x0;var _0x3c9851=0x0;var _0x244d29=[];return db[_0x1c8f('0x25')][_0x1c8f('0x21')]()[_0x1c8f('0x18')](function(_0x425aa4){return BPromise[_0x1c8f('0x5b')](_0x52bae4['body'],function(_0x2c5000){var _0x5afbcd={'where':{'$or':[]},'defaults':_0x2c5000,'fields':_[_0x1c8f('0x2a')](_0x425aa4),'raw':!![]};if(_0x2c5000[_0x1c8f('0x5c')]){for(var _0x1521a7=0x0;_0x1521a7<_0x2c5000[_0x1c8f('0x5c')][_0x1c8f('0x2b')];_0x1521a7++){var _0x3e9716={};_0x3e9716[_0x2c5000[_0x1c8f('0x5c')][_0x1521a7]]=_0x2c5000[_0x2c5000['duplicates'][_0x1521a7]];_0x5afbcd[_0x1c8f('0x5d')]['$or']['push'](_0x3e9716);}_0x5afbcd['where'][_0x1c8f('0x5e')]=_0x2c5000[_0x1c8f('0x5e')];}return db[_0x1c8f('0x25')][_0x1c8f('0x5f')](_0x5afbcd)[_0x1c8f('0x60')](function(_0x402310,_0x4d99bb){if(_0x4d99bb){if(_0x2c5000[_0x1c8f('0x37')](_0x1c8f('0x59'))){_0x244d29[_0x1c8f('0x61')]({'contact':_0x402310,'additionalPhones':_0x2c5000[_0x1c8f('0x59')]});}_0x2a6315++;}else{_0x3c9851++;}})['catch'](function(){_0x283f0b++;});});})[_0x1c8f('0x18')](function(_0x205464){if(_0x205464){if(_0x244d29[_0x1c8f('0x2b')]>0x0){return new Promise(function(_0x1f3c78){var _0x29eabc=[];for(var _0x3ed12b=0x0;_0x3ed12b<_0x244d29[_0x1c8f('0x2b')];_0x3ed12b++){_0x29eabc[_0x1c8f('0x61')](insertAdditionalPhones(_0x244d29[_0x3ed12b][_0x1c8f('0x62')],_0x244d29[_0x3ed12b][_0x1c8f('0x59')]));}Promise[_0x1c8f('0x63')](_0x29eabc)[_0x1c8f('0x18')](function(){_0x1f3c78(0x1);});})[_0x1c8f('0x18')](function(){return{'success':_0x2a6315,'failure':_0x283f0b,'duplicates':_0x3c9851};});}else{return{'success':_0x2a6315,'failure':_0x283f0b,'duplicates':_0x3c9851};}}})[_0x1c8f('0x18')](respondWithResult(_0x34d4e7,0xc9))[_0x1c8f('0x28')](handleError(_0x34d4e7,null));};exports[_0x1c8f('0x64')]=function(_0x53b602,_0x59d388){var _0x4a70e4;return db[_0x1c8f('0x25')][_0x1c8f('0x21')]()[_0x1c8f('0x18')](function(_0x4d8ce1){return db[_0x1c8f('0x25')][_0x1c8f('0x26')]({'where':{'id':_0x53b602['params']['id']},'include':[{'model':db[_0x1c8f('0x65')],'as':'Tags','attributes':['id',_0x1c8f('0x1e'),_0x1c8f('0x66')],'required':_0x53b602[_0x1c8f('0x2e')][_0x1c8f('0x67')]?!![]:![]},{'model':db[_0x1c8f('0x68')],'as':_0x1c8f('0x69'),'where':{'CmContactId':_0x53b602[_0x1c8f('0x27')]['id']},'required':![],'include':[{'model':db[_0x1c8f('0x6a')],'as':_0x1c8f('0x6b')}]}],'order':[db['sequelize'][_0x1c8f('0x6c')](_0x1c8f('0x6d'))],'attributes':_['keys'](_0x4d8ce1)});})[_0x1c8f('0x18')](function(_0x4e6f69){if(!_[_0x1c8f('0x55')](_0x4e6f69)){_0x4a70e4=_0x4e6f69[_0x1c8f('0x3a')]({'plain':!![]});var _0x36f41d={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x4e6f69&&_0x4e6f69['ListId']){if(_0x4e6f69['ListId']){_0x36f41d[_0x1c8f('0x5d')][_0x1c8f('0x6e')]['push']({'ListId':{'$ne':_0x4e6f69[_0x1c8f('0x5e')]}});}}return db[_0x1c8f('0x6f')]['findAll'](_0x36f41d);}})[_0x1c8f('0x18')](function(_0x4fde0f){if(!_[_0x1c8f('0x55')](_0x4fde0f)){return _[_0x1c8f('0x70')](_0x4a70e4,_['map'](_0x4fde0f,function(_0x5c13b1){return util[_0x1c8f('0x71')](_0x1c8f('0x72'),_0x5c13b1['id']);}));}})['then'](handleEntityNotFound(_0x59d388,null))[_0x1c8f('0x18')](respondWithResult(_0x59d388,null))[_0x1c8f('0x28')](handleError(_0x59d388,null));};exports['update']=function(_0x1487cc,_0x297379){var _0x3c2289;if(_0x1487cc[_0x1c8f('0x38')]['id']){delete _0x1487cc[_0x1c8f('0x38')]['id'];}if(!_[_0x1c8f('0x55')](_0x1487cc[_0x1c8f('0x38')][_0x1c8f('0x56')])){var _0x26c623=_0x1487cc[_0x1c8f('0x38')][_0x1c8f('0x56')];if(!_['isNil'](shared[_0x1c8f('0x57')][_0x26c623]))_0x1487cc['body'][_0x1c8f('0x58')]=shared[_0x1c8f('0x57')][_0x26c623][_0x1c8f('0x58')];}return db[_0x1c8f('0x25')][_0x1c8f('0x26')]({'where':{'id':_0x1487cc[_0x1c8f('0x27')]['id']}})[_0x1c8f('0x18')](handleEntityNotFound(_0x297379,null))['then'](saveUpdates(_0x1487cc['body'],null))[_0x1c8f('0x18')](function(_0x49a06c){_0x3c2289=_0x49a06c;var _0x11a193={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x49a06c&&_0x49a06c[_0x1c8f('0x5e')]){if(_0x49a06c['ListId']){_0x11a193['where'][_0x1c8f('0x6e')][_0x1c8f('0x61')]({'ListId':{'$ne':_0x49a06c[_0x1c8f('0x5e')]}});}}return db['CmCustomField']['findAll'](_0x11a193);})[_0x1c8f('0x18')](function(_0x2a1ec0){if(_0x2a1ec0){return _[_0x1c8f('0x70')](_[_0x1c8f('0x73')](_0x1487cc[_0x1c8f('0x38')],function(_0x25cf7a,_0x337868){return _['startsWith'](_0x337868,_0x1c8f('0x2c'));}),_[_0x1c8f('0x74')](_0x2a1ec0,function(_0x3bd0a0){return util[_0x1c8f('0x71')](_0x1c8f('0x72'),_0x3bd0a0['id']);}));}})[_0x1c8f('0x18')](function(_0x4ff19a){if(_0x4ff19a&&!_['isEmpty'](_0x4ff19a)){var _0x28cf53=squel[_0x1c8f('0x17')]()['table'](_0x1c8f('0x75'))['setFields'](_0x4ff19a)[_0x1c8f('0x5d')](_0x1c8f('0x76'),_0x1487cc['params']['id'])['toParam']();return db[_0x1c8f('0x77')][_0x1c8f('0x2e')](_0x28cf53[_0x1c8f('0x78')],{'replacements':_0x28cf53[_0x1c8f('0x34')]});}})[_0x1c8f('0x18')](function(){if(_0x1487cc['body'][_0x1c8f('0x79')]&&_0x3c2289){return db['CmHopper'][_0x1c8f('0x17')]({'phone':_0x1487cc[_0x1c8f('0x38')]['phone'],'OrderBy':0x0},{'where':{'ContactId':_0x3c2289['id']}});}})[_0x1c8f('0x18')](function(){return _0x3c2289;})[_0x1c8f('0x18')](respondWithResult(_0x297379,null))[_0x1c8f('0x28')](handleError(_0x297379,null));};exports[_0x1c8f('0x7a')]=function(_0x44c51e,_0x1288b4){var _0x20b5c9={};var _0x414bc4={};var _0x3fb43a;var _0x4a63db;return db[_0x1c8f('0x25')][_0x1c8f('0x7b')]({'where':{'id':_0x44c51e[_0x1c8f('0x27')]['id']}})[_0x1c8f('0x18')](handleEntityNotFound(_0x1288b4,null))['then'](function(_0x52cf79){if(_0x52cf79){_0x3fb43a=_0x52cf79;_0x414bc4['model']=_[_0x1c8f('0x2a')](db[_0x1c8f('0x65')]['rawAttributes']);_0x414bc4[_0x1c8f('0x2e')]=_['keys'](_0x44c51e[_0x1c8f('0x2e')]);_0x414bc4[_0x1c8f('0x7c')]=_['intersection'](_0x414bc4[_0x1c8f('0x7d')],_0x414bc4[_0x1c8f('0x2e')]);_0x20b5c9[_0x1c8f('0x7e')]=_[_0x1c8f('0x7f')](_0x414bc4[_0x1c8f('0x7d')],qs[_0x1c8f('0x80')](_0x44c51e['query']['fields']));_0x20b5c9[_0x1c8f('0x7e')]=_0x20b5c9[_0x1c8f('0x7e')]['length']?_0x20b5c9[_0x1c8f('0x7e')]:_0x414bc4[_0x1c8f('0x7d')];_0x20b5c9[_0x1c8f('0x81')]=qs[_0x1c8f('0x82')](_0x44c51e[_0x1c8f('0x2e')]['sort']);_0x20b5c9[_0x1c8f('0x5d')]=qs[_0x1c8f('0x7c')](_[_0x1c8f('0x83')](_0x44c51e['query'],_0x414bc4[_0x1c8f('0x7c')]));if(_0x44c51e['query'][_0x1c8f('0x84')]){_0x20b5c9[_0x1c8f('0x5d')]=_[_0x1c8f('0x85')](_0x20b5c9[_0x1c8f('0x5d')],{'$or':_[_0x1c8f('0x74')](_0x20b5c9[_0x1c8f('0x7e')],function(_0x41fa21){var _0x2a8555={};_0x2a8555[_0x41fa21]={'$like':'%'+_0x44c51e[_0x1c8f('0x2e')][_0x1c8f('0x84')]+'%'};return _0x2a8555;})});}_0x20b5c9=_[_0x1c8f('0x85')]({},_0x20b5c9,_0x44c51e[_0x1c8f('0x86')]);return _0x3fb43a['getTags'](_0x20b5c9);}})['then'](function(_0x3035b0){if(_0x3035b0){_0x4a63db=_0x3035b0['length'];if(!_0x44c51e['query'][_0x1c8f('0x37')]('nolimit')){_0x20b5c9[_0x1c8f('0x12')]=qs['limit'](_0x44c51e[_0x1c8f('0x2e')]['limit']);_0x20b5c9[_0x1c8f('0x11')]=qs[_0x1c8f('0x11')](_0x44c51e[_0x1c8f('0x2e')][_0x1c8f('0x11')]);}return _0x3fb43a[_0x1c8f('0x7a')](_0x20b5c9);}})[_0x1c8f('0x18')](function(_0x5c4f62){if(_0x5c4f62){return _0x5c4f62?{'count':_0x4a63db,'rows':_0x5c4f62}:null;}})[_0x1c8f('0x18')](respondWithResult(_0x1288b4,null))[_0x1c8f('0x28')](handleError(_0x1288b4,null));};exports['setTags']=function(_0x5f0b79,_0x2c5726){if(_0x5f0b79[_0x1c8f('0x38')]['id']){delete _0x5f0b79[_0x1c8f('0x38')]['id'];}return db[_0x1c8f('0x25')][_0x1c8f('0x7b')]({'where':{'id':_0x5f0b79[_0x1c8f('0x27')]['id']}})[_0x1c8f('0x18')](handleEntityNotFound(_0x2c5726,null))['then'](function(_0x35ea0a){if(_0x35ea0a){return _0x35ea0a[_0x1c8f('0x87')](_0x5f0b79['body']['ids']||[]);}return null;})[_0x1c8f('0x18')](respondWithResult(_0x2c5726,null))['catch'](handleError(_0x2c5726,null));};exports[_0x1c8f('0x88')]=function(_0x49c002,_0x4beb00){var _0x2daf12=[];_0x2daf12['push'](addAdditionalPhones(_0x49c002[_0x1c8f('0x38')]));Promise[_0x1c8f('0x63')](_0x2daf12)['then'](function(){_0x2daf12=[];_0x2daf12[_0x1c8f('0x61')](deleteCmHopperPhones(_0x49c002[_0x1c8f('0x38')]['id']));_0x2daf12[_0x1c8f('0x61')](addCmHopperPhones(_0x49c002['body']['id']));Promise[_0x1c8f('0x63')](_0x2daf12)[_0x1c8f('0x18')](function(){return[0x1];})[_0x1c8f('0x18')](respondWithResult(_0x4beb00,null));});};function addAdditionalPhones(_0x30fa40){var _0x442dcc;return new Promise(function(_0x2fbef3){return db[_0x1c8f('0x68')][_0x1c8f('0x19')]({'where':{'CmContactId':_0x30fa40['id']}})[_0x1c8f('0x18')](function(){db[_0x1c8f('0x6a')][_0x1c8f('0x23')]({'raw':!![],'attributes':['id',_0x1c8f('0x89')]})['then'](function(_0x5bfa58){var _0xfb685f=[];for(var _0x42aca6=0x0;_0x42aca6<_0x30fa40[_0x1c8f('0x8a')]['length'];_0x42aca6++){var _0x16068f=_0x30fa40[_0x1c8f('0x8b')]?_['isNil'](_0x30fa40[_0x1c8f('0x8b')][_0x42aca6])?'':_0x30fa40['item_types'][_0x42aca6]:_0x30fa40['items'][_0x42aca6]['ItemTypeId']?_0x30fa40[_0x1c8f('0x8a')][_0x42aca6]['ItemTypeId']:'';var _0x43dda9=_[_0x1c8f('0x55')](_0x30fa40[_0x1c8f('0x8a')][_0x42aca6]['description'])?'':_0x30fa40[_0x1c8f('0x8a')][_0x42aca6][_0x1c8f('0x8c')];var _0x3fcb3b=_0x16068f+':'+_0x30fa40[_0x1c8f('0x8a')][_0x42aca6][_0x1c8f('0x79')]+'§'+_0x43dda9;if(_['isNil'](_0x442dcc))_0x442dcc=_0x3fcb3b;else _0x442dcc+=';'+_0x3fcb3b;var _0x3a7368=null;var _0x5692fd=null;if(_0x30fa40[_0x1c8f('0x8b')]){if(!_[_0x1c8f('0x55')](_0x30fa40['item_types'][_0x42aca6])){_0x5692fd=_[_0x1c8f('0x26')](_0x5bfa58,function(_0x31ccf0){return _0x31ccf0['id']===_0x30fa40[_0x1c8f('0x8b')][_0x42aca6];});if(!_[_0x1c8f('0x55')](_0x5692fd)){_0x3a7368=_0x5692fd[_0x1c8f('0x89')];}}}else{if(!_[_0x1c8f('0x55')](_0x30fa40[_0x1c8f('0x8a')][_0x42aca6])){_0x5692fd=_[_0x1c8f('0x26')](_0x5bfa58,function(_0x19bed6){return _0x19bed6['id']===_0x30fa40[_0x1c8f('0x8a')][_0x42aca6]['ItemTypeId'];});if(!_[_0x1c8f('0x55')](_0x5692fd)){_0x3a7368=_0x42aca6;}}}if(_['isNil'](_0x3a7368)){_0x3a7368=0x64;}_0xfb685f[_0x1c8f('0x61')](addAdditionalPhone(_0x30fa40['id'],_0x30fa40[_0x1c8f('0x8a')][_0x42aca6][_0x1c8f('0x79')],_0x30fa40[_0x1c8f('0x8b')]?_[_0x1c8f('0x55')](_0x30fa40[_0x1c8f('0x8b')][_0x42aca6])?null:_0x30fa40[_0x1c8f('0x8b')][_0x42aca6]:_0x30fa40[_0x1c8f('0x8a')][_0x42aca6][_0x1c8f('0x8d')]?_0x30fa40['items'][_0x42aca6][_0x1c8f('0x8d')]:null,_0x3a7368,_0x43dda9));}Promise[_0x1c8f('0x63')](_0xfb685f)['then'](function(){db[_0x1c8f('0x25')][_0x1c8f('0x17')]({'AdditionalPhones':_0x442dcc},{'where':{'id':_0x30fa40['id']}})['then'](function(){_0x2fbef3(0x1);});});});});});}function addAdditionalPhone(_0x25353e,_0x5364a3,_0x17f628,_0x5345dc,_0x3296ee){return db['CmContactHasItem'][_0x1c8f('0x26')]({'where':{'CmContactId':_0x25353e,'item':_0x5364a3}})[_0x1c8f('0x18')](function(_0x5789a5){if(_0x5789a5)logger[_0x1c8f('0x35')](_0x1c8f('0x8e'),_0x5789a5);else{db[_0x1c8f('0x68')][_0x1c8f('0x40')]({'CmContactId':_0x25353e,'item':_0x5364a3,'ItemTypeId':_0x17f628,'OrderBy':_0x5345dc,'ItemClass':'PHONE','description':_0x3296ee});}});}function deleteCmHopperPhones(_0x539a61){return new Promise(function(_0x4c3b0d){return db['CmHopper']['findAll']({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x539a61}})[_0x1c8f('0x18')](function(_0x42ed6c){db[_0x1c8f('0x8f')][_0x1c8f('0x19')]({'where':{'CmHopperId':{'$in':_[_0x1c8f('0x74')](_0x42ed6c,'id')}}});})[_0x1c8f('0x18')](function(){_0x4c3b0d(0x1);});});}function addCmHopperPhones(_0x4efdb7){return new Promise(function(_0x5b5918){return db[_0x1c8f('0x3d')][_0x1c8f('0x23')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x4efdb7}})[_0x1c8f('0x18')](function(_0x32a8ec){var _0x3830b2=[];_[_0x1c8f('0x74')](_0x32a8ec,function(_0x22dfb8){_0x3830b2[_0x1c8f('0x61')](createCmHopperPhone(_0x4efdb7,_0x22dfb8['id']));});Promise[_0x1c8f('0x63')](_0x3830b2)[_0x1c8f('0x18')](function(){_0x5b5918(0x1);});});});}function createCmHopperPhone(_0x1f320a,_0x5070e0){return new Promise(function(_0x318589){db[_0x1c8f('0x68')]['findAll']({'raw':!![],'attributes':[_0x1c8f('0x90'),'OrderBy'],'where':{'CmContactId':_0x1f320a,'ItemClass':_0x1c8f('0x91')},'include':[{'model':db[_0x1c8f('0x6a')],'attributes':[_0x1c8f('0x89')],'as':'ItemType'}],'order':['OrderBy',db[_0x1c8f('0x77')][_0x1c8f('0x6c')](_0x1c8f('0x92'))]})[_0x1c8f('0x18')](function(_0x57bdfa){var _0xbddd64=0x1;var _0x513365=_['map'](_0x57bdfa,function(_0x3495a3){_0x3495a3[_0x1c8f('0x93')]=_0x5070e0;_0x3495a3['phone']=_0x3495a3['item'];_0x3495a3[_0x1c8f('0x89')]=_0xbddd64;delete _0x3495a3[_0x1c8f('0x94')];_0xbddd64=_0xbddd64+0x1;return _0x3495a3;});return db[_0x1c8f('0x8f')]['bulkCreate'](_0x513365,{});})['then'](function(){_0x318589(0x1);});});}function insertAdditionalPhones(_0x1e509d,_0xab98dc){return new Promise(function(_0x5eec12){var _0x8139c4=[];for(var _0x6a42fc=0x0;_0x6a42fc<_0xab98dc[_0x1c8f('0x2b')];_0x6a42fc++){var _0x13cab9=_0xab98dc[_0x6a42fc];_0x8139c4[_0x1c8f('0x61')](parseContactItemType(_0x13cab9));}Promise['all'](_0x8139c4)['then'](function(){var _0x32f4b4={'id':_0x1e509d['id'],'items':_0xab98dc};return addAdditionalPhones(_0x32f4b4)[_0x1c8f('0x18')](function(){return addCmHopperPhones(_0x1e509d['id']);});})[_0x1c8f('0x18')](function(){_0x5eec12(_0x1e509d);});});}function parseContactItemType(_0x12c406){return new Promise(function(_0x5d4077){if(_0x12c406[_0x1c8f('0x37')](_0x1c8f('0x8d'))){_0x5d4077(_0x12c406);}else{return db[_0x1c8f('0x6a')][_0x1c8f('0x26')]({'where':{'name':_0x12c406[_0x1c8f('0x6b')]}})['then'](function(_0x483216){if(_[_0x1c8f('0x55')](_0x483216))_0x12c406[_0x1c8f('0x8d')]=null;else _0x12c406[_0x1c8f('0x8d')]=_0x483216['id'];_0x5d4077(_0x12c406);});}});}exports[_0x1c8f('0x95')]=function(_0x1e0640,_0xd2b7c){return db[_0x1c8f('0x68')][_0x1c8f('0x23')]({'raw':!![],'where':{'CmContactId':_0x1e0640['params']['id'],'ItemClass':'PHONE'},'include':[{'model':db[_0x1c8f('0x6a')],'as':_0x1c8f('0x6b')}],'order':[[_0x1c8f('0x89')],[db[_0x1c8f('0x77')][_0x1c8f('0x6c')](_0x1c8f('0x92'))]]})['then'](function(_0x10d97c){return _0x10d97c;})[_0x1c8f('0x18')](respondWithResult(_0xd2b7c,null))[_0x1c8f('0x28')](handleError(_0xd2b7c,null));};exports[_0x1c8f('0x96')]=function(_0x3e9527,_0x45373f){return db[_0x1c8f('0x68')][_0x1c8f('0x23')]({'raw':!![],'where':{'CmContactId':_0x3e9527[_0x1c8f('0x38')][_0x1c8f('0x97')]}})[_0x1c8f('0x18')](function(_0x4ca492){var _0x1c2de1=_[_0x1c8f('0x74')](_0x4ca492,function(_0x1dddc4){_0x1dddc4[_0x1c8f('0x98')]=_0x3e9527['body'][_0x1c8f('0x99')];return _0x1dddc4;});return db['CmContactHasItem'][_0x1c8f('0x5a')](_0x1c2de1,{});})[_0x1c8f('0x18')](function(){return addCmHopperPhones(_0x3e9527[_0x1c8f('0x38')]['toContactId']);})[_0x1c8f('0x18')](function(){return['ok'];})[_0x1c8f('0x18')](respondWithResult(_0x45373f,null))[_0x1c8f('0x28')](handleError(_0x45373f,null));};exports[_0x1c8f('0x9a')]=function(_0xb450b0,_0x52d82f){var _0x34e7fc=[];_0x34e7fc[_0x1c8f('0x61')](createCmHopperPhone(_0xb450b0[_0x1c8f('0x38')]['id'],_0xb450b0[_0x1c8f('0x38')][_0x1c8f('0x9b')]));Promise[_0x1c8f('0x63')](_0x34e7fc)['then'](function(){return[0x1];})['then'](respondWithResult(_0x52d82f,null));};exports[_0x1c8f('0x9c')]=function(_0x452668,_0x165c69){var _0x1d1e8a={'raw':![],'where':{}};var _0x6f4d4b={};var _0x1537ec={'count':0x0,'rows':[]};return db[_0x1c8f('0x25')][_0x1c8f('0x7b')]({'where':{'id':_0x452668[_0x1c8f('0x27')]['id']}})['then'](handleEntityNotFound(_0x165c69,null))[_0x1c8f('0x18')](function(_0x26c720){if(_0x26c720){_0x6f4d4b[_0x1c8f('0x7d')]=_[_0x1c8f('0x2a')](db[_0x1c8f('0x3d')][_0x1c8f('0x9d')]);_0x6f4d4b['query']=_[_0x1c8f('0x2a')](_0x452668[_0x1c8f('0x2e')]);_0x6f4d4b[_0x1c8f('0x7c')]=_[_0x1c8f('0x7f')](_0x6f4d4b[_0x1c8f('0x7d')],_0x6f4d4b['query']);_0x1d1e8a[_0x1c8f('0x7e')]=_[_0x1c8f('0x7f')](_0x6f4d4b['model'],qs[_0x1c8f('0x80')](_0x452668['query'][_0x1c8f('0x80')]));_0x1d1e8a[_0x1c8f('0x7e')]=_0x1d1e8a[_0x1c8f('0x7e')][_0x1c8f('0x2b')]?_0x1d1e8a['attributes']:_0x6f4d4b[_0x1c8f('0x7d')];if(!_0x452668[_0x1c8f('0x2e')][_0x1c8f('0x37')](_0x1c8f('0x9e'))){_0x1d1e8a[_0x1c8f('0x12')]=qs[_0x1c8f('0x12')](_0x452668[_0x1c8f('0x2e')][_0x1c8f('0x12')]);_0x1d1e8a[_0x1c8f('0x11')]=qs[_0x1c8f('0x11')](_0x452668[_0x1c8f('0x2e')][_0x1c8f('0x11')]);}_0x1d1e8a[_0x1c8f('0x81')]=qs[_0x1c8f('0x82')](_0x452668[_0x1c8f('0x2e')]['sort']);_0x1d1e8a[_0x1c8f('0x5d')]=qs[_0x1c8f('0x7c')](_[_0x1c8f('0x83')](_0x452668[_0x1c8f('0x2e')],_0x6f4d4b[_0x1c8f('0x7c')]));_0x1d1e8a[_0x1c8f('0x5d')][_0x1c8f('0x9f')]=_0x26c720['id'];if(_0x452668['query'][_0x1c8f('0x84')]){_0x1d1e8a[_0x1c8f('0x5d')]=_[_0x1c8f('0x85')](_0x1d1e8a[_0x1c8f('0x5d')],{'$or':_['map'](_0x1d1e8a[_0x1c8f('0x7e')],function(_0xd2d881){var _0x3647bd={};_0x3647bd[_0xd2d881]={'$like':'%'+_0x452668['query'][_0x1c8f('0x84')]+'%'};return _0x3647bd;})});}_0x1d1e8a=_[_0x1c8f('0x85')]({},_0x1d1e8a,_0x452668['options']);return db[_0x1c8f('0x3d')][_0x1c8f('0x14')]({'where':_0x1d1e8a[_0x1c8f('0x5d')]})[_0x1c8f('0x18')](function(_0x3356e6){_0x1537ec[_0x1c8f('0x14')]=_0x3356e6;if(_0x452668[_0x1c8f('0x2e')][_0x1c8f('0xa0')]){_0x1d1e8a[_0x1c8f('0xa1')]=[{'all':!![]}];}return db[_0x1c8f('0x3d')][_0x1c8f('0x23')](_0x1d1e8a);})[_0x1c8f('0x18')](function(_0x3d304b){_0x1537ec[_0x1c8f('0xa2')]=_0x3d304b;return _0x1537ec;});}})[_0x1c8f('0x18')](respondWithFilteredResult(_0x165c69,_0x1d1e8a))[_0x1c8f('0x28')](handleError(_0x165c69,null));};exports['getHopperHistories']=function(_0x2f5707,_0x29f8cf){var _0x2879be={'raw':!![],'where':{}};var _0x3f6e87={};var _0x27f40b={'count':0x0,'rows':[]};return db[_0x1c8f('0x25')]['findOne']({'where':{'id':_0x2f5707[_0x1c8f('0x27')]['id']}})['then'](handleEntityNotFound(_0x29f8cf,null))[_0x1c8f('0x18')](function(_0x3691de){if(_0x3691de){_0x3f6e87[_0x1c8f('0x7d')]=_['keys'](db[_0x1c8f('0x48')]['rawAttributes']);_0x3f6e87['query']=_[_0x1c8f('0x2a')](_0x2f5707[_0x1c8f('0x2e')]);_0x3f6e87[_0x1c8f('0x7c')]=_['intersection'](_0x3f6e87['model'],_0x3f6e87[_0x1c8f('0x2e')]);_0x2879be[_0x1c8f('0x7e')]=_['intersection'](_0x3f6e87['model'],qs[_0x1c8f('0x80')](_0x2f5707[_0x1c8f('0x2e')]['fields']));_0x2879be[_0x1c8f('0x7e')]=_0x2879be[_0x1c8f('0x7e')][_0x1c8f('0x2b')]?_0x2879be[_0x1c8f('0x7e')]:_0x3f6e87[_0x1c8f('0x7d')];if(!_0x2f5707[_0x1c8f('0x2e')][_0x1c8f('0x37')](_0x1c8f('0x9e'))){_0x2879be[_0x1c8f('0x12')]=qs[_0x1c8f('0x12')](_0x2f5707['query']['limit']);_0x2879be[_0x1c8f('0x11')]=qs[_0x1c8f('0x11')](_0x2f5707[_0x1c8f('0x2e')][_0x1c8f('0x11')]);}_0x2879be[_0x1c8f('0x81')]=qs['sort'](_0x2f5707[_0x1c8f('0x2e')][_0x1c8f('0x82')]);_0x2879be[_0x1c8f('0x5d')]=qs[_0x1c8f('0x7c')](_[_0x1c8f('0x83')](_0x2f5707[_0x1c8f('0x2e')],_0x3f6e87[_0x1c8f('0x7c')]));_0x2879be['where'][_0x1c8f('0x9f')]=_0x3691de['id'];if(_0x2f5707[_0x1c8f('0x2e')][_0x1c8f('0x84')]){_0x2879be['where']=_['merge'](_0x2879be[_0x1c8f('0x5d')],{'$or':_[_0x1c8f('0x74')](_0x2879be[_0x1c8f('0x7e')],function(_0x2e4f9d){var _0x10ebb0={};_0x10ebb0[_0x2e4f9d]={'$like':'%'+_0x2f5707['query'][_0x1c8f('0x84')]+'%'};return _0x10ebb0;})});}_0x2879be=_[_0x1c8f('0x85')]({},_0x2879be,_0x2f5707[_0x1c8f('0x86')]);return db[_0x1c8f('0x48')][_0x1c8f('0x14')]({'where':_0x2879be['where']})['then'](function(_0x182274){_0x27f40b[_0x1c8f('0x14')]=_0x182274;if(_0x2f5707['query']['includeAll']){_0x2879be[_0x1c8f('0xa1')]=[{'all':!![]}];}return db[_0x1c8f('0x48')][_0x1c8f('0x23')](_0x2879be);})[_0x1c8f('0x18')](function(_0x31291b){_0x27f40b[_0x1c8f('0xa2')]=_0x31291b;return _0x27f40b;});}})[_0x1c8f('0x18')](respondWithFilteredResult(_0x29f8cf,_0x2879be))['catch'](handleError(_0x29f8cf,null));};exports['getHopperFinals']=function(_0x55364e,_0x3ca232){var _0x16ada3={'raw':!![],'where':{}};var _0x5b9939={};var _0x4c155d={'count':0x0,'rows':[]};return db[_0x1c8f('0x25')][_0x1c8f('0x7b')]({'where':{'id':_0x55364e[_0x1c8f('0x27')]['id']}})[_0x1c8f('0x18')](handleEntityNotFound(_0x3ca232,null))[_0x1c8f('0x18')](function(_0x433111){if(_0x433111){_0x5b9939[_0x1c8f('0x7d')]=_[_0x1c8f('0x2a')](db[_0x1c8f('0x47')][_0x1c8f('0x9d')]);_0x5b9939[_0x1c8f('0x2e')]=_[_0x1c8f('0x2a')](_0x55364e[_0x1c8f('0x2e')]);_0x5b9939['filters']=_['intersection'](_0x5b9939['model'],_0x5b9939[_0x1c8f('0x2e')]);_0x16ada3[_0x1c8f('0x7e')]=_['intersection'](_0x5b9939['model'],qs[_0x1c8f('0x80')](_0x55364e[_0x1c8f('0x2e')]['fields']));_0x16ada3['attributes']=_0x16ada3[_0x1c8f('0x7e')][_0x1c8f('0x2b')]?_0x16ada3[_0x1c8f('0x7e')]:_0x5b9939['model'];if(!_0x55364e['query']['hasOwnProperty'](_0x1c8f('0x9e'))){_0x16ada3[_0x1c8f('0x12')]=qs[_0x1c8f('0x12')](_0x55364e[_0x1c8f('0x2e')]['limit']);_0x16ada3[_0x1c8f('0x11')]=qs['offset'](_0x55364e[_0x1c8f('0x2e')][_0x1c8f('0x11')]);}_0x16ada3[_0x1c8f('0x81')]=qs[_0x1c8f('0x82')](_0x55364e[_0x1c8f('0x2e')]['sort']);_0x16ada3[_0x1c8f('0x5d')]=qs[_0x1c8f('0x7c')](_[_0x1c8f('0x83')](_0x55364e[_0x1c8f('0x2e')],_0x5b9939[_0x1c8f('0x7c')]));_0x16ada3[_0x1c8f('0x5d')]['ContactId']=_0x433111['id'];if(_0x55364e[_0x1c8f('0x2e')][_0x1c8f('0x84')]){_0x16ada3['where']=_[_0x1c8f('0x85')](_0x16ada3[_0x1c8f('0x5d')],{'$or':_[_0x1c8f('0x74')](_0x16ada3[_0x1c8f('0x7e')],function(_0x363ed0){var _0x4e133e={};_0x4e133e[_0x363ed0]={'$like':'%'+_0x55364e[_0x1c8f('0x2e')][_0x1c8f('0x84')]+'%'};return _0x4e133e;})});}_0x16ada3=_[_0x1c8f('0x85')]({},_0x16ada3,_0x55364e['options']);return db['CmHopperFinal'][_0x1c8f('0x14')]({'where':_0x16ada3['where']})[_0x1c8f('0x18')](function(_0x26b2ca){_0x4c155d[_0x1c8f('0x14')]=_0x26b2ca;if(_0x55364e['query'][_0x1c8f('0xa0')]){_0x16ada3['include']=[{'all':!![]}];}return db['CmHopperFinal'][_0x1c8f('0x23')](_0x16ada3);})['then'](function(_0x41eac5){_0x4c155d['rows']=_0x41eac5;return _0x4c155d;});}})['then'](respondWithFilteredResult(_0x3ca232,_0x16ada3))[_0x1c8f('0x28')](handleError(_0x3ca232,null));};exports[_0x1c8f('0xa3')]=function(_0x123cc9,_0x2ac1d5){var _0x5ec461={'raw':!![],'where':{}};var _0x32b811={};var _0x213e91={'count':0x0,'rows':[]};return db['CmContact'][_0x1c8f('0x7b')]({'where':{'id':_0x123cc9[_0x1c8f('0x27')]['id']}})[_0x1c8f('0x18')](handleEntityNotFound(_0x2ac1d5,null))['then'](function(_0x5792f8){if(_0x5792f8){_0x32b811[_0x1c8f('0x7d')]=_[_0x1c8f('0x2a')](db[_0x1c8f('0x4f')][_0x1c8f('0x9d')]);_0x32b811[_0x1c8f('0x2e')]=_['keys'](_0x123cc9['query']);_0x32b811[_0x1c8f('0x7c')]=_[_0x1c8f('0x7f')](_0x32b811[_0x1c8f('0x7d')],_0x32b811[_0x1c8f('0x2e')]);_0x5ec461[_0x1c8f('0x7e')]=_['intersection'](_0x32b811['model'],qs[_0x1c8f('0x80')](_0x123cc9[_0x1c8f('0x2e')]['fields']));_0x5ec461[_0x1c8f('0x7e')]=_0x5ec461[_0x1c8f('0x7e')]['length']?_0x5ec461[_0x1c8f('0x7e')]:_0x32b811[_0x1c8f('0x7d')];if(!_0x123cc9[_0x1c8f('0x2e')][_0x1c8f('0x37')](_0x1c8f('0x9e'))){_0x5ec461[_0x1c8f('0x12')]=qs['limit'](_0x123cc9[_0x1c8f('0x2e')]['limit']);_0x5ec461[_0x1c8f('0x11')]=qs[_0x1c8f('0x11')](_0x123cc9['query'][_0x1c8f('0x11')]);}_0x5ec461[_0x1c8f('0x81')]=qs['sort'](_0x123cc9['query'][_0x1c8f('0x82')]);_0x5ec461[_0x1c8f('0x5d')]=qs[_0x1c8f('0x7c')](_[_0x1c8f('0x83')](_0x123cc9[_0x1c8f('0x2e')],_0x32b811['filters']));_0x5ec461[_0x1c8f('0x5d')][_0x1c8f('0x9f')]=_0x5792f8['id'];if(_0x123cc9['query'][_0x1c8f('0x84')]){_0x5ec461[_0x1c8f('0x5d')]=_[_0x1c8f('0x85')](_0x5ec461[_0x1c8f('0x5d')],{'$or':_[_0x1c8f('0x74')](_0x5ec461[_0x1c8f('0x7e')],function(_0x4566c1){var _0xd42692={};_0xd42692[_0x4566c1]={'$like':'%'+_0x123cc9[_0x1c8f('0x2e')][_0x1c8f('0x84')]+'%'};return _0xd42692;})});}_0x5ec461=_['merge']({},_0x5ec461,_0x123cc9[_0x1c8f('0x86')]);return db[_0x1c8f('0x4f')][_0x1c8f('0x14')]({'where':_0x5ec461[_0x1c8f('0x5d')]})[_0x1c8f('0x18')](function(_0x427dc5){_0x213e91[_0x1c8f('0x14')]=_0x427dc5;if(_0x123cc9['query'][_0x1c8f('0xa0')]){_0x5ec461[_0x1c8f('0xa1')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0x1c8f('0x23')](_0x5ec461);})['then'](function(_0x1c640c){_0x213e91[_0x1c8f('0xa2')]=_0x1c640c;return _0x213e91;});}})[_0x1c8f('0x18')](respondWithFilteredResult(_0x2ac1d5,_0x5ec461))['catch'](handleError(_0x2ac1d5,null));};exports[_0x1c8f('0xa4')]=function(_0x37ddb4,_0x2f17b3){try{if(!_0x37ddb4['body'][_0x1c8f('0x5e')]){throw new Error(_0x1c8f('0xa5'));}if(!_0x37ddb4['body']['binding_keys']){throw new Error(_0x1c8f('0xa6'));}if(!_0x37ddb4[_0x1c8f('0x38')]['binding_values']){throw new Error(_0x1c8f('0xa7'));}if(!_0x37ddb4[_0x1c8f('0x38')]['socket_timestamp']){throw new Error(_0x1c8f('0xa8'));}var _0x58d3f1=_0x37ddb4['body'][_0x1c8f('0xa9')][_0x1c8f('0xaa')](',');var _0x1a47a3=_0x37ddb4[_0x1c8f('0x38')][_0x1c8f('0xab')][_0x1c8f('0xaa')](',');if(!_0x58d3f1[_0x1c8f('0x2b')]||!_0x1a47a3[_0x1c8f('0x2b')]||_0x58d3f1['length']!==_0x1a47a3[_0x1c8f('0x2b')]){throw new Error(_0x1c8f('0xac'));}_0x37ddb4[_0x1c8f('0x38')]['fields']=_[_0x1c8f('0xad')](_0x58d3f1,_0x1a47a3);if(!_0x37ddb4['body'][_0x1c8f('0x80')][_0x1c8f('0x79')]){throw new Error(_0x1c8f('0xae'));}if(!_0x37ddb4[_0x1c8f('0x38')][_0x1c8f('0x80')][_0x1c8f('0xaf')]){throw new Error('No\x20firstName\x20column\x20specified');}var _0x17fd28=path['join'](config[_0x1c8f('0xb0')],_0x1c8f('0xb1'),_0x37ddb4[_0x1c8f('0xb2')][_0x1c8f('0xb3')]);fs[_0x1c8f('0xb4')](_0x17fd28,parseInt(_0x1c8f('0xb5'),0x8));var _0x8ac62d=require(_0x1c8f('0xb6'))[_0x1c8f('0xb7')](path['join'](__dirname,_0x1c8f('0xb8')),[_0x17fd28,_0x37ddb4['body'][_0x1c8f('0xa9')],_0x37ddb4[_0x1c8f('0x38')][_0x1c8f('0xab')],_0x37ddb4[_0x1c8f('0x38')]['ListId'],_0x37ddb4[_0x1c8f('0x38')][_0x1c8f('0xb9')],_0x37ddb4[_0x1c8f('0x38')]['duplicates'],_0x37ddb4[_0x1c8f('0x38')][_0x1c8f('0xba')]]);return _0x2f17b3['status'](0xc8)['json']({'message':_0x1c8f('0xbb'),'pid':_0x8ac62d[_0x1c8f('0xbc')]});}catch(_0x4d687f){return _0x2f17b3['status'](0x1f4)['send'](_0x4d687f);}};exports[_0x1c8f('0xbd')]=function(_0x52169d,_0x9fd1be){var _0x1015d7=fs[_0x1c8f('0xbe')](_0x52169d[_0x1c8f('0xb2')][_0x1c8f('0x1')]);Papa[_0x1c8f('0xbf')](_0x1015d7,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x2aaac3){return _0x9fd1be['status'](0xc8)[_0x1c8f('0x10')]({'file':_0x52169d['file'],'fields':_0x2aaac3['meta']['fields']});}});};exports[_0x1c8f('0xc0')]=function(_0x5ec446,_0x46b13d){return db[_0x1c8f('0xc1')][_0x1c8f('0x23')]({'raw':!![],'attributes':['id'],'where':{'role':_0x1c8f('0xc2')}})[_0x1c8f('0x18')](function(_0x251cc3){var _0x1fcc20=![];if(!_0x5ec446[_0x1c8f('0x38')][_0x1c8f('0x5e')]){throw new Error(_0x1c8f('0xa5'));}if(!_0x5ec446[_0x1c8f('0x38')][_0x1c8f('0xc3')][_0x1c8f('0x79')]){throw new Error(_0x1c8f('0xae'));}if(!_0x5ec446[_0x1c8f('0x38')][_0x1c8f('0xc3')]['firstName']){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x5ec446[_0x1c8f('0x38')][_0x1c8f('0xba')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x857cd4=require('child_process')[_0x1c8f('0xb7')](path[_0x1c8f('0x54')](__dirname,_0x1c8f('0xc4')),[_0x5ec446['params']['id'],JSON[_0x1c8f('0xc5')](_0x5ec446[_0x1c8f('0x38')]),JSON['stringify'](_0x251cc3)]);_0x857cd4['on']('message',function(){_0x1fcc20=!![];return _0x46b13d[_0x1c8f('0xf')](0xc8)[_0x1c8f('0x10')]({'message':_0x1c8f('0xc6'),'pid':_0x857cd4[_0x1c8f('0xbc')]});});_0x857cd4['on'](_0x1c8f('0xc7'),function(_0x553668){if(_0x553668&&!_0x1fcc20){return _0x46b13d[_0x1c8f('0xf')](0x1f4)['json']({'message':_0x1c8f('0xc8'),'pid':_0x857cd4[_0x1c8f('0xbc')]});}});})[_0x1c8f('0x28')](handleError(_0x46b13d,null));};exports[_0x1c8f('0xc9')]=function(_0xed79a5,_0xfeb211){return db[_0x1c8f('0xc1')][_0x1c8f('0x23')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0x1c8f('0x18')](function(_0x4fd1d1){var _0x14021a=![];if(!_0xed79a5['body'][_0x1c8f('0x5e')]){throw new Error(_0x1c8f('0xa5'));}if(!_0xed79a5['body']['binding']['phone']){throw new Error(_0x1c8f('0xae'));}if(!_0xed79a5[_0x1c8f('0x38')][_0x1c8f('0xc3')][_0x1c8f('0xaf')]){throw new Error(_0x1c8f('0xca'));}if(!_0xed79a5[_0x1c8f('0x38')]['socket_timestamp']){throw new Error(_0x1c8f('0xa8'));}var _0x3ec867=require(_0x1c8f('0xb6'))[_0x1c8f('0xb7')](path[_0x1c8f('0x54')](__dirname,_0x1c8f('0xcb')),[_0xed79a5[_0x1c8f('0x27')]['id'],JSON[_0x1c8f('0xc5')](_0xed79a5['body']),JSON[_0x1c8f('0xc5')](_0x4fd1d1)]);_0x3ec867['on']('message',function(){_0x14021a=!![];return _0xfeb211[_0x1c8f('0xf')](0xc8)[_0x1c8f('0x10')]({'message':_0x1c8f('0xc6'),'pid':_0x3ec867[_0x1c8f('0xbc')]});});_0x3ec867['on']('exit',function(_0x1734ba){if(_0x1734ba&&!_0x14021a){return _0xfeb211[_0x1c8f('0xf')](0x1f4)['json']({'message':_0x1c8f('0xc8'),'pid':_0x3ec867[_0x1c8f('0xbc')]});}});})['catch'](handleError(_0xfeb211,null));};exports[_0x1c8f('0xcc')]=function(_0x140a01,_0x1d51ff){var _0x462410=['mail','chat',_0x1c8f('0xcd'),_0x1c8f('0xce'),_0x1c8f('0xcf'),_0x1c8f('0xd0'),_0x1c8f('0xd1')];var _0x1103be={'offset':0x0,'order':qs['sort']('-createdAt')},_0x3c12da={'count':0x0,'rows':[]};Promise[_0x1c8f('0xd2')]()['then'](function(){if(_0x140a01[_0x1c8f('0x2e')][_0x1c8f('0xd3')]){if(!_[_0x1c8f('0xd4')](_0x462410,_0x140a01[_0x1c8f('0x2e')][_0x1c8f('0xd3')][_0x1c8f('0xd5')]())){throw new Error(_0x1c8f('0xd6'));}_0x462410=[_0x140a01[_0x1c8f('0x2e')][_0x1c8f('0xd3')]['toLowerCase']()];}if(_0x140a01['query'][_0x1c8f('0xd7')]){try{var _0x1ae73b=JSON[_0x1c8f('0xbf')](_0x140a01['query'][_0x1c8f('0xd7')]);if(!moment(_0x1ae73b['from'])[_0x1c8f('0xd8')]()){throw new Error(_0x1c8f('0xd9'));}if(!moment(_0x1ae73b['to'])[_0x1c8f('0xd8')]()){throw new Error('Invalid\x20date\x20for\x20range\x20to\x20filter');}}catch(_0x3a14fe){throw new Error(_0x1c8f('0xda'));}}if(!_0x140a01[_0x1c8f('0x2e')]['hasOwnProperty']('nolimit')){_0x1103be[_0x1c8f('0x12')]=qs[_0x1c8f('0x12')](_0x140a01[_0x1c8f('0x2e')][_0x1c8f('0x12')]||0xa);_0x1103be[_0x1c8f('0x11')]=qs['offset'](_0x140a01[_0x1c8f('0x2e')]['offset']);}var _0x3df44c=_0x462410[_0x1c8f('0x74')](function(_0x392336){if(_0x392336===_0x1c8f('0xd1')){var _0x9f8313={'attributes':['id','uniqueid','type',_0x1c8f('0xdb'),_0x1c8f('0xdc'),_0x1c8f('0xdd'),_0x1c8f('0xde'),'endtime',_0x1c8f('0xdf'),_0x1c8f('0xe0'),_0x1c8f('0xe1'),_0x1c8f('0xe2'),_0x1c8f('0xe3'),_0x1c8f('0xe4'),_0x1c8f('0xe5')],'where':{'ContactId':_0x140a01['params']['id']},'include':[{'model':db['User'],'as':_0x1c8f('0xc1'),'attributes':['id',_0x1c8f('0x1e'),_0x1c8f('0xe6'),_0x1c8f('0x31')]}],'order':[[_0x1c8f('0xe1'),_0x1c8f('0xe7')]]};if(_0x140a01[_0x1c8f('0x2e')]['range']){_0x9f8313[_0x1c8f('0x5d')][_0x1c8f('0xe1')]={'$gte':_0x1ae73b[_0x1c8f('0x39')],'$lte':_0x1ae73b['to']};}return db[_0x1c8f('0x4a')][_0x1c8f('0xe8')](_0x9f8313)[_0x1c8f('0x18')](function(_0x176e80){_0x3c12da[_0x1c8f('0x14')]+=_0x176e80[_0x1c8f('0x14')];return _[_0x1c8f('0x74')](_0x176e80['rows'],function(_0x41920c){var _0x420eaa=_0x41920c[_0x1c8f('0x3a')]({'plain':!![]});_0x420eaa['channel']=_0x392336;if(_0x420eaa[_0x1c8f('0xc1')]){_0x420eaa[_0x1c8f('0xc1')]={'id':_0x420eaa[_0x1c8f('0xc1')]['id'],'name':_0x420eaa[_0x1c8f('0xc1')][_0x1c8f('0x1e')],'fullname':_0x420eaa['User'][_0x1c8f('0xe6')],'alias':_0x420eaa[_0x1c8f('0xc1')][_0x1c8f('0x31')]};}return _0x420eaa;});});}else{var _0x565a95=_[_0x1c8f('0xe9')](_0x392336)+(_0x392336===_0x1c8f('0xea')?'Website':_0x1c8f('0xeb'));var _0x42e9ac={'attributes':['id',_0x1c8f('0xec'),_0x1c8f('0xed'),_0x1c8f('0xe1'),_0x1c8f('0xe0'),_0x1c8f('0xee'),_0x1c8f('0xef'),_0x1c8f('0xf0'),_0x1c8f('0xe5'),_0x565a95+'Id'],'where':{'ContactId':_0x140a01[_0x1c8f('0x27')]['id']},'include':[{'model':db[_0x565a95],'as':'Account','attributes':['id',_0x1c8f('0x1e'),_0x1c8f('0xf1')]},{'model':db[_0x1c8f('0xc1')],'as':_0x1c8f('0xf2'),'attributes':['id',_0x1c8f('0x1e'),'fullname']},{'model':db['Tag'],'as':_0x1c8f('0xf3'),'attributes':['id','name',_0x1c8f('0x66')],'through':{'attributes':[]}}],'order':[[_0x1c8f('0xe1'),_0x1c8f('0xe7')]]};if(_0x140a01[_0x1c8f('0x2e')][_0x1c8f('0xd7')]){_0x42e9ac[_0x1c8f('0x5d')][_0x1c8f('0xe1')]={'$gte':_0x1ae73b[_0x1c8f('0x39')],'$lte':_0x1ae73b['to']};}switch(_0x392336){case _0x1c8f('0xea'):_0x42e9ac[_0x1c8f('0x7e')][_0x1c8f('0x61')](_0x1c8f('0xf4'),'customerIp',_0x1c8f('0xf5'),_0x1c8f('0xf6'),'osName',_0x1c8f('0xf7'),'ratingType',_0x1c8f('0xf8'),_0x1c8f('0xf9'));break;case _0x1c8f('0xfa'):_0x42e9ac[_0x1c8f('0x7e')][_0x1c8f('0x61')](_0x1c8f('0xfb'),'substatus');break;case'openchannel':_0x42e9ac['attributes'][_0x1c8f('0x61')](_0x1c8f('0xfc'),_0x1c8f('0xfd'));break;}return db[_[_0x1c8f('0xe9')](_0x392336)+_0x1c8f('0xfe')][_0x1c8f('0xe8')](_0x42e9ac)[_0x1c8f('0x18')](function(_0x4de5b3){_0x3c12da[_0x1c8f('0x14')]+=_0x4de5b3[_0x1c8f('0x14')];return _[_0x1c8f('0x74')](_0x4de5b3[_0x1c8f('0xa2')],function(_0x1c81f6){var _0x2757d8=_0x1c81f6[_0x1c8f('0x3a')]({'plain':!![]});_0x2757d8['channel']=_0x392336;if(_0x2757d8['Owner']){_0x2757d8['Owner']={'id':_0x2757d8[_0x1c8f('0xf2')]['id'],'name':_0x2757d8[_0x1c8f('0xf2')][_0x1c8f('0x1e')],'fullname':_0x2757d8[_0x1c8f('0xf2')][_0x1c8f('0xe6')]};}return _0x2757d8;});});}});return Promise[_0x1c8f('0x63')](_0x3df44c);})[_0x1c8f('0x18')](function(_0x5d0053){return _(_0x5d0053)['flatten']()[_0x1c8f('0xff')](_0x1c8f('0xe1'))[_0x1c8f('0x100')]()[_0x1c8f('0x101')]();})['then'](function(_0x38080b){_0x3c12da[_0x1c8f('0xa2')]=_0x1103be['limit']?_0x38080b['slice'](_0x1103be[_0x1c8f('0x11')],_0x1103be[_0x1c8f('0x11')]+_0x1103be['limit']):_0x38080b;return _0x3c12da;})[_0x1c8f('0x18')](respondWithFilteredResult(_0x1d51ff,_0x1103be))[_0x1c8f('0x28')](handleError(_0x1d51ff,null));};
\ No newline at end of file
+var _0x372f=['MailMessage','SmsMessage','FaxInteraction','OpenchannelInteraction','CmContactHasItem','CmHopperFinal','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','SmsQueueReport','WhatsappInteraction','WhatsappMessage','isNil','dialTimezone','timezones','utcOffset','additionalPhones','bulkCreate','each','duplicates','where','push','ListId','findOrCreate','spread','contact','show','Tag','Tags','color','tag','Phones','ItemType','literal','Phones.OrderBy','$and','omit','map','format','cf_%d','table','cm_contacts','setFields','id\x20=\x20?','toParam','sequelize','text','phone','getTags','findOne','model','rawAttributes','filters','intersection','fields','attributes','order','sort','pick','filter','options','nolimit','setTags','ids','setAdditionalPhones','all','OrderBy','items','item_types','ItemTypeId','description','PHONE','ContactItemType','`ItemType`.OrderBy','CmHopperId','item','CmHopperAdditionalPhone','duplicateAdditionalPhones','CmContactId','toContactId','getHoppers','includeAll','include','rows','getHopperHistories','ContactId','getJscriptySessions','JscriptySessionReport','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!','root','filename','chmodSync','0777','child_process','fork','../../components/import/cm/csv','CompanyId','File\x20uploaded\x20correctly!','pid','send','upload','file','parse','User','agent','No\x20phone\x20column\x20specified','../../components/import/cm/csv2','stringify','binding','firstName','message','start\x20child\x20process\x20correctly!','exit','error\x20child\x20process','getJourney','mail','chat','sms','openchannel','voice','-createdAt','resolve','includes','toLowerCase','Invalid\x20channel','channel','range','isValid','Invalid\x20date\x20for\x20range\x20from\x20filter','Invalid\x20createdAt\x20filter','uniqueid','source','destination','callerid','starttime','note','createdAt','userSecondDisposition','UserId','DESC','findAndCountAll','fullname','startCase','Website','Account','closed','closedAt','secondDisposition','thirdDisposition','key','Owner','browserName','customerIp','customerPort','deviceModel','referer','subject','substatus','threadId','Interaction','flatten','reverse','value','slice','moment','bluebird','util','path','lodash','papaparse','ioredis','../../components/contacts','../../config/logger','api','../../config/environment','../../config/environment/shared','defaults','socket.io-emitter','./cmContact.socket','register','status','json','offset','undefined','limit','count','set','Content-Range','update','then','destroy','stack','name','describe','getOptions','findAll','query','catch','CmContact','find','params','tags','length','startsWith','cf_','columnName','displayName','analytics','CmCustomField','alias','type','values','info','keys','forEach','hasOwnProperty','merge','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','ChatOfflineMessage','MailInteraction'];(function(_0x1cfcb0,_0x3bb361){var _0x9bf834=function(_0x250007){while(--_0x250007){_0x1cfcb0['push'](_0x1cfcb0['shift']());}};_0x9bf834(++_0x3bb361);}(_0x372f,0xae));var _0xf372=function(_0x17d9e3,_0x1f969c){_0x17d9e3=_0x17d9e3-0x0;var _0x14192d=_0x372f[_0x17d9e3];return _0x14192d;};'use strict';var moment=require(_0xf372('0x0'));var BPromise=require(_0xf372('0x1'));var util=require(_0xf372('0x2'));var path=require(_0xf372('0x3'));var fs=require('fs');var _=require(_0xf372('0x4'));var squel=require('squel');var Papa=require(_0xf372('0x5'));var Redis=require(_0xf372('0x6'));var contacts=require(_0xf372('0x7'));var qs=require('../../components/parsers/qs');var logger=require(_0xf372('0x8'))(_0xf372('0x9'));var config=require(_0xf372('0xa'));var shared=require(_0xf372('0xb'));var db=require('../../mysqldb')['db'];config['redis']=_[_0xf372('0xc')](config['redis'],{'host':'localhost','port':0x18eb});var socket=require(_0xf372('0xd'))(new Redis(config['redis']));require(_0xf372('0xe'))[_0xf372('0xf')](socket);function respondWithResult(_0x88a1d,_0x23b1ec){_0x23b1ec=_0x23b1ec||0xc8;return function(_0x503153){if(_0x503153){return _0x88a1d[_0xf372('0x10')](_0x23b1ec)[_0xf372('0x11')](_0x503153);}};}function respondWithFilteredResult(_0x303697,_0x3956b5){return function(_0x379c30){if(_0x379c30){var _0x37808e=typeof _0x3956b5[_0xf372('0x12')]===_0xf372('0x13')&&typeof _0x3956b5[_0xf372('0x14')]===_0xf372('0x13');var _0x397a5e=_0x379c30[_0xf372('0x15')];var _0x3cdd7c=_0x37808e?0x0:_0x3956b5[_0xf372('0x12')];var _0xa6696d=_0x37808e?_0x379c30['count']:_0x3956b5[_0xf372('0x12')]+_0x3956b5['limit'];var _0x12445d;if(_0xa6696d>=_0x397a5e){_0xa6696d=_0x397a5e;_0x12445d=0xc8;}else{_0x12445d=0xce;}_0x303697[_0xf372('0x10')](_0x12445d);return _0x303697[_0xf372('0x16')](_0xf372('0x17'),_0x3cdd7c+'-'+_0xa6696d+'/'+_0x397a5e)[_0xf372('0x11')](_0x379c30);}return null;};}function saveUpdates(_0xbaeb57){return function(_0x2fa07b){if(_0x2fa07b){return _0x2fa07b[_0xf372('0x18')](_0xbaeb57)[_0xf372('0x19')](function(_0x396814){return _0x396814;});}return null;};}function removeEntity(_0x3477a2){return function(_0x31cd51){if(_0x31cd51){return _0x31cd51[_0xf372('0x1a')]()[_0xf372('0x19')](function(){_0x3477a2[_0xf372('0x10')](0xcc)['end']();});}};}function handleEntityNotFound(_0x3f29ea){return function(_0x46390f){if(!_0x46390f){_0x3f29ea['sendStatus'](0x194);}return _0x46390f;};}function handleError(_0x4be8c8,_0x3a15e4){_0x3a15e4=_0x3a15e4||0x1f4;return function(_0x222243){logger['error'](_0x222243[_0xf372('0x1b')]);if(_0x222243[_0xf372('0x1c')]){delete _0x222243[_0xf372('0x1c')];}_0x4be8c8[_0xf372('0x10')](_0x3a15e4)['send'](_0x222243);};}exports['index']=function(_0x428e80,_0x102b8e){var _0x4e2bd2={};return contacts[_0xf372('0x1d')]()[_0xf372('0x19')](function(_0x271f93){_0x4e2bd2=qs[_0xf372('0x1e')](_0x271f93,_0x428e80);return contacts[_0xf372('0x1f')](_0x428e80[_0xf372('0x20')],_0x428e80['user'],_0x4e2bd2,_0x271f93);})[_0xf372('0x19')](respondWithFilteredResult(_0x102b8e,_0x4e2bd2))[_0xf372('0x21')](handleError(_0x102b8e,null));};exports['destroy']=function(_0x469918,_0xfe8b7a){return db[_0xf372('0x22')][_0xf372('0x23')]({'where':{'id':_0x469918[_0xf372('0x24')]['id']}})[_0xf372('0x19')](handleEntityNotFound(_0xfe8b7a,null))[_0xf372('0x19')](removeEntity(_0xfe8b7a,null))[_0xf372('0x21')](handleError(_0xfe8b7a,null));};exports['describe']=function(_0xfd29e0,_0x3fe061){return db[_0xf372('0x22')]['describe']()[_0xf372('0x19')](function(_0x321fdc){delete _0x321fdc[_0xf372('0x25')];for(var _0x31349e=0x0;_0x31349e<Object['keys'](_0x321fdc)[_0xf372('0x26')];_0x31349e++){var _0x1fd2cf=Object['keys'](_0x321fdc)[_0x31349e];if(!_[_0xf372('0x27')](_0x1fd2cf,_0xf372('0x28'))){_0x321fdc[_0x1fd2cf][_0xf372('0x29')]=_0x1fd2cf;_0x321fdc[_0x1fd2cf][_0xf372('0x2a')]=_0x1fd2cf;}}return _0x321fdc;})[_0xf372('0x19')](function(_0x340097){var _0x2f734f={'where':Boolean(_0xfd29e0[_0xf372('0x20')][_0xf372('0x2b')])===!![]?undefined:{'$or':[{'ListId':_0xfd29e0[_0xf372('0x20')]['id']},{'ListId':null}]},'raw':!![]};return db[_0xf372('0x2c')]['findAll'](_0x2f734f)['then'](function(_0x3895a6){for(var _0x13e6df=0x0;_0x13e6df<_0x3895a6[_0xf372('0x26')];_0x13e6df++){var _0x3e393a=_0xf372('0x28')+_0x3895a6[_0x13e6df]['id'];if(_0x340097[_0x3e393a]){_0x340097[_0x3e393a][_0xf372('0x29')]=_0x3e393a;_0x340097[_0x3e393a][_0xf372('0x2a')]=_0x3895a6[_0x13e6df][_0xf372('0x2d')];_0x340097[_0x3e393a]['custom']={'type':_0x3895a6[_0x13e6df][_0xf372('0x2e')],'values':_0x3895a6[_0x13e6df][_0xf372('0x2f')]};}else{logger[_0xf372('0x30')]('Custom\x20field\x20%s\x20not\x20found\x20on\x20cm_contacts\x20table',_0x3e393a);}}Object[_0xf372('0x31')](_0x340097)[_0xf372('0x32')](function(_0x33095d){if(!_0x340097[_0x33095d][_0xf372('0x33')]('columnName')){delete _0x340097[_0x33095d];}});return _0x340097;});})[_0xf372('0x19')](respondWithResult(_0x3fe061,null))['catch'](handleError(_0x3fe061,null));};exports[_0xf372('0x34')]=function(_0x154aeb,_0x19900a){var _0x2a4022;var _0x38c5e7;var _0x4cb761;if(_0x154aeb[_0xf372('0x35')]['id']){delete _0x154aeb[_0xf372('0x35')]['id'];}return db[_0xf372('0x22')][_0xf372('0x1f')]({'where':{'id':[_0x154aeb['body']['to'],_0x154aeb[_0xf372('0x35')][_0xf372('0x36')]]}})[_0xf372('0x19')](function(_0x157e36){if(_0x157e36){if(_0x157e36[_0xf372('0x26')]!==0x2){return null;}_0x157e36[0x0]=_0x157e36[0x0][_0xf372('0x37')]({'plain':!![]});_0x157e36[0x1]=_0x157e36[0x1][_0xf372('0x37')]({'plain':!![]});delete _0x157e36[0x0]['id'];delete _0x157e36[0x1]['id'];return _[_0xf372('0x38')](_0x157e36[0x0],_0x157e36[0x1],function(_0x22f43b,_0x2e8f75){if(Array[_0xf372('0x39')](_0x2e8f75)&&!_0x2e8f75[_0xf372('0x26')]){return _0x22f43b;}else if(!_0x2e8f75){return _0x22f43b;}});}})[_0xf372('0x19')](handleEntityNotFound(_0x19900a,null))[_0xf372('0x19')](function(_0x52a8b0){if(_0x52a8b0){if(_0x52a8b0[_0xf372('0x25')]&&_[_0xf372('0x39')](_0x52a8b0[_0xf372('0x25')])){_0x52a8b0[_0xf372('0x25')]=_0x52a8b0[_0xf372('0x25')][_0xf372('0x3a')]();}logger['info'](_0xf372('0x3b'),_0x154aeb[_0xf372('0x35')]['to'],_0x154aeb[_0xf372('0x35')]['from']);return db[_0xf372('0x3c')][_0xf372('0x1a')]({'where':{'ContactId':[_0x154aeb[_0xf372('0x35')]['to'],_0x154aeb[_0xf372('0x35')]['from']]}})[_0xf372('0x19')](function(_0x1574c0){logger[_0xf372('0x30')](_0xf372('0x3d'),_0x1574c0);return db['CmHopperBlack'][_0xf372('0x1a')]({'where':{'ContactId':[_0x154aeb[_0xf372('0x35')]['to'],_0x154aeb[_0xf372('0x35')][_0xf372('0x36')]]}})[_0xf372('0x19')](function(_0x37c1a6){logger[_0xf372('0x30')](_0xf372('0x3e'),_0x37c1a6);return db[_0xf372('0x22')][_0xf372('0x3f')](_0x52a8b0);});});}})[_0xf372('0x19')](function(_0x10c8a2){if(_0x10c8a2){_0x2a4022=_0x10c8a2;_0x38c5e7={'ContactId':_0x2a4022['id']};_0x4cb761={'where':{'ContactId':[_0x154aeb[_0xf372('0x35')]['to'],_0x154aeb[_0xf372('0x35')]['from']]}};return db['ChatInteraction'][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})[_0xf372('0x19')](function(){if(_0x2a4022){return db[_0xf372('0x40')][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})[_0xf372('0x19')](function(){if(_0x2a4022){return db[_0xf372('0x41')][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})[_0xf372('0x19')](function(){if(_0x2a4022){return db[_0xf372('0x42')][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})[_0xf372('0x19')](function(){if(_0x2a4022){return db['MailMessage']['update'](_0x38c5e7,_0x4cb761);}})[_0xf372('0x19')](function(){if(_0x2a4022){return db[_0xf372('0x42')]['update'](_0x38c5e7,_0x4cb761);}})[_0xf372('0x19')](function(){if(_0x2a4022){return db[_0xf372('0x43')][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})[_0xf372('0x19')](function(){if(_0x2a4022){return db['SmsInteraction'][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})[_0xf372('0x19')](function(){if(_0x2a4022){return db[_0xf372('0x44')][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})['then'](function(){if(_0x2a4022){return db[_0xf372('0x45')][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})[_0xf372('0x19')](function(){if(_0x2a4022){return db['FaxMessage'][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})[_0xf372('0x19')](function(){if(_0x2a4022){return db[_0xf372('0x46')][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})[_0xf372('0x19')](function(){if(_0x2a4022){return db['OpenchannelMessage'][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})[_0xf372('0x19')](function(){if(_0x2a4022){return db[_0xf372('0x47')][_0xf372('0x18')]({'CmContactId':_0x2a4022['id']},{'where':{'CmContactId':[_0x154aeb[_0xf372('0x35')]['to'],_0x154aeb[_0xf372('0x35')][_0xf372('0x36')]]}});}})[_0xf372('0x19')](function(){if(_0x2a4022){return db[_0xf372('0x48')][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})[_0xf372('0x19')](function(){if(_0x2a4022){return db[_0xf372('0x49')][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})['then'](function(){if(_0x2a4022){return db[_0xf372('0x4a')][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})[_0xf372('0x19')](function(){if(_0x2a4022){return db[_0xf372('0x4b')][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})[_0xf372('0x19')](function(){if(_0x2a4022){return db[_0xf372('0x4c')][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})['then'](function(){if(_0x2a4022){return db['FaxQueueReport'][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})['then'](function(){if(_0x2a4022){return db['MailQueueReport'][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})[_0xf372('0x19')](function(){if(_0x2a4022){return db['OpenchannelQueueReport']['update'](_0x38c5e7,_0x4cb761);}})['then'](function(){if(_0x2a4022){return db[_0xf372('0x4d')][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})[_0xf372('0x19')](function(){if(_0x2a4022){return db['JscriptySessionReport'][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})[_0xf372('0x19')](function(){if(_0x2a4022){return db[_0xf372('0x4e')][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})[_0xf372('0x19')](function(){if(_0x2a4022){return db[_0xf372('0x4f')]['update'](_0x38c5e7,_0x4cb761);}})[_0xf372('0x19')](function(){if(_0x2a4022){return db['WhatsappQueueReport'][_0xf372('0x18')](_0x38c5e7,_0x4cb761);}})[_0xf372('0x19')](function(){if(_0x2a4022){return db[_0xf372('0x22')][_0xf372('0x1a')]({'where':{'id':[_0x154aeb[_0xf372('0x35')]['to'],_0x154aeb[_0xf372('0x35')][_0xf372('0x36')]]}});}})[_0xf372('0x19')](function(){if(_0x2a4022){return _0x2a4022;}})[_0xf372('0x19')](respondWithResult(_0x19900a,null))[_0xf372('0x21')](handleError(_0x19900a,null));};exports['create']=function(_0x10ec4b,_0x41094f){return db[_0xf372('0x22')][_0xf372('0x1d')]()[_0xf372('0x19')](function(_0xe23b81){if(_0x10ec4b['body']['tags']&&_[_0xf372('0x39')](_0x10ec4b[_0xf372('0x35')][_0xf372('0x25')])){if(_0x10ec4b[_0xf372('0x35')][_0xf372('0x25')][_0xf372('0x26')]){_0x10ec4b[_0xf372('0x35')][_0xf372('0x25')]=_0x10ec4b['body'][_0xf372('0x25')][_0xf372('0x3a')](';')+';';}else{_0x10ec4b[_0xf372('0x35')][_0xf372('0x25')]=null;}}else{_0x10ec4b[_0xf372('0x35')][_0xf372('0x25')]=null;}if(!_[_0xf372('0x50')](_0x10ec4b[_0xf372('0x35')]['dialTimezone'])){var _0x357dbf=_0x10ec4b[_0xf372('0x35')][_0xf372('0x51')];if(!_[_0xf372('0x50')](shared[_0xf372('0x52')][_0x357dbf]))_0x10ec4b['body'][_0xf372('0x53')]=shared['timezones'][_0x357dbf][_0xf372('0x53')];}return db[_0xf372('0x22')]['create'](_0x10ec4b[_0xf372('0x35')],{'fields':_[_0xf372('0x31')](_0xe23b81),'raw':!![]});})[_0xf372('0x19')](function(_0x2434ce){if(_0x10ec4b[_0xf372('0x35')][_0xf372('0x54')]){return insertAdditionalPhones(_0x2434ce,_0x10ec4b['body'][_0xf372('0x54')]);}else{return _0x2434ce;}})[_0xf372('0x19')](respondWithResult(_0x41094f,0xc9))[_0xf372('0x21')](handleError(_0x41094f,null));};exports[_0xf372('0x55')]=function(_0x599aad,_0x5b6951){var _0xa382d0=0x0;var _0x455b9f=0x0;var _0x320f6d=0x0;var _0x265720=[];return db[_0xf372('0x22')][_0xf372('0x1d')]()[_0xf372('0x19')](function(_0x529195){return BPromise[_0xf372('0x56')](_0x599aad[_0xf372('0x35')],function(_0x54c24d){var _0x573508={'where':{'$or':[]},'defaults':_0x54c24d,'fields':_[_0xf372('0x31')](_0x529195),'raw':!![]};if(_0x54c24d[_0xf372('0x57')]){for(var _0x24762a=0x0;_0x24762a<_0x54c24d[_0xf372('0x57')][_0xf372('0x26')];_0x24762a++){var _0x2d8e71={};_0x2d8e71[_0x54c24d[_0xf372('0x57')][_0x24762a]]=_0x54c24d[_0x54c24d[_0xf372('0x57')][_0x24762a]];_0x573508[_0xf372('0x58')]['$or'][_0xf372('0x59')](_0x2d8e71);}_0x573508[_0xf372('0x58')]['ListId']=_0x54c24d[_0xf372('0x5a')];}return db[_0xf372('0x22')][_0xf372('0x5b')](_0x573508)[_0xf372('0x5c')](function(_0x161196,_0x1617ec){if(_0x1617ec){if(_0x54c24d[_0xf372('0x33')](_0xf372('0x54'))){_0x265720['push']({'contact':_0x161196,'additionalPhones':_0x54c24d[_0xf372('0x54')]});}_0xa382d0++;}else{_0x320f6d++;}})[_0xf372('0x21')](function(){_0x455b9f++;});});})[_0xf372('0x19')](function(_0x5dcba8){if(_0x5dcba8){if(_0x265720['length']>0x0){return new Promise(function(_0x580bef){var _0x5a9c12=[];for(var _0x47b835=0x0;_0x47b835<_0x265720[_0xf372('0x26')];_0x47b835++){_0x5a9c12[_0xf372('0x59')](insertAdditionalPhones(_0x265720[_0x47b835][_0xf372('0x5d')],_0x265720[_0x47b835][_0xf372('0x54')]));}Promise['all'](_0x5a9c12)[_0xf372('0x19')](function(){_0x580bef(0x1);});})[_0xf372('0x19')](function(){return{'success':_0xa382d0,'failure':_0x455b9f,'duplicates':_0x320f6d};});}else{return{'success':_0xa382d0,'failure':_0x455b9f,'duplicates':_0x320f6d};}}})['then'](respondWithResult(_0x5b6951,0xc9))[_0xf372('0x21')](handleError(_0x5b6951,null));};exports[_0xf372('0x5e')]=function(_0xa604d9,_0x1c1828){var _0x248c48;return db['CmContact']['describe']()['then'](function(_0x4f6283){return db[_0xf372('0x22')][_0xf372('0x23')]({'where':{'id':_0xa604d9[_0xf372('0x24')]['id']},'include':[{'model':db[_0xf372('0x5f')],'as':_0xf372('0x60'),'attributes':['id',_0xf372('0x1c'),_0xf372('0x61')],'required':_0xa604d9[_0xf372('0x20')][_0xf372('0x62')]?!![]:![]},{'model':db[_0xf372('0x47')],'as':_0xf372('0x63'),'where':{'CmContactId':_0xa604d9[_0xf372('0x24')]['id']},'required':![],'include':[{'model':db['ContactItemType'],'as':_0xf372('0x64')}]}],'order':[db['sequelize'][_0xf372('0x65')](_0xf372('0x66'))],'attributes':_['keys'](_0x4f6283)});})['then'](function(_0x62b661){if(!_[_0xf372('0x50')](_0x62b661)){_0x248c48=_0x62b661[_0xf372('0x37')]({'plain':!![]});var _0x25718f={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x62b661&&_0x62b661[_0xf372('0x5a')]){if(_0x62b661[_0xf372('0x5a')]){_0x25718f['where'][_0xf372('0x67')][_0xf372('0x59')]({'ListId':{'$ne':_0x62b661[_0xf372('0x5a')]}});}}return db['CmCustomField']['findAll'](_0x25718f);}})[_0xf372('0x19')](function(_0x1156b4){if(!_[_0xf372('0x50')](_0x1156b4)){return _[_0xf372('0x68')](_0x248c48,_[_0xf372('0x69')](_0x1156b4,function(_0x251904){return util[_0xf372('0x6a')]('cf_%d',_0x251904['id']);}));}})[_0xf372('0x19')](handleEntityNotFound(_0x1c1828,null))[_0xf372('0x19')](respondWithResult(_0x1c1828,null))[_0xf372('0x21')](handleError(_0x1c1828,null));};exports[_0xf372('0x18')]=function(_0x10632c,_0x516df3){var _0x5510ed;if(_0x10632c[_0xf372('0x35')]['id']){delete _0x10632c[_0xf372('0x35')]['id'];}if(!_[_0xf372('0x50')](_0x10632c[_0xf372('0x35')][_0xf372('0x51')])){var _0x4e7367=_0x10632c['body']['dialTimezone'];if(!_['isNil'](shared[_0xf372('0x52')][_0x4e7367]))_0x10632c[_0xf372('0x35')]['utcOffset']=shared[_0xf372('0x52')][_0x4e7367][_0xf372('0x53')];}return db[_0xf372('0x22')]['find']({'where':{'id':_0x10632c['params']['id']}})['then'](handleEntityNotFound(_0x516df3,null))[_0xf372('0x19')](saveUpdates(_0x10632c[_0xf372('0x35')],null))[_0xf372('0x19')](function(_0x482c53){_0x5510ed=_0x482c53;var _0x148007={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x482c53&&_0x482c53[_0xf372('0x5a')]){if(_0x482c53[_0xf372('0x5a')]){_0x148007[_0xf372('0x58')][_0xf372('0x67')][_0xf372('0x59')]({'ListId':{'$ne':_0x482c53[_0xf372('0x5a')]}});}}return db[_0xf372('0x2c')]['findAll'](_0x148007);})['then'](function(_0x578d6e){if(_0x578d6e){return _[_0xf372('0x68')](_['pickBy'](_0x10632c[_0xf372('0x35')],function(_0x198189,_0x497a47){return _['startsWith'](_0x497a47,'cf_');}),_[_0xf372('0x69')](_0x578d6e,function(_0x3f08a3){return util[_0xf372('0x6a')](_0xf372('0x6b'),_0x3f08a3['id']);}));}})[_0xf372('0x19')](function(_0x1cd1df){if(_0x1cd1df&&!_['isEmpty'](_0x1cd1df)){var _0x25653=squel[_0xf372('0x18')]()[_0xf372('0x6c')](_0xf372('0x6d'))[_0xf372('0x6e')](_0x1cd1df)[_0xf372('0x58')](_0xf372('0x6f'),_0x10632c[_0xf372('0x24')]['id'])[_0xf372('0x70')]();return db[_0xf372('0x71')]['query'](_0x25653[_0xf372('0x72')],{'replacements':_0x25653[_0xf372('0x2f')]});}})['then'](function(){if(_0x10632c[_0xf372('0x35')][_0xf372('0x73')]&&_0x5510ed){return db[_0xf372('0x3c')][_0xf372('0x18')]({'phone':_0x10632c['body'][_0xf372('0x73')],'OrderBy':0x0},{'where':{'ContactId':_0x5510ed['id']}});}})[_0xf372('0x19')](function(){return _0x5510ed;})['then'](respondWithResult(_0x516df3,null))['catch'](handleError(_0x516df3,null));};exports[_0xf372('0x74')]=function(_0x7430bc,_0x178bed){var _0x2a53f7={};var _0xbb8e51={};var _0x23b278;var _0x56cc3b;return db[_0xf372('0x22')][_0xf372('0x75')]({'where':{'id':_0x7430bc[_0xf372('0x24')]['id']}})['then'](handleEntityNotFound(_0x178bed,null))[_0xf372('0x19')](function(_0x19f116){if(_0x19f116){_0x23b278=_0x19f116;_0xbb8e51[_0xf372('0x76')]=_['keys'](db[_0xf372('0x5f')][_0xf372('0x77')]);_0xbb8e51[_0xf372('0x20')]=_[_0xf372('0x31')](_0x7430bc['query']);_0xbb8e51[_0xf372('0x78')]=_[_0xf372('0x79')](_0xbb8e51[_0xf372('0x76')],_0xbb8e51[_0xf372('0x20')]);_0x2a53f7['attributes']=_[_0xf372('0x79')](_0xbb8e51['model'],qs[_0xf372('0x7a')](_0x7430bc[_0xf372('0x20')]['fields']));_0x2a53f7[_0xf372('0x7b')]=_0x2a53f7['attributes'][_0xf372('0x26')]?_0x2a53f7[_0xf372('0x7b')]:_0xbb8e51[_0xf372('0x76')];_0x2a53f7[_0xf372('0x7c')]=qs[_0xf372('0x7d')](_0x7430bc[_0xf372('0x20')]['sort']);_0x2a53f7[_0xf372('0x58')]=qs[_0xf372('0x78')](_[_0xf372('0x7e')](_0x7430bc['query'],_0xbb8e51[_0xf372('0x78')]));if(_0x7430bc[_0xf372('0x20')][_0xf372('0x7f')]){_0x2a53f7[_0xf372('0x58')]=_['merge'](_0x2a53f7[_0xf372('0x58')],{'$or':_['map'](_0x2a53f7['attributes'],function(_0x482a94){var _0xf552a4={};_0xf552a4[_0x482a94]={'$like':'%'+_0x7430bc['query'][_0xf372('0x7f')]+'%'};return _0xf552a4;})});}_0x2a53f7=_[_0xf372('0x34')]({},_0x2a53f7,_0x7430bc[_0xf372('0x80')]);return _0x23b278[_0xf372('0x74')](_0x2a53f7);}})[_0xf372('0x19')](function(_0x3cf030){if(_0x3cf030){_0x56cc3b=_0x3cf030[_0xf372('0x26')];if(!_0x7430bc[_0xf372('0x20')][_0xf372('0x33')](_0xf372('0x81'))){_0x2a53f7[_0xf372('0x14')]=qs['limit'](_0x7430bc[_0xf372('0x20')][_0xf372('0x14')]);_0x2a53f7['offset']=qs[_0xf372('0x12')](_0x7430bc['query'][_0xf372('0x12')]);}return _0x23b278[_0xf372('0x74')](_0x2a53f7);}})['then'](function(_0x30a8b7){if(_0x30a8b7){return _0x30a8b7?{'count':_0x56cc3b,'rows':_0x30a8b7}:null;}})['then'](respondWithResult(_0x178bed,null))[_0xf372('0x21')](handleError(_0x178bed,null));};exports[_0xf372('0x82')]=function(_0x1725cf,_0x1d7514){if(_0x1725cf['body']['id']){delete _0x1725cf[_0xf372('0x35')]['id'];}return db[_0xf372('0x22')][_0xf372('0x75')]({'where':{'id':_0x1725cf[_0xf372('0x24')]['id']}})[_0xf372('0x19')](handleEntityNotFound(_0x1d7514,null))[_0xf372('0x19')](function(_0x5c5000){if(_0x5c5000){return _0x5c5000[_0xf372('0x82')](_0x1725cf[_0xf372('0x35')][_0xf372('0x83')]||[]);}return null;})[_0xf372('0x19')](respondWithResult(_0x1d7514,null))[_0xf372('0x21')](handleError(_0x1d7514,null));};exports[_0xf372('0x84')]=function(_0x13c77f,_0x318a5f){var _0xa56f97=[];_0xa56f97[_0xf372('0x59')](addAdditionalPhones(_0x13c77f['body']));Promise[_0xf372('0x85')](_0xa56f97)[_0xf372('0x19')](function(){_0xa56f97=[];_0xa56f97[_0xf372('0x59')](deleteCmHopperPhones(_0x13c77f[_0xf372('0x35')]['id']));_0xa56f97[_0xf372('0x59')](addCmHopperPhones(_0x13c77f['body']['id']));Promise[_0xf372('0x85')](_0xa56f97)[_0xf372('0x19')](function(){return[0x1];})[_0xf372('0x19')](respondWithResult(_0x318a5f,null));});};function addAdditionalPhones(_0x545ee4){var _0x4e781c;return new Promise(function(_0x1fa210){return db['CmContactHasItem'][_0xf372('0x1a')]({'where':{'CmContactId':_0x545ee4['id']}})[_0xf372('0x19')](function(){db['ContactItemType']['findAll']({'raw':!![],'attributes':['id',_0xf372('0x86')]})['then'](function(_0x5082fb){var _0x4b0631=[];for(var _0x9b29e5=0x0;_0x9b29e5<_0x545ee4[_0xf372('0x87')][_0xf372('0x26')];_0x9b29e5++){var _0x253876=_0x545ee4[_0xf372('0x88')]?_[_0xf372('0x50')](_0x545ee4[_0xf372('0x88')][_0x9b29e5])?'':_0x545ee4[_0xf372('0x88')][_0x9b29e5]:_0x545ee4[_0xf372('0x87')][_0x9b29e5][_0xf372('0x89')]?_0x545ee4[_0xf372('0x87')][_0x9b29e5][_0xf372('0x89')]:'';var _0x13d4ab=_['isNil'](_0x545ee4['items'][_0x9b29e5][_0xf372('0x8a')])?'':_0x545ee4[_0xf372('0x87')][_0x9b29e5][_0xf372('0x8a')];var _0x517242=_0x253876+':'+_0x545ee4[_0xf372('0x87')][_0x9b29e5][_0xf372('0x73')]+'§'+_0x13d4ab;if(_[_0xf372('0x50')](_0x4e781c))_0x4e781c=_0x517242;else _0x4e781c+=';'+_0x517242;var _0x3e83c2=null;var _0x4682d9=null;if(_0x545ee4[_0xf372('0x88')]){if(!_[_0xf372('0x50')](_0x545ee4['item_types'][_0x9b29e5])){_0x4682d9=_[_0xf372('0x23')](_0x5082fb,function(_0x53c0bf){return _0x53c0bf['id']===_0x545ee4['item_types'][_0x9b29e5];});if(!_['isNil'](_0x4682d9)){_0x3e83c2=_0x4682d9[_0xf372('0x86')];}}}else{if(!_['isNil'](_0x545ee4['items'][_0x9b29e5])){_0x4682d9=_[_0xf372('0x23')](_0x5082fb,function(_0xd16329){return _0xd16329['id']===_0x545ee4[_0xf372('0x87')][_0x9b29e5][_0xf372('0x89')];});if(!_['isNil'](_0x4682d9)){_0x3e83c2=_0x9b29e5;}}}if(_[_0xf372('0x50')](_0x3e83c2)){_0x3e83c2=0x64;}_0x4b0631[_0xf372('0x59')](addAdditionalPhone(_0x545ee4['id'],_0x545ee4[_0xf372('0x87')][_0x9b29e5][_0xf372('0x73')],_0x545ee4['item_types']?_[_0xf372('0x50')](_0x545ee4[_0xf372('0x88')][_0x9b29e5])?null:_0x545ee4[_0xf372('0x88')][_0x9b29e5]:_0x545ee4[_0xf372('0x87')][_0x9b29e5][_0xf372('0x89')]?_0x545ee4['items'][_0x9b29e5][_0xf372('0x89')]:null,_0x3e83c2,_0x13d4ab));}Promise[_0xf372('0x85')](_0x4b0631)[_0xf372('0x19')](function(){db[_0xf372('0x22')][_0xf372('0x18')]({'AdditionalPhones':_0x4e781c},{'where':{'id':_0x545ee4['id']}})['then'](function(){_0x1fa210(0x1);});});});});});}function addAdditionalPhone(_0x30033d,_0x1963e7,_0x3502c2,_0x3a93eb,_0x2531f2){return db[_0xf372('0x47')][_0xf372('0x23')]({'where':{'CmContactId':_0x30033d,'item':_0x1963e7}})[_0xf372('0x19')](function(_0x9b9e94){if(_0x9b9e94)logger['info']('contact\x20phone\x20exists',_0x9b9e94);else{db[_0xf372('0x47')]['create']({'CmContactId':_0x30033d,'item':_0x1963e7,'ItemTypeId':_0x3502c2,'OrderBy':_0x3a93eb,'ItemClass':_0xf372('0x8b'),'description':_0x2531f2});}});}function deleteCmHopperPhones(_0x5d9112){return new Promise(function(_0x58ce06){return db['CmHopper'][_0xf372('0x1f')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x5d9112}})['then'](function(_0x3a4993){db['CmHopperAdditionalPhone']['destroy']({'where':{'CmHopperId':{'$in':_[_0xf372('0x69')](_0x3a4993,'id')}}});})[_0xf372('0x19')](function(){_0x58ce06(0x1);});});}function addCmHopperPhones(_0x3b3047){return new Promise(function(_0x1ff916){return db[_0xf372('0x3c')][_0xf372('0x1f')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x3b3047}})['then'](function(_0x521b48){var _0x2479bb=[];_[_0xf372('0x69')](_0x521b48,function(_0x3c6e20){_0x2479bb['push'](createCmHopperPhone(_0x3b3047,_0x3c6e20['id']));});Promise['all'](_0x2479bb)['then'](function(){_0x1ff916(0x1);});});});}function createCmHopperPhone(_0x14786c,_0x19d104){return new Promise(function(_0x1b5607){db['CmContactHasItem'][_0xf372('0x1f')]({'raw':!![],'attributes':['item',_0xf372('0x86')],'where':{'CmContactId':_0x14786c,'ItemClass':_0xf372('0x8b')},'include':[{'model':db[_0xf372('0x8c')],'attributes':[_0xf372('0x86')],'as':_0xf372('0x64')}],'order':[_0xf372('0x86'),db[_0xf372('0x71')][_0xf372('0x65')](_0xf372('0x8d'))]})[_0xf372('0x19')](function(_0x1d0a68){var _0x2790b0=0x1;var _0x3e1387=_[_0xf372('0x69')](_0x1d0a68,function(_0x628b0e){_0x628b0e[_0xf372('0x8e')]=_0x19d104;_0x628b0e[_0xf372('0x73')]=_0x628b0e[_0xf372('0x8f')];_0x628b0e[_0xf372('0x86')]=_0x2790b0;delete _0x628b0e['ItemType.OrderBy'];_0x2790b0=_0x2790b0+0x1;return _0x628b0e;});return db[_0xf372('0x90')][_0xf372('0x55')](_0x3e1387,{});})['then'](function(){_0x1b5607(0x1);});});}function insertAdditionalPhones(_0x5601e4,_0x3893d0){return new Promise(function(_0x41e93e){var _0x1560a3=[];for(var _0x502020=0x0;_0x502020<_0x3893d0[_0xf372('0x26')];_0x502020++){var _0xc77c37=_0x3893d0[_0x502020];_0x1560a3[_0xf372('0x59')](parseContactItemType(_0xc77c37));}Promise[_0xf372('0x85')](_0x1560a3)[_0xf372('0x19')](function(){var _0x33427a={'id':_0x5601e4['id'],'items':_0x3893d0};return addAdditionalPhones(_0x33427a)[_0xf372('0x19')](function(){return addCmHopperPhones(_0x5601e4['id']);});})['then'](function(){_0x41e93e(_0x5601e4);});});}function parseContactItemType(_0x3a352a){return new Promise(function(_0x534d2a){if(_0x3a352a[_0xf372('0x33')](_0xf372('0x89'))){_0x534d2a(_0x3a352a);}else{return db['ContactItemType'][_0xf372('0x23')]({'where':{'name':_0x3a352a[_0xf372('0x64')]}})[_0xf372('0x19')](function(_0x5f5829){if(_[_0xf372('0x50')](_0x5f5829))_0x3a352a[_0xf372('0x89')]=null;else _0x3a352a['ItemTypeId']=_0x5f5829['id'];_0x534d2a(_0x3a352a);});}});}exports['getAdditionalPhones']=function(_0x127755,_0x2b0f3a){return db[_0xf372('0x47')][_0xf372('0x1f')]({'raw':!![],'where':{'CmContactId':_0x127755[_0xf372('0x24')]['id'],'ItemClass':_0xf372('0x8b')},'include':[{'model':db[_0xf372('0x8c')],'as':_0xf372('0x64')}],'order':[[_0xf372('0x86')],[db[_0xf372('0x71')][_0xf372('0x65')]('`ItemType`.OrderBy')]]})[_0xf372('0x19')](function(_0x5dbe22){return _0x5dbe22;})[_0xf372('0x19')](respondWithResult(_0x2b0f3a,null))[_0xf372('0x21')](handleError(_0x2b0f3a,null));};exports[_0xf372('0x91')]=function(_0x266261,_0x5a0cf9){return db['CmContactHasItem'][_0xf372('0x1f')]({'raw':!![],'where':{'CmContactId':_0x266261[_0xf372('0x35')]['fromContactId']}})[_0xf372('0x19')](function(_0x1ad7a9){var _0xb1950b=_[_0xf372('0x69')](_0x1ad7a9,function(_0x47018e){_0x47018e[_0xf372('0x92')]=_0x266261[_0xf372('0x35')][_0xf372('0x93')];return _0x47018e;});return db['CmContactHasItem'][_0xf372('0x55')](_0xb1950b,{});})['then'](function(){return addCmHopperPhones(_0x266261[_0xf372('0x35')][_0xf372('0x93')]);})[_0xf372('0x19')](function(){return['ok'];})[_0xf372('0x19')](respondWithResult(_0x5a0cf9,null))[_0xf372('0x21')](handleError(_0x5a0cf9,null));};exports['rescheduleAdditionalPhones']=function(_0x14b0ef,_0x26ece6){var _0x65fc9d=[];_0x65fc9d[_0xf372('0x59')](createCmHopperPhone(_0x14b0ef[_0xf372('0x35')]['id'],_0x14b0ef[_0xf372('0x35')]['hopperId']));Promise['all'](_0x65fc9d)[_0xf372('0x19')](function(){return[0x1];})[_0xf372('0x19')](respondWithResult(_0x26ece6,null));};exports[_0xf372('0x94')]=function(_0x59aa49,_0xbf5562){var _0x14e998={'raw':![],'where':{}};var _0x18930c={};var _0x160fc2={'count':0x0,'rows':[]};return db[_0xf372('0x22')][_0xf372('0x75')]({'where':{'id':_0x59aa49['params']['id']}})[_0xf372('0x19')](handleEntityNotFound(_0xbf5562,null))[_0xf372('0x19')](function(_0x31333a){if(_0x31333a){_0x18930c[_0xf372('0x76')]=_[_0xf372('0x31')](db['CmHopper'][_0xf372('0x77')]);_0x18930c['query']=_[_0xf372('0x31')](_0x59aa49['query']);_0x18930c[_0xf372('0x78')]=_[_0xf372('0x79')](_0x18930c['model'],_0x18930c[_0xf372('0x20')]);_0x14e998[_0xf372('0x7b')]=_[_0xf372('0x79')](_0x18930c[_0xf372('0x76')],qs[_0xf372('0x7a')](_0x59aa49[_0xf372('0x20')][_0xf372('0x7a')]));_0x14e998['attributes']=_0x14e998['attributes']['length']?_0x14e998['attributes']:_0x18930c['model'];if(!_0x59aa49['query'][_0xf372('0x33')]('nolimit')){_0x14e998[_0xf372('0x14')]=qs[_0xf372('0x14')](_0x59aa49[_0xf372('0x20')][_0xf372('0x14')]);_0x14e998[_0xf372('0x12')]=qs['offset'](_0x59aa49[_0xf372('0x20')][_0xf372('0x12')]);}_0x14e998[_0xf372('0x7c')]=qs[_0xf372('0x7d')](_0x59aa49[_0xf372('0x20')][_0xf372('0x7d')]);_0x14e998[_0xf372('0x58')]=qs[_0xf372('0x78')](_[_0xf372('0x7e')](_0x59aa49[_0xf372('0x20')],_0x18930c[_0xf372('0x78')]));_0x14e998[_0xf372('0x58')]['ContactId']=_0x31333a['id'];if(_0x59aa49[_0xf372('0x20')][_0xf372('0x7f')]){_0x14e998['where']=_['merge'](_0x14e998[_0xf372('0x58')],{'$or':_['map'](_0x14e998[_0xf372('0x7b')],function(_0x343a74){var _0x3c5923={};_0x3c5923[_0x343a74]={'$like':'%'+_0x59aa49['query'][_0xf372('0x7f')]+'%'};return _0x3c5923;})});}_0x14e998=_[_0xf372('0x34')]({},_0x14e998,_0x59aa49[_0xf372('0x80')]);return db['CmHopper'][_0xf372('0x15')]({'where':_0x14e998[_0xf372('0x58')]})['then'](function(_0x1a3c13){_0x160fc2[_0xf372('0x15')]=_0x1a3c13;if(_0x59aa49[_0xf372('0x20')][_0xf372('0x95')]){_0x14e998[_0xf372('0x96')]=[{'all':!![]}];}return db[_0xf372('0x3c')]['findAll'](_0x14e998);})[_0xf372('0x19')](function(_0x2ff584){_0x160fc2[_0xf372('0x97')]=_0x2ff584;return _0x160fc2;});}})[_0xf372('0x19')](respondWithFilteredResult(_0xbf5562,_0x14e998))['catch'](handleError(_0xbf5562,null));};exports[_0xf372('0x98')]=function(_0x1bac8d,_0xa49f78){var _0x47ac4a={'raw':!![],'where':{}};var _0x46bb97={};var _0x3b8125={'count':0x0,'rows':[]};return db[_0xf372('0x22')][_0xf372('0x75')]({'where':{'id':_0x1bac8d['params']['id']}})[_0xf372('0x19')](handleEntityNotFound(_0xa49f78,null))['then'](function(_0x262b37){if(_0x262b37){_0x46bb97[_0xf372('0x76')]=_['keys'](db['CmHopperHistory'][_0xf372('0x77')]);_0x46bb97['query']=_[_0xf372('0x31')](_0x1bac8d[_0xf372('0x20')]);_0x46bb97[_0xf372('0x78')]=_[_0xf372('0x79')](_0x46bb97['model'],_0x46bb97['query']);_0x47ac4a[_0xf372('0x7b')]=_[_0xf372('0x79')](_0x46bb97['model'],qs[_0xf372('0x7a')](_0x1bac8d[_0xf372('0x20')]['fields']));_0x47ac4a[_0xf372('0x7b')]=_0x47ac4a[_0xf372('0x7b')][_0xf372('0x26')]?_0x47ac4a[_0xf372('0x7b')]:_0x46bb97[_0xf372('0x76')];if(!_0x1bac8d['query'][_0xf372('0x33')]('nolimit')){_0x47ac4a[_0xf372('0x14')]=qs['limit'](_0x1bac8d[_0xf372('0x20')]['limit']);_0x47ac4a[_0xf372('0x12')]=qs[_0xf372('0x12')](_0x1bac8d['query'][_0xf372('0x12')]);}_0x47ac4a[_0xf372('0x7c')]=qs[_0xf372('0x7d')](_0x1bac8d[_0xf372('0x20')][_0xf372('0x7d')]);_0x47ac4a[_0xf372('0x58')]=qs[_0xf372('0x78')](_[_0xf372('0x7e')](_0x1bac8d[_0xf372('0x20')],_0x46bb97[_0xf372('0x78')]));_0x47ac4a[_0xf372('0x58')][_0xf372('0x99')]=_0x262b37['id'];if(_0x1bac8d[_0xf372('0x20')][_0xf372('0x7f')]){_0x47ac4a[_0xf372('0x58')]=_[_0xf372('0x34')](_0x47ac4a[_0xf372('0x58')],{'$or':_[_0xf372('0x69')](_0x47ac4a[_0xf372('0x7b')],function(_0x259cb1){var _0x32da26={};_0x32da26[_0x259cb1]={'$like':'%'+_0x1bac8d[_0xf372('0x20')]['filter']+'%'};return _0x32da26;})});}_0x47ac4a=_[_0xf372('0x34')]({},_0x47ac4a,_0x1bac8d[_0xf372('0x80')]);return db[_0xf372('0x49')]['count']({'where':_0x47ac4a[_0xf372('0x58')]})[_0xf372('0x19')](function(_0x33255b){_0x3b8125[_0xf372('0x15')]=_0x33255b;if(_0x1bac8d[_0xf372('0x20')]['includeAll']){_0x47ac4a[_0xf372('0x96')]=[{'all':!![]}];}return db[_0xf372('0x49')][_0xf372('0x1f')](_0x47ac4a);})[_0xf372('0x19')](function(_0x5c7381){_0x3b8125[_0xf372('0x97')]=_0x5c7381;return _0x3b8125;});}})[_0xf372('0x19')](respondWithFilteredResult(_0xa49f78,_0x47ac4a))[_0xf372('0x21')](handleError(_0xa49f78,null));};exports['getHopperFinals']=function(_0x4fcab5,_0x593107){var _0x303fd7={'raw':!![],'where':{}};var _0x22f85d={};var _0x378ae0={'count':0x0,'rows':[]};return db[_0xf372('0x22')][_0xf372('0x75')]({'where':{'id':_0x4fcab5[_0xf372('0x24')]['id']}})['then'](handleEntityNotFound(_0x593107,null))[_0xf372('0x19')](function(_0x9af2f6){if(_0x9af2f6){_0x22f85d[_0xf372('0x76')]=_[_0xf372('0x31')](db[_0xf372('0x48')][_0xf372('0x77')]);_0x22f85d['query']=_[_0xf372('0x31')](_0x4fcab5['query']);_0x22f85d['filters']=_[_0xf372('0x79')](_0x22f85d[_0xf372('0x76')],_0x22f85d[_0xf372('0x20')]);_0x303fd7[_0xf372('0x7b')]=_['intersection'](_0x22f85d[_0xf372('0x76')],qs[_0xf372('0x7a')](_0x4fcab5[_0xf372('0x20')][_0xf372('0x7a')]));_0x303fd7['attributes']=_0x303fd7[_0xf372('0x7b')]['length']?_0x303fd7[_0xf372('0x7b')]:_0x22f85d['model'];if(!_0x4fcab5[_0xf372('0x20')][_0xf372('0x33')](_0xf372('0x81'))){_0x303fd7['limit']=qs[_0xf372('0x14')](_0x4fcab5[_0xf372('0x20')][_0xf372('0x14')]);_0x303fd7[_0xf372('0x12')]=qs[_0xf372('0x12')](_0x4fcab5[_0xf372('0x20')]['offset']);}_0x303fd7[_0xf372('0x7c')]=qs[_0xf372('0x7d')](_0x4fcab5['query'][_0xf372('0x7d')]);_0x303fd7[_0xf372('0x58')]=qs[_0xf372('0x78')](_[_0xf372('0x7e')](_0x4fcab5[_0xf372('0x20')],_0x22f85d[_0xf372('0x78')]));_0x303fd7[_0xf372('0x58')]['ContactId']=_0x9af2f6['id'];if(_0x4fcab5['query'][_0xf372('0x7f')]){_0x303fd7[_0xf372('0x58')]=_['merge'](_0x303fd7[_0xf372('0x58')],{'$or':_[_0xf372('0x69')](_0x303fd7[_0xf372('0x7b')],function(_0x52d52a){var _0x10286f={};_0x10286f[_0x52d52a]={'$like':'%'+_0x4fcab5[_0xf372('0x20')][_0xf372('0x7f')]+'%'};return _0x10286f;})});}_0x303fd7=_[_0xf372('0x34')]({},_0x303fd7,_0x4fcab5['options']);return db['CmHopperFinal'][_0xf372('0x15')]({'where':_0x303fd7['where']})[_0xf372('0x19')](function(_0x2db3ef){_0x378ae0[_0xf372('0x15')]=_0x2db3ef;if(_0x4fcab5['query']['includeAll']){_0x303fd7[_0xf372('0x96')]=[{'all':!![]}];}return db[_0xf372('0x48')]['findAll'](_0x303fd7);})['then'](function(_0x1fa04c){_0x378ae0[_0xf372('0x97')]=_0x1fa04c;return _0x378ae0;});}})[_0xf372('0x19')](respondWithFilteredResult(_0x593107,_0x303fd7))[_0xf372('0x21')](handleError(_0x593107,null));};exports[_0xf372('0x9a')]=function(_0x1f82e1,_0x351ce4){var _0x3e1499={'raw':!![],'where':{}};var _0x38b364={};var _0xbeb737={'count':0x0,'rows':[]};return db[_0xf372('0x22')]['findOne']({'where':{'id':_0x1f82e1[_0xf372('0x24')]['id']}})[_0xf372('0x19')](handleEntityNotFound(_0x351ce4,null))[_0xf372('0x19')](function(_0x58fa87){if(_0x58fa87){_0x38b364['model']=_['keys'](db[_0xf372('0x9b')][_0xf372('0x77')]);_0x38b364[_0xf372('0x20')]=_['keys'](_0x1f82e1[_0xf372('0x20')]);_0x38b364[_0xf372('0x78')]=_[_0xf372('0x79')](_0x38b364['model'],_0x38b364[_0xf372('0x20')]);_0x3e1499['attributes']=_[_0xf372('0x79')](_0x38b364['model'],qs[_0xf372('0x7a')](_0x1f82e1[_0xf372('0x20')]['fields']));_0x3e1499[_0xf372('0x7b')]=_0x3e1499[_0xf372('0x7b')][_0xf372('0x26')]?_0x3e1499[_0xf372('0x7b')]:_0x38b364[_0xf372('0x76')];if(!_0x1f82e1[_0xf372('0x20')][_0xf372('0x33')](_0xf372('0x81'))){_0x3e1499[_0xf372('0x14')]=qs['limit'](_0x1f82e1[_0xf372('0x20')][_0xf372('0x14')]);_0x3e1499[_0xf372('0x12')]=qs['offset'](_0x1f82e1[_0xf372('0x20')][_0xf372('0x12')]);}_0x3e1499['order']=qs['sort'](_0x1f82e1[_0xf372('0x20')][_0xf372('0x7d')]);_0x3e1499['where']=qs['filters'](_[_0xf372('0x7e')](_0x1f82e1['query'],_0x38b364[_0xf372('0x78')]));_0x3e1499[_0xf372('0x58')]['ContactId']=_0x58fa87['id'];if(_0x1f82e1['query']['filter']){_0x3e1499[_0xf372('0x58')]=_[_0xf372('0x34')](_0x3e1499['where'],{'$or':_[_0xf372('0x69')](_0x3e1499[_0xf372('0x7b')],function(_0x18bfc8){var _0x188d27={};_0x188d27[_0x18bfc8]={'$like':'%'+_0x1f82e1[_0xf372('0x20')][_0xf372('0x7f')]+'%'};return _0x188d27;})});}_0x3e1499=_[_0xf372('0x34')]({},_0x3e1499,_0x1f82e1[_0xf372('0x80')]);return db[_0xf372('0x9b')]['count']({'where':_0x3e1499['where']})[_0xf372('0x19')](function(_0xc4654){_0xbeb737[_0xf372('0x15')]=_0xc4654;if(_0x1f82e1[_0xf372('0x20')][_0xf372('0x95')]){_0x3e1499[_0xf372('0x96')]=[{'all':!![]}];}return db[_0xf372('0x9b')][_0xf372('0x1f')](_0x3e1499);})['then'](function(_0x3a0dfa){_0xbeb737[_0xf372('0x97')]=_0x3a0dfa;return _0xbeb737;});}})[_0xf372('0x19')](respondWithFilteredResult(_0x351ce4,_0x3e1499))[_0xf372('0x21')](handleError(_0x351ce4,null));};exports[_0xf372('0x9c')]=function(_0x1d23be,_0x979b46){try{if(!_0x1d23be[_0xf372('0x35')][_0xf372('0x5a')]){throw new Error(_0xf372('0x9d'));}if(!_0x1d23be['body'][_0xf372('0x9e')]){throw new Error(_0xf372('0x9f'));}if(!_0x1d23be[_0xf372('0x35')][_0xf372('0xa0')]){throw new Error(_0xf372('0xa1'));}if(!_0x1d23be[_0xf372('0x35')][_0xf372('0xa2')]){throw new Error(_0xf372('0xa3'));}var _0x2c34c0=_0x1d23be[_0xf372('0x35')]['binding_keys']['split'](',');var _0x3ac180=_0x1d23be[_0xf372('0x35')][_0xf372('0xa0')][_0xf372('0xa4')](',');if(!_0x2c34c0['length']||!_0x3ac180[_0xf372('0x26')]||_0x2c34c0[_0xf372('0x26')]!==_0x3ac180[_0xf372('0x26')]){throw new Error(_0xf372('0xa5'));}_0x1d23be[_0xf372('0x35')][_0xf372('0x7a')]=_['zipObject'](_0x2c34c0,_0x3ac180);if(!_0x1d23be[_0xf372('0x35')][_0xf372('0x7a')][_0xf372('0x73')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x1d23be['body']['fields']['firstName']){throw new Error('No\x20firstName\x20column\x20specified');}var _0x47064e=path[_0xf372('0x3a')](config[_0xf372('0xa6')],'server/files/tmp',_0x1d23be['file'][_0xf372('0xa7')]);fs[_0xf372('0xa8')](_0x47064e,parseInt(_0xf372('0xa9'),0x8));var _0x405d16=require(_0xf372('0xaa'))[_0xf372('0xab')](path[_0xf372('0x3a')](__dirname,_0xf372('0xac')),[_0x47064e,_0x1d23be[_0xf372('0x35')][_0xf372('0x9e')],_0x1d23be[_0xf372('0x35')][_0xf372('0xa0')],_0x1d23be['body'][_0xf372('0x5a')],_0x1d23be[_0xf372('0x35')][_0xf372('0xad')],_0x1d23be['body'][_0xf372('0x57')],_0x1d23be[_0xf372('0x35')][_0xf372('0xa2')]]);return _0x979b46[_0xf372('0x10')](0xc8)[_0xf372('0x11')]({'message':_0xf372('0xae'),'pid':_0x405d16[_0xf372('0xaf')]});}catch(_0x128f44){return _0x979b46[_0xf372('0x10')](0x1f4)[_0xf372('0xb0')](_0x128f44);}};exports[_0xf372('0xb1')]=function(_0x532be7,_0x31e915){var _0x1445a5=fs['createReadStream'](_0x532be7[_0xf372('0xb2')][_0xf372('0x3')]);Papa[_0xf372('0xb3')](_0x1445a5,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x1b3f8b){return _0x31e915['status'](0xc8)[_0xf372('0x11')]({'file':_0x532be7[_0xf372('0xb2')],'fields':_0x1b3f8b['meta'][_0xf372('0x7a')]});}});};exports['import']=function(_0x2842e6,_0x19ae10){return db[_0xf372('0xb4')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0xf372('0xb5')}})[_0xf372('0x19')](function(_0x151b50){var _0x458027=![];if(!_0x2842e6[_0xf372('0x35')][_0xf372('0x5a')]){throw new Error(_0xf372('0x9d'));}if(!_0x2842e6[_0xf372('0x35')]['binding'][_0xf372('0x73')]){throw new Error(_0xf372('0xb6'));}if(!_0x2842e6[_0xf372('0x35')]['binding']['firstName']){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x2842e6['body'][_0xf372('0xa2')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x4e1ab4=require(_0xf372('0xaa'))[_0xf372('0xab')](path['join'](__dirname,_0xf372('0xb7')),[_0x2842e6[_0xf372('0x24')]['id'],JSON[_0xf372('0xb8')](_0x2842e6[_0xf372('0x35')]),JSON[_0xf372('0xb8')](_0x151b50)]);_0x4e1ab4['on']('message',function(){_0x458027=!![];return _0x19ae10['status'](0xc8)[_0xf372('0x11')]({'message':'start\x20child\x20process\x20correctly!','pid':_0x4e1ab4['pid']});});_0x4e1ab4['on']('exit',function(_0x46710c){if(_0x46710c&&!_0x458027){return _0x19ae10[_0xf372('0x10')](0x1f4)['json']({'message':'error\x20child\x20process','pid':_0x4e1ab4[_0xf372('0xaf')]});}});})[_0xf372('0x21')](handleError(_0x19ae10,null));};exports['importUpdates']=function(_0x20f0a5,_0x1a4c19){return db[_0xf372('0xb4')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0xf372('0xb5')}})[_0xf372('0x19')](function(_0x209ccc){var _0x2d6715=![];if(!_0x20f0a5[_0xf372('0x35')][_0xf372('0x5a')]){throw new Error(_0xf372('0x9d'));}if(!_0x20f0a5[_0xf372('0x35')][_0xf372('0xb9')][_0xf372('0x73')]){throw new Error(_0xf372('0xb6'));}if(!_0x20f0a5[_0xf372('0x35')][_0xf372('0xb9')][_0xf372('0xba')]){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x20f0a5['body']['socket_timestamp']){throw new Error(_0xf372('0xa3'));}var _0x4657c4=require(_0xf372('0xaa'))[_0xf372('0xab')](path['join'](__dirname,'../../components/import/cm/csvUpdates'),[_0x20f0a5[_0xf372('0x24')]['id'],JSON[_0xf372('0xb8')](_0x20f0a5[_0xf372('0x35')]),JSON[_0xf372('0xb8')](_0x209ccc)]);_0x4657c4['on'](_0xf372('0xbb'),function(){_0x2d6715=!![];return _0x1a4c19[_0xf372('0x10')](0xc8)[_0xf372('0x11')]({'message':_0xf372('0xbc'),'pid':_0x4657c4['pid']});});_0x4657c4['on'](_0xf372('0xbd'),function(_0x48d056){if(_0x48d056&&!_0x2d6715){return _0x1a4c19[_0xf372('0x10')](0x1f4)[_0xf372('0x11')]({'message':_0xf372('0xbe'),'pid':_0x4657c4[_0xf372('0xaf')]});}});})['catch'](handleError(_0x1a4c19,null));};exports[_0xf372('0xbf')]=function(_0x496f4b,_0x39cb79){var _0x257a9f=[_0xf372('0xc0'),_0xf372('0xc1'),_0xf372('0xc2'),_0xf372('0xc3'),'fax','whatsapp',_0xf372('0xc4')];var _0x100e22={'offset':0x0,'order':qs['sort'](_0xf372('0xc5'))},_0x2e63ce={'count':0x0,'rows':[]};Promise[_0xf372('0xc6')]()['then'](function(){if(_0x496f4b[_0xf372('0x20')]['channel']){if(!_[_0xf372('0xc7')](_0x257a9f,_0x496f4b[_0xf372('0x20')]['channel'][_0xf372('0xc8')]())){throw new Error(_0xf372('0xc9'));}_0x257a9f=[_0x496f4b[_0xf372('0x20')][_0xf372('0xca')][_0xf372('0xc8')]()];}if(_0x496f4b[_0xf372('0x20')][_0xf372('0xcb')]){try{var _0xa012d8=JSON[_0xf372('0xb3')](_0x496f4b[_0xf372('0x20')][_0xf372('0xcb')]);if(!moment(_0xa012d8[_0xf372('0x36')])[_0xf372('0xcc')]()){throw new Error(_0xf372('0xcd'));}if(!moment(_0xa012d8['to'])['isValid']()){throw new Error('Invalid\x20date\x20for\x20range\x20to\x20filter');}}catch(_0x3d8af9){throw new Error(_0xf372('0xce'));}}if(!_0x496f4b[_0xf372('0x20')][_0xf372('0x33')](_0xf372('0x81'))){_0x100e22[_0xf372('0x14')]=qs[_0xf372('0x14')](_0x496f4b[_0xf372('0x20')]['limit']||0xa);_0x100e22[_0xf372('0x12')]=qs[_0xf372('0x12')](_0x496f4b['query'][_0xf372('0x12')]);}var _0xa2ee96=_0x257a9f['map'](function(_0x2fb0d1){if(_0x2fb0d1===_0xf372('0xc4')){var _0x3e6936={'attributes':['id',_0xf372('0xcf'),_0xf372('0x2e'),_0xf372('0xd0'),_0xf372('0xd1'),_0xf372('0xd2'),_0xf372('0xd3'),'endtime','duration',_0xf372('0xd4'),_0xf372('0xd5'),'userDisposition',_0xf372('0xd6'),'userThirdDisposition',_0xf372('0xd7')],'where':{'ContactId':_0x496f4b[_0xf372('0x24')]['id']},'include':[{'model':db[_0xf372('0xb4')],'as':_0xf372('0xb4'),'attributes':['id',_0xf372('0x1c'),'fullname','alias']}],'order':[[_0xf372('0xd5'),_0xf372('0xd8')]]};if(_0x496f4b[_0xf372('0x20')][_0xf372('0xcb')]){_0x3e6936[_0xf372('0x58')]['createdAt']={'$gte':_0xa012d8[_0xf372('0x36')],'$lte':_0xa012d8['to']};}return db[_0xf372('0x4b')][_0xf372('0xd9')](_0x3e6936)[_0xf372('0x19')](function(_0x5302e2){_0x2e63ce[_0xf372('0x15')]+=_0x5302e2[_0xf372('0x15')];return _[_0xf372('0x69')](_0x5302e2[_0xf372('0x97')],function(_0x2b7c63){var _0x4167a4=_0x2b7c63[_0xf372('0x37')]({'plain':!![]});_0x4167a4[_0xf372('0xca')]=_0x2fb0d1;if(_0x4167a4['User']){_0x4167a4[_0xf372('0xb4')]={'id':_0x4167a4[_0xf372('0xb4')]['id'],'name':_0x4167a4['User'][_0xf372('0x1c')],'fullname':_0x4167a4['User'][_0xf372('0xda')],'alias':_0x4167a4['User'][_0xf372('0x2d')]};}return _0x4167a4;});});}else{var _0xeb996d=_[_0xf372('0xdb')](_0x2fb0d1)+(_0x2fb0d1===_0xf372('0xc1')?_0xf372('0xdc'):_0xf372('0xdd'));var _0x536fb0={'attributes':['id',_0xf372('0xde'),_0xf372('0xdf'),_0xf372('0xd5'),_0xf372('0xd4'),'disposition',_0xf372('0xe0'),_0xf372('0xe1'),_0xf372('0xd7'),_0xeb996d+'Id'],'where':{'ContactId':_0x496f4b[_0xf372('0x24')]['id']},'include':[{'model':db[_0xeb996d],'as':_0xf372('0xdd'),'attributes':['id',_0xf372('0x1c'),_0xf372('0xe2')]},{'model':db['User'],'as':_0xf372('0xe3'),'attributes':['id',_0xf372('0x1c'),'fullname']},{'model':db[_0xf372('0x5f')],'as':_0xf372('0x60'),'attributes':['id',_0xf372('0x1c'),_0xf372('0x61')],'through':{'attributes':[]}}],'order':[['createdAt',_0xf372('0xd8')]]};if(_0x496f4b[_0xf372('0x20')]['range']){_0x536fb0['where']['createdAt']={'$gte':_0xa012d8[_0xf372('0x36')],'$lte':_0xa012d8['to']};}switch(_0x2fb0d1){case'chat':_0x536fb0['attributes'][_0xf372('0x59')](_0xf372('0xe4'),_0xf372('0xe5'),_0xf372('0xe6'),_0xf372('0xe7'),'osName','ratingMessage','ratingType','ratingValue',_0xf372('0xe8'));break;case'mail':_0x536fb0[_0xf372('0x7b')][_0xf372('0x59')](_0xf372('0xe9'),_0xf372('0xea'));break;case _0xf372('0xc3'):_0x536fb0[_0xf372('0x7b')][_0xf372('0x59')]('externalUrl',_0xf372('0xeb'));break;}return db[_['startCase'](_0x2fb0d1)+_0xf372('0xec')][_0xf372('0xd9')](_0x536fb0)[_0xf372('0x19')](function(_0x3251a9){_0x2e63ce[_0xf372('0x15')]+=_0x3251a9['count'];return _[_0xf372('0x69')](_0x3251a9[_0xf372('0x97')],function(_0x585572){var _0x2f89d3=_0x585572['get']({'plain':!![]});_0x2f89d3[_0xf372('0xca')]=_0x2fb0d1;if(_0x2f89d3['Owner']){_0x2f89d3[_0xf372('0xe3')]={'id':_0x2f89d3[_0xf372('0xe3')]['id'],'name':_0x2f89d3[_0xf372('0xe3')][_0xf372('0x1c')],'fullname':_0x2f89d3[_0xf372('0xe3')][_0xf372('0xda')]};}return _0x2f89d3;});});}});return Promise[_0xf372('0x85')](_0xa2ee96);})[_0xf372('0x19')](function(_0x377028){return _(_0x377028)[_0xf372('0xed')]()['sortBy']('createdAt')[_0xf372('0xee')]()[_0xf372('0xef')]();})['then'](function(_0x5be375){_0x2e63ce[_0xf372('0x97')]=_0x100e22[_0xf372('0x14')]?_0x5be375[_0xf372('0xf0')](_0x100e22[_0xf372('0x12')],_0x100e22[_0xf372('0x12')]+_0x100e22['limit']):_0x5be375;return _0x2e63ce;})[_0xf372('0x19')](respondWithFilteredResult(_0x39cb79,_0x100e22))['catch'](handleError(_0x39cb79,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff