// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x1b30=['key','model','map','query','keys','filters','intersection','attributes','fields','length','nolimit','sort','where','pick','filter','merge','options','count','include','findAll','rows','show','params','includeAll','find','catch','create','body','user','role','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','destroy','preview','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\x20DESC)','SEC_TO_TIME(%s)','DATE(%s)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','rules','operator','group','field','condition','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','select','from','table','MetricId','function','replace','format','groupBy','orderBy','DESC','alias','joins','parse','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','conditions','clone','debug','toString','sequelize','SELECT','right_join','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','includes','IS\x20NOT\x20EMPTY','value','metric','QueryTypes','No\x20available\x20data','web','%s-%s.%s','generate','output','csv','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','info','../../files/reports','countTable','COUNT(*)','runReport','left_join','order','Limited\x20Query:','html-pdf','eml-format','zip-dir','fast-json-patch','moment','bluebird','mustache','path','sox','to-csv','ejs','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','json','offset','limit','set','Content-Range','reject','save','update','then','get','DefaultReports','UserProfileResource','error','name','index','AnalyticDefaultReport','rawAttributes','fieldName','type'];(function(_0x53f0ff,_0x34cca8){var _0x51d8a9=function(_0x1111b1){while(--_0x1111b1){_0x53f0ff['push'](_0x53f0ff['shift']());}};_0x51d8a9(++_0x34cca8);}(_0x1b30,0x111));var _0x01b3=function(_0x488315,_0x264c2a){_0x488315=_0x488315-0x0;var _0x43b193=_0x1b30[_0x488315];return _0x43b193;};'use strict';var pdf=require(_0x01b3('0x0'));var emlformat=require(_0x01b3('0x1'));var rimraf=require('rimraf');var zipdir=require(_0x01b3('0x2'));var jsonpatch=require(_0x01b3('0x3'));var rp=require('request-promise');var moment=require(_0x01b3('0x4'));var BPromise=require(_0x01b3('0x5'));var Mustache=require(_0x01b3('0x6'));var util=require('util');var path=require(_0x01b3('0x7'));var sox=require(_0x01b3('0x8'));var csv=require(_0x01b3('0x9'));var ejs=require(_0x01b3('0xa'));var fs=require('fs');var _=require('lodash');var squel=require('squel');var crypto=require(_0x01b3('0xb'));var jsforce=require(_0x01b3('0xc'));var deskjs=require('desk.js');var toCsv=require(_0x01b3('0x9'));var querystring=require(_0x01b3('0xd'));var Papa=require(_0x01b3('0xe'));var Redis=require(_0x01b3('0xf'));var authService=require(_0x01b3('0x10'));var qs=require(_0x01b3('0x11'));var as=require(_0x01b3('0x12'));var hardwareService=require(_0x01b3('0x13'));var logger=require(_0x01b3('0x14'))(_0x01b3('0x15'));var utils=require(_0x01b3('0x16'));var config=require(_0x01b3('0x17'));var db=require(_0x01b3('0x18'))['db'];var dbH=require(_0x01b3('0x18'))['dbH'];function respondWithStatusCode(_0x34855a,_0x12d5a9){_0x12d5a9=_0x12d5a9||0xcc;return function(_0x42ff61){if(_0x42ff61){return _0x34855a[_0x01b3('0x19')](_0x12d5a9);}return _0x34855a[_0x01b3('0x1a')](_0x12d5a9)[_0x01b3('0x1b')]();};}function respondWithResult(_0x235b56,_0x409e5f){_0x409e5f=_0x409e5f||0xc8;return function(_0x28069a){if(_0x28069a){return _0x235b56[_0x01b3('0x1a')](_0x409e5f)[_0x01b3('0x1c')](_0x28069a);}};}function respondWithFilteredResult(_0x3a55fd,_0x5d11d8){return function(_0x461292){if(_0x461292){var _0x5e1b8a=_0x461292['count'],_0xee39f8=_0x5d11d8['offset'],_0x3a5a38=_0x5d11d8[_0x01b3('0x1d')]+_0x5d11d8[_0x01b3('0x1e')],_0x43ee5f;if(_0x3a5a38>=_0x5e1b8a){_0x3a5a38=_0x5e1b8a;_0x43ee5f=0xc8;}else{_0x43ee5f=0xce;}_0x3a55fd[_0x01b3('0x1a')](_0x43ee5f);return _0x3a55fd[_0x01b3('0x1f')](_0x01b3('0x20'),_0xee39f8+'-'+_0x3a5a38+'/'+_0x5e1b8a)['json'](_0x461292);}return null;};}function patchUpdates(_0x16ad60){return function(_0x1d424f){try{jsonpatch['apply'](_0x1d424f,_0x16ad60,!![]);}catch(_0x118d17){return BPromise[_0x01b3('0x21')](_0x118d17);}return _0x1d424f[_0x01b3('0x22')]();};}function saveUpdates(_0x1aeede,_0x2ca4dc){return function(_0x5db7ea){if(_0x5db7ea){return _0x5db7ea[_0x01b3('0x23')](_0x1aeede)[_0x01b3('0x24')](function(_0x58b7ce){return _0x58b7ce;});}return null;};}function removeEntity(_0x2af18a,_0x446b22){return function(_0x459d2d){if(_0x459d2d){return _0x459d2d['destroy']()['then'](function(){var _0x41c73a=_0x459d2d[_0x01b3('0x25')]({'plain':!![]});var _0x4dd5f6=_0x01b3('0x26');return db[_0x01b3('0x27')]['destroy']({'where':{'type':_0x4dd5f6,'resourceId':_0x41c73a['id']}})[_0x01b3('0x24')](function(){return _0x459d2d;});})[_0x01b3('0x24')](function(){_0x2af18a[_0x01b3('0x1a')](0xcc)['end']();});}};}function handleEntityNotFound(_0xf36325,_0x5d98e0){return function(_0x4b3c45){if(!_0x4b3c45){_0xf36325[_0x01b3('0x19')](0x194);}return _0x4b3c45;};}function handleError(_0x57e135,_0x449fad){_0x449fad=_0x449fad||0x1f4;return function(_0x3f588a){logger[_0x01b3('0x28')](_0x3f588a['stack']);if(_0x3f588a['name']){delete _0x3f588a[_0x01b3('0x29')];}_0x57e135['status'](_0x449fad)['send'](_0x3f588a);};}exports[_0x01b3('0x2a')]=function(_0x29e50c,_0x2b8e51){var _0x4e80e9={},_0x19e221={},_0x3bea48={'count':0x0,'rows':[]};var _0x1b33ee=_['map'](db[_0x01b3('0x2b')][_0x01b3('0x2c')],function(_0x43f965){return{'name':_0x43f965[_0x01b3('0x2d')],'type':_0x43f965[_0x01b3('0x2e')][_0x01b3('0x2f')]};});_0x19e221[_0x01b3('0x30')]=_[_0x01b3('0x31')](_0x1b33ee,'name');_0x19e221[_0x01b3('0x32')]=_[_0x01b3('0x33')](_0x29e50c[_0x01b3('0x32')]);_0x19e221[_0x01b3('0x34')]=_[_0x01b3('0x35')](_0x19e221['model'],_0x19e221[_0x01b3('0x32')]);_0x4e80e9[_0x01b3('0x36')]=_['intersection'](_0x19e221['model'],qs[_0x01b3('0x37')](_0x29e50c[_0x01b3('0x32')]['fields']));_0x4e80e9[_0x01b3('0x36')]=_0x4e80e9['attributes'][_0x01b3('0x38')]?_0x4e80e9[_0x01b3('0x36')]:_0x19e221[_0x01b3('0x30')];if(!_0x29e50c[_0x01b3('0x32')]['hasOwnProperty'](_0x01b3('0x39'))){_0x4e80e9[_0x01b3('0x1e')]=qs[_0x01b3('0x1e')](_0x29e50c[_0x01b3('0x32')][_0x01b3('0x1e')]);_0x4e80e9[_0x01b3('0x1d')]=qs['offset'](_0x29e50c[_0x01b3('0x32')][_0x01b3('0x1d')]);}_0x4e80e9['order']=qs[_0x01b3('0x3a')](_0x29e50c[_0x01b3('0x32')][_0x01b3('0x3a')]);_0x4e80e9[_0x01b3('0x3b')]=qs[_0x01b3('0x34')](_[_0x01b3('0x3c')](_0x29e50c[_0x01b3('0x32')],_0x19e221[_0x01b3('0x34')]),_0x1b33ee);if(_0x29e50c['query'][_0x01b3('0x3d')]){_0x4e80e9[_0x01b3('0x3b')]=_['merge'](_0x4e80e9[_0x01b3('0x3b')],{'$or':_[_0x01b3('0x31')](_0x1b33ee,function(_0x6a3fbe){if(_0x6a3fbe['type']!=='VIRTUAL'){var _0x4e0f9b={};_0x4e0f9b[_0x6a3fbe[_0x01b3('0x29')]]={'$like':'%'+_0x29e50c['query'][_0x01b3('0x3d')]+'%'};return _0x4e0f9b;}})});}_0x4e80e9=_[_0x01b3('0x3e')]({},_0x4e80e9,_0x29e50c[_0x01b3('0x3f')]);var _0xede1f5={'where':_0x4e80e9['where']};return db[_0x01b3('0x2b')][_0x01b3('0x40')](_0xede1f5)['then'](function(_0x25821c){_0x3bea48[_0x01b3('0x40')]=_0x25821c;if(_0x29e50c[_0x01b3('0x32')]['includeAll']){_0x4e80e9[_0x01b3('0x41')]=[{'all':!![]}];}return db[_0x01b3('0x2b')][_0x01b3('0x42')](_0x4e80e9);})[_0x01b3('0x24')](function(_0xa9788a){_0x3bea48[_0x01b3('0x43')]=_0xa9788a;return _0x3bea48;})[_0x01b3('0x24')](respondWithFilteredResult(_0x2b8e51,_0x4e80e9))['catch'](handleError(_0x2b8e51,null));};exports[_0x01b3('0x44')]=function(_0x58c90c,_0x3569b2){var _0x3a43f8={'raw':!![],'where':{'id':_0x58c90c[_0x01b3('0x45')]['id']}},_0x8aba3f={};_0x8aba3f['model']=_['keys'](db[_0x01b3('0x2b')][_0x01b3('0x2c')]);_0x8aba3f[_0x01b3('0x32')]=_['keys'](_0x58c90c[_0x01b3('0x32')]);_0x8aba3f[_0x01b3('0x34')]=_['intersection'](_0x8aba3f[_0x01b3('0x30')],_0x8aba3f[_0x01b3('0x32')]);_0x3a43f8['attributes']=_[_0x01b3('0x35')](_0x8aba3f[_0x01b3('0x30')],qs['fields'](_0x58c90c[_0x01b3('0x32')]['fields']));_0x3a43f8['attributes']=_0x3a43f8['attributes']['length']?_0x3a43f8[_0x01b3('0x36')]:_0x8aba3f[_0x01b3('0x30')];if(_0x58c90c[_0x01b3('0x32')][_0x01b3('0x46')]){_0x3a43f8[_0x01b3('0x41')]=[{'all':!![]}];}_0x3a43f8=_[_0x01b3('0x3e')]({},_0x3a43f8,_0x58c90c[_0x01b3('0x3f')]);return db[_0x01b3('0x2b')][_0x01b3('0x47')](_0x3a43f8)[_0x01b3('0x24')](handleEntityNotFound(_0x3569b2,null))['then'](respondWithResult(_0x3569b2,null))[_0x01b3('0x48')](handleError(_0x3569b2,null));};exports[_0x01b3('0x49')]=function(_0x1aecbd,_0xfef329){return db['AnalyticDefaultReport'][_0x01b3('0x49')](_0x1aecbd[_0x01b3('0x4a')],{})[_0x01b3('0x24')](function(_0xfa2b25){var _0x53d059=_0x1aecbd[_0x01b3('0x4b')][_0x01b3('0x25')]({'plain':!![]});if(!_0x53d059)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x53d059[_0x01b3('0x4c')]===_0x01b3('0x4b')){var _0x5abcc7=_0xfa2b25[_0x01b3('0x25')]({'plain':!![]});var _0x3c7405='Reports';return db['UserProfileSection']['find']({'where':{'name':_0x3c7405,'userProfileId':_0x53d059[_0x01b3('0x4d')]},'raw':!![]})[_0x01b3('0x24')](function(_0x4abfc6){if(_0x4abfc6&&_0x4abfc6[_0x01b3('0x4e')]===0x0){return db[_0x01b3('0x27')]['create']({'name':_0x5abcc7[_0x01b3('0x29')],'resourceId':_0x5abcc7['id'],'type':_0x01b3('0x26'),'sectionId':_0x4abfc6['id']},{})['then'](function(){return _0xfa2b25;});}else{return _0xfa2b25;}})[_0x01b3('0x48')](function(_0x519de7){logger[_0x01b3('0x28')](_0x01b3('0x4f'),_0x519de7);throw _0x519de7;});}return _0xfa2b25;})[_0x01b3('0x24')](respondWithResult(_0xfef329,0xc9))[_0x01b3('0x48')](handleError(_0xfef329,null));};exports[_0x01b3('0x23')]=function(_0x12dd00,_0x16b7b2){if(_0x12dd00[_0x01b3('0x4a')]['id']){delete _0x12dd00[_0x01b3('0x4a')]['id'];}return db[_0x01b3('0x2b')][_0x01b3('0x47')]({'where':{'id':_0x12dd00['params']['id']}})['then'](handleEntityNotFound(_0x16b7b2,null))[_0x01b3('0x24')](saveUpdates(_0x12dd00[_0x01b3('0x4a')],null))[_0x01b3('0x24')](respondWithResult(_0x16b7b2,null))[_0x01b3('0x48')](handleError(_0x16b7b2,null));};exports[_0x01b3('0x50')]=function(_0x14fce3,_0x421195){return db[_0x01b3('0x2b')][_0x01b3('0x47')]({'where':{'id':_0x14fce3[_0x01b3('0x45')]['id']}})[_0x01b3('0x24')](handleEntityNotFound(_0x421195,null))['then'](removeEntity(_0x421195,null))[_0x01b3('0x48')](handleError(_0x421195,null));};exports[_0x01b3('0x51')]=function(_0xb4c304,_0xbab0e0){var _0x51808f=0xa;var _0x2e6f9e=[_0x01b3('0x52'),'left_join','right_join',_0x01b3('0x53')];var _0x53c85e={'SUM':_0x01b3('0x54'),'COUNT':_0x01b3('0x55'),'COUNT DISTINCT':_0x01b3('0x56'),'MAX':_0x01b3('0x57'),'MIN':_0x01b3('0x58'),'AVG':_0x01b3('0x59'),'GROUP_CONCAT':_0x01b3('0x5a'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0x01b3('0x5b')};var _0x5dc758={'SEC_TO_TIME':_0x01b3('0x5c'),'DATE':_0x01b3('0x5d'),'HOUR':_0x01b3('0x5e'),'ROUND':_0x01b3('0x5f'),'UNIX_TIMESTAMP':_0x01b3('0x60')};var _0x4884a8=function(_0x353ce7){return!_['includes']([_0x01b3('0x61'),_0x01b3('0x62'),_0x01b3('0x63'),'IS\x20NOT\x20EMPTY'],_0x353ce7);};var _0xcb7c4=function(_0x5a5c7f){if(!_0x5a5c7f||!_0x5a5c7f[_0x01b3('0x64')][_0x01b3('0x38')]){return'';}for(var _0x380a9b='(',_0x237b52=0x0;_0x237b52<_0x5a5c7f[_0x01b3('0x64')][_0x01b3('0x38')];_0x237b52+=0x1){_0x237b52>0x0&&(_0x380a9b+='\x20'+_0x5a5c7f[_0x01b3('0x65')]+'\x20');_0x380a9b+=_0x5a5c7f['rules'][_0x237b52][_0x01b3('0x66')]?_0xcb7c4(_0x5a5c7f[_0x01b3('0x64')][_0x237b52][_0x01b3('0x66')]):_0x5a5c7f[_0x01b3('0x64')][_0x237b52][_0x01b3('0x67')]+'\x20'+_0x5a5c7f[_0x01b3('0x64')][_0x237b52][_0x01b3('0x68')]+(_0x4884a8(_0x5a5c7f[_0x01b3('0x64')][_0x237b52][_0x01b3('0x68')])?'\x20'+_0x5a5c7f[_0x01b3('0x64')][_0x237b52]['value']:'');}return _0x380a9b+')';};var _0x38e529={'where':{'id':_0xb4c304[_0x01b3('0x45')]['id']}},_0x11deb8,_0x5f55fc,_0x40743d,_0x1c56df,_0x5b7bea;_0x38e529=_[_0x01b3('0x3e')]({},_0x38e529,_0xb4c304['options']);return db['AnalyticDefaultReport'][_0x01b3('0x47')](_0x38e529)[_0x01b3('0x24')](function(_0x5413e1){if(_0x5413e1){_0x11deb8=_0x5413e1;return _0x5413e1[_0x01b3('0x69')]();}return null;})[_0x01b3('0x24')](function(_0x31d700){if(_0x31d700){if(!_0x31d700[_0x01b3('0x38')]){throw new db[(_0x01b3('0x6a'))][(_0x01b3('0x6b'))](_0x01b3('0x6c'),0x193);}_0x5f55fc=_0x31d700;return db[_0x01b3('0x6d')][_0x01b3('0x42')]({'raw':!![]});}return null;})[_0x01b3('0x24')](function(_0x28b360){if(_0x28b360){_0x40743d=_[_0x01b3('0x6e')](_0x28b360,'id');var _0x2fd270;var _0x3ccc44=squel[_0x01b3('0x6f')]();_0x3ccc44[_0x01b3('0x70')](_0x11deb8[_0x01b3('0x71')]);for(var _0x32ecfa=0x0;_0x32ecfa<_0x5f55fc[_0x01b3('0x38')];_0x32ecfa+=0x1){_0x2fd270=_0x5f55fc[_0x32ecfa][_0x01b3('0x72')]?_0x40743d[_0x5f55fc[_0x32ecfa]['MetricId']]['metric']:_0x5f55fc[_0x32ecfa][_0x01b3('0x67')];_0x2fd270=_0x5f55fc[_0x32ecfa][_0x01b3('0x73')]?_[_0x01b3('0x74')](_0x53c85e[_0x5f55fc[_0x32ecfa][_0x01b3('0x73')]],'%s',_0x2fd270):_0x2fd270;_0x2fd270=_0x5f55fc[_0x32ecfa][_0x01b3('0x75')]?_[_0x01b3('0x74')](_0x5dc758[_0x5f55fc[_0x32ecfa]['format']],'%s',_0x2fd270):_0x2fd270;if(_0x5f55fc[_0x32ecfa][_0x01b3('0x76')]){_0x3ccc44[_0x01b3('0x66')](_0x2fd270);}_0x5f55fc[_0x32ecfa][_0x01b3('0x77')]&&_0x3ccc44['order'](_0x2fd270,_0x5f55fc[_0x32ecfa][_0x01b3('0x77')]===_0x01b3('0x78')?![]:!![]);_0x3ccc44[_0x01b3('0x67')](_0x2fd270,_0x5f55fc[_0x32ecfa][_0x01b3('0x79')]||_0x2fd270);}if(_0x11deb8[_0x01b3('0x7a')]){_0x11deb8[_0x01b3('0x7a')]=JSON[_0x01b3('0x7b')](_0x11deb8['joins']);for(var _0x281713=0x0;_0x281713<_0x11deb8[_0x01b3('0x7a')]['length'];_0x281713+=0x1){if(_0x11deb8['joins'][_0x281713][_0x01b3('0x2e')]&&_['includes'](_0x2e6f9e,_0x11deb8[_0x01b3('0x7a')][_0x281713]['type'])&&_0x11deb8[_0x01b3('0x7a')][_0x281713][_0x01b3('0x7c')]&&_0x11deb8[_0x01b3('0x7a')][_0x281713][_0x01b3('0x7d')]&&_0x11deb8['joins'][_0x281713][_0x01b3('0x7e')]){_0x3ccc44[_0x11deb8['joins'][_0x281713][_0x01b3('0x2e')]](_0x11deb8[_0x01b3('0x7a')][_0x281713][_0x01b3('0x7d')],null,util[_0x01b3('0x75')](_0x01b3('0x7f'),_0x11deb8[_0x01b3('0x71')],_0x11deb8[_0x01b3('0x7a')][_0x281713][_0x01b3('0x7c')],_0x11deb8[_0x01b3('0x7a')][_0x281713][_0x01b3('0x7d')],_0x11deb8[_0x01b3('0x7a')][_0x281713]['foreignKey']));}}}if(_0x11deb8[_0x01b3('0x80')]){_0x11deb8[_0x01b3('0x80')]=JSON[_0x01b3('0x7b')](_0x11deb8[_0x01b3('0x80')]);_0x3ccc44['where'](_0xcb7c4(_0x11deb8[_0x01b3('0x80')][_0x01b3('0x66')]));}_0x5b7bea=_0x3ccc44[_0x01b3('0x81')]();_0x3ccc44[_0x01b3('0x1e')](_0x51808f);_0x3ccc44['offset'](0x0);logger[_0x01b3('0x82')]('Limited\x20Query:',_0x3ccc44[_0x01b3('0x83')]());return db[_0x01b3('0x84')][_0x01b3('0x32')](_0x3ccc44[_0x01b3('0x83')](),{'type':db[_0x01b3('0x84')]['QueryTypes'][_0x01b3('0x85')]});}})[_0x01b3('0x24')](respondWithResult(_0xbab0e0,null))['catch'](handleError(_0xbab0e0,null));};function runReport(_0x599332,_0x377e64,_0x8ae8e){var _0x3621bb=_0x377e64[_0x01b3('0x29')];var _0x38a62d=0xa;var _0x1d53f5=[_0x01b3('0x52'),'left_join',_0x01b3('0x86'),_0x01b3('0x53')];var _0x467e71={'SUM':_0x01b3('0x54'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x01b3('0x56'),'MAX':_0x01b3('0x57'),'MIN':_0x01b3('0x58'),'AVG':_0x01b3('0x59'),'GROUP_CONCAT':_0x01b3('0x5a'),'GROUP_CONCAT ASC':_0x01b3('0x87'),'GROUP_CONCAT DESC':_0x01b3('0x5b')};var _0xd6d61e={'SEC_TO_TIME':_0x01b3('0x5c'),'DATE':_0x01b3('0x5d'),'HOUR':_0x01b3('0x5e'),'ROUND':_0x01b3('0x5f'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x3d654f=function(_0x40f73d){return!_[_0x01b3('0x88')]([_0x01b3('0x61'),'IS\x20NOT\x20NULL','IS\x20EMPTY',_0x01b3('0x89')],_0x40f73d);};var _0x25adf6=function(_0x11eec7){if(!_0x11eec7||!_0x11eec7[_0x01b3('0x64')]['length']){return'';}for(var _0xc2f26e='(',_0x1d12e3=0x0;_0x1d12e3<_0x11eec7[_0x01b3('0x64')]['length'];_0x1d12e3+=0x1){_0x1d12e3>0x0&&(_0xc2f26e+='\x20'+_0x11eec7['operator']+'\x20');_0xc2f26e+=_0x11eec7[_0x01b3('0x64')][_0x1d12e3][_0x01b3('0x66')]?_0x25adf6(_0x11eec7[_0x01b3('0x64')][_0x1d12e3]['group']):_0x11eec7[_0x01b3('0x64')][_0x1d12e3][_0x01b3('0x67')]+'\x20'+_0x11eec7['rules'][_0x1d12e3][_0x01b3('0x68')]+(_0x3d654f(_0x11eec7['rules'][_0x1d12e3][_0x01b3('0x68')])?'\x20'+_0x11eec7[_0x01b3('0x64')][_0x1d12e3][_0x01b3('0x8a')]:'');}return _0xc2f26e+')';};var _0x5137e1={'where':{'id':_0x599332['id']}},_0x413f9d,_0x487988,_0x2686aa,_0x4fcdbb,_0x4a9197;_0x5137e1=_[_0x01b3('0x3e')]({},_0x5137e1,_0x8ae8e);return db[_0x01b3('0x2b')][_0x01b3('0x47')](_0x5137e1)[_0x01b3('0x24')](function(_0x594751){if(_0x594751){_0x413f9d=_0x594751;return _0x594751[_0x01b3('0x69')]();}return null;})[_0x01b3('0x24')](function(_0x51c9c3){if(_0x51c9c3){if(!_0x51c9c3[_0x01b3('0x38')]){throw new db['Sequelize'][(_0x01b3('0x6b'))](_0x01b3('0x6c'),0x193);}_0x487988=_0x51c9c3;return db[_0x01b3('0x6d')][_0x01b3('0x42')]({'raw':!![]});}return null;})[_0x01b3('0x24')](function(_0x5bb062){if(_0x5bb062){_0x2686aa=_[_0x01b3('0x6e')](_0x5bb062,'id');var _0x1ea4c4;var _0x342e6e=squel['select']();_0x342e6e[_0x01b3('0x70')](_0x413f9d['table']);for(var _0x32f1e9=0x0;_0x32f1e9<_0x487988['length'];_0x32f1e9+=0x1){_0x1ea4c4=_0x487988[_0x32f1e9]['MetricId']?_0x2686aa[_0x487988[_0x32f1e9][_0x01b3('0x72')]][_0x01b3('0x8b')]:_0x487988[_0x32f1e9][_0x01b3('0x67')];_0x1ea4c4=_0x487988[_0x32f1e9][_0x01b3('0x73')]?_[_0x01b3('0x74')](_0x467e71[_0x487988[_0x32f1e9][_0x01b3('0x73')]],'%s',_0x1ea4c4):_0x1ea4c4;_0x1ea4c4=_0x487988[_0x32f1e9][_0x01b3('0x75')]?_[_0x01b3('0x74')](_0xd6d61e[_0x487988[_0x32f1e9][_0x01b3('0x75')]],'%s',_0x1ea4c4):_0x1ea4c4;if(_0x487988[_0x32f1e9][_0x01b3('0x76')]){_0x342e6e[_0x01b3('0x66')](_0x1ea4c4);}_0x487988[_0x32f1e9][_0x01b3('0x77')]&&_0x342e6e['order'](_0x1ea4c4,_0x487988[_0x32f1e9][_0x01b3('0x77')]===_0x01b3('0x78')?![]:!![]);_0x342e6e[_0x01b3('0x67')](_0x1ea4c4,_0x487988[_0x32f1e9][_0x01b3('0x79')]||_0x1ea4c4);}if(_0x413f9d[_0x01b3('0x7a')]){_0x413f9d['joins']=JSON['parse'](_0x413f9d['joins']);for(var _0x1f6f90=0x0;_0x1f6f90<_0x413f9d[_0x01b3('0x7a')][_0x01b3('0x38')];_0x1f6f90+=0x1){if(_0x413f9d[_0x01b3('0x7a')][_0x1f6f90][_0x01b3('0x2e')]&&_[_0x01b3('0x88')](_0x1d53f5,_0x413f9d[_0x01b3('0x7a')][_0x1f6f90][_0x01b3('0x2e')])&&_0x413f9d[_0x01b3('0x7a')][_0x1f6f90][_0x01b3('0x7c')]&&_0x413f9d[_0x01b3('0x7a')][_0x1f6f90][_0x01b3('0x7d')]&&_0x413f9d[_0x01b3('0x7a')][_0x1f6f90][_0x01b3('0x7e')]){_0x342e6e[_0x413f9d[_0x01b3('0x7a')][_0x1f6f90]['type']](_0x413f9d['joins'][_0x1f6f90][_0x01b3('0x7d')],null,util['format']('%s.%s\x20=\x20%s.%s',_0x413f9d['table'],_0x413f9d[_0x01b3('0x7a')][_0x1f6f90]['parentKey'],_0x413f9d[_0x01b3('0x7a')][_0x1f6f90][_0x01b3('0x7d')],_0x413f9d[_0x01b3('0x7a')][_0x1f6f90][_0x01b3('0x7e')]));}}}if(_0x413f9d[_0x01b3('0x80')]){_0x413f9d[_0x01b3('0x80')]=JSON[_0x01b3('0x7b')](_0x413f9d[_0x01b3('0x80')]);_0x342e6e[_0x01b3('0x3b')](_0x25adf6(_0x413f9d['conditions'][_0x01b3('0x66')]));}_0x4a9197=_0x342e6e[_0x01b3('0x81')]();_0x342e6e[_0x01b3('0x1e')](_0x38a62d);_0x342e6e[_0x01b3('0x1d')](0x0);logger[_0x01b3('0x82')]('Limited\x20Query:',_0x342e6e['toString']());return db[_0x01b3('0x84')][_0x01b3('0x32')](_0x342e6e['toString'](),{'type':db[_0x01b3('0x84')][_0x01b3('0x8c')]['SELECT']});}})[_0x01b3('0x24')](function(_0x7eaaba){if(!_0x7eaaba[_0x01b3('0x38')]){throw new db[(_0x01b3('0x6a'))]['ValidationErrorItem'](_0x01b3('0x8d'),0xcc);}if(_0x377e64['output']===_0x01b3('0x8e')){return null;}var _0x24af38=_[_0x01b3('0x3e')](_0x377e64,{'name':_0x377e64['fullPath']||_0x377e64[_0x01b3('0x29')]||_0x413f9d[_0x01b3('0x29')],'basename':_0x3621bb,'savename':util[_0x01b3('0x75')](_0x01b3('0x8f'),_0x377e64['name']||_0x413f9d[_0x01b3('0x29')],require('randomstring')[_0x01b3('0x90')](0x4),_0x377e64[_0x01b3('0x91')]||_0x01b3('0x92')),'reportId':_0x413f9d['id'],'reportType':'default'});return db[_0x01b3('0x93')][_0x01b3('0x49')](_0x24af38,{'raw':!![]});})[_0x01b3('0x24')](function(_0x1145ca){if(_0x413f9d[_0x01b3('0x71')]===_0x01b3('0x94')){_0x4a9197[_0x01b3('0x3b')](_0x413f9d[_0x01b3('0x71')]+_0x01b3('0x95'),_0x377e64[_0x01b3('0x96')],_0x377e64[_0x01b3('0x97')]);}else{_0x4a9197['where'](_0x413f9d['table']+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x377e64[_0x01b3('0x96')],_0x377e64[_0x01b3('0x97')]);}if(_0x1145ca){logger[_0x01b3('0x98')]('Run\x20Query:',_0x4a9197[_0x01b3('0x83')]());require('child_process')['fork'](path[_0x01b3('0x52')](__dirname,'../../components/export/',_0x1145ca['output']),[_0x1145ca['id'],_0x4a9197[_0x01b3('0x83')](),path[_0x01b3('0x52')](__dirname,_0x01b3('0x99'),_0x1145ca['savename']),_0x3621bb]);return _0x1145ca;}else{var _0x179def=squel[_0x01b3('0x6f')]();_0x179def[_0x01b3('0x70')]('('+_0x4a9197[_0x01b3('0x83')]()+')',_0x01b3('0x9a'));_0x179def[_0x01b3('0x67')](_0x01b3('0x9b'),_0x01b3('0x40'));_0x4a9197['limit'](_0x377e64[_0x01b3('0x1e')]||_0x38a62d);_0x4a9197[_0x01b3('0x1d')](_0x377e64[_0x01b3('0x1d')]||0x0);return dbH[_0x01b3('0x84')][_0x01b3('0x32')](_0x179def[_0x01b3('0x83')](),{'type':dbH[_0x01b3('0x84')]['QueryTypes'][_0x01b3('0x85')]})['then'](function(_0x5dd32a){if(!_0x5dd32a['length']){_0x4fcdbb=0x0;}else{_0x4fcdbb=_0x5dd32a[0x0][_0x01b3('0x40')]||0x0;}return dbH['sequelize'][_0x01b3('0x32')](_0x4a9197[_0x01b3('0x83')](),{'type':dbH[_0x01b3('0x84')][_0x01b3('0x8c')][_0x01b3('0x85')]});})[_0x01b3('0x24')](function(_0x1bda9b){return{'rows':_0x1bda9b||[],'count':_0x4fcdbb};});}});}exports['run']=function(_0x501869,_0x58f5f2){return runReport(_0x501869['params'],_0x501869['query'],_0x501869[_0x01b3('0x3f')])[_0x01b3('0x24')](respondWithResult(_0x58f5f2,null))[_0x01b3('0x48')](handleError(_0x58f5f2,null));};exports[_0x01b3('0x9c')]=runReport;exports[_0x01b3('0x32')]=function(_0x1eae0f,_0x17b9ab){var _0x41de93=0xa;var _0x373995=[_0x01b3('0x52'),_0x01b3('0x9d'),_0x01b3('0x86'),_0x01b3('0x53')];var _0x3e3723={'SUM':_0x01b3('0x54'),'COUNT':'COUNT(%s)','COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x01b3('0x57'),'MIN':_0x01b3('0x58'),'AVG':'AVG(%s)','GROUP_CONCAT':_0x01b3('0x5a'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0x01b3('0x5b')};var _0x227214={'SEC_TO_TIME':_0x01b3('0x5c'),'DATE':_0x01b3('0x5d'),'HOUR':_0x01b3('0x5e'),'ROUND':_0x01b3('0x5f'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x24cf0a=function(_0x293365){return!_[_0x01b3('0x88')]([_0x01b3('0x61'),'IS\x20NOT\x20NULL','IS\x20EMPTY',_0x01b3('0x89')],_0x293365);};var _0xf80428=function(_0x2c50fd){if(!_0x2c50fd||!_0x2c50fd[_0x01b3('0x64')][_0x01b3('0x38')]){return'';}for(var _0x586e64='(',_0x5f4155=0x0;_0x5f4155<_0x2c50fd[_0x01b3('0x64')]['length'];_0x5f4155+=0x1){_0x5f4155>0x0&&(_0x586e64+='\x20'+_0x2c50fd[_0x01b3('0x65')]+'\x20');_0x586e64+=_0x2c50fd[_0x01b3('0x64')][_0x5f4155][_0x01b3('0x66')]?_0xf80428(_0x2c50fd[_0x01b3('0x64')][_0x5f4155][_0x01b3('0x66')]):_0x2c50fd[_0x01b3('0x64')][_0x5f4155][_0x01b3('0x67')]+'\x20'+_0x2c50fd['rules'][_0x5f4155][_0x01b3('0x68')]+(_0x24cf0a(_0x2c50fd[_0x01b3('0x64')][_0x5f4155]['condition'])?'\x20'+_0x2c50fd[_0x01b3('0x64')][_0x5f4155][_0x01b3('0x8a')]:'');}return _0x586e64+')';};var _0x203cd4={'where':{'id':_0x1eae0f[_0x01b3('0x45')]['id']}},_0x2e1740,_0x5ce14b,_0x2e1ca6,_0x35b2e2,_0x82abbb;_0x203cd4=_[_0x01b3('0x3e')]({},_0x203cd4,_0x1eae0f[_0x01b3('0x3f')]);return db[_0x01b3('0x2b')][_0x01b3('0x47')](_0x203cd4)[_0x01b3('0x24')](function(_0x17b6bc){if(_0x17b6bc){_0x2e1740=_0x17b6bc;return _0x17b6bc[_0x01b3('0x69')]();}return null;})[_0x01b3('0x24')](function(_0x557924){if(_0x557924){if(!_0x557924['length']){throw new db[(_0x01b3('0x6a'))]['ValidationErrorItem'](_0x01b3('0x6c'),0x193);}_0x5ce14b=_0x557924;return db[_0x01b3('0x6d')][_0x01b3('0x42')]({'raw':!![]});}return null;})['then'](function(_0x4b1288){if(_0x4b1288){_0x2e1ca6=_[_0x01b3('0x6e')](_0x4b1288,'id');var _0x2d4c6e;var _0x42455a=squel[_0x01b3('0x6f')]();_0x42455a['from'](_0x2e1740[_0x01b3('0x71')]);for(var _0x4699ab=0x0;_0x4699ab<_0x5ce14b[_0x01b3('0x38')];_0x4699ab+=0x1){_0x2d4c6e=_0x5ce14b[_0x4699ab]['MetricId']?_0x2e1ca6[_0x5ce14b[_0x4699ab][_0x01b3('0x72')]][_0x01b3('0x8b')]:_0x5ce14b[_0x4699ab][_0x01b3('0x67')];_0x2d4c6e=_0x5ce14b[_0x4699ab][_0x01b3('0x73')]?_['replace'](_0x3e3723[_0x5ce14b[_0x4699ab]['function']],'%s',_0x2d4c6e):_0x2d4c6e;_0x2d4c6e=_0x5ce14b[_0x4699ab][_0x01b3('0x75')]?_[_0x01b3('0x74')](_0x227214[_0x5ce14b[_0x4699ab][_0x01b3('0x75')]],'%s',_0x2d4c6e):_0x2d4c6e;if(_0x5ce14b[_0x4699ab][_0x01b3('0x76')]){_0x42455a[_0x01b3('0x66')](_0x2d4c6e);}_0x5ce14b[_0x4699ab][_0x01b3('0x77')]&&_0x42455a[_0x01b3('0x9e')](_0x2d4c6e,_0x5ce14b[_0x4699ab]['orderBy']==='DESC'?![]:!![]);_0x42455a[_0x01b3('0x67')](_0x2d4c6e,_0x5ce14b[_0x4699ab][_0x01b3('0x79')]||_0x2d4c6e);}if(_0x2e1740[_0x01b3('0x7a')]){_0x2e1740[_0x01b3('0x7a')]=JSON['parse'](_0x2e1740[_0x01b3('0x7a')]);for(var _0x29a386=0x0;_0x29a386<_0x2e1740[_0x01b3('0x7a')][_0x01b3('0x38')];_0x29a386+=0x1){if(_0x2e1740[_0x01b3('0x7a')][_0x29a386][_0x01b3('0x2e')]&&_[_0x01b3('0x88')](_0x373995,_0x2e1740[_0x01b3('0x7a')][_0x29a386][_0x01b3('0x2e')])&&_0x2e1740[_0x01b3('0x7a')][_0x29a386][_0x01b3('0x7c')]&&_0x2e1740[_0x01b3('0x7a')][_0x29a386][_0x01b3('0x7d')]&&_0x2e1740['joins'][_0x29a386][_0x01b3('0x7e')]){_0x42455a[_0x2e1740[_0x01b3('0x7a')][_0x29a386]['type']](_0x2e1740[_0x01b3('0x7a')][_0x29a386][_0x01b3('0x7d')],null,util['format'](_0x01b3('0x7f'),_0x2e1740[_0x01b3('0x71')],_0x2e1740[_0x01b3('0x7a')][_0x29a386]['parentKey'],_0x2e1740['joins'][_0x29a386][_0x01b3('0x7d')],_0x2e1740[_0x01b3('0x7a')][_0x29a386][_0x01b3('0x7e')]));}}}if(_0x2e1740[_0x01b3('0x80')]){_0x2e1740[_0x01b3('0x80')]=JSON[_0x01b3('0x7b')](_0x2e1740[_0x01b3('0x80')]);_0x42455a['where'](_0xf80428(_0x2e1740[_0x01b3('0x80')][_0x01b3('0x66')]));}_0x82abbb=_0x42455a[_0x01b3('0x81')]();_0x42455a[_0x01b3('0x1e')](_0x41de93);_0x42455a['offset'](0x0);logger[_0x01b3('0x82')](_0x01b3('0x9f'),_0x42455a[_0x01b3('0x83')]());return db[_0x01b3('0x84')]['query'](_0x42455a[_0x01b3('0x83')](),{'type':db[_0x01b3('0x84')]['QueryTypes'][_0x01b3('0x85')]});}})[_0x01b3('0x24')](function(){return{'sql':_0x82abbb[_0x01b3('0x83')]()};})['then'](respondWithResult(_0x17b9ab,null))[_0x01b3('0x48')](handleError(_0x17b9ab,null));};
\ No newline at end of file
+var _0xe171=['keys','intersection','fields','attributes','hasOwnProperty','nolimit','sort','pick','filter','where','merge','VIRTUAL','includeAll','findAll','rows','catch','show','length','include','create','body','user','Reports','find','userProfileId','autoAssociation','DefaultReports','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','preview','join','left_join','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','options','Sequelize','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','select','from','table','MetricId','metric','function','replace','format','groupBy','orderBy','order','DESC','joins','parse','type','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','parentKey','conditions','debug','Limited\x20Query:','sequelize','QueryTypes','SELECT','cross_join','SUM(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','DATE(%s)','value','getFields','alias','clone','toString','ValidationErrorItem','No\x20available\x20data','%s-%s.%s','randomstring','generate','default','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','Run\x20Query:','child_process','../../components/export/','output','../../files/reports','COUNT(*)','run','runReport','right_join','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','sox','to-csv','lodash','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','api','../../config/environment','../../mysqldb','dbH','sendStatus','status','end','json','count','offset','limit','Content-Range','apply','reject','save','update','then','destroy','get','UserProfileResource','error','stack','name','send','index','map','AnalyticDefaultReport','rawAttributes','fieldName','key','model','query'];(function(_0x10e337,_0x4b2143){var _0x1be4ff=function(_0xd46e7b){while(--_0xd46e7b){_0x10e337['push'](_0x10e337['shift']());}};_0x1be4ff(++_0x4b2143);}(_0xe171,0x118));var _0x1e17=function(_0x304c13,_0x22ac2e){_0x304c13=_0x304c13-0x0;var _0x335654=_0xe171[_0x304c13];return _0x335654;};'use strict';var pdf=require(_0x1e17('0x0'));var emlformat=require(_0x1e17('0x1'));var rimraf=require(_0x1e17('0x2'));var zipdir=require(_0x1e17('0x3'));var jsonpatch=require(_0x1e17('0x4'));var rp=require(_0x1e17('0x5'));var moment=require(_0x1e17('0x6'));var BPromise=require(_0x1e17('0x7'));var Mustache=require('mustache');var util=require(_0x1e17('0x8'));var path=require(_0x1e17('0x9'));var sox=require(_0x1e17('0xa'));var csv=require(_0x1e17('0xb'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x1e17('0xc'));var squel=require(_0x1e17('0xd'));var crypto=require(_0x1e17('0xe'));var jsforce=require(_0x1e17('0xf'));var deskjs=require('desk.js');var toCsv=require(_0x1e17('0xb'));var querystring=require(_0x1e17('0x10'));var Papa=require(_0x1e17('0x11'));var Redis=require(_0x1e17('0x12'));var authService=require(_0x1e17('0x13'));var qs=require(_0x1e17('0x14'));var as=require(_0x1e17('0x15'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0x1e17('0x16'));var utils=require('../../config/utils');var config=require(_0x1e17('0x17'));var db=require(_0x1e17('0x18'))['db'];var dbH=require(_0x1e17('0x18'))[_0x1e17('0x19')];function respondWithStatusCode(_0x1cc88a,_0x555e84){_0x555e84=_0x555e84||0xcc;return function(_0x63114b){if(_0x63114b){return _0x1cc88a[_0x1e17('0x1a')](_0x555e84);}return _0x1cc88a[_0x1e17('0x1b')](_0x555e84)[_0x1e17('0x1c')]();};}function respondWithResult(_0x2d448d,_0x3f31d3){_0x3f31d3=_0x3f31d3||0xc8;return function(_0xf7572d){if(_0xf7572d){return _0x2d448d[_0x1e17('0x1b')](_0x3f31d3)[_0x1e17('0x1d')](_0xf7572d);}};}function respondWithFilteredResult(_0x442779,_0x50a4ad){return function(_0x56a31a){if(_0x56a31a){var _0x200b68=_0x56a31a[_0x1e17('0x1e')],_0x12357e=_0x50a4ad[_0x1e17('0x1f')],_0x42277f=_0x50a4ad['offset']+_0x50a4ad[_0x1e17('0x20')],_0x4374c7;if(_0x42277f>=_0x200b68){_0x42277f=_0x200b68;_0x4374c7=0xc8;}else{_0x4374c7=0xce;}_0x442779[_0x1e17('0x1b')](_0x4374c7);return _0x442779['set'](_0x1e17('0x21'),_0x12357e+'-'+_0x42277f+'/'+_0x200b68)['json'](_0x56a31a);}return null;};}function patchUpdates(_0xff2824){return function(_0x5f0b8c){try{jsonpatch[_0x1e17('0x22')](_0x5f0b8c,_0xff2824,!![]);}catch(_0x527ee1){return BPromise[_0x1e17('0x23')](_0x527ee1);}return _0x5f0b8c[_0x1e17('0x24')]();};}function saveUpdates(_0x2e9f66,_0x2fe169){return function(_0x349dea){if(_0x349dea){return _0x349dea[_0x1e17('0x25')](_0x2e9f66)[_0x1e17('0x26')](function(_0x4c5301){return _0x4c5301;});}return null;};}function removeEntity(_0x3f80ba,_0xcea651){return function(_0x21df0d){if(_0x21df0d){return _0x21df0d[_0x1e17('0x27')]()['then'](function(){var _0x1af9fe=_0x21df0d[_0x1e17('0x28')]({'plain':!![]});var _0xa4d072='DefaultReports';return db[_0x1e17('0x29')][_0x1e17('0x27')]({'where':{'type':_0xa4d072,'resourceId':_0x1af9fe['id']}})[_0x1e17('0x26')](function(){return _0x21df0d;});})['then'](function(){_0x3f80ba[_0x1e17('0x1b')](0xcc)[_0x1e17('0x1c')]();});}};}function handleEntityNotFound(_0x2487e6,_0x34edf2){return function(_0x8a4d4){if(!_0x8a4d4){_0x2487e6[_0x1e17('0x1a')](0x194);}return _0x8a4d4;};}function handleError(_0x56a4cb,_0x1bd3f6){_0x1bd3f6=_0x1bd3f6||0x1f4;return function(_0x45d873){logger[_0x1e17('0x2a')](_0x45d873[_0x1e17('0x2b')]);if(_0x45d873['name']){delete _0x45d873[_0x1e17('0x2c')];}_0x56a4cb['status'](_0x1bd3f6)[_0x1e17('0x2d')](_0x45d873);};}exports[_0x1e17('0x2e')]=function(_0x4d1821,_0x6acaa3){var _0x138b04={},_0x5a35b6={},_0x54d435={'count':0x0,'rows':[]};var _0xc3134=_[_0x1e17('0x2f')](db[_0x1e17('0x30')][_0x1e17('0x31')],function(_0x54018c){return{'name':_0x54018c[_0x1e17('0x32')],'type':_0x54018c['type'][_0x1e17('0x33')]};});_0x5a35b6[_0x1e17('0x34')]=_[_0x1e17('0x2f')](_0xc3134,_0x1e17('0x2c'));_0x5a35b6[_0x1e17('0x35')]=_[_0x1e17('0x36')](_0x4d1821[_0x1e17('0x35')]);_0x5a35b6['filters']=_['intersection'](_0x5a35b6['model'],_0x5a35b6[_0x1e17('0x35')]);_0x138b04['attributes']=_[_0x1e17('0x37')](_0x5a35b6[_0x1e17('0x34')],qs[_0x1e17('0x38')](_0x4d1821['query']['fields']));_0x138b04[_0x1e17('0x39')]=_0x138b04['attributes']['length']?_0x138b04[_0x1e17('0x39')]:_0x5a35b6[_0x1e17('0x34')];if(!_0x4d1821[_0x1e17('0x35')][_0x1e17('0x3a')](_0x1e17('0x3b'))){_0x138b04[_0x1e17('0x20')]=qs[_0x1e17('0x20')](_0x4d1821[_0x1e17('0x35')][_0x1e17('0x20')]);_0x138b04[_0x1e17('0x1f')]=qs[_0x1e17('0x1f')](_0x4d1821[_0x1e17('0x35')][_0x1e17('0x1f')]);}_0x138b04['order']=qs[_0x1e17('0x3c')](_0x4d1821['query'][_0x1e17('0x3c')]);_0x138b04['where']=qs['filters'](_[_0x1e17('0x3d')](_0x4d1821[_0x1e17('0x35')],_0x5a35b6['filters']),_0xc3134);if(_0x4d1821[_0x1e17('0x35')][_0x1e17('0x3e')]){_0x138b04[_0x1e17('0x3f')]=_[_0x1e17('0x40')](_0x138b04[_0x1e17('0x3f')],{'$or':_[_0x1e17('0x2f')](_0xc3134,function(_0x284bb2){if(_0x284bb2['type']!==_0x1e17('0x41')){var _0x14eea2={};_0x14eea2[_0x284bb2[_0x1e17('0x2c')]]={'$like':'%'+_0x4d1821[_0x1e17('0x35')]['filter']+'%'};return _0x14eea2;}})});}_0x138b04=_[_0x1e17('0x40')]({},_0x138b04,_0x4d1821['options']);var _0x70baa={'where':_0x138b04['where']};return db[_0x1e17('0x30')][_0x1e17('0x1e')](_0x70baa)[_0x1e17('0x26')](function(_0x1080e1){_0x54d435[_0x1e17('0x1e')]=_0x1080e1;if(_0x4d1821[_0x1e17('0x35')][_0x1e17('0x42')]){_0x138b04['include']=[{'all':!![]}];}return db[_0x1e17('0x30')][_0x1e17('0x43')](_0x138b04);})[_0x1e17('0x26')](function(_0xc399fe){_0x54d435[_0x1e17('0x44')]=_0xc399fe;return _0x54d435;})[_0x1e17('0x26')](respondWithFilteredResult(_0x6acaa3,_0x138b04))[_0x1e17('0x45')](handleError(_0x6acaa3,null));};exports[_0x1e17('0x46')]=function(_0x124cc9,_0x2c125b){var _0x462848={'raw':!![],'where':{'id':_0x124cc9['params']['id']}},_0x5e28ce={};_0x5e28ce[_0x1e17('0x34')]=_[_0x1e17('0x36')](db['AnalyticDefaultReport'][_0x1e17('0x31')]);_0x5e28ce[_0x1e17('0x35')]=_[_0x1e17('0x36')](_0x124cc9['query']);_0x5e28ce['filters']=_[_0x1e17('0x37')](_0x5e28ce[_0x1e17('0x34')],_0x5e28ce[_0x1e17('0x35')]);_0x462848[_0x1e17('0x39')]=_['intersection'](_0x5e28ce[_0x1e17('0x34')],qs[_0x1e17('0x38')](_0x124cc9[_0x1e17('0x35')][_0x1e17('0x38')]));_0x462848['attributes']=_0x462848[_0x1e17('0x39')][_0x1e17('0x47')]?_0x462848['attributes']:_0x5e28ce[_0x1e17('0x34')];if(_0x124cc9['query']['includeAll']){_0x462848[_0x1e17('0x48')]=[{'all':!![]}];}_0x462848=_[_0x1e17('0x40')]({},_0x462848,_0x124cc9['options']);return db[_0x1e17('0x30')]['find'](_0x462848)[_0x1e17('0x26')](handleEntityNotFound(_0x2c125b,null))['then'](respondWithResult(_0x2c125b,null))[_0x1e17('0x45')](handleError(_0x2c125b,null));};exports['create']=function(_0x324e73,_0x26a035){return db[_0x1e17('0x30')][_0x1e17('0x49')](_0x324e73[_0x1e17('0x4a')],{})[_0x1e17('0x26')](function(_0x2db30b){var _0x1e777f=_0x324e73['user'][_0x1e17('0x28')]({'plain':!![]});if(!_0x1e777f)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x1e777f['role']===_0x1e17('0x4b')){var _0x5b1492=_0x2db30b[_0x1e17('0x28')]({'plain':!![]});var _0x38d70b=_0x1e17('0x4c');return db['UserProfileSection'][_0x1e17('0x4d')]({'where':{'name':_0x38d70b,'userProfileId':_0x1e777f[_0x1e17('0x4e')]},'raw':!![]})[_0x1e17('0x26')](function(_0x1de01d){if(_0x1de01d&&_0x1de01d[_0x1e17('0x4f')]===0x0){return db[_0x1e17('0x29')][_0x1e17('0x49')]({'name':_0x5b1492[_0x1e17('0x2c')],'resourceId':_0x5b1492['id'],'type':_0x1e17('0x50'),'sectionId':_0x1de01d['id']},{})[_0x1e17('0x26')](function(){return _0x2db30b;});}else{return _0x2db30b;}})['catch'](function(_0x3b97a9){logger[_0x1e17('0x2a')](_0x1e17('0x51'),_0x3b97a9);throw _0x3b97a9;});}return _0x2db30b;})[_0x1e17('0x26')](respondWithResult(_0x26a035,0xc9))[_0x1e17('0x45')](handleError(_0x26a035,null));};exports[_0x1e17('0x25')]=function(_0x12f833,_0x208756){if(_0x12f833['body']['id']){delete _0x12f833[_0x1e17('0x4a')]['id'];}return db[_0x1e17('0x30')][_0x1e17('0x4d')]({'where':{'id':_0x12f833[_0x1e17('0x52')]['id']}})[_0x1e17('0x26')](handleEntityNotFound(_0x208756,null))[_0x1e17('0x26')](saveUpdates(_0x12f833['body'],null))[_0x1e17('0x26')](respondWithResult(_0x208756,null))[_0x1e17('0x45')](handleError(_0x208756,null));};exports['destroy']=function(_0x4657c5,_0x569544){return db[_0x1e17('0x30')][_0x1e17('0x4d')]({'where':{'id':_0x4657c5['params']['id']}})[_0x1e17('0x26')](handleEntityNotFound(_0x569544,null))[_0x1e17('0x26')](removeEntity(_0x569544,null))[_0x1e17('0x45')](handleError(_0x569544,null));};exports[_0x1e17('0x53')]=function(_0x10b966,_0x2cb24f){var _0x538c71=0xa;var _0x266a3d=[_0x1e17('0x54'),_0x1e17('0x55'),'right_join','cross_join'];var _0x4872b6={'SUM':'SUM(%s)','COUNT':_0x1e17('0x56'),'COUNT DISTINCT':_0x1e17('0x57'),'MAX':_0x1e17('0x58'),'MIN':_0x1e17('0x59'),'AVG':_0x1e17('0x5a'),'GROUP_CONCAT':_0x1e17('0x5b'),'GROUP_CONCAT ASC':_0x1e17('0x5c'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x5b3678={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':'DATE(%s)','HOUR':_0x1e17('0x5d'),'ROUND':_0x1e17('0x5e'),'UNIX_TIMESTAMP':_0x1e17('0x5f')};var _0x2e5da3=function(_0x3beb6a){return!_[_0x1e17('0x60')]([_0x1e17('0x61'),_0x1e17('0x62'),_0x1e17('0x63'),_0x1e17('0x64')],_0x3beb6a);};var _0x2a2071=function(_0x2764f1){if(!_0x2764f1||!_0x2764f1['rules'][_0x1e17('0x47')]){return'';}for(var _0x230648='(',_0x24265a=0x0;_0x24265a<_0x2764f1[_0x1e17('0x65')][_0x1e17('0x47')];_0x24265a+=0x1){_0x24265a>0x0&&(_0x230648+='\x20'+_0x2764f1[_0x1e17('0x66')]+'\x20');_0x230648+=_0x2764f1[_0x1e17('0x65')][_0x24265a][_0x1e17('0x67')]?_0x2a2071(_0x2764f1[_0x1e17('0x65')][_0x24265a][_0x1e17('0x67')]):_0x2764f1[_0x1e17('0x65')][_0x24265a][_0x1e17('0x68')]+'\x20'+_0x2764f1[_0x1e17('0x65')][_0x24265a][_0x1e17('0x69')]+(_0x2e5da3(_0x2764f1[_0x1e17('0x65')][_0x24265a][_0x1e17('0x69')])?'\x20'+_0x2764f1[_0x1e17('0x65')][_0x24265a]['value']:'');}return _0x230648+')';};var _0x42e7a0={'where':{'id':_0x10b966[_0x1e17('0x52')]['id']}},_0x10102a,_0x48e228,_0x509c27,_0x36e77d,_0x25e779;_0x42e7a0=_[_0x1e17('0x40')]({},_0x42e7a0,_0x10b966[_0x1e17('0x6a')]);return db[_0x1e17('0x30')][_0x1e17('0x4d')](_0x42e7a0)[_0x1e17('0x26')](function(_0x22c89d){if(_0x22c89d){_0x10102a=_0x22c89d;return _0x22c89d['getFields']();}return null;})[_0x1e17('0x26')](function(_0x6b2edc){if(_0x6b2edc){if(!_0x6b2edc[_0x1e17('0x47')]){throw new db[(_0x1e17('0x6b'))]['ValidationErrorItem'](_0x1e17('0x6c'),0x193);}_0x48e228=_0x6b2edc;return db[_0x1e17('0x6d')][_0x1e17('0x43')]({'raw':!![]});}return null;})['then'](function(_0x542fb1){if(_0x542fb1){_0x509c27=_[_0x1e17('0x6e')](_0x542fb1,'id');var _0x5c47c7;var _0x444a37=squel[_0x1e17('0x6f')]();_0x444a37[_0x1e17('0x70')](_0x10102a[_0x1e17('0x71')]);for(var _0x1f6679=0x0;_0x1f6679<_0x48e228[_0x1e17('0x47')];_0x1f6679+=0x1){_0x5c47c7=_0x48e228[_0x1f6679][_0x1e17('0x72')]?_0x509c27[_0x48e228[_0x1f6679][_0x1e17('0x72')]][_0x1e17('0x73')]:_0x48e228[_0x1f6679]['field'];_0x5c47c7=_0x48e228[_0x1f6679][_0x1e17('0x74')]?_['replace'](_0x4872b6[_0x48e228[_0x1f6679]['function']],'%s',_0x5c47c7):_0x5c47c7;_0x5c47c7=_0x48e228[_0x1f6679]['format']?_[_0x1e17('0x75')](_0x5b3678[_0x48e228[_0x1f6679][_0x1e17('0x76')]],'%s',_0x5c47c7):_0x5c47c7;if(_0x48e228[_0x1f6679][_0x1e17('0x77')]){_0x444a37[_0x1e17('0x67')](_0x5c47c7);}_0x48e228[_0x1f6679][_0x1e17('0x78')]&&_0x444a37[_0x1e17('0x79')](_0x5c47c7,_0x48e228[_0x1f6679][_0x1e17('0x78')]===_0x1e17('0x7a')?![]:!![]);_0x444a37[_0x1e17('0x68')](_0x5c47c7,_0x48e228[_0x1f6679]['alias']||_0x5c47c7);}if(_0x10102a['joins']){_0x10102a[_0x1e17('0x7b')]=JSON[_0x1e17('0x7c')](_0x10102a['joins']);for(var _0x65e343=0x0;_0x65e343<_0x10102a['joins'][_0x1e17('0x47')];_0x65e343+=0x1){if(_0x10102a[_0x1e17('0x7b')][_0x65e343][_0x1e17('0x7d')]&&_[_0x1e17('0x60')](_0x266a3d,_0x10102a[_0x1e17('0x7b')][_0x65e343][_0x1e17('0x7d')])&&_0x10102a[_0x1e17('0x7b')][_0x65e343]['parentKey']&&_0x10102a[_0x1e17('0x7b')][_0x65e343][_0x1e17('0x7e')]&&_0x10102a[_0x1e17('0x7b')][_0x65e343][_0x1e17('0x7f')]){_0x444a37[_0x10102a[_0x1e17('0x7b')][_0x65e343][_0x1e17('0x7d')]](_0x10102a[_0x1e17('0x7b')][_0x65e343]['foreignTable'],null,util['format'](_0x1e17('0x80'),_0x10102a[_0x1e17('0x71')],_0x10102a[_0x1e17('0x7b')][_0x65e343][_0x1e17('0x81')],_0x10102a[_0x1e17('0x7b')][_0x65e343][_0x1e17('0x7e')],_0x10102a['joins'][_0x65e343]['foreignKey']));}}}if(_0x10102a[_0x1e17('0x82')]){_0x10102a[_0x1e17('0x82')]=JSON[_0x1e17('0x7c')](_0x10102a[_0x1e17('0x82')]);_0x444a37[_0x1e17('0x3f')](_0x2a2071(_0x10102a['conditions'][_0x1e17('0x67')]));}_0x25e779=_0x444a37['clone']();_0x444a37['limit'](_0x538c71);_0x444a37[_0x1e17('0x1f')](0x0);logger[_0x1e17('0x83')](_0x1e17('0x84'),_0x444a37['toString']());return db[_0x1e17('0x85')][_0x1e17('0x35')](_0x444a37['toString'](),{'type':db[_0x1e17('0x85')][_0x1e17('0x86')][_0x1e17('0x87')]});}})['then'](respondWithResult(_0x2cb24f,null))[_0x1e17('0x45')](handleError(_0x2cb24f,null));};function runReport(_0x6359c4,_0x206abf,_0x35652a){var _0x856be8=_0x206abf[_0x1e17('0x2c')];var _0x329b3a=0xa;var _0xc41ef5=[_0x1e17('0x54'),'left_join','right_join',_0x1e17('0x88')];var _0x4b47be={'SUM':_0x1e17('0x89'),'COUNT':_0x1e17('0x56'),'COUNT DISTINCT':_0x1e17('0x57'),'MAX':_0x1e17('0x58'),'MIN':'MIN(%s)','AVG':_0x1e17('0x5a'),'GROUP_CONCAT':_0x1e17('0x5b'),'GROUP_CONCAT ASC':_0x1e17('0x5c'),'GROUP_CONCAT DESC':_0x1e17('0x8a')};var _0x5163c7={'SEC_TO_TIME':_0x1e17('0x8b'),'DATE':_0x1e17('0x8c'),'HOUR':_0x1e17('0x5d'),'ROUND':_0x1e17('0x5e'),'UNIX_TIMESTAMP':_0x1e17('0x5f')};var _0x520dfd=function(_0x1e3b68){return!_[_0x1e17('0x60')]([_0x1e17('0x61'),'IS\x20NOT\x20NULL',_0x1e17('0x63'),_0x1e17('0x64')],_0x1e3b68);};var _0x490c06=function(_0x1a9748){if(!_0x1a9748||!_0x1a9748['rules']['length']){return'';}for(var _0x52e257='(',_0xf0f71a=0x0;_0xf0f71a<_0x1a9748[_0x1e17('0x65')][_0x1e17('0x47')];_0xf0f71a+=0x1){_0xf0f71a>0x0&&(_0x52e257+='\x20'+_0x1a9748['operator']+'\x20');_0x52e257+=_0x1a9748[_0x1e17('0x65')][_0xf0f71a]['group']?_0x490c06(_0x1a9748[_0x1e17('0x65')][_0xf0f71a]['group']):_0x1a9748['rules'][_0xf0f71a][_0x1e17('0x68')]+'\x20'+_0x1a9748['rules'][_0xf0f71a]['condition']+(_0x520dfd(_0x1a9748[_0x1e17('0x65')][_0xf0f71a][_0x1e17('0x69')])?'\x20'+_0x1a9748[_0x1e17('0x65')][_0xf0f71a][_0x1e17('0x8d')]:'');}return _0x52e257+')';};var _0x22b349={'where':{'id':_0x6359c4['id']}},_0x54e4dc,_0x14d359,_0x314a86,_0x49c7a0,_0x2da280;_0x22b349=_['merge']({},_0x22b349,_0x35652a);return db[_0x1e17('0x30')]['find'](_0x22b349)[_0x1e17('0x26')](function(_0x2c0450){if(_0x2c0450){_0x54e4dc=_0x2c0450;return _0x2c0450[_0x1e17('0x8e')]();}return null;})[_0x1e17('0x26')](function(_0x5521e7){if(_0x5521e7){if(!_0x5521e7['length']){throw new db[(_0x1e17('0x6b'))]['ValidationErrorItem'](_0x1e17('0x6c'),0x193);}_0x14d359=_0x5521e7;return db[_0x1e17('0x6d')]['findAll']({'raw':!![]});}return null;})[_0x1e17('0x26')](function(_0x3228cc){if(_0x3228cc){_0x314a86=_[_0x1e17('0x6e')](_0x3228cc,'id');var _0x48f5f9;var _0x551e98=squel[_0x1e17('0x6f')]();_0x551e98['from'](_0x54e4dc[_0x1e17('0x71')]);for(var _0x254953=0x0;_0x254953<_0x14d359['length'];_0x254953+=0x1){_0x48f5f9=_0x14d359[_0x254953]['MetricId']?_0x314a86[_0x14d359[_0x254953]['MetricId']]['metric']:_0x14d359[_0x254953]['field'];_0x48f5f9=_0x14d359[_0x254953][_0x1e17('0x74')]?_[_0x1e17('0x75')](_0x4b47be[_0x14d359[_0x254953][_0x1e17('0x74')]],'%s',_0x48f5f9):_0x48f5f9;_0x48f5f9=_0x14d359[_0x254953][_0x1e17('0x76')]?_[_0x1e17('0x75')](_0x5163c7[_0x14d359[_0x254953][_0x1e17('0x76')]],'%s',_0x48f5f9):_0x48f5f9;if(_0x14d359[_0x254953]['groupBy']){_0x551e98['group'](_0x48f5f9);}_0x14d359[_0x254953]['orderBy']&&_0x551e98[_0x1e17('0x79')](_0x48f5f9,_0x14d359[_0x254953][_0x1e17('0x78')]===_0x1e17('0x7a')?![]:!![]);_0x551e98['field'](_0x48f5f9,_0x14d359[_0x254953][_0x1e17('0x8f')]||_0x48f5f9);}if(_0x54e4dc[_0x1e17('0x7b')]){_0x54e4dc['joins']=JSON[_0x1e17('0x7c')](_0x54e4dc[_0x1e17('0x7b')]);for(var _0x20b1ff=0x0;_0x20b1ff<_0x54e4dc[_0x1e17('0x7b')][_0x1e17('0x47')];_0x20b1ff+=0x1){if(_0x54e4dc[_0x1e17('0x7b')][_0x20b1ff][_0x1e17('0x7d')]&&_[_0x1e17('0x60')](_0xc41ef5,_0x54e4dc['joins'][_0x20b1ff][_0x1e17('0x7d')])&&_0x54e4dc['joins'][_0x20b1ff][_0x1e17('0x81')]&&_0x54e4dc[_0x1e17('0x7b')][_0x20b1ff]['foreignTable']&&_0x54e4dc['joins'][_0x20b1ff][_0x1e17('0x7f')]){_0x551e98[_0x54e4dc[_0x1e17('0x7b')][_0x20b1ff][_0x1e17('0x7d')]](_0x54e4dc[_0x1e17('0x7b')][_0x20b1ff][_0x1e17('0x7e')],null,util[_0x1e17('0x76')](_0x1e17('0x80'),_0x54e4dc[_0x1e17('0x71')],_0x54e4dc[_0x1e17('0x7b')][_0x20b1ff][_0x1e17('0x81')],_0x54e4dc[_0x1e17('0x7b')][_0x20b1ff][_0x1e17('0x7e')],_0x54e4dc['joins'][_0x20b1ff][_0x1e17('0x7f')]));}}}if(_0x54e4dc[_0x1e17('0x82')]){_0x54e4dc[_0x1e17('0x82')]=JSON[_0x1e17('0x7c')](_0x54e4dc[_0x1e17('0x82')]);_0x551e98[_0x1e17('0x3f')](_0x490c06(_0x54e4dc['conditions'][_0x1e17('0x67')]));}_0x2da280=_0x551e98[_0x1e17('0x90')]();_0x551e98[_0x1e17('0x20')](_0x329b3a);_0x551e98[_0x1e17('0x1f')](0x0);logger[_0x1e17('0x83')](_0x1e17('0x84'),_0x551e98[_0x1e17('0x91')]());return db[_0x1e17('0x85')][_0x1e17('0x35')](_0x551e98[_0x1e17('0x91')](),{'type':db['sequelize'][_0x1e17('0x86')][_0x1e17('0x87')]});}})[_0x1e17('0x26')](function(_0x58d1be){if(!_0x58d1be['length']){throw new db['Sequelize'][(_0x1e17('0x92'))](_0x1e17('0x93'),0xcc);}if(_0x206abf['output']==='web'){return null;}var _0x26bb3b=_[_0x1e17('0x40')](_0x206abf,{'name':_0x206abf['fullPath']||_0x206abf[_0x1e17('0x2c')]||_0x54e4dc[_0x1e17('0x2c')],'basename':_0x856be8,'savename':util[_0x1e17('0x76')](_0x1e17('0x94'),_0x206abf[_0x1e17('0x2c')]||_0x54e4dc[_0x1e17('0x2c')],require(_0x1e17('0x95'))[_0x1e17('0x96')](0x4),_0x206abf['output']||'csv'),'reportId':_0x54e4dc['id'],'reportType':_0x1e17('0x97')});return db[_0x1e17('0x98')][_0x1e17('0x49')](_0x26bb3b,{'raw':!![]});})[_0x1e17('0x26')](function(_0x22b1bc){if(_0x54e4dc[_0x1e17('0x71')]===_0x1e17('0x99')){_0x2da280[_0x1e17('0x3f')](_0x54e4dc[_0x1e17('0x71')]+_0x1e17('0x9a'),_0x206abf[_0x1e17('0x9b')],_0x206abf[_0x1e17('0x9c')]);}else{_0x2da280[_0x1e17('0x3f')](_0x54e4dc['table']+_0x1e17('0x9d'),_0x206abf[_0x1e17('0x9b')],_0x206abf[_0x1e17('0x9c')]);}if(_0x22b1bc){logger['info'](_0x1e17('0x9e'),_0x2da280[_0x1e17('0x91')]());require(_0x1e17('0x9f'))['fork'](path[_0x1e17('0x54')](__dirname,_0x1e17('0xa0'),_0x22b1bc[_0x1e17('0xa1')]),[_0x22b1bc['id'],_0x2da280[_0x1e17('0x91')](),path[_0x1e17('0x54')](__dirname,_0x1e17('0xa2'),_0x22b1bc['savename']),_0x856be8]);return _0x22b1bc;}else{var _0x562be5=squel[_0x1e17('0x6f')]();_0x562be5[_0x1e17('0x70')]('('+_0x2da280['toString']()+')','countTable');_0x562be5['field'](_0x1e17('0xa3'),_0x1e17('0x1e'));_0x2da280[_0x1e17('0x20')](_0x206abf[_0x1e17('0x20')]||_0x329b3a);_0x2da280[_0x1e17('0x1f')](_0x206abf[_0x1e17('0x1f')]||0x0);return dbH[_0x1e17('0x85')]['query'](_0x562be5[_0x1e17('0x91')](),{'type':dbH['sequelize'][_0x1e17('0x86')][_0x1e17('0x87')]})[_0x1e17('0x26')](function(_0x51d7d7){if(!_0x51d7d7[_0x1e17('0x47')]){_0x49c7a0=0x0;}else{_0x49c7a0=_0x51d7d7[0x0][_0x1e17('0x1e')]||0x0;}return dbH[_0x1e17('0x85')]['query'](_0x2da280[_0x1e17('0x91')](),{'type':dbH[_0x1e17('0x85')][_0x1e17('0x86')][_0x1e17('0x87')]});})['then'](function(_0x80a719){return{'rows':_0x80a719||[],'count':_0x49c7a0};});}});}exports[_0x1e17('0xa4')]=function(_0x4741e1,_0xfa0934){return runReport(_0x4741e1[_0x1e17('0x52')],_0x4741e1[_0x1e17('0x35')],_0x4741e1[_0x1e17('0x6a')])[_0x1e17('0x26')](respondWithResult(_0xfa0934,null))['catch'](handleError(_0xfa0934,null));};exports[_0x1e17('0xa5')]=runReport;exports[_0x1e17('0x35')]=function(_0x355eb1,_0x9486e4){var _0x290bb6=0xa;var _0x25d8b0=[_0x1e17('0x54'),_0x1e17('0x55'),_0x1e17('0xa6'),_0x1e17('0x88')];var _0x45344f={'SUM':_0x1e17('0x89'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x1e17('0x57'),'MAX':'MAX(%s)','MIN':_0x1e17('0x59'),'AVG':_0x1e17('0x5a'),'GROUP_CONCAT':_0x1e17('0x5b'),'GROUP_CONCAT ASC':_0x1e17('0x5c'),'GROUP_CONCAT DESC':_0x1e17('0x8a')};var _0x403b36={'SEC_TO_TIME':_0x1e17('0x8b'),'DATE':'DATE(%s)','HOUR':_0x1e17('0x5d'),'ROUND':_0x1e17('0x5e'),'UNIX_TIMESTAMP':_0x1e17('0x5f')};var _0x1d6104=function(_0x1f6b83){return!_['includes']([_0x1e17('0x61'),_0x1e17('0x62'),_0x1e17('0x63'),'IS\x20NOT\x20EMPTY'],_0x1f6b83);};var _0x448a85=function(_0x1c8222){if(!_0x1c8222||!_0x1c8222['rules']['length']){return'';}for(var _0xe178b2='(',_0xf34914=0x0;_0xf34914<_0x1c8222['rules'][_0x1e17('0x47')];_0xf34914+=0x1){_0xf34914>0x0&&(_0xe178b2+='\x20'+_0x1c8222['operator']+'\x20');_0xe178b2+=_0x1c8222[_0x1e17('0x65')][_0xf34914][_0x1e17('0x67')]?_0x448a85(_0x1c8222[_0x1e17('0x65')][_0xf34914][_0x1e17('0x67')]):_0x1c8222['rules'][_0xf34914]['field']+'\x20'+_0x1c8222['rules'][_0xf34914][_0x1e17('0x69')]+(_0x1d6104(_0x1c8222['rules'][_0xf34914][_0x1e17('0x69')])?'\x20'+_0x1c8222[_0x1e17('0x65')][_0xf34914][_0x1e17('0x8d')]:'');}return _0xe178b2+')';};var _0x12af9e={'where':{'id':_0x355eb1['params']['id']}},_0x7dad48,_0x2803f0,_0x3b715d,_0x322940,_0x4ab371;_0x12af9e=_[_0x1e17('0x40')]({},_0x12af9e,_0x355eb1['options']);return db[_0x1e17('0x30')][_0x1e17('0x4d')](_0x12af9e)[_0x1e17('0x26')](function(_0x14fbfd){if(_0x14fbfd){_0x7dad48=_0x14fbfd;return _0x14fbfd['getFields']();}return null;})[_0x1e17('0x26')](function(_0x439e3a){if(_0x439e3a){if(!_0x439e3a[_0x1e17('0x47')]){throw new db[(_0x1e17('0x6b'))][(_0x1e17('0x92'))](_0x1e17('0x6c'),0x193);}_0x2803f0=_0x439e3a;return db[_0x1e17('0x6d')][_0x1e17('0x43')]({'raw':!![]});}return null;})[_0x1e17('0x26')](function(_0x5d2a08){if(_0x5d2a08){_0x3b715d=_[_0x1e17('0x6e')](_0x5d2a08,'id');var _0x4e6231;var _0x5136e4=squel[_0x1e17('0x6f')]();_0x5136e4['from'](_0x7dad48[_0x1e17('0x71')]);for(var _0x3e8569=0x0;_0x3e8569<_0x2803f0[_0x1e17('0x47')];_0x3e8569+=0x1){_0x4e6231=_0x2803f0[_0x3e8569]['MetricId']?_0x3b715d[_0x2803f0[_0x3e8569][_0x1e17('0x72')]][_0x1e17('0x73')]:_0x2803f0[_0x3e8569]['field'];_0x4e6231=_0x2803f0[_0x3e8569][_0x1e17('0x74')]?_[_0x1e17('0x75')](_0x45344f[_0x2803f0[_0x3e8569]['function']],'%s',_0x4e6231):_0x4e6231;_0x4e6231=_0x2803f0[_0x3e8569]['format']?_[_0x1e17('0x75')](_0x403b36[_0x2803f0[_0x3e8569][_0x1e17('0x76')]],'%s',_0x4e6231):_0x4e6231;if(_0x2803f0[_0x3e8569][_0x1e17('0x77')]){_0x5136e4[_0x1e17('0x67')](_0x4e6231);}_0x2803f0[_0x3e8569][_0x1e17('0x78')]&&_0x5136e4['order'](_0x4e6231,_0x2803f0[_0x3e8569][_0x1e17('0x78')]===_0x1e17('0x7a')?![]:!![]);_0x5136e4[_0x1e17('0x68')](_0x4e6231,_0x2803f0[_0x3e8569][_0x1e17('0x8f')]||_0x4e6231);}if(_0x7dad48[_0x1e17('0x7b')]){_0x7dad48[_0x1e17('0x7b')]=JSON[_0x1e17('0x7c')](_0x7dad48[_0x1e17('0x7b')]);for(var _0xf67e84=0x0;_0xf67e84<_0x7dad48[_0x1e17('0x7b')][_0x1e17('0x47')];_0xf67e84+=0x1){if(_0x7dad48[_0x1e17('0x7b')][_0xf67e84][_0x1e17('0x7d')]&&_[_0x1e17('0x60')](_0x25d8b0,_0x7dad48[_0x1e17('0x7b')][_0xf67e84][_0x1e17('0x7d')])&&_0x7dad48['joins'][_0xf67e84][_0x1e17('0x81')]&&_0x7dad48[_0x1e17('0x7b')][_0xf67e84][_0x1e17('0x7e')]&&_0x7dad48[_0x1e17('0x7b')][_0xf67e84]['foreignKey']){_0x5136e4[_0x7dad48['joins'][_0xf67e84][_0x1e17('0x7d')]](_0x7dad48[_0x1e17('0x7b')][_0xf67e84][_0x1e17('0x7e')],null,util['format']('%s.%s\x20=\x20%s.%s',_0x7dad48[_0x1e17('0x71')],_0x7dad48[_0x1e17('0x7b')][_0xf67e84][_0x1e17('0x81')],_0x7dad48[_0x1e17('0x7b')][_0xf67e84]['foreignTable'],_0x7dad48[_0x1e17('0x7b')][_0xf67e84][_0x1e17('0x7f')]));}}}if(_0x7dad48['conditions']){_0x7dad48[_0x1e17('0x82')]=JSON[_0x1e17('0x7c')](_0x7dad48[_0x1e17('0x82')]);_0x5136e4['where'](_0x448a85(_0x7dad48['conditions'][_0x1e17('0x67')]));}_0x4ab371=_0x5136e4['clone']();_0x5136e4['limit'](_0x290bb6);_0x5136e4[_0x1e17('0x1f')](0x0);logger[_0x1e17('0x83')]('Limited\x20Query:',_0x5136e4[_0x1e17('0x91')]());return db[_0x1e17('0x85')][_0x1e17('0x35')](_0x5136e4[_0x1e17('0x91')](),{'type':db['sequelize']['QueryTypes'][_0x1e17('0x87')]});}})[_0x1e17('0x26')](function(){return{'sql':_0x4ab371[_0x1e17('0x91')]()};})[_0x1e17('0x26')](respondWithResult(_0x9486e4,null))[_0x1e17('0x45')](handleError(_0x9486e4,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff