// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x96fd=['fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','dbH','sendStatus','status','end','json','count','offset','limit','set','Content-Range','apply','reject','save','update','then','DefaultReports','UserProfileResource','destroy','error','stack','name','send','index','AnalyticDefaultReport','rawAttributes','type','key','model','keys','filters','intersection','query','attributes','fields','hasOwnProperty','order','sort','pick','filter','where','merge','VIRTUAL','includeAll','include','rows','catch','show','params','length','options','find','create','body','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','preview','left_join','right_join','cross_join','COUNT(DISTINCT\x20%s)','MAX(%s)','AVG(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','DATE(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NOT\x20NULL','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','getFields','ValidationErrorItem','select','from','table','MetricId','function','replace','format','groupBy','orderBy','DESC','alias','joins','parse','foreignKey','foreignTable','conditions','clone','Limited\x20Query:','sequelize','toString','QueryTypes','join','SUM(%s)','MIN(%s)','HOUR(%s)','IS\x20NULL','IS\x20EMPTY','value','Sequelize','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','findAll','keyBy','metric','parentKey','%s.%s\x20=\x20%s.%s','output','web','%s-%s.%s','randomstring','generate','csv','cdr','endDate','info','Run\x20Query:','child_process','../../components/export/','../../files/reports','savename','countTable','COUNT(*)','SELECT','run','runReport','eml-format','zip-dir','fast-json-patch','moment','bluebird','mustache','util','sox','to-csv'];(function(_0x4cc8f9,_0xb142f8){var _0x515637=function(_0x342441){while(--_0x342441){_0x4cc8f9['push'](_0x4cc8f9['shift']());}};_0x515637(++_0xb142f8);}(_0x96fd,0x1e9));var _0xd96f=function(_0x4a7a41,_0x48821c){_0x4a7a41=_0x4a7a41-0x0;var _0x356dfa=_0x96fd[_0x4a7a41];return _0x356dfa;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0xd96f('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xd96f('0x1'));var jsonpatch=require(_0xd96f('0x2'));var rp=require('request-promise');var moment=require(_0xd96f('0x3'));var BPromise=require(_0xd96f('0x4'));var Mustache=require(_0xd96f('0x5'));var util=require(_0xd96f('0x6'));var path=require('path');var sox=require(_0xd96f('0x7'));var csv=require(_0xd96f('0x8'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xd96f('0x9'));var _=require(_0xd96f('0xa'));var squel=require(_0xd96f('0xb'));var crypto=require(_0xd96f('0xc'));var jsforce=require(_0xd96f('0xd'));var deskjs=require(_0xd96f('0xe'));var toCsv=require(_0xd96f('0x8'));var querystring=require(_0xd96f('0xf'));var Papa=require(_0xd96f('0x10'));var Redis=require(_0xd96f('0x11'));var authService=require(_0xd96f('0x12'));var qs=require(_0xd96f('0x13'));var as=require(_0xd96f('0x14'));var hardwareService=require(_0xd96f('0x15'));var logger=require(_0xd96f('0x16'))(_0xd96f('0x17'));var utils=require(_0xd96f('0x18'));var config=require(_0xd96f('0x19'));var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];var dbH=require(_0xd96f('0x1a'))[_0xd96f('0x1b')];function respondWithStatusCode(_0x4ced55,_0x5870cd){_0x5870cd=_0x5870cd||0xcc;return function(_0x27118a){if(_0x27118a){return _0x4ced55[_0xd96f('0x1c')](_0x5870cd);}return _0x4ced55[_0xd96f('0x1d')](_0x5870cd)[_0xd96f('0x1e')]();};}function respondWithResult(_0x1c770a,_0x370c03){_0x370c03=_0x370c03||0xc8;return function(_0x1b33c8){if(_0x1b33c8){return _0x1c770a[_0xd96f('0x1d')](_0x370c03)[_0xd96f('0x1f')](_0x1b33c8);}};}function respondWithFilteredResult(_0x28884d,_0x5e5e65){return function(_0x1f6f36){if(_0x1f6f36){var _0x569e1=_0x1f6f36[_0xd96f('0x20')],_0x47d17c=_0x5e5e65[_0xd96f('0x21')],_0x19b141=_0x5e5e65[_0xd96f('0x21')]+_0x5e5e65[_0xd96f('0x22')],_0x3420d6;if(_0x19b141>=_0x569e1){_0x19b141=_0x569e1;_0x3420d6=0xc8;}else{_0x3420d6=0xce;}_0x28884d['status'](_0x3420d6);return _0x28884d[_0xd96f('0x23')](_0xd96f('0x24'),_0x47d17c+'-'+_0x19b141+'/'+_0x569e1)[_0xd96f('0x1f')](_0x1f6f36);}return null;};}function patchUpdates(_0x519ad4){return function(_0x33215f){try{jsonpatch[_0xd96f('0x25')](_0x33215f,_0x519ad4,!![]);}catch(_0x16f4af){return BPromise[_0xd96f('0x26')](_0x16f4af);}return _0x33215f[_0xd96f('0x27')]();};}function saveUpdates(_0x422e34,_0x318f36){return function(_0x57c396){if(_0x57c396){return _0x57c396[_0xd96f('0x28')](_0x422e34)[_0xd96f('0x29')](function(_0x4de2ef){return _0x4de2ef;});}return null;};}function removeEntity(_0x3ea026,_0x480610){return function(_0x39e7b2){if(_0x39e7b2){return _0x39e7b2['destroy']()['then'](function(){var _0x33a00c=_0x39e7b2['get']({'plain':!![]});var _0x565f74=_0xd96f('0x2a');return db[_0xd96f('0x2b')][_0xd96f('0x2c')]({'where':{'type':_0x565f74,'resourceId':_0x33a00c['id']}})[_0xd96f('0x29')](function(){return _0x39e7b2;});})[_0xd96f('0x29')](function(){_0x3ea026[_0xd96f('0x1d')](0xcc)['end']();});}};}function handleEntityNotFound(_0x1d6996,_0x24d81a){return function(_0x42117d){if(!_0x42117d){_0x1d6996[_0xd96f('0x1c')](0x194);}return _0x42117d;};}function handleError(_0xd4d095,_0x3725cd){_0x3725cd=_0x3725cd||0x1f4;return function(_0x2dd76b){logger[_0xd96f('0x2d')](_0x2dd76b[_0xd96f('0x2e')]);if(_0x2dd76b[_0xd96f('0x2f')]){delete _0x2dd76b[_0xd96f('0x2f')];}_0xd4d095[_0xd96f('0x1d')](_0x3725cd)[_0xd96f('0x30')](_0x2dd76b);};}exports[_0xd96f('0x31')]=function(_0x42487d,_0x3c84a7){var _0x157190={},_0x160b0a={},_0x22ef06={'count':0x0,'rows':[]};var _0x1738dd=_['map'](db[_0xd96f('0x32')][_0xd96f('0x33')],function(_0x146cee){return{'name':_0x146cee['fieldName'],'type':_0x146cee[_0xd96f('0x34')][_0xd96f('0x35')]};});_0x160b0a[_0xd96f('0x36')]=_['map'](_0x1738dd,_0xd96f('0x2f'));_0x160b0a['query']=_[_0xd96f('0x37')](_0x42487d['query']);_0x160b0a[_0xd96f('0x38')]=_[_0xd96f('0x39')](_0x160b0a[_0xd96f('0x36')],_0x160b0a[_0xd96f('0x3a')]);_0x157190[_0xd96f('0x3b')]=_[_0xd96f('0x39')](_0x160b0a[_0xd96f('0x36')],qs['fields'](_0x42487d['query'][_0xd96f('0x3c')]));_0x157190['attributes']=_0x157190['attributes']['length']?_0x157190[_0xd96f('0x3b')]:_0x160b0a[_0xd96f('0x36')];if(!_0x42487d[_0xd96f('0x3a')][_0xd96f('0x3d')]('nolimit')){_0x157190[_0xd96f('0x22')]=qs[_0xd96f('0x22')](_0x42487d[_0xd96f('0x3a')][_0xd96f('0x22')]);_0x157190[_0xd96f('0x21')]=qs[_0xd96f('0x21')](_0x42487d[_0xd96f('0x3a')][_0xd96f('0x21')]);}_0x157190[_0xd96f('0x3e')]=qs[_0xd96f('0x3f')](_0x42487d[_0xd96f('0x3a')][_0xd96f('0x3f')]);_0x157190['where']=qs[_0xd96f('0x38')](_[_0xd96f('0x40')](_0x42487d[_0xd96f('0x3a')],_0x160b0a[_0xd96f('0x38')]),_0x1738dd);if(_0x42487d['query'][_0xd96f('0x41')]){_0x157190[_0xd96f('0x42')]=_[_0xd96f('0x43')](_0x157190[_0xd96f('0x42')],{'$or':_['map'](_0x1738dd,function(_0x5b84dc){if(_0x5b84dc[_0xd96f('0x34')]!==_0xd96f('0x44')){var _0xfaf6f1={};_0xfaf6f1[_0x5b84dc[_0xd96f('0x2f')]]={'$like':'%'+_0x42487d['query'][_0xd96f('0x41')]+'%'};return _0xfaf6f1;}})});}_0x157190=_[_0xd96f('0x43')]({},_0x157190,_0x42487d['options']);var _0x1f23ab={'where':_0x157190[_0xd96f('0x42')]};return db[_0xd96f('0x32')][_0xd96f('0x20')](_0x1f23ab)['then'](function(_0x458d09){_0x22ef06['count']=_0x458d09;if(_0x42487d[_0xd96f('0x3a')][_0xd96f('0x45')]){_0x157190[_0xd96f('0x46')]=[{'all':!![]}];}return db[_0xd96f('0x32')]['findAll'](_0x157190);})[_0xd96f('0x29')](function(_0x252290){_0x22ef06[_0xd96f('0x47')]=_0x252290;return _0x22ef06;})[_0xd96f('0x29')](respondWithFilteredResult(_0x3c84a7,_0x157190))[_0xd96f('0x48')](handleError(_0x3c84a7,null));};exports[_0xd96f('0x49')]=function(_0x92819e,_0x187c18){var _0x2e3ce4={'raw':!![],'where':{'id':_0x92819e[_0xd96f('0x4a')]['id']}},_0x1a0b3c={};_0x1a0b3c[_0xd96f('0x36')]=_[_0xd96f('0x37')](db[_0xd96f('0x32')][_0xd96f('0x33')]);_0x1a0b3c[_0xd96f('0x3a')]=_[_0xd96f('0x37')](_0x92819e[_0xd96f('0x3a')]);_0x1a0b3c['filters']=_['intersection'](_0x1a0b3c[_0xd96f('0x36')],_0x1a0b3c['query']);_0x2e3ce4['attributes']=_[_0xd96f('0x39')](_0x1a0b3c['model'],qs[_0xd96f('0x3c')](_0x92819e[_0xd96f('0x3a')][_0xd96f('0x3c')]));_0x2e3ce4['attributes']=_0x2e3ce4[_0xd96f('0x3b')][_0xd96f('0x4b')]?_0x2e3ce4[_0xd96f('0x3b')]:_0x1a0b3c['model'];if(_0x92819e[_0xd96f('0x3a')][_0xd96f('0x45')]){_0x2e3ce4[_0xd96f('0x46')]=[{'all':!![]}];}_0x2e3ce4=_[_0xd96f('0x43')]({},_0x2e3ce4,_0x92819e[_0xd96f('0x4c')]);return db[_0xd96f('0x32')][_0xd96f('0x4d')](_0x2e3ce4)[_0xd96f('0x29')](handleEntityNotFound(_0x187c18,null))[_0xd96f('0x29')](respondWithResult(_0x187c18,null))[_0xd96f('0x48')](handleError(_0x187c18,null));};exports[_0xd96f('0x4e')]=function(_0x1f9ec5,_0x4e18e2){return db[_0xd96f('0x32')][_0xd96f('0x4e')](_0x1f9ec5[_0xd96f('0x4f')],{})['then'](function(_0x238f1f){var _0x599e5e=_0x1f9ec5[_0xd96f('0x50')][_0xd96f('0x51')]({'plain':!![]});if(!_0x599e5e)throw new Error(_0xd96f('0x52'));if(_0x599e5e[_0xd96f('0x53')]===_0xd96f('0x50')){var _0x38ec76=_0x238f1f[_0xd96f('0x51')]({'plain':!![]});var _0x19daf9=_0xd96f('0x54');return db[_0xd96f('0x55')][_0xd96f('0x4d')]({'where':{'name':_0x19daf9,'userProfileId':_0x599e5e[_0xd96f('0x56')]},'raw':!![]})[_0xd96f('0x29')](function(_0x37b86a){if(_0x37b86a&&_0x37b86a[_0xd96f('0x57')]===0x0){return db['UserProfileResource'][_0xd96f('0x4e')]({'name':_0x38ec76[_0xd96f('0x2f')],'resourceId':_0x38ec76['id'],'type':_0xd96f('0x2a'),'sectionId':_0x37b86a['id']},{})[_0xd96f('0x29')](function(){return _0x238f1f;});}else{return _0x238f1f;}})['catch'](function(_0x2efc45){logger['error'](_0xd96f('0x58'),_0x2efc45);throw _0x2efc45;});}return _0x238f1f;})[_0xd96f('0x29')](respondWithResult(_0x4e18e2,0xc9))[_0xd96f('0x48')](handleError(_0x4e18e2,null));};exports['update']=function(_0x2aee03,_0x27ec7e){if(_0x2aee03[_0xd96f('0x4f')]['id']){delete _0x2aee03[_0xd96f('0x4f')]['id'];}return db['AnalyticDefaultReport'][_0xd96f('0x4d')]({'where':{'id':_0x2aee03[_0xd96f('0x4a')]['id']}})[_0xd96f('0x29')](handleEntityNotFound(_0x27ec7e,null))[_0xd96f('0x29')](saveUpdates(_0x2aee03[_0xd96f('0x4f')],null))[_0xd96f('0x29')](respondWithResult(_0x27ec7e,null))[_0xd96f('0x48')](handleError(_0x27ec7e,null));};exports['destroy']=function(_0x2e4d7f,_0x4caa77){return db[_0xd96f('0x32')]['find']({'where':{'id':_0x2e4d7f[_0xd96f('0x4a')]['id']}})[_0xd96f('0x29')](handleEntityNotFound(_0x4caa77,null))[_0xd96f('0x29')](removeEntity(_0x4caa77,null))[_0xd96f('0x48')](handleError(_0x4caa77,null));};exports[_0xd96f('0x59')]=function(_0x1a526b,_0x3385c5){var _0x40d594=0xa;var _0x52b854=['join',_0xd96f('0x5a'),_0xd96f('0x5b'),_0xd96f('0x5c')];var _0x446ccc={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT DISTINCT':_0xd96f('0x5d'),'MAX':_0xd96f('0x5e'),'MIN':'MIN(%s)','AVG':_0xd96f('0x5f'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0xd96f('0x60'),'GROUP_CONCAT DESC':_0xd96f('0x61')};var _0x559cfd={'SEC_TO_TIME':_0xd96f('0x62'),'DATE':_0xd96f('0x63'),'HOUR':'HOUR(%s)','ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0xd96f('0x64')};var _0x3430e2=function(_0x267a6d){return!_[_0xd96f('0x65')](['IS\x20NULL',_0xd96f('0x66'),'IS\x20EMPTY',_0xd96f('0x67')],_0x267a6d);};var _0x2f1f67=function(_0x165540){if(!_0x165540||!_0x165540['rules'][_0xd96f('0x4b')]){return'';}for(var _0xf01dc8='(',_0x3dfce7=0x0;_0x3dfce7<_0x165540[_0xd96f('0x68')][_0xd96f('0x4b')];_0x3dfce7+=0x1){_0x3dfce7>0x0&&(_0xf01dc8+='\x20'+_0x165540[_0xd96f('0x69')]+'\x20');_0xf01dc8+=_0x165540[_0xd96f('0x68')][_0x3dfce7][_0xd96f('0x6a')]?_0x2f1f67(_0x165540[_0xd96f('0x68')][_0x3dfce7][_0xd96f('0x6a')]):_0x165540[_0xd96f('0x68')][_0x3dfce7][_0xd96f('0x6b')]+'\x20'+_0x165540[_0xd96f('0x68')][_0x3dfce7][_0xd96f('0x6c')]+(_0x3430e2(_0x165540[_0xd96f('0x68')][_0x3dfce7][_0xd96f('0x6c')])?'\x20'+_0x165540[_0xd96f('0x68')][_0x3dfce7]['value']:'');}return _0xf01dc8+')';};var _0x5ebf3b={'where':{'id':_0x1a526b['params']['id']}},_0x16d16a,_0x433743,_0x21bcfd,_0x2c6d56,_0x392d8a;_0x5ebf3b=_[_0xd96f('0x43')]({},_0x5ebf3b,_0x1a526b['options']);return db['AnalyticDefaultReport'][_0xd96f('0x4d')](_0x5ebf3b)[_0xd96f('0x29')](function(_0x459562){if(_0x459562){_0x16d16a=_0x459562;return _0x459562[_0xd96f('0x6d')]();}return null;})['then'](function(_0x322df0){if(_0x322df0){if(!_0x322df0['length']){throw new db['Sequelize'][(_0xd96f('0x6e'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x433743=_0x322df0;return db['AnalyticMetric']['findAll']({'raw':!![]});}return null;})[_0xd96f('0x29')](function(_0x407d78){if(_0x407d78){_0x21bcfd=_['keyBy'](_0x407d78,'id');var _0x1e98de;var _0xf5dc13=squel[_0xd96f('0x6f')]();_0xf5dc13[_0xd96f('0x70')](_0x16d16a[_0xd96f('0x71')]);for(var _0x2bf711=0x0;_0x2bf711<_0x433743[_0xd96f('0x4b')];_0x2bf711+=0x1){_0x1e98de=_0x433743[_0x2bf711][_0xd96f('0x72')]?_0x21bcfd[_0x433743[_0x2bf711][_0xd96f('0x72')]]['metric']:_0x433743[_0x2bf711]['field'];_0x1e98de=_0x433743[_0x2bf711][_0xd96f('0x73')]?_[_0xd96f('0x74')](_0x446ccc[_0x433743[_0x2bf711][_0xd96f('0x73')]],'%s',_0x1e98de):_0x1e98de;_0x1e98de=_0x433743[_0x2bf711][_0xd96f('0x75')]?_[_0xd96f('0x74')](_0x559cfd[_0x433743[_0x2bf711][_0xd96f('0x75')]],'%s',_0x1e98de):_0x1e98de;if(_0x433743[_0x2bf711][_0xd96f('0x76')]){_0xf5dc13[_0xd96f('0x6a')](_0x1e98de);}_0x433743[_0x2bf711][_0xd96f('0x77')]&&_0xf5dc13[_0xd96f('0x3e')](_0x1e98de,_0x433743[_0x2bf711][_0xd96f('0x77')]===_0xd96f('0x78')?![]:!![]);_0xf5dc13[_0xd96f('0x6b')](_0x1e98de,_0x433743[_0x2bf711][_0xd96f('0x79')]||_0x1e98de);}if(_0x16d16a['joins']){_0x16d16a[_0xd96f('0x7a')]=JSON[_0xd96f('0x7b')](_0x16d16a[_0xd96f('0x7a')]);for(var _0x421283=0x0;_0x421283<_0x16d16a[_0xd96f('0x7a')][_0xd96f('0x4b')];_0x421283+=0x1){if(_0x16d16a['joins'][_0x421283][_0xd96f('0x34')]&&_['includes'](_0x52b854,_0x16d16a[_0xd96f('0x7a')][_0x421283][_0xd96f('0x34')])&&_0x16d16a[_0xd96f('0x7a')][_0x421283]['parentKey']&&_0x16d16a[_0xd96f('0x7a')][_0x421283]['foreignTable']&&_0x16d16a[_0xd96f('0x7a')][_0x421283][_0xd96f('0x7c')]){_0xf5dc13[_0x16d16a['joins'][_0x421283]['type']](_0x16d16a[_0xd96f('0x7a')][_0x421283]['foreignTable'],null,util[_0xd96f('0x75')]('%s.%s\x20=\x20%s.%s',_0x16d16a[_0xd96f('0x71')],_0x16d16a[_0xd96f('0x7a')][_0x421283]['parentKey'],_0x16d16a[_0xd96f('0x7a')][_0x421283][_0xd96f('0x7d')],_0x16d16a[_0xd96f('0x7a')][_0x421283][_0xd96f('0x7c')]));}}}if(_0x16d16a[_0xd96f('0x7e')]){_0x16d16a['conditions']=JSON[_0xd96f('0x7b')](_0x16d16a[_0xd96f('0x7e')]);_0xf5dc13[_0xd96f('0x42')](_0x2f1f67(_0x16d16a['conditions']['group']));}_0x392d8a=_0xf5dc13[_0xd96f('0x7f')]();_0xf5dc13['limit'](_0x40d594);_0xf5dc13[_0xd96f('0x21')](0x0);logger['debug'](_0xd96f('0x80'),_0xf5dc13['toString']());return dbH[_0xd96f('0x81')][_0xd96f('0x3a')](_0xf5dc13[_0xd96f('0x82')](),{'type':dbH[_0xd96f('0x81')][_0xd96f('0x83')]['SELECT']});}})[_0xd96f('0x29')](respondWithResult(_0x3385c5,null))[_0xd96f('0x48')](handleError(_0x3385c5,null));};function runReport(_0x11ffab,_0x3228e1,_0x384847){var _0x284e67=_0x3228e1[_0xd96f('0x2f')];var _0x18f860=0xa;var _0x1b9e6d=[_0xd96f('0x84'),_0xd96f('0x5a'),_0xd96f('0x5b'),_0xd96f('0x5c')];var _0x19dcef={'SUM':_0xd96f('0x85'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0xd96f('0x5d'),'MAX':_0xd96f('0x5e'),'MIN':_0xd96f('0x86'),'AVG':_0xd96f('0x5f'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0xd96f('0x60'),'GROUP_CONCAT DESC':_0xd96f('0x61')};var _0x4817fa={'SEC_TO_TIME':_0xd96f('0x62'),'DATE':'DATE(%s)','HOUR':_0xd96f('0x87'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0xd96f('0x64')};var _0x40b148=function(_0xf449e4){return!_[_0xd96f('0x65')]([_0xd96f('0x88'),_0xd96f('0x66'),_0xd96f('0x89'),_0xd96f('0x67')],_0xf449e4);};var _0x418324=function(_0x156dbd){if(!_0x156dbd||!_0x156dbd['rules'][_0xd96f('0x4b')]){return'';}for(var _0x516ca1='(',_0x5f4b95=0x0;_0x5f4b95<_0x156dbd[_0xd96f('0x68')][_0xd96f('0x4b')];_0x5f4b95+=0x1){_0x5f4b95>0x0&&(_0x516ca1+='\x20'+_0x156dbd[_0xd96f('0x69')]+'\x20');_0x516ca1+=_0x156dbd[_0xd96f('0x68')][_0x5f4b95][_0xd96f('0x6a')]?_0x418324(_0x156dbd['rules'][_0x5f4b95]['group']):_0x156dbd[_0xd96f('0x68')][_0x5f4b95][_0xd96f('0x6b')]+'\x20'+_0x156dbd['rules'][_0x5f4b95]['condition']+(_0x40b148(_0x156dbd[_0xd96f('0x68')][_0x5f4b95]['condition'])?'\x20'+_0x156dbd[_0xd96f('0x68')][_0x5f4b95][_0xd96f('0x8a')]:'');}return _0x516ca1+')';};var _0x22e92b={'where':{'id':_0x11ffab['id']}},_0x3dfac2,_0x6ae1a1,_0x193a81,_0x5578be,_0x8ce2cc;_0x22e92b=_[_0xd96f('0x43')]({},_0x22e92b,_0x384847);return db['AnalyticDefaultReport'][_0xd96f('0x4d')](_0x22e92b)['then'](function(_0x1c99bc){if(_0x1c99bc){_0x3dfac2=_0x1c99bc;return _0x1c99bc[_0xd96f('0x6d')]();}return null;})[_0xd96f('0x29')](function(_0x183ca7){if(_0x183ca7){if(!_0x183ca7['length']){throw new db[(_0xd96f('0x8b'))][(_0xd96f('0x6e'))](_0xd96f('0x8c'),0x193);}_0x6ae1a1=_0x183ca7;return db[_0xd96f('0x8d')][_0xd96f('0x8e')]({'raw':!![]});}return null;})['then'](function(_0x21df28){if(_0x21df28){_0x193a81=_[_0xd96f('0x8f')](_0x21df28,'id');var _0x43a57d;var _0xdb859=squel[_0xd96f('0x6f')]();_0xdb859[_0xd96f('0x70')](_0x3dfac2[_0xd96f('0x71')]);for(var _0x1b85cb=0x0;_0x1b85cb<_0x6ae1a1[_0xd96f('0x4b')];_0x1b85cb+=0x1){_0x43a57d=_0x6ae1a1[_0x1b85cb]['MetricId']?_0x193a81[_0x6ae1a1[_0x1b85cb]['MetricId']][_0xd96f('0x90')]:_0x6ae1a1[_0x1b85cb][_0xd96f('0x6b')];_0x43a57d=_0x6ae1a1[_0x1b85cb]['function']?_[_0xd96f('0x74')](_0x19dcef[_0x6ae1a1[_0x1b85cb]['function']],'%s',_0x43a57d):_0x43a57d;_0x43a57d=_0x6ae1a1[_0x1b85cb]['format']?_[_0xd96f('0x74')](_0x4817fa[_0x6ae1a1[_0x1b85cb][_0xd96f('0x75')]],'%s',_0x43a57d):_0x43a57d;if(_0x6ae1a1[_0x1b85cb]['groupBy']){_0xdb859[_0xd96f('0x6a')](_0x43a57d);}_0x6ae1a1[_0x1b85cb][_0xd96f('0x77')]&&_0xdb859['order'](_0x43a57d,_0x6ae1a1[_0x1b85cb][_0xd96f('0x77')]===_0xd96f('0x78')?![]:!![]);_0xdb859[_0xd96f('0x6b')](_0x43a57d,_0x6ae1a1[_0x1b85cb][_0xd96f('0x79')]||_0x43a57d);}if(_0x3dfac2[_0xd96f('0x7a')]){_0x3dfac2[_0xd96f('0x7a')]=JSON[_0xd96f('0x7b')](_0x3dfac2[_0xd96f('0x7a')]);for(var _0x441d54=0x0;_0x441d54<_0x3dfac2[_0xd96f('0x7a')][_0xd96f('0x4b')];_0x441d54+=0x1){if(_0x3dfac2['joins'][_0x441d54][_0xd96f('0x34')]&&_['includes'](_0x1b9e6d,_0x3dfac2['joins'][_0x441d54][_0xd96f('0x34')])&&_0x3dfac2[_0xd96f('0x7a')][_0x441d54][_0xd96f('0x91')]&&_0x3dfac2[_0xd96f('0x7a')][_0x441d54][_0xd96f('0x7d')]&&_0x3dfac2['joins'][_0x441d54][_0xd96f('0x7c')]){_0xdb859[_0x3dfac2[_0xd96f('0x7a')][_0x441d54][_0xd96f('0x34')]](_0x3dfac2[_0xd96f('0x7a')][_0x441d54][_0xd96f('0x7d')],null,util[_0xd96f('0x75')](_0xd96f('0x92'),_0x3dfac2[_0xd96f('0x71')],_0x3dfac2['joins'][_0x441d54][_0xd96f('0x91')],_0x3dfac2[_0xd96f('0x7a')][_0x441d54]['foreignTable'],_0x3dfac2[_0xd96f('0x7a')][_0x441d54]['foreignKey']));}}}if(_0x3dfac2[_0xd96f('0x7e')]){_0x3dfac2[_0xd96f('0x7e')]=JSON[_0xd96f('0x7b')](_0x3dfac2[_0xd96f('0x7e')]);_0xdb859[_0xd96f('0x42')](_0x418324(_0x3dfac2['conditions']['group']));}_0x8ce2cc=_0xdb859[_0xd96f('0x7f')]();_0xdb859[_0xd96f('0x22')](_0x18f860);_0xdb859['offset'](0x0);return;}})[_0xd96f('0x29')](function(){if(_0x3228e1[_0xd96f('0x93')]===_0xd96f('0x94')){return null;}var _0x1962ed=_[_0xd96f('0x43')](_0x3228e1,{'name':_0x3228e1['fullPath']||_0x3228e1[_0xd96f('0x2f')]||_0x3dfac2[_0xd96f('0x2f')],'basename':_0x284e67,'savename':util[_0xd96f('0x75')](_0xd96f('0x95'),_0x3228e1[_0xd96f('0x2f')]||_0x3dfac2[_0xd96f('0x2f')],require(_0xd96f('0x96'))[_0xd96f('0x97')](0x4),_0x3228e1[_0xd96f('0x93')]||_0xd96f('0x98')),'reportId':_0x3dfac2['id'],'reportType':'default'});return db['AnalyticExtractedReport'][_0xd96f('0x4e')](_0x1962ed,{'raw':!![]});})[_0xd96f('0x29')](function(_0x14b578){if(_0x3dfac2[_0xd96f('0x71')]===_0xd96f('0x99')){_0x8ce2cc[_0xd96f('0x42')](_0x3dfac2[_0xd96f('0x71')]+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x3228e1['startDate'],_0x3228e1[_0xd96f('0x9a')]);}else{_0x8ce2cc[_0xd96f('0x42')](_0x3dfac2[_0xd96f('0x71')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x3228e1['startDate'],_0x3228e1[_0xd96f('0x9a')]);}if(_0x14b578){logger[_0xd96f('0x9b')](_0xd96f('0x9c'),_0x8ce2cc[_0xd96f('0x82')]());require(_0xd96f('0x9d'))['fork'](path[_0xd96f('0x84')](__dirname,_0xd96f('0x9e'),_0x14b578[_0xd96f('0x93')]),[_0x14b578['id'],_0x8ce2cc[_0xd96f('0x82')](),path['join'](__dirname,_0xd96f('0x9f'),_0x14b578[_0xd96f('0xa0')]),_0x284e67]);return _0x14b578;}else{var _0x78c647=squel[_0xd96f('0x6f')]();_0x78c647['from']('('+_0x8ce2cc[_0xd96f('0x82')]()+')',_0xd96f('0xa1'));_0x78c647[_0xd96f('0x6b')](_0xd96f('0xa2'),'count');_0x8ce2cc[_0xd96f('0x22')](_0x3228e1['limit']||_0x18f860);_0x8ce2cc['offset'](_0x3228e1[_0xd96f('0x21')]||0x0);return dbH['sequelize'][_0xd96f('0x3a')](_0x78c647[_0xd96f('0x82')](),{'type':dbH[_0xd96f('0x81')]['QueryTypes'][_0xd96f('0xa3')]})[_0xd96f('0x29')](function(_0x2687e3){if(!_0x2687e3['length']){_0x5578be=0x0;}else{_0x5578be=_0x2687e3[0x0][_0xd96f('0x20')]||0x0;}return dbH['sequelize'][_0xd96f('0x3a')](_0x8ce2cc[_0xd96f('0x82')](),{'type':dbH['sequelize']['QueryTypes'][_0xd96f('0xa3')]});})['then'](function(_0x83d500){return{'rows':_0x83d500||[],'count':_0x5578be};});}});}exports[_0xd96f('0xa4')]=function(_0x5459ac,_0x5a3e63){return runReport(_0x5459ac[_0xd96f('0x4a')],_0x5459ac[_0xd96f('0x3a')],_0x5459ac[_0xd96f('0x4c')])[_0xd96f('0x29')](respondWithResult(_0x5a3e63,null))[_0xd96f('0x48')](handleError(_0x5a3e63,null));};exports[_0xd96f('0xa5')]=runReport;exports[_0xd96f('0x3a')]=function(_0x520954,_0xabc139){var _0x3ec497=0xa;var _0x29d3d2=[_0xd96f('0x84'),_0xd96f('0x5a'),_0xd96f('0x5b'),_0xd96f('0x5c')];var _0x2c85fd={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT DISTINCT':_0xd96f('0x5d'),'MAX':_0xd96f('0x5e'),'MIN':_0xd96f('0x86'),'AVG':_0xd96f('0x5f'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0xd96f('0x61')};var _0x32481b={'SEC_TO_TIME':_0xd96f('0x62'),'DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':'ROUND(%s)','UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x441488=function(_0x10a413){return!_[_0xd96f('0x65')](['IS\x20NULL',_0xd96f('0x66'),_0xd96f('0x89'),_0xd96f('0x67')],_0x10a413);};var _0x1f61cf=function(_0x5d6a41){if(!_0x5d6a41||!_0x5d6a41[_0xd96f('0x68')]['length']){return'';}for(var _0x648f36='(',_0x484d2b=0x0;_0x484d2b<_0x5d6a41[_0xd96f('0x68')]['length'];_0x484d2b+=0x1){_0x484d2b>0x0&&(_0x648f36+='\x20'+_0x5d6a41[_0xd96f('0x69')]+'\x20');_0x648f36+=_0x5d6a41[_0xd96f('0x68')][_0x484d2b][_0xd96f('0x6a')]?_0x1f61cf(_0x5d6a41[_0xd96f('0x68')][_0x484d2b]['group']):_0x5d6a41[_0xd96f('0x68')][_0x484d2b][_0xd96f('0x6b')]+'\x20'+_0x5d6a41[_0xd96f('0x68')][_0x484d2b]['condition']+(_0x441488(_0x5d6a41[_0xd96f('0x68')][_0x484d2b][_0xd96f('0x6c')])?'\x20'+_0x5d6a41[_0xd96f('0x68')][_0x484d2b][_0xd96f('0x8a')]:'');}return _0x648f36+')';};var _0x5a7c52={'where':{'id':_0x520954[_0xd96f('0x4a')]['id']}},_0x266729,_0x5acf05,_0x28cfeb,_0xe0eb48,_0x258d5f;_0x5a7c52=_[_0xd96f('0x43')]({},_0x5a7c52,_0x520954[_0xd96f('0x4c')]);return db['AnalyticDefaultReport'][_0xd96f('0x4d')](_0x5a7c52)[_0xd96f('0x29')](function(_0x41c915){if(_0x41c915){_0x266729=_0x41c915;return _0x41c915[_0xd96f('0x6d')]();}return null;})[_0xd96f('0x29')](function(_0x41aae0){if(_0x41aae0){if(!_0x41aae0[_0xd96f('0x4b')]){throw new db['Sequelize'][(_0xd96f('0x6e'))](_0xd96f('0x8c'),0x193);}_0x5acf05=_0x41aae0;return db['AnalyticMetric'][_0xd96f('0x8e')]({'raw':!![]});}return null;})[_0xd96f('0x29')](function(_0x19d3fa){if(_0x19d3fa){_0x28cfeb=_[_0xd96f('0x8f')](_0x19d3fa,'id');var _0x30e2b6;var _0x9647c2=squel[_0xd96f('0x6f')]();_0x9647c2[_0xd96f('0x70')](_0x266729[_0xd96f('0x71')]);for(var _0x3917c9=0x0;_0x3917c9<_0x5acf05[_0xd96f('0x4b')];_0x3917c9+=0x1){_0x30e2b6=_0x5acf05[_0x3917c9][_0xd96f('0x72')]?_0x28cfeb[_0x5acf05[_0x3917c9][_0xd96f('0x72')]][_0xd96f('0x90')]:_0x5acf05[_0x3917c9][_0xd96f('0x6b')];_0x30e2b6=_0x5acf05[_0x3917c9][_0xd96f('0x73')]?_[_0xd96f('0x74')](_0x2c85fd[_0x5acf05[_0x3917c9][_0xd96f('0x73')]],'%s',_0x30e2b6):_0x30e2b6;_0x30e2b6=_0x5acf05[_0x3917c9][_0xd96f('0x75')]?_['replace'](_0x32481b[_0x5acf05[_0x3917c9]['format']],'%s',_0x30e2b6):_0x30e2b6;if(_0x5acf05[_0x3917c9][_0xd96f('0x76')]){_0x9647c2[_0xd96f('0x6a')](_0x30e2b6);}_0x5acf05[_0x3917c9][_0xd96f('0x77')]&&_0x9647c2[_0xd96f('0x3e')](_0x30e2b6,_0x5acf05[_0x3917c9][_0xd96f('0x77')]===_0xd96f('0x78')?![]:!![]);_0x9647c2['field'](_0x30e2b6,_0x5acf05[_0x3917c9]['alias']||_0x30e2b6);}if(_0x266729[_0xd96f('0x7a')]){_0x266729[_0xd96f('0x7a')]=JSON[_0xd96f('0x7b')](_0x266729[_0xd96f('0x7a')]);for(var _0x5206e9=0x0;_0x5206e9<_0x266729[_0xd96f('0x7a')]['length'];_0x5206e9+=0x1){if(_0x266729[_0xd96f('0x7a')][_0x5206e9]['type']&&_[_0xd96f('0x65')](_0x29d3d2,_0x266729[_0xd96f('0x7a')][_0x5206e9][_0xd96f('0x34')])&&_0x266729[_0xd96f('0x7a')][_0x5206e9][_0xd96f('0x91')]&&_0x266729[_0xd96f('0x7a')][_0x5206e9]['foreignTable']&&_0x266729[_0xd96f('0x7a')][_0x5206e9]['foreignKey']){_0x9647c2[_0x266729['joins'][_0x5206e9]['type']](_0x266729[_0xd96f('0x7a')][_0x5206e9]['foreignTable'],null,util[_0xd96f('0x75')](_0xd96f('0x92'),_0x266729['table'],_0x266729[_0xd96f('0x7a')][_0x5206e9][_0xd96f('0x91')],_0x266729['joins'][_0x5206e9][_0xd96f('0x7d')],_0x266729[_0xd96f('0x7a')][_0x5206e9][_0xd96f('0x7c')]));}}}if(_0x266729[_0xd96f('0x7e')]){_0x266729[_0xd96f('0x7e')]=JSON['parse'](_0x266729['conditions']);_0x9647c2['where'](_0x1f61cf(_0x266729['conditions'][_0xd96f('0x6a')]));}_0x258d5f=_0x9647c2['clone']();_0x9647c2[_0xd96f('0x22')](_0x3ec497);_0x9647c2[_0xd96f('0x21')](0x0);logger['debug'](_0xd96f('0x80'),_0x9647c2[_0xd96f('0x82')]());return dbH['sequelize'][_0xd96f('0x3a')](_0x9647c2[_0xd96f('0x82')](),{'type':dbH['sequelize'][_0xd96f('0x83')]['SELECT']});}})[_0xd96f('0x29')](function(){return{'sql':_0x258d5f[_0xd96f('0x82')]()};})[_0xd96f('0x29')](respondWithResult(_0xabc139,null))[_0xd96f('0x48')](handleError(_0xabc139,null));};
\ No newline at end of file
+var _0x3ef0=['AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','Run\x20Query:','child_process','fork','../../components/export/','savename','COUNT(*)','run','findAll','html-pdf','eml-format','rimraf','fast-json-patch','moment','util','path','sox','ejs','lodash','squel','crypto','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','status','end','json','count','offset','limit','set','Content-Range','reject','save','update','then','get','UserProfileResource','destroy','name','send','index','AnalyticDefaultReport','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filter','merge','map','VIRTUAL','options','includeAll','catch','show','include','find','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','user','UserProfileSection','userProfileId','autoAssociation','DefaultReports','error','params','preview','join','left_join','right_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','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','field','condition','value','getFields','Sequelize','ValidationErrorItem','AnalyticMetric','keyBy','select','from','MetricId','metric','function','replace','format','groupBy','orderBy','alias','joins','parse','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','table','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','cross_join','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','ROUND(%s)','Please\x20insert\x20at\x20least\x20one\x20field','DESC','output','fullPath','randomstring','generate'];(function(_0x213d47,_0x218719){var _0x58c3a9=function(_0x449b16){while(--_0x449b16){_0x213d47['push'](_0x213d47['shift']());}};_0x58c3a9(++_0x218719);}(_0x3ef0,0x1ee));var _0x03ef=function(_0x10593e,_0x3c7394){_0x10593e=_0x10593e-0x0;var _0x12d3ea=_0x3ef0[_0x10593e];return _0x12d3ea;};'use strict';var pdf=require(_0x03ef('0x0'));var emlformat=require(_0x03ef('0x1'));var rimraf=require(_0x03ef('0x2'));var zipdir=require('zip-dir');var jsonpatch=require(_0x03ef('0x3'));var rp=require('request-promise');var moment=require(_0x03ef('0x4'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x03ef('0x5'));var path=require(_0x03ef('0x6'));var sox=require(_0x03ef('0x7'));var csv=require('to-csv');var ejs=require(_0x03ef('0x8'));var fs=require('fs');var _=require(_0x03ef('0x9'));var squel=require(_0x03ef('0xa'));var crypto=require(_0x03ef('0xb'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x03ef('0xc'));var querystring=require(_0x03ef('0xd'));var Papa=require(_0x03ef('0xe'));var Redis=require(_0x03ef('0xf'));var authService=require(_0x03ef('0x10'));var qs=require('../../components/parsers/qs');var as=require(_0x03ef('0x11'));var hardwareService=require(_0x03ef('0x12'));var logger=require('../../config/logger')(_0x03ef('0x13'));var utils=require(_0x03ef('0x14'));var config=require('../../config/environment');var licenseUtil=require(_0x03ef('0x15'));var db=require(_0x03ef('0x16'))['db'];var dbH=require(_0x03ef('0x16'))['dbH'];function respondWithStatusCode(_0x407e20,_0x21cd98){_0x21cd98=_0x21cd98||0xcc;return function(_0x4d4097){if(_0x4d4097){return _0x407e20[_0x03ef('0x17')](_0x21cd98);}return _0x407e20[_0x03ef('0x18')](_0x21cd98)[_0x03ef('0x19')]();};}function respondWithResult(_0x505aff,_0x6049e0){_0x6049e0=_0x6049e0||0xc8;return function(_0x470c5c){if(_0x470c5c){return _0x505aff[_0x03ef('0x18')](_0x6049e0)[_0x03ef('0x1a')](_0x470c5c);}};}function respondWithFilteredResult(_0x3f5777,_0x254b65){return function(_0x367d81){if(_0x367d81){var _0x48485f=_0x367d81[_0x03ef('0x1b')],_0xc1bc60=_0x254b65[_0x03ef('0x1c')],_0x995464=_0x254b65[_0x03ef('0x1c')]+_0x254b65[_0x03ef('0x1d')],_0x359b59;if(_0x995464>=_0x48485f){_0x995464=_0x48485f;_0x359b59=0xc8;}else{_0x359b59=0xce;}_0x3f5777[_0x03ef('0x18')](_0x359b59);return _0x3f5777[_0x03ef('0x1e')](_0x03ef('0x1f'),_0xc1bc60+'-'+_0x995464+'/'+_0x48485f)[_0x03ef('0x1a')](_0x367d81);}return null;};}function patchUpdates(_0x19c02f){return function(_0x45a709){try{jsonpatch['apply'](_0x45a709,_0x19c02f,!![]);}catch(_0x3ffcd4){return BPromise[_0x03ef('0x20')](_0x3ffcd4);}return _0x45a709[_0x03ef('0x21')]();};}function saveUpdates(_0x4c7b07,_0xd933d5){return function(_0x903d8){if(_0x903d8){return _0x903d8[_0x03ef('0x22')](_0x4c7b07)[_0x03ef('0x23')](function(_0x5d070c){return _0x5d070c;});}return null;};}function removeEntity(_0x3babe9,_0x5e1338){return function(_0x22aaf8){if(_0x22aaf8){return _0x22aaf8['destroy']()[_0x03ef('0x23')](function(){var _0x25abb7=_0x22aaf8[_0x03ef('0x24')]({'plain':!![]});var _0x3a5561='DefaultReports';return db[_0x03ef('0x25')][_0x03ef('0x26')]({'where':{'type':_0x3a5561,'resourceId':_0x25abb7['id']}})['then'](function(){return _0x22aaf8;});})[_0x03ef('0x23')](function(){_0x3babe9['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x3d460c,_0x495e0d){return function(_0x472a9f){if(!_0x472a9f){_0x3d460c[_0x03ef('0x17')](0x194);}return _0x472a9f;};}function handleError(_0x2c3540,_0x4cd475){_0x4cd475=_0x4cd475||0x1f4;return function(_0xb8235e){logger['error'](_0xb8235e['stack']);if(_0xb8235e[_0x03ef('0x27')]){delete _0xb8235e['name'];}_0x2c3540[_0x03ef('0x18')](_0x4cd475)[_0x03ef('0x28')](_0xb8235e);};}exports[_0x03ef('0x29')]=function(_0x57845e,_0x1c00b3){var _0x1b0dae={},_0x329303={},_0x3865b1={'count':0x0,'rows':[]};var _0x544797=_['map'](db[_0x03ef('0x2a')][_0x03ef('0x2b')],function(_0x1d71e2){return{'name':_0x1d71e2[_0x03ef('0x2c')],'type':_0x1d71e2[_0x03ef('0x2d')][_0x03ef('0x2e')]};});_0x329303[_0x03ef('0x2f')]=_['map'](_0x544797,_0x03ef('0x27'));_0x329303[_0x03ef('0x30')]=_[_0x03ef('0x31')](_0x57845e['query']);_0x329303[_0x03ef('0x32')]=_[_0x03ef('0x33')](_0x329303['model'],_0x329303[_0x03ef('0x30')]);_0x1b0dae[_0x03ef('0x34')]=_[_0x03ef('0x33')](_0x329303['model'],qs['fields'](_0x57845e['query'][_0x03ef('0x35')]));_0x1b0dae['attributes']=_0x1b0dae[_0x03ef('0x34')][_0x03ef('0x36')]?_0x1b0dae[_0x03ef('0x34')]:_0x329303[_0x03ef('0x2f')];if(!_0x57845e[_0x03ef('0x30')][_0x03ef('0x37')](_0x03ef('0x38'))){_0x1b0dae[_0x03ef('0x1d')]=qs[_0x03ef('0x1d')](_0x57845e['query'][_0x03ef('0x1d')]);_0x1b0dae[_0x03ef('0x1c')]=qs[_0x03ef('0x1c')](_0x57845e[_0x03ef('0x30')][_0x03ef('0x1c')]);}_0x1b0dae[_0x03ef('0x39')]=qs[_0x03ef('0x3a')](_0x57845e[_0x03ef('0x30')][_0x03ef('0x3a')]);_0x1b0dae[_0x03ef('0x3b')]=qs['filters'](_['pick'](_0x57845e[_0x03ef('0x30')],_0x329303[_0x03ef('0x32')]),_0x544797);if(_0x57845e[_0x03ef('0x30')][_0x03ef('0x3c')]){_0x1b0dae[_0x03ef('0x3b')]=_[_0x03ef('0x3d')](_0x1b0dae[_0x03ef('0x3b')],{'$or':_[_0x03ef('0x3e')](_0x544797,function(_0x1ec6e3){if(_0x1ec6e3[_0x03ef('0x2d')]!==_0x03ef('0x3f')){var _0x374c52={};_0x374c52[_0x1ec6e3[_0x03ef('0x27')]]={'$like':'%'+_0x57845e['query'][_0x03ef('0x3c')]+'%'};return _0x374c52;}})});}_0x1b0dae=_[_0x03ef('0x3d')]({},_0x1b0dae,_0x57845e[_0x03ef('0x40')]);var _0x4ac063={'where':_0x1b0dae['where']};return db[_0x03ef('0x2a')]['count'](_0x4ac063)[_0x03ef('0x23')](function(_0x4f1e27){_0x3865b1[_0x03ef('0x1b')]=_0x4f1e27;if(_0x57845e[_0x03ef('0x30')][_0x03ef('0x41')]){_0x1b0dae['include']=[{'all':!![]}];}return db[_0x03ef('0x2a')]['findAll'](_0x1b0dae);})[_0x03ef('0x23')](function(_0x2a184c){_0x3865b1['rows']=_0x2a184c;return _0x3865b1;})['then'](respondWithFilteredResult(_0x1c00b3,_0x1b0dae))[_0x03ef('0x42')](handleError(_0x1c00b3,null));};exports[_0x03ef('0x43')]=function(_0x32a15b,_0x5ef013){var _0x4d8caf={'raw':!![],'where':{'id':_0x32a15b['params']['id']}},_0x38b7b3={};_0x38b7b3[_0x03ef('0x2f')]=_['keys'](db[_0x03ef('0x2a')][_0x03ef('0x2b')]);_0x38b7b3[_0x03ef('0x30')]=_[_0x03ef('0x31')](_0x32a15b[_0x03ef('0x30')]);_0x38b7b3['filters']=_[_0x03ef('0x33')](_0x38b7b3[_0x03ef('0x2f')],_0x38b7b3[_0x03ef('0x30')]);_0x4d8caf[_0x03ef('0x34')]=_[_0x03ef('0x33')](_0x38b7b3['model'],qs[_0x03ef('0x35')](_0x32a15b[_0x03ef('0x30')][_0x03ef('0x35')]));_0x4d8caf[_0x03ef('0x34')]=_0x4d8caf[_0x03ef('0x34')][_0x03ef('0x36')]?_0x4d8caf['attributes']:_0x38b7b3[_0x03ef('0x2f')];if(_0x32a15b[_0x03ef('0x30')][_0x03ef('0x41')]){_0x4d8caf[_0x03ef('0x44')]=[{'all':!![]}];}_0x4d8caf=_[_0x03ef('0x3d')]({},_0x4d8caf,_0x32a15b[_0x03ef('0x40')]);return db[_0x03ef('0x2a')][_0x03ef('0x45')](_0x4d8caf)[_0x03ef('0x23')](handleEntityNotFound(_0x5ef013,null))[_0x03ef('0x23')](respondWithResult(_0x5ef013,null))[_0x03ef('0x42')](handleError(_0x5ef013,null));};exports[_0x03ef('0x46')]=function(_0x3cb35d,_0x587312){return db['AnalyticDefaultReport'][_0x03ef('0x46')](_0x3cb35d[_0x03ef('0x47')],{})[_0x03ef('0x23')](function(_0x381196){var _0x41d961=_0x3cb35d['user'][_0x03ef('0x24')]({'plain':!![]});if(!_0x41d961)throw new Error(_0x03ef('0x48'));if(_0x41d961['role']===_0x03ef('0x49')){var _0x570fe9=_0x381196[_0x03ef('0x24')]({'plain':!![]});var _0x4782d7='Reports';return db[_0x03ef('0x4a')][_0x03ef('0x45')]({'where':{'name':_0x4782d7,'userProfileId':_0x41d961[_0x03ef('0x4b')]},'raw':!![]})[_0x03ef('0x23')](function(_0x26efb6){if(_0x26efb6&&_0x26efb6[_0x03ef('0x4c')]===0x0){return db[_0x03ef('0x25')][_0x03ef('0x46')]({'name':_0x570fe9[_0x03ef('0x27')],'resourceId':_0x570fe9['id'],'type':_0x03ef('0x4d'),'sectionId':_0x26efb6['id']},{})[_0x03ef('0x23')](function(){return _0x381196;});}else{return _0x381196;}})[_0x03ef('0x42')](function(_0x4a64bf){logger[_0x03ef('0x4e')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x4a64bf);throw _0x4a64bf;});}return _0x381196;})['then'](respondWithResult(_0x587312,0xc9))['catch'](handleError(_0x587312,null));};exports['update']=function(_0x204a3a,_0x122105){if(_0x204a3a[_0x03ef('0x47')]['id']){delete _0x204a3a['body']['id'];}return db[_0x03ef('0x2a')]['find']({'where':{'id':_0x204a3a[_0x03ef('0x4f')]['id']}})['then'](handleEntityNotFound(_0x122105,null))[_0x03ef('0x23')](saveUpdates(_0x204a3a['body'],null))[_0x03ef('0x23')](respondWithResult(_0x122105,null))[_0x03ef('0x42')](handleError(_0x122105,null));};exports[_0x03ef('0x26')]=function(_0x8ba982,_0x2d13d0){return db['AnalyticDefaultReport']['find']({'where':{'id':_0x8ba982[_0x03ef('0x4f')]['id']}})[_0x03ef('0x23')](handleEntityNotFound(_0x2d13d0,null))[_0x03ef('0x23')](removeEntity(_0x2d13d0,null))[_0x03ef('0x42')](handleError(_0x2d13d0,null));};exports[_0x03ef('0x50')]=function(_0x51de8f,_0x75beb){var _0x3958ed=0xa;var _0x24bf69=[_0x03ef('0x51'),_0x03ef('0x52'),_0x03ef('0x53'),'cross_join'];var _0x319d44={'SUM':_0x03ef('0x54'),'COUNT':_0x03ef('0x55'),'COUNT DISTINCT':_0x03ef('0x56'),'MAX':_0x03ef('0x57'),'MIN':'MIN(%s)','AVG':'AVG(%s)','GROUP_CONCAT':_0x03ef('0x58'),'GROUP_CONCAT ASC':_0x03ef('0x59'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x423d89={'SEC_TO_TIME':_0x03ef('0x5a'),'DATE':_0x03ef('0x5b'),'HOUR':_0x03ef('0x5c'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x03ef('0x5d')};var _0x2702a1=function(_0x10c8f9){return!_[_0x03ef('0x5e')]([_0x03ef('0x5f'),_0x03ef('0x60'),_0x03ef('0x61'),_0x03ef('0x62')],_0x10c8f9);};var _0x159b86=function(_0x20a9f1){if(!_0x20a9f1||!_0x20a9f1[_0x03ef('0x63')][_0x03ef('0x36')]){return'';}for(var _0x2b58a9='(',_0x351654=0x0;_0x351654<_0x20a9f1['rules'][_0x03ef('0x36')];_0x351654+=0x1){_0x351654>0x0&&(_0x2b58a9+='\x20'+_0x20a9f1[_0x03ef('0x64')]+'\x20');_0x2b58a9+=_0x20a9f1[_0x03ef('0x63')][_0x351654][_0x03ef('0x65')]?_0x159b86(_0x20a9f1['rules'][_0x351654][_0x03ef('0x65')]):_0x20a9f1[_0x03ef('0x63')][_0x351654][_0x03ef('0x66')]+'\x20'+_0x20a9f1[_0x03ef('0x63')][_0x351654][_0x03ef('0x67')]+(_0x2702a1(_0x20a9f1[_0x03ef('0x63')][_0x351654]['condition'])?'\x20'+_0x20a9f1['rules'][_0x351654][_0x03ef('0x68')]:'');}return _0x2b58a9+')';};var _0x47e004={'where':{'id':_0x51de8f[_0x03ef('0x4f')]['id']}},_0x4d59a8,_0x1c3904,_0x209313,_0x3bc978,_0xcfc58a;_0x47e004=_[_0x03ef('0x3d')]({},_0x47e004,_0x51de8f[_0x03ef('0x40')]);return db['AnalyticDefaultReport']['find'](_0x47e004)[_0x03ef('0x23')](function(_0x1410e5){if(_0x1410e5){_0x4d59a8=_0x1410e5;return _0x1410e5[_0x03ef('0x69')]();}return null;})['then'](function(_0x1ebdc5){if(_0x1ebdc5){if(!_0x1ebdc5[_0x03ef('0x36')]){throw new db[(_0x03ef('0x6a'))][(_0x03ef('0x6b'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x1c3904=_0x1ebdc5;return db[_0x03ef('0x6c')]['findAll']({'raw':!![]});}return null;})['then'](function(_0x957161){if(_0x957161){_0x209313=_[_0x03ef('0x6d')](_0x957161,'id');var _0x291b83;var _0x43b596=squel[_0x03ef('0x6e')]();_0x43b596[_0x03ef('0x6f')](_0x4d59a8['table']);for(var _0x4c67f1=0x0;_0x4c67f1<_0x1c3904[_0x03ef('0x36')];_0x4c67f1+=0x1){_0x291b83=_0x1c3904[_0x4c67f1][_0x03ef('0x70')]?_0x209313[_0x1c3904[_0x4c67f1][_0x03ef('0x70')]][_0x03ef('0x71')]:_0x1c3904[_0x4c67f1][_0x03ef('0x66')];_0x291b83=_0x1c3904[_0x4c67f1][_0x03ef('0x72')]?_[_0x03ef('0x73')](_0x319d44[_0x1c3904[_0x4c67f1][_0x03ef('0x72')]],'%s',_0x291b83):_0x291b83;_0x291b83=_0x1c3904[_0x4c67f1]['format']?_[_0x03ef('0x73')](_0x423d89[_0x1c3904[_0x4c67f1][_0x03ef('0x74')]],'%s',_0x291b83):_0x291b83;if(_0x1c3904[_0x4c67f1][_0x03ef('0x75')]){_0x43b596['group'](_0x291b83);}_0x1c3904[_0x4c67f1][_0x03ef('0x76')]&&_0x43b596['order'](_0x291b83,_0x1c3904[_0x4c67f1][_0x03ef('0x76')]==='DESC'?![]:!![]);_0x43b596[_0x03ef('0x66')](_0x291b83,_0x1c3904[_0x4c67f1][_0x03ef('0x77')]||_0x291b83);}if(_0x4d59a8[_0x03ef('0x78')]){_0x4d59a8[_0x03ef('0x78')]=JSON[_0x03ef('0x79')](_0x4d59a8['joins']);for(var _0x3b4e2c=0x0;_0x3b4e2c<_0x4d59a8[_0x03ef('0x78')][_0x03ef('0x36')];_0x3b4e2c+=0x1){if(_0x4d59a8['joins'][_0x3b4e2c]['type']&&_[_0x03ef('0x5e')](_0x24bf69,_0x4d59a8['joins'][_0x3b4e2c][_0x03ef('0x2d')])&&_0x4d59a8[_0x03ef('0x78')][_0x3b4e2c][_0x03ef('0x7a')]&&_0x4d59a8[_0x03ef('0x78')][_0x3b4e2c][_0x03ef('0x7b')]&&_0x4d59a8['joins'][_0x3b4e2c][_0x03ef('0x7c')]){_0x43b596[_0x4d59a8[_0x03ef('0x78')][_0x3b4e2c][_0x03ef('0x2d')]](_0x4d59a8[_0x03ef('0x78')][_0x3b4e2c][_0x03ef('0x7b')],null,util[_0x03ef('0x74')](_0x03ef('0x7d'),_0x4d59a8[_0x03ef('0x7e')],_0x4d59a8[_0x03ef('0x78')][_0x3b4e2c][_0x03ef('0x7a')],_0x4d59a8[_0x03ef('0x78')][_0x3b4e2c][_0x03ef('0x7b')],_0x4d59a8[_0x03ef('0x78')][_0x3b4e2c][_0x03ef('0x7c')]));}}}if(_0x4d59a8[_0x03ef('0x7f')]){_0x4d59a8[_0x03ef('0x7f')]=JSON[_0x03ef('0x79')](_0x4d59a8['conditions']);_0x43b596[_0x03ef('0x3b')](_0x159b86(_0x4d59a8[_0x03ef('0x7f')][_0x03ef('0x65')]));}_0xcfc58a=_0x43b596[_0x03ef('0x80')]();_0x43b596[_0x03ef('0x1d')](_0x3958ed);_0x43b596['offset'](0x0);logger[_0x03ef('0x81')](_0x03ef('0x82'),_0x43b596[_0x03ef('0x83')]());return dbH['sequelize'][_0x03ef('0x30')](_0x43b596[_0x03ef('0x83')](),{'type':dbH[_0x03ef('0x84')][_0x03ef('0x85')][_0x03ef('0x86')]});}})['then'](respondWithResult(_0x75beb,null))[_0x03ef('0x42')](handleError(_0x75beb,null));};function runReport(_0x15142f,_0x15c000,_0x18a6c3){var _0x1ed0bd=_0x15c000[_0x03ef('0x27')];var _0x559755=0xa;var _0x55ea0f=[_0x03ef('0x51'),_0x03ef('0x52'),_0x03ef('0x53'),_0x03ef('0x87')];var _0x500a82={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x03ef('0x57'),'MIN':_0x03ef('0x88'),'AVG':_0x03ef('0x89'),'GROUP_CONCAT':_0x03ef('0x58'),'GROUP_CONCAT ASC':_0x03ef('0x59'),'GROUP_CONCAT DESC':_0x03ef('0x8a')};var _0x21e67b={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x03ef('0x5b'),'HOUR':'HOUR(%s)','ROUND':_0x03ef('0x8b'),'UNIX_TIMESTAMP':_0x03ef('0x5d')};var _0x585d27=function(_0x3c9273){return!_[_0x03ef('0x5e')]([_0x03ef('0x5f'),'IS\x20NOT\x20NULL',_0x03ef('0x61'),'IS\x20NOT\x20EMPTY'],_0x3c9273);};var _0x41fac0=function(_0x348089){if(!_0x348089||!_0x348089['rules'][_0x03ef('0x36')]){return'';}for(var _0x37876c='(',_0x48466c=0x0;_0x48466c<_0x348089[_0x03ef('0x63')]['length'];_0x48466c+=0x1){_0x48466c>0x0&&(_0x37876c+='\x20'+_0x348089[_0x03ef('0x64')]+'\x20');_0x37876c+=_0x348089['rules'][_0x48466c][_0x03ef('0x65')]?_0x41fac0(_0x348089[_0x03ef('0x63')][_0x48466c][_0x03ef('0x65')]):_0x348089[_0x03ef('0x63')][_0x48466c]['field']+'\x20'+_0x348089[_0x03ef('0x63')][_0x48466c][_0x03ef('0x67')]+(_0x585d27(_0x348089[_0x03ef('0x63')][_0x48466c][_0x03ef('0x67')])?'\x20'+_0x348089['rules'][_0x48466c][_0x03ef('0x68')]:'');}return _0x37876c+')';};var _0x3fff64={'where':{'id':_0x15142f['id']}},_0x4c8b51,_0x13733b,_0x1bd22f,_0x284cea,_0x5370d5;_0x3fff64=_[_0x03ef('0x3d')]({},_0x3fff64,_0x18a6c3);return db['AnalyticDefaultReport'][_0x03ef('0x45')](_0x3fff64)[_0x03ef('0x23')](function(_0x2841c2){if(_0x2841c2){_0x4c8b51=_0x2841c2;return _0x2841c2[_0x03ef('0x69')]();}return null;})[_0x03ef('0x23')](function(_0x5bebf0){if(_0x5bebf0){if(!_0x5bebf0[_0x03ef('0x36')]){throw new db[(_0x03ef('0x6a'))]['ValidationErrorItem'](_0x03ef('0x8c'),0x193);}_0x13733b=_0x5bebf0;return db[_0x03ef('0x6c')]['findAll']({'raw':!![]});}return null;})['then'](function(_0x2ef28b){if(_0x2ef28b){_0x1bd22f=_['keyBy'](_0x2ef28b,'id');var _0x4e0d30;var _0x536536=squel[_0x03ef('0x6e')]();_0x536536[_0x03ef('0x6f')](_0x4c8b51['table']);for(var _0x39f14e=0x0;_0x39f14e<_0x13733b[_0x03ef('0x36')];_0x39f14e+=0x1){_0x4e0d30=_0x13733b[_0x39f14e][_0x03ef('0x70')]?_0x1bd22f[_0x13733b[_0x39f14e][_0x03ef('0x70')]]['metric']:_0x13733b[_0x39f14e][_0x03ef('0x66')];_0x4e0d30=_0x13733b[_0x39f14e][_0x03ef('0x72')]?_[_0x03ef('0x73')](_0x500a82[_0x13733b[_0x39f14e]['function']],'%s',_0x4e0d30):_0x4e0d30;_0x4e0d30=_0x13733b[_0x39f14e][_0x03ef('0x74')]?_[_0x03ef('0x73')](_0x21e67b[_0x13733b[_0x39f14e][_0x03ef('0x74')]],'%s',_0x4e0d30):_0x4e0d30;if(_0x13733b[_0x39f14e][_0x03ef('0x75')]){_0x536536[_0x03ef('0x65')](_0x4e0d30);}_0x13733b[_0x39f14e]['orderBy']&&_0x536536[_0x03ef('0x39')](_0x4e0d30,_0x13733b[_0x39f14e][_0x03ef('0x76')]===_0x03ef('0x8d')?![]:!![]);_0x536536['field'](_0x4e0d30,_0x13733b[_0x39f14e][_0x03ef('0x77')]||_0x4e0d30);}if(_0x4c8b51['joins']){_0x4c8b51['joins']=JSON[_0x03ef('0x79')](_0x4c8b51[_0x03ef('0x78')]);for(var _0x16dfda=0x0;_0x16dfda<_0x4c8b51['joins']['length'];_0x16dfda+=0x1){if(_0x4c8b51[_0x03ef('0x78')][_0x16dfda][_0x03ef('0x2d')]&&_['includes'](_0x55ea0f,_0x4c8b51[_0x03ef('0x78')][_0x16dfda]['type'])&&_0x4c8b51[_0x03ef('0x78')][_0x16dfda][_0x03ef('0x7a')]&&_0x4c8b51[_0x03ef('0x78')][_0x16dfda][_0x03ef('0x7b')]&&_0x4c8b51['joins'][_0x16dfda][_0x03ef('0x7c')]){_0x536536[_0x4c8b51[_0x03ef('0x78')][_0x16dfda][_0x03ef('0x2d')]](_0x4c8b51[_0x03ef('0x78')][_0x16dfda][_0x03ef('0x7b')],null,util[_0x03ef('0x74')](_0x03ef('0x7d'),_0x4c8b51['table'],_0x4c8b51[_0x03ef('0x78')][_0x16dfda][_0x03ef('0x7a')],_0x4c8b51[_0x03ef('0x78')][_0x16dfda][_0x03ef('0x7b')],_0x4c8b51[_0x03ef('0x78')][_0x16dfda][_0x03ef('0x7c')]));}}}if(_0x4c8b51[_0x03ef('0x7f')]){_0x4c8b51['conditions']=JSON['parse'](_0x4c8b51[_0x03ef('0x7f')]);_0x536536['where'](_0x41fac0(_0x4c8b51[_0x03ef('0x7f')][_0x03ef('0x65')]));}_0x5370d5=_0x536536[_0x03ef('0x80')]();_0x536536[_0x03ef('0x1d')](_0x559755);_0x536536[_0x03ef('0x1c')](0x0);return;}})[_0x03ef('0x23')](function(){if(_0x15c000[_0x03ef('0x8e')]==='web'){return null;}var _0x193278=_[_0x03ef('0x3d')](_0x15c000,{'name':_0x15c000[_0x03ef('0x8f')]||_0x15c000['name']||_0x4c8b51['name'],'basename':_0x1ed0bd,'savename':util[_0x03ef('0x74')]('%s-%s.%s',_0x15c000[_0x03ef('0x27')]||_0x4c8b51['name'],require(_0x03ef('0x90'))[_0x03ef('0x91')](0x4),_0x15c000[_0x03ef('0x8e')]||'csv'),'reportId':_0x4c8b51['id'],'reportType':'default'});return db[_0x03ef('0x92')][_0x03ef('0x46')](_0x193278,{'raw':!![]});})['then'](function(_0x39ba85){if(_0x4c8b51[_0x03ef('0x7e')]===_0x03ef('0x93')){_0x5370d5['where'](_0x4c8b51['table']+_0x03ef('0x94'),_0x15c000['startDate'],_0x15c000[_0x03ef('0x95')]);}else{_0x5370d5[_0x03ef('0x3b')](_0x4c8b51[_0x03ef('0x7e')]+_0x03ef('0x96'),_0x15c000['startDate'],_0x15c000['endDate']);}if(_0x39ba85){logger[_0x03ef('0x97')](_0x03ef('0x98'),_0x5370d5['toString']());require(_0x03ef('0x99'))[_0x03ef('0x9a')](path[_0x03ef('0x51')](__dirname,_0x03ef('0x9b'),_0x39ba85[_0x03ef('0x8e')]),[_0x39ba85['id'],_0x5370d5[_0x03ef('0x83')](),path[_0x03ef('0x51')](__dirname,'../../files/reports',_0x39ba85[_0x03ef('0x9c')]),_0x1ed0bd]);return _0x39ba85;}else{var _0xbdb31=squel['select']();_0xbdb31[_0x03ef('0x6f')]('('+_0x5370d5[_0x03ef('0x83')]()+')','countTable');_0xbdb31[_0x03ef('0x66')](_0x03ef('0x9d'),_0x03ef('0x1b'));_0x5370d5['limit'](_0x15c000['limit']||_0x559755);_0x5370d5[_0x03ef('0x1c')](_0x15c000[_0x03ef('0x1c')]||0x0);return dbH[_0x03ef('0x84')][_0x03ef('0x30')](_0xbdb31[_0x03ef('0x83')](),{'type':dbH['sequelize'][_0x03ef('0x85')][_0x03ef('0x86')]})[_0x03ef('0x23')](function(_0x291129){if(!_0x291129[_0x03ef('0x36')]){_0x284cea=0x0;}else{_0x284cea=_0x291129[0x0][_0x03ef('0x1b')]||0x0;}return dbH[_0x03ef('0x84')][_0x03ef('0x30')](_0x5370d5[_0x03ef('0x83')](),{'type':dbH[_0x03ef('0x84')][_0x03ef('0x85')]['SELECT']});})[_0x03ef('0x23')](function(_0x5efe51){return{'rows':_0x5efe51||[],'count':_0x284cea};});}});}exports[_0x03ef('0x9e')]=function(_0x45c1ae,_0x2a653d){return runReport(_0x45c1ae[_0x03ef('0x4f')],_0x45c1ae[_0x03ef('0x30')],_0x45c1ae['options'])[_0x03ef('0x23')](respondWithResult(_0x2a653d,null))[_0x03ef('0x42')](handleError(_0x2a653d,null));};exports['runReport']=runReport;exports[_0x03ef('0x30')]=function(_0x6ce007,_0x43f9bc){var _0x1046fd=0xa;var _0x4e88ef=[_0x03ef('0x51'),_0x03ef('0x52'),_0x03ef('0x53'),_0x03ef('0x87')];var _0xc6b7c2={'SUM':_0x03ef('0x54'),'COUNT':_0x03ef('0x55'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x03ef('0x57'),'MIN':_0x03ef('0x88'),'AVG':_0x03ef('0x89'),'GROUP_CONCAT':_0x03ef('0x58'),'GROUP_CONCAT ASC':_0x03ef('0x59'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0xb7e49f={'SEC_TO_TIME':_0x03ef('0x5a'),'DATE':_0x03ef('0x5b'),'HOUR':_0x03ef('0x5c'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x03ef('0x5d')};var _0x1becc4=function(_0xe4dfc6){return!_['includes']([_0x03ef('0x5f'),_0x03ef('0x60'),_0x03ef('0x61'),_0x03ef('0x62')],_0xe4dfc6);};var _0x2ce788=function(_0x579a76){if(!_0x579a76||!_0x579a76[_0x03ef('0x63')][_0x03ef('0x36')]){return'';}for(var _0x37b2c5='(',_0x40de6e=0x0;_0x40de6e<_0x579a76['rules'][_0x03ef('0x36')];_0x40de6e+=0x1){_0x40de6e>0x0&&(_0x37b2c5+='\x20'+_0x579a76[_0x03ef('0x64')]+'\x20');_0x37b2c5+=_0x579a76['rules'][_0x40de6e][_0x03ef('0x65')]?_0x2ce788(_0x579a76[_0x03ef('0x63')][_0x40de6e][_0x03ef('0x65')]):_0x579a76[_0x03ef('0x63')][_0x40de6e][_0x03ef('0x66')]+'\x20'+_0x579a76['rules'][_0x40de6e][_0x03ef('0x67')]+(_0x1becc4(_0x579a76[_0x03ef('0x63')][_0x40de6e][_0x03ef('0x67')])?'\x20'+_0x579a76[_0x03ef('0x63')][_0x40de6e][_0x03ef('0x68')]:'');}return _0x37b2c5+')';};var _0x2dbb3a={'where':{'id':_0x6ce007['params']['id']}},_0x3410b9,_0x57f6de,_0xea866c,_0x54225b,_0x2aaa77;_0x2dbb3a=_['merge']({},_0x2dbb3a,_0x6ce007['options']);return db[_0x03ef('0x2a')][_0x03ef('0x45')](_0x2dbb3a)['then'](function(_0x20f968){if(_0x20f968){_0x3410b9=_0x20f968;return _0x20f968['getFields']();}return null;})['then'](function(_0x23eb02){if(_0x23eb02){if(!_0x23eb02['length']){throw new db['Sequelize']['ValidationErrorItem'](_0x03ef('0x8c'),0x193);}_0x57f6de=_0x23eb02;return db[_0x03ef('0x6c')][_0x03ef('0x9f')]({'raw':!![]});}return null;})['then'](function(_0x5b5897){if(_0x5b5897){_0xea866c=_[_0x03ef('0x6d')](_0x5b5897,'id');var _0x3f52ca;var _0x1dcc8=squel[_0x03ef('0x6e')]();_0x1dcc8['from'](_0x3410b9['table']);for(var _0x45bc90=0x0;_0x45bc90<_0x57f6de[_0x03ef('0x36')];_0x45bc90+=0x1){_0x3f52ca=_0x57f6de[_0x45bc90][_0x03ef('0x70')]?_0xea866c[_0x57f6de[_0x45bc90]['MetricId']][_0x03ef('0x71')]:_0x57f6de[_0x45bc90][_0x03ef('0x66')];_0x3f52ca=_0x57f6de[_0x45bc90]['function']?_[_0x03ef('0x73')](_0xc6b7c2[_0x57f6de[_0x45bc90][_0x03ef('0x72')]],'%s',_0x3f52ca):_0x3f52ca;_0x3f52ca=_0x57f6de[_0x45bc90][_0x03ef('0x74')]?_[_0x03ef('0x73')](_0xb7e49f[_0x57f6de[_0x45bc90][_0x03ef('0x74')]],'%s',_0x3f52ca):_0x3f52ca;if(_0x57f6de[_0x45bc90][_0x03ef('0x75')]){_0x1dcc8[_0x03ef('0x65')](_0x3f52ca);}_0x57f6de[_0x45bc90]['orderBy']&&_0x1dcc8[_0x03ef('0x39')](_0x3f52ca,_0x57f6de[_0x45bc90][_0x03ef('0x76')]==='DESC'?![]:!![]);_0x1dcc8[_0x03ef('0x66')](_0x3f52ca,_0x57f6de[_0x45bc90][_0x03ef('0x77')]||_0x3f52ca);}if(_0x3410b9[_0x03ef('0x78')]){_0x3410b9['joins']=JSON[_0x03ef('0x79')](_0x3410b9[_0x03ef('0x78')]);for(var _0x51cec4=0x0;_0x51cec4<_0x3410b9['joins'][_0x03ef('0x36')];_0x51cec4+=0x1){if(_0x3410b9['joins'][_0x51cec4]['type']&&_[_0x03ef('0x5e')](_0x4e88ef,_0x3410b9[_0x03ef('0x78')][_0x51cec4][_0x03ef('0x2d')])&&_0x3410b9[_0x03ef('0x78')][_0x51cec4][_0x03ef('0x7a')]&&_0x3410b9[_0x03ef('0x78')][_0x51cec4][_0x03ef('0x7b')]&&_0x3410b9[_0x03ef('0x78')][_0x51cec4][_0x03ef('0x7c')]){_0x1dcc8[_0x3410b9[_0x03ef('0x78')][_0x51cec4][_0x03ef('0x2d')]](_0x3410b9[_0x03ef('0x78')][_0x51cec4][_0x03ef('0x7b')],null,util[_0x03ef('0x74')](_0x03ef('0x7d'),_0x3410b9[_0x03ef('0x7e')],_0x3410b9[_0x03ef('0x78')][_0x51cec4]['parentKey'],_0x3410b9[_0x03ef('0x78')][_0x51cec4][_0x03ef('0x7b')],_0x3410b9[_0x03ef('0x78')][_0x51cec4]['foreignKey']));}}}if(_0x3410b9['conditions']){_0x3410b9[_0x03ef('0x7f')]=JSON[_0x03ef('0x79')](_0x3410b9[_0x03ef('0x7f')]);_0x1dcc8['where'](_0x2ce788(_0x3410b9[_0x03ef('0x7f')]['group']));}_0x2aaa77=_0x1dcc8[_0x03ef('0x80')]();_0x1dcc8[_0x03ef('0x1d')](_0x1046fd);_0x1dcc8['offset'](0x0);logger['debug']('Limited\x20Query:',_0x1dcc8['toString']());return dbH['sequelize'][_0x03ef('0x30')](_0x1dcc8[_0x03ef('0x83')](),{'type':dbH['sequelize'][_0x03ef('0x85')]['SELECT']});}})[_0x03ef('0x23')](function(){return{'sql':_0x2aaa77['toString']()};})[_0x03ef('0x23')](respondWithResult(_0x43f9bc,null))[_0x03ef('0x42')](handleError(_0x43f9bc,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff