// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x4e75=['attributes','intersection','fields','length','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','VIRTUAL','options','includeAll','include','findAll','rows','keys','catch','create','body','user','Reports','UserProfileSection','find','DefaultReports','params','preview','join','left_join','right_join','cross_join','COUNT(%s)','MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','DATE(%s)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','operator','rules','group','field','condition','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','select','MetricId','metric','function','format','groupBy','orderBy','DESC','alias','joins','parentKey','foreignKey','foreignTable','table','conditions','parse','clone','sequelize','QueryTypes','SELECT','SUM(%s)','GROUP_CONCAT(%s)','SEC_TO_TIME(%s)','value','keyBy','replace','%s.%s\x20=\x20%s.%s','debug','Limited\x20Query:','toString','No\x20available\x20data','fullPath','%s-%s.%s','randomstring','generate','output','csv','default','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','endDate','child_process','savename','COUNT(*)','run','runReport','COUNT(DISTINCT\x20%s)','from','html-pdf','fast-json-patch','bluebird','mustache','path','sox','to-csv','ejs','lodash','crypto','jsforce','desk.js','papaparse','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','dbH','status','json','count','offset','limit','reject','save','update','then','destroy','get','UserProfileResource','sendStatus','error','stack','name','send','index','map','AnalyticDefaultReport','rawAttributes','fieldName','type','key','model','query','filters'];(function(_0x5e96a6,_0x30e673){var _0x249082=function(_0x1b4ebc){while(--_0x1b4ebc){_0x5e96a6['push'](_0x5e96a6['shift']());}};_0x249082(++_0x30e673);}(_0x4e75,0x107));var _0x54e7=function(_0x253a4c,_0x18114c){_0x253a4c=_0x253a4c-0x0;var _0x194adb=_0x4e75[_0x253a4c];return _0x194adb;};'use strict';var pdf=require(_0x54e7('0x0'));var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0x54e7('0x1'));var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0x54e7('0x2'));var Mustache=require(_0x54e7('0x3'));var util=require('util');var path=require(_0x54e7('0x4'));var sox=require(_0x54e7('0x5'));var csv=require(_0x54e7('0x6'));var ejs=require(_0x54e7('0x7'));var fs=require('fs');var _=require(_0x54e7('0x8'));var squel=require('squel');var crypto=require(_0x54e7('0x9'));var jsforce=require(_0x54e7('0xa'));var deskjs=require(_0x54e7('0xb'));var toCsv=require(_0x54e7('0x6'));var querystring=require('querystring');var Papa=require(_0x54e7('0xc'));var Redis=require('ioredis');var authService=require(_0x54e7('0xd'));var qs=require('../../components/parsers/qs');var as=require(_0x54e7('0xe'));var hardwareService=require(_0x54e7('0xf'));var logger=require('../../config/logger')(_0x54e7('0x10'));var utils=require(_0x54e7('0x11'));var config=require(_0x54e7('0x12'));var licenseUtil=require(_0x54e7('0x13'));var db=require('../../mysqldb')['db'];var dbH=require(_0x54e7('0x14'))[_0x54e7('0x15')];function respondWithStatusCode(_0x4663ba,_0x2d217e){_0x2d217e=_0x2d217e||0xcc;return function(_0x515532){if(_0x515532){return _0x4663ba['sendStatus'](_0x2d217e);}return _0x4663ba[_0x54e7('0x16')](_0x2d217e)['end']();};}function respondWithResult(_0xeb2d38,_0x21bdbd){_0x21bdbd=_0x21bdbd||0xc8;return function(_0x59c19c){if(_0x59c19c){return _0xeb2d38['status'](_0x21bdbd)[_0x54e7('0x17')](_0x59c19c);}};}function respondWithFilteredResult(_0x5784dd,_0x5167fc){return function(_0xf851af){if(_0xf851af){var _0xa4d3c0=_0xf851af[_0x54e7('0x18')],_0x48866d=_0x5167fc['offset'],_0x3153f7=_0x5167fc[_0x54e7('0x19')]+_0x5167fc[_0x54e7('0x1a')],_0x2e1702;if(_0x3153f7>=_0xa4d3c0){_0x3153f7=_0xa4d3c0;_0x2e1702=0xc8;}else{_0x2e1702=0xce;}_0x5784dd[_0x54e7('0x16')](_0x2e1702);return _0x5784dd['set']('Content-Range',_0x48866d+'-'+_0x3153f7+'/'+_0xa4d3c0)[_0x54e7('0x17')](_0xf851af);}return null;};}function patchUpdates(_0x2c22a4){return function(_0x52784a){try{jsonpatch['apply'](_0x52784a,_0x2c22a4,!![]);}catch(_0x565aa4){return BPromise[_0x54e7('0x1b')](_0x565aa4);}return _0x52784a[_0x54e7('0x1c')]();};}function saveUpdates(_0x1ff379,_0x5a5074){return function(_0x1c93b5){if(_0x1c93b5){return _0x1c93b5[_0x54e7('0x1d')](_0x1ff379)[_0x54e7('0x1e')](function(_0x424311){return _0x424311;});}return null;};}function removeEntity(_0x351b0a,_0x1b9473){return function(_0x52aeb5){if(_0x52aeb5){return _0x52aeb5[_0x54e7('0x1f')]()[_0x54e7('0x1e')](function(){var _0x2a434a=_0x52aeb5[_0x54e7('0x20')]({'plain':!![]});var _0x28a0e1='DefaultReports';return db[_0x54e7('0x21')][_0x54e7('0x1f')]({'where':{'type':_0x28a0e1,'resourceId':_0x2a434a['id']}})[_0x54e7('0x1e')](function(){return _0x52aeb5;});})[_0x54e7('0x1e')](function(){_0x351b0a['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x9206eb,_0x40ce03){return function(_0x4df8ed){if(!_0x4df8ed){_0x9206eb[_0x54e7('0x22')](0x194);}return _0x4df8ed;};}function handleError(_0x35808c,_0x4277b1){_0x4277b1=_0x4277b1||0x1f4;return function(_0x175db6){logger[_0x54e7('0x23')](_0x175db6[_0x54e7('0x24')]);if(_0x175db6['name']){delete _0x175db6[_0x54e7('0x25')];}_0x35808c[_0x54e7('0x16')](_0x4277b1)[_0x54e7('0x26')](_0x175db6);};}exports[_0x54e7('0x27')]=function(_0x3c7394,_0x7b74ab){var _0x26b312={},_0x278f09={},_0x3c531c={'count':0x0,'rows':[]};var _0x6473ca=_[_0x54e7('0x28')](db[_0x54e7('0x29')][_0x54e7('0x2a')],function(_0x354c30){return{'name':_0x354c30[_0x54e7('0x2b')],'type':_0x354c30[_0x54e7('0x2c')][_0x54e7('0x2d')]};});_0x278f09[_0x54e7('0x2e')]=_['map'](_0x6473ca,_0x54e7('0x25'));_0x278f09[_0x54e7('0x2f')]=_['keys'](_0x3c7394['query']);_0x278f09[_0x54e7('0x30')]=_['intersection'](_0x278f09[_0x54e7('0x2e')],_0x278f09[_0x54e7('0x2f')]);_0x26b312[_0x54e7('0x31')]=_[_0x54e7('0x32')](_0x278f09[_0x54e7('0x2e')],qs[_0x54e7('0x33')](_0x3c7394[_0x54e7('0x2f')][_0x54e7('0x33')]));_0x26b312[_0x54e7('0x31')]=_0x26b312['attributes'][_0x54e7('0x34')]?_0x26b312[_0x54e7('0x31')]:_0x278f09['model'];if(!_0x3c7394['query'][_0x54e7('0x35')](_0x54e7('0x36'))){_0x26b312[_0x54e7('0x1a')]=qs[_0x54e7('0x1a')](_0x3c7394[_0x54e7('0x2f')][_0x54e7('0x1a')]);_0x26b312[_0x54e7('0x19')]=qs['offset'](_0x3c7394['query']['offset']);}_0x26b312[_0x54e7('0x37')]=qs[_0x54e7('0x38')](_0x3c7394[_0x54e7('0x2f')][_0x54e7('0x38')]);_0x26b312['where']=qs[_0x54e7('0x30')](_[_0x54e7('0x39')](_0x3c7394['query'],_0x278f09['filters']),_0x6473ca);if(_0x3c7394['query'][_0x54e7('0x3a')]){_0x26b312[_0x54e7('0x3b')]=_[_0x54e7('0x3c')](_0x26b312[_0x54e7('0x3b')],{'$or':_['map'](_0x6473ca,function(_0x5aa066){if(_0x5aa066[_0x54e7('0x2c')]!==_0x54e7('0x3d')){var _0x5448c7={};_0x5448c7[_0x5aa066[_0x54e7('0x25')]]={'$like':'%'+_0x3c7394[_0x54e7('0x2f')]['filter']+'%'};return _0x5448c7;}})});}_0x26b312=_[_0x54e7('0x3c')]({},_0x26b312,_0x3c7394[_0x54e7('0x3e')]);var _0xcfd4ce={'where':_0x26b312[_0x54e7('0x3b')]};return db[_0x54e7('0x29')]['count'](_0xcfd4ce)['then'](function(_0x35604a){_0x3c531c[_0x54e7('0x18')]=_0x35604a;if(_0x3c7394[_0x54e7('0x2f')][_0x54e7('0x3f')]){_0x26b312[_0x54e7('0x40')]=[{'all':!![]}];}return db[_0x54e7('0x29')][_0x54e7('0x41')](_0x26b312);})[_0x54e7('0x1e')](function(_0x39c876){_0x3c531c[_0x54e7('0x42')]=_0x39c876;return _0x3c531c;})[_0x54e7('0x1e')](respondWithFilteredResult(_0x7b74ab,_0x26b312))['catch'](handleError(_0x7b74ab,null));};exports['show']=function(_0x10909d,_0x56dccb){var _0x80be42={'raw':!![],'where':{'id':_0x10909d['params']['id']}},_0x5470f6={};_0x5470f6[_0x54e7('0x2e')]=_[_0x54e7('0x43')](db['AnalyticDefaultReport'][_0x54e7('0x2a')]);_0x5470f6[_0x54e7('0x2f')]=_[_0x54e7('0x43')](_0x10909d[_0x54e7('0x2f')]);_0x5470f6['filtears']=_[_0x54e7('0x32')](_0x5470f6[_0x54e7('0x2e')],_0x5470f6[_0x54e7('0x2f')]);_0x80be42[_0x54e7('0x31')]=_['intersection'](_0x5470f6[_0x54e7('0x2e')],qs['fields'](_0x10909d['query'][_0x54e7('0x33')]));_0x80be42[_0x54e7('0x31')]=_0x80be42[_0x54e7('0x31')][_0x54e7('0x34')]?_0x80be42[_0x54e7('0x31')]:_0x5470f6[_0x54e7('0x2e')];if(_0x10909d[_0x54e7('0x2f')][_0x54e7('0x3f')]){_0x80be42[_0x54e7('0x40')]=[{'all':!![]}];}_0x80be42=_['merge']({},_0x80be42,_0x10909d['options']);return db[_0x54e7('0x29')]['find'](_0x80be42)[_0x54e7('0x1e')](handleEntityNotFound(_0x56dccb,null))[_0x54e7('0x1e')](respondWithResult(_0x56dccb,null))[_0x54e7('0x44')](handleError(_0x56dccb,null));};exports[_0x54e7('0x45')]=function(_0x131e83,_0xe36db6){return db['AnalyticDefaultReport'][_0x54e7('0x45')](_0x131e83[_0x54e7('0x46')],{})[_0x54e7('0x1e')](function(_0x5845d3){var _0x3e2c49=_0x131e83['user'][_0x54e7('0x20')]({'plain':!![]});if(!_0x3e2c49)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x3e2c49['role']===_0x54e7('0x47')){var _0x32b8d0=_0x5845d3[_0x54e7('0x20')]({'plain':!![]});var _0x382f4c=_0x54e7('0x48');return db[_0x54e7('0x49')][_0x54e7('0x4a')]({'where':{'name':_0x382f4c,'userProfileId':_0x3e2c49['userProfileId']},'raw':!![]})['then'](function(_0x32fe5d){if(_0x32fe5d&&_0x32fe5d['autoAssociation']===0x0){return db['UserProfileResource'][_0x54e7('0x45')]({'name':_0x32b8d0[_0x54e7('0x25')],'resourceId':_0x32b8d0['id'],'type':_0x54e7('0x4b'),'sectionId':_0x32fe5d['id']},{})['then'](function(){return _0x5845d3;});}else{return _0x5845d3;}})[_0x54e7('0x44')](function(_0x38ec86){logger[_0x54e7('0x23')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x38ec86);throw _0x38ec86;});}return _0x5845d3;})[_0x54e7('0x1e')](respondWithResult(_0xe36db6,0xc9))[_0x54e7('0x44')](handleError(_0xe36db6,null));};exports['update']=function(_0x37ffba,_0x317ffc){if(_0x37ffba[_0x54e7('0x46')]['id']){delete _0x37ffba[_0x54e7('0x46')]['id'];}return db[_0x54e7('0x29')]['find']({'where':{'id':_0x37ffba['params']['id']}})[_0x54e7('0x1e')](handleEntityNotFound(_0x317ffc,null))[_0x54e7('0x1e')](saveUpdates(_0x37ffba[_0x54e7('0x46')],null))[_0x54e7('0x1e')](respondWithResult(_0x317ffc,null))[_0x54e7('0x44')](handleError(_0x317ffc,null));};exports[_0x54e7('0x1f')]=function(_0x2e441e,_0x101092){return db[_0x54e7('0x29')][_0x54e7('0x4a')]({'where':{'id':_0x2e441e[_0x54e7('0x4c')]['id']}})[_0x54e7('0x1e')](handleEntityNotFound(_0x101092,null))['then'](removeEntity(_0x101092,null))['catch'](handleError(_0x101092,null));};exports[_0x54e7('0x4d')]=function(_0xa1dbc3,_0x36b823){var _0x180503=0xa;var _0x139810=[_0x54e7('0x4e'),_0x54e7('0x4f'),_0x54e7('0x50'),_0x54e7('0x51')];var _0x579af4={'SUM':'SUM(%s)','COUNT':_0x54e7('0x52'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x54e7('0x53'),'MIN':_0x54e7('0x54'),'AVG':_0x54e7('0x55'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x54e7('0x56'),'GROUP_CONCAT DESC':_0x54e7('0x57')};var _0x38908e={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x54e7('0x58'),'HOUR':_0x54e7('0x59'),'ROUND':_0x54e7('0x5a'),'UNIX_TIMESTAMP':_0x54e7('0x5b')};var _0x59aac5=function(_0x394e1d){return!_[_0x54e7('0x5c')]([_0x54e7('0x5d'),_0x54e7('0x5e'),_0x54e7('0x5f'),_0x54e7('0x60')],_0x394e1d);};var _0x9c182f=function(_0x2e38e5){if(!_0x2e38e5||!_0x2e38e5['rules']['length']){return'';}for(var _0x3fceb7='(',_0x257b49=0x0;_0x257b49<_0x2e38e5['rules'][_0x54e7('0x34')];_0x257b49+=0x1){_0x257b49>0x0&&(_0x3fceb7+='\x20'+_0x2e38e5[_0x54e7('0x61')]+'\x20');_0x3fceb7+=_0x2e38e5[_0x54e7('0x62')][_0x257b49][_0x54e7('0x63')]?_0x9c182f(_0x2e38e5['rules'][_0x257b49][_0x54e7('0x63')]):_0x2e38e5[_0x54e7('0x62')][_0x257b49][_0x54e7('0x64')]+'\x20'+_0x2e38e5[_0x54e7('0x62')][_0x257b49][_0x54e7('0x65')]+(_0x59aac5(_0x2e38e5[_0x54e7('0x62')][_0x257b49][_0x54e7('0x65')])?'\x20'+_0x2e38e5[_0x54e7('0x62')][_0x257b49]['value']:'');}return _0x3fceb7+')';};var _0x32f905={'where':{'id':_0xa1dbc3['params']['id']}},_0x43867e,_0x5a2940,_0xaf9ef9,_0x356710,_0x46ff12;_0x32f905=_[_0x54e7('0x3c')]({},_0x32f905,_0xa1dbc3[_0x54e7('0x3e')]);return db[_0x54e7('0x29')][_0x54e7('0x4a')](_0x32f905)['then'](function(_0x67c1c6){if(_0x67c1c6){_0x43867e=_0x67c1c6;return _0x67c1c6[_0x54e7('0x66')]();}return null;})[_0x54e7('0x1e')](function(_0x1836ac){if(_0x1836ac){if(!_0x1836ac[_0x54e7('0x34')]){throw new db[(_0x54e7('0x67'))][(_0x54e7('0x68'))](_0x54e7('0x69'),0x193);}_0x5a2940=_0x1836ac;return db[_0x54e7('0x6a')][_0x54e7('0x41')]({'raw':!![]});}return null;})['then'](function(_0x274bc1){if(_0x274bc1){_0xaf9ef9=_['keyBy'](_0x274bc1,'id');var _0x55f5fa;var _0x2c2e07=squel[_0x54e7('0x6b')]();_0x2c2e07['from'](_0x43867e['table']);for(var _0x13028c=0x0;_0x13028c<_0x5a2940[_0x54e7('0x34')];_0x13028c+=0x1){_0x55f5fa=_0x5a2940[_0x13028c][_0x54e7('0x6c')]?_0xaf9ef9[_0x5a2940[_0x13028c][_0x54e7('0x6c')]][_0x54e7('0x6d')]:_0x5a2940[_0x13028c][_0x54e7('0x64')];_0x55f5fa=_0x5a2940[_0x13028c]['function']?_['replace'](_0x579af4[_0x5a2940[_0x13028c][_0x54e7('0x6e')]],'%s',_0x55f5fa):_0x55f5fa;_0x55f5fa=_0x5a2940[_0x13028c]['format']?_['replace'](_0x38908e[_0x5a2940[_0x13028c][_0x54e7('0x6f')]],'%s',_0x55f5fa):_0x55f5fa;if(_0x5a2940[_0x13028c][_0x54e7('0x70')]){_0x2c2e07[_0x54e7('0x63')](_0x55f5fa);}_0x5a2940[_0x13028c][_0x54e7('0x71')]&&_0x2c2e07[_0x54e7('0x37')](_0x55f5fa,_0x5a2940[_0x13028c][_0x54e7('0x71')]===_0x54e7('0x72')?![]:!![]);_0x2c2e07[_0x54e7('0x64')](_0x55f5fa,_0x5a2940[_0x13028c][_0x54e7('0x73')]||_0x55f5fa);}if(_0x43867e[_0x54e7('0x74')]){_0x43867e['joins']=JSON['parse'](_0x43867e[_0x54e7('0x74')]);for(var _0x2f985b=0x0;_0x2f985b<_0x43867e[_0x54e7('0x74')][_0x54e7('0x34')];_0x2f985b+=0x1){if(_0x43867e[_0x54e7('0x74')][_0x2f985b][_0x54e7('0x2c')]&&_[_0x54e7('0x5c')](_0x139810,_0x43867e[_0x54e7('0x74')][_0x2f985b][_0x54e7('0x2c')])&&_0x43867e[_0x54e7('0x74')][_0x2f985b][_0x54e7('0x75')]&&_0x43867e[_0x54e7('0x74')][_0x2f985b]['foreignTable']&&_0x43867e[_0x54e7('0x74')][_0x2f985b][_0x54e7('0x76')]){_0x2c2e07[_0x43867e[_0x54e7('0x74')][_0x2f985b][_0x54e7('0x2c')]](_0x43867e[_0x54e7('0x74')][_0x2f985b][_0x54e7('0x77')],null,util[_0x54e7('0x6f')]('%s.%s\x20=\x20%s.%s',_0x43867e[_0x54e7('0x78')],_0x43867e['joins'][_0x2f985b][_0x54e7('0x75')],_0x43867e['joins'][_0x2f985b]['foreignTable'],_0x43867e['joins'][_0x2f985b][_0x54e7('0x76')]));}}}if(_0x43867e['conditions']){_0x43867e[_0x54e7('0x79')]=JSON[_0x54e7('0x7a')](_0x43867e[_0x54e7('0x79')]);_0x2c2e07[_0x54e7('0x3b')](_0x9c182f(_0x43867e[_0x54e7('0x79')][_0x54e7('0x63')]));}_0x46ff12=_0x2c2e07[_0x54e7('0x7b')]();_0x2c2e07[_0x54e7('0x1a')](_0x180503);_0x2c2e07[_0x54e7('0x19')](0x0);logger['debug']('Limited\x20Query:',_0x2c2e07['toString']());return db[_0x54e7('0x7c')][_0x54e7('0x2f')](_0x2c2e07['toString'](),{'type':db[_0x54e7('0x7c')][_0x54e7('0x7d')][_0x54e7('0x7e')]});}})[_0x54e7('0x1e')](respondWithResult(_0x36b823,null))['catch'](handleError(_0x36b823,null));};function runReport(_0x2f29a8,_0x4477e2,_0x38e103){var _0x282b0a=_0x4477e2[_0x54e7('0x25')];var _0x5ea15a=0xa;var _0x31c3d1=[_0x54e7('0x4e'),'left_join','right_join',_0x54e7('0x51')];var _0x5f1bbf={'SUM':_0x54e7('0x7f'),'COUNT':'COUNT(%s)','COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x54e7('0x53'),'MIN':_0x54e7('0x54'),'AVG':_0x54e7('0x55'),'GROUP_CONCAT':_0x54e7('0x80'),'GROUP_CONCAT ASC':_0x54e7('0x56'),'GROUP_CONCAT DESC':_0x54e7('0x57')};var _0x510c8b={'SEC_TO_TIME':_0x54e7('0x81'),'DATE':'DATE(%s)','HOUR':_0x54e7('0x59'),'ROUND':_0x54e7('0x5a'),'UNIX_TIMESTAMP':_0x54e7('0x5b')};var _0x11f358=function(_0x20917b){return!_['includes'](['IS\x20NULL',_0x54e7('0x5e'),_0x54e7('0x5f'),_0x54e7('0x60')],_0x20917b);};var _0x4e03a9=function(_0x4cd03d){if(!_0x4cd03d||!_0x4cd03d[_0x54e7('0x62')]['length']){return'';}for(var _0x345150='(',_0x514c21=0x0;_0x514c21<_0x4cd03d[_0x54e7('0x62')][_0x54e7('0x34')];_0x514c21+=0x1){_0x514c21>0x0&&(_0x345150+='\x20'+_0x4cd03d['operator']+'\x20');_0x345150+=_0x4cd03d[_0x54e7('0x62')][_0x514c21][_0x54e7('0x63')]?_0x4e03a9(_0x4cd03d[_0x54e7('0x62')][_0x514c21][_0x54e7('0x63')]):_0x4cd03d['rules'][_0x514c21]['field']+'\x20'+_0x4cd03d[_0x54e7('0x62')][_0x514c21][_0x54e7('0x65')]+(_0x11f358(_0x4cd03d[_0x54e7('0x62')][_0x514c21][_0x54e7('0x65')])?'\x20'+_0x4cd03d['rules'][_0x514c21][_0x54e7('0x82')]:'');}return _0x345150+')';};var _0x23f2f6={'where':{'id':_0x2f29a8['id']}},_0x5c3594,_0x1d6c2c,_0x39e653,_0x9d61f0,_0x37da8d;_0x23f2f6=_['merge']({},_0x23f2f6,_0x38e103);return db[_0x54e7('0x29')][_0x54e7('0x4a')](_0x23f2f6)['then'](function(_0xff2b86){if(_0xff2b86){_0x5c3594=_0xff2b86;return _0xff2b86[_0x54e7('0x66')]();}return null;})['then'](function(_0x5886e9){if(_0x5886e9){if(!_0x5886e9[_0x54e7('0x34')]){throw new db[(_0x54e7('0x67'))][(_0x54e7('0x68'))](_0x54e7('0x69'),0x193);}_0x1d6c2c=_0x5886e9;return db[_0x54e7('0x6a')][_0x54e7('0x41')]({'raw':!![]});}return null;})[_0x54e7('0x1e')](function(_0x2f7534){if(_0x2f7534){_0x39e653=_[_0x54e7('0x83')](_0x2f7534,'id');var _0x499e6f;var _0x2818af=squel[_0x54e7('0x6b')]();_0x2818af['from'](_0x5c3594['table']);for(var _0x5269f7=0x0;_0x5269f7<_0x1d6c2c[_0x54e7('0x34')];_0x5269f7+=0x1){_0x499e6f=_0x1d6c2c[_0x5269f7][_0x54e7('0x6c')]?_0x39e653[_0x1d6c2c[_0x5269f7]['MetricId']][_0x54e7('0x6d')]:_0x1d6c2c[_0x5269f7]['field'];_0x499e6f=_0x1d6c2c[_0x5269f7][_0x54e7('0x6e')]?_[_0x54e7('0x84')](_0x5f1bbf[_0x1d6c2c[_0x5269f7]['function']],'%s',_0x499e6f):_0x499e6f;_0x499e6f=_0x1d6c2c[_0x5269f7][_0x54e7('0x6f')]?_['replace'](_0x510c8b[_0x1d6c2c[_0x5269f7][_0x54e7('0x6f')]],'%s',_0x499e6f):_0x499e6f;if(_0x1d6c2c[_0x5269f7][_0x54e7('0x70')]){_0x2818af[_0x54e7('0x63')](_0x499e6f);}_0x1d6c2c[_0x5269f7][_0x54e7('0x71')]&&_0x2818af[_0x54e7('0x37')](_0x499e6f,_0x1d6c2c[_0x5269f7][_0x54e7('0x71')]===_0x54e7('0x72')?![]:!![]);_0x2818af['field'](_0x499e6f,_0x1d6c2c[_0x5269f7][_0x54e7('0x73')]||_0x499e6f);}if(_0x5c3594[_0x54e7('0x74')]){_0x5c3594[_0x54e7('0x74')]=JSON[_0x54e7('0x7a')](_0x5c3594['joins']);for(var _0x547e85=0x0;_0x547e85<_0x5c3594['joins'][_0x54e7('0x34')];_0x547e85+=0x1){if(_0x5c3594[_0x54e7('0x74')][_0x547e85][_0x54e7('0x2c')]&&_[_0x54e7('0x5c')](_0x31c3d1,_0x5c3594[_0x54e7('0x74')][_0x547e85][_0x54e7('0x2c')])&&_0x5c3594['joins'][_0x547e85][_0x54e7('0x75')]&&_0x5c3594[_0x54e7('0x74')][_0x547e85][_0x54e7('0x77')]&&_0x5c3594[_0x54e7('0x74')][_0x547e85]['foreignKey']){_0x2818af[_0x5c3594[_0x54e7('0x74')][_0x547e85][_0x54e7('0x2c')]](_0x5c3594[_0x54e7('0x74')][_0x547e85][_0x54e7('0x77')],null,util[_0x54e7('0x6f')](_0x54e7('0x85'),_0x5c3594[_0x54e7('0x78')],_0x5c3594['joins'][_0x547e85][_0x54e7('0x75')],_0x5c3594['joins'][_0x547e85][_0x54e7('0x77')],_0x5c3594[_0x54e7('0x74')][_0x547e85]['foreignKey']));}}}if(_0x5c3594[_0x54e7('0x79')]){_0x5c3594[_0x54e7('0x79')]=JSON['parse'](_0x5c3594['conditions']);_0x2818af[_0x54e7('0x3b')](_0x4e03a9(_0x5c3594[_0x54e7('0x79')][_0x54e7('0x63')]));}_0x37da8d=_0x2818af[_0x54e7('0x7b')]();_0x2818af[_0x54e7('0x1a')](_0x5ea15a);_0x2818af[_0x54e7('0x19')](0x0);logger[_0x54e7('0x86')](_0x54e7('0x87'),_0x2818af[_0x54e7('0x88')]());return db[_0x54e7('0x7c')]['query'](_0x2818af[_0x54e7('0x88')](),{'type':db[_0x54e7('0x7c')]['QueryTypes'][_0x54e7('0x7e')]});}})[_0x54e7('0x1e')](function(_0x50881c){if(!_0x50881c[_0x54e7('0x34')]){throw new db[(_0x54e7('0x67'))]['ValidationErrorItem'](_0x54e7('0x89'),0xcc);}if(_0x4477e2['output']==='web'){return null;}var _0x115769=_[_0x54e7('0x3c')](_0x4477e2,{'name':_0x4477e2[_0x54e7('0x8a')]||_0x4477e2[_0x54e7('0x25')]||_0x5c3594['name'],'basename':_0x282b0a,'savename':util[_0x54e7('0x6f')](_0x54e7('0x8b'),_0x4477e2[_0x54e7('0x25')]||_0x5c3594[_0x54e7('0x25')],require(_0x54e7('0x8c'))[_0x54e7('0x8d')](0x4),_0x4477e2[_0x54e7('0x8e')]||_0x54e7('0x8f')),'reportId':_0x5c3594['id'],'reportType':_0x54e7('0x90')});return db['AnalyticExtractedReport'][_0x54e7('0x45')](_0x115769,{'raw':!![]});})[_0x54e7('0x1e')](function(_0x5e2746){if(_0x5c3594[_0x54e7('0x78')]==='cdr'){_0x37da8d[_0x54e7('0x3b')](_0x5c3594[_0x54e7('0x78')]+_0x54e7('0x91'),_0x4477e2[_0x54e7('0x92')],_0x4477e2['endDate']);}else{_0x37da8d[_0x54e7('0x3b')](_0x5c3594[_0x54e7('0x78')]+_0x54e7('0x93'),_0x4477e2[_0x54e7('0x92')],_0x4477e2[_0x54e7('0x94')]);}if(_0x5e2746){logger['info']('Run\x20Query:',_0x37da8d['toString']());require(_0x54e7('0x95'))['fork'](path[_0x54e7('0x4e')](__dirname,'../../components/export/',_0x5e2746[_0x54e7('0x8e')]),[_0x5e2746['id'],_0x37da8d[_0x54e7('0x88')](),path['join'](__dirname,'../../files/reports',_0x5e2746[_0x54e7('0x96')]),_0x282b0a]);return _0x5e2746;}else{var _0x444f7d=squel['select']();_0x444f7d['from']('('+_0x37da8d['toString']()+')','countTable');_0x444f7d['field'](_0x54e7('0x97'),_0x54e7('0x18'));_0x37da8d[_0x54e7('0x1a')](_0x4477e2['limit']||_0x5ea15a);_0x37da8d[_0x54e7('0x19')](_0x4477e2['offset']||0x0);return dbH[_0x54e7('0x7c')][_0x54e7('0x2f')](_0x444f7d['toString'](),{'type':dbH['sequelize']['QueryTypes'][_0x54e7('0x7e')]})[_0x54e7('0x1e')](function(_0x47d564){if(!_0x47d564[_0x54e7('0x34')]){_0x9d61f0=0x0;}else{_0x9d61f0=_0x47d564[0x0]['count']||0x0;}return dbH[_0x54e7('0x7c')][_0x54e7('0x2f')](_0x37da8d[_0x54e7('0x88')](),{'type':dbH[_0x54e7('0x7c')][_0x54e7('0x7d')][_0x54e7('0x7e')]});})['then'](function(_0x15a70a){return{'rows':_0x15a70a||[],'count':_0x9d61f0};});}});}exports[_0x54e7('0x98')]=function(_0x413cb6,_0x232a87){return runReport(_0x413cb6[_0x54e7('0x4c')],_0x413cb6[_0x54e7('0x2f')],_0x413cb6[_0x54e7('0x3e')])[_0x54e7('0x1e')](respondWithResult(_0x232a87,null))[_0x54e7('0x44')](handleError(_0x232a87,null));};exports[_0x54e7('0x99')]=runReport;exports[_0x54e7('0x2f')]=function(_0x3a380e,_0x3e20b1){var _0x5f02f4=0xa;var _0x53e44b=[_0x54e7('0x4e'),_0x54e7('0x4f'),_0x54e7('0x50'),_0x54e7('0x51')];var _0x3cddc2={'SUM':_0x54e7('0x7f'),'COUNT':_0x54e7('0x52'),'COUNT DISTINCT':_0x54e7('0x9a'),'MAX':_0x54e7('0x53'),'MIN':_0x54e7('0x54'),'AVG':_0x54e7('0x55'),'GROUP_CONCAT':_0x54e7('0x80'),'GROUP_CONCAT ASC':_0x54e7('0x56'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x1e1b53={'SEC_TO_TIME':_0x54e7('0x81'),'DATE':_0x54e7('0x58'),'HOUR':_0x54e7('0x59'),'ROUND':_0x54e7('0x5a'),'UNIX_TIMESTAMP':_0x54e7('0x5b')};var _0x5416a4=function(_0x1e825d){return!_['includes']([_0x54e7('0x5d'),_0x54e7('0x5e'),'IS\x20EMPTY',_0x54e7('0x60')],_0x1e825d);};var _0x23f9f5=function(_0x3ffe4a){if(!_0x3ffe4a||!_0x3ffe4a['rules'][_0x54e7('0x34')]){return'';}for(var _0x3bc062='(',_0x33b950=0x0;_0x33b950<_0x3ffe4a[_0x54e7('0x62')][_0x54e7('0x34')];_0x33b950+=0x1){_0x33b950>0x0&&(_0x3bc062+='\x20'+_0x3ffe4a[_0x54e7('0x61')]+'\x20');_0x3bc062+=_0x3ffe4a['rules'][_0x33b950][_0x54e7('0x63')]?_0x23f9f5(_0x3ffe4a[_0x54e7('0x62')][_0x33b950][_0x54e7('0x63')]):_0x3ffe4a[_0x54e7('0x62')][_0x33b950]['field']+'\x20'+_0x3ffe4a[_0x54e7('0x62')][_0x33b950][_0x54e7('0x65')]+(_0x5416a4(_0x3ffe4a[_0x54e7('0x62')][_0x33b950][_0x54e7('0x65')])?'\x20'+_0x3ffe4a['rules'][_0x33b950][_0x54e7('0x82')]:'');}return _0x3bc062+')';};var _0x1d7afa={'where':{'id':_0x3a380e[_0x54e7('0x4c')]['id']}},_0x4955c8,_0x5e25cd,_0x411687,_0x42e02e,_0x11d0ff;_0x1d7afa=_[_0x54e7('0x3c')]({},_0x1d7afa,_0x3a380e['options']);return db[_0x54e7('0x29')][_0x54e7('0x4a')](_0x1d7afa)[_0x54e7('0x1e')](function(_0x2e4f67){if(_0x2e4f67){_0x4955c8=_0x2e4f67;return _0x2e4f67[_0x54e7('0x66')]();}return null;})[_0x54e7('0x1e')](function(_0x1f1a3d){if(_0x1f1a3d){if(!_0x1f1a3d[_0x54e7('0x34')]){throw new db[(_0x54e7('0x67'))][(_0x54e7('0x68'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x5e25cd=_0x1f1a3d;return db[_0x54e7('0x6a')][_0x54e7('0x41')]({'raw':!![]});}return null;})[_0x54e7('0x1e')](function(_0x3fb911){if(_0x3fb911){_0x411687=_[_0x54e7('0x83')](_0x3fb911,'id');var _0x232229;var _0xc2685e=squel[_0x54e7('0x6b')]();_0xc2685e[_0x54e7('0x9b')](_0x4955c8[_0x54e7('0x78')]);for(var _0x23990b=0x0;_0x23990b<_0x5e25cd[_0x54e7('0x34')];_0x23990b+=0x1){_0x232229=_0x5e25cd[_0x23990b][_0x54e7('0x6c')]?_0x411687[_0x5e25cd[_0x23990b][_0x54e7('0x6c')]][_0x54e7('0x6d')]:_0x5e25cd[_0x23990b][_0x54e7('0x64')];_0x232229=_0x5e25cd[_0x23990b][_0x54e7('0x6e')]?_[_0x54e7('0x84')](_0x3cddc2[_0x5e25cd[_0x23990b][_0x54e7('0x6e')]],'%s',_0x232229):_0x232229;_0x232229=_0x5e25cd[_0x23990b]['format']?_[_0x54e7('0x84')](_0x1e1b53[_0x5e25cd[_0x23990b]['format']],'%s',_0x232229):_0x232229;if(_0x5e25cd[_0x23990b]['groupBy']){_0xc2685e['group'](_0x232229);}_0x5e25cd[_0x23990b][_0x54e7('0x71')]&&_0xc2685e[_0x54e7('0x37')](_0x232229,_0x5e25cd[_0x23990b][_0x54e7('0x71')]===_0x54e7('0x72')?![]:!![]);_0xc2685e[_0x54e7('0x64')](_0x232229,_0x5e25cd[_0x23990b][_0x54e7('0x73')]||_0x232229);}if(_0x4955c8[_0x54e7('0x74')]){_0x4955c8[_0x54e7('0x74')]=JSON[_0x54e7('0x7a')](_0x4955c8[_0x54e7('0x74')]);for(var _0x1db872=0x0;_0x1db872<_0x4955c8[_0x54e7('0x74')][_0x54e7('0x34')];_0x1db872+=0x1){if(_0x4955c8['joins'][_0x1db872][_0x54e7('0x2c')]&&_['includes'](_0x53e44b,_0x4955c8[_0x54e7('0x74')][_0x1db872][_0x54e7('0x2c')])&&_0x4955c8[_0x54e7('0x74')][_0x1db872][_0x54e7('0x75')]&&_0x4955c8[_0x54e7('0x74')][_0x1db872][_0x54e7('0x77')]&&_0x4955c8[_0x54e7('0x74')][_0x1db872][_0x54e7('0x76')]){_0xc2685e[_0x4955c8['joins'][_0x1db872][_0x54e7('0x2c')]](_0x4955c8[_0x54e7('0x74')][_0x1db872][_0x54e7('0x77')],null,util['format'](_0x54e7('0x85'),_0x4955c8[_0x54e7('0x78')],_0x4955c8[_0x54e7('0x74')][_0x1db872]['parentKey'],_0x4955c8[_0x54e7('0x74')][_0x1db872]['foreignTable'],_0x4955c8['joins'][_0x1db872][_0x54e7('0x76')]));}}}if(_0x4955c8[_0x54e7('0x79')]){_0x4955c8[_0x54e7('0x79')]=JSON[_0x54e7('0x7a')](_0x4955c8[_0x54e7('0x79')]);_0xc2685e[_0x54e7('0x3b')](_0x23f9f5(_0x4955c8[_0x54e7('0x79')]['group']));}_0x11d0ff=_0xc2685e[_0x54e7('0x7b')]();_0xc2685e[_0x54e7('0x1a')](_0x5f02f4);_0xc2685e[_0x54e7('0x19')](0x0);logger[_0x54e7('0x86')](_0x54e7('0x87'),_0xc2685e[_0x54e7('0x88')]());return db[_0x54e7('0x7c')][_0x54e7('0x2f')](_0xc2685e['toString'](),{'type':db[_0x54e7('0x7c')]['QueryTypes']['SELECT']});}})[_0x54e7('0x1e')](function(){return{'sql':_0x11d0ff[_0x54e7('0x88')]()};})['then'](respondWithResult(_0x3e20b1,null))[_0x54e7('0x44')](handleError(_0x3e20b1,null));};
\ No newline at end of file
+var _0xa3aa=['model','name','query','filters','attributes','intersection','fields','length','hasOwnProperty','nolimit','limit','order','sort','where','filter','merge','VIRTUAL','options','AnalyticDefaultReport','includeAll','findAll','rows','catch','show','params','filtears','include','find','create','body','user','role','Reports','UserProfileSection','userProfileId','autoAssociation','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','preview','join','right_join','cross_join','SUM(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%s)','GROUP_CONCAT(%s)','SEC_TO_TIME(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20NOT\x20EMPTY','rules','group','field','condition','value','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','select','from','table','MetricId','metric','function','replace','format','groupBy','orderBy','DESC','alias','joins','parse','parentKey','foreignTable','foreignKey','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','left_join','COUNT(%s)','AVG(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','IS\x20EMPTY','operator','%s.%s\x20=\x20%s.%s','No\x20available\x20data','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:','child_process','fork','../../components/export/','output','../../files/reports','savename','countTable','COUNT(*)','count','run','runReport','DATE(%s)','SELECT','eml-format','rimraf','fast-json-patch','request-promise','bluebird','mustache','util','path','ejs','crypto','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/environment','../../mysqldb','dbH','sendStatus','status','end','json','offset','Content-Range','save','update','then','destroy','get','DefaultReports','UserProfileResource','stack','send','index','map','rawAttributes','fieldName','type','key'];(function(_0x3002ab,_0x125f45){var _0x397753=function(_0x2c4675){while(--_0x2c4675){_0x3002ab['push'](_0x3002ab['shift']());}};_0x397753(++_0x125f45);}(_0xa3aa,0x127));var _0xaa3a=function(_0x179b25,_0x8d2b1){_0x179b25=_0x179b25-0x0;var _0x9c967a=_0xa3aa[_0x179b25];return _0x9c967a;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0xaa3a('0x0'));var rimraf=require(_0xaa3a('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xaa3a('0x2'));var rp=require(_0xaa3a('0x3'));var moment=require('moment');var BPromise=require(_0xaa3a('0x4'));var Mustache=require(_0xaa3a('0x5'));var util=require(_0xaa3a('0x6'));var path=require(_0xaa3a('0x7'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0xaa3a('0x8'));var fs=require('fs');var _=require('lodash');var squel=require('squel');var crypto=require(_0xaa3a('0x9'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0xaa3a('0xa'));var querystring=require(_0xaa3a('0xb'));var Papa=require(_0xaa3a('0xc'));var Redis=require(_0xaa3a('0xd'));var authService=require(_0xaa3a('0xe'));var qs=require(_0xaa3a('0xf'));var as=require(_0xaa3a('0x10'));var hardwareService=require(_0xaa3a('0x11'));var logger=require('../../config/logger')(_0xaa3a('0x12'));var utils=require('../../config/utils');var config=require(_0xaa3a('0x13'));var licenseUtil=require('../../config/license/util');var db=require(_0xaa3a('0x14'))['db'];var dbH=require(_0xaa3a('0x14'))[_0xaa3a('0x15')];function respondWithStatusCode(_0x5d705d,_0x3fb10e){_0x3fb10e=_0x3fb10e||0xcc;return function(_0x4dd628){if(_0x4dd628){return _0x5d705d[_0xaa3a('0x16')](_0x3fb10e);}return _0x5d705d[_0xaa3a('0x17')](_0x3fb10e)[_0xaa3a('0x18')]();};}function respondWithResult(_0x2b2976,_0x3bad6b){_0x3bad6b=_0x3bad6b||0xc8;return function(_0x573037){if(_0x573037){return _0x2b2976[_0xaa3a('0x17')](_0x3bad6b)[_0xaa3a('0x19')](_0x573037);}};}function respondWithFilteredResult(_0x3c6b3c,_0x2366e4){return function(_0x1669d8){if(_0x1669d8){var _0xa0685d=_0x1669d8['count'],_0x29dd4f=_0x2366e4['offset'],_0x2cf7d6=_0x2366e4[_0xaa3a('0x1a')]+_0x2366e4['limit'],_0x9f5c6d;if(_0x2cf7d6>=_0xa0685d){_0x2cf7d6=_0xa0685d;_0x9f5c6d=0xc8;}else{_0x9f5c6d=0xce;}_0x3c6b3c[_0xaa3a('0x17')](_0x9f5c6d);return _0x3c6b3c['set'](_0xaa3a('0x1b'),_0x29dd4f+'-'+_0x2cf7d6+'/'+_0xa0685d)[_0xaa3a('0x19')](_0x1669d8);}return null;};}function patchUpdates(_0x3a5b44){return function(_0x77bbd2){try{jsonpatch['apply'](_0x77bbd2,_0x3a5b44,!![]);}catch(_0x2ba85c){return BPromise['reject'](_0x2ba85c);}return _0x77bbd2[_0xaa3a('0x1c')]();};}function saveUpdates(_0x14c23f,_0x116e92){return function(_0x3d54a0){if(_0x3d54a0){return _0x3d54a0[_0xaa3a('0x1d')](_0x14c23f)[_0xaa3a('0x1e')](function(_0xa2f713){return _0xa2f713;});}return null;};}function removeEntity(_0xa4284b,_0x24e508){return function(_0x5134f8){if(_0x5134f8){return _0x5134f8[_0xaa3a('0x1f')]()[_0xaa3a('0x1e')](function(){var _0x5e06af=_0x5134f8[_0xaa3a('0x20')]({'plain':!![]});var _0x38c656=_0xaa3a('0x21');return db[_0xaa3a('0x22')][_0xaa3a('0x1f')]({'where':{'type':_0x38c656,'resourceId':_0x5e06af['id']}})['then'](function(){return _0x5134f8;});})['then'](function(){_0xa4284b[_0xaa3a('0x17')](0xcc)[_0xaa3a('0x18')]();});}};}function handleEntityNotFound(_0x145b91,_0x484066){return function(_0x5afa89){if(!_0x5afa89){_0x145b91['sendStatus'](0x194);}return _0x5afa89;};}function handleError(_0x5b1890,_0x5e4f80){_0x5e4f80=_0x5e4f80||0x1f4;return function(_0x405a82){logger['error'](_0x405a82[_0xaa3a('0x23')]);if(_0x405a82['name']){delete _0x405a82['name'];}_0x5b1890[_0xaa3a('0x17')](_0x5e4f80)[_0xaa3a('0x24')](_0x405a82);};}exports[_0xaa3a('0x25')]=function(_0x4753e2,_0x2b805c){var _0x165b3f={},_0x3e91c7={},_0x2bbcf0={'count':0x0,'rows':[]};var _0xf8a69a=_[_0xaa3a('0x26')](db['AnalyticDefaultReport'][_0xaa3a('0x27')],function(_0x579115){return{'name':_0x579115[_0xaa3a('0x28')],'type':_0x579115[_0xaa3a('0x29')][_0xaa3a('0x2a')]};});_0x3e91c7[_0xaa3a('0x2b')]=_[_0xaa3a('0x26')](_0xf8a69a,_0xaa3a('0x2c'));_0x3e91c7[_0xaa3a('0x2d')]=_['keys'](_0x4753e2['query']);_0x3e91c7[_0xaa3a('0x2e')]=_['intersection'](_0x3e91c7[_0xaa3a('0x2b')],_0x3e91c7[_0xaa3a('0x2d')]);_0x165b3f[_0xaa3a('0x2f')]=_[_0xaa3a('0x30')](_0x3e91c7[_0xaa3a('0x2b')],qs[_0xaa3a('0x31')](_0x4753e2[_0xaa3a('0x2d')][_0xaa3a('0x31')]));_0x165b3f[_0xaa3a('0x2f')]=_0x165b3f[_0xaa3a('0x2f')][_0xaa3a('0x32')]?_0x165b3f['attributes']:_0x3e91c7[_0xaa3a('0x2b')];if(!_0x4753e2['query'][_0xaa3a('0x33')](_0xaa3a('0x34'))){_0x165b3f[_0xaa3a('0x35')]=qs['limit'](_0x4753e2[_0xaa3a('0x2d')][_0xaa3a('0x35')]);_0x165b3f[_0xaa3a('0x1a')]=qs[_0xaa3a('0x1a')](_0x4753e2[_0xaa3a('0x2d')]['offset']);}_0x165b3f[_0xaa3a('0x36')]=qs['sort'](_0x4753e2[_0xaa3a('0x2d')][_0xaa3a('0x37')]);_0x165b3f[_0xaa3a('0x38')]=qs[_0xaa3a('0x2e')](_['pick'](_0x4753e2[_0xaa3a('0x2d')],_0x3e91c7[_0xaa3a('0x2e')]),_0xf8a69a);if(_0x4753e2[_0xaa3a('0x2d')][_0xaa3a('0x39')]){_0x165b3f['where']=_[_0xaa3a('0x3a')](_0x165b3f[_0xaa3a('0x38')],{'$or':_[_0xaa3a('0x26')](_0xf8a69a,function(_0x3a1f80){if(_0x3a1f80['type']!==_0xaa3a('0x3b')){var _0x35dd4b={};_0x35dd4b[_0x3a1f80[_0xaa3a('0x2c')]]={'$like':'%'+_0x4753e2['query']['filter']+'%'};return _0x35dd4b;}})});}_0x165b3f=_[_0xaa3a('0x3a')]({},_0x165b3f,_0x4753e2[_0xaa3a('0x3c')]);var _0x361655={'where':_0x165b3f[_0xaa3a('0x38')]};return db[_0xaa3a('0x3d')]['count'](_0x361655)[_0xaa3a('0x1e')](function(_0x2d723d){_0x2bbcf0['count']=_0x2d723d;if(_0x4753e2[_0xaa3a('0x2d')][_0xaa3a('0x3e')]){_0x165b3f['include']=[{'all':!![]}];}return db[_0xaa3a('0x3d')][_0xaa3a('0x3f')](_0x165b3f);})[_0xaa3a('0x1e')](function(_0x535544){_0x2bbcf0[_0xaa3a('0x40')]=_0x535544;return _0x2bbcf0;})[_0xaa3a('0x1e')](respondWithFilteredResult(_0x2b805c,_0x165b3f))[_0xaa3a('0x41')](handleError(_0x2b805c,null));};exports[_0xaa3a('0x42')]=function(_0x63516e,_0x2cca5b){var _0x41f4ed={'raw':!![],'where':{'id':_0x63516e[_0xaa3a('0x43')]['id']}},_0x367ca9={};_0x367ca9[_0xaa3a('0x2b')]=_['keys'](db['AnalyticDefaultReport'][_0xaa3a('0x27')]);_0x367ca9[_0xaa3a('0x2d')]=_['keys'](_0x63516e[_0xaa3a('0x2d')]);_0x367ca9[_0xaa3a('0x44')]=_['intersection'](_0x367ca9['model'],_0x367ca9[_0xaa3a('0x2d')]);_0x41f4ed[_0xaa3a('0x2f')]=_[_0xaa3a('0x30')](_0x367ca9['model'],qs['fields'](_0x63516e['query']['fields']));_0x41f4ed[_0xaa3a('0x2f')]=_0x41f4ed['attributes'][_0xaa3a('0x32')]?_0x41f4ed[_0xaa3a('0x2f')]:_0x367ca9[_0xaa3a('0x2b')];if(_0x63516e[_0xaa3a('0x2d')]['includeAll']){_0x41f4ed[_0xaa3a('0x45')]=[{'all':!![]}];}_0x41f4ed=_[_0xaa3a('0x3a')]({},_0x41f4ed,_0x63516e[_0xaa3a('0x3c')]);return db[_0xaa3a('0x3d')][_0xaa3a('0x46')](_0x41f4ed)[_0xaa3a('0x1e')](handleEntityNotFound(_0x2cca5b,null))['then'](respondWithResult(_0x2cca5b,null))['catch'](handleError(_0x2cca5b,null));};exports['create']=function(_0x18789e,_0x45a397){return db[_0xaa3a('0x3d')][_0xaa3a('0x47')](_0x18789e[_0xaa3a('0x48')],{})['then'](function(_0x225161){var _0x48be87=_0x18789e[_0xaa3a('0x49')][_0xaa3a('0x20')]({'plain':!![]});if(!_0x48be87)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x48be87[_0xaa3a('0x4a')]==='user'){var _0x1ee236=_0x225161['get']({'plain':!![]});var _0x45e8ce=_0xaa3a('0x4b');return db[_0xaa3a('0x4c')][_0xaa3a('0x46')]({'where':{'name':_0x45e8ce,'userProfileId':_0x48be87[_0xaa3a('0x4d')]},'raw':!![]})[_0xaa3a('0x1e')](function(_0x51177d){if(_0x51177d&&_0x51177d[_0xaa3a('0x4e')]===0x0){return db[_0xaa3a('0x22')][_0xaa3a('0x47')]({'name':_0x1ee236[_0xaa3a('0x2c')],'resourceId':_0x1ee236['id'],'type':'DefaultReports','sectionId':_0x51177d['id']},{})[_0xaa3a('0x1e')](function(){return _0x225161;});}else{return _0x225161;}})[_0xaa3a('0x41')](function(_0x1fc736){logger[_0xaa3a('0x4f')](_0xaa3a('0x50'),_0x1fc736);throw _0x1fc736;});}return _0x225161;})[_0xaa3a('0x1e')](respondWithResult(_0x45a397,0xc9))['catch'](handleError(_0x45a397,null));};exports[_0xaa3a('0x1d')]=function(_0x1e8bad,_0x5cc37e){if(_0x1e8bad[_0xaa3a('0x48')]['id']){delete _0x1e8bad[_0xaa3a('0x48')]['id'];}return db[_0xaa3a('0x3d')][_0xaa3a('0x46')]({'where':{'id':_0x1e8bad[_0xaa3a('0x43')]['id']}})[_0xaa3a('0x1e')](handleEntityNotFound(_0x5cc37e,null))[_0xaa3a('0x1e')](saveUpdates(_0x1e8bad[_0xaa3a('0x48')],null))[_0xaa3a('0x1e')](respondWithResult(_0x5cc37e,null))[_0xaa3a('0x41')](handleError(_0x5cc37e,null));};exports[_0xaa3a('0x1f')]=function(_0x1b5ecb,_0x1677a9){return db[_0xaa3a('0x3d')][_0xaa3a('0x46')]({'where':{'id':_0x1b5ecb[_0xaa3a('0x43')]['id']}})[_0xaa3a('0x1e')](handleEntityNotFound(_0x1677a9,null))['then'](removeEntity(_0x1677a9,null))[_0xaa3a('0x41')](handleError(_0x1677a9,null));};exports[_0xaa3a('0x51')]=function(_0x5b6564,_0x16dddf){var _0x52b1a4=0xa;var _0x5770ed=[_0xaa3a('0x52'),'left_join',_0xaa3a('0x53'),_0xaa3a('0x54')];var _0x18f2ec={'SUM':_0xaa3a('0x55'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0xaa3a('0x56'),'MAX':_0xaa3a('0x57'),'MIN':_0xaa3a('0x58'),'AVG':'AVG(%s)','GROUP_CONCAT':_0xaa3a('0x59'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x1651c5={'SEC_TO_TIME':_0xaa3a('0x5a'),'DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':'ROUND(%s)','UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x90ac16=function(_0x532776){return!_[_0xaa3a('0x5b')]([_0xaa3a('0x5c'),_0xaa3a('0x5d'),'IS\x20EMPTY',_0xaa3a('0x5e')],_0x532776);};var _0x2abc62=function(_0x46ec00){if(!_0x46ec00||!_0x46ec00[_0xaa3a('0x5f')][_0xaa3a('0x32')]){return'';}for(var _0x1fb1a8='(',_0x460fae=0x0;_0x460fae<_0x46ec00['rules'][_0xaa3a('0x32')];_0x460fae+=0x1){_0x460fae>0x0&&(_0x1fb1a8+='\x20'+_0x46ec00['operator']+'\x20');_0x1fb1a8+=_0x46ec00[_0xaa3a('0x5f')][_0x460fae][_0xaa3a('0x60')]?_0x2abc62(_0x46ec00[_0xaa3a('0x5f')][_0x460fae][_0xaa3a('0x60')]):_0x46ec00[_0xaa3a('0x5f')][_0x460fae][_0xaa3a('0x61')]+'\x20'+_0x46ec00[_0xaa3a('0x5f')][_0x460fae][_0xaa3a('0x62')]+(_0x90ac16(_0x46ec00['rules'][_0x460fae][_0xaa3a('0x62')])?'\x20'+_0x46ec00[_0xaa3a('0x5f')][_0x460fae][_0xaa3a('0x63')]:'');}return _0x1fb1a8+')';};var _0x1529a0={'where':{'id':_0x5b6564[_0xaa3a('0x43')]['id']}},_0x4acc96,_0x199469,_0x573ba3,_0x235426,_0x1f7ed3;_0x1529a0=_[_0xaa3a('0x3a')]({},_0x1529a0,_0x5b6564[_0xaa3a('0x3c')]);return db[_0xaa3a('0x3d')][_0xaa3a('0x46')](_0x1529a0)['then'](function(_0x330190){if(_0x330190){_0x4acc96=_0x330190;return _0x330190[_0xaa3a('0x64')]();}return null;})['then'](function(_0xc9e8a0){if(_0xc9e8a0){if(!_0xc9e8a0[_0xaa3a('0x32')]){throw new db[(_0xaa3a('0x65'))][(_0xaa3a('0x66'))](_0xaa3a('0x67'),0x193);}_0x199469=_0xc9e8a0;return db[_0xaa3a('0x68')]['findAll']({'raw':!![]});}return null;})['then'](function(_0x33eca5){if(_0x33eca5){_0x573ba3=_[_0xaa3a('0x69')](_0x33eca5,'id');var _0x1c5df9;var _0x5c1c7a=squel[_0xaa3a('0x6a')]();_0x5c1c7a[_0xaa3a('0x6b')](_0x4acc96[_0xaa3a('0x6c')]);for(var _0x24006a=0x0;_0x24006a<_0x199469[_0xaa3a('0x32')];_0x24006a+=0x1){_0x1c5df9=_0x199469[_0x24006a][_0xaa3a('0x6d')]?_0x573ba3[_0x199469[_0x24006a][_0xaa3a('0x6d')]][_0xaa3a('0x6e')]:_0x199469[_0x24006a][_0xaa3a('0x61')];_0x1c5df9=_0x199469[_0x24006a][_0xaa3a('0x6f')]?_['replace'](_0x18f2ec[_0x199469[_0x24006a]['function']],'%s',_0x1c5df9):_0x1c5df9;_0x1c5df9=_0x199469[_0x24006a]['format']?_[_0xaa3a('0x70')](_0x1651c5[_0x199469[_0x24006a][_0xaa3a('0x71')]],'%s',_0x1c5df9):_0x1c5df9;if(_0x199469[_0x24006a][_0xaa3a('0x72')]){_0x5c1c7a['group'](_0x1c5df9);}_0x199469[_0x24006a][_0xaa3a('0x73')]&&_0x5c1c7a[_0xaa3a('0x36')](_0x1c5df9,_0x199469[_0x24006a]['orderBy']===_0xaa3a('0x74')?![]:!![]);_0x5c1c7a[_0xaa3a('0x61')](_0x1c5df9,_0x199469[_0x24006a][_0xaa3a('0x75')]||_0x1c5df9);}if(_0x4acc96[_0xaa3a('0x76')]){_0x4acc96[_0xaa3a('0x76')]=JSON[_0xaa3a('0x77')](_0x4acc96[_0xaa3a('0x76')]);for(var _0x4d13b8=0x0;_0x4d13b8<_0x4acc96[_0xaa3a('0x76')]['length'];_0x4d13b8+=0x1){if(_0x4acc96[_0xaa3a('0x76')][_0x4d13b8][_0xaa3a('0x29')]&&_[_0xaa3a('0x5b')](_0x5770ed,_0x4acc96['joins'][_0x4d13b8][_0xaa3a('0x29')])&&_0x4acc96[_0xaa3a('0x76')][_0x4d13b8][_0xaa3a('0x78')]&&_0x4acc96[_0xaa3a('0x76')][_0x4d13b8][_0xaa3a('0x79')]&&_0x4acc96[_0xaa3a('0x76')][_0x4d13b8]['foreignKey']){_0x5c1c7a[_0x4acc96[_0xaa3a('0x76')][_0x4d13b8][_0xaa3a('0x29')]](_0x4acc96['joins'][_0x4d13b8][_0xaa3a('0x79')],null,util[_0xaa3a('0x71')]('%s.%s\x20=\x20%s.%s',_0x4acc96[_0xaa3a('0x6c')],_0x4acc96[_0xaa3a('0x76')][_0x4d13b8][_0xaa3a('0x78')],_0x4acc96[_0xaa3a('0x76')][_0x4d13b8]['foreignTable'],_0x4acc96['joins'][_0x4d13b8][_0xaa3a('0x7a')]));}}}if(_0x4acc96[_0xaa3a('0x7b')]){_0x4acc96[_0xaa3a('0x7b')]=JSON[_0xaa3a('0x77')](_0x4acc96['conditions']);_0x5c1c7a[_0xaa3a('0x38')](_0x2abc62(_0x4acc96[_0xaa3a('0x7b')][_0xaa3a('0x60')]));}_0x1f7ed3=_0x5c1c7a[_0xaa3a('0x7c')]();_0x5c1c7a[_0xaa3a('0x35')](_0x52b1a4);_0x5c1c7a[_0xaa3a('0x1a')](0x0);logger[_0xaa3a('0x7d')](_0xaa3a('0x7e'),_0x5c1c7a[_0xaa3a('0x7f')]());return db[_0xaa3a('0x80')][_0xaa3a('0x2d')](_0x5c1c7a['toString'](),{'type':db[_0xaa3a('0x80')][_0xaa3a('0x81')]['SELECT']});}})[_0xaa3a('0x1e')](respondWithResult(_0x16dddf,null))[_0xaa3a('0x41')](handleError(_0x16dddf,null));};function runReport(_0x1d0cc6,_0x32a95a,_0x229067){var _0x3acd87=_0x32a95a[_0xaa3a('0x2c')];var _0x596688=0xa;var _0x4c4d67=['join',_0xaa3a('0x82'),_0xaa3a('0x53'),_0xaa3a('0x54')];var _0xcdc25d={'SUM':'SUM(%s)','COUNT':_0xaa3a('0x83'),'COUNT DISTINCT':_0xaa3a('0x56'),'MAX':_0xaa3a('0x57'),'MIN':_0xaa3a('0x58'),'AVG':_0xaa3a('0x84'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0xaa3a('0x85'),'GROUP_CONCAT DESC':_0xaa3a('0x86')};var _0x1b8655={'SEC_TO_TIME':_0xaa3a('0x5a'),'DATE':'DATE(%s)','HOUR':_0xaa3a('0x87'),'ROUND':_0xaa3a('0x88'),'UNIX_TIMESTAMP':_0xaa3a('0x89')};var _0x54aa6a=function(_0x2244d7){return!_[_0xaa3a('0x5b')]([_0xaa3a('0x5c'),_0xaa3a('0x5d'),_0xaa3a('0x8a'),_0xaa3a('0x5e')],_0x2244d7);};var _0x8dc67b=function(_0x41c17c){if(!_0x41c17c||!_0x41c17c[_0xaa3a('0x5f')]['length']){return'';}for(var _0x19b3ee='(',_0x1273c2=0x0;_0x1273c2<_0x41c17c['rules']['length'];_0x1273c2+=0x1){_0x1273c2>0x0&&(_0x19b3ee+='\x20'+_0x41c17c[_0xaa3a('0x8b')]+'\x20');_0x19b3ee+=_0x41c17c[_0xaa3a('0x5f')][_0x1273c2][_0xaa3a('0x60')]?_0x8dc67b(_0x41c17c['rules'][_0x1273c2][_0xaa3a('0x60')]):_0x41c17c[_0xaa3a('0x5f')][_0x1273c2][_0xaa3a('0x61')]+'\x20'+_0x41c17c[_0xaa3a('0x5f')][_0x1273c2][_0xaa3a('0x62')]+(_0x54aa6a(_0x41c17c[_0xaa3a('0x5f')][_0x1273c2][_0xaa3a('0x62')])?'\x20'+_0x41c17c['rules'][_0x1273c2][_0xaa3a('0x63')]:'');}return _0x19b3ee+')';};var _0x40fc52={'where':{'id':_0x1d0cc6['id']}},_0x5147d7,_0x4685aa,_0x572cb9,_0x438b8f,_0x71ad96;_0x40fc52=_['merge']({},_0x40fc52,_0x229067);return db['AnalyticDefaultReport']['find'](_0x40fc52)[_0xaa3a('0x1e')](function(_0x50e2f6){if(_0x50e2f6){_0x5147d7=_0x50e2f6;return _0x50e2f6[_0xaa3a('0x64')]();}return null;})[_0xaa3a('0x1e')](function(_0x448f41){if(_0x448f41){if(!_0x448f41['length']){throw new db[(_0xaa3a('0x65'))][(_0xaa3a('0x66'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x4685aa=_0x448f41;return db[_0xaa3a('0x68')][_0xaa3a('0x3f')]({'raw':!![]});}return null;})[_0xaa3a('0x1e')](function(_0xc8c19){if(_0xc8c19){_0x572cb9=_['keyBy'](_0xc8c19,'id');var _0x230b24;var _0x3425aa=squel[_0xaa3a('0x6a')]();_0x3425aa['from'](_0x5147d7['table']);for(var _0x393814=0x0;_0x393814<_0x4685aa['length'];_0x393814+=0x1){_0x230b24=_0x4685aa[_0x393814][_0xaa3a('0x6d')]?_0x572cb9[_0x4685aa[_0x393814][_0xaa3a('0x6d')]][_0xaa3a('0x6e')]:_0x4685aa[_0x393814]['field'];_0x230b24=_0x4685aa[_0x393814][_0xaa3a('0x6f')]?_[_0xaa3a('0x70')](_0xcdc25d[_0x4685aa[_0x393814][_0xaa3a('0x6f')]],'%s',_0x230b24):_0x230b24;_0x230b24=_0x4685aa[_0x393814][_0xaa3a('0x71')]?_[_0xaa3a('0x70')](_0x1b8655[_0x4685aa[_0x393814][_0xaa3a('0x71')]],'%s',_0x230b24):_0x230b24;if(_0x4685aa[_0x393814][_0xaa3a('0x72')]){_0x3425aa['group'](_0x230b24);}_0x4685aa[_0x393814]['orderBy']&&_0x3425aa[_0xaa3a('0x36')](_0x230b24,_0x4685aa[_0x393814][_0xaa3a('0x73')]===_0xaa3a('0x74')?![]:!![]);_0x3425aa['field'](_0x230b24,_0x4685aa[_0x393814][_0xaa3a('0x75')]||_0x230b24);}if(_0x5147d7['joins']){_0x5147d7[_0xaa3a('0x76')]=JSON[_0xaa3a('0x77')](_0x5147d7['joins']);for(var _0x4fb6a=0x0;_0x4fb6a<_0x5147d7[_0xaa3a('0x76')][_0xaa3a('0x32')];_0x4fb6a+=0x1){if(_0x5147d7['joins'][_0x4fb6a][_0xaa3a('0x29')]&&_[_0xaa3a('0x5b')](_0x4c4d67,_0x5147d7[_0xaa3a('0x76')][_0x4fb6a][_0xaa3a('0x29')])&&_0x5147d7[_0xaa3a('0x76')][_0x4fb6a][_0xaa3a('0x78')]&&_0x5147d7['joins'][_0x4fb6a][_0xaa3a('0x79')]&&_0x5147d7[_0xaa3a('0x76')][_0x4fb6a][_0xaa3a('0x7a')]){_0x3425aa[_0x5147d7[_0xaa3a('0x76')][_0x4fb6a][_0xaa3a('0x29')]](_0x5147d7[_0xaa3a('0x76')][_0x4fb6a][_0xaa3a('0x79')],null,util['format'](_0xaa3a('0x8c'),_0x5147d7[_0xaa3a('0x6c')],_0x5147d7[_0xaa3a('0x76')][_0x4fb6a][_0xaa3a('0x78')],_0x5147d7[_0xaa3a('0x76')][_0x4fb6a][_0xaa3a('0x79')],_0x5147d7[_0xaa3a('0x76')][_0x4fb6a][_0xaa3a('0x7a')]));}}}if(_0x5147d7[_0xaa3a('0x7b')]){_0x5147d7['conditions']=JSON[_0xaa3a('0x77')](_0x5147d7[_0xaa3a('0x7b')]);_0x3425aa[_0xaa3a('0x38')](_0x8dc67b(_0x5147d7['conditions'][_0xaa3a('0x60')]));}_0x71ad96=_0x3425aa['clone']();_0x3425aa[_0xaa3a('0x35')](_0x596688);_0x3425aa[_0xaa3a('0x1a')](0x0);logger['debug'](_0xaa3a('0x7e'),_0x3425aa[_0xaa3a('0x7f')]());return db[_0xaa3a('0x80')]['query'](_0x3425aa[_0xaa3a('0x7f')](),{'type':db[_0xaa3a('0x80')][_0xaa3a('0x81')]['SELECT']});}})[_0xaa3a('0x1e')](function(_0x6622ad){if(!_0x6622ad[_0xaa3a('0x32')]){throw new db[(_0xaa3a('0x65'))][(_0xaa3a('0x66'))](_0xaa3a('0x8d'),0xcc);}if(_0x32a95a['output']===_0xaa3a('0x8e')){return null;}var _0x41c137=_['merge'](_0x32a95a,{'name':_0x32a95a[_0xaa3a('0x8f')]||_0x32a95a[_0xaa3a('0x2c')]||_0x5147d7[_0xaa3a('0x2c')],'basename':_0x3acd87,'savename':util[_0xaa3a('0x71')](_0xaa3a('0x90'),_0x32a95a[_0xaa3a('0x2c')]||_0x5147d7[_0xaa3a('0x2c')],require(_0xaa3a('0x91'))[_0xaa3a('0x92')](0x4),_0x32a95a['output']||_0xaa3a('0x93')),'reportId':_0x5147d7['id'],'reportType':_0xaa3a('0x94')});return db['AnalyticExtractedReport'][_0xaa3a('0x47')](_0x41c137,{'raw':!![]});})[_0xaa3a('0x1e')](function(_0x23625b){if(_0x5147d7[_0xaa3a('0x6c')]===_0xaa3a('0x95')){_0x71ad96[_0xaa3a('0x38')](_0x5147d7[_0xaa3a('0x6c')]+_0xaa3a('0x96'),_0x32a95a[_0xaa3a('0x97')],_0x32a95a[_0xaa3a('0x98')]);}else{_0x71ad96['where'](_0x5147d7[_0xaa3a('0x6c')]+_0xaa3a('0x99'),_0x32a95a[_0xaa3a('0x97')],_0x32a95a['endDate']);}if(_0x23625b){logger[_0xaa3a('0x9a')](_0xaa3a('0x9b'),_0x71ad96[_0xaa3a('0x7f')]());require(_0xaa3a('0x9c'))[_0xaa3a('0x9d')](path[_0xaa3a('0x52')](__dirname,_0xaa3a('0x9e'),_0x23625b[_0xaa3a('0x9f')]),[_0x23625b['id'],_0x71ad96[_0xaa3a('0x7f')](),path['join'](__dirname,_0xaa3a('0xa0'),_0x23625b[_0xaa3a('0xa1')]),_0x3acd87]);return _0x23625b;}else{var _0x482d0d=squel[_0xaa3a('0x6a')]();_0x482d0d[_0xaa3a('0x6b')]('('+_0x71ad96[_0xaa3a('0x7f')]()+')',_0xaa3a('0xa2'));_0x482d0d[_0xaa3a('0x61')](_0xaa3a('0xa3'),_0xaa3a('0xa4'));_0x71ad96[_0xaa3a('0x35')](_0x32a95a[_0xaa3a('0x35')]||_0x596688);_0x71ad96['offset'](_0x32a95a[_0xaa3a('0x1a')]||0x0);return dbH[_0xaa3a('0x80')][_0xaa3a('0x2d')](_0x482d0d[_0xaa3a('0x7f')](),{'type':dbH[_0xaa3a('0x80')]['QueryTypes']['SELECT']})['then'](function(_0x59fddc){if(!_0x59fddc[_0xaa3a('0x32')]){_0x438b8f=0x0;}else{_0x438b8f=_0x59fddc[0x0]['count']||0x0;}return dbH['sequelize'][_0xaa3a('0x2d')](_0x71ad96[_0xaa3a('0x7f')](),{'type':dbH['sequelize']['QueryTypes']['SELECT']});})[_0xaa3a('0x1e')](function(_0xdb914){return{'rows':_0xdb914||[],'count':_0x438b8f};});}});}exports[_0xaa3a('0xa5')]=function(_0x4e75cd,_0x3a19dd){return runReport(_0x4e75cd[_0xaa3a('0x43')],_0x4e75cd[_0xaa3a('0x2d')],_0x4e75cd[_0xaa3a('0x3c')])['then'](respondWithResult(_0x3a19dd,null))[_0xaa3a('0x41')](handleError(_0x3a19dd,null));};exports[_0xaa3a('0xa6')]=runReport;exports[_0xaa3a('0x2d')]=function(_0x467bf4,_0x427a80){var _0x4027c1=0xa;var _0x208edc=['join',_0xaa3a('0x82'),_0xaa3a('0x53'),_0xaa3a('0x54')];var _0x2c6f6c={'SUM':'SUM(%s)','COUNT':_0xaa3a('0x83'),'COUNT DISTINCT':_0xaa3a('0x56'),'MAX':'MAX(%s)','MIN':_0xaa3a('0x58'),'AVG':_0xaa3a('0x84'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0xaa3a('0x86')};var _0x2a848a={'SEC_TO_TIME':_0xaa3a('0x5a'),'DATE':_0xaa3a('0xa7'),'HOUR':_0xaa3a('0x87'),'ROUND':_0xaa3a('0x88'),'UNIX_TIMESTAMP':_0xaa3a('0x89')};var _0x32ea4e=function(_0x61d96b){return!_[_0xaa3a('0x5b')]([_0xaa3a('0x5c'),'IS\x20NOT\x20NULL',_0xaa3a('0x8a'),_0xaa3a('0x5e')],_0x61d96b);};var _0x4e4aca=function(_0x29748e){if(!_0x29748e||!_0x29748e[_0xaa3a('0x5f')][_0xaa3a('0x32')]){return'';}for(var _0x50ff28='(',_0x42c448=0x0;_0x42c448<_0x29748e['rules']['length'];_0x42c448+=0x1){_0x42c448>0x0&&(_0x50ff28+='\x20'+_0x29748e[_0xaa3a('0x8b')]+'\x20');_0x50ff28+=_0x29748e[_0xaa3a('0x5f')][_0x42c448][_0xaa3a('0x60')]?_0x4e4aca(_0x29748e[_0xaa3a('0x5f')][_0x42c448][_0xaa3a('0x60')]):_0x29748e['rules'][_0x42c448][_0xaa3a('0x61')]+'\x20'+_0x29748e[_0xaa3a('0x5f')][_0x42c448][_0xaa3a('0x62')]+(_0x32ea4e(_0x29748e[_0xaa3a('0x5f')][_0x42c448][_0xaa3a('0x62')])?'\x20'+_0x29748e[_0xaa3a('0x5f')][_0x42c448]['value']:'');}return _0x50ff28+')';};var _0x32c3de={'where':{'id':_0x467bf4[_0xaa3a('0x43')]['id']}},_0x1ff694,_0x2a113a,_0x469263,_0x2822e7,_0x286d72;_0x32c3de=_[_0xaa3a('0x3a')]({},_0x32c3de,_0x467bf4['options']);return db[_0xaa3a('0x3d')]['find'](_0x32c3de)[_0xaa3a('0x1e')](function(_0x50ebe4){if(_0x50ebe4){_0x1ff694=_0x50ebe4;return _0x50ebe4[_0xaa3a('0x64')]();}return null;})[_0xaa3a('0x1e')](function(_0x19e4cb){if(_0x19e4cb){if(!_0x19e4cb['length']){throw new db[(_0xaa3a('0x65'))][(_0xaa3a('0x66'))](_0xaa3a('0x67'),0x193);}_0x2a113a=_0x19e4cb;return db[_0xaa3a('0x68')]['findAll']({'raw':!![]});}return null;})[_0xaa3a('0x1e')](function(_0x340993){if(_0x340993){_0x469263=_[_0xaa3a('0x69')](_0x340993,'id');var _0x115bf5;var _0x4e0f7d=squel[_0xaa3a('0x6a')]();_0x4e0f7d['from'](_0x1ff694['table']);for(var _0x57ff54=0x0;_0x57ff54<_0x2a113a['length'];_0x57ff54+=0x1){_0x115bf5=_0x2a113a[_0x57ff54][_0xaa3a('0x6d')]?_0x469263[_0x2a113a[_0x57ff54]['MetricId']][_0xaa3a('0x6e')]:_0x2a113a[_0x57ff54]['field'];_0x115bf5=_0x2a113a[_0x57ff54]['function']?_[_0xaa3a('0x70')](_0x2c6f6c[_0x2a113a[_0x57ff54][_0xaa3a('0x6f')]],'%s',_0x115bf5):_0x115bf5;_0x115bf5=_0x2a113a[_0x57ff54][_0xaa3a('0x71')]?_[_0xaa3a('0x70')](_0x2a848a[_0x2a113a[_0x57ff54][_0xaa3a('0x71')]],'%s',_0x115bf5):_0x115bf5;if(_0x2a113a[_0x57ff54][_0xaa3a('0x72')]){_0x4e0f7d['group'](_0x115bf5);}_0x2a113a[_0x57ff54][_0xaa3a('0x73')]&&_0x4e0f7d['order'](_0x115bf5,_0x2a113a[_0x57ff54][_0xaa3a('0x73')]===_0xaa3a('0x74')?![]:!![]);_0x4e0f7d[_0xaa3a('0x61')](_0x115bf5,_0x2a113a[_0x57ff54][_0xaa3a('0x75')]||_0x115bf5);}if(_0x1ff694[_0xaa3a('0x76')]){_0x1ff694[_0xaa3a('0x76')]=JSON['parse'](_0x1ff694[_0xaa3a('0x76')]);for(var _0x23ec7c=0x0;_0x23ec7c<_0x1ff694[_0xaa3a('0x76')][_0xaa3a('0x32')];_0x23ec7c+=0x1){if(_0x1ff694['joins'][_0x23ec7c]['type']&&_[_0xaa3a('0x5b')](_0x208edc,_0x1ff694[_0xaa3a('0x76')][_0x23ec7c][_0xaa3a('0x29')])&&_0x1ff694[_0xaa3a('0x76')][_0x23ec7c][_0xaa3a('0x78')]&&_0x1ff694[_0xaa3a('0x76')][_0x23ec7c]['foreignTable']&&_0x1ff694['joins'][_0x23ec7c][_0xaa3a('0x7a')]){_0x4e0f7d[_0x1ff694[_0xaa3a('0x76')][_0x23ec7c][_0xaa3a('0x29')]](_0x1ff694[_0xaa3a('0x76')][_0x23ec7c][_0xaa3a('0x79')],null,util[_0xaa3a('0x71')](_0xaa3a('0x8c'),_0x1ff694[_0xaa3a('0x6c')],_0x1ff694[_0xaa3a('0x76')][_0x23ec7c][_0xaa3a('0x78')],_0x1ff694[_0xaa3a('0x76')][_0x23ec7c][_0xaa3a('0x79')],_0x1ff694[_0xaa3a('0x76')][_0x23ec7c]['foreignKey']));}}}if(_0x1ff694[_0xaa3a('0x7b')]){_0x1ff694[_0xaa3a('0x7b')]=JSON[_0xaa3a('0x77')](_0x1ff694[_0xaa3a('0x7b')]);_0x4e0f7d[_0xaa3a('0x38')](_0x4e4aca(_0x1ff694['conditions']['group']));}_0x286d72=_0x4e0f7d[_0xaa3a('0x7c')]();_0x4e0f7d[_0xaa3a('0x35')](_0x4027c1);_0x4e0f7d[_0xaa3a('0x1a')](0x0);logger['debug'](_0xaa3a('0x7e'),_0x4e0f7d[_0xaa3a('0x7f')]());return db[_0xaa3a('0x80')][_0xaa3a('0x2d')](_0x4e0f7d['toString'](),{'type':db[_0xaa3a('0x80')][_0xaa3a('0x81')][_0xaa3a('0xa8')]});}})[_0xaa3a('0x1e')](function(){return{'sql':_0x286d72[_0xaa3a('0x7f')]()};})[_0xaa3a('0x1e')](respondWithResult(_0x427a80,null))['catch'](handleError(_0x427a80,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff