// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xfb3d=['send','index','AnalyticDefaultReport','rawAttributes','model','keys','query','filters','intersection','attributes','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','map','key','VIRTUAL','field','options','include','findAll','rows','show','params','fields','includeAll','find','catch','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','Reports','UserProfileSection','userProfileId','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','preview','join','left_join','right_join','SUM(%s)','COUNT(%s)','MAX(%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)','ROUND(%s)','UNIX_TIMESTAMP(%s)','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','condition','getFields','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','select','from','table','MetricId','function','format','orderBy','DESC','alias','joins','parse','type','includes','parentKey','foreignTable','%s.%s\x20=\x20%s.%s','foreignKey','conditions','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','COUNT(DISTINCT\x20%s)','MIN(%s)','IS\x20NULL','value','keyBy','metric','groupBy','Sequelize','output','web','fullPath','%s-%s.%s','randomstring','generate','csv','default','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','Run\x20Query:','../../components/export/','../../files/reports','savename','COUNT(*)','runReport','cross_join','HOUR(%s)','replace','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','to-csv','lodash','squel','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','api','../../config/utils','../../mysqldb','sendStatus','end','status','json','count','offset','limit','set','apply','reject','save','update','then','destroy','get','DefaultReports','error','stack','name'];(function(_0x3ee369,_0x311aff){var _0xd65c5e=function(_0x39dfde){while(--_0x39dfde){_0x3ee369['push'](_0x3ee369['shift']());}};_0xd65c5e(++_0x311aff);}(_0xfb3d,0x7c));var _0xdfb3=function(_0x4dcc75,_0x1a8621){_0x4dcc75=_0x4dcc75-0x0;var _0x3384db=_0xfb3d[_0x4dcc75];return _0x3384db;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0xdfb3('0x0'));var rimraf=require(_0xdfb3('0x1'));var zipdir=require(_0xdfb3('0x2'));var jsonpatch=require(_0xdfb3('0x3'));var rp=require(_0xdfb3('0x4'));var moment=require(_0xdfb3('0x5'));var BPromise=require(_0xdfb3('0x6'));var Mustache=require(_0xdfb3('0x7'));var util=require(_0xdfb3('0x8'));var path=require(_0xdfb3('0x9'));var sox=require('sox');var csv=require(_0xdfb3('0xa'));var ejs=require('ejs');var fs=require('fs');var _=require(_0xdfb3('0xb'));var squel=require(_0xdfb3('0xc'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0xdfb3('0xd'));var toCsv=require(_0xdfb3('0xa'));var querystring=require(_0xdfb3('0xe'));var Papa=require(_0xdfb3('0xf'));var Redis=require('ioredis');var authService=require(_0xdfb3('0x10'));var qs=require(_0xdfb3('0x11'));var hardwareService=require(_0xdfb3('0x12'));var logger=require('../../config/logger')(_0xdfb3('0x13'));var utils=require(_0xdfb3('0x14'));var config=require('../../config/environment');var db=require(_0xdfb3('0x15'))['db'];function respondWithStatusCode(_0x31e1cd,_0xafec){_0xafec=_0xafec||0xcc;return function(_0x306aba){if(_0x306aba){return _0x31e1cd[_0xdfb3('0x16')](_0xafec);}return _0x31e1cd['status'](_0xafec)[_0xdfb3('0x17')]();};}function respondWithResult(_0x3406de,_0x3657ea){_0x3657ea=_0x3657ea||0xc8;return function(_0x4da609){if(_0x4da609){return _0x3406de[_0xdfb3('0x18')](_0x3657ea)[_0xdfb3('0x19')](_0x4da609);}};}function respondWithFilteredResult(_0x522af0,_0x2e793a){return function(_0xd48def){if(_0xd48def){var _0x18f131=_0xd48def[_0xdfb3('0x1a')],_0x4f029d=_0x2e793a['offset'],_0x235f50=_0x2e793a[_0xdfb3('0x1b')]+_0x2e793a[_0xdfb3('0x1c')],_0x292deb;if(_0x235f50>=_0x18f131){_0x235f50=_0x18f131;_0x292deb=0xc8;}else{_0x292deb=0xce;}_0x522af0[_0xdfb3('0x18')](_0x292deb);return _0x522af0[_0xdfb3('0x1d')]('Content-Range',_0x4f029d+'-'+_0x235f50+'/'+_0x18f131)[_0xdfb3('0x19')](_0xd48def);}return null;};}function patchUpdates(_0x19f61a){return function(_0x594985){try{jsonpatch[_0xdfb3('0x1e')](_0x594985,_0x19f61a,!![]);}catch(_0x58170f){return BPromise[_0xdfb3('0x1f')](_0x58170f);}return _0x594985[_0xdfb3('0x20')]();};}function saveUpdates(_0x3877c6,_0x117b51){return function(_0x32d4b3){if(_0x32d4b3){return _0x32d4b3[_0xdfb3('0x21')](_0x3877c6)[_0xdfb3('0x22')](function(_0x4f6f1e){return _0x4f6f1e;});}return null;};}function removeEntity(_0x489428,_0x582a87){return function(_0x4632c7){if(_0x4632c7){return _0x4632c7[_0xdfb3('0x23')]()[_0xdfb3('0x22')](function(){var _0x274260=_0x4632c7[_0xdfb3('0x24')]({'plain':!![]});var _0x308a53=_0xdfb3('0x25');return db['UserProfileResource'][_0xdfb3('0x23')]({'where':{'type':_0x308a53,'resourceId':_0x274260['id']}})['then'](function(){return _0x4632c7;});})[_0xdfb3('0x22')](function(){_0x489428[_0xdfb3('0x18')](0xcc)[_0xdfb3('0x17')]();});}};}function handleEntityNotFound(_0xbd184f,_0x11fc56){return function(_0x341ea0){if(!_0x341ea0){_0xbd184f[_0xdfb3('0x16')](0x194);}return _0x341ea0;};}function handleError(_0xebf40,_0x66e7cc){_0x66e7cc=_0x66e7cc||0x1f4;return function(_0x1ccc79){logger[_0xdfb3('0x26')](_0x1ccc79[_0xdfb3('0x27')]);if(_0x1ccc79[_0xdfb3('0x28')]){delete _0x1ccc79['name'];}_0xebf40[_0xdfb3('0x18')](_0x66e7cc)[_0xdfb3('0x29')](_0x1ccc79);};}exports[_0xdfb3('0x2a')]=function(_0x2e6eb8,_0xa82486){var _0x5acede={},_0x2ff8f7={},_0x98449={'count':0x0,'rows':[]};var _0x2c406c=db[_0xdfb3('0x2b')][_0xdfb3('0x2c')];_0x2ff8f7[_0xdfb3('0x2d')]=_[_0xdfb3('0x2e')](_0x2c406c);_0x2ff8f7[_0xdfb3('0x2f')]=_[_0xdfb3('0x2e')](_0x2e6eb8[_0xdfb3('0x2f')]);_0x2ff8f7[_0xdfb3('0x30')]=_[_0xdfb3('0x31')](_0x2ff8f7['model'],_0x2ff8f7[_0xdfb3('0x2f')]);_0x5acede['attributes']=_[_0xdfb3('0x31')](_0x2ff8f7['model'],qs['fields'](_0x2e6eb8['query']['fields']));_0x5acede[_0xdfb3('0x32')]=_0x5acede[_0xdfb3('0x32')][_0xdfb3('0x33')]?_0x5acede['attributes']:_0x2ff8f7['model'];if(!_0x2e6eb8[_0xdfb3('0x2f')][_0xdfb3('0x34')](_0xdfb3('0x35'))){_0x5acede['limit']=qs[_0xdfb3('0x1c')](_0x2e6eb8[_0xdfb3('0x2f')]['limit']);_0x5acede['offset']=qs[_0xdfb3('0x1b')](_0x2e6eb8[_0xdfb3('0x2f')][_0xdfb3('0x1b')]);}_0x5acede[_0xdfb3('0x36')]=qs['sort'](_0x2e6eb8[_0xdfb3('0x2f')][_0xdfb3('0x37')]);_0x5acede[_0xdfb3('0x38')]=qs[_0xdfb3('0x30')](_[_0xdfb3('0x39')](_0x2e6eb8['query'],_0x2ff8f7[_0xdfb3('0x30')]));if(_0x2e6eb8[_0xdfb3('0x2f')][_0xdfb3('0x3a')]){_0x5acede[_0xdfb3('0x38')]=_[_0xdfb3('0x3b')](_0x5acede[_0xdfb3('0x38')],{'$or':_[_0xdfb3('0x3c')](_0x2c406c,function(_0xd1e98f){if(_0xd1e98f['type'][_0xdfb3('0x3d')]!==_0xdfb3('0x3e')){var _0xd7a530={};_0xd7a530[_0xd1e98f[_0xdfb3('0x3f')]]={'$like':'%'+_0x2e6eb8['query'][_0xdfb3('0x3a')]+'%'};return _0xd7a530;}})});}_0x5acede=_['merge']({},_0x5acede,_0x2e6eb8[_0xdfb3('0x40')]);var _0x308001={'where':_0x5acede['where']};return db[_0xdfb3('0x2b')][_0xdfb3('0x1a')](_0x308001)[_0xdfb3('0x22')](function(_0x2e6135){_0x98449[_0xdfb3('0x1a')]=_0x2e6135;if(_0x2e6eb8[_0xdfb3('0x2f')]['includeAll']){_0x5acede[_0xdfb3('0x41')]=[{'all':!![]}];}return db[_0xdfb3('0x2b')][_0xdfb3('0x42')](_0x5acede);})[_0xdfb3('0x22')](function(_0x49e26a){_0x98449[_0xdfb3('0x43')]=_0x49e26a;return _0x98449;})[_0xdfb3('0x22')](respondWithFilteredResult(_0xa82486,_0x5acede))['catch'](handleError(_0xa82486,null));};exports[_0xdfb3('0x44')]=function(_0x455cd1,_0x448a1a){var _0x3d20f0={'raw':!![],'where':{'id':_0x455cd1[_0xdfb3('0x45')]['id']}},_0x387d3f={};_0x387d3f[_0xdfb3('0x2d')]=_['keys'](db[_0xdfb3('0x2b')][_0xdfb3('0x2c')]);_0x387d3f[_0xdfb3('0x2f')]=_[_0xdfb3('0x2e')](_0x455cd1[_0xdfb3('0x2f')]);_0x387d3f[_0xdfb3('0x30')]=_[_0xdfb3('0x31')](_0x387d3f[_0xdfb3('0x2d')],_0x387d3f['query']);_0x3d20f0[_0xdfb3('0x32')]=_[_0xdfb3('0x31')](_0x387d3f['model'],qs[_0xdfb3('0x46')](_0x455cd1['query'][_0xdfb3('0x46')]));_0x3d20f0['attributes']=_0x3d20f0[_0xdfb3('0x32')][_0xdfb3('0x33')]?_0x3d20f0[_0xdfb3('0x32')]:_0x387d3f['model'];if(_0x455cd1[_0xdfb3('0x2f')][_0xdfb3('0x47')]){_0x3d20f0[_0xdfb3('0x41')]=[{'all':!![]}];}_0x3d20f0=_[_0xdfb3('0x3b')]({},_0x3d20f0,_0x455cd1[_0xdfb3('0x40')]);return db[_0xdfb3('0x2b')][_0xdfb3('0x48')](_0x3d20f0)[_0xdfb3('0x22')](handleEntityNotFound(_0x448a1a,null))[_0xdfb3('0x22')](respondWithResult(_0x448a1a,null))[_0xdfb3('0x49')](handleError(_0x448a1a,null));};exports[_0xdfb3('0x4a')]=function(_0x2160a9,_0x199a7b){return db['AnalyticDefaultReport'][_0xdfb3('0x4a')](_0x2160a9[_0xdfb3('0x4b')],{})[_0xdfb3('0x22')](function(_0x1ade9e){var _0x1a331e=_0x2160a9[_0xdfb3('0x4c')]['get']({'plain':!![]});if(!_0x1a331e)throw new Error(_0xdfb3('0x4d'));if(_0x1a331e['role']===_0xdfb3('0x4c')){var _0x4dbc79=_0x1ade9e[_0xdfb3('0x24')]({'plain':!![]});var _0x168bdd=_0xdfb3('0x4e');return db[_0xdfb3('0x4f')]['find']({'where':{'name':_0x168bdd,'userProfileId':_0x1a331e[_0xdfb3('0x50')]},'raw':!![]})['then'](function(_0x1e0aa9){if(_0x1e0aa9&&_0x1e0aa9[_0xdfb3('0x51')]===0x0){return db[_0xdfb3('0x52')][_0xdfb3('0x4a')]({'name':_0x4dbc79[_0xdfb3('0x28')],'resourceId':_0x4dbc79['id'],'type':_0xdfb3('0x25'),'sectionId':_0x1e0aa9['id']},{})['then'](function(){return _0x1ade9e;});}else{return _0x1ade9e;}})[_0xdfb3('0x49')](function(_0x38d528){logger[_0xdfb3('0x26')](_0xdfb3('0x53'),_0x38d528);throw _0x38d528;});}return _0x1ade9e;})[_0xdfb3('0x22')](respondWithResult(_0x199a7b,0xc9))['catch'](handleError(_0x199a7b,null));};exports[_0xdfb3('0x21')]=function(_0x26723c,_0x5dc863){if(_0x26723c['body']['id']){delete _0x26723c[_0xdfb3('0x4b')]['id'];}return db[_0xdfb3('0x2b')][_0xdfb3('0x48')]({'where':{'id':_0x26723c['params']['id']}})['then'](handleEntityNotFound(_0x5dc863,null))[_0xdfb3('0x22')](saveUpdates(_0x26723c[_0xdfb3('0x4b')],null))[_0xdfb3('0x22')](respondWithResult(_0x5dc863,null))[_0xdfb3('0x49')](handleError(_0x5dc863,null));};exports[_0xdfb3('0x23')]=function(_0x3f37f8,_0xca3f3a){return db['AnalyticDefaultReport'][_0xdfb3('0x48')]({'where':{'id':_0x3f37f8['params']['id']}})[_0xdfb3('0x22')](handleEntityNotFound(_0xca3f3a,null))[_0xdfb3('0x22')](removeEntity(_0xca3f3a,null))[_0xdfb3('0x49')](handleError(_0xca3f3a,null));};exports[_0xdfb3('0x54')]=function(_0x36028c,_0xb39976){var _0x1d0a95=0xa;var _0x5bd7d2=[_0xdfb3('0x55'),_0xdfb3('0x56'),_0xdfb3('0x57'),'cross_join'];var _0x327538={'SUM':_0xdfb3('0x58'),'COUNT':_0xdfb3('0x59'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0xdfb3('0x5a'),'MIN':'MIN(%s)','AVG':_0xdfb3('0x5b'),'GROUP_CONCAT':_0xdfb3('0x5c'),'GROUP_CONCAT ASC':_0xdfb3('0x5d'),'GROUP_CONCAT DESC':_0xdfb3('0x5e')};var _0x36d83a={'SEC_TO_TIME':_0xdfb3('0x5f'),'DATE':_0xdfb3('0x60'),'HOUR':'HOUR(%s)','ROUND':_0xdfb3('0x61'),'UNIX_TIMESTAMP':_0xdfb3('0x62')};var _0x3960c7=function(_0x49eaf1){return!_['includes'](['IS\x20NULL',_0xdfb3('0x63'),_0xdfb3('0x64'),_0xdfb3('0x65')],_0x49eaf1);};var _0x2d5ff3=function(_0x2a02af){if(!_0x2a02af||!_0x2a02af[_0xdfb3('0x66')][_0xdfb3('0x33')]){return'';}for(var _0x2dbd1f='(',_0xab76c0=0x0;_0xab76c0<_0x2a02af['rules'][_0xdfb3('0x33')];_0xab76c0+=0x1){_0xab76c0>0x0&&(_0x2dbd1f+='\x20'+_0x2a02af[_0xdfb3('0x67')]+'\x20');_0x2dbd1f+=_0x2a02af[_0xdfb3('0x66')][_0xab76c0][_0xdfb3('0x68')]?_0x2d5ff3(_0x2a02af[_0xdfb3('0x66')][_0xab76c0][_0xdfb3('0x68')]):_0x2a02af[_0xdfb3('0x66')][_0xab76c0]['field']+'\x20'+_0x2a02af[_0xdfb3('0x66')][_0xab76c0]['condition']+(_0x3960c7(_0x2a02af[_0xdfb3('0x66')][_0xab76c0][_0xdfb3('0x69')])?'\x20'+_0x2a02af[_0xdfb3('0x66')][_0xab76c0]['value']:'');}return _0x2dbd1f+')';};var _0x93ef41={'where':{'id':_0x36028c[_0xdfb3('0x45')]['id']}},_0xcae918,_0x24e474,_0xe4a4dc,_0x48ca24,_0x20e3a6;_0x93ef41=_[_0xdfb3('0x3b')]({},_0x93ef41,_0x36028c['options']);return db['AnalyticDefaultReport'][_0xdfb3('0x48')](_0x93ef41)[_0xdfb3('0x22')](function(_0x59e6e1){if(_0x59e6e1){_0xcae918=_0x59e6e1;return _0x59e6e1[_0xdfb3('0x6a')]();}return null;})['then'](function(_0x101ba3){if(_0x101ba3){if(!_0x101ba3['length']){throw new db['Sequelize'][(_0xdfb3('0x6b'))](_0xdfb3('0x6c'),0x193);}_0x24e474=_0x101ba3;return db[_0xdfb3('0x6d')][_0xdfb3('0x42')]({'raw':!![]});}return null;})[_0xdfb3('0x22')](function(_0x447294){if(_0x447294){_0xe4a4dc=_['keyBy'](_0x447294,'id');var _0x2f72ab;var _0x1519dc=squel[_0xdfb3('0x6e')]();_0x1519dc[_0xdfb3('0x6f')](_0xcae918[_0xdfb3('0x70')]);for(var _0x1e90e7=0x0;_0x1e90e7<_0x24e474[_0xdfb3('0x33')];_0x1e90e7+=0x1){_0x2f72ab=_0x24e474[_0x1e90e7][_0xdfb3('0x71')]?_0xe4a4dc[_0x24e474[_0x1e90e7][_0xdfb3('0x71')]]['metric']:_0x24e474[_0x1e90e7][_0xdfb3('0x3f')];_0x2f72ab=_0x24e474[_0x1e90e7][_0xdfb3('0x72')]?_['replace'](_0x327538[_0x24e474[_0x1e90e7][_0xdfb3('0x72')]],'%s',_0x2f72ab):_0x2f72ab;_0x2f72ab=_0x24e474[_0x1e90e7][_0xdfb3('0x73')]?_['replace'](_0x36d83a[_0x24e474[_0x1e90e7][_0xdfb3('0x73')]],'%s',_0x2f72ab):_0x2f72ab;if(_0x24e474[_0x1e90e7]['groupBy']){_0x1519dc[_0xdfb3('0x68')](_0x2f72ab);}_0x24e474[_0x1e90e7][_0xdfb3('0x74')]&&_0x1519dc[_0xdfb3('0x36')](_0x2f72ab,_0x24e474[_0x1e90e7][_0xdfb3('0x74')]===_0xdfb3('0x75')?![]:!![]);_0x1519dc[_0xdfb3('0x3f')](_0x2f72ab,_0x24e474[_0x1e90e7][_0xdfb3('0x76')]||_0x2f72ab);}if(_0xcae918['joins']){_0xcae918[_0xdfb3('0x77')]=JSON[_0xdfb3('0x78')](_0xcae918[_0xdfb3('0x77')]);for(var _0x4e62ab=0x0;_0x4e62ab<_0xcae918[_0xdfb3('0x77')]['length'];_0x4e62ab+=0x1){if(_0xcae918['joins'][_0x4e62ab][_0xdfb3('0x79')]&&_[_0xdfb3('0x7a')](_0x5bd7d2,_0xcae918[_0xdfb3('0x77')][_0x4e62ab][_0xdfb3('0x79')])&&_0xcae918[_0xdfb3('0x77')][_0x4e62ab][_0xdfb3('0x7b')]&&_0xcae918['joins'][_0x4e62ab][_0xdfb3('0x7c')]&&_0xcae918['joins'][_0x4e62ab]['foreignKey']){_0x1519dc[_0xcae918['joins'][_0x4e62ab][_0xdfb3('0x79')]](_0xcae918[_0xdfb3('0x77')][_0x4e62ab]['foreignTable'],null,util[_0xdfb3('0x73')](_0xdfb3('0x7d'),_0xcae918[_0xdfb3('0x70')],_0xcae918[_0xdfb3('0x77')][_0x4e62ab][_0xdfb3('0x7b')],_0xcae918[_0xdfb3('0x77')][_0x4e62ab]['foreignTable'],_0xcae918[_0xdfb3('0x77')][_0x4e62ab][_0xdfb3('0x7e')]));}}}if(_0xcae918['conditions']){_0xcae918[_0xdfb3('0x7f')]=JSON[_0xdfb3('0x78')](_0xcae918[_0xdfb3('0x7f')]);_0x1519dc[_0xdfb3('0x38')](_0x2d5ff3(_0xcae918[_0xdfb3('0x7f')][_0xdfb3('0x68')]));}_0x20e3a6=_0x1519dc['clone']();_0x1519dc['limit'](_0x1d0a95);_0x1519dc[_0xdfb3('0x1b')](0x0);logger[_0xdfb3('0x80')](_0xdfb3('0x81'),_0x1519dc[_0xdfb3('0x82')]());return db['sequelize'][_0xdfb3('0x2f')](_0x1519dc[_0xdfb3('0x82')](),{'type':db[_0xdfb3('0x83')][_0xdfb3('0x84')][_0xdfb3('0x85')]});}})['then'](respondWithResult(_0xb39976,null))[_0xdfb3('0x49')](handleError(_0xb39976,null));};function runReport(_0x33bf54,_0x1c0ee1,_0x4b05c3){var _0x1fc9cc=_0x1c0ee1['name'];var _0x84a83d=0xa;var _0x1e8c67=[_0xdfb3('0x55'),_0xdfb3('0x56'),_0xdfb3('0x57'),'cross_join'];var _0x266583={'SUM':_0xdfb3('0x58'),'COUNT':_0xdfb3('0x59'),'COUNT DISTINCT':_0xdfb3('0x86'),'MAX':_0xdfb3('0x5a'),'MIN':_0xdfb3('0x87'),'AVG':_0xdfb3('0x5b'),'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 _0x1f42e2={'SEC_TO_TIME':_0xdfb3('0x5f'),'DATE':_0xdfb3('0x60'),'HOUR':'HOUR(%s)','ROUND':_0xdfb3('0x61'),'UNIX_TIMESTAMP':_0xdfb3('0x62')};var _0x148d24=function(_0x433579){return!_[_0xdfb3('0x7a')]([_0xdfb3('0x88'),_0xdfb3('0x63'),_0xdfb3('0x64'),'IS\x20NOT\x20EMPTY'],_0x433579);};var _0xc21251=function(_0x168833){if(!_0x168833||!_0x168833[_0xdfb3('0x66')][_0xdfb3('0x33')]){return'';}for(var _0x41fda3='(',_0x8ebc4a=0x0;_0x8ebc4a<_0x168833[_0xdfb3('0x66')][_0xdfb3('0x33')];_0x8ebc4a+=0x1){_0x8ebc4a>0x0&&(_0x41fda3+='\x20'+_0x168833[_0xdfb3('0x67')]+'\x20');_0x41fda3+=_0x168833[_0xdfb3('0x66')][_0x8ebc4a]['group']?_0xc21251(_0x168833[_0xdfb3('0x66')][_0x8ebc4a]['group']):_0x168833[_0xdfb3('0x66')][_0x8ebc4a][_0xdfb3('0x3f')]+'\x20'+_0x168833[_0xdfb3('0x66')][_0x8ebc4a][_0xdfb3('0x69')]+(_0x148d24(_0x168833['rules'][_0x8ebc4a][_0xdfb3('0x69')])?'\x20'+_0x168833[_0xdfb3('0x66')][_0x8ebc4a][_0xdfb3('0x89')]:'');}return _0x41fda3+')';};var _0x17aaba={'where':{'id':_0x33bf54['id']}},_0x1c9525,_0x4fb6e6,_0x4d988d,_0x30e976,_0x441279;_0x17aaba=_[_0xdfb3('0x3b')]({},_0x17aaba,_0x4b05c3);return db[_0xdfb3('0x2b')][_0xdfb3('0x48')](_0x17aaba)[_0xdfb3('0x22')](function(_0x13b2bc){if(_0x13b2bc){_0x1c9525=_0x13b2bc;return _0x13b2bc['getFields']();}return null;})[_0xdfb3('0x22')](function(_0x35cc75){if(_0x35cc75){if(!_0x35cc75[_0xdfb3('0x33')]){throw new db['Sequelize']['ValidationErrorItem'](_0xdfb3('0x6c'),0x193);}_0x4fb6e6=_0x35cc75;return db[_0xdfb3('0x6d')][_0xdfb3('0x42')]({'raw':!![]});}return null;})[_0xdfb3('0x22')](function(_0x122d0c){if(_0x122d0c){_0x4d988d=_[_0xdfb3('0x8a')](_0x122d0c,'id');var _0x5b8cb0;var _0x42c188=squel['select']();_0x42c188['from'](_0x1c9525[_0xdfb3('0x70')]);for(var _0x41336d=0x0;_0x41336d<_0x4fb6e6[_0xdfb3('0x33')];_0x41336d+=0x1){_0x5b8cb0=_0x4fb6e6[_0x41336d][_0xdfb3('0x71')]?_0x4d988d[_0x4fb6e6[_0x41336d][_0xdfb3('0x71')]][_0xdfb3('0x8b')]:_0x4fb6e6[_0x41336d][_0xdfb3('0x3f')];_0x5b8cb0=_0x4fb6e6[_0x41336d]['function']?_['replace'](_0x266583[_0x4fb6e6[_0x41336d]['function']],'%s',_0x5b8cb0):_0x5b8cb0;_0x5b8cb0=_0x4fb6e6[_0x41336d][_0xdfb3('0x73')]?_['replace'](_0x1f42e2[_0x4fb6e6[_0x41336d]['format']],'%s',_0x5b8cb0):_0x5b8cb0;if(_0x4fb6e6[_0x41336d][_0xdfb3('0x8c')]){_0x42c188[_0xdfb3('0x68')](_0x5b8cb0);}_0x4fb6e6[_0x41336d][_0xdfb3('0x74')]&&_0x42c188[_0xdfb3('0x36')](_0x5b8cb0,_0x4fb6e6[_0x41336d][_0xdfb3('0x74')]===_0xdfb3('0x75')?![]:!![]);_0x42c188[_0xdfb3('0x3f')](_0x5b8cb0,_0x4fb6e6[_0x41336d][_0xdfb3('0x76')]||_0x5b8cb0);}if(_0x1c9525['joins']){_0x1c9525[_0xdfb3('0x77')]=JSON[_0xdfb3('0x78')](_0x1c9525['joins']);for(var _0x204668=0x0;_0x204668<_0x1c9525[_0xdfb3('0x77')]['length'];_0x204668+=0x1){if(_0x1c9525[_0xdfb3('0x77')][_0x204668][_0xdfb3('0x79')]&&_['includes'](_0x1e8c67,_0x1c9525[_0xdfb3('0x77')][_0x204668]['type'])&&_0x1c9525[_0xdfb3('0x77')][_0x204668]['parentKey']&&_0x1c9525[_0xdfb3('0x77')][_0x204668][_0xdfb3('0x7c')]&&_0x1c9525['joins'][_0x204668][_0xdfb3('0x7e')]){_0x42c188[_0x1c9525[_0xdfb3('0x77')][_0x204668]['type']](_0x1c9525['joins'][_0x204668][_0xdfb3('0x7c')],null,util['format'](_0xdfb3('0x7d'),_0x1c9525[_0xdfb3('0x70')],_0x1c9525[_0xdfb3('0x77')][_0x204668][_0xdfb3('0x7b')],_0x1c9525[_0xdfb3('0x77')][_0x204668][_0xdfb3('0x7c')],_0x1c9525[_0xdfb3('0x77')][_0x204668]['foreignKey']));}}}if(_0x1c9525['conditions']){_0x1c9525[_0xdfb3('0x7f')]=JSON[_0xdfb3('0x78')](_0x1c9525[_0xdfb3('0x7f')]);_0x42c188[_0xdfb3('0x38')](_0xc21251(_0x1c9525['conditions'][_0xdfb3('0x68')]));}_0x441279=_0x42c188['clone']();_0x42c188['limit'](_0x84a83d);_0x42c188[_0xdfb3('0x1b')](0x0);logger[_0xdfb3('0x80')](_0xdfb3('0x81'),_0x42c188['toString']());return db[_0xdfb3('0x83')][_0xdfb3('0x2f')](_0x42c188['toString'](),{'type':db[_0xdfb3('0x83')]['QueryTypes'][_0xdfb3('0x85')]});}})[_0xdfb3('0x22')](function(_0x2c79ea){if(!_0x2c79ea[_0xdfb3('0x33')]){throw new db[(_0xdfb3('0x8d'))]['ValidationErrorItem']('No\x20available\x20data',0xcc);}if(_0x1c0ee1[_0xdfb3('0x8e')]===_0xdfb3('0x8f')){return null;}var _0x48d3a4=_['merge'](_0x1c0ee1,{'name':_0x1c0ee1[_0xdfb3('0x90')]||_0x1c0ee1['name']||_0x1c9525[_0xdfb3('0x28')],'basename':_0x1fc9cc,'savename':util[_0xdfb3('0x73')](_0xdfb3('0x91'),_0x1c0ee1[_0xdfb3('0x28')]||_0x1c9525[_0xdfb3('0x28')],require(_0xdfb3('0x92'))[_0xdfb3('0x93')](0x4),_0x1c0ee1['output']||_0xdfb3('0x94')),'reportId':_0x1c9525['id'],'reportType':_0xdfb3('0x95')});return db['AnalyticExtractedReport'][_0xdfb3('0x4a')](_0x48d3a4,{'raw':!![]});})['then'](function(_0x24130d){if(_0x1c9525[_0xdfb3('0x70')]===_0xdfb3('0x96')){_0x441279[_0xdfb3('0x38')](_0x1c9525['table']+_0xdfb3('0x97'),_0x1c0ee1[_0xdfb3('0x98')],_0x1c0ee1[_0xdfb3('0x99')]);}else{_0x441279[_0xdfb3('0x38')](_0x1c9525['table']+_0xdfb3('0x9a'),_0x1c0ee1[_0xdfb3('0x98')],_0x1c0ee1[_0xdfb3('0x99')]);}if(_0x24130d){logger[_0xdfb3('0x9b')](_0xdfb3('0x9c'),_0x441279[_0xdfb3('0x82')]());require('child_process')['fork'](path['join'](__dirname,_0xdfb3('0x9d'),_0x24130d[_0xdfb3('0x8e')]),[_0x24130d['id'],_0x441279[_0xdfb3('0x82')](),path[_0xdfb3('0x55')](__dirname,_0xdfb3('0x9e'),_0x24130d[_0xdfb3('0x9f')]),_0x1fc9cc]);return _0x24130d;}else{var _0x597f63=squel['select']();_0x597f63[_0xdfb3('0x6f')]('('+_0x441279['toString']()+')','countTable');_0x597f63[_0xdfb3('0x3f')](_0xdfb3('0xa0'),_0xdfb3('0x1a'));_0x441279[_0xdfb3('0x1c')](_0x1c0ee1[_0xdfb3('0x1c')]||_0x84a83d);_0x441279[_0xdfb3('0x1b')](_0x1c0ee1[_0xdfb3('0x1b')]||0x0);return db['sequelize'][_0xdfb3('0x2f')](_0x597f63[_0xdfb3('0x82')](),{'type':db[_0xdfb3('0x83')][_0xdfb3('0x84')][_0xdfb3('0x85')]})[_0xdfb3('0x22')](function(_0x2f634e){if(!_0x2f634e[_0xdfb3('0x33')]){_0x30e976=0x0;}else{_0x30e976=_0x2f634e[0x0][_0xdfb3('0x1a')]||0x0;}return db['sequelize'][_0xdfb3('0x2f')](_0x441279[_0xdfb3('0x82')](),{'type':db[_0xdfb3('0x83')][_0xdfb3('0x84')]['SELECT']});})[_0xdfb3('0x22')](function(_0x74614d){return{'rows':_0x74614d||[],'count':_0x30e976};});}});}exports['run']=function(_0xe08c29,_0x5241be){return runReport(_0xe08c29['params'],_0xe08c29['query'],_0xe08c29[_0xdfb3('0x40')])[_0xdfb3('0x22')](respondWithResult(_0x5241be,null))[_0xdfb3('0x49')](handleError(_0x5241be,null));};exports[_0xdfb3('0xa1')]=runReport;exports[_0xdfb3('0x2f')]=function(_0x3f18d3,_0x1515e7){var _0x534488=0xa;var _0x1e14fa=[_0xdfb3('0x55'),'left_join','right_join',_0xdfb3('0xa2')];var _0x3cffa1={'SUM':'SUM(%s)','COUNT':_0xdfb3('0x59'),'COUNT DISTINCT':_0xdfb3('0x86'),'MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':_0xdfb3('0x5b'),'GROUP_CONCAT':_0xdfb3('0x5c'),'GROUP_CONCAT ASC':_0xdfb3('0x5d'),'GROUP_CONCAT DESC':_0xdfb3('0x5e')};var _0x468cff={'SEC_TO_TIME':_0xdfb3('0x5f'),'DATE':'DATE(%s)','HOUR':_0xdfb3('0xa3'),'ROUND':_0xdfb3('0x61'),'UNIX_TIMESTAMP':_0xdfb3('0x62')};var _0x23af61=function(_0x41ccf5){return!_[_0xdfb3('0x7a')](['IS\x20NULL','IS\x20NOT\x20NULL',_0xdfb3('0x64'),_0xdfb3('0x65')],_0x41ccf5);};var _0x1bae90=function(_0x46a544){if(!_0x46a544||!_0x46a544[_0xdfb3('0x66')][_0xdfb3('0x33')]){return'';}for(var _0x49a8e6='(',_0x11ae32=0x0;_0x11ae32<_0x46a544[_0xdfb3('0x66')][_0xdfb3('0x33')];_0x11ae32+=0x1){_0x11ae32>0x0&&(_0x49a8e6+='\x20'+_0x46a544[_0xdfb3('0x67')]+'\x20');_0x49a8e6+=_0x46a544[_0xdfb3('0x66')][_0x11ae32]['group']?_0x1bae90(_0x46a544[_0xdfb3('0x66')][_0x11ae32][_0xdfb3('0x68')]):_0x46a544[_0xdfb3('0x66')][_0x11ae32][_0xdfb3('0x3f')]+'\x20'+_0x46a544[_0xdfb3('0x66')][_0x11ae32][_0xdfb3('0x69')]+(_0x23af61(_0x46a544['rules'][_0x11ae32][_0xdfb3('0x69')])?'\x20'+_0x46a544['rules'][_0x11ae32][_0xdfb3('0x89')]:'');}return _0x49a8e6+')';};var _0x26b397={'where':{'id':_0x3f18d3[_0xdfb3('0x45')]['id']}},_0x46e489,_0x32fb6f,_0x2ab719,_0x4f61c9,_0x549760;_0x26b397=_[_0xdfb3('0x3b')]({},_0x26b397,_0x3f18d3[_0xdfb3('0x40')]);return db[_0xdfb3('0x2b')]['find'](_0x26b397)[_0xdfb3('0x22')](function(_0x199b75){if(_0x199b75){_0x46e489=_0x199b75;return _0x199b75[_0xdfb3('0x6a')]();}return null;})[_0xdfb3('0x22')](function(_0x5b0c0a){if(_0x5b0c0a){if(!_0x5b0c0a['length']){throw new db['Sequelize']['ValidationErrorItem'](_0xdfb3('0x6c'),0x193);}_0x32fb6f=_0x5b0c0a;return db[_0xdfb3('0x6d')]['findAll']({'raw':!![]});}return null;})[_0xdfb3('0x22')](function(_0x713bd2){if(_0x713bd2){_0x2ab719=_[_0xdfb3('0x8a')](_0x713bd2,'id');var _0x5e9959;var _0x9f0d40=squel[_0xdfb3('0x6e')]();_0x9f0d40[_0xdfb3('0x6f')](_0x46e489['table']);for(var _0x2403d8=0x0;_0x2403d8<_0x32fb6f[_0xdfb3('0x33')];_0x2403d8+=0x1){_0x5e9959=_0x32fb6f[_0x2403d8][_0xdfb3('0x71')]?_0x2ab719[_0x32fb6f[_0x2403d8][_0xdfb3('0x71')]][_0xdfb3('0x8b')]:_0x32fb6f[_0x2403d8][_0xdfb3('0x3f')];_0x5e9959=_0x32fb6f[_0x2403d8]['function']?_[_0xdfb3('0xa4')](_0x3cffa1[_0x32fb6f[_0x2403d8][_0xdfb3('0x72')]],'%s',_0x5e9959):_0x5e9959;_0x5e9959=_0x32fb6f[_0x2403d8][_0xdfb3('0x73')]?_[_0xdfb3('0xa4')](_0x468cff[_0x32fb6f[_0x2403d8][_0xdfb3('0x73')]],'%s',_0x5e9959):_0x5e9959;if(_0x32fb6f[_0x2403d8]['groupBy']){_0x9f0d40[_0xdfb3('0x68')](_0x5e9959);}_0x32fb6f[_0x2403d8][_0xdfb3('0x74')]&&_0x9f0d40[_0xdfb3('0x36')](_0x5e9959,_0x32fb6f[_0x2403d8][_0xdfb3('0x74')]==='DESC'?![]:!![]);_0x9f0d40['field'](_0x5e9959,_0x32fb6f[_0x2403d8][_0xdfb3('0x76')]||_0x5e9959);}if(_0x46e489['joins']){_0x46e489['joins']=JSON[_0xdfb3('0x78')](_0x46e489['joins']);for(var _0x28e186=0x0;_0x28e186<_0x46e489['joins']['length'];_0x28e186+=0x1){if(_0x46e489['joins'][_0x28e186][_0xdfb3('0x79')]&&_[_0xdfb3('0x7a')](_0x1e14fa,_0x46e489[_0xdfb3('0x77')][_0x28e186][_0xdfb3('0x79')])&&_0x46e489['joins'][_0x28e186][_0xdfb3('0x7b')]&&_0x46e489[_0xdfb3('0x77')][_0x28e186]['foreignTable']&&_0x46e489['joins'][_0x28e186][_0xdfb3('0x7e')]){_0x9f0d40[_0x46e489[_0xdfb3('0x77')][_0x28e186]['type']](_0x46e489[_0xdfb3('0x77')][_0x28e186][_0xdfb3('0x7c')],null,util[_0xdfb3('0x73')](_0xdfb3('0x7d'),_0x46e489['table'],_0x46e489[_0xdfb3('0x77')][_0x28e186]['parentKey'],_0x46e489[_0xdfb3('0x77')][_0x28e186][_0xdfb3('0x7c')],_0x46e489['joins'][_0x28e186][_0xdfb3('0x7e')]));}}}if(_0x46e489[_0xdfb3('0x7f')]){_0x46e489[_0xdfb3('0x7f')]=JSON[_0xdfb3('0x78')](_0x46e489[_0xdfb3('0x7f')]);_0x9f0d40[_0xdfb3('0x38')](_0x1bae90(_0x46e489['conditions']['group']));}_0x549760=_0x9f0d40['clone']();_0x9f0d40[_0xdfb3('0x1c')](_0x534488);_0x9f0d40[_0xdfb3('0x1b')](0x0);logger[_0xdfb3('0x80')](_0xdfb3('0x81'),_0x9f0d40[_0xdfb3('0x82')]());return db[_0xdfb3('0x83')][_0xdfb3('0x2f')](_0x9f0d40[_0xdfb3('0x82')](),{'type':db['sequelize'][_0xdfb3('0x84')][_0xdfb3('0x85')]});}})[_0xdfb3('0x22')](function(){return{'sql':_0x549760[_0xdfb3('0x82')]()};})[_0xdfb3('0x22')](respondWithResult(_0x1515e7,null))[_0xdfb3('0x49')](handleError(_0x1515e7,null));};
\ No newline at end of file
+var _0x7459=['get','UserProfileResource','destroy','error','stack','name','send','AnalyticDefaultReport','model','keys','query','attributes','fields','length','nolimit','order','sort','where','filters','filter','merge','type','VIRTUAL','field','options','includeAll','include','findAll','rows','show','rawAttributes','intersection','find','catch','create','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','Reports','autoAssociation','DefaultReports','update','body','params','preview','join','left_join','cross_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','AVG(%s)','SEC_TO_TIME(%s)','DATE(%s)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','condition','value','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','select','from','metric','function','format','replace','groupBy','orderBy','DESC','alias','joins','parse','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','table','conditions','debug','Limited\x20Query:','toString','sequelize','SELECT','right_join','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','MetricId','clone','QueryTypes','No\x20available\x20data','output','web','%s-%s.%s','randomstring','generate','default','cdr','startDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','Run\x20Query:','../../files/reports','countTable','COUNT(*)','run','runReport','MAX(%s)','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','bluebird','util','path','sox','to-csv','lodash','squel','crypto','jsforce','../../components/auth/service','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','json','count','offset','limit','set','Content-Range','apply','reject','then'];(function(_0x47a7d0,_0x4e182d){var _0xb9bd08=function(_0x588ee2){while(--_0x588ee2){_0x47a7d0['push'](_0x47a7d0['shift']());}};_0xb9bd08(++_0x4e182d);}(_0x7459,0x1ad));var _0x9745=function(_0x311746,_0x5d553c){_0x311746=_0x311746-0x0;var _0x1c40d1=_0x7459[_0x311746];return _0x1c40d1;};'use strict';var pdf=require(_0x9745('0x0'));var emlformat=require(_0x9745('0x1'));var rimraf=require(_0x9745('0x2'));var zipdir=require(_0x9745('0x3'));var jsonpatch=require(_0x9745('0x4'));var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0x9745('0x5'));var Mustache=require('mustache');var util=require(_0x9745('0x6'));var path=require(_0x9745('0x7'));var sox=require(_0x9745('0x8'));var csv=require(_0x9745('0x9'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x9745('0xa'));var squel=require(_0x9745('0xb'));var crypto=require(_0x9745('0xc'));var jsforce=require(_0x9745('0xd'));var deskjs=require('desk.js');var toCsv=require(_0x9745('0x9'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x9745('0xe'));var qs=require('../../components/parsers/qs');var hardwareService=require(_0x9745('0xf'));var logger=require(_0x9745('0x10'))(_0x9745('0x11'));var utils=require(_0x9745('0x12'));var config=require(_0x9745('0x13'));var db=require(_0x9745('0x14'))['db'];function respondWithStatusCode(_0x50fabe,_0x1e506d){_0x1e506d=_0x1e506d||0xcc;return function(_0x52c7ca){if(_0x52c7ca){return _0x50fabe[_0x9745('0x15')](_0x1e506d);}return _0x50fabe[_0x9745('0x16')](_0x1e506d)[_0x9745('0x17')]();};}function respondWithResult(_0x508d96,_0x30f988){_0x30f988=_0x30f988||0xc8;return function(_0x17652d){if(_0x17652d){return _0x508d96[_0x9745('0x16')](_0x30f988)[_0x9745('0x18')](_0x17652d);}};}function respondWithFilteredResult(_0x40763d,_0x4c1689){return function(_0x558a84){if(_0x558a84){var _0x33e89f=_0x558a84[_0x9745('0x19')],_0x398221=_0x4c1689[_0x9745('0x1a')],_0x79432e=_0x4c1689[_0x9745('0x1a')]+_0x4c1689[_0x9745('0x1b')],_0x175318;if(_0x79432e>=_0x33e89f){_0x79432e=_0x33e89f;_0x175318=0xc8;}else{_0x175318=0xce;}_0x40763d['status'](_0x175318);return _0x40763d[_0x9745('0x1c')](_0x9745('0x1d'),_0x398221+'-'+_0x79432e+'/'+_0x33e89f)[_0x9745('0x18')](_0x558a84);}return null;};}function patchUpdates(_0x2db5c3){return function(_0x32dbe8){try{jsonpatch[_0x9745('0x1e')](_0x32dbe8,_0x2db5c3,!![]);}catch(_0x2c409d){return BPromise[_0x9745('0x1f')](_0x2c409d);}return _0x32dbe8['save']();};}function saveUpdates(_0x316a20,_0x1007e6){return function(_0x2e8415){if(_0x2e8415){return _0x2e8415['update'](_0x316a20)['then'](function(_0xce515d){return _0xce515d;});}return null;};}function removeEntity(_0x28843a,_0x597552){return function(_0x90577b){if(_0x90577b){return _0x90577b['destroy']()[_0x9745('0x20')](function(){var _0x5a6650=_0x90577b[_0x9745('0x21')]({'plain':!![]});var _0x59f9c9='DefaultReports';return db[_0x9745('0x22')][_0x9745('0x23')]({'where':{'type':_0x59f9c9,'resourceId':_0x5a6650['id']}})[_0x9745('0x20')](function(){return _0x90577b;});})[_0x9745('0x20')](function(){_0x28843a[_0x9745('0x16')](0xcc)[_0x9745('0x17')]();});}};}function handleEntityNotFound(_0x564859,_0x160891){return function(_0x3e3ade){if(!_0x3e3ade){_0x564859[_0x9745('0x15')](0x194);}return _0x3e3ade;};}function handleError(_0x446271,_0x48e7c2){_0x48e7c2=_0x48e7c2||0x1f4;return function(_0x95afbf){logger[_0x9745('0x24')](_0x95afbf[_0x9745('0x25')]);if(_0x95afbf['name']){delete _0x95afbf[_0x9745('0x26')];}_0x446271[_0x9745('0x16')](_0x48e7c2)[_0x9745('0x27')](_0x95afbf);};}exports['index']=function(_0x4b2142,_0x114fe8){var _0x3f4554={},_0x10dc31={},_0xc899db={'count':0x0,'rows':[]};var _0x40dc43=db[_0x9745('0x28')]['rawAttributes'];_0x10dc31[_0x9745('0x29')]=_[_0x9745('0x2a')](_0x40dc43);_0x10dc31['query']=_['keys'](_0x4b2142['query']);_0x10dc31['filters']=_['intersection'](_0x10dc31['model'],_0x10dc31[_0x9745('0x2b')]);_0x3f4554[_0x9745('0x2c')]=_['intersection'](_0x10dc31['model'],qs[_0x9745('0x2d')](_0x4b2142[_0x9745('0x2b')][_0x9745('0x2d')]));_0x3f4554[_0x9745('0x2c')]=_0x3f4554[_0x9745('0x2c')][_0x9745('0x2e')]?_0x3f4554['attributes']:_0x10dc31['model'];if(!_0x4b2142[_0x9745('0x2b')]['hasOwnProperty'](_0x9745('0x2f'))){_0x3f4554[_0x9745('0x1b')]=qs[_0x9745('0x1b')](_0x4b2142[_0x9745('0x2b')]['limit']);_0x3f4554[_0x9745('0x1a')]=qs['offset'](_0x4b2142[_0x9745('0x2b')][_0x9745('0x1a')]);}_0x3f4554[_0x9745('0x30')]=qs[_0x9745('0x31')](_0x4b2142[_0x9745('0x2b')][_0x9745('0x31')]);_0x3f4554[_0x9745('0x32')]=qs[_0x9745('0x33')](_['pick'](_0x4b2142[_0x9745('0x2b')],_0x10dc31['filters']));if(_0x4b2142['query'][_0x9745('0x34')]){_0x3f4554['where']=_[_0x9745('0x35')](_0x3f4554[_0x9745('0x32')],{'$or':_['map'](_0x40dc43,function(_0x20d73f){if(_0x20d73f[_0x9745('0x36')]['key']!==_0x9745('0x37')){var _0x108377={};_0x108377[_0x20d73f[_0x9745('0x38')]]={'$like':'%'+_0x4b2142[_0x9745('0x2b')]['filter']+'%'};return _0x108377;}})});}_0x3f4554=_['merge']({},_0x3f4554,_0x4b2142[_0x9745('0x39')]);var _0x40fa1b={'where':_0x3f4554['where']};return db[_0x9745('0x28')][_0x9745('0x19')](_0x40fa1b)[_0x9745('0x20')](function(_0x28b57c){_0xc899db[_0x9745('0x19')]=_0x28b57c;if(_0x4b2142['query'][_0x9745('0x3a')]){_0x3f4554[_0x9745('0x3b')]=[{'all':!![]}];}return db['AnalyticDefaultReport'][_0x9745('0x3c')](_0x3f4554);})[_0x9745('0x20')](function(_0x3fbad7){_0xc899db[_0x9745('0x3d')]=_0x3fbad7;return _0xc899db;})[_0x9745('0x20')](respondWithFilteredResult(_0x114fe8,_0x3f4554))['catch'](handleError(_0x114fe8,null));};exports[_0x9745('0x3e')]=function(_0x5c0189,_0x130a76){var _0x5bb93f={'raw':!![],'where':{'id':_0x5c0189['params']['id']}},_0x14038b={};_0x14038b[_0x9745('0x29')]=_[_0x9745('0x2a')](db[_0x9745('0x28')][_0x9745('0x3f')]);_0x14038b[_0x9745('0x2b')]=_[_0x9745('0x2a')](_0x5c0189['query']);_0x14038b[_0x9745('0x33')]=_[_0x9745('0x40')](_0x14038b[_0x9745('0x29')],_0x14038b[_0x9745('0x2b')]);_0x5bb93f[_0x9745('0x2c')]=_[_0x9745('0x40')](_0x14038b[_0x9745('0x29')],qs[_0x9745('0x2d')](_0x5c0189[_0x9745('0x2b')][_0x9745('0x2d')]));_0x5bb93f['attributes']=_0x5bb93f['attributes'][_0x9745('0x2e')]?_0x5bb93f[_0x9745('0x2c')]:_0x14038b[_0x9745('0x29')];if(_0x5c0189[_0x9745('0x2b')][_0x9745('0x3a')]){_0x5bb93f[_0x9745('0x3b')]=[{'all':!![]}];}_0x5bb93f=_[_0x9745('0x35')]({},_0x5bb93f,_0x5c0189[_0x9745('0x39')]);return db[_0x9745('0x28')][_0x9745('0x41')](_0x5bb93f)[_0x9745('0x20')](handleEntityNotFound(_0x130a76,null))['then'](respondWithResult(_0x130a76,null))[_0x9745('0x42')](handleError(_0x130a76,null));};exports[_0x9745('0x43')]=function(_0x7d3ff1,_0x35fee1){return db[_0x9745('0x28')][_0x9745('0x43')](_0x7d3ff1['body'],{})[_0x9745('0x20')](function(_0x2f2aae){var _0x2a2ae2=_0x7d3ff1['user'][_0x9745('0x21')]({'plain':!![]});if(!_0x2a2ae2)throw new Error(_0x9745('0x44'));if(_0x2a2ae2[_0x9745('0x45')]===_0x9745('0x46')){var _0x470920=_0x2f2aae[_0x9745('0x21')]({'plain':!![]});var _0x560b8b=_0x9745('0x47');return db['UserProfileSection'][_0x9745('0x41')]({'where':{'name':_0x560b8b,'userProfileId':_0x2a2ae2['userProfileId']},'raw':!![]})['then'](function(_0x45b162){if(_0x45b162&&_0x45b162[_0x9745('0x48')]===0x0){return db[_0x9745('0x22')][_0x9745('0x43')]({'name':_0x470920[_0x9745('0x26')],'resourceId':_0x470920['id'],'type':_0x9745('0x49'),'sectionId':_0x45b162['id']},{})[_0x9745('0x20')](function(){return _0x2f2aae;});}else{return _0x2f2aae;}})['catch'](function(_0x144973){logger[_0x9745('0x24')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x144973);throw _0x144973;});}return _0x2f2aae;})[_0x9745('0x20')](respondWithResult(_0x35fee1,0xc9))[_0x9745('0x42')](handleError(_0x35fee1,null));};exports[_0x9745('0x4a')]=function(_0x4a1d4c,_0x275135){if(_0x4a1d4c[_0x9745('0x4b')]['id']){delete _0x4a1d4c[_0x9745('0x4b')]['id'];}return db[_0x9745('0x28')][_0x9745('0x41')]({'where':{'id':_0x4a1d4c[_0x9745('0x4c')]['id']}})[_0x9745('0x20')](handleEntityNotFound(_0x275135,null))[_0x9745('0x20')](saveUpdates(_0x4a1d4c[_0x9745('0x4b')],null))[_0x9745('0x20')](respondWithResult(_0x275135,null))['catch'](handleError(_0x275135,null));};exports[_0x9745('0x23')]=function(_0x6e59d9,_0x57fc13){return db[_0x9745('0x28')]['find']({'where':{'id':_0x6e59d9[_0x9745('0x4c')]['id']}})[_0x9745('0x20')](handleEntityNotFound(_0x57fc13,null))[_0x9745('0x20')](removeEntity(_0x57fc13,null))[_0x9745('0x42')](handleError(_0x57fc13,null));};exports[_0x9745('0x4d')]=function(_0xce3766,_0x4ef346){var _0x27f0e1=0xa;var _0x58b92f=[_0x9745('0x4e'),_0x9745('0x4f'),'right_join',_0x9745('0x50')];var _0xafe162={'SUM':_0x9745('0x51'),'COUNT':_0x9745('0x52'),'COUNT DISTINCT':_0x9745('0x53'),'MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':_0x9745('0x54'),'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 _0x147638={'SEC_TO_TIME':_0x9745('0x55'),'DATE':_0x9745('0x56'),'HOUR':_0x9745('0x57'),'ROUND':_0x9745('0x58'),'UNIX_TIMESTAMP':_0x9745('0x59')};var _0x623804=function(_0x588c6c){return!_[_0x9745('0x5a')]([_0x9745('0x5b'),_0x9745('0x5c'),_0x9745('0x5d'),_0x9745('0x5e')],_0x588c6c);};var _0x5575ad=function(_0x5402c9){if(!_0x5402c9||!_0x5402c9[_0x9745('0x5f')]['length']){return'';}for(var _0x3a87b1='(',_0x3d23fe=0x0;_0x3d23fe<_0x5402c9[_0x9745('0x5f')][_0x9745('0x2e')];_0x3d23fe+=0x1){_0x3d23fe>0x0&&(_0x3a87b1+='\x20'+_0x5402c9[_0x9745('0x60')]+'\x20');_0x3a87b1+=_0x5402c9[_0x9745('0x5f')][_0x3d23fe]['group']?_0x5575ad(_0x5402c9['rules'][_0x3d23fe][_0x9745('0x61')]):_0x5402c9[_0x9745('0x5f')][_0x3d23fe]['field']+'\x20'+_0x5402c9['rules'][_0x3d23fe][_0x9745('0x62')]+(_0x623804(_0x5402c9[_0x9745('0x5f')][_0x3d23fe][_0x9745('0x62')])?'\x20'+_0x5402c9['rules'][_0x3d23fe][_0x9745('0x63')]:'');}return _0x3a87b1+')';};var _0x422591={'where':{'id':_0xce3766[_0x9745('0x4c')]['id']}},_0x2a6616,_0x33b904,_0x1a8efe,_0x30b6a2,_0x4e1337;_0x422591=_['merge']({},_0x422591,_0xce3766[_0x9745('0x39')]);return db['AnalyticDefaultReport']['find'](_0x422591)[_0x9745('0x20')](function(_0x3c8839){if(_0x3c8839){_0x2a6616=_0x3c8839;return _0x3c8839[_0x9745('0x64')]();}return null;})[_0x9745('0x20')](function(_0x418a3d){if(_0x418a3d){if(!_0x418a3d[_0x9745('0x2e')]){throw new db[(_0x9745('0x65'))][(_0x9745('0x66'))](_0x9745('0x67'),0x193);}_0x33b904=_0x418a3d;return db[_0x9745('0x68')][_0x9745('0x3c')]({'raw':!![]});}return null;})[_0x9745('0x20')](function(_0x5f15ab){if(_0x5f15ab){_0x1a8efe=_[_0x9745('0x69')](_0x5f15ab,'id');var _0x1be3cb;var _0x160522=squel[_0x9745('0x6a')]();_0x160522[_0x9745('0x6b')](_0x2a6616['table']);for(var _0x52958e=0x0;_0x52958e<_0x33b904[_0x9745('0x2e')];_0x52958e+=0x1){_0x1be3cb=_0x33b904[_0x52958e]['MetricId']?_0x1a8efe[_0x33b904[_0x52958e]['MetricId']][_0x9745('0x6c')]:_0x33b904[_0x52958e][_0x9745('0x38')];_0x1be3cb=_0x33b904[_0x52958e][_0x9745('0x6d')]?_['replace'](_0xafe162[_0x33b904[_0x52958e][_0x9745('0x6d')]],'%s',_0x1be3cb):_0x1be3cb;_0x1be3cb=_0x33b904[_0x52958e][_0x9745('0x6e')]?_[_0x9745('0x6f')](_0x147638[_0x33b904[_0x52958e]['format']],'%s',_0x1be3cb):_0x1be3cb;if(_0x33b904[_0x52958e][_0x9745('0x70')]){_0x160522[_0x9745('0x61')](_0x1be3cb);}_0x33b904[_0x52958e][_0x9745('0x71')]&&_0x160522['order'](_0x1be3cb,_0x33b904[_0x52958e][_0x9745('0x71')]===_0x9745('0x72')?![]:!![]);_0x160522['field'](_0x1be3cb,_0x33b904[_0x52958e][_0x9745('0x73')]||_0x1be3cb);}if(_0x2a6616[_0x9745('0x74')]){_0x2a6616[_0x9745('0x74')]=JSON[_0x9745('0x75')](_0x2a6616['joins']);for(var _0x32b9f0=0x0;_0x32b9f0<_0x2a6616[_0x9745('0x74')][_0x9745('0x2e')];_0x32b9f0+=0x1){if(_0x2a6616['joins'][_0x32b9f0][_0x9745('0x36')]&&_[_0x9745('0x5a')](_0x58b92f,_0x2a6616['joins'][_0x32b9f0][_0x9745('0x36')])&&_0x2a6616[_0x9745('0x74')][_0x32b9f0][_0x9745('0x76')]&&_0x2a6616[_0x9745('0x74')][_0x32b9f0][_0x9745('0x77')]&&_0x2a6616[_0x9745('0x74')][_0x32b9f0][_0x9745('0x78')]){_0x160522[_0x2a6616[_0x9745('0x74')][_0x32b9f0][_0x9745('0x36')]](_0x2a6616[_0x9745('0x74')][_0x32b9f0][_0x9745('0x77')],null,util['format'](_0x9745('0x79'),_0x2a6616[_0x9745('0x7a')],_0x2a6616['joins'][_0x32b9f0][_0x9745('0x76')],_0x2a6616['joins'][_0x32b9f0][_0x9745('0x77')],_0x2a6616[_0x9745('0x74')][_0x32b9f0][_0x9745('0x78')]));}}}if(_0x2a6616[_0x9745('0x7b')]){_0x2a6616['conditions']=JSON[_0x9745('0x75')](_0x2a6616[_0x9745('0x7b')]);_0x160522['where'](_0x5575ad(_0x2a6616[_0x9745('0x7b')][_0x9745('0x61')]));}_0x4e1337=_0x160522['clone']();_0x160522[_0x9745('0x1b')](_0x27f0e1);_0x160522[_0x9745('0x1a')](0x0);logger[_0x9745('0x7c')](_0x9745('0x7d'),_0x160522[_0x9745('0x7e')]());return db['sequelize'][_0x9745('0x2b')](_0x160522[_0x9745('0x7e')](),{'type':db[_0x9745('0x7f')]['QueryTypes'][_0x9745('0x80')]});}})[_0x9745('0x20')](respondWithResult(_0x4ef346,null))[_0x9745('0x42')](handleError(_0x4ef346,null));};function runReport(_0x1dc743,_0x435eec,_0x23406a){var _0x5eb4cd=_0x435eec[_0x9745('0x26')];var _0x5af60e=0xa;var _0x47b272=[_0x9745('0x4e'),_0x9745('0x4f'),_0x9745('0x81'),_0x9745('0x50')];var _0x5ee31a={'SUM':_0x9745('0x51'),'COUNT':_0x9745('0x52'),'COUNT DISTINCT':_0x9745('0x53'),'MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':'AVG(%s)','GROUP_CONCAT':_0x9745('0x82'),'GROUP_CONCAT ASC':_0x9745('0x83'),'GROUP_CONCAT DESC':_0x9745('0x84')};var _0xf04a6c={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x9745('0x56'),'HOUR':_0x9745('0x57'),'ROUND':_0x9745('0x58'),'UNIX_TIMESTAMP':_0x9745('0x59')};var _0xc29f9=function(_0x6776d8){return!_[_0x9745('0x5a')]([_0x9745('0x5b'),'IS\x20NOT\x20NULL',_0x9745('0x5d'),_0x9745('0x5e')],_0x6776d8);};var _0x403210=function(_0x27b180){if(!_0x27b180||!_0x27b180[_0x9745('0x5f')][_0x9745('0x2e')]){return'';}for(var _0x287cf6='(',_0x40dc42=0x0;_0x40dc42<_0x27b180['rules'][_0x9745('0x2e')];_0x40dc42+=0x1){_0x40dc42>0x0&&(_0x287cf6+='\x20'+_0x27b180[_0x9745('0x60')]+'\x20');_0x287cf6+=_0x27b180[_0x9745('0x5f')][_0x40dc42]['group']?_0x403210(_0x27b180[_0x9745('0x5f')][_0x40dc42][_0x9745('0x61')]):_0x27b180['rules'][_0x40dc42][_0x9745('0x38')]+'\x20'+_0x27b180['rules'][_0x40dc42][_0x9745('0x62')]+(_0xc29f9(_0x27b180['rules'][_0x40dc42][_0x9745('0x62')])?'\x20'+_0x27b180['rules'][_0x40dc42][_0x9745('0x63')]:'');}return _0x287cf6+')';};var _0x1524cd={'where':{'id':_0x1dc743['id']}},_0x9c6453,_0xa70cf4,_0x3d1864,_0x251c06,_0x93031a;_0x1524cd=_['merge']({},_0x1524cd,_0x23406a);return db[_0x9745('0x28')][_0x9745('0x41')](_0x1524cd)[_0x9745('0x20')](function(_0x10f216){if(_0x10f216){_0x9c6453=_0x10f216;return _0x10f216[_0x9745('0x64')]();}return null;})[_0x9745('0x20')](function(_0x4676f9){if(_0x4676f9){if(!_0x4676f9[_0x9745('0x2e')]){throw new db[(_0x9745('0x65'))]['ValidationErrorItem'](_0x9745('0x67'),0x193);}_0xa70cf4=_0x4676f9;return db[_0x9745('0x68')]['findAll']({'raw':!![]});}return null;})[_0x9745('0x20')](function(_0x25f753){if(_0x25f753){_0x3d1864=_[_0x9745('0x69')](_0x25f753,'id');var _0x105f2d;var _0x1fe711=squel['select']();_0x1fe711[_0x9745('0x6b')](_0x9c6453[_0x9745('0x7a')]);for(var _0x26236a=0x0;_0x26236a<_0xa70cf4[_0x9745('0x2e')];_0x26236a+=0x1){_0x105f2d=_0xa70cf4[_0x26236a][_0x9745('0x85')]?_0x3d1864[_0xa70cf4[_0x26236a][_0x9745('0x85')]]['metric']:_0xa70cf4[_0x26236a][_0x9745('0x38')];_0x105f2d=_0xa70cf4[_0x26236a][_0x9745('0x6d')]?_[_0x9745('0x6f')](_0x5ee31a[_0xa70cf4[_0x26236a]['function']],'%s',_0x105f2d):_0x105f2d;_0x105f2d=_0xa70cf4[_0x26236a][_0x9745('0x6e')]?_[_0x9745('0x6f')](_0xf04a6c[_0xa70cf4[_0x26236a][_0x9745('0x6e')]],'%s',_0x105f2d):_0x105f2d;if(_0xa70cf4[_0x26236a][_0x9745('0x70')]){_0x1fe711[_0x9745('0x61')](_0x105f2d);}_0xa70cf4[_0x26236a][_0x9745('0x71')]&&_0x1fe711['order'](_0x105f2d,_0xa70cf4[_0x26236a][_0x9745('0x71')]===_0x9745('0x72')?![]:!![]);_0x1fe711[_0x9745('0x38')](_0x105f2d,_0xa70cf4[_0x26236a][_0x9745('0x73')]||_0x105f2d);}if(_0x9c6453[_0x9745('0x74')]){_0x9c6453['joins']=JSON[_0x9745('0x75')](_0x9c6453[_0x9745('0x74')]);for(var _0x5abc3d=0x0;_0x5abc3d<_0x9c6453[_0x9745('0x74')][_0x9745('0x2e')];_0x5abc3d+=0x1){if(_0x9c6453[_0x9745('0x74')][_0x5abc3d][_0x9745('0x36')]&&_['includes'](_0x47b272,_0x9c6453[_0x9745('0x74')][_0x5abc3d][_0x9745('0x36')])&&_0x9c6453[_0x9745('0x74')][_0x5abc3d][_0x9745('0x76')]&&_0x9c6453[_0x9745('0x74')][_0x5abc3d][_0x9745('0x77')]&&_0x9c6453[_0x9745('0x74')][_0x5abc3d][_0x9745('0x78')]){_0x1fe711[_0x9c6453[_0x9745('0x74')][_0x5abc3d][_0x9745('0x36')]](_0x9c6453['joins'][_0x5abc3d][_0x9745('0x77')],null,util[_0x9745('0x6e')](_0x9745('0x79'),_0x9c6453[_0x9745('0x7a')],_0x9c6453[_0x9745('0x74')][_0x5abc3d][_0x9745('0x76')],_0x9c6453[_0x9745('0x74')][_0x5abc3d][_0x9745('0x77')],_0x9c6453[_0x9745('0x74')][_0x5abc3d]['foreignKey']));}}}if(_0x9c6453['conditions']){_0x9c6453[_0x9745('0x7b')]=JSON['parse'](_0x9c6453['conditions']);_0x1fe711[_0x9745('0x32')](_0x403210(_0x9c6453[_0x9745('0x7b')]['group']));}_0x93031a=_0x1fe711[_0x9745('0x86')]();_0x1fe711['limit'](_0x5af60e);_0x1fe711[_0x9745('0x1a')](0x0);logger[_0x9745('0x7c')](_0x9745('0x7d'),_0x1fe711[_0x9745('0x7e')]());return db['sequelize']['query'](_0x1fe711[_0x9745('0x7e')](),{'type':db[_0x9745('0x7f')][_0x9745('0x87')][_0x9745('0x80')]});}})[_0x9745('0x20')](function(_0x5f2f9b){if(!_0x5f2f9b[_0x9745('0x2e')]){throw new db[(_0x9745('0x65'))][(_0x9745('0x66'))](_0x9745('0x88'),0xcc);}if(_0x435eec[_0x9745('0x89')]===_0x9745('0x8a')){return null;}var _0x493f1d=_[_0x9745('0x35')](_0x435eec,{'name':_0x435eec['fullPath']||_0x435eec[_0x9745('0x26')]||_0x9c6453['name'],'basename':_0x5eb4cd,'savename':util['format'](_0x9745('0x8b'),_0x435eec[_0x9745('0x26')]||_0x9c6453[_0x9745('0x26')],require(_0x9745('0x8c'))[_0x9745('0x8d')](0x4),_0x435eec[_0x9745('0x89')]||'csv'),'reportId':_0x9c6453['id'],'reportType':_0x9745('0x8e')});return db['AnalyticExtractedReport'][_0x9745('0x43')](_0x493f1d,{'raw':!![]});})[_0x9745('0x20')](function(_0x48c2c5){if(_0x9c6453[_0x9745('0x7a')]===_0x9745('0x8f')){_0x93031a['where'](_0x9c6453['table']+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x435eec[_0x9745('0x90')],_0x435eec['endDate']);}else{_0x93031a[_0x9745('0x32')](_0x9c6453['table']+_0x9745('0x91'),_0x435eec[_0x9745('0x90')],_0x435eec['endDate']);}if(_0x48c2c5){logger[_0x9745('0x92')](_0x9745('0x93'),_0x93031a['toString']());require('child_process')['fork'](path[_0x9745('0x4e')](__dirname,'../../components/export/',_0x48c2c5['output']),[_0x48c2c5['id'],_0x93031a[_0x9745('0x7e')](),path['join'](__dirname,_0x9745('0x94'),_0x48c2c5['savename']),_0x5eb4cd]);return _0x48c2c5;}else{var _0x315b59=squel[_0x9745('0x6a')]();_0x315b59['from']('('+_0x93031a[_0x9745('0x7e')]()+')',_0x9745('0x95'));_0x315b59[_0x9745('0x38')](_0x9745('0x96'),'count');_0x93031a[_0x9745('0x1b')](_0x435eec[_0x9745('0x1b')]||_0x5af60e);_0x93031a[_0x9745('0x1a')](_0x435eec[_0x9745('0x1a')]||0x0);return db[_0x9745('0x7f')][_0x9745('0x2b')](_0x315b59[_0x9745('0x7e')](),{'type':db[_0x9745('0x7f')][_0x9745('0x87')][_0x9745('0x80')]})[_0x9745('0x20')](function(_0x93d9e7){if(!_0x93d9e7['length']){_0x251c06=0x0;}else{_0x251c06=_0x93d9e7[0x0]['count']||0x0;}return db[_0x9745('0x7f')]['query'](_0x93031a[_0x9745('0x7e')](),{'type':db[_0x9745('0x7f')][_0x9745('0x87')][_0x9745('0x80')]});})[_0x9745('0x20')](function(_0x47724a){return{'rows':_0x47724a||[],'count':_0x251c06};});}});}exports[_0x9745('0x97')]=function(_0x151a36,_0x394137){return runReport(_0x151a36['params'],_0x151a36[_0x9745('0x2b')],_0x151a36[_0x9745('0x39')])[_0x9745('0x20')](respondWithResult(_0x394137,null))[_0x9745('0x42')](handleError(_0x394137,null));};exports[_0x9745('0x98')]=runReport;exports[_0x9745('0x2b')]=function(_0x5d3e75,_0x2e200c){var _0x26f687=0xa;var _0x6e0f95=['join',_0x9745('0x4f'),_0x9745('0x81'),_0x9745('0x50')];var _0x73b2f2={'SUM':_0x9745('0x51'),'COUNT':_0x9745('0x52'),'COUNT DISTINCT':_0x9745('0x53'),'MAX':_0x9745('0x99'),'MIN':'MIN(%s)','AVG':_0x9745('0x54'),'GROUP_CONCAT':_0x9745('0x82'),'GROUP_CONCAT ASC':_0x9745('0x83'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x42ee73={'SEC_TO_TIME':_0x9745('0x55'),'DATE':_0x9745('0x56'),'HOUR':_0x9745('0x57'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x362256=function(_0x156740){return!_[_0x9745('0x5a')]([_0x9745('0x5b'),_0x9745('0x5c'),_0x9745('0x5d'),_0x9745('0x5e')],_0x156740);};var _0x4d3498=function(_0x1660c7){if(!_0x1660c7||!_0x1660c7[_0x9745('0x5f')][_0x9745('0x2e')]){return'';}for(var _0x4493bb='(',_0x4a468b=0x0;_0x4a468b<_0x1660c7[_0x9745('0x5f')][_0x9745('0x2e')];_0x4a468b+=0x1){_0x4a468b>0x0&&(_0x4493bb+='\x20'+_0x1660c7[_0x9745('0x60')]+'\x20');_0x4493bb+=_0x1660c7['rules'][_0x4a468b]['group']?_0x4d3498(_0x1660c7[_0x9745('0x5f')][_0x4a468b][_0x9745('0x61')]):_0x1660c7[_0x9745('0x5f')][_0x4a468b][_0x9745('0x38')]+'\x20'+_0x1660c7[_0x9745('0x5f')][_0x4a468b][_0x9745('0x62')]+(_0x362256(_0x1660c7[_0x9745('0x5f')][_0x4a468b][_0x9745('0x62')])?'\x20'+_0x1660c7[_0x9745('0x5f')][_0x4a468b][_0x9745('0x63')]:'');}return _0x4493bb+')';};var _0x27ec4c={'where':{'id':_0x5d3e75[_0x9745('0x4c')]['id']}},_0x23d60e,_0x399886,_0x220696,_0x2f05a6,_0x51c63e;_0x27ec4c=_[_0x9745('0x35')]({},_0x27ec4c,_0x5d3e75[_0x9745('0x39')]);return db[_0x9745('0x28')]['find'](_0x27ec4c)[_0x9745('0x20')](function(_0x11eeb2){if(_0x11eeb2){_0x23d60e=_0x11eeb2;return _0x11eeb2[_0x9745('0x64')]();}return null;})[_0x9745('0x20')](function(_0x3d2ff0){if(_0x3d2ff0){if(!_0x3d2ff0[_0x9745('0x2e')]){throw new db[(_0x9745('0x65'))][(_0x9745('0x66'))](_0x9745('0x67'),0x193);}_0x399886=_0x3d2ff0;return db[_0x9745('0x68')][_0x9745('0x3c')]({'raw':!![]});}return null;})['then'](function(_0x43b67f){if(_0x43b67f){_0x220696=_[_0x9745('0x69')](_0x43b67f,'id');var _0x2b8523;var _0x17d3f9=squel['select']();_0x17d3f9[_0x9745('0x6b')](_0x23d60e[_0x9745('0x7a')]);for(var _0x46eb30=0x0;_0x46eb30<_0x399886[_0x9745('0x2e')];_0x46eb30+=0x1){_0x2b8523=_0x399886[_0x46eb30]['MetricId']?_0x220696[_0x399886[_0x46eb30][_0x9745('0x85')]]['metric']:_0x399886[_0x46eb30][_0x9745('0x38')];_0x2b8523=_0x399886[_0x46eb30][_0x9745('0x6d')]?_[_0x9745('0x6f')](_0x73b2f2[_0x399886[_0x46eb30][_0x9745('0x6d')]],'%s',_0x2b8523):_0x2b8523;_0x2b8523=_0x399886[_0x46eb30][_0x9745('0x6e')]?_['replace'](_0x42ee73[_0x399886[_0x46eb30][_0x9745('0x6e')]],'%s',_0x2b8523):_0x2b8523;if(_0x399886[_0x46eb30][_0x9745('0x70')]){_0x17d3f9['group'](_0x2b8523);}_0x399886[_0x46eb30][_0x9745('0x71')]&&_0x17d3f9[_0x9745('0x30')](_0x2b8523,_0x399886[_0x46eb30][_0x9745('0x71')]===_0x9745('0x72')?![]:!![]);_0x17d3f9[_0x9745('0x38')](_0x2b8523,_0x399886[_0x46eb30][_0x9745('0x73')]||_0x2b8523);}if(_0x23d60e['joins']){_0x23d60e[_0x9745('0x74')]=JSON[_0x9745('0x75')](_0x23d60e[_0x9745('0x74')]);for(var _0xd4abab=0x0;_0xd4abab<_0x23d60e['joins']['length'];_0xd4abab+=0x1){if(_0x23d60e['joins'][_0xd4abab][_0x9745('0x36')]&&_['includes'](_0x6e0f95,_0x23d60e[_0x9745('0x74')][_0xd4abab][_0x9745('0x36')])&&_0x23d60e[_0x9745('0x74')][_0xd4abab]['parentKey']&&_0x23d60e[_0x9745('0x74')][_0xd4abab][_0x9745('0x77')]&&_0x23d60e['joins'][_0xd4abab]['foreignKey']){_0x17d3f9[_0x23d60e['joins'][_0xd4abab][_0x9745('0x36')]](_0x23d60e[_0x9745('0x74')][_0xd4abab]['foreignTable'],null,util[_0x9745('0x6e')](_0x9745('0x79'),_0x23d60e[_0x9745('0x7a')],_0x23d60e['joins'][_0xd4abab][_0x9745('0x76')],_0x23d60e[_0x9745('0x74')][_0xd4abab][_0x9745('0x77')],_0x23d60e[_0x9745('0x74')][_0xd4abab][_0x9745('0x78')]));}}}if(_0x23d60e[_0x9745('0x7b')]){_0x23d60e[_0x9745('0x7b')]=JSON[_0x9745('0x75')](_0x23d60e[_0x9745('0x7b')]);_0x17d3f9[_0x9745('0x32')](_0x4d3498(_0x23d60e['conditions'][_0x9745('0x61')]));}_0x51c63e=_0x17d3f9[_0x9745('0x86')]();_0x17d3f9[_0x9745('0x1b')](_0x26f687);_0x17d3f9[_0x9745('0x1a')](0x0);logger['debug'](_0x9745('0x7d'),_0x17d3f9[_0x9745('0x7e')]());return db[_0x9745('0x7f')][_0x9745('0x2b')](_0x17d3f9['toString'](),{'type':db[_0x9745('0x7f')]['QueryTypes'][_0x9745('0x80')]});}})[_0x9745('0x20')](function(){return{'sql':_0x51c63e[_0x9745('0x7e')]()};})[_0x9745('0x20')](respondWithResult(_0x2e200c,null))[_0x9745('0x42')](handleError(_0x2e200c,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff