// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x2686=['clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','cross_join','COUNT(%s)','getFields','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','select','from','replace','output','web','fullPath','%s-%s.%s','randomstring','csv','default','AnalyticExtractedReport','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','info','Run\x20Query:','child_process','fork','../../files/reports','savename','countTable','runReport','UNIX_TIMESTAMP(%s)','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','sox','fs-extra','lodash','squel','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/utils','../../config/environment','../../mysqldb','dbH','status','end','json','offset','undefined','count','set','reject','update','then','destroy','get','UserProfileResource','sendStatus','error','stack','name','send','render','merge','contact','message','agent','interaction','account','index','map','AnalyticDefaultReport','fieldName','key','query','keys','filters','intersection','model','attributes','fields','hasOwnProperty','limit','order','sort','where','VIRTUAL','filter','options','includeAll','include','findAll','rows','catch','params','rawAttributes','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','UserProfileSection','userProfileId','preview','join','right_join','SUM(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','DATE(%s)','HOUR(%s)','ROUND(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','length','operator','field','condition','value','Sequelize','keyBy','MetricId','metric','function','format','groupBy','orderBy','DESC','alias','joins','parse','type','parentKey','foreignTable','%s.%s\x20=\x20%s.%s','table','foreignKey','conditions','group'];(function(_0x16dbfd,_0x2f9431){var _0x382254=function(_0x19dade){while(--_0x19dade){_0x16dbfd['push'](_0x16dbfd['shift']());}};_0x382254(++_0x2f9431);}(_0x2686,0x174));var _0x6268=function(_0x5e8f5b,_0x201aaa){_0x5e8f5b=_0x5e8f5b-0x0;var _0x57c450=_0x2686[_0x5e8f5b];return _0x57c450;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x6268('0x0'));var zipdir=require(_0x6268('0x1'));var jsonpatch=require(_0x6268('0x2'));var rp=require(_0x6268('0x3'));var moment=require(_0x6268('0x4'));var BPromise=require(_0x6268('0x5'));var Mustache=require('mustache');var util=require(_0x6268('0x6'));var path=require(_0x6268('0x7'));var sox=require(_0x6268('0x8'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x6268('0x9'));var _=require(_0x6268('0xa'));var squel=require(_0x6268('0xb'));var crypto=require('crypto');var jsforce=require(_0x6268('0xc'));var deskjs=require(_0x6268('0xd'));var toCsv=require(_0x6268('0xe'));var querystring=require(_0x6268('0xf'));var Papa=require(_0x6268('0x10'));var Redis=require(_0x6268('0x11'));var authService=require('../../components/auth/service');var qs=require(_0x6268('0x12'));var as=require(_0x6268('0x13'));var hardwareService=require(_0x6268('0x14'));var logger=require('../../config/logger')('api');var utils=require(_0x6268('0x15'));var config=require(_0x6268('0x16'));var licenseUtil=require('../../config/license/util');var db=require(_0x6268('0x17'))['db'];var dbH=require('../../mysqldb')[_0x6268('0x18')];function respondWithStatusCode(_0xa92856,_0x4dbf7a){_0x4dbf7a=_0x4dbf7a||0xcc;return function(_0x210eec){if(_0x210eec){return _0xa92856['sendStatus'](_0x4dbf7a);}return _0xa92856[_0x6268('0x19')](_0x4dbf7a)[_0x6268('0x1a')]();};}function respondWithResult(_0x3d0c4f,_0x2b6499){_0x2b6499=_0x2b6499||0xc8;return function(_0xcd3381){if(_0xcd3381){return _0x3d0c4f[_0x6268('0x19')](_0x2b6499)[_0x6268('0x1b')](_0xcd3381);}};}function respondWithFilteredResult(_0x2f2a12,_0x395618){return function(_0x3f3949){if(_0x3f3949){var _0x83012=typeof _0x395618[_0x6268('0x1c')]==='undefined'&&typeof _0x395618['limit']===_0x6268('0x1d');var _0x4c9a75=_0x3f3949[_0x6268('0x1e')];var _0x501b1e=_0x83012?0x0:_0x395618[_0x6268('0x1c')];var _0x5834b7=_0x83012?_0x3f3949[_0x6268('0x1e')]:_0x395618[_0x6268('0x1c')]+_0x395618['limit'];var _0x161553;if(_0x5834b7>=_0x4c9a75){_0x5834b7=_0x4c9a75;_0x161553=0xc8;}else{_0x161553=0xce;}_0x2f2a12[_0x6268('0x19')](_0x161553);return _0x2f2a12[_0x6268('0x1f')]('Content-Range',_0x501b1e+'-'+_0x5834b7+'/'+_0x4c9a75)[_0x6268('0x1b')](_0x3f3949);}return null;};}function patchUpdates(_0x2ee6b8){return function(_0x245c95){try{jsonpatch['apply'](_0x245c95,_0x2ee6b8,!![]);}catch(_0x55c60d){return BPromise[_0x6268('0x20')](_0x55c60d);}return _0x245c95['save']();};}function saveUpdates(_0x4a18b0,_0x27bbe7){return function(_0x5a2541){if(_0x5a2541){return _0x5a2541[_0x6268('0x21')](_0x4a18b0)[_0x6268('0x22')](function(_0x391ecc){return _0x391ecc;});}return null;};}function removeEntity(_0x54a963,_0x4db3b0){return function(_0x245795){if(_0x245795){return _0x245795[_0x6268('0x23')]()['then'](function(){var _0x5ce386=_0x245795[_0x6268('0x24')]({'plain':!![]});var _0x7bb687='DefaultReports';return db[_0x6268('0x25')][_0x6268('0x23')]({'where':{'type':_0x7bb687,'resourceId':_0x5ce386['id']}})[_0x6268('0x22')](function(){return _0x245795;});})[_0x6268('0x22')](function(){_0x54a963['status'](0xcc)[_0x6268('0x1a')]();});}};}function handleEntityNotFound(_0x3fb899,_0xb28670){return function(_0x1b4502){if(!_0x1b4502){_0x3fb899[_0x6268('0x26')](0x194);}return _0x1b4502;};}function handleError(_0x30f111,_0x271bc1){_0x271bc1=_0x271bc1||0x1f4;return function(_0x3a55d4){logger[_0x6268('0x27')](_0x3a55d4[_0x6268('0x28')]);if(_0x3a55d4['name']){delete _0x3a55d4[_0x6268('0x29')];}_0x30f111[_0x6268('0x19')](_0x271bc1)[_0x6268('0x2a')](_0x3a55d4);};}function getMustacheRender(_0x101f95,_0x48b1a8){return Mustache[_0x6268('0x2b')](_0x101f95,_[_0x6268('0x2c')](_0x48b1a8['body'],{'contact':_0x48b1a8[_0x6268('0x2d')],'message':_0x48b1a8[_0x6268('0x2e')],'agent':_0x48b1a8[_0x6268('0x2f')],'interaction':_0x48b1a8[_0x6268('0x30')],'account':_0x48b1a8[_0x6268('0x31')]}))||'';}exports[_0x6268('0x32')]=function(_0x16f405,_0xf7b2cd){var _0x5e8286={},_0x2b0b67={},_0x4f9512={'count':0x0,'rows':[]};var _0x367c7d=_[_0x6268('0x33')](db[_0x6268('0x34')]['rawAttributes'],function(_0xb19dde){return{'name':_0xb19dde[_0x6268('0x35')],'type':_0xb19dde['type'][_0x6268('0x36')]};});_0x2b0b67['model']=_[_0x6268('0x33')](_0x367c7d,_0x6268('0x29'));_0x2b0b67[_0x6268('0x37')]=_[_0x6268('0x38')](_0x16f405[_0x6268('0x37')]);_0x2b0b67[_0x6268('0x39')]=_[_0x6268('0x3a')](_0x2b0b67[_0x6268('0x3b')],_0x2b0b67['query']);_0x5e8286[_0x6268('0x3c')]=_[_0x6268('0x3a')](_0x2b0b67[_0x6268('0x3b')],qs[_0x6268('0x3d')](_0x16f405[_0x6268('0x37')]['fields']));_0x5e8286[_0x6268('0x3c')]=_0x5e8286[_0x6268('0x3c')]['length']?_0x5e8286[_0x6268('0x3c')]:_0x2b0b67['model'];if(!_0x16f405[_0x6268('0x37')][_0x6268('0x3e')]('nolimit')){_0x5e8286[_0x6268('0x3f')]=qs[_0x6268('0x3f')](_0x16f405[_0x6268('0x37')][_0x6268('0x3f')]);_0x5e8286['offset']=qs[_0x6268('0x1c')](_0x16f405[_0x6268('0x37')][_0x6268('0x1c')]);}_0x5e8286[_0x6268('0x40')]=qs[_0x6268('0x41')](_0x16f405['query']['sort']);_0x5e8286[_0x6268('0x42')]=qs[_0x6268('0x39')](_['pick'](_0x16f405[_0x6268('0x37')],_0x2b0b67[_0x6268('0x39')]),_0x367c7d);if(_0x16f405['query']['filter']){_0x5e8286[_0x6268('0x42')]=_['merge'](_0x5e8286[_0x6268('0x42')],{'$or':_['map'](_0x367c7d,function(_0x25c340){if(_0x25c340['type']!==_0x6268('0x43')){var _0x10afea={};_0x10afea[_0x25c340[_0x6268('0x29')]]={'$like':'%'+_0x16f405[_0x6268('0x37')][_0x6268('0x44')]+'%'};return _0x10afea;}})});}_0x5e8286=_[_0x6268('0x2c')]({},_0x5e8286,_0x16f405[_0x6268('0x45')]);var _0xfbd5ba={'where':_0x5e8286[_0x6268('0x42')]};return db[_0x6268('0x34')][_0x6268('0x1e')](_0xfbd5ba)['then'](function(_0x4e5253){_0x4f9512[_0x6268('0x1e')]=_0x4e5253;if(_0x16f405[_0x6268('0x37')][_0x6268('0x46')]){_0x5e8286[_0x6268('0x47')]=[{'all':!![]}];}return db['AnalyticDefaultReport'][_0x6268('0x48')](_0x5e8286);})['then'](function(_0x52710b){_0x4f9512[_0x6268('0x49')]=_0x52710b;return _0x4f9512;})[_0x6268('0x22')](respondWithFilteredResult(_0xf7b2cd,_0x5e8286))[_0x6268('0x4a')](handleError(_0xf7b2cd,null));};exports['show']=function(_0x40a26e,_0x462228){var _0x37bd05={'raw':!![],'where':{'id':_0x40a26e[_0x6268('0x4b')]['id']}},_0x62c917={};_0x62c917[_0x6268('0x3b')]=_[_0x6268('0x38')](db['AnalyticDefaultReport'][_0x6268('0x4c')]);_0x62c917['query']=_[_0x6268('0x38')](_0x40a26e[_0x6268('0x37')]);_0x62c917[_0x6268('0x39')]=_[_0x6268('0x3a')](_0x62c917[_0x6268('0x3b')],_0x62c917[_0x6268('0x37')]);_0x37bd05['attributes']=_['intersection'](_0x62c917[_0x6268('0x3b')],qs[_0x6268('0x3d')](_0x40a26e[_0x6268('0x37')][_0x6268('0x3d')]));_0x37bd05[_0x6268('0x3c')]=_0x37bd05[_0x6268('0x3c')]['length']?_0x37bd05[_0x6268('0x3c')]:_0x62c917[_0x6268('0x3b')];if(_0x40a26e[_0x6268('0x37')]['includeAll']){_0x37bd05['include']=[{'all':!![]}];}_0x37bd05=_[_0x6268('0x2c')]({},_0x37bd05,_0x40a26e[_0x6268('0x45')]);return db[_0x6268('0x34')][_0x6268('0x4d')](_0x37bd05)[_0x6268('0x22')](handleEntityNotFound(_0x462228,null))[_0x6268('0x22')](respondWithResult(_0x462228,null))[_0x6268('0x4a')](handleError(_0x462228,null));};exports[_0x6268('0x4e')]=function(_0x54621c,_0x2ebec8){return db[_0x6268('0x34')][_0x6268('0x4e')](_0x54621c[_0x6268('0x4f')],{})['then'](function(_0x4bcc6b){var _0x5a911d=_0x54621c[_0x6268('0x50')][_0x6268('0x24')]({'plain':!![]});if(!_0x5a911d)throw new Error(_0x6268('0x51'));if(_0x5a911d[_0x6268('0x52')]===_0x6268('0x50')){var _0x379390=_0x4bcc6b[_0x6268('0x24')]({'plain':!![]});var _0xf75eed=_0x6268('0x53');return db[_0x6268('0x54')][_0x6268('0x4d')]({'where':{'name':_0xf75eed,'userProfileId':_0x5a911d[_0x6268('0x55')]},'raw':!![]})[_0x6268('0x22')](function(_0x53d139){if(_0x53d139&&_0x53d139['autoAssociation']===0x0){return db[_0x6268('0x25')]['create']({'name':_0x379390[_0x6268('0x29')],'resourceId':_0x379390['id'],'type':'DefaultReports','sectionId':_0x53d139['id']},{})['then'](function(){return _0x4bcc6b;});}else{return _0x4bcc6b;}})['catch'](function(_0x29985c){logger[_0x6268('0x27')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x29985c);throw _0x29985c;});}return _0x4bcc6b;})[_0x6268('0x22')](respondWithResult(_0x2ebec8,0xc9))[_0x6268('0x4a')](handleError(_0x2ebec8,null));};exports[_0x6268('0x21')]=function(_0x317db9,_0x5a7257){if(_0x317db9[_0x6268('0x4f')]['id']){delete _0x317db9['body']['id'];}return db[_0x6268('0x34')][_0x6268('0x4d')]({'where':{'id':_0x317db9[_0x6268('0x4b')]['id']}})[_0x6268('0x22')](handleEntityNotFound(_0x5a7257,null))[_0x6268('0x22')](saveUpdates(_0x317db9[_0x6268('0x4f')],null))['then'](respondWithResult(_0x5a7257,null))['catch'](handleError(_0x5a7257,null));};exports[_0x6268('0x23')]=function(_0x321d4b,_0x24488c){return db[_0x6268('0x34')][_0x6268('0x4d')]({'where':{'id':_0x321d4b['params']['id']}})[_0x6268('0x22')](handleEntityNotFound(_0x24488c,null))[_0x6268('0x22')](removeEntity(_0x24488c,null))[_0x6268('0x4a')](handleError(_0x24488c,null));};exports[_0x6268('0x56')]=function(_0x29c325,_0x501790){var _0x3a10a8=0xa;var _0x1dc8fd=[_0x6268('0x57'),'left_join',_0x6268('0x58'),'cross_join'];var _0x26a709={'SUM':_0x6268('0x59'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x6268('0x5a'),'MAX':_0x6268('0x5b'),'MIN':_0x6268('0x5c'),'AVG':_0x6268('0x5d'),'GROUP_CONCAT':_0x6268('0x5e'),'GROUP_CONCAT ASC':_0x6268('0x5f'),'GROUP_CONCAT DESC':_0x6268('0x60')};var _0x30510e={'SEC_TO_TIME':_0x6268('0x61'),'DATE':_0x6268('0x62'),'HOUR':_0x6268('0x63'),'ROUND':_0x6268('0x64'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x6e1082=function(_0x8d0314){return!_[_0x6268('0x65')]([_0x6268('0x66'),_0x6268('0x67'),_0x6268('0x68'),_0x6268('0x69')],_0x8d0314);};var _0xbb0353=function(_0x4588d6){if(!_0x4588d6||!_0x4588d6[_0x6268('0x6a')][_0x6268('0x6b')]){return'';}for(var _0x2f611c='(',_0x2fc683=0x0;_0x2fc683<_0x4588d6[_0x6268('0x6a')]['length'];_0x2fc683+=0x1){_0x2fc683>0x0&&(_0x2f611c+='\x20'+_0x4588d6[_0x6268('0x6c')]+'\x20');_0x2f611c+=_0x4588d6['rules'][_0x2fc683]['group']?_0xbb0353(_0x4588d6['rules'][_0x2fc683]['group']):_0x4588d6[_0x6268('0x6a')][_0x2fc683][_0x6268('0x6d')]+'\x20'+_0x4588d6[_0x6268('0x6a')][_0x2fc683][_0x6268('0x6e')]+(_0x6e1082(_0x4588d6[_0x6268('0x6a')][_0x2fc683][_0x6268('0x6e')])?'\x20'+_0x4588d6['rules'][_0x2fc683][_0x6268('0x6f')]:'');}return _0x2f611c+')';};var _0x1c3384={'where':{'id':_0x29c325[_0x6268('0x4b')]['id']}},_0x1e9ec7,_0x16573e,_0x165925,_0x5ac46f,_0x31d0b7;_0x1c3384=_[_0x6268('0x2c')]({},_0x1c3384,_0x29c325[_0x6268('0x45')]);return db[_0x6268('0x34')][_0x6268('0x4d')](_0x1c3384)[_0x6268('0x22')](function(_0x419b38){if(_0x419b38){_0x1e9ec7=_0x419b38;return _0x419b38['getFields']();}return null;})[_0x6268('0x22')](function(_0x5a25f9){if(_0x5a25f9){if(!_0x5a25f9[_0x6268('0x6b')]){throw new db[(_0x6268('0x70'))]['ValidationErrorItem']('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x16573e=_0x5a25f9;return db['AnalyticMetric'][_0x6268('0x48')]({'raw':!![]});}return null;})[_0x6268('0x22')](function(_0x4fb3fa){if(_0x4fb3fa){_0x165925=_[_0x6268('0x71')](_0x4fb3fa,'id');var _0x247f0a;var _0x506f84=squel['select']();_0x506f84['from'](_0x1e9ec7['table']);for(var _0x1872e5=0x0;_0x1872e5<_0x16573e['length'];_0x1872e5+=0x1){_0x247f0a=_0x16573e[_0x1872e5][_0x6268('0x72')]?_0x165925[_0x16573e[_0x1872e5][_0x6268('0x72')]][_0x6268('0x73')]:_0x16573e[_0x1872e5][_0x6268('0x6d')];_0x247f0a=_0x16573e[_0x1872e5][_0x6268('0x74')]?_['replace'](_0x26a709[_0x16573e[_0x1872e5][_0x6268('0x74')]],'%s',_0x247f0a):_0x247f0a;_0x247f0a=_0x16573e[_0x1872e5][_0x6268('0x75')]?_['replace'](_0x30510e[_0x16573e[_0x1872e5][_0x6268('0x75')]],'%s',_0x247f0a):_0x247f0a;if(_0x16573e[_0x1872e5][_0x6268('0x76')]){_0x506f84['group'](_0x247f0a);}_0x16573e[_0x1872e5][_0x6268('0x77')]&&_0x506f84[_0x6268('0x40')](_0x247f0a,_0x16573e[_0x1872e5][_0x6268('0x77')]===_0x6268('0x78')?![]:!![]);_0x506f84['field'](_0x247f0a,_0x16573e[_0x1872e5][_0x6268('0x79')]||_0x247f0a);}if(_0x1e9ec7[_0x6268('0x7a')]){_0x1e9ec7[_0x6268('0x7a')]=JSON[_0x6268('0x7b')](_0x1e9ec7[_0x6268('0x7a')]);for(var _0x29347c=0x0;_0x29347c<_0x1e9ec7[_0x6268('0x7a')][_0x6268('0x6b')];_0x29347c+=0x1){if(_0x1e9ec7[_0x6268('0x7a')][_0x29347c]['type']&&_[_0x6268('0x65')](_0x1dc8fd,_0x1e9ec7[_0x6268('0x7a')][_0x29347c][_0x6268('0x7c')])&&_0x1e9ec7[_0x6268('0x7a')][_0x29347c][_0x6268('0x7d')]&&_0x1e9ec7[_0x6268('0x7a')][_0x29347c][_0x6268('0x7e')]&&_0x1e9ec7[_0x6268('0x7a')][_0x29347c]['foreignKey']){_0x506f84[_0x1e9ec7[_0x6268('0x7a')][_0x29347c]['type']](_0x1e9ec7[_0x6268('0x7a')][_0x29347c][_0x6268('0x7e')],null,util['format'](_0x6268('0x7f'),_0x1e9ec7[_0x6268('0x80')],_0x1e9ec7[_0x6268('0x7a')][_0x29347c][_0x6268('0x7d')],_0x1e9ec7[_0x6268('0x7a')][_0x29347c]['foreignTable'],_0x1e9ec7[_0x6268('0x7a')][_0x29347c][_0x6268('0x81')]));}}}if(_0x1e9ec7['conditions']){_0x1e9ec7['conditions']=JSON[_0x6268('0x7b')](_0x1e9ec7['conditions']);_0x506f84[_0x6268('0x42')](_0xbb0353(_0x1e9ec7[_0x6268('0x82')][_0x6268('0x83')]));}_0x31d0b7=_0x506f84[_0x6268('0x84')]();_0x506f84['limit'](_0x3a10a8);_0x506f84[_0x6268('0x1c')](0x0);logger[_0x6268('0x85')](_0x6268('0x86'),_0x506f84[_0x6268('0x87')]());return dbH['sequelize'][_0x6268('0x37')](_0x506f84['toString'](),{'type':dbH[_0x6268('0x88')][_0x6268('0x89')][_0x6268('0x8a')]});}})[_0x6268('0x22')](respondWithResult(_0x501790,null))[_0x6268('0x4a')](handleError(_0x501790,null));};function runReport(_0xbba00e,_0x21475e,_0x857f4e){var _0x579b63=_0x21475e[_0x6268('0x29')];var _0x3b5f34=0xa;var _0x5998a1=[_0x6268('0x57'),'left_join',_0x6268('0x58'),_0x6268('0x8b')];var _0x3c8bfb={'SUM':_0x6268('0x59'),'COUNT':_0x6268('0x8c'),'COUNT DISTINCT':_0x6268('0x5a'),'MAX':'MAX(%s)','MIN':_0x6268('0x5c'),'AVG':_0x6268('0x5d'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0xbde59f={'SEC_TO_TIME':_0x6268('0x61'),'DATE':'DATE(%s)','HOUR':_0x6268('0x63'),'ROUND':_0x6268('0x64'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x4cb00a=function(_0x353cf0){return!_[_0x6268('0x65')](['IS\x20NULL','IS\x20NOT\x20NULL',_0x6268('0x68'),_0x6268('0x69')],_0x353cf0);};var _0x1aebe8=function(_0x16d18f){if(!_0x16d18f||!_0x16d18f['rules'][_0x6268('0x6b')]){return'';}for(var _0x14fc93='(',_0x4a51f2=0x0;_0x4a51f2<_0x16d18f[_0x6268('0x6a')][_0x6268('0x6b')];_0x4a51f2+=0x1){_0x4a51f2>0x0&&(_0x14fc93+='\x20'+_0x16d18f[_0x6268('0x6c')]+'\x20');_0x14fc93+=_0x16d18f['rules'][_0x4a51f2][_0x6268('0x83')]?_0x1aebe8(_0x16d18f[_0x6268('0x6a')][_0x4a51f2][_0x6268('0x83')]):_0x16d18f[_0x6268('0x6a')][_0x4a51f2]['field']+'\x20'+_0x16d18f[_0x6268('0x6a')][_0x4a51f2][_0x6268('0x6e')]+(_0x4cb00a(_0x16d18f[_0x6268('0x6a')][_0x4a51f2][_0x6268('0x6e')])?'\x20'+_0x16d18f[_0x6268('0x6a')][_0x4a51f2][_0x6268('0x6f')]:'');}return _0x14fc93+')';};var _0x3b306c={'where':{'id':_0xbba00e['id']}},_0x5011d4,_0x2a86bd,_0x6d2920,_0x5ecfb4,_0x52c157;_0x3b306c=_[_0x6268('0x2c')]({},_0x3b306c,_0x857f4e);return db['AnalyticDefaultReport']['find'](_0x3b306c)[_0x6268('0x22')](function(_0x6e99cb){if(_0x6e99cb){_0x5011d4=_0x6e99cb;return _0x6e99cb[_0x6268('0x8d')]();}return null;})['then'](function(_0x56f501){if(_0x56f501){if(!_0x56f501[_0x6268('0x6b')]){throw new db[(_0x6268('0x70'))][(_0x6268('0x8e'))](_0x6268('0x8f'),0x193);}_0x2a86bd=_0x56f501;return db[_0x6268('0x90')][_0x6268('0x48')]({'raw':!![]});}return null;})[_0x6268('0x22')](function(_0x1e6fe7){if(_0x1e6fe7){_0x6d2920=_[_0x6268('0x71')](_0x1e6fe7,'id');var _0x4fd6cf;var _0x106359=squel[_0x6268('0x91')]();_0x106359[_0x6268('0x92')](_0x5011d4[_0x6268('0x80')]);for(var _0x2e9350=0x0;_0x2e9350<_0x2a86bd['length'];_0x2e9350+=0x1){_0x4fd6cf=_0x2a86bd[_0x2e9350]['MetricId']?_0x6d2920[_0x2a86bd[_0x2e9350][_0x6268('0x72')]][_0x6268('0x73')]:_0x2a86bd[_0x2e9350]['field'];_0x4fd6cf=_0x2a86bd[_0x2e9350]['function']?_[_0x6268('0x93')](_0x3c8bfb[_0x2a86bd[_0x2e9350][_0x6268('0x74')]],'%s',_0x4fd6cf):_0x4fd6cf;_0x4fd6cf=_0x2a86bd[_0x2e9350][_0x6268('0x75')]?_[_0x6268('0x93')](_0xbde59f[_0x2a86bd[_0x2e9350]['format']],'%s',_0x4fd6cf):_0x4fd6cf;if(_0x2a86bd[_0x2e9350][_0x6268('0x76')]){_0x106359['group'](_0x4fd6cf);}_0x2a86bd[_0x2e9350][_0x6268('0x77')]&&_0x106359['order'](_0x4fd6cf,_0x2a86bd[_0x2e9350][_0x6268('0x77')]==='DESC'?![]:!![]);_0x106359['field'](_0x4fd6cf,_0x2a86bd[_0x2e9350][_0x6268('0x79')]||_0x4fd6cf);}if(_0x5011d4['joins']){_0x5011d4[_0x6268('0x7a')]=JSON[_0x6268('0x7b')](_0x5011d4[_0x6268('0x7a')]);for(var _0x13bfd3=0x0;_0x13bfd3<_0x5011d4['joins'][_0x6268('0x6b')];_0x13bfd3+=0x1){if(_0x5011d4[_0x6268('0x7a')][_0x13bfd3][_0x6268('0x7c')]&&_[_0x6268('0x65')](_0x5998a1,_0x5011d4[_0x6268('0x7a')][_0x13bfd3][_0x6268('0x7c')])&&_0x5011d4[_0x6268('0x7a')][_0x13bfd3]['parentKey']&&_0x5011d4[_0x6268('0x7a')][_0x13bfd3][_0x6268('0x7e')]&&_0x5011d4['joins'][_0x13bfd3][_0x6268('0x81')]){_0x106359[_0x5011d4[_0x6268('0x7a')][_0x13bfd3][_0x6268('0x7c')]](_0x5011d4[_0x6268('0x7a')][_0x13bfd3][_0x6268('0x7e')],null,util[_0x6268('0x75')](_0x6268('0x7f'),_0x5011d4[_0x6268('0x80')],_0x5011d4[_0x6268('0x7a')][_0x13bfd3]['parentKey'],_0x5011d4[_0x6268('0x7a')][_0x13bfd3][_0x6268('0x7e')],_0x5011d4['joins'][_0x13bfd3][_0x6268('0x81')]));}}}if(_0x5011d4['conditions']){_0x5011d4[_0x6268('0x82')]=JSON['parse'](_0x5011d4['conditions']);_0x106359[_0x6268('0x42')](_0x1aebe8(_0x5011d4[_0x6268('0x82')][_0x6268('0x83')]));}_0x52c157=_0x106359['clone']();_0x106359[_0x6268('0x3f')](_0x3b5f34);_0x106359[_0x6268('0x1c')](0x0);return;}})['then'](function(){if(_0x21475e[_0x6268('0x94')]===_0x6268('0x95')){return null;}var _0x1ddfb=_['merge'](_0x21475e,{'name':_0x21475e[_0x6268('0x96')]||_0x21475e[_0x6268('0x29')]||_0x5011d4['name'],'basename':_0x579b63,'savename':util[_0x6268('0x75')](_0x6268('0x97'),_0x21475e[_0x6268('0x29')]||_0x5011d4[_0x6268('0x29')],require(_0x6268('0x98'))['generate'](0x4),_0x21475e['output']||_0x6268('0x99')),'reportId':_0x5011d4['id'],'reportType':_0x6268('0x9a')});return db[_0x6268('0x9b')][_0x6268('0x4e')](_0x1ddfb,{'raw':!![]});})['then'](function(_0x2e3a4f){if(_0x5011d4[_0x6268('0x80')]==='cdr'){_0x52c157[_0x6268('0x42')](_0x5011d4['table']+_0x6268('0x9c'),_0x21475e[_0x6268('0x9d')],_0x21475e['endDate']);}else{_0x52c157[_0x6268('0x42')](_0x5011d4[_0x6268('0x80')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x21475e[_0x6268('0x9d')],_0x21475e[_0x6268('0x9e')]);}if(_0x2e3a4f){logger[_0x6268('0x9f')](_0x6268('0xa0'),_0x52c157[_0x6268('0x87')]());require(_0x6268('0xa1'))[_0x6268('0xa2')](path[_0x6268('0x57')](__dirname,'../../components/export/',_0x2e3a4f['output']),[_0x2e3a4f['id'],_0x52c157[_0x6268('0x87')](),path['join'](__dirname,_0x6268('0xa3'),_0x2e3a4f[_0x6268('0xa4')]),_0x579b63]);return _0x2e3a4f;}else{var _0x3d2e2b=squel[_0x6268('0x91')]();_0x3d2e2b[_0x6268('0x92')]('('+_0x52c157[_0x6268('0x87')]()+')',_0x6268('0xa5'));_0x3d2e2b[_0x6268('0x6d')]('COUNT(*)',_0x6268('0x1e'));_0x52c157[_0x6268('0x3f')](_0x21475e[_0x6268('0x3f')]||_0x3b5f34);_0x52c157[_0x6268('0x1c')](_0x21475e['offset']||0x0);return dbH[_0x6268('0x88')]['query'](_0x3d2e2b[_0x6268('0x87')](),{'type':dbH[_0x6268('0x88')]['QueryTypes'][_0x6268('0x8a')]})['then'](function(_0x470713){if(!_0x470713[_0x6268('0x6b')]){_0x5ecfb4=0x0;}else{_0x5ecfb4=_0x470713[0x0][_0x6268('0x1e')]||0x0;}return dbH[_0x6268('0x88')][_0x6268('0x37')](_0x52c157[_0x6268('0x87')](),{'type':dbH[_0x6268('0x88')][_0x6268('0x89')][_0x6268('0x8a')]});})[_0x6268('0x22')](function(_0x24e5e6){return{'rows':_0x24e5e6||[],'count':_0x5ecfb4};});}});}exports['run']=function(_0x475dd2,_0x4d7410){return runReport(_0x475dd2[_0x6268('0x4b')],_0x475dd2[_0x6268('0x37')],_0x475dd2['options'])[_0x6268('0x22')](respondWithResult(_0x4d7410,null))['catch'](handleError(_0x4d7410,null));};exports[_0x6268('0xa6')]=runReport;exports[_0x6268('0x37')]=function(_0x1ea30b,_0x3ea8c3){var _0x281e70=0xa;var _0x42e3c6=['join','left_join',_0x6268('0x58'),_0x6268('0x8b')];var _0x413290={'SUM':_0x6268('0x59'),'COUNT':_0x6268('0x8c'),'COUNT DISTINCT':_0x6268('0x5a'),'MAX':_0x6268('0x5b'),'MIN':_0x6268('0x5c'),'AVG':_0x6268('0x5d'),'GROUP_CONCAT':_0x6268('0x5e'),'GROUP_CONCAT ASC':_0x6268('0x5f'),'GROUP_CONCAT DESC':_0x6268('0x60')};var _0x413e6e={'SEC_TO_TIME':_0x6268('0x61'),'DATE':_0x6268('0x62'),'HOUR':_0x6268('0x63'),'ROUND':_0x6268('0x64'),'UNIX_TIMESTAMP':_0x6268('0xa7')};var _0x575dca=function(_0x371d2f){return!_[_0x6268('0x65')]([_0x6268('0x66'),_0x6268('0x67'),'IS\x20EMPTY',_0x6268('0x69')],_0x371d2f);};var _0x4a5236=function(_0x5af13e){if(!_0x5af13e||!_0x5af13e[_0x6268('0x6a')][_0x6268('0x6b')]){return'';}for(var _0x135b55='(',_0x41683a=0x0;_0x41683a<_0x5af13e[_0x6268('0x6a')]['length'];_0x41683a+=0x1){_0x41683a>0x0&&(_0x135b55+='\x20'+_0x5af13e[_0x6268('0x6c')]+'\x20');_0x135b55+=_0x5af13e[_0x6268('0x6a')][_0x41683a]['group']?_0x4a5236(_0x5af13e[_0x6268('0x6a')][_0x41683a][_0x6268('0x83')]):_0x5af13e['rules'][_0x41683a][_0x6268('0x6d')]+'\x20'+_0x5af13e[_0x6268('0x6a')][_0x41683a][_0x6268('0x6e')]+(_0x575dca(_0x5af13e[_0x6268('0x6a')][_0x41683a][_0x6268('0x6e')])?'\x20'+_0x5af13e[_0x6268('0x6a')][_0x41683a]['value']:'');}return _0x135b55+')';};var _0x2b82c2={'where':{'id':_0x1ea30b[_0x6268('0x4b')]['id']}},_0x5107b3,_0x401207,_0x3156eb,_0x4e2852,_0x1bf166;_0x2b82c2=_[_0x6268('0x2c')]({},_0x2b82c2,_0x1ea30b[_0x6268('0x45')]);return db[_0x6268('0x34')][_0x6268('0x4d')](_0x2b82c2)[_0x6268('0x22')](function(_0x2c199d){if(_0x2c199d){_0x5107b3=_0x2c199d;return _0x2c199d[_0x6268('0x8d')]();}return null;})[_0x6268('0x22')](function(_0x3f71cc){if(_0x3f71cc){if(!_0x3f71cc['length']){throw new db[(_0x6268('0x70'))][(_0x6268('0x8e'))](_0x6268('0x8f'),0x193);}_0x401207=_0x3f71cc;return db[_0x6268('0x90')][_0x6268('0x48')]({'raw':!![]});}return null;})[_0x6268('0x22')](function(_0x447ccc){if(_0x447ccc){_0x3156eb=_['keyBy'](_0x447ccc,'id');var _0x211401;var _0x3213c0=squel[_0x6268('0x91')]();_0x3213c0['from'](_0x5107b3[_0x6268('0x80')]);for(var _0x1d71f2=0x0;_0x1d71f2<_0x401207[_0x6268('0x6b')];_0x1d71f2+=0x1){_0x211401=_0x401207[_0x1d71f2]['MetricId']?_0x3156eb[_0x401207[_0x1d71f2][_0x6268('0x72')]]['metric']:_0x401207[_0x1d71f2][_0x6268('0x6d')];_0x211401=_0x401207[_0x1d71f2]['function']?_[_0x6268('0x93')](_0x413290[_0x401207[_0x1d71f2][_0x6268('0x74')]],'%s',_0x211401):_0x211401;_0x211401=_0x401207[_0x1d71f2][_0x6268('0x75')]?_[_0x6268('0x93')](_0x413e6e[_0x401207[_0x1d71f2][_0x6268('0x75')]],'%s',_0x211401):_0x211401;if(_0x401207[_0x1d71f2][_0x6268('0x76')]){_0x3213c0[_0x6268('0x83')](_0x211401);}_0x401207[_0x1d71f2][_0x6268('0x77')]&&_0x3213c0[_0x6268('0x40')](_0x211401,_0x401207[_0x1d71f2]['orderBy']===_0x6268('0x78')?![]:!![]);_0x3213c0[_0x6268('0x6d')](_0x211401,_0x401207[_0x1d71f2]['alias']||_0x211401);}if(_0x5107b3[_0x6268('0x7a')]){_0x5107b3[_0x6268('0x7a')]=JSON[_0x6268('0x7b')](_0x5107b3[_0x6268('0x7a')]);for(var _0x13a0fd=0x0;_0x13a0fd<_0x5107b3['joins'][_0x6268('0x6b')];_0x13a0fd+=0x1){if(_0x5107b3[_0x6268('0x7a')][_0x13a0fd][_0x6268('0x7c')]&&_['includes'](_0x42e3c6,_0x5107b3[_0x6268('0x7a')][_0x13a0fd][_0x6268('0x7c')])&&_0x5107b3[_0x6268('0x7a')][_0x13a0fd][_0x6268('0x7d')]&&_0x5107b3[_0x6268('0x7a')][_0x13a0fd]['foreignTable']&&_0x5107b3[_0x6268('0x7a')][_0x13a0fd][_0x6268('0x81')]){_0x3213c0[_0x5107b3['joins'][_0x13a0fd]['type']](_0x5107b3[_0x6268('0x7a')][_0x13a0fd][_0x6268('0x7e')],null,util[_0x6268('0x75')](_0x6268('0x7f'),_0x5107b3['table'],_0x5107b3['joins'][_0x13a0fd][_0x6268('0x7d')],_0x5107b3[_0x6268('0x7a')][_0x13a0fd][_0x6268('0x7e')],_0x5107b3[_0x6268('0x7a')][_0x13a0fd][_0x6268('0x81')]));}}}if(_0x5107b3['conditions']){_0x5107b3[_0x6268('0x82')]=JSON[_0x6268('0x7b')](_0x5107b3['conditions']);_0x3213c0[_0x6268('0x42')](_0x4a5236(_0x5107b3['conditions'][_0x6268('0x83')]));}_0x1bf166=_0x3213c0[_0x6268('0x84')]();_0x3213c0[_0x6268('0x3f')](_0x281e70);_0x3213c0[_0x6268('0x1c')](0x0);logger['debug'](_0x6268('0x86'),_0x3213c0[_0x6268('0x87')]());return dbH['sequelize']['query'](_0x3213c0[_0x6268('0x87')](),{'type':dbH[_0x6268('0x88')][_0x6268('0x89')]['SELECT']});}})['then'](function(){return{'sql':_0x1bf166[_0x6268('0x87')]()};})[_0x6268('0x22')](respondWithResult(_0x3ea8c3,null))[_0x6268('0x4a')](handleError(_0x3ea8c3,null));};
\ No newline at end of file
+var _0xaed4=['../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/license/util','../../mysqldb','dbH','sendStatus','status','end','json','offset','undefined','limit','count','set','apply','reject','save','update','destroy','get','DefaultReports','UserProfileResource','then','error','render','merge','body','contact','message','interaction','account','index','map','fieldName','type','model','name','query','keys','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filters','filter','VIRTUAL','includeAll','findAll','catch','params','AnalyticDefaultReport','rawAttributes','include','options','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','Reports','userProfileId','preview','join','left_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','MIN(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','DATE(%s)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NOT\x20NULL','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','value','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','select','table','MetricId','metric','function','replace','format','groupBy','orderBy','DESC','alias','joins','parse','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','conditions','clone','Limited\x20Query:','toString','sequelize','SELECT','cross_join','MAX(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','SEC_TO_TIME(%s)','IS\x20NULL','IS\x20EMPTY','parentKey','output','web','fullPath','randomstring','generate','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','Run\x20Query:','child_process','fork','../../files/reports','from','countTable','COUNT(*)','QueryTypes','run','runReport','AVG(%s)','debug','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','fs-extra','lodash','squel','jsforce','to-csv','querystring','papaparse','../../components/auth/service'];(function(_0x126558,_0x143c9a){var _0x1f6d14=function(_0x2b0eea){while(--_0x2b0eea){_0x126558['push'](_0x126558['shift']());}};_0x1f6d14(++_0x143c9a);}(_0xaed4,0x1e1));var _0x4aed=function(_0x309305,_0x245441){_0x309305=_0x309305-0x0;var _0x576f62=_0xaed4[_0x309305];return _0x576f62;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x4aed('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0x4aed('0x1'));var rp=require(_0x4aed('0x2'));var moment=require(_0x4aed('0x3'));var BPromise=require(_0x4aed('0x4'));var Mustache=require(_0x4aed('0x5'));var util=require(_0x4aed('0x6'));var path=require(_0x4aed('0x7'));var sox=require(_0x4aed('0x8'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x4aed('0x9'));var _=require(_0x4aed('0xa'));var squel=require(_0x4aed('0xb'));var crypto=require('crypto');var jsforce=require(_0x4aed('0xc'));var deskjs=require('desk.js');var toCsv=require(_0x4aed('0xd'));var querystring=require(_0x4aed('0xe'));var Papa=require(_0x4aed('0xf'));var Redis=require('ioredis');var authService=require(_0x4aed('0x10'));var qs=require(_0x4aed('0x11'));var as=require(_0x4aed('0x12'));var hardwareService=require(_0x4aed('0x13'));var logger=require('../../config/logger')(_0x4aed('0x14'));var utils=require(_0x4aed('0x15'));var config=require('../../config/environment');var licenseUtil=require(_0x4aed('0x16'));var db=require(_0x4aed('0x17'))['db'];var dbH=require('../../mysqldb')[_0x4aed('0x18')];function respondWithStatusCode(_0x502cbd,_0x33ccbe){_0x33ccbe=_0x33ccbe||0xcc;return function(_0x13d5b1){if(_0x13d5b1){return _0x502cbd[_0x4aed('0x19')](_0x33ccbe);}return _0x502cbd[_0x4aed('0x1a')](_0x33ccbe)[_0x4aed('0x1b')]();};}function respondWithResult(_0x134d94,_0x4da4c4){_0x4da4c4=_0x4da4c4||0xc8;return function(_0xb46ba6){if(_0xb46ba6){return _0x134d94[_0x4aed('0x1a')](_0x4da4c4)[_0x4aed('0x1c')](_0xb46ba6);}};}function respondWithFilteredResult(_0x5e9daf,_0x23dfcf){return function(_0x5b493c){if(_0x5b493c){var _0x2cee9f=typeof _0x23dfcf[_0x4aed('0x1d')]===_0x4aed('0x1e')&&typeof _0x23dfcf[_0x4aed('0x1f')]===_0x4aed('0x1e');var _0x1214c4=_0x5b493c['count'];var _0x2b9d9f=_0x2cee9f?0x0:_0x23dfcf['offset'];var _0x2c96ad=_0x2cee9f?_0x5b493c[_0x4aed('0x20')]:_0x23dfcf[_0x4aed('0x1d')]+_0x23dfcf['limit'];var _0x4243f6;if(_0x2c96ad>=_0x1214c4){_0x2c96ad=_0x1214c4;_0x4243f6=0xc8;}else{_0x4243f6=0xce;}_0x5e9daf['status'](_0x4243f6);return _0x5e9daf[_0x4aed('0x21')]('Content-Range',_0x2b9d9f+'-'+_0x2c96ad+'/'+_0x1214c4)[_0x4aed('0x1c')](_0x5b493c);}return null;};}function patchUpdates(_0x1a2211){return function(_0x2c0d71){try{jsonpatch[_0x4aed('0x22')](_0x2c0d71,_0x1a2211,!![]);}catch(_0x2982dd){return BPromise[_0x4aed('0x23')](_0x2982dd);}return _0x2c0d71[_0x4aed('0x24')]();};}function saveUpdates(_0x431e01,_0x508dc6){return function(_0x3c63d8){if(_0x3c63d8){return _0x3c63d8[_0x4aed('0x25')](_0x431e01)['then'](function(_0x252cce){return _0x252cce;});}return null;};}function removeEntity(_0x2a83ac,_0x413be0){return function(_0x20e4e9){if(_0x20e4e9){return _0x20e4e9[_0x4aed('0x26')]()['then'](function(){var _0x50a5cc=_0x20e4e9[_0x4aed('0x27')]({'plain':!![]});var _0x2bf68c=_0x4aed('0x28');return db[_0x4aed('0x29')][_0x4aed('0x26')]({'where':{'type':_0x2bf68c,'resourceId':_0x50a5cc['id']}})[_0x4aed('0x2a')](function(){return _0x20e4e9;});})['then'](function(){_0x2a83ac[_0x4aed('0x1a')](0xcc)[_0x4aed('0x1b')]();});}};}function handleEntityNotFound(_0x1ba36c,_0x31e5db){return function(_0x4d7e44){if(!_0x4d7e44){_0x1ba36c[_0x4aed('0x19')](0x194);}return _0x4d7e44;};}function handleError(_0x214b80,_0x3abf76){_0x3abf76=_0x3abf76||0x1f4;return function(_0xd7dc0f){logger[_0x4aed('0x2b')](_0xd7dc0f['stack']);if(_0xd7dc0f['name']){delete _0xd7dc0f['name'];}_0x214b80['status'](_0x3abf76)['send'](_0xd7dc0f);};}function getMustacheRender(_0x29f2e1,_0x332ba4){return Mustache[_0x4aed('0x2c')](_0x29f2e1,_[_0x4aed('0x2d')](_0x332ba4[_0x4aed('0x2e')],{'contact':_0x332ba4[_0x4aed('0x2f')],'message':_0x332ba4[_0x4aed('0x30')],'agent':_0x332ba4['agent'],'interaction':_0x332ba4[_0x4aed('0x31')],'account':_0x332ba4[_0x4aed('0x32')]}))||'';}exports[_0x4aed('0x33')]=function(_0x5d2a60,_0x17c248){var _0x34e3dd={},_0x467b4b={},_0x1fb5bc={'count':0x0,'rows':[]};var _0x110a32=_[_0x4aed('0x34')](db['AnalyticDefaultReport']['rawAttributes'],function(_0x46383f){return{'name':_0x46383f[_0x4aed('0x35')],'type':_0x46383f[_0x4aed('0x36')]['key']};});_0x467b4b[_0x4aed('0x37')]=_[_0x4aed('0x34')](_0x110a32,_0x4aed('0x38'));_0x467b4b[_0x4aed('0x39')]=_[_0x4aed('0x3a')](_0x5d2a60[_0x4aed('0x39')]);_0x467b4b['filters']=_[_0x4aed('0x3b')](_0x467b4b[_0x4aed('0x37')],_0x467b4b['query']);_0x34e3dd[_0x4aed('0x3c')]=_[_0x4aed('0x3b')](_0x467b4b['model'],qs[_0x4aed('0x3d')](_0x5d2a60['query'][_0x4aed('0x3d')]));_0x34e3dd[_0x4aed('0x3c')]=_0x34e3dd[_0x4aed('0x3c')][_0x4aed('0x3e')]?_0x34e3dd['attributes']:_0x467b4b[_0x4aed('0x37')];if(!_0x5d2a60[_0x4aed('0x39')][_0x4aed('0x3f')](_0x4aed('0x40'))){_0x34e3dd[_0x4aed('0x1f')]=qs[_0x4aed('0x1f')](_0x5d2a60[_0x4aed('0x39')][_0x4aed('0x1f')]);_0x34e3dd[_0x4aed('0x1d')]=qs[_0x4aed('0x1d')](_0x5d2a60[_0x4aed('0x39')][_0x4aed('0x1d')]);}_0x34e3dd[_0x4aed('0x41')]=qs['sort'](_0x5d2a60[_0x4aed('0x39')][_0x4aed('0x42')]);_0x34e3dd[_0x4aed('0x43')]=qs['filters'](_[_0x4aed('0x44')](_0x5d2a60[_0x4aed('0x39')],_0x467b4b[_0x4aed('0x45')]),_0x110a32);if(_0x5d2a60[_0x4aed('0x39')][_0x4aed('0x46')]){_0x34e3dd[_0x4aed('0x43')]=_[_0x4aed('0x2d')](_0x34e3dd[_0x4aed('0x43')],{'$or':_[_0x4aed('0x34')](_0x110a32,function(_0x47c3e0){if(_0x47c3e0[_0x4aed('0x36')]!==_0x4aed('0x47')){var _0x340cf0={};_0x340cf0[_0x47c3e0[_0x4aed('0x38')]]={'$like':'%'+_0x5d2a60[_0x4aed('0x39')]['filter']+'%'};return _0x340cf0;}})});}_0x34e3dd=_[_0x4aed('0x2d')]({},_0x34e3dd,_0x5d2a60['options']);var _0x46310c={'where':_0x34e3dd[_0x4aed('0x43')]};return db['AnalyticDefaultReport']['count'](_0x46310c)[_0x4aed('0x2a')](function(_0x4e07b6){_0x1fb5bc[_0x4aed('0x20')]=_0x4e07b6;if(_0x5d2a60[_0x4aed('0x39')][_0x4aed('0x48')]){_0x34e3dd['include']=[{'all':!![]}];}return db['AnalyticDefaultReport'][_0x4aed('0x49')](_0x34e3dd);})[_0x4aed('0x2a')](function(_0x537793){_0x1fb5bc['rows']=_0x537793;return _0x1fb5bc;})[_0x4aed('0x2a')](respondWithFilteredResult(_0x17c248,_0x34e3dd))[_0x4aed('0x4a')](handleError(_0x17c248,null));};exports['show']=function(_0x42eb6d,_0x3cff3c){var _0x3d4bce={'raw':!![],'where':{'id':_0x42eb6d[_0x4aed('0x4b')]['id']}},_0x1a0483={};_0x1a0483['model']=_[_0x4aed('0x3a')](db[_0x4aed('0x4c')][_0x4aed('0x4d')]);_0x1a0483[_0x4aed('0x39')]=_[_0x4aed('0x3a')](_0x42eb6d['query']);_0x1a0483[_0x4aed('0x45')]=_['intersection'](_0x1a0483[_0x4aed('0x37')],_0x1a0483[_0x4aed('0x39')]);_0x3d4bce[_0x4aed('0x3c')]=_[_0x4aed('0x3b')](_0x1a0483[_0x4aed('0x37')],qs[_0x4aed('0x3d')](_0x42eb6d[_0x4aed('0x39')][_0x4aed('0x3d')]));_0x3d4bce['attributes']=_0x3d4bce[_0x4aed('0x3c')]['length']?_0x3d4bce[_0x4aed('0x3c')]:_0x1a0483[_0x4aed('0x37')];if(_0x42eb6d['query']['includeAll']){_0x3d4bce[_0x4aed('0x4e')]=[{'all':!![]}];}_0x3d4bce=_[_0x4aed('0x2d')]({},_0x3d4bce,_0x42eb6d[_0x4aed('0x4f')]);return db[_0x4aed('0x4c')][_0x4aed('0x50')](_0x3d4bce)[_0x4aed('0x2a')](handleEntityNotFound(_0x3cff3c,null))[_0x4aed('0x2a')](respondWithResult(_0x3cff3c,null))['catch'](handleError(_0x3cff3c,null));};exports[_0x4aed('0x51')]=function(_0x1001d6,_0x327c95){return db[_0x4aed('0x4c')][_0x4aed('0x51')](_0x1001d6[_0x4aed('0x2e')],{})['then'](function(_0xf9b145){var _0x179301=_0x1001d6[_0x4aed('0x52')][_0x4aed('0x27')]({'plain':!![]});if(!_0x179301)throw new Error(_0x4aed('0x53'));if(_0x179301['role']===_0x4aed('0x52')){var _0x26a9a1=_0xf9b145[_0x4aed('0x27')]({'plain':!![]});var _0x5cc8a1=_0x4aed('0x54');return db['UserProfileSection'][_0x4aed('0x50')]({'where':{'name':_0x5cc8a1,'userProfileId':_0x179301[_0x4aed('0x55')]},'raw':!![]})['then'](function(_0x7345fd){if(_0x7345fd&&_0x7345fd['autoAssociation']===0x0){return db[_0x4aed('0x29')][_0x4aed('0x51')]({'name':_0x26a9a1[_0x4aed('0x38')],'resourceId':_0x26a9a1['id'],'type':_0x4aed('0x28'),'sectionId':_0x7345fd['id']},{})['then'](function(){return _0xf9b145;});}else{return _0xf9b145;}})['catch'](function(_0x256aee){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x256aee);throw _0x256aee;});}return _0xf9b145;})[_0x4aed('0x2a')](respondWithResult(_0x327c95,0xc9))[_0x4aed('0x4a')](handleError(_0x327c95,null));};exports[_0x4aed('0x25')]=function(_0x497e88,_0x5c4165){if(_0x497e88[_0x4aed('0x2e')]['id']){delete _0x497e88[_0x4aed('0x2e')]['id'];}return db[_0x4aed('0x4c')][_0x4aed('0x50')]({'where':{'id':_0x497e88[_0x4aed('0x4b')]['id']}})[_0x4aed('0x2a')](handleEntityNotFound(_0x5c4165,null))['then'](saveUpdates(_0x497e88[_0x4aed('0x2e')],null))[_0x4aed('0x2a')](respondWithResult(_0x5c4165,null))[_0x4aed('0x4a')](handleError(_0x5c4165,null));};exports['destroy']=function(_0x30536b,_0xe8169b){return db['AnalyticDefaultReport'][_0x4aed('0x50')]({'where':{'id':_0x30536b[_0x4aed('0x4b')]['id']}})[_0x4aed('0x2a')](handleEntityNotFound(_0xe8169b,null))[_0x4aed('0x2a')](removeEntity(_0xe8169b,null))[_0x4aed('0x4a')](handleError(_0xe8169b,null));};exports[_0x4aed('0x56')]=function(_0x50a0bd,_0x1aaadb){var _0x3d58ec=0xa;var _0x308217=[_0x4aed('0x57'),_0x4aed('0x58'),'right_join','cross_join'];var _0x5215fc={'SUM':_0x4aed('0x59'),'COUNT':_0x4aed('0x5a'),'COUNT DISTINCT':_0x4aed('0x5b'),'MAX':'MAX(%s)','MIN':_0x4aed('0x5c'),'AVG':'AVG(%s)','GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0x4aed('0x5d')};var _0x2ff267={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x4aed('0x5e'),'HOUR':_0x4aed('0x5f'),'ROUND':_0x4aed('0x60'),'UNIX_TIMESTAMP':_0x4aed('0x61')};var _0x566cdd=function(_0x3db027){return!_[_0x4aed('0x62')](['IS\x20NULL',_0x4aed('0x63'),'IS\x20EMPTY',_0x4aed('0x64')],_0x3db027);};var _0x15c7d3=function(_0x34f6c2){if(!_0x34f6c2||!_0x34f6c2[_0x4aed('0x65')][_0x4aed('0x3e')]){return'';}for(var _0x3f7b95='(',_0x485f06=0x0;_0x485f06<_0x34f6c2[_0x4aed('0x65')][_0x4aed('0x3e')];_0x485f06+=0x1){_0x485f06>0x0&&(_0x3f7b95+='\x20'+_0x34f6c2[_0x4aed('0x66')]+'\x20');_0x3f7b95+=_0x34f6c2[_0x4aed('0x65')][_0x485f06][_0x4aed('0x67')]?_0x15c7d3(_0x34f6c2[_0x4aed('0x65')][_0x485f06]['group']):_0x34f6c2[_0x4aed('0x65')][_0x485f06][_0x4aed('0x68')]+'\x20'+_0x34f6c2[_0x4aed('0x65')][_0x485f06][_0x4aed('0x69')]+(_0x566cdd(_0x34f6c2[_0x4aed('0x65')][_0x485f06]['condition'])?'\x20'+_0x34f6c2[_0x4aed('0x65')][_0x485f06][_0x4aed('0x6a')]:'');}return _0x3f7b95+')';};var _0x51dea5={'where':{'id':_0x50a0bd['params']['id']}},_0x3f3551,_0x304650,_0x54218e,_0x31b522,_0x41563e;_0x51dea5=_['merge']({},_0x51dea5,_0x50a0bd[_0x4aed('0x4f')]);return db[_0x4aed('0x4c')]['find'](_0x51dea5)['then'](function(_0x287c70){if(_0x287c70){_0x3f3551=_0x287c70;return _0x287c70[_0x4aed('0x6b')]();}return null;})[_0x4aed('0x2a')](function(_0x89ccdc){if(_0x89ccdc){if(!_0x89ccdc['length']){throw new db[(_0x4aed('0x6c'))][(_0x4aed('0x6d'))](_0x4aed('0x6e'),0x193);}_0x304650=_0x89ccdc;return db[_0x4aed('0x6f')][_0x4aed('0x49')]({'raw':!![]});}return null;})[_0x4aed('0x2a')](function(_0x59d507){if(_0x59d507){_0x54218e=_[_0x4aed('0x70')](_0x59d507,'id');var _0x516ab2;var _0x21859c=squel[_0x4aed('0x71')]();_0x21859c['from'](_0x3f3551[_0x4aed('0x72')]);for(var _0x335973=0x0;_0x335973<_0x304650[_0x4aed('0x3e')];_0x335973+=0x1){_0x516ab2=_0x304650[_0x335973]['MetricId']?_0x54218e[_0x304650[_0x335973][_0x4aed('0x73')]][_0x4aed('0x74')]:_0x304650[_0x335973][_0x4aed('0x68')];_0x516ab2=_0x304650[_0x335973][_0x4aed('0x75')]?_[_0x4aed('0x76')](_0x5215fc[_0x304650[_0x335973]['function']],'%s',_0x516ab2):_0x516ab2;_0x516ab2=_0x304650[_0x335973][_0x4aed('0x77')]?_[_0x4aed('0x76')](_0x2ff267[_0x304650[_0x335973][_0x4aed('0x77')]],'%s',_0x516ab2):_0x516ab2;if(_0x304650[_0x335973][_0x4aed('0x78')]){_0x21859c['group'](_0x516ab2);}_0x304650[_0x335973]['orderBy']&&_0x21859c[_0x4aed('0x41')](_0x516ab2,_0x304650[_0x335973][_0x4aed('0x79')]===_0x4aed('0x7a')?![]:!![]);_0x21859c[_0x4aed('0x68')](_0x516ab2,_0x304650[_0x335973][_0x4aed('0x7b')]||_0x516ab2);}if(_0x3f3551[_0x4aed('0x7c')]){_0x3f3551[_0x4aed('0x7c')]=JSON[_0x4aed('0x7d')](_0x3f3551['joins']);for(var _0x584bc0=0x0;_0x584bc0<_0x3f3551[_0x4aed('0x7c')]['length'];_0x584bc0+=0x1){if(_0x3f3551['joins'][_0x584bc0][_0x4aed('0x36')]&&_['includes'](_0x308217,_0x3f3551[_0x4aed('0x7c')][_0x584bc0][_0x4aed('0x36')])&&_0x3f3551[_0x4aed('0x7c')][_0x584bc0]['parentKey']&&_0x3f3551['joins'][_0x584bc0][_0x4aed('0x7e')]&&_0x3f3551[_0x4aed('0x7c')][_0x584bc0][_0x4aed('0x7f')]){_0x21859c[_0x3f3551['joins'][_0x584bc0][_0x4aed('0x36')]](_0x3f3551[_0x4aed('0x7c')][_0x584bc0][_0x4aed('0x7e')],null,util[_0x4aed('0x77')](_0x4aed('0x80'),_0x3f3551[_0x4aed('0x72')],_0x3f3551[_0x4aed('0x7c')][_0x584bc0]['parentKey'],_0x3f3551[_0x4aed('0x7c')][_0x584bc0][_0x4aed('0x7e')],_0x3f3551[_0x4aed('0x7c')][_0x584bc0][_0x4aed('0x7f')]));}}}if(_0x3f3551['conditions']){_0x3f3551['conditions']=JSON['parse'](_0x3f3551[_0x4aed('0x81')]);_0x21859c[_0x4aed('0x43')](_0x15c7d3(_0x3f3551[_0x4aed('0x81')][_0x4aed('0x67')]));}_0x41563e=_0x21859c[_0x4aed('0x82')]();_0x21859c[_0x4aed('0x1f')](_0x3d58ec);_0x21859c[_0x4aed('0x1d')](0x0);logger['debug'](_0x4aed('0x83'),_0x21859c[_0x4aed('0x84')]());return dbH['sequelize']['query'](_0x21859c[_0x4aed('0x84')](),{'type':dbH[_0x4aed('0x85')]['QueryTypes'][_0x4aed('0x86')]});}})[_0x4aed('0x2a')](respondWithResult(_0x1aaadb,null))['catch'](handleError(_0x1aaadb,null));};function runReport(_0x2d5e90,_0x4a1837,_0x173627){var _0x47a4ea=_0x4a1837['name'];var _0xa50db3=0xa;var _0x3e9e91=[_0x4aed('0x57'),_0x4aed('0x58'),'right_join',_0x4aed('0x87')];var _0x5b4726={'SUM':_0x4aed('0x59'),'COUNT':_0x4aed('0x5a'),'COUNT DISTINCT':_0x4aed('0x5b'),'MAX':_0x4aed('0x88'),'MIN':'MIN(%s)','AVG':'AVG(%s)','GROUP_CONCAT':_0x4aed('0x89'),'GROUP_CONCAT ASC':_0x4aed('0x8a'),'GROUP_CONCAT DESC':_0x4aed('0x5d')};var _0x5229ca={'SEC_TO_TIME':_0x4aed('0x8b'),'DATE':_0x4aed('0x5e'),'HOUR':_0x4aed('0x5f'),'ROUND':_0x4aed('0x60'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x56ff21=function(_0xc121f0){return!_[_0x4aed('0x62')]([_0x4aed('0x8c'),_0x4aed('0x63'),_0x4aed('0x8d'),_0x4aed('0x64')],_0xc121f0);};var _0x5f4db6=function(_0x17c23b){if(!_0x17c23b||!_0x17c23b[_0x4aed('0x65')][_0x4aed('0x3e')]){return'';}for(var _0x47d056='(',_0x283e07=0x0;_0x283e07<_0x17c23b['rules']['length'];_0x283e07+=0x1){_0x283e07>0x0&&(_0x47d056+='\x20'+_0x17c23b['operator']+'\x20');_0x47d056+=_0x17c23b['rules'][_0x283e07][_0x4aed('0x67')]?_0x5f4db6(_0x17c23b[_0x4aed('0x65')][_0x283e07][_0x4aed('0x67')]):_0x17c23b[_0x4aed('0x65')][_0x283e07][_0x4aed('0x68')]+'\x20'+_0x17c23b[_0x4aed('0x65')][_0x283e07][_0x4aed('0x69')]+(_0x56ff21(_0x17c23b[_0x4aed('0x65')][_0x283e07][_0x4aed('0x69')])?'\x20'+_0x17c23b['rules'][_0x283e07][_0x4aed('0x6a')]:'');}return _0x47d056+')';};var _0x51d781={'where':{'id':_0x2d5e90['id']}},_0x270860,_0x3bb5c9,_0x5dbe59,_0x49fda5,_0x147f1e;_0x51d781=_[_0x4aed('0x2d')]({},_0x51d781,_0x173627);return db[_0x4aed('0x4c')]['find'](_0x51d781)['then'](function(_0x16298d){if(_0x16298d){_0x270860=_0x16298d;return _0x16298d[_0x4aed('0x6b')]();}return null;})['then'](function(_0x9d9f43){if(_0x9d9f43){if(!_0x9d9f43[_0x4aed('0x3e')]){throw new db['Sequelize'][(_0x4aed('0x6d'))](_0x4aed('0x6e'),0x193);}_0x3bb5c9=_0x9d9f43;return db[_0x4aed('0x6f')][_0x4aed('0x49')]({'raw':!![]});}return null;})[_0x4aed('0x2a')](function(_0x5240d9){if(_0x5240d9){_0x5dbe59=_[_0x4aed('0x70')](_0x5240d9,'id');var _0x47ba9c;var _0x3dc1a6=squel[_0x4aed('0x71')]();_0x3dc1a6['from'](_0x270860[_0x4aed('0x72')]);for(var _0x3b0443=0x0;_0x3b0443<_0x3bb5c9['length'];_0x3b0443+=0x1){_0x47ba9c=_0x3bb5c9[_0x3b0443]['MetricId']?_0x5dbe59[_0x3bb5c9[_0x3b0443][_0x4aed('0x73')]][_0x4aed('0x74')]:_0x3bb5c9[_0x3b0443][_0x4aed('0x68')];_0x47ba9c=_0x3bb5c9[_0x3b0443]['function']?_[_0x4aed('0x76')](_0x5b4726[_0x3bb5c9[_0x3b0443][_0x4aed('0x75')]],'%s',_0x47ba9c):_0x47ba9c;_0x47ba9c=_0x3bb5c9[_0x3b0443][_0x4aed('0x77')]?_[_0x4aed('0x76')](_0x5229ca[_0x3bb5c9[_0x3b0443][_0x4aed('0x77')]],'%s',_0x47ba9c):_0x47ba9c;if(_0x3bb5c9[_0x3b0443]['groupBy']){_0x3dc1a6[_0x4aed('0x67')](_0x47ba9c);}_0x3bb5c9[_0x3b0443][_0x4aed('0x79')]&&_0x3dc1a6[_0x4aed('0x41')](_0x47ba9c,_0x3bb5c9[_0x3b0443][_0x4aed('0x79')]===_0x4aed('0x7a')?![]:!![]);_0x3dc1a6[_0x4aed('0x68')](_0x47ba9c,_0x3bb5c9[_0x3b0443][_0x4aed('0x7b')]||_0x47ba9c);}if(_0x270860['joins']){_0x270860[_0x4aed('0x7c')]=JSON[_0x4aed('0x7d')](_0x270860[_0x4aed('0x7c')]);for(var _0xc186e=0x0;_0xc186e<_0x270860[_0x4aed('0x7c')]['length'];_0xc186e+=0x1){if(_0x270860[_0x4aed('0x7c')][_0xc186e][_0x4aed('0x36')]&&_[_0x4aed('0x62')](_0x3e9e91,_0x270860['joins'][_0xc186e][_0x4aed('0x36')])&&_0x270860[_0x4aed('0x7c')][_0xc186e][_0x4aed('0x8e')]&&_0x270860[_0x4aed('0x7c')][_0xc186e]['foreignTable']&&_0x270860[_0x4aed('0x7c')][_0xc186e][_0x4aed('0x7f')]){_0x3dc1a6[_0x270860['joins'][_0xc186e][_0x4aed('0x36')]](_0x270860[_0x4aed('0x7c')][_0xc186e]['foreignTable'],null,util[_0x4aed('0x77')](_0x4aed('0x80'),_0x270860[_0x4aed('0x72')],_0x270860[_0x4aed('0x7c')][_0xc186e]['parentKey'],_0x270860[_0x4aed('0x7c')][_0xc186e][_0x4aed('0x7e')],_0x270860[_0x4aed('0x7c')][_0xc186e]['foreignKey']));}}}if(_0x270860[_0x4aed('0x81')]){_0x270860[_0x4aed('0x81')]=JSON[_0x4aed('0x7d')](_0x270860[_0x4aed('0x81')]);_0x3dc1a6[_0x4aed('0x43')](_0x5f4db6(_0x270860[_0x4aed('0x81')]['group']));}_0x147f1e=_0x3dc1a6[_0x4aed('0x82')]();_0x3dc1a6['limit'](_0xa50db3);_0x3dc1a6[_0x4aed('0x1d')](0x0);return;}})[_0x4aed('0x2a')](function(){if(_0x4a1837[_0x4aed('0x8f')]===_0x4aed('0x90')){return null;}var _0xbb9f8a=_[_0x4aed('0x2d')](_0x4a1837,{'name':_0x4a1837[_0x4aed('0x91')]||_0x4a1837[_0x4aed('0x38')]||_0x270860[_0x4aed('0x38')],'basename':_0x47a4ea,'savename':util['format']('%s-%s.%s',_0x4a1837[_0x4aed('0x38')]||_0x270860[_0x4aed('0x38')],require(_0x4aed('0x92'))[_0x4aed('0x93')](0x4),_0x4a1837[_0x4aed('0x8f')]||'csv'),'reportId':_0x270860['id'],'reportType':'default'});return db[_0x4aed('0x94')][_0x4aed('0x51')](_0xbb9f8a,{'raw':!![]});})[_0x4aed('0x2a')](function(_0x140705){if(_0x270860[_0x4aed('0x72')]===_0x4aed('0x95')){_0x147f1e[_0x4aed('0x43')](_0x270860[_0x4aed('0x72')]+_0x4aed('0x96'),_0x4a1837[_0x4aed('0x97')],_0x4a1837[_0x4aed('0x98')]);}else{_0x147f1e[_0x4aed('0x43')](_0x270860[_0x4aed('0x72')]+_0x4aed('0x99'),_0x4a1837[_0x4aed('0x97')],_0x4a1837['endDate']);}if(_0x140705){logger['info'](_0x4aed('0x9a'),_0x147f1e[_0x4aed('0x84')]());require(_0x4aed('0x9b'))[_0x4aed('0x9c')](path['join'](__dirname,'../../components/export/',_0x140705['output']),[_0x140705['id'],_0x147f1e['toString'](),path['join'](__dirname,_0x4aed('0x9d'),_0x140705['savename']),_0x47a4ea]);return _0x140705;}else{var _0x2dd907=squel[_0x4aed('0x71')]();_0x2dd907[_0x4aed('0x9e')]('('+_0x147f1e[_0x4aed('0x84')]()+')',_0x4aed('0x9f'));_0x2dd907[_0x4aed('0x68')](_0x4aed('0xa0'),_0x4aed('0x20'));_0x147f1e['limit'](_0x4a1837['limit']||_0xa50db3);_0x147f1e[_0x4aed('0x1d')](_0x4a1837[_0x4aed('0x1d')]||0x0);return dbH['sequelize'][_0x4aed('0x39')](_0x2dd907[_0x4aed('0x84')](),{'type':dbH['sequelize']['QueryTypes'][_0x4aed('0x86')]})['then'](function(_0x46f8f1){if(!_0x46f8f1[_0x4aed('0x3e')]){_0x49fda5=0x0;}else{_0x49fda5=_0x46f8f1[0x0][_0x4aed('0x20')]||0x0;}return dbH['sequelize'][_0x4aed('0x39')](_0x147f1e[_0x4aed('0x84')](),{'type':dbH['sequelize'][_0x4aed('0xa1')][_0x4aed('0x86')]});})[_0x4aed('0x2a')](function(_0x56597d){return{'rows':_0x56597d||[],'count':_0x49fda5};});}});}exports[_0x4aed('0xa2')]=function(_0x4da72b,_0x5eb2df){return runReport(_0x4da72b[_0x4aed('0x4b')],_0x4da72b['query'],_0x4da72b['options'])[_0x4aed('0x2a')](respondWithResult(_0x5eb2df,null))[_0x4aed('0x4a')](handleError(_0x5eb2df,null));};exports[_0x4aed('0xa3')]=runReport;exports[_0x4aed('0x39')]=function(_0x996849,_0xcc5d50){var _0x912ea6=0xa;var _0x5af1af=[_0x4aed('0x57'),_0x4aed('0x58'),'right_join',_0x4aed('0x87')];var _0x2df38b={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT DISTINCT':_0x4aed('0x5b'),'MAX':_0x4aed('0x88'),'MIN':_0x4aed('0x5c'),'AVG':_0x4aed('0xa4'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0x4aed('0x5d')};var _0x10fb56={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x4aed('0x5e'),'HOUR':_0x4aed('0x5f'),'ROUND':_0x4aed('0x60'),'UNIX_TIMESTAMP':_0x4aed('0x61')};var _0x3338e9=function(_0x13fc2b){return!_[_0x4aed('0x62')]([_0x4aed('0x8c'),_0x4aed('0x63'),_0x4aed('0x8d'),_0x4aed('0x64')],_0x13fc2b);};var _0x5e5fe7=function(_0x4636ae){if(!_0x4636ae||!_0x4636ae[_0x4aed('0x65')][_0x4aed('0x3e')]){return'';}for(var _0x2f8d42='(',_0x51d96c=0x0;_0x51d96c<_0x4636ae[_0x4aed('0x65')][_0x4aed('0x3e')];_0x51d96c+=0x1){_0x51d96c>0x0&&(_0x2f8d42+='\x20'+_0x4636ae[_0x4aed('0x66')]+'\x20');_0x2f8d42+=_0x4636ae[_0x4aed('0x65')][_0x51d96c]['group']?_0x5e5fe7(_0x4636ae[_0x4aed('0x65')][_0x51d96c]['group']):_0x4636ae[_0x4aed('0x65')][_0x51d96c][_0x4aed('0x68')]+'\x20'+_0x4636ae['rules'][_0x51d96c][_0x4aed('0x69')]+(_0x3338e9(_0x4636ae[_0x4aed('0x65')][_0x51d96c][_0x4aed('0x69')])?'\x20'+_0x4636ae['rules'][_0x51d96c][_0x4aed('0x6a')]:'');}return _0x2f8d42+')';};var _0x4d3656={'where':{'id':_0x996849[_0x4aed('0x4b')]['id']}},_0x4d1644,_0x2734a3,_0x4dcfa6,_0x1e06bd,_0x57d79a;_0x4d3656=_['merge']({},_0x4d3656,_0x996849[_0x4aed('0x4f')]);return db['AnalyticDefaultReport'][_0x4aed('0x50')](_0x4d3656)[_0x4aed('0x2a')](function(_0x3ae0af){if(_0x3ae0af){_0x4d1644=_0x3ae0af;return _0x3ae0af[_0x4aed('0x6b')]();}return null;})[_0x4aed('0x2a')](function(_0x4cbbae){if(_0x4cbbae){if(!_0x4cbbae[_0x4aed('0x3e')]){throw new db[(_0x4aed('0x6c'))][(_0x4aed('0x6d'))](_0x4aed('0x6e'),0x193);}_0x2734a3=_0x4cbbae;return db[_0x4aed('0x6f')][_0x4aed('0x49')]({'raw':!![]});}return null;})[_0x4aed('0x2a')](function(_0x293ca6){if(_0x293ca6){_0x4dcfa6=_['keyBy'](_0x293ca6,'id');var _0x2763c2;var _0x48d9cc=squel['select']();_0x48d9cc['from'](_0x4d1644[_0x4aed('0x72')]);for(var _0x1d4886=0x0;_0x1d4886<_0x2734a3[_0x4aed('0x3e')];_0x1d4886+=0x1){_0x2763c2=_0x2734a3[_0x1d4886][_0x4aed('0x73')]?_0x4dcfa6[_0x2734a3[_0x1d4886][_0x4aed('0x73')]][_0x4aed('0x74')]:_0x2734a3[_0x1d4886][_0x4aed('0x68')];_0x2763c2=_0x2734a3[_0x1d4886][_0x4aed('0x75')]?_[_0x4aed('0x76')](_0x2df38b[_0x2734a3[_0x1d4886][_0x4aed('0x75')]],'%s',_0x2763c2):_0x2763c2;_0x2763c2=_0x2734a3[_0x1d4886][_0x4aed('0x77')]?_[_0x4aed('0x76')](_0x10fb56[_0x2734a3[_0x1d4886][_0x4aed('0x77')]],'%s',_0x2763c2):_0x2763c2;if(_0x2734a3[_0x1d4886][_0x4aed('0x78')]){_0x48d9cc['group'](_0x2763c2);}_0x2734a3[_0x1d4886]['orderBy']&&_0x48d9cc[_0x4aed('0x41')](_0x2763c2,_0x2734a3[_0x1d4886][_0x4aed('0x79')]===_0x4aed('0x7a')?![]:!![]);_0x48d9cc[_0x4aed('0x68')](_0x2763c2,_0x2734a3[_0x1d4886]['alias']||_0x2763c2);}if(_0x4d1644['joins']){_0x4d1644[_0x4aed('0x7c')]=JSON[_0x4aed('0x7d')](_0x4d1644[_0x4aed('0x7c')]);for(var _0x30ead9=0x0;_0x30ead9<_0x4d1644[_0x4aed('0x7c')]['length'];_0x30ead9+=0x1){if(_0x4d1644[_0x4aed('0x7c')][_0x30ead9]['type']&&_['includes'](_0x5af1af,_0x4d1644[_0x4aed('0x7c')][_0x30ead9][_0x4aed('0x36')])&&_0x4d1644[_0x4aed('0x7c')][_0x30ead9]['parentKey']&&_0x4d1644['joins'][_0x30ead9][_0x4aed('0x7e')]&&_0x4d1644[_0x4aed('0x7c')][_0x30ead9][_0x4aed('0x7f')]){_0x48d9cc[_0x4d1644[_0x4aed('0x7c')][_0x30ead9][_0x4aed('0x36')]](_0x4d1644['joins'][_0x30ead9][_0x4aed('0x7e')],null,util[_0x4aed('0x77')](_0x4aed('0x80'),_0x4d1644[_0x4aed('0x72')],_0x4d1644['joins'][_0x30ead9][_0x4aed('0x8e')],_0x4d1644[_0x4aed('0x7c')][_0x30ead9][_0x4aed('0x7e')],_0x4d1644[_0x4aed('0x7c')][_0x30ead9]['foreignKey']));}}}if(_0x4d1644[_0x4aed('0x81')]){_0x4d1644[_0x4aed('0x81')]=JSON[_0x4aed('0x7d')](_0x4d1644[_0x4aed('0x81')]);_0x48d9cc['where'](_0x5e5fe7(_0x4d1644['conditions'][_0x4aed('0x67')]));}_0x57d79a=_0x48d9cc['clone']();_0x48d9cc['limit'](_0x912ea6);_0x48d9cc[_0x4aed('0x1d')](0x0);logger[_0x4aed('0xa5')](_0x4aed('0x83'),_0x48d9cc['toString']());return dbH[_0x4aed('0x85')][_0x4aed('0x39')](_0x48d9cc[_0x4aed('0x84')](),{'type':dbH[_0x4aed('0x85')]['QueryTypes']['SELECT']});}})['then'](function(){return{'sql':_0x57d79a[_0x4aed('0x84')]()};})[_0x4aed('0x2a')](respondWithResult(_0xcc5d50,null))[_0x4aed('0x4a')](handleError(_0xcc5d50,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff