// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x1948=['userSecondDisposition','DESC','findAndCountAll','fullname','startCase','Website','Account','closed','closedAt','secondDisposition','thirdDisposition','UserId','Owner','browserName','customerPort','deviceModel','osName','ratingMessage','ratingType','ratingValue','referer','substatus','threadId','Interaction','all','flatten','sortBy','reverse','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','ejs','squel','crypto','desk.js','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./cmContact.socket','register','sendStatus','status','end','count','offset','set','json','reject','save','update','then','name','send','index','describe','keys','startsWith','cf_','push','findOne','fieldType','type','query','filters','intersection','attributes','model','fields','length','hasOwnProperty','limit','order','sort','pick','select','field','from','tools_tags','cm_contacts','left_join','uc.CmContactId\x20=\x20c.id','cm_contact_has_tags','ct.CmContactId\x20=\x20c.id','t.id\x20=\x20ct.TagId','c.deletedAt\x20IS\x20NULL','expr','parseSearch','search','sqlOperator','conditions','find','Tag','value','split','map','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','uc.UserId\x20=\x20?','datetime','castTo','DATE','buildExpression','text','start','filter','isNil','Contact','isEmpty','ListId','where','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','tag','isArray','replace','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','isNumeric','c.id\x20LIKE\x20?','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','group','c.id','SELECT','clone','having','t.id\x20IN\x20?','resolve','user','role','agent','some','getLists','c.ListId\x20IS\x20NULL','c.ListId\x20IN\x20?','sequelize','toString','merge','CmContact','c.lastName','c.phone','c.mobile','c.fax','c.email','c.deletedAt','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','Tags','rows','destroy','columnName','displayName','CmCustomField','findAll','alias','body','get','mergeWith','tags','join','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','CmHopperBlack','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','FaxMessage','CmHopperFinal','ReportAgentPreview','VoiceCallReport','FaxQueueReport','MailQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappMessage','WhatsappQueueReport','catch','bulkCreate','each','duplicates','$or','findOrCreate','error','show','params','color','$and','omit','format','cf_%d','setFields','id\x20=\x20?','toParam','values','phone','getTags','rawAttributes','options','nolimit','setTags','getHoppers','ContactId','getHopperHistories','CmHopperHistory','includeAll','include','getHopperFinals','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','Incorrect\x20binding\x20parameters\x20passed!','zipObject','firstName','No\x20firstName\x20column\x20specified','root','server/files/tmp','file','filename','0777','fork','../../components/import/cm/csv','CompanyId','socket_timestamp','File\x20uploaded\x20correctly!','pid','upload','createReadStream','meta','import','binding','No\x20phone\x20column\x20specified','child_process','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','exit','getJourney','mail','chat','fax','whatsapp','-createdAt','channel','includes','toLowerCase','Invalid\x20channel','range','parse','isValid','Invalid\x20date\x20for\x20range\x20from\x20filter','Invalid\x20createdAt\x20filter','uniqueid','destination','endtime','duration','note','createdAt','userDisposition'];(function(_0x2d64fc,_0x42b2a7){var _0x2c8556=function(_0x4b29da){while(--_0x4b29da){_0x2d64fc['push'](_0x2d64fc['shift']());}};_0x2c8556(++_0x42b2a7);}(_0x1948,0x145));var _0x8194=function(_0x1ef912,_0xe60aa9){_0x1ef912=_0x1ef912-0x0;var _0x4b7aff=_0x1948[_0x1ef912];return _0x4b7aff;};'use strict';var pdf=require(_0x8194('0x0'));var emlformat=require(_0x8194('0x1'));var rimraf=require(_0x8194('0x2'));var zipdir=require(_0x8194('0x3'));var jsonpatch=require(_0x8194('0x4'));var rp=require('request-promise');var moment=require(_0x8194('0x5'));var BPromise=require(_0x8194('0x6'));var Mustache=require(_0x8194('0x7'));var util=require(_0x8194('0x8'));var path=require(_0x8194('0x9'));var sox=require(_0x8194('0xa'));var csv=require(_0x8194('0xb'));var ejs=require(_0x8194('0xc'));var fs=require('fs');var _=require('lodash');var squel=require(_0x8194('0xd'));var crypto=require(_0x8194('0xe'));var jsforce=require('jsforce');var deskjs=require(_0x8194('0xf'));var toCsv=require(_0x8194('0xb'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0x8194('0x10'));var authService=require(_0x8194('0x11'));var qs=require(_0x8194('0x12'));var as=require(_0x8194('0x13'));var hardwareService=require(_0x8194('0x14'));var logger=require('../../config/logger')(_0x8194('0x15'));var utils=require(_0x8194('0x16'));var config=require(_0x8194('0x17'));var licenseUtil=require('../../config/license/util');var db=require(_0x8194('0x18'))['db'];config[_0x8194('0x19')]=_[_0x8194('0x1a')](config[_0x8194('0x19')],{'host':_0x8194('0x1b'),'port':0x18eb});var socket=require(_0x8194('0x1c'))(new Redis(config['redis']));require(_0x8194('0x1d'))[_0x8194('0x1e')](socket);function respondWithStatusCode(_0xfd031c,_0x2ab425){_0x2ab425=_0x2ab425||0xcc;return function(_0x2d4463){if(_0x2d4463){return _0xfd031c[_0x8194('0x1f')](_0x2ab425);}return _0xfd031c[_0x8194('0x20')](_0x2ab425)[_0x8194('0x21')]();};}function respondWithResult(_0x19c23e,_0x5abd09){_0x5abd09=_0x5abd09||0xc8;return function(_0x49731d){if(_0x49731d){return _0x19c23e[_0x8194('0x20')](_0x5abd09)['json'](_0x49731d);}};}function respondWithFilteredResult(_0x41a11e,_0x4afbe3){return function(_0x55e4c2){if(_0x55e4c2){var _0x5f2172=_0x55e4c2[_0x8194('0x22')],_0x37b048=_0x4afbe3[_0x8194('0x23')],_0x43a192=_0x4afbe3[_0x8194('0x23')]+_0x4afbe3['limit'],_0x48421e;if(_0x43a192>=_0x5f2172){_0x43a192=_0x5f2172;_0x48421e=0xc8;}else{_0x48421e=0xce;}_0x41a11e['status'](_0x48421e);return _0x41a11e[_0x8194('0x24')]('Content-Range',_0x37b048+'-'+_0x43a192+'/'+_0x5f2172)[_0x8194('0x25')](_0x55e4c2);}return null;};}function patchUpdates(_0x24d1ff){return function(_0x9421f5){try{jsonpatch['apply'](_0x9421f5,_0x24d1ff,!![]);}catch(_0x3cdb81){return BPromise[_0x8194('0x26')](_0x3cdb81);}return _0x9421f5[_0x8194('0x27')]();};}function saveUpdates(_0x28df4f,_0x1babf1){return function(_0x17dcde){if(_0x17dcde){return _0x17dcde[_0x8194('0x28')](_0x28df4f)[_0x8194('0x29')](function(_0x269a22){return _0x269a22;});}return null;};}function removeEntity(_0x263093,_0xbb64b7){return function(_0x300491){if(_0x300491){return _0x300491['destroy']()[_0x8194('0x29')](function(){_0x263093[_0x8194('0x20')](0xcc)[_0x8194('0x21')]();});}};}function handleEntityNotFound(_0x46a242,_0x55b0d9){return function(_0x34c430){if(!_0x34c430){_0x46a242[_0x8194('0x1f')](0x194);}return _0x34c430;};}function handleError(_0x425a1d,_0x42c3b0){_0x42c3b0=_0x42c3b0||0x1f4;return function(_0x3e8cb3){logger['error'](_0x3e8cb3['stack']);if(_0x3e8cb3[_0x8194('0x2a')]){delete _0x3e8cb3[_0x8194('0x2a')];}_0x425a1d[_0x8194('0x20')](_0x42c3b0)[_0x8194('0x2b')](_0x3e8cb3);};}exports[_0x8194('0x2c')]=function(_0x56c512,_0x4af9cc){var _0x5624a0={},_0x1ea1f={},_0x56b5bc={'count':0x0,'rows':[]};return db['CmContact'][_0x8194('0x2d')]()[_0x8194('0x29')](function(_0x4ee84e){var _0x1ef19a=[];for(var _0x58f209=0x0;_0x58f209<Object[_0x8194('0x2e')](_0x4ee84e)['length'];_0x58f209++){var _0x2fa6ff=Object[_0x8194('0x2e')](_0x4ee84e)[_0x58f209];if(_[_0x8194('0x2f')](_0x2fa6ff,_0x8194('0x30'))){_0x1ef19a[_0x8194('0x31')](db['CmCustomField'][_0x8194('0x32')]({'where':{'id':_['trimStart'](_0x2fa6ff,_0x8194('0x30'))},'raw':!![]}));}}return BPromise['all'](_0x1ef19a)[_0x8194('0x29')](function(_0x275dac){for(var _0x371daf=0x0;_0x371daf<_0x275dac['length'];_0x371daf++){if(_0x275dac[_0x371daf]){var _0x56ac52=_0x8194('0x30')+_0x275dac[_0x371daf]['id'];var _0x2582ea=_0x4ee84e[_0x56ac52];_0x2582ea[_0x8194('0x33')]=_0x275dac[_0x371daf][_0x8194('0x34')];}}return _0x4ee84e;});})['then'](function(_0x52d0d2){_0x1ea1f['model']=_[_0x8194('0x2e')](_0x52d0d2);_0x1ea1f[_0x8194('0x35')]=_[_0x8194('0x2e')](_0x56c512[_0x8194('0x35')]);_0x1ea1f[_0x8194('0x36')]=_[_0x8194('0x37')](_0x1ea1f['model'],_0x1ea1f[_0x8194('0x35')]);_0x5624a0[_0x8194('0x38')]=_[_0x8194('0x37')](_0x1ea1f[_0x8194('0x39')],qs[_0x8194('0x3a')](_0x56c512[_0x8194('0x35')][_0x8194('0x3a')]));_0x5624a0[_0x8194('0x38')]=_0x5624a0[_0x8194('0x38')][_0x8194('0x3b')]?_0x5624a0[_0x8194('0x38')]:_0x1ea1f[_0x8194('0x39')];if(!_0x56c512['query'][_0x8194('0x3c')]('nolimit')){_0x5624a0['limit']=qs[_0x8194('0x3d')](_0x56c512[_0x8194('0x35')]['limit']);_0x5624a0['offset']=qs['offset'](_0x56c512['query']['offset']);}_0x5624a0[_0x8194('0x3e')]=qs[_0x8194('0x3f')](_0x56c512[_0x8194('0x35')]['sort']);_0x5624a0['where']=qs['filters'](_[_0x8194('0x40')](_0x56c512[_0x8194('0x35')],_0x1ea1f[_0x8194('0x36')]),_0x52d0d2);var _0x2256d8=[];var _0x4aa53a=squel[_0x8194('0x41')]()[_0x8194('0x42')]('id')[_0x8194('0x42')](_0x8194('0x2a'))[_0x8194('0x42')]('color')[_0x8194('0x43')](_0x8194('0x44'));var _0x369856=squel[_0x8194('0x41')]()[_0x8194('0x43')](_0x8194('0x45'),'c')[_0x8194('0x46')]('cm_user_has_contacts','uc',_0x8194('0x47'))[_0x8194('0x46')](_0x8194('0x48'),'ct',_0x8194('0x49'))['left_join']('tools_tags','t',_0x8194('0x4a'))['where'](_0x8194('0x4b'));var _0x4c0350=squel[_0x8194('0x4c')]();var _0x573003=[];var _0x1200c8=squel[_0x8194('0x4c')]();var _0x958766;if(_0x56c512[_0x8194('0x35')]['search']){_0x958766=as[_0x8194('0x4d')](_0x56c512[_0x8194('0x35')][_0x8194('0x4e')]);var _0x4b05ae=_0x958766[_0x8194('0x4f')];for(var _0x200273=0x0;_0x200273<_0x958766[_0x8194('0x50')][_0x8194('0x3b')];_0x200273++){var _0x251d29=_0x958766['conditions'][_0x200273];var _0x27b4cb='c';var _0x51f8d5=_(_0x52d0d2)[_0x8194('0x2e')]()[_0x8194('0x51')](function(_0xeef7db){return _0xeef7db===_0x251d29[_0x8194('0x42')];});if(_0x51f8d5)_0x51f8d5=_0x52d0d2[_0x251d29[_0x8194('0x42')]];if(!_0x51f8d5){if(_0x251d29[_0x8194('0x42')]===_0x8194('0x52')){var _0x4ac75e=_0x251d29[_0x8194('0x53')][_0x8194('0x54')](',')[_0x8194('0x55')](function(_0x98c012){return Number(_0x98c012);});_0x4ac75e[_0x8194('0x56')](function(_0x349e27){_0x1200c8['or'](_0x8194('0x57'),'%,'+_0x349e27+',%');});_0x573003=_[_0x8194('0x58')](_0x573003,_0x4ac75e);}else if(_0x251d29[_0x8194('0x42')]===_0x8194('0x59')){_0x4c0350['and'](_0x8194('0x5a'),_0x251d29[_0x8194('0x53')]);}}else{if(_0x251d29['field']==='dateOfBirth'||_0x51f8d5[_0x8194('0x33')]===_0x8194('0x5b'))_0x251d29[_0x8194('0x5c')]=_0x8194('0x5d');var _0x3f85af=as[_0x8194('0x5e')](_0x27b4cb,_0x51f8d5[_0x8194('0x34')],_0x251d29);_0x4c0350[_0x4b05ae](_0x3f85af[_0x8194('0x5f')],_0x3f85af[_0x8194('0x53')][_0x8194('0x60')],_0x3f85af['value']['end']);}}}else{var _0x510f6d=_(Object['keys'](_0x56c512[_0x8194('0x35')]))[_0x8194('0x55')](function(_0x899688){return _0x52d0d2[_0x8194('0x3c')](_0x899688)?_0x899688:undefined;})[_0x8194('0x61')](function(_0x4631b6){return!_[_0x8194('0x62')](_0x4631b6);})[_0x8194('0x53')]();if(_0x56c512[_0x8194('0x35')]['Contact'])_0x510f6d['push'](_0x8194('0x63'));if(!_[_0x8194('0x64')](_0x510f6d)){_0x510f6d[_0x8194('0x56')](function(_0x250651){if(_0x250651===_0x8194('0x65')){_0x369856[_0x8194('0x66')]('c.ListId\x20IN\x20?',[][_0x8194('0x67')](_0x56c512[_0x8194('0x35')][_0x250651]));}else if(_0x250651===_0x8194('0x63')){var _0x1c02cd='%'+_0x56c512[_0x8194('0x35')][_0x250651]+'%';_0x369856[_0x8194('0x66')](_0x8194('0x68'),_0x1c02cd);}else{_0x369856[_0x8194('0x66')]('c.'+_0x250651+'\x20=\x20?',_0x56c512[_0x8194('0x35')][_0x250651]);}});}if(_0x56c512[_0x8194('0x35')][_0x8194('0x69')]){_0x573003=_[_0x8194('0x6a')](_0x56c512[_0x8194('0x35')][_0x8194('0x69')])?_0x56c512[_0x8194('0x35')][_0x8194('0x69')]:new Array(_0x56c512[_0x8194('0x35')][_0x8194('0x69')]);_0x573003[_0x8194('0x56')](function(_0x52d4ec){_0x1200c8['or'](_0x8194('0x57'),'%,'+_0x52d4ec+',%');});}if(_0x56c512[_0x8194('0x35')][_0x8194('0x61')]){var _0xfaa533=_0x56c512['query']['filter'][_0x8194('0x6b')]('\x5c','\x5c\x5c')[_0x8194('0x6b')](/'/g,'\x27\x27');if(_0xfaa533[_0x8194('0x54')]('\x20')[_0x8194('0x3b')]>0x1){_0x4c0350['or'](_0x8194('0x6c'),qs['getFullTextValue'](_0xfaa533),null);}else{if(qs[_0x8194('0x6d')](_0xfaa533)){_0x4c0350['or'](_0x8194('0x6e'),_0xfaa533+'%');_0x4c0350['or'](_0x8194('0x6f'),_0xfaa533+'%');_0x4c0350['or'](_0x8194('0x70'),_0xfaa533+'%');_0x4c0350['or'](_0x8194('0x71'),_0xfaa533+'%');}else if(qs[_0x8194('0x72')](_0xfaa533)){_0x4c0350['or'](_0x8194('0x73'),_0xfaa533+'%');}else{_0x4c0350['or'](_0x8194('0x74'),'%'+_0xfaa533+'%');_0x4c0350['or'](_0x8194('0x75'),'%'+_0xfaa533+'%');_0x4c0350['or'](_0x8194('0x73'),'%'+_0xfaa533+'%');}}}}_0x369856[_0x8194('0x66')](_0x4c0350);_0x369856[_0x8194('0x76')](_0x8194('0x77'));var _0x545068={'type':db['Sequelize']['QueryTypes'][_0x8194('0x78')],'raw':!![]};var _0x42f541=_0x369856[_0x8194('0x79')]()['field'](_0x8194('0x77'));if(_0x5624a0[_0x8194('0x3e')]){_0x5624a0['order'][_0x8194('0x56')](function(_0x494f0f){_0x369856['order']('c.'+_0x494f0f[0x0],_0x494f0f[0x1]==='DESC'?![]:!![]);});}if(!_['isEmpty'](_0x573003)){_0x369856[_0x8194('0x7a')](_0x1200c8);_0x42f541[_0x8194('0x66')](_0x8194('0x7b'),_0x573003);}BPromise[_0x8194('0x7c')]()['then'](function(){if(!_0x958766)return;if(_0x56c512[_0x8194('0x7d')][_0x8194('0x7e')]!==_0x8194('0x7f'))return;if(!_[_0x8194('0x80')](_0x958766[_0x8194('0x50')],[_0x8194('0x42'),_0x8194('0x59')])){return _0x56c512[_0x8194('0x7d')][_0x8194('0x81')]({'attributes':['id'],'raw':!![]})[_0x8194('0x29')](function(_0x4b4c70){if(_['isEmpty'](_0x4b4c70)){_0x42f541['where'](_0x8194('0x82'));_0x369856[_0x8194('0x66')]('c.ListId\x20IS\x20NULL');}else{_0x42f541[_0x8194('0x66')](_0x8194('0x83'),_['map'](_0x4b4c70,'id'));_0x369856['where'](_0x8194('0x83'),_[_0x8194('0x55')](_0x4b4c70,'id'));}});}})[_0x8194('0x29')](function(){if(_0x56c512[_0x8194('0x7d')][_0x8194('0x7e')]==='agent'&&!_0x958766&&!_0x56c512['query']['ListId'])return[];return db[_0x8194('0x84')][_0x8194('0x35')](_0x42f541[_0x8194('0x85')](),_0x545068);})['then'](function(_0x24b6f9){_0x56b5bc['count']=_0x24b6f9[_0x8194('0x3b')];if(_0x56b5bc[_0x8194('0x22')]===0x0)return[];return db[_0x8194('0x84')]['query'](_0x4aa53a[_0x8194('0x85')](),_0x545068)['then'](function(_0x5e0778){_0x2256d8=_['keyBy'](_0x5e0778,'id');_0x545068=_[_0x8194('0x86')](_0x545068,{'model':db[_0x8194('0x87')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x56c512[_0x8194('0x35')][_0x8194('0x3a')]){_0x5624a0['attributes'][_0x8194('0x56')](function(_0x5a3a29){_0x369856[_0x8194('0x42')]('c.'+_0x5a3a29);});}else{_0x369856[_0x8194('0x42')](_0x8194('0x77'));_0x369856['field']('c.firstName');_0x369856[_0x8194('0x42')](_0x8194('0x88'));_0x369856[_0x8194('0x42')](_0x8194('0x89'));_0x369856[_0x8194('0x42')](_0x8194('0x8a'));_0x369856[_0x8194('0x42')](_0x8194('0x8b'));_0x369856[_0x8194('0x42')](_0x8194('0x8c'));_0x369856[_0x8194('0x42')]('c.ListId');_0x369856['field']('c.createdAt');_0x369856[_0x8194('0x42')](_0x8194('0x8d'));_0x369856[_0x8194('0x42')]('c.CompanyId');_0x369856[_0x8194('0x42')](_0x8194('0x8e'),_0x8194('0x8f'));}if(_0x5624a0['limit'])_0x369856[_0x8194('0x3d')](_0x5624a0[_0x8194('0x3d')]);if(_0x5624a0[_0x8194('0x23')])_0x369856[_0x8194('0x23')](_0x5624a0[_0x8194('0x23')]);return db['sequelize'][_0x8194('0x35')](_0x369856[_0x8194('0x85')](),_0x545068);});})['then'](function(_0x3ee59e){_0x3ee59e['forEach'](function(_0x1a2062){if(_0x1a2062[_0x8194('0x8f')]){_0x1a2062[_0x8194('0x90')]=[];_0x1a2062[_0x8194('0x8f')][_0x8194('0x54')](',')[_0x8194('0x56')](function(_0x29aaa6){_0x1a2062[_0x8194('0x90')]['push'](_0x2256d8[_0x29aaa6]);});}delete _0x1a2062[_0x8194('0x8f')];});_0x56b5bc[_0x8194('0x91')]=_0x3ee59e;return _0x56b5bc;})['then'](respondWithFilteredResult(_0x4af9cc,_0x5624a0));})['catch'](handleError(_0x4af9cc,null));};exports[_0x8194('0x92')]=function(_0x1c92d8,_0x8b3c28){return db[_0x8194('0x87')][_0x8194('0x51')]({'where':{'id':_0x1c92d8['params']['id']}})[_0x8194('0x29')](handleEntityNotFound(_0x8b3c28,null))[_0x8194('0x29')](removeEntity(_0x8b3c28,null))['catch'](handleError(_0x8b3c28,null));};exports[_0x8194('0x2d')]=function(_0x5acb38,_0x345cd7){return db['CmContact'][_0x8194('0x2d')]()[_0x8194('0x29')](function(_0x286d9d){delete _0x286d9d['tags'];for(var _0x55a34d=0x0;_0x55a34d<Object[_0x8194('0x2e')](_0x286d9d)[_0x8194('0x3b')];_0x55a34d++){var _0xe5e303=Object[_0x8194('0x2e')](_0x286d9d)[_0x55a34d];if(!_[_0x8194('0x2f')](_0xe5e303,_0x8194('0x30'))){_0x286d9d[_0xe5e303][_0x8194('0x93')]=_0xe5e303;_0x286d9d[_0xe5e303][_0x8194('0x94')]=_0xe5e303;}}return _0x286d9d;})[_0x8194('0x29')](function(_0x2f5661){var _0x469dfa={'where':{'$or':[{'ListId':_0x5acb38[_0x8194('0x35')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x8194('0x95')][_0x8194('0x96')](_0x469dfa)[_0x8194('0x29')](function(_0x21b389){for(var _0x4dea3d=0x0;_0x4dea3d<_0x21b389[_0x8194('0x3b')];_0x4dea3d++){var _0x2bb3c0='cf_'+_0x21b389[_0x4dea3d]['id'];_0x2f5661[_0x2bb3c0][_0x8194('0x93')]=_0x2bb3c0;_0x2f5661[_0x2bb3c0][_0x8194('0x94')]=_0x21b389[_0x4dea3d][_0x8194('0x97')];_0x2f5661[_0x2bb3c0]['custom']={'type':_0x21b389[_0x4dea3d][_0x8194('0x34')],'values':_0x21b389[_0x4dea3d]['values']};}Object[_0x8194('0x2e')](_0x2f5661)[_0x8194('0x56')](function(_0x14e3bd){if(!_0x2f5661[_0x14e3bd]['hasOwnProperty']('columnName')){delete _0x2f5661[_0x14e3bd];}});return _0x2f5661;});})[_0x8194('0x29')](respondWithResult(_0x345cd7,null))['catch'](handleError(_0x345cd7,null));};exports[_0x8194('0x86')]=function(_0x9b910d,_0x4afaf4){var _0x56244b;var _0x4ea67f;var _0x529a7b;if(_0x9b910d[_0x8194('0x98')]['id']){delete _0x9b910d[_0x8194('0x98')]['id'];}return db[_0x8194('0x87')]['findAll']({'where':{'id':[_0x9b910d[_0x8194('0x98')]['to'],_0x9b910d[_0x8194('0x98')][_0x8194('0x43')]]}})[_0x8194('0x29')](function(_0x849234){if(_0x849234){if(_0x849234['length']!==0x2){return null;}_0x849234[0x0]=_0x849234[0x0][_0x8194('0x99')]({'plain':!![]});_0x849234[0x1]=_0x849234[0x1][_0x8194('0x99')]({'plain':!![]});delete _0x849234[0x0]['id'];delete _0x849234[0x1]['id'];return _[_0x8194('0x9a')](_0x849234[0x0],_0x849234[0x1],function(_0x17f5cf,_0x415d1e){if(Array[_0x8194('0x6a')](_0x415d1e)&&!_0x415d1e['length']){return _0x17f5cf;}else if(!_0x415d1e){return _0x17f5cf;}});}})['then'](handleEntityNotFound(_0x4afaf4,null))[_0x8194('0x29')](function(_0x2169c2){if(_0x2169c2){if(_0x2169c2['tags']&&_['isArray'](_0x2169c2[_0x8194('0x9b')])){_0x2169c2['tags']=_0x2169c2[_0x8194('0x9b')][_0x8194('0x9c')]();}logger[_0x8194('0x9d')](_0x8194('0x9e'),_0x9b910d['body']['to'],_0x9b910d['body'][_0x8194('0x43')]);return db[_0x8194('0x9f')]['destroy']({'where':{'ContactId':[_0x9b910d[_0x8194('0x98')]['to'],_0x9b910d[_0x8194('0x98')][_0x8194('0x43')]]}})['then'](function(_0x12a516){logger['info']('[CmContact][merge][destroy][CmHopper],\x20%s',_0x12a516);return db[_0x8194('0xa0')][_0x8194('0x92')]({'where':{'ContactId':[_0x9b910d[_0x8194('0x98')]['to'],_0x9b910d[_0x8194('0x98')]['from']]}})[_0x8194('0x29')](function(_0x240324){logger[_0x8194('0x9d')]('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x240324);return db[_0x8194('0x87')][_0x8194('0xa1')](_0x2169c2);});});}})[_0x8194('0x29')](function(_0x56bd44){if(_0x56bd44){_0x56244b=_0x56bd44;_0x4ea67f={'ContactId':_0x56244b['id']};_0x529a7b={'where':{'ContactId':[_0x9b910d[_0x8194('0x98')]['to'],_0x9b910d[_0x8194('0x98')]['from']]}};return db[_0x8194('0xa2')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xa3')]['update'](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xa4')]['update'](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xa5')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xa6')]['update'](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db['MailInteraction']['update'](_0x4ea67f,_0x529a7b);}})['then'](function(){if(_0x56244b){return db[_0x8194('0xa6')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xa7')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xa8')]['update'](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xa9')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})['then'](function(){if(_0x56244b){return db[_0x8194('0xaa')]['update'](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db['OpenchannelInteraction'][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})['then'](function(){if(_0x56244b){return db['OpenchannelMessage'][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xab')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db['CmHopperHistory'][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})['then'](function(){if(_0x56244b){return db[_0x8194('0xac')]['update'](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xad')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})['then'](function(){if(_0x56244b){return db['ChatQueueReport']['update'](_0x4ea67f,_0x529a7b);}})['then'](function(){if(_0x56244b){return db[_0x8194('0xae')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})['then'](function(){if(_0x56244b){return db[_0x8194('0xaf')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db['OpenchannelQueueReport'][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})['then'](function(){if(_0x56244b){return db[_0x8194('0xb0')]['update'](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xb1')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xb2')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0xb3')]['update'](_0x4ea67f,_0x529a7b);}})['then'](function(){if(_0x56244b){return db[_0x8194('0xb4')][_0x8194('0x28')](_0x4ea67f,_0x529a7b);}})[_0x8194('0x29')](function(){if(_0x56244b){return db[_0x8194('0x87')]['destroy']({'where':{'id':[_0x9b910d[_0x8194('0x98')]['to'],_0x9b910d[_0x8194('0x98')][_0x8194('0x43')]]}});}})['then'](function(){if(_0x56244b){return _0x56244b;}})[_0x8194('0x29')](respondWithResult(_0x4afaf4,null))[_0x8194('0xb5')](handleError(_0x4afaf4,null));};exports[_0x8194('0xa1')]=function(_0x4749e0,_0x5b38cc){return db[_0x8194('0x87')][_0x8194('0x2d')]()[_0x8194('0x29')](function(_0x2d3f75){if(_0x4749e0[_0x8194('0x98')]['tags']&&_[_0x8194('0x6a')](_0x4749e0['body']['tags'])){if(_0x4749e0[_0x8194('0x98')][_0x8194('0x9b')][_0x8194('0x3b')]){_0x4749e0[_0x8194('0x98')][_0x8194('0x9b')]=_0x4749e0[_0x8194('0x98')][_0x8194('0x9b')][_0x8194('0x9c')](';')+';';}else{_0x4749e0['body']['tags']=null;}}else{_0x4749e0['body'][_0x8194('0x9b')]=null;}return db[_0x8194('0x87')][_0x8194('0xa1')](_0x4749e0[_0x8194('0x98')],{'fields':_[_0x8194('0x2e')](_0x2d3f75),'raw':!![]});})['then'](respondWithResult(_0x5b38cc,0xc9))[_0x8194('0xb5')](handleError(_0x5b38cc,null));};exports[_0x8194('0xb6')]=function(_0x17f8b1,_0x29590e){var _0x5174a7=[];var _0x5d388c=0x0;var _0x53296a=0x0;var _0xef8b0e=0x0;return db[_0x8194('0x87')]['describe']()[_0x8194('0x29')](function(_0x32f7bb){return BPromise[_0x8194('0xb7')](_0x17f8b1[_0x8194('0x98')],function(_0x82e7e9){var _0x38bca1={'where':{'$or':[]},'defaults':_0x82e7e9,'fields':_[_0x8194('0x2e')](_0x32f7bb),'raw':!![]};if(_0x82e7e9['duplicates']){for(var _0x475486=0x0;_0x475486<_0x82e7e9[_0x8194('0xb8')][_0x8194('0x3b')];_0x475486++){var _0x27a583={};_0x27a583[_0x82e7e9[_0x8194('0xb8')][_0x475486]]=_0x82e7e9[_0x82e7e9[_0x8194('0xb8')][_0x475486]];_0x38bca1['where'][_0x8194('0xb9')]['push'](_0x27a583);}_0x38bca1['where'][_0x8194('0x65')]=_0x82e7e9[_0x8194('0x65')];}return db[_0x8194('0x87')][_0x8194('0xba')](_0x38bca1)['spread'](function(_0xabdad,_0xff0777){if(_0xff0777){_0x5d388c++;}else{_0xef8b0e++;}})[_0x8194('0xb5')](function(_0x2af28e){console[_0x8194('0xbb')](_0x2af28e);_0x53296a++;});});})['then'](function(_0x22a2ee){if(_0x22a2ee){return{'success':_0x5d388c,'failure':_0x53296a,'duplicates':_0xef8b0e};}})[_0x8194('0x29')](respondWithResult(_0x29590e,0xc9))[_0x8194('0xb5')](handleError(_0x29590e,null));};exports[_0x8194('0xbc')]=function(_0x40f76a,_0x5c8e96,_0x1b41fc){var _0x20edc7;return db[_0x8194('0x87')][_0x8194('0x2d')]()['then'](function(_0x131176){return db[_0x8194('0x87')][_0x8194('0x51')]({'where':{'id':_0x40f76a[_0x8194('0xbd')]['id']},'include':[{'model':db[_0x8194('0x52')],'as':'Tags','attributes':['id','name',_0x8194('0xbe')],'required':_0x40f76a['query'][_0x8194('0x69')]?!![]:![]}],'attributes':_['keys'](_0x131176)});})[_0x8194('0x29')](function(_0x298bfc){_0x20edc7=_0x298bfc[_0x8194('0x99')]({'plain':!![]});var _0x328b06={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x298bfc&&_0x298bfc[_0x8194('0x65')]){if(_0x298bfc[_0x8194('0x65')]){_0x328b06[_0x8194('0x66')][_0x8194('0xbf')]['push']({'ListId':{'$ne':_0x298bfc[_0x8194('0x65')]}});}}return db[_0x8194('0x95')][_0x8194('0x96')](_0x328b06);})[_0x8194('0x29')](function(_0x47c0a6){return _[_0x8194('0xc0')](_0x20edc7,_[_0x8194('0x55')](_0x47c0a6,function(_0x23f8cf){return util[_0x8194('0xc1')](_0x8194('0xc2'),_0x23f8cf['id']);}));})['then'](handleEntityNotFound(_0x5c8e96,null))[_0x8194('0x29')](respondWithResult(_0x5c8e96,null))[_0x8194('0xb5')](handleError(_0x5c8e96,null));};exports[_0x8194('0x28')]=function(_0x352bb4,_0x3af3f8){var _0x19ba7f;if(_0x352bb4[_0x8194('0x98')]['id']){delete _0x352bb4[_0x8194('0x98')]['id'];}return db[_0x8194('0x87')][_0x8194('0x51')]({'where':{'id':_0x352bb4[_0x8194('0xbd')]['id']}})['then'](handleEntityNotFound(_0x3af3f8,null))['then'](saveUpdates(_0x352bb4['body'],null))['then'](function(_0x40371a){_0x19ba7f=_0x40371a;var _0x4e2a1e={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x40371a&&_0x40371a[_0x8194('0x65')]){if(_0x40371a[_0x8194('0x65')]){_0x4e2a1e[_0x8194('0x66')][_0x8194('0xbf')][_0x8194('0x31')]({'ListId':{'$ne':_0x40371a[_0x8194('0x65')]}});}}return db[_0x8194('0x95')]['findAll'](_0x4e2a1e);})[_0x8194('0x29')](function(_0x5a0fd3){if(_0x5a0fd3){return _[_0x8194('0xc0')](_['pickBy'](_0x352bb4['body'],function(_0x5c6101,_0x26726c){return _[_0x8194('0x2f')](_0x26726c,_0x8194('0x30'));}),_[_0x8194('0x55')](_0x5a0fd3,function(_0x136498){return util[_0x8194('0xc1')](_0x8194('0xc2'),_0x136498['id']);}));}})['then'](function(_0x4e5b5d){if(_0x4e5b5d&&!_['isEmpty'](_0x4e5b5d)){var _0x3dc66d=squel['update']()['table'](_0x8194('0x45'))[_0x8194('0xc3')](_0x4e5b5d)[_0x8194('0x66')](_0x8194('0xc4'),_0x352bb4[_0x8194('0xbd')]['id'])[_0x8194('0xc5')]();return db[_0x8194('0x84')][_0x8194('0x35')](_0x3dc66d[_0x8194('0x5f')],{'replacements':_0x3dc66d[_0x8194('0xc6')]});}})[_0x8194('0x29')](function(){if(_0x352bb4[_0x8194('0x98')][_0x8194('0xc7')]&&_0x19ba7f){return db[_0x8194('0x9f')][_0x8194('0x28')]({'phone':_0x352bb4['body']['phone']},{'where':{'ContactId':_0x19ba7f['id']}});}})[_0x8194('0x29')](function(){return _0x19ba7f;})[_0x8194('0x29')](respondWithResult(_0x3af3f8,null))[_0x8194('0xb5')](handleError(_0x3af3f8,null));};exports[_0x8194('0xc8')]=function(_0x19bef0,_0x29d3ac,_0x1dc18d){var _0xa1457d={};var _0x58f083={};var _0x4d8f53;var _0x40aacd;return db[_0x8194('0x87')][_0x8194('0x32')]({'where':{'id':_0x19bef0[_0x8194('0xbd')]['id']}})[_0x8194('0x29')](handleEntityNotFound(_0x29d3ac,null))[_0x8194('0x29')](function(_0x5bfddb){if(_0x5bfddb){_0x4d8f53=_0x5bfddb;_0x58f083[_0x8194('0x39')]=_[_0x8194('0x2e')](db[_0x8194('0x52')][_0x8194('0xc9')]);_0x58f083[_0x8194('0x35')]=_[_0x8194('0x2e')](_0x19bef0[_0x8194('0x35')]);_0x58f083['filters']=_[_0x8194('0x37')](_0x58f083['model'],_0x58f083[_0x8194('0x35')]);_0xa1457d[_0x8194('0x38')]=_[_0x8194('0x37')](_0x58f083['model'],qs['fields'](_0x19bef0[_0x8194('0x35')][_0x8194('0x3a')]));_0xa1457d[_0x8194('0x38')]=_0xa1457d['attributes'][_0x8194('0x3b')]?_0xa1457d['attributes']:_0x58f083[_0x8194('0x39')];_0xa1457d[_0x8194('0x3e')]=qs[_0x8194('0x3f')](_0x19bef0[_0x8194('0x35')]['sort']);_0xa1457d[_0x8194('0x66')]=qs['filters'](_[_0x8194('0x40')](_0x19bef0['query'],_0x58f083[_0x8194('0x36')]));if(_0x19bef0[_0x8194('0x35')][_0x8194('0x61')]){_0xa1457d[_0x8194('0x66')]=_[_0x8194('0x86')](_0xa1457d[_0x8194('0x66')],{'$or':_['map'](_0xa1457d[_0x8194('0x38')],function(_0xf53e74){var _0x659183={};_0x659183[_0xf53e74]={'$like':'%'+_0x19bef0['query'][_0x8194('0x61')]+'%'};return _0x659183;})});}_0xa1457d=_[_0x8194('0x86')]({},_0xa1457d,_0x19bef0[_0x8194('0xca')]);return _0x4d8f53[_0x8194('0xc8')](_0xa1457d);}})[_0x8194('0x29')](function(_0x163d66){if(_0x163d66){_0x40aacd=_0x163d66[_0x8194('0x3b')];if(!_0x19bef0[_0x8194('0x35')][_0x8194('0x3c')](_0x8194('0xcb'))){_0xa1457d[_0x8194('0x3d')]=qs[_0x8194('0x3d')](_0x19bef0[_0x8194('0x35')][_0x8194('0x3d')]);_0xa1457d[_0x8194('0x23')]=qs['offset'](_0x19bef0['query']['offset']);}return _0x4d8f53[_0x8194('0xc8')](_0xa1457d);}})[_0x8194('0x29')](function(_0x13a5c3){if(_0x13a5c3){return _0x13a5c3?{'count':_0x40aacd,'rows':_0x13a5c3}:null;}})['then'](respondWithResult(_0x29d3ac,null))['catch'](handleError(_0x29d3ac,null));};exports[_0x8194('0xcc')]=function(_0x4852c1,_0x1dba1c,_0x47b273){if(_0x4852c1[_0x8194('0x98')]['id']){delete _0x4852c1['body']['id'];}return db[_0x8194('0x87')][_0x8194('0x32')]({'where':{'id':_0x4852c1[_0x8194('0xbd')]['id']}})[_0x8194('0x29')](handleEntityNotFound(_0x1dba1c,null))[_0x8194('0x29')](function(_0x2f77ea){if(_0x2f77ea){return _0x2f77ea[_0x8194('0xcc')](_0x4852c1[_0x8194('0x98')]['ids']||[]);}return null;})[_0x8194('0x29')](respondWithResult(_0x1dba1c,null))[_0x8194('0xb5')](handleError(_0x1dba1c,null));};exports[_0x8194('0xcd')]=function(_0xf317a0,_0x51825d,_0x35532a){var _0x48558e={'raw':![],'where':{}};var _0x1c4647={};var _0x109f4a={'count':0x0,'rows':[]};return db[_0x8194('0x87')][_0x8194('0x32')]({'where':{'id':_0xf317a0[_0x8194('0xbd')]['id']}})[_0x8194('0x29')](handleEntityNotFound(_0x51825d,null))['then'](function(_0x575612){if(_0x575612){_0x1c4647[_0x8194('0x39')]=_['keys'](db[_0x8194('0x9f')][_0x8194('0xc9')]);_0x1c4647[_0x8194('0x35')]=_[_0x8194('0x2e')](_0xf317a0[_0x8194('0x35')]);_0x1c4647[_0x8194('0x36')]=_[_0x8194('0x37')](_0x1c4647[_0x8194('0x39')],_0x1c4647[_0x8194('0x35')]);_0x48558e[_0x8194('0x38')]=_[_0x8194('0x37')](_0x1c4647['model'],qs['fields'](_0xf317a0[_0x8194('0x35')][_0x8194('0x3a')]));_0x48558e['attributes']=_0x48558e[_0x8194('0x38')][_0x8194('0x3b')]?_0x48558e['attributes']:_0x1c4647[_0x8194('0x39')];if(!_0xf317a0[_0x8194('0x35')]['hasOwnProperty'](_0x8194('0xcb'))){_0x48558e[_0x8194('0x3d')]=qs[_0x8194('0x3d')](_0xf317a0[_0x8194('0x35')][_0x8194('0x3d')]);_0x48558e[_0x8194('0x23')]=qs[_0x8194('0x23')](_0xf317a0[_0x8194('0x35')][_0x8194('0x23')]);}_0x48558e[_0x8194('0x3e')]=qs['sort'](_0xf317a0['query'][_0x8194('0x3f')]);_0x48558e['where']=qs[_0x8194('0x36')](_[_0x8194('0x40')](_0xf317a0[_0x8194('0x35')],_0x1c4647[_0x8194('0x36')]));_0x48558e[_0x8194('0x66')][_0x8194('0xce')]=_0x575612['id'];if(_0xf317a0[_0x8194('0x35')]['filter']){_0x48558e['where']=_[_0x8194('0x86')](_0x48558e['where'],{'$or':_['map'](_0x48558e['attributes'],function(_0x265629){var _0x4881f5={};_0x4881f5[_0x265629]={'$like':'%'+_0xf317a0[_0x8194('0x35')][_0x8194('0x61')]+'%'};return _0x4881f5;})});}_0x48558e=_[_0x8194('0x86')]({},_0x48558e,_0xf317a0['options']);return db[_0x8194('0x9f')][_0x8194('0x22')]({'where':_0x48558e[_0x8194('0x66')]})['then'](function(_0xa1a2d5){_0x109f4a['count']=_0xa1a2d5;if(_0xf317a0[_0x8194('0x35')]['includeAll']){_0x48558e['include']=[{'all':!![]}];}return db['CmHopper']['findAll'](_0x48558e);})[_0x8194('0x29')](function(_0x1c8473){_0x109f4a[_0x8194('0x91')]=_0x1c8473;return _0x109f4a;});}})[_0x8194('0x29')](respondWithFilteredResult(_0x51825d,_0x48558e))[_0x8194('0xb5')](handleError(_0x51825d,null));};exports[_0x8194('0xcf')]=function(_0x9c7419,_0x818812,_0x554c28){var _0x43f2ff={'raw':!![],'where':{}};var _0x47f38e={};var _0x227854={'count':0x0,'rows':[]};return db['CmContact'][_0x8194('0x32')]({'where':{'id':_0x9c7419[_0x8194('0xbd')]['id']}})[_0x8194('0x29')](handleEntityNotFound(_0x818812,null))[_0x8194('0x29')](function(_0x130d94){if(_0x130d94){_0x47f38e[_0x8194('0x39')]=_[_0x8194('0x2e')](db[_0x8194('0xd0')][_0x8194('0xc9')]);_0x47f38e[_0x8194('0x35')]=_['keys'](_0x9c7419[_0x8194('0x35')]);_0x47f38e[_0x8194('0x36')]=_['intersection'](_0x47f38e[_0x8194('0x39')],_0x47f38e[_0x8194('0x35')]);_0x43f2ff['attributes']=_[_0x8194('0x37')](_0x47f38e['model'],qs[_0x8194('0x3a')](_0x9c7419[_0x8194('0x35')][_0x8194('0x3a')]));_0x43f2ff[_0x8194('0x38')]=_0x43f2ff[_0x8194('0x38')][_0x8194('0x3b')]?_0x43f2ff['attributes']:_0x47f38e[_0x8194('0x39')];if(!_0x9c7419[_0x8194('0x35')]['hasOwnProperty']('nolimit')){_0x43f2ff[_0x8194('0x3d')]=qs[_0x8194('0x3d')](_0x9c7419[_0x8194('0x35')]['limit']);_0x43f2ff['offset']=qs[_0x8194('0x23')](_0x9c7419[_0x8194('0x35')][_0x8194('0x23')]);}_0x43f2ff['order']=qs[_0x8194('0x3f')](_0x9c7419[_0x8194('0x35')][_0x8194('0x3f')]);_0x43f2ff[_0x8194('0x66')]=qs[_0x8194('0x36')](_['pick'](_0x9c7419[_0x8194('0x35')],_0x47f38e['filters']));_0x43f2ff['where']['ContactId']=_0x130d94['id'];if(_0x9c7419['query'][_0x8194('0x61')]){_0x43f2ff[_0x8194('0x66')]=_[_0x8194('0x86')](_0x43f2ff[_0x8194('0x66')],{'$or':_[_0x8194('0x55')](_0x43f2ff[_0x8194('0x38')],function(_0xff419b){var _0x3d4b3f={};_0x3d4b3f[_0xff419b]={'$like':'%'+_0x9c7419[_0x8194('0x35')][_0x8194('0x61')]+'%'};return _0x3d4b3f;})});}_0x43f2ff=_['merge']({},_0x43f2ff,_0x9c7419[_0x8194('0xca')]);return db[_0x8194('0xd0')][_0x8194('0x22')]({'where':_0x43f2ff[_0x8194('0x66')]})['then'](function(_0x274e85){_0x227854[_0x8194('0x22')]=_0x274e85;if(_0x9c7419['query'][_0x8194('0xd1')]){_0x43f2ff[_0x8194('0xd2')]=[{'all':!![]}];}return db['CmHopperHistory'][_0x8194('0x96')](_0x43f2ff);})['then'](function(_0x2d595a){_0x227854['rows']=_0x2d595a;return _0x227854;});}})[_0x8194('0x29')](respondWithFilteredResult(_0x818812,_0x43f2ff))[_0x8194('0xb5')](handleError(_0x818812,null));};exports[_0x8194('0xd3')]=function(_0xa9c437,_0x30bd35,_0x496530){var _0xd283f4={'raw':!![],'where':{}};var _0x21d63c={};var _0x5cac6d={'count':0x0,'rows':[]};return db[_0x8194('0x87')][_0x8194('0x32')]({'where':{'id':_0xa9c437['params']['id']}})[_0x8194('0x29')](handleEntityNotFound(_0x30bd35,null))[_0x8194('0x29')](function(_0x500029){if(_0x500029){_0x21d63c['model']=_[_0x8194('0x2e')](db[_0x8194('0xab')][_0x8194('0xc9')]);_0x21d63c[_0x8194('0x35')]=_['keys'](_0xa9c437[_0x8194('0x35')]);_0x21d63c[_0x8194('0x36')]=_[_0x8194('0x37')](_0x21d63c[_0x8194('0x39')],_0x21d63c[_0x8194('0x35')]);_0xd283f4[_0x8194('0x38')]=_[_0x8194('0x37')](_0x21d63c[_0x8194('0x39')],qs['fields'](_0xa9c437[_0x8194('0x35')][_0x8194('0x3a')]));_0xd283f4[_0x8194('0x38')]=_0xd283f4['attributes']['length']?_0xd283f4[_0x8194('0x38')]:_0x21d63c[_0x8194('0x39')];if(!_0xa9c437[_0x8194('0x35')][_0x8194('0x3c')]('nolimit')){_0xd283f4[_0x8194('0x3d')]=qs[_0x8194('0x3d')](_0xa9c437[_0x8194('0x35')][_0x8194('0x3d')]);_0xd283f4[_0x8194('0x23')]=qs[_0x8194('0x23')](_0xa9c437[_0x8194('0x35')][_0x8194('0x23')]);}_0xd283f4[_0x8194('0x3e')]=qs[_0x8194('0x3f')](_0xa9c437[_0x8194('0x35')][_0x8194('0x3f')]);_0xd283f4[_0x8194('0x66')]=qs[_0x8194('0x36')](_[_0x8194('0x40')](_0xa9c437['query'],_0x21d63c[_0x8194('0x36')]));_0xd283f4['where'][_0x8194('0xce')]=_0x500029['id'];if(_0xa9c437[_0x8194('0x35')][_0x8194('0x61')]){_0xd283f4['where']=_[_0x8194('0x86')](_0xd283f4[_0x8194('0x66')],{'$or':_[_0x8194('0x55')](_0xd283f4['attributes'],function(_0x5e46b9){var _0x426fc9={};_0x426fc9[_0x5e46b9]={'$like':'%'+_0xa9c437[_0x8194('0x35')][_0x8194('0x61')]+'%'};return _0x426fc9;})});}_0xd283f4=_['merge']({},_0xd283f4,_0xa9c437[_0x8194('0xca')]);return db[_0x8194('0xab')][_0x8194('0x22')]({'where':_0xd283f4['where']})['then'](function(_0x390a32){_0x5cac6d[_0x8194('0x22')]=_0x390a32;if(_0xa9c437['query'][_0x8194('0xd1')]){_0xd283f4[_0x8194('0xd2')]=[{'all':!![]}];}return db['CmHopperFinal'][_0x8194('0x96')](_0xd283f4);})[_0x8194('0x29')](function(_0x2042f3){_0x5cac6d[_0x8194('0x91')]=_0x2042f3;return _0x5cac6d;});}})[_0x8194('0x29')](respondWithFilteredResult(_0x30bd35,_0xd283f4))[_0x8194('0xb5')](handleError(_0x30bd35,null));};exports[_0x8194('0xd4')]=function(_0xc048ad,_0x525358,_0x416c77){var _0x2270af={'raw':!![],'where':{}};var _0x9637ea={};var _0x3e7311={'count':0x0,'rows':[]};return db[_0x8194('0x87')]['findOne']({'where':{'id':_0xc048ad[_0x8194('0xbd')]['id']}})[_0x8194('0x29')](handleEntityNotFound(_0x525358,null))[_0x8194('0x29')](function(_0x38109e){if(_0x38109e){_0x9637ea[_0x8194('0x39')]=_['keys'](db[_0x8194('0xb1')][_0x8194('0xc9')]);_0x9637ea[_0x8194('0x35')]=_['keys'](_0xc048ad[_0x8194('0x35')]);_0x9637ea[_0x8194('0x36')]=_[_0x8194('0x37')](_0x9637ea[_0x8194('0x39')],_0x9637ea[_0x8194('0x35')]);_0x2270af[_0x8194('0x38')]=_[_0x8194('0x37')](_0x9637ea['model'],qs['fields'](_0xc048ad['query']['fields']));_0x2270af['attributes']=_0x2270af[_0x8194('0x38')][_0x8194('0x3b')]?_0x2270af[_0x8194('0x38')]:_0x9637ea[_0x8194('0x39')];if(!_0xc048ad[_0x8194('0x35')][_0x8194('0x3c')]('nolimit')){_0x2270af[_0x8194('0x3d')]=qs[_0x8194('0x3d')](_0xc048ad[_0x8194('0x35')]['limit']);_0x2270af[_0x8194('0x23')]=qs[_0x8194('0x23')](_0xc048ad[_0x8194('0x35')][_0x8194('0x23')]);}_0x2270af[_0x8194('0x3e')]=qs[_0x8194('0x3f')](_0xc048ad[_0x8194('0x35')]['sort']);_0x2270af[_0x8194('0x66')]=qs[_0x8194('0x36')](_['pick'](_0xc048ad[_0x8194('0x35')],_0x9637ea[_0x8194('0x36')]));_0x2270af['where'][_0x8194('0xce')]=_0x38109e['id'];if(_0xc048ad[_0x8194('0x35')][_0x8194('0x61')]){_0x2270af[_0x8194('0x66')]=_['merge'](_0x2270af[_0x8194('0x66')],{'$or':_[_0x8194('0x55')](_0x2270af[_0x8194('0x38')],function(_0x5218be){var _0x6a0670={};_0x6a0670[_0x5218be]={'$like':'%'+_0xc048ad['query']['filter']+'%'};return _0x6a0670;})});}_0x2270af=_['merge']({},_0x2270af,_0xc048ad[_0x8194('0xca')]);return db[_0x8194('0xb1')][_0x8194('0x22')]({'where':_0x2270af[_0x8194('0x66')]})['then'](function(_0x2715b1){_0x3e7311[_0x8194('0x22')]=_0x2715b1;if(_0xc048ad[_0x8194('0x35')][_0x8194('0xd1')]){_0x2270af[_0x8194('0xd2')]=[{'all':!![]}];}return db[_0x8194('0xb1')]['findAll'](_0x2270af);})[_0x8194('0x29')](function(_0x40e596){_0x3e7311[_0x8194('0x91')]=_0x40e596;return _0x3e7311;});}})[_0x8194('0x29')](respondWithFilteredResult(_0x525358,_0x2270af))['catch'](handleError(_0x525358,null));};exports[_0x8194('0xd5')]=function(_0x3f8cd8,_0x192c75,_0x1d0141){try{if(!_0x3f8cd8[_0x8194('0x98')]['ListId']){throw new Error(_0x8194('0xd6'));}if(!_0x3f8cd8[_0x8194('0x98')][_0x8194('0xd7')]){throw new Error(_0x8194('0xd8'));}if(!_0x3f8cd8[_0x8194('0x98')][_0x8194('0xd9')]){throw new Error(_0x8194('0xda'));}if(!_0x3f8cd8['body']['socket_timestamp']){throw new Error(_0x8194('0xdb'));}var _0x418ad5=_0x3f8cd8[_0x8194('0x98')][_0x8194('0xd7')]['split'](',');var _0x508350=_0x3f8cd8[_0x8194('0x98')][_0x8194('0xd9')]['split'](',');if(!_0x418ad5[_0x8194('0x3b')]||!_0x508350['length']||_0x418ad5[_0x8194('0x3b')]!==_0x508350[_0x8194('0x3b')]){throw new Error(_0x8194('0xdc'));}_0x3f8cd8['body'][_0x8194('0x3a')]=_[_0x8194('0xdd')](_0x418ad5,_0x508350);if(!_0x3f8cd8[_0x8194('0x98')][_0x8194('0x3a')]['phone']){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x3f8cd8[_0x8194('0x98')][_0x8194('0x3a')][_0x8194('0xde')]){throw new Error(_0x8194('0xdf'));}var _0x279f67=path[_0x8194('0x9c')](config[_0x8194('0xe0')],_0x8194('0xe1'),_0x3f8cd8[_0x8194('0xe2')][_0x8194('0xe3')]);fs['chmodSync'](_0x279f67,parseInt(_0x8194('0xe4'),0x8));var _0x5e15cf=require('child_process')[_0x8194('0xe5')](path[_0x8194('0x9c')](__dirname,_0x8194('0xe6')),[_0x279f67,_0x3f8cd8[_0x8194('0x98')][_0x8194('0xd7')],_0x3f8cd8[_0x8194('0x98')]['binding_values'],_0x3f8cd8[_0x8194('0x98')][_0x8194('0x65')],_0x3f8cd8[_0x8194('0x98')][_0x8194('0xe7')],_0x3f8cd8['body'][_0x8194('0xb8')],_0x3f8cd8[_0x8194('0x98')][_0x8194('0xe8')]]);return _0x192c75['status'](0xc8)[_0x8194('0x25')]({'message':_0x8194('0xe9'),'pid':_0x5e15cf[_0x8194('0xea')]});}catch(_0x33eca2){return _0x192c75[_0x8194('0x20')](0x1f4)[_0x8194('0x2b')](_0x33eca2);}};exports[_0x8194('0xeb')]=function(_0x24925a,_0x10192c,_0xd59e4a){var _0x2d8b56=fs[_0x8194('0xec')](_0x24925a['file'][_0x8194('0x9')]);Papa['parse'](_0x2d8b56,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x1e0c77){return _0x10192c['status'](0xc8)[_0x8194('0x25')]({'file':_0x24925a[_0x8194('0xe2')],'fields':_0x1e0c77[_0x8194('0xed')][_0x8194('0x3a')]});}});};exports[_0x8194('0xee')]=function(_0x59212f,_0x43e9e,_0x47bb92){return db['User'][_0x8194('0x96')]({'raw':!![],'attributes':['id'],'where':{'role':_0x8194('0x7f')}})[_0x8194('0x29')](function(_0x41700c){var _0x4138f3=![];if(!_0x59212f[_0x8194('0x98')]['ListId']){throw new Error(_0x8194('0xd6'));}if(!_0x59212f[_0x8194('0x98')][_0x8194('0xef')][_0x8194('0xc7')]){throw new Error(_0x8194('0xf0'));}if(!_0x59212f[_0x8194('0x98')][_0x8194('0xef')][_0x8194('0xde')]){throw new Error(_0x8194('0xdf'));}if(!_0x59212f[_0x8194('0x98')][_0x8194('0xe8')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x47b2ef=require(_0x8194('0xf1'))['fork'](path['join'](__dirname,_0x8194('0xf2')),[_0x59212f[_0x8194('0xbd')]['id'],JSON[_0x8194('0xf3')](_0x59212f['body']),JSON[_0x8194('0xf3')](_0x41700c)]);_0x47b2ef['on'](_0x8194('0xf4'),function(_0x13fc69){_0x4138f3=!![];return _0x43e9e['status'](0xc8)['json']({'message':_0x8194('0xf5'),'pid':_0x47b2ef[_0x8194('0xea')]});});_0x47b2ef['on'](_0x8194('0xf6'),function(_0x3bb151){if(_0x3bb151&&!_0x4138f3){return _0x43e9e[_0x8194('0x20')](0x1f4)[_0x8194('0x25')]({'message':'error\x20child\x20process','pid':_0x47b2ef[_0x8194('0xea')]});}});})[_0x8194('0xb5')](handleError(_0x43e9e,null));};exports[_0x8194('0xf7')]=function(_0x1de77a,_0x2e4819){var _0x1e1027=[_0x8194('0xf8'),_0x8194('0xf9'),'sms','openchannel',_0x8194('0xfa'),_0x8194('0xfb'),'voice'];var _0x4e627a={'offset':0x0,'order':qs['sort'](_0x8194('0xfc'))},_0x13b4e1={'count':0x0,'rows':[]};Promise[_0x8194('0x7c')]()['then'](function(){if(_0x1de77a[_0x8194('0x35')][_0x8194('0xfd')]){if(!_[_0x8194('0xfe')](_0x1e1027,_0x1de77a[_0x8194('0x35')][_0x8194('0xfd')][_0x8194('0xff')]())){throw new Error(_0x8194('0x100'));}_0x1e1027=[_0x1de77a['query'][_0x8194('0xfd')][_0x8194('0xff')]()];}if(_0x1de77a[_0x8194('0x35')][_0x8194('0x101')]){try{var _0xc62327=JSON[_0x8194('0x102')](_0x1de77a[_0x8194('0x35')]['range']);if(!moment(_0xc62327[_0x8194('0x43')])[_0x8194('0x103')]()){throw new Error(_0x8194('0x104'));}if(!moment(_0xc62327['to'])['isValid']()){throw new Error('Invalid\x20date\x20for\x20range\x20to\x20filter');}}catch(_0x4b20e8){throw new Error(_0x8194('0x105'));}}if(!_0x1de77a['query']['hasOwnProperty']('nolimit')){_0x4e627a[_0x8194('0x3d')]=qs[_0x8194('0x3d')](_0x1de77a[_0x8194('0x35')][_0x8194('0x3d')]||0xa);_0x4e627a[_0x8194('0x23')]=qs['offset'](_0x1de77a[_0x8194('0x35')][_0x8194('0x23')]);}var _0x21b3ac=_0x1e1027['map'](function(_0x73c02b){if(_0x73c02b==='voice'){var _0x3c7faa={'attributes':['id',_0x8194('0x106'),'type','source',_0x8194('0x107'),'callerid','starttime',_0x8194('0x108'),_0x8194('0x109'),_0x8194('0x10a'),_0x8194('0x10b'),_0x8194('0x10c'),_0x8194('0x10d'),'userThirdDisposition'],'where':{'ContactId':_0x1de77a[_0x8194('0xbd')]['id']},'include':[{'model':db['User'],'as':_0x8194('0x59'),'attributes':['id','name','fullname','alias']}],'order':[[_0x8194('0x10b'),_0x8194('0x10e')]]};if(_0x1de77a[_0x8194('0x35')][_0x8194('0x101')]){_0x3c7faa[_0x8194('0x66')]['createdAt']={'$gte':_0xc62327[_0x8194('0x43')],'$lte':_0xc62327['to']};}return db[_0x8194('0xad')][_0x8194('0x10f')](_0x3c7faa)[_0x8194('0x29')](function(_0x41e3f2){_0x13b4e1[_0x8194('0x22')]+=_0x41e3f2['count'];return _[_0x8194('0x55')](_0x41e3f2[_0x8194('0x91')],function(_0x3033a3){var _0x4873fe=_0x3033a3[_0x8194('0x99')]({'plain':!![]});_0x4873fe[_0x8194('0xfd')]=_0x73c02b;if(_0x4873fe[_0x8194('0x59')]){_0x4873fe[_0x8194('0x59')]={'id':_0x4873fe[_0x8194('0x59')]['id'],'name':_0x4873fe[_0x8194('0x59')][_0x8194('0x2a')],'fullname':_0x4873fe['User'][_0x8194('0x110')],'alias':_0x4873fe['User'][_0x8194('0x97')]};}return _0x4873fe;});});}else{var _0x4280fe=_[_0x8194('0x111')](_0x73c02b)+(_0x73c02b===_0x8194('0xf9')?_0x8194('0x112'):_0x8194('0x113'));var _0x323a22={'attributes':['id',_0x8194('0x114'),_0x8194('0x115'),'createdAt',_0x8194('0x10a'),'disposition',_0x8194('0x116'),_0x8194('0x117'),_0x8194('0x118'),_0x4280fe+'Id'],'where':{'ContactId':_0x1de77a[_0x8194('0xbd')]['id']},'include':[{'model':db[_0x4280fe],'as':_0x8194('0x113'),'attributes':['id','name','key']},{'model':db[_0x8194('0x59')],'as':_0x8194('0x119'),'attributes':['id','name',_0x8194('0x110')]},{'model':db['Tag'],'as':_0x8194('0x90'),'attributes':['id',_0x8194('0x2a'),_0x8194('0xbe')],'through':{'attributes':[]}}],'order':[[_0x8194('0x10b'),_0x8194('0x10e')]]};if(_0x1de77a['query'][_0x8194('0x101')]){_0x323a22[_0x8194('0x66')][_0x8194('0x10b')]={'$gte':_0xc62327[_0x8194('0x43')],'$lte':_0xc62327['to']};}switch(_0x73c02b){case _0x8194('0xf9'):_0x323a22[_0x8194('0x38')][_0x8194('0x31')](_0x8194('0x11a'),'customerIp',_0x8194('0x11b'),_0x8194('0x11c'),_0x8194('0x11d'),_0x8194('0x11e'),_0x8194('0x11f'),_0x8194('0x120'),_0x8194('0x121'));break;case _0x8194('0xf8'):_0x323a22[_0x8194('0x38')][_0x8194('0x31')]('subject',_0x8194('0x122'));break;case'openchannel':_0x323a22[_0x8194('0x38')]['push']('externalUrl',_0x8194('0x123'));break;}return db[_[_0x8194('0x111')](_0x73c02b)+_0x8194('0x124')]['findAndCountAll'](_0x323a22)[_0x8194('0x29')](function(_0x1a23fd){_0x13b4e1['count']+=_0x1a23fd[_0x8194('0x22')];return _[_0x8194('0x55')](_0x1a23fd[_0x8194('0x91')],function(_0x5743ee){var _0x36c7a9=_0x5743ee['get']({'plain':!![]});_0x36c7a9[_0x8194('0xfd')]=_0x73c02b;if(_0x36c7a9[_0x8194('0x119')]){_0x36c7a9[_0x8194('0x119')]={'id':_0x36c7a9[_0x8194('0x119')]['id'],'name':_0x36c7a9[_0x8194('0x119')][_0x8194('0x2a')],'fullname':_0x36c7a9[_0x8194('0x119')][_0x8194('0x110')]};}return _0x36c7a9;});});}});return Promise[_0x8194('0x125')](_0x21b3ac);})['then'](function(_0x1dbfb8){return _(_0x1dbfb8)[_0x8194('0x126')]()[_0x8194('0x127')](_0x8194('0x10b'))[_0x8194('0x128')]()[_0x8194('0x53')]();})['then'](function(_0x37a0b1){_0x13b4e1['rows']=_0x4e627a['limit']?_0x37a0b1['slice'](_0x4e627a[_0x8194('0x23')],_0x4e627a[_0x8194('0x23')]+_0x4e627a[_0x8194('0x3d')]):_0x37a0b1;return _0x13b4e1;})[_0x8194('0x29')](respondWithFilteredResult(_0x2e4819,_0x4e627a))[_0x8194('0xb5')](handleError(_0x2e4819,null));};
\ No newline at end of file
+var _0xb248=['Contact','isEmpty','ListId','c.ListId\x20IN\x20?','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','tag','replace','getFullTextValue','isNumeric','c.id\x20LIKE\x20?','c.mobile\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','group','c.id','Sequelize','QueryTypes','clone','DESC','having','t.id\x20IN\x20?','resolve','user','role','some','User','c.ListId\x20IS\x20NULL','agent','sequelize','toString','merge','c.firstName','c.lastName','c.phone','c.ListId','c.createdAt','c.deletedAt','c.CompanyId','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','Tags','find','params','tags','columnName','displayName','findAll','values','catch','body','get','mergeWith','isArray','join','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','info','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','ChatOfflineMessage','MailMessage','MailInteraction','SmsInteraction','SmsMessage','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','ReportAgentPreview','VoiceCallReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','WhatsappMessage','WhatsappQueueReport','bulkCreate','each','duplicates','$or','show','Tag','color','$and','omit','format','cf_%d','table','setFields','id\x20=\x20?','toParam','phone','getTags','rawAttributes','setTags','ids','getHoppers','nolimit','ContactId','options','includeAll','rows','CmHopperHistory','include','getHopperFinals','getJscriptySessions','JscriptySessionReport','uploadCsv','No\x20ListId\x20specified','binding_values','socket_timestamp','binding_keys','zipObject','firstName','root','server/files/tmp','file','filename','chmodSync','0777','child_process','fork','../../components/import/cm/csv','File\x20uploaded\x20correctly!','pid','upload','createReadStream','parse','meta','import','binding','No\x20phone\x20column\x20specified','No\x20firstName\x20column\x20specified','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','exit','getJourney','chat','fax','voice','-createdAt','includes','channel','toLowerCase','isValid','Invalid\x20createdAt\x20filter','uniqueid','source','destination','callerid','starttime','endtime','duration','createdAt','userDisposition','userSecondDisposition','userThirdDisposition','fullname','alias','range','Account','closed','note','disposition','secondDisposition','thirdDisposition','UserId','key','Owner','browserName','customerIp','customerPort','deviceModel','osName','ratingMessage','ratingType','referer','mail','substatus','openchannel','externalUrl','threadId','startCase','Interaction','flatten','sortBy','reverse','slice','html-pdf','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','path','sox','ejs','lodash','crypto','desk.js','to-csv','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','./cmContact.socket','register','sendStatus','status','count','offset','limit','set','Content-Range','json','apply','save','update','then','destroy','end','error','stack','name','send','index','CmContact','describe','keys','startsWith','cf_','push','CmCustomField','findOne','trimStart','all','length','fieldType','type','model','query','filters','intersection','attributes','fields','hasOwnProperty','order','sort','where','pick','select','field','from','cm_contacts','left_join','cm_user_has_contacts','uc.CmContactId\x20=\x20c.id','tools_tags','t.id\x20=\x20ct.TagId','expr','search','sqlOperator','conditions','value','split','map','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','uc.UserId\x20=\x20?','dateOfBirth','datetime','DATE','buildExpression','text','start','filter'];(function(_0x2d8c1c,_0x41ae7f){var _0x58399b=function(_0x1ea0f1){while(--_0x1ea0f1){_0x2d8c1c['push'](_0x2d8c1c['shift']());}};_0x58399b(++_0x41ae7f);}(_0xb248,0xc6));var _0x8b24=function(_0x279d37,_0x14de3f){_0x279d37=_0x279d37-0x0;var _0x530173=_0xb248[_0x279d37];return _0x530173;};'use strict';var pdf=require(_0x8b24('0x0'));var emlformat=require('eml-format');var rimraf=require(_0x8b24('0x1'));var zipdir=require(_0x8b24('0x2'));var jsonpatch=require(_0x8b24('0x3'));var rp=require(_0x8b24('0x4'));var moment=require('moment');var BPromise=require(_0x8b24('0x5'));var Mustache=require(_0x8b24('0x6'));var util=require('util');var path=require(_0x8b24('0x7'));var sox=require(_0x8b24('0x8'));var csv=require('to-csv');var ejs=require(_0x8b24('0x9'));var fs=require('fs');var _=require(_0x8b24('0xa'));var squel=require('squel');var crypto=require(_0x8b24('0xb'));var jsforce=require('jsforce');var deskjs=require(_0x8b24('0xc'));var toCsv=require(_0x8b24('0xd'));var querystring=require(_0x8b24('0xe'));var Papa=require('papaparse');var Redis=require(_0x8b24('0xf'));var authService=require(_0x8b24('0x10'));var qs=require(_0x8b24('0x11'));var as=require(_0x8b24('0x12'));var hardwareService=require(_0x8b24('0x13'));var logger=require(_0x8b24('0x14'))(_0x8b24('0x15'));var utils=require(_0x8b24('0x16'));var config=require(_0x8b24('0x17'));var licenseUtil=require(_0x8b24('0x18'));var db=require(_0x8b24('0x19'))['db'];config[_0x8b24('0x1a')]=_[_0x8b24('0x1b')](config[_0x8b24('0x1a')],{'host':'localhost','port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x8b24('0x1a')]));require(_0x8b24('0x1c'))[_0x8b24('0x1d')](socket);function respondWithStatusCode(_0x32a451,_0x22a11e){_0x22a11e=_0x22a11e||0xcc;return function(_0x2ccaf2){if(_0x2ccaf2){return _0x32a451[_0x8b24('0x1e')](_0x22a11e);}return _0x32a451[_0x8b24('0x1f')](_0x22a11e)['end']();};}function respondWithResult(_0x5a5745,_0x552a28){_0x552a28=_0x552a28||0xc8;return function(_0xfe489b){if(_0xfe489b){return _0x5a5745['status'](_0x552a28)['json'](_0xfe489b);}};}function respondWithFilteredResult(_0xafc423,_0x1d7722){return function(_0x527af7){if(_0x527af7){var _0x1bafdf=_0x527af7[_0x8b24('0x20')],_0x5e3c52=_0x1d7722['offset'],_0x3b4805=_0x1d7722[_0x8b24('0x21')]+_0x1d7722[_0x8b24('0x22')],_0x56d424;if(_0x3b4805>=_0x1bafdf){_0x3b4805=_0x1bafdf;_0x56d424=0xc8;}else{_0x56d424=0xce;}_0xafc423[_0x8b24('0x1f')](_0x56d424);return _0xafc423[_0x8b24('0x23')](_0x8b24('0x24'),_0x5e3c52+'-'+_0x3b4805+'/'+_0x1bafdf)[_0x8b24('0x25')](_0x527af7);}return null;};}function patchUpdates(_0x2f62b3){return function(_0x5c9c38){try{jsonpatch[_0x8b24('0x26')](_0x5c9c38,_0x2f62b3,!![]);}catch(_0x237d62){return BPromise['reject'](_0x237d62);}return _0x5c9c38[_0x8b24('0x27')]();};}function saveUpdates(_0x13dd68,_0x2225a6){return function(_0x3379df){if(_0x3379df){return _0x3379df[_0x8b24('0x28')](_0x13dd68)[_0x8b24('0x29')](function(_0x347591){return _0x347591;});}return null;};}function removeEntity(_0x3fddf8,_0x2e8c46){return function(_0xc1dc78){if(_0xc1dc78){return _0xc1dc78[_0x8b24('0x2a')]()[_0x8b24('0x29')](function(){_0x3fddf8[_0x8b24('0x1f')](0xcc)[_0x8b24('0x2b')]();});}};}function handleEntityNotFound(_0x19600a,_0x35d496){return function(_0x1fe79f){if(!_0x1fe79f){_0x19600a[_0x8b24('0x1e')](0x194);}return _0x1fe79f;};}function handleError(_0x44ee85,_0x279837){_0x279837=_0x279837||0x1f4;return function(_0x1adcb4){logger[_0x8b24('0x2c')](_0x1adcb4[_0x8b24('0x2d')]);if(_0x1adcb4[_0x8b24('0x2e')]){delete _0x1adcb4[_0x8b24('0x2e')];}_0x44ee85[_0x8b24('0x1f')](_0x279837)[_0x8b24('0x2f')](_0x1adcb4);};}exports[_0x8b24('0x30')]=function(_0x5d3958,_0x36ff89){var _0x59d6e1={},_0xadbba0={},_0x14316c={'count':0x0,'rows':[]};return db[_0x8b24('0x31')][_0x8b24('0x32')]()[_0x8b24('0x29')](function(_0x4de1cf){var _0xa37fe3=[];for(var _0x28d351=0x0;_0x28d351<Object[_0x8b24('0x33')](_0x4de1cf)['length'];_0x28d351++){var _0x496851=Object['keys'](_0x4de1cf)[_0x28d351];if(_[_0x8b24('0x34')](_0x496851,_0x8b24('0x35'))){_0xa37fe3[_0x8b24('0x36')](db[_0x8b24('0x37')][_0x8b24('0x38')]({'where':{'id':_[_0x8b24('0x39')](_0x496851,_0x8b24('0x35'))},'raw':!![]}));}}return BPromise[_0x8b24('0x3a')](_0xa37fe3)[_0x8b24('0x29')](function(_0x4d0f55){for(var _0x4bfaa0=0x0;_0x4bfaa0<_0x4d0f55[_0x8b24('0x3b')];_0x4bfaa0++){if(_0x4d0f55[_0x4bfaa0]){var _0xe3075a='cf_'+_0x4d0f55[_0x4bfaa0]['id'];var _0x164ecc=_0x4de1cf[_0xe3075a];_0x164ecc[_0x8b24('0x3c')]=_0x4d0f55[_0x4bfaa0][_0x8b24('0x3d')];}}return _0x4de1cf;});})[_0x8b24('0x29')](function(_0x446bb2){_0xadbba0[_0x8b24('0x3e')]=_[_0x8b24('0x33')](_0x446bb2);_0xadbba0[_0x8b24('0x3f')]=_[_0x8b24('0x33')](_0x5d3958['query']);_0xadbba0[_0x8b24('0x40')]=_[_0x8b24('0x41')](_0xadbba0['model'],_0xadbba0[_0x8b24('0x3f')]);_0x59d6e1[_0x8b24('0x42')]=_['intersection'](_0xadbba0[_0x8b24('0x3e')],qs[_0x8b24('0x43')](_0x5d3958[_0x8b24('0x3f')][_0x8b24('0x43')]));_0x59d6e1['attributes']=_0x59d6e1[_0x8b24('0x42')][_0x8b24('0x3b')]?_0x59d6e1[_0x8b24('0x42')]:_0xadbba0[_0x8b24('0x3e')];if(!_0x5d3958[_0x8b24('0x3f')][_0x8b24('0x44')]('nolimit')){_0x59d6e1[_0x8b24('0x22')]=qs[_0x8b24('0x22')](_0x5d3958[_0x8b24('0x3f')][_0x8b24('0x22')]);_0x59d6e1[_0x8b24('0x21')]=qs[_0x8b24('0x21')](_0x5d3958[_0x8b24('0x3f')][_0x8b24('0x21')]);}_0x59d6e1[_0x8b24('0x45')]=qs[_0x8b24('0x46')](_0x5d3958[_0x8b24('0x3f')]['sort']);_0x59d6e1[_0x8b24('0x47')]=qs['filters'](_[_0x8b24('0x48')](_0x5d3958[_0x8b24('0x3f')],_0xadbba0[_0x8b24('0x40')]),_0x446bb2);var _0x5397aa=[];var _0x8a41d0=squel[_0x8b24('0x49')]()[_0x8b24('0x4a')]('id')['field'](_0x8b24('0x2e'))['field']('color')[_0x8b24('0x4b')]('tools_tags');var _0x529cad=squel[_0x8b24('0x49')]()[_0x8b24('0x4b')](_0x8b24('0x4c'),'c')[_0x8b24('0x4d')](_0x8b24('0x4e'),'uc',_0x8b24('0x4f'))[_0x8b24('0x4d')]('cm_contact_has_tags','ct','ct.CmContactId\x20=\x20c.id')[_0x8b24('0x4d')](_0x8b24('0x50'),'t',_0x8b24('0x51'))[_0x8b24('0x47')]('c.deletedAt\x20IS\x20NULL');var _0x357084=squel[_0x8b24('0x52')]();var _0x204297=[];var _0x5a2b4b=squel[_0x8b24('0x52')]();var _0x54cbaf;if(_0x5d3958[_0x8b24('0x3f')][_0x8b24('0x53')]){_0x54cbaf=as['parseSearch'](_0x5d3958[_0x8b24('0x3f')][_0x8b24('0x53')]);var _0x3d3fa6=_0x54cbaf[_0x8b24('0x54')];for(var _0x6e2f3a=0x0;_0x6e2f3a<_0x54cbaf[_0x8b24('0x55')][_0x8b24('0x3b')];_0x6e2f3a++){var _0x7232a0=_0x54cbaf[_0x8b24('0x55')][_0x6e2f3a];var _0x104682='c';var _0xc1f95=_(_0x446bb2)[_0x8b24('0x33')]()['find'](function(_0x2ea25e){return _0x2ea25e===_0x7232a0['field'];});if(_0xc1f95)_0xc1f95=_0x446bb2[_0x7232a0[_0x8b24('0x4a')]];if(!_0xc1f95){if(_0x7232a0[_0x8b24('0x4a')]==='Tag'){var _0x4c7f1f=_0x7232a0[_0x8b24('0x56')][_0x8b24('0x57')](',')[_0x8b24('0x58')](function(_0x353313){return Number(_0x353313);});_0x4c7f1f[_0x8b24('0x59')](function(_0x22619e){_0x5a2b4b['or'](_0x8b24('0x5a'),'%,'+_0x22619e+',%');});_0x204297=_[_0x8b24('0x5b')](_0x204297,_0x4c7f1f);}else if(_0x7232a0['field']==='User'){_0x357084['and'](_0x8b24('0x5c'),_0x7232a0['value']);}}else{if(_0x7232a0[_0x8b24('0x4a')]===_0x8b24('0x5d')||_0xc1f95[_0x8b24('0x3c')]===_0x8b24('0x5e'))_0x7232a0['castTo']=_0x8b24('0x5f');var _0x3df397=as[_0x8b24('0x60')](_0x104682,_0xc1f95[_0x8b24('0x3d')],_0x7232a0);_0x357084[_0x3d3fa6](_0x3df397[_0x8b24('0x61')],_0x3df397[_0x8b24('0x56')][_0x8b24('0x62')],_0x3df397[_0x8b24('0x56')][_0x8b24('0x2b')]);}}}else{var _0x2a03fc=_(Object[_0x8b24('0x33')](_0x5d3958[_0x8b24('0x3f')]))[_0x8b24('0x58')](function(_0x437919){return _0x446bb2[_0x8b24('0x44')](_0x437919)?_0x437919:undefined;})[_0x8b24('0x63')](function(_0x93691c){return!_['isNil'](_0x93691c);})[_0x8b24('0x56')]();if(_0x5d3958[_0x8b24('0x3f')][_0x8b24('0x64')])_0x2a03fc[_0x8b24('0x36')]('Contact');if(!_[_0x8b24('0x65')](_0x2a03fc)){_0x2a03fc[_0x8b24('0x59')](function(_0x7d315){if(_0x7d315===_0x8b24('0x66')){_0x529cad[_0x8b24('0x47')](_0x8b24('0x67'),[][_0x8b24('0x68')](_0x5d3958[_0x8b24('0x3f')][_0x7d315]));}else if(_0x7d315===_0x8b24('0x64')){var _0x17cf69='%'+_0x5d3958[_0x8b24('0x3f')][_0x7d315]+'%';_0x529cad[_0x8b24('0x47')](_0x8b24('0x69'),_0x17cf69);}else{_0x529cad[_0x8b24('0x47')]('c.'+_0x7d315+_0x8b24('0x6a'),_0x5d3958[_0x8b24('0x3f')][_0x7d315]);}});}if(_0x5d3958['query']['tag']){_0x204297=_['isArray'](_0x5d3958[_0x8b24('0x3f')]['tag'])?_0x5d3958['query'][_0x8b24('0x6b')]:new Array(_0x5d3958[_0x8b24('0x3f')]['tag']);_0x204297[_0x8b24('0x59')](function(_0x6e0a03){_0x5a2b4b['or'](_0x8b24('0x5a'),'%,'+_0x6e0a03+',%');});}if(_0x5d3958[_0x8b24('0x3f')][_0x8b24('0x63')]){var _0x28119b=_0x5d3958[_0x8b24('0x3f')]['filter'][_0x8b24('0x6c')]('\x5c','\x5c\x5c')[_0x8b24('0x6c')](/'/g,'\x27\x27');if(_0x28119b[_0x8b24('0x57')]('\x20')['length']>0x1){_0x357084['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x8b24('0x6d')](_0x28119b),null);}else{if(qs[_0x8b24('0x6e')](_0x28119b)){_0x357084['or'](_0x8b24('0x6f'),_0x28119b+'%');_0x357084['or']('c.phone\x20LIKE\x20?',_0x28119b+'%');_0x357084['or'](_0x8b24('0x70'),_0x28119b+'%');_0x357084['or']('c.fax\x20LIKE\x20?',_0x28119b+'%');}else if(qs[_0x8b24('0x71')](_0x28119b)){_0x357084['or'](_0x8b24('0x72'),_0x28119b+'%');}else{_0x357084['or'](_0x8b24('0x73'),'%'+_0x28119b+'%');_0x357084['or'](_0x8b24('0x74'),'%'+_0x28119b+'%');_0x357084['or'](_0x8b24('0x72'),'%'+_0x28119b+'%');}}}}_0x529cad['where'](_0x357084);_0x529cad[_0x8b24('0x75')](_0x8b24('0x76'));var _0x2662b9={'type':db[_0x8b24('0x77')][_0x8b24('0x78')]['SELECT'],'raw':!![]};var _0x5c57ed=_0x529cad[_0x8b24('0x79')]()[_0x8b24('0x4a')](_0x8b24('0x76'));if(_0x59d6e1['order']){_0x59d6e1[_0x8b24('0x45')][_0x8b24('0x59')](function(_0x51b881){_0x529cad['order']('c.'+_0x51b881[0x0],_0x51b881[0x1]===_0x8b24('0x7a')?![]:!![]);});}if(!_[_0x8b24('0x65')](_0x204297)){_0x529cad[_0x8b24('0x7b')](_0x5a2b4b);_0x5c57ed[_0x8b24('0x47')](_0x8b24('0x7c'),_0x204297);}BPromise[_0x8b24('0x7d')]()[_0x8b24('0x29')](function(){if(!_0x54cbaf)return;if(_0x5d3958[_0x8b24('0x7e')][_0x8b24('0x7f')]!=='agent')return;if(!_[_0x8b24('0x80')](_0x54cbaf[_0x8b24('0x55')],[_0x8b24('0x4a'),_0x8b24('0x81')])){return _0x5d3958[_0x8b24('0x7e')]['getLists']({'attributes':['id'],'raw':!![]})['then'](function(_0x4419c2){if(_[_0x8b24('0x65')](_0x4419c2)){_0x5c57ed['where'](_0x8b24('0x82'));_0x529cad['where'](_0x8b24('0x82'));}else{_0x5c57ed['where']('c.ListId\x20IN\x20?',_[_0x8b24('0x58')](_0x4419c2,'id'));_0x529cad[_0x8b24('0x47')]('c.ListId\x20IN\x20?',_[_0x8b24('0x58')](_0x4419c2,'id'));}});}})['then'](function(){if(_0x5d3958[_0x8b24('0x7e')]['role']===_0x8b24('0x83')&&!_0x54cbaf&&!_0x5d3958[_0x8b24('0x3f')][_0x8b24('0x66')])return[];return db[_0x8b24('0x84')]['query'](_0x5c57ed[_0x8b24('0x85')](),_0x2662b9);})[_0x8b24('0x29')](function(_0x304b57){_0x14316c[_0x8b24('0x20')]=_0x304b57['length'];if(_0x14316c[_0x8b24('0x20')]===0x0)return[];return db[_0x8b24('0x84')][_0x8b24('0x3f')](_0x8a41d0[_0x8b24('0x85')](),_0x2662b9)['then'](function(_0x525617){_0x5397aa=_['keyBy'](_0x525617,'id');_0x2662b9=_[_0x8b24('0x86')](_0x2662b9,{'model':db[_0x8b24('0x31')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x5d3958[_0x8b24('0x3f')][_0x8b24('0x43')]){_0x59d6e1[_0x8b24('0x42')][_0x8b24('0x59')](function(_0x4bcdf9){_0x529cad[_0x8b24('0x4a')]('c.'+_0x4bcdf9);});}else{_0x529cad['field'](_0x8b24('0x76'));_0x529cad[_0x8b24('0x4a')](_0x8b24('0x87'));_0x529cad[_0x8b24('0x4a')](_0x8b24('0x88'));_0x529cad[_0x8b24('0x4a')](_0x8b24('0x89'));_0x529cad['field']('c.mobile');_0x529cad[_0x8b24('0x4a')]('c.fax');_0x529cad[_0x8b24('0x4a')]('c.email');_0x529cad[_0x8b24('0x4a')](_0x8b24('0x8a'));_0x529cad[_0x8b24('0x4a')](_0x8b24('0x8b'));_0x529cad[_0x8b24('0x4a')](_0x8b24('0x8c'));_0x529cad[_0x8b24('0x4a')](_0x8b24('0x8d'));_0x529cad[_0x8b24('0x4a')](_0x8b24('0x8e'),_0x8b24('0x8f'));}if(_0x59d6e1[_0x8b24('0x22')])_0x529cad[_0x8b24('0x22')](_0x59d6e1[_0x8b24('0x22')]);if(_0x59d6e1[_0x8b24('0x21')])_0x529cad[_0x8b24('0x21')](_0x59d6e1[_0x8b24('0x21')]);return db['sequelize'][_0x8b24('0x3f')](_0x529cad['toString'](),_0x2662b9);});})[_0x8b24('0x29')](function(_0x368b89){_0x368b89[_0x8b24('0x59')](function(_0x3503a8){if(_0x3503a8[_0x8b24('0x8f')]){_0x3503a8[_0x8b24('0x90')]=[];_0x3503a8[_0x8b24('0x8f')][_0x8b24('0x57')](',')['forEach'](function(_0x4fd50a){_0x3503a8[_0x8b24('0x90')][_0x8b24('0x36')](_0x5397aa[_0x4fd50a]);});}delete _0x3503a8['TagIds'];});_0x14316c['rows']=_0x368b89;return _0x14316c;})[_0x8b24('0x29')](respondWithFilteredResult(_0x36ff89,_0x59d6e1));})['catch'](handleError(_0x36ff89,null));};exports[_0x8b24('0x2a')]=function(_0x5c1012,_0x4573a1){return db[_0x8b24('0x31')][_0x8b24('0x91')]({'where':{'id':_0x5c1012[_0x8b24('0x92')]['id']}})[_0x8b24('0x29')](handleEntityNotFound(_0x4573a1,null))[_0x8b24('0x29')](removeEntity(_0x4573a1,null))['catch'](handleError(_0x4573a1,null));};exports[_0x8b24('0x32')]=function(_0x423aa9,_0x31442f){return db[_0x8b24('0x31')][_0x8b24('0x32')]()['then'](function(_0x3823ff){delete _0x3823ff[_0x8b24('0x93')];for(var _0x253da3=0x0;_0x253da3<Object['keys'](_0x3823ff)[_0x8b24('0x3b')];_0x253da3++){var _0x24a379=Object[_0x8b24('0x33')](_0x3823ff)[_0x253da3];if(!_[_0x8b24('0x34')](_0x24a379,_0x8b24('0x35'))){_0x3823ff[_0x24a379][_0x8b24('0x94')]=_0x24a379;_0x3823ff[_0x24a379][_0x8b24('0x95')]=_0x24a379;}}return _0x3823ff;})[_0x8b24('0x29')](function(_0xa89a48){var _0x39fedb={'where':{'$or':[{'ListId':_0x423aa9['query']['id']},{'ListId':null}]},'raw':!![]};return db[_0x8b24('0x37')][_0x8b24('0x96')](_0x39fedb)[_0x8b24('0x29')](function(_0x3bb704){for(var _0x4be5b3=0x0;_0x4be5b3<_0x3bb704['length'];_0x4be5b3++){var _0x2059a6='cf_'+_0x3bb704[_0x4be5b3]['id'];_0xa89a48[_0x2059a6][_0x8b24('0x94')]=_0x2059a6;_0xa89a48[_0x2059a6][_0x8b24('0x95')]=_0x3bb704[_0x4be5b3]['alias'];_0xa89a48[_0x2059a6]['custom']={'type':_0x3bb704[_0x4be5b3]['type'],'values':_0x3bb704[_0x4be5b3][_0x8b24('0x97')]};}Object[_0x8b24('0x33')](_0xa89a48)['forEach'](function(_0x42d6e2){if(!_0xa89a48[_0x42d6e2][_0x8b24('0x44')](_0x8b24('0x94'))){delete _0xa89a48[_0x42d6e2];}});return _0xa89a48;});})[_0x8b24('0x29')](respondWithResult(_0x31442f,null))[_0x8b24('0x98')](handleError(_0x31442f,null));};exports[_0x8b24('0x86')]=function(_0x56d1da,_0x35618f){var _0x4b4bee;var _0x46099a;var _0x7155a2;if(_0x56d1da[_0x8b24('0x99')]['id']){delete _0x56d1da[_0x8b24('0x99')]['id'];}return db[_0x8b24('0x31')][_0x8b24('0x96')]({'where':{'id':[_0x56d1da[_0x8b24('0x99')]['to'],_0x56d1da[_0x8b24('0x99')][_0x8b24('0x4b')]]}})['then'](function(_0x2dddb2){if(_0x2dddb2){if(_0x2dddb2['length']!==0x2){return null;}_0x2dddb2[0x0]=_0x2dddb2[0x0][_0x8b24('0x9a')]({'plain':!![]});_0x2dddb2[0x1]=_0x2dddb2[0x1][_0x8b24('0x9a')]({'plain':!![]});delete _0x2dddb2[0x0]['id'];delete _0x2dddb2[0x1]['id'];return _[_0x8b24('0x9b')](_0x2dddb2[0x0],_0x2dddb2[0x1],function(_0x556374,_0x197f00){if(Array[_0x8b24('0x9c')](_0x197f00)&&!_0x197f00[_0x8b24('0x3b')]){return _0x556374;}else if(!_0x197f00){return _0x556374;}});}})['then'](handleEntityNotFound(_0x35618f,null))[_0x8b24('0x29')](function(_0x2ec74b){if(_0x2ec74b){if(_0x2ec74b[_0x8b24('0x93')]&&_[_0x8b24('0x9c')](_0x2ec74b[_0x8b24('0x93')])){_0x2ec74b['tags']=_0x2ec74b[_0x8b24('0x93')][_0x8b24('0x9d')]();}logger['info'](_0x8b24('0x9e'),_0x56d1da[_0x8b24('0x99')]['to'],_0x56d1da[_0x8b24('0x99')][_0x8b24('0x4b')]);return db[_0x8b24('0x9f')][_0x8b24('0x2a')]({'where':{'ContactId':[_0x56d1da['body']['to'],_0x56d1da[_0x8b24('0x99')][_0x8b24('0x4b')]]}})['then'](function(_0x201e56){logger['info'](_0x8b24('0xa0'),_0x201e56);return db[_0x8b24('0xa1')]['destroy']({'where':{'ContactId':[_0x56d1da[_0x8b24('0x99')]['to'],_0x56d1da['body']['from']]}})[_0x8b24('0x29')](function(_0x4b1dbc){logger[_0x8b24('0xa2')](_0x8b24('0xa3'),_0x4b1dbc);return db[_0x8b24('0x31')][_0x8b24('0xa4')](_0x2ec74b);});});}})[_0x8b24('0x29')](function(_0x19766f){if(_0x19766f){_0x4b4bee=_0x19766f;_0x46099a={'ContactId':_0x4b4bee['id']};_0x7155a2={'where':{'ContactId':[_0x56d1da[_0x8b24('0x99')]['to'],_0x56d1da[_0x8b24('0x99')][_0x8b24('0x4b')]]}};return db[_0x8b24('0xa5')][_0x8b24('0x28')](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db['ChatMessage']['update'](_0x46099a,_0x7155a2);}})['then'](function(){if(_0x4b4bee){return db[_0x8b24('0xa6')]['update'](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db['MailInteraction']['update'](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db[_0x8b24('0xa7')]['update'](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db[_0x8b24('0xa8')][_0x8b24('0x28')](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db[_0x8b24('0xa7')]['update'](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db[_0x8b24('0xa9')][_0x8b24('0x28')](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db[_0x8b24('0xaa')][_0x8b24('0x28')](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db['FaxInteraction']['update'](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db[_0x8b24('0xab')]['update'](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db[_0x8b24('0xac')][_0x8b24('0x28')](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db[_0x8b24('0xad')]['update'](_0x46099a,_0x7155a2);}})['then'](function(){if(_0x4b4bee){return db[_0x8b24('0xae')][_0x8b24('0x28')](_0x46099a,_0x7155a2);}})['then'](function(){if(_0x4b4bee){return db['CmHopperHistory']['update'](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db[_0x8b24('0xaf')][_0x8b24('0x28')](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db[_0x8b24('0xb0')][_0x8b24('0x28')](_0x46099a,_0x7155a2);}})['then'](function(){if(_0x4b4bee){return db['ChatQueueReport'][_0x8b24('0x28')](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db[_0x8b24('0xb1')][_0x8b24('0x28')](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db[_0x8b24('0xb2')]['update'](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db[_0x8b24('0xb3')][_0x8b24('0x28')](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db[_0x8b24('0xb4')][_0x8b24('0x28')](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db['JscriptySessionReport'][_0x8b24('0x28')](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db['WhatsappInteraction']['update'](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db[_0x8b24('0xb5')][_0x8b24('0x28')](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db[_0x8b24('0xb6')][_0x8b24('0x28')](_0x46099a,_0x7155a2);}})[_0x8b24('0x29')](function(){if(_0x4b4bee){return db[_0x8b24('0x31')][_0x8b24('0x2a')]({'where':{'id':[_0x56d1da[_0x8b24('0x99')]['to'],_0x56d1da['body'][_0x8b24('0x4b')]]}});}})['then'](function(){if(_0x4b4bee){return _0x4b4bee;}})['then'](respondWithResult(_0x35618f,null))[_0x8b24('0x98')](handleError(_0x35618f,null));};exports[_0x8b24('0xa4')]=function(_0x116c08,_0x51054c){return db['CmContact'][_0x8b24('0x32')]()[_0x8b24('0x29')](function(_0x53a7cc){if(_0x116c08[_0x8b24('0x99')][_0x8b24('0x93')]&&_[_0x8b24('0x9c')](_0x116c08['body'][_0x8b24('0x93')])){if(_0x116c08[_0x8b24('0x99')]['tags'][_0x8b24('0x3b')]){_0x116c08[_0x8b24('0x99')][_0x8b24('0x93')]=_0x116c08[_0x8b24('0x99')][_0x8b24('0x93')]['join'](';')+';';}else{_0x116c08['body'][_0x8b24('0x93')]=null;}}else{_0x116c08[_0x8b24('0x99')]['tags']=null;}return db[_0x8b24('0x31')][_0x8b24('0xa4')](_0x116c08[_0x8b24('0x99')],{'fields':_['keys'](_0x53a7cc),'raw':!![]});})[_0x8b24('0x29')](respondWithResult(_0x51054c,0xc9))[_0x8b24('0x98')](handleError(_0x51054c,null));};exports[_0x8b24('0xb7')]=function(_0x1f2de3,_0x3559b8){var _0x10e453=[];var _0x55c160=0x0;var _0x43c714=0x0;var _0x223e72=0x0;return db[_0x8b24('0x31')][_0x8b24('0x32')]()[_0x8b24('0x29')](function(_0x35fb9c){return BPromise[_0x8b24('0xb8')](_0x1f2de3['body'],function(_0x297081){var _0x3ba206={'where':{'$or':[]},'defaults':_0x297081,'fields':_[_0x8b24('0x33')](_0x35fb9c),'raw':!![]};if(_0x297081[_0x8b24('0xb9')]){for(var _0x5b84de=0x0;_0x5b84de<_0x297081[_0x8b24('0xb9')][_0x8b24('0x3b')];_0x5b84de++){var _0x23d673={};_0x23d673[_0x297081[_0x8b24('0xb9')][_0x5b84de]]=_0x297081[_0x297081[_0x8b24('0xb9')][_0x5b84de]];_0x3ba206['where'][_0x8b24('0xba')]['push'](_0x23d673);}_0x3ba206[_0x8b24('0x47')][_0x8b24('0x66')]=_0x297081[_0x8b24('0x66')];}return db[_0x8b24('0x31')]['findOrCreate'](_0x3ba206)['spread'](function(_0x323f8d,_0x1492e1){if(_0x1492e1){_0x55c160++;}else{_0x223e72++;}})['catch'](function(_0x25f6f1){console[_0x8b24('0x2c')](_0x25f6f1);_0x43c714++;});});})['then'](function(_0x4113f5){if(_0x4113f5){return{'success':_0x55c160,'failure':_0x43c714,'duplicates':_0x223e72};}})[_0x8b24('0x29')](respondWithResult(_0x3559b8,0xc9))[_0x8b24('0x98')](handleError(_0x3559b8,null));};exports[_0x8b24('0xbb')]=function(_0x1aade9,_0x394e2e,_0x420ada){var _0x39339a;return db['CmContact'][_0x8b24('0x32')]()['then'](function(_0x368f4c){return db[_0x8b24('0x31')]['find']({'where':{'id':_0x1aade9[_0x8b24('0x92')]['id']},'include':[{'model':db[_0x8b24('0xbc')],'as':'Tags','attributes':['id',_0x8b24('0x2e'),_0x8b24('0xbd')],'required':_0x1aade9[_0x8b24('0x3f')][_0x8b24('0x6b')]?!![]:![]}],'attributes':_[_0x8b24('0x33')](_0x368f4c)});})['then'](function(_0x5f1bc1){_0x39339a=_0x5f1bc1[_0x8b24('0x9a')]({'plain':!![]});var _0x14d7eb={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x5f1bc1&&_0x5f1bc1['ListId']){if(_0x5f1bc1['ListId']){_0x14d7eb['where'][_0x8b24('0xbe')][_0x8b24('0x36')]({'ListId':{'$ne':_0x5f1bc1['ListId']}});}}return db[_0x8b24('0x37')][_0x8b24('0x96')](_0x14d7eb);})[_0x8b24('0x29')](function(_0x54653e){return _[_0x8b24('0xbf')](_0x39339a,_[_0x8b24('0x58')](_0x54653e,function(_0xbe9ceb){return util[_0x8b24('0xc0')](_0x8b24('0xc1'),_0xbe9ceb['id']);}));})['then'](handleEntityNotFound(_0x394e2e,null))[_0x8b24('0x29')](respondWithResult(_0x394e2e,null))[_0x8b24('0x98')](handleError(_0x394e2e,null));};exports[_0x8b24('0x28')]=function(_0x4910f1,_0x35b2f3){var _0xdade5b;if(_0x4910f1[_0x8b24('0x99')]['id']){delete _0x4910f1[_0x8b24('0x99')]['id'];}return db['CmContact']['find']({'where':{'id':_0x4910f1[_0x8b24('0x92')]['id']}})['then'](handleEntityNotFound(_0x35b2f3,null))[_0x8b24('0x29')](saveUpdates(_0x4910f1[_0x8b24('0x99')],null))[_0x8b24('0x29')](function(_0xd0a443){_0xdade5b=_0xd0a443;var _0x40c654={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0xd0a443&&_0xd0a443[_0x8b24('0x66')]){if(_0xd0a443[_0x8b24('0x66')]){_0x40c654[_0x8b24('0x47')][_0x8b24('0xbe')][_0x8b24('0x36')]({'ListId':{'$ne':_0xd0a443[_0x8b24('0x66')]}});}}return db['CmCustomField'][_0x8b24('0x96')](_0x40c654);})[_0x8b24('0x29')](function(_0xf335a0){if(_0xf335a0){return _[_0x8b24('0xbf')](_['pickBy'](_0x4910f1['body'],function(_0x4e0e39,_0x301a8f){return _['startsWith'](_0x301a8f,_0x8b24('0x35'));}),_[_0x8b24('0x58')](_0xf335a0,function(_0xd5aa2a){return util['format'](_0x8b24('0xc1'),_0xd5aa2a['id']);}));}})[_0x8b24('0x29')](function(_0x33f472){if(_0x33f472&&!_[_0x8b24('0x65')](_0x33f472)){var _0x427ebd=squel[_0x8b24('0x28')]()[_0x8b24('0xc2')](_0x8b24('0x4c'))[_0x8b24('0xc3')](_0x33f472)['where'](_0x8b24('0xc4'),_0x4910f1[_0x8b24('0x92')]['id'])[_0x8b24('0xc5')]();return db['sequelize'][_0x8b24('0x3f')](_0x427ebd[_0x8b24('0x61')],{'replacements':_0x427ebd['values']});}})['then'](function(){if(_0x4910f1[_0x8b24('0x99')][_0x8b24('0xc6')]&&_0xdade5b){return db[_0x8b24('0x9f')][_0x8b24('0x28')]({'phone':_0x4910f1[_0x8b24('0x99')][_0x8b24('0xc6')]},{'where':{'ContactId':_0xdade5b['id']}});}})[_0x8b24('0x29')](function(){return _0xdade5b;})[_0x8b24('0x29')](respondWithResult(_0x35b2f3,null))[_0x8b24('0x98')](handleError(_0x35b2f3,null));};exports[_0x8b24('0xc7')]=function(_0xfa2442,_0x17605d,_0x23131c){var _0x4315d7={};var _0x33d0d8={};var _0x10e6c1;var _0x1929e6;return db[_0x8b24('0x31')][_0x8b24('0x38')]({'where':{'id':_0xfa2442['params']['id']}})[_0x8b24('0x29')](handleEntityNotFound(_0x17605d,null))[_0x8b24('0x29')](function(_0x5e4801){if(_0x5e4801){_0x10e6c1=_0x5e4801;_0x33d0d8['model']=_[_0x8b24('0x33')](db[_0x8b24('0xbc')][_0x8b24('0xc8')]);_0x33d0d8[_0x8b24('0x3f')]=_['keys'](_0xfa2442[_0x8b24('0x3f')]);_0x33d0d8['filters']=_[_0x8b24('0x41')](_0x33d0d8['model'],_0x33d0d8[_0x8b24('0x3f')]);_0x4315d7[_0x8b24('0x42')]=_['intersection'](_0x33d0d8[_0x8b24('0x3e')],qs[_0x8b24('0x43')](_0xfa2442['query'][_0x8b24('0x43')]));_0x4315d7[_0x8b24('0x42')]=_0x4315d7['attributes'][_0x8b24('0x3b')]?_0x4315d7[_0x8b24('0x42')]:_0x33d0d8[_0x8b24('0x3e')];_0x4315d7[_0x8b24('0x45')]=qs[_0x8b24('0x46')](_0xfa2442[_0x8b24('0x3f')][_0x8b24('0x46')]);_0x4315d7[_0x8b24('0x47')]=qs[_0x8b24('0x40')](_[_0x8b24('0x48')](_0xfa2442[_0x8b24('0x3f')],_0x33d0d8[_0x8b24('0x40')]));if(_0xfa2442[_0x8b24('0x3f')][_0x8b24('0x63')]){_0x4315d7[_0x8b24('0x47')]=_[_0x8b24('0x86')](_0x4315d7[_0x8b24('0x47')],{'$or':_[_0x8b24('0x58')](_0x4315d7[_0x8b24('0x42')],function(_0x514283){var _0x396afb={};_0x396afb[_0x514283]={'$like':'%'+_0xfa2442[_0x8b24('0x3f')][_0x8b24('0x63')]+'%'};return _0x396afb;})});}_0x4315d7=_[_0x8b24('0x86')]({},_0x4315d7,_0xfa2442['options']);return _0x10e6c1[_0x8b24('0xc7')](_0x4315d7);}})['then'](function(_0x3363a2){if(_0x3363a2){_0x1929e6=_0x3363a2[_0x8b24('0x3b')];if(!_0xfa2442[_0x8b24('0x3f')]['hasOwnProperty']('nolimit')){_0x4315d7[_0x8b24('0x22')]=qs['limit'](_0xfa2442[_0x8b24('0x3f')][_0x8b24('0x22')]);_0x4315d7[_0x8b24('0x21')]=qs[_0x8b24('0x21')](_0xfa2442[_0x8b24('0x3f')]['offset']);}return _0x10e6c1['getTags'](_0x4315d7);}})['then'](function(_0x582b10){if(_0x582b10){return _0x582b10?{'count':_0x1929e6,'rows':_0x582b10}:null;}})[_0x8b24('0x29')](respondWithResult(_0x17605d,null))[_0x8b24('0x98')](handleError(_0x17605d,null));};exports[_0x8b24('0xc9')]=function(_0xad7f94,_0xbc5554,_0x4f042b){if(_0xad7f94[_0x8b24('0x99')]['id']){delete _0xad7f94['body']['id'];}return db[_0x8b24('0x31')][_0x8b24('0x38')]({'where':{'id':_0xad7f94['params']['id']}})['then'](handleEntityNotFound(_0xbc5554,null))[_0x8b24('0x29')](function(_0xf3ed2f){if(_0xf3ed2f){return _0xf3ed2f[_0x8b24('0xc9')](_0xad7f94[_0x8b24('0x99')][_0x8b24('0xca')]||[]);}return null;})[_0x8b24('0x29')](respondWithResult(_0xbc5554,null))[_0x8b24('0x98')](handleError(_0xbc5554,null));};exports[_0x8b24('0xcb')]=function(_0x3e4de4,_0x515036,_0x23ef20){var _0x575a80={'raw':![],'where':{}};var _0x15a5b1={};var _0xa105fe={'count':0x0,'rows':[]};return db[_0x8b24('0x31')][_0x8b24('0x38')]({'where':{'id':_0x3e4de4['params']['id']}})['then'](handleEntityNotFound(_0x515036,null))['then'](function(_0x2dc51a){if(_0x2dc51a){_0x15a5b1[_0x8b24('0x3e')]=_[_0x8b24('0x33')](db[_0x8b24('0x9f')]['rawAttributes']);_0x15a5b1[_0x8b24('0x3f')]=_[_0x8b24('0x33')](_0x3e4de4['query']);_0x15a5b1[_0x8b24('0x40')]=_[_0x8b24('0x41')](_0x15a5b1[_0x8b24('0x3e')],_0x15a5b1[_0x8b24('0x3f')]);_0x575a80['attributes']=_[_0x8b24('0x41')](_0x15a5b1[_0x8b24('0x3e')],qs['fields'](_0x3e4de4['query']['fields']));_0x575a80[_0x8b24('0x42')]=_0x575a80[_0x8b24('0x42')][_0x8b24('0x3b')]?_0x575a80[_0x8b24('0x42')]:_0x15a5b1[_0x8b24('0x3e')];if(!_0x3e4de4[_0x8b24('0x3f')][_0x8b24('0x44')](_0x8b24('0xcc'))){_0x575a80[_0x8b24('0x22')]=qs[_0x8b24('0x22')](_0x3e4de4[_0x8b24('0x3f')][_0x8b24('0x22')]);_0x575a80[_0x8b24('0x21')]=qs['offset'](_0x3e4de4[_0x8b24('0x3f')][_0x8b24('0x21')]);}_0x575a80[_0x8b24('0x45')]=qs[_0x8b24('0x46')](_0x3e4de4['query'][_0x8b24('0x46')]);_0x575a80[_0x8b24('0x47')]=qs[_0x8b24('0x40')](_[_0x8b24('0x48')](_0x3e4de4[_0x8b24('0x3f')],_0x15a5b1['filters']));_0x575a80['where'][_0x8b24('0xcd')]=_0x2dc51a['id'];if(_0x3e4de4['query'][_0x8b24('0x63')]){_0x575a80['where']=_[_0x8b24('0x86')](_0x575a80[_0x8b24('0x47')],{'$or':_[_0x8b24('0x58')](_0x575a80[_0x8b24('0x42')],function(_0x113246){var _0x1d9da4={};_0x1d9da4[_0x113246]={'$like':'%'+_0x3e4de4['query'][_0x8b24('0x63')]+'%'};return _0x1d9da4;})});}_0x575a80=_[_0x8b24('0x86')]({},_0x575a80,_0x3e4de4[_0x8b24('0xce')]);return db[_0x8b24('0x9f')][_0x8b24('0x20')]({'where':_0x575a80[_0x8b24('0x47')]})[_0x8b24('0x29')](function(_0x47ecce){_0xa105fe['count']=_0x47ecce;if(_0x3e4de4['query'][_0x8b24('0xcf')]){_0x575a80['include']=[{'all':!![]}];}return db['CmHopper'][_0x8b24('0x96')](_0x575a80);})[_0x8b24('0x29')](function(_0x174a5f){_0xa105fe[_0x8b24('0xd0')]=_0x174a5f;return _0xa105fe;});}})[_0x8b24('0x29')](respondWithFilteredResult(_0x515036,_0x575a80))[_0x8b24('0x98')](handleError(_0x515036,null));};exports['getHopperHistories']=function(_0xacd949,_0x5c66d5,_0x2d144d){var _0x1d141a={'raw':!![],'where':{}};var _0xa26c6c={};var _0x1ab13d={'count':0x0,'rows':[]};return db['CmContact'][_0x8b24('0x38')]({'where':{'id':_0xacd949[_0x8b24('0x92')]['id']}})['then'](handleEntityNotFound(_0x5c66d5,null))[_0x8b24('0x29')](function(_0x1ca98d){if(_0x1ca98d){_0xa26c6c['model']=_[_0x8b24('0x33')](db[_0x8b24('0xd1')][_0x8b24('0xc8')]);_0xa26c6c[_0x8b24('0x3f')]=_[_0x8b24('0x33')](_0xacd949[_0x8b24('0x3f')]);_0xa26c6c['filters']=_['intersection'](_0xa26c6c[_0x8b24('0x3e')],_0xa26c6c[_0x8b24('0x3f')]);_0x1d141a[_0x8b24('0x42')]=_['intersection'](_0xa26c6c[_0x8b24('0x3e')],qs['fields'](_0xacd949['query'][_0x8b24('0x43')]));_0x1d141a[_0x8b24('0x42')]=_0x1d141a[_0x8b24('0x42')][_0x8b24('0x3b')]?_0x1d141a['attributes']:_0xa26c6c[_0x8b24('0x3e')];if(!_0xacd949[_0x8b24('0x3f')][_0x8b24('0x44')](_0x8b24('0xcc'))){_0x1d141a['limit']=qs['limit'](_0xacd949[_0x8b24('0x3f')][_0x8b24('0x22')]);_0x1d141a[_0x8b24('0x21')]=qs['offset'](_0xacd949['query']['offset']);}_0x1d141a['order']=qs[_0x8b24('0x46')](_0xacd949[_0x8b24('0x3f')][_0x8b24('0x46')]);_0x1d141a[_0x8b24('0x47')]=qs['filters'](_['pick'](_0xacd949[_0x8b24('0x3f')],_0xa26c6c[_0x8b24('0x40')]));_0x1d141a[_0x8b24('0x47')][_0x8b24('0xcd')]=_0x1ca98d['id'];if(_0xacd949['query'][_0x8b24('0x63')]){_0x1d141a[_0x8b24('0x47')]=_[_0x8b24('0x86')](_0x1d141a[_0x8b24('0x47')],{'$or':_[_0x8b24('0x58')](_0x1d141a[_0x8b24('0x42')],function(_0x18df3a){var _0x20625e={};_0x20625e[_0x18df3a]={'$like':'%'+_0xacd949[_0x8b24('0x3f')][_0x8b24('0x63')]+'%'};return _0x20625e;})});}_0x1d141a=_[_0x8b24('0x86')]({},_0x1d141a,_0xacd949['options']);return db[_0x8b24('0xd1')]['count']({'where':_0x1d141a[_0x8b24('0x47')]})[_0x8b24('0x29')](function(_0x373f4e){_0x1ab13d[_0x8b24('0x20')]=_0x373f4e;if(_0xacd949['query'][_0x8b24('0xcf')]){_0x1d141a[_0x8b24('0xd2')]=[{'all':!![]}];}return db['CmHopperHistory'][_0x8b24('0x96')](_0x1d141a);})[_0x8b24('0x29')](function(_0x3e893a){_0x1ab13d['rows']=_0x3e893a;return _0x1ab13d;});}})[_0x8b24('0x29')](respondWithFilteredResult(_0x5c66d5,_0x1d141a))[_0x8b24('0x98')](handleError(_0x5c66d5,null));};exports[_0x8b24('0xd3')]=function(_0x5df5be,_0x3f36af,_0x5250da){var _0x55b5ed={'raw':!![],'where':{}};var _0x39d141={};var _0x14f5df={'count':0x0,'rows':[]};return db[_0x8b24('0x31')][_0x8b24('0x38')]({'where':{'id':_0x5df5be['params']['id']}})[_0x8b24('0x29')](handleEntityNotFound(_0x3f36af,null))['then'](function(_0x21fe1a){if(_0x21fe1a){_0x39d141[_0x8b24('0x3e')]=_[_0x8b24('0x33')](db[_0x8b24('0xae')][_0x8b24('0xc8')]);_0x39d141[_0x8b24('0x3f')]=_[_0x8b24('0x33')](_0x5df5be[_0x8b24('0x3f')]);_0x39d141['filters']=_[_0x8b24('0x41')](_0x39d141[_0x8b24('0x3e')],_0x39d141[_0x8b24('0x3f')]);_0x55b5ed[_0x8b24('0x42')]=_['intersection'](_0x39d141[_0x8b24('0x3e')],qs[_0x8b24('0x43')](_0x5df5be[_0x8b24('0x3f')][_0x8b24('0x43')]));_0x55b5ed[_0x8b24('0x42')]=_0x55b5ed[_0x8b24('0x42')][_0x8b24('0x3b')]?_0x55b5ed[_0x8b24('0x42')]:_0x39d141['model'];if(!_0x5df5be[_0x8b24('0x3f')][_0x8b24('0x44')](_0x8b24('0xcc'))){_0x55b5ed[_0x8b24('0x22')]=qs[_0x8b24('0x22')](_0x5df5be[_0x8b24('0x3f')][_0x8b24('0x22')]);_0x55b5ed[_0x8b24('0x21')]=qs[_0x8b24('0x21')](_0x5df5be['query'][_0x8b24('0x21')]);}_0x55b5ed[_0x8b24('0x45')]=qs[_0x8b24('0x46')](_0x5df5be[_0x8b24('0x3f')][_0x8b24('0x46')]);_0x55b5ed[_0x8b24('0x47')]=qs[_0x8b24('0x40')](_[_0x8b24('0x48')](_0x5df5be['query'],_0x39d141['filters']));_0x55b5ed[_0x8b24('0x47')][_0x8b24('0xcd')]=_0x21fe1a['id'];if(_0x5df5be['query'][_0x8b24('0x63')]){_0x55b5ed[_0x8b24('0x47')]=_['merge'](_0x55b5ed['where'],{'$or':_[_0x8b24('0x58')](_0x55b5ed['attributes'],function(_0x1bf573){var _0x147913={};_0x147913[_0x1bf573]={'$like':'%'+_0x5df5be[_0x8b24('0x3f')][_0x8b24('0x63')]+'%'};return _0x147913;})});}_0x55b5ed=_[_0x8b24('0x86')]({},_0x55b5ed,_0x5df5be[_0x8b24('0xce')]);return db[_0x8b24('0xae')]['count']({'where':_0x55b5ed[_0x8b24('0x47')]})[_0x8b24('0x29')](function(_0x230ac9){_0x14f5df[_0x8b24('0x20')]=_0x230ac9;if(_0x5df5be[_0x8b24('0x3f')]['includeAll']){_0x55b5ed['include']=[{'all':!![]}];}return db[_0x8b24('0xae')][_0x8b24('0x96')](_0x55b5ed);})['then'](function(_0x2a84e1){_0x14f5df[_0x8b24('0xd0')]=_0x2a84e1;return _0x14f5df;});}})[_0x8b24('0x29')](respondWithFilteredResult(_0x3f36af,_0x55b5ed))[_0x8b24('0x98')](handleError(_0x3f36af,null));};exports[_0x8b24('0xd4')]=function(_0x146924,_0x280926,_0x3eb323){var _0x5be263={'raw':!![],'where':{}};var _0x730be7={};var _0x9415ef={'count':0x0,'rows':[]};return db[_0x8b24('0x31')][_0x8b24('0x38')]({'where':{'id':_0x146924[_0x8b24('0x92')]['id']}})['then'](handleEntityNotFound(_0x280926,null))[_0x8b24('0x29')](function(_0x4d508a){if(_0x4d508a){_0x730be7[_0x8b24('0x3e')]=_[_0x8b24('0x33')](db[_0x8b24('0xd5')]['rawAttributes']);_0x730be7[_0x8b24('0x3f')]=_[_0x8b24('0x33')](_0x146924[_0x8b24('0x3f')]);_0x730be7[_0x8b24('0x40')]=_[_0x8b24('0x41')](_0x730be7['model'],_0x730be7[_0x8b24('0x3f')]);_0x5be263[_0x8b24('0x42')]=_[_0x8b24('0x41')](_0x730be7[_0x8b24('0x3e')],qs['fields'](_0x146924[_0x8b24('0x3f')][_0x8b24('0x43')]));_0x5be263[_0x8b24('0x42')]=_0x5be263[_0x8b24('0x42')][_0x8b24('0x3b')]?_0x5be263[_0x8b24('0x42')]:_0x730be7[_0x8b24('0x3e')];if(!_0x146924[_0x8b24('0x3f')][_0x8b24('0x44')]('nolimit')){_0x5be263[_0x8b24('0x22')]=qs['limit'](_0x146924['query']['limit']);_0x5be263[_0x8b24('0x21')]=qs['offset'](_0x146924[_0x8b24('0x3f')][_0x8b24('0x21')]);}_0x5be263['order']=qs[_0x8b24('0x46')](_0x146924[_0x8b24('0x3f')][_0x8b24('0x46')]);_0x5be263[_0x8b24('0x47')]=qs[_0x8b24('0x40')](_[_0x8b24('0x48')](_0x146924[_0x8b24('0x3f')],_0x730be7[_0x8b24('0x40')]));_0x5be263[_0x8b24('0x47')][_0x8b24('0xcd')]=_0x4d508a['id'];if(_0x146924['query'][_0x8b24('0x63')]){_0x5be263[_0x8b24('0x47')]=_[_0x8b24('0x86')](_0x5be263[_0x8b24('0x47')],{'$or':_[_0x8b24('0x58')](_0x5be263[_0x8b24('0x42')],function(_0x456baf){var _0x4be9d1={};_0x4be9d1[_0x456baf]={'$like':'%'+_0x146924[_0x8b24('0x3f')][_0x8b24('0x63')]+'%'};return _0x4be9d1;})});}_0x5be263=_['merge']({},_0x5be263,_0x146924[_0x8b24('0xce')]);return db['JscriptySessionReport']['count']({'where':_0x5be263[_0x8b24('0x47')]})[_0x8b24('0x29')](function(_0x2b98d9){_0x9415ef[_0x8b24('0x20')]=_0x2b98d9;if(_0x146924['query']['includeAll']){_0x5be263[_0x8b24('0xd2')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0x8b24('0x96')](_0x5be263);})[_0x8b24('0x29')](function(_0x5273b9){_0x9415ef['rows']=_0x5273b9;return _0x9415ef;});}})[_0x8b24('0x29')](respondWithFilteredResult(_0x280926,_0x5be263))[_0x8b24('0x98')](handleError(_0x280926,null));};exports[_0x8b24('0xd6')]=function(_0x2b893b,_0x47eafe,_0x372885){try{if(!_0x2b893b[_0x8b24('0x99')]['ListId']){throw new Error(_0x8b24('0xd7'));}if(!_0x2b893b[_0x8b24('0x99')]['binding_keys']){throw new Error('No\x20association\x20keys\x20specified!');}if(!_0x2b893b[_0x8b24('0x99')][_0x8b24('0xd8')]){throw new Error('No\x20association\x20values\x20specified!');}if(!_0x2b893b[_0x8b24('0x99')][_0x8b24('0xd9')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x127d7c=_0x2b893b[_0x8b24('0x99')][_0x8b24('0xda')][_0x8b24('0x57')](',');var _0x175d83=_0x2b893b[_0x8b24('0x99')]['binding_values'][_0x8b24('0x57')](',');if(!_0x127d7c['length']||!_0x175d83['length']||_0x127d7c[_0x8b24('0x3b')]!==_0x175d83[_0x8b24('0x3b')]){throw new Error('Incorrect\x20binding\x20parameters\x20passed!');}_0x2b893b['body'][_0x8b24('0x43')]=_[_0x8b24('0xdb')](_0x127d7c,_0x175d83);if(!_0x2b893b[_0x8b24('0x99')]['fields'][_0x8b24('0xc6')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x2b893b[_0x8b24('0x99')][_0x8b24('0x43')][_0x8b24('0xdc')]){throw new Error('No\x20firstName\x20column\x20specified');}var _0x87518f=path[_0x8b24('0x9d')](config[_0x8b24('0xdd')],_0x8b24('0xde'),_0x2b893b[_0x8b24('0xdf')][_0x8b24('0xe0')]);fs[_0x8b24('0xe1')](_0x87518f,parseInt(_0x8b24('0xe2'),0x8));var _0xf3178b=require(_0x8b24('0xe3'))[_0x8b24('0xe4')](path[_0x8b24('0x9d')](__dirname,_0x8b24('0xe5')),[_0x87518f,_0x2b893b[_0x8b24('0x99')]['binding_keys'],_0x2b893b[_0x8b24('0x99')][_0x8b24('0xd8')],_0x2b893b[_0x8b24('0x99')][_0x8b24('0x66')],_0x2b893b['body']['CompanyId'],_0x2b893b['body']['duplicates'],_0x2b893b[_0x8b24('0x99')][_0x8b24('0xd9')]]);return _0x47eafe[_0x8b24('0x1f')](0xc8)[_0x8b24('0x25')]({'message':_0x8b24('0xe6'),'pid':_0xf3178b[_0x8b24('0xe7')]});}catch(_0x2a9b0b){return _0x47eafe[_0x8b24('0x1f')](0x1f4)[_0x8b24('0x2f')](_0x2a9b0b);}};exports[_0x8b24('0xe8')]=function(_0x21e779,_0x442706,_0x565954){var _0x3bbf60=fs[_0x8b24('0xe9')](_0x21e779[_0x8b24('0xdf')][_0x8b24('0x7')]);Papa[_0x8b24('0xea')](_0x3bbf60,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x52f748){return _0x442706['status'](0xc8)[_0x8b24('0x25')]({'file':_0x21e779[_0x8b24('0xdf')],'fields':_0x52f748[_0x8b24('0xeb')][_0x8b24('0x43')]});}});};exports[_0x8b24('0xec')]=function(_0x2cf2a3,_0x5eb14a,_0x4bd162){return db[_0x8b24('0x81')][_0x8b24('0x96')]({'raw':!![],'attributes':['id'],'where':{'role':_0x8b24('0x83')}})[_0x8b24('0x29')](function(_0x2979fa){var _0x5535c3=![];if(!_0x2cf2a3[_0x8b24('0x99')][_0x8b24('0x66')]){throw new Error('No\x20ListId\x20specified');}if(!_0x2cf2a3[_0x8b24('0x99')][_0x8b24('0xed')][_0x8b24('0xc6')]){throw new Error(_0x8b24('0xee'));}if(!_0x2cf2a3[_0x8b24('0x99')][_0x8b24('0xed')][_0x8b24('0xdc')]){throw new Error(_0x8b24('0xef'));}if(!_0x2cf2a3[_0x8b24('0x99')][_0x8b24('0xd9')]){throw new Error(_0x8b24('0xf0'));}var _0x42cfae=require(_0x8b24('0xe3'))[_0x8b24('0xe4')](path[_0x8b24('0x9d')](__dirname,_0x8b24('0xf1')),[_0x2cf2a3['params']['id'],JSON[_0x8b24('0xf2')](_0x2cf2a3[_0x8b24('0x99')]),JSON[_0x8b24('0xf2')](_0x2979fa)]);_0x42cfae['on'](_0x8b24('0xf3'),function(_0x2b984d){_0x5535c3=!![];return _0x5eb14a[_0x8b24('0x1f')](0xc8)[_0x8b24('0x25')]({'message':_0x8b24('0xf4'),'pid':_0x42cfae[_0x8b24('0xe7')]});});_0x42cfae['on'](_0x8b24('0xf5'),function(_0x5bd4ed){if(_0x5bd4ed&&!_0x5535c3){return _0x5eb14a[_0x8b24('0x1f')](0x1f4)[_0x8b24('0x25')]({'message':'error\x20child\x20process','pid':_0x42cfae['pid']});}});})['catch'](handleError(_0x5eb14a,null));};exports[_0x8b24('0xf6')]=function(_0x282b53,_0x1c8c98){var _0x56ba05=['mail',_0x8b24('0xf7'),'sms','openchannel',_0x8b24('0xf8'),'whatsapp',_0x8b24('0xf9')];var _0xf44a17={'offset':0x0,'order':qs[_0x8b24('0x46')](_0x8b24('0xfa'))},_0x125bc4={'count':0x0,'rows':[]};Promise[_0x8b24('0x7d')]()[_0x8b24('0x29')](function(){if(_0x282b53[_0x8b24('0x3f')]['channel']){if(!_[_0x8b24('0xfb')](_0x56ba05,_0x282b53['query'][_0x8b24('0xfc')][_0x8b24('0xfd')]())){throw new Error('Invalid\x20channel');}_0x56ba05=[_0x282b53[_0x8b24('0x3f')][_0x8b24('0xfc')][_0x8b24('0xfd')]()];}if(_0x282b53[_0x8b24('0x3f')]['range']){try{var _0x4260d9=JSON['parse'](_0x282b53[_0x8b24('0x3f')]['range']);if(!moment(_0x4260d9[_0x8b24('0x4b')])['isValid']()){throw new Error('Invalid\x20date\x20for\x20range\x20from\x20filter');}if(!moment(_0x4260d9['to'])[_0x8b24('0xfe')]()){throw new Error('Invalid\x20date\x20for\x20range\x20to\x20filter');}}catch(_0x117ac3){throw new Error(_0x8b24('0xff'));}}if(!_0x282b53[_0x8b24('0x3f')][_0x8b24('0x44')](_0x8b24('0xcc'))){_0xf44a17['limit']=qs[_0x8b24('0x22')](_0x282b53['query'][_0x8b24('0x22')]||0xa);_0xf44a17[_0x8b24('0x21')]=qs[_0x8b24('0x21')](_0x282b53[_0x8b24('0x3f')][_0x8b24('0x21')]);}var _0x38dbed=_0x56ba05[_0x8b24('0x58')](function(_0x50fc14){if(_0x50fc14==='voice'){var _0x4ab558={'attributes':['id',_0x8b24('0x100'),'type',_0x8b24('0x101'),_0x8b24('0x102'),_0x8b24('0x103'),_0x8b24('0x104'),_0x8b24('0x105'),_0x8b24('0x106'),'note',_0x8b24('0x107'),_0x8b24('0x108'),_0x8b24('0x109'),_0x8b24('0x10a')],'where':{'ContactId':_0x282b53[_0x8b24('0x92')]['id']},'include':[{'model':db[_0x8b24('0x81')],'as':_0x8b24('0x81'),'attributes':['id',_0x8b24('0x2e'),_0x8b24('0x10b'),_0x8b24('0x10c')]}],'order':[[_0x8b24('0x107'),'DESC']]};if(_0x282b53[_0x8b24('0x3f')][_0x8b24('0x10d')]){_0x4ab558[_0x8b24('0x47')][_0x8b24('0x107')]={'$gte':_0x4260d9[_0x8b24('0x4b')],'$lte':_0x4260d9['to']};}return db[_0x8b24('0xb0')]['findAndCountAll'](_0x4ab558)['then'](function(_0x43fef9){_0x125bc4['count']+=_0x43fef9[_0x8b24('0x20')];return _[_0x8b24('0x58')](_0x43fef9['rows'],function(_0x477ce0){var _0x262520=_0x477ce0['get']({'plain':!![]});_0x262520[_0x8b24('0xfc')]=_0x50fc14;if(_0x262520[_0x8b24('0x81')]){_0x262520[_0x8b24('0x81')]={'id':_0x262520['User']['id'],'name':_0x262520[_0x8b24('0x81')][_0x8b24('0x2e')],'fullname':_0x262520[_0x8b24('0x81')][_0x8b24('0x10b')],'alias':_0x262520[_0x8b24('0x81')][_0x8b24('0x10c')]};}return _0x262520;});});}else{var _0x513273=_['startCase'](_0x50fc14)+(_0x50fc14==='chat'?'Website':_0x8b24('0x10e'));var _0x176869={'attributes':['id',_0x8b24('0x10f'),'closedAt',_0x8b24('0x107'),_0x8b24('0x110'),_0x8b24('0x111'),_0x8b24('0x112'),_0x8b24('0x113'),_0x8b24('0x114'),_0x513273+'Id'],'where':{'ContactId':_0x282b53[_0x8b24('0x92')]['id']},'include':[{'model':db[_0x513273],'as':_0x8b24('0x10e'),'attributes':['id',_0x8b24('0x2e'),_0x8b24('0x115')]},{'model':db[_0x8b24('0x81')],'as':_0x8b24('0x116'),'attributes':['id',_0x8b24('0x2e'),_0x8b24('0x10b')]},{'model':db[_0x8b24('0xbc')],'as':_0x8b24('0x90'),'attributes':['id',_0x8b24('0x2e'),'color'],'through':{'attributes':[]}}],'order':[['createdAt','DESC']]};if(_0x282b53[_0x8b24('0x3f')][_0x8b24('0x10d')]){_0x176869[_0x8b24('0x47')]['createdAt']={'$gte':_0x4260d9[_0x8b24('0x4b')],'$lte':_0x4260d9['to']};}switch(_0x50fc14){case'chat':_0x176869['attributes'][_0x8b24('0x36')](_0x8b24('0x117'),_0x8b24('0x118'),_0x8b24('0x119'),_0x8b24('0x11a'),_0x8b24('0x11b'),_0x8b24('0x11c'),_0x8b24('0x11d'),'ratingValue',_0x8b24('0x11e'));break;case _0x8b24('0x11f'):_0x176869[_0x8b24('0x42')][_0x8b24('0x36')]('subject',_0x8b24('0x120'));break;case _0x8b24('0x121'):_0x176869[_0x8b24('0x42')]['push'](_0x8b24('0x122'),_0x8b24('0x123'));break;}return db[_[_0x8b24('0x124')](_0x50fc14)+_0x8b24('0x125')]['findAndCountAll'](_0x176869)[_0x8b24('0x29')](function(_0x500b62){_0x125bc4['count']+=_0x500b62['count'];return _['map'](_0x500b62[_0x8b24('0xd0')],function(_0x5b636e){var _0x83b85a=_0x5b636e[_0x8b24('0x9a')]({'plain':!![]});_0x83b85a[_0x8b24('0xfc')]=_0x50fc14;if(_0x83b85a[_0x8b24('0x116')]){_0x83b85a['Owner']={'id':_0x83b85a[_0x8b24('0x116')]['id'],'name':_0x83b85a[_0x8b24('0x116')]['name'],'fullname':_0x83b85a[_0x8b24('0x116')][_0x8b24('0x10b')]};}return _0x83b85a;});});}});return Promise[_0x8b24('0x3a')](_0x38dbed);})['then'](function(_0x5f43e2){return _(_0x5f43e2)[_0x8b24('0x126')]()[_0x8b24('0x127')]('createdAt')[_0x8b24('0x128')]()[_0x8b24('0x56')]();})[_0x8b24('0x29')](function(_0x10f1b4){_0x125bc4[_0x8b24('0xd0')]=_0xf44a17[_0x8b24('0x22')]?_0x10f1b4[_0x8b24('0x129')](_0xf44a17['offset'],_0xf44a17['offset']+_0xf44a17[_0x8b24('0x22')]):_0x10f1b4;return _0x125bc4;})[_0x8b24('0x29')](respondWithFilteredResult(_0x1c8c98,_0xf44a17))['catch'](handleError(_0x1c8c98,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff