18 var _0x8273=['include','catch','show','params','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','Reports','UserProfileSection','DefaultReports','find','preview','cross_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s)','SEC_TO_TIME(%s)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','value','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','findAll','from','table','MetricId','metric','function','format','groupBy','orderBy','DESC','alias','joins','parse','includes','foreignTable','%s.%s\x20=\x20%s.%s','parentKey','foreignKey','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','join','left_join','right_join','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','DATE(%s)','IS\x20EMPTY','keyBy','select','replace','No\x20available\x20data','web','fullPath','%s-%s.%s','generate','csv','default','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','Run\x20Query:','child_process','output','../../files/reports','savename','countTable','SELECT','run','runReport','html-pdf','eml-format','zip-dir','request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','lodash','squel','jsforce','desk.js','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../mysqldb','sendStatus','status','end','count','offset','limit','set','apply','reject','save','update','then','get','UserProfileResource','destroy','error','stack','name','index','AnalyticDefaultReport','rawAttributes','fieldName','key','model','map','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','merge','where','type','VIRTUAL','filter','options','includeAll'];(function(_0x289803,_0x593ea6){var _0x13b42c=function(_0x2c3ff0){while(--_0x2c3ff0){_0x289803['push'](_0x289803['shift']());}};_0x13b42c(++_0x593ea6);}(_0x8273,0x103));var _0x3827=function(_0x1977cc,_0x1fa9ca){_0x1977cc=_0x1977cc-0x0;var _0x514755=_0x8273[_0x1977cc];return _0x514755;};'use strict';var pdf=require(_0x3827('0x0'));var emlformat=require(_0x3827('0x1'));var rimraf=require('rimraf');var zipdir=require(_0x3827('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x3827('0x3'));var moment=require(_0x3827('0x4'));var BPromise=require(_0x3827('0x5'));var Mustache=require(_0x3827('0x6'));var util=require(_0x3827('0x7'));var path=require('path');var sox=require(_0x3827('0x8'));var csv=require(_0x3827('0x9'));var ejs=require(_0x3827('0xa'));var fs=require('fs');var _=require(_0x3827('0xb'));var squel=require(_0x3827('0xc'));var crypto=require('crypto');var jsforce=require(_0x3827('0xd'));var deskjs=require(_0x3827('0xe'));var toCsv=require(_0x3827('0x9'));var querystring=require(_0x3827('0xf'));var Papa=require('papaparse');var Redis=require(_0x3827('0x10'));var authService=require(_0x3827('0x11'));var qs=require(_0x3827('0x12'));var as=require(_0x3827('0x13'));var hardwareService=require(_0x3827('0x14'));var logger=require(_0x3827('0x15'))(_0x3827('0x16'));var utils=require('../../config/utils');var config=require(_0x3827('0x17'));var db=require(_0x3827('0x18'))['db'];function respondWithStatusCode(_0x34ff7c,_0x5eb69e){_0x5eb69e=_0x5eb69e||0xcc;return function(_0x45b2c3){if(_0x45b2c3){return _0x34ff7c[_0x3827('0x19')](_0x5eb69e);}return _0x34ff7c[_0x3827('0x1a')](_0x5eb69e)[_0x3827('0x1b')]();};}function respondWithResult(_0x5be61a,_0x390507){_0x390507=_0x390507||0xc8;return function(_0x44c38c){if(_0x44c38c){return _0x5be61a[_0x3827('0x1a')](_0x390507)['json'](_0x44c38c);}};}function respondWithFilteredResult(_0x1a69d5,_0xb52a1e){return function(_0x4ddcb7){if(_0x4ddcb7){var _0xef2c1f=_0x4ddcb7[_0x3827('0x1c')],_0x2a4ac7=_0xb52a1e[_0x3827('0x1d')],_0x3011c9=_0xb52a1e['offset']+_0xb52a1e[_0x3827('0x1e')],_0x3389d6;if(_0x3011c9>=_0xef2c1f){_0x3011c9=_0xef2c1f;_0x3389d6=0xc8;}else{_0x3389d6=0xce;}_0x1a69d5[_0x3827('0x1a')](_0x3389d6);return _0x1a69d5[_0x3827('0x1f')]('Content-Range',_0x2a4ac7+'-'+_0x3011c9+'/'+_0xef2c1f)['json'](_0x4ddcb7);}return null;};}function patchUpdates(_0x45c1cf){return function(_0x4e921a){try{jsonpatch[_0x3827('0x20')](_0x4e921a,_0x45c1cf,!![]);}catch(_0x22b8ec){return BPromise[_0x3827('0x21')](_0x22b8ec);}return _0x4e921a[_0x3827('0x22')]();};}function saveUpdates(_0x2711c4,_0x16c1bd){return function(_0x876c9f){if(_0x876c9f){return _0x876c9f[_0x3827('0x23')](_0x2711c4)['then'](function(_0x57b0ea){return _0x57b0ea;});}return null;};}function removeEntity(_0x22beb0,_0x150bc1){return function(_0x374118){if(_0x374118){return _0x374118['destroy']()[_0x3827('0x24')](function(){var _0xb6eb68=_0x374118[_0x3827('0x25')]({'plain':!![]});var _0x2604f7='DefaultReports';return db[_0x3827('0x26')][_0x3827('0x27')]({'where':{'type':_0x2604f7,'resourceId':_0xb6eb68['id']}})['then'](function(){return _0x374118;});})['then'](function(){_0x22beb0[_0x3827('0x1a')](0xcc)[_0x3827('0x1b')]();});}};}function handleEntityNotFound(_0x433abd,_0x42c3a9){return function(_0x5a5c06){if(!_0x5a5c06){_0x433abd['sendStatus'](0x194);}return _0x5a5c06;};}function handleError(_0x210db5,_0x50908e){_0x50908e=_0x50908e||0x1f4;return function(_0x526372){logger[_0x3827('0x28')](_0x526372[_0x3827('0x29')]);if(_0x526372[_0x3827('0x2a')]){delete _0x526372['name'];}_0x210db5[_0x3827('0x1a')](_0x50908e)['send'](_0x526372);};}exports[_0x3827('0x2b')]=function(_0x223c84,_0x5aed58){var _0x2e3eef={},_0x56a592={},_0x2b28bf={'count':0x0,'rows':[]};var _0xa9131a=_['map'](db[_0x3827('0x2c')][_0x3827('0x2d')],function(_0x23dd16){return{'name':_0x23dd16[_0x3827('0x2e')],'type':_0x23dd16['type'][_0x3827('0x2f')]};});_0x56a592[_0x3827('0x30')]=_[_0x3827('0x31')](_0xa9131a,_0x3827('0x2a'));_0x56a592[_0x3827('0x32')]=_['keys'](_0x223c84['query']);_0x56a592[_0x3827('0x33')]=_[_0x3827('0x34')](_0x56a592[_0x3827('0x30')],_0x56a592[_0x3827('0x32')]);_0x2e3eef[_0x3827('0x35')]=_[_0x3827('0x34')](_0x56a592['model'],qs[_0x3827('0x36')](_0x223c84[_0x3827('0x32')][_0x3827('0x36')]));_0x2e3eef[_0x3827('0x35')]=_0x2e3eef['attributes'][_0x3827('0x37')]?_0x2e3eef[_0x3827('0x35')]:_0x56a592[_0x3827('0x30')];if(!_0x223c84[_0x3827('0x32')][_0x3827('0x38')](_0x3827('0x39'))){_0x2e3eef[_0x3827('0x1e')]=qs[_0x3827('0x1e')](_0x223c84[_0x3827('0x32')][_0x3827('0x1e')]);_0x2e3eef[_0x3827('0x1d')]=qs['offset'](_0x223c84[_0x3827('0x32')][_0x3827('0x1d')]);}_0x2e3eef[_0x3827('0x3a')]=qs['sort'](_0x223c84[_0x3827('0x32')][_0x3827('0x3b')]);_0x2e3eef['where']=qs[_0x3827('0x33')](_['pick'](_0x223c84['query'],_0x56a592[_0x3827('0x33')]));if(_0x223c84[_0x3827('0x32')]['filter']){_0x2e3eef['where']=_[_0x3827('0x3c')](_0x2e3eef[_0x3827('0x3d')],{'$or':_['map'](_0xa9131a,function(_0xaa6c66){if(_0xaa6c66[_0x3827('0x3e')]!==_0x3827('0x3f')){var _0x32d42c={};_0x32d42c[_0xaa6c66[_0x3827('0x2a')]]={'$like':'%'+_0x223c84['query'][_0x3827('0x40')]+'%'};return _0x32d42c;}})});}_0x2e3eef=_[_0x3827('0x3c')]({},_0x2e3eef,_0x223c84[_0x3827('0x41')]);var _0x178079={'where':_0x2e3eef['where']};return db[_0x3827('0x2c')][_0x3827('0x1c')](_0x178079)['then'](function(_0x4857ba){_0x2b28bf[_0x3827('0x1c')]=_0x4857ba;if(_0x223c84[_0x3827('0x32')][_0x3827('0x42')]){_0x2e3eef[_0x3827('0x43')]=[{'all':!![]}];}return db[_0x3827('0x2c')]['findAll'](_0x2e3eef);})[_0x3827('0x24')](function(_0x5c3df1){_0x2b28bf['rows']=_0x5c3df1;return _0x2b28bf;})['then'](respondWithFilteredResult(_0x5aed58,_0x2e3eef))[_0x3827('0x44')](handleError(_0x5aed58,null));};exports[_0x3827('0x45')]=function(_0x38cef2,_0x4886fb){var _0x3fbb48={'raw':!![],'where':{'id':_0x38cef2[_0x3827('0x46')]['id']}},_0x59e9db={};_0x59e9db[_0x3827('0x30')]=_['keys'](db[_0x3827('0x2c')][_0x3827('0x2d')]);_0x59e9db['query']=_['keys'](_0x38cef2[_0x3827('0x32')]);_0x59e9db['filters']=_['intersection'](_0x59e9db['model'],_0x59e9db[_0x3827('0x32')]);_0x3fbb48['attributes']=_[_0x3827('0x34')](_0x59e9db[_0x3827('0x30')],qs[_0x3827('0x36')](_0x38cef2[_0x3827('0x32')][_0x3827('0x36')]));_0x3fbb48['attributes']=_0x3fbb48[_0x3827('0x35')]['length']?_0x3fbb48[_0x3827('0x35')]:_0x59e9db[_0x3827('0x30')];if(_0x38cef2[_0x3827('0x32')][_0x3827('0x42')]){_0x3fbb48[_0x3827('0x43')]=[{'all':!![]}];}_0x3fbb48=_[_0x3827('0x3c')]({},_0x3fbb48,_0x38cef2['options']);return db[_0x3827('0x2c')]['find'](_0x3fbb48)[_0x3827('0x24')](handleEntityNotFound(_0x4886fb,null))['then'](respondWithResult(_0x4886fb,null))['catch'](handleError(_0x4886fb,null));};exports[_0x3827('0x47')]=function(_0x287bfe,_0x266cb4){return db[_0x3827('0x2c')][_0x3827('0x47')](_0x287bfe[_0x3827('0x48')],{})[_0x3827('0x24')](function(_0xb7f27c){var _0x2f7785=_0x287bfe['user'][_0x3827('0x25')]({'plain':!![]});if(!_0x2f7785)throw new Error(_0x3827('0x49'));if(_0x2f7785[_0x3827('0x4a')]===_0x3827('0x4b')){var _0x18ecfb=_0xb7f27c[_0x3827('0x25')]({'plain':!![]});var _0x300be2=_0x3827('0x4c');return db[_0x3827('0x4d')]['find']({'where':{'name':_0x300be2,'userProfileId':_0x2f7785['userProfileId']},'raw':!![]})['then'](function(_0x199262){if(_0x199262&&_0x199262['autoAssociation']===0x0){return db['UserProfileResource']['create']({'name':_0x18ecfb['name'],'resourceId':_0x18ecfb['id'],'type':_0x3827('0x4e'),'sectionId':_0x199262['id']},{})[_0x3827('0x24')](function(){return _0xb7f27c;});}else{return _0xb7f27c;}})[_0x3827('0x44')](function(_0x541055){logger[_0x3827('0x28')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x541055);throw _0x541055;});}return _0xb7f27c;})['then'](respondWithResult(_0x266cb4,0xc9))[_0x3827('0x44')](handleError(_0x266cb4,null));};exports[_0x3827('0x23')]=function(_0x1d470c,_0x1664b8){if(_0x1d470c[_0x3827('0x48')]['id']){delete _0x1d470c['body']['id'];}return db[_0x3827('0x2c')][_0x3827('0x4f')]({'where':{'id':_0x1d470c[_0x3827('0x46')]['id']}})[_0x3827('0x24')](handleEntityNotFound(_0x1664b8,null))[_0x3827('0x24')](saveUpdates(_0x1d470c[_0x3827('0x48')],null))[_0x3827('0x24')](respondWithResult(_0x1664b8,null))[_0x3827('0x44')](handleError(_0x1664b8,null));};exports[_0x3827('0x27')]=function(_0x228c2a,_0x3a6ab4){return db[_0x3827('0x2c')]['find']({'where':{'id':_0x228c2a['params']['id']}})[_0x3827('0x24')](handleEntityNotFound(_0x3a6ab4,null))[_0x3827('0x24')](removeEntity(_0x3a6ab4,null))['catch'](handleError(_0x3a6ab4,null));};exports[_0x3827('0x50')]=function(_0x4135bc,_0x48f1c2){var _0x3b87ea=0xa;var _0x13a23e=['join','left_join','right_join',_0x3827('0x51')];var _0x196479={'SUM':_0x3827('0x52'),'COUNT':_0x3827('0x53'),'COUNT DISTINCT':_0x3827('0x54'),'MAX':_0x3827('0x55'),'MIN':_0x3827('0x56'),'AVG':_0x3827('0x57'),'GROUP_CONCAT':_0x3827('0x58'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x331c6a={'SEC_TO_TIME':_0x3827('0x59'),'DATE':'DATE(%s)','HOUR':_0x3827('0x5a'),'ROUND':_0x3827('0x5b'),'UNIX_TIMESTAMP':_0x3827('0x5c')};var _0x35106f=function(_0x4b9ce6){return!_['includes']([_0x3827('0x5d'),_0x3827('0x5e'),'IS\x20EMPTY',_0x3827('0x5f')],_0x4b9ce6);};var _0x1a0fb8=function(_0x282d74){if(!_0x282d74||!_0x282d74['rules'][_0x3827('0x37')]){return'';}for(var _0x2811df='(',_0x377297=0x0;_0x377297<_0x282d74[_0x3827('0x60')]['length'];_0x377297+=0x1){_0x377297>0x0&&(_0x2811df+='\x20'+_0x282d74[_0x3827('0x61')]+'\x20');_0x2811df+=_0x282d74[_0x3827('0x60')][_0x377297][_0x3827('0x62')]?_0x1a0fb8(_0x282d74['rules'][_0x377297][_0x3827('0x62')]):_0x282d74[_0x3827('0x60')][_0x377297][_0x3827('0x63')]+'\x20'+_0x282d74[_0x3827('0x60')][_0x377297][_0x3827('0x64')]+(_0x35106f(_0x282d74[_0x3827('0x60')][_0x377297][_0x3827('0x64')])?'\x20'+_0x282d74[_0x3827('0x60')][_0x377297][_0x3827('0x65')]:'');}return _0x2811df+')';};var _0x5c22f8={'where':{'id':_0x4135bc[_0x3827('0x46')]['id']}},_0x423b01,_0x595d3,_0x74ab1e,_0x193683,_0xcd8849;_0x5c22f8=_[_0x3827('0x3c')]({},_0x5c22f8,_0x4135bc[_0x3827('0x41')]);return db[_0x3827('0x2c')]['find'](_0x5c22f8)[_0x3827('0x24')](function(_0x5a11cf){if(_0x5a11cf){_0x423b01=_0x5a11cf;return _0x5a11cf[_0x3827('0x66')]();}return null;})['then'](function(_0x2ceff1){if(_0x2ceff1){if(!_0x2ceff1['length']){throw new db[(_0x3827('0x67'))][(_0x3827('0x68'))](_0x3827('0x69'),0x193);}_0x595d3=_0x2ceff1;return db[_0x3827('0x6a')][_0x3827('0x6b')]({'raw':!![]});}return null;})[_0x3827('0x24')](function(_0x76315d){if(_0x76315d){_0x74ab1e=_['keyBy'](_0x76315d,'id');var _0x1db37c;var _0x265a67=squel['select']();_0x265a67[_0x3827('0x6c')](_0x423b01[_0x3827('0x6d')]);for(var _0x5dbc8b=0x0;_0x5dbc8b<_0x595d3[_0x3827('0x37')];_0x5dbc8b+=0x1){_0x1db37c=_0x595d3[_0x5dbc8b][_0x3827('0x6e')]?_0x74ab1e[_0x595d3[_0x5dbc8b][_0x3827('0x6e')]][_0x3827('0x6f')]:_0x595d3[_0x5dbc8b]['field'];_0x1db37c=_0x595d3[_0x5dbc8b][_0x3827('0x70')]?_['replace'](_0x196479[_0x595d3[_0x5dbc8b][_0x3827('0x70')]],'%s',_0x1db37c):_0x1db37c;_0x1db37c=_0x595d3[_0x5dbc8b][_0x3827('0x71')]?_['replace'](_0x331c6a[_0x595d3[_0x5dbc8b][_0x3827('0x71')]],'%s',_0x1db37c):_0x1db37c;if(_0x595d3[_0x5dbc8b][_0x3827('0x72')]){_0x265a67[_0x3827('0x62')](_0x1db37c);}_0x595d3[_0x5dbc8b]['orderBy']&&_0x265a67[_0x3827('0x3a')](_0x1db37c,_0x595d3[_0x5dbc8b][_0x3827('0x73')]===_0x3827('0x74')?![]:!![]);_0x265a67['field'](_0x1db37c,_0x595d3[_0x5dbc8b][_0x3827('0x75')]||_0x1db37c);}if(_0x423b01[_0x3827('0x76')]){_0x423b01[_0x3827('0x76')]=JSON[_0x3827('0x77')](_0x423b01['joins']);for(var _0x5126bc=0x0;_0x5126bc<_0x423b01['joins'][_0x3827('0x37')];_0x5126bc+=0x1){if(_0x423b01[_0x3827('0x76')][_0x5126bc][_0x3827('0x3e')]&&_[_0x3827('0x78')](_0x13a23e,_0x423b01[_0x3827('0x76')][_0x5126bc][_0x3827('0x3e')])&&_0x423b01[_0x3827('0x76')][_0x5126bc]['parentKey']&&_0x423b01[_0x3827('0x76')][_0x5126bc][_0x3827('0x79')]&&_0x423b01[_0x3827('0x76')][_0x5126bc]['foreignKey']){_0x265a67[_0x423b01[_0x3827('0x76')][_0x5126bc][_0x3827('0x3e')]](_0x423b01[_0x3827('0x76')][_0x5126bc][_0x3827('0x79')],null,util['format'](_0x3827('0x7a'),_0x423b01['table'],_0x423b01[_0x3827('0x76')][_0x5126bc][_0x3827('0x7b')],_0x423b01['joins'][_0x5126bc][_0x3827('0x79')],_0x423b01[_0x3827('0x76')][_0x5126bc][_0x3827('0x7c')]));}}}if(_0x423b01[_0x3827('0x7d')]){_0x423b01[_0x3827('0x7d')]=JSON[_0x3827('0x77')](_0x423b01[_0x3827('0x7d')]);_0x265a67[_0x3827('0x3d')](_0x1a0fb8(_0x423b01['conditions'][_0x3827('0x62')]));}_0xcd8849=_0x265a67[_0x3827('0x7e')]();_0x265a67[_0x3827('0x1e')](_0x3b87ea);_0x265a67[_0x3827('0x1d')](0x0);logger[_0x3827('0x7f')](_0x3827('0x80'),_0x265a67[_0x3827('0x81')]());return db[_0x3827('0x82')][_0x3827('0x32')](_0x265a67[_0x3827('0x81')](),{'type':db[_0x3827('0x82')][_0x3827('0x83')]['SELECT']});}})[_0x3827('0x24')](respondWithResult(_0x48f1c2,null))['catch'](handleError(_0x48f1c2,null));};function runReport(_0x4c454e,_0x46346f,_0xb38da6){var _0x35a8e1=_0x46346f['name'];var _0x5ed765=0xa;var _0x296752=[_0x3827('0x84'),_0x3827('0x85'),_0x3827('0x86'),_0x3827('0x51')];var _0x1d2014={'SUM':_0x3827('0x52'),'COUNT':_0x3827('0x53'),'COUNT DISTINCT':_0x3827('0x54'),'MAX':_0x3827('0x55'),'MIN':_0x3827('0x56'),'AVG':'AVG(%s)','GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x3827('0x87'),'GROUP_CONCAT DESC':_0x3827('0x88')};var _0x804725={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x3827('0x89'),'HOUR':_0x3827('0x5a'),'ROUND':_0x3827('0x5b'),'UNIX_TIMESTAMP':_0x3827('0x5c')};var _0xdc3f9a=function(_0x2d59f6){return!_[_0x3827('0x78')]([_0x3827('0x5d'),_0x3827('0x5e'),_0x3827('0x8a'),_0x3827('0x5f')],_0x2d59f6);};var _0x2a1141=function(_0x59c8d6){if(!_0x59c8d6||!_0x59c8d6[_0x3827('0x60')][_0x3827('0x37')]){return'';}for(var _0x406321='(',_0x4d13bd=0x0;_0x4d13bd<_0x59c8d6['rules']['length'];_0x4d13bd+=0x1){_0x4d13bd>0x0&&(_0x406321+='\x20'+_0x59c8d6[_0x3827('0x61')]+'\x20');_0x406321+=_0x59c8d6[_0x3827('0x60')][_0x4d13bd][_0x3827('0x62')]?_0x2a1141(_0x59c8d6[_0x3827('0x60')][_0x4d13bd]['group']):_0x59c8d6['rules'][_0x4d13bd][_0x3827('0x63')]+'\x20'+_0x59c8d6[_0x3827('0x60')][_0x4d13bd][_0x3827('0x64')]+(_0xdc3f9a(_0x59c8d6[_0x3827('0x60')][_0x4d13bd][_0x3827('0x64')])?'\x20'+_0x59c8d6[_0x3827('0x60')][_0x4d13bd]['value']:'');}return _0x406321+')';};var _0x547b69={'where':{'id':_0x4c454e['id']}},_0x307aa4,_0x566cc1,_0xa059d1,_0x1ada1a,_0x4e7ba7;_0x547b69=_[_0x3827('0x3c')]({},_0x547b69,_0xb38da6);return db[_0x3827('0x2c')][_0x3827('0x4f')](_0x547b69)['then'](function(_0xf8995e){if(_0xf8995e){_0x307aa4=_0xf8995e;return _0xf8995e[_0x3827('0x66')]();}return null;})['then'](function(_0xf9d07a){if(_0xf9d07a){if(!_0xf9d07a['length']){throw new db[(_0x3827('0x67'))]['ValidationErrorItem'](_0x3827('0x69'),0x193);}_0x566cc1=_0xf9d07a;return db[_0x3827('0x6a')][_0x3827('0x6b')]({'raw':!![]});}return null;})['then'](function(_0x37cd96){if(_0x37cd96){_0xa059d1=_[_0x3827('0x8b')](_0x37cd96,'id');var _0xbdd25f;var _0x15a619=squel[_0x3827('0x8c')]();_0x15a619[_0x3827('0x6c')](_0x307aa4[_0x3827('0x6d')]);for(var _0x55c177=0x0;_0x55c177<_0x566cc1[_0x3827('0x37')];_0x55c177+=0x1){_0xbdd25f=_0x566cc1[_0x55c177][_0x3827('0x6e')]?_0xa059d1[_0x566cc1[_0x55c177][_0x3827('0x6e')]][_0x3827('0x6f')]:_0x566cc1[_0x55c177][_0x3827('0x63')];_0xbdd25f=_0x566cc1[_0x55c177][_0x3827('0x70')]?_[_0x3827('0x8d')](_0x1d2014[_0x566cc1[_0x55c177][_0x3827('0x70')]],'%s',_0xbdd25f):_0xbdd25f;_0xbdd25f=_0x566cc1[_0x55c177]['format']?_[_0x3827('0x8d')](_0x804725[_0x566cc1[_0x55c177][_0x3827('0x71')]],'%s',_0xbdd25f):_0xbdd25f;if(_0x566cc1[_0x55c177][_0x3827('0x72')]){_0x15a619[_0x3827('0x62')](_0xbdd25f);}_0x566cc1[_0x55c177][_0x3827('0x73')]&&_0x15a619[_0x3827('0x3a')](_0xbdd25f,_0x566cc1[_0x55c177][_0x3827('0x73')]===_0x3827('0x74')?![]:!![]);_0x15a619['field'](_0xbdd25f,_0x566cc1[_0x55c177][_0x3827('0x75')]||_0xbdd25f);}if(_0x307aa4['joins']){_0x307aa4[_0x3827('0x76')]=JSON[_0x3827('0x77')](_0x307aa4[_0x3827('0x76')]);for(var _0x1de4bf=0x0;_0x1de4bf<_0x307aa4['joins']['length'];_0x1de4bf+=0x1){if(_0x307aa4['joins'][_0x1de4bf][_0x3827('0x3e')]&&_[_0x3827('0x78')](_0x296752,_0x307aa4[_0x3827('0x76')][_0x1de4bf][_0x3827('0x3e')])&&_0x307aa4[_0x3827('0x76')][_0x1de4bf]['parentKey']&&_0x307aa4[_0x3827('0x76')][_0x1de4bf][_0x3827('0x79')]&&_0x307aa4[_0x3827('0x76')][_0x1de4bf][_0x3827('0x7c')]){_0x15a619[_0x307aa4[_0x3827('0x76')][_0x1de4bf]['type']](_0x307aa4[_0x3827('0x76')][_0x1de4bf][_0x3827('0x79')],null,util[_0x3827('0x71')](_0x3827('0x7a'),_0x307aa4[_0x3827('0x6d')],_0x307aa4[_0x3827('0x76')][_0x1de4bf]['parentKey'],_0x307aa4[_0x3827('0x76')][_0x1de4bf][_0x3827('0x79')],_0x307aa4['joins'][_0x1de4bf][_0x3827('0x7c')]));}}}if(_0x307aa4['conditions']){_0x307aa4[_0x3827('0x7d')]=JSON['parse'](_0x307aa4[_0x3827('0x7d')]);_0x15a619[_0x3827('0x3d')](_0x2a1141(_0x307aa4['conditions']['group']));}_0x4e7ba7=_0x15a619[_0x3827('0x7e')]();_0x15a619['limit'](_0x5ed765);_0x15a619[_0x3827('0x1d')](0x0);logger[_0x3827('0x7f')](_0x3827('0x80'),_0x15a619[_0x3827('0x81')]());return db['sequelize'][_0x3827('0x32')](_0x15a619[_0x3827('0x81')](),{'type':db['sequelize']['QueryTypes']['SELECT']});}})[_0x3827('0x24')](function(_0x23664e){if(!_0x23664e[_0x3827('0x37')]){throw new db['Sequelize']['ValidationErrorItem'](_0x3827('0x8e'),0xcc);}if(_0x46346f['output']===_0x3827('0x8f')){return null;}var _0x3f816e=_[_0x3827('0x3c')](_0x46346f,{'name':_0x46346f[_0x3827('0x90')]||_0x46346f[_0x3827('0x2a')]||_0x307aa4[_0x3827('0x2a')],'basename':_0x35a8e1,'savename':util['format'](_0x3827('0x91'),_0x46346f['name']||_0x307aa4[_0x3827('0x2a')],require('randomstring')[_0x3827('0x92')](0x4),_0x46346f['output']||_0x3827('0x93')),'reportId':_0x307aa4['id'],'reportType':_0x3827('0x94')});return db['AnalyticExtractedReport']['create'](_0x3f816e,{'raw':!![]});})[_0x3827('0x24')](function(_0x4b99ec){if(_0x307aa4[_0x3827('0x6d')]===_0x3827('0x95')){_0x4e7ba7[_0x3827('0x3d')](_0x307aa4[_0x3827('0x6d')]+_0x3827('0x96'),_0x46346f['startDate'],_0x46346f[_0x3827('0x97')]);}else{_0x4e7ba7[_0x3827('0x3d')](_0x307aa4[_0x3827('0x6d')]+_0x3827('0x98'),_0x46346f['startDate'],_0x46346f[_0x3827('0x97')]);}if(_0x4b99ec){logger[_0x3827('0x99')](_0x3827('0x9a'),_0x4e7ba7[_0x3827('0x81')]());require(_0x3827('0x9b'))['fork'](path[_0x3827('0x84')](__dirname,'../../components/export/',_0x4b99ec[_0x3827('0x9c')]),[_0x4b99ec['id'],_0x4e7ba7['toString'](),path[_0x3827('0x84')](__dirname,_0x3827('0x9d'),_0x4b99ec[_0x3827('0x9e')]),_0x35a8e1]);return _0x4b99ec;}else{var _0x611b98=squel[_0x3827('0x8c')]();_0x611b98[_0x3827('0x6c')]('('+_0x4e7ba7[_0x3827('0x81')]()+')',_0x3827('0x9f'));_0x611b98[_0x3827('0x63')]('COUNT(*)',_0x3827('0x1c'));_0x4e7ba7[_0x3827('0x1e')](_0x46346f['limit']||_0x5ed765);_0x4e7ba7[_0x3827('0x1d')](_0x46346f[_0x3827('0x1d')]||0x0);return db['sequelize']['query'](_0x611b98[_0x3827('0x81')](),{'type':db[_0x3827('0x82')][_0x3827('0x83')][_0x3827('0xa0')]})[_0x3827('0x24')](function(_0x2749c5){if(!_0x2749c5[_0x3827('0x37')]){_0x1ada1a=0x0;}else{_0x1ada1a=_0x2749c5[0x0]['count']||0x0;}return db[_0x3827('0x82')][_0x3827('0x32')](_0x4e7ba7['toString'](),{'type':db[_0x3827('0x82')][_0x3827('0x83')]['SELECT']});})[_0x3827('0x24')](function(_0xff81b0){return{'rows':_0xff81b0||[],'count':_0x1ada1a};});}});}exports[_0x3827('0xa1')]=function(_0x4a4ae8,_0x186e3e){return runReport(_0x4a4ae8['params'],_0x4a4ae8[_0x3827('0x32')],_0x4a4ae8[_0x3827('0x41')])[_0x3827('0x24')](respondWithResult(_0x186e3e,null))[_0x3827('0x44')](handleError(_0x186e3e,null));};exports[_0x3827('0xa2')]=runReport;exports[_0x3827('0x32')]=function(_0xa08d5b,_0x4ffc15){var _0x44e42b=0xa;var _0x563d64=[_0x3827('0x84'),_0x3827('0x85'),_0x3827('0x86'),_0x3827('0x51')];var _0x23dae3={'SUM':'SUM(%s)','COUNT':_0x3827('0x53'),'COUNT DISTINCT':_0x3827('0x54'),'MAX':_0x3827('0x55'),'MIN':'MIN(%s)','AVG':_0x3827('0x57'),'GROUP_CONCAT':_0x3827('0x58'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x565bd3={'SEC_TO_TIME':_0x3827('0x59'),'DATE':_0x3827('0x89'),'HOUR':'HOUR(%s)','ROUND':_0x3827('0x5b'),'UNIX_TIMESTAMP':_0x3827('0x5c')};var _0xdea99d=function(_0x4b7496){return!_[_0x3827('0x78')]([_0x3827('0x5d'),_0x3827('0x5e'),_0x3827('0x8a'),'IS\x20NOT\x20EMPTY'],_0x4b7496);};var _0x12bfb9=function(_0xa3a35a){if(!_0xa3a35a||!_0xa3a35a['rules'][_0x3827('0x37')]){return'';}for(var _0x5ab1c2='(',_0x400d1b=0x0;_0x400d1b<_0xa3a35a['rules'][_0x3827('0x37')];_0x400d1b+=0x1){_0x400d1b>0x0&&(_0x5ab1c2+='\x20'+_0xa3a35a[_0x3827('0x61')]+'\x20');_0x5ab1c2+=_0xa3a35a[_0x3827('0x60')][_0x400d1b][_0x3827('0x62')]?_0x12bfb9(_0xa3a35a[_0x3827('0x60')][_0x400d1b][_0x3827('0x62')]):_0xa3a35a['rules'][_0x400d1b][_0x3827('0x63')]+'\x20'+_0xa3a35a[_0x3827('0x60')][_0x400d1b][_0x3827('0x64')]+(_0xdea99d(_0xa3a35a[_0x3827('0x60')][_0x400d1b]['condition'])?'\x20'+_0xa3a35a[_0x3827('0x60')][_0x400d1b]['value']:'');}return _0x5ab1c2+')';};var _0x7fe5dc={'where':{'id':_0xa08d5b[_0x3827('0x46')]['id']}},_0x466031,_0x484436,_0x189199,_0x3a6492,_0x10a56a;_0x7fe5dc=_['merge']({},_0x7fe5dc,_0xa08d5b[_0x3827('0x41')]);return db['AnalyticDefaultReport']['find'](_0x7fe5dc)[_0x3827('0x24')](function(_0xa5e1fe){if(_0xa5e1fe){_0x466031=_0xa5e1fe;return _0xa5e1fe[_0x3827('0x66')]();}return null;})[_0x3827('0x24')](function(_0x6c5051){if(_0x6c5051){if(!_0x6c5051[_0x3827('0x37')]){throw new db[(_0x3827('0x67'))][(_0x3827('0x68'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x484436=_0x6c5051;return db[_0x3827('0x6a')]['findAll']({'raw':!![]});}return null;})[_0x3827('0x24')](function(_0x4dd3c4){if(_0x4dd3c4){_0x189199=_['keyBy'](_0x4dd3c4,'id');var _0x5e6e33;var _0x5d0d10=squel[_0x3827('0x8c')]();_0x5d0d10[_0x3827('0x6c')](_0x466031[_0x3827('0x6d')]);for(var _0x32f83b=0x0;_0x32f83b<_0x484436['length'];_0x32f83b+=0x1){_0x5e6e33=_0x484436[_0x32f83b]['MetricId']?_0x189199[_0x484436[_0x32f83b]['MetricId']][_0x3827('0x6f')]:_0x484436[_0x32f83b][_0x3827('0x63')];_0x5e6e33=_0x484436[_0x32f83b]['function']?_[_0x3827('0x8d')](_0x23dae3[_0x484436[_0x32f83b][_0x3827('0x70')]],'%s',_0x5e6e33):_0x5e6e33;_0x5e6e33=_0x484436[_0x32f83b]['format']?_[_0x3827('0x8d')](_0x565bd3[_0x484436[_0x32f83b][_0x3827('0x71')]],'%s',_0x5e6e33):_0x5e6e33;if(_0x484436[_0x32f83b][_0x3827('0x72')]){_0x5d0d10['group'](_0x5e6e33);}_0x484436[_0x32f83b][_0x3827('0x73')]&&_0x5d0d10[_0x3827('0x3a')](_0x5e6e33,_0x484436[_0x32f83b]['orderBy']===_0x3827('0x74')?![]:!![]);_0x5d0d10[_0x3827('0x63')](_0x5e6e33,_0x484436[_0x32f83b][_0x3827('0x75')]||_0x5e6e33);}if(_0x466031['joins']){_0x466031['joins']=JSON[_0x3827('0x77')](_0x466031[_0x3827('0x76')]);for(var _0x584423=0x0;_0x584423<_0x466031['joins'][_0x3827('0x37')];_0x584423+=0x1){if(_0x466031[_0x3827('0x76')][_0x584423][_0x3827('0x3e')]&&_['includes'](_0x563d64,_0x466031[_0x3827('0x76')][_0x584423][_0x3827('0x3e')])&&_0x466031[_0x3827('0x76')][_0x584423]['parentKey']&&_0x466031['joins'][_0x584423][_0x3827('0x79')]&&_0x466031[_0x3827('0x76')][_0x584423][_0x3827('0x7c')]){_0x5d0d10[_0x466031[_0x3827('0x76')][_0x584423][_0x3827('0x3e')]](_0x466031[_0x3827('0x76')][_0x584423]['foreignTable'],null,util[_0x3827('0x71')](_0x3827('0x7a'),_0x466031['table'],_0x466031[_0x3827('0x76')][_0x584423][_0x3827('0x7b')],_0x466031[_0x3827('0x76')][_0x584423][_0x3827('0x79')],_0x466031['joins'][_0x584423][_0x3827('0x7c')]));}}}if(_0x466031[_0x3827('0x7d')]){_0x466031[_0x3827('0x7d')]=JSON[_0x3827('0x77')](_0x466031[_0x3827('0x7d')]);_0x5d0d10[_0x3827('0x3d')](_0x12bfb9(_0x466031[_0x3827('0x7d')][_0x3827('0x62')]));}_0x10a56a=_0x5d0d10['clone']();_0x5d0d10[_0x3827('0x1e')](_0x44e42b);_0x5d0d10[_0x3827('0x1d')](0x0);logger[_0x3827('0x7f')]('Limited\x20Query:',_0x5d0d10[_0x3827('0x81')]());return db[_0x3827('0x82')][_0x3827('0x32')](_0x5d0d10[_0x3827('0x81')](),{'type':db[_0x3827('0x82')][_0x3827('0x83')][_0x3827('0xa0')]});}})[_0x3827('0x24')](function(){return{'sql':_0x10a56a[_0x3827('0x81')]()};})[_0x3827('0x24')](respondWithResult(_0x4ffc15,null))[_0x3827('0x44')](handleError(_0x4ffc15,null));};
git://repos.xcallymotion.com / motion2.git / blob