18 var _0x8ef5=['MailMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','JscriptySessionReport','create','bulkCreate','each','duplicates','findOrCreate','spread','show','params','$and','omit','format','cf_%d','pickBy','table','id\x20=\x20?','toParam','phone','pick','options','getTags','setTags','ids','getHoppers','rawAttributes','includeAll','include','getHopperHistories','ContactId','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','No\x20phone\x20column\x20specified','firstName','root','file','filename','chmodSync','0777','child_process','fork','../../components/import/cm/csv','binding_values','File\x20uploaded\x20correctly!','pid','send','createReadStream','parse','meta','agent','binding','No\x20firstName\x20column\x20specified','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','error\x20child\x20process','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','sox','to-csv','ejs','crypto','jsforce','desk.js','querystring','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/utils','../../config/environment','../../mysqldb','defaults','localhost','socket.io-emitter','redis','./cmContact.socket','register','sendStatus','status','json','count','offset','limit','set','apply','reject','save','update','then','destroy','end','error','stack','name','index','CmContact','describe','keys','startsWith','push','CmCustomField','findOne','trimStart','cf_','fieldType','type','model','query','filters','intersection','fields','attributes','length','nolimit','order','sort','where','select','field','color','from','tools_tags','cm_contacts','left_join','cm_user_has_contacts','uc.CmContactId\x20=\x20c.id','cm_contact_has_tags','ct.CmContactId\x20=\x20c.id','t.id\x20=\x20ct.TagId','c.deletedAt\x20IS\x20NULL','expr','search','sqlOperator','conditions','find','Tag','value','split','map','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','and','uc.UserId\x20=\x20?','dateOfBirth','DATE','buildExpression','text','hasOwnProperty','filter','isNil','Contact','isEmpty','ListId','c.ListId\x20IN\x20?','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','isArray','tag','replace','getFullTextValue','isNumeric','c.id\x20LIKE\x20?','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','group','c.id','QueryTypes','SELECT','clone','DESC','t.id\x20IN\x20?','resolve','some','User','c.ListId\x20IS\x20NULL','toString','sequelize','merge','c.firstName','c.lastName','c.mobile','c.fax','c.email','c.deletedAt','TagIds','Tags','rows','catch','columnName','findAll','displayName','alias','values','body','get','mergeWith','tags','join','info','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','ChatInteraction','ChatMessage'];(function(_0x23e093,_0x381500){var _0x18d7d7=function(_0x2c9d11){while(--_0x2c9d11){_0x23e093['push'](_0x23e093['shift']());}};_0x18d7d7(++_0x381500);}(_0x8ef5,0x137));var _0x58ef=function(_0x3d6a1d,_0x4d4b08){_0x3d6a1d=_0x3d6a1d-0x0;var _0x55ca05=_0x8ef5[_0x3d6a1d];return _0x55ca05;};'use strict';var pdf=require(_0x58ef('0x0'));var emlformat=require(_0x58ef('0x1'));var rimraf=require(_0x58ef('0x2'));var zipdir=require(_0x58ef('0x3'));var jsonpatch=require(_0x58ef('0x4'));var rp=require(_0x58ef('0x5'));var moment=require(_0x58ef('0x6'));var BPromise=require(_0x58ef('0x7'));var Mustache=require('mustache');var util=require(_0x58ef('0x8'));var path=require(_0x58ef('0x9'));var sox=require(_0x58ef('0xa'));var csv=require(_0x58ef('0xb'));var ejs=require(_0x58ef('0xc'));var fs=require('fs');var _=require('lodash');var squel=require('squel');var crypto=require(_0x58ef('0xd'));var jsforce=require(_0x58ef('0xe'));var deskjs=require(_0x58ef('0xf'));var toCsv=require(_0x58ef('0xb'));var querystring=require(_0x58ef('0x10'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x58ef('0x11'));var qs=require(_0x58ef('0x12'));var as=require(_0x58ef('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')('api');var utils=require(_0x58ef('0x14'));var config=require(_0x58ef('0x15'));var db=require(_0x58ef('0x16'))['db'];config['redis']=_[_0x58ef('0x17')](config['redis'],{'host':_0x58ef('0x18'),'port':0x18eb});var socket=require(_0x58ef('0x19'))(new Redis(config[_0x58ef('0x1a')]));require(_0x58ef('0x1b'))[_0x58ef('0x1c')](socket);function respondWithStatusCode(_0x29fce4,_0x34fb50){_0x34fb50=_0x34fb50||0xcc;return function(_0xd93bb3){if(_0xd93bb3){return _0x29fce4[_0x58ef('0x1d')](_0x34fb50);}return _0x29fce4['status'](_0x34fb50)['end']();};}function respondWithResult(_0x21d6c9,_0x4b88fb){_0x4b88fb=_0x4b88fb||0xc8;return function(_0x4620cd){if(_0x4620cd){return _0x21d6c9[_0x58ef('0x1e')](_0x4b88fb)[_0x58ef('0x1f')](_0x4620cd);}};}function respondWithFilteredResult(_0x58360a,_0x20f538){return function(_0x563222){if(_0x563222){var _0x1278d5=_0x563222[_0x58ef('0x20')],_0x2df822=_0x20f538[_0x58ef('0x21')],_0x205f4f=_0x20f538['offset']+_0x20f538[_0x58ef('0x22')],_0x2923ee;if(_0x205f4f>=_0x1278d5){_0x205f4f=_0x1278d5;_0x2923ee=0xc8;}else{_0x2923ee=0xce;}_0x58360a[_0x58ef('0x1e')](_0x2923ee);return _0x58360a[_0x58ef('0x23')]('Content-Range',_0x2df822+'-'+_0x205f4f+'/'+_0x1278d5)[_0x58ef('0x1f')](_0x563222);}return null;};}function patchUpdates(_0x20fd49){return function(_0x55c40f){try{jsonpatch[_0x58ef('0x24')](_0x55c40f,_0x20fd49,!![]);}catch(_0x3dca3d){return BPromise[_0x58ef('0x25')](_0x3dca3d);}return _0x55c40f[_0x58ef('0x26')]();};}function saveUpdates(_0x83ec8a,_0x53176f){return function(_0x446149){if(_0x446149){return _0x446149[_0x58ef('0x27')](_0x83ec8a)[_0x58ef('0x28')](function(_0x2ccc73){return _0x2ccc73;});}return null;};}function removeEntity(_0x290119,_0xce4bb3){return function(_0x338b08){if(_0x338b08){return _0x338b08[_0x58ef('0x29')]()[_0x58ef('0x28')](function(){_0x290119[_0x58ef('0x1e')](0xcc)[_0x58ef('0x2a')]();});}};}function handleEntityNotFound(_0x35743c,_0x110742){return function(_0xaf0d2f){if(!_0xaf0d2f){_0x35743c[_0x58ef('0x1d')](0x194);}return _0xaf0d2f;};}function handleError(_0xbf3ce1,_0x225932){_0x225932=_0x225932||0x1f4;return function(_0xcdd320){logger[_0x58ef('0x2b')](_0xcdd320[_0x58ef('0x2c')]);if(_0xcdd320[_0x58ef('0x2d')]){delete _0xcdd320['name'];}_0xbf3ce1[_0x58ef('0x1e')](_0x225932)['send'](_0xcdd320);};}exports[_0x58ef('0x2e')]=function(_0x5a62d9,_0x199b78){var _0x178dd0={},_0x22ada0={},_0x195406={'count':0x0,'rows':[]};return db[_0x58ef('0x2f')][_0x58ef('0x30')]()[_0x58ef('0x28')](function(_0x456a77){var _0x43f955=[];for(var _0x53b154=0x0;_0x53b154<Object[_0x58ef('0x31')](_0x456a77)['length'];_0x53b154++){var _0x205134=Object[_0x58ef('0x31')](_0x456a77)[_0x53b154];if(_[_0x58ef('0x32')](_0x205134,'cf_')){_0x43f955[_0x58ef('0x33')](db[_0x58ef('0x34')][_0x58ef('0x35')]({'where':{'id':_[_0x58ef('0x36')](_0x205134,'cf_')},'raw':!![]}));}}return BPromise['all'](_0x43f955)[_0x58ef('0x28')](function(_0x140b14){for(var _0x104e26=0x0;_0x104e26<_0x140b14['length'];_0x104e26++){if(_0x140b14[_0x104e26]){var _0x386a43=_0x58ef('0x37')+_0x140b14[_0x104e26]['id'];var _0x38c68b=_0x456a77[_0x386a43];_0x38c68b[_0x58ef('0x38')]=_0x140b14[_0x104e26][_0x58ef('0x39')];}}return _0x456a77;});})[_0x58ef('0x28')](function(_0x55a353){_0x22ada0[_0x58ef('0x3a')]=_['keys'](_0x55a353);_0x22ada0['query']=_[_0x58ef('0x31')](_0x5a62d9[_0x58ef('0x3b')]);_0x22ada0[_0x58ef('0x3c')]=_[_0x58ef('0x3d')](_0x22ada0[_0x58ef('0x3a')],_0x22ada0[_0x58ef('0x3b')]);_0x178dd0['attributes']=_[_0x58ef('0x3d')](_0x22ada0[_0x58ef('0x3a')],qs[_0x58ef('0x3e')](_0x5a62d9[_0x58ef('0x3b')][_0x58ef('0x3e')]));_0x178dd0[_0x58ef('0x3f')]=_0x178dd0[_0x58ef('0x3f')][_0x58ef('0x40')]?_0x178dd0[_0x58ef('0x3f')]:_0x22ada0[_0x58ef('0x3a')];if(!_0x5a62d9[_0x58ef('0x3b')]['hasOwnProperty'](_0x58ef('0x41'))){_0x178dd0[_0x58ef('0x22')]=qs['limit'](_0x5a62d9['query'][_0x58ef('0x22')]);_0x178dd0[_0x58ef('0x21')]=qs['offset'](_0x5a62d9[_0x58ef('0x3b')][_0x58ef('0x21')]);}_0x178dd0[_0x58ef('0x42')]=qs['sort'](_0x5a62d9[_0x58ef('0x3b')][_0x58ef('0x43')]);_0x178dd0[_0x58ef('0x44')]=qs[_0x58ef('0x3c')](_['pick'](_0x5a62d9[_0x58ef('0x3b')],_0x22ada0[_0x58ef('0x3c')]));var _0x1a234c=[];var _0x5d8236=squel[_0x58ef('0x45')]()['field']('id')[_0x58ef('0x46')](_0x58ef('0x2d'))[_0x58ef('0x46')](_0x58ef('0x47'))[_0x58ef('0x48')](_0x58ef('0x49'));var _0x174b8c=squel[_0x58ef('0x45')]()[_0x58ef('0x48')](_0x58ef('0x4a'),'c')[_0x58ef('0x4b')](_0x58ef('0x4c'),'uc',_0x58ef('0x4d'))[_0x58ef('0x4b')](_0x58ef('0x4e'),'ct',_0x58ef('0x4f'))[_0x58ef('0x4b')](_0x58ef('0x49'),'t',_0x58ef('0x50'))[_0x58ef('0x44')](_0x58ef('0x51'));var _0x25c46c=squel[_0x58ef('0x52')]();var _0x22314f=[];var _0x52ce9c=squel['expr']();var _0x1c33af;if(_0x5a62d9['query']['search']){_0x1c33af=as['parseSearch'](_0x5a62d9[_0x58ef('0x3b')][_0x58ef('0x53')]);var _0x36b4ad=_0x1c33af[_0x58ef('0x54')];for(var _0x545cc1=0x0;_0x545cc1<_0x1c33af['conditions'][_0x58ef('0x40')];_0x545cc1++){var _0xf19094=_0x1c33af[_0x58ef('0x55')][_0x545cc1];var _0x378037='c';var _0x37900c=_(_0x55a353)[_0x58ef('0x31')]()[_0x58ef('0x56')](function(_0x20aa6b){return _0x20aa6b===_0xf19094[_0x58ef('0x46')];});if(_0x37900c)_0x37900c=_0x55a353[_0xf19094[_0x58ef('0x46')]];if(!_0x37900c){if(_0xf19094[_0x58ef('0x46')]===_0x58ef('0x57')){var _0x57c32c=_0xf19094[_0x58ef('0x58')][_0x58ef('0x59')](',')[_0x58ef('0x5a')](function(_0x592c23){return Number(_0x592c23);});_0x57c32c[_0x58ef('0x5b')](function(_0x5dcd2b){_0x52ce9c['or'](_0x58ef('0x5c'),'%,'+_0x5dcd2b+',%');});_0x22314f=_['union'](_0x22314f,_0x57c32c);}else if(_0xf19094[_0x58ef('0x46')]==='User'){_0x25c46c[_0x58ef('0x5d')](_0x58ef('0x5e'),_0xf19094[_0x58ef('0x58')]);}}else{if(_0xf19094[_0x58ef('0x46')]===_0x58ef('0x5f')||_0x37900c[_0x58ef('0x38')]==='datetime')_0xf19094['castTo']=_0x58ef('0x60');var _0x2d11d8=as[_0x58ef('0x61')](_0x378037,_0x37900c['type'],_0xf19094);_0x25c46c[_0x36b4ad](_0x2d11d8[_0x58ef('0x62')],_0x2d11d8[_0x58ef('0x58')]['start'],_0x2d11d8[_0x58ef('0x58')][_0x58ef('0x2a')]);}}}else{var _0x43959b=_(Object[_0x58ef('0x31')](_0x5a62d9[_0x58ef('0x3b')]))[_0x58ef('0x5a')](function(_0x2004b8){return _0x55a353[_0x58ef('0x63')](_0x2004b8)?_0x2004b8:undefined;})[_0x58ef('0x64')](function(_0x1fab49){return!_[_0x58ef('0x65')](_0x1fab49);})[_0x58ef('0x58')]();if(_0x5a62d9['query'][_0x58ef('0x66')])_0x43959b[_0x58ef('0x33')](_0x58ef('0x66'));if(!_[_0x58ef('0x67')](_0x43959b)){_0x43959b[_0x58ef('0x5b')](function(_0xb2fe71){if(_0xb2fe71===_0x58ef('0x68')){_0x174b8c['where'](_0x58ef('0x69'),[][_0x58ef('0x6a')](_0x5a62d9[_0x58ef('0x3b')][_0xb2fe71]));}else if(_0xb2fe71===_0x58ef('0x66')){var _0x3b12e2='%'+_0x5a62d9['query'][_0xb2fe71]+'%';_0x174b8c[_0x58ef('0x44')](_0x58ef('0x6b'),_0x3b12e2);}else{_0x174b8c[_0x58ef('0x44')]('c.'+_0xb2fe71+_0x58ef('0x6c'),_0x5a62d9['query'][_0xb2fe71]);}});}if(_0x5a62d9['query']['tag']){_0x22314f=_[_0x58ef('0x6d')](_0x5a62d9[_0x58ef('0x3b')][_0x58ef('0x6e')])?_0x5a62d9['query'][_0x58ef('0x6e')]:new Array(_0x5a62d9[_0x58ef('0x3b')][_0x58ef('0x6e')]);_0x22314f[_0x58ef('0x5b')](function(_0xf51f45){_0x52ce9c['or'](_0x58ef('0x5c'),'%,'+_0xf51f45+',%');});}if(_0x5a62d9['query'][_0x58ef('0x64')]){var _0x47d649=_0x5a62d9[_0x58ef('0x3b')][_0x58ef('0x64')][_0x58ef('0x6f')]('\x5c','\x5c\x5c')[_0x58ef('0x6f')]('\x27\x27','\x27\x27\x27\x27');if(_0x47d649[_0x58ef('0x59')]('\x20')['length']>0x1){_0x25c46c['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x58ef('0x70')](_0x47d649),null);}else{if(qs[_0x58ef('0x71')](_0x47d649)){_0x25c46c['or'](_0x58ef('0x72'),_0x47d649+'%');_0x25c46c['or'](_0x58ef('0x73'),_0x47d649+'%');_0x25c46c['or'](_0x58ef('0x74'),_0x47d649+'%');_0x25c46c['or']('c.fax\x20LIKE\x20?',_0x47d649+'%');}else if(qs[_0x58ef('0x75')](_0x47d649)){_0x25c46c['or'](_0x58ef('0x76'),_0x47d649+'%');}else{_0x25c46c['or'](_0x58ef('0x77'),'%'+_0x47d649+'%');_0x25c46c['or'](_0x58ef('0x78'),'%'+_0x47d649+'%');_0x25c46c['or']('c.email\x20LIKE\x20?','%'+_0x47d649+'%');}}}}_0x174b8c[_0x58ef('0x44')](_0x25c46c);_0x174b8c[_0x58ef('0x79')](_0x58ef('0x7a'));var _0x396da5={'type':db['Sequelize'][_0x58ef('0x7b')][_0x58ef('0x7c')],'raw':!![]};var _0x47e202=_0x174b8c[_0x58ef('0x7d')]()[_0x58ef('0x46')](_0x58ef('0x7a'));if(_0x178dd0['order']){_0x178dd0['order']['forEach'](function(_0x4c08aa){_0x174b8c[_0x58ef('0x42')]('c.'+_0x4c08aa[0x0],_0x4c08aa[0x1]===_0x58ef('0x7e')?![]:!![]);});}if(!_['isEmpty'](_0x22314f)){_0x174b8c['having'](_0x52ce9c);_0x47e202['where'](_0x58ef('0x7f'),_0x22314f);}BPromise[_0x58ef('0x80')]()[_0x58ef('0x28')](function(){if(_0x1c33af&&!_[_0x58ef('0x81')](_0x1c33af['conditions'],[_0x58ef('0x46'),_0x58ef('0x82')])){return _0x5a62d9['user']['getLists']({'attributes':['id'],'raw':!![]})[_0x58ef('0x28')](function(_0xd7273d){if(_[_0x58ef('0x67')](_0xd7273d)){_0x47e202['where']('c.ListId\x20IS\x20NULL');_0x174b8c[_0x58ef('0x44')](_0x58ef('0x83'));}else{_0x47e202[_0x58ef('0x44')](_0x58ef('0x69'),_[_0x58ef('0x5a')](_0xd7273d,'id'));_0x174b8c[_0x58ef('0x44')](_0x58ef('0x69'),_[_0x58ef('0x5a')](_0xd7273d,'id'));}});}else{return;}})[_0x58ef('0x28')](function(){db['sequelize'][_0x58ef('0x3b')](_0x47e202[_0x58ef('0x84')](),_0x396da5)[_0x58ef('0x28')](function(_0x1776ee){_0x195406[_0x58ef('0x20')]=_0x1776ee[_0x58ef('0x40')];if(_0x195406[_0x58ef('0x20')]===0x0)return[];return db[_0x58ef('0x85')][_0x58ef('0x3b')](_0x5d8236['toString'](),_0x396da5);})[_0x58ef('0x28')](function(_0x579bd0){_0x1a234c=_['keyBy'](_0x579bd0,'id');_0x396da5=_[_0x58ef('0x86')](_0x396da5,{'model':db[_0x58ef('0x2f')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x5a62d9[_0x58ef('0x3b')]['fields']){_0x178dd0[_0x58ef('0x3f')]['forEach'](function(_0x424ca0){_0x174b8c['field']('c.'+_0x424ca0);});}else{_0x174b8c[_0x58ef('0x46')](_0x58ef('0x7a'));_0x174b8c[_0x58ef('0x46')](_0x58ef('0x87'));_0x174b8c[_0x58ef('0x46')](_0x58ef('0x88'));_0x174b8c[_0x58ef('0x46')]('c.phone');_0x174b8c['field'](_0x58ef('0x89'));_0x174b8c['field'](_0x58ef('0x8a'));_0x174b8c['field'](_0x58ef('0x8b'));_0x174b8c[_0x58ef('0x46')]('c.ListId');_0x174b8c[_0x58ef('0x46')](_0x58ef('0x8c'));_0x174b8c[_0x58ef('0x46')]('GROUP_CONCAT(DISTINCT\x20t.id)',_0x58ef('0x8d'));}if(_0x178dd0[_0x58ef('0x22')])_0x174b8c[_0x58ef('0x22')](_0x178dd0['limit']);if(_0x178dd0['offset'])_0x174b8c[_0x58ef('0x21')](_0x178dd0[_0x58ef('0x21')]);return db[_0x58ef('0x85')][_0x58ef('0x3b')](_0x174b8c['toString'](),_0x396da5);})[_0x58ef('0x28')](function(_0x2bd11d){_0x2bd11d[_0x58ef('0x5b')](function(_0x53a208){if(_0x53a208[_0x58ef('0x8d')]){_0x53a208['Tags']=[];_0x53a208[_0x58ef('0x8d')][_0x58ef('0x59')](',')[_0x58ef('0x5b')](function(_0x17f998){_0x53a208[_0x58ef('0x8e')]['push'](_0x1a234c[_0x17f998]);});}delete _0x53a208[_0x58ef('0x8d')];});_0x195406[_0x58ef('0x8f')]=_0x2bd11d;return _0x195406;})[_0x58ef('0x28')](respondWithFilteredResult(_0x199b78,_0x178dd0));});})[_0x58ef('0x90')](handleError(_0x199b78,null));};exports['destroy']=function(_0xfa935c,_0x46ca88){return db[_0x58ef('0x2f')][_0x58ef('0x56')]({'where':{'id':_0xfa935c['params']['id']}})['then'](handleEntityNotFound(_0x46ca88,null))[_0x58ef('0x28')](removeEntity(_0x46ca88,null))[_0x58ef('0x90')](handleError(_0x46ca88,null));};exports[_0x58ef('0x30')]=function(_0x4061dd,_0x2e2b1e){return db[_0x58ef('0x2f')]['describe']()[_0x58ef('0x28')](function(_0x1ad543){delete _0x1ad543['tags'];for(var _0x3a2263=0x0;_0x3a2263<Object['keys'](_0x1ad543)[_0x58ef('0x40')];_0x3a2263++){var _0x5d0879=Object[_0x58ef('0x31')](_0x1ad543)[_0x3a2263];if(!_['startsWith'](_0x5d0879,_0x58ef('0x37'))){_0x1ad543[_0x5d0879][_0x58ef('0x91')]=_0x5d0879;_0x1ad543[_0x5d0879]['displayName']=_0x5d0879;}}return _0x1ad543;})[_0x58ef('0x28')](function(_0x512ed5){var _0x1e029d={'where':{'$or':[{'ListId':_0x4061dd['query']['id']},{'ListId':null}]},'raw':!![]};return db[_0x58ef('0x34')][_0x58ef('0x92')](_0x1e029d)[_0x58ef('0x28')](function(_0x58c713){for(var _0x227505=0x0;_0x227505<_0x58c713['length'];_0x227505++){var _0x5349ef='cf_'+_0x58c713[_0x227505]['id'];_0x512ed5[_0x5349ef]['columnName']=_0x5349ef;_0x512ed5[_0x5349ef][_0x58ef('0x93')]=_0x58c713[_0x227505][_0x58ef('0x94')];_0x512ed5[_0x5349ef]['custom']={'type':_0x58c713[_0x227505][_0x58ef('0x39')],'values':_0x58c713[_0x227505][_0x58ef('0x95')]};}Object['keys'](_0x512ed5)[_0x58ef('0x5b')](function(_0x2eb9dd){if(!_0x512ed5[_0x2eb9dd][_0x58ef('0x63')]('columnName')){delete _0x512ed5[_0x2eb9dd];}});return _0x512ed5;});})[_0x58ef('0x28')](respondWithResult(_0x2e2b1e,null))[_0x58ef('0x90')](handleError(_0x2e2b1e,null));};exports['merge']=function(_0x458f2d,_0xe2f0ba){var _0x235b4c;var _0xf985c7;var _0x5a03de;if(_0x458f2d[_0x58ef('0x96')]['id']){delete _0x458f2d['body']['id'];}return db['CmContact'][_0x58ef('0x92')]({'where':{'id':[_0x458f2d['body']['to'],_0x458f2d['body'][_0x58ef('0x48')]]}})[_0x58ef('0x28')](function(_0x566b65){if(_0x566b65){if(_0x566b65[_0x58ef('0x40')]!==0x2){return null;}_0x566b65[0x0]=_0x566b65[0x0][_0x58ef('0x97')]({'plain':!![]});_0x566b65[0x1]=_0x566b65[0x1][_0x58ef('0x97')]({'plain':!![]});delete _0x566b65[0x0]['id'];delete _0x566b65[0x1]['id'];return _[_0x58ef('0x98')](_0x566b65[0x0],_0x566b65[0x1],function(_0x144e3b,_0x54e5af){if(Array['isArray'](_0x54e5af)&&!_0x54e5af['length']){return _0x144e3b;}else if(!_0x54e5af){return _0x144e3b;}});}})[_0x58ef('0x28')](handleEntityNotFound(_0xe2f0ba,null))['then'](function(_0x38ca88){if(_0x38ca88){if(_0x38ca88[_0x58ef('0x99')]&&_[_0x58ef('0x6d')](_0x38ca88[_0x58ef('0x99')])){_0x38ca88[_0x58ef('0x99')]=_0x38ca88[_0x58ef('0x99')][_0x58ef('0x9a')]();}logger[_0x58ef('0x9b')]('[CmContact][merge]\x20to\x20%s\x20from\x20%s',_0x458f2d['body']['to'],_0x458f2d[_0x58ef('0x96')][_0x58ef('0x48')]);return db[_0x58ef('0x9c')][_0x58ef('0x29')]({'where':{'ContactId':[_0x458f2d[_0x58ef('0x96')]['to'],_0x458f2d[_0x58ef('0x96')][_0x58ef('0x48')]]}})[_0x58ef('0x28')](function(_0x41522d){logger[_0x58ef('0x9b')](_0x58ef('0x9d'),_0x41522d);return db[_0x58ef('0x9e')]['destroy']({'where':{'ContactId':[_0x458f2d[_0x58ef('0x96')]['to'],_0x458f2d['body'][_0x58ef('0x48')]]}})[_0x58ef('0x28')](function(_0x5f4087){logger[_0x58ef('0x9b')]('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x5f4087);return db[_0x58ef('0x2f')]['create'](_0x38ca88);});});}})['then'](function(_0x59a42e){if(_0x59a42e){_0x235b4c=_0x59a42e;_0xf985c7={'ContactId':_0x235b4c['id']};_0x5a03de={'where':{'ContactId':[_0x458f2d['body']['to'],_0x458f2d[_0x58ef('0x96')]['from']]}};return db[_0x58ef('0x9f')][_0x58ef('0x27')](_0xf985c7,_0x5a03de);}})[_0x58ef('0x28')](function(){if(_0x235b4c){return db[_0x58ef('0xa0')][_0x58ef('0x27')](_0xf985c7,_0x5a03de);}})[_0x58ef('0x28')](function(){if(_0x235b4c){return db['ChatOfflineMessage'][_0x58ef('0x27')](_0xf985c7,_0x5a03de);}})['then'](function(){if(_0x235b4c){return db['MailInteraction']['update'](_0xf985c7,_0x5a03de);}})[_0x58ef('0x28')](function(){if(_0x235b4c){return db['MailMessage'][_0x58ef('0x27')](_0xf985c7,_0x5a03de);}})[_0x58ef('0x28')](function(){if(_0x235b4c){return db['MailInteraction'][_0x58ef('0x27')](_0xf985c7,_0x5a03de);}})[_0x58ef('0x28')](function(){if(_0x235b4c){return db[_0x58ef('0xa1')][_0x58ef('0x27')](_0xf985c7,_0x5a03de);}})['then'](function(){if(_0x235b4c){return db['SmsInteraction'][_0x58ef('0x27')](_0xf985c7,_0x5a03de);}})[_0x58ef('0x28')](function(){if(_0x235b4c){return db['SmsMessage']['update'](_0xf985c7,_0x5a03de);}})['then'](function(){if(_0x235b4c){return db[_0x58ef('0xa2')][_0x58ef('0x27')](_0xf985c7,_0x5a03de);}})[_0x58ef('0x28')](function(){if(_0x235b4c){return db[_0x58ef('0xa3')][_0x58ef('0x27')](_0xf985c7,_0x5a03de);}})[_0x58ef('0x28')](function(){if(_0x235b4c){return db[_0x58ef('0xa4')][_0x58ef('0x27')](_0xf985c7,_0x5a03de);}})['then'](function(){if(_0x235b4c){return db[_0x58ef('0xa5')]['update'](_0xf985c7,_0x5a03de);}})['then'](function(){if(_0x235b4c){return db['CmHopperFinal'][_0x58ef('0x27')](_0xf985c7,_0x5a03de);}})['then'](function(){if(_0x235b4c){return db[_0x58ef('0xa6')][_0x58ef('0x27')](_0xf985c7,_0x5a03de);}})['then'](function(){if(_0x235b4c){return db[_0x58ef('0xa7')][_0x58ef('0x27')](_0xf985c7,_0x5a03de);}})[_0x58ef('0x28')](function(){if(_0x235b4c){return db[_0x58ef('0xa8')][_0x58ef('0x27')](_0xf985c7,_0x5a03de);}})[_0x58ef('0x28')](function(){if(_0x235b4c){return db[_0x58ef('0xa9')][_0x58ef('0x27')](_0xf985c7,_0x5a03de);}})[_0x58ef('0x28')](function(){if(_0x235b4c){return db[_0x58ef('0xaa')][_0x58ef('0x27')](_0xf985c7,_0x5a03de);}})[_0x58ef('0x28')](function(){if(_0x235b4c){return db[_0x58ef('0xab')]['update'](_0xf985c7,_0x5a03de);}})[_0x58ef('0x28')](function(){if(_0x235b4c){return db[_0x58ef('0xac')]['update'](_0xf985c7,_0x5a03de);}})[_0x58ef('0x28')](function(){if(_0x235b4c){return db['SmsQueueReport'][_0x58ef('0x27')](_0xf985c7,_0x5a03de);}})[_0x58ef('0x28')](function(){if(_0x235b4c){return db[_0x58ef('0xad')][_0x58ef('0x27')](_0xf985c7,_0x5a03de);}})['then'](function(){if(_0x235b4c){return db[_0x58ef('0x2f')][_0x58ef('0x29')]({'where':{'id':[_0x458f2d[_0x58ef('0x96')]['to'],_0x458f2d[_0x58ef('0x96')]['from']]}});}})[_0x58ef('0x28')](function(){if(_0x235b4c){return _0x235b4c;}})['then'](respondWithResult(_0xe2f0ba,null))[_0x58ef('0x90')](handleError(_0xe2f0ba,null));};exports[_0x58ef('0xae')]=function(_0xcd841b,_0x3688fa){return db[_0x58ef('0x2f')]['describe']()[_0x58ef('0x28')](function(_0x1cf187){if(_0xcd841b[_0x58ef('0x96')][_0x58ef('0x99')]&&_[_0x58ef('0x6d')](_0xcd841b[_0x58ef('0x96')][_0x58ef('0x99')])){if(_0xcd841b[_0x58ef('0x96')][_0x58ef('0x99')]['length']){_0xcd841b[_0x58ef('0x96')][_0x58ef('0x99')]=_0xcd841b[_0x58ef('0x96')][_0x58ef('0x99')][_0x58ef('0x9a')](';')+';';}else{_0xcd841b['body'][_0x58ef('0x99')]=null;}}else{_0xcd841b['body']['tags']=null;}return db[_0x58ef('0x2f')]['create'](_0xcd841b['body'],{'fields':_[_0x58ef('0x31')](_0x1cf187),'raw':!![]});})[_0x58ef('0x28')](respondWithResult(_0x3688fa,0xc9))[_0x58ef('0x90')](handleError(_0x3688fa,null));};exports[_0x58ef('0xaf')]=function(_0x461820,_0x1aad7e){var _0x4b1ace=[];var _0x564893=0x0;var _0x12af60=0x0;var _0x5c86ac=0x0;return db['CmContact'][_0x58ef('0x30')]()[_0x58ef('0x28')](function(_0x1e53fb){return BPromise[_0x58ef('0xb0')](_0x461820[_0x58ef('0x96')],function(_0x163c97){var _0x5699d9={'where':{'$or':[]},'defaults':_0x163c97,'fields':_[_0x58ef('0x31')](_0x1e53fb),'raw':!![]};if(_0x163c97['duplicates']){for(var _0x2fd7bb=0x0;_0x2fd7bb<_0x163c97[_0x58ef('0xb1')][_0x58ef('0x40')];_0x2fd7bb++){var _0xc769a9={};_0xc769a9[_0x163c97[_0x58ef('0xb1')][_0x2fd7bb]]=_0x163c97[_0x163c97[_0x58ef('0xb1')][_0x2fd7bb]];_0x5699d9['where']['$or'][_0x58ef('0x33')](_0xc769a9);}_0x5699d9[_0x58ef('0x44')][_0x58ef('0x68')]=_0x163c97[_0x58ef('0x68')];}return db[_0x58ef('0x2f')][_0x58ef('0xb2')](_0x5699d9)[_0x58ef('0xb3')](function(_0x2ac411,_0x39c401){if(_0x39c401){_0x564893++;}else{_0x5c86ac++;}})[_0x58ef('0x90')](function(_0x2e4f79){console[_0x58ef('0x2b')](_0x2e4f79);_0x12af60++;});});})['then'](function(_0x141ef7){if(_0x141ef7){return{'success':_0x564893,'failure':_0x12af60,'duplicates':_0x5c86ac};}})['then'](respondWithResult(_0x1aad7e,0xc9))[_0x58ef('0x90')](handleError(_0x1aad7e,null));};exports[_0x58ef('0xb4')]=function(_0x474490,_0x1b9a59,_0x52fb87){var _0x303ef2;return db['CmContact'][_0x58ef('0x30')]()[_0x58ef('0x28')](function(_0xdbd0c){return db[_0x58ef('0x2f')][_0x58ef('0x56')]({'where':{'id':_0x474490[_0x58ef('0xb5')]['id']},'include':[{'model':db['Tag'],'as':_0x58ef('0x8e'),'attributes':['id',_0x58ef('0x2d'),_0x58ef('0x47')],'required':_0x474490['query']['tag']?!![]:![]}],'attributes':_['keys'](_0xdbd0c)});})[_0x58ef('0x28')](function(_0x57e325){_0x303ef2=_0x57e325[_0x58ef('0x97')]({'plain':!![]});var _0x1abb6b={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x57e325&&_0x57e325['ListId']){if(_0x57e325[_0x58ef('0x68')]){_0x1abb6b[_0x58ef('0x44')][_0x58ef('0xb6')]['push']({'ListId':{'$ne':_0x57e325[_0x58ef('0x68')]}});}}return db['CmCustomField'][_0x58ef('0x92')](_0x1abb6b);})[_0x58ef('0x28')](function(_0x23ef39){return _[_0x58ef('0xb7')](_0x303ef2,_[_0x58ef('0x5a')](_0x23ef39,function(_0x17549e){return util[_0x58ef('0xb8')](_0x58ef('0xb9'),_0x17549e['id']);}));})['then'](handleEntityNotFound(_0x1b9a59,null))['then'](respondWithResult(_0x1b9a59,null))[_0x58ef('0x90')](handleError(_0x1b9a59,null));};exports[_0x58ef('0x27')]=function(_0x923679,_0x58028f){var _0x4f4786;if(_0x923679[_0x58ef('0x96')]['id']){delete _0x923679[_0x58ef('0x96')]['id'];}return db[_0x58ef('0x2f')][_0x58ef('0x56')]({'where':{'id':_0x923679[_0x58ef('0xb5')]['id']}})[_0x58ef('0x28')](handleEntityNotFound(_0x58028f,null))[_0x58ef('0x28')](saveUpdates(_0x923679[_0x58ef('0x96')],null))[_0x58ef('0x28')](function(_0x1cecfa){_0x4f4786=_0x1cecfa;var _0x55894f={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x1cecfa&&_0x1cecfa[_0x58ef('0x68')]){if(_0x1cecfa[_0x58ef('0x68')]){_0x55894f[_0x58ef('0x44')][_0x58ef('0xb6')][_0x58ef('0x33')]({'ListId':{'$ne':_0x1cecfa[_0x58ef('0x68')]}});}}return db[_0x58ef('0x34')][_0x58ef('0x92')](_0x55894f);})[_0x58ef('0x28')](function(_0x19c3e1){if(_0x19c3e1){return _[_0x58ef('0xb7')](_[_0x58ef('0xba')](_0x923679[_0x58ef('0x96')],function(_0x14005b,_0x32fc51){return _['startsWith'](_0x32fc51,_0x58ef('0x37'));}),_[_0x58ef('0x5a')](_0x19c3e1,function(_0x1b00c7){return util['format'](_0x58ef('0xb9'),_0x1b00c7['id']);}));}})[_0x58ef('0x28')](function(_0x32b6f4){if(_0x32b6f4&&!_['isEmpty'](_0x32b6f4)){var _0x17e789=squel[_0x58ef('0x27')]()[_0x58ef('0xbb')](_0x58ef('0x4a'))['setFields'](_0x32b6f4)[_0x58ef('0x44')](_0x58ef('0xbc'),_0x923679[_0x58ef('0xb5')]['id'])[_0x58ef('0xbd')]();return db[_0x58ef('0x85')][_0x58ef('0x3b')](_0x17e789[_0x58ef('0x62')],{'replacements':_0x17e789[_0x58ef('0x95')]});}})[_0x58ef('0x28')](function(){if(_0x923679['body'][_0x58ef('0xbe')]&&_0x4f4786){return db[_0x58ef('0x9c')][_0x58ef('0x27')]({'phone':_0x923679['body']['phone']},{'where':{'ContactId':_0x4f4786['id']}});}})[_0x58ef('0x28')](function(){return _0x4f4786;})['then'](respondWithResult(_0x58028f,null))[_0x58ef('0x90')](handleError(_0x58028f,null));};exports['getTags']=function(_0x33f8be,_0x399316,_0x1afcab){var _0x2523e7={};var _0x376189={};var _0x47d829;var _0x260b7f;return db[_0x58ef('0x2f')][_0x58ef('0x35')]({'where':{'id':_0x33f8be[_0x58ef('0xb5')]['id']}})[_0x58ef('0x28')](handleEntityNotFound(_0x399316,null))[_0x58ef('0x28')](function(_0x1556ef){if(_0x1556ef){_0x47d829=_0x1556ef;_0x376189[_0x58ef('0x3a')]=_[_0x58ef('0x31')](db[_0x58ef('0x57')]['rawAttributes']);_0x376189[_0x58ef('0x3b')]=_['keys'](_0x33f8be['query']);_0x376189['filters']=_[_0x58ef('0x3d')](_0x376189[_0x58ef('0x3a')],_0x376189['query']);_0x2523e7[_0x58ef('0x3f')]=_['intersection'](_0x376189['model'],qs['fields'](_0x33f8be['query'][_0x58ef('0x3e')]));_0x2523e7[_0x58ef('0x3f')]=_0x2523e7[_0x58ef('0x3f')]['length']?_0x2523e7[_0x58ef('0x3f')]:_0x376189['model'];_0x2523e7['order']=qs[_0x58ef('0x43')](_0x33f8be['query']['sort']);_0x2523e7[_0x58ef('0x44')]=qs['filters'](_[_0x58ef('0xbf')](_0x33f8be['query'],_0x376189[_0x58ef('0x3c')]));if(_0x33f8be[_0x58ef('0x3b')][_0x58ef('0x64')]){_0x2523e7[_0x58ef('0x44')]=_['merge'](_0x2523e7[_0x58ef('0x44')],{'$or':_['map'](_0x2523e7[_0x58ef('0x3f')],function(_0x427b17){var _0x2ab13b={};_0x2ab13b[_0x427b17]={'$like':'%'+_0x33f8be[_0x58ef('0x3b')][_0x58ef('0x64')]+'%'};return _0x2ab13b;})});}_0x2523e7=_[_0x58ef('0x86')]({},_0x2523e7,_0x33f8be[_0x58ef('0xc0')]);return _0x47d829[_0x58ef('0xc1')](_0x2523e7);}})[_0x58ef('0x28')](function(_0x36e108){if(_0x36e108){_0x260b7f=_0x36e108['length'];if(!_0x33f8be[_0x58ef('0x3b')][_0x58ef('0x63')](_0x58ef('0x41'))){_0x2523e7['limit']=qs[_0x58ef('0x22')](_0x33f8be[_0x58ef('0x3b')][_0x58ef('0x22')]);_0x2523e7['offset']=qs['offset'](_0x33f8be['query'][_0x58ef('0x21')]);}return _0x47d829[_0x58ef('0xc1')](_0x2523e7);}})[_0x58ef('0x28')](function(_0x510471){if(_0x510471){return _0x510471?{'count':_0x260b7f,'rows':_0x510471}:null;}})[_0x58ef('0x28')](respondWithResult(_0x399316,null))[_0x58ef('0x90')](handleError(_0x399316,null));};exports[_0x58ef('0xc2')]=function(_0x291fa0,_0x2f25b9,_0x56f587){if(_0x291fa0[_0x58ef('0x96')]['id']){delete _0x291fa0[_0x58ef('0x96')]['id'];}return db[_0x58ef('0x2f')][_0x58ef('0x35')]({'where':{'id':_0x291fa0[_0x58ef('0xb5')]['id']}})[_0x58ef('0x28')](handleEntityNotFound(_0x2f25b9,null))[_0x58ef('0x28')](function(_0xc87c7f){if(_0xc87c7f){return _0xc87c7f[_0x58ef('0xc2')](_0x291fa0['body'][_0x58ef('0xc3')]||[]);}return null;})[_0x58ef('0x28')](respondWithResult(_0x2f25b9,null))[_0x58ef('0x90')](handleError(_0x2f25b9,null));};exports[_0x58ef('0xc4')]=function(_0x1b70df,_0x57f805,_0x236d8b){var _0x440a51={'raw':![],'where':{}};var _0x56453a={};var _0x4f8fc6={'count':0x0,'rows':[]};return db[_0x58ef('0x2f')][_0x58ef('0x35')]({'where':{'id':_0x1b70df[_0x58ef('0xb5')]['id']}})[_0x58ef('0x28')](handleEntityNotFound(_0x57f805,null))[_0x58ef('0x28')](function(_0x35c148){if(_0x35c148){_0x56453a[_0x58ef('0x3a')]=_[_0x58ef('0x31')](db[_0x58ef('0x9c')][_0x58ef('0xc5')]);_0x56453a[_0x58ef('0x3b')]=_[_0x58ef('0x31')](_0x1b70df[_0x58ef('0x3b')]);_0x56453a[_0x58ef('0x3c')]=_[_0x58ef('0x3d')](_0x56453a[_0x58ef('0x3a')],_0x56453a['query']);_0x440a51['attributes']=_[_0x58ef('0x3d')](_0x56453a[_0x58ef('0x3a')],qs[_0x58ef('0x3e')](_0x1b70df['query'][_0x58ef('0x3e')]));_0x440a51[_0x58ef('0x3f')]=_0x440a51['attributes'][_0x58ef('0x40')]?_0x440a51[_0x58ef('0x3f')]:_0x56453a['model'];if(!_0x1b70df['query'][_0x58ef('0x63')](_0x58ef('0x41'))){_0x440a51[_0x58ef('0x22')]=qs[_0x58ef('0x22')](_0x1b70df[_0x58ef('0x3b')]['limit']);_0x440a51['offset']=qs['offset'](_0x1b70df[_0x58ef('0x3b')][_0x58ef('0x21')]);}_0x440a51[_0x58ef('0x42')]=qs[_0x58ef('0x43')](_0x1b70df['query']['sort']);_0x440a51[_0x58ef('0x44')]=qs[_0x58ef('0x3c')](_[_0x58ef('0xbf')](_0x1b70df[_0x58ef('0x3b')],_0x56453a[_0x58ef('0x3c')]));_0x440a51['where']['ContactId']=_0x35c148['id'];if(_0x1b70df[_0x58ef('0x3b')]['filter']){_0x440a51[_0x58ef('0x44')]=_[_0x58ef('0x86')](_0x440a51[_0x58ef('0x44')],{'$or':_['map'](_0x440a51['attributes'],function(_0x362301){var _0x234a86={};_0x234a86[_0x362301]={'$like':'%'+_0x1b70df[_0x58ef('0x3b')]['filter']+'%'};return _0x234a86;})});}_0x440a51=_[_0x58ef('0x86')]({},_0x440a51,_0x1b70df[_0x58ef('0xc0')]);return db[_0x58ef('0x9c')][_0x58ef('0x20')]({'where':_0x440a51[_0x58ef('0x44')]})[_0x58ef('0x28')](function(_0x41064c){_0x4f8fc6[_0x58ef('0x20')]=_0x41064c;if(_0x1b70df[_0x58ef('0x3b')][_0x58ef('0xc6')]){_0x440a51[_0x58ef('0xc7')]=[{'all':!![]}];}return db[_0x58ef('0x9c')]['findAll'](_0x440a51);})[_0x58ef('0x28')](function(_0x37cb7b){_0x4f8fc6[_0x58ef('0x8f')]=_0x37cb7b;return _0x4f8fc6;});}})[_0x58ef('0x28')](respondWithFilteredResult(_0x57f805,_0x440a51))[_0x58ef('0x90')](handleError(_0x57f805,null));};exports[_0x58ef('0xc8')]=function(_0x5b923b,_0x2f6d89,_0x3bd96f){var _0x595251={'raw':!![],'where':{}};var _0x455f2f={};var _0x401b1c={'count':0x0,'rows':[]};return db[_0x58ef('0x2f')][_0x58ef('0x35')]({'where':{'id':_0x5b923b[_0x58ef('0xb5')]['id']}})[_0x58ef('0x28')](handleEntityNotFound(_0x2f6d89,null))[_0x58ef('0x28')](function(_0xe480c2){if(_0xe480c2){_0x455f2f['model']=_['keys'](db[_0x58ef('0xa6')][_0x58ef('0xc5')]);_0x455f2f['query']=_[_0x58ef('0x31')](_0x5b923b[_0x58ef('0x3b')]);_0x455f2f['filters']=_[_0x58ef('0x3d')](_0x455f2f['model'],_0x455f2f[_0x58ef('0x3b')]);_0x595251['attributes']=_[_0x58ef('0x3d')](_0x455f2f[_0x58ef('0x3a')],qs[_0x58ef('0x3e')](_0x5b923b['query'][_0x58ef('0x3e')]));_0x595251['attributes']=_0x595251[_0x58ef('0x3f')][_0x58ef('0x40')]?_0x595251['attributes']:_0x455f2f[_0x58ef('0x3a')];if(!_0x5b923b[_0x58ef('0x3b')][_0x58ef('0x63')](_0x58ef('0x41'))){_0x595251[_0x58ef('0x22')]=qs['limit'](_0x5b923b[_0x58ef('0x3b')][_0x58ef('0x22')]);_0x595251[_0x58ef('0x21')]=qs[_0x58ef('0x21')](_0x5b923b['query'][_0x58ef('0x21')]);}_0x595251['order']=qs[_0x58ef('0x43')](_0x5b923b[_0x58ef('0x3b')]['sort']);_0x595251[_0x58ef('0x44')]=qs['filters'](_[_0x58ef('0xbf')](_0x5b923b[_0x58ef('0x3b')],_0x455f2f['filters']));_0x595251[_0x58ef('0x44')][_0x58ef('0xc9')]=_0xe480c2['id'];if(_0x5b923b[_0x58ef('0x3b')][_0x58ef('0x64')]){_0x595251[_0x58ef('0x44')]=_[_0x58ef('0x86')](_0x595251[_0x58ef('0x44')],{'$or':_[_0x58ef('0x5a')](_0x595251[_0x58ef('0x3f')],function(_0x18b4b6){var _0x45c12f={};_0x45c12f[_0x18b4b6]={'$like':'%'+_0x5b923b['query']['filter']+'%'};return _0x45c12f;})});}_0x595251=_[_0x58ef('0x86')]({},_0x595251,_0x5b923b['options']);return db[_0x58ef('0xa6')][_0x58ef('0x20')]({'where':_0x595251[_0x58ef('0x44')]})[_0x58ef('0x28')](function(_0x449e6a){_0x401b1c[_0x58ef('0x20')]=_0x449e6a;if(_0x5b923b[_0x58ef('0x3b')]['includeAll']){_0x595251[_0x58ef('0xc7')]=[{'all':!![]}];}return db['CmHopperHistory'][_0x58ef('0x92')](_0x595251);})[_0x58ef('0x28')](function(_0x537253){_0x401b1c[_0x58ef('0x8f')]=_0x537253;return _0x401b1c;});}})[_0x58ef('0x28')](respondWithFilteredResult(_0x2f6d89,_0x595251))[_0x58ef('0x90')](handleError(_0x2f6d89,null));};exports[_0x58ef('0xca')]=function(_0x358e1c,_0x146070,_0x347b6f){var _0x4befb6={'raw':!![],'where':{}};var _0x57df57={};var _0x980a2f={'count':0x0,'rows':[]};return db[_0x58ef('0x2f')][_0x58ef('0x35')]({'where':{'id':_0x358e1c['params']['id']}})[_0x58ef('0x28')](handleEntityNotFound(_0x146070,null))[_0x58ef('0x28')](function(_0x2331e4){if(_0x2331e4){_0x57df57[_0x58ef('0x3a')]=_[_0x58ef('0x31')](db['CmHopperFinal'][_0x58ef('0xc5')]);_0x57df57['query']=_[_0x58ef('0x31')](_0x358e1c[_0x58ef('0x3b')]);_0x57df57[_0x58ef('0x3c')]=_[_0x58ef('0x3d')](_0x57df57[_0x58ef('0x3a')],_0x57df57[_0x58ef('0x3b')]);_0x4befb6[_0x58ef('0x3f')]=_['intersection'](_0x57df57[_0x58ef('0x3a')],qs[_0x58ef('0x3e')](_0x358e1c[_0x58ef('0x3b')]['fields']));_0x4befb6[_0x58ef('0x3f')]=_0x4befb6[_0x58ef('0x3f')]['length']?_0x4befb6[_0x58ef('0x3f')]:_0x57df57[_0x58ef('0x3a')];if(!_0x358e1c['query']['hasOwnProperty'](_0x58ef('0x41'))){_0x4befb6[_0x58ef('0x22')]=qs[_0x58ef('0x22')](_0x358e1c[_0x58ef('0x3b')][_0x58ef('0x22')]);_0x4befb6['offset']=qs[_0x58ef('0x21')](_0x358e1c[_0x58ef('0x3b')][_0x58ef('0x21')]);}_0x4befb6[_0x58ef('0x42')]=qs['sort'](_0x358e1c[_0x58ef('0x3b')]['sort']);_0x4befb6['where']=qs[_0x58ef('0x3c')](_['pick'](_0x358e1c[_0x58ef('0x3b')],_0x57df57[_0x58ef('0x3c')]));_0x4befb6[_0x58ef('0x44')][_0x58ef('0xc9')]=_0x2331e4['id'];if(_0x358e1c[_0x58ef('0x3b')][_0x58ef('0x64')]){_0x4befb6[_0x58ef('0x44')]=_[_0x58ef('0x86')](_0x4befb6['where'],{'$or':_['map'](_0x4befb6[_0x58ef('0x3f')],function(_0x51f95f){var _0x2eb804={};_0x2eb804[_0x51f95f]={'$like':'%'+_0x358e1c['query']['filter']+'%'};return _0x2eb804;})});}_0x4befb6=_['merge']({},_0x4befb6,_0x358e1c[_0x58ef('0xc0')]);return db[_0x58ef('0xcb')][_0x58ef('0x20')]({'where':_0x4befb6[_0x58ef('0x44')]})[_0x58ef('0x28')](function(_0x3c0012){_0x980a2f[_0x58ef('0x20')]=_0x3c0012;if(_0x358e1c[_0x58ef('0x3b')][_0x58ef('0xc6')]){_0x4befb6[_0x58ef('0xc7')]=[{'all':!![]}];}return db[_0x58ef('0xcb')][_0x58ef('0x92')](_0x4befb6);})[_0x58ef('0x28')](function(_0x5ca4d9){_0x980a2f['rows']=_0x5ca4d9;return _0x980a2f;});}})[_0x58ef('0x28')](respondWithFilteredResult(_0x146070,_0x4befb6))['catch'](handleError(_0x146070,null));};exports['getJscriptySessions']=function(_0x521ce8,_0x305a2a,_0x479884){var _0x56ff60={'raw':!![],'where':{}};var _0x5cda0e={};var _0x1fa0ff={'count':0x0,'rows':[]};return db[_0x58ef('0x2f')][_0x58ef('0x35')]({'where':{'id':_0x521ce8[_0x58ef('0xb5')]['id']}})[_0x58ef('0x28')](handleEntityNotFound(_0x305a2a,null))['then'](function(_0x567d36){if(_0x567d36){_0x5cda0e[_0x58ef('0x3a')]=_[_0x58ef('0x31')](db[_0x58ef('0xad')]['rawAttributes']);_0x5cda0e[_0x58ef('0x3b')]=_[_0x58ef('0x31')](_0x521ce8[_0x58ef('0x3b')]);_0x5cda0e[_0x58ef('0x3c')]=_[_0x58ef('0x3d')](_0x5cda0e[_0x58ef('0x3a')],_0x5cda0e[_0x58ef('0x3b')]);_0x56ff60[_0x58ef('0x3f')]=_[_0x58ef('0x3d')](_0x5cda0e['model'],qs[_0x58ef('0x3e')](_0x521ce8[_0x58ef('0x3b')][_0x58ef('0x3e')]));_0x56ff60[_0x58ef('0x3f')]=_0x56ff60['attributes'][_0x58ef('0x40')]?_0x56ff60[_0x58ef('0x3f')]:_0x5cda0e[_0x58ef('0x3a')];if(!_0x521ce8[_0x58ef('0x3b')]['hasOwnProperty'](_0x58ef('0x41'))){_0x56ff60[_0x58ef('0x22')]=qs[_0x58ef('0x22')](_0x521ce8[_0x58ef('0x3b')][_0x58ef('0x22')]);_0x56ff60['offset']=qs[_0x58ef('0x21')](_0x521ce8[_0x58ef('0x3b')][_0x58ef('0x21')]);}_0x56ff60[_0x58ef('0x42')]=qs[_0x58ef('0x43')](_0x521ce8[_0x58ef('0x3b')][_0x58ef('0x43')]);_0x56ff60[_0x58ef('0x44')]=qs[_0x58ef('0x3c')](_[_0x58ef('0xbf')](_0x521ce8[_0x58ef('0x3b')],_0x5cda0e[_0x58ef('0x3c')]));_0x56ff60[_0x58ef('0x44')][_0x58ef('0xc9')]=_0x567d36['id'];if(_0x521ce8['query']['filter']){_0x56ff60[_0x58ef('0x44')]=_['merge'](_0x56ff60[_0x58ef('0x44')],{'$or':_['map'](_0x56ff60['attributes'],function(_0x2998eb){var _0xfb06cc={};_0xfb06cc[_0x2998eb]={'$like':'%'+_0x521ce8['query'][_0x58ef('0x64')]+'%'};return _0xfb06cc;})});}_0x56ff60=_[_0x58ef('0x86')]({},_0x56ff60,_0x521ce8[_0x58ef('0xc0')]);return db[_0x58ef('0xad')]['count']({'where':_0x56ff60[_0x58ef('0x44')]})[_0x58ef('0x28')](function(_0x61d2c0){_0x1fa0ff[_0x58ef('0x20')]=_0x61d2c0;if(_0x521ce8[_0x58ef('0x3b')][_0x58ef('0xc6')]){_0x56ff60['include']=[{'all':!![]}];}return db['JscriptySessionReport']['findAll'](_0x56ff60);})['then'](function(_0x32b03c){_0x1fa0ff[_0x58ef('0x8f')]=_0x32b03c;return _0x1fa0ff;});}})[_0x58ef('0x28')](respondWithFilteredResult(_0x305a2a,_0x56ff60))['catch'](handleError(_0x305a2a,null));};exports[_0x58ef('0xcc')]=function(_0x41d062,_0xc06f24,_0x46c88b){try{if(!_0x41d062[_0x58ef('0x96')][_0x58ef('0x68')]){throw new Error(_0x58ef('0xcd'));}if(!_0x41d062[_0x58ef('0x96')][_0x58ef('0xce')]){throw new Error(_0x58ef('0xcf'));}if(!_0x41d062[_0x58ef('0x96')]['binding_values']){throw new Error(_0x58ef('0xd0'));}if(!_0x41d062[_0x58ef('0x96')][_0x58ef('0xd1')]){throw new Error(_0x58ef('0xd2'));}var _0x35f87b=_0x41d062[_0x58ef('0x96')][_0x58ef('0xce')][_0x58ef('0x59')](',');var _0x187dc2=_0x41d062['body']['binding_values'][_0x58ef('0x59')](',');if(!_0x35f87b[_0x58ef('0x40')]||!_0x187dc2[_0x58ef('0x40')]||_0x35f87b['length']!==_0x187dc2['length']){throw new Error('Incorrect\x20binding\x20parameters\x20passed!');}_0x41d062[_0x58ef('0x96')][_0x58ef('0x3e')]=_['zipObject'](_0x35f87b,_0x187dc2);if(!_0x41d062[_0x58ef('0x96')][_0x58ef('0x3e')][_0x58ef('0xbe')]){throw new Error(_0x58ef('0xd3'));}if(!_0x41d062[_0x58ef('0x96')][_0x58ef('0x3e')][_0x58ef('0xd4')]){throw new Error('No\x20firstName\x20column\x20specified');}var _0x4b0d26=path['join'](config[_0x58ef('0xd5')],'server/files/tmp',_0x41d062[_0x58ef('0xd6')][_0x58ef('0xd7')]);fs[_0x58ef('0xd8')](_0x4b0d26,parseInt(_0x58ef('0xd9'),0x8));var _0x10c22c=require(_0x58ef('0xda'))[_0x58ef('0xdb')](path[_0x58ef('0x9a')](__dirname,_0x58ef('0xdc')),[_0x4b0d26,_0x41d062[_0x58ef('0x96')][_0x58ef('0xce')],_0x41d062[_0x58ef('0x96')][_0x58ef('0xdd')],_0x41d062[_0x58ef('0x96')]['ListId'],_0x41d062[_0x58ef('0x96')]['CompanyId'],_0x41d062[_0x58ef('0x96')][_0x58ef('0xb1')],_0x41d062['body'][_0x58ef('0xd1')]]);return _0xc06f24[_0x58ef('0x1e')](0xc8)[_0x58ef('0x1f')]({'message':_0x58ef('0xde'),'pid':_0x10c22c[_0x58ef('0xdf')]});}catch(_0x12832f){return _0xc06f24['status'](0x1f4)[_0x58ef('0xe0')](_0x12832f);}};exports['upload']=function(_0x5203c1,_0x2618b4,_0x4be0ba){var _0x47bd05=fs[_0x58ef('0xe1')](_0x5203c1[_0x58ef('0xd6')][_0x58ef('0x9')]);Papa[_0x58ef('0xe2')](_0x47bd05,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x1af641){return _0x2618b4[_0x58ef('0x1e')](0xc8)[_0x58ef('0x1f')]({'file':_0x5203c1['file'],'fields':_0x1af641[_0x58ef('0xe3')][_0x58ef('0x3e')]});}});};exports['import']=function(_0x2fedd4,_0x102177,_0x5b8981){return db[_0x58ef('0x82')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0x58ef('0xe4')}})[_0x58ef('0x28')](function(_0xae945e){var _0x547c48=![];if(!_0x2fedd4[_0x58ef('0x96')][_0x58ef('0x68')]){throw new Error(_0x58ef('0xcd'));}if(!_0x2fedd4[_0x58ef('0x96')][_0x58ef('0xe5')]['phone']){throw new Error(_0x58ef('0xd3'));}if(!_0x2fedd4['body'][_0x58ef('0xe5')]['firstName']){throw new Error(_0x58ef('0xe6'));}if(!_0x2fedd4[_0x58ef('0x96')]['socket_timestamp']){throw new Error(_0x58ef('0xd2'));}var _0x16d811=require(_0x58ef('0xda'))[_0x58ef('0xdb')](path[_0x58ef('0x9a')](__dirname,_0x58ef('0xe7')),[_0x2fedd4[_0x58ef('0xb5')]['id'],JSON[_0x58ef('0xe8')](_0x2fedd4[_0x58ef('0x96')]),JSON[_0x58ef('0xe8')](_0xae945e)]);_0x16d811['on'](_0x58ef('0xe9'),function(_0x2861e8){_0x547c48=!![];return _0x102177['status'](0xc8)['json']({'message':_0x58ef('0xea'),'pid':_0x16d811[_0x58ef('0xdf')]});});_0x16d811['on']('exit',function(_0x1dac75){if(_0x1dac75&&!_0x547c48){return _0x102177[_0x58ef('0x1e')](0x1f4)['json']({'message':_0x58ef('0xeb'),'pid':_0x16d811['pid']});}});})[_0x58ef('0x90')](handleError(_0x102177,null));};
git://repos.xcallymotion.com / motion2.git / blob