// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xdb94=['.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','Run\x20Query:','child_process','../../components/export/','savename','COUNT(*)','QueryTypes','Sequelize','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','path','ejs','squel','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/environment','../../mysqldb','end','status','json','count','limit','set','Content-Range','apply','save','update','then','destroy','get','DefaultReports','sendStatus','error','stack','name','send','index','AnalyticDefaultReport','rawAttributes','model','keys','filters','intersection','query','attributes','fields','length','hasOwnProperty','offset','order','sort','where','filter','merge','map','type','key','VIRTUAL','options','include','findAll','rows','catch','show','params','includeAll','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','preview','join','left_join','right_join','cross_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','DATE(%s)','HOUR(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','field','getFields','AnalyticMetric','keyBy','select','table','MetricId','replace','function','format','orderBy','joins','parse','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','parentKey','conditions','clone','debug','Limited\x20Query:','toString','SELECT','ROUND(%s)','condition','value','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','from','metric','groupBy','DESC','alias','sequelize','output','web','fullPath','%s-%s.%s','randomstring','generate','csv','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate'];(function(_0x32b122,_0x1ad490){var _0x4ad25a=function(_0x590ee6){while(--_0x590ee6){_0x32b122['push'](_0x32b122['shift']());}};_0x4ad25a(++_0x1ad490);}(_0xdb94,0xab));var _0x4db9=function(_0x59eca4,_0xec28a5){_0x59eca4=_0x59eca4-0x0;var _0x30d5fe=_0xdb94[_0x59eca4];return _0x30d5fe;};'use strict';var pdf=require(_0x4db9('0x0'));var emlformat=require(_0x4db9('0x1'));var rimraf=require(_0x4db9('0x2'));var zipdir=require(_0x4db9('0x3'));var jsonpatch=require(_0x4db9('0x4'));var rp=require('request-promise');var moment=require(_0x4db9('0x5'));var BPromise=require(_0x4db9('0x6'));var Mustache=require('mustache');var util=require('util');var path=require(_0x4db9('0x7'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x4db9('0x8'));var fs=require('fs');var _=require('lodash');var squel=require(_0x4db9('0x9'));var crypto=require('crypto');var jsforce=require(_0x4db9('0xa'));var deskjs=require(_0x4db9('0xb'));var toCsv=require(_0x4db9('0xc'));var querystring=require(_0x4db9('0xd'));var Papa=require(_0x4db9('0xe'));var Redis=require(_0x4db9('0xf'));var authService=require(_0x4db9('0x10'));var qs=require(_0x4db9('0x11'));var hardwareService=require(_0x4db9('0x12'));var logger=require(_0x4db9('0x13'))(_0x4db9('0x14'));var utils=require('../../config/utils');var config=require(_0x4db9('0x15'));var db=require(_0x4db9('0x16'))['db'];function respondWithStatusCode(_0x58a64b,_0x496645){_0x496645=_0x496645||0xcc;return function(_0x31222b){if(_0x31222b){return _0x58a64b['sendStatus'](_0x496645);}return _0x58a64b['status'](_0x496645)[_0x4db9('0x17')]();};}function respondWithResult(_0x3ff3d3,_0x569873){_0x569873=_0x569873||0xc8;return function(_0xd37d63){if(_0xd37d63){return _0x3ff3d3[_0x4db9('0x18')](_0x569873)[_0x4db9('0x19')](_0xd37d63);}};}function respondWithFilteredResult(_0x22667c,_0x51d024){return function(_0x5e04ab){if(_0x5e04ab){var _0x102274=_0x5e04ab[_0x4db9('0x1a')],_0x34de1a=_0x51d024['offset'],_0x4a037f=_0x51d024['offset']+_0x51d024[_0x4db9('0x1b')],_0xadc104;if(_0x4a037f>=_0x102274){_0x4a037f=_0x102274;_0xadc104=0xc8;}else{_0xadc104=0xce;}_0x22667c[_0x4db9('0x18')](_0xadc104);return _0x22667c[_0x4db9('0x1c')](_0x4db9('0x1d'),_0x34de1a+'-'+_0x4a037f+'/'+_0x102274)[_0x4db9('0x19')](_0x5e04ab);}return null;};}function patchUpdates(_0x55494a){return function(_0x3b1f87){try{jsonpatch[_0x4db9('0x1e')](_0x3b1f87,_0x55494a,!![]);}catch(_0x11012e){return BPromise['reject'](_0x11012e);}return _0x3b1f87[_0x4db9('0x1f')]();};}function saveUpdates(_0x36b5a3,_0x1fd635){return function(_0x4c92e8){if(_0x4c92e8){return _0x4c92e8[_0x4db9('0x20')](_0x36b5a3)[_0x4db9('0x21')](function(_0x4553c2){return _0x4553c2;});}return null;};}function removeEntity(_0x46fc3d,_0xf4f3fe){return function(_0x159d9b){if(_0x159d9b){return _0x159d9b[_0x4db9('0x22')]()['then'](function(){var _0x4ceb0c=_0x159d9b[_0x4db9('0x23')]({'plain':!![]});var _0xcde40c=_0x4db9('0x24');return db['UserProfileResource'][_0x4db9('0x22')]({'where':{'type':_0xcde40c,'resourceId':_0x4ceb0c['id']}})[_0x4db9('0x21')](function(){return _0x159d9b;});})['then'](function(){_0x46fc3d[_0x4db9('0x18')](0xcc)[_0x4db9('0x17')]();});}};}function handleEntityNotFound(_0x2987c6,_0x4dbb1b){return function(_0x3c8237){if(!_0x3c8237){_0x2987c6[_0x4db9('0x25')](0x194);}return _0x3c8237;};}function handleError(_0x43b95e,_0x2d330e){_0x2d330e=_0x2d330e||0x1f4;return function(_0x3f9f7e){logger[_0x4db9('0x26')](_0x3f9f7e[_0x4db9('0x27')]);if(_0x3f9f7e[_0x4db9('0x28')]){delete _0x3f9f7e[_0x4db9('0x28')];}_0x43b95e[_0x4db9('0x18')](_0x2d330e)[_0x4db9('0x29')](_0x3f9f7e);};}exports[_0x4db9('0x2a')]=function(_0x2d646d,_0x20f133){var _0x583861={},_0x5031fe={},_0x3951b2={'count':0x0,'rows':[]};var _0x331279=db[_0x4db9('0x2b')][_0x4db9('0x2c')];_0x5031fe[_0x4db9('0x2d')]=_[_0x4db9('0x2e')](_0x331279);_0x5031fe['query']=_[_0x4db9('0x2e')](_0x2d646d['query']);_0x5031fe[_0x4db9('0x2f')]=_[_0x4db9('0x30')](_0x5031fe[_0x4db9('0x2d')],_0x5031fe[_0x4db9('0x31')]);_0x583861[_0x4db9('0x32')]=_['intersection'](_0x5031fe['model'],qs[_0x4db9('0x33')](_0x2d646d['query'][_0x4db9('0x33')]));_0x583861[_0x4db9('0x32')]=_0x583861['attributes'][_0x4db9('0x34')]?_0x583861[_0x4db9('0x32')]:_0x5031fe[_0x4db9('0x2d')];if(!_0x2d646d['query'][_0x4db9('0x35')]('nolimit')){_0x583861[_0x4db9('0x1b')]=qs[_0x4db9('0x1b')](_0x2d646d[_0x4db9('0x31')]['limit']);_0x583861['offset']=qs[_0x4db9('0x36')](_0x2d646d[_0x4db9('0x31')][_0x4db9('0x36')]);}_0x583861[_0x4db9('0x37')]=qs[_0x4db9('0x38')](_0x2d646d[_0x4db9('0x31')][_0x4db9('0x38')]);_0x583861[_0x4db9('0x39')]=qs[_0x4db9('0x2f')](_['pick'](_0x2d646d[_0x4db9('0x31')],_0x5031fe[_0x4db9('0x2f')]));if(_0x2d646d[_0x4db9('0x31')][_0x4db9('0x3a')]){_0x583861['where']=_[_0x4db9('0x3b')](_0x583861[_0x4db9('0x39')],{'$or':_[_0x4db9('0x3c')](_0x331279,function(_0x5495ed){if(_0x5495ed[_0x4db9('0x3d')][_0x4db9('0x3e')]!==_0x4db9('0x3f')){var _0x279de3={};_0x279de3[_0x5495ed['field']]={'$like':'%'+_0x2d646d['query'][_0x4db9('0x3a')]+'%'};return _0x279de3;}})});}_0x583861=_[_0x4db9('0x3b')]({},_0x583861,_0x2d646d[_0x4db9('0x40')]);var _0x8bc540={'where':_0x583861[_0x4db9('0x39')]};return db['AnalyticDefaultReport'][_0x4db9('0x1a')](_0x8bc540)[_0x4db9('0x21')](function(_0x23affc){_0x3951b2[_0x4db9('0x1a')]=_0x23affc;if(_0x2d646d[_0x4db9('0x31')]['includeAll']){_0x583861[_0x4db9('0x41')]=[{'all':!![]}];}return db[_0x4db9('0x2b')][_0x4db9('0x42')](_0x583861);})['then'](function(_0x37358f){_0x3951b2[_0x4db9('0x43')]=_0x37358f;return _0x3951b2;})[_0x4db9('0x21')](respondWithFilteredResult(_0x20f133,_0x583861))[_0x4db9('0x44')](handleError(_0x20f133,null));};exports[_0x4db9('0x45')]=function(_0x24aa2a,_0x412aab){var _0x115eec={'raw':!![],'where':{'id':_0x24aa2a[_0x4db9('0x46')]['id']}},_0x2c987c={};_0x2c987c['model']=_['keys'](db['AnalyticDefaultReport'][_0x4db9('0x2c')]);_0x2c987c[_0x4db9('0x31')]=_['keys'](_0x24aa2a[_0x4db9('0x31')]);_0x2c987c[_0x4db9('0x2f')]=_['intersection'](_0x2c987c['model'],_0x2c987c[_0x4db9('0x31')]);_0x115eec['attributes']=_[_0x4db9('0x30')](_0x2c987c[_0x4db9('0x2d')],qs['fields'](_0x24aa2a[_0x4db9('0x31')][_0x4db9('0x33')]));_0x115eec['attributes']=_0x115eec[_0x4db9('0x32')][_0x4db9('0x34')]?_0x115eec[_0x4db9('0x32')]:_0x2c987c['model'];if(_0x24aa2a['query'][_0x4db9('0x47')]){_0x115eec[_0x4db9('0x41')]=[{'all':!![]}];}_0x115eec=_[_0x4db9('0x3b')]({},_0x115eec,_0x24aa2a[_0x4db9('0x40')]);return db[_0x4db9('0x2b')][_0x4db9('0x48')](_0x115eec)[_0x4db9('0x21')](handleEntityNotFound(_0x412aab,null))[_0x4db9('0x21')](respondWithResult(_0x412aab,null))[_0x4db9('0x44')](handleError(_0x412aab,null));};exports[_0x4db9('0x49')]=function(_0x1159b3,_0x9fec71){return db[_0x4db9('0x2b')]['create'](_0x1159b3[_0x4db9('0x4a')],{})[_0x4db9('0x21')](function(_0x3852f0){var _0xba27c0=_0x1159b3[_0x4db9('0x4b')][_0x4db9('0x23')]({'plain':!![]});if(!_0xba27c0)throw new Error(_0x4db9('0x4c'));if(_0xba27c0[_0x4db9('0x4d')]===_0x4db9('0x4b')){var _0x2d6094=_0x3852f0[_0x4db9('0x23')]({'plain':!![]});var _0x49ea0c='Reports';return db[_0x4db9('0x4e')][_0x4db9('0x48')]({'where':{'name':_0x49ea0c,'userProfileId':_0xba27c0[_0x4db9('0x4f')]},'raw':!![]})[_0x4db9('0x21')](function(_0x2e7730){if(_0x2e7730&&_0x2e7730[_0x4db9('0x50')]===0x0){return db[_0x4db9('0x51')][_0x4db9('0x49')]({'name':_0x2d6094['name'],'resourceId':_0x2d6094['id'],'type':_0x4db9('0x24'),'sectionId':_0x2e7730['id']},{})[_0x4db9('0x21')](function(){return _0x3852f0;});}else{return _0x3852f0;}})[_0x4db9('0x44')](function(_0x29bd1b){logger[_0x4db9('0x26')](_0x4db9('0x52'),_0x29bd1b);throw _0x29bd1b;});}return _0x3852f0;})[_0x4db9('0x21')](respondWithResult(_0x9fec71,0xc9))[_0x4db9('0x44')](handleError(_0x9fec71,null));};exports['update']=function(_0x45bc79,_0xd6701a){if(_0x45bc79[_0x4db9('0x4a')]['id']){delete _0x45bc79[_0x4db9('0x4a')]['id'];}return db[_0x4db9('0x2b')][_0x4db9('0x48')]({'where':{'id':_0x45bc79['params']['id']}})[_0x4db9('0x21')](handleEntityNotFound(_0xd6701a,null))['then'](saveUpdates(_0x45bc79[_0x4db9('0x4a')],null))['then'](respondWithResult(_0xd6701a,null))['catch'](handleError(_0xd6701a,null));};exports[_0x4db9('0x22')]=function(_0x5996f2,_0x4643a1){return db[_0x4db9('0x2b')][_0x4db9('0x48')]({'where':{'id':_0x5996f2[_0x4db9('0x46')]['id']}})['then'](handleEntityNotFound(_0x4643a1,null))[_0x4db9('0x21')](removeEntity(_0x4643a1,null))['catch'](handleError(_0x4643a1,null));};exports[_0x4db9('0x53')]=function(_0x5df7e,_0x48a084){var _0x23a853=0xa;var _0x5d4c9e=[_0x4db9('0x54'),_0x4db9('0x55'),_0x4db9('0x56'),_0x4db9('0x57')];var _0x435fc9={'SUM':_0x4db9('0x58'),'COUNT':_0x4db9('0x59'),'COUNT DISTINCT':_0x4db9('0x5a'),'MAX':_0x4db9('0x5b'),'MIN':_0x4db9('0x5c'),'AVG':_0x4db9('0x5d'),'GROUP_CONCAT':_0x4db9('0x5e'),'GROUP_CONCAT ASC':_0x4db9('0x5f'),'GROUP_CONCAT DESC':_0x4db9('0x60')};var _0x125b69={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x4db9('0x61'),'HOUR':_0x4db9('0x62'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x4db9('0x63')};var _0x3de5ef=function(_0x26c64a){return!_[_0x4db9('0x64')]([_0x4db9('0x65'),_0x4db9('0x66'),_0x4db9('0x67'),_0x4db9('0x68')],_0x26c64a);};var _0x215538=function(_0x528d9c){if(!_0x528d9c||!_0x528d9c['rules'][_0x4db9('0x34')]){return'';}for(var _0x2a8adb='(',_0x355f13=0x0;_0x355f13<_0x528d9c[_0x4db9('0x69')][_0x4db9('0x34')];_0x355f13+=0x1){_0x355f13>0x0&&(_0x2a8adb+='\x20'+_0x528d9c[_0x4db9('0x6a')]+'\x20');_0x2a8adb+=_0x528d9c[_0x4db9('0x69')][_0x355f13][_0x4db9('0x6b')]?_0x215538(_0x528d9c[_0x4db9('0x69')][_0x355f13][_0x4db9('0x6b')]):_0x528d9c['rules'][_0x355f13][_0x4db9('0x6c')]+'\x20'+_0x528d9c['rules'][_0x355f13]['condition']+(_0x3de5ef(_0x528d9c['rules'][_0x355f13]['condition'])?'\x20'+_0x528d9c[_0x4db9('0x69')][_0x355f13]['value']:'');}return _0x2a8adb+')';};var _0x4bfff5={'where':{'id':_0x5df7e[_0x4db9('0x46')]['id']}},_0x7aea3a,_0x1354d5,_0xf1e173,_0x24a807,_0x2d91d9;_0x4bfff5=_[_0x4db9('0x3b')]({},_0x4bfff5,_0x5df7e[_0x4db9('0x40')]);return db[_0x4db9('0x2b')][_0x4db9('0x48')](_0x4bfff5)[_0x4db9('0x21')](function(_0x3c5777){if(_0x3c5777){_0x7aea3a=_0x3c5777;return _0x3c5777[_0x4db9('0x6d')]();}return null;})[_0x4db9('0x21')](function(_0xd84c6c){if(_0xd84c6c){if(!_0xd84c6c[_0x4db9('0x34')]){throw new db['Sequelize']['ValidationErrorItem']('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x1354d5=_0xd84c6c;return db[_0x4db9('0x6e')]['findAll']({'raw':!![]});}return null;})[_0x4db9('0x21')](function(_0x747299){if(_0x747299){_0xf1e173=_[_0x4db9('0x6f')](_0x747299,'id');var _0x4ad693;var _0x4dc8d6=squel[_0x4db9('0x70')]();_0x4dc8d6['from'](_0x7aea3a[_0x4db9('0x71')]);for(var _0x458790=0x0;_0x458790<_0x1354d5[_0x4db9('0x34')];_0x458790+=0x1){_0x4ad693=_0x1354d5[_0x458790][_0x4db9('0x72')]?_0xf1e173[_0x1354d5[_0x458790][_0x4db9('0x72')]]['metric']:_0x1354d5[_0x458790][_0x4db9('0x6c')];_0x4ad693=_0x1354d5[_0x458790]['function']?_[_0x4db9('0x73')](_0x435fc9[_0x1354d5[_0x458790][_0x4db9('0x74')]],'%s',_0x4ad693):_0x4ad693;_0x4ad693=_0x1354d5[_0x458790][_0x4db9('0x75')]?_[_0x4db9('0x73')](_0x125b69[_0x1354d5[_0x458790][_0x4db9('0x75')]],'%s',_0x4ad693):_0x4ad693;if(_0x1354d5[_0x458790]['groupBy']){_0x4dc8d6['group'](_0x4ad693);}_0x1354d5[_0x458790][_0x4db9('0x76')]&&_0x4dc8d6[_0x4db9('0x37')](_0x4ad693,_0x1354d5[_0x458790]['orderBy']==='DESC'?![]:!![]);_0x4dc8d6[_0x4db9('0x6c')](_0x4ad693,_0x1354d5[_0x458790]['alias']||_0x4ad693);}if(_0x7aea3a[_0x4db9('0x77')]){_0x7aea3a['joins']=JSON[_0x4db9('0x78')](_0x7aea3a[_0x4db9('0x77')]);for(var _0x52611e=0x0;_0x52611e<_0x7aea3a['joins'][_0x4db9('0x34')];_0x52611e+=0x1){if(_0x7aea3a[_0x4db9('0x77')][_0x52611e][_0x4db9('0x3d')]&&_[_0x4db9('0x64')](_0x5d4c9e,_0x7aea3a[_0x4db9('0x77')][_0x52611e]['type'])&&_0x7aea3a['joins'][_0x52611e]['parentKey']&&_0x7aea3a['joins'][_0x52611e][_0x4db9('0x79')]&&_0x7aea3a[_0x4db9('0x77')][_0x52611e][_0x4db9('0x7a')]){_0x4dc8d6[_0x7aea3a[_0x4db9('0x77')][_0x52611e]['type']](_0x7aea3a[_0x4db9('0x77')][_0x52611e]['foreignTable'],null,util[_0x4db9('0x75')](_0x4db9('0x7b'),_0x7aea3a[_0x4db9('0x71')],_0x7aea3a[_0x4db9('0x77')][_0x52611e][_0x4db9('0x7c')],_0x7aea3a[_0x4db9('0x77')][_0x52611e][_0x4db9('0x79')],_0x7aea3a['joins'][_0x52611e][_0x4db9('0x7a')]));}}}if(_0x7aea3a[_0x4db9('0x7d')]){_0x7aea3a[_0x4db9('0x7d')]=JSON['parse'](_0x7aea3a[_0x4db9('0x7d')]);_0x4dc8d6[_0x4db9('0x39')](_0x215538(_0x7aea3a['conditions']['group']));}_0x2d91d9=_0x4dc8d6[_0x4db9('0x7e')]();_0x4dc8d6['limit'](_0x23a853);_0x4dc8d6['offset'](0x0);logger[_0x4db9('0x7f')](_0x4db9('0x80'),_0x4dc8d6[_0x4db9('0x81')]());return db['sequelize']['query'](_0x4dc8d6['toString'](),{'type':db['sequelize']['QueryTypes'][_0x4db9('0x82')]});}})[_0x4db9('0x21')](respondWithResult(_0x48a084,null))[_0x4db9('0x44')](handleError(_0x48a084,null));};function runReport(_0x437f6a,_0x19c43b,_0x193b1d){var _0x19ffe2=_0x19c43b[_0x4db9('0x28')];var _0x4c5be0=0xa;var _0x173a6c=[_0x4db9('0x54'),_0x4db9('0x55'),_0x4db9('0x56'),_0x4db9('0x57')];var _0x3b928e={'SUM':_0x4db9('0x58'),'COUNT':_0x4db9('0x59'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x4db9('0x5b'),'MIN':'MIN(%s)','AVG':_0x4db9('0x5d'),'GROUP_CONCAT':_0x4db9('0x5e'),'GROUP_CONCAT ASC':_0x4db9('0x5f'),'GROUP_CONCAT DESC':_0x4db9('0x60')};var _0x4edbf6={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x4db9('0x61'),'HOUR':'HOUR(%s)','ROUND':_0x4db9('0x83'),'UNIX_TIMESTAMP':_0x4db9('0x63')};var _0x8f605f=function(_0x445414){return!_[_0x4db9('0x64')]([_0x4db9('0x65'),_0x4db9('0x66'),_0x4db9('0x67'),'IS\x20NOT\x20EMPTY'],_0x445414);};var _0x3707f2=function(_0xdc3e6f){if(!_0xdc3e6f||!_0xdc3e6f[_0x4db9('0x69')][_0x4db9('0x34')]){return'';}for(var _0x4c1c51='(',_0x3137dd=0x0;_0x3137dd<_0xdc3e6f[_0x4db9('0x69')]['length'];_0x3137dd+=0x1){_0x3137dd>0x0&&(_0x4c1c51+='\x20'+_0xdc3e6f[_0x4db9('0x6a')]+'\x20');_0x4c1c51+=_0xdc3e6f[_0x4db9('0x69')][_0x3137dd][_0x4db9('0x6b')]?_0x3707f2(_0xdc3e6f['rules'][_0x3137dd]['group']):_0xdc3e6f[_0x4db9('0x69')][_0x3137dd][_0x4db9('0x6c')]+'\x20'+_0xdc3e6f['rules'][_0x3137dd]['condition']+(_0x8f605f(_0xdc3e6f[_0x4db9('0x69')][_0x3137dd][_0x4db9('0x84')])?'\x20'+_0xdc3e6f[_0x4db9('0x69')][_0x3137dd][_0x4db9('0x85')]:'');}return _0x4c1c51+')';};var _0x34c0e9={'where':{'id':_0x437f6a['id']}},_0x1af543,_0x2d672f,_0x28d35a,_0xb5c0a0,_0x1f24b4;_0x34c0e9=_[_0x4db9('0x3b')]({},_0x34c0e9,_0x193b1d);return db[_0x4db9('0x2b')][_0x4db9('0x48')](_0x34c0e9)[_0x4db9('0x21')](function(_0x1c31fe){if(_0x1c31fe){_0x1af543=_0x1c31fe;return _0x1c31fe['getFields']();}return null;})[_0x4db9('0x21')](function(_0x541687){if(_0x541687){if(!_0x541687[_0x4db9('0x34')]){throw new db['Sequelize'][(_0x4db9('0x86'))](_0x4db9('0x87'),0x193);}_0x2d672f=_0x541687;return db[_0x4db9('0x6e')][_0x4db9('0x42')]({'raw':!![]});}return null;})[_0x4db9('0x21')](function(_0x3af042){if(_0x3af042){_0x28d35a=_[_0x4db9('0x6f')](_0x3af042,'id');var _0x242ea1;var _0x409b69=squel[_0x4db9('0x70')]();_0x409b69[_0x4db9('0x88')](_0x1af543[_0x4db9('0x71')]);for(var _0x59b98b=0x0;_0x59b98b<_0x2d672f[_0x4db9('0x34')];_0x59b98b+=0x1){_0x242ea1=_0x2d672f[_0x59b98b][_0x4db9('0x72')]?_0x28d35a[_0x2d672f[_0x59b98b]['MetricId']][_0x4db9('0x89')]:_0x2d672f[_0x59b98b][_0x4db9('0x6c')];_0x242ea1=_0x2d672f[_0x59b98b][_0x4db9('0x74')]?_[_0x4db9('0x73')](_0x3b928e[_0x2d672f[_0x59b98b]['function']],'%s',_0x242ea1):_0x242ea1;_0x242ea1=_0x2d672f[_0x59b98b]['format']?_[_0x4db9('0x73')](_0x4edbf6[_0x2d672f[_0x59b98b]['format']],'%s',_0x242ea1):_0x242ea1;if(_0x2d672f[_0x59b98b][_0x4db9('0x8a')]){_0x409b69[_0x4db9('0x6b')](_0x242ea1);}_0x2d672f[_0x59b98b][_0x4db9('0x76')]&&_0x409b69[_0x4db9('0x37')](_0x242ea1,_0x2d672f[_0x59b98b][_0x4db9('0x76')]===_0x4db9('0x8b')?![]:!![]);_0x409b69['field'](_0x242ea1,_0x2d672f[_0x59b98b][_0x4db9('0x8c')]||_0x242ea1);}if(_0x1af543[_0x4db9('0x77')]){_0x1af543[_0x4db9('0x77')]=JSON[_0x4db9('0x78')](_0x1af543[_0x4db9('0x77')]);for(var _0x1684be=0x0;_0x1684be<_0x1af543[_0x4db9('0x77')]['length'];_0x1684be+=0x1){if(_0x1af543[_0x4db9('0x77')][_0x1684be][_0x4db9('0x3d')]&&_[_0x4db9('0x64')](_0x173a6c,_0x1af543[_0x4db9('0x77')][_0x1684be]['type'])&&_0x1af543['joins'][_0x1684be]['parentKey']&&_0x1af543[_0x4db9('0x77')][_0x1684be][_0x4db9('0x79')]&&_0x1af543[_0x4db9('0x77')][_0x1684be]['foreignKey']){_0x409b69[_0x1af543['joins'][_0x1684be][_0x4db9('0x3d')]](_0x1af543[_0x4db9('0x77')][_0x1684be]['foreignTable'],null,util['format'](_0x4db9('0x7b'),_0x1af543[_0x4db9('0x71')],_0x1af543['joins'][_0x1684be]['parentKey'],_0x1af543[_0x4db9('0x77')][_0x1684be]['foreignTable'],_0x1af543['joins'][_0x1684be][_0x4db9('0x7a')]));}}}if(_0x1af543[_0x4db9('0x7d')]){_0x1af543[_0x4db9('0x7d')]=JSON['parse'](_0x1af543[_0x4db9('0x7d')]);_0x409b69['where'](_0x3707f2(_0x1af543[_0x4db9('0x7d')]['group']));}_0x1f24b4=_0x409b69[_0x4db9('0x7e')]();_0x409b69[_0x4db9('0x1b')](_0x4c5be0);_0x409b69[_0x4db9('0x36')](0x0);logger[_0x4db9('0x7f')](_0x4db9('0x80'),_0x409b69[_0x4db9('0x81')]());return db[_0x4db9('0x8d')]['query'](_0x409b69['toString'](),{'type':db['sequelize']['QueryTypes'][_0x4db9('0x82')]});}})['then'](function(_0x1f5e81){if(!_0x1f5e81['length']){throw new db['Sequelize'][(_0x4db9('0x86'))]('No\x20available\x20data',0xcc);}if(_0x19c43b[_0x4db9('0x8e')]===_0x4db9('0x8f')){return null;}var _0x24f4fd=_[_0x4db9('0x3b')](_0x19c43b,{'name':_0x19c43b[_0x4db9('0x90')]||_0x19c43b[_0x4db9('0x28')]||_0x1af543[_0x4db9('0x28')],'basename':_0x19ffe2,'savename':util[_0x4db9('0x75')](_0x4db9('0x91'),_0x19c43b[_0x4db9('0x28')]||_0x1af543[_0x4db9('0x28')],require(_0x4db9('0x92'))[_0x4db9('0x93')](0x4),_0x19c43b[_0x4db9('0x8e')]||_0x4db9('0x94')),'reportId':_0x1af543['id'],'reportType':'default'});return db[_0x4db9('0x95')][_0x4db9('0x49')](_0x24f4fd,{'raw':!![]});})[_0x4db9('0x21')](function(_0x24d16d){if(_0x1af543[_0x4db9('0x71')]===_0x4db9('0x96')){_0x1f24b4[_0x4db9('0x39')](_0x1af543['table']+_0x4db9('0x97'),_0x19c43b[_0x4db9('0x98')],_0x19c43b['endDate']);}else{_0x1f24b4[_0x4db9('0x39')](_0x1af543[_0x4db9('0x71')]+_0x4db9('0x99'),_0x19c43b['startDate'],_0x19c43b['endDate']);}if(_0x24d16d){logger[_0x4db9('0x9a')](_0x4db9('0x9b'),_0x1f24b4[_0x4db9('0x81')]());require(_0x4db9('0x9c'))['fork'](path[_0x4db9('0x54')](__dirname,_0x4db9('0x9d'),_0x24d16d[_0x4db9('0x8e')]),[_0x24d16d['id'],_0x1f24b4[_0x4db9('0x81')](),path[_0x4db9('0x54')](__dirname,'../../files/reports',_0x24d16d[_0x4db9('0x9e')]),_0x19ffe2]);return _0x24d16d;}else{var _0xaab4d2=squel[_0x4db9('0x70')]();_0xaab4d2['from']('('+_0x1f24b4[_0x4db9('0x81')]()+')','countTable');_0xaab4d2['field'](_0x4db9('0x9f'),_0x4db9('0x1a'));_0x1f24b4[_0x4db9('0x1b')](_0x19c43b[_0x4db9('0x1b')]||_0x4c5be0);_0x1f24b4[_0x4db9('0x36')](_0x19c43b[_0x4db9('0x36')]||0x0);return db['sequelize'][_0x4db9('0x31')](_0xaab4d2[_0x4db9('0x81')](),{'type':db['sequelize'][_0x4db9('0xa0')][_0x4db9('0x82')]})[_0x4db9('0x21')](function(_0x49f86f){if(!_0x49f86f[_0x4db9('0x34')]){_0xb5c0a0=0x0;}else{_0xb5c0a0=_0x49f86f[0x0][_0x4db9('0x1a')]||0x0;}return db[_0x4db9('0x8d')][_0x4db9('0x31')](_0x1f24b4[_0x4db9('0x81')](),{'type':db[_0x4db9('0x8d')][_0x4db9('0xa0')]['SELECT']});})[_0x4db9('0x21')](function(_0xf74a65){return{'rows':_0xf74a65||[],'count':_0xb5c0a0};});}});}exports['run']=function(_0x1329b8,_0x1b8ec6){return runReport(_0x1329b8[_0x4db9('0x46')],_0x1329b8[_0x4db9('0x31')],_0x1329b8[_0x4db9('0x40')])[_0x4db9('0x21')](respondWithResult(_0x1b8ec6,null))['catch'](handleError(_0x1b8ec6,null));};exports['runReport']=runReport;exports[_0x4db9('0x31')]=function(_0x24614d,_0x406a21){var _0x2d4961=0xa;var _0x216591=['join',_0x4db9('0x55'),_0x4db9('0x56'),_0x4db9('0x57')];var _0x51568a={'SUM':_0x4db9('0x58'),'COUNT':_0x4db9('0x59'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x4db9('0x5b'),'MIN':_0x4db9('0x5c'),'AVG':'AVG(%s)','GROUP_CONCAT':_0x4db9('0x5e'),'GROUP_CONCAT ASC':_0x4db9('0x5f'),'GROUP_CONCAT DESC':_0x4db9('0x60')};var _0x5c8ee9={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':'DATE(%s)','HOUR':_0x4db9('0x62'),'ROUND':_0x4db9('0x83'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x38ce33=function(_0x7d2fe0){return!_[_0x4db9('0x64')]([_0x4db9('0x65'),_0x4db9('0x66'),_0x4db9('0x67'),_0x4db9('0x68')],_0x7d2fe0);};var _0x5cf46c=function(_0x22ba86){if(!_0x22ba86||!_0x22ba86['rules']['length']){return'';}for(var _0x1f2d3f='(',_0x509b91=0x0;_0x509b91<_0x22ba86[_0x4db9('0x69')]['length'];_0x509b91+=0x1){_0x509b91>0x0&&(_0x1f2d3f+='\x20'+_0x22ba86['operator']+'\x20');_0x1f2d3f+=_0x22ba86['rules'][_0x509b91]['group']?_0x5cf46c(_0x22ba86[_0x4db9('0x69')][_0x509b91][_0x4db9('0x6b')]):_0x22ba86[_0x4db9('0x69')][_0x509b91][_0x4db9('0x6c')]+'\x20'+_0x22ba86['rules'][_0x509b91][_0x4db9('0x84')]+(_0x38ce33(_0x22ba86[_0x4db9('0x69')][_0x509b91]['condition'])?'\x20'+_0x22ba86[_0x4db9('0x69')][_0x509b91][_0x4db9('0x85')]:'');}return _0x1f2d3f+')';};var _0x436230={'where':{'id':_0x24614d[_0x4db9('0x46')]['id']}},_0xc1d733,_0x24c502,_0x32e51c,_0x5c35f0,_0x28c275;_0x436230=_['merge']({},_0x436230,_0x24614d[_0x4db9('0x40')]);return db[_0x4db9('0x2b')][_0x4db9('0x48')](_0x436230)[_0x4db9('0x21')](function(_0x37aec1){if(_0x37aec1){_0xc1d733=_0x37aec1;return _0x37aec1[_0x4db9('0x6d')]();}return null;})[_0x4db9('0x21')](function(_0x5a7dca){if(_0x5a7dca){if(!_0x5a7dca[_0x4db9('0x34')]){throw new db[(_0x4db9('0xa1'))][(_0x4db9('0x86'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x24c502=_0x5a7dca;return db[_0x4db9('0x6e')]['findAll']({'raw':!![]});}return null;})[_0x4db9('0x21')](function(_0x51b9d3){if(_0x51b9d3){_0x32e51c=_[_0x4db9('0x6f')](_0x51b9d3,'id');var _0x269cc8;var _0x28f774=squel['select']();_0x28f774[_0x4db9('0x88')](_0xc1d733[_0x4db9('0x71')]);for(var _0x5bdb27=0x0;_0x5bdb27<_0x24c502[_0x4db9('0x34')];_0x5bdb27+=0x1){_0x269cc8=_0x24c502[_0x5bdb27]['MetricId']?_0x32e51c[_0x24c502[_0x5bdb27]['MetricId']][_0x4db9('0x89')]:_0x24c502[_0x5bdb27][_0x4db9('0x6c')];_0x269cc8=_0x24c502[_0x5bdb27][_0x4db9('0x74')]?_[_0x4db9('0x73')](_0x51568a[_0x24c502[_0x5bdb27][_0x4db9('0x74')]],'%s',_0x269cc8):_0x269cc8;_0x269cc8=_0x24c502[_0x5bdb27][_0x4db9('0x75')]?_[_0x4db9('0x73')](_0x5c8ee9[_0x24c502[_0x5bdb27][_0x4db9('0x75')]],'%s',_0x269cc8):_0x269cc8;if(_0x24c502[_0x5bdb27]['groupBy']){_0x28f774[_0x4db9('0x6b')](_0x269cc8);}_0x24c502[_0x5bdb27][_0x4db9('0x76')]&&_0x28f774[_0x4db9('0x37')](_0x269cc8,_0x24c502[_0x5bdb27][_0x4db9('0x76')]===_0x4db9('0x8b')?![]:!![]);_0x28f774['field'](_0x269cc8,_0x24c502[_0x5bdb27]['alias']||_0x269cc8);}if(_0xc1d733['joins']){_0xc1d733[_0x4db9('0x77')]=JSON['parse'](_0xc1d733[_0x4db9('0x77')]);for(var _0xcf68d6=0x0;_0xcf68d6<_0xc1d733[_0x4db9('0x77')]['length'];_0xcf68d6+=0x1){if(_0xc1d733[_0x4db9('0x77')][_0xcf68d6]['type']&&_[_0x4db9('0x64')](_0x216591,_0xc1d733[_0x4db9('0x77')][_0xcf68d6]['type'])&&_0xc1d733[_0x4db9('0x77')][_0xcf68d6]['parentKey']&&_0xc1d733[_0x4db9('0x77')][_0xcf68d6][_0x4db9('0x79')]&&_0xc1d733[_0x4db9('0x77')][_0xcf68d6][_0x4db9('0x7a')]){_0x28f774[_0xc1d733[_0x4db9('0x77')][_0xcf68d6]['type']](_0xc1d733['joins'][_0xcf68d6]['foreignTable'],null,util[_0x4db9('0x75')](_0x4db9('0x7b'),_0xc1d733[_0x4db9('0x71')],_0xc1d733[_0x4db9('0x77')][_0xcf68d6][_0x4db9('0x7c')],_0xc1d733[_0x4db9('0x77')][_0xcf68d6][_0x4db9('0x79')],_0xc1d733[_0x4db9('0x77')][_0xcf68d6][_0x4db9('0x7a')]));}}}if(_0xc1d733[_0x4db9('0x7d')]){_0xc1d733[_0x4db9('0x7d')]=JSON[_0x4db9('0x78')](_0xc1d733[_0x4db9('0x7d')]);_0x28f774[_0x4db9('0x39')](_0x5cf46c(_0xc1d733[_0x4db9('0x7d')][_0x4db9('0x6b')]));}_0x28c275=_0x28f774[_0x4db9('0x7e')]();_0x28f774[_0x4db9('0x1b')](_0x2d4961);_0x28f774[_0x4db9('0x36')](0x0);logger[_0x4db9('0x7f')](_0x4db9('0x80'),_0x28f774['toString']());return db[_0x4db9('0x8d')]['query'](_0x28f774[_0x4db9('0x81')](),{'type':db['sequelize'][_0x4db9('0xa0')][_0x4db9('0x82')]});}})[_0x4db9('0x21')](function(){return{'sql':_0x28c275[_0x4db9('0x81')]()};})['then'](respondWithResult(_0x406a21,null))[_0x4db9('0x44')](handleError(_0x406a21,null));};
\ No newline at end of file
+var _0xde2c=['UserProfileResource','error','name','status','send','index','AnalyticDefaultReport','rawAttributes','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','map','type','key','VIRTUAL','field','options','findAll','rows','catch','show','params','includeAll','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','user','get','Reports','UserProfileSection','userProfileId','DefaultReports','find','right_join','cross_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','condition','value','Sequelize','keyBy','table','MetricId','metric','function','replace','format','groupBy','orderBy','DESC','joins','parse','parentKey','foreignKey','foreignTable','%s.%s\x20=\x20%s.%s','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','join','left_join','MAX(%s)','SEC_TO_TIME(%s)','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','select','from','alias','No\x20available\x20data','web','%s-%s.%s','randomstring','generate','output','csv','.calldate\x20BETWEEN\x20?\x20AND\x20?','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','startDate','info','Run\x20Query:','child_process','fork','../../components/export/','../../files/reports','savename','countTable','COUNT(*)','run','DATE(%s)','getFields','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','sox','to-csv','ejs','squel','crypto','jsforce','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','../../config/environment','../../mysqldb','sendStatus','end','json','count','offset','limit','apply','save','update','destroy','then'];(function(_0x3d5ad8,_0x338d1c){var _0x40bf6a=function(_0x4be312){while(--_0x4be312){_0x3d5ad8['push'](_0x3d5ad8['shift']());}};_0x40bf6a(++_0x338d1c);}(_0xde2c,0x7f));var _0xcde2=function(_0x3da612,_0x332456){_0x3da612=_0x3da612-0x0;var _0x1a9d1d=_0xde2c[_0x3da612];return _0x1a9d1d;};'use strict';var pdf=require(_0xcde2('0x0'));var emlformat=require(_0xcde2('0x1'));var rimraf=require(_0xcde2('0x2'));var zipdir=require(_0xcde2('0x3'));var jsonpatch=require(_0xcde2('0x4'));var rp=require(_0xcde2('0x5'));var moment=require(_0xcde2('0x6'));var BPromise=require(_0xcde2('0x7'));var Mustache=require('mustache');var util=require(_0xcde2('0x8'));var path=require(_0xcde2('0x9'));var sox=require(_0xcde2('0xa'));var csv=require(_0xcde2('0xb'));var ejs=require(_0xcde2('0xc'));var fs=require('fs');var _=require('lodash');var squel=require(_0xcde2('0xd'));var crypto=require(_0xcde2('0xe'));var jsforce=require(_0xcde2('0xf'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0xcde2('0x10'));var Papa=require(_0xcde2('0x11'));var Redis=require('ioredis');var authService=require(_0xcde2('0x12'));var qs=require(_0xcde2('0x13'));var hardwareService=require(_0xcde2('0x14'));var logger=require(_0xcde2('0x15'))('api');var utils=require('../../config/utils');var config=require(_0xcde2('0x16'));var db=require(_0xcde2('0x17'))['db'];function respondWithStatusCode(_0x3b1333,_0x39a973){_0x39a973=_0x39a973||0xcc;return function(_0x932b90){if(_0x932b90){return _0x3b1333[_0xcde2('0x18')](_0x39a973);}return _0x3b1333['status'](_0x39a973)[_0xcde2('0x19')]();};}function respondWithResult(_0x577062,_0x31c3ba){_0x31c3ba=_0x31c3ba||0xc8;return function(_0x4f0ac9){if(_0x4f0ac9){return _0x577062['status'](_0x31c3ba)[_0xcde2('0x1a')](_0x4f0ac9);}};}function respondWithFilteredResult(_0x1c7103,_0x417505){return function(_0x19b54b){if(_0x19b54b){var _0x11665c=_0x19b54b[_0xcde2('0x1b')],_0x5312c7=_0x417505[_0xcde2('0x1c')],_0x39b023=_0x417505[_0xcde2('0x1c')]+_0x417505[_0xcde2('0x1d')],_0x4c558b;if(_0x39b023>=_0x11665c){_0x39b023=_0x11665c;_0x4c558b=0xc8;}else{_0x4c558b=0xce;}_0x1c7103['status'](_0x4c558b);return _0x1c7103['set']('Content-Range',_0x5312c7+'-'+_0x39b023+'/'+_0x11665c)[_0xcde2('0x1a')](_0x19b54b);}return null;};}function patchUpdates(_0x582e84){return function(_0x285ac7){try{jsonpatch[_0xcde2('0x1e')](_0x285ac7,_0x582e84,!![]);}catch(_0x252372){return BPromise['reject'](_0x252372);}return _0x285ac7[_0xcde2('0x1f')]();};}function saveUpdates(_0x24d76f,_0x208368){return function(_0x3c1d7e){if(_0x3c1d7e){return _0x3c1d7e[_0xcde2('0x20')](_0x24d76f)['then'](function(_0x4bce90){return _0x4bce90;});}return null;};}function removeEntity(_0x5a92b9,_0xb96dc0){return function(_0x3e5170){if(_0x3e5170){return _0x3e5170[_0xcde2('0x21')]()[_0xcde2('0x22')](function(){var _0xc86374=_0x3e5170['get']({'plain':!![]});var _0x1104b8='DefaultReports';return db[_0xcde2('0x23')][_0xcde2('0x21')]({'where':{'type':_0x1104b8,'resourceId':_0xc86374['id']}})[_0xcde2('0x22')](function(){return _0x3e5170;});})['then'](function(){_0x5a92b9['status'](0xcc)[_0xcde2('0x19')]();});}};}function handleEntityNotFound(_0x207a12,_0x3e8aaf){return function(_0x217ec9){if(!_0x217ec9){_0x207a12[_0xcde2('0x18')](0x194);}return _0x217ec9;};}function handleError(_0x5a5b92,_0x2d1d17){_0x2d1d17=_0x2d1d17||0x1f4;return function(_0x45275a){logger[_0xcde2('0x24')](_0x45275a['stack']);if(_0x45275a[_0xcde2('0x25')]){delete _0x45275a[_0xcde2('0x25')];}_0x5a5b92[_0xcde2('0x26')](_0x2d1d17)[_0xcde2('0x27')](_0x45275a);};}exports[_0xcde2('0x28')]=function(_0x5b2b7,_0x40b12c){var _0x3e492f={},_0x5bf1e6={},_0x3c3c01={'count':0x0,'rows':[]};var _0x4a0826=db[_0xcde2('0x29')][_0xcde2('0x2a')];_0x5bf1e6[_0xcde2('0x2b')]=_['keys'](_0x4a0826);_0x5bf1e6[_0xcde2('0x2c')]=_[_0xcde2('0x2d')](_0x5b2b7['query']);_0x5bf1e6[_0xcde2('0x2e')]=_[_0xcde2('0x2f')](_0x5bf1e6[_0xcde2('0x2b')],_0x5bf1e6[_0xcde2('0x2c')]);_0x3e492f[_0xcde2('0x30')]=_[_0xcde2('0x2f')](_0x5bf1e6[_0xcde2('0x2b')],qs[_0xcde2('0x31')](_0x5b2b7['query'][_0xcde2('0x31')]));_0x3e492f[_0xcde2('0x30')]=_0x3e492f[_0xcde2('0x30')][_0xcde2('0x32')]?_0x3e492f['attributes']:_0x5bf1e6[_0xcde2('0x2b')];if(!_0x5b2b7[_0xcde2('0x2c')][_0xcde2('0x33')](_0xcde2('0x34'))){_0x3e492f['limit']=qs[_0xcde2('0x1d')](_0x5b2b7[_0xcde2('0x2c')][_0xcde2('0x1d')]);_0x3e492f[_0xcde2('0x1c')]=qs['offset'](_0x5b2b7[_0xcde2('0x2c')][_0xcde2('0x1c')]);}_0x3e492f[_0xcde2('0x35')]=qs[_0xcde2('0x36')](_0x5b2b7[_0xcde2('0x2c')]['sort']);_0x3e492f[_0xcde2('0x37')]=qs[_0xcde2('0x2e')](_[_0xcde2('0x38')](_0x5b2b7[_0xcde2('0x2c')],_0x5bf1e6['filters']));if(_0x5b2b7['query'][_0xcde2('0x39')]){_0x3e492f[_0xcde2('0x37')]=_[_0xcde2('0x3a')](_0x3e492f[_0xcde2('0x37')],{'$or':_[_0xcde2('0x3b')](_0x4a0826,function(_0x45af6e){if(_0x45af6e[_0xcde2('0x3c')][_0xcde2('0x3d')]!==_0xcde2('0x3e')){var _0x5d02b3={};_0x5d02b3[_0x45af6e[_0xcde2('0x3f')]]={'$like':'%'+_0x5b2b7[_0xcde2('0x2c')][_0xcde2('0x39')]+'%'};return _0x5d02b3;}})});}_0x3e492f=_[_0xcde2('0x3a')]({},_0x3e492f,_0x5b2b7[_0xcde2('0x40')]);var _0x47b6ee={'where':_0x3e492f['where']};return db[_0xcde2('0x29')][_0xcde2('0x1b')](_0x47b6ee)[_0xcde2('0x22')](function(_0x383899){_0x3c3c01[_0xcde2('0x1b')]=_0x383899;if(_0x5b2b7[_0xcde2('0x2c')]['includeAll']){_0x3e492f['include']=[{'all':!![]}];}return db['AnalyticDefaultReport'][_0xcde2('0x41')](_0x3e492f);})[_0xcde2('0x22')](function(_0x1cfe20){_0x3c3c01[_0xcde2('0x42')]=_0x1cfe20;return _0x3c3c01;})[_0xcde2('0x22')](respondWithFilteredResult(_0x40b12c,_0x3e492f))[_0xcde2('0x43')](handleError(_0x40b12c,null));};exports[_0xcde2('0x44')]=function(_0x49b862,_0x48580a){var _0x6f60d5={'raw':!![],'where':{'id':_0x49b862[_0xcde2('0x45')]['id']}},_0x578bf1={};_0x578bf1['model']=_[_0xcde2('0x2d')](db[_0xcde2('0x29')][_0xcde2('0x2a')]);_0x578bf1['query']=_[_0xcde2('0x2d')](_0x49b862['query']);_0x578bf1[_0xcde2('0x2e')]=_[_0xcde2('0x2f')](_0x578bf1[_0xcde2('0x2b')],_0x578bf1[_0xcde2('0x2c')]);_0x6f60d5[_0xcde2('0x30')]=_[_0xcde2('0x2f')](_0x578bf1['model'],qs['fields'](_0x49b862[_0xcde2('0x2c')]['fields']));_0x6f60d5['attributes']=_0x6f60d5[_0xcde2('0x30')]['length']?_0x6f60d5[_0xcde2('0x30')]:_0x578bf1[_0xcde2('0x2b')];if(_0x49b862['query'][_0xcde2('0x46')]){_0x6f60d5['include']=[{'all':!![]}];}_0x6f60d5=_['merge']({},_0x6f60d5,_0x49b862[_0xcde2('0x40')]);return db[_0xcde2('0x29')]['find'](_0x6f60d5)[_0xcde2('0x22')](handleEntityNotFound(_0x48580a,null))['then'](respondWithResult(_0x48580a,null))[_0xcde2('0x43')](handleError(_0x48580a,null));};exports[_0xcde2('0x47')]=function(_0x2d7b55,_0x411103){return db[_0xcde2('0x29')]['create'](_0x2d7b55[_0xcde2('0x48')],{})[_0xcde2('0x22')](function(_0x40d14b){var _0x2c78a5=_0x2d7b55['user']['get']({'plain':!![]});if(!_0x2c78a5)throw new Error(_0xcde2('0x49'));if(_0x2c78a5['role']===_0xcde2('0x4a')){var _0x3e9e79=_0x40d14b[_0xcde2('0x4b')]({'plain':!![]});var _0x16675f=_0xcde2('0x4c');return db[_0xcde2('0x4d')]['find']({'where':{'name':_0x16675f,'userProfileId':_0x2c78a5[_0xcde2('0x4e')]},'raw':!![]})['then'](function(_0x1a76a5){if(_0x1a76a5&&_0x1a76a5['autoAssociation']===0x0){return db[_0xcde2('0x23')][_0xcde2('0x47')]({'name':_0x3e9e79[_0xcde2('0x25')],'resourceId':_0x3e9e79['id'],'type':_0xcde2('0x4f'),'sectionId':_0x1a76a5['id']},{})[_0xcde2('0x22')](function(){return _0x40d14b;});}else{return _0x40d14b;}})[_0xcde2('0x43')](function(_0x52fbc4){logger[_0xcde2('0x24')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x52fbc4);throw _0x52fbc4;});}return _0x40d14b;})[_0xcde2('0x22')](respondWithResult(_0x411103,0xc9))[_0xcde2('0x43')](handleError(_0x411103,null));};exports[_0xcde2('0x20')]=function(_0x428a55,_0x1e1c9e){if(_0x428a55[_0xcde2('0x48')]['id']){delete _0x428a55[_0xcde2('0x48')]['id'];}return db[_0xcde2('0x29')][_0xcde2('0x50')]({'where':{'id':_0x428a55[_0xcde2('0x45')]['id']}})[_0xcde2('0x22')](handleEntityNotFound(_0x1e1c9e,null))[_0xcde2('0x22')](saveUpdates(_0x428a55['body'],null))['then'](respondWithResult(_0x1e1c9e,null))['catch'](handleError(_0x1e1c9e,null));};exports[_0xcde2('0x21')]=function(_0x59a64d,_0x1751dd){return db[_0xcde2('0x29')][_0xcde2('0x50')]({'where':{'id':_0x59a64d['params']['id']}})[_0xcde2('0x22')](handleEntityNotFound(_0x1751dd,null))['then'](removeEntity(_0x1751dd,null))[_0xcde2('0x43')](handleError(_0x1751dd,null));};exports['preview']=function(_0x1085d2,_0x10d6ab){var _0x50d2bf=0xa;var _0x418dd1=['join','left_join',_0xcde2('0x51'),_0xcde2('0x52')];var _0x8eddd4={'SUM':_0xcde2('0x53'),'COUNT':_0xcde2('0x54'),'COUNT DISTINCT':_0xcde2('0x55'),'MAX':'MAX(%s)','MIN':_0xcde2('0x56'),'AVG':_0xcde2('0x57'),'GROUP_CONCAT':_0xcde2('0x58'),'GROUP_CONCAT ASC':_0xcde2('0x59'),'GROUP_CONCAT DESC':_0xcde2('0x5a')};var _0x541a70={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':'DATE(%s)','HOUR':_0xcde2('0x5b'),'ROUND':_0xcde2('0x5c'),'UNIX_TIMESTAMP':_0xcde2('0x5d')};var _0x109472=function(_0x4c298b){return!_[_0xcde2('0x5e')]([_0xcde2('0x5f'),_0xcde2('0x60'),_0xcde2('0x61'),_0xcde2('0x62')],_0x4c298b);};var _0x35453a=function(_0x50a1db){if(!_0x50a1db||!_0x50a1db[_0xcde2('0x63')][_0xcde2('0x32')]){return'';}for(var _0x585165='(',_0x124335=0x0;_0x124335<_0x50a1db[_0xcde2('0x63')][_0xcde2('0x32')];_0x124335+=0x1){_0x124335>0x0&&(_0x585165+='\x20'+_0x50a1db[_0xcde2('0x64')]+'\x20');_0x585165+=_0x50a1db[_0xcde2('0x63')][_0x124335][_0xcde2('0x65')]?_0x35453a(_0x50a1db[_0xcde2('0x63')][_0x124335][_0xcde2('0x65')]):_0x50a1db[_0xcde2('0x63')][_0x124335][_0xcde2('0x3f')]+'\x20'+_0x50a1db['rules'][_0x124335][_0xcde2('0x66')]+(_0x109472(_0x50a1db[_0xcde2('0x63')][_0x124335]['condition'])?'\x20'+_0x50a1db[_0xcde2('0x63')][_0x124335][_0xcde2('0x67')]:'');}return _0x585165+')';};var _0x2bc67c={'where':{'id':_0x1085d2[_0xcde2('0x45')]['id']}},_0x5aaa3f,_0x1efcbd,_0x1253c6,_0x2ce985,_0x3b1ca7;_0x2bc67c=_[_0xcde2('0x3a')]({},_0x2bc67c,_0x1085d2[_0xcde2('0x40')]);return db[_0xcde2('0x29')][_0xcde2('0x50')](_0x2bc67c)[_0xcde2('0x22')](function(_0x3b0961){if(_0x3b0961){_0x5aaa3f=_0x3b0961;return _0x3b0961['getFields']();}return null;})['then'](function(_0x39c723){if(_0x39c723){if(!_0x39c723[_0xcde2('0x32')]){throw new db[(_0xcde2('0x68'))]['ValidationErrorItem']('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x1efcbd=_0x39c723;return db['AnalyticMetric'][_0xcde2('0x41')]({'raw':!![]});}return null;})[_0xcde2('0x22')](function(_0x161a8b){if(_0x161a8b){_0x1253c6=_[_0xcde2('0x69')](_0x161a8b,'id');var _0x325b51;var _0x333cbb=squel['select']();_0x333cbb['from'](_0x5aaa3f[_0xcde2('0x6a')]);for(var _0xa66188=0x0;_0xa66188<_0x1efcbd[_0xcde2('0x32')];_0xa66188+=0x1){_0x325b51=_0x1efcbd[_0xa66188][_0xcde2('0x6b')]?_0x1253c6[_0x1efcbd[_0xa66188][_0xcde2('0x6b')]][_0xcde2('0x6c')]:_0x1efcbd[_0xa66188][_0xcde2('0x3f')];_0x325b51=_0x1efcbd[_0xa66188][_0xcde2('0x6d')]?_[_0xcde2('0x6e')](_0x8eddd4[_0x1efcbd[_0xa66188][_0xcde2('0x6d')]],'%s',_0x325b51):_0x325b51;_0x325b51=_0x1efcbd[_0xa66188][_0xcde2('0x6f')]?_[_0xcde2('0x6e')](_0x541a70[_0x1efcbd[_0xa66188][_0xcde2('0x6f')]],'%s',_0x325b51):_0x325b51;if(_0x1efcbd[_0xa66188][_0xcde2('0x70')]){_0x333cbb[_0xcde2('0x65')](_0x325b51);}_0x1efcbd[_0xa66188][_0xcde2('0x71')]&&_0x333cbb[_0xcde2('0x35')](_0x325b51,_0x1efcbd[_0xa66188][_0xcde2('0x71')]===_0xcde2('0x72')?![]:!![]);_0x333cbb[_0xcde2('0x3f')](_0x325b51,_0x1efcbd[_0xa66188]['alias']||_0x325b51);}if(_0x5aaa3f[_0xcde2('0x73')]){_0x5aaa3f[_0xcde2('0x73')]=JSON[_0xcde2('0x74')](_0x5aaa3f[_0xcde2('0x73')]);for(var _0x912306=0x0;_0x912306<_0x5aaa3f['joins'][_0xcde2('0x32')];_0x912306+=0x1){if(_0x5aaa3f['joins'][_0x912306][_0xcde2('0x3c')]&&_[_0xcde2('0x5e')](_0x418dd1,_0x5aaa3f[_0xcde2('0x73')][_0x912306][_0xcde2('0x3c')])&&_0x5aaa3f[_0xcde2('0x73')][_0x912306][_0xcde2('0x75')]&&_0x5aaa3f[_0xcde2('0x73')][_0x912306]['foreignTable']&&_0x5aaa3f['joins'][_0x912306][_0xcde2('0x76')]){_0x333cbb[_0x5aaa3f['joins'][_0x912306][_0xcde2('0x3c')]](_0x5aaa3f[_0xcde2('0x73')][_0x912306][_0xcde2('0x77')],null,util[_0xcde2('0x6f')](_0xcde2('0x78'),_0x5aaa3f[_0xcde2('0x6a')],_0x5aaa3f[_0xcde2('0x73')][_0x912306]['parentKey'],_0x5aaa3f[_0xcde2('0x73')][_0x912306][_0xcde2('0x77')],_0x5aaa3f[_0xcde2('0x73')][_0x912306][_0xcde2('0x76')]));}}}if(_0x5aaa3f['conditions']){_0x5aaa3f[_0xcde2('0x79')]=JSON[_0xcde2('0x74')](_0x5aaa3f[_0xcde2('0x79')]);_0x333cbb[_0xcde2('0x37')](_0x35453a(_0x5aaa3f[_0xcde2('0x79')][_0xcde2('0x65')]));}_0x3b1ca7=_0x333cbb[_0xcde2('0x7a')]();_0x333cbb[_0xcde2('0x1d')](_0x50d2bf);_0x333cbb[_0xcde2('0x1c')](0x0);logger[_0xcde2('0x7b')](_0xcde2('0x7c'),_0x333cbb[_0xcde2('0x7d')]());return db[_0xcde2('0x7e')]['query'](_0x333cbb[_0xcde2('0x7d')](),{'type':db[_0xcde2('0x7e')][_0xcde2('0x7f')][_0xcde2('0x80')]});}})[_0xcde2('0x22')](respondWithResult(_0x10d6ab,null))[_0xcde2('0x43')](handleError(_0x10d6ab,null));};function runReport(_0x42493d,_0x9ed7e6,_0x422fec){var _0x27ffe1=_0x9ed7e6[_0xcde2('0x25')];var _0x18b0a1=0xa;var _0x2ac055=[_0xcde2('0x81'),_0xcde2('0x82'),_0xcde2('0x51'),'cross_join'];var _0x598fdd={'SUM':_0xcde2('0x53'),'COUNT':_0xcde2('0x54'),'COUNT DISTINCT':_0xcde2('0x55'),'MAX':_0xcde2('0x83'),'MIN':'MIN(%s)','AVG':_0xcde2('0x57'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0xcde2('0x59'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x476e2f={'SEC_TO_TIME':_0xcde2('0x84'),'DATE':'DATE(%s)','HOUR':_0xcde2('0x5b'),'ROUND':_0xcde2('0x5c'),'UNIX_TIMESTAMP':_0xcde2('0x5d')};var _0x59d195=function(_0x1bbc7e){return!_[_0xcde2('0x5e')]([_0xcde2('0x5f'),_0xcde2('0x60'),'IS\x20EMPTY','IS\x20NOT\x20EMPTY'],_0x1bbc7e);};var _0xc70ceb=function(_0x3fa065){if(!_0x3fa065||!_0x3fa065[_0xcde2('0x63')][_0xcde2('0x32')]){return'';}for(var _0x335a54='(',_0xddfade=0x0;_0xddfade<_0x3fa065['rules'][_0xcde2('0x32')];_0xddfade+=0x1){_0xddfade>0x0&&(_0x335a54+='\x20'+_0x3fa065[_0xcde2('0x64')]+'\x20');_0x335a54+=_0x3fa065[_0xcde2('0x63')][_0xddfade][_0xcde2('0x65')]?_0xc70ceb(_0x3fa065[_0xcde2('0x63')][_0xddfade][_0xcde2('0x65')]):_0x3fa065[_0xcde2('0x63')][_0xddfade]['field']+'\x20'+_0x3fa065[_0xcde2('0x63')][_0xddfade][_0xcde2('0x66')]+(_0x59d195(_0x3fa065['rules'][_0xddfade][_0xcde2('0x66')])?'\x20'+_0x3fa065[_0xcde2('0x63')][_0xddfade][_0xcde2('0x67')]:'');}return _0x335a54+')';};var _0x55c35f={'where':{'id':_0x42493d['id']}},_0x2e0684,_0x27e039,_0x482093,_0x4a8e17,_0x4b44c1;_0x55c35f=_[_0xcde2('0x3a')]({},_0x55c35f,_0x422fec);return db[_0xcde2('0x29')]['find'](_0x55c35f)[_0xcde2('0x22')](function(_0x5e5437){if(_0x5e5437){_0x2e0684=_0x5e5437;return _0x5e5437['getFields']();}return null;})[_0xcde2('0x22')](function(_0x243504){if(_0x243504){if(!_0x243504[_0xcde2('0x32')]){throw new db['Sequelize'][(_0xcde2('0x85'))](_0xcde2('0x86'),0x193);}_0x27e039=_0x243504;return db[_0xcde2('0x87')][_0xcde2('0x41')]({'raw':!![]});}return null;})[_0xcde2('0x22')](function(_0x191ee9){if(_0x191ee9){_0x482093=_[_0xcde2('0x69')](_0x191ee9,'id');var _0x540673;var _0x59d539=squel[_0xcde2('0x88')]();_0x59d539[_0xcde2('0x89')](_0x2e0684[_0xcde2('0x6a')]);for(var _0xc61e4=0x0;_0xc61e4<_0x27e039[_0xcde2('0x32')];_0xc61e4+=0x1){_0x540673=_0x27e039[_0xc61e4]['MetricId']?_0x482093[_0x27e039[_0xc61e4][_0xcde2('0x6b')]]['metric']:_0x27e039[_0xc61e4]['field'];_0x540673=_0x27e039[_0xc61e4][_0xcde2('0x6d')]?_['replace'](_0x598fdd[_0x27e039[_0xc61e4]['function']],'%s',_0x540673):_0x540673;_0x540673=_0x27e039[_0xc61e4][_0xcde2('0x6f')]?_[_0xcde2('0x6e')](_0x476e2f[_0x27e039[_0xc61e4][_0xcde2('0x6f')]],'%s',_0x540673):_0x540673;if(_0x27e039[_0xc61e4][_0xcde2('0x70')]){_0x59d539[_0xcde2('0x65')](_0x540673);}_0x27e039[_0xc61e4]['orderBy']&&_0x59d539[_0xcde2('0x35')](_0x540673,_0x27e039[_0xc61e4]['orderBy']===_0xcde2('0x72')?![]:!![]);_0x59d539[_0xcde2('0x3f')](_0x540673,_0x27e039[_0xc61e4][_0xcde2('0x8a')]||_0x540673);}if(_0x2e0684[_0xcde2('0x73')]){_0x2e0684['joins']=JSON['parse'](_0x2e0684['joins']);for(var _0x472f71=0x0;_0x472f71<_0x2e0684['joins']['length'];_0x472f71+=0x1){if(_0x2e0684[_0xcde2('0x73')][_0x472f71][_0xcde2('0x3c')]&&_[_0xcde2('0x5e')](_0x2ac055,_0x2e0684[_0xcde2('0x73')][_0x472f71][_0xcde2('0x3c')])&&_0x2e0684[_0xcde2('0x73')][_0x472f71][_0xcde2('0x75')]&&_0x2e0684['joins'][_0x472f71][_0xcde2('0x77')]&&_0x2e0684[_0xcde2('0x73')][_0x472f71][_0xcde2('0x76')]){_0x59d539[_0x2e0684[_0xcde2('0x73')][_0x472f71][_0xcde2('0x3c')]](_0x2e0684[_0xcde2('0x73')][_0x472f71][_0xcde2('0x77')],null,util['format'](_0xcde2('0x78'),_0x2e0684['table'],_0x2e0684['joins'][_0x472f71][_0xcde2('0x75')],_0x2e0684[_0xcde2('0x73')][_0x472f71][_0xcde2('0x77')],_0x2e0684[_0xcde2('0x73')][_0x472f71][_0xcde2('0x76')]));}}}if(_0x2e0684[_0xcde2('0x79')]){_0x2e0684[_0xcde2('0x79')]=JSON['parse'](_0x2e0684[_0xcde2('0x79')]);_0x59d539[_0xcde2('0x37')](_0xc70ceb(_0x2e0684[_0xcde2('0x79')]['group']));}_0x4b44c1=_0x59d539[_0xcde2('0x7a')]();_0x59d539[_0xcde2('0x1d')](_0x18b0a1);_0x59d539['offset'](0x0);logger['debug'](_0xcde2('0x7c'),_0x59d539[_0xcde2('0x7d')]());return db[_0xcde2('0x7e')][_0xcde2('0x2c')](_0x59d539[_0xcde2('0x7d')](),{'type':db['sequelize']['QueryTypes'][_0xcde2('0x80')]});}})['then'](function(_0x26a4dd){if(!_0x26a4dd[_0xcde2('0x32')]){throw new db[(_0xcde2('0x68'))][(_0xcde2('0x85'))](_0xcde2('0x8b'),0xcc);}if(_0x9ed7e6['output']===_0xcde2('0x8c')){return null;}var _0x3e3fec=_[_0xcde2('0x3a')](_0x9ed7e6,{'name':_0x9ed7e6['fullPath']||_0x9ed7e6['name']||_0x2e0684[_0xcde2('0x25')],'basename':_0x27ffe1,'savename':util['format'](_0xcde2('0x8d'),_0x9ed7e6[_0xcde2('0x25')]||_0x2e0684[_0xcde2('0x25')],require(_0xcde2('0x8e'))[_0xcde2('0x8f')](0x4),_0x9ed7e6[_0xcde2('0x90')]||_0xcde2('0x91')),'reportId':_0x2e0684['id'],'reportType':'default'});return db['AnalyticExtractedReport'][_0xcde2('0x47')](_0x3e3fec,{'raw':!![]});})[_0xcde2('0x22')](function(_0x417795){if(_0x2e0684['table']==='cdr'){_0x4b44c1[_0xcde2('0x37')](_0x2e0684[_0xcde2('0x6a')]+_0xcde2('0x92'),_0x9ed7e6['startDate'],_0x9ed7e6[_0xcde2('0x93')]);}else{_0x4b44c1[_0xcde2('0x37')](_0x2e0684['table']+_0xcde2('0x94'),_0x9ed7e6[_0xcde2('0x95')],_0x9ed7e6[_0xcde2('0x93')]);}if(_0x417795){logger[_0xcde2('0x96')](_0xcde2('0x97'),_0x4b44c1[_0xcde2('0x7d')]());require(_0xcde2('0x98'))[_0xcde2('0x99')](path['join'](__dirname,_0xcde2('0x9a'),_0x417795[_0xcde2('0x90')]),[_0x417795['id'],_0x4b44c1[_0xcde2('0x7d')](),path['join'](__dirname,_0xcde2('0x9b'),_0x417795[_0xcde2('0x9c')]),_0x27ffe1]);return _0x417795;}else{var _0x168f5c=squel[_0xcde2('0x88')]();_0x168f5c['from']('('+_0x4b44c1[_0xcde2('0x7d')]()+')',_0xcde2('0x9d'));_0x168f5c[_0xcde2('0x3f')](_0xcde2('0x9e'),_0xcde2('0x1b'));_0x4b44c1['limit'](_0x9ed7e6['limit']||_0x18b0a1);_0x4b44c1['offset'](_0x9ed7e6[_0xcde2('0x1c')]||0x0);return db[_0xcde2('0x7e')]['query'](_0x168f5c[_0xcde2('0x7d')](),{'type':db[_0xcde2('0x7e')][_0xcde2('0x7f')]['SELECT']})[_0xcde2('0x22')](function(_0xd33254){if(!_0xd33254[_0xcde2('0x32')]){_0x4a8e17=0x0;}else{_0x4a8e17=_0xd33254[0x0]['count']||0x0;}return db[_0xcde2('0x7e')][_0xcde2('0x2c')](_0x4b44c1[_0xcde2('0x7d')](),{'type':db[_0xcde2('0x7e')][_0xcde2('0x7f')][_0xcde2('0x80')]});})[_0xcde2('0x22')](function(_0xe2855f){return{'rows':_0xe2855f||[],'count':_0x4a8e17};});}});}exports[_0xcde2('0x9f')]=function(_0x406b1a,_0x2e70f8){return runReport(_0x406b1a[_0xcde2('0x45')],_0x406b1a['query'],_0x406b1a[_0xcde2('0x40')])['then'](respondWithResult(_0x2e70f8,null))[_0xcde2('0x43')](handleError(_0x2e70f8,null));};exports['runReport']=runReport;exports[_0xcde2('0x2c')]=function(_0x555b3e,_0x5c5c33){var _0x18e913=0xa;var _0x1b1c10=[_0xcde2('0x81'),_0xcde2('0x82'),_0xcde2('0x51'),_0xcde2('0x52')];var _0x532842={'SUM':_0xcde2('0x53'),'COUNT':_0xcde2('0x54'),'COUNT DISTINCT':_0xcde2('0x55'),'MAX':_0xcde2('0x83'),'MIN':_0xcde2('0x56'),'AVG':_0xcde2('0x57'),'GROUP_CONCAT':_0xcde2('0x58'),'GROUP_CONCAT ASC':_0xcde2('0x59'),'GROUP_CONCAT DESC':_0xcde2('0x5a')};var _0x231ea8={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0xcde2('0xa0'),'HOUR':_0xcde2('0x5b'),'ROUND':_0xcde2('0x5c'),'UNIX_TIMESTAMP':_0xcde2('0x5d')};var _0x27a6f4=function(_0x15d947){return!_['includes']([_0xcde2('0x5f'),_0xcde2('0x60'),_0xcde2('0x61'),_0xcde2('0x62')],_0x15d947);};var _0x33ac3a=function(_0x27ab58){if(!_0x27ab58||!_0x27ab58[_0xcde2('0x63')][_0xcde2('0x32')]){return'';}for(var _0x4ee3d6='(',_0x5785bf=0x0;_0x5785bf<_0x27ab58[_0xcde2('0x63')][_0xcde2('0x32')];_0x5785bf+=0x1){_0x5785bf>0x0&&(_0x4ee3d6+='\x20'+_0x27ab58[_0xcde2('0x64')]+'\x20');_0x4ee3d6+=_0x27ab58[_0xcde2('0x63')][_0x5785bf][_0xcde2('0x65')]?_0x33ac3a(_0x27ab58[_0xcde2('0x63')][_0x5785bf][_0xcde2('0x65')]):_0x27ab58[_0xcde2('0x63')][_0x5785bf][_0xcde2('0x3f')]+'\x20'+_0x27ab58[_0xcde2('0x63')][_0x5785bf]['condition']+(_0x27a6f4(_0x27ab58[_0xcde2('0x63')][_0x5785bf][_0xcde2('0x66')])?'\x20'+_0x27ab58[_0xcde2('0x63')][_0x5785bf][_0xcde2('0x67')]:'');}return _0x4ee3d6+')';};var _0x150020={'where':{'id':_0x555b3e[_0xcde2('0x45')]['id']}},_0xb4e2e3,_0x5b3823,_0x2cbb7e,_0x49db7b,_0xbb9148;_0x150020=_[_0xcde2('0x3a')]({},_0x150020,_0x555b3e[_0xcde2('0x40')]);return db['AnalyticDefaultReport'][_0xcde2('0x50')](_0x150020)[_0xcde2('0x22')](function(_0x3ab370){if(_0x3ab370){_0xb4e2e3=_0x3ab370;return _0x3ab370[_0xcde2('0xa1')]();}return null;})[_0xcde2('0x22')](function(_0x50d99e){if(_0x50d99e){if(!_0x50d99e[_0xcde2('0x32')]){throw new db[(_0xcde2('0x68'))][(_0xcde2('0x85'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x5b3823=_0x50d99e;return db[_0xcde2('0x87')][_0xcde2('0x41')]({'raw':!![]});}return null;})[_0xcde2('0x22')](function(_0x5ae43c){if(_0x5ae43c){_0x2cbb7e=_['keyBy'](_0x5ae43c,'id');var _0x30ebc6;var _0x28e5c1=squel[_0xcde2('0x88')]();_0x28e5c1[_0xcde2('0x89')](_0xb4e2e3['table']);for(var _0x2cd4f2=0x0;_0x2cd4f2<_0x5b3823['length'];_0x2cd4f2+=0x1){_0x30ebc6=_0x5b3823[_0x2cd4f2][_0xcde2('0x6b')]?_0x2cbb7e[_0x5b3823[_0x2cd4f2][_0xcde2('0x6b')]]['metric']:_0x5b3823[_0x2cd4f2][_0xcde2('0x3f')];_0x30ebc6=_0x5b3823[_0x2cd4f2][_0xcde2('0x6d')]?_['replace'](_0x532842[_0x5b3823[_0x2cd4f2][_0xcde2('0x6d')]],'%s',_0x30ebc6):_0x30ebc6;_0x30ebc6=_0x5b3823[_0x2cd4f2][_0xcde2('0x6f')]?_['replace'](_0x231ea8[_0x5b3823[_0x2cd4f2]['format']],'%s',_0x30ebc6):_0x30ebc6;if(_0x5b3823[_0x2cd4f2]['groupBy']){_0x28e5c1['group'](_0x30ebc6);}_0x5b3823[_0x2cd4f2][_0xcde2('0x71')]&&_0x28e5c1[_0xcde2('0x35')](_0x30ebc6,_0x5b3823[_0x2cd4f2][_0xcde2('0x71')]==='DESC'?![]:!![]);_0x28e5c1[_0xcde2('0x3f')](_0x30ebc6,_0x5b3823[_0x2cd4f2][_0xcde2('0x8a')]||_0x30ebc6);}if(_0xb4e2e3[_0xcde2('0x73')]){_0xb4e2e3[_0xcde2('0x73')]=JSON[_0xcde2('0x74')](_0xb4e2e3[_0xcde2('0x73')]);for(var _0x133d71=0x0;_0x133d71<_0xb4e2e3[_0xcde2('0x73')][_0xcde2('0x32')];_0x133d71+=0x1){if(_0xb4e2e3[_0xcde2('0x73')][_0x133d71][_0xcde2('0x3c')]&&_[_0xcde2('0x5e')](_0x1b1c10,_0xb4e2e3[_0xcde2('0x73')][_0x133d71][_0xcde2('0x3c')])&&_0xb4e2e3[_0xcde2('0x73')][_0x133d71][_0xcde2('0x75')]&&_0xb4e2e3['joins'][_0x133d71]['foreignTable']&&_0xb4e2e3[_0xcde2('0x73')][_0x133d71][_0xcde2('0x76')]){_0x28e5c1[_0xb4e2e3[_0xcde2('0x73')][_0x133d71]['type']](_0xb4e2e3['joins'][_0x133d71]['foreignTable'],null,util[_0xcde2('0x6f')](_0xcde2('0x78'),_0xb4e2e3[_0xcde2('0x6a')],_0xb4e2e3[_0xcde2('0x73')][_0x133d71][_0xcde2('0x75')],_0xb4e2e3['joins'][_0x133d71][_0xcde2('0x77')],_0xb4e2e3[_0xcde2('0x73')][_0x133d71][_0xcde2('0x76')]));}}}if(_0xb4e2e3[_0xcde2('0x79')]){_0xb4e2e3[_0xcde2('0x79')]=JSON[_0xcde2('0x74')](_0xb4e2e3['conditions']);_0x28e5c1[_0xcde2('0x37')](_0x33ac3a(_0xb4e2e3['conditions'][_0xcde2('0x65')]));}_0xbb9148=_0x28e5c1['clone']();_0x28e5c1['limit'](_0x18e913);_0x28e5c1['offset'](0x0);logger[_0xcde2('0x7b')]('Limited\x20Query:',_0x28e5c1['toString']());return db[_0xcde2('0x7e')]['query'](_0x28e5c1[_0xcde2('0x7d')](),{'type':db[_0xcde2('0x7e')][_0xcde2('0x7f')][_0xcde2('0x80')]});}})[_0xcde2('0x22')](function(){return{'sql':_0xbb9148[_0xcde2('0x7d')]()};})[_0xcde2('0x22')](respondWithResult(_0x5c5c33,null))[_0xcde2('0x43')](handleError(_0x5c5c33,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff