// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x5a1b=['Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','select','table','MetricId','metric','field','function','format','replace','groupBy','orderBy','alias','joins','parentKey','foreignKey','foreignTable','%s.%s\x20=\x20%s.%s','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','cross_join','SUM(%s)','includes','IS\x20NULL','from','DESC','parse','output','web','fullPath','randomstring','generate','csv','custom','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','endDate','info','child_process','fork','../../components/export/','../../files/reports','savename','COUNT(*)','run','runReport','DATE(%s)','HOUR(%s)','getFields','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','path','to-csv','ejs','lodash','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','count','offset','limit','set','Content-Range','apply','update','then','destroy','get','CustomReports','UserProfileResource','error','stack','name','send','index','map','AnalyticCustomReport','rawAttributes','type','key','model','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','options','include','findAll','catch','show','params','keys','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','UserProfileSection','userProfileId','autoAssociation','body','preview','join','left_join','right_join','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)','SEC_TO_TIME(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','condition','value'];(function(_0x25edd2,_0x564c8c){var _0x26eaf6=function(_0x937195){while(--_0x937195){_0x25edd2['push'](_0x25edd2['shift']());}};_0x26eaf6(++_0x564c8c);}(_0x5a1b,0xe6));var _0xb5a1=function(_0x38f5cf,_0x2c455b){_0x38f5cf=_0x38f5cf-0x0;var _0x5af4ac=_0x5a1b[_0x38f5cf];return _0x5af4ac;};'use strict';var pdf=require(_0xb5a1('0x0'));var emlformat=require(_0xb5a1('0x1'));var rimraf=require(_0xb5a1('0x2'));var zipdir=require(_0xb5a1('0x3'));var jsonpatch=require(_0xb5a1('0x4'));var rp=require('request-promise');var moment=require(_0xb5a1('0x5'));var BPromise=require(_0xb5a1('0x6'));var Mustache=require(_0xb5a1('0x7'));var util=require('util');var path=require(_0xb5a1('0x8'));var sox=require('sox');var csv=require(_0xb5a1('0x9'));var ejs=require(_0xb5a1('0xa'));var fs=require('fs');var _=require(_0xb5a1('0xb'));var squel=require('squel');var crypto=require(_0xb5a1('0xc'));var jsforce=require(_0xb5a1('0xd'));var deskjs=require(_0xb5a1('0xe'));var toCsv=require(_0xb5a1('0x9'));var querystring=require('querystring');var Papa=require(_0xb5a1('0xf'));var Redis=require(_0xb5a1('0x10'));var authService=require(_0xb5a1('0x11'));var qs=require(_0xb5a1('0x12'));var as=require(_0xb5a1('0x13'));var hardwareService=require(_0xb5a1('0x14'));var logger=require(_0xb5a1('0x15'))(_0xb5a1('0x16'));var utils=require(_0xb5a1('0x17'));var config=require(_0xb5a1('0x18'));var licenseUtil=require(_0xb5a1('0x19'));var db=require(_0xb5a1('0x1a'))['db'];var dbH=require(_0xb5a1('0x1a'))['dbH'];function respondWithStatusCode(_0x8d5524,_0x493508){_0x493508=_0x493508||0xcc;return function(_0x1c5c0b){if(_0x1c5c0b){return _0x8d5524[_0xb5a1('0x1b')](_0x493508);}return _0x8d5524[_0xb5a1('0x1c')](_0x493508)[_0xb5a1('0x1d')]();};}function respondWithResult(_0x31a540,_0x43386e){_0x43386e=_0x43386e||0xc8;return function(_0x1b7198){if(_0x1b7198){return _0x31a540[_0xb5a1('0x1c')](_0x43386e)[_0xb5a1('0x1e')](_0x1b7198);}};}function respondWithFilteredResult(_0x56932a,_0x4cda72){return function(_0x37da70){if(_0x37da70){var _0x485e0e=_0x37da70[_0xb5a1('0x1f')],_0x5522e1=_0x4cda72[_0xb5a1('0x20')],_0x47c3f9=_0x4cda72[_0xb5a1('0x20')]+_0x4cda72[_0xb5a1('0x21')],_0x5ba229;if(_0x47c3f9>=_0x485e0e){_0x47c3f9=_0x485e0e;_0x5ba229=0xc8;}else{_0x5ba229=0xce;}_0x56932a['status'](_0x5ba229);return _0x56932a[_0xb5a1('0x22')](_0xb5a1('0x23'),_0x5522e1+'-'+_0x47c3f9+'/'+_0x485e0e)['json'](_0x37da70);}return null;};}function patchUpdates(_0x34a4de){return function(_0x10854c){try{jsonpatch[_0xb5a1('0x24')](_0x10854c,_0x34a4de,!![]);}catch(_0x169c5c){return BPromise['reject'](_0x169c5c);}return _0x10854c['save']();};}function saveUpdates(_0x36a2b2,_0x560a91){return function(_0xe283f1){if(_0xe283f1){return _0xe283f1[_0xb5a1('0x25')](_0x36a2b2)[_0xb5a1('0x26')](function(_0x1cc9ab){return _0x1cc9ab;});}return null;};}function removeEntity(_0x51cf17,_0x16977b){return function(_0x295a97){if(_0x295a97){return _0x295a97[_0xb5a1('0x27')]()[_0xb5a1('0x26')](function(){var _0xa425f6=_0x295a97[_0xb5a1('0x28')]({'plain':!![]});var _0x58edd7=_0xb5a1('0x29');return db[_0xb5a1('0x2a')][_0xb5a1('0x27')]({'where':{'type':_0x58edd7,'resourceId':_0xa425f6['id']}})[_0xb5a1('0x26')](function(){return _0x295a97;});})[_0xb5a1('0x26')](function(){_0x51cf17[_0xb5a1('0x1c')](0xcc)[_0xb5a1('0x1d')]();});}};}function handleEntityNotFound(_0x55b363,_0x391293){return function(_0x540e79){if(!_0x540e79){_0x55b363['sendStatus'](0x194);}return _0x540e79;};}function handleError(_0x40e8b7,_0x32e175){_0x32e175=_0x32e175||0x1f4;return function(_0x4d93aa){logger[_0xb5a1('0x2b')](_0x4d93aa[_0xb5a1('0x2c')]);if(_0x4d93aa[_0xb5a1('0x2d')]){delete _0x4d93aa[_0xb5a1('0x2d')];}_0x40e8b7[_0xb5a1('0x1c')](_0x32e175)[_0xb5a1('0x2e')](_0x4d93aa);};}exports[_0xb5a1('0x2f')]=function(_0x2aa0b5,_0x230f2d){var _0x404e6f={},_0x238b1c={},_0x386da7={'count':0x0,'rows':[]};var _0xca3ddc=_[_0xb5a1('0x30')](db[_0xb5a1('0x31')][_0xb5a1('0x32')],function(_0x4267ce){return{'name':_0x4267ce['fieldName'],'type':_0x4267ce[_0xb5a1('0x33')][_0xb5a1('0x34')]};});_0x238b1c[_0xb5a1('0x35')]=_[_0xb5a1('0x30')](_0xca3ddc,_0xb5a1('0x2d'));_0x238b1c['query']=_['keys'](_0x2aa0b5[_0xb5a1('0x36')]);_0x238b1c[_0xb5a1('0x37')]=_[_0xb5a1('0x38')](_0x238b1c[_0xb5a1('0x35')],_0x238b1c['query']);_0x404e6f[_0xb5a1('0x39')]=_[_0xb5a1('0x38')](_0x238b1c[_0xb5a1('0x35')],qs[_0xb5a1('0x3a')](_0x2aa0b5[_0xb5a1('0x36')][_0xb5a1('0x3a')]));_0x404e6f['attributes']=_0x404e6f[_0xb5a1('0x39')][_0xb5a1('0x3b')]?_0x404e6f['attributes']:_0x238b1c[_0xb5a1('0x35')];if(!_0x2aa0b5[_0xb5a1('0x36')][_0xb5a1('0x3c')](_0xb5a1('0x3d'))){_0x404e6f['limit']=qs[_0xb5a1('0x21')](_0x2aa0b5['query']['limit']);_0x404e6f[_0xb5a1('0x20')]=qs[_0xb5a1('0x20')](_0x2aa0b5['query'][_0xb5a1('0x20')]);}_0x404e6f[_0xb5a1('0x3e')]=qs[_0xb5a1('0x3f')](_0x2aa0b5['query'][_0xb5a1('0x3f')]);_0x404e6f[_0xb5a1('0x40')]=qs[_0xb5a1('0x37')](_[_0xb5a1('0x41')](_0x2aa0b5[_0xb5a1('0x36')],_0x238b1c[_0xb5a1('0x37')]),_0xca3ddc);if(_0x2aa0b5['query'][_0xb5a1('0x42')]){_0x404e6f[_0xb5a1('0x40')]=_[_0xb5a1('0x43')](_0x404e6f['where'],{'$or':_['map'](_0xca3ddc,function(_0x16ddaf){if(_0x16ddaf[_0xb5a1('0x33')]!=='VIRTUAL'){var _0x17d4d7={};_0x17d4d7[_0x16ddaf[_0xb5a1('0x2d')]]={'$like':'%'+_0x2aa0b5[_0xb5a1('0x36')][_0xb5a1('0x42')]+'%'};return _0x17d4d7;}})});}_0x404e6f=_[_0xb5a1('0x43')]({},_0x404e6f,_0x2aa0b5[_0xb5a1('0x44')]);var _0x48e4c9={'where':_0x404e6f[_0xb5a1('0x40')]};return db[_0xb5a1('0x31')][_0xb5a1('0x1f')](_0x48e4c9)[_0xb5a1('0x26')](function(_0x23a80){_0x386da7[_0xb5a1('0x1f')]=_0x23a80;if(_0x2aa0b5[_0xb5a1('0x36')]['includeAll']){_0x404e6f[_0xb5a1('0x45')]=[{'all':!![]}];}return db['AnalyticCustomReport'][_0xb5a1('0x46')](_0x404e6f);})[_0xb5a1('0x26')](function(_0x3def4f){_0x386da7['rows']=_0x3def4f;return _0x386da7;})[_0xb5a1('0x26')](respondWithFilteredResult(_0x230f2d,_0x404e6f))[_0xb5a1('0x47')](handleError(_0x230f2d,null));};exports[_0xb5a1('0x48')]=function(_0x1d2d3f,_0xc6b896){var _0x13c30e={'raw':![],'where':{'id':_0x1d2d3f[_0xb5a1('0x49')]['id']}},_0x181a13={};_0x181a13[_0xb5a1('0x35')]=_[_0xb5a1('0x4a')](db[_0xb5a1('0x31')][_0xb5a1('0x32')]);_0x181a13[_0xb5a1('0x36')]=_[_0xb5a1('0x4a')](_0x1d2d3f['query']);_0x181a13[_0xb5a1('0x37')]=_['intersection'](_0x181a13[_0xb5a1('0x35')],_0x181a13['query']);_0x13c30e['attributes']=_['intersection'](_0x181a13[_0xb5a1('0x35')],qs[_0xb5a1('0x3a')](_0x1d2d3f[_0xb5a1('0x36')]['fields']));_0x13c30e[_0xb5a1('0x39')]=_0x13c30e['attributes'][_0xb5a1('0x3b')]?_0x13c30e['attributes']:_0x181a13['model'];if(_0x1d2d3f['query']['includeAll']){_0x13c30e[_0xb5a1('0x45')]=[{'all':!![]}];}_0x13c30e=_[_0xb5a1('0x43')]({},_0x13c30e,_0x1d2d3f[_0xb5a1('0x44')]);return db[_0xb5a1('0x31')][_0xb5a1('0x4b')](_0x13c30e)[_0xb5a1('0x26')](handleEntityNotFound(_0xc6b896,null))[_0xb5a1('0x26')](respondWithResult(_0xc6b896,null))[_0xb5a1('0x47')](handleError(_0xc6b896,null));};exports[_0xb5a1('0x4c')]=function(_0x2b5260,_0x52cf23){return db['AnalyticCustomReport'][_0xb5a1('0x4c')](_0x2b5260['body'],{})[_0xb5a1('0x26')](function(_0x45c651){var _0x12bee4=_0x2b5260[_0xb5a1('0x4d')]['get']({'plain':!![]});if(!_0x12bee4)throw new Error(_0xb5a1('0x4e'));if(_0x12bee4[_0xb5a1('0x4f')]===_0xb5a1('0x4d')){var _0x359c1e=_0x45c651[_0xb5a1('0x28')]({'plain':!![]});var _0x3e71c0=_0xb5a1('0x50');return db[_0xb5a1('0x51')][_0xb5a1('0x4b')]({'where':{'name':_0x3e71c0,'userProfileId':_0x12bee4[_0xb5a1('0x52')]},'raw':!![]})['then'](function(_0x286dec){if(_0x286dec&&_0x286dec[_0xb5a1('0x53')]===0x0){return db['UserProfileResource'][_0xb5a1('0x4c')]({'name':_0x359c1e[_0xb5a1('0x2d')],'resourceId':_0x359c1e['id'],'type':_0xb5a1('0x29'),'sectionId':_0x286dec['id']},{})[_0xb5a1('0x26')](function(){return _0x45c651;});}else{return _0x45c651;}})['catch'](function(_0x53bcca){logger[_0xb5a1('0x2b')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x53bcca);throw _0x53bcca;});}return _0x45c651;})[_0xb5a1('0x26')](respondWithResult(_0x52cf23,0xc9))[_0xb5a1('0x47')](handleError(_0x52cf23,null));};exports['update']=function(_0x586f53,_0x60bef4){if(_0x586f53['body']['id']){delete _0x586f53[_0xb5a1('0x54')]['id'];}return db[_0xb5a1('0x31')][_0xb5a1('0x4b')]({'where':{'id':_0x586f53[_0xb5a1('0x49')]['id']}})['then'](handleEntityNotFound(_0x60bef4,null))[_0xb5a1('0x26')](saveUpdates(_0x586f53[_0xb5a1('0x54')],null))['then'](respondWithResult(_0x60bef4,null))[_0xb5a1('0x47')](handleError(_0x60bef4,null));};exports[_0xb5a1('0x27')]=function(_0x5dadef,_0x55f574){return db[_0xb5a1('0x31')]['find']({'where':{'id':_0x5dadef['params']['id']}})[_0xb5a1('0x26')](handleEntityNotFound(_0x55f574,null))['then'](removeEntity(_0x55f574,null))[_0xb5a1('0x47')](handleError(_0x55f574,null));};exports[_0xb5a1('0x55')]=function(_0x412098,_0x32c495){var _0x34ee1c=0xa;var _0x5b4b67=[_0xb5a1('0x56'),_0xb5a1('0x57'),_0xb5a1('0x58'),'cross_join'];var _0x317820={'SUM':'SUM(%s)','COUNT':_0xb5a1('0x59'),'COUNT DISTINCT':_0xb5a1('0x5a'),'MAX':_0xb5a1('0x5b'),'MIN':_0xb5a1('0x5c'),'AVG':_0xb5a1('0x5d'),'GROUP_CONCAT':_0xb5a1('0x5e'),'GROUP_CONCAT ASC':_0xb5a1('0x5f'),'GROUP_CONCAT DESC':_0xb5a1('0x60')};var _0x547f06={'SEC_TO_TIME':_0xb5a1('0x61'),'DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':_0xb5a1('0x62'),'UNIX_TIMESTAMP':_0xb5a1('0x63')};var _0x4a3344=function(_0x53bc2c){return!_['includes'](['IS\x20NULL',_0xb5a1('0x64'),_0xb5a1('0x65'),_0xb5a1('0x66')],_0x53bc2c);};var _0x2bf986=function(_0x70dfca){if(!_0x70dfca||!_0x70dfca[_0xb5a1('0x67')]['length']){return'';}for(var _0x11eb3c='(',_0x6dc627=0x0;_0x6dc627<_0x70dfca[_0xb5a1('0x67')][_0xb5a1('0x3b')];_0x6dc627+=0x1){_0x6dc627>0x0&&(_0x11eb3c+='\x20'+_0x70dfca[_0xb5a1('0x68')]+'\x20');_0x11eb3c+=_0x70dfca[_0xb5a1('0x67')][_0x6dc627]['group']?_0x2bf986(_0x70dfca[_0xb5a1('0x67')][_0x6dc627][_0xb5a1('0x69')]):_0x70dfca[_0xb5a1('0x67')][_0x6dc627]['field']+'\x20'+_0x70dfca['rules'][_0x6dc627][_0xb5a1('0x6a')]+(_0x4a3344(_0x70dfca[_0xb5a1('0x67')][_0x6dc627][_0xb5a1('0x6a')])?'\x20'+_0x70dfca[_0xb5a1('0x67')][_0x6dc627][_0xb5a1('0x6b')]:'');}return _0x11eb3c+')';};var _0x176fd7={'where':{'id':_0x412098[_0xb5a1('0x49')]['id']}},_0x10b7f9,_0x2c5d36,_0x48a1d7,_0x10d31e,_0x505633;_0x176fd7=_[_0xb5a1('0x43')]({},_0x176fd7,_0x412098['options']);return db[_0xb5a1('0x31')]['find'](_0x176fd7)['then'](function(_0x32ff7d){if(_0x32ff7d){_0x10b7f9=_0x32ff7d;return _0x32ff7d['getFields']();}return null;})[_0xb5a1('0x26')](function(_0xc0184f){if(_0xc0184f){if(!_0xc0184f[_0xb5a1('0x3b')]){throw new db[(_0xb5a1('0x6c'))][(_0xb5a1('0x6d'))](_0xb5a1('0x6e'),0x193);}_0x2c5d36=_0xc0184f;return db[_0xb5a1('0x6f')]['findAll']({'raw':!![]});}return null;})[_0xb5a1('0x26')](function(_0x333425){if(_0x333425){_0x48a1d7=_[_0xb5a1('0x70')](_0x333425,'id');var _0x1cd464;var _0x14b346=squel[_0xb5a1('0x71')]();_0x14b346['from'](_0x10b7f9[_0xb5a1('0x72')]);for(var _0x568235=0x0;_0x568235<_0x2c5d36[_0xb5a1('0x3b')];_0x568235+=0x1){_0x1cd464=_0x2c5d36[_0x568235][_0xb5a1('0x73')]?_0x48a1d7[_0x2c5d36[_0x568235][_0xb5a1('0x73')]][_0xb5a1('0x74')]:_0x2c5d36[_0x568235][_0xb5a1('0x75')];_0x1cd464=_0x2c5d36[_0x568235][_0xb5a1('0x76')]?_['replace'](_0x317820[_0x2c5d36[_0x568235]['function']],'%s',_0x1cd464):_0x1cd464;_0x1cd464=_0x2c5d36[_0x568235][_0xb5a1('0x77')]?_[_0xb5a1('0x78')](_0x547f06[_0x2c5d36[_0x568235]['format']],'%s',_0x1cd464):_0x1cd464;if(_0x2c5d36[_0x568235][_0xb5a1('0x79')]){_0x14b346[_0xb5a1('0x69')](_0x1cd464);}_0x2c5d36[_0x568235][_0xb5a1('0x7a')]&&_0x14b346['order'](_0x1cd464,_0x2c5d36[_0x568235][_0xb5a1('0x7a')]==='DESC'?![]:!![]);_0x14b346[_0xb5a1('0x75')](_0x1cd464,_0x2c5d36[_0x568235][_0xb5a1('0x7b')]||_0x1cd464);}if(_0x10b7f9['joins']){_0x10b7f9[_0xb5a1('0x7c')]=JSON['parse'](_0x10b7f9[_0xb5a1('0x7c')]);for(var _0x58f492=0x0;_0x58f492<_0x10b7f9[_0xb5a1('0x7c')]['length'];_0x58f492+=0x1){if(_0x10b7f9[_0xb5a1('0x7c')][_0x58f492]['type']&&_['includes'](_0x5b4b67,_0x10b7f9[_0xb5a1('0x7c')][_0x58f492][_0xb5a1('0x33')])&&_0x10b7f9['joins'][_0x58f492][_0xb5a1('0x7d')]&&_0x10b7f9[_0xb5a1('0x7c')][_0x58f492]['foreignTable']&&_0x10b7f9[_0xb5a1('0x7c')][_0x58f492][_0xb5a1('0x7e')]){_0x14b346[_0x10b7f9[_0xb5a1('0x7c')][_0x58f492][_0xb5a1('0x33')]](_0x10b7f9['joins'][_0x58f492][_0xb5a1('0x7f')],null,util[_0xb5a1('0x77')](_0xb5a1('0x80'),_0x10b7f9['table'],_0x10b7f9['joins'][_0x58f492][_0xb5a1('0x7d')],_0x10b7f9[_0xb5a1('0x7c')][_0x58f492][_0xb5a1('0x7f')],_0x10b7f9[_0xb5a1('0x7c')][_0x58f492]['foreignKey']));}}}if(_0x10b7f9['conditions']){_0x10b7f9[_0xb5a1('0x81')]=JSON['parse'](_0x10b7f9['conditions']);_0x14b346['where'](_0x2bf986(_0x10b7f9[_0xb5a1('0x81')]['group']));}_0x505633=_0x14b346[_0xb5a1('0x82')]();_0x14b346[_0xb5a1('0x21')](_0x34ee1c);_0x14b346['offset'](0x0);logger[_0xb5a1('0x83')](_0xb5a1('0x84'),_0x14b346[_0xb5a1('0x85')]());return dbH[_0xb5a1('0x86')][_0xb5a1('0x36')](_0x14b346[_0xb5a1('0x85')](),{'type':dbH[_0xb5a1('0x86')][_0xb5a1('0x87')][_0xb5a1('0x88')]});}})[_0xb5a1('0x26')](respondWithResult(_0x32c495,null))[_0xb5a1('0x47')](handleError(_0x32c495,null));};function runReport(_0x5880fe,_0x3b5eda,_0x1dc1da){var _0x3398a7=_0x3b5eda['name'];var _0x48ef7e=0xa;var _0x2ef385=[_0xb5a1('0x56'),'left_join',_0xb5a1('0x58'),_0xb5a1('0x89')];var _0x19f165={'SUM':_0xb5a1('0x8a'),'COUNT':_0xb5a1('0x59'),'COUNT DISTINCT':_0xb5a1('0x5a'),'MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':_0xb5a1('0x5d'),'GROUP_CONCAT':_0xb5a1('0x5e'),'GROUP_CONCAT ASC':_0xb5a1('0x5f'),'GROUP_CONCAT DESC':_0xb5a1('0x60')};var _0x3822d1={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':_0xb5a1('0x62'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x3da986=function(_0x342a5a){return!_[_0xb5a1('0x8b')]([_0xb5a1('0x8c'),'IS\x20NOT\x20NULL',_0xb5a1('0x65'),_0xb5a1('0x66')],_0x342a5a);};var _0x3fff0e=function(_0x42b0a8){if(!_0x42b0a8||!_0x42b0a8[_0xb5a1('0x67')][_0xb5a1('0x3b')]){return'';}for(var _0x329b74='(',_0x2b0ab6=0x0;_0x2b0ab6<_0x42b0a8[_0xb5a1('0x67')]['length'];_0x2b0ab6+=0x1){_0x2b0ab6>0x0&&(_0x329b74+='\x20'+_0x42b0a8[_0xb5a1('0x68')]+'\x20');_0x329b74+=_0x42b0a8[_0xb5a1('0x67')][_0x2b0ab6][_0xb5a1('0x69')]?_0x3fff0e(_0x42b0a8[_0xb5a1('0x67')][_0x2b0ab6][_0xb5a1('0x69')]):_0x42b0a8[_0xb5a1('0x67')][_0x2b0ab6][_0xb5a1('0x75')]+'\x20'+_0x42b0a8[_0xb5a1('0x67')][_0x2b0ab6][_0xb5a1('0x6a')]+(_0x3da986(_0x42b0a8['rules'][_0x2b0ab6][_0xb5a1('0x6a')])?'\x20'+_0x42b0a8[_0xb5a1('0x67')][_0x2b0ab6][_0xb5a1('0x6b')]:'');}return _0x329b74+')';};var _0x2ae3b8={'where':{'id':_0x5880fe['id']}},_0x3c8008,_0x47a238,_0x1d292a,_0x1258ea,_0x39462e;_0x2ae3b8=_[_0xb5a1('0x43')]({},_0x2ae3b8,_0x1dc1da);return db[_0xb5a1('0x31')]['find'](_0x2ae3b8)[_0xb5a1('0x26')](function(_0x1209f8){if(_0x1209f8){_0x3c8008=_0x1209f8;return _0x1209f8['getFields']();}return null;})['then'](function(_0x4463a9){if(_0x4463a9){if(!_0x4463a9['length']){throw new db[(_0xb5a1('0x6c'))][(_0xb5a1('0x6d'))](_0xb5a1('0x6e'),0x193);}_0x47a238=_0x4463a9;return db['AnalyticMetric'][_0xb5a1('0x46')]({'raw':!![]});}return null;})[_0xb5a1('0x26')](function(_0x252b2e){if(_0x252b2e){_0x1d292a=_[_0xb5a1('0x70')](_0x252b2e,'id');var _0x4fcfe3;var _0x12ad89=squel[_0xb5a1('0x71')]();_0x12ad89[_0xb5a1('0x8d')](_0x3c8008[_0xb5a1('0x72')]);for(var _0x20fedf=0x0;_0x20fedf<_0x47a238[_0xb5a1('0x3b')];_0x20fedf+=0x1){_0x4fcfe3=_0x47a238[_0x20fedf]['MetricId']?_0x1d292a[_0x47a238[_0x20fedf][_0xb5a1('0x73')]][_0xb5a1('0x74')]:_0x47a238[_0x20fedf][_0xb5a1('0x75')];_0x4fcfe3=_0x47a238[_0x20fedf][_0xb5a1('0x76')]?_[_0xb5a1('0x78')](_0x19f165[_0x47a238[_0x20fedf]['function']],'%s',_0x4fcfe3):_0x4fcfe3;_0x4fcfe3=_0x47a238[_0x20fedf][_0xb5a1('0x77')]?_[_0xb5a1('0x78')](_0x3822d1[_0x47a238[_0x20fedf][_0xb5a1('0x77')]],'%s',_0x4fcfe3):_0x4fcfe3;if(_0x47a238[_0x20fedf][_0xb5a1('0x79')]){_0x12ad89[_0xb5a1('0x69')](_0x4fcfe3);}_0x47a238[_0x20fedf]['orderBy']&&_0x12ad89[_0xb5a1('0x3e')](_0x4fcfe3,_0x47a238[_0x20fedf][_0xb5a1('0x7a')]===_0xb5a1('0x8e')?![]:!![]);_0x12ad89[_0xb5a1('0x75')](_0x4fcfe3,_0x47a238[_0x20fedf][_0xb5a1('0x7b')]||_0x4fcfe3);}if(_0x3c8008[_0xb5a1('0x7c')]){_0x3c8008[_0xb5a1('0x7c')]=JSON[_0xb5a1('0x8f')](_0x3c8008[_0xb5a1('0x7c')]);for(var _0xbf1d53=0x0;_0xbf1d53<_0x3c8008[_0xb5a1('0x7c')][_0xb5a1('0x3b')];_0xbf1d53+=0x1){if(_0x3c8008[_0xb5a1('0x7c')][_0xbf1d53][_0xb5a1('0x33')]&&_[_0xb5a1('0x8b')](_0x2ef385,_0x3c8008['joins'][_0xbf1d53][_0xb5a1('0x33')])&&_0x3c8008[_0xb5a1('0x7c')][_0xbf1d53][_0xb5a1('0x7d')]&&_0x3c8008['joins'][_0xbf1d53][_0xb5a1('0x7f')]&&_0x3c8008[_0xb5a1('0x7c')][_0xbf1d53][_0xb5a1('0x7e')]){_0x12ad89[_0x3c8008[_0xb5a1('0x7c')][_0xbf1d53][_0xb5a1('0x33')]](_0x3c8008[_0xb5a1('0x7c')][_0xbf1d53][_0xb5a1('0x7f')],null,util[_0xb5a1('0x77')](_0xb5a1('0x80'),_0x3c8008[_0xb5a1('0x72')],_0x3c8008[_0xb5a1('0x7c')][_0xbf1d53][_0xb5a1('0x7d')],_0x3c8008[_0xb5a1('0x7c')][_0xbf1d53][_0xb5a1('0x7f')],_0x3c8008[_0xb5a1('0x7c')][_0xbf1d53][_0xb5a1('0x7e')]));}}}if(_0x3c8008[_0xb5a1('0x81')]){_0x3c8008[_0xb5a1('0x81')]=JSON[_0xb5a1('0x8f')](_0x3c8008[_0xb5a1('0x81')]);_0x12ad89[_0xb5a1('0x40')](_0x3fff0e(_0x3c8008[_0xb5a1('0x81')][_0xb5a1('0x69')]));}_0x39462e=_0x12ad89[_0xb5a1('0x82')]();_0x12ad89['limit'](_0x48ef7e);_0x12ad89[_0xb5a1('0x20')](0x0);return;}})[_0xb5a1('0x26')](function(){if(_0x3b5eda[_0xb5a1('0x90')]===_0xb5a1('0x91')){return null;}var _0x418d7f=_[_0xb5a1('0x43')](_0x3b5eda,{'name':_0x3b5eda[_0xb5a1('0x92')]||_0x3b5eda['name']||_0x3c8008[_0xb5a1('0x2d')],'basename':_0x3398a7,'savename':util[_0xb5a1('0x77')]('%s-%s.%s',_0x3b5eda[_0xb5a1('0x2d')]||_0x3c8008[_0xb5a1('0x2d')],require(_0xb5a1('0x93'))[_0xb5a1('0x94')](0x4),_0x3b5eda[_0xb5a1('0x90')]||_0xb5a1('0x95')),'reportId':_0x3c8008['id'],'reportType':_0xb5a1('0x96')});return db[_0xb5a1('0x97')][_0xb5a1('0x4c')](_0x418d7f,{'raw':!![]});})[_0xb5a1('0x26')](function(_0x3f84c0){if(_0x3c8008[_0xb5a1('0x72')]===_0xb5a1('0x98')){_0x39462e['where'](_0x3c8008[_0xb5a1('0x72')]+_0xb5a1('0x99'),_0x3b5eda[_0xb5a1('0x9a')],_0x3b5eda['endDate']);}else{_0x39462e[_0xb5a1('0x40')](_0x3c8008[_0xb5a1('0x72')]+_0xb5a1('0x9b'),_0x3b5eda[_0xb5a1('0x9a')],_0x3b5eda[_0xb5a1('0x9c')]);}if(_0x3f84c0){logger[_0xb5a1('0x9d')]('Run\x20Query:',_0x39462e['toString']());require(_0xb5a1('0x9e'))[_0xb5a1('0x9f')](path[_0xb5a1('0x56')](__dirname,_0xb5a1('0xa0'),_0x3f84c0[_0xb5a1('0x90')]),[_0x3f84c0['id'],_0x39462e['toString'](),path[_0xb5a1('0x56')](__dirname,_0xb5a1('0xa1'),_0x3f84c0[_0xb5a1('0xa2')]),_0x3398a7]);return _0x3f84c0;}else{var _0x19446c=squel[_0xb5a1('0x71')]();_0x19446c['from']('('+_0x39462e['toString']()+')','countTable');_0x19446c[_0xb5a1('0x75')](_0xb5a1('0xa3'),'count');_0x39462e[_0xb5a1('0x21')](_0x3b5eda[_0xb5a1('0x21')]||_0x48ef7e);_0x39462e[_0xb5a1('0x20')](_0x3b5eda[_0xb5a1('0x20')]||0x0);return dbH[_0xb5a1('0x86')][_0xb5a1('0x36')](_0x19446c[_0xb5a1('0x85')](),{'type':dbH['sequelize'][_0xb5a1('0x87')][_0xb5a1('0x88')]})[_0xb5a1('0x26')](function(_0x25c030){if(!_0x25c030[_0xb5a1('0x3b')]){_0x1258ea=0x0;}else{_0x1258ea=_0x25c030[0x0][_0xb5a1('0x1f')]||0x0;}return dbH['sequelize']['query'](_0x39462e[_0xb5a1('0x85')](),{'type':dbH[_0xb5a1('0x86')][_0xb5a1('0x87')][_0xb5a1('0x88')]});})[_0xb5a1('0x26')](function(_0x33eb44){return{'rows':_0x33eb44||[],'count':_0x1258ea};});}});}exports[_0xb5a1('0xa4')]=function(_0x5c8912,_0x3840a8){return runReport(_0x5c8912[_0xb5a1('0x49')],_0x5c8912[_0xb5a1('0x36')],_0x5c8912['options'])[_0xb5a1('0x26')](respondWithResult(_0x3840a8,null))[_0xb5a1('0x47')](handleError(_0x3840a8,null));};exports[_0xb5a1('0xa5')]=runReport;exports[_0xb5a1('0x36')]=function(_0x5dfb61,_0x5c5c4e){var _0xe83ef5=0xa;var _0x17fa6e=[_0xb5a1('0x56'),'left_join',_0xb5a1('0x58'),_0xb5a1('0x89')];var _0x466238={'SUM':_0xb5a1('0x8a'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0xb5a1('0x5a'),'MAX':_0xb5a1('0x5b'),'MIN':'MIN(%s)','AVG':_0xb5a1('0x5d'),'GROUP_CONCAT':_0xb5a1('0x5e'),'GROUP_CONCAT ASC':_0xb5a1('0x5f'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x1db6a7={'SEC_TO_TIME':_0xb5a1('0x61'),'DATE':_0xb5a1('0xa6'),'HOUR':_0xb5a1('0xa7'),'ROUND':_0xb5a1('0x62'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x31ef40=function(_0x5aaa6d){return!_[_0xb5a1('0x8b')]([_0xb5a1('0x8c'),_0xb5a1('0x64'),_0xb5a1('0x65'),_0xb5a1('0x66')],_0x5aaa6d);};var _0x161e05=function(_0x391a83){if(!_0x391a83||!_0x391a83[_0xb5a1('0x67')][_0xb5a1('0x3b')]){return'';}for(var _0x3969f7='(',_0x2a9ba9=0x0;_0x2a9ba9<_0x391a83['rules'][_0xb5a1('0x3b')];_0x2a9ba9+=0x1){_0x2a9ba9>0x0&&(_0x3969f7+='\x20'+_0x391a83[_0xb5a1('0x68')]+'\x20');_0x3969f7+=_0x391a83[_0xb5a1('0x67')][_0x2a9ba9][_0xb5a1('0x69')]?_0x161e05(_0x391a83[_0xb5a1('0x67')][_0x2a9ba9][_0xb5a1('0x69')]):_0x391a83['rules'][_0x2a9ba9]['field']+'\x20'+_0x391a83[_0xb5a1('0x67')][_0x2a9ba9][_0xb5a1('0x6a')]+(_0x31ef40(_0x391a83[_0xb5a1('0x67')][_0x2a9ba9]['condition'])?'\x20'+_0x391a83[_0xb5a1('0x67')][_0x2a9ba9][_0xb5a1('0x6b')]:'');}return _0x3969f7+')';};var _0x540dcd={'where':{'id':_0x5dfb61[_0xb5a1('0x49')]['id']}},_0x4dd37d,_0x1e882d,_0x1fd3a2,_0x32afd0,_0x4e152a;_0x540dcd=_['merge']({},_0x540dcd,_0x5dfb61['options']);return db[_0xb5a1('0x31')][_0xb5a1('0x4b')](_0x540dcd)[_0xb5a1('0x26')](function(_0x53836f){if(_0x53836f){_0x4dd37d=_0x53836f;return _0x53836f[_0xb5a1('0xa8')]();}return null;})[_0xb5a1('0x26')](function(_0x57f309){if(_0x57f309){if(!_0x57f309[_0xb5a1('0x3b')]){throw new db['Sequelize'][(_0xb5a1('0x6d'))](_0xb5a1('0x6e'),0x193);}_0x1e882d=_0x57f309;return db[_0xb5a1('0x6f')][_0xb5a1('0x46')]({'raw':!![]});}return null;})['then'](function(_0x3df21a){if(_0x3df21a){_0x1fd3a2=_[_0xb5a1('0x70')](_0x3df21a,'id');var _0x15d119;var _0x150028=squel[_0xb5a1('0x71')]();_0x150028[_0xb5a1('0x8d')](_0x4dd37d[_0xb5a1('0x72')]);for(var _0x3961ca=0x0;_0x3961ca<_0x1e882d[_0xb5a1('0x3b')];_0x3961ca+=0x1){_0x15d119=_0x1e882d[_0x3961ca]['MetricId']?_0x1fd3a2[_0x1e882d[_0x3961ca][_0xb5a1('0x73')]]['metric']:_0x1e882d[_0x3961ca][_0xb5a1('0x75')];_0x15d119=_0x1e882d[_0x3961ca][_0xb5a1('0x76')]?_[_0xb5a1('0x78')](_0x466238[_0x1e882d[_0x3961ca][_0xb5a1('0x76')]],'%s',_0x15d119):_0x15d119;_0x15d119=_0x1e882d[_0x3961ca][_0xb5a1('0x77')]?_[_0xb5a1('0x78')](_0x1db6a7[_0x1e882d[_0x3961ca][_0xb5a1('0x77')]],'%s',_0x15d119):_0x15d119;if(_0x1e882d[_0x3961ca][_0xb5a1('0x79')]){_0x150028['group'](_0x15d119);}_0x1e882d[_0x3961ca]['orderBy']&&_0x150028['order'](_0x15d119,_0x1e882d[_0x3961ca][_0xb5a1('0x7a')]==='DESC'?![]:!![]);_0x150028[_0xb5a1('0x75')](_0x15d119,_0x1e882d[_0x3961ca][_0xb5a1('0x7b')]||_0x15d119);}if(_0x4dd37d[_0xb5a1('0x7c')]){_0x4dd37d[_0xb5a1('0x7c')]=JSON['parse'](_0x4dd37d['joins']);for(var _0x375695=0x0;_0x375695<_0x4dd37d[_0xb5a1('0x7c')]['length'];_0x375695+=0x1){if(_0x4dd37d[_0xb5a1('0x7c')][_0x375695][_0xb5a1('0x33')]&&_[_0xb5a1('0x8b')](_0x17fa6e,_0x4dd37d['joins'][_0x375695][_0xb5a1('0x33')])&&_0x4dd37d['joins'][_0x375695][_0xb5a1('0x7d')]&&_0x4dd37d['joins'][_0x375695][_0xb5a1('0x7f')]&&_0x4dd37d[_0xb5a1('0x7c')][_0x375695][_0xb5a1('0x7e')]){_0x150028[_0x4dd37d['joins'][_0x375695][_0xb5a1('0x33')]](_0x4dd37d[_0xb5a1('0x7c')][_0x375695]['foreignTable'],null,util['format'](_0xb5a1('0x80'),_0x4dd37d[_0xb5a1('0x72')],_0x4dd37d['joins'][_0x375695][_0xb5a1('0x7d')],_0x4dd37d[_0xb5a1('0x7c')][_0x375695][_0xb5a1('0x7f')],_0x4dd37d['joins'][_0x375695][_0xb5a1('0x7e')]));}}}if(_0x4dd37d['conditions']){_0x4dd37d[_0xb5a1('0x81')]=JSON[_0xb5a1('0x8f')](_0x4dd37d[_0xb5a1('0x81')]);_0x150028['where'](_0x161e05(_0x4dd37d[_0xb5a1('0x81')][_0xb5a1('0x69')]));}_0x4e152a=_0x150028[_0xb5a1('0x82')]();_0x150028[_0xb5a1('0x21')](_0xe83ef5);_0x150028[_0xb5a1('0x20')](0x0);logger[_0xb5a1('0x83')](_0xb5a1('0x84'),_0x150028[_0xb5a1('0x85')]());return dbH['sequelize']['query'](_0x150028[_0xb5a1('0x85')](),{'type':dbH[_0xb5a1('0x86')][_0xb5a1('0x87')]['SELECT']});}})['then'](function(){return{'sql':_0x4e152a[_0xb5a1('0x85')]()};})['then'](respondWithResult(_0x5c5c4e,null))[_0xb5a1('0x47')](handleError(_0x5c5c4e,null));};
\ No newline at end of file
+var _0xb466=['intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','type','merge','options','include','AnalyticCustomReport','findAll','catch','show','params','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','UserProfileSection','find','autoAssociation','create','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','join','left_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)','SEC_TO_TIME(%s)','DATE(%s)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','from','table','MetricId','replace','function','format','orderBy','DESC','alias','joins','parse','parentKey','foreignTable','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','value','getFields','select','metric','groupBy','%s.%s\x20=\x20%s.%s','foreignKey','output','%s-%s.%s','randomstring','custom','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','Run\x20Query:','child_process','fork','../../components/export/','countTable','COUNT(*)','run','runReport','right_join','html-pdf','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','dbH','sendStatus','end','status','json','count','offset','limit','set','Content-Range','apply','reject','update','then','destroy','get','CustomReports','UserProfileResource','error','stack','name','send','map','rawAttributes','fieldName','key','model','query','keys'];(function(_0x31f208,_0x28b633){var _0x195dc2=function(_0x1ff0c7){while(--_0x1ff0c7){_0x31f208['push'](_0x31f208['shift']());}};_0x195dc2(++_0x28b633);}(_0xb466,0x6d));var _0x6b46=function(_0x271ff8,_0x312078){_0x271ff8=_0x271ff8-0x0;var _0x341a46=_0xb466[_0x271ff8];return _0x341a46;};'use strict';var pdf=require(_0x6b46('0x0'));var emlformat=require('eml-format');var rimraf=require(_0x6b46('0x1'));var zipdir=require(_0x6b46('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x6b46('0x3'));var moment=require(_0x6b46('0x4'));var BPromise=require(_0x6b46('0x5'));var Mustache=require(_0x6b46('0x6'));var util=require(_0x6b46('0x7'));var path=require(_0x6b46('0x8'));var sox=require(_0x6b46('0x9'));var csv=require(_0x6b46('0xa'));var ejs=require(_0x6b46('0xb'));var fs=require('fs');var _=require(_0x6b46('0xc'));var squel=require(_0x6b46('0xd'));var crypto=require('crypto');var jsforce=require(_0x6b46('0xe'));var deskjs=require(_0x6b46('0xf'));var toCsv=require(_0x6b46('0xa'));var querystring=require(_0x6b46('0x10'));var Papa=require(_0x6b46('0x11'));var Redis=require('ioredis');var authService=require(_0x6b46('0x12'));var qs=require(_0x6b46('0x13'));var as=require(_0x6b46('0x14'));var hardwareService=require(_0x6b46('0x15'));var logger=require('../../config/logger')(_0x6b46('0x16'));var utils=require(_0x6b46('0x17'));var config=require(_0x6b46('0x18'));var licenseUtil=require(_0x6b46('0x19'));var db=require(_0x6b46('0x1a'))['db'];var dbH=require(_0x6b46('0x1a'))[_0x6b46('0x1b')];function respondWithStatusCode(_0x2bcdb5,_0x4ad476){_0x4ad476=_0x4ad476||0xcc;return function(_0x3d506a){if(_0x3d506a){return _0x2bcdb5[_0x6b46('0x1c')](_0x4ad476);}return _0x2bcdb5['status'](_0x4ad476)[_0x6b46('0x1d')]();};}function respondWithResult(_0x12d5f8,_0x14c551){_0x14c551=_0x14c551||0xc8;return function(_0x3d9675){if(_0x3d9675){return _0x12d5f8[_0x6b46('0x1e')](_0x14c551)[_0x6b46('0x1f')](_0x3d9675);}};}function respondWithFilteredResult(_0x1ce80d,_0x47655c){return function(_0x1dcde5){if(_0x1dcde5){var _0x33079a=_0x1dcde5[_0x6b46('0x20')],_0x4b9598=_0x47655c['offset'],_0x487e27=_0x47655c[_0x6b46('0x21')]+_0x47655c[_0x6b46('0x22')],_0x1008cf;if(_0x487e27>=_0x33079a){_0x487e27=_0x33079a;_0x1008cf=0xc8;}else{_0x1008cf=0xce;}_0x1ce80d[_0x6b46('0x1e')](_0x1008cf);return _0x1ce80d[_0x6b46('0x23')](_0x6b46('0x24'),_0x4b9598+'-'+_0x487e27+'/'+_0x33079a)[_0x6b46('0x1f')](_0x1dcde5);}return null;};}function patchUpdates(_0x1e6b5d){return function(_0x38d5cf){try{jsonpatch[_0x6b46('0x25')](_0x38d5cf,_0x1e6b5d,!![]);}catch(_0x5da1c2){return BPromise[_0x6b46('0x26')](_0x5da1c2);}return _0x38d5cf['save']();};}function saveUpdates(_0x5a2d19,_0xd36cfe){return function(_0x21d372){if(_0x21d372){return _0x21d372[_0x6b46('0x27')](_0x5a2d19)[_0x6b46('0x28')](function(_0x490482){return _0x490482;});}return null;};}function removeEntity(_0x2f5a4e,_0x4d3022){return function(_0x40b20d){if(_0x40b20d){return _0x40b20d[_0x6b46('0x29')]()[_0x6b46('0x28')](function(){var _0x2e2630=_0x40b20d[_0x6b46('0x2a')]({'plain':!![]});var _0x1adc2d=_0x6b46('0x2b');return db[_0x6b46('0x2c')]['destroy']({'where':{'type':_0x1adc2d,'resourceId':_0x2e2630['id']}})['then'](function(){return _0x40b20d;});})[_0x6b46('0x28')](function(){_0x2f5a4e[_0x6b46('0x1e')](0xcc)[_0x6b46('0x1d')]();});}};}function handleEntityNotFound(_0x316e87,_0x1719b3){return function(_0x35aede){if(!_0x35aede){_0x316e87['sendStatus'](0x194);}return _0x35aede;};}function handleError(_0x5d3c9e,_0x2a1801){_0x2a1801=_0x2a1801||0x1f4;return function(_0x11541f){logger[_0x6b46('0x2d')](_0x11541f[_0x6b46('0x2e')]);if(_0x11541f[_0x6b46('0x2f')]){delete _0x11541f[_0x6b46('0x2f')];}_0x5d3c9e[_0x6b46('0x1e')](_0x2a1801)[_0x6b46('0x30')](_0x11541f);};}exports['index']=function(_0x2a91e9,_0x338d53){var _0x168d78={},_0x3a82b5={},_0x3f7b73={'count':0x0,'rows':[]};var _0x35c073=_[_0x6b46('0x31')](db['AnalyticCustomReport'][_0x6b46('0x32')],function(_0x12e586){return{'name':_0x12e586[_0x6b46('0x33')],'type':_0x12e586['type'][_0x6b46('0x34')]};});_0x3a82b5[_0x6b46('0x35')]=_[_0x6b46('0x31')](_0x35c073,_0x6b46('0x2f'));_0x3a82b5[_0x6b46('0x36')]=_[_0x6b46('0x37')](_0x2a91e9[_0x6b46('0x36')]);_0x3a82b5['filters']=_[_0x6b46('0x38')](_0x3a82b5['model'],_0x3a82b5['query']);_0x168d78['attributes']=_['intersection'](_0x3a82b5['model'],qs[_0x6b46('0x39')](_0x2a91e9[_0x6b46('0x36')][_0x6b46('0x39')]));_0x168d78['attributes']=_0x168d78[_0x6b46('0x3a')][_0x6b46('0x3b')]?_0x168d78[_0x6b46('0x3a')]:_0x3a82b5[_0x6b46('0x35')];if(!_0x2a91e9['query'][_0x6b46('0x3c')](_0x6b46('0x3d'))){_0x168d78[_0x6b46('0x22')]=qs[_0x6b46('0x22')](_0x2a91e9[_0x6b46('0x36')]['limit']);_0x168d78['offset']=qs[_0x6b46('0x21')](_0x2a91e9['query']['offset']);}_0x168d78[_0x6b46('0x3e')]=qs['sort'](_0x2a91e9[_0x6b46('0x36')][_0x6b46('0x3f')]);_0x168d78[_0x6b46('0x40')]=qs[_0x6b46('0x41')](_[_0x6b46('0x42')](_0x2a91e9[_0x6b46('0x36')],_0x3a82b5['filters']),_0x35c073);if(_0x2a91e9[_0x6b46('0x36')][_0x6b46('0x43')]){_0x168d78[_0x6b46('0x40')]=_['merge'](_0x168d78['where'],{'$or':_[_0x6b46('0x31')](_0x35c073,function(_0x52a0d9){if(_0x52a0d9[_0x6b46('0x44')]!=='VIRTUAL'){var _0x3b608d={};_0x3b608d[_0x52a0d9[_0x6b46('0x2f')]]={'$like':'%'+_0x2a91e9[_0x6b46('0x36')][_0x6b46('0x43')]+'%'};return _0x3b608d;}})});}_0x168d78=_[_0x6b46('0x45')]({},_0x168d78,_0x2a91e9[_0x6b46('0x46')]);var _0x2186d0={'where':_0x168d78[_0x6b46('0x40')]};return db['AnalyticCustomReport'][_0x6b46('0x20')](_0x2186d0)[_0x6b46('0x28')](function(_0x54f58e){_0x3f7b73[_0x6b46('0x20')]=_0x54f58e;if(_0x2a91e9[_0x6b46('0x36')]['includeAll']){_0x168d78[_0x6b46('0x47')]=[{'all':!![]}];}return db[_0x6b46('0x48')][_0x6b46('0x49')](_0x168d78);})[_0x6b46('0x28')](function(_0x357123){_0x3f7b73['rows']=_0x357123;return _0x3f7b73;})[_0x6b46('0x28')](respondWithFilteredResult(_0x338d53,_0x168d78))[_0x6b46('0x4a')](handleError(_0x338d53,null));};exports[_0x6b46('0x4b')]=function(_0x591b3f,_0x429550){var _0x7ee13e={'raw':![],'where':{'id':_0x591b3f[_0x6b46('0x4c')]['id']}},_0x310ddb={};_0x310ddb['model']=_[_0x6b46('0x37')](db[_0x6b46('0x48')][_0x6b46('0x32')]);_0x310ddb[_0x6b46('0x36')]=_['keys'](_0x591b3f[_0x6b46('0x36')]);_0x310ddb[_0x6b46('0x41')]=_[_0x6b46('0x38')](_0x310ddb[_0x6b46('0x35')],_0x310ddb[_0x6b46('0x36')]);_0x7ee13e['attributes']=_['intersection'](_0x310ddb[_0x6b46('0x35')],qs[_0x6b46('0x39')](_0x591b3f[_0x6b46('0x36')][_0x6b46('0x39')]));_0x7ee13e[_0x6b46('0x3a')]=_0x7ee13e[_0x6b46('0x3a')][_0x6b46('0x3b')]?_0x7ee13e[_0x6b46('0x3a')]:_0x310ddb['model'];if(_0x591b3f['query']['includeAll']){_0x7ee13e['include']=[{'all':!![]}];}_0x7ee13e=_[_0x6b46('0x45')]({},_0x7ee13e,_0x591b3f[_0x6b46('0x46')]);return db[_0x6b46('0x48')]['find'](_0x7ee13e)[_0x6b46('0x28')](handleEntityNotFound(_0x429550,null))[_0x6b46('0x28')](respondWithResult(_0x429550,null))['catch'](handleError(_0x429550,null));};exports['create']=function(_0x2eed3c,_0x3f3f72){return db[_0x6b46('0x48')]['create'](_0x2eed3c[_0x6b46('0x4d')],{})[_0x6b46('0x28')](function(_0x665aa){var _0x5ac912=_0x2eed3c[_0x6b46('0x4e')]['get']({'plain':!![]});if(!_0x5ac912)throw new Error(_0x6b46('0x4f'));if(_0x5ac912[_0x6b46('0x50')]===_0x6b46('0x4e')){var _0x3e2144=_0x665aa[_0x6b46('0x2a')]({'plain':!![]});var _0x52a62d=_0x6b46('0x51');return db[_0x6b46('0x52')][_0x6b46('0x53')]({'where':{'name':_0x52a62d,'userProfileId':_0x5ac912['userProfileId']},'raw':!![]})[_0x6b46('0x28')](function(_0x3fc20a){if(_0x3fc20a&&_0x3fc20a[_0x6b46('0x54')]===0x0){return db['UserProfileResource'][_0x6b46('0x55')]({'name':_0x3e2144[_0x6b46('0x2f')],'resourceId':_0x3e2144['id'],'type':_0x6b46('0x2b'),'sectionId':_0x3fc20a['id']},{})['then'](function(){return _0x665aa;});}else{return _0x665aa;}})[_0x6b46('0x4a')](function(_0xe0f217){logger[_0x6b46('0x2d')](_0x6b46('0x56'),_0xe0f217);throw _0xe0f217;});}return _0x665aa;})['then'](respondWithResult(_0x3f3f72,0xc9))[_0x6b46('0x4a')](handleError(_0x3f3f72,null));};exports['update']=function(_0x3331f3,_0xd140d7){if(_0x3331f3['body']['id']){delete _0x3331f3[_0x6b46('0x4d')]['id'];}return db['AnalyticCustomReport'][_0x6b46('0x53')]({'where':{'id':_0x3331f3[_0x6b46('0x4c')]['id']}})['then'](handleEntityNotFound(_0xd140d7,null))['then'](saveUpdates(_0x3331f3[_0x6b46('0x4d')],null))['then'](respondWithResult(_0xd140d7,null))[_0x6b46('0x4a')](handleError(_0xd140d7,null));};exports[_0x6b46('0x29')]=function(_0x299209,_0x559eb7){return db[_0x6b46('0x48')]['find']({'where':{'id':_0x299209[_0x6b46('0x4c')]['id']}})[_0x6b46('0x28')](handleEntityNotFound(_0x559eb7,null))['then'](removeEntity(_0x559eb7,null))[_0x6b46('0x4a')](handleError(_0x559eb7,null));};exports['preview']=function(_0x3fa938,_0x1fb0fd){var _0x37e99d=0xa;var _0x5c170e=[_0x6b46('0x57'),_0x6b46('0x58'),'right_join',_0x6b46('0x59')];var _0x27e69f={'SUM':_0x6b46('0x5a'),'COUNT':_0x6b46('0x5b'),'COUNT DISTINCT':_0x6b46('0x5c'),'MAX':_0x6b46('0x5d'),'MIN':_0x6b46('0x5e'),'AVG':_0x6b46('0x5f'),'GROUP_CONCAT':_0x6b46('0x60'),'GROUP_CONCAT ASC':_0x6b46('0x61'),'GROUP_CONCAT DESC':_0x6b46('0x62')};var _0x35b194={'SEC_TO_TIME':_0x6b46('0x63'),'DATE':_0x6b46('0x64'),'HOUR':_0x6b46('0x65'),'ROUND':_0x6b46('0x66'),'UNIX_TIMESTAMP':_0x6b46('0x67')};var _0xb256fb=function(_0x14c01a){return!_[_0x6b46('0x68')]([_0x6b46('0x69'),_0x6b46('0x6a'),_0x6b46('0x6b'),_0x6b46('0x6c')],_0x14c01a);};var _0x13045d=function(_0x35fbd4){if(!_0x35fbd4||!_0x35fbd4[_0x6b46('0x6d')][_0x6b46('0x3b')]){return'';}for(var _0x20b0c5='(',_0xcdf94e=0x0;_0xcdf94e<_0x35fbd4[_0x6b46('0x6d')][_0x6b46('0x3b')];_0xcdf94e+=0x1){_0xcdf94e>0x0&&(_0x20b0c5+='\x20'+_0x35fbd4[_0x6b46('0x6e')]+'\x20');_0x20b0c5+=_0x35fbd4[_0x6b46('0x6d')][_0xcdf94e][_0x6b46('0x6f')]?_0x13045d(_0x35fbd4['rules'][_0xcdf94e]['group']):_0x35fbd4['rules'][_0xcdf94e][_0x6b46('0x70')]+'\x20'+_0x35fbd4[_0x6b46('0x6d')][_0xcdf94e][_0x6b46('0x71')]+(_0xb256fb(_0x35fbd4[_0x6b46('0x6d')][_0xcdf94e]['condition'])?'\x20'+_0x35fbd4['rules'][_0xcdf94e]['value']:'');}return _0x20b0c5+')';};var _0x4fde0f={'where':{'id':_0x3fa938['params']['id']}},_0x414a82,_0x1867d8,_0x3c9593,_0x4bb45e,_0x51981b;_0x4fde0f=_[_0x6b46('0x45')]({},_0x4fde0f,_0x3fa938[_0x6b46('0x46')]);return db['AnalyticCustomReport']['find'](_0x4fde0f)['then'](function(_0x509971){if(_0x509971){_0x414a82=_0x509971;return _0x509971['getFields']();}return null;})[_0x6b46('0x28')](function(_0x93c5de){if(_0x93c5de){if(!_0x93c5de[_0x6b46('0x3b')]){throw new db[(_0x6b46('0x72'))][(_0x6b46('0x73'))](_0x6b46('0x74'),0x193);}_0x1867d8=_0x93c5de;return db[_0x6b46('0x75')][_0x6b46('0x49')]({'raw':!![]});}return null;})[_0x6b46('0x28')](function(_0x442dd1){if(_0x442dd1){_0x3c9593=_[_0x6b46('0x76')](_0x442dd1,'id');var _0x17d073;var _0x4d34f6=squel['select']();_0x4d34f6[_0x6b46('0x77')](_0x414a82[_0x6b46('0x78')]);for(var _0x37f2d=0x0;_0x37f2d<_0x1867d8[_0x6b46('0x3b')];_0x37f2d+=0x1){_0x17d073=_0x1867d8[_0x37f2d][_0x6b46('0x79')]?_0x3c9593[_0x1867d8[_0x37f2d]['MetricId']]['metric']:_0x1867d8[_0x37f2d][_0x6b46('0x70')];_0x17d073=_0x1867d8[_0x37f2d]['function']?_[_0x6b46('0x7a')](_0x27e69f[_0x1867d8[_0x37f2d][_0x6b46('0x7b')]],'%s',_0x17d073):_0x17d073;_0x17d073=_0x1867d8[_0x37f2d]['format']?_[_0x6b46('0x7a')](_0x35b194[_0x1867d8[_0x37f2d][_0x6b46('0x7c')]],'%s',_0x17d073):_0x17d073;if(_0x1867d8[_0x37f2d]['groupBy']){_0x4d34f6[_0x6b46('0x6f')](_0x17d073);}_0x1867d8[_0x37f2d][_0x6b46('0x7d')]&&_0x4d34f6['order'](_0x17d073,_0x1867d8[_0x37f2d]['orderBy']===_0x6b46('0x7e')?![]:!![]);_0x4d34f6['field'](_0x17d073,_0x1867d8[_0x37f2d][_0x6b46('0x7f')]||_0x17d073);}if(_0x414a82[_0x6b46('0x80')]){_0x414a82[_0x6b46('0x80')]=JSON[_0x6b46('0x81')](_0x414a82[_0x6b46('0x80')]);for(var _0x5b080c=0x0;_0x5b080c<_0x414a82[_0x6b46('0x80')][_0x6b46('0x3b')];_0x5b080c+=0x1){if(_0x414a82[_0x6b46('0x80')][_0x5b080c][_0x6b46('0x44')]&&_[_0x6b46('0x68')](_0x5c170e,_0x414a82[_0x6b46('0x80')][_0x5b080c]['type'])&&_0x414a82[_0x6b46('0x80')][_0x5b080c][_0x6b46('0x82')]&&_0x414a82[_0x6b46('0x80')][_0x5b080c][_0x6b46('0x83')]&&_0x414a82['joins'][_0x5b080c]['foreignKey']){_0x4d34f6[_0x414a82[_0x6b46('0x80')][_0x5b080c][_0x6b46('0x44')]](_0x414a82[_0x6b46('0x80')][_0x5b080c][_0x6b46('0x83')],null,util['format']('%s.%s\x20=\x20%s.%s',_0x414a82[_0x6b46('0x78')],_0x414a82['joins'][_0x5b080c]['parentKey'],_0x414a82[_0x6b46('0x80')][_0x5b080c][_0x6b46('0x83')],_0x414a82[_0x6b46('0x80')][_0x5b080c]['foreignKey']));}}}if(_0x414a82[_0x6b46('0x84')]){_0x414a82[_0x6b46('0x84')]=JSON[_0x6b46('0x81')](_0x414a82[_0x6b46('0x84')]);_0x4d34f6['where'](_0x13045d(_0x414a82[_0x6b46('0x84')][_0x6b46('0x6f')]));}_0x51981b=_0x4d34f6[_0x6b46('0x85')]();_0x4d34f6['limit'](_0x37e99d);_0x4d34f6['offset'](0x0);logger[_0x6b46('0x86')](_0x6b46('0x87'),_0x4d34f6[_0x6b46('0x88')]());return dbH['sequelize'][_0x6b46('0x36')](_0x4d34f6[_0x6b46('0x88')](),{'type':dbH[_0x6b46('0x89')][_0x6b46('0x8a')][_0x6b46('0x8b')]});}})['then'](respondWithResult(_0x1fb0fd,null))[_0x6b46('0x4a')](handleError(_0x1fb0fd,null));};function runReport(_0x535686,_0x20bef6,_0x2b8f4c){var _0x5b3cb2=_0x20bef6[_0x6b46('0x2f')];var _0x4545d9=0xa;var _0x29cbfe=['join','left_join','right_join',_0x6b46('0x59')];var _0x461aee={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT DISTINCT':_0x6b46('0x5c'),'MAX':_0x6b46('0x5d'),'MIN':_0x6b46('0x5e'),'AVG':_0x6b46('0x5f'),'GROUP_CONCAT':_0x6b46('0x60'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x4a1ba6={'SEC_TO_TIME':_0x6b46('0x63'),'DATE':_0x6b46('0x64'),'HOUR':_0x6b46('0x65'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x6b46('0x67')};var _0x1f4518=function(_0x1aedc4){return!_['includes']([_0x6b46('0x69'),'IS\x20NOT\x20NULL',_0x6b46('0x6b'),'IS\x20NOT\x20EMPTY'],_0x1aedc4);};var _0x1447ed=function(_0x35a1fd){if(!_0x35a1fd||!_0x35a1fd['rules'][_0x6b46('0x3b')]){return'';}for(var _0x5e9aa1='(',_0x3be735=0x0;_0x3be735<_0x35a1fd[_0x6b46('0x6d')][_0x6b46('0x3b')];_0x3be735+=0x1){_0x3be735>0x0&&(_0x5e9aa1+='\x20'+_0x35a1fd[_0x6b46('0x6e')]+'\x20');_0x5e9aa1+=_0x35a1fd['rules'][_0x3be735][_0x6b46('0x6f')]?_0x1447ed(_0x35a1fd[_0x6b46('0x6d')][_0x3be735]['group']):_0x35a1fd[_0x6b46('0x6d')][_0x3be735][_0x6b46('0x70')]+'\x20'+_0x35a1fd[_0x6b46('0x6d')][_0x3be735]['condition']+(_0x1f4518(_0x35a1fd[_0x6b46('0x6d')][_0x3be735]['condition'])?'\x20'+_0x35a1fd[_0x6b46('0x6d')][_0x3be735][_0x6b46('0x8c')]:'');}return _0x5e9aa1+')';};var _0x258b22={'where':{'id':_0x535686['id']}},_0x402933,_0x4f2c94,_0x5e5717,_0xd2a99f,_0x52864b;_0x258b22=_[_0x6b46('0x45')]({},_0x258b22,_0x2b8f4c);return db[_0x6b46('0x48')][_0x6b46('0x53')](_0x258b22)[_0x6b46('0x28')](function(_0x36d5dd){if(_0x36d5dd){_0x402933=_0x36d5dd;return _0x36d5dd[_0x6b46('0x8d')]();}return null;})[_0x6b46('0x28')](function(_0x57e013){if(_0x57e013){if(!_0x57e013['length']){throw new db[(_0x6b46('0x72'))][(_0x6b46('0x73'))](_0x6b46('0x74'),0x193);}_0x4f2c94=_0x57e013;return db[_0x6b46('0x75')][_0x6b46('0x49')]({'raw':!![]});}return null;})['then'](function(_0x41da1f){if(_0x41da1f){_0x5e5717=_[_0x6b46('0x76')](_0x41da1f,'id');var _0x12b026;var _0x39091a=squel[_0x6b46('0x8e')]();_0x39091a['from'](_0x402933[_0x6b46('0x78')]);for(var _0x1ebaf8=0x0;_0x1ebaf8<_0x4f2c94[_0x6b46('0x3b')];_0x1ebaf8+=0x1){_0x12b026=_0x4f2c94[_0x1ebaf8][_0x6b46('0x79')]?_0x5e5717[_0x4f2c94[_0x1ebaf8][_0x6b46('0x79')]][_0x6b46('0x8f')]:_0x4f2c94[_0x1ebaf8][_0x6b46('0x70')];_0x12b026=_0x4f2c94[_0x1ebaf8][_0x6b46('0x7b')]?_['replace'](_0x461aee[_0x4f2c94[_0x1ebaf8][_0x6b46('0x7b')]],'%s',_0x12b026):_0x12b026;_0x12b026=_0x4f2c94[_0x1ebaf8][_0x6b46('0x7c')]?_[_0x6b46('0x7a')](_0x4a1ba6[_0x4f2c94[_0x1ebaf8]['format']],'%s',_0x12b026):_0x12b026;if(_0x4f2c94[_0x1ebaf8][_0x6b46('0x90')]){_0x39091a[_0x6b46('0x6f')](_0x12b026);}_0x4f2c94[_0x1ebaf8][_0x6b46('0x7d')]&&_0x39091a[_0x6b46('0x3e')](_0x12b026,_0x4f2c94[_0x1ebaf8][_0x6b46('0x7d')]==='DESC'?![]:!![]);_0x39091a['field'](_0x12b026,_0x4f2c94[_0x1ebaf8][_0x6b46('0x7f')]||_0x12b026);}if(_0x402933[_0x6b46('0x80')]){_0x402933['joins']=JSON[_0x6b46('0x81')](_0x402933[_0x6b46('0x80')]);for(var _0x45426c=0x0;_0x45426c<_0x402933['joins'][_0x6b46('0x3b')];_0x45426c+=0x1){if(_0x402933[_0x6b46('0x80')][_0x45426c][_0x6b46('0x44')]&&_[_0x6b46('0x68')](_0x29cbfe,_0x402933[_0x6b46('0x80')][_0x45426c][_0x6b46('0x44')])&&_0x402933[_0x6b46('0x80')][_0x45426c][_0x6b46('0x82')]&&_0x402933[_0x6b46('0x80')][_0x45426c][_0x6b46('0x83')]&&_0x402933[_0x6b46('0x80')][_0x45426c]['foreignKey']){_0x39091a[_0x402933[_0x6b46('0x80')][_0x45426c][_0x6b46('0x44')]](_0x402933['joins'][_0x45426c][_0x6b46('0x83')],null,util[_0x6b46('0x7c')](_0x6b46('0x91'),_0x402933['table'],_0x402933[_0x6b46('0x80')][_0x45426c][_0x6b46('0x82')],_0x402933[_0x6b46('0x80')][_0x45426c][_0x6b46('0x83')],_0x402933[_0x6b46('0x80')][_0x45426c][_0x6b46('0x92')]));}}}if(_0x402933[_0x6b46('0x84')]){_0x402933[_0x6b46('0x84')]=JSON[_0x6b46('0x81')](_0x402933[_0x6b46('0x84')]);_0x39091a[_0x6b46('0x40')](_0x1447ed(_0x402933[_0x6b46('0x84')]['group']));}_0x52864b=_0x39091a[_0x6b46('0x85')]();_0x39091a['limit'](_0x4545d9);_0x39091a[_0x6b46('0x21')](0x0);return;}})[_0x6b46('0x28')](function(){if(_0x20bef6[_0x6b46('0x93')]==='web'){return null;}var _0x5b2a6d=_[_0x6b46('0x45')](_0x20bef6,{'name':_0x20bef6['fullPath']||_0x20bef6[_0x6b46('0x2f')]||_0x402933['name'],'basename':_0x5b3cb2,'savename':util[_0x6b46('0x7c')](_0x6b46('0x94'),_0x20bef6[_0x6b46('0x2f')]||_0x402933[_0x6b46('0x2f')],require(_0x6b46('0x95'))['generate'](0x4),_0x20bef6[_0x6b46('0x93')]||'csv'),'reportId':_0x402933['id'],'reportType':_0x6b46('0x96')});return db[_0x6b46('0x97')][_0x6b46('0x55')](_0x5b2a6d,{'raw':!![]});})[_0x6b46('0x28')](function(_0x43e7da){if(_0x402933[_0x6b46('0x78')]===_0x6b46('0x98')){_0x52864b[_0x6b46('0x40')](_0x402933[_0x6b46('0x78')]+_0x6b46('0x99'),_0x20bef6[_0x6b46('0x9a')],_0x20bef6['endDate']);}else{_0x52864b[_0x6b46('0x40')](_0x402933[_0x6b46('0x78')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x20bef6[_0x6b46('0x9a')],_0x20bef6[_0x6b46('0x9b')]);}if(_0x43e7da){logger['info'](_0x6b46('0x9c'),_0x52864b[_0x6b46('0x88')]());require(_0x6b46('0x9d'))[_0x6b46('0x9e')](path[_0x6b46('0x57')](__dirname,_0x6b46('0x9f'),_0x43e7da['output']),[_0x43e7da['id'],_0x52864b[_0x6b46('0x88')](),path[_0x6b46('0x57')](__dirname,'../../files/reports',_0x43e7da['savename']),_0x5b3cb2]);return _0x43e7da;}else{var _0x1bba5c=squel['select']();_0x1bba5c[_0x6b46('0x77')]('('+_0x52864b['toString']()+')',_0x6b46('0xa0'));_0x1bba5c[_0x6b46('0x70')](_0x6b46('0xa1'),'count');_0x52864b[_0x6b46('0x22')](_0x20bef6[_0x6b46('0x22')]||_0x4545d9);_0x52864b[_0x6b46('0x21')](_0x20bef6[_0x6b46('0x21')]||0x0);return dbH[_0x6b46('0x89')][_0x6b46('0x36')](_0x1bba5c['toString'](),{'type':dbH[_0x6b46('0x89')][_0x6b46('0x8a')][_0x6b46('0x8b')]})['then'](function(_0x4298b1){if(!_0x4298b1['length']){_0xd2a99f=0x0;}else{_0xd2a99f=_0x4298b1[0x0][_0x6b46('0x20')]||0x0;}return dbH[_0x6b46('0x89')]['query'](_0x52864b[_0x6b46('0x88')](),{'type':dbH[_0x6b46('0x89')][_0x6b46('0x8a')][_0x6b46('0x8b')]});})['then'](function(_0x343f1c){return{'rows':_0x343f1c||[],'count':_0xd2a99f};});}});}exports[_0x6b46('0xa2')]=function(_0x45c2f5,_0x5d30e7){return runReport(_0x45c2f5['params'],_0x45c2f5[_0x6b46('0x36')],_0x45c2f5[_0x6b46('0x46')])[_0x6b46('0x28')](respondWithResult(_0x5d30e7,null))[_0x6b46('0x4a')](handleError(_0x5d30e7,null));};exports[_0x6b46('0xa3')]=runReport;exports[_0x6b46('0x36')]=function(_0x337f59,_0xc65cfa){var _0x3c949f=0xa;var _0x58a036=[_0x6b46('0x57'),_0x6b46('0x58'),_0x6b46('0xa4'),'cross_join'];var _0x5a1251={'SUM':_0x6b46('0x5a'),'COUNT':_0x6b46('0x5b'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':'MAX(%s)','MIN':_0x6b46('0x5e'),'AVG':_0x6b46('0x5f'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x6b46('0x61'),'GROUP_CONCAT DESC':_0x6b46('0x62')};var _0x3f107b={'SEC_TO_TIME':_0x6b46('0x63'),'DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x6b46('0x67')};var _0x409e65=function(_0x44af46){return!_[_0x6b46('0x68')](['IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY',_0x6b46('0x6c')],_0x44af46);};var _0x536057=function(_0x56b07c){if(!_0x56b07c||!_0x56b07c['rules'][_0x6b46('0x3b')]){return'';}for(var _0x1a5da5='(',_0x53d2b7=0x0;_0x53d2b7<_0x56b07c[_0x6b46('0x6d')][_0x6b46('0x3b')];_0x53d2b7+=0x1){_0x53d2b7>0x0&&(_0x1a5da5+='\x20'+_0x56b07c[_0x6b46('0x6e')]+'\x20');_0x1a5da5+=_0x56b07c[_0x6b46('0x6d')][_0x53d2b7]['group']?_0x536057(_0x56b07c[_0x6b46('0x6d')][_0x53d2b7][_0x6b46('0x6f')]):_0x56b07c[_0x6b46('0x6d')][_0x53d2b7][_0x6b46('0x70')]+'\x20'+_0x56b07c[_0x6b46('0x6d')][_0x53d2b7][_0x6b46('0x71')]+(_0x409e65(_0x56b07c[_0x6b46('0x6d')][_0x53d2b7][_0x6b46('0x71')])?'\x20'+_0x56b07c[_0x6b46('0x6d')][_0x53d2b7][_0x6b46('0x8c')]:'');}return _0x1a5da5+')';};var _0x1edccb={'where':{'id':_0x337f59[_0x6b46('0x4c')]['id']}},_0x422dc2,_0x37e759,_0x4f9700,_0x180c10,_0x703b67;_0x1edccb=_[_0x6b46('0x45')]({},_0x1edccb,_0x337f59['options']);return db[_0x6b46('0x48')]['find'](_0x1edccb)['then'](function(_0x30f71f){if(_0x30f71f){_0x422dc2=_0x30f71f;return _0x30f71f[_0x6b46('0x8d')]();}return null;})[_0x6b46('0x28')](function(_0x580f7d){if(_0x580f7d){if(!_0x580f7d[_0x6b46('0x3b')]){throw new db['Sequelize'][(_0x6b46('0x73'))](_0x6b46('0x74'),0x193);}_0x37e759=_0x580f7d;return db[_0x6b46('0x75')]['findAll']({'raw':!![]});}return null;})[_0x6b46('0x28')](function(_0x1403df){if(_0x1403df){_0x4f9700=_[_0x6b46('0x76')](_0x1403df,'id');var _0x25b825;var _0x23c72e=squel[_0x6b46('0x8e')]();_0x23c72e[_0x6b46('0x77')](_0x422dc2[_0x6b46('0x78')]);for(var _0x1ec4d8=0x0;_0x1ec4d8<_0x37e759[_0x6b46('0x3b')];_0x1ec4d8+=0x1){_0x25b825=_0x37e759[_0x1ec4d8]['MetricId']?_0x4f9700[_0x37e759[_0x1ec4d8][_0x6b46('0x79')]][_0x6b46('0x8f')]:_0x37e759[_0x1ec4d8]['field'];_0x25b825=_0x37e759[_0x1ec4d8][_0x6b46('0x7b')]?_[_0x6b46('0x7a')](_0x5a1251[_0x37e759[_0x1ec4d8][_0x6b46('0x7b')]],'%s',_0x25b825):_0x25b825;_0x25b825=_0x37e759[_0x1ec4d8][_0x6b46('0x7c')]?_[_0x6b46('0x7a')](_0x3f107b[_0x37e759[_0x1ec4d8]['format']],'%s',_0x25b825):_0x25b825;if(_0x37e759[_0x1ec4d8]['groupBy']){_0x23c72e[_0x6b46('0x6f')](_0x25b825);}_0x37e759[_0x1ec4d8][_0x6b46('0x7d')]&&_0x23c72e['order'](_0x25b825,_0x37e759[_0x1ec4d8][_0x6b46('0x7d')]==='DESC'?![]:!![]);_0x23c72e[_0x6b46('0x70')](_0x25b825,_0x37e759[_0x1ec4d8]['alias']||_0x25b825);}if(_0x422dc2[_0x6b46('0x80')]){_0x422dc2[_0x6b46('0x80')]=JSON[_0x6b46('0x81')](_0x422dc2['joins']);for(var _0x36f76f=0x0;_0x36f76f<_0x422dc2[_0x6b46('0x80')][_0x6b46('0x3b')];_0x36f76f+=0x1){if(_0x422dc2['joins'][_0x36f76f][_0x6b46('0x44')]&&_[_0x6b46('0x68')](_0x58a036,_0x422dc2[_0x6b46('0x80')][_0x36f76f][_0x6b46('0x44')])&&_0x422dc2['joins'][_0x36f76f]['parentKey']&&_0x422dc2[_0x6b46('0x80')][_0x36f76f]['foreignTable']&&_0x422dc2[_0x6b46('0x80')][_0x36f76f]['foreignKey']){_0x23c72e[_0x422dc2[_0x6b46('0x80')][_0x36f76f][_0x6b46('0x44')]](_0x422dc2[_0x6b46('0x80')][_0x36f76f][_0x6b46('0x83')],null,util[_0x6b46('0x7c')](_0x6b46('0x91'),_0x422dc2[_0x6b46('0x78')],_0x422dc2['joins'][_0x36f76f][_0x6b46('0x82')],_0x422dc2[_0x6b46('0x80')][_0x36f76f][_0x6b46('0x83')],_0x422dc2[_0x6b46('0x80')][_0x36f76f][_0x6b46('0x92')]));}}}if(_0x422dc2['conditions']){_0x422dc2[_0x6b46('0x84')]=JSON[_0x6b46('0x81')](_0x422dc2[_0x6b46('0x84')]);_0x23c72e[_0x6b46('0x40')](_0x536057(_0x422dc2[_0x6b46('0x84')]['group']));}_0x703b67=_0x23c72e[_0x6b46('0x85')]();_0x23c72e[_0x6b46('0x22')](_0x3c949f);_0x23c72e['offset'](0x0);logger['debug'](_0x6b46('0x87'),_0x23c72e['toString']());return dbH[_0x6b46('0x89')][_0x6b46('0x36')](_0x23c72e[_0x6b46('0x88')](),{'type':dbH[_0x6b46('0x89')][_0x6b46('0x8a')][_0x6b46('0x8b')]});}})['then'](function(){return{'sql':_0x703b67[_0x6b46('0x88')]()};})[_0x6b46('0x28')](respondWithResult(_0xc65cfa,null))[_0x6b46('0x4a')](handleError(_0xc65cfa,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff