// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x12d7=['ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','dbH','sendStatus','end','status','count','offset','limit','set','json','reject','save','update','then','destroy','get','DefaultReports','UserProfileResource','error','stack','name','send','index','map','AnalyticDefaultReport','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','nolimit','order','sort','where','pick','merge','VIRTUAL','includeAll','rows','catch','show','params','rawAttributes','length','include','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','user','Reports','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','find','preview','left_join','cross_join','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','DATE(%s)','HOUR(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','condition','value','getFields','Sequelize','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','findAll','select','from','table','MetricId','metric','field','function','replace','format','groupBy','orderBy','DESC','alias','joins','parse','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','parentKey','conditions','Limited\x20Query:','toString','sequelize','QueryTypes','join','right_join','SUM(%s)','ROUND(%s)','ValidationErrorItem','output','fullPath','%s-%s.%s','randomstring','generate','default','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','endDate','info','child_process','fork','../../files/reports','savename','countTable','run','options','keyBy','clone','debug','SELECT','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','mustache','sox','lodash','squel','crypto','jsforce','desk.js','to-csv','querystring','papaparse'];(function(_0x173441,_0x26b0d9){var _0x2423a8=function(_0x4d96c2){while(--_0x4d96c2){_0x173441['push'](_0x173441['shift']());}};_0x2423a8(++_0x26b0d9);}(_0x12d7,0x1d7));var _0x712d=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0x12d7[_0x3dd15e];return _0x231fd0;};'use strict';var pdf=require(_0x712d('0x0'));var emlformat=require(_0x712d('0x1'));var rimraf=require(_0x712d('0x2'));var zipdir=require(_0x712d('0x3'));var jsonpatch=require(_0x712d('0x4'));var rp=require('request-promise');var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x712d('0x5'));var util=require('util');var path=require('path');var sox=require(_0x712d('0x6'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var _=require(_0x712d('0x7'));var squel=require(_0x712d('0x8'));var crypto=require(_0x712d('0x9'));var jsforce=require(_0x712d('0xa'));var deskjs=require(_0x712d('0xb'));var toCsv=require(_0x712d('0xc'));var querystring=require(_0x712d('0xd'));var Papa=require(_0x712d('0xe'));var Redis=require(_0x712d('0xf'));var authService=require('../../components/auth/service');var qs=require(_0x712d('0x10'));var as=require(_0x712d('0x11'));var hardwareService=require(_0x712d('0x12'));var logger=require(_0x712d('0x13'))(_0x712d('0x14'));var utils=require(_0x712d('0x15'));var config=require(_0x712d('0x16'));var licenseUtil=require(_0x712d('0x17'));var db=require('../../mysqldb')['db'];var dbH=require(_0x712d('0x18'))[_0x712d('0x19')];function respondWithStatusCode(_0x4fb6c6,_0x31406e){_0x31406e=_0x31406e||0xcc;return function(_0x57f59d){if(_0x57f59d){return _0x4fb6c6[_0x712d('0x1a')](_0x31406e);}return _0x4fb6c6['status'](_0x31406e)[_0x712d('0x1b')]();};}function respondWithResult(_0xc0cf83,_0x15186d){_0x15186d=_0x15186d||0xc8;return function(_0x3c46ed){if(_0x3c46ed){return _0xc0cf83[_0x712d('0x1c')](_0x15186d)['json'](_0x3c46ed);}};}function respondWithFilteredResult(_0x19bfbb,_0x1eac9f){return function(_0x4a0d7a){if(_0x4a0d7a){var _0x25128c=_0x4a0d7a[_0x712d('0x1d')],_0x53c297=_0x1eac9f['offset'],_0x257bb3=_0x1eac9f[_0x712d('0x1e')]+_0x1eac9f[_0x712d('0x1f')],_0x12ebda;if(_0x257bb3>=_0x25128c){_0x257bb3=_0x25128c;_0x12ebda=0xc8;}else{_0x12ebda=0xce;}_0x19bfbb['status'](_0x12ebda);return _0x19bfbb[_0x712d('0x20')]('Content-Range',_0x53c297+'-'+_0x257bb3+'/'+_0x25128c)[_0x712d('0x21')](_0x4a0d7a);}return null;};}function patchUpdates(_0x154df0){return function(_0x47c142){try{jsonpatch['apply'](_0x47c142,_0x154df0,!![]);}catch(_0x25275f){return BPromise[_0x712d('0x22')](_0x25275f);}return _0x47c142[_0x712d('0x23')]();};}function saveUpdates(_0xedd120,_0xf1e337){return function(_0x3cc92e){if(_0x3cc92e){return _0x3cc92e[_0x712d('0x24')](_0xedd120)[_0x712d('0x25')](function(_0x20d564){return _0x20d564;});}return null;};}function removeEntity(_0x14cc11,_0x16f2aa){return function(_0xeee14a){if(_0xeee14a){return _0xeee14a[_0x712d('0x26')]()['then'](function(){var _0x2574b5=_0xeee14a[_0x712d('0x27')]({'plain':!![]});var _0x309a28=_0x712d('0x28');return db[_0x712d('0x29')][_0x712d('0x26')]({'where':{'type':_0x309a28,'resourceId':_0x2574b5['id']}})[_0x712d('0x25')](function(){return _0xeee14a;});})[_0x712d('0x25')](function(){_0x14cc11['status'](0xcc)[_0x712d('0x1b')]();});}};}function handleEntityNotFound(_0x81948b,_0x24a57a){return function(_0x5ba8c2){if(!_0x5ba8c2){_0x81948b[_0x712d('0x1a')](0x194);}return _0x5ba8c2;};}function handleError(_0x3e47b9,_0x584b2d){_0x584b2d=_0x584b2d||0x1f4;return function(_0x3413c9){logger[_0x712d('0x2a')](_0x3413c9[_0x712d('0x2b')]);if(_0x3413c9[_0x712d('0x2c')]){delete _0x3413c9['name'];}_0x3e47b9[_0x712d('0x1c')](_0x584b2d)[_0x712d('0x2d')](_0x3413c9);};}exports[_0x712d('0x2e')]=function(_0x4eff82,_0x571808){var _0x603472={},_0x316818={},_0x373d41={'count':0x0,'rows':[]};var _0x256881=_[_0x712d('0x2f')](db[_0x712d('0x30')]['rawAttributes'],function(_0x505064){return{'name':_0x505064[_0x712d('0x31')],'type':_0x505064[_0x712d('0x32')][_0x712d('0x33')]};});_0x316818[_0x712d('0x34')]=_[_0x712d('0x2f')](_0x256881,_0x712d('0x2c'));_0x316818[_0x712d('0x35')]=_[_0x712d('0x36')](_0x4eff82[_0x712d('0x35')]);_0x316818[_0x712d('0x37')]=_[_0x712d('0x38')](_0x316818[_0x712d('0x34')],_0x316818[_0x712d('0x35')]);_0x603472[_0x712d('0x39')]=_[_0x712d('0x38')](_0x316818['model'],qs[_0x712d('0x3a')](_0x4eff82[_0x712d('0x35')]['fields']));_0x603472[_0x712d('0x39')]=_0x603472[_0x712d('0x39')]['length']?_0x603472['attributes']:_0x316818[_0x712d('0x34')];if(!_0x4eff82[_0x712d('0x35')]['hasOwnProperty'](_0x712d('0x3b'))){_0x603472[_0x712d('0x1f')]=qs['limit'](_0x4eff82['query'][_0x712d('0x1f')]);_0x603472[_0x712d('0x1e')]=qs['offset'](_0x4eff82['query'][_0x712d('0x1e')]);}_0x603472[_0x712d('0x3c')]=qs[_0x712d('0x3d')](_0x4eff82[_0x712d('0x35')][_0x712d('0x3d')]);_0x603472[_0x712d('0x3e')]=qs[_0x712d('0x37')](_[_0x712d('0x3f')](_0x4eff82['query'],_0x316818[_0x712d('0x37')]),_0x256881);if(_0x4eff82[_0x712d('0x35')]['filter']){_0x603472[_0x712d('0x3e')]=_[_0x712d('0x40')](_0x603472[_0x712d('0x3e')],{'$or':_[_0x712d('0x2f')](_0x256881,function(_0x20138b){if(_0x20138b[_0x712d('0x32')]!==_0x712d('0x41')){var _0x2cbbbc={};_0x2cbbbc[_0x20138b[_0x712d('0x2c')]]={'$like':'%'+_0x4eff82[_0x712d('0x35')]['filter']+'%'};return _0x2cbbbc;}})});}_0x603472=_[_0x712d('0x40')]({},_0x603472,_0x4eff82['options']);var _0x362383={'where':_0x603472[_0x712d('0x3e')]};return db[_0x712d('0x30')][_0x712d('0x1d')](_0x362383)['then'](function(_0x1d0ca2){_0x373d41[_0x712d('0x1d')]=_0x1d0ca2;if(_0x4eff82[_0x712d('0x35')][_0x712d('0x42')]){_0x603472['include']=[{'all':!![]}];}return db[_0x712d('0x30')]['findAll'](_0x603472);})[_0x712d('0x25')](function(_0x388efa){_0x373d41[_0x712d('0x43')]=_0x388efa;return _0x373d41;})[_0x712d('0x25')](respondWithFilteredResult(_0x571808,_0x603472))[_0x712d('0x44')](handleError(_0x571808,null));};exports[_0x712d('0x45')]=function(_0x4dec7a,_0x1de976){var _0x2ea794={'raw':!![],'where':{'id':_0x4dec7a[_0x712d('0x46')]['id']}},_0x2b4fb9={};_0x2b4fb9[_0x712d('0x34')]=_['keys'](db[_0x712d('0x30')][_0x712d('0x47')]);_0x2b4fb9[_0x712d('0x35')]=_['keys'](_0x4dec7a[_0x712d('0x35')]);_0x2b4fb9['filters']=_[_0x712d('0x38')](_0x2b4fb9[_0x712d('0x34')],_0x2b4fb9['query']);_0x2ea794['attributes']=_[_0x712d('0x38')](_0x2b4fb9[_0x712d('0x34')],qs[_0x712d('0x3a')](_0x4dec7a[_0x712d('0x35')][_0x712d('0x3a')]));_0x2ea794[_0x712d('0x39')]=_0x2ea794[_0x712d('0x39')][_0x712d('0x48')]?_0x2ea794[_0x712d('0x39')]:_0x2b4fb9['model'];if(_0x4dec7a[_0x712d('0x35')][_0x712d('0x42')]){_0x2ea794[_0x712d('0x49')]=[{'all':!![]}];}_0x2ea794=_[_0x712d('0x40')]({},_0x2ea794,_0x4dec7a['options']);return db[_0x712d('0x30')]['find'](_0x2ea794)['then'](handleEntityNotFound(_0x1de976,null))['then'](respondWithResult(_0x1de976,null))[_0x712d('0x44')](handleError(_0x1de976,null));};exports[_0x712d('0x4a')]=function(_0x5e08e6,_0x934c87){return db[_0x712d('0x30')][_0x712d('0x4a')](_0x5e08e6[_0x712d('0x4b')],{})[_0x712d('0x25')](function(_0x23d1eb){var _0x3a9d96=_0x5e08e6['user'][_0x712d('0x27')]({'plain':!![]});if(!_0x3a9d96)throw new Error(_0x712d('0x4c'));if(_0x3a9d96['role']===_0x712d('0x4d')){var _0x3a4aef=_0x23d1eb[_0x712d('0x27')]({'plain':!![]});var _0x4570cd=_0x712d('0x4e');return db['UserProfileSection']['find']({'where':{'name':_0x4570cd,'userProfileId':_0x3a9d96['userProfileId']},'raw':!![]})[_0x712d('0x25')](function(_0x137880){if(_0x137880&&_0x137880[_0x712d('0x4f')]===0x0){return db[_0x712d('0x29')][_0x712d('0x4a')]({'name':_0x3a4aef[_0x712d('0x2c')],'resourceId':_0x3a4aef['id'],'type':_0x712d('0x28'),'sectionId':_0x137880['id']},{})['then'](function(){return _0x23d1eb;});}else{return _0x23d1eb;}})['catch'](function(_0x2c34f9){logger['error'](_0x712d('0x50'),_0x2c34f9);throw _0x2c34f9;});}return _0x23d1eb;})['then'](respondWithResult(_0x934c87,0xc9))[_0x712d('0x44')](handleError(_0x934c87,null));};exports[_0x712d('0x24')]=function(_0x21f779,_0x1624e8){if(_0x21f779[_0x712d('0x4b')]['id']){delete _0x21f779['body']['id'];}return db[_0x712d('0x30')][_0x712d('0x51')]({'where':{'id':_0x21f779[_0x712d('0x46')]['id']}})[_0x712d('0x25')](handleEntityNotFound(_0x1624e8,null))[_0x712d('0x25')](saveUpdates(_0x21f779[_0x712d('0x4b')],null))['then'](respondWithResult(_0x1624e8,null))['catch'](handleError(_0x1624e8,null));};exports['destroy']=function(_0x3a557b,_0x2d2d1c){return db[_0x712d('0x30')][_0x712d('0x51')]({'where':{'id':_0x3a557b[_0x712d('0x46')]['id']}})[_0x712d('0x25')](handleEntityNotFound(_0x2d2d1c,null))[_0x712d('0x25')](removeEntity(_0x2d2d1c,null))[_0x712d('0x44')](handleError(_0x2d2d1c,null));};exports[_0x712d('0x52')]=function(_0x3eab6c,_0x3bf3aa){var _0x274424=0xa;var _0x3e5ca2=['join',_0x712d('0x53'),'right_join',_0x712d('0x54')];var _0x10a9d8={'SUM':'SUM(%s)','COUNT':_0x712d('0x55'),'COUNT DISTINCT':_0x712d('0x56'),'MAX':_0x712d('0x57'),'MIN':_0x712d('0x58'),'AVG':_0x712d('0x59'),'GROUP_CONCAT':_0x712d('0x5a'),'GROUP_CONCAT ASC':_0x712d('0x5b'),'GROUP_CONCAT DESC':_0x712d('0x5c')};var _0x40f3d8={'SEC_TO_TIME':_0x712d('0x5d'),'DATE':_0x712d('0x5e'),'HOUR':_0x712d('0x5f'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x712d('0x60')};var _0x3bd94d=function(_0x29d615){return!_[_0x712d('0x61')]([_0x712d('0x62'),_0x712d('0x63'),_0x712d('0x64'),_0x712d('0x65')],_0x29d615);};var _0x247592=function(_0x5b0af8){if(!_0x5b0af8||!_0x5b0af8[_0x712d('0x66')][_0x712d('0x48')]){return'';}for(var _0x1db001='(',_0x111237=0x0;_0x111237<_0x5b0af8[_0x712d('0x66')][_0x712d('0x48')];_0x111237+=0x1){_0x111237>0x0&&(_0x1db001+='\x20'+_0x5b0af8[_0x712d('0x67')]+'\x20');_0x1db001+=_0x5b0af8['rules'][_0x111237]['group']?_0x247592(_0x5b0af8[_0x712d('0x66')][_0x111237][_0x712d('0x68')]):_0x5b0af8[_0x712d('0x66')][_0x111237]['field']+'\x20'+_0x5b0af8[_0x712d('0x66')][_0x111237]['condition']+(_0x3bd94d(_0x5b0af8[_0x712d('0x66')][_0x111237][_0x712d('0x69')])?'\x20'+_0x5b0af8[_0x712d('0x66')][_0x111237][_0x712d('0x6a')]:'');}return _0x1db001+')';};var _0x183994={'where':{'id':_0x3eab6c[_0x712d('0x46')]['id']}},_0x350285,_0x98a947,_0x40a33c,_0x39428e,_0xdc8c26;_0x183994=_['merge']({},_0x183994,_0x3eab6c['options']);return db['AnalyticDefaultReport'][_0x712d('0x51')](_0x183994)[_0x712d('0x25')](function(_0x506b4f){if(_0x506b4f){_0x350285=_0x506b4f;return _0x506b4f[_0x712d('0x6b')]();}return null;})['then'](function(_0x468598){if(_0x468598){if(!_0x468598[_0x712d('0x48')]){throw new db[(_0x712d('0x6c'))]['ValidationErrorItem'](_0x712d('0x6d'),0x193);}_0x98a947=_0x468598;return db[_0x712d('0x6e')][_0x712d('0x6f')]({'raw':!![]});}return null;})[_0x712d('0x25')](function(_0xd1e460){if(_0xd1e460){_0x40a33c=_['keyBy'](_0xd1e460,'id');var _0x626455;var _0x4af801=squel[_0x712d('0x70')]();_0x4af801[_0x712d('0x71')](_0x350285[_0x712d('0x72')]);for(var _0x1679d7=0x0;_0x1679d7<_0x98a947[_0x712d('0x48')];_0x1679d7+=0x1){_0x626455=_0x98a947[_0x1679d7][_0x712d('0x73')]?_0x40a33c[_0x98a947[_0x1679d7][_0x712d('0x73')]][_0x712d('0x74')]:_0x98a947[_0x1679d7][_0x712d('0x75')];_0x626455=_0x98a947[_0x1679d7][_0x712d('0x76')]?_[_0x712d('0x77')](_0x10a9d8[_0x98a947[_0x1679d7]['function']],'%s',_0x626455):_0x626455;_0x626455=_0x98a947[_0x1679d7][_0x712d('0x78')]?_[_0x712d('0x77')](_0x40f3d8[_0x98a947[_0x1679d7][_0x712d('0x78')]],'%s',_0x626455):_0x626455;if(_0x98a947[_0x1679d7][_0x712d('0x79')]){_0x4af801['group'](_0x626455);}_0x98a947[_0x1679d7][_0x712d('0x7a')]&&_0x4af801[_0x712d('0x3c')](_0x626455,_0x98a947[_0x1679d7]['orderBy']===_0x712d('0x7b')?![]:!![]);_0x4af801[_0x712d('0x75')](_0x626455,_0x98a947[_0x1679d7][_0x712d('0x7c')]||_0x626455);}if(_0x350285[_0x712d('0x7d')]){_0x350285[_0x712d('0x7d')]=JSON[_0x712d('0x7e')](_0x350285['joins']);for(var _0x44fbe9=0x0;_0x44fbe9<_0x350285['joins'][_0x712d('0x48')];_0x44fbe9+=0x1){if(_0x350285['joins'][_0x44fbe9]['type']&&_['includes'](_0x3e5ca2,_0x350285[_0x712d('0x7d')][_0x44fbe9][_0x712d('0x32')])&&_0x350285[_0x712d('0x7d')][_0x44fbe9]['parentKey']&&_0x350285[_0x712d('0x7d')][_0x44fbe9][_0x712d('0x7f')]&&_0x350285[_0x712d('0x7d')][_0x44fbe9][_0x712d('0x80')]){_0x4af801[_0x350285[_0x712d('0x7d')][_0x44fbe9][_0x712d('0x32')]](_0x350285['joins'][_0x44fbe9]['foreignTable'],null,util['format'](_0x712d('0x81'),_0x350285[_0x712d('0x72')],_0x350285[_0x712d('0x7d')][_0x44fbe9][_0x712d('0x82')],_0x350285['joins'][_0x44fbe9][_0x712d('0x7f')],_0x350285[_0x712d('0x7d')][_0x44fbe9]['foreignKey']));}}}if(_0x350285[_0x712d('0x83')]){_0x350285[_0x712d('0x83')]=JSON[_0x712d('0x7e')](_0x350285['conditions']);_0x4af801[_0x712d('0x3e')](_0x247592(_0x350285['conditions'][_0x712d('0x68')]));}_0xdc8c26=_0x4af801['clone']();_0x4af801[_0x712d('0x1f')](_0x274424);_0x4af801[_0x712d('0x1e')](0x0);logger['debug'](_0x712d('0x84'),_0x4af801[_0x712d('0x85')]());return dbH[_0x712d('0x86')][_0x712d('0x35')](_0x4af801[_0x712d('0x85')](),{'type':dbH[_0x712d('0x86')][_0x712d('0x87')]['SELECT']});}})[_0x712d('0x25')](respondWithResult(_0x3bf3aa,null))[_0x712d('0x44')](handleError(_0x3bf3aa,null));};function runReport(_0x4a0c58,_0x40644a,_0x1b2993){var _0x411e75=_0x40644a['name'];var _0x2b5855=0xa;var _0x137118=[_0x712d('0x88'),_0x712d('0x53'),_0x712d('0x89'),_0x712d('0x54')];var _0x4c19b9={'SUM':_0x712d('0x8a'),'COUNT':_0x712d('0x55'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':'MAX(%s)','MIN':_0x712d('0x58'),'AVG':_0x712d('0x59'),'GROUP_CONCAT':_0x712d('0x5a'),'GROUP_CONCAT ASC':_0x712d('0x5b'),'GROUP_CONCAT DESC':_0x712d('0x5c')};var _0x7b7e4e={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':_0x712d('0x8b'),'UNIX_TIMESTAMP':_0x712d('0x60')};var _0x531134=function(_0x8b2f32){return!_[_0x712d('0x61')]([_0x712d('0x62'),_0x712d('0x63'),_0x712d('0x64'),_0x712d('0x65')],_0x8b2f32);};var _0x72a904=function(_0x4cd961){if(!_0x4cd961||!_0x4cd961[_0x712d('0x66')]['length']){return'';}for(var _0x3ee240='(',_0x3e4041=0x0;_0x3e4041<_0x4cd961[_0x712d('0x66')][_0x712d('0x48')];_0x3e4041+=0x1){_0x3e4041>0x0&&(_0x3ee240+='\x20'+_0x4cd961[_0x712d('0x67')]+'\x20');_0x3ee240+=_0x4cd961['rules'][_0x3e4041][_0x712d('0x68')]?_0x72a904(_0x4cd961['rules'][_0x3e4041][_0x712d('0x68')]):_0x4cd961[_0x712d('0x66')][_0x3e4041][_0x712d('0x75')]+'\x20'+_0x4cd961[_0x712d('0x66')][_0x3e4041]['condition']+(_0x531134(_0x4cd961[_0x712d('0x66')][_0x3e4041][_0x712d('0x69')])?'\x20'+_0x4cd961[_0x712d('0x66')][_0x3e4041][_0x712d('0x6a')]:'');}return _0x3ee240+')';};var _0x5a3d7b={'where':{'id':_0x4a0c58['id']}},_0x3ef9de,_0xb1d783,_0x11acfd,_0xb4170,_0x3aacae;_0x5a3d7b=_[_0x712d('0x40')]({},_0x5a3d7b,_0x1b2993);return db[_0x712d('0x30')][_0x712d('0x51')](_0x5a3d7b)[_0x712d('0x25')](function(_0x79f29a){if(_0x79f29a){_0x3ef9de=_0x79f29a;return _0x79f29a['getFields']();}return null;})[_0x712d('0x25')](function(_0x45ae9a){if(_0x45ae9a){if(!_0x45ae9a[_0x712d('0x48')]){throw new db[(_0x712d('0x6c'))][(_0x712d('0x8c'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0xb1d783=_0x45ae9a;return db[_0x712d('0x6e')]['findAll']({'raw':!![]});}return null;})[_0x712d('0x25')](function(_0x123f83){if(_0x123f83){_0x11acfd=_['keyBy'](_0x123f83,'id');var _0x31c089;var _0x89104f=squel['select']();_0x89104f[_0x712d('0x71')](_0x3ef9de['table']);for(var _0x3dac52=0x0;_0x3dac52<_0xb1d783[_0x712d('0x48')];_0x3dac52+=0x1){_0x31c089=_0xb1d783[_0x3dac52]['MetricId']?_0x11acfd[_0xb1d783[_0x3dac52][_0x712d('0x73')]][_0x712d('0x74')]:_0xb1d783[_0x3dac52][_0x712d('0x75')];_0x31c089=_0xb1d783[_0x3dac52][_0x712d('0x76')]?_[_0x712d('0x77')](_0x4c19b9[_0xb1d783[_0x3dac52]['function']],'%s',_0x31c089):_0x31c089;_0x31c089=_0xb1d783[_0x3dac52]['format']?_[_0x712d('0x77')](_0x7b7e4e[_0xb1d783[_0x3dac52][_0x712d('0x78')]],'%s',_0x31c089):_0x31c089;if(_0xb1d783[_0x3dac52][_0x712d('0x79')]){_0x89104f[_0x712d('0x68')](_0x31c089);}_0xb1d783[_0x3dac52][_0x712d('0x7a')]&&_0x89104f['order'](_0x31c089,_0xb1d783[_0x3dac52][_0x712d('0x7a')]===_0x712d('0x7b')?![]:!![]);_0x89104f[_0x712d('0x75')](_0x31c089,_0xb1d783[_0x3dac52][_0x712d('0x7c')]||_0x31c089);}if(_0x3ef9de[_0x712d('0x7d')]){_0x3ef9de[_0x712d('0x7d')]=JSON[_0x712d('0x7e')](_0x3ef9de[_0x712d('0x7d')]);for(var _0x13468c=0x0;_0x13468c<_0x3ef9de[_0x712d('0x7d')]['length'];_0x13468c+=0x1){if(_0x3ef9de[_0x712d('0x7d')][_0x13468c]['type']&&_[_0x712d('0x61')](_0x137118,_0x3ef9de[_0x712d('0x7d')][_0x13468c]['type'])&&_0x3ef9de[_0x712d('0x7d')][_0x13468c][_0x712d('0x82')]&&_0x3ef9de[_0x712d('0x7d')][_0x13468c][_0x712d('0x7f')]&&_0x3ef9de[_0x712d('0x7d')][_0x13468c][_0x712d('0x80')]){_0x89104f[_0x3ef9de[_0x712d('0x7d')][_0x13468c][_0x712d('0x32')]](_0x3ef9de['joins'][_0x13468c][_0x712d('0x7f')],null,util['format'](_0x712d('0x81'),_0x3ef9de['table'],_0x3ef9de['joins'][_0x13468c]['parentKey'],_0x3ef9de['joins'][_0x13468c][_0x712d('0x7f')],_0x3ef9de['joins'][_0x13468c][_0x712d('0x80')]));}}}if(_0x3ef9de[_0x712d('0x83')]){_0x3ef9de[_0x712d('0x83')]=JSON[_0x712d('0x7e')](_0x3ef9de[_0x712d('0x83')]);_0x89104f[_0x712d('0x3e')](_0x72a904(_0x3ef9de[_0x712d('0x83')][_0x712d('0x68')]));}_0x3aacae=_0x89104f['clone']();_0x89104f[_0x712d('0x1f')](_0x2b5855);_0x89104f['offset'](0x0);return;}})[_0x712d('0x25')](function(){if(_0x40644a[_0x712d('0x8d')]==='web'){return null;}var _0x17e07a=_[_0x712d('0x40')](_0x40644a,{'name':_0x40644a[_0x712d('0x8e')]||_0x40644a[_0x712d('0x2c')]||_0x3ef9de[_0x712d('0x2c')],'basename':_0x411e75,'savename':util[_0x712d('0x78')](_0x712d('0x8f'),_0x40644a[_0x712d('0x2c')]||_0x3ef9de[_0x712d('0x2c')],require(_0x712d('0x90'))[_0x712d('0x91')](0x4),_0x40644a['output']||'csv'),'reportId':_0x3ef9de['id'],'reportType':_0x712d('0x92')});return db['AnalyticExtractedReport'][_0x712d('0x4a')](_0x17e07a,{'raw':!![]});})[_0x712d('0x25')](function(_0x511449){if(_0x3ef9de[_0x712d('0x72')]===_0x712d('0x93')){_0x3aacae[_0x712d('0x3e')](_0x3ef9de[_0x712d('0x72')]+_0x712d('0x94'),_0x40644a['startDate'],_0x40644a[_0x712d('0x95')]);}else{_0x3aacae[_0x712d('0x3e')](_0x3ef9de[_0x712d('0x72')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x40644a['startDate'],_0x40644a[_0x712d('0x95')]);}if(_0x511449){logger[_0x712d('0x96')]('Run\x20Query:',_0x3aacae[_0x712d('0x85')]());require(_0x712d('0x97'))[_0x712d('0x98')](path['join'](__dirname,'../../components/export/',_0x511449[_0x712d('0x8d')]),[_0x511449['id'],_0x3aacae[_0x712d('0x85')](),path['join'](__dirname,_0x712d('0x99'),_0x511449[_0x712d('0x9a')]),_0x411e75]);return _0x511449;}else{var _0x95667d=squel['select']();_0x95667d[_0x712d('0x71')]('('+_0x3aacae['toString']()+')',_0x712d('0x9b'));_0x95667d[_0x712d('0x75')]('COUNT(*)','count');_0x3aacae['limit'](_0x40644a[_0x712d('0x1f')]||_0x2b5855);_0x3aacae[_0x712d('0x1e')](_0x40644a[_0x712d('0x1e')]||0x0);return dbH[_0x712d('0x86')][_0x712d('0x35')](_0x95667d[_0x712d('0x85')](),{'type':dbH[_0x712d('0x86')][_0x712d('0x87')]['SELECT']})[_0x712d('0x25')](function(_0x33d3fd){if(!_0x33d3fd[_0x712d('0x48')]){_0xb4170=0x0;}else{_0xb4170=_0x33d3fd[0x0][_0x712d('0x1d')]||0x0;}return dbH['sequelize'][_0x712d('0x35')](_0x3aacae[_0x712d('0x85')](),{'type':dbH[_0x712d('0x86')][_0x712d('0x87')]['SELECT']});})[_0x712d('0x25')](function(_0x760279){return{'rows':_0x760279||[],'count':_0xb4170};});}});}exports[_0x712d('0x9c')]=function(_0x2d3e55,_0x162e59){return runReport(_0x2d3e55[_0x712d('0x46')],_0x2d3e55[_0x712d('0x35')],_0x2d3e55[_0x712d('0x9d')])[_0x712d('0x25')](respondWithResult(_0x162e59,null))[_0x712d('0x44')](handleError(_0x162e59,null));};exports['runReport']=runReport;exports['query']=function(_0x1ed723,_0x34d624){var _0x5a6c91=0xa;var _0x5e18cb=[_0x712d('0x88'),_0x712d('0x53'),_0x712d('0x89'),_0x712d('0x54')];var _0x269f7e={'SUM':_0x712d('0x8a'),'COUNT':_0x712d('0x55'),'COUNT DISTINCT':_0x712d('0x56'),'MAX':_0x712d('0x57'),'MIN':_0x712d('0x58'),'AVG':'AVG(%s)','GROUP_CONCAT':_0x712d('0x5a'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0x712d('0x5c')};var _0x846231={'SEC_TO_TIME':_0x712d('0x5d'),'DATE':_0x712d('0x5e'),'HOUR':_0x712d('0x5f'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x712d('0x60')};var _0x1a0d08=function(_0x1eb849){return!_[_0x712d('0x61')]([_0x712d('0x62'),_0x712d('0x63'),'IS\x20EMPTY',_0x712d('0x65')],_0x1eb849);};var _0x58f32d=function(_0x1d6ad6){if(!_0x1d6ad6||!_0x1d6ad6[_0x712d('0x66')][_0x712d('0x48')]){return'';}for(var _0x2a6824='(',_0x19b394=0x0;_0x19b394<_0x1d6ad6[_0x712d('0x66')][_0x712d('0x48')];_0x19b394+=0x1){_0x19b394>0x0&&(_0x2a6824+='\x20'+_0x1d6ad6[_0x712d('0x67')]+'\x20');_0x2a6824+=_0x1d6ad6[_0x712d('0x66')][_0x19b394][_0x712d('0x68')]?_0x58f32d(_0x1d6ad6[_0x712d('0x66')][_0x19b394][_0x712d('0x68')]):_0x1d6ad6['rules'][_0x19b394]['field']+'\x20'+_0x1d6ad6[_0x712d('0x66')][_0x19b394][_0x712d('0x69')]+(_0x1a0d08(_0x1d6ad6[_0x712d('0x66')][_0x19b394][_0x712d('0x69')])?'\x20'+_0x1d6ad6['rules'][_0x19b394]['value']:'');}return _0x2a6824+')';};var _0x7d568a={'where':{'id':_0x1ed723['params']['id']}},_0x268875,_0x1c02f8,_0x45597e,_0x1acd0a,_0x5b5138;_0x7d568a=_['merge']({},_0x7d568a,_0x1ed723[_0x712d('0x9d')]);return db[_0x712d('0x30')][_0x712d('0x51')](_0x7d568a)[_0x712d('0x25')](function(_0x2ac2fd){if(_0x2ac2fd){_0x268875=_0x2ac2fd;return _0x2ac2fd['getFields']();}return null;})[_0x712d('0x25')](function(_0x38e6e1){if(_0x38e6e1){if(!_0x38e6e1[_0x712d('0x48')]){throw new db[(_0x712d('0x6c'))][(_0x712d('0x8c'))](_0x712d('0x6d'),0x193);}_0x1c02f8=_0x38e6e1;return db['AnalyticMetric'][_0x712d('0x6f')]({'raw':!![]});}return null;})['then'](function(_0x5ea048){if(_0x5ea048){_0x45597e=_[_0x712d('0x9e')](_0x5ea048,'id');var _0x59f234;var _0x236b7a=squel['select']();_0x236b7a[_0x712d('0x71')](_0x268875[_0x712d('0x72')]);for(var _0x2e827c=0x0;_0x2e827c<_0x1c02f8['length'];_0x2e827c+=0x1){_0x59f234=_0x1c02f8[_0x2e827c]['MetricId']?_0x45597e[_0x1c02f8[_0x2e827c][_0x712d('0x73')]][_0x712d('0x74')]:_0x1c02f8[_0x2e827c][_0x712d('0x75')];_0x59f234=_0x1c02f8[_0x2e827c][_0x712d('0x76')]?_[_0x712d('0x77')](_0x269f7e[_0x1c02f8[_0x2e827c]['function']],'%s',_0x59f234):_0x59f234;_0x59f234=_0x1c02f8[_0x2e827c]['format']?_['replace'](_0x846231[_0x1c02f8[_0x2e827c]['format']],'%s',_0x59f234):_0x59f234;if(_0x1c02f8[_0x2e827c][_0x712d('0x79')]){_0x236b7a[_0x712d('0x68')](_0x59f234);}_0x1c02f8[_0x2e827c]['orderBy']&&_0x236b7a['order'](_0x59f234,_0x1c02f8[_0x2e827c]['orderBy']===_0x712d('0x7b')?![]:!![]);_0x236b7a[_0x712d('0x75')](_0x59f234,_0x1c02f8[_0x2e827c]['alias']||_0x59f234);}if(_0x268875[_0x712d('0x7d')]){_0x268875['joins']=JSON[_0x712d('0x7e')](_0x268875[_0x712d('0x7d')]);for(var _0x54c3cb=0x0;_0x54c3cb<_0x268875['joins'][_0x712d('0x48')];_0x54c3cb+=0x1){if(_0x268875[_0x712d('0x7d')][_0x54c3cb][_0x712d('0x32')]&&_[_0x712d('0x61')](_0x5e18cb,_0x268875[_0x712d('0x7d')][_0x54c3cb][_0x712d('0x32')])&&_0x268875[_0x712d('0x7d')][_0x54c3cb][_0x712d('0x82')]&&_0x268875['joins'][_0x54c3cb][_0x712d('0x7f')]&&_0x268875[_0x712d('0x7d')][_0x54c3cb][_0x712d('0x80')]){_0x236b7a[_0x268875['joins'][_0x54c3cb]['type']](_0x268875[_0x712d('0x7d')][_0x54c3cb][_0x712d('0x7f')],null,util[_0x712d('0x78')](_0x712d('0x81'),_0x268875[_0x712d('0x72')],_0x268875[_0x712d('0x7d')][_0x54c3cb][_0x712d('0x82')],_0x268875[_0x712d('0x7d')][_0x54c3cb][_0x712d('0x7f')],_0x268875[_0x712d('0x7d')][_0x54c3cb][_0x712d('0x80')]));}}}if(_0x268875[_0x712d('0x83')]){_0x268875['conditions']=JSON['parse'](_0x268875['conditions']);_0x236b7a['where'](_0x58f32d(_0x268875['conditions'][_0x712d('0x68')]));}_0x5b5138=_0x236b7a[_0x712d('0x9f')]();_0x236b7a[_0x712d('0x1f')](_0x5a6c91);_0x236b7a['offset'](0x0);logger[_0x712d('0xa0')](_0x712d('0x84'),_0x236b7a[_0x712d('0x85')]());return dbH['sequelize'][_0x712d('0x35')](_0x236b7a[_0x712d('0x85')](),{'type':dbH[_0x712d('0x86')][_0x712d('0x87')][_0x712d('0xa1')]});}})['then'](function(){return{'sql':_0x5b5138[_0x712d('0x85')]()};})['then'](respondWithResult(_0x34d624,null))[_0x712d('0x44')](handleError(_0x34d624,null));};
\ No newline at end of file
+var _0x8cb8=['html-pdf','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','path','sox','squel','crypto','jsforce','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','limit','set','apply','reject','save','update','then','get','DefaultReports','UserProfileResource','destroy','error','stack','name','send','map','AnalyticDefaultReport','rawAttributes','fieldName','type','key','model','query','filters','attributes','intersection','fields','length','hasOwnProperty','nolimit','sort','where','pick','filter','merge','VIRTUAL','options','includeAll','findAll','rows','show','params','keys','include','find','catch','create','body','user','Reports','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','preview','join','right_join','cross_join','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','HOUR(%s)','ROUND(%s)','includes','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','keyBy','select','from','MetricId','metric','function','replace','format','groupBy','order','orderBy','DESC','alias','joins','parentKey','foreignKey','foreignTable','table','conditions','parse','clone','debug','toString','sequelize','QueryTypes','SELECT','left_join','SUM(%s)','GROUP_CONCAT(%s)','DATE(%s)','UNIX_TIMESTAMP(%s)','IS\x20NULL','value','AnalyticMetric','%s.%s\x20=\x20%s.%s','output','web','fullPath','%s-%s.%s','randomstring','generate','default','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','Run\x20Query:','child_process','fork','../../components/export/','../../files/reports','savename','COUNT(*)','count','run','runReport'];(function(_0x5e27f2,_0x434e8d){var _0x51f4c6=function(_0x2fdcbe){while(--_0x2fdcbe){_0x5e27f2['push'](_0x5e27f2['shift']());}};_0x51f4c6(++_0x434e8d);}(_0x8cb8,0xa8));var _0x88cb=function(_0x9e0cb3,_0x9cd497){_0x9e0cb3=_0x9e0cb3-0x0;var _0x5926b7=_0x8cb8[_0x9e0cb3];return _0x5926b7;};'use strict';var pdf=require(_0x88cb('0x0'));var emlformat=require('eml-format');var rimraf=require(_0x88cb('0x1'));var zipdir=require(_0x88cb('0x2'));var jsonpatch=require(_0x88cb('0x3'));var rp=require(_0x88cb('0x4'));var moment=require('moment');var BPromise=require(_0x88cb('0x5'));var Mustache=require(_0x88cb('0x6'));var util=require(_0x88cb('0x7'));var path=require(_0x88cb('0x8'));var sox=require(_0x88cb('0x9'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var _=require('lodash');var squel=require(_0x88cb('0xa'));var crypto=require(_0x88cb('0xb'));var jsforce=require(_0x88cb('0xc'));var deskjs=require('desk.js');var toCsv=require(_0x88cb('0xd'));var querystring=require(_0x88cb('0xe'));var Papa=require(_0x88cb('0xf'));var Redis=require(_0x88cb('0x10'));var authService=require(_0x88cb('0x11'));var qs=require(_0x88cb('0x12'));var as=require(_0x88cb('0x13'));var hardwareService=require(_0x88cb('0x14'));var logger=require(_0x88cb('0x15'))(_0x88cb('0x16'));var utils=require(_0x88cb('0x17'));var config=require(_0x88cb('0x18'));var licenseUtil=require(_0x88cb('0x19'));var db=require('../../mysqldb')['db'];var dbH=require(_0x88cb('0x1a'))['dbH'];function respondWithStatusCode(_0x5aca59,_0x871f91){_0x871f91=_0x871f91||0xcc;return function(_0x5253a4){if(_0x5253a4){return _0x5aca59[_0x88cb('0x1b')](_0x871f91);}return _0x5aca59[_0x88cb('0x1c')](_0x871f91)[_0x88cb('0x1d')]();};}function respondWithResult(_0x11a3f3,_0x516e27){_0x516e27=_0x516e27||0xc8;return function(_0x54fdb7){if(_0x54fdb7){return _0x11a3f3[_0x88cb('0x1c')](_0x516e27)[_0x88cb('0x1e')](_0x54fdb7);}};}function respondWithFilteredResult(_0x4aa05a,_0x26576f){return function(_0xebfad7){if(_0xebfad7){var _0x3dc46f=_0xebfad7['count'],_0x5a5d96=_0x26576f['offset'],_0x57be73=_0x26576f[_0x88cb('0x1f')]+_0x26576f[_0x88cb('0x20')],_0x515bf1;if(_0x57be73>=_0x3dc46f){_0x57be73=_0x3dc46f;_0x515bf1=0xc8;}else{_0x515bf1=0xce;}_0x4aa05a['status'](_0x515bf1);return _0x4aa05a[_0x88cb('0x21')]('Content-Range',_0x5a5d96+'-'+_0x57be73+'/'+_0x3dc46f)['json'](_0xebfad7);}return null;};}function patchUpdates(_0x4cbec5){return function(_0x1e468e){try{jsonpatch[_0x88cb('0x22')](_0x1e468e,_0x4cbec5,!![]);}catch(_0x24a3a5){return BPromise[_0x88cb('0x23')](_0x24a3a5);}return _0x1e468e[_0x88cb('0x24')]();};}function saveUpdates(_0x34dd10,_0x1e5061){return function(_0x1f3740){if(_0x1f3740){return _0x1f3740[_0x88cb('0x25')](_0x34dd10)[_0x88cb('0x26')](function(_0x20fd83){return _0x20fd83;});}return null;};}function removeEntity(_0x231aee,_0xef70fe){return function(_0x3996c0){if(_0x3996c0){return _0x3996c0['destroy']()[_0x88cb('0x26')](function(){var _0x2fa769=_0x3996c0[_0x88cb('0x27')]({'plain':!![]});var _0x5f1a48=_0x88cb('0x28');return db[_0x88cb('0x29')][_0x88cb('0x2a')]({'where':{'type':_0x5f1a48,'resourceId':_0x2fa769['id']}})['then'](function(){return _0x3996c0;});})['then'](function(){_0x231aee[_0x88cb('0x1c')](0xcc)[_0x88cb('0x1d')]();});}};}function handleEntityNotFound(_0xc338f6,_0x129903){return function(_0x4db179){if(!_0x4db179){_0xc338f6[_0x88cb('0x1b')](0x194);}return _0x4db179;};}function handleError(_0x32da7f,_0x46b472){_0x46b472=_0x46b472||0x1f4;return function(_0x1d54aa){logger[_0x88cb('0x2b')](_0x1d54aa[_0x88cb('0x2c')]);if(_0x1d54aa[_0x88cb('0x2d')]){delete _0x1d54aa[_0x88cb('0x2d')];}_0x32da7f[_0x88cb('0x1c')](_0x46b472)[_0x88cb('0x2e')](_0x1d54aa);};}exports['index']=function(_0x2ab08b,_0x2667b6){var _0x59b9f0={},_0x42b3a8={},_0x5869a0={'count':0x0,'rows':[]};var _0x3b1f6a=_[_0x88cb('0x2f')](db[_0x88cb('0x30')][_0x88cb('0x31')],function(_0x62f864){return{'name':_0x62f864[_0x88cb('0x32')],'type':_0x62f864[_0x88cb('0x33')][_0x88cb('0x34')]};});_0x42b3a8[_0x88cb('0x35')]=_[_0x88cb('0x2f')](_0x3b1f6a,_0x88cb('0x2d'));_0x42b3a8[_0x88cb('0x36')]=_['keys'](_0x2ab08b[_0x88cb('0x36')]);_0x42b3a8[_0x88cb('0x37')]=_['intersection'](_0x42b3a8[_0x88cb('0x35')],_0x42b3a8[_0x88cb('0x36')]);_0x59b9f0[_0x88cb('0x38')]=_[_0x88cb('0x39')](_0x42b3a8[_0x88cb('0x35')],qs[_0x88cb('0x3a')](_0x2ab08b[_0x88cb('0x36')]['fields']));_0x59b9f0[_0x88cb('0x38')]=_0x59b9f0[_0x88cb('0x38')][_0x88cb('0x3b')]?_0x59b9f0[_0x88cb('0x38')]:_0x42b3a8['model'];if(!_0x2ab08b[_0x88cb('0x36')][_0x88cb('0x3c')](_0x88cb('0x3d'))){_0x59b9f0['limit']=qs[_0x88cb('0x20')](_0x2ab08b[_0x88cb('0x36')]['limit']);_0x59b9f0['offset']=qs[_0x88cb('0x1f')](_0x2ab08b[_0x88cb('0x36')][_0x88cb('0x1f')]);}_0x59b9f0['order']=qs[_0x88cb('0x3e')](_0x2ab08b[_0x88cb('0x36')]['sort']);_0x59b9f0[_0x88cb('0x3f')]=qs['filters'](_[_0x88cb('0x40')](_0x2ab08b[_0x88cb('0x36')],_0x42b3a8[_0x88cb('0x37')]),_0x3b1f6a);if(_0x2ab08b[_0x88cb('0x36')][_0x88cb('0x41')]){_0x59b9f0[_0x88cb('0x3f')]=_[_0x88cb('0x42')](_0x59b9f0[_0x88cb('0x3f')],{'$or':_[_0x88cb('0x2f')](_0x3b1f6a,function(_0x1ff4f2){if(_0x1ff4f2[_0x88cb('0x33')]!==_0x88cb('0x43')){var _0x36260b={};_0x36260b[_0x1ff4f2[_0x88cb('0x2d')]]={'$like':'%'+_0x2ab08b[_0x88cb('0x36')]['filter']+'%'};return _0x36260b;}})});}_0x59b9f0=_[_0x88cb('0x42')]({},_0x59b9f0,_0x2ab08b[_0x88cb('0x44')]);var _0x5e96bb={'where':_0x59b9f0[_0x88cb('0x3f')]};return db['AnalyticDefaultReport']['count'](_0x5e96bb)[_0x88cb('0x26')](function(_0x8dd351){_0x5869a0['count']=_0x8dd351;if(_0x2ab08b['query'][_0x88cb('0x45')]){_0x59b9f0['include']=[{'all':!![]}];}return db[_0x88cb('0x30')][_0x88cb('0x46')](_0x59b9f0);})['then'](function(_0x36dbfe){_0x5869a0[_0x88cb('0x47')]=_0x36dbfe;return _0x5869a0;})[_0x88cb('0x26')](respondWithFilteredResult(_0x2667b6,_0x59b9f0))['catch'](handleError(_0x2667b6,null));};exports[_0x88cb('0x48')]=function(_0x163c7f,_0x3ffaa2){var _0x11928f={'raw':!![],'where':{'id':_0x163c7f[_0x88cb('0x49')]['id']}},_0xe34825={};_0xe34825[_0x88cb('0x35')]=_[_0x88cb('0x4a')](db['AnalyticDefaultReport']['rawAttributes']);_0xe34825[_0x88cb('0x36')]=_[_0x88cb('0x4a')](_0x163c7f[_0x88cb('0x36')]);_0xe34825[_0x88cb('0x37')]=_[_0x88cb('0x39')](_0xe34825[_0x88cb('0x35')],_0xe34825[_0x88cb('0x36')]);_0x11928f[_0x88cb('0x38')]=_['intersection'](_0xe34825[_0x88cb('0x35')],qs[_0x88cb('0x3a')](_0x163c7f[_0x88cb('0x36')][_0x88cb('0x3a')]));_0x11928f[_0x88cb('0x38')]=_0x11928f['attributes'][_0x88cb('0x3b')]?_0x11928f['attributes']:_0xe34825[_0x88cb('0x35')];if(_0x163c7f[_0x88cb('0x36')][_0x88cb('0x45')]){_0x11928f[_0x88cb('0x4b')]=[{'all':!![]}];}_0x11928f=_[_0x88cb('0x42')]({},_0x11928f,_0x163c7f[_0x88cb('0x44')]);return db[_0x88cb('0x30')][_0x88cb('0x4c')](_0x11928f)[_0x88cb('0x26')](handleEntityNotFound(_0x3ffaa2,null))[_0x88cb('0x26')](respondWithResult(_0x3ffaa2,null))[_0x88cb('0x4d')](handleError(_0x3ffaa2,null));};exports[_0x88cb('0x4e')]=function(_0x3774ee,_0x37502c){return db[_0x88cb('0x30')][_0x88cb('0x4e')](_0x3774ee[_0x88cb('0x4f')],{})[_0x88cb('0x26')](function(_0x48ffad){var _0x1cf200=_0x3774ee[_0x88cb('0x50')][_0x88cb('0x27')]({'plain':!![]});if(!_0x1cf200)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x1cf200['role']===_0x88cb('0x50')){var _0x436532=_0x48ffad[_0x88cb('0x27')]({'plain':!![]});var _0x5aa6c4=_0x88cb('0x51');return db['UserProfileSection']['find']({'where':{'name':_0x5aa6c4,'userProfileId':_0x1cf200['userProfileId']},'raw':!![]})[_0x88cb('0x26')](function(_0x49a9b9){if(_0x49a9b9&&_0x49a9b9['autoAssociation']===0x0){return db[_0x88cb('0x29')]['create']({'name':_0x436532[_0x88cb('0x2d')],'resourceId':_0x436532['id'],'type':_0x88cb('0x28'),'sectionId':_0x49a9b9['id']},{})[_0x88cb('0x26')](function(){return _0x48ffad;});}else{return _0x48ffad;}})[_0x88cb('0x4d')](function(_0x519f8d){logger[_0x88cb('0x2b')](_0x88cb('0x52'),_0x519f8d);throw _0x519f8d;});}return _0x48ffad;})['then'](respondWithResult(_0x37502c,0xc9))['catch'](handleError(_0x37502c,null));};exports[_0x88cb('0x25')]=function(_0x1408b6,_0x345273){if(_0x1408b6['body']['id']){delete _0x1408b6[_0x88cb('0x4f')]['id'];}return db[_0x88cb('0x30')][_0x88cb('0x4c')]({'where':{'id':_0x1408b6[_0x88cb('0x49')]['id']}})[_0x88cb('0x26')](handleEntityNotFound(_0x345273,null))['then'](saveUpdates(_0x1408b6['body'],null))[_0x88cb('0x26')](respondWithResult(_0x345273,null))[_0x88cb('0x4d')](handleError(_0x345273,null));};exports[_0x88cb('0x2a')]=function(_0x1dbf01,_0x3adf8a){return db[_0x88cb('0x30')][_0x88cb('0x4c')]({'where':{'id':_0x1dbf01[_0x88cb('0x49')]['id']}})[_0x88cb('0x26')](handleEntityNotFound(_0x3adf8a,null))['then'](removeEntity(_0x3adf8a,null))[_0x88cb('0x4d')](handleError(_0x3adf8a,null));};exports[_0x88cb('0x53')]=function(_0x25dfac,_0x296444){var _0x555116=0xa;var _0x3a6f3a=[_0x88cb('0x54'),'left_join',_0x88cb('0x55'),_0x88cb('0x56')];var _0x135900={'SUM':'SUM(%s)','COUNT':_0x88cb('0x57'),'COUNT DISTINCT':_0x88cb('0x58'),'MAX':_0x88cb('0x59'),'MIN':_0x88cb('0x5a'),'AVG':_0x88cb('0x5b'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x88cb('0x5c'),'GROUP_CONCAT DESC':_0x88cb('0x5d')};var _0x57c278={'SEC_TO_TIME':_0x88cb('0x5e'),'DATE':'DATE(%s)','HOUR':_0x88cb('0x5f'),'ROUND':_0x88cb('0x60'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x52ecd8=function(_0x5a519a){return!_[_0x88cb('0x61')](['IS\x20NULL',_0x88cb('0x62'),_0x88cb('0x63'),_0x88cb('0x64')],_0x5a519a);};var _0x10ab55=function(_0x10a038){if(!_0x10a038||!_0x10a038[_0x88cb('0x65')][_0x88cb('0x3b')]){return'';}for(var _0x55962f='(',_0x17d695=0x0;_0x17d695<_0x10a038[_0x88cb('0x65')][_0x88cb('0x3b')];_0x17d695+=0x1){_0x17d695>0x0&&(_0x55962f+='\x20'+_0x10a038[_0x88cb('0x66')]+'\x20');_0x55962f+=_0x10a038[_0x88cb('0x65')][_0x17d695][_0x88cb('0x67')]?_0x10ab55(_0x10a038['rules'][_0x17d695][_0x88cb('0x67')]):_0x10a038['rules'][_0x17d695][_0x88cb('0x68')]+'\x20'+_0x10a038[_0x88cb('0x65')][_0x17d695][_0x88cb('0x69')]+(_0x52ecd8(_0x10a038['rules'][_0x17d695]['condition'])?'\x20'+_0x10a038[_0x88cb('0x65')][_0x17d695]['value']:'');}return _0x55962f+')';};var _0x576048={'where':{'id':_0x25dfac[_0x88cb('0x49')]['id']}},_0x20d02d,_0x1bdb79,_0xfcfbdd,_0x1cfcb3,_0x2eb08f;_0x576048=_['merge']({},_0x576048,_0x25dfac[_0x88cb('0x44')]);return db['AnalyticDefaultReport']['find'](_0x576048)[_0x88cb('0x26')](function(_0x4f8bd6){if(_0x4f8bd6){_0x20d02d=_0x4f8bd6;return _0x4f8bd6[_0x88cb('0x6a')]();}return null;})[_0x88cb('0x26')](function(_0x33a8c6){if(_0x33a8c6){if(!_0x33a8c6['length']){throw new db[(_0x88cb('0x6b'))][(_0x88cb('0x6c'))](_0x88cb('0x6d'),0x193);}_0x1bdb79=_0x33a8c6;return db['AnalyticMetric'][_0x88cb('0x46')]({'raw':!![]});}return null;})[_0x88cb('0x26')](function(_0x13a0fd){if(_0x13a0fd){_0xfcfbdd=_[_0x88cb('0x6e')](_0x13a0fd,'id');var _0x55a089;var _0x1f29f1=squel[_0x88cb('0x6f')]();_0x1f29f1[_0x88cb('0x70')](_0x20d02d['table']);for(var _0x4a2f20=0x0;_0x4a2f20<_0x1bdb79[_0x88cb('0x3b')];_0x4a2f20+=0x1){_0x55a089=_0x1bdb79[_0x4a2f20]['MetricId']?_0xfcfbdd[_0x1bdb79[_0x4a2f20][_0x88cb('0x71')]][_0x88cb('0x72')]:_0x1bdb79[_0x4a2f20][_0x88cb('0x68')];_0x55a089=_0x1bdb79[_0x4a2f20][_0x88cb('0x73')]?_[_0x88cb('0x74')](_0x135900[_0x1bdb79[_0x4a2f20][_0x88cb('0x73')]],'%s',_0x55a089):_0x55a089;_0x55a089=_0x1bdb79[_0x4a2f20]['format']?_[_0x88cb('0x74')](_0x57c278[_0x1bdb79[_0x4a2f20][_0x88cb('0x75')]],'%s',_0x55a089):_0x55a089;if(_0x1bdb79[_0x4a2f20][_0x88cb('0x76')]){_0x1f29f1[_0x88cb('0x67')](_0x55a089);}_0x1bdb79[_0x4a2f20]['orderBy']&&_0x1f29f1[_0x88cb('0x77')](_0x55a089,_0x1bdb79[_0x4a2f20][_0x88cb('0x78')]===_0x88cb('0x79')?![]:!![]);_0x1f29f1['field'](_0x55a089,_0x1bdb79[_0x4a2f20][_0x88cb('0x7a')]||_0x55a089);}if(_0x20d02d[_0x88cb('0x7b')]){_0x20d02d[_0x88cb('0x7b')]=JSON['parse'](_0x20d02d[_0x88cb('0x7b')]);for(var _0x136274=0x0;_0x136274<_0x20d02d[_0x88cb('0x7b')][_0x88cb('0x3b')];_0x136274+=0x1){if(_0x20d02d[_0x88cb('0x7b')][_0x136274]['type']&&_[_0x88cb('0x61')](_0x3a6f3a,_0x20d02d['joins'][_0x136274]['type'])&&_0x20d02d[_0x88cb('0x7b')][_0x136274][_0x88cb('0x7c')]&&_0x20d02d['joins'][_0x136274]['foreignTable']&&_0x20d02d[_0x88cb('0x7b')][_0x136274][_0x88cb('0x7d')]){_0x1f29f1[_0x20d02d[_0x88cb('0x7b')][_0x136274][_0x88cb('0x33')]](_0x20d02d[_0x88cb('0x7b')][_0x136274][_0x88cb('0x7e')],null,util['format']('%s.%s\x20=\x20%s.%s',_0x20d02d[_0x88cb('0x7f')],_0x20d02d['joins'][_0x136274][_0x88cb('0x7c')],_0x20d02d[_0x88cb('0x7b')][_0x136274][_0x88cb('0x7e')],_0x20d02d['joins'][_0x136274][_0x88cb('0x7d')]));}}}if(_0x20d02d['conditions']){_0x20d02d[_0x88cb('0x80')]=JSON[_0x88cb('0x81')](_0x20d02d[_0x88cb('0x80')]);_0x1f29f1[_0x88cb('0x3f')](_0x10ab55(_0x20d02d[_0x88cb('0x80')][_0x88cb('0x67')]));}_0x2eb08f=_0x1f29f1[_0x88cb('0x82')]();_0x1f29f1[_0x88cb('0x20')](_0x555116);_0x1f29f1[_0x88cb('0x1f')](0x0);logger[_0x88cb('0x83')]('Limited\x20Query:',_0x1f29f1[_0x88cb('0x84')]());return dbH[_0x88cb('0x85')]['query'](_0x1f29f1[_0x88cb('0x84')](),{'type':dbH[_0x88cb('0x85')][_0x88cb('0x86')][_0x88cb('0x87')]});}})['then'](respondWithResult(_0x296444,null))[_0x88cb('0x4d')](handleError(_0x296444,null));};function runReport(_0x30dfb8,_0x4f3f8e,_0x5857c3){var _0x34d78f=_0x4f3f8e[_0x88cb('0x2d')];var _0x1f6fb7=0xa;var _0x2f8a2d=['join',_0x88cb('0x88'),'right_join',_0x88cb('0x56')];var _0x1b0579={'SUM':_0x88cb('0x89'),'COUNT':_0x88cb('0x57'),'COUNT DISTINCT':_0x88cb('0x58'),'MAX':_0x88cb('0x59'),'MIN':_0x88cb('0x5a'),'AVG':_0x88cb('0x5b'),'GROUP_CONCAT':_0x88cb('0x8a'),'GROUP_CONCAT ASC':_0x88cb('0x5c'),'GROUP_CONCAT DESC':_0x88cb('0x5d')};var _0x22a7ae={'SEC_TO_TIME':_0x88cb('0x5e'),'DATE':_0x88cb('0x8b'),'HOUR':_0x88cb('0x5f'),'ROUND':_0x88cb('0x60'),'UNIX_TIMESTAMP':_0x88cb('0x8c')};var _0x4f47cc=function(_0x1ea32b){return!_[_0x88cb('0x61')]([_0x88cb('0x8d'),'IS\x20NOT\x20NULL',_0x88cb('0x63'),_0x88cb('0x64')],_0x1ea32b);};var _0x454fac=function(_0x42d37f){if(!_0x42d37f||!_0x42d37f[_0x88cb('0x65')][_0x88cb('0x3b')]){return'';}for(var _0x550468='(',_0x1b19e6=0x0;_0x1b19e6<_0x42d37f[_0x88cb('0x65')][_0x88cb('0x3b')];_0x1b19e6+=0x1){_0x1b19e6>0x0&&(_0x550468+='\x20'+_0x42d37f[_0x88cb('0x66')]+'\x20');_0x550468+=_0x42d37f[_0x88cb('0x65')][_0x1b19e6][_0x88cb('0x67')]?_0x454fac(_0x42d37f[_0x88cb('0x65')][_0x1b19e6][_0x88cb('0x67')]):_0x42d37f[_0x88cb('0x65')][_0x1b19e6]['field']+'\x20'+_0x42d37f[_0x88cb('0x65')][_0x1b19e6][_0x88cb('0x69')]+(_0x4f47cc(_0x42d37f[_0x88cb('0x65')][_0x1b19e6][_0x88cb('0x69')])?'\x20'+_0x42d37f[_0x88cb('0x65')][_0x1b19e6][_0x88cb('0x8e')]:'');}return _0x550468+')';};var _0x12fbf9={'where':{'id':_0x30dfb8['id']}},_0x2bafd4,_0xdaff87,_0x513af6,_0x25ccec,_0x2f72a5;_0x12fbf9=_[_0x88cb('0x42')]({},_0x12fbf9,_0x5857c3);return db[_0x88cb('0x30')][_0x88cb('0x4c')](_0x12fbf9)[_0x88cb('0x26')](function(_0x27b5b1){if(_0x27b5b1){_0x2bafd4=_0x27b5b1;return _0x27b5b1[_0x88cb('0x6a')]();}return null;})[_0x88cb('0x26')](function(_0x2a062c){if(_0x2a062c){if(!_0x2a062c['length']){throw new db['Sequelize'][(_0x88cb('0x6c'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0xdaff87=_0x2a062c;return db[_0x88cb('0x8f')][_0x88cb('0x46')]({'raw':!![]});}return null;})[_0x88cb('0x26')](function(_0x538d3c){if(_0x538d3c){_0x513af6=_[_0x88cb('0x6e')](_0x538d3c,'id');var _0x51e615;var _0x3c37e1=squel[_0x88cb('0x6f')]();_0x3c37e1[_0x88cb('0x70')](_0x2bafd4[_0x88cb('0x7f')]);for(var _0x494c1b=0x0;_0x494c1b<_0xdaff87[_0x88cb('0x3b')];_0x494c1b+=0x1){_0x51e615=_0xdaff87[_0x494c1b][_0x88cb('0x71')]?_0x513af6[_0xdaff87[_0x494c1b]['MetricId']][_0x88cb('0x72')]:_0xdaff87[_0x494c1b]['field'];_0x51e615=_0xdaff87[_0x494c1b][_0x88cb('0x73')]?_[_0x88cb('0x74')](_0x1b0579[_0xdaff87[_0x494c1b][_0x88cb('0x73')]],'%s',_0x51e615):_0x51e615;_0x51e615=_0xdaff87[_0x494c1b][_0x88cb('0x75')]?_[_0x88cb('0x74')](_0x22a7ae[_0xdaff87[_0x494c1b]['format']],'%s',_0x51e615):_0x51e615;if(_0xdaff87[_0x494c1b]['groupBy']){_0x3c37e1[_0x88cb('0x67')](_0x51e615);}_0xdaff87[_0x494c1b]['orderBy']&&_0x3c37e1[_0x88cb('0x77')](_0x51e615,_0xdaff87[_0x494c1b][_0x88cb('0x78')]===_0x88cb('0x79')?![]:!![]);_0x3c37e1[_0x88cb('0x68')](_0x51e615,_0xdaff87[_0x494c1b][_0x88cb('0x7a')]||_0x51e615);}if(_0x2bafd4['joins']){_0x2bafd4[_0x88cb('0x7b')]=JSON['parse'](_0x2bafd4['joins']);for(var _0xc33a9f=0x0;_0xc33a9f<_0x2bafd4[_0x88cb('0x7b')][_0x88cb('0x3b')];_0xc33a9f+=0x1){if(_0x2bafd4[_0x88cb('0x7b')][_0xc33a9f]['type']&&_[_0x88cb('0x61')](_0x2f8a2d,_0x2bafd4[_0x88cb('0x7b')][_0xc33a9f]['type'])&&_0x2bafd4[_0x88cb('0x7b')][_0xc33a9f]['parentKey']&&_0x2bafd4[_0x88cb('0x7b')][_0xc33a9f][_0x88cb('0x7e')]&&_0x2bafd4[_0x88cb('0x7b')][_0xc33a9f]['foreignKey']){_0x3c37e1[_0x2bafd4[_0x88cb('0x7b')][_0xc33a9f][_0x88cb('0x33')]](_0x2bafd4[_0x88cb('0x7b')][_0xc33a9f]['foreignTable'],null,util[_0x88cb('0x75')](_0x88cb('0x90'),_0x2bafd4['table'],_0x2bafd4[_0x88cb('0x7b')][_0xc33a9f]['parentKey'],_0x2bafd4['joins'][_0xc33a9f][_0x88cb('0x7e')],_0x2bafd4[_0x88cb('0x7b')][_0xc33a9f]['foreignKey']));}}}if(_0x2bafd4[_0x88cb('0x80')]){_0x2bafd4[_0x88cb('0x80')]=JSON[_0x88cb('0x81')](_0x2bafd4['conditions']);_0x3c37e1['where'](_0x454fac(_0x2bafd4[_0x88cb('0x80')][_0x88cb('0x67')]));}_0x2f72a5=_0x3c37e1[_0x88cb('0x82')]();_0x3c37e1['limit'](_0x1f6fb7);_0x3c37e1[_0x88cb('0x1f')](0x0);return;}})[_0x88cb('0x26')](function(){if(_0x4f3f8e[_0x88cb('0x91')]===_0x88cb('0x92')){return null;}var _0x2d174c=_[_0x88cb('0x42')](_0x4f3f8e,{'name':_0x4f3f8e[_0x88cb('0x93')]||_0x4f3f8e[_0x88cb('0x2d')]||_0x2bafd4[_0x88cb('0x2d')],'basename':_0x34d78f,'savename':util[_0x88cb('0x75')](_0x88cb('0x94'),_0x4f3f8e[_0x88cb('0x2d')]||_0x2bafd4['name'],require(_0x88cb('0x95'))[_0x88cb('0x96')](0x4),_0x4f3f8e[_0x88cb('0x91')]||'csv'),'reportId':_0x2bafd4['id'],'reportType':_0x88cb('0x97')});return db[_0x88cb('0x98')][_0x88cb('0x4e')](_0x2d174c,{'raw':!![]});})[_0x88cb('0x26')](function(_0x2b8e95){if(_0x2bafd4[_0x88cb('0x7f')]===_0x88cb('0x99')){_0x2f72a5[_0x88cb('0x3f')](_0x2bafd4[_0x88cb('0x7f')]+_0x88cb('0x9a'),_0x4f3f8e[_0x88cb('0x9b')],_0x4f3f8e[_0x88cb('0x9c')]);}else{_0x2f72a5[_0x88cb('0x3f')](_0x2bafd4[_0x88cb('0x7f')]+_0x88cb('0x9d'),_0x4f3f8e['startDate'],_0x4f3f8e[_0x88cb('0x9c')]);}if(_0x2b8e95){logger['info'](_0x88cb('0x9e'),_0x2f72a5[_0x88cb('0x84')]());require(_0x88cb('0x9f'))[_0x88cb('0xa0')](path[_0x88cb('0x54')](__dirname,_0x88cb('0xa1'),_0x2b8e95[_0x88cb('0x91')]),[_0x2b8e95['id'],_0x2f72a5[_0x88cb('0x84')](),path[_0x88cb('0x54')](__dirname,_0x88cb('0xa2'),_0x2b8e95[_0x88cb('0xa3')]),_0x34d78f]);return _0x2b8e95;}else{var _0x109d79=squel[_0x88cb('0x6f')]();_0x109d79[_0x88cb('0x70')]('('+_0x2f72a5[_0x88cb('0x84')]()+')','countTable');_0x109d79[_0x88cb('0x68')](_0x88cb('0xa4'),_0x88cb('0xa5'));_0x2f72a5[_0x88cb('0x20')](_0x4f3f8e[_0x88cb('0x20')]||_0x1f6fb7);_0x2f72a5[_0x88cb('0x1f')](_0x4f3f8e[_0x88cb('0x1f')]||0x0);return dbH[_0x88cb('0x85')][_0x88cb('0x36')](_0x109d79[_0x88cb('0x84')](),{'type':dbH['sequelize'][_0x88cb('0x86')][_0x88cb('0x87')]})[_0x88cb('0x26')](function(_0x4cf0ba){if(!_0x4cf0ba['length']){_0x25ccec=0x0;}else{_0x25ccec=_0x4cf0ba[0x0][_0x88cb('0xa5')]||0x0;}return dbH[_0x88cb('0x85')]['query'](_0x2f72a5[_0x88cb('0x84')](),{'type':dbH[_0x88cb('0x85')]['QueryTypes']['SELECT']});})[_0x88cb('0x26')](function(_0x15d9b4){return{'rows':_0x15d9b4||[],'count':_0x25ccec};});}});}exports[_0x88cb('0xa6')]=function(_0x17710d,_0x47be1a){return runReport(_0x17710d[_0x88cb('0x49')],_0x17710d['query'],_0x17710d[_0x88cb('0x44')])[_0x88cb('0x26')](respondWithResult(_0x47be1a,null))[_0x88cb('0x4d')](handleError(_0x47be1a,null));};exports[_0x88cb('0xa7')]=runReport;exports['query']=function(_0x2c06ef,_0x5f29e9){var _0x1f2a24=0xa;var _0x2d89f9=[_0x88cb('0x54'),'left_join',_0x88cb('0x55'),_0x88cb('0x56')];var _0x144afe={'SUM':_0x88cb('0x89'),'COUNT':_0x88cb('0x57'),'COUNT DISTINCT':_0x88cb('0x58'),'MAX':_0x88cb('0x59'),'MIN':_0x88cb('0x5a'),'AVG':_0x88cb('0x5b'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x88cb('0x5c'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x4625b1={'SEC_TO_TIME':_0x88cb('0x5e'),'DATE':_0x88cb('0x8b'),'HOUR':'HOUR(%s)','ROUND':_0x88cb('0x60'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0xe2029b=function(_0x4d3e8f){return!_[_0x88cb('0x61')]([_0x88cb('0x8d'),_0x88cb('0x62'),_0x88cb('0x63'),'IS\x20NOT\x20EMPTY'],_0x4d3e8f);};var _0xf43ad=function(_0x5947f6){if(!_0x5947f6||!_0x5947f6[_0x88cb('0x65')][_0x88cb('0x3b')]){return'';}for(var _0x6c963f='(',_0x23b487=0x0;_0x23b487<_0x5947f6['rules'][_0x88cb('0x3b')];_0x23b487+=0x1){_0x23b487>0x0&&(_0x6c963f+='\x20'+_0x5947f6['operator']+'\x20');_0x6c963f+=_0x5947f6[_0x88cb('0x65')][_0x23b487]['group']?_0xf43ad(_0x5947f6[_0x88cb('0x65')][_0x23b487][_0x88cb('0x67')]):_0x5947f6[_0x88cb('0x65')][_0x23b487][_0x88cb('0x68')]+'\x20'+_0x5947f6['rules'][_0x23b487][_0x88cb('0x69')]+(_0xe2029b(_0x5947f6[_0x88cb('0x65')][_0x23b487][_0x88cb('0x69')])?'\x20'+_0x5947f6['rules'][_0x23b487][_0x88cb('0x8e')]:'');}return _0x6c963f+')';};var _0x394672={'where':{'id':_0x2c06ef[_0x88cb('0x49')]['id']}},_0x22c3f1,_0x1ca3de,_0x16ceb2,_0x5d2a40,_0x54e043;_0x394672=_[_0x88cb('0x42')]({},_0x394672,_0x2c06ef['options']);return db[_0x88cb('0x30')][_0x88cb('0x4c')](_0x394672)[_0x88cb('0x26')](function(_0x25cd44){if(_0x25cd44){_0x22c3f1=_0x25cd44;return _0x25cd44[_0x88cb('0x6a')]();}return null;})[_0x88cb('0x26')](function(_0x36486a){if(_0x36486a){if(!_0x36486a['length']){throw new db[(_0x88cb('0x6b'))][(_0x88cb('0x6c'))](_0x88cb('0x6d'),0x193);}_0x1ca3de=_0x36486a;return db['AnalyticMetric'][_0x88cb('0x46')]({'raw':!![]});}return null;})[_0x88cb('0x26')](function(_0x6047f1){if(_0x6047f1){_0x16ceb2=_[_0x88cb('0x6e')](_0x6047f1,'id');var _0x340a1d;var _0x4fd8c8=squel[_0x88cb('0x6f')]();_0x4fd8c8[_0x88cb('0x70')](_0x22c3f1[_0x88cb('0x7f')]);for(var _0x4d071d=0x0;_0x4d071d<_0x1ca3de[_0x88cb('0x3b')];_0x4d071d+=0x1){_0x340a1d=_0x1ca3de[_0x4d071d][_0x88cb('0x71')]?_0x16ceb2[_0x1ca3de[_0x4d071d]['MetricId']][_0x88cb('0x72')]:_0x1ca3de[_0x4d071d]['field'];_0x340a1d=_0x1ca3de[_0x4d071d][_0x88cb('0x73')]?_[_0x88cb('0x74')](_0x144afe[_0x1ca3de[_0x4d071d][_0x88cb('0x73')]],'%s',_0x340a1d):_0x340a1d;_0x340a1d=_0x1ca3de[_0x4d071d][_0x88cb('0x75')]?_[_0x88cb('0x74')](_0x4625b1[_0x1ca3de[_0x4d071d][_0x88cb('0x75')]],'%s',_0x340a1d):_0x340a1d;if(_0x1ca3de[_0x4d071d][_0x88cb('0x76')]){_0x4fd8c8[_0x88cb('0x67')](_0x340a1d);}_0x1ca3de[_0x4d071d][_0x88cb('0x78')]&&_0x4fd8c8['order'](_0x340a1d,_0x1ca3de[_0x4d071d][_0x88cb('0x78')]===_0x88cb('0x79')?![]:!![]);_0x4fd8c8[_0x88cb('0x68')](_0x340a1d,_0x1ca3de[_0x4d071d][_0x88cb('0x7a')]||_0x340a1d);}if(_0x22c3f1[_0x88cb('0x7b')]){_0x22c3f1[_0x88cb('0x7b')]=JSON[_0x88cb('0x81')](_0x22c3f1[_0x88cb('0x7b')]);for(var _0x3eaec4=0x0;_0x3eaec4<_0x22c3f1[_0x88cb('0x7b')]['length'];_0x3eaec4+=0x1){if(_0x22c3f1[_0x88cb('0x7b')][_0x3eaec4][_0x88cb('0x33')]&&_[_0x88cb('0x61')](_0x2d89f9,_0x22c3f1[_0x88cb('0x7b')][_0x3eaec4]['type'])&&_0x22c3f1[_0x88cb('0x7b')][_0x3eaec4]['parentKey']&&_0x22c3f1[_0x88cb('0x7b')][_0x3eaec4][_0x88cb('0x7e')]&&_0x22c3f1['joins'][_0x3eaec4][_0x88cb('0x7d')]){_0x4fd8c8[_0x22c3f1[_0x88cb('0x7b')][_0x3eaec4][_0x88cb('0x33')]](_0x22c3f1[_0x88cb('0x7b')][_0x3eaec4][_0x88cb('0x7e')],null,util['format'](_0x88cb('0x90'),_0x22c3f1[_0x88cb('0x7f')],_0x22c3f1[_0x88cb('0x7b')][_0x3eaec4][_0x88cb('0x7c')],_0x22c3f1['joins'][_0x3eaec4][_0x88cb('0x7e')],_0x22c3f1[_0x88cb('0x7b')][_0x3eaec4][_0x88cb('0x7d')]));}}}if(_0x22c3f1['conditions']){_0x22c3f1[_0x88cb('0x80')]=JSON[_0x88cb('0x81')](_0x22c3f1[_0x88cb('0x80')]);_0x4fd8c8['where'](_0xf43ad(_0x22c3f1['conditions'][_0x88cb('0x67')]));}_0x54e043=_0x4fd8c8[_0x88cb('0x82')]();_0x4fd8c8['limit'](_0x1f2a24);_0x4fd8c8['offset'](0x0);logger[_0x88cb('0x83')]('Limited\x20Query:',_0x4fd8c8[_0x88cb('0x84')]());return dbH['sequelize'][_0x88cb('0x36')](_0x4fd8c8[_0x88cb('0x84')](),{'type':dbH[_0x88cb('0x85')][_0x88cb('0x86')][_0x88cb('0x87')]});}})[_0x88cb('0x26')](function(){return{'sql':_0x54e043[_0x88cb('0x84')]()};})[_0x88cb('0x26')](respondWithResult(_0x5f29e9,null))[_0x88cb('0x4d')](handleError(_0x5f29e9,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff