18 var _0xc892=['text','phone','getTags','findOne','rawAttributes','fields','options','setTags','ids','ContactId','includeAll','include','getHopperHistories','getHopperFinals','CmHopperFinal','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','binding_values','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','firstName','root','server/files/tmp','file','chmodSync','0777','child_process','fork','../../components/import/cm/csv','CompanyId','pid','send','upload','meta','import','agent','binding','../../components/import/cm/csv2','stringify','message','exit','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','path','sox','ejs','lodash','squel','crypto','jsforce','to-csv','querystring','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','socket.io-emitter','./cmContact.socket','register','end','json','count','offset','limit','status','Content-Range','apply','reject','save','then','destroy','sendStatus','name','index','CmContact','model','keys','query','filters','intersection','attributes','length','hasOwnProperty','nolimit','order','sort','pick','select','field','color','tools_tags','cm_contacts','where','c.deletedAt\x20IS\x20NULL','expr','advancedFilter','parse','condition','isArray','value','and','tableAlias','\x20LIKE\x20?','\x20>\x20?','\x20<\x20?','filter','isNil','isEmpty','c.ListId\x20IN\x20?','concat','replace','\x27\x27\x27\x27','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?','DESC','group','c.id','Sequelize','QueryTypes','SELECT','clone','COUNT(*)','tag','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','left_join','ct.CmContactId\x20=\x20c.id','t.id\x20=\x20ct.TagId','t.id\x20IN\x20?','sequelize','toString','keyBy','c.*','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','cm_contact_has_tags','Tags','split','push','rows','catch','find','params','describe','startsWith','columnName','displayName','findAll','cf_','alias','values','merge','body','from','get','mergeWith','tags','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','CmHopperBlack','update','MailInteraction','MailMessage','SmsInteraction','FaxInteraction','FaxMessage','OpenchannelInteraction','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','JscriptySessionReport','create','join','bulkCreate','duplicates','$or','ListId','findOrCreate','error','show','Tag','$and','CmCustomField','omit','format','cf_%d','pickBy','map','table','setFields','id\x20=\x20?','toParam'];(function(_0x1dc967,_0x1829be){var _0x38a238=function(_0x1e9a01){while(--_0x1e9a01){_0x1dc967['push'](_0x1dc967['shift']());}};_0x38a238(++_0x1829be);}(_0xc892,0x10d));var _0x2c89=function(_0x55b0e7,_0x47b099){_0x55b0e7=_0x55b0e7-0x0;var _0x314708=_0xc892[_0x55b0e7];return _0x314708;};'use strict';var pdf=require(_0x2c89('0x0'));var emlformat=require(_0x2c89('0x1'));var rimraf=require(_0x2c89('0x2'));var zipdir=require(_0x2c89('0x3'));var jsonpatch=require(_0x2c89('0x4'));var rp=require(_0x2c89('0x5'));var moment=require('moment');var BPromise=require(_0x2c89('0x6'));var Mustache=require(_0x2c89('0x7'));var util=require('util');var path=require(_0x2c89('0x8'));var sox=require(_0x2c89('0x9'));var csv=require('to-csv');var ejs=require(_0x2c89('0xa'));var fs=require('fs');var _=require(_0x2c89('0xb'));var squel=require(_0x2c89('0xc'));var crypto=require(_0x2c89('0xd'));var jsforce=require(_0x2c89('0xe'));var deskjs=require('desk.js');var toCsv=require(_0x2c89('0xf'));var querystring=require(_0x2c89('0x10'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x2c89('0x11'));var qs=require(_0x2c89('0x12'));var hardwareService=require(_0x2c89('0x13'));var logger=require(_0x2c89('0x14'))(_0x2c89('0x15'));var utils=require(_0x2c89('0x16'));var config=require(_0x2c89('0x17'));var db=require(_0x2c89('0x18'))['db'];config[_0x2c89('0x19')]=_[_0x2c89('0x1a')](config['redis'],{'host':'localhost','port':0x18eb});var socket=require(_0x2c89('0x1b'))(new Redis(config[_0x2c89('0x19')]));require(_0x2c89('0x1c'))[_0x2c89('0x1d')](socket);function respondWithStatusCode(_0x18c023,_0x3fa907){_0x3fa907=_0x3fa907||0xcc;return function(_0xf814ba){if(_0xf814ba){return _0x18c023['sendStatus'](_0x3fa907);}return _0x18c023['status'](_0x3fa907)[_0x2c89('0x1e')]();};}function respondWithResult(_0x41abf8,_0x167e28){_0x167e28=_0x167e28||0xc8;return function(_0xe6742){if(_0xe6742){return _0x41abf8['status'](_0x167e28)[_0x2c89('0x1f')](_0xe6742);}};}function respondWithFilteredResult(_0x1c5bbd,_0x15bbd4){return function(_0x1e5134){if(_0x1e5134){var _0x3a589f=_0x1e5134[_0x2c89('0x20')],_0x4cf917=_0x15bbd4[_0x2c89('0x21')],_0x28b4e1=_0x15bbd4[_0x2c89('0x21')]+_0x15bbd4[_0x2c89('0x22')],_0x153f03;if(_0x28b4e1>=_0x3a589f){_0x28b4e1=_0x3a589f;_0x153f03=0xc8;}else{_0x153f03=0xce;}_0x1c5bbd[_0x2c89('0x23')](_0x153f03);return _0x1c5bbd['set'](_0x2c89('0x24'),_0x4cf917+'-'+_0x28b4e1+'/'+_0x3a589f)[_0x2c89('0x1f')](_0x1e5134);}return null;};}function patchUpdates(_0x227f2d){return function(_0x3e821f){try{jsonpatch[_0x2c89('0x25')](_0x3e821f,_0x227f2d,!![]);}catch(_0x405176){return BPromise[_0x2c89('0x26')](_0x405176);}return _0x3e821f[_0x2c89('0x27')]();};}function saveUpdates(_0x1e899e,_0x1ccec6){return function(_0x38d8fa){if(_0x38d8fa){return _0x38d8fa['update'](_0x1e899e)[_0x2c89('0x28')](function(_0x556d5e){return _0x556d5e;});}return null;};}function removeEntity(_0x298d33,_0x4d3d15){return function(_0xabb031){if(_0xabb031){return _0xabb031[_0x2c89('0x29')]()['then'](function(){_0x298d33[_0x2c89('0x23')](0xcc)[_0x2c89('0x1e')]();});}};}function handleEntityNotFound(_0x2b3e04,_0x5673ce){return function(_0x531c57){if(!_0x531c57){_0x2b3e04[_0x2c89('0x2a')](0x194);}return _0x531c57;};}function handleError(_0x5d1d73,_0x176f93){_0x176f93=_0x176f93||0x1f4;return function(_0x14a4c0){logger['error'](_0x14a4c0['stack']);if(_0x14a4c0[_0x2c89('0x2b')]){delete _0x14a4c0['name'];}_0x5d1d73[_0x2c89('0x23')](_0x176f93)['send'](_0x14a4c0);};}exports[_0x2c89('0x2c')]=function(_0x444cfa,_0x2c4191){var _0x3929c6={},_0x597d82={},_0x3d491b={'count':0x0,'rows':[]};return db[_0x2c89('0x2d')]['describe']()[_0x2c89('0x28')](function(_0x32df5e){_0x597d82[_0x2c89('0x2e')]=_[_0x2c89('0x2f')](_0x32df5e);_0x597d82[_0x2c89('0x30')]=_['keys'](_0x444cfa[_0x2c89('0x30')]);_0x597d82[_0x2c89('0x31')]=_[_0x2c89('0x32')](_0x597d82[_0x2c89('0x2e')],_0x597d82[_0x2c89('0x30')]);_0x3929c6['attributes']=_[_0x2c89('0x32')](_0x597d82[_0x2c89('0x2e')],qs['fields'](_0x444cfa[_0x2c89('0x30')]['fields']));_0x3929c6[_0x2c89('0x33')]=_0x3929c6['attributes'][_0x2c89('0x34')]?_0x3929c6[_0x2c89('0x33')]:_0x597d82['model'];if(!_0x444cfa[_0x2c89('0x30')][_0x2c89('0x35')](_0x2c89('0x36'))){_0x3929c6[_0x2c89('0x22')]=qs['limit'](_0x444cfa[_0x2c89('0x30')]['limit']);_0x3929c6[_0x2c89('0x21')]=qs[_0x2c89('0x21')](_0x444cfa[_0x2c89('0x30')][_0x2c89('0x21')]);}_0x3929c6[_0x2c89('0x37')]=qs[_0x2c89('0x38')](_0x444cfa[_0x2c89('0x30')][_0x2c89('0x38')]);_0x3929c6['where']=qs['filters'](_[_0x2c89('0x39')](_0x444cfa[_0x2c89('0x30')],_0x597d82['filters']));var _0x32fc44=[];var _0x52e235=squel[_0x2c89('0x3a')]()[_0x2c89('0x3b')]('id')[_0x2c89('0x3b')](_0x2c89('0x2b'))[_0x2c89('0x3b')](_0x2c89('0x3c'))['from'](_0x2c89('0x3d'));var _0x58a786=squel[_0x2c89('0x3a')]()['from'](_0x2c89('0x3e'),'c')[_0x2c89('0x3f')](_0x2c89('0x40'));var _0x3d5200=squel[_0x2c89('0x41')]();if(_0x444cfa['query'][_0x2c89('0x42')]){var _0x34c7f6=JSON[_0x2c89('0x43')](_0x444cfa['query'][_0x2c89('0x42')]);_['keys'](_0x34c7f6)['forEach'](function(_0x2d3a38){var _0x313455=_0x34c7f6[_0x2d3a38];switch(_0x313455[_0x2c89('0x44')]){case'IS':if(_[_0x2c89('0x45')](_0x313455[_0x2c89('0x46')])&&_0x313455['value'][_0x2c89('0x34')]>0x1){_0x3d5200[_0x2c89('0x47')](_0x313455['tableAlias']+'.'+_0x2d3a38+'\x20IN\x20?',_0x313455['value']);}else{_0x3d5200['and'](_0x313455[_0x2c89('0x48')]+'.'+_0x2d3a38+'\x20=\x20?',_0x313455['value'][0x0]);}break;case'=':_0x3d5200[_0x2c89('0x47')](_0x313455[_0x2c89('0x48')]+'.'+_0x2d3a38+'\x20=\x20?',_0x313455[_0x2c89('0x46')]);break;case'LIKE':_0x3d5200[_0x2c89('0x47')](_0x313455[_0x2c89('0x48')]+'.'+_0x2d3a38+_0x2c89('0x49'),'%'+_0x313455[_0x2c89('0x46')]+'%');break;case'>':_0x3d5200[_0x2c89('0x47')](_0x313455[_0x2c89('0x48')]+'.'+_0x2d3a38+_0x2c89('0x4a'),_0x313455[_0x2c89('0x46')]);break;case'<':_0x3d5200[_0x2c89('0x47')](_0x313455[_0x2c89('0x48')]+'.'+_0x2d3a38+_0x2c89('0x4b'),_0x313455[_0x2c89('0x46')]);break;}});}else{var _0x271be5=_(Object[_0x2c89('0x2f')](_0x444cfa[_0x2c89('0x30')]))['map'](function(_0x1c2b8c){return _0x32df5e[_0x2c89('0x35')](_0x1c2b8c)?_0x1c2b8c:undefined;})[_0x2c89('0x4c')](function(_0x1b5143){return!_[_0x2c89('0x4d')](_0x1b5143);})[_0x2c89('0x46')]();if(!_[_0x2c89('0x4e')](_0x271be5)){_0x271be5['forEach'](function(_0x3aa153){if(_0x3aa153==='ListId'){_0x58a786['where'](_0x2c89('0x4f'),[][_0x2c89('0x50')](_0x444cfa[_0x2c89('0x30')][_0x3aa153]));}else{_0x58a786[_0x2c89('0x3f')]('c.'+_0x3aa153+'\x20=\x20?',_0x444cfa['query'][_0x3aa153]);}});}if(_0x444cfa['query'][_0x2c89('0x4c')]){var _0x9ffa4d=_0x444cfa['query'][_0x2c89('0x4c')][_0x2c89('0x51')]('\x5c','\x5c\x5c')[_0x2c89('0x51')]('\x27\x27',_0x2c89('0x52'));if(qs[_0x2c89('0x53')](_0x9ffa4d)){_0x3d5200['or'](_0x2c89('0x54'),_0x9ffa4d+'%');_0x3d5200['or'](_0x2c89('0x55'),_0x9ffa4d+'%');_0x3d5200['or'](_0x2c89('0x56'),_0x9ffa4d+'%');_0x3d5200['or'](_0x2c89('0x57'),_0x9ffa4d+'%');}else if(qs[_0x2c89('0x58')](_0x9ffa4d)){_0x3d5200['or'](_0x2c89('0x59'),_0x9ffa4d+'%');}else{_0x3d5200['or'](_0x2c89('0x59'),_0x9ffa4d+'%');_0x3d5200['or'](_0x2c89('0x5a'),_0x9ffa4d+'%');_0x3d5200['or'](_0x2c89('0x5b'),_0x9ffa4d+'%');}}}_0x58a786[_0x2c89('0x3f')](_0x3d5200);if(_0x3929c6[_0x2c89('0x37')]){_0x3929c6[_0x2c89('0x37')]['forEach'](function(_0x31f2d8){_0x58a786['order']('c.'+_0x31f2d8[0x0],_0x31f2d8[0x1]===_0x2c89('0x5c')?![]:!![]);});}_0x58a786[_0x2c89('0x5d')](_0x2c89('0x5e'));var _0x2453a3={'type':db[_0x2c89('0x5f')][_0x2c89('0x60')][_0x2c89('0x61')],'raw':!![]};var _0x221363=_0x58a786[_0x2c89('0x62')]()['field'](_0x2c89('0x63'));if(!_0x444cfa[_0x2c89('0x30')][_0x2c89('0x42')]){if(_0x444cfa[_0x2c89('0x30')][_0x2c89('0x64')]){var _0x467425=_[_0x2c89('0x45')](_0x444cfa[_0x2c89('0x30')][_0x2c89('0x64')])?_0x444cfa[_0x2c89('0x30')][_0x2c89('0x64')]:new Array(_0x444cfa['query'][_0x2c89('0x64')]);var _0x2cab7f=squel[_0x2c89('0x41')]();_0x467425[_0x2c89('0x65')](function(_0x2305aa){_0x2cab7f['or'](_0x2c89('0x66'),'%,'+_0x2305aa+',%');});_0x58a786['having'](_0x2cab7f);_0x221363[_0x2c89('0x67')]('cm_contact_has_tags','ct',_0x2c89('0x68'));_0x221363[_0x2c89('0x67')](_0x2c89('0x3d'),'t',_0x2c89('0x69'));_0x221363[_0x2c89('0x3f')](_0x2c89('0x6a'),_0x467425);}}db[_0x2c89('0x6b')][_0x2c89('0x30')](_0x52e235[_0x2c89('0x6c')](),_0x2453a3)[_0x2c89('0x28')](function(_0x271401){_0x32fc44=_[_0x2c89('0x6d')](_0x271401,'id');return db['sequelize'][_0x2c89('0x30')](_0x221363[_0x2c89('0x6c')](),_0x2453a3);})[_0x2c89('0x28')](function(_0x2d3a77){_0x3d491b[_0x2c89('0x20')]=_0x2d3a77['length'];_0x2453a3=_['merge'](_0x2453a3,{'model':db['CmContact'],'mapToModel':!![],'raw':!![],'nest':!![]});_0x58a786[_0x2c89('0x3b')](_0x2c89('0x6e'));_0x58a786[_0x2c89('0x3b')](_0x2c89('0x6f'),_0x2c89('0x70'));_0x58a786[_0x2c89('0x67')](_0x2c89('0x71'),'ct',_0x2c89('0x68'));_0x58a786[_0x2c89('0x67')](_0x2c89('0x3d'),'t','t.id\x20=\x20ct.TagId');if(_0x3929c6[_0x2c89('0x22')]){_0x58a786['limit'](_0x3929c6[_0x2c89('0x22')]);}if(_0x3929c6[_0x2c89('0x21')]){_0x58a786[_0x2c89('0x21')](_0x3929c6[_0x2c89('0x21')]);}db[_0x2c89('0x6b')][_0x2c89('0x30')](_0x58a786[_0x2c89('0x6c')](),_0x2453a3)[_0x2c89('0x28')](function(_0x38c03c){_0x38c03c[_0x2c89('0x65')](function(_0x5db949){if(_0x5db949['TagIds']){_0x5db949[_0x2c89('0x72')]=[];_0x5db949[_0x2c89('0x70')][_0x2c89('0x73')](',')[_0x2c89('0x65')](function(_0x3403b9){_0x5db949[_0x2c89('0x72')][_0x2c89('0x74')](_0x32fc44[_0x3403b9]);});}delete _0x5db949[_0x2c89('0x70')];});_0x3d491b[_0x2c89('0x75')]=_0x38c03c;return _0x3d491b;})[_0x2c89('0x28')](respondWithFilteredResult(_0x2c4191,_0x3929c6))[_0x2c89('0x76')](handleError(_0x2c4191,null));});});};exports[_0x2c89('0x29')]=function(_0xb934f3,_0x34ff2a){return db[_0x2c89('0x2d')][_0x2c89('0x77')]({'where':{'id':_0xb934f3[_0x2c89('0x78')]['id']}})[_0x2c89('0x28')](handleEntityNotFound(_0x34ff2a,null))[_0x2c89('0x28')](removeEntity(_0x34ff2a,null))[_0x2c89('0x76')](handleError(_0x34ff2a,null));};exports['describe']=function(_0x267dfd,_0x23029f){return db['CmContact'][_0x2c89('0x79')]()[_0x2c89('0x28')](function(_0x415f11){for(var _0x3a29fd=0x0;_0x3a29fd<Object[_0x2c89('0x2f')](_0x415f11)[_0x2c89('0x34')];_0x3a29fd++){var _0x5ecbc9=Object[_0x2c89('0x2f')](_0x415f11)[_0x3a29fd];if(!_[_0x2c89('0x7a')](_0x5ecbc9,'cf_')){_0x415f11[_0x5ecbc9][_0x2c89('0x7b')]=_0x5ecbc9;_0x415f11[_0x5ecbc9][_0x2c89('0x7c')]=_0x5ecbc9;}}return _0x415f11;})[_0x2c89('0x28')](function(_0x209a02){var _0x2dbd95={'where':{'$or':[{'ListId':_0x267dfd[_0x2c89('0x30')]['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField'][_0x2c89('0x7d')](_0x2dbd95)[_0x2c89('0x28')](function(_0x2b4c32){for(var _0x2af0fd=0x0;_0x2af0fd<_0x2b4c32[_0x2c89('0x34')];_0x2af0fd++){var _0x308940=_0x2c89('0x7e')+_0x2b4c32[_0x2af0fd]['id'];_0x209a02[_0x308940]['columnName']=_0x308940;_0x209a02[_0x308940][_0x2c89('0x7c')]=_0x2b4c32[_0x2af0fd][_0x2c89('0x7f')];_0x209a02[_0x308940]['custom']={'type':_0x2b4c32[_0x2af0fd]['type'],'values':_0x2b4c32[_0x2af0fd][_0x2c89('0x80')]};}Object[_0x2c89('0x2f')](_0x209a02)[_0x2c89('0x65')](function(_0x1bb52f){if(!_0x209a02[_0x1bb52f][_0x2c89('0x35')](_0x2c89('0x7b'))){delete _0x209a02[_0x1bb52f];}});return _0x209a02;});})[_0x2c89('0x28')](respondWithResult(_0x23029f,null))[_0x2c89('0x76')](handleError(_0x23029f,null));};exports[_0x2c89('0x81')]=function(_0x2e00b2,_0x2aab15){var _0x1a6009;var _0x3a24e2;var _0x4ccce3;if(_0x2e00b2['body']['id']){delete _0x2e00b2[_0x2c89('0x82')]['id'];}return db[_0x2c89('0x2d')]['findAll']({'where':{'id':[_0x2e00b2[_0x2c89('0x82')]['to'],_0x2e00b2[_0x2c89('0x82')][_0x2c89('0x83')]]}})[_0x2c89('0x28')](function(_0x15d39d){if(_0x15d39d){if(_0x15d39d['length']!==0x2){return null;}_0x15d39d[0x0]=_0x15d39d[0x0][_0x2c89('0x84')]({'plain':!![]});_0x15d39d[0x1]=_0x15d39d[0x1][_0x2c89('0x84')]({'plain':!![]});delete _0x15d39d[0x0]['id'];delete _0x15d39d[0x1]['id'];return _[_0x2c89('0x85')](_0x15d39d[0x0],_0x15d39d[0x1],function(_0x359833,_0x48338c){if(Array[_0x2c89('0x45')](_0x48338c)&&!_0x48338c[_0x2c89('0x34')]){return _0x359833;}else if(!_0x48338c){return _0x359833;}});}})['then'](handleEntityNotFound(_0x2aab15,null))[_0x2c89('0x28')](function(_0x3b6201){if(_0x3b6201){if(_0x3b6201['tags']&&_[_0x2c89('0x45')](_0x3b6201['tags'])){_0x3b6201[_0x2c89('0x86')]=_0x3b6201[_0x2c89('0x86')]['join']();}logger[_0x2c89('0x87')](_0x2c89('0x88'),_0x2e00b2[_0x2c89('0x82')]['to'],_0x2e00b2[_0x2c89('0x82')][_0x2c89('0x83')]);return db[_0x2c89('0x89')][_0x2c89('0x29')]({'where':{'ContactId':[_0x2e00b2['body']['to'],_0x2e00b2['body'][_0x2c89('0x83')]]}})[_0x2c89('0x28')](function(_0x19d2aa){logger['info']('[CmContact][merge][destroy][CmHopper],\x20%s',_0x19d2aa);return db[_0x2c89('0x8a')][_0x2c89('0x29')]({'where':{'ContactId':[_0x2e00b2[_0x2c89('0x82')]['to'],_0x2e00b2['body']['from']]}})[_0x2c89('0x28')](function(_0x127fb4){logger[_0x2c89('0x87')]('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x127fb4);return db['CmContact']['create'](_0x3b6201);});});}})['then'](function(_0xaf7210){if(_0xaf7210){_0x1a6009=_0xaf7210;_0x3a24e2={'ContactId':_0x1a6009['id']};_0x4ccce3={'where':{'ContactId':[_0x2e00b2[_0x2c89('0x82')]['to'],_0x2e00b2[_0x2c89('0x82')][_0x2c89('0x83')]]}};return db['ChatInteraction'][_0x2c89('0x8b')](_0x3a24e2,_0x4ccce3);}})[_0x2c89('0x28')](function(){if(_0x1a6009){return db['ChatMessage'][_0x2c89('0x8b')](_0x3a24e2,_0x4ccce3);}})[_0x2c89('0x28')](function(){if(_0x1a6009){return db['ChatOfflineMessage'][_0x2c89('0x8b')](_0x3a24e2,_0x4ccce3);}})[_0x2c89('0x28')](function(){if(_0x1a6009){return db[_0x2c89('0x8c')]['update'](_0x3a24e2,_0x4ccce3);}})[_0x2c89('0x28')](function(){if(_0x1a6009){return db[_0x2c89('0x8d')][_0x2c89('0x8b')](_0x3a24e2,_0x4ccce3);}})[_0x2c89('0x28')](function(){if(_0x1a6009){return db['MailInteraction'][_0x2c89('0x8b')](_0x3a24e2,_0x4ccce3);}})[_0x2c89('0x28')](function(){if(_0x1a6009){return db['MailMessage'][_0x2c89('0x8b')](_0x3a24e2,_0x4ccce3);}})['then'](function(){if(_0x1a6009){return db[_0x2c89('0x8e')][_0x2c89('0x8b')](_0x3a24e2,_0x4ccce3);}})[_0x2c89('0x28')](function(){if(_0x1a6009){return db['SmsMessage'][_0x2c89('0x8b')](_0x3a24e2,_0x4ccce3);}})['then'](function(){if(_0x1a6009){return db[_0x2c89('0x8f')][_0x2c89('0x8b')](_0x3a24e2,_0x4ccce3);}})['then'](function(){if(_0x1a6009){return db[_0x2c89('0x90')][_0x2c89('0x8b')](_0x3a24e2,_0x4ccce3);}})[_0x2c89('0x28')](function(){if(_0x1a6009){return db[_0x2c89('0x91')]['update'](_0x3a24e2,_0x4ccce3);}})['then'](function(){if(_0x1a6009){return db['OpenchannelMessage'][_0x2c89('0x8b')](_0x3a24e2,_0x4ccce3);}})['then'](function(){if(_0x1a6009){return db['CmHopperFinal'][_0x2c89('0x8b')](_0x3a24e2,_0x4ccce3);}})[_0x2c89('0x28')](function(){if(_0x1a6009){return db[_0x2c89('0x92')][_0x2c89('0x8b')](_0x3a24e2,_0x4ccce3);}})['then'](function(){if(_0x1a6009){return db[_0x2c89('0x93')][_0x2c89('0x8b')](_0x3a24e2,_0x4ccce3);}})[_0x2c89('0x28')](function(){if(_0x1a6009){return db[_0x2c89('0x94')][_0x2c89('0x8b')](_0x3a24e2,_0x4ccce3);}})[_0x2c89('0x28')](function(){if(_0x1a6009){return db[_0x2c89('0x95')][_0x2c89('0x8b')](_0x3a24e2,_0x4ccce3);}})[_0x2c89('0x28')](function(){if(_0x1a6009){return db[_0x2c89('0x96')]['update'](_0x3a24e2,_0x4ccce3);}})['then'](function(){if(_0x1a6009){return db[_0x2c89('0x97')][_0x2c89('0x8b')](_0x3a24e2,_0x4ccce3);}})[_0x2c89('0x28')](function(){if(_0x1a6009){return db[_0x2c89('0x98')][_0x2c89('0x8b')](_0x3a24e2,_0x4ccce3);}})['then'](function(){if(_0x1a6009){return db['SmsQueueReport'][_0x2c89('0x8b')](_0x3a24e2,_0x4ccce3);}})[_0x2c89('0x28')](function(){if(_0x1a6009){return db[_0x2c89('0x99')][_0x2c89('0x8b')](_0x3a24e2,_0x4ccce3);}})[_0x2c89('0x28')](function(){if(_0x1a6009){return db[_0x2c89('0x2d')][_0x2c89('0x29')]({'where':{'id':[_0x2e00b2[_0x2c89('0x82')]['to'],_0x2e00b2[_0x2c89('0x82')][_0x2c89('0x83')]]}});}})['then'](function(){if(_0x1a6009){return _0x1a6009;}})[_0x2c89('0x28')](respondWithResult(_0x2aab15,null))[_0x2c89('0x76')](handleError(_0x2aab15,null));};exports[_0x2c89('0x9a')]=function(_0xe39a65,_0x1dbc22){return db[_0x2c89('0x2d')][_0x2c89('0x79')]()[_0x2c89('0x28')](function(_0x2954e9){if(_0xe39a65['body'][_0x2c89('0x86')]&&_['isArray'](_0xe39a65['body'][_0x2c89('0x86')])){if(_0xe39a65['body']['tags']['length']){_0xe39a65[_0x2c89('0x82')][_0x2c89('0x86')]=_0xe39a65['body'][_0x2c89('0x86')][_0x2c89('0x9b')](';')+';';}else{_0xe39a65['body'][_0x2c89('0x86')]=null;}}else{_0xe39a65['body'][_0x2c89('0x86')]=null;}return db['CmContact']['create'](_0xe39a65[_0x2c89('0x82')],{'fields':_[_0x2c89('0x2f')](_0x2954e9),'raw':!![]});})[_0x2c89('0x28')](respondWithResult(_0x1dbc22,0xc9))[_0x2c89('0x76')](handleError(_0x1dbc22,null));};exports[_0x2c89('0x9c')]=function(_0x1c970a,_0x3bc238){var _0x589d52=[];var _0x2c8bef=0x0;var _0x5825f7=0x0;var _0x23424a=0x0;return db['CmContact'][_0x2c89('0x79')]()[_0x2c89('0x28')](function(_0x31b86c){return BPromise['each'](_0x1c970a[_0x2c89('0x82')],function(_0x1362f5){var _0x39cb3c={'where':{'$or':[]},'defaults':_0x1362f5,'fields':_[_0x2c89('0x2f')](_0x31b86c),'raw':!![]};if(_0x1362f5[_0x2c89('0x9d')]){for(var _0x508575=0x0;_0x508575<_0x1362f5[_0x2c89('0x9d')][_0x2c89('0x34')];_0x508575++){var _0x1c23f7={};_0x1c23f7[_0x1362f5[_0x2c89('0x9d')][_0x508575]]=_0x1362f5[_0x1362f5['duplicates'][_0x508575]];_0x39cb3c[_0x2c89('0x3f')][_0x2c89('0x9e')]['push'](_0x1c23f7);}_0x39cb3c[_0x2c89('0x3f')]['ListId']=_0x1362f5[_0x2c89('0x9f')];}return db[_0x2c89('0x2d')][_0x2c89('0xa0')](_0x39cb3c)['spread'](function(_0xa1cde4,_0x1ba819){if(_0x1ba819){_0x2c8bef++;}else{_0x23424a++;}})[_0x2c89('0x76')](function(_0x1656d7){console[_0x2c89('0xa1')](_0x1656d7);_0x5825f7++;});});})[_0x2c89('0x28')](function(_0x3a481e){if(_0x3a481e){return{'success':_0x2c8bef,'failure':_0x5825f7,'duplicates':_0x23424a};}})[_0x2c89('0x28')](respondWithResult(_0x3bc238,0xc9))['catch'](handleError(_0x3bc238,null));};exports[_0x2c89('0xa2')]=function(_0x4d5863,_0xbdfb78,_0x15bcf7){var _0x24313b;return db[_0x2c89('0x2d')][_0x2c89('0x79')]()['then'](function(_0x226e91){return db[_0x2c89('0x2d')][_0x2c89('0x77')]({'where':{'id':_0x4d5863[_0x2c89('0x78')]['id']},'include':[{'model':db[_0x2c89('0xa3')],'as':_0x2c89('0x72'),'attributes':['id',_0x2c89('0x2b'),_0x2c89('0x3c')],'required':_0x4d5863['query'][_0x2c89('0x64')]?!![]:![]}],'attributes':_[_0x2c89('0x2f')](_0x226e91)});})[_0x2c89('0x28')](function(_0x63f7f8){_0x24313b=_0x63f7f8['get']({'plain':!![]});var _0x33ccaa={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x63f7f8&&_0x63f7f8['ListId']){if(_0x63f7f8[_0x2c89('0x9f')]){_0x33ccaa[_0x2c89('0x3f')][_0x2c89('0xa4')][_0x2c89('0x74')]({'ListId':{'$ne':_0x63f7f8[_0x2c89('0x9f')]}});}}return db[_0x2c89('0xa5')][_0x2c89('0x7d')](_0x33ccaa);})['then'](function(_0x2b76fe){return _[_0x2c89('0xa6')](_0x24313b,_['map'](_0x2b76fe,function(_0x33b37d){return util[_0x2c89('0xa7')](_0x2c89('0xa8'),_0x33b37d['id']);}));})[_0x2c89('0x28')](handleEntityNotFound(_0xbdfb78,null))[_0x2c89('0x28')](respondWithResult(_0xbdfb78,null))[_0x2c89('0x76')](handleError(_0xbdfb78,null));};exports[_0x2c89('0x8b')]=function(_0x5ca7aa,_0x18c7b5){var _0x10e15c;if(_0x5ca7aa[_0x2c89('0x82')]['id']){delete _0x5ca7aa[_0x2c89('0x82')]['id'];}return db[_0x2c89('0x2d')]['find']({'where':{'id':_0x5ca7aa[_0x2c89('0x78')]['id']}})[_0x2c89('0x28')](handleEntityNotFound(_0x18c7b5,null))['then'](saveUpdates(_0x5ca7aa[_0x2c89('0x82')],null))['then'](function(_0x4d0470){_0x10e15c=_0x4d0470;var _0x9bcc09={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x4d0470&&_0x4d0470['ListId']){if(_0x4d0470[_0x2c89('0x9f')]){_0x9bcc09[_0x2c89('0x3f')][_0x2c89('0xa4')][_0x2c89('0x74')]({'ListId':{'$ne':_0x4d0470[_0x2c89('0x9f')]}});}}return db[_0x2c89('0xa5')][_0x2c89('0x7d')](_0x9bcc09);})[_0x2c89('0x28')](function(_0xab88d7){if(_0xab88d7){return _[_0x2c89('0xa6')](_[_0x2c89('0xa9')](_0x5ca7aa['body'],function(_0x22f9b8,_0x489265){return _[_0x2c89('0x7a')](_0x489265,_0x2c89('0x7e'));}),_[_0x2c89('0xaa')](_0xab88d7,function(_0x5a09d2){return util[_0x2c89('0xa7')](_0x2c89('0xa8'),_0x5a09d2['id']);}));}})[_0x2c89('0x28')](function(_0x564c0a){if(_0x564c0a&&!_[_0x2c89('0x4e')](_0x564c0a)){var _0x2d4ce1=squel[_0x2c89('0x8b')]()[_0x2c89('0xab')](_0x2c89('0x3e'))[_0x2c89('0xac')](_0x564c0a)[_0x2c89('0x3f')](_0x2c89('0xad'),_0x5ca7aa[_0x2c89('0x78')]['id'])[_0x2c89('0xae')]();return db['sequelize'][_0x2c89('0x30')](_0x2d4ce1[_0x2c89('0xaf')],{'replacements':_0x2d4ce1[_0x2c89('0x80')]});}})[_0x2c89('0x28')](function(){if(_0x5ca7aa[_0x2c89('0x82')][_0x2c89('0xb0')]&&_0x10e15c){return db[_0x2c89('0x89')][_0x2c89('0x8b')]({'phone':_0x5ca7aa[_0x2c89('0x82')]['phone']},{'where':{'ContactId':_0x10e15c['id']}});}})[_0x2c89('0x28')](function(){return _0x10e15c;})[_0x2c89('0x28')](respondWithResult(_0x18c7b5,null))[_0x2c89('0x76')](handleError(_0x18c7b5,null));};exports[_0x2c89('0xb1')]=function(_0x5c6d27,_0x6f2959,_0x28db83){var _0x13997e={};var _0x232848={};var _0x348f6a;var _0x27a186;return db[_0x2c89('0x2d')][_0x2c89('0xb2')]({'where':{'id':_0x5c6d27['params']['id']}})[_0x2c89('0x28')](handleEntityNotFound(_0x6f2959,null))[_0x2c89('0x28')](function(_0x599b92){if(_0x599b92){_0x348f6a=_0x599b92;_0x232848[_0x2c89('0x2e')]=_[_0x2c89('0x2f')](db[_0x2c89('0xa3')][_0x2c89('0xb3')]);_0x232848[_0x2c89('0x30')]=_[_0x2c89('0x2f')](_0x5c6d27[_0x2c89('0x30')]);_0x232848['filters']=_['intersection'](_0x232848['model'],_0x232848[_0x2c89('0x30')]);_0x13997e[_0x2c89('0x33')]=_[_0x2c89('0x32')](_0x232848[_0x2c89('0x2e')],qs[_0x2c89('0xb4')](_0x5c6d27[_0x2c89('0x30')][_0x2c89('0xb4')]));_0x13997e['attributes']=_0x13997e[_0x2c89('0x33')][_0x2c89('0x34')]?_0x13997e[_0x2c89('0x33')]:_0x232848[_0x2c89('0x2e')];_0x13997e[_0x2c89('0x37')]=qs[_0x2c89('0x38')](_0x5c6d27['query'][_0x2c89('0x38')]);_0x13997e[_0x2c89('0x3f')]=qs[_0x2c89('0x31')](_[_0x2c89('0x39')](_0x5c6d27[_0x2c89('0x30')],_0x232848[_0x2c89('0x31')]));if(_0x5c6d27[_0x2c89('0x30')]['filter']){_0x13997e[_0x2c89('0x3f')]=_[_0x2c89('0x81')](_0x13997e[_0x2c89('0x3f')],{'$or':_[_0x2c89('0xaa')](_0x13997e[_0x2c89('0x33')],function(_0x40b645){var _0x57ab92={};_0x57ab92[_0x40b645]={'$like':'%'+_0x5c6d27['query'][_0x2c89('0x4c')]+'%'};return _0x57ab92;})});}_0x13997e=_[_0x2c89('0x81')]({},_0x13997e,_0x5c6d27[_0x2c89('0xb5')]);return _0x348f6a[_0x2c89('0xb1')](_0x13997e);}})['then'](function(_0x40145f){if(_0x40145f){_0x27a186=_0x40145f[_0x2c89('0x34')];if(!_0x5c6d27[_0x2c89('0x30')]['hasOwnProperty'](_0x2c89('0x36'))){_0x13997e[_0x2c89('0x22')]=qs[_0x2c89('0x22')](_0x5c6d27[_0x2c89('0x30')][_0x2c89('0x22')]);_0x13997e['offset']=qs[_0x2c89('0x21')](_0x5c6d27[_0x2c89('0x30')]['offset']);}return _0x348f6a['getTags'](_0x13997e);}})[_0x2c89('0x28')](function(_0x227e31){if(_0x227e31){return _0x227e31?{'count':_0x27a186,'rows':_0x227e31}:null;}})[_0x2c89('0x28')](respondWithResult(_0x6f2959,null))[_0x2c89('0x76')](handleError(_0x6f2959,null));};exports[_0x2c89('0xb6')]=function(_0x49f5aa,_0x1e152f,_0x3b1969){if(_0x49f5aa[_0x2c89('0x82')]['id']){delete _0x49f5aa['body']['id'];}return db[_0x2c89('0x2d')]['findOne']({'where':{'id':_0x49f5aa[_0x2c89('0x78')]['id']}})[_0x2c89('0x28')](handleEntityNotFound(_0x1e152f,null))[_0x2c89('0x28')](function(_0x18eb4a){if(_0x18eb4a){return _0x18eb4a[_0x2c89('0xb6')](_0x49f5aa['body'][_0x2c89('0xb7')]||[]);}return null;})[_0x2c89('0x28')](respondWithResult(_0x1e152f,null))[_0x2c89('0x76')](handleError(_0x1e152f,null));};exports['getHoppers']=function(_0x5baa0a,_0xfc1def,_0x366ffe){var _0x5a88d3={'raw':![],'where':{}};var _0x5ad7f1={};var _0x197f96={'count':0x0,'rows':[]};return db[_0x2c89('0x2d')]['findOne']({'where':{'id':_0x5baa0a[_0x2c89('0x78')]['id']}})[_0x2c89('0x28')](handleEntityNotFound(_0xfc1def,null))['then'](function(_0x2576af){if(_0x2576af){_0x5ad7f1[_0x2c89('0x2e')]=_[_0x2c89('0x2f')](db['CmHopper'][_0x2c89('0xb3')]);_0x5ad7f1[_0x2c89('0x30')]=_[_0x2c89('0x2f')](_0x5baa0a['query']);_0x5ad7f1[_0x2c89('0x31')]=_['intersection'](_0x5ad7f1[_0x2c89('0x2e')],_0x5ad7f1['query']);_0x5a88d3[_0x2c89('0x33')]=_['intersection'](_0x5ad7f1[_0x2c89('0x2e')],qs[_0x2c89('0xb4')](_0x5baa0a[_0x2c89('0x30')]['fields']));_0x5a88d3[_0x2c89('0x33')]=_0x5a88d3[_0x2c89('0x33')][_0x2c89('0x34')]?_0x5a88d3[_0x2c89('0x33')]:_0x5ad7f1[_0x2c89('0x2e')];if(!_0x5baa0a[_0x2c89('0x30')][_0x2c89('0x35')]('nolimit')){_0x5a88d3['limit']=qs[_0x2c89('0x22')](_0x5baa0a[_0x2c89('0x30')][_0x2c89('0x22')]);_0x5a88d3[_0x2c89('0x21')]=qs[_0x2c89('0x21')](_0x5baa0a[_0x2c89('0x30')]['offset']);}_0x5a88d3['order']=qs[_0x2c89('0x38')](_0x5baa0a[_0x2c89('0x30')][_0x2c89('0x38')]);_0x5a88d3[_0x2c89('0x3f')]=qs['filters'](_[_0x2c89('0x39')](_0x5baa0a['query'],_0x5ad7f1[_0x2c89('0x31')]));_0x5a88d3[_0x2c89('0x3f')][_0x2c89('0xb8')]=_0x2576af['id'];if(_0x5baa0a[_0x2c89('0x30')][_0x2c89('0x4c')]){_0x5a88d3['where']=_[_0x2c89('0x81')](_0x5a88d3[_0x2c89('0x3f')],{'$or':_['map'](_0x5a88d3[_0x2c89('0x33')],function(_0xdcdb78){var _0x15218a={};_0x15218a[_0xdcdb78]={'$like':'%'+_0x5baa0a[_0x2c89('0x30')][_0x2c89('0x4c')]+'%'};return _0x15218a;})});}_0x5a88d3=_[_0x2c89('0x81')]({},_0x5a88d3,_0x5baa0a[_0x2c89('0xb5')]);return db['CmHopper'][_0x2c89('0x20')]({'where':_0x5a88d3[_0x2c89('0x3f')]})[_0x2c89('0x28')](function(_0x215594){_0x197f96[_0x2c89('0x20')]=_0x215594;if(_0x5baa0a[_0x2c89('0x30')][_0x2c89('0xb9')]){_0x5a88d3[_0x2c89('0xba')]=[{'all':!![]}];}return db[_0x2c89('0x89')][_0x2c89('0x7d')](_0x5a88d3);})[_0x2c89('0x28')](function(_0x150f03){_0x197f96[_0x2c89('0x75')]=_0x150f03;return _0x197f96;});}})[_0x2c89('0x28')](respondWithFilteredResult(_0xfc1def,_0x5a88d3))[_0x2c89('0x76')](handleError(_0xfc1def,null));};exports[_0x2c89('0xbb')]=function(_0x216c8a,_0x479a94,_0x1e20aa){var _0xeff0f9={'raw':!![],'where':{}};var _0x5a4926={};var _0x52e010={'count':0x0,'rows':[]};return db['CmContact'][_0x2c89('0xb2')]({'where':{'id':_0x216c8a[_0x2c89('0x78')]['id']}})[_0x2c89('0x28')](handleEntityNotFound(_0x479a94,null))['then'](function(_0x3fad79){if(_0x3fad79){_0x5a4926[_0x2c89('0x2e')]=_['keys'](db[_0x2c89('0x92')][_0x2c89('0xb3')]);_0x5a4926['query']=_[_0x2c89('0x2f')](_0x216c8a[_0x2c89('0x30')]);_0x5a4926[_0x2c89('0x31')]=_[_0x2c89('0x32')](_0x5a4926[_0x2c89('0x2e')],_0x5a4926[_0x2c89('0x30')]);_0xeff0f9['attributes']=_[_0x2c89('0x32')](_0x5a4926[_0x2c89('0x2e')],qs['fields'](_0x216c8a[_0x2c89('0x30')]['fields']));_0xeff0f9[_0x2c89('0x33')]=_0xeff0f9[_0x2c89('0x33')][_0x2c89('0x34')]?_0xeff0f9['attributes']:_0x5a4926[_0x2c89('0x2e')];if(!_0x216c8a['query'][_0x2c89('0x35')]('nolimit')){_0xeff0f9[_0x2c89('0x22')]=qs[_0x2c89('0x22')](_0x216c8a['query'][_0x2c89('0x22')]);_0xeff0f9['offset']=qs[_0x2c89('0x21')](_0x216c8a[_0x2c89('0x30')][_0x2c89('0x21')]);}_0xeff0f9['order']=qs['sort'](_0x216c8a[_0x2c89('0x30')][_0x2c89('0x38')]);_0xeff0f9['where']=qs[_0x2c89('0x31')](_[_0x2c89('0x39')](_0x216c8a[_0x2c89('0x30')],_0x5a4926['filters']));_0xeff0f9[_0x2c89('0x3f')][_0x2c89('0xb8')]=_0x3fad79['id'];if(_0x216c8a[_0x2c89('0x30')][_0x2c89('0x4c')]){_0xeff0f9[_0x2c89('0x3f')]=_[_0x2c89('0x81')](_0xeff0f9[_0x2c89('0x3f')],{'$or':_[_0x2c89('0xaa')](_0xeff0f9[_0x2c89('0x33')],function(_0x1f1f33){var _0x31d80a={};_0x31d80a[_0x1f1f33]={'$like':'%'+_0x216c8a[_0x2c89('0x30')][_0x2c89('0x4c')]+'%'};return _0x31d80a;})});}_0xeff0f9=_[_0x2c89('0x81')]({},_0xeff0f9,_0x216c8a[_0x2c89('0xb5')]);return db['CmHopperHistory']['count']({'where':_0xeff0f9[_0x2c89('0x3f')]})[_0x2c89('0x28')](function(_0x5ddf2d){_0x52e010[_0x2c89('0x20')]=_0x5ddf2d;if(_0x216c8a[_0x2c89('0x30')]['includeAll']){_0xeff0f9[_0x2c89('0xba')]=[{'all':!![]}];}return db['CmHopperHistory'][_0x2c89('0x7d')](_0xeff0f9);})['then'](function(_0x392574){_0x52e010[_0x2c89('0x75')]=_0x392574;return _0x52e010;});}})[_0x2c89('0x28')](respondWithFilteredResult(_0x479a94,_0xeff0f9))[_0x2c89('0x76')](handleError(_0x479a94,null));};exports[_0x2c89('0xbc')]=function(_0x4890ec,_0x211964,_0x3bbb8d){var _0x59162f={'raw':!![],'where':{}};var _0x3480e4={};var _0x585984={'count':0x0,'rows':[]};return db['CmContact'][_0x2c89('0xb2')]({'where':{'id':_0x4890ec['params']['id']}})['then'](handleEntityNotFound(_0x211964,null))['then'](function(_0x587afc){if(_0x587afc){_0x3480e4[_0x2c89('0x2e')]=_[_0x2c89('0x2f')](db[_0x2c89('0xbd')][_0x2c89('0xb3')]);_0x3480e4[_0x2c89('0x30')]=_[_0x2c89('0x2f')](_0x4890ec[_0x2c89('0x30')]);_0x3480e4['filters']=_[_0x2c89('0x32')](_0x3480e4[_0x2c89('0x2e')],_0x3480e4[_0x2c89('0x30')]);_0x59162f[_0x2c89('0x33')]=_[_0x2c89('0x32')](_0x3480e4[_0x2c89('0x2e')],qs[_0x2c89('0xb4')](_0x4890ec[_0x2c89('0x30')][_0x2c89('0xb4')]));_0x59162f[_0x2c89('0x33')]=_0x59162f[_0x2c89('0x33')]['length']?_0x59162f['attributes']:_0x3480e4[_0x2c89('0x2e')];if(!_0x4890ec[_0x2c89('0x30')][_0x2c89('0x35')]('nolimit')){_0x59162f['limit']=qs['limit'](_0x4890ec[_0x2c89('0x30')]['limit']);_0x59162f[_0x2c89('0x21')]=qs[_0x2c89('0x21')](_0x4890ec['query'][_0x2c89('0x21')]);}_0x59162f[_0x2c89('0x37')]=qs[_0x2c89('0x38')](_0x4890ec['query']['sort']);_0x59162f['where']=qs[_0x2c89('0x31')](_[_0x2c89('0x39')](_0x4890ec[_0x2c89('0x30')],_0x3480e4['filters']));_0x59162f[_0x2c89('0x3f')][_0x2c89('0xb8')]=_0x587afc['id'];if(_0x4890ec[_0x2c89('0x30')][_0x2c89('0x4c')]){_0x59162f['where']=_[_0x2c89('0x81')](_0x59162f[_0x2c89('0x3f')],{'$or':_[_0x2c89('0xaa')](_0x59162f[_0x2c89('0x33')],function(_0xa38643){var _0x544f64={};_0x544f64[_0xa38643]={'$like':'%'+_0x4890ec[_0x2c89('0x30')][_0x2c89('0x4c')]+'%'};return _0x544f64;})});}_0x59162f=_[_0x2c89('0x81')]({},_0x59162f,_0x4890ec[_0x2c89('0xb5')]);return db[_0x2c89('0xbd')][_0x2c89('0x20')]({'where':_0x59162f[_0x2c89('0x3f')]})[_0x2c89('0x28')](function(_0x5ad23b){_0x585984[_0x2c89('0x20')]=_0x5ad23b;if(_0x4890ec[_0x2c89('0x30')][_0x2c89('0xb9')]){_0x59162f[_0x2c89('0xba')]=[{'all':!![]}];}return db['CmHopperFinal']['findAll'](_0x59162f);})[_0x2c89('0x28')](function(_0x476958){_0x585984[_0x2c89('0x75')]=_0x476958;return _0x585984;});}})['then'](respondWithFilteredResult(_0x211964,_0x59162f))[_0x2c89('0x76')](handleError(_0x211964,null));};exports['getJscriptySessions']=function(_0xa9fb02,_0x10d404,_0x5386cd){var _0x14491e={'raw':!![],'where':{}};var _0x2315bd={};var _0x2a5628={'count':0x0,'rows':[]};return db['CmContact'][_0x2c89('0xb2')]({'where':{'id':_0xa9fb02[_0x2c89('0x78')]['id']}})[_0x2c89('0x28')](handleEntityNotFound(_0x10d404,null))[_0x2c89('0x28')](function(_0x21f1f9){if(_0x21f1f9){_0x2315bd[_0x2c89('0x2e')]=_[_0x2c89('0x2f')](db['JscriptySessionReport'][_0x2c89('0xb3')]);_0x2315bd[_0x2c89('0x30')]=_[_0x2c89('0x2f')](_0xa9fb02[_0x2c89('0x30')]);_0x2315bd['filters']=_[_0x2c89('0x32')](_0x2315bd[_0x2c89('0x2e')],_0x2315bd[_0x2c89('0x30')]);_0x14491e[_0x2c89('0x33')]=_[_0x2c89('0x32')](_0x2315bd[_0x2c89('0x2e')],qs['fields'](_0xa9fb02[_0x2c89('0x30')][_0x2c89('0xb4')]));_0x14491e[_0x2c89('0x33')]=_0x14491e[_0x2c89('0x33')][_0x2c89('0x34')]?_0x14491e['attributes']:_0x2315bd[_0x2c89('0x2e')];if(!_0xa9fb02['query'][_0x2c89('0x35')]('nolimit')){_0x14491e[_0x2c89('0x22')]=qs['limit'](_0xa9fb02['query'][_0x2c89('0x22')]);_0x14491e['offset']=qs[_0x2c89('0x21')](_0xa9fb02['query']['offset']);}_0x14491e['order']=qs[_0x2c89('0x38')](_0xa9fb02['query'][_0x2c89('0x38')]);_0x14491e[_0x2c89('0x3f')]=qs['filters'](_[_0x2c89('0x39')](_0xa9fb02['query'],_0x2315bd[_0x2c89('0x31')]));_0x14491e[_0x2c89('0x3f')][_0x2c89('0xb8')]=_0x21f1f9['id'];if(_0xa9fb02[_0x2c89('0x30')][_0x2c89('0x4c')]){_0x14491e[_0x2c89('0x3f')]=_[_0x2c89('0x81')](_0x14491e[_0x2c89('0x3f')],{'$or':_['map'](_0x14491e[_0x2c89('0x33')],function(_0x383a31){var _0x1a04a5={};_0x1a04a5[_0x383a31]={'$like':'%'+_0xa9fb02['query'][_0x2c89('0x4c')]+'%'};return _0x1a04a5;})});}_0x14491e=_['merge']({},_0x14491e,_0xa9fb02[_0x2c89('0xb5')]);return db[_0x2c89('0x99')]['count']({'where':_0x14491e[_0x2c89('0x3f')]})[_0x2c89('0x28')](function(_0x5ab8a2){_0x2a5628[_0x2c89('0x20')]=_0x5ab8a2;if(_0xa9fb02[_0x2c89('0x30')]['includeAll']){_0x14491e[_0x2c89('0xba')]=[{'all':!![]}];}return db[_0x2c89('0x99')][_0x2c89('0x7d')](_0x14491e);})[_0x2c89('0x28')](function(_0x294aaa){_0x2a5628[_0x2c89('0x75')]=_0x294aaa;return _0x2a5628;});}})['then'](respondWithFilteredResult(_0x10d404,_0x14491e))['catch'](handleError(_0x10d404,null));};exports[_0x2c89('0xbe')]=function(_0x1a4c27,_0x3bbf04,_0x523d73){try{if(!_0x1a4c27[_0x2c89('0x82')][_0x2c89('0x9f')]){throw new Error(_0x2c89('0xbf'));}if(!_0x1a4c27[_0x2c89('0x82')][_0x2c89('0xc0')]){throw new Error(_0x2c89('0xc1'));}if(!_0x1a4c27['body']['binding_values']){throw new Error(_0x2c89('0xc2'));}if(!_0x1a4c27[_0x2c89('0x82')][_0x2c89('0xc3')]){throw new Error(_0x2c89('0xc4'));}var _0x229040=_0x1a4c27['body']['binding_keys'][_0x2c89('0x73')](',');var _0x2b634f=_0x1a4c27[_0x2c89('0x82')][_0x2c89('0xc5')][_0x2c89('0x73')](',');if(!_0x229040[_0x2c89('0x34')]||!_0x2b634f['length']||_0x229040[_0x2c89('0x34')]!==_0x2b634f[_0x2c89('0x34')]){throw new Error(_0x2c89('0xc6'));}_0x1a4c27['body'][_0x2c89('0xb4')]=_[_0x2c89('0xc7')](_0x229040,_0x2b634f);if(!_0x1a4c27['body'][_0x2c89('0xb4')][_0x2c89('0xb0')]){throw new Error(_0x2c89('0xc8'));}if(!_0x1a4c27[_0x2c89('0x82')]['fields'][_0x2c89('0xc9')]){throw new Error('No\x20firstName\x20column\x20specified');}var _0x5419ec=path['join'](config[_0x2c89('0xca')],_0x2c89('0xcb'),_0x1a4c27[_0x2c89('0xcc')]['filename']);fs[_0x2c89('0xcd')](_0x5419ec,parseInt(_0x2c89('0xce'),0x8));var _0x167401=require(_0x2c89('0xcf'))[_0x2c89('0xd0')](path[_0x2c89('0x9b')](__dirname,_0x2c89('0xd1')),[_0x5419ec,_0x1a4c27[_0x2c89('0x82')][_0x2c89('0xc0')],_0x1a4c27['body']['binding_values'],_0x1a4c27[_0x2c89('0x82')]['ListId'],_0x1a4c27[_0x2c89('0x82')][_0x2c89('0xd2')],_0x1a4c27[_0x2c89('0x82')][_0x2c89('0x9d')],_0x1a4c27[_0x2c89('0x82')][_0x2c89('0xc3')]]);return _0x3bbf04[_0x2c89('0x23')](0xc8)[_0x2c89('0x1f')]({'message':'File\x20uploaded\x20correctly!','pid':_0x167401[_0x2c89('0xd3')]});}catch(_0x2920c8){return _0x3bbf04['status'](0x1f4)[_0x2c89('0xd4')](_0x2920c8);}};exports[_0x2c89('0xd5')]=function(_0x27b698,_0xa183f4,_0x3cda7f){var _0x41ef23=fs['createReadStream'](_0x27b698[_0x2c89('0xcc')][_0x2c89('0x8')]);Papa[_0x2c89('0x43')](_0x41ef23,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x2a8623){return _0xa183f4[_0x2c89('0x23')](0xc8)['json']({'file':_0x27b698[_0x2c89('0xcc')],'fields':_0x2a8623[_0x2c89('0xd6')]['fields']});}});};exports[_0x2c89('0xd7')]=function(_0x557d2f,_0x5cefb5,_0x4776a9){return db['User'][_0x2c89('0x7d')]({'raw':!![],'attributes':['id'],'where':{'role':_0x2c89('0xd8')}})[_0x2c89('0x28')](function(_0x54517a){var _0x71d6e4=![];if(!_0x557d2f[_0x2c89('0x82')][_0x2c89('0x9f')]){throw new Error(_0x2c89('0xbf'));}if(!_0x557d2f[_0x2c89('0x82')][_0x2c89('0xd9')][_0x2c89('0xb0')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x557d2f[_0x2c89('0x82')][_0x2c89('0xd9')][_0x2c89('0xc9')]){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x557d2f[_0x2c89('0x82')][_0x2c89('0xc3')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0xbb25fe=require(_0x2c89('0xcf'))[_0x2c89('0xd0')](path[_0x2c89('0x9b')](__dirname,_0x2c89('0xda')),[_0x557d2f[_0x2c89('0x78')]['id'],JSON[_0x2c89('0xdb')](_0x557d2f[_0x2c89('0x82')]),JSON[_0x2c89('0xdb')](_0x54517a)]);_0xbb25fe['on'](_0x2c89('0xdc'),function(_0x3dbeaf){_0x71d6e4=!![];return _0x5cefb5[_0x2c89('0x23')](0xc8)[_0x2c89('0x1f')]({'message':'start\x20child\x20process\x20correctly!','pid':_0xbb25fe[_0x2c89('0xd3')]});});_0xbb25fe['on'](_0x2c89('0xdd'),function(_0x405bc9){if(_0x405bc9&&!_0x71d6e4){return _0x5cefb5[_0x2c89('0x23')](0x1f4)['json']({'message':'error\x20child\x20process','pid':_0xbb25fe['pid']});}});})[_0x2c89('0x76')](handleError(_0x5cefb5,null));};
git://repos.xcallymotion.com / motion2.git / blob