// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x5835=['query','filters','intersection','attributes','fields','length','hasOwnProperty','limit','order','pick','filter','where','merge','map','type','key','VIRTUAL','options','count','findAll','catch','show','params','model','includeAll','find','create','body','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','UserProfileSection','userProfileId','name','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','preview','join','right_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%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)','UNIX_TIMESTAMP(%s)','includes','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','group','field','condition','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','keyBy','select','from','table','MetricId','metric','function','replace','format','orderBy','DESC','joins','parse','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','left_join','AVG(%s)','ROUND(%s)','IS\x20NULL','operator','value','AnalyticMetric','alias','No\x20available\x20data','output','web','randomstring','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','fork','../../components/export/','../../files/reports','countTable','COUNT(*)','run','groupBy','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','lodash','crypto','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','end','json','offset','status','set','Content-Range','apply','reject','update','then','destroy','CustomReports','UserProfileResource','error','stack','AnalyticCustomReport','rawAttributes','keys'];(function(_0x3dd15e,_0x1f0015){var _0x231fd0=function(_0x4f680a){while(--_0x4f680a){_0x3dd15e['push'](_0x3dd15e['shift']());}};_0x231fd0(++_0x1f0015);}(_0x5835,0x70));var _0x5583=function(_0x4ad0f7,_0x1920b0){_0x4ad0f7=_0x4ad0f7-0x0;var _0x30f5c8=_0x5835[_0x4ad0f7];return _0x30f5c8;};'use strict';var pdf=require(_0x5583('0x0'));var emlformat=require(_0x5583('0x1'));var rimraf=require(_0x5583('0x2'));var zipdir=require(_0x5583('0x3'));var jsonpatch=require(_0x5583('0x4'));var rp=require(_0x5583('0x5'));var moment=require(_0x5583('0x6'));var BPromise=require(_0x5583('0x7'));var Mustache=require(_0x5583('0x8'));var util=require(_0x5583('0x9'));var path=require(_0x5583('0xa'));var sox=require('sox');var csv=require(_0x5583('0xb'));var ejs=require(_0x5583('0xc'));var fs=require('fs');var _=require(_0x5583('0xd'));var squel=require('squel');var crypto=require(_0x5583('0xe'));var jsforce=require(_0x5583('0xf'));var deskjs=require(_0x5583('0x10'));var toCsv=require('to-csv');var querystring=require(_0x5583('0x11'));var Papa=require(_0x5583('0x12'));var Redis=require('ioredis');var authService=require(_0x5583('0x13'));var qs=require(_0x5583('0x14'));var hardwareService=require(_0x5583('0x15'));var logger=require('../../config/logger')(_0x5583('0x16'));var utils=require(_0x5583('0x17'));var config=require(_0x5583('0x18'));var db=require(_0x5583('0x19'))['db'];function respondWithStatusCode(_0x96a1d8,_0x3041a7){_0x3041a7=_0x3041a7||0xcc;return function(_0x23d52c){if(_0x23d52c){return _0x96a1d8[_0x5583('0x1a')](_0x3041a7);}return _0x96a1d8['status'](_0x3041a7)[_0x5583('0x1b')]();};}function respondWithResult(_0x98be2d,_0x21c374){_0x21c374=_0x21c374||0xc8;return function(_0x3dd63f){if(_0x3dd63f){return _0x98be2d['status'](_0x21c374)[_0x5583('0x1c')](_0x3dd63f);}};}function respondWithFilteredResult(_0x26fc0c,_0x5f2bf9){return function(_0x2c54fe){if(_0x2c54fe){var _0xd7efd4=_0x2c54fe['count'],_0x4dc4c4=_0x5f2bf9[_0x5583('0x1d')],_0x242a87=_0x5f2bf9['offset']+_0x5f2bf9['limit'],_0x5e760b;if(_0x242a87>=_0xd7efd4){_0x242a87=_0xd7efd4;_0x5e760b=0xc8;}else{_0x5e760b=0xce;}_0x26fc0c[_0x5583('0x1e')](_0x5e760b);return _0x26fc0c[_0x5583('0x1f')](_0x5583('0x20'),_0x4dc4c4+'-'+_0x242a87+'/'+_0xd7efd4)[_0x5583('0x1c')](_0x2c54fe);}return null;};}function patchUpdates(_0x1b4a61){return function(_0x591184){try{jsonpatch[_0x5583('0x21')](_0x591184,_0x1b4a61,!![]);}catch(_0x3b0838){return BPromise[_0x5583('0x22')](_0x3b0838);}return _0x591184['save']();};}function saveUpdates(_0x431f7a,_0x70eb4f){return function(_0x5a86c9){if(_0x5a86c9){return _0x5a86c9[_0x5583('0x23')](_0x431f7a)[_0x5583('0x24')](function(_0xd3b302){return _0xd3b302;});}return null;};}function removeEntity(_0x53fe2c,_0x1a1ef8){return function(_0x213bb4){if(_0x213bb4){return _0x213bb4[_0x5583('0x25')]()['then'](function(){var _0x8cde2=_0x213bb4['get']({'plain':!![]});var _0x12ed93=_0x5583('0x26');return db[_0x5583('0x27')]['destroy']({'where':{'type':_0x12ed93,'resourceId':_0x8cde2['id']}})[_0x5583('0x24')](function(){return _0x213bb4;});})[_0x5583('0x24')](function(){_0x53fe2c['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x15edf6,_0x1eb41d){return function(_0x421627){if(!_0x421627){_0x15edf6[_0x5583('0x1a')](0x194);}return _0x421627;};}function handleError(_0x49f1fc,_0x593074){_0x593074=_0x593074||0x1f4;return function(_0x47c59d){logger[_0x5583('0x28')](_0x47c59d[_0x5583('0x29')]);if(_0x47c59d['name']){delete _0x47c59d['name'];}_0x49f1fc[_0x5583('0x1e')](_0x593074)['send'](_0x47c59d);};}exports['index']=function(_0x366b69,_0x3347cf){var _0x8eea31={},_0x5a6164={},_0x5a54ac={'count':0x0,'rows':[]};var _0x11add5=db[_0x5583('0x2a')][_0x5583('0x2b')];_0x5a6164['model']=_[_0x5583('0x2c')](_0x11add5);_0x5a6164['query']=_[_0x5583('0x2c')](_0x366b69[_0x5583('0x2d')]);_0x5a6164[_0x5583('0x2e')]=_[_0x5583('0x2f')](_0x5a6164['model'],_0x5a6164[_0x5583('0x2d')]);_0x8eea31[_0x5583('0x30')]=_[_0x5583('0x2f')](_0x5a6164['model'],qs[_0x5583('0x31')](_0x366b69['query'][_0x5583('0x31')]));_0x8eea31['attributes']=_0x8eea31[_0x5583('0x30')][_0x5583('0x32')]?_0x8eea31[_0x5583('0x30')]:_0x5a6164['model'];if(!_0x366b69['query'][_0x5583('0x33')]('nolimit')){_0x8eea31['limit']=qs[_0x5583('0x34')](_0x366b69['query'][_0x5583('0x34')]);_0x8eea31[_0x5583('0x1d')]=qs[_0x5583('0x1d')](_0x366b69[_0x5583('0x2d')]['offset']);}_0x8eea31[_0x5583('0x35')]=qs['sort'](_0x366b69['query']['sort']);_0x8eea31['where']=qs[_0x5583('0x2e')](_[_0x5583('0x36')](_0x366b69['query'],_0x5a6164[_0x5583('0x2e')]));if(_0x366b69[_0x5583('0x2d')][_0x5583('0x37')]){_0x8eea31[_0x5583('0x38')]=_[_0x5583('0x39')](_0x8eea31['where'],{'$or':_[_0x5583('0x3a')](_0x11add5,function(_0xa8befe){if(_0xa8befe[_0x5583('0x3b')][_0x5583('0x3c')]!==_0x5583('0x3d')){var _0x2051b4={};_0x2051b4[_0xa8befe['field']]={'$like':'%'+_0x366b69['query'][_0x5583('0x37')]+'%'};return _0x2051b4;}})});}_0x8eea31=_[_0x5583('0x39')]({},_0x8eea31,_0x366b69[_0x5583('0x3e')]);var _0x1b0d4d={'where':_0x8eea31[_0x5583('0x38')]};return db[_0x5583('0x2a')]['count'](_0x1b0d4d)[_0x5583('0x24')](function(_0x223998){_0x5a54ac[_0x5583('0x3f')]=_0x223998;if(_0x366b69[_0x5583('0x2d')]['includeAll']){_0x8eea31['include']=[{'all':!![]}];}return db[_0x5583('0x2a')][_0x5583('0x40')](_0x8eea31);})[_0x5583('0x24')](function(_0x2951c9){_0x5a54ac['rows']=_0x2951c9;return _0x5a54ac;})[_0x5583('0x24')](respondWithFilteredResult(_0x3347cf,_0x8eea31))[_0x5583('0x41')](handleError(_0x3347cf,null));};exports[_0x5583('0x42')]=function(_0x1965f3,_0x537db9){var _0x29cdf9={'raw':![],'where':{'id':_0x1965f3[_0x5583('0x43')]['id']}},_0x327d09={};_0x327d09[_0x5583('0x44')]=_[_0x5583('0x2c')](db[_0x5583('0x2a')]['rawAttributes']);_0x327d09[_0x5583('0x2d')]=_['keys'](_0x1965f3['query']);_0x327d09[_0x5583('0x2e')]=_[_0x5583('0x2f')](_0x327d09[_0x5583('0x44')],_0x327d09[_0x5583('0x2d')]);_0x29cdf9['attributes']=_['intersection'](_0x327d09[_0x5583('0x44')],qs['fields'](_0x1965f3['query'][_0x5583('0x31')]));_0x29cdf9[_0x5583('0x30')]=_0x29cdf9[_0x5583('0x30')]['length']?_0x29cdf9[_0x5583('0x30')]:_0x327d09[_0x5583('0x44')];if(_0x1965f3[_0x5583('0x2d')][_0x5583('0x45')]){_0x29cdf9['include']=[{'all':!![]}];}_0x29cdf9=_['merge']({},_0x29cdf9,_0x1965f3[_0x5583('0x3e')]);return db[_0x5583('0x2a')][_0x5583('0x46')](_0x29cdf9)[_0x5583('0x24')](handleEntityNotFound(_0x537db9,null))[_0x5583('0x24')](respondWithResult(_0x537db9,null))[_0x5583('0x41')](handleError(_0x537db9,null));};exports[_0x5583('0x47')]=function(_0x1d4027,_0xa593fe){return db[_0x5583('0x2a')][_0x5583('0x47')](_0x1d4027[_0x5583('0x48')],{})['then'](function(_0x3a10d8){var _0x314200=_0x1d4027[_0x5583('0x49')][_0x5583('0x4a')]({'plain':!![]});if(!_0x314200)throw new Error(_0x5583('0x4b'));if(_0x314200[_0x5583('0x4c')]===_0x5583('0x49')){var _0xf091eb=_0x3a10d8[_0x5583('0x4a')]({'plain':!![]});var _0x1eb5c3=_0x5583('0x4d');return db[_0x5583('0x4e')][_0x5583('0x46')]({'where':{'name':_0x1eb5c3,'userProfileId':_0x314200[_0x5583('0x4f')]},'raw':!![]})[_0x5583('0x24')](function(_0x446c1c){if(_0x446c1c&&_0x446c1c['autoAssociation']===0x0){return db[_0x5583('0x27')]['create']({'name':_0xf091eb[_0x5583('0x50')],'resourceId':_0xf091eb['id'],'type':_0x5583('0x26'),'sectionId':_0x446c1c['id']},{})[_0x5583('0x24')](function(){return _0x3a10d8;});}else{return _0x3a10d8;}})[_0x5583('0x41')](function(_0x56b622){logger[_0x5583('0x28')](_0x5583('0x51'),_0x56b622);throw _0x56b622;});}return _0x3a10d8;})['then'](respondWithResult(_0xa593fe,0xc9))[_0x5583('0x41')](handleError(_0xa593fe,null));};exports['update']=function(_0x23440a,_0x141916){if(_0x23440a[_0x5583('0x48')]['id']){delete _0x23440a['body']['id'];}return db[_0x5583('0x2a')][_0x5583('0x46')]({'where':{'id':_0x23440a[_0x5583('0x43')]['id']}})['then'](handleEntityNotFound(_0x141916,null))[_0x5583('0x24')](saveUpdates(_0x23440a[_0x5583('0x48')],null))[_0x5583('0x24')](respondWithResult(_0x141916,null))[_0x5583('0x41')](handleError(_0x141916,null));};exports[_0x5583('0x25')]=function(_0x1e59a2,_0x3d161){return db[_0x5583('0x2a')][_0x5583('0x46')]({'where':{'id':_0x1e59a2[_0x5583('0x43')]['id']}})[_0x5583('0x24')](handleEntityNotFound(_0x3d161,null))['then'](removeEntity(_0x3d161,null))[_0x5583('0x41')](handleError(_0x3d161,null));};exports[_0x5583('0x52')]=function(_0x2ef75d,_0x75125a){var _0x15d292=0xa;var _0x563743=[_0x5583('0x53'),'left_join',_0x5583('0x54'),'cross_join'];var _0x142895={'SUM':_0x5583('0x55'),'COUNT':_0x5583('0x56'),'COUNT DISTINCT':_0x5583('0x57'),'MAX':_0x5583('0x58'),'MIN':'MIN(%s)','AVG':'AVG(%s)','GROUP_CONCAT':_0x5583('0x59'),'GROUP_CONCAT ASC':_0x5583('0x5a'),'GROUP_CONCAT DESC':_0x5583('0x5b')};var _0x5e490a={'SEC_TO_TIME':_0x5583('0x5c'),'DATE':_0x5583('0x5d'),'HOUR':_0x5583('0x5e'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x5583('0x5f')};var _0x174773=function(_0x22a2c0){return!_[_0x5583('0x60')](['IS\x20NULL',_0x5583('0x61'),_0x5583('0x62'),_0x5583('0x63')],_0x22a2c0);};var _0x3b49cc=function(_0x21dd65){if(!_0x21dd65||!_0x21dd65['rules']['length']){return'';}for(var _0xd07115='(',_0x343737=0x0;_0x343737<_0x21dd65[_0x5583('0x64')][_0x5583('0x32')];_0x343737+=0x1){_0x343737>0x0&&(_0xd07115+='\x20'+_0x21dd65['operator']+'\x20');_0xd07115+=_0x21dd65[_0x5583('0x64')][_0x343737][_0x5583('0x65')]?_0x3b49cc(_0x21dd65[_0x5583('0x64')][_0x343737]['group']):_0x21dd65[_0x5583('0x64')][_0x343737][_0x5583('0x66')]+'\x20'+_0x21dd65['rules'][_0x343737][_0x5583('0x67')]+(_0x174773(_0x21dd65[_0x5583('0x64')][_0x343737]['condition'])?'\x20'+_0x21dd65['rules'][_0x343737]['value']:'');}return _0xd07115+')';};var _0x299a73={'where':{'id':_0x2ef75d[_0x5583('0x43')]['id']}},_0x4af70b,_0x21ac66,_0x2836ee,_0x31479e,_0x1ebe4b;_0x299a73=_['merge']({},_0x299a73,_0x2ef75d[_0x5583('0x3e')]);return db[_0x5583('0x2a')]['find'](_0x299a73)['then'](function(_0x15ac71){if(_0x15ac71){_0x4af70b=_0x15ac71;return _0x15ac71[_0x5583('0x68')]();}return null;})[_0x5583('0x24')](function(_0x12065f){if(_0x12065f){if(!_0x12065f['length']){throw new db[(_0x5583('0x69'))][(_0x5583('0x6a'))](_0x5583('0x6b'),0x193);}_0x21ac66=_0x12065f;return db['AnalyticMetric']['findAll']({'raw':!![]});}return null;})[_0x5583('0x24')](function(_0x1d05fb){if(_0x1d05fb){_0x2836ee=_[_0x5583('0x6c')](_0x1d05fb,'id');var _0x5e91c3;var _0x1039e4=squel[_0x5583('0x6d')]();_0x1039e4[_0x5583('0x6e')](_0x4af70b[_0x5583('0x6f')]);for(var _0x1cee2a=0x0;_0x1cee2a<_0x21ac66[_0x5583('0x32')];_0x1cee2a+=0x1){_0x5e91c3=_0x21ac66[_0x1cee2a][_0x5583('0x70')]?_0x2836ee[_0x21ac66[_0x1cee2a][_0x5583('0x70')]][_0x5583('0x71')]:_0x21ac66[_0x1cee2a]['field'];_0x5e91c3=_0x21ac66[_0x1cee2a][_0x5583('0x72')]?_[_0x5583('0x73')](_0x142895[_0x21ac66[_0x1cee2a]['function']],'%s',_0x5e91c3):_0x5e91c3;_0x5e91c3=_0x21ac66[_0x1cee2a][_0x5583('0x74')]?_[_0x5583('0x73')](_0x5e490a[_0x21ac66[_0x1cee2a][_0x5583('0x74')]],'%s',_0x5e91c3):_0x5e91c3;if(_0x21ac66[_0x1cee2a]['groupBy']){_0x1039e4[_0x5583('0x65')](_0x5e91c3);}_0x21ac66[_0x1cee2a]['orderBy']&&_0x1039e4[_0x5583('0x35')](_0x5e91c3,_0x21ac66[_0x1cee2a][_0x5583('0x75')]===_0x5583('0x76')?![]:!![]);_0x1039e4[_0x5583('0x66')](_0x5e91c3,_0x21ac66[_0x1cee2a]['alias']||_0x5e91c3);}if(_0x4af70b['joins']){_0x4af70b[_0x5583('0x77')]=JSON[_0x5583('0x78')](_0x4af70b['joins']);for(var _0x44be8b=0x0;_0x44be8b<_0x4af70b['joins'][_0x5583('0x32')];_0x44be8b+=0x1){if(_0x4af70b[_0x5583('0x77')][_0x44be8b][_0x5583('0x3b')]&&_['includes'](_0x563743,_0x4af70b[_0x5583('0x77')][_0x44be8b][_0x5583('0x3b')])&&_0x4af70b[_0x5583('0x77')][_0x44be8b][_0x5583('0x79')]&&_0x4af70b[_0x5583('0x77')][_0x44be8b][_0x5583('0x7a')]&&_0x4af70b[_0x5583('0x77')][_0x44be8b][_0x5583('0x7b')]){_0x1039e4[_0x4af70b[_0x5583('0x77')][_0x44be8b][_0x5583('0x3b')]](_0x4af70b[_0x5583('0x77')][_0x44be8b]['foreignTable'],null,util['format'](_0x5583('0x7c'),_0x4af70b[_0x5583('0x6f')],_0x4af70b[_0x5583('0x77')][_0x44be8b][_0x5583('0x79')],_0x4af70b[_0x5583('0x77')][_0x44be8b]['foreignTable'],_0x4af70b['joins'][_0x44be8b][_0x5583('0x7b')]));}}}if(_0x4af70b['conditions']){_0x4af70b[_0x5583('0x7d')]=JSON[_0x5583('0x78')](_0x4af70b[_0x5583('0x7d')]);_0x1039e4[_0x5583('0x38')](_0x3b49cc(_0x4af70b['conditions'][_0x5583('0x65')]));}_0x1ebe4b=_0x1039e4[_0x5583('0x7e')]();_0x1039e4[_0x5583('0x34')](_0x15d292);_0x1039e4[_0x5583('0x1d')](0x0);logger[_0x5583('0x7f')](_0x5583('0x80'),_0x1039e4[_0x5583('0x81')]());return db[_0x5583('0x82')]['query'](_0x1039e4[_0x5583('0x81')](),{'type':db[_0x5583('0x82')][_0x5583('0x83')][_0x5583('0x84')]});}})['then'](respondWithResult(_0x75125a,null))[_0x5583('0x41')](handleError(_0x75125a,null));};function runReport(_0x174783,_0xc6ab09,_0x34c302){var _0x3dc897=_0xc6ab09['name'];var _0x1390a4=0xa;var _0x1cf37d=['join',_0x5583('0x85'),_0x5583('0x54'),'cross_join'];var _0x5cb13f={'SUM':_0x5583('0x55'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x5583('0x57'),'MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':_0x5583('0x86'),'GROUP_CONCAT':_0x5583('0x59'),'GROUP_CONCAT ASC':_0x5583('0x5a'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x24fb3d={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x5583('0x5d'),'HOUR':_0x5583('0x5e'),'ROUND':_0x5583('0x87'),'UNIX_TIMESTAMP':_0x5583('0x5f')};var _0x324ae0=function(_0x14b8c1){return!_['includes']([_0x5583('0x88'),'IS\x20NOT\x20NULL','IS\x20EMPTY',_0x5583('0x63')],_0x14b8c1);};var _0x1a8281=function(_0x584df7){if(!_0x584df7||!_0x584df7[_0x5583('0x64')][_0x5583('0x32')]){return'';}for(var _0x10a28d='(',_0x889ff9=0x0;_0x889ff9<_0x584df7[_0x5583('0x64')][_0x5583('0x32')];_0x889ff9+=0x1){_0x889ff9>0x0&&(_0x10a28d+='\x20'+_0x584df7[_0x5583('0x89')]+'\x20');_0x10a28d+=_0x584df7[_0x5583('0x64')][_0x889ff9]['group']?_0x1a8281(_0x584df7[_0x5583('0x64')][_0x889ff9][_0x5583('0x65')]):_0x584df7[_0x5583('0x64')][_0x889ff9][_0x5583('0x66')]+'\x20'+_0x584df7[_0x5583('0x64')][_0x889ff9][_0x5583('0x67')]+(_0x324ae0(_0x584df7[_0x5583('0x64')][_0x889ff9][_0x5583('0x67')])?'\x20'+_0x584df7[_0x5583('0x64')][_0x889ff9][_0x5583('0x8a')]:'');}return _0x10a28d+')';};var _0x4d0e66={'where':{'id':_0x174783['id']}},_0x72db42,_0x16db1f,_0x4afbf1,_0x29fc26,_0x1527d3;_0x4d0e66=_[_0x5583('0x39')]({},_0x4d0e66,_0x34c302);return db[_0x5583('0x2a')]['find'](_0x4d0e66)[_0x5583('0x24')](function(_0xbaa17e){if(_0xbaa17e){_0x72db42=_0xbaa17e;return _0xbaa17e[_0x5583('0x68')]();}return null;})[_0x5583('0x24')](function(_0x4edb5f){if(_0x4edb5f){if(!_0x4edb5f[_0x5583('0x32')]){throw new db[(_0x5583('0x69'))]['ValidationErrorItem'](_0x5583('0x6b'),0x193);}_0x16db1f=_0x4edb5f;return db[_0x5583('0x8b')][_0x5583('0x40')]({'raw':!![]});}return null;})[_0x5583('0x24')](function(_0x473288){if(_0x473288){_0x4afbf1=_['keyBy'](_0x473288,'id');var _0x58f9e3;var _0x1a65b4=squel[_0x5583('0x6d')]();_0x1a65b4[_0x5583('0x6e')](_0x72db42[_0x5583('0x6f')]);for(var _0x5239d3=0x0;_0x5239d3<_0x16db1f['length'];_0x5239d3+=0x1){_0x58f9e3=_0x16db1f[_0x5239d3][_0x5583('0x70')]?_0x4afbf1[_0x16db1f[_0x5239d3]['MetricId']][_0x5583('0x71')]:_0x16db1f[_0x5239d3]['field'];_0x58f9e3=_0x16db1f[_0x5239d3][_0x5583('0x72')]?_[_0x5583('0x73')](_0x5cb13f[_0x16db1f[_0x5239d3]['function']],'%s',_0x58f9e3):_0x58f9e3;_0x58f9e3=_0x16db1f[_0x5239d3][_0x5583('0x74')]?_[_0x5583('0x73')](_0x24fb3d[_0x16db1f[_0x5239d3][_0x5583('0x74')]],'%s',_0x58f9e3):_0x58f9e3;if(_0x16db1f[_0x5239d3]['groupBy']){_0x1a65b4[_0x5583('0x65')](_0x58f9e3);}_0x16db1f[_0x5239d3]['orderBy']&&_0x1a65b4[_0x5583('0x35')](_0x58f9e3,_0x16db1f[_0x5239d3]['orderBy']==='DESC'?![]:!![]);_0x1a65b4[_0x5583('0x66')](_0x58f9e3,_0x16db1f[_0x5239d3][_0x5583('0x8c')]||_0x58f9e3);}if(_0x72db42[_0x5583('0x77')]){_0x72db42[_0x5583('0x77')]=JSON[_0x5583('0x78')](_0x72db42[_0x5583('0x77')]);for(var _0x23af2e=0x0;_0x23af2e<_0x72db42[_0x5583('0x77')][_0x5583('0x32')];_0x23af2e+=0x1){if(_0x72db42[_0x5583('0x77')][_0x23af2e][_0x5583('0x3b')]&&_['includes'](_0x1cf37d,_0x72db42[_0x5583('0x77')][_0x23af2e][_0x5583('0x3b')])&&_0x72db42['joins'][_0x23af2e][_0x5583('0x79')]&&_0x72db42['joins'][_0x23af2e]['foreignTable']&&_0x72db42[_0x5583('0x77')][_0x23af2e][_0x5583('0x7b')]){_0x1a65b4[_0x72db42[_0x5583('0x77')][_0x23af2e]['type']](_0x72db42['joins'][_0x23af2e]['foreignTable'],null,util['format'](_0x5583('0x7c'),_0x72db42[_0x5583('0x6f')],_0x72db42[_0x5583('0x77')][_0x23af2e][_0x5583('0x79')],_0x72db42[_0x5583('0x77')][_0x23af2e]['foreignTable'],_0x72db42[_0x5583('0x77')][_0x23af2e][_0x5583('0x7b')]));}}}if(_0x72db42['conditions']){_0x72db42['conditions']=JSON[_0x5583('0x78')](_0x72db42[_0x5583('0x7d')]);_0x1a65b4['where'](_0x1a8281(_0x72db42[_0x5583('0x7d')][_0x5583('0x65')]));}_0x1527d3=_0x1a65b4[_0x5583('0x7e')]();_0x1a65b4['limit'](_0x1390a4);_0x1a65b4['offset'](0x0);logger[_0x5583('0x7f')](_0x5583('0x80'),_0x1a65b4[_0x5583('0x81')]());return db[_0x5583('0x82')][_0x5583('0x2d')](_0x1a65b4[_0x5583('0x81')](),{'type':db[_0x5583('0x82')][_0x5583('0x83')]['SELECT']});}})[_0x5583('0x24')](function(_0x1cd67a){if(!_0x1cd67a[_0x5583('0x32')]){throw new db[(_0x5583('0x69'))][(_0x5583('0x6a'))](_0x5583('0x8d'),0xcc);}if(_0xc6ab09[_0x5583('0x8e')]===_0x5583('0x8f')){return null;}var _0x44f0fd=_[_0x5583('0x39')](_0xc6ab09,{'name':_0xc6ab09['fullPath']||_0xc6ab09[_0x5583('0x50')]||_0x72db42[_0x5583('0x50')],'basename':_0x3dc897,'savename':util['format']('%s-%s.%s',_0xc6ab09[_0x5583('0x50')]||_0x72db42[_0x5583('0x50')],require(_0x5583('0x90'))['generate'](0x4),_0xc6ab09[_0x5583('0x8e')]||'csv'),'reportId':_0x72db42['id'],'reportType':'custom'});return db[_0x5583('0x91')][_0x5583('0x47')](_0x44f0fd,{'raw':!![]});})[_0x5583('0x24')](function(_0x8c6801){if(_0x72db42[_0x5583('0x6f')]===_0x5583('0x92')){_0x1527d3['where'](_0x72db42[_0x5583('0x6f')]+_0x5583('0x93'),_0xc6ab09[_0x5583('0x94')],_0xc6ab09[_0x5583('0x95')]);}else{_0x1527d3[_0x5583('0x38')](_0x72db42[_0x5583('0x6f')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0xc6ab09['startDate'],_0xc6ab09[_0x5583('0x95')]);}if(_0x8c6801){logger['info']('Run\x20Query:',_0x1527d3[_0x5583('0x81')]());require('child_process')[_0x5583('0x96')](path['join'](__dirname,_0x5583('0x97'),_0x8c6801['output']),[_0x8c6801['id'],_0x1527d3[_0x5583('0x81')](),path['join'](__dirname,_0x5583('0x98'),_0x8c6801['savename']),_0x3dc897]);return _0x8c6801;}else{var _0x52b85a=squel[_0x5583('0x6d')]();_0x52b85a[_0x5583('0x6e')]('('+_0x1527d3[_0x5583('0x81')]()+')',_0x5583('0x99'));_0x52b85a[_0x5583('0x66')](_0x5583('0x9a'),_0x5583('0x3f'));_0x1527d3[_0x5583('0x34')](_0xc6ab09['limit']||_0x1390a4);_0x1527d3[_0x5583('0x1d')](_0xc6ab09[_0x5583('0x1d')]||0x0);return db['sequelize']['query'](_0x52b85a[_0x5583('0x81')](),{'type':db[_0x5583('0x82')][_0x5583('0x83')][_0x5583('0x84')]})[_0x5583('0x24')](function(_0x278940){if(!_0x278940[_0x5583('0x32')]){_0x29fc26=0x0;}else{_0x29fc26=_0x278940[0x0]['count']||0x0;}return db['sequelize'][_0x5583('0x2d')](_0x1527d3[_0x5583('0x81')](),{'type':db['sequelize'][_0x5583('0x83')][_0x5583('0x84')]});})[_0x5583('0x24')](function(_0x5e1498){return{'rows':_0x5e1498||[],'count':_0x29fc26};});}});}exports[_0x5583('0x9b')]=function(_0x3021d0,_0x86bf07){return runReport(_0x3021d0['params'],_0x3021d0[_0x5583('0x2d')],_0x3021d0['options'])[_0x5583('0x24')](respondWithResult(_0x86bf07,null))[_0x5583('0x41')](handleError(_0x86bf07,null));};exports['runReport']=runReport;exports[_0x5583('0x2d')]=function(_0xc41301,_0x4fffc8){var _0x1d3a37=0xa;var _0x415244=[_0x5583('0x53'),'left_join','right_join','cross_join'];var _0x3a0c1a={'SUM':_0x5583('0x55'),'COUNT':_0x5583('0x56'),'COUNT DISTINCT':_0x5583('0x57'),'MAX':_0x5583('0x58'),'MIN':'MIN(%s)','AVG':_0x5583('0x86'),'GROUP_CONCAT':_0x5583('0x59'),'GROUP_CONCAT ASC':_0x5583('0x5a'),'GROUP_CONCAT DESC':_0x5583('0x5b')};var _0x182bfd={'SEC_TO_TIME':_0x5583('0x5c'),'DATE':_0x5583('0x5d'),'HOUR':_0x5583('0x5e'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x5583('0x5f')};var _0x382007=function(_0xd4a1d7){return!_[_0x5583('0x60')](['IS\x20NULL','IS\x20NOT\x20NULL',_0x5583('0x62'),_0x5583('0x63')],_0xd4a1d7);};var _0x3713d6=function(_0x4ca292){if(!_0x4ca292||!_0x4ca292[_0x5583('0x64')][_0x5583('0x32')]){return'';}for(var _0x1affca='(',_0xf14340=0x0;_0xf14340<_0x4ca292['rules']['length'];_0xf14340+=0x1){_0xf14340>0x0&&(_0x1affca+='\x20'+_0x4ca292['operator']+'\x20');_0x1affca+=_0x4ca292[_0x5583('0x64')][_0xf14340][_0x5583('0x65')]?_0x3713d6(_0x4ca292['rules'][_0xf14340][_0x5583('0x65')]):_0x4ca292[_0x5583('0x64')][_0xf14340][_0x5583('0x66')]+'\x20'+_0x4ca292[_0x5583('0x64')][_0xf14340][_0x5583('0x67')]+(_0x382007(_0x4ca292['rules'][_0xf14340][_0x5583('0x67')])?'\x20'+_0x4ca292[_0x5583('0x64')][_0xf14340][_0x5583('0x8a')]:'');}return _0x1affca+')';};var _0x3511e6={'where':{'id':_0xc41301[_0x5583('0x43')]['id']}},_0x1a3b7e,_0x2b358b,_0x327a86,_0x1d2610,_0x305d5e;_0x3511e6=_[_0x5583('0x39')]({},_0x3511e6,_0xc41301[_0x5583('0x3e')]);return db['AnalyticCustomReport'][_0x5583('0x46')](_0x3511e6)[_0x5583('0x24')](function(_0x973fe3){if(_0x973fe3){_0x1a3b7e=_0x973fe3;return _0x973fe3[_0x5583('0x68')]();}return null;})[_0x5583('0x24')](function(_0x155010){if(_0x155010){if(!_0x155010['length']){throw new db[(_0x5583('0x69'))]['ValidationErrorItem'](_0x5583('0x6b'),0x193);}_0x2b358b=_0x155010;return db[_0x5583('0x8b')]['findAll']({'raw':!![]});}return null;})[_0x5583('0x24')](function(_0x28167c){if(_0x28167c){_0x327a86=_['keyBy'](_0x28167c,'id');var _0x4b16a7;var _0x456524=squel[_0x5583('0x6d')]();_0x456524['from'](_0x1a3b7e[_0x5583('0x6f')]);for(var _0x3d3070=0x0;_0x3d3070<_0x2b358b['length'];_0x3d3070+=0x1){_0x4b16a7=_0x2b358b[_0x3d3070][_0x5583('0x70')]?_0x327a86[_0x2b358b[_0x3d3070][_0x5583('0x70')]][_0x5583('0x71')]:_0x2b358b[_0x3d3070][_0x5583('0x66')];_0x4b16a7=_0x2b358b[_0x3d3070][_0x5583('0x72')]?_[_0x5583('0x73')](_0x3a0c1a[_0x2b358b[_0x3d3070][_0x5583('0x72')]],'%s',_0x4b16a7):_0x4b16a7;_0x4b16a7=_0x2b358b[_0x3d3070]['format']?_[_0x5583('0x73')](_0x182bfd[_0x2b358b[_0x3d3070][_0x5583('0x74')]],'%s',_0x4b16a7):_0x4b16a7;if(_0x2b358b[_0x3d3070][_0x5583('0x9c')]){_0x456524[_0x5583('0x65')](_0x4b16a7);}_0x2b358b[_0x3d3070]['orderBy']&&_0x456524[_0x5583('0x35')](_0x4b16a7,_0x2b358b[_0x3d3070][_0x5583('0x75')]===_0x5583('0x76')?![]:!![]);_0x456524[_0x5583('0x66')](_0x4b16a7,_0x2b358b[_0x3d3070][_0x5583('0x8c')]||_0x4b16a7);}if(_0x1a3b7e[_0x5583('0x77')]){_0x1a3b7e[_0x5583('0x77')]=JSON[_0x5583('0x78')](_0x1a3b7e['joins']);for(var _0x541826=0x0;_0x541826<_0x1a3b7e[_0x5583('0x77')]['length'];_0x541826+=0x1){if(_0x1a3b7e['joins'][_0x541826][_0x5583('0x3b')]&&_[_0x5583('0x60')](_0x415244,_0x1a3b7e[_0x5583('0x77')][_0x541826][_0x5583('0x3b')])&&_0x1a3b7e[_0x5583('0x77')][_0x541826]['parentKey']&&_0x1a3b7e[_0x5583('0x77')][_0x541826][_0x5583('0x7a')]&&_0x1a3b7e[_0x5583('0x77')][_0x541826][_0x5583('0x7b')]){_0x456524[_0x1a3b7e[_0x5583('0x77')][_0x541826][_0x5583('0x3b')]](_0x1a3b7e['joins'][_0x541826][_0x5583('0x7a')],null,util['format'](_0x5583('0x7c'),_0x1a3b7e[_0x5583('0x6f')],_0x1a3b7e[_0x5583('0x77')][_0x541826]['parentKey'],_0x1a3b7e[_0x5583('0x77')][_0x541826][_0x5583('0x7a')],_0x1a3b7e[_0x5583('0x77')][_0x541826][_0x5583('0x7b')]));}}}if(_0x1a3b7e[_0x5583('0x7d')]){_0x1a3b7e['conditions']=JSON[_0x5583('0x78')](_0x1a3b7e['conditions']);_0x456524[_0x5583('0x38')](_0x3713d6(_0x1a3b7e['conditions'][_0x5583('0x65')]));}_0x305d5e=_0x456524[_0x5583('0x7e')]();_0x456524[_0x5583('0x34')](_0x1d3a37);_0x456524[_0x5583('0x1d')](0x0);logger['debug']('Limited\x20Query:',_0x456524['toString']());return db['sequelize'][_0x5583('0x2d')](_0x456524[_0x5583('0x81')](),{'type':db['sequelize'][_0x5583('0x83')]['SELECT']});}})['then'](function(){return{'sql':_0x305d5e['toString']()};})[_0x5583('0x24')](respondWithResult(_0x4fffc8,null))['catch'](handleError(_0x4fffc8,null));};
\ No newline at end of file
+var _0x5b52=['UserProfileResource','error','stack','name','send','index','keys','query','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','limit','sort','where','filters','map','type','key','VIRTUAL','field','merge','options','includeAll','include','AnalyticCustomReport','findAll','rows','catch','show','params','rawAttributes','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','Reports','UserProfileSection','find','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','left_join','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','DATE(%s)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','condition','getFields','Sequelize','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','select','from','MetricId','metric','function','format','groupBy','orderBy','order','DESC','alias','joins','parse','includes','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','table','conditions','clone','debug','sequelize','toString','QueryTypes','SELECT','join','right_join','SUM(%s)','AVG(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','value','replace','Limited\x20Query:','ValidationErrorItem','No\x20available\x20data','output','fullPath','%s-%s.%s','randomstring','custom','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','fork','../../components/export/','../../files/reports','savename','countTable','COUNT(*)','run','cross_join','MIN(%s)','IS\x20NULL','html-pdf','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','lodash','crypto','jsforce','desk.js','../../components/parsers/qs','../../config/logger','../../config/utils','../../mysqldb','sendStatus','status','end','count','offset','set','Content-Range','json','apply','save','update','then','destroy','get','CustomReports'];(function(_0x2b7764,_0x2606f1){var _0x848dcb=function(_0x1ae85b){while(--_0x1ae85b){_0x2b7764['push'](_0x2b7764['shift']());}};_0x848dcb(++_0x2606f1);}(_0x5b52,0x11d));var _0x25b5=function(_0x321bb2,_0x202794){_0x321bb2=_0x321bb2-0x0;var _0x9c12ed=_0x5b52[_0x321bb2];return _0x9c12ed;};'use strict';var pdf=require(_0x25b5('0x0'));var emlformat=require('eml-format');var rimraf=require(_0x25b5('0x1'));var zipdir=require(_0x25b5('0x2'));var jsonpatch=require(_0x25b5('0x3'));var rp=require(_0x25b5('0x4'));var moment=require(_0x25b5('0x5'));var BPromise=require(_0x25b5('0x6'));var Mustache=require(_0x25b5('0x7'));var util=require(_0x25b5('0x8'));var path=require(_0x25b5('0x9'));var sox=require('sox');var csv=require(_0x25b5('0xa'));var ejs=require(_0x25b5('0xb'));var fs=require('fs');var _=require(_0x25b5('0xc'));var squel=require('squel');var crypto=require(_0x25b5('0xd'));var jsforce=require(_0x25b5('0xe'));var deskjs=require(_0x25b5('0xf'));var toCsv=require(_0x25b5('0xa'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0x25b5('0x10'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x25b5('0x11'))('api');var utils=require(_0x25b5('0x12'));var config=require('../../config/environment');var db=require(_0x25b5('0x13'))['db'];function respondWithStatusCode(_0x263e2e,_0x167ad3){_0x167ad3=_0x167ad3||0xcc;return function(_0x56809e){if(_0x56809e){return _0x263e2e[_0x25b5('0x14')](_0x167ad3);}return _0x263e2e[_0x25b5('0x15')](_0x167ad3)[_0x25b5('0x16')]();};}function respondWithResult(_0x46961d,_0x5ad37a){_0x5ad37a=_0x5ad37a||0xc8;return function(_0x27bd61){if(_0x27bd61){return _0x46961d[_0x25b5('0x15')](_0x5ad37a)['json'](_0x27bd61);}};}function respondWithFilteredResult(_0x2a2d65,_0x4dced7){return function(_0x3bb922){if(_0x3bb922){var _0xadbe04=_0x3bb922[_0x25b5('0x17')],_0x242141=_0x4dced7[_0x25b5('0x18')],_0x1cdb39=_0x4dced7['offset']+_0x4dced7['limit'],_0x595c16;if(_0x1cdb39>=_0xadbe04){_0x1cdb39=_0xadbe04;_0x595c16=0xc8;}else{_0x595c16=0xce;}_0x2a2d65[_0x25b5('0x15')](_0x595c16);return _0x2a2d65[_0x25b5('0x19')](_0x25b5('0x1a'),_0x242141+'-'+_0x1cdb39+'/'+_0xadbe04)[_0x25b5('0x1b')](_0x3bb922);}return null;};}function patchUpdates(_0x79771b){return function(_0x5d5f92){try{jsonpatch[_0x25b5('0x1c')](_0x5d5f92,_0x79771b,!![]);}catch(_0xcae430){return BPromise['reject'](_0xcae430);}return _0x5d5f92[_0x25b5('0x1d')]();};}function saveUpdates(_0x3fda33,_0x2f6ea9){return function(_0x3182de){if(_0x3182de){return _0x3182de[_0x25b5('0x1e')](_0x3fda33)[_0x25b5('0x1f')](function(_0x1264ae){return _0x1264ae;});}return null;};}function removeEntity(_0x39f14a,_0x202792){return function(_0x1cc8bb){if(_0x1cc8bb){return _0x1cc8bb[_0x25b5('0x20')]()[_0x25b5('0x1f')](function(){var _0x155c8a=_0x1cc8bb[_0x25b5('0x21')]({'plain':!![]});var _0x4c000f=_0x25b5('0x22');return db[_0x25b5('0x23')]['destroy']({'where':{'type':_0x4c000f,'resourceId':_0x155c8a['id']}})[_0x25b5('0x1f')](function(){return _0x1cc8bb;});})[_0x25b5('0x1f')](function(){_0x39f14a['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x59f934,_0x22ced4){return function(_0x3ac743){if(!_0x3ac743){_0x59f934[_0x25b5('0x14')](0x194);}return _0x3ac743;};}function handleError(_0x5270fe,_0x5a2099){_0x5a2099=_0x5a2099||0x1f4;return function(_0x1fe9a8){logger[_0x25b5('0x24')](_0x1fe9a8[_0x25b5('0x25')]);if(_0x1fe9a8[_0x25b5('0x26')]){delete _0x1fe9a8[_0x25b5('0x26')];}_0x5270fe[_0x25b5('0x15')](_0x5a2099)[_0x25b5('0x27')](_0x1fe9a8);};}exports[_0x25b5('0x28')]=function(_0x3026cb,_0xca3eac){var _0x1f01ef={},_0x5c3c5e={},_0x557822={'count':0x0,'rows':[]};var _0x543928=db['AnalyticCustomReport']['rawAttributes'];_0x5c3c5e['model']=_[_0x25b5('0x29')](_0x543928);_0x5c3c5e[_0x25b5('0x2a')]=_['keys'](_0x3026cb[_0x25b5('0x2a')]);_0x5c3c5e['filters']=_[_0x25b5('0x2b')](_0x5c3c5e[_0x25b5('0x2c')],_0x5c3c5e[_0x25b5('0x2a')]);_0x1f01ef[_0x25b5('0x2d')]=_[_0x25b5('0x2b')](_0x5c3c5e[_0x25b5('0x2c')],qs['fields'](_0x3026cb[_0x25b5('0x2a')][_0x25b5('0x2e')]));_0x1f01ef[_0x25b5('0x2d')]=_0x1f01ef['attributes'][_0x25b5('0x2f')]?_0x1f01ef[_0x25b5('0x2d')]:_0x5c3c5e[_0x25b5('0x2c')];if(!_0x3026cb[_0x25b5('0x2a')][_0x25b5('0x30')](_0x25b5('0x31'))){_0x1f01ef[_0x25b5('0x32')]=qs['limit'](_0x3026cb[_0x25b5('0x2a')]['limit']);_0x1f01ef[_0x25b5('0x18')]=qs[_0x25b5('0x18')](_0x3026cb[_0x25b5('0x2a')][_0x25b5('0x18')]);}_0x1f01ef['order']=qs[_0x25b5('0x33')](_0x3026cb[_0x25b5('0x2a')]['sort']);_0x1f01ef[_0x25b5('0x34')]=qs['filters'](_['pick'](_0x3026cb[_0x25b5('0x2a')],_0x5c3c5e[_0x25b5('0x35')]));if(_0x3026cb[_0x25b5('0x2a')]['filter']){_0x1f01ef[_0x25b5('0x34')]=_['merge'](_0x1f01ef[_0x25b5('0x34')],{'$or':_[_0x25b5('0x36')](_0x543928,function(_0x27d438){if(_0x27d438[_0x25b5('0x37')][_0x25b5('0x38')]!==_0x25b5('0x39')){var _0x5a3ce3={};_0x5a3ce3[_0x27d438[_0x25b5('0x3a')]]={'$like':'%'+_0x3026cb['query']['filter']+'%'};return _0x5a3ce3;}})});}_0x1f01ef=_[_0x25b5('0x3b')]({},_0x1f01ef,_0x3026cb[_0x25b5('0x3c')]);var _0x124cc8={'where':_0x1f01ef[_0x25b5('0x34')]};return db['AnalyticCustomReport'][_0x25b5('0x17')](_0x124cc8)[_0x25b5('0x1f')](function(_0x120048){_0x557822['count']=_0x120048;if(_0x3026cb[_0x25b5('0x2a')][_0x25b5('0x3d')]){_0x1f01ef[_0x25b5('0x3e')]=[{'all':!![]}];}return db[_0x25b5('0x3f')][_0x25b5('0x40')](_0x1f01ef);})[_0x25b5('0x1f')](function(_0x44be3e){_0x557822[_0x25b5('0x41')]=_0x44be3e;return _0x557822;})['then'](respondWithFilteredResult(_0xca3eac,_0x1f01ef))[_0x25b5('0x42')](handleError(_0xca3eac,null));};exports[_0x25b5('0x43')]=function(_0x3dec43,_0x1fb405){var _0x531ac1={'raw':![],'where':{'id':_0x3dec43[_0x25b5('0x44')]['id']}},_0x41da9c={};_0x41da9c['model']=_['keys'](db[_0x25b5('0x3f')][_0x25b5('0x45')]);_0x41da9c['query']=_['keys'](_0x3dec43['query']);_0x41da9c[_0x25b5('0x35')]=_['intersection'](_0x41da9c[_0x25b5('0x2c')],_0x41da9c['query']);_0x531ac1['attributes']=_['intersection'](_0x41da9c[_0x25b5('0x2c')],qs[_0x25b5('0x2e')](_0x3dec43[_0x25b5('0x2a')][_0x25b5('0x2e')]));_0x531ac1['attributes']=_0x531ac1[_0x25b5('0x2d')][_0x25b5('0x2f')]?_0x531ac1[_0x25b5('0x2d')]:_0x41da9c['model'];if(_0x3dec43['query'][_0x25b5('0x3d')]){_0x531ac1[_0x25b5('0x3e')]=[{'all':!![]}];}_0x531ac1=_['merge']({},_0x531ac1,_0x3dec43['options']);return db[_0x25b5('0x3f')]['find'](_0x531ac1)[_0x25b5('0x1f')](handleEntityNotFound(_0x1fb405,null))[_0x25b5('0x1f')](respondWithResult(_0x1fb405,null))['catch'](handleError(_0x1fb405,null));};exports[_0x25b5('0x46')]=function(_0x3d7ca7,_0x53a735){return db[_0x25b5('0x3f')]['create'](_0x3d7ca7[_0x25b5('0x47')],{})[_0x25b5('0x1f')](function(_0x3d6d13){var _0x1bd7f8=_0x3d7ca7['user'][_0x25b5('0x21')]({'plain':!![]});if(!_0x1bd7f8)throw new Error(_0x25b5('0x48'));if(_0x1bd7f8[_0x25b5('0x49')]===_0x25b5('0x4a')){var _0x545af6=_0x3d6d13[_0x25b5('0x21')]({'plain':!![]});var _0x5c5cc1=_0x25b5('0x4b');return db[_0x25b5('0x4c')][_0x25b5('0x4d')]({'where':{'name':_0x5c5cc1,'userProfileId':_0x1bd7f8['userProfileId']},'raw':!![]})['then'](function(_0x3dae12){if(_0x3dae12&&_0x3dae12[_0x25b5('0x4e')]===0x0){return db[_0x25b5('0x23')][_0x25b5('0x46')]({'name':_0x545af6[_0x25b5('0x26')],'resourceId':_0x545af6['id'],'type':_0x25b5('0x22'),'sectionId':_0x3dae12['id']},{})[_0x25b5('0x1f')](function(){return _0x3d6d13;});}else{return _0x3d6d13;}})[_0x25b5('0x42')](function(_0x5341eb){logger[_0x25b5('0x24')](_0x25b5('0x4f'),_0x5341eb);throw _0x5341eb;});}return _0x3d6d13;})['then'](respondWithResult(_0x53a735,0xc9))['catch'](handleError(_0x53a735,null));};exports[_0x25b5('0x1e')]=function(_0x18afed,_0x3a30fc){if(_0x18afed[_0x25b5('0x47')]['id']){delete _0x18afed['body']['id'];}return db[_0x25b5('0x3f')][_0x25b5('0x4d')]({'where':{'id':_0x18afed[_0x25b5('0x44')]['id']}})[_0x25b5('0x1f')](handleEntityNotFound(_0x3a30fc,null))[_0x25b5('0x1f')](saveUpdates(_0x18afed['body'],null))[_0x25b5('0x1f')](respondWithResult(_0x3a30fc,null))['catch'](handleError(_0x3a30fc,null));};exports[_0x25b5('0x20')]=function(_0x553763,_0x51604b){return db['AnalyticCustomReport']['find']({'where':{'id':_0x553763[_0x25b5('0x44')]['id']}})['then'](handleEntityNotFound(_0x51604b,null))[_0x25b5('0x1f')](removeEntity(_0x51604b,null))['catch'](handleError(_0x51604b,null));};exports['preview']=function(_0x522534,_0x248779){var _0x2ab01d=0xa;var _0x4f27fb=['join',_0x25b5('0x50'),'right_join','cross_join'];var _0x2ab59c={'SUM':'SUM(%s)','COUNT':_0x25b5('0x51'),'COUNT DISTINCT':_0x25b5('0x52'),'MAX':_0x25b5('0x53'),'MIN':'MIN(%s)','AVG':'AVG(%s)','GROUP_CONCAT':_0x25b5('0x54'),'GROUP_CONCAT ASC':_0x25b5('0x55'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x1c3a0e={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x25b5('0x56'),'HOUR':_0x25b5('0x57'),'ROUND':_0x25b5('0x58'),'UNIX_TIMESTAMP':_0x25b5('0x59')};var _0x5a0a64=function(_0xc3c381){return!_['includes'](['IS\x20NULL',_0x25b5('0x5a'),_0x25b5('0x5b'),_0x25b5('0x5c')],_0xc3c381);};var _0x1c3744=function(_0x18fd8b){if(!_0x18fd8b||!_0x18fd8b[_0x25b5('0x5d')][_0x25b5('0x2f')]){return'';}for(var _0x14d9a4='(',_0x3608ee=0x0;_0x3608ee<_0x18fd8b[_0x25b5('0x5d')][_0x25b5('0x2f')];_0x3608ee+=0x1){_0x3608ee>0x0&&(_0x14d9a4+='\x20'+_0x18fd8b[_0x25b5('0x5e')]+'\x20');_0x14d9a4+=_0x18fd8b[_0x25b5('0x5d')][_0x3608ee][_0x25b5('0x5f')]?_0x1c3744(_0x18fd8b[_0x25b5('0x5d')][_0x3608ee][_0x25b5('0x5f')]):_0x18fd8b[_0x25b5('0x5d')][_0x3608ee][_0x25b5('0x3a')]+'\x20'+_0x18fd8b[_0x25b5('0x5d')][_0x3608ee][_0x25b5('0x60')]+(_0x5a0a64(_0x18fd8b[_0x25b5('0x5d')][_0x3608ee]['condition'])?'\x20'+_0x18fd8b[_0x25b5('0x5d')][_0x3608ee]['value']:'');}return _0x14d9a4+')';};var _0x549a8c={'where':{'id':_0x522534['params']['id']}},_0x27db7a,_0x55fdb4,_0x5838a1,_0x3c6408,_0x498248;_0x549a8c=_[_0x25b5('0x3b')]({},_0x549a8c,_0x522534[_0x25b5('0x3c')]);return db[_0x25b5('0x3f')][_0x25b5('0x4d')](_0x549a8c)[_0x25b5('0x1f')](function(_0x4a62e3){if(_0x4a62e3){_0x27db7a=_0x4a62e3;return _0x4a62e3[_0x25b5('0x61')]();}return null;})[_0x25b5('0x1f')](function(_0x4f433a){if(_0x4f433a){if(!_0x4f433a[_0x25b5('0x2f')]){throw new db[(_0x25b5('0x62'))]['ValidationErrorItem'](_0x25b5('0x63'),0x193);}_0x55fdb4=_0x4f433a;return db[_0x25b5('0x64')]['findAll']({'raw':!![]});}return null;})[_0x25b5('0x1f')](function(_0x56e47d){if(_0x56e47d){_0x5838a1=_[_0x25b5('0x65')](_0x56e47d,'id');var _0x593dc1;var _0x31fc9c=squel[_0x25b5('0x66')]();_0x31fc9c[_0x25b5('0x67')](_0x27db7a['table']);for(var _0x3fc226=0x0;_0x3fc226<_0x55fdb4[_0x25b5('0x2f')];_0x3fc226+=0x1){_0x593dc1=_0x55fdb4[_0x3fc226][_0x25b5('0x68')]?_0x5838a1[_0x55fdb4[_0x3fc226][_0x25b5('0x68')]][_0x25b5('0x69')]:_0x55fdb4[_0x3fc226][_0x25b5('0x3a')];_0x593dc1=_0x55fdb4[_0x3fc226]['function']?_['replace'](_0x2ab59c[_0x55fdb4[_0x3fc226][_0x25b5('0x6a')]],'%s',_0x593dc1):_0x593dc1;_0x593dc1=_0x55fdb4[_0x3fc226][_0x25b5('0x6b')]?_['replace'](_0x1c3a0e[_0x55fdb4[_0x3fc226][_0x25b5('0x6b')]],'%s',_0x593dc1):_0x593dc1;if(_0x55fdb4[_0x3fc226][_0x25b5('0x6c')]){_0x31fc9c[_0x25b5('0x5f')](_0x593dc1);}_0x55fdb4[_0x3fc226][_0x25b5('0x6d')]&&_0x31fc9c[_0x25b5('0x6e')](_0x593dc1,_0x55fdb4[_0x3fc226]['orderBy']===_0x25b5('0x6f')?![]:!![]);_0x31fc9c[_0x25b5('0x3a')](_0x593dc1,_0x55fdb4[_0x3fc226][_0x25b5('0x70')]||_0x593dc1);}if(_0x27db7a[_0x25b5('0x71')]){_0x27db7a[_0x25b5('0x71')]=JSON[_0x25b5('0x72')](_0x27db7a[_0x25b5('0x71')]);for(var _0x18ba1c=0x0;_0x18ba1c<_0x27db7a[_0x25b5('0x71')]['length'];_0x18ba1c+=0x1){if(_0x27db7a[_0x25b5('0x71')][_0x18ba1c]['type']&&_[_0x25b5('0x73')](_0x4f27fb,_0x27db7a[_0x25b5('0x71')][_0x18ba1c]['type'])&&_0x27db7a[_0x25b5('0x71')][_0x18ba1c][_0x25b5('0x74')]&&_0x27db7a[_0x25b5('0x71')][_0x18ba1c][_0x25b5('0x75')]&&_0x27db7a[_0x25b5('0x71')][_0x18ba1c][_0x25b5('0x76')]){_0x31fc9c[_0x27db7a[_0x25b5('0x71')][_0x18ba1c][_0x25b5('0x37')]](_0x27db7a[_0x25b5('0x71')][_0x18ba1c][_0x25b5('0x75')],null,util[_0x25b5('0x6b')](_0x25b5('0x77'),_0x27db7a[_0x25b5('0x78')],_0x27db7a[_0x25b5('0x71')][_0x18ba1c][_0x25b5('0x74')],_0x27db7a[_0x25b5('0x71')][_0x18ba1c][_0x25b5('0x75')],_0x27db7a[_0x25b5('0x71')][_0x18ba1c][_0x25b5('0x76')]));}}}if(_0x27db7a[_0x25b5('0x79')]){_0x27db7a[_0x25b5('0x79')]=JSON[_0x25b5('0x72')](_0x27db7a['conditions']);_0x31fc9c[_0x25b5('0x34')](_0x1c3744(_0x27db7a[_0x25b5('0x79')][_0x25b5('0x5f')]));}_0x498248=_0x31fc9c[_0x25b5('0x7a')]();_0x31fc9c[_0x25b5('0x32')](_0x2ab01d);_0x31fc9c[_0x25b5('0x18')](0x0);logger[_0x25b5('0x7b')]('Limited\x20Query:',_0x31fc9c['toString']());return db[_0x25b5('0x7c')][_0x25b5('0x2a')](_0x31fc9c[_0x25b5('0x7d')](),{'type':db['sequelize'][_0x25b5('0x7e')][_0x25b5('0x7f')]});}})['then'](respondWithResult(_0x248779,null))[_0x25b5('0x42')](handleError(_0x248779,null));};function runReport(_0x2cc9e2,_0xdae93e,_0x13826f){var _0x45f1c9=_0xdae93e[_0x25b5('0x26')];var _0x35180a=0xa;var _0x393210=[_0x25b5('0x80'),_0x25b5('0x50'),_0x25b5('0x81'),'cross_join'];var _0x5744d7={'SUM':_0x25b5('0x82'),'COUNT':'COUNT(%s)','COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':_0x25b5('0x83'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x25b5('0x55'),'GROUP_CONCAT DESC':_0x25b5('0x84')};var _0x5efe01={'SEC_TO_TIME':_0x25b5('0x85'),'DATE':_0x25b5('0x56'),'HOUR':_0x25b5('0x57'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0xca74d5=function(_0x1f0983){return!_['includes'](['IS\x20NULL',_0x25b5('0x5a'),_0x25b5('0x5b'),_0x25b5('0x5c')],_0x1f0983);};var _0x7e9a2f=function(_0x47f537){if(!_0x47f537||!_0x47f537[_0x25b5('0x5d')]['length']){return'';}for(var _0x23794e='(',_0x3dcd05=0x0;_0x3dcd05<_0x47f537['rules']['length'];_0x3dcd05+=0x1){_0x3dcd05>0x0&&(_0x23794e+='\x20'+_0x47f537[_0x25b5('0x5e')]+'\x20');_0x23794e+=_0x47f537[_0x25b5('0x5d')][_0x3dcd05][_0x25b5('0x5f')]?_0x7e9a2f(_0x47f537[_0x25b5('0x5d')][_0x3dcd05][_0x25b5('0x5f')]):_0x47f537['rules'][_0x3dcd05][_0x25b5('0x3a')]+'\x20'+_0x47f537[_0x25b5('0x5d')][_0x3dcd05][_0x25b5('0x60')]+(_0xca74d5(_0x47f537[_0x25b5('0x5d')][_0x3dcd05][_0x25b5('0x60')])?'\x20'+_0x47f537[_0x25b5('0x5d')][_0x3dcd05][_0x25b5('0x86')]:'');}return _0x23794e+')';};var _0x220ae8={'where':{'id':_0x2cc9e2['id']}},_0x58683c,_0x2cce52,_0x48dc38,_0x6048c8,_0x5deae4;_0x220ae8=_['merge']({},_0x220ae8,_0x13826f);return db[_0x25b5('0x3f')][_0x25b5('0x4d')](_0x220ae8)[_0x25b5('0x1f')](function(_0x45a732){if(_0x45a732){_0x58683c=_0x45a732;return _0x45a732[_0x25b5('0x61')]();}return null;})[_0x25b5('0x1f')](function(_0x20abfa){if(_0x20abfa){if(!_0x20abfa[_0x25b5('0x2f')]){throw new db['Sequelize']['ValidationErrorItem'](_0x25b5('0x63'),0x193);}_0x2cce52=_0x20abfa;return db[_0x25b5('0x64')]['findAll']({'raw':!![]});}return null;})[_0x25b5('0x1f')](function(_0x1789e2){if(_0x1789e2){_0x48dc38=_[_0x25b5('0x65')](_0x1789e2,'id');var _0x32d511;var _0x4d7df6=squel[_0x25b5('0x66')]();_0x4d7df6[_0x25b5('0x67')](_0x58683c[_0x25b5('0x78')]);for(var _0x27f5fb=0x0;_0x27f5fb<_0x2cce52[_0x25b5('0x2f')];_0x27f5fb+=0x1){_0x32d511=_0x2cce52[_0x27f5fb]['MetricId']?_0x48dc38[_0x2cce52[_0x27f5fb]['MetricId']][_0x25b5('0x69')]:_0x2cce52[_0x27f5fb][_0x25b5('0x3a')];_0x32d511=_0x2cce52[_0x27f5fb][_0x25b5('0x6a')]?_[_0x25b5('0x87')](_0x5744d7[_0x2cce52[_0x27f5fb]['function']],'%s',_0x32d511):_0x32d511;_0x32d511=_0x2cce52[_0x27f5fb][_0x25b5('0x6b')]?_['replace'](_0x5efe01[_0x2cce52[_0x27f5fb][_0x25b5('0x6b')]],'%s',_0x32d511):_0x32d511;if(_0x2cce52[_0x27f5fb][_0x25b5('0x6c')]){_0x4d7df6[_0x25b5('0x5f')](_0x32d511);}_0x2cce52[_0x27f5fb][_0x25b5('0x6d')]&&_0x4d7df6[_0x25b5('0x6e')](_0x32d511,_0x2cce52[_0x27f5fb]['orderBy']===_0x25b5('0x6f')?![]:!![]);_0x4d7df6[_0x25b5('0x3a')](_0x32d511,_0x2cce52[_0x27f5fb]['alias']||_0x32d511);}if(_0x58683c[_0x25b5('0x71')]){_0x58683c[_0x25b5('0x71')]=JSON[_0x25b5('0x72')](_0x58683c['joins']);for(var _0x141cbc=0x0;_0x141cbc<_0x58683c['joins'][_0x25b5('0x2f')];_0x141cbc+=0x1){if(_0x58683c[_0x25b5('0x71')][_0x141cbc][_0x25b5('0x37')]&&_[_0x25b5('0x73')](_0x393210,_0x58683c[_0x25b5('0x71')][_0x141cbc][_0x25b5('0x37')])&&_0x58683c[_0x25b5('0x71')][_0x141cbc][_0x25b5('0x74')]&&_0x58683c['joins'][_0x141cbc][_0x25b5('0x75')]&&_0x58683c[_0x25b5('0x71')][_0x141cbc][_0x25b5('0x76')]){_0x4d7df6[_0x58683c[_0x25b5('0x71')][_0x141cbc]['type']](_0x58683c[_0x25b5('0x71')][_0x141cbc][_0x25b5('0x75')],null,util[_0x25b5('0x6b')]('%s.%s\x20=\x20%s.%s',_0x58683c['table'],_0x58683c[_0x25b5('0x71')][_0x141cbc]['parentKey'],_0x58683c[_0x25b5('0x71')][_0x141cbc][_0x25b5('0x75')],_0x58683c['joins'][_0x141cbc]['foreignKey']));}}}if(_0x58683c[_0x25b5('0x79')]){_0x58683c['conditions']=JSON[_0x25b5('0x72')](_0x58683c['conditions']);_0x4d7df6[_0x25b5('0x34')](_0x7e9a2f(_0x58683c[_0x25b5('0x79')][_0x25b5('0x5f')]));}_0x5deae4=_0x4d7df6[_0x25b5('0x7a')]();_0x4d7df6[_0x25b5('0x32')](_0x35180a);_0x4d7df6['offset'](0x0);logger[_0x25b5('0x7b')](_0x25b5('0x88'),_0x4d7df6[_0x25b5('0x7d')]());return db['sequelize'][_0x25b5('0x2a')](_0x4d7df6[_0x25b5('0x7d')](),{'type':db['sequelize'][_0x25b5('0x7e')]['SELECT']});}})['then'](function(_0x2c83b2){if(!_0x2c83b2[_0x25b5('0x2f')]){throw new db[(_0x25b5('0x62'))][(_0x25b5('0x89'))](_0x25b5('0x8a'),0xcc);}if(_0xdae93e[_0x25b5('0x8b')]==='web'){return null;}var _0xfe371f=_[_0x25b5('0x3b')](_0xdae93e,{'name':_0xdae93e[_0x25b5('0x8c')]||_0xdae93e['name']||_0x58683c[_0x25b5('0x26')],'basename':_0x45f1c9,'savename':util['format'](_0x25b5('0x8d'),_0xdae93e['name']||_0x58683c['name'],require(_0x25b5('0x8e'))['generate'](0x4),_0xdae93e[_0x25b5('0x8b')]||'csv'),'reportId':_0x58683c['id'],'reportType':_0x25b5('0x8f')});return db['AnalyticExtractedReport']['create'](_0xfe371f,{'raw':!![]});})[_0x25b5('0x1f')](function(_0x24f034){if(_0x58683c['table']===_0x25b5('0x90')){_0x5deae4[_0x25b5('0x34')](_0x58683c[_0x25b5('0x78')]+_0x25b5('0x91'),_0xdae93e[_0x25b5('0x92')],_0xdae93e[_0x25b5('0x93')]);}else{_0x5deae4['where'](_0x58683c[_0x25b5('0x78')]+_0x25b5('0x94'),_0xdae93e[_0x25b5('0x92')],_0xdae93e[_0x25b5('0x93')]);}if(_0x24f034){logger[_0x25b5('0x95')]('Run\x20Query:',_0x5deae4[_0x25b5('0x7d')]());require('child_process')[_0x25b5('0x96')](path[_0x25b5('0x80')](__dirname,_0x25b5('0x97'),_0x24f034[_0x25b5('0x8b')]),[_0x24f034['id'],_0x5deae4[_0x25b5('0x7d')](),path[_0x25b5('0x80')](__dirname,_0x25b5('0x98'),_0x24f034[_0x25b5('0x99')]),_0x45f1c9]);return _0x24f034;}else{var _0xb60c5=squel[_0x25b5('0x66')]();_0xb60c5[_0x25b5('0x67')]('('+_0x5deae4['toString']()+')',_0x25b5('0x9a'));_0xb60c5[_0x25b5('0x3a')](_0x25b5('0x9b'),_0x25b5('0x17'));_0x5deae4['limit'](_0xdae93e['limit']||_0x35180a);_0x5deae4[_0x25b5('0x18')](_0xdae93e[_0x25b5('0x18')]||0x0);return db[_0x25b5('0x7c')][_0x25b5('0x2a')](_0xb60c5[_0x25b5('0x7d')](),{'type':db[_0x25b5('0x7c')]['QueryTypes']['SELECT']})['then'](function(_0x8efe22){if(!_0x8efe22['length']){_0x6048c8=0x0;}else{_0x6048c8=_0x8efe22[0x0]['count']||0x0;}return db[_0x25b5('0x7c')][_0x25b5('0x2a')](_0x5deae4[_0x25b5('0x7d')](),{'type':db[_0x25b5('0x7c')]['QueryTypes'][_0x25b5('0x7f')]});})['then'](function(_0x12b5bb){return{'rows':_0x12b5bb||[],'count':_0x6048c8};});}});}exports[_0x25b5('0x9c')]=function(_0x242683,_0x1861d5){return runReport(_0x242683[_0x25b5('0x44')],_0x242683[_0x25b5('0x2a')],_0x242683[_0x25b5('0x3c')])['then'](respondWithResult(_0x1861d5,null))[_0x25b5('0x42')](handleError(_0x1861d5,null));};exports['runReport']=runReport;exports['query']=function(_0x56b44d,_0x47009b){var _0x87eed5=0xa;var _0x4aca5a=['join',_0x25b5('0x50'),_0x25b5('0x81'),_0x25b5('0x9d')];var _0x5dcab7={'SUM':_0x25b5('0x82'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x25b5('0x52'),'MAX':_0x25b5('0x53'),'MIN':_0x25b5('0x9e'),'AVG':_0x25b5('0x83'),'GROUP_CONCAT':_0x25b5('0x54'),'GROUP_CONCAT ASC':_0x25b5('0x55'),'GROUP_CONCAT DESC':_0x25b5('0x84')};var _0x4623ce={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':'DATE(%s)','HOUR':_0x25b5('0x57'),'ROUND':_0x25b5('0x58'),'UNIX_TIMESTAMP':_0x25b5('0x59')};var _0xa5730e=function(_0x40187c){return!_[_0x25b5('0x73')]([_0x25b5('0x9f'),_0x25b5('0x5a'),_0x25b5('0x5b'),_0x25b5('0x5c')],_0x40187c);};var _0x5c2799=function(_0x5d4bd5){if(!_0x5d4bd5||!_0x5d4bd5[_0x25b5('0x5d')][_0x25b5('0x2f')]){return'';}for(var _0x55cd1a='(',_0x16e4da=0x0;_0x16e4da<_0x5d4bd5[_0x25b5('0x5d')][_0x25b5('0x2f')];_0x16e4da+=0x1){_0x16e4da>0x0&&(_0x55cd1a+='\x20'+_0x5d4bd5[_0x25b5('0x5e')]+'\x20');_0x55cd1a+=_0x5d4bd5[_0x25b5('0x5d')][_0x16e4da][_0x25b5('0x5f')]?_0x5c2799(_0x5d4bd5[_0x25b5('0x5d')][_0x16e4da]['group']):_0x5d4bd5[_0x25b5('0x5d')][_0x16e4da]['field']+'\x20'+_0x5d4bd5['rules'][_0x16e4da][_0x25b5('0x60')]+(_0xa5730e(_0x5d4bd5[_0x25b5('0x5d')][_0x16e4da][_0x25b5('0x60')])?'\x20'+_0x5d4bd5[_0x25b5('0x5d')][_0x16e4da][_0x25b5('0x86')]:'');}return _0x55cd1a+')';};var _0xf62290={'where':{'id':_0x56b44d['params']['id']}},_0x30ce71,_0xbd3311,_0x278b4d,_0x2820ca,_0x3ab275;_0xf62290=_['merge']({},_0xf62290,_0x56b44d[_0x25b5('0x3c')]);return db['AnalyticCustomReport']['find'](_0xf62290)['then'](function(_0x18747e){if(_0x18747e){_0x30ce71=_0x18747e;return _0x18747e[_0x25b5('0x61')]();}return null;})[_0x25b5('0x1f')](function(_0x3e80c1){if(_0x3e80c1){if(!_0x3e80c1[_0x25b5('0x2f')]){throw new db[(_0x25b5('0x62'))][(_0x25b5('0x89'))](_0x25b5('0x63'),0x193);}_0xbd3311=_0x3e80c1;return db['AnalyticMetric'][_0x25b5('0x40')]({'raw':!![]});}return null;})[_0x25b5('0x1f')](function(_0x482816){if(_0x482816){_0x278b4d=_[_0x25b5('0x65')](_0x482816,'id');var _0xbc88af;var _0xc6a727=squel['select']();_0xc6a727[_0x25b5('0x67')](_0x30ce71[_0x25b5('0x78')]);for(var _0x2e5a72=0x0;_0x2e5a72<_0xbd3311[_0x25b5('0x2f')];_0x2e5a72+=0x1){_0xbc88af=_0xbd3311[_0x2e5a72]['MetricId']?_0x278b4d[_0xbd3311[_0x2e5a72][_0x25b5('0x68')]][_0x25b5('0x69')]:_0xbd3311[_0x2e5a72][_0x25b5('0x3a')];_0xbc88af=_0xbd3311[_0x2e5a72][_0x25b5('0x6a')]?_[_0x25b5('0x87')](_0x5dcab7[_0xbd3311[_0x2e5a72]['function']],'%s',_0xbc88af):_0xbc88af;_0xbc88af=_0xbd3311[_0x2e5a72]['format']?_[_0x25b5('0x87')](_0x4623ce[_0xbd3311[_0x2e5a72][_0x25b5('0x6b')]],'%s',_0xbc88af):_0xbc88af;if(_0xbd3311[_0x2e5a72][_0x25b5('0x6c')]){_0xc6a727[_0x25b5('0x5f')](_0xbc88af);}_0xbd3311[_0x2e5a72][_0x25b5('0x6d')]&&_0xc6a727[_0x25b5('0x6e')](_0xbc88af,_0xbd3311[_0x2e5a72][_0x25b5('0x6d')]===_0x25b5('0x6f')?![]:!![]);_0xc6a727[_0x25b5('0x3a')](_0xbc88af,_0xbd3311[_0x2e5a72][_0x25b5('0x70')]||_0xbc88af);}if(_0x30ce71[_0x25b5('0x71')]){_0x30ce71[_0x25b5('0x71')]=JSON[_0x25b5('0x72')](_0x30ce71[_0x25b5('0x71')]);for(var _0x476a0f=0x0;_0x476a0f<_0x30ce71[_0x25b5('0x71')][_0x25b5('0x2f')];_0x476a0f+=0x1){if(_0x30ce71[_0x25b5('0x71')][_0x476a0f][_0x25b5('0x37')]&&_['includes'](_0x4aca5a,_0x30ce71[_0x25b5('0x71')][_0x476a0f]['type'])&&_0x30ce71['joins'][_0x476a0f][_0x25b5('0x74')]&&_0x30ce71[_0x25b5('0x71')][_0x476a0f][_0x25b5('0x75')]&&_0x30ce71[_0x25b5('0x71')][_0x476a0f]['foreignKey']){_0xc6a727[_0x30ce71[_0x25b5('0x71')][_0x476a0f]['type']](_0x30ce71[_0x25b5('0x71')][_0x476a0f][_0x25b5('0x75')],null,util[_0x25b5('0x6b')](_0x25b5('0x77'),_0x30ce71[_0x25b5('0x78')],_0x30ce71['joins'][_0x476a0f][_0x25b5('0x74')],_0x30ce71[_0x25b5('0x71')][_0x476a0f]['foreignTable'],_0x30ce71['joins'][_0x476a0f]['foreignKey']));}}}if(_0x30ce71[_0x25b5('0x79')]){_0x30ce71[_0x25b5('0x79')]=JSON[_0x25b5('0x72')](_0x30ce71[_0x25b5('0x79')]);_0xc6a727[_0x25b5('0x34')](_0x5c2799(_0x30ce71[_0x25b5('0x79')]['group']));}_0x3ab275=_0xc6a727['clone']();_0xc6a727[_0x25b5('0x32')](_0x87eed5);_0xc6a727[_0x25b5('0x18')](0x0);logger[_0x25b5('0x7b')](_0x25b5('0x88'),_0xc6a727[_0x25b5('0x7d')]());return db[_0x25b5('0x7c')][_0x25b5('0x2a')](_0xc6a727['toString'](),{'type':db[_0x25b5('0x7c')]['QueryTypes']['SELECT']});}})[_0x25b5('0x1f')](function(){return{'sql':_0x3ab275['toString']()};})[_0x25b5('0x1f')](respondWithResult(_0x47009b,null))['catch'](handleError(_0x47009b,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff