// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xe988=['MetricId','replace','format','groupBy','orderBy','DESC','joins','parse','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','parentKey','conditions','Limited\x20Query:','toString','QueryTypes','SELECT','left_join','right_join','cross_join','COUNT(%s)','COUNT(DISTINCT\x20%s)','HOUR(%s)','Sequelize','select','from','function','clone','debug','sequelize','ValidationErrorItem','No\x20available\x20data','output','web','fullPath','%s-%s.%s','randomstring','generate','csv','default','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','info','Run\x20Query:','child_process','../../files/reports','savename','COUNT(*)','SEC_TO_TIME(%s)','IS\x20EMPTY','IS\x20NOT\x20EMPTY','metric','html-pdf','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','ejs','squel','jsforce','desk.js','to-csv','querystring','papaparse','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','json','count','offset','set','Content-Range','apply','reject','update','then','destroy','get','UserProfileResource','end','error','name','index','map','AnalyticDefaultReport','fieldName','key','query','keys','filters','intersection','attributes','model','fields','length','hasOwnProperty','nolimit','limit','order','sort','where','filter','type','merge','options','includeAll','include','findAll','rows','catch','params','rawAttributes','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','UserProfileSection','userProfileId','autoAssociation','DefaultReports','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','preview','join','SUM(%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)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','rules','operator','group','field','condition','value','getFields','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','table'];(function(_0x266c6f,_0x1edfcb){var _0x1384ae=function(_0x16eb3f){while(--_0x16eb3f){_0x266c6f['push'](_0x266c6f['shift']());}};_0x1384ae(++_0x1edfcb);}(_0xe988,0x17b));var _0x8e98=function(_0x46aff0,_0x122890){_0x46aff0=_0x46aff0-0x0;var _0x9d78cf=_0xe988[_0x46aff0];return _0x9d78cf;};'use strict';var pdf=require(_0x8e98('0x0'));var emlformat=require(_0x8e98('0x1'));var rimraf=require(_0x8e98('0x2'));var zipdir=require(_0x8e98('0x3'));var jsonpatch=require('fast-json-patch');var rp=require(_0x8e98('0x4'));var moment=require(_0x8e98('0x5'));var BPromise=require(_0x8e98('0x6'));var Mustache=require(_0x8e98('0x7'));var util=require(_0x8e98('0x8'));var path=require(_0x8e98('0x9'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x8e98('0xa'));var fs=require('fs');var _=require('lodash');var squel=require(_0x8e98('0xb'));var crypto=require('crypto');var jsforce=require(_0x8e98('0xc'));var deskjs=require(_0x8e98('0xd'));var toCsv=require(_0x8e98('0xe'));var querystring=require(_0x8e98('0xf'));var Papa=require(_0x8e98('0x10'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0x8e98('0x11'));var hardwareService=require(_0x8e98('0x12'));var logger=require(_0x8e98('0x13'))(_0x8e98('0x14'));var utils=require(_0x8e98('0x15'));var config=require(_0x8e98('0x16'));var db=require(_0x8e98('0x17'))['db'];function respondWithStatusCode(_0x58dd31,_0x262ca7){_0x262ca7=_0x262ca7||0xcc;return function(_0x4ce4de){if(_0x4ce4de){return _0x58dd31[_0x8e98('0x18')](_0x262ca7);}return _0x58dd31[_0x8e98('0x19')](_0x262ca7)['end']();};}function respondWithResult(_0x54b434,_0x32a512){_0x32a512=_0x32a512||0xc8;return function(_0x447147){if(_0x447147){return _0x54b434[_0x8e98('0x19')](_0x32a512)[_0x8e98('0x1a')](_0x447147);}};}function respondWithFilteredResult(_0x21da7e,_0x5c5c36){return function(_0x33fa6f){if(_0x33fa6f){var _0xbd6142=_0x33fa6f[_0x8e98('0x1b')],_0x555572=_0x5c5c36[_0x8e98('0x1c')],_0x10ad90=_0x5c5c36[_0x8e98('0x1c')]+_0x5c5c36['limit'],_0x16fd1;if(_0x10ad90>=_0xbd6142){_0x10ad90=_0xbd6142;_0x16fd1=0xc8;}else{_0x16fd1=0xce;}_0x21da7e[_0x8e98('0x19')](_0x16fd1);return _0x21da7e[_0x8e98('0x1d')](_0x8e98('0x1e'),_0x555572+'-'+_0x10ad90+'/'+_0xbd6142)['json'](_0x33fa6f);}return null;};}function patchUpdates(_0x2e5d7e){return function(_0x3d8c89){try{jsonpatch[_0x8e98('0x1f')](_0x3d8c89,_0x2e5d7e,!![]);}catch(_0x25ab4d){return BPromise[_0x8e98('0x20')](_0x25ab4d);}return _0x3d8c89['save']();};}function saveUpdates(_0x2e0a38,_0x2d5d14){return function(_0x1c5fc4){if(_0x1c5fc4){return _0x1c5fc4[_0x8e98('0x21')](_0x2e0a38)[_0x8e98('0x22')](function(_0x4a2361){return _0x4a2361;});}return null;};}function removeEntity(_0x193725,_0x4236e0){return function(_0x41257e){if(_0x41257e){return _0x41257e[_0x8e98('0x23')]()[_0x8e98('0x22')](function(){var _0x5204b1=_0x41257e[_0x8e98('0x24')]({'plain':!![]});var _0x55b6fe='DefaultReports';return db[_0x8e98('0x25')][_0x8e98('0x23')]({'where':{'type':_0x55b6fe,'resourceId':_0x5204b1['id']}})[_0x8e98('0x22')](function(){return _0x41257e;});})[_0x8e98('0x22')](function(){_0x193725[_0x8e98('0x19')](0xcc)[_0x8e98('0x26')]();});}};}function handleEntityNotFound(_0x343e0f,_0x13d8ab){return function(_0x467d5e){if(!_0x467d5e){_0x343e0f['sendStatus'](0x194);}return _0x467d5e;};}function handleError(_0x4afc4a,_0xfb54c2){_0xfb54c2=_0xfb54c2||0x1f4;return function(_0x6d38b6){logger[_0x8e98('0x27')](_0x6d38b6['stack']);if(_0x6d38b6[_0x8e98('0x28')]){delete _0x6d38b6['name'];}_0x4afc4a[_0x8e98('0x19')](_0xfb54c2)['send'](_0x6d38b6);};}exports[_0x8e98('0x29')]=function(_0x158106,_0x170d7d){var _0x21e416={},_0x5b8521={},_0x5da141={'count':0x0,'rows':[]};var _0xc2504c=_[_0x8e98('0x2a')](db[_0x8e98('0x2b')]['rawAttributes'],function(_0x592997){return{'name':_0x592997[_0x8e98('0x2c')],'type':_0x592997['type'][_0x8e98('0x2d')]};});_0x5b8521['model']=_[_0x8e98('0x2a')](_0xc2504c,_0x8e98('0x28'));_0x5b8521[_0x8e98('0x2e')]=_[_0x8e98('0x2f')](_0x158106[_0x8e98('0x2e')]);_0x5b8521[_0x8e98('0x30')]=_[_0x8e98('0x31')](_0x5b8521['model'],_0x5b8521[_0x8e98('0x2e')]);_0x21e416[_0x8e98('0x32')]=_['intersection'](_0x5b8521[_0x8e98('0x33')],qs[_0x8e98('0x34')](_0x158106[_0x8e98('0x2e')][_0x8e98('0x34')]));_0x21e416[_0x8e98('0x32')]=_0x21e416[_0x8e98('0x32')][_0x8e98('0x35')]?_0x21e416[_0x8e98('0x32')]:_0x5b8521['model'];if(!_0x158106[_0x8e98('0x2e')][_0x8e98('0x36')](_0x8e98('0x37'))){_0x21e416['limit']=qs[_0x8e98('0x38')](_0x158106[_0x8e98('0x2e')][_0x8e98('0x38')]);_0x21e416[_0x8e98('0x1c')]=qs[_0x8e98('0x1c')](_0x158106[_0x8e98('0x2e')][_0x8e98('0x1c')]);}_0x21e416[_0x8e98('0x39')]=qs[_0x8e98('0x3a')](_0x158106['query'][_0x8e98('0x3a')]);_0x21e416[_0x8e98('0x3b')]=qs[_0x8e98('0x30')](_['pick'](_0x158106['query'],_0x5b8521[_0x8e98('0x30')]));if(_0x158106[_0x8e98('0x2e')][_0x8e98('0x3c')]){_0x21e416[_0x8e98('0x3b')]=_['merge'](_0x21e416[_0x8e98('0x3b')],{'$or':_[_0x8e98('0x2a')](_0xc2504c,function(_0x43caaa){if(_0x43caaa[_0x8e98('0x3d')]!=='VIRTUAL'){var _0x17ffd3={};_0x17ffd3[_0x43caaa[_0x8e98('0x28')]]={'$like':'%'+_0x158106[_0x8e98('0x2e')][_0x8e98('0x3c')]+'%'};return _0x17ffd3;}})});}_0x21e416=_[_0x8e98('0x3e')]({},_0x21e416,_0x158106[_0x8e98('0x3f')]);var _0x5514c3={'where':_0x21e416[_0x8e98('0x3b')]};return db[_0x8e98('0x2b')][_0x8e98('0x1b')](_0x5514c3)[_0x8e98('0x22')](function(_0x25b78b){_0x5da141[_0x8e98('0x1b')]=_0x25b78b;if(_0x158106[_0x8e98('0x2e')][_0x8e98('0x40')]){_0x21e416[_0x8e98('0x41')]=[{'all':!![]}];}return db[_0x8e98('0x2b')][_0x8e98('0x42')](_0x21e416);})[_0x8e98('0x22')](function(_0x7d0354){_0x5da141[_0x8e98('0x43')]=_0x7d0354;return _0x5da141;})['then'](respondWithFilteredResult(_0x170d7d,_0x21e416))[_0x8e98('0x44')](handleError(_0x170d7d,null));};exports['show']=function(_0x481ba5,_0x593f5a){var _0x33093e={'raw':!![],'where':{'id':_0x481ba5[_0x8e98('0x45')]['id']}},_0x29ced6={};_0x29ced6[_0x8e98('0x33')]=_[_0x8e98('0x2f')](db[_0x8e98('0x2b')][_0x8e98('0x46')]);_0x29ced6[_0x8e98('0x2e')]=_[_0x8e98('0x2f')](_0x481ba5[_0x8e98('0x2e')]);_0x29ced6[_0x8e98('0x30')]=_['intersection'](_0x29ced6[_0x8e98('0x33')],_0x29ced6[_0x8e98('0x2e')]);_0x33093e[_0x8e98('0x32')]=_[_0x8e98('0x31')](_0x29ced6['model'],qs[_0x8e98('0x34')](_0x481ba5[_0x8e98('0x2e')]['fields']));_0x33093e[_0x8e98('0x32')]=_0x33093e[_0x8e98('0x32')][_0x8e98('0x35')]?_0x33093e[_0x8e98('0x32')]:_0x29ced6[_0x8e98('0x33')];if(_0x481ba5[_0x8e98('0x2e')][_0x8e98('0x40')]){_0x33093e[_0x8e98('0x41')]=[{'all':!![]}];}_0x33093e=_[_0x8e98('0x3e')]({},_0x33093e,_0x481ba5[_0x8e98('0x3f')]);return db[_0x8e98('0x2b')][_0x8e98('0x47')](_0x33093e)[_0x8e98('0x22')](handleEntityNotFound(_0x593f5a,null))[_0x8e98('0x22')](respondWithResult(_0x593f5a,null))[_0x8e98('0x44')](handleError(_0x593f5a,null));};exports[_0x8e98('0x48')]=function(_0x56ea7c,_0x5d2bdc){return db[_0x8e98('0x2b')]['create'](_0x56ea7c[_0x8e98('0x49')],{})[_0x8e98('0x22')](function(_0xddb244){var _0x58674d=_0x56ea7c[_0x8e98('0x4a')][_0x8e98('0x24')]({'plain':!![]});if(!_0x58674d)throw new Error(_0x8e98('0x4b'));if(_0x58674d['role']===_0x8e98('0x4a')){var _0x3d49c2=_0xddb244[_0x8e98('0x24')]({'plain':!![]});var _0x3b9404='Reports';return db[_0x8e98('0x4c')][_0x8e98('0x47')]({'where':{'name':_0x3b9404,'userProfileId':_0x58674d[_0x8e98('0x4d')]},'raw':!![]})[_0x8e98('0x22')](function(_0x35332e){if(_0x35332e&&_0x35332e[_0x8e98('0x4e')]===0x0){return db[_0x8e98('0x25')][_0x8e98('0x48')]({'name':_0x3d49c2['name'],'resourceId':_0x3d49c2['id'],'type':_0x8e98('0x4f'),'sectionId':_0x35332e['id']},{})[_0x8e98('0x22')](function(){return _0xddb244;});}else{return _0xddb244;}})['catch'](function(_0x2c5344){logger[_0x8e98('0x27')](_0x8e98('0x50'),_0x2c5344);throw _0x2c5344;});}return _0xddb244;})[_0x8e98('0x22')](respondWithResult(_0x5d2bdc,0xc9))['catch'](handleError(_0x5d2bdc,null));};exports[_0x8e98('0x21')]=function(_0x4c1c8a,_0x56473a){if(_0x4c1c8a['body']['id']){delete _0x4c1c8a[_0x8e98('0x49')]['id'];}return db['AnalyticDefaultReport'][_0x8e98('0x47')]({'where':{'id':_0x4c1c8a[_0x8e98('0x45')]['id']}})['then'](handleEntityNotFound(_0x56473a,null))[_0x8e98('0x22')](saveUpdates(_0x4c1c8a[_0x8e98('0x49')],null))[_0x8e98('0x22')](respondWithResult(_0x56473a,null))[_0x8e98('0x44')](handleError(_0x56473a,null));};exports[_0x8e98('0x23')]=function(_0x542174,_0xc9668c){return db['AnalyticDefaultReport'][_0x8e98('0x47')]({'where':{'id':_0x542174['params']['id']}})[_0x8e98('0x22')](handleEntityNotFound(_0xc9668c,null))['then'](removeEntity(_0xc9668c,null))[_0x8e98('0x44')](handleError(_0xc9668c,null));};exports[_0x8e98('0x51')]=function(_0x3a83db,_0x4c4175){var _0x238a08=0xa;var _0x27bff8=[_0x8e98('0x52'),'left_join','right_join','cross_join'];var _0x2c293d={'SUM':_0x8e98('0x53'),'COUNT':'COUNT(%s)','COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x8e98('0x54'),'MIN':_0x8e98('0x55'),'AVG':_0x8e98('0x56'),'GROUP_CONCAT':_0x8e98('0x57'),'GROUP_CONCAT ASC':_0x8e98('0x58'),'GROUP_CONCAT DESC':_0x8e98('0x59')};var _0x5b8586={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x8e98('0x5a'),'HOUR':'HOUR(%s)','ROUND':_0x8e98('0x5b'),'UNIX_TIMESTAMP':_0x8e98('0x5c')};var _0x16258d=function(_0xd81b0e){return!_[_0x8e98('0x5d')]([_0x8e98('0x5e'),_0x8e98('0x5f'),'IS\x20EMPTY','IS\x20NOT\x20EMPTY'],_0xd81b0e);};var _0x23e96c=function(_0x3d6b33){if(!_0x3d6b33||!_0x3d6b33[_0x8e98('0x60')][_0x8e98('0x35')]){return'';}for(var _0x225d90='(',_0x27f1cf=0x0;_0x27f1cf<_0x3d6b33[_0x8e98('0x60')][_0x8e98('0x35')];_0x27f1cf+=0x1){_0x27f1cf>0x0&&(_0x225d90+='\x20'+_0x3d6b33[_0x8e98('0x61')]+'\x20');_0x225d90+=_0x3d6b33['rules'][_0x27f1cf]['group']?_0x23e96c(_0x3d6b33[_0x8e98('0x60')][_0x27f1cf][_0x8e98('0x62')]):_0x3d6b33[_0x8e98('0x60')][_0x27f1cf][_0x8e98('0x63')]+'\x20'+_0x3d6b33[_0x8e98('0x60')][_0x27f1cf][_0x8e98('0x64')]+(_0x16258d(_0x3d6b33[_0x8e98('0x60')][_0x27f1cf][_0x8e98('0x64')])?'\x20'+_0x3d6b33['rules'][_0x27f1cf][_0x8e98('0x65')]:'');}return _0x225d90+')';};var _0x2c2b2c={'where':{'id':_0x3a83db[_0x8e98('0x45')]['id']}},_0x55a483,_0x5ab728,_0x2acdfa,_0x4e861a,_0x192ae3;_0x2c2b2c=_[_0x8e98('0x3e')]({},_0x2c2b2c,_0x3a83db[_0x8e98('0x3f')]);return db[_0x8e98('0x2b')][_0x8e98('0x47')](_0x2c2b2c)[_0x8e98('0x22')](function(_0x194254){if(_0x194254){_0x55a483=_0x194254;return _0x194254[_0x8e98('0x66')]();}return null;})[_0x8e98('0x22')](function(_0x378e07){if(_0x378e07){if(!_0x378e07[_0x8e98('0x35')]){throw new db['Sequelize']['ValidationErrorItem'](_0x8e98('0x67'),0x193);}_0x5ab728=_0x378e07;return db[_0x8e98('0x68')][_0x8e98('0x42')]({'raw':!![]});}return null;})[_0x8e98('0x22')](function(_0x3fa013){if(_0x3fa013){_0x2acdfa=_[_0x8e98('0x69')](_0x3fa013,'id');var _0x5b9c61;var _0x3095d8=squel['select']();_0x3095d8['from'](_0x55a483[_0x8e98('0x6a')]);for(var _0x5bb053=0x0;_0x5bb053<_0x5ab728['length'];_0x5bb053+=0x1){_0x5b9c61=_0x5ab728[_0x5bb053][_0x8e98('0x6b')]?_0x2acdfa[_0x5ab728[_0x5bb053][_0x8e98('0x6b')]]['metric']:_0x5ab728[_0x5bb053]['field'];_0x5b9c61=_0x5ab728[_0x5bb053]['function']?_[_0x8e98('0x6c')](_0x2c293d[_0x5ab728[_0x5bb053]['function']],'%s',_0x5b9c61):_0x5b9c61;_0x5b9c61=_0x5ab728[_0x5bb053][_0x8e98('0x6d')]?_[_0x8e98('0x6c')](_0x5b8586[_0x5ab728[_0x5bb053]['format']],'%s',_0x5b9c61):_0x5b9c61;if(_0x5ab728[_0x5bb053][_0x8e98('0x6e')]){_0x3095d8[_0x8e98('0x62')](_0x5b9c61);}_0x5ab728[_0x5bb053][_0x8e98('0x6f')]&&_0x3095d8['order'](_0x5b9c61,_0x5ab728[_0x5bb053][_0x8e98('0x6f')]===_0x8e98('0x70')?![]:!![]);_0x3095d8[_0x8e98('0x63')](_0x5b9c61,_0x5ab728[_0x5bb053]['alias']||_0x5b9c61);}if(_0x55a483['joins']){_0x55a483[_0x8e98('0x71')]=JSON[_0x8e98('0x72')](_0x55a483['joins']);for(var _0x177767=0x0;_0x177767<_0x55a483[_0x8e98('0x71')]['length'];_0x177767+=0x1){if(_0x55a483[_0x8e98('0x71')][_0x177767]['type']&&_[_0x8e98('0x5d')](_0x27bff8,_0x55a483[_0x8e98('0x71')][_0x177767][_0x8e98('0x3d')])&&_0x55a483['joins'][_0x177767]['parentKey']&&_0x55a483[_0x8e98('0x71')][_0x177767][_0x8e98('0x73')]&&_0x55a483['joins'][_0x177767][_0x8e98('0x74')]){_0x3095d8[_0x55a483['joins'][_0x177767]['type']](_0x55a483['joins'][_0x177767][_0x8e98('0x73')],null,util['format'](_0x8e98('0x75'),_0x55a483['table'],_0x55a483[_0x8e98('0x71')][_0x177767][_0x8e98('0x76')],_0x55a483[_0x8e98('0x71')][_0x177767][_0x8e98('0x73')],_0x55a483['joins'][_0x177767][_0x8e98('0x74')]));}}}if(_0x55a483[_0x8e98('0x77')]){_0x55a483[_0x8e98('0x77')]=JSON['parse'](_0x55a483[_0x8e98('0x77')]);_0x3095d8[_0x8e98('0x3b')](_0x23e96c(_0x55a483[_0x8e98('0x77')][_0x8e98('0x62')]));}_0x192ae3=_0x3095d8['clone']();_0x3095d8[_0x8e98('0x38')](_0x238a08);_0x3095d8[_0x8e98('0x1c')](0x0);logger['debug'](_0x8e98('0x78'),_0x3095d8[_0x8e98('0x79')]());return db['sequelize'][_0x8e98('0x2e')](_0x3095d8[_0x8e98('0x79')](),{'type':db['sequelize'][_0x8e98('0x7a')][_0x8e98('0x7b')]});}})[_0x8e98('0x22')](respondWithResult(_0x4c4175,null))[_0x8e98('0x44')](handleError(_0x4c4175,null));};function runReport(_0x5175b7,_0x165d89,_0x11ee36){var _0x3a1eaf=_0x165d89[_0x8e98('0x28')];var _0xdc8176=0xa;var _0x58d403=['join',_0x8e98('0x7c'),_0x8e98('0x7d'),_0x8e98('0x7e')];var _0xa190f7={'SUM':'SUM(%s)','COUNT':_0x8e98('0x7f'),'COUNT DISTINCT':_0x8e98('0x80'),'MAX':_0x8e98('0x54'),'MIN':'MIN(%s)','AVG':_0x8e98('0x56'),'GROUP_CONCAT':_0x8e98('0x57'),'GROUP_CONCAT ASC':_0x8e98('0x58'),'GROUP_CONCAT DESC':_0x8e98('0x59')};var _0x3f3162={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x8e98('0x5a'),'HOUR':_0x8e98('0x81'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x8e98('0x5c')};var _0x3ad340=function(_0x5288da){return!_[_0x8e98('0x5d')]([_0x8e98('0x5e'),_0x8e98('0x5f'),'IS\x20EMPTY','IS\x20NOT\x20EMPTY'],_0x5288da);};var _0x3b71a6=function(_0x107d94){if(!_0x107d94||!_0x107d94[_0x8e98('0x60')]['length']){return'';}for(var _0x1caaa6='(',_0x78bcc0=0x0;_0x78bcc0<_0x107d94[_0x8e98('0x60')]['length'];_0x78bcc0+=0x1){_0x78bcc0>0x0&&(_0x1caaa6+='\x20'+_0x107d94['operator']+'\x20');_0x1caaa6+=_0x107d94[_0x8e98('0x60')][_0x78bcc0][_0x8e98('0x62')]?_0x3b71a6(_0x107d94[_0x8e98('0x60')][_0x78bcc0]['group']):_0x107d94[_0x8e98('0x60')][_0x78bcc0][_0x8e98('0x63')]+'\x20'+_0x107d94[_0x8e98('0x60')][_0x78bcc0][_0x8e98('0x64')]+(_0x3ad340(_0x107d94[_0x8e98('0x60')][_0x78bcc0][_0x8e98('0x64')])?'\x20'+_0x107d94[_0x8e98('0x60')][_0x78bcc0]['value']:'');}return _0x1caaa6+')';};var _0x1e3c7a={'where':{'id':_0x5175b7['id']}},_0x24530,_0x1cfdd7,_0x3d54d8,_0x5d9031,_0xc95c55;_0x1e3c7a=_[_0x8e98('0x3e')]({},_0x1e3c7a,_0x11ee36);return db[_0x8e98('0x2b')]['find'](_0x1e3c7a)[_0x8e98('0x22')](function(_0x3cf3e9){if(_0x3cf3e9){_0x24530=_0x3cf3e9;return _0x3cf3e9[_0x8e98('0x66')]();}return null;})[_0x8e98('0x22')](function(_0x4669e0){if(_0x4669e0){if(!_0x4669e0[_0x8e98('0x35')]){throw new db[(_0x8e98('0x82'))]['ValidationErrorItem'](_0x8e98('0x67'),0x193);}_0x1cfdd7=_0x4669e0;return db[_0x8e98('0x68')][_0x8e98('0x42')]({'raw':!![]});}return null;})[_0x8e98('0x22')](function(_0x1d9c2b){if(_0x1d9c2b){_0x3d54d8=_[_0x8e98('0x69')](_0x1d9c2b,'id');var _0x31a98a;var _0x4a5b6a=squel[_0x8e98('0x83')]();_0x4a5b6a[_0x8e98('0x84')](_0x24530[_0x8e98('0x6a')]);for(var _0x2103e4=0x0;_0x2103e4<_0x1cfdd7[_0x8e98('0x35')];_0x2103e4+=0x1){_0x31a98a=_0x1cfdd7[_0x2103e4][_0x8e98('0x6b')]?_0x3d54d8[_0x1cfdd7[_0x2103e4][_0x8e98('0x6b')]]['metric']:_0x1cfdd7[_0x2103e4][_0x8e98('0x63')];_0x31a98a=_0x1cfdd7[_0x2103e4][_0x8e98('0x85')]?_['replace'](_0xa190f7[_0x1cfdd7[_0x2103e4][_0x8e98('0x85')]],'%s',_0x31a98a):_0x31a98a;_0x31a98a=_0x1cfdd7[_0x2103e4]['format']?_['replace'](_0x3f3162[_0x1cfdd7[_0x2103e4][_0x8e98('0x6d')]],'%s',_0x31a98a):_0x31a98a;if(_0x1cfdd7[_0x2103e4][_0x8e98('0x6e')]){_0x4a5b6a['group'](_0x31a98a);}_0x1cfdd7[_0x2103e4][_0x8e98('0x6f')]&&_0x4a5b6a[_0x8e98('0x39')](_0x31a98a,_0x1cfdd7[_0x2103e4][_0x8e98('0x6f')]==='DESC'?![]:!![]);_0x4a5b6a['field'](_0x31a98a,_0x1cfdd7[_0x2103e4]['alias']||_0x31a98a);}if(_0x24530['joins']){_0x24530[_0x8e98('0x71')]=JSON['parse'](_0x24530[_0x8e98('0x71')]);for(var _0x291f57=0x0;_0x291f57<_0x24530[_0x8e98('0x71')]['length'];_0x291f57+=0x1){if(_0x24530[_0x8e98('0x71')][_0x291f57][_0x8e98('0x3d')]&&_['includes'](_0x58d403,_0x24530[_0x8e98('0x71')][_0x291f57]['type'])&&_0x24530[_0x8e98('0x71')][_0x291f57][_0x8e98('0x76')]&&_0x24530[_0x8e98('0x71')][_0x291f57][_0x8e98('0x73')]&&_0x24530['joins'][_0x291f57][_0x8e98('0x74')]){_0x4a5b6a[_0x24530[_0x8e98('0x71')][_0x291f57]['type']](_0x24530[_0x8e98('0x71')][_0x291f57][_0x8e98('0x73')],null,util[_0x8e98('0x6d')]('%s.%s\x20=\x20%s.%s',_0x24530[_0x8e98('0x6a')],_0x24530['joins'][_0x291f57][_0x8e98('0x76')],_0x24530['joins'][_0x291f57][_0x8e98('0x73')],_0x24530[_0x8e98('0x71')][_0x291f57]['foreignKey']));}}}if(_0x24530[_0x8e98('0x77')]){_0x24530[_0x8e98('0x77')]=JSON['parse'](_0x24530[_0x8e98('0x77')]);_0x4a5b6a[_0x8e98('0x3b')](_0x3b71a6(_0x24530['conditions']['group']));}_0xc95c55=_0x4a5b6a[_0x8e98('0x86')]();_0x4a5b6a['limit'](_0xdc8176);_0x4a5b6a['offset'](0x0);logger[_0x8e98('0x87')]('Limited\x20Query:',_0x4a5b6a[_0x8e98('0x79')]());return db[_0x8e98('0x88')][_0x8e98('0x2e')](_0x4a5b6a[_0x8e98('0x79')](),{'type':db[_0x8e98('0x88')][_0x8e98('0x7a')][_0x8e98('0x7b')]});}})[_0x8e98('0x22')](function(_0x1e044){if(!_0x1e044[_0x8e98('0x35')]){throw new db[(_0x8e98('0x82'))][(_0x8e98('0x89'))](_0x8e98('0x8a'),0xcc);}if(_0x165d89[_0x8e98('0x8b')]===_0x8e98('0x8c')){return null;}var _0xe2c4bb=_[_0x8e98('0x3e')](_0x165d89,{'name':_0x165d89[_0x8e98('0x8d')]||_0x165d89[_0x8e98('0x28')]||_0x24530['name'],'basename':_0x3a1eaf,'savename':util[_0x8e98('0x6d')](_0x8e98('0x8e'),_0x165d89[_0x8e98('0x28')]||_0x24530[_0x8e98('0x28')],require(_0x8e98('0x8f'))[_0x8e98('0x90')](0x4),_0x165d89[_0x8e98('0x8b')]||_0x8e98('0x91')),'reportId':_0x24530['id'],'reportType':_0x8e98('0x92')});return db[_0x8e98('0x93')][_0x8e98('0x48')](_0xe2c4bb,{'raw':!![]});})['then'](function(_0x5ca1b4){if(_0x24530[_0x8e98('0x6a')]===_0x8e98('0x94')){_0xc95c55[_0x8e98('0x3b')](_0x24530[_0x8e98('0x6a')]+_0x8e98('0x95'),_0x165d89[_0x8e98('0x96')],_0x165d89[_0x8e98('0x97')]);}else{_0xc95c55[_0x8e98('0x3b')](_0x24530[_0x8e98('0x6a')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x165d89[_0x8e98('0x96')],_0x165d89[_0x8e98('0x97')]);}if(_0x5ca1b4){logger[_0x8e98('0x98')](_0x8e98('0x99'),_0xc95c55[_0x8e98('0x79')]());require(_0x8e98('0x9a'))['fork'](path[_0x8e98('0x52')](__dirname,'../../components/export/',_0x5ca1b4[_0x8e98('0x8b')]),[_0x5ca1b4['id'],_0xc95c55[_0x8e98('0x79')](),path[_0x8e98('0x52')](__dirname,_0x8e98('0x9b'),_0x5ca1b4[_0x8e98('0x9c')]),_0x3a1eaf]);return _0x5ca1b4;}else{var _0xf7eee7=squel[_0x8e98('0x83')]();_0xf7eee7[_0x8e98('0x84')]('('+_0xc95c55[_0x8e98('0x79')]()+')','countTable');_0xf7eee7['field'](_0x8e98('0x9d'),_0x8e98('0x1b'));_0xc95c55[_0x8e98('0x38')](_0x165d89['limit']||_0xdc8176);_0xc95c55[_0x8e98('0x1c')](_0x165d89[_0x8e98('0x1c')]||0x0);return db['sequelize'][_0x8e98('0x2e')](_0xf7eee7['toString'](),{'type':db[_0x8e98('0x88')]['QueryTypes']['SELECT']})['then'](function(_0xe03198){if(!_0xe03198[_0x8e98('0x35')]){_0x5d9031=0x0;}else{_0x5d9031=_0xe03198[0x0]['count']||0x0;}return db[_0x8e98('0x88')][_0x8e98('0x2e')](_0xc95c55[_0x8e98('0x79')](),{'type':db[_0x8e98('0x88')]['QueryTypes']['SELECT']});})['then'](function(_0xeab4b0){return{'rows':_0xeab4b0||[],'count':_0x5d9031};});}});}exports['run']=function(_0x2a9a8a,_0x2a9dc5){return runReport(_0x2a9a8a[_0x8e98('0x45')],_0x2a9a8a[_0x8e98('0x2e')],_0x2a9a8a[_0x8e98('0x3f')])[_0x8e98('0x22')](respondWithResult(_0x2a9dc5,null))[_0x8e98('0x44')](handleError(_0x2a9dc5,null));};exports['runReport']=runReport;exports[_0x8e98('0x2e')]=function(_0x29f29e,_0x2270bf){var _0x1fa3e5=0xa;var _0x4854ae=[_0x8e98('0x52'),_0x8e98('0x7c'),_0x8e98('0x7d'),'cross_join'];var _0x12e655={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT DISTINCT':_0x8e98('0x80'),'MAX':_0x8e98('0x54'),'MIN':_0x8e98('0x55'),'AVG':_0x8e98('0x56'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0x8e98('0x59')};var _0x387e15={'SEC_TO_TIME':_0x8e98('0x9e'),'DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':_0x8e98('0x5b'),'UNIX_TIMESTAMP':_0x8e98('0x5c')};var _0x37c5e6=function(_0x140b7c){return!_['includes']([_0x8e98('0x5e'),'IS\x20NOT\x20NULL',_0x8e98('0x9f'),_0x8e98('0xa0')],_0x140b7c);};var _0x27ce65=function(_0x56b903){if(!_0x56b903||!_0x56b903[_0x8e98('0x60')]['length']){return'';}for(var _0x171559='(',_0x57e84e=0x0;_0x57e84e<_0x56b903['rules'][_0x8e98('0x35')];_0x57e84e+=0x1){_0x57e84e>0x0&&(_0x171559+='\x20'+_0x56b903[_0x8e98('0x61')]+'\x20');_0x171559+=_0x56b903[_0x8e98('0x60')][_0x57e84e][_0x8e98('0x62')]?_0x27ce65(_0x56b903['rules'][_0x57e84e][_0x8e98('0x62')]):_0x56b903[_0x8e98('0x60')][_0x57e84e][_0x8e98('0x63')]+'\x20'+_0x56b903[_0x8e98('0x60')][_0x57e84e][_0x8e98('0x64')]+(_0x37c5e6(_0x56b903[_0x8e98('0x60')][_0x57e84e][_0x8e98('0x64')])?'\x20'+_0x56b903[_0x8e98('0x60')][_0x57e84e]['value']:'');}return _0x171559+')';};var _0x3ace97={'where':{'id':_0x29f29e[_0x8e98('0x45')]['id']}},_0x5258ca,_0x346e92,_0x2d6ec6,_0x13f50d,_0x874f7c;_0x3ace97=_[_0x8e98('0x3e')]({},_0x3ace97,_0x29f29e[_0x8e98('0x3f')]);return db['AnalyticDefaultReport']['find'](_0x3ace97)[_0x8e98('0x22')](function(_0x43cf18){if(_0x43cf18){_0x5258ca=_0x43cf18;return _0x43cf18['getFields']();}return null;})['then'](function(_0x3c98ae){if(_0x3c98ae){if(!_0x3c98ae[_0x8e98('0x35')]){throw new db['Sequelize'][(_0x8e98('0x89'))](_0x8e98('0x67'),0x193);}_0x346e92=_0x3c98ae;return db[_0x8e98('0x68')][_0x8e98('0x42')]({'raw':!![]});}return null;})['then'](function(_0x3c6d80){if(_0x3c6d80){_0x2d6ec6=_[_0x8e98('0x69')](_0x3c6d80,'id');var _0x142147;var _0x2e5773=squel['select']();_0x2e5773[_0x8e98('0x84')](_0x5258ca['table']);for(var _0x3c6761=0x0;_0x3c6761<_0x346e92[_0x8e98('0x35')];_0x3c6761+=0x1){_0x142147=_0x346e92[_0x3c6761][_0x8e98('0x6b')]?_0x2d6ec6[_0x346e92[_0x3c6761][_0x8e98('0x6b')]][_0x8e98('0xa1')]:_0x346e92[_0x3c6761][_0x8e98('0x63')];_0x142147=_0x346e92[_0x3c6761][_0x8e98('0x85')]?_[_0x8e98('0x6c')](_0x12e655[_0x346e92[_0x3c6761][_0x8e98('0x85')]],'%s',_0x142147):_0x142147;_0x142147=_0x346e92[_0x3c6761][_0x8e98('0x6d')]?_['replace'](_0x387e15[_0x346e92[_0x3c6761]['format']],'%s',_0x142147):_0x142147;if(_0x346e92[_0x3c6761]['groupBy']){_0x2e5773[_0x8e98('0x62')](_0x142147);}_0x346e92[_0x3c6761][_0x8e98('0x6f')]&&_0x2e5773[_0x8e98('0x39')](_0x142147,_0x346e92[_0x3c6761][_0x8e98('0x6f')]===_0x8e98('0x70')?![]:!![]);_0x2e5773[_0x8e98('0x63')](_0x142147,_0x346e92[_0x3c6761]['alias']||_0x142147);}if(_0x5258ca[_0x8e98('0x71')]){_0x5258ca[_0x8e98('0x71')]=JSON['parse'](_0x5258ca['joins']);for(var _0xae3e61=0x0;_0xae3e61<_0x5258ca[_0x8e98('0x71')][_0x8e98('0x35')];_0xae3e61+=0x1){if(_0x5258ca['joins'][_0xae3e61]['type']&&_[_0x8e98('0x5d')](_0x4854ae,_0x5258ca[_0x8e98('0x71')][_0xae3e61]['type'])&&_0x5258ca[_0x8e98('0x71')][_0xae3e61][_0x8e98('0x76')]&&_0x5258ca[_0x8e98('0x71')][_0xae3e61][_0x8e98('0x73')]&&_0x5258ca[_0x8e98('0x71')][_0xae3e61][_0x8e98('0x74')]){_0x2e5773[_0x5258ca[_0x8e98('0x71')][_0xae3e61]['type']](_0x5258ca[_0x8e98('0x71')][_0xae3e61][_0x8e98('0x73')],null,util['format'](_0x8e98('0x75'),_0x5258ca['table'],_0x5258ca[_0x8e98('0x71')][_0xae3e61][_0x8e98('0x76')],_0x5258ca[_0x8e98('0x71')][_0xae3e61]['foreignTable'],_0x5258ca[_0x8e98('0x71')][_0xae3e61][_0x8e98('0x74')]));}}}if(_0x5258ca[_0x8e98('0x77')]){_0x5258ca[_0x8e98('0x77')]=JSON[_0x8e98('0x72')](_0x5258ca[_0x8e98('0x77')]);_0x2e5773[_0x8e98('0x3b')](_0x27ce65(_0x5258ca[_0x8e98('0x77')][_0x8e98('0x62')]));}_0x874f7c=_0x2e5773[_0x8e98('0x86')]();_0x2e5773[_0x8e98('0x38')](_0x1fa3e5);_0x2e5773[_0x8e98('0x1c')](0x0);logger[_0x8e98('0x87')]('Limited\x20Query:',_0x2e5773[_0x8e98('0x79')]());return db[_0x8e98('0x88')]['query'](_0x2e5773[_0x8e98('0x79')](),{'type':db['sequelize']['QueryTypes'][_0x8e98('0x7b')]});}})[_0x8e98('0x22')](function(){return{'sql':_0x874f7c[_0x8e98('0x79')]()};})['then'](respondWithResult(_0x2270bf,null))[_0x8e98('0x44')](handleError(_0x2270bf,null));};
\ No newline at end of file
+var _0x0578=['name','index','map','type','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','options','findAll','rows','show','params','AnalyticDefaultReport','rawAttributes','include','find','catch','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','UserProfileSection','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','preview','cross_join','SUM(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','operator','rules','group','field','condition','value','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','keyBy','select','from','table','MetricId','metric','function','replace','format','DESC','alias','joins','parse','includes','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','join','left_join','AVG(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','AnalyticMetric','groupBy','orderBy','No\x20available\x20data','web','fullPath','%s-%s.%s','randomstring','AnalyticExtractedReport','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','Run\x20Query:','fork','../../components/export/','output','../../files/reports','savename','countTable','COUNT(*)','run','runReport','right_join','DATE(%s)','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','util','path','to-csv','lodash','squel','jsforce','querystring','papaparse','ioredis','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','status','end','json','count','offset','limit','set','apply','reject','save','update','then','destroy','get','DefaultReports','UserProfileResource','sendStatus','error'];(function(_0x12223b,_0x4aacbc){var _0x330caf=function(_0x1783ff){while(--_0x1783ff){_0x12223b['push'](_0x12223b['shift']());}};_0x330caf(++_0x4aacbc);}(_0x0578,0x1b8));var _0x8057=function(_0x44930f,_0x342804){_0x44930f=_0x44930f-0x0;var _0x364357=_0x0578[_0x44930f];return _0x364357;};'use strict';var pdf=require(_0x8057('0x0'));var emlformat=require(_0x8057('0x1'));var rimraf=require(_0x8057('0x2'));var zipdir=require(_0x8057('0x3'));var jsonpatch=require(_0x8057('0x4'));var rp=require('request-promise');var moment=require(_0x8057('0x5'));var BPromise=require(_0x8057('0x6'));var Mustache=require('mustache');var util=require(_0x8057('0x7'));var path=require(_0x8057('0x8'));var sox=require('sox');var csv=require(_0x8057('0x9'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x8057('0xa'));var squel=require(_0x8057('0xb'));var crypto=require('crypto');var jsforce=require(_0x8057('0xc'));var deskjs=require('desk.js');var toCsv=require(_0x8057('0x9'));var querystring=require(_0x8057('0xd'));var Papa=require(_0x8057('0xe'));var Redis=require(_0x8057('0xf'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x8057('0x10'));var logger=require(_0x8057('0x11'))(_0x8057('0x12'));var utils=require(_0x8057('0x13'));var config=require(_0x8057('0x14'));var db=require(_0x8057('0x15'))['db'];function respondWithStatusCode(_0x53dfbc,_0x47337f){_0x47337f=_0x47337f||0xcc;return function(_0x27635d){if(_0x27635d){return _0x53dfbc['sendStatus'](_0x47337f);}return _0x53dfbc[_0x8057('0x16')](_0x47337f)[_0x8057('0x17')]();};}function respondWithResult(_0x4d961a,_0x1915c6){_0x1915c6=_0x1915c6||0xc8;return function(_0x826189){if(_0x826189){return _0x4d961a['status'](_0x1915c6)[_0x8057('0x18')](_0x826189);}};}function respondWithFilteredResult(_0x37f26d,_0x70a8a7){return function(_0x582fd5){if(_0x582fd5){var _0x3b9dbf=_0x582fd5[_0x8057('0x19')],_0x44a708=_0x70a8a7[_0x8057('0x1a')],_0x372433=_0x70a8a7[_0x8057('0x1a')]+_0x70a8a7[_0x8057('0x1b')],_0x15e05f;if(_0x372433>=_0x3b9dbf){_0x372433=_0x3b9dbf;_0x15e05f=0xc8;}else{_0x15e05f=0xce;}_0x37f26d[_0x8057('0x16')](_0x15e05f);return _0x37f26d[_0x8057('0x1c')]('Content-Range',_0x44a708+'-'+_0x372433+'/'+_0x3b9dbf)[_0x8057('0x18')](_0x582fd5);}return null;};}function patchUpdates(_0xcae021){return function(_0xabe28a){try{jsonpatch[_0x8057('0x1d')](_0xabe28a,_0xcae021,!![]);}catch(_0x5c3a96){return BPromise[_0x8057('0x1e')](_0x5c3a96);}return _0xabe28a[_0x8057('0x1f')]();};}function saveUpdates(_0xb59edf,_0x3e2230){return function(_0x3f3d36){if(_0x3f3d36){return _0x3f3d36[_0x8057('0x20')](_0xb59edf)[_0x8057('0x21')](function(_0x88dd51){return _0x88dd51;});}return null;};}function removeEntity(_0xf34935,_0x6e8b75){return function(_0x3d6d9d){if(_0x3d6d9d){return _0x3d6d9d[_0x8057('0x22')]()['then'](function(){var _0x2df71f=_0x3d6d9d[_0x8057('0x23')]({'plain':!![]});var _0x597341=_0x8057('0x24');return db[_0x8057('0x25')]['destroy']({'where':{'type':_0x597341,'resourceId':_0x2df71f['id']}})[_0x8057('0x21')](function(){return _0x3d6d9d;});})[_0x8057('0x21')](function(){_0xf34935['status'](0xcc)[_0x8057('0x17')]();});}};}function handleEntityNotFound(_0xb5462,_0x4ed0a0){return function(_0x383a6b){if(!_0x383a6b){_0xb5462[_0x8057('0x26')](0x194);}return _0x383a6b;};}function handleError(_0x5e5f74,_0x29699b){_0x29699b=_0x29699b||0x1f4;return function(_0x376623){logger[_0x8057('0x27')](_0x376623['stack']);if(_0x376623[_0x8057('0x28')]){delete _0x376623[_0x8057('0x28')];}_0x5e5f74[_0x8057('0x16')](_0x29699b)['send'](_0x376623);};}exports[_0x8057('0x29')]=function(_0x34e319,_0x255a8c){var _0x4c1c14={},_0x640284={},_0x497bd7={'count':0x0,'rows':[]};var _0x5d1def=_[_0x8057('0x2a')](db['AnalyticDefaultReport']['rawAttributes'],function(_0x242d87){return{'name':_0x242d87['fieldName'],'type':_0x242d87[_0x8057('0x2b')]['key']};});_0x640284[_0x8057('0x2c')]=_['map'](_0x5d1def,_0x8057('0x28'));_0x640284[_0x8057('0x2d')]=_[_0x8057('0x2e')](_0x34e319[_0x8057('0x2d')]);_0x640284[_0x8057('0x2f')]=_[_0x8057('0x30')](_0x640284['model'],_0x640284[_0x8057('0x2d')]);_0x4c1c14[_0x8057('0x31')]=_[_0x8057('0x30')](_0x640284['model'],qs[_0x8057('0x32')](_0x34e319[_0x8057('0x2d')][_0x8057('0x32')]));_0x4c1c14['attributes']=_0x4c1c14[_0x8057('0x31')][_0x8057('0x33')]?_0x4c1c14['attributes']:_0x640284['model'];if(!_0x34e319[_0x8057('0x2d')][_0x8057('0x34')](_0x8057('0x35'))){_0x4c1c14[_0x8057('0x1b')]=qs[_0x8057('0x1b')](_0x34e319[_0x8057('0x2d')][_0x8057('0x1b')]);_0x4c1c14[_0x8057('0x1a')]=qs[_0x8057('0x1a')](_0x34e319[_0x8057('0x2d')][_0x8057('0x1a')]);}_0x4c1c14[_0x8057('0x36')]=qs['sort'](_0x34e319[_0x8057('0x2d')][_0x8057('0x37')]);_0x4c1c14[_0x8057('0x38')]=qs[_0x8057('0x2f')](_[_0x8057('0x39')](_0x34e319[_0x8057('0x2d')],_0x640284[_0x8057('0x2f')]));if(_0x34e319[_0x8057('0x2d')][_0x8057('0x3a')]){_0x4c1c14[_0x8057('0x38')]=_[_0x8057('0x3b')](_0x4c1c14['where'],{'$or':_[_0x8057('0x2a')](_0x5d1def,function(_0xdb4afb){if(_0xdb4afb['type']!==_0x8057('0x3c')){var _0x61a5bd={};_0x61a5bd[_0xdb4afb[_0x8057('0x28')]]={'$like':'%'+_0x34e319[_0x8057('0x2d')][_0x8057('0x3a')]+'%'};return _0x61a5bd;}})});}_0x4c1c14=_['merge']({},_0x4c1c14,_0x34e319[_0x8057('0x3d')]);var _0x5429b6={'where':_0x4c1c14['where']};return db['AnalyticDefaultReport']['count'](_0x5429b6)[_0x8057('0x21')](function(_0x1ca53b){_0x497bd7[_0x8057('0x19')]=_0x1ca53b;if(_0x34e319[_0x8057('0x2d')]['includeAll']){_0x4c1c14['include']=[{'all':!![]}];}return db['AnalyticDefaultReport'][_0x8057('0x3e')](_0x4c1c14);})[_0x8057('0x21')](function(_0x2a6fa8){_0x497bd7[_0x8057('0x3f')]=_0x2a6fa8;return _0x497bd7;})[_0x8057('0x21')](respondWithFilteredResult(_0x255a8c,_0x4c1c14))['catch'](handleError(_0x255a8c,null));};exports[_0x8057('0x40')]=function(_0x22ae42,_0x485277){var _0x58c157={'raw':!![],'where':{'id':_0x22ae42[_0x8057('0x41')]['id']}},_0x216650={};_0x216650[_0x8057('0x2c')]=_[_0x8057('0x2e')](db[_0x8057('0x42')][_0x8057('0x43')]);_0x216650[_0x8057('0x2d')]=_[_0x8057('0x2e')](_0x22ae42[_0x8057('0x2d')]);_0x216650[_0x8057('0x2f')]=_[_0x8057('0x30')](_0x216650[_0x8057('0x2c')],_0x216650[_0x8057('0x2d')]);_0x58c157['attributes']=_[_0x8057('0x30')](_0x216650[_0x8057('0x2c')],qs[_0x8057('0x32')](_0x22ae42[_0x8057('0x2d')]['fields']));_0x58c157['attributes']=_0x58c157['attributes'][_0x8057('0x33')]?_0x58c157['attributes']:_0x216650[_0x8057('0x2c')];if(_0x22ae42['query']['includeAll']){_0x58c157[_0x8057('0x44')]=[{'all':!![]}];}_0x58c157=_[_0x8057('0x3b')]({},_0x58c157,_0x22ae42['options']);return db['AnalyticDefaultReport'][_0x8057('0x45')](_0x58c157)['then'](handleEntityNotFound(_0x485277,null))['then'](respondWithResult(_0x485277,null))[_0x8057('0x46')](handleError(_0x485277,null));};exports[_0x8057('0x47')]=function(_0x4daad4,_0x98d88){return db[_0x8057('0x42')][_0x8057('0x47')](_0x4daad4[_0x8057('0x48')],{})[_0x8057('0x21')](function(_0x35bf3b){var _0x15ea8c=_0x4daad4[_0x8057('0x49')][_0x8057('0x23')]({'plain':!![]});if(!_0x15ea8c)throw new Error(_0x8057('0x4a'));if(_0x15ea8c[_0x8057('0x4b')]===_0x8057('0x49')){var _0x44eea9=_0x35bf3b[_0x8057('0x23')]({'plain':!![]});var _0x1f0228=_0x8057('0x4c');return db[_0x8057('0x4d')][_0x8057('0x45')]({'where':{'name':_0x1f0228,'userProfileId':_0x15ea8c['userProfileId']},'raw':!![]})[_0x8057('0x21')](function(_0x3c5cda){if(_0x3c5cda&&_0x3c5cda['autoAssociation']===0x0){return db[_0x8057('0x25')][_0x8057('0x47')]({'name':_0x44eea9[_0x8057('0x28')],'resourceId':_0x44eea9['id'],'type':_0x8057('0x24'),'sectionId':_0x3c5cda['id']},{})['then'](function(){return _0x35bf3b;});}else{return _0x35bf3b;}})[_0x8057('0x46')](function(_0x44662b){logger['error'](_0x8057('0x4e'),_0x44662b);throw _0x44662b;});}return _0x35bf3b;})['then'](respondWithResult(_0x98d88,0xc9))['catch'](handleError(_0x98d88,null));};exports[_0x8057('0x20')]=function(_0x4af2c7,_0x3b87fd){if(_0x4af2c7['body']['id']){delete _0x4af2c7['body']['id'];}return db[_0x8057('0x42')]['find']({'where':{'id':_0x4af2c7[_0x8057('0x41')]['id']}})[_0x8057('0x21')](handleEntityNotFound(_0x3b87fd,null))[_0x8057('0x21')](saveUpdates(_0x4af2c7[_0x8057('0x48')],null))[_0x8057('0x21')](respondWithResult(_0x3b87fd,null))[_0x8057('0x46')](handleError(_0x3b87fd,null));};exports[_0x8057('0x22')]=function(_0x3d2d9f,_0x591241){return db[_0x8057('0x42')][_0x8057('0x45')]({'where':{'id':_0x3d2d9f['params']['id']}})[_0x8057('0x21')](handleEntityNotFound(_0x591241,null))[_0x8057('0x21')](removeEntity(_0x591241,null))[_0x8057('0x46')](handleError(_0x591241,null));};exports[_0x8057('0x4f')]=function(_0x14539a,_0x25d123){var _0x4940ae=0xa;var _0x27ba23=['join','left_join','right_join',_0x8057('0x50')];var _0x2428db={'SUM':_0x8057('0x51'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x8057('0x52'),'MAX':_0x8057('0x53'),'MIN':_0x8057('0x54'),'AVG':'AVG(%s)','GROUP_CONCAT':_0x8057('0x55'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0x8057('0x56')};var _0x8f0979={'SEC_TO_TIME':_0x8057('0x57'),'DATE':'DATE(%s)','HOUR':_0x8057('0x58'),'ROUND':_0x8057('0x59'),'UNIX_TIMESTAMP':_0x8057('0x5a')};var _0x3ca821=function(_0xd806bf){return!_['includes']([_0x8057('0x5b'),_0x8057('0x5c'),_0x8057('0x5d'),_0x8057('0x5e')],_0xd806bf);};var _0x2aad78=function(_0x145d97){if(!_0x145d97||!_0x145d97['rules']['length']){return'';}for(var _0x2b51d4='(',_0x36ece9=0x0;_0x36ece9<_0x145d97['rules'][_0x8057('0x33')];_0x36ece9+=0x1){_0x36ece9>0x0&&(_0x2b51d4+='\x20'+_0x145d97[_0x8057('0x5f')]+'\x20');_0x2b51d4+=_0x145d97[_0x8057('0x60')][_0x36ece9][_0x8057('0x61')]?_0x2aad78(_0x145d97[_0x8057('0x60')][_0x36ece9][_0x8057('0x61')]):_0x145d97[_0x8057('0x60')][_0x36ece9][_0x8057('0x62')]+'\x20'+_0x145d97[_0x8057('0x60')][_0x36ece9][_0x8057('0x63')]+(_0x3ca821(_0x145d97[_0x8057('0x60')][_0x36ece9][_0x8057('0x63')])?'\x20'+_0x145d97[_0x8057('0x60')][_0x36ece9][_0x8057('0x64')]:'');}return _0x2b51d4+')';};var _0x3232e0={'where':{'id':_0x14539a[_0x8057('0x41')]['id']}},_0x2453fc,_0x1f1036,_0x55fab0,_0x4e505e,_0x509f80;_0x3232e0=_[_0x8057('0x3b')]({},_0x3232e0,_0x14539a[_0x8057('0x3d')]);return db['AnalyticDefaultReport'][_0x8057('0x45')](_0x3232e0)['then'](function(_0x39c65a){if(_0x39c65a){_0x2453fc=_0x39c65a;return _0x39c65a[_0x8057('0x65')]();}return null;})['then'](function(_0x554e76){if(_0x554e76){if(!_0x554e76['length']){throw new db[(_0x8057('0x66'))][(_0x8057('0x67'))](_0x8057('0x68'),0x193);}_0x1f1036=_0x554e76;return db['AnalyticMetric'][_0x8057('0x3e')]({'raw':!![]});}return null;})[_0x8057('0x21')](function(_0x362c8b){if(_0x362c8b){_0x55fab0=_[_0x8057('0x69')](_0x362c8b,'id');var _0x16fd4d;var _0x48af23=squel[_0x8057('0x6a')]();_0x48af23[_0x8057('0x6b')](_0x2453fc[_0x8057('0x6c')]);for(var _0x4426b7=0x0;_0x4426b7<_0x1f1036[_0x8057('0x33')];_0x4426b7+=0x1){_0x16fd4d=_0x1f1036[_0x4426b7][_0x8057('0x6d')]?_0x55fab0[_0x1f1036[_0x4426b7][_0x8057('0x6d')]][_0x8057('0x6e')]:_0x1f1036[_0x4426b7][_0x8057('0x62')];_0x16fd4d=_0x1f1036[_0x4426b7][_0x8057('0x6f')]?_[_0x8057('0x70')](_0x2428db[_0x1f1036[_0x4426b7][_0x8057('0x6f')]],'%s',_0x16fd4d):_0x16fd4d;_0x16fd4d=_0x1f1036[_0x4426b7]['format']?_[_0x8057('0x70')](_0x8f0979[_0x1f1036[_0x4426b7][_0x8057('0x71')]],'%s',_0x16fd4d):_0x16fd4d;if(_0x1f1036[_0x4426b7]['groupBy']){_0x48af23[_0x8057('0x61')](_0x16fd4d);}_0x1f1036[_0x4426b7]['orderBy']&&_0x48af23[_0x8057('0x36')](_0x16fd4d,_0x1f1036[_0x4426b7]['orderBy']===_0x8057('0x72')?![]:!![]);_0x48af23[_0x8057('0x62')](_0x16fd4d,_0x1f1036[_0x4426b7][_0x8057('0x73')]||_0x16fd4d);}if(_0x2453fc[_0x8057('0x74')]){_0x2453fc['joins']=JSON[_0x8057('0x75')](_0x2453fc[_0x8057('0x74')]);for(var _0x4af5bc=0x0;_0x4af5bc<_0x2453fc[_0x8057('0x74')][_0x8057('0x33')];_0x4af5bc+=0x1){if(_0x2453fc[_0x8057('0x74')][_0x4af5bc][_0x8057('0x2b')]&&_[_0x8057('0x76')](_0x27ba23,_0x2453fc[_0x8057('0x74')][_0x4af5bc][_0x8057('0x2b')])&&_0x2453fc[_0x8057('0x74')][_0x4af5bc][_0x8057('0x77')]&&_0x2453fc['joins'][_0x4af5bc][_0x8057('0x78')]&&_0x2453fc[_0x8057('0x74')][_0x4af5bc][_0x8057('0x79')]){_0x48af23[_0x2453fc[_0x8057('0x74')][_0x4af5bc][_0x8057('0x2b')]](_0x2453fc[_0x8057('0x74')][_0x4af5bc][_0x8057('0x78')],null,util[_0x8057('0x71')](_0x8057('0x7a'),_0x2453fc[_0x8057('0x6c')],_0x2453fc[_0x8057('0x74')][_0x4af5bc]['parentKey'],_0x2453fc[_0x8057('0x74')][_0x4af5bc][_0x8057('0x78')],_0x2453fc['joins'][_0x4af5bc]['foreignKey']));}}}if(_0x2453fc['conditions']){_0x2453fc['conditions']=JSON[_0x8057('0x75')](_0x2453fc[_0x8057('0x7b')]);_0x48af23[_0x8057('0x38')](_0x2aad78(_0x2453fc[_0x8057('0x7b')][_0x8057('0x61')]));}_0x509f80=_0x48af23[_0x8057('0x7c')]();_0x48af23[_0x8057('0x1b')](_0x4940ae);_0x48af23[_0x8057('0x1a')](0x0);logger[_0x8057('0x7d')](_0x8057('0x7e'),_0x48af23[_0x8057('0x7f')]());return db[_0x8057('0x80')][_0x8057('0x2d')](_0x48af23[_0x8057('0x7f')](),{'type':db[_0x8057('0x80')][_0x8057('0x81')][_0x8057('0x82')]});}})['then'](respondWithResult(_0x25d123,null))[_0x8057('0x46')](handleError(_0x25d123,null));};function runReport(_0x225f49,_0x555f5d,_0x3a7a2c){var _0x30771a=_0x555f5d[_0x8057('0x28')];var _0x5f424c=0xa;var _0x5c5fc7=[_0x8057('0x83'),_0x8057('0x84'),'right_join',_0x8057('0x50')];var _0xe11cbb={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT DISTINCT':_0x8057('0x52'),'MAX':_0x8057('0x53'),'MIN':_0x8057('0x54'),'AVG':_0x8057('0x85'),'GROUP_CONCAT':_0x8057('0x55'),'GROUP_CONCAT ASC':_0x8057('0x86'),'GROUP_CONCAT DESC':_0x8057('0x56')};var _0x320b74={'SEC_TO_TIME':_0x8057('0x57'),'DATE':'DATE(%s)','HOUR':_0x8057('0x58'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x4430bf=function(_0x394d61){return!_[_0x8057('0x76')]([_0x8057('0x5b'),_0x8057('0x5c'),'IS\x20EMPTY','IS\x20NOT\x20EMPTY'],_0x394d61);};var _0x1359a9=function(_0x4fd116){if(!_0x4fd116||!_0x4fd116['rules'][_0x8057('0x33')]){return'';}for(var _0x287954='(',_0x28a15b=0x0;_0x28a15b<_0x4fd116[_0x8057('0x60')][_0x8057('0x33')];_0x28a15b+=0x1){_0x28a15b>0x0&&(_0x287954+='\x20'+_0x4fd116[_0x8057('0x5f')]+'\x20');_0x287954+=_0x4fd116[_0x8057('0x60')][_0x28a15b]['group']?_0x1359a9(_0x4fd116[_0x8057('0x60')][_0x28a15b]['group']):_0x4fd116['rules'][_0x28a15b][_0x8057('0x62')]+'\x20'+_0x4fd116[_0x8057('0x60')][_0x28a15b]['condition']+(_0x4430bf(_0x4fd116[_0x8057('0x60')][_0x28a15b][_0x8057('0x63')])?'\x20'+_0x4fd116[_0x8057('0x60')][_0x28a15b][_0x8057('0x64')]:'');}return _0x287954+')';};var _0xc326bb={'where':{'id':_0x225f49['id']}},_0x3495b2,_0x3b0f89,_0x1d3910,_0x5ad810,_0xd9c0e7;_0xc326bb=_[_0x8057('0x3b')]({},_0xc326bb,_0x3a7a2c);return db['AnalyticDefaultReport'][_0x8057('0x45')](_0xc326bb)[_0x8057('0x21')](function(_0x143b1f){if(_0x143b1f){_0x3495b2=_0x143b1f;return _0x143b1f[_0x8057('0x65')]();}return null;})[_0x8057('0x21')](function(_0xa61eaf){if(_0xa61eaf){if(!_0xa61eaf[_0x8057('0x33')]){throw new db[(_0x8057('0x66'))]['ValidationErrorItem'](_0x8057('0x68'),0x193);}_0x3b0f89=_0xa61eaf;return db[_0x8057('0x87')][_0x8057('0x3e')]({'raw':!![]});}return null;})[_0x8057('0x21')](function(_0x901552){if(_0x901552){_0x1d3910=_['keyBy'](_0x901552,'id');var _0xd040b7;var _0x398378=squel[_0x8057('0x6a')]();_0x398378['from'](_0x3495b2[_0x8057('0x6c')]);for(var _0xe2e060=0x0;_0xe2e060<_0x3b0f89[_0x8057('0x33')];_0xe2e060+=0x1){_0xd040b7=_0x3b0f89[_0xe2e060][_0x8057('0x6d')]?_0x1d3910[_0x3b0f89[_0xe2e060]['MetricId']][_0x8057('0x6e')]:_0x3b0f89[_0xe2e060][_0x8057('0x62')];_0xd040b7=_0x3b0f89[_0xe2e060]['function']?_[_0x8057('0x70')](_0xe11cbb[_0x3b0f89[_0xe2e060][_0x8057('0x6f')]],'%s',_0xd040b7):_0xd040b7;_0xd040b7=_0x3b0f89[_0xe2e060][_0x8057('0x71')]?_[_0x8057('0x70')](_0x320b74[_0x3b0f89[_0xe2e060][_0x8057('0x71')]],'%s',_0xd040b7):_0xd040b7;if(_0x3b0f89[_0xe2e060][_0x8057('0x88')]){_0x398378[_0x8057('0x61')](_0xd040b7);}_0x3b0f89[_0xe2e060][_0x8057('0x89')]&&_0x398378[_0x8057('0x36')](_0xd040b7,_0x3b0f89[_0xe2e060]['orderBy']===_0x8057('0x72')?![]:!![]);_0x398378[_0x8057('0x62')](_0xd040b7,_0x3b0f89[_0xe2e060]['alias']||_0xd040b7);}if(_0x3495b2[_0x8057('0x74')]){_0x3495b2[_0x8057('0x74')]=JSON[_0x8057('0x75')](_0x3495b2['joins']);for(var _0x3a4200=0x0;_0x3a4200<_0x3495b2['joins'][_0x8057('0x33')];_0x3a4200+=0x1){if(_0x3495b2[_0x8057('0x74')][_0x3a4200]['type']&&_[_0x8057('0x76')](_0x5c5fc7,_0x3495b2['joins'][_0x3a4200][_0x8057('0x2b')])&&_0x3495b2['joins'][_0x3a4200][_0x8057('0x77')]&&_0x3495b2[_0x8057('0x74')][_0x3a4200][_0x8057('0x78')]&&_0x3495b2[_0x8057('0x74')][_0x3a4200][_0x8057('0x79')]){_0x398378[_0x3495b2[_0x8057('0x74')][_0x3a4200][_0x8057('0x2b')]](_0x3495b2[_0x8057('0x74')][_0x3a4200][_0x8057('0x78')],null,util[_0x8057('0x71')](_0x8057('0x7a'),_0x3495b2[_0x8057('0x6c')],_0x3495b2[_0x8057('0x74')][_0x3a4200][_0x8057('0x77')],_0x3495b2[_0x8057('0x74')][_0x3a4200][_0x8057('0x78')],_0x3495b2['joins'][_0x3a4200]['foreignKey']));}}}if(_0x3495b2['conditions']){_0x3495b2[_0x8057('0x7b')]=JSON[_0x8057('0x75')](_0x3495b2[_0x8057('0x7b')]);_0x398378[_0x8057('0x38')](_0x1359a9(_0x3495b2[_0x8057('0x7b')][_0x8057('0x61')]));}_0xd9c0e7=_0x398378['clone']();_0x398378[_0x8057('0x1b')](_0x5f424c);_0x398378[_0x8057('0x1a')](0x0);logger['debug']('Limited\x20Query:',_0x398378[_0x8057('0x7f')]());return db[_0x8057('0x80')]['query'](_0x398378[_0x8057('0x7f')](),{'type':db[_0x8057('0x80')][_0x8057('0x81')][_0x8057('0x82')]});}})[_0x8057('0x21')](function(_0x5acddb){if(!_0x5acddb[_0x8057('0x33')]){throw new db[(_0x8057('0x66'))][(_0x8057('0x67'))](_0x8057('0x8a'),0xcc);}if(_0x555f5d['output']===_0x8057('0x8b')){return null;}var _0x317562=_[_0x8057('0x3b')](_0x555f5d,{'name':_0x555f5d[_0x8057('0x8c')]||_0x555f5d['name']||_0x3495b2[_0x8057('0x28')],'basename':_0x30771a,'savename':util[_0x8057('0x71')](_0x8057('0x8d'),_0x555f5d['name']||_0x3495b2[_0x8057('0x28')],require(_0x8057('0x8e'))['generate'](0x4),_0x555f5d['output']||'csv'),'reportId':_0x3495b2['id'],'reportType':'default'});return db[_0x8057('0x8f')][_0x8057('0x47')](_0x317562,{'raw':!![]});})[_0x8057('0x21')](function(_0x38d291){if(_0x3495b2[_0x8057('0x6c')]==='cdr'){_0xd9c0e7['where'](_0x3495b2[_0x8057('0x6c')]+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x555f5d[_0x8057('0x90')],_0x555f5d[_0x8057('0x91')]);}else{_0xd9c0e7['where'](_0x3495b2['table']+_0x8057('0x92'),_0x555f5d[_0x8057('0x90')],_0x555f5d['endDate']);}if(_0x38d291){logger[_0x8057('0x93')](_0x8057('0x94'),_0xd9c0e7[_0x8057('0x7f')]());require('child_process')[_0x8057('0x95')](path['join'](__dirname,_0x8057('0x96'),_0x38d291[_0x8057('0x97')]),[_0x38d291['id'],_0xd9c0e7['toString'](),path['join'](__dirname,_0x8057('0x98'),_0x38d291[_0x8057('0x99')]),_0x30771a]);return _0x38d291;}else{var _0x2ecf70=squel['select']();_0x2ecf70['from']('('+_0xd9c0e7[_0x8057('0x7f')]()+')',_0x8057('0x9a'));_0x2ecf70[_0x8057('0x62')](_0x8057('0x9b'),'count');_0xd9c0e7['limit'](_0x555f5d[_0x8057('0x1b')]||_0x5f424c);_0xd9c0e7['offset'](_0x555f5d[_0x8057('0x1a')]||0x0);return db['sequelize'][_0x8057('0x2d')](_0x2ecf70[_0x8057('0x7f')](),{'type':db[_0x8057('0x80')]['QueryTypes'][_0x8057('0x82')]})[_0x8057('0x21')](function(_0x256764){if(!_0x256764[_0x8057('0x33')]){_0x5ad810=0x0;}else{_0x5ad810=_0x256764[0x0][_0x8057('0x19')]||0x0;}return db[_0x8057('0x80')][_0x8057('0x2d')](_0xd9c0e7[_0x8057('0x7f')](),{'type':db['sequelize'][_0x8057('0x81')]['SELECT']});})[_0x8057('0x21')](function(_0x510364){return{'rows':_0x510364||[],'count':_0x5ad810};});}});}exports[_0x8057('0x9c')]=function(_0x445aab,_0xd34082){return runReport(_0x445aab[_0x8057('0x41')],_0x445aab[_0x8057('0x2d')],_0x445aab[_0x8057('0x3d')])[_0x8057('0x21')](respondWithResult(_0xd34082,null))['catch'](handleError(_0xd34082,null));};exports[_0x8057('0x9d')]=runReport;exports[_0x8057('0x2d')]=function(_0x15c20f,_0x3bbb0d){var _0x19b3a6=0xa;var _0x4a6203=['join',_0x8057('0x84'),_0x8057('0x9e'),'cross_join'];var _0x4f0408={'SUM':_0x8057('0x51'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x8057('0x52'),'MAX':_0x8057('0x53'),'MIN':'MIN(%s)','AVG':_0x8057('0x85'),'GROUP_CONCAT':_0x8057('0x55'),'GROUP_CONCAT ASC':_0x8057('0x86'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x7994a0={'SEC_TO_TIME':_0x8057('0x57'),'DATE':_0x8057('0x9f'),'HOUR':_0x8057('0x58'),'ROUND':_0x8057('0x59'),'UNIX_TIMESTAMP':_0x8057('0x5a')};var _0xde063f=function(_0x49db46){return!_[_0x8057('0x76')]([_0x8057('0x5b'),_0x8057('0x5c'),_0x8057('0x5d'),'IS\x20NOT\x20EMPTY'],_0x49db46);};var _0x12f011=function(_0x178bca){if(!_0x178bca||!_0x178bca[_0x8057('0x60')][_0x8057('0x33')]){return'';}for(var _0x2b9f1b='(',_0x3e6693=0x0;_0x3e6693<_0x178bca[_0x8057('0x60')]['length'];_0x3e6693+=0x1){_0x3e6693>0x0&&(_0x2b9f1b+='\x20'+_0x178bca[_0x8057('0x5f')]+'\x20');_0x2b9f1b+=_0x178bca[_0x8057('0x60')][_0x3e6693][_0x8057('0x61')]?_0x12f011(_0x178bca[_0x8057('0x60')][_0x3e6693]['group']):_0x178bca['rules'][_0x3e6693][_0x8057('0x62')]+'\x20'+_0x178bca[_0x8057('0x60')][_0x3e6693][_0x8057('0x63')]+(_0xde063f(_0x178bca[_0x8057('0x60')][_0x3e6693][_0x8057('0x63')])?'\x20'+_0x178bca['rules'][_0x3e6693][_0x8057('0x64')]:'');}return _0x2b9f1b+')';};var _0x13f35f={'where':{'id':_0x15c20f[_0x8057('0x41')]['id']}},_0x2e5aeb,_0x31d178,_0x3c6e4e,_0x27225f,_0x1a6f0e;_0x13f35f=_[_0x8057('0x3b')]({},_0x13f35f,_0x15c20f[_0x8057('0x3d')]);return db['AnalyticDefaultReport'][_0x8057('0x45')](_0x13f35f)[_0x8057('0x21')](function(_0xde1614){if(_0xde1614){_0x2e5aeb=_0xde1614;return _0xde1614[_0x8057('0x65')]();}return null;})['then'](function(_0x5047b8){if(_0x5047b8){if(!_0x5047b8[_0x8057('0x33')]){throw new db['Sequelize'][(_0x8057('0x67'))](_0x8057('0x68'),0x193);}_0x31d178=_0x5047b8;return db[_0x8057('0x87')]['findAll']({'raw':!![]});}return null;})[_0x8057('0x21')](function(_0x11fa07){if(_0x11fa07){_0x3c6e4e=_['keyBy'](_0x11fa07,'id');var _0x1b0807;var _0x9ae579=squel[_0x8057('0x6a')]();_0x9ae579[_0x8057('0x6b')](_0x2e5aeb[_0x8057('0x6c')]);for(var _0x2c6434=0x0;_0x2c6434<_0x31d178[_0x8057('0x33')];_0x2c6434+=0x1){_0x1b0807=_0x31d178[_0x2c6434][_0x8057('0x6d')]?_0x3c6e4e[_0x31d178[_0x2c6434][_0x8057('0x6d')]][_0x8057('0x6e')]:_0x31d178[_0x2c6434][_0x8057('0x62')];_0x1b0807=_0x31d178[_0x2c6434]['function']?_[_0x8057('0x70')](_0x4f0408[_0x31d178[_0x2c6434][_0x8057('0x6f')]],'%s',_0x1b0807):_0x1b0807;_0x1b0807=_0x31d178[_0x2c6434][_0x8057('0x71')]?_['replace'](_0x7994a0[_0x31d178[_0x2c6434][_0x8057('0x71')]],'%s',_0x1b0807):_0x1b0807;if(_0x31d178[_0x2c6434][_0x8057('0x88')]){_0x9ae579[_0x8057('0x61')](_0x1b0807);}_0x31d178[_0x2c6434][_0x8057('0x89')]&&_0x9ae579['order'](_0x1b0807,_0x31d178[_0x2c6434]['orderBy']===_0x8057('0x72')?![]:!![]);_0x9ae579[_0x8057('0x62')](_0x1b0807,_0x31d178[_0x2c6434][_0x8057('0x73')]||_0x1b0807);}if(_0x2e5aeb[_0x8057('0x74')]){_0x2e5aeb[_0x8057('0x74')]=JSON[_0x8057('0x75')](_0x2e5aeb[_0x8057('0x74')]);for(var _0x330b7b=0x0;_0x330b7b<_0x2e5aeb[_0x8057('0x74')][_0x8057('0x33')];_0x330b7b+=0x1){if(_0x2e5aeb[_0x8057('0x74')][_0x330b7b][_0x8057('0x2b')]&&_[_0x8057('0x76')](_0x4a6203,_0x2e5aeb[_0x8057('0x74')][_0x330b7b][_0x8057('0x2b')])&&_0x2e5aeb[_0x8057('0x74')][_0x330b7b][_0x8057('0x77')]&&_0x2e5aeb[_0x8057('0x74')][_0x330b7b][_0x8057('0x78')]&&_0x2e5aeb[_0x8057('0x74')][_0x330b7b][_0x8057('0x79')]){_0x9ae579[_0x2e5aeb['joins'][_0x330b7b][_0x8057('0x2b')]](_0x2e5aeb[_0x8057('0x74')][_0x330b7b][_0x8057('0x78')],null,util[_0x8057('0x71')]('%s.%s\x20=\x20%s.%s',_0x2e5aeb[_0x8057('0x6c')],_0x2e5aeb[_0x8057('0x74')][_0x330b7b][_0x8057('0x77')],_0x2e5aeb['joins'][_0x330b7b]['foreignTable'],_0x2e5aeb[_0x8057('0x74')][_0x330b7b][_0x8057('0x79')]));}}}if(_0x2e5aeb[_0x8057('0x7b')]){_0x2e5aeb[_0x8057('0x7b')]=JSON['parse'](_0x2e5aeb['conditions']);_0x9ae579[_0x8057('0x38')](_0x12f011(_0x2e5aeb[_0x8057('0x7b')][_0x8057('0x61')]));}_0x1a6f0e=_0x9ae579['clone']();_0x9ae579[_0x8057('0x1b')](_0x19b3a6);_0x9ae579[_0x8057('0x1a')](0x0);logger[_0x8057('0x7d')](_0x8057('0x7e'),_0x9ae579[_0x8057('0x7f')]());return db['sequelize'][_0x8057('0x2d')](_0x9ae579[_0x8057('0x7f')](),{'type':db['sequelize'][_0x8057('0x81')][_0x8057('0x82')]});}})[_0x8057('0x21')](function(){return{'sql':_0x1a6f0e[_0x8057('0x7f')]()};})[_0x8057('0x21')](respondWithResult(_0x3bbb0d,null))[_0x8057('0x46')](handleError(_0x3bbb0d,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff