// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x4dd8=['lodash','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','api','../../config/utils','../../config/environment','../../mysqldb','dbH','sendStatus','status','end','json','undefined','limit','offset','count','Content-Range','apply','reject','save','destroy','then','get','CustomReports','UserProfileResource','stack','name','send','index','map','AnalyticCustomReport','rawAttributes','fieldName','type','key','filters','intersection','model','query','attributes','fields','length','hasOwnProperty','nolimit','sort','where','pick','filter','merge','VIRTUAL','options','findAll','rows','catch','params','keys','includeAll','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','UserProfileSection','autoAssociation','error','update','preview','join','right_join','SUM(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','DATE(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','getFields','ValidationErrorItem','keyBy','from','table','MetricId','function','format','groupBy','order','orderBy','DESC','joins','parse','foreignTable','foreignKey','parentKey','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','left_join','cross_join','COUNT(%s)','MIN(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','HOUR(%s)','value','Please\x20insert\x20at\x20least\x20one\x20field','metric','replace','alias','%s.%s\x20=\x20%s.%s','output','web','fullPath','randomstring','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','info','Run\x20Query:','fork','../../files/reports','savename','select','countTable','COUNT(*)','run','runReport','AVG(%s)','Sequelize','AnalyticMetric','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','mustache','path','sox','to-csv','ejs','fs-extra'];(function(_0x4ee804,_0xd164c1){var _0x316cc9=function(_0x4beaf7){while(--_0x4beaf7){_0x4ee804['push'](_0x4ee804['shift']());}};_0x316cc9(++_0xd164c1);}(_0x4dd8,0x1e7));var _0x84dd=function(_0x112e53,_0x3ec1de){_0x112e53=_0x112e53-0x0;var _0x47740e=_0x4dd8[_0x112e53];return _0x47740e;};'use strict';var emlformat=require(_0x84dd('0x0'));var rimraf=require(_0x84dd('0x1'));var zipdir=require(_0x84dd('0x2'));var jsonpatch=require(_0x84dd('0x3'));var rp=require(_0x84dd('0x4'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x84dd('0x5'));var util=require('util');var path=require(_0x84dd('0x6'));var sox=require(_0x84dd('0x7'));var csv=require(_0x84dd('0x8'));var ejs=require(_0x84dd('0x9'));var fs=require('fs');var fs_extra=require(_0x84dd('0xa'));var _=require(_0x84dd('0xb'));var squel=require(_0x84dd('0xc'));var crypto=require(_0x84dd('0xd'));var jsforce=require(_0x84dd('0xe'));var deskjs=require(_0x84dd('0xf'));var toCsv=require(_0x84dd('0x8'));var querystring=require('querystring');var Papa=require(_0x84dd('0x10'));var Redis=require(_0x84dd('0x11'));var authService=require(_0x84dd('0x12'));var qs=require(_0x84dd('0x13'));var as=require(_0x84dd('0x14'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0x84dd('0x15'));var utils=require(_0x84dd('0x16'));var config=require(_0x84dd('0x17'));var licenseUtil=require('../../config/license/util');var db=require(_0x84dd('0x18'))['db'];var dbH=require(_0x84dd('0x18'))[_0x84dd('0x19')];function respondWithStatusCode(_0x510f5e,_0x131897){_0x131897=_0x131897||0xcc;return function(_0x27df72){if(_0x27df72){return _0x510f5e[_0x84dd('0x1a')](_0x131897);}return _0x510f5e[_0x84dd('0x1b')](_0x131897)[_0x84dd('0x1c')]();};}function respondWithResult(_0x2abe0c,_0x5b905e){_0x5b905e=_0x5b905e||0xc8;return function(_0x19bec6){if(_0x19bec6){return _0x2abe0c[_0x84dd('0x1b')](_0x5b905e)[_0x84dd('0x1d')](_0x19bec6);}};}function respondWithFilteredResult(_0x251ec5,_0x1ba75f){return function(_0x24ae78){if(_0x24ae78){var _0x308cda=typeof _0x1ba75f['offset']===_0x84dd('0x1e')&&typeof _0x1ba75f[_0x84dd('0x1f')]==='undefined';var _0x36a6c7=_0x24ae78['count'];var _0x576b3a=_0x308cda?0x0:_0x1ba75f[_0x84dd('0x20')];var _0x2f3e19=_0x308cda?_0x24ae78[_0x84dd('0x21')]:_0x1ba75f[_0x84dd('0x20')]+_0x1ba75f[_0x84dd('0x1f')];var _0x21e0e6;if(_0x2f3e19>=_0x36a6c7){_0x2f3e19=_0x36a6c7;_0x21e0e6=0xc8;}else{_0x21e0e6=0xce;}_0x251ec5[_0x84dd('0x1b')](_0x21e0e6);return _0x251ec5['set'](_0x84dd('0x22'),_0x576b3a+'-'+_0x2f3e19+'/'+_0x36a6c7)[_0x84dd('0x1d')](_0x24ae78);}return null;};}function patchUpdates(_0x2ece4e){return function(_0x2c82f3){try{jsonpatch[_0x84dd('0x23')](_0x2c82f3,_0x2ece4e,!![]);}catch(_0x58a93c){return BPromise[_0x84dd('0x24')](_0x58a93c);}return _0x2c82f3[_0x84dd('0x25')]();};}function saveUpdates(_0x9d1c0f,_0x44187d){return function(_0x1a05f6){if(_0x1a05f6){return _0x1a05f6['update'](_0x9d1c0f)['then'](function(_0x216721){return _0x216721;});}return null;};}function removeEntity(_0x5390e1,_0x5783b6){return function(_0x54472a){if(_0x54472a){return _0x54472a[_0x84dd('0x26')]()[_0x84dd('0x27')](function(){var _0x3224d0=_0x54472a[_0x84dd('0x28')]({'plain':!![]});var _0x36c838=_0x84dd('0x29');return db[_0x84dd('0x2a')]['destroy']({'where':{'type':_0x36c838,'resourceId':_0x3224d0['id']}})[_0x84dd('0x27')](function(){return _0x54472a;});})[_0x84dd('0x27')](function(){_0x5390e1[_0x84dd('0x1b')](0xcc)[_0x84dd('0x1c')]();});}};}function handleEntityNotFound(_0x246d9b,_0x115bce){return function(_0x282b0b){if(!_0x282b0b){_0x246d9b[_0x84dd('0x1a')](0x194);}return _0x282b0b;};}function handleError(_0x126ecc,_0x31816e){_0x31816e=_0x31816e||0x1f4;return function(_0x49dc6c){logger['error'](_0x49dc6c[_0x84dd('0x2b')]);if(_0x49dc6c[_0x84dd('0x2c')]){delete _0x49dc6c[_0x84dd('0x2c')];}_0x126ecc[_0x84dd('0x1b')](_0x31816e)[_0x84dd('0x2d')](_0x49dc6c);};}exports[_0x84dd('0x2e')]=function(_0x5a2fe2,_0xc14cf1){var _0x5de42d={},_0x55d1e3={},_0x3ff71c={'count':0x0,'rows':[]};var _0x3e384e=_[_0x84dd('0x2f')](db[_0x84dd('0x30')][_0x84dd('0x31')],function(_0x5f0ac6){return{'name':_0x5f0ac6[_0x84dd('0x32')],'type':_0x5f0ac6[_0x84dd('0x33')][_0x84dd('0x34')]};});_0x55d1e3['model']=_[_0x84dd('0x2f')](_0x3e384e,_0x84dd('0x2c'));_0x55d1e3['query']=_['keys'](_0x5a2fe2['query']);_0x55d1e3[_0x84dd('0x35')]=_[_0x84dd('0x36')](_0x55d1e3[_0x84dd('0x37')],_0x55d1e3[_0x84dd('0x38')]);_0x5de42d[_0x84dd('0x39')]=_[_0x84dd('0x36')](_0x55d1e3[_0x84dd('0x37')],qs[_0x84dd('0x3a')](_0x5a2fe2[_0x84dd('0x38')][_0x84dd('0x3a')]));_0x5de42d[_0x84dd('0x39')]=_0x5de42d[_0x84dd('0x39')][_0x84dd('0x3b')]?_0x5de42d[_0x84dd('0x39')]:_0x55d1e3[_0x84dd('0x37')];if(!_0x5a2fe2[_0x84dd('0x38')][_0x84dd('0x3c')](_0x84dd('0x3d'))){_0x5de42d[_0x84dd('0x1f')]=qs[_0x84dd('0x1f')](_0x5a2fe2[_0x84dd('0x38')][_0x84dd('0x1f')]);_0x5de42d[_0x84dd('0x20')]=qs[_0x84dd('0x20')](_0x5a2fe2[_0x84dd('0x38')][_0x84dd('0x20')]);}_0x5de42d['order']=qs[_0x84dd('0x3e')](_0x5a2fe2['query']['sort']);_0x5de42d[_0x84dd('0x3f')]=qs[_0x84dd('0x35')](_[_0x84dd('0x40')](_0x5a2fe2[_0x84dd('0x38')],_0x55d1e3[_0x84dd('0x35')]),_0x3e384e);if(_0x5a2fe2[_0x84dd('0x38')][_0x84dd('0x41')]){_0x5de42d[_0x84dd('0x3f')]=_[_0x84dd('0x42')](_0x5de42d['where'],{'$or':_['map'](_0x3e384e,function(_0x26688a){if(_0x26688a['type']!==_0x84dd('0x43')){var _0x1e8f41={};_0x1e8f41[_0x26688a['name']]={'$like':'%'+_0x5a2fe2['query']['filter']+'%'};return _0x1e8f41;}})});}_0x5de42d=_['merge']({},_0x5de42d,_0x5a2fe2[_0x84dd('0x44')]);var _0x5833a={'where':_0x5de42d['where']};return db[_0x84dd('0x30')][_0x84dd('0x21')](_0x5833a)[_0x84dd('0x27')](function(_0x38e4a8){_0x3ff71c[_0x84dd('0x21')]=_0x38e4a8;if(_0x5a2fe2[_0x84dd('0x38')]['includeAll']){_0x5de42d['include']=[{'all':!![]}];}return db[_0x84dd('0x30')][_0x84dd('0x45')](_0x5de42d);})[_0x84dd('0x27')](function(_0x2eaceb){_0x3ff71c[_0x84dd('0x46')]=_0x2eaceb;return _0x3ff71c;})['then'](respondWithFilteredResult(_0xc14cf1,_0x5de42d))[_0x84dd('0x47')](handleError(_0xc14cf1,null));};exports['show']=function(_0xbfbafa,_0x5a75e8){var _0x1d6784={'raw':![],'where':{'id':_0xbfbafa[_0x84dd('0x48')]['id']}},_0x4e8e8e={};_0x4e8e8e[_0x84dd('0x37')]=_[_0x84dd('0x49')](db[_0x84dd('0x30')][_0x84dd('0x31')]);_0x4e8e8e['query']=_[_0x84dd('0x49')](_0xbfbafa[_0x84dd('0x38')]);_0x4e8e8e[_0x84dd('0x35')]=_[_0x84dd('0x36')](_0x4e8e8e[_0x84dd('0x37')],_0x4e8e8e[_0x84dd('0x38')]);_0x1d6784[_0x84dd('0x39')]=_['intersection'](_0x4e8e8e[_0x84dd('0x37')],qs['fields'](_0xbfbafa[_0x84dd('0x38')][_0x84dd('0x3a')]));_0x1d6784[_0x84dd('0x39')]=_0x1d6784[_0x84dd('0x39')][_0x84dd('0x3b')]?_0x1d6784[_0x84dd('0x39')]:_0x4e8e8e[_0x84dd('0x37')];if(_0xbfbafa[_0x84dd('0x38')][_0x84dd('0x4a')]){_0x1d6784['include']=[{'all':!![]}];}_0x1d6784=_[_0x84dd('0x42')]({},_0x1d6784,_0xbfbafa[_0x84dd('0x44')]);return db[_0x84dd('0x30')][_0x84dd('0x4b')](_0x1d6784)[_0x84dd('0x27')](handleEntityNotFound(_0x5a75e8,null))[_0x84dd('0x27')](respondWithResult(_0x5a75e8,null))['catch'](handleError(_0x5a75e8,null));};exports['create']=function(_0xe35b04,_0xd369f1){return db[_0x84dd('0x30')][_0x84dd('0x4c')](_0xe35b04[_0x84dd('0x4d')],{})[_0x84dd('0x27')](function(_0x584bc7){var _0x460741=_0xe35b04[_0x84dd('0x4e')][_0x84dd('0x28')]({'plain':!![]});if(!_0x460741)throw new Error(_0x84dd('0x4f'));if(_0x460741[_0x84dd('0x50')]===_0x84dd('0x4e')){var _0xe0ef5f=_0x584bc7[_0x84dd('0x28')]({'plain':!![]});var _0x3e3f5e=_0x84dd('0x51');return db[_0x84dd('0x52')][_0x84dd('0x4b')]({'where':{'name':_0x3e3f5e,'userProfileId':_0x460741['userProfileId']},'raw':!![]})[_0x84dd('0x27')](function(_0x3ff970){if(_0x3ff970&&_0x3ff970[_0x84dd('0x53')]===0x0){return db['UserProfileResource']['create']({'name':_0xe0ef5f[_0x84dd('0x2c')],'resourceId':_0xe0ef5f['id'],'type':_0x84dd('0x29'),'sectionId':_0x3ff970['id']},{})[_0x84dd('0x27')](function(){return _0x584bc7;});}else{return _0x584bc7;}})[_0x84dd('0x47')](function(_0x35f13a){logger[_0x84dd('0x54')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x35f13a);throw _0x35f13a;});}return _0x584bc7;})['then'](respondWithResult(_0xd369f1,0xc9))['catch'](handleError(_0xd369f1,null));};exports[_0x84dd('0x55')]=function(_0x3f3722,_0x32d956){if(_0x3f3722[_0x84dd('0x4d')]['id']){delete _0x3f3722[_0x84dd('0x4d')]['id'];}return db[_0x84dd('0x30')][_0x84dd('0x4b')]({'where':{'id':_0x3f3722[_0x84dd('0x48')]['id']}})['then'](handleEntityNotFound(_0x32d956,null))[_0x84dd('0x27')](saveUpdates(_0x3f3722[_0x84dd('0x4d')],null))[_0x84dd('0x27')](respondWithResult(_0x32d956,null))[_0x84dd('0x47')](handleError(_0x32d956,null));};exports[_0x84dd('0x26')]=function(_0x489e8c,_0x321088){return db[_0x84dd('0x30')][_0x84dd('0x4b')]({'where':{'id':_0x489e8c[_0x84dd('0x48')]['id']}})[_0x84dd('0x27')](handleEntityNotFound(_0x321088,null))[_0x84dd('0x27')](removeEntity(_0x321088,null))[_0x84dd('0x47')](handleError(_0x321088,null));};exports[_0x84dd('0x56')]=function(_0x2602d3,_0xb452d){var _0x50da91=0xa;var _0x47dae5=[_0x84dd('0x57'),'left_join',_0x84dd('0x58'),'cross_join'];var _0x3aee7b={'SUM':_0x84dd('0x59'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x84dd('0x5a'),'MAX':_0x84dd('0x5b'),'MIN':'MIN(%s)','AVG':'AVG(%s)','GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x2de814={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x84dd('0x5c'),'HOUR':'HOUR(%s)','ROUND':_0x84dd('0x5d'),'UNIX_TIMESTAMP':_0x84dd('0x5e')};var _0x21d5c5=function(_0x2e3ddf){return!_[_0x84dd('0x5f')]([_0x84dd('0x60'),_0x84dd('0x61'),_0x84dd('0x62'),_0x84dd('0x63')],_0x2e3ddf);};var _0x386b87=function(_0x2ed4a3){if(!_0x2ed4a3||!_0x2ed4a3[_0x84dd('0x64')][_0x84dd('0x3b')]){return'';}for(var _0x32c4cf='(',_0x5a6d5b=0x0;_0x5a6d5b<_0x2ed4a3[_0x84dd('0x64')][_0x84dd('0x3b')];_0x5a6d5b+=0x1){_0x5a6d5b>0x0&&(_0x32c4cf+='\x20'+_0x2ed4a3[_0x84dd('0x65')]+'\x20');_0x32c4cf+=_0x2ed4a3[_0x84dd('0x64')][_0x5a6d5b][_0x84dd('0x66')]?_0x386b87(_0x2ed4a3[_0x84dd('0x64')][_0x5a6d5b][_0x84dd('0x66')]):_0x2ed4a3[_0x84dd('0x64')][_0x5a6d5b][_0x84dd('0x67')]+'\x20'+_0x2ed4a3[_0x84dd('0x64')][_0x5a6d5b][_0x84dd('0x68')]+(_0x21d5c5(_0x2ed4a3[_0x84dd('0x64')][_0x5a6d5b][_0x84dd('0x68')])?'\x20'+_0x2ed4a3['rules'][_0x5a6d5b]['value']:'');}return _0x32c4cf+')';};var _0x430df5={'where':{'id':_0x2602d3[_0x84dd('0x48')]['id']}},_0x26ddf5,_0x96141,_0xe50cc3,_0x4bf94e,_0x1ee27a;_0x430df5=_[_0x84dd('0x42')]({},_0x430df5,_0x2602d3[_0x84dd('0x44')]);return db['AnalyticCustomReport'][_0x84dd('0x4b')](_0x430df5)[_0x84dd('0x27')](function(_0x3fde8e){if(_0x3fde8e){_0x26ddf5=_0x3fde8e;return _0x3fde8e[_0x84dd('0x69')]();}return null;})[_0x84dd('0x27')](function(_0x36e266){if(_0x36e266){if(!_0x36e266[_0x84dd('0x3b')]){throw new db['Sequelize'][(_0x84dd('0x6a'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x96141=_0x36e266;return db['AnalyticMetric'][_0x84dd('0x45')]({'raw':!![]});}return null;})[_0x84dd('0x27')](function(_0x22412b){if(_0x22412b){_0xe50cc3=_[_0x84dd('0x6b')](_0x22412b,'id');var _0x355c34;var _0x3093d0=squel['select']();_0x3093d0[_0x84dd('0x6c')](_0x26ddf5[_0x84dd('0x6d')]);for(var _0x2c6834=0x0;_0x2c6834<_0x96141[_0x84dd('0x3b')];_0x2c6834+=0x1){_0x355c34=_0x96141[_0x2c6834][_0x84dd('0x6e')]?_0xe50cc3[_0x96141[_0x2c6834][_0x84dd('0x6e')]]['metric']:_0x96141[_0x2c6834][_0x84dd('0x67')];_0x355c34=_0x96141[_0x2c6834][_0x84dd('0x6f')]?_['replace'](_0x3aee7b[_0x96141[_0x2c6834]['function']],'%s',_0x355c34):_0x355c34;_0x355c34=_0x96141[_0x2c6834][_0x84dd('0x70')]?_['replace'](_0x2de814[_0x96141[_0x2c6834][_0x84dd('0x70')]],'%s',_0x355c34):_0x355c34;if(_0x96141[_0x2c6834][_0x84dd('0x71')]){_0x3093d0[_0x84dd('0x66')](_0x355c34);}_0x96141[_0x2c6834]['orderBy']&&_0x3093d0[_0x84dd('0x72')](_0x355c34,_0x96141[_0x2c6834][_0x84dd('0x73')]===_0x84dd('0x74')?![]:!![]);_0x3093d0[_0x84dd('0x67')](_0x355c34,_0x96141[_0x2c6834]['alias']||_0x355c34);}if(_0x26ddf5[_0x84dd('0x75')]){_0x26ddf5[_0x84dd('0x75')]=JSON[_0x84dd('0x76')](_0x26ddf5[_0x84dd('0x75')]);for(var _0x379cc7=0x0;_0x379cc7<_0x26ddf5[_0x84dd('0x75')][_0x84dd('0x3b')];_0x379cc7+=0x1){if(_0x26ddf5[_0x84dd('0x75')][_0x379cc7][_0x84dd('0x33')]&&_[_0x84dd('0x5f')](_0x47dae5,_0x26ddf5[_0x84dd('0x75')][_0x379cc7][_0x84dd('0x33')])&&_0x26ddf5['joins'][_0x379cc7]['parentKey']&&_0x26ddf5[_0x84dd('0x75')][_0x379cc7][_0x84dd('0x77')]&&_0x26ddf5[_0x84dd('0x75')][_0x379cc7][_0x84dd('0x78')]){_0x3093d0[_0x26ddf5[_0x84dd('0x75')][_0x379cc7][_0x84dd('0x33')]](_0x26ddf5[_0x84dd('0x75')][_0x379cc7][_0x84dd('0x77')],null,util[_0x84dd('0x70')]('%s.%s\x20=\x20%s.%s',_0x26ddf5[_0x84dd('0x6d')],_0x26ddf5[_0x84dd('0x75')][_0x379cc7][_0x84dd('0x79')],_0x26ddf5[_0x84dd('0x75')][_0x379cc7][_0x84dd('0x77')],_0x26ddf5[_0x84dd('0x75')][_0x379cc7][_0x84dd('0x78')]));}}}if(_0x26ddf5['conditions']){_0x26ddf5[_0x84dd('0x7a')]=JSON[_0x84dd('0x76')](_0x26ddf5[_0x84dd('0x7a')]);_0x3093d0[_0x84dd('0x3f')](_0x386b87(_0x26ddf5[_0x84dd('0x7a')][_0x84dd('0x66')]));}_0x1ee27a=_0x3093d0[_0x84dd('0x7b')]();_0x3093d0[_0x84dd('0x1f')](_0x50da91);_0x3093d0[_0x84dd('0x20')](0x0);logger[_0x84dd('0x7c')](_0x84dd('0x7d'),_0x3093d0[_0x84dd('0x7e')]());return dbH[_0x84dd('0x7f')][_0x84dd('0x38')](_0x3093d0[_0x84dd('0x7e')](),{'type':dbH[_0x84dd('0x7f')][_0x84dd('0x80')][_0x84dd('0x81')]});}})[_0x84dd('0x27')](respondWithResult(_0xb452d,null))['catch'](handleError(_0xb452d,null));};function runReport(_0x29599c,_0x35f032,_0x173ca3){var _0x3e5f6f=_0x35f032[_0x84dd('0x2c')];var _0x5c092d=0xa;var _0x21066a=[_0x84dd('0x57'),_0x84dd('0x82'),_0x84dd('0x58'),_0x84dd('0x83')];var _0x4e0832={'SUM':'SUM(%s)','COUNT':_0x84dd('0x84'),'COUNT DISTINCT':_0x84dd('0x5a'),'MAX':'MAX(%s)','MIN':_0x84dd('0x85'),'AVG':'AVG(%s)','GROUP_CONCAT':_0x84dd('0x86'),'GROUP_CONCAT ASC':_0x84dd('0x87'),'GROUP_CONCAT DESC':_0x84dd('0x88')};var _0x1d6490={'SEC_TO_TIME':_0x84dd('0x89'),'DATE':_0x84dd('0x5c'),'HOUR':_0x84dd('0x8a'),'ROUND':_0x84dd('0x5d'),'UNIX_TIMESTAMP':_0x84dd('0x5e')};var _0x29463b=function(_0x4ae3be){return!_[_0x84dd('0x5f')](['IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY',_0x84dd('0x63')],_0x4ae3be);};var _0x428d92=function(_0x1d2918){if(!_0x1d2918||!_0x1d2918['rules']['length']){return'';}for(var _0x2c9d49='(',_0x13100f=0x0;_0x13100f<_0x1d2918[_0x84dd('0x64')][_0x84dd('0x3b')];_0x13100f+=0x1){_0x13100f>0x0&&(_0x2c9d49+='\x20'+_0x1d2918['operator']+'\x20');_0x2c9d49+=_0x1d2918['rules'][_0x13100f][_0x84dd('0x66')]?_0x428d92(_0x1d2918[_0x84dd('0x64')][_0x13100f][_0x84dd('0x66')]):_0x1d2918[_0x84dd('0x64')][_0x13100f][_0x84dd('0x67')]+'\x20'+_0x1d2918[_0x84dd('0x64')][_0x13100f][_0x84dd('0x68')]+(_0x29463b(_0x1d2918[_0x84dd('0x64')][_0x13100f][_0x84dd('0x68')])?'\x20'+_0x1d2918[_0x84dd('0x64')][_0x13100f][_0x84dd('0x8b')]:'');}return _0x2c9d49+')';};var _0x2ec272={'where':{'id':_0x29599c['id']}},_0x1112a7,_0x59f77f,_0x17382b,_0x2e9577,_0x18026;_0x2ec272=_['merge']({},_0x2ec272,_0x173ca3);return db[_0x84dd('0x30')][_0x84dd('0x4b')](_0x2ec272)[_0x84dd('0x27')](function(_0x2c18f0){if(_0x2c18f0){_0x1112a7=_0x2c18f0;return _0x2c18f0[_0x84dd('0x69')]();}return null;})[_0x84dd('0x27')](function(_0x50f39a){if(_0x50f39a){if(!_0x50f39a[_0x84dd('0x3b')]){throw new db['Sequelize'][(_0x84dd('0x6a'))](_0x84dd('0x8c'),0x193);}_0x59f77f=_0x50f39a;return db['AnalyticMetric'][_0x84dd('0x45')]({'raw':!![]});}return null;})[_0x84dd('0x27')](function(_0x1871d6){if(_0x1871d6){_0x17382b=_[_0x84dd('0x6b')](_0x1871d6,'id');var _0x298ea2;var _0x128545=squel['select']();_0x128545[_0x84dd('0x6c')](_0x1112a7[_0x84dd('0x6d')]);for(var _0x54ac9c=0x0;_0x54ac9c<_0x59f77f['length'];_0x54ac9c+=0x1){_0x298ea2=_0x59f77f[_0x54ac9c][_0x84dd('0x6e')]?_0x17382b[_0x59f77f[_0x54ac9c][_0x84dd('0x6e')]][_0x84dd('0x8d')]:_0x59f77f[_0x54ac9c][_0x84dd('0x67')];_0x298ea2=_0x59f77f[_0x54ac9c][_0x84dd('0x6f')]?_['replace'](_0x4e0832[_0x59f77f[_0x54ac9c][_0x84dd('0x6f')]],'%s',_0x298ea2):_0x298ea2;_0x298ea2=_0x59f77f[_0x54ac9c][_0x84dd('0x70')]?_[_0x84dd('0x8e')](_0x1d6490[_0x59f77f[_0x54ac9c][_0x84dd('0x70')]],'%s',_0x298ea2):_0x298ea2;if(_0x59f77f[_0x54ac9c]['groupBy']){_0x128545[_0x84dd('0x66')](_0x298ea2);}_0x59f77f[_0x54ac9c][_0x84dd('0x73')]&&_0x128545[_0x84dd('0x72')](_0x298ea2,_0x59f77f[_0x54ac9c][_0x84dd('0x73')]==='DESC'?![]:!![]);_0x128545[_0x84dd('0x67')](_0x298ea2,_0x59f77f[_0x54ac9c][_0x84dd('0x8f')]||_0x298ea2);}if(_0x1112a7[_0x84dd('0x75')]){_0x1112a7['joins']=JSON[_0x84dd('0x76')](_0x1112a7['joins']);for(var _0x4f4dc4=0x0;_0x4f4dc4<_0x1112a7['joins']['length'];_0x4f4dc4+=0x1){if(_0x1112a7[_0x84dd('0x75')][_0x4f4dc4][_0x84dd('0x33')]&&_['includes'](_0x21066a,_0x1112a7[_0x84dd('0x75')][_0x4f4dc4]['type'])&&_0x1112a7[_0x84dd('0x75')][_0x4f4dc4][_0x84dd('0x79')]&&_0x1112a7['joins'][_0x4f4dc4][_0x84dd('0x77')]&&_0x1112a7[_0x84dd('0x75')][_0x4f4dc4][_0x84dd('0x78')]){_0x128545[_0x1112a7[_0x84dd('0x75')][_0x4f4dc4][_0x84dd('0x33')]](_0x1112a7[_0x84dd('0x75')][_0x4f4dc4][_0x84dd('0x77')],null,util[_0x84dd('0x70')](_0x84dd('0x90'),_0x1112a7[_0x84dd('0x6d')],_0x1112a7[_0x84dd('0x75')][_0x4f4dc4][_0x84dd('0x79')],_0x1112a7[_0x84dd('0x75')][_0x4f4dc4][_0x84dd('0x77')],_0x1112a7['joins'][_0x4f4dc4][_0x84dd('0x78')]));}}}if(_0x1112a7[_0x84dd('0x7a')]){_0x1112a7['conditions']=JSON[_0x84dd('0x76')](_0x1112a7[_0x84dd('0x7a')]);_0x128545[_0x84dd('0x3f')](_0x428d92(_0x1112a7['conditions'][_0x84dd('0x66')]));}_0x18026=_0x128545[_0x84dd('0x7b')]();_0x128545[_0x84dd('0x1f')](_0x5c092d);_0x128545[_0x84dd('0x20')](0x0);return;}})[_0x84dd('0x27')](function(){if(_0x35f032[_0x84dd('0x91')]===_0x84dd('0x92')){return null;}var _0x56d029=_['merge'](_0x35f032,{'name':_0x35f032[_0x84dd('0x93')]||_0x35f032[_0x84dd('0x2c')]||_0x1112a7[_0x84dd('0x2c')],'basename':_0x3e5f6f,'savename':util[_0x84dd('0x70')]('%s-%s.%s',_0x35f032[_0x84dd('0x2c')]||_0x1112a7[_0x84dd('0x2c')],require(_0x84dd('0x94'))['generate'](0x4),_0x35f032[_0x84dd('0x91')]||'csv'),'reportId':_0x1112a7['id'],'reportType':'custom'});return db['AnalyticExtractedReport'][_0x84dd('0x4c')](_0x56d029,{'raw':!![]});})['then'](function(_0x3bdf3a){if(_0x1112a7[_0x84dd('0x6d')]===_0x84dd('0x95')){_0x18026[_0x84dd('0x3f')](_0x1112a7['table']+_0x84dd('0x96'),_0x35f032[_0x84dd('0x97')],_0x35f032[_0x84dd('0x98')]);}else{_0x18026['where'](_0x1112a7[_0x84dd('0x6d')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x35f032[_0x84dd('0x97')],_0x35f032[_0x84dd('0x98')]);}if(_0x3bdf3a){logger[_0x84dd('0x99')](_0x84dd('0x9a'),_0x18026[_0x84dd('0x7e')]());require('child_process')[_0x84dd('0x9b')](path['join'](__dirname,'../../components/export/',_0x3bdf3a[_0x84dd('0x91')]),[_0x3bdf3a['id'],_0x18026[_0x84dd('0x7e')](),path[_0x84dd('0x57')](__dirname,_0x84dd('0x9c'),_0x3bdf3a[_0x84dd('0x9d')]),_0x3e5f6f]);return _0x3bdf3a;}else{var _0x4b392b=squel[_0x84dd('0x9e')]();_0x4b392b['from']('('+_0x18026[_0x84dd('0x7e')]()+')',_0x84dd('0x9f'));_0x4b392b[_0x84dd('0x67')](_0x84dd('0xa0'),'count');_0x18026[_0x84dd('0x1f')](_0x35f032[_0x84dd('0x1f')]||_0x5c092d);_0x18026[_0x84dd('0x20')](_0x35f032[_0x84dd('0x20')]||0x0);return dbH[_0x84dd('0x7f')][_0x84dd('0x38')](_0x4b392b[_0x84dd('0x7e')](),{'type':dbH['sequelize']['QueryTypes'][_0x84dd('0x81')]})[_0x84dd('0x27')](function(_0x545d09){if(!_0x545d09[_0x84dd('0x3b')]){_0x2e9577=0x0;}else{_0x2e9577=_0x545d09[0x0]['count']||0x0;}return dbH[_0x84dd('0x7f')][_0x84dd('0x38')](_0x18026[_0x84dd('0x7e')](),{'type':dbH[_0x84dd('0x7f')]['QueryTypes'][_0x84dd('0x81')]});})['then'](function(_0x197a18){return{'rows':_0x197a18||[],'count':_0x2e9577};});}});}exports[_0x84dd('0xa1')]=function(_0x2a4156,_0x271948){return runReport(_0x2a4156['params'],_0x2a4156['query'],_0x2a4156[_0x84dd('0x44')])[_0x84dd('0x27')](respondWithResult(_0x271948,null))[_0x84dd('0x47')](handleError(_0x271948,null));};exports[_0x84dd('0xa2')]=runReport;exports['query']=function(_0x19b561,_0x2d1c29){var _0xf78df4=0xa;var _0x6c0063=[_0x84dd('0x57'),_0x84dd('0x82'),'right_join','cross_join'];var _0x2c93f8={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT DISTINCT':_0x84dd('0x5a'),'MAX':'MAX(%s)','MIN':_0x84dd('0x85'),'AVG':_0x84dd('0xa3'),'GROUP_CONCAT':_0x84dd('0x86'),'GROUP_CONCAT ASC':_0x84dd('0x87'),'GROUP_CONCAT DESC':_0x84dd('0x88')};var _0x127c8c={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x84dd('0x5c'),'HOUR':_0x84dd('0x8a'),'ROUND':_0x84dd('0x5d'),'UNIX_TIMESTAMP':_0x84dd('0x5e')};var _0x5cea01=function(_0x684549){return!_[_0x84dd('0x5f')](['IS\x20NULL','IS\x20NOT\x20NULL',_0x84dd('0x62'),_0x84dd('0x63')],_0x684549);};var _0x4f6a56=function(_0x121928){if(!_0x121928||!_0x121928[_0x84dd('0x64')][_0x84dd('0x3b')]){return'';}for(var _0x4632fe='(',_0x4f7901=0x0;_0x4f7901<_0x121928[_0x84dd('0x64')][_0x84dd('0x3b')];_0x4f7901+=0x1){_0x4f7901>0x0&&(_0x4632fe+='\x20'+_0x121928[_0x84dd('0x65')]+'\x20');_0x4632fe+=_0x121928['rules'][_0x4f7901][_0x84dd('0x66')]?_0x4f6a56(_0x121928['rules'][_0x4f7901]['group']):_0x121928['rules'][_0x4f7901][_0x84dd('0x67')]+'\x20'+_0x121928[_0x84dd('0x64')][_0x4f7901]['condition']+(_0x5cea01(_0x121928['rules'][_0x4f7901]['condition'])?'\x20'+_0x121928[_0x84dd('0x64')][_0x4f7901][_0x84dd('0x8b')]:'');}return _0x4632fe+')';};var _0x5e9d82={'where':{'id':_0x19b561['params']['id']}},_0xedbb26,_0x529133,_0x19b8df,_0x6f499a,_0x15e276;_0x5e9d82=_[_0x84dd('0x42')]({},_0x5e9d82,_0x19b561[_0x84dd('0x44')]);return db['AnalyticCustomReport'][_0x84dd('0x4b')](_0x5e9d82)['then'](function(_0x3bfaec){if(_0x3bfaec){_0xedbb26=_0x3bfaec;return _0x3bfaec[_0x84dd('0x69')]();}return null;})['then'](function(_0x4bedb3){if(_0x4bedb3){if(!_0x4bedb3[_0x84dd('0x3b')]){throw new db[(_0x84dd('0xa4'))]['ValidationErrorItem'](_0x84dd('0x8c'),0x193);}_0x529133=_0x4bedb3;return db[_0x84dd('0xa5')][_0x84dd('0x45')]({'raw':!![]});}return null;})[_0x84dd('0x27')](function(_0x87da06){if(_0x87da06){_0x19b8df=_['keyBy'](_0x87da06,'id');var _0x443af3;var _0x39ab4b=squel[_0x84dd('0x9e')]();_0x39ab4b[_0x84dd('0x6c')](_0xedbb26[_0x84dd('0x6d')]);for(var _0x44bf51=0x0;_0x44bf51<_0x529133[_0x84dd('0x3b')];_0x44bf51+=0x1){_0x443af3=_0x529133[_0x44bf51][_0x84dd('0x6e')]?_0x19b8df[_0x529133[_0x44bf51]['MetricId']][_0x84dd('0x8d')]:_0x529133[_0x44bf51][_0x84dd('0x67')];_0x443af3=_0x529133[_0x44bf51][_0x84dd('0x6f')]?_[_0x84dd('0x8e')](_0x2c93f8[_0x529133[_0x44bf51][_0x84dd('0x6f')]],'%s',_0x443af3):_0x443af3;_0x443af3=_0x529133[_0x44bf51][_0x84dd('0x70')]?_[_0x84dd('0x8e')](_0x127c8c[_0x529133[_0x44bf51][_0x84dd('0x70')]],'%s',_0x443af3):_0x443af3;if(_0x529133[_0x44bf51][_0x84dd('0x71')]){_0x39ab4b[_0x84dd('0x66')](_0x443af3);}_0x529133[_0x44bf51][_0x84dd('0x73')]&&_0x39ab4b['order'](_0x443af3,_0x529133[_0x44bf51][_0x84dd('0x73')]==='DESC'?![]:!![]);_0x39ab4b[_0x84dd('0x67')](_0x443af3,_0x529133[_0x44bf51][_0x84dd('0x8f')]||_0x443af3);}if(_0xedbb26['joins']){_0xedbb26[_0x84dd('0x75')]=JSON[_0x84dd('0x76')](_0xedbb26[_0x84dd('0x75')]);for(var _0x15f24c=0x0;_0x15f24c<_0xedbb26[_0x84dd('0x75')]['length'];_0x15f24c+=0x1){if(_0xedbb26[_0x84dd('0x75')][_0x15f24c][_0x84dd('0x33')]&&_[_0x84dd('0x5f')](_0x6c0063,_0xedbb26[_0x84dd('0x75')][_0x15f24c]['type'])&&_0xedbb26[_0x84dd('0x75')][_0x15f24c][_0x84dd('0x79')]&&_0xedbb26[_0x84dd('0x75')][_0x15f24c][_0x84dd('0x77')]&&_0xedbb26[_0x84dd('0x75')][_0x15f24c]['foreignKey']){_0x39ab4b[_0xedbb26[_0x84dd('0x75')][_0x15f24c]['type']](_0xedbb26[_0x84dd('0x75')][_0x15f24c][_0x84dd('0x77')],null,util[_0x84dd('0x70')](_0x84dd('0x90'),_0xedbb26[_0x84dd('0x6d')],_0xedbb26[_0x84dd('0x75')][_0x15f24c][_0x84dd('0x79')],_0xedbb26[_0x84dd('0x75')][_0x15f24c][_0x84dd('0x77')],_0xedbb26['joins'][_0x15f24c][_0x84dd('0x78')]));}}}if(_0xedbb26[_0x84dd('0x7a')]){_0xedbb26['conditions']=JSON['parse'](_0xedbb26[_0x84dd('0x7a')]);_0x39ab4b[_0x84dd('0x3f')](_0x4f6a56(_0xedbb26[_0x84dd('0x7a')][_0x84dd('0x66')]));}_0x15e276=_0x39ab4b['clone']();_0x39ab4b[_0x84dd('0x1f')](_0xf78df4);_0x39ab4b[_0x84dd('0x20')](0x0);logger[_0x84dd('0x7c')](_0x84dd('0x7d'),_0x39ab4b['toString']());return dbH[_0x84dd('0x7f')][_0x84dd('0x38')](_0x39ab4b['toString'](),{'type':dbH[_0x84dd('0x7f')][_0x84dd('0x80')]['SELECT']});}})[_0x84dd('0x27')](function(){return{'sql':_0x15e276[_0x84dd('0x7e')]()};})[_0x84dd('0x27')](respondWithResult(_0x2d1c29,null))[_0x84dd('0x47')](handleError(_0x2d1c29,null));};
\ No newline at end of file
+var _0x66d4=['join','cross_join','COUNT(DISTINCT\x20%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','UNIX_TIMESTAMP(%s)','Sequelize','keyBy','from','metric','web','fullPath','%s-%s.%s','randomstring','generate','csv','AnalyticExtractedReport','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','info','Run\x20Query:','fork','output','../../files/reports','countTable','COUNT(*)','QueryTypes','SELECT','run','alias','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','dbH','sendStatus','status','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','then','destroy','end','error','stack','name','map','AnalyticCustomReport','rawAttributes','fieldName','type','key','query','filters','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','options','include','findAll','rows','catch','show','params','keys','includeAll','find','create','body','user','get','role','Reports','UserProfileSection','userProfileId','autoAssociation','UserProfileResource','left_join','right_join','SUM(%s)','COUNT(%s)','MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','DATE(%s)','HOUR(%s)','ROUND(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','condition','value','getFields','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','select','table','MetricId','field','function','replace','format','groupBy','orderBy','DESC','joins','parse','parentKey','foreignKey','foreignTable','%s.%s\x20=\x20%s.%s','conditions','clone','debug','Limited\x20Query:','toString','sequelize'];(function(_0xb38a96,_0xfeb8f0){var _0x1a362a=function(_0x57d24a){while(--_0x57d24a){_0xb38a96['push'](_0xb38a96['shift']());}};_0x1a362a(++_0xfeb8f0);}(_0x66d4,0x174));var _0x466d=function(_0x4c2f17,_0x5c6821){_0x4c2f17=_0x4c2f17-0x0;var _0x20919e=_0x66d4[_0x4c2f17];return _0x20919e;};'use strict';var emlformat=require(_0x466d('0x0'));var rimraf=require(_0x466d('0x1'));var zipdir=require(_0x466d('0x2'));var jsonpatch=require(_0x466d('0x3'));var rp=require(_0x466d('0x4'));var moment=require(_0x466d('0x5'));var BPromise=require(_0x466d('0x6'));var Mustache=require(_0x466d('0x7'));var util=require(_0x466d('0x8'));var path=require(_0x466d('0x9'));var sox=require(_0x466d('0xa'));var csv=require(_0x466d('0xb'));var ejs=require(_0x466d('0xc'));var fs=require('fs');var fs_extra=require(_0x466d('0xd'));var _=require(_0x466d('0xe'));var squel=require(_0x466d('0xf'));var crypto=require(_0x466d('0x10'));var jsforce=require(_0x466d('0x11'));var deskjs=require(_0x466d('0x12'));var toCsv=require(_0x466d('0xb'));var querystring=require(_0x466d('0x13'));var Papa=require(_0x466d('0x14'));var Redis=require(_0x466d('0x15'));var authService=require(_0x466d('0x16'));var qs=require(_0x466d('0x17'));var as=require(_0x466d('0x18'));var hardwareService=require(_0x466d('0x19'));var logger=require(_0x466d('0x1a'))('api');var utils=require(_0x466d('0x1b'));var config=require(_0x466d('0x1c'));var licenseUtil=require('../../config/license/util');var db=require(_0x466d('0x1d'))['db'];var dbH=require('../../mysqldb')[_0x466d('0x1e')];function respondWithStatusCode(_0x1ca278,_0x435466){_0x435466=_0x435466||0xcc;return function(_0x493499){if(_0x493499){return _0x1ca278[_0x466d('0x1f')](_0x435466);}return _0x1ca278[_0x466d('0x20')](_0x435466)['end']();};}function respondWithResult(_0x127b24,_0x1be2dd){_0x1be2dd=_0x1be2dd||0xc8;return function(_0x1fcbcc){if(_0x1fcbcc){return _0x127b24[_0x466d('0x20')](_0x1be2dd)[_0x466d('0x21')](_0x1fcbcc);}};}function respondWithFilteredResult(_0x451bfb,_0x346d7e){return function(_0x533f4d){if(_0x533f4d){var _0x54ef53=typeof _0x346d7e[_0x466d('0x22')]===_0x466d('0x23')&&typeof _0x346d7e[_0x466d('0x24')]===_0x466d('0x23');var _0x4bfb6f=_0x533f4d[_0x466d('0x25')];var _0x2f1dbd=_0x54ef53?0x0:_0x346d7e[_0x466d('0x22')];var _0x484c37=_0x54ef53?_0x533f4d[_0x466d('0x25')]:_0x346d7e[_0x466d('0x22')]+_0x346d7e[_0x466d('0x24')];var _0xd154bd;if(_0x484c37>=_0x4bfb6f){_0x484c37=_0x4bfb6f;_0xd154bd=0xc8;}else{_0xd154bd=0xce;}_0x451bfb[_0x466d('0x20')](_0xd154bd);return _0x451bfb[_0x466d('0x26')](_0x466d('0x27'),_0x2f1dbd+'-'+_0x484c37+'/'+_0x4bfb6f)['json'](_0x533f4d);}return null;};}function patchUpdates(_0x1cca1f){return function(_0x553db3){try{jsonpatch[_0x466d('0x28')](_0x553db3,_0x1cca1f,!![]);}catch(_0x597dc2){return BPromise[_0x466d('0x29')](_0x597dc2);}return _0x553db3[_0x466d('0x2a')]();};}function saveUpdates(_0x483f4e,_0x4fc31d){return function(_0x2b1ba0){if(_0x2b1ba0){return _0x2b1ba0[_0x466d('0x2b')](_0x483f4e)[_0x466d('0x2c')](function(_0x42878e){return _0x42878e;});}return null;};}function removeEntity(_0x5232da,_0x84e1c4){return function(_0x30d82e){if(_0x30d82e){return _0x30d82e[_0x466d('0x2d')]()[_0x466d('0x2c')](function(){var _0x313244=_0x30d82e['get']({'plain':!![]});var _0x2e4534='CustomReports';return db['UserProfileResource'][_0x466d('0x2d')]({'where':{'type':_0x2e4534,'resourceId':_0x313244['id']}})[_0x466d('0x2c')](function(){return _0x30d82e;});})[_0x466d('0x2c')](function(){_0x5232da['status'](0xcc)[_0x466d('0x2e')]();});}};}function handleEntityNotFound(_0x32aff7,_0x2db3dd){return function(_0x2f584c){if(!_0x2f584c){_0x32aff7[_0x466d('0x1f')](0x194);}return _0x2f584c;};}function handleError(_0x59a995,_0x54fed9){_0x54fed9=_0x54fed9||0x1f4;return function(_0x34685d){logger[_0x466d('0x2f')](_0x34685d[_0x466d('0x30')]);if(_0x34685d[_0x466d('0x31')]){delete _0x34685d[_0x466d('0x31')];}_0x59a995[_0x466d('0x20')](_0x54fed9)['send'](_0x34685d);};}exports['index']=function(_0x646117,_0x1f864f){var _0x75f4ad={},_0x509b41={},_0x28064a={'count':0x0,'rows':[]};var _0x36bcdf=_[_0x466d('0x32')](db[_0x466d('0x33')][_0x466d('0x34')],function(_0x874548){return{'name':_0x874548[_0x466d('0x35')],'type':_0x874548[_0x466d('0x36')][_0x466d('0x37')]};});_0x509b41['model']=_[_0x466d('0x32')](_0x36bcdf,'name');_0x509b41['query']=_['keys'](_0x646117[_0x466d('0x38')]);_0x509b41[_0x466d('0x39')]=_[_0x466d('0x3a')](_0x509b41[_0x466d('0x3b')],_0x509b41[_0x466d('0x38')]);_0x75f4ad[_0x466d('0x3c')]=_[_0x466d('0x3a')](_0x509b41['model'],qs['fields'](_0x646117[_0x466d('0x38')][_0x466d('0x3d')]));_0x75f4ad[_0x466d('0x3c')]=_0x75f4ad[_0x466d('0x3c')][_0x466d('0x3e')]?_0x75f4ad['attributes']:_0x509b41[_0x466d('0x3b')];if(!_0x646117[_0x466d('0x38')][_0x466d('0x3f')](_0x466d('0x40'))){_0x75f4ad[_0x466d('0x24')]=qs[_0x466d('0x24')](_0x646117[_0x466d('0x38')][_0x466d('0x24')]);_0x75f4ad[_0x466d('0x22')]=qs[_0x466d('0x22')](_0x646117[_0x466d('0x38')][_0x466d('0x22')]);}_0x75f4ad[_0x466d('0x41')]=qs[_0x466d('0x42')](_0x646117[_0x466d('0x38')][_0x466d('0x42')]);_0x75f4ad[_0x466d('0x43')]=qs[_0x466d('0x39')](_[_0x466d('0x44')](_0x646117[_0x466d('0x38')],_0x509b41[_0x466d('0x39')]),_0x36bcdf);if(_0x646117[_0x466d('0x38')][_0x466d('0x45')]){_0x75f4ad[_0x466d('0x43')]=_[_0x466d('0x46')](_0x75f4ad['where'],{'$or':_[_0x466d('0x32')](_0x36bcdf,function(_0x3e6c2d){if(_0x3e6c2d['type']!==_0x466d('0x47')){var _0x338994={};_0x338994[_0x3e6c2d['name']]={'$like':'%'+_0x646117['query'][_0x466d('0x45')]+'%'};return _0x338994;}})});}_0x75f4ad=_[_0x466d('0x46')]({},_0x75f4ad,_0x646117[_0x466d('0x48')]);var _0x2e6e48={'where':_0x75f4ad[_0x466d('0x43')]};return db[_0x466d('0x33')]['count'](_0x2e6e48)[_0x466d('0x2c')](function(_0x55868f){_0x28064a[_0x466d('0x25')]=_0x55868f;if(_0x646117[_0x466d('0x38')]['includeAll']){_0x75f4ad[_0x466d('0x49')]=[{'all':!![]}];}return db['AnalyticCustomReport'][_0x466d('0x4a')](_0x75f4ad);})[_0x466d('0x2c')](function(_0x2adfc1){_0x28064a[_0x466d('0x4b')]=_0x2adfc1;return _0x28064a;})[_0x466d('0x2c')](respondWithFilteredResult(_0x1f864f,_0x75f4ad))[_0x466d('0x4c')](handleError(_0x1f864f,null));};exports[_0x466d('0x4d')]=function(_0x4547e1,_0x479144){var _0x48425d={'raw':![],'where':{'id':_0x4547e1[_0x466d('0x4e')]['id']}},_0x1ab80e={};_0x1ab80e['model']=_[_0x466d('0x4f')](db[_0x466d('0x33')][_0x466d('0x34')]);_0x1ab80e[_0x466d('0x38')]=_[_0x466d('0x4f')](_0x4547e1[_0x466d('0x38')]);_0x1ab80e[_0x466d('0x39')]=_[_0x466d('0x3a')](_0x1ab80e['model'],_0x1ab80e['query']);_0x48425d['attributes']=_[_0x466d('0x3a')](_0x1ab80e[_0x466d('0x3b')],qs[_0x466d('0x3d')](_0x4547e1[_0x466d('0x38')][_0x466d('0x3d')]));_0x48425d[_0x466d('0x3c')]=_0x48425d[_0x466d('0x3c')]['length']?_0x48425d[_0x466d('0x3c')]:_0x1ab80e[_0x466d('0x3b')];if(_0x4547e1['query'][_0x466d('0x50')]){_0x48425d[_0x466d('0x49')]=[{'all':!![]}];}_0x48425d=_[_0x466d('0x46')]({},_0x48425d,_0x4547e1[_0x466d('0x48')]);return db[_0x466d('0x33')][_0x466d('0x51')](_0x48425d)['then'](handleEntityNotFound(_0x479144,null))['then'](respondWithResult(_0x479144,null))[_0x466d('0x4c')](handleError(_0x479144,null));};exports[_0x466d('0x52')]=function(_0x3b4cbd,_0xb84a82){return db[_0x466d('0x33')]['create'](_0x3b4cbd[_0x466d('0x53')],{})[_0x466d('0x2c')](function(_0x43fb3e){var _0x23b9f8=_0x3b4cbd[_0x466d('0x54')][_0x466d('0x55')]({'plain':!![]});if(!_0x23b9f8)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x23b9f8[_0x466d('0x56')]===_0x466d('0x54')){var _0x1d8d4e=_0x43fb3e[_0x466d('0x55')]({'plain':!![]});var _0x1ad05a=_0x466d('0x57');return db[_0x466d('0x58')][_0x466d('0x51')]({'where':{'name':_0x1ad05a,'userProfileId':_0x23b9f8[_0x466d('0x59')]},'raw':!![]})['then'](function(_0x44ec89){if(_0x44ec89&&_0x44ec89[_0x466d('0x5a')]===0x0){return db[_0x466d('0x5b')][_0x466d('0x52')]({'name':_0x1d8d4e[_0x466d('0x31')],'resourceId':_0x1d8d4e['id'],'type':'CustomReports','sectionId':_0x44ec89['id']},{})[_0x466d('0x2c')](function(){return _0x43fb3e;});}else{return _0x43fb3e;}})[_0x466d('0x4c')](function(_0x5e853e){logger[_0x466d('0x2f')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x5e853e);throw _0x5e853e;});}return _0x43fb3e;})[_0x466d('0x2c')](respondWithResult(_0xb84a82,0xc9))[_0x466d('0x4c')](handleError(_0xb84a82,null));};exports[_0x466d('0x2b')]=function(_0x777dda,_0x325ea6){if(_0x777dda['body']['id']){delete _0x777dda[_0x466d('0x53')]['id'];}return db[_0x466d('0x33')][_0x466d('0x51')]({'where':{'id':_0x777dda[_0x466d('0x4e')]['id']}})[_0x466d('0x2c')](handleEntityNotFound(_0x325ea6,null))[_0x466d('0x2c')](saveUpdates(_0x777dda[_0x466d('0x53')],null))[_0x466d('0x2c')](respondWithResult(_0x325ea6,null))['catch'](handleError(_0x325ea6,null));};exports['destroy']=function(_0x2dfd87,_0x555aa1){return db['AnalyticCustomReport'][_0x466d('0x51')]({'where':{'id':_0x2dfd87[_0x466d('0x4e')]['id']}})[_0x466d('0x2c')](handleEntityNotFound(_0x555aa1,null))['then'](removeEntity(_0x555aa1,null))[_0x466d('0x4c')](handleError(_0x555aa1,null));};exports['preview']=function(_0x564755,_0x3a2ae3){var _0x2883ae=0xa;var _0x5c6855=['join',_0x466d('0x5c'),_0x466d('0x5d'),'cross_join'];var _0x5624a7={'SUM':_0x466d('0x5e'),'COUNT':_0x466d('0x5f'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x466d('0x60'),'MIN':_0x466d('0x61'),'AVG':_0x466d('0x62'),'GROUP_CONCAT':_0x466d('0x63'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0x466d('0x64')};var _0x3da099={'SEC_TO_TIME':_0x466d('0x65'),'DATE':_0x466d('0x66'),'HOUR':_0x466d('0x67'),'ROUND':_0x466d('0x68'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x179f76=function(_0x514c66){return!_[_0x466d('0x69')]([_0x466d('0x6a'),_0x466d('0x6b'),_0x466d('0x6c'),_0x466d('0x6d')],_0x514c66);};var _0x29f54d=function(_0x30ddef){if(!_0x30ddef||!_0x30ddef[_0x466d('0x6e')][_0x466d('0x3e')]){return'';}for(var _0x2a18e2='(',_0x3f620e=0x0;_0x3f620e<_0x30ddef['rules'][_0x466d('0x3e')];_0x3f620e+=0x1){_0x3f620e>0x0&&(_0x2a18e2+='\x20'+_0x30ddef[_0x466d('0x6f')]+'\x20');_0x2a18e2+=_0x30ddef[_0x466d('0x6e')][_0x3f620e][_0x466d('0x70')]?_0x29f54d(_0x30ddef[_0x466d('0x6e')][_0x3f620e][_0x466d('0x70')]):_0x30ddef[_0x466d('0x6e')][_0x3f620e]['field']+'\x20'+_0x30ddef[_0x466d('0x6e')][_0x3f620e]['condition']+(_0x179f76(_0x30ddef[_0x466d('0x6e')][_0x3f620e][_0x466d('0x71')])?'\x20'+_0x30ddef['rules'][_0x3f620e][_0x466d('0x72')]:'');}return _0x2a18e2+')';};var _0x3c30d9={'where':{'id':_0x564755[_0x466d('0x4e')]['id']}},_0x36a9f6,_0x3cb2ef,_0x4f4a49,_0x3f3a38,_0x31c56e;_0x3c30d9=_[_0x466d('0x46')]({},_0x3c30d9,_0x564755['options']);return db[_0x466d('0x33')]['find'](_0x3c30d9)[_0x466d('0x2c')](function(_0x18bab9){if(_0x18bab9){_0x36a9f6=_0x18bab9;return _0x18bab9[_0x466d('0x73')]();}return null;})['then'](function(_0x592ece){if(_0x592ece){if(!_0x592ece[_0x466d('0x3e')]){throw new db['Sequelize'][(_0x466d('0x74'))](_0x466d('0x75'),0x193);}_0x3cb2ef=_0x592ece;return db[_0x466d('0x76')][_0x466d('0x4a')]({'raw':!![]});}return null;})[_0x466d('0x2c')](function(_0x1b6e68){if(_0x1b6e68){_0x4f4a49=_['keyBy'](_0x1b6e68,'id');var _0x308a84;var _0x122895=squel[_0x466d('0x77')]();_0x122895['from'](_0x36a9f6[_0x466d('0x78')]);for(var _0x38ebaa=0x0;_0x38ebaa<_0x3cb2ef[_0x466d('0x3e')];_0x38ebaa+=0x1){_0x308a84=_0x3cb2ef[_0x38ebaa][_0x466d('0x79')]?_0x4f4a49[_0x3cb2ef[_0x38ebaa][_0x466d('0x79')]]['metric']:_0x3cb2ef[_0x38ebaa][_0x466d('0x7a')];_0x308a84=_0x3cb2ef[_0x38ebaa][_0x466d('0x7b')]?_[_0x466d('0x7c')](_0x5624a7[_0x3cb2ef[_0x38ebaa]['function']],'%s',_0x308a84):_0x308a84;_0x308a84=_0x3cb2ef[_0x38ebaa][_0x466d('0x7d')]?_[_0x466d('0x7c')](_0x3da099[_0x3cb2ef[_0x38ebaa][_0x466d('0x7d')]],'%s',_0x308a84):_0x308a84;if(_0x3cb2ef[_0x38ebaa][_0x466d('0x7e')]){_0x122895['group'](_0x308a84);}_0x3cb2ef[_0x38ebaa][_0x466d('0x7f')]&&_0x122895[_0x466d('0x41')](_0x308a84,_0x3cb2ef[_0x38ebaa][_0x466d('0x7f')]===_0x466d('0x80')?![]:!![]);_0x122895[_0x466d('0x7a')](_0x308a84,_0x3cb2ef[_0x38ebaa]['alias']||_0x308a84);}if(_0x36a9f6[_0x466d('0x81')]){_0x36a9f6[_0x466d('0x81')]=JSON[_0x466d('0x82')](_0x36a9f6[_0x466d('0x81')]);for(var _0x3bcb54=0x0;_0x3bcb54<_0x36a9f6['joins'][_0x466d('0x3e')];_0x3bcb54+=0x1){if(_0x36a9f6[_0x466d('0x81')][_0x3bcb54][_0x466d('0x36')]&&_[_0x466d('0x69')](_0x5c6855,_0x36a9f6[_0x466d('0x81')][_0x3bcb54]['type'])&&_0x36a9f6['joins'][_0x3bcb54][_0x466d('0x83')]&&_0x36a9f6[_0x466d('0x81')][_0x3bcb54]['foreignTable']&&_0x36a9f6[_0x466d('0x81')][_0x3bcb54][_0x466d('0x84')]){_0x122895[_0x36a9f6[_0x466d('0x81')][_0x3bcb54]['type']](_0x36a9f6[_0x466d('0x81')][_0x3bcb54][_0x466d('0x85')],null,util[_0x466d('0x7d')](_0x466d('0x86'),_0x36a9f6['table'],_0x36a9f6[_0x466d('0x81')][_0x3bcb54][_0x466d('0x83')],_0x36a9f6['joins'][_0x3bcb54]['foreignTable'],_0x36a9f6[_0x466d('0x81')][_0x3bcb54]['foreignKey']));}}}if(_0x36a9f6[_0x466d('0x87')]){_0x36a9f6[_0x466d('0x87')]=JSON[_0x466d('0x82')](_0x36a9f6['conditions']);_0x122895[_0x466d('0x43')](_0x29f54d(_0x36a9f6[_0x466d('0x87')]['group']));}_0x31c56e=_0x122895[_0x466d('0x88')]();_0x122895[_0x466d('0x24')](_0x2883ae);_0x122895[_0x466d('0x22')](0x0);logger[_0x466d('0x89')](_0x466d('0x8a'),_0x122895[_0x466d('0x8b')]());return dbH[_0x466d('0x8c')][_0x466d('0x38')](_0x122895[_0x466d('0x8b')](),{'type':dbH['sequelize']['QueryTypes']['SELECT']});}})['then'](respondWithResult(_0x3a2ae3,null))[_0x466d('0x4c')](handleError(_0x3a2ae3,null));};function runReport(_0x1c9726,_0x47856b,_0x402c1e){var _0x118040=_0x47856b[_0x466d('0x31')];var _0x73eb91=0xa;var _0x42de5c=[_0x466d('0x8d'),_0x466d('0x5c'),_0x466d('0x5d'),_0x466d('0x8e')];var _0x281003={'SUM':'SUM(%s)','COUNT':_0x466d('0x5f'),'COUNT DISTINCT':_0x466d('0x8f'),'MAX':_0x466d('0x60'),'MIN':'MIN(%s)','AVG':_0x466d('0x62'),'GROUP_CONCAT':_0x466d('0x63'),'GROUP_CONCAT ASC':_0x466d('0x90'),'GROUP_CONCAT DESC':_0x466d('0x64')};var _0x20926b={'SEC_TO_TIME':_0x466d('0x65'),'DATE':_0x466d('0x66'),'HOUR':'HOUR(%s)','ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x466d('0x91')};var _0x55d86e=function(_0x283983){return!_['includes'](['IS\x20NULL',_0x466d('0x6b'),_0x466d('0x6c'),_0x466d('0x6d')],_0x283983);};var _0x2eab48=function(_0x262bb5){if(!_0x262bb5||!_0x262bb5[_0x466d('0x6e')]['length']){return'';}for(var _0x21992d='(',_0x445140=0x0;_0x445140<_0x262bb5['rules'][_0x466d('0x3e')];_0x445140+=0x1){_0x445140>0x0&&(_0x21992d+='\x20'+_0x262bb5['operator']+'\x20');_0x21992d+=_0x262bb5[_0x466d('0x6e')][_0x445140][_0x466d('0x70')]?_0x2eab48(_0x262bb5[_0x466d('0x6e')][_0x445140][_0x466d('0x70')]):_0x262bb5[_0x466d('0x6e')][_0x445140][_0x466d('0x7a')]+'\x20'+_0x262bb5[_0x466d('0x6e')][_0x445140]['condition']+(_0x55d86e(_0x262bb5[_0x466d('0x6e')][_0x445140]['condition'])?'\x20'+_0x262bb5[_0x466d('0x6e')][_0x445140][_0x466d('0x72')]:'');}return _0x21992d+')';};var _0x1d7bcb={'where':{'id':_0x1c9726['id']}},_0x105428,_0xe2d1c,_0x48c541,_0x20aa79,_0x45f314;_0x1d7bcb=_[_0x466d('0x46')]({},_0x1d7bcb,_0x402c1e);return db['AnalyticCustomReport'][_0x466d('0x51')](_0x1d7bcb)[_0x466d('0x2c')](function(_0x3d78a2){if(_0x3d78a2){_0x105428=_0x3d78a2;return _0x3d78a2[_0x466d('0x73')]();}return null;})['then'](function(_0x578e19){if(_0x578e19){if(!_0x578e19['length']){throw new db[(_0x466d('0x92'))][(_0x466d('0x74'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0xe2d1c=_0x578e19;return db[_0x466d('0x76')][_0x466d('0x4a')]({'raw':!![]});}return null;})['then'](function(_0xa7cca0){if(_0xa7cca0){_0x48c541=_[_0x466d('0x93')](_0xa7cca0,'id');var _0x23a8c9;var _0x34aaf1=squel[_0x466d('0x77')]();_0x34aaf1[_0x466d('0x94')](_0x105428[_0x466d('0x78')]);for(var _0x20c6f6=0x0;_0x20c6f6<_0xe2d1c[_0x466d('0x3e')];_0x20c6f6+=0x1){_0x23a8c9=_0xe2d1c[_0x20c6f6][_0x466d('0x79')]?_0x48c541[_0xe2d1c[_0x20c6f6][_0x466d('0x79')]][_0x466d('0x95')]:_0xe2d1c[_0x20c6f6][_0x466d('0x7a')];_0x23a8c9=_0xe2d1c[_0x20c6f6][_0x466d('0x7b')]?_[_0x466d('0x7c')](_0x281003[_0xe2d1c[_0x20c6f6][_0x466d('0x7b')]],'%s',_0x23a8c9):_0x23a8c9;_0x23a8c9=_0xe2d1c[_0x20c6f6][_0x466d('0x7d')]?_[_0x466d('0x7c')](_0x20926b[_0xe2d1c[_0x20c6f6]['format']],'%s',_0x23a8c9):_0x23a8c9;if(_0xe2d1c[_0x20c6f6][_0x466d('0x7e')]){_0x34aaf1['group'](_0x23a8c9);}_0xe2d1c[_0x20c6f6]['orderBy']&&_0x34aaf1[_0x466d('0x41')](_0x23a8c9,_0xe2d1c[_0x20c6f6][_0x466d('0x7f')]===_0x466d('0x80')?![]:!![]);_0x34aaf1[_0x466d('0x7a')](_0x23a8c9,_0xe2d1c[_0x20c6f6]['alias']||_0x23a8c9);}if(_0x105428['joins']){_0x105428[_0x466d('0x81')]=JSON['parse'](_0x105428[_0x466d('0x81')]);for(var _0x48dd61=0x0;_0x48dd61<_0x105428[_0x466d('0x81')]['length'];_0x48dd61+=0x1){if(_0x105428[_0x466d('0x81')][_0x48dd61][_0x466d('0x36')]&&_[_0x466d('0x69')](_0x42de5c,_0x105428[_0x466d('0x81')][_0x48dd61]['type'])&&_0x105428[_0x466d('0x81')][_0x48dd61][_0x466d('0x83')]&&_0x105428[_0x466d('0x81')][_0x48dd61][_0x466d('0x85')]&&_0x105428[_0x466d('0x81')][_0x48dd61]['foreignKey']){_0x34aaf1[_0x105428[_0x466d('0x81')][_0x48dd61][_0x466d('0x36')]](_0x105428['joins'][_0x48dd61]['foreignTable'],null,util['format'](_0x466d('0x86'),_0x105428['table'],_0x105428[_0x466d('0x81')][_0x48dd61]['parentKey'],_0x105428['joins'][_0x48dd61][_0x466d('0x85')],_0x105428[_0x466d('0x81')][_0x48dd61][_0x466d('0x84')]));}}}if(_0x105428['conditions']){_0x105428[_0x466d('0x87')]=JSON['parse'](_0x105428[_0x466d('0x87')]);_0x34aaf1[_0x466d('0x43')](_0x2eab48(_0x105428['conditions'][_0x466d('0x70')]));}_0x45f314=_0x34aaf1['clone']();_0x34aaf1[_0x466d('0x24')](_0x73eb91);_0x34aaf1['offset'](0x0);return;}})[_0x466d('0x2c')](function(){if(_0x47856b['output']===_0x466d('0x96')){return null;}var _0x2a4d14=_['merge'](_0x47856b,{'name':_0x47856b[_0x466d('0x97')]||_0x47856b['name']||_0x105428[_0x466d('0x31')],'basename':_0x118040,'savename':util[_0x466d('0x7d')](_0x466d('0x98'),_0x47856b['name']||_0x105428[_0x466d('0x31')],require(_0x466d('0x99'))[_0x466d('0x9a')](0x4),_0x47856b['output']||_0x466d('0x9b')),'reportId':_0x105428['id'],'reportType':'custom'});return db[_0x466d('0x9c')][_0x466d('0x52')](_0x2a4d14,{'raw':!![]});})['then'](function(_0x4592e1){if(_0x105428[_0x466d('0x78')]==='cdr'){_0x45f314[_0x466d('0x43')](_0x105428[_0x466d('0x78')]+_0x466d('0x9d'),_0x47856b[_0x466d('0x9e')],_0x47856b[_0x466d('0x9f')]);}else{_0x45f314[_0x466d('0x43')](_0x105428[_0x466d('0x78')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x47856b[_0x466d('0x9e')],_0x47856b[_0x466d('0x9f')]);}if(_0x4592e1){logger[_0x466d('0xa0')](_0x466d('0xa1'),_0x45f314[_0x466d('0x8b')]());require('child_process')[_0x466d('0xa2')](path[_0x466d('0x8d')](__dirname,'../../components/export/',_0x4592e1[_0x466d('0xa3')]),[_0x4592e1['id'],_0x45f314[_0x466d('0x8b')](),path[_0x466d('0x8d')](__dirname,_0x466d('0xa4'),_0x4592e1['savename']),_0x118040]);return _0x4592e1;}else{var _0x27d936=squel[_0x466d('0x77')]();_0x27d936['from']('('+_0x45f314['toString']()+')',_0x466d('0xa5'));_0x27d936['field'](_0x466d('0xa6'),'count');_0x45f314['limit'](_0x47856b[_0x466d('0x24')]||_0x73eb91);_0x45f314[_0x466d('0x22')](_0x47856b[_0x466d('0x22')]||0x0);return dbH[_0x466d('0x8c')][_0x466d('0x38')](_0x27d936['toString'](),{'type':dbH['sequelize'][_0x466d('0xa7')][_0x466d('0xa8')]})['then'](function(_0x56c1d7){if(!_0x56c1d7[_0x466d('0x3e')]){_0x20aa79=0x0;}else{_0x20aa79=_0x56c1d7[0x0][_0x466d('0x25')]||0x0;}return dbH['sequelize'][_0x466d('0x38')](_0x45f314[_0x466d('0x8b')](),{'type':dbH[_0x466d('0x8c')]['QueryTypes'][_0x466d('0xa8')]});})[_0x466d('0x2c')](function(_0x5c55ec){return{'rows':_0x5c55ec||[],'count':_0x20aa79};});}});}exports[_0x466d('0xa9')]=function(_0x40f028,_0x42e883){return runReport(_0x40f028[_0x466d('0x4e')],_0x40f028['query'],_0x40f028['options'])[_0x466d('0x2c')](respondWithResult(_0x42e883,null))[_0x466d('0x4c')](handleError(_0x42e883,null));};exports['runReport']=runReport;exports[_0x466d('0x38')]=function(_0x5a91d4,_0x4775c4){var _0x171bb2=0xa;var _0x3569b1=[_0x466d('0x8d'),_0x466d('0x5c'),_0x466d('0x5d'),_0x466d('0x8e')];var _0x67f602={'SUM':_0x466d('0x5e'),'COUNT':_0x466d('0x5f'),'COUNT DISTINCT':_0x466d('0x8f'),'MAX':_0x466d('0x60'),'MIN':_0x466d('0x61'),'AVG':'AVG(%s)','GROUP_CONCAT':_0x466d('0x63'),'GROUP_CONCAT ASC':_0x466d('0x90'),'GROUP_CONCAT DESC':_0x466d('0x64')};var _0x22610b={'SEC_TO_TIME':_0x466d('0x65'),'DATE':_0x466d('0x66'),'HOUR':_0x466d('0x67'),'ROUND':_0x466d('0x68'),'UNIX_TIMESTAMP':_0x466d('0x91')};var _0x5f0697=function(_0x270546){return!_[_0x466d('0x69')]([_0x466d('0x6a'),_0x466d('0x6b'),_0x466d('0x6c'),_0x466d('0x6d')],_0x270546);};var _0x6cfe92=function(_0x5ac828){if(!_0x5ac828||!_0x5ac828[_0x466d('0x6e')][_0x466d('0x3e')]){return'';}for(var _0x119bc5='(',_0x2b5f6e=0x0;_0x2b5f6e<_0x5ac828[_0x466d('0x6e')][_0x466d('0x3e')];_0x2b5f6e+=0x1){_0x2b5f6e>0x0&&(_0x119bc5+='\x20'+_0x5ac828[_0x466d('0x6f')]+'\x20');_0x119bc5+=_0x5ac828[_0x466d('0x6e')][_0x2b5f6e]['group']?_0x6cfe92(_0x5ac828['rules'][_0x2b5f6e]['group']):_0x5ac828[_0x466d('0x6e')][_0x2b5f6e][_0x466d('0x7a')]+'\x20'+_0x5ac828[_0x466d('0x6e')][_0x2b5f6e]['condition']+(_0x5f0697(_0x5ac828[_0x466d('0x6e')][_0x2b5f6e]['condition'])?'\x20'+_0x5ac828[_0x466d('0x6e')][_0x2b5f6e][_0x466d('0x72')]:'');}return _0x119bc5+')';};var _0x45bd04={'where':{'id':_0x5a91d4[_0x466d('0x4e')]['id']}},_0x1edc97,_0x5f13c7,_0x3ed851,_0x260b6b,_0x1054b2;_0x45bd04=_['merge']({},_0x45bd04,_0x5a91d4['options']);return db[_0x466d('0x33')]['find'](_0x45bd04)[_0x466d('0x2c')](function(_0x324a87){if(_0x324a87){_0x1edc97=_0x324a87;return _0x324a87[_0x466d('0x73')]();}return null;})[_0x466d('0x2c')](function(_0x58047b){if(_0x58047b){if(!_0x58047b[_0x466d('0x3e')]){throw new db[(_0x466d('0x92'))][(_0x466d('0x74'))](_0x466d('0x75'),0x193);}_0x5f13c7=_0x58047b;return db[_0x466d('0x76')][_0x466d('0x4a')]({'raw':!![]});}return null;})['then'](function(_0x1c6c51){if(_0x1c6c51){_0x3ed851=_[_0x466d('0x93')](_0x1c6c51,'id');var _0x48b8b3;var _0x324747=squel[_0x466d('0x77')]();_0x324747['from'](_0x1edc97[_0x466d('0x78')]);for(var _0x54d89c=0x0;_0x54d89c<_0x5f13c7[_0x466d('0x3e')];_0x54d89c+=0x1){_0x48b8b3=_0x5f13c7[_0x54d89c][_0x466d('0x79')]?_0x3ed851[_0x5f13c7[_0x54d89c]['MetricId']][_0x466d('0x95')]:_0x5f13c7[_0x54d89c][_0x466d('0x7a')];_0x48b8b3=_0x5f13c7[_0x54d89c]['function']?_[_0x466d('0x7c')](_0x67f602[_0x5f13c7[_0x54d89c]['function']],'%s',_0x48b8b3):_0x48b8b3;_0x48b8b3=_0x5f13c7[_0x54d89c][_0x466d('0x7d')]?_[_0x466d('0x7c')](_0x22610b[_0x5f13c7[_0x54d89c][_0x466d('0x7d')]],'%s',_0x48b8b3):_0x48b8b3;if(_0x5f13c7[_0x54d89c]['groupBy']){_0x324747[_0x466d('0x70')](_0x48b8b3);}_0x5f13c7[_0x54d89c][_0x466d('0x7f')]&&_0x324747[_0x466d('0x41')](_0x48b8b3,_0x5f13c7[_0x54d89c][_0x466d('0x7f')]===_0x466d('0x80')?![]:!![]);_0x324747[_0x466d('0x7a')](_0x48b8b3,_0x5f13c7[_0x54d89c][_0x466d('0xaa')]||_0x48b8b3);}if(_0x1edc97['joins']){_0x1edc97['joins']=JSON['parse'](_0x1edc97[_0x466d('0x81')]);for(var _0x31be55=0x0;_0x31be55<_0x1edc97[_0x466d('0x81')][_0x466d('0x3e')];_0x31be55+=0x1){if(_0x1edc97[_0x466d('0x81')][_0x31be55][_0x466d('0x36')]&&_[_0x466d('0x69')](_0x3569b1,_0x1edc97['joins'][_0x31be55][_0x466d('0x36')])&&_0x1edc97[_0x466d('0x81')][_0x31be55][_0x466d('0x83')]&&_0x1edc97[_0x466d('0x81')][_0x31be55]['foreignTable']&&_0x1edc97[_0x466d('0x81')][_0x31be55][_0x466d('0x84')]){_0x324747[_0x1edc97[_0x466d('0x81')][_0x31be55]['type']](_0x1edc97[_0x466d('0x81')][_0x31be55][_0x466d('0x85')],null,util[_0x466d('0x7d')]('%s.%s\x20=\x20%s.%s',_0x1edc97[_0x466d('0x78')],_0x1edc97[_0x466d('0x81')][_0x31be55][_0x466d('0x83')],_0x1edc97[_0x466d('0x81')][_0x31be55][_0x466d('0x85')],_0x1edc97[_0x466d('0x81')][_0x31be55][_0x466d('0x84')]));}}}if(_0x1edc97['conditions']){_0x1edc97['conditions']=JSON[_0x466d('0x82')](_0x1edc97[_0x466d('0x87')]);_0x324747[_0x466d('0x43')](_0x6cfe92(_0x1edc97[_0x466d('0x87')][_0x466d('0x70')]));}_0x1054b2=_0x324747['clone']();_0x324747[_0x466d('0x24')](_0x171bb2);_0x324747[_0x466d('0x22')](0x0);logger[_0x466d('0x89')]('Limited\x20Query:',_0x324747[_0x466d('0x8b')]());return dbH[_0x466d('0x8c')]['query'](_0x324747[_0x466d('0x8b')](),{'type':dbH['sequelize'][_0x466d('0xa7')][_0x466d('0xa8')]});}})['then'](function(){return{'sql':_0x1054b2[_0x466d('0x8b')]()};})[_0x466d('0x2c')](respondWithResult(_0x4775c4,null))[_0x466d('0x4c')](handleError(_0x4775c4,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff