// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x0b25=['alias','No\x20available\x20data','output','web','%s-%s.%s','randomstring','generate','csv','custom','AnalyticExtractedReport','cdr','startDate','endDate','info','Run\x20Query:','child_process','fork','../../components/export/','../../files/reports','countTable','COUNT(*)','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','util','sox','to-csv','ejs','lodash','squel','jsforce','desk.js','querystring','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','../../config/environment','../../mysqldb','dbH','sendStatus','status','end','json','offset','set','apply','reject','save','update','then','get','CustomReports','destroy','stack','name','send','map','AnalyticCustomReport','rawAttributes','fieldName','type','key','model','query','filters','intersection','fields','attributes','hasOwnProperty','nolimit','limit','order','sort','pick','where','VIRTUAL','options','count','include','rows','catch','show','keys','length','includeAll','merge','find','user','role','autoAssociation','create','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','params','preview','join','left_join','right_join','cross_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','DATE(%s)','HOUR(%s)','includes','IS\x20NOT\x20EMPTY','rules','group','condition','value','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','select','from','table','MetricId','field','function','replace','format','groupBy','orderBy','DESC','joins','parse','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','parentKey','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','ROUND(%s)','UNIX_TIMESTAMP(%s)','IS\x20NULL','IS\x20EMPTY','operator','findAll','metric'];(function(_0xbf5e16,_0x146ce3){var _0x5975a5=function(_0x2387a7){while(--_0x2387a7){_0xbf5e16['push'](_0xbf5e16['shift']());}};_0x5975a5(++_0x146ce3);}(_0x0b25,0x155));var _0x50b2=function(_0x20fdc1,_0xde1296){_0x20fdc1=_0x20fdc1-0x0;var _0x25397c=_0x0b25[_0x20fdc1];return _0x25397c;};'use strict';var pdf=require(_0x50b2('0x0'));var emlformat=require(_0x50b2('0x1'));var rimraf=require(_0x50b2('0x2'));var zipdir=require(_0x50b2('0x3'));var jsonpatch=require(_0x50b2('0x4'));var rp=require(_0x50b2('0x5'));var moment=require(_0x50b2('0x6'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x50b2('0x7'));var path=require('path');var sox=require(_0x50b2('0x8'));var csv=require(_0x50b2('0x9'));var ejs=require(_0x50b2('0xa'));var fs=require('fs');var _=require(_0x50b2('0xb'));var squel=require(_0x50b2('0xc'));var crypto=require('crypto');var jsforce=require(_0x50b2('0xd'));var deskjs=require(_0x50b2('0xe'));var toCsv=require(_0x50b2('0x9'));var querystring=require(_0x50b2('0xf'));var Papa=require('papaparse');var Redis=require(_0x50b2('0x10'));var authService=require('../../components/auth/service');var qs=require(_0x50b2('0x11'));var as=require(_0x50b2('0x12'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x50b2('0x13'))('api');var utils=require('../../config/utils');var config=require(_0x50b2('0x14'));var db=require(_0x50b2('0x15'))['db'];var dbH=require(_0x50b2('0x15'))[_0x50b2('0x16')];function respondWithStatusCode(_0x3eda73,_0x3ab9e6){_0x3ab9e6=_0x3ab9e6||0xcc;return function(_0x36067a){if(_0x36067a){return _0x3eda73[_0x50b2('0x17')](_0x3ab9e6);}return _0x3eda73[_0x50b2('0x18')](_0x3ab9e6)[_0x50b2('0x19')]();};}function respondWithResult(_0x391255,_0x4d6650){_0x4d6650=_0x4d6650||0xc8;return function(_0x131cf1){if(_0x131cf1){return _0x391255[_0x50b2('0x18')](_0x4d6650)[_0x50b2('0x1a')](_0x131cf1);}};}function respondWithFilteredResult(_0x54cc61,_0x3c3fd6){return function(_0x112d57){if(_0x112d57){var _0x2f0f92=_0x112d57['count'],_0x1a4df6=_0x3c3fd6[_0x50b2('0x1b')],_0x1308dd=_0x3c3fd6[_0x50b2('0x1b')]+_0x3c3fd6['limit'],_0xb95d74;if(_0x1308dd>=_0x2f0f92){_0x1308dd=_0x2f0f92;_0xb95d74=0xc8;}else{_0xb95d74=0xce;}_0x54cc61[_0x50b2('0x18')](_0xb95d74);return _0x54cc61[_0x50b2('0x1c')]('Content-Range',_0x1a4df6+'-'+_0x1308dd+'/'+_0x2f0f92)[_0x50b2('0x1a')](_0x112d57);}return null;};}function patchUpdates(_0x106491){return function(_0x52aaf9){try{jsonpatch[_0x50b2('0x1d')](_0x52aaf9,_0x106491,!![]);}catch(_0x1119c6){return BPromise[_0x50b2('0x1e')](_0x1119c6);}return _0x52aaf9[_0x50b2('0x1f')]();};}function saveUpdates(_0x4b6005,_0x42aef5){return function(_0x41d435){if(_0x41d435){return _0x41d435[_0x50b2('0x20')](_0x4b6005)[_0x50b2('0x21')](function(_0x20d71e){return _0x20d71e;});}return null;};}function removeEntity(_0x459eaf,_0x51f7ae){return function(_0x57c697){if(_0x57c697){return _0x57c697['destroy']()[_0x50b2('0x21')](function(){var _0x34c3cb=_0x57c697[_0x50b2('0x22')]({'plain':!![]});var _0x28e515=_0x50b2('0x23');return db['UserProfileResource'][_0x50b2('0x24')]({'where':{'type':_0x28e515,'resourceId':_0x34c3cb['id']}})[_0x50b2('0x21')](function(){return _0x57c697;});})[_0x50b2('0x21')](function(){_0x459eaf[_0x50b2('0x18')](0xcc)[_0x50b2('0x19')]();});}};}function handleEntityNotFound(_0x412639,_0x21ae06){return function(_0x2a145a){if(!_0x2a145a){_0x412639[_0x50b2('0x17')](0x194);}return _0x2a145a;};}function handleError(_0x8e2403,_0x2d05f5){_0x2d05f5=_0x2d05f5||0x1f4;return function(_0x2c6fff){logger['error'](_0x2c6fff[_0x50b2('0x25')]);if(_0x2c6fff[_0x50b2('0x26')]){delete _0x2c6fff[_0x50b2('0x26')];}_0x8e2403[_0x50b2('0x18')](_0x2d05f5)[_0x50b2('0x27')](_0x2c6fff);};}exports['index']=function(_0x65ecbe,_0x24d967){var _0x1220e3={},_0x2cc4fe={},_0x508693={'count':0x0,'rows':[]};var _0x34309d=_[_0x50b2('0x28')](db[_0x50b2('0x29')][_0x50b2('0x2a')],function(_0x313b33){return{'name':_0x313b33[_0x50b2('0x2b')],'type':_0x313b33[_0x50b2('0x2c')][_0x50b2('0x2d')]};});_0x2cc4fe[_0x50b2('0x2e')]=_[_0x50b2('0x28')](_0x34309d,_0x50b2('0x26'));_0x2cc4fe[_0x50b2('0x2f')]=_['keys'](_0x65ecbe['query']);_0x2cc4fe[_0x50b2('0x30')]=_[_0x50b2('0x31')](_0x2cc4fe[_0x50b2('0x2e')],_0x2cc4fe[_0x50b2('0x2f')]);_0x1220e3['attributes']=_[_0x50b2('0x31')](_0x2cc4fe['model'],qs[_0x50b2('0x32')](_0x65ecbe[_0x50b2('0x2f')][_0x50b2('0x32')]));_0x1220e3['attributes']=_0x1220e3[_0x50b2('0x33')]['length']?_0x1220e3[_0x50b2('0x33')]:_0x2cc4fe[_0x50b2('0x2e')];if(!_0x65ecbe[_0x50b2('0x2f')][_0x50b2('0x34')](_0x50b2('0x35'))){_0x1220e3['limit']=qs[_0x50b2('0x36')](_0x65ecbe[_0x50b2('0x2f')][_0x50b2('0x36')]);_0x1220e3['offset']=qs['offset'](_0x65ecbe[_0x50b2('0x2f')]['offset']);}_0x1220e3[_0x50b2('0x37')]=qs[_0x50b2('0x38')](_0x65ecbe['query'][_0x50b2('0x38')]);_0x1220e3['where']=qs[_0x50b2('0x30')](_[_0x50b2('0x39')](_0x65ecbe[_0x50b2('0x2f')],_0x2cc4fe[_0x50b2('0x30')]),_0x34309d);if(_0x65ecbe[_0x50b2('0x2f')]['filter']){_0x1220e3[_0x50b2('0x3a')]=_['merge'](_0x1220e3['where'],{'$or':_['map'](_0x34309d,function(_0x177e69){if(_0x177e69[_0x50b2('0x2c')]!==_0x50b2('0x3b')){var _0x4dad2f={};_0x4dad2f[_0x177e69[_0x50b2('0x26')]]={'$like':'%'+_0x65ecbe['query']['filter']+'%'};return _0x4dad2f;}})});}_0x1220e3=_['merge']({},_0x1220e3,_0x65ecbe[_0x50b2('0x3c')]);var _0x40207c={'where':_0x1220e3['where']};return db[_0x50b2('0x29')][_0x50b2('0x3d')](_0x40207c)[_0x50b2('0x21')](function(_0x19cc7e){_0x508693['count']=_0x19cc7e;if(_0x65ecbe[_0x50b2('0x2f')]['includeAll']){_0x1220e3[_0x50b2('0x3e')]=[{'all':!![]}];}return db[_0x50b2('0x29')]['findAll'](_0x1220e3);})[_0x50b2('0x21')](function(_0x2e4781){_0x508693[_0x50b2('0x3f')]=_0x2e4781;return _0x508693;})['then'](respondWithFilteredResult(_0x24d967,_0x1220e3))[_0x50b2('0x40')](handleError(_0x24d967,null));};exports[_0x50b2('0x41')]=function(_0x7c5241,_0x3ade1a){var _0x330348={'raw':![],'where':{'id':_0x7c5241['params']['id']}},_0x27725a={};_0x27725a[_0x50b2('0x2e')]=_[_0x50b2('0x42')](db['AnalyticCustomReport'][_0x50b2('0x2a')]);_0x27725a[_0x50b2('0x2f')]=_[_0x50b2('0x42')](_0x7c5241[_0x50b2('0x2f')]);_0x27725a['filters']=_[_0x50b2('0x31')](_0x27725a[_0x50b2('0x2e')],_0x27725a[_0x50b2('0x2f')]);_0x330348[_0x50b2('0x33')]=_[_0x50b2('0x31')](_0x27725a['model'],qs[_0x50b2('0x32')](_0x7c5241[_0x50b2('0x2f')][_0x50b2('0x32')]));_0x330348[_0x50b2('0x33')]=_0x330348[_0x50b2('0x33')][_0x50b2('0x43')]?_0x330348[_0x50b2('0x33')]:_0x27725a[_0x50b2('0x2e')];if(_0x7c5241[_0x50b2('0x2f')][_0x50b2('0x44')]){_0x330348[_0x50b2('0x3e')]=[{'all':!![]}];}_0x330348=_[_0x50b2('0x45')]({},_0x330348,_0x7c5241[_0x50b2('0x3c')]);return db['AnalyticCustomReport'][_0x50b2('0x46')](_0x330348)['then'](handleEntityNotFound(_0x3ade1a,null))[_0x50b2('0x21')](respondWithResult(_0x3ade1a,null))['catch'](handleError(_0x3ade1a,null));};exports['create']=function(_0x3ba565,_0x550778){return db['AnalyticCustomReport']['create'](_0x3ba565['body'],{})['then'](function(_0x4cfa62){var _0x33fa98=_0x3ba565[_0x50b2('0x47')][_0x50b2('0x22')]({'plain':!![]});if(!_0x33fa98)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x33fa98[_0x50b2('0x48')]==='user'){var _0x26c804=_0x4cfa62[_0x50b2('0x22')]({'plain':!![]});var _0x9f7672='Reports';return db['UserProfileSection']['find']({'where':{'name':_0x9f7672,'userProfileId':_0x33fa98['userProfileId']},'raw':!![]})[_0x50b2('0x21')](function(_0x3dcd8d){if(_0x3dcd8d&&_0x3dcd8d[_0x50b2('0x49')]===0x0){return db['UserProfileResource'][_0x50b2('0x4a')]({'name':_0x26c804['name'],'resourceId':_0x26c804['id'],'type':'CustomReports','sectionId':_0x3dcd8d['id']},{})[_0x50b2('0x21')](function(){return _0x4cfa62;});}else{return _0x4cfa62;}})[_0x50b2('0x40')](function(_0x2d4f0e){logger[_0x50b2('0x4b')](_0x50b2('0x4c'),_0x2d4f0e);throw _0x2d4f0e;});}return _0x4cfa62;})[_0x50b2('0x21')](respondWithResult(_0x550778,0xc9))[_0x50b2('0x40')](handleError(_0x550778,null));};exports[_0x50b2('0x20')]=function(_0x34247b,_0x79b436){if(_0x34247b[_0x50b2('0x4d')]['id']){delete _0x34247b['body']['id'];}return db['AnalyticCustomReport'][_0x50b2('0x46')]({'where':{'id':_0x34247b[_0x50b2('0x4e')]['id']}})[_0x50b2('0x21')](handleEntityNotFound(_0x79b436,null))['then'](saveUpdates(_0x34247b[_0x50b2('0x4d')],null))[_0x50b2('0x21')](respondWithResult(_0x79b436,null))[_0x50b2('0x40')](handleError(_0x79b436,null));};exports[_0x50b2('0x24')]=function(_0x4fa58a,_0x5b9b0f){return db[_0x50b2('0x29')][_0x50b2('0x46')]({'where':{'id':_0x4fa58a[_0x50b2('0x4e')]['id']}})[_0x50b2('0x21')](handleEntityNotFound(_0x5b9b0f,null))[_0x50b2('0x21')](removeEntity(_0x5b9b0f,null))[_0x50b2('0x40')](handleError(_0x5b9b0f,null));};exports[_0x50b2('0x4f')]=function(_0x3e81e5,_0xfc6a64){var _0x1c9c2a=0xa;var _0x528cde=[_0x50b2('0x50'),_0x50b2('0x51'),_0x50b2('0x52'),_0x50b2('0x53')];var _0x4cb3d0={'SUM':_0x50b2('0x54'),'COUNT':_0x50b2('0x55'),'COUNT DISTINCT':_0x50b2('0x56'),'MAX':_0x50b2('0x57'),'MIN':_0x50b2('0x58'),'AVG':_0x50b2('0x59'),'GROUP_CONCAT':_0x50b2('0x5a'),'GROUP_CONCAT ASC':_0x50b2('0x5b'),'GROUP_CONCAT DESC':_0x50b2('0x5c')};var _0x21fece={'SEC_TO_TIME':_0x50b2('0x5d'),'DATE':_0x50b2('0x5e'),'HOUR':_0x50b2('0x5f'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x30db39=function(_0x213ffb){return!_[_0x50b2('0x60')](['IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY',_0x50b2('0x61')],_0x213ffb);};var _0x402596=function(_0xe9168e){if(!_0xe9168e||!_0xe9168e[_0x50b2('0x62')]['length']){return'';}for(var _0x250a8f='(',_0x287199=0x0;_0x287199<_0xe9168e['rules']['length'];_0x287199+=0x1){_0x287199>0x0&&(_0x250a8f+='\x20'+_0xe9168e['operator']+'\x20');_0x250a8f+=_0xe9168e[_0x50b2('0x62')][_0x287199][_0x50b2('0x63')]?_0x402596(_0xe9168e[_0x50b2('0x62')][_0x287199][_0x50b2('0x63')]):_0xe9168e[_0x50b2('0x62')][_0x287199]['field']+'\x20'+_0xe9168e['rules'][_0x287199][_0x50b2('0x64')]+(_0x30db39(_0xe9168e['rules'][_0x287199][_0x50b2('0x64')])?'\x20'+_0xe9168e['rules'][_0x287199][_0x50b2('0x65')]:'');}return _0x250a8f+')';};var _0x15a2f9={'where':{'id':_0x3e81e5[_0x50b2('0x4e')]['id']}},_0x3aea36,_0x1c3dbb,_0x288119,_0xf5da02,_0x19f5a7;_0x15a2f9=_[_0x50b2('0x45')]({},_0x15a2f9,_0x3e81e5['options']);return db[_0x50b2('0x29')][_0x50b2('0x46')](_0x15a2f9)[_0x50b2('0x21')](function(_0x43f5d8){if(_0x43f5d8){_0x3aea36=_0x43f5d8;return _0x43f5d8[_0x50b2('0x66')]();}return null;})[_0x50b2('0x21')](function(_0x5bdacf){if(_0x5bdacf){if(!_0x5bdacf[_0x50b2('0x43')]){throw new db[(_0x50b2('0x67'))][(_0x50b2('0x68'))](_0x50b2('0x69'),0x193);}_0x1c3dbb=_0x5bdacf;return db[_0x50b2('0x6a')]['findAll']({'raw':!![]});}return null;})['then'](function(_0x287ac3){if(_0x287ac3){_0x288119=_['keyBy'](_0x287ac3,'id');var _0x3f5214;var _0x36c8b4=squel[_0x50b2('0x6b')]();_0x36c8b4[_0x50b2('0x6c')](_0x3aea36[_0x50b2('0x6d')]);for(var _0x4f9af7=0x0;_0x4f9af7<_0x1c3dbb[_0x50b2('0x43')];_0x4f9af7+=0x1){_0x3f5214=_0x1c3dbb[_0x4f9af7][_0x50b2('0x6e')]?_0x288119[_0x1c3dbb[_0x4f9af7][_0x50b2('0x6e')]]['metric']:_0x1c3dbb[_0x4f9af7][_0x50b2('0x6f')];_0x3f5214=_0x1c3dbb[_0x4f9af7][_0x50b2('0x70')]?_[_0x50b2('0x71')](_0x4cb3d0[_0x1c3dbb[_0x4f9af7][_0x50b2('0x70')]],'%s',_0x3f5214):_0x3f5214;_0x3f5214=_0x1c3dbb[_0x4f9af7]['format']?_[_0x50b2('0x71')](_0x21fece[_0x1c3dbb[_0x4f9af7][_0x50b2('0x72')]],'%s',_0x3f5214):_0x3f5214;if(_0x1c3dbb[_0x4f9af7][_0x50b2('0x73')]){_0x36c8b4[_0x50b2('0x63')](_0x3f5214);}_0x1c3dbb[_0x4f9af7][_0x50b2('0x74')]&&_0x36c8b4[_0x50b2('0x37')](_0x3f5214,_0x1c3dbb[_0x4f9af7][_0x50b2('0x74')]===_0x50b2('0x75')?![]:!![]);_0x36c8b4[_0x50b2('0x6f')](_0x3f5214,_0x1c3dbb[_0x4f9af7]['alias']||_0x3f5214);}if(_0x3aea36[_0x50b2('0x76')]){_0x3aea36[_0x50b2('0x76')]=JSON[_0x50b2('0x77')](_0x3aea36[_0x50b2('0x76')]);for(var _0x469042=0x0;_0x469042<_0x3aea36[_0x50b2('0x76')][_0x50b2('0x43')];_0x469042+=0x1){if(_0x3aea36['joins'][_0x469042]['type']&&_[_0x50b2('0x60')](_0x528cde,_0x3aea36[_0x50b2('0x76')][_0x469042][_0x50b2('0x2c')])&&_0x3aea36[_0x50b2('0x76')][_0x469042]['parentKey']&&_0x3aea36[_0x50b2('0x76')][_0x469042][_0x50b2('0x78')]&&_0x3aea36[_0x50b2('0x76')][_0x469042][_0x50b2('0x79')]){_0x36c8b4[_0x3aea36[_0x50b2('0x76')][_0x469042]['type']](_0x3aea36[_0x50b2('0x76')][_0x469042]['foreignTable'],null,util[_0x50b2('0x72')](_0x50b2('0x7a'),_0x3aea36[_0x50b2('0x6d')],_0x3aea36[_0x50b2('0x76')][_0x469042][_0x50b2('0x7b')],_0x3aea36[_0x50b2('0x76')][_0x469042][_0x50b2('0x78')],_0x3aea36[_0x50b2('0x76')][_0x469042][_0x50b2('0x79')]));}}}if(_0x3aea36[_0x50b2('0x7c')]){_0x3aea36[_0x50b2('0x7c')]=JSON[_0x50b2('0x77')](_0x3aea36['conditions']);_0x36c8b4['where'](_0x402596(_0x3aea36[_0x50b2('0x7c')]['group']));}_0x19f5a7=_0x36c8b4[_0x50b2('0x7d')]();_0x36c8b4[_0x50b2('0x36')](_0x1c9c2a);_0x36c8b4[_0x50b2('0x1b')](0x0);logger[_0x50b2('0x7e')](_0x50b2('0x7f'),_0x36c8b4[_0x50b2('0x80')]());return db[_0x50b2('0x81')][_0x50b2('0x2f')](_0x36c8b4[_0x50b2('0x80')](),{'type':db['sequelize'][_0x50b2('0x82')][_0x50b2('0x83')]});}})[_0x50b2('0x21')](respondWithResult(_0xfc6a64,null))[_0x50b2('0x40')](handleError(_0xfc6a64,null));};function runReport(_0x427415,_0x1694f1,_0x423468){var _0x1cceff=_0x1694f1[_0x50b2('0x26')];var _0x661785=0xa;var _0xe81c02=[_0x50b2('0x50'),'left_join','right_join',_0x50b2('0x53')];var _0x4cf7e7={'SUM':_0x50b2('0x54'),'COUNT':_0x50b2('0x55'),'COUNT DISTINCT':_0x50b2('0x56'),'MAX':_0x50b2('0x57'),'MIN':'MIN(%s)','AVG':_0x50b2('0x59'),'GROUP_CONCAT':_0x50b2('0x5a'),'GROUP_CONCAT ASC':_0x50b2('0x5b'),'GROUP_CONCAT DESC':_0x50b2('0x5c')};var _0x2e8965={'SEC_TO_TIME':_0x50b2('0x5d'),'DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':_0x50b2('0x84'),'UNIX_TIMESTAMP':_0x50b2('0x85')};var _0x350a70=function(_0x1a60f8){return!_[_0x50b2('0x60')]([_0x50b2('0x86'),'IS\x20NOT\x20NULL',_0x50b2('0x87'),'IS\x20NOT\x20EMPTY'],_0x1a60f8);};var _0x382c74=function(_0x5792e7){if(!_0x5792e7||!_0x5792e7[_0x50b2('0x62')]['length']){return'';}for(var _0xfea7b7='(',_0x43910a=0x0;_0x43910a<_0x5792e7[_0x50b2('0x62')][_0x50b2('0x43')];_0x43910a+=0x1){_0x43910a>0x0&&(_0xfea7b7+='\x20'+_0x5792e7[_0x50b2('0x88')]+'\x20');_0xfea7b7+=_0x5792e7[_0x50b2('0x62')][_0x43910a][_0x50b2('0x63')]?_0x382c74(_0x5792e7[_0x50b2('0x62')][_0x43910a][_0x50b2('0x63')]):_0x5792e7[_0x50b2('0x62')][_0x43910a][_0x50b2('0x6f')]+'\x20'+_0x5792e7[_0x50b2('0x62')][_0x43910a][_0x50b2('0x64')]+(_0x350a70(_0x5792e7[_0x50b2('0x62')][_0x43910a][_0x50b2('0x64')])?'\x20'+_0x5792e7[_0x50b2('0x62')][_0x43910a]['value']:'');}return _0xfea7b7+')';};var _0xbe66c6={'where':{'id':_0x427415['id']}},_0x5ee380,_0xcde634,_0x19b392,_0x2698b7,_0x43ec67;_0xbe66c6=_[_0x50b2('0x45')]({},_0xbe66c6,_0x423468);return db['AnalyticCustomReport'][_0x50b2('0x46')](_0xbe66c6)[_0x50b2('0x21')](function(_0x3c06c1){if(_0x3c06c1){_0x5ee380=_0x3c06c1;return _0x3c06c1[_0x50b2('0x66')]();}return null;})[_0x50b2('0x21')](function(_0x50af09){if(_0x50af09){if(!_0x50af09[_0x50b2('0x43')]){throw new db[(_0x50b2('0x67'))][(_0x50b2('0x68'))](_0x50b2('0x69'),0x193);}_0xcde634=_0x50af09;return db[_0x50b2('0x6a')][_0x50b2('0x89')]({'raw':!![]});}return null;})[_0x50b2('0x21')](function(_0x2d72a1){if(_0x2d72a1){_0x19b392=_['keyBy'](_0x2d72a1,'id');var _0x2db0d1;var _0x3895c6=squel[_0x50b2('0x6b')]();_0x3895c6[_0x50b2('0x6c')](_0x5ee380[_0x50b2('0x6d')]);for(var _0x263b94=0x0;_0x263b94<_0xcde634[_0x50b2('0x43')];_0x263b94+=0x1){_0x2db0d1=_0xcde634[_0x263b94][_0x50b2('0x6e')]?_0x19b392[_0xcde634[_0x263b94]['MetricId']][_0x50b2('0x8a')]:_0xcde634[_0x263b94][_0x50b2('0x6f')];_0x2db0d1=_0xcde634[_0x263b94]['function']?_['replace'](_0x4cf7e7[_0xcde634[_0x263b94]['function']],'%s',_0x2db0d1):_0x2db0d1;_0x2db0d1=_0xcde634[_0x263b94][_0x50b2('0x72')]?_[_0x50b2('0x71')](_0x2e8965[_0xcde634[_0x263b94][_0x50b2('0x72')]],'%s',_0x2db0d1):_0x2db0d1;if(_0xcde634[_0x263b94]['groupBy']){_0x3895c6['group'](_0x2db0d1);}_0xcde634[_0x263b94]['orderBy']&&_0x3895c6[_0x50b2('0x37')](_0x2db0d1,_0xcde634[_0x263b94][_0x50b2('0x74')]==='DESC'?![]:!![]);_0x3895c6[_0x50b2('0x6f')](_0x2db0d1,_0xcde634[_0x263b94][_0x50b2('0x8b')]||_0x2db0d1);}if(_0x5ee380[_0x50b2('0x76')]){_0x5ee380[_0x50b2('0x76')]=JSON[_0x50b2('0x77')](_0x5ee380['joins']);for(var _0x5cc987=0x0;_0x5cc987<_0x5ee380[_0x50b2('0x76')][_0x50b2('0x43')];_0x5cc987+=0x1){if(_0x5ee380['joins'][_0x5cc987][_0x50b2('0x2c')]&&_['includes'](_0xe81c02,_0x5ee380[_0x50b2('0x76')][_0x5cc987]['type'])&&_0x5ee380[_0x50b2('0x76')][_0x5cc987][_0x50b2('0x7b')]&&_0x5ee380['joins'][_0x5cc987][_0x50b2('0x78')]&&_0x5ee380[_0x50b2('0x76')][_0x5cc987]['foreignKey']){_0x3895c6[_0x5ee380[_0x50b2('0x76')][_0x5cc987][_0x50b2('0x2c')]](_0x5ee380[_0x50b2('0x76')][_0x5cc987][_0x50b2('0x78')],null,util['format'](_0x50b2('0x7a'),_0x5ee380[_0x50b2('0x6d')],_0x5ee380[_0x50b2('0x76')][_0x5cc987]['parentKey'],_0x5ee380[_0x50b2('0x76')][_0x5cc987][_0x50b2('0x78')],_0x5ee380[_0x50b2('0x76')][_0x5cc987][_0x50b2('0x79')]));}}}if(_0x5ee380[_0x50b2('0x7c')]){_0x5ee380['conditions']=JSON[_0x50b2('0x77')](_0x5ee380[_0x50b2('0x7c')]);_0x3895c6[_0x50b2('0x3a')](_0x382c74(_0x5ee380['conditions']['group']));}_0x43ec67=_0x3895c6[_0x50b2('0x7d')]();_0x3895c6[_0x50b2('0x36')](_0x661785);_0x3895c6[_0x50b2('0x1b')](0x0);logger[_0x50b2('0x7e')](_0x50b2('0x7f'),_0x3895c6[_0x50b2('0x80')]());return db[_0x50b2('0x81')][_0x50b2('0x2f')](_0x3895c6[_0x50b2('0x80')](),{'type':db[_0x50b2('0x81')][_0x50b2('0x82')][_0x50b2('0x83')]});}})[_0x50b2('0x21')](function(_0xde6c9e){if(!_0xde6c9e['length']){throw new db[(_0x50b2('0x67'))][(_0x50b2('0x68'))](_0x50b2('0x8c'),0xcc);}if(_0x1694f1[_0x50b2('0x8d')]===_0x50b2('0x8e')){return null;}var _0x101165=_[_0x50b2('0x45')](_0x1694f1,{'name':_0x1694f1['fullPath']||_0x1694f1[_0x50b2('0x26')]||_0x5ee380['name'],'basename':_0x1cceff,'savename':util['format'](_0x50b2('0x8f'),_0x1694f1[_0x50b2('0x26')]||_0x5ee380[_0x50b2('0x26')],require(_0x50b2('0x90'))[_0x50b2('0x91')](0x4),_0x1694f1[_0x50b2('0x8d')]||_0x50b2('0x92')),'reportId':_0x5ee380['id'],'reportType':_0x50b2('0x93')});return db[_0x50b2('0x94')]['create'](_0x101165,{'raw':!![]});})[_0x50b2('0x21')](function(_0x5da4e0){if(_0x5ee380['table']===_0x50b2('0x95')){_0x43ec67[_0x50b2('0x3a')](_0x5ee380[_0x50b2('0x6d')]+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x1694f1[_0x50b2('0x96')],_0x1694f1[_0x50b2('0x97')]);}else{_0x43ec67[_0x50b2('0x3a')](_0x5ee380['table']+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x1694f1[_0x50b2('0x96')],_0x1694f1[_0x50b2('0x97')]);}if(_0x5da4e0){logger[_0x50b2('0x98')](_0x50b2('0x99'),_0x43ec67['toString']());require(_0x50b2('0x9a'))[_0x50b2('0x9b')](path['join'](__dirname,_0x50b2('0x9c'),_0x5da4e0[_0x50b2('0x8d')]),[_0x5da4e0['id'],_0x43ec67[_0x50b2('0x80')](),path[_0x50b2('0x50')](__dirname,_0x50b2('0x9d'),_0x5da4e0['savename']),_0x1cceff]);return _0x5da4e0;}else{var _0x392e48=squel[_0x50b2('0x6b')]();_0x392e48['from']('('+_0x43ec67['toString']()+')',_0x50b2('0x9e'));_0x392e48[_0x50b2('0x6f')](_0x50b2('0x9f'),_0x50b2('0x3d'));_0x43ec67[_0x50b2('0x36')](_0x1694f1['limit']||_0x661785);_0x43ec67[_0x50b2('0x1b')](_0x1694f1[_0x50b2('0x1b')]||0x0);return dbH['sequelize'][_0x50b2('0x2f')](_0x392e48[_0x50b2('0x80')](),{'type':dbH[_0x50b2('0x81')][_0x50b2('0x82')][_0x50b2('0x83')]})[_0x50b2('0x21')](function(_0x1b4840){if(!_0x1b4840[_0x50b2('0x43')]){_0x2698b7=0x0;}else{_0x2698b7=_0x1b4840[0x0][_0x50b2('0x3d')]||0x0;}return dbH['sequelize'][_0x50b2('0x2f')](_0x43ec67['toString'](),{'type':dbH[_0x50b2('0x81')]['QueryTypes'][_0x50b2('0x83')]});})[_0x50b2('0x21')](function(_0xf46d01){return{'rows':_0xf46d01||[],'count':_0x2698b7};});}});}exports['run']=function(_0x2b708c,_0x580d01){return runReport(_0x2b708c['params'],_0x2b708c['query'],_0x2b708c[_0x50b2('0x3c')])[_0x50b2('0x21')](respondWithResult(_0x580d01,null))[_0x50b2('0x40')](handleError(_0x580d01,null));};exports['runReport']=runReport;exports[_0x50b2('0x2f')]=function(_0x269158,_0x59a8d4){var _0x53edb2=0xa;var _0x4b86cb=[_0x50b2('0x50'),_0x50b2('0x51'),'right_join',_0x50b2('0x53')];var _0x550e94={'SUM':_0x50b2('0x54'),'COUNT':_0x50b2('0x55'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':'MAX(%s)','MIN':_0x50b2('0x58'),'AVG':'AVG(%s)','GROUP_CONCAT':_0x50b2('0x5a'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0x50b2('0x5c')};var _0xa7f172={'SEC_TO_TIME':_0x50b2('0x5d'),'DATE':_0x50b2('0x5e'),'HOUR':_0x50b2('0x5f'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x50b2('0x85')};var _0x419458=function(_0x468ebd){return!_['includes']([_0x50b2('0x86'),'IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY'],_0x468ebd);};var _0x15de59=function(_0x889ace){if(!_0x889ace||!_0x889ace['rules'][_0x50b2('0x43')]){return'';}for(var _0x15403a='(',_0x54a25f=0x0;_0x54a25f<_0x889ace[_0x50b2('0x62')][_0x50b2('0x43')];_0x54a25f+=0x1){_0x54a25f>0x0&&(_0x15403a+='\x20'+_0x889ace[_0x50b2('0x88')]+'\x20');_0x15403a+=_0x889ace['rules'][_0x54a25f]['group']?_0x15de59(_0x889ace[_0x50b2('0x62')][_0x54a25f]['group']):_0x889ace[_0x50b2('0x62')][_0x54a25f]['field']+'\x20'+_0x889ace[_0x50b2('0x62')][_0x54a25f]['condition']+(_0x419458(_0x889ace[_0x50b2('0x62')][_0x54a25f][_0x50b2('0x64')])?'\x20'+_0x889ace[_0x50b2('0x62')][_0x54a25f]['value']:'');}return _0x15403a+')';};var _0x519dfd={'where':{'id':_0x269158['params']['id']}},_0x4ca044,_0xa9de7,_0x29722e,_0xadd2d8,_0x5d4630;_0x519dfd=_[_0x50b2('0x45')]({},_0x519dfd,_0x269158[_0x50b2('0x3c')]);return db[_0x50b2('0x29')][_0x50b2('0x46')](_0x519dfd)[_0x50b2('0x21')](function(_0xa441b){if(_0xa441b){_0x4ca044=_0xa441b;return _0xa441b[_0x50b2('0x66')]();}return null;})[_0x50b2('0x21')](function(_0x4b9d29){if(_0x4b9d29){if(!_0x4b9d29[_0x50b2('0x43')]){throw new db[(_0x50b2('0x67'))]['ValidationErrorItem']('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0xa9de7=_0x4b9d29;return db[_0x50b2('0x6a')][_0x50b2('0x89')]({'raw':!![]});}return null;})[_0x50b2('0x21')](function(_0x51d28c){if(_0x51d28c){_0x29722e=_['keyBy'](_0x51d28c,'id');var _0x44303f;var _0x18c3e9=squel[_0x50b2('0x6b')]();_0x18c3e9['from'](_0x4ca044['table']);for(var _0x2a1f8d=0x0;_0x2a1f8d<_0xa9de7[_0x50b2('0x43')];_0x2a1f8d+=0x1){_0x44303f=_0xa9de7[_0x2a1f8d][_0x50b2('0x6e')]?_0x29722e[_0xa9de7[_0x2a1f8d][_0x50b2('0x6e')]]['metric']:_0xa9de7[_0x2a1f8d][_0x50b2('0x6f')];_0x44303f=_0xa9de7[_0x2a1f8d][_0x50b2('0x70')]?_[_0x50b2('0x71')](_0x550e94[_0xa9de7[_0x2a1f8d][_0x50b2('0x70')]],'%s',_0x44303f):_0x44303f;_0x44303f=_0xa9de7[_0x2a1f8d][_0x50b2('0x72')]?_[_0x50b2('0x71')](_0xa7f172[_0xa9de7[_0x2a1f8d][_0x50b2('0x72')]],'%s',_0x44303f):_0x44303f;if(_0xa9de7[_0x2a1f8d][_0x50b2('0x73')]){_0x18c3e9[_0x50b2('0x63')](_0x44303f);}_0xa9de7[_0x2a1f8d][_0x50b2('0x74')]&&_0x18c3e9[_0x50b2('0x37')](_0x44303f,_0xa9de7[_0x2a1f8d]['orderBy']===_0x50b2('0x75')?![]:!![]);_0x18c3e9['field'](_0x44303f,_0xa9de7[_0x2a1f8d][_0x50b2('0x8b')]||_0x44303f);}if(_0x4ca044[_0x50b2('0x76')]){_0x4ca044[_0x50b2('0x76')]=JSON['parse'](_0x4ca044['joins']);for(var _0x5a525e=0x0;_0x5a525e<_0x4ca044[_0x50b2('0x76')]['length'];_0x5a525e+=0x1){if(_0x4ca044['joins'][_0x5a525e][_0x50b2('0x2c')]&&_[_0x50b2('0x60')](_0x4b86cb,_0x4ca044[_0x50b2('0x76')][_0x5a525e][_0x50b2('0x2c')])&&_0x4ca044[_0x50b2('0x76')][_0x5a525e][_0x50b2('0x7b')]&&_0x4ca044[_0x50b2('0x76')][_0x5a525e]['foreignTable']&&_0x4ca044[_0x50b2('0x76')][_0x5a525e][_0x50b2('0x79')]){_0x18c3e9[_0x4ca044[_0x50b2('0x76')][_0x5a525e][_0x50b2('0x2c')]](_0x4ca044[_0x50b2('0x76')][_0x5a525e]['foreignTable'],null,util[_0x50b2('0x72')](_0x50b2('0x7a'),_0x4ca044[_0x50b2('0x6d')],_0x4ca044[_0x50b2('0x76')][_0x5a525e]['parentKey'],_0x4ca044['joins'][_0x5a525e][_0x50b2('0x78')],_0x4ca044[_0x50b2('0x76')][_0x5a525e][_0x50b2('0x79')]));}}}if(_0x4ca044[_0x50b2('0x7c')]){_0x4ca044[_0x50b2('0x7c')]=JSON[_0x50b2('0x77')](_0x4ca044[_0x50b2('0x7c')]);_0x18c3e9['where'](_0x15de59(_0x4ca044[_0x50b2('0x7c')]['group']));}_0x5d4630=_0x18c3e9['clone']();_0x18c3e9[_0x50b2('0x36')](_0x53edb2);_0x18c3e9['offset'](0x0);logger[_0x50b2('0x7e')](_0x50b2('0x7f'),_0x18c3e9['toString']());return db[_0x50b2('0x81')][_0x50b2('0x2f')](_0x18c3e9[_0x50b2('0x80')](),{'type':db['sequelize'][_0x50b2('0x82')][_0x50b2('0x83')]});}})[_0x50b2('0x21')](function(){return{'sql':_0x5d4630[_0x50b2('0x80')]()};})[_0x50b2('0x21')](respondWithResult(_0x59a8d4,null))['catch'](handleError(_0x59a8d4,null));};
\ No newline at end of file
+var _0x6822=['rules','operator','group','field','condition','value','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','keyBy','select','from','MetricId','metric','replace','format','groupBy','orderBy','DESC','joins','parse','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','table','conditions','debug','Limited\x20Query:','toString','sequelize','join','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','DATE(%s)','IS\x20EMPTY','IS\x20NOT\x20EMPTY','getFields','AnalyticMetric','function','alias','QueryTypes','SELECT','No\x20available\x20data','output','web','fullPath','%s-%s.%s','randomstring','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','endDate','startDate','Run\x20Query:','child_process','fork','../../components/export/','../../files/reports','savename','COUNT(*)','runReport','IS\x20NOT\x20NULL','clone','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','dbH','sendStatus','status','end','json','offset','limit','set','Content-Range','apply','reject','save','update','then','destroy','get','CustomReports','error','stack','name','send','map','AnalyticCustomReport','rawAttributes','fieldName','type','key','model','query','keys','filters','attributes','intersection','fields','hasOwnProperty','nolimit','order','sort','where','pick','filter','VIRTUAL','merge','options','count','include','findAll','rows','catch','show','length','includeAll','create','body','user','role','find','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','preview','left_join','right_join','cross_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','SEC_TO_TIME(%s)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL'];(function(_0x3cc6df,_0x23e15b){var _0x53a5bb=function(_0x197f96){while(--_0x197f96){_0x3cc6df['push'](_0x3cc6df['shift']());}};_0x53a5bb(++_0x23e15b);}(_0x6822,0x18c));var _0x2682=function(_0x27aad0,_0x639ce7){_0x27aad0=_0x27aad0-0x0;var _0x4d9ace=_0x6822[_0x27aad0];return _0x4d9ace;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x2682('0x0'));var rimraf=require(_0x2682('0x1'));var zipdir=require(_0x2682('0x2'));var jsonpatch=require(_0x2682('0x3'));var rp=require('request-promise');var moment=require(_0x2682('0x4'));var BPromise=require(_0x2682('0x5'));var Mustache=require(_0x2682('0x6'));var util=require(_0x2682('0x7'));var path=require(_0x2682('0x8'));var sox=require(_0x2682('0x9'));var csv=require(_0x2682('0xa'));var ejs=require(_0x2682('0xb'));var fs=require('fs');var _=require(_0x2682('0xc'));var squel=require(_0x2682('0xd'));var crypto=require(_0x2682('0xe'));var jsforce=require(_0x2682('0xf'));var deskjs=require(_0x2682('0x10'));var toCsv=require(_0x2682('0xa'));var querystring=require('querystring');var Papa=require(_0x2682('0x11'));var Redis=require(_0x2682('0x12'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x2682('0x13'));var logger=require(_0x2682('0x14'))('api');var utils=require(_0x2682('0x15'));var config=require(_0x2682('0x16'));var db=require('../../mysqldb')['db'];var dbH=require(_0x2682('0x17'))[_0x2682('0x18')];function respondWithStatusCode(_0x1feca6,_0x2cd01f){_0x2cd01f=_0x2cd01f||0xcc;return function(_0x3227f9){if(_0x3227f9){return _0x1feca6[_0x2682('0x19')](_0x2cd01f);}return _0x1feca6[_0x2682('0x1a')](_0x2cd01f)[_0x2682('0x1b')]();};}function respondWithResult(_0xfb9e0c,_0x18dab9){_0x18dab9=_0x18dab9||0xc8;return function(_0x4a7e21){if(_0x4a7e21){return _0xfb9e0c[_0x2682('0x1a')](_0x18dab9)[_0x2682('0x1c')](_0x4a7e21);}};}function respondWithFilteredResult(_0x1ac17b,_0x212aaf){return function(_0x545ba8){if(_0x545ba8){var _0x52a80d=_0x545ba8['count'],_0x2ce295=_0x212aaf[_0x2682('0x1d')],_0x2b1ed2=_0x212aaf['offset']+_0x212aaf[_0x2682('0x1e')],_0x602eec;if(_0x2b1ed2>=_0x52a80d){_0x2b1ed2=_0x52a80d;_0x602eec=0xc8;}else{_0x602eec=0xce;}_0x1ac17b[_0x2682('0x1a')](_0x602eec);return _0x1ac17b[_0x2682('0x1f')](_0x2682('0x20'),_0x2ce295+'-'+_0x2b1ed2+'/'+_0x52a80d)[_0x2682('0x1c')](_0x545ba8);}return null;};}function patchUpdates(_0x34cf1d){return function(_0x554b57){try{jsonpatch[_0x2682('0x21')](_0x554b57,_0x34cf1d,!![]);}catch(_0x516525){return BPromise[_0x2682('0x22')](_0x516525);}return _0x554b57[_0x2682('0x23')]();};}function saveUpdates(_0x348924,_0x20ae5b){return function(_0x23641e){if(_0x23641e){return _0x23641e[_0x2682('0x24')](_0x348924)[_0x2682('0x25')](function(_0x49c98a){return _0x49c98a;});}return null;};}function removeEntity(_0x57ae26,_0x599726){return function(_0x3ed75d){if(_0x3ed75d){return _0x3ed75d[_0x2682('0x26')]()['then'](function(){var _0xa27b38=_0x3ed75d[_0x2682('0x27')]({'plain':!![]});var _0x2b2d81=_0x2682('0x28');return db['UserProfileResource'][_0x2682('0x26')]({'where':{'type':_0x2b2d81,'resourceId':_0xa27b38['id']}})[_0x2682('0x25')](function(){return _0x3ed75d;});})[_0x2682('0x25')](function(){_0x57ae26[_0x2682('0x1a')](0xcc)[_0x2682('0x1b')]();});}};}function handleEntityNotFound(_0x2accf0,_0x5d325b){return function(_0x4afd1d){if(!_0x4afd1d){_0x2accf0['sendStatus'](0x194);}return _0x4afd1d;};}function handleError(_0x576352,_0x273201){_0x273201=_0x273201||0x1f4;return function(_0x385c1c){logger[_0x2682('0x29')](_0x385c1c[_0x2682('0x2a')]);if(_0x385c1c[_0x2682('0x2b')]){delete _0x385c1c[_0x2682('0x2b')];}_0x576352[_0x2682('0x1a')](_0x273201)[_0x2682('0x2c')](_0x385c1c);};}exports['index']=function(_0x9384b5,_0x8b809b){var _0x545543={},_0x19bb3d={},_0x193df4={'count':0x0,'rows':[]};var _0x3b5fcd=_[_0x2682('0x2d')](db[_0x2682('0x2e')][_0x2682('0x2f')],function(_0x3a417f){return{'name':_0x3a417f[_0x2682('0x30')],'type':_0x3a417f[_0x2682('0x31')][_0x2682('0x32')]};});_0x19bb3d[_0x2682('0x33')]=_['map'](_0x3b5fcd,_0x2682('0x2b'));_0x19bb3d[_0x2682('0x34')]=_[_0x2682('0x35')](_0x9384b5[_0x2682('0x34')]);_0x19bb3d[_0x2682('0x36')]=_['intersection'](_0x19bb3d['model'],_0x19bb3d[_0x2682('0x34')]);_0x545543[_0x2682('0x37')]=_[_0x2682('0x38')](_0x19bb3d['model'],qs[_0x2682('0x39')](_0x9384b5[_0x2682('0x34')][_0x2682('0x39')]));_0x545543[_0x2682('0x37')]=_0x545543['attributes']['length']?_0x545543[_0x2682('0x37')]:_0x19bb3d['model'];if(!_0x9384b5[_0x2682('0x34')][_0x2682('0x3a')](_0x2682('0x3b'))){_0x545543[_0x2682('0x1e')]=qs[_0x2682('0x1e')](_0x9384b5[_0x2682('0x34')]['limit']);_0x545543['offset']=qs[_0x2682('0x1d')](_0x9384b5['query'][_0x2682('0x1d')]);}_0x545543[_0x2682('0x3c')]=qs[_0x2682('0x3d')](_0x9384b5[_0x2682('0x34')][_0x2682('0x3d')]);_0x545543[_0x2682('0x3e')]=qs[_0x2682('0x36')](_[_0x2682('0x3f')](_0x9384b5[_0x2682('0x34')],_0x19bb3d[_0x2682('0x36')]),_0x3b5fcd);if(_0x9384b5['query'][_0x2682('0x40')]){_0x545543['where']=_['merge'](_0x545543[_0x2682('0x3e')],{'$or':_[_0x2682('0x2d')](_0x3b5fcd,function(_0x3ea618){if(_0x3ea618[_0x2682('0x31')]!==_0x2682('0x41')){var _0x92192d={};_0x92192d[_0x3ea618['name']]={'$like':'%'+_0x9384b5[_0x2682('0x34')][_0x2682('0x40')]+'%'};return _0x92192d;}})});}_0x545543=_[_0x2682('0x42')]({},_0x545543,_0x9384b5[_0x2682('0x43')]);var _0x142ee2={'where':_0x545543['where']};return db[_0x2682('0x2e')]['count'](_0x142ee2)[_0x2682('0x25')](function(_0x4e5175){_0x193df4[_0x2682('0x44')]=_0x4e5175;if(_0x9384b5[_0x2682('0x34')]['includeAll']){_0x545543[_0x2682('0x45')]=[{'all':!![]}];}return db[_0x2682('0x2e')][_0x2682('0x46')](_0x545543);})[_0x2682('0x25')](function(_0x1c1c32){_0x193df4[_0x2682('0x47')]=_0x1c1c32;return _0x193df4;})[_0x2682('0x25')](respondWithFilteredResult(_0x8b809b,_0x545543))[_0x2682('0x48')](handleError(_0x8b809b,null));};exports[_0x2682('0x49')]=function(_0x16ba45,_0x2fec5e){var _0x1b4161={'raw':![],'where':{'id':_0x16ba45['params']['id']}},_0x579687={};_0x579687[_0x2682('0x33')]=_[_0x2682('0x35')](db[_0x2682('0x2e')][_0x2682('0x2f')]);_0x579687[_0x2682('0x34')]=_[_0x2682('0x35')](_0x16ba45[_0x2682('0x34')]);_0x579687['filters']=_['intersection'](_0x579687[_0x2682('0x33')],_0x579687[_0x2682('0x34')]);_0x1b4161[_0x2682('0x37')]=_[_0x2682('0x38')](_0x579687[_0x2682('0x33')],qs['fields'](_0x16ba45['query'][_0x2682('0x39')]));_0x1b4161[_0x2682('0x37')]=_0x1b4161[_0x2682('0x37')][_0x2682('0x4a')]?_0x1b4161[_0x2682('0x37')]:_0x579687[_0x2682('0x33')];if(_0x16ba45[_0x2682('0x34')][_0x2682('0x4b')]){_0x1b4161[_0x2682('0x45')]=[{'all':!![]}];}_0x1b4161=_['merge']({},_0x1b4161,_0x16ba45[_0x2682('0x43')]);return db['AnalyticCustomReport']['find'](_0x1b4161)[_0x2682('0x25')](handleEntityNotFound(_0x2fec5e,null))[_0x2682('0x25')](respondWithResult(_0x2fec5e,null))['catch'](handleError(_0x2fec5e,null));};exports['create']=function(_0x2836b1,_0xd525e2){return db[_0x2682('0x2e')][_0x2682('0x4c')](_0x2836b1[_0x2682('0x4d')],{})[_0x2682('0x25')](function(_0x28805b){var _0x30b9fc=_0x2836b1[_0x2682('0x4e')][_0x2682('0x27')]({'plain':!![]});if(!_0x30b9fc)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x30b9fc[_0x2682('0x4f')]===_0x2682('0x4e')){var _0x5bcf84=_0x28805b[_0x2682('0x27')]({'plain':!![]});var _0x608a0f='Reports';return db['UserProfileSection'][_0x2682('0x50')]({'where':{'name':_0x608a0f,'userProfileId':_0x30b9fc[_0x2682('0x51')]},'raw':!![]})[_0x2682('0x25')](function(_0x4412f8){if(_0x4412f8&&_0x4412f8[_0x2682('0x52')]===0x0){return db['UserProfileResource']['create']({'name':_0x5bcf84[_0x2682('0x2b')],'resourceId':_0x5bcf84['id'],'type':_0x2682('0x28'),'sectionId':_0x4412f8['id']},{})[_0x2682('0x25')](function(){return _0x28805b;});}else{return _0x28805b;}})['catch'](function(_0x7e2a88){logger['error'](_0x2682('0x53'),_0x7e2a88);throw _0x7e2a88;});}return _0x28805b;})[_0x2682('0x25')](respondWithResult(_0xd525e2,0xc9))['catch'](handleError(_0xd525e2,null));};exports[_0x2682('0x24')]=function(_0x11f5f0,_0x21874b){if(_0x11f5f0[_0x2682('0x4d')]['id']){delete _0x11f5f0[_0x2682('0x4d')]['id'];}return db[_0x2682('0x2e')]['find']({'where':{'id':_0x11f5f0['params']['id']}})[_0x2682('0x25')](handleEntityNotFound(_0x21874b,null))['then'](saveUpdates(_0x11f5f0[_0x2682('0x4d')],null))[_0x2682('0x25')](respondWithResult(_0x21874b,null))[_0x2682('0x48')](handleError(_0x21874b,null));};exports['destroy']=function(_0x22f051,_0x5758aa){return db[_0x2682('0x2e')][_0x2682('0x50')]({'where':{'id':_0x22f051[_0x2682('0x54')]['id']}})[_0x2682('0x25')](handleEntityNotFound(_0x5758aa,null))[_0x2682('0x25')](removeEntity(_0x5758aa,null))[_0x2682('0x48')](handleError(_0x5758aa,null));};exports[_0x2682('0x55')]=function(_0x4f0d54,_0x5e71b4){var _0x5a2442=0xa;var _0x524e5b=['join',_0x2682('0x56'),_0x2682('0x57'),_0x2682('0x58')];var _0x24ac62={'SUM':_0x2682('0x59'),'COUNT':_0x2682('0x5a'),'COUNT DISTINCT':_0x2682('0x5b'),'MAX':_0x2682('0x5c'),'MIN':_0x2682('0x5d'),'AVG':_0x2682('0x5e'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x2682('0x5f'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x22c4ac={'SEC_TO_TIME':_0x2682('0x60'),'DATE':'DATE(%s)','HOUR':_0x2682('0x61'),'ROUND':_0x2682('0x62'),'UNIX_TIMESTAMP':_0x2682('0x63')};var _0x52e6ca=function(_0x479326){return!_[_0x2682('0x64')]([_0x2682('0x65'),'IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY'],_0x479326);};var _0x4f7f20=function(_0x372ada){if(!_0x372ada||!_0x372ada[_0x2682('0x66')][_0x2682('0x4a')]){return'';}for(var _0x3aa9dd='(',_0x1f2bb2=0x0;_0x1f2bb2<_0x372ada[_0x2682('0x66')][_0x2682('0x4a')];_0x1f2bb2+=0x1){_0x1f2bb2>0x0&&(_0x3aa9dd+='\x20'+_0x372ada[_0x2682('0x67')]+'\x20');_0x3aa9dd+=_0x372ada[_0x2682('0x66')][_0x1f2bb2][_0x2682('0x68')]?_0x4f7f20(_0x372ada['rules'][_0x1f2bb2][_0x2682('0x68')]):_0x372ada[_0x2682('0x66')][_0x1f2bb2][_0x2682('0x69')]+'\x20'+_0x372ada[_0x2682('0x66')][_0x1f2bb2][_0x2682('0x6a')]+(_0x52e6ca(_0x372ada[_0x2682('0x66')][_0x1f2bb2]['condition'])?'\x20'+_0x372ada[_0x2682('0x66')][_0x1f2bb2][_0x2682('0x6b')]:'');}return _0x3aa9dd+')';};var _0x44a1e3={'where':{'id':_0x4f0d54[_0x2682('0x54')]['id']}},_0x45fdd4,_0x52e3cd,_0x57c9d1,_0x572b44,_0x3fe0f2;_0x44a1e3=_[_0x2682('0x42')]({},_0x44a1e3,_0x4f0d54[_0x2682('0x43')]);return db['AnalyticCustomReport']['find'](_0x44a1e3)[_0x2682('0x25')](function(_0x555ae9){if(_0x555ae9){_0x45fdd4=_0x555ae9;return _0x555ae9['getFields']();}return null;})['then'](function(_0x31f796){if(_0x31f796){if(!_0x31f796[_0x2682('0x4a')]){throw new db[(_0x2682('0x6c'))][(_0x2682('0x6d'))](_0x2682('0x6e'),0x193);}_0x52e3cd=_0x31f796;return db['AnalyticMetric'][_0x2682('0x46')]({'raw':!![]});}return null;})[_0x2682('0x25')](function(_0x3296ed){if(_0x3296ed){_0x57c9d1=_[_0x2682('0x6f')](_0x3296ed,'id');var _0x39e730;var _0x488c33=squel[_0x2682('0x70')]();_0x488c33[_0x2682('0x71')](_0x45fdd4['table']);for(var _0x3ebabe=0x0;_0x3ebabe<_0x52e3cd[_0x2682('0x4a')];_0x3ebabe+=0x1){_0x39e730=_0x52e3cd[_0x3ebabe]['MetricId']?_0x57c9d1[_0x52e3cd[_0x3ebabe][_0x2682('0x72')]][_0x2682('0x73')]:_0x52e3cd[_0x3ebabe][_0x2682('0x69')];_0x39e730=_0x52e3cd[_0x3ebabe]['function']?_[_0x2682('0x74')](_0x24ac62[_0x52e3cd[_0x3ebabe]['function']],'%s',_0x39e730):_0x39e730;_0x39e730=_0x52e3cd[_0x3ebabe]['format']?_['replace'](_0x22c4ac[_0x52e3cd[_0x3ebabe][_0x2682('0x75')]],'%s',_0x39e730):_0x39e730;if(_0x52e3cd[_0x3ebabe][_0x2682('0x76')]){_0x488c33['group'](_0x39e730);}_0x52e3cd[_0x3ebabe]['orderBy']&&_0x488c33[_0x2682('0x3c')](_0x39e730,_0x52e3cd[_0x3ebabe][_0x2682('0x77')]===_0x2682('0x78')?![]:!![]);_0x488c33['field'](_0x39e730,_0x52e3cd[_0x3ebabe]['alias']||_0x39e730);}if(_0x45fdd4[_0x2682('0x79')]){_0x45fdd4[_0x2682('0x79')]=JSON[_0x2682('0x7a')](_0x45fdd4['joins']);for(var _0x246d2a=0x0;_0x246d2a<_0x45fdd4[_0x2682('0x79')][_0x2682('0x4a')];_0x246d2a+=0x1){if(_0x45fdd4['joins'][_0x246d2a]['type']&&_['includes'](_0x524e5b,_0x45fdd4[_0x2682('0x79')][_0x246d2a]['type'])&&_0x45fdd4[_0x2682('0x79')][_0x246d2a][_0x2682('0x7b')]&&_0x45fdd4[_0x2682('0x79')][_0x246d2a][_0x2682('0x7c')]&&_0x45fdd4[_0x2682('0x79')][_0x246d2a][_0x2682('0x7d')]){_0x488c33[_0x45fdd4[_0x2682('0x79')][_0x246d2a][_0x2682('0x31')]](_0x45fdd4['joins'][_0x246d2a][_0x2682('0x7c')],null,util[_0x2682('0x75')](_0x2682('0x7e'),_0x45fdd4[_0x2682('0x7f')],_0x45fdd4['joins'][_0x246d2a]['parentKey'],_0x45fdd4[_0x2682('0x79')][_0x246d2a][_0x2682('0x7c')],_0x45fdd4[_0x2682('0x79')][_0x246d2a]['foreignKey']));}}}if(_0x45fdd4['conditions']){_0x45fdd4[_0x2682('0x80')]=JSON['parse'](_0x45fdd4[_0x2682('0x80')]);_0x488c33[_0x2682('0x3e')](_0x4f7f20(_0x45fdd4['conditions'][_0x2682('0x68')]));}_0x3fe0f2=_0x488c33['clone']();_0x488c33[_0x2682('0x1e')](_0x5a2442);_0x488c33[_0x2682('0x1d')](0x0);logger[_0x2682('0x81')](_0x2682('0x82'),_0x488c33[_0x2682('0x83')]());return db[_0x2682('0x84')][_0x2682('0x34')](_0x488c33[_0x2682('0x83')](),{'type':db[_0x2682('0x84')]['QueryTypes']['SELECT']});}})[_0x2682('0x25')](respondWithResult(_0x5e71b4,null))[_0x2682('0x48')](handleError(_0x5e71b4,null));};function runReport(_0x1c1207,_0x3632c9,_0x421f1b){var _0x432c4c=_0x3632c9[_0x2682('0x2b')];var _0x50aad9=0xa;var _0x2598d7=[_0x2682('0x85'),'left_join',_0x2682('0x57'),_0x2682('0x58')];var _0xcf8e25={'SUM':_0x2682('0x59'),'COUNT':_0x2682('0x5a'),'COUNT DISTINCT':_0x2682('0x5b'),'MAX':_0x2682('0x5c'),'MIN':'MIN(%s)','AVG':_0x2682('0x5e'),'GROUP_CONCAT':_0x2682('0x86'),'GROUP_CONCAT ASC':_0x2682('0x5f'),'GROUP_CONCAT DESC':_0x2682('0x87')};var _0x100c0c={'SEC_TO_TIME':_0x2682('0x60'),'DATE':_0x2682('0x88'),'HOUR':'HOUR(%s)','ROUND':_0x2682('0x62'),'UNIX_TIMESTAMP':_0x2682('0x63')};var _0x25343d=function(_0x9fefff){return!_['includes']([_0x2682('0x65'),'IS\x20NOT\x20NULL',_0x2682('0x89'),_0x2682('0x8a')],_0x9fefff);};var _0x1fb763=function(_0x1c3ca7){if(!_0x1c3ca7||!_0x1c3ca7[_0x2682('0x66')][_0x2682('0x4a')]){return'';}for(var _0x487079='(',_0xd465be=0x0;_0xd465be<_0x1c3ca7[_0x2682('0x66')]['length'];_0xd465be+=0x1){_0xd465be>0x0&&(_0x487079+='\x20'+_0x1c3ca7['operator']+'\x20');_0x487079+=_0x1c3ca7['rules'][_0xd465be][_0x2682('0x68')]?_0x1fb763(_0x1c3ca7[_0x2682('0x66')][_0xd465be]['group']):_0x1c3ca7[_0x2682('0x66')][_0xd465be][_0x2682('0x69')]+'\x20'+_0x1c3ca7[_0x2682('0x66')][_0xd465be][_0x2682('0x6a')]+(_0x25343d(_0x1c3ca7[_0x2682('0x66')][_0xd465be]['condition'])?'\x20'+_0x1c3ca7[_0x2682('0x66')][_0xd465be][_0x2682('0x6b')]:'');}return _0x487079+')';};var _0x5a8e7a={'where':{'id':_0x1c1207['id']}},_0x4aaee2,_0x44bd07,_0x193e1c,_0x3e1ebd,_0x1c7120;_0x5a8e7a=_[_0x2682('0x42')]({},_0x5a8e7a,_0x421f1b);return db[_0x2682('0x2e')][_0x2682('0x50')](_0x5a8e7a)[_0x2682('0x25')](function(_0x3f194d){if(_0x3f194d){_0x4aaee2=_0x3f194d;return _0x3f194d[_0x2682('0x8b')]();}return null;})[_0x2682('0x25')](function(_0x3b13fd){if(_0x3b13fd){if(!_0x3b13fd['length']){throw new db[(_0x2682('0x6c'))][(_0x2682('0x6d'))](_0x2682('0x6e'),0x193);}_0x44bd07=_0x3b13fd;return db[_0x2682('0x8c')]['findAll']({'raw':!![]});}return null;})['then'](function(_0x3b6b99){if(_0x3b6b99){_0x193e1c=_[_0x2682('0x6f')](_0x3b6b99,'id');var _0x4b1658;var _0x338d71=squel['select']();_0x338d71[_0x2682('0x71')](_0x4aaee2[_0x2682('0x7f')]);for(var _0x2842df=0x0;_0x2842df<_0x44bd07[_0x2682('0x4a')];_0x2842df+=0x1){_0x4b1658=_0x44bd07[_0x2842df]['MetricId']?_0x193e1c[_0x44bd07[_0x2842df][_0x2682('0x72')]]['metric']:_0x44bd07[_0x2842df]['field'];_0x4b1658=_0x44bd07[_0x2842df][_0x2682('0x8d')]?_[_0x2682('0x74')](_0xcf8e25[_0x44bd07[_0x2842df][_0x2682('0x8d')]],'%s',_0x4b1658):_0x4b1658;_0x4b1658=_0x44bd07[_0x2842df][_0x2682('0x75')]?_['replace'](_0x100c0c[_0x44bd07[_0x2842df][_0x2682('0x75')]],'%s',_0x4b1658):_0x4b1658;if(_0x44bd07[_0x2842df]['groupBy']){_0x338d71['group'](_0x4b1658);}_0x44bd07[_0x2842df][_0x2682('0x77')]&&_0x338d71[_0x2682('0x3c')](_0x4b1658,_0x44bd07[_0x2842df][_0x2682('0x77')]===_0x2682('0x78')?![]:!![]);_0x338d71['field'](_0x4b1658,_0x44bd07[_0x2842df][_0x2682('0x8e')]||_0x4b1658);}if(_0x4aaee2['joins']){_0x4aaee2[_0x2682('0x79')]=JSON[_0x2682('0x7a')](_0x4aaee2[_0x2682('0x79')]);for(var _0x24ca2e=0x0;_0x24ca2e<_0x4aaee2[_0x2682('0x79')][_0x2682('0x4a')];_0x24ca2e+=0x1){if(_0x4aaee2[_0x2682('0x79')][_0x24ca2e][_0x2682('0x31')]&&_[_0x2682('0x64')](_0x2598d7,_0x4aaee2[_0x2682('0x79')][_0x24ca2e][_0x2682('0x31')])&&_0x4aaee2['joins'][_0x24ca2e][_0x2682('0x7b')]&&_0x4aaee2[_0x2682('0x79')][_0x24ca2e][_0x2682('0x7c')]&&_0x4aaee2[_0x2682('0x79')][_0x24ca2e]['foreignKey']){_0x338d71[_0x4aaee2[_0x2682('0x79')][_0x24ca2e][_0x2682('0x31')]](_0x4aaee2[_0x2682('0x79')][_0x24ca2e][_0x2682('0x7c')],null,util[_0x2682('0x75')](_0x2682('0x7e'),_0x4aaee2[_0x2682('0x7f')],_0x4aaee2[_0x2682('0x79')][_0x24ca2e][_0x2682('0x7b')],_0x4aaee2[_0x2682('0x79')][_0x24ca2e][_0x2682('0x7c')],_0x4aaee2[_0x2682('0x79')][_0x24ca2e][_0x2682('0x7d')]));}}}if(_0x4aaee2[_0x2682('0x80')]){_0x4aaee2[_0x2682('0x80')]=JSON[_0x2682('0x7a')](_0x4aaee2['conditions']);_0x338d71['where'](_0x1fb763(_0x4aaee2[_0x2682('0x80')][_0x2682('0x68')]));}_0x1c7120=_0x338d71['clone']();_0x338d71[_0x2682('0x1e')](_0x50aad9);_0x338d71['offset'](0x0);logger[_0x2682('0x81')](_0x2682('0x82'),_0x338d71[_0x2682('0x83')]());return db['sequelize'][_0x2682('0x34')](_0x338d71[_0x2682('0x83')](),{'type':db['sequelize'][_0x2682('0x8f')][_0x2682('0x90')]});}})[_0x2682('0x25')](function(_0x1a7103){if(!_0x1a7103[_0x2682('0x4a')]){throw new db['Sequelize'][(_0x2682('0x6d'))](_0x2682('0x91'),0xcc);}if(_0x3632c9[_0x2682('0x92')]===_0x2682('0x93')){return null;}var _0x34fdca=_[_0x2682('0x42')](_0x3632c9,{'name':_0x3632c9[_0x2682('0x94')]||_0x3632c9['name']||_0x4aaee2[_0x2682('0x2b')],'basename':_0x432c4c,'savename':util[_0x2682('0x75')](_0x2682('0x95'),_0x3632c9[_0x2682('0x2b')]||_0x4aaee2[_0x2682('0x2b')],require(_0x2682('0x96'))['generate'](0x4),_0x3632c9[_0x2682('0x92')]||'csv'),'reportId':_0x4aaee2['id'],'reportType':'custom'});return db[_0x2682('0x97')][_0x2682('0x4c')](_0x34fdca,{'raw':!![]});})[_0x2682('0x25')](function(_0x406a03){if(_0x4aaee2[_0x2682('0x7f')]===_0x2682('0x98')){_0x1c7120[_0x2682('0x3e')](_0x4aaee2[_0x2682('0x7f')]+_0x2682('0x99'),_0x3632c9['startDate'],_0x3632c9[_0x2682('0x9a')]);}else{_0x1c7120[_0x2682('0x3e')](_0x4aaee2['table']+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x3632c9[_0x2682('0x9b')],_0x3632c9['endDate']);}if(_0x406a03){logger['info'](_0x2682('0x9c'),_0x1c7120[_0x2682('0x83')]());require(_0x2682('0x9d'))[_0x2682('0x9e')](path[_0x2682('0x85')](__dirname,_0x2682('0x9f'),_0x406a03[_0x2682('0x92')]),[_0x406a03['id'],_0x1c7120[_0x2682('0x83')](),path[_0x2682('0x85')](__dirname,_0x2682('0xa0'),_0x406a03[_0x2682('0xa1')]),_0x432c4c]);return _0x406a03;}else{var _0x50abbc=squel[_0x2682('0x70')]();_0x50abbc['from']('('+_0x1c7120[_0x2682('0x83')]()+')','countTable');_0x50abbc[_0x2682('0x69')](_0x2682('0xa2'),_0x2682('0x44'));_0x1c7120[_0x2682('0x1e')](_0x3632c9[_0x2682('0x1e')]||_0x50aad9);_0x1c7120[_0x2682('0x1d')](_0x3632c9[_0x2682('0x1d')]||0x0);return dbH[_0x2682('0x84')][_0x2682('0x34')](_0x50abbc['toString'](),{'type':dbH[_0x2682('0x84')]['QueryTypes']['SELECT']})['then'](function(_0x1cffc4){if(!_0x1cffc4[_0x2682('0x4a')]){_0x3e1ebd=0x0;}else{_0x3e1ebd=_0x1cffc4[0x0]['count']||0x0;}return dbH['sequelize'][_0x2682('0x34')](_0x1c7120[_0x2682('0x83')](),{'type':dbH[_0x2682('0x84')][_0x2682('0x8f')][_0x2682('0x90')]});})[_0x2682('0x25')](function(_0x899a77){return{'rows':_0x899a77||[],'count':_0x3e1ebd};});}});}exports['run']=function(_0x195247,_0x2df0c1){return runReport(_0x195247['params'],_0x195247[_0x2682('0x34')],_0x195247[_0x2682('0x43')])[_0x2682('0x25')](respondWithResult(_0x2df0c1,null))[_0x2682('0x48')](handleError(_0x2df0c1,null));};exports[_0x2682('0xa3')]=runReport;exports[_0x2682('0x34')]=function(_0x487d43,_0x497dc0){var _0x2cbd24=0xa;var _0x240697=[_0x2682('0x85'),_0x2682('0x56'),_0x2682('0x57'),_0x2682('0x58')];var _0x3e8596={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT DISTINCT':_0x2682('0x5b'),'MAX':'MAX(%s)','MIN':_0x2682('0x5d'),'AVG':_0x2682('0x5e'),'GROUP_CONCAT':_0x2682('0x86'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0x2682('0x87')};var _0x3ea97d={'SEC_TO_TIME':_0x2682('0x60'),'DATE':_0x2682('0x88'),'HOUR':'HOUR(%s)','ROUND':_0x2682('0x62'),'UNIX_TIMESTAMP':_0x2682('0x63')};var _0x131ab4=function(_0xba6663){return!_[_0x2682('0x64')]([_0x2682('0x65'),_0x2682('0xa4'),'IS\x20EMPTY',_0x2682('0x8a')],_0xba6663);};var _0x2b23a9=function(_0x19a993){if(!_0x19a993||!_0x19a993[_0x2682('0x66')][_0x2682('0x4a')]){return'';}for(var _0x5da5fc='(',_0x4b84de=0x0;_0x4b84de<_0x19a993[_0x2682('0x66')][_0x2682('0x4a')];_0x4b84de+=0x1){_0x4b84de>0x0&&(_0x5da5fc+='\x20'+_0x19a993[_0x2682('0x67')]+'\x20');_0x5da5fc+=_0x19a993[_0x2682('0x66')][_0x4b84de]['group']?_0x2b23a9(_0x19a993[_0x2682('0x66')][_0x4b84de][_0x2682('0x68')]):_0x19a993[_0x2682('0x66')][_0x4b84de][_0x2682('0x69')]+'\x20'+_0x19a993[_0x2682('0x66')][_0x4b84de][_0x2682('0x6a')]+(_0x131ab4(_0x19a993[_0x2682('0x66')][_0x4b84de][_0x2682('0x6a')])?'\x20'+_0x19a993[_0x2682('0x66')][_0x4b84de][_0x2682('0x6b')]:'');}return _0x5da5fc+')';};var _0x4c8581={'where':{'id':_0x487d43[_0x2682('0x54')]['id']}},_0x5ff5f8,_0x78e9a2,_0x45cebd,_0x37d74c,_0x2d7d84;_0x4c8581=_['merge']({},_0x4c8581,_0x487d43['options']);return db[_0x2682('0x2e')][_0x2682('0x50')](_0x4c8581)[_0x2682('0x25')](function(_0x4c274a){if(_0x4c274a){_0x5ff5f8=_0x4c274a;return _0x4c274a[_0x2682('0x8b')]();}return null;})['then'](function(_0x4a3391){if(_0x4a3391){if(!_0x4a3391[_0x2682('0x4a')]){throw new db[(_0x2682('0x6c'))][(_0x2682('0x6d'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x78e9a2=_0x4a3391;return db[_0x2682('0x8c')][_0x2682('0x46')]({'raw':!![]});}return null;})[_0x2682('0x25')](function(_0x2a23c0){if(_0x2a23c0){_0x45cebd=_[_0x2682('0x6f')](_0x2a23c0,'id');var _0x507b6a;var _0x49aa01=squel[_0x2682('0x70')]();_0x49aa01['from'](_0x5ff5f8['table']);for(var _0x105d3f=0x0;_0x105d3f<_0x78e9a2[_0x2682('0x4a')];_0x105d3f+=0x1){_0x507b6a=_0x78e9a2[_0x105d3f][_0x2682('0x72')]?_0x45cebd[_0x78e9a2[_0x105d3f]['MetricId']]['metric']:_0x78e9a2[_0x105d3f]['field'];_0x507b6a=_0x78e9a2[_0x105d3f][_0x2682('0x8d')]?_[_0x2682('0x74')](_0x3e8596[_0x78e9a2[_0x105d3f][_0x2682('0x8d')]],'%s',_0x507b6a):_0x507b6a;_0x507b6a=_0x78e9a2[_0x105d3f]['format']?_[_0x2682('0x74')](_0x3ea97d[_0x78e9a2[_0x105d3f][_0x2682('0x75')]],'%s',_0x507b6a):_0x507b6a;if(_0x78e9a2[_0x105d3f][_0x2682('0x76')]){_0x49aa01[_0x2682('0x68')](_0x507b6a);}_0x78e9a2[_0x105d3f]['orderBy']&&_0x49aa01[_0x2682('0x3c')](_0x507b6a,_0x78e9a2[_0x105d3f][_0x2682('0x77')]===_0x2682('0x78')?![]:!![]);_0x49aa01['field'](_0x507b6a,_0x78e9a2[_0x105d3f][_0x2682('0x8e')]||_0x507b6a);}if(_0x5ff5f8['joins']){_0x5ff5f8['joins']=JSON[_0x2682('0x7a')](_0x5ff5f8[_0x2682('0x79')]);for(var _0x31dfd7=0x0;_0x31dfd7<_0x5ff5f8['joins'][_0x2682('0x4a')];_0x31dfd7+=0x1){if(_0x5ff5f8['joins'][_0x31dfd7][_0x2682('0x31')]&&_[_0x2682('0x64')](_0x240697,_0x5ff5f8[_0x2682('0x79')][_0x31dfd7][_0x2682('0x31')])&&_0x5ff5f8[_0x2682('0x79')][_0x31dfd7][_0x2682('0x7b')]&&_0x5ff5f8[_0x2682('0x79')][_0x31dfd7][_0x2682('0x7c')]&&_0x5ff5f8['joins'][_0x31dfd7][_0x2682('0x7d')]){_0x49aa01[_0x5ff5f8['joins'][_0x31dfd7]['type']](_0x5ff5f8[_0x2682('0x79')][_0x31dfd7][_0x2682('0x7c')],null,util['format'](_0x2682('0x7e'),_0x5ff5f8['table'],_0x5ff5f8[_0x2682('0x79')][_0x31dfd7][_0x2682('0x7b')],_0x5ff5f8[_0x2682('0x79')][_0x31dfd7][_0x2682('0x7c')],_0x5ff5f8[_0x2682('0x79')][_0x31dfd7][_0x2682('0x7d')]));}}}if(_0x5ff5f8['conditions']){_0x5ff5f8[_0x2682('0x80')]=JSON[_0x2682('0x7a')](_0x5ff5f8[_0x2682('0x80')]);_0x49aa01['where'](_0x2b23a9(_0x5ff5f8[_0x2682('0x80')][_0x2682('0x68')]));}_0x2d7d84=_0x49aa01[_0x2682('0xa5')]();_0x49aa01[_0x2682('0x1e')](_0x2cbd24);_0x49aa01[_0x2682('0x1d')](0x0);logger[_0x2682('0x81')]('Limited\x20Query:',_0x49aa01[_0x2682('0x83')]());return db[_0x2682('0x84')][_0x2682('0x34')](_0x49aa01[_0x2682('0x83')](),{'type':db[_0x2682('0x84')][_0x2682('0x8f')][_0x2682('0x90')]});}})[_0x2682('0x25')](function(){return{'sql':_0x2d7d84['toString']()};})[_0x2682('0x25')](respondWithResult(_0x497dc0,null))[_0x2682('0x48')](handleError(_0x497dc0,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff