// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x977f=['reject','save','update','then','destroy','CustomReports','sendStatus','error','stack','name','send','index','AnalyticCustomReport','rawAttributes','fieldName','key','model','map','query','filters','fields','attributes','hasOwnProperty','limit','order','sort','where','filter','merge','type','VIRTUAL','options','count','includeAll','rows','catch','params','keys','intersection','length','include','find','create','body','user','get','role','Reports','userProfileId','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','preview','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)','SEC_TO_TIME(%s)','HOUR(%s)','ROUND(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','from','table','MetricId','metric','function','replace','format','groupBy','alias','joins','parse','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','conditions','clone','Limited\x20Query:','toString','sequelize','QueryTypes','left_join','right_join','SUM(%s)','COUNT(DISTINCT\x20%s)','GROUP_CONCAT(%s)','DATE(%s)','UNIX_TIMESTAMP(%s)','value','orderBy','DESC','parentKey','web','fullPath','%s-%s.%s','randomstring','generate','output','csv','custom','AnalyticExtractedReport','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','Run\x20Query:','child_process','savename','select','COUNT(*)','SELECT','run','runReport','findAll','debug','eml-format','rimraf','zip-dir','request-promise','moment','mustache','util','sox','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','to-csv','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','dbH','status','offset','undefined','Content-Range','json'];(function(_0x331dfe,_0x13f0fc){var _0x104132=function(_0x41de65){while(--_0x41de65){_0x331dfe['push'](_0x331dfe['shift']());}};_0x104132(++_0x13f0fc);}(_0x977f,0x1d7));var _0xf977=function(_0x13aee3,_0x500a70){_0x13aee3=_0x13aee3-0x0;var _0x3cb89d=_0x977f[_0x13aee3];return _0x3cb89d;};'use strict';var emlformat=require(_0xf977('0x0'));var rimraf=require(_0xf977('0x1'));var zipdir=require(_0xf977('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0xf977('0x3'));var moment=require(_0xf977('0x4'));var BPromise=require('bluebird');var Mustache=require(_0xf977('0x5'));var util=require(_0xf977('0x6'));var path=require('path');var sox=require(_0xf977('0x7'));var csv=require('to-csv');var ejs=require(_0xf977('0x8'));var fs=require('fs');var fs_extra=require(_0xf977('0x9'));var _=require(_0xf977('0xa'));var squel=require(_0xf977('0xb'));var crypto=require(_0xf977('0xc'));var jsforce=require(_0xf977('0xd'));var deskjs=require(_0xf977('0xe'));var toCsv=require(_0xf977('0xf'));var querystring=require(_0xf977('0x10'));var Papa=require(_0xf977('0x11'));var Redis=require('ioredis');var authService=require(_0xf977('0x12'));var qs=require(_0xf977('0x13'));var as=require(_0xf977('0x14'));var hardwareService=require(_0xf977('0x15'));var logger=require(_0xf977('0x16'))(_0xf977('0x17'));var utils=require(_0xf977('0x18'));var config=require(_0xf977('0x19'));var licenseUtil=require(_0xf977('0x1a'));var db=require('../../mysqldb')['db'];var dbH=require('../../mysqldb')[_0xf977('0x1b')];function respondWithStatusCode(_0x44e8dd,_0x4bdc7c){_0x4bdc7c=_0x4bdc7c||0xcc;return function(_0x1ee804){if(_0x1ee804){return _0x44e8dd['sendStatus'](_0x4bdc7c);}return _0x44e8dd['status'](_0x4bdc7c)['end']();};}function respondWithResult(_0x18510,_0x1be79c){_0x1be79c=_0x1be79c||0xc8;return function(_0x348afb){if(_0x348afb){return _0x18510[_0xf977('0x1c')](_0x1be79c)['json'](_0x348afb);}};}function respondWithFilteredResult(_0x46d27b,_0x3b34f6){return function(_0x3253ce){if(_0x3253ce){var _0x235dd7=typeof _0x3b34f6[_0xf977('0x1d')]===_0xf977('0x1e')&&typeof _0x3b34f6['limit']===_0xf977('0x1e');var _0x37ee57=_0x3253ce['count'];var _0x5b1568=_0x235dd7?0x0:_0x3b34f6[_0xf977('0x1d')];var _0x57be9e=_0x235dd7?_0x3253ce['count']:_0x3b34f6[_0xf977('0x1d')]+_0x3b34f6['limit'];var _0x1e64d0;if(_0x57be9e>=_0x37ee57){_0x57be9e=_0x37ee57;_0x1e64d0=0xc8;}else{_0x1e64d0=0xce;}_0x46d27b['status'](_0x1e64d0);return _0x46d27b['set'](_0xf977('0x1f'),_0x5b1568+'-'+_0x57be9e+'/'+_0x37ee57)[_0xf977('0x20')](_0x3253ce);}return null;};}function patchUpdates(_0x5d9b12){return function(_0x45ac11){try{jsonpatch['apply'](_0x45ac11,_0x5d9b12,!![]);}catch(_0x453aa0){return BPromise[_0xf977('0x21')](_0x453aa0);}return _0x45ac11[_0xf977('0x22')]();};}function saveUpdates(_0x1de7c8,_0x4ba9c8){return function(_0x4363ed){if(_0x4363ed){return _0x4363ed[_0xf977('0x23')](_0x1de7c8)[_0xf977('0x24')](function(_0x3cf169){return _0x3cf169;});}return null;};}function removeEntity(_0x563dd5,_0x397274){return function(_0x56eab7){if(_0x56eab7){return _0x56eab7[_0xf977('0x25')]()[_0xf977('0x24')](function(){var _0x5104d4=_0x56eab7['get']({'plain':!![]});var _0x1fa1ea=_0xf977('0x26');return db['UserProfileResource'][_0xf977('0x25')]({'where':{'type':_0x1fa1ea,'resourceId':_0x5104d4['id']}})[_0xf977('0x24')](function(){return _0x56eab7;});})[_0xf977('0x24')](function(){_0x563dd5[_0xf977('0x1c')](0xcc)['end']();});}};}function handleEntityNotFound(_0x3faa4c,_0x2f151f){return function(_0x3b7f51){if(!_0x3b7f51){_0x3faa4c[_0xf977('0x27')](0x194);}return _0x3b7f51;};}function handleError(_0x7e06f6,_0x14c492){_0x14c492=_0x14c492||0x1f4;return function(_0x5e74dc){logger[_0xf977('0x28')](_0x5e74dc[_0xf977('0x29')]);if(_0x5e74dc[_0xf977('0x2a')]){delete _0x5e74dc[_0xf977('0x2a')];}_0x7e06f6[_0xf977('0x1c')](_0x14c492)[_0xf977('0x2b')](_0x5e74dc);};}exports[_0xf977('0x2c')]=function(_0x3ab637,_0x4d9ba8){var _0x113e08={},_0x208fa0={},_0x472597={'count':0x0,'rows':[]};var _0xb5eed7=_['map'](db[_0xf977('0x2d')][_0xf977('0x2e')],function(_0x4e472a){return{'name':_0x4e472a[_0xf977('0x2f')],'type':_0x4e472a['type'][_0xf977('0x30')]};});_0x208fa0[_0xf977('0x31')]=_[_0xf977('0x32')](_0xb5eed7,_0xf977('0x2a'));_0x208fa0[_0xf977('0x33')]=_['keys'](_0x3ab637['query']);_0x208fa0[_0xf977('0x34')]=_['intersection'](_0x208fa0[_0xf977('0x31')],_0x208fa0[_0xf977('0x33')]);_0x113e08['attributes']=_['intersection'](_0x208fa0[_0xf977('0x31')],qs[_0xf977('0x35')](_0x3ab637['query']['fields']));_0x113e08[_0xf977('0x36')]=_0x113e08[_0xf977('0x36')]['length']?_0x113e08[_0xf977('0x36')]:_0x208fa0[_0xf977('0x31')];if(!_0x3ab637['query'][_0xf977('0x37')]('nolimit')){_0x113e08[_0xf977('0x38')]=qs[_0xf977('0x38')](_0x3ab637[_0xf977('0x33')][_0xf977('0x38')]);_0x113e08[_0xf977('0x1d')]=qs[_0xf977('0x1d')](_0x3ab637['query'][_0xf977('0x1d')]);}_0x113e08[_0xf977('0x39')]=qs[_0xf977('0x3a')](_0x3ab637['query'][_0xf977('0x3a')]);_0x113e08[_0xf977('0x3b')]=qs[_0xf977('0x34')](_['pick'](_0x3ab637['query'],_0x208fa0[_0xf977('0x34')]),_0xb5eed7);if(_0x3ab637['query'][_0xf977('0x3c')]){_0x113e08[_0xf977('0x3b')]=_[_0xf977('0x3d')](_0x113e08[_0xf977('0x3b')],{'$or':_[_0xf977('0x32')](_0xb5eed7,function(_0x30d32a){if(_0x30d32a[_0xf977('0x3e')]!==_0xf977('0x3f')){var _0x5ad59f={};_0x5ad59f[_0x30d32a[_0xf977('0x2a')]]={'$like':'%'+_0x3ab637[_0xf977('0x33')]['filter']+'%'};return _0x5ad59f;}})});}_0x113e08=_[_0xf977('0x3d')]({},_0x113e08,_0x3ab637[_0xf977('0x40')]);var _0x31b65a={'where':_0x113e08[_0xf977('0x3b')]};return db[_0xf977('0x2d')][_0xf977('0x41')](_0x31b65a)['then'](function(_0x38bc3e){_0x472597[_0xf977('0x41')]=_0x38bc3e;if(_0x3ab637[_0xf977('0x33')][_0xf977('0x42')]){_0x113e08['include']=[{'all':!![]}];}return db[_0xf977('0x2d')]['findAll'](_0x113e08);})[_0xf977('0x24')](function(_0x5ae644){_0x472597[_0xf977('0x43')]=_0x5ae644;return _0x472597;})['then'](respondWithFilteredResult(_0x4d9ba8,_0x113e08))[_0xf977('0x44')](handleError(_0x4d9ba8,null));};exports['show']=function(_0x443a95,_0x5cc677){var _0x5bbe7b={'raw':![],'where':{'id':_0x443a95[_0xf977('0x45')]['id']}},_0x5a4735={};_0x5a4735['model']=_[_0xf977('0x46')](db['AnalyticCustomReport'][_0xf977('0x2e')]);_0x5a4735[_0xf977('0x33')]=_[_0xf977('0x46')](_0x443a95[_0xf977('0x33')]);_0x5a4735[_0xf977('0x34')]=_[_0xf977('0x47')](_0x5a4735['model'],_0x5a4735[_0xf977('0x33')]);_0x5bbe7b[_0xf977('0x36')]=_['intersection'](_0x5a4735[_0xf977('0x31')],qs[_0xf977('0x35')](_0x443a95[_0xf977('0x33')][_0xf977('0x35')]));_0x5bbe7b[_0xf977('0x36')]=_0x5bbe7b['attributes'][_0xf977('0x48')]?_0x5bbe7b[_0xf977('0x36')]:_0x5a4735[_0xf977('0x31')];if(_0x443a95['query'][_0xf977('0x42')]){_0x5bbe7b[_0xf977('0x49')]=[{'all':!![]}];}_0x5bbe7b=_[_0xf977('0x3d')]({},_0x5bbe7b,_0x443a95[_0xf977('0x40')]);return db[_0xf977('0x2d')][_0xf977('0x4a')](_0x5bbe7b)[_0xf977('0x24')](handleEntityNotFound(_0x5cc677,null))[_0xf977('0x24')](respondWithResult(_0x5cc677,null))['catch'](handleError(_0x5cc677,null));};exports[_0xf977('0x4b')]=function(_0x450d5f,_0x35b3c4){return db[_0xf977('0x2d')]['create'](_0x450d5f[_0xf977('0x4c')],{})[_0xf977('0x24')](function(_0x226bda){var _0x2e9ff9=_0x450d5f[_0xf977('0x4d')][_0xf977('0x4e')]({'plain':!![]});if(!_0x2e9ff9)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x2e9ff9[_0xf977('0x4f')]===_0xf977('0x4d')){var _0x21eae9=_0x226bda[_0xf977('0x4e')]({'plain':!![]});var _0x4cc6e2=_0xf977('0x50');return db['UserProfileSection']['find']({'where':{'name':_0x4cc6e2,'userProfileId':_0x2e9ff9[_0xf977('0x51')]},'raw':!![]})[_0xf977('0x24')](function(_0x31b092){if(_0x31b092&&_0x31b092[_0xf977('0x52')]===0x0){return db[_0xf977('0x53')][_0xf977('0x4b')]({'name':_0x21eae9[_0xf977('0x2a')],'resourceId':_0x21eae9['id'],'type':_0xf977('0x26'),'sectionId':_0x31b092['id']},{})['then'](function(){return _0x226bda;});}else{return _0x226bda;}})['catch'](function(_0x22d140){logger[_0xf977('0x28')](_0xf977('0x54'),_0x22d140);throw _0x22d140;});}return _0x226bda;})[_0xf977('0x24')](respondWithResult(_0x35b3c4,0xc9))['catch'](handleError(_0x35b3c4,null));};exports[_0xf977('0x23')]=function(_0x21fddd,_0x395bd0){if(_0x21fddd['body']['id']){delete _0x21fddd[_0xf977('0x4c')]['id'];}return db[_0xf977('0x2d')][_0xf977('0x4a')]({'where':{'id':_0x21fddd[_0xf977('0x45')]['id']}})[_0xf977('0x24')](handleEntityNotFound(_0x395bd0,null))['then'](saveUpdates(_0x21fddd[_0xf977('0x4c')],null))[_0xf977('0x24')](respondWithResult(_0x395bd0,null))[_0xf977('0x44')](handleError(_0x395bd0,null));};exports[_0xf977('0x25')]=function(_0x162203,_0x4bea88){return db[_0xf977('0x2d')]['find']({'where':{'id':_0x162203['params']['id']}})[_0xf977('0x24')](handleEntityNotFound(_0x4bea88,null))[_0xf977('0x24')](removeEntity(_0x4bea88,null))['catch'](handleError(_0x4bea88,null));};exports[_0xf977('0x55')]=function(_0x4ce1c6,_0x439cc4){var _0x2fef31=0xa;var _0x152f8f=[_0xf977('0x56'),'left_join','right_join',_0xf977('0x57')];var _0x15453e={'SUM':'SUM(%s)','COUNT':_0xf977('0x58'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0xf977('0x59'),'MIN':_0xf977('0x5a'),'AVG':_0xf977('0x5b'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0xf977('0x5c'),'GROUP_CONCAT DESC':_0xf977('0x5d')};var _0x21b170={'SEC_TO_TIME':_0xf977('0x5e'),'DATE':'DATE(%s)','HOUR':_0xf977('0x5f'),'ROUND':_0xf977('0x60'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x2ae985=function(_0x591ac6){return!_[_0xf977('0x61')]([_0xf977('0x62'),_0xf977('0x63'),_0xf977('0x64'),_0xf977('0x65')],_0x591ac6);};var _0x19394b=function(_0x2eea65){if(!_0x2eea65||!_0x2eea65[_0xf977('0x66')][_0xf977('0x48')]){return'';}for(var _0x3bb17a='(',_0x1bd0bb=0x0;_0x1bd0bb<_0x2eea65[_0xf977('0x66')][_0xf977('0x48')];_0x1bd0bb+=0x1){_0x1bd0bb>0x0&&(_0x3bb17a+='\x20'+_0x2eea65[_0xf977('0x67')]+'\x20');_0x3bb17a+=_0x2eea65['rules'][_0x1bd0bb][_0xf977('0x68')]?_0x19394b(_0x2eea65[_0xf977('0x66')][_0x1bd0bb][_0xf977('0x68')]):_0x2eea65[_0xf977('0x66')][_0x1bd0bb][_0xf977('0x69')]+'\x20'+_0x2eea65[_0xf977('0x66')][_0x1bd0bb]['condition']+(_0x2ae985(_0x2eea65['rules'][_0x1bd0bb][_0xf977('0x6a')])?'\x20'+_0x2eea65[_0xf977('0x66')][_0x1bd0bb]['value']:'');}return _0x3bb17a+')';};var _0x42c256={'where':{'id':_0x4ce1c6['params']['id']}},_0x546d1f,_0x5183c8,_0x5e7860,_0xf7ab94,_0x357350;_0x42c256=_['merge']({},_0x42c256,_0x4ce1c6[_0xf977('0x40')]);return db[_0xf977('0x2d')]['find'](_0x42c256)[_0xf977('0x24')](function(_0xe66c8a){if(_0xe66c8a){_0x546d1f=_0xe66c8a;return _0xe66c8a[_0xf977('0x6b')]();}return null;})[_0xf977('0x24')](function(_0x563244){if(_0x563244){if(!_0x563244[_0xf977('0x48')]){throw new db[(_0xf977('0x6c'))][(_0xf977('0x6d'))](_0xf977('0x6e'),0x193);}_0x5183c8=_0x563244;return db[_0xf977('0x6f')]['findAll']({'raw':!![]});}return null;})[_0xf977('0x24')](function(_0x2ea6ca){if(_0x2ea6ca){_0x5e7860=_[_0xf977('0x70')](_0x2ea6ca,'id');var _0x1bf08f;var _0x24d520=squel['select']();_0x24d520[_0xf977('0x71')](_0x546d1f[_0xf977('0x72')]);for(var _0x5d339e=0x0;_0x5d339e<_0x5183c8[_0xf977('0x48')];_0x5d339e+=0x1){_0x1bf08f=_0x5183c8[_0x5d339e][_0xf977('0x73')]?_0x5e7860[_0x5183c8[_0x5d339e][_0xf977('0x73')]][_0xf977('0x74')]:_0x5183c8[_0x5d339e]['field'];_0x1bf08f=_0x5183c8[_0x5d339e][_0xf977('0x75')]?_[_0xf977('0x76')](_0x15453e[_0x5183c8[_0x5d339e][_0xf977('0x75')]],'%s',_0x1bf08f):_0x1bf08f;_0x1bf08f=_0x5183c8[_0x5d339e][_0xf977('0x77')]?_[_0xf977('0x76')](_0x21b170[_0x5183c8[_0x5d339e][_0xf977('0x77')]],'%s',_0x1bf08f):_0x1bf08f;if(_0x5183c8[_0x5d339e][_0xf977('0x78')]){_0x24d520[_0xf977('0x68')](_0x1bf08f);}_0x5183c8[_0x5d339e]['orderBy']&&_0x24d520[_0xf977('0x39')](_0x1bf08f,_0x5183c8[_0x5d339e]['orderBy']==='DESC'?![]:!![]);_0x24d520[_0xf977('0x69')](_0x1bf08f,_0x5183c8[_0x5d339e][_0xf977('0x79')]||_0x1bf08f);}if(_0x546d1f[_0xf977('0x7a')]){_0x546d1f['joins']=JSON[_0xf977('0x7b')](_0x546d1f['joins']);for(var _0x1ee1fe=0x0;_0x1ee1fe<_0x546d1f[_0xf977('0x7a')][_0xf977('0x48')];_0x1ee1fe+=0x1){if(_0x546d1f[_0xf977('0x7a')][_0x1ee1fe]['type']&&_['includes'](_0x152f8f,_0x546d1f[_0xf977('0x7a')][_0x1ee1fe][_0xf977('0x3e')])&&_0x546d1f['joins'][_0x1ee1fe]['parentKey']&&_0x546d1f[_0xf977('0x7a')][_0x1ee1fe][_0xf977('0x7c')]&&_0x546d1f['joins'][_0x1ee1fe][_0xf977('0x7d')]){_0x24d520[_0x546d1f[_0xf977('0x7a')][_0x1ee1fe][_0xf977('0x3e')]](_0x546d1f[_0xf977('0x7a')][_0x1ee1fe][_0xf977('0x7c')],null,util['format'](_0xf977('0x7e'),_0x546d1f[_0xf977('0x72')],_0x546d1f['joins'][_0x1ee1fe]['parentKey'],_0x546d1f[_0xf977('0x7a')][_0x1ee1fe][_0xf977('0x7c')],_0x546d1f[_0xf977('0x7a')][_0x1ee1fe]['foreignKey']));}}}if(_0x546d1f[_0xf977('0x7f')]){_0x546d1f[_0xf977('0x7f')]=JSON['parse'](_0x546d1f[_0xf977('0x7f')]);_0x24d520[_0xf977('0x3b')](_0x19394b(_0x546d1f['conditions'][_0xf977('0x68')]));}_0x357350=_0x24d520[_0xf977('0x80')]();_0x24d520[_0xf977('0x38')](_0x2fef31);_0x24d520[_0xf977('0x1d')](0x0);logger['debug'](_0xf977('0x81'),_0x24d520[_0xf977('0x82')]());return dbH['sequelize'][_0xf977('0x33')](_0x24d520[_0xf977('0x82')](),{'type':dbH[_0xf977('0x83')][_0xf977('0x84')]['SELECT']});}})[_0xf977('0x24')](respondWithResult(_0x439cc4,null))[_0xf977('0x44')](handleError(_0x439cc4,null));};function runReport(_0x3ce7ed,_0x4f9ae7,_0x19594f){var _0x4ee3e6=_0x4f9ae7[_0xf977('0x2a')];var _0x2b8424=0xa;var _0x238246=[_0xf977('0x56'),_0xf977('0x85'),_0xf977('0x86'),_0xf977('0x57')];var _0x223f58={'SUM':_0xf977('0x87'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0xf977('0x88'),'MAX':'MAX(%s)','MIN':_0xf977('0x5a'),'AVG':_0xf977('0x5b'),'GROUP_CONCAT':_0xf977('0x89'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0xf977('0x5d')};var _0x432b7d={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0xf977('0x8a'),'HOUR':'HOUR(%s)','ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0xf977('0x8b')};var _0x48c641=function(_0x2907d8){return!_[_0xf977('0x61')]([_0xf977('0x62'),_0xf977('0x63'),_0xf977('0x64'),_0xf977('0x65')],_0x2907d8);};var _0xd4f620=function(_0x308d82){if(!_0x308d82||!_0x308d82['rules']['length']){return'';}for(var _0x3e44a5='(',_0x776cea=0x0;_0x776cea<_0x308d82['rules'][_0xf977('0x48')];_0x776cea+=0x1){_0x776cea>0x0&&(_0x3e44a5+='\x20'+_0x308d82[_0xf977('0x67')]+'\x20');_0x3e44a5+=_0x308d82[_0xf977('0x66')][_0x776cea][_0xf977('0x68')]?_0xd4f620(_0x308d82[_0xf977('0x66')][_0x776cea][_0xf977('0x68')]):_0x308d82[_0xf977('0x66')][_0x776cea]['field']+'\x20'+_0x308d82[_0xf977('0x66')][_0x776cea][_0xf977('0x6a')]+(_0x48c641(_0x308d82['rules'][_0x776cea][_0xf977('0x6a')])?'\x20'+_0x308d82[_0xf977('0x66')][_0x776cea][_0xf977('0x8c')]:'');}return _0x3e44a5+')';};var _0x2cae22={'where':{'id':_0x3ce7ed['id']}},_0x3b599c,_0x374557,_0x20bce8,_0x4ed1a8,_0x2030a3;_0x2cae22=_[_0xf977('0x3d')]({},_0x2cae22,_0x19594f);return db[_0xf977('0x2d')][_0xf977('0x4a')](_0x2cae22)[_0xf977('0x24')](function(_0x2b8dd8){if(_0x2b8dd8){_0x3b599c=_0x2b8dd8;return _0x2b8dd8[_0xf977('0x6b')]();}return null;})[_0xf977('0x24')](function(_0xe2c2b9){if(_0xe2c2b9){if(!_0xe2c2b9[_0xf977('0x48')]){throw new db[(_0xf977('0x6c'))][(_0xf977('0x6d'))](_0xf977('0x6e'),0x193);}_0x374557=_0xe2c2b9;return db[_0xf977('0x6f')]['findAll']({'raw':!![]});}return null;})['then'](function(_0x2dff45){if(_0x2dff45){_0x20bce8=_[_0xf977('0x70')](_0x2dff45,'id');var _0x5e5338;var _0x592d17=squel['select']();_0x592d17[_0xf977('0x71')](_0x3b599c[_0xf977('0x72')]);for(var _0x57937c=0x0;_0x57937c<_0x374557[_0xf977('0x48')];_0x57937c+=0x1){_0x5e5338=_0x374557[_0x57937c][_0xf977('0x73')]?_0x20bce8[_0x374557[_0x57937c][_0xf977('0x73')]]['metric']:_0x374557[_0x57937c]['field'];_0x5e5338=_0x374557[_0x57937c][_0xf977('0x75')]?_['replace'](_0x223f58[_0x374557[_0x57937c][_0xf977('0x75')]],'%s',_0x5e5338):_0x5e5338;_0x5e5338=_0x374557[_0x57937c][_0xf977('0x77')]?_[_0xf977('0x76')](_0x432b7d[_0x374557[_0x57937c][_0xf977('0x77')]],'%s',_0x5e5338):_0x5e5338;if(_0x374557[_0x57937c][_0xf977('0x78')]){_0x592d17[_0xf977('0x68')](_0x5e5338);}_0x374557[_0x57937c][_0xf977('0x8d')]&&_0x592d17[_0xf977('0x39')](_0x5e5338,_0x374557[_0x57937c][_0xf977('0x8d')]===_0xf977('0x8e')?![]:!![]);_0x592d17['field'](_0x5e5338,_0x374557[_0x57937c][_0xf977('0x79')]||_0x5e5338);}if(_0x3b599c[_0xf977('0x7a')]){_0x3b599c['joins']=JSON[_0xf977('0x7b')](_0x3b599c[_0xf977('0x7a')]);for(var _0x5be54c=0x0;_0x5be54c<_0x3b599c[_0xf977('0x7a')][_0xf977('0x48')];_0x5be54c+=0x1){if(_0x3b599c[_0xf977('0x7a')][_0x5be54c][_0xf977('0x3e')]&&_['includes'](_0x238246,_0x3b599c[_0xf977('0x7a')][_0x5be54c][_0xf977('0x3e')])&&_0x3b599c['joins'][_0x5be54c]['parentKey']&&_0x3b599c['joins'][_0x5be54c]['foreignTable']&&_0x3b599c[_0xf977('0x7a')][_0x5be54c][_0xf977('0x7d')]){_0x592d17[_0x3b599c[_0xf977('0x7a')][_0x5be54c]['type']](_0x3b599c[_0xf977('0x7a')][_0x5be54c][_0xf977('0x7c')],null,util[_0xf977('0x77')](_0xf977('0x7e'),_0x3b599c[_0xf977('0x72')],_0x3b599c[_0xf977('0x7a')][_0x5be54c][_0xf977('0x8f')],_0x3b599c['joins'][_0x5be54c][_0xf977('0x7c')],_0x3b599c[_0xf977('0x7a')][_0x5be54c][_0xf977('0x7d')]));}}}if(_0x3b599c[_0xf977('0x7f')]){_0x3b599c[_0xf977('0x7f')]=JSON[_0xf977('0x7b')](_0x3b599c[_0xf977('0x7f')]);_0x592d17[_0xf977('0x3b')](_0xd4f620(_0x3b599c[_0xf977('0x7f')]['group']));}_0x2030a3=_0x592d17[_0xf977('0x80')]();_0x592d17['limit'](_0x2b8424);_0x592d17[_0xf977('0x1d')](0x0);return;}})[_0xf977('0x24')](function(){if(_0x4f9ae7['output']===_0xf977('0x90')){return null;}var _0x25bd9d=_['merge'](_0x4f9ae7,{'name':_0x4f9ae7[_0xf977('0x91')]||_0x4f9ae7['name']||_0x3b599c['name'],'basename':_0x4ee3e6,'savename':util[_0xf977('0x77')](_0xf977('0x92'),_0x4f9ae7['name']||_0x3b599c[_0xf977('0x2a')],require(_0xf977('0x93'))[_0xf977('0x94')](0x4),_0x4f9ae7[_0xf977('0x95')]||_0xf977('0x96')),'reportId':_0x3b599c['id'],'reportType':_0xf977('0x97')});return db[_0xf977('0x98')][_0xf977('0x4b')](_0x25bd9d,{'raw':!![]});})['then'](function(_0x4c8086){if(_0x3b599c[_0xf977('0x72')]==='cdr'){_0x2030a3[_0xf977('0x3b')](_0x3b599c[_0xf977('0x72')]+_0xf977('0x99'),_0x4f9ae7[_0xf977('0x9a')],_0x4f9ae7[_0xf977('0x9b')]);}else{_0x2030a3[_0xf977('0x3b')](_0x3b599c[_0xf977('0x72')]+_0xf977('0x9c'),_0x4f9ae7[_0xf977('0x9a')],_0x4f9ae7[_0xf977('0x9b')]);}if(_0x4c8086){logger[_0xf977('0x9d')](_0xf977('0x9e'),_0x2030a3[_0xf977('0x82')]());require(_0xf977('0x9f'))['fork'](path[_0xf977('0x56')](__dirname,'../../components/export/',_0x4c8086[_0xf977('0x95')]),[_0x4c8086['id'],_0x2030a3['toString'](),path[_0xf977('0x56')](__dirname,'../../files/reports',_0x4c8086[_0xf977('0xa0')]),_0x4ee3e6]);return _0x4c8086;}else{var _0x211c94=squel[_0xf977('0xa1')]();_0x211c94['from']('('+_0x2030a3[_0xf977('0x82')]()+')','countTable');_0x211c94[_0xf977('0x69')](_0xf977('0xa2'),'count');_0x2030a3[_0xf977('0x38')](_0x4f9ae7[_0xf977('0x38')]||_0x2b8424);_0x2030a3[_0xf977('0x1d')](_0x4f9ae7[_0xf977('0x1d')]||0x0);return dbH[_0xf977('0x83')][_0xf977('0x33')](_0x211c94['toString'](),{'type':dbH[_0xf977('0x83')]['QueryTypes'][_0xf977('0xa3')]})[_0xf977('0x24')](function(_0x5e5adc){if(!_0x5e5adc[_0xf977('0x48')]){_0x4ed1a8=0x0;}else{_0x4ed1a8=_0x5e5adc[0x0][_0xf977('0x41')]||0x0;}return dbH[_0xf977('0x83')]['query'](_0x2030a3[_0xf977('0x82')](),{'type':dbH['sequelize'][_0xf977('0x84')][_0xf977('0xa3')]});})['then'](function(_0x8bf85c){return{'rows':_0x8bf85c||[],'count':_0x4ed1a8};});}});}exports[_0xf977('0xa4')]=function(_0x392b7a,_0x576fc8){return runReport(_0x392b7a['params'],_0x392b7a[_0xf977('0x33')],_0x392b7a[_0xf977('0x40')])['then'](respondWithResult(_0x576fc8,null))[_0xf977('0x44')](handleError(_0x576fc8,null));};exports[_0xf977('0xa5')]=runReport;exports['query']=function(_0x1f0088,_0x460a3f){var _0x478c30=0xa;var _0x5db39f=[_0xf977('0x56'),_0xf977('0x85'),_0xf977('0x86'),_0xf977('0x57')];var _0x45a51a={'SUM':'SUM(%s)','COUNT':_0xf977('0x58'),'COUNT DISTINCT':_0xf977('0x88'),'MAX':_0xf977('0x59'),'MIN':_0xf977('0x5a'),'AVG':'AVG(%s)','GROUP_CONCAT':_0xf977('0x89'),'GROUP_CONCAT ASC':_0xf977('0x5c'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x42070a={'SEC_TO_TIME':_0xf977('0x5e'),'DATE':'DATE(%s)','HOUR':_0xf977('0x5f'),'ROUND':_0xf977('0x60'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x3e0148=function(_0x524c2e){return!_[_0xf977('0x61')]([_0xf977('0x62'),_0xf977('0x63'),'IS\x20EMPTY',_0xf977('0x65')],_0x524c2e);};var _0x5729f5=function(_0x430575){if(!_0x430575||!_0x430575['rules']['length']){return'';}for(var _0x10f8a2='(',_0x461603=0x0;_0x461603<_0x430575[_0xf977('0x66')]['length'];_0x461603+=0x1){_0x461603>0x0&&(_0x10f8a2+='\x20'+_0x430575[_0xf977('0x67')]+'\x20');_0x10f8a2+=_0x430575[_0xf977('0x66')][_0x461603][_0xf977('0x68')]?_0x5729f5(_0x430575['rules'][_0x461603][_0xf977('0x68')]):_0x430575['rules'][_0x461603][_0xf977('0x69')]+'\x20'+_0x430575[_0xf977('0x66')][_0x461603][_0xf977('0x6a')]+(_0x3e0148(_0x430575['rules'][_0x461603][_0xf977('0x6a')])?'\x20'+_0x430575['rules'][_0x461603]['value']:'');}return _0x10f8a2+')';};var _0x559c4a={'where':{'id':_0x1f0088[_0xf977('0x45')]['id']}},_0x2acfdd,_0x16f072,_0x4266af,_0x44e60,_0x3195c9;_0x559c4a=_[_0xf977('0x3d')]({},_0x559c4a,_0x1f0088['options']);return db[_0xf977('0x2d')][_0xf977('0x4a')](_0x559c4a)[_0xf977('0x24')](function(_0x56839){if(_0x56839){_0x2acfdd=_0x56839;return _0x56839[_0xf977('0x6b')]();}return null;})[_0xf977('0x24')](function(_0x25a8e6){if(_0x25a8e6){if(!_0x25a8e6[_0xf977('0x48')]){throw new db['Sequelize'][(_0xf977('0x6d'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x16f072=_0x25a8e6;return db['AnalyticMetric'][_0xf977('0xa6')]({'raw':!![]});}return null;})[_0xf977('0x24')](function(_0x1554d3){if(_0x1554d3){_0x4266af=_[_0xf977('0x70')](_0x1554d3,'id');var _0x7a9048;var _0x3345cf=squel[_0xf977('0xa1')]();_0x3345cf['from'](_0x2acfdd['table']);for(var _0x53c86f=0x0;_0x53c86f<_0x16f072['length'];_0x53c86f+=0x1){_0x7a9048=_0x16f072[_0x53c86f][_0xf977('0x73')]?_0x4266af[_0x16f072[_0x53c86f]['MetricId']][_0xf977('0x74')]:_0x16f072[_0x53c86f][_0xf977('0x69')];_0x7a9048=_0x16f072[_0x53c86f]['function']?_[_0xf977('0x76')](_0x45a51a[_0x16f072[_0x53c86f][_0xf977('0x75')]],'%s',_0x7a9048):_0x7a9048;_0x7a9048=_0x16f072[_0x53c86f][_0xf977('0x77')]?_['replace'](_0x42070a[_0x16f072[_0x53c86f][_0xf977('0x77')]],'%s',_0x7a9048):_0x7a9048;if(_0x16f072[_0x53c86f][_0xf977('0x78')]){_0x3345cf[_0xf977('0x68')](_0x7a9048);}_0x16f072[_0x53c86f][_0xf977('0x8d')]&&_0x3345cf[_0xf977('0x39')](_0x7a9048,_0x16f072[_0x53c86f][_0xf977('0x8d')]==='DESC'?![]:!![]);_0x3345cf['field'](_0x7a9048,_0x16f072[_0x53c86f][_0xf977('0x79')]||_0x7a9048);}if(_0x2acfdd[_0xf977('0x7a')]){_0x2acfdd[_0xf977('0x7a')]=JSON[_0xf977('0x7b')](_0x2acfdd[_0xf977('0x7a')]);for(var _0x3b62ba=0x0;_0x3b62ba<_0x2acfdd[_0xf977('0x7a')][_0xf977('0x48')];_0x3b62ba+=0x1){if(_0x2acfdd[_0xf977('0x7a')][_0x3b62ba]['type']&&_[_0xf977('0x61')](_0x5db39f,_0x2acfdd[_0xf977('0x7a')][_0x3b62ba][_0xf977('0x3e')])&&_0x2acfdd[_0xf977('0x7a')][_0x3b62ba][_0xf977('0x8f')]&&_0x2acfdd[_0xf977('0x7a')][_0x3b62ba][_0xf977('0x7c')]&&_0x2acfdd[_0xf977('0x7a')][_0x3b62ba][_0xf977('0x7d')]){_0x3345cf[_0x2acfdd[_0xf977('0x7a')][_0x3b62ba]['type']](_0x2acfdd[_0xf977('0x7a')][_0x3b62ba]['foreignTable'],null,util['format'](_0xf977('0x7e'),_0x2acfdd[_0xf977('0x72')],_0x2acfdd[_0xf977('0x7a')][_0x3b62ba][_0xf977('0x8f')],_0x2acfdd[_0xf977('0x7a')][_0x3b62ba][_0xf977('0x7c')],_0x2acfdd['joins'][_0x3b62ba][_0xf977('0x7d')]));}}}if(_0x2acfdd[_0xf977('0x7f')]){_0x2acfdd['conditions']=JSON[_0xf977('0x7b')](_0x2acfdd['conditions']);_0x3345cf[_0xf977('0x3b')](_0x5729f5(_0x2acfdd['conditions'][_0xf977('0x68')]));}_0x3195c9=_0x3345cf['clone']();_0x3345cf[_0xf977('0x38')](_0x478c30);_0x3345cf['offset'](0x0);logger[_0xf977('0xa7')](_0xf977('0x81'),_0x3345cf[_0xf977('0x82')]());return dbH[_0xf977('0x83')][_0xf977('0x33')](_0x3345cf[_0xf977('0x82')](),{'type':dbH[_0xf977('0x83')]['QueryTypes'][_0xf977('0xa3')]});}})['then'](function(){return{'sql':_0x3195c9[_0xf977('0x82')]()};})[_0xf977('0x24')](respondWithResult(_0x460a3f,null))[_0xf977('0x44')](handleError(_0x460a3f,null));};
\ No newline at end of file
+var _0xc8f1=['../../components/parsers/advancedSearch','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','dbH','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','update','then','get','CustomReports','UserProfileResource','destroy','error','name','send','index','map','type','key','model','query','keys','filters','intersection','fields','attributes','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','options','includeAll','AnalyticCustomReport','rows','catch','show','rawAttributes','length','include','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','preview','join','left_join','right_join','cross_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','DATE(%s)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','group','field','condition','value','params','getFields','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','findAll','keyBy','select','table','MetricId','metric','function','format','replace','groupBy','orderBy','alias','joins','parse','parentKey','foreignTable','foreignKey','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','SEC_TO_TIME(%s)','includes','Sequelize','DESC','%s.%s\x20=\x20%s.%s','output','web','fullPath','randomstring','generate','csv','custom','cdr','endDate','startDate','info','Run\x20Query:','child_process','../../components/export/','savename','from','countTable','COUNT(*)','run','runReport','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs'];(function(_0x17f928,_0x5b3e05){var _0x35f22b=function(_0x55b336){while(--_0x55b336){_0x17f928['push'](_0x17f928['shift']());}};_0x35f22b(++_0x5b3e05);}(_0xc8f1,0x13a));var _0x1c8f=function(_0x14a1c8,_0x17772b){_0x14a1c8=_0x14a1c8-0x0;var _0x2311b2=_0xc8f1[_0x14a1c8];return _0x2311b2;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x1c8f('0x0'));var zipdir=require(_0x1c8f('0x1'));var jsonpatch=require(_0x1c8f('0x2'));var rp=require(_0x1c8f('0x3'));var moment=require(_0x1c8f('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x1c8f('0x5'));var util=require(_0x1c8f('0x6'));var path=require(_0x1c8f('0x7'));var sox=require(_0x1c8f('0x8'));var csv=require(_0x1c8f('0x9'));var ejs=require(_0x1c8f('0xa'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x1c8f('0xb'));var squel=require(_0x1c8f('0xc'));var crypto=require(_0x1c8f('0xd'));var jsforce=require(_0x1c8f('0xe'));var deskjs=require(_0x1c8f('0xf'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x1c8f('0x10'));var Redis=require(_0x1c8f('0x11'));var authService=require(_0x1c8f('0x12'));var qs=require(_0x1c8f('0x13'));var as=require(_0x1c8f('0x14'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x1c8f('0x15'))(_0x1c8f('0x16'));var utils=require('../../config/utils');var config=require(_0x1c8f('0x17'));var licenseUtil=require(_0x1c8f('0x18'));var db=require('../../mysqldb')['db'];var dbH=require(_0x1c8f('0x19'))[_0x1c8f('0x1a')];function respondWithStatusCode(_0x1983c3,_0x1e6b7d){_0x1e6b7d=_0x1e6b7d||0xcc;return function(_0x5c9821){if(_0x5c9821){return _0x1983c3[_0x1c8f('0x1b')](_0x1e6b7d);}return _0x1983c3[_0x1c8f('0x1c')](_0x1e6b7d)[_0x1c8f('0x1d')]();};}function respondWithResult(_0x5aef5b,_0x346b88){_0x346b88=_0x346b88||0xc8;return function(_0x780b30){if(_0x780b30){return _0x5aef5b[_0x1c8f('0x1c')](_0x346b88)[_0x1c8f('0x1e')](_0x780b30);}};}function respondWithFilteredResult(_0x40010f,_0x42206){return function(_0x454f9b){if(_0x454f9b){var _0x14eb46=typeof _0x42206[_0x1c8f('0x1f')]===_0x1c8f('0x20')&&typeof _0x42206[_0x1c8f('0x21')]===_0x1c8f('0x20');var _0x5f1426=_0x454f9b[_0x1c8f('0x22')];var _0x2105ba=_0x14eb46?0x0:_0x42206[_0x1c8f('0x1f')];var _0x11e167=_0x14eb46?_0x454f9b['count']:_0x42206[_0x1c8f('0x1f')]+_0x42206[_0x1c8f('0x21')];var _0x505346;if(_0x11e167>=_0x5f1426){_0x11e167=_0x5f1426;_0x505346=0xc8;}else{_0x505346=0xce;}_0x40010f[_0x1c8f('0x1c')](_0x505346);return _0x40010f[_0x1c8f('0x23')](_0x1c8f('0x24'),_0x2105ba+'-'+_0x11e167+'/'+_0x5f1426)['json'](_0x454f9b);}return null;};}function patchUpdates(_0x385e2e){return function(_0x499cf2){try{jsonpatch[_0x1c8f('0x25')](_0x499cf2,_0x385e2e,!![]);}catch(_0x36f133){return BPromise['reject'](_0x36f133);}return _0x499cf2['save']();};}function saveUpdates(_0xaa36f6,_0xf68937){return function(_0x1ade50){if(_0x1ade50){return _0x1ade50[_0x1c8f('0x26')](_0xaa36f6)['then'](function(_0x18fe7c){return _0x18fe7c;});}return null;};}function removeEntity(_0x4ccd17,_0xc089e8){return function(_0x479669){if(_0x479669){return _0x479669['destroy']()[_0x1c8f('0x27')](function(){var _0x790a63=_0x479669[_0x1c8f('0x28')]({'plain':!![]});var _0x36d680=_0x1c8f('0x29');return db[_0x1c8f('0x2a')][_0x1c8f('0x2b')]({'where':{'type':_0x36d680,'resourceId':_0x790a63['id']}})[_0x1c8f('0x27')](function(){return _0x479669;});})[_0x1c8f('0x27')](function(){_0x4ccd17[_0x1c8f('0x1c')](0xcc)[_0x1c8f('0x1d')]();});}};}function handleEntityNotFound(_0x14a839,_0xa53a1a){return function(_0x1a27c9){if(!_0x1a27c9){_0x14a839[_0x1c8f('0x1b')](0x194);}return _0x1a27c9;};}function handleError(_0x86ed49,_0x3815d5){_0x3815d5=_0x3815d5||0x1f4;return function(_0x7031ca){logger[_0x1c8f('0x2c')](_0x7031ca['stack']);if(_0x7031ca[_0x1c8f('0x2d')]){delete _0x7031ca[_0x1c8f('0x2d')];}_0x86ed49['status'](_0x3815d5)[_0x1c8f('0x2e')](_0x7031ca);};}exports[_0x1c8f('0x2f')]=function(_0x51f87d,_0x10d441){var _0x50722b={},_0x247412={},_0x4fb489={'count':0x0,'rows':[]};var _0x2cc94b=_[_0x1c8f('0x30')](db['AnalyticCustomReport']['rawAttributes'],function(_0x2ef1c5){return{'name':_0x2ef1c5['fieldName'],'type':_0x2ef1c5[_0x1c8f('0x31')][_0x1c8f('0x32')]};});_0x247412[_0x1c8f('0x33')]=_[_0x1c8f('0x30')](_0x2cc94b,'name');_0x247412[_0x1c8f('0x34')]=_[_0x1c8f('0x35')](_0x51f87d['query']);_0x247412[_0x1c8f('0x36')]=_[_0x1c8f('0x37')](_0x247412[_0x1c8f('0x33')],_0x247412['query']);_0x50722b['attributes']=_[_0x1c8f('0x37')](_0x247412[_0x1c8f('0x33')],qs[_0x1c8f('0x38')](_0x51f87d[_0x1c8f('0x34')][_0x1c8f('0x38')]));_0x50722b['attributes']=_0x50722b[_0x1c8f('0x39')]['length']?_0x50722b['attributes']:_0x247412[_0x1c8f('0x33')];if(!_0x51f87d['query']['hasOwnProperty'](_0x1c8f('0x3a'))){_0x50722b[_0x1c8f('0x21')]=qs[_0x1c8f('0x21')](_0x51f87d[_0x1c8f('0x34')]['limit']);_0x50722b[_0x1c8f('0x1f')]=qs['offset'](_0x51f87d[_0x1c8f('0x34')][_0x1c8f('0x1f')]);}_0x50722b[_0x1c8f('0x3b')]=qs[_0x1c8f('0x3c')](_0x51f87d[_0x1c8f('0x34')][_0x1c8f('0x3c')]);_0x50722b[_0x1c8f('0x3d')]=qs['filters'](_[_0x1c8f('0x3e')](_0x51f87d[_0x1c8f('0x34')],_0x247412[_0x1c8f('0x36')]),_0x2cc94b);if(_0x51f87d[_0x1c8f('0x34')][_0x1c8f('0x3f')]){_0x50722b['where']=_[_0x1c8f('0x40')](_0x50722b[_0x1c8f('0x3d')],{'$or':_['map'](_0x2cc94b,function(_0x40ad55){if(_0x40ad55[_0x1c8f('0x31')]!==_0x1c8f('0x41')){var _0x5472ca={};_0x5472ca[_0x40ad55[_0x1c8f('0x2d')]]={'$like':'%'+_0x51f87d[_0x1c8f('0x34')][_0x1c8f('0x3f')]+'%'};return _0x5472ca;}})});}_0x50722b=_[_0x1c8f('0x40')]({},_0x50722b,_0x51f87d[_0x1c8f('0x42')]);var _0x12473a={'where':_0x50722b['where']};return db['AnalyticCustomReport']['count'](_0x12473a)[_0x1c8f('0x27')](function(_0x172a97){_0x4fb489[_0x1c8f('0x22')]=_0x172a97;if(_0x51f87d[_0x1c8f('0x34')][_0x1c8f('0x43')]){_0x50722b['include']=[{'all':!![]}];}return db[_0x1c8f('0x44')]['findAll'](_0x50722b);})[_0x1c8f('0x27')](function(_0x8a849b){_0x4fb489[_0x1c8f('0x45')]=_0x8a849b;return _0x4fb489;})['then'](respondWithFilteredResult(_0x10d441,_0x50722b))[_0x1c8f('0x46')](handleError(_0x10d441,null));};exports[_0x1c8f('0x47')]=function(_0x5399a7,_0x295c0a){var _0x17f54a={'raw':![],'where':{'id':_0x5399a7['params']['id']}},_0x1a2039={};_0x1a2039[_0x1c8f('0x33')]=_[_0x1c8f('0x35')](db['AnalyticCustomReport'][_0x1c8f('0x48')]);_0x1a2039[_0x1c8f('0x34')]=_[_0x1c8f('0x35')](_0x5399a7[_0x1c8f('0x34')]);_0x1a2039[_0x1c8f('0x36')]=_['intersection'](_0x1a2039[_0x1c8f('0x33')],_0x1a2039[_0x1c8f('0x34')]);_0x17f54a['attributes']=_[_0x1c8f('0x37')](_0x1a2039[_0x1c8f('0x33')],qs[_0x1c8f('0x38')](_0x5399a7[_0x1c8f('0x34')]['fields']));_0x17f54a['attributes']=_0x17f54a[_0x1c8f('0x39')][_0x1c8f('0x49')]?_0x17f54a[_0x1c8f('0x39')]:_0x1a2039['model'];if(_0x5399a7[_0x1c8f('0x34')][_0x1c8f('0x43')]){_0x17f54a[_0x1c8f('0x4a')]=[{'all':!![]}];}_0x17f54a=_[_0x1c8f('0x40')]({},_0x17f54a,_0x5399a7[_0x1c8f('0x42')]);return db['AnalyticCustomReport'][_0x1c8f('0x4b')](_0x17f54a)['then'](handleEntityNotFound(_0x295c0a,null))[_0x1c8f('0x27')](respondWithResult(_0x295c0a,null))['catch'](handleError(_0x295c0a,null));};exports[_0x1c8f('0x4c')]=function(_0x43c15d,_0x256cde){return db[_0x1c8f('0x44')][_0x1c8f('0x4c')](_0x43c15d[_0x1c8f('0x4d')],{})[_0x1c8f('0x27')](function(_0x242362){var _0x1f58db=_0x43c15d[_0x1c8f('0x4e')][_0x1c8f('0x28')]({'plain':!![]});if(!_0x1f58db)throw new Error(_0x1c8f('0x4f'));if(_0x1f58db[_0x1c8f('0x50')]===_0x1c8f('0x4e')){var _0x405fd3=_0x242362[_0x1c8f('0x28')]({'plain':!![]});var _0x240029='Reports';return db[_0x1c8f('0x51')]['find']({'where':{'name':_0x240029,'userProfileId':_0x1f58db[_0x1c8f('0x52')]},'raw':!![]})[_0x1c8f('0x27')](function(_0xd36713){if(_0xd36713&&_0xd36713[_0x1c8f('0x53')]===0x0){return db[_0x1c8f('0x2a')][_0x1c8f('0x4c')]({'name':_0x405fd3[_0x1c8f('0x2d')],'resourceId':_0x405fd3['id'],'type':_0x1c8f('0x29'),'sectionId':_0xd36713['id']},{})[_0x1c8f('0x27')](function(){return _0x242362;});}else{return _0x242362;}})[_0x1c8f('0x46')](function(_0x167662){logger[_0x1c8f('0x2c')](_0x1c8f('0x54'),_0x167662);throw _0x167662;});}return _0x242362;})[_0x1c8f('0x27')](respondWithResult(_0x256cde,0xc9))['catch'](handleError(_0x256cde,null));};exports['update']=function(_0x1f4363,_0x5184bf){if(_0x1f4363['body']['id']){delete _0x1f4363[_0x1c8f('0x4d')]['id'];}return db[_0x1c8f('0x44')]['find']({'where':{'id':_0x1f4363['params']['id']}})[_0x1c8f('0x27')](handleEntityNotFound(_0x5184bf,null))[_0x1c8f('0x27')](saveUpdates(_0x1f4363[_0x1c8f('0x4d')],null))[_0x1c8f('0x27')](respondWithResult(_0x5184bf,null))['catch'](handleError(_0x5184bf,null));};exports['destroy']=function(_0x538b38,_0x5a66b2){return db[_0x1c8f('0x44')][_0x1c8f('0x4b')]({'where':{'id':_0x538b38['params']['id']}})[_0x1c8f('0x27')](handleEntityNotFound(_0x5a66b2,null))['then'](removeEntity(_0x5a66b2,null))[_0x1c8f('0x46')](handleError(_0x5a66b2,null));};exports[_0x1c8f('0x55')]=function(_0x19190b,_0x37d119){var _0x4aeafc=0xa;var _0x4e26af=[_0x1c8f('0x56'),_0x1c8f('0x57'),_0x1c8f('0x58'),_0x1c8f('0x59')];var _0x3357e5={'SUM':_0x1c8f('0x5a'),'COUNT':_0x1c8f('0x5b'),'COUNT DISTINCT':_0x1c8f('0x5c'),'MAX':_0x1c8f('0x5d'),'MIN':_0x1c8f('0x5e'),'AVG':_0x1c8f('0x5f'),'GROUP_CONCAT':_0x1c8f('0x60'),'GROUP_CONCAT ASC':_0x1c8f('0x61'),'GROUP_CONCAT DESC':_0x1c8f('0x62')};var _0x514021={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x1c8f('0x63'),'HOUR':_0x1c8f('0x64'),'ROUND':_0x1c8f('0x65'),'UNIX_TIMESTAMP':_0x1c8f('0x66')};var _0x4a3813=function(_0x198f36){return!_['includes']([_0x1c8f('0x67'),_0x1c8f('0x68'),_0x1c8f('0x69'),_0x1c8f('0x6a')],_0x198f36);};var _0x219cbb=function(_0x5f092e){if(!_0x5f092e||!_0x5f092e['rules'][_0x1c8f('0x49')]){return'';}for(var _0x5d5c04='(',_0x1d23e9=0x0;_0x1d23e9<_0x5f092e[_0x1c8f('0x6b')][_0x1c8f('0x49')];_0x1d23e9+=0x1){_0x1d23e9>0x0&&(_0x5d5c04+='\x20'+_0x5f092e['operator']+'\x20');_0x5d5c04+=_0x5f092e['rules'][_0x1d23e9]['group']?_0x219cbb(_0x5f092e[_0x1c8f('0x6b')][_0x1d23e9][_0x1c8f('0x6c')]):_0x5f092e[_0x1c8f('0x6b')][_0x1d23e9][_0x1c8f('0x6d')]+'\x20'+_0x5f092e['rules'][_0x1d23e9][_0x1c8f('0x6e')]+(_0x4a3813(_0x5f092e[_0x1c8f('0x6b')][_0x1d23e9]['condition'])?'\x20'+_0x5f092e[_0x1c8f('0x6b')][_0x1d23e9][_0x1c8f('0x6f')]:'');}return _0x5d5c04+')';};var _0x5f3f6c={'where':{'id':_0x19190b[_0x1c8f('0x70')]['id']}},_0x2a705b,_0x577dae,_0x2c11da,_0x495036,_0x4f9d31;_0x5f3f6c=_[_0x1c8f('0x40')]({},_0x5f3f6c,_0x19190b['options']);return db[_0x1c8f('0x44')]['find'](_0x5f3f6c)[_0x1c8f('0x27')](function(_0xdb57be){if(_0xdb57be){_0x2a705b=_0xdb57be;return _0xdb57be[_0x1c8f('0x71')]();}return null;})[_0x1c8f('0x27')](function(_0x2d95bf){if(_0x2d95bf){if(!_0x2d95bf[_0x1c8f('0x49')]){throw new db['Sequelize'][(_0x1c8f('0x72'))](_0x1c8f('0x73'),0x193);}_0x577dae=_0x2d95bf;return db[_0x1c8f('0x74')][_0x1c8f('0x75')]({'raw':!![]});}return null;})[_0x1c8f('0x27')](function(_0x56623f){if(_0x56623f){_0x2c11da=_[_0x1c8f('0x76')](_0x56623f,'id');var _0xa6911a;var _0x50bf08=squel[_0x1c8f('0x77')]();_0x50bf08['from'](_0x2a705b[_0x1c8f('0x78')]);for(var _0x589d91=0x0;_0x589d91<_0x577dae[_0x1c8f('0x49')];_0x589d91+=0x1){_0xa6911a=_0x577dae[_0x589d91][_0x1c8f('0x79')]?_0x2c11da[_0x577dae[_0x589d91][_0x1c8f('0x79')]][_0x1c8f('0x7a')]:_0x577dae[_0x589d91]['field'];_0xa6911a=_0x577dae[_0x589d91][_0x1c8f('0x7b')]?_['replace'](_0x3357e5[_0x577dae[_0x589d91][_0x1c8f('0x7b')]],'%s',_0xa6911a):_0xa6911a;_0xa6911a=_0x577dae[_0x589d91][_0x1c8f('0x7c')]?_[_0x1c8f('0x7d')](_0x514021[_0x577dae[_0x589d91]['format']],'%s',_0xa6911a):_0xa6911a;if(_0x577dae[_0x589d91][_0x1c8f('0x7e')]){_0x50bf08[_0x1c8f('0x6c')](_0xa6911a);}_0x577dae[_0x589d91][_0x1c8f('0x7f')]&&_0x50bf08[_0x1c8f('0x3b')](_0xa6911a,_0x577dae[_0x589d91]['orderBy']==='DESC'?![]:!![]);_0x50bf08['field'](_0xa6911a,_0x577dae[_0x589d91][_0x1c8f('0x80')]||_0xa6911a);}if(_0x2a705b['joins']){_0x2a705b[_0x1c8f('0x81')]=JSON[_0x1c8f('0x82')](_0x2a705b[_0x1c8f('0x81')]);for(var _0x18407e=0x0;_0x18407e<_0x2a705b['joins'][_0x1c8f('0x49')];_0x18407e+=0x1){if(_0x2a705b[_0x1c8f('0x81')][_0x18407e][_0x1c8f('0x31')]&&_['includes'](_0x4e26af,_0x2a705b[_0x1c8f('0x81')][_0x18407e]['type'])&&_0x2a705b[_0x1c8f('0x81')][_0x18407e][_0x1c8f('0x83')]&&_0x2a705b[_0x1c8f('0x81')][_0x18407e][_0x1c8f('0x84')]&&_0x2a705b[_0x1c8f('0x81')][_0x18407e][_0x1c8f('0x85')]){_0x50bf08[_0x2a705b[_0x1c8f('0x81')][_0x18407e][_0x1c8f('0x31')]](_0x2a705b[_0x1c8f('0x81')][_0x18407e][_0x1c8f('0x84')],null,util[_0x1c8f('0x7c')]('%s.%s\x20=\x20%s.%s',_0x2a705b['table'],_0x2a705b[_0x1c8f('0x81')][_0x18407e][_0x1c8f('0x83')],_0x2a705b[_0x1c8f('0x81')][_0x18407e][_0x1c8f('0x84')],_0x2a705b['joins'][_0x18407e]['foreignKey']));}}}if(_0x2a705b[_0x1c8f('0x86')]){_0x2a705b[_0x1c8f('0x86')]=JSON[_0x1c8f('0x82')](_0x2a705b['conditions']);_0x50bf08['where'](_0x219cbb(_0x2a705b[_0x1c8f('0x86')][_0x1c8f('0x6c')]));}_0x4f9d31=_0x50bf08[_0x1c8f('0x87')]();_0x50bf08[_0x1c8f('0x21')](_0x4aeafc);_0x50bf08['offset'](0x0);logger[_0x1c8f('0x88')](_0x1c8f('0x89'),_0x50bf08[_0x1c8f('0x8a')]());return dbH[_0x1c8f('0x8b')][_0x1c8f('0x34')](_0x50bf08[_0x1c8f('0x8a')](),{'type':dbH[_0x1c8f('0x8b')][_0x1c8f('0x8c')][_0x1c8f('0x8d')]});}})[_0x1c8f('0x27')](respondWithResult(_0x37d119,null))[_0x1c8f('0x46')](handleError(_0x37d119,null));};function runReport(_0x4a8e68,_0x157e0d,_0x130df1){var _0x569099=_0x157e0d[_0x1c8f('0x2d')];var _0x3ac4a6=0xa;var _0x18193d=[_0x1c8f('0x56'),_0x1c8f('0x57'),_0x1c8f('0x58'),_0x1c8f('0x59')];var _0x562c58={'SUM':_0x1c8f('0x5a'),'COUNT':_0x1c8f('0x5b'),'COUNT DISTINCT':_0x1c8f('0x5c'),'MAX':_0x1c8f('0x5d'),'MIN':'MIN(%s)','AVG':_0x1c8f('0x5f'),'GROUP_CONCAT':_0x1c8f('0x60'),'GROUP_CONCAT ASC':_0x1c8f('0x61'),'GROUP_CONCAT DESC':_0x1c8f('0x62')};var _0x247605={'SEC_TO_TIME':_0x1c8f('0x8e'),'DATE':_0x1c8f('0x63'),'HOUR':_0x1c8f('0x64'),'ROUND':_0x1c8f('0x65'),'UNIX_TIMESTAMP':_0x1c8f('0x66')};var _0x2a2ec5=function(_0x31b827){return!_[_0x1c8f('0x8f')](['IS\x20NULL',_0x1c8f('0x68'),_0x1c8f('0x69'),_0x1c8f('0x6a')],_0x31b827);};var _0x366434=function(_0x4195ad){if(!_0x4195ad||!_0x4195ad[_0x1c8f('0x6b')]['length']){return'';}for(var _0x214fde='(',_0x7e238e=0x0;_0x7e238e<_0x4195ad[_0x1c8f('0x6b')]['length'];_0x7e238e+=0x1){_0x7e238e>0x0&&(_0x214fde+='\x20'+_0x4195ad['operator']+'\x20');_0x214fde+=_0x4195ad['rules'][_0x7e238e][_0x1c8f('0x6c')]?_0x366434(_0x4195ad['rules'][_0x7e238e][_0x1c8f('0x6c')]):_0x4195ad['rules'][_0x7e238e][_0x1c8f('0x6d')]+'\x20'+_0x4195ad['rules'][_0x7e238e][_0x1c8f('0x6e')]+(_0x2a2ec5(_0x4195ad[_0x1c8f('0x6b')][_0x7e238e][_0x1c8f('0x6e')])?'\x20'+_0x4195ad[_0x1c8f('0x6b')][_0x7e238e]['value']:'');}return _0x214fde+')';};var _0x268752={'where':{'id':_0x4a8e68['id']}},_0x502e71,_0x8937e7,_0x258971,_0x241947,_0x608880;_0x268752=_[_0x1c8f('0x40')]({},_0x268752,_0x130df1);return db[_0x1c8f('0x44')][_0x1c8f('0x4b')](_0x268752)[_0x1c8f('0x27')](function(_0x585c6e){if(_0x585c6e){_0x502e71=_0x585c6e;return _0x585c6e[_0x1c8f('0x71')]();}return null;})[_0x1c8f('0x27')](function(_0x3a5461){if(_0x3a5461){if(!_0x3a5461[_0x1c8f('0x49')]){throw new db[(_0x1c8f('0x90'))][(_0x1c8f('0x72'))](_0x1c8f('0x73'),0x193);}_0x8937e7=_0x3a5461;return db[_0x1c8f('0x74')][_0x1c8f('0x75')]({'raw':!![]});}return null;})[_0x1c8f('0x27')](function(_0x3d2ee5){if(_0x3d2ee5){_0x258971=_[_0x1c8f('0x76')](_0x3d2ee5,'id');var _0x2d53b7;var _0x5ab53a=squel[_0x1c8f('0x77')]();_0x5ab53a['from'](_0x502e71[_0x1c8f('0x78')]);for(var _0x3d588d=0x0;_0x3d588d<_0x8937e7['length'];_0x3d588d+=0x1){_0x2d53b7=_0x8937e7[_0x3d588d][_0x1c8f('0x79')]?_0x258971[_0x8937e7[_0x3d588d][_0x1c8f('0x79')]][_0x1c8f('0x7a')]:_0x8937e7[_0x3d588d]['field'];_0x2d53b7=_0x8937e7[_0x3d588d][_0x1c8f('0x7b')]?_[_0x1c8f('0x7d')](_0x562c58[_0x8937e7[_0x3d588d][_0x1c8f('0x7b')]],'%s',_0x2d53b7):_0x2d53b7;_0x2d53b7=_0x8937e7[_0x3d588d][_0x1c8f('0x7c')]?_[_0x1c8f('0x7d')](_0x247605[_0x8937e7[_0x3d588d]['format']],'%s',_0x2d53b7):_0x2d53b7;if(_0x8937e7[_0x3d588d][_0x1c8f('0x7e')]){_0x5ab53a[_0x1c8f('0x6c')](_0x2d53b7);}_0x8937e7[_0x3d588d][_0x1c8f('0x7f')]&&_0x5ab53a[_0x1c8f('0x3b')](_0x2d53b7,_0x8937e7[_0x3d588d][_0x1c8f('0x7f')]===_0x1c8f('0x91')?![]:!![]);_0x5ab53a[_0x1c8f('0x6d')](_0x2d53b7,_0x8937e7[_0x3d588d][_0x1c8f('0x80')]||_0x2d53b7);}if(_0x502e71[_0x1c8f('0x81')]){_0x502e71[_0x1c8f('0x81')]=JSON[_0x1c8f('0x82')](_0x502e71['joins']);for(var _0x2dc75=0x0;_0x2dc75<_0x502e71[_0x1c8f('0x81')]['length'];_0x2dc75+=0x1){if(_0x502e71[_0x1c8f('0x81')][_0x2dc75][_0x1c8f('0x31')]&&_['includes'](_0x18193d,_0x502e71['joins'][_0x2dc75][_0x1c8f('0x31')])&&_0x502e71['joins'][_0x2dc75][_0x1c8f('0x83')]&&_0x502e71[_0x1c8f('0x81')][_0x2dc75][_0x1c8f('0x84')]&&_0x502e71['joins'][_0x2dc75][_0x1c8f('0x85')]){_0x5ab53a[_0x502e71[_0x1c8f('0x81')][_0x2dc75]['type']](_0x502e71['joins'][_0x2dc75][_0x1c8f('0x84')],null,util[_0x1c8f('0x7c')](_0x1c8f('0x92'),_0x502e71[_0x1c8f('0x78')],_0x502e71['joins'][_0x2dc75][_0x1c8f('0x83')],_0x502e71[_0x1c8f('0x81')][_0x2dc75][_0x1c8f('0x84')],_0x502e71['joins'][_0x2dc75][_0x1c8f('0x85')]));}}}if(_0x502e71[_0x1c8f('0x86')]){_0x502e71[_0x1c8f('0x86')]=JSON[_0x1c8f('0x82')](_0x502e71[_0x1c8f('0x86')]);_0x5ab53a['where'](_0x366434(_0x502e71[_0x1c8f('0x86')][_0x1c8f('0x6c')]));}_0x608880=_0x5ab53a['clone']();_0x5ab53a[_0x1c8f('0x21')](_0x3ac4a6);_0x5ab53a[_0x1c8f('0x1f')](0x0);return;}})[_0x1c8f('0x27')](function(){if(_0x157e0d[_0x1c8f('0x93')]===_0x1c8f('0x94')){return null;}var _0x41f5e8=_['merge'](_0x157e0d,{'name':_0x157e0d[_0x1c8f('0x95')]||_0x157e0d[_0x1c8f('0x2d')]||_0x502e71['name'],'basename':_0x569099,'savename':util[_0x1c8f('0x7c')]('%s-%s.%s',_0x157e0d[_0x1c8f('0x2d')]||_0x502e71['name'],require(_0x1c8f('0x96'))[_0x1c8f('0x97')](0x4),_0x157e0d['output']||_0x1c8f('0x98')),'reportId':_0x502e71['id'],'reportType':_0x1c8f('0x99')});return db['AnalyticExtractedReport'][_0x1c8f('0x4c')](_0x41f5e8,{'raw':!![]});})[_0x1c8f('0x27')](function(_0xaefd39){if(_0x502e71[_0x1c8f('0x78')]===_0x1c8f('0x9a')){_0x608880[_0x1c8f('0x3d')](_0x502e71['table']+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x157e0d['startDate'],_0x157e0d[_0x1c8f('0x9b')]);}else{_0x608880[_0x1c8f('0x3d')](_0x502e71[_0x1c8f('0x78')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x157e0d[_0x1c8f('0x9c')],_0x157e0d['endDate']);}if(_0xaefd39){logger[_0x1c8f('0x9d')](_0x1c8f('0x9e'),_0x608880['toString']());require(_0x1c8f('0x9f'))['fork'](path[_0x1c8f('0x56')](__dirname,_0x1c8f('0xa0'),_0xaefd39[_0x1c8f('0x93')]),[_0xaefd39['id'],_0x608880[_0x1c8f('0x8a')](),path[_0x1c8f('0x56')](__dirname,'../../files/reports',_0xaefd39[_0x1c8f('0xa1')]),_0x569099]);return _0xaefd39;}else{var _0x476349=squel[_0x1c8f('0x77')]();_0x476349[_0x1c8f('0xa2')]('('+_0x608880['toString']()+')',_0x1c8f('0xa3'));_0x476349['field'](_0x1c8f('0xa4'),_0x1c8f('0x22'));_0x608880[_0x1c8f('0x21')](_0x157e0d[_0x1c8f('0x21')]||_0x3ac4a6);_0x608880[_0x1c8f('0x1f')](_0x157e0d[_0x1c8f('0x1f')]||0x0);return dbH[_0x1c8f('0x8b')]['query'](_0x476349['toString'](),{'type':dbH['sequelize'][_0x1c8f('0x8c')]['SELECT']})[_0x1c8f('0x27')](function(_0x170c57){if(!_0x170c57[_0x1c8f('0x49')]){_0x241947=0x0;}else{_0x241947=_0x170c57[0x0]['count']||0x0;}return dbH[_0x1c8f('0x8b')][_0x1c8f('0x34')](_0x608880['toString'](),{'type':dbH[_0x1c8f('0x8b')][_0x1c8f('0x8c')][_0x1c8f('0x8d')]});})[_0x1c8f('0x27')](function(_0x1a844a){return{'rows':_0x1a844a||[],'count':_0x241947};});}});}exports[_0x1c8f('0xa5')]=function(_0x534c6d,_0xdb7593){return runReport(_0x534c6d[_0x1c8f('0x70')],_0x534c6d['query'],_0x534c6d['options'])[_0x1c8f('0x27')](respondWithResult(_0xdb7593,null))[_0x1c8f('0x46')](handleError(_0xdb7593,null));};exports[_0x1c8f('0xa6')]=runReport;exports[_0x1c8f('0x34')]=function(_0x3bf2de,_0x3f0457){var _0x21b8fa=0xa;var _0x4d30c5=['join',_0x1c8f('0x57'),_0x1c8f('0x58'),_0x1c8f('0x59')];var _0x48df6c={'SUM':'SUM(%s)','COUNT':_0x1c8f('0x5b'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x1c8f('0x5d'),'MIN':_0x1c8f('0x5e'),'AVG':_0x1c8f('0x5f'),'GROUP_CONCAT':_0x1c8f('0x60'),'GROUP_CONCAT ASC':_0x1c8f('0x61'),'GROUP_CONCAT DESC':_0x1c8f('0x62')};var _0x47d691={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x1c8f('0x63'),'HOUR':_0x1c8f('0x64'),'ROUND':_0x1c8f('0x65'),'UNIX_TIMESTAMP':_0x1c8f('0x66')};var _0x4eb4f2=function(_0x1c877d){return!_['includes']([_0x1c8f('0x67'),_0x1c8f('0x68'),_0x1c8f('0x69'),_0x1c8f('0x6a')],_0x1c877d);};var _0x5290ff=function(_0x56e423){if(!_0x56e423||!_0x56e423['rules']['length']){return'';}for(var _0x3adfe3='(',_0xd04fb6=0x0;_0xd04fb6<_0x56e423[_0x1c8f('0x6b')][_0x1c8f('0x49')];_0xd04fb6+=0x1){_0xd04fb6>0x0&&(_0x3adfe3+='\x20'+_0x56e423['operator']+'\x20');_0x3adfe3+=_0x56e423['rules'][_0xd04fb6]['group']?_0x5290ff(_0x56e423[_0x1c8f('0x6b')][_0xd04fb6][_0x1c8f('0x6c')]):_0x56e423[_0x1c8f('0x6b')][_0xd04fb6]['field']+'\x20'+_0x56e423['rules'][_0xd04fb6][_0x1c8f('0x6e')]+(_0x4eb4f2(_0x56e423[_0x1c8f('0x6b')][_0xd04fb6][_0x1c8f('0x6e')])?'\x20'+_0x56e423['rules'][_0xd04fb6]['value']:'');}return _0x3adfe3+')';};var _0x32db2f={'where':{'id':_0x3bf2de['params']['id']}},_0x3d43b0,_0x2df251,_0x56b5e4,_0x5c535e,_0x46895d;_0x32db2f=_[_0x1c8f('0x40')]({},_0x32db2f,_0x3bf2de[_0x1c8f('0x42')]);return db[_0x1c8f('0x44')]['find'](_0x32db2f)['then'](function(_0x5316b7){if(_0x5316b7){_0x3d43b0=_0x5316b7;return _0x5316b7[_0x1c8f('0x71')]();}return null;})[_0x1c8f('0x27')](function(_0x182b37){if(_0x182b37){if(!_0x182b37[_0x1c8f('0x49')]){throw new db[(_0x1c8f('0x90'))][(_0x1c8f('0x72'))](_0x1c8f('0x73'),0x193);}_0x2df251=_0x182b37;return db[_0x1c8f('0x74')]['findAll']({'raw':!![]});}return null;})['then'](function(_0x2ea4fc){if(_0x2ea4fc){_0x56b5e4=_['keyBy'](_0x2ea4fc,'id');var _0x1a086f;var _0x51a42f=squel['select']();_0x51a42f[_0x1c8f('0xa2')](_0x3d43b0['table']);for(var _0x540284=0x0;_0x540284<_0x2df251[_0x1c8f('0x49')];_0x540284+=0x1){_0x1a086f=_0x2df251[_0x540284][_0x1c8f('0x79')]?_0x56b5e4[_0x2df251[_0x540284]['MetricId']][_0x1c8f('0x7a')]:_0x2df251[_0x540284][_0x1c8f('0x6d')];_0x1a086f=_0x2df251[_0x540284]['function']?_[_0x1c8f('0x7d')](_0x48df6c[_0x2df251[_0x540284][_0x1c8f('0x7b')]],'%s',_0x1a086f):_0x1a086f;_0x1a086f=_0x2df251[_0x540284][_0x1c8f('0x7c')]?_[_0x1c8f('0x7d')](_0x47d691[_0x2df251[_0x540284][_0x1c8f('0x7c')]],'%s',_0x1a086f):_0x1a086f;if(_0x2df251[_0x540284][_0x1c8f('0x7e')]){_0x51a42f[_0x1c8f('0x6c')](_0x1a086f);}_0x2df251[_0x540284][_0x1c8f('0x7f')]&&_0x51a42f['order'](_0x1a086f,_0x2df251[_0x540284][_0x1c8f('0x7f')]===_0x1c8f('0x91')?![]:!![]);_0x51a42f[_0x1c8f('0x6d')](_0x1a086f,_0x2df251[_0x540284]['alias']||_0x1a086f);}if(_0x3d43b0[_0x1c8f('0x81')]){_0x3d43b0[_0x1c8f('0x81')]=JSON[_0x1c8f('0x82')](_0x3d43b0[_0x1c8f('0x81')]);for(var _0x36417f=0x0;_0x36417f<_0x3d43b0[_0x1c8f('0x81')]['length'];_0x36417f+=0x1){if(_0x3d43b0[_0x1c8f('0x81')][_0x36417f][_0x1c8f('0x31')]&&_['includes'](_0x4d30c5,_0x3d43b0[_0x1c8f('0x81')][_0x36417f][_0x1c8f('0x31')])&&_0x3d43b0['joins'][_0x36417f][_0x1c8f('0x83')]&&_0x3d43b0['joins'][_0x36417f][_0x1c8f('0x84')]&&_0x3d43b0['joins'][_0x36417f]['foreignKey']){_0x51a42f[_0x3d43b0[_0x1c8f('0x81')][_0x36417f][_0x1c8f('0x31')]](_0x3d43b0['joins'][_0x36417f][_0x1c8f('0x84')],null,util['format'](_0x1c8f('0x92'),_0x3d43b0[_0x1c8f('0x78')],_0x3d43b0[_0x1c8f('0x81')][_0x36417f][_0x1c8f('0x83')],_0x3d43b0['joins'][_0x36417f][_0x1c8f('0x84')],_0x3d43b0[_0x1c8f('0x81')][_0x36417f]['foreignKey']));}}}if(_0x3d43b0[_0x1c8f('0x86')]){_0x3d43b0[_0x1c8f('0x86')]=JSON[_0x1c8f('0x82')](_0x3d43b0[_0x1c8f('0x86')]);_0x51a42f[_0x1c8f('0x3d')](_0x5290ff(_0x3d43b0[_0x1c8f('0x86')]['group']));}_0x46895d=_0x51a42f[_0x1c8f('0x87')]();_0x51a42f[_0x1c8f('0x21')](_0x21b8fa);_0x51a42f['offset'](0x0);logger[_0x1c8f('0x88')]('Limited\x20Query:',_0x51a42f[_0x1c8f('0x8a')]());return dbH['sequelize'][_0x1c8f('0x34')](_0x51a42f[_0x1c8f('0x8a')](),{'type':dbH[_0x1c8f('0x8b')][_0x1c8f('0x8c')][_0x1c8f('0x8d')]});}})[_0x1c8f('0x27')](function(){return{'sql':_0x46895d[_0x1c8f('0x8a')]()};})[_0x1c8f('0x27')](respondWithResult(_0x3f0457,null))['catch'](handleError(_0x3f0457,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff