// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x1e1b=['ItemTypeId','contact\x20phone\x20exists','CmHopperAdditionalPhone','item','PHONE','`ItemType`.OrderBy','CmHopperId','ItemType.OrderBy','getAdditionalPhones','CmContactId','toContactId','hopperId','getHoppers','include','getHopperHistories','CmHopperHistory','ContactId','includeAll','getHopperFinals','CmHopperFinal','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','No\x20firstName\x20column\x20specified','root','file','filename','0777','fork','../../components/import/cm/csv','CompanyId','File\x20uploaded\x20correctly!','upload','createReadStream','path','parse','meta','binding','child_process','stringify','message','start\x20child\x20process\x20correctly!','pid','exit','error\x20child\x20process','importUpdates','firstName','../../components/import/cm/csvUpdates','chat','sms','fax','voice','-createdAt','resolve','channel','includes','toLowerCase','Invalid\x20channel','Invalid\x20date\x20for\x20range\x20from\x20filter','isValid','Invalid\x20date\x20for\x20range\x20to\x20filter','uniqueid','source','callerid','createdAt','userSecondDisposition','userThirdDisposition','UserId','fullname','range','findAndCountAll','startCase','Website','Account','closed','closedAt','note','disposition','thirdDisposition','key','customerIp','customerPort','ratingMessage','ratingType','ratingValue','subject','substatus','threadId','Owner','flatten','reverse','slice','util','lodash','papaparse','ioredis','../../components/parsers/advancedSearch','../../config/logger','api','../../config/environment','../../config/environment/shared','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./cmContact.socket','status','offset','undefined','limit','count','set','Content-Range','json','update','then','destroy','error','stack','name','send','CmContact','keys','length','startsWith','push','CmCustomField','all','cf_','fieldType','type','model','query','filters','attributes','intersection','fields','hasOwnProperty','nolimit','order','sort','pick','select','field','from','tools_tags','left_join','uc.CmContactId\x20=\x20c.id','cm_contact_has_tags','ct.CmContactId\x20=\x20c.id','t.id\x20=\x20ct.TagId','where','expr','search','parseSearch','sqlOperator','conditions','find','Tag','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','and','uc.UserId\x20=\x20?','value','dateOfBirth','castTo','buildExpression','text','start','end','map','filter','isNil','Contact','isEmpty','forEach','c.ListId\x20IN\x20?','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','tag','isArray','replace','split','getFullTextValue','isNumeric','c.id\x20LIKE\x20?','c.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','c.id','Sequelize','QueryTypes','SELECT','clone','DESC','t.id\x20IN\x20?','user','role','agent','getLists','c.ListId\x20IS\x20NULL','sequelize','toString','keyBy','c.firstName','c.lastName','c.phone','c.mobile','c.fax','c.email','c.ListId','c.createdAt','c.deletedAt','c.CompanyId','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','Tags','rows','catch','params','describe','tags','columnName','displayName','analytics','findAll','alias','custom','values','merge','body','get','mergeWith','join','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopperBlack','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailMessage','MailInteraction','SmsInteraction','FaxInteraction','FaxMessage','CmContactHasItem','VoiceCallReport','ChatQueueReport','FaxQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappMessage','WhatsappQueueReport','dialTimezone','timezones','utcOffset','additionalPhones','bulkCreate','each','duplicates','$or','ListId','findOrCreate','spread','contact','color','Phones','ContactItemType','ItemType','literal','Phones.OrderBy','omit','format','cf_%d','$and','pickBy','table','cm_contacts','setFields','id\x20=\x20?','phone','CmHopper','findOne','rawAttributes','options','getTags','setTags','ids','setAdditionalPhones','items','item_types','description','OrderBy'];(function(_0x341f73,_0x4b15c9){var _0x1220eb=function(_0x12cfbf){while(--_0x12cfbf){_0x341f73['push'](_0x341f73['shift']());}};_0x1220eb(++_0x4b15c9);}(_0x1e1b,0x19a));var _0xb1e1=function(_0x4eec9b,_0x4aea09){_0x4eec9b=_0x4eec9b-0x0;var _0x2e3849=_0x1e1b[_0x4eec9b];return _0x2e3849;};'use strict';var moment=require('moment');var BPromise=require('bluebird');var util=require(_0xb1e1('0x0'));var path=require('path');var fs=require('fs');var _=require(_0xb1e1('0x1'));var squel=require('squel');var Papa=require(_0xb1e1('0x2'));var Redis=require(_0xb1e1('0x3'));var qs=require('../../components/parsers/qs');var as=require(_0xb1e1('0x4'));var logger=require(_0xb1e1('0x5'))(_0xb1e1('0x6'));var config=require(_0xb1e1('0x7'));var shared=require(_0xb1e1('0x8'));var db=require(_0xb1e1('0x9'))['db'];config[_0xb1e1('0xa')]=_[_0xb1e1('0xb')](config[_0xb1e1('0xa')],{'host':_0xb1e1('0xc'),'port':0x18eb});var socket=require(_0xb1e1('0xd'))(new Redis(config['redis']));require(_0xb1e1('0xe'))['register'](socket);function respondWithResult(_0x374543,_0x1a0ba3){_0x1a0ba3=_0x1a0ba3||0xc8;return function(_0x55db0f){if(_0x55db0f){return _0x374543[_0xb1e1('0xf')](_0x1a0ba3)['json'](_0x55db0f);}};}function respondWithFilteredResult(_0x1f8474,_0x32806f){return function(_0x4d06c5){if(_0x4d06c5){var _0x1fb127=typeof _0x32806f[_0xb1e1('0x10')]===_0xb1e1('0x11')&&typeof _0x32806f[_0xb1e1('0x12')]===_0xb1e1('0x11');var _0x2af4df=_0x4d06c5[_0xb1e1('0x13')];var _0x4741c8=_0x1fb127?0x0:_0x32806f[_0xb1e1('0x10')];var _0x4551ed=_0x1fb127?_0x4d06c5[_0xb1e1('0x13')]:_0x32806f[_0xb1e1('0x10')]+_0x32806f['limit'];var _0x19d71f;if(_0x4551ed>=_0x2af4df){_0x4551ed=_0x2af4df;_0x19d71f=0xc8;}else{_0x19d71f=0xce;}_0x1f8474['status'](_0x19d71f);return _0x1f8474[_0xb1e1('0x14')](_0xb1e1('0x15'),_0x4741c8+'-'+_0x4551ed+'/'+_0x2af4df)[_0xb1e1('0x16')](_0x4d06c5);}return null;};}function saveUpdates(_0x374368){return function(_0x3a56c4){if(_0x3a56c4){return _0x3a56c4[_0xb1e1('0x17')](_0x374368)[_0xb1e1('0x18')](function(_0x45f281){return _0x45f281;});}return null;};}function removeEntity(_0x2cbc87){return function(_0x287460){if(_0x287460){return _0x287460[_0xb1e1('0x19')]()[_0xb1e1('0x18')](function(){_0x2cbc87[_0xb1e1('0xf')](0xcc)['end']();});}};}function handleEntityNotFound(_0xd7694a){return function(_0x5c6324){if(!_0x5c6324){_0xd7694a['sendStatus'](0x194);}return _0x5c6324;};}function handleError(_0x17c2a4,_0x20eed4){_0x20eed4=_0x20eed4||0x1f4;return function(_0x1f21d4){logger[_0xb1e1('0x1a')](_0x1f21d4[_0xb1e1('0x1b')]);if(_0x1f21d4[_0xb1e1('0x1c')]){delete _0x1f21d4['name'];}_0x17c2a4['status'](_0x20eed4)[_0xb1e1('0x1d')](_0x1f21d4);};}exports['index']=function(_0x2c407c,_0x249cd0){var _0x11f5de={},_0x5a99c0={},_0xfb510f={'count':0x0,'rows':[]};return db[_0xb1e1('0x1e')]['describe']()['then'](function(_0x485e73){var _0x55d1f4=[];for(var _0x40efb0=0x0;_0x40efb0<Object[_0xb1e1('0x1f')](_0x485e73)[_0xb1e1('0x20')];_0x40efb0++){var _0x562125=Object['keys'](_0x485e73)[_0x40efb0];if(_[_0xb1e1('0x21')](_0x562125,'cf_')){_0x55d1f4[_0xb1e1('0x22')](db[_0xb1e1('0x23')]['findOne']({'where':{'id':_['trimStart'](_0x562125,'cf_')},'raw':!![]}));}}return BPromise[_0xb1e1('0x24')](_0x55d1f4)['then'](function(_0x158512){for(var _0x4f7d44=0x0;_0x4f7d44<_0x158512[_0xb1e1('0x20')];_0x4f7d44++){if(_0x158512[_0x4f7d44]){var _0x158ed6=_0xb1e1('0x25')+_0x158512[_0x4f7d44]['id'];var _0x3fa437=_0x485e73[_0x158ed6];_0x3fa437[_0xb1e1('0x26')]=_0x158512[_0x4f7d44][_0xb1e1('0x27')];}}return _0x485e73;});})[_0xb1e1('0x18')](function(_0x432f37){_0x5a99c0[_0xb1e1('0x28')]=_['keys'](_0x432f37);_0x5a99c0[_0xb1e1('0x29')]=_['keys'](_0x2c407c['query']);_0x5a99c0[_0xb1e1('0x2a')]=_['intersection'](_0x5a99c0[_0xb1e1('0x28')],_0x5a99c0[_0xb1e1('0x29')]);_0x11f5de[_0xb1e1('0x2b')]=_[_0xb1e1('0x2c')](_0x5a99c0['model'],qs[_0xb1e1('0x2d')](_0x2c407c[_0xb1e1('0x29')][_0xb1e1('0x2d')]));_0x11f5de[_0xb1e1('0x2b')]=_0x11f5de['attributes']['length']?_0x11f5de[_0xb1e1('0x2b')]:_0x5a99c0[_0xb1e1('0x28')];if(!_0x2c407c['query'][_0xb1e1('0x2e')](_0xb1e1('0x2f'))){_0x11f5de['limit']=qs[_0xb1e1('0x12')](_0x2c407c[_0xb1e1('0x29')][_0xb1e1('0x12')]);_0x11f5de[_0xb1e1('0x10')]=qs[_0xb1e1('0x10')](_0x2c407c[_0xb1e1('0x29')]['offset']);}_0x11f5de[_0xb1e1('0x30')]=qs[_0xb1e1('0x31')](_0x2c407c[_0xb1e1('0x29')]['sort']);_0x11f5de['where']=qs[_0xb1e1('0x2a')](_[_0xb1e1('0x32')](_0x2c407c['query'],_0x5a99c0[_0xb1e1('0x2a')]),_0x432f37);var _0x514b30=[];var _0x23341a=squel[_0xb1e1('0x33')]()[_0xb1e1('0x34')]('id')[_0xb1e1('0x34')](_0xb1e1('0x1c'))[_0xb1e1('0x34')]('color')[_0xb1e1('0x35')](_0xb1e1('0x36'));var _0x3a127b=squel[_0xb1e1('0x33')]()['from']('cm_contacts','c')[_0xb1e1('0x37')]('cm_user_has_contacts','uc',_0xb1e1('0x38'))[_0xb1e1('0x37')](_0xb1e1('0x39'),'ct',_0xb1e1('0x3a'))[_0xb1e1('0x37')](_0xb1e1('0x36'),'t',_0xb1e1('0x3b'))[_0xb1e1('0x3c')]('c.deletedAt\x20IS\x20NULL');var _0x39c54c=squel[_0xb1e1('0x3d')]();var _0x885558=[];var _0x36d5c2=squel['expr']();var _0x1d6f34;if(_0x2c407c[_0xb1e1('0x29')][_0xb1e1('0x3e')]){_0x1d6f34=as[_0xb1e1('0x3f')](_0x2c407c[_0xb1e1('0x29')]['search']);var _0x2df589=_0x1d6f34[_0xb1e1('0x40')];for(var _0x412324=0x0;_0x412324<_0x1d6f34['conditions'][_0xb1e1('0x20')];_0x412324++){var _0x155352=_0x1d6f34[_0xb1e1('0x41')][_0x412324];var _0x5d6915='c';var _0x29c59c=_(_0x432f37)['keys']()[_0xb1e1('0x42')](function(_0x16c05d){return _0x16c05d===_0x155352[_0xb1e1('0x34')];});if(_0x29c59c)_0x29c59c=_0x432f37[_0x155352['field']];if(!_0x29c59c){if(_0x155352[_0xb1e1('0x34')]===_0xb1e1('0x43')){var _0x23cf6e=_0x155352['value']['split'](',')['map'](function(_0x50d93e){return Number(_0x50d93e);});_0x23cf6e['forEach'](function(_0x534d75){_0x36d5c2['or'](_0xb1e1('0x44'),'%,'+_0x534d75+',%');});_0x885558=_[_0xb1e1('0x45')](_0x885558,_0x23cf6e);}else if(_0x155352[_0xb1e1('0x34')]===_0xb1e1('0x46')){_0x39c54c[_0xb1e1('0x47')](_0xb1e1('0x48'),_0x155352[_0xb1e1('0x49')]);}}else{if(_0x155352['field']===_0xb1e1('0x4a')||_0x29c59c['fieldType']==='datetime')_0x155352[_0xb1e1('0x4b')]='DATE';var _0x485cb8=as[_0xb1e1('0x4c')](_0x5d6915,_0x29c59c[_0xb1e1('0x27')],_0x155352);_0x39c54c[_0x2df589](_0x485cb8[_0xb1e1('0x4d')],_0x485cb8[_0xb1e1('0x49')][_0xb1e1('0x4e')],_0x485cb8[_0xb1e1('0x49')][_0xb1e1('0x4f')]);}}}else{var _0x45a230=_(Object['keys'](_0x2c407c[_0xb1e1('0x29')]))[_0xb1e1('0x50')](function(_0x543846){return _0x432f37[_0xb1e1('0x2e')](_0x543846)?_0x543846:undefined;})[_0xb1e1('0x51')](function(_0xd67824){return!_[_0xb1e1('0x52')](_0xd67824);})[_0xb1e1('0x49')]();if(_0x2c407c['query'][_0xb1e1('0x53')])_0x45a230[_0xb1e1('0x22')](_0xb1e1('0x53'));if(!_[_0xb1e1('0x54')](_0x45a230)){_0x45a230[_0xb1e1('0x55')](function(_0xe5a063){if(_0xe5a063==='ListId'){_0x3a127b[_0xb1e1('0x3c')](_0xb1e1('0x56'),[][_0xb1e1('0x57')](_0x2c407c[_0xb1e1('0x29')][_0xe5a063]));}else if(_0xe5a063===_0xb1e1('0x53')){var _0x489940='%'+_0x2c407c[_0xb1e1('0x29')][_0xe5a063]+'%';_0x3a127b['where'](_0xb1e1('0x58'),_0x489940);}else{_0x3a127b['where']('c.'+_0xe5a063+_0xb1e1('0x59'),_0x2c407c[_0xb1e1('0x29')][_0xe5a063]);}});}if(_0x2c407c[_0xb1e1('0x29')][_0xb1e1('0x5a')]){_0x885558=_[_0xb1e1('0x5b')](_0x2c407c['query']['tag'])?_0x2c407c[_0xb1e1('0x29')][_0xb1e1('0x5a')]:new Array(_0x2c407c[_0xb1e1('0x29')]['tag']);_0x885558[_0xb1e1('0x55')](function(_0x476504){_0x36d5c2['or'](_0xb1e1('0x44'),'%,'+_0x476504+',%');});}if(_0x2c407c[_0xb1e1('0x29')][_0xb1e1('0x51')]){var _0x3a5788=_0x2c407c[_0xb1e1('0x29')][_0xb1e1('0x51')][_0xb1e1('0x5c')]('\x5c','\x5c\x5c')[_0xb1e1('0x5c')](/'/g,'\x27\x27');if(_0x3a5788[_0xb1e1('0x5d')]('\x20')[_0xb1e1('0x20')]>0x1){_0x39c54c['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xb1e1('0x5e')](_0x3a5788),null);}else{if(qs[_0xb1e1('0x5f')](_0x3a5788)){_0x39c54c['or'](_0xb1e1('0x60'),_0x3a5788+'%');_0x39c54c['or']('c.phone\x20LIKE\x20?',_0x3a5788+'%');_0x39c54c['or'](_0xb1e1('0x61'),_0x3a5788+'%');_0x39c54c['or'](_0xb1e1('0x62'),_0x3a5788+'%');}else if(qs[_0xb1e1('0x63')](_0x3a5788)){_0x39c54c['or'](_0xb1e1('0x64'),_0x3a5788+'%');}else{_0x39c54c['or'](_0xb1e1('0x65'),'%'+_0x3a5788+'%');_0x39c54c['or'](_0xb1e1('0x66'),'%'+_0x3a5788+'%');_0x39c54c['or']('c.email\x20LIKE\x20?','%'+_0x3a5788+'%');}}}}_0x3a127b[_0xb1e1('0x3c')](_0x39c54c);_0x3a127b['group'](_0xb1e1('0x67'));var _0x529a40={'type':db[_0xb1e1('0x68')][_0xb1e1('0x69')][_0xb1e1('0x6a')],'raw':!![]};var _0x410e52=_0x3a127b[_0xb1e1('0x6b')]()[_0xb1e1('0x34')](_0xb1e1('0x67'));if(_0x11f5de[_0xb1e1('0x30')]){_0x11f5de[_0xb1e1('0x30')][_0xb1e1('0x55')](function(_0x929fd7){_0x3a127b[_0xb1e1('0x30')]('c.'+_0x929fd7[0x0],_0x929fd7[0x1]===_0xb1e1('0x6c')?![]:!![]);});}if(!_[_0xb1e1('0x54')](_0x885558)){_0x3a127b['having'](_0x36d5c2);_0x410e52[_0xb1e1('0x3c')](_0xb1e1('0x6d'),_0x885558);}BPromise['resolve']()[_0xb1e1('0x18')](function(){if(!_0x1d6f34)return;if(_0x2c407c[_0xb1e1('0x6e')][_0xb1e1('0x6f')]!==_0xb1e1('0x70'))return;if(!_['some'](_0x1d6f34[_0xb1e1('0x41')],[_0xb1e1('0x34'),_0xb1e1('0x46')])){return _0x2c407c[_0xb1e1('0x6e')][_0xb1e1('0x71')]({'attributes':['id'],'raw':!![]})[_0xb1e1('0x18')](function(_0x4a6d94){if(_['isEmpty'](_0x4a6d94)){_0x410e52[_0xb1e1('0x3c')](_0xb1e1('0x72'));_0x3a127b['where'](_0xb1e1('0x72'));}else{_0x410e52[_0xb1e1('0x3c')](_0xb1e1('0x56'),_['map'](_0x4a6d94,'id'));_0x3a127b[_0xb1e1('0x3c')]('c.ListId\x20IN\x20?',_['map'](_0x4a6d94,'id'));}});}})[_0xb1e1('0x18')](function(){if(_0x2c407c[_0xb1e1('0x6e')][_0xb1e1('0x6f')]===_0xb1e1('0x70')&&!_0x1d6f34&&!_0x2c407c['query']['ListId'])return[];return db[_0xb1e1('0x73')]['query'](_0x410e52[_0xb1e1('0x74')](),_0x529a40);})[_0xb1e1('0x18')](function(_0x5c406e){_0xfb510f[_0xb1e1('0x13')]=_0x5c406e['length'];if(_0xfb510f['count']===0x0)return[];return db[_0xb1e1('0x73')][_0xb1e1('0x29')](_0x23341a[_0xb1e1('0x74')](),_0x529a40)['then'](function(_0x515ebf){_0x514b30=_[_0xb1e1('0x75')](_0x515ebf,'id');_0x529a40=_['merge'](_0x529a40,{'model':db['CmContact'],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x2c407c[_0xb1e1('0x29')][_0xb1e1('0x2d')]){_0x11f5de[_0xb1e1('0x2b')][_0xb1e1('0x55')](function(_0x116b28){_0x3a127b[_0xb1e1('0x34')]('c.'+_0x116b28);});}else{_0x3a127b['field'](_0xb1e1('0x67'));_0x3a127b[_0xb1e1('0x34')](_0xb1e1('0x76'));_0x3a127b['field'](_0xb1e1('0x77'));_0x3a127b[_0xb1e1('0x34')](_0xb1e1('0x78'));_0x3a127b[_0xb1e1('0x34')](_0xb1e1('0x79'));_0x3a127b['field'](_0xb1e1('0x7a'));_0x3a127b[_0xb1e1('0x34')](_0xb1e1('0x7b'));_0x3a127b['field'](_0xb1e1('0x7c'));_0x3a127b[_0xb1e1('0x34')](_0xb1e1('0x7d'));_0x3a127b[_0xb1e1('0x34')](_0xb1e1('0x7e'));_0x3a127b[_0xb1e1('0x34')](_0xb1e1('0x7f'));_0x3a127b['field'](_0xb1e1('0x80'),_0xb1e1('0x81'));}if(_0x11f5de['limit'])_0x3a127b[_0xb1e1('0x12')](_0x11f5de[_0xb1e1('0x12')]);if(_0x11f5de[_0xb1e1('0x10')])_0x3a127b[_0xb1e1('0x10')](_0x11f5de[_0xb1e1('0x10')]);return db[_0xb1e1('0x73')]['query'](_0x3a127b[_0xb1e1('0x74')](),_0x529a40);});})['then'](function(_0x585edc){_0x585edc[_0xb1e1('0x55')](function(_0x40686d){if(_0x40686d[_0xb1e1('0x81')]){_0x40686d[_0xb1e1('0x82')]=[];_0x40686d[_0xb1e1('0x81')][_0xb1e1('0x5d')](',')[_0xb1e1('0x55')](function(_0x101e67){_0x40686d[_0xb1e1('0x82')][_0xb1e1('0x22')](_0x514b30[_0x101e67]);});}delete _0x40686d[_0xb1e1('0x81')];});_0xfb510f[_0xb1e1('0x83')]=_0x585edc;return _0xfb510f;})[_0xb1e1('0x18')](respondWithFilteredResult(_0x249cd0,_0x11f5de));})[_0xb1e1('0x84')](handleError(_0x249cd0,null));};exports['destroy']=function(_0x1098ae,_0x251bf0){return db[_0xb1e1('0x1e')][_0xb1e1('0x42')]({'where':{'id':_0x1098ae[_0xb1e1('0x85')]['id']}})[_0xb1e1('0x18')](handleEntityNotFound(_0x251bf0,null))[_0xb1e1('0x18')](removeEntity(_0x251bf0,null))[_0xb1e1('0x84')](handleError(_0x251bf0,null));};exports[_0xb1e1('0x86')]=function(_0x12f267,_0x5d3a69){return db['CmContact'][_0xb1e1('0x86')]()[_0xb1e1('0x18')](function(_0xa3c9ed){delete _0xa3c9ed[_0xb1e1('0x87')];for(var _0x105afe=0x0;_0x105afe<Object[_0xb1e1('0x1f')](_0xa3c9ed)[_0xb1e1('0x20')];_0x105afe++){var _0xf0a33=Object[_0xb1e1('0x1f')](_0xa3c9ed)[_0x105afe];if(!_['startsWith'](_0xf0a33,_0xb1e1('0x25'))){_0xa3c9ed[_0xf0a33][_0xb1e1('0x88')]=_0xf0a33;_0xa3c9ed[_0xf0a33][_0xb1e1('0x89')]=_0xf0a33;}}return _0xa3c9ed;})['then'](function(_0x4c5412){var _0x292fda={'where':Boolean(_0x12f267[_0xb1e1('0x29')][_0xb1e1('0x8a')])===!![]?undefined:{'$or':[{'ListId':_0x12f267['query']['id']},{'ListId':null}]},'raw':!![]};return db[_0xb1e1('0x23')][_0xb1e1('0x8b')](_0x292fda)[_0xb1e1('0x18')](function(_0x3fd7c8){for(var _0x4cd647=0x0;_0x4cd647<_0x3fd7c8['length'];_0x4cd647++){var _0x1462b9=_0xb1e1('0x25')+_0x3fd7c8[_0x4cd647]['id'];_0x4c5412[_0x1462b9][_0xb1e1('0x88')]=_0x1462b9;_0x4c5412[_0x1462b9][_0xb1e1('0x89')]=_0x3fd7c8[_0x4cd647][_0xb1e1('0x8c')];_0x4c5412[_0x1462b9][_0xb1e1('0x8d')]={'type':_0x3fd7c8[_0x4cd647][_0xb1e1('0x27')],'values':_0x3fd7c8[_0x4cd647][_0xb1e1('0x8e')]};}Object[_0xb1e1('0x1f')](_0x4c5412)['forEach'](function(_0x3ad90f){if(!_0x4c5412[_0x3ad90f]['hasOwnProperty'](_0xb1e1('0x88'))){delete _0x4c5412[_0x3ad90f];}});return _0x4c5412;});})[_0xb1e1('0x18')](respondWithResult(_0x5d3a69,null))[_0xb1e1('0x84')](handleError(_0x5d3a69,null));};exports[_0xb1e1('0x8f')]=function(_0x1b7794,_0x515ba8){var _0x229b62;var _0x13d004;var _0x232806;if(_0x1b7794[_0xb1e1('0x90')]['id']){delete _0x1b7794[_0xb1e1('0x90')]['id'];}return db[_0xb1e1('0x1e')][_0xb1e1('0x8b')]({'where':{'id':[_0x1b7794[_0xb1e1('0x90')]['to'],_0x1b7794['body'][_0xb1e1('0x35')]]}})[_0xb1e1('0x18')](function(_0x22c64a){if(_0x22c64a){if(_0x22c64a[_0xb1e1('0x20')]!==0x2){return null;}_0x22c64a[0x0]=_0x22c64a[0x0][_0xb1e1('0x91')]({'plain':!![]});_0x22c64a[0x1]=_0x22c64a[0x1][_0xb1e1('0x91')]({'plain':!![]});delete _0x22c64a[0x0]['id'];delete _0x22c64a[0x1]['id'];return _[_0xb1e1('0x92')](_0x22c64a[0x0],_0x22c64a[0x1],function(_0x286a6c,_0x4f7ce2){if(Array[_0xb1e1('0x5b')](_0x4f7ce2)&&!_0x4f7ce2[_0xb1e1('0x20')]){return _0x286a6c;}else if(!_0x4f7ce2){return _0x286a6c;}});}})[_0xb1e1('0x18')](handleEntityNotFound(_0x515ba8,null))[_0xb1e1('0x18')](function(_0x17b1d1){if(_0x17b1d1){if(_0x17b1d1[_0xb1e1('0x87')]&&_[_0xb1e1('0x5b')](_0x17b1d1[_0xb1e1('0x87')])){_0x17b1d1[_0xb1e1('0x87')]=_0x17b1d1['tags'][_0xb1e1('0x93')]();}logger[_0xb1e1('0x94')](_0xb1e1('0x95'),_0x1b7794[_0xb1e1('0x90')]['to'],_0x1b7794[_0xb1e1('0x90')][_0xb1e1('0x35')]);return db['CmHopper'][_0xb1e1('0x19')]({'where':{'ContactId':[_0x1b7794[_0xb1e1('0x90')]['to'],_0x1b7794['body'][_0xb1e1('0x35')]]}})[_0xb1e1('0x18')](function(_0x3088c9){logger[_0xb1e1('0x94')]('[CmContact][merge][destroy][CmHopper],\x20%s',_0x3088c9);return db[_0xb1e1('0x96')][_0xb1e1('0x19')]({'where':{'ContactId':[_0x1b7794['body']['to'],_0x1b7794[_0xb1e1('0x90')][_0xb1e1('0x35')]]}})[_0xb1e1('0x18')](function(_0x347092){logger['info']('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x347092);return db['CmContact'][_0xb1e1('0x97')](_0x17b1d1);});});}})[_0xb1e1('0x18')](function(_0x1ab104){if(_0x1ab104){_0x229b62=_0x1ab104;_0x13d004={'ContactId':_0x229b62['id']};_0x232806={'where':{'ContactId':[_0x1b7794[_0xb1e1('0x90')]['to'],_0x1b7794[_0xb1e1('0x90')][_0xb1e1('0x35')]]}};return db[_0xb1e1('0x98')]['update'](_0x13d004,_0x232806);}})[_0xb1e1('0x18')](function(){if(_0x229b62){return db[_0xb1e1('0x99')][_0xb1e1('0x17')](_0x13d004,_0x232806);}})['then'](function(){if(_0x229b62){return db[_0xb1e1('0x9a')][_0xb1e1('0x17')](_0x13d004,_0x232806);}})['then'](function(){if(_0x229b62){return db['MailInteraction'][_0xb1e1('0x17')](_0x13d004,_0x232806);}})['then'](function(){if(_0x229b62){return db[_0xb1e1('0x9b')][_0xb1e1('0x17')](_0x13d004,_0x232806);}})[_0xb1e1('0x18')](function(){if(_0x229b62){return db[_0xb1e1('0x9c')]['update'](_0x13d004,_0x232806);}})[_0xb1e1('0x18')](function(){if(_0x229b62){return db[_0xb1e1('0x9b')][_0xb1e1('0x17')](_0x13d004,_0x232806);}})[_0xb1e1('0x18')](function(){if(_0x229b62){return db[_0xb1e1('0x9d')][_0xb1e1('0x17')](_0x13d004,_0x232806);}})['then'](function(){if(_0x229b62){return db['SmsMessage'][_0xb1e1('0x17')](_0x13d004,_0x232806);}})[_0xb1e1('0x18')](function(){if(_0x229b62){return db[_0xb1e1('0x9e')]['update'](_0x13d004,_0x232806);}})[_0xb1e1('0x18')](function(){if(_0x229b62){return db[_0xb1e1('0x9f')][_0xb1e1('0x17')](_0x13d004,_0x232806);}})[_0xb1e1('0x18')](function(){if(_0x229b62){return db['OpenchannelInteraction'][_0xb1e1('0x17')](_0x13d004,_0x232806);}})['then'](function(){if(_0x229b62){return db['OpenchannelMessage']['update'](_0x13d004,_0x232806);}})['then'](function(){if(_0x229b62){return db[_0xb1e1('0xa0')][_0xb1e1('0x17')]({'CmContactId':_0x229b62['id']},{'where':{'CmContactId':[_0x1b7794[_0xb1e1('0x90')]['to'],_0x1b7794[_0xb1e1('0x90')]['from']]}});}})['then'](function(){if(_0x229b62){return db['CmHopperFinal'][_0xb1e1('0x17')](_0x13d004,_0x232806);}})[_0xb1e1('0x18')](function(){if(_0x229b62){return db['CmHopperHistory'][_0xb1e1('0x17')](_0x13d004,_0x232806);}})[_0xb1e1('0x18')](function(){if(_0x229b62){return db['ReportAgentPreview'][_0xb1e1('0x17')](_0x13d004,_0x232806);}})[_0xb1e1('0x18')](function(){if(_0x229b62){return db[_0xb1e1('0xa1')][_0xb1e1('0x17')](_0x13d004,_0x232806);}})[_0xb1e1('0x18')](function(){if(_0x229b62){return db[_0xb1e1('0xa2')][_0xb1e1('0x17')](_0x13d004,_0x232806);}})[_0xb1e1('0x18')](function(){if(_0x229b62){return db[_0xb1e1('0xa3')]['update'](_0x13d004,_0x232806);}})[_0xb1e1('0x18')](function(){if(_0x229b62){return db['MailQueueReport']['update'](_0x13d004,_0x232806);}})['then'](function(){if(_0x229b62){return db[_0xb1e1('0xa4')][_0xb1e1('0x17')](_0x13d004,_0x232806);}})[_0xb1e1('0x18')](function(){if(_0x229b62){return db[_0xb1e1('0xa5')]['update'](_0x13d004,_0x232806);}})['then'](function(){if(_0x229b62){return db[_0xb1e1('0xa6')][_0xb1e1('0x17')](_0x13d004,_0x232806);}})[_0xb1e1('0x18')](function(){if(_0x229b62){return db[_0xb1e1('0xa7')][_0xb1e1('0x17')](_0x13d004,_0x232806);}})[_0xb1e1('0x18')](function(){if(_0x229b62){return db[_0xb1e1('0xa8')][_0xb1e1('0x17')](_0x13d004,_0x232806);}})['then'](function(){if(_0x229b62){return db[_0xb1e1('0xa9')][_0xb1e1('0x17')](_0x13d004,_0x232806);}})[_0xb1e1('0x18')](function(){if(_0x229b62){return db[_0xb1e1('0x1e')]['destroy']({'where':{'id':[_0x1b7794['body']['to'],_0x1b7794[_0xb1e1('0x90')][_0xb1e1('0x35')]]}});}})[_0xb1e1('0x18')](function(){if(_0x229b62){return _0x229b62;}})[_0xb1e1('0x18')](respondWithResult(_0x515ba8,null))[_0xb1e1('0x84')](handleError(_0x515ba8,null));};exports['create']=function(_0x5421d8,_0x433c33){return db['CmContact'][_0xb1e1('0x86')]()['then'](function(_0x400373){if(_0x5421d8[_0xb1e1('0x90')]['tags']&&_[_0xb1e1('0x5b')](_0x5421d8['body'][_0xb1e1('0x87')])){if(_0x5421d8[_0xb1e1('0x90')][_0xb1e1('0x87')]['length']){_0x5421d8[_0xb1e1('0x90')][_0xb1e1('0x87')]=_0x5421d8[_0xb1e1('0x90')][_0xb1e1('0x87')][_0xb1e1('0x93')](';')+';';}else{_0x5421d8['body'][_0xb1e1('0x87')]=null;}}else{_0x5421d8[_0xb1e1('0x90')][_0xb1e1('0x87')]=null;}if(!_[_0xb1e1('0x52')](_0x5421d8[_0xb1e1('0x90')][_0xb1e1('0xaa')])){var _0x51a6f0=_0x5421d8[_0xb1e1('0x90')]['dialTimezone'];if(!_[_0xb1e1('0x52')](shared[_0xb1e1('0xab')][_0x51a6f0]))_0x5421d8[_0xb1e1('0x90')][_0xb1e1('0xac')]=shared[_0xb1e1('0xab')][_0x51a6f0][_0xb1e1('0xac')];}return db[_0xb1e1('0x1e')][_0xb1e1('0x97')](_0x5421d8['body'],{'fields':_['keys'](_0x400373),'raw':!![]});})[_0xb1e1('0x18')](function(_0x1cebdf){if(_0x5421d8['body'][_0xb1e1('0xad')]){return insertAdditionalPhones(_0x1cebdf,_0x5421d8['body']['additionalPhones']);}else{return _0x1cebdf;}})[_0xb1e1('0x18')](respondWithResult(_0x433c33,0xc9))[_0xb1e1('0x84')](handleError(_0x433c33,null));};exports[_0xb1e1('0xae')]=function(_0x1a0a41,_0x274794){var _0x258bd7=0x0;var _0x566a9d=0x0;var _0x592a35=0x0;var _0x150f9d=[];return db[_0xb1e1('0x1e')][_0xb1e1('0x86')]()['then'](function(_0x34f892){return BPromise[_0xb1e1('0xaf')](_0x1a0a41[_0xb1e1('0x90')],function(_0x5441c3){var _0x410f06={'where':{'$or':[]},'defaults':_0x5441c3,'fields':_['keys'](_0x34f892),'raw':!![]};if(_0x5441c3[_0xb1e1('0xb0')]){for(var _0x1aea85=0x0;_0x1aea85<_0x5441c3[_0xb1e1('0xb0')][_0xb1e1('0x20')];_0x1aea85++){var _0x22fbae={};_0x22fbae[_0x5441c3['duplicates'][_0x1aea85]]=_0x5441c3[_0x5441c3['duplicates'][_0x1aea85]];_0x410f06[_0xb1e1('0x3c')][_0xb1e1('0xb1')][_0xb1e1('0x22')](_0x22fbae);}_0x410f06[_0xb1e1('0x3c')][_0xb1e1('0xb2')]=_0x5441c3[_0xb1e1('0xb2')];}return db[_0xb1e1('0x1e')][_0xb1e1('0xb3')](_0x410f06)[_0xb1e1('0xb4')](function(_0x4190cf,_0x1387de){if(_0x1387de){if(_0x5441c3[_0xb1e1('0x2e')](_0xb1e1('0xad'))){_0x150f9d[_0xb1e1('0x22')]({'contact':_0x4190cf,'additionalPhones':_0x5441c3[_0xb1e1('0xad')]});}_0x258bd7++;}else{_0x592a35++;}})[_0xb1e1('0x84')](function(){_0x566a9d++;});});})[_0xb1e1('0x18')](function(_0xd1d811){if(_0xd1d811){if(_0x150f9d[_0xb1e1('0x20')]>0x0){return new Promise(function(_0x1122e7,_0x1370b7){var _0x5ee778=[];for(var _0x4ce39f=0x0;_0x4ce39f<_0x150f9d[_0xb1e1('0x20')];_0x4ce39f++){_0x5ee778[_0xb1e1('0x22')](insertAdditionalPhones(_0x150f9d[_0x4ce39f][_0xb1e1('0xb5')],_0x150f9d[_0x4ce39f][_0xb1e1('0xad')]));}Promise[_0xb1e1('0x24')](_0x5ee778)[_0xb1e1('0x18')](function(){_0x1122e7(0x1);});})[_0xb1e1('0x18')](function(){return{'success':_0x258bd7,'failure':_0x566a9d,'duplicates':_0x592a35};});}else{return{'success':_0x258bd7,'failure':_0x566a9d,'duplicates':_0x592a35};}}})[_0xb1e1('0x18')](respondWithResult(_0x274794,0xc9))[_0xb1e1('0x84')](handleError(_0x274794,null));};exports['show']=function(_0x25b380,_0x414994){var _0x5d2782;return db[_0xb1e1('0x1e')][_0xb1e1('0x86')]()[_0xb1e1('0x18')](function(_0x4d184a){return db[_0xb1e1('0x1e')]['find']({'where':{'id':_0x25b380[_0xb1e1('0x85')]['id']},'include':[{'model':db[_0xb1e1('0x43')],'as':_0xb1e1('0x82'),'attributes':['id',_0xb1e1('0x1c'),_0xb1e1('0xb6')],'required':_0x25b380['query'][_0xb1e1('0x5a')]?!![]:![]},{'model':db[_0xb1e1('0xa0')],'as':_0xb1e1('0xb7'),'where':{'CmContactId':_0x25b380[_0xb1e1('0x85')]['id']},'required':![],'include':[{'model':db[_0xb1e1('0xb8')],'as':_0xb1e1('0xb9')}]}],'order':[db[_0xb1e1('0x73')][_0xb1e1('0xba')](_0xb1e1('0xbb'))],'attributes':_['keys'](_0x4d184a)});})['then'](function(_0x5929a7){if(!_[_0xb1e1('0x52')](_0x5929a7)){_0x5d2782=_0x5929a7['get']({'plain':!![]});var _0x1b8e44={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x5929a7&&_0x5929a7[_0xb1e1('0xb2')]){if(_0x5929a7[_0xb1e1('0xb2')]){_0x1b8e44[_0xb1e1('0x3c')]['$and'][_0xb1e1('0x22')]({'ListId':{'$ne':_0x5929a7[_0xb1e1('0xb2')]}});}}return db[_0xb1e1('0x23')]['findAll'](_0x1b8e44);}})[_0xb1e1('0x18')](function(_0xfdda25){if(!_[_0xb1e1('0x52')](_0xfdda25)){return _[_0xb1e1('0xbc')](_0x5d2782,_[_0xb1e1('0x50')](_0xfdda25,function(_0xf19891){return util[_0xb1e1('0xbd')](_0xb1e1('0xbe'),_0xf19891['id']);}));}})[_0xb1e1('0x18')](handleEntityNotFound(_0x414994,null))[_0xb1e1('0x18')](respondWithResult(_0x414994,null))[_0xb1e1('0x84')](handleError(_0x414994,null));};exports[_0xb1e1('0x17')]=function(_0x1940fa,_0x5edd2f){var _0xbbf720;if(_0x1940fa[_0xb1e1('0x90')]['id']){delete _0x1940fa['body']['id'];}if(!_[_0xb1e1('0x52')](_0x1940fa[_0xb1e1('0x90')][_0xb1e1('0xaa')])){var _0x3c17ba=_0x1940fa[_0xb1e1('0x90')][_0xb1e1('0xaa')];if(!_[_0xb1e1('0x52')](shared[_0xb1e1('0xab')][_0x3c17ba]))_0x1940fa['body'][_0xb1e1('0xac')]=shared['timezones'][_0x3c17ba][_0xb1e1('0xac')];}return db[_0xb1e1('0x1e')]['find']({'where':{'id':_0x1940fa[_0xb1e1('0x85')]['id']}})[_0xb1e1('0x18')](handleEntityNotFound(_0x5edd2f,null))[_0xb1e1('0x18')](saveUpdates(_0x1940fa[_0xb1e1('0x90')],null))[_0xb1e1('0x18')](function(_0x55ad1c){_0xbbf720=_0x55ad1c;var _0x3c09f2={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x55ad1c&&_0x55ad1c[_0xb1e1('0xb2')]){if(_0x55ad1c[_0xb1e1('0xb2')]){_0x3c09f2['where'][_0xb1e1('0xbf')][_0xb1e1('0x22')]({'ListId':{'$ne':_0x55ad1c[_0xb1e1('0xb2')]}});}}return db[_0xb1e1('0x23')][_0xb1e1('0x8b')](_0x3c09f2);})[_0xb1e1('0x18')](function(_0x37a2d3){if(_0x37a2d3){return _[_0xb1e1('0xbc')](_[_0xb1e1('0xc0')](_0x1940fa[_0xb1e1('0x90')],function(_0x2f9e24,_0x410f0f){return _[_0xb1e1('0x21')](_0x410f0f,'cf_');}),_[_0xb1e1('0x50')](_0x37a2d3,function(_0x19b8f9){return util['format'](_0xb1e1('0xbe'),_0x19b8f9['id']);}));}})[_0xb1e1('0x18')](function(_0x4fc7dc){if(_0x4fc7dc&&!_[_0xb1e1('0x54')](_0x4fc7dc)){var _0x5cf5d1=squel['update']()[_0xb1e1('0xc1')](_0xb1e1('0xc2'))[_0xb1e1('0xc3')](_0x4fc7dc)['where'](_0xb1e1('0xc4'),_0x1940fa[_0xb1e1('0x85')]['id'])['toParam']();return db['sequelize'][_0xb1e1('0x29')](_0x5cf5d1[_0xb1e1('0x4d')],{'replacements':_0x5cf5d1[_0xb1e1('0x8e')]});}})['then'](function(){if(_0x1940fa['body'][_0xb1e1('0xc5')]&&_0xbbf720){return db[_0xb1e1('0xc6')][_0xb1e1('0x17')]({'phone':_0x1940fa[_0xb1e1('0x90')][_0xb1e1('0xc5')],'OrderBy':0x0},{'where':{'ContactId':_0xbbf720['id']}});}})[_0xb1e1('0x18')](function(){return _0xbbf720;})[_0xb1e1('0x18')](respondWithResult(_0x5edd2f,null))['catch'](handleError(_0x5edd2f,null));};exports['getTags']=function(_0x2c3ad1,_0x35f2bc){var _0x5e1d05={};var _0x18702b={};var _0x22e84f;var _0x3edc81;return db[_0xb1e1('0x1e')][_0xb1e1('0xc7')]({'where':{'id':_0x2c3ad1[_0xb1e1('0x85')]['id']}})[_0xb1e1('0x18')](handleEntityNotFound(_0x35f2bc,null))[_0xb1e1('0x18')](function(_0x6362ca){if(_0x6362ca){_0x22e84f=_0x6362ca;_0x18702b['model']=_[_0xb1e1('0x1f')](db[_0xb1e1('0x43')][_0xb1e1('0xc8')]);_0x18702b[_0xb1e1('0x29')]=_[_0xb1e1('0x1f')](_0x2c3ad1[_0xb1e1('0x29')]);_0x18702b[_0xb1e1('0x2a')]=_[_0xb1e1('0x2c')](_0x18702b[_0xb1e1('0x28')],_0x18702b[_0xb1e1('0x29')]);_0x5e1d05[_0xb1e1('0x2b')]=_[_0xb1e1('0x2c')](_0x18702b['model'],qs['fields'](_0x2c3ad1['query'][_0xb1e1('0x2d')]));_0x5e1d05[_0xb1e1('0x2b')]=_0x5e1d05['attributes'][_0xb1e1('0x20')]?_0x5e1d05[_0xb1e1('0x2b')]:_0x18702b[_0xb1e1('0x28')];_0x5e1d05[_0xb1e1('0x30')]=qs[_0xb1e1('0x31')](_0x2c3ad1['query'][_0xb1e1('0x31')]);_0x5e1d05[_0xb1e1('0x3c')]=qs[_0xb1e1('0x2a')](_[_0xb1e1('0x32')](_0x2c3ad1[_0xb1e1('0x29')],_0x18702b[_0xb1e1('0x2a')]));if(_0x2c3ad1[_0xb1e1('0x29')]['filter']){_0x5e1d05[_0xb1e1('0x3c')]=_[_0xb1e1('0x8f')](_0x5e1d05[_0xb1e1('0x3c')],{'$or':_['map'](_0x5e1d05[_0xb1e1('0x2b')],function(_0x37dad5){var _0xc64c75={};_0xc64c75[_0x37dad5]={'$like':'%'+_0x2c3ad1[_0xb1e1('0x29')][_0xb1e1('0x51')]+'%'};return _0xc64c75;})});}_0x5e1d05=_['merge']({},_0x5e1d05,_0x2c3ad1[_0xb1e1('0xc9')]);return _0x22e84f[_0xb1e1('0xca')](_0x5e1d05);}})[_0xb1e1('0x18')](function(_0x24cc04){if(_0x24cc04){_0x3edc81=_0x24cc04[_0xb1e1('0x20')];if(!_0x2c3ad1['query'][_0xb1e1('0x2e')]('nolimit')){_0x5e1d05[_0xb1e1('0x12')]=qs[_0xb1e1('0x12')](_0x2c3ad1[_0xb1e1('0x29')][_0xb1e1('0x12')]);_0x5e1d05[_0xb1e1('0x10')]=qs[_0xb1e1('0x10')](_0x2c3ad1[_0xb1e1('0x29')][_0xb1e1('0x10')]);}return _0x22e84f[_0xb1e1('0xca')](_0x5e1d05);}})[_0xb1e1('0x18')](function(_0x42827c){if(_0x42827c){return _0x42827c?{'count':_0x3edc81,'rows':_0x42827c}:null;}})['then'](respondWithResult(_0x35f2bc,null))[_0xb1e1('0x84')](handleError(_0x35f2bc,null));};exports[_0xb1e1('0xcb')]=function(_0x5ea396,_0x13dd6e){if(_0x5ea396['body']['id']){delete _0x5ea396['body']['id'];}return db['CmContact'][_0xb1e1('0xc7')]({'where':{'id':_0x5ea396[_0xb1e1('0x85')]['id']}})[_0xb1e1('0x18')](handleEntityNotFound(_0x13dd6e,null))['then'](function(_0x422064){if(_0x422064){return _0x422064[_0xb1e1('0xcb')](_0x5ea396[_0xb1e1('0x90')][_0xb1e1('0xcc')]||[]);}return null;})[_0xb1e1('0x18')](respondWithResult(_0x13dd6e,null))[_0xb1e1('0x84')](handleError(_0x13dd6e,null));};exports[_0xb1e1('0xcd')]=function(_0x46fe36,_0x31964a){var _0x1d4cac=[];_0x1d4cac[_0xb1e1('0x22')](addAdditionalPhones(_0x46fe36[_0xb1e1('0x90')]));Promise[_0xb1e1('0x24')](_0x1d4cac)['then'](function(){_0x1d4cac=[];_0x1d4cac[_0xb1e1('0x22')](deleteCmHopperPhones(_0x46fe36[_0xb1e1('0x90')]['id']));_0x1d4cac[_0xb1e1('0x22')](addCmHopperPhones(_0x46fe36[_0xb1e1('0x90')]['id']));Promise['all'](_0x1d4cac)[_0xb1e1('0x18')](function(){return[0x1];})[_0xb1e1('0x18')](respondWithResult(_0x31964a,null));});};function addAdditionalPhones(_0x10dff2){var _0x584a36;return new Promise(function(_0x34cecf,_0x3a511b){return db['CmContactHasItem'][_0xb1e1('0x19')]({'where':{'CmContactId':_0x10dff2['id']}})[_0xb1e1('0x18')](function(){db[_0xb1e1('0xb8')]['findAll']({'raw':!![],'attributes':['id','OrderBy']})[_0xb1e1('0x18')](function(_0xc1b564){var _0x137ddf=[];for(var _0x3fc05f=0x0;_0x3fc05f<_0x10dff2[_0xb1e1('0xce')]['length'];_0x3fc05f++){var _0x34f2ea=_0x10dff2[_0xb1e1('0xcf')]?_[_0xb1e1('0x52')](_0x10dff2['item_types'][_0x3fc05f])?'':_0x10dff2[_0xb1e1('0xcf')][_0x3fc05f]:_0x10dff2[_0xb1e1('0xce')][_0x3fc05f]['ItemTypeId']?_0x10dff2[_0xb1e1('0xce')][_0x3fc05f]['ItemTypeId']:'';var _0x1b7418=_[_0xb1e1('0x52')](_0x10dff2['items'][_0x3fc05f][_0xb1e1('0xd0')])?'':_0x10dff2[_0xb1e1('0xce')][_0x3fc05f][_0xb1e1('0xd0')];var _0x4942d8=_0x34f2ea+':'+_0x10dff2['items'][_0x3fc05f]['phone']+'§'+_0x1b7418;if(_[_0xb1e1('0x52')](_0x584a36))_0x584a36=_0x4942d8;else _0x584a36+=';'+_0x4942d8;var _0x1e9f8f=null;if(_0x10dff2[_0xb1e1('0xcf')]){if(!_[_0xb1e1('0x52')](_0x10dff2[_0xb1e1('0xcf')][_0x3fc05f])){var _0x5cf51b=_[_0xb1e1('0x42')](_0xc1b564,function(_0x17cf8e){return _0x17cf8e['id']===_0x10dff2[_0xb1e1('0xcf')][_0x3fc05f];});if(!_[_0xb1e1('0x52')](_0x5cf51b)){_0x1e9f8f=_0x5cf51b[_0xb1e1('0xd1')];}}}else{if(!_['isNil'](_0x10dff2[_0xb1e1('0xce')][_0x3fc05f])){var _0x5cf51b=_[_0xb1e1('0x42')](_0xc1b564,function(_0x3727c9){return _0x3727c9['id']===_0x10dff2['items'][_0x3fc05f][_0xb1e1('0xd2')];});if(!_['isNil'](_0x5cf51b)){_0x1e9f8f=_0x3fc05f;}}}if(_[_0xb1e1('0x52')](_0x1e9f8f)){_0x1e9f8f=0x64;}_0x137ddf['push'](addAdditionalPhone(_0x10dff2['id'],_0x10dff2['items'][_0x3fc05f][_0xb1e1('0xc5')],_0x10dff2[_0xb1e1('0xcf')]?_[_0xb1e1('0x52')](_0x10dff2[_0xb1e1('0xcf')][_0x3fc05f])?null:_0x10dff2[_0xb1e1('0xcf')][_0x3fc05f]:_0x10dff2[_0xb1e1('0xce')][_0x3fc05f][_0xb1e1('0xd2')]?_0x10dff2['items'][_0x3fc05f]['ItemTypeId']:null,_0x1e9f8f,_0x1b7418));}Promise['all'](_0x137ddf)['then'](function(){db[_0xb1e1('0x1e')][_0xb1e1('0x17')]({'AdditionalPhones':_0x584a36},{'where':{'id':_0x10dff2['id']}})[_0xb1e1('0x18')](function(){_0x34cecf(0x1);});});});});});}function addAdditionalPhone(_0x1c179a,_0xc87938,_0x5edd42,_0x5160ba,_0x4c864b){return db['CmContactHasItem']['find']({'where':{'CmContactId':_0x1c179a,'item':_0xc87938}})[_0xb1e1('0x18')](function(_0x435303){if(_0x435303)logger['info'](_0xb1e1('0xd3'),_0x435303);else{db[_0xb1e1('0xa0')][_0xb1e1('0x97')]({'CmContactId':_0x1c179a,'item':_0xc87938,'ItemTypeId':_0x5edd42,'OrderBy':_0x5160ba,'ItemClass':'PHONE','description':_0x4c864b});}});}function deletePhones(_0x1c0f9b){return db[_0xb1e1('0xa0')][_0xb1e1('0x19')]({'where':{'CmContactId':_0x1c0f9b}});}function deleteCmHopperPhones(_0xfa5510){return new Promise(function(_0x43814a,_0x4db101){return db[_0xb1e1('0xc6')][_0xb1e1('0x8b')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0xfa5510}})[_0xb1e1('0x18')](function(_0x5b89ce){db[_0xb1e1('0xd4')][_0xb1e1('0x19')]({'where':{'CmHopperId':{'$in':_[_0xb1e1('0x50')](_0x5b89ce,'id')}}});})[_0xb1e1('0x18')](function(){_0x43814a(0x1);});});}function addCmHopperPhones(_0x1a7d10){return new Promise(function(_0x3a502c,_0x215512){return db[_0xb1e1('0xc6')][_0xb1e1('0x8b')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x1a7d10}})['then'](function(_0x5c50a0){var _0x119a19=[];_['map'](_0x5c50a0,function(_0x5beaa0){_0x119a19[_0xb1e1('0x22')](createCmHopperPhone(_0x1a7d10,_0x5beaa0['id']));});Promise['all'](_0x119a19)[_0xb1e1('0x18')](function(){_0x3a502c(0x1);});});});}function createCmHopperPhone(_0x11d0fd,_0x472563){return new Promise(function(_0x250acc,_0x42fb84){db[_0xb1e1('0xa0')][_0xb1e1('0x8b')]({'raw':!![],'attributes':[_0xb1e1('0xd5'),'OrderBy'],'where':{'CmContactId':_0x11d0fd,'ItemClass':_0xb1e1('0xd6')},'include':[{'model':db['ContactItemType'],'attributes':[_0xb1e1('0xd1')],'as':'ItemType'}],'order':[_0xb1e1('0xd1'),db['sequelize'][_0xb1e1('0xba')](_0xb1e1('0xd7'))]})['then'](function(_0x427186){var _0x23e15e=0x1;var _0x54b47e=_[_0xb1e1('0x50')](_0x427186,function(_0x5b8792){_0x5b8792[_0xb1e1('0xd8')]=_0x472563;_0x5b8792[_0xb1e1('0xc5')]=_0x5b8792[_0xb1e1('0xd5')];_0x5b8792[_0xb1e1('0xd1')]=_0x23e15e;delete _0x5b8792[_0xb1e1('0xd9')];_0x23e15e=_0x23e15e+0x1;return _0x5b8792;});return db[_0xb1e1('0xd4')]['bulkCreate'](_0x54b47e,{});})[_0xb1e1('0x18')](function(){_0x250acc(0x1);});});}function insertAdditionalPhones(_0x546b7f,_0x463f49){return new Promise(function(_0x3ca88b,_0x9b52be){var _0x25900e=[];for(var _0xd63b5=0x0;_0xd63b5<_0x463f49[_0xb1e1('0x20')];_0xd63b5++){var _0x43a7d8=_0x463f49[_0xd63b5];_0x25900e[_0xb1e1('0x22')](parseContactItemType(_0x43a7d8));}Promise[_0xb1e1('0x24')](_0x25900e)[_0xb1e1('0x18')](function(){var _0x27fe77={'id':_0x546b7f['id'],'items':_0x463f49};return addAdditionalPhones(_0x27fe77)[_0xb1e1('0x18')](function(_0x1ce3ab){return addCmHopperPhones(_0x546b7f['id']);});})[_0xb1e1('0x18')](function(){_0x3ca88b(_0x546b7f);});});}function parseContactItemType(_0x1da4f4){return new Promise(function(_0x2f13d3,_0x92e5cf){if(_0x1da4f4[_0xb1e1('0x2e')](_0xb1e1('0xd2'))){_0x2f13d3(_0x1da4f4);}else{return db[_0xb1e1('0xb8')][_0xb1e1('0x42')]({'where':{'name':_0x1da4f4[_0xb1e1('0xb9')]}})['then'](function(_0xab3446){if(_[_0xb1e1('0x52')](_0xab3446))_0x1da4f4[_0xb1e1('0xd2')]=null;else _0x1da4f4[_0xb1e1('0xd2')]=_0xab3446['id'];_0x2f13d3(_0x1da4f4);});}});}exports[_0xb1e1('0xda')]=function(_0x494734,_0x31d9c1){return db[_0xb1e1('0xa0')]['findAll']({'raw':!![],'where':{'CmContactId':_0x494734['params']['id'],'ItemClass':_0xb1e1('0xd6')},'include':[{'model':db[_0xb1e1('0xb8')],'as':_0xb1e1('0xb9')}],'order':[[_0xb1e1('0xd1')],[db[_0xb1e1('0x73')][_0xb1e1('0xba')](_0xb1e1('0xd7'))]]})[_0xb1e1('0x18')](function(_0x36e16a){return _0x36e16a;})[_0xb1e1('0x18')](respondWithResult(_0x31d9c1,null))[_0xb1e1('0x84')](handleError(_0x31d9c1,null));};exports['duplicateAdditionalPhones']=function(_0x4dc4c4,_0x574c90){return db[_0xb1e1('0xa0')][_0xb1e1('0x8b')]({'raw':!![],'where':{'CmContactId':_0x4dc4c4[_0xb1e1('0x90')]['fromContactId']}})[_0xb1e1('0x18')](function(_0x4cff8d){var _0x5badea=_[_0xb1e1('0x50')](_0x4cff8d,function(_0x25cbde){_0x25cbde[_0xb1e1('0xdb')]=_0x4dc4c4[_0xb1e1('0x90')][_0xb1e1('0xdc')];return _0x25cbde;});return db['CmContactHasItem'][_0xb1e1('0xae')](_0x5badea,{});})['then'](function(_0x58ed1e){return addCmHopperPhones(_0x4dc4c4['body'][_0xb1e1('0xdc')]);})[_0xb1e1('0x18')](function(_0x4b1f3c){return['ok'];})[_0xb1e1('0x18')](respondWithResult(_0x574c90,null))[_0xb1e1('0x84')](handleError(_0x574c90,null));};exports['rescheduleAdditionalPhones']=function(_0x30175a,_0x3a301b){var _0x1ffc24=[];_0x1ffc24[_0xb1e1('0x22')](createCmHopperPhone(_0x30175a[_0xb1e1('0x90')]['id'],_0x30175a[_0xb1e1('0x90')][_0xb1e1('0xdd')]));Promise['all'](_0x1ffc24)[_0xb1e1('0x18')](function(){return[0x1];})[_0xb1e1('0x18')](respondWithResult(_0x3a301b,null));};exports[_0xb1e1('0xde')]=function(_0x2c6d78,_0x215629){var _0x11e0dd={'raw':![],'where':{}};var _0x282735={};var _0x2e9bbd={'count':0x0,'rows':[]};return db[_0xb1e1('0x1e')][_0xb1e1('0xc7')]({'where':{'id':_0x2c6d78[_0xb1e1('0x85')]['id']}})[_0xb1e1('0x18')](handleEntityNotFound(_0x215629,null))['then'](function(_0x338728){if(_0x338728){_0x282735['model']=_[_0xb1e1('0x1f')](db[_0xb1e1('0xc6')]['rawAttributes']);_0x282735['query']=_[_0xb1e1('0x1f')](_0x2c6d78[_0xb1e1('0x29')]);_0x282735[_0xb1e1('0x2a')]=_[_0xb1e1('0x2c')](_0x282735[_0xb1e1('0x28')],_0x282735['query']);_0x11e0dd[_0xb1e1('0x2b')]=_[_0xb1e1('0x2c')](_0x282735[_0xb1e1('0x28')],qs[_0xb1e1('0x2d')](_0x2c6d78[_0xb1e1('0x29')][_0xb1e1('0x2d')]));_0x11e0dd[_0xb1e1('0x2b')]=_0x11e0dd[_0xb1e1('0x2b')][_0xb1e1('0x20')]?_0x11e0dd[_0xb1e1('0x2b')]:_0x282735[_0xb1e1('0x28')];if(!_0x2c6d78[_0xb1e1('0x29')][_0xb1e1('0x2e')]('nolimit')){_0x11e0dd['limit']=qs[_0xb1e1('0x12')](_0x2c6d78[_0xb1e1('0x29')][_0xb1e1('0x12')]);_0x11e0dd['offset']=qs[_0xb1e1('0x10')](_0x2c6d78[_0xb1e1('0x29')][_0xb1e1('0x10')]);}_0x11e0dd[_0xb1e1('0x30')]=qs[_0xb1e1('0x31')](_0x2c6d78[_0xb1e1('0x29')]['sort']);_0x11e0dd[_0xb1e1('0x3c')]=qs[_0xb1e1('0x2a')](_[_0xb1e1('0x32')](_0x2c6d78[_0xb1e1('0x29')],_0x282735[_0xb1e1('0x2a')]));_0x11e0dd[_0xb1e1('0x3c')]['ContactId']=_0x338728['id'];if(_0x2c6d78[_0xb1e1('0x29')][_0xb1e1('0x51')]){_0x11e0dd[_0xb1e1('0x3c')]=_['merge'](_0x11e0dd['where'],{'$or':_[_0xb1e1('0x50')](_0x11e0dd['attributes'],function(_0x3b16da){var _0x3c981c={};_0x3c981c[_0x3b16da]={'$like':'%'+_0x2c6d78[_0xb1e1('0x29')][_0xb1e1('0x51')]+'%'};return _0x3c981c;})});}_0x11e0dd=_[_0xb1e1('0x8f')]({},_0x11e0dd,_0x2c6d78[_0xb1e1('0xc9')]);return db[_0xb1e1('0xc6')]['count']({'where':_0x11e0dd['where']})[_0xb1e1('0x18')](function(_0x39b92f){_0x2e9bbd[_0xb1e1('0x13')]=_0x39b92f;if(_0x2c6d78[_0xb1e1('0x29')]['includeAll']){_0x11e0dd[_0xb1e1('0xdf')]=[{'all':!![]}];}return db[_0xb1e1('0xc6')][_0xb1e1('0x8b')](_0x11e0dd);})[_0xb1e1('0x18')](function(_0x1951e4){_0x2e9bbd['rows']=_0x1951e4;return _0x2e9bbd;});}})[_0xb1e1('0x18')](respondWithFilteredResult(_0x215629,_0x11e0dd))['catch'](handleError(_0x215629,null));};exports[_0xb1e1('0xe0')]=function(_0x31fde7,_0x30cefd){var _0x174a70={'raw':!![],'where':{}};var _0x385160={};var _0x2810ee={'count':0x0,'rows':[]};return db[_0xb1e1('0x1e')][_0xb1e1('0xc7')]({'where':{'id':_0x31fde7[_0xb1e1('0x85')]['id']}})['then'](handleEntityNotFound(_0x30cefd,null))['then'](function(_0x3dcd5a){if(_0x3dcd5a){_0x385160[_0xb1e1('0x28')]=_[_0xb1e1('0x1f')](db[_0xb1e1('0xe1')][_0xb1e1('0xc8')]);_0x385160[_0xb1e1('0x29')]=_[_0xb1e1('0x1f')](_0x31fde7[_0xb1e1('0x29')]);_0x385160[_0xb1e1('0x2a')]=_[_0xb1e1('0x2c')](_0x385160[_0xb1e1('0x28')],_0x385160[_0xb1e1('0x29')]);_0x174a70['attributes']=_[_0xb1e1('0x2c')](_0x385160[_0xb1e1('0x28')],qs[_0xb1e1('0x2d')](_0x31fde7[_0xb1e1('0x29')][_0xb1e1('0x2d')]));_0x174a70[_0xb1e1('0x2b')]=_0x174a70[_0xb1e1('0x2b')][_0xb1e1('0x20')]?_0x174a70[_0xb1e1('0x2b')]:_0x385160[_0xb1e1('0x28')];if(!_0x31fde7[_0xb1e1('0x29')]['hasOwnProperty']('nolimit')){_0x174a70['limit']=qs[_0xb1e1('0x12')](_0x31fde7['query'][_0xb1e1('0x12')]);_0x174a70[_0xb1e1('0x10')]=qs[_0xb1e1('0x10')](_0x31fde7[_0xb1e1('0x29')][_0xb1e1('0x10')]);}_0x174a70['order']=qs[_0xb1e1('0x31')](_0x31fde7[_0xb1e1('0x29')][_0xb1e1('0x31')]);_0x174a70[_0xb1e1('0x3c')]=qs[_0xb1e1('0x2a')](_[_0xb1e1('0x32')](_0x31fde7[_0xb1e1('0x29')],_0x385160[_0xb1e1('0x2a')]));_0x174a70['where'][_0xb1e1('0xe2')]=_0x3dcd5a['id'];if(_0x31fde7['query'][_0xb1e1('0x51')]){_0x174a70[_0xb1e1('0x3c')]=_[_0xb1e1('0x8f')](_0x174a70[_0xb1e1('0x3c')],{'$or':_[_0xb1e1('0x50')](_0x174a70[_0xb1e1('0x2b')],function(_0x4a83be){var _0x9a0471={};_0x9a0471[_0x4a83be]={'$like':'%'+_0x31fde7[_0xb1e1('0x29')]['filter']+'%'};return _0x9a0471;})});}_0x174a70=_[_0xb1e1('0x8f')]({},_0x174a70,_0x31fde7[_0xb1e1('0xc9')]);return db['CmHopperHistory'][_0xb1e1('0x13')]({'where':_0x174a70[_0xb1e1('0x3c')]})['then'](function(_0x4dda44){_0x2810ee[_0xb1e1('0x13')]=_0x4dda44;if(_0x31fde7['query'][_0xb1e1('0xe3')]){_0x174a70[_0xb1e1('0xdf')]=[{'all':!![]}];}return db[_0xb1e1('0xe1')]['findAll'](_0x174a70);})[_0xb1e1('0x18')](function(_0x52bc69){_0x2810ee[_0xb1e1('0x83')]=_0x52bc69;return _0x2810ee;});}})[_0xb1e1('0x18')](respondWithFilteredResult(_0x30cefd,_0x174a70))[_0xb1e1('0x84')](handleError(_0x30cefd,null));};exports[_0xb1e1('0xe4')]=function(_0x1615aa,_0x16102e){var _0x1ae90b={'raw':!![],'where':{}};var _0x2e9f0a={};var _0x18f436={'count':0x0,'rows':[]};return db[_0xb1e1('0x1e')][_0xb1e1('0xc7')]({'where':{'id':_0x1615aa[_0xb1e1('0x85')]['id']}})[_0xb1e1('0x18')](handleEntityNotFound(_0x16102e,null))[_0xb1e1('0x18')](function(_0x5b042c){if(_0x5b042c){_0x2e9f0a[_0xb1e1('0x28')]=_[_0xb1e1('0x1f')](db[_0xb1e1('0xe5')][_0xb1e1('0xc8')]);_0x2e9f0a['query']=_[_0xb1e1('0x1f')](_0x1615aa[_0xb1e1('0x29')]);_0x2e9f0a[_0xb1e1('0x2a')]=_[_0xb1e1('0x2c')](_0x2e9f0a[_0xb1e1('0x28')],_0x2e9f0a['query']);_0x1ae90b['attributes']=_[_0xb1e1('0x2c')](_0x2e9f0a['model'],qs[_0xb1e1('0x2d')](_0x1615aa[_0xb1e1('0x29')][_0xb1e1('0x2d')]));_0x1ae90b[_0xb1e1('0x2b')]=_0x1ae90b[_0xb1e1('0x2b')][_0xb1e1('0x20')]?_0x1ae90b[_0xb1e1('0x2b')]:_0x2e9f0a[_0xb1e1('0x28')];if(!_0x1615aa[_0xb1e1('0x29')][_0xb1e1('0x2e')]('nolimit')){_0x1ae90b[_0xb1e1('0x12')]=qs['limit'](_0x1615aa[_0xb1e1('0x29')][_0xb1e1('0x12')]);_0x1ae90b[_0xb1e1('0x10')]=qs[_0xb1e1('0x10')](_0x1615aa['query'][_0xb1e1('0x10')]);}_0x1ae90b[_0xb1e1('0x30')]=qs['sort'](_0x1615aa['query'][_0xb1e1('0x31')]);_0x1ae90b['where']=qs[_0xb1e1('0x2a')](_[_0xb1e1('0x32')](_0x1615aa[_0xb1e1('0x29')],_0x2e9f0a[_0xb1e1('0x2a')]));_0x1ae90b[_0xb1e1('0x3c')][_0xb1e1('0xe2')]=_0x5b042c['id'];if(_0x1615aa['query'][_0xb1e1('0x51')]){_0x1ae90b['where']=_['merge'](_0x1ae90b[_0xb1e1('0x3c')],{'$or':_[_0xb1e1('0x50')](_0x1ae90b['attributes'],function(_0x35b418){var _0x4428d0={};_0x4428d0[_0x35b418]={'$like':'%'+_0x1615aa['query']['filter']+'%'};return _0x4428d0;})});}_0x1ae90b=_['merge']({},_0x1ae90b,_0x1615aa['options']);return db[_0xb1e1('0xe5')][_0xb1e1('0x13')]({'where':_0x1ae90b[_0xb1e1('0x3c')]})['then'](function(_0x327977){_0x18f436[_0xb1e1('0x13')]=_0x327977;if(_0x1615aa[_0xb1e1('0x29')][_0xb1e1('0xe3')]){_0x1ae90b['include']=[{'all':!![]}];}return db[_0xb1e1('0xe5')][_0xb1e1('0x8b')](_0x1ae90b);})[_0xb1e1('0x18')](function(_0x2630d0){_0x18f436['rows']=_0x2630d0;return _0x18f436;});}})['then'](respondWithFilteredResult(_0x16102e,_0x1ae90b))['catch'](handleError(_0x16102e,null));};exports[_0xb1e1('0xe6')]=function(_0x4c389a,_0xa1a105){var _0x74478c={'raw':!![],'where':{}};var _0x30020c={};var _0x7abfe5={'count':0x0,'rows':[]};return db[_0xb1e1('0x1e')]['findOne']({'where':{'id':_0x4c389a[_0xb1e1('0x85')]['id']}})[_0xb1e1('0x18')](handleEntityNotFound(_0xa1a105,null))[_0xb1e1('0x18')](function(_0x9af35){if(_0x9af35){_0x30020c[_0xb1e1('0x28')]=_[_0xb1e1('0x1f')](db[_0xb1e1('0xa6')]['rawAttributes']);_0x30020c[_0xb1e1('0x29')]=_[_0xb1e1('0x1f')](_0x4c389a[_0xb1e1('0x29')]);_0x30020c[_0xb1e1('0x2a')]=_[_0xb1e1('0x2c')](_0x30020c[_0xb1e1('0x28')],_0x30020c[_0xb1e1('0x29')]);_0x74478c[_0xb1e1('0x2b')]=_['intersection'](_0x30020c[_0xb1e1('0x28')],qs[_0xb1e1('0x2d')](_0x4c389a[_0xb1e1('0x29')][_0xb1e1('0x2d')]));_0x74478c[_0xb1e1('0x2b')]=_0x74478c[_0xb1e1('0x2b')][_0xb1e1('0x20')]?_0x74478c['attributes']:_0x30020c[_0xb1e1('0x28')];if(!_0x4c389a[_0xb1e1('0x29')][_0xb1e1('0x2e')](_0xb1e1('0x2f'))){_0x74478c[_0xb1e1('0x12')]=qs[_0xb1e1('0x12')](_0x4c389a['query'][_0xb1e1('0x12')]);_0x74478c[_0xb1e1('0x10')]=qs[_0xb1e1('0x10')](_0x4c389a[_0xb1e1('0x29')][_0xb1e1('0x10')]);}_0x74478c[_0xb1e1('0x30')]=qs[_0xb1e1('0x31')](_0x4c389a['query'][_0xb1e1('0x31')]);_0x74478c[_0xb1e1('0x3c')]=qs['filters'](_[_0xb1e1('0x32')](_0x4c389a[_0xb1e1('0x29')],_0x30020c[_0xb1e1('0x2a')]));_0x74478c[_0xb1e1('0x3c')]['ContactId']=_0x9af35['id'];if(_0x4c389a[_0xb1e1('0x29')][_0xb1e1('0x51')]){_0x74478c[_0xb1e1('0x3c')]=_['merge'](_0x74478c['where'],{'$or':_[_0xb1e1('0x50')](_0x74478c[_0xb1e1('0x2b')],function(_0x5f3b89){var _0x11f2e6={};_0x11f2e6[_0x5f3b89]={'$like':'%'+_0x4c389a[_0xb1e1('0x29')]['filter']+'%'};return _0x11f2e6;})});}_0x74478c=_[_0xb1e1('0x8f')]({},_0x74478c,_0x4c389a[_0xb1e1('0xc9')]);return db[_0xb1e1('0xa6')][_0xb1e1('0x13')]({'where':_0x74478c[_0xb1e1('0x3c')]})[_0xb1e1('0x18')](function(_0xa5be09){_0x7abfe5[_0xb1e1('0x13')]=_0xa5be09;if(_0x4c389a[_0xb1e1('0x29')]['includeAll']){_0x74478c[_0xb1e1('0xdf')]=[{'all':!![]}];}return db[_0xb1e1('0xa6')][_0xb1e1('0x8b')](_0x74478c);})['then'](function(_0x4944a7){_0x7abfe5[_0xb1e1('0x83')]=_0x4944a7;return _0x7abfe5;});}})[_0xb1e1('0x18')](respondWithFilteredResult(_0xa1a105,_0x74478c))['catch'](handleError(_0xa1a105,null));};exports[_0xb1e1('0xe7')]=function(_0x1bedd9,_0x2957fb){try{if(!_0x1bedd9[_0xb1e1('0x90')][_0xb1e1('0xb2')]){throw new Error(_0xb1e1('0xe8'));}if(!_0x1bedd9[_0xb1e1('0x90')][_0xb1e1('0xe9')]){throw new Error(_0xb1e1('0xea'));}if(!_0x1bedd9[_0xb1e1('0x90')][_0xb1e1('0xeb')]){throw new Error('No\x20association\x20values\x20specified!');}if(!_0x1bedd9[_0xb1e1('0x90')][_0xb1e1('0xec')]){throw new Error(_0xb1e1('0xed'));}var _0x2b8a68=_0x1bedd9[_0xb1e1('0x90')][_0xb1e1('0xe9')][_0xb1e1('0x5d')](',');var _0x44f460=_0x1bedd9[_0xb1e1('0x90')][_0xb1e1('0xeb')][_0xb1e1('0x5d')](',');if(!_0x2b8a68['length']||!_0x44f460[_0xb1e1('0x20')]||_0x2b8a68[_0xb1e1('0x20')]!==_0x44f460[_0xb1e1('0x20')]){throw new Error(_0xb1e1('0xee'));}_0x1bedd9['body'][_0xb1e1('0x2d')]=_[_0xb1e1('0xef')](_0x2b8a68,_0x44f460);if(!_0x1bedd9['body'][_0xb1e1('0x2d')][_0xb1e1('0xc5')]){throw new Error(_0xb1e1('0xf0'));}if(!_0x1bedd9['body'][_0xb1e1('0x2d')]['firstName']){throw new Error(_0xb1e1('0xf1'));}var _0x3cd662=path['join'](config[_0xb1e1('0xf2')],'server/files/tmp',_0x1bedd9[_0xb1e1('0xf3')][_0xb1e1('0xf4')]);fs['chmodSync'](_0x3cd662,parseInt(_0xb1e1('0xf5'),0x8));var _0x26fdfa=require('child_process')[_0xb1e1('0xf6')](path['join'](__dirname,_0xb1e1('0xf7')),[_0x3cd662,_0x1bedd9[_0xb1e1('0x90')][_0xb1e1('0xe9')],_0x1bedd9[_0xb1e1('0x90')][_0xb1e1('0xeb')],_0x1bedd9['body'][_0xb1e1('0xb2')],_0x1bedd9[_0xb1e1('0x90')][_0xb1e1('0xf8')],_0x1bedd9[_0xb1e1('0x90')][_0xb1e1('0xb0')],_0x1bedd9[_0xb1e1('0x90')][_0xb1e1('0xec')]]);return _0x2957fb['status'](0xc8)[_0xb1e1('0x16')]({'message':_0xb1e1('0xf9'),'pid':_0x26fdfa['pid']});}catch(_0x20ce9d){return _0x2957fb[_0xb1e1('0xf')](0x1f4)[_0xb1e1('0x1d')](_0x20ce9d);}};exports[_0xb1e1('0xfa')]=function(_0xe7b13b,_0x490995){var _0xaf5961=fs[_0xb1e1('0xfb')](_0xe7b13b['file'][_0xb1e1('0xfc')]);Papa[_0xb1e1('0xfd')](_0xaf5961,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x5088a9){return _0x490995['status'](0xc8)[_0xb1e1('0x16')]({'file':_0xe7b13b[_0xb1e1('0xf3')],'fields':_0x5088a9[_0xb1e1('0xfe')][_0xb1e1('0x2d')]});}});};exports['import']=function(_0x4d0703,_0x2bb763){return db[_0xb1e1('0x46')][_0xb1e1('0x8b')]({'raw':!![],'attributes':['id'],'where':{'role':_0xb1e1('0x70')}})['then'](function(_0x157a44){var _0x3fb3a0=![];if(!_0x4d0703['body'][_0xb1e1('0xb2')]){throw new Error(_0xb1e1('0xe8'));}if(!_0x4d0703['body'][_0xb1e1('0xff')][_0xb1e1('0xc5')]){throw new Error(_0xb1e1('0xf0'));}if(!_0x4d0703['body']['binding']['firstName']){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x4d0703[_0xb1e1('0x90')]['socket_timestamp']){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x5c9936=require(_0xb1e1('0x100'))[_0xb1e1('0xf6')](path[_0xb1e1('0x93')](__dirname,'../../components/import/cm/csv2'),[_0x4d0703[_0xb1e1('0x85')]['id'],JSON['stringify'](_0x4d0703[_0xb1e1('0x90')]),JSON[_0xb1e1('0x101')](_0x157a44)]);_0x5c9936['on'](_0xb1e1('0x102'),function(){_0x3fb3a0=!![];return _0x2bb763[_0xb1e1('0xf')](0xc8)['json']({'message':_0xb1e1('0x103'),'pid':_0x5c9936[_0xb1e1('0x104')]});});_0x5c9936['on'](_0xb1e1('0x105'),function(_0x13d936){if(_0x13d936&&!_0x3fb3a0){return _0x2bb763[_0xb1e1('0xf')](0x1f4)['json']({'message':_0xb1e1('0x106'),'pid':_0x5c9936['pid']});}});})[_0xb1e1('0x84')](handleError(_0x2bb763,null));};exports[_0xb1e1('0x107')]=function(_0xab087a,_0x4c1637,_0x120c0e){return db[_0xb1e1('0x46')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0xb1e1('0x70')}})[_0xb1e1('0x18')](function(_0x144d07){var _0x1b0cbf=![];if(!_0xab087a[_0xb1e1('0x90')][_0xb1e1('0xb2')]){throw new Error(_0xb1e1('0xe8'));}if(!_0xab087a[_0xb1e1('0x90')][_0xb1e1('0xff')][_0xb1e1('0xc5')]){throw new Error(_0xb1e1('0xf0'));}if(!_0xab087a['body']['binding'][_0xb1e1('0x108')]){throw new Error(_0xb1e1('0xf1'));}if(!_0xab087a[_0xb1e1('0x90')]['socket_timestamp']){throw new Error(_0xb1e1('0xed'));}var _0x2ba767=require(_0xb1e1('0x100'))['fork'](path[_0xb1e1('0x93')](__dirname,_0xb1e1('0x109')),[_0xab087a[_0xb1e1('0x85')]['id'],JSON[_0xb1e1('0x101')](_0xab087a[_0xb1e1('0x90')]),JSON[_0xb1e1('0x101')](_0x144d07)]);_0x2ba767['on'](_0xb1e1('0x102'),function(_0x4d35ac){_0x1b0cbf=!![];return _0x4c1637[_0xb1e1('0xf')](0xc8)[_0xb1e1('0x16')]({'message':_0xb1e1('0x103'),'pid':_0x2ba767[_0xb1e1('0x104')]});});_0x2ba767['on'](_0xb1e1('0x105'),function(_0x219bda){if(_0x219bda&&!_0x1b0cbf){return _0x4c1637['status'](0x1f4)['json']({'message':_0xb1e1('0x106'),'pid':_0x2ba767[_0xb1e1('0x104')]});}});})[_0xb1e1('0x84')](handleError(_0x4c1637,null));};exports['getJourney']=function(_0x35fc15,_0x423cd3){var _0x415da2=['mail',_0xb1e1('0x10a'),_0xb1e1('0x10b'),'openchannel',_0xb1e1('0x10c'),'whatsapp',_0xb1e1('0x10d')];var _0x1c2e80={'offset':0x0,'order':qs[_0xb1e1('0x31')](_0xb1e1('0x10e'))},_0x1dc220={'count':0x0,'rows':[]};Promise[_0xb1e1('0x10f')]()['then'](function(){if(_0x35fc15[_0xb1e1('0x29')][_0xb1e1('0x110')]){if(!_[_0xb1e1('0x111')](_0x415da2,_0x35fc15[_0xb1e1('0x29')]['channel'][_0xb1e1('0x112')]())){throw new Error(_0xb1e1('0x113'));}_0x415da2=[_0x35fc15[_0xb1e1('0x29')][_0xb1e1('0x110')][_0xb1e1('0x112')]()];}if(_0x35fc15[_0xb1e1('0x29')]['range']){try{var _0xa0b6de=JSON[_0xb1e1('0xfd')](_0x35fc15[_0xb1e1('0x29')]['range']);if(!moment(_0xa0b6de[_0xb1e1('0x35')])['isValid']()){throw new Error(_0xb1e1('0x114'));}if(!moment(_0xa0b6de['to'])[_0xb1e1('0x115')]()){throw new Error(_0xb1e1('0x116'));}}catch(_0xe17f66){throw new Error('Invalid\x20createdAt\x20filter');}}if(!_0x35fc15['query'][_0xb1e1('0x2e')](_0xb1e1('0x2f'))){_0x1c2e80[_0xb1e1('0x12')]=qs['limit'](_0x35fc15[_0xb1e1('0x29')][_0xb1e1('0x12')]||0xa);_0x1c2e80[_0xb1e1('0x10')]=qs[_0xb1e1('0x10')](_0x35fc15[_0xb1e1('0x29')][_0xb1e1('0x10')]);}var _0x4cc842=_0x415da2[_0xb1e1('0x50')](function(_0x2eca6a){if(_0x2eca6a==='voice'){var _0x3a4f52={'attributes':['id',_0xb1e1('0x117'),_0xb1e1('0x27'),_0xb1e1('0x118'),'destination',_0xb1e1('0x119'),'starttime','endtime','duration','note',_0xb1e1('0x11a'),'userDisposition',_0xb1e1('0x11b'),_0xb1e1('0x11c'),_0xb1e1('0x11d')],'where':{'ContactId':_0x35fc15['params']['id']},'include':[{'model':db['User'],'as':_0xb1e1('0x46'),'attributes':['id',_0xb1e1('0x1c'),_0xb1e1('0x11e'),_0xb1e1('0x8c')]}],'order':[[_0xb1e1('0x11a'),_0xb1e1('0x6c')]]};if(_0x35fc15[_0xb1e1('0x29')][_0xb1e1('0x11f')]){_0x3a4f52[_0xb1e1('0x3c')][_0xb1e1('0x11a')]={'$gte':_0xa0b6de[_0xb1e1('0x35')],'$lte':_0xa0b6de['to']};}return db[_0xb1e1('0xa1')][_0xb1e1('0x120')](_0x3a4f52)[_0xb1e1('0x18')](function(_0x341dfa){_0x1dc220[_0xb1e1('0x13')]+=_0x341dfa['count'];return _[_0xb1e1('0x50')](_0x341dfa[_0xb1e1('0x83')],function(_0x5ac5ef){var _0x44199f=_0x5ac5ef['get']({'plain':!![]});_0x44199f['channel']=_0x2eca6a;if(_0x44199f['User']){_0x44199f[_0xb1e1('0x46')]={'id':_0x44199f[_0xb1e1('0x46')]['id'],'name':_0x44199f[_0xb1e1('0x46')][_0xb1e1('0x1c')],'fullname':_0x44199f[_0xb1e1('0x46')][_0xb1e1('0x11e')],'alias':_0x44199f[_0xb1e1('0x46')][_0xb1e1('0x8c')]};}return _0x44199f;});});}else{var _0x3c8443=_[_0xb1e1('0x121')](_0x2eca6a)+(_0x2eca6a===_0xb1e1('0x10a')?_0xb1e1('0x122'):_0xb1e1('0x123'));var _0x10040c={'attributes':['id',_0xb1e1('0x124'),_0xb1e1('0x125'),_0xb1e1('0x11a'),_0xb1e1('0x126'),_0xb1e1('0x127'),'secondDisposition',_0xb1e1('0x128'),'UserId',_0x3c8443+'Id'],'where':{'ContactId':_0x35fc15[_0xb1e1('0x85')]['id']},'include':[{'model':db[_0x3c8443],'as':_0xb1e1('0x123'),'attributes':['id',_0xb1e1('0x1c'),_0xb1e1('0x129')]},{'model':db[_0xb1e1('0x46')],'as':'Owner','attributes':['id','name','fullname']},{'model':db[_0xb1e1('0x43')],'as':_0xb1e1('0x82'),'attributes':['id','name',_0xb1e1('0xb6')],'through':{'attributes':[]}}],'order':[[_0xb1e1('0x11a'),_0xb1e1('0x6c')]]};if(_0x35fc15['query'][_0xb1e1('0x11f')]){_0x10040c['where'][_0xb1e1('0x11a')]={'$gte':_0xa0b6de[_0xb1e1('0x35')],'$lte':_0xa0b6de['to']};}switch(_0x2eca6a){case'chat':_0x10040c[_0xb1e1('0x2b')][_0xb1e1('0x22')]('browserName',_0xb1e1('0x12a'),_0xb1e1('0x12b'),'deviceModel','osName',_0xb1e1('0x12c'),_0xb1e1('0x12d'),_0xb1e1('0x12e'),'referer');break;case'mail':_0x10040c[_0xb1e1('0x2b')]['push'](_0xb1e1('0x12f'),_0xb1e1('0x130'));break;case'openchannel':_0x10040c[_0xb1e1('0x2b')]['push']('externalUrl',_0xb1e1('0x131'));break;}return db[_['startCase'](_0x2eca6a)+'Interaction']['findAndCountAll'](_0x10040c)[_0xb1e1('0x18')](function(_0x31a716){_0x1dc220['count']+=_0x31a716[_0xb1e1('0x13')];return _[_0xb1e1('0x50')](_0x31a716[_0xb1e1('0x83')],function(_0x3ebb97){var _0x48afb7=_0x3ebb97['get']({'plain':!![]});_0x48afb7[_0xb1e1('0x110')]=_0x2eca6a;if(_0x48afb7[_0xb1e1('0x132')]){_0x48afb7['Owner']={'id':_0x48afb7[_0xb1e1('0x132')]['id'],'name':_0x48afb7[_0xb1e1('0x132')][_0xb1e1('0x1c')],'fullname':_0x48afb7[_0xb1e1('0x132')][_0xb1e1('0x11e')]};}return _0x48afb7;});});}});return Promise[_0xb1e1('0x24')](_0x4cc842);})['then'](function(_0x113f83){return _(_0x113f83)[_0xb1e1('0x133')]()['sortBy'](_0xb1e1('0x11a'))[_0xb1e1('0x134')]()[_0xb1e1('0x49')]();})[_0xb1e1('0x18')](function(_0x1d5fcc){_0x1dc220[_0xb1e1('0x83')]=_0x1c2e80[_0xb1e1('0x12')]?_0x1d5fcc[_0xb1e1('0x135')](_0x1c2e80['offset'],_0x1c2e80[_0xb1e1('0x10')]+_0x1c2e80['limit']):_0x1d5fcc;return _0x1dc220;})[_0xb1e1('0x18')](respondWithFilteredResult(_0x423cd3,_0x1c2e80))['catch'](handleError(_0x423cd3,null));};
\ No newline at end of file
+var _0x4b93=['toContactId','rescheduleAdditionalPhones','getHoppers','options','include','includeAll','getHopperFinals','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','zipObject','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','root','file','filename','chmodSync','0777','child_process','fork','CompanyId','pid','send','upload','path','parse','meta','import','binding','../../components/import/cm/csv2','stringify','start\x20child\x20process\x20correctly!','exit','error\x20child\x20process','importUpdates','../../components/import/cm/csvUpdates','message','mail','chat','sms','openchannel','fax','whatsapp','voice','channel','includes','Invalid\x20channel','toLowerCase','range','isValid','Invalid\x20date\x20for\x20range\x20from\x20filter','Invalid\x20createdAt\x20filter','uniqueid','source','destination','callerid','starttime','endtime','duration','createdAt','userDisposition','userSecondDisposition','userThirdDisposition','UserId','fullname','findAndCountAll','startCase','Website','Account','closed','closedAt','note','disposition','secondDisposition','thirdDisposition','Owner','DESC','browserName','customerIp','customerPort','ratingMessage','ratingType','ratingValue','referer','subject','substatus','externalUrl','threadId','Interaction','sortBy','reverse','slice','moment','bluebird','util','lodash','squel','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/environment/shared','../../mysqldb','redis','defaults','localhost','socket.io-emitter','register','status','json','undefined','limit','count','offset','update','then','sendStatus','error','stack','name','index','CmContact','describe','keys','length','startsWith','cf_','CmCustomField','trimStart','all','type','model','query','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','filters','pick','select','field','color','from','tools_tags','cm_contacts','left_join','cm_user_has_contacts','uc.CmContactId\x20=\x20c.id','cm_contact_has_tags','ct.CmContactId\x20=\x20c.id','t.id\x20=\x20ct.TagId','where','c.deletedAt\x20IS\x20NULL','expr','search','parseSearch','conditions','value','split','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','and','uc.UserId\x20=\x20?','dateOfBirth','fieldType','datetime','castTo','DATE','buildExpression','text','map','filter','isNil','push','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','tag','isArray','replace','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','c.id\x20LIKE\x20?','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','group','c.id','Sequelize','clone','isEmpty','having','t.id\x20IN\x20?','resolve','user','role','agent','some','getLists','c.ListId\x20IN\x20?','ListId','toString','sequelize','keyBy','merge','c.firstName','c.lastName','c.phone','c.mobile','c.fax','c.email','c.ListId','c.createdAt','c.deletedAt','c.CompanyId','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','Tags','rows','catch','destroy','find','params','tags','displayName','analytics','columnName','alias','custom','body','findAll','get','mergeWith','info','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmContactHasItem','CmHopperFinal','CmHopperHistory','VoiceCallReport','ChatQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','WhatsappInteraction','WhatsappMessage','WhatsappQueueReport','join','dialTimezone','timezones','utcOffset','additionalPhones','duplicates','$or','findOrCreate','spread','show','Tag','Phones','ContactItemType','ItemType','literal','Phones.OrderBy','$and','omit','cf_%d','pickBy','format','table','setFields','id\x20=\x20?','toParam','values','phone','getTags','findOne','rawAttributes','setTags','ids','setAdditionalPhones','item_types','items','description','OrderBy','ItemTypeId','PHONE','CmHopperAdditionalPhone','`ItemType`.OrderBy','CmHopperId','item','ItemType.OrderBy','bulkCreate','getAdditionalPhones','fromContactId','CmContactId'];(function(_0x1998bb,_0x1f1da1){var _0x4ae4c9=function(_0x4741e8){while(--_0x4741e8){_0x1998bb['push'](_0x1998bb['shift']());}};_0x4ae4c9(++_0x1f1da1);}(_0x4b93,0x65));var _0x34b9=function(_0x42245d,_0x51758f){_0x42245d=_0x42245d-0x0;var _0x4b211a=_0x4b93[_0x42245d];return _0x4b211a;};'use strict';var moment=require(_0x34b9('0x0'));var BPromise=require(_0x34b9('0x1'));var util=require(_0x34b9('0x2'));var path=require('path');var fs=require('fs');var _=require(_0x34b9('0x3'));var squel=require(_0x34b9('0x4'));var Papa=require('papaparse');var Redis=require('ioredis');var qs=require(_0x34b9('0x5'));var as=require(_0x34b9('0x6'));var logger=require('../../config/logger')('api');var config=require('../../config/environment');var shared=require(_0x34b9('0x7'));var db=require(_0x34b9('0x8'))['db'];config[_0x34b9('0x9')]=_[_0x34b9('0xa')](config[_0x34b9('0x9')],{'host':_0x34b9('0xb'),'port':0x18eb});var socket=require(_0x34b9('0xc'))(new Redis(config[_0x34b9('0x9')]));require('./cmContact.socket')[_0x34b9('0xd')](socket);function respondWithResult(_0x1db3a8,_0x33ad04){_0x33ad04=_0x33ad04||0xc8;return function(_0x66fc3a){if(_0x66fc3a){return _0x1db3a8[_0x34b9('0xe')](_0x33ad04)[_0x34b9('0xf')](_0x66fc3a);}};}function respondWithFilteredResult(_0x38532c,_0x258c10){return function(_0x157784){if(_0x157784){var _0x279663=typeof _0x258c10['offset']===_0x34b9('0x10')&&typeof _0x258c10[_0x34b9('0x11')]===_0x34b9('0x10');var _0x15811f=_0x157784[_0x34b9('0x12')];var _0x39a1f1=_0x279663?0x0:_0x258c10[_0x34b9('0x13')];var _0x17a9e6=_0x279663?_0x157784[_0x34b9('0x12')]:_0x258c10[_0x34b9('0x13')]+_0x258c10['limit'];var _0x14659d;if(_0x17a9e6>=_0x15811f){_0x17a9e6=_0x15811f;_0x14659d=0xc8;}else{_0x14659d=0xce;}_0x38532c[_0x34b9('0xe')](_0x14659d);return _0x38532c['set']('Content-Range',_0x39a1f1+'-'+_0x17a9e6+'/'+_0x15811f)[_0x34b9('0xf')](_0x157784);}return null;};}function saveUpdates(_0xe3c9c9){return function(_0x1b89ef){if(_0x1b89ef){return _0x1b89ef[_0x34b9('0x14')](_0xe3c9c9)[_0x34b9('0x15')](function(_0x2d2001){return _0x2d2001;});}return null;};}function removeEntity(_0xcaf1ad){return function(_0x11fa1f){if(_0x11fa1f){return _0x11fa1f['destroy']()[_0x34b9('0x15')](function(){_0xcaf1ad[_0x34b9('0xe')](0xcc)['end']();});}};}function handleEntityNotFound(_0x1d53d0){return function(_0x174b8e){if(!_0x174b8e){_0x1d53d0[_0x34b9('0x16')](0x194);}return _0x174b8e;};}function handleError(_0x24a838,_0xbaa7cc){_0xbaa7cc=_0xbaa7cc||0x1f4;return function(_0x20d661){logger[_0x34b9('0x17')](_0x20d661[_0x34b9('0x18')]);if(_0x20d661[_0x34b9('0x19')]){delete _0x20d661[_0x34b9('0x19')];}_0x24a838[_0x34b9('0xe')](_0xbaa7cc)['send'](_0x20d661);};}exports[_0x34b9('0x1a')]=function(_0x48c6f4,_0x1ad8ef){var _0x60b314={},_0x59277d={},_0x3ac396={'count':0x0,'rows':[]};return db[_0x34b9('0x1b')][_0x34b9('0x1c')]()[_0x34b9('0x15')](function(_0x1e5e1f){var _0x20f857=[];for(var _0xd9713f=0x0;_0xd9713f<Object[_0x34b9('0x1d')](_0x1e5e1f)[_0x34b9('0x1e')];_0xd9713f++){var _0x2c6ba5=Object['keys'](_0x1e5e1f)[_0xd9713f];if(_[_0x34b9('0x1f')](_0x2c6ba5,_0x34b9('0x20'))){_0x20f857['push'](db[_0x34b9('0x21')]['findOne']({'where':{'id':_[_0x34b9('0x22')](_0x2c6ba5,_0x34b9('0x20'))},'raw':!![]}));}}return BPromise[_0x34b9('0x23')](_0x20f857)[_0x34b9('0x15')](function(_0x404667){for(var _0x292aea=0x0;_0x292aea<_0x404667[_0x34b9('0x1e')];_0x292aea++){if(_0x404667[_0x292aea]){var _0x26f2c2='cf_'+_0x404667[_0x292aea]['id'];var _0x326eb7=_0x1e5e1f[_0x26f2c2];_0x326eb7['fieldType']=_0x404667[_0x292aea][_0x34b9('0x24')];}}return _0x1e5e1f;});})['then'](function(_0x1e8d5e){_0x59277d[_0x34b9('0x25')]=_[_0x34b9('0x1d')](_0x1e8d5e);_0x59277d[_0x34b9('0x26')]=_[_0x34b9('0x1d')](_0x48c6f4['query']);_0x59277d['filters']=_[_0x34b9('0x27')](_0x59277d[_0x34b9('0x25')],_0x59277d['query']);_0x60b314[_0x34b9('0x28')]=_['intersection'](_0x59277d[_0x34b9('0x25')],qs[_0x34b9('0x29')](_0x48c6f4[_0x34b9('0x26')][_0x34b9('0x29')]));_0x60b314[_0x34b9('0x28')]=_0x60b314[_0x34b9('0x28')][_0x34b9('0x1e')]?_0x60b314[_0x34b9('0x28')]:_0x59277d[_0x34b9('0x25')];if(!_0x48c6f4[_0x34b9('0x26')][_0x34b9('0x2a')](_0x34b9('0x2b'))){_0x60b314['limit']=qs[_0x34b9('0x11')](_0x48c6f4[_0x34b9('0x26')][_0x34b9('0x11')]);_0x60b314['offset']=qs[_0x34b9('0x13')](_0x48c6f4[_0x34b9('0x26')]['offset']);}_0x60b314[_0x34b9('0x2c')]=qs[_0x34b9('0x2d')](_0x48c6f4['query']['sort']);_0x60b314['where']=qs[_0x34b9('0x2e')](_[_0x34b9('0x2f')](_0x48c6f4[_0x34b9('0x26')],_0x59277d[_0x34b9('0x2e')]),_0x1e8d5e);var _0x1d083b=[];var _0x3fb92b=squel[_0x34b9('0x30')]()[_0x34b9('0x31')]('id')[_0x34b9('0x31')]('name')['field'](_0x34b9('0x32'))[_0x34b9('0x33')](_0x34b9('0x34'));var _0x3ae726=squel[_0x34b9('0x30')]()[_0x34b9('0x33')](_0x34b9('0x35'),'c')[_0x34b9('0x36')](_0x34b9('0x37'),'uc',_0x34b9('0x38'))['left_join'](_0x34b9('0x39'),'ct',_0x34b9('0x3a'))[_0x34b9('0x36')](_0x34b9('0x34'),'t',_0x34b9('0x3b'))[_0x34b9('0x3c')](_0x34b9('0x3d'));var _0xff8ce2=squel[_0x34b9('0x3e')]();var _0x5b2c27=[];var _0x425bb1=squel['expr']();var _0x32ae2d;if(_0x48c6f4[_0x34b9('0x26')][_0x34b9('0x3f')]){_0x32ae2d=as[_0x34b9('0x40')](_0x48c6f4['query'][_0x34b9('0x3f')]);var _0x3750fc=_0x32ae2d['sqlOperator'];for(var _0xc7b90=0x0;_0xc7b90<_0x32ae2d[_0x34b9('0x41')]['length'];_0xc7b90++){var _0x184c22=_0x32ae2d['conditions'][_0xc7b90];var _0xc5cc7a='c';var _0x2b0300=_(_0x1e8d5e)[_0x34b9('0x1d')]()['find'](function(_0xbecbab){return _0xbecbab===_0x184c22['field'];});if(_0x2b0300)_0x2b0300=_0x1e8d5e[_0x184c22['field']];if(!_0x2b0300){if(_0x184c22[_0x34b9('0x31')]==='Tag'){var _0x868362=_0x184c22[_0x34b9('0x42')][_0x34b9('0x43')](',')['map'](function(_0x201a41){return Number(_0x201a41);});_0x868362[_0x34b9('0x44')](function(_0x9c220a){_0x425bb1['or'](_0x34b9('0x45'),'%,'+_0x9c220a+',%');});_0x5b2c27=_[_0x34b9('0x46')](_0x5b2c27,_0x868362);}else if(_0x184c22[_0x34b9('0x31')]===_0x34b9('0x47')){_0xff8ce2[_0x34b9('0x48')](_0x34b9('0x49'),_0x184c22['value']);}}else{if(_0x184c22[_0x34b9('0x31')]===_0x34b9('0x4a')||_0x2b0300[_0x34b9('0x4b')]===_0x34b9('0x4c'))_0x184c22[_0x34b9('0x4d')]=_0x34b9('0x4e');var _0x51654e=as[_0x34b9('0x4f')](_0xc5cc7a,_0x2b0300[_0x34b9('0x24')],_0x184c22);_0xff8ce2[_0x3750fc](_0x51654e[_0x34b9('0x50')],_0x51654e[_0x34b9('0x42')]['start'],_0x51654e[_0x34b9('0x42')]['end']);}}}else{var _0x51af64=_(Object[_0x34b9('0x1d')](_0x48c6f4[_0x34b9('0x26')]))[_0x34b9('0x51')](function(_0xe6834e){return _0x1e8d5e[_0x34b9('0x2a')](_0xe6834e)?_0xe6834e:undefined;})[_0x34b9('0x52')](function(_0x2e13de){return!_[_0x34b9('0x53')](_0x2e13de);})[_0x34b9('0x42')]();if(_0x48c6f4[_0x34b9('0x26')]['Contact'])_0x51af64[_0x34b9('0x54')]('Contact');if(!_['isEmpty'](_0x51af64)){_0x51af64['forEach'](function(_0x171f1d){if(_0x171f1d==='ListId'){_0x3ae726[_0x34b9('0x3c')]('c.ListId\x20IN\x20?',[][_0x34b9('0x55')](_0x48c6f4['query'][_0x171f1d]));}else if(_0x171f1d==='Contact'){var _0x4e94b2='%'+_0x48c6f4[_0x34b9('0x26')][_0x171f1d]+'%';_0x3ae726['where'](_0x34b9('0x56'),_0x4e94b2);}else{_0x3ae726[_0x34b9('0x3c')]('c.'+_0x171f1d+_0x34b9('0x57'),_0x48c6f4[_0x34b9('0x26')][_0x171f1d]);}});}if(_0x48c6f4[_0x34b9('0x26')][_0x34b9('0x58')]){_0x5b2c27=_[_0x34b9('0x59')](_0x48c6f4[_0x34b9('0x26')][_0x34b9('0x58')])?_0x48c6f4[_0x34b9('0x26')][_0x34b9('0x58')]:new Array(_0x48c6f4[_0x34b9('0x26')][_0x34b9('0x58')]);_0x5b2c27[_0x34b9('0x44')](function(_0x12380d){_0x425bb1['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x12380d+',%');});}if(_0x48c6f4[_0x34b9('0x26')][_0x34b9('0x52')]){var _0x389222=_0x48c6f4[_0x34b9('0x26')][_0x34b9('0x52')]['replace']('\x5c','\x5c\x5c')[_0x34b9('0x5a')](/'/g,'\x27\x27');if(_0x389222[_0x34b9('0x43')]('\x20')[_0x34b9('0x1e')]>0x1){_0xff8ce2['or'](_0x34b9('0x5b'),qs['getFullTextValue'](_0x389222),null);}else{if(qs['isNumeric'](_0x389222)){_0xff8ce2['or'](_0x34b9('0x5c'),_0x389222+'%');_0xff8ce2['or'](_0x34b9('0x5d'),_0x389222+'%');_0xff8ce2['or'](_0x34b9('0x5e'),_0x389222+'%');_0xff8ce2['or'](_0x34b9('0x5f'),_0x389222+'%');}else if(qs[_0x34b9('0x60')](_0x389222)){_0xff8ce2['or']('c.email\x20LIKE\x20?',_0x389222+'%');}else{_0xff8ce2['or'](_0x34b9('0x61'),'%'+_0x389222+'%');_0xff8ce2['or'](_0x34b9('0x62'),'%'+_0x389222+'%');_0xff8ce2['or']('c.email\x20LIKE\x20?','%'+_0x389222+'%');}}}}_0x3ae726[_0x34b9('0x3c')](_0xff8ce2);_0x3ae726[_0x34b9('0x63')](_0x34b9('0x64'));var _0x6bf2ef={'type':db[_0x34b9('0x65')]['QueryTypes']['SELECT'],'raw':!![]};var _0x9cb257=_0x3ae726[_0x34b9('0x66')]()[_0x34b9('0x31')](_0x34b9('0x64'));if(_0x60b314[_0x34b9('0x2c')]){_0x60b314['order'][_0x34b9('0x44')](function(_0x23166f){_0x3ae726[_0x34b9('0x2c')]('c.'+_0x23166f[0x0],_0x23166f[0x1]==='DESC'?![]:!![]);});}if(!_[_0x34b9('0x67')](_0x5b2c27)){_0x3ae726[_0x34b9('0x68')](_0x425bb1);_0x9cb257[_0x34b9('0x3c')](_0x34b9('0x69'),_0x5b2c27);}BPromise[_0x34b9('0x6a')]()[_0x34b9('0x15')](function(){if(!_0x32ae2d)return;if(_0x48c6f4[_0x34b9('0x6b')][_0x34b9('0x6c')]!==_0x34b9('0x6d'))return;if(!_[_0x34b9('0x6e')](_0x32ae2d[_0x34b9('0x41')],[_0x34b9('0x31'),'User'])){return _0x48c6f4[_0x34b9('0x6b')][_0x34b9('0x6f')]({'attributes':['id'],'raw':!![]})['then'](function(_0x39809e){if(_['isEmpty'](_0x39809e)){_0x9cb257[_0x34b9('0x3c')]('c.ListId\x20IS\x20NULL');_0x3ae726[_0x34b9('0x3c')]('c.ListId\x20IS\x20NULL');}else{_0x9cb257[_0x34b9('0x3c')](_0x34b9('0x70'),_[_0x34b9('0x51')](_0x39809e,'id'));_0x3ae726[_0x34b9('0x3c')](_0x34b9('0x70'),_[_0x34b9('0x51')](_0x39809e,'id'));}});}})[_0x34b9('0x15')](function(){if(_0x48c6f4[_0x34b9('0x6b')][_0x34b9('0x6c')]==='agent'&&!_0x32ae2d&&!_0x48c6f4[_0x34b9('0x26')][_0x34b9('0x71')])return[];return db['sequelize'][_0x34b9('0x26')](_0x9cb257[_0x34b9('0x72')](),_0x6bf2ef);})[_0x34b9('0x15')](function(_0x42bd61){_0x3ac396['count']=_0x42bd61[_0x34b9('0x1e')];if(_0x3ac396[_0x34b9('0x12')]===0x0)return[];return db[_0x34b9('0x73')][_0x34b9('0x26')](_0x3fb92b['toString'](),_0x6bf2ef)['then'](function(_0x3baa78){_0x1d083b=_[_0x34b9('0x74')](_0x3baa78,'id');_0x6bf2ef=_[_0x34b9('0x75')](_0x6bf2ef,{'model':db['CmContact'],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x48c6f4[_0x34b9('0x26')][_0x34b9('0x29')]){_0x60b314[_0x34b9('0x28')][_0x34b9('0x44')](function(_0x3a4772){_0x3ae726[_0x34b9('0x31')]('c.'+_0x3a4772);});}else{_0x3ae726['field']('c.id');_0x3ae726[_0x34b9('0x31')](_0x34b9('0x76'));_0x3ae726[_0x34b9('0x31')](_0x34b9('0x77'));_0x3ae726[_0x34b9('0x31')](_0x34b9('0x78'));_0x3ae726[_0x34b9('0x31')](_0x34b9('0x79'));_0x3ae726['field'](_0x34b9('0x7a'));_0x3ae726[_0x34b9('0x31')](_0x34b9('0x7b'));_0x3ae726[_0x34b9('0x31')](_0x34b9('0x7c'));_0x3ae726[_0x34b9('0x31')](_0x34b9('0x7d'));_0x3ae726[_0x34b9('0x31')](_0x34b9('0x7e'));_0x3ae726[_0x34b9('0x31')](_0x34b9('0x7f'));_0x3ae726[_0x34b9('0x31')](_0x34b9('0x80'),_0x34b9('0x81'));}if(_0x60b314[_0x34b9('0x11')])_0x3ae726[_0x34b9('0x11')](_0x60b314['limit']);if(_0x60b314[_0x34b9('0x13')])_0x3ae726[_0x34b9('0x13')](_0x60b314['offset']);return db['sequelize'][_0x34b9('0x26')](_0x3ae726[_0x34b9('0x72')](),_0x6bf2ef);});})[_0x34b9('0x15')](function(_0x5ca9ad){_0x5ca9ad['forEach'](function(_0x675649){if(_0x675649[_0x34b9('0x81')]){_0x675649[_0x34b9('0x82')]=[];_0x675649[_0x34b9('0x81')]['split'](',')[_0x34b9('0x44')](function(_0x21583c){_0x675649['Tags'][_0x34b9('0x54')](_0x1d083b[_0x21583c]);});}delete _0x675649['TagIds'];});_0x3ac396[_0x34b9('0x83')]=_0x5ca9ad;return _0x3ac396;})[_0x34b9('0x15')](respondWithFilteredResult(_0x1ad8ef,_0x60b314));})[_0x34b9('0x84')](handleError(_0x1ad8ef,null));};exports[_0x34b9('0x85')]=function(_0x15da18,_0x5821f2){return db[_0x34b9('0x1b')][_0x34b9('0x86')]({'where':{'id':_0x15da18[_0x34b9('0x87')]['id']}})[_0x34b9('0x15')](handleEntityNotFound(_0x5821f2,null))[_0x34b9('0x15')](removeEntity(_0x5821f2,null))[_0x34b9('0x84')](handleError(_0x5821f2,null));};exports['describe']=function(_0x1457cb,_0x3b3d26){return db[_0x34b9('0x1b')][_0x34b9('0x1c')]()['then'](function(_0x155ecc){delete _0x155ecc[_0x34b9('0x88')];for(var _0x5b79d1=0x0;_0x5b79d1<Object['keys'](_0x155ecc)[_0x34b9('0x1e')];_0x5b79d1++){var _0x41ff71=Object[_0x34b9('0x1d')](_0x155ecc)[_0x5b79d1];if(!_[_0x34b9('0x1f')](_0x41ff71,_0x34b9('0x20'))){_0x155ecc[_0x41ff71]['columnName']=_0x41ff71;_0x155ecc[_0x41ff71][_0x34b9('0x89')]=_0x41ff71;}}return _0x155ecc;})['then'](function(_0x5523a2){var _0x327bdc={'where':Boolean(_0x1457cb[_0x34b9('0x26')][_0x34b9('0x8a')])===!![]?undefined:{'$or':[{'ListId':_0x1457cb[_0x34b9('0x26')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x34b9('0x21')]['findAll'](_0x327bdc)[_0x34b9('0x15')](function(_0x323c14){for(var _0x58ed57=0x0;_0x58ed57<_0x323c14[_0x34b9('0x1e')];_0x58ed57++){var _0x29c375=_0x34b9('0x20')+_0x323c14[_0x58ed57]['id'];_0x5523a2[_0x29c375][_0x34b9('0x8b')]=_0x29c375;_0x5523a2[_0x29c375][_0x34b9('0x89')]=_0x323c14[_0x58ed57][_0x34b9('0x8c')];_0x5523a2[_0x29c375][_0x34b9('0x8d')]={'type':_0x323c14[_0x58ed57][_0x34b9('0x24')],'values':_0x323c14[_0x58ed57]['values']};}Object[_0x34b9('0x1d')](_0x5523a2)[_0x34b9('0x44')](function(_0x53df54){if(!_0x5523a2[_0x53df54][_0x34b9('0x2a')](_0x34b9('0x8b'))){delete _0x5523a2[_0x53df54];}});return _0x5523a2;});})['then'](respondWithResult(_0x3b3d26,null))[_0x34b9('0x84')](handleError(_0x3b3d26,null));};exports['merge']=function(_0x4ac71f,_0x5d25d0){var _0x2fa8d2;var _0xe62025;var _0x2dd672;if(_0x4ac71f[_0x34b9('0x8e')]['id']){delete _0x4ac71f[_0x34b9('0x8e')]['id'];}return db[_0x34b9('0x1b')][_0x34b9('0x8f')]({'where':{'id':[_0x4ac71f['body']['to'],_0x4ac71f[_0x34b9('0x8e')][_0x34b9('0x33')]]}})[_0x34b9('0x15')](function(_0x517c4e){if(_0x517c4e){if(_0x517c4e['length']!==0x2){return null;}_0x517c4e[0x0]=_0x517c4e[0x0]['get']({'plain':!![]});_0x517c4e[0x1]=_0x517c4e[0x1][_0x34b9('0x90')]({'plain':!![]});delete _0x517c4e[0x0]['id'];delete _0x517c4e[0x1]['id'];return _[_0x34b9('0x91')](_0x517c4e[0x0],_0x517c4e[0x1],function(_0x232be9,_0x220a9e){if(Array[_0x34b9('0x59')](_0x220a9e)&&!_0x220a9e['length']){return _0x232be9;}else if(!_0x220a9e){return _0x232be9;}});}})['then'](handleEntityNotFound(_0x5d25d0,null))[_0x34b9('0x15')](function(_0x508ee3){if(_0x508ee3){if(_0x508ee3[_0x34b9('0x88')]&&_[_0x34b9('0x59')](_0x508ee3[_0x34b9('0x88')])){_0x508ee3[_0x34b9('0x88')]=_0x508ee3[_0x34b9('0x88')]['join']();}logger[_0x34b9('0x92')]('[CmContact][merge]\x20to\x20%s\x20from\x20%s',_0x4ac71f['body']['to'],_0x4ac71f[_0x34b9('0x8e')]['from']);return db[_0x34b9('0x93')]['destroy']({'where':{'ContactId':[_0x4ac71f[_0x34b9('0x8e')]['to'],_0x4ac71f[_0x34b9('0x8e')][_0x34b9('0x33')]]}})[_0x34b9('0x15')](function(_0x282562){logger[_0x34b9('0x92')](_0x34b9('0x94'),_0x282562);return db[_0x34b9('0x95')][_0x34b9('0x85')]({'where':{'ContactId':[_0x4ac71f[_0x34b9('0x8e')]['to'],_0x4ac71f[_0x34b9('0x8e')][_0x34b9('0x33')]]}})[_0x34b9('0x15')](function(_0x1cad63){logger[_0x34b9('0x92')](_0x34b9('0x96'),_0x1cad63);return db['CmContact'][_0x34b9('0x97')](_0x508ee3);});});}})[_0x34b9('0x15')](function(_0x58a5eb){if(_0x58a5eb){_0x2fa8d2=_0x58a5eb;_0xe62025={'ContactId':_0x2fa8d2['id']};_0x2dd672={'where':{'ContactId':[_0x4ac71f[_0x34b9('0x8e')]['to'],_0x4ac71f[_0x34b9('0x8e')]['from']]}};return db[_0x34b9('0x98')]['update'](_0xe62025,_0x2dd672);}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return db[_0x34b9('0x99')][_0x34b9('0x14')](_0xe62025,_0x2dd672);}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return db[_0x34b9('0x9a')][_0x34b9('0x14')](_0xe62025,_0x2dd672);}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return db[_0x34b9('0x9b')]['update'](_0xe62025,_0x2dd672);}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return db[_0x34b9('0x9c')][_0x34b9('0x14')](_0xe62025,_0x2dd672);}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return db[_0x34b9('0x9b')][_0x34b9('0x14')](_0xe62025,_0x2dd672);}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return db[_0x34b9('0x9c')]['update'](_0xe62025,_0x2dd672);}})['then'](function(){if(_0x2fa8d2){return db['SmsInteraction'][_0x34b9('0x14')](_0xe62025,_0x2dd672);}})['then'](function(){if(_0x2fa8d2){return db[_0x34b9('0x9d')][_0x34b9('0x14')](_0xe62025,_0x2dd672);}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return db[_0x34b9('0x9e')]['update'](_0xe62025,_0x2dd672);}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return db[_0x34b9('0x9f')][_0x34b9('0x14')](_0xe62025,_0x2dd672);}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return db[_0x34b9('0xa0')][_0x34b9('0x14')](_0xe62025,_0x2dd672);}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return db[_0x34b9('0xa1')][_0x34b9('0x14')](_0xe62025,_0x2dd672);}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return db[_0x34b9('0xa2')][_0x34b9('0x14')]({'CmContactId':_0x2fa8d2['id']},{'where':{'CmContactId':[_0x4ac71f[_0x34b9('0x8e')]['to'],_0x4ac71f[_0x34b9('0x8e')][_0x34b9('0x33')]]}});}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return db[_0x34b9('0xa3')][_0x34b9('0x14')](_0xe62025,_0x2dd672);}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return db[_0x34b9('0xa4')][_0x34b9('0x14')](_0xe62025,_0x2dd672);}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return db['ReportAgentPreview']['update'](_0xe62025,_0x2dd672);}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return db[_0x34b9('0xa5')][_0x34b9('0x14')](_0xe62025,_0x2dd672);}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return db[_0x34b9('0xa6')]['update'](_0xe62025,_0x2dd672);}})['then'](function(){if(_0x2fa8d2){return db['FaxQueueReport']['update'](_0xe62025,_0x2dd672);}})['then'](function(){if(_0x2fa8d2){return db[_0x34b9('0xa7')][_0x34b9('0x14')](_0xe62025,_0x2dd672);}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return db[_0x34b9('0xa8')][_0x34b9('0x14')](_0xe62025,_0x2dd672);}})['then'](function(){if(_0x2fa8d2){return db[_0x34b9('0xa9')]['update'](_0xe62025,_0x2dd672);}})['then'](function(){if(_0x2fa8d2){return db['JscriptySessionReport'][_0x34b9('0x14')](_0xe62025,_0x2dd672);}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return db[_0x34b9('0xaa')][_0x34b9('0x14')](_0xe62025,_0x2dd672);}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return db[_0x34b9('0xab')]['update'](_0xe62025,_0x2dd672);}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return db[_0x34b9('0xac')][_0x34b9('0x14')](_0xe62025,_0x2dd672);}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return db[_0x34b9('0x1b')]['destroy']({'where':{'id':[_0x4ac71f[_0x34b9('0x8e')]['to'],_0x4ac71f[_0x34b9('0x8e')][_0x34b9('0x33')]]}});}})[_0x34b9('0x15')](function(){if(_0x2fa8d2){return _0x2fa8d2;}})[_0x34b9('0x15')](respondWithResult(_0x5d25d0,null))[_0x34b9('0x84')](handleError(_0x5d25d0,null));};exports[_0x34b9('0x97')]=function(_0x1baf8e,_0x292e8a){return db[_0x34b9('0x1b')][_0x34b9('0x1c')]()[_0x34b9('0x15')](function(_0x4b4aa6){if(_0x1baf8e[_0x34b9('0x8e')][_0x34b9('0x88')]&&_[_0x34b9('0x59')](_0x1baf8e[_0x34b9('0x8e')][_0x34b9('0x88')])){if(_0x1baf8e['body']['tags'][_0x34b9('0x1e')]){_0x1baf8e[_0x34b9('0x8e')][_0x34b9('0x88')]=_0x1baf8e['body']['tags'][_0x34b9('0xad')](';')+';';}else{_0x1baf8e[_0x34b9('0x8e')][_0x34b9('0x88')]=null;}}else{_0x1baf8e[_0x34b9('0x8e')]['tags']=null;}if(!_[_0x34b9('0x53')](_0x1baf8e[_0x34b9('0x8e')]['dialTimezone'])){var _0x435529=_0x1baf8e[_0x34b9('0x8e')][_0x34b9('0xae')];if(!_[_0x34b9('0x53')](shared[_0x34b9('0xaf')][_0x435529]))_0x1baf8e[_0x34b9('0x8e')][_0x34b9('0xb0')]=shared[_0x34b9('0xaf')][_0x435529]['utcOffset'];}return db[_0x34b9('0x1b')]['create'](_0x1baf8e['body'],{'fields':_['keys'](_0x4b4aa6),'raw':!![]});})[_0x34b9('0x15')](function(_0x759629){if(_0x1baf8e[_0x34b9('0x8e')][_0x34b9('0xb1')]){return insertAdditionalPhones(_0x759629,_0x1baf8e[_0x34b9('0x8e')][_0x34b9('0xb1')]);}else{return _0x759629;}})[_0x34b9('0x15')](respondWithResult(_0x292e8a,0xc9))[_0x34b9('0x84')](handleError(_0x292e8a,null));};exports['bulkCreate']=function(_0x5ca7ec,_0x15f23c){var _0xaa0c3=0x0;var _0x2532eb=0x0;var _0x50215e=0x0;var _0x50a38a=[];return db[_0x34b9('0x1b')][_0x34b9('0x1c')]()[_0x34b9('0x15')](function(_0x3247c1){return BPromise['each'](_0x5ca7ec[_0x34b9('0x8e')],function(_0x14ff28){var _0x51d0ed={'where':{'$or':[]},'defaults':_0x14ff28,'fields':_[_0x34b9('0x1d')](_0x3247c1),'raw':!![]};if(_0x14ff28[_0x34b9('0xb2')]){for(var _0x3e0311=0x0;_0x3e0311<_0x14ff28['duplicates'][_0x34b9('0x1e')];_0x3e0311++){var _0x195d40={};_0x195d40[_0x14ff28[_0x34b9('0xb2')][_0x3e0311]]=_0x14ff28[_0x14ff28[_0x34b9('0xb2')][_0x3e0311]];_0x51d0ed[_0x34b9('0x3c')][_0x34b9('0xb3')][_0x34b9('0x54')](_0x195d40);}_0x51d0ed['where']['ListId']=_0x14ff28['ListId'];}return db[_0x34b9('0x1b')][_0x34b9('0xb4')](_0x51d0ed)[_0x34b9('0xb5')](function(_0x4da8d5,_0x351d2e){if(_0x351d2e){if(_0x14ff28['hasOwnProperty']('additionalPhones')){_0x50a38a[_0x34b9('0x54')]({'contact':_0x4da8d5,'additionalPhones':_0x14ff28[_0x34b9('0xb1')]});}_0xaa0c3++;}else{_0x50215e++;}})['catch'](function(){_0x2532eb++;});});})['then'](function(_0x5676f5){if(_0x5676f5){if(_0x50a38a[_0x34b9('0x1e')]>0x0){return new Promise(function(_0x31bbdf,_0x70bca2){var _0x51e51f=[];for(var _0x244dd5=0x0;_0x244dd5<_0x50a38a[_0x34b9('0x1e')];_0x244dd5++){_0x51e51f[_0x34b9('0x54')](insertAdditionalPhones(_0x50a38a[_0x244dd5]['contact'],_0x50a38a[_0x244dd5]['additionalPhones']));}Promise['all'](_0x51e51f)['then'](function(){_0x31bbdf(0x1);});})['then'](function(){return{'success':_0xaa0c3,'failure':_0x2532eb,'duplicates':_0x50215e};});}else{return{'success':_0xaa0c3,'failure':_0x2532eb,'duplicates':_0x50215e};}}})[_0x34b9('0x15')](respondWithResult(_0x15f23c,0xc9))[_0x34b9('0x84')](handleError(_0x15f23c,null));};exports[_0x34b9('0xb6')]=function(_0x5bf708,_0xa556db){var _0xe434e1;return db['CmContact'][_0x34b9('0x1c')]()['then'](function(_0x5c9a74){return db[_0x34b9('0x1b')][_0x34b9('0x86')]({'where':{'id':_0x5bf708[_0x34b9('0x87')]['id']},'include':[{'model':db[_0x34b9('0xb7')],'as':_0x34b9('0x82'),'attributes':['id',_0x34b9('0x19'),_0x34b9('0x32')],'required':_0x5bf708[_0x34b9('0x26')][_0x34b9('0x58')]?!![]:![]},{'model':db[_0x34b9('0xa2')],'as':_0x34b9('0xb8'),'where':{'CmContactId':_0x5bf708[_0x34b9('0x87')]['id']},'required':![],'include':[{'model':db[_0x34b9('0xb9')],'as':_0x34b9('0xba')}]}],'order':[db['sequelize'][_0x34b9('0xbb')](_0x34b9('0xbc'))],'attributes':_[_0x34b9('0x1d')](_0x5c9a74)});})[_0x34b9('0x15')](function(_0x4021aa){if(!_['isNil'](_0x4021aa)){_0xe434e1=_0x4021aa['get']({'plain':!![]});var _0x338a1b={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x4021aa&&_0x4021aa[_0x34b9('0x71')]){if(_0x4021aa[_0x34b9('0x71')]){_0x338a1b[_0x34b9('0x3c')][_0x34b9('0xbd')][_0x34b9('0x54')]({'ListId':{'$ne':_0x4021aa['ListId']}});}}return db[_0x34b9('0x21')][_0x34b9('0x8f')](_0x338a1b);}})[_0x34b9('0x15')](function(_0x126cce){if(!_[_0x34b9('0x53')](_0x126cce)){return _[_0x34b9('0xbe')](_0xe434e1,_['map'](_0x126cce,function(_0x4c3ff1){return util['format'](_0x34b9('0xbf'),_0x4c3ff1['id']);}));}})[_0x34b9('0x15')](handleEntityNotFound(_0xa556db,null))[_0x34b9('0x15')](respondWithResult(_0xa556db,null))[_0x34b9('0x84')](handleError(_0xa556db,null));};exports[_0x34b9('0x14')]=function(_0x5e9bb1,_0x4230ab){var _0x5d7dc4;if(_0x5e9bb1[_0x34b9('0x8e')]['id']){delete _0x5e9bb1[_0x34b9('0x8e')]['id'];}if(!_[_0x34b9('0x53')](_0x5e9bb1[_0x34b9('0x8e')][_0x34b9('0xae')])){var _0x456fff=_0x5e9bb1['body']['dialTimezone'];if(!_['isNil'](shared[_0x34b9('0xaf')][_0x456fff]))_0x5e9bb1['body']['utcOffset']=shared['timezones'][_0x456fff]['utcOffset'];}return db[_0x34b9('0x1b')][_0x34b9('0x86')]({'where':{'id':_0x5e9bb1['params']['id']}})[_0x34b9('0x15')](handleEntityNotFound(_0x4230ab,null))[_0x34b9('0x15')](saveUpdates(_0x5e9bb1[_0x34b9('0x8e')],null))['then'](function(_0x2442f1){_0x5d7dc4=_0x2442f1;var _0x591833={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x2442f1&&_0x2442f1['ListId']){if(_0x2442f1[_0x34b9('0x71')]){_0x591833[_0x34b9('0x3c')][_0x34b9('0xbd')][_0x34b9('0x54')]({'ListId':{'$ne':_0x2442f1[_0x34b9('0x71')]}});}}return db[_0x34b9('0x21')][_0x34b9('0x8f')](_0x591833);})[_0x34b9('0x15')](function(_0x47ebec){if(_0x47ebec){return _[_0x34b9('0xbe')](_[_0x34b9('0xc0')](_0x5e9bb1[_0x34b9('0x8e')],function(_0x636f28,_0x56d61a){return _[_0x34b9('0x1f')](_0x56d61a,_0x34b9('0x20'));}),_[_0x34b9('0x51')](_0x47ebec,function(_0x223261){return util[_0x34b9('0xc1')]('cf_%d',_0x223261['id']);}));}})[_0x34b9('0x15')](function(_0x78b5a5){if(_0x78b5a5&&!_['isEmpty'](_0x78b5a5)){var _0x432a2e=squel[_0x34b9('0x14')]()[_0x34b9('0xc2')](_0x34b9('0x35'))[_0x34b9('0xc3')](_0x78b5a5)[_0x34b9('0x3c')](_0x34b9('0xc4'),_0x5e9bb1['params']['id'])[_0x34b9('0xc5')]();return db['sequelize'][_0x34b9('0x26')](_0x432a2e[_0x34b9('0x50')],{'replacements':_0x432a2e[_0x34b9('0xc6')]});}})['then'](function(){if(_0x5e9bb1[_0x34b9('0x8e')][_0x34b9('0xc7')]&&_0x5d7dc4){return db[_0x34b9('0x93')][_0x34b9('0x14')]({'phone':_0x5e9bb1[_0x34b9('0x8e')][_0x34b9('0xc7')],'OrderBy':0x0},{'where':{'ContactId':_0x5d7dc4['id']}});}})[_0x34b9('0x15')](function(){return _0x5d7dc4;})[_0x34b9('0x15')](respondWithResult(_0x4230ab,null))[_0x34b9('0x84')](handleError(_0x4230ab,null));};exports[_0x34b9('0xc8')]=function(_0x2cf8c7,_0x466d98){var _0x62b1ca={};var _0x90e45e={};var _0x1ff31d;var _0x19420b;return db[_0x34b9('0x1b')][_0x34b9('0xc9')]({'where':{'id':_0x2cf8c7['params']['id']}})[_0x34b9('0x15')](handleEntityNotFound(_0x466d98,null))[_0x34b9('0x15')](function(_0x448181){if(_0x448181){_0x1ff31d=_0x448181;_0x90e45e[_0x34b9('0x25')]=_[_0x34b9('0x1d')](db[_0x34b9('0xb7')][_0x34b9('0xca')]);_0x90e45e['query']=_[_0x34b9('0x1d')](_0x2cf8c7[_0x34b9('0x26')]);_0x90e45e[_0x34b9('0x2e')]=_[_0x34b9('0x27')](_0x90e45e[_0x34b9('0x25')],_0x90e45e[_0x34b9('0x26')]);_0x62b1ca['attributes']=_[_0x34b9('0x27')](_0x90e45e['model'],qs[_0x34b9('0x29')](_0x2cf8c7[_0x34b9('0x26')][_0x34b9('0x29')]));_0x62b1ca[_0x34b9('0x28')]=_0x62b1ca[_0x34b9('0x28')][_0x34b9('0x1e')]?_0x62b1ca[_0x34b9('0x28')]:_0x90e45e[_0x34b9('0x25')];_0x62b1ca[_0x34b9('0x2c')]=qs[_0x34b9('0x2d')](_0x2cf8c7[_0x34b9('0x26')]['sort']);_0x62b1ca[_0x34b9('0x3c')]=qs[_0x34b9('0x2e')](_[_0x34b9('0x2f')](_0x2cf8c7[_0x34b9('0x26')],_0x90e45e[_0x34b9('0x2e')]));if(_0x2cf8c7[_0x34b9('0x26')][_0x34b9('0x52')]){_0x62b1ca[_0x34b9('0x3c')]=_['merge'](_0x62b1ca[_0x34b9('0x3c')],{'$or':_[_0x34b9('0x51')](_0x62b1ca[_0x34b9('0x28')],function(_0x272ba7){var _0x27012a={};_0x27012a[_0x272ba7]={'$like':'%'+_0x2cf8c7['query'][_0x34b9('0x52')]+'%'};return _0x27012a;})});}_0x62b1ca=_[_0x34b9('0x75')]({},_0x62b1ca,_0x2cf8c7['options']);return _0x1ff31d['getTags'](_0x62b1ca);}})[_0x34b9('0x15')](function(_0xec8267){if(_0xec8267){_0x19420b=_0xec8267['length'];if(!_0x2cf8c7[_0x34b9('0x26')]['hasOwnProperty']('nolimit')){_0x62b1ca[_0x34b9('0x11')]=qs['limit'](_0x2cf8c7[_0x34b9('0x26')][_0x34b9('0x11')]);_0x62b1ca[_0x34b9('0x13')]=qs[_0x34b9('0x13')](_0x2cf8c7[_0x34b9('0x26')]['offset']);}return _0x1ff31d[_0x34b9('0xc8')](_0x62b1ca);}})['then'](function(_0x500df2){if(_0x500df2){return _0x500df2?{'count':_0x19420b,'rows':_0x500df2}:null;}})['then'](respondWithResult(_0x466d98,null))['catch'](handleError(_0x466d98,null));};exports[_0x34b9('0xcb')]=function(_0x3c6a62,_0x2ed596){if(_0x3c6a62['body']['id']){delete _0x3c6a62[_0x34b9('0x8e')]['id'];}return db['CmContact'][_0x34b9('0xc9')]({'where':{'id':_0x3c6a62['params']['id']}})[_0x34b9('0x15')](handleEntityNotFound(_0x2ed596,null))[_0x34b9('0x15')](function(_0x259d81){if(_0x259d81){return _0x259d81['setTags'](_0x3c6a62[_0x34b9('0x8e')][_0x34b9('0xcc')]||[]);}return null;})[_0x34b9('0x15')](respondWithResult(_0x2ed596,null))[_0x34b9('0x84')](handleError(_0x2ed596,null));};exports[_0x34b9('0xcd')]=function(_0xe4abed,_0x6d855c){var _0x5d199b=[];_0x5d199b['push'](addAdditionalPhones(_0xe4abed[_0x34b9('0x8e')]));Promise[_0x34b9('0x23')](_0x5d199b)[_0x34b9('0x15')](function(){_0x5d199b=[];_0x5d199b['push'](deleteCmHopperPhones(_0xe4abed[_0x34b9('0x8e')]['id']));_0x5d199b['push'](addCmHopperPhones(_0xe4abed[_0x34b9('0x8e')]['id']));Promise[_0x34b9('0x23')](_0x5d199b)[_0x34b9('0x15')](function(){return[0x1];})['then'](respondWithResult(_0x6d855c,null));});};function addAdditionalPhones(_0x5255df){var _0x2e2b9b;return new Promise(function(_0x62c39b,_0x50ec99){return db[_0x34b9('0xa2')][_0x34b9('0x85')]({'where':{'CmContactId':_0x5255df['id']}})[_0x34b9('0x15')](function(){db['ContactItemType'][_0x34b9('0x8f')]({'raw':!![],'attributes':['id','OrderBy']})[_0x34b9('0x15')](function(_0x493b9f){var _0x8dc204=[];for(var _0xa10bce=0x0;_0xa10bce<_0x5255df['items']['length'];_0xa10bce++){var _0x593612=_0x5255df[_0x34b9('0xce')]?_[_0x34b9('0x53')](_0x5255df[_0x34b9('0xce')][_0xa10bce])?'':_0x5255df[_0x34b9('0xce')][_0xa10bce]:_0x5255df[_0x34b9('0xcf')][_0xa10bce]['ItemTypeId']?_0x5255df[_0x34b9('0xcf')][_0xa10bce]['ItemTypeId']:'';var _0x1d55a1=_[_0x34b9('0x53')](_0x5255df[_0x34b9('0xcf')][_0xa10bce][_0x34b9('0xd0')])?'':_0x5255df[_0x34b9('0xcf')][_0xa10bce][_0x34b9('0xd0')];var _0x2cd2a5=_0x593612+':'+_0x5255df[_0x34b9('0xcf')][_0xa10bce][_0x34b9('0xc7')]+'§'+_0x1d55a1;if(_[_0x34b9('0x53')](_0x2e2b9b))_0x2e2b9b=_0x2cd2a5;else _0x2e2b9b+=';'+_0x2cd2a5;var _0x2b0425=null;if(_0x5255df['item_types']){if(!_['isNil'](_0x5255df[_0x34b9('0xce')][_0xa10bce])){var _0x552275=_[_0x34b9('0x86')](_0x493b9f,function(_0x8f90a6){return _0x8f90a6['id']===_0x5255df['item_types'][_0xa10bce];});if(!_[_0x34b9('0x53')](_0x552275)){_0x2b0425=_0x552275[_0x34b9('0xd1')];}}}else{if(!_[_0x34b9('0x53')](_0x5255df[_0x34b9('0xcf')][_0xa10bce])){var _0x552275=_['find'](_0x493b9f,function(_0xae6d3e){return _0xae6d3e['id']===_0x5255df[_0x34b9('0xcf')][_0xa10bce][_0x34b9('0xd2')];});if(!_[_0x34b9('0x53')](_0x552275)){_0x2b0425=_0xa10bce;}}}if(_[_0x34b9('0x53')](_0x2b0425)){_0x2b0425=0x64;}_0x8dc204[_0x34b9('0x54')](addAdditionalPhone(_0x5255df['id'],_0x5255df[_0x34b9('0xcf')][_0xa10bce]['phone'],_0x5255df[_0x34b9('0xce')]?_[_0x34b9('0x53')](_0x5255df[_0x34b9('0xce')][_0xa10bce])?null:_0x5255df[_0x34b9('0xce')][_0xa10bce]:_0x5255df[_0x34b9('0xcf')][_0xa10bce][_0x34b9('0xd2')]?_0x5255df[_0x34b9('0xcf')][_0xa10bce]['ItemTypeId']:null,_0x2b0425,_0x1d55a1));}Promise[_0x34b9('0x23')](_0x8dc204)[_0x34b9('0x15')](function(){db[_0x34b9('0x1b')][_0x34b9('0x14')]({'AdditionalPhones':_0x2e2b9b},{'where':{'id':_0x5255df['id']}})[_0x34b9('0x15')](function(){_0x62c39b(0x1);});});});});});}function addAdditionalPhone(_0x5c6d15,_0x493756,_0x4ea5b2,_0x22332b,_0x5df8b2){return db['CmContactHasItem'][_0x34b9('0x86')]({'where':{'CmContactId':_0x5c6d15,'item':_0x493756}})[_0x34b9('0x15')](function(_0x3bfc69){if(_0x3bfc69)logger[_0x34b9('0x92')]('contact\x20phone\x20exists',_0x3bfc69);else{db[_0x34b9('0xa2')]['create']({'CmContactId':_0x5c6d15,'item':_0x493756,'ItemTypeId':_0x4ea5b2,'OrderBy':_0x22332b,'ItemClass':_0x34b9('0xd3'),'description':_0x5df8b2});}});}function deletePhones(_0x5328d2){return db[_0x34b9('0xa2')][_0x34b9('0x85')]({'where':{'CmContactId':_0x5328d2}});}function deleteCmHopperPhones(_0x478596){return new Promise(function(_0x3518ab,_0x3ed4a0){return db[_0x34b9('0x93')][_0x34b9('0x8f')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x478596}})[_0x34b9('0x15')](function(_0x2a67e5){db[_0x34b9('0xd4')]['destroy']({'where':{'CmHopperId':{'$in':_[_0x34b9('0x51')](_0x2a67e5,'id')}}});})['then'](function(){_0x3518ab(0x1);});});}function addCmHopperPhones(_0x5a40f2){return new Promise(function(_0xe7de6a,_0x3250dd){return db['CmHopper'][_0x34b9('0x8f')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x5a40f2}})[_0x34b9('0x15')](function(_0x19a04b){var _0x10f416=[];_[_0x34b9('0x51')](_0x19a04b,function(_0x31a745){_0x10f416[_0x34b9('0x54')](createCmHopperPhone(_0x5a40f2,_0x31a745['id']));});Promise['all'](_0x10f416)[_0x34b9('0x15')](function(){_0xe7de6a(0x1);});});});}function createCmHopperPhone(_0x2791d9,_0x2f45f0){return new Promise(function(_0x33068a,_0x3244f3){db[_0x34b9('0xa2')]['findAll']({'raw':!![],'attributes':['item','OrderBy'],'where':{'CmContactId':_0x2791d9,'ItemClass':_0x34b9('0xd3')},'include':[{'model':db[_0x34b9('0xb9')],'attributes':['OrderBy'],'as':'ItemType'}],'order':[_0x34b9('0xd1'),db[_0x34b9('0x73')]['literal'](_0x34b9('0xd5'))]})[_0x34b9('0x15')](function(_0x56ace0){var _0x21e8de=0x1;var _0x187a1d=_['map'](_0x56ace0,function(_0x4c909b){_0x4c909b[_0x34b9('0xd6')]=_0x2f45f0;_0x4c909b[_0x34b9('0xc7')]=_0x4c909b[_0x34b9('0xd7')];_0x4c909b[_0x34b9('0xd1')]=_0x21e8de;delete _0x4c909b[_0x34b9('0xd8')];_0x21e8de=_0x21e8de+0x1;return _0x4c909b;});return db['CmHopperAdditionalPhone'][_0x34b9('0xd9')](_0x187a1d,{});})['then'](function(){_0x33068a(0x1);});});}function insertAdditionalPhones(_0x371f0b,_0x30c3dc){return new Promise(function(_0x3efbd8,_0x40a9b2){var _0xbb91fa=[];for(var _0x1ab31a=0x0;_0x1ab31a<_0x30c3dc[_0x34b9('0x1e')];_0x1ab31a++){var _0x372047=_0x30c3dc[_0x1ab31a];_0xbb91fa[_0x34b9('0x54')](parseContactItemType(_0x372047));}Promise[_0x34b9('0x23')](_0xbb91fa)[_0x34b9('0x15')](function(){var _0x33479f={'id':_0x371f0b['id'],'items':_0x30c3dc};return addAdditionalPhones(_0x33479f)[_0x34b9('0x15')](function(_0x4de7d7){return addCmHopperPhones(_0x371f0b['id']);});})['then'](function(){_0x3efbd8(_0x371f0b);});});}function parseContactItemType(_0xb737a1){return new Promise(function(_0x527f3a,_0x17f076){if(_0xb737a1[_0x34b9('0x2a')](_0x34b9('0xd2'))){_0x527f3a(_0xb737a1);}else{return db[_0x34b9('0xb9')]['find']({'where':{'name':_0xb737a1[_0x34b9('0xba')]}})[_0x34b9('0x15')](function(_0x5be7d5){if(_[_0x34b9('0x53')](_0x5be7d5))_0xb737a1['ItemTypeId']=null;else _0xb737a1[_0x34b9('0xd2')]=_0x5be7d5['id'];_0x527f3a(_0xb737a1);});}});}exports[_0x34b9('0xda')]=function(_0x5ba0be,_0x14a671){return db[_0x34b9('0xa2')]['findAll']({'raw':!![],'where':{'CmContactId':_0x5ba0be[_0x34b9('0x87')]['id'],'ItemClass':_0x34b9('0xd3')},'include':[{'model':db[_0x34b9('0xb9')],'as':_0x34b9('0xba')}],'order':[['OrderBy'],[db[_0x34b9('0x73')][_0x34b9('0xbb')]('`ItemType`.OrderBy')]]})[_0x34b9('0x15')](function(_0x5137f2){return _0x5137f2;})[_0x34b9('0x15')](respondWithResult(_0x14a671,null))[_0x34b9('0x84')](handleError(_0x14a671,null));};exports['duplicateAdditionalPhones']=function(_0x1eb0ce,_0x50a70b){return db['CmContactHasItem'][_0x34b9('0x8f')]({'raw':!![],'where':{'CmContactId':_0x1eb0ce[_0x34b9('0x8e')][_0x34b9('0xdb')]}})[_0x34b9('0x15')](function(_0xc15656){var _0x51d948=_[_0x34b9('0x51')](_0xc15656,function(_0x574779){_0x574779[_0x34b9('0xdc')]=_0x1eb0ce[_0x34b9('0x8e')][_0x34b9('0xdd')];return _0x574779;});return db[_0x34b9('0xa2')]['bulkCreate'](_0x51d948,{});})[_0x34b9('0x15')](function(_0x5dfd3d){return addCmHopperPhones(_0x1eb0ce[_0x34b9('0x8e')][_0x34b9('0xdd')]);})[_0x34b9('0x15')](function(_0x5bc856){return['ok'];})[_0x34b9('0x15')](respondWithResult(_0x50a70b,null))[_0x34b9('0x84')](handleError(_0x50a70b,null));};exports[_0x34b9('0xde')]=function(_0x931e59,_0x4f76e2){var _0x5b3d16=[];_0x5b3d16['push'](createCmHopperPhone(_0x931e59[_0x34b9('0x8e')]['id'],_0x931e59['body']['hopperId']));Promise[_0x34b9('0x23')](_0x5b3d16)[_0x34b9('0x15')](function(){return[0x1];})[_0x34b9('0x15')](respondWithResult(_0x4f76e2,null));};exports[_0x34b9('0xdf')]=function(_0x45284e,_0x330369){var _0x4eaba9={'raw':![],'where':{}};var _0xb6175a={};var _0x3b461d={'count':0x0,'rows':[]};return db[_0x34b9('0x1b')][_0x34b9('0xc9')]({'where':{'id':_0x45284e[_0x34b9('0x87')]['id']}})[_0x34b9('0x15')](handleEntityNotFound(_0x330369,null))[_0x34b9('0x15')](function(_0x234307){if(_0x234307){_0xb6175a[_0x34b9('0x25')]=_['keys'](db[_0x34b9('0x93')][_0x34b9('0xca')]);_0xb6175a['query']=_['keys'](_0x45284e[_0x34b9('0x26')]);_0xb6175a['filters']=_['intersection'](_0xb6175a['model'],_0xb6175a[_0x34b9('0x26')]);_0x4eaba9['attributes']=_['intersection'](_0xb6175a[_0x34b9('0x25')],qs[_0x34b9('0x29')](_0x45284e['query'][_0x34b9('0x29')]));_0x4eaba9[_0x34b9('0x28')]=_0x4eaba9[_0x34b9('0x28')][_0x34b9('0x1e')]?_0x4eaba9[_0x34b9('0x28')]:_0xb6175a['model'];if(!_0x45284e['query'][_0x34b9('0x2a')]('nolimit')){_0x4eaba9[_0x34b9('0x11')]=qs[_0x34b9('0x11')](_0x45284e[_0x34b9('0x26')][_0x34b9('0x11')]);_0x4eaba9[_0x34b9('0x13')]=qs['offset'](_0x45284e[_0x34b9('0x26')][_0x34b9('0x13')]);}_0x4eaba9[_0x34b9('0x2c')]=qs['sort'](_0x45284e[_0x34b9('0x26')][_0x34b9('0x2d')]);_0x4eaba9['where']=qs[_0x34b9('0x2e')](_[_0x34b9('0x2f')](_0x45284e['query'],_0xb6175a['filters']));_0x4eaba9[_0x34b9('0x3c')]['ContactId']=_0x234307['id'];if(_0x45284e['query'][_0x34b9('0x52')]){_0x4eaba9[_0x34b9('0x3c')]=_[_0x34b9('0x75')](_0x4eaba9['where'],{'$or':_[_0x34b9('0x51')](_0x4eaba9[_0x34b9('0x28')],function(_0x2e46fa){var _0xaf47a={};_0xaf47a[_0x2e46fa]={'$like':'%'+_0x45284e[_0x34b9('0x26')][_0x34b9('0x52')]+'%'};return _0xaf47a;})});}_0x4eaba9=_[_0x34b9('0x75')]({},_0x4eaba9,_0x45284e[_0x34b9('0xe0')]);return db['CmHopper'][_0x34b9('0x12')]({'where':_0x4eaba9['where']})[_0x34b9('0x15')](function(_0x2e6ce7){_0x3b461d[_0x34b9('0x12')]=_0x2e6ce7;if(_0x45284e[_0x34b9('0x26')]['includeAll']){_0x4eaba9[_0x34b9('0xe1')]=[{'all':!![]}];}return db[_0x34b9('0x93')][_0x34b9('0x8f')](_0x4eaba9);})[_0x34b9('0x15')](function(_0x16fe34){_0x3b461d[_0x34b9('0x83')]=_0x16fe34;return _0x3b461d;});}})[_0x34b9('0x15')](respondWithFilteredResult(_0x330369,_0x4eaba9))[_0x34b9('0x84')](handleError(_0x330369,null));};exports['getHopperHistories']=function(_0x3c9e4f,_0x23afd9){var _0x392c45={'raw':!![],'where':{}};var _0x28434b={};var _0x2b8a3b={'count':0x0,'rows':[]};return db[_0x34b9('0x1b')][_0x34b9('0xc9')]({'where':{'id':_0x3c9e4f[_0x34b9('0x87')]['id']}})[_0x34b9('0x15')](handleEntityNotFound(_0x23afd9,null))[_0x34b9('0x15')](function(_0x2dfb74){if(_0x2dfb74){_0x28434b[_0x34b9('0x25')]=_[_0x34b9('0x1d')](db[_0x34b9('0xa4')][_0x34b9('0xca')]);_0x28434b[_0x34b9('0x26')]=_['keys'](_0x3c9e4f[_0x34b9('0x26')]);_0x28434b['filters']=_[_0x34b9('0x27')](_0x28434b[_0x34b9('0x25')],_0x28434b[_0x34b9('0x26')]);_0x392c45[_0x34b9('0x28')]=_[_0x34b9('0x27')](_0x28434b[_0x34b9('0x25')],qs[_0x34b9('0x29')](_0x3c9e4f[_0x34b9('0x26')][_0x34b9('0x29')]));_0x392c45[_0x34b9('0x28')]=_0x392c45[_0x34b9('0x28')][_0x34b9('0x1e')]?_0x392c45['attributes']:_0x28434b[_0x34b9('0x25')];if(!_0x3c9e4f[_0x34b9('0x26')][_0x34b9('0x2a')](_0x34b9('0x2b'))){_0x392c45['limit']=qs[_0x34b9('0x11')](_0x3c9e4f[_0x34b9('0x26')][_0x34b9('0x11')]);_0x392c45['offset']=qs[_0x34b9('0x13')](_0x3c9e4f[_0x34b9('0x26')]['offset']);}_0x392c45[_0x34b9('0x2c')]=qs[_0x34b9('0x2d')](_0x3c9e4f[_0x34b9('0x26')][_0x34b9('0x2d')]);_0x392c45[_0x34b9('0x3c')]=qs[_0x34b9('0x2e')](_[_0x34b9('0x2f')](_0x3c9e4f[_0x34b9('0x26')],_0x28434b['filters']));_0x392c45['where']['ContactId']=_0x2dfb74['id'];if(_0x3c9e4f['query'][_0x34b9('0x52')]){_0x392c45[_0x34b9('0x3c')]=_[_0x34b9('0x75')](_0x392c45['where'],{'$or':_[_0x34b9('0x51')](_0x392c45['attributes'],function(_0x1a2b2c){var _0x5b9ba8={};_0x5b9ba8[_0x1a2b2c]={'$like':'%'+_0x3c9e4f[_0x34b9('0x26')][_0x34b9('0x52')]+'%'};return _0x5b9ba8;})});}_0x392c45=_[_0x34b9('0x75')]({},_0x392c45,_0x3c9e4f[_0x34b9('0xe0')]);return db['CmHopperHistory'][_0x34b9('0x12')]({'where':_0x392c45[_0x34b9('0x3c')]})[_0x34b9('0x15')](function(_0x3b8dc2){_0x2b8a3b['count']=_0x3b8dc2;if(_0x3c9e4f[_0x34b9('0x26')][_0x34b9('0xe2')]){_0x392c45[_0x34b9('0xe1')]=[{'all':!![]}];}return db[_0x34b9('0xa4')][_0x34b9('0x8f')](_0x392c45);})[_0x34b9('0x15')](function(_0x5f5b41){_0x2b8a3b[_0x34b9('0x83')]=_0x5f5b41;return _0x2b8a3b;});}})[_0x34b9('0x15')](respondWithFilteredResult(_0x23afd9,_0x392c45))['catch'](handleError(_0x23afd9,null));};exports[_0x34b9('0xe3')]=function(_0x1e40cb,_0x8c8cc2){var _0x2fcacf={'raw':!![],'where':{}};var _0x3d56d9={};var _0x15b733={'count':0x0,'rows':[]};return db[_0x34b9('0x1b')]['findOne']({'where':{'id':_0x1e40cb[_0x34b9('0x87')]['id']}})[_0x34b9('0x15')](handleEntityNotFound(_0x8c8cc2,null))[_0x34b9('0x15')](function(_0x1a6783){if(_0x1a6783){_0x3d56d9[_0x34b9('0x25')]=_[_0x34b9('0x1d')](db[_0x34b9('0xa3')][_0x34b9('0xca')]);_0x3d56d9['query']=_[_0x34b9('0x1d')](_0x1e40cb['query']);_0x3d56d9['filters']=_[_0x34b9('0x27')](_0x3d56d9[_0x34b9('0x25')],_0x3d56d9[_0x34b9('0x26')]);_0x2fcacf['attributes']=_['intersection'](_0x3d56d9[_0x34b9('0x25')],qs[_0x34b9('0x29')](_0x1e40cb[_0x34b9('0x26')][_0x34b9('0x29')]));_0x2fcacf[_0x34b9('0x28')]=_0x2fcacf[_0x34b9('0x28')][_0x34b9('0x1e')]?_0x2fcacf[_0x34b9('0x28')]:_0x3d56d9['model'];if(!_0x1e40cb[_0x34b9('0x26')]['hasOwnProperty']('nolimit')){_0x2fcacf['limit']=qs[_0x34b9('0x11')](_0x1e40cb['query'][_0x34b9('0x11')]);_0x2fcacf[_0x34b9('0x13')]=qs[_0x34b9('0x13')](_0x1e40cb[_0x34b9('0x26')]['offset']);}_0x2fcacf[_0x34b9('0x2c')]=qs[_0x34b9('0x2d')](_0x1e40cb[_0x34b9('0x26')][_0x34b9('0x2d')]);_0x2fcacf[_0x34b9('0x3c')]=qs['filters'](_['pick'](_0x1e40cb[_0x34b9('0x26')],_0x3d56d9[_0x34b9('0x2e')]));_0x2fcacf[_0x34b9('0x3c')][_0x34b9('0xe4')]=_0x1a6783['id'];if(_0x1e40cb[_0x34b9('0x26')][_0x34b9('0x52')]){_0x2fcacf['where']=_[_0x34b9('0x75')](_0x2fcacf[_0x34b9('0x3c')],{'$or':_[_0x34b9('0x51')](_0x2fcacf[_0x34b9('0x28')],function(_0x5258bb){var _0x42bbce={};_0x42bbce[_0x5258bb]={'$like':'%'+_0x1e40cb['query'][_0x34b9('0x52')]+'%'};return _0x42bbce;})});}_0x2fcacf=_[_0x34b9('0x75')]({},_0x2fcacf,_0x1e40cb[_0x34b9('0xe0')]);return db[_0x34b9('0xa3')][_0x34b9('0x12')]({'where':_0x2fcacf[_0x34b9('0x3c')]})['then'](function(_0xfe5009){_0x15b733[_0x34b9('0x12')]=_0xfe5009;if(_0x1e40cb[_0x34b9('0x26')][_0x34b9('0xe2')]){_0x2fcacf['include']=[{'all':!![]}];}return db['CmHopperFinal'][_0x34b9('0x8f')](_0x2fcacf);})[_0x34b9('0x15')](function(_0x25434e){_0x15b733[_0x34b9('0x83')]=_0x25434e;return _0x15b733;});}})[_0x34b9('0x15')](respondWithFilteredResult(_0x8c8cc2,_0x2fcacf))[_0x34b9('0x84')](handleError(_0x8c8cc2,null));};exports[_0x34b9('0xe5')]=function(_0x1a8dbd,_0x1b5278){var _0x441286={'raw':!![],'where':{}};var _0x364926={};var _0x1bbb5a={'count':0x0,'rows':[]};return db[_0x34b9('0x1b')][_0x34b9('0xc9')]({'where':{'id':_0x1a8dbd[_0x34b9('0x87')]['id']}})[_0x34b9('0x15')](handleEntityNotFound(_0x1b5278,null))[_0x34b9('0x15')](function(_0x6a6726){if(_0x6a6726){_0x364926[_0x34b9('0x25')]=_[_0x34b9('0x1d')](db[_0x34b9('0xe6')][_0x34b9('0xca')]);_0x364926[_0x34b9('0x26')]=_[_0x34b9('0x1d')](_0x1a8dbd[_0x34b9('0x26')]);_0x364926[_0x34b9('0x2e')]=_[_0x34b9('0x27')](_0x364926['model'],_0x364926[_0x34b9('0x26')]);_0x441286[_0x34b9('0x28')]=_[_0x34b9('0x27')](_0x364926['model'],qs[_0x34b9('0x29')](_0x1a8dbd[_0x34b9('0x26')]['fields']));_0x441286['attributes']=_0x441286[_0x34b9('0x28')][_0x34b9('0x1e')]?_0x441286['attributes']:_0x364926['model'];if(!_0x1a8dbd['query'][_0x34b9('0x2a')]('nolimit')){_0x441286[_0x34b9('0x11')]=qs[_0x34b9('0x11')](_0x1a8dbd[_0x34b9('0x26')]['limit']);_0x441286[_0x34b9('0x13')]=qs[_0x34b9('0x13')](_0x1a8dbd[_0x34b9('0x26')][_0x34b9('0x13')]);}_0x441286[_0x34b9('0x2c')]=qs[_0x34b9('0x2d')](_0x1a8dbd[_0x34b9('0x26')][_0x34b9('0x2d')]);_0x441286[_0x34b9('0x3c')]=qs[_0x34b9('0x2e')](_['pick'](_0x1a8dbd[_0x34b9('0x26')],_0x364926[_0x34b9('0x2e')]));_0x441286[_0x34b9('0x3c')][_0x34b9('0xe4')]=_0x6a6726['id'];if(_0x1a8dbd[_0x34b9('0x26')][_0x34b9('0x52')]){_0x441286['where']=_[_0x34b9('0x75')](_0x441286[_0x34b9('0x3c')],{'$or':_[_0x34b9('0x51')](_0x441286[_0x34b9('0x28')],function(_0x21cdfe){var _0x20b72f={};_0x20b72f[_0x21cdfe]={'$like':'%'+_0x1a8dbd[_0x34b9('0x26')][_0x34b9('0x52')]+'%'};return _0x20b72f;})});}_0x441286=_[_0x34b9('0x75')]({},_0x441286,_0x1a8dbd[_0x34b9('0xe0')]);return db[_0x34b9('0xe6')][_0x34b9('0x12')]({'where':_0x441286[_0x34b9('0x3c')]})[_0x34b9('0x15')](function(_0x221b46){_0x1bbb5a[_0x34b9('0x12')]=_0x221b46;if(_0x1a8dbd['query']['includeAll']){_0x441286[_0x34b9('0xe1')]=[{'all':!![]}];}return db[_0x34b9('0xe6')][_0x34b9('0x8f')](_0x441286);})[_0x34b9('0x15')](function(_0x232a2d){_0x1bbb5a[_0x34b9('0x83')]=_0x232a2d;return _0x1bbb5a;});}})['then'](respondWithFilteredResult(_0x1b5278,_0x441286))[_0x34b9('0x84')](handleError(_0x1b5278,null));};exports[_0x34b9('0xe7')]=function(_0x4f34a6,_0x567d02){try{if(!_0x4f34a6['body']['ListId']){throw new Error(_0x34b9('0xe8'));}if(!_0x4f34a6[_0x34b9('0x8e')][_0x34b9('0xe9')]){throw new Error(_0x34b9('0xea'));}if(!_0x4f34a6[_0x34b9('0x8e')][_0x34b9('0xeb')]){throw new Error(_0x34b9('0xec'));}if(!_0x4f34a6[_0x34b9('0x8e')][_0x34b9('0xed')]){throw new Error(_0x34b9('0xee'));}var _0x21c89f=_0x4f34a6[_0x34b9('0x8e')][_0x34b9('0xe9')][_0x34b9('0x43')](',');var _0x1d566d=_0x4f34a6[_0x34b9('0x8e')][_0x34b9('0xeb')][_0x34b9('0x43')](',');if(!_0x21c89f[_0x34b9('0x1e')]||!_0x1d566d[_0x34b9('0x1e')]||_0x21c89f[_0x34b9('0x1e')]!==_0x1d566d[_0x34b9('0x1e')]){throw new Error('Incorrect\x20binding\x20parameters\x20passed!');}_0x4f34a6[_0x34b9('0x8e')][_0x34b9('0x29')]=_[_0x34b9('0xef')](_0x21c89f,_0x1d566d);if(!_0x4f34a6[_0x34b9('0x8e')]['fields']['phone']){throw new Error(_0x34b9('0xf0'));}if(!_0x4f34a6['body'][_0x34b9('0x29')][_0x34b9('0xf1')]){throw new Error(_0x34b9('0xf2'));}var _0x4980ec=path[_0x34b9('0xad')](config[_0x34b9('0xf3')],'server/files/tmp',_0x4f34a6[_0x34b9('0xf4')][_0x34b9('0xf5')]);fs[_0x34b9('0xf6')](_0x4980ec,parseInt(_0x34b9('0xf7'),0x8));var _0x1f689e=require(_0x34b9('0xf8'))[_0x34b9('0xf9')](path[_0x34b9('0xad')](__dirname,'../../components/import/cm/csv'),[_0x4980ec,_0x4f34a6[_0x34b9('0x8e')][_0x34b9('0xe9')],_0x4f34a6['body']['binding_values'],_0x4f34a6[_0x34b9('0x8e')][_0x34b9('0x71')],_0x4f34a6[_0x34b9('0x8e')][_0x34b9('0xfa')],_0x4f34a6[_0x34b9('0x8e')][_0x34b9('0xb2')],_0x4f34a6[_0x34b9('0x8e')][_0x34b9('0xed')]]);return _0x567d02[_0x34b9('0xe')](0xc8)[_0x34b9('0xf')]({'message':'File\x20uploaded\x20correctly!','pid':_0x1f689e[_0x34b9('0xfb')]});}catch(_0x2100c7){return _0x567d02[_0x34b9('0xe')](0x1f4)[_0x34b9('0xfc')](_0x2100c7);}};exports[_0x34b9('0xfd')]=function(_0x23153c,_0x49d250){var _0x4af143=fs['createReadStream'](_0x23153c[_0x34b9('0xf4')][_0x34b9('0xfe')]);Papa[_0x34b9('0xff')](_0x4af143,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x1186bc){return _0x49d250[_0x34b9('0xe')](0xc8)['json']({'file':_0x23153c[_0x34b9('0xf4')],'fields':_0x1186bc[_0x34b9('0x100')][_0x34b9('0x29')]});}});};exports[_0x34b9('0x101')]=function(_0x4cabbb,_0x2a0a73){return db[_0x34b9('0x47')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0x34b9('0x6d')}})[_0x34b9('0x15')](function(_0x2d1351){var _0x5ed7e5=![];if(!_0x4cabbb[_0x34b9('0x8e')][_0x34b9('0x71')]){throw new Error(_0x34b9('0xe8'));}if(!_0x4cabbb[_0x34b9('0x8e')][_0x34b9('0x102')]['phone']){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x4cabbb[_0x34b9('0x8e')][_0x34b9('0x102')][_0x34b9('0xf1')]){throw new Error(_0x34b9('0xf2'));}if(!_0x4cabbb[_0x34b9('0x8e')]['socket_timestamp']){throw new Error(_0x34b9('0xee'));}var _0x2e63f2=require(_0x34b9('0xf8'))[_0x34b9('0xf9')](path['join'](__dirname,_0x34b9('0x103')),[_0x4cabbb['params']['id'],JSON[_0x34b9('0x104')](_0x4cabbb[_0x34b9('0x8e')]),JSON[_0x34b9('0x104')](_0x2d1351)]);_0x2e63f2['on']('message',function(){_0x5ed7e5=!![];return _0x2a0a73[_0x34b9('0xe')](0xc8)[_0x34b9('0xf')]({'message':_0x34b9('0x105'),'pid':_0x2e63f2[_0x34b9('0xfb')]});});_0x2e63f2['on'](_0x34b9('0x106'),function(_0x62e1a5){if(_0x62e1a5&&!_0x5ed7e5){return _0x2a0a73[_0x34b9('0xe')](0x1f4)[_0x34b9('0xf')]({'message':_0x34b9('0x107'),'pid':_0x2e63f2[_0x34b9('0xfb')]});}});})[_0x34b9('0x84')](handleError(_0x2a0a73,null));};exports[_0x34b9('0x108')]=function(_0x90937d,_0x1ad5cb,_0x5c2993){return db[_0x34b9('0x47')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0x34b9('0x6d')}})[_0x34b9('0x15')](function(_0x433279){var _0x8d6129=![];if(!_0x90937d[_0x34b9('0x8e')][_0x34b9('0x71')]){throw new Error('No\x20ListId\x20specified');}if(!_0x90937d[_0x34b9('0x8e')][_0x34b9('0x102')][_0x34b9('0xc7')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x90937d[_0x34b9('0x8e')][_0x34b9('0x102')][_0x34b9('0xf1')]){throw new Error(_0x34b9('0xf2'));}if(!_0x90937d[_0x34b9('0x8e')]['socket_timestamp']){throw new Error(_0x34b9('0xee'));}var _0x2934fa=require(_0x34b9('0xf8'))['fork'](path[_0x34b9('0xad')](__dirname,_0x34b9('0x109')),[_0x90937d[_0x34b9('0x87')]['id'],JSON[_0x34b9('0x104')](_0x90937d[_0x34b9('0x8e')]),JSON['stringify'](_0x433279)]);_0x2934fa['on'](_0x34b9('0x10a'),function(_0x4e5379){_0x8d6129=!![];return _0x1ad5cb[_0x34b9('0xe')](0xc8)[_0x34b9('0xf')]({'message':_0x34b9('0x105'),'pid':_0x2934fa[_0x34b9('0xfb')]});});_0x2934fa['on'](_0x34b9('0x106'),function(_0x42c0e5){if(_0x42c0e5&&!_0x8d6129){return _0x1ad5cb[_0x34b9('0xe')](0x1f4)['json']({'message':_0x34b9('0x107'),'pid':_0x2934fa[_0x34b9('0xfb')]});}});})[_0x34b9('0x84')](handleError(_0x1ad5cb,null));};exports['getJourney']=function(_0x169a04,_0x39c8fe){var _0x664e4c=[_0x34b9('0x10b'),_0x34b9('0x10c'),_0x34b9('0x10d'),_0x34b9('0x10e'),_0x34b9('0x10f'),_0x34b9('0x110'),_0x34b9('0x111')];var _0x42d33f={'offset':0x0,'order':qs['sort']('-createdAt')},_0x350f64={'count':0x0,'rows':[]};Promise['resolve']()[_0x34b9('0x15')](function(){if(_0x169a04[_0x34b9('0x26')][_0x34b9('0x112')]){if(!_[_0x34b9('0x113')](_0x664e4c,_0x169a04[_0x34b9('0x26')]['channel']['toLowerCase']())){throw new Error(_0x34b9('0x114'));}_0x664e4c=[_0x169a04[_0x34b9('0x26')][_0x34b9('0x112')][_0x34b9('0x115')]()];}if(_0x169a04['query'][_0x34b9('0x116')]){try{var _0xa48640=JSON['parse'](_0x169a04[_0x34b9('0x26')][_0x34b9('0x116')]);if(!moment(_0xa48640['from'])[_0x34b9('0x117')]()){throw new Error(_0x34b9('0x118'));}if(!moment(_0xa48640['to'])[_0x34b9('0x117')]()){throw new Error('Invalid\x20date\x20for\x20range\x20to\x20filter');}}catch(_0x4e3f48){throw new Error(_0x34b9('0x119'));}}if(!_0x169a04[_0x34b9('0x26')][_0x34b9('0x2a')](_0x34b9('0x2b'))){_0x42d33f[_0x34b9('0x11')]=qs[_0x34b9('0x11')](_0x169a04[_0x34b9('0x26')][_0x34b9('0x11')]||0xa);_0x42d33f[_0x34b9('0x13')]=qs[_0x34b9('0x13')](_0x169a04[_0x34b9('0x26')]['offset']);}var _0x34a18a=_0x664e4c[_0x34b9('0x51')](function(_0x4f727d){if(_0x4f727d===_0x34b9('0x111')){var _0x964ad={'attributes':['id',_0x34b9('0x11a'),'type',_0x34b9('0x11b'),_0x34b9('0x11c'),_0x34b9('0x11d'),_0x34b9('0x11e'),_0x34b9('0x11f'),_0x34b9('0x120'),'note',_0x34b9('0x121'),_0x34b9('0x122'),_0x34b9('0x123'),_0x34b9('0x124'),_0x34b9('0x125')],'where':{'ContactId':_0x169a04[_0x34b9('0x87')]['id']},'include':[{'model':db[_0x34b9('0x47')],'as':_0x34b9('0x47'),'attributes':['id',_0x34b9('0x19'),_0x34b9('0x126'),_0x34b9('0x8c')]}],'order':[[_0x34b9('0x121'),'DESC']]};if(_0x169a04[_0x34b9('0x26')][_0x34b9('0x116')]){_0x964ad[_0x34b9('0x3c')][_0x34b9('0x121')]={'$gte':_0xa48640[_0x34b9('0x33')],'$lte':_0xa48640['to']};}return db[_0x34b9('0xa5')][_0x34b9('0x127')](_0x964ad)[_0x34b9('0x15')](function(_0x1317d2){_0x350f64[_0x34b9('0x12')]+=_0x1317d2[_0x34b9('0x12')];return _[_0x34b9('0x51')](_0x1317d2[_0x34b9('0x83')],function(_0x33b422){var _0x2cd519=_0x33b422[_0x34b9('0x90')]({'plain':!![]});_0x2cd519[_0x34b9('0x112')]=_0x4f727d;if(_0x2cd519[_0x34b9('0x47')]){_0x2cd519['User']={'id':_0x2cd519[_0x34b9('0x47')]['id'],'name':_0x2cd519['User'][_0x34b9('0x19')],'fullname':_0x2cd519[_0x34b9('0x47')][_0x34b9('0x126')],'alias':_0x2cd519['User'][_0x34b9('0x8c')]};}return _0x2cd519;});});}else{var _0x51f612=_[_0x34b9('0x128')](_0x4f727d)+(_0x4f727d==='chat'?_0x34b9('0x129'):_0x34b9('0x12a'));var _0x3827e1={'attributes':['id',_0x34b9('0x12b'),_0x34b9('0x12c'),_0x34b9('0x121'),_0x34b9('0x12d'),_0x34b9('0x12e'),_0x34b9('0x12f'),_0x34b9('0x130'),_0x34b9('0x125'),_0x51f612+'Id'],'where':{'ContactId':_0x169a04[_0x34b9('0x87')]['id']},'include':[{'model':db[_0x51f612],'as':'Account','attributes':['id',_0x34b9('0x19'),'key']},{'model':db[_0x34b9('0x47')],'as':_0x34b9('0x131'),'attributes':['id',_0x34b9('0x19'),'fullname']},{'model':db['Tag'],'as':_0x34b9('0x82'),'attributes':['id',_0x34b9('0x19'),'color'],'through':{'attributes':[]}}],'order':[[_0x34b9('0x121'),_0x34b9('0x132')]]};if(_0x169a04['query'][_0x34b9('0x116')]){_0x3827e1['where'][_0x34b9('0x121')]={'$gte':_0xa48640[_0x34b9('0x33')],'$lte':_0xa48640['to']};}switch(_0x4f727d){case'chat':_0x3827e1[_0x34b9('0x28')][_0x34b9('0x54')](_0x34b9('0x133'),_0x34b9('0x134'),_0x34b9('0x135'),'deviceModel','osName',_0x34b9('0x136'),_0x34b9('0x137'),_0x34b9('0x138'),_0x34b9('0x139'));break;case _0x34b9('0x10b'):_0x3827e1[_0x34b9('0x28')][_0x34b9('0x54')](_0x34b9('0x13a'),_0x34b9('0x13b'));break;case'openchannel':_0x3827e1[_0x34b9('0x28')][_0x34b9('0x54')](_0x34b9('0x13c'),_0x34b9('0x13d'));break;}return db[_[_0x34b9('0x128')](_0x4f727d)+_0x34b9('0x13e')]['findAndCountAll'](_0x3827e1)[_0x34b9('0x15')](function(_0x3ecece){_0x350f64[_0x34b9('0x12')]+=_0x3ecece[_0x34b9('0x12')];return _['map'](_0x3ecece[_0x34b9('0x83')],function(_0x314cdb){var _0x5ec0d1=_0x314cdb[_0x34b9('0x90')]({'plain':!![]});_0x5ec0d1[_0x34b9('0x112')]=_0x4f727d;if(_0x5ec0d1[_0x34b9('0x131')]){_0x5ec0d1[_0x34b9('0x131')]={'id':_0x5ec0d1[_0x34b9('0x131')]['id'],'name':_0x5ec0d1[_0x34b9('0x131')]['name'],'fullname':_0x5ec0d1[_0x34b9('0x131')][_0x34b9('0x126')]};}return _0x5ec0d1;});});}});return Promise[_0x34b9('0x23')](_0x34a18a);})[_0x34b9('0x15')](function(_0x5e1bea){return _(_0x5e1bea)['flatten']()[_0x34b9('0x13f')]('createdAt')[_0x34b9('0x140')]()['value']();})[_0x34b9('0x15')](function(_0x215a94){_0x350f64[_0x34b9('0x83')]=_0x42d33f[_0x34b9('0x11')]?_0x215a94[_0x34b9('0x141')](_0x42d33f[_0x34b9('0x13')],_0x42d33f[_0x34b9('0x13')]+_0x42d33f[_0x34b9('0x11')]):_0x215a94;return _0x350f64;})[_0x34b9('0x15')](respondWithFilteredResult(_0x39c8fe,_0x42d33f))[_0x34b9('0x84')](handleError(_0x39c8fe,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff