// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x9354=['ejs','lodash','squel','crypto','jsforce','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','../../config/environment','sendStatus','status','end','json','count','offset','limit','set','apply','reject','update','then','get','DefaultReports','error','stack','name','AnalyticDefaultReport','rawAttributes','model','keys','query','filters','intersection','fields','attributes','hasOwnProperty','nolimit','order','sort','where','map','type','key','VIRTUAL','filter','include','findAll','rows','catch','params','length','includeAll','merge','options','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','UserProfileSection','userProfileId','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','join','cross_join','SUM(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','DATE(%s)','HOUR(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','group','field','condition','value','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','select','from','MetricId','metric','function','format','replace','groupBy','orderBy','DESC','alias','parse','joins','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','conditions','debug','Limited\x20Query:','toString','sequelize','SELECT','right_join','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','table','QueryTypes','No\x20available\x20data','output','web','fullPath','%s-%s.%s','randomstring','generate','csv','default','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','Run\x20Query:','fork','../../components/export/','../../files/reports','countTable','run','COUNT(%s)','ROUND(%s)','operator','clone','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','util','path','sox','to-csv'];(function(_0x109c6d,_0xc7eac){var _0x375801=function(_0x6129f9){while(--_0x6129f9){_0x109c6d['push'](_0x109c6d['shift']());}};_0x375801(++_0xc7eac);}(_0x9354,0x96));var _0x4935=function(_0x35825e,_0x657421){_0x35825e=_0x35825e-0x0;var _0x4f4d90=_0x9354[_0x35825e];return _0x4f4d90;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x4935('0x0'));var rimraf=require(_0x4935('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x4935('0x2'));var rp=require(_0x4935('0x3'));var moment=require(_0x4935('0x4'));var BPromise=require(_0x4935('0x5'));var Mustache=require('mustache');var util=require(_0x4935('0x6'));var path=require(_0x4935('0x7'));var sox=require(_0x4935('0x8'));var csv=require(_0x4935('0x9'));var ejs=require(_0x4935('0xa'));var fs=require('fs');var _=require(_0x4935('0xb'));var squel=require(_0x4935('0xc'));var crypto=require(_0x4935('0xd'));var jsforce=require(_0x4935('0xe'));var deskjs=require('desk.js');var toCsv=require(_0x4935('0x9'));var querystring=require('querystring');var Papa=require(_0x4935('0xf'));var Redis=require(_0x4935('0x10'));var authService=require(_0x4935('0x11'));var qs=require(_0x4935('0x12'));var hardwareService=require(_0x4935('0x13'));var logger=require(_0x4935('0x14'))('api');var utils=require('../../config/utils');var config=require(_0x4935('0x15'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x4823d0,_0x3f6eef){_0x3f6eef=_0x3f6eef||0xcc;return function(_0x32916f){if(_0x32916f){return _0x4823d0[_0x4935('0x16')](_0x3f6eef);}return _0x4823d0[_0x4935('0x17')](_0x3f6eef)[_0x4935('0x18')]();};}function respondWithResult(_0x2bf1b3,_0x102c63){_0x102c63=_0x102c63||0xc8;return function(_0x3a7c30){if(_0x3a7c30){return _0x2bf1b3[_0x4935('0x17')](_0x102c63)[_0x4935('0x19')](_0x3a7c30);}};}function respondWithFilteredResult(_0x1ce1ba,_0x1799e4){return function(_0xa41961){if(_0xa41961){var _0x3652c4=_0xa41961[_0x4935('0x1a')],_0x24cc99=_0x1799e4[_0x4935('0x1b')],_0x395a43=_0x1799e4[_0x4935('0x1b')]+_0x1799e4[_0x4935('0x1c')],_0x57d7ed;if(_0x395a43>=_0x3652c4){_0x395a43=_0x3652c4;_0x57d7ed=0xc8;}else{_0x57d7ed=0xce;}_0x1ce1ba[_0x4935('0x17')](_0x57d7ed);return _0x1ce1ba[_0x4935('0x1d')]('Content-Range',_0x24cc99+'-'+_0x395a43+'/'+_0x3652c4)[_0x4935('0x19')](_0xa41961);}return null;};}function patchUpdates(_0x145277){return function(_0x4fe356){try{jsonpatch[_0x4935('0x1e')](_0x4fe356,_0x145277,!![]);}catch(_0x10407f){return BPromise[_0x4935('0x1f')](_0x10407f);}return _0x4fe356['save']();};}function saveUpdates(_0x4d58aa,_0x125688){return function(_0x6b849f){if(_0x6b849f){return _0x6b849f[_0x4935('0x20')](_0x4d58aa)[_0x4935('0x21')](function(_0x41d76e){return _0x41d76e;});}return null;};}function removeEntity(_0x16ab7c,_0x7a50ab){return function(_0xe482a5){if(_0xe482a5){return _0xe482a5['destroy']()[_0x4935('0x21')](function(){var _0x320d81=_0xe482a5[_0x4935('0x22')]({'plain':!![]});var _0x2c701f=_0x4935('0x23');return db['UserProfileResource']['destroy']({'where':{'type':_0x2c701f,'resourceId':_0x320d81['id']}})[_0x4935('0x21')](function(){return _0xe482a5;});})[_0x4935('0x21')](function(){_0x16ab7c[_0x4935('0x17')](0xcc)[_0x4935('0x18')]();});}};}function handleEntityNotFound(_0x344e51,_0x1c37ba){return function(_0x3784f9){if(!_0x3784f9){_0x344e51[_0x4935('0x16')](0x194);}return _0x3784f9;};}function handleError(_0x2e1583,_0xf4abb2){_0xf4abb2=_0xf4abb2||0x1f4;return function(_0x1d08b5){logger[_0x4935('0x24')](_0x1d08b5[_0x4935('0x25')]);if(_0x1d08b5[_0x4935('0x26')]){delete _0x1d08b5[_0x4935('0x26')];}_0x2e1583['status'](_0xf4abb2)['send'](_0x1d08b5);};}exports['index']=function(_0x1fc218,_0x76ea7d){var _0x4f1163={},_0x3f0707={},_0x20755a={'count':0x0,'rows':[]};var _0x24a3b6=db[_0x4935('0x27')][_0x4935('0x28')];_0x3f0707[_0x4935('0x29')]=_[_0x4935('0x2a')](_0x24a3b6);_0x3f0707[_0x4935('0x2b')]=_['keys'](_0x1fc218[_0x4935('0x2b')]);_0x3f0707[_0x4935('0x2c')]=_['intersection'](_0x3f0707['model'],_0x3f0707[_0x4935('0x2b')]);_0x4f1163['attributes']=_[_0x4935('0x2d')](_0x3f0707[_0x4935('0x29')],qs[_0x4935('0x2e')](_0x1fc218['query']['fields']));_0x4f1163[_0x4935('0x2f')]=_0x4f1163[_0x4935('0x2f')]['length']?_0x4f1163[_0x4935('0x2f')]:_0x3f0707[_0x4935('0x29')];if(!_0x1fc218[_0x4935('0x2b')][_0x4935('0x30')](_0x4935('0x31'))){_0x4f1163['limit']=qs['limit'](_0x1fc218[_0x4935('0x2b')][_0x4935('0x1c')]);_0x4f1163['offset']=qs['offset'](_0x1fc218[_0x4935('0x2b')]['offset']);}_0x4f1163[_0x4935('0x32')]=qs[_0x4935('0x33')](_0x1fc218[_0x4935('0x2b')][_0x4935('0x33')]);_0x4f1163[_0x4935('0x34')]=qs[_0x4935('0x2c')](_['pick'](_0x1fc218[_0x4935('0x2b')],_0x3f0707['filters']));if(_0x1fc218[_0x4935('0x2b')]['filter']){_0x4f1163[_0x4935('0x34')]=_['merge'](_0x4f1163[_0x4935('0x34')],{'$or':_[_0x4935('0x35')](_0x24a3b6,function(_0x352679){if(_0x352679[_0x4935('0x36')][_0x4935('0x37')]!==_0x4935('0x38')){var _0x441332={};_0x441332[_0x352679['field']]={'$like':'%'+_0x1fc218['query'][_0x4935('0x39')]+'%'};return _0x441332;}})});}_0x4f1163=_['merge']({},_0x4f1163,_0x1fc218['options']);var _0x1552b2={'where':_0x4f1163['where']};return db[_0x4935('0x27')][_0x4935('0x1a')](_0x1552b2)[_0x4935('0x21')](function(_0x99b7c5){_0x20755a[_0x4935('0x1a')]=_0x99b7c5;if(_0x1fc218['query']['includeAll']){_0x4f1163[_0x4935('0x3a')]=[{'all':!![]}];}return db[_0x4935('0x27')][_0x4935('0x3b')](_0x4f1163);})[_0x4935('0x21')](function(_0x4d9436){_0x20755a[_0x4935('0x3c')]=_0x4d9436;return _0x20755a;})[_0x4935('0x21')](respondWithFilteredResult(_0x76ea7d,_0x4f1163))[_0x4935('0x3d')](handleError(_0x76ea7d,null));};exports['show']=function(_0x4e94f6,_0x213230){var _0xe7f002={'raw':!![],'where':{'id':_0x4e94f6[_0x4935('0x3e')]['id']}},_0x493588={};_0x493588[_0x4935('0x29')]=_[_0x4935('0x2a')](db[_0x4935('0x27')]['rawAttributes']);_0x493588['query']=_[_0x4935('0x2a')](_0x4e94f6[_0x4935('0x2b')]);_0x493588['filters']=_[_0x4935('0x2d')](_0x493588[_0x4935('0x29')],_0x493588[_0x4935('0x2b')]);_0xe7f002['attributes']=_[_0x4935('0x2d')](_0x493588[_0x4935('0x29')],qs[_0x4935('0x2e')](_0x4e94f6[_0x4935('0x2b')][_0x4935('0x2e')]));_0xe7f002[_0x4935('0x2f')]=_0xe7f002[_0x4935('0x2f')][_0x4935('0x3f')]?_0xe7f002[_0x4935('0x2f')]:_0x493588[_0x4935('0x29')];if(_0x4e94f6[_0x4935('0x2b')][_0x4935('0x40')]){_0xe7f002[_0x4935('0x3a')]=[{'all':!![]}];}_0xe7f002=_[_0x4935('0x41')]({},_0xe7f002,_0x4e94f6[_0x4935('0x42')]);return db[_0x4935('0x27')][_0x4935('0x43')](_0xe7f002)[_0x4935('0x21')](handleEntityNotFound(_0x213230,null))['then'](respondWithResult(_0x213230,null))[_0x4935('0x3d')](handleError(_0x213230,null));};exports['create']=function(_0x13d78c,_0x144ac5){return db[_0x4935('0x27')][_0x4935('0x44')](_0x13d78c['body'],{})[_0x4935('0x21')](function(_0x9c8bad){var _0x2b34d5=_0x13d78c[_0x4935('0x45')][_0x4935('0x22')]({'plain':!![]});if(!_0x2b34d5)throw new Error(_0x4935('0x46'));if(_0x2b34d5[_0x4935('0x47')]===_0x4935('0x45')){var _0x29b932=_0x9c8bad[_0x4935('0x22')]({'plain':!![]});var _0x5d48dd=_0x4935('0x48');return db[_0x4935('0x49')]['find']({'where':{'name':_0x5d48dd,'userProfileId':_0x2b34d5[_0x4935('0x4a')]},'raw':!![]})[_0x4935('0x21')](function(_0x697a3c){if(_0x697a3c&&_0x697a3c[_0x4935('0x4b')]===0x0){return db[_0x4935('0x4c')][_0x4935('0x44')]({'name':_0x29b932[_0x4935('0x26')],'resourceId':_0x29b932['id'],'type':_0x4935('0x23'),'sectionId':_0x697a3c['id']},{})['then'](function(){return _0x9c8bad;});}else{return _0x9c8bad;}})[_0x4935('0x3d')](function(_0x5609b6){logger['error'](_0x4935('0x4d'),_0x5609b6);throw _0x5609b6;});}return _0x9c8bad;})[_0x4935('0x21')](respondWithResult(_0x144ac5,0xc9))[_0x4935('0x3d')](handleError(_0x144ac5,null));};exports[_0x4935('0x20')]=function(_0x2dd30f,_0x487cf3){if(_0x2dd30f[_0x4935('0x4e')]['id']){delete _0x2dd30f[_0x4935('0x4e')]['id'];}return db[_0x4935('0x27')][_0x4935('0x43')]({'where':{'id':_0x2dd30f[_0x4935('0x3e')]['id']}})[_0x4935('0x21')](handleEntityNotFound(_0x487cf3,null))[_0x4935('0x21')](saveUpdates(_0x2dd30f[_0x4935('0x4e')],null))[_0x4935('0x21')](respondWithResult(_0x487cf3,null))[_0x4935('0x3d')](handleError(_0x487cf3,null));};exports['destroy']=function(_0x24b83b,_0x4e99bb){return db[_0x4935('0x27')][_0x4935('0x43')]({'where':{'id':_0x24b83b['params']['id']}})[_0x4935('0x21')](handleEntityNotFound(_0x4e99bb,null))['then'](removeEntity(_0x4e99bb,null))['catch'](handleError(_0x4e99bb,null));};exports['preview']=function(_0x126f53,_0x2e66e4){var _0x2f946d=0xa;var _0x311af0=[_0x4935('0x4f'),'left_join','right_join',_0x4935('0x50')];var _0x3020e5={'SUM':_0x4935('0x51'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x4935('0x52'),'MAX':_0x4935('0x53'),'MIN':_0x4935('0x54'),'AVG':_0x4935('0x55'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x4935('0x56'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x5093a5={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x4935('0x57'),'HOUR':_0x4935('0x58'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x4935('0x59')};var _0x395eba=function(_0x57b448){return!_[_0x4935('0x5a')]([_0x4935('0x5b'),_0x4935('0x5c'),_0x4935('0x5d'),_0x4935('0x5e')],_0x57b448);};var _0x2d21f0=function(_0x1aba4f){if(!_0x1aba4f||!_0x1aba4f['rules'][_0x4935('0x3f')]){return'';}for(var _0x518788='(',_0x4800c7=0x0;_0x4800c7<_0x1aba4f[_0x4935('0x5f')][_0x4935('0x3f')];_0x4800c7+=0x1){_0x4800c7>0x0&&(_0x518788+='\x20'+_0x1aba4f['operator']+'\x20');_0x518788+=_0x1aba4f['rules'][_0x4800c7][_0x4935('0x60')]?_0x2d21f0(_0x1aba4f[_0x4935('0x5f')][_0x4800c7][_0x4935('0x60')]):_0x1aba4f['rules'][_0x4800c7][_0x4935('0x61')]+'\x20'+_0x1aba4f['rules'][_0x4800c7][_0x4935('0x62')]+(_0x395eba(_0x1aba4f[_0x4935('0x5f')][_0x4800c7][_0x4935('0x62')])?'\x20'+_0x1aba4f[_0x4935('0x5f')][_0x4800c7][_0x4935('0x63')]:'');}return _0x518788+')';};var _0x4e97b0={'where':{'id':_0x126f53[_0x4935('0x3e')]['id']}},_0x1eb15d,_0x33d527,_0x5aef06,_0x103539,_0x2ae5ee;_0x4e97b0=_[_0x4935('0x41')]({},_0x4e97b0,_0x126f53[_0x4935('0x42')]);return db[_0x4935('0x27')][_0x4935('0x43')](_0x4e97b0)[_0x4935('0x21')](function(_0x15ebcc){if(_0x15ebcc){_0x1eb15d=_0x15ebcc;return _0x15ebcc[_0x4935('0x64')]();}return null;})[_0x4935('0x21')](function(_0x5d4435){if(_0x5d4435){if(!_0x5d4435[_0x4935('0x3f')]){throw new db[(_0x4935('0x65'))][(_0x4935('0x66'))](_0x4935('0x67'),0x193);}_0x33d527=_0x5d4435;return db[_0x4935('0x68')][_0x4935('0x3b')]({'raw':!![]});}return null;})[_0x4935('0x21')](function(_0x9023e){if(_0x9023e){_0x5aef06=_[_0x4935('0x69')](_0x9023e,'id');var _0x19d5d0;var _0x11502f=squel[_0x4935('0x6a')]();_0x11502f[_0x4935('0x6b')](_0x1eb15d['table']);for(var _0x5862ab=0x0;_0x5862ab<_0x33d527[_0x4935('0x3f')];_0x5862ab+=0x1){_0x19d5d0=_0x33d527[_0x5862ab][_0x4935('0x6c')]?_0x5aef06[_0x33d527[_0x5862ab]['MetricId']][_0x4935('0x6d')]:_0x33d527[_0x5862ab][_0x4935('0x61')];_0x19d5d0=_0x33d527[_0x5862ab]['function']?_['replace'](_0x3020e5[_0x33d527[_0x5862ab][_0x4935('0x6e')]],'%s',_0x19d5d0):_0x19d5d0;_0x19d5d0=_0x33d527[_0x5862ab][_0x4935('0x6f')]?_[_0x4935('0x70')](_0x5093a5[_0x33d527[_0x5862ab][_0x4935('0x6f')]],'%s',_0x19d5d0):_0x19d5d0;if(_0x33d527[_0x5862ab][_0x4935('0x71')]){_0x11502f['group'](_0x19d5d0);}_0x33d527[_0x5862ab][_0x4935('0x72')]&&_0x11502f[_0x4935('0x32')](_0x19d5d0,_0x33d527[_0x5862ab][_0x4935('0x72')]===_0x4935('0x73')?![]:!![]);_0x11502f['field'](_0x19d5d0,_0x33d527[_0x5862ab][_0x4935('0x74')]||_0x19d5d0);}if(_0x1eb15d['joins']){_0x1eb15d['joins']=JSON[_0x4935('0x75')](_0x1eb15d[_0x4935('0x76')]);for(var _0x531575=0x0;_0x531575<_0x1eb15d[_0x4935('0x76')][_0x4935('0x3f')];_0x531575+=0x1){if(_0x1eb15d[_0x4935('0x76')][_0x531575]['type']&&_[_0x4935('0x5a')](_0x311af0,_0x1eb15d['joins'][_0x531575]['type'])&&_0x1eb15d[_0x4935('0x76')][_0x531575][_0x4935('0x77')]&&_0x1eb15d[_0x4935('0x76')][_0x531575][_0x4935('0x78')]&&_0x1eb15d[_0x4935('0x76')][_0x531575][_0x4935('0x79')]){_0x11502f[_0x1eb15d[_0x4935('0x76')][_0x531575][_0x4935('0x36')]](_0x1eb15d['joins'][_0x531575][_0x4935('0x78')],null,util[_0x4935('0x6f')](_0x4935('0x7a'),_0x1eb15d['table'],_0x1eb15d['joins'][_0x531575][_0x4935('0x77')],_0x1eb15d[_0x4935('0x76')][_0x531575]['foreignTable'],_0x1eb15d[_0x4935('0x76')][_0x531575]['foreignKey']));}}}if(_0x1eb15d['conditions']){_0x1eb15d[_0x4935('0x7b')]=JSON[_0x4935('0x75')](_0x1eb15d[_0x4935('0x7b')]);_0x11502f['where'](_0x2d21f0(_0x1eb15d['conditions'][_0x4935('0x60')]));}_0x2ae5ee=_0x11502f['clone']();_0x11502f[_0x4935('0x1c')](_0x2f946d);_0x11502f['offset'](0x0);logger[_0x4935('0x7c')](_0x4935('0x7d'),_0x11502f[_0x4935('0x7e')]());return db[_0x4935('0x7f')][_0x4935('0x2b')](_0x11502f[_0x4935('0x7e')](),{'type':db[_0x4935('0x7f')]['QueryTypes'][_0x4935('0x80')]});}})['then'](respondWithResult(_0x2e66e4,null))[_0x4935('0x3d')](handleError(_0x2e66e4,null));};function runReport(_0x10e5ba,_0x5b6ee3,_0x3583ba){var _0x4fbed4=_0x5b6ee3[_0x4935('0x26')];var _0x402963=0xa;var _0x5345ff=['join','left_join',_0x4935('0x81'),'cross_join'];var _0x5c28f6={'SUM':_0x4935('0x51'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x4935('0x52'),'MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':'AVG(%s)','GROUP_CONCAT':_0x4935('0x82'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0x4935('0x83')};var _0x29dfcf={'SEC_TO_TIME':_0x4935('0x84'),'DATE':_0x4935('0x57'),'HOUR':_0x4935('0x58'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x4935('0x59')};var _0x1700e2=function(_0x539155){return!_[_0x4935('0x5a')]([_0x4935('0x5b'),'IS\x20NOT\x20NULL',_0x4935('0x5d'),_0x4935('0x5e')],_0x539155);};var _0x495114=function(_0x390767){if(!_0x390767||!_0x390767['rules'][_0x4935('0x3f')]){return'';}for(var _0x453bb1='(',_0x5435b0=0x0;_0x5435b0<_0x390767[_0x4935('0x5f')][_0x4935('0x3f')];_0x5435b0+=0x1){_0x5435b0>0x0&&(_0x453bb1+='\x20'+_0x390767['operator']+'\x20');_0x453bb1+=_0x390767['rules'][_0x5435b0][_0x4935('0x60')]?_0x495114(_0x390767[_0x4935('0x5f')][_0x5435b0]['group']):_0x390767[_0x4935('0x5f')][_0x5435b0][_0x4935('0x61')]+'\x20'+_0x390767[_0x4935('0x5f')][_0x5435b0][_0x4935('0x62')]+(_0x1700e2(_0x390767['rules'][_0x5435b0][_0x4935('0x62')])?'\x20'+_0x390767[_0x4935('0x5f')][_0x5435b0]['value']:'');}return _0x453bb1+')';};var _0x2f7897={'where':{'id':_0x10e5ba['id']}},_0x45f4b8,_0x30a109,_0x9429db,_0xc081fd,_0x1e3fc5;_0x2f7897=_[_0x4935('0x41')]({},_0x2f7897,_0x3583ba);return db[_0x4935('0x27')][_0x4935('0x43')](_0x2f7897)[_0x4935('0x21')](function(_0x34f3d4){if(_0x34f3d4){_0x45f4b8=_0x34f3d4;return _0x34f3d4['getFields']();}return null;})[_0x4935('0x21')](function(_0x3e8e54){if(_0x3e8e54){if(!_0x3e8e54[_0x4935('0x3f')]){throw new db[(_0x4935('0x65'))][(_0x4935('0x66'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x30a109=_0x3e8e54;return db[_0x4935('0x68')][_0x4935('0x3b')]({'raw':!![]});}return null;})['then'](function(_0xa08e30){if(_0xa08e30){_0x9429db=_[_0x4935('0x69')](_0xa08e30,'id');var _0x5474ea;var _0xdab2a0=squel[_0x4935('0x6a')]();_0xdab2a0[_0x4935('0x6b')](_0x45f4b8['table']);for(var _0x15d6d2=0x0;_0x15d6d2<_0x30a109[_0x4935('0x3f')];_0x15d6d2+=0x1){_0x5474ea=_0x30a109[_0x15d6d2][_0x4935('0x6c')]?_0x9429db[_0x30a109[_0x15d6d2][_0x4935('0x6c')]][_0x4935('0x6d')]:_0x30a109[_0x15d6d2]['field'];_0x5474ea=_0x30a109[_0x15d6d2][_0x4935('0x6e')]?_[_0x4935('0x70')](_0x5c28f6[_0x30a109[_0x15d6d2][_0x4935('0x6e')]],'%s',_0x5474ea):_0x5474ea;_0x5474ea=_0x30a109[_0x15d6d2][_0x4935('0x6f')]?_[_0x4935('0x70')](_0x29dfcf[_0x30a109[_0x15d6d2][_0x4935('0x6f')]],'%s',_0x5474ea):_0x5474ea;if(_0x30a109[_0x15d6d2]['groupBy']){_0xdab2a0[_0x4935('0x60')](_0x5474ea);}_0x30a109[_0x15d6d2][_0x4935('0x72')]&&_0xdab2a0[_0x4935('0x32')](_0x5474ea,_0x30a109[_0x15d6d2][_0x4935('0x72')]===_0x4935('0x73')?![]:!![]);_0xdab2a0[_0x4935('0x61')](_0x5474ea,_0x30a109[_0x15d6d2][_0x4935('0x74')]||_0x5474ea);}if(_0x45f4b8['joins']){_0x45f4b8[_0x4935('0x76')]=JSON[_0x4935('0x75')](_0x45f4b8[_0x4935('0x76')]);for(var _0xf12731=0x0;_0xf12731<_0x45f4b8[_0x4935('0x76')]['length'];_0xf12731+=0x1){if(_0x45f4b8['joins'][_0xf12731][_0x4935('0x36')]&&_[_0x4935('0x5a')](_0x5345ff,_0x45f4b8[_0x4935('0x76')][_0xf12731][_0x4935('0x36')])&&_0x45f4b8[_0x4935('0x76')][_0xf12731]['parentKey']&&_0x45f4b8[_0x4935('0x76')][_0xf12731][_0x4935('0x78')]&&_0x45f4b8[_0x4935('0x76')][_0xf12731]['foreignKey']){_0xdab2a0[_0x45f4b8[_0x4935('0x76')][_0xf12731][_0x4935('0x36')]](_0x45f4b8[_0x4935('0x76')][_0xf12731][_0x4935('0x78')],null,util[_0x4935('0x6f')](_0x4935('0x7a'),_0x45f4b8[_0x4935('0x85')],_0x45f4b8['joins'][_0xf12731][_0x4935('0x77')],_0x45f4b8['joins'][_0xf12731][_0x4935('0x78')],_0x45f4b8['joins'][_0xf12731]['foreignKey']));}}}if(_0x45f4b8[_0x4935('0x7b')]){_0x45f4b8['conditions']=JSON['parse'](_0x45f4b8[_0x4935('0x7b')]);_0xdab2a0[_0x4935('0x34')](_0x495114(_0x45f4b8['conditions'][_0x4935('0x60')]));}_0x1e3fc5=_0xdab2a0['clone']();_0xdab2a0[_0x4935('0x1c')](_0x402963);_0xdab2a0[_0x4935('0x1b')](0x0);logger[_0x4935('0x7c')](_0x4935('0x7d'),_0xdab2a0[_0x4935('0x7e')]());return db[_0x4935('0x7f')]['query'](_0xdab2a0[_0x4935('0x7e')](),{'type':db[_0x4935('0x7f')][_0x4935('0x86')]['SELECT']});}})[_0x4935('0x21')](function(_0xea6cf6){if(!_0xea6cf6[_0x4935('0x3f')]){throw new db['Sequelize'][(_0x4935('0x66'))](_0x4935('0x87'),0xcc);}if(_0x5b6ee3[_0x4935('0x88')]===_0x4935('0x89')){return null;}var _0x268999=_['merge'](_0x5b6ee3,{'name':_0x5b6ee3[_0x4935('0x8a')]||_0x5b6ee3['name']||_0x45f4b8[_0x4935('0x26')],'basename':_0x4fbed4,'savename':util['format'](_0x4935('0x8b'),_0x5b6ee3['name']||_0x45f4b8[_0x4935('0x26')],require(_0x4935('0x8c'))[_0x4935('0x8d')](0x4),_0x5b6ee3['output']||_0x4935('0x8e')),'reportId':_0x45f4b8['id'],'reportType':_0x4935('0x8f')});return db[_0x4935('0x90')][_0x4935('0x44')](_0x268999,{'raw':!![]});})[_0x4935('0x21')](function(_0x3bc361){if(_0x45f4b8[_0x4935('0x85')]===_0x4935('0x91')){_0x1e3fc5[_0x4935('0x34')](_0x45f4b8['table']+_0x4935('0x92'),_0x5b6ee3[_0x4935('0x93')],_0x5b6ee3[_0x4935('0x94')]);}else{_0x1e3fc5[_0x4935('0x34')](_0x45f4b8[_0x4935('0x85')]+_0x4935('0x95'),_0x5b6ee3[_0x4935('0x93')],_0x5b6ee3['endDate']);}if(_0x3bc361){logger['info'](_0x4935('0x96'),_0x1e3fc5['toString']());require('child_process')[_0x4935('0x97')](path[_0x4935('0x4f')](__dirname,_0x4935('0x98'),_0x3bc361[_0x4935('0x88')]),[_0x3bc361['id'],_0x1e3fc5['toString'](),path[_0x4935('0x4f')](__dirname,_0x4935('0x99'),_0x3bc361['savename']),_0x4fbed4]);return _0x3bc361;}else{var _0x55eae6=squel['select']();_0x55eae6['from']('('+_0x1e3fc5['toString']()+')',_0x4935('0x9a'));_0x55eae6[_0x4935('0x61')]('COUNT(*)','count');_0x1e3fc5['limit'](_0x5b6ee3[_0x4935('0x1c')]||_0x402963);_0x1e3fc5[_0x4935('0x1b')](_0x5b6ee3[_0x4935('0x1b')]||0x0);return db['sequelize']['query'](_0x55eae6['toString'](),{'type':db[_0x4935('0x7f')][_0x4935('0x86')][_0x4935('0x80')]})[_0x4935('0x21')](function(_0x4fc9fb){if(!_0x4fc9fb[_0x4935('0x3f')]){_0xc081fd=0x0;}else{_0xc081fd=_0x4fc9fb[0x0][_0x4935('0x1a')]||0x0;}return db[_0x4935('0x7f')]['query'](_0x1e3fc5['toString'](),{'type':db[_0x4935('0x7f')][_0x4935('0x86')][_0x4935('0x80')]});})[_0x4935('0x21')](function(_0x415fc2){return{'rows':_0x415fc2||[],'count':_0xc081fd};});}});}exports[_0x4935('0x9b')]=function(_0xf39d39,_0x12cb5f){return runReport(_0xf39d39[_0x4935('0x3e')],_0xf39d39['query'],_0xf39d39[_0x4935('0x42')])[_0x4935('0x21')](respondWithResult(_0x12cb5f,null))['catch'](handleError(_0x12cb5f,null));};exports['runReport']=runReport;exports[_0x4935('0x2b')]=function(_0x5eeb57,_0x46a85a){var _0x46b58e=0xa;var _0x4a7372=[_0x4935('0x4f'),'left_join',_0x4935('0x81'),_0x4935('0x50')];var _0x493f4c={'SUM':'SUM(%s)','COUNT':_0x4935('0x9c'),'COUNT DISTINCT':_0x4935('0x52'),'MAX':_0x4935('0x53'),'MIN':_0x4935('0x54'),'AVG':_0x4935('0x55'),'GROUP_CONCAT':_0x4935('0x82'),'GROUP_CONCAT ASC':_0x4935('0x56'),'GROUP_CONCAT DESC':_0x4935('0x83')};var _0x5e230e={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x4935('0x57'),'HOUR':_0x4935('0x58'),'ROUND':_0x4935('0x9d'),'UNIX_TIMESTAMP':_0x4935('0x59')};var _0x41485b=function(_0x2a18f0){return!_[_0x4935('0x5a')]([_0x4935('0x5b'),'IS\x20NOT\x20NULL',_0x4935('0x5d'),'IS\x20NOT\x20EMPTY'],_0x2a18f0);};var _0x222c90=function(_0x52a661){if(!_0x52a661||!_0x52a661[_0x4935('0x5f')][_0x4935('0x3f')]){return'';}for(var _0x31eaee='(',_0x409d86=0x0;_0x409d86<_0x52a661[_0x4935('0x5f')]['length'];_0x409d86+=0x1){_0x409d86>0x0&&(_0x31eaee+='\x20'+_0x52a661[_0x4935('0x9e')]+'\x20');_0x31eaee+=_0x52a661[_0x4935('0x5f')][_0x409d86][_0x4935('0x60')]?_0x222c90(_0x52a661['rules'][_0x409d86]['group']):_0x52a661[_0x4935('0x5f')][_0x409d86]['field']+'\x20'+_0x52a661[_0x4935('0x5f')][_0x409d86][_0x4935('0x62')]+(_0x41485b(_0x52a661[_0x4935('0x5f')][_0x409d86][_0x4935('0x62')])?'\x20'+_0x52a661[_0x4935('0x5f')][_0x409d86]['value']:'');}return _0x31eaee+')';};var _0x145125={'where':{'id':_0x5eeb57[_0x4935('0x3e')]['id']}},_0x247898,_0x3c277e,_0x2c951b,_0x46eebd,_0x5702f6;_0x145125=_[_0x4935('0x41')]({},_0x145125,_0x5eeb57[_0x4935('0x42')]);return db[_0x4935('0x27')]['find'](_0x145125)['then'](function(_0x5b303b){if(_0x5b303b){_0x247898=_0x5b303b;return _0x5b303b['getFields']();}return null;})[_0x4935('0x21')](function(_0x3fc079){if(_0x3fc079){if(!_0x3fc079[_0x4935('0x3f')]){throw new db[(_0x4935('0x65'))][(_0x4935('0x66'))](_0x4935('0x67'),0x193);}_0x3c277e=_0x3fc079;return db[_0x4935('0x68')][_0x4935('0x3b')]({'raw':!![]});}return null;})[_0x4935('0x21')](function(_0x320aa9){if(_0x320aa9){_0x2c951b=_['keyBy'](_0x320aa9,'id');var _0x7f709e;var _0x3508ac=squel[_0x4935('0x6a')]();_0x3508ac[_0x4935('0x6b')](_0x247898[_0x4935('0x85')]);for(var _0x8ef56f=0x0;_0x8ef56f<_0x3c277e[_0x4935('0x3f')];_0x8ef56f+=0x1){_0x7f709e=_0x3c277e[_0x8ef56f][_0x4935('0x6c')]?_0x2c951b[_0x3c277e[_0x8ef56f][_0x4935('0x6c')]]['metric']:_0x3c277e[_0x8ef56f]['field'];_0x7f709e=_0x3c277e[_0x8ef56f][_0x4935('0x6e')]?_[_0x4935('0x70')](_0x493f4c[_0x3c277e[_0x8ef56f][_0x4935('0x6e')]],'%s',_0x7f709e):_0x7f709e;_0x7f709e=_0x3c277e[_0x8ef56f][_0x4935('0x6f')]?_[_0x4935('0x70')](_0x5e230e[_0x3c277e[_0x8ef56f][_0x4935('0x6f')]],'%s',_0x7f709e):_0x7f709e;if(_0x3c277e[_0x8ef56f][_0x4935('0x71')]){_0x3508ac[_0x4935('0x60')](_0x7f709e);}_0x3c277e[_0x8ef56f]['orderBy']&&_0x3508ac[_0x4935('0x32')](_0x7f709e,_0x3c277e[_0x8ef56f][_0x4935('0x72')]==='DESC'?![]:!![]);_0x3508ac[_0x4935('0x61')](_0x7f709e,_0x3c277e[_0x8ef56f]['alias']||_0x7f709e);}if(_0x247898[_0x4935('0x76')]){_0x247898[_0x4935('0x76')]=JSON[_0x4935('0x75')](_0x247898[_0x4935('0x76')]);for(var _0x6b6036=0x0;_0x6b6036<_0x247898[_0x4935('0x76')][_0x4935('0x3f')];_0x6b6036+=0x1){if(_0x247898[_0x4935('0x76')][_0x6b6036][_0x4935('0x36')]&&_[_0x4935('0x5a')](_0x4a7372,_0x247898['joins'][_0x6b6036][_0x4935('0x36')])&&_0x247898['joins'][_0x6b6036][_0x4935('0x77')]&&_0x247898[_0x4935('0x76')][_0x6b6036][_0x4935('0x78')]&&_0x247898[_0x4935('0x76')][_0x6b6036][_0x4935('0x79')]){_0x3508ac[_0x247898['joins'][_0x6b6036][_0x4935('0x36')]](_0x247898[_0x4935('0x76')][_0x6b6036][_0x4935('0x78')],null,util[_0x4935('0x6f')](_0x4935('0x7a'),_0x247898[_0x4935('0x85')],_0x247898[_0x4935('0x76')][_0x6b6036][_0x4935('0x77')],_0x247898[_0x4935('0x76')][_0x6b6036][_0x4935('0x78')],_0x247898[_0x4935('0x76')][_0x6b6036][_0x4935('0x79')]));}}}if(_0x247898['conditions']){_0x247898[_0x4935('0x7b')]=JSON[_0x4935('0x75')](_0x247898[_0x4935('0x7b')]);_0x3508ac['where'](_0x222c90(_0x247898[_0x4935('0x7b')]['group']));}_0x5702f6=_0x3508ac[_0x4935('0x9f')]();_0x3508ac[_0x4935('0x1c')](_0x46b58e);_0x3508ac[_0x4935('0x1b')](0x0);logger[_0x4935('0x7c')](_0x4935('0x7d'),_0x3508ac['toString']());return db[_0x4935('0x7f')][_0x4935('0x2b')](_0x3508ac[_0x4935('0x7e')](),{'type':db[_0x4935('0x7f')]['QueryTypes'][_0x4935('0x80')]});}})[_0x4935('0x21')](function(){return{'sql':_0x5702f6[_0x4935('0x7e')]()};})[_0x4935('0x21')](respondWithResult(_0x46a85a,null))[_0x4935('0x3d')](handleError(_0x46a85a,null));};
\ No newline at end of file
+var _0x4024=['COUNT(DISTINCT\x20%s)','MAX(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','getFields','groupBy','order','No\x20available\x20data','output','web','fullPath','%s-%s.%s','randomstring','generate','csv','default','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','Run\x20Query:','child_process','fork','../../files/reports','select','run','runReport','debug','html-pdf','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','end','status','json','count','offset','limit','set','apply','reject','save','then','destroy','get','DefaultReports','UserProfileResource','stack','name','index','map','AnalyticDefaultReport','rawAttributes','key','model','query','filters','intersection','attributes','fields','length','hasOwnProperty','sort','where','filter','merge','type','VIRTUAL','rows','catch','show','params','keys','include','options','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','Reports','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','find','preview','join','right_join','cross_join','SUM(%s)','COUNT(%s)','MIN(%s)','SEC_TO_TIME(%s)','DATE(%s)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','condition','value','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','findAll','keyBy','from','MetricId','field','replace','function','format','orderBy','DESC','alias','joins','parse','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','table','conditions','clone','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','left_join'];(function(_0x1ffd87,_0xacf17d){var _0x5665b6=function(_0x474772){while(--_0x474772){_0x1ffd87['push'](_0x1ffd87['shift']());}};_0x5665b6(++_0xacf17d);}(_0x4024,0xc4));var _0x4402=function(_0x3994ba,_0x23ae01){_0x3994ba=_0x3994ba-0x0;var _0x4fa775=_0x4024[_0x3994ba];return _0x4fa775;};'use strict';var pdf=require(_0x4402('0x0'));var emlformat=require('eml-format');var rimraf=require(_0x4402('0x1'));var zipdir=require(_0x4402('0x2'));var jsonpatch=require(_0x4402('0x3'));var rp=require(_0x4402('0x4'));var moment=require(_0x4402('0x5'));var BPromise=require(_0x4402('0x6'));var Mustache=require(_0x4402('0x7'));var util=require(_0x4402('0x8'));var path=require(_0x4402('0x9'));var sox=require(_0x4402('0xa'));var csv=require('to-csv');var ejs=require(_0x4402('0xb'));var fs=require('fs');var _=require(_0x4402('0xc'));var squel=require(_0x4402('0xd'));var crypto=require(_0x4402('0xe'));var jsforce=require(_0x4402('0xf'));var deskjs=require(_0x4402('0x10'));var toCsv=require('to-csv');var querystring=require(_0x4402('0x11'));var Papa=require(_0x4402('0x12'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0x4402('0x13'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x4402('0x14'));var logger=require(_0x4402('0x15'))(_0x4402('0x16'));var utils=require(_0x4402('0x17'));var config=require(_0x4402('0x18'));var db=require(_0x4402('0x19'))['db'];function respondWithStatusCode(_0x3d1b85,_0x5a452d){_0x5a452d=_0x5a452d||0xcc;return function(_0x2a005f){if(_0x2a005f){return _0x3d1b85[_0x4402('0x1a')](_0x5a452d);}return _0x3d1b85['status'](_0x5a452d)[_0x4402('0x1b')]();};}function respondWithResult(_0x5ea30a,_0x308790){_0x308790=_0x308790||0xc8;return function(_0x26d1d7){if(_0x26d1d7){return _0x5ea30a[_0x4402('0x1c')](_0x308790)[_0x4402('0x1d')](_0x26d1d7);}};}function respondWithFilteredResult(_0xc084a0,_0x140f88){return function(_0x2ff1d8){if(_0x2ff1d8){var _0x51a0ae=_0x2ff1d8[_0x4402('0x1e')],_0x1f1ca8=_0x140f88[_0x4402('0x1f')],_0x4c9e0e=_0x140f88[_0x4402('0x1f')]+_0x140f88[_0x4402('0x20')],_0x1e43fc;if(_0x4c9e0e>=_0x51a0ae){_0x4c9e0e=_0x51a0ae;_0x1e43fc=0xc8;}else{_0x1e43fc=0xce;}_0xc084a0[_0x4402('0x1c')](_0x1e43fc);return _0xc084a0[_0x4402('0x21')]('Content-Range',_0x1f1ca8+'-'+_0x4c9e0e+'/'+_0x51a0ae)[_0x4402('0x1d')](_0x2ff1d8);}return null;};}function patchUpdates(_0x407129){return function(_0x37442f){try{jsonpatch[_0x4402('0x22')](_0x37442f,_0x407129,!![]);}catch(_0x21b333){return BPromise[_0x4402('0x23')](_0x21b333);}return _0x37442f[_0x4402('0x24')]();};}function saveUpdates(_0x4df34b,_0x119bc9){return function(_0xb0a2e5){if(_0xb0a2e5){return _0xb0a2e5['update'](_0x4df34b)[_0x4402('0x25')](function(_0x238d44){return _0x238d44;});}return null;};}function removeEntity(_0x5de6d1,_0x40fb74){return function(_0x53ddb6){if(_0x53ddb6){return _0x53ddb6[_0x4402('0x26')]()[_0x4402('0x25')](function(){var _0x60a4af=_0x53ddb6[_0x4402('0x27')]({'plain':!![]});var _0x1de5a1=_0x4402('0x28');return db[_0x4402('0x29')][_0x4402('0x26')]({'where':{'type':_0x1de5a1,'resourceId':_0x60a4af['id']}})[_0x4402('0x25')](function(){return _0x53ddb6;});})[_0x4402('0x25')](function(){_0x5de6d1['status'](0xcc)[_0x4402('0x1b')]();});}};}function handleEntityNotFound(_0x458b83,_0x2aac41){return function(_0x3b4daf){if(!_0x3b4daf){_0x458b83[_0x4402('0x1a')](0x194);}return _0x3b4daf;};}function handleError(_0x4779c5,_0x3178d9){_0x3178d9=_0x3178d9||0x1f4;return function(_0x5ae84e){logger['error'](_0x5ae84e[_0x4402('0x2a')]);if(_0x5ae84e[_0x4402('0x2b')]){delete _0x5ae84e[_0x4402('0x2b')];}_0x4779c5[_0x4402('0x1c')](_0x3178d9)['send'](_0x5ae84e);};}exports[_0x4402('0x2c')]=function(_0x393638,_0x340703){var _0x5abf5b={},_0x5b1fd9={},_0x1d5af4={'count':0x0,'rows':[]};var _0x7748ce=_[_0x4402('0x2d')](db[_0x4402('0x2e')][_0x4402('0x2f')],function(_0x67f535){return{'name':_0x67f535['fieldName'],'type':_0x67f535['type'][_0x4402('0x30')]};});_0x5b1fd9[_0x4402('0x31')]=_['map'](_0x7748ce,'name');_0x5b1fd9[_0x4402('0x32')]=_['keys'](_0x393638[_0x4402('0x32')]);_0x5b1fd9[_0x4402('0x33')]=_[_0x4402('0x34')](_0x5b1fd9[_0x4402('0x31')],_0x5b1fd9[_0x4402('0x32')]);_0x5abf5b[_0x4402('0x35')]=_['intersection'](_0x5b1fd9[_0x4402('0x31')],qs[_0x4402('0x36')](_0x393638[_0x4402('0x32')][_0x4402('0x36')]));_0x5abf5b['attributes']=_0x5abf5b[_0x4402('0x35')][_0x4402('0x37')]?_0x5abf5b[_0x4402('0x35')]:_0x5b1fd9[_0x4402('0x31')];if(!_0x393638[_0x4402('0x32')][_0x4402('0x38')]('nolimit')){_0x5abf5b[_0x4402('0x20')]=qs[_0x4402('0x20')](_0x393638['query'][_0x4402('0x20')]);_0x5abf5b['offset']=qs[_0x4402('0x1f')](_0x393638['query'][_0x4402('0x1f')]);}_0x5abf5b['order']=qs[_0x4402('0x39')](_0x393638['query'][_0x4402('0x39')]);_0x5abf5b[_0x4402('0x3a')]=qs[_0x4402('0x33')](_['pick'](_0x393638[_0x4402('0x32')],_0x5b1fd9[_0x4402('0x33')]));if(_0x393638[_0x4402('0x32')][_0x4402('0x3b')]){_0x5abf5b['where']=_[_0x4402('0x3c')](_0x5abf5b[_0x4402('0x3a')],{'$or':_[_0x4402('0x2d')](_0x7748ce,function(_0x378f58){if(_0x378f58[_0x4402('0x3d')]!==_0x4402('0x3e')){var _0x38b54d={};_0x38b54d[_0x378f58[_0x4402('0x2b')]]={'$like':'%'+_0x393638[_0x4402('0x32')][_0x4402('0x3b')]+'%'};return _0x38b54d;}})});}_0x5abf5b=_[_0x4402('0x3c')]({},_0x5abf5b,_0x393638['options']);var _0x322ced={'where':_0x5abf5b[_0x4402('0x3a')]};return db[_0x4402('0x2e')][_0x4402('0x1e')](_0x322ced)[_0x4402('0x25')](function(_0x3d50d0){_0x1d5af4[_0x4402('0x1e')]=_0x3d50d0;if(_0x393638['query']['includeAll']){_0x5abf5b['include']=[{'all':!![]}];}return db[_0x4402('0x2e')]['findAll'](_0x5abf5b);})[_0x4402('0x25')](function(_0x98b7a3){_0x1d5af4[_0x4402('0x3f')]=_0x98b7a3;return _0x1d5af4;})[_0x4402('0x25')](respondWithFilteredResult(_0x340703,_0x5abf5b))[_0x4402('0x40')](handleError(_0x340703,null));};exports[_0x4402('0x41')]=function(_0x479e66,_0x11ba62){var _0x28e810={'raw':!![],'where':{'id':_0x479e66[_0x4402('0x42')]['id']}},_0x4dedc6={};_0x4dedc6[_0x4402('0x31')]=_['keys'](db[_0x4402('0x2e')][_0x4402('0x2f')]);_0x4dedc6[_0x4402('0x32')]=_[_0x4402('0x43')](_0x479e66['query']);_0x4dedc6[_0x4402('0x33')]=_['intersection'](_0x4dedc6[_0x4402('0x31')],_0x4dedc6[_0x4402('0x32')]);_0x28e810[_0x4402('0x35')]=_['intersection'](_0x4dedc6[_0x4402('0x31')],qs[_0x4402('0x36')](_0x479e66['query']['fields']));_0x28e810[_0x4402('0x35')]=_0x28e810['attributes']['length']?_0x28e810[_0x4402('0x35')]:_0x4dedc6['model'];if(_0x479e66[_0x4402('0x32')]['includeAll']){_0x28e810[_0x4402('0x44')]=[{'all':!![]}];}_0x28e810=_[_0x4402('0x3c')]({},_0x28e810,_0x479e66[_0x4402('0x45')]);return db[_0x4402('0x2e')]['find'](_0x28e810)[_0x4402('0x25')](handleEntityNotFound(_0x11ba62,null))[_0x4402('0x25')](respondWithResult(_0x11ba62,null))[_0x4402('0x40')](handleError(_0x11ba62,null));};exports[_0x4402('0x46')]=function(_0x2821cd,_0x9ba9c6){return db[_0x4402('0x2e')]['create'](_0x2821cd[_0x4402('0x47')],{})['then'](function(_0x2cc265){var _0xaedd43=_0x2821cd[_0x4402('0x48')][_0x4402('0x27')]({'plain':!![]});if(!_0xaedd43)throw new Error(_0x4402('0x49'));if(_0xaedd43['role']===_0x4402('0x48')){var _0x3a0846=_0x2cc265[_0x4402('0x27')]({'plain':!![]});var _0x1ed8d6=_0x4402('0x4a');return db[_0x4402('0x4b')]['find']({'where':{'name':_0x1ed8d6,'userProfileId':_0xaedd43[_0x4402('0x4c')]},'raw':!![]})[_0x4402('0x25')](function(_0x3ba284){if(_0x3ba284&&_0x3ba284[_0x4402('0x4d')]===0x0){return db[_0x4402('0x29')][_0x4402('0x46')]({'name':_0x3a0846['name'],'resourceId':_0x3a0846['id'],'type':'DefaultReports','sectionId':_0x3ba284['id']},{})['then'](function(){return _0x2cc265;});}else{return _0x2cc265;}})[_0x4402('0x40')](function(_0x48f408){logger['error'](_0x4402('0x4e'),_0x48f408);throw _0x48f408;});}return _0x2cc265;})[_0x4402('0x25')](respondWithResult(_0x9ba9c6,0xc9))[_0x4402('0x40')](handleError(_0x9ba9c6,null));};exports['update']=function(_0x277107,_0x1c6149){if(_0x277107[_0x4402('0x47')]['id']){delete _0x277107[_0x4402('0x47')]['id'];}return db[_0x4402('0x2e')][_0x4402('0x4f')]({'where':{'id':_0x277107[_0x4402('0x42')]['id']}})[_0x4402('0x25')](handleEntityNotFound(_0x1c6149,null))[_0x4402('0x25')](saveUpdates(_0x277107[_0x4402('0x47')],null))['then'](respondWithResult(_0x1c6149,null))[_0x4402('0x40')](handleError(_0x1c6149,null));};exports['destroy']=function(_0x1d7cf2,_0x28612c){return db[_0x4402('0x2e')][_0x4402('0x4f')]({'where':{'id':_0x1d7cf2['params']['id']}})[_0x4402('0x25')](handleEntityNotFound(_0x28612c,null))[_0x4402('0x25')](removeEntity(_0x28612c,null))[_0x4402('0x40')](handleError(_0x28612c,null));};exports[_0x4402('0x50')]=function(_0x536642,_0x54656c){var _0xa64302=0xa;var _0x2f926d=[_0x4402('0x51'),'left_join',_0x4402('0x52'),_0x4402('0x53')];var _0x305dea={'SUM':_0x4402('0x54'),'COUNT':_0x4402('0x55'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':'MAX(%s)','MIN':_0x4402('0x56'),'AVG':'AVG(%s)','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 _0x5c6fe7={'SEC_TO_TIME':_0x4402('0x57'),'DATE':_0x4402('0x58'),'HOUR':_0x4402('0x59'),'ROUND':_0x4402('0x5a'),'UNIX_TIMESTAMP':_0x4402('0x5b')};var _0x4f10ec=function(_0x15f24a){return!_[_0x4402('0x5c')]([_0x4402('0x5d'),_0x4402('0x5e'),_0x4402('0x5f'),_0x4402('0x60')],_0x15f24a);};var _0xc31333=function(_0x399584){if(!_0x399584||!_0x399584[_0x4402('0x61')][_0x4402('0x37')]){return'';}for(var _0x150436='(',_0x421189=0x0;_0x421189<_0x399584[_0x4402('0x61')][_0x4402('0x37')];_0x421189+=0x1){_0x421189>0x0&&(_0x150436+='\x20'+_0x399584[_0x4402('0x62')]+'\x20');_0x150436+=_0x399584[_0x4402('0x61')][_0x421189][_0x4402('0x63')]?_0xc31333(_0x399584[_0x4402('0x61')][_0x421189]['group']):_0x399584[_0x4402('0x61')][_0x421189]['field']+'\x20'+_0x399584['rules'][_0x421189]['condition']+(_0x4f10ec(_0x399584[_0x4402('0x61')][_0x421189][_0x4402('0x64')])?'\x20'+_0x399584[_0x4402('0x61')][_0x421189][_0x4402('0x65')]:'');}return _0x150436+')';};var _0x2e8c2d={'where':{'id':_0x536642[_0x4402('0x42')]['id']}},_0x50ee55,_0x559db1,_0x57729e,_0x1bde61,_0x5c5ecf;_0x2e8c2d=_[_0x4402('0x3c')]({},_0x2e8c2d,_0x536642['options']);return db[_0x4402('0x2e')][_0x4402('0x4f')](_0x2e8c2d)['then'](function(_0x4a9f16){if(_0x4a9f16){_0x50ee55=_0x4a9f16;return _0x4a9f16['getFields']();}return null;})['then'](function(_0x133613){if(_0x133613){if(!_0x133613[_0x4402('0x37')]){throw new db[(_0x4402('0x66'))][(_0x4402('0x67'))](_0x4402('0x68'),0x193);}_0x559db1=_0x133613;return db[_0x4402('0x69')][_0x4402('0x6a')]({'raw':!![]});}return null;})['then'](function(_0x424829){if(_0x424829){_0x57729e=_[_0x4402('0x6b')](_0x424829,'id');var _0x402c4d;var _0x4858d4=squel['select']();_0x4858d4[_0x4402('0x6c')](_0x50ee55['table']);for(var _0x58639d=0x0;_0x58639d<_0x559db1['length'];_0x58639d+=0x1){_0x402c4d=_0x559db1[_0x58639d][_0x4402('0x6d')]?_0x57729e[_0x559db1[_0x58639d][_0x4402('0x6d')]]['metric']:_0x559db1[_0x58639d][_0x4402('0x6e')];_0x402c4d=_0x559db1[_0x58639d]['function']?_[_0x4402('0x6f')](_0x305dea[_0x559db1[_0x58639d][_0x4402('0x70')]],'%s',_0x402c4d):_0x402c4d;_0x402c4d=_0x559db1[_0x58639d][_0x4402('0x71')]?_[_0x4402('0x6f')](_0x5c6fe7[_0x559db1[_0x58639d][_0x4402('0x71')]],'%s',_0x402c4d):_0x402c4d;if(_0x559db1[_0x58639d]['groupBy']){_0x4858d4[_0x4402('0x63')](_0x402c4d);}_0x559db1[_0x58639d]['orderBy']&&_0x4858d4['order'](_0x402c4d,_0x559db1[_0x58639d][_0x4402('0x72')]===_0x4402('0x73')?![]:!![]);_0x4858d4[_0x4402('0x6e')](_0x402c4d,_0x559db1[_0x58639d][_0x4402('0x74')]||_0x402c4d);}if(_0x50ee55[_0x4402('0x75')]){_0x50ee55[_0x4402('0x75')]=JSON[_0x4402('0x76')](_0x50ee55['joins']);for(var _0x4d448c=0x0;_0x4d448c<_0x50ee55[_0x4402('0x75')][_0x4402('0x37')];_0x4d448c+=0x1){if(_0x50ee55[_0x4402('0x75')][_0x4d448c][_0x4402('0x3d')]&&_[_0x4402('0x5c')](_0x2f926d,_0x50ee55[_0x4402('0x75')][_0x4d448c][_0x4402('0x3d')])&&_0x50ee55[_0x4402('0x75')][_0x4d448c][_0x4402('0x77')]&&_0x50ee55[_0x4402('0x75')][_0x4d448c][_0x4402('0x78')]&&_0x50ee55[_0x4402('0x75')][_0x4d448c][_0x4402('0x79')]){_0x4858d4[_0x50ee55[_0x4402('0x75')][_0x4d448c][_0x4402('0x3d')]](_0x50ee55[_0x4402('0x75')][_0x4d448c][_0x4402('0x78')],null,util[_0x4402('0x71')](_0x4402('0x7a'),_0x50ee55[_0x4402('0x7b')],_0x50ee55[_0x4402('0x75')][_0x4d448c][_0x4402('0x77')],_0x50ee55['joins'][_0x4d448c][_0x4402('0x78')],_0x50ee55[_0x4402('0x75')][_0x4d448c][_0x4402('0x79')]));}}}if(_0x50ee55[_0x4402('0x7c')]){_0x50ee55[_0x4402('0x7c')]=JSON['parse'](_0x50ee55[_0x4402('0x7c')]);_0x4858d4[_0x4402('0x3a')](_0xc31333(_0x50ee55[_0x4402('0x7c')][_0x4402('0x63')]));}_0x5c5ecf=_0x4858d4[_0x4402('0x7d')]();_0x4858d4[_0x4402('0x20')](_0xa64302);_0x4858d4[_0x4402('0x1f')](0x0);logger['debug'](_0x4402('0x7e'),_0x4858d4[_0x4402('0x7f')]());return db['sequelize'][_0x4402('0x32')](_0x4858d4[_0x4402('0x7f')](),{'type':db[_0x4402('0x80')][_0x4402('0x81')][_0x4402('0x82')]});}})['then'](respondWithResult(_0x54656c,null))['catch'](handleError(_0x54656c,null));};function runReport(_0x5365ab,_0x1d94f4,_0x9c984){var _0x1b79c6=_0x1d94f4[_0x4402('0x2b')];var _0x173d57=0xa;var _0x1d391c=[_0x4402('0x51'),_0x4402('0x83'),_0x4402('0x52'),'cross_join'];var _0x2583e5={'SUM':_0x4402('0x54'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x4402('0x84'),'MAX':_0x4402('0x85'),'MIN':_0x4402('0x56'),'AVG':_0x4402('0x86'),'GROUP_CONCAT':_0x4402('0x87'),'GROUP_CONCAT ASC':_0x4402('0x88'),'GROUP_CONCAT DESC':_0x4402('0x89')};var _0x3ec130={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x4402('0x58'),'HOUR':_0x4402('0x59'),'ROUND':_0x4402('0x5a'),'UNIX_TIMESTAMP':_0x4402('0x5b')};var _0x1b0980=function(_0x26d7a9){return!_[_0x4402('0x5c')](['IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY'],_0x26d7a9);};var _0x51b54a=function(_0x21d544){if(!_0x21d544||!_0x21d544['rules'][_0x4402('0x37')]){return'';}for(var _0x191a40='(',_0x4d8498=0x0;_0x4d8498<_0x21d544[_0x4402('0x61')][_0x4402('0x37')];_0x4d8498+=0x1){_0x4d8498>0x0&&(_0x191a40+='\x20'+_0x21d544[_0x4402('0x62')]+'\x20');_0x191a40+=_0x21d544['rules'][_0x4d8498][_0x4402('0x63')]?_0x51b54a(_0x21d544[_0x4402('0x61')][_0x4d8498][_0x4402('0x63')]):_0x21d544[_0x4402('0x61')][_0x4d8498][_0x4402('0x6e')]+'\x20'+_0x21d544[_0x4402('0x61')][_0x4d8498][_0x4402('0x64')]+(_0x1b0980(_0x21d544['rules'][_0x4d8498][_0x4402('0x64')])?'\x20'+_0x21d544['rules'][_0x4d8498][_0x4402('0x65')]:'');}return _0x191a40+')';};var _0x41b75d={'where':{'id':_0x5365ab['id']}},_0x2bd2f2,_0x4df828,_0x3e1e80,_0x176b3f,_0xc3c7fe;_0x41b75d=_[_0x4402('0x3c')]({},_0x41b75d,_0x9c984);return db[_0x4402('0x2e')][_0x4402('0x4f')](_0x41b75d)[_0x4402('0x25')](function(_0x11b1aa){if(_0x11b1aa){_0x2bd2f2=_0x11b1aa;return _0x11b1aa[_0x4402('0x8a')]();}return null;})[_0x4402('0x25')](function(_0x7ae123){if(_0x7ae123){if(!_0x7ae123[_0x4402('0x37')]){throw new db[(_0x4402('0x66'))][(_0x4402('0x67'))](_0x4402('0x68'),0x193);}_0x4df828=_0x7ae123;return db['AnalyticMetric'][_0x4402('0x6a')]({'raw':!![]});}return null;})[_0x4402('0x25')](function(_0xd59b4d){if(_0xd59b4d){_0x3e1e80=_['keyBy'](_0xd59b4d,'id');var _0x2a501a;var _0x2bbc0c=squel['select']();_0x2bbc0c[_0x4402('0x6c')](_0x2bd2f2[_0x4402('0x7b')]);for(var _0x5a2e33=0x0;_0x5a2e33<_0x4df828[_0x4402('0x37')];_0x5a2e33+=0x1){_0x2a501a=_0x4df828[_0x5a2e33][_0x4402('0x6d')]?_0x3e1e80[_0x4df828[_0x5a2e33]['MetricId']]['metric']:_0x4df828[_0x5a2e33]['field'];_0x2a501a=_0x4df828[_0x5a2e33][_0x4402('0x70')]?_[_0x4402('0x6f')](_0x2583e5[_0x4df828[_0x5a2e33]['function']],'%s',_0x2a501a):_0x2a501a;_0x2a501a=_0x4df828[_0x5a2e33][_0x4402('0x71')]?_['replace'](_0x3ec130[_0x4df828[_0x5a2e33]['format']],'%s',_0x2a501a):_0x2a501a;if(_0x4df828[_0x5a2e33][_0x4402('0x8b')]){_0x2bbc0c[_0x4402('0x63')](_0x2a501a);}_0x4df828[_0x5a2e33][_0x4402('0x72')]&&_0x2bbc0c[_0x4402('0x8c')](_0x2a501a,_0x4df828[_0x5a2e33][_0x4402('0x72')]===_0x4402('0x73')?![]:!![]);_0x2bbc0c[_0x4402('0x6e')](_0x2a501a,_0x4df828[_0x5a2e33]['alias']||_0x2a501a);}if(_0x2bd2f2[_0x4402('0x75')]){_0x2bd2f2[_0x4402('0x75')]=JSON[_0x4402('0x76')](_0x2bd2f2[_0x4402('0x75')]);for(var _0x1d393d=0x0;_0x1d393d<_0x2bd2f2[_0x4402('0x75')]['length'];_0x1d393d+=0x1){if(_0x2bd2f2['joins'][_0x1d393d][_0x4402('0x3d')]&&_[_0x4402('0x5c')](_0x1d391c,_0x2bd2f2['joins'][_0x1d393d][_0x4402('0x3d')])&&_0x2bd2f2[_0x4402('0x75')][_0x1d393d][_0x4402('0x77')]&&_0x2bd2f2[_0x4402('0x75')][_0x1d393d][_0x4402('0x78')]&&_0x2bd2f2[_0x4402('0x75')][_0x1d393d][_0x4402('0x79')]){_0x2bbc0c[_0x2bd2f2[_0x4402('0x75')][_0x1d393d]['type']](_0x2bd2f2[_0x4402('0x75')][_0x1d393d]['foreignTable'],null,util[_0x4402('0x71')](_0x4402('0x7a'),_0x2bd2f2[_0x4402('0x7b')],_0x2bd2f2[_0x4402('0x75')][_0x1d393d][_0x4402('0x77')],_0x2bd2f2['joins'][_0x1d393d][_0x4402('0x78')],_0x2bd2f2['joins'][_0x1d393d][_0x4402('0x79')]));}}}if(_0x2bd2f2[_0x4402('0x7c')]){_0x2bd2f2[_0x4402('0x7c')]=JSON['parse'](_0x2bd2f2[_0x4402('0x7c')]);_0x2bbc0c[_0x4402('0x3a')](_0x51b54a(_0x2bd2f2[_0x4402('0x7c')][_0x4402('0x63')]));}_0xc3c7fe=_0x2bbc0c[_0x4402('0x7d')]();_0x2bbc0c[_0x4402('0x20')](_0x173d57);_0x2bbc0c[_0x4402('0x1f')](0x0);logger['debug'](_0x4402('0x7e'),_0x2bbc0c[_0x4402('0x7f')]());return db[_0x4402('0x80')]['query'](_0x2bbc0c['toString'](),{'type':db['sequelize'][_0x4402('0x81')][_0x4402('0x82')]});}})[_0x4402('0x25')](function(_0x316e63){if(!_0x316e63[_0x4402('0x37')]){throw new db[(_0x4402('0x66'))][(_0x4402('0x67'))](_0x4402('0x8d'),0xcc);}if(_0x1d94f4[_0x4402('0x8e')]===_0x4402('0x8f')){return null;}var _0x1f5935=_[_0x4402('0x3c')](_0x1d94f4,{'name':_0x1d94f4[_0x4402('0x90')]||_0x1d94f4[_0x4402('0x2b')]||_0x2bd2f2[_0x4402('0x2b')],'basename':_0x1b79c6,'savename':util['format'](_0x4402('0x91'),_0x1d94f4['name']||_0x2bd2f2[_0x4402('0x2b')],require(_0x4402('0x92'))[_0x4402('0x93')](0x4),_0x1d94f4[_0x4402('0x8e')]||_0x4402('0x94')),'reportId':_0x2bd2f2['id'],'reportType':_0x4402('0x95')});return db[_0x4402('0x96')][_0x4402('0x46')](_0x1f5935,{'raw':!![]});})[_0x4402('0x25')](function(_0x31655e){if(_0x2bd2f2[_0x4402('0x7b')]===_0x4402('0x97')){_0xc3c7fe[_0x4402('0x3a')](_0x2bd2f2[_0x4402('0x7b')]+_0x4402('0x98'),_0x1d94f4[_0x4402('0x99')],_0x1d94f4[_0x4402('0x9a')]);}else{_0xc3c7fe['where'](_0x2bd2f2[_0x4402('0x7b')]+_0x4402('0x9b'),_0x1d94f4[_0x4402('0x99')],_0x1d94f4['endDate']);}if(_0x31655e){logger['info'](_0x4402('0x9c'),_0xc3c7fe[_0x4402('0x7f')]());require(_0x4402('0x9d'))[_0x4402('0x9e')](path[_0x4402('0x51')](__dirname,'../../components/export/',_0x31655e[_0x4402('0x8e')]),[_0x31655e['id'],_0xc3c7fe['toString'](),path['join'](__dirname,_0x4402('0x9f'),_0x31655e['savename']),_0x1b79c6]);return _0x31655e;}else{var _0x2a1955=squel[_0x4402('0xa0')]();_0x2a1955[_0x4402('0x6c')]('('+_0xc3c7fe[_0x4402('0x7f')]()+')','countTable');_0x2a1955[_0x4402('0x6e')]('COUNT(*)',_0x4402('0x1e'));_0xc3c7fe[_0x4402('0x20')](_0x1d94f4[_0x4402('0x20')]||_0x173d57);_0xc3c7fe[_0x4402('0x1f')](_0x1d94f4[_0x4402('0x1f')]||0x0);return db[_0x4402('0x80')]['query'](_0x2a1955[_0x4402('0x7f')](),{'type':db['sequelize'][_0x4402('0x81')][_0x4402('0x82')]})[_0x4402('0x25')](function(_0x349f0d){if(!_0x349f0d[_0x4402('0x37')]){_0x176b3f=0x0;}else{_0x176b3f=_0x349f0d[0x0][_0x4402('0x1e')]||0x0;}return db[_0x4402('0x80')][_0x4402('0x32')](_0xc3c7fe[_0x4402('0x7f')](),{'type':db[_0x4402('0x80')]['QueryTypes'][_0x4402('0x82')]});})[_0x4402('0x25')](function(_0x1a14c4){return{'rows':_0x1a14c4||[],'count':_0x176b3f};});}});}exports[_0x4402('0xa1')]=function(_0x19ace3,_0x38b045){return runReport(_0x19ace3[_0x4402('0x42')],_0x19ace3['query'],_0x19ace3[_0x4402('0x45')])[_0x4402('0x25')](respondWithResult(_0x38b045,null))['catch'](handleError(_0x38b045,null));};exports[_0x4402('0xa2')]=runReport;exports['query']=function(_0x16bd05,_0x9bde19){var _0x6288b1=0xa;var _0x197729=[_0x4402('0x51'),_0x4402('0x83'),_0x4402('0x52'),_0x4402('0x53')];var _0x25737b={'SUM':_0x4402('0x54'),'COUNT':_0x4402('0x55'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':'MAX(%s)','MIN':_0x4402('0x56'),'AVG':_0x4402('0x86'),'GROUP_CONCAT':_0x4402('0x87'),'GROUP_CONCAT ASC':_0x4402('0x88'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x3558a8={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x4402('0x58'),'HOUR':_0x4402('0x59'),'ROUND':_0x4402('0x5a'),'UNIX_TIMESTAMP':_0x4402('0x5b')};var _0x1034a1=function(_0x2ba297){return!_['includes']([_0x4402('0x5d'),'IS\x20NOT\x20NULL',_0x4402('0x5f'),'IS\x20NOT\x20EMPTY'],_0x2ba297);};var _0x2a794a=function(_0x4aed9b){if(!_0x4aed9b||!_0x4aed9b[_0x4402('0x61')][_0x4402('0x37')]){return'';}for(var _0x1fb295='(',_0x5c9a46=0x0;_0x5c9a46<_0x4aed9b[_0x4402('0x61')][_0x4402('0x37')];_0x5c9a46+=0x1){_0x5c9a46>0x0&&(_0x1fb295+='\x20'+_0x4aed9b[_0x4402('0x62')]+'\x20');_0x1fb295+=_0x4aed9b[_0x4402('0x61')][_0x5c9a46][_0x4402('0x63')]?_0x2a794a(_0x4aed9b[_0x4402('0x61')][_0x5c9a46]['group']):_0x4aed9b[_0x4402('0x61')][_0x5c9a46][_0x4402('0x6e')]+'\x20'+_0x4aed9b[_0x4402('0x61')][_0x5c9a46][_0x4402('0x64')]+(_0x1034a1(_0x4aed9b['rules'][_0x5c9a46]['condition'])?'\x20'+_0x4aed9b[_0x4402('0x61')][_0x5c9a46]['value']:'');}return _0x1fb295+')';};var _0x466ecc={'where':{'id':_0x16bd05['params']['id']}},_0xd26934,_0xc9af19,_0x524be6,_0x2d5e67,_0x5cb717;_0x466ecc=_['merge']({},_0x466ecc,_0x16bd05[_0x4402('0x45')]);return db['AnalyticDefaultReport'][_0x4402('0x4f')](_0x466ecc)[_0x4402('0x25')](function(_0x128288){if(_0x128288){_0xd26934=_0x128288;return _0x128288['getFields']();}return null;})[_0x4402('0x25')](function(_0x1cf1c9){if(_0x1cf1c9){if(!_0x1cf1c9['length']){throw new db[(_0x4402('0x66'))][(_0x4402('0x67'))](_0x4402('0x68'),0x193);}_0xc9af19=_0x1cf1c9;return db[_0x4402('0x69')][_0x4402('0x6a')]({'raw':!![]});}return null;})[_0x4402('0x25')](function(_0x3aa223){if(_0x3aa223){_0x524be6=_['keyBy'](_0x3aa223,'id');var _0x59cc1b;var _0x1b644f=squel[_0x4402('0xa0')]();_0x1b644f[_0x4402('0x6c')](_0xd26934[_0x4402('0x7b')]);for(var _0xc0974f=0x0;_0xc0974f<_0xc9af19[_0x4402('0x37')];_0xc0974f+=0x1){_0x59cc1b=_0xc9af19[_0xc0974f]['MetricId']?_0x524be6[_0xc9af19[_0xc0974f][_0x4402('0x6d')]]['metric']:_0xc9af19[_0xc0974f][_0x4402('0x6e')];_0x59cc1b=_0xc9af19[_0xc0974f]['function']?_[_0x4402('0x6f')](_0x25737b[_0xc9af19[_0xc0974f]['function']],'%s',_0x59cc1b):_0x59cc1b;_0x59cc1b=_0xc9af19[_0xc0974f]['format']?_[_0x4402('0x6f')](_0x3558a8[_0xc9af19[_0xc0974f][_0x4402('0x71')]],'%s',_0x59cc1b):_0x59cc1b;if(_0xc9af19[_0xc0974f][_0x4402('0x8b')]){_0x1b644f['group'](_0x59cc1b);}_0xc9af19[_0xc0974f][_0x4402('0x72')]&&_0x1b644f[_0x4402('0x8c')](_0x59cc1b,_0xc9af19[_0xc0974f]['orderBy']==='DESC'?![]:!![]);_0x1b644f['field'](_0x59cc1b,_0xc9af19[_0xc0974f][_0x4402('0x74')]||_0x59cc1b);}if(_0xd26934['joins']){_0xd26934[_0x4402('0x75')]=JSON[_0x4402('0x76')](_0xd26934[_0x4402('0x75')]);for(var _0x43423f=0x0;_0x43423f<_0xd26934[_0x4402('0x75')][_0x4402('0x37')];_0x43423f+=0x1){if(_0xd26934['joins'][_0x43423f][_0x4402('0x3d')]&&_[_0x4402('0x5c')](_0x197729,_0xd26934[_0x4402('0x75')][_0x43423f][_0x4402('0x3d')])&&_0xd26934[_0x4402('0x75')][_0x43423f][_0x4402('0x77')]&&_0xd26934[_0x4402('0x75')][_0x43423f][_0x4402('0x78')]&&_0xd26934[_0x4402('0x75')][_0x43423f][_0x4402('0x79')]){_0x1b644f[_0xd26934['joins'][_0x43423f]['type']](_0xd26934[_0x4402('0x75')][_0x43423f][_0x4402('0x78')],null,util[_0x4402('0x71')](_0x4402('0x7a'),_0xd26934[_0x4402('0x7b')],_0xd26934['joins'][_0x43423f][_0x4402('0x77')],_0xd26934[_0x4402('0x75')][_0x43423f]['foreignTable'],_0xd26934[_0x4402('0x75')][_0x43423f][_0x4402('0x79')]));}}}if(_0xd26934[_0x4402('0x7c')]){_0xd26934['conditions']=JSON[_0x4402('0x76')](_0xd26934[_0x4402('0x7c')]);_0x1b644f[_0x4402('0x3a')](_0x2a794a(_0xd26934[_0x4402('0x7c')][_0x4402('0x63')]));}_0x5cb717=_0x1b644f[_0x4402('0x7d')]();_0x1b644f[_0x4402('0x20')](_0x6288b1);_0x1b644f['offset'](0x0);logger[_0x4402('0xa3')](_0x4402('0x7e'),_0x1b644f[_0x4402('0x7f')]());return db[_0x4402('0x80')][_0x4402('0x32')](_0x1b644f[_0x4402('0x7f')](),{'type':db['sequelize'][_0x4402('0x81')][_0x4402('0x82')]});}})[_0x4402('0x25')](function(){return{'sql':_0x5cb717['toString']()};})[_0x4402('0x25')](respondWithResult(_0x9bde19,null))['catch'](handleError(_0x9bde19,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff