// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x3ef0=['AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','Run\x20Query:','child_process','fork','../../components/export/','savename','COUNT(*)','run','findAll','html-pdf','eml-format','rimraf','fast-json-patch','moment','util','path','sox','ejs','lodash','squel','crypto','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','status','end','json','count','offset','limit','set','Content-Range','reject','save','update','then','get','UserProfileResource','destroy','name','send','index','AnalyticDefaultReport','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filter','merge','map','VIRTUAL','options','includeAll','catch','show','include','find','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','user','UserProfileSection','userProfileId','autoAssociation','DefaultReports','error','params','preview','join','left_join','right_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','SEC_TO_TIME(%s)','DATE(%s)','HOUR(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','value','getFields','Sequelize','ValidationErrorItem','AnalyticMetric','keyBy','select','from','MetricId','metric','function','replace','format','groupBy','orderBy','alias','joins','parse','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','table','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','cross_join','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','ROUND(%s)','Please\x20insert\x20at\x20least\x20one\x20field','DESC','output','fullPath','randomstring','generate'];(function(_0x213d47,_0x218719){var _0x58c3a9=function(_0x449b16){while(--_0x449b16){_0x213d47['push'](_0x213d47['shift']());}};_0x58c3a9(++_0x218719);}(_0x3ef0,0x1ee));var _0x03ef=function(_0x10593e,_0x3c7394){_0x10593e=_0x10593e-0x0;var _0x12d3ea=_0x3ef0[_0x10593e];return _0x12d3ea;};'use strict';var pdf=require(_0x03ef('0x0'));var emlformat=require(_0x03ef('0x1'));var rimraf=require(_0x03ef('0x2'));var zipdir=require('zip-dir');var jsonpatch=require(_0x03ef('0x3'));var rp=require('request-promise');var moment=require(_0x03ef('0x4'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x03ef('0x5'));var path=require(_0x03ef('0x6'));var sox=require(_0x03ef('0x7'));var csv=require('to-csv');var ejs=require(_0x03ef('0x8'));var fs=require('fs');var _=require(_0x03ef('0x9'));var squel=require(_0x03ef('0xa'));var crypto=require(_0x03ef('0xb'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x03ef('0xc'));var querystring=require(_0x03ef('0xd'));var Papa=require(_0x03ef('0xe'));var Redis=require(_0x03ef('0xf'));var authService=require(_0x03ef('0x10'));var qs=require('../../components/parsers/qs');var as=require(_0x03ef('0x11'));var hardwareService=require(_0x03ef('0x12'));var logger=require('../../config/logger')(_0x03ef('0x13'));var utils=require(_0x03ef('0x14'));var config=require('../../config/environment');var licenseUtil=require(_0x03ef('0x15'));var db=require(_0x03ef('0x16'))['db'];var dbH=require(_0x03ef('0x16'))['dbH'];function respondWithStatusCode(_0x407e20,_0x21cd98){_0x21cd98=_0x21cd98||0xcc;return function(_0x4d4097){if(_0x4d4097){return _0x407e20[_0x03ef('0x17')](_0x21cd98);}return _0x407e20[_0x03ef('0x18')](_0x21cd98)[_0x03ef('0x19')]();};}function respondWithResult(_0x505aff,_0x6049e0){_0x6049e0=_0x6049e0||0xc8;return function(_0x470c5c){if(_0x470c5c){return _0x505aff[_0x03ef('0x18')](_0x6049e0)[_0x03ef('0x1a')](_0x470c5c);}};}function respondWithFilteredResult(_0x3f5777,_0x254b65){return function(_0x367d81){if(_0x367d81){var _0x48485f=_0x367d81[_0x03ef('0x1b')],_0xc1bc60=_0x254b65[_0x03ef('0x1c')],_0x995464=_0x254b65[_0x03ef('0x1c')]+_0x254b65[_0x03ef('0x1d')],_0x359b59;if(_0x995464>=_0x48485f){_0x995464=_0x48485f;_0x359b59=0xc8;}else{_0x359b59=0xce;}_0x3f5777[_0x03ef('0x18')](_0x359b59);return _0x3f5777[_0x03ef('0x1e')](_0x03ef('0x1f'),_0xc1bc60+'-'+_0x995464+'/'+_0x48485f)[_0x03ef('0x1a')](_0x367d81);}return null;};}function patchUpdates(_0x19c02f){return function(_0x45a709){try{jsonpatch['apply'](_0x45a709,_0x19c02f,!![]);}catch(_0x3ffcd4){return BPromise[_0x03ef('0x20')](_0x3ffcd4);}return _0x45a709[_0x03ef('0x21')]();};}function saveUpdates(_0x4c7b07,_0xd933d5){return function(_0x903d8){if(_0x903d8){return _0x903d8[_0x03ef('0x22')](_0x4c7b07)[_0x03ef('0x23')](function(_0x5d070c){return _0x5d070c;});}return null;};}function removeEntity(_0x3babe9,_0x5e1338){return function(_0x22aaf8){if(_0x22aaf8){return _0x22aaf8['destroy']()[_0x03ef('0x23')](function(){var _0x25abb7=_0x22aaf8[_0x03ef('0x24')]({'plain':!![]});var _0x3a5561='DefaultReports';return db[_0x03ef('0x25')][_0x03ef('0x26')]({'where':{'type':_0x3a5561,'resourceId':_0x25abb7['id']}})['then'](function(){return _0x22aaf8;});})[_0x03ef('0x23')](function(){_0x3babe9['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x3d460c,_0x495e0d){return function(_0x472a9f){if(!_0x472a9f){_0x3d460c[_0x03ef('0x17')](0x194);}return _0x472a9f;};}function handleError(_0x2c3540,_0x4cd475){_0x4cd475=_0x4cd475||0x1f4;return function(_0xb8235e){logger['error'](_0xb8235e['stack']);if(_0xb8235e[_0x03ef('0x27')]){delete _0xb8235e['name'];}_0x2c3540[_0x03ef('0x18')](_0x4cd475)[_0x03ef('0x28')](_0xb8235e);};}exports[_0x03ef('0x29')]=function(_0x57845e,_0x1c00b3){var _0x1b0dae={},_0x329303={},_0x3865b1={'count':0x0,'rows':[]};var _0x544797=_['map'](db[_0x03ef('0x2a')][_0x03ef('0x2b')],function(_0x1d71e2){return{'name':_0x1d71e2[_0x03ef('0x2c')],'type':_0x1d71e2[_0x03ef('0x2d')][_0x03ef('0x2e')]};});_0x329303[_0x03ef('0x2f')]=_['map'](_0x544797,_0x03ef('0x27'));_0x329303[_0x03ef('0x30')]=_[_0x03ef('0x31')](_0x57845e['query']);_0x329303[_0x03ef('0x32')]=_[_0x03ef('0x33')](_0x329303['model'],_0x329303[_0x03ef('0x30')]);_0x1b0dae[_0x03ef('0x34')]=_[_0x03ef('0x33')](_0x329303['model'],qs['fields'](_0x57845e['query'][_0x03ef('0x35')]));_0x1b0dae['attributes']=_0x1b0dae[_0x03ef('0x34')][_0x03ef('0x36')]?_0x1b0dae[_0x03ef('0x34')]:_0x329303[_0x03ef('0x2f')];if(!_0x57845e[_0x03ef('0x30')][_0x03ef('0x37')](_0x03ef('0x38'))){_0x1b0dae[_0x03ef('0x1d')]=qs[_0x03ef('0x1d')](_0x57845e['query'][_0x03ef('0x1d')]);_0x1b0dae[_0x03ef('0x1c')]=qs[_0x03ef('0x1c')](_0x57845e[_0x03ef('0x30')][_0x03ef('0x1c')]);}_0x1b0dae[_0x03ef('0x39')]=qs[_0x03ef('0x3a')](_0x57845e[_0x03ef('0x30')][_0x03ef('0x3a')]);_0x1b0dae[_0x03ef('0x3b')]=qs['filters'](_['pick'](_0x57845e[_0x03ef('0x30')],_0x329303[_0x03ef('0x32')]),_0x544797);if(_0x57845e[_0x03ef('0x30')][_0x03ef('0x3c')]){_0x1b0dae[_0x03ef('0x3b')]=_[_0x03ef('0x3d')](_0x1b0dae[_0x03ef('0x3b')],{'$or':_[_0x03ef('0x3e')](_0x544797,function(_0x1ec6e3){if(_0x1ec6e3[_0x03ef('0x2d')]!==_0x03ef('0x3f')){var _0x374c52={};_0x374c52[_0x1ec6e3[_0x03ef('0x27')]]={'$like':'%'+_0x57845e['query'][_0x03ef('0x3c')]+'%'};return _0x374c52;}})});}_0x1b0dae=_[_0x03ef('0x3d')]({},_0x1b0dae,_0x57845e[_0x03ef('0x40')]);var _0x4ac063={'where':_0x1b0dae['where']};return db[_0x03ef('0x2a')]['count'](_0x4ac063)[_0x03ef('0x23')](function(_0x4f1e27){_0x3865b1[_0x03ef('0x1b')]=_0x4f1e27;if(_0x57845e[_0x03ef('0x30')][_0x03ef('0x41')]){_0x1b0dae['include']=[{'all':!![]}];}return db[_0x03ef('0x2a')]['findAll'](_0x1b0dae);})[_0x03ef('0x23')](function(_0x2a184c){_0x3865b1['rows']=_0x2a184c;return _0x3865b1;})['then'](respondWithFilteredResult(_0x1c00b3,_0x1b0dae))[_0x03ef('0x42')](handleError(_0x1c00b3,null));};exports[_0x03ef('0x43')]=function(_0x32a15b,_0x5ef013){var _0x4d8caf={'raw':!![],'where':{'id':_0x32a15b['params']['id']}},_0x38b7b3={};_0x38b7b3[_0x03ef('0x2f')]=_['keys'](db[_0x03ef('0x2a')][_0x03ef('0x2b')]);_0x38b7b3[_0x03ef('0x30')]=_[_0x03ef('0x31')](_0x32a15b[_0x03ef('0x30')]);_0x38b7b3['filters']=_[_0x03ef('0x33')](_0x38b7b3[_0x03ef('0x2f')],_0x38b7b3[_0x03ef('0x30')]);_0x4d8caf[_0x03ef('0x34')]=_[_0x03ef('0x33')](_0x38b7b3['model'],qs[_0x03ef('0x35')](_0x32a15b[_0x03ef('0x30')][_0x03ef('0x35')]));_0x4d8caf[_0x03ef('0x34')]=_0x4d8caf[_0x03ef('0x34')][_0x03ef('0x36')]?_0x4d8caf['attributes']:_0x38b7b3[_0x03ef('0x2f')];if(_0x32a15b[_0x03ef('0x30')][_0x03ef('0x41')]){_0x4d8caf[_0x03ef('0x44')]=[{'all':!![]}];}_0x4d8caf=_[_0x03ef('0x3d')]({},_0x4d8caf,_0x32a15b[_0x03ef('0x40')]);return db[_0x03ef('0x2a')][_0x03ef('0x45')](_0x4d8caf)[_0x03ef('0x23')](handleEntityNotFound(_0x5ef013,null))[_0x03ef('0x23')](respondWithResult(_0x5ef013,null))[_0x03ef('0x42')](handleError(_0x5ef013,null));};exports[_0x03ef('0x46')]=function(_0x3cb35d,_0x587312){return db['AnalyticDefaultReport'][_0x03ef('0x46')](_0x3cb35d[_0x03ef('0x47')],{})[_0x03ef('0x23')](function(_0x381196){var _0x41d961=_0x3cb35d['user'][_0x03ef('0x24')]({'plain':!![]});if(!_0x41d961)throw new Error(_0x03ef('0x48'));if(_0x41d961['role']===_0x03ef('0x49')){var _0x570fe9=_0x381196[_0x03ef('0x24')]({'plain':!![]});var _0x4782d7='Reports';return db[_0x03ef('0x4a')][_0x03ef('0x45')]({'where':{'name':_0x4782d7,'userProfileId':_0x41d961[_0x03ef('0x4b')]},'raw':!![]})[_0x03ef('0x23')](function(_0x26efb6){if(_0x26efb6&&_0x26efb6[_0x03ef('0x4c')]===0x0){return db[_0x03ef('0x25')][_0x03ef('0x46')]({'name':_0x570fe9[_0x03ef('0x27')],'resourceId':_0x570fe9['id'],'type':_0x03ef('0x4d'),'sectionId':_0x26efb6['id']},{})[_0x03ef('0x23')](function(){return _0x381196;});}else{return _0x381196;}})[_0x03ef('0x42')](function(_0x4a64bf){logger[_0x03ef('0x4e')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x4a64bf);throw _0x4a64bf;});}return _0x381196;})['then'](respondWithResult(_0x587312,0xc9))['catch'](handleError(_0x587312,null));};exports['update']=function(_0x204a3a,_0x122105){if(_0x204a3a[_0x03ef('0x47')]['id']){delete _0x204a3a['body']['id'];}return db[_0x03ef('0x2a')]['find']({'where':{'id':_0x204a3a[_0x03ef('0x4f')]['id']}})['then'](handleEntityNotFound(_0x122105,null))[_0x03ef('0x23')](saveUpdates(_0x204a3a['body'],null))[_0x03ef('0x23')](respondWithResult(_0x122105,null))[_0x03ef('0x42')](handleError(_0x122105,null));};exports[_0x03ef('0x26')]=function(_0x8ba982,_0x2d13d0){return db['AnalyticDefaultReport']['find']({'where':{'id':_0x8ba982[_0x03ef('0x4f')]['id']}})[_0x03ef('0x23')](handleEntityNotFound(_0x2d13d0,null))[_0x03ef('0x23')](removeEntity(_0x2d13d0,null))[_0x03ef('0x42')](handleError(_0x2d13d0,null));};exports[_0x03ef('0x50')]=function(_0x51de8f,_0x75beb){var _0x3958ed=0xa;var _0x24bf69=[_0x03ef('0x51'),_0x03ef('0x52'),_0x03ef('0x53'),'cross_join'];var _0x319d44={'SUM':_0x03ef('0x54'),'COUNT':_0x03ef('0x55'),'COUNT DISTINCT':_0x03ef('0x56'),'MAX':_0x03ef('0x57'),'MIN':'MIN(%s)','AVG':'AVG(%s)','GROUP_CONCAT':_0x03ef('0x58'),'GROUP_CONCAT ASC':_0x03ef('0x59'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x423d89={'SEC_TO_TIME':_0x03ef('0x5a'),'DATE':_0x03ef('0x5b'),'HOUR':_0x03ef('0x5c'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x03ef('0x5d')};var _0x2702a1=function(_0x10c8f9){return!_[_0x03ef('0x5e')]([_0x03ef('0x5f'),_0x03ef('0x60'),_0x03ef('0x61'),_0x03ef('0x62')],_0x10c8f9);};var _0x159b86=function(_0x20a9f1){if(!_0x20a9f1||!_0x20a9f1[_0x03ef('0x63')][_0x03ef('0x36')]){return'';}for(var _0x2b58a9='(',_0x351654=0x0;_0x351654<_0x20a9f1['rules'][_0x03ef('0x36')];_0x351654+=0x1){_0x351654>0x0&&(_0x2b58a9+='\x20'+_0x20a9f1[_0x03ef('0x64')]+'\x20');_0x2b58a9+=_0x20a9f1[_0x03ef('0x63')][_0x351654][_0x03ef('0x65')]?_0x159b86(_0x20a9f1['rules'][_0x351654][_0x03ef('0x65')]):_0x20a9f1[_0x03ef('0x63')][_0x351654][_0x03ef('0x66')]+'\x20'+_0x20a9f1[_0x03ef('0x63')][_0x351654][_0x03ef('0x67')]+(_0x2702a1(_0x20a9f1[_0x03ef('0x63')][_0x351654]['condition'])?'\x20'+_0x20a9f1['rules'][_0x351654][_0x03ef('0x68')]:'');}return _0x2b58a9+')';};var _0x47e004={'where':{'id':_0x51de8f[_0x03ef('0x4f')]['id']}},_0x4d59a8,_0x1c3904,_0x209313,_0x3bc978,_0xcfc58a;_0x47e004=_[_0x03ef('0x3d')]({},_0x47e004,_0x51de8f[_0x03ef('0x40')]);return db['AnalyticDefaultReport']['find'](_0x47e004)[_0x03ef('0x23')](function(_0x1410e5){if(_0x1410e5){_0x4d59a8=_0x1410e5;return _0x1410e5[_0x03ef('0x69')]();}return null;})['then'](function(_0x1ebdc5){if(_0x1ebdc5){if(!_0x1ebdc5[_0x03ef('0x36')]){throw new db[(_0x03ef('0x6a'))][(_0x03ef('0x6b'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x1c3904=_0x1ebdc5;return db[_0x03ef('0x6c')]['findAll']({'raw':!![]});}return null;})['then'](function(_0x957161){if(_0x957161){_0x209313=_[_0x03ef('0x6d')](_0x957161,'id');var _0x291b83;var _0x43b596=squel[_0x03ef('0x6e')]();_0x43b596[_0x03ef('0x6f')](_0x4d59a8['table']);for(var _0x4c67f1=0x0;_0x4c67f1<_0x1c3904[_0x03ef('0x36')];_0x4c67f1+=0x1){_0x291b83=_0x1c3904[_0x4c67f1][_0x03ef('0x70')]?_0x209313[_0x1c3904[_0x4c67f1][_0x03ef('0x70')]][_0x03ef('0x71')]:_0x1c3904[_0x4c67f1][_0x03ef('0x66')];_0x291b83=_0x1c3904[_0x4c67f1][_0x03ef('0x72')]?_[_0x03ef('0x73')](_0x319d44[_0x1c3904[_0x4c67f1][_0x03ef('0x72')]],'%s',_0x291b83):_0x291b83;_0x291b83=_0x1c3904[_0x4c67f1]['format']?_[_0x03ef('0x73')](_0x423d89[_0x1c3904[_0x4c67f1][_0x03ef('0x74')]],'%s',_0x291b83):_0x291b83;if(_0x1c3904[_0x4c67f1][_0x03ef('0x75')]){_0x43b596['group'](_0x291b83);}_0x1c3904[_0x4c67f1][_0x03ef('0x76')]&&_0x43b596['order'](_0x291b83,_0x1c3904[_0x4c67f1][_0x03ef('0x76')]==='DESC'?![]:!![]);_0x43b596[_0x03ef('0x66')](_0x291b83,_0x1c3904[_0x4c67f1][_0x03ef('0x77')]||_0x291b83);}if(_0x4d59a8[_0x03ef('0x78')]){_0x4d59a8[_0x03ef('0x78')]=JSON[_0x03ef('0x79')](_0x4d59a8['joins']);for(var _0x3b4e2c=0x0;_0x3b4e2c<_0x4d59a8[_0x03ef('0x78')][_0x03ef('0x36')];_0x3b4e2c+=0x1){if(_0x4d59a8['joins'][_0x3b4e2c]['type']&&_[_0x03ef('0x5e')](_0x24bf69,_0x4d59a8['joins'][_0x3b4e2c][_0x03ef('0x2d')])&&_0x4d59a8[_0x03ef('0x78')][_0x3b4e2c][_0x03ef('0x7a')]&&_0x4d59a8[_0x03ef('0x78')][_0x3b4e2c][_0x03ef('0x7b')]&&_0x4d59a8['joins'][_0x3b4e2c][_0x03ef('0x7c')]){_0x43b596[_0x4d59a8[_0x03ef('0x78')][_0x3b4e2c][_0x03ef('0x2d')]](_0x4d59a8[_0x03ef('0x78')][_0x3b4e2c][_0x03ef('0x7b')],null,util[_0x03ef('0x74')](_0x03ef('0x7d'),_0x4d59a8[_0x03ef('0x7e')],_0x4d59a8[_0x03ef('0x78')][_0x3b4e2c][_0x03ef('0x7a')],_0x4d59a8[_0x03ef('0x78')][_0x3b4e2c][_0x03ef('0x7b')],_0x4d59a8[_0x03ef('0x78')][_0x3b4e2c][_0x03ef('0x7c')]));}}}if(_0x4d59a8[_0x03ef('0x7f')]){_0x4d59a8[_0x03ef('0x7f')]=JSON[_0x03ef('0x79')](_0x4d59a8['conditions']);_0x43b596[_0x03ef('0x3b')](_0x159b86(_0x4d59a8[_0x03ef('0x7f')][_0x03ef('0x65')]));}_0xcfc58a=_0x43b596[_0x03ef('0x80')]();_0x43b596[_0x03ef('0x1d')](_0x3958ed);_0x43b596['offset'](0x0);logger[_0x03ef('0x81')](_0x03ef('0x82'),_0x43b596[_0x03ef('0x83')]());return dbH['sequelize'][_0x03ef('0x30')](_0x43b596[_0x03ef('0x83')](),{'type':dbH[_0x03ef('0x84')][_0x03ef('0x85')][_0x03ef('0x86')]});}})['then'](respondWithResult(_0x75beb,null))[_0x03ef('0x42')](handleError(_0x75beb,null));};function runReport(_0x15142f,_0x15c000,_0x18a6c3){var _0x1ed0bd=_0x15c000[_0x03ef('0x27')];var _0x559755=0xa;var _0x55ea0f=[_0x03ef('0x51'),_0x03ef('0x52'),_0x03ef('0x53'),_0x03ef('0x87')];var _0x500a82={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x03ef('0x57'),'MIN':_0x03ef('0x88'),'AVG':_0x03ef('0x89'),'GROUP_CONCAT':_0x03ef('0x58'),'GROUP_CONCAT ASC':_0x03ef('0x59'),'GROUP_CONCAT DESC':_0x03ef('0x8a')};var _0x21e67b={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x03ef('0x5b'),'HOUR':'HOUR(%s)','ROUND':_0x03ef('0x8b'),'UNIX_TIMESTAMP':_0x03ef('0x5d')};var _0x585d27=function(_0x3c9273){return!_[_0x03ef('0x5e')]([_0x03ef('0x5f'),'IS\x20NOT\x20NULL',_0x03ef('0x61'),'IS\x20NOT\x20EMPTY'],_0x3c9273);};var _0x41fac0=function(_0x348089){if(!_0x348089||!_0x348089['rules'][_0x03ef('0x36')]){return'';}for(var _0x37876c='(',_0x48466c=0x0;_0x48466c<_0x348089[_0x03ef('0x63')]['length'];_0x48466c+=0x1){_0x48466c>0x0&&(_0x37876c+='\x20'+_0x348089[_0x03ef('0x64')]+'\x20');_0x37876c+=_0x348089['rules'][_0x48466c][_0x03ef('0x65')]?_0x41fac0(_0x348089[_0x03ef('0x63')][_0x48466c][_0x03ef('0x65')]):_0x348089[_0x03ef('0x63')][_0x48466c]['field']+'\x20'+_0x348089[_0x03ef('0x63')][_0x48466c][_0x03ef('0x67')]+(_0x585d27(_0x348089[_0x03ef('0x63')][_0x48466c][_0x03ef('0x67')])?'\x20'+_0x348089['rules'][_0x48466c][_0x03ef('0x68')]:'');}return _0x37876c+')';};var _0x3fff64={'where':{'id':_0x15142f['id']}},_0x4c8b51,_0x13733b,_0x1bd22f,_0x284cea,_0x5370d5;_0x3fff64=_[_0x03ef('0x3d')]({},_0x3fff64,_0x18a6c3);return db['AnalyticDefaultReport'][_0x03ef('0x45')](_0x3fff64)[_0x03ef('0x23')](function(_0x2841c2){if(_0x2841c2){_0x4c8b51=_0x2841c2;return _0x2841c2[_0x03ef('0x69')]();}return null;})[_0x03ef('0x23')](function(_0x5bebf0){if(_0x5bebf0){if(!_0x5bebf0[_0x03ef('0x36')]){throw new db[(_0x03ef('0x6a'))]['ValidationErrorItem'](_0x03ef('0x8c'),0x193);}_0x13733b=_0x5bebf0;return db[_0x03ef('0x6c')]['findAll']({'raw':!![]});}return null;})['then'](function(_0x2ef28b){if(_0x2ef28b){_0x1bd22f=_['keyBy'](_0x2ef28b,'id');var _0x4e0d30;var _0x536536=squel[_0x03ef('0x6e')]();_0x536536[_0x03ef('0x6f')](_0x4c8b51['table']);for(var _0x39f14e=0x0;_0x39f14e<_0x13733b[_0x03ef('0x36')];_0x39f14e+=0x1){_0x4e0d30=_0x13733b[_0x39f14e][_0x03ef('0x70')]?_0x1bd22f[_0x13733b[_0x39f14e][_0x03ef('0x70')]]['metric']:_0x13733b[_0x39f14e][_0x03ef('0x66')];_0x4e0d30=_0x13733b[_0x39f14e][_0x03ef('0x72')]?_[_0x03ef('0x73')](_0x500a82[_0x13733b[_0x39f14e]['function']],'%s',_0x4e0d30):_0x4e0d30;_0x4e0d30=_0x13733b[_0x39f14e][_0x03ef('0x74')]?_[_0x03ef('0x73')](_0x21e67b[_0x13733b[_0x39f14e][_0x03ef('0x74')]],'%s',_0x4e0d30):_0x4e0d30;if(_0x13733b[_0x39f14e][_0x03ef('0x75')]){_0x536536[_0x03ef('0x65')](_0x4e0d30);}_0x13733b[_0x39f14e]['orderBy']&&_0x536536[_0x03ef('0x39')](_0x4e0d30,_0x13733b[_0x39f14e][_0x03ef('0x76')]===_0x03ef('0x8d')?![]:!![]);_0x536536['field'](_0x4e0d30,_0x13733b[_0x39f14e][_0x03ef('0x77')]||_0x4e0d30);}if(_0x4c8b51['joins']){_0x4c8b51['joins']=JSON[_0x03ef('0x79')](_0x4c8b51[_0x03ef('0x78')]);for(var _0x16dfda=0x0;_0x16dfda<_0x4c8b51['joins']['length'];_0x16dfda+=0x1){if(_0x4c8b51[_0x03ef('0x78')][_0x16dfda][_0x03ef('0x2d')]&&_['includes'](_0x55ea0f,_0x4c8b51[_0x03ef('0x78')][_0x16dfda]['type'])&&_0x4c8b51[_0x03ef('0x78')][_0x16dfda][_0x03ef('0x7a')]&&_0x4c8b51[_0x03ef('0x78')][_0x16dfda][_0x03ef('0x7b')]&&_0x4c8b51['joins'][_0x16dfda][_0x03ef('0x7c')]){_0x536536[_0x4c8b51[_0x03ef('0x78')][_0x16dfda][_0x03ef('0x2d')]](_0x4c8b51[_0x03ef('0x78')][_0x16dfda][_0x03ef('0x7b')],null,util[_0x03ef('0x74')](_0x03ef('0x7d'),_0x4c8b51['table'],_0x4c8b51[_0x03ef('0x78')][_0x16dfda][_0x03ef('0x7a')],_0x4c8b51[_0x03ef('0x78')][_0x16dfda][_0x03ef('0x7b')],_0x4c8b51[_0x03ef('0x78')][_0x16dfda][_0x03ef('0x7c')]));}}}if(_0x4c8b51[_0x03ef('0x7f')]){_0x4c8b51['conditions']=JSON['parse'](_0x4c8b51[_0x03ef('0x7f')]);_0x536536['where'](_0x41fac0(_0x4c8b51[_0x03ef('0x7f')][_0x03ef('0x65')]));}_0x5370d5=_0x536536[_0x03ef('0x80')]();_0x536536[_0x03ef('0x1d')](_0x559755);_0x536536[_0x03ef('0x1c')](0x0);return;}})[_0x03ef('0x23')](function(){if(_0x15c000[_0x03ef('0x8e')]==='web'){return null;}var _0x193278=_[_0x03ef('0x3d')](_0x15c000,{'name':_0x15c000[_0x03ef('0x8f')]||_0x15c000['name']||_0x4c8b51['name'],'basename':_0x1ed0bd,'savename':util[_0x03ef('0x74')]('%s-%s.%s',_0x15c000[_0x03ef('0x27')]||_0x4c8b51['name'],require(_0x03ef('0x90'))[_0x03ef('0x91')](0x4),_0x15c000[_0x03ef('0x8e')]||'csv'),'reportId':_0x4c8b51['id'],'reportType':'default'});return db[_0x03ef('0x92')][_0x03ef('0x46')](_0x193278,{'raw':!![]});})['then'](function(_0x39ba85){if(_0x4c8b51[_0x03ef('0x7e')]===_0x03ef('0x93')){_0x5370d5['where'](_0x4c8b51['table']+_0x03ef('0x94'),_0x15c000['startDate'],_0x15c000[_0x03ef('0x95')]);}else{_0x5370d5[_0x03ef('0x3b')](_0x4c8b51[_0x03ef('0x7e')]+_0x03ef('0x96'),_0x15c000['startDate'],_0x15c000['endDate']);}if(_0x39ba85){logger[_0x03ef('0x97')](_0x03ef('0x98'),_0x5370d5['toString']());require(_0x03ef('0x99'))[_0x03ef('0x9a')](path[_0x03ef('0x51')](__dirname,_0x03ef('0x9b'),_0x39ba85[_0x03ef('0x8e')]),[_0x39ba85['id'],_0x5370d5[_0x03ef('0x83')](),path[_0x03ef('0x51')](__dirname,'../../files/reports',_0x39ba85[_0x03ef('0x9c')]),_0x1ed0bd]);return _0x39ba85;}else{var _0xbdb31=squel['select']();_0xbdb31[_0x03ef('0x6f')]('('+_0x5370d5[_0x03ef('0x83')]()+')','countTable');_0xbdb31[_0x03ef('0x66')](_0x03ef('0x9d'),_0x03ef('0x1b'));_0x5370d5['limit'](_0x15c000['limit']||_0x559755);_0x5370d5[_0x03ef('0x1c')](_0x15c000[_0x03ef('0x1c')]||0x0);return dbH[_0x03ef('0x84')][_0x03ef('0x30')](_0xbdb31[_0x03ef('0x83')](),{'type':dbH['sequelize'][_0x03ef('0x85')][_0x03ef('0x86')]})[_0x03ef('0x23')](function(_0x291129){if(!_0x291129[_0x03ef('0x36')]){_0x284cea=0x0;}else{_0x284cea=_0x291129[0x0][_0x03ef('0x1b')]||0x0;}return dbH[_0x03ef('0x84')][_0x03ef('0x30')](_0x5370d5[_0x03ef('0x83')](),{'type':dbH[_0x03ef('0x84')][_0x03ef('0x85')]['SELECT']});})[_0x03ef('0x23')](function(_0x5efe51){return{'rows':_0x5efe51||[],'count':_0x284cea};});}});}exports[_0x03ef('0x9e')]=function(_0x45c1ae,_0x2a653d){return runReport(_0x45c1ae[_0x03ef('0x4f')],_0x45c1ae[_0x03ef('0x30')],_0x45c1ae['options'])[_0x03ef('0x23')](respondWithResult(_0x2a653d,null))[_0x03ef('0x42')](handleError(_0x2a653d,null));};exports['runReport']=runReport;exports[_0x03ef('0x30')]=function(_0x6ce007,_0x43f9bc){var _0x1046fd=0xa;var _0x4e88ef=[_0x03ef('0x51'),_0x03ef('0x52'),_0x03ef('0x53'),_0x03ef('0x87')];var _0xc6b7c2={'SUM':_0x03ef('0x54'),'COUNT':_0x03ef('0x55'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x03ef('0x57'),'MIN':_0x03ef('0x88'),'AVG':_0x03ef('0x89'),'GROUP_CONCAT':_0x03ef('0x58'),'GROUP_CONCAT ASC':_0x03ef('0x59'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0xb7e49f={'SEC_TO_TIME':_0x03ef('0x5a'),'DATE':_0x03ef('0x5b'),'HOUR':_0x03ef('0x5c'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x03ef('0x5d')};var _0x1becc4=function(_0xe4dfc6){return!_['includes']([_0x03ef('0x5f'),_0x03ef('0x60'),_0x03ef('0x61'),_0x03ef('0x62')],_0xe4dfc6);};var _0x2ce788=function(_0x579a76){if(!_0x579a76||!_0x579a76[_0x03ef('0x63')][_0x03ef('0x36')]){return'';}for(var _0x37b2c5='(',_0x40de6e=0x0;_0x40de6e<_0x579a76['rules'][_0x03ef('0x36')];_0x40de6e+=0x1){_0x40de6e>0x0&&(_0x37b2c5+='\x20'+_0x579a76[_0x03ef('0x64')]+'\x20');_0x37b2c5+=_0x579a76['rules'][_0x40de6e][_0x03ef('0x65')]?_0x2ce788(_0x579a76[_0x03ef('0x63')][_0x40de6e][_0x03ef('0x65')]):_0x579a76[_0x03ef('0x63')][_0x40de6e][_0x03ef('0x66')]+'\x20'+_0x579a76['rules'][_0x40de6e][_0x03ef('0x67')]+(_0x1becc4(_0x579a76[_0x03ef('0x63')][_0x40de6e][_0x03ef('0x67')])?'\x20'+_0x579a76[_0x03ef('0x63')][_0x40de6e][_0x03ef('0x68')]:'');}return _0x37b2c5+')';};var _0x2dbb3a={'where':{'id':_0x6ce007['params']['id']}},_0x3410b9,_0x57f6de,_0xea866c,_0x54225b,_0x2aaa77;_0x2dbb3a=_['merge']({},_0x2dbb3a,_0x6ce007['options']);return db[_0x03ef('0x2a')][_0x03ef('0x45')](_0x2dbb3a)['then'](function(_0x20f968){if(_0x20f968){_0x3410b9=_0x20f968;return _0x20f968['getFields']();}return null;})['then'](function(_0x23eb02){if(_0x23eb02){if(!_0x23eb02['length']){throw new db['Sequelize']['ValidationErrorItem'](_0x03ef('0x8c'),0x193);}_0x57f6de=_0x23eb02;return db[_0x03ef('0x6c')][_0x03ef('0x9f')]({'raw':!![]});}return null;})['then'](function(_0x5b5897){if(_0x5b5897){_0xea866c=_[_0x03ef('0x6d')](_0x5b5897,'id');var _0x3f52ca;var _0x1dcc8=squel[_0x03ef('0x6e')]();_0x1dcc8['from'](_0x3410b9['table']);for(var _0x45bc90=0x0;_0x45bc90<_0x57f6de[_0x03ef('0x36')];_0x45bc90+=0x1){_0x3f52ca=_0x57f6de[_0x45bc90][_0x03ef('0x70')]?_0xea866c[_0x57f6de[_0x45bc90]['MetricId']][_0x03ef('0x71')]:_0x57f6de[_0x45bc90][_0x03ef('0x66')];_0x3f52ca=_0x57f6de[_0x45bc90]['function']?_[_0x03ef('0x73')](_0xc6b7c2[_0x57f6de[_0x45bc90][_0x03ef('0x72')]],'%s',_0x3f52ca):_0x3f52ca;_0x3f52ca=_0x57f6de[_0x45bc90][_0x03ef('0x74')]?_[_0x03ef('0x73')](_0xb7e49f[_0x57f6de[_0x45bc90][_0x03ef('0x74')]],'%s',_0x3f52ca):_0x3f52ca;if(_0x57f6de[_0x45bc90][_0x03ef('0x75')]){_0x1dcc8[_0x03ef('0x65')](_0x3f52ca);}_0x57f6de[_0x45bc90]['orderBy']&&_0x1dcc8[_0x03ef('0x39')](_0x3f52ca,_0x57f6de[_0x45bc90][_0x03ef('0x76')]==='DESC'?![]:!![]);_0x1dcc8[_0x03ef('0x66')](_0x3f52ca,_0x57f6de[_0x45bc90][_0x03ef('0x77')]||_0x3f52ca);}if(_0x3410b9[_0x03ef('0x78')]){_0x3410b9['joins']=JSON[_0x03ef('0x79')](_0x3410b9[_0x03ef('0x78')]);for(var _0x51cec4=0x0;_0x51cec4<_0x3410b9['joins'][_0x03ef('0x36')];_0x51cec4+=0x1){if(_0x3410b9['joins'][_0x51cec4]['type']&&_[_0x03ef('0x5e')](_0x4e88ef,_0x3410b9[_0x03ef('0x78')][_0x51cec4][_0x03ef('0x2d')])&&_0x3410b9[_0x03ef('0x78')][_0x51cec4][_0x03ef('0x7a')]&&_0x3410b9[_0x03ef('0x78')][_0x51cec4][_0x03ef('0x7b')]&&_0x3410b9[_0x03ef('0x78')][_0x51cec4][_0x03ef('0x7c')]){_0x1dcc8[_0x3410b9[_0x03ef('0x78')][_0x51cec4][_0x03ef('0x2d')]](_0x3410b9[_0x03ef('0x78')][_0x51cec4][_0x03ef('0x7b')],null,util[_0x03ef('0x74')](_0x03ef('0x7d'),_0x3410b9[_0x03ef('0x7e')],_0x3410b9[_0x03ef('0x78')][_0x51cec4]['parentKey'],_0x3410b9[_0x03ef('0x78')][_0x51cec4][_0x03ef('0x7b')],_0x3410b9[_0x03ef('0x78')][_0x51cec4]['foreignKey']));}}}if(_0x3410b9['conditions']){_0x3410b9[_0x03ef('0x7f')]=JSON[_0x03ef('0x79')](_0x3410b9[_0x03ef('0x7f')]);_0x1dcc8['where'](_0x2ce788(_0x3410b9[_0x03ef('0x7f')]['group']));}_0x2aaa77=_0x1dcc8[_0x03ef('0x80')]();_0x1dcc8[_0x03ef('0x1d')](_0x1046fd);_0x1dcc8['offset'](0x0);logger['debug']('Limited\x20Query:',_0x1dcc8['toString']());return dbH['sequelize'][_0x03ef('0x30')](_0x1dcc8[_0x03ef('0x83')](),{'type':dbH['sequelize'][_0x03ef('0x85')]['SELECT']});}})[_0x03ef('0x23')](function(){return{'sql':_0x2aaa77['toString']()};})[_0x03ef('0x23')](respondWithResult(_0x43f9bc,null))[_0x03ef('0x42')](handleError(_0x43f9bc,null));};
\ No newline at end of file
+var _0xd0b3=['groupBy','orderBy','DESC','parse','joins','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','join','COUNT(%s)','UNIX_TIMESTAMP(%s)','operator','AnalyticMetric','output','web','%s-%s.%s','randomstring','generate','csv','AnalyticExtractedReport','cdr','endDate','startDate','info','Run\x20Query:','child_process','fork','../../components/export/','../../files/reports','savename','COUNT(*)','run','runReport','value','alias','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','path','ejs','lodash','squel','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/environment','../../mysqldb','dbH','sendStatus','status','end','json','offset','undefined','limit','count','apply','reject','save','update','then','get','DefaultReports','UserProfileResource','destroy','error','stack','name','send','index','AnalyticDefaultReport','rawAttributes','fieldName','key','map','keys','query','filters','model','attributes','intersection','fields','length','nolimit','order','sort','where','pick','filter','merge','type','options','includeAll','include','findAll','rows','catch','show','params','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','Reports','UserProfileSection','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','find','preview','left_join','right_join','cross_join','SUM(%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)','SEC_TO_TIME(%s)','DATE(%s)','HOUR(%s)','ROUND(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','group','field','condition','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','keyBy','select','from','table','MetricId','metric','function','replace','format'];(function(_0x53d578,_0x4ca37f){var _0x5ce805=function(_0x237705){while(--_0x237705){_0x53d578['push'](_0x53d578['shift']());}};_0x5ce805(++_0x4ca37f);}(_0xd0b3,0xcf));var _0x3d0b=function(_0x450c0b,_0x17f956){_0x450c0b=_0x450c0b-0x0;var _0x18c267=_0xd0b3[_0x450c0b];return _0x18c267;};'use strict';var emlformat=require(_0x3d0b('0x0'));var rimraf=require(_0x3d0b('0x1'));var zipdir=require(_0x3d0b('0x2'));var jsonpatch=require(_0x3d0b('0x3'));var rp=require(_0x3d0b('0x4'));var moment=require(_0x3d0b('0x5'));var BPromise=require('bluebird');var Mustache=require(_0x3d0b('0x6'));var util=require('util');var path=require(_0x3d0b('0x7'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x3d0b('0x8'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x3d0b('0x9'));var squel=require(_0x3d0b('0xa'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0x3d0b('0xb'));var toCsv=require(_0x3d0b('0xc'));var querystring=require(_0x3d0b('0xd'));var Papa=require(_0x3d0b('0xe'));var Redis=require(_0x3d0b('0xf'));var authService=require(_0x3d0b('0x10'));var qs=require(_0x3d0b('0x11'));var as=require(_0x3d0b('0x12'));var hardwareService=require(_0x3d0b('0x13'));var logger=require('../../config/logger')(_0x3d0b('0x14'));var utils=require('../../config/utils');var config=require(_0x3d0b('0x15'));var licenseUtil=require('../../config/license/util');var db=require(_0x3d0b('0x16'))['db'];var dbH=require('../../mysqldb')[_0x3d0b('0x17')];function respondWithStatusCode(_0x1f5351,_0x3bf596){_0x3bf596=_0x3bf596||0xcc;return function(_0x29c7a1){if(_0x29c7a1){return _0x1f5351[_0x3d0b('0x18')](_0x3bf596);}return _0x1f5351[_0x3d0b('0x19')](_0x3bf596)[_0x3d0b('0x1a')]();};}function respondWithResult(_0x4702d7,_0x16c5b9){_0x16c5b9=_0x16c5b9||0xc8;return function(_0x3b36ad){if(_0x3b36ad){return _0x4702d7[_0x3d0b('0x19')](_0x16c5b9)[_0x3d0b('0x1b')](_0x3b36ad);}};}function respondWithFilteredResult(_0x3b4631,_0x3c77a8){return function(_0x231f77){if(_0x231f77){var _0xf3b78e=typeof _0x3c77a8[_0x3d0b('0x1c')]===_0x3d0b('0x1d')&&typeof _0x3c77a8[_0x3d0b('0x1e')]===_0x3d0b('0x1d');var _0x3ecf37=_0x231f77[_0x3d0b('0x1f')];var _0x466d37=_0xf3b78e?0x0:_0x3c77a8[_0x3d0b('0x1c')];var _0x1bea2c=_0xf3b78e?_0x231f77[_0x3d0b('0x1f')]:_0x3c77a8['offset']+_0x3c77a8[_0x3d0b('0x1e')];var _0x360545;if(_0x1bea2c>=_0x3ecf37){_0x1bea2c=_0x3ecf37;_0x360545=0xc8;}else{_0x360545=0xce;}_0x3b4631['status'](_0x360545);return _0x3b4631['set']('Content-Range',_0x466d37+'-'+_0x1bea2c+'/'+_0x3ecf37)[_0x3d0b('0x1b')](_0x231f77);}return null;};}function patchUpdates(_0x287ef2){return function(_0xa5e42c){try{jsonpatch[_0x3d0b('0x20')](_0xa5e42c,_0x287ef2,!![]);}catch(_0x4c7161){return BPromise[_0x3d0b('0x21')](_0x4c7161);}return _0xa5e42c[_0x3d0b('0x22')]();};}function saveUpdates(_0x990bdc,_0x591e68){return function(_0x215c52){if(_0x215c52){return _0x215c52[_0x3d0b('0x23')](_0x990bdc)[_0x3d0b('0x24')](function(_0xbd0304){return _0xbd0304;});}return null;};}function removeEntity(_0x2863ae,_0x36ca32){return function(_0xeb38b3){if(_0xeb38b3){return _0xeb38b3['destroy']()[_0x3d0b('0x24')](function(){var _0x461913=_0xeb38b3[_0x3d0b('0x25')]({'plain':!![]});var _0x3a36c5=_0x3d0b('0x26');return db[_0x3d0b('0x27')][_0x3d0b('0x28')]({'where':{'type':_0x3a36c5,'resourceId':_0x461913['id']}})[_0x3d0b('0x24')](function(){return _0xeb38b3;});})['then'](function(){_0x2863ae[_0x3d0b('0x19')](0xcc)[_0x3d0b('0x1a')]();});}};}function handleEntityNotFound(_0x5e7558,_0x4b9696){return function(_0x31e033){if(!_0x31e033){_0x5e7558[_0x3d0b('0x18')](0x194);}return _0x31e033;};}function handleError(_0x5acaab,_0x17c8e0){_0x17c8e0=_0x17c8e0||0x1f4;return function(_0x370c2c){logger[_0x3d0b('0x29')](_0x370c2c[_0x3d0b('0x2a')]);if(_0x370c2c['name']){delete _0x370c2c[_0x3d0b('0x2b')];}_0x5acaab[_0x3d0b('0x19')](_0x17c8e0)[_0x3d0b('0x2c')](_0x370c2c);};}exports[_0x3d0b('0x2d')]=function(_0x1ba0b2,_0xf5a3f0){var _0x12acf8={},_0x422615={},_0x45f337={'count':0x0,'rows':[]};var _0x20c6d7=_['map'](db[_0x3d0b('0x2e')][_0x3d0b('0x2f')],function(_0x2ceda3){return{'name':_0x2ceda3[_0x3d0b('0x30')],'type':_0x2ceda3['type'][_0x3d0b('0x31')]};});_0x422615['model']=_[_0x3d0b('0x32')](_0x20c6d7,_0x3d0b('0x2b'));_0x422615['query']=_[_0x3d0b('0x33')](_0x1ba0b2[_0x3d0b('0x34')]);_0x422615[_0x3d0b('0x35')]=_['intersection'](_0x422615[_0x3d0b('0x36')],_0x422615[_0x3d0b('0x34')]);_0x12acf8[_0x3d0b('0x37')]=_[_0x3d0b('0x38')](_0x422615[_0x3d0b('0x36')],qs[_0x3d0b('0x39')](_0x1ba0b2[_0x3d0b('0x34')][_0x3d0b('0x39')]));_0x12acf8[_0x3d0b('0x37')]=_0x12acf8[_0x3d0b('0x37')][_0x3d0b('0x3a')]?_0x12acf8['attributes']:_0x422615['model'];if(!_0x1ba0b2[_0x3d0b('0x34')]['hasOwnProperty'](_0x3d0b('0x3b'))){_0x12acf8[_0x3d0b('0x1e')]=qs[_0x3d0b('0x1e')](_0x1ba0b2[_0x3d0b('0x34')][_0x3d0b('0x1e')]);_0x12acf8['offset']=qs['offset'](_0x1ba0b2['query']['offset']);}_0x12acf8[_0x3d0b('0x3c')]=qs['sort'](_0x1ba0b2[_0x3d0b('0x34')][_0x3d0b('0x3d')]);_0x12acf8[_0x3d0b('0x3e')]=qs[_0x3d0b('0x35')](_[_0x3d0b('0x3f')](_0x1ba0b2['query'],_0x422615['filters']),_0x20c6d7);if(_0x1ba0b2[_0x3d0b('0x34')][_0x3d0b('0x40')]){_0x12acf8[_0x3d0b('0x3e')]=_[_0x3d0b('0x41')](_0x12acf8['where'],{'$or':_[_0x3d0b('0x32')](_0x20c6d7,function(_0x27e193){if(_0x27e193[_0x3d0b('0x42')]!=='VIRTUAL'){var _0x154ea8={};_0x154ea8[_0x27e193['name']]={'$like':'%'+_0x1ba0b2[_0x3d0b('0x34')][_0x3d0b('0x40')]+'%'};return _0x154ea8;}})});}_0x12acf8=_[_0x3d0b('0x41')]({},_0x12acf8,_0x1ba0b2[_0x3d0b('0x43')]);var _0x39a189={'where':_0x12acf8['where']};return db[_0x3d0b('0x2e')][_0x3d0b('0x1f')](_0x39a189)[_0x3d0b('0x24')](function(_0x4a2a98){_0x45f337[_0x3d0b('0x1f')]=_0x4a2a98;if(_0x1ba0b2[_0x3d0b('0x34')][_0x3d0b('0x44')]){_0x12acf8[_0x3d0b('0x45')]=[{'all':!![]}];}return db[_0x3d0b('0x2e')][_0x3d0b('0x46')](_0x12acf8);})['then'](function(_0x1e6053){_0x45f337[_0x3d0b('0x47')]=_0x1e6053;return _0x45f337;})[_0x3d0b('0x24')](respondWithFilteredResult(_0xf5a3f0,_0x12acf8))[_0x3d0b('0x48')](handleError(_0xf5a3f0,null));};exports[_0x3d0b('0x49')]=function(_0x20eefe,_0x55fc31){var _0x327a53={'raw':!![],'where':{'id':_0x20eefe[_0x3d0b('0x4a')]['id']}},_0x53ae2e={};_0x53ae2e[_0x3d0b('0x36')]=_[_0x3d0b('0x33')](db[_0x3d0b('0x2e')][_0x3d0b('0x2f')]);_0x53ae2e[_0x3d0b('0x34')]=_['keys'](_0x20eefe[_0x3d0b('0x34')]);_0x53ae2e[_0x3d0b('0x35')]=_[_0x3d0b('0x38')](_0x53ae2e[_0x3d0b('0x36')],_0x53ae2e['query']);_0x327a53[_0x3d0b('0x37')]=_[_0x3d0b('0x38')](_0x53ae2e[_0x3d0b('0x36')],qs[_0x3d0b('0x39')](_0x20eefe['query']['fields']));_0x327a53['attributes']=_0x327a53[_0x3d0b('0x37')][_0x3d0b('0x3a')]?_0x327a53[_0x3d0b('0x37')]:_0x53ae2e['model'];if(_0x20eefe[_0x3d0b('0x34')][_0x3d0b('0x44')]){_0x327a53[_0x3d0b('0x45')]=[{'all':!![]}];}_0x327a53=_[_0x3d0b('0x41')]({},_0x327a53,_0x20eefe[_0x3d0b('0x43')]);return db[_0x3d0b('0x2e')]['find'](_0x327a53)[_0x3d0b('0x24')](handleEntityNotFound(_0x55fc31,null))['then'](respondWithResult(_0x55fc31,null))[_0x3d0b('0x48')](handleError(_0x55fc31,null));};exports[_0x3d0b('0x4b')]=function(_0x154cf0,_0x443e0e){return db[_0x3d0b('0x2e')][_0x3d0b('0x4b')](_0x154cf0[_0x3d0b('0x4c')],{})['then'](function(_0x2a3d9c){var _0x19c165=_0x154cf0[_0x3d0b('0x4d')][_0x3d0b('0x25')]({'plain':!![]});if(!_0x19c165)throw new Error(_0x3d0b('0x4e'));if(_0x19c165['role']===_0x3d0b('0x4d')){var _0x534f39=_0x2a3d9c[_0x3d0b('0x25')]({'plain':!![]});var _0x14a41d=_0x3d0b('0x4f');return db[_0x3d0b('0x50')]['find']({'where':{'name':_0x14a41d,'userProfileId':_0x19c165['userProfileId']},'raw':!![]})['then'](function(_0x2f34a3){if(_0x2f34a3&&_0x2f34a3['autoAssociation']===0x0){return db['UserProfileResource'][_0x3d0b('0x4b')]({'name':_0x534f39[_0x3d0b('0x2b')],'resourceId':_0x534f39['id'],'type':_0x3d0b('0x26'),'sectionId':_0x2f34a3['id']},{})[_0x3d0b('0x24')](function(){return _0x2a3d9c;});}else{return _0x2a3d9c;}})['catch'](function(_0x334df1){logger[_0x3d0b('0x29')](_0x3d0b('0x51'),_0x334df1);throw _0x334df1;});}return _0x2a3d9c;})['then'](respondWithResult(_0x443e0e,0xc9))[_0x3d0b('0x48')](handleError(_0x443e0e,null));};exports[_0x3d0b('0x23')]=function(_0x3c0a8d,_0x268fbc){if(_0x3c0a8d[_0x3d0b('0x4c')]['id']){delete _0x3c0a8d[_0x3d0b('0x4c')]['id'];}return db[_0x3d0b('0x2e')]['find']({'where':{'id':_0x3c0a8d[_0x3d0b('0x4a')]['id']}})['then'](handleEntityNotFound(_0x268fbc,null))[_0x3d0b('0x24')](saveUpdates(_0x3c0a8d[_0x3d0b('0x4c')],null))[_0x3d0b('0x24')](respondWithResult(_0x268fbc,null))[_0x3d0b('0x48')](handleError(_0x268fbc,null));};exports[_0x3d0b('0x28')]=function(_0x194e0d,_0x49730f){return db[_0x3d0b('0x2e')][_0x3d0b('0x52')]({'where':{'id':_0x194e0d[_0x3d0b('0x4a')]['id']}})['then'](handleEntityNotFound(_0x49730f,null))[_0x3d0b('0x24')](removeEntity(_0x49730f,null))[_0x3d0b('0x48')](handleError(_0x49730f,null));};exports[_0x3d0b('0x53')]=function(_0x221dd1,_0x28b68c){var _0x2a37a6=0xa;var _0x6256e8=['join',_0x3d0b('0x54'),_0x3d0b('0x55'),_0x3d0b('0x56')];var _0x2ab32c={'SUM':_0x3d0b('0x57'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x3d0b('0x58'),'MAX':_0x3d0b('0x59'),'MIN':_0x3d0b('0x5a'),'AVG':_0x3d0b('0x5b'),'GROUP_CONCAT':_0x3d0b('0x5c'),'GROUP_CONCAT ASC':_0x3d0b('0x5d'),'GROUP_CONCAT DESC':_0x3d0b('0x5e')};var _0x5247b7={'SEC_TO_TIME':_0x3d0b('0x5f'),'DATE':_0x3d0b('0x60'),'HOUR':_0x3d0b('0x61'),'ROUND':_0x3d0b('0x62'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x15975a=function(_0x49bfc5){return!_[_0x3d0b('0x63')]([_0x3d0b('0x64'),_0x3d0b('0x65'),_0x3d0b('0x66'),_0x3d0b('0x67')],_0x49bfc5);};var _0x36ad5d=function(_0x1a303f){if(!_0x1a303f||!_0x1a303f[_0x3d0b('0x68')][_0x3d0b('0x3a')]){return'';}for(var _0xa06649='(',_0x25660e=0x0;_0x25660e<_0x1a303f['rules']['length'];_0x25660e+=0x1){_0x25660e>0x0&&(_0xa06649+='\x20'+_0x1a303f['operator']+'\x20');_0xa06649+=_0x1a303f[_0x3d0b('0x68')][_0x25660e]['group']?_0x36ad5d(_0x1a303f[_0x3d0b('0x68')][_0x25660e][_0x3d0b('0x69')]):_0x1a303f['rules'][_0x25660e][_0x3d0b('0x6a')]+'\x20'+_0x1a303f[_0x3d0b('0x68')][_0x25660e][_0x3d0b('0x6b')]+(_0x15975a(_0x1a303f['rules'][_0x25660e][_0x3d0b('0x6b')])?'\x20'+_0x1a303f[_0x3d0b('0x68')][_0x25660e]['value']:'');}return _0xa06649+')';};var _0x40f346={'where':{'id':_0x221dd1[_0x3d0b('0x4a')]['id']}},_0x470fe2,_0x4af8b5,_0x1ea506,_0x55d9a9,_0x48ff86;_0x40f346=_[_0x3d0b('0x41')]({},_0x40f346,_0x221dd1['options']);return db['AnalyticDefaultReport'][_0x3d0b('0x52')](_0x40f346)['then'](function(_0x2be04e){if(_0x2be04e){_0x470fe2=_0x2be04e;return _0x2be04e[_0x3d0b('0x6c')]();}return null;})['then'](function(_0x4bc89b){if(_0x4bc89b){if(!_0x4bc89b['length']){throw new db[(_0x3d0b('0x6d'))][(_0x3d0b('0x6e'))](_0x3d0b('0x6f'),0x193);}_0x4af8b5=_0x4bc89b;return db['AnalyticMetric'][_0x3d0b('0x46')]({'raw':!![]});}return null;})[_0x3d0b('0x24')](function(_0x13130e){if(_0x13130e){_0x1ea506=_[_0x3d0b('0x70')](_0x13130e,'id');var _0x3c7ac0;var _0x2b6185=squel[_0x3d0b('0x71')]();_0x2b6185[_0x3d0b('0x72')](_0x470fe2[_0x3d0b('0x73')]);for(var _0x3a020f=0x0;_0x3a020f<_0x4af8b5[_0x3d0b('0x3a')];_0x3a020f+=0x1){_0x3c7ac0=_0x4af8b5[_0x3a020f][_0x3d0b('0x74')]?_0x1ea506[_0x4af8b5[_0x3a020f][_0x3d0b('0x74')]][_0x3d0b('0x75')]:_0x4af8b5[_0x3a020f][_0x3d0b('0x6a')];_0x3c7ac0=_0x4af8b5[_0x3a020f][_0x3d0b('0x76')]?_[_0x3d0b('0x77')](_0x2ab32c[_0x4af8b5[_0x3a020f][_0x3d0b('0x76')]],'%s',_0x3c7ac0):_0x3c7ac0;_0x3c7ac0=_0x4af8b5[_0x3a020f][_0x3d0b('0x78')]?_['replace'](_0x5247b7[_0x4af8b5[_0x3a020f][_0x3d0b('0x78')]],'%s',_0x3c7ac0):_0x3c7ac0;if(_0x4af8b5[_0x3a020f][_0x3d0b('0x79')]){_0x2b6185[_0x3d0b('0x69')](_0x3c7ac0);}_0x4af8b5[_0x3a020f][_0x3d0b('0x7a')]&&_0x2b6185[_0x3d0b('0x3c')](_0x3c7ac0,_0x4af8b5[_0x3a020f][_0x3d0b('0x7a')]===_0x3d0b('0x7b')?![]:!![]);_0x2b6185['field'](_0x3c7ac0,_0x4af8b5[_0x3a020f]['alias']||_0x3c7ac0);}if(_0x470fe2['joins']){_0x470fe2['joins']=JSON[_0x3d0b('0x7c')](_0x470fe2['joins']);for(var _0x22c8f9=0x0;_0x22c8f9<_0x470fe2[_0x3d0b('0x7d')][_0x3d0b('0x3a')];_0x22c8f9+=0x1){if(_0x470fe2[_0x3d0b('0x7d')][_0x22c8f9][_0x3d0b('0x42')]&&_['includes'](_0x6256e8,_0x470fe2[_0x3d0b('0x7d')][_0x22c8f9][_0x3d0b('0x42')])&&_0x470fe2['joins'][_0x22c8f9][_0x3d0b('0x7e')]&&_0x470fe2['joins'][_0x22c8f9][_0x3d0b('0x7f')]&&_0x470fe2['joins'][_0x22c8f9][_0x3d0b('0x80')]){_0x2b6185[_0x470fe2[_0x3d0b('0x7d')][_0x22c8f9]['type']](_0x470fe2[_0x3d0b('0x7d')][_0x22c8f9][_0x3d0b('0x7f')],null,util['format'](_0x3d0b('0x81'),_0x470fe2[_0x3d0b('0x73')],_0x470fe2[_0x3d0b('0x7d')][_0x22c8f9][_0x3d0b('0x7e')],_0x470fe2['joins'][_0x22c8f9][_0x3d0b('0x7f')],_0x470fe2[_0x3d0b('0x7d')][_0x22c8f9][_0x3d0b('0x80')]));}}}if(_0x470fe2['conditions']){_0x470fe2[_0x3d0b('0x82')]=JSON['parse'](_0x470fe2[_0x3d0b('0x82')]);_0x2b6185[_0x3d0b('0x3e')](_0x36ad5d(_0x470fe2['conditions'][_0x3d0b('0x69')]));}_0x48ff86=_0x2b6185[_0x3d0b('0x83')]();_0x2b6185[_0x3d0b('0x1e')](_0x2a37a6);_0x2b6185[_0x3d0b('0x1c')](0x0);logger[_0x3d0b('0x84')](_0x3d0b('0x85'),_0x2b6185[_0x3d0b('0x86')]());return dbH['sequelize'][_0x3d0b('0x34')](_0x2b6185[_0x3d0b('0x86')](),{'type':dbH[_0x3d0b('0x87')][_0x3d0b('0x88')]['SELECT']});}})['then'](respondWithResult(_0x28b68c,null))[_0x3d0b('0x48')](handleError(_0x28b68c,null));};function runReport(_0x158c84,_0x19806c,_0x541cfd){var _0x91b16a=_0x19806c['name'];var _0xceb7fe=0xa;var _0x1331fe=[_0x3d0b('0x89'),_0x3d0b('0x54'),_0x3d0b('0x55'),_0x3d0b('0x56')];var _0x20158b={'SUM':_0x3d0b('0x57'),'COUNT':_0x3d0b('0x8a'),'COUNT DISTINCT':_0x3d0b('0x58'),'MAX':_0x3d0b('0x59'),'MIN':'MIN(%s)','AVG':_0x3d0b('0x5b'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x3d0b('0x5d'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x4d8209={'SEC_TO_TIME':_0x3d0b('0x5f'),'DATE':_0x3d0b('0x60'),'HOUR':_0x3d0b('0x61'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x3d0b('0x8b')};var _0x49fc4e=function(_0x449104){return!_[_0x3d0b('0x63')](['IS\x20NULL',_0x3d0b('0x65'),_0x3d0b('0x66'),_0x3d0b('0x67')],_0x449104);};var _0x3ab380=function(_0x56cf9c){if(!_0x56cf9c||!_0x56cf9c[_0x3d0b('0x68')][_0x3d0b('0x3a')]){return'';}for(var _0x2fb1e9='(',_0x51774a=0x0;_0x51774a<_0x56cf9c[_0x3d0b('0x68')][_0x3d0b('0x3a')];_0x51774a+=0x1){_0x51774a>0x0&&(_0x2fb1e9+='\x20'+_0x56cf9c[_0x3d0b('0x8c')]+'\x20');_0x2fb1e9+=_0x56cf9c[_0x3d0b('0x68')][_0x51774a][_0x3d0b('0x69')]?_0x3ab380(_0x56cf9c[_0x3d0b('0x68')][_0x51774a][_0x3d0b('0x69')]):_0x56cf9c[_0x3d0b('0x68')][_0x51774a][_0x3d0b('0x6a')]+'\x20'+_0x56cf9c[_0x3d0b('0x68')][_0x51774a][_0x3d0b('0x6b')]+(_0x49fc4e(_0x56cf9c[_0x3d0b('0x68')][_0x51774a]['condition'])?'\x20'+_0x56cf9c[_0x3d0b('0x68')][_0x51774a]['value']:'');}return _0x2fb1e9+')';};var _0x2bb783={'where':{'id':_0x158c84['id']}},_0x171e4a,_0x57efcf,_0x33df39,_0x564ede,_0x4be48f;_0x2bb783=_['merge']({},_0x2bb783,_0x541cfd);return db[_0x3d0b('0x2e')]['find'](_0x2bb783)['then'](function(_0x544149){if(_0x544149){_0x171e4a=_0x544149;return _0x544149[_0x3d0b('0x6c')]();}return null;})['then'](function(_0x5cda9e){if(_0x5cda9e){if(!_0x5cda9e[_0x3d0b('0x3a')]){throw new db[(_0x3d0b('0x6d'))]['ValidationErrorItem'](_0x3d0b('0x6f'),0x193);}_0x57efcf=_0x5cda9e;return db[_0x3d0b('0x8d')]['findAll']({'raw':!![]});}return null;})[_0x3d0b('0x24')](function(_0x55432d){if(_0x55432d){_0x33df39=_[_0x3d0b('0x70')](_0x55432d,'id');var _0x403aec;var _0x98a646=squel['select']();_0x98a646[_0x3d0b('0x72')](_0x171e4a['table']);for(var _0x2889aa=0x0;_0x2889aa<_0x57efcf['length'];_0x2889aa+=0x1){_0x403aec=_0x57efcf[_0x2889aa][_0x3d0b('0x74')]?_0x33df39[_0x57efcf[_0x2889aa][_0x3d0b('0x74')]][_0x3d0b('0x75')]:_0x57efcf[_0x2889aa][_0x3d0b('0x6a')];_0x403aec=_0x57efcf[_0x2889aa][_0x3d0b('0x76')]?_[_0x3d0b('0x77')](_0x20158b[_0x57efcf[_0x2889aa]['function']],'%s',_0x403aec):_0x403aec;_0x403aec=_0x57efcf[_0x2889aa]['format']?_[_0x3d0b('0x77')](_0x4d8209[_0x57efcf[_0x2889aa][_0x3d0b('0x78')]],'%s',_0x403aec):_0x403aec;if(_0x57efcf[_0x2889aa]['groupBy']){_0x98a646['group'](_0x403aec);}_0x57efcf[_0x2889aa][_0x3d0b('0x7a')]&&_0x98a646[_0x3d0b('0x3c')](_0x403aec,_0x57efcf[_0x2889aa][_0x3d0b('0x7a')]===_0x3d0b('0x7b')?![]:!![]);_0x98a646[_0x3d0b('0x6a')](_0x403aec,_0x57efcf[_0x2889aa]['alias']||_0x403aec);}if(_0x171e4a[_0x3d0b('0x7d')]){_0x171e4a[_0x3d0b('0x7d')]=JSON[_0x3d0b('0x7c')](_0x171e4a['joins']);for(var _0x23c5f8=0x0;_0x23c5f8<_0x171e4a[_0x3d0b('0x7d')][_0x3d0b('0x3a')];_0x23c5f8+=0x1){if(_0x171e4a['joins'][_0x23c5f8][_0x3d0b('0x42')]&&_[_0x3d0b('0x63')](_0x1331fe,_0x171e4a[_0x3d0b('0x7d')][_0x23c5f8][_0x3d0b('0x42')])&&_0x171e4a[_0x3d0b('0x7d')][_0x23c5f8][_0x3d0b('0x7e')]&&_0x171e4a[_0x3d0b('0x7d')][_0x23c5f8][_0x3d0b('0x7f')]&&_0x171e4a[_0x3d0b('0x7d')][_0x23c5f8]['foreignKey']){_0x98a646[_0x171e4a['joins'][_0x23c5f8][_0x3d0b('0x42')]](_0x171e4a['joins'][_0x23c5f8][_0x3d0b('0x7f')],null,util[_0x3d0b('0x78')](_0x3d0b('0x81'),_0x171e4a[_0x3d0b('0x73')],_0x171e4a['joins'][_0x23c5f8]['parentKey'],_0x171e4a[_0x3d0b('0x7d')][_0x23c5f8][_0x3d0b('0x7f')],_0x171e4a[_0x3d0b('0x7d')][_0x23c5f8][_0x3d0b('0x80')]));}}}if(_0x171e4a[_0x3d0b('0x82')]){_0x171e4a['conditions']=JSON[_0x3d0b('0x7c')](_0x171e4a[_0x3d0b('0x82')]);_0x98a646[_0x3d0b('0x3e')](_0x3ab380(_0x171e4a[_0x3d0b('0x82')][_0x3d0b('0x69')]));}_0x4be48f=_0x98a646[_0x3d0b('0x83')]();_0x98a646[_0x3d0b('0x1e')](_0xceb7fe);_0x98a646[_0x3d0b('0x1c')](0x0);return;}})[_0x3d0b('0x24')](function(){if(_0x19806c[_0x3d0b('0x8e')]===_0x3d0b('0x8f')){return null;}var _0x50cfbf=_[_0x3d0b('0x41')](_0x19806c,{'name':_0x19806c['fullPath']||_0x19806c[_0x3d0b('0x2b')]||_0x171e4a[_0x3d0b('0x2b')],'basename':_0x91b16a,'savename':util[_0x3d0b('0x78')](_0x3d0b('0x90'),_0x19806c[_0x3d0b('0x2b')]||_0x171e4a['name'],require(_0x3d0b('0x91'))[_0x3d0b('0x92')](0x4),_0x19806c[_0x3d0b('0x8e')]||_0x3d0b('0x93')),'reportId':_0x171e4a['id'],'reportType':'default'});return db[_0x3d0b('0x94')][_0x3d0b('0x4b')](_0x50cfbf,{'raw':!![]});})[_0x3d0b('0x24')](function(_0x3a24a8){if(_0x171e4a['table']===_0x3d0b('0x95')){_0x4be48f[_0x3d0b('0x3e')](_0x171e4a[_0x3d0b('0x73')]+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x19806c['startDate'],_0x19806c[_0x3d0b('0x96')]);}else{_0x4be48f['where'](_0x171e4a['table']+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x19806c[_0x3d0b('0x97')],_0x19806c[_0x3d0b('0x96')]);}if(_0x3a24a8){logger[_0x3d0b('0x98')](_0x3d0b('0x99'),_0x4be48f[_0x3d0b('0x86')]());require(_0x3d0b('0x9a'))[_0x3d0b('0x9b')](path['join'](__dirname,_0x3d0b('0x9c'),_0x3a24a8['output']),[_0x3a24a8['id'],_0x4be48f[_0x3d0b('0x86')](),path['join'](__dirname,_0x3d0b('0x9d'),_0x3a24a8[_0x3d0b('0x9e')]),_0x91b16a]);return _0x3a24a8;}else{var _0x2ab577=squel[_0x3d0b('0x71')]();_0x2ab577['from']('('+_0x4be48f[_0x3d0b('0x86')]()+')','countTable');_0x2ab577[_0x3d0b('0x6a')](_0x3d0b('0x9f'),'count');_0x4be48f['limit'](_0x19806c['limit']||_0xceb7fe);_0x4be48f['offset'](_0x19806c[_0x3d0b('0x1c')]||0x0);return dbH[_0x3d0b('0x87')][_0x3d0b('0x34')](_0x2ab577[_0x3d0b('0x86')](),{'type':dbH[_0x3d0b('0x87')][_0x3d0b('0x88')]['SELECT']})[_0x3d0b('0x24')](function(_0x98800d){if(!_0x98800d[_0x3d0b('0x3a')]){_0x564ede=0x0;}else{_0x564ede=_0x98800d[0x0][_0x3d0b('0x1f')]||0x0;}return dbH[_0x3d0b('0x87')][_0x3d0b('0x34')](_0x4be48f[_0x3d0b('0x86')](),{'type':dbH[_0x3d0b('0x87')][_0x3d0b('0x88')]['SELECT']});})[_0x3d0b('0x24')](function(_0x11e421){return{'rows':_0x11e421||[],'count':_0x564ede};});}});}exports[_0x3d0b('0xa0')]=function(_0x2d3b01,_0x469d12){return runReport(_0x2d3b01[_0x3d0b('0x4a')],_0x2d3b01[_0x3d0b('0x34')],_0x2d3b01['options'])['then'](respondWithResult(_0x469d12,null))[_0x3d0b('0x48')](handleError(_0x469d12,null));};exports[_0x3d0b('0xa1')]=runReport;exports[_0x3d0b('0x34')]=function(_0x5bea73,_0x261660){var _0x45c3a5=0xa;var _0x38c4e2=[_0x3d0b('0x89'),_0x3d0b('0x54'),_0x3d0b('0x55'),_0x3d0b('0x56')];var _0x4d43c8={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT DISTINCT':_0x3d0b('0x58'),'MAX':_0x3d0b('0x59'),'MIN':_0x3d0b('0x5a'),'AVG':'AVG(%s)','GROUP_CONCAT':_0x3d0b('0x5c'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0x3d0b('0x5e')};var _0x5419c6={'SEC_TO_TIME':_0x3d0b('0x5f'),'DATE':'DATE(%s)','HOUR':_0x3d0b('0x61'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x417ab5=function(_0x3877be){return!_['includes']([_0x3d0b('0x64'),_0x3d0b('0x65'),_0x3d0b('0x66'),_0x3d0b('0x67')],_0x3877be);};var _0x128234=function(_0x2a3b08){if(!_0x2a3b08||!_0x2a3b08[_0x3d0b('0x68')][_0x3d0b('0x3a')]){return'';}for(var _0x1be70e='(',_0x112595=0x0;_0x112595<_0x2a3b08['rules']['length'];_0x112595+=0x1){_0x112595>0x0&&(_0x1be70e+='\x20'+_0x2a3b08[_0x3d0b('0x8c')]+'\x20');_0x1be70e+=_0x2a3b08[_0x3d0b('0x68')][_0x112595]['group']?_0x128234(_0x2a3b08[_0x3d0b('0x68')][_0x112595][_0x3d0b('0x69')]):_0x2a3b08[_0x3d0b('0x68')][_0x112595][_0x3d0b('0x6a')]+'\x20'+_0x2a3b08[_0x3d0b('0x68')][_0x112595][_0x3d0b('0x6b')]+(_0x417ab5(_0x2a3b08[_0x3d0b('0x68')][_0x112595][_0x3d0b('0x6b')])?'\x20'+_0x2a3b08[_0x3d0b('0x68')][_0x112595][_0x3d0b('0xa2')]:'');}return _0x1be70e+')';};var _0x7f57b={'where':{'id':_0x5bea73[_0x3d0b('0x4a')]['id']}},_0x357360,_0x1b04af,_0x304882,_0x3124e7,_0x55e661;_0x7f57b=_[_0x3d0b('0x41')]({},_0x7f57b,_0x5bea73[_0x3d0b('0x43')]);return db[_0x3d0b('0x2e')][_0x3d0b('0x52')](_0x7f57b)[_0x3d0b('0x24')](function(_0x1cf83a){if(_0x1cf83a){_0x357360=_0x1cf83a;return _0x1cf83a[_0x3d0b('0x6c')]();}return null;})[_0x3d0b('0x24')](function(_0x6ec4e4){if(_0x6ec4e4){if(!_0x6ec4e4[_0x3d0b('0x3a')]){throw new db[(_0x3d0b('0x6d'))]['ValidationErrorItem'](_0x3d0b('0x6f'),0x193);}_0x1b04af=_0x6ec4e4;return db[_0x3d0b('0x8d')][_0x3d0b('0x46')]({'raw':!![]});}return null;})['then'](function(_0xa914f4){if(_0xa914f4){_0x304882=_['keyBy'](_0xa914f4,'id');var _0x532ebf;var _0x534d6a=squel[_0x3d0b('0x71')]();_0x534d6a[_0x3d0b('0x72')](_0x357360[_0x3d0b('0x73')]);for(var _0x1f3346=0x0;_0x1f3346<_0x1b04af['length'];_0x1f3346+=0x1){_0x532ebf=_0x1b04af[_0x1f3346][_0x3d0b('0x74')]?_0x304882[_0x1b04af[_0x1f3346]['MetricId']][_0x3d0b('0x75')]:_0x1b04af[_0x1f3346][_0x3d0b('0x6a')];_0x532ebf=_0x1b04af[_0x1f3346][_0x3d0b('0x76')]?_[_0x3d0b('0x77')](_0x4d43c8[_0x1b04af[_0x1f3346]['function']],'%s',_0x532ebf):_0x532ebf;_0x532ebf=_0x1b04af[_0x1f3346][_0x3d0b('0x78')]?_[_0x3d0b('0x77')](_0x5419c6[_0x1b04af[_0x1f3346][_0x3d0b('0x78')]],'%s',_0x532ebf):_0x532ebf;if(_0x1b04af[_0x1f3346][_0x3d0b('0x79')]){_0x534d6a['group'](_0x532ebf);}_0x1b04af[_0x1f3346][_0x3d0b('0x7a')]&&_0x534d6a[_0x3d0b('0x3c')](_0x532ebf,_0x1b04af[_0x1f3346][_0x3d0b('0x7a')]===_0x3d0b('0x7b')?![]:!![]);_0x534d6a[_0x3d0b('0x6a')](_0x532ebf,_0x1b04af[_0x1f3346][_0x3d0b('0xa3')]||_0x532ebf);}if(_0x357360['joins']){_0x357360[_0x3d0b('0x7d')]=JSON['parse'](_0x357360['joins']);for(var _0x4ae731=0x0;_0x4ae731<_0x357360[_0x3d0b('0x7d')][_0x3d0b('0x3a')];_0x4ae731+=0x1){if(_0x357360['joins'][_0x4ae731]['type']&&_[_0x3d0b('0x63')](_0x38c4e2,_0x357360[_0x3d0b('0x7d')][_0x4ae731][_0x3d0b('0x42')])&&_0x357360[_0x3d0b('0x7d')][_0x4ae731][_0x3d0b('0x7e')]&&_0x357360['joins'][_0x4ae731][_0x3d0b('0x7f')]&&_0x357360['joins'][_0x4ae731]['foreignKey']){_0x534d6a[_0x357360[_0x3d0b('0x7d')][_0x4ae731][_0x3d0b('0x42')]](_0x357360[_0x3d0b('0x7d')][_0x4ae731][_0x3d0b('0x7f')],null,util[_0x3d0b('0x78')](_0x3d0b('0x81'),_0x357360[_0x3d0b('0x73')],_0x357360[_0x3d0b('0x7d')][_0x4ae731][_0x3d0b('0x7e')],_0x357360['joins'][_0x4ae731][_0x3d0b('0x7f')],_0x357360[_0x3d0b('0x7d')][_0x4ae731][_0x3d0b('0x80')]));}}}if(_0x357360[_0x3d0b('0x82')]){_0x357360[_0x3d0b('0x82')]=JSON[_0x3d0b('0x7c')](_0x357360[_0x3d0b('0x82')]);_0x534d6a[_0x3d0b('0x3e')](_0x128234(_0x357360['conditions'][_0x3d0b('0x69')]));}_0x55e661=_0x534d6a[_0x3d0b('0x83')]();_0x534d6a[_0x3d0b('0x1e')](_0x45c3a5);_0x534d6a[_0x3d0b('0x1c')](0x0);logger[_0x3d0b('0x84')](_0x3d0b('0x85'),_0x534d6a[_0x3d0b('0x86')]());return dbH['sequelize'][_0x3d0b('0x34')](_0x534d6a[_0x3d0b('0x86')](),{'type':dbH[_0x3d0b('0x87')][_0x3d0b('0x88')]['SELECT']});}})['then'](function(){return{'sql':_0x55e661[_0x3d0b('0x86')]()};})[_0x3d0b('0x24')](respondWithResult(_0x261660,null))[_0x3d0b('0x48')](handleError(_0x261660,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff