// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xfad1=['secondDisposition','thirdDisposition','Account','Owner','browserName','customerIp','deviceModel','osName','ratingMessage','ratingType','ratingValue','referer','subject','substatus','openchannel','externalUrl','threadId','Interaction','sortBy','reverse','slice','moment','util','path','lodash','squel','papaparse','ioredis','../../components/parsers/advancedSearch','../../config/environment','../../mysqldb','redis','localhost','socket.io-emitter','register','json','undefined','limit','offset','count','status','Content-Range','then','end','sendStatus','error','name','index','describe','length','keys','startsWith','push','CmCustomField','findOne','trimStart','all','cf_','fieldType','type','model','query','filters','intersection','attributes','fields','hasOwnProperty','nolimit','sort','where','select','field','color','from','tools_tags','cm_contacts','left_join','uc.CmContactId\x20=\x20c.id','c.deletedAt\x20IS\x20NULL','expr','search','sqlOperator','conditions','find','value','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','and','uc.UserId\x20=\x20?','datetime','castTo','DATE','buildExpression','text','map','filter','isNil','Contact','ListId','c.ListId\x20IN\x20?','concat','\x20=\x20?','tag','replace','split','isNumeric','c.id\x20LIKE\x20?','c.phone\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','c.email\x20LIKE\x20?','group','Sequelize','QueryTypes','clone','order','DESC','isEmpty','t.id\x20IN\x20?','user','role','agent','some','User','c.ListId\x20IS\x20NULL','toString','sequelize','keyBy','CmContact','c.firstName','c.lastName','c.phone','c.mobile','c.fax','c.ListId','c.createdAt','c.deletedAt','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','Tags','rows','catch','destroy','params','tags','columnName','displayName','analytics','findAll','custom','values','merge','body','get','isArray','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','create','update','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappMessage','join','duplicates','$or','findOrCreate','show','Tag','$and','omit','format','pickBy','cf_%d','table','setFields','toParam','phone','rawAttributes','pick','options','getTags','setTags','ContactId','includeAll','getHopperHistories','include','CmHopperHistory','getHopperFinals','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20firstName\x20column\x20specified','file','filename','chmodSync','0777','child_process','socket_timestamp','File\x20uploaded\x20correctly!','pid','send','upload','createReadStream','parse','import','No\x20phone\x20column\x20specified','firstName','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','fork','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','exit','error\x20child\x20process','getJourney','mail','chat','fax','whatsapp','-createdAt','resolve','channel','toLowerCase','Invalid\x20channel','range','isValid','Invalid\x20date\x20for\x20range\x20to\x20filter','Invalid\x20createdAt\x20filter','voice','uniqueid','source','destination','callerid','starttime','endtime','duration','note','createdAt','userDisposition','userThirdDisposition','UserId','fullname','alias','findAndCountAll','startCase','closed','closedAt','disposition'];(function(_0x58d719,_0x44d73d){var _0x206009=function(_0xe4116f){while(--_0xe4116f){_0x58d719['push'](_0x58d719['shift']());}};_0x206009(++_0x44d73d);}(_0xfad1,0x12a));var _0x1fad=function(_0x5258b1,_0x293992){_0x5258b1=_0x5258b1-0x0;var _0x181a02=_0xfad1[_0x5258b1];return _0x181a02;};'use strict';var moment=require(_0x1fad('0x0'));var BPromise=require('bluebird');var util=require(_0x1fad('0x1'));var path=require(_0x1fad('0x2'));var fs=require('fs');var _=require(_0x1fad('0x3'));var squel=require(_0x1fad('0x4'));var Papa=require(_0x1fad('0x5'));var Redis=require(_0x1fad('0x6'));var qs=require('../../components/parsers/qs');var as=require(_0x1fad('0x7'));var logger=require('../../config/logger')('api');var config=require(_0x1fad('0x8'));var db=require(_0x1fad('0x9'))['db'];config[_0x1fad('0xa')]=_['defaults'](config[_0x1fad('0xa')],{'host':_0x1fad('0xb'),'port':0x18eb});var socket=require(_0x1fad('0xc'))(new Redis(config[_0x1fad('0xa')]));require('./cmContact.socket')[_0x1fad('0xd')](socket);function respondWithResult(_0x26ead8,_0x25305e){_0x25305e=_0x25305e||0xc8;return function(_0x3d5a75){if(_0x3d5a75){return _0x26ead8['status'](_0x25305e)[_0x1fad('0xe')](_0x3d5a75);}};}function respondWithFilteredResult(_0x5140db,_0x3c97b8){return function(_0x28e318){if(_0x28e318){var _0x2305ee=typeof _0x3c97b8['offset']===_0x1fad('0xf')&&typeof _0x3c97b8[_0x1fad('0x10')]==='undefined';var _0x3c127f=_0x28e318['count'];var _0x3e00b1=_0x2305ee?0x0:_0x3c97b8[_0x1fad('0x11')];var _0x15a14f=_0x2305ee?_0x28e318[_0x1fad('0x12')]:_0x3c97b8[_0x1fad('0x11')]+_0x3c97b8[_0x1fad('0x10')];var _0x57af74;if(_0x15a14f>=_0x3c127f){_0x15a14f=_0x3c127f;_0x57af74=0xc8;}else{_0x57af74=0xce;}_0x5140db[_0x1fad('0x13')](_0x57af74);return _0x5140db['set'](_0x1fad('0x14'),_0x3e00b1+'-'+_0x15a14f+'/'+_0x3c127f)[_0x1fad('0xe')](_0x28e318);}return null;};}function saveUpdates(_0x58bb2d){return function(_0x45df98){if(_0x45df98){return _0x45df98['update'](_0x58bb2d)['then'](function(_0x52c5e6){return _0x52c5e6;});}return null;};}function removeEntity(_0x507e12){return function(_0x5bfe65){if(_0x5bfe65){return _0x5bfe65['destroy']()[_0x1fad('0x15')](function(){_0x507e12[_0x1fad('0x13')](0xcc)[_0x1fad('0x16')]();});}};}function handleEntityNotFound(_0x17f82e){return function(_0x282049){if(!_0x282049){_0x17f82e[_0x1fad('0x17')](0x194);}return _0x282049;};}function handleError(_0x82c481,_0x4cf3b1){_0x4cf3b1=_0x4cf3b1||0x1f4;return function(_0x17cdfe){logger[_0x1fad('0x18')](_0x17cdfe['stack']);if(_0x17cdfe[_0x1fad('0x19')]){delete _0x17cdfe[_0x1fad('0x19')];}_0x82c481[_0x1fad('0x13')](_0x4cf3b1)['send'](_0x17cdfe);};}exports[_0x1fad('0x1a')]=function(_0x4d8d28,_0x447d61){var _0x473e0c={},_0x4b5d7b={},_0x44e7bd={'count':0x0,'rows':[]};return db['CmContact'][_0x1fad('0x1b')]()['then'](function(_0x2e824e){var _0x591d7c=[];for(var _0x216767=0x0;_0x216767<Object['keys'](_0x2e824e)[_0x1fad('0x1c')];_0x216767++){var _0x5cd017=Object[_0x1fad('0x1d')](_0x2e824e)[_0x216767];if(_[_0x1fad('0x1e')](_0x5cd017,'cf_')){_0x591d7c[_0x1fad('0x1f')](db[_0x1fad('0x20')][_0x1fad('0x21')]({'where':{'id':_[_0x1fad('0x22')](_0x5cd017,'cf_')},'raw':!![]}));}}return BPromise[_0x1fad('0x23')](_0x591d7c)[_0x1fad('0x15')](function(_0x6bb30f){for(var _0x5249ce=0x0;_0x5249ce<_0x6bb30f[_0x1fad('0x1c')];_0x5249ce++){if(_0x6bb30f[_0x5249ce]){var _0xa3af9c=_0x1fad('0x24')+_0x6bb30f[_0x5249ce]['id'];var _0x118a04=_0x2e824e[_0xa3af9c];_0x118a04[_0x1fad('0x25')]=_0x6bb30f[_0x5249ce][_0x1fad('0x26')];}}return _0x2e824e;});})[_0x1fad('0x15')](function(_0x2fe046){_0x4b5d7b[_0x1fad('0x27')]=_['keys'](_0x2fe046);_0x4b5d7b[_0x1fad('0x28')]=_[_0x1fad('0x1d')](_0x4d8d28[_0x1fad('0x28')]);_0x4b5d7b[_0x1fad('0x29')]=_[_0x1fad('0x2a')](_0x4b5d7b[_0x1fad('0x27')],_0x4b5d7b[_0x1fad('0x28')]);_0x473e0c[_0x1fad('0x2b')]=_[_0x1fad('0x2a')](_0x4b5d7b[_0x1fad('0x27')],qs[_0x1fad('0x2c')](_0x4d8d28[_0x1fad('0x28')]['fields']));_0x473e0c[_0x1fad('0x2b')]=_0x473e0c[_0x1fad('0x2b')]['length']?_0x473e0c[_0x1fad('0x2b')]:_0x4b5d7b[_0x1fad('0x27')];if(!_0x4d8d28['query'][_0x1fad('0x2d')](_0x1fad('0x2e'))){_0x473e0c[_0x1fad('0x10')]=qs[_0x1fad('0x10')](_0x4d8d28[_0x1fad('0x28')][_0x1fad('0x10')]);_0x473e0c[_0x1fad('0x11')]=qs[_0x1fad('0x11')](_0x4d8d28['query'][_0x1fad('0x11')]);}_0x473e0c['order']=qs[_0x1fad('0x2f')](_0x4d8d28[_0x1fad('0x28')][_0x1fad('0x2f')]);_0x473e0c[_0x1fad('0x30')]=qs[_0x1fad('0x29')](_['pick'](_0x4d8d28[_0x1fad('0x28')],_0x4b5d7b[_0x1fad('0x29')]),_0x2fe046);var _0x2225e6=[];var _0xc45ef9=squel[_0x1fad('0x31')]()[_0x1fad('0x32')]('id')[_0x1fad('0x32')](_0x1fad('0x19'))[_0x1fad('0x32')](_0x1fad('0x33'))[_0x1fad('0x34')](_0x1fad('0x35'));var _0x57d382=squel[_0x1fad('0x31')]()[_0x1fad('0x34')](_0x1fad('0x36'),'c')[_0x1fad('0x37')]('cm_user_has_contacts','uc',_0x1fad('0x38'))[_0x1fad('0x37')]('cm_contact_has_tags','ct','ct.CmContactId\x20=\x20c.id')[_0x1fad('0x37')](_0x1fad('0x35'),'t','t.id\x20=\x20ct.TagId')[_0x1fad('0x30')](_0x1fad('0x39'));var _0x359540=squel[_0x1fad('0x3a')]();var _0x36f021=[];var _0x4fe20a=squel[_0x1fad('0x3a')]();var _0x227059;if(_0x4d8d28['query'][_0x1fad('0x3b')]){_0x227059=as['parseSearch'](_0x4d8d28[_0x1fad('0x28')][_0x1fad('0x3b')]);var _0x1202b5=_0x227059[_0x1fad('0x3c')];for(var _0x409f47=0x0;_0x409f47<_0x227059[_0x1fad('0x3d')][_0x1fad('0x1c')];_0x409f47++){var _0x594cb7=_0x227059[_0x1fad('0x3d')][_0x409f47];var _0x2b6075='c';var _0x5205e4=_(_0x2fe046)[_0x1fad('0x1d')]()[_0x1fad('0x3e')](function(_0x47a9ca){return _0x47a9ca===_0x594cb7[_0x1fad('0x32')];});if(_0x5205e4)_0x5205e4=_0x2fe046[_0x594cb7[_0x1fad('0x32')]];if(!_0x5205e4){if(_0x594cb7[_0x1fad('0x32')]==='Tag'){var _0x237918=_0x594cb7[_0x1fad('0x3f')]['split'](',')['map'](function(_0x459c5a){return Number(_0x459c5a);});_0x237918[_0x1fad('0x40')](function(_0x462995){_0x4fe20a['or'](_0x1fad('0x41'),'%,'+_0x462995+',%');});_0x36f021=_[_0x1fad('0x42')](_0x36f021,_0x237918);}else if(_0x594cb7[_0x1fad('0x32')]==='User'){_0x359540[_0x1fad('0x43')](_0x1fad('0x44'),_0x594cb7[_0x1fad('0x3f')]);}}else{if(_0x594cb7[_0x1fad('0x32')]==='dateOfBirth'||_0x5205e4['fieldType']===_0x1fad('0x45'))_0x594cb7[_0x1fad('0x46')]=_0x1fad('0x47');var _0x5aa541=as[_0x1fad('0x48')](_0x2b6075,_0x5205e4[_0x1fad('0x26')],_0x594cb7);_0x359540[_0x1202b5](_0x5aa541[_0x1fad('0x49')],_0x5aa541[_0x1fad('0x3f')]['start'],_0x5aa541[_0x1fad('0x3f')][_0x1fad('0x16')]);}}}else{var _0x4c3b75=_(Object[_0x1fad('0x1d')](_0x4d8d28[_0x1fad('0x28')]))[_0x1fad('0x4a')](function(_0x5955af){return _0x2fe046[_0x1fad('0x2d')](_0x5955af)?_0x5955af:undefined;})[_0x1fad('0x4b')](function(_0x203033){return!_[_0x1fad('0x4c')](_0x203033);})[_0x1fad('0x3f')]();if(_0x4d8d28[_0x1fad('0x28')][_0x1fad('0x4d')])_0x4c3b75['push'](_0x1fad('0x4d'));if(!_['isEmpty'](_0x4c3b75)){_0x4c3b75[_0x1fad('0x40')](function(_0x1565b9){if(_0x1565b9===_0x1fad('0x4e')){_0x57d382['where'](_0x1fad('0x4f'),[][_0x1fad('0x50')](_0x4d8d28[_0x1fad('0x28')][_0x1565b9]));}else if(_0x1565b9===_0x1fad('0x4d')){var _0x1bc7fb='%'+_0x4d8d28[_0x1fad('0x28')][_0x1565b9]+'%';_0x57d382[_0x1fad('0x30')]('CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?',_0x1bc7fb);}else{_0x57d382[_0x1fad('0x30')]('c.'+_0x1565b9+_0x1fad('0x51'),_0x4d8d28[_0x1fad('0x28')][_0x1565b9]);}});}if(_0x4d8d28[_0x1fad('0x28')][_0x1fad('0x52')]){_0x36f021=_['isArray'](_0x4d8d28['query']['tag'])?_0x4d8d28['query'][_0x1fad('0x52')]:new Array(_0x4d8d28['query']['tag']);_0x36f021[_0x1fad('0x40')](function(_0x558609){_0x4fe20a['or'](_0x1fad('0x41'),'%,'+_0x558609+',%');});}if(_0x4d8d28['query'][_0x1fad('0x4b')]){var _0x5d9dd8=_0x4d8d28[_0x1fad('0x28')][_0x1fad('0x4b')][_0x1fad('0x53')]('\x5c','\x5c\x5c')[_0x1fad('0x53')](/'/g,'\x27\x27');if(_0x5d9dd8[_0x1fad('0x54')]('\x20')[_0x1fad('0x1c')]>0x1){_0x359540['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x5d9dd8),null);}else{if(qs[_0x1fad('0x55')](_0x5d9dd8)){_0x359540['or'](_0x1fad('0x56'),_0x5d9dd8+'%');_0x359540['or'](_0x1fad('0x57'),_0x5d9dd8+'%');_0x359540['or']('c.mobile\x20LIKE\x20?',_0x5d9dd8+'%');_0x359540['or'](_0x1fad('0x58'),_0x5d9dd8+'%');}else if(qs[_0x1fad('0x59')](_0x5d9dd8)){_0x359540['or']('c.email\x20LIKE\x20?',_0x5d9dd8+'%');}else{_0x359540['or'](_0x1fad('0x5a'),'%'+_0x5d9dd8+'%');_0x359540['or'](_0x1fad('0x5b'),'%'+_0x5d9dd8+'%');_0x359540['or'](_0x1fad('0x5c'),'%'+_0x5d9dd8+'%');}}}}_0x57d382[_0x1fad('0x30')](_0x359540);_0x57d382[_0x1fad('0x5d')]('c.id');var _0x3394f8={'type':db[_0x1fad('0x5e')][_0x1fad('0x5f')]['SELECT'],'raw':!![]};var _0x1f5979=_0x57d382[_0x1fad('0x60')]()['field']('c.id');if(_0x473e0c[_0x1fad('0x61')]){_0x473e0c[_0x1fad('0x61')][_0x1fad('0x40')](function(_0x59b4e1){_0x57d382[_0x1fad('0x61')]('c.'+_0x59b4e1[0x0],_0x59b4e1[0x1]===_0x1fad('0x62')?![]:!![]);});}if(!_[_0x1fad('0x63')](_0x36f021)){_0x57d382['having'](_0x4fe20a);_0x1f5979[_0x1fad('0x30')](_0x1fad('0x64'),_0x36f021);}BPromise['resolve']()[_0x1fad('0x15')](function(){if(!_0x227059)return;if(_0x4d8d28[_0x1fad('0x65')][_0x1fad('0x66')]!==_0x1fad('0x67'))return;if(!_[_0x1fad('0x68')](_0x227059[_0x1fad('0x3d')],[_0x1fad('0x32'),_0x1fad('0x69')])){return _0x4d8d28[_0x1fad('0x65')]['getLists']({'attributes':['id'],'raw':!![]})[_0x1fad('0x15')](function(_0x2ca401){if(_[_0x1fad('0x63')](_0x2ca401)){_0x1f5979[_0x1fad('0x30')](_0x1fad('0x6a'));_0x57d382[_0x1fad('0x30')](_0x1fad('0x6a'));}else{_0x1f5979['where'](_0x1fad('0x4f'),_[_0x1fad('0x4a')](_0x2ca401,'id'));_0x57d382['where'](_0x1fad('0x4f'),_[_0x1fad('0x4a')](_0x2ca401,'id'));}});}})[_0x1fad('0x15')](function(){if(_0x4d8d28[_0x1fad('0x65')]['role']===_0x1fad('0x67')&&!_0x227059&&!_0x4d8d28[_0x1fad('0x28')][_0x1fad('0x4e')])return[];return db['sequelize'][_0x1fad('0x28')](_0x1f5979[_0x1fad('0x6b')](),_0x3394f8);})[_0x1fad('0x15')](function(_0x9edcfb){_0x44e7bd['count']=_0x9edcfb[_0x1fad('0x1c')];if(_0x44e7bd[_0x1fad('0x12')]===0x0)return[];return db[_0x1fad('0x6c')][_0x1fad('0x28')](_0xc45ef9[_0x1fad('0x6b')](),_0x3394f8)['then'](function(_0x43d290){_0x2225e6=_[_0x1fad('0x6d')](_0x43d290,'id');_0x3394f8=_['merge'](_0x3394f8,{'model':db[_0x1fad('0x6e')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x4d8d28[_0x1fad('0x28')][_0x1fad('0x2c')]){_0x473e0c[_0x1fad('0x2b')][_0x1fad('0x40')](function(_0x2cd9dc){_0x57d382[_0x1fad('0x32')]('c.'+_0x2cd9dc);});}else{_0x57d382[_0x1fad('0x32')]('c.id');_0x57d382[_0x1fad('0x32')](_0x1fad('0x6f'));_0x57d382[_0x1fad('0x32')](_0x1fad('0x70'));_0x57d382[_0x1fad('0x32')](_0x1fad('0x71'));_0x57d382[_0x1fad('0x32')](_0x1fad('0x72'));_0x57d382['field'](_0x1fad('0x73'));_0x57d382[_0x1fad('0x32')]('c.email');_0x57d382['field'](_0x1fad('0x74'));_0x57d382[_0x1fad('0x32')](_0x1fad('0x75'));_0x57d382[_0x1fad('0x32')](_0x1fad('0x76'));_0x57d382['field']('c.CompanyId');_0x57d382[_0x1fad('0x32')](_0x1fad('0x77'),_0x1fad('0x78'));}if(_0x473e0c['limit'])_0x57d382[_0x1fad('0x10')](_0x473e0c[_0x1fad('0x10')]);if(_0x473e0c[_0x1fad('0x11')])_0x57d382['offset'](_0x473e0c[_0x1fad('0x11')]);return db[_0x1fad('0x6c')]['query'](_0x57d382[_0x1fad('0x6b')](),_0x3394f8);});})[_0x1fad('0x15')](function(_0x396a91){_0x396a91[_0x1fad('0x40')](function(_0x2ded6b){if(_0x2ded6b[_0x1fad('0x78')]){_0x2ded6b[_0x1fad('0x79')]=[];_0x2ded6b[_0x1fad('0x78')][_0x1fad('0x54')](',')[_0x1fad('0x40')](function(_0x14f3b4){_0x2ded6b[_0x1fad('0x79')]['push'](_0x2225e6[_0x14f3b4]);});}delete _0x2ded6b[_0x1fad('0x78')];});_0x44e7bd[_0x1fad('0x7a')]=_0x396a91;return _0x44e7bd;})[_0x1fad('0x15')](respondWithFilteredResult(_0x447d61,_0x473e0c));})[_0x1fad('0x7b')](handleError(_0x447d61,null));};exports[_0x1fad('0x7c')]=function(_0x4aff22,_0x556ba4){return db['CmContact'][_0x1fad('0x3e')]({'where':{'id':_0x4aff22[_0x1fad('0x7d')]['id']}})['then'](handleEntityNotFound(_0x556ba4,null))[_0x1fad('0x15')](removeEntity(_0x556ba4,null))[_0x1fad('0x7b')](handleError(_0x556ba4,null));};exports[_0x1fad('0x1b')]=function(_0x1c87a1,_0x4a7abc){return db[_0x1fad('0x6e')]['describe']()[_0x1fad('0x15')](function(_0x41b5ba){delete _0x41b5ba[_0x1fad('0x7e')];for(var _0x363344=0x0;_0x363344<Object[_0x1fad('0x1d')](_0x41b5ba)[_0x1fad('0x1c')];_0x363344++){var _0x25ae2b=Object[_0x1fad('0x1d')](_0x41b5ba)[_0x363344];if(!_[_0x1fad('0x1e')](_0x25ae2b,_0x1fad('0x24'))){_0x41b5ba[_0x25ae2b][_0x1fad('0x7f')]=_0x25ae2b;_0x41b5ba[_0x25ae2b][_0x1fad('0x80')]=_0x25ae2b;}}return _0x41b5ba;})[_0x1fad('0x15')](function(_0x27e619){var _0xe819f4={'where':Boolean(_0x1c87a1['query'][_0x1fad('0x81')])===!![]?undefined:{'$or':[{'ListId':_0x1c87a1[_0x1fad('0x28')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x1fad('0x20')][_0x1fad('0x82')](_0xe819f4)[_0x1fad('0x15')](function(_0x510369){for(var _0x163d6e=0x0;_0x163d6e<_0x510369[_0x1fad('0x1c')];_0x163d6e++){var _0x22acfc=_0x1fad('0x24')+_0x510369[_0x163d6e]['id'];_0x27e619[_0x22acfc][_0x1fad('0x7f')]=_0x22acfc;_0x27e619[_0x22acfc][_0x1fad('0x80')]=_0x510369[_0x163d6e]['alias'];_0x27e619[_0x22acfc][_0x1fad('0x83')]={'type':_0x510369[_0x163d6e][_0x1fad('0x26')],'values':_0x510369[_0x163d6e][_0x1fad('0x84')]};}Object[_0x1fad('0x1d')](_0x27e619)[_0x1fad('0x40')](function(_0x3f9288){if(!_0x27e619[_0x3f9288][_0x1fad('0x2d')](_0x1fad('0x7f'))){delete _0x27e619[_0x3f9288];}});return _0x27e619;});})[_0x1fad('0x15')](respondWithResult(_0x4a7abc,null))[_0x1fad('0x7b')](handleError(_0x4a7abc,null));};exports[_0x1fad('0x85')]=function(_0x46016b,_0x6a58bd){var _0x305697;var _0x235800;var _0xd421cf;if(_0x46016b['body']['id']){delete _0x46016b[_0x1fad('0x86')]['id'];}return db[_0x1fad('0x6e')][_0x1fad('0x82')]({'where':{'id':[_0x46016b['body']['to'],_0x46016b[_0x1fad('0x86')][_0x1fad('0x34')]]}})['then'](function(_0xf21895){if(_0xf21895){if(_0xf21895[_0x1fad('0x1c')]!==0x2){return null;}_0xf21895[0x0]=_0xf21895[0x0]['get']({'plain':!![]});_0xf21895[0x1]=_0xf21895[0x1][_0x1fad('0x87')]({'plain':!![]});delete _0xf21895[0x0]['id'];delete _0xf21895[0x1]['id'];return _['mergeWith'](_0xf21895[0x0],_0xf21895[0x1],function(_0x4eaeea,_0x2ab26d){if(Array[_0x1fad('0x88')](_0x2ab26d)&&!_0x2ab26d[_0x1fad('0x1c')]){return _0x4eaeea;}else if(!_0x2ab26d){return _0x4eaeea;}});}})[_0x1fad('0x15')](handleEntityNotFound(_0x6a58bd,null))[_0x1fad('0x15')](function(_0x35a10b){if(_0x35a10b){if(_0x35a10b['tags']&&_[_0x1fad('0x88')](_0x35a10b[_0x1fad('0x7e')])){_0x35a10b[_0x1fad('0x7e')]=_0x35a10b['tags']['join']();}logger[_0x1fad('0x89')](_0x1fad('0x8a'),_0x46016b[_0x1fad('0x86')]['to'],_0x46016b[_0x1fad('0x86')]['from']);return db[_0x1fad('0x8b')][_0x1fad('0x7c')]({'where':{'ContactId':[_0x46016b[_0x1fad('0x86')]['to'],_0x46016b[_0x1fad('0x86')]['from']]}})['then'](function(_0x49be48){logger['info'](_0x1fad('0x8c'),_0x49be48);return db[_0x1fad('0x8d')]['destroy']({'where':{'ContactId':[_0x46016b[_0x1fad('0x86')]['to'],_0x46016b['body'][_0x1fad('0x34')]]}})[_0x1fad('0x15')](function(_0x321c2e){logger['info']('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x321c2e);return db['CmContact'][_0x1fad('0x8e')](_0x35a10b);});});}})[_0x1fad('0x15')](function(_0x400ebd){if(_0x400ebd){_0x305697=_0x400ebd;_0x235800={'ContactId':_0x305697['id']};_0xd421cf={'where':{'ContactId':[_0x46016b[_0x1fad('0x86')]['to'],_0x46016b[_0x1fad('0x86')]['from']]}};return db['ChatInteraction'][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})[_0x1fad('0x15')](function(){if(_0x305697){return db[_0x1fad('0x90')][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})[_0x1fad('0x15')](function(){if(_0x305697){return db[_0x1fad('0x91')][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})[_0x1fad('0x15')](function(){if(_0x305697){return db[_0x1fad('0x92')][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})[_0x1fad('0x15')](function(){if(_0x305697){return db['MailMessage'][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})[_0x1fad('0x15')](function(){if(_0x305697){return db[_0x1fad('0x92')][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})['then'](function(){if(_0x305697){return db[_0x1fad('0x93')][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})['then'](function(){if(_0x305697){return db['SmsInteraction']['update'](_0x235800,_0xd421cf);}})[_0x1fad('0x15')](function(){if(_0x305697){return db[_0x1fad('0x94')][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})[_0x1fad('0x15')](function(){if(_0x305697){return db[_0x1fad('0x95')][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})[_0x1fad('0x15')](function(){if(_0x305697){return db[_0x1fad('0x96')][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})[_0x1fad('0x15')](function(){if(_0x305697){return db[_0x1fad('0x97')][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})['then'](function(){if(_0x305697){return db[_0x1fad('0x98')][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})['then'](function(){if(_0x305697){return db[_0x1fad('0x99')][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})[_0x1fad('0x15')](function(){if(_0x305697){return db['CmHopperHistory'][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})[_0x1fad('0x15')](function(){if(_0x305697){return db[_0x1fad('0x9a')]['update'](_0x235800,_0xd421cf);}})[_0x1fad('0x15')](function(){if(_0x305697){return db[_0x1fad('0x9b')]['update'](_0x235800,_0xd421cf);}})[_0x1fad('0x15')](function(){if(_0x305697){return db[_0x1fad('0x9c')][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})[_0x1fad('0x15')](function(){if(_0x305697){return db[_0x1fad('0x9d')][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})[_0x1fad('0x15')](function(){if(_0x305697){return db['MailQueueReport'][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})['then'](function(){if(_0x305697){return db[_0x1fad('0x9e')][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})[_0x1fad('0x15')](function(){if(_0x305697){return db[_0x1fad('0x9f')][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})[_0x1fad('0x15')](function(){if(_0x305697){return db[_0x1fad('0xa0')][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})[_0x1fad('0x15')](function(){if(_0x305697){return db[_0x1fad('0xa1')][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})[_0x1fad('0x15')](function(){if(_0x305697){return db[_0x1fad('0xa2')][_0x1fad('0x8f')](_0x235800,_0xd421cf);}})[_0x1fad('0x15')](function(){if(_0x305697){return db['WhatsappQueueReport']['update'](_0x235800,_0xd421cf);}})[_0x1fad('0x15')](function(){if(_0x305697){return db[_0x1fad('0x6e')][_0x1fad('0x7c')]({'where':{'id':[_0x46016b[_0x1fad('0x86')]['to'],_0x46016b[_0x1fad('0x86')][_0x1fad('0x34')]]}});}})[_0x1fad('0x15')](function(){if(_0x305697){return _0x305697;}})['then'](respondWithResult(_0x6a58bd,null))[_0x1fad('0x7b')](handleError(_0x6a58bd,null));};exports[_0x1fad('0x8e')]=function(_0x11847f,_0x42a7ad){return db[_0x1fad('0x6e')][_0x1fad('0x1b')]()['then'](function(_0x369595){if(_0x11847f[_0x1fad('0x86')][_0x1fad('0x7e')]&&_['isArray'](_0x11847f[_0x1fad('0x86')][_0x1fad('0x7e')])){if(_0x11847f[_0x1fad('0x86')][_0x1fad('0x7e')][_0x1fad('0x1c')]){_0x11847f[_0x1fad('0x86')][_0x1fad('0x7e')]=_0x11847f[_0x1fad('0x86')]['tags'][_0x1fad('0xa3')](';')+';';}else{_0x11847f[_0x1fad('0x86')]['tags']=null;}}else{_0x11847f[_0x1fad('0x86')][_0x1fad('0x7e')]=null;}return db[_0x1fad('0x6e')][_0x1fad('0x8e')](_0x11847f[_0x1fad('0x86')],{'fields':_['keys'](_0x369595),'raw':!![]});})[_0x1fad('0x15')](respondWithResult(_0x42a7ad,0xc9))['catch'](handleError(_0x42a7ad,null));};exports['bulkCreate']=function(_0x42624c,_0x585ff1){var _0x201afb=0x0;var _0x34e0df=0x0;var _0x57ca41=0x0;return db['CmContact']['describe']()[_0x1fad('0x15')](function(_0x63bcf6){return BPromise['each'](_0x42624c[_0x1fad('0x86')],function(_0xcf0f50){var _0x2487ff={'where':{'$or':[]},'defaults':_0xcf0f50,'fields':_[_0x1fad('0x1d')](_0x63bcf6),'raw':!![]};if(_0xcf0f50[_0x1fad('0xa4')]){for(var _0xcf2529=0x0;_0xcf2529<_0xcf0f50['duplicates'][_0x1fad('0x1c')];_0xcf2529++){var _0x3f82f6={};_0x3f82f6[_0xcf0f50['duplicates'][_0xcf2529]]=_0xcf0f50[_0xcf0f50[_0x1fad('0xa4')][_0xcf2529]];_0x2487ff[_0x1fad('0x30')][_0x1fad('0xa5')][_0x1fad('0x1f')](_0x3f82f6);}_0x2487ff[_0x1fad('0x30')][_0x1fad('0x4e')]=_0xcf0f50[_0x1fad('0x4e')];}return db[_0x1fad('0x6e')][_0x1fad('0xa6')](_0x2487ff)['spread'](function(_0xd2d74,_0x2596e7){if(_0x2596e7){_0x201afb++;}else{_0x57ca41++;}})[_0x1fad('0x7b')](function(){_0x34e0df++;});});})[_0x1fad('0x15')](function(_0x2dc74d){if(_0x2dc74d){return{'success':_0x201afb,'failure':_0x34e0df,'duplicates':_0x57ca41};}})[_0x1fad('0x15')](respondWithResult(_0x585ff1,0xc9))[_0x1fad('0x7b')](handleError(_0x585ff1,null));};exports[_0x1fad('0xa7')]=function(_0x3359bd,_0x1d4036){var _0xbb7c88;return db[_0x1fad('0x6e')][_0x1fad('0x1b')]()['then'](function(_0xcdac30){return db[_0x1fad('0x6e')][_0x1fad('0x3e')]({'where':{'id':_0x3359bd[_0x1fad('0x7d')]['id']},'include':[{'model':db[_0x1fad('0xa8')],'as':_0x1fad('0x79'),'attributes':['id',_0x1fad('0x19'),_0x1fad('0x33')],'required':_0x3359bd[_0x1fad('0x28')][_0x1fad('0x52')]?!![]:![]}],'attributes':_[_0x1fad('0x1d')](_0xcdac30)});})['then'](function(_0x190a88){if(!_[_0x1fad('0x4c')](_0x190a88)){_0xbb7c88=_0x190a88['get']({'plain':!![]});var _0x37f526={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x190a88&&_0x190a88[_0x1fad('0x4e')]){if(_0x190a88[_0x1fad('0x4e')]){_0x37f526[_0x1fad('0x30')][_0x1fad('0xa9')][_0x1fad('0x1f')]({'ListId':{'$ne':_0x190a88[_0x1fad('0x4e')]}});}}return db[_0x1fad('0x20')][_0x1fad('0x82')](_0x37f526);}})[_0x1fad('0x15')](function(_0x3fe5db){if(!_[_0x1fad('0x4c')](_0x3fe5db)){return _[_0x1fad('0xaa')](_0xbb7c88,_['map'](_0x3fe5db,function(_0x55f3ae){return util[_0x1fad('0xab')]('cf_%d',_0x55f3ae['id']);}));}})['then'](handleEntityNotFound(_0x1d4036,null))[_0x1fad('0x15')](respondWithResult(_0x1d4036,null))['catch'](handleError(_0x1d4036,null));};exports[_0x1fad('0x8f')]=function(_0x5dff3a,_0x5b7ec9){var _0x24c4b4;if(_0x5dff3a[_0x1fad('0x86')]['id']){delete _0x5dff3a[_0x1fad('0x86')]['id'];}return db[_0x1fad('0x6e')][_0x1fad('0x3e')]({'where':{'id':_0x5dff3a['params']['id']}})['then'](handleEntityNotFound(_0x5b7ec9,null))[_0x1fad('0x15')](saveUpdates(_0x5dff3a[_0x1fad('0x86')],null))[_0x1fad('0x15')](function(_0x4acac1){_0x24c4b4=_0x4acac1;var _0x128b57={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x4acac1&&_0x4acac1[_0x1fad('0x4e')]){if(_0x4acac1[_0x1fad('0x4e')]){_0x128b57[_0x1fad('0x30')]['$and'][_0x1fad('0x1f')]({'ListId':{'$ne':_0x4acac1[_0x1fad('0x4e')]}});}}return db[_0x1fad('0x20')]['findAll'](_0x128b57);})[_0x1fad('0x15')](function(_0x463611){if(_0x463611){return _[_0x1fad('0xaa')](_[_0x1fad('0xac')](_0x5dff3a[_0x1fad('0x86')],function(_0x1a00f1,_0x304a10){return _[_0x1fad('0x1e')](_0x304a10,_0x1fad('0x24'));}),_[_0x1fad('0x4a')](_0x463611,function(_0x2c731a){return util['format'](_0x1fad('0xad'),_0x2c731a['id']);}));}})[_0x1fad('0x15')](function(_0x4d9dc6){if(_0x4d9dc6&&!_[_0x1fad('0x63')](_0x4d9dc6)){var _0x1c1cfd=squel[_0x1fad('0x8f')]()[_0x1fad('0xae')](_0x1fad('0x36'))[_0x1fad('0xaf')](_0x4d9dc6)['where']('id\x20=\x20?',_0x5dff3a[_0x1fad('0x7d')]['id'])[_0x1fad('0xb0')]();return db[_0x1fad('0x6c')]['query'](_0x1c1cfd[_0x1fad('0x49')],{'replacements':_0x1c1cfd[_0x1fad('0x84')]});}})['then'](function(){if(_0x5dff3a[_0x1fad('0x86')][_0x1fad('0xb1')]&&_0x24c4b4){return db[_0x1fad('0x8b')]['update']({'phone':_0x5dff3a[_0x1fad('0x86')][_0x1fad('0xb1')]},{'where':{'ContactId':_0x24c4b4['id']}});}})[_0x1fad('0x15')](function(){return _0x24c4b4;})[_0x1fad('0x15')](respondWithResult(_0x5b7ec9,null))['catch'](handleError(_0x5b7ec9,null));};exports['getTags']=function(_0x4de7a8,_0x3662cd){var _0x4625bf={};var _0x2e830b={};var _0x10b247;var _0x319906;return db['CmContact'][_0x1fad('0x21')]({'where':{'id':_0x4de7a8[_0x1fad('0x7d')]['id']}})[_0x1fad('0x15')](handleEntityNotFound(_0x3662cd,null))[_0x1fad('0x15')](function(_0x19824c){if(_0x19824c){_0x10b247=_0x19824c;_0x2e830b[_0x1fad('0x27')]=_[_0x1fad('0x1d')](db[_0x1fad('0xa8')][_0x1fad('0xb2')]);_0x2e830b[_0x1fad('0x28')]=_[_0x1fad('0x1d')](_0x4de7a8[_0x1fad('0x28')]);_0x2e830b[_0x1fad('0x29')]=_[_0x1fad('0x2a')](_0x2e830b['model'],_0x2e830b[_0x1fad('0x28')]);_0x4625bf[_0x1fad('0x2b')]=_[_0x1fad('0x2a')](_0x2e830b[_0x1fad('0x27')],qs[_0x1fad('0x2c')](_0x4de7a8['query'][_0x1fad('0x2c')]));_0x4625bf[_0x1fad('0x2b')]=_0x4625bf[_0x1fad('0x2b')][_0x1fad('0x1c')]?_0x4625bf['attributes']:_0x2e830b[_0x1fad('0x27')];_0x4625bf[_0x1fad('0x61')]=qs['sort'](_0x4de7a8[_0x1fad('0x28')][_0x1fad('0x2f')]);_0x4625bf[_0x1fad('0x30')]=qs[_0x1fad('0x29')](_[_0x1fad('0xb3')](_0x4de7a8[_0x1fad('0x28')],_0x2e830b[_0x1fad('0x29')]));if(_0x4de7a8[_0x1fad('0x28')][_0x1fad('0x4b')]){_0x4625bf[_0x1fad('0x30')]=_['merge'](_0x4625bf[_0x1fad('0x30')],{'$or':_[_0x1fad('0x4a')](_0x4625bf[_0x1fad('0x2b')],function(_0x11cbfb){var _0x3def76={};_0x3def76[_0x11cbfb]={'$like':'%'+_0x4de7a8[_0x1fad('0x28')][_0x1fad('0x4b')]+'%'};return _0x3def76;})});}_0x4625bf=_[_0x1fad('0x85')]({},_0x4625bf,_0x4de7a8[_0x1fad('0xb4')]);return _0x10b247[_0x1fad('0xb5')](_0x4625bf);}})['then'](function(_0xf9c5e6){if(_0xf9c5e6){_0x319906=_0xf9c5e6[_0x1fad('0x1c')];if(!_0x4de7a8[_0x1fad('0x28')][_0x1fad('0x2d')](_0x1fad('0x2e'))){_0x4625bf[_0x1fad('0x10')]=qs['limit'](_0x4de7a8[_0x1fad('0x28')][_0x1fad('0x10')]);_0x4625bf[_0x1fad('0x11')]=qs[_0x1fad('0x11')](_0x4de7a8[_0x1fad('0x28')][_0x1fad('0x11')]);}return _0x10b247['getTags'](_0x4625bf);}})[_0x1fad('0x15')](function(_0x511085){if(_0x511085){return _0x511085?{'count':_0x319906,'rows':_0x511085}:null;}})[_0x1fad('0x15')](respondWithResult(_0x3662cd,null))[_0x1fad('0x7b')](handleError(_0x3662cd,null));};exports[_0x1fad('0xb6')]=function(_0x53da2a,_0x18a593){if(_0x53da2a[_0x1fad('0x86')]['id']){delete _0x53da2a['body']['id'];}return db['CmContact'][_0x1fad('0x21')]({'where':{'id':_0x53da2a['params']['id']}})[_0x1fad('0x15')](handleEntityNotFound(_0x18a593,null))[_0x1fad('0x15')](function(_0x45b048){if(_0x45b048){return _0x45b048['setTags'](_0x53da2a[_0x1fad('0x86')]['ids']||[]);}return null;})[_0x1fad('0x15')](respondWithResult(_0x18a593,null))[_0x1fad('0x7b')](handleError(_0x18a593,null));};exports['getHoppers']=function(_0x28f408,_0x25c8ed){var _0x39182f={'raw':![],'where':{}};var _0x467d79={};var _0x8a2217={'count':0x0,'rows':[]};return db[_0x1fad('0x6e')][_0x1fad('0x21')]({'where':{'id':_0x28f408[_0x1fad('0x7d')]['id']}})[_0x1fad('0x15')](handleEntityNotFound(_0x25c8ed,null))['then'](function(_0x1b38b8){if(_0x1b38b8){_0x467d79['model']=_[_0x1fad('0x1d')](db[_0x1fad('0x8b')][_0x1fad('0xb2')]);_0x467d79[_0x1fad('0x28')]=_[_0x1fad('0x1d')](_0x28f408['query']);_0x467d79['filters']=_['intersection'](_0x467d79['model'],_0x467d79[_0x1fad('0x28')]);_0x39182f[_0x1fad('0x2b')]=_[_0x1fad('0x2a')](_0x467d79['model'],qs[_0x1fad('0x2c')](_0x28f408['query'][_0x1fad('0x2c')]));_0x39182f[_0x1fad('0x2b')]=_0x39182f['attributes'][_0x1fad('0x1c')]?_0x39182f[_0x1fad('0x2b')]:_0x467d79[_0x1fad('0x27')];if(!_0x28f408[_0x1fad('0x28')][_0x1fad('0x2d')](_0x1fad('0x2e'))){_0x39182f[_0x1fad('0x10')]=qs[_0x1fad('0x10')](_0x28f408['query'][_0x1fad('0x10')]);_0x39182f[_0x1fad('0x11')]=qs[_0x1fad('0x11')](_0x28f408[_0x1fad('0x28')][_0x1fad('0x11')]);}_0x39182f['order']=qs[_0x1fad('0x2f')](_0x28f408[_0x1fad('0x28')]['sort']);_0x39182f['where']=qs[_0x1fad('0x29')](_[_0x1fad('0xb3')](_0x28f408[_0x1fad('0x28')],_0x467d79[_0x1fad('0x29')]));_0x39182f[_0x1fad('0x30')][_0x1fad('0xb7')]=_0x1b38b8['id'];if(_0x28f408[_0x1fad('0x28')]['filter']){_0x39182f[_0x1fad('0x30')]=_[_0x1fad('0x85')](_0x39182f[_0x1fad('0x30')],{'$or':_[_0x1fad('0x4a')](_0x39182f['attributes'],function(_0x2de43c){var _0x509b41={};_0x509b41[_0x2de43c]={'$like':'%'+_0x28f408[_0x1fad('0x28')]['filter']+'%'};return _0x509b41;})});}_0x39182f=_['merge']({},_0x39182f,_0x28f408['options']);return db[_0x1fad('0x8b')][_0x1fad('0x12')]({'where':_0x39182f[_0x1fad('0x30')]})[_0x1fad('0x15')](function(_0x1150b9){_0x8a2217[_0x1fad('0x12')]=_0x1150b9;if(_0x28f408[_0x1fad('0x28')][_0x1fad('0xb8')]){_0x39182f['include']=[{'all':!![]}];}return db[_0x1fad('0x8b')]['findAll'](_0x39182f);})['then'](function(_0x41566d){_0x8a2217[_0x1fad('0x7a')]=_0x41566d;return _0x8a2217;});}})['then'](respondWithFilteredResult(_0x25c8ed,_0x39182f))[_0x1fad('0x7b')](handleError(_0x25c8ed,null));};exports[_0x1fad('0xb9')]=function(_0x29cadc,_0x4b89f1){var _0x11ab1d={'raw':!![],'where':{}};var _0x1a1336={};var _0x242fd7={'count':0x0,'rows':[]};return db[_0x1fad('0x6e')]['findOne']({'where':{'id':_0x29cadc['params']['id']}})[_0x1fad('0x15')](handleEntityNotFound(_0x4b89f1,null))[_0x1fad('0x15')](function(_0x5750ed){if(_0x5750ed){_0x1a1336[_0x1fad('0x27')]=_['keys'](db['CmHopperHistory'][_0x1fad('0xb2')]);_0x1a1336['query']=_[_0x1fad('0x1d')](_0x29cadc['query']);_0x1a1336[_0x1fad('0x29')]=_[_0x1fad('0x2a')](_0x1a1336[_0x1fad('0x27')],_0x1a1336[_0x1fad('0x28')]);_0x11ab1d[_0x1fad('0x2b')]=_[_0x1fad('0x2a')](_0x1a1336['model'],qs[_0x1fad('0x2c')](_0x29cadc['query'][_0x1fad('0x2c')]));_0x11ab1d['attributes']=_0x11ab1d[_0x1fad('0x2b')][_0x1fad('0x1c')]?_0x11ab1d[_0x1fad('0x2b')]:_0x1a1336[_0x1fad('0x27')];if(!_0x29cadc[_0x1fad('0x28')][_0x1fad('0x2d')]('nolimit')){_0x11ab1d['limit']=qs[_0x1fad('0x10')](_0x29cadc[_0x1fad('0x28')][_0x1fad('0x10')]);_0x11ab1d[_0x1fad('0x11')]=qs[_0x1fad('0x11')](_0x29cadc['query'][_0x1fad('0x11')]);}_0x11ab1d['order']=qs[_0x1fad('0x2f')](_0x29cadc[_0x1fad('0x28')][_0x1fad('0x2f')]);_0x11ab1d['where']=qs['filters'](_['pick'](_0x29cadc[_0x1fad('0x28')],_0x1a1336[_0x1fad('0x29')]));_0x11ab1d[_0x1fad('0x30')][_0x1fad('0xb7')]=_0x5750ed['id'];if(_0x29cadc[_0x1fad('0x28')][_0x1fad('0x4b')]){_0x11ab1d[_0x1fad('0x30')]=_[_0x1fad('0x85')](_0x11ab1d[_0x1fad('0x30')],{'$or':_[_0x1fad('0x4a')](_0x11ab1d[_0x1fad('0x2b')],function(_0x50a259){var _0x38cd71={};_0x38cd71[_0x50a259]={'$like':'%'+_0x29cadc[_0x1fad('0x28')][_0x1fad('0x4b')]+'%'};return _0x38cd71;})});}_0x11ab1d=_[_0x1fad('0x85')]({},_0x11ab1d,_0x29cadc[_0x1fad('0xb4')]);return db['CmHopperHistory']['count']({'where':_0x11ab1d[_0x1fad('0x30')]})[_0x1fad('0x15')](function(_0x1403a2){_0x242fd7[_0x1fad('0x12')]=_0x1403a2;if(_0x29cadc[_0x1fad('0x28')][_0x1fad('0xb8')]){_0x11ab1d[_0x1fad('0xba')]=[{'all':!![]}];}return db[_0x1fad('0xbb')]['findAll'](_0x11ab1d);})[_0x1fad('0x15')](function(_0x4399eb){_0x242fd7[_0x1fad('0x7a')]=_0x4399eb;return _0x242fd7;});}})['then'](respondWithFilteredResult(_0x4b89f1,_0x11ab1d))[_0x1fad('0x7b')](handleError(_0x4b89f1,null));};exports[_0x1fad('0xbc')]=function(_0x1f2f4f,_0x57edb9){var _0x1535cf={'raw':!![],'where':{}};var _0x1b014a={};var _0x67b2f7={'count':0x0,'rows':[]};return db[_0x1fad('0x6e')]['findOne']({'where':{'id':_0x1f2f4f[_0x1fad('0x7d')]['id']}})[_0x1fad('0x15')](handleEntityNotFound(_0x57edb9,null))[_0x1fad('0x15')](function(_0x36e44b){if(_0x36e44b){_0x1b014a[_0x1fad('0x27')]=_['keys'](db['CmHopperFinal'][_0x1fad('0xb2')]);_0x1b014a[_0x1fad('0x28')]=_[_0x1fad('0x1d')](_0x1f2f4f[_0x1fad('0x28')]);_0x1b014a[_0x1fad('0x29')]=_[_0x1fad('0x2a')](_0x1b014a[_0x1fad('0x27')],_0x1b014a[_0x1fad('0x28')]);_0x1535cf['attributes']=_[_0x1fad('0x2a')](_0x1b014a[_0x1fad('0x27')],qs[_0x1fad('0x2c')](_0x1f2f4f[_0x1fad('0x28')][_0x1fad('0x2c')]));_0x1535cf[_0x1fad('0x2b')]=_0x1535cf[_0x1fad('0x2b')][_0x1fad('0x1c')]?_0x1535cf[_0x1fad('0x2b')]:_0x1b014a[_0x1fad('0x27')];if(!_0x1f2f4f[_0x1fad('0x28')][_0x1fad('0x2d')](_0x1fad('0x2e'))){_0x1535cf[_0x1fad('0x10')]=qs['limit'](_0x1f2f4f[_0x1fad('0x28')][_0x1fad('0x10')]);_0x1535cf[_0x1fad('0x11')]=qs[_0x1fad('0x11')](_0x1f2f4f['query']['offset']);}_0x1535cf['order']=qs['sort'](_0x1f2f4f[_0x1fad('0x28')]['sort']);_0x1535cf[_0x1fad('0x30')]=qs[_0x1fad('0x29')](_[_0x1fad('0xb3')](_0x1f2f4f[_0x1fad('0x28')],_0x1b014a['filters']));_0x1535cf['where']['ContactId']=_0x36e44b['id'];if(_0x1f2f4f[_0x1fad('0x28')]['filter']){_0x1535cf[_0x1fad('0x30')]=_['merge'](_0x1535cf['where'],{'$or':_[_0x1fad('0x4a')](_0x1535cf['attributes'],function(_0x16e9d8){var _0x14c4ae={};_0x14c4ae[_0x16e9d8]={'$like':'%'+_0x1f2f4f[_0x1fad('0x28')][_0x1fad('0x4b')]+'%'};return _0x14c4ae;})});}_0x1535cf=_[_0x1fad('0x85')]({},_0x1535cf,_0x1f2f4f[_0x1fad('0xb4')]);return db['CmHopperFinal'][_0x1fad('0x12')]({'where':_0x1535cf[_0x1fad('0x30')]})[_0x1fad('0x15')](function(_0x4bca62){_0x67b2f7[_0x1fad('0x12')]=_0x4bca62;if(_0x1f2f4f[_0x1fad('0x28')][_0x1fad('0xb8')]){_0x1535cf[_0x1fad('0xba')]=[{'all':!![]}];}return db[_0x1fad('0x99')][_0x1fad('0x82')](_0x1535cf);})[_0x1fad('0x15')](function(_0x3665ac){_0x67b2f7['rows']=_0x3665ac;return _0x67b2f7;});}})[_0x1fad('0x15')](respondWithFilteredResult(_0x57edb9,_0x1535cf))['catch'](handleError(_0x57edb9,null));};exports[_0x1fad('0xbd')]=function(_0x4f948e,_0x270a59){var _0xb74412={'raw':!![],'where':{}};var _0x1bcd8a={};var _0x5a6491={'count':0x0,'rows':[]};return db[_0x1fad('0x6e')][_0x1fad('0x21')]({'where':{'id':_0x4f948e[_0x1fad('0x7d')]['id']}})[_0x1fad('0x15')](handleEntityNotFound(_0x270a59,null))[_0x1fad('0x15')](function(_0x2132d6){if(_0x2132d6){_0x1bcd8a['model']=_[_0x1fad('0x1d')](db['JscriptySessionReport'][_0x1fad('0xb2')]);_0x1bcd8a[_0x1fad('0x28')]=_[_0x1fad('0x1d')](_0x4f948e[_0x1fad('0x28')]);_0x1bcd8a[_0x1fad('0x29')]=_['intersection'](_0x1bcd8a[_0x1fad('0x27')],_0x1bcd8a[_0x1fad('0x28')]);_0xb74412[_0x1fad('0x2b')]=_[_0x1fad('0x2a')](_0x1bcd8a[_0x1fad('0x27')],qs['fields'](_0x4f948e[_0x1fad('0x28')][_0x1fad('0x2c')]));_0xb74412[_0x1fad('0x2b')]=_0xb74412['attributes']['length']?_0xb74412[_0x1fad('0x2b')]:_0x1bcd8a[_0x1fad('0x27')];if(!_0x4f948e[_0x1fad('0x28')][_0x1fad('0x2d')](_0x1fad('0x2e'))){_0xb74412[_0x1fad('0x10')]=qs[_0x1fad('0x10')](_0x4f948e[_0x1fad('0x28')][_0x1fad('0x10')]);_0xb74412['offset']=qs[_0x1fad('0x11')](_0x4f948e[_0x1fad('0x28')][_0x1fad('0x11')]);}_0xb74412[_0x1fad('0x61')]=qs[_0x1fad('0x2f')](_0x4f948e[_0x1fad('0x28')][_0x1fad('0x2f')]);_0xb74412['where']=qs[_0x1fad('0x29')](_[_0x1fad('0xb3')](_0x4f948e[_0x1fad('0x28')],_0x1bcd8a[_0x1fad('0x29')]));_0xb74412[_0x1fad('0x30')][_0x1fad('0xb7')]=_0x2132d6['id'];if(_0x4f948e[_0x1fad('0x28')][_0x1fad('0x4b')]){_0xb74412['where']=_['merge'](_0xb74412[_0x1fad('0x30')],{'$or':_[_0x1fad('0x4a')](_0xb74412['attributes'],function(_0x576fb2){var _0x45378b={};_0x45378b[_0x576fb2]={'$like':'%'+_0x4f948e['query'][_0x1fad('0x4b')]+'%'};return _0x45378b;})});}_0xb74412=_['merge']({},_0xb74412,_0x4f948e[_0x1fad('0xb4')]);return db[_0x1fad('0xa0')][_0x1fad('0x12')]({'where':_0xb74412[_0x1fad('0x30')]})['then'](function(_0x4eb529){_0x5a6491[_0x1fad('0x12')]=_0x4eb529;if(_0x4f948e[_0x1fad('0x28')][_0x1fad('0xb8')]){_0xb74412[_0x1fad('0xba')]=[{'all':!![]}];}return db[_0x1fad('0xa0')][_0x1fad('0x82')](_0xb74412);})['then'](function(_0x54ad73){_0x5a6491[_0x1fad('0x7a')]=_0x54ad73;return _0x5a6491;});}})[_0x1fad('0x15')](respondWithFilteredResult(_0x270a59,_0xb74412))['catch'](handleError(_0x270a59,null));};exports[_0x1fad('0xbe')]=function(_0x534b2f,_0x11b99b){try{if(!_0x534b2f['body'][_0x1fad('0x4e')]){throw new Error(_0x1fad('0xbf'));}if(!_0x534b2f['body'][_0x1fad('0xc0')]){throw new Error(_0x1fad('0xc1'));}if(!_0x534b2f[_0x1fad('0x86')][_0x1fad('0xc2')]){throw new Error(_0x1fad('0xc3'));}if(!_0x534b2f[_0x1fad('0x86')]['socket_timestamp']){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x157dec=_0x534b2f['body'][_0x1fad('0xc0')][_0x1fad('0x54')](',');var _0x3bda84=_0x534b2f[_0x1fad('0x86')][_0x1fad('0xc2')][_0x1fad('0x54')](',');if(!_0x157dec['length']||!_0x3bda84[_0x1fad('0x1c')]||_0x157dec[_0x1fad('0x1c')]!==_0x3bda84[_0x1fad('0x1c')]){throw new Error(_0x1fad('0xc4'));}_0x534b2f[_0x1fad('0x86')][_0x1fad('0x2c')]=_[_0x1fad('0xc5')](_0x157dec,_0x3bda84);if(!_0x534b2f[_0x1fad('0x86')][_0x1fad('0x2c')]['phone']){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x534b2f['body'][_0x1fad('0x2c')]['firstName']){throw new Error(_0x1fad('0xc6'));}var _0x51491c=path[_0x1fad('0xa3')](config['root'],'server/files/tmp',_0x534b2f[_0x1fad('0xc7')][_0x1fad('0xc8')]);fs[_0x1fad('0xc9')](_0x51491c,parseInt(_0x1fad('0xca'),0x8));var _0x56a1c5=require(_0x1fad('0xcb'))['fork'](path['join'](__dirname,'../../components/import/cm/csv'),[_0x51491c,_0x534b2f[_0x1fad('0x86')][_0x1fad('0xc0')],_0x534b2f[_0x1fad('0x86')][_0x1fad('0xc2')],_0x534b2f[_0x1fad('0x86')][_0x1fad('0x4e')],_0x534b2f[_0x1fad('0x86')]['CompanyId'],_0x534b2f[_0x1fad('0x86')][_0x1fad('0xa4')],_0x534b2f[_0x1fad('0x86')][_0x1fad('0xcc')]]);return _0x11b99b[_0x1fad('0x13')](0xc8)['json']({'message':_0x1fad('0xcd'),'pid':_0x56a1c5[_0x1fad('0xce')]});}catch(_0x388935){return _0x11b99b['status'](0x1f4)[_0x1fad('0xcf')](_0x388935);}};exports[_0x1fad('0xd0')]=function(_0x13b8f7,_0x1f7c9d){var _0x4e2ef3=fs[_0x1fad('0xd1')](_0x13b8f7[_0x1fad('0xc7')][_0x1fad('0x2')]);Papa[_0x1fad('0xd2')](_0x4e2ef3,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x31e7d0){return _0x1f7c9d[_0x1fad('0x13')](0xc8)[_0x1fad('0xe')]({'file':_0x13b8f7[_0x1fad('0xc7')],'fields':_0x31e7d0['meta']['fields']});}});};exports[_0x1fad('0xd3')]=function(_0x1add53,_0x9a1719){return db['User'][_0x1fad('0x82')]({'raw':!![],'attributes':['id'],'where':{'role':_0x1fad('0x67')}})['then'](function(_0x291935){var _0x38f5c8=![];if(!_0x1add53[_0x1fad('0x86')]['ListId']){throw new Error(_0x1fad('0xbf'));}if(!_0x1add53['body']['binding'][_0x1fad('0xb1')]){throw new Error(_0x1fad('0xd4'));}if(!_0x1add53[_0x1fad('0x86')]['binding'][_0x1fad('0xd5')]){throw new Error(_0x1fad('0xc6'));}if(!_0x1add53[_0x1fad('0x86')][_0x1fad('0xcc')]){throw new Error(_0x1fad('0xd6'));}var _0x3703b8=require('child_process')[_0x1fad('0xd7')](path[_0x1fad('0xa3')](__dirname,_0x1fad('0xd8')),[_0x1add53['params']['id'],JSON[_0x1fad('0xd9')](_0x1add53['body']),JSON[_0x1fad('0xd9')](_0x291935)]);_0x3703b8['on'](_0x1fad('0xda'),function(){_0x38f5c8=!![];return _0x9a1719[_0x1fad('0x13')](0xc8)[_0x1fad('0xe')]({'message':_0x1fad('0xdb'),'pid':_0x3703b8[_0x1fad('0xce')]});});_0x3703b8['on'](_0x1fad('0xdc'),function(_0x382678){if(_0x382678&&!_0x38f5c8){return _0x9a1719[_0x1fad('0x13')](0x1f4)[_0x1fad('0xe')]({'message':_0x1fad('0xdd'),'pid':_0x3703b8[_0x1fad('0xce')]});}});})[_0x1fad('0x7b')](handleError(_0x9a1719,null));};exports[_0x1fad('0xde')]=function(_0x1fdfb3,_0x59f0ca){var _0x284ab9=[_0x1fad('0xdf'),_0x1fad('0xe0'),'sms','openchannel',_0x1fad('0xe1'),_0x1fad('0xe2'),'voice'];var _0x5e8ea9={'offset':0x0,'order':qs['sort'](_0x1fad('0xe3'))},_0x18f4f8={'count':0x0,'rows':[]};Promise[_0x1fad('0xe4')]()['then'](function(){if(_0x1fdfb3[_0x1fad('0x28')][_0x1fad('0xe5')]){if(!_['includes'](_0x284ab9,_0x1fdfb3[_0x1fad('0x28')][_0x1fad('0xe5')][_0x1fad('0xe6')]())){throw new Error(_0x1fad('0xe7'));}_0x284ab9=[_0x1fdfb3[_0x1fad('0x28')]['channel'][_0x1fad('0xe6')]()];}if(_0x1fdfb3[_0x1fad('0x28')][_0x1fad('0xe8')]){try{var _0xfe6ebb=JSON['parse'](_0x1fdfb3[_0x1fad('0x28')][_0x1fad('0xe8')]);if(!moment(_0xfe6ebb[_0x1fad('0x34')])[_0x1fad('0xe9')]()){throw new Error('Invalid\x20date\x20for\x20range\x20from\x20filter');}if(!moment(_0xfe6ebb['to'])[_0x1fad('0xe9')]()){throw new Error(_0x1fad('0xea'));}}catch(_0x56cfbb){throw new Error(_0x1fad('0xeb'));}}if(!_0x1fdfb3[_0x1fad('0x28')][_0x1fad('0x2d')](_0x1fad('0x2e'))){_0x5e8ea9[_0x1fad('0x10')]=qs[_0x1fad('0x10')](_0x1fdfb3['query'][_0x1fad('0x10')]||0xa);_0x5e8ea9[_0x1fad('0x11')]=qs[_0x1fad('0x11')](_0x1fdfb3[_0x1fad('0x28')][_0x1fad('0x11')]);}var _0x12a867=_0x284ab9[_0x1fad('0x4a')](function(_0x4f766d){if(_0x4f766d===_0x1fad('0xec')){var _0x50ed85={'attributes':['id',_0x1fad('0xed'),_0x1fad('0x26'),_0x1fad('0xee'),_0x1fad('0xef'),_0x1fad('0xf0'),_0x1fad('0xf1'),_0x1fad('0xf2'),_0x1fad('0xf3'),_0x1fad('0xf4'),_0x1fad('0xf5'),_0x1fad('0xf6'),'userSecondDisposition',_0x1fad('0xf7'),_0x1fad('0xf8')],'where':{'ContactId':_0x1fdfb3['params']['id']},'include':[{'model':db['User'],'as':'User','attributes':['id',_0x1fad('0x19'),_0x1fad('0xf9'),_0x1fad('0xfa')]}],'order':[['createdAt',_0x1fad('0x62')]]};if(_0x1fdfb3[_0x1fad('0x28')][_0x1fad('0xe8')]){_0x50ed85[_0x1fad('0x30')][_0x1fad('0xf5')]={'$gte':_0xfe6ebb[_0x1fad('0x34')],'$lte':_0xfe6ebb['to']};}return db['VoiceCallReport'][_0x1fad('0xfb')](_0x50ed85)[_0x1fad('0x15')](function(_0x26e53c){_0x18f4f8[_0x1fad('0x12')]+=_0x26e53c[_0x1fad('0x12')];return _[_0x1fad('0x4a')](_0x26e53c[_0x1fad('0x7a')],function(_0x2c4ed2){var _0x4d7083=_0x2c4ed2[_0x1fad('0x87')]({'plain':!![]});_0x4d7083[_0x1fad('0xe5')]=_0x4f766d;if(_0x4d7083[_0x1fad('0x69')]){_0x4d7083[_0x1fad('0x69')]={'id':_0x4d7083[_0x1fad('0x69')]['id'],'name':_0x4d7083[_0x1fad('0x69')][_0x1fad('0x19')],'fullname':_0x4d7083[_0x1fad('0x69')][_0x1fad('0xf9')],'alias':_0x4d7083[_0x1fad('0x69')][_0x1fad('0xfa')]};}return _0x4d7083;});});}else{var _0x5e0228=_[_0x1fad('0xfc')](_0x4f766d)+(_0x4f766d===_0x1fad('0xe0')?'Website':'Account');var _0x5170df={'attributes':['id',_0x1fad('0xfd'),_0x1fad('0xfe'),'createdAt','note',_0x1fad('0xff'),_0x1fad('0x100'),_0x1fad('0x101'),'UserId',_0x5e0228+'Id'],'where':{'ContactId':_0x1fdfb3[_0x1fad('0x7d')]['id']},'include':[{'model':db[_0x5e0228],'as':_0x1fad('0x102'),'attributes':['id',_0x1fad('0x19'),'key']},{'model':db[_0x1fad('0x69')],'as':_0x1fad('0x103'),'attributes':['id',_0x1fad('0x19'),_0x1fad('0xf9')]},{'model':db[_0x1fad('0xa8')],'as':_0x1fad('0x79'),'attributes':['id',_0x1fad('0x19'),_0x1fad('0x33')],'through':{'attributes':[]}}],'order':[[_0x1fad('0xf5'),_0x1fad('0x62')]]};if(_0x1fdfb3[_0x1fad('0x28')]['range']){_0x5170df[_0x1fad('0x30')][_0x1fad('0xf5')]={'$gte':_0xfe6ebb[_0x1fad('0x34')],'$lte':_0xfe6ebb['to']};}switch(_0x4f766d){case _0x1fad('0xe0'):_0x5170df[_0x1fad('0x2b')][_0x1fad('0x1f')](_0x1fad('0x104'),_0x1fad('0x105'),'customerPort',_0x1fad('0x106'),_0x1fad('0x107'),_0x1fad('0x108'),_0x1fad('0x109'),_0x1fad('0x10a'),_0x1fad('0x10b'));break;case _0x1fad('0xdf'):_0x5170df[_0x1fad('0x2b')]['push'](_0x1fad('0x10c'),_0x1fad('0x10d'));break;case _0x1fad('0x10e'):_0x5170df[_0x1fad('0x2b')]['push'](_0x1fad('0x10f'),_0x1fad('0x110'));break;}return db[_[_0x1fad('0xfc')](_0x4f766d)+_0x1fad('0x111')][_0x1fad('0xfb')](_0x5170df)[_0x1fad('0x15')](function(_0x49466d){_0x18f4f8['count']+=_0x49466d[_0x1fad('0x12')];return _[_0x1fad('0x4a')](_0x49466d[_0x1fad('0x7a')],function(_0x1e5b9c){var _0x52291d=_0x1e5b9c['get']({'plain':!![]});_0x52291d['channel']=_0x4f766d;if(_0x52291d[_0x1fad('0x103')]){_0x52291d['Owner']={'id':_0x52291d[_0x1fad('0x103')]['id'],'name':_0x52291d[_0x1fad('0x103')][_0x1fad('0x19')],'fullname':_0x52291d['Owner']['fullname']};}return _0x52291d;});});}});return Promise[_0x1fad('0x23')](_0x12a867);})[_0x1fad('0x15')](function(_0x582b27){return _(_0x582b27)['flatten']()[_0x1fad('0x112')]('createdAt')[_0x1fad('0x113')]()[_0x1fad('0x3f')]();})[_0x1fad('0x15')](function(_0x50d02e){_0x18f4f8[_0x1fad('0x7a')]=_0x5e8ea9['limit']?_0x50d02e[_0x1fad('0x114')](_0x5e8ea9[_0x1fad('0x11')],_0x5e8ea9['offset']+_0x5e8ea9[_0x1fad('0x10')]):_0x50d02e;return _0x18f4f8;})[_0x1fad('0x15')](respondWithFilteredResult(_0x59f0ca,_0x5e8ea9))[_0x1fad('0x7b')](handleError(_0x59f0ca,null));};
\ No newline at end of file
+var _0x8260=['group','c.id','QueryTypes','SELECT','clone','DESC','t.id\x20IN\x20?','user','User','getLists','c.ListId\x20IS\x20NULL','role','agent','sequelize','toString','keyBy','CmContact','c.firstName','c.lastName','c.phone','c.fax','c.email','c.ListId','c.CompanyId','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','Tags','rows','catch','params','displayName','columnName','alias','custom','merge','body','findAll','get','isArray','tags','join','info','from','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','CmHopperFinal','ReportAgentPreview','VoiceCallReport','ChatQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappMessage','bulkCreate','each','duplicates','$or','findOrCreate','spread','format','$and','omit','cf_%d','table','cm_contacts','setFields','id\x20=\x20?','values','phone','getTags','findOne','rawAttributes','options','setTags','ids','include','getHopperHistories','CmHopperHistory','ContactId','includeAll','getHopperFinals','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20firstName\x20column\x20specified','root','file','chmodSync','child_process','fork','../../components/import/cm/csv','CompanyId','File\x20uploaded\x20correctly!','upload','createReadStream','parse','meta','import','binding','No\x20phone\x20column\x20specified','firstName','../../components/import/cm/csv2','stringify','pid','exit','error\x20child\x20process','mail','chat','openchannel','fax','whatsapp','voice','-createdAt','includes','channel','toLowerCase','Invalid\x20channel','range','isValid','Invalid\x20date\x20for\x20range\x20to\x20filter','Invalid\x20createdAt\x20filter','uniqueid','source','starttime','endtime','duration','note','createdAt','userDisposition','userSecondDisposition','userThirdDisposition','UserId','findAndCountAll','startCase','Website','closedAt','disposition','thirdDisposition','key','Owner','fullname','color','browserName','customerIp','customerPort','deviceModel','ratingMessage','ratingType','ratingValue','referer','externalUrl','sortBy','reverse','slice','moment','bluebird','util','path','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../mysqldb','defaults','redis','localhost','socket.io-emitter','status','json','offset','undefined','limit','count','set','update','then','destroy','end','sendStatus','stack','name','send','index','describe','keys','length','startsWith','cf_','CmCustomField','all','fieldType','type','query','filters','intersection','attributes','model','fields','hasOwnProperty','nolimit','order','sort','pick','field','tools_tags','select','left_join','uc.CmContactId\x20=\x20c.id','ct.CmContactId\x20=\x20c.id','t.id\x20=\x20ct.TagId','where','c.deletedAt\x20IS\x20NULL','expr','search','parseSearch','conditions','find','Tag','value','split','map','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','and','uc.UserId\x20=\x20?','dateOfBirth','datetime','castTo','DATE','buildExpression','text','start','filter','isNil','Contact','push','isEmpty','forEach','ListId','c.ListId\x20IN\x20?','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','tag','replace','getFullTextValue','c.id\x20LIKE\x20?','c.phone\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?'];(function(_0xf766d,_0x30acbc){var _0x522802=function(_0x58c285){while(--_0x58c285){_0xf766d['push'](_0xf766d['shift']());}};_0x522802(++_0x30acbc);}(_0x8260,0x1c4));var _0x0826=function(_0x7a3247,_0x15cb12){_0x7a3247=_0x7a3247-0x0;var _0x1bfde5=_0x8260[_0x7a3247];return _0x1bfde5;};'use strict';var moment=require(_0x0826('0x0'));var BPromise=require(_0x0826('0x1'));var util=require(_0x0826('0x2'));var path=require(_0x0826('0x3'));var fs=require('fs');var _=require('lodash');var squel=require('squel');var Papa=require(_0x0826('0x4'));var Redis=require(_0x0826('0x5'));var qs=require(_0x0826('0x6'));var as=require(_0x0826('0x7'));var logger=require(_0x0826('0x8'))(_0x0826('0x9'));var config=require('../../config/environment');var db=require(_0x0826('0xa'))['db'];config['redis']=_[_0x0826('0xb')](config[_0x0826('0xc')],{'host':_0x0826('0xd'),'port':0x18eb});var socket=require(_0x0826('0xe'))(new Redis(config[_0x0826('0xc')]));require('./cmContact.socket')['register'](socket);function respondWithResult(_0x17ef07,_0x2876c6){_0x2876c6=_0x2876c6||0xc8;return function(_0x128894){if(_0x128894){return _0x17ef07[_0x0826('0xf')](_0x2876c6)[_0x0826('0x10')](_0x128894);}};}function respondWithFilteredResult(_0x44daad,_0x19415d){return function(_0x2a33ba){if(_0x2a33ba){var _0x1886aa=typeof _0x19415d[_0x0826('0x11')]===_0x0826('0x12')&&typeof _0x19415d[_0x0826('0x13')]===_0x0826('0x12');var _0x200d30=_0x2a33ba[_0x0826('0x14')];var _0xa6078e=_0x1886aa?0x0:_0x19415d['offset'];var _0x4fc649=_0x1886aa?_0x2a33ba[_0x0826('0x14')]:_0x19415d[_0x0826('0x11')]+_0x19415d['limit'];var _0x2cf629;if(_0x4fc649>=_0x200d30){_0x4fc649=_0x200d30;_0x2cf629=0xc8;}else{_0x2cf629=0xce;}_0x44daad['status'](_0x2cf629);return _0x44daad[_0x0826('0x15')]('Content-Range',_0xa6078e+'-'+_0x4fc649+'/'+_0x200d30)['json'](_0x2a33ba);}return null;};}function saveUpdates(_0x521513){return function(_0x8c36e7){if(_0x8c36e7){return _0x8c36e7[_0x0826('0x16')](_0x521513)[_0x0826('0x17')](function(_0x17c0c5){return _0x17c0c5;});}return null;};}function removeEntity(_0x833421){return function(_0x1379c0){if(_0x1379c0){return _0x1379c0[_0x0826('0x18')]()['then'](function(){_0x833421['status'](0xcc)[_0x0826('0x19')]();});}};}function handleEntityNotFound(_0x52e8d1){return function(_0x3ac0bf){if(!_0x3ac0bf){_0x52e8d1[_0x0826('0x1a')](0x194);}return _0x3ac0bf;};}function handleError(_0x5c7f84,_0x36c920){_0x36c920=_0x36c920||0x1f4;return function(_0x38023f){logger['error'](_0x38023f[_0x0826('0x1b')]);if(_0x38023f[_0x0826('0x1c')]){delete _0x38023f[_0x0826('0x1c')];}_0x5c7f84['status'](_0x36c920)[_0x0826('0x1d')](_0x38023f);};}exports[_0x0826('0x1e')]=function(_0x40b4fd,_0x352b89){var _0xb53e4f={},_0x59ef70={},_0x11003d={'count':0x0,'rows':[]};return db['CmContact'][_0x0826('0x1f')]()[_0x0826('0x17')](function(_0xff48f4){var _0x14c42c=[];for(var _0x11c153=0x0;_0x11c153<Object[_0x0826('0x20')](_0xff48f4)[_0x0826('0x21')];_0x11c153++){var _0x1a0986=Object[_0x0826('0x20')](_0xff48f4)[_0x11c153];if(_[_0x0826('0x22')](_0x1a0986,_0x0826('0x23'))){_0x14c42c['push'](db[_0x0826('0x24')]['findOne']({'where':{'id':_['trimStart'](_0x1a0986,_0x0826('0x23'))},'raw':!![]}));}}return BPromise[_0x0826('0x25')](_0x14c42c)[_0x0826('0x17')](function(_0x3e9ee7){for(var _0x578bce=0x0;_0x578bce<_0x3e9ee7[_0x0826('0x21')];_0x578bce++){if(_0x3e9ee7[_0x578bce]){var _0xf1f6fe=_0x0826('0x23')+_0x3e9ee7[_0x578bce]['id'];var _0x1de699=_0xff48f4[_0xf1f6fe];_0x1de699[_0x0826('0x26')]=_0x3e9ee7[_0x578bce][_0x0826('0x27')];}}return _0xff48f4;});})[_0x0826('0x17')](function(_0x440981){_0x59ef70['model']=_[_0x0826('0x20')](_0x440981);_0x59ef70['query']=_[_0x0826('0x20')](_0x40b4fd[_0x0826('0x28')]);_0x59ef70[_0x0826('0x29')]=_[_0x0826('0x2a')](_0x59ef70['model'],_0x59ef70[_0x0826('0x28')]);_0xb53e4f[_0x0826('0x2b')]=_['intersection'](_0x59ef70[_0x0826('0x2c')],qs['fields'](_0x40b4fd[_0x0826('0x28')][_0x0826('0x2d')]));_0xb53e4f[_0x0826('0x2b')]=_0xb53e4f[_0x0826('0x2b')][_0x0826('0x21')]?_0xb53e4f['attributes']:_0x59ef70[_0x0826('0x2c')];if(!_0x40b4fd[_0x0826('0x28')][_0x0826('0x2e')](_0x0826('0x2f'))){_0xb53e4f[_0x0826('0x13')]=qs['limit'](_0x40b4fd['query'][_0x0826('0x13')]);_0xb53e4f['offset']=qs['offset'](_0x40b4fd['query'][_0x0826('0x11')]);}_0xb53e4f[_0x0826('0x30')]=qs[_0x0826('0x31')](_0x40b4fd[_0x0826('0x28')][_0x0826('0x31')]);_0xb53e4f['where']=qs[_0x0826('0x29')](_[_0x0826('0x32')](_0x40b4fd[_0x0826('0x28')],_0x59ef70[_0x0826('0x29')]),_0x440981);var _0x7ec66d=[];var _0x331ee2=squel['select']()[_0x0826('0x33')]('id')[_0x0826('0x33')](_0x0826('0x1c'))[_0x0826('0x33')]('color')['from'](_0x0826('0x34'));var _0xc633f3=squel[_0x0826('0x35')]()['from']('cm_contacts','c')[_0x0826('0x36')]('cm_user_has_contacts','uc',_0x0826('0x37'))[_0x0826('0x36')]('cm_contact_has_tags','ct',_0x0826('0x38'))[_0x0826('0x36')]('tools_tags','t',_0x0826('0x39'))[_0x0826('0x3a')](_0x0826('0x3b'));var _0x8846cb=squel[_0x0826('0x3c')]();var _0xebfdbe=[];var _0x1a38c8=squel['expr']();var _0x39ec58;if(_0x40b4fd[_0x0826('0x28')][_0x0826('0x3d')]){_0x39ec58=as[_0x0826('0x3e')](_0x40b4fd['query']['search']);var _0xb408b1=_0x39ec58['sqlOperator'];for(var _0x10bd79=0x0;_0x10bd79<_0x39ec58[_0x0826('0x3f')][_0x0826('0x21')];_0x10bd79++){var _0x313a37=_0x39ec58[_0x0826('0x3f')][_0x10bd79];var _0x407d68='c';var _0x298f18=_(_0x440981)[_0x0826('0x20')]()[_0x0826('0x40')](function(_0x40f958){return _0x40f958===_0x313a37['field'];});if(_0x298f18)_0x298f18=_0x440981[_0x313a37[_0x0826('0x33')]];if(!_0x298f18){if(_0x313a37['field']===_0x0826('0x41')){var _0x5e9dd2=_0x313a37[_0x0826('0x42')][_0x0826('0x43')](',')[_0x0826('0x44')](function(_0x175c2d){return Number(_0x175c2d);});_0x5e9dd2['forEach'](function(_0x1cfd2a){_0x1a38c8['or'](_0x0826('0x45'),'%,'+_0x1cfd2a+',%');});_0xebfdbe=_[_0x0826('0x46')](_0xebfdbe,_0x5e9dd2);}else if(_0x313a37[_0x0826('0x33')]==='User'){_0x8846cb[_0x0826('0x47')](_0x0826('0x48'),_0x313a37[_0x0826('0x42')]);}}else{if(_0x313a37['field']===_0x0826('0x49')||_0x298f18[_0x0826('0x26')]===_0x0826('0x4a'))_0x313a37[_0x0826('0x4b')]=_0x0826('0x4c');var _0x3b7d3f=as[_0x0826('0x4d')](_0x407d68,_0x298f18[_0x0826('0x27')],_0x313a37);_0x8846cb[_0xb408b1](_0x3b7d3f[_0x0826('0x4e')],_0x3b7d3f[_0x0826('0x42')][_0x0826('0x4f')],_0x3b7d3f['value']['end']);}}}else{var _0x16c42e=_(Object['keys'](_0x40b4fd['query']))['map'](function(_0x331248){return _0x440981[_0x0826('0x2e')](_0x331248)?_0x331248:undefined;})[_0x0826('0x50')](function(_0x303764){return!_[_0x0826('0x51')](_0x303764);})['value']();if(_0x40b4fd[_0x0826('0x28')][_0x0826('0x52')])_0x16c42e[_0x0826('0x53')](_0x0826('0x52'));if(!_[_0x0826('0x54')](_0x16c42e)){_0x16c42e[_0x0826('0x55')](function(_0x30aa12){if(_0x30aa12===_0x0826('0x56')){_0xc633f3[_0x0826('0x3a')](_0x0826('0x57'),[]['concat'](_0x40b4fd[_0x0826('0x28')][_0x30aa12]));}else if(_0x30aa12===_0x0826('0x52')){var _0x25c5c4='%'+_0x40b4fd[_0x0826('0x28')][_0x30aa12]+'%';_0xc633f3[_0x0826('0x3a')](_0x0826('0x58'),_0x25c5c4);}else{_0xc633f3[_0x0826('0x3a')]('c.'+_0x30aa12+_0x0826('0x59'),_0x40b4fd[_0x0826('0x28')][_0x30aa12]);}});}if(_0x40b4fd['query'][_0x0826('0x5a')]){_0xebfdbe=_['isArray'](_0x40b4fd['query']['tag'])?_0x40b4fd[_0x0826('0x28')][_0x0826('0x5a')]:new Array(_0x40b4fd['query']['tag']);_0xebfdbe[_0x0826('0x55')](function(_0x364cf3){_0x1a38c8['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x364cf3+',%');});}if(_0x40b4fd[_0x0826('0x28')]['filter']){var _0x12bca8=_0x40b4fd[_0x0826('0x28')]['filter'][_0x0826('0x5b')]('\x5c','\x5c\x5c')[_0x0826('0x5b')](/'/g,'\x27\x27');if(_0x12bca8[_0x0826('0x43')]('\x20')[_0x0826('0x21')]>0x1){_0x8846cb['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x0826('0x5c')](_0x12bca8),null);}else{if(qs['isNumeric'](_0x12bca8)){_0x8846cb['or'](_0x0826('0x5d'),_0x12bca8+'%');_0x8846cb['or'](_0x0826('0x5e'),_0x12bca8+'%');_0x8846cb['or']('c.mobile\x20LIKE\x20?',_0x12bca8+'%');_0x8846cb['or']('c.fax\x20LIKE\x20?',_0x12bca8+'%');}else if(qs[_0x0826('0x5f')](_0x12bca8)){_0x8846cb['or'](_0x0826('0x60'),_0x12bca8+'%');}else{_0x8846cb['or'](_0x0826('0x61'),'%'+_0x12bca8+'%');_0x8846cb['or']('c.lastName\x20LIKE\x20?','%'+_0x12bca8+'%');_0x8846cb['or'](_0x0826('0x60'),'%'+_0x12bca8+'%');}}}}_0xc633f3[_0x0826('0x3a')](_0x8846cb);_0xc633f3[_0x0826('0x62')](_0x0826('0x63'));var _0xd5c837={'type':db['Sequelize'][_0x0826('0x64')][_0x0826('0x65')],'raw':!![]};var _0x1f8362=_0xc633f3[_0x0826('0x66')]()[_0x0826('0x33')](_0x0826('0x63'));if(_0xb53e4f[_0x0826('0x30')]){_0xb53e4f[_0x0826('0x30')][_0x0826('0x55')](function(_0x39c00b){_0xc633f3['order']('c.'+_0x39c00b[0x0],_0x39c00b[0x1]===_0x0826('0x67')?![]:!![]);});}if(!_[_0x0826('0x54')](_0xebfdbe)){_0xc633f3['having'](_0x1a38c8);_0x1f8362[_0x0826('0x3a')](_0x0826('0x68'),_0xebfdbe);}BPromise['resolve']()[_0x0826('0x17')](function(){if(!_0x39ec58)return;if(_0x40b4fd[_0x0826('0x69')]['role']!=='agent')return;if(!_['some'](_0x39ec58[_0x0826('0x3f')],[_0x0826('0x33'),_0x0826('0x6a')])){return _0x40b4fd[_0x0826('0x69')][_0x0826('0x6b')]({'attributes':['id'],'raw':!![]})[_0x0826('0x17')](function(_0x1124b5){if(_['isEmpty'](_0x1124b5)){_0x1f8362[_0x0826('0x3a')](_0x0826('0x6c'));_0xc633f3[_0x0826('0x3a')](_0x0826('0x6c'));}else{_0x1f8362[_0x0826('0x3a')](_0x0826('0x57'),_[_0x0826('0x44')](_0x1124b5,'id'));_0xc633f3[_0x0826('0x3a')]('c.ListId\x20IN\x20?',_['map'](_0x1124b5,'id'));}});}})[_0x0826('0x17')](function(){if(_0x40b4fd[_0x0826('0x69')][_0x0826('0x6d')]===_0x0826('0x6e')&&!_0x39ec58&&!_0x40b4fd['query']['ListId'])return[];return db[_0x0826('0x6f')][_0x0826('0x28')](_0x1f8362[_0x0826('0x70')](),_0xd5c837);})[_0x0826('0x17')](function(_0x3b966c){_0x11003d[_0x0826('0x14')]=_0x3b966c[_0x0826('0x21')];if(_0x11003d[_0x0826('0x14')]===0x0)return[];return db[_0x0826('0x6f')][_0x0826('0x28')](_0x331ee2[_0x0826('0x70')](),_0xd5c837)[_0x0826('0x17')](function(_0x1a6bf7){_0x7ec66d=_[_0x0826('0x71')](_0x1a6bf7,'id');_0xd5c837=_['merge'](_0xd5c837,{'model':db[_0x0826('0x72')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x40b4fd[_0x0826('0x28')][_0x0826('0x2d')]){_0xb53e4f[_0x0826('0x2b')][_0x0826('0x55')](function(_0xade65f){_0xc633f3['field']('c.'+_0xade65f);});}else{_0xc633f3[_0x0826('0x33')](_0x0826('0x63'));_0xc633f3[_0x0826('0x33')](_0x0826('0x73'));_0xc633f3[_0x0826('0x33')](_0x0826('0x74'));_0xc633f3['field'](_0x0826('0x75'));_0xc633f3[_0x0826('0x33')]('c.mobile');_0xc633f3['field'](_0x0826('0x76'));_0xc633f3[_0x0826('0x33')](_0x0826('0x77'));_0xc633f3[_0x0826('0x33')](_0x0826('0x78'));_0xc633f3[_0x0826('0x33')]('c.createdAt');_0xc633f3[_0x0826('0x33')]('c.deletedAt');_0xc633f3[_0x0826('0x33')](_0x0826('0x79'));_0xc633f3[_0x0826('0x33')](_0x0826('0x7a'),'TagIds');}if(_0xb53e4f[_0x0826('0x13')])_0xc633f3[_0x0826('0x13')](_0xb53e4f['limit']);if(_0xb53e4f[_0x0826('0x11')])_0xc633f3['offset'](_0xb53e4f['offset']);return db[_0x0826('0x6f')][_0x0826('0x28')](_0xc633f3[_0x0826('0x70')](),_0xd5c837);});})[_0x0826('0x17')](function(_0xa1f85c){_0xa1f85c['forEach'](function(_0x3077b6){if(_0x3077b6[_0x0826('0x7b')]){_0x3077b6[_0x0826('0x7c')]=[];_0x3077b6[_0x0826('0x7b')][_0x0826('0x43')](',')['forEach'](function(_0x40981b){_0x3077b6['Tags']['push'](_0x7ec66d[_0x40981b]);});}delete _0x3077b6['TagIds'];});_0x11003d[_0x0826('0x7d')]=_0xa1f85c;return _0x11003d;})['then'](respondWithFilteredResult(_0x352b89,_0xb53e4f));})[_0x0826('0x7e')](handleError(_0x352b89,null));};exports['destroy']=function(_0x1b20a2,_0xd00ee0){return db[_0x0826('0x72')][_0x0826('0x40')]({'where':{'id':_0x1b20a2[_0x0826('0x7f')]['id']}})[_0x0826('0x17')](handleEntityNotFound(_0xd00ee0,null))['then'](removeEntity(_0xd00ee0,null))[_0x0826('0x7e')](handleError(_0xd00ee0,null));};exports[_0x0826('0x1f')]=function(_0x2ae2a4,_0xf5b915){return db['CmContact'][_0x0826('0x1f')]()[_0x0826('0x17')](function(_0x1ce3f4){delete _0x1ce3f4['tags'];for(var _0x572299=0x0;_0x572299<Object[_0x0826('0x20')](_0x1ce3f4)[_0x0826('0x21')];_0x572299++){var _0x432a26=Object[_0x0826('0x20')](_0x1ce3f4)[_0x572299];if(!_[_0x0826('0x22')](_0x432a26,_0x0826('0x23'))){_0x1ce3f4[_0x432a26]['columnName']=_0x432a26;_0x1ce3f4[_0x432a26][_0x0826('0x80')]=_0x432a26;}}return _0x1ce3f4;})[_0x0826('0x17')](function(_0x28019f){var _0x5dc842={'where':Boolean(_0x2ae2a4[_0x0826('0x28')]['analytics'])===!![]?undefined:{'$or':[{'ListId':_0x2ae2a4[_0x0826('0x28')]['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField']['findAll'](_0x5dc842)[_0x0826('0x17')](function(_0x410498){for(var _0x11498f=0x0;_0x11498f<_0x410498[_0x0826('0x21')];_0x11498f++){var _0x42841b=_0x0826('0x23')+_0x410498[_0x11498f]['id'];_0x28019f[_0x42841b][_0x0826('0x81')]=_0x42841b;_0x28019f[_0x42841b]['displayName']=_0x410498[_0x11498f][_0x0826('0x82')];_0x28019f[_0x42841b][_0x0826('0x83')]={'type':_0x410498[_0x11498f][_0x0826('0x27')],'values':_0x410498[_0x11498f]['values']};}Object[_0x0826('0x20')](_0x28019f)['forEach'](function(_0x5806eb){if(!_0x28019f[_0x5806eb][_0x0826('0x2e')]('columnName')){delete _0x28019f[_0x5806eb];}});return _0x28019f;});})[_0x0826('0x17')](respondWithResult(_0xf5b915,null))[_0x0826('0x7e')](handleError(_0xf5b915,null));};exports[_0x0826('0x84')]=function(_0x39927d,_0x591ec2){var _0x1e1063;var _0xe55aed;var _0xd9f8d6;if(_0x39927d['body']['id']){delete _0x39927d[_0x0826('0x85')]['id'];}return db['CmContact'][_0x0826('0x86')]({'where':{'id':[_0x39927d[_0x0826('0x85')]['to'],_0x39927d[_0x0826('0x85')]['from']]}})[_0x0826('0x17')](function(_0x56de43){if(_0x56de43){if(_0x56de43[_0x0826('0x21')]!==0x2){return null;}_0x56de43[0x0]=_0x56de43[0x0]['get']({'plain':!![]});_0x56de43[0x1]=_0x56de43[0x1][_0x0826('0x87')]({'plain':!![]});delete _0x56de43[0x0]['id'];delete _0x56de43[0x1]['id'];return _['mergeWith'](_0x56de43[0x0],_0x56de43[0x1],function(_0x16e132,_0x1f7be7){if(Array[_0x0826('0x88')](_0x1f7be7)&&!_0x1f7be7['length']){return _0x16e132;}else if(!_0x1f7be7){return _0x16e132;}});}})[_0x0826('0x17')](handleEntityNotFound(_0x591ec2,null))[_0x0826('0x17')](function(_0x45ebc2){if(_0x45ebc2){if(_0x45ebc2[_0x0826('0x89')]&&_[_0x0826('0x88')](_0x45ebc2[_0x0826('0x89')])){_0x45ebc2['tags']=_0x45ebc2[_0x0826('0x89')][_0x0826('0x8a')]();}logger[_0x0826('0x8b')]('[CmContact][merge]\x20to\x20%s\x20from\x20%s',_0x39927d['body']['to'],_0x39927d[_0x0826('0x85')][_0x0826('0x8c')]);return db[_0x0826('0x8d')][_0x0826('0x18')]({'where':{'ContactId':[_0x39927d[_0x0826('0x85')]['to'],_0x39927d[_0x0826('0x85')]['from']]}})[_0x0826('0x17')](function(_0x370a7a){logger[_0x0826('0x8b')](_0x0826('0x8e'),_0x370a7a);return db[_0x0826('0x8f')]['destroy']({'where':{'ContactId':[_0x39927d[_0x0826('0x85')]['to'],_0x39927d[_0x0826('0x85')]['from']]}})[_0x0826('0x17')](function(_0x338350){logger['info'](_0x0826('0x90'),_0x338350);return db[_0x0826('0x72')][_0x0826('0x91')](_0x45ebc2);});});}})[_0x0826('0x17')](function(_0x1bbebb){if(_0x1bbebb){_0x1e1063=_0x1bbebb;_0xe55aed={'ContactId':_0x1e1063['id']};_0xd9f8d6={'where':{'ContactId':[_0x39927d[_0x0826('0x85')]['to'],_0x39927d['body']['from']]}};return db[_0x0826('0x92')][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})[_0x0826('0x17')](function(){if(_0x1e1063){return db[_0x0826('0x93')][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})[_0x0826('0x17')](function(){if(_0x1e1063){return db[_0x0826('0x94')][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})[_0x0826('0x17')](function(){if(_0x1e1063){return db[_0x0826('0x95')][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})[_0x0826('0x17')](function(){if(_0x1e1063){return db[_0x0826('0x96')][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})[_0x0826('0x17')](function(){if(_0x1e1063){return db[_0x0826('0x95')][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})[_0x0826('0x17')](function(){if(_0x1e1063){return db[_0x0826('0x96')]['update'](_0xe55aed,_0xd9f8d6);}})[_0x0826('0x17')](function(){if(_0x1e1063){return db[_0x0826('0x97')][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})[_0x0826('0x17')](function(){if(_0x1e1063){return db[_0x0826('0x98')][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})[_0x0826('0x17')](function(){if(_0x1e1063){return db[_0x0826('0x99')][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})[_0x0826('0x17')](function(){if(_0x1e1063){return db[_0x0826('0x9a')]['update'](_0xe55aed,_0xd9f8d6);}})['then'](function(){if(_0x1e1063){return db[_0x0826('0x9b')][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})[_0x0826('0x17')](function(){if(_0x1e1063){return db['OpenchannelMessage']['update'](_0xe55aed,_0xd9f8d6);}})['then'](function(){if(_0x1e1063){return db[_0x0826('0x9c')][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})[_0x0826('0x17')](function(){if(_0x1e1063){return db['CmHopperHistory'][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})[_0x0826('0x17')](function(){if(_0x1e1063){return db[_0x0826('0x9d')][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})['then'](function(){if(_0x1e1063){return db[_0x0826('0x9e')]['update'](_0xe55aed,_0xd9f8d6);}})[_0x0826('0x17')](function(){if(_0x1e1063){return db[_0x0826('0x9f')][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})['then'](function(){if(_0x1e1063){return db['FaxQueueReport'][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})[_0x0826('0x17')](function(){if(_0x1e1063){return db[_0x0826('0xa0')][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})[_0x0826('0x17')](function(){if(_0x1e1063){return db[_0x0826('0xa1')][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})[_0x0826('0x17')](function(){if(_0x1e1063){return db[_0x0826('0xa2')][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})[_0x0826('0x17')](function(){if(_0x1e1063){return db[_0x0826('0xa3')][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})[_0x0826('0x17')](function(){if(_0x1e1063){return db[_0x0826('0xa4')][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})[_0x0826('0x17')](function(){if(_0x1e1063){return db[_0x0826('0xa5')][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})['then'](function(){if(_0x1e1063){return db['WhatsappQueueReport'][_0x0826('0x16')](_0xe55aed,_0xd9f8d6);}})[_0x0826('0x17')](function(){if(_0x1e1063){return db['CmContact'][_0x0826('0x18')]({'where':{'id':[_0x39927d[_0x0826('0x85')]['to'],_0x39927d[_0x0826('0x85')][_0x0826('0x8c')]]}});}})['then'](function(){if(_0x1e1063){return _0x1e1063;}})[_0x0826('0x17')](respondWithResult(_0x591ec2,null))['catch'](handleError(_0x591ec2,null));};exports[_0x0826('0x91')]=function(_0x20d189,_0x594bce){return db['CmContact']['describe']()[_0x0826('0x17')](function(_0x3943fb){if(_0x20d189[_0x0826('0x85')][_0x0826('0x89')]&&_[_0x0826('0x88')](_0x20d189['body']['tags'])){if(_0x20d189[_0x0826('0x85')][_0x0826('0x89')][_0x0826('0x21')]){_0x20d189['body'][_0x0826('0x89')]=_0x20d189[_0x0826('0x85')][_0x0826('0x89')][_0x0826('0x8a')](';')+';';}else{_0x20d189[_0x0826('0x85')][_0x0826('0x89')]=null;}}else{_0x20d189[_0x0826('0x85')][_0x0826('0x89')]=null;}return db[_0x0826('0x72')][_0x0826('0x91')](_0x20d189[_0x0826('0x85')],{'fields':_[_0x0826('0x20')](_0x3943fb),'raw':!![]});})[_0x0826('0x17')](respondWithResult(_0x594bce,0xc9))[_0x0826('0x7e')](handleError(_0x594bce,null));};exports[_0x0826('0xa6')]=function(_0x2bd342,_0x166e23){var _0x12ecc4=0x0;var _0x42206b=0x0;var _0x44c01d=0x0;return db[_0x0826('0x72')][_0x0826('0x1f')]()[_0x0826('0x17')](function(_0xfdc28e){return BPromise[_0x0826('0xa7')](_0x2bd342[_0x0826('0x85')],function(_0x585a1a){var _0x1122e2={'where':{'$or':[]},'defaults':_0x585a1a,'fields':_[_0x0826('0x20')](_0xfdc28e),'raw':!![]};if(_0x585a1a[_0x0826('0xa8')]){for(var _0x3dabc7=0x0;_0x3dabc7<_0x585a1a[_0x0826('0xa8')][_0x0826('0x21')];_0x3dabc7++){var _0x3a179e={};_0x3a179e[_0x585a1a[_0x0826('0xa8')][_0x3dabc7]]=_0x585a1a[_0x585a1a[_0x0826('0xa8')][_0x3dabc7]];_0x1122e2['where'][_0x0826('0xa9')][_0x0826('0x53')](_0x3a179e);}_0x1122e2[_0x0826('0x3a')]['ListId']=_0x585a1a[_0x0826('0x56')];}return db[_0x0826('0x72')][_0x0826('0xaa')](_0x1122e2)[_0x0826('0xab')](function(_0x206c4f,_0x521e36){if(_0x521e36){_0x12ecc4++;}else{_0x44c01d++;}})[_0x0826('0x7e')](function(){_0x42206b++;});});})[_0x0826('0x17')](function(_0x15f65a){if(_0x15f65a){return{'success':_0x12ecc4,'failure':_0x42206b,'duplicates':_0x44c01d};}})['then'](respondWithResult(_0x166e23,0xc9))[_0x0826('0x7e')](handleError(_0x166e23,null));};exports['show']=function(_0xa165fd,_0x374cda){var _0x5ada49;return db[_0x0826('0x72')][_0x0826('0x1f')]()[_0x0826('0x17')](function(_0xf002b3){return db['CmContact'][_0x0826('0x40')]({'where':{'id':_0xa165fd['params']['id']},'include':[{'model':db[_0x0826('0x41')],'as':_0x0826('0x7c'),'attributes':['id',_0x0826('0x1c'),'color'],'required':_0xa165fd[_0x0826('0x28')][_0x0826('0x5a')]?!![]:![]}],'attributes':_['keys'](_0xf002b3)});})[_0x0826('0x17')](function(_0x2301ad){if(!_['isNil'](_0x2301ad)){_0x5ada49=_0x2301ad['get']({'plain':!![]});var _0x217028={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x2301ad&&_0x2301ad[_0x0826('0x56')]){if(_0x2301ad['ListId']){_0x217028['where']['$and'][_0x0826('0x53')]({'ListId':{'$ne':_0x2301ad['ListId']}});}}return db[_0x0826('0x24')][_0x0826('0x86')](_0x217028);}})[_0x0826('0x17')](function(_0x2356b4){if(!_['isNil'](_0x2356b4)){return _['omit'](_0x5ada49,_[_0x0826('0x44')](_0x2356b4,function(_0xdd0737){return util[_0x0826('0xac')]('cf_%d',_0xdd0737['id']);}));}})['then'](handleEntityNotFound(_0x374cda,null))['then'](respondWithResult(_0x374cda,null))['catch'](handleError(_0x374cda,null));};exports[_0x0826('0x16')]=function(_0x42025f,_0x11ae28){var _0x3f6f8c;if(_0x42025f[_0x0826('0x85')]['id']){delete _0x42025f[_0x0826('0x85')]['id'];}return db[_0x0826('0x72')][_0x0826('0x40')]({'where':{'id':_0x42025f[_0x0826('0x7f')]['id']}})[_0x0826('0x17')](handleEntityNotFound(_0x11ae28,null))[_0x0826('0x17')](saveUpdates(_0x42025f['body'],null))[_0x0826('0x17')](function(_0x39c873){_0x3f6f8c=_0x39c873;var _0x15f083={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x39c873&&_0x39c873[_0x0826('0x56')]){if(_0x39c873[_0x0826('0x56')]){_0x15f083[_0x0826('0x3a')][_0x0826('0xad')][_0x0826('0x53')]({'ListId':{'$ne':_0x39c873['ListId']}});}}return db[_0x0826('0x24')][_0x0826('0x86')](_0x15f083);})[_0x0826('0x17')](function(_0x1b1395){if(_0x1b1395){return _[_0x0826('0xae')](_['pickBy'](_0x42025f['body'],function(_0x371746,_0x40598){return _[_0x0826('0x22')](_0x40598,'cf_');}),_['map'](_0x1b1395,function(_0x43b546){return util[_0x0826('0xac')](_0x0826('0xaf'),_0x43b546['id']);}));}})['then'](function(_0x32a1f5){if(_0x32a1f5&&!_[_0x0826('0x54')](_0x32a1f5)){var _0x3dfab2=squel[_0x0826('0x16')]()[_0x0826('0xb0')](_0x0826('0xb1'))[_0x0826('0xb2')](_0x32a1f5)[_0x0826('0x3a')](_0x0826('0xb3'),_0x42025f[_0x0826('0x7f')]['id'])['toParam']();return db['sequelize']['query'](_0x3dfab2[_0x0826('0x4e')],{'replacements':_0x3dfab2[_0x0826('0xb4')]});}})[_0x0826('0x17')](function(){if(_0x42025f[_0x0826('0x85')][_0x0826('0xb5')]&&_0x3f6f8c){return db[_0x0826('0x8d')][_0x0826('0x16')]({'phone':_0x42025f[_0x0826('0x85')][_0x0826('0xb5')]},{'where':{'ContactId':_0x3f6f8c['id']}});}})[_0x0826('0x17')](function(){return _0x3f6f8c;})['then'](respondWithResult(_0x11ae28,null))[_0x0826('0x7e')](handleError(_0x11ae28,null));};exports[_0x0826('0xb6')]=function(_0xad585a,_0x3c3679){var _0x7e0ce3={};var _0x1f4525={};var _0xb3b41c;var _0x5c16ba;return db[_0x0826('0x72')][_0x0826('0xb7')]({'where':{'id':_0xad585a['params']['id']}})[_0x0826('0x17')](handleEntityNotFound(_0x3c3679,null))[_0x0826('0x17')](function(_0x3a6040){if(_0x3a6040){_0xb3b41c=_0x3a6040;_0x1f4525[_0x0826('0x2c')]=_[_0x0826('0x20')](db[_0x0826('0x41')][_0x0826('0xb8')]);_0x1f4525['query']=_['keys'](_0xad585a[_0x0826('0x28')]);_0x1f4525[_0x0826('0x29')]=_[_0x0826('0x2a')](_0x1f4525[_0x0826('0x2c')],_0x1f4525[_0x0826('0x28')]);_0x7e0ce3[_0x0826('0x2b')]=_[_0x0826('0x2a')](_0x1f4525[_0x0826('0x2c')],qs[_0x0826('0x2d')](_0xad585a[_0x0826('0x28')]['fields']));_0x7e0ce3[_0x0826('0x2b')]=_0x7e0ce3[_0x0826('0x2b')][_0x0826('0x21')]?_0x7e0ce3[_0x0826('0x2b')]:_0x1f4525[_0x0826('0x2c')];_0x7e0ce3[_0x0826('0x30')]=qs[_0x0826('0x31')](_0xad585a[_0x0826('0x28')][_0x0826('0x31')]);_0x7e0ce3[_0x0826('0x3a')]=qs[_0x0826('0x29')](_[_0x0826('0x32')](_0xad585a['query'],_0x1f4525['filters']));if(_0xad585a[_0x0826('0x28')][_0x0826('0x50')]){_0x7e0ce3[_0x0826('0x3a')]=_['merge'](_0x7e0ce3[_0x0826('0x3a')],{'$or':_[_0x0826('0x44')](_0x7e0ce3[_0x0826('0x2b')],function(_0x72c3b8){var _0x3f418b={};_0x3f418b[_0x72c3b8]={'$like':'%'+_0xad585a[_0x0826('0x28')]['filter']+'%'};return _0x3f418b;})});}_0x7e0ce3=_['merge']({},_0x7e0ce3,_0xad585a[_0x0826('0xb9')]);return _0xb3b41c[_0x0826('0xb6')](_0x7e0ce3);}})[_0x0826('0x17')](function(_0x1e04d0){if(_0x1e04d0){_0x5c16ba=_0x1e04d0[_0x0826('0x21')];if(!_0xad585a[_0x0826('0x28')][_0x0826('0x2e')](_0x0826('0x2f'))){_0x7e0ce3[_0x0826('0x13')]=qs[_0x0826('0x13')](_0xad585a[_0x0826('0x28')][_0x0826('0x13')]);_0x7e0ce3['offset']=qs[_0x0826('0x11')](_0xad585a[_0x0826('0x28')][_0x0826('0x11')]);}return _0xb3b41c[_0x0826('0xb6')](_0x7e0ce3);}})[_0x0826('0x17')](function(_0x3572f2){if(_0x3572f2){return _0x3572f2?{'count':_0x5c16ba,'rows':_0x3572f2}:null;}})[_0x0826('0x17')](respondWithResult(_0x3c3679,null))['catch'](handleError(_0x3c3679,null));};exports['setTags']=function(_0x1e396b,_0x30b2ff){if(_0x1e396b['body']['id']){delete _0x1e396b[_0x0826('0x85')]['id'];}return db['CmContact'][_0x0826('0xb7')]({'where':{'id':_0x1e396b[_0x0826('0x7f')]['id']}})[_0x0826('0x17')](handleEntityNotFound(_0x30b2ff,null))['then'](function(_0x3eb6cd){if(_0x3eb6cd){return _0x3eb6cd[_0x0826('0xba')](_0x1e396b[_0x0826('0x85')][_0x0826('0xbb')]||[]);}return null;})[_0x0826('0x17')](respondWithResult(_0x30b2ff,null))['catch'](handleError(_0x30b2ff,null));};exports['getHoppers']=function(_0x53480c,_0x846cad){var _0x35eca1={'raw':![],'where':{}};var _0x1631cf={};var _0x377656={'count':0x0,'rows':[]};return db['CmContact'][_0x0826('0xb7')]({'where':{'id':_0x53480c[_0x0826('0x7f')]['id']}})[_0x0826('0x17')](handleEntityNotFound(_0x846cad,null))['then'](function(_0x3bbe4a){if(_0x3bbe4a){_0x1631cf[_0x0826('0x2c')]=_[_0x0826('0x20')](db[_0x0826('0x8d')][_0x0826('0xb8')]);_0x1631cf[_0x0826('0x28')]=_[_0x0826('0x20')](_0x53480c['query']);_0x1631cf[_0x0826('0x29')]=_[_0x0826('0x2a')](_0x1631cf[_0x0826('0x2c')],_0x1631cf[_0x0826('0x28')]);_0x35eca1['attributes']=_[_0x0826('0x2a')](_0x1631cf[_0x0826('0x2c')],qs[_0x0826('0x2d')](_0x53480c['query'][_0x0826('0x2d')]));_0x35eca1[_0x0826('0x2b')]=_0x35eca1[_0x0826('0x2b')][_0x0826('0x21')]?_0x35eca1[_0x0826('0x2b')]:_0x1631cf[_0x0826('0x2c')];if(!_0x53480c[_0x0826('0x28')][_0x0826('0x2e')]('nolimit')){_0x35eca1[_0x0826('0x13')]=qs[_0x0826('0x13')](_0x53480c['query'][_0x0826('0x13')]);_0x35eca1[_0x0826('0x11')]=qs['offset'](_0x53480c[_0x0826('0x28')]['offset']);}_0x35eca1[_0x0826('0x30')]=qs['sort'](_0x53480c['query'][_0x0826('0x31')]);_0x35eca1[_0x0826('0x3a')]=qs[_0x0826('0x29')](_[_0x0826('0x32')](_0x53480c[_0x0826('0x28')],_0x1631cf[_0x0826('0x29')]));_0x35eca1[_0x0826('0x3a')]['ContactId']=_0x3bbe4a['id'];if(_0x53480c[_0x0826('0x28')][_0x0826('0x50')]){_0x35eca1[_0x0826('0x3a')]=_['merge'](_0x35eca1[_0x0826('0x3a')],{'$or':_[_0x0826('0x44')](_0x35eca1[_0x0826('0x2b')],function(_0x4d9ee1){var _0x4b7dbb={};_0x4b7dbb[_0x4d9ee1]={'$like':'%'+_0x53480c[_0x0826('0x28')]['filter']+'%'};return _0x4b7dbb;})});}_0x35eca1=_[_0x0826('0x84')]({},_0x35eca1,_0x53480c[_0x0826('0xb9')]);return db[_0x0826('0x8d')][_0x0826('0x14')]({'where':_0x35eca1[_0x0826('0x3a')]})[_0x0826('0x17')](function(_0x6d08e3){_0x377656[_0x0826('0x14')]=_0x6d08e3;if(_0x53480c[_0x0826('0x28')]['includeAll']){_0x35eca1[_0x0826('0xbc')]=[{'all':!![]}];}return db[_0x0826('0x8d')][_0x0826('0x86')](_0x35eca1);})[_0x0826('0x17')](function(_0x4e8f24){_0x377656[_0x0826('0x7d')]=_0x4e8f24;return _0x377656;});}})[_0x0826('0x17')](respondWithFilteredResult(_0x846cad,_0x35eca1))[_0x0826('0x7e')](handleError(_0x846cad,null));};exports[_0x0826('0xbd')]=function(_0x5ea5a6,_0x425947){var _0x3bc951={'raw':!![],'where':{}};var _0x4f4ecb={};var _0x8ae524={'count':0x0,'rows':[]};return db[_0x0826('0x72')][_0x0826('0xb7')]({'where':{'id':_0x5ea5a6[_0x0826('0x7f')]['id']}})[_0x0826('0x17')](handleEntityNotFound(_0x425947,null))['then'](function(_0x955ad3){if(_0x955ad3){_0x4f4ecb[_0x0826('0x2c')]=_[_0x0826('0x20')](db[_0x0826('0xbe')][_0x0826('0xb8')]);_0x4f4ecb['query']=_['keys'](_0x5ea5a6[_0x0826('0x28')]);_0x4f4ecb['filters']=_['intersection'](_0x4f4ecb[_0x0826('0x2c')],_0x4f4ecb['query']);_0x3bc951[_0x0826('0x2b')]=_[_0x0826('0x2a')](_0x4f4ecb[_0x0826('0x2c')],qs[_0x0826('0x2d')](_0x5ea5a6[_0x0826('0x28')][_0x0826('0x2d')]));_0x3bc951['attributes']=_0x3bc951[_0x0826('0x2b')][_0x0826('0x21')]?_0x3bc951[_0x0826('0x2b')]:_0x4f4ecb[_0x0826('0x2c')];if(!_0x5ea5a6[_0x0826('0x28')]['hasOwnProperty']('nolimit')){_0x3bc951[_0x0826('0x13')]=qs[_0x0826('0x13')](_0x5ea5a6[_0x0826('0x28')][_0x0826('0x13')]);_0x3bc951[_0x0826('0x11')]=qs[_0x0826('0x11')](_0x5ea5a6[_0x0826('0x28')][_0x0826('0x11')]);}_0x3bc951[_0x0826('0x30')]=qs[_0x0826('0x31')](_0x5ea5a6[_0x0826('0x28')][_0x0826('0x31')]);_0x3bc951[_0x0826('0x3a')]=qs['filters'](_['pick'](_0x5ea5a6[_0x0826('0x28')],_0x4f4ecb[_0x0826('0x29')]));_0x3bc951[_0x0826('0x3a')][_0x0826('0xbf')]=_0x955ad3['id'];if(_0x5ea5a6[_0x0826('0x28')][_0x0826('0x50')]){_0x3bc951[_0x0826('0x3a')]=_[_0x0826('0x84')](_0x3bc951[_0x0826('0x3a')],{'$or':_[_0x0826('0x44')](_0x3bc951['attributes'],function(_0x50b45f){var _0x5861ae={};_0x5861ae[_0x50b45f]={'$like':'%'+_0x5ea5a6['query'][_0x0826('0x50')]+'%'};return _0x5861ae;})});}_0x3bc951=_[_0x0826('0x84')]({},_0x3bc951,_0x5ea5a6[_0x0826('0xb9')]);return db['CmHopperHistory']['count']({'where':_0x3bc951[_0x0826('0x3a')]})[_0x0826('0x17')](function(_0x3f66af){_0x8ae524[_0x0826('0x14')]=_0x3f66af;if(_0x5ea5a6['query'][_0x0826('0xc0')]){_0x3bc951[_0x0826('0xbc')]=[{'all':!![]}];}return db['CmHopperHistory'][_0x0826('0x86')](_0x3bc951);})[_0x0826('0x17')](function(_0x38e714){_0x8ae524[_0x0826('0x7d')]=_0x38e714;return _0x8ae524;});}})[_0x0826('0x17')](respondWithFilteredResult(_0x425947,_0x3bc951))[_0x0826('0x7e')](handleError(_0x425947,null));};exports[_0x0826('0xc1')]=function(_0x8c1367,_0x47cb70){var _0x11550d={'raw':!![],'where':{}};var _0x104f83={};var _0x109e72={'count':0x0,'rows':[]};return db['CmContact']['findOne']({'where':{'id':_0x8c1367[_0x0826('0x7f')]['id']}})[_0x0826('0x17')](handleEntityNotFound(_0x47cb70,null))[_0x0826('0x17')](function(_0x262826){if(_0x262826){_0x104f83[_0x0826('0x2c')]=_['keys'](db['CmHopperFinal']['rawAttributes']);_0x104f83[_0x0826('0x28')]=_[_0x0826('0x20')](_0x8c1367['query']);_0x104f83['filters']=_['intersection'](_0x104f83[_0x0826('0x2c')],_0x104f83['query']);_0x11550d[_0x0826('0x2b')]=_[_0x0826('0x2a')](_0x104f83[_0x0826('0x2c')],qs[_0x0826('0x2d')](_0x8c1367[_0x0826('0x28')][_0x0826('0x2d')]));_0x11550d[_0x0826('0x2b')]=_0x11550d[_0x0826('0x2b')][_0x0826('0x21')]?_0x11550d[_0x0826('0x2b')]:_0x104f83[_0x0826('0x2c')];if(!_0x8c1367['query'][_0x0826('0x2e')](_0x0826('0x2f'))){_0x11550d[_0x0826('0x13')]=qs[_0x0826('0x13')](_0x8c1367['query']['limit']);_0x11550d['offset']=qs[_0x0826('0x11')](_0x8c1367[_0x0826('0x28')][_0x0826('0x11')]);}_0x11550d['order']=qs[_0x0826('0x31')](_0x8c1367[_0x0826('0x28')][_0x0826('0x31')]);_0x11550d[_0x0826('0x3a')]=qs[_0x0826('0x29')](_[_0x0826('0x32')](_0x8c1367['query'],_0x104f83[_0x0826('0x29')]));_0x11550d[_0x0826('0x3a')][_0x0826('0xbf')]=_0x262826['id'];if(_0x8c1367[_0x0826('0x28')][_0x0826('0x50')]){_0x11550d[_0x0826('0x3a')]=_[_0x0826('0x84')](_0x11550d[_0x0826('0x3a')],{'$or':_[_0x0826('0x44')](_0x11550d[_0x0826('0x2b')],function(_0x1d9538){var _0xde0957={};_0xde0957[_0x1d9538]={'$like':'%'+_0x8c1367[_0x0826('0x28')][_0x0826('0x50')]+'%'};return _0xde0957;})});}_0x11550d=_[_0x0826('0x84')]({},_0x11550d,_0x8c1367[_0x0826('0xb9')]);return db['CmHopperFinal']['count']({'where':_0x11550d[_0x0826('0x3a')]})[_0x0826('0x17')](function(_0x471494){_0x109e72[_0x0826('0x14')]=_0x471494;if(_0x8c1367[_0x0826('0x28')][_0x0826('0xc0')]){_0x11550d[_0x0826('0xbc')]=[{'all':!![]}];}return db['CmHopperFinal']['findAll'](_0x11550d);})['then'](function(_0x4f17c5){_0x109e72[_0x0826('0x7d')]=_0x4f17c5;return _0x109e72;});}})[_0x0826('0x17')](respondWithFilteredResult(_0x47cb70,_0x11550d))[_0x0826('0x7e')](handleError(_0x47cb70,null));};exports[_0x0826('0xc2')]=function(_0x3267b1,_0x2cf44a){var _0x3ed971={'raw':!![],'where':{}};var _0xf0aebc={};var _0x36e691={'count':0x0,'rows':[]};return db[_0x0826('0x72')][_0x0826('0xb7')]({'where':{'id':_0x3267b1[_0x0826('0x7f')]['id']}})['then'](handleEntityNotFound(_0x2cf44a,null))[_0x0826('0x17')](function(_0x43db34){if(_0x43db34){_0xf0aebc[_0x0826('0x2c')]=_['keys'](db[_0x0826('0xa3')][_0x0826('0xb8')]);_0xf0aebc['query']=_[_0x0826('0x20')](_0x3267b1[_0x0826('0x28')]);_0xf0aebc[_0x0826('0x29')]=_['intersection'](_0xf0aebc[_0x0826('0x2c')],_0xf0aebc['query']);_0x3ed971['attributes']=_['intersection'](_0xf0aebc[_0x0826('0x2c')],qs[_0x0826('0x2d')](_0x3267b1[_0x0826('0x28')][_0x0826('0x2d')]));_0x3ed971['attributes']=_0x3ed971[_0x0826('0x2b')][_0x0826('0x21')]?_0x3ed971['attributes']:_0xf0aebc[_0x0826('0x2c')];if(!_0x3267b1[_0x0826('0x28')][_0x0826('0x2e')](_0x0826('0x2f'))){_0x3ed971[_0x0826('0x13')]=qs[_0x0826('0x13')](_0x3267b1[_0x0826('0x28')]['limit']);_0x3ed971['offset']=qs[_0x0826('0x11')](_0x3267b1[_0x0826('0x28')]['offset']);}_0x3ed971[_0x0826('0x30')]=qs['sort'](_0x3267b1[_0x0826('0x28')][_0x0826('0x31')]);_0x3ed971[_0x0826('0x3a')]=qs[_0x0826('0x29')](_[_0x0826('0x32')](_0x3267b1['query'],_0xf0aebc['filters']));_0x3ed971['where'][_0x0826('0xbf')]=_0x43db34['id'];if(_0x3267b1[_0x0826('0x28')][_0x0826('0x50')]){_0x3ed971[_0x0826('0x3a')]=_[_0x0826('0x84')](_0x3ed971[_0x0826('0x3a')],{'$or':_[_0x0826('0x44')](_0x3ed971[_0x0826('0x2b')],function(_0x5f5048){var _0x283c37={};_0x283c37[_0x5f5048]={'$like':'%'+_0x3267b1[_0x0826('0x28')][_0x0826('0x50')]+'%'};return _0x283c37;})});}_0x3ed971=_[_0x0826('0x84')]({},_0x3ed971,_0x3267b1[_0x0826('0xb9')]);return db[_0x0826('0xa3')]['count']({'where':_0x3ed971[_0x0826('0x3a')]})['then'](function(_0x549d51){_0x36e691[_0x0826('0x14')]=_0x549d51;if(_0x3267b1[_0x0826('0x28')][_0x0826('0xc0')]){_0x3ed971[_0x0826('0xbc')]=[{'all':!![]}];}return db[_0x0826('0xa3')][_0x0826('0x86')](_0x3ed971);})[_0x0826('0x17')](function(_0x35079c){_0x36e691['rows']=_0x35079c;return _0x36e691;});}})[_0x0826('0x17')](respondWithFilteredResult(_0x2cf44a,_0x3ed971))[_0x0826('0x7e')](handleError(_0x2cf44a,null));};exports[_0x0826('0xc3')]=function(_0x5f3ad6,_0x4c743f){try{if(!_0x5f3ad6['body'][_0x0826('0x56')]){throw new Error(_0x0826('0xc4'));}if(!_0x5f3ad6[_0x0826('0x85')][_0x0826('0xc5')]){throw new Error(_0x0826('0xc6'));}if(!_0x5f3ad6[_0x0826('0x85')][_0x0826('0xc7')]){throw new Error(_0x0826('0xc8'));}if(!_0x5f3ad6['body'][_0x0826('0xc9')]){throw new Error(_0x0826('0xca'));}var _0x3fd59a=_0x5f3ad6[_0x0826('0x85')][_0x0826('0xc5')][_0x0826('0x43')](',');var _0x477a98=_0x5f3ad6['body']['binding_values']['split'](',');if(!_0x3fd59a[_0x0826('0x21')]||!_0x477a98['length']||_0x3fd59a[_0x0826('0x21')]!==_0x477a98[_0x0826('0x21')]){throw new Error(_0x0826('0xcb'));}_0x5f3ad6['body'][_0x0826('0x2d')]=_[_0x0826('0xcc')](_0x3fd59a,_0x477a98);if(!_0x5f3ad6['body'][_0x0826('0x2d')]['phone']){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x5f3ad6[_0x0826('0x85')]['fields']['firstName']){throw new Error(_0x0826('0xcd'));}var _0x462952=path[_0x0826('0x8a')](config[_0x0826('0xce')],'server/files/tmp',_0x5f3ad6[_0x0826('0xcf')]['filename']);fs[_0x0826('0xd0')](_0x462952,parseInt('0777',0x8));var _0x59f28c=require(_0x0826('0xd1'))[_0x0826('0xd2')](path[_0x0826('0x8a')](__dirname,_0x0826('0xd3')),[_0x462952,_0x5f3ad6[_0x0826('0x85')][_0x0826('0xc5')],_0x5f3ad6[_0x0826('0x85')]['binding_values'],_0x5f3ad6[_0x0826('0x85')]['ListId'],_0x5f3ad6['body'][_0x0826('0xd4')],_0x5f3ad6['body'][_0x0826('0xa8')],_0x5f3ad6['body'][_0x0826('0xc9')]]);return _0x4c743f[_0x0826('0xf')](0xc8)[_0x0826('0x10')]({'message':_0x0826('0xd5'),'pid':_0x59f28c['pid']});}catch(_0x48ff60){return _0x4c743f['status'](0x1f4)[_0x0826('0x1d')](_0x48ff60);}};exports[_0x0826('0xd6')]=function(_0x18a0d1,_0x398dc6){var _0x2c7a8=fs[_0x0826('0xd7')](_0x18a0d1[_0x0826('0xcf')][_0x0826('0x3')]);Papa[_0x0826('0xd8')](_0x2c7a8,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x59d6a2){return _0x398dc6['status'](0xc8)[_0x0826('0x10')]({'file':_0x18a0d1[_0x0826('0xcf')],'fields':_0x59d6a2[_0x0826('0xd9')][_0x0826('0x2d')]});}});};exports[_0x0826('0xda')]=function(_0x3d24d7,_0x2958d5){return db['User'][_0x0826('0x86')]({'raw':!![],'attributes':['id'],'where':{'role':_0x0826('0x6e')}})[_0x0826('0x17')](function(_0x1f49b9){var _0x1a6a9e=![];if(!_0x3d24d7[_0x0826('0x85')][_0x0826('0x56')]){throw new Error(_0x0826('0xc4'));}if(!_0x3d24d7['body'][_0x0826('0xdb')][_0x0826('0xb5')]){throw new Error(_0x0826('0xdc'));}if(!_0x3d24d7[_0x0826('0x85')]['binding'][_0x0826('0xdd')]){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x3d24d7[_0x0826('0x85')]['socket_timestamp']){throw new Error(_0x0826('0xca'));}var _0x1dfb70=require(_0x0826('0xd1'))[_0x0826('0xd2')](path[_0x0826('0x8a')](__dirname,_0x0826('0xde')),[_0x3d24d7['params']['id'],JSON[_0x0826('0xdf')](_0x3d24d7[_0x0826('0x85')]),JSON[_0x0826('0xdf')](_0x1f49b9)]);_0x1dfb70['on']('message',function(){_0x1a6a9e=!![];return _0x2958d5['status'](0xc8)['json']({'message':'start\x20child\x20process\x20correctly!','pid':_0x1dfb70[_0x0826('0xe0')]});});_0x1dfb70['on'](_0x0826('0xe1'),function(_0x1be180){if(_0x1be180&&!_0x1a6a9e){return _0x2958d5[_0x0826('0xf')](0x1f4)['json']({'message':_0x0826('0xe2'),'pid':_0x1dfb70[_0x0826('0xe0')]});}});})['catch'](handleError(_0x2958d5,null));};exports['getJourney']=function(_0x3ad9d8,_0x1ac43c){var _0x322fdf=[_0x0826('0xe3'),_0x0826('0xe4'),'sms',_0x0826('0xe5'),_0x0826('0xe6'),_0x0826('0xe7'),_0x0826('0xe8')];var _0xc783f4={'offset':0x0,'order':qs['sort'](_0x0826('0xe9'))},_0x4deb6d={'count':0x0,'rows':[]};Promise['resolve']()['then'](function(){if(_0x3ad9d8[_0x0826('0x28')]['channel']){if(!_[_0x0826('0xea')](_0x322fdf,_0x3ad9d8['query'][_0x0826('0xeb')][_0x0826('0xec')]())){throw new Error(_0x0826('0xed'));}_0x322fdf=[_0x3ad9d8[_0x0826('0x28')][_0x0826('0xeb')][_0x0826('0xec')]()];}if(_0x3ad9d8[_0x0826('0x28')][_0x0826('0xee')]){try{var _0x5cd8ad=JSON[_0x0826('0xd8')](_0x3ad9d8[_0x0826('0x28')][_0x0826('0xee')]);if(!moment(_0x5cd8ad['from'])[_0x0826('0xef')]()){throw new Error('Invalid\x20date\x20for\x20range\x20from\x20filter');}if(!moment(_0x5cd8ad['to'])[_0x0826('0xef')]()){throw new Error(_0x0826('0xf0'));}}catch(_0xcf3473){throw new Error(_0x0826('0xf1'));}}if(!_0x3ad9d8[_0x0826('0x28')][_0x0826('0x2e')](_0x0826('0x2f'))){_0xc783f4['limit']=qs['limit'](_0x3ad9d8[_0x0826('0x28')][_0x0826('0x13')]||0xa);_0xc783f4[_0x0826('0x11')]=qs[_0x0826('0x11')](_0x3ad9d8[_0x0826('0x28')]['offset']);}var _0x1dfdc0=_0x322fdf[_0x0826('0x44')](function(_0x36ca45){if(_0x36ca45===_0x0826('0xe8')){var _0x352741={'attributes':['id',_0x0826('0xf2'),_0x0826('0x27'),_0x0826('0xf3'),'destination','callerid',_0x0826('0xf4'),_0x0826('0xf5'),_0x0826('0xf6'),_0x0826('0xf7'),_0x0826('0xf8'),_0x0826('0xf9'),_0x0826('0xfa'),_0x0826('0xfb'),_0x0826('0xfc')],'where':{'ContactId':_0x3ad9d8[_0x0826('0x7f')]['id']},'include':[{'model':db['User'],'as':'User','attributes':['id',_0x0826('0x1c'),'fullname',_0x0826('0x82')]}],'order':[['createdAt',_0x0826('0x67')]]};if(_0x3ad9d8['query']['range']){_0x352741[_0x0826('0x3a')][_0x0826('0xf8')]={'$gte':_0x5cd8ad[_0x0826('0x8c')],'$lte':_0x5cd8ad['to']};}return db[_0x0826('0x9e')][_0x0826('0xfd')](_0x352741)[_0x0826('0x17')](function(_0xc36971){_0x4deb6d[_0x0826('0x14')]+=_0xc36971[_0x0826('0x14')];return _[_0x0826('0x44')](_0xc36971[_0x0826('0x7d')],function(_0x5e272e){var _0x568e88=_0x5e272e[_0x0826('0x87')]({'plain':!![]});_0x568e88['channel']=_0x36ca45;if(_0x568e88['User']){_0x568e88[_0x0826('0x6a')]={'id':_0x568e88['User']['id'],'name':_0x568e88['User'][_0x0826('0x1c')],'fullname':_0x568e88[_0x0826('0x6a')]['fullname'],'alias':_0x568e88[_0x0826('0x6a')][_0x0826('0x82')]};}return _0x568e88;});});}else{var _0x37eedd=_[_0x0826('0xfe')](_0x36ca45)+(_0x36ca45===_0x0826('0xe4')?_0x0826('0xff'):'Account');var _0x2ad348={'attributes':['id','closed',_0x0826('0x100'),_0x0826('0xf8'),_0x0826('0xf7'),_0x0826('0x101'),'secondDisposition',_0x0826('0x102'),_0x0826('0xfc'),_0x37eedd+'Id'],'where':{'ContactId':_0x3ad9d8[_0x0826('0x7f')]['id']},'include':[{'model':db[_0x37eedd],'as':'Account','attributes':['id',_0x0826('0x1c'),_0x0826('0x103')]},{'model':db[_0x0826('0x6a')],'as':_0x0826('0x104'),'attributes':['id',_0x0826('0x1c'),_0x0826('0x105')]},{'model':db[_0x0826('0x41')],'as':_0x0826('0x7c'),'attributes':['id','name',_0x0826('0x106')],'through':{'attributes':[]}}],'order':[[_0x0826('0xf8'),_0x0826('0x67')]]};if(_0x3ad9d8['query'][_0x0826('0xee')]){_0x2ad348[_0x0826('0x3a')][_0x0826('0xf8')]={'$gte':_0x5cd8ad[_0x0826('0x8c')],'$lte':_0x5cd8ad['to']};}switch(_0x36ca45){case _0x0826('0xe4'):_0x2ad348[_0x0826('0x2b')]['push'](_0x0826('0x107'),_0x0826('0x108'),_0x0826('0x109'),_0x0826('0x10a'),'osName',_0x0826('0x10b'),_0x0826('0x10c'),_0x0826('0x10d'),_0x0826('0x10e'));break;case _0x0826('0xe3'):_0x2ad348['attributes'][_0x0826('0x53')]('subject','substatus');break;case _0x0826('0xe5'):_0x2ad348['attributes']['push'](_0x0826('0x10f'),'threadId');break;}return db[_[_0x0826('0xfe')](_0x36ca45)+'Interaction']['findAndCountAll'](_0x2ad348)[_0x0826('0x17')](function(_0x2c96aa){_0x4deb6d[_0x0826('0x14')]+=_0x2c96aa[_0x0826('0x14')];return _[_0x0826('0x44')](_0x2c96aa[_0x0826('0x7d')],function(_0x4d0d21){var _0x4115e4=_0x4d0d21[_0x0826('0x87')]({'plain':!![]});_0x4115e4[_0x0826('0xeb')]=_0x36ca45;if(_0x4115e4['Owner']){_0x4115e4[_0x0826('0x104')]={'id':_0x4115e4[_0x0826('0x104')]['id'],'name':_0x4115e4[_0x0826('0x104')][_0x0826('0x1c')],'fullname':_0x4115e4[_0x0826('0x104')]['fullname']};}return _0x4115e4;});});}});return Promise['all'](_0x1dfdc0);})[_0x0826('0x17')](function(_0x43a902){return _(_0x43a902)['flatten']()[_0x0826('0x110')](_0x0826('0xf8'))[_0x0826('0x111')]()[_0x0826('0x42')]();})[_0x0826('0x17')](function(_0x5349fb){_0x4deb6d[_0x0826('0x7d')]=_0xc783f4[_0x0826('0x13')]?_0x5349fb[_0x0826('0x112')](_0xc783f4[_0x0826('0x11')],_0xc783f4['offset']+_0xc783f4['limit']):_0x5349fb;return _0x4deb6d;})[_0x0826('0x17')](respondWithFilteredResult(_0x1ac43c,_0xc783f4))[_0x0826('0x7e')](handleError(_0x1ac43c,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff