// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x63ae=['fork','../../components/export/','../../files/reports','savename','runReport','SUM(%s)','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','desk.js','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','dbH','sendStatus','status','end','json','count','offset','limit','set','save','update','destroy','then','UserProfileResource','stack','name','send','index','map','rawAttributes','type','model','query','keys','filters','intersection','attributes','fields','hasOwnProperty','order','pick','filter','merge','where','options','AnalyticCustomReport','includeAll','findAll','rows','catch','show','params','length','include','create','user','get','Reports','UserProfileSection','find','CustomReports','body','preview','join','left_join','right_join','cross_join','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','DATE(%s)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','rules','operator','group','field','condition','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','select','from','table','MetricId','metric','function','format','replace','orderBy','DESC','alias','joins','parse','parentKey','foreignTable','foreignKey','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SEC_TO_TIME(%s)','IS\x20NOT\x20EMPTY','value','groupBy','SELECT','No\x20available\x20data','web','fullPath','%s-%s.%s','randomstring','generate','output','csv','AnalyticExtractedReport','cdr','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','child_process'];(function(_0x323c60,_0x219b72){var _0x103f23=function(_0x7695b3){while(--_0x7695b3){_0x323c60['push'](_0x323c60['shift']());}};_0x103f23(++_0x219b72);}(_0x63ae,0x146));var _0xe63a=function(_0x4cef0a,_0x448b2f){_0x4cef0a=_0x4cef0a-0x0;var _0x1a1b6a=_0x63ae[_0x4cef0a];return _0x1a1b6a;};'use strict';var pdf=require(_0xe63a('0x0'));var emlformat=require(_0xe63a('0x1'));var rimraf=require(_0xe63a('0x2'));var zipdir=require(_0xe63a('0x3'));var jsonpatch=require(_0xe63a('0x4'));var rp=require(_0xe63a('0x5'));var moment=require(_0xe63a('0x6'));var BPromise=require(_0xe63a('0x7'));var Mustache=require(_0xe63a('0x8'));var util=require(_0xe63a('0x9'));var path=require(_0xe63a('0xa'));var sox=require(_0xe63a('0xb'));var csv=require(_0xe63a('0xc'));var ejs=require(_0xe63a('0xd'));var fs=require('fs');var _=require(_0xe63a('0xe'));var squel=require(_0xe63a('0xf'));var crypto=require(_0xe63a('0x10'));var jsforce=require('jsforce');var deskjs=require(_0xe63a('0x11'));var toCsv=require(_0xe63a('0xc'));var querystring=require('querystring');var Papa=require(_0xe63a('0x12'));var Redis=require(_0xe63a('0x13'));var authService=require('../../components/auth/service');var qs=require(_0xe63a('0x14'));var as=require(_0xe63a('0x15'));var hardwareService=require(_0xe63a('0x16'));var logger=require('../../config/logger')(_0xe63a('0x17'));var utils=require(_0xe63a('0x18'));var config=require(_0xe63a('0x19'));var licenseUtil=require(_0xe63a('0x1a'));var db=require(_0xe63a('0x1b'))['db'];var dbH=require(_0xe63a('0x1b'))[_0xe63a('0x1c')];function respondWithStatusCode(_0x48ad1f,_0x299659){_0x299659=_0x299659||0xcc;return function(_0x2f5fa8){if(_0x2f5fa8){return _0x48ad1f[_0xe63a('0x1d')](_0x299659);}return _0x48ad1f[_0xe63a('0x1e')](_0x299659)[_0xe63a('0x1f')]();};}function respondWithResult(_0x440b83,_0x53712a){_0x53712a=_0x53712a||0xc8;return function(_0x4db36d){if(_0x4db36d){return _0x440b83[_0xe63a('0x1e')](_0x53712a)[_0xe63a('0x20')](_0x4db36d);}};}function respondWithFilteredResult(_0xd7bd5e,_0x5cc3f2){return function(_0x58f3d7){if(_0x58f3d7){var _0x3e4c04=_0x58f3d7[_0xe63a('0x21')],_0x21f78f=_0x5cc3f2['offset'],_0x472017=_0x5cc3f2[_0xe63a('0x22')]+_0x5cc3f2[_0xe63a('0x23')],_0x38fe5d;if(_0x472017>=_0x3e4c04){_0x472017=_0x3e4c04;_0x38fe5d=0xc8;}else{_0x38fe5d=0xce;}_0xd7bd5e['status'](_0x38fe5d);return _0xd7bd5e[_0xe63a('0x24')]('Content-Range',_0x21f78f+'-'+_0x472017+'/'+_0x3e4c04)[_0xe63a('0x20')](_0x58f3d7);}return null;};}function patchUpdates(_0x1e5c67){return function(_0x51ad1f){try{jsonpatch['apply'](_0x51ad1f,_0x1e5c67,!![]);}catch(_0x301ad7){return BPromise['reject'](_0x301ad7);}return _0x51ad1f[_0xe63a('0x25')]();};}function saveUpdates(_0x166479,_0x3191ac){return function(_0xdc130e){if(_0xdc130e){return _0xdc130e[_0xe63a('0x26')](_0x166479)['then'](function(_0x2f3ab3){return _0x2f3ab3;});}return null;};}function removeEntity(_0x2fd353,_0x4315e2){return function(_0x5b7952){if(_0x5b7952){return _0x5b7952[_0xe63a('0x27')]()[_0xe63a('0x28')](function(){var _0x134b42=_0x5b7952['get']({'plain':!![]});var _0x4bda3e='CustomReports';return db[_0xe63a('0x29')][_0xe63a('0x27')]({'where':{'type':_0x4bda3e,'resourceId':_0x134b42['id']}})[_0xe63a('0x28')](function(){return _0x5b7952;});})[_0xe63a('0x28')](function(){_0x2fd353['status'](0xcc)[_0xe63a('0x1f')]();});}};}function handleEntityNotFound(_0x2e241f,_0x2512c9){return function(_0x3693fc){if(!_0x3693fc){_0x2e241f[_0xe63a('0x1d')](0x194);}return _0x3693fc;};}function handleError(_0x5f59e1,_0x2e254a){_0x2e254a=_0x2e254a||0x1f4;return function(_0x2cab66){logger['error'](_0x2cab66[_0xe63a('0x2a')]);if(_0x2cab66[_0xe63a('0x2b')]){delete _0x2cab66[_0xe63a('0x2b')];}_0x5f59e1['status'](_0x2e254a)[_0xe63a('0x2c')](_0x2cab66);};}exports[_0xe63a('0x2d')]=function(_0x14bb31,_0x2d4691){var _0x397371={},_0x33b450={},_0x4d134b={'count':0x0,'rows':[]};var _0x2e520e=_[_0xe63a('0x2e')](db['AnalyticCustomReport'][_0xe63a('0x2f')],function(_0x4a093b){return{'name':_0x4a093b['fieldName'],'type':_0x4a093b[_0xe63a('0x30')]['key']};});_0x33b450[_0xe63a('0x31')]=_[_0xe63a('0x2e')](_0x2e520e,_0xe63a('0x2b'));_0x33b450[_0xe63a('0x32')]=_[_0xe63a('0x33')](_0x14bb31[_0xe63a('0x32')]);_0x33b450[_0xe63a('0x34')]=_[_0xe63a('0x35')](_0x33b450[_0xe63a('0x31')],_0x33b450[_0xe63a('0x32')]);_0x397371[_0xe63a('0x36')]=_[_0xe63a('0x35')](_0x33b450[_0xe63a('0x31')],qs['fields'](_0x14bb31[_0xe63a('0x32')][_0xe63a('0x37')]));_0x397371[_0xe63a('0x36')]=_0x397371[_0xe63a('0x36')]['length']?_0x397371[_0xe63a('0x36')]:_0x33b450[_0xe63a('0x31')];if(!_0x14bb31[_0xe63a('0x32')][_0xe63a('0x38')]('nolimit')){_0x397371[_0xe63a('0x23')]=qs[_0xe63a('0x23')](_0x14bb31['query'][_0xe63a('0x23')]);_0x397371[_0xe63a('0x22')]=qs[_0xe63a('0x22')](_0x14bb31[_0xe63a('0x32')][_0xe63a('0x22')]);}_0x397371[_0xe63a('0x39')]=qs['sort'](_0x14bb31[_0xe63a('0x32')]['sort']);_0x397371['where']=qs[_0xe63a('0x34')](_[_0xe63a('0x3a')](_0x14bb31[_0xe63a('0x32')],_0x33b450['filters']),_0x2e520e);if(_0x14bb31['query'][_0xe63a('0x3b')]){_0x397371['where']=_[_0xe63a('0x3c')](_0x397371[_0xe63a('0x3d')],{'$or':_['map'](_0x2e520e,function(_0x462545){if(_0x462545['type']!=='VIRTUAL'){var _0x3220bc={};_0x3220bc[_0x462545[_0xe63a('0x2b')]]={'$like':'%'+_0x14bb31[_0xe63a('0x32')]['filter']+'%'};return _0x3220bc;}})});}_0x397371=_[_0xe63a('0x3c')]({},_0x397371,_0x14bb31[_0xe63a('0x3e')]);var _0x18b300={'where':_0x397371[_0xe63a('0x3d')]};return db[_0xe63a('0x3f')][_0xe63a('0x21')](_0x18b300)[_0xe63a('0x28')](function(_0x451f5d){_0x4d134b[_0xe63a('0x21')]=_0x451f5d;if(_0x14bb31[_0xe63a('0x32')][_0xe63a('0x40')]){_0x397371['include']=[{'all':!![]}];}return db[_0xe63a('0x3f')][_0xe63a('0x41')](_0x397371);})['then'](function(_0xac7051){_0x4d134b[_0xe63a('0x42')]=_0xac7051;return _0x4d134b;})[_0xe63a('0x28')](respondWithFilteredResult(_0x2d4691,_0x397371))[_0xe63a('0x43')](handleError(_0x2d4691,null));};exports[_0xe63a('0x44')]=function(_0x19b9e3,_0x502836){var _0x2c125c={'raw':![],'where':{'id':_0x19b9e3[_0xe63a('0x45')]['id']}},_0x4a0399={};_0x4a0399[_0xe63a('0x31')]=_[_0xe63a('0x33')](db[_0xe63a('0x3f')][_0xe63a('0x2f')]);_0x4a0399['query']=_[_0xe63a('0x33')](_0x19b9e3[_0xe63a('0x32')]);_0x4a0399[_0xe63a('0x34')]=_[_0xe63a('0x35')](_0x4a0399[_0xe63a('0x31')],_0x4a0399[_0xe63a('0x32')]);_0x2c125c[_0xe63a('0x36')]=_['intersection'](_0x4a0399[_0xe63a('0x31')],qs[_0xe63a('0x37')](_0x19b9e3[_0xe63a('0x32')][_0xe63a('0x37')]));_0x2c125c[_0xe63a('0x36')]=_0x2c125c[_0xe63a('0x36')][_0xe63a('0x46')]?_0x2c125c[_0xe63a('0x36')]:_0x4a0399[_0xe63a('0x31')];if(_0x19b9e3['query'][_0xe63a('0x40')]){_0x2c125c[_0xe63a('0x47')]=[{'all':!![]}];}_0x2c125c=_[_0xe63a('0x3c')]({},_0x2c125c,_0x19b9e3[_0xe63a('0x3e')]);return db['AnalyticCustomReport']['find'](_0x2c125c)[_0xe63a('0x28')](handleEntityNotFound(_0x502836,null))[_0xe63a('0x28')](respondWithResult(_0x502836,null))[_0xe63a('0x43')](handleError(_0x502836,null));};exports[_0xe63a('0x48')]=function(_0x16bb78,_0x35f100){return db[_0xe63a('0x3f')][_0xe63a('0x48')](_0x16bb78['body'],{})['then'](function(_0x1358aa){var _0x1fb652=_0x16bb78[_0xe63a('0x49')][_0xe63a('0x4a')]({'plain':!![]});if(!_0x1fb652)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x1fb652['role']===_0xe63a('0x49')){var _0x1175bb=_0x1358aa[_0xe63a('0x4a')]({'plain':!![]});var _0x23bd4b=_0xe63a('0x4b');return db[_0xe63a('0x4c')][_0xe63a('0x4d')]({'where':{'name':_0x23bd4b,'userProfileId':_0x1fb652['userProfileId']},'raw':!![]})[_0xe63a('0x28')](function(_0x1d204b){if(_0x1d204b&&_0x1d204b['autoAssociation']===0x0){return db[_0xe63a('0x29')][_0xe63a('0x48')]({'name':_0x1175bb['name'],'resourceId':_0x1175bb['id'],'type':_0xe63a('0x4e'),'sectionId':_0x1d204b['id']},{})[_0xe63a('0x28')](function(){return _0x1358aa;});}else{return _0x1358aa;}})[_0xe63a('0x43')](function(_0x8bac1d){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x8bac1d);throw _0x8bac1d;});}return _0x1358aa;})['then'](respondWithResult(_0x35f100,0xc9))[_0xe63a('0x43')](handleError(_0x35f100,null));};exports[_0xe63a('0x26')]=function(_0x25a5bb,_0xe9d0b6){if(_0x25a5bb[_0xe63a('0x4f')]['id']){delete _0x25a5bb[_0xe63a('0x4f')]['id'];}return db[_0xe63a('0x3f')][_0xe63a('0x4d')]({'where':{'id':_0x25a5bb[_0xe63a('0x45')]['id']}})['then'](handleEntityNotFound(_0xe9d0b6,null))[_0xe63a('0x28')](saveUpdates(_0x25a5bb[_0xe63a('0x4f')],null))[_0xe63a('0x28')](respondWithResult(_0xe9d0b6,null))[_0xe63a('0x43')](handleError(_0xe9d0b6,null));};exports[_0xe63a('0x27')]=function(_0x2bb746,_0x1b3335){return db[_0xe63a('0x3f')][_0xe63a('0x4d')]({'where':{'id':_0x2bb746[_0xe63a('0x45')]['id']}})[_0xe63a('0x28')](handleEntityNotFound(_0x1b3335,null))[_0xe63a('0x28')](removeEntity(_0x1b3335,null))['catch'](handleError(_0x1b3335,null));};exports[_0xe63a('0x50')]=function(_0x144a0e,_0x5bb0bd){var _0x1070aa=0xa;var _0x4fd8a0=[_0xe63a('0x51'),_0xe63a('0x52'),_0xe63a('0x53'),_0xe63a('0x54')];var _0xd2e7a3={'SUM':'SUM(%s)','COUNT':_0xe63a('0x55'),'COUNT DISTINCT':_0xe63a('0x56'),'MAX':_0xe63a('0x57'),'MIN':_0xe63a('0x58'),'AVG':_0xe63a('0x59'),'GROUP_CONCAT':_0xe63a('0x5a'),'GROUP_CONCAT ASC':_0xe63a('0x5b'),'GROUP_CONCAT DESC':_0xe63a('0x5c')};var _0x4b01e1={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0xe63a('0x5d'),'HOUR':_0xe63a('0x5e'),'ROUND':_0xe63a('0x5f'),'UNIX_TIMESTAMP':_0xe63a('0x60')};var _0x12775e=function(_0x532c3c){return!_[_0xe63a('0x61')]([_0xe63a('0x62'),_0xe63a('0x63'),_0xe63a('0x64'),'IS\x20NOT\x20EMPTY'],_0x532c3c);};var _0x32fdbb=function(_0x34cfba){if(!_0x34cfba||!_0x34cfba[_0xe63a('0x65')][_0xe63a('0x46')]){return'';}for(var _0x40ec19='(',_0x31024b=0x0;_0x31024b<_0x34cfba[_0xe63a('0x65')][_0xe63a('0x46')];_0x31024b+=0x1){_0x31024b>0x0&&(_0x40ec19+='\x20'+_0x34cfba[_0xe63a('0x66')]+'\x20');_0x40ec19+=_0x34cfba[_0xe63a('0x65')][_0x31024b][_0xe63a('0x67')]?_0x32fdbb(_0x34cfba[_0xe63a('0x65')][_0x31024b][_0xe63a('0x67')]):_0x34cfba['rules'][_0x31024b][_0xe63a('0x68')]+'\x20'+_0x34cfba[_0xe63a('0x65')][_0x31024b][_0xe63a('0x69')]+(_0x12775e(_0x34cfba['rules'][_0x31024b][_0xe63a('0x69')])?'\x20'+_0x34cfba[_0xe63a('0x65')][_0x31024b]['value']:'');}return _0x40ec19+')';};var _0x5e1f62={'where':{'id':_0x144a0e[_0xe63a('0x45')]['id']}},_0x5508e3,_0x1d07c3,_0x4e00ce,_0xb48305,_0x375ca6;_0x5e1f62=_[_0xe63a('0x3c')]({},_0x5e1f62,_0x144a0e[_0xe63a('0x3e')]);return db[_0xe63a('0x3f')]['find'](_0x5e1f62)['then'](function(_0x1888ac){if(_0x1888ac){_0x5508e3=_0x1888ac;return _0x1888ac[_0xe63a('0x6a')]();}return null;})['then'](function(_0x37efd9){if(_0x37efd9){if(!_0x37efd9['length']){throw new db[(_0xe63a('0x6b'))][(_0xe63a('0x6c'))](_0xe63a('0x6d'),0x193);}_0x1d07c3=_0x37efd9;return db[_0xe63a('0x6e')][_0xe63a('0x41')]({'raw':!![]});}return null;})[_0xe63a('0x28')](function(_0x53a6ff){if(_0x53a6ff){_0x4e00ce=_[_0xe63a('0x6f')](_0x53a6ff,'id');var _0x13a4e0;var _0x220ccb=squel[_0xe63a('0x70')]();_0x220ccb[_0xe63a('0x71')](_0x5508e3[_0xe63a('0x72')]);for(var _0x2634d7=0x0;_0x2634d7<_0x1d07c3[_0xe63a('0x46')];_0x2634d7+=0x1){_0x13a4e0=_0x1d07c3[_0x2634d7]['MetricId']?_0x4e00ce[_0x1d07c3[_0x2634d7][_0xe63a('0x73')]][_0xe63a('0x74')]:_0x1d07c3[_0x2634d7][_0xe63a('0x68')];_0x13a4e0=_0x1d07c3[_0x2634d7]['function']?_['replace'](_0xd2e7a3[_0x1d07c3[_0x2634d7][_0xe63a('0x75')]],'%s',_0x13a4e0):_0x13a4e0;_0x13a4e0=_0x1d07c3[_0x2634d7][_0xe63a('0x76')]?_[_0xe63a('0x77')](_0x4b01e1[_0x1d07c3[_0x2634d7][_0xe63a('0x76')]],'%s',_0x13a4e0):_0x13a4e0;if(_0x1d07c3[_0x2634d7]['groupBy']){_0x220ccb[_0xe63a('0x67')](_0x13a4e0);}_0x1d07c3[_0x2634d7][_0xe63a('0x78')]&&_0x220ccb[_0xe63a('0x39')](_0x13a4e0,_0x1d07c3[_0x2634d7][_0xe63a('0x78')]===_0xe63a('0x79')?![]:!![]);_0x220ccb['field'](_0x13a4e0,_0x1d07c3[_0x2634d7][_0xe63a('0x7a')]||_0x13a4e0);}if(_0x5508e3[_0xe63a('0x7b')]){_0x5508e3[_0xe63a('0x7b')]=JSON[_0xe63a('0x7c')](_0x5508e3[_0xe63a('0x7b')]);for(var _0x5a0a96=0x0;_0x5a0a96<_0x5508e3[_0xe63a('0x7b')][_0xe63a('0x46')];_0x5a0a96+=0x1){if(_0x5508e3[_0xe63a('0x7b')][_0x5a0a96][_0xe63a('0x30')]&&_['includes'](_0x4fd8a0,_0x5508e3[_0xe63a('0x7b')][_0x5a0a96]['type'])&&_0x5508e3['joins'][_0x5a0a96][_0xe63a('0x7d')]&&_0x5508e3[_0xe63a('0x7b')][_0x5a0a96][_0xe63a('0x7e')]&&_0x5508e3['joins'][_0x5a0a96]['foreignKey']){_0x220ccb[_0x5508e3['joins'][_0x5a0a96][_0xe63a('0x30')]](_0x5508e3[_0xe63a('0x7b')][_0x5a0a96]['foreignTable'],null,util['format']('%s.%s\x20=\x20%s.%s',_0x5508e3[_0xe63a('0x72')],_0x5508e3[_0xe63a('0x7b')][_0x5a0a96][_0xe63a('0x7d')],_0x5508e3[_0xe63a('0x7b')][_0x5a0a96][_0xe63a('0x7e')],_0x5508e3[_0xe63a('0x7b')][_0x5a0a96][_0xe63a('0x7f')]));}}}if(_0x5508e3[_0xe63a('0x80')]){_0x5508e3[_0xe63a('0x80')]=JSON['parse'](_0x5508e3['conditions']);_0x220ccb[_0xe63a('0x3d')](_0x32fdbb(_0x5508e3[_0xe63a('0x80')][_0xe63a('0x67')]));}_0x375ca6=_0x220ccb[_0xe63a('0x81')]();_0x220ccb['limit'](_0x1070aa);_0x220ccb[_0xe63a('0x22')](0x0);logger[_0xe63a('0x82')](_0xe63a('0x83'),_0x220ccb[_0xe63a('0x84')]());return db['sequelize']['query'](_0x220ccb['toString'](),{'type':db[_0xe63a('0x85')][_0xe63a('0x86')]['SELECT']});}})[_0xe63a('0x28')](respondWithResult(_0x5bb0bd,null))[_0xe63a('0x43')](handleError(_0x5bb0bd,null));};function runReport(_0x5e97d5,_0x5b416c,_0x3f749d){var _0x441f87=_0x5b416c[_0xe63a('0x2b')];var _0x24a7d4=0xa;var _0x2bfdf7=['join',_0xe63a('0x52'),_0xe63a('0x53'),_0xe63a('0x54')];var _0x1d504b={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT DISTINCT':_0xe63a('0x56'),'MAX':_0xe63a('0x57'),'MIN':'MIN(%s)','AVG':_0xe63a('0x59'),'GROUP_CONCAT':_0xe63a('0x5a'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x43e408={'SEC_TO_TIME':_0xe63a('0x87'),'DATE':_0xe63a('0x5d'),'HOUR':_0xe63a('0x5e'),'ROUND':_0xe63a('0x5f'),'UNIX_TIMESTAMP':_0xe63a('0x60')};var _0x27f0d1=function(_0x22f5c3){return!_[_0xe63a('0x61')]([_0xe63a('0x62'),_0xe63a('0x63'),_0xe63a('0x64'),_0xe63a('0x88')],_0x22f5c3);};var _0x3e3cef=function(_0x49b82e){if(!_0x49b82e||!_0x49b82e['rules'][_0xe63a('0x46')]){return'';}for(var _0x340ae2='(',_0x1d0245=0x0;_0x1d0245<_0x49b82e[_0xe63a('0x65')]['length'];_0x1d0245+=0x1){_0x1d0245>0x0&&(_0x340ae2+='\x20'+_0x49b82e[_0xe63a('0x66')]+'\x20');_0x340ae2+=_0x49b82e[_0xe63a('0x65')][_0x1d0245][_0xe63a('0x67')]?_0x3e3cef(_0x49b82e[_0xe63a('0x65')][_0x1d0245]['group']):_0x49b82e[_0xe63a('0x65')][_0x1d0245][_0xe63a('0x68')]+'\x20'+_0x49b82e['rules'][_0x1d0245]['condition']+(_0x27f0d1(_0x49b82e['rules'][_0x1d0245][_0xe63a('0x69')])?'\x20'+_0x49b82e[_0xe63a('0x65')][_0x1d0245][_0xe63a('0x89')]:'');}return _0x340ae2+')';};var _0x54ad34={'where':{'id':_0x5e97d5['id']}},_0x24ee81,_0x2e6027,_0x2d30c4,_0x4dc87c,_0x22ee1b;_0x54ad34=_['merge']({},_0x54ad34,_0x3f749d);return db[_0xe63a('0x3f')][_0xe63a('0x4d')](_0x54ad34)[_0xe63a('0x28')](function(_0x44977e){if(_0x44977e){_0x24ee81=_0x44977e;return _0x44977e[_0xe63a('0x6a')]();}return null;})[_0xe63a('0x28')](function(_0x6890d){if(_0x6890d){if(!_0x6890d[_0xe63a('0x46')]){throw new db[(_0xe63a('0x6b'))]['ValidationErrorItem'](_0xe63a('0x6d'),0x193);}_0x2e6027=_0x6890d;return db['AnalyticMetric'][_0xe63a('0x41')]({'raw':!![]});}return null;})[_0xe63a('0x28')](function(_0x1f529e){if(_0x1f529e){_0x2d30c4=_[_0xe63a('0x6f')](_0x1f529e,'id');var _0x4bfd14;var _0x295ec5=squel[_0xe63a('0x70')]();_0x295ec5[_0xe63a('0x71')](_0x24ee81[_0xe63a('0x72')]);for(var _0x501d29=0x0;_0x501d29<_0x2e6027[_0xe63a('0x46')];_0x501d29+=0x1){_0x4bfd14=_0x2e6027[_0x501d29]['MetricId']?_0x2d30c4[_0x2e6027[_0x501d29][_0xe63a('0x73')]][_0xe63a('0x74')]:_0x2e6027[_0x501d29]['field'];_0x4bfd14=_0x2e6027[_0x501d29][_0xe63a('0x75')]?_[_0xe63a('0x77')](_0x1d504b[_0x2e6027[_0x501d29][_0xe63a('0x75')]],'%s',_0x4bfd14):_0x4bfd14;_0x4bfd14=_0x2e6027[_0x501d29][_0xe63a('0x76')]?_[_0xe63a('0x77')](_0x43e408[_0x2e6027[_0x501d29]['format']],'%s',_0x4bfd14):_0x4bfd14;if(_0x2e6027[_0x501d29][_0xe63a('0x8a')]){_0x295ec5[_0xe63a('0x67')](_0x4bfd14);}_0x2e6027[_0x501d29][_0xe63a('0x78')]&&_0x295ec5['order'](_0x4bfd14,_0x2e6027[_0x501d29][_0xe63a('0x78')]===_0xe63a('0x79')?![]:!![]);_0x295ec5['field'](_0x4bfd14,_0x2e6027[_0x501d29][_0xe63a('0x7a')]||_0x4bfd14);}if(_0x24ee81[_0xe63a('0x7b')]){_0x24ee81['joins']=JSON['parse'](_0x24ee81[_0xe63a('0x7b')]);for(var _0x583392=0x0;_0x583392<_0x24ee81[_0xe63a('0x7b')]['length'];_0x583392+=0x1){if(_0x24ee81[_0xe63a('0x7b')][_0x583392][_0xe63a('0x30')]&&_['includes'](_0x2bfdf7,_0x24ee81[_0xe63a('0x7b')][_0x583392][_0xe63a('0x30')])&&_0x24ee81['joins'][_0x583392][_0xe63a('0x7d')]&&_0x24ee81[_0xe63a('0x7b')][_0x583392][_0xe63a('0x7e')]&&_0x24ee81['joins'][_0x583392][_0xe63a('0x7f')]){_0x295ec5[_0x24ee81[_0xe63a('0x7b')][_0x583392]['type']](_0x24ee81[_0xe63a('0x7b')][_0x583392]['foreignTable'],null,util[_0xe63a('0x76')]('%s.%s\x20=\x20%s.%s',_0x24ee81['table'],_0x24ee81[_0xe63a('0x7b')][_0x583392]['parentKey'],_0x24ee81[_0xe63a('0x7b')][_0x583392][_0xe63a('0x7e')],_0x24ee81[_0xe63a('0x7b')][_0x583392][_0xe63a('0x7f')]));}}}if(_0x24ee81[_0xe63a('0x80')]){_0x24ee81[_0xe63a('0x80')]=JSON[_0xe63a('0x7c')](_0x24ee81[_0xe63a('0x80')]);_0x295ec5[_0xe63a('0x3d')](_0x3e3cef(_0x24ee81['conditions'][_0xe63a('0x67')]));}_0x22ee1b=_0x295ec5['clone']();_0x295ec5[_0xe63a('0x23')](_0x24a7d4);_0x295ec5['offset'](0x0);logger[_0xe63a('0x82')](_0xe63a('0x83'),_0x295ec5[_0xe63a('0x84')]());return db[_0xe63a('0x85')]['query'](_0x295ec5['toString'](),{'type':db['sequelize'][_0xe63a('0x86')][_0xe63a('0x8b')]});}})[_0xe63a('0x28')](function(_0xdeca80){if(!_0xdeca80[_0xe63a('0x46')]){throw new db[(_0xe63a('0x6b'))][(_0xe63a('0x6c'))](_0xe63a('0x8c'),0xcc);}if(_0x5b416c['output']===_0xe63a('0x8d')){return null;}var _0x2dfc45=_[_0xe63a('0x3c')](_0x5b416c,{'name':_0x5b416c[_0xe63a('0x8e')]||_0x5b416c[_0xe63a('0x2b')]||_0x24ee81[_0xe63a('0x2b')],'basename':_0x441f87,'savename':util[_0xe63a('0x76')](_0xe63a('0x8f'),_0x5b416c[_0xe63a('0x2b')]||_0x24ee81[_0xe63a('0x2b')],require(_0xe63a('0x90'))[_0xe63a('0x91')](0x4),_0x5b416c[_0xe63a('0x92')]||_0xe63a('0x93')),'reportId':_0x24ee81['id'],'reportType':'custom'});return db[_0xe63a('0x94')]['create'](_0x2dfc45,{'raw':!![]});})[_0xe63a('0x28')](function(_0x2378ce){if(_0x24ee81['table']===_0xe63a('0x95')){_0x22ee1b[_0xe63a('0x3d')](_0x24ee81[_0xe63a('0x72')]+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x5b416c[_0xe63a('0x96')],_0x5b416c[_0xe63a('0x97')]);}else{_0x22ee1b[_0xe63a('0x3d')](_0x24ee81[_0xe63a('0x72')]+_0xe63a('0x98'),_0x5b416c[_0xe63a('0x96')],_0x5b416c[_0xe63a('0x97')]);}if(_0x2378ce){logger['info']('Run\x20Query:',_0x22ee1b['toString']());require(_0xe63a('0x99'))[_0xe63a('0x9a')](path[_0xe63a('0x51')](__dirname,_0xe63a('0x9b'),_0x2378ce[_0xe63a('0x92')]),[_0x2378ce['id'],_0x22ee1b[_0xe63a('0x84')](),path['join'](__dirname,_0xe63a('0x9c'),_0x2378ce[_0xe63a('0x9d')]),_0x441f87]);return _0x2378ce;}else{var _0x35339b=squel['select']();_0x35339b[_0xe63a('0x71')]('('+_0x22ee1b['toString']()+')','countTable');_0x35339b['field']('COUNT(*)',_0xe63a('0x21'));_0x22ee1b[_0xe63a('0x23')](_0x5b416c[_0xe63a('0x23')]||_0x24a7d4);_0x22ee1b[_0xe63a('0x22')](_0x5b416c[_0xe63a('0x22')]||0x0);return dbH['sequelize'][_0xe63a('0x32')](_0x35339b[_0xe63a('0x84')](),{'type':dbH[_0xe63a('0x85')][_0xe63a('0x86')]['SELECT']})[_0xe63a('0x28')](function(_0x224437){if(!_0x224437[_0xe63a('0x46')]){_0x4dc87c=0x0;}else{_0x4dc87c=_0x224437[0x0][_0xe63a('0x21')]||0x0;}return dbH[_0xe63a('0x85')]['query'](_0x22ee1b[_0xe63a('0x84')](),{'type':dbH[_0xe63a('0x85')]['QueryTypes'][_0xe63a('0x8b')]});})[_0xe63a('0x28')](function(_0x12396e){return{'rows':_0x12396e||[],'count':_0x4dc87c};});}});}exports['run']=function(_0x1c8e87,_0x331d84){return runReport(_0x1c8e87[_0xe63a('0x45')],_0x1c8e87['query'],_0x1c8e87[_0xe63a('0x3e')])[_0xe63a('0x28')](respondWithResult(_0x331d84,null))[_0xe63a('0x43')](handleError(_0x331d84,null));};exports[_0xe63a('0x9e')]=runReport;exports[_0xe63a('0x32')]=function(_0x38cb60,_0x28cc16){var _0x14b040=0xa;var _0x5f3004=['join',_0xe63a('0x52'),'right_join',_0xe63a('0x54')];var _0x30dd2f={'SUM':_0xe63a('0x9f'),'COUNT':_0xe63a('0x55'),'COUNT DISTINCT':_0xe63a('0x56'),'MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':'AVG(%s)','GROUP_CONCAT':_0xe63a('0x5a'),'GROUP_CONCAT ASC':_0xe63a('0x5b'),'GROUP_CONCAT DESC':_0xe63a('0x5c')};var _0x294b18={'SEC_TO_TIME':_0xe63a('0x87'),'DATE':_0xe63a('0x5d'),'HOUR':_0xe63a('0x5e'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x39575d=function(_0xab319b){return!_[_0xe63a('0x61')]([_0xe63a('0x62'),_0xe63a('0x63'),'IS\x20EMPTY','IS\x20NOT\x20EMPTY'],_0xab319b);};var _0x1cee74=function(_0x4ee96f){if(!_0x4ee96f||!_0x4ee96f[_0xe63a('0x65')][_0xe63a('0x46')]){return'';}for(var _0x4c732d='(',_0x8a0502=0x0;_0x8a0502<_0x4ee96f[_0xe63a('0x65')][_0xe63a('0x46')];_0x8a0502+=0x1){_0x8a0502>0x0&&(_0x4c732d+='\x20'+_0x4ee96f[_0xe63a('0x66')]+'\x20');_0x4c732d+=_0x4ee96f['rules'][_0x8a0502][_0xe63a('0x67')]?_0x1cee74(_0x4ee96f[_0xe63a('0x65')][_0x8a0502]['group']):_0x4ee96f[_0xe63a('0x65')][_0x8a0502][_0xe63a('0x68')]+'\x20'+_0x4ee96f['rules'][_0x8a0502][_0xe63a('0x69')]+(_0x39575d(_0x4ee96f[_0xe63a('0x65')][_0x8a0502][_0xe63a('0x69')])?'\x20'+_0x4ee96f[_0xe63a('0x65')][_0x8a0502][_0xe63a('0x89')]:'');}return _0x4c732d+')';};var _0x5ee453={'where':{'id':_0x38cb60[_0xe63a('0x45')]['id']}},_0x3ac0b7,_0x3b3634,_0x29e45a,_0x22dde4,_0x10410e;_0x5ee453=_[_0xe63a('0x3c')]({},_0x5ee453,_0x38cb60['options']);return db['AnalyticCustomReport'][_0xe63a('0x4d')](_0x5ee453)[_0xe63a('0x28')](function(_0x4d8c24){if(_0x4d8c24){_0x3ac0b7=_0x4d8c24;return _0x4d8c24[_0xe63a('0x6a')]();}return null;})[_0xe63a('0x28')](function(_0x2ffd29){if(_0x2ffd29){if(!_0x2ffd29[_0xe63a('0x46')]){throw new db['Sequelize'][(_0xe63a('0x6c'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x3b3634=_0x2ffd29;return db[_0xe63a('0x6e')][_0xe63a('0x41')]({'raw':!![]});}return null;})[_0xe63a('0x28')](function(_0x3f279c){if(_0x3f279c){_0x29e45a=_[_0xe63a('0x6f')](_0x3f279c,'id');var _0x5802c0;var _0xa344c8=squel[_0xe63a('0x70')]();_0xa344c8[_0xe63a('0x71')](_0x3ac0b7[_0xe63a('0x72')]);for(var _0x20d6d6=0x0;_0x20d6d6<_0x3b3634[_0xe63a('0x46')];_0x20d6d6+=0x1){_0x5802c0=_0x3b3634[_0x20d6d6][_0xe63a('0x73')]?_0x29e45a[_0x3b3634[_0x20d6d6]['MetricId']][_0xe63a('0x74')]:_0x3b3634[_0x20d6d6][_0xe63a('0x68')];_0x5802c0=_0x3b3634[_0x20d6d6][_0xe63a('0x75')]?_['replace'](_0x30dd2f[_0x3b3634[_0x20d6d6][_0xe63a('0x75')]],'%s',_0x5802c0):_0x5802c0;_0x5802c0=_0x3b3634[_0x20d6d6]['format']?_[_0xe63a('0x77')](_0x294b18[_0x3b3634[_0x20d6d6][_0xe63a('0x76')]],'%s',_0x5802c0):_0x5802c0;if(_0x3b3634[_0x20d6d6][_0xe63a('0x8a')]){_0xa344c8[_0xe63a('0x67')](_0x5802c0);}_0x3b3634[_0x20d6d6][_0xe63a('0x78')]&&_0xa344c8['order'](_0x5802c0,_0x3b3634[_0x20d6d6][_0xe63a('0x78')]===_0xe63a('0x79')?![]:!![]);_0xa344c8[_0xe63a('0x68')](_0x5802c0,_0x3b3634[_0x20d6d6]['alias']||_0x5802c0);}if(_0x3ac0b7[_0xe63a('0x7b')]){_0x3ac0b7['joins']=JSON['parse'](_0x3ac0b7[_0xe63a('0x7b')]);for(var _0x1e806f=0x0;_0x1e806f<_0x3ac0b7[_0xe63a('0x7b')][_0xe63a('0x46')];_0x1e806f+=0x1){if(_0x3ac0b7[_0xe63a('0x7b')][_0x1e806f][_0xe63a('0x30')]&&_[_0xe63a('0x61')](_0x5f3004,_0x3ac0b7[_0xe63a('0x7b')][_0x1e806f]['type'])&&_0x3ac0b7[_0xe63a('0x7b')][_0x1e806f][_0xe63a('0x7d')]&&_0x3ac0b7[_0xe63a('0x7b')][_0x1e806f]['foreignTable']&&_0x3ac0b7[_0xe63a('0x7b')][_0x1e806f][_0xe63a('0x7f')]){_0xa344c8[_0x3ac0b7[_0xe63a('0x7b')][_0x1e806f][_0xe63a('0x30')]](_0x3ac0b7[_0xe63a('0x7b')][_0x1e806f][_0xe63a('0x7e')],null,util[_0xe63a('0x76')]('%s.%s\x20=\x20%s.%s',_0x3ac0b7['table'],_0x3ac0b7[_0xe63a('0x7b')][_0x1e806f][_0xe63a('0x7d')],_0x3ac0b7[_0xe63a('0x7b')][_0x1e806f][_0xe63a('0x7e')],_0x3ac0b7[_0xe63a('0x7b')][_0x1e806f]['foreignKey']));}}}if(_0x3ac0b7[_0xe63a('0x80')]){_0x3ac0b7['conditions']=JSON[_0xe63a('0x7c')](_0x3ac0b7['conditions']);_0xa344c8[_0xe63a('0x3d')](_0x1cee74(_0x3ac0b7[_0xe63a('0x80')][_0xe63a('0x67')]));}_0x10410e=_0xa344c8[_0xe63a('0x81')]();_0xa344c8[_0xe63a('0x23')](_0x14b040);_0xa344c8[_0xe63a('0x22')](0x0);logger['debug']('Limited\x20Query:',_0xa344c8[_0xe63a('0x84')]());return db[_0xe63a('0x85')][_0xe63a('0x32')](_0xa344c8[_0xe63a('0x84')](),{'type':db[_0xe63a('0x85')]['QueryTypes'][_0xe63a('0x8b')]});}})[_0xe63a('0x28')](function(){return{'sql':_0x10410e[_0xe63a('0x84')]()};})[_0xe63a('0x28')](respondWithResult(_0x28cc16,null))[_0xe63a('0x43')](handleError(_0x28cc16,null));};
\ No newline at end of file
+var _0xd317=['AnalyticMetric','keyBy','select','from','table','MetricId','field','function','replace','format','groupBy','orderBy','DESC','alias','joins','parse','includes','foreignKey','%s.%s\x20=\x20%s.%s','foreignTable','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','left_join','SUM(%s)','COUNT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','operator','parentKey','No\x20available\x20data','output','fullPath','%s-%s.%s','csv','custom','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','endDate','startDate','info','fork','../../components/export/','../../files/reports','savename','countTable','COUNT(*)','run','runReport','ROUND(%s)','value','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','squel','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/license/util','../../mysqldb','dbH','sendStatus','status','end','count','offset','limit','set','json','apply','reject','save','update','then','destroy','CustomReports','UserProfileResource','error','stack','name','send','index','map','AnalyticCustomReport','rawAttributes','type','key','query','keys','filters','intersection','model','attributes','fields','nolimit','order','sort','where','pick','VIRTUAL','filter','merge','options','includeAll','findAll','rows','params','find','create','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','autoAssociation','catch','body','preview','join','right_join','cross_join','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)','UNIX_TIMESTAMP(%s)','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','group','condition','getFields','length','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field'];(function(_0x173f10,_0x35db61){var _0x53142d=function(_0x37bbef){while(--_0x37bbef){_0x173f10['push'](_0x173f10['shift']());}};_0x53142d(++_0x35db61);}(_0xd317,0x17e));var _0x7d31=function(_0x4a7631,_0x2c85b9){_0x4a7631=_0x4a7631-0x0;var _0x1a5a6f=_0xd317[_0x4a7631];return _0x1a5a6f;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x7d31('0x0'));var rimraf=require(_0x7d31('0x1'));var zipdir=require(_0x7d31('0x2'));var jsonpatch=require(_0x7d31('0x3'));var rp=require(_0x7d31('0x4'));var moment=require(_0x7d31('0x5'));var BPromise=require(_0x7d31('0x6'));var Mustache=require(_0x7d31('0x7'));var util=require(_0x7d31('0x8'));var path=require(_0x7d31('0x9'));var sox=require(_0x7d31('0xa'));var csv=require(_0x7d31('0xb'));var ejs=require(_0x7d31('0xc'));var fs=require('fs');var _=require('lodash');var squel=require(_0x7d31('0xd'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0x7d31('0xe'));var toCsv=require(_0x7d31('0xb'));var querystring=require(_0x7d31('0xf'));var Papa=require(_0x7d31('0x10'));var Redis=require(_0x7d31('0x11'));var authService=require(_0x7d31('0x12'));var qs=require(_0x7d31('0x13'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x7d31('0x14'));var logger=require(_0x7d31('0x15'))(_0x7d31('0x16'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0x7d31('0x17'));var db=require(_0x7d31('0x18'))['db'];var dbH=require('../../mysqldb')[_0x7d31('0x19')];function respondWithStatusCode(_0xef0c39,_0xa3393a){_0xa3393a=_0xa3393a||0xcc;return function(_0x339af9){if(_0x339af9){return _0xef0c39[_0x7d31('0x1a')](_0xa3393a);}return _0xef0c39[_0x7d31('0x1b')](_0xa3393a)[_0x7d31('0x1c')]();};}function respondWithResult(_0x2a91c5,_0x95eeb3){_0x95eeb3=_0x95eeb3||0xc8;return function(_0x54fe7f){if(_0x54fe7f){return _0x2a91c5[_0x7d31('0x1b')](_0x95eeb3)['json'](_0x54fe7f);}};}function respondWithFilteredResult(_0xaea6f4,_0x432986){return function(_0x22172b){if(_0x22172b){var _0x5e7e1b=_0x22172b[_0x7d31('0x1d')],_0xdf67a6=_0x432986[_0x7d31('0x1e')],_0x596224=_0x432986[_0x7d31('0x1e')]+_0x432986[_0x7d31('0x1f')],_0xf6a4aa;if(_0x596224>=_0x5e7e1b){_0x596224=_0x5e7e1b;_0xf6a4aa=0xc8;}else{_0xf6a4aa=0xce;}_0xaea6f4[_0x7d31('0x1b')](_0xf6a4aa);return _0xaea6f4[_0x7d31('0x20')]('Content-Range',_0xdf67a6+'-'+_0x596224+'/'+_0x5e7e1b)[_0x7d31('0x21')](_0x22172b);}return null;};}function patchUpdates(_0x42d140){return function(_0x1025b0){try{jsonpatch[_0x7d31('0x22')](_0x1025b0,_0x42d140,!![]);}catch(_0x5efe26){return BPromise[_0x7d31('0x23')](_0x5efe26);}return _0x1025b0[_0x7d31('0x24')]();};}function saveUpdates(_0x3ccdc0,_0x1c4e01){return function(_0x8f38aa){if(_0x8f38aa){return _0x8f38aa[_0x7d31('0x25')](_0x3ccdc0)[_0x7d31('0x26')](function(_0x24c3ad){return _0x24c3ad;});}return null;};}function removeEntity(_0x46bf5f,_0x1905c3){return function(_0x26f76a){if(_0x26f76a){return _0x26f76a[_0x7d31('0x27')]()[_0x7d31('0x26')](function(){var _0x13663a=_0x26f76a['get']({'plain':!![]});var _0x1ce1dd=_0x7d31('0x28');return db[_0x7d31('0x29')][_0x7d31('0x27')]({'where':{'type':_0x1ce1dd,'resourceId':_0x13663a['id']}})[_0x7d31('0x26')](function(){return _0x26f76a;});})['then'](function(){_0x46bf5f[_0x7d31('0x1b')](0xcc)['end']();});}};}function handleEntityNotFound(_0x16a541,_0x40d075){return function(_0x25d803){if(!_0x25d803){_0x16a541[_0x7d31('0x1a')](0x194);}return _0x25d803;};}function handleError(_0x196841,_0x2ff038){_0x2ff038=_0x2ff038||0x1f4;return function(_0x31e069){logger[_0x7d31('0x2a')](_0x31e069[_0x7d31('0x2b')]);if(_0x31e069['name']){delete _0x31e069[_0x7d31('0x2c')];}_0x196841['status'](_0x2ff038)[_0x7d31('0x2d')](_0x31e069);};}exports[_0x7d31('0x2e')]=function(_0x3cbb68,_0x662360){var _0x121e0e={},_0x10bf8c={},_0xfcf123={'count':0x0,'rows':[]};var _0xb17d0e=_[_0x7d31('0x2f')](db[_0x7d31('0x30')][_0x7d31('0x31')],function(_0x442e95){return{'name':_0x442e95['fieldName'],'type':_0x442e95[_0x7d31('0x32')][_0x7d31('0x33')]};});_0x10bf8c['model']=_[_0x7d31('0x2f')](_0xb17d0e,_0x7d31('0x2c'));_0x10bf8c[_0x7d31('0x34')]=_[_0x7d31('0x35')](_0x3cbb68['query']);_0x10bf8c[_0x7d31('0x36')]=_[_0x7d31('0x37')](_0x10bf8c[_0x7d31('0x38')],_0x10bf8c[_0x7d31('0x34')]);_0x121e0e[_0x7d31('0x39')]=_[_0x7d31('0x37')](_0x10bf8c[_0x7d31('0x38')],qs['fields'](_0x3cbb68[_0x7d31('0x34')][_0x7d31('0x3a')]));_0x121e0e[_0x7d31('0x39')]=_0x121e0e[_0x7d31('0x39')]['length']?_0x121e0e['attributes']:_0x10bf8c[_0x7d31('0x38')];if(!_0x3cbb68['query']['hasOwnProperty'](_0x7d31('0x3b'))){_0x121e0e[_0x7d31('0x1f')]=qs['limit'](_0x3cbb68['query'][_0x7d31('0x1f')]);_0x121e0e[_0x7d31('0x1e')]=qs[_0x7d31('0x1e')](_0x3cbb68[_0x7d31('0x34')]['offset']);}_0x121e0e[_0x7d31('0x3c')]=qs[_0x7d31('0x3d')](_0x3cbb68[_0x7d31('0x34')][_0x7d31('0x3d')]);_0x121e0e[_0x7d31('0x3e')]=qs[_0x7d31('0x36')](_[_0x7d31('0x3f')](_0x3cbb68[_0x7d31('0x34')],_0x10bf8c[_0x7d31('0x36')]),_0xb17d0e);if(_0x3cbb68[_0x7d31('0x34')]['filter']){_0x121e0e['where']=_['merge'](_0x121e0e[_0x7d31('0x3e')],{'$or':_[_0x7d31('0x2f')](_0xb17d0e,function(_0x36f38c){if(_0x36f38c[_0x7d31('0x32')]!==_0x7d31('0x40')){var _0x273c62={};_0x273c62[_0x36f38c['name']]={'$like':'%'+_0x3cbb68[_0x7d31('0x34')][_0x7d31('0x41')]+'%'};return _0x273c62;}})});}_0x121e0e=_[_0x7d31('0x42')]({},_0x121e0e,_0x3cbb68[_0x7d31('0x43')]);var _0xebc65a={'where':_0x121e0e['where']};return db['AnalyticCustomReport'][_0x7d31('0x1d')](_0xebc65a)[_0x7d31('0x26')](function(_0x151cff){_0xfcf123[_0x7d31('0x1d')]=_0x151cff;if(_0x3cbb68[_0x7d31('0x34')][_0x7d31('0x44')]){_0x121e0e['include']=[{'all':!![]}];}return db['AnalyticCustomReport'][_0x7d31('0x45')](_0x121e0e);})[_0x7d31('0x26')](function(_0x3afd5b){_0xfcf123[_0x7d31('0x46')]=_0x3afd5b;return _0xfcf123;})[_0x7d31('0x26')](respondWithFilteredResult(_0x662360,_0x121e0e))['catch'](handleError(_0x662360,null));};exports['show']=function(_0x4cdf1a,_0x1ff2c9){var _0x47aab9={'raw':![],'where':{'id':_0x4cdf1a[_0x7d31('0x47')]['id']}},_0x46229d={};_0x46229d[_0x7d31('0x38')]=_[_0x7d31('0x35')](db[_0x7d31('0x30')][_0x7d31('0x31')]);_0x46229d['query']=_[_0x7d31('0x35')](_0x4cdf1a[_0x7d31('0x34')]);_0x46229d['filters']=_[_0x7d31('0x37')](_0x46229d[_0x7d31('0x38')],_0x46229d[_0x7d31('0x34')]);_0x47aab9[_0x7d31('0x39')]=_[_0x7d31('0x37')](_0x46229d[_0x7d31('0x38')],qs[_0x7d31('0x3a')](_0x4cdf1a[_0x7d31('0x34')][_0x7d31('0x3a')]));_0x47aab9['attributes']=_0x47aab9['attributes']['length']?_0x47aab9[_0x7d31('0x39')]:_0x46229d[_0x7d31('0x38')];if(_0x4cdf1a[_0x7d31('0x34')]['includeAll']){_0x47aab9['include']=[{'all':!![]}];}_0x47aab9=_[_0x7d31('0x42')]({},_0x47aab9,_0x4cdf1a['options']);return db['AnalyticCustomReport'][_0x7d31('0x48')](_0x47aab9)[_0x7d31('0x26')](handleEntityNotFound(_0x1ff2c9,null))['then'](respondWithResult(_0x1ff2c9,null))['catch'](handleError(_0x1ff2c9,null));};exports['create']=function(_0x124afe,_0x16cde7){return db[_0x7d31('0x30')][_0x7d31('0x49')](_0x124afe['body'],{})['then'](function(_0x1bece1){var _0x4ae526=_0x124afe[_0x7d31('0x4a')][_0x7d31('0x4b')]({'plain':!![]});if(!_0x4ae526)throw new Error(_0x7d31('0x4c'));if(_0x4ae526[_0x7d31('0x4d')]===_0x7d31('0x4a')){var _0x4f7869=_0x1bece1[_0x7d31('0x4b')]({'plain':!![]});var _0x12ef36='Reports';return db['UserProfileSection'][_0x7d31('0x48')]({'where':{'name':_0x12ef36,'userProfileId':_0x4ae526['userProfileId']},'raw':!![]})[_0x7d31('0x26')](function(_0x409a90){if(_0x409a90&&_0x409a90[_0x7d31('0x4e')]===0x0){return db['UserProfileResource'][_0x7d31('0x49')]({'name':_0x4f7869[_0x7d31('0x2c')],'resourceId':_0x4f7869['id'],'type':_0x7d31('0x28'),'sectionId':_0x409a90['id']},{})['then'](function(){return _0x1bece1;});}else{return _0x1bece1;}})[_0x7d31('0x4f')](function(_0xaa0db3){logger[_0x7d31('0x2a')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0xaa0db3);throw _0xaa0db3;});}return _0x1bece1;})[_0x7d31('0x26')](respondWithResult(_0x16cde7,0xc9))[_0x7d31('0x4f')](handleError(_0x16cde7,null));};exports['update']=function(_0x3b7fb6,_0x300d56){if(_0x3b7fb6[_0x7d31('0x50')]['id']){delete _0x3b7fb6[_0x7d31('0x50')]['id'];}return db['AnalyticCustomReport'][_0x7d31('0x48')]({'where':{'id':_0x3b7fb6['params']['id']}})[_0x7d31('0x26')](handleEntityNotFound(_0x300d56,null))[_0x7d31('0x26')](saveUpdates(_0x3b7fb6[_0x7d31('0x50')],null))[_0x7d31('0x26')](respondWithResult(_0x300d56,null))['catch'](handleError(_0x300d56,null));};exports[_0x7d31('0x27')]=function(_0x4e7685,_0x282849){return db['AnalyticCustomReport'][_0x7d31('0x48')]({'where':{'id':_0x4e7685[_0x7d31('0x47')]['id']}})[_0x7d31('0x26')](handleEntityNotFound(_0x282849,null))[_0x7d31('0x26')](removeEntity(_0x282849,null))['catch'](handleError(_0x282849,null));};exports[_0x7d31('0x51')]=function(_0x14bf75,_0x5345ed){var _0x194631=0xa;var _0x1dc266=[_0x7d31('0x52'),'left_join',_0x7d31('0x53'),_0x7d31('0x54')];var _0x337dda={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT DISTINCT':_0x7d31('0x55'),'MAX':_0x7d31('0x56'),'MIN':_0x7d31('0x57'),'AVG':_0x7d31('0x58'),'GROUP_CONCAT':_0x7d31('0x59'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0x7d31('0x5a')};var _0x1baaad={'SEC_TO_TIME':_0x7d31('0x5b'),'DATE':_0x7d31('0x5c'),'HOUR':_0x7d31('0x5d'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x7d31('0x5e')};var _0x2c21cf=function(_0x1894f5){return!_['includes']([_0x7d31('0x5f'),_0x7d31('0x60'),_0x7d31('0x61'),_0x7d31('0x62')],_0x1894f5);};var _0x157de3=function(_0x120f0b){if(!_0x120f0b||!_0x120f0b['rules']['length']){return'';}for(var _0x4c8c81='(',_0x809294=0x0;_0x809294<_0x120f0b['rules']['length'];_0x809294+=0x1){_0x809294>0x0&&(_0x4c8c81+='\x20'+_0x120f0b['operator']+'\x20');_0x4c8c81+=_0x120f0b[_0x7d31('0x63')][_0x809294][_0x7d31('0x64')]?_0x157de3(_0x120f0b['rules'][_0x809294][_0x7d31('0x64')]):_0x120f0b['rules'][_0x809294]['field']+'\x20'+_0x120f0b[_0x7d31('0x63')][_0x809294]['condition']+(_0x2c21cf(_0x120f0b[_0x7d31('0x63')][_0x809294][_0x7d31('0x65')])?'\x20'+_0x120f0b[_0x7d31('0x63')][_0x809294]['value']:'');}return _0x4c8c81+')';};var _0x2ba7a3={'where':{'id':_0x14bf75['params']['id']}},_0x5c74f0,_0x150d84,_0x18c045,_0x469b44,_0x3ec3ea;_0x2ba7a3=_[_0x7d31('0x42')]({},_0x2ba7a3,_0x14bf75[_0x7d31('0x43')]);return db[_0x7d31('0x30')][_0x7d31('0x48')](_0x2ba7a3)[_0x7d31('0x26')](function(_0x58f1f2){if(_0x58f1f2){_0x5c74f0=_0x58f1f2;return _0x58f1f2[_0x7d31('0x66')]();}return null;})[_0x7d31('0x26')](function(_0x537941){if(_0x537941){if(!_0x537941[_0x7d31('0x67')]){throw new db[(_0x7d31('0x68'))][(_0x7d31('0x69'))](_0x7d31('0x6a'),0x193);}_0x150d84=_0x537941;return db[_0x7d31('0x6b')][_0x7d31('0x45')]({'raw':!![]});}return null;})[_0x7d31('0x26')](function(_0x4f968c){if(_0x4f968c){_0x18c045=_[_0x7d31('0x6c')](_0x4f968c,'id');var _0x5675e3;var _0x17cfd0=squel[_0x7d31('0x6d')]();_0x17cfd0[_0x7d31('0x6e')](_0x5c74f0[_0x7d31('0x6f')]);for(var _0x163a50=0x0;_0x163a50<_0x150d84[_0x7d31('0x67')];_0x163a50+=0x1){_0x5675e3=_0x150d84[_0x163a50][_0x7d31('0x70')]?_0x18c045[_0x150d84[_0x163a50][_0x7d31('0x70')]]['metric']:_0x150d84[_0x163a50][_0x7d31('0x71')];_0x5675e3=_0x150d84[_0x163a50][_0x7d31('0x72')]?_[_0x7d31('0x73')](_0x337dda[_0x150d84[_0x163a50][_0x7d31('0x72')]],'%s',_0x5675e3):_0x5675e3;_0x5675e3=_0x150d84[_0x163a50][_0x7d31('0x74')]?_[_0x7d31('0x73')](_0x1baaad[_0x150d84[_0x163a50]['format']],'%s',_0x5675e3):_0x5675e3;if(_0x150d84[_0x163a50][_0x7d31('0x75')]){_0x17cfd0[_0x7d31('0x64')](_0x5675e3);}_0x150d84[_0x163a50][_0x7d31('0x76')]&&_0x17cfd0['order'](_0x5675e3,_0x150d84[_0x163a50][_0x7d31('0x76')]===_0x7d31('0x77')?![]:!![]);_0x17cfd0['field'](_0x5675e3,_0x150d84[_0x163a50][_0x7d31('0x78')]||_0x5675e3);}if(_0x5c74f0['joins']){_0x5c74f0[_0x7d31('0x79')]=JSON[_0x7d31('0x7a')](_0x5c74f0['joins']);for(var _0x43cc15=0x0;_0x43cc15<_0x5c74f0['joins'][_0x7d31('0x67')];_0x43cc15+=0x1){if(_0x5c74f0[_0x7d31('0x79')][_0x43cc15][_0x7d31('0x32')]&&_[_0x7d31('0x7b')](_0x1dc266,_0x5c74f0[_0x7d31('0x79')][_0x43cc15]['type'])&&_0x5c74f0[_0x7d31('0x79')][_0x43cc15]['parentKey']&&_0x5c74f0[_0x7d31('0x79')][_0x43cc15]['foreignTable']&&_0x5c74f0[_0x7d31('0x79')][_0x43cc15][_0x7d31('0x7c')]){_0x17cfd0[_0x5c74f0[_0x7d31('0x79')][_0x43cc15]['type']](_0x5c74f0[_0x7d31('0x79')][_0x43cc15]['foreignTable'],null,util[_0x7d31('0x74')](_0x7d31('0x7d'),_0x5c74f0[_0x7d31('0x6f')],_0x5c74f0['joins'][_0x43cc15]['parentKey'],_0x5c74f0[_0x7d31('0x79')][_0x43cc15][_0x7d31('0x7e')],_0x5c74f0[_0x7d31('0x79')][_0x43cc15][_0x7d31('0x7c')]));}}}if(_0x5c74f0[_0x7d31('0x7f')]){_0x5c74f0[_0x7d31('0x7f')]=JSON['parse'](_0x5c74f0[_0x7d31('0x7f')]);_0x17cfd0['where'](_0x157de3(_0x5c74f0[_0x7d31('0x7f')][_0x7d31('0x64')]));}_0x3ec3ea=_0x17cfd0[_0x7d31('0x80')]();_0x17cfd0[_0x7d31('0x1f')](_0x194631);_0x17cfd0[_0x7d31('0x1e')](0x0);logger[_0x7d31('0x81')](_0x7d31('0x82'),_0x17cfd0[_0x7d31('0x83')]());return db[_0x7d31('0x84')]['query'](_0x17cfd0[_0x7d31('0x83')](),{'type':db['sequelize'][_0x7d31('0x85')][_0x7d31('0x86')]});}})['then'](respondWithResult(_0x5345ed,null))['catch'](handleError(_0x5345ed,null));};function runReport(_0x274738,_0xd00303,_0x45ecc6){var _0xa3ceb6=_0xd00303[_0x7d31('0x2c')];var _0x532d30=0xa;var _0x5aef71=['join',_0x7d31('0x87'),_0x7d31('0x53'),'cross_join'];var _0x90cfa={'SUM':_0x7d31('0x88'),'COUNT':_0x7d31('0x89'),'COUNT DISTINCT':_0x7d31('0x55'),'MAX':_0x7d31('0x56'),'MIN':_0x7d31('0x57'),'AVG':_0x7d31('0x58'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x7d31('0x8a'),'GROUP_CONCAT DESC':_0x7d31('0x5a')};var _0xfd14ac={'SEC_TO_TIME':_0x7d31('0x5b'),'DATE':_0x7d31('0x5c'),'HOUR':'HOUR(%s)','ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x7d31('0x5e')};var _0x538fc1=function(_0x443502){return!_['includes']([_0x7d31('0x5f'),'IS\x20NOT\x20NULL',_0x7d31('0x61'),_0x7d31('0x62')],_0x443502);};var _0x3ac7de=function(_0x5834bf){if(!_0x5834bf||!_0x5834bf[_0x7d31('0x63')][_0x7d31('0x67')]){return'';}for(var _0x2ccfd2='(',_0x257472=0x0;_0x257472<_0x5834bf[_0x7d31('0x63')]['length'];_0x257472+=0x1){_0x257472>0x0&&(_0x2ccfd2+='\x20'+_0x5834bf[_0x7d31('0x8b')]+'\x20');_0x2ccfd2+=_0x5834bf[_0x7d31('0x63')][_0x257472]['group']?_0x3ac7de(_0x5834bf[_0x7d31('0x63')][_0x257472][_0x7d31('0x64')]):_0x5834bf[_0x7d31('0x63')][_0x257472][_0x7d31('0x71')]+'\x20'+_0x5834bf[_0x7d31('0x63')][_0x257472][_0x7d31('0x65')]+(_0x538fc1(_0x5834bf['rules'][_0x257472]['condition'])?'\x20'+_0x5834bf['rules'][_0x257472]['value']:'');}return _0x2ccfd2+')';};var _0x318a33={'where':{'id':_0x274738['id']}},_0x177d1c,_0xa7b2a,_0x36d17a,_0x3ac100,_0x3ece40;_0x318a33=_[_0x7d31('0x42')]({},_0x318a33,_0x45ecc6);return db['AnalyticCustomReport'][_0x7d31('0x48')](_0x318a33)[_0x7d31('0x26')](function(_0x9ff57d){if(_0x9ff57d){_0x177d1c=_0x9ff57d;return _0x9ff57d[_0x7d31('0x66')]();}return null;})[_0x7d31('0x26')](function(_0x15cd0b){if(_0x15cd0b){if(!_0x15cd0b[_0x7d31('0x67')]){throw new db[(_0x7d31('0x68'))][(_0x7d31('0x69'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0xa7b2a=_0x15cd0b;return db[_0x7d31('0x6b')][_0x7d31('0x45')]({'raw':!![]});}return null;})['then'](function(_0x2b4181){if(_0x2b4181){_0x36d17a=_[_0x7d31('0x6c')](_0x2b4181,'id');var _0x4b66db;var _0x34a87f=squel[_0x7d31('0x6d')]();_0x34a87f[_0x7d31('0x6e')](_0x177d1c[_0x7d31('0x6f')]);for(var _0x3d1ef1=0x0;_0x3d1ef1<_0xa7b2a[_0x7d31('0x67')];_0x3d1ef1+=0x1){_0x4b66db=_0xa7b2a[_0x3d1ef1]['MetricId']?_0x36d17a[_0xa7b2a[_0x3d1ef1][_0x7d31('0x70')]]['metric']:_0xa7b2a[_0x3d1ef1]['field'];_0x4b66db=_0xa7b2a[_0x3d1ef1][_0x7d31('0x72')]?_[_0x7d31('0x73')](_0x90cfa[_0xa7b2a[_0x3d1ef1][_0x7d31('0x72')]],'%s',_0x4b66db):_0x4b66db;_0x4b66db=_0xa7b2a[_0x3d1ef1][_0x7d31('0x74')]?_[_0x7d31('0x73')](_0xfd14ac[_0xa7b2a[_0x3d1ef1][_0x7d31('0x74')]],'%s',_0x4b66db):_0x4b66db;if(_0xa7b2a[_0x3d1ef1][_0x7d31('0x75')]){_0x34a87f[_0x7d31('0x64')](_0x4b66db);}_0xa7b2a[_0x3d1ef1]['orderBy']&&_0x34a87f[_0x7d31('0x3c')](_0x4b66db,_0xa7b2a[_0x3d1ef1][_0x7d31('0x76')]===_0x7d31('0x77')?![]:!![]);_0x34a87f[_0x7d31('0x71')](_0x4b66db,_0xa7b2a[_0x3d1ef1]['alias']||_0x4b66db);}if(_0x177d1c[_0x7d31('0x79')]){_0x177d1c[_0x7d31('0x79')]=JSON[_0x7d31('0x7a')](_0x177d1c['joins']);for(var _0x27cf08=0x0;_0x27cf08<_0x177d1c[_0x7d31('0x79')][_0x7d31('0x67')];_0x27cf08+=0x1){if(_0x177d1c[_0x7d31('0x79')][_0x27cf08][_0x7d31('0x32')]&&_['includes'](_0x5aef71,_0x177d1c[_0x7d31('0x79')][_0x27cf08][_0x7d31('0x32')])&&_0x177d1c[_0x7d31('0x79')][_0x27cf08][_0x7d31('0x8c')]&&_0x177d1c['joins'][_0x27cf08][_0x7d31('0x7e')]&&_0x177d1c[_0x7d31('0x79')][_0x27cf08][_0x7d31('0x7c')]){_0x34a87f[_0x177d1c[_0x7d31('0x79')][_0x27cf08]['type']](_0x177d1c[_0x7d31('0x79')][_0x27cf08]['foreignTable'],null,util['format'](_0x7d31('0x7d'),_0x177d1c[_0x7d31('0x6f')],_0x177d1c[_0x7d31('0x79')][_0x27cf08][_0x7d31('0x8c')],_0x177d1c[_0x7d31('0x79')][_0x27cf08][_0x7d31('0x7e')],_0x177d1c[_0x7d31('0x79')][_0x27cf08][_0x7d31('0x7c')]));}}}if(_0x177d1c[_0x7d31('0x7f')]){_0x177d1c[_0x7d31('0x7f')]=JSON[_0x7d31('0x7a')](_0x177d1c[_0x7d31('0x7f')]);_0x34a87f[_0x7d31('0x3e')](_0x3ac7de(_0x177d1c['conditions'][_0x7d31('0x64')]));}_0x3ece40=_0x34a87f['clone']();_0x34a87f['limit'](_0x532d30);_0x34a87f['offset'](0x0);logger[_0x7d31('0x81')](_0x7d31('0x82'),_0x34a87f[_0x7d31('0x83')]());return db[_0x7d31('0x84')][_0x7d31('0x34')](_0x34a87f[_0x7d31('0x83')](),{'type':db[_0x7d31('0x84')][_0x7d31('0x85')]['SELECT']});}})[_0x7d31('0x26')](function(_0x174eec){if(!_0x174eec[_0x7d31('0x67')]){throw new db[(_0x7d31('0x68'))][(_0x7d31('0x69'))](_0x7d31('0x8d'),0xcc);}if(_0xd00303[_0x7d31('0x8e')]==='web'){return null;}var _0x224a61=_[_0x7d31('0x42')](_0xd00303,{'name':_0xd00303[_0x7d31('0x8f')]||_0xd00303['name']||_0x177d1c[_0x7d31('0x2c')],'basename':_0xa3ceb6,'savename':util[_0x7d31('0x74')](_0x7d31('0x90'),_0xd00303[_0x7d31('0x2c')]||_0x177d1c['name'],require('randomstring')['generate'](0x4),_0xd00303[_0x7d31('0x8e')]||_0x7d31('0x91')),'reportId':_0x177d1c['id'],'reportType':_0x7d31('0x92')});return db[_0x7d31('0x93')][_0x7d31('0x49')](_0x224a61,{'raw':!![]});})[_0x7d31('0x26')](function(_0x2a460d){if(_0x177d1c[_0x7d31('0x6f')]===_0x7d31('0x94')){_0x3ece40[_0x7d31('0x3e')](_0x177d1c['table']+_0x7d31('0x95'),_0xd00303['startDate'],_0xd00303[_0x7d31('0x96')]);}else{_0x3ece40[_0x7d31('0x3e')](_0x177d1c[_0x7d31('0x6f')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0xd00303[_0x7d31('0x97')],_0xd00303[_0x7d31('0x96')]);}if(_0x2a460d){logger[_0x7d31('0x98')]('Run\x20Query:',_0x3ece40['toString']());require('child_process')[_0x7d31('0x99')](path[_0x7d31('0x52')](__dirname,_0x7d31('0x9a'),_0x2a460d[_0x7d31('0x8e')]),[_0x2a460d['id'],_0x3ece40[_0x7d31('0x83')](),path['join'](__dirname,_0x7d31('0x9b'),_0x2a460d[_0x7d31('0x9c')]),_0xa3ceb6]);return _0x2a460d;}else{var _0xc3591f=squel[_0x7d31('0x6d')]();_0xc3591f[_0x7d31('0x6e')]('('+_0x3ece40[_0x7d31('0x83')]()+')',_0x7d31('0x9d'));_0xc3591f[_0x7d31('0x71')](_0x7d31('0x9e'),_0x7d31('0x1d'));_0x3ece40['limit'](_0xd00303[_0x7d31('0x1f')]||_0x532d30);_0x3ece40[_0x7d31('0x1e')](_0xd00303[_0x7d31('0x1e')]||0x0);return dbH['sequelize']['query'](_0xc3591f[_0x7d31('0x83')](),{'type':dbH[_0x7d31('0x84')]['QueryTypes'][_0x7d31('0x86')]})['then'](function(_0x17e725){if(!_0x17e725[_0x7d31('0x67')]){_0x3ac100=0x0;}else{_0x3ac100=_0x17e725[0x0][_0x7d31('0x1d')]||0x0;}return dbH[_0x7d31('0x84')]['query'](_0x3ece40[_0x7d31('0x83')](),{'type':dbH['sequelize'][_0x7d31('0x85')]['SELECT']});})[_0x7d31('0x26')](function(_0x287bb3){return{'rows':_0x287bb3||[],'count':_0x3ac100};});}});}exports[_0x7d31('0x9f')]=function(_0x2fead0,_0x278a00){return runReport(_0x2fead0[_0x7d31('0x47')],_0x2fead0[_0x7d31('0x34')],_0x2fead0['options'])[_0x7d31('0x26')](respondWithResult(_0x278a00,null))[_0x7d31('0x4f')](handleError(_0x278a00,null));};exports[_0x7d31('0xa0')]=runReport;exports[_0x7d31('0x34')]=function(_0x1be394,_0x2bbd1a){var _0x3cb88f=0xa;var _0xa24871=[_0x7d31('0x52'),_0x7d31('0x87'),_0x7d31('0x53'),'cross_join'];var _0x4be041={'SUM':'SUM(%s)','COUNT':_0x7d31('0x89'),'COUNT DISTINCT':_0x7d31('0x55'),'MAX':'MAX(%s)','MIN':_0x7d31('0x57'),'AVG':'AVG(%s)','GROUP_CONCAT':_0x7d31('0x59'),'GROUP_CONCAT ASC':_0x7d31('0x8a'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x178a15={'SEC_TO_TIME':_0x7d31('0x5b'),'DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':_0x7d31('0xa1'),'UNIX_TIMESTAMP':_0x7d31('0x5e')};var _0x5ac312=function(_0x3016b9){return!_[_0x7d31('0x7b')]([_0x7d31('0x5f'),_0x7d31('0x60'),_0x7d31('0x61'),'IS\x20NOT\x20EMPTY'],_0x3016b9);};var _0x1cbcd0=function(_0x39c87c){if(!_0x39c87c||!_0x39c87c[_0x7d31('0x63')][_0x7d31('0x67')]){return'';}for(var _0x480566='(',_0x58e5fc=0x0;_0x58e5fc<_0x39c87c[_0x7d31('0x63')][_0x7d31('0x67')];_0x58e5fc+=0x1){_0x58e5fc>0x0&&(_0x480566+='\x20'+_0x39c87c[_0x7d31('0x8b')]+'\x20');_0x480566+=_0x39c87c['rules'][_0x58e5fc][_0x7d31('0x64')]?_0x1cbcd0(_0x39c87c['rules'][_0x58e5fc][_0x7d31('0x64')]):_0x39c87c[_0x7d31('0x63')][_0x58e5fc][_0x7d31('0x71')]+'\x20'+_0x39c87c[_0x7d31('0x63')][_0x58e5fc][_0x7d31('0x65')]+(_0x5ac312(_0x39c87c['rules'][_0x58e5fc][_0x7d31('0x65')])?'\x20'+_0x39c87c['rules'][_0x58e5fc][_0x7d31('0xa2')]:'');}return _0x480566+')';};var _0x3ece07={'where':{'id':_0x1be394[_0x7d31('0x47')]['id']}},_0x2ddfd1,_0x20515f,_0x5173a9,_0x4dafcb,_0x316d28;_0x3ece07=_['merge']({},_0x3ece07,_0x1be394[_0x7d31('0x43')]);return db['AnalyticCustomReport'][_0x7d31('0x48')](_0x3ece07)['then'](function(_0x4dc3c7){if(_0x4dc3c7){_0x2ddfd1=_0x4dc3c7;return _0x4dc3c7[_0x7d31('0x66')]();}return null;})[_0x7d31('0x26')](function(_0x15f66a){if(_0x15f66a){if(!_0x15f66a[_0x7d31('0x67')]){throw new db['Sequelize'][(_0x7d31('0x69'))](_0x7d31('0x6a'),0x193);}_0x20515f=_0x15f66a;return db[_0x7d31('0x6b')][_0x7d31('0x45')]({'raw':!![]});}return null;})[_0x7d31('0x26')](function(_0xa168a5){if(_0xa168a5){_0x5173a9=_[_0x7d31('0x6c')](_0xa168a5,'id');var _0x34c665;var _0xa92f8=squel[_0x7d31('0x6d')]();_0xa92f8['from'](_0x2ddfd1[_0x7d31('0x6f')]);for(var _0x1e2a4d=0x0;_0x1e2a4d<_0x20515f[_0x7d31('0x67')];_0x1e2a4d+=0x1){_0x34c665=_0x20515f[_0x1e2a4d][_0x7d31('0x70')]?_0x5173a9[_0x20515f[_0x1e2a4d]['MetricId']]['metric']:_0x20515f[_0x1e2a4d][_0x7d31('0x71')];_0x34c665=_0x20515f[_0x1e2a4d][_0x7d31('0x72')]?_[_0x7d31('0x73')](_0x4be041[_0x20515f[_0x1e2a4d][_0x7d31('0x72')]],'%s',_0x34c665):_0x34c665;_0x34c665=_0x20515f[_0x1e2a4d][_0x7d31('0x74')]?_['replace'](_0x178a15[_0x20515f[_0x1e2a4d][_0x7d31('0x74')]],'%s',_0x34c665):_0x34c665;if(_0x20515f[_0x1e2a4d][_0x7d31('0x75')]){_0xa92f8[_0x7d31('0x64')](_0x34c665);}_0x20515f[_0x1e2a4d][_0x7d31('0x76')]&&_0xa92f8[_0x7d31('0x3c')](_0x34c665,_0x20515f[_0x1e2a4d][_0x7d31('0x76')]===_0x7d31('0x77')?![]:!![]);_0xa92f8['field'](_0x34c665,_0x20515f[_0x1e2a4d][_0x7d31('0x78')]||_0x34c665);}if(_0x2ddfd1[_0x7d31('0x79')]){_0x2ddfd1[_0x7d31('0x79')]=JSON[_0x7d31('0x7a')](_0x2ddfd1[_0x7d31('0x79')]);for(var _0x59ec9c=0x0;_0x59ec9c<_0x2ddfd1[_0x7d31('0x79')]['length'];_0x59ec9c+=0x1){if(_0x2ddfd1[_0x7d31('0x79')][_0x59ec9c][_0x7d31('0x32')]&&_[_0x7d31('0x7b')](_0xa24871,_0x2ddfd1['joins'][_0x59ec9c]['type'])&&_0x2ddfd1['joins'][_0x59ec9c]['parentKey']&&_0x2ddfd1[_0x7d31('0x79')][_0x59ec9c]['foreignTable']&&_0x2ddfd1[_0x7d31('0x79')][_0x59ec9c][_0x7d31('0x7c')]){_0xa92f8[_0x2ddfd1[_0x7d31('0x79')][_0x59ec9c][_0x7d31('0x32')]](_0x2ddfd1[_0x7d31('0x79')][_0x59ec9c][_0x7d31('0x7e')],null,util['format'](_0x7d31('0x7d'),_0x2ddfd1['table'],_0x2ddfd1[_0x7d31('0x79')][_0x59ec9c]['parentKey'],_0x2ddfd1[_0x7d31('0x79')][_0x59ec9c][_0x7d31('0x7e')],_0x2ddfd1[_0x7d31('0x79')][_0x59ec9c][_0x7d31('0x7c')]));}}}if(_0x2ddfd1[_0x7d31('0x7f')]){_0x2ddfd1[_0x7d31('0x7f')]=JSON[_0x7d31('0x7a')](_0x2ddfd1[_0x7d31('0x7f')]);_0xa92f8[_0x7d31('0x3e')](_0x1cbcd0(_0x2ddfd1['conditions'][_0x7d31('0x64')]));}_0x316d28=_0xa92f8['clone']();_0xa92f8[_0x7d31('0x1f')](_0x3cb88f);_0xa92f8[_0x7d31('0x1e')](0x0);logger[_0x7d31('0x81')](_0x7d31('0x82'),_0xa92f8[_0x7d31('0x83')]());return db[_0x7d31('0x84')][_0x7d31('0x34')](_0xa92f8[_0x7d31('0x83')](),{'type':db[_0x7d31('0x84')][_0x7d31('0x85')]['SELECT']});}})['then'](function(){return{'sql':_0x316d28[_0x7d31('0x83')]()};})[_0x7d31('0x26')](respondWithResult(_0x2bbd1a,null))['catch'](handleError(_0x2bbd1a,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff