// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x8bec=['Sequelize','ValidationErrorItem','AnalyticMetric','table','MetricId','replace','function','format','groupBy','DESC','alias','joins','parentKey','foreignTable','%s.%s\x20=\x20%s.%s','foreignKey','conditions','parse','clone','Limited\x20Query:','toString','QueryTypes','SELECT','join','right_join','SUM(%s)','MIN(%s)','GROUP_CONCAT(%s)','SEC_TO_TIME(%s)','HOUR(%s)','IS\x20NULL','Please\x20insert\x20at\x20least\x20one\x20field','keyBy','from','metric','orderBy','output','web','fullPath','%s-%s.%s','randomstring','generate','csv','custom','AnalyticExtractedReport','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','info','Run\x20Query:','savename','select','countTable','COUNT(*)','sequelize','run','DATE(%s)','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','path','sox','to-csv','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','dbH','sendStatus','status','json','limit','undefined','count','offset','set','Content-Range','apply','save','update','then','destroy','get','CustomReports','UserProfileResource','end','error','name','send','AnalyticCustomReport','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','order','sort','where','pick','filter','map','VIRTUAL','merge','options','includeAll','findAll','rows','catch','params','include','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','find','preview','left_join','cross_join','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','AVG(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','getFields'];(function(_0x34e5a8,_0x1670a4){var _0x5bc365=function(_0x47a389){while(--_0x47a389){_0x34e5a8['push'](_0x34e5a8['shift']());}};_0x5bc365(++_0x1670a4);}(_0x8bec,0xdd));var _0xc8be=function(_0x3701cf,_0x25c0b8){_0x3701cf=_0x3701cf-0x0;var _0x4ea60b=_0x8bec[_0x3701cf];return _0x4ea60b;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xc8be('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0xc8be('0x1'));var rp=require(_0xc8be('0x2'));var moment=require(_0xc8be('0x3'));var BPromise=require(_0xc8be('0x4'));var Mustache=require(_0xc8be('0x5'));var util=require('util');var path=require(_0xc8be('0x6'));var sox=require(_0xc8be('0x7'));var csv=require(_0xc8be('0x8'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xc8be('0x9'));var squel=require(_0xc8be('0xa'));var crypto=require('crypto');var jsforce=require(_0xc8be('0xb'));var deskjs=require(_0xc8be('0xc'));var toCsv=require(_0xc8be('0x8'));var querystring=require(_0xc8be('0xd'));var Papa=require(_0xc8be('0xe'));var Redis=require(_0xc8be('0xf'));var authService=require(_0xc8be('0x10'));var qs=require(_0xc8be('0x11'));var as=require(_0xc8be('0x12'));var hardwareService=require(_0xc8be('0x13'));var logger=require(_0xc8be('0x14'))(_0xc8be('0x15'));var utils=require('../../config/utils');var config=require(_0xc8be('0x16'));var licenseUtil=require(_0xc8be('0x17'));var db=require(_0xc8be('0x18'))['db'];var dbH=require('../../mysqldb')[_0xc8be('0x19')];function respondWithStatusCode(_0x51f0b0,_0xc81750){_0xc81750=_0xc81750||0xcc;return function(_0x3474c1){if(_0x3474c1){return _0x51f0b0[_0xc8be('0x1a')](_0xc81750);}return _0x51f0b0[_0xc8be('0x1b')](_0xc81750)['end']();};}function respondWithResult(_0x530ad4,_0x715138){_0x715138=_0x715138||0xc8;return function(_0x49f9d5){if(_0x49f9d5){return _0x530ad4[_0xc8be('0x1b')](_0x715138)[_0xc8be('0x1c')](_0x49f9d5);}};}function respondWithFilteredResult(_0x5bd966,_0x18ec0b){return function(_0x4ba583){if(_0x4ba583){var _0x48e5ca=typeof _0x18ec0b['offset']==='undefined'&&typeof _0x18ec0b[_0xc8be('0x1d')]===_0xc8be('0x1e');var _0x349c08=_0x4ba583[_0xc8be('0x1f')];var _0x5eaef5=_0x48e5ca?0x0:_0x18ec0b['offset'];var _0x28a34f=_0x48e5ca?_0x4ba583[_0xc8be('0x1f')]:_0x18ec0b[_0xc8be('0x20')]+_0x18ec0b[_0xc8be('0x1d')];var _0xa357cf;if(_0x28a34f>=_0x349c08){_0x28a34f=_0x349c08;_0xa357cf=0xc8;}else{_0xa357cf=0xce;}_0x5bd966[_0xc8be('0x1b')](_0xa357cf);return _0x5bd966[_0xc8be('0x21')](_0xc8be('0x22'),_0x5eaef5+'-'+_0x28a34f+'/'+_0x349c08)[_0xc8be('0x1c')](_0x4ba583);}return null;};}function patchUpdates(_0x4ed146){return function(_0x28e58b){try{jsonpatch[_0xc8be('0x23')](_0x28e58b,_0x4ed146,!![]);}catch(_0x1c34b8){return BPromise['reject'](_0x1c34b8);}return _0x28e58b[_0xc8be('0x24')]();};}function saveUpdates(_0x275020,_0x926280){return function(_0x4a6a15){if(_0x4a6a15){return _0x4a6a15[_0xc8be('0x25')](_0x275020)[_0xc8be('0x26')](function(_0x45d13f){return _0x45d13f;});}return null;};}function removeEntity(_0x3d529b,_0xa0ed02){return function(_0x5039a4){if(_0x5039a4){return _0x5039a4[_0xc8be('0x27')]()['then'](function(){var _0x17e0c8=_0x5039a4[_0xc8be('0x28')]({'plain':!![]});var _0x4b3354=_0xc8be('0x29');return db[_0xc8be('0x2a')][_0xc8be('0x27')]({'where':{'type':_0x4b3354,'resourceId':_0x17e0c8['id']}})[_0xc8be('0x26')](function(){return _0x5039a4;});})[_0xc8be('0x26')](function(){_0x3d529b[_0xc8be('0x1b')](0xcc)[_0xc8be('0x2b')]();});}};}function handleEntityNotFound(_0x326b19,_0x3d3183){return function(_0x2d0886){if(!_0x2d0886){_0x326b19[_0xc8be('0x1a')](0x194);}return _0x2d0886;};}function handleError(_0xccb34a,_0x11f8e9){_0x11f8e9=_0x11f8e9||0x1f4;return function(_0x29ff47){logger[_0xc8be('0x2c')](_0x29ff47['stack']);if(_0x29ff47[_0xc8be('0x2d')]){delete _0x29ff47[_0xc8be('0x2d')];}_0xccb34a[_0xc8be('0x1b')](_0x11f8e9)[_0xc8be('0x2e')](_0x29ff47);};}exports['index']=function(_0x5087ea,_0x1595b9){var _0x179f80={},_0x4eb9b6={},_0x170b2e={'count':0x0,'rows':[]};var _0x224548=_['map'](db[_0xc8be('0x2f')][_0xc8be('0x30')],function(_0x39c631){return{'name':_0x39c631[_0xc8be('0x31')],'type':_0x39c631[_0xc8be('0x32')][_0xc8be('0x33')]};});_0x4eb9b6[_0xc8be('0x34')]=_['map'](_0x224548,_0xc8be('0x2d'));_0x4eb9b6[_0xc8be('0x35')]=_[_0xc8be('0x36')](_0x5087ea[_0xc8be('0x35')]);_0x4eb9b6[_0xc8be('0x37')]=_[_0xc8be('0x38')](_0x4eb9b6[_0xc8be('0x34')],_0x4eb9b6[_0xc8be('0x35')]);_0x179f80[_0xc8be('0x39')]=_[_0xc8be('0x38')](_0x4eb9b6[_0xc8be('0x34')],qs[_0xc8be('0x3a')](_0x5087ea['query'][_0xc8be('0x3a')]));_0x179f80[_0xc8be('0x39')]=_0x179f80[_0xc8be('0x39')][_0xc8be('0x3b')]?_0x179f80[_0xc8be('0x39')]:_0x4eb9b6['model'];if(!_0x5087ea[_0xc8be('0x35')][_0xc8be('0x3c')]('nolimit')){_0x179f80['limit']=qs[_0xc8be('0x1d')](_0x5087ea['query']['limit']);_0x179f80[_0xc8be('0x20')]=qs[_0xc8be('0x20')](_0x5087ea[_0xc8be('0x35')]['offset']);}_0x179f80[_0xc8be('0x3d')]=qs[_0xc8be('0x3e')](_0x5087ea['query'][_0xc8be('0x3e')]);_0x179f80[_0xc8be('0x3f')]=qs[_0xc8be('0x37')](_[_0xc8be('0x40')](_0x5087ea[_0xc8be('0x35')],_0x4eb9b6[_0xc8be('0x37')]),_0x224548);if(_0x5087ea[_0xc8be('0x35')][_0xc8be('0x41')]){_0x179f80[_0xc8be('0x3f')]=_['merge'](_0x179f80['where'],{'$or':_[_0xc8be('0x42')](_0x224548,function(_0x2a20f8){if(_0x2a20f8[_0xc8be('0x32')]!==_0xc8be('0x43')){var _0x1da866={};_0x1da866[_0x2a20f8[_0xc8be('0x2d')]]={'$like':'%'+_0x5087ea['query'][_0xc8be('0x41')]+'%'};return _0x1da866;}})});}_0x179f80=_[_0xc8be('0x44')]({},_0x179f80,_0x5087ea[_0xc8be('0x45')]);var _0x10da5c={'where':_0x179f80['where']};return db[_0xc8be('0x2f')]['count'](_0x10da5c)[_0xc8be('0x26')](function(_0x147698){_0x170b2e[_0xc8be('0x1f')]=_0x147698;if(_0x5087ea[_0xc8be('0x35')][_0xc8be('0x46')]){_0x179f80['include']=[{'all':!![]}];}return db['AnalyticCustomReport'][_0xc8be('0x47')](_0x179f80);})['then'](function(_0x120ba3){_0x170b2e[_0xc8be('0x48')]=_0x120ba3;return _0x170b2e;})[_0xc8be('0x26')](respondWithFilteredResult(_0x1595b9,_0x179f80))[_0xc8be('0x49')](handleError(_0x1595b9,null));};exports['show']=function(_0x3de8da,_0x5ade06){var _0x44fff4={'raw':![],'where':{'id':_0x3de8da[_0xc8be('0x4a')]['id']}},_0x5e6524={};_0x5e6524[_0xc8be('0x34')]=_[_0xc8be('0x36')](db[_0xc8be('0x2f')][_0xc8be('0x30')]);_0x5e6524[_0xc8be('0x35')]=_[_0xc8be('0x36')](_0x3de8da['query']);_0x5e6524['filters']=_[_0xc8be('0x38')](_0x5e6524[_0xc8be('0x34')],_0x5e6524['query']);_0x44fff4[_0xc8be('0x39')]=_['intersection'](_0x5e6524['model'],qs[_0xc8be('0x3a')](_0x3de8da['query'][_0xc8be('0x3a')]));_0x44fff4[_0xc8be('0x39')]=_0x44fff4[_0xc8be('0x39')][_0xc8be('0x3b')]?_0x44fff4[_0xc8be('0x39')]:_0x5e6524[_0xc8be('0x34')];if(_0x3de8da[_0xc8be('0x35')][_0xc8be('0x46')]){_0x44fff4[_0xc8be('0x4b')]=[{'all':!![]}];}_0x44fff4=_[_0xc8be('0x44')]({},_0x44fff4,_0x3de8da['options']);return db[_0xc8be('0x2f')]['find'](_0x44fff4)[_0xc8be('0x26')](handleEntityNotFound(_0x5ade06,null))[_0xc8be('0x26')](respondWithResult(_0x5ade06,null))[_0xc8be('0x49')](handleError(_0x5ade06,null));};exports[_0xc8be('0x4c')]=function(_0x472673,_0x48cb1f){return db['AnalyticCustomReport'][_0xc8be('0x4c')](_0x472673[_0xc8be('0x4d')],{})['then'](function(_0x3d1431){var _0x3ff5dd=_0x472673['user'][_0xc8be('0x28')]({'plain':!![]});if(!_0x3ff5dd)throw new Error(_0xc8be('0x4e'));if(_0x3ff5dd[_0xc8be('0x4f')]==='user'){var _0x15ec9e=_0x3d1431[_0xc8be('0x28')]({'plain':!![]});var _0x2d2d07=_0xc8be('0x50');return db[_0xc8be('0x51')]['find']({'where':{'name':_0x2d2d07,'userProfileId':_0x3ff5dd[_0xc8be('0x52')]},'raw':!![]})['then'](function(_0x235e96){if(_0x235e96&&_0x235e96[_0xc8be('0x53')]===0x0){return db[_0xc8be('0x2a')]['create']({'name':_0x15ec9e['name'],'resourceId':_0x15ec9e['id'],'type':_0xc8be('0x29'),'sectionId':_0x235e96['id']},{})[_0xc8be('0x26')](function(){return _0x3d1431;});}else{return _0x3d1431;}})[_0xc8be('0x49')](function(_0x2c07c9){logger[_0xc8be('0x2c')](_0xc8be('0x54'),_0x2c07c9);throw _0x2c07c9;});}return _0x3d1431;})[_0xc8be('0x26')](respondWithResult(_0x48cb1f,0xc9))['catch'](handleError(_0x48cb1f,null));};exports[_0xc8be('0x25')]=function(_0x3d5af8,_0x4b128f){if(_0x3d5af8[_0xc8be('0x4d')]['id']){delete _0x3d5af8[_0xc8be('0x4d')]['id'];}return db[_0xc8be('0x2f')]['find']({'where':{'id':_0x3d5af8[_0xc8be('0x4a')]['id']}})[_0xc8be('0x26')](handleEntityNotFound(_0x4b128f,null))[_0xc8be('0x26')](saveUpdates(_0x3d5af8['body'],null))[_0xc8be('0x26')](respondWithResult(_0x4b128f,null))[_0xc8be('0x49')](handleError(_0x4b128f,null));};exports[_0xc8be('0x27')]=function(_0x593e95,_0x2e6015){return db[_0xc8be('0x2f')][_0xc8be('0x55')]({'where':{'id':_0x593e95[_0xc8be('0x4a')]['id']}})['then'](handleEntityNotFound(_0x2e6015,null))[_0xc8be('0x26')](removeEntity(_0x2e6015,null))['catch'](handleError(_0x2e6015,null));};exports[_0xc8be('0x56')]=function(_0x455072,_0x2fcafd){var _0x5d3629=0xa;var _0x4c4964=['join',_0xc8be('0x57'),'right_join',_0xc8be('0x58')];var _0xadab50={'SUM':'SUM(%s)','COUNT':_0xc8be('0x59'),'COUNT DISTINCT':_0xc8be('0x5a'),'MAX':_0xc8be('0x5b'),'MIN':'MIN(%s)','AVG':_0xc8be('0x5c'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0xc8be('0x5d'),'GROUP_CONCAT DESC':_0xc8be('0x5e')};var _0x311678={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':_0xc8be('0x5f'),'UNIX_TIMESTAMP':_0xc8be('0x60')};var _0x430756=function(_0x212ec6){return!_[_0xc8be('0x61')](['IS\x20NULL',_0xc8be('0x62'),_0xc8be('0x63'),_0xc8be('0x64')],_0x212ec6);};var _0x43e1b8=function(_0x2e31de){if(!_0x2e31de||!_0x2e31de[_0xc8be('0x65')][_0xc8be('0x3b')]){return'';}for(var _0x5329c8='(',_0x393e50=0x0;_0x393e50<_0x2e31de[_0xc8be('0x65')][_0xc8be('0x3b')];_0x393e50+=0x1){_0x393e50>0x0&&(_0x5329c8+='\x20'+_0x2e31de[_0xc8be('0x66')]+'\x20');_0x5329c8+=_0x2e31de[_0xc8be('0x65')][_0x393e50][_0xc8be('0x67')]?_0x43e1b8(_0x2e31de[_0xc8be('0x65')][_0x393e50][_0xc8be('0x67')]):_0x2e31de[_0xc8be('0x65')][_0x393e50][_0xc8be('0x68')]+'\x20'+_0x2e31de[_0xc8be('0x65')][_0x393e50][_0xc8be('0x69')]+(_0x430756(_0x2e31de[_0xc8be('0x65')][_0x393e50][_0xc8be('0x69')])?'\x20'+_0x2e31de[_0xc8be('0x65')][_0x393e50]['value']:'');}return _0x5329c8+')';};var _0x4ff668={'where':{'id':_0x455072['params']['id']}},_0x485220,_0x9dacf,_0x5ad2f6,_0x2869e9,_0x108ec6;_0x4ff668=_[_0xc8be('0x44')]({},_0x4ff668,_0x455072['options']);return db['AnalyticCustomReport']['find'](_0x4ff668)['then'](function(_0x2fa9e0){if(_0x2fa9e0){_0x485220=_0x2fa9e0;return _0x2fa9e0[_0xc8be('0x6a')]();}return null;})[_0xc8be('0x26')](function(_0xbc2525){if(_0xbc2525){if(!_0xbc2525[_0xc8be('0x3b')]){throw new db[(_0xc8be('0x6b'))][(_0xc8be('0x6c'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x9dacf=_0xbc2525;return db[_0xc8be('0x6d')][_0xc8be('0x47')]({'raw':!![]});}return null;})[_0xc8be('0x26')](function(_0xe065a0){if(_0xe065a0){_0x5ad2f6=_['keyBy'](_0xe065a0,'id');var _0x330423;var _0x419288=squel['select']();_0x419288['from'](_0x485220[_0xc8be('0x6e')]);for(var _0x3f1c05=0x0;_0x3f1c05<_0x9dacf[_0xc8be('0x3b')];_0x3f1c05+=0x1){_0x330423=_0x9dacf[_0x3f1c05][_0xc8be('0x6f')]?_0x5ad2f6[_0x9dacf[_0x3f1c05][_0xc8be('0x6f')]]['metric']:_0x9dacf[_0x3f1c05][_0xc8be('0x68')];_0x330423=_0x9dacf[_0x3f1c05]['function']?_[_0xc8be('0x70')](_0xadab50[_0x9dacf[_0x3f1c05][_0xc8be('0x71')]],'%s',_0x330423):_0x330423;_0x330423=_0x9dacf[_0x3f1c05]['format']?_[_0xc8be('0x70')](_0x311678[_0x9dacf[_0x3f1c05][_0xc8be('0x72')]],'%s',_0x330423):_0x330423;if(_0x9dacf[_0x3f1c05][_0xc8be('0x73')]){_0x419288[_0xc8be('0x67')](_0x330423);}_0x9dacf[_0x3f1c05]['orderBy']&&_0x419288[_0xc8be('0x3d')](_0x330423,_0x9dacf[_0x3f1c05]['orderBy']===_0xc8be('0x74')?![]:!![]);_0x419288[_0xc8be('0x68')](_0x330423,_0x9dacf[_0x3f1c05][_0xc8be('0x75')]||_0x330423);}if(_0x485220[_0xc8be('0x76')]){_0x485220[_0xc8be('0x76')]=JSON['parse'](_0x485220[_0xc8be('0x76')]);for(var _0x21cd12=0x0;_0x21cd12<_0x485220[_0xc8be('0x76')][_0xc8be('0x3b')];_0x21cd12+=0x1){if(_0x485220['joins'][_0x21cd12][_0xc8be('0x32')]&&_[_0xc8be('0x61')](_0x4c4964,_0x485220[_0xc8be('0x76')][_0x21cd12][_0xc8be('0x32')])&&_0x485220[_0xc8be('0x76')][_0x21cd12][_0xc8be('0x77')]&&_0x485220[_0xc8be('0x76')][_0x21cd12]['foreignTable']&&_0x485220[_0xc8be('0x76')][_0x21cd12]['foreignKey']){_0x419288[_0x485220[_0xc8be('0x76')][_0x21cd12]['type']](_0x485220[_0xc8be('0x76')][_0x21cd12][_0xc8be('0x78')],null,util[_0xc8be('0x72')](_0xc8be('0x79'),_0x485220[_0xc8be('0x6e')],_0x485220[_0xc8be('0x76')][_0x21cd12][_0xc8be('0x77')],_0x485220[_0xc8be('0x76')][_0x21cd12][_0xc8be('0x78')],_0x485220[_0xc8be('0x76')][_0x21cd12][_0xc8be('0x7a')]));}}}if(_0x485220[_0xc8be('0x7b')]){_0x485220['conditions']=JSON[_0xc8be('0x7c')](_0x485220['conditions']);_0x419288[_0xc8be('0x3f')](_0x43e1b8(_0x485220[_0xc8be('0x7b')][_0xc8be('0x67')]));}_0x108ec6=_0x419288[_0xc8be('0x7d')]();_0x419288['limit'](_0x5d3629);_0x419288[_0xc8be('0x20')](0x0);logger['debug'](_0xc8be('0x7e'),_0x419288[_0xc8be('0x7f')]());return dbH['sequelize'][_0xc8be('0x35')](_0x419288['toString'](),{'type':dbH['sequelize'][_0xc8be('0x80')][_0xc8be('0x81')]});}})[_0xc8be('0x26')](respondWithResult(_0x2fcafd,null))['catch'](handleError(_0x2fcafd,null));};function runReport(_0x688161,_0x3870fb,_0x1f2020){var _0x28dd19=_0x3870fb[_0xc8be('0x2d')];var _0x147cd7=0xa;var _0xa383b6=[_0xc8be('0x82'),'left_join',_0xc8be('0x83'),_0xc8be('0x58')];var _0x41fa9b={'SUM':_0xc8be('0x84'),'COUNT':_0xc8be('0x59'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0xc8be('0x5b'),'MIN':_0xc8be('0x85'),'AVG':'AVG(%s)','GROUP_CONCAT':_0xc8be('0x86'),'GROUP_CONCAT ASC':_0xc8be('0x5d'),'GROUP_CONCAT DESC':_0xc8be('0x5e')};var _0xc4b85b={'SEC_TO_TIME':_0xc8be('0x87'),'DATE':'DATE(%s)','HOUR':_0xc8be('0x88'),'ROUND':_0xc8be('0x5f'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x53b3d2=function(_0x263803){return!_['includes']([_0xc8be('0x89'),'IS\x20NOT\x20NULL',_0xc8be('0x63'),'IS\x20NOT\x20EMPTY'],_0x263803);};var _0x6fc3d3=function(_0x3fced6){if(!_0x3fced6||!_0x3fced6['rules']['length']){return'';}for(var _0x593dd0='(',_0x20fd0b=0x0;_0x20fd0b<_0x3fced6['rules'][_0xc8be('0x3b')];_0x20fd0b+=0x1){_0x20fd0b>0x0&&(_0x593dd0+='\x20'+_0x3fced6[_0xc8be('0x66')]+'\x20');_0x593dd0+=_0x3fced6['rules'][_0x20fd0b][_0xc8be('0x67')]?_0x6fc3d3(_0x3fced6[_0xc8be('0x65')][_0x20fd0b][_0xc8be('0x67')]):_0x3fced6[_0xc8be('0x65')][_0x20fd0b][_0xc8be('0x68')]+'\x20'+_0x3fced6[_0xc8be('0x65')][_0x20fd0b][_0xc8be('0x69')]+(_0x53b3d2(_0x3fced6[_0xc8be('0x65')][_0x20fd0b][_0xc8be('0x69')])?'\x20'+_0x3fced6[_0xc8be('0x65')][_0x20fd0b]['value']:'');}return _0x593dd0+')';};var _0x2bb7f9={'where':{'id':_0x688161['id']}},_0x32b758,_0x1a9162,_0x33bdcf,_0x5a69ad,_0x596c3b;_0x2bb7f9=_[_0xc8be('0x44')]({},_0x2bb7f9,_0x1f2020);return db[_0xc8be('0x2f')][_0xc8be('0x55')](_0x2bb7f9)[_0xc8be('0x26')](function(_0x3c7d22){if(_0x3c7d22){_0x32b758=_0x3c7d22;return _0x3c7d22[_0xc8be('0x6a')]();}return null;})[_0xc8be('0x26')](function(_0x34448e){if(_0x34448e){if(!_0x34448e['length']){throw new db['Sequelize'][(_0xc8be('0x6c'))](_0xc8be('0x8a'),0x193);}_0x1a9162=_0x34448e;return db['AnalyticMetric'][_0xc8be('0x47')]({'raw':!![]});}return null;})[_0xc8be('0x26')](function(_0x3ce586){if(_0x3ce586){_0x33bdcf=_[_0xc8be('0x8b')](_0x3ce586,'id');var _0x2c5407;var _0x4e5272=squel['select']();_0x4e5272[_0xc8be('0x8c')](_0x32b758[_0xc8be('0x6e')]);for(var _0x470c99=0x0;_0x470c99<_0x1a9162[_0xc8be('0x3b')];_0x470c99+=0x1){_0x2c5407=_0x1a9162[_0x470c99]['MetricId']?_0x33bdcf[_0x1a9162[_0x470c99][_0xc8be('0x6f')]][_0xc8be('0x8d')]:_0x1a9162[_0x470c99]['field'];_0x2c5407=_0x1a9162[_0x470c99][_0xc8be('0x71')]?_[_0xc8be('0x70')](_0x41fa9b[_0x1a9162[_0x470c99]['function']],'%s',_0x2c5407):_0x2c5407;_0x2c5407=_0x1a9162[_0x470c99]['format']?_[_0xc8be('0x70')](_0xc4b85b[_0x1a9162[_0x470c99]['format']],'%s',_0x2c5407):_0x2c5407;if(_0x1a9162[_0x470c99]['groupBy']){_0x4e5272['group'](_0x2c5407);}_0x1a9162[_0x470c99][_0xc8be('0x8e')]&&_0x4e5272[_0xc8be('0x3d')](_0x2c5407,_0x1a9162[_0x470c99][_0xc8be('0x8e')]==='DESC'?![]:!![]);_0x4e5272[_0xc8be('0x68')](_0x2c5407,_0x1a9162[_0x470c99][_0xc8be('0x75')]||_0x2c5407);}if(_0x32b758['joins']){_0x32b758[_0xc8be('0x76')]=JSON[_0xc8be('0x7c')](_0x32b758['joins']);for(var _0x55beaa=0x0;_0x55beaa<_0x32b758['joins'][_0xc8be('0x3b')];_0x55beaa+=0x1){if(_0x32b758[_0xc8be('0x76')][_0x55beaa]['type']&&_[_0xc8be('0x61')](_0xa383b6,_0x32b758[_0xc8be('0x76')][_0x55beaa]['type'])&&_0x32b758[_0xc8be('0x76')][_0x55beaa]['parentKey']&&_0x32b758[_0xc8be('0x76')][_0x55beaa]['foreignTable']&&_0x32b758[_0xc8be('0x76')][_0x55beaa][_0xc8be('0x7a')]){_0x4e5272[_0x32b758[_0xc8be('0x76')][_0x55beaa][_0xc8be('0x32')]](_0x32b758[_0xc8be('0x76')][_0x55beaa][_0xc8be('0x78')],null,util['format'](_0xc8be('0x79'),_0x32b758['table'],_0x32b758[_0xc8be('0x76')][_0x55beaa]['parentKey'],_0x32b758[_0xc8be('0x76')][_0x55beaa][_0xc8be('0x78')],_0x32b758[_0xc8be('0x76')][_0x55beaa][_0xc8be('0x7a')]));}}}if(_0x32b758[_0xc8be('0x7b')]){_0x32b758[_0xc8be('0x7b')]=JSON['parse'](_0x32b758[_0xc8be('0x7b')]);_0x4e5272[_0xc8be('0x3f')](_0x6fc3d3(_0x32b758[_0xc8be('0x7b')][_0xc8be('0x67')]));}_0x596c3b=_0x4e5272[_0xc8be('0x7d')]();_0x4e5272[_0xc8be('0x1d')](_0x147cd7);_0x4e5272[_0xc8be('0x20')](0x0);return;}})['then'](function(){if(_0x3870fb[_0xc8be('0x8f')]===_0xc8be('0x90')){return null;}var _0x548685=_[_0xc8be('0x44')](_0x3870fb,{'name':_0x3870fb[_0xc8be('0x91')]||_0x3870fb[_0xc8be('0x2d')]||_0x32b758['name'],'basename':_0x28dd19,'savename':util['format'](_0xc8be('0x92'),_0x3870fb[_0xc8be('0x2d')]||_0x32b758[_0xc8be('0x2d')],require(_0xc8be('0x93'))[_0xc8be('0x94')](0x4),_0x3870fb[_0xc8be('0x8f')]||_0xc8be('0x95')),'reportId':_0x32b758['id'],'reportType':_0xc8be('0x96')});return db[_0xc8be('0x97')][_0xc8be('0x4c')](_0x548685,{'raw':!![]});})['then'](function(_0x34cdfe){if(_0x32b758[_0xc8be('0x6e')]==='cdr'){_0x596c3b[_0xc8be('0x3f')](_0x32b758[_0xc8be('0x6e')]+_0xc8be('0x98'),_0x3870fb[_0xc8be('0x99')],_0x3870fb[_0xc8be('0x9a')]);}else{_0x596c3b[_0xc8be('0x3f')](_0x32b758[_0xc8be('0x6e')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x3870fb[_0xc8be('0x99')],_0x3870fb[_0xc8be('0x9a')]);}if(_0x34cdfe){logger[_0xc8be('0x9b')](_0xc8be('0x9c'),_0x596c3b['toString']());require('child_process')['fork'](path[_0xc8be('0x82')](__dirname,'../../components/export/',_0x34cdfe['output']),[_0x34cdfe['id'],_0x596c3b['toString'](),path[_0xc8be('0x82')](__dirname,'../../files/reports',_0x34cdfe[_0xc8be('0x9d')]),_0x28dd19]);return _0x34cdfe;}else{var _0x473864=squel[_0xc8be('0x9e')]();_0x473864[_0xc8be('0x8c')]('('+_0x596c3b[_0xc8be('0x7f')]()+')',_0xc8be('0x9f'));_0x473864[_0xc8be('0x68')](_0xc8be('0xa0'),_0xc8be('0x1f'));_0x596c3b[_0xc8be('0x1d')](_0x3870fb['limit']||_0x147cd7);_0x596c3b['offset'](_0x3870fb[_0xc8be('0x20')]||0x0);return dbH['sequelize'][_0xc8be('0x35')](_0x473864[_0xc8be('0x7f')](),{'type':dbH['sequelize'][_0xc8be('0x80')][_0xc8be('0x81')]})[_0xc8be('0x26')](function(_0x5e162c){if(!_0x5e162c['length']){_0x5a69ad=0x0;}else{_0x5a69ad=_0x5e162c[0x0][_0xc8be('0x1f')]||0x0;}return dbH[_0xc8be('0xa1')][_0xc8be('0x35')](_0x596c3b[_0xc8be('0x7f')](),{'type':dbH[_0xc8be('0xa1')][_0xc8be('0x80')][_0xc8be('0x81')]});})[_0xc8be('0x26')](function(_0x5d19fb){return{'rows':_0x5d19fb||[],'count':_0x5a69ad};});}});}exports[_0xc8be('0xa2')]=function(_0x135519,_0x39df69){return runReport(_0x135519['params'],_0x135519['query'],_0x135519['options'])[_0xc8be('0x26')](respondWithResult(_0x39df69,null))[_0xc8be('0x49')](handleError(_0x39df69,null));};exports['runReport']=runReport;exports[_0xc8be('0x35')]=function(_0x20eaeb,_0x5459a8){var _0x2832c3=0xa;var _0x20bea8=[_0xc8be('0x82'),_0xc8be('0x57'),_0xc8be('0x83'),_0xc8be('0x58')];var _0x58ed5f={'SUM':_0xc8be('0x84'),'COUNT':_0xc8be('0x59'),'COUNT DISTINCT':_0xc8be('0x5a'),'MAX':_0xc8be('0x5b'),'MIN':_0xc8be('0x85'),'AVG':_0xc8be('0x5c'),'GROUP_CONCAT':_0xc8be('0x86'),'GROUP_CONCAT ASC':_0xc8be('0x5d'),'GROUP_CONCAT DESC':_0xc8be('0x5e')};var _0x4b7ae5={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0xc8be('0xa3'),'HOUR':'HOUR(%s)','ROUND':_0xc8be('0x5f'),'UNIX_TIMESTAMP':_0xc8be('0x60')};var _0x3738fb=function(_0x2d2f9e){return!_['includes']([_0xc8be('0x89'),'IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY'],_0x2d2f9e);};var _0xb3f27a=function(_0x2f3c8c){if(!_0x2f3c8c||!_0x2f3c8c[_0xc8be('0x65')]['length']){return'';}for(var _0x1cbc3e='(',_0x494b15=0x0;_0x494b15<_0x2f3c8c[_0xc8be('0x65')][_0xc8be('0x3b')];_0x494b15+=0x1){_0x494b15>0x0&&(_0x1cbc3e+='\x20'+_0x2f3c8c[_0xc8be('0x66')]+'\x20');_0x1cbc3e+=_0x2f3c8c[_0xc8be('0x65')][_0x494b15]['group']?_0xb3f27a(_0x2f3c8c[_0xc8be('0x65')][_0x494b15][_0xc8be('0x67')]):_0x2f3c8c[_0xc8be('0x65')][_0x494b15][_0xc8be('0x68')]+'\x20'+_0x2f3c8c[_0xc8be('0x65')][_0x494b15]['condition']+(_0x3738fb(_0x2f3c8c[_0xc8be('0x65')][_0x494b15][_0xc8be('0x69')])?'\x20'+_0x2f3c8c[_0xc8be('0x65')][_0x494b15]['value']:'');}return _0x1cbc3e+')';};var _0x4d9b54={'where':{'id':_0x20eaeb[_0xc8be('0x4a')]['id']}},_0x2d16bc,_0xf1d11c,_0x383f81,_0xd992b1,_0x152bf1;_0x4d9b54=_[_0xc8be('0x44')]({},_0x4d9b54,_0x20eaeb[_0xc8be('0x45')]);return db['AnalyticCustomReport'][_0xc8be('0x55')](_0x4d9b54)[_0xc8be('0x26')](function(_0x2db12c){if(_0x2db12c){_0x2d16bc=_0x2db12c;return _0x2db12c[_0xc8be('0x6a')]();}return null;})[_0xc8be('0x26')](function(_0x512a8c){if(_0x512a8c){if(!_0x512a8c[_0xc8be('0x3b')]){throw new db[(_0xc8be('0x6b'))][(_0xc8be('0x6c'))](_0xc8be('0x8a'),0x193);}_0xf1d11c=_0x512a8c;return db[_0xc8be('0x6d')][_0xc8be('0x47')]({'raw':!![]});}return null;})[_0xc8be('0x26')](function(_0x24842c){if(_0x24842c){_0x383f81=_[_0xc8be('0x8b')](_0x24842c,'id');var _0x3fe10e;var _0x2a88c9=squel[_0xc8be('0x9e')]();_0x2a88c9['from'](_0x2d16bc[_0xc8be('0x6e')]);for(var _0x1e5e20=0x0;_0x1e5e20<_0xf1d11c[_0xc8be('0x3b')];_0x1e5e20+=0x1){_0x3fe10e=_0xf1d11c[_0x1e5e20]['MetricId']?_0x383f81[_0xf1d11c[_0x1e5e20][_0xc8be('0x6f')]][_0xc8be('0x8d')]:_0xf1d11c[_0x1e5e20][_0xc8be('0x68')];_0x3fe10e=_0xf1d11c[_0x1e5e20][_0xc8be('0x71')]?_[_0xc8be('0x70')](_0x58ed5f[_0xf1d11c[_0x1e5e20][_0xc8be('0x71')]],'%s',_0x3fe10e):_0x3fe10e;_0x3fe10e=_0xf1d11c[_0x1e5e20][_0xc8be('0x72')]?_[_0xc8be('0x70')](_0x4b7ae5[_0xf1d11c[_0x1e5e20]['format']],'%s',_0x3fe10e):_0x3fe10e;if(_0xf1d11c[_0x1e5e20][_0xc8be('0x73')]){_0x2a88c9[_0xc8be('0x67')](_0x3fe10e);}_0xf1d11c[_0x1e5e20]['orderBy']&&_0x2a88c9[_0xc8be('0x3d')](_0x3fe10e,_0xf1d11c[_0x1e5e20][_0xc8be('0x8e')]===_0xc8be('0x74')?![]:!![]);_0x2a88c9[_0xc8be('0x68')](_0x3fe10e,_0xf1d11c[_0x1e5e20]['alias']||_0x3fe10e);}if(_0x2d16bc[_0xc8be('0x76')]){_0x2d16bc[_0xc8be('0x76')]=JSON[_0xc8be('0x7c')](_0x2d16bc[_0xc8be('0x76')]);for(var _0x39f3fd=0x0;_0x39f3fd<_0x2d16bc['joins'][_0xc8be('0x3b')];_0x39f3fd+=0x1){if(_0x2d16bc['joins'][_0x39f3fd]['type']&&_[_0xc8be('0x61')](_0x20bea8,_0x2d16bc[_0xc8be('0x76')][_0x39f3fd][_0xc8be('0x32')])&&_0x2d16bc['joins'][_0x39f3fd][_0xc8be('0x77')]&&_0x2d16bc[_0xc8be('0x76')][_0x39f3fd][_0xc8be('0x78')]&&_0x2d16bc['joins'][_0x39f3fd][_0xc8be('0x7a')]){_0x2a88c9[_0x2d16bc['joins'][_0x39f3fd][_0xc8be('0x32')]](_0x2d16bc['joins'][_0x39f3fd]['foreignTable'],null,util[_0xc8be('0x72')](_0xc8be('0x79'),_0x2d16bc['table'],_0x2d16bc[_0xc8be('0x76')][_0x39f3fd]['parentKey'],_0x2d16bc[_0xc8be('0x76')][_0x39f3fd][_0xc8be('0x78')],_0x2d16bc[_0xc8be('0x76')][_0x39f3fd][_0xc8be('0x7a')]));}}}if(_0x2d16bc[_0xc8be('0x7b')]){_0x2d16bc['conditions']=JSON['parse'](_0x2d16bc[_0xc8be('0x7b')]);_0x2a88c9[_0xc8be('0x3f')](_0xb3f27a(_0x2d16bc[_0xc8be('0x7b')][_0xc8be('0x67')]));}_0x152bf1=_0x2a88c9[_0xc8be('0x7d')]();_0x2a88c9['limit'](_0x2832c3);_0x2a88c9[_0xc8be('0x20')](0x0);logger['debug'](_0xc8be('0x7e'),_0x2a88c9['toString']());return dbH['sequelize'][_0xc8be('0x35')](_0x2a88c9[_0xc8be('0x7f')](),{'type':dbH['sequelize']['QueryTypes']['SELECT']});}})[_0xc8be('0x26')](function(){return{'sql':_0x152bf1[_0xc8be('0x7f')]()};})[_0xc8be('0x26')](respondWithResult(_0x5459a8,null))[_0xc8be('0x49')](handleError(_0x5459a8,null));};
\ No newline at end of file
+var _0xae02=['AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','endDate','info','Run\x20Query:','fork','../../components/export/','../../files/reports','savename','countTable','COUNT(*)','QueryTypes','run','COUNT(DISTINCT\x20%s)','clone','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','fs-extra','lodash','squel','desk.js','papaparse','ioredis','../../components/auth/service','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','dbH','sendStatus','status','offset','undefined','limit','count','set','json','apply','save','update','then','UserProfileResource','end','stack','name','send','index','map','AnalyticCustomReport','rawAttributes','fieldName','type','keys','query','filters','attributes','intersection','fields','length','model','hasOwnProperty','order','sort','where','pick','merge','VIRTUAL','filter','options','includeAll','include','findAll','rows','catch','create','body','user','get','role','Reports','UserProfileSection','userProfileId','autoAssociation','CustomReports','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','find','params','destroy','preview','left_join','cross_join','SUM(%s)','MAX(%s)','AVG(%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)','UNIX_TIMESTAMP(%s)','includes','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','value','getFields','Sequelize','AnalyticMetric','keyBy','select','MetricId','metric','function','replace','format','groupBy','orderBy','DESC','alias','joins','parse','parentKey','foreignTable','%s.%s\x20=\x20%s.%s','table','foreignKey','conditions','debug','Limited\x20Query:','toString','sequelize','SELECT','join','right_join','COUNT(%s)','MIN(%s)','IS\x20NULL','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','from','output','web','csv','custom'];(function(_0x4f3522,_0x3e9fb){var _0x5b4de7=function(_0x176d69){while(--_0x176d69){_0x4f3522['push'](_0x4f3522['shift']());}};_0x5b4de7(++_0x3e9fb);}(_0xae02,0xb7));var _0x2ae0=function(_0x5e0bee,_0xd2c6cf){_0x5e0bee=_0x5e0bee-0x0;var _0xac61d2=_0xae02[_0x5e0bee];return _0xac61d2;};'use strict';var emlformat=require(_0x2ae0('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x2ae0('0x1'));var jsonpatch=require(_0x2ae0('0x2'));var rp=require(_0x2ae0('0x3'));var moment=require(_0x2ae0('0x4'));var BPromise=require(_0x2ae0('0x5'));var Mustache=require(_0x2ae0('0x6'));var util=require(_0x2ae0('0x7'));var path=require(_0x2ae0('0x8'));var sox=require('sox');var csv=require(_0x2ae0('0x9'));var ejs=require(_0x2ae0('0xa'));var fs=require('fs');var fs_extra=require(_0x2ae0('0xb'));var _=require(_0x2ae0('0xc'));var squel=require(_0x2ae0('0xd'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0x2ae0('0xe'));var toCsv=require(_0x2ae0('0x9'));var querystring=require('querystring');var Papa=require(_0x2ae0('0xf'));var Redis=require(_0x2ae0('0x10'));var authService=require(_0x2ae0('0x11'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x2ae0('0x12'))(_0x2ae0('0x13'));var utils=require(_0x2ae0('0x14'));var config=require(_0x2ae0('0x15'));var licenseUtil=require(_0x2ae0('0x16'));var db=require(_0x2ae0('0x17'))['db'];var dbH=require(_0x2ae0('0x17'))[_0x2ae0('0x18')];function respondWithStatusCode(_0x557dbc,_0x162a90){_0x162a90=_0x162a90||0xcc;return function(_0xcaea14){if(_0xcaea14){return _0x557dbc[_0x2ae0('0x19')](_0x162a90);}return _0x557dbc[_0x2ae0('0x1a')](_0x162a90)['end']();};}function respondWithResult(_0x127e7f,_0x4f2fc8){_0x4f2fc8=_0x4f2fc8||0xc8;return function(_0x42c900){if(_0x42c900){return _0x127e7f['status'](_0x4f2fc8)['json'](_0x42c900);}};}function respondWithFilteredResult(_0x1e5373,_0x30faa5){return function(_0x2c5db9){if(_0x2c5db9){var _0x3af1cd=typeof _0x30faa5[_0x2ae0('0x1b')]===_0x2ae0('0x1c')&&typeof _0x30faa5[_0x2ae0('0x1d')]===_0x2ae0('0x1c');var _0x25166e=_0x2c5db9[_0x2ae0('0x1e')];var _0x297235=_0x3af1cd?0x0:_0x30faa5[_0x2ae0('0x1b')];var _0x560390=_0x3af1cd?_0x2c5db9[_0x2ae0('0x1e')]:_0x30faa5[_0x2ae0('0x1b')]+_0x30faa5[_0x2ae0('0x1d')];var _0xbdc99e;if(_0x560390>=_0x25166e){_0x560390=_0x25166e;_0xbdc99e=0xc8;}else{_0xbdc99e=0xce;}_0x1e5373[_0x2ae0('0x1a')](_0xbdc99e);return _0x1e5373[_0x2ae0('0x1f')]('Content-Range',_0x297235+'-'+_0x560390+'/'+_0x25166e)[_0x2ae0('0x20')](_0x2c5db9);}return null;};}function patchUpdates(_0x399ece){return function(_0x489220){try{jsonpatch[_0x2ae0('0x21')](_0x489220,_0x399ece,!![]);}catch(_0x2e4cca){return BPromise['reject'](_0x2e4cca);}return _0x489220[_0x2ae0('0x22')]();};}function saveUpdates(_0x3ef00a,_0x1a842a){return function(_0x584bd4){if(_0x584bd4){return _0x584bd4[_0x2ae0('0x23')](_0x3ef00a)[_0x2ae0('0x24')](function(_0x528ce7){return _0x528ce7;});}return null;};}function removeEntity(_0x3873fc,_0x436721){return function(_0x221285){if(_0x221285){return _0x221285['destroy']()[_0x2ae0('0x24')](function(){var _0x5caf5a=_0x221285['get']({'plain':!![]});var _0x20d729='CustomReports';return db[_0x2ae0('0x25')]['destroy']({'where':{'type':_0x20d729,'resourceId':_0x5caf5a['id']}})[_0x2ae0('0x24')](function(){return _0x221285;});})[_0x2ae0('0x24')](function(){_0x3873fc[_0x2ae0('0x1a')](0xcc)[_0x2ae0('0x26')]();});}};}function handleEntityNotFound(_0x325be5,_0x50bec8){return function(_0x448a19){if(!_0x448a19){_0x325be5[_0x2ae0('0x19')](0x194);}return _0x448a19;};}function handleError(_0x478c10,_0x2a83bd){_0x2a83bd=_0x2a83bd||0x1f4;return function(_0x590869){logger['error'](_0x590869[_0x2ae0('0x27')]);if(_0x590869[_0x2ae0('0x28')]){delete _0x590869['name'];}_0x478c10[_0x2ae0('0x1a')](_0x2a83bd)[_0x2ae0('0x29')](_0x590869);};}exports[_0x2ae0('0x2a')]=function(_0x4dcc6b,_0x1f57d7){var _0x4e5598={},_0x34182e={},_0x326dcb={'count':0x0,'rows':[]};var _0x3a06d3=_[_0x2ae0('0x2b')](db[_0x2ae0('0x2c')][_0x2ae0('0x2d')],function(_0x403511){return{'name':_0x403511[_0x2ae0('0x2e')],'type':_0x403511[_0x2ae0('0x2f')]['key']};});_0x34182e['model']=_[_0x2ae0('0x2b')](_0x3a06d3,_0x2ae0('0x28'));_0x34182e['query']=_[_0x2ae0('0x30')](_0x4dcc6b[_0x2ae0('0x31')]);_0x34182e[_0x2ae0('0x32')]=_['intersection'](_0x34182e['model'],_0x34182e['query']);_0x4e5598[_0x2ae0('0x33')]=_[_0x2ae0('0x34')](_0x34182e['model'],qs[_0x2ae0('0x35')](_0x4dcc6b[_0x2ae0('0x31')][_0x2ae0('0x35')]));_0x4e5598[_0x2ae0('0x33')]=_0x4e5598[_0x2ae0('0x33')][_0x2ae0('0x36')]?_0x4e5598[_0x2ae0('0x33')]:_0x34182e[_0x2ae0('0x37')];if(!_0x4dcc6b[_0x2ae0('0x31')][_0x2ae0('0x38')]('nolimit')){_0x4e5598[_0x2ae0('0x1d')]=qs[_0x2ae0('0x1d')](_0x4dcc6b[_0x2ae0('0x31')]['limit']);_0x4e5598[_0x2ae0('0x1b')]=qs[_0x2ae0('0x1b')](_0x4dcc6b['query']['offset']);}_0x4e5598[_0x2ae0('0x39')]=qs[_0x2ae0('0x3a')](_0x4dcc6b[_0x2ae0('0x31')][_0x2ae0('0x3a')]);_0x4e5598[_0x2ae0('0x3b')]=qs[_0x2ae0('0x32')](_[_0x2ae0('0x3c')](_0x4dcc6b[_0x2ae0('0x31')],_0x34182e['filters']),_0x3a06d3);if(_0x4dcc6b[_0x2ae0('0x31')]['filter']){_0x4e5598[_0x2ae0('0x3b')]=_[_0x2ae0('0x3d')](_0x4e5598[_0x2ae0('0x3b')],{'$or':_[_0x2ae0('0x2b')](_0x3a06d3,function(_0x1e80d9){if(_0x1e80d9[_0x2ae0('0x2f')]!==_0x2ae0('0x3e')){var _0x54a70e={};_0x54a70e[_0x1e80d9[_0x2ae0('0x28')]]={'$like':'%'+_0x4dcc6b[_0x2ae0('0x31')][_0x2ae0('0x3f')]+'%'};return _0x54a70e;}})});}_0x4e5598=_[_0x2ae0('0x3d')]({},_0x4e5598,_0x4dcc6b[_0x2ae0('0x40')]);var _0xad4343={'where':_0x4e5598['where']};return db['AnalyticCustomReport'][_0x2ae0('0x1e')](_0xad4343)[_0x2ae0('0x24')](function(_0x3dfd1f){_0x326dcb[_0x2ae0('0x1e')]=_0x3dfd1f;if(_0x4dcc6b[_0x2ae0('0x31')][_0x2ae0('0x41')]){_0x4e5598[_0x2ae0('0x42')]=[{'all':!![]}];}return db['AnalyticCustomReport'][_0x2ae0('0x43')](_0x4e5598);})[_0x2ae0('0x24')](function(_0x1d7a75){_0x326dcb[_0x2ae0('0x44')]=_0x1d7a75;return _0x326dcb;})[_0x2ae0('0x24')](respondWithFilteredResult(_0x1f57d7,_0x4e5598))['catch'](handleError(_0x1f57d7,null));};exports['show']=function(_0x299c48,_0x47f139){var _0x2c6b36={'raw':![],'where':{'id':_0x299c48['params']['id']}},_0xcac4a1={};_0xcac4a1[_0x2ae0('0x37')]=_[_0x2ae0('0x30')](db[_0x2ae0('0x2c')]['rawAttributes']);_0xcac4a1[_0x2ae0('0x31')]=_[_0x2ae0('0x30')](_0x299c48[_0x2ae0('0x31')]);_0xcac4a1[_0x2ae0('0x32')]=_[_0x2ae0('0x34')](_0xcac4a1[_0x2ae0('0x37')],_0xcac4a1[_0x2ae0('0x31')]);_0x2c6b36[_0x2ae0('0x33')]=_[_0x2ae0('0x34')](_0xcac4a1[_0x2ae0('0x37')],qs[_0x2ae0('0x35')](_0x299c48[_0x2ae0('0x31')][_0x2ae0('0x35')]));_0x2c6b36[_0x2ae0('0x33')]=_0x2c6b36[_0x2ae0('0x33')][_0x2ae0('0x36')]?_0x2c6b36['attributes']:_0xcac4a1[_0x2ae0('0x37')];if(_0x299c48['query'][_0x2ae0('0x41')]){_0x2c6b36['include']=[{'all':!![]}];}_0x2c6b36=_[_0x2ae0('0x3d')]({},_0x2c6b36,_0x299c48[_0x2ae0('0x40')]);return db[_0x2ae0('0x2c')]['find'](_0x2c6b36)[_0x2ae0('0x24')](handleEntityNotFound(_0x47f139,null))[_0x2ae0('0x24')](respondWithResult(_0x47f139,null))[_0x2ae0('0x45')](handleError(_0x47f139,null));};exports[_0x2ae0('0x46')]=function(_0xb64197,_0x4b1737){return db[_0x2ae0('0x2c')][_0x2ae0('0x46')](_0xb64197[_0x2ae0('0x47')],{})['then'](function(_0x5acf46){var _0x3768d7=_0xb64197[_0x2ae0('0x48')][_0x2ae0('0x49')]({'plain':!![]});if(!_0x3768d7)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x3768d7[_0x2ae0('0x4a')]===_0x2ae0('0x48')){var _0x2539d0=_0x5acf46['get']({'plain':!![]});var _0x43e738=_0x2ae0('0x4b');return db[_0x2ae0('0x4c')]['find']({'where':{'name':_0x43e738,'userProfileId':_0x3768d7[_0x2ae0('0x4d')]},'raw':!![]})['then'](function(_0x4722d3){if(_0x4722d3&&_0x4722d3[_0x2ae0('0x4e')]===0x0){return db[_0x2ae0('0x25')][_0x2ae0('0x46')]({'name':_0x2539d0[_0x2ae0('0x28')],'resourceId':_0x2539d0['id'],'type':_0x2ae0('0x4f'),'sectionId':_0x4722d3['id']},{})['then'](function(){return _0x5acf46;});}else{return _0x5acf46;}})[_0x2ae0('0x45')](function(_0x35f103){logger[_0x2ae0('0x50')](_0x2ae0('0x51'),_0x35f103);throw _0x35f103;});}return _0x5acf46;})['then'](respondWithResult(_0x4b1737,0xc9))[_0x2ae0('0x45')](handleError(_0x4b1737,null));};exports[_0x2ae0('0x23')]=function(_0x10a921,_0x5650c4){if(_0x10a921[_0x2ae0('0x47')]['id']){delete _0x10a921['body']['id'];}return db[_0x2ae0('0x2c')][_0x2ae0('0x52')]({'where':{'id':_0x10a921[_0x2ae0('0x53')]['id']}})[_0x2ae0('0x24')](handleEntityNotFound(_0x5650c4,null))[_0x2ae0('0x24')](saveUpdates(_0x10a921[_0x2ae0('0x47')],null))['then'](respondWithResult(_0x5650c4,null))[_0x2ae0('0x45')](handleError(_0x5650c4,null));};exports[_0x2ae0('0x54')]=function(_0x2bb8fc,_0x6be513){return db['AnalyticCustomReport'][_0x2ae0('0x52')]({'where':{'id':_0x2bb8fc[_0x2ae0('0x53')]['id']}})['then'](handleEntityNotFound(_0x6be513,null))['then'](removeEntity(_0x6be513,null))['catch'](handleError(_0x6be513,null));};exports[_0x2ae0('0x55')]=function(_0x2f9f6e,_0x43bcc1){var _0x3648f4=0xa;var _0x2f0cf8=['join',_0x2ae0('0x56'),'right_join',_0x2ae0('0x57')];var _0x5597cb={'SUM':_0x2ae0('0x58'),'COUNT':'COUNT(%s)','COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x2ae0('0x59'),'MIN':'MIN(%s)','AVG':_0x2ae0('0x5a'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x2ae0('0x5b'),'GROUP_CONCAT DESC':_0x2ae0('0x5c')};var _0x5efda2={'SEC_TO_TIME':_0x2ae0('0x5d'),'DATE':_0x2ae0('0x5e'),'HOUR':_0x2ae0('0x5f'),'ROUND':_0x2ae0('0x60'),'UNIX_TIMESTAMP':_0x2ae0('0x61')};var _0x316ea7=function(_0x5de063){return!_[_0x2ae0('0x62')](['IS\x20NULL',_0x2ae0('0x63'),_0x2ae0('0x64'),_0x2ae0('0x65')],_0x5de063);};var _0x490250=function(_0x273a6a){if(!_0x273a6a||!_0x273a6a['rules'][_0x2ae0('0x36')]){return'';}for(var _0x476e54='(',_0xd886bc=0x0;_0xd886bc<_0x273a6a[_0x2ae0('0x66')]['length'];_0xd886bc+=0x1){_0xd886bc>0x0&&(_0x476e54+='\x20'+_0x273a6a[_0x2ae0('0x67')]+'\x20');_0x476e54+=_0x273a6a[_0x2ae0('0x66')][_0xd886bc][_0x2ae0('0x68')]?_0x490250(_0x273a6a[_0x2ae0('0x66')][_0xd886bc]['group']):_0x273a6a[_0x2ae0('0x66')][_0xd886bc][_0x2ae0('0x69')]+'\x20'+_0x273a6a[_0x2ae0('0x66')][_0xd886bc][_0x2ae0('0x6a')]+(_0x316ea7(_0x273a6a[_0x2ae0('0x66')][_0xd886bc][_0x2ae0('0x6a')])?'\x20'+_0x273a6a[_0x2ae0('0x66')][_0xd886bc][_0x2ae0('0x6b')]:'');}return _0x476e54+')';};var _0x5a1863={'where':{'id':_0x2f9f6e[_0x2ae0('0x53')]['id']}},_0x8217b6,_0xea7a62,_0xc47edf,_0x451203,_0x1786fb;_0x5a1863=_[_0x2ae0('0x3d')]({},_0x5a1863,_0x2f9f6e['options']);return db[_0x2ae0('0x2c')][_0x2ae0('0x52')](_0x5a1863)[_0x2ae0('0x24')](function(_0x5959bc){if(_0x5959bc){_0x8217b6=_0x5959bc;return _0x5959bc[_0x2ae0('0x6c')]();}return null;})['then'](function(_0x90b787){if(_0x90b787){if(!_0x90b787['length']){throw new db[(_0x2ae0('0x6d'))]['ValidationErrorItem']('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0xea7a62=_0x90b787;return db[_0x2ae0('0x6e')][_0x2ae0('0x43')]({'raw':!![]});}return null;})[_0x2ae0('0x24')](function(_0x513afb){if(_0x513afb){_0xc47edf=_[_0x2ae0('0x6f')](_0x513afb,'id');var _0x30de37;var _0xb08814=squel[_0x2ae0('0x70')]();_0xb08814['from'](_0x8217b6['table']);for(var _0x3c4c9c=0x0;_0x3c4c9c<_0xea7a62[_0x2ae0('0x36')];_0x3c4c9c+=0x1){_0x30de37=_0xea7a62[_0x3c4c9c][_0x2ae0('0x71')]?_0xc47edf[_0xea7a62[_0x3c4c9c]['MetricId']][_0x2ae0('0x72')]:_0xea7a62[_0x3c4c9c]['field'];_0x30de37=_0xea7a62[_0x3c4c9c][_0x2ae0('0x73')]?_[_0x2ae0('0x74')](_0x5597cb[_0xea7a62[_0x3c4c9c]['function']],'%s',_0x30de37):_0x30de37;_0x30de37=_0xea7a62[_0x3c4c9c][_0x2ae0('0x75')]?_[_0x2ae0('0x74')](_0x5efda2[_0xea7a62[_0x3c4c9c][_0x2ae0('0x75')]],'%s',_0x30de37):_0x30de37;if(_0xea7a62[_0x3c4c9c][_0x2ae0('0x76')]){_0xb08814[_0x2ae0('0x68')](_0x30de37);}_0xea7a62[_0x3c4c9c][_0x2ae0('0x77')]&&_0xb08814[_0x2ae0('0x39')](_0x30de37,_0xea7a62[_0x3c4c9c][_0x2ae0('0x77')]===_0x2ae0('0x78')?![]:!![]);_0xb08814[_0x2ae0('0x69')](_0x30de37,_0xea7a62[_0x3c4c9c][_0x2ae0('0x79')]||_0x30de37);}if(_0x8217b6[_0x2ae0('0x7a')]){_0x8217b6[_0x2ae0('0x7a')]=JSON[_0x2ae0('0x7b')](_0x8217b6[_0x2ae0('0x7a')]);for(var _0x5047c3=0x0;_0x5047c3<_0x8217b6[_0x2ae0('0x7a')]['length'];_0x5047c3+=0x1){if(_0x8217b6[_0x2ae0('0x7a')][_0x5047c3][_0x2ae0('0x2f')]&&_[_0x2ae0('0x62')](_0x2f0cf8,_0x8217b6[_0x2ae0('0x7a')][_0x5047c3][_0x2ae0('0x2f')])&&_0x8217b6['joins'][_0x5047c3][_0x2ae0('0x7c')]&&_0x8217b6[_0x2ae0('0x7a')][_0x5047c3][_0x2ae0('0x7d')]&&_0x8217b6[_0x2ae0('0x7a')][_0x5047c3]['foreignKey']){_0xb08814[_0x8217b6[_0x2ae0('0x7a')][_0x5047c3]['type']](_0x8217b6['joins'][_0x5047c3][_0x2ae0('0x7d')],null,util['format'](_0x2ae0('0x7e'),_0x8217b6[_0x2ae0('0x7f')],_0x8217b6[_0x2ae0('0x7a')][_0x5047c3][_0x2ae0('0x7c')],_0x8217b6['joins'][_0x5047c3][_0x2ae0('0x7d')],_0x8217b6[_0x2ae0('0x7a')][_0x5047c3][_0x2ae0('0x80')]));}}}if(_0x8217b6[_0x2ae0('0x81')]){_0x8217b6['conditions']=JSON[_0x2ae0('0x7b')](_0x8217b6[_0x2ae0('0x81')]);_0xb08814[_0x2ae0('0x3b')](_0x490250(_0x8217b6[_0x2ae0('0x81')]['group']));}_0x1786fb=_0xb08814['clone']();_0xb08814['limit'](_0x3648f4);_0xb08814['offset'](0x0);logger[_0x2ae0('0x82')](_0x2ae0('0x83'),_0xb08814[_0x2ae0('0x84')]());return dbH[_0x2ae0('0x85')][_0x2ae0('0x31')](_0xb08814[_0x2ae0('0x84')](),{'type':dbH[_0x2ae0('0x85')]['QueryTypes'][_0x2ae0('0x86')]});}})[_0x2ae0('0x24')](respondWithResult(_0x43bcc1,null))[_0x2ae0('0x45')](handleError(_0x43bcc1,null));};function runReport(_0x38e9cd,_0x2bc528,_0x1bd364){var _0x300bd9=_0x2bc528['name'];var _0x41496b=0xa;var _0x428fd7=[_0x2ae0('0x87'),_0x2ae0('0x56'),_0x2ae0('0x88'),_0x2ae0('0x57')];var _0x4b9fe7={'SUM':_0x2ae0('0x58'),'COUNT':_0x2ae0('0x89'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':'MAX(%s)','MIN':_0x2ae0('0x8a'),'AVG':_0x2ae0('0x5a'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x2ae0('0x5b'),'GROUP_CONCAT DESC':_0x2ae0('0x5c')};var _0x5e460b={'SEC_TO_TIME':_0x2ae0('0x5d'),'DATE':_0x2ae0('0x5e'),'HOUR':_0x2ae0('0x5f'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x4d7968=function(_0x3c407c){return!_['includes']([_0x2ae0('0x8b'),_0x2ae0('0x63'),_0x2ae0('0x64'),_0x2ae0('0x65')],_0x3c407c);};var _0x3f4a3e=function(_0x43381e){if(!_0x43381e||!_0x43381e[_0x2ae0('0x66')]['length']){return'';}for(var _0x3afa8b='(',_0x2c76e7=0x0;_0x2c76e7<_0x43381e[_0x2ae0('0x66')][_0x2ae0('0x36')];_0x2c76e7+=0x1){_0x2c76e7>0x0&&(_0x3afa8b+='\x20'+_0x43381e[_0x2ae0('0x67')]+'\x20');_0x3afa8b+=_0x43381e[_0x2ae0('0x66')][_0x2c76e7]['group']?_0x3f4a3e(_0x43381e['rules'][_0x2c76e7]['group']):_0x43381e[_0x2ae0('0x66')][_0x2c76e7][_0x2ae0('0x69')]+'\x20'+_0x43381e[_0x2ae0('0x66')][_0x2c76e7][_0x2ae0('0x6a')]+(_0x4d7968(_0x43381e['rules'][_0x2c76e7][_0x2ae0('0x6a')])?'\x20'+_0x43381e[_0x2ae0('0x66')][_0x2c76e7][_0x2ae0('0x6b')]:'');}return _0x3afa8b+')';};var _0x1cb3a0={'where':{'id':_0x38e9cd['id']}},_0x56985c,_0x24ca4a,_0x2cfb5e,_0x217966,_0x22d53e;_0x1cb3a0=_['merge']({},_0x1cb3a0,_0x1bd364);return db['AnalyticCustomReport']['find'](_0x1cb3a0)[_0x2ae0('0x24')](function(_0xdb5ed6){if(_0xdb5ed6){_0x56985c=_0xdb5ed6;return _0xdb5ed6[_0x2ae0('0x6c')]();}return null;})[_0x2ae0('0x24')](function(_0x51f912){if(_0x51f912){if(!_0x51f912[_0x2ae0('0x36')]){throw new db[(_0x2ae0('0x6d'))][(_0x2ae0('0x8c'))](_0x2ae0('0x8d'),0x193);}_0x24ca4a=_0x51f912;return db[_0x2ae0('0x6e')]['findAll']({'raw':!![]});}return null;})[_0x2ae0('0x24')](function(_0x4ef6ab){if(_0x4ef6ab){_0x2cfb5e=_['keyBy'](_0x4ef6ab,'id');var _0x5414e4;var _0x42d016=squel[_0x2ae0('0x70')]();_0x42d016[_0x2ae0('0x8e')](_0x56985c[_0x2ae0('0x7f')]);for(var _0xcfe62f=0x0;_0xcfe62f<_0x24ca4a[_0x2ae0('0x36')];_0xcfe62f+=0x1){_0x5414e4=_0x24ca4a[_0xcfe62f][_0x2ae0('0x71')]?_0x2cfb5e[_0x24ca4a[_0xcfe62f]['MetricId']][_0x2ae0('0x72')]:_0x24ca4a[_0xcfe62f]['field'];_0x5414e4=_0x24ca4a[_0xcfe62f][_0x2ae0('0x73')]?_['replace'](_0x4b9fe7[_0x24ca4a[_0xcfe62f]['function']],'%s',_0x5414e4):_0x5414e4;_0x5414e4=_0x24ca4a[_0xcfe62f]['format']?_[_0x2ae0('0x74')](_0x5e460b[_0x24ca4a[_0xcfe62f][_0x2ae0('0x75')]],'%s',_0x5414e4):_0x5414e4;if(_0x24ca4a[_0xcfe62f]['groupBy']){_0x42d016[_0x2ae0('0x68')](_0x5414e4);}_0x24ca4a[_0xcfe62f]['orderBy']&&_0x42d016[_0x2ae0('0x39')](_0x5414e4,_0x24ca4a[_0xcfe62f][_0x2ae0('0x77')]==='DESC'?![]:!![]);_0x42d016[_0x2ae0('0x69')](_0x5414e4,_0x24ca4a[_0xcfe62f][_0x2ae0('0x79')]||_0x5414e4);}if(_0x56985c[_0x2ae0('0x7a')]){_0x56985c[_0x2ae0('0x7a')]=JSON[_0x2ae0('0x7b')](_0x56985c[_0x2ae0('0x7a')]);for(var _0x58d8a7=0x0;_0x58d8a7<_0x56985c[_0x2ae0('0x7a')][_0x2ae0('0x36')];_0x58d8a7+=0x1){if(_0x56985c[_0x2ae0('0x7a')][_0x58d8a7][_0x2ae0('0x2f')]&&_[_0x2ae0('0x62')](_0x428fd7,_0x56985c[_0x2ae0('0x7a')][_0x58d8a7][_0x2ae0('0x2f')])&&_0x56985c[_0x2ae0('0x7a')][_0x58d8a7][_0x2ae0('0x7c')]&&_0x56985c['joins'][_0x58d8a7][_0x2ae0('0x7d')]&&_0x56985c['joins'][_0x58d8a7][_0x2ae0('0x80')]){_0x42d016[_0x56985c[_0x2ae0('0x7a')][_0x58d8a7][_0x2ae0('0x2f')]](_0x56985c[_0x2ae0('0x7a')][_0x58d8a7][_0x2ae0('0x7d')],null,util[_0x2ae0('0x75')](_0x2ae0('0x7e'),_0x56985c[_0x2ae0('0x7f')],_0x56985c[_0x2ae0('0x7a')][_0x58d8a7][_0x2ae0('0x7c')],_0x56985c['joins'][_0x58d8a7]['foreignTable'],_0x56985c[_0x2ae0('0x7a')][_0x58d8a7][_0x2ae0('0x80')]));}}}if(_0x56985c[_0x2ae0('0x81')]){_0x56985c[_0x2ae0('0x81')]=JSON[_0x2ae0('0x7b')](_0x56985c[_0x2ae0('0x81')]);_0x42d016['where'](_0x3f4a3e(_0x56985c[_0x2ae0('0x81')][_0x2ae0('0x68')]));}_0x22d53e=_0x42d016['clone']();_0x42d016[_0x2ae0('0x1d')](_0x41496b);_0x42d016['offset'](0x0);return;}})[_0x2ae0('0x24')](function(){if(_0x2bc528[_0x2ae0('0x8f')]===_0x2ae0('0x90')){return null;}var _0x4543ae=_['merge'](_0x2bc528,{'name':_0x2bc528['fullPath']||_0x2bc528[_0x2ae0('0x28')]||_0x56985c[_0x2ae0('0x28')],'basename':_0x300bd9,'savename':util['format']('%s-%s.%s',_0x2bc528[_0x2ae0('0x28')]||_0x56985c[_0x2ae0('0x28')],require('randomstring')['generate'](0x4),_0x2bc528['output']||_0x2ae0('0x91')),'reportId':_0x56985c['id'],'reportType':_0x2ae0('0x92')});return db[_0x2ae0('0x93')][_0x2ae0('0x46')](_0x4543ae,{'raw':!![]});})[_0x2ae0('0x24')](function(_0x527a57){if(_0x56985c[_0x2ae0('0x7f')]===_0x2ae0('0x94')){_0x22d53e[_0x2ae0('0x3b')](_0x56985c[_0x2ae0('0x7f')]+_0x2ae0('0x95'),_0x2bc528[_0x2ae0('0x96')],_0x2bc528['endDate']);}else{_0x22d53e['where'](_0x56985c[_0x2ae0('0x7f')]+_0x2ae0('0x97'),_0x2bc528[_0x2ae0('0x96')],_0x2bc528[_0x2ae0('0x98')]);}if(_0x527a57){logger[_0x2ae0('0x99')](_0x2ae0('0x9a'),_0x22d53e[_0x2ae0('0x84')]());require('child_process')[_0x2ae0('0x9b')](path[_0x2ae0('0x87')](__dirname,_0x2ae0('0x9c'),_0x527a57[_0x2ae0('0x8f')]),[_0x527a57['id'],_0x22d53e['toString'](),path['join'](__dirname,_0x2ae0('0x9d'),_0x527a57[_0x2ae0('0x9e')]),_0x300bd9]);return _0x527a57;}else{var _0x15533d=squel[_0x2ae0('0x70')]();_0x15533d[_0x2ae0('0x8e')]('('+_0x22d53e[_0x2ae0('0x84')]()+')',_0x2ae0('0x9f'));_0x15533d['field'](_0x2ae0('0xa0'),_0x2ae0('0x1e'));_0x22d53e[_0x2ae0('0x1d')](_0x2bc528['limit']||_0x41496b);_0x22d53e[_0x2ae0('0x1b')](_0x2bc528[_0x2ae0('0x1b')]||0x0);return dbH['sequelize'][_0x2ae0('0x31')](_0x15533d[_0x2ae0('0x84')](),{'type':dbH['sequelize'][_0x2ae0('0xa1')][_0x2ae0('0x86')]})[_0x2ae0('0x24')](function(_0x4c1a53){if(!_0x4c1a53[_0x2ae0('0x36')]){_0x217966=0x0;}else{_0x217966=_0x4c1a53[0x0][_0x2ae0('0x1e')]||0x0;}return dbH[_0x2ae0('0x85')]['query'](_0x22d53e[_0x2ae0('0x84')](),{'type':dbH[_0x2ae0('0x85')][_0x2ae0('0xa1')][_0x2ae0('0x86')]});})[_0x2ae0('0x24')](function(_0x2189a4){return{'rows':_0x2189a4||[],'count':_0x217966};});}});}exports[_0x2ae0('0xa2')]=function(_0x5af2f4,_0x2a536d){return runReport(_0x5af2f4[_0x2ae0('0x53')],_0x5af2f4[_0x2ae0('0x31')],_0x5af2f4[_0x2ae0('0x40')])['then'](respondWithResult(_0x2a536d,null))[_0x2ae0('0x45')](handleError(_0x2a536d,null));};exports['runReport']=runReport;exports['query']=function(_0x401cb8,_0x289c7c){var _0xa45eb4=0xa;var _0x49b052=[_0x2ae0('0x87'),_0x2ae0('0x56'),'right_join','cross_join'];var _0x43f171={'SUM':_0x2ae0('0x58'),'COUNT':_0x2ae0('0x89'),'COUNT DISTINCT':_0x2ae0('0xa3'),'MAX':_0x2ae0('0x59'),'MIN':_0x2ae0('0x8a'),'AVG':_0x2ae0('0x5a'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x2ae0('0x5b'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x4a10d7={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':'DATE(%s)','HOUR':_0x2ae0('0x5f'),'ROUND':_0x2ae0('0x60'),'UNIX_TIMESTAMP':_0x2ae0('0x61')};var _0x3b255d=function(_0x30d434){return!_[_0x2ae0('0x62')](['IS\x20NULL',_0x2ae0('0x63'),_0x2ae0('0x64'),_0x2ae0('0x65')],_0x30d434);};var _0x7b7319=function(_0x5d1c51){if(!_0x5d1c51||!_0x5d1c51[_0x2ae0('0x66')]['length']){return'';}for(var _0x399d57='(',_0x291114=0x0;_0x291114<_0x5d1c51[_0x2ae0('0x66')]['length'];_0x291114+=0x1){_0x291114>0x0&&(_0x399d57+='\x20'+_0x5d1c51['operator']+'\x20');_0x399d57+=_0x5d1c51['rules'][_0x291114][_0x2ae0('0x68')]?_0x7b7319(_0x5d1c51[_0x2ae0('0x66')][_0x291114][_0x2ae0('0x68')]):_0x5d1c51['rules'][_0x291114][_0x2ae0('0x69')]+'\x20'+_0x5d1c51[_0x2ae0('0x66')][_0x291114][_0x2ae0('0x6a')]+(_0x3b255d(_0x5d1c51[_0x2ae0('0x66')][_0x291114][_0x2ae0('0x6a')])?'\x20'+_0x5d1c51['rules'][_0x291114]['value']:'');}return _0x399d57+')';};var _0x43660f={'where':{'id':_0x401cb8[_0x2ae0('0x53')]['id']}},_0x3c382e,_0x47f062,_0x2473a8,_0x1aa1d2,_0x2aff44;_0x43660f=_[_0x2ae0('0x3d')]({},_0x43660f,_0x401cb8[_0x2ae0('0x40')]);return db['AnalyticCustomReport'][_0x2ae0('0x52')](_0x43660f)[_0x2ae0('0x24')](function(_0x1364aa){if(_0x1364aa){_0x3c382e=_0x1364aa;return _0x1364aa[_0x2ae0('0x6c')]();}return null;})[_0x2ae0('0x24')](function(_0x2293ce){if(_0x2293ce){if(!_0x2293ce[_0x2ae0('0x36')]){throw new db[(_0x2ae0('0x6d'))][(_0x2ae0('0x8c'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x47f062=_0x2293ce;return db[_0x2ae0('0x6e')][_0x2ae0('0x43')]({'raw':!![]});}return null;})[_0x2ae0('0x24')](function(_0x34c902){if(_0x34c902){_0x2473a8=_[_0x2ae0('0x6f')](_0x34c902,'id');var _0x5523c5;var _0x139fd2=squel[_0x2ae0('0x70')]();_0x139fd2[_0x2ae0('0x8e')](_0x3c382e[_0x2ae0('0x7f')]);for(var _0x14cb3e=0x0;_0x14cb3e<_0x47f062['length'];_0x14cb3e+=0x1){_0x5523c5=_0x47f062[_0x14cb3e][_0x2ae0('0x71')]?_0x2473a8[_0x47f062[_0x14cb3e][_0x2ae0('0x71')]][_0x2ae0('0x72')]:_0x47f062[_0x14cb3e][_0x2ae0('0x69')];_0x5523c5=_0x47f062[_0x14cb3e][_0x2ae0('0x73')]?_[_0x2ae0('0x74')](_0x43f171[_0x47f062[_0x14cb3e]['function']],'%s',_0x5523c5):_0x5523c5;_0x5523c5=_0x47f062[_0x14cb3e][_0x2ae0('0x75')]?_['replace'](_0x4a10d7[_0x47f062[_0x14cb3e]['format']],'%s',_0x5523c5):_0x5523c5;if(_0x47f062[_0x14cb3e][_0x2ae0('0x76')]){_0x139fd2[_0x2ae0('0x68')](_0x5523c5);}_0x47f062[_0x14cb3e][_0x2ae0('0x77')]&&_0x139fd2['order'](_0x5523c5,_0x47f062[_0x14cb3e][_0x2ae0('0x77')]==='DESC'?![]:!![]);_0x139fd2[_0x2ae0('0x69')](_0x5523c5,_0x47f062[_0x14cb3e][_0x2ae0('0x79')]||_0x5523c5);}if(_0x3c382e['joins']){_0x3c382e['joins']=JSON[_0x2ae0('0x7b')](_0x3c382e['joins']);for(var _0x13835f=0x0;_0x13835f<_0x3c382e[_0x2ae0('0x7a')]['length'];_0x13835f+=0x1){if(_0x3c382e[_0x2ae0('0x7a')][_0x13835f][_0x2ae0('0x2f')]&&_[_0x2ae0('0x62')](_0x49b052,_0x3c382e['joins'][_0x13835f]['type'])&&_0x3c382e['joins'][_0x13835f][_0x2ae0('0x7c')]&&_0x3c382e['joins'][_0x13835f][_0x2ae0('0x7d')]&&_0x3c382e[_0x2ae0('0x7a')][_0x13835f][_0x2ae0('0x80')]){_0x139fd2[_0x3c382e[_0x2ae0('0x7a')][_0x13835f][_0x2ae0('0x2f')]](_0x3c382e[_0x2ae0('0x7a')][_0x13835f][_0x2ae0('0x7d')],null,util[_0x2ae0('0x75')](_0x2ae0('0x7e'),_0x3c382e[_0x2ae0('0x7f')],_0x3c382e[_0x2ae0('0x7a')][_0x13835f][_0x2ae0('0x7c')],_0x3c382e[_0x2ae0('0x7a')][_0x13835f]['foreignTable'],_0x3c382e['joins'][_0x13835f][_0x2ae0('0x80')]));}}}if(_0x3c382e['conditions']){_0x3c382e['conditions']=JSON[_0x2ae0('0x7b')](_0x3c382e[_0x2ae0('0x81')]);_0x139fd2[_0x2ae0('0x3b')](_0x7b7319(_0x3c382e[_0x2ae0('0x81')]['group']));}_0x2aff44=_0x139fd2[_0x2ae0('0xa4')]();_0x139fd2[_0x2ae0('0x1d')](_0xa45eb4);_0x139fd2[_0x2ae0('0x1b')](0x0);logger[_0x2ae0('0x82')](_0x2ae0('0x83'),_0x139fd2[_0x2ae0('0x84')]());return dbH[_0x2ae0('0x85')]['query'](_0x139fd2[_0x2ae0('0x84')](),{'type':dbH[_0x2ae0('0x85')][_0x2ae0('0xa1')][_0x2ae0('0x86')]});}})[_0x2ae0('0x24')](function(){return{'sql':_0x2aff44[_0x2ae0('0x84')]()};})['then'](respondWithResult(_0x289c7c,null))['catch'](handleError(_0x289c7c,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff