18 var _0x1dcc=['No\x20ListId\x20specified','No\x20association\x20keys\x20specified!','binding_values','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','binding_keys','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','server/files/tmp','chmodSync','child_process','fork','CompanyId','File\x20uploaded\x20correctly!','pid','upload','createReadStream','file','parse','meta','import','agent','binding','../../components/import/cm/csv2','stringify','exit','html-pdf','zip-dir','fast-json-patch','bluebird','mustache','util','path','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/environment','../../mysqldb','redis','defaults','socket.io-emitter','register','sendStatus','status','json','offset','limit','set','Content-Range','apply','reject','save','update','then','end','error','stack','name','send','index','startsWith','cf_','push','CmCustomField','trimStart','all','length','type','model','keys','query','attributes','intersection','fields','nolimit','where','filters','select','field','color','from','tools_tags','cm_contacts','left_join','uc.CmContactId\x20=\x20c.id','ct.CmContactId\x20=\x20c.id','t.id\x20=\x20ct.TagId','c.deletedAt\x20IS\x20NULL','search','sqlOperator','conditions','find','value','split','map','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','and','dateOfBirth','fieldType','datetime','castTo','buildExpression','text','hasOwnProperty','filter','isNil','forEach','ListId','c.ListId\x20IN\x20?','concat','Contact','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','replace','\x27\x27\x27\x27','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','isNumeric','c.id\x20LIKE\x20?','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','c.email\x20LIKE\x20?','c.id','Sequelize','QueryTypes','SELECT','clone','DESC','t.id\x20IN\x20?','some','user','isEmpty','c.ListId\x20IS\x20NULL','sequelize','toString','count','keyBy','merge','CmContact','c.firstName','c.lastName','c.mobile','c.fax','c.deletedAt','TagIds','Tags','rows','params','describe','tags','columnName','displayName','findAll','alias','custom','values','catch','body','get','mergeWith','isArray','join','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','destroy','[CmContact][merge][destroy][CmHopper],\x20%s','info','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','SmsQueueReport','bulkCreate','each','duplicates','$or','spread','show','Tag','tag','$and','omit','format','cf_%d','pickBy','table','id\x20=\x20?','toParam','phone','getTags','findOne','rawAttributes','sort','pick','setTags','ids','order','ContactId','options','includeAll','getHopperHistories','include','getHopperFinals','getJscriptySessions','JscriptySessionReport','uploadCsv'];(function(_0x2bb2f5,_0x1b624c){var _0xb25642=function(_0x5b9a7b){while(--_0x5b9a7b){_0x2bb2f5['push'](_0x2bb2f5['shift']());}};_0xb25642(++_0x1b624c);}(_0x1dcc,0x10a));var _0xc1dc=function(_0x8f87ef,_0x26be33){_0x8f87ef=_0x8f87ef-0x0;var _0x179079=_0x1dcc[_0x8f87ef];return _0x179079;};'use strict';var pdf=require(_0xc1dc('0x0'));var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0xc1dc('0x1'));var jsonpatch=require(_0xc1dc('0x2'));var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0xc1dc('0x3'));var Mustache=require(_0xc1dc('0x4'));var util=require(_0xc1dc('0x5'));var path=require(_0xc1dc('0x6'));var sox=require('sox');var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var _=require('lodash');var squel=require('squel');var crypto=require(_0xc1dc('0x7'));var jsforce=require(_0xc1dc('0x8'));var deskjs=require(_0xc1dc('0x9'));var toCsv=require('to-csv');var querystring=require(_0xc1dc('0xa'));var Papa=require(_0xc1dc('0xb'));var Redis=require(_0xc1dc('0xc'));var authService=require('../../components/auth/service');var qs=require(_0xc1dc('0xd'));var as=require(_0xc1dc('0xe'));var hardwareService=require(_0xc1dc('0xf'));var logger=require(_0xc1dc('0x10'))('api');var utils=require('../../config/utils');var config=require(_0xc1dc('0x11'));var db=require(_0xc1dc('0x12'))['db'];config[_0xc1dc('0x13')]=_[_0xc1dc('0x14')](config[_0xc1dc('0x13')],{'host':'localhost','port':0x18eb});var socket=require(_0xc1dc('0x15'))(new Redis(config[_0xc1dc('0x13')]));require('./cmContact.socket')[_0xc1dc('0x16')](socket);function respondWithStatusCode(_0x2f18bb,_0x25191c){_0x25191c=_0x25191c||0xcc;return function(_0x746ec4){if(_0x746ec4){return _0x2f18bb[_0xc1dc('0x17')](_0x25191c);}return _0x2f18bb[_0xc1dc('0x18')](_0x25191c)['end']();};}function respondWithResult(_0x26710c,_0x116bdc){_0x116bdc=_0x116bdc||0xc8;return function(_0x1e1745){if(_0x1e1745){return _0x26710c[_0xc1dc('0x18')](_0x116bdc)[_0xc1dc('0x19')](_0x1e1745);}};}function respondWithFilteredResult(_0x562b70,_0x134cb6){return function(_0x380573){if(_0x380573){var _0x59221e=_0x380573['count'],_0x52af53=_0x134cb6[_0xc1dc('0x1a')],_0x407856=_0x134cb6[_0xc1dc('0x1a')]+_0x134cb6[_0xc1dc('0x1b')],_0x1a662d;if(_0x407856>=_0x59221e){_0x407856=_0x59221e;_0x1a662d=0xc8;}else{_0x1a662d=0xce;}_0x562b70[_0xc1dc('0x18')](_0x1a662d);return _0x562b70[_0xc1dc('0x1c')](_0xc1dc('0x1d'),_0x52af53+'-'+_0x407856+'/'+_0x59221e)['json'](_0x380573);}return null;};}function patchUpdates(_0x4a97e0){return function(_0x2f4970){try{jsonpatch[_0xc1dc('0x1e')](_0x2f4970,_0x4a97e0,!![]);}catch(_0xcc4897){return BPromise[_0xc1dc('0x1f')](_0xcc4897);}return _0x2f4970[_0xc1dc('0x20')]();};}function saveUpdates(_0x1b03df,_0x5ecbfe){return function(_0x3e3328){if(_0x3e3328){return _0x3e3328[_0xc1dc('0x21')](_0x1b03df)[_0xc1dc('0x22')](function(_0x20cf54){return _0x20cf54;});}return null;};}function removeEntity(_0x69e848,_0x6e8dda){return function(_0xda656a){if(_0xda656a){return _0xda656a['destroy']()['then'](function(){_0x69e848[_0xc1dc('0x18')](0xcc)[_0xc1dc('0x23')]();});}};}function handleEntityNotFound(_0x399316,_0x4fe422){return function(_0x126211){if(!_0x126211){_0x399316['sendStatus'](0x194);}return _0x126211;};}function handleError(_0x1d1f0a,_0x2cda2e){_0x2cda2e=_0x2cda2e||0x1f4;return function(_0x1a759c){logger[_0xc1dc('0x24')](_0x1a759c[_0xc1dc('0x25')]);if(_0x1a759c['name']){delete _0x1a759c[_0xc1dc('0x26')];}_0x1d1f0a[_0xc1dc('0x18')](_0x2cda2e)[_0xc1dc('0x27')](_0x1a759c);};}exports[_0xc1dc('0x28')]=function(_0x582f19,_0x8007fe){var _0x2d06d2={},_0x367a75={},_0x3288d4={'count':0x0,'rows':[]};return db['CmContact']['describe']()[_0xc1dc('0x22')](function(_0x11ae26){var _0x5e8782=[];for(var _0x560397=0x0;_0x560397<Object['keys'](_0x11ae26)['length'];_0x560397++){var _0x38dcdf=Object['keys'](_0x11ae26)[_0x560397];if(_[_0xc1dc('0x29')](_0x38dcdf,_0xc1dc('0x2a'))){_0x5e8782[_0xc1dc('0x2b')](db[_0xc1dc('0x2c')]['findOne']({'where':{'id':_[_0xc1dc('0x2d')](_0x38dcdf,_0xc1dc('0x2a'))},'raw':!![]}));}}return BPromise[_0xc1dc('0x2e')](_0x5e8782)['then'](function(_0x43ddaf){for(var _0x49a55a=0x0;_0x49a55a<_0x43ddaf[_0xc1dc('0x2f')];_0x49a55a++){if(_0x43ddaf[_0x49a55a]){var _0x214ccd=_0xc1dc('0x2a')+_0x43ddaf[_0x49a55a]['id'];var _0x1cce32=_0x11ae26[_0x214ccd];_0x1cce32['fieldType']=_0x43ddaf[_0x49a55a][_0xc1dc('0x30')];}}return _0x11ae26;});})[_0xc1dc('0x22')](function(_0x2719fb){_0x367a75[_0xc1dc('0x31')]=_[_0xc1dc('0x32')](_0x2719fb);_0x367a75[_0xc1dc('0x33')]=_['keys'](_0x582f19['query']);_0x367a75['filters']=_['intersection'](_0x367a75[_0xc1dc('0x31')],_0x367a75[_0xc1dc('0x33')]);_0x2d06d2[_0xc1dc('0x34')]=_[_0xc1dc('0x35')](_0x367a75[_0xc1dc('0x31')],qs['fields'](_0x582f19[_0xc1dc('0x33')][_0xc1dc('0x36')]));_0x2d06d2[_0xc1dc('0x34')]=_0x2d06d2[_0xc1dc('0x34')][_0xc1dc('0x2f')]?_0x2d06d2['attributes']:_0x367a75[_0xc1dc('0x31')];if(!_0x582f19['query']['hasOwnProperty'](_0xc1dc('0x37'))){_0x2d06d2[_0xc1dc('0x1b')]=qs[_0xc1dc('0x1b')](_0x582f19[_0xc1dc('0x33')][_0xc1dc('0x1b')]);_0x2d06d2['offset']=qs[_0xc1dc('0x1a')](_0x582f19[_0xc1dc('0x33')]['offset']);}_0x2d06d2['order']=qs['sort'](_0x582f19[_0xc1dc('0x33')]['sort']);_0x2d06d2[_0xc1dc('0x38')]=qs['filters'](_['pick'](_0x582f19[_0xc1dc('0x33')],_0x367a75[_0xc1dc('0x39')]));var _0x1a8372=[];var _0x23f490=squel[_0xc1dc('0x3a')]()[_0xc1dc('0x3b')]('id')[_0xc1dc('0x3b')](_0xc1dc('0x26'))[_0xc1dc('0x3b')](_0xc1dc('0x3c'))[_0xc1dc('0x3d')](_0xc1dc('0x3e'));var _0x33f73f=squel[_0xc1dc('0x3a')]()[_0xc1dc('0x3d')](_0xc1dc('0x3f'),'c')[_0xc1dc('0x40')]('cm_user_has_contacts','uc',_0xc1dc('0x41'))[_0xc1dc('0x40')]('cm_contact_has_tags','ct',_0xc1dc('0x42'))[_0xc1dc('0x40')](_0xc1dc('0x3e'),'t',_0xc1dc('0x43'))[_0xc1dc('0x38')](_0xc1dc('0x44'));var _0x21bf98=squel['expr']();var _0x56e8c6=[];var _0x3494ea=squel['expr']();var _0x28fce3;if(_0x582f19['query'][_0xc1dc('0x45')]){_0x28fce3=as['parseSearch'](_0x582f19[_0xc1dc('0x33')][_0xc1dc('0x45')]);var _0x6d0c04=_0x28fce3[_0xc1dc('0x46')];for(var _0x4e144f=0x0;_0x4e144f<_0x28fce3[_0xc1dc('0x47')][_0xc1dc('0x2f')];_0x4e144f++){var _0x304575=_0x28fce3['conditions'][_0x4e144f];var _0x51a25c='c';var _0x496ddc=_(_0x2719fb)['keys']()[_0xc1dc('0x48')](function(_0x2a2f5d){return _0x2a2f5d===_0x304575[_0xc1dc('0x3b')];});if(_0x496ddc)_0x496ddc=_0x2719fb[_0x304575[_0xc1dc('0x3b')]];if(!_0x496ddc){if(_0x304575[_0xc1dc('0x3b')]==='Tag'){var _0x9093bf=_0x304575[_0xc1dc('0x49')][_0xc1dc('0x4a')](',')[_0xc1dc('0x4b')](function(_0x3761c2){return Number(_0x3761c2);});_0x9093bf['forEach'](function(_0x1c74ee){_0x3494ea['or'](_0xc1dc('0x4c'),'%,'+_0x1c74ee+',%');});_0x56e8c6=_[_0xc1dc('0x4d')](_0x56e8c6,_0x9093bf);}else if(_0x304575[_0xc1dc('0x3b')]===_0xc1dc('0x4e')){_0x21bf98[_0xc1dc('0x4f')]('uc.UserId\x20=\x20?',_0x304575[_0xc1dc('0x49')]);}}else{if(_0x304575[_0xc1dc('0x3b')]===_0xc1dc('0x50')||_0x496ddc[_0xc1dc('0x51')]===_0xc1dc('0x52'))_0x304575[_0xc1dc('0x53')]='DATE';var _0xfb82f1=as[_0xc1dc('0x54')](_0x51a25c,_0x496ddc['type'],_0x304575);_0x21bf98[_0x6d0c04](_0xfb82f1[_0xc1dc('0x55')],_0xfb82f1[_0xc1dc('0x49')]['start'],_0xfb82f1[_0xc1dc('0x49')][_0xc1dc('0x23')]);}}}else{var _0x5a8435=_(Object[_0xc1dc('0x32')](_0x582f19['query']))[_0xc1dc('0x4b')](function(_0x4a6200){return _0x2719fb[_0xc1dc('0x56')](_0x4a6200)?_0x4a6200:undefined;})[_0xc1dc('0x57')](function(_0x4ad744){return!_[_0xc1dc('0x58')](_0x4ad744);})[_0xc1dc('0x49')]();if(_0x582f19[_0xc1dc('0x33')]['Contact'])_0x5a8435[_0xc1dc('0x2b')]('Contact');if(!_['isEmpty'](_0x5a8435)){_0x5a8435[_0xc1dc('0x59')](function(_0x5071a5){if(_0x5071a5===_0xc1dc('0x5a')){_0x33f73f[_0xc1dc('0x38')](_0xc1dc('0x5b'),[][_0xc1dc('0x5c')](_0x582f19[_0xc1dc('0x33')][_0x5071a5]));}else if(_0x5071a5===_0xc1dc('0x5d')){var _0x194f23='%'+_0x582f19['query'][_0x5071a5]+'%';_0x33f73f['where'](_0xc1dc('0x5e'),_0x194f23);}else{_0x33f73f[_0xc1dc('0x38')]('c.'+_0x5071a5+'\x20=\x20?',_0x582f19[_0xc1dc('0x33')][_0x5071a5]);}});}if(_0x582f19[_0xc1dc('0x33')]['tag']){_0x56e8c6=_['isArray'](_0x582f19[_0xc1dc('0x33')]['tag'])?_0x582f19[_0xc1dc('0x33')]['tag']:new Array(_0x582f19[_0xc1dc('0x33')]['tag']);_0x56e8c6['forEach'](function(_0x379160){_0x3494ea['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x379160+',%');});}if(_0x582f19[_0xc1dc('0x33')][_0xc1dc('0x57')]){var _0x1517e1=_0x582f19['query'][_0xc1dc('0x57')][_0xc1dc('0x5f')]('\x5c','\x5c\x5c')[_0xc1dc('0x5f')]('\x27\x27',_0xc1dc('0x60'));if(_0x1517e1['split']('\x20')['length']>0x1){_0x21bf98['or'](_0xc1dc('0x61'),qs[_0xc1dc('0x62')](_0x1517e1),null);}else{if(qs[_0xc1dc('0x63')](_0x1517e1)){_0x21bf98['or'](_0xc1dc('0x64'),_0x1517e1+'%');_0x21bf98['or'](_0xc1dc('0x65'),_0x1517e1+'%');_0x21bf98['or'](_0xc1dc('0x66'),_0x1517e1+'%');_0x21bf98['or'](_0xc1dc('0x67'),_0x1517e1+'%');}else if(qs[_0xc1dc('0x68')](_0x1517e1)){_0x21bf98['or']('c.email\x20LIKE\x20?',_0x1517e1+'%');}else{_0x21bf98['or'](_0xc1dc('0x69'),'%'+_0x1517e1+'%');_0x21bf98['or'](_0xc1dc('0x6a'),'%'+_0x1517e1+'%');_0x21bf98['or'](_0xc1dc('0x6b'),'%'+_0x1517e1+'%');}}}}_0x33f73f[_0xc1dc('0x38')](_0x21bf98);_0x33f73f['group'](_0xc1dc('0x6c'));var _0x2ca0fe={'type':db[_0xc1dc('0x6d')][_0xc1dc('0x6e')][_0xc1dc('0x6f')],'raw':!![]};var _0x4eab0a=_0x33f73f[_0xc1dc('0x70')]()[_0xc1dc('0x3b')]('c.id');if(_0x2d06d2['order']){_0x2d06d2['order'][_0xc1dc('0x59')](function(_0x1cf3b6){_0x33f73f['order']('c.'+_0x1cf3b6[0x0],_0x1cf3b6[0x1]===_0xc1dc('0x71')?![]:!![]);});}if(!_['isEmpty'](_0x56e8c6)){_0x33f73f['having'](_0x3494ea);_0x4eab0a['where'](_0xc1dc('0x72'),_0x56e8c6);}BPromise['resolve']()[_0xc1dc('0x22')](function(){if(_0x28fce3&&!_[_0xc1dc('0x73')](_0x28fce3[_0xc1dc('0x47')],[_0xc1dc('0x3b'),_0xc1dc('0x4e')])){return _0x582f19[_0xc1dc('0x74')]['getLists']({'attributes':['id'],'raw':!![]})[_0xc1dc('0x22')](function(_0x59e16b){if(_[_0xc1dc('0x75')](_0x59e16b)){_0x4eab0a[_0xc1dc('0x38')]('c.ListId\x20IS\x20NULL');_0x33f73f[_0xc1dc('0x38')](_0xc1dc('0x76'));}else{_0x4eab0a[_0xc1dc('0x38')](_0xc1dc('0x5b'),_[_0xc1dc('0x4b')](_0x59e16b,'id'));_0x33f73f[_0xc1dc('0x38')](_0xc1dc('0x5b'),_[_0xc1dc('0x4b')](_0x59e16b,'id'));}});}else{return;}})[_0xc1dc('0x22')](function(){db[_0xc1dc('0x77')][_0xc1dc('0x33')](_0x4eab0a[_0xc1dc('0x78')](),_0x2ca0fe)[_0xc1dc('0x22')](function(_0xa86ce5){_0x3288d4[_0xc1dc('0x79')]=_0xa86ce5[_0xc1dc('0x2f')];if(_0x3288d4[_0xc1dc('0x79')]===0x0)return[];return db[_0xc1dc('0x77')]['query'](_0x23f490[_0xc1dc('0x78')](),_0x2ca0fe);})[_0xc1dc('0x22')](function(_0x6d0bd2){_0x1a8372=_[_0xc1dc('0x7a')](_0x6d0bd2,'id');_0x2ca0fe=_[_0xc1dc('0x7b')](_0x2ca0fe,{'model':db[_0xc1dc('0x7c')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x582f19[_0xc1dc('0x33')][_0xc1dc('0x36')]){_0x2d06d2['attributes'][_0xc1dc('0x59')](function(_0x4f02af){_0x33f73f[_0xc1dc('0x3b')]('c.'+_0x4f02af);});}else{_0x33f73f[_0xc1dc('0x3b')](_0xc1dc('0x6c'));_0x33f73f[_0xc1dc('0x3b')](_0xc1dc('0x7d'));_0x33f73f[_0xc1dc('0x3b')](_0xc1dc('0x7e'));_0x33f73f[_0xc1dc('0x3b')]('c.phone');_0x33f73f[_0xc1dc('0x3b')](_0xc1dc('0x7f'));_0x33f73f[_0xc1dc('0x3b')](_0xc1dc('0x80'));_0x33f73f[_0xc1dc('0x3b')]('c.email');_0x33f73f['field']('c.ListId');_0x33f73f[_0xc1dc('0x3b')](_0xc1dc('0x81'));_0x33f73f[_0xc1dc('0x3b')]('GROUP_CONCAT(DISTINCT\x20t.id)',_0xc1dc('0x82'));}if(_0x2d06d2[_0xc1dc('0x1b')])_0x33f73f['limit'](_0x2d06d2[_0xc1dc('0x1b')]);if(_0x2d06d2[_0xc1dc('0x1a')])_0x33f73f['offset'](_0x2d06d2[_0xc1dc('0x1a')]);return db[_0xc1dc('0x77')][_0xc1dc('0x33')](_0x33f73f[_0xc1dc('0x78')](),_0x2ca0fe);})['then'](function(_0x2b25b2){_0x2b25b2['forEach'](function(_0x4caaa7){if(_0x4caaa7['TagIds']){_0x4caaa7[_0xc1dc('0x83')]=[];_0x4caaa7[_0xc1dc('0x82')][_0xc1dc('0x4a')](',')[_0xc1dc('0x59')](function(_0x5ec8d3){_0x4caaa7['Tags']['push'](_0x1a8372[_0x5ec8d3]);});}delete _0x4caaa7[_0xc1dc('0x82')];});_0x3288d4[_0xc1dc('0x84')]=_0x2b25b2;return _0x3288d4;})[_0xc1dc('0x22')](respondWithFilteredResult(_0x8007fe,_0x2d06d2));});})['catch'](handleError(_0x8007fe,null));};exports['destroy']=function(_0x492aaf,_0x4c95c7){return db['CmContact'][_0xc1dc('0x48')]({'where':{'id':_0x492aaf[_0xc1dc('0x85')]['id']}})['then'](handleEntityNotFound(_0x4c95c7,null))[_0xc1dc('0x22')](removeEntity(_0x4c95c7,null))['catch'](handleError(_0x4c95c7,null));};exports['describe']=function(_0x447f52,_0x102a7){return db[_0xc1dc('0x7c')][_0xc1dc('0x86')]()[_0xc1dc('0x22')](function(_0x2404f0){delete _0x2404f0[_0xc1dc('0x87')];for(var _0x4bd04d=0x0;_0x4bd04d<Object[_0xc1dc('0x32')](_0x2404f0)['length'];_0x4bd04d++){var _0x26f796=Object['keys'](_0x2404f0)[_0x4bd04d];if(!_[_0xc1dc('0x29')](_0x26f796,_0xc1dc('0x2a'))){_0x2404f0[_0x26f796][_0xc1dc('0x88')]=_0x26f796;_0x2404f0[_0x26f796][_0xc1dc('0x89')]=_0x26f796;}}return _0x2404f0;})[_0xc1dc('0x22')](function(_0x4c1dd4){var _0x44528e={'where':{'$or':[{'ListId':_0x447f52['query']['id']},{'ListId':null}]},'raw':!![]};return db[_0xc1dc('0x2c')][_0xc1dc('0x8a')](_0x44528e)[_0xc1dc('0x22')](function(_0x2ab7b1){for(var _0x4d8b88=0x0;_0x4d8b88<_0x2ab7b1['length'];_0x4d8b88++){var _0x520db9=_0xc1dc('0x2a')+_0x2ab7b1[_0x4d8b88]['id'];_0x4c1dd4[_0x520db9]['columnName']=_0x520db9;_0x4c1dd4[_0x520db9][_0xc1dc('0x89')]=_0x2ab7b1[_0x4d8b88][_0xc1dc('0x8b')];_0x4c1dd4[_0x520db9][_0xc1dc('0x8c')]={'type':_0x2ab7b1[_0x4d8b88][_0xc1dc('0x30')],'values':_0x2ab7b1[_0x4d8b88][_0xc1dc('0x8d')]};}Object['keys'](_0x4c1dd4)[_0xc1dc('0x59')](function(_0x458760){if(!_0x4c1dd4[_0x458760]['hasOwnProperty'](_0xc1dc('0x88'))){delete _0x4c1dd4[_0x458760];}});return _0x4c1dd4;});})[_0xc1dc('0x22')](respondWithResult(_0x102a7,null))[_0xc1dc('0x8e')](handleError(_0x102a7,null));};exports[_0xc1dc('0x7b')]=function(_0x1b753b,_0x65b208){var _0x1a67ab;var _0x49d711;var _0xd98053;if(_0x1b753b[_0xc1dc('0x8f')]['id']){delete _0x1b753b[_0xc1dc('0x8f')]['id'];}return db['CmContact']['findAll']({'where':{'id':[_0x1b753b[_0xc1dc('0x8f')]['to'],_0x1b753b[_0xc1dc('0x8f')][_0xc1dc('0x3d')]]}})[_0xc1dc('0x22')](function(_0x79eb6){if(_0x79eb6){if(_0x79eb6[_0xc1dc('0x2f')]!==0x2){return null;}_0x79eb6[0x0]=_0x79eb6[0x0][_0xc1dc('0x90')]({'plain':!![]});_0x79eb6[0x1]=_0x79eb6[0x1][_0xc1dc('0x90')]({'plain':!![]});delete _0x79eb6[0x0]['id'];delete _0x79eb6[0x1]['id'];return _[_0xc1dc('0x91')](_0x79eb6[0x0],_0x79eb6[0x1],function(_0x269d1b,_0x10e63a){if(Array[_0xc1dc('0x92')](_0x10e63a)&&!_0x10e63a[_0xc1dc('0x2f')]){return _0x269d1b;}else if(!_0x10e63a){return _0x269d1b;}});}})['then'](handleEntityNotFound(_0x65b208,null))[_0xc1dc('0x22')](function(_0x1ddc58){if(_0x1ddc58){if(_0x1ddc58['tags']&&_['isArray'](_0x1ddc58['tags'])){_0x1ddc58[_0xc1dc('0x87')]=_0x1ddc58[_0xc1dc('0x87')][_0xc1dc('0x93')]();}logger['info'](_0xc1dc('0x94'),_0x1b753b['body']['to'],_0x1b753b[_0xc1dc('0x8f')][_0xc1dc('0x3d')]);return db[_0xc1dc('0x95')][_0xc1dc('0x96')]({'where':{'ContactId':[_0x1b753b[_0xc1dc('0x8f')]['to'],_0x1b753b[_0xc1dc('0x8f')][_0xc1dc('0x3d')]]}})[_0xc1dc('0x22')](function(_0x3f815a){logger['info'](_0xc1dc('0x97'),_0x3f815a);return db['CmHopperBlack'][_0xc1dc('0x96')]({'where':{'ContactId':[_0x1b753b[_0xc1dc('0x8f')]['to'],_0x1b753b[_0xc1dc('0x8f')][_0xc1dc('0x3d')]]}})['then'](function(_0x47388e){logger[_0xc1dc('0x98')](_0xc1dc('0x99'),_0x47388e);return db[_0xc1dc('0x7c')][_0xc1dc('0x9a')](_0x1ddc58);});});}})[_0xc1dc('0x22')](function(_0x4a78a4){if(_0x4a78a4){_0x1a67ab=_0x4a78a4;_0x49d711={'ContactId':_0x1a67ab['id']};_0xd98053={'where':{'ContactId':[_0x1b753b[_0xc1dc('0x8f')]['to'],_0x1b753b[_0xc1dc('0x8f')][_0xc1dc('0x3d')]]}};return db[_0xc1dc('0x9b')][_0xc1dc('0x21')](_0x49d711,_0xd98053);}})[_0xc1dc('0x22')](function(){if(_0x1a67ab){return db[_0xc1dc('0x9c')][_0xc1dc('0x21')](_0x49d711,_0xd98053);}})[_0xc1dc('0x22')](function(){if(_0x1a67ab){return db[_0xc1dc('0x9d')][_0xc1dc('0x21')](_0x49d711,_0xd98053);}})[_0xc1dc('0x22')](function(){if(_0x1a67ab){return db[_0xc1dc('0x9e')][_0xc1dc('0x21')](_0x49d711,_0xd98053);}})[_0xc1dc('0x22')](function(){if(_0x1a67ab){return db[_0xc1dc('0x9f')][_0xc1dc('0x21')](_0x49d711,_0xd98053);}})['then'](function(){if(_0x1a67ab){return db[_0xc1dc('0x9e')][_0xc1dc('0x21')](_0x49d711,_0xd98053);}})[_0xc1dc('0x22')](function(){if(_0x1a67ab){return db[_0xc1dc('0x9f')]['update'](_0x49d711,_0xd98053);}})['then'](function(){if(_0x1a67ab){return db[_0xc1dc('0xa0')][_0xc1dc('0x21')](_0x49d711,_0xd98053);}})[_0xc1dc('0x22')](function(){if(_0x1a67ab){return db[_0xc1dc('0xa1')]['update'](_0x49d711,_0xd98053);}})[_0xc1dc('0x22')](function(){if(_0x1a67ab){return db[_0xc1dc('0xa2')]['update'](_0x49d711,_0xd98053);}})[_0xc1dc('0x22')](function(){if(_0x1a67ab){return db[_0xc1dc('0xa3')][_0xc1dc('0x21')](_0x49d711,_0xd98053);}})['then'](function(){if(_0x1a67ab){return db[_0xc1dc('0xa4')][_0xc1dc('0x21')](_0x49d711,_0xd98053);}})[_0xc1dc('0x22')](function(){if(_0x1a67ab){return db[_0xc1dc('0xa5')][_0xc1dc('0x21')](_0x49d711,_0xd98053);}})[_0xc1dc('0x22')](function(){if(_0x1a67ab){return db[_0xc1dc('0xa6')][_0xc1dc('0x21')](_0x49d711,_0xd98053);}})[_0xc1dc('0x22')](function(){if(_0x1a67ab){return db[_0xc1dc('0xa7')][_0xc1dc('0x21')](_0x49d711,_0xd98053);}})[_0xc1dc('0x22')](function(){if(_0x1a67ab){return db[_0xc1dc('0xa8')][_0xc1dc('0x21')](_0x49d711,_0xd98053);}})['then'](function(){if(_0x1a67ab){return db[_0xc1dc('0xa9')][_0xc1dc('0x21')](_0x49d711,_0xd98053);}})['then'](function(){if(_0x1a67ab){return db[_0xc1dc('0xaa')][_0xc1dc('0x21')](_0x49d711,_0xd98053);}})[_0xc1dc('0x22')](function(){if(_0x1a67ab){return db[_0xc1dc('0xab')][_0xc1dc('0x21')](_0x49d711,_0xd98053);}})[_0xc1dc('0x22')](function(){if(_0x1a67ab){return db[_0xc1dc('0xac')][_0xc1dc('0x21')](_0x49d711,_0xd98053);}})[_0xc1dc('0x22')](function(){if(_0x1a67ab){return db['OpenchannelQueueReport']['update'](_0x49d711,_0xd98053);}})[_0xc1dc('0x22')](function(){if(_0x1a67ab){return db[_0xc1dc('0xad')][_0xc1dc('0x21')](_0x49d711,_0xd98053);}})[_0xc1dc('0x22')](function(){if(_0x1a67ab){return db['JscriptySessionReport'][_0xc1dc('0x21')](_0x49d711,_0xd98053);}})[_0xc1dc('0x22')](function(){if(_0x1a67ab){return db[_0xc1dc('0x7c')]['destroy']({'where':{'id':[_0x1b753b[_0xc1dc('0x8f')]['to'],_0x1b753b[_0xc1dc('0x8f')][_0xc1dc('0x3d')]]}});}})[_0xc1dc('0x22')](function(){if(_0x1a67ab){return _0x1a67ab;}})[_0xc1dc('0x22')](respondWithResult(_0x65b208,null))['catch'](handleError(_0x65b208,null));};exports[_0xc1dc('0x9a')]=function(_0x55dabb,_0x1187c5){return db[_0xc1dc('0x7c')]['describe']()['then'](function(_0x38ed20){if(_0x55dabb[_0xc1dc('0x8f')][_0xc1dc('0x87')]&&_[_0xc1dc('0x92')](_0x55dabb['body'][_0xc1dc('0x87')])){if(_0x55dabb['body'][_0xc1dc('0x87')][_0xc1dc('0x2f')]){_0x55dabb[_0xc1dc('0x8f')][_0xc1dc('0x87')]=_0x55dabb[_0xc1dc('0x8f')][_0xc1dc('0x87')][_0xc1dc('0x93')](';')+';';}else{_0x55dabb[_0xc1dc('0x8f')][_0xc1dc('0x87')]=null;}}else{_0x55dabb[_0xc1dc('0x8f')]['tags']=null;}return db['CmContact'][_0xc1dc('0x9a')](_0x55dabb[_0xc1dc('0x8f')],{'fields':_[_0xc1dc('0x32')](_0x38ed20),'raw':!![]});})[_0xc1dc('0x22')](respondWithResult(_0x1187c5,0xc9))[_0xc1dc('0x8e')](handleError(_0x1187c5,null));};exports[_0xc1dc('0xae')]=function(_0x28d792,_0x3e6fe9){var _0x43c79e=[];var _0x2380a7=0x0;var _0x2ce8f7=0x0;var _0x543f13=0x0;return db['CmContact'][_0xc1dc('0x86')]()[_0xc1dc('0x22')](function(_0x1355b6){return BPromise[_0xc1dc('0xaf')](_0x28d792[_0xc1dc('0x8f')],function(_0x27176d){var _0x44c3db={'where':{'$or':[]},'defaults':_0x27176d,'fields':_['keys'](_0x1355b6),'raw':!![]};if(_0x27176d[_0xc1dc('0xb0')]){for(var _0x46a591=0x0;_0x46a591<_0x27176d[_0xc1dc('0xb0')][_0xc1dc('0x2f')];_0x46a591++){var _0x589f72={};_0x589f72[_0x27176d[_0xc1dc('0xb0')][_0x46a591]]=_0x27176d[_0x27176d[_0xc1dc('0xb0')][_0x46a591]];_0x44c3db['where'][_0xc1dc('0xb1')][_0xc1dc('0x2b')](_0x589f72);}_0x44c3db[_0xc1dc('0x38')][_0xc1dc('0x5a')]=_0x27176d[_0xc1dc('0x5a')];}return db[_0xc1dc('0x7c')]['findOrCreate'](_0x44c3db)[_0xc1dc('0xb2')](function(_0x182d06,_0x44fa09){if(_0x44fa09){_0x2380a7++;}else{_0x543f13++;}})[_0xc1dc('0x8e')](function(_0x55fcab){console[_0xc1dc('0x24')](_0x55fcab);_0x2ce8f7++;});});})['then'](function(_0x40f229){if(_0x40f229){return{'success':_0x2380a7,'failure':_0x2ce8f7,'duplicates':_0x543f13};}})['then'](respondWithResult(_0x3e6fe9,0xc9))[_0xc1dc('0x8e')](handleError(_0x3e6fe9,null));};exports[_0xc1dc('0xb3')]=function(_0x53c090,_0x446c57,_0x17143b){var _0x4b5cbb;return db[_0xc1dc('0x7c')]['describe']()[_0xc1dc('0x22')](function(_0x48b30d){return db[_0xc1dc('0x7c')]['find']({'where':{'id':_0x53c090[_0xc1dc('0x85')]['id']},'include':[{'model':db[_0xc1dc('0xb4')],'as':_0xc1dc('0x83'),'attributes':['id',_0xc1dc('0x26'),_0xc1dc('0x3c')],'required':_0x53c090['query'][_0xc1dc('0xb5')]?!![]:![]}],'attributes':_['keys'](_0x48b30d)});})[_0xc1dc('0x22')](function(_0x12f620){_0x4b5cbb=_0x12f620['get']({'plain':!![]});var _0xbab96f={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x12f620&&_0x12f620[_0xc1dc('0x5a')]){if(_0x12f620[_0xc1dc('0x5a')]){_0xbab96f[_0xc1dc('0x38')][_0xc1dc('0xb6')][_0xc1dc('0x2b')]({'ListId':{'$ne':_0x12f620[_0xc1dc('0x5a')]}});}}return db[_0xc1dc('0x2c')][_0xc1dc('0x8a')](_0xbab96f);})[_0xc1dc('0x22')](function(_0x1b3fd9){return _[_0xc1dc('0xb7')](_0x4b5cbb,_[_0xc1dc('0x4b')](_0x1b3fd9,function(_0x51cdd1){return util[_0xc1dc('0xb8')](_0xc1dc('0xb9'),_0x51cdd1['id']);}));})[_0xc1dc('0x22')](handleEntityNotFound(_0x446c57,null))[_0xc1dc('0x22')](respondWithResult(_0x446c57,null))[_0xc1dc('0x8e')](handleError(_0x446c57,null));};exports[_0xc1dc('0x21')]=function(_0x342e4e,_0x5780a2){var _0x6e0855;if(_0x342e4e['body']['id']){delete _0x342e4e[_0xc1dc('0x8f')]['id'];}return db[_0xc1dc('0x7c')]['find']({'where':{'id':_0x342e4e['params']['id']}})[_0xc1dc('0x22')](handleEntityNotFound(_0x5780a2,null))[_0xc1dc('0x22')](saveUpdates(_0x342e4e[_0xc1dc('0x8f')],null))[_0xc1dc('0x22')](function(_0x2b738b){_0x6e0855=_0x2b738b;var _0x16406c={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x2b738b&&_0x2b738b[_0xc1dc('0x5a')]){if(_0x2b738b[_0xc1dc('0x5a')]){_0x16406c[_0xc1dc('0x38')][_0xc1dc('0xb6')][_0xc1dc('0x2b')]({'ListId':{'$ne':_0x2b738b[_0xc1dc('0x5a')]}});}}return db[_0xc1dc('0x2c')][_0xc1dc('0x8a')](_0x16406c);})['then'](function(_0x1cca24){if(_0x1cca24){return _['omit'](_[_0xc1dc('0xba')](_0x342e4e[_0xc1dc('0x8f')],function(_0x34b545,_0x56b090){return _[_0xc1dc('0x29')](_0x56b090,_0xc1dc('0x2a'));}),_[_0xc1dc('0x4b')](_0x1cca24,function(_0x55a1b9){return util[_0xc1dc('0xb8')](_0xc1dc('0xb9'),_0x55a1b9['id']);}));}})[_0xc1dc('0x22')](function(_0x17ed68){if(_0x17ed68&&!_[_0xc1dc('0x75')](_0x17ed68)){var _0x588ed9=squel[_0xc1dc('0x21')]()[_0xc1dc('0xbb')](_0xc1dc('0x3f'))['setFields'](_0x17ed68)['where'](_0xc1dc('0xbc'),_0x342e4e[_0xc1dc('0x85')]['id'])[_0xc1dc('0xbd')]();return db[_0xc1dc('0x77')]['query'](_0x588ed9[_0xc1dc('0x55')],{'replacements':_0x588ed9[_0xc1dc('0x8d')]});}})['then'](function(){if(_0x342e4e['body'][_0xc1dc('0xbe')]&&_0x6e0855){return db['CmHopper'][_0xc1dc('0x21')]({'phone':_0x342e4e[_0xc1dc('0x8f')][_0xc1dc('0xbe')]},{'where':{'ContactId':_0x6e0855['id']}});}})[_0xc1dc('0x22')](function(){return _0x6e0855;})['then'](respondWithResult(_0x5780a2,null))[_0xc1dc('0x8e')](handleError(_0x5780a2,null));};exports[_0xc1dc('0xbf')]=function(_0xcee67f,_0x38dedc,_0x3bf0fc){var _0x5574b9={};var _0x457849={};var _0xbb5a90;var _0x12ca0b;return db[_0xc1dc('0x7c')][_0xc1dc('0xc0')]({'where':{'id':_0xcee67f[_0xc1dc('0x85')]['id']}})[_0xc1dc('0x22')](handleEntityNotFound(_0x38dedc,null))[_0xc1dc('0x22')](function(_0x4b5106){if(_0x4b5106){_0xbb5a90=_0x4b5106;_0x457849[_0xc1dc('0x31')]=_[_0xc1dc('0x32')](db['Tag'][_0xc1dc('0xc1')]);_0x457849[_0xc1dc('0x33')]=_['keys'](_0xcee67f[_0xc1dc('0x33')]);_0x457849['filters']=_[_0xc1dc('0x35')](_0x457849[_0xc1dc('0x31')],_0x457849[_0xc1dc('0x33')]);_0x5574b9[_0xc1dc('0x34')]=_[_0xc1dc('0x35')](_0x457849[_0xc1dc('0x31')],qs[_0xc1dc('0x36')](_0xcee67f[_0xc1dc('0x33')][_0xc1dc('0x36')]));_0x5574b9['attributes']=_0x5574b9[_0xc1dc('0x34')][_0xc1dc('0x2f')]?_0x5574b9[_0xc1dc('0x34')]:_0x457849[_0xc1dc('0x31')];_0x5574b9['order']=qs[_0xc1dc('0xc2')](_0xcee67f[_0xc1dc('0x33')][_0xc1dc('0xc2')]);_0x5574b9['where']=qs[_0xc1dc('0x39')](_[_0xc1dc('0xc3')](_0xcee67f[_0xc1dc('0x33')],_0x457849[_0xc1dc('0x39')]));if(_0xcee67f[_0xc1dc('0x33')][_0xc1dc('0x57')]){_0x5574b9[_0xc1dc('0x38')]=_['merge'](_0x5574b9[_0xc1dc('0x38')],{'$or':_[_0xc1dc('0x4b')](_0x5574b9[_0xc1dc('0x34')],function(_0x594344){var _0x177160={};_0x177160[_0x594344]={'$like':'%'+_0xcee67f['query'][_0xc1dc('0x57')]+'%'};return _0x177160;})});}_0x5574b9=_[_0xc1dc('0x7b')]({},_0x5574b9,_0xcee67f['options']);return _0xbb5a90[_0xc1dc('0xbf')](_0x5574b9);}})[_0xc1dc('0x22')](function(_0x2b225f){if(_0x2b225f){_0x12ca0b=_0x2b225f[_0xc1dc('0x2f')];if(!_0xcee67f[_0xc1dc('0x33')][_0xc1dc('0x56')]('nolimit')){_0x5574b9[_0xc1dc('0x1b')]=qs[_0xc1dc('0x1b')](_0xcee67f[_0xc1dc('0x33')][_0xc1dc('0x1b')]);_0x5574b9[_0xc1dc('0x1a')]=qs['offset'](_0xcee67f['query'][_0xc1dc('0x1a')]);}return _0xbb5a90['getTags'](_0x5574b9);}})[_0xc1dc('0x22')](function(_0x5c6438){if(_0x5c6438){return _0x5c6438?{'count':_0x12ca0b,'rows':_0x5c6438}:null;}})[_0xc1dc('0x22')](respondWithResult(_0x38dedc,null))[_0xc1dc('0x8e')](handleError(_0x38dedc,null));};exports[_0xc1dc('0xc4')]=function(_0x11cc94,_0x5ab85d,_0x370086){if(_0x11cc94[_0xc1dc('0x8f')]['id']){delete _0x11cc94['body']['id'];}return db[_0xc1dc('0x7c')][_0xc1dc('0xc0')]({'where':{'id':_0x11cc94[_0xc1dc('0x85')]['id']}})[_0xc1dc('0x22')](handleEntityNotFound(_0x5ab85d,null))['then'](function(_0x591bb6){if(_0x591bb6){return _0x591bb6[_0xc1dc('0xc4')](_0x11cc94[_0xc1dc('0x8f')][_0xc1dc('0xc5')]||[]);}return null;})['then'](respondWithResult(_0x5ab85d,null))[_0xc1dc('0x8e')](handleError(_0x5ab85d,null));};exports['getHoppers']=function(_0x44ad9d,_0x33b88d,_0x4919b1){var _0x874dcf={'raw':![],'where':{}};var _0x407e57={};var _0x55836f={'count':0x0,'rows':[]};return db[_0xc1dc('0x7c')]['findOne']({'where':{'id':_0x44ad9d[_0xc1dc('0x85')]['id']}})[_0xc1dc('0x22')](handleEntityNotFound(_0x33b88d,null))[_0xc1dc('0x22')](function(_0x35d5db){if(_0x35d5db){_0x407e57[_0xc1dc('0x31')]=_[_0xc1dc('0x32')](db[_0xc1dc('0x95')][_0xc1dc('0xc1')]);_0x407e57['query']=_['keys'](_0x44ad9d[_0xc1dc('0x33')]);_0x407e57[_0xc1dc('0x39')]=_[_0xc1dc('0x35')](_0x407e57[_0xc1dc('0x31')],_0x407e57[_0xc1dc('0x33')]);_0x874dcf[_0xc1dc('0x34')]=_[_0xc1dc('0x35')](_0x407e57['model'],qs[_0xc1dc('0x36')](_0x44ad9d['query']['fields']));_0x874dcf['attributes']=_0x874dcf[_0xc1dc('0x34')]['length']?_0x874dcf[_0xc1dc('0x34')]:_0x407e57[_0xc1dc('0x31')];if(!_0x44ad9d['query'][_0xc1dc('0x56')](_0xc1dc('0x37'))){_0x874dcf['limit']=qs['limit'](_0x44ad9d[_0xc1dc('0x33')][_0xc1dc('0x1b')]);_0x874dcf[_0xc1dc('0x1a')]=qs[_0xc1dc('0x1a')](_0x44ad9d[_0xc1dc('0x33')][_0xc1dc('0x1a')]);}_0x874dcf[_0xc1dc('0xc6')]=qs[_0xc1dc('0xc2')](_0x44ad9d[_0xc1dc('0x33')][_0xc1dc('0xc2')]);_0x874dcf[_0xc1dc('0x38')]=qs[_0xc1dc('0x39')](_[_0xc1dc('0xc3')](_0x44ad9d['query'],_0x407e57[_0xc1dc('0x39')]));_0x874dcf[_0xc1dc('0x38')][_0xc1dc('0xc7')]=_0x35d5db['id'];if(_0x44ad9d['query']['filter']){_0x874dcf['where']=_['merge'](_0x874dcf[_0xc1dc('0x38')],{'$or':_[_0xc1dc('0x4b')](_0x874dcf[_0xc1dc('0x34')],function(_0xfe727b){var _0x211454={};_0x211454[_0xfe727b]={'$like':'%'+_0x44ad9d[_0xc1dc('0x33')][_0xc1dc('0x57')]+'%'};return _0x211454;})});}_0x874dcf=_[_0xc1dc('0x7b')]({},_0x874dcf,_0x44ad9d[_0xc1dc('0xc8')]);return db[_0xc1dc('0x95')][_0xc1dc('0x79')]({'where':_0x874dcf[_0xc1dc('0x38')]})[_0xc1dc('0x22')](function(_0x49242a){_0x55836f['count']=_0x49242a;if(_0x44ad9d[_0xc1dc('0x33')][_0xc1dc('0xc9')]){_0x874dcf['include']=[{'all':!![]}];}return db['CmHopper']['findAll'](_0x874dcf);})[_0xc1dc('0x22')](function(_0x411b8f){_0x55836f[_0xc1dc('0x84')]=_0x411b8f;return _0x55836f;});}})[_0xc1dc('0x22')](respondWithFilteredResult(_0x33b88d,_0x874dcf))[_0xc1dc('0x8e')](handleError(_0x33b88d,null));};exports[_0xc1dc('0xca')]=function(_0x226323,_0x1766cd,_0x25bb01){var _0x56794f={'raw':!![],'where':{}};var _0x48371a={};var _0x2d4928={'count':0x0,'rows':[]};return db[_0xc1dc('0x7c')][_0xc1dc('0xc0')]({'where':{'id':_0x226323[_0xc1dc('0x85')]['id']}})['then'](handleEntityNotFound(_0x1766cd,null))[_0xc1dc('0x22')](function(_0x581f5b){if(_0x581f5b){_0x48371a[_0xc1dc('0x31')]=_[_0xc1dc('0x32')](db[_0xc1dc('0xa7')][_0xc1dc('0xc1')]);_0x48371a[_0xc1dc('0x33')]=_['keys'](_0x226323[_0xc1dc('0x33')]);_0x48371a[_0xc1dc('0x39')]=_[_0xc1dc('0x35')](_0x48371a[_0xc1dc('0x31')],_0x48371a[_0xc1dc('0x33')]);_0x56794f[_0xc1dc('0x34')]=_[_0xc1dc('0x35')](_0x48371a[_0xc1dc('0x31')],qs['fields'](_0x226323[_0xc1dc('0x33')][_0xc1dc('0x36')]));_0x56794f[_0xc1dc('0x34')]=_0x56794f[_0xc1dc('0x34')][_0xc1dc('0x2f')]?_0x56794f['attributes']:_0x48371a[_0xc1dc('0x31')];if(!_0x226323[_0xc1dc('0x33')][_0xc1dc('0x56')](_0xc1dc('0x37'))){_0x56794f[_0xc1dc('0x1b')]=qs[_0xc1dc('0x1b')](_0x226323[_0xc1dc('0x33')][_0xc1dc('0x1b')]);_0x56794f['offset']=qs['offset'](_0x226323[_0xc1dc('0x33')][_0xc1dc('0x1a')]);}_0x56794f['order']=qs[_0xc1dc('0xc2')](_0x226323[_0xc1dc('0x33')]['sort']);_0x56794f[_0xc1dc('0x38')]=qs[_0xc1dc('0x39')](_[_0xc1dc('0xc3')](_0x226323[_0xc1dc('0x33')],_0x48371a[_0xc1dc('0x39')]));_0x56794f['where'][_0xc1dc('0xc7')]=_0x581f5b['id'];if(_0x226323[_0xc1dc('0x33')][_0xc1dc('0x57')]){_0x56794f['where']=_[_0xc1dc('0x7b')](_0x56794f[_0xc1dc('0x38')],{'$or':_[_0xc1dc('0x4b')](_0x56794f['attributes'],function(_0x3fb4c7){var _0x2c08f7={};_0x2c08f7[_0x3fb4c7]={'$like':'%'+_0x226323[_0xc1dc('0x33')]['filter']+'%'};return _0x2c08f7;})});}_0x56794f=_['merge']({},_0x56794f,_0x226323[_0xc1dc('0xc8')]);return db['CmHopperHistory'][_0xc1dc('0x79')]({'where':_0x56794f[_0xc1dc('0x38')]})[_0xc1dc('0x22')](function(_0x155abb){_0x2d4928[_0xc1dc('0x79')]=_0x155abb;if(_0x226323[_0xc1dc('0x33')][_0xc1dc('0xc9')]){_0x56794f[_0xc1dc('0xcb')]=[{'all':!![]}];}return db[_0xc1dc('0xa7')][_0xc1dc('0x8a')](_0x56794f);})[_0xc1dc('0x22')](function(_0x4b468c){_0x2d4928[_0xc1dc('0x84')]=_0x4b468c;return _0x2d4928;});}})[_0xc1dc('0x22')](respondWithFilteredResult(_0x1766cd,_0x56794f))['catch'](handleError(_0x1766cd,null));};exports[_0xc1dc('0xcc')]=function(_0x2a3912,_0x55bfd7,_0x5e7e56){var _0x30bde0={'raw':!![],'where':{}};var _0x262c3d={};var _0x2e6f68={'count':0x0,'rows':[]};return db[_0xc1dc('0x7c')][_0xc1dc('0xc0')]({'where':{'id':_0x2a3912['params']['id']}})[_0xc1dc('0x22')](handleEntityNotFound(_0x55bfd7,null))['then'](function(_0x5761b9){if(_0x5761b9){_0x262c3d[_0xc1dc('0x31')]=_['keys'](db[_0xc1dc('0xa6')]['rawAttributes']);_0x262c3d[_0xc1dc('0x33')]=_[_0xc1dc('0x32')](_0x2a3912[_0xc1dc('0x33')]);_0x262c3d[_0xc1dc('0x39')]=_[_0xc1dc('0x35')](_0x262c3d['model'],_0x262c3d[_0xc1dc('0x33')]);_0x30bde0['attributes']=_[_0xc1dc('0x35')](_0x262c3d[_0xc1dc('0x31')],qs['fields'](_0x2a3912['query'][_0xc1dc('0x36')]));_0x30bde0[_0xc1dc('0x34')]=_0x30bde0[_0xc1dc('0x34')][_0xc1dc('0x2f')]?_0x30bde0[_0xc1dc('0x34')]:_0x262c3d[_0xc1dc('0x31')];if(!_0x2a3912[_0xc1dc('0x33')][_0xc1dc('0x56')](_0xc1dc('0x37'))){_0x30bde0['limit']=qs[_0xc1dc('0x1b')](_0x2a3912[_0xc1dc('0x33')][_0xc1dc('0x1b')]);_0x30bde0[_0xc1dc('0x1a')]=qs[_0xc1dc('0x1a')](_0x2a3912[_0xc1dc('0x33')]['offset']);}_0x30bde0[_0xc1dc('0xc6')]=qs[_0xc1dc('0xc2')](_0x2a3912[_0xc1dc('0x33')][_0xc1dc('0xc2')]);_0x30bde0[_0xc1dc('0x38')]=qs[_0xc1dc('0x39')](_[_0xc1dc('0xc3')](_0x2a3912[_0xc1dc('0x33')],_0x262c3d[_0xc1dc('0x39')]));_0x30bde0[_0xc1dc('0x38')][_0xc1dc('0xc7')]=_0x5761b9['id'];if(_0x2a3912[_0xc1dc('0x33')][_0xc1dc('0x57')]){_0x30bde0['where']=_['merge'](_0x30bde0['where'],{'$or':_[_0xc1dc('0x4b')](_0x30bde0[_0xc1dc('0x34')],function(_0x847c72){var _0x26f9c1={};_0x26f9c1[_0x847c72]={'$like':'%'+_0x2a3912['query'][_0xc1dc('0x57')]+'%'};return _0x26f9c1;})});}_0x30bde0=_[_0xc1dc('0x7b')]({},_0x30bde0,_0x2a3912[_0xc1dc('0xc8')]);return db[_0xc1dc('0xa6')][_0xc1dc('0x79')]({'where':_0x30bde0[_0xc1dc('0x38')]})['then'](function(_0x552228){_0x2e6f68['count']=_0x552228;if(_0x2a3912['query'][_0xc1dc('0xc9')]){_0x30bde0['include']=[{'all':!![]}];}return db['CmHopperFinal'][_0xc1dc('0x8a')](_0x30bde0);})[_0xc1dc('0x22')](function(_0x523771){_0x2e6f68[_0xc1dc('0x84')]=_0x523771;return _0x2e6f68;});}})[_0xc1dc('0x22')](respondWithFilteredResult(_0x55bfd7,_0x30bde0))['catch'](handleError(_0x55bfd7,null));};exports[_0xc1dc('0xcd')]=function(_0x4bb6f7,_0x1eefc9,_0x3fb366){var _0xc8b927={'raw':!![],'where':{}};var _0x2b8012={};var _0x206ee8={'count':0x0,'rows':[]};return db[_0xc1dc('0x7c')][_0xc1dc('0xc0')]({'where':{'id':_0x4bb6f7[_0xc1dc('0x85')]['id']}})[_0xc1dc('0x22')](handleEntityNotFound(_0x1eefc9,null))[_0xc1dc('0x22')](function(_0x5a3449){if(_0x5a3449){_0x2b8012[_0xc1dc('0x31')]=_[_0xc1dc('0x32')](db[_0xc1dc('0xce')][_0xc1dc('0xc1')]);_0x2b8012['query']=_[_0xc1dc('0x32')](_0x4bb6f7['query']);_0x2b8012[_0xc1dc('0x39')]=_[_0xc1dc('0x35')](_0x2b8012[_0xc1dc('0x31')],_0x2b8012[_0xc1dc('0x33')]);_0xc8b927[_0xc1dc('0x34')]=_[_0xc1dc('0x35')](_0x2b8012['model'],qs[_0xc1dc('0x36')](_0x4bb6f7[_0xc1dc('0x33')][_0xc1dc('0x36')]));_0xc8b927[_0xc1dc('0x34')]=_0xc8b927[_0xc1dc('0x34')][_0xc1dc('0x2f')]?_0xc8b927[_0xc1dc('0x34')]:_0x2b8012['model'];if(!_0x4bb6f7['query']['hasOwnProperty'](_0xc1dc('0x37'))){_0xc8b927['limit']=qs[_0xc1dc('0x1b')](_0x4bb6f7['query'][_0xc1dc('0x1b')]);_0xc8b927[_0xc1dc('0x1a')]=qs[_0xc1dc('0x1a')](_0x4bb6f7[_0xc1dc('0x33')][_0xc1dc('0x1a')]);}_0xc8b927['order']=qs[_0xc1dc('0xc2')](_0x4bb6f7[_0xc1dc('0x33')][_0xc1dc('0xc2')]);_0xc8b927[_0xc1dc('0x38')]=qs[_0xc1dc('0x39')](_[_0xc1dc('0xc3')](_0x4bb6f7[_0xc1dc('0x33')],_0x2b8012[_0xc1dc('0x39')]));_0xc8b927['where'][_0xc1dc('0xc7')]=_0x5a3449['id'];if(_0x4bb6f7['query'][_0xc1dc('0x57')]){_0xc8b927[_0xc1dc('0x38')]=_['merge'](_0xc8b927[_0xc1dc('0x38')],{'$or':_[_0xc1dc('0x4b')](_0xc8b927[_0xc1dc('0x34')],function(_0x40aef8){var _0x4473c3={};_0x4473c3[_0x40aef8]={'$like':'%'+_0x4bb6f7['query'][_0xc1dc('0x57')]+'%'};return _0x4473c3;})});}_0xc8b927=_[_0xc1dc('0x7b')]({},_0xc8b927,_0x4bb6f7[_0xc1dc('0xc8')]);return db['JscriptySessionReport'][_0xc1dc('0x79')]({'where':_0xc8b927['where']})[_0xc1dc('0x22')](function(_0x2f52bc){_0x206ee8[_0xc1dc('0x79')]=_0x2f52bc;if(_0x4bb6f7[_0xc1dc('0x33')][_0xc1dc('0xc9')]){_0xc8b927['include']=[{'all':!![]}];}return db['JscriptySessionReport'][_0xc1dc('0x8a')](_0xc8b927);})[_0xc1dc('0x22')](function(_0x29f02d){_0x206ee8[_0xc1dc('0x84')]=_0x29f02d;return _0x206ee8;});}})[_0xc1dc('0x22')](respondWithFilteredResult(_0x1eefc9,_0xc8b927))[_0xc1dc('0x8e')](handleError(_0x1eefc9,null));};exports[_0xc1dc('0xcf')]=function(_0x891603,_0x5429ad,_0x1f0855){try{if(!_0x891603[_0xc1dc('0x8f')][_0xc1dc('0x5a')]){throw new Error(_0xc1dc('0xd0'));}if(!_0x891603[_0xc1dc('0x8f')]['binding_keys']){throw new Error(_0xc1dc('0xd1'));}if(!_0x891603[_0xc1dc('0x8f')][_0xc1dc('0xd2')]){throw new Error('No\x20association\x20values\x20specified!');}if(!_0x891603[_0xc1dc('0x8f')][_0xc1dc('0xd3')]){throw new Error(_0xc1dc('0xd4'));}var _0x23edbd=_0x891603[_0xc1dc('0x8f')][_0xc1dc('0xd5')][_0xc1dc('0x4a')](',');var _0x265436=_0x891603[_0xc1dc('0x8f')]['binding_values']['split'](',');if(!_0x23edbd[_0xc1dc('0x2f')]||!_0x265436[_0xc1dc('0x2f')]||_0x23edbd[_0xc1dc('0x2f')]!==_0x265436[_0xc1dc('0x2f')]){throw new Error(_0xc1dc('0xd6'));}_0x891603[_0xc1dc('0x8f')][_0xc1dc('0x36')]=_[_0xc1dc('0xd7')](_0x23edbd,_0x265436);if(!_0x891603['body'][_0xc1dc('0x36')][_0xc1dc('0xbe')]){throw new Error(_0xc1dc('0xd8'));}if(!_0x891603['body'][_0xc1dc('0x36')][_0xc1dc('0xd9')]){throw new Error(_0xc1dc('0xda'));}var _0x4d46f8=path['join'](config['root'],_0xc1dc('0xdb'),_0x891603['file']['filename']);fs[_0xc1dc('0xdc')](_0x4d46f8,parseInt('0777',0x8));var _0x44c0a4=require(_0xc1dc('0xdd'))[_0xc1dc('0xde')](path[_0xc1dc('0x93')](__dirname,'../../components/import/cm/csv'),[_0x4d46f8,_0x891603[_0xc1dc('0x8f')][_0xc1dc('0xd5')],_0x891603[_0xc1dc('0x8f')][_0xc1dc('0xd2')],_0x891603['body'][_0xc1dc('0x5a')],_0x891603['body'][_0xc1dc('0xdf')],_0x891603[_0xc1dc('0x8f')]['duplicates'],_0x891603[_0xc1dc('0x8f')]['socket_timestamp']]);return _0x5429ad[_0xc1dc('0x18')](0xc8)['json']({'message':_0xc1dc('0xe0'),'pid':_0x44c0a4[_0xc1dc('0xe1')]});}catch(_0x33e244){return _0x5429ad[_0xc1dc('0x18')](0x1f4)[_0xc1dc('0x27')](_0x33e244);}};exports[_0xc1dc('0xe2')]=function(_0x124ee5,_0x4214c2,_0xf191f9){var _0x1089b0=fs[_0xc1dc('0xe3')](_0x124ee5[_0xc1dc('0xe4')][_0xc1dc('0x6')]);Papa[_0xc1dc('0xe5')](_0x1089b0,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x173c7a){return _0x4214c2[_0xc1dc('0x18')](0xc8)['json']({'file':_0x124ee5[_0xc1dc('0xe4')],'fields':_0x173c7a[_0xc1dc('0xe6')]['fields']});}});};exports[_0xc1dc('0xe7')]=function(_0x433fab,_0x2d6a9d,_0x499a8b){return db['User']['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0xc1dc('0xe8')}})[_0xc1dc('0x22')](function(_0x30114b){var _0x2b859a=![];if(!_0x433fab[_0xc1dc('0x8f')][_0xc1dc('0x5a')]){throw new Error(_0xc1dc('0xd0'));}if(!_0x433fab[_0xc1dc('0x8f')]['binding'][_0xc1dc('0xbe')]){throw new Error(_0xc1dc('0xd8'));}if(!_0x433fab[_0xc1dc('0x8f')][_0xc1dc('0xe9')][_0xc1dc('0xd9')]){throw new Error(_0xc1dc('0xda'));}if(!_0x433fab[_0xc1dc('0x8f')][_0xc1dc('0xd3')]){throw new Error(_0xc1dc('0xd4'));}var _0x1dce00=require('child_process')[_0xc1dc('0xde')](path[_0xc1dc('0x93')](__dirname,_0xc1dc('0xea')),[_0x433fab[_0xc1dc('0x85')]['id'],JSON[_0xc1dc('0xeb')](_0x433fab[_0xc1dc('0x8f')]),JSON[_0xc1dc('0xeb')](_0x30114b)]);_0x1dce00['on']('message',function(_0x4e43fb){_0x2b859a=!![];return _0x2d6a9d[_0xc1dc('0x18')](0xc8)[_0xc1dc('0x19')]({'message':'start\x20child\x20process\x20correctly!','pid':_0x1dce00[_0xc1dc('0xe1')]});});_0x1dce00['on'](_0xc1dc('0xec'),function(_0x44db58){if(_0x44db58&&!_0x2b859a){return _0x2d6a9d['status'](0x1f4)[_0xc1dc('0x19')]({'message':'error\x20child\x20process','pid':_0x1dce00[_0xc1dc('0xe1')]});}});})['catch'](handleError(_0x2d6a9d,null));};
git://repos.xcallymotion.com / motion2.git / blob