// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x225f=['../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','dbH','sendStatus','status','end','offset','undefined','limit','count','Content-Range','json','reject','save','update','destroy','then','get','UserProfileResource','stack','name','send','index','map','AnalyticCustomReport','rawAttributes','model','query','keys','filters','attributes','intersection','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','type','VIRTUAL','options','includeAll','findAll','rows','catch','show','params','include','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','find','userProfileId','autoAssociation','CustomReports','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','preview','join','left_join','right_join','cross_join','SUM(%s)','COUNT(%s)','MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','DATE(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','rules','operator','group','field','condition','value','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','select','from','table','MetricId','metric','function','format','groupBy','orderBy','DESC','alias','joins','parse','parentKey','foreignTable','%s.%s\x20=\x20%s.%s','foreignKey','conditions','clone','debug','Limited\x20Query:','sequelize','toString','QueryTypes','SELECT','GROUP_CONCAT(%s)','HOUR(%s)','IS\x20NOT\x20EMPTY','replace','output','web','fullPath','%s-%s.%s','randomstring','generate','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','Run\x20Query:','fork','savename','countTable','COUNT(*)','run','runReport','COUNT(DISTINCT\x20%s)','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','path','to-csv','ejs','fs-extra','lodash','jsforce','desk.js','querystring','../../components/auth/service','../../components/parsers/qs'];(function(_0x4ce028,_0x526d4b){var _0x583d0c=function(_0x874178){while(--_0x874178){_0x4ce028['push'](_0x4ce028['shift']());}};_0x583d0c(++_0x526d4b);}(_0x225f,0x94));var _0xf225=function(_0x3995eb,_0x3aee63){_0x3995eb=_0x3995eb-0x0;var _0x2580c3=_0x225f[_0x3995eb];return _0x2580c3;};'use strict';var emlformat=require(_0xf225('0x0'));var rimraf=require(_0xf225('0x1'));var zipdir=require(_0xf225('0x2'));var jsonpatch=require(_0xf225('0x3'));var rp=require(_0xf225('0x4'));var moment=require('moment');var BPromise=require(_0xf225('0x5'));var Mustache=require(_0xf225('0x6'));var util=require(_0xf225('0x7'));var path=require(_0xf225('0x8'));var sox=require('sox');var csv=require(_0xf225('0x9'));var ejs=require(_0xf225('0xa'));var fs=require('fs');var fs_extra=require(_0xf225('0xb'));var _=require(_0xf225('0xc'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0xf225('0xd'));var deskjs=require(_0xf225('0xe'));var toCsv=require('to-csv');var querystring=require(_0xf225('0xf'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0xf225('0x10'));var qs=require(_0xf225('0x11'));var as=require(_0xf225('0x12'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xf225('0x13'))(_0xf225('0x14'));var utils=require(_0xf225('0x15'));var config=require(_0xf225('0x16'));var licenseUtil=require(_0xf225('0x17'));var db=require('../../mysqldb')['db'];var dbH=require(_0xf225('0x18'))[_0xf225('0x19')];function respondWithStatusCode(_0x3a69b9,_0x4fbbc1){_0x4fbbc1=_0x4fbbc1||0xcc;return function(_0x13df7f){if(_0x13df7f){return _0x3a69b9[_0xf225('0x1a')](_0x4fbbc1);}return _0x3a69b9[_0xf225('0x1b')](_0x4fbbc1)[_0xf225('0x1c')]();};}function respondWithResult(_0x911ff2,_0x4ba8ee){_0x4ba8ee=_0x4ba8ee||0xc8;return function(_0x4ee79e){if(_0x4ee79e){return _0x911ff2[_0xf225('0x1b')](_0x4ba8ee)['json'](_0x4ee79e);}};}function respondWithFilteredResult(_0x4a182a,_0x54e9b5){return function(_0xa1c554){if(_0xa1c554){var _0x68e3e7=typeof _0x54e9b5[_0xf225('0x1d')]===_0xf225('0x1e')&&typeof _0x54e9b5[_0xf225('0x1f')]===_0xf225('0x1e');var _0x24242a=_0xa1c554[_0xf225('0x20')];var _0x1e2447=_0x68e3e7?0x0:_0x54e9b5[_0xf225('0x1d')];var _0x2482e7=_0x68e3e7?_0xa1c554['count']:_0x54e9b5[_0xf225('0x1d')]+_0x54e9b5[_0xf225('0x1f')];var _0x18c332;if(_0x2482e7>=_0x24242a){_0x2482e7=_0x24242a;_0x18c332=0xc8;}else{_0x18c332=0xce;}_0x4a182a['status'](_0x18c332);return _0x4a182a['set'](_0xf225('0x21'),_0x1e2447+'-'+_0x2482e7+'/'+_0x24242a)[_0xf225('0x22')](_0xa1c554);}return null;};}function patchUpdates(_0xeddc02){return function(_0x4d2bbb){try{jsonpatch['apply'](_0x4d2bbb,_0xeddc02,!![]);}catch(_0x2c20ef){return BPromise[_0xf225('0x23')](_0x2c20ef);}return _0x4d2bbb[_0xf225('0x24')]();};}function saveUpdates(_0x138449,_0x6cc262){return function(_0x5c2fff){if(_0x5c2fff){return _0x5c2fff[_0xf225('0x25')](_0x138449)['then'](function(_0x1b94fc){return _0x1b94fc;});}return null;};}function removeEntity(_0x1e761b,_0x310405){return function(_0x1b2610){if(_0x1b2610){return _0x1b2610[_0xf225('0x26')]()[_0xf225('0x27')](function(){var _0x10b1ef=_0x1b2610[_0xf225('0x28')]({'plain':!![]});var _0x1087ae='CustomReports';return db[_0xf225('0x29')][_0xf225('0x26')]({'where':{'type':_0x1087ae,'resourceId':_0x10b1ef['id']}})[_0xf225('0x27')](function(){return _0x1b2610;});})[_0xf225('0x27')](function(){_0x1e761b['status'](0xcc)[_0xf225('0x1c')]();});}};}function handleEntityNotFound(_0x5322e4,_0x115258){return function(_0x460551){if(!_0x460551){_0x5322e4[_0xf225('0x1a')](0x194);}return _0x460551;};}function handleError(_0x219c5c,_0x157da4){_0x157da4=_0x157da4||0x1f4;return function(_0x46285b){logger['error'](_0x46285b[_0xf225('0x2a')]);if(_0x46285b[_0xf225('0x2b')]){delete _0x46285b[_0xf225('0x2b')];}_0x219c5c[_0xf225('0x1b')](_0x157da4)[_0xf225('0x2c')](_0x46285b);};}exports[_0xf225('0x2d')]=function(_0x5b3dbc,_0x3b0486){var _0x4d764b={},_0x36a4c0={},_0x41934a={'count':0x0,'rows':[]};var _0x349221=_[_0xf225('0x2e')](db[_0xf225('0x2f')][_0xf225('0x30')],function(_0x22e516){return{'name':_0x22e516['fieldName'],'type':_0x22e516['type']['key']};});_0x36a4c0[_0xf225('0x31')]=_[_0xf225('0x2e')](_0x349221,'name');_0x36a4c0[_0xf225('0x32')]=_[_0xf225('0x33')](_0x5b3dbc[_0xf225('0x32')]);_0x36a4c0[_0xf225('0x34')]=_['intersection'](_0x36a4c0['model'],_0x36a4c0[_0xf225('0x32')]);_0x4d764b[_0xf225('0x35')]=_[_0xf225('0x36')](_0x36a4c0[_0xf225('0x31')],qs[_0xf225('0x37')](_0x5b3dbc['query'][_0xf225('0x37')]));_0x4d764b['attributes']=_0x4d764b[_0xf225('0x35')][_0xf225('0x38')]?_0x4d764b[_0xf225('0x35')]:_0x36a4c0[_0xf225('0x31')];if(!_0x5b3dbc[_0xf225('0x32')][_0xf225('0x39')](_0xf225('0x3a'))){_0x4d764b[_0xf225('0x1f')]=qs[_0xf225('0x1f')](_0x5b3dbc['query'][_0xf225('0x1f')]);_0x4d764b[_0xf225('0x1d')]=qs[_0xf225('0x1d')](_0x5b3dbc['query']['offset']);}_0x4d764b[_0xf225('0x3b')]=qs['sort'](_0x5b3dbc[_0xf225('0x32')][_0xf225('0x3c')]);_0x4d764b[_0xf225('0x3d')]=qs[_0xf225('0x34')](_[_0xf225('0x3e')](_0x5b3dbc[_0xf225('0x32')],_0x36a4c0[_0xf225('0x34')]),_0x349221);if(_0x5b3dbc['query'][_0xf225('0x3f')]){_0x4d764b['where']=_[_0xf225('0x40')](_0x4d764b[_0xf225('0x3d')],{'$or':_[_0xf225('0x2e')](_0x349221,function(_0x531aed){if(_0x531aed[_0xf225('0x41')]!==_0xf225('0x42')){var _0x4f5ea0={};_0x4f5ea0[_0x531aed['name']]={'$like':'%'+_0x5b3dbc[_0xf225('0x32')][_0xf225('0x3f')]+'%'};return _0x4f5ea0;}})});}_0x4d764b=_[_0xf225('0x40')]({},_0x4d764b,_0x5b3dbc[_0xf225('0x43')]);var _0x24ba5e={'where':_0x4d764b['where']};return db[_0xf225('0x2f')][_0xf225('0x20')](_0x24ba5e)[_0xf225('0x27')](function(_0x297fdd){_0x41934a['count']=_0x297fdd;if(_0x5b3dbc[_0xf225('0x32')][_0xf225('0x44')]){_0x4d764b['include']=[{'all':!![]}];}return db[_0xf225('0x2f')][_0xf225('0x45')](_0x4d764b);})[_0xf225('0x27')](function(_0x54cae0){_0x41934a[_0xf225('0x46')]=_0x54cae0;return _0x41934a;})[_0xf225('0x27')](respondWithFilteredResult(_0x3b0486,_0x4d764b))[_0xf225('0x47')](handleError(_0x3b0486,null));};exports[_0xf225('0x48')]=function(_0x4aba24,_0xe9adb0){var _0x52c5f3={'raw':![],'where':{'id':_0x4aba24[_0xf225('0x49')]['id']}},_0x40138e={};_0x40138e[_0xf225('0x31')]=_[_0xf225('0x33')](db['AnalyticCustomReport'][_0xf225('0x30')]);_0x40138e['query']=_[_0xf225('0x33')](_0x4aba24[_0xf225('0x32')]);_0x40138e[_0xf225('0x34')]=_[_0xf225('0x36')](_0x40138e[_0xf225('0x31')],_0x40138e[_0xf225('0x32')]);_0x52c5f3[_0xf225('0x35')]=_[_0xf225('0x36')](_0x40138e[_0xf225('0x31')],qs[_0xf225('0x37')](_0x4aba24['query'][_0xf225('0x37')]));_0x52c5f3[_0xf225('0x35')]=_0x52c5f3[_0xf225('0x35')][_0xf225('0x38')]?_0x52c5f3[_0xf225('0x35')]:_0x40138e['model'];if(_0x4aba24['query'][_0xf225('0x44')]){_0x52c5f3[_0xf225('0x4a')]=[{'all':!![]}];}_0x52c5f3=_[_0xf225('0x40')]({},_0x52c5f3,_0x4aba24[_0xf225('0x43')]);return db[_0xf225('0x2f')]['find'](_0x52c5f3)['then'](handleEntityNotFound(_0xe9adb0,null))['then'](respondWithResult(_0xe9adb0,null))[_0xf225('0x47')](handleError(_0xe9adb0,null));};exports[_0xf225('0x4b')]=function(_0x393f16,_0x4e0695){return db[_0xf225('0x2f')][_0xf225('0x4b')](_0x393f16[_0xf225('0x4c')],{})[_0xf225('0x27')](function(_0x2cb68a){var _0x3fc7a2=_0x393f16[_0xf225('0x4d')]['get']({'plain':!![]});if(!_0x3fc7a2)throw new Error(_0xf225('0x4e'));if(_0x3fc7a2[_0xf225('0x4f')]===_0xf225('0x4d')){var _0x47ba1b=_0x2cb68a[_0xf225('0x28')]({'plain':!![]});var _0x19032d='Reports';return db[_0xf225('0x50')][_0xf225('0x51')]({'where':{'name':_0x19032d,'userProfileId':_0x3fc7a2[_0xf225('0x52')]},'raw':!![]})[_0xf225('0x27')](function(_0xe0515a){if(_0xe0515a&&_0xe0515a[_0xf225('0x53')]===0x0){return db[_0xf225('0x29')]['create']({'name':_0x47ba1b[_0xf225('0x2b')],'resourceId':_0x47ba1b['id'],'type':_0xf225('0x54'),'sectionId':_0xe0515a['id']},{})[_0xf225('0x27')](function(){return _0x2cb68a;});}else{return _0x2cb68a;}})[_0xf225('0x47')](function(_0x277009){logger[_0xf225('0x55')](_0xf225('0x56'),_0x277009);throw _0x277009;});}return _0x2cb68a;})[_0xf225('0x27')](respondWithResult(_0x4e0695,0xc9))[_0xf225('0x47')](handleError(_0x4e0695,null));};exports['update']=function(_0x24f660,_0x2a0dac){if(_0x24f660[_0xf225('0x4c')]['id']){delete _0x24f660['body']['id'];}return db[_0xf225('0x2f')]['find']({'where':{'id':_0x24f660[_0xf225('0x49')]['id']}})[_0xf225('0x27')](handleEntityNotFound(_0x2a0dac,null))[_0xf225('0x27')](saveUpdates(_0x24f660['body'],null))[_0xf225('0x27')](respondWithResult(_0x2a0dac,null))[_0xf225('0x47')](handleError(_0x2a0dac,null));};exports[_0xf225('0x26')]=function(_0x2f8fc5,_0x2a5df8){return db[_0xf225('0x2f')][_0xf225('0x51')]({'where':{'id':_0x2f8fc5['params']['id']}})[_0xf225('0x27')](handleEntityNotFound(_0x2a5df8,null))[_0xf225('0x27')](removeEntity(_0x2a5df8,null))['catch'](handleError(_0x2a5df8,null));};exports[_0xf225('0x57')]=function(_0x5955d5,_0x577c3f){var _0x39f878=0xa;var _0x5f1b45=[_0xf225('0x58'),_0xf225('0x59'),_0xf225('0x5a'),_0xf225('0x5b')];var _0x3d527f={'SUM':_0xf225('0x5c'),'COUNT':_0xf225('0x5d'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0xf225('0x5e'),'MIN':_0xf225('0x5f'),'AVG':_0xf225('0x60'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0xf225('0x61'),'GROUP_CONCAT DESC':_0xf225('0x62')};var _0xc63e7b={'SEC_TO_TIME':_0xf225('0x63'),'DATE':_0xf225('0x64'),'HOUR':'HOUR(%s)','ROUND':_0xf225('0x65'),'UNIX_TIMESTAMP':_0xf225('0x66')};var _0x4f6ad0=function(_0x1bb548){return!_[_0xf225('0x67')]([_0xf225('0x68'),_0xf225('0x69'),'IS\x20EMPTY','IS\x20NOT\x20EMPTY'],_0x1bb548);};var _0x591767=function(_0x108e91){if(!_0x108e91||!_0x108e91[_0xf225('0x6a')]['length']){return'';}for(var _0x31244c='(',_0x1cd0e9=0x0;_0x1cd0e9<_0x108e91['rules'][_0xf225('0x38')];_0x1cd0e9+=0x1){_0x1cd0e9>0x0&&(_0x31244c+='\x20'+_0x108e91[_0xf225('0x6b')]+'\x20');_0x31244c+=_0x108e91['rules'][_0x1cd0e9][_0xf225('0x6c')]?_0x591767(_0x108e91[_0xf225('0x6a')][_0x1cd0e9][_0xf225('0x6c')]):_0x108e91[_0xf225('0x6a')][_0x1cd0e9][_0xf225('0x6d')]+'\x20'+_0x108e91[_0xf225('0x6a')][_0x1cd0e9][_0xf225('0x6e')]+(_0x4f6ad0(_0x108e91[_0xf225('0x6a')][_0x1cd0e9][_0xf225('0x6e')])?'\x20'+_0x108e91[_0xf225('0x6a')][_0x1cd0e9][_0xf225('0x6f')]:'');}return _0x31244c+')';};var _0x4e895e={'where':{'id':_0x5955d5['params']['id']}},_0x54f47b,_0x353dc8,_0x2124d4,_0x287273,_0x3354a8;_0x4e895e=_['merge']({},_0x4e895e,_0x5955d5[_0xf225('0x43')]);return db['AnalyticCustomReport'][_0xf225('0x51')](_0x4e895e)[_0xf225('0x27')](function(_0x5deb2d){if(_0x5deb2d){_0x54f47b=_0x5deb2d;return _0x5deb2d[_0xf225('0x70')]();}return null;})['then'](function(_0x25fe43){if(_0x25fe43){if(!_0x25fe43['length']){throw new db[(_0xf225('0x71'))][(_0xf225('0x72'))](_0xf225('0x73'),0x193);}_0x353dc8=_0x25fe43;return db[_0xf225('0x74')][_0xf225('0x45')]({'raw':!![]});}return null;})[_0xf225('0x27')](function(_0x6de756){if(_0x6de756){_0x2124d4=_[_0xf225('0x75')](_0x6de756,'id');var _0x535ea6;var _0x21add6=squel[_0xf225('0x76')]();_0x21add6[_0xf225('0x77')](_0x54f47b[_0xf225('0x78')]);for(var _0x22f5e5=0x0;_0x22f5e5<_0x353dc8[_0xf225('0x38')];_0x22f5e5+=0x1){_0x535ea6=_0x353dc8[_0x22f5e5][_0xf225('0x79')]?_0x2124d4[_0x353dc8[_0x22f5e5][_0xf225('0x79')]][_0xf225('0x7a')]:_0x353dc8[_0x22f5e5][_0xf225('0x6d')];_0x535ea6=_0x353dc8[_0x22f5e5]['function']?_['replace'](_0x3d527f[_0x353dc8[_0x22f5e5][_0xf225('0x7b')]],'%s',_0x535ea6):_0x535ea6;_0x535ea6=_0x353dc8[_0x22f5e5][_0xf225('0x7c')]?_['replace'](_0xc63e7b[_0x353dc8[_0x22f5e5][_0xf225('0x7c')]],'%s',_0x535ea6):_0x535ea6;if(_0x353dc8[_0x22f5e5][_0xf225('0x7d')]){_0x21add6['group'](_0x535ea6);}_0x353dc8[_0x22f5e5][_0xf225('0x7e')]&&_0x21add6[_0xf225('0x3b')](_0x535ea6,_0x353dc8[_0x22f5e5][_0xf225('0x7e')]===_0xf225('0x7f')?![]:!![]);_0x21add6[_0xf225('0x6d')](_0x535ea6,_0x353dc8[_0x22f5e5][_0xf225('0x80')]||_0x535ea6);}if(_0x54f47b[_0xf225('0x81')]){_0x54f47b[_0xf225('0x81')]=JSON[_0xf225('0x82')](_0x54f47b[_0xf225('0x81')]);for(var _0x3d8ee6=0x0;_0x3d8ee6<_0x54f47b[_0xf225('0x81')][_0xf225('0x38')];_0x3d8ee6+=0x1){if(_0x54f47b[_0xf225('0x81')][_0x3d8ee6]['type']&&_['includes'](_0x5f1b45,_0x54f47b[_0xf225('0x81')][_0x3d8ee6][_0xf225('0x41')])&&_0x54f47b[_0xf225('0x81')][_0x3d8ee6][_0xf225('0x83')]&&_0x54f47b['joins'][_0x3d8ee6]['foreignTable']&&_0x54f47b['joins'][_0x3d8ee6]['foreignKey']){_0x21add6[_0x54f47b[_0xf225('0x81')][_0x3d8ee6]['type']](_0x54f47b[_0xf225('0x81')][_0x3d8ee6][_0xf225('0x84')],null,util[_0xf225('0x7c')](_0xf225('0x85'),_0x54f47b[_0xf225('0x78')],_0x54f47b[_0xf225('0x81')][_0x3d8ee6][_0xf225('0x83')],_0x54f47b[_0xf225('0x81')][_0x3d8ee6][_0xf225('0x84')],_0x54f47b[_0xf225('0x81')][_0x3d8ee6][_0xf225('0x86')]));}}}if(_0x54f47b[_0xf225('0x87')]){_0x54f47b[_0xf225('0x87')]=JSON['parse'](_0x54f47b[_0xf225('0x87')]);_0x21add6[_0xf225('0x3d')](_0x591767(_0x54f47b[_0xf225('0x87')][_0xf225('0x6c')]));}_0x3354a8=_0x21add6[_0xf225('0x88')]();_0x21add6[_0xf225('0x1f')](_0x39f878);_0x21add6[_0xf225('0x1d')](0x0);logger[_0xf225('0x89')](_0xf225('0x8a'),_0x21add6['toString']());return dbH[_0xf225('0x8b')][_0xf225('0x32')](_0x21add6[_0xf225('0x8c')](),{'type':dbH['sequelize'][_0xf225('0x8d')][_0xf225('0x8e')]});}})[_0xf225('0x27')](respondWithResult(_0x577c3f,null))[_0xf225('0x47')](handleError(_0x577c3f,null));};function runReport(_0x4509d1,_0x40c0d8,_0x5333c2){var _0x40a4b4=_0x40c0d8[_0xf225('0x2b')];var _0x29a3ae=0xa;var _0x27467=[_0xf225('0x58'),_0xf225('0x59'),'right_join',_0xf225('0x5b')];var _0x246e07={'SUM':_0xf225('0x5c'),'COUNT':_0xf225('0x5d'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0xf225('0x5e'),'MIN':_0xf225('0x5f'),'AVG':_0xf225('0x60'),'GROUP_CONCAT':_0xf225('0x8f'),'GROUP_CONCAT ASC':_0xf225('0x61'),'GROUP_CONCAT DESC':_0xf225('0x62')};var _0x245bba={'SEC_TO_TIME':_0xf225('0x63'),'DATE':_0xf225('0x64'),'HOUR':_0xf225('0x90'),'ROUND':_0xf225('0x65'),'UNIX_TIMESTAMP':_0xf225('0x66')};var _0x38ca8e=function(_0x545203){return!_['includes']([_0xf225('0x68'),_0xf225('0x69'),'IS\x20EMPTY',_0xf225('0x91')],_0x545203);};var _0x13edfa=function(_0x194443){if(!_0x194443||!_0x194443[_0xf225('0x6a')][_0xf225('0x38')]){return'';}for(var _0x4631cc='(',_0x348292=0x0;_0x348292<_0x194443[_0xf225('0x6a')][_0xf225('0x38')];_0x348292+=0x1){_0x348292>0x0&&(_0x4631cc+='\x20'+_0x194443[_0xf225('0x6b')]+'\x20');_0x4631cc+=_0x194443[_0xf225('0x6a')][_0x348292][_0xf225('0x6c')]?_0x13edfa(_0x194443['rules'][_0x348292][_0xf225('0x6c')]):_0x194443[_0xf225('0x6a')][_0x348292]['field']+'\x20'+_0x194443[_0xf225('0x6a')][_0x348292][_0xf225('0x6e')]+(_0x38ca8e(_0x194443['rules'][_0x348292][_0xf225('0x6e')])?'\x20'+_0x194443[_0xf225('0x6a')][_0x348292][_0xf225('0x6f')]:'');}return _0x4631cc+')';};var _0xbf447d={'where':{'id':_0x4509d1['id']}},_0x4207b7,_0x41b90d,_0x11a017,_0x4c098f,_0x114754;_0xbf447d=_['merge']({},_0xbf447d,_0x5333c2);return db[_0xf225('0x2f')][_0xf225('0x51')](_0xbf447d)['then'](function(_0x4fa74e){if(_0x4fa74e){_0x4207b7=_0x4fa74e;return _0x4fa74e[_0xf225('0x70')]();}return null;})[_0xf225('0x27')](function(_0x5f37e4){if(_0x5f37e4){if(!_0x5f37e4[_0xf225('0x38')]){throw new db[(_0xf225('0x71'))]['ValidationErrorItem'](_0xf225('0x73'),0x193);}_0x41b90d=_0x5f37e4;return db['AnalyticMetric'][_0xf225('0x45')]({'raw':!![]});}return null;})[_0xf225('0x27')](function(_0x5b4498){if(_0x5b4498){_0x11a017=_[_0xf225('0x75')](_0x5b4498,'id');var _0x65559b;var _0x19992b=squel[_0xf225('0x76')]();_0x19992b[_0xf225('0x77')](_0x4207b7[_0xf225('0x78')]);for(var _0x2d001c=0x0;_0x2d001c<_0x41b90d[_0xf225('0x38')];_0x2d001c+=0x1){_0x65559b=_0x41b90d[_0x2d001c][_0xf225('0x79')]?_0x11a017[_0x41b90d[_0x2d001c]['MetricId']]['metric']:_0x41b90d[_0x2d001c][_0xf225('0x6d')];_0x65559b=_0x41b90d[_0x2d001c][_0xf225('0x7b')]?_[_0xf225('0x92')](_0x246e07[_0x41b90d[_0x2d001c][_0xf225('0x7b')]],'%s',_0x65559b):_0x65559b;_0x65559b=_0x41b90d[_0x2d001c]['format']?_['replace'](_0x245bba[_0x41b90d[_0x2d001c][_0xf225('0x7c')]],'%s',_0x65559b):_0x65559b;if(_0x41b90d[_0x2d001c]['groupBy']){_0x19992b[_0xf225('0x6c')](_0x65559b);}_0x41b90d[_0x2d001c][_0xf225('0x7e')]&&_0x19992b[_0xf225('0x3b')](_0x65559b,_0x41b90d[_0x2d001c][_0xf225('0x7e')]==='DESC'?![]:!![]);_0x19992b[_0xf225('0x6d')](_0x65559b,_0x41b90d[_0x2d001c][_0xf225('0x80')]||_0x65559b);}if(_0x4207b7[_0xf225('0x81')]){_0x4207b7[_0xf225('0x81')]=JSON['parse'](_0x4207b7[_0xf225('0x81')]);for(var _0xa4bc0=0x0;_0xa4bc0<_0x4207b7['joins'][_0xf225('0x38')];_0xa4bc0+=0x1){if(_0x4207b7[_0xf225('0x81')][_0xa4bc0][_0xf225('0x41')]&&_['includes'](_0x27467,_0x4207b7[_0xf225('0x81')][_0xa4bc0][_0xf225('0x41')])&&_0x4207b7[_0xf225('0x81')][_0xa4bc0][_0xf225('0x83')]&&_0x4207b7[_0xf225('0x81')][_0xa4bc0]['foreignTable']&&_0x4207b7[_0xf225('0x81')][_0xa4bc0]['foreignKey']){_0x19992b[_0x4207b7[_0xf225('0x81')][_0xa4bc0][_0xf225('0x41')]](_0x4207b7[_0xf225('0x81')][_0xa4bc0][_0xf225('0x84')],null,util[_0xf225('0x7c')](_0xf225('0x85'),_0x4207b7['table'],_0x4207b7[_0xf225('0x81')][_0xa4bc0]['parentKey'],_0x4207b7[_0xf225('0x81')][_0xa4bc0][_0xf225('0x84')],_0x4207b7[_0xf225('0x81')][_0xa4bc0][_0xf225('0x86')]));}}}if(_0x4207b7[_0xf225('0x87')]){_0x4207b7[_0xf225('0x87')]=JSON[_0xf225('0x82')](_0x4207b7['conditions']);_0x19992b[_0xf225('0x3d')](_0x13edfa(_0x4207b7[_0xf225('0x87')][_0xf225('0x6c')]));}_0x114754=_0x19992b[_0xf225('0x88')]();_0x19992b[_0xf225('0x1f')](_0x29a3ae);_0x19992b[_0xf225('0x1d')](0x0);return;}})[_0xf225('0x27')](function(){if(_0x40c0d8[_0xf225('0x93')]===_0xf225('0x94')){return null;}var _0x1a7e82=_[_0xf225('0x40')](_0x40c0d8,{'name':_0x40c0d8[_0xf225('0x95')]||_0x40c0d8[_0xf225('0x2b')]||_0x4207b7[_0xf225('0x2b')],'basename':_0x40a4b4,'savename':util['format'](_0xf225('0x96'),_0x40c0d8[_0xf225('0x2b')]||_0x4207b7[_0xf225('0x2b')],require(_0xf225('0x97'))[_0xf225('0x98')](0x4),_0x40c0d8[_0xf225('0x93')]||'csv'),'reportId':_0x4207b7['id'],'reportType':'custom'});return db[_0xf225('0x99')][_0xf225('0x4b')](_0x1a7e82,{'raw':!![]});})['then'](function(_0x10f5f7){if(_0x4207b7['table']===_0xf225('0x9a')){_0x114754[_0xf225('0x3d')](_0x4207b7[_0xf225('0x78')]+_0xf225('0x9b'),_0x40c0d8['startDate'],_0x40c0d8[_0xf225('0x9c')]);}else{_0x114754[_0xf225('0x3d')](_0x4207b7['table']+_0xf225('0x9d'),_0x40c0d8['startDate'],_0x40c0d8['endDate']);}if(_0x10f5f7){logger['info'](_0xf225('0x9e'),_0x114754[_0xf225('0x8c')]());require('child_process')[_0xf225('0x9f')](path['join'](__dirname,'../../components/export/',_0x10f5f7['output']),[_0x10f5f7['id'],_0x114754[_0xf225('0x8c')](),path[_0xf225('0x58')](__dirname,'../../files/reports',_0x10f5f7[_0xf225('0xa0')]),_0x40a4b4]);return _0x10f5f7;}else{var _0x2f5184=squel['select']();_0x2f5184[_0xf225('0x77')]('('+_0x114754[_0xf225('0x8c')]()+')',_0xf225('0xa1'));_0x2f5184[_0xf225('0x6d')](_0xf225('0xa2'),_0xf225('0x20'));_0x114754[_0xf225('0x1f')](_0x40c0d8[_0xf225('0x1f')]||_0x29a3ae);_0x114754[_0xf225('0x1d')](_0x40c0d8[_0xf225('0x1d')]||0x0);return dbH['sequelize'][_0xf225('0x32')](_0x2f5184['toString'](),{'type':dbH[_0xf225('0x8b')][_0xf225('0x8d')]['SELECT']})['then'](function(_0x220e75){if(!_0x220e75['length']){_0x4c098f=0x0;}else{_0x4c098f=_0x220e75[0x0][_0xf225('0x20')]||0x0;}return dbH[_0xf225('0x8b')][_0xf225('0x32')](_0x114754[_0xf225('0x8c')](),{'type':dbH[_0xf225('0x8b')][_0xf225('0x8d')][_0xf225('0x8e')]});})[_0xf225('0x27')](function(_0xec0c9a){return{'rows':_0xec0c9a||[],'count':_0x4c098f};});}});}exports[_0xf225('0xa3')]=function(_0x320a8f,_0x2d8060){return runReport(_0x320a8f['params'],_0x320a8f[_0xf225('0x32')],_0x320a8f[_0xf225('0x43')])[_0xf225('0x27')](respondWithResult(_0x2d8060,null))['catch'](handleError(_0x2d8060,null));};exports[_0xf225('0xa4')]=runReport;exports[_0xf225('0x32')]=function(_0x107cd0,_0x3f350d){var _0x1332b8=0xa;var _0x27bf8c=[_0xf225('0x58'),_0xf225('0x59'),_0xf225('0x5a'),_0xf225('0x5b')];var _0x646585={'SUM':_0xf225('0x5c'),'COUNT':_0xf225('0x5d'),'COUNT DISTINCT':_0xf225('0xa5'),'MAX':'MAX(%s)','MIN':_0xf225('0x5f'),'AVG':'AVG(%s)','GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0xf225('0x61'),'GROUP_CONCAT DESC':_0xf225('0x62')};var _0xc804d6={'SEC_TO_TIME':_0xf225('0x63'),'DATE':_0xf225('0x64'),'HOUR':'HOUR(%s)','ROUND':_0xf225('0x65'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x345d5f=function(_0x30889d){return!_[_0xf225('0x67')](['IS\x20NULL',_0xf225('0x69'),'IS\x20EMPTY',_0xf225('0x91')],_0x30889d);};var _0x4d1c06=function(_0x62afeb){if(!_0x62afeb||!_0x62afeb[_0xf225('0x6a')][_0xf225('0x38')]){return'';}for(var _0x2389e1='(',_0x2d2d7b=0x0;_0x2d2d7b<_0x62afeb['rules'][_0xf225('0x38')];_0x2d2d7b+=0x1){_0x2d2d7b>0x0&&(_0x2389e1+='\x20'+_0x62afeb[_0xf225('0x6b')]+'\x20');_0x2389e1+=_0x62afeb[_0xf225('0x6a')][_0x2d2d7b][_0xf225('0x6c')]?_0x4d1c06(_0x62afeb[_0xf225('0x6a')][_0x2d2d7b][_0xf225('0x6c')]):_0x62afeb[_0xf225('0x6a')][_0x2d2d7b][_0xf225('0x6d')]+'\x20'+_0x62afeb[_0xf225('0x6a')][_0x2d2d7b][_0xf225('0x6e')]+(_0x345d5f(_0x62afeb[_0xf225('0x6a')][_0x2d2d7b][_0xf225('0x6e')])?'\x20'+_0x62afeb[_0xf225('0x6a')][_0x2d2d7b][_0xf225('0x6f')]:'');}return _0x2389e1+')';};var _0xd16536={'where':{'id':_0x107cd0[_0xf225('0x49')]['id']}},_0x55813b,_0x3410f7,_0x1e1828,_0x13f743,_0x27da71;_0xd16536=_[_0xf225('0x40')]({},_0xd16536,_0x107cd0[_0xf225('0x43')]);return db[_0xf225('0x2f')][_0xf225('0x51')](_0xd16536)[_0xf225('0x27')](function(_0x9becfa){if(_0x9becfa){_0x55813b=_0x9becfa;return _0x9becfa['getFields']();}return null;})[_0xf225('0x27')](function(_0x183576){if(_0x183576){if(!_0x183576['length']){throw new db['Sequelize']['ValidationErrorItem'](_0xf225('0x73'),0x193);}_0x3410f7=_0x183576;return db[_0xf225('0x74')][_0xf225('0x45')]({'raw':!![]});}return null;})[_0xf225('0x27')](function(_0x26af8c){if(_0x26af8c){_0x1e1828=_[_0xf225('0x75')](_0x26af8c,'id');var _0x32cf0b;var _0x3a9016=squel[_0xf225('0x76')]();_0x3a9016[_0xf225('0x77')](_0x55813b[_0xf225('0x78')]);for(var _0xa00c53=0x0;_0xa00c53<_0x3410f7['length'];_0xa00c53+=0x1){_0x32cf0b=_0x3410f7[_0xa00c53]['MetricId']?_0x1e1828[_0x3410f7[_0xa00c53][_0xf225('0x79')]]['metric']:_0x3410f7[_0xa00c53][_0xf225('0x6d')];_0x32cf0b=_0x3410f7[_0xa00c53][_0xf225('0x7b')]?_[_0xf225('0x92')](_0x646585[_0x3410f7[_0xa00c53][_0xf225('0x7b')]],'%s',_0x32cf0b):_0x32cf0b;_0x32cf0b=_0x3410f7[_0xa00c53][_0xf225('0x7c')]?_['replace'](_0xc804d6[_0x3410f7[_0xa00c53][_0xf225('0x7c')]],'%s',_0x32cf0b):_0x32cf0b;if(_0x3410f7[_0xa00c53][_0xf225('0x7d')]){_0x3a9016[_0xf225('0x6c')](_0x32cf0b);}_0x3410f7[_0xa00c53]['orderBy']&&_0x3a9016[_0xf225('0x3b')](_0x32cf0b,_0x3410f7[_0xa00c53][_0xf225('0x7e')]===_0xf225('0x7f')?![]:!![]);_0x3a9016['field'](_0x32cf0b,_0x3410f7[_0xa00c53][_0xf225('0x80')]||_0x32cf0b);}if(_0x55813b['joins']){_0x55813b[_0xf225('0x81')]=JSON[_0xf225('0x82')](_0x55813b[_0xf225('0x81')]);for(var _0x366939=0x0;_0x366939<_0x55813b[_0xf225('0x81')][_0xf225('0x38')];_0x366939+=0x1){if(_0x55813b[_0xf225('0x81')][_0x366939][_0xf225('0x41')]&&_[_0xf225('0x67')](_0x27bf8c,_0x55813b[_0xf225('0x81')][_0x366939][_0xf225('0x41')])&&_0x55813b[_0xf225('0x81')][_0x366939][_0xf225('0x83')]&&_0x55813b[_0xf225('0x81')][_0x366939][_0xf225('0x84')]&&_0x55813b['joins'][_0x366939][_0xf225('0x86')]){_0x3a9016[_0x55813b['joins'][_0x366939][_0xf225('0x41')]](_0x55813b[_0xf225('0x81')][_0x366939][_0xf225('0x84')],null,util[_0xf225('0x7c')](_0xf225('0x85'),_0x55813b[_0xf225('0x78')],_0x55813b['joins'][_0x366939][_0xf225('0x83')],_0x55813b[_0xf225('0x81')][_0x366939][_0xf225('0x84')],_0x55813b[_0xf225('0x81')][_0x366939][_0xf225('0x86')]));}}}if(_0x55813b['conditions']){_0x55813b[_0xf225('0x87')]=JSON[_0xf225('0x82')](_0x55813b['conditions']);_0x3a9016[_0xf225('0x3d')](_0x4d1c06(_0x55813b['conditions'][_0xf225('0x6c')]));}_0x27da71=_0x3a9016[_0xf225('0x88')]();_0x3a9016['limit'](_0x1332b8);_0x3a9016['offset'](0x0);logger[_0xf225('0x89')](_0xf225('0x8a'),_0x3a9016[_0xf225('0x8c')]());return dbH['sequelize'][_0xf225('0x32')](_0x3a9016[_0xf225('0x8c')](),{'type':dbH[_0xf225('0x8b')]['QueryTypes'][_0xf225('0x8e')]});}})[_0xf225('0x27')](function(){return{'sql':_0x27da71[_0xf225('0x8c')]()};})[_0xf225('0x27')](respondWithResult(_0x3f350d,null))['catch'](handleError(_0x3f350d,null));};
\ No newline at end of file
+var _0x8967=['../../mysqldb','dbH','sendStatus','status','end','offset','undefined','count','limit','set','Content-Range','json','apply','reject','save','update','then','destroy','get','CustomReports','UserProfileResource','error','stack','name','send','index','map','AnalyticCustomReport','rawAttributes','fieldName','type','model','query','keys','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','merge','VIRTUAL','options','includeAll','include','rows','show','params','find','catch','create','body','user','UserProfileSection','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','join','left_join','right_join','cross_join','SUM(%s)','COUNT(%s)','MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','DATE(%s)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NOT\x20EMPTY','rules','group','field','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','findAll','keyBy','select','table','MetricId','metric','replace','function','format','groupBy','orderBy','DESC','alias','joins','parse','parentKey','foreignTable','%s.%s\x20=\x20%s.%s','foreignKey','conditions','clone','debug','Limited\x20Query:','toString','SELECT','COUNT(DISTINCT\x20%s)','IS\x20NULL','IS\x20EMPTY','operator','condition','value','web','fullPath','%s-%s.%s','randomstring','generate','output','csv','custom','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','Run\x20Query:','child_process','fork','../../components/export/','../../files/reports','savename','countTable','COUNT(*)','sequelize','QueryTypes','runReport','IS\x20NOT\x20NULL','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','jsforce','desk.js','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util'];(function(_0x4304b0,_0x2a83af){var _0x3e303a=function(_0x2df888){while(--_0x2df888){_0x4304b0['push'](_0x4304b0['shift']());}};_0x3e303a(++_0x2a83af);}(_0x8967,0x13b));var _0x7896=function(_0x39772f,_0x5605cb){_0x39772f=_0x39772f-0x0;var _0xc9edbf=_0x8967[_0x39772f];return _0xc9edbf;};'use strict';var emlformat=require(_0x7896('0x0'));var rimraf=require(_0x7896('0x1'));var zipdir=require(_0x7896('0x2'));var jsonpatch=require(_0x7896('0x3'));var rp=require(_0x7896('0x4'));var moment=require(_0x7896('0x5'));var BPromise=require(_0x7896('0x6'));var Mustache=require(_0x7896('0x7'));var util=require(_0x7896('0x8'));var path=require(_0x7896('0x9'));var sox=require(_0x7896('0xa'));var csv=require(_0x7896('0xb'));var ejs=require(_0x7896('0xc'));var fs=require('fs');var fs_extra=require(_0x7896('0xd'));var _=require('lodash');var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x7896('0xe'));var deskjs=require(_0x7896('0xf'));var toCsv=require(_0x7896('0xb'));var querystring=require(_0x7896('0x10'));var Papa=require('papaparse');var Redis=require(_0x7896('0x11'));var authService=require(_0x7896('0x12'));var qs=require(_0x7896('0x13'));var as=require(_0x7896('0x14'));var hardwareService=require(_0x7896('0x15'));var logger=require(_0x7896('0x16'))(_0x7896('0x17'));var utils=require(_0x7896('0x18'));var config=require(_0x7896('0x19'));var licenseUtil=require(_0x7896('0x1a'));var db=require(_0x7896('0x1b'))['db'];var dbH=require(_0x7896('0x1b'))[_0x7896('0x1c')];function respondWithStatusCode(_0x3c84fc,_0x1942c6){_0x1942c6=_0x1942c6||0xcc;return function(_0x26215d){if(_0x26215d){return _0x3c84fc[_0x7896('0x1d')](_0x1942c6);}return _0x3c84fc[_0x7896('0x1e')](_0x1942c6)[_0x7896('0x1f')]();};}function respondWithResult(_0x4c8213,_0x36c2d6){_0x36c2d6=_0x36c2d6||0xc8;return function(_0x54b6ae){if(_0x54b6ae){return _0x4c8213[_0x7896('0x1e')](_0x36c2d6)['json'](_0x54b6ae);}};}function respondWithFilteredResult(_0x5bb3f0,_0x5db57c){return function(_0x308263){if(_0x308263){var _0x90348f=typeof _0x5db57c[_0x7896('0x20')]==='undefined'&&typeof _0x5db57c['limit']===_0x7896('0x21');var _0x3a1821=_0x308263[_0x7896('0x22')];var _0x14375c=_0x90348f?0x0:_0x5db57c[_0x7896('0x20')];var _0x2af1d3=_0x90348f?_0x308263[_0x7896('0x22')]:_0x5db57c['offset']+_0x5db57c[_0x7896('0x23')];var _0x348295;if(_0x2af1d3>=_0x3a1821){_0x2af1d3=_0x3a1821;_0x348295=0xc8;}else{_0x348295=0xce;}_0x5bb3f0[_0x7896('0x1e')](_0x348295);return _0x5bb3f0[_0x7896('0x24')](_0x7896('0x25'),_0x14375c+'-'+_0x2af1d3+'/'+_0x3a1821)[_0x7896('0x26')](_0x308263);}return null;};}function patchUpdates(_0x1fc8a1){return function(_0x46d94a){try{jsonpatch[_0x7896('0x27')](_0x46d94a,_0x1fc8a1,!![]);}catch(_0x439029){return BPromise[_0x7896('0x28')](_0x439029);}return _0x46d94a[_0x7896('0x29')]();};}function saveUpdates(_0x1d9086,_0x510315){return function(_0x287cd6){if(_0x287cd6){return _0x287cd6[_0x7896('0x2a')](_0x1d9086)[_0x7896('0x2b')](function(_0x34c89c){return _0x34c89c;});}return null;};}function removeEntity(_0x283b12,_0x1c1018){return function(_0x2a652a){if(_0x2a652a){return _0x2a652a[_0x7896('0x2c')]()[_0x7896('0x2b')](function(){var _0x4c90e5=_0x2a652a[_0x7896('0x2d')]({'plain':!![]});var _0xbb87b0=_0x7896('0x2e');return db[_0x7896('0x2f')][_0x7896('0x2c')]({'where':{'type':_0xbb87b0,'resourceId':_0x4c90e5['id']}})[_0x7896('0x2b')](function(){return _0x2a652a;});})['then'](function(){_0x283b12[_0x7896('0x1e')](0xcc)[_0x7896('0x1f')]();});}};}function handleEntityNotFound(_0xa14a44,_0x5261dc){return function(_0x3697bf){if(!_0x3697bf){_0xa14a44[_0x7896('0x1d')](0x194);}return _0x3697bf;};}function handleError(_0xdfa8b0,_0x187f29){_0x187f29=_0x187f29||0x1f4;return function(_0x32deb9){logger[_0x7896('0x30')](_0x32deb9[_0x7896('0x31')]);if(_0x32deb9['name']){delete _0x32deb9[_0x7896('0x32')];}_0xdfa8b0['status'](_0x187f29)[_0x7896('0x33')](_0x32deb9);};}exports[_0x7896('0x34')]=function(_0x11844e,_0x48c992){var _0x5d4edf={},_0xc69d54={},_0x470f1f={'count':0x0,'rows':[]};var _0x3f3599=_[_0x7896('0x35')](db[_0x7896('0x36')][_0x7896('0x37')],function(_0xd08776){return{'name':_0xd08776[_0x7896('0x38')],'type':_0xd08776[_0x7896('0x39')]['key']};});_0xc69d54[_0x7896('0x3a')]=_['map'](_0x3f3599,_0x7896('0x32'));_0xc69d54[_0x7896('0x3b')]=_[_0x7896('0x3c')](_0x11844e['query']);_0xc69d54['filters']=_[_0x7896('0x3d')](_0xc69d54[_0x7896('0x3a')],_0xc69d54[_0x7896('0x3b')]);_0x5d4edf[_0x7896('0x3e')]=_[_0x7896('0x3d')](_0xc69d54[_0x7896('0x3a')],qs[_0x7896('0x3f')](_0x11844e[_0x7896('0x3b')][_0x7896('0x3f')]));_0x5d4edf['attributes']=_0x5d4edf[_0x7896('0x3e')][_0x7896('0x40')]?_0x5d4edf[_0x7896('0x3e')]:_0xc69d54[_0x7896('0x3a')];if(!_0x11844e[_0x7896('0x3b')][_0x7896('0x41')](_0x7896('0x42'))){_0x5d4edf[_0x7896('0x23')]=qs[_0x7896('0x23')](_0x11844e[_0x7896('0x3b')][_0x7896('0x23')]);_0x5d4edf['offset']=qs[_0x7896('0x20')](_0x11844e[_0x7896('0x3b')][_0x7896('0x20')]);}_0x5d4edf[_0x7896('0x43')]=qs[_0x7896('0x44')](_0x11844e[_0x7896('0x3b')]['sort']);_0x5d4edf[_0x7896('0x45')]=qs[_0x7896('0x46')](_[_0x7896('0x47')](_0x11844e[_0x7896('0x3b')],_0xc69d54['filters']),_0x3f3599);if(_0x11844e[_0x7896('0x3b')]['filter']){_0x5d4edf[_0x7896('0x45')]=_[_0x7896('0x48')](_0x5d4edf['where'],{'$or':_['map'](_0x3f3599,function(_0x36c029){if(_0x36c029['type']!==_0x7896('0x49')){var _0xdbdeef={};_0xdbdeef[_0x36c029['name']]={'$like':'%'+_0x11844e[_0x7896('0x3b')]['filter']+'%'};return _0xdbdeef;}})});}_0x5d4edf=_['merge']({},_0x5d4edf,_0x11844e[_0x7896('0x4a')]);var _0x478071={'where':_0x5d4edf[_0x7896('0x45')]};return db[_0x7896('0x36')]['count'](_0x478071)[_0x7896('0x2b')](function(_0x1b59db){_0x470f1f[_0x7896('0x22')]=_0x1b59db;if(_0x11844e[_0x7896('0x3b')][_0x7896('0x4b')]){_0x5d4edf[_0x7896('0x4c')]=[{'all':!![]}];}return db[_0x7896('0x36')]['findAll'](_0x5d4edf);})[_0x7896('0x2b')](function(_0x24fdc6){_0x470f1f[_0x7896('0x4d')]=_0x24fdc6;return _0x470f1f;})[_0x7896('0x2b')](respondWithFilteredResult(_0x48c992,_0x5d4edf))['catch'](handleError(_0x48c992,null));};exports[_0x7896('0x4e')]=function(_0x29f21b,_0x1d9db5){var _0x4ef3de={'raw':![],'where':{'id':_0x29f21b[_0x7896('0x4f')]['id']}},_0xed06b={};_0xed06b['model']=_[_0x7896('0x3c')](db[_0x7896('0x36')]['rawAttributes']);_0xed06b[_0x7896('0x3b')]=_[_0x7896('0x3c')](_0x29f21b[_0x7896('0x3b')]);_0xed06b['filters']=_[_0x7896('0x3d')](_0xed06b['model'],_0xed06b[_0x7896('0x3b')]);_0x4ef3de[_0x7896('0x3e')]=_['intersection'](_0xed06b[_0x7896('0x3a')],qs[_0x7896('0x3f')](_0x29f21b[_0x7896('0x3b')][_0x7896('0x3f')]));_0x4ef3de[_0x7896('0x3e')]=_0x4ef3de[_0x7896('0x3e')]['length']?_0x4ef3de['attributes']:_0xed06b['model'];if(_0x29f21b[_0x7896('0x3b')][_0x7896('0x4b')]){_0x4ef3de[_0x7896('0x4c')]=[{'all':!![]}];}_0x4ef3de=_[_0x7896('0x48')]({},_0x4ef3de,_0x29f21b[_0x7896('0x4a')]);return db[_0x7896('0x36')][_0x7896('0x50')](_0x4ef3de)[_0x7896('0x2b')](handleEntityNotFound(_0x1d9db5,null))[_0x7896('0x2b')](respondWithResult(_0x1d9db5,null))[_0x7896('0x51')](handleError(_0x1d9db5,null));};exports[_0x7896('0x52')]=function(_0x422d29,_0x4265a1){return db['AnalyticCustomReport'][_0x7896('0x52')](_0x422d29[_0x7896('0x53')],{})[_0x7896('0x2b')](function(_0x142361){var _0x2991bf=_0x422d29[_0x7896('0x54')][_0x7896('0x2d')]({'plain':!![]});if(!_0x2991bf)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x2991bf['role']==='user'){var _0x54f9e9=_0x142361['get']({'plain':!![]});var _0x50b3d5='Reports';return db[_0x7896('0x55')][_0x7896('0x50')]({'where':{'name':_0x50b3d5,'userProfileId':_0x2991bf['userProfileId']},'raw':!![]})[_0x7896('0x2b')](function(_0x24431e){if(_0x24431e&&_0x24431e[_0x7896('0x56')]===0x0){return db[_0x7896('0x2f')][_0x7896('0x52')]({'name':_0x54f9e9['name'],'resourceId':_0x54f9e9['id'],'type':_0x7896('0x2e'),'sectionId':_0x24431e['id']},{})[_0x7896('0x2b')](function(){return _0x142361;});}else{return _0x142361;}})['catch'](function(_0x3dfe78){logger[_0x7896('0x30')](_0x7896('0x57'),_0x3dfe78);throw _0x3dfe78;});}return _0x142361;})['then'](respondWithResult(_0x4265a1,0xc9))[_0x7896('0x51')](handleError(_0x4265a1,null));};exports[_0x7896('0x2a')]=function(_0xc97ebd,_0x5d9a45){if(_0xc97ebd[_0x7896('0x53')]['id']){delete _0xc97ebd['body']['id'];}return db[_0x7896('0x36')]['find']({'where':{'id':_0xc97ebd[_0x7896('0x4f')]['id']}})[_0x7896('0x2b')](handleEntityNotFound(_0x5d9a45,null))[_0x7896('0x2b')](saveUpdates(_0xc97ebd[_0x7896('0x53')],null))['then'](respondWithResult(_0x5d9a45,null))[_0x7896('0x51')](handleError(_0x5d9a45,null));};exports[_0x7896('0x2c')]=function(_0x582734,_0x5eb072){return db[_0x7896('0x36')][_0x7896('0x50')]({'where':{'id':_0x582734[_0x7896('0x4f')]['id']}})['then'](handleEntityNotFound(_0x5eb072,null))[_0x7896('0x2b')](removeEntity(_0x5eb072,null))[_0x7896('0x51')](handleError(_0x5eb072,null));};exports['preview']=function(_0x37a2bb,_0x24336c){var _0x353d10=0xa;var _0x207fe4=[_0x7896('0x58'),_0x7896('0x59'),_0x7896('0x5a'),_0x7896('0x5b')];var _0x4cd9cb={'SUM':_0x7896('0x5c'),'COUNT':_0x7896('0x5d'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x7896('0x5e'),'MIN':_0x7896('0x5f'),'AVG':_0x7896('0x60'),'GROUP_CONCAT':_0x7896('0x61'),'GROUP_CONCAT ASC':_0x7896('0x62'),'GROUP_CONCAT DESC':_0x7896('0x63')};var _0x312795={'SEC_TO_TIME':_0x7896('0x64'),'DATE':_0x7896('0x65'),'HOUR':_0x7896('0x66'),'ROUND':_0x7896('0x67'),'UNIX_TIMESTAMP':_0x7896('0x68')};var _0x3f3d2a=function(_0x443747){return!_[_0x7896('0x69')](['IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY',_0x7896('0x6a')],_0x443747);};var _0x4ad86b=function(_0x3b95d0){if(!_0x3b95d0||!_0x3b95d0[_0x7896('0x6b')][_0x7896('0x40')]){return'';}for(var _0x17c0c5='(',_0x1e4a50=0x0;_0x1e4a50<_0x3b95d0[_0x7896('0x6b')][_0x7896('0x40')];_0x1e4a50+=0x1){_0x1e4a50>0x0&&(_0x17c0c5+='\x20'+_0x3b95d0['operator']+'\x20');_0x17c0c5+=_0x3b95d0[_0x7896('0x6b')][_0x1e4a50][_0x7896('0x6c')]?_0x4ad86b(_0x3b95d0[_0x7896('0x6b')][_0x1e4a50]['group']):_0x3b95d0[_0x7896('0x6b')][_0x1e4a50][_0x7896('0x6d')]+'\x20'+_0x3b95d0[_0x7896('0x6b')][_0x1e4a50]['condition']+(_0x3f3d2a(_0x3b95d0['rules'][_0x1e4a50]['condition'])?'\x20'+_0x3b95d0[_0x7896('0x6b')][_0x1e4a50]['value']:'');}return _0x17c0c5+')';};var _0x28fb43={'where':{'id':_0x37a2bb['params']['id']}},_0x16c8fa,_0xf7ca4,_0x23fa4b,_0x5a1bf0,_0x4b368a;_0x28fb43=_['merge']({},_0x28fb43,_0x37a2bb['options']);return db[_0x7896('0x36')]['find'](_0x28fb43)['then'](function(_0x335f39){if(_0x335f39){_0x16c8fa=_0x335f39;return _0x335f39[_0x7896('0x6e')]();}return null;})['then'](function(_0x121ca9){if(_0x121ca9){if(!_0x121ca9['length']){throw new db[(_0x7896('0x6f'))][(_0x7896('0x70'))](_0x7896('0x71'),0x193);}_0xf7ca4=_0x121ca9;return db[_0x7896('0x72')][_0x7896('0x73')]({'raw':!![]});}return null;})[_0x7896('0x2b')](function(_0x2f89f1){if(_0x2f89f1){_0x23fa4b=_[_0x7896('0x74')](_0x2f89f1,'id');var _0x2959bd;var _0x2c4b8b=squel[_0x7896('0x75')]();_0x2c4b8b['from'](_0x16c8fa[_0x7896('0x76')]);for(var _0x169444=0x0;_0x169444<_0xf7ca4[_0x7896('0x40')];_0x169444+=0x1){_0x2959bd=_0xf7ca4[_0x169444][_0x7896('0x77')]?_0x23fa4b[_0xf7ca4[_0x169444]['MetricId']][_0x7896('0x78')]:_0xf7ca4[_0x169444][_0x7896('0x6d')];_0x2959bd=_0xf7ca4[_0x169444]['function']?_[_0x7896('0x79')](_0x4cd9cb[_0xf7ca4[_0x169444][_0x7896('0x7a')]],'%s',_0x2959bd):_0x2959bd;_0x2959bd=_0xf7ca4[_0x169444][_0x7896('0x7b')]?_[_0x7896('0x79')](_0x312795[_0xf7ca4[_0x169444][_0x7896('0x7b')]],'%s',_0x2959bd):_0x2959bd;if(_0xf7ca4[_0x169444][_0x7896('0x7c')]){_0x2c4b8b[_0x7896('0x6c')](_0x2959bd);}_0xf7ca4[_0x169444][_0x7896('0x7d')]&&_0x2c4b8b[_0x7896('0x43')](_0x2959bd,_0xf7ca4[_0x169444][_0x7896('0x7d')]===_0x7896('0x7e')?![]:!![]);_0x2c4b8b[_0x7896('0x6d')](_0x2959bd,_0xf7ca4[_0x169444][_0x7896('0x7f')]||_0x2959bd);}if(_0x16c8fa[_0x7896('0x80')]){_0x16c8fa['joins']=JSON[_0x7896('0x81')](_0x16c8fa[_0x7896('0x80')]);for(var _0x54d0b=0x0;_0x54d0b<_0x16c8fa[_0x7896('0x80')]['length'];_0x54d0b+=0x1){if(_0x16c8fa[_0x7896('0x80')][_0x54d0b][_0x7896('0x39')]&&_[_0x7896('0x69')](_0x207fe4,_0x16c8fa[_0x7896('0x80')][_0x54d0b][_0x7896('0x39')])&&_0x16c8fa[_0x7896('0x80')][_0x54d0b][_0x7896('0x82')]&&_0x16c8fa['joins'][_0x54d0b][_0x7896('0x83')]&&_0x16c8fa[_0x7896('0x80')][_0x54d0b]['foreignKey']){_0x2c4b8b[_0x16c8fa[_0x7896('0x80')][_0x54d0b]['type']](_0x16c8fa[_0x7896('0x80')][_0x54d0b][_0x7896('0x83')],null,util[_0x7896('0x7b')](_0x7896('0x84'),_0x16c8fa[_0x7896('0x76')],_0x16c8fa['joins'][_0x54d0b][_0x7896('0x82')],_0x16c8fa[_0x7896('0x80')][_0x54d0b][_0x7896('0x83')],_0x16c8fa[_0x7896('0x80')][_0x54d0b][_0x7896('0x85')]));}}}if(_0x16c8fa[_0x7896('0x86')]){_0x16c8fa[_0x7896('0x86')]=JSON['parse'](_0x16c8fa['conditions']);_0x2c4b8b['where'](_0x4ad86b(_0x16c8fa[_0x7896('0x86')][_0x7896('0x6c')]));}_0x4b368a=_0x2c4b8b[_0x7896('0x87')]();_0x2c4b8b[_0x7896('0x23')](_0x353d10);_0x2c4b8b['offset'](0x0);logger[_0x7896('0x88')](_0x7896('0x89'),_0x2c4b8b[_0x7896('0x8a')]());return dbH['sequelize']['query'](_0x2c4b8b['toString'](),{'type':dbH['sequelize']['QueryTypes'][_0x7896('0x8b')]});}})[_0x7896('0x2b')](respondWithResult(_0x24336c,null))['catch'](handleError(_0x24336c,null));};function runReport(_0x21ec8c,_0x363c93,_0x565049){var _0x57721d=_0x363c93[_0x7896('0x32')];var _0x29e3dc=0xa;var _0x462a3f=[_0x7896('0x58'),_0x7896('0x59'),_0x7896('0x5a'),'cross_join'];var _0x28807b={'SUM':'SUM(%s)','COUNT':_0x7896('0x5d'),'COUNT DISTINCT':_0x7896('0x8c'),'MAX':_0x7896('0x5e'),'MIN':_0x7896('0x5f'),'AVG':_0x7896('0x60'),'GROUP_CONCAT':_0x7896('0x61'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0x7896('0x63')};var _0x122285={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':'DATE(%s)','HOUR':_0x7896('0x66'),'ROUND':_0x7896('0x67'),'UNIX_TIMESTAMP':_0x7896('0x68')};var _0x4b2209=function(_0x3a781a){return!_[_0x7896('0x69')]([_0x7896('0x8d'),'IS\x20NOT\x20NULL',_0x7896('0x8e'),_0x7896('0x6a')],_0x3a781a);};var _0x223de2=function(_0x27218e){if(!_0x27218e||!_0x27218e['rules']['length']){return'';}for(var _0x36021a='(',_0x3097b3=0x0;_0x3097b3<_0x27218e[_0x7896('0x6b')][_0x7896('0x40')];_0x3097b3+=0x1){_0x3097b3>0x0&&(_0x36021a+='\x20'+_0x27218e[_0x7896('0x8f')]+'\x20');_0x36021a+=_0x27218e[_0x7896('0x6b')][_0x3097b3][_0x7896('0x6c')]?_0x223de2(_0x27218e[_0x7896('0x6b')][_0x3097b3]['group']):_0x27218e['rules'][_0x3097b3]['field']+'\x20'+_0x27218e['rules'][_0x3097b3][_0x7896('0x90')]+(_0x4b2209(_0x27218e[_0x7896('0x6b')][_0x3097b3]['condition'])?'\x20'+_0x27218e[_0x7896('0x6b')][_0x3097b3][_0x7896('0x91')]:'');}return _0x36021a+')';};var _0x53a6e9={'where':{'id':_0x21ec8c['id']}},_0x359189,_0xe24a8e,_0x36bb60,_0x177502,_0x126095;_0x53a6e9=_['merge']({},_0x53a6e9,_0x565049);return db[_0x7896('0x36')][_0x7896('0x50')](_0x53a6e9)[_0x7896('0x2b')](function(_0x313d64){if(_0x313d64){_0x359189=_0x313d64;return _0x313d64[_0x7896('0x6e')]();}return null;})[_0x7896('0x2b')](function(_0x273ca6){if(_0x273ca6){if(!_0x273ca6[_0x7896('0x40')]){throw new db[(_0x7896('0x6f'))]['ValidationErrorItem'](_0x7896('0x71'),0x193);}_0xe24a8e=_0x273ca6;return db[_0x7896('0x72')][_0x7896('0x73')]({'raw':!![]});}return null;})['then'](function(_0x1d5618){if(_0x1d5618){_0x36bb60=_[_0x7896('0x74')](_0x1d5618,'id');var _0x5995ad;var _0x28f5f2=squel[_0x7896('0x75')]();_0x28f5f2['from'](_0x359189[_0x7896('0x76')]);for(var _0x183ef8=0x0;_0x183ef8<_0xe24a8e[_0x7896('0x40')];_0x183ef8+=0x1){_0x5995ad=_0xe24a8e[_0x183ef8][_0x7896('0x77')]?_0x36bb60[_0xe24a8e[_0x183ef8]['MetricId']][_0x7896('0x78')]:_0xe24a8e[_0x183ef8][_0x7896('0x6d')];_0x5995ad=_0xe24a8e[_0x183ef8][_0x7896('0x7a')]?_[_0x7896('0x79')](_0x28807b[_0xe24a8e[_0x183ef8][_0x7896('0x7a')]],'%s',_0x5995ad):_0x5995ad;_0x5995ad=_0xe24a8e[_0x183ef8][_0x7896('0x7b')]?_[_0x7896('0x79')](_0x122285[_0xe24a8e[_0x183ef8]['format']],'%s',_0x5995ad):_0x5995ad;if(_0xe24a8e[_0x183ef8][_0x7896('0x7c')]){_0x28f5f2[_0x7896('0x6c')](_0x5995ad);}_0xe24a8e[_0x183ef8][_0x7896('0x7d')]&&_0x28f5f2['order'](_0x5995ad,_0xe24a8e[_0x183ef8]['orderBy']===_0x7896('0x7e')?![]:!![]);_0x28f5f2[_0x7896('0x6d')](_0x5995ad,_0xe24a8e[_0x183ef8][_0x7896('0x7f')]||_0x5995ad);}if(_0x359189[_0x7896('0x80')]){_0x359189[_0x7896('0x80')]=JSON[_0x7896('0x81')](_0x359189[_0x7896('0x80')]);for(var _0x3620e4=0x0;_0x3620e4<_0x359189[_0x7896('0x80')]['length'];_0x3620e4+=0x1){if(_0x359189[_0x7896('0x80')][_0x3620e4][_0x7896('0x39')]&&_[_0x7896('0x69')](_0x462a3f,_0x359189['joins'][_0x3620e4][_0x7896('0x39')])&&_0x359189[_0x7896('0x80')][_0x3620e4][_0x7896('0x82')]&&_0x359189['joins'][_0x3620e4][_0x7896('0x83')]&&_0x359189[_0x7896('0x80')][_0x3620e4][_0x7896('0x85')]){_0x28f5f2[_0x359189[_0x7896('0x80')][_0x3620e4][_0x7896('0x39')]](_0x359189[_0x7896('0x80')][_0x3620e4][_0x7896('0x83')],null,util[_0x7896('0x7b')](_0x7896('0x84'),_0x359189[_0x7896('0x76')],_0x359189[_0x7896('0x80')][_0x3620e4][_0x7896('0x82')],_0x359189[_0x7896('0x80')][_0x3620e4][_0x7896('0x83')],_0x359189[_0x7896('0x80')][_0x3620e4][_0x7896('0x85')]));}}}if(_0x359189[_0x7896('0x86')]){_0x359189[_0x7896('0x86')]=JSON[_0x7896('0x81')](_0x359189[_0x7896('0x86')]);_0x28f5f2['where'](_0x223de2(_0x359189[_0x7896('0x86')][_0x7896('0x6c')]));}_0x126095=_0x28f5f2[_0x7896('0x87')]();_0x28f5f2['limit'](_0x29e3dc);_0x28f5f2[_0x7896('0x20')](0x0);return;}})[_0x7896('0x2b')](function(){if(_0x363c93['output']===_0x7896('0x92')){return null;}var _0x3fb03a=_[_0x7896('0x48')](_0x363c93,{'name':_0x363c93[_0x7896('0x93')]||_0x363c93['name']||_0x359189[_0x7896('0x32')],'basename':_0x57721d,'savename':util[_0x7896('0x7b')](_0x7896('0x94'),_0x363c93['name']||_0x359189[_0x7896('0x32')],require(_0x7896('0x95'))[_0x7896('0x96')](0x4),_0x363c93[_0x7896('0x97')]||_0x7896('0x98')),'reportId':_0x359189['id'],'reportType':_0x7896('0x99')});return db[_0x7896('0x9a')][_0x7896('0x52')](_0x3fb03a,{'raw':!![]});})['then'](function(_0x1e990c){if(_0x359189[_0x7896('0x76')]===_0x7896('0x9b')){_0x126095[_0x7896('0x45')](_0x359189[_0x7896('0x76')]+_0x7896('0x9c'),_0x363c93[_0x7896('0x9d')],_0x363c93['endDate']);}else{_0x126095[_0x7896('0x45')](_0x359189[_0x7896('0x76')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x363c93[_0x7896('0x9d')],_0x363c93[_0x7896('0x9e')]);}if(_0x1e990c){logger['info'](_0x7896('0x9f'),_0x126095[_0x7896('0x8a')]());require(_0x7896('0xa0'))[_0x7896('0xa1')](path[_0x7896('0x58')](__dirname,_0x7896('0xa2'),_0x1e990c[_0x7896('0x97')]),[_0x1e990c['id'],_0x126095['toString'](),path[_0x7896('0x58')](__dirname,_0x7896('0xa3'),_0x1e990c[_0x7896('0xa4')]),_0x57721d]);return _0x1e990c;}else{var _0x5b59fb=squel[_0x7896('0x75')]();_0x5b59fb['from']('('+_0x126095[_0x7896('0x8a')]()+')',_0x7896('0xa5'));_0x5b59fb[_0x7896('0x6d')](_0x7896('0xa6'),_0x7896('0x22'));_0x126095['limit'](_0x363c93[_0x7896('0x23')]||_0x29e3dc);_0x126095[_0x7896('0x20')](_0x363c93[_0x7896('0x20')]||0x0);return dbH[_0x7896('0xa7')][_0x7896('0x3b')](_0x5b59fb['toString'](),{'type':dbH[_0x7896('0xa7')][_0x7896('0xa8')][_0x7896('0x8b')]})['then'](function(_0x6f979e){if(!_0x6f979e[_0x7896('0x40')]){_0x177502=0x0;}else{_0x177502=_0x6f979e[0x0][_0x7896('0x22')]||0x0;}return dbH[_0x7896('0xa7')][_0x7896('0x3b')](_0x126095[_0x7896('0x8a')](),{'type':dbH[_0x7896('0xa7')][_0x7896('0xa8')][_0x7896('0x8b')]});})[_0x7896('0x2b')](function(_0x27131c){return{'rows':_0x27131c||[],'count':_0x177502};});}});}exports['run']=function(_0x5d4872,_0x2d1e58){return runReport(_0x5d4872[_0x7896('0x4f')],_0x5d4872[_0x7896('0x3b')],_0x5d4872['options'])[_0x7896('0x2b')](respondWithResult(_0x2d1e58,null))['catch'](handleError(_0x2d1e58,null));};exports[_0x7896('0xa9')]=runReport;exports[_0x7896('0x3b')]=function(_0xcfea26,_0x4ff5a4){var _0x407c3a=0xa;var _0x5ed7bf=[_0x7896('0x58'),_0x7896('0x59'),_0x7896('0x5a'),_0x7896('0x5b')];var _0x354c43={'SUM':_0x7896('0x5c'),'COUNT':_0x7896('0x5d'),'COUNT DISTINCT':_0x7896('0x8c'),'MAX':_0x7896('0x5e'),'MIN':_0x7896('0x5f'),'AVG':_0x7896('0x60'),'GROUP_CONCAT':_0x7896('0x61'),'GROUP_CONCAT ASC':_0x7896('0x62'),'GROUP_CONCAT DESC':_0x7896('0x63')};var _0x1c2d5b={'SEC_TO_TIME':_0x7896('0x64'),'DATE':_0x7896('0x65'),'HOUR':_0x7896('0x66'),'ROUND':_0x7896('0x67'),'UNIX_TIMESTAMP':_0x7896('0x68')};var _0xadcacb=function(_0x4451e4){return!_[_0x7896('0x69')](['IS\x20NULL',_0x7896('0xaa'),'IS\x20EMPTY',_0x7896('0x6a')],_0x4451e4);};var _0x2edb26=function(_0x3a5288){if(!_0x3a5288||!_0x3a5288[_0x7896('0x6b')][_0x7896('0x40')]){return'';}for(var _0x5da00a='(',_0x56dc37=0x0;_0x56dc37<_0x3a5288[_0x7896('0x6b')]['length'];_0x56dc37+=0x1){_0x56dc37>0x0&&(_0x5da00a+='\x20'+_0x3a5288[_0x7896('0x8f')]+'\x20');_0x5da00a+=_0x3a5288[_0x7896('0x6b')][_0x56dc37][_0x7896('0x6c')]?_0x2edb26(_0x3a5288[_0x7896('0x6b')][_0x56dc37][_0x7896('0x6c')]):_0x3a5288['rules'][_0x56dc37][_0x7896('0x6d')]+'\x20'+_0x3a5288['rules'][_0x56dc37][_0x7896('0x90')]+(_0xadcacb(_0x3a5288[_0x7896('0x6b')][_0x56dc37][_0x7896('0x90')])?'\x20'+_0x3a5288['rules'][_0x56dc37][_0x7896('0x91')]:'');}return _0x5da00a+')';};var _0x1f4619={'where':{'id':_0xcfea26['params']['id']}},_0x301374,_0x556e2b,_0x26372f,_0x1056c0,_0x48570d;_0x1f4619=_[_0x7896('0x48')]({},_0x1f4619,_0xcfea26[_0x7896('0x4a')]);return db[_0x7896('0x36')]['find'](_0x1f4619)[_0x7896('0x2b')](function(_0x4a5c24){if(_0x4a5c24){_0x301374=_0x4a5c24;return _0x4a5c24[_0x7896('0x6e')]();}return null;})[_0x7896('0x2b')](function(_0x43c6a0){if(_0x43c6a0){if(!_0x43c6a0[_0x7896('0x40')]){throw new db[(_0x7896('0x6f'))]['ValidationErrorItem'](_0x7896('0x71'),0x193);}_0x556e2b=_0x43c6a0;return db['AnalyticMetric'][_0x7896('0x73')]({'raw':!![]});}return null;})[_0x7896('0x2b')](function(_0x53742d){if(_0x53742d){_0x26372f=_[_0x7896('0x74')](_0x53742d,'id');var _0x4d7b3a;var _0x4b1f07=squel[_0x7896('0x75')]();_0x4b1f07['from'](_0x301374[_0x7896('0x76')]);for(var _0x1c9262=0x0;_0x1c9262<_0x556e2b[_0x7896('0x40')];_0x1c9262+=0x1){_0x4d7b3a=_0x556e2b[_0x1c9262][_0x7896('0x77')]?_0x26372f[_0x556e2b[_0x1c9262]['MetricId']][_0x7896('0x78')]:_0x556e2b[_0x1c9262][_0x7896('0x6d')];_0x4d7b3a=_0x556e2b[_0x1c9262][_0x7896('0x7a')]?_[_0x7896('0x79')](_0x354c43[_0x556e2b[_0x1c9262][_0x7896('0x7a')]],'%s',_0x4d7b3a):_0x4d7b3a;_0x4d7b3a=_0x556e2b[_0x1c9262][_0x7896('0x7b')]?_[_0x7896('0x79')](_0x1c2d5b[_0x556e2b[_0x1c9262]['format']],'%s',_0x4d7b3a):_0x4d7b3a;if(_0x556e2b[_0x1c9262]['groupBy']){_0x4b1f07[_0x7896('0x6c')](_0x4d7b3a);}_0x556e2b[_0x1c9262][_0x7896('0x7d')]&&_0x4b1f07['order'](_0x4d7b3a,_0x556e2b[_0x1c9262][_0x7896('0x7d')]===_0x7896('0x7e')?![]:!![]);_0x4b1f07[_0x7896('0x6d')](_0x4d7b3a,_0x556e2b[_0x1c9262][_0x7896('0x7f')]||_0x4d7b3a);}if(_0x301374['joins']){_0x301374[_0x7896('0x80')]=JSON[_0x7896('0x81')](_0x301374[_0x7896('0x80')]);for(var _0x4de4af=0x0;_0x4de4af<_0x301374[_0x7896('0x80')]['length'];_0x4de4af+=0x1){if(_0x301374[_0x7896('0x80')][_0x4de4af][_0x7896('0x39')]&&_[_0x7896('0x69')](_0x5ed7bf,_0x301374[_0x7896('0x80')][_0x4de4af]['type'])&&_0x301374[_0x7896('0x80')][_0x4de4af][_0x7896('0x82')]&&_0x301374[_0x7896('0x80')][_0x4de4af][_0x7896('0x83')]&&_0x301374[_0x7896('0x80')][_0x4de4af][_0x7896('0x85')]){_0x4b1f07[_0x301374[_0x7896('0x80')][_0x4de4af][_0x7896('0x39')]](_0x301374[_0x7896('0x80')][_0x4de4af][_0x7896('0x83')],null,util[_0x7896('0x7b')](_0x7896('0x84'),_0x301374[_0x7896('0x76')],_0x301374[_0x7896('0x80')][_0x4de4af]['parentKey'],_0x301374[_0x7896('0x80')][_0x4de4af][_0x7896('0x83')],_0x301374['joins'][_0x4de4af][_0x7896('0x85')]));}}}if(_0x301374[_0x7896('0x86')]){_0x301374[_0x7896('0x86')]=JSON['parse'](_0x301374[_0x7896('0x86')]);_0x4b1f07[_0x7896('0x45')](_0x2edb26(_0x301374[_0x7896('0x86')][_0x7896('0x6c')]));}_0x48570d=_0x4b1f07[_0x7896('0x87')]();_0x4b1f07[_0x7896('0x23')](_0x407c3a);_0x4b1f07[_0x7896('0x20')](0x0);logger['debug'](_0x7896('0x89'),_0x4b1f07['toString']());return dbH['sequelize'][_0x7896('0x3b')](_0x4b1f07[_0x7896('0x8a')](),{'type':dbH['sequelize']['QueryTypes']['SELECT']});}})['then'](function(){return{'sql':_0x48570d[_0x7896('0x8a')]()};})[_0x7896('0x2b')](respondWithResult(_0x4ff5a4,null))[_0x7896('0x51')](handleError(_0x4ff5a4,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff