// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x70e4=['includes','IS\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','field','condition','value','getFields','Sequelize','ValidationErrorItem','findAll','keyBy','select','from','table','MetricId','function','replace','format','groupBy','orderBy','DESC','joins','parse','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','parentKey','conditions','group','clone','Limited\x20Query:','toString','sequelize','QueryTypes','HOUR(%s)','IS\x20NOT\x20NULL','operator','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','metric','alias','output','web','fullPath','%s-%s.%s','randomstring','generate','csv','default','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','Run\x20Query:','child_process','../../components/export/','../../files/reports','savename','countTable','SELECT','run','runReport','eml-format','rimraf','zip-dir','moment','bluebird','mustache','path','sox','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','dbH','status','end','json','count','offset','Content-Range','apply','save','get','DefaultReports','UserProfileResource','then','sendStatus','name','send','map','AnalyticDefaultReport','rawAttributes','fieldName','key','model','query','keys','intersection','attributes','fields','hasOwnProperty','limit','order','sort','where','filters','filter','merge','type','VIRTUAL','options','includeAll','include','show','params','length','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','UserProfileSection','find','userProfileId','catch','error','preview','join','left_join','right_join','cross_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','DATE(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)'];(function(_0x19bff2,_0x48446e){var _0x233991=function(_0x51b9fa){while(--_0x51b9fa){_0x19bff2['push'](_0x19bff2['shift']());}};_0x233991(++_0x48446e);}(_0x70e4,0x18b));var _0x470e=function(_0x4599b6,_0x40c254){_0x4599b6=_0x4599b6-0x0;var _0x2e014c=_0x70e4[_0x4599b6];return _0x2e014c;};'use strict';var emlformat=require(_0x470e('0x0'));var rimraf=require(_0x470e('0x1'));var zipdir=require(_0x470e('0x2'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0x470e('0x3'));var BPromise=require(_0x470e('0x4'));var Mustache=require(_0x470e('0x5'));var util=require('util');var path=require(_0x470e('0x6'));var sox=require(_0x470e('0x7'));var csv=require('to-csv');var ejs=require(_0x470e('0x8'));var fs=require('fs');var fs_extra=require(_0x470e('0x9'));var _=require(_0x470e('0xa'));var squel=require(_0x470e('0xb'));var crypto=require(_0x470e('0xc'));var jsforce=require(_0x470e('0xd'));var deskjs=require(_0x470e('0xe'));var toCsv=require(_0x470e('0xf'));var querystring=require(_0x470e('0x10'));var Papa=require(_0x470e('0x11'));var Redis=require(_0x470e('0x12'));var authService=require(_0x470e('0x13'));var qs=require(_0x470e('0x14'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x470e('0x15'));var logger=require(_0x470e('0x16'))(_0x470e('0x17'));var utils=require('../../config/utils');var config=require(_0x470e('0x18'));var licenseUtil=require(_0x470e('0x19'));var db=require(_0x470e('0x1a'))['db'];var dbH=require('../../mysqldb')[_0x470e('0x1b')];function respondWithStatusCode(_0x36c0bf,_0x3426a1){_0x3426a1=_0x3426a1||0xcc;return function(_0x2a83ac){if(_0x2a83ac){return _0x36c0bf['sendStatus'](_0x3426a1);}return _0x36c0bf[_0x470e('0x1c')](_0x3426a1)[_0x470e('0x1d')]();};}function respondWithResult(_0x55bd07,_0x113c96){_0x113c96=_0x113c96||0xc8;return function(_0x4c9317){if(_0x4c9317){return _0x55bd07[_0x470e('0x1c')](_0x113c96)[_0x470e('0x1e')](_0x4c9317);}};}function respondWithFilteredResult(_0x3f602b,_0x3ec8d7){return function(_0x3f3f25){if(_0x3f3f25){var _0x5ce828=_0x3f3f25[_0x470e('0x1f')],_0x22fbcf=_0x3ec8d7[_0x470e('0x20')],_0x3be174=_0x3ec8d7[_0x470e('0x20')]+_0x3ec8d7['limit'],_0x524850;if(_0x3be174>=_0x5ce828){_0x3be174=_0x5ce828;_0x524850=0xc8;}else{_0x524850=0xce;}_0x3f602b['status'](_0x524850);return _0x3f602b['set'](_0x470e('0x21'),_0x22fbcf+'-'+_0x3be174+'/'+_0x5ce828)[_0x470e('0x1e')](_0x3f3f25);}return null;};}function patchUpdates(_0x262e34){return function(_0x4eec7d){try{jsonpatch[_0x470e('0x22')](_0x4eec7d,_0x262e34,!![]);}catch(_0x3278c3){return BPromise['reject'](_0x3278c3);}return _0x4eec7d[_0x470e('0x23')]();};}function saveUpdates(_0x35247b,_0x3978af){return function(_0x3d680c){if(_0x3d680c){return _0x3d680c['update'](_0x35247b)['then'](function(_0x2b3c5d){return _0x2b3c5d;});}return null;};}function removeEntity(_0x4f8cfd,_0x1ad929){return function(_0x1d6017){if(_0x1d6017){return _0x1d6017['destroy']()['then'](function(){var _0x2e7ecb=_0x1d6017[_0x470e('0x24')]({'plain':!![]});var _0x413355=_0x470e('0x25');return db[_0x470e('0x26')]['destroy']({'where':{'type':_0x413355,'resourceId':_0x2e7ecb['id']}})[_0x470e('0x27')](function(){return _0x1d6017;});})[_0x470e('0x27')](function(){_0x4f8cfd[_0x470e('0x1c')](0xcc)[_0x470e('0x1d')]();});}};}function handleEntityNotFound(_0x5715e6,_0x29b2a9){return function(_0x81bfe8){if(!_0x81bfe8){_0x5715e6[_0x470e('0x28')](0x194);}return _0x81bfe8;};}function handleError(_0x3c137d,_0x58cce3){_0x58cce3=_0x58cce3||0x1f4;return function(_0x5a014a){logger['error'](_0x5a014a['stack']);if(_0x5a014a[_0x470e('0x29')]){delete _0x5a014a[_0x470e('0x29')];}_0x3c137d[_0x470e('0x1c')](_0x58cce3)[_0x470e('0x2a')](_0x5a014a);};}exports['index']=function(_0x20eea1,_0x3657c2){var _0x2fd7ee={},_0xa5f994={},_0x539ecc={'count':0x0,'rows':[]};var _0xbeda57=_[_0x470e('0x2b')](db[_0x470e('0x2c')][_0x470e('0x2d')],function(_0x2b9a45){return{'name':_0x2b9a45[_0x470e('0x2e')],'type':_0x2b9a45['type'][_0x470e('0x2f')]};});_0xa5f994[_0x470e('0x30')]=_[_0x470e('0x2b')](_0xbeda57,_0x470e('0x29'));_0xa5f994[_0x470e('0x31')]=_[_0x470e('0x32')](_0x20eea1[_0x470e('0x31')]);_0xa5f994['filters']=_[_0x470e('0x33')](_0xa5f994[_0x470e('0x30')],_0xa5f994['query']);_0x2fd7ee[_0x470e('0x34')]=_[_0x470e('0x33')](_0xa5f994[_0x470e('0x30')],qs[_0x470e('0x35')](_0x20eea1[_0x470e('0x31')][_0x470e('0x35')]));_0x2fd7ee[_0x470e('0x34')]=_0x2fd7ee[_0x470e('0x34')]['length']?_0x2fd7ee[_0x470e('0x34')]:_0xa5f994['model'];if(!_0x20eea1[_0x470e('0x31')][_0x470e('0x36')]('nolimit')){_0x2fd7ee['limit']=qs[_0x470e('0x37')](_0x20eea1[_0x470e('0x31')][_0x470e('0x37')]);_0x2fd7ee['offset']=qs[_0x470e('0x20')](_0x20eea1['query'][_0x470e('0x20')]);}_0x2fd7ee[_0x470e('0x38')]=qs['sort'](_0x20eea1[_0x470e('0x31')][_0x470e('0x39')]);_0x2fd7ee[_0x470e('0x3a')]=qs[_0x470e('0x3b')](_['pick'](_0x20eea1['query'],_0xa5f994[_0x470e('0x3b')]),_0xbeda57);if(_0x20eea1['query'][_0x470e('0x3c')]){_0x2fd7ee[_0x470e('0x3a')]=_[_0x470e('0x3d')](_0x2fd7ee[_0x470e('0x3a')],{'$or':_['map'](_0xbeda57,function(_0x4d0d31){if(_0x4d0d31[_0x470e('0x3e')]!==_0x470e('0x3f')){var _0x2fd462={};_0x2fd462[_0x4d0d31[_0x470e('0x29')]]={'$like':'%'+_0x20eea1[_0x470e('0x31')]['filter']+'%'};return _0x2fd462;}})});}_0x2fd7ee=_['merge']({},_0x2fd7ee,_0x20eea1[_0x470e('0x40')]);var _0x588ed5={'where':_0x2fd7ee[_0x470e('0x3a')]};return db[_0x470e('0x2c')][_0x470e('0x1f')](_0x588ed5)[_0x470e('0x27')](function(_0x304140){_0x539ecc['count']=_0x304140;if(_0x20eea1['query'][_0x470e('0x41')]){_0x2fd7ee[_0x470e('0x42')]=[{'all':!![]}];}return db['AnalyticDefaultReport']['findAll'](_0x2fd7ee);})[_0x470e('0x27')](function(_0xaa456c){_0x539ecc['rows']=_0xaa456c;return _0x539ecc;})[_0x470e('0x27')](respondWithFilteredResult(_0x3657c2,_0x2fd7ee))['catch'](handleError(_0x3657c2,null));};exports[_0x470e('0x43')]=function(_0x5ccae3,_0x18a140){var _0x463469={'raw':!![],'where':{'id':_0x5ccae3[_0x470e('0x44')]['id']}},_0x4d0d58={};_0x4d0d58[_0x470e('0x30')]=_[_0x470e('0x32')](db[_0x470e('0x2c')][_0x470e('0x2d')]);_0x4d0d58[_0x470e('0x31')]=_[_0x470e('0x32')](_0x5ccae3[_0x470e('0x31')]);_0x4d0d58['filters']=_[_0x470e('0x33')](_0x4d0d58['model'],_0x4d0d58[_0x470e('0x31')]);_0x463469[_0x470e('0x34')]=_[_0x470e('0x33')](_0x4d0d58[_0x470e('0x30')],qs[_0x470e('0x35')](_0x5ccae3[_0x470e('0x31')][_0x470e('0x35')]));_0x463469[_0x470e('0x34')]=_0x463469['attributes'][_0x470e('0x45')]?_0x463469[_0x470e('0x34')]:_0x4d0d58[_0x470e('0x30')];if(_0x5ccae3['query'][_0x470e('0x41')]){_0x463469['include']=[{'all':!![]}];}_0x463469=_['merge']({},_0x463469,_0x5ccae3['options']);return db[_0x470e('0x2c')]['find'](_0x463469)[_0x470e('0x27')](handleEntityNotFound(_0x18a140,null))[_0x470e('0x27')](respondWithResult(_0x18a140,null))['catch'](handleError(_0x18a140,null));};exports[_0x470e('0x46')]=function(_0x5d3112,_0x58e437){return db[_0x470e('0x2c')][_0x470e('0x46')](_0x5d3112[_0x470e('0x47')],{})[_0x470e('0x27')](function(_0x5b6134){var _0x1b450f=_0x5d3112[_0x470e('0x48')][_0x470e('0x24')]({'plain':!![]});if(!_0x1b450f)throw new Error(_0x470e('0x49'));if(_0x1b450f[_0x470e('0x4a')]===_0x470e('0x48')){var _0x5942ca=_0x5b6134['get']({'plain':!![]});var _0x4fc6c2=_0x470e('0x4b');return db[_0x470e('0x4c')][_0x470e('0x4d')]({'where':{'name':_0x4fc6c2,'userProfileId':_0x1b450f[_0x470e('0x4e')]},'raw':!![]})[_0x470e('0x27')](function(_0x521845){if(_0x521845&&_0x521845['autoAssociation']===0x0){return db['UserProfileResource'][_0x470e('0x46')]({'name':_0x5942ca[_0x470e('0x29')],'resourceId':_0x5942ca['id'],'type':_0x470e('0x25'),'sectionId':_0x521845['id']},{})[_0x470e('0x27')](function(){return _0x5b6134;});}else{return _0x5b6134;}})[_0x470e('0x4f')](function(_0x2db527){logger[_0x470e('0x50')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x2db527);throw _0x2db527;});}return _0x5b6134;})[_0x470e('0x27')](respondWithResult(_0x58e437,0xc9))[_0x470e('0x4f')](handleError(_0x58e437,null));};exports['update']=function(_0x4c4181,_0x4174de){if(_0x4c4181[_0x470e('0x47')]['id']){delete _0x4c4181[_0x470e('0x47')]['id'];}return db[_0x470e('0x2c')][_0x470e('0x4d')]({'where':{'id':_0x4c4181['params']['id']}})[_0x470e('0x27')](handleEntityNotFound(_0x4174de,null))['then'](saveUpdates(_0x4c4181[_0x470e('0x47')],null))['then'](respondWithResult(_0x4174de,null))[_0x470e('0x4f')](handleError(_0x4174de,null));};exports['destroy']=function(_0x525783,_0x4519b6){return db[_0x470e('0x2c')][_0x470e('0x4d')]({'where':{'id':_0x525783[_0x470e('0x44')]['id']}})[_0x470e('0x27')](handleEntityNotFound(_0x4519b6,null))['then'](removeEntity(_0x4519b6,null))['catch'](handleError(_0x4519b6,null));};exports[_0x470e('0x51')]=function(_0x10a5e7,_0x1259e2){var _0x150127=0xa;var _0x237832=[_0x470e('0x52'),_0x470e('0x53'),_0x470e('0x54'),_0x470e('0x55')];var _0x25a42b={'SUM':_0x470e('0x56'),'COUNT':_0x470e('0x57'),'COUNT DISTINCT':_0x470e('0x58'),'MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':_0x470e('0x59'),'GROUP_CONCAT':_0x470e('0x5a'),'GROUP_CONCAT ASC':_0x470e('0x5b'),'GROUP_CONCAT DESC':_0x470e('0x5c')};var _0x2b7d46={'SEC_TO_TIME':_0x470e('0x5d'),'DATE':_0x470e('0x5e'),'HOUR':'HOUR(%s)','ROUND':_0x470e('0x5f'),'UNIX_TIMESTAMP':_0x470e('0x60')};var _0x55544a=function(_0x9af88d){return!_[_0x470e('0x61')]([_0x470e('0x62'),'IS\x20NOT\x20NULL',_0x470e('0x63'),_0x470e('0x64')],_0x9af88d);};var _0x481b51=function(_0x3e20ad){if(!_0x3e20ad||!_0x3e20ad[_0x470e('0x65')][_0x470e('0x45')]){return'';}for(var _0x3ec3b9='(',_0x5c98d8=0x0;_0x5c98d8<_0x3e20ad[_0x470e('0x65')][_0x470e('0x45')];_0x5c98d8+=0x1){_0x5c98d8>0x0&&(_0x3ec3b9+='\x20'+_0x3e20ad['operator']+'\x20');_0x3ec3b9+=_0x3e20ad['rules'][_0x5c98d8]['group']?_0x481b51(_0x3e20ad['rules'][_0x5c98d8]['group']):_0x3e20ad['rules'][_0x5c98d8][_0x470e('0x66')]+'\x20'+_0x3e20ad[_0x470e('0x65')][_0x5c98d8][_0x470e('0x67')]+(_0x55544a(_0x3e20ad['rules'][_0x5c98d8][_0x470e('0x67')])?'\x20'+_0x3e20ad[_0x470e('0x65')][_0x5c98d8][_0x470e('0x68')]:'');}return _0x3ec3b9+')';};var _0x2270db={'where':{'id':_0x10a5e7[_0x470e('0x44')]['id']}},_0xaf5305,_0x577bfd,_0x3024bd,_0x165442,_0x21ba03;_0x2270db=_[_0x470e('0x3d')]({},_0x2270db,_0x10a5e7[_0x470e('0x40')]);return db[_0x470e('0x2c')][_0x470e('0x4d')](_0x2270db)['then'](function(_0xd8c25b){if(_0xd8c25b){_0xaf5305=_0xd8c25b;return _0xd8c25b[_0x470e('0x69')]();}return null;})[_0x470e('0x27')](function(_0x4f5b0c){if(_0x4f5b0c){if(!_0x4f5b0c[_0x470e('0x45')]){throw new db[(_0x470e('0x6a'))][(_0x470e('0x6b'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x577bfd=_0x4f5b0c;return db['AnalyticMetric'][_0x470e('0x6c')]({'raw':!![]});}return null;})[_0x470e('0x27')](function(_0x33a586){if(_0x33a586){_0x3024bd=_[_0x470e('0x6d')](_0x33a586,'id');var _0x1c2cba;var _0x5420ef=squel[_0x470e('0x6e')]();_0x5420ef[_0x470e('0x6f')](_0xaf5305[_0x470e('0x70')]);for(var _0x14cef3=0x0;_0x14cef3<_0x577bfd[_0x470e('0x45')];_0x14cef3+=0x1){_0x1c2cba=_0x577bfd[_0x14cef3][_0x470e('0x71')]?_0x3024bd[_0x577bfd[_0x14cef3]['MetricId']]['metric']:_0x577bfd[_0x14cef3][_0x470e('0x66')];_0x1c2cba=_0x577bfd[_0x14cef3][_0x470e('0x72')]?_[_0x470e('0x73')](_0x25a42b[_0x577bfd[_0x14cef3][_0x470e('0x72')]],'%s',_0x1c2cba):_0x1c2cba;_0x1c2cba=_0x577bfd[_0x14cef3][_0x470e('0x74')]?_['replace'](_0x2b7d46[_0x577bfd[_0x14cef3][_0x470e('0x74')]],'%s',_0x1c2cba):_0x1c2cba;if(_0x577bfd[_0x14cef3][_0x470e('0x75')]){_0x5420ef['group'](_0x1c2cba);}_0x577bfd[_0x14cef3][_0x470e('0x76')]&&_0x5420ef[_0x470e('0x38')](_0x1c2cba,_0x577bfd[_0x14cef3]['orderBy']===_0x470e('0x77')?![]:!![]);_0x5420ef[_0x470e('0x66')](_0x1c2cba,_0x577bfd[_0x14cef3]['alias']||_0x1c2cba);}if(_0xaf5305[_0x470e('0x78')]){_0xaf5305[_0x470e('0x78')]=JSON[_0x470e('0x79')](_0xaf5305[_0x470e('0x78')]);for(var _0x252b34=0x0;_0x252b34<_0xaf5305['joins']['length'];_0x252b34+=0x1){if(_0xaf5305['joins'][_0x252b34][_0x470e('0x3e')]&&_[_0x470e('0x61')](_0x237832,_0xaf5305[_0x470e('0x78')][_0x252b34]['type'])&&_0xaf5305[_0x470e('0x78')][_0x252b34]['parentKey']&&_0xaf5305['joins'][_0x252b34][_0x470e('0x7a')]&&_0xaf5305[_0x470e('0x78')][_0x252b34][_0x470e('0x7b')]){_0x5420ef[_0xaf5305[_0x470e('0x78')][_0x252b34][_0x470e('0x3e')]](_0xaf5305[_0x470e('0x78')][_0x252b34]['foreignTable'],null,util[_0x470e('0x74')](_0x470e('0x7c'),_0xaf5305[_0x470e('0x70')],_0xaf5305[_0x470e('0x78')][_0x252b34][_0x470e('0x7d')],_0xaf5305[_0x470e('0x78')][_0x252b34][_0x470e('0x7a')],_0xaf5305[_0x470e('0x78')][_0x252b34][_0x470e('0x7b')]));}}}if(_0xaf5305['conditions']){_0xaf5305[_0x470e('0x7e')]=JSON[_0x470e('0x79')](_0xaf5305['conditions']);_0x5420ef[_0x470e('0x3a')](_0x481b51(_0xaf5305[_0x470e('0x7e')][_0x470e('0x7f')]));}_0x21ba03=_0x5420ef[_0x470e('0x80')]();_0x5420ef[_0x470e('0x37')](_0x150127);_0x5420ef[_0x470e('0x20')](0x0);logger['debug'](_0x470e('0x81'),_0x5420ef[_0x470e('0x82')]());return dbH[_0x470e('0x83')][_0x470e('0x31')](_0x5420ef['toString'](),{'type':dbH['sequelize'][_0x470e('0x84')]['SELECT']});}})[_0x470e('0x27')](respondWithResult(_0x1259e2,null))[_0x470e('0x4f')](handleError(_0x1259e2,null));};function runReport(_0x315c15,_0x2c1bc8,_0x339c0b){var _0x244240=_0x2c1bc8[_0x470e('0x29')];var _0x500ed8=0xa;var _0x4876c1=[_0x470e('0x52'),_0x470e('0x53'),'right_join',_0x470e('0x55')];var _0xf27d45={'SUM':_0x470e('0x56'),'COUNT':_0x470e('0x57'),'COUNT DISTINCT':_0x470e('0x58'),'MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':'AVG(%s)','GROUP_CONCAT':_0x470e('0x5a'),'GROUP_CONCAT ASC':_0x470e('0x5b'),'GROUP_CONCAT DESC':_0x470e('0x5c')};var _0x2e9c67={'SEC_TO_TIME':_0x470e('0x5d'),'DATE':_0x470e('0x5e'),'HOUR':_0x470e('0x85'),'ROUND':_0x470e('0x5f'),'UNIX_TIMESTAMP':_0x470e('0x60')};var _0x40d309=function(_0x4ad7a5){return!_[_0x470e('0x61')](['IS\x20NULL',_0x470e('0x86'),_0x470e('0x63'),_0x470e('0x64')],_0x4ad7a5);};var _0x531df5=function(_0x5a5d19){if(!_0x5a5d19||!_0x5a5d19[_0x470e('0x65')]['length']){return'';}for(var _0x1dfa5a='(',_0x422442=0x0;_0x422442<_0x5a5d19['rules'][_0x470e('0x45')];_0x422442+=0x1){_0x422442>0x0&&(_0x1dfa5a+='\x20'+_0x5a5d19[_0x470e('0x87')]+'\x20');_0x1dfa5a+=_0x5a5d19['rules'][_0x422442][_0x470e('0x7f')]?_0x531df5(_0x5a5d19['rules'][_0x422442]['group']):_0x5a5d19[_0x470e('0x65')][_0x422442][_0x470e('0x66')]+'\x20'+_0x5a5d19[_0x470e('0x65')][_0x422442]['condition']+(_0x40d309(_0x5a5d19[_0x470e('0x65')][_0x422442][_0x470e('0x67')])?'\x20'+_0x5a5d19['rules'][_0x422442]['value']:'');}return _0x1dfa5a+')';};var _0x535502={'where':{'id':_0x315c15['id']}},_0x42ece7,_0x30a451,_0x597113,_0x3f3376,_0x163d3e;_0x535502=_[_0x470e('0x3d')]({},_0x535502,_0x339c0b);return db['AnalyticDefaultReport'][_0x470e('0x4d')](_0x535502)[_0x470e('0x27')](function(_0x385b13){if(_0x385b13){_0x42ece7=_0x385b13;return _0x385b13[_0x470e('0x69')]();}return null;})['then'](function(_0x1d0c60){if(_0x1d0c60){if(!_0x1d0c60[_0x470e('0x45')]){throw new db[(_0x470e('0x6a'))]['ValidationErrorItem'](_0x470e('0x88'),0x193);}_0x30a451=_0x1d0c60;return db[_0x470e('0x89')][_0x470e('0x6c')]({'raw':!![]});}return null;})['then'](function(_0xadefae){if(_0xadefae){_0x597113=_[_0x470e('0x6d')](_0xadefae,'id');var _0x36d02c;var _0x225cef=squel[_0x470e('0x6e')]();_0x225cef[_0x470e('0x6f')](_0x42ece7[_0x470e('0x70')]);for(var _0x464115=0x0;_0x464115<_0x30a451[_0x470e('0x45')];_0x464115+=0x1){_0x36d02c=_0x30a451[_0x464115][_0x470e('0x71')]?_0x597113[_0x30a451[_0x464115][_0x470e('0x71')]][_0x470e('0x8a')]:_0x30a451[_0x464115]['field'];_0x36d02c=_0x30a451[_0x464115][_0x470e('0x72')]?_[_0x470e('0x73')](_0xf27d45[_0x30a451[_0x464115][_0x470e('0x72')]],'%s',_0x36d02c):_0x36d02c;_0x36d02c=_0x30a451[_0x464115][_0x470e('0x74')]?_[_0x470e('0x73')](_0x2e9c67[_0x30a451[_0x464115][_0x470e('0x74')]],'%s',_0x36d02c):_0x36d02c;if(_0x30a451[_0x464115]['groupBy']){_0x225cef['group'](_0x36d02c);}_0x30a451[_0x464115][_0x470e('0x76')]&&_0x225cef[_0x470e('0x38')](_0x36d02c,_0x30a451[_0x464115]['orderBy']===_0x470e('0x77')?![]:!![]);_0x225cef[_0x470e('0x66')](_0x36d02c,_0x30a451[_0x464115][_0x470e('0x8b')]||_0x36d02c);}if(_0x42ece7[_0x470e('0x78')]){_0x42ece7['joins']=JSON['parse'](_0x42ece7[_0x470e('0x78')]);for(var _0x13c745=0x0;_0x13c745<_0x42ece7[_0x470e('0x78')]['length'];_0x13c745+=0x1){if(_0x42ece7[_0x470e('0x78')][_0x13c745][_0x470e('0x3e')]&&_['includes'](_0x4876c1,_0x42ece7[_0x470e('0x78')][_0x13c745][_0x470e('0x3e')])&&_0x42ece7[_0x470e('0x78')][_0x13c745]['parentKey']&&_0x42ece7[_0x470e('0x78')][_0x13c745][_0x470e('0x7a')]&&_0x42ece7[_0x470e('0x78')][_0x13c745][_0x470e('0x7b')]){_0x225cef[_0x42ece7[_0x470e('0x78')][_0x13c745][_0x470e('0x3e')]](_0x42ece7[_0x470e('0x78')][_0x13c745][_0x470e('0x7a')],null,util[_0x470e('0x74')]('%s.%s\x20=\x20%s.%s',_0x42ece7[_0x470e('0x70')],_0x42ece7[_0x470e('0x78')][_0x13c745][_0x470e('0x7d')],_0x42ece7['joins'][_0x13c745][_0x470e('0x7a')],_0x42ece7[_0x470e('0x78')][_0x13c745]['foreignKey']));}}}if(_0x42ece7['conditions']){_0x42ece7[_0x470e('0x7e')]=JSON[_0x470e('0x79')](_0x42ece7[_0x470e('0x7e')]);_0x225cef['where'](_0x531df5(_0x42ece7[_0x470e('0x7e')][_0x470e('0x7f')]));}_0x163d3e=_0x225cef[_0x470e('0x80')]();_0x225cef['limit'](_0x500ed8);_0x225cef[_0x470e('0x20')](0x0);return;}})['then'](function(){if(_0x2c1bc8[_0x470e('0x8c')]===_0x470e('0x8d')){return null;}var _0x95c485=_[_0x470e('0x3d')](_0x2c1bc8,{'name':_0x2c1bc8[_0x470e('0x8e')]||_0x2c1bc8[_0x470e('0x29')]||_0x42ece7[_0x470e('0x29')],'basename':_0x244240,'savename':util[_0x470e('0x74')](_0x470e('0x8f'),_0x2c1bc8[_0x470e('0x29')]||_0x42ece7['name'],require(_0x470e('0x90'))[_0x470e('0x91')](0x4),_0x2c1bc8[_0x470e('0x8c')]||_0x470e('0x92')),'reportId':_0x42ece7['id'],'reportType':_0x470e('0x93')});return db[_0x470e('0x94')][_0x470e('0x46')](_0x95c485,{'raw':!![]});})[_0x470e('0x27')](function(_0x2c05e4){if(_0x42ece7[_0x470e('0x70')]===_0x470e('0x95')){_0x163d3e['where'](_0x42ece7[_0x470e('0x70')]+_0x470e('0x96'),_0x2c1bc8[_0x470e('0x97')],_0x2c1bc8[_0x470e('0x98')]);}else{_0x163d3e[_0x470e('0x3a')](_0x42ece7[_0x470e('0x70')]+_0x470e('0x99'),_0x2c1bc8[_0x470e('0x97')],_0x2c1bc8[_0x470e('0x98')]);}if(_0x2c05e4){logger[_0x470e('0x9a')](_0x470e('0x9b'),_0x163d3e[_0x470e('0x82')]());require(_0x470e('0x9c'))['fork'](path['join'](__dirname,_0x470e('0x9d'),_0x2c05e4[_0x470e('0x8c')]),[_0x2c05e4['id'],_0x163d3e[_0x470e('0x82')](),path[_0x470e('0x52')](__dirname,_0x470e('0x9e'),_0x2c05e4[_0x470e('0x9f')]),_0x244240]);return _0x2c05e4;}else{var _0x310e43=squel[_0x470e('0x6e')]();_0x310e43['from']('('+_0x163d3e[_0x470e('0x82')]()+')',_0x470e('0xa0'));_0x310e43[_0x470e('0x66')]('COUNT(*)','count');_0x163d3e[_0x470e('0x37')](_0x2c1bc8[_0x470e('0x37')]||_0x500ed8);_0x163d3e[_0x470e('0x20')](_0x2c1bc8[_0x470e('0x20')]||0x0);return dbH['sequelize']['query'](_0x310e43[_0x470e('0x82')](),{'type':dbH[_0x470e('0x83')][_0x470e('0x84')][_0x470e('0xa1')]})[_0x470e('0x27')](function(_0x31dd71){if(!_0x31dd71[_0x470e('0x45')]){_0x3f3376=0x0;}else{_0x3f3376=_0x31dd71[0x0][_0x470e('0x1f')]||0x0;}return dbH['sequelize']['query'](_0x163d3e['toString'](),{'type':dbH['sequelize'][_0x470e('0x84')][_0x470e('0xa1')]});})['then'](function(_0x33945c){return{'rows':_0x33945c||[],'count':_0x3f3376};});}});}exports[_0x470e('0xa2')]=function(_0x3aa36a,_0x5424d6){return runReport(_0x3aa36a['params'],_0x3aa36a[_0x470e('0x31')],_0x3aa36a['options'])[_0x470e('0x27')](respondWithResult(_0x5424d6,null))[_0x470e('0x4f')](handleError(_0x5424d6,null));};exports[_0x470e('0xa3')]=runReport;exports['query']=function(_0x13aaaa,_0x5b4070){var _0x301bf8=0xa;var _0x32d392=['join','left_join','right_join','cross_join'];var _0x2b7a00={'SUM':_0x470e('0x56'),'COUNT':_0x470e('0x57'),'COUNT DISTINCT':_0x470e('0x58'),'MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':'AVG(%s)','GROUP_CONCAT':_0x470e('0x5a'),'GROUP_CONCAT ASC':_0x470e('0x5b'),'GROUP_CONCAT DESC':_0x470e('0x5c')};var _0x3bca89={'SEC_TO_TIME':_0x470e('0x5d'),'DATE':_0x470e('0x5e'),'HOUR':_0x470e('0x85'),'ROUND':_0x470e('0x5f'),'UNIX_TIMESTAMP':_0x470e('0x60')};var _0x297621=function(_0xbdb110){return!_['includes']([_0x470e('0x62'),_0x470e('0x86'),_0x470e('0x63'),'IS\x20NOT\x20EMPTY'],_0xbdb110);};var _0x4e8ee9=function(_0x3bb331){if(!_0x3bb331||!_0x3bb331[_0x470e('0x65')]['length']){return'';}for(var _0x411cd0='(',_0x1290ef=0x0;_0x1290ef<_0x3bb331[_0x470e('0x65')][_0x470e('0x45')];_0x1290ef+=0x1){_0x1290ef>0x0&&(_0x411cd0+='\x20'+_0x3bb331[_0x470e('0x87')]+'\x20');_0x411cd0+=_0x3bb331['rules'][_0x1290ef][_0x470e('0x7f')]?_0x4e8ee9(_0x3bb331[_0x470e('0x65')][_0x1290ef][_0x470e('0x7f')]):_0x3bb331['rules'][_0x1290ef][_0x470e('0x66')]+'\x20'+_0x3bb331['rules'][_0x1290ef][_0x470e('0x67')]+(_0x297621(_0x3bb331[_0x470e('0x65')][_0x1290ef][_0x470e('0x67')])?'\x20'+_0x3bb331[_0x470e('0x65')][_0x1290ef][_0x470e('0x68')]:'');}return _0x411cd0+')';};var _0x21e89d={'where':{'id':_0x13aaaa['params']['id']}},_0x19a1f4,_0x2893f4,_0x392185,_0x4878fe,_0x15b964;_0x21e89d=_[_0x470e('0x3d')]({},_0x21e89d,_0x13aaaa[_0x470e('0x40')]);return db[_0x470e('0x2c')][_0x470e('0x4d')](_0x21e89d)[_0x470e('0x27')](function(_0x58c10d){if(_0x58c10d){_0x19a1f4=_0x58c10d;return _0x58c10d[_0x470e('0x69')]();}return null;})[_0x470e('0x27')](function(_0x2fe682){if(_0x2fe682){if(!_0x2fe682[_0x470e('0x45')]){throw new db[(_0x470e('0x6a'))][(_0x470e('0x6b'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x2893f4=_0x2fe682;return db[_0x470e('0x89')][_0x470e('0x6c')]({'raw':!![]});}return null;})['then'](function(_0x473dfe){if(_0x473dfe){_0x392185=_[_0x470e('0x6d')](_0x473dfe,'id');var _0x2ebb04;var _0x4a85dc=squel[_0x470e('0x6e')]();_0x4a85dc[_0x470e('0x6f')](_0x19a1f4[_0x470e('0x70')]);for(var _0x2d240d=0x0;_0x2d240d<_0x2893f4['length'];_0x2d240d+=0x1){_0x2ebb04=_0x2893f4[_0x2d240d]['MetricId']?_0x392185[_0x2893f4[_0x2d240d][_0x470e('0x71')]][_0x470e('0x8a')]:_0x2893f4[_0x2d240d][_0x470e('0x66')];_0x2ebb04=_0x2893f4[_0x2d240d][_0x470e('0x72')]?_[_0x470e('0x73')](_0x2b7a00[_0x2893f4[_0x2d240d]['function']],'%s',_0x2ebb04):_0x2ebb04;_0x2ebb04=_0x2893f4[_0x2d240d][_0x470e('0x74')]?_[_0x470e('0x73')](_0x3bca89[_0x2893f4[_0x2d240d][_0x470e('0x74')]],'%s',_0x2ebb04):_0x2ebb04;if(_0x2893f4[_0x2d240d][_0x470e('0x75')]){_0x4a85dc[_0x470e('0x7f')](_0x2ebb04);}_0x2893f4[_0x2d240d][_0x470e('0x76')]&&_0x4a85dc[_0x470e('0x38')](_0x2ebb04,_0x2893f4[_0x2d240d][_0x470e('0x76')]==='DESC'?![]:!![]);_0x4a85dc['field'](_0x2ebb04,_0x2893f4[_0x2d240d]['alias']||_0x2ebb04);}if(_0x19a1f4[_0x470e('0x78')]){_0x19a1f4[_0x470e('0x78')]=JSON['parse'](_0x19a1f4[_0x470e('0x78')]);for(var _0xbcdf82=0x0;_0xbcdf82<_0x19a1f4[_0x470e('0x78')][_0x470e('0x45')];_0xbcdf82+=0x1){if(_0x19a1f4[_0x470e('0x78')][_0xbcdf82]['type']&&_['includes'](_0x32d392,_0x19a1f4[_0x470e('0x78')][_0xbcdf82][_0x470e('0x3e')])&&_0x19a1f4[_0x470e('0x78')][_0xbcdf82][_0x470e('0x7d')]&&_0x19a1f4[_0x470e('0x78')][_0xbcdf82][_0x470e('0x7a')]&&_0x19a1f4[_0x470e('0x78')][_0xbcdf82]['foreignKey']){_0x4a85dc[_0x19a1f4[_0x470e('0x78')][_0xbcdf82][_0x470e('0x3e')]](_0x19a1f4[_0x470e('0x78')][_0xbcdf82]['foreignTable'],null,util[_0x470e('0x74')](_0x470e('0x7c'),_0x19a1f4['table'],_0x19a1f4[_0x470e('0x78')][_0xbcdf82][_0x470e('0x7d')],_0x19a1f4['joins'][_0xbcdf82][_0x470e('0x7a')],_0x19a1f4[_0x470e('0x78')][_0xbcdf82]['foreignKey']));}}}if(_0x19a1f4['conditions']){_0x19a1f4['conditions']=JSON[_0x470e('0x79')](_0x19a1f4[_0x470e('0x7e')]);_0x4a85dc[_0x470e('0x3a')](_0x4e8ee9(_0x19a1f4[_0x470e('0x7e')][_0x470e('0x7f')]));}_0x15b964=_0x4a85dc[_0x470e('0x80')]();_0x4a85dc[_0x470e('0x37')](_0x301bf8);_0x4a85dc[_0x470e('0x20')](0x0);logger['debug'](_0x470e('0x81'),_0x4a85dc['toString']());return dbH[_0x470e('0x83')][_0x470e('0x31')](_0x4a85dc['toString'](),{'type':dbH['sequelize'][_0x470e('0x84')][_0x470e('0xa1')]});}})[_0x470e('0x27')](function(){return{'sql':_0x15b964[_0x470e('0x82')]()};})[_0x470e('0x27')](respondWithResult(_0x5b4070,null))[_0x470e('0x4f')](handleError(_0x5b4070,null));};
\ No newline at end of file
+var _0xd344=['type','key','model','query','keys','filters','intersection','fields','attributes','length','nolimit','order','sort','where','pick','merge','VIRTUAL','filter','options','count','includeAll','include','rows','catch','show','params','rawAttributes','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','find','userProfileId','DefaultReports','error','preview','join','left_join','right_join','SUM(%s)','COUNT(%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)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20EMPTY','rules','group','field','condition','value','getFields','Sequelize','ValidationErrorItem','findAll','keyBy','select','from','table','MetricId','metric','function','replace','format','groupBy','orderBy','alias','joins','foreignTable','foreignKey','conditions','parse','clone','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','cross_join','COUNT(DISTINCT\x20%s)','SEC_TO_TIME(%s)','DATE(%s)','IS\x20NOT\x20NULL','IS\x20NOT\x20EMPTY','operator','AnalyticMetric','DESC','parentKey','output','fullPath','randomstring','generate','csv','default','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','Run\x20Query:','child_process','../../components/export/','../../files/reports','savename','countTable','COUNT(*)','run','Please\x20insert\x20at\x20least\x20one\x20field','%s.%s\x20=\x20%s.%s','debug','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','dbH','sendStatus','status','json','offset','limit','set','Content-Range','reject','update','then','get','UserProfileResource','destroy','end','stack','name','send','index','AnalyticDefaultReport'];(function(_0x3900a3,_0x5410d2){var _0x4577c2=function(_0x49469b){while(--_0x49469b){_0x3900a3['push'](_0x3900a3['shift']());}};_0x4577c2(++_0x5410d2);}(_0xd344,0x78));var _0x4d34=function(_0x47b0b1,_0x61a1ed){_0x47b0b1=_0x47b0b1-0x0;var _0x28e38e=_0xd344[_0x47b0b1];return _0x28e38e;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x4d34('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0x4d34('0x1'));var rp=require(_0x4d34('0x2'));var moment=require(_0x4d34('0x3'));var BPromise=require(_0x4d34('0x4'));var Mustache=require(_0x4d34('0x5'));var util=require(_0x4d34('0x6'));var path=require(_0x4d34('0x7'));var sox=require(_0x4d34('0x8'));var csv=require(_0x4d34('0x9'));var ejs=require(_0x4d34('0xa'));var fs=require('fs');var fs_extra=require(_0x4d34('0xb'));var _=require(_0x4d34('0xc'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x4d34('0xd'));var deskjs=require(_0x4d34('0xe'));var toCsv=require(_0x4d34('0x9'));var querystring=require(_0x4d34('0xf'));var Papa=require(_0x4d34('0x10'));var Redis=require(_0x4d34('0x11'));var authService=require('../../components/auth/service');var qs=require(_0x4d34('0x12'));var as=require(_0x4d34('0x13'));var hardwareService=require(_0x4d34('0x14'));var logger=require(_0x4d34('0x15'))(_0x4d34('0x16'));var utils=require('../../config/utils');var config=require(_0x4d34('0x17'));var licenseUtil=require(_0x4d34('0x18'));var db=require(_0x4d34('0x19'))['db'];var dbH=require(_0x4d34('0x19'))[_0x4d34('0x1a')];function respondWithStatusCode(_0x4d5e22,_0x5ab243){_0x5ab243=_0x5ab243||0xcc;return function(_0x4c031b){if(_0x4c031b){return _0x4d5e22[_0x4d34('0x1b')](_0x5ab243);}return _0x4d5e22[_0x4d34('0x1c')](_0x5ab243)['end']();};}function respondWithResult(_0x5cdeba,_0x3feb1a){_0x3feb1a=_0x3feb1a||0xc8;return function(_0x19509c){if(_0x19509c){return _0x5cdeba[_0x4d34('0x1c')](_0x3feb1a)[_0x4d34('0x1d')](_0x19509c);}};}function respondWithFilteredResult(_0x188838,_0x590fca){return function(_0x1d1502){if(_0x1d1502){var _0x2db894=_0x1d1502['count'],_0x37aebd=_0x590fca['offset'],_0x818d94=_0x590fca[_0x4d34('0x1e')]+_0x590fca[_0x4d34('0x1f')],_0xd9b2b0;if(_0x818d94>=_0x2db894){_0x818d94=_0x2db894;_0xd9b2b0=0xc8;}else{_0xd9b2b0=0xce;}_0x188838[_0x4d34('0x1c')](_0xd9b2b0);return _0x188838[_0x4d34('0x20')](_0x4d34('0x21'),_0x37aebd+'-'+_0x818d94+'/'+_0x2db894)[_0x4d34('0x1d')](_0x1d1502);}return null;};}function patchUpdates(_0xbe81d2){return function(_0x52ac8d){try{jsonpatch['apply'](_0x52ac8d,_0xbe81d2,!![]);}catch(_0x4042d5){return BPromise[_0x4d34('0x22')](_0x4042d5);}return _0x52ac8d['save']();};}function saveUpdates(_0x1bdfd5,_0x39b2a5){return function(_0x4332a3){if(_0x4332a3){return _0x4332a3[_0x4d34('0x23')](_0x1bdfd5)[_0x4d34('0x24')](function(_0x1175c9){return _0x1175c9;});}return null;};}function removeEntity(_0x19a393,_0x3fa2e6){return function(_0x13d0a5){if(_0x13d0a5){return _0x13d0a5['destroy']()[_0x4d34('0x24')](function(){var _0x41a5c7=_0x13d0a5[_0x4d34('0x25')]({'plain':!![]});var _0x35ec6f='DefaultReports';return db[_0x4d34('0x26')][_0x4d34('0x27')]({'where':{'type':_0x35ec6f,'resourceId':_0x41a5c7['id']}})['then'](function(){return _0x13d0a5;});})['then'](function(){_0x19a393[_0x4d34('0x1c')](0xcc)[_0x4d34('0x28')]();});}};}function handleEntityNotFound(_0x2c42c2,_0x440728){return function(_0x1bec53){if(!_0x1bec53){_0x2c42c2['sendStatus'](0x194);}return _0x1bec53;};}function handleError(_0x774deb,_0x5d15e2){_0x5d15e2=_0x5d15e2||0x1f4;return function(_0x2ab138){logger['error'](_0x2ab138[_0x4d34('0x29')]);if(_0x2ab138[_0x4d34('0x2a')]){delete _0x2ab138[_0x4d34('0x2a')];}_0x774deb[_0x4d34('0x1c')](_0x5d15e2)[_0x4d34('0x2b')](_0x2ab138);};}exports[_0x4d34('0x2c')]=function(_0x27450a,_0x3a68e8){var _0x4e147c={},_0x7095fe={},_0x5d494f={'count':0x0,'rows':[]};var _0x3b1179=_['map'](db[_0x4d34('0x2d')]['rawAttributes'],function(_0x5d1ee3){return{'name':_0x5d1ee3['fieldName'],'type':_0x5d1ee3[_0x4d34('0x2e')][_0x4d34('0x2f')]};});_0x7095fe[_0x4d34('0x30')]=_['map'](_0x3b1179,_0x4d34('0x2a'));_0x7095fe[_0x4d34('0x31')]=_[_0x4d34('0x32')](_0x27450a[_0x4d34('0x31')]);_0x7095fe[_0x4d34('0x33')]=_[_0x4d34('0x34')](_0x7095fe[_0x4d34('0x30')],_0x7095fe['query']);_0x4e147c['attributes']=_[_0x4d34('0x34')](_0x7095fe['model'],qs[_0x4d34('0x35')](_0x27450a[_0x4d34('0x31')]['fields']));_0x4e147c[_0x4d34('0x36')]=_0x4e147c[_0x4d34('0x36')][_0x4d34('0x37')]?_0x4e147c['attributes']:_0x7095fe[_0x4d34('0x30')];if(!_0x27450a['query']['hasOwnProperty'](_0x4d34('0x38'))){_0x4e147c[_0x4d34('0x1f')]=qs[_0x4d34('0x1f')](_0x27450a[_0x4d34('0x31')][_0x4d34('0x1f')]);_0x4e147c['offset']=qs['offset'](_0x27450a[_0x4d34('0x31')][_0x4d34('0x1e')]);}_0x4e147c[_0x4d34('0x39')]=qs['sort'](_0x27450a[_0x4d34('0x31')][_0x4d34('0x3a')]);_0x4e147c[_0x4d34('0x3b')]=qs[_0x4d34('0x33')](_[_0x4d34('0x3c')](_0x27450a['query'],_0x7095fe[_0x4d34('0x33')]),_0x3b1179);if(_0x27450a[_0x4d34('0x31')]['filter']){_0x4e147c[_0x4d34('0x3b')]=_[_0x4d34('0x3d')](_0x4e147c[_0x4d34('0x3b')],{'$or':_['map'](_0x3b1179,function(_0x487728){if(_0x487728[_0x4d34('0x2e')]!==_0x4d34('0x3e')){var _0x230109={};_0x230109[_0x487728[_0x4d34('0x2a')]]={'$like':'%'+_0x27450a[_0x4d34('0x31')][_0x4d34('0x3f')]+'%'};return _0x230109;}})});}_0x4e147c=_[_0x4d34('0x3d')]({},_0x4e147c,_0x27450a[_0x4d34('0x40')]);var _0xdc2140={'where':_0x4e147c[_0x4d34('0x3b')]};return db[_0x4d34('0x2d')][_0x4d34('0x41')](_0xdc2140)[_0x4d34('0x24')](function(_0x33a0f2){_0x5d494f['count']=_0x33a0f2;if(_0x27450a[_0x4d34('0x31')][_0x4d34('0x42')]){_0x4e147c[_0x4d34('0x43')]=[{'all':!![]}];}return db[_0x4d34('0x2d')]['findAll'](_0x4e147c);})[_0x4d34('0x24')](function(_0x5af2c7){_0x5d494f[_0x4d34('0x44')]=_0x5af2c7;return _0x5d494f;})[_0x4d34('0x24')](respondWithFilteredResult(_0x3a68e8,_0x4e147c))[_0x4d34('0x45')](handleError(_0x3a68e8,null));};exports[_0x4d34('0x46')]=function(_0x13e7c1,_0x2737eb){var _0x1aa8e1={'raw':!![],'where':{'id':_0x13e7c1[_0x4d34('0x47')]['id']}},_0x89d0df={};_0x89d0df['model']=_['keys'](db['AnalyticDefaultReport'][_0x4d34('0x48')]);_0x89d0df['query']=_[_0x4d34('0x32')](_0x13e7c1[_0x4d34('0x31')]);_0x89d0df['filters']=_[_0x4d34('0x34')](_0x89d0df['model'],_0x89d0df[_0x4d34('0x31')]);_0x1aa8e1['attributes']=_['intersection'](_0x89d0df['model'],qs[_0x4d34('0x35')](_0x13e7c1[_0x4d34('0x31')]['fields']));_0x1aa8e1['attributes']=_0x1aa8e1[_0x4d34('0x36')][_0x4d34('0x37')]?_0x1aa8e1[_0x4d34('0x36')]:_0x89d0df['model'];if(_0x13e7c1[_0x4d34('0x31')][_0x4d34('0x42')]){_0x1aa8e1[_0x4d34('0x43')]=[{'all':!![]}];}_0x1aa8e1=_[_0x4d34('0x3d')]({},_0x1aa8e1,_0x13e7c1['options']);return db[_0x4d34('0x2d')]['find'](_0x1aa8e1)[_0x4d34('0x24')](handleEntityNotFound(_0x2737eb,null))[_0x4d34('0x24')](respondWithResult(_0x2737eb,null))[_0x4d34('0x45')](handleError(_0x2737eb,null));};exports[_0x4d34('0x49')]=function(_0x38b9d5,_0x2786e2){return db['AnalyticDefaultReport'][_0x4d34('0x49')](_0x38b9d5[_0x4d34('0x4a')],{})[_0x4d34('0x24')](function(_0x35c9ef){var _0x282902=_0x38b9d5[_0x4d34('0x4b')]['get']({'plain':!![]});if(!_0x282902)throw new Error(_0x4d34('0x4c'));if(_0x282902[_0x4d34('0x4d')]==='user'){var _0x1985b2=_0x35c9ef[_0x4d34('0x25')]({'plain':!![]});var _0xf30a7=_0x4d34('0x4e');return db['UserProfileSection'][_0x4d34('0x4f')]({'where':{'name':_0xf30a7,'userProfileId':_0x282902[_0x4d34('0x50')]},'raw':!![]})[_0x4d34('0x24')](function(_0x4a119c){if(_0x4a119c&&_0x4a119c['autoAssociation']===0x0){return db[_0x4d34('0x26')]['create']({'name':_0x1985b2[_0x4d34('0x2a')],'resourceId':_0x1985b2['id'],'type':_0x4d34('0x51'),'sectionId':_0x4a119c['id']},{})[_0x4d34('0x24')](function(){return _0x35c9ef;});}else{return _0x35c9ef;}})[_0x4d34('0x45')](function(_0x334160){logger[_0x4d34('0x52')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x334160);throw _0x334160;});}return _0x35c9ef;})[_0x4d34('0x24')](respondWithResult(_0x2786e2,0xc9))['catch'](handleError(_0x2786e2,null));};exports[_0x4d34('0x23')]=function(_0x23def3,_0x404235){if(_0x23def3[_0x4d34('0x4a')]['id']){delete _0x23def3[_0x4d34('0x4a')]['id'];}return db[_0x4d34('0x2d')][_0x4d34('0x4f')]({'where':{'id':_0x23def3[_0x4d34('0x47')]['id']}})['then'](handleEntityNotFound(_0x404235,null))['then'](saveUpdates(_0x23def3[_0x4d34('0x4a')],null))[_0x4d34('0x24')](respondWithResult(_0x404235,null))[_0x4d34('0x45')](handleError(_0x404235,null));};exports['destroy']=function(_0x14dc64,_0x251690){return db['AnalyticDefaultReport'][_0x4d34('0x4f')]({'where':{'id':_0x14dc64['params']['id']}})[_0x4d34('0x24')](handleEntityNotFound(_0x251690,null))['then'](removeEntity(_0x251690,null))[_0x4d34('0x45')](handleError(_0x251690,null));};exports[_0x4d34('0x53')]=function(_0x23cc04,_0x53974d){var _0x494f04=0xa;var _0x21d332=[_0x4d34('0x54'),_0x4d34('0x55'),_0x4d34('0x56'),'cross_join'];var _0x380264={'SUM':_0x4d34('0x57'),'COUNT':_0x4d34('0x58'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x4d34('0x59'),'MIN':_0x4d34('0x5a'),'AVG':_0x4d34('0x5b'),'GROUP_CONCAT':_0x4d34('0x5c'),'GROUP_CONCAT ASC':_0x4d34('0x5d'),'GROUP_CONCAT DESC':_0x4d34('0x5e')};var _0x444f20={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':_0x4d34('0x5f'),'UNIX_TIMESTAMP':_0x4d34('0x60')};var _0x336428=function(_0x2de0f2){return!_[_0x4d34('0x61')]([_0x4d34('0x62'),'IS\x20NOT\x20NULL',_0x4d34('0x63'),'IS\x20NOT\x20EMPTY'],_0x2de0f2);};var _0x13d2ce=function(_0x30d96c){if(!_0x30d96c||!_0x30d96c[_0x4d34('0x64')][_0x4d34('0x37')]){return'';}for(var _0x269075='(',_0x3c0ae4=0x0;_0x3c0ae4<_0x30d96c[_0x4d34('0x64')][_0x4d34('0x37')];_0x3c0ae4+=0x1){_0x3c0ae4>0x0&&(_0x269075+='\x20'+_0x30d96c['operator']+'\x20');_0x269075+=_0x30d96c[_0x4d34('0x64')][_0x3c0ae4][_0x4d34('0x65')]?_0x13d2ce(_0x30d96c[_0x4d34('0x64')][_0x3c0ae4][_0x4d34('0x65')]):_0x30d96c[_0x4d34('0x64')][_0x3c0ae4][_0x4d34('0x66')]+'\x20'+_0x30d96c['rules'][_0x3c0ae4]['condition']+(_0x336428(_0x30d96c[_0x4d34('0x64')][_0x3c0ae4][_0x4d34('0x67')])?'\x20'+_0x30d96c[_0x4d34('0x64')][_0x3c0ae4][_0x4d34('0x68')]:'');}return _0x269075+')';};var _0x989558={'where':{'id':_0x23cc04[_0x4d34('0x47')]['id']}},_0x22d72d,_0x12a545,_0x2389ad,_0xe5a463,_0x1838bd;_0x989558=_[_0x4d34('0x3d')]({},_0x989558,_0x23cc04['options']);return db['AnalyticDefaultReport'][_0x4d34('0x4f')](_0x989558)[_0x4d34('0x24')](function(_0x5b2c9a){if(_0x5b2c9a){_0x22d72d=_0x5b2c9a;return _0x5b2c9a[_0x4d34('0x69')]();}return null;})[_0x4d34('0x24')](function(_0x135cf7){if(_0x135cf7){if(!_0x135cf7[_0x4d34('0x37')]){throw new db[(_0x4d34('0x6a'))][(_0x4d34('0x6b'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x12a545=_0x135cf7;return db['AnalyticMetric'][_0x4d34('0x6c')]({'raw':!![]});}return null;})[_0x4d34('0x24')](function(_0x1aa811){if(_0x1aa811){_0x2389ad=_[_0x4d34('0x6d')](_0x1aa811,'id');var _0x4f42d7;var _0x359be1=squel[_0x4d34('0x6e')]();_0x359be1[_0x4d34('0x6f')](_0x22d72d[_0x4d34('0x70')]);for(var _0xe7fd7b=0x0;_0xe7fd7b<_0x12a545[_0x4d34('0x37')];_0xe7fd7b+=0x1){_0x4f42d7=_0x12a545[_0xe7fd7b]['MetricId']?_0x2389ad[_0x12a545[_0xe7fd7b][_0x4d34('0x71')]][_0x4d34('0x72')]:_0x12a545[_0xe7fd7b][_0x4d34('0x66')];_0x4f42d7=_0x12a545[_0xe7fd7b][_0x4d34('0x73')]?_[_0x4d34('0x74')](_0x380264[_0x12a545[_0xe7fd7b][_0x4d34('0x73')]],'%s',_0x4f42d7):_0x4f42d7;_0x4f42d7=_0x12a545[_0xe7fd7b]['format']?_[_0x4d34('0x74')](_0x444f20[_0x12a545[_0xe7fd7b][_0x4d34('0x75')]],'%s',_0x4f42d7):_0x4f42d7;if(_0x12a545[_0xe7fd7b][_0x4d34('0x76')]){_0x359be1['group'](_0x4f42d7);}_0x12a545[_0xe7fd7b][_0x4d34('0x77')]&&_0x359be1[_0x4d34('0x39')](_0x4f42d7,_0x12a545[_0xe7fd7b][_0x4d34('0x77')]==='DESC'?![]:!![]);_0x359be1[_0x4d34('0x66')](_0x4f42d7,_0x12a545[_0xe7fd7b][_0x4d34('0x78')]||_0x4f42d7);}if(_0x22d72d['joins']){_0x22d72d[_0x4d34('0x79')]=JSON['parse'](_0x22d72d[_0x4d34('0x79')]);for(var _0x525896=0x0;_0x525896<_0x22d72d[_0x4d34('0x79')][_0x4d34('0x37')];_0x525896+=0x1){if(_0x22d72d[_0x4d34('0x79')][_0x525896]['type']&&_[_0x4d34('0x61')](_0x21d332,_0x22d72d[_0x4d34('0x79')][_0x525896]['type'])&&_0x22d72d['joins'][_0x525896]['parentKey']&&_0x22d72d[_0x4d34('0x79')][_0x525896][_0x4d34('0x7a')]&&_0x22d72d[_0x4d34('0x79')][_0x525896][_0x4d34('0x7b')]){_0x359be1[_0x22d72d['joins'][_0x525896][_0x4d34('0x2e')]](_0x22d72d[_0x4d34('0x79')][_0x525896][_0x4d34('0x7a')],null,util[_0x4d34('0x75')]('%s.%s\x20=\x20%s.%s',_0x22d72d['table'],_0x22d72d[_0x4d34('0x79')][_0x525896]['parentKey'],_0x22d72d[_0x4d34('0x79')][_0x525896][_0x4d34('0x7a')],_0x22d72d[_0x4d34('0x79')][_0x525896][_0x4d34('0x7b')]));}}}if(_0x22d72d[_0x4d34('0x7c')]){_0x22d72d[_0x4d34('0x7c')]=JSON[_0x4d34('0x7d')](_0x22d72d[_0x4d34('0x7c')]);_0x359be1['where'](_0x13d2ce(_0x22d72d['conditions'][_0x4d34('0x65')]));}_0x1838bd=_0x359be1[_0x4d34('0x7e')]();_0x359be1[_0x4d34('0x1f')](_0x494f04);_0x359be1['offset'](0x0);logger['debug'](_0x4d34('0x7f'),_0x359be1[_0x4d34('0x80')]());return dbH[_0x4d34('0x81')][_0x4d34('0x31')](_0x359be1[_0x4d34('0x80')](),{'type':dbH[_0x4d34('0x81')][_0x4d34('0x82')][_0x4d34('0x83')]});}})[_0x4d34('0x24')](respondWithResult(_0x53974d,null))['catch'](handleError(_0x53974d,null));};function runReport(_0x587394,_0x3f9af7,_0x46a025){var _0x43103b=_0x3f9af7[_0x4d34('0x2a')];var _0x57cfa4=0xa;var _0x2b093e=[_0x4d34('0x54'),_0x4d34('0x55'),_0x4d34('0x56'),_0x4d34('0x84')];var _0x38efa8={'SUM':_0x4d34('0x57'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x4d34('0x85'),'MAX':_0x4d34('0x59'),'MIN':_0x4d34('0x5a'),'AVG':_0x4d34('0x5b'),'GROUP_CONCAT':_0x4d34('0x5c'),'GROUP_CONCAT ASC':_0x4d34('0x5d'),'GROUP_CONCAT DESC':_0x4d34('0x5e')};var _0x221512={'SEC_TO_TIME':_0x4d34('0x86'),'DATE':_0x4d34('0x87'),'HOUR':'HOUR(%s)','ROUND':_0x4d34('0x5f'),'UNIX_TIMESTAMP':_0x4d34('0x60')};var _0xe36978=function(_0x9ea875){return!_[_0x4d34('0x61')]([_0x4d34('0x62'),_0x4d34('0x88'),_0x4d34('0x63'),_0x4d34('0x89')],_0x9ea875);};var _0x4d4f00=function(_0x5c6b54){if(!_0x5c6b54||!_0x5c6b54['rules'][_0x4d34('0x37')]){return'';}for(var _0x5c32e0='(',_0x4468d4=0x0;_0x4468d4<_0x5c6b54[_0x4d34('0x64')]['length'];_0x4468d4+=0x1){_0x4468d4>0x0&&(_0x5c32e0+='\x20'+_0x5c6b54[_0x4d34('0x8a')]+'\x20');_0x5c32e0+=_0x5c6b54[_0x4d34('0x64')][_0x4468d4]['group']?_0x4d4f00(_0x5c6b54[_0x4d34('0x64')][_0x4468d4][_0x4d34('0x65')]):_0x5c6b54['rules'][_0x4468d4][_0x4d34('0x66')]+'\x20'+_0x5c6b54['rules'][_0x4468d4][_0x4d34('0x67')]+(_0xe36978(_0x5c6b54[_0x4d34('0x64')][_0x4468d4][_0x4d34('0x67')])?'\x20'+_0x5c6b54[_0x4d34('0x64')][_0x4468d4][_0x4d34('0x68')]:'');}return _0x5c32e0+')';};var _0x59aa7f={'where':{'id':_0x587394['id']}},_0x1b092d,_0x5682ff,_0x17c859,_0x374d09,_0x14e1f2;_0x59aa7f=_[_0x4d34('0x3d')]({},_0x59aa7f,_0x46a025);return db[_0x4d34('0x2d')][_0x4d34('0x4f')](_0x59aa7f)['then'](function(_0x49866c){if(_0x49866c){_0x1b092d=_0x49866c;return _0x49866c[_0x4d34('0x69')]();}return null;})[_0x4d34('0x24')](function(_0x1c477d){if(_0x1c477d){if(!_0x1c477d[_0x4d34('0x37')]){throw new db[(_0x4d34('0x6a'))][(_0x4d34('0x6b'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x5682ff=_0x1c477d;return db[_0x4d34('0x8b')][_0x4d34('0x6c')]({'raw':!![]});}return null;})['then'](function(_0x55267b){if(_0x55267b){_0x17c859=_[_0x4d34('0x6d')](_0x55267b,'id');var _0x37343b;var _0x1e52e4=squel[_0x4d34('0x6e')]();_0x1e52e4[_0x4d34('0x6f')](_0x1b092d[_0x4d34('0x70')]);for(var _0x458cea=0x0;_0x458cea<_0x5682ff[_0x4d34('0x37')];_0x458cea+=0x1){_0x37343b=_0x5682ff[_0x458cea][_0x4d34('0x71')]?_0x17c859[_0x5682ff[_0x458cea]['MetricId']][_0x4d34('0x72')]:_0x5682ff[_0x458cea][_0x4d34('0x66')];_0x37343b=_0x5682ff[_0x458cea]['function']?_[_0x4d34('0x74')](_0x38efa8[_0x5682ff[_0x458cea][_0x4d34('0x73')]],'%s',_0x37343b):_0x37343b;_0x37343b=_0x5682ff[_0x458cea]['format']?_[_0x4d34('0x74')](_0x221512[_0x5682ff[_0x458cea][_0x4d34('0x75')]],'%s',_0x37343b):_0x37343b;if(_0x5682ff[_0x458cea][_0x4d34('0x76')]){_0x1e52e4[_0x4d34('0x65')](_0x37343b);}_0x5682ff[_0x458cea][_0x4d34('0x77')]&&_0x1e52e4[_0x4d34('0x39')](_0x37343b,_0x5682ff[_0x458cea][_0x4d34('0x77')]===_0x4d34('0x8c')?![]:!![]);_0x1e52e4[_0x4d34('0x66')](_0x37343b,_0x5682ff[_0x458cea][_0x4d34('0x78')]||_0x37343b);}if(_0x1b092d[_0x4d34('0x79')]){_0x1b092d[_0x4d34('0x79')]=JSON['parse'](_0x1b092d[_0x4d34('0x79')]);for(var _0x223ba0=0x0;_0x223ba0<_0x1b092d[_0x4d34('0x79')][_0x4d34('0x37')];_0x223ba0+=0x1){if(_0x1b092d['joins'][_0x223ba0][_0x4d34('0x2e')]&&_[_0x4d34('0x61')](_0x2b093e,_0x1b092d[_0x4d34('0x79')][_0x223ba0][_0x4d34('0x2e')])&&_0x1b092d['joins'][_0x223ba0][_0x4d34('0x8d')]&&_0x1b092d['joins'][_0x223ba0][_0x4d34('0x7a')]&&_0x1b092d[_0x4d34('0x79')][_0x223ba0][_0x4d34('0x7b')]){_0x1e52e4[_0x1b092d[_0x4d34('0x79')][_0x223ba0][_0x4d34('0x2e')]](_0x1b092d[_0x4d34('0x79')][_0x223ba0][_0x4d34('0x7a')],null,util[_0x4d34('0x75')]('%s.%s\x20=\x20%s.%s',_0x1b092d[_0x4d34('0x70')],_0x1b092d[_0x4d34('0x79')][_0x223ba0]['parentKey'],_0x1b092d[_0x4d34('0x79')][_0x223ba0]['foreignTable'],_0x1b092d[_0x4d34('0x79')][_0x223ba0][_0x4d34('0x7b')]));}}}if(_0x1b092d['conditions']){_0x1b092d[_0x4d34('0x7c')]=JSON[_0x4d34('0x7d')](_0x1b092d[_0x4d34('0x7c')]);_0x1e52e4[_0x4d34('0x3b')](_0x4d4f00(_0x1b092d[_0x4d34('0x7c')]['group']));}_0x14e1f2=_0x1e52e4[_0x4d34('0x7e')]();_0x1e52e4[_0x4d34('0x1f')](_0x57cfa4);_0x1e52e4['offset'](0x0);return;}})[_0x4d34('0x24')](function(){if(_0x3f9af7[_0x4d34('0x8e')]==='web'){return null;}var _0x4d5568=_[_0x4d34('0x3d')](_0x3f9af7,{'name':_0x3f9af7[_0x4d34('0x8f')]||_0x3f9af7[_0x4d34('0x2a')]||_0x1b092d['name'],'basename':_0x43103b,'savename':util[_0x4d34('0x75')]('%s-%s.%s',_0x3f9af7[_0x4d34('0x2a')]||_0x1b092d[_0x4d34('0x2a')],require(_0x4d34('0x90'))[_0x4d34('0x91')](0x4),_0x3f9af7[_0x4d34('0x8e')]||_0x4d34('0x92')),'reportId':_0x1b092d['id'],'reportType':_0x4d34('0x93')});return db[_0x4d34('0x94')][_0x4d34('0x49')](_0x4d5568,{'raw':!![]});})['then'](function(_0x49a56f){if(_0x1b092d[_0x4d34('0x70')]===_0x4d34('0x95')){_0x14e1f2[_0x4d34('0x3b')](_0x1b092d[_0x4d34('0x70')]+_0x4d34('0x96'),_0x3f9af7[_0x4d34('0x97')],_0x3f9af7[_0x4d34('0x98')]);}else{_0x14e1f2[_0x4d34('0x3b')](_0x1b092d[_0x4d34('0x70')]+_0x4d34('0x99'),_0x3f9af7[_0x4d34('0x97')],_0x3f9af7[_0x4d34('0x98')]);}if(_0x49a56f){logger[_0x4d34('0x9a')](_0x4d34('0x9b'),_0x14e1f2[_0x4d34('0x80')]());require(_0x4d34('0x9c'))['fork'](path['join'](__dirname,_0x4d34('0x9d'),_0x49a56f[_0x4d34('0x8e')]),[_0x49a56f['id'],_0x14e1f2[_0x4d34('0x80')](),path[_0x4d34('0x54')](__dirname,_0x4d34('0x9e'),_0x49a56f[_0x4d34('0x9f')]),_0x43103b]);return _0x49a56f;}else{var _0x212c2f=squel['select']();_0x212c2f[_0x4d34('0x6f')]('('+_0x14e1f2[_0x4d34('0x80')]()+')',_0x4d34('0xa0'));_0x212c2f[_0x4d34('0x66')](_0x4d34('0xa1'),'count');_0x14e1f2[_0x4d34('0x1f')](_0x3f9af7[_0x4d34('0x1f')]||_0x57cfa4);_0x14e1f2['offset'](_0x3f9af7['offset']||0x0);return dbH['sequelize'][_0x4d34('0x31')](_0x212c2f[_0x4d34('0x80')](),{'type':dbH[_0x4d34('0x81')]['QueryTypes'][_0x4d34('0x83')]})['then'](function(_0x3b6070){if(!_0x3b6070['length']){_0x374d09=0x0;}else{_0x374d09=_0x3b6070[0x0][_0x4d34('0x41')]||0x0;}return dbH[_0x4d34('0x81')]['query'](_0x14e1f2[_0x4d34('0x80')](),{'type':dbH['sequelize']['QueryTypes']['SELECT']});})[_0x4d34('0x24')](function(_0xbe7ecd){return{'rows':_0xbe7ecd||[],'count':_0x374d09};});}});}exports[_0x4d34('0xa2')]=function(_0x17cf99,_0x45381c){return runReport(_0x17cf99['params'],_0x17cf99[_0x4d34('0x31')],_0x17cf99[_0x4d34('0x40')])[_0x4d34('0x24')](respondWithResult(_0x45381c,null))['catch'](handleError(_0x45381c,null));};exports['runReport']=runReport;exports['query']=function(_0x560186,_0x1cd77a){var _0x352a6b=0xa;var _0x55b3a1=['join','left_join',_0x4d34('0x56'),'cross_join'];var _0x582147={'SUM':_0x4d34('0x57'),'COUNT':_0x4d34('0x58'),'COUNT DISTINCT':_0x4d34('0x85'),'MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':'AVG(%s)','GROUP_CONCAT':_0x4d34('0x5c'),'GROUP_CONCAT ASC':_0x4d34('0x5d'),'GROUP_CONCAT DESC':_0x4d34('0x5e')};var _0x1fdc76={'SEC_TO_TIME':_0x4d34('0x86'),'DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':_0x4d34('0x5f'),'UNIX_TIMESTAMP':_0x4d34('0x60')};var _0x509551=function(_0x1a7a04){return!_[_0x4d34('0x61')]([_0x4d34('0x62'),_0x4d34('0x88'),_0x4d34('0x63'),'IS\x20NOT\x20EMPTY'],_0x1a7a04);};var _0x53aed9=function(_0x442a29){if(!_0x442a29||!_0x442a29[_0x4d34('0x64')][_0x4d34('0x37')]){return'';}for(var _0x1f4516='(',_0x7273f8=0x0;_0x7273f8<_0x442a29[_0x4d34('0x64')][_0x4d34('0x37')];_0x7273f8+=0x1){_0x7273f8>0x0&&(_0x1f4516+='\x20'+_0x442a29[_0x4d34('0x8a')]+'\x20');_0x1f4516+=_0x442a29['rules'][_0x7273f8][_0x4d34('0x65')]?_0x53aed9(_0x442a29[_0x4d34('0x64')][_0x7273f8][_0x4d34('0x65')]):_0x442a29['rules'][_0x7273f8][_0x4d34('0x66')]+'\x20'+_0x442a29[_0x4d34('0x64')][_0x7273f8][_0x4d34('0x67')]+(_0x509551(_0x442a29[_0x4d34('0x64')][_0x7273f8]['condition'])?'\x20'+_0x442a29[_0x4d34('0x64')][_0x7273f8]['value']:'');}return _0x1f4516+')';};var _0x18c371={'where':{'id':_0x560186[_0x4d34('0x47')]['id']}},_0x4f22fb,_0x456622,_0x4f61be,_0x1127a3,_0x35598e;_0x18c371=_[_0x4d34('0x3d')]({},_0x18c371,_0x560186[_0x4d34('0x40')]);return db['AnalyticDefaultReport'][_0x4d34('0x4f')](_0x18c371)[_0x4d34('0x24')](function(_0x5bd3aa){if(_0x5bd3aa){_0x4f22fb=_0x5bd3aa;return _0x5bd3aa[_0x4d34('0x69')]();}return null;})['then'](function(_0xd50949){if(_0xd50949){if(!_0xd50949[_0x4d34('0x37')]){throw new db['Sequelize'][(_0x4d34('0x6b'))](_0x4d34('0xa3'),0x193);}_0x456622=_0xd50949;return db[_0x4d34('0x8b')]['findAll']({'raw':!![]});}return null;})[_0x4d34('0x24')](function(_0x4d4c9a){if(_0x4d4c9a){_0x4f61be=_['keyBy'](_0x4d4c9a,'id');var _0x2ec16a;var _0xd3c071=squel[_0x4d34('0x6e')]();_0xd3c071[_0x4d34('0x6f')](_0x4f22fb[_0x4d34('0x70')]);for(var _0x1a987f=0x0;_0x1a987f<_0x456622[_0x4d34('0x37')];_0x1a987f+=0x1){_0x2ec16a=_0x456622[_0x1a987f]['MetricId']?_0x4f61be[_0x456622[_0x1a987f][_0x4d34('0x71')]][_0x4d34('0x72')]:_0x456622[_0x1a987f][_0x4d34('0x66')];_0x2ec16a=_0x456622[_0x1a987f][_0x4d34('0x73')]?_['replace'](_0x582147[_0x456622[_0x1a987f][_0x4d34('0x73')]],'%s',_0x2ec16a):_0x2ec16a;_0x2ec16a=_0x456622[_0x1a987f]['format']?_[_0x4d34('0x74')](_0x1fdc76[_0x456622[_0x1a987f][_0x4d34('0x75')]],'%s',_0x2ec16a):_0x2ec16a;if(_0x456622[_0x1a987f][_0x4d34('0x76')]){_0xd3c071[_0x4d34('0x65')](_0x2ec16a);}_0x456622[_0x1a987f][_0x4d34('0x77')]&&_0xd3c071['order'](_0x2ec16a,_0x456622[_0x1a987f][_0x4d34('0x77')]==='DESC'?![]:!![]);_0xd3c071[_0x4d34('0x66')](_0x2ec16a,_0x456622[_0x1a987f][_0x4d34('0x78')]||_0x2ec16a);}if(_0x4f22fb[_0x4d34('0x79')]){_0x4f22fb[_0x4d34('0x79')]=JSON[_0x4d34('0x7d')](_0x4f22fb[_0x4d34('0x79')]);for(var _0x5487e4=0x0;_0x5487e4<_0x4f22fb['joins']['length'];_0x5487e4+=0x1){if(_0x4f22fb[_0x4d34('0x79')][_0x5487e4][_0x4d34('0x2e')]&&_[_0x4d34('0x61')](_0x55b3a1,_0x4f22fb['joins'][_0x5487e4]['type'])&&_0x4f22fb[_0x4d34('0x79')][_0x5487e4][_0x4d34('0x8d')]&&_0x4f22fb['joins'][_0x5487e4][_0x4d34('0x7a')]&&_0x4f22fb[_0x4d34('0x79')][_0x5487e4][_0x4d34('0x7b')]){_0xd3c071[_0x4f22fb[_0x4d34('0x79')][_0x5487e4]['type']](_0x4f22fb['joins'][_0x5487e4][_0x4d34('0x7a')],null,util['format'](_0x4d34('0xa4'),_0x4f22fb[_0x4d34('0x70')],_0x4f22fb[_0x4d34('0x79')][_0x5487e4][_0x4d34('0x8d')],_0x4f22fb['joins'][_0x5487e4][_0x4d34('0x7a')],_0x4f22fb[_0x4d34('0x79')][_0x5487e4][_0x4d34('0x7b')]));}}}if(_0x4f22fb[_0x4d34('0x7c')]){_0x4f22fb[_0x4d34('0x7c')]=JSON[_0x4d34('0x7d')](_0x4f22fb[_0x4d34('0x7c')]);_0xd3c071[_0x4d34('0x3b')](_0x53aed9(_0x4f22fb[_0x4d34('0x7c')]['group']));}_0x35598e=_0xd3c071[_0x4d34('0x7e')]();_0xd3c071[_0x4d34('0x1f')](_0x352a6b);_0xd3c071['offset'](0x0);logger[_0x4d34('0xa5')]('Limited\x20Query:',_0xd3c071[_0x4d34('0x80')]());return dbH[_0x4d34('0x81')]['query'](_0xd3c071[_0x4d34('0x80')](),{'type':dbH[_0x4d34('0x81')][_0x4d34('0x82')][_0x4d34('0x83')]});}})[_0x4d34('0x24')](function(){return{'sql':_0x35598e[_0x4d34('0x80')]()};})[_0x4d34('0x24')](respondWithResult(_0x1cd77a,null))['catch'](handleError(_0x1cd77a,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff