// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xb384=['binding_values','Incorrect\x20binding\x20parameters\x20passed!','zipObject','firstName','No\x20firstName\x20column\x20specified','filename','chmodSync','0777','child_process','../../components/import/cm/csv','File\x20uploaded\x20correctly!','upload','createReadStream','file','parse','meta','import','No\x20ListId\x20specified','binding','No\x20phone\x20column\x20specified','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','fork','../../components/import/cm/csv2','stringify','message','exit','error\x20child\x20process','getJourney','mail','openchannel','fax','whatsapp','voice','channel','toLowerCase','range','isValid','Invalid\x20date\x20for\x20range\x20to\x20filter','Invalid\x20createdAt\x20filter','uniqueid','destination','callerid','starttime','endtime','duration','note','createdAt','userSecondDisposition','userThirdDisposition','UserId','fullname','findAndCountAll','startCase','chat','Website','Account','closedAt','secondDisposition','thirdDisposition','key','customerIp','deviceModel','osName','ratingMessage','ratingType','substatus','externalUrl','threadId','Interaction','Owner','all','flatten','sortBy','moment','bluebird','util','path','squel','papaparse','ioredis','../../config/logger','../../config/environment','../../mysqldb','redis','localhost','./cmContact.socket','json','offset','undefined','limit','count','Content-Range','update','then','status','error','stack','name','send','index','describe','startsWith','push','CmCustomField','findOne','cf_','length','type','model','query','filters','attributes','intersection','fields','hasOwnProperty','nolimit','order','sort','where','pick','field','color','from','select','left_join','cm_user_has_contacts','uc.CmContactId\x20=\x20c.id','ct.CmContactId\x20=\x20c.id','tools_tags','c.deletedAt\x20IS\x20NULL','expr','search','sqlOperator','conditions','keys','find','Tag','value','split','map','forEach','User','and','dateOfBirth','fieldType','datetime','castTo','buildExpression','start','filter','Contact','isEmpty','ListId','c.ListId\x20IN\x20?','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','tag','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','replace','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','c.email\x20LIKE\x20?','c.lastName\x20LIKE\x20?','group','Sequelize','QueryTypes','SELECT','clone','c.id','DESC','having','t.id\x20IN\x20?','resolve','user','role','agent','some','sequelize','toString','keyBy','CmContact','c.lastName','c.fax','c.email','c.ListId','c.createdAt','c.deletedAt','c.CompanyId','TagIds','Tags','rows','catch','destroy','params','columnName','displayName','analytics','findAll','alias','custom','values','merge','body','get','mergeWith','isArray','tags','join','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','ReportAgentPreview','VoiceCallReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','each','duplicates','$or','spread','show','isNil','omit','cf_%d','pickBy','format','table','cm_contacts','setFields','id\x20=\x20?','toParam','phone','getTags','rawAttributes','setTags','ids','getHoppers','ContactId','options','includeAll','include','CmHopperHistory','getHopperFinals','CmHopperFinal','getJscriptySessions','uploadCsv','binding_keys','No\x20association\x20keys\x20specified!','No\x20association\x20values\x20specified!','socket_timestamp'];(function(_0xd8c9a8,_0x4e4005){var _0x5488cc=function(_0x44ff67){while(--_0x44ff67){_0xd8c9a8['push'](_0xd8c9a8['shift']());}};_0x5488cc(++_0x4e4005);}(_0xb384,0x154));var _0x4b38=function(_0x2da5f4,_0x23dd9e){_0x2da5f4=_0x2da5f4-0x0;var _0x36fa0d=_0xb384[_0x2da5f4];return _0x36fa0d;};'use strict';var moment=require(_0x4b38('0x0'));var BPromise=require(_0x4b38('0x1'));var util=require(_0x4b38('0x2'));var path=require(_0x4b38('0x3'));var fs=require('fs');var _=require('lodash');var squel=require(_0x4b38('0x4'));var Papa=require(_0x4b38('0x5'));var Redis=require(_0x4b38('0x6'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var logger=require(_0x4b38('0x7'))('api');var config=require(_0x4b38('0x8'));var db=require(_0x4b38('0x9'))['db'];config[_0x4b38('0xa')]=_['defaults'](config[_0x4b38('0xa')],{'host':_0x4b38('0xb'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x4b38('0xa')]));require(_0x4b38('0xc'))['register'](socket);function respondWithResult(_0x5a8fd6,_0x3c11b5){_0x3c11b5=_0x3c11b5||0xc8;return function(_0x57af0e){if(_0x57af0e){return _0x5a8fd6['status'](_0x3c11b5)[_0x4b38('0xd')](_0x57af0e);}};}function respondWithFilteredResult(_0x1e1a93,_0x99d907){return function(_0x93b717){if(_0x93b717){var _0x31308b=typeof _0x99d907[_0x4b38('0xe')]===_0x4b38('0xf')&&typeof _0x99d907[_0x4b38('0x10')]===_0x4b38('0xf');var _0xa898d=_0x93b717[_0x4b38('0x11')];var _0x5dab49=_0x31308b?0x0:_0x99d907['offset'];var _0x2fb78c=_0x31308b?_0x93b717['count']:_0x99d907[_0x4b38('0xe')]+_0x99d907['limit'];var _0x4e14c6;if(_0x2fb78c>=_0xa898d){_0x2fb78c=_0xa898d;_0x4e14c6=0xc8;}else{_0x4e14c6=0xce;}_0x1e1a93['status'](_0x4e14c6);return _0x1e1a93['set'](_0x4b38('0x12'),_0x5dab49+'-'+_0x2fb78c+'/'+_0xa898d)['json'](_0x93b717);}return null;};}function saveUpdates(_0x52e411){return function(_0x1a2b1a){if(_0x1a2b1a){return _0x1a2b1a[_0x4b38('0x13')](_0x52e411)[_0x4b38('0x14')](function(_0x30a363){return _0x30a363;});}return null;};}function removeEntity(_0x588fc8){return function(_0x3f2587){if(_0x3f2587){return _0x3f2587['destroy']()[_0x4b38('0x14')](function(){_0x588fc8[_0x4b38('0x15')](0xcc)['end']();});}};}function handleEntityNotFound(_0x4f9b0c){return function(_0x1c7e88){if(!_0x1c7e88){_0x4f9b0c['sendStatus'](0x194);}return _0x1c7e88;};}function handleError(_0x527a2e,_0x296d4f){_0x296d4f=_0x296d4f||0x1f4;return function(_0x2d6e7a){logger[_0x4b38('0x16')](_0x2d6e7a[_0x4b38('0x17')]);if(_0x2d6e7a['name']){delete _0x2d6e7a[_0x4b38('0x18')];}_0x527a2e['status'](_0x296d4f)[_0x4b38('0x19')](_0x2d6e7a);};}exports[_0x4b38('0x1a')]=function(_0xcbff5,_0x4061d5){var _0x46fd57={},_0x1638da={},_0x35b24b={'count':0x0,'rows':[]};return db['CmContact'][_0x4b38('0x1b')]()[_0x4b38('0x14')](function(_0x544514){var _0xfb76a2=[];for(var _0x388722=0x0;_0x388722<Object['keys'](_0x544514)['length'];_0x388722++){var _0x5ae3a4=Object['keys'](_0x544514)[_0x388722];if(_[_0x4b38('0x1c')](_0x5ae3a4,'cf_')){_0xfb76a2[_0x4b38('0x1d')](db[_0x4b38('0x1e')][_0x4b38('0x1f')]({'where':{'id':_['trimStart'](_0x5ae3a4,_0x4b38('0x20'))},'raw':!![]}));}}return BPromise['all'](_0xfb76a2)[_0x4b38('0x14')](function(_0x3e2c15){for(var _0xc36ec=0x0;_0xc36ec<_0x3e2c15[_0x4b38('0x21')];_0xc36ec++){if(_0x3e2c15[_0xc36ec]){var _0x20e8e0=_0x4b38('0x20')+_0x3e2c15[_0xc36ec]['id'];var _0x1dbf5d=_0x544514[_0x20e8e0];_0x1dbf5d['fieldType']=_0x3e2c15[_0xc36ec][_0x4b38('0x22')];}}return _0x544514;});})['then'](function(_0x5ecde7){_0x1638da[_0x4b38('0x23')]=_['keys'](_0x5ecde7);_0x1638da[_0x4b38('0x24')]=_['keys'](_0xcbff5['query']);_0x1638da[_0x4b38('0x25')]=_['intersection'](_0x1638da[_0x4b38('0x23')],_0x1638da[_0x4b38('0x24')]);_0x46fd57[_0x4b38('0x26')]=_[_0x4b38('0x27')](_0x1638da['model'],qs[_0x4b38('0x28')](_0xcbff5['query'][_0x4b38('0x28')]));_0x46fd57[_0x4b38('0x26')]=_0x46fd57[_0x4b38('0x26')][_0x4b38('0x21')]?_0x46fd57[_0x4b38('0x26')]:_0x1638da['model'];if(!_0xcbff5[_0x4b38('0x24')][_0x4b38('0x29')](_0x4b38('0x2a'))){_0x46fd57[_0x4b38('0x10')]=qs[_0x4b38('0x10')](_0xcbff5['query'][_0x4b38('0x10')]);_0x46fd57[_0x4b38('0xe')]=qs[_0x4b38('0xe')](_0xcbff5[_0x4b38('0x24')]['offset']);}_0x46fd57[_0x4b38('0x2b')]=qs[_0x4b38('0x2c')](_0xcbff5[_0x4b38('0x24')][_0x4b38('0x2c')]);_0x46fd57[_0x4b38('0x2d')]=qs[_0x4b38('0x25')](_[_0x4b38('0x2e')](_0xcbff5[_0x4b38('0x24')],_0x1638da[_0x4b38('0x25')]),_0x5ecde7);var _0xe215bd=[];var _0x2088f2=squel['select']()[_0x4b38('0x2f')]('id')[_0x4b38('0x2f')](_0x4b38('0x18'))['field'](_0x4b38('0x30'))[_0x4b38('0x31')]('tools_tags');var _0x502a24=squel[_0x4b38('0x32')]()[_0x4b38('0x31')]('cm_contacts','c')[_0x4b38('0x33')](_0x4b38('0x34'),'uc',_0x4b38('0x35'))[_0x4b38('0x33')]('cm_contact_has_tags','ct',_0x4b38('0x36'))[_0x4b38('0x33')](_0x4b38('0x37'),'t','t.id\x20=\x20ct.TagId')['where'](_0x4b38('0x38'));var _0x3d8a60=squel[_0x4b38('0x39')]();var _0x5a345d=[];var _0x25e7eb=squel[_0x4b38('0x39')]();var _0x821815;if(_0xcbff5[_0x4b38('0x24')][_0x4b38('0x3a')]){_0x821815=as['parseSearch'](_0xcbff5[_0x4b38('0x24')][_0x4b38('0x3a')]);var _0x3ca226=_0x821815[_0x4b38('0x3b')];for(var _0x250c0e=0x0;_0x250c0e<_0x821815['conditions'][_0x4b38('0x21')];_0x250c0e++){var _0x43d468=_0x821815[_0x4b38('0x3c')][_0x250c0e];var _0xfb1b91='c';var _0x3166d0=_(_0x5ecde7)[_0x4b38('0x3d')]()[_0x4b38('0x3e')](function(_0x18e7a3){return _0x18e7a3===_0x43d468[_0x4b38('0x2f')];});if(_0x3166d0)_0x3166d0=_0x5ecde7[_0x43d468[_0x4b38('0x2f')]];if(!_0x3166d0){if(_0x43d468['field']===_0x4b38('0x3f')){var _0x487367=_0x43d468[_0x4b38('0x40')][_0x4b38('0x41')](',')[_0x4b38('0x42')](function(_0x5e63f1){return Number(_0x5e63f1);});_0x487367[_0x4b38('0x43')](function(_0x1672a2){_0x25e7eb['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x1672a2+',%');});_0x5a345d=_['union'](_0x5a345d,_0x487367);}else if(_0x43d468[_0x4b38('0x2f')]===_0x4b38('0x44')){_0x3d8a60[_0x4b38('0x45')]('uc.UserId\x20=\x20?',_0x43d468[_0x4b38('0x40')]);}}else{if(_0x43d468[_0x4b38('0x2f')]===_0x4b38('0x46')||_0x3166d0[_0x4b38('0x47')]===_0x4b38('0x48'))_0x43d468[_0x4b38('0x49')]='DATE';var _0x3890e9=as[_0x4b38('0x4a')](_0xfb1b91,_0x3166d0[_0x4b38('0x22')],_0x43d468);_0x3d8a60[_0x3ca226](_0x3890e9['text'],_0x3890e9[_0x4b38('0x40')][_0x4b38('0x4b')],_0x3890e9[_0x4b38('0x40')]['end']);}}}else{var _0x2fde7f=_(Object['keys'](_0xcbff5[_0x4b38('0x24')]))[_0x4b38('0x42')](function(_0x49706e){return _0x5ecde7[_0x4b38('0x29')](_0x49706e)?_0x49706e:undefined;})[_0x4b38('0x4c')](function(_0x27dd95){return!_['isNil'](_0x27dd95);})[_0x4b38('0x40')]();if(_0xcbff5[_0x4b38('0x24')][_0x4b38('0x4d')])_0x2fde7f['push']('Contact');if(!_[_0x4b38('0x4e')](_0x2fde7f)){_0x2fde7f[_0x4b38('0x43')](function(_0x23d115){if(_0x23d115===_0x4b38('0x4f')){_0x502a24[_0x4b38('0x2d')](_0x4b38('0x50'),[][_0x4b38('0x51')](_0xcbff5[_0x4b38('0x24')][_0x23d115]));}else if(_0x23d115===_0x4b38('0x4d')){var _0x284c50='%'+_0xcbff5[_0x4b38('0x24')][_0x23d115]+'%';_0x502a24[_0x4b38('0x2d')](_0x4b38('0x52'),_0x284c50);}else{_0x502a24[_0x4b38('0x2d')]('c.'+_0x23d115+_0x4b38('0x53'),_0xcbff5[_0x4b38('0x24')][_0x23d115]);}});}if(_0xcbff5[_0x4b38('0x24')][_0x4b38('0x54')]){_0x5a345d=_['isArray'](_0xcbff5['query'][_0x4b38('0x54')])?_0xcbff5[_0x4b38('0x24')]['tag']:new Array(_0xcbff5[_0x4b38('0x24')]['tag']);_0x5a345d[_0x4b38('0x43')](function(_0x2a6356){_0x25e7eb['or'](_0x4b38('0x55'),'%,'+_0x2a6356+',%');});}if(_0xcbff5[_0x4b38('0x24')][_0x4b38('0x4c')]){var _0x40f0dc=_0xcbff5[_0x4b38('0x24')]['filter'][_0x4b38('0x56')]('\x5c','\x5c\x5c')[_0x4b38('0x56')](/'/g,'\x27\x27');if(_0x40f0dc['split']('\x20')['length']>0x1){_0x3d8a60['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x40f0dc),null);}else{if(qs['isNumeric'](_0x40f0dc)){_0x3d8a60['or']('c.id\x20LIKE\x20?',_0x40f0dc+'%');_0x3d8a60['or'](_0x4b38('0x57'),_0x40f0dc+'%');_0x3d8a60['or'](_0x4b38('0x58'),_0x40f0dc+'%');_0x3d8a60['or'](_0x4b38('0x59'),_0x40f0dc+'%');}else if(qs['isEmail'](_0x40f0dc)){_0x3d8a60['or'](_0x4b38('0x5a'),_0x40f0dc+'%');}else{_0x3d8a60['or']('c.firstName\x20LIKE\x20?','%'+_0x40f0dc+'%');_0x3d8a60['or'](_0x4b38('0x5b'),'%'+_0x40f0dc+'%');_0x3d8a60['or'](_0x4b38('0x5a'),'%'+_0x40f0dc+'%');}}}}_0x502a24[_0x4b38('0x2d')](_0x3d8a60);_0x502a24[_0x4b38('0x5c')]('c.id');var _0x15c5b6={'type':db[_0x4b38('0x5d')][_0x4b38('0x5e')][_0x4b38('0x5f')],'raw':!![]};var _0x3faeaf=_0x502a24[_0x4b38('0x60')]()[_0x4b38('0x2f')](_0x4b38('0x61'));if(_0x46fd57[_0x4b38('0x2b')]){_0x46fd57[_0x4b38('0x2b')][_0x4b38('0x43')](function(_0x1258cc){_0x502a24['order']('c.'+_0x1258cc[0x0],_0x1258cc[0x1]===_0x4b38('0x62')?![]:!![]);});}if(!_[_0x4b38('0x4e')](_0x5a345d)){_0x502a24[_0x4b38('0x63')](_0x25e7eb);_0x3faeaf[_0x4b38('0x2d')](_0x4b38('0x64'),_0x5a345d);}BPromise[_0x4b38('0x65')]()[_0x4b38('0x14')](function(){if(!_0x821815)return;if(_0xcbff5[_0x4b38('0x66')][_0x4b38('0x67')]!==_0x4b38('0x68'))return;if(!_[_0x4b38('0x69')](_0x821815[_0x4b38('0x3c')],[_0x4b38('0x2f'),_0x4b38('0x44')])){return _0xcbff5[_0x4b38('0x66')]['getLists']({'attributes':['id'],'raw':!![]})[_0x4b38('0x14')](function(_0x188e3d){if(_[_0x4b38('0x4e')](_0x188e3d)){_0x3faeaf[_0x4b38('0x2d')]('c.ListId\x20IS\x20NULL');_0x502a24[_0x4b38('0x2d')]('c.ListId\x20IS\x20NULL');}else{_0x3faeaf[_0x4b38('0x2d')]('c.ListId\x20IN\x20?',_[_0x4b38('0x42')](_0x188e3d,'id'));_0x502a24[_0x4b38('0x2d')](_0x4b38('0x50'),_[_0x4b38('0x42')](_0x188e3d,'id'));}});}})['then'](function(){if(_0xcbff5[_0x4b38('0x66')][_0x4b38('0x67')]==='agent'&&!_0x821815&&!_0xcbff5['query']['ListId'])return[];return db[_0x4b38('0x6a')][_0x4b38('0x24')](_0x3faeaf[_0x4b38('0x6b')](),_0x15c5b6);})[_0x4b38('0x14')](function(_0x254a67){_0x35b24b[_0x4b38('0x11')]=_0x254a67[_0x4b38('0x21')];if(_0x35b24b[_0x4b38('0x11')]===0x0)return[];return db['sequelize'][_0x4b38('0x24')](_0x2088f2[_0x4b38('0x6b')](),_0x15c5b6)[_0x4b38('0x14')](function(_0x14f0ed){_0xe215bd=_[_0x4b38('0x6c')](_0x14f0ed,'id');_0x15c5b6=_['merge'](_0x15c5b6,{'model':db[_0x4b38('0x6d')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0xcbff5[_0x4b38('0x24')][_0x4b38('0x28')]){_0x46fd57['attributes']['forEach'](function(_0x3dba94){_0x502a24[_0x4b38('0x2f')]('c.'+_0x3dba94);});}else{_0x502a24[_0x4b38('0x2f')]('c.id');_0x502a24[_0x4b38('0x2f')]('c.firstName');_0x502a24[_0x4b38('0x2f')](_0x4b38('0x6e'));_0x502a24[_0x4b38('0x2f')]('c.phone');_0x502a24[_0x4b38('0x2f')]('c.mobile');_0x502a24[_0x4b38('0x2f')](_0x4b38('0x6f'));_0x502a24[_0x4b38('0x2f')](_0x4b38('0x70'));_0x502a24[_0x4b38('0x2f')](_0x4b38('0x71'));_0x502a24[_0x4b38('0x2f')](_0x4b38('0x72'));_0x502a24[_0x4b38('0x2f')](_0x4b38('0x73'));_0x502a24[_0x4b38('0x2f')](_0x4b38('0x74'));_0x502a24[_0x4b38('0x2f')]('GROUP_CONCAT(DISTINCT\x20t.id)',_0x4b38('0x75'));}if(_0x46fd57[_0x4b38('0x10')])_0x502a24[_0x4b38('0x10')](_0x46fd57[_0x4b38('0x10')]);if(_0x46fd57['offset'])_0x502a24['offset'](_0x46fd57[_0x4b38('0xe')]);return db['sequelize']['query'](_0x502a24[_0x4b38('0x6b')](),_0x15c5b6);});})[_0x4b38('0x14')](function(_0x185ac9){_0x185ac9[_0x4b38('0x43')](function(_0x55ca13){if(_0x55ca13['TagIds']){_0x55ca13[_0x4b38('0x76')]=[];_0x55ca13[_0x4b38('0x75')][_0x4b38('0x41')](',')[_0x4b38('0x43')](function(_0x257571){_0x55ca13[_0x4b38('0x76')][_0x4b38('0x1d')](_0xe215bd[_0x257571]);});}delete _0x55ca13[_0x4b38('0x75')];});_0x35b24b[_0x4b38('0x77')]=_0x185ac9;return _0x35b24b;})[_0x4b38('0x14')](respondWithFilteredResult(_0x4061d5,_0x46fd57));})[_0x4b38('0x78')](handleError(_0x4061d5,null));};exports[_0x4b38('0x79')]=function(_0x281015,_0x3af377){return db[_0x4b38('0x6d')]['find']({'where':{'id':_0x281015[_0x4b38('0x7a')]['id']}})[_0x4b38('0x14')](handleEntityNotFound(_0x3af377,null))[_0x4b38('0x14')](removeEntity(_0x3af377,null))['catch'](handleError(_0x3af377,null));};exports['describe']=function(_0x4c4ed6,_0x24dfee){return db[_0x4b38('0x6d')][_0x4b38('0x1b')]()[_0x4b38('0x14')](function(_0x2fe65c){delete _0x2fe65c['tags'];for(var _0x5db26b=0x0;_0x5db26b<Object[_0x4b38('0x3d')](_0x2fe65c)[_0x4b38('0x21')];_0x5db26b++){var _0x54dca7=Object[_0x4b38('0x3d')](_0x2fe65c)[_0x5db26b];if(!_[_0x4b38('0x1c')](_0x54dca7,_0x4b38('0x20'))){_0x2fe65c[_0x54dca7][_0x4b38('0x7b')]=_0x54dca7;_0x2fe65c[_0x54dca7][_0x4b38('0x7c')]=_0x54dca7;}}return _0x2fe65c;})[_0x4b38('0x14')](function(_0x2ffc7d){var _0x4e5f21={'where':Boolean(_0x4c4ed6['query'][_0x4b38('0x7d')])===!![]?undefined:{'$or':[{'ListId':_0x4c4ed6[_0x4b38('0x24')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x4b38('0x1e')][_0x4b38('0x7e')](_0x4e5f21)[_0x4b38('0x14')](function(_0x15fed1){for(var _0x161c6e=0x0;_0x161c6e<_0x15fed1[_0x4b38('0x21')];_0x161c6e++){var _0x4d561e=_0x4b38('0x20')+_0x15fed1[_0x161c6e]['id'];_0x2ffc7d[_0x4d561e][_0x4b38('0x7b')]=_0x4d561e;_0x2ffc7d[_0x4d561e]['displayName']=_0x15fed1[_0x161c6e][_0x4b38('0x7f')];_0x2ffc7d[_0x4d561e][_0x4b38('0x80')]={'type':_0x15fed1[_0x161c6e][_0x4b38('0x22')],'values':_0x15fed1[_0x161c6e][_0x4b38('0x81')]};}Object[_0x4b38('0x3d')](_0x2ffc7d)[_0x4b38('0x43')](function(_0x1fa424){if(!_0x2ffc7d[_0x1fa424][_0x4b38('0x29')](_0x4b38('0x7b'))){delete _0x2ffc7d[_0x1fa424];}});return _0x2ffc7d;});})['then'](respondWithResult(_0x24dfee,null))[_0x4b38('0x78')](handleError(_0x24dfee,null));};exports[_0x4b38('0x82')]=function(_0x59bc30,_0x37ec67){var _0x23460c;var _0x2f5a15;var _0xabafe6;if(_0x59bc30['body']['id']){delete _0x59bc30[_0x4b38('0x83')]['id'];}return db[_0x4b38('0x6d')][_0x4b38('0x7e')]({'where':{'id':[_0x59bc30[_0x4b38('0x83')]['to'],_0x59bc30[_0x4b38('0x83')][_0x4b38('0x31')]]}})[_0x4b38('0x14')](function(_0x1694e3){if(_0x1694e3){if(_0x1694e3['length']!==0x2){return null;}_0x1694e3[0x0]=_0x1694e3[0x0]['get']({'plain':!![]});_0x1694e3[0x1]=_0x1694e3[0x1][_0x4b38('0x84')]({'plain':!![]});delete _0x1694e3[0x0]['id'];delete _0x1694e3[0x1]['id'];return _[_0x4b38('0x85')](_0x1694e3[0x0],_0x1694e3[0x1],function(_0x44447f,_0x3f5524){if(Array[_0x4b38('0x86')](_0x3f5524)&&!_0x3f5524['length']){return _0x44447f;}else if(!_0x3f5524){return _0x44447f;}});}})[_0x4b38('0x14')](handleEntityNotFound(_0x37ec67,null))[_0x4b38('0x14')](function(_0x75ea43){if(_0x75ea43){if(_0x75ea43[_0x4b38('0x87')]&&_[_0x4b38('0x86')](_0x75ea43['tags'])){_0x75ea43[_0x4b38('0x87')]=_0x75ea43['tags'][_0x4b38('0x88')]();}logger[_0x4b38('0x89')](_0x4b38('0x8a'),_0x59bc30['body']['to'],_0x59bc30[_0x4b38('0x83')][_0x4b38('0x31')]);return db[_0x4b38('0x8b')][_0x4b38('0x79')]({'where':{'ContactId':[_0x59bc30[_0x4b38('0x83')]['to'],_0x59bc30[_0x4b38('0x83')][_0x4b38('0x31')]]}})[_0x4b38('0x14')](function(_0x5b719b){logger[_0x4b38('0x89')](_0x4b38('0x8c'),_0x5b719b);return db[_0x4b38('0x8d')][_0x4b38('0x79')]({'where':{'ContactId':[_0x59bc30[_0x4b38('0x83')]['to'],_0x59bc30[_0x4b38('0x83')]['from']]}})[_0x4b38('0x14')](function(_0x48ad47){logger[_0x4b38('0x89')]('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x48ad47);return db[_0x4b38('0x6d')][_0x4b38('0x8e')](_0x75ea43);});});}})[_0x4b38('0x14')](function(_0x42877f){if(_0x42877f){_0x23460c=_0x42877f;_0x2f5a15={'ContactId':_0x23460c['id']};_0xabafe6={'where':{'ContactId':[_0x59bc30[_0x4b38('0x83')]['to'],_0x59bc30[_0x4b38('0x83')][_0x4b38('0x31')]]}};return db[_0x4b38('0x8f')]['update'](_0x2f5a15,_0xabafe6);}})[_0x4b38('0x14')](function(){if(_0x23460c){return db[_0x4b38('0x90')]['update'](_0x2f5a15,_0xabafe6);}})[_0x4b38('0x14')](function(){if(_0x23460c){return db[_0x4b38('0x91')][_0x4b38('0x13')](_0x2f5a15,_0xabafe6);}})[_0x4b38('0x14')](function(){if(_0x23460c){return db[_0x4b38('0x92')][_0x4b38('0x13')](_0x2f5a15,_0xabafe6);}})[_0x4b38('0x14')](function(){if(_0x23460c){return db[_0x4b38('0x93')][_0x4b38('0x13')](_0x2f5a15,_0xabafe6);}})['then'](function(){if(_0x23460c){return db['MailInteraction']['update'](_0x2f5a15,_0xabafe6);}})[_0x4b38('0x14')](function(){if(_0x23460c){return db[_0x4b38('0x93')][_0x4b38('0x13')](_0x2f5a15,_0xabafe6);}})[_0x4b38('0x14')](function(){if(_0x23460c){return db[_0x4b38('0x94')]['update'](_0x2f5a15,_0xabafe6);}})[_0x4b38('0x14')](function(){if(_0x23460c){return db['SmsMessage'][_0x4b38('0x13')](_0x2f5a15,_0xabafe6);}})[_0x4b38('0x14')](function(){if(_0x23460c){return db['FaxInteraction'][_0x4b38('0x13')](_0x2f5a15,_0xabafe6);}})['then'](function(){if(_0x23460c){return db[_0x4b38('0x95')][_0x4b38('0x13')](_0x2f5a15,_0xabafe6);}})['then'](function(){if(_0x23460c){return db[_0x4b38('0x96')][_0x4b38('0x13')](_0x2f5a15,_0xabafe6);}})[_0x4b38('0x14')](function(){if(_0x23460c){return db[_0x4b38('0x97')][_0x4b38('0x13')](_0x2f5a15,_0xabafe6);}})['then'](function(){if(_0x23460c){return db['CmHopperFinal']['update'](_0x2f5a15,_0xabafe6);}})[_0x4b38('0x14')](function(){if(_0x23460c){return db['CmHopperHistory'][_0x4b38('0x13')](_0x2f5a15,_0xabafe6);}})['then'](function(){if(_0x23460c){return db[_0x4b38('0x98')][_0x4b38('0x13')](_0x2f5a15,_0xabafe6);}})[_0x4b38('0x14')](function(){if(_0x23460c){return db[_0x4b38('0x99')][_0x4b38('0x13')](_0x2f5a15,_0xabafe6);}})[_0x4b38('0x14')](function(){if(_0x23460c){return db['ChatQueueReport'][_0x4b38('0x13')](_0x2f5a15,_0xabafe6);}})[_0x4b38('0x14')](function(){if(_0x23460c){return db[_0x4b38('0x9a')]['update'](_0x2f5a15,_0xabafe6);}})[_0x4b38('0x14')](function(){if(_0x23460c){return db[_0x4b38('0x9b')]['update'](_0x2f5a15,_0xabafe6);}})[_0x4b38('0x14')](function(){if(_0x23460c){return db[_0x4b38('0x9c')]['update'](_0x2f5a15,_0xabafe6);}})['then'](function(){if(_0x23460c){return db[_0x4b38('0x9d')][_0x4b38('0x13')](_0x2f5a15,_0xabafe6);}})[_0x4b38('0x14')](function(){if(_0x23460c){return db[_0x4b38('0x9e')][_0x4b38('0x13')](_0x2f5a15,_0xabafe6);}})[_0x4b38('0x14')](function(){if(_0x23460c){return db[_0x4b38('0x9f')]['update'](_0x2f5a15,_0xabafe6);}})[_0x4b38('0x14')](function(){if(_0x23460c){return db['WhatsappMessage']['update'](_0x2f5a15,_0xabafe6);}})[_0x4b38('0x14')](function(){if(_0x23460c){return db['WhatsappQueueReport'][_0x4b38('0x13')](_0x2f5a15,_0xabafe6);}})[_0x4b38('0x14')](function(){if(_0x23460c){return db['CmContact']['destroy']({'where':{'id':[_0x59bc30[_0x4b38('0x83')]['to'],_0x59bc30[_0x4b38('0x83')][_0x4b38('0x31')]]}});}})[_0x4b38('0x14')](function(){if(_0x23460c){return _0x23460c;}})[_0x4b38('0x14')](respondWithResult(_0x37ec67,null))[_0x4b38('0x78')](handleError(_0x37ec67,null));};exports[_0x4b38('0x8e')]=function(_0x40db84,_0x2abde1){return db[_0x4b38('0x6d')][_0x4b38('0x1b')]()[_0x4b38('0x14')](function(_0x48c32d){if(_0x40db84[_0x4b38('0x83')][_0x4b38('0x87')]&&_[_0x4b38('0x86')](_0x40db84[_0x4b38('0x83')][_0x4b38('0x87')])){if(_0x40db84['body']['tags'][_0x4b38('0x21')]){_0x40db84[_0x4b38('0x83')][_0x4b38('0x87')]=_0x40db84[_0x4b38('0x83')][_0x4b38('0x87')]['join'](';')+';';}else{_0x40db84[_0x4b38('0x83')][_0x4b38('0x87')]=null;}}else{_0x40db84[_0x4b38('0x83')][_0x4b38('0x87')]=null;}return db['CmContact']['create'](_0x40db84[_0x4b38('0x83')],{'fields':_[_0x4b38('0x3d')](_0x48c32d),'raw':!![]});})[_0x4b38('0x14')](respondWithResult(_0x2abde1,0xc9))[_0x4b38('0x78')](handleError(_0x2abde1,null));};exports['bulkCreate']=function(_0x12e896,_0x51773d){var _0xc0e748=0x0;var _0x528582=0x0;var _0x4ec0a7=0x0;return db[_0x4b38('0x6d')][_0x4b38('0x1b')]()[_0x4b38('0x14')](function(_0x5ad963){return BPromise[_0x4b38('0xa0')](_0x12e896[_0x4b38('0x83')],function(_0x457b6b){var _0x4539ec={'where':{'$or':[]},'defaults':_0x457b6b,'fields':_['keys'](_0x5ad963),'raw':!![]};if(_0x457b6b[_0x4b38('0xa1')]){for(var _0x25d2d1=0x0;_0x25d2d1<_0x457b6b['duplicates'][_0x4b38('0x21')];_0x25d2d1++){var _0x5c9f09={};_0x5c9f09[_0x457b6b[_0x4b38('0xa1')][_0x25d2d1]]=_0x457b6b[_0x457b6b[_0x4b38('0xa1')][_0x25d2d1]];_0x4539ec[_0x4b38('0x2d')][_0x4b38('0xa2')][_0x4b38('0x1d')](_0x5c9f09);}_0x4539ec['where'][_0x4b38('0x4f')]=_0x457b6b['ListId'];}return db['CmContact']['findOrCreate'](_0x4539ec)[_0x4b38('0xa3')](function(_0x10a67a,_0x29b3ec){if(_0x29b3ec){_0xc0e748++;}else{_0x4ec0a7++;}})['catch'](function(){_0x528582++;});});})['then'](function(_0x173469){if(_0x173469){return{'success':_0xc0e748,'failure':_0x528582,'duplicates':_0x4ec0a7};}})[_0x4b38('0x14')](respondWithResult(_0x51773d,0xc9))[_0x4b38('0x78')](handleError(_0x51773d,null));};exports[_0x4b38('0xa4')]=function(_0x159299,_0x51b999){var _0x3e9bea;return db[_0x4b38('0x6d')]['describe']()[_0x4b38('0x14')](function(_0x2a94a6){return db[_0x4b38('0x6d')][_0x4b38('0x3e')]({'where':{'id':_0x159299[_0x4b38('0x7a')]['id']},'include':[{'model':db[_0x4b38('0x3f')],'as':'Tags','attributes':['id',_0x4b38('0x18'),'color'],'required':_0x159299['query'][_0x4b38('0x54')]?!![]:![]}],'attributes':_['keys'](_0x2a94a6)});})[_0x4b38('0x14')](function(_0x581b3a){if(!_[_0x4b38('0xa5')](_0x581b3a)){_0x3e9bea=_0x581b3a[_0x4b38('0x84')]({'plain':!![]});var _0x117697={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x581b3a&&_0x581b3a['ListId']){if(_0x581b3a[_0x4b38('0x4f')]){_0x117697[_0x4b38('0x2d')]['$and'][_0x4b38('0x1d')]({'ListId':{'$ne':_0x581b3a[_0x4b38('0x4f')]}});}}return db[_0x4b38('0x1e')][_0x4b38('0x7e')](_0x117697);}})[_0x4b38('0x14')](function(_0x441046){if(!_['isNil'](_0x441046)){return _[_0x4b38('0xa6')](_0x3e9bea,_[_0x4b38('0x42')](_0x441046,function(_0x5b7ea7){return util['format'](_0x4b38('0xa7'),_0x5b7ea7['id']);}));}})[_0x4b38('0x14')](handleEntityNotFound(_0x51b999,null))[_0x4b38('0x14')](respondWithResult(_0x51b999,null))[_0x4b38('0x78')](handleError(_0x51b999,null));};exports[_0x4b38('0x13')]=function(_0x161aac,_0x39f277){var _0x1a5f66;if(_0x161aac[_0x4b38('0x83')]['id']){delete _0x161aac[_0x4b38('0x83')]['id'];}return db['CmContact'][_0x4b38('0x3e')]({'where':{'id':_0x161aac[_0x4b38('0x7a')]['id']}})[_0x4b38('0x14')](handleEntityNotFound(_0x39f277,null))[_0x4b38('0x14')](saveUpdates(_0x161aac[_0x4b38('0x83')],null))[_0x4b38('0x14')](function(_0x37a39f){_0x1a5f66=_0x37a39f;var _0x33a7fa={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x37a39f&&_0x37a39f[_0x4b38('0x4f')]){if(_0x37a39f[_0x4b38('0x4f')]){_0x33a7fa[_0x4b38('0x2d')]['$and']['push']({'ListId':{'$ne':_0x37a39f[_0x4b38('0x4f')]}});}}return db['CmCustomField'][_0x4b38('0x7e')](_0x33a7fa);})[_0x4b38('0x14')](function(_0xc8b435){if(_0xc8b435){return _['omit'](_[_0x4b38('0xa8')](_0x161aac[_0x4b38('0x83')],function(_0x343fc1,_0x18fa36){return _[_0x4b38('0x1c')](_0x18fa36,'cf_');}),_[_0x4b38('0x42')](_0xc8b435,function(_0x408e06){return util[_0x4b38('0xa9')](_0x4b38('0xa7'),_0x408e06['id']);}));}})[_0x4b38('0x14')](function(_0x57449f){if(_0x57449f&&!_['isEmpty'](_0x57449f)){var _0x3124f0=squel['update']()[_0x4b38('0xaa')](_0x4b38('0xab'))[_0x4b38('0xac')](_0x57449f)[_0x4b38('0x2d')](_0x4b38('0xad'),_0x161aac['params']['id'])[_0x4b38('0xae')]();return db[_0x4b38('0x6a')]['query'](_0x3124f0['text'],{'replacements':_0x3124f0[_0x4b38('0x81')]});}})[_0x4b38('0x14')](function(){if(_0x161aac[_0x4b38('0x83')]['phone']&&_0x1a5f66){return db['CmHopper'][_0x4b38('0x13')]({'phone':_0x161aac[_0x4b38('0x83')][_0x4b38('0xaf')]},{'where':{'ContactId':_0x1a5f66['id']}});}})['then'](function(){return _0x1a5f66;})[_0x4b38('0x14')](respondWithResult(_0x39f277,null))[_0x4b38('0x78')](handleError(_0x39f277,null));};exports[_0x4b38('0xb0')]=function(_0x10f11f,_0x15b1fa){var _0x1496b0={};var _0x4a18ae={};var _0x4224f8;var _0x1f4206;return db[_0x4b38('0x6d')]['findOne']({'where':{'id':_0x10f11f['params']['id']}})[_0x4b38('0x14')](handleEntityNotFound(_0x15b1fa,null))['then'](function(_0x1222d2){if(_0x1222d2){_0x4224f8=_0x1222d2;_0x4a18ae[_0x4b38('0x23')]=_[_0x4b38('0x3d')](db['Tag'][_0x4b38('0xb1')]);_0x4a18ae['query']=_['keys'](_0x10f11f[_0x4b38('0x24')]);_0x4a18ae[_0x4b38('0x25')]=_[_0x4b38('0x27')](_0x4a18ae[_0x4b38('0x23')],_0x4a18ae[_0x4b38('0x24')]);_0x1496b0[_0x4b38('0x26')]=_[_0x4b38('0x27')](_0x4a18ae[_0x4b38('0x23')],qs[_0x4b38('0x28')](_0x10f11f[_0x4b38('0x24')][_0x4b38('0x28')]));_0x1496b0[_0x4b38('0x26')]=_0x1496b0[_0x4b38('0x26')][_0x4b38('0x21')]?_0x1496b0[_0x4b38('0x26')]:_0x4a18ae[_0x4b38('0x23')];_0x1496b0[_0x4b38('0x2b')]=qs[_0x4b38('0x2c')](_0x10f11f[_0x4b38('0x24')]['sort']);_0x1496b0[_0x4b38('0x2d')]=qs[_0x4b38('0x25')](_['pick'](_0x10f11f[_0x4b38('0x24')],_0x4a18ae[_0x4b38('0x25')]));if(_0x10f11f[_0x4b38('0x24')][_0x4b38('0x4c')]){_0x1496b0[_0x4b38('0x2d')]=_['merge'](_0x1496b0[_0x4b38('0x2d')],{'$or':_[_0x4b38('0x42')](_0x1496b0[_0x4b38('0x26')],function(_0x237e31){var _0x26568a={};_0x26568a[_0x237e31]={'$like':'%'+_0x10f11f[_0x4b38('0x24')][_0x4b38('0x4c')]+'%'};return _0x26568a;})});}_0x1496b0=_[_0x4b38('0x82')]({},_0x1496b0,_0x10f11f['options']);return _0x4224f8[_0x4b38('0xb0')](_0x1496b0);}})[_0x4b38('0x14')](function(_0x57df57){if(_0x57df57){_0x1f4206=_0x57df57[_0x4b38('0x21')];if(!_0x10f11f['query'][_0x4b38('0x29')]('nolimit')){_0x1496b0[_0x4b38('0x10')]=qs[_0x4b38('0x10')](_0x10f11f[_0x4b38('0x24')]['limit']);_0x1496b0[_0x4b38('0xe')]=qs[_0x4b38('0xe')](_0x10f11f[_0x4b38('0x24')][_0x4b38('0xe')]);}return _0x4224f8['getTags'](_0x1496b0);}})[_0x4b38('0x14')](function(_0x3e8eed){if(_0x3e8eed){return _0x3e8eed?{'count':_0x1f4206,'rows':_0x3e8eed}:null;}})['then'](respondWithResult(_0x15b1fa,null))['catch'](handleError(_0x15b1fa,null));};exports[_0x4b38('0xb2')]=function(_0x6e16a9,_0x3c7f8a){if(_0x6e16a9[_0x4b38('0x83')]['id']){delete _0x6e16a9['body']['id'];}return db[_0x4b38('0x6d')][_0x4b38('0x1f')]({'where':{'id':_0x6e16a9['params']['id']}})[_0x4b38('0x14')](handleEntityNotFound(_0x3c7f8a,null))[_0x4b38('0x14')](function(_0x52a0cd){if(_0x52a0cd){return _0x52a0cd['setTags'](_0x6e16a9[_0x4b38('0x83')][_0x4b38('0xb3')]||[]);}return null;})[_0x4b38('0x14')](respondWithResult(_0x3c7f8a,null))['catch'](handleError(_0x3c7f8a,null));};exports[_0x4b38('0xb4')]=function(_0x1e95e5,_0x1869ef){var _0x1c0e59={'raw':![],'where':{}};var _0x3f7c62={};var _0x4be806={'count':0x0,'rows':[]};return db['CmContact']['findOne']({'where':{'id':_0x1e95e5[_0x4b38('0x7a')]['id']}})[_0x4b38('0x14')](handleEntityNotFound(_0x1869ef,null))[_0x4b38('0x14')](function(_0x1f4311){if(_0x1f4311){_0x3f7c62[_0x4b38('0x23')]=_[_0x4b38('0x3d')](db['CmHopper']['rawAttributes']);_0x3f7c62[_0x4b38('0x24')]=_['keys'](_0x1e95e5[_0x4b38('0x24')]);_0x3f7c62[_0x4b38('0x25')]=_['intersection'](_0x3f7c62[_0x4b38('0x23')],_0x3f7c62['query']);_0x1c0e59[_0x4b38('0x26')]=_[_0x4b38('0x27')](_0x3f7c62[_0x4b38('0x23')],qs['fields'](_0x1e95e5[_0x4b38('0x24')][_0x4b38('0x28')]));_0x1c0e59[_0x4b38('0x26')]=_0x1c0e59[_0x4b38('0x26')][_0x4b38('0x21')]?_0x1c0e59[_0x4b38('0x26')]:_0x3f7c62[_0x4b38('0x23')];if(!_0x1e95e5[_0x4b38('0x24')][_0x4b38('0x29')](_0x4b38('0x2a'))){_0x1c0e59[_0x4b38('0x10')]=qs[_0x4b38('0x10')](_0x1e95e5[_0x4b38('0x24')][_0x4b38('0x10')]);_0x1c0e59[_0x4b38('0xe')]=qs['offset'](_0x1e95e5[_0x4b38('0x24')]['offset']);}_0x1c0e59[_0x4b38('0x2b')]=qs[_0x4b38('0x2c')](_0x1e95e5[_0x4b38('0x24')][_0x4b38('0x2c')]);_0x1c0e59[_0x4b38('0x2d')]=qs[_0x4b38('0x25')](_[_0x4b38('0x2e')](_0x1e95e5['query'],_0x3f7c62[_0x4b38('0x25')]));_0x1c0e59['where'][_0x4b38('0xb5')]=_0x1f4311['id'];if(_0x1e95e5[_0x4b38('0x24')][_0x4b38('0x4c')]){_0x1c0e59[_0x4b38('0x2d')]=_[_0x4b38('0x82')](_0x1c0e59[_0x4b38('0x2d')],{'$or':_['map'](_0x1c0e59[_0x4b38('0x26')],function(_0x473ff1){var _0x4f7bc1={};_0x4f7bc1[_0x473ff1]={'$like':'%'+_0x1e95e5[_0x4b38('0x24')]['filter']+'%'};return _0x4f7bc1;})});}_0x1c0e59=_[_0x4b38('0x82')]({},_0x1c0e59,_0x1e95e5[_0x4b38('0xb6')]);return db[_0x4b38('0x8b')][_0x4b38('0x11')]({'where':_0x1c0e59[_0x4b38('0x2d')]})[_0x4b38('0x14')](function(_0xcf40ad){_0x4be806['count']=_0xcf40ad;if(_0x1e95e5['query'][_0x4b38('0xb7')]){_0x1c0e59[_0x4b38('0xb8')]=[{'all':!![]}];}return db[_0x4b38('0x8b')]['findAll'](_0x1c0e59);})[_0x4b38('0x14')](function(_0x4fe949){_0x4be806['rows']=_0x4fe949;return _0x4be806;});}})[_0x4b38('0x14')](respondWithFilteredResult(_0x1869ef,_0x1c0e59))[_0x4b38('0x78')](handleError(_0x1869ef,null));};exports['getHopperHistories']=function(_0x46252d,_0x160cc5){var _0x556b5e={'raw':!![],'where':{}};var _0x44adff={};var _0xd25f5b={'count':0x0,'rows':[]};return db[_0x4b38('0x6d')][_0x4b38('0x1f')]({'where':{'id':_0x46252d[_0x4b38('0x7a')]['id']}})[_0x4b38('0x14')](handleEntityNotFound(_0x160cc5,null))[_0x4b38('0x14')](function(_0x4b400a){if(_0x4b400a){_0x44adff[_0x4b38('0x23')]=_[_0x4b38('0x3d')](db[_0x4b38('0xb9')]['rawAttributes']);_0x44adff[_0x4b38('0x24')]=_[_0x4b38('0x3d')](_0x46252d[_0x4b38('0x24')]);_0x44adff[_0x4b38('0x25')]=_[_0x4b38('0x27')](_0x44adff[_0x4b38('0x23')],_0x44adff[_0x4b38('0x24')]);_0x556b5e[_0x4b38('0x26')]=_[_0x4b38('0x27')](_0x44adff['model'],qs[_0x4b38('0x28')](_0x46252d[_0x4b38('0x24')][_0x4b38('0x28')]));_0x556b5e[_0x4b38('0x26')]=_0x556b5e['attributes'][_0x4b38('0x21')]?_0x556b5e['attributes']:_0x44adff[_0x4b38('0x23')];if(!_0x46252d[_0x4b38('0x24')][_0x4b38('0x29')]('nolimit')){_0x556b5e[_0x4b38('0x10')]=qs[_0x4b38('0x10')](_0x46252d['query']['limit']);_0x556b5e[_0x4b38('0xe')]=qs[_0x4b38('0xe')](_0x46252d[_0x4b38('0x24')][_0x4b38('0xe')]);}_0x556b5e[_0x4b38('0x2b')]=qs['sort'](_0x46252d[_0x4b38('0x24')][_0x4b38('0x2c')]);_0x556b5e[_0x4b38('0x2d')]=qs[_0x4b38('0x25')](_[_0x4b38('0x2e')](_0x46252d[_0x4b38('0x24')],_0x44adff[_0x4b38('0x25')]));_0x556b5e[_0x4b38('0x2d')][_0x4b38('0xb5')]=_0x4b400a['id'];if(_0x46252d['query']['filter']){_0x556b5e['where']=_[_0x4b38('0x82')](_0x556b5e[_0x4b38('0x2d')],{'$or':_[_0x4b38('0x42')](_0x556b5e[_0x4b38('0x26')],function(_0x4c4bb0){var _0x1a30cd={};_0x1a30cd[_0x4c4bb0]={'$like':'%'+_0x46252d[_0x4b38('0x24')][_0x4b38('0x4c')]+'%'};return _0x1a30cd;})});}_0x556b5e=_[_0x4b38('0x82')]({},_0x556b5e,_0x46252d[_0x4b38('0xb6')]);return db['CmHopperHistory'][_0x4b38('0x11')]({'where':_0x556b5e[_0x4b38('0x2d')]})[_0x4b38('0x14')](function(_0x1d8e80){_0xd25f5b[_0x4b38('0x11')]=_0x1d8e80;if(_0x46252d[_0x4b38('0x24')][_0x4b38('0xb7')]){_0x556b5e['include']=[{'all':!![]}];}return db[_0x4b38('0xb9')]['findAll'](_0x556b5e);})[_0x4b38('0x14')](function(_0xacdd7e){_0xd25f5b[_0x4b38('0x77')]=_0xacdd7e;return _0xd25f5b;});}})[_0x4b38('0x14')](respondWithFilteredResult(_0x160cc5,_0x556b5e))[_0x4b38('0x78')](handleError(_0x160cc5,null));};exports[_0x4b38('0xba')]=function(_0x4ed171,_0x11dabd){var _0x39012b={'raw':!![],'where':{}};var _0x1a925c={};var _0x5aa9d3={'count':0x0,'rows':[]};return db[_0x4b38('0x6d')][_0x4b38('0x1f')]({'where':{'id':_0x4ed171[_0x4b38('0x7a')]['id']}})[_0x4b38('0x14')](handleEntityNotFound(_0x11dabd,null))[_0x4b38('0x14')](function(_0x153328){if(_0x153328){_0x1a925c[_0x4b38('0x23')]=_[_0x4b38('0x3d')](db[_0x4b38('0xbb')][_0x4b38('0xb1')]);_0x1a925c[_0x4b38('0x24')]=_[_0x4b38('0x3d')](_0x4ed171[_0x4b38('0x24')]);_0x1a925c['filters']=_[_0x4b38('0x27')](_0x1a925c[_0x4b38('0x23')],_0x1a925c[_0x4b38('0x24')]);_0x39012b['attributes']=_[_0x4b38('0x27')](_0x1a925c[_0x4b38('0x23')],qs[_0x4b38('0x28')](_0x4ed171[_0x4b38('0x24')][_0x4b38('0x28')]));_0x39012b['attributes']=_0x39012b[_0x4b38('0x26')][_0x4b38('0x21')]?_0x39012b['attributes']:_0x1a925c[_0x4b38('0x23')];if(!_0x4ed171[_0x4b38('0x24')][_0x4b38('0x29')](_0x4b38('0x2a'))){_0x39012b[_0x4b38('0x10')]=qs[_0x4b38('0x10')](_0x4ed171[_0x4b38('0x24')][_0x4b38('0x10')]);_0x39012b[_0x4b38('0xe')]=qs[_0x4b38('0xe')](_0x4ed171['query'][_0x4b38('0xe')]);}_0x39012b[_0x4b38('0x2b')]=qs[_0x4b38('0x2c')](_0x4ed171[_0x4b38('0x24')][_0x4b38('0x2c')]);_0x39012b['where']=qs['filters'](_[_0x4b38('0x2e')](_0x4ed171[_0x4b38('0x24')],_0x1a925c['filters']));_0x39012b[_0x4b38('0x2d')][_0x4b38('0xb5')]=_0x153328['id'];if(_0x4ed171[_0x4b38('0x24')][_0x4b38('0x4c')]){_0x39012b[_0x4b38('0x2d')]=_['merge'](_0x39012b[_0x4b38('0x2d')],{'$or':_[_0x4b38('0x42')](_0x39012b['attributes'],function(_0x4968fc){var _0x4edeca={};_0x4edeca[_0x4968fc]={'$like':'%'+_0x4ed171[_0x4b38('0x24')][_0x4b38('0x4c')]+'%'};return _0x4edeca;})});}_0x39012b=_[_0x4b38('0x82')]({},_0x39012b,_0x4ed171[_0x4b38('0xb6')]);return db[_0x4b38('0xbb')][_0x4b38('0x11')]({'where':_0x39012b[_0x4b38('0x2d')]})[_0x4b38('0x14')](function(_0x49f59b){_0x5aa9d3[_0x4b38('0x11')]=_0x49f59b;if(_0x4ed171[_0x4b38('0x24')]['includeAll']){_0x39012b[_0x4b38('0xb8')]=[{'all':!![]}];}return db[_0x4b38('0xbb')][_0x4b38('0x7e')](_0x39012b);})[_0x4b38('0x14')](function(_0x24d44c){_0x5aa9d3['rows']=_0x24d44c;return _0x5aa9d3;});}})[_0x4b38('0x14')](respondWithFilteredResult(_0x11dabd,_0x39012b))['catch'](handleError(_0x11dabd,null));};exports[_0x4b38('0xbc')]=function(_0x4ef937,_0x3d6577){var _0x55fd56={'raw':!![],'where':{}};var _0x2a57f4={};var _0x409089={'count':0x0,'rows':[]};return db[_0x4b38('0x6d')][_0x4b38('0x1f')]({'where':{'id':_0x4ef937[_0x4b38('0x7a')]['id']}})['then'](handleEntityNotFound(_0x3d6577,null))[_0x4b38('0x14')](function(_0x1c4d07){if(_0x1c4d07){_0x2a57f4[_0x4b38('0x23')]=_['keys'](db[_0x4b38('0x9e')][_0x4b38('0xb1')]);_0x2a57f4[_0x4b38('0x24')]=_[_0x4b38('0x3d')](_0x4ef937[_0x4b38('0x24')]);_0x2a57f4[_0x4b38('0x25')]=_[_0x4b38('0x27')](_0x2a57f4[_0x4b38('0x23')],_0x2a57f4['query']);_0x55fd56['attributes']=_['intersection'](_0x2a57f4['model'],qs[_0x4b38('0x28')](_0x4ef937[_0x4b38('0x24')][_0x4b38('0x28')]));_0x55fd56['attributes']=_0x55fd56[_0x4b38('0x26')][_0x4b38('0x21')]?_0x55fd56[_0x4b38('0x26')]:_0x2a57f4['model'];if(!_0x4ef937[_0x4b38('0x24')]['hasOwnProperty'](_0x4b38('0x2a'))){_0x55fd56[_0x4b38('0x10')]=qs['limit'](_0x4ef937[_0x4b38('0x24')][_0x4b38('0x10')]);_0x55fd56[_0x4b38('0xe')]=qs[_0x4b38('0xe')](_0x4ef937[_0x4b38('0x24')][_0x4b38('0xe')]);}_0x55fd56[_0x4b38('0x2b')]=qs[_0x4b38('0x2c')](_0x4ef937['query'][_0x4b38('0x2c')]);_0x55fd56[_0x4b38('0x2d')]=qs[_0x4b38('0x25')](_[_0x4b38('0x2e')](_0x4ef937[_0x4b38('0x24')],_0x2a57f4[_0x4b38('0x25')]));_0x55fd56[_0x4b38('0x2d')][_0x4b38('0xb5')]=_0x1c4d07['id'];if(_0x4ef937[_0x4b38('0x24')][_0x4b38('0x4c')]){_0x55fd56[_0x4b38('0x2d')]=_['merge'](_0x55fd56[_0x4b38('0x2d')],{'$or':_[_0x4b38('0x42')](_0x55fd56[_0x4b38('0x26')],function(_0x503be4){var _0x5d1e22={};_0x5d1e22[_0x503be4]={'$like':'%'+_0x4ef937['query'][_0x4b38('0x4c')]+'%'};return _0x5d1e22;})});}_0x55fd56=_[_0x4b38('0x82')]({},_0x55fd56,_0x4ef937[_0x4b38('0xb6')]);return db[_0x4b38('0x9e')][_0x4b38('0x11')]({'where':_0x55fd56[_0x4b38('0x2d')]})[_0x4b38('0x14')](function(_0x310cac){_0x409089[_0x4b38('0x11')]=_0x310cac;if(_0x4ef937[_0x4b38('0x24')][_0x4b38('0xb7')]){_0x55fd56[_0x4b38('0xb8')]=[{'all':!![]}];}return db[_0x4b38('0x9e')]['findAll'](_0x55fd56);})[_0x4b38('0x14')](function(_0x2bb309){_0x409089['rows']=_0x2bb309;return _0x409089;});}})[_0x4b38('0x14')](respondWithFilteredResult(_0x3d6577,_0x55fd56))['catch'](handleError(_0x3d6577,null));};exports[_0x4b38('0xbd')]=function(_0x53f1da,_0x582398){try{if(!_0x53f1da[_0x4b38('0x83')][_0x4b38('0x4f')]){throw new Error('No\x20ListId\x20specified');}if(!_0x53f1da[_0x4b38('0x83')][_0x4b38('0xbe')]){throw new Error(_0x4b38('0xbf'));}if(!_0x53f1da[_0x4b38('0x83')]['binding_values']){throw new Error(_0x4b38('0xc0'));}if(!_0x53f1da[_0x4b38('0x83')][_0x4b38('0xc1')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x473162=_0x53f1da[_0x4b38('0x83')]['binding_keys'][_0x4b38('0x41')](',');var _0x5aaff8=_0x53f1da[_0x4b38('0x83')][_0x4b38('0xc2')]['split'](',');if(!_0x473162[_0x4b38('0x21')]||!_0x5aaff8[_0x4b38('0x21')]||_0x473162[_0x4b38('0x21')]!==_0x5aaff8[_0x4b38('0x21')]){throw new Error(_0x4b38('0xc3'));}_0x53f1da[_0x4b38('0x83')][_0x4b38('0x28')]=_[_0x4b38('0xc4')](_0x473162,_0x5aaff8);if(!_0x53f1da[_0x4b38('0x83')][_0x4b38('0x28')]['phone']){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x53f1da[_0x4b38('0x83')][_0x4b38('0x28')][_0x4b38('0xc5')]){throw new Error(_0x4b38('0xc6'));}var _0x5d3c3e=path[_0x4b38('0x88')](config['root'],'server/files/tmp',_0x53f1da['file'][_0x4b38('0xc7')]);fs[_0x4b38('0xc8')](_0x5d3c3e,parseInt(_0x4b38('0xc9'),0x8));var _0x2bb9d4=require(_0x4b38('0xca'))['fork'](path[_0x4b38('0x88')](__dirname,_0x4b38('0xcb')),[_0x5d3c3e,_0x53f1da[_0x4b38('0x83')][_0x4b38('0xbe')],_0x53f1da['body'][_0x4b38('0xc2')],_0x53f1da['body'][_0x4b38('0x4f')],_0x53f1da['body']['CompanyId'],_0x53f1da['body'][_0x4b38('0xa1')],_0x53f1da[_0x4b38('0x83')]['socket_timestamp']]);return _0x582398[_0x4b38('0x15')](0xc8)[_0x4b38('0xd')]({'message':_0x4b38('0xcc'),'pid':_0x2bb9d4['pid']});}catch(_0x46a24e){return _0x582398[_0x4b38('0x15')](0x1f4)[_0x4b38('0x19')](_0x46a24e);}};exports[_0x4b38('0xcd')]=function(_0x4732d8,_0x35469f){var _0x3389b9=fs[_0x4b38('0xce')](_0x4732d8[_0x4b38('0xcf')][_0x4b38('0x3')]);Papa[_0x4b38('0xd0')](_0x3389b9,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x5dc0b4){return _0x35469f[_0x4b38('0x15')](0xc8)['json']({'file':_0x4732d8['file'],'fields':_0x5dc0b4[_0x4b38('0xd1')][_0x4b38('0x28')]});}});};exports[_0x4b38('0xd2')]=function(_0x442d95,_0x3d8b9e){return db[_0x4b38('0x44')][_0x4b38('0x7e')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0x4b38('0x14')](function(_0x133752){var _0x4176b4=![];if(!_0x442d95[_0x4b38('0x83')][_0x4b38('0x4f')]){throw new Error(_0x4b38('0xd3'));}if(!_0x442d95[_0x4b38('0x83')][_0x4b38('0xd4')][_0x4b38('0xaf')]){throw new Error(_0x4b38('0xd5'));}if(!_0x442d95[_0x4b38('0x83')][_0x4b38('0xd4')][_0x4b38('0xc5')]){throw new Error(_0x4b38('0xc6'));}if(!_0x442d95['body']['socket_timestamp']){throw new Error(_0x4b38('0xd6'));}var _0x59b2d9=require('child_process')[_0x4b38('0xd7')](path['join'](__dirname,_0x4b38('0xd8')),[_0x442d95['params']['id'],JSON[_0x4b38('0xd9')](_0x442d95[_0x4b38('0x83')]),JSON[_0x4b38('0xd9')](_0x133752)]);_0x59b2d9['on'](_0x4b38('0xda'),function(){_0x4176b4=!![];return _0x3d8b9e[_0x4b38('0x15')](0xc8)[_0x4b38('0xd')]({'message':'start\x20child\x20process\x20correctly!','pid':_0x59b2d9['pid']});});_0x59b2d9['on'](_0x4b38('0xdb'),function(_0x2e24f3){if(_0x2e24f3&&!_0x4176b4){return _0x3d8b9e['status'](0x1f4)[_0x4b38('0xd')]({'message':_0x4b38('0xdc'),'pid':_0x59b2d9['pid']});}});})[_0x4b38('0x78')](handleError(_0x3d8b9e,null));};exports[_0x4b38('0xdd')]=function(_0x278984,_0x38eca2){var _0x3ee202=[_0x4b38('0xde'),'chat','sms',_0x4b38('0xdf'),_0x4b38('0xe0'),_0x4b38('0xe1'),_0x4b38('0xe2')];var _0x553787={'offset':0x0,'order':qs[_0x4b38('0x2c')]('-createdAt')},_0x41c7e0={'count':0x0,'rows':[]};Promise[_0x4b38('0x65')]()['then'](function(){if(_0x278984[_0x4b38('0x24')][_0x4b38('0xe3')]){if(!_['includes'](_0x3ee202,_0x278984[_0x4b38('0x24')][_0x4b38('0xe3')]['toLowerCase']())){throw new Error('Invalid\x20channel');}_0x3ee202=[_0x278984[_0x4b38('0x24')][_0x4b38('0xe3')][_0x4b38('0xe4')]()];}if(_0x278984[_0x4b38('0x24')]['range']){try{var _0x13cff1=JSON[_0x4b38('0xd0')](_0x278984[_0x4b38('0x24')][_0x4b38('0xe5')]);if(!moment(_0x13cff1[_0x4b38('0x31')])['isValid']()){throw new Error('Invalid\x20date\x20for\x20range\x20from\x20filter');}if(!moment(_0x13cff1['to'])[_0x4b38('0xe6')]()){throw new Error(_0x4b38('0xe7'));}}catch(_0x17e311){throw new Error(_0x4b38('0xe8'));}}if(!_0x278984[_0x4b38('0x24')]['hasOwnProperty'](_0x4b38('0x2a'))){_0x553787['limit']=qs[_0x4b38('0x10')](_0x278984[_0x4b38('0x24')][_0x4b38('0x10')]||0xa);_0x553787[_0x4b38('0xe')]=qs['offset'](_0x278984[_0x4b38('0x24')][_0x4b38('0xe')]);}var _0x436b1f=_0x3ee202[_0x4b38('0x42')](function(_0x5eb5a4){if(_0x5eb5a4===_0x4b38('0xe2')){var _0x223748={'attributes':['id',_0x4b38('0xe9'),_0x4b38('0x22'),'source',_0x4b38('0xea'),_0x4b38('0xeb'),_0x4b38('0xec'),_0x4b38('0xed'),_0x4b38('0xee'),_0x4b38('0xef'),_0x4b38('0xf0'),'userDisposition',_0x4b38('0xf1'),_0x4b38('0xf2'),_0x4b38('0xf3')],'where':{'ContactId':_0x278984[_0x4b38('0x7a')]['id']},'include':[{'model':db[_0x4b38('0x44')],'as':_0x4b38('0x44'),'attributes':['id',_0x4b38('0x18'),_0x4b38('0xf4'),_0x4b38('0x7f')]}],'order':[[_0x4b38('0xf0'),_0x4b38('0x62')]]};if(_0x278984['query'][_0x4b38('0xe5')]){_0x223748['where'][_0x4b38('0xf0')]={'$gte':_0x13cff1[_0x4b38('0x31')],'$lte':_0x13cff1['to']};}return db[_0x4b38('0x99')][_0x4b38('0xf5')](_0x223748)['then'](function(_0x1282ed){_0x41c7e0[_0x4b38('0x11')]+=_0x1282ed['count'];return _['map'](_0x1282ed['rows'],function(_0x14789f){var _0x1ea3f9=_0x14789f[_0x4b38('0x84')]({'plain':!![]});_0x1ea3f9[_0x4b38('0xe3')]=_0x5eb5a4;if(_0x1ea3f9[_0x4b38('0x44')]){_0x1ea3f9[_0x4b38('0x44')]={'id':_0x1ea3f9[_0x4b38('0x44')]['id'],'name':_0x1ea3f9[_0x4b38('0x44')][_0x4b38('0x18')],'fullname':_0x1ea3f9['User'][_0x4b38('0xf4')],'alias':_0x1ea3f9['User'][_0x4b38('0x7f')]};}return _0x1ea3f9;});});}else{var _0xee2880=_[_0x4b38('0xf6')](_0x5eb5a4)+(_0x5eb5a4===_0x4b38('0xf7')?_0x4b38('0xf8'):_0x4b38('0xf9'));var _0x406b3a={'attributes':['id','closed',_0x4b38('0xfa'),_0x4b38('0xf0'),'note','disposition',_0x4b38('0xfb'),_0x4b38('0xfc'),_0x4b38('0xf3'),_0xee2880+'Id'],'where':{'ContactId':_0x278984[_0x4b38('0x7a')]['id']},'include':[{'model':db[_0xee2880],'as':'Account','attributes':['id','name',_0x4b38('0xfd')]},{'model':db[_0x4b38('0x44')],'as':'Owner','attributes':['id',_0x4b38('0x18'),_0x4b38('0xf4')]},{'model':db[_0x4b38('0x3f')],'as':_0x4b38('0x76'),'attributes':['id',_0x4b38('0x18'),_0x4b38('0x30')],'through':{'attributes':[]}}],'order':[[_0x4b38('0xf0'),'DESC']]};if(_0x278984[_0x4b38('0x24')]['range']){_0x406b3a[_0x4b38('0x2d')]['createdAt']={'$gte':_0x13cff1[_0x4b38('0x31')],'$lte':_0x13cff1['to']};}switch(_0x5eb5a4){case _0x4b38('0xf7'):_0x406b3a[_0x4b38('0x26')][_0x4b38('0x1d')]('browserName',_0x4b38('0xfe'),'customerPort',_0x4b38('0xff'),_0x4b38('0x100'),_0x4b38('0x101'),_0x4b38('0x102'),'ratingValue','referer');break;case _0x4b38('0xde'):_0x406b3a['attributes'][_0x4b38('0x1d')]('subject',_0x4b38('0x103'));break;case'openchannel':_0x406b3a[_0x4b38('0x26')]['push'](_0x4b38('0x104'),_0x4b38('0x105'));break;}return db[_[_0x4b38('0xf6')](_0x5eb5a4)+_0x4b38('0x106')][_0x4b38('0xf5')](_0x406b3a)['then'](function(_0x386ac2){_0x41c7e0[_0x4b38('0x11')]+=_0x386ac2[_0x4b38('0x11')];return _[_0x4b38('0x42')](_0x386ac2[_0x4b38('0x77')],function(_0x2c344d){var _0x3bc9c6=_0x2c344d[_0x4b38('0x84')]({'plain':!![]});_0x3bc9c6[_0x4b38('0xe3')]=_0x5eb5a4;if(_0x3bc9c6[_0x4b38('0x107')]){_0x3bc9c6[_0x4b38('0x107')]={'id':_0x3bc9c6[_0x4b38('0x107')]['id'],'name':_0x3bc9c6[_0x4b38('0x107')][_0x4b38('0x18')],'fullname':_0x3bc9c6[_0x4b38('0x107')][_0x4b38('0xf4')]};}return _0x3bc9c6;});});}});return Promise[_0x4b38('0x108')](_0x436b1f);})[_0x4b38('0x14')](function(_0xc5df1a){return _(_0xc5df1a)[_0x4b38('0x109')]()[_0x4b38('0x10a')](_0x4b38('0xf0'))['reverse']()[_0x4b38('0x40')]();})[_0x4b38('0x14')](function(_0x5b09a4){_0x41c7e0[_0x4b38('0x77')]=_0x553787['limit']?_0x5b09a4['slice'](_0x553787[_0x4b38('0xe')],_0x553787[_0x4b38('0xe')]+_0x553787['limit']):_0x5b09a4;return _0x41c7e0;})['then'](respondWithFilteredResult(_0x38eca2,_0x553787))[_0x4b38('0x78')](handleError(_0x38eca2,null));};
\ No newline at end of file
+var _0xa5d2=['left_join','cm_user_has_contacts','uc.CmContactId\x20=\x20c.id','ct.CmContactId\x20=\x20c.id','t.id\x20=\x20ct.TagId','c.deletedAt\x20IS\x20NULL','expr','search','parseSearch','sqlOperator','conditions','find','field','Tag','value','split','forEach','union','User','and','uc.UserId\x20=\x20?','dateOfBirth','datetime','DATE','buildExpression','text','start','map','filter','isNil','Contact','push','isEmpty','c.ListId\x20IN\x20?','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','tag','isArray','replace','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','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?','c.id','Sequelize','QueryTypes','SELECT','order','having','t.id\x20IN\x20?','resolve','user','agent','some','getLists','c.ListId\x20IS\x20NULL','toString','sequelize','keyBy','c.firstName','c.phone','c.mobile','c.fax','c.email','c.ListId','c.createdAt','c.CompanyId','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','Tags','rows','catch','tags','startsWith','columnName','displayName','analytics','alias','values','merge','body','findAll','get','mergeWith','join','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','ChatMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','CmHopperHistory','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','SmsQueueReport','WhatsappInteraction','WhatsappMessage','WhatsappQueueReport','dialTimezone','utcOffset','timezones','each','duplicates','$or','ListId','findOrCreate','spread','show','$and','format','cf_%d','params','omit','pickBy','table','cm_contacts','setFields','id\x20=\x20?','toParam','phone','getTags','findOne','rawAttributes','options','setTags','getHoppers','ContactId','include','includeAll','getHopperFinals','JscriptySessionReport','uploadCsv','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','binding_keys','Incorrect\x20binding\x20parameters\x20passed!','zipObject','firstName','No\x20firstName\x20column\x20specified','root','server/files/tmp','chmodSync','child_process','fork','../../components/import/cm/csv','CompanyId','File\x20uploaded\x20correctly!','upload','createReadStream','file','path','parse','meta','import','No\x20ListId\x20specified','../../components/import/cm/csv2','message','pid','exit','error\x20child\x20process','chat','sms','openchannel','fax','whatsapp','voice','-createdAt','channel','toLowerCase','range','isValid','source','destination','starttime','note','createdAt','userDisposition','userSecondDisposition','userThirdDisposition','UserId','fullname','DESC','Website','Account','closed','closedAt','disposition','secondDisposition','thirdDisposition','key','browserName','customerIp','customerPort','deviceModel','osName','ratingMessage','ratingType','ratingValue','referer','mail','subject','substatus','startCase','Interaction','findAndCountAll','Owner','flatten','sortBy','reverse','slice','moment','squel','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','api','../../config/environment','../../config/environment/shared','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./cmContact.socket','register','status','json','offset','undefined','count','set','update','then','destroy','end','sendStatus','error','stack','name','send','index','CmContact','describe','length','keys','cf_','CmCustomField','trimStart','all','fieldType','type','model','query','intersection','fields','attributes','hasOwnProperty','nolimit','limit','sort','where','filters','pick','color','from','tools_tags','select'];(function(_0x2b7577,_0x422c99){var _0x1a7c9b=function(_0x386a67){while(--_0x386a67){_0x2b7577['push'](_0x2b7577['shift']());}};_0x1a7c9b(++_0x422c99);}(_0xa5d2,0xe7));var _0x2a5d=function(_0x265fbf,_0x401471){_0x265fbf=_0x265fbf-0x0;var _0x2d6bf8=_0xa5d2[_0x265fbf];return _0x2d6bf8;};'use strict';var moment=require(_0x2a5d('0x0'));var BPromise=require('bluebird');var util=require('util');var path=require('path');var fs=require('fs');var _=require('lodash');var squel=require(_0x2a5d('0x1'));var Papa=require(_0x2a5d('0x2'));var Redis=require(_0x2a5d('0x3'));var qs=require(_0x2a5d('0x4'));var as=require(_0x2a5d('0x5'));var logger=require('../../config/logger')(_0x2a5d('0x6'));var config=require(_0x2a5d('0x7'));var shared=require(_0x2a5d('0x8'));var db=require(_0x2a5d('0x9'))['db'];config[_0x2a5d('0xa')]=_[_0x2a5d('0xb')](config[_0x2a5d('0xa')],{'host':_0x2a5d('0xc'),'port':0x18eb});var socket=require(_0x2a5d('0xd'))(new Redis(config[_0x2a5d('0xa')]));require(_0x2a5d('0xe'))[_0x2a5d('0xf')](socket);function respondWithResult(_0x803f1d,_0x28fcbe){_0x28fcbe=_0x28fcbe||0xc8;return function(_0x337e2d){if(_0x337e2d){return _0x803f1d[_0x2a5d('0x10')](_0x28fcbe)[_0x2a5d('0x11')](_0x337e2d);}};}function respondWithFilteredResult(_0xa992d6,_0x236108){return function(_0x5dd875){if(_0x5dd875){var _0x2ae71b=typeof _0x236108[_0x2a5d('0x12')]===_0x2a5d('0x13')&&typeof _0x236108['limit']===_0x2a5d('0x13');var _0x42f7e5=_0x5dd875['count'];var _0x5f4722=_0x2ae71b?0x0:_0x236108[_0x2a5d('0x12')];var _0x342999=_0x2ae71b?_0x5dd875[_0x2a5d('0x14')]:_0x236108[_0x2a5d('0x12')]+_0x236108['limit'];var _0x4ef1ce;if(_0x342999>=_0x42f7e5){_0x342999=_0x42f7e5;_0x4ef1ce=0xc8;}else{_0x4ef1ce=0xce;}_0xa992d6[_0x2a5d('0x10')](_0x4ef1ce);return _0xa992d6[_0x2a5d('0x15')]('Content-Range',_0x5f4722+'-'+_0x342999+'/'+_0x42f7e5)[_0x2a5d('0x11')](_0x5dd875);}return null;};}function saveUpdates(_0x182535){return function(_0xbabaf5){if(_0xbabaf5){return _0xbabaf5[_0x2a5d('0x16')](_0x182535)[_0x2a5d('0x17')](function(_0x316193){return _0x316193;});}return null;};}function removeEntity(_0x9a12ad){return function(_0x506f07){if(_0x506f07){return _0x506f07[_0x2a5d('0x18')]()[_0x2a5d('0x17')](function(){_0x9a12ad[_0x2a5d('0x10')](0xcc)[_0x2a5d('0x19')]();});}};}function handleEntityNotFound(_0x491eb5){return function(_0x2cee86){if(!_0x2cee86){_0x491eb5[_0x2a5d('0x1a')](0x194);}return _0x2cee86;};}function handleError(_0x54234c,_0x5daa54){_0x5daa54=_0x5daa54||0x1f4;return function(_0x39cf3f){logger[_0x2a5d('0x1b')](_0x39cf3f[_0x2a5d('0x1c')]);if(_0x39cf3f[_0x2a5d('0x1d')]){delete _0x39cf3f['name'];}_0x54234c[_0x2a5d('0x10')](_0x5daa54)[_0x2a5d('0x1e')](_0x39cf3f);};}exports[_0x2a5d('0x1f')]=function(_0x3d1f66,_0x23ba1e){var _0x321f14={},_0x18f3f5={},_0x5eef6b={'count':0x0,'rows':[]};return db[_0x2a5d('0x20')][_0x2a5d('0x21')]()['then'](function(_0x5c87c3){var _0x297c1e=[];for(var _0x37bef0=0x0;_0x37bef0<Object['keys'](_0x5c87c3)[_0x2a5d('0x22')];_0x37bef0++){var _0x4f3c06=Object[_0x2a5d('0x23')](_0x5c87c3)[_0x37bef0];if(_['startsWith'](_0x4f3c06,_0x2a5d('0x24'))){_0x297c1e['push'](db[_0x2a5d('0x25')]['findOne']({'where':{'id':_[_0x2a5d('0x26')](_0x4f3c06,_0x2a5d('0x24'))},'raw':!![]}));}}return BPromise[_0x2a5d('0x27')](_0x297c1e)[_0x2a5d('0x17')](function(_0x5d8eb4){for(var _0x23fc5a=0x0;_0x23fc5a<_0x5d8eb4[_0x2a5d('0x22')];_0x23fc5a++){if(_0x5d8eb4[_0x23fc5a]){var _0x3b4b42=_0x2a5d('0x24')+_0x5d8eb4[_0x23fc5a]['id'];var _0x4162b0=_0x5c87c3[_0x3b4b42];_0x4162b0[_0x2a5d('0x28')]=_0x5d8eb4[_0x23fc5a][_0x2a5d('0x29')];}}return _0x5c87c3;});})[_0x2a5d('0x17')](function(_0xb39976){_0x18f3f5[_0x2a5d('0x2a')]=_[_0x2a5d('0x23')](_0xb39976);_0x18f3f5[_0x2a5d('0x2b')]=_[_0x2a5d('0x23')](_0x3d1f66['query']);_0x18f3f5['filters']=_[_0x2a5d('0x2c')](_0x18f3f5['model'],_0x18f3f5[_0x2a5d('0x2b')]);_0x321f14['attributes']=_['intersection'](_0x18f3f5[_0x2a5d('0x2a')],qs[_0x2a5d('0x2d')](_0x3d1f66[_0x2a5d('0x2b')][_0x2a5d('0x2d')]));_0x321f14['attributes']=_0x321f14[_0x2a5d('0x2e')][_0x2a5d('0x22')]?_0x321f14[_0x2a5d('0x2e')]:_0x18f3f5[_0x2a5d('0x2a')];if(!_0x3d1f66['query'][_0x2a5d('0x2f')](_0x2a5d('0x30'))){_0x321f14[_0x2a5d('0x31')]=qs[_0x2a5d('0x31')](_0x3d1f66[_0x2a5d('0x2b')][_0x2a5d('0x31')]);_0x321f14['offset']=qs['offset'](_0x3d1f66['query'][_0x2a5d('0x12')]);}_0x321f14['order']=qs[_0x2a5d('0x32')](_0x3d1f66['query'][_0x2a5d('0x32')]);_0x321f14[_0x2a5d('0x33')]=qs[_0x2a5d('0x34')](_[_0x2a5d('0x35')](_0x3d1f66[_0x2a5d('0x2b')],_0x18f3f5[_0x2a5d('0x34')]),_0xb39976);var _0x27978=[];var _0x445863=squel['select']()['field']('id')['field'](_0x2a5d('0x1d'))['field'](_0x2a5d('0x36'))[_0x2a5d('0x37')](_0x2a5d('0x38'));var _0x2094af=squel[_0x2a5d('0x39')]()['from']('cm_contacts','c')[_0x2a5d('0x3a')](_0x2a5d('0x3b'),'uc',_0x2a5d('0x3c'))[_0x2a5d('0x3a')]('cm_contact_has_tags','ct',_0x2a5d('0x3d'))['left_join']('tools_tags','t',_0x2a5d('0x3e'))[_0x2a5d('0x33')](_0x2a5d('0x3f'));var _0xa57602=squel['expr']();var _0x5124ba=[];var _0x5e167a=squel[_0x2a5d('0x40')]();var _0x342517;if(_0x3d1f66['query'][_0x2a5d('0x41')]){_0x342517=as[_0x2a5d('0x42')](_0x3d1f66[_0x2a5d('0x2b')][_0x2a5d('0x41')]);var _0x3da7de=_0x342517[_0x2a5d('0x43')];for(var _0x572ee5=0x0;_0x572ee5<_0x342517['conditions'][_0x2a5d('0x22')];_0x572ee5++){var _0x459e28=_0x342517[_0x2a5d('0x44')][_0x572ee5];var _0xf89e59='c';var _0x3cc1ee=_(_0xb39976)[_0x2a5d('0x23')]()[_0x2a5d('0x45')](function(_0x233c53){return _0x233c53===_0x459e28[_0x2a5d('0x46')];});if(_0x3cc1ee)_0x3cc1ee=_0xb39976[_0x459e28[_0x2a5d('0x46')]];if(!_0x3cc1ee){if(_0x459e28[_0x2a5d('0x46')]===_0x2a5d('0x47')){var _0x4e4376=_0x459e28[_0x2a5d('0x48')][_0x2a5d('0x49')](',')['map'](function(_0x19ccfd){return Number(_0x19ccfd);});_0x4e4376[_0x2a5d('0x4a')](function(_0x3d941b){_0x5e167a['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x3d941b+',%');});_0x5124ba=_[_0x2a5d('0x4b')](_0x5124ba,_0x4e4376);}else if(_0x459e28[_0x2a5d('0x46')]===_0x2a5d('0x4c')){_0xa57602[_0x2a5d('0x4d')](_0x2a5d('0x4e'),_0x459e28[_0x2a5d('0x48')]);}}else{if(_0x459e28[_0x2a5d('0x46')]===_0x2a5d('0x4f')||_0x3cc1ee[_0x2a5d('0x28')]===_0x2a5d('0x50'))_0x459e28['castTo']=_0x2a5d('0x51');var _0x4917a1=as[_0x2a5d('0x52')](_0xf89e59,_0x3cc1ee[_0x2a5d('0x29')],_0x459e28);_0xa57602[_0x3da7de](_0x4917a1[_0x2a5d('0x53')],_0x4917a1[_0x2a5d('0x48')][_0x2a5d('0x54')],_0x4917a1[_0x2a5d('0x48')]['end']);}}}else{var _0x4e9b1c=_(Object[_0x2a5d('0x23')](_0x3d1f66[_0x2a5d('0x2b')]))[_0x2a5d('0x55')](function(_0xadad7f){return _0xb39976['hasOwnProperty'](_0xadad7f)?_0xadad7f:undefined;})[_0x2a5d('0x56')](function(_0x297e0d){return!_[_0x2a5d('0x57')](_0x297e0d);})[_0x2a5d('0x48')]();if(_0x3d1f66[_0x2a5d('0x2b')][_0x2a5d('0x58')])_0x4e9b1c[_0x2a5d('0x59')](_0x2a5d('0x58'));if(!_[_0x2a5d('0x5a')](_0x4e9b1c)){_0x4e9b1c[_0x2a5d('0x4a')](function(_0x355305){if(_0x355305==='ListId'){_0x2094af[_0x2a5d('0x33')](_0x2a5d('0x5b'),[]['concat'](_0x3d1f66[_0x2a5d('0x2b')][_0x355305]));}else if(_0x355305==='Contact'){var _0x439aae='%'+_0x3d1f66['query'][_0x355305]+'%';_0x2094af[_0x2a5d('0x33')](_0x2a5d('0x5c'),_0x439aae);}else{_0x2094af[_0x2a5d('0x33')]('c.'+_0x355305+_0x2a5d('0x5d'),_0x3d1f66[_0x2a5d('0x2b')][_0x355305]);}});}if(_0x3d1f66[_0x2a5d('0x2b')][_0x2a5d('0x5e')]){_0x5124ba=_[_0x2a5d('0x5f')](_0x3d1f66[_0x2a5d('0x2b')][_0x2a5d('0x5e')])?_0x3d1f66[_0x2a5d('0x2b')][_0x2a5d('0x5e')]:new Array(_0x3d1f66[_0x2a5d('0x2b')][_0x2a5d('0x5e')]);_0x5124ba['forEach'](function(_0x1aecda){_0x5e167a['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x1aecda+',%');});}if(_0x3d1f66[_0x2a5d('0x2b')][_0x2a5d('0x56')]){var _0x813c29=_0x3d1f66['query']['filter'][_0x2a5d('0x60')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(_0x813c29['split']('\x20')['length']>0x1){_0xa57602['or'](_0x2a5d('0x61'),qs[_0x2a5d('0x62')](_0x813c29),null);}else{if(qs['isNumeric'](_0x813c29)){_0xa57602['or'](_0x2a5d('0x63'),_0x813c29+'%');_0xa57602['or'](_0x2a5d('0x64'),_0x813c29+'%');_0xa57602['or']('c.mobile\x20LIKE\x20?',_0x813c29+'%');_0xa57602['or'](_0x2a5d('0x65'),_0x813c29+'%');}else if(qs[_0x2a5d('0x66')](_0x813c29)){_0xa57602['or']('c.email\x20LIKE\x20?',_0x813c29+'%');}else{_0xa57602['or'](_0x2a5d('0x67'),'%'+_0x813c29+'%');_0xa57602['or'](_0x2a5d('0x68'),'%'+_0x813c29+'%');_0xa57602['or'](_0x2a5d('0x69'),'%'+_0x813c29+'%');}}}}_0x2094af['where'](_0xa57602);_0x2094af['group'](_0x2a5d('0x6a'));var _0x5b423d={'type':db[_0x2a5d('0x6b')][_0x2a5d('0x6c')][_0x2a5d('0x6d')],'raw':!![]};var _0x27ed54=_0x2094af['clone']()[_0x2a5d('0x46')]('c.id');if(_0x321f14[_0x2a5d('0x6e')]){_0x321f14[_0x2a5d('0x6e')][_0x2a5d('0x4a')](function(_0xb0a58d){_0x2094af['order']('c.'+_0xb0a58d[0x0],_0xb0a58d[0x1]==='DESC'?![]:!![]);});}if(!_[_0x2a5d('0x5a')](_0x5124ba)){_0x2094af[_0x2a5d('0x6f')](_0x5e167a);_0x27ed54[_0x2a5d('0x33')](_0x2a5d('0x70'),_0x5124ba);}BPromise[_0x2a5d('0x71')]()['then'](function(){if(!_0x342517)return;if(_0x3d1f66[_0x2a5d('0x72')]['role']!==_0x2a5d('0x73'))return;if(!_[_0x2a5d('0x74')](_0x342517[_0x2a5d('0x44')],[_0x2a5d('0x46'),_0x2a5d('0x4c')])){return _0x3d1f66[_0x2a5d('0x72')][_0x2a5d('0x75')]({'attributes':['id'],'raw':!![]})['then'](function(_0x5391a8){if(_[_0x2a5d('0x5a')](_0x5391a8)){_0x27ed54[_0x2a5d('0x33')](_0x2a5d('0x76'));_0x2094af[_0x2a5d('0x33')](_0x2a5d('0x76'));}else{_0x27ed54[_0x2a5d('0x33')](_0x2a5d('0x5b'),_['map'](_0x5391a8,'id'));_0x2094af['where']('c.ListId\x20IN\x20?',_[_0x2a5d('0x55')](_0x5391a8,'id'));}});}})[_0x2a5d('0x17')](function(){if(_0x3d1f66[_0x2a5d('0x72')]['role']===_0x2a5d('0x73')&&!_0x342517&&!_0x3d1f66[_0x2a5d('0x2b')]['ListId'])return[];return db['sequelize'][_0x2a5d('0x2b')](_0x27ed54[_0x2a5d('0x77')](),_0x5b423d);})[_0x2a5d('0x17')](function(_0x2f6a6f){_0x5eef6b[_0x2a5d('0x14')]=_0x2f6a6f['length'];if(_0x5eef6b['count']===0x0)return[];return db[_0x2a5d('0x78')]['query'](_0x445863[_0x2a5d('0x77')](),_0x5b423d)[_0x2a5d('0x17')](function(_0x379989){_0x27978=_[_0x2a5d('0x79')](_0x379989,'id');_0x5b423d=_['merge'](_0x5b423d,{'model':db[_0x2a5d('0x20')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x3d1f66[_0x2a5d('0x2b')][_0x2a5d('0x2d')]){_0x321f14['attributes']['forEach'](function(_0x49067e){_0x2094af[_0x2a5d('0x46')]('c.'+_0x49067e);});}else{_0x2094af[_0x2a5d('0x46')]('c.id');_0x2094af[_0x2a5d('0x46')](_0x2a5d('0x7a'));_0x2094af['field']('c.lastName');_0x2094af[_0x2a5d('0x46')](_0x2a5d('0x7b'));_0x2094af[_0x2a5d('0x46')](_0x2a5d('0x7c'));_0x2094af[_0x2a5d('0x46')](_0x2a5d('0x7d'));_0x2094af['field'](_0x2a5d('0x7e'));_0x2094af[_0x2a5d('0x46')](_0x2a5d('0x7f'));_0x2094af[_0x2a5d('0x46')](_0x2a5d('0x80'));_0x2094af[_0x2a5d('0x46')]('c.deletedAt');_0x2094af[_0x2a5d('0x46')](_0x2a5d('0x81'));_0x2094af[_0x2a5d('0x46')](_0x2a5d('0x82'),'TagIds');}if(_0x321f14[_0x2a5d('0x31')])_0x2094af[_0x2a5d('0x31')](_0x321f14[_0x2a5d('0x31')]);if(_0x321f14['offset'])_0x2094af[_0x2a5d('0x12')](_0x321f14[_0x2a5d('0x12')]);return db['sequelize'][_0x2a5d('0x2b')](_0x2094af[_0x2a5d('0x77')](),_0x5b423d);});})['then'](function(_0x4a5503){_0x4a5503[_0x2a5d('0x4a')](function(_0x2c321d){if(_0x2c321d[_0x2a5d('0x83')]){_0x2c321d[_0x2a5d('0x84')]=[];_0x2c321d['TagIds']['split'](',')[_0x2a5d('0x4a')](function(_0x3a44ca){_0x2c321d[_0x2a5d('0x84')][_0x2a5d('0x59')](_0x27978[_0x3a44ca]);});}delete _0x2c321d['TagIds'];});_0x5eef6b[_0x2a5d('0x85')]=_0x4a5503;return _0x5eef6b;})[_0x2a5d('0x17')](respondWithFilteredResult(_0x23ba1e,_0x321f14));})[_0x2a5d('0x86')](handleError(_0x23ba1e,null));};exports['destroy']=function(_0x46490b,_0x16f3be){return db[_0x2a5d('0x20')][_0x2a5d('0x45')]({'where':{'id':_0x46490b['params']['id']}})['then'](handleEntityNotFound(_0x16f3be,null))[_0x2a5d('0x17')](removeEntity(_0x16f3be,null))[_0x2a5d('0x86')](handleError(_0x16f3be,null));};exports[_0x2a5d('0x21')]=function(_0x359864,_0x1995e8){return db[_0x2a5d('0x20')]['describe']()[_0x2a5d('0x17')](function(_0x228aaf){delete _0x228aaf[_0x2a5d('0x87')];for(var _0x9a8516=0x0;_0x9a8516<Object[_0x2a5d('0x23')](_0x228aaf)[_0x2a5d('0x22')];_0x9a8516++){var _0x2051c3=Object[_0x2a5d('0x23')](_0x228aaf)[_0x9a8516];if(!_[_0x2a5d('0x88')](_0x2051c3,'cf_')){_0x228aaf[_0x2051c3][_0x2a5d('0x89')]=_0x2051c3;_0x228aaf[_0x2051c3][_0x2a5d('0x8a')]=_0x2051c3;}}return _0x228aaf;})[_0x2a5d('0x17')](function(_0x15b3b6){var _0x45fad9={'where':Boolean(_0x359864[_0x2a5d('0x2b')][_0x2a5d('0x8b')])===!![]?undefined:{'$or':[{'ListId':_0x359864[_0x2a5d('0x2b')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x2a5d('0x25')]['findAll'](_0x45fad9)[_0x2a5d('0x17')](function(_0x484730){for(var _0x30d5ec=0x0;_0x30d5ec<_0x484730[_0x2a5d('0x22')];_0x30d5ec++){var _0x1c3dd9=_0x2a5d('0x24')+_0x484730[_0x30d5ec]['id'];_0x15b3b6[_0x1c3dd9][_0x2a5d('0x89')]=_0x1c3dd9;_0x15b3b6[_0x1c3dd9]['displayName']=_0x484730[_0x30d5ec][_0x2a5d('0x8c')];_0x15b3b6[_0x1c3dd9]['custom']={'type':_0x484730[_0x30d5ec][_0x2a5d('0x29')],'values':_0x484730[_0x30d5ec][_0x2a5d('0x8d')]};}Object[_0x2a5d('0x23')](_0x15b3b6)['forEach'](function(_0x51460a){if(!_0x15b3b6[_0x51460a]['hasOwnProperty'](_0x2a5d('0x89'))){delete _0x15b3b6[_0x51460a];}});return _0x15b3b6;});})[_0x2a5d('0x17')](respondWithResult(_0x1995e8,null))[_0x2a5d('0x86')](handleError(_0x1995e8,null));};exports[_0x2a5d('0x8e')]=function(_0xfe4c47,_0xe08945){var _0x5420d3;var _0x45b563;var _0xca2ca4;if(_0xfe4c47['body']['id']){delete _0xfe4c47[_0x2a5d('0x8f')]['id'];}return db[_0x2a5d('0x20')][_0x2a5d('0x90')]({'where':{'id':[_0xfe4c47[_0x2a5d('0x8f')]['to'],_0xfe4c47[_0x2a5d('0x8f')][_0x2a5d('0x37')]]}})['then'](function(_0x23c5b7){if(_0x23c5b7){if(_0x23c5b7[_0x2a5d('0x22')]!==0x2){return null;}_0x23c5b7[0x0]=_0x23c5b7[0x0][_0x2a5d('0x91')]({'plain':!![]});_0x23c5b7[0x1]=_0x23c5b7[0x1]['get']({'plain':!![]});delete _0x23c5b7[0x0]['id'];delete _0x23c5b7[0x1]['id'];return _[_0x2a5d('0x92')](_0x23c5b7[0x0],_0x23c5b7[0x1],function(_0x3c71a3,_0x57dc64){if(Array[_0x2a5d('0x5f')](_0x57dc64)&&!_0x57dc64['length']){return _0x3c71a3;}else if(!_0x57dc64){return _0x3c71a3;}});}})[_0x2a5d('0x17')](handleEntityNotFound(_0xe08945,null))[_0x2a5d('0x17')](function(_0x206adb){if(_0x206adb){if(_0x206adb[_0x2a5d('0x87')]&&_[_0x2a5d('0x5f')](_0x206adb[_0x2a5d('0x87')])){_0x206adb[_0x2a5d('0x87')]=_0x206adb[_0x2a5d('0x87')][_0x2a5d('0x93')]();}logger[_0x2a5d('0x94')](_0x2a5d('0x95'),_0xfe4c47['body']['to'],_0xfe4c47[_0x2a5d('0x8f')]['from']);return db[_0x2a5d('0x96')][_0x2a5d('0x18')]({'where':{'ContactId':[_0xfe4c47[_0x2a5d('0x8f')]['to'],_0xfe4c47['body'][_0x2a5d('0x37')]]}})[_0x2a5d('0x17')](function(_0x5a4521){logger[_0x2a5d('0x94')](_0x2a5d('0x97'),_0x5a4521);return db[_0x2a5d('0x98')]['destroy']({'where':{'ContactId':[_0xfe4c47[_0x2a5d('0x8f')]['to'],_0xfe4c47[_0x2a5d('0x8f')][_0x2a5d('0x37')]]}})[_0x2a5d('0x17')](function(_0x1d5a16){logger[_0x2a5d('0x94')](_0x2a5d('0x99'),_0x1d5a16);return db[_0x2a5d('0x20')][_0x2a5d('0x9a')](_0x206adb);});});}})[_0x2a5d('0x17')](function(_0x4c4537){if(_0x4c4537){_0x5420d3=_0x4c4537;_0x45b563={'ContactId':_0x5420d3['id']};_0xca2ca4={'where':{'ContactId':[_0xfe4c47['body']['to'],_0xfe4c47[_0x2a5d('0x8f')][_0x2a5d('0x37')]]}};return db[_0x2a5d('0x9b')][_0x2a5d('0x16')](_0x45b563,_0xca2ca4);}})[_0x2a5d('0x17')](function(){if(_0x5420d3){return db[_0x2a5d('0x9c')][_0x2a5d('0x16')](_0x45b563,_0xca2ca4);}})[_0x2a5d('0x17')](function(){if(_0x5420d3){return db['ChatOfflineMessage']['update'](_0x45b563,_0xca2ca4);}})['then'](function(){if(_0x5420d3){return db[_0x2a5d('0x9d')]['update'](_0x45b563,_0xca2ca4);}})[_0x2a5d('0x17')](function(){if(_0x5420d3){return db[_0x2a5d('0x9e')][_0x2a5d('0x16')](_0x45b563,_0xca2ca4);}})[_0x2a5d('0x17')](function(){if(_0x5420d3){return db[_0x2a5d('0x9d')]['update'](_0x45b563,_0xca2ca4);}})[_0x2a5d('0x17')](function(){if(_0x5420d3){return db[_0x2a5d('0x9e')][_0x2a5d('0x16')](_0x45b563,_0xca2ca4);}})[_0x2a5d('0x17')](function(){if(_0x5420d3){return db[_0x2a5d('0x9f')][_0x2a5d('0x16')](_0x45b563,_0xca2ca4);}})[_0x2a5d('0x17')](function(){if(_0x5420d3){return db[_0x2a5d('0xa0')][_0x2a5d('0x16')](_0x45b563,_0xca2ca4);}})[_0x2a5d('0x17')](function(){if(_0x5420d3){return db['FaxInteraction'][_0x2a5d('0x16')](_0x45b563,_0xca2ca4);}})['then'](function(){if(_0x5420d3){return db[_0x2a5d('0xa1')][_0x2a5d('0x16')](_0x45b563,_0xca2ca4);}})['then'](function(){if(_0x5420d3){return db[_0x2a5d('0xa2')][_0x2a5d('0x16')](_0x45b563,_0xca2ca4);}})['then'](function(){if(_0x5420d3){return db[_0x2a5d('0xa3')][_0x2a5d('0x16')](_0x45b563,_0xca2ca4);}})[_0x2a5d('0x17')](function(){if(_0x5420d3){return db[_0x2a5d('0xa4')][_0x2a5d('0x16')](_0x45b563,_0xca2ca4);}})[_0x2a5d('0x17')](function(){if(_0x5420d3){return db[_0x2a5d('0xa5')][_0x2a5d('0x16')](_0x45b563,_0xca2ca4);}})[_0x2a5d('0x17')](function(){if(_0x5420d3){return db['ReportAgentPreview'][_0x2a5d('0x16')](_0x45b563,_0xca2ca4);}})[_0x2a5d('0x17')](function(){if(_0x5420d3){return db[_0x2a5d('0xa6')][_0x2a5d('0x16')](_0x45b563,_0xca2ca4);}})[_0x2a5d('0x17')](function(){if(_0x5420d3){return db[_0x2a5d('0xa7')]['update'](_0x45b563,_0xca2ca4);}})[_0x2a5d('0x17')](function(){if(_0x5420d3){return db[_0x2a5d('0xa8')][_0x2a5d('0x16')](_0x45b563,_0xca2ca4);}})[_0x2a5d('0x17')](function(){if(_0x5420d3){return db[_0x2a5d('0xa9')][_0x2a5d('0x16')](_0x45b563,_0xca2ca4);}})[_0x2a5d('0x17')](function(){if(_0x5420d3){return db['OpenchannelQueueReport'][_0x2a5d('0x16')](_0x45b563,_0xca2ca4);}})[_0x2a5d('0x17')](function(){if(_0x5420d3){return db[_0x2a5d('0xaa')]['update'](_0x45b563,_0xca2ca4);}})[_0x2a5d('0x17')](function(){if(_0x5420d3){return db['JscriptySessionReport'][_0x2a5d('0x16')](_0x45b563,_0xca2ca4);}})[_0x2a5d('0x17')](function(){if(_0x5420d3){return db[_0x2a5d('0xab')][_0x2a5d('0x16')](_0x45b563,_0xca2ca4);}})[_0x2a5d('0x17')](function(){if(_0x5420d3){return db[_0x2a5d('0xac')][_0x2a5d('0x16')](_0x45b563,_0xca2ca4);}})['then'](function(){if(_0x5420d3){return db[_0x2a5d('0xad')]['update'](_0x45b563,_0xca2ca4);}})[_0x2a5d('0x17')](function(){if(_0x5420d3){return db[_0x2a5d('0x20')][_0x2a5d('0x18')]({'where':{'id':[_0xfe4c47[_0x2a5d('0x8f')]['to'],_0xfe4c47['body'][_0x2a5d('0x37')]]}});}})['then'](function(){if(_0x5420d3){return _0x5420d3;}})[_0x2a5d('0x17')](respondWithResult(_0xe08945,null))[_0x2a5d('0x86')](handleError(_0xe08945,null));};exports[_0x2a5d('0x9a')]=function(_0x2ad5c9,_0x4cef5b){return db[_0x2a5d('0x20')][_0x2a5d('0x21')]()[_0x2a5d('0x17')](function(_0x140fdd){if(_0x2ad5c9['body'][_0x2a5d('0x87')]&&_[_0x2a5d('0x5f')](_0x2ad5c9[_0x2a5d('0x8f')]['tags'])){if(_0x2ad5c9[_0x2a5d('0x8f')]['tags'][_0x2a5d('0x22')]){_0x2ad5c9[_0x2a5d('0x8f')][_0x2a5d('0x87')]=_0x2ad5c9['body'][_0x2a5d('0x87')][_0x2a5d('0x93')](';')+';';}else{_0x2ad5c9[_0x2a5d('0x8f')]['tags']=null;}}else{_0x2ad5c9[_0x2a5d('0x8f')]['tags']=null;}if(!_['isNil'](_0x2ad5c9['body'][_0x2a5d('0xae')])){var _0x262c1b=_0x2ad5c9[_0x2a5d('0x8f')]['dialTimezone'];if(!_[_0x2a5d('0x57')](shared['timezones'][_0x262c1b]))_0x2ad5c9[_0x2a5d('0x8f')][_0x2a5d('0xaf')]=shared[_0x2a5d('0xb0')][_0x262c1b][_0x2a5d('0xaf')];}return db['CmContact'][_0x2a5d('0x9a')](_0x2ad5c9[_0x2a5d('0x8f')],{'fields':_[_0x2a5d('0x23')](_0x140fdd),'raw':!![]});})[_0x2a5d('0x17')](respondWithResult(_0x4cef5b,0xc9))['catch'](handleError(_0x4cef5b,null));};exports['bulkCreate']=function(_0x264396,_0x3bd771){var _0x8f803c=0x0;var _0x2a6bc1=0x0;var _0x2e1a63=0x0;return db[_0x2a5d('0x20')][_0x2a5d('0x21')]()[_0x2a5d('0x17')](function(_0x2497cb){return BPromise[_0x2a5d('0xb1')](_0x264396['body'],function(_0x20555e){var _0x2ae3b0={'where':{'$or':[]},'defaults':_0x20555e,'fields':_[_0x2a5d('0x23')](_0x2497cb),'raw':!![]};if(_0x20555e[_0x2a5d('0xb2')]){for(var _0x1dc0e5=0x0;_0x1dc0e5<_0x20555e[_0x2a5d('0xb2')]['length'];_0x1dc0e5++){var _0x30213a={};_0x30213a[_0x20555e[_0x2a5d('0xb2')][_0x1dc0e5]]=_0x20555e[_0x20555e['duplicates'][_0x1dc0e5]];_0x2ae3b0['where'][_0x2a5d('0xb3')][_0x2a5d('0x59')](_0x30213a);}_0x2ae3b0['where'][_0x2a5d('0xb4')]=_0x20555e[_0x2a5d('0xb4')];}return db['CmContact'][_0x2a5d('0xb5')](_0x2ae3b0)[_0x2a5d('0xb6')](function(_0x1ddf74,_0x40b724){if(_0x40b724){_0x8f803c++;}else{_0x2e1a63++;}})[_0x2a5d('0x86')](function(){_0x2a6bc1++;});});})['then'](function(_0x32c9e6){if(_0x32c9e6){return{'success':_0x8f803c,'failure':_0x2a6bc1,'duplicates':_0x2e1a63};}})[_0x2a5d('0x17')](respondWithResult(_0x3bd771,0xc9))['catch'](handleError(_0x3bd771,null));};exports[_0x2a5d('0xb7')]=function(_0x50b2ae,_0x3c796e){var _0x11052b;return db[_0x2a5d('0x20')][_0x2a5d('0x21')]()[_0x2a5d('0x17')](function(_0x13b523){return db[_0x2a5d('0x20')]['find']({'where':{'id':_0x50b2ae['params']['id']},'include':[{'model':db[_0x2a5d('0x47')],'as':_0x2a5d('0x84'),'attributes':['id',_0x2a5d('0x1d'),'color'],'required':_0x50b2ae[_0x2a5d('0x2b')][_0x2a5d('0x5e')]?!![]:![]}],'attributes':_[_0x2a5d('0x23')](_0x13b523)});})[_0x2a5d('0x17')](function(_0x38d7cc){if(!_[_0x2a5d('0x57')](_0x38d7cc)){_0x11052b=_0x38d7cc[_0x2a5d('0x91')]({'plain':!![]});var _0x4d3281={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x38d7cc&&_0x38d7cc[_0x2a5d('0xb4')]){if(_0x38d7cc[_0x2a5d('0xb4')]){_0x4d3281['where'][_0x2a5d('0xb8')][_0x2a5d('0x59')]({'ListId':{'$ne':_0x38d7cc[_0x2a5d('0xb4')]}});}}return db[_0x2a5d('0x25')][_0x2a5d('0x90')](_0x4d3281);}})[_0x2a5d('0x17')](function(_0x14be8c){if(!_[_0x2a5d('0x57')](_0x14be8c)){return _['omit'](_0x11052b,_[_0x2a5d('0x55')](_0x14be8c,function(_0x200a64){return util[_0x2a5d('0xb9')](_0x2a5d('0xba'),_0x200a64['id']);}));}})[_0x2a5d('0x17')](handleEntityNotFound(_0x3c796e,null))[_0x2a5d('0x17')](respondWithResult(_0x3c796e,null))[_0x2a5d('0x86')](handleError(_0x3c796e,null));};exports['update']=function(_0x19448d,_0x12544c){var _0x5ce523;if(_0x19448d[_0x2a5d('0x8f')]['id']){delete _0x19448d[_0x2a5d('0x8f')]['id'];}if(!_[_0x2a5d('0x57')](_0x19448d[_0x2a5d('0x8f')][_0x2a5d('0xae')])){var _0x344464=_0x19448d[_0x2a5d('0x8f')][_0x2a5d('0xae')];if(!_[_0x2a5d('0x57')](shared[_0x2a5d('0xb0')][_0x344464]))_0x19448d[_0x2a5d('0x8f')][_0x2a5d('0xaf')]=shared[_0x2a5d('0xb0')][_0x344464][_0x2a5d('0xaf')];}return db[_0x2a5d('0x20')][_0x2a5d('0x45')]({'where':{'id':_0x19448d[_0x2a5d('0xbb')]['id']}})['then'](handleEntityNotFound(_0x12544c,null))[_0x2a5d('0x17')](saveUpdates(_0x19448d['body'],null))[_0x2a5d('0x17')](function(_0x1dfe82){_0x5ce523=_0x1dfe82;var _0x3e6892={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x1dfe82&&_0x1dfe82[_0x2a5d('0xb4')]){if(_0x1dfe82[_0x2a5d('0xb4')]){_0x3e6892[_0x2a5d('0x33')][_0x2a5d('0xb8')]['push']({'ListId':{'$ne':_0x1dfe82[_0x2a5d('0xb4')]}});}}return db[_0x2a5d('0x25')]['findAll'](_0x3e6892);})[_0x2a5d('0x17')](function(_0x4f89cc){if(_0x4f89cc){return _[_0x2a5d('0xbc')](_[_0x2a5d('0xbd')](_0x19448d[_0x2a5d('0x8f')],function(_0x4ca14e,_0x1e2adc){return _[_0x2a5d('0x88')](_0x1e2adc,_0x2a5d('0x24'));}),_[_0x2a5d('0x55')](_0x4f89cc,function(_0x874150){return util[_0x2a5d('0xb9')](_0x2a5d('0xba'),_0x874150['id']);}));}})['then'](function(_0x2a928a){if(_0x2a928a&&!_['isEmpty'](_0x2a928a)){var _0x138223=squel[_0x2a5d('0x16')]()[_0x2a5d('0xbe')](_0x2a5d('0xbf'))[_0x2a5d('0xc0')](_0x2a928a)['where'](_0x2a5d('0xc1'),_0x19448d[_0x2a5d('0xbb')]['id'])[_0x2a5d('0xc2')]();return db[_0x2a5d('0x78')][_0x2a5d('0x2b')](_0x138223[_0x2a5d('0x53')],{'replacements':_0x138223['values']});}})[_0x2a5d('0x17')](function(){if(_0x19448d[_0x2a5d('0x8f')][_0x2a5d('0xc3')]&&_0x5ce523){return db['CmHopper'][_0x2a5d('0x16')]({'phone':_0x19448d[_0x2a5d('0x8f')]['phone']},{'where':{'ContactId':_0x5ce523['id']}});}})['then'](function(){return _0x5ce523;})['then'](respondWithResult(_0x12544c,null))[_0x2a5d('0x86')](handleError(_0x12544c,null));};exports[_0x2a5d('0xc4')]=function(_0x55c3e4,_0xca8b18){var _0x85539d={};var _0x24ad4f={};var _0x2edf05;var _0x212f00;return db[_0x2a5d('0x20')][_0x2a5d('0xc5')]({'where':{'id':_0x55c3e4[_0x2a5d('0xbb')]['id']}})[_0x2a5d('0x17')](handleEntityNotFound(_0xca8b18,null))['then'](function(_0x36a327){if(_0x36a327){_0x2edf05=_0x36a327;_0x24ad4f['model']=_[_0x2a5d('0x23')](db[_0x2a5d('0x47')][_0x2a5d('0xc6')]);_0x24ad4f[_0x2a5d('0x2b')]=_[_0x2a5d('0x23')](_0x55c3e4[_0x2a5d('0x2b')]);_0x24ad4f[_0x2a5d('0x34')]=_[_0x2a5d('0x2c')](_0x24ad4f[_0x2a5d('0x2a')],_0x24ad4f['query']);_0x85539d[_0x2a5d('0x2e')]=_['intersection'](_0x24ad4f[_0x2a5d('0x2a')],qs[_0x2a5d('0x2d')](_0x55c3e4[_0x2a5d('0x2b')][_0x2a5d('0x2d')]));_0x85539d[_0x2a5d('0x2e')]=_0x85539d[_0x2a5d('0x2e')][_0x2a5d('0x22')]?_0x85539d[_0x2a5d('0x2e')]:_0x24ad4f[_0x2a5d('0x2a')];_0x85539d[_0x2a5d('0x6e')]=qs[_0x2a5d('0x32')](_0x55c3e4[_0x2a5d('0x2b')][_0x2a5d('0x32')]);_0x85539d[_0x2a5d('0x33')]=qs['filters'](_['pick'](_0x55c3e4[_0x2a5d('0x2b')],_0x24ad4f['filters']));if(_0x55c3e4['query'][_0x2a5d('0x56')]){_0x85539d['where']=_[_0x2a5d('0x8e')](_0x85539d[_0x2a5d('0x33')],{'$or':_[_0x2a5d('0x55')](_0x85539d[_0x2a5d('0x2e')],function(_0x51d907){var _0x20d12b={};_0x20d12b[_0x51d907]={'$like':'%'+_0x55c3e4['query'][_0x2a5d('0x56')]+'%'};return _0x20d12b;})});}_0x85539d=_[_0x2a5d('0x8e')]({},_0x85539d,_0x55c3e4[_0x2a5d('0xc7')]);return _0x2edf05['getTags'](_0x85539d);}})[_0x2a5d('0x17')](function(_0x5b3942){if(_0x5b3942){_0x212f00=_0x5b3942['length'];if(!_0x55c3e4['query'][_0x2a5d('0x2f')](_0x2a5d('0x30'))){_0x85539d[_0x2a5d('0x31')]=qs[_0x2a5d('0x31')](_0x55c3e4[_0x2a5d('0x2b')][_0x2a5d('0x31')]);_0x85539d[_0x2a5d('0x12')]=qs['offset'](_0x55c3e4[_0x2a5d('0x2b')][_0x2a5d('0x12')]);}return _0x2edf05['getTags'](_0x85539d);}})[_0x2a5d('0x17')](function(_0x393646){if(_0x393646){return _0x393646?{'count':_0x212f00,'rows':_0x393646}:null;}})[_0x2a5d('0x17')](respondWithResult(_0xca8b18,null))[_0x2a5d('0x86')](handleError(_0xca8b18,null));};exports[_0x2a5d('0xc8')]=function(_0x448da7,_0x5cdb06){if(_0x448da7[_0x2a5d('0x8f')]['id']){delete _0x448da7[_0x2a5d('0x8f')]['id'];}return db[_0x2a5d('0x20')][_0x2a5d('0xc5')]({'where':{'id':_0x448da7['params']['id']}})[_0x2a5d('0x17')](handleEntityNotFound(_0x5cdb06,null))[_0x2a5d('0x17')](function(_0xc9d5cd){if(_0xc9d5cd){return _0xc9d5cd[_0x2a5d('0xc8')](_0x448da7[_0x2a5d('0x8f')]['ids']||[]);}return null;})[_0x2a5d('0x17')](respondWithResult(_0x5cdb06,null))['catch'](handleError(_0x5cdb06,null));};exports[_0x2a5d('0xc9')]=function(_0x23f76d,_0xa00fe5){var _0x25f7a9={'raw':![],'where':{}};var _0x2d2557={};var _0x468a8a={'count':0x0,'rows':[]};return db[_0x2a5d('0x20')][_0x2a5d('0xc5')]({'where':{'id':_0x23f76d[_0x2a5d('0xbb')]['id']}})['then'](handleEntityNotFound(_0xa00fe5,null))['then'](function(_0x19c105){if(_0x19c105){_0x2d2557[_0x2a5d('0x2a')]=_[_0x2a5d('0x23')](db[_0x2a5d('0x96')][_0x2a5d('0xc6')]);_0x2d2557['query']=_['keys'](_0x23f76d['query']);_0x2d2557['filters']=_['intersection'](_0x2d2557['model'],_0x2d2557['query']);_0x25f7a9[_0x2a5d('0x2e')]=_[_0x2a5d('0x2c')](_0x2d2557[_0x2a5d('0x2a')],qs['fields'](_0x23f76d[_0x2a5d('0x2b')]['fields']));_0x25f7a9[_0x2a5d('0x2e')]=_0x25f7a9[_0x2a5d('0x2e')][_0x2a5d('0x22')]?_0x25f7a9[_0x2a5d('0x2e')]:_0x2d2557['model'];if(!_0x23f76d[_0x2a5d('0x2b')][_0x2a5d('0x2f')](_0x2a5d('0x30'))){_0x25f7a9[_0x2a5d('0x31')]=qs['limit'](_0x23f76d['query'][_0x2a5d('0x31')]);_0x25f7a9['offset']=qs[_0x2a5d('0x12')](_0x23f76d[_0x2a5d('0x2b')][_0x2a5d('0x12')]);}_0x25f7a9[_0x2a5d('0x6e')]=qs[_0x2a5d('0x32')](_0x23f76d[_0x2a5d('0x2b')][_0x2a5d('0x32')]);_0x25f7a9[_0x2a5d('0x33')]=qs[_0x2a5d('0x34')](_[_0x2a5d('0x35')](_0x23f76d['query'],_0x2d2557[_0x2a5d('0x34')]));_0x25f7a9[_0x2a5d('0x33')][_0x2a5d('0xca')]=_0x19c105['id'];if(_0x23f76d['query'][_0x2a5d('0x56')]){_0x25f7a9[_0x2a5d('0x33')]=_['merge'](_0x25f7a9[_0x2a5d('0x33')],{'$or':_[_0x2a5d('0x55')](_0x25f7a9[_0x2a5d('0x2e')],function(_0x147cff){var _0x30d04b={};_0x30d04b[_0x147cff]={'$like':'%'+_0x23f76d[_0x2a5d('0x2b')]['filter']+'%'};return _0x30d04b;})});}_0x25f7a9=_['merge']({},_0x25f7a9,_0x23f76d['options']);return db[_0x2a5d('0x96')][_0x2a5d('0x14')]({'where':_0x25f7a9['where']})[_0x2a5d('0x17')](function(_0x2a73a9){_0x468a8a[_0x2a5d('0x14')]=_0x2a73a9;if(_0x23f76d[_0x2a5d('0x2b')]['includeAll']){_0x25f7a9[_0x2a5d('0xcb')]=[{'all':!![]}];}return db['CmHopper'][_0x2a5d('0x90')](_0x25f7a9);})[_0x2a5d('0x17')](function(_0x257c60){_0x468a8a[_0x2a5d('0x85')]=_0x257c60;return _0x468a8a;});}})[_0x2a5d('0x17')](respondWithFilteredResult(_0xa00fe5,_0x25f7a9))['catch'](handleError(_0xa00fe5,null));};exports['getHopperHistories']=function(_0x566fd9,_0x2ee87c){var _0x436693={'raw':!![],'where':{}};var _0x254cff={};var _0x185abf={'count':0x0,'rows':[]};return db[_0x2a5d('0x20')][_0x2a5d('0xc5')]({'where':{'id':_0x566fd9[_0x2a5d('0xbb')]['id']}})[_0x2a5d('0x17')](handleEntityNotFound(_0x2ee87c,null))[_0x2a5d('0x17')](function(_0x4ee85c){if(_0x4ee85c){_0x254cff[_0x2a5d('0x2a')]=_[_0x2a5d('0x23')](db[_0x2a5d('0xa5')]['rawAttributes']);_0x254cff[_0x2a5d('0x2b')]=_[_0x2a5d('0x23')](_0x566fd9['query']);_0x254cff[_0x2a5d('0x34')]=_['intersection'](_0x254cff[_0x2a5d('0x2a')],_0x254cff[_0x2a5d('0x2b')]);_0x436693[_0x2a5d('0x2e')]=_[_0x2a5d('0x2c')](_0x254cff['model'],qs[_0x2a5d('0x2d')](_0x566fd9['query'][_0x2a5d('0x2d')]));_0x436693[_0x2a5d('0x2e')]=_0x436693['attributes'][_0x2a5d('0x22')]?_0x436693[_0x2a5d('0x2e')]:_0x254cff['model'];if(!_0x566fd9[_0x2a5d('0x2b')][_0x2a5d('0x2f')](_0x2a5d('0x30'))){_0x436693[_0x2a5d('0x31')]=qs[_0x2a5d('0x31')](_0x566fd9[_0x2a5d('0x2b')]['limit']);_0x436693['offset']=qs[_0x2a5d('0x12')](_0x566fd9['query'][_0x2a5d('0x12')]);}_0x436693['order']=qs[_0x2a5d('0x32')](_0x566fd9[_0x2a5d('0x2b')][_0x2a5d('0x32')]);_0x436693[_0x2a5d('0x33')]=qs[_0x2a5d('0x34')](_[_0x2a5d('0x35')](_0x566fd9[_0x2a5d('0x2b')],_0x254cff[_0x2a5d('0x34')]));_0x436693['where'][_0x2a5d('0xca')]=_0x4ee85c['id'];if(_0x566fd9['query'][_0x2a5d('0x56')]){_0x436693[_0x2a5d('0x33')]=_[_0x2a5d('0x8e')](_0x436693[_0x2a5d('0x33')],{'$or':_[_0x2a5d('0x55')](_0x436693['attributes'],function(_0x3cef9b){var _0x1307cb={};_0x1307cb[_0x3cef9b]={'$like':'%'+_0x566fd9[_0x2a5d('0x2b')][_0x2a5d('0x56')]+'%'};return _0x1307cb;})});}_0x436693=_[_0x2a5d('0x8e')]({},_0x436693,_0x566fd9[_0x2a5d('0xc7')]);return db[_0x2a5d('0xa5')][_0x2a5d('0x14')]({'where':_0x436693[_0x2a5d('0x33')]})['then'](function(_0x425d91){_0x185abf[_0x2a5d('0x14')]=_0x425d91;if(_0x566fd9[_0x2a5d('0x2b')][_0x2a5d('0xcc')]){_0x436693[_0x2a5d('0xcb')]=[{'all':!![]}];}return db[_0x2a5d('0xa5')][_0x2a5d('0x90')](_0x436693);})[_0x2a5d('0x17')](function(_0x1b812a){_0x185abf[_0x2a5d('0x85')]=_0x1b812a;return _0x185abf;});}})[_0x2a5d('0x17')](respondWithFilteredResult(_0x2ee87c,_0x436693))[_0x2a5d('0x86')](handleError(_0x2ee87c,null));};exports[_0x2a5d('0xcd')]=function(_0x3c6f33,_0x152299){var _0x5c0feb={'raw':!![],'where':{}};var _0x303813={};var _0x3e97ba={'count':0x0,'rows':[]};return db[_0x2a5d('0x20')][_0x2a5d('0xc5')]({'where':{'id':_0x3c6f33[_0x2a5d('0xbb')]['id']}})['then'](handleEntityNotFound(_0x152299,null))[_0x2a5d('0x17')](function(_0x4e3c0e){if(_0x4e3c0e){_0x303813[_0x2a5d('0x2a')]=_[_0x2a5d('0x23')](db['CmHopperFinal'][_0x2a5d('0xc6')]);_0x303813[_0x2a5d('0x2b')]=_[_0x2a5d('0x23')](_0x3c6f33[_0x2a5d('0x2b')]);_0x303813[_0x2a5d('0x34')]=_[_0x2a5d('0x2c')](_0x303813['model'],_0x303813[_0x2a5d('0x2b')]);_0x5c0feb[_0x2a5d('0x2e')]=_[_0x2a5d('0x2c')](_0x303813['model'],qs[_0x2a5d('0x2d')](_0x3c6f33[_0x2a5d('0x2b')][_0x2a5d('0x2d')]));_0x5c0feb[_0x2a5d('0x2e')]=_0x5c0feb['attributes']['length']?_0x5c0feb[_0x2a5d('0x2e')]:_0x303813[_0x2a5d('0x2a')];if(!_0x3c6f33[_0x2a5d('0x2b')]['hasOwnProperty'](_0x2a5d('0x30'))){_0x5c0feb[_0x2a5d('0x31')]=qs['limit'](_0x3c6f33['query'][_0x2a5d('0x31')]);_0x5c0feb[_0x2a5d('0x12')]=qs['offset'](_0x3c6f33[_0x2a5d('0x2b')]['offset']);}_0x5c0feb[_0x2a5d('0x6e')]=qs[_0x2a5d('0x32')](_0x3c6f33[_0x2a5d('0x2b')][_0x2a5d('0x32')]);_0x5c0feb[_0x2a5d('0x33')]=qs[_0x2a5d('0x34')](_[_0x2a5d('0x35')](_0x3c6f33[_0x2a5d('0x2b')],_0x303813[_0x2a5d('0x34')]));_0x5c0feb[_0x2a5d('0x33')][_0x2a5d('0xca')]=_0x4e3c0e['id'];if(_0x3c6f33['query']['filter']){_0x5c0feb[_0x2a5d('0x33')]=_[_0x2a5d('0x8e')](_0x5c0feb['where'],{'$or':_[_0x2a5d('0x55')](_0x5c0feb[_0x2a5d('0x2e')],function(_0x52ea13){var _0x2152ec={};_0x2152ec[_0x52ea13]={'$like':'%'+_0x3c6f33['query'][_0x2a5d('0x56')]+'%'};return _0x2152ec;})});}_0x5c0feb=_[_0x2a5d('0x8e')]({},_0x5c0feb,_0x3c6f33[_0x2a5d('0xc7')]);return db[_0x2a5d('0xa4')][_0x2a5d('0x14')]({'where':_0x5c0feb[_0x2a5d('0x33')]})['then'](function(_0x31d93b){_0x3e97ba[_0x2a5d('0x14')]=_0x31d93b;if(_0x3c6f33[_0x2a5d('0x2b')][_0x2a5d('0xcc')]){_0x5c0feb['include']=[{'all':!![]}];}return db['CmHopperFinal'][_0x2a5d('0x90')](_0x5c0feb);})[_0x2a5d('0x17')](function(_0x3de4da){_0x3e97ba['rows']=_0x3de4da;return _0x3e97ba;});}})[_0x2a5d('0x17')](respondWithFilteredResult(_0x152299,_0x5c0feb))[_0x2a5d('0x86')](handleError(_0x152299,null));};exports['getJscriptySessions']=function(_0x5b75b0,_0x39a655){var _0x48eae7={'raw':!![],'where':{}};var _0x3ccb27={};var _0xfd3a1b={'count':0x0,'rows':[]};return db[_0x2a5d('0x20')][_0x2a5d('0xc5')]({'where':{'id':_0x5b75b0[_0x2a5d('0xbb')]['id']}})[_0x2a5d('0x17')](handleEntityNotFound(_0x39a655,null))['then'](function(_0x4c3eb9){if(_0x4c3eb9){_0x3ccb27[_0x2a5d('0x2a')]=_[_0x2a5d('0x23')](db[_0x2a5d('0xce')][_0x2a5d('0xc6')]);_0x3ccb27[_0x2a5d('0x2b')]=_[_0x2a5d('0x23')](_0x5b75b0[_0x2a5d('0x2b')]);_0x3ccb27[_0x2a5d('0x34')]=_[_0x2a5d('0x2c')](_0x3ccb27['model'],_0x3ccb27['query']);_0x48eae7[_0x2a5d('0x2e')]=_[_0x2a5d('0x2c')](_0x3ccb27[_0x2a5d('0x2a')],qs[_0x2a5d('0x2d')](_0x5b75b0[_0x2a5d('0x2b')][_0x2a5d('0x2d')]));_0x48eae7[_0x2a5d('0x2e')]=_0x48eae7[_0x2a5d('0x2e')]['length']?_0x48eae7[_0x2a5d('0x2e')]:_0x3ccb27[_0x2a5d('0x2a')];if(!_0x5b75b0['query'][_0x2a5d('0x2f')](_0x2a5d('0x30'))){_0x48eae7[_0x2a5d('0x31')]=qs[_0x2a5d('0x31')](_0x5b75b0[_0x2a5d('0x2b')][_0x2a5d('0x31')]);_0x48eae7[_0x2a5d('0x12')]=qs['offset'](_0x5b75b0['query'][_0x2a5d('0x12')]);}_0x48eae7['order']=qs['sort'](_0x5b75b0[_0x2a5d('0x2b')][_0x2a5d('0x32')]);_0x48eae7['where']=qs[_0x2a5d('0x34')](_[_0x2a5d('0x35')](_0x5b75b0[_0x2a5d('0x2b')],_0x3ccb27[_0x2a5d('0x34')]));_0x48eae7['where'][_0x2a5d('0xca')]=_0x4c3eb9['id'];if(_0x5b75b0[_0x2a5d('0x2b')][_0x2a5d('0x56')]){_0x48eae7['where']=_[_0x2a5d('0x8e')](_0x48eae7[_0x2a5d('0x33')],{'$or':_[_0x2a5d('0x55')](_0x48eae7[_0x2a5d('0x2e')],function(_0x3df516){var _0x5827c9={};_0x5827c9[_0x3df516]={'$like':'%'+_0x5b75b0[_0x2a5d('0x2b')][_0x2a5d('0x56')]+'%'};return _0x5827c9;})});}_0x48eae7=_['merge']({},_0x48eae7,_0x5b75b0['options']);return db[_0x2a5d('0xce')]['count']({'where':_0x48eae7['where']})[_0x2a5d('0x17')](function(_0x180cd3){_0xfd3a1b['count']=_0x180cd3;if(_0x5b75b0['query'][_0x2a5d('0xcc')]){_0x48eae7[_0x2a5d('0xcb')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0x2a5d('0x90')](_0x48eae7);})[_0x2a5d('0x17')](function(_0xbff1c3){_0xfd3a1b[_0x2a5d('0x85')]=_0xbff1c3;return _0xfd3a1b;});}})[_0x2a5d('0x17')](respondWithFilteredResult(_0x39a655,_0x48eae7))['catch'](handleError(_0x39a655,null));};exports[_0x2a5d('0xcf')]=function(_0x267bb0,_0x2f5f9b){try{if(!_0x267bb0[_0x2a5d('0x8f')][_0x2a5d('0xb4')]){throw new Error('No\x20ListId\x20specified');}if(!_0x267bb0[_0x2a5d('0x8f')]['binding_keys']){throw new Error(_0x2a5d('0xd0'));}if(!_0x267bb0[_0x2a5d('0x8f')][_0x2a5d('0xd1')]){throw new Error(_0x2a5d('0xd2'));}if(!_0x267bb0[_0x2a5d('0x8f')][_0x2a5d('0xd3')]){throw new Error(_0x2a5d('0xd4'));}var _0x5a1475=_0x267bb0[_0x2a5d('0x8f')][_0x2a5d('0xd5')]['split'](',');var _0x1fef1d=_0x267bb0[_0x2a5d('0x8f')][_0x2a5d('0xd1')][_0x2a5d('0x49')](',');if(!_0x5a1475[_0x2a5d('0x22')]||!_0x1fef1d[_0x2a5d('0x22')]||_0x5a1475['length']!==_0x1fef1d[_0x2a5d('0x22')]){throw new Error(_0x2a5d('0xd6'));}_0x267bb0['body'][_0x2a5d('0x2d')]=_[_0x2a5d('0xd7')](_0x5a1475,_0x1fef1d);if(!_0x267bb0[_0x2a5d('0x8f')][_0x2a5d('0x2d')][_0x2a5d('0xc3')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x267bb0[_0x2a5d('0x8f')][_0x2a5d('0x2d')][_0x2a5d('0xd8')]){throw new Error(_0x2a5d('0xd9'));}var _0x40437d=path[_0x2a5d('0x93')](config[_0x2a5d('0xda')],_0x2a5d('0xdb'),_0x267bb0['file']['filename']);fs[_0x2a5d('0xdc')](_0x40437d,parseInt('0777',0x8));var _0x3a97a2=require(_0x2a5d('0xdd'))[_0x2a5d('0xde')](path['join'](__dirname,_0x2a5d('0xdf')),[_0x40437d,_0x267bb0[_0x2a5d('0x8f')][_0x2a5d('0xd5')],_0x267bb0[_0x2a5d('0x8f')][_0x2a5d('0xd1')],_0x267bb0[_0x2a5d('0x8f')][_0x2a5d('0xb4')],_0x267bb0[_0x2a5d('0x8f')][_0x2a5d('0xe0')],_0x267bb0[_0x2a5d('0x8f')][_0x2a5d('0xb2')],_0x267bb0['body'][_0x2a5d('0xd3')]]);return _0x2f5f9b[_0x2a5d('0x10')](0xc8)[_0x2a5d('0x11')]({'message':_0x2a5d('0xe1'),'pid':_0x3a97a2['pid']});}catch(_0x2e100d){return _0x2f5f9b['status'](0x1f4)[_0x2a5d('0x1e')](_0x2e100d);}};exports[_0x2a5d('0xe2')]=function(_0x40b88f,_0x29aefa){var _0x36d956=fs[_0x2a5d('0xe3')](_0x40b88f[_0x2a5d('0xe4')][_0x2a5d('0xe5')]);Papa[_0x2a5d('0xe6')](_0x36d956,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0xc7eb1c){return _0x29aefa[_0x2a5d('0x10')](0xc8)[_0x2a5d('0x11')]({'file':_0x40b88f[_0x2a5d('0xe4')],'fields':_0xc7eb1c[_0x2a5d('0xe7')][_0x2a5d('0x2d')]});}});};exports[_0x2a5d('0xe8')]=function(_0x1d078b,_0x27e79b){return db[_0x2a5d('0x4c')][_0x2a5d('0x90')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0x2a5d('0x17')](function(_0x1f0eed){var _0xede8da=![];if(!_0x1d078b[_0x2a5d('0x8f')]['ListId']){throw new Error(_0x2a5d('0xe9'));}if(!_0x1d078b[_0x2a5d('0x8f')]['binding'][_0x2a5d('0xc3')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x1d078b[_0x2a5d('0x8f')]['binding'][_0x2a5d('0xd8')]){throw new Error(_0x2a5d('0xd9'));}if(!_0x1d078b[_0x2a5d('0x8f')][_0x2a5d('0xd3')]){throw new Error(_0x2a5d('0xd4'));}var _0x273801=require(_0x2a5d('0xdd'))[_0x2a5d('0xde')](path['join'](__dirname,_0x2a5d('0xea')),[_0x1d078b[_0x2a5d('0xbb')]['id'],JSON['stringify'](_0x1d078b[_0x2a5d('0x8f')]),JSON['stringify'](_0x1f0eed)]);_0x273801['on'](_0x2a5d('0xeb'),function(){_0xede8da=!![];return _0x27e79b[_0x2a5d('0x10')](0xc8)[_0x2a5d('0x11')]({'message':'start\x20child\x20process\x20correctly!','pid':_0x273801[_0x2a5d('0xec')]});});_0x273801['on'](_0x2a5d('0xed'),function(_0x383a66){if(_0x383a66&&!_0xede8da){return _0x27e79b[_0x2a5d('0x10')](0x1f4)[_0x2a5d('0x11')]({'message':_0x2a5d('0xee'),'pid':_0x273801[_0x2a5d('0xec')]});}});})[_0x2a5d('0x86')](handleError(_0x27e79b,null));};exports['getJourney']=function(_0x10bc20,_0x2e48e6){var _0x1ebb59=['mail',_0x2a5d('0xef'),_0x2a5d('0xf0'),_0x2a5d('0xf1'),_0x2a5d('0xf2'),_0x2a5d('0xf3'),_0x2a5d('0xf4')];var _0x57a157={'offset':0x0,'order':qs[_0x2a5d('0x32')](_0x2a5d('0xf5'))},_0x39f7c0={'count':0x0,'rows':[]};Promise[_0x2a5d('0x71')]()[_0x2a5d('0x17')](function(){if(_0x10bc20[_0x2a5d('0x2b')]['channel']){if(!_['includes'](_0x1ebb59,_0x10bc20[_0x2a5d('0x2b')][_0x2a5d('0xf6')]['toLowerCase']())){throw new Error('Invalid\x20channel');}_0x1ebb59=[_0x10bc20[_0x2a5d('0x2b')]['channel'][_0x2a5d('0xf7')]()];}if(_0x10bc20[_0x2a5d('0x2b')]['range']){try{var _0x168de5=JSON['parse'](_0x10bc20['query'][_0x2a5d('0xf8')]);if(!moment(_0x168de5['from'])[_0x2a5d('0xf9')]()){throw new Error('Invalid\x20date\x20for\x20range\x20from\x20filter');}if(!moment(_0x168de5['to'])['isValid']()){throw new Error('Invalid\x20date\x20for\x20range\x20to\x20filter');}}catch(_0x27f771){throw new Error('Invalid\x20createdAt\x20filter');}}if(!_0x10bc20[_0x2a5d('0x2b')]['hasOwnProperty'](_0x2a5d('0x30'))){_0x57a157[_0x2a5d('0x31')]=qs[_0x2a5d('0x31')](_0x10bc20[_0x2a5d('0x2b')]['limit']||0xa);_0x57a157[_0x2a5d('0x12')]=qs[_0x2a5d('0x12')](_0x10bc20[_0x2a5d('0x2b')][_0x2a5d('0x12')]);}var _0xcc79ac=_0x1ebb59[_0x2a5d('0x55')](function(_0x5647f7){if(_0x5647f7===_0x2a5d('0xf4')){var _0x30d8d={'attributes':['id','uniqueid',_0x2a5d('0x29'),_0x2a5d('0xfa'),_0x2a5d('0xfb'),'callerid',_0x2a5d('0xfc'),'endtime','duration',_0x2a5d('0xfd'),_0x2a5d('0xfe'),_0x2a5d('0xff'),_0x2a5d('0x100'),_0x2a5d('0x101'),_0x2a5d('0x102')],'where':{'ContactId':_0x10bc20[_0x2a5d('0xbb')]['id']},'include':[{'model':db['User'],'as':'User','attributes':['id','name',_0x2a5d('0x103'),'alias']}],'order':[[_0x2a5d('0xfe'),_0x2a5d('0x104')]]};if(_0x10bc20[_0x2a5d('0x2b')][_0x2a5d('0xf8')]){_0x30d8d[_0x2a5d('0x33')][_0x2a5d('0xfe')]={'$gte':_0x168de5[_0x2a5d('0x37')],'$lte':_0x168de5['to']};}return db[_0x2a5d('0xa6')]['findAndCountAll'](_0x30d8d)[_0x2a5d('0x17')](function(_0x5f35b4){_0x39f7c0[_0x2a5d('0x14')]+=_0x5f35b4[_0x2a5d('0x14')];return _['map'](_0x5f35b4[_0x2a5d('0x85')],function(_0x5cd104){var _0x501fcb=_0x5cd104['get']({'plain':!![]});_0x501fcb[_0x2a5d('0xf6')]=_0x5647f7;if(_0x501fcb['User']){_0x501fcb[_0x2a5d('0x4c')]={'id':_0x501fcb['User']['id'],'name':_0x501fcb[_0x2a5d('0x4c')][_0x2a5d('0x1d')],'fullname':_0x501fcb[_0x2a5d('0x4c')][_0x2a5d('0x103')],'alias':_0x501fcb[_0x2a5d('0x4c')]['alias']};}return _0x501fcb;});});}else{var _0x3b45cf=_['startCase'](_0x5647f7)+(_0x5647f7===_0x2a5d('0xef')?_0x2a5d('0x105'):_0x2a5d('0x106'));var _0x4c3c50={'attributes':['id',_0x2a5d('0x107'),_0x2a5d('0x108'),_0x2a5d('0xfe'),_0x2a5d('0xfd'),_0x2a5d('0x109'),_0x2a5d('0x10a'),_0x2a5d('0x10b'),_0x2a5d('0x102'),_0x3b45cf+'Id'],'where':{'ContactId':_0x10bc20['params']['id']},'include':[{'model':db[_0x3b45cf],'as':_0x2a5d('0x106'),'attributes':['id','name',_0x2a5d('0x10c')]},{'model':db[_0x2a5d('0x4c')],'as':'Owner','attributes':['id',_0x2a5d('0x1d'),'fullname']},{'model':db[_0x2a5d('0x47')],'as':_0x2a5d('0x84'),'attributes':['id',_0x2a5d('0x1d'),_0x2a5d('0x36')],'through':{'attributes':[]}}],'order':[[_0x2a5d('0xfe'),_0x2a5d('0x104')]]};if(_0x10bc20[_0x2a5d('0x2b')][_0x2a5d('0xf8')]){_0x4c3c50['where'][_0x2a5d('0xfe')]={'$gte':_0x168de5[_0x2a5d('0x37')],'$lte':_0x168de5['to']};}switch(_0x5647f7){case'chat':_0x4c3c50[_0x2a5d('0x2e')][_0x2a5d('0x59')](_0x2a5d('0x10d'),_0x2a5d('0x10e'),_0x2a5d('0x10f'),_0x2a5d('0x110'),_0x2a5d('0x111'),_0x2a5d('0x112'),_0x2a5d('0x113'),_0x2a5d('0x114'),_0x2a5d('0x115'));break;case _0x2a5d('0x116'):_0x4c3c50['attributes']['push'](_0x2a5d('0x117'),_0x2a5d('0x118'));break;case _0x2a5d('0xf1'):_0x4c3c50[_0x2a5d('0x2e')][_0x2a5d('0x59')]('externalUrl','threadId');break;}return db[_[_0x2a5d('0x119')](_0x5647f7)+_0x2a5d('0x11a')][_0x2a5d('0x11b')](_0x4c3c50)[_0x2a5d('0x17')](function(_0xfa9b74){_0x39f7c0[_0x2a5d('0x14')]+=_0xfa9b74[_0x2a5d('0x14')];return _[_0x2a5d('0x55')](_0xfa9b74[_0x2a5d('0x85')],function(_0x1d31ff){var _0x24b11a=_0x1d31ff[_0x2a5d('0x91')]({'plain':!![]});_0x24b11a[_0x2a5d('0xf6')]=_0x5647f7;if(_0x24b11a[_0x2a5d('0x11c')]){_0x24b11a[_0x2a5d('0x11c')]={'id':_0x24b11a[_0x2a5d('0x11c')]['id'],'name':_0x24b11a[_0x2a5d('0x11c')][_0x2a5d('0x1d')],'fullname':_0x24b11a[_0x2a5d('0x11c')][_0x2a5d('0x103')]};}return _0x24b11a;});});}});return Promise[_0x2a5d('0x27')](_0xcc79ac);})[_0x2a5d('0x17')](function(_0xcb33a1){return _(_0xcb33a1)[_0x2a5d('0x11d')]()[_0x2a5d('0x11e')]('createdAt')[_0x2a5d('0x11f')]()[_0x2a5d('0x48')]();})[_0x2a5d('0x17')](function(_0x38fe77){_0x39f7c0[_0x2a5d('0x85')]=_0x57a157['limit']?_0x38fe77[_0x2a5d('0x120')](_0x57a157['offset'],_0x57a157[_0x2a5d('0x12')]+_0x57a157[_0x2a5d('0x31')]):_0x38fe77;return _0x39f7c0;})['then'](respondWithFilteredResult(_0x2e48e6,_0x57a157))[_0x2a5d('0x86')](handleError(_0x2e48e6,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff