// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x3cdb=['keys','query','filters','intersection','model','fields','length','attributes','hasOwnProperty','nolimit','sort','where','pick','filter','merge','map','type','key','field','includeAll','include','findAll','rows','catch','options','find','create','body','user','get','role','Reports','UserProfileSection','userProfileId','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','left_join','right_join','cross_join','SUM(%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)','includes','IS\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','value','Sequelize','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','select','from','table','MetricId','metric','function','replace','format','groupBy','orderBy','DESC','alias','joins','parse','foreignTable','%s.%s\x20=\x20%s.%s','parentKey','conditions','clone','Limited\x20Query:','sequelize','QueryTypes','join','COUNT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','IS\x20NOT\x20NULL','condition','ValidationErrorItem','keyBy','order','foreignKey','debug','toString','SELECT','output','web','fullPath','%s-%s.%s','csv','default','.calldate\x20BETWEEN\x20?\x20AND\x20?','.createdAt\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','info','Run\x20Query:','child_process','../../components/export/','countTable','COUNT(*)','run','getFields','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../config/license/hardware','../../config/logger','api','../../config/environment','../../mysqldb','sendStatus','end','status','json','count','offset','limit','Content-Range','reject','update','then','DefaultReports','destroy','error','stack','name','index','AnalyticDefaultReport','rawAttributes'];(function(_0x2c9e15,_0x47e1ac){var _0x59b908=function(_0x18a71b){while(--_0x18a71b){_0x2c9e15['push'](_0x2c9e15['shift']());}};_0x59b908(++_0x47e1ac);}(_0x3cdb,0x116));var _0xb3cd=function(_0x5783f4,_0x4a9e0a){_0x5783f4=_0x5783f4-0x0;var _0x28e380=_0x3cdb[_0x5783f4];return _0x28e380;};'use strict';var pdf=require(_0xb3cd('0x0'));var emlformat=require(_0xb3cd('0x1'));var rimraf=require(_0xb3cd('0x2'));var zipdir=require(_0xb3cd('0x3'));var jsonpatch=require(_0xb3cd('0x4'));var rp=require('request-promise');var moment=require(_0xb3cd('0x5'));var BPromise=require(_0xb3cd('0x6'));var Mustache=require(_0xb3cd('0x7'));var util=require(_0xb3cd('0x8'));var path=require(_0xb3cd('0x9'));var sox=require(_0xb3cd('0xa'));var csv=require(_0xb3cd('0xb'));var ejs=require(_0xb3cd('0xc'));var fs=require('fs');var _=require(_0xb3cd('0xd'));var squel=require(_0xb3cd('0xe'));var crypto=require(_0xb3cd('0xf'));var jsforce=require(_0xb3cd('0x10'));var deskjs=require(_0xb3cd('0x11'));var toCsv=require(_0xb3cd('0xb'));var querystring=require(_0xb3cd('0x12'));var Papa=require(_0xb3cd('0x13'));var Redis=require(_0xb3cd('0x14'));var authService=require(_0xb3cd('0x15'));var qs=require('../../components/parsers/qs');var hardwareService=require(_0xb3cd('0x16'));var logger=require(_0xb3cd('0x17'))(_0xb3cd('0x18'));var utils=require('../../config/utils');var config=require(_0xb3cd('0x19'));var db=require(_0xb3cd('0x1a'))['db'];function respondWithStatusCode(_0x16b967,_0x586e41){_0x586e41=_0x586e41||0xcc;return function(_0x5e8064){if(_0x5e8064){return _0x16b967[_0xb3cd('0x1b')](_0x586e41);}return _0x16b967['status'](_0x586e41)[_0xb3cd('0x1c')]();};}function respondWithResult(_0x501121,_0x1c250a){_0x1c250a=_0x1c250a||0xc8;return function(_0xe339){if(_0xe339){return _0x501121[_0xb3cd('0x1d')](_0x1c250a)[_0xb3cd('0x1e')](_0xe339);}};}function respondWithFilteredResult(_0x39dd6f,_0x34c260){return function(_0x2bc7aa){if(_0x2bc7aa){var _0x32bebb=_0x2bc7aa[_0xb3cd('0x1f')],_0x350956=_0x34c260['offset'],_0x1747cb=_0x34c260[_0xb3cd('0x20')]+_0x34c260[_0xb3cd('0x21')],_0x32c456;if(_0x1747cb>=_0x32bebb){_0x1747cb=_0x32bebb;_0x32c456=0xc8;}else{_0x32c456=0xce;}_0x39dd6f[_0xb3cd('0x1d')](_0x32c456);return _0x39dd6f['set'](_0xb3cd('0x22'),_0x350956+'-'+_0x1747cb+'/'+_0x32bebb)[_0xb3cd('0x1e')](_0x2bc7aa);}return null;};}function patchUpdates(_0x3f344b){return function(_0x1908c8){try{jsonpatch['apply'](_0x1908c8,_0x3f344b,!![]);}catch(_0x735d0b){return BPromise[_0xb3cd('0x23')](_0x735d0b);}return _0x1908c8['save']();};}function saveUpdates(_0x3ddb54,_0x1b6737){return function(_0x533f7e){if(_0x533f7e){return _0x533f7e[_0xb3cd('0x24')](_0x3ddb54)[_0xb3cd('0x25')](function(_0x5c376f){return _0x5c376f;});}return null;};}function removeEntity(_0x23ba33,_0x2cd5c6){return function(_0x39e3d1){if(_0x39e3d1){return _0x39e3d1['destroy']()['then'](function(){var _0x4b049d=_0x39e3d1['get']({'plain':!![]});var _0x5215f3=_0xb3cd('0x26');return db['UserProfileResource'][_0xb3cd('0x27')]({'where':{'type':_0x5215f3,'resourceId':_0x4b049d['id']}})[_0xb3cd('0x25')](function(){return _0x39e3d1;});})[_0xb3cd('0x25')](function(){_0x23ba33[_0xb3cd('0x1d')](0xcc)['end']();});}};}function handleEntityNotFound(_0x39bcea,_0x12f1a4){return function(_0x470984){if(!_0x470984){_0x39bcea[_0xb3cd('0x1b')](0x194);}return _0x470984;};}function handleError(_0x46dd32,_0x57ee58){_0x57ee58=_0x57ee58||0x1f4;return function(_0x372bfc){logger[_0xb3cd('0x28')](_0x372bfc[_0xb3cd('0x29')]);if(_0x372bfc[_0xb3cd('0x2a')]){delete _0x372bfc[_0xb3cd('0x2a')];}_0x46dd32[_0xb3cd('0x1d')](_0x57ee58)['send'](_0x372bfc);};}exports[_0xb3cd('0x2b')]=function(_0x50499e,_0x4012a5){var _0xdecb7c={},_0x53d9c2={},_0xbb6e34={'count':0x0,'rows':[]};var _0x2de5a2=db[_0xb3cd('0x2c')][_0xb3cd('0x2d')];_0x53d9c2['model']=_[_0xb3cd('0x2e')](_0x2de5a2);_0x53d9c2[_0xb3cd('0x2f')]=_[_0xb3cd('0x2e')](_0x50499e[_0xb3cd('0x2f')]);_0x53d9c2[_0xb3cd('0x30')]=_[_0xb3cd('0x31')](_0x53d9c2['model'],_0x53d9c2[_0xb3cd('0x2f')]);_0xdecb7c['attributes']=_[_0xb3cd('0x31')](_0x53d9c2[_0xb3cd('0x32')],qs[_0xb3cd('0x33')](_0x50499e[_0xb3cd('0x2f')][_0xb3cd('0x33')]));_0xdecb7c['attributes']=_0xdecb7c['attributes'][_0xb3cd('0x34')]?_0xdecb7c[_0xb3cd('0x35')]:_0x53d9c2[_0xb3cd('0x32')];if(!_0x50499e[_0xb3cd('0x2f')][_0xb3cd('0x36')](_0xb3cd('0x37'))){_0xdecb7c[_0xb3cd('0x21')]=qs[_0xb3cd('0x21')](_0x50499e['query']['limit']);_0xdecb7c[_0xb3cd('0x20')]=qs[_0xb3cd('0x20')](_0x50499e[_0xb3cd('0x2f')][_0xb3cd('0x20')]);}_0xdecb7c['order']=qs[_0xb3cd('0x38')](_0x50499e[_0xb3cd('0x2f')][_0xb3cd('0x38')]);_0xdecb7c[_0xb3cd('0x39')]=qs['filters'](_[_0xb3cd('0x3a')](_0x50499e[_0xb3cd('0x2f')],_0x53d9c2[_0xb3cd('0x30')]));if(_0x50499e[_0xb3cd('0x2f')][_0xb3cd('0x3b')]){_0xdecb7c[_0xb3cd('0x39')]=_[_0xb3cd('0x3c')](_0xdecb7c[_0xb3cd('0x39')],{'$or':_[_0xb3cd('0x3d')](_0x2de5a2,function(_0x458a52){if(_0x458a52[_0xb3cd('0x3e')][_0xb3cd('0x3f')]!=='VIRTUAL'){var _0x5301b9={};_0x5301b9[_0x458a52[_0xb3cd('0x40')]]={'$like':'%'+_0x50499e[_0xb3cd('0x2f')][_0xb3cd('0x3b')]+'%'};return _0x5301b9;}})});}_0xdecb7c=_[_0xb3cd('0x3c')]({},_0xdecb7c,_0x50499e['options']);var _0x454449={'where':_0xdecb7c[_0xb3cd('0x39')]};return db[_0xb3cd('0x2c')][_0xb3cd('0x1f')](_0x454449)[_0xb3cd('0x25')](function(_0x5caca2){_0xbb6e34[_0xb3cd('0x1f')]=_0x5caca2;if(_0x50499e[_0xb3cd('0x2f')][_0xb3cd('0x41')]){_0xdecb7c[_0xb3cd('0x42')]=[{'all':!![]}];}return db[_0xb3cd('0x2c')][_0xb3cd('0x43')](_0xdecb7c);})[_0xb3cd('0x25')](function(_0x335c8f){_0xbb6e34[_0xb3cd('0x44')]=_0x335c8f;return _0xbb6e34;})[_0xb3cd('0x25')](respondWithFilteredResult(_0x4012a5,_0xdecb7c))[_0xb3cd('0x45')](handleError(_0x4012a5,null));};exports['show']=function(_0x52bc3d,_0x2fbaab){var _0x59598d={'raw':!![],'where':{'id':_0x52bc3d['params']['id']}},_0x5e2349={};_0x5e2349[_0xb3cd('0x32')]=_['keys'](db[_0xb3cd('0x2c')][_0xb3cd('0x2d')]);_0x5e2349['query']=_['keys'](_0x52bc3d[_0xb3cd('0x2f')]);_0x5e2349[_0xb3cd('0x30')]=_[_0xb3cd('0x31')](_0x5e2349[_0xb3cd('0x32')],_0x5e2349['query']);_0x59598d['attributes']=_[_0xb3cd('0x31')](_0x5e2349[_0xb3cd('0x32')],qs['fields'](_0x52bc3d[_0xb3cd('0x2f')][_0xb3cd('0x33')]));_0x59598d[_0xb3cd('0x35')]=_0x59598d['attributes']['length']?_0x59598d['attributes']:_0x5e2349['model'];if(_0x52bc3d[_0xb3cd('0x2f')][_0xb3cd('0x41')]){_0x59598d[_0xb3cd('0x42')]=[{'all':!![]}];}_0x59598d=_[_0xb3cd('0x3c')]({},_0x59598d,_0x52bc3d[_0xb3cd('0x46')]);return db[_0xb3cd('0x2c')][_0xb3cd('0x47')](_0x59598d)[_0xb3cd('0x25')](handleEntityNotFound(_0x2fbaab,null))[_0xb3cd('0x25')](respondWithResult(_0x2fbaab,null))['catch'](handleError(_0x2fbaab,null));};exports[_0xb3cd('0x48')]=function(_0x3474eb,_0x4da5a4){return db[_0xb3cd('0x2c')][_0xb3cd('0x48')](_0x3474eb[_0xb3cd('0x49')],{})[_0xb3cd('0x25')](function(_0x2ba9ca){var _0x3f0814=_0x3474eb[_0xb3cd('0x4a')][_0xb3cd('0x4b')]({'plain':!![]});if(!_0x3f0814)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x3f0814[_0xb3cd('0x4c')]===_0xb3cd('0x4a')){var _0x985057=_0x2ba9ca[_0xb3cd('0x4b')]({'plain':!![]});var _0x3d7a9c=_0xb3cd('0x4d');return db[_0xb3cd('0x4e')]['find']({'where':{'name':_0x3d7a9c,'userProfileId':_0x3f0814[_0xb3cd('0x4f')]},'raw':!![]})[_0xb3cd('0x25')](function(_0x16df6d){if(_0x16df6d&&_0x16df6d[_0xb3cd('0x50')]===0x0){return db[_0xb3cd('0x51')][_0xb3cd('0x48')]({'name':_0x985057[_0xb3cd('0x2a')],'resourceId':_0x985057['id'],'type':_0xb3cd('0x26'),'sectionId':_0x16df6d['id']},{})[_0xb3cd('0x25')](function(){return _0x2ba9ca;});}else{return _0x2ba9ca;}})['catch'](function(_0x36eb3c){logger[_0xb3cd('0x28')](_0xb3cd('0x52'),_0x36eb3c);throw _0x36eb3c;});}return _0x2ba9ca;})[_0xb3cd('0x25')](respondWithResult(_0x4da5a4,0xc9))[_0xb3cd('0x45')](handleError(_0x4da5a4,null));};exports[_0xb3cd('0x24')]=function(_0x52155a,_0x12df5d){if(_0x52155a['body']['id']){delete _0x52155a[_0xb3cd('0x49')]['id'];}return db[_0xb3cd('0x2c')][_0xb3cd('0x47')]({'where':{'id':_0x52155a[_0xb3cd('0x53')]['id']}})[_0xb3cd('0x25')](handleEntityNotFound(_0x12df5d,null))[_0xb3cd('0x25')](saveUpdates(_0x52155a[_0xb3cd('0x49')],null))[_0xb3cd('0x25')](respondWithResult(_0x12df5d,null))[_0xb3cd('0x45')](handleError(_0x12df5d,null));};exports[_0xb3cd('0x27')]=function(_0x3f81e2,_0x7227d4){return db['AnalyticDefaultReport']['find']({'where':{'id':_0x3f81e2[_0xb3cd('0x53')]['id']}})[_0xb3cd('0x25')](handleEntityNotFound(_0x7227d4,null))[_0xb3cd('0x25')](removeEntity(_0x7227d4,null))[_0xb3cd('0x45')](handleError(_0x7227d4,null));};exports['preview']=function(_0x32196c,_0x28f027){var _0x2a56ce=0xa;var _0x21ca4c=['join',_0xb3cd('0x54'),_0xb3cd('0x55'),_0xb3cd('0x56')];var _0x20c7b9={'SUM':_0xb3cd('0x57'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0xb3cd('0x58'),'MAX':_0xb3cd('0x59'),'MIN':_0xb3cd('0x5a'),'AVG':_0xb3cd('0x5b'),'GROUP_CONCAT':_0xb3cd('0x5c'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0xb3cd('0x5d')};var _0x5cf25e={'SEC_TO_TIME':_0xb3cd('0x5e'),'DATE':_0xb3cd('0x5f'),'HOUR':_0xb3cd('0x60'),'ROUND':_0xb3cd('0x61'),'UNIX_TIMESTAMP':_0xb3cd('0x62')};var _0x996e58=function(_0x39fdb3){return!_[_0xb3cd('0x63')]([_0xb3cd('0x64'),'IS\x20NOT\x20NULL',_0xb3cd('0x65'),_0xb3cd('0x66')],_0x39fdb3);};var _0x57a17b=function(_0x21dad8){if(!_0x21dad8||!_0x21dad8[_0xb3cd('0x67')][_0xb3cd('0x34')]){return'';}for(var _0x4bfa0e='(',_0x2d32c0=0x0;_0x2d32c0<_0x21dad8[_0xb3cd('0x67')][_0xb3cd('0x34')];_0x2d32c0+=0x1){_0x2d32c0>0x0&&(_0x4bfa0e+='\x20'+_0x21dad8[_0xb3cd('0x68')]+'\x20');_0x4bfa0e+=_0x21dad8[_0xb3cd('0x67')][_0x2d32c0][_0xb3cd('0x69')]?_0x57a17b(_0x21dad8[_0xb3cd('0x67')][_0x2d32c0]['group']):_0x21dad8[_0xb3cd('0x67')][_0x2d32c0][_0xb3cd('0x40')]+'\x20'+_0x21dad8[_0xb3cd('0x67')][_0x2d32c0]['condition']+(_0x996e58(_0x21dad8['rules'][_0x2d32c0]['condition'])?'\x20'+_0x21dad8['rules'][_0x2d32c0][_0xb3cd('0x6a')]:'');}return _0x4bfa0e+')';};var _0x3c0f36={'where':{'id':_0x32196c[_0xb3cd('0x53')]['id']}},_0x32e42f,_0x461dbb,_0x119402,_0x3b5239,_0x4f5e61;_0x3c0f36=_['merge']({},_0x3c0f36,_0x32196c[_0xb3cd('0x46')]);return db[_0xb3cd('0x2c')][_0xb3cd('0x47')](_0x3c0f36)[_0xb3cd('0x25')](function(_0x180928){if(_0x180928){_0x32e42f=_0x180928;return _0x180928['getFields']();}return null;})[_0xb3cd('0x25')](function(_0x2c29e6){if(_0x2c29e6){if(!_0x2c29e6[_0xb3cd('0x34')]){throw new db[(_0xb3cd('0x6b'))]['ValidationErrorItem'](_0xb3cd('0x6c'),0x193);}_0x461dbb=_0x2c29e6;return db[_0xb3cd('0x6d')][_0xb3cd('0x43')]({'raw':!![]});}return null;})[_0xb3cd('0x25')](function(_0x28e7be){if(_0x28e7be){_0x119402=_['keyBy'](_0x28e7be,'id');var _0x29e37e;var _0x43e235=squel[_0xb3cd('0x6e')]();_0x43e235[_0xb3cd('0x6f')](_0x32e42f[_0xb3cd('0x70')]);for(var _0x1e0200=0x0;_0x1e0200<_0x461dbb[_0xb3cd('0x34')];_0x1e0200+=0x1){_0x29e37e=_0x461dbb[_0x1e0200]['MetricId']?_0x119402[_0x461dbb[_0x1e0200][_0xb3cd('0x71')]][_0xb3cd('0x72')]:_0x461dbb[_0x1e0200][_0xb3cd('0x40')];_0x29e37e=_0x461dbb[_0x1e0200][_0xb3cd('0x73')]?_[_0xb3cd('0x74')](_0x20c7b9[_0x461dbb[_0x1e0200]['function']],'%s',_0x29e37e):_0x29e37e;_0x29e37e=_0x461dbb[_0x1e0200]['format']?_[_0xb3cd('0x74')](_0x5cf25e[_0x461dbb[_0x1e0200][_0xb3cd('0x75')]],'%s',_0x29e37e):_0x29e37e;if(_0x461dbb[_0x1e0200][_0xb3cd('0x76')]){_0x43e235[_0xb3cd('0x69')](_0x29e37e);}_0x461dbb[_0x1e0200][_0xb3cd('0x77')]&&_0x43e235['order'](_0x29e37e,_0x461dbb[_0x1e0200]['orderBy']===_0xb3cd('0x78')?![]:!![]);_0x43e235[_0xb3cd('0x40')](_0x29e37e,_0x461dbb[_0x1e0200][_0xb3cd('0x79')]||_0x29e37e);}if(_0x32e42f[_0xb3cd('0x7a')]){_0x32e42f[_0xb3cd('0x7a')]=JSON[_0xb3cd('0x7b')](_0x32e42f[_0xb3cd('0x7a')]);for(var _0x3aa7c3=0x0;_0x3aa7c3<_0x32e42f[_0xb3cd('0x7a')][_0xb3cd('0x34')];_0x3aa7c3+=0x1){if(_0x32e42f['joins'][_0x3aa7c3]['type']&&_[_0xb3cd('0x63')](_0x21ca4c,_0x32e42f[_0xb3cd('0x7a')][_0x3aa7c3][_0xb3cd('0x3e')])&&_0x32e42f[_0xb3cd('0x7a')][_0x3aa7c3]['parentKey']&&_0x32e42f[_0xb3cd('0x7a')][_0x3aa7c3]['foreignTable']&&_0x32e42f[_0xb3cd('0x7a')][_0x3aa7c3]['foreignKey']){_0x43e235[_0x32e42f[_0xb3cd('0x7a')][_0x3aa7c3][_0xb3cd('0x3e')]](_0x32e42f[_0xb3cd('0x7a')][_0x3aa7c3][_0xb3cd('0x7c')],null,util[_0xb3cd('0x75')](_0xb3cd('0x7d'),_0x32e42f[_0xb3cd('0x70')],_0x32e42f[_0xb3cd('0x7a')][_0x3aa7c3][_0xb3cd('0x7e')],_0x32e42f['joins'][_0x3aa7c3][_0xb3cd('0x7c')],_0x32e42f[_0xb3cd('0x7a')][_0x3aa7c3]['foreignKey']));}}}if(_0x32e42f[_0xb3cd('0x7f')]){_0x32e42f['conditions']=JSON[_0xb3cd('0x7b')](_0x32e42f[_0xb3cd('0x7f')]);_0x43e235[_0xb3cd('0x39')](_0x57a17b(_0x32e42f[_0xb3cd('0x7f')][_0xb3cd('0x69')]));}_0x4f5e61=_0x43e235[_0xb3cd('0x80')]();_0x43e235[_0xb3cd('0x21')](_0x2a56ce);_0x43e235[_0xb3cd('0x20')](0x0);logger['debug'](_0xb3cd('0x81'),_0x43e235['toString']());return db[_0xb3cd('0x82')][_0xb3cd('0x2f')](_0x43e235['toString'](),{'type':db[_0xb3cd('0x82')][_0xb3cd('0x83')]['SELECT']});}})[_0xb3cd('0x25')](respondWithResult(_0x28f027,null))[_0xb3cd('0x45')](handleError(_0x28f027,null));};function runReport(_0x15335e,_0x5eefbd,_0x103b53){var _0xe6d1f8=_0x5eefbd[_0xb3cd('0x2a')];var _0x326176=0xa;var _0x4171a6=[_0xb3cd('0x84'),_0xb3cd('0x54'),_0xb3cd('0x55'),_0xb3cd('0x56')];var _0x435ee6={'SUM':_0xb3cd('0x57'),'COUNT':_0xb3cd('0x85'),'COUNT DISTINCT':_0xb3cd('0x58'),'MAX':_0xb3cd('0x59'),'MIN':_0xb3cd('0x5a'),'AVG':_0xb3cd('0x5b'),'GROUP_CONCAT':_0xb3cd('0x5c'),'GROUP_CONCAT ASC':_0xb3cd('0x86'),'GROUP_CONCAT DESC':_0xb3cd('0x5d')};var _0x305faf={'SEC_TO_TIME':_0xb3cd('0x5e'),'DATE':'DATE(%s)','HOUR':_0xb3cd('0x60'),'ROUND':_0xb3cd('0x61'),'UNIX_TIMESTAMP':_0xb3cd('0x62')};var _0x44337a=function(_0x267cda){return!_[_0xb3cd('0x63')](['IS\x20NULL',_0xb3cd('0x87'),_0xb3cd('0x65'),'IS\x20NOT\x20EMPTY'],_0x267cda);};var _0x1b2ee2=function(_0x5b18f6){if(!_0x5b18f6||!_0x5b18f6[_0xb3cd('0x67')]['length']){return'';}for(var _0x2407e2='(',_0x25570f=0x0;_0x25570f<_0x5b18f6['rules'][_0xb3cd('0x34')];_0x25570f+=0x1){_0x25570f>0x0&&(_0x2407e2+='\x20'+_0x5b18f6[_0xb3cd('0x68')]+'\x20');_0x2407e2+=_0x5b18f6[_0xb3cd('0x67')][_0x25570f]['group']?_0x1b2ee2(_0x5b18f6[_0xb3cd('0x67')][_0x25570f][_0xb3cd('0x69')]):_0x5b18f6[_0xb3cd('0x67')][_0x25570f]['field']+'\x20'+_0x5b18f6[_0xb3cd('0x67')][_0x25570f][_0xb3cd('0x88')]+(_0x44337a(_0x5b18f6['rules'][_0x25570f]['condition'])?'\x20'+_0x5b18f6[_0xb3cd('0x67')][_0x25570f][_0xb3cd('0x6a')]:'');}return _0x2407e2+')';};var _0x620da3={'where':{'id':_0x15335e['id']}},_0x36a46a,_0x34f396,_0x52f880,_0x536dac,_0x57dd88;_0x620da3=_[_0xb3cd('0x3c')]({},_0x620da3,_0x103b53);return db[_0xb3cd('0x2c')]['find'](_0x620da3)[_0xb3cd('0x25')](function(_0x5ecca9){if(_0x5ecca9){_0x36a46a=_0x5ecca9;return _0x5ecca9['getFields']();}return null;})['then'](function(_0x3258e2){if(_0x3258e2){if(!_0x3258e2['length']){throw new db[(_0xb3cd('0x6b'))][(_0xb3cd('0x89'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x34f396=_0x3258e2;return db[_0xb3cd('0x6d')]['findAll']({'raw':!![]});}return null;})[_0xb3cd('0x25')](function(_0x4fd7c1){if(_0x4fd7c1){_0x52f880=_[_0xb3cd('0x8a')](_0x4fd7c1,'id');var _0x147117;var _0x1de62b=squel[_0xb3cd('0x6e')]();_0x1de62b[_0xb3cd('0x6f')](_0x36a46a[_0xb3cd('0x70')]);for(var _0x473ed1=0x0;_0x473ed1<_0x34f396[_0xb3cd('0x34')];_0x473ed1+=0x1){_0x147117=_0x34f396[_0x473ed1][_0xb3cd('0x71')]?_0x52f880[_0x34f396[_0x473ed1][_0xb3cd('0x71')]][_0xb3cd('0x72')]:_0x34f396[_0x473ed1][_0xb3cd('0x40')];_0x147117=_0x34f396[_0x473ed1][_0xb3cd('0x73')]?_[_0xb3cd('0x74')](_0x435ee6[_0x34f396[_0x473ed1][_0xb3cd('0x73')]],'%s',_0x147117):_0x147117;_0x147117=_0x34f396[_0x473ed1][_0xb3cd('0x75')]?_[_0xb3cd('0x74')](_0x305faf[_0x34f396[_0x473ed1][_0xb3cd('0x75')]],'%s',_0x147117):_0x147117;if(_0x34f396[_0x473ed1]['groupBy']){_0x1de62b[_0xb3cd('0x69')](_0x147117);}_0x34f396[_0x473ed1][_0xb3cd('0x77')]&&_0x1de62b[_0xb3cd('0x8b')](_0x147117,_0x34f396[_0x473ed1][_0xb3cd('0x77')]===_0xb3cd('0x78')?![]:!![]);_0x1de62b[_0xb3cd('0x40')](_0x147117,_0x34f396[_0x473ed1]['alias']||_0x147117);}if(_0x36a46a[_0xb3cd('0x7a')]){_0x36a46a[_0xb3cd('0x7a')]=JSON[_0xb3cd('0x7b')](_0x36a46a[_0xb3cd('0x7a')]);for(var _0x2fae91=0x0;_0x2fae91<_0x36a46a[_0xb3cd('0x7a')]['length'];_0x2fae91+=0x1){if(_0x36a46a[_0xb3cd('0x7a')][_0x2fae91]['type']&&_[_0xb3cd('0x63')](_0x4171a6,_0x36a46a[_0xb3cd('0x7a')][_0x2fae91][_0xb3cd('0x3e')])&&_0x36a46a['joins'][_0x2fae91]['parentKey']&&_0x36a46a[_0xb3cd('0x7a')][_0x2fae91]['foreignTable']&&_0x36a46a[_0xb3cd('0x7a')][_0x2fae91][_0xb3cd('0x8c')]){_0x1de62b[_0x36a46a[_0xb3cd('0x7a')][_0x2fae91][_0xb3cd('0x3e')]](_0x36a46a[_0xb3cd('0x7a')][_0x2fae91][_0xb3cd('0x7c')],null,util['format'](_0xb3cd('0x7d'),_0x36a46a[_0xb3cd('0x70')],_0x36a46a[_0xb3cd('0x7a')][_0x2fae91][_0xb3cd('0x7e')],_0x36a46a[_0xb3cd('0x7a')][_0x2fae91]['foreignTable'],_0x36a46a[_0xb3cd('0x7a')][_0x2fae91]['foreignKey']));}}}if(_0x36a46a[_0xb3cd('0x7f')]){_0x36a46a[_0xb3cd('0x7f')]=JSON['parse'](_0x36a46a[_0xb3cd('0x7f')]);_0x1de62b['where'](_0x1b2ee2(_0x36a46a[_0xb3cd('0x7f')][_0xb3cd('0x69')]));}_0x57dd88=_0x1de62b['clone']();_0x1de62b[_0xb3cd('0x21')](_0x326176);_0x1de62b[_0xb3cd('0x20')](0x0);logger[_0xb3cd('0x8d')](_0xb3cd('0x81'),_0x1de62b[_0xb3cd('0x8e')]());return db[_0xb3cd('0x82')][_0xb3cd('0x2f')](_0x1de62b['toString'](),{'type':db[_0xb3cd('0x82')][_0xb3cd('0x83')][_0xb3cd('0x8f')]});}})[_0xb3cd('0x25')](function(_0x5572ab){if(!_0x5572ab[_0xb3cd('0x34')]){throw new db[(_0xb3cd('0x6b'))][(_0xb3cd('0x89'))]('No\x20available\x20data',0xcc);}if(_0x5eefbd[_0xb3cd('0x90')]===_0xb3cd('0x91')){return null;}var _0x133b3f=_['merge'](_0x5eefbd,{'name':_0x5eefbd[_0xb3cd('0x92')]||_0x5eefbd[_0xb3cd('0x2a')]||_0x36a46a[_0xb3cd('0x2a')],'basename':_0xe6d1f8,'savename':util[_0xb3cd('0x75')](_0xb3cd('0x93'),_0x5eefbd['name']||_0x36a46a['name'],require('randomstring')['generate'](0x4),_0x5eefbd['output']||_0xb3cd('0x94')),'reportId':_0x36a46a['id'],'reportType':_0xb3cd('0x95')});return db['AnalyticExtractedReport'][_0xb3cd('0x48')](_0x133b3f,{'raw':!![]});})[_0xb3cd('0x25')](function(_0x3bf843){if(_0x36a46a[_0xb3cd('0x70')]==='cdr'){_0x57dd88[_0xb3cd('0x39')](_0x36a46a[_0xb3cd('0x70')]+_0xb3cd('0x96'),_0x5eefbd['startDate'],_0x5eefbd['endDate']);}else{_0x57dd88[_0xb3cd('0x39')](_0x36a46a[_0xb3cd('0x70')]+_0xb3cd('0x97'),_0x5eefbd[_0xb3cd('0x98')],_0x5eefbd[_0xb3cd('0x99')]);}if(_0x3bf843){logger[_0xb3cd('0x9a')](_0xb3cd('0x9b'),_0x57dd88[_0xb3cd('0x8e')]());require(_0xb3cd('0x9c'))['fork'](path['join'](__dirname,_0xb3cd('0x9d'),_0x3bf843['output']),[_0x3bf843['id'],_0x57dd88[_0xb3cd('0x8e')](),path['join'](__dirname,'../../files/reports',_0x3bf843['savename']),_0xe6d1f8]);return _0x3bf843;}else{var _0x8a8eb5=squel[_0xb3cd('0x6e')]();_0x8a8eb5['from']('('+_0x57dd88[_0xb3cd('0x8e')]()+')',_0xb3cd('0x9e'));_0x8a8eb5[_0xb3cd('0x40')](_0xb3cd('0x9f'),_0xb3cd('0x1f'));_0x57dd88[_0xb3cd('0x21')](_0x5eefbd[_0xb3cd('0x21')]||_0x326176);_0x57dd88[_0xb3cd('0x20')](_0x5eefbd['offset']||0x0);return db[_0xb3cd('0x82')]['query'](_0x8a8eb5['toString'](),{'type':db['sequelize'][_0xb3cd('0x83')][_0xb3cd('0x8f')]})[_0xb3cd('0x25')](function(_0x5d7c77){if(!_0x5d7c77[_0xb3cd('0x34')]){_0x536dac=0x0;}else{_0x536dac=_0x5d7c77[0x0][_0xb3cd('0x1f')]||0x0;}return db['sequelize'][_0xb3cd('0x2f')](_0x57dd88['toString'](),{'type':db[_0xb3cd('0x82')][_0xb3cd('0x83')][_0xb3cd('0x8f')]});})[_0xb3cd('0x25')](function(_0xae9c80){return{'rows':_0xae9c80||[],'count':_0x536dac};});}});}exports[_0xb3cd('0xa0')]=function(_0x1a82ae,_0x4b5785){return runReport(_0x1a82ae[_0xb3cd('0x53')],_0x1a82ae[_0xb3cd('0x2f')],_0x1a82ae['options'])[_0xb3cd('0x25')](respondWithResult(_0x4b5785,null))[_0xb3cd('0x45')](handleError(_0x4b5785,null));};exports['runReport']=runReport;exports[_0xb3cd('0x2f')]=function(_0x4675a5,_0x464374){var _0xbe4b26=0xa;var _0x2b3ec9=[_0xb3cd('0x84'),_0xb3cd('0x54'),_0xb3cd('0x55'),_0xb3cd('0x56')];var _0x5ad47b={'SUM':'SUM(%s)','COUNT':_0xb3cd('0x85'),'COUNT DISTINCT':_0xb3cd('0x58'),'MAX':_0xb3cd('0x59'),'MIN':'MIN(%s)','AVG':'AVG(%s)','GROUP_CONCAT':_0xb3cd('0x5c'),'GROUP_CONCAT ASC':_0xb3cd('0x86'),'GROUP_CONCAT DESC':_0xb3cd('0x5d')};var _0x1fe0fc={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0xb3cd('0x5f'),'HOUR':'HOUR(%s)','ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0xb3cd('0x62')};var _0x48b195=function(_0x2e62e8){return!_['includes']([_0xb3cd('0x64'),'IS\x20NOT\x20NULL',_0xb3cd('0x65'),_0xb3cd('0x66')],_0x2e62e8);};var _0x12d7d0=function(_0x37655f){if(!_0x37655f||!_0x37655f[_0xb3cd('0x67')][_0xb3cd('0x34')]){return'';}for(var _0x3ec633='(',_0x23d03d=0x0;_0x23d03d<_0x37655f[_0xb3cd('0x67')][_0xb3cd('0x34')];_0x23d03d+=0x1){_0x23d03d>0x0&&(_0x3ec633+='\x20'+_0x37655f[_0xb3cd('0x68')]+'\x20');_0x3ec633+=_0x37655f['rules'][_0x23d03d][_0xb3cd('0x69')]?_0x12d7d0(_0x37655f[_0xb3cd('0x67')][_0x23d03d][_0xb3cd('0x69')]):_0x37655f[_0xb3cd('0x67')][_0x23d03d][_0xb3cd('0x40')]+'\x20'+_0x37655f[_0xb3cd('0x67')][_0x23d03d]['condition']+(_0x48b195(_0x37655f['rules'][_0x23d03d][_0xb3cd('0x88')])?'\x20'+_0x37655f[_0xb3cd('0x67')][_0x23d03d][_0xb3cd('0x6a')]:'');}return _0x3ec633+')';};var _0x3db01c={'where':{'id':_0x4675a5[_0xb3cd('0x53')]['id']}},_0x2552cd,_0x3d3514,_0x3250d0,_0x220764,_0x3615d1;_0x3db01c=_['merge']({},_0x3db01c,_0x4675a5[_0xb3cd('0x46')]);return db[_0xb3cd('0x2c')][_0xb3cd('0x47')](_0x3db01c)[_0xb3cd('0x25')](function(_0x2c01b8){if(_0x2c01b8){_0x2552cd=_0x2c01b8;return _0x2c01b8[_0xb3cd('0xa1')]();}return null;})[_0xb3cd('0x25')](function(_0xf1fa5b){if(_0xf1fa5b){if(!_0xf1fa5b[_0xb3cd('0x34')]){throw new db[(_0xb3cd('0x6b'))][(_0xb3cd('0x89'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x3d3514=_0xf1fa5b;return db[_0xb3cd('0x6d')][_0xb3cd('0x43')]({'raw':!![]});}return null;})[_0xb3cd('0x25')](function(_0xeb98ab){if(_0xeb98ab){_0x3250d0=_[_0xb3cd('0x8a')](_0xeb98ab,'id');var _0x32d9ce;var _0x373602=squel[_0xb3cd('0x6e')]();_0x373602[_0xb3cd('0x6f')](_0x2552cd[_0xb3cd('0x70')]);for(var _0x5e2eb1=0x0;_0x5e2eb1<_0x3d3514['length'];_0x5e2eb1+=0x1){_0x32d9ce=_0x3d3514[_0x5e2eb1][_0xb3cd('0x71')]?_0x3250d0[_0x3d3514[_0x5e2eb1][_0xb3cd('0x71')]][_0xb3cd('0x72')]:_0x3d3514[_0x5e2eb1][_0xb3cd('0x40')];_0x32d9ce=_0x3d3514[_0x5e2eb1][_0xb3cd('0x73')]?_['replace'](_0x5ad47b[_0x3d3514[_0x5e2eb1][_0xb3cd('0x73')]],'%s',_0x32d9ce):_0x32d9ce;_0x32d9ce=_0x3d3514[_0x5e2eb1][_0xb3cd('0x75')]?_[_0xb3cd('0x74')](_0x1fe0fc[_0x3d3514[_0x5e2eb1][_0xb3cd('0x75')]],'%s',_0x32d9ce):_0x32d9ce;if(_0x3d3514[_0x5e2eb1][_0xb3cd('0x76')]){_0x373602[_0xb3cd('0x69')](_0x32d9ce);}_0x3d3514[_0x5e2eb1][_0xb3cd('0x77')]&&_0x373602[_0xb3cd('0x8b')](_0x32d9ce,_0x3d3514[_0x5e2eb1][_0xb3cd('0x77')]===_0xb3cd('0x78')?![]:!![]);_0x373602[_0xb3cd('0x40')](_0x32d9ce,_0x3d3514[_0x5e2eb1][_0xb3cd('0x79')]||_0x32d9ce);}if(_0x2552cd[_0xb3cd('0x7a')]){_0x2552cd[_0xb3cd('0x7a')]=JSON[_0xb3cd('0x7b')](_0x2552cd[_0xb3cd('0x7a')]);for(var _0x812c2e=0x0;_0x812c2e<_0x2552cd[_0xb3cd('0x7a')][_0xb3cd('0x34')];_0x812c2e+=0x1){if(_0x2552cd['joins'][_0x812c2e][_0xb3cd('0x3e')]&&_[_0xb3cd('0x63')](_0x2b3ec9,_0x2552cd['joins'][_0x812c2e]['type'])&&_0x2552cd[_0xb3cd('0x7a')][_0x812c2e]['parentKey']&&_0x2552cd[_0xb3cd('0x7a')][_0x812c2e][_0xb3cd('0x7c')]&&_0x2552cd[_0xb3cd('0x7a')][_0x812c2e][_0xb3cd('0x8c')]){_0x373602[_0x2552cd[_0xb3cd('0x7a')][_0x812c2e][_0xb3cd('0x3e')]](_0x2552cd[_0xb3cd('0x7a')][_0x812c2e][_0xb3cd('0x7c')],null,util[_0xb3cd('0x75')](_0xb3cd('0x7d'),_0x2552cd[_0xb3cd('0x70')],_0x2552cd[_0xb3cd('0x7a')][_0x812c2e][_0xb3cd('0x7e')],_0x2552cd[_0xb3cd('0x7a')][_0x812c2e]['foreignTable'],_0x2552cd[_0xb3cd('0x7a')][_0x812c2e][_0xb3cd('0x8c')]));}}}if(_0x2552cd[_0xb3cd('0x7f')]){_0x2552cd[_0xb3cd('0x7f')]=JSON[_0xb3cd('0x7b')](_0x2552cd[_0xb3cd('0x7f')]);_0x373602['where'](_0x12d7d0(_0x2552cd[_0xb3cd('0x7f')]['group']));}_0x3615d1=_0x373602[_0xb3cd('0x80')]();_0x373602[_0xb3cd('0x21')](_0xbe4b26);_0x373602[_0xb3cd('0x20')](0x0);logger[_0xb3cd('0x8d')](_0xb3cd('0x81'),_0x373602[_0xb3cd('0x8e')]());return db[_0xb3cd('0x82')][_0xb3cd('0x2f')](_0x373602[_0xb3cd('0x8e')](),{'type':db[_0xb3cd('0x82')][_0xb3cd('0x83')][_0xb3cd('0x8f')]});}})[_0xb3cd('0x25')](function(){return{'sql':_0x3615d1[_0xb3cd('0x8e')]()};})[_0xb3cd('0x25')](respondWithResult(_0x464374,null))[_0xb3cd('0x45')](handleError(_0x464374,null));};
\ No newline at end of file
+var _0xac5f=['MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','DATE(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','rules','operator','group','value','getFields','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','select','from','MetricId','function','format','replace','groupBy','orderBy','DESC','alias','joins','parse','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','table','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','left_join','GROUP_CONCAT(%s)','SEC_TO_TIME(%s)','IS\x20EMPTY','condition','Sequelize','metric','output','web','fullPath','%s-%s.%s','randomstring','generate','csv','default','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','info','Run\x20Query:','child_process','../../components/export/','../../files/reports','savename','COUNT(*)','run','runReport','IS\x20NOT\x20EMPTY','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','to-csv','ejs','lodash','squel','crypto','querystring','papaparse','ioredis','../../components/auth/service','../../config/license/hardware','../../config/logger','api','../../config/utils','../../mysqldb','status','end','json','offset','limit','Content-Range','apply','reject','update','then','destroy','get','DefaultReports','UserProfileResource','sendStatus','error','stack','name','send','index','AnalyticDefaultReport','model','keys','query','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','merge','map','type','key','VIRTUAL','field','options','count','includeAll','include','findAll','rows','show','rawAttributes','find','catch','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','params','join','right_join','cross_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)'];(function(_0x4f9b18,_0x2cb5ca){var _0x29f20c=function(_0x268b3d){while(--_0x268b3d){_0x4f9b18['push'](_0x4f9b18['shift']());}};_0x29f20c(++_0x2cb5ca);}(_0xac5f,0x190));var _0xfac5=function(_0xc50088,_0x4aaef5){_0xc50088=_0xc50088-0x0;var _0x150f01=_0xac5f[_0xc50088];return _0x150f01;};'use strict';var pdf=require(_0xfac5('0x0'));var emlformat=require(_0xfac5('0x1'));var rimraf=require(_0xfac5('0x2'));var zipdir=require(_0xfac5('0x3'));var jsonpatch=require(_0xfac5('0x4'));var rp=require('request-promise');var moment=require(_0xfac5('0x5'));var BPromise=require(_0xfac5('0x6'));var Mustache=require(_0xfac5('0x7'));var util=require(_0xfac5('0x8'));var path=require(_0xfac5('0x9'));var sox=require('sox');var csv=require(_0xfac5('0xa'));var ejs=require(_0xfac5('0xb'));var fs=require('fs');var _=require(_0xfac5('0xc'));var squel=require(_0xfac5('0xd'));var crypto=require(_0xfac5('0xe'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0xfac5('0xa'));var querystring=require(_0xfac5('0xf'));var Papa=require(_0xfac5('0x10'));var Redis=require(_0xfac5('0x11'));var authService=require(_0xfac5('0x12'));var qs=require('../../components/parsers/qs');var hardwareService=require(_0xfac5('0x13'));var logger=require(_0xfac5('0x14'))(_0xfac5('0x15'));var utils=require(_0xfac5('0x16'));var config=require('../../config/environment');var db=require(_0xfac5('0x17'))['db'];function respondWithStatusCode(_0x26871a,_0x29a4f2){_0x29a4f2=_0x29a4f2||0xcc;return function(_0x3b0d6c){if(_0x3b0d6c){return _0x26871a['sendStatus'](_0x29a4f2);}return _0x26871a[_0xfac5('0x18')](_0x29a4f2)[_0xfac5('0x19')]();};}function respondWithResult(_0xc4b46d,_0x3319e2){_0x3319e2=_0x3319e2||0xc8;return function(_0x18a89f){if(_0x18a89f){return _0xc4b46d[_0xfac5('0x18')](_0x3319e2)[_0xfac5('0x1a')](_0x18a89f);}};}function respondWithFilteredResult(_0x1a3660,_0x247a82){return function(_0x32a9f3){if(_0x32a9f3){var _0x51dd21=_0x32a9f3['count'],_0x422e00=_0x247a82[_0xfac5('0x1b')],_0x234134=_0x247a82[_0xfac5('0x1b')]+_0x247a82[_0xfac5('0x1c')],_0x5f53ca;if(_0x234134>=_0x51dd21){_0x234134=_0x51dd21;_0x5f53ca=0xc8;}else{_0x5f53ca=0xce;}_0x1a3660[_0xfac5('0x18')](_0x5f53ca);return _0x1a3660['set'](_0xfac5('0x1d'),_0x422e00+'-'+_0x234134+'/'+_0x51dd21)[_0xfac5('0x1a')](_0x32a9f3);}return null;};}function patchUpdates(_0x51ca8d){return function(_0x5f0091){try{jsonpatch[_0xfac5('0x1e')](_0x5f0091,_0x51ca8d,!![]);}catch(_0x3af4cd){return BPromise[_0xfac5('0x1f')](_0x3af4cd);}return _0x5f0091['save']();};}function saveUpdates(_0x3643c7,_0x26133a){return function(_0x5beccd){if(_0x5beccd){return _0x5beccd[_0xfac5('0x20')](_0x3643c7)[_0xfac5('0x21')](function(_0x16cc4a){return _0x16cc4a;});}return null;};}function removeEntity(_0x4532de,_0xe36977){return function(_0x486642){if(_0x486642){return _0x486642[_0xfac5('0x22')]()['then'](function(){var _0xf86a54=_0x486642[_0xfac5('0x23')]({'plain':!![]});var _0x5e06c3=_0xfac5('0x24');return db[_0xfac5('0x25')][_0xfac5('0x22')]({'where':{'type':_0x5e06c3,'resourceId':_0xf86a54['id']}})[_0xfac5('0x21')](function(){return _0x486642;});})['then'](function(){_0x4532de[_0xfac5('0x18')](0xcc)['end']();});}};}function handleEntityNotFound(_0x359c45,_0x5f0cff){return function(_0x4da524){if(!_0x4da524){_0x359c45[_0xfac5('0x26')](0x194);}return _0x4da524;};}function handleError(_0x810b81,_0x4fd009){_0x4fd009=_0x4fd009||0x1f4;return function(_0x5f332a){logger[_0xfac5('0x27')](_0x5f332a[_0xfac5('0x28')]);if(_0x5f332a[_0xfac5('0x29')]){delete _0x5f332a[_0xfac5('0x29')];}_0x810b81[_0xfac5('0x18')](_0x4fd009)[_0xfac5('0x2a')](_0x5f332a);};}exports[_0xfac5('0x2b')]=function(_0x28fe13,_0x28ae68){var _0x1c9b7c={},_0x18c281={},_0x3436c7={'count':0x0,'rows':[]};var _0xe273a0=db[_0xfac5('0x2c')]['rawAttributes'];_0x18c281[_0xfac5('0x2d')]=_[_0xfac5('0x2e')](_0xe273a0);_0x18c281[_0xfac5('0x2f')]=_[_0xfac5('0x2e')](_0x28fe13['query']);_0x18c281['filters']=_[_0xfac5('0x30')](_0x18c281[_0xfac5('0x2d')],_0x18c281[_0xfac5('0x2f')]);_0x1c9b7c[_0xfac5('0x31')]=_[_0xfac5('0x30')](_0x18c281['model'],qs[_0xfac5('0x32')](_0x28fe13[_0xfac5('0x2f')][_0xfac5('0x32')]));_0x1c9b7c[_0xfac5('0x31')]=_0x1c9b7c[_0xfac5('0x31')][_0xfac5('0x33')]?_0x1c9b7c['attributes']:_0x18c281[_0xfac5('0x2d')];if(!_0x28fe13[_0xfac5('0x2f')][_0xfac5('0x34')](_0xfac5('0x35'))){_0x1c9b7c['limit']=qs[_0xfac5('0x1c')](_0x28fe13['query'][_0xfac5('0x1c')]);_0x1c9b7c[_0xfac5('0x1b')]=qs[_0xfac5('0x1b')](_0x28fe13[_0xfac5('0x2f')][_0xfac5('0x1b')]);}_0x1c9b7c[_0xfac5('0x36')]=qs['sort'](_0x28fe13[_0xfac5('0x2f')][_0xfac5('0x37')]);_0x1c9b7c[_0xfac5('0x38')]=qs[_0xfac5('0x39')](_[_0xfac5('0x3a')](_0x28fe13['query'],_0x18c281['filters']));if(_0x28fe13[_0xfac5('0x2f')][_0xfac5('0x3b')]){_0x1c9b7c[_0xfac5('0x38')]=_[_0xfac5('0x3c')](_0x1c9b7c[_0xfac5('0x38')],{'$or':_[_0xfac5('0x3d')](_0xe273a0,function(_0x4ed79b){if(_0x4ed79b[_0xfac5('0x3e')][_0xfac5('0x3f')]!==_0xfac5('0x40')){var _0x4dce9d={};_0x4dce9d[_0x4ed79b[_0xfac5('0x41')]]={'$like':'%'+_0x28fe13['query']['filter']+'%'};return _0x4dce9d;}})});}_0x1c9b7c=_[_0xfac5('0x3c')]({},_0x1c9b7c,_0x28fe13[_0xfac5('0x42')]);var _0x5554f7={'where':_0x1c9b7c[_0xfac5('0x38')]};return db[_0xfac5('0x2c')][_0xfac5('0x43')](_0x5554f7)[_0xfac5('0x21')](function(_0x21c2c1){_0x3436c7[_0xfac5('0x43')]=_0x21c2c1;if(_0x28fe13['query'][_0xfac5('0x44')]){_0x1c9b7c[_0xfac5('0x45')]=[{'all':!![]}];}return db[_0xfac5('0x2c')][_0xfac5('0x46')](_0x1c9b7c);})[_0xfac5('0x21')](function(_0x3d3278){_0x3436c7[_0xfac5('0x47')]=_0x3d3278;return _0x3436c7;})[_0xfac5('0x21')](respondWithFilteredResult(_0x28ae68,_0x1c9b7c))['catch'](handleError(_0x28ae68,null));};exports[_0xfac5('0x48')]=function(_0x441058,_0x5c8677){var _0x97963a={'raw':!![],'where':{'id':_0x441058['params']['id']}},_0x2d66d7={};_0x2d66d7['model']=_['keys'](db[_0xfac5('0x2c')][_0xfac5('0x49')]);_0x2d66d7['query']=_['keys'](_0x441058[_0xfac5('0x2f')]);_0x2d66d7[_0xfac5('0x39')]=_[_0xfac5('0x30')](_0x2d66d7[_0xfac5('0x2d')],_0x2d66d7[_0xfac5('0x2f')]);_0x97963a[_0xfac5('0x31')]=_[_0xfac5('0x30')](_0x2d66d7[_0xfac5('0x2d')],qs[_0xfac5('0x32')](_0x441058[_0xfac5('0x2f')][_0xfac5('0x32')]));_0x97963a[_0xfac5('0x31')]=_0x97963a[_0xfac5('0x31')][_0xfac5('0x33')]?_0x97963a[_0xfac5('0x31')]:_0x2d66d7['model'];if(_0x441058[_0xfac5('0x2f')][_0xfac5('0x44')]){_0x97963a[_0xfac5('0x45')]=[{'all':!![]}];}_0x97963a=_[_0xfac5('0x3c')]({},_0x97963a,_0x441058[_0xfac5('0x42')]);return db[_0xfac5('0x2c')][_0xfac5('0x4a')](_0x97963a)[_0xfac5('0x21')](handleEntityNotFound(_0x5c8677,null))[_0xfac5('0x21')](respondWithResult(_0x5c8677,null))[_0xfac5('0x4b')](handleError(_0x5c8677,null));};exports[_0xfac5('0x4c')]=function(_0x2e5bcb,_0x4a2d4f){return db[_0xfac5('0x2c')][_0xfac5('0x4c')](_0x2e5bcb['body'],{})[_0xfac5('0x21')](function(_0x5ad987){var _0x28c111=_0x2e5bcb[_0xfac5('0x4d')]['get']({'plain':!![]});if(!_0x28c111)throw new Error(_0xfac5('0x4e'));if(_0x28c111[_0xfac5('0x4f')]===_0xfac5('0x4d')){var _0x5e5f70=_0x5ad987[_0xfac5('0x23')]({'plain':!![]});var _0x5c2646='Reports';return db[_0xfac5('0x50')][_0xfac5('0x4a')]({'where':{'name':_0x5c2646,'userProfileId':_0x28c111[_0xfac5('0x51')]},'raw':!![]})[_0xfac5('0x21')](function(_0x2c9079){if(_0x2c9079&&_0x2c9079[_0xfac5('0x52')]===0x0){return db[_0xfac5('0x25')][_0xfac5('0x4c')]({'name':_0x5e5f70['name'],'resourceId':_0x5e5f70['id'],'type':_0xfac5('0x24'),'sectionId':_0x2c9079['id']},{})[_0xfac5('0x21')](function(){return _0x5ad987;});}else{return _0x5ad987;}})[_0xfac5('0x4b')](function(_0x1a48e6){logger[_0xfac5('0x27')](_0xfac5('0x53'),_0x1a48e6);throw _0x1a48e6;});}return _0x5ad987;})[_0xfac5('0x21')](respondWithResult(_0x4a2d4f,0xc9))['catch'](handleError(_0x4a2d4f,null));};exports[_0xfac5('0x20')]=function(_0x4e6d4c,_0x55629f){if(_0x4e6d4c[_0xfac5('0x54')]['id']){delete _0x4e6d4c[_0xfac5('0x54')]['id'];}return db[_0xfac5('0x2c')][_0xfac5('0x4a')]({'where':{'id':_0x4e6d4c[_0xfac5('0x55')]['id']}})['then'](handleEntityNotFound(_0x55629f,null))['then'](saveUpdates(_0x4e6d4c[_0xfac5('0x54')],null))[_0xfac5('0x21')](respondWithResult(_0x55629f,null))[_0xfac5('0x4b')](handleError(_0x55629f,null));};exports[_0xfac5('0x22')]=function(_0x59315c,_0x201df8){return db[_0xfac5('0x2c')]['find']({'where':{'id':_0x59315c[_0xfac5('0x55')]['id']}})['then'](handleEntityNotFound(_0x201df8,null))['then'](removeEntity(_0x201df8,null))[_0xfac5('0x4b')](handleError(_0x201df8,null));};exports['preview']=function(_0x28f1af,_0xb50dcc){var _0x3e861f=0xa;var _0x44fd25=[_0xfac5('0x56'),'left_join',_0xfac5('0x57'),_0xfac5('0x58')];var _0x50b631={'SUM':_0xfac5('0x59'),'COUNT':_0xfac5('0x5a'),'COUNT DISTINCT':_0xfac5('0x5b'),'MAX':_0xfac5('0x5c'),'MIN':_0xfac5('0x5d'),'AVG':_0xfac5('0x5e'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0xfac5('0x5f')};var _0x310f06={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0xfac5('0x60'),'HOUR':'HOUR(%s)','ROUND':_0xfac5('0x61'),'UNIX_TIMESTAMP':_0xfac5('0x62')};var _0x48fcfb=function(_0x35e51c){return!_[_0xfac5('0x63')]([_0xfac5('0x64'),_0xfac5('0x65'),'IS\x20EMPTY','IS\x20NOT\x20EMPTY'],_0x35e51c);};var _0x5c5355=function(_0x59e6b3){if(!_0x59e6b3||!_0x59e6b3[_0xfac5('0x66')]['length']){return'';}for(var _0x2322a5='(',_0x3e7ff2=0x0;_0x3e7ff2<_0x59e6b3['rules'][_0xfac5('0x33')];_0x3e7ff2+=0x1){_0x3e7ff2>0x0&&(_0x2322a5+='\x20'+_0x59e6b3[_0xfac5('0x67')]+'\x20');_0x2322a5+=_0x59e6b3[_0xfac5('0x66')][_0x3e7ff2][_0xfac5('0x68')]?_0x5c5355(_0x59e6b3[_0xfac5('0x66')][_0x3e7ff2][_0xfac5('0x68')]):_0x59e6b3['rules'][_0x3e7ff2]['field']+'\x20'+_0x59e6b3[_0xfac5('0x66')][_0x3e7ff2]['condition']+(_0x48fcfb(_0x59e6b3[_0xfac5('0x66')][_0x3e7ff2]['condition'])?'\x20'+_0x59e6b3[_0xfac5('0x66')][_0x3e7ff2][_0xfac5('0x69')]:'');}return _0x2322a5+')';};var _0x57ac82={'where':{'id':_0x28f1af[_0xfac5('0x55')]['id']}},_0x67a223,_0x34295d,_0x150af6,_0x4a06cc,_0x2ce538;_0x57ac82=_[_0xfac5('0x3c')]({},_0x57ac82,_0x28f1af[_0xfac5('0x42')]);return db[_0xfac5('0x2c')][_0xfac5('0x4a')](_0x57ac82)['then'](function(_0x1043a6){if(_0x1043a6){_0x67a223=_0x1043a6;return _0x1043a6[_0xfac5('0x6a')]();}return null;})['then'](function(_0x4acdfd){if(_0x4acdfd){if(!_0x4acdfd[_0xfac5('0x33')]){throw new db['Sequelize'][(_0xfac5('0x6b'))](_0xfac5('0x6c'),0x193);}_0x34295d=_0x4acdfd;return db[_0xfac5('0x6d')][_0xfac5('0x46')]({'raw':!![]});}return null;})[_0xfac5('0x21')](function(_0x3a16ac){if(_0x3a16ac){_0x150af6=_[_0xfac5('0x6e')](_0x3a16ac,'id');var _0x27e770;var _0x4cabc1=squel[_0xfac5('0x6f')]();_0x4cabc1[_0xfac5('0x70')](_0x67a223['table']);for(var _0x58269a=0x0;_0x58269a<_0x34295d['length'];_0x58269a+=0x1){_0x27e770=_0x34295d[_0x58269a]['MetricId']?_0x150af6[_0x34295d[_0x58269a][_0xfac5('0x71')]]['metric']:_0x34295d[_0x58269a][_0xfac5('0x41')];_0x27e770=_0x34295d[_0x58269a][_0xfac5('0x72')]?_['replace'](_0x50b631[_0x34295d[_0x58269a][_0xfac5('0x72')]],'%s',_0x27e770):_0x27e770;_0x27e770=_0x34295d[_0x58269a][_0xfac5('0x73')]?_[_0xfac5('0x74')](_0x310f06[_0x34295d[_0x58269a][_0xfac5('0x73')]],'%s',_0x27e770):_0x27e770;if(_0x34295d[_0x58269a][_0xfac5('0x75')]){_0x4cabc1[_0xfac5('0x68')](_0x27e770);}_0x34295d[_0x58269a][_0xfac5('0x76')]&&_0x4cabc1[_0xfac5('0x36')](_0x27e770,_0x34295d[_0x58269a][_0xfac5('0x76')]===_0xfac5('0x77')?![]:!![]);_0x4cabc1['field'](_0x27e770,_0x34295d[_0x58269a][_0xfac5('0x78')]||_0x27e770);}if(_0x67a223['joins']){_0x67a223[_0xfac5('0x79')]=JSON[_0xfac5('0x7a')](_0x67a223[_0xfac5('0x79')]);for(var _0x3175bb=0x0;_0x3175bb<_0x67a223[_0xfac5('0x79')][_0xfac5('0x33')];_0x3175bb+=0x1){if(_0x67a223[_0xfac5('0x79')][_0x3175bb][_0xfac5('0x3e')]&&_['includes'](_0x44fd25,_0x67a223[_0xfac5('0x79')][_0x3175bb][_0xfac5('0x3e')])&&_0x67a223[_0xfac5('0x79')][_0x3175bb][_0xfac5('0x7b')]&&_0x67a223[_0xfac5('0x79')][_0x3175bb][_0xfac5('0x7c')]&&_0x67a223['joins'][_0x3175bb][_0xfac5('0x7d')]){_0x4cabc1[_0x67a223[_0xfac5('0x79')][_0x3175bb][_0xfac5('0x3e')]](_0x67a223[_0xfac5('0x79')][_0x3175bb][_0xfac5('0x7c')],null,util[_0xfac5('0x73')](_0xfac5('0x7e'),_0x67a223[_0xfac5('0x7f')],_0x67a223[_0xfac5('0x79')][_0x3175bb][_0xfac5('0x7b')],_0x67a223[_0xfac5('0x79')][_0x3175bb]['foreignTable'],_0x67a223[_0xfac5('0x79')][_0x3175bb][_0xfac5('0x7d')]));}}}if(_0x67a223[_0xfac5('0x80')]){_0x67a223[_0xfac5('0x80')]=JSON[_0xfac5('0x7a')](_0x67a223[_0xfac5('0x80')]);_0x4cabc1[_0xfac5('0x38')](_0x5c5355(_0x67a223['conditions'][_0xfac5('0x68')]));}_0x2ce538=_0x4cabc1[_0xfac5('0x81')]();_0x4cabc1[_0xfac5('0x1c')](_0x3e861f);_0x4cabc1[_0xfac5('0x1b')](0x0);logger[_0xfac5('0x82')](_0xfac5('0x83'),_0x4cabc1[_0xfac5('0x84')]());return db[_0xfac5('0x85')][_0xfac5('0x2f')](_0x4cabc1['toString'](),{'type':db[_0xfac5('0x85')][_0xfac5('0x86')][_0xfac5('0x87')]});}})[_0xfac5('0x21')](respondWithResult(_0xb50dcc,null))['catch'](handleError(_0xb50dcc,null));};function runReport(_0x1e65c4,_0x170808,_0x30f840){var _0x32a490=_0x170808['name'];var _0x148f08=0xa;var _0x9d05c6=[_0xfac5('0x56'),_0xfac5('0x88'),_0xfac5('0x57'),'cross_join'];var _0x53fd2d={'SUM':'SUM(%s)','COUNT':_0xfac5('0x5a'),'COUNT DISTINCT':_0xfac5('0x5b'),'MAX':_0xfac5('0x5c'),'MIN':_0xfac5('0x5d'),'AVG':'AVG(%s)','GROUP_CONCAT':_0xfac5('0x89'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x262038={'SEC_TO_TIME':_0xfac5('0x8a'),'DATE':_0xfac5('0x60'),'HOUR':'HOUR(%s)','ROUND':_0xfac5('0x61'),'UNIX_TIMESTAMP':_0xfac5('0x62')};var _0x5baf5d=function(_0xdfb568){return!_[_0xfac5('0x63')](['IS\x20NULL','IS\x20NOT\x20NULL',_0xfac5('0x8b'),'IS\x20NOT\x20EMPTY'],_0xdfb568);};var _0x54b499=function(_0x4b803c){if(!_0x4b803c||!_0x4b803c[_0xfac5('0x66')][_0xfac5('0x33')]){return'';}for(var _0x323c5c='(',_0x55b423=0x0;_0x55b423<_0x4b803c[_0xfac5('0x66')]['length'];_0x55b423+=0x1){_0x55b423>0x0&&(_0x323c5c+='\x20'+_0x4b803c['operator']+'\x20');_0x323c5c+=_0x4b803c[_0xfac5('0x66')][_0x55b423][_0xfac5('0x68')]?_0x54b499(_0x4b803c[_0xfac5('0x66')][_0x55b423][_0xfac5('0x68')]):_0x4b803c[_0xfac5('0x66')][_0x55b423][_0xfac5('0x41')]+'\x20'+_0x4b803c['rules'][_0x55b423][_0xfac5('0x8c')]+(_0x5baf5d(_0x4b803c[_0xfac5('0x66')][_0x55b423][_0xfac5('0x8c')])?'\x20'+_0x4b803c[_0xfac5('0x66')][_0x55b423][_0xfac5('0x69')]:'');}return _0x323c5c+')';};var _0xe3ed88={'where':{'id':_0x1e65c4['id']}},_0x5d5aa0,_0x48b61b,_0x2d3238,_0x527ca7,_0xab79d1;_0xe3ed88=_[_0xfac5('0x3c')]({},_0xe3ed88,_0x30f840);return db['AnalyticDefaultReport'][_0xfac5('0x4a')](_0xe3ed88)[_0xfac5('0x21')](function(_0x96e589){if(_0x96e589){_0x5d5aa0=_0x96e589;return _0x96e589[_0xfac5('0x6a')]();}return null;})['then'](function(_0x363348){if(_0x363348){if(!_0x363348[_0xfac5('0x33')]){throw new db[(_0xfac5('0x8d'))]['ValidationErrorItem'](_0xfac5('0x6c'),0x193);}_0x48b61b=_0x363348;return db[_0xfac5('0x6d')][_0xfac5('0x46')]({'raw':!![]});}return null;})[_0xfac5('0x21')](function(_0x2641ae){if(_0x2641ae){_0x2d3238=_['keyBy'](_0x2641ae,'id');var _0x1f7aee;var _0x259894=squel['select']();_0x259894['from'](_0x5d5aa0['table']);for(var _0x1905bf=0x0;_0x1905bf<_0x48b61b[_0xfac5('0x33')];_0x1905bf+=0x1){_0x1f7aee=_0x48b61b[_0x1905bf]['MetricId']?_0x2d3238[_0x48b61b[_0x1905bf][_0xfac5('0x71')]][_0xfac5('0x8e')]:_0x48b61b[_0x1905bf]['field'];_0x1f7aee=_0x48b61b[_0x1905bf][_0xfac5('0x72')]?_[_0xfac5('0x74')](_0x53fd2d[_0x48b61b[_0x1905bf][_0xfac5('0x72')]],'%s',_0x1f7aee):_0x1f7aee;_0x1f7aee=_0x48b61b[_0x1905bf][_0xfac5('0x73')]?_[_0xfac5('0x74')](_0x262038[_0x48b61b[_0x1905bf][_0xfac5('0x73')]],'%s',_0x1f7aee):_0x1f7aee;if(_0x48b61b[_0x1905bf]['groupBy']){_0x259894[_0xfac5('0x68')](_0x1f7aee);}_0x48b61b[_0x1905bf][_0xfac5('0x76')]&&_0x259894[_0xfac5('0x36')](_0x1f7aee,_0x48b61b[_0x1905bf][_0xfac5('0x76')]===_0xfac5('0x77')?![]:!![]);_0x259894[_0xfac5('0x41')](_0x1f7aee,_0x48b61b[_0x1905bf][_0xfac5('0x78')]||_0x1f7aee);}if(_0x5d5aa0['joins']){_0x5d5aa0[_0xfac5('0x79')]=JSON[_0xfac5('0x7a')](_0x5d5aa0[_0xfac5('0x79')]);for(var _0x5ce79b=0x0;_0x5ce79b<_0x5d5aa0[_0xfac5('0x79')][_0xfac5('0x33')];_0x5ce79b+=0x1){if(_0x5d5aa0[_0xfac5('0x79')][_0x5ce79b][_0xfac5('0x3e')]&&_[_0xfac5('0x63')](_0x9d05c6,_0x5d5aa0[_0xfac5('0x79')][_0x5ce79b][_0xfac5('0x3e')])&&_0x5d5aa0['joins'][_0x5ce79b][_0xfac5('0x7b')]&&_0x5d5aa0[_0xfac5('0x79')][_0x5ce79b][_0xfac5('0x7c')]&&_0x5d5aa0[_0xfac5('0x79')][_0x5ce79b][_0xfac5('0x7d')]){_0x259894[_0x5d5aa0['joins'][_0x5ce79b][_0xfac5('0x3e')]](_0x5d5aa0[_0xfac5('0x79')][_0x5ce79b]['foreignTable'],null,util[_0xfac5('0x73')](_0xfac5('0x7e'),_0x5d5aa0['table'],_0x5d5aa0[_0xfac5('0x79')][_0x5ce79b][_0xfac5('0x7b')],_0x5d5aa0['joins'][_0x5ce79b][_0xfac5('0x7c')],_0x5d5aa0['joins'][_0x5ce79b]['foreignKey']));}}}if(_0x5d5aa0[_0xfac5('0x80')]){_0x5d5aa0[_0xfac5('0x80')]=JSON[_0xfac5('0x7a')](_0x5d5aa0[_0xfac5('0x80')]);_0x259894[_0xfac5('0x38')](_0x54b499(_0x5d5aa0[_0xfac5('0x80')][_0xfac5('0x68')]));}_0xab79d1=_0x259894[_0xfac5('0x81')]();_0x259894[_0xfac5('0x1c')](_0x148f08);_0x259894['offset'](0x0);logger[_0xfac5('0x82')]('Limited\x20Query:',_0x259894['toString']());return db[_0xfac5('0x85')][_0xfac5('0x2f')](_0x259894[_0xfac5('0x84')](),{'type':db[_0xfac5('0x85')][_0xfac5('0x86')][_0xfac5('0x87')]});}})['then'](function(_0x25b5e8){if(!_0x25b5e8[_0xfac5('0x33')]){throw new db[(_0xfac5('0x8d'))]['ValidationErrorItem']('No\x20available\x20data',0xcc);}if(_0x170808[_0xfac5('0x8f')]===_0xfac5('0x90')){return null;}var _0x1c89f2=_['merge'](_0x170808,{'name':_0x170808[_0xfac5('0x91')]||_0x170808[_0xfac5('0x29')]||_0x5d5aa0[_0xfac5('0x29')],'basename':_0x32a490,'savename':util[_0xfac5('0x73')](_0xfac5('0x92'),_0x170808[_0xfac5('0x29')]||_0x5d5aa0['name'],require(_0xfac5('0x93'))[_0xfac5('0x94')](0x4),_0x170808[_0xfac5('0x8f')]||_0xfac5('0x95')),'reportId':_0x5d5aa0['id'],'reportType':_0xfac5('0x96')});return db['AnalyticExtractedReport'][_0xfac5('0x4c')](_0x1c89f2,{'raw':!![]});})['then'](function(_0x112a79){if(_0x5d5aa0[_0xfac5('0x7f')]===_0xfac5('0x97')){_0xab79d1['where'](_0x5d5aa0[_0xfac5('0x7f')]+_0xfac5('0x98'),_0x170808[_0xfac5('0x99')],_0x170808['endDate']);}else{_0xab79d1[_0xfac5('0x38')](_0x5d5aa0[_0xfac5('0x7f')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x170808[_0xfac5('0x99')],_0x170808['endDate']);}if(_0x112a79){logger[_0xfac5('0x9a')](_0xfac5('0x9b'),_0xab79d1['toString']());require(_0xfac5('0x9c'))['fork'](path[_0xfac5('0x56')](__dirname,_0xfac5('0x9d'),_0x112a79[_0xfac5('0x8f')]),[_0x112a79['id'],_0xab79d1[_0xfac5('0x84')](),path[_0xfac5('0x56')](__dirname,_0xfac5('0x9e'),_0x112a79[_0xfac5('0x9f')]),_0x32a490]);return _0x112a79;}else{var _0xb63b29=squel[_0xfac5('0x6f')]();_0xb63b29[_0xfac5('0x70')]('('+_0xab79d1['toString']()+')','countTable');_0xb63b29[_0xfac5('0x41')](_0xfac5('0xa0'),_0xfac5('0x43'));_0xab79d1[_0xfac5('0x1c')](_0x170808['limit']||_0x148f08);_0xab79d1['offset'](_0x170808[_0xfac5('0x1b')]||0x0);return db[_0xfac5('0x85')][_0xfac5('0x2f')](_0xb63b29[_0xfac5('0x84')](),{'type':db[_0xfac5('0x85')]['QueryTypes'][_0xfac5('0x87')]})['then'](function(_0x2a9114){if(!_0x2a9114[_0xfac5('0x33')]){_0x527ca7=0x0;}else{_0x527ca7=_0x2a9114[0x0][_0xfac5('0x43')]||0x0;}return db['sequelize'][_0xfac5('0x2f')](_0xab79d1['toString'](),{'type':db[_0xfac5('0x85')][_0xfac5('0x86')][_0xfac5('0x87')]});})[_0xfac5('0x21')](function(_0x39f623){return{'rows':_0x39f623||[],'count':_0x527ca7};});}});}exports[_0xfac5('0xa1')]=function(_0x4f7d7d,_0x205d25){return runReport(_0x4f7d7d[_0xfac5('0x55')],_0x4f7d7d['query'],_0x4f7d7d['options'])['then'](respondWithResult(_0x205d25,null))[_0xfac5('0x4b')](handleError(_0x205d25,null));};exports[_0xfac5('0xa2')]=runReport;exports[_0xfac5('0x2f')]=function(_0x25ae8b,_0x57931c){var _0x40c406=0xa;var _0x3e046a=[_0xfac5('0x56'),_0xfac5('0x88'),_0xfac5('0x57'),_0xfac5('0x58')];var _0x7412e7={'SUM':_0xfac5('0x59'),'COUNT':_0xfac5('0x5a'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':'MAX(%s)','MIN':_0xfac5('0x5d'),'AVG':_0xfac5('0x5e'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x38183c={'SEC_TO_TIME':_0xfac5('0x8a'),'DATE':_0xfac5('0x60'),'HOUR':'HOUR(%s)','ROUND':_0xfac5('0x61'),'UNIX_TIMESTAMP':_0xfac5('0x62')};var _0x2ee78a=function(_0x31754a){return!_['includes']([_0xfac5('0x64'),_0xfac5('0x65'),'IS\x20EMPTY',_0xfac5('0xa3')],_0x31754a);};var _0x2311c0=function(_0x3c324f){if(!_0x3c324f||!_0x3c324f[_0xfac5('0x66')]['length']){return'';}for(var _0x339ccb='(',_0x15cd43=0x0;_0x15cd43<_0x3c324f[_0xfac5('0x66')][_0xfac5('0x33')];_0x15cd43+=0x1){_0x15cd43>0x0&&(_0x339ccb+='\x20'+_0x3c324f[_0xfac5('0x67')]+'\x20');_0x339ccb+=_0x3c324f[_0xfac5('0x66')][_0x15cd43]['group']?_0x2311c0(_0x3c324f[_0xfac5('0x66')][_0x15cd43][_0xfac5('0x68')]):_0x3c324f[_0xfac5('0x66')][_0x15cd43][_0xfac5('0x41')]+'\x20'+_0x3c324f[_0xfac5('0x66')][_0x15cd43]['condition']+(_0x2ee78a(_0x3c324f[_0xfac5('0x66')][_0x15cd43]['condition'])?'\x20'+_0x3c324f[_0xfac5('0x66')][_0x15cd43]['value']:'');}return _0x339ccb+')';};var _0x28a24f={'where':{'id':_0x25ae8b['params']['id']}},_0x4ea074,_0x1fcb8e,_0x10746a,_0x377580,_0x3c7260;_0x28a24f=_['merge']({},_0x28a24f,_0x25ae8b['options']);return db[_0xfac5('0x2c')][_0xfac5('0x4a')](_0x28a24f)[_0xfac5('0x21')](function(_0x2cd1bd){if(_0x2cd1bd){_0x4ea074=_0x2cd1bd;return _0x2cd1bd[_0xfac5('0x6a')]();}return null;})[_0xfac5('0x21')](function(_0x2c96ec){if(_0x2c96ec){if(!_0x2c96ec[_0xfac5('0x33')]){throw new db[(_0xfac5('0x8d'))][(_0xfac5('0x6b'))](_0xfac5('0x6c'),0x193);}_0x1fcb8e=_0x2c96ec;return db[_0xfac5('0x6d')][_0xfac5('0x46')]({'raw':!![]});}return null;})[_0xfac5('0x21')](function(_0xb6c7b0){if(_0xb6c7b0){_0x10746a=_[_0xfac5('0x6e')](_0xb6c7b0,'id');var _0xa3e87;var _0x424a42=squel['select']();_0x424a42[_0xfac5('0x70')](_0x4ea074[_0xfac5('0x7f')]);for(var _0x4ee629=0x0;_0x4ee629<_0x1fcb8e[_0xfac5('0x33')];_0x4ee629+=0x1){_0xa3e87=_0x1fcb8e[_0x4ee629][_0xfac5('0x71')]?_0x10746a[_0x1fcb8e[_0x4ee629][_0xfac5('0x71')]][_0xfac5('0x8e')]:_0x1fcb8e[_0x4ee629][_0xfac5('0x41')];_0xa3e87=_0x1fcb8e[_0x4ee629][_0xfac5('0x72')]?_['replace'](_0x7412e7[_0x1fcb8e[_0x4ee629][_0xfac5('0x72')]],'%s',_0xa3e87):_0xa3e87;_0xa3e87=_0x1fcb8e[_0x4ee629][_0xfac5('0x73')]?_[_0xfac5('0x74')](_0x38183c[_0x1fcb8e[_0x4ee629][_0xfac5('0x73')]],'%s',_0xa3e87):_0xa3e87;if(_0x1fcb8e[_0x4ee629][_0xfac5('0x75')]){_0x424a42[_0xfac5('0x68')](_0xa3e87);}_0x1fcb8e[_0x4ee629]['orderBy']&&_0x424a42['order'](_0xa3e87,_0x1fcb8e[_0x4ee629][_0xfac5('0x76')]===_0xfac5('0x77')?![]:!![]);_0x424a42[_0xfac5('0x41')](_0xa3e87,_0x1fcb8e[_0x4ee629][_0xfac5('0x78')]||_0xa3e87);}if(_0x4ea074['joins']){_0x4ea074[_0xfac5('0x79')]=JSON[_0xfac5('0x7a')](_0x4ea074[_0xfac5('0x79')]);for(var _0x116afc=0x0;_0x116afc<_0x4ea074[_0xfac5('0x79')]['length'];_0x116afc+=0x1){if(_0x4ea074[_0xfac5('0x79')][_0x116afc][_0xfac5('0x3e')]&&_[_0xfac5('0x63')](_0x3e046a,_0x4ea074[_0xfac5('0x79')][_0x116afc][_0xfac5('0x3e')])&&_0x4ea074[_0xfac5('0x79')][_0x116afc][_0xfac5('0x7b')]&&_0x4ea074[_0xfac5('0x79')][_0x116afc][_0xfac5('0x7c')]&&_0x4ea074[_0xfac5('0x79')][_0x116afc][_0xfac5('0x7d')]){_0x424a42[_0x4ea074['joins'][_0x116afc][_0xfac5('0x3e')]](_0x4ea074[_0xfac5('0x79')][_0x116afc][_0xfac5('0x7c')],null,util['format'](_0xfac5('0x7e'),_0x4ea074[_0xfac5('0x7f')],_0x4ea074[_0xfac5('0x79')][_0x116afc][_0xfac5('0x7b')],_0x4ea074['joins'][_0x116afc][_0xfac5('0x7c')],_0x4ea074['joins'][_0x116afc][_0xfac5('0x7d')]));}}}if(_0x4ea074['conditions']){_0x4ea074[_0xfac5('0x80')]=JSON[_0xfac5('0x7a')](_0x4ea074[_0xfac5('0x80')]);_0x424a42[_0xfac5('0x38')](_0x2311c0(_0x4ea074[_0xfac5('0x80')][_0xfac5('0x68')]));}_0x3c7260=_0x424a42['clone']();_0x424a42[_0xfac5('0x1c')](_0x40c406);_0x424a42[_0xfac5('0x1b')](0x0);logger[_0xfac5('0x82')](_0xfac5('0x83'),_0x424a42['toString']());return db[_0xfac5('0x85')][_0xfac5('0x2f')](_0x424a42['toString'](),{'type':db[_0xfac5('0x85')][_0xfac5('0x86')][_0xfac5('0x87')]});}})[_0xfac5('0x21')](function(){return{'sql':_0x3c7260[_0xfac5('0x84')]()};})[_0xfac5('0x21')](respondWithResult(_0x57931c,null))[_0xfac5('0x4b')](handleError(_0x57931c,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff