// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x731b=['left_join','right_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%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)','HOUR(%s)','ROUND(%s)','includes','IS\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','value','getFields','Sequelize','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','select','table','MetricId','function','replace','format','groupBy','orderBy','order','alias','joins','parse','foreignKey','%s.%s\x20=\x20%s.%s','parentKey','foreignTable','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','cross_join','GROUP_CONCAT(%s)','UNIX_TIMESTAMP(%s)','IS\x20NOT\x20NULL','DESC','output','web','fullPath','%s-%s.%s','csv','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','endDate','info','Run\x20Query:','child_process','fork','../../files/reports','savename','countTable','COUNT(*)','SELECT','run','ValidationErrorItem','keyBy','from','metric','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','dbH','sendStatus','end','status','json','offset','undefined','limit','count','Content-Range','apply','save','update','destroy','then','CustomReports','UserProfileResource','error','stack','name','AnalyticCustomReport','rawAttributes','fieldName','type','model','map','query','keys','filters','attributes','intersection','fields','length','hasOwnProperty','nolimit','sort','where','filter','merge','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','params','create','body','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','find','userProfileId','autoAssociation','preview','join'];(function(_0x390bfb,_0x3fc1e6){var _0x2c074f=function(_0x52b79c){while(--_0x52b79c){_0x390bfb['push'](_0x390bfb['shift']());}};_0x2c074f(++_0x3fc1e6);}(_0x731b,0xf7));var _0xb731=function(_0x23295c,_0x459613){_0x23295c=_0x23295c-0x0;var _0x28944b=_0x731b[_0x23295c];return _0x28944b;};'use strict';var emlformat=require(_0xb731('0x0'));var rimraf=require(_0xb731('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xb731('0x2'));var rp=require(_0xb731('0x3'));var moment=require(_0xb731('0x4'));var BPromise=require(_0xb731('0x5'));var Mustache=require(_0xb731('0x6'));var util=require(_0xb731('0x7'));var path=require('path');var sox=require(_0xb731('0x8'));var csv=require(_0xb731('0x9'));var ejs=require(_0xb731('0xa'));var fs=require('fs');var fs_extra=require(_0xb731('0xb'));var _=require(_0xb731('0xc'));var squel=require(_0xb731('0xd'));var crypto=require(_0xb731('0xe'));var jsforce=require('jsforce');var deskjs=require(_0xb731('0xf'));var toCsv=require(_0xb731('0x9'));var querystring=require(_0xb731('0x10'));var Papa=require(_0xb731('0x11'));var Redis=require(_0xb731('0x12'));var authService=require(_0xb731('0x13'));var qs=require(_0xb731('0x14'));var as=require(_0xb731('0x15'));var hardwareService=require(_0xb731('0x16'));var logger=require(_0xb731('0x17'))(_0xb731('0x18'));var utils=require(_0xb731('0x19'));var config=require(_0xb731('0x1a'));var licenseUtil=require(_0xb731('0x1b'));var db=require(_0xb731('0x1c'))['db'];var dbH=require('../../mysqldb')[_0xb731('0x1d')];function respondWithStatusCode(_0x5f4f12,_0x180a92){_0x180a92=_0x180a92||0xcc;return function(_0x1b670e){if(_0x1b670e){return _0x5f4f12[_0xb731('0x1e')](_0x180a92);}return _0x5f4f12['status'](_0x180a92)[_0xb731('0x1f')]();};}function respondWithResult(_0x4b433a,_0x524c0d){_0x524c0d=_0x524c0d||0xc8;return function(_0x579641){if(_0x579641){return _0x4b433a[_0xb731('0x20')](_0x524c0d)[_0xb731('0x21')](_0x579641);}};}function respondWithFilteredResult(_0x4962e8,_0x47829e){return function(_0x15c596){if(_0x15c596){var _0x5e4ca6=typeof _0x47829e[_0xb731('0x22')]===_0xb731('0x23')&&typeof _0x47829e[_0xb731('0x24')]===_0xb731('0x23');var _0x4e0c6d=_0x15c596[_0xb731('0x25')];var _0x1eaaf7=_0x5e4ca6?0x0:_0x47829e[_0xb731('0x22')];var _0x2c5c62=_0x5e4ca6?_0x15c596['count']:_0x47829e[_0xb731('0x22')]+_0x47829e['limit'];var _0x4b4cb4;if(_0x2c5c62>=_0x4e0c6d){_0x2c5c62=_0x4e0c6d;_0x4b4cb4=0xc8;}else{_0x4b4cb4=0xce;}_0x4962e8[_0xb731('0x20')](_0x4b4cb4);return _0x4962e8['set'](_0xb731('0x26'),_0x1eaaf7+'-'+_0x2c5c62+'/'+_0x4e0c6d)[_0xb731('0x21')](_0x15c596);}return null;};}function patchUpdates(_0x474f0c){return function(_0x36374e){try{jsonpatch[_0xb731('0x27')](_0x36374e,_0x474f0c,!![]);}catch(_0x49af50){return BPromise['reject'](_0x49af50);}return _0x36374e[_0xb731('0x28')]();};}function saveUpdates(_0x3e4623,_0x4f7424){return function(_0x4972cb){if(_0x4972cb){return _0x4972cb[_0xb731('0x29')](_0x3e4623)['then'](function(_0x1f6bc3){return _0x1f6bc3;});}return null;};}function removeEntity(_0x15be09,_0x573432){return function(_0x396790){if(_0x396790){return _0x396790[_0xb731('0x2a')]()[_0xb731('0x2b')](function(){var _0x29944a=_0x396790['get']({'plain':!![]});var _0x9fabd8=_0xb731('0x2c');return db[_0xb731('0x2d')][_0xb731('0x2a')]({'where':{'type':_0x9fabd8,'resourceId':_0x29944a['id']}})[_0xb731('0x2b')](function(){return _0x396790;});})['then'](function(){_0x15be09['status'](0xcc)[_0xb731('0x1f')]();});}};}function handleEntityNotFound(_0x3519c8,_0x513a26){return function(_0x5b6df7){if(!_0x5b6df7){_0x3519c8[_0xb731('0x1e')](0x194);}return _0x5b6df7;};}function handleError(_0x5e4a21,_0x41f8d3){_0x41f8d3=_0x41f8d3||0x1f4;return function(_0x4fbad1){logger[_0xb731('0x2e')](_0x4fbad1[_0xb731('0x2f')]);if(_0x4fbad1[_0xb731('0x30')]){delete _0x4fbad1[_0xb731('0x30')];}_0x5e4a21[_0xb731('0x20')](_0x41f8d3)['send'](_0x4fbad1);};}exports['index']=function(_0x5edd1f,_0x4c0a33){var _0x257dd2={},_0x325a04={},_0x5c20d0={'count':0x0,'rows':[]};var _0x189b34=_['map'](db[_0xb731('0x31')][_0xb731('0x32')],function(_0x4918f7){return{'name':_0x4918f7[_0xb731('0x33')],'type':_0x4918f7[_0xb731('0x34')]['key']};});_0x325a04[_0xb731('0x35')]=_[_0xb731('0x36')](_0x189b34,_0xb731('0x30'));_0x325a04[_0xb731('0x37')]=_[_0xb731('0x38')](_0x5edd1f[_0xb731('0x37')]);_0x325a04[_0xb731('0x39')]=_['intersection'](_0x325a04[_0xb731('0x35')],_0x325a04[_0xb731('0x37')]);_0x257dd2[_0xb731('0x3a')]=_[_0xb731('0x3b')](_0x325a04[_0xb731('0x35')],qs[_0xb731('0x3c')](_0x5edd1f[_0xb731('0x37')][_0xb731('0x3c')]));_0x257dd2[_0xb731('0x3a')]=_0x257dd2[_0xb731('0x3a')][_0xb731('0x3d')]?_0x257dd2[_0xb731('0x3a')]:_0x325a04[_0xb731('0x35')];if(!_0x5edd1f[_0xb731('0x37')][_0xb731('0x3e')](_0xb731('0x3f'))){_0x257dd2[_0xb731('0x24')]=qs[_0xb731('0x24')](_0x5edd1f['query'][_0xb731('0x24')]);_0x257dd2['offset']=qs[_0xb731('0x22')](_0x5edd1f[_0xb731('0x37')][_0xb731('0x22')]);}_0x257dd2['order']=qs['sort'](_0x5edd1f[_0xb731('0x37')][_0xb731('0x40')]);_0x257dd2[_0xb731('0x41')]=qs['filters'](_['pick'](_0x5edd1f['query'],_0x325a04[_0xb731('0x39')]),_0x189b34);if(_0x5edd1f[_0xb731('0x37')][_0xb731('0x42')]){_0x257dd2[_0xb731('0x41')]=_[_0xb731('0x43')](_0x257dd2[_0xb731('0x41')],{'$or':_[_0xb731('0x36')](_0x189b34,function(_0x321441){if(_0x321441[_0xb731('0x34')]!==_0xb731('0x44')){var _0x2c2152={};_0x2c2152[_0x321441[_0xb731('0x30')]]={'$like':'%'+_0x5edd1f[_0xb731('0x37')][_0xb731('0x42')]+'%'};return _0x2c2152;}})});}_0x257dd2=_[_0xb731('0x43')]({},_0x257dd2,_0x5edd1f[_0xb731('0x45')]);var _0x1fb0a1={'where':_0x257dd2[_0xb731('0x41')]};return db[_0xb731('0x31')][_0xb731('0x25')](_0x1fb0a1)[_0xb731('0x2b')](function(_0x21204a){_0x5c20d0[_0xb731('0x25')]=_0x21204a;if(_0x5edd1f['query'][_0xb731('0x46')]){_0x257dd2[_0xb731('0x47')]=[{'all':!![]}];}return db[_0xb731('0x31')][_0xb731('0x48')](_0x257dd2);})['then'](function(_0x5394b2){_0x5c20d0[_0xb731('0x49')]=_0x5394b2;return _0x5c20d0;})[_0xb731('0x2b')](respondWithFilteredResult(_0x4c0a33,_0x257dd2))[_0xb731('0x4a')](handleError(_0x4c0a33,null));};exports[_0xb731('0x4b')]=function(_0x132a97,_0x46a1e1){var _0x411370={'raw':![],'where':{'id':_0x132a97[_0xb731('0x4c')]['id']}},_0x573941={};_0x573941[_0xb731('0x35')]=_[_0xb731('0x38')](db['AnalyticCustomReport'][_0xb731('0x32')]);_0x573941[_0xb731('0x37')]=_[_0xb731('0x38')](_0x132a97[_0xb731('0x37')]);_0x573941[_0xb731('0x39')]=_[_0xb731('0x3b')](_0x573941[_0xb731('0x35')],_0x573941[_0xb731('0x37')]);_0x411370[_0xb731('0x3a')]=_['intersection'](_0x573941['model'],qs[_0xb731('0x3c')](_0x132a97[_0xb731('0x37')][_0xb731('0x3c')]));_0x411370[_0xb731('0x3a')]=_0x411370[_0xb731('0x3a')][_0xb731('0x3d')]?_0x411370[_0xb731('0x3a')]:_0x573941[_0xb731('0x35')];if(_0x132a97['query']['includeAll']){_0x411370[_0xb731('0x47')]=[{'all':!![]}];}_0x411370=_[_0xb731('0x43')]({},_0x411370,_0x132a97[_0xb731('0x45')]);return db[_0xb731('0x31')]['find'](_0x411370)[_0xb731('0x2b')](handleEntityNotFound(_0x46a1e1,null))['then'](respondWithResult(_0x46a1e1,null))[_0xb731('0x4a')](handleError(_0x46a1e1,null));};exports[_0xb731('0x4d')]=function(_0x493f70,_0x5673f9){return db[_0xb731('0x31')]['create'](_0x493f70[_0xb731('0x4e')],{})[_0xb731('0x2b')](function(_0xb699d){var _0x4db993=_0x493f70[_0xb731('0x4f')][_0xb731('0x50')]({'plain':!![]});if(!_0x4db993)throw new Error(_0xb731('0x51'));if(_0x4db993[_0xb731('0x52')]===_0xb731('0x4f')){var _0x49a174=_0xb699d[_0xb731('0x50')]({'plain':!![]});var _0x4cf35d='Reports';return db[_0xb731('0x53')][_0xb731('0x54')]({'where':{'name':_0x4cf35d,'userProfileId':_0x4db993[_0xb731('0x55')]},'raw':!![]})[_0xb731('0x2b')](function(_0x26bc63){if(_0x26bc63&&_0x26bc63[_0xb731('0x56')]===0x0){return db[_0xb731('0x2d')]['create']({'name':_0x49a174[_0xb731('0x30')],'resourceId':_0x49a174['id'],'type':_0xb731('0x2c'),'sectionId':_0x26bc63['id']},{})[_0xb731('0x2b')](function(){return _0xb699d;});}else{return _0xb699d;}})['catch'](function(_0x529b84){logger[_0xb731('0x2e')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x529b84);throw _0x529b84;});}return _0xb699d;})[_0xb731('0x2b')](respondWithResult(_0x5673f9,0xc9))[_0xb731('0x4a')](handleError(_0x5673f9,null));};exports[_0xb731('0x29')]=function(_0x1b82c1,_0x58a4cc){if(_0x1b82c1[_0xb731('0x4e')]['id']){delete _0x1b82c1['body']['id'];}return db['AnalyticCustomReport'][_0xb731('0x54')]({'where':{'id':_0x1b82c1[_0xb731('0x4c')]['id']}})[_0xb731('0x2b')](handleEntityNotFound(_0x58a4cc,null))[_0xb731('0x2b')](saveUpdates(_0x1b82c1[_0xb731('0x4e')],null))[_0xb731('0x2b')](respondWithResult(_0x58a4cc,null))['catch'](handleError(_0x58a4cc,null));};exports[_0xb731('0x2a')]=function(_0x1fa078,_0x3c9ad2){return db[_0xb731('0x31')][_0xb731('0x54')]({'where':{'id':_0x1fa078['params']['id']}})['then'](handleEntityNotFound(_0x3c9ad2,null))[_0xb731('0x2b')](removeEntity(_0x3c9ad2,null))[_0xb731('0x4a')](handleError(_0x3c9ad2,null));};exports[_0xb731('0x57')]=function(_0x84a0c3,_0x14daea){var _0x20b321=0xa;var _0x4c4132=[_0xb731('0x58'),_0xb731('0x59'),_0xb731('0x5a'),'cross_join'];var _0x4796a8={'SUM':_0xb731('0x5b'),'COUNT':_0xb731('0x5c'),'COUNT DISTINCT':_0xb731('0x5d'),'MAX':_0xb731('0x5e'),'MIN':_0xb731('0x5f'),'AVG':_0xb731('0x60'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0xb731('0x61'),'GROUP_CONCAT DESC':_0xb731('0x62')};var _0x39f272={'SEC_TO_TIME':_0xb731('0x63'),'DATE':_0xb731('0x64'),'HOUR':_0xb731('0x65'),'ROUND':_0xb731('0x66'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x4a9ed9=function(_0x515e84){return!_[_0xb731('0x67')]([_0xb731('0x68'),'IS\x20NOT\x20NULL',_0xb731('0x69'),_0xb731('0x6a')],_0x515e84);};var _0x509f25=function(_0x3fdc27){if(!_0x3fdc27||!_0x3fdc27[_0xb731('0x6b')]['length']){return'';}for(var _0x236126='(',_0x142ccb=0x0;_0x142ccb<_0x3fdc27['rules'][_0xb731('0x3d')];_0x142ccb+=0x1){_0x142ccb>0x0&&(_0x236126+='\x20'+_0x3fdc27[_0xb731('0x6c')]+'\x20');_0x236126+=_0x3fdc27[_0xb731('0x6b')][_0x142ccb]['group']?_0x509f25(_0x3fdc27[_0xb731('0x6b')][_0x142ccb][_0xb731('0x6d')]):_0x3fdc27[_0xb731('0x6b')][_0x142ccb][_0xb731('0x6e')]+'\x20'+_0x3fdc27[_0xb731('0x6b')][_0x142ccb]['condition']+(_0x4a9ed9(_0x3fdc27[_0xb731('0x6b')][_0x142ccb][_0xb731('0x6f')])?'\x20'+_0x3fdc27[_0xb731('0x6b')][_0x142ccb][_0xb731('0x70')]:'');}return _0x236126+')';};var _0x76cc37={'where':{'id':_0x84a0c3[_0xb731('0x4c')]['id']}},_0x3424d1,_0x3cb2e4,_0x335068,_0xf99729,_0x4c9dc5;_0x76cc37=_[_0xb731('0x43')]({},_0x76cc37,_0x84a0c3[_0xb731('0x45')]);return db['AnalyticCustomReport']['find'](_0x76cc37)[_0xb731('0x2b')](function(_0x59b071){if(_0x59b071){_0x3424d1=_0x59b071;return _0x59b071[_0xb731('0x71')]();}return null;})[_0xb731('0x2b')](function(_0x197ab3){if(_0x197ab3){if(!_0x197ab3[_0xb731('0x3d')]){throw new db[(_0xb731('0x72'))]['ValidationErrorItem'](_0xb731('0x73'),0x193);}_0x3cb2e4=_0x197ab3;return db[_0xb731('0x74')][_0xb731('0x48')]({'raw':!![]});}return null;})[_0xb731('0x2b')](function(_0x56af26){if(_0x56af26){_0x335068=_['keyBy'](_0x56af26,'id');var _0x657805;var _0x23bda6=squel[_0xb731('0x75')]();_0x23bda6['from'](_0x3424d1[_0xb731('0x76')]);for(var _0x46f928=0x0;_0x46f928<_0x3cb2e4[_0xb731('0x3d')];_0x46f928+=0x1){_0x657805=_0x3cb2e4[_0x46f928][_0xb731('0x77')]?_0x335068[_0x3cb2e4[_0x46f928][_0xb731('0x77')]]['metric']:_0x3cb2e4[_0x46f928][_0xb731('0x6e')];_0x657805=_0x3cb2e4[_0x46f928][_0xb731('0x78')]?_[_0xb731('0x79')](_0x4796a8[_0x3cb2e4[_0x46f928][_0xb731('0x78')]],'%s',_0x657805):_0x657805;_0x657805=_0x3cb2e4[_0x46f928][_0xb731('0x7a')]?_[_0xb731('0x79')](_0x39f272[_0x3cb2e4[_0x46f928][_0xb731('0x7a')]],'%s',_0x657805):_0x657805;if(_0x3cb2e4[_0x46f928][_0xb731('0x7b')]){_0x23bda6[_0xb731('0x6d')](_0x657805);}_0x3cb2e4[_0x46f928][_0xb731('0x7c')]&&_0x23bda6[_0xb731('0x7d')](_0x657805,_0x3cb2e4[_0x46f928][_0xb731('0x7c')]==='DESC'?![]:!![]);_0x23bda6[_0xb731('0x6e')](_0x657805,_0x3cb2e4[_0x46f928][_0xb731('0x7e')]||_0x657805);}if(_0x3424d1['joins']){_0x3424d1[_0xb731('0x7f')]=JSON[_0xb731('0x80')](_0x3424d1[_0xb731('0x7f')]);for(var _0x4c0826=0x0;_0x4c0826<_0x3424d1[_0xb731('0x7f')][_0xb731('0x3d')];_0x4c0826+=0x1){if(_0x3424d1[_0xb731('0x7f')][_0x4c0826]['type']&&_['includes'](_0x4c4132,_0x3424d1[_0xb731('0x7f')][_0x4c0826]['type'])&&_0x3424d1[_0xb731('0x7f')][_0x4c0826]['parentKey']&&_0x3424d1['joins'][_0x4c0826]['foreignTable']&&_0x3424d1[_0xb731('0x7f')][_0x4c0826][_0xb731('0x81')]){_0x23bda6[_0x3424d1[_0xb731('0x7f')][_0x4c0826][_0xb731('0x34')]](_0x3424d1[_0xb731('0x7f')][_0x4c0826]['foreignTable'],null,util[_0xb731('0x7a')](_0xb731('0x82'),_0x3424d1['table'],_0x3424d1[_0xb731('0x7f')][_0x4c0826][_0xb731('0x83')],_0x3424d1['joins'][_0x4c0826][_0xb731('0x84')],_0x3424d1[_0xb731('0x7f')][_0x4c0826][_0xb731('0x81')]));}}}if(_0x3424d1[_0xb731('0x85')]){_0x3424d1[_0xb731('0x85')]=JSON[_0xb731('0x80')](_0x3424d1[_0xb731('0x85')]);_0x23bda6[_0xb731('0x41')](_0x509f25(_0x3424d1[_0xb731('0x85')][_0xb731('0x6d')]));}_0x4c9dc5=_0x23bda6[_0xb731('0x86')]();_0x23bda6['limit'](_0x20b321);_0x23bda6[_0xb731('0x22')](0x0);logger[_0xb731('0x87')](_0xb731('0x88'),_0x23bda6[_0xb731('0x89')]());return dbH['sequelize'][_0xb731('0x37')](_0x23bda6[_0xb731('0x89')](),{'type':dbH[_0xb731('0x8a')][_0xb731('0x8b')]['SELECT']});}})[_0xb731('0x2b')](respondWithResult(_0x14daea,null))['catch'](handleError(_0x14daea,null));};function runReport(_0x59d39c,_0x133e4c,_0x928b61){var _0x4ce877=_0x133e4c[_0xb731('0x30')];var _0x199cd7=0xa;var _0x3e38d8=['join',_0xb731('0x59'),_0xb731('0x5a'),_0xb731('0x8c')];var _0x27101d={'SUM':'SUM(%s)','COUNT':_0xb731('0x5c'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0xb731('0x5e'),'MIN':_0xb731('0x5f'),'AVG':_0xb731('0x60'),'GROUP_CONCAT':_0xb731('0x8d'),'GROUP_CONCAT ASC':_0xb731('0x61'),'GROUP_CONCAT DESC':_0xb731('0x62')};var _0x47abb9={'SEC_TO_TIME':_0xb731('0x63'),'DATE':_0xb731('0x64'),'HOUR':'HOUR(%s)','ROUND':_0xb731('0x66'),'UNIX_TIMESTAMP':_0xb731('0x8e')};var _0x30c379=function(_0x2d6c11){return!_['includes']([_0xb731('0x68'),_0xb731('0x8f'),_0xb731('0x69'),'IS\x20NOT\x20EMPTY'],_0x2d6c11);};var _0x451f2f=function(_0x599d9d){if(!_0x599d9d||!_0x599d9d[_0xb731('0x6b')][_0xb731('0x3d')]){return'';}for(var _0x2d45a4='(',_0x3cec58=0x0;_0x3cec58<_0x599d9d['rules']['length'];_0x3cec58+=0x1){_0x3cec58>0x0&&(_0x2d45a4+='\x20'+_0x599d9d[_0xb731('0x6c')]+'\x20');_0x2d45a4+=_0x599d9d['rules'][_0x3cec58][_0xb731('0x6d')]?_0x451f2f(_0x599d9d[_0xb731('0x6b')][_0x3cec58]['group']):_0x599d9d[_0xb731('0x6b')][_0x3cec58]['field']+'\x20'+_0x599d9d[_0xb731('0x6b')][_0x3cec58][_0xb731('0x6f')]+(_0x30c379(_0x599d9d[_0xb731('0x6b')][_0x3cec58]['condition'])?'\x20'+_0x599d9d['rules'][_0x3cec58][_0xb731('0x70')]:'');}return _0x2d45a4+')';};var _0x38dfdf={'where':{'id':_0x59d39c['id']}},_0x423ab0,_0x3501cf,_0x3af421,_0x190c75,_0x49f5dd;_0x38dfdf=_['merge']({},_0x38dfdf,_0x928b61);return db['AnalyticCustomReport'][_0xb731('0x54')](_0x38dfdf)[_0xb731('0x2b')](function(_0x32b9bb){if(_0x32b9bb){_0x423ab0=_0x32b9bb;return _0x32b9bb[_0xb731('0x71')]();}return null;})[_0xb731('0x2b')](function(_0x5ad732){if(_0x5ad732){if(!_0x5ad732[_0xb731('0x3d')]){throw new db[(_0xb731('0x72'))]['ValidationErrorItem'](_0xb731('0x73'),0x193);}_0x3501cf=_0x5ad732;return db[_0xb731('0x74')]['findAll']({'raw':!![]});}return null;})[_0xb731('0x2b')](function(_0x1cbcc4){if(_0x1cbcc4){_0x3af421=_['keyBy'](_0x1cbcc4,'id');var _0x5d9830;var _0xf64460=squel[_0xb731('0x75')]();_0xf64460['from'](_0x423ab0[_0xb731('0x76')]);for(var _0x4db474=0x0;_0x4db474<_0x3501cf['length'];_0x4db474+=0x1){_0x5d9830=_0x3501cf[_0x4db474][_0xb731('0x77')]?_0x3af421[_0x3501cf[_0x4db474][_0xb731('0x77')]]['metric']:_0x3501cf[_0x4db474][_0xb731('0x6e')];_0x5d9830=_0x3501cf[_0x4db474][_0xb731('0x78')]?_[_0xb731('0x79')](_0x27101d[_0x3501cf[_0x4db474][_0xb731('0x78')]],'%s',_0x5d9830):_0x5d9830;_0x5d9830=_0x3501cf[_0x4db474][_0xb731('0x7a')]?_['replace'](_0x47abb9[_0x3501cf[_0x4db474][_0xb731('0x7a')]],'%s',_0x5d9830):_0x5d9830;if(_0x3501cf[_0x4db474]['groupBy']){_0xf64460[_0xb731('0x6d')](_0x5d9830);}_0x3501cf[_0x4db474][_0xb731('0x7c')]&&_0xf64460[_0xb731('0x7d')](_0x5d9830,_0x3501cf[_0x4db474][_0xb731('0x7c')]===_0xb731('0x90')?![]:!![]);_0xf64460['field'](_0x5d9830,_0x3501cf[_0x4db474][_0xb731('0x7e')]||_0x5d9830);}if(_0x423ab0[_0xb731('0x7f')]){_0x423ab0[_0xb731('0x7f')]=JSON[_0xb731('0x80')](_0x423ab0[_0xb731('0x7f')]);for(var _0x2beeb8=0x0;_0x2beeb8<_0x423ab0[_0xb731('0x7f')]['length'];_0x2beeb8+=0x1){if(_0x423ab0[_0xb731('0x7f')][_0x2beeb8][_0xb731('0x34')]&&_['includes'](_0x3e38d8,_0x423ab0[_0xb731('0x7f')][_0x2beeb8]['type'])&&_0x423ab0[_0xb731('0x7f')][_0x2beeb8][_0xb731('0x83')]&&_0x423ab0[_0xb731('0x7f')][_0x2beeb8][_0xb731('0x84')]&&_0x423ab0[_0xb731('0x7f')][_0x2beeb8]['foreignKey']){_0xf64460[_0x423ab0[_0xb731('0x7f')][_0x2beeb8]['type']](_0x423ab0[_0xb731('0x7f')][_0x2beeb8]['foreignTable'],null,util['format']('%s.%s\x20=\x20%s.%s',_0x423ab0['table'],_0x423ab0['joins'][_0x2beeb8]['parentKey'],_0x423ab0[_0xb731('0x7f')][_0x2beeb8][_0xb731('0x84')],_0x423ab0[_0xb731('0x7f')][_0x2beeb8][_0xb731('0x81')]));}}}if(_0x423ab0[_0xb731('0x85')]){_0x423ab0[_0xb731('0x85')]=JSON[_0xb731('0x80')](_0x423ab0[_0xb731('0x85')]);_0xf64460[_0xb731('0x41')](_0x451f2f(_0x423ab0[_0xb731('0x85')]['group']));}_0x49f5dd=_0xf64460[_0xb731('0x86')]();_0xf64460['limit'](_0x199cd7);_0xf64460[_0xb731('0x22')](0x0);return;}})['then'](function(){if(_0x133e4c[_0xb731('0x91')]===_0xb731('0x92')){return null;}var _0x3b528c=_['merge'](_0x133e4c,{'name':_0x133e4c[_0xb731('0x93')]||_0x133e4c[_0xb731('0x30')]||_0x423ab0['name'],'basename':_0x4ce877,'savename':util[_0xb731('0x7a')](_0xb731('0x94'),_0x133e4c[_0xb731('0x30')]||_0x423ab0[_0xb731('0x30')],require('randomstring')['generate'](0x4),_0x133e4c[_0xb731('0x91')]||_0xb731('0x95')),'reportId':_0x423ab0['id'],'reportType':'custom'});return db[_0xb731('0x96')][_0xb731('0x4d')](_0x3b528c,{'raw':!![]});})[_0xb731('0x2b')](function(_0x1c0efe){if(_0x423ab0[_0xb731('0x76')]===_0xb731('0x97')){_0x49f5dd[_0xb731('0x41')](_0x423ab0[_0xb731('0x76')]+_0xb731('0x98'),_0x133e4c['startDate'],_0x133e4c[_0xb731('0x99')]);}else{_0x49f5dd[_0xb731('0x41')](_0x423ab0[_0xb731('0x76')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x133e4c['startDate'],_0x133e4c[_0xb731('0x99')]);}if(_0x1c0efe){logger[_0xb731('0x9a')](_0xb731('0x9b'),_0x49f5dd[_0xb731('0x89')]());require(_0xb731('0x9c'))[_0xb731('0x9d')](path['join'](__dirname,'../../components/export/',_0x1c0efe[_0xb731('0x91')]),[_0x1c0efe['id'],_0x49f5dd[_0xb731('0x89')](),path['join'](__dirname,_0xb731('0x9e'),_0x1c0efe[_0xb731('0x9f')]),_0x4ce877]);return _0x1c0efe;}else{var _0x33e2ec=squel['select']();_0x33e2ec['from']('('+_0x49f5dd[_0xb731('0x89')]()+')',_0xb731('0xa0'));_0x33e2ec['field'](_0xb731('0xa1'),_0xb731('0x25'));_0x49f5dd[_0xb731('0x24')](_0x133e4c[_0xb731('0x24')]||_0x199cd7);_0x49f5dd['offset'](_0x133e4c[_0xb731('0x22')]||0x0);return dbH[_0xb731('0x8a')][_0xb731('0x37')](_0x33e2ec[_0xb731('0x89')](),{'type':dbH[_0xb731('0x8a')]['QueryTypes']['SELECT']})[_0xb731('0x2b')](function(_0x39c0cd){if(!_0x39c0cd[_0xb731('0x3d')]){_0x190c75=0x0;}else{_0x190c75=_0x39c0cd[0x0]['count']||0x0;}return dbH[_0xb731('0x8a')][_0xb731('0x37')](_0x49f5dd[_0xb731('0x89')](),{'type':dbH[_0xb731('0x8a')][_0xb731('0x8b')][_0xb731('0xa2')]});})['then'](function(_0x1e360a){return{'rows':_0x1e360a||[],'count':_0x190c75};});}});}exports[_0xb731('0xa3')]=function(_0x367d26,_0x56e7df){return runReport(_0x367d26[_0xb731('0x4c')],_0x367d26[_0xb731('0x37')],_0x367d26['options'])[_0xb731('0x2b')](respondWithResult(_0x56e7df,null))[_0xb731('0x4a')](handleError(_0x56e7df,null));};exports['runReport']=runReport;exports[_0xb731('0x37')]=function(_0x42013d,_0x1c853f){var _0x2f9086=0xa;var _0x1462a6=[_0xb731('0x58'),'left_join',_0xb731('0x5a'),_0xb731('0x8c')];var _0x3e1cd3={'SUM':_0xb731('0x5b'),'COUNT':_0xb731('0x5c'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0xb731('0x5e'),'MIN':_0xb731('0x5f'),'AVG':_0xb731('0x60'),'GROUP_CONCAT':_0xb731('0x8d'),'GROUP_CONCAT ASC':_0xb731('0x61'),'GROUP_CONCAT DESC':_0xb731('0x62')};var _0xe890ba={'SEC_TO_TIME':_0xb731('0x63'),'DATE':_0xb731('0x64'),'HOUR':_0xb731('0x65'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0xb731('0x8e')};var _0x25b4ac=function(_0x2262c7){return!_['includes']([_0xb731('0x68'),_0xb731('0x8f'),'IS\x20EMPTY',_0xb731('0x6a')],_0x2262c7);};var _0x9b06c5=function(_0x4fc06a){if(!_0x4fc06a||!_0x4fc06a[_0xb731('0x6b')][_0xb731('0x3d')]){return'';}for(var _0x2e0494='(',_0x1f5200=0x0;_0x1f5200<_0x4fc06a[_0xb731('0x6b')][_0xb731('0x3d')];_0x1f5200+=0x1){_0x1f5200>0x0&&(_0x2e0494+='\x20'+_0x4fc06a['operator']+'\x20');_0x2e0494+=_0x4fc06a[_0xb731('0x6b')][_0x1f5200]['group']?_0x9b06c5(_0x4fc06a[_0xb731('0x6b')][_0x1f5200]['group']):_0x4fc06a[_0xb731('0x6b')][_0x1f5200][_0xb731('0x6e')]+'\x20'+_0x4fc06a['rules'][_0x1f5200]['condition']+(_0x25b4ac(_0x4fc06a[_0xb731('0x6b')][_0x1f5200][_0xb731('0x6f')])?'\x20'+_0x4fc06a[_0xb731('0x6b')][_0x1f5200][_0xb731('0x70')]:'');}return _0x2e0494+')';};var _0xf6e179={'where':{'id':_0x42013d[_0xb731('0x4c')]['id']}},_0x6db50e,_0x4b6720,_0x5a10be,_0x13225f,_0x381c7a;_0xf6e179=_['merge']({},_0xf6e179,_0x42013d[_0xb731('0x45')]);return db[_0xb731('0x31')][_0xb731('0x54')](_0xf6e179)['then'](function(_0x2a3cef){if(_0x2a3cef){_0x6db50e=_0x2a3cef;return _0x2a3cef[_0xb731('0x71')]();}return null;})[_0xb731('0x2b')](function(_0x236ef8){if(_0x236ef8){if(!_0x236ef8[_0xb731('0x3d')]){throw new db['Sequelize'][(_0xb731('0xa4'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x4b6720=_0x236ef8;return db[_0xb731('0x74')][_0xb731('0x48')]({'raw':!![]});}return null;})[_0xb731('0x2b')](function(_0x4c841d){if(_0x4c841d){_0x5a10be=_[_0xb731('0xa5')](_0x4c841d,'id');var _0x495e8e;var _0xb68b89=squel[_0xb731('0x75')]();_0xb68b89[_0xb731('0xa6')](_0x6db50e[_0xb731('0x76')]);for(var _0x1e2b7e=0x0;_0x1e2b7e<_0x4b6720['length'];_0x1e2b7e+=0x1){_0x495e8e=_0x4b6720[_0x1e2b7e][_0xb731('0x77')]?_0x5a10be[_0x4b6720[_0x1e2b7e][_0xb731('0x77')]][_0xb731('0xa7')]:_0x4b6720[_0x1e2b7e][_0xb731('0x6e')];_0x495e8e=_0x4b6720[_0x1e2b7e][_0xb731('0x78')]?_[_0xb731('0x79')](_0x3e1cd3[_0x4b6720[_0x1e2b7e][_0xb731('0x78')]],'%s',_0x495e8e):_0x495e8e;_0x495e8e=_0x4b6720[_0x1e2b7e][_0xb731('0x7a')]?_[_0xb731('0x79')](_0xe890ba[_0x4b6720[_0x1e2b7e][_0xb731('0x7a')]],'%s',_0x495e8e):_0x495e8e;if(_0x4b6720[_0x1e2b7e][_0xb731('0x7b')]){_0xb68b89[_0xb731('0x6d')](_0x495e8e);}_0x4b6720[_0x1e2b7e][_0xb731('0x7c')]&&_0xb68b89[_0xb731('0x7d')](_0x495e8e,_0x4b6720[_0x1e2b7e]['orderBy']===_0xb731('0x90')?![]:!![]);_0xb68b89[_0xb731('0x6e')](_0x495e8e,_0x4b6720[_0x1e2b7e][_0xb731('0x7e')]||_0x495e8e);}if(_0x6db50e[_0xb731('0x7f')]){_0x6db50e['joins']=JSON[_0xb731('0x80')](_0x6db50e['joins']);for(var _0x4fdf04=0x0;_0x4fdf04<_0x6db50e['joins'][_0xb731('0x3d')];_0x4fdf04+=0x1){if(_0x6db50e['joins'][_0x4fdf04][_0xb731('0x34')]&&_[_0xb731('0x67')](_0x1462a6,_0x6db50e['joins'][_0x4fdf04][_0xb731('0x34')])&&_0x6db50e[_0xb731('0x7f')][_0x4fdf04]['parentKey']&&_0x6db50e[_0xb731('0x7f')][_0x4fdf04][_0xb731('0x84')]&&_0x6db50e[_0xb731('0x7f')][_0x4fdf04][_0xb731('0x81')]){_0xb68b89[_0x6db50e[_0xb731('0x7f')][_0x4fdf04]['type']](_0x6db50e[_0xb731('0x7f')][_0x4fdf04][_0xb731('0x84')],null,util[_0xb731('0x7a')](_0xb731('0x82'),_0x6db50e['table'],_0x6db50e[_0xb731('0x7f')][_0x4fdf04]['parentKey'],_0x6db50e[_0xb731('0x7f')][_0x4fdf04][_0xb731('0x84')],_0x6db50e[_0xb731('0x7f')][_0x4fdf04][_0xb731('0x81')]));}}}if(_0x6db50e[_0xb731('0x85')]){_0x6db50e[_0xb731('0x85')]=JSON[_0xb731('0x80')](_0x6db50e[_0xb731('0x85')]);_0xb68b89[_0xb731('0x41')](_0x9b06c5(_0x6db50e['conditions']['group']));}_0x381c7a=_0xb68b89[_0xb731('0x86')]();_0xb68b89[_0xb731('0x24')](_0x2f9086);_0xb68b89['offset'](0x0);logger[_0xb731('0x87')]('Limited\x20Query:',_0xb68b89[_0xb731('0x89')]());return dbH[_0xb731('0x8a')]['query'](_0xb68b89[_0xb731('0x89')](),{'type':dbH[_0xb731('0x8a')][_0xb731('0x8b')]['SELECT']});}})['then'](function(){return{'sql':_0x381c7a[_0xb731('0x89')]()};})[_0xb731('0x2b')](respondWithResult(_0x1c853f,null))[_0xb731('0x4a')](handleError(_0x1c853f,null));};
\ No newline at end of file
+var _0x00fe=['IS\x20NOT\x20NULL','IS\x20NOT\x20EMPTY','rules','operator','group','condition','value','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','select','from','table','MetricId','metric','field','replace','format','groupBy','orderBy','DESC','joins','parse','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','conditions','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','right_join','cross_join','MAX(%s)','GROUP_CONCAT(%s)','IS\x20EMPTY','function','alias','output','fullPath','%s-%s.%s','generate','csv','custom','AnalyticExtractedReport','.calldate\x20BETWEEN\x20?\x20AND\x20?','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','child_process','fork','COUNT(*)','run','eml-format','zip-dir','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','desk.js','querystring','ioredis','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','dbH','sendStatus','status','end','offset','undefined','limit','count','set','Content-Range','json','save','update','then','CustomReports','UserProfileResource','stack','name','send','index','map','AnalyticCustomReport','rawAttributes','fieldName','type','key','query','keys','filters','model','intersection','fields','attributes','hasOwnProperty','nolimit','order','sort','where','filter','merge','VIRTUAL','options','includeAll','include','findAll','rows','catch','length','find','create','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','UserProfileSection','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','params','destroy','join','left_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%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)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL'];(function(_0x45e35b,_0x337936){var _0x53311f=function(_0x59352d){while(--_0x59352d){_0x45e35b['push'](_0x45e35b['shift']());}};_0x53311f(++_0x337936);}(_0x00fe,0x179));var _0xe00f=function(_0x4e21ba,_0x18097f){_0x4e21ba=_0x4e21ba-0x0;var _0x55b94b=_0x00fe[_0x4e21ba];return _0x55b94b;};'use strict';var emlformat=require(_0xe00f('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xe00f('0x1'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0xe00f('0x2'));var BPromise=require(_0xe00f('0x3'));var Mustache=require(_0xe00f('0x4'));var util=require(_0xe00f('0x5'));var path=require(_0xe00f('0x6'));var sox=require(_0xe00f('0x7'));var csv=require(_0xe00f('0x8'));var ejs=require(_0xe00f('0x9'));var fs=require('fs');var fs_extra=require(_0xe00f('0xa'));var _=require(_0xe00f('0xb'));var squel=require(_0xe00f('0xc'));var crypto=require(_0xe00f('0xd'));var jsforce=require('jsforce');var deskjs=require(_0xe00f('0xe'));var toCsv=require(_0xe00f('0x8'));var querystring=require(_0xe00f('0xf'));var Papa=require('papaparse');var Redis=require(_0xe00f('0x10'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xe00f('0x11'));var logger=require(_0xe00f('0x12'))(_0xe00f('0x13'));var utils=require('../../config/utils');var config=require(_0xe00f('0x14'));var licenseUtil=require(_0xe00f('0x15'));var db=require(_0xe00f('0x16'))['db'];var dbH=require(_0xe00f('0x16'))[_0xe00f('0x17')];function respondWithStatusCode(_0x3082b8,_0x1d2f88){_0x1d2f88=_0x1d2f88||0xcc;return function(_0x5e7c64){if(_0x5e7c64){return _0x3082b8[_0xe00f('0x18')](_0x1d2f88);}return _0x3082b8[_0xe00f('0x19')](_0x1d2f88)[_0xe00f('0x1a')]();};}function respondWithResult(_0x33670c,_0x195d95){_0x195d95=_0x195d95||0xc8;return function(_0x2b9eb5){if(_0x2b9eb5){return _0x33670c['status'](_0x195d95)['json'](_0x2b9eb5);}};}function respondWithFilteredResult(_0xa9a5d2,_0x4fb287){return function(_0x2c869a){if(_0x2c869a){var _0x448aaa=typeof _0x4fb287[_0xe00f('0x1b')]===_0xe00f('0x1c')&&typeof _0x4fb287[_0xe00f('0x1d')]===_0xe00f('0x1c');var _0x29ec53=_0x2c869a[_0xe00f('0x1e')];var _0x5e5ca3=_0x448aaa?0x0:_0x4fb287['offset'];var _0x284e3a=_0x448aaa?_0x2c869a[_0xe00f('0x1e')]:_0x4fb287[_0xe00f('0x1b')]+_0x4fb287[_0xe00f('0x1d')];var _0x136cf7;if(_0x284e3a>=_0x29ec53){_0x284e3a=_0x29ec53;_0x136cf7=0xc8;}else{_0x136cf7=0xce;}_0xa9a5d2['status'](_0x136cf7);return _0xa9a5d2[_0xe00f('0x1f')](_0xe00f('0x20'),_0x5e5ca3+'-'+_0x284e3a+'/'+_0x29ec53)[_0xe00f('0x21')](_0x2c869a);}return null;};}function patchUpdates(_0x4b6c81){return function(_0x47d0d6){try{jsonpatch['apply'](_0x47d0d6,_0x4b6c81,!![]);}catch(_0x4afe00){return BPromise['reject'](_0x4afe00);}return _0x47d0d6[_0xe00f('0x22')]();};}function saveUpdates(_0xb01fea,_0x3776fe){return function(_0x264ced){if(_0x264ced){return _0x264ced[_0xe00f('0x23')](_0xb01fea)['then'](function(_0x193b4d){return _0x193b4d;});}return null;};}function removeEntity(_0x2afb99,_0x97522b){return function(_0xacf0c6){if(_0xacf0c6){return _0xacf0c6['destroy']()[_0xe00f('0x24')](function(){var _0x4fa753=_0xacf0c6['get']({'plain':!![]});var _0x490ef6=_0xe00f('0x25');return db[_0xe00f('0x26')]['destroy']({'where':{'type':_0x490ef6,'resourceId':_0x4fa753['id']}})[_0xe00f('0x24')](function(){return _0xacf0c6;});})[_0xe00f('0x24')](function(){_0x2afb99[_0xe00f('0x19')](0xcc)[_0xe00f('0x1a')]();});}};}function handleEntityNotFound(_0x3d6845,_0x5c9d47){return function(_0x2a629e){if(!_0x2a629e){_0x3d6845[_0xe00f('0x18')](0x194);}return _0x2a629e;};}function handleError(_0x998e0f,_0x1656e1){_0x1656e1=_0x1656e1||0x1f4;return function(_0x119605){logger['error'](_0x119605[_0xe00f('0x27')]);if(_0x119605[_0xe00f('0x28')]){delete _0x119605[_0xe00f('0x28')];}_0x998e0f[_0xe00f('0x19')](_0x1656e1)[_0xe00f('0x29')](_0x119605);};}exports[_0xe00f('0x2a')]=function(_0x277091,_0x20faf0){var _0x1bf4c2={},_0x11570e={},_0x1d5f96={'count':0x0,'rows':[]};var _0xc6f2b8=_[_0xe00f('0x2b')](db[_0xe00f('0x2c')][_0xe00f('0x2d')],function(_0x57f8bf){return{'name':_0x57f8bf[_0xe00f('0x2e')],'type':_0x57f8bf[_0xe00f('0x2f')][_0xe00f('0x30')]};});_0x11570e['model']=_[_0xe00f('0x2b')](_0xc6f2b8,_0xe00f('0x28'));_0x11570e[_0xe00f('0x31')]=_[_0xe00f('0x32')](_0x277091[_0xe00f('0x31')]);_0x11570e[_0xe00f('0x33')]=_['intersection'](_0x11570e[_0xe00f('0x34')],_0x11570e[_0xe00f('0x31')]);_0x1bf4c2['attributes']=_[_0xe00f('0x35')](_0x11570e[_0xe00f('0x34')],qs[_0xe00f('0x36')](_0x277091['query'][_0xe00f('0x36')]));_0x1bf4c2[_0xe00f('0x37')]=_0x1bf4c2['attributes']['length']?_0x1bf4c2[_0xe00f('0x37')]:_0x11570e[_0xe00f('0x34')];if(!_0x277091[_0xe00f('0x31')][_0xe00f('0x38')](_0xe00f('0x39'))){_0x1bf4c2[_0xe00f('0x1d')]=qs['limit'](_0x277091[_0xe00f('0x31')][_0xe00f('0x1d')]);_0x1bf4c2['offset']=qs['offset'](_0x277091[_0xe00f('0x31')][_0xe00f('0x1b')]);}_0x1bf4c2[_0xe00f('0x3a')]=qs[_0xe00f('0x3b')](_0x277091[_0xe00f('0x31')][_0xe00f('0x3b')]);_0x1bf4c2[_0xe00f('0x3c')]=qs[_0xe00f('0x33')](_['pick'](_0x277091[_0xe00f('0x31')],_0x11570e[_0xe00f('0x33')]),_0xc6f2b8);if(_0x277091[_0xe00f('0x31')][_0xe00f('0x3d')]){_0x1bf4c2[_0xe00f('0x3c')]=_[_0xe00f('0x3e')](_0x1bf4c2[_0xe00f('0x3c')],{'$or':_['map'](_0xc6f2b8,function(_0x19cd1e){if(_0x19cd1e[_0xe00f('0x2f')]!==_0xe00f('0x3f')){var _0x25d9bf={};_0x25d9bf[_0x19cd1e['name']]={'$like':'%'+_0x277091['query']['filter']+'%'};return _0x25d9bf;}})});}_0x1bf4c2=_[_0xe00f('0x3e')]({},_0x1bf4c2,_0x277091[_0xe00f('0x40')]);var _0x110f4c={'where':_0x1bf4c2[_0xe00f('0x3c')]};return db[_0xe00f('0x2c')][_0xe00f('0x1e')](_0x110f4c)[_0xe00f('0x24')](function(_0x558f60){_0x1d5f96[_0xe00f('0x1e')]=_0x558f60;if(_0x277091['query'][_0xe00f('0x41')]){_0x1bf4c2[_0xe00f('0x42')]=[{'all':!![]}];}return db['AnalyticCustomReport'][_0xe00f('0x43')](_0x1bf4c2);})[_0xe00f('0x24')](function(_0x49c7c6){_0x1d5f96[_0xe00f('0x44')]=_0x49c7c6;return _0x1d5f96;})['then'](respondWithFilteredResult(_0x20faf0,_0x1bf4c2))[_0xe00f('0x45')](handleError(_0x20faf0,null));};exports['show']=function(_0x164dff,_0x45f2ae){var _0x31dde1={'raw':![],'where':{'id':_0x164dff['params']['id']}},_0x2a468c={};_0x2a468c[_0xe00f('0x34')]=_[_0xe00f('0x32')](db[_0xe00f('0x2c')][_0xe00f('0x2d')]);_0x2a468c[_0xe00f('0x31')]=_[_0xe00f('0x32')](_0x164dff['query']);_0x2a468c[_0xe00f('0x33')]=_['intersection'](_0x2a468c[_0xe00f('0x34')],_0x2a468c[_0xe00f('0x31')]);_0x31dde1[_0xe00f('0x37')]=_[_0xe00f('0x35')](_0x2a468c['model'],qs['fields'](_0x164dff[_0xe00f('0x31')][_0xe00f('0x36')]));_0x31dde1['attributes']=_0x31dde1[_0xe00f('0x37')][_0xe00f('0x46')]?_0x31dde1['attributes']:_0x2a468c[_0xe00f('0x34')];if(_0x164dff[_0xe00f('0x31')][_0xe00f('0x41')]){_0x31dde1[_0xe00f('0x42')]=[{'all':!![]}];}_0x31dde1=_[_0xe00f('0x3e')]({},_0x31dde1,_0x164dff['options']);return db[_0xe00f('0x2c')][_0xe00f('0x47')](_0x31dde1)['then'](handleEntityNotFound(_0x45f2ae,null))[_0xe00f('0x24')](respondWithResult(_0x45f2ae,null))[_0xe00f('0x45')](handleError(_0x45f2ae,null));};exports[_0xe00f('0x48')]=function(_0x5b82d4,_0x5c487b){return db[_0xe00f('0x2c')]['create'](_0x5b82d4['body'],{})[_0xe00f('0x24')](function(_0x553292){var _0x58756a=_0x5b82d4[_0xe00f('0x49')][_0xe00f('0x4a')]({'plain':!![]});if(!_0x58756a)throw new Error(_0xe00f('0x4b'));if(_0x58756a[_0xe00f('0x4c')]===_0xe00f('0x49')){var _0x5878a8=_0x553292[_0xe00f('0x4a')]({'plain':!![]});var _0x531728=_0xe00f('0x4d');return db[_0xe00f('0x4e')][_0xe00f('0x47')]({'where':{'name':_0x531728,'userProfileId':_0x58756a[_0xe00f('0x4f')]},'raw':!![]})[_0xe00f('0x24')](function(_0x1d3c13){if(_0x1d3c13&&_0x1d3c13['autoAssociation']===0x0){return db[_0xe00f('0x26')][_0xe00f('0x48')]({'name':_0x5878a8[_0xe00f('0x28')],'resourceId':_0x5878a8['id'],'type':_0xe00f('0x25'),'sectionId':_0x1d3c13['id']},{})[_0xe00f('0x24')](function(){return _0x553292;});}else{return _0x553292;}})[_0xe00f('0x45')](function(_0x4a93e0){logger['error'](_0xe00f('0x50'),_0x4a93e0);throw _0x4a93e0;});}return _0x553292;})[_0xe00f('0x24')](respondWithResult(_0x5c487b,0xc9))[_0xe00f('0x45')](handleError(_0x5c487b,null));};exports[_0xe00f('0x23')]=function(_0x1415a4,_0x5ea34a){if(_0x1415a4['body']['id']){delete _0x1415a4[_0xe00f('0x51')]['id'];}return db[_0xe00f('0x2c')][_0xe00f('0x47')]({'where':{'id':_0x1415a4[_0xe00f('0x52')]['id']}})['then'](handleEntityNotFound(_0x5ea34a,null))[_0xe00f('0x24')](saveUpdates(_0x1415a4[_0xe00f('0x51')],null))[_0xe00f('0x24')](respondWithResult(_0x5ea34a,null))['catch'](handleError(_0x5ea34a,null));};exports[_0xe00f('0x53')]=function(_0x5acc70,_0x4f08bc){return db[_0xe00f('0x2c')][_0xe00f('0x47')]({'where':{'id':_0x5acc70[_0xe00f('0x52')]['id']}})['then'](handleEntityNotFound(_0x4f08bc,null))[_0xe00f('0x24')](removeEntity(_0x4f08bc,null))[_0xe00f('0x45')](handleError(_0x4f08bc,null));};exports['preview']=function(_0x38a482,_0x50aa93){var _0x48dbf7=0xa;var _0x569175=[_0xe00f('0x54'),_0xe00f('0x55'),'right_join','cross_join'];var _0x4f5235={'SUM':_0xe00f('0x56'),'COUNT':_0xe00f('0x57'),'COUNT DISTINCT':_0xe00f('0x58'),'MAX':'MAX(%s)','MIN':_0xe00f('0x59'),'AVG':_0xe00f('0x5a'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0xe00f('0x5b'),'GROUP_CONCAT DESC':_0xe00f('0x5c')};var _0x436ff3={'SEC_TO_TIME':_0xe00f('0x5d'),'DATE':_0xe00f('0x5e'),'HOUR':_0xe00f('0x5f'),'ROUND':_0xe00f('0x60'),'UNIX_TIMESTAMP':_0xe00f('0x61')};var _0x4dbc7d=function(_0xf4810c){return!_[_0xe00f('0x62')]([_0xe00f('0x63'),_0xe00f('0x64'),'IS\x20EMPTY',_0xe00f('0x65')],_0xf4810c);};var _0x500c98=function(_0x5a97f2){if(!_0x5a97f2||!_0x5a97f2[_0xe00f('0x66')]['length']){return'';}for(var _0x25334d='(',_0x432e4a=0x0;_0x432e4a<_0x5a97f2[_0xe00f('0x66')][_0xe00f('0x46')];_0x432e4a+=0x1){_0x432e4a>0x0&&(_0x25334d+='\x20'+_0x5a97f2[_0xe00f('0x67')]+'\x20');_0x25334d+=_0x5a97f2['rules'][_0x432e4a]['group']?_0x500c98(_0x5a97f2[_0xe00f('0x66')][_0x432e4a][_0xe00f('0x68')]):_0x5a97f2[_0xe00f('0x66')][_0x432e4a]['field']+'\x20'+_0x5a97f2[_0xe00f('0x66')][_0x432e4a]['condition']+(_0x4dbc7d(_0x5a97f2[_0xe00f('0x66')][_0x432e4a][_0xe00f('0x69')])?'\x20'+_0x5a97f2['rules'][_0x432e4a][_0xe00f('0x6a')]:'');}return _0x25334d+')';};var _0x54f3a8={'where':{'id':_0x38a482[_0xe00f('0x52')]['id']}},_0x482fe0,_0x21f801,_0x29168b,_0x1d8033,_0x510473;_0x54f3a8=_[_0xe00f('0x3e')]({},_0x54f3a8,_0x38a482[_0xe00f('0x40')]);return db[_0xe00f('0x2c')][_0xe00f('0x47')](_0x54f3a8)[_0xe00f('0x24')](function(_0x3fc1dd){if(_0x3fc1dd){_0x482fe0=_0x3fc1dd;return _0x3fc1dd[_0xe00f('0x6b')]();}return null;})[_0xe00f('0x24')](function(_0x5a48aa){if(_0x5a48aa){if(!_0x5a48aa[_0xe00f('0x46')]){throw new db[(_0xe00f('0x6c'))][(_0xe00f('0x6d'))](_0xe00f('0x6e'),0x193);}_0x21f801=_0x5a48aa;return db[_0xe00f('0x6f')][_0xe00f('0x43')]({'raw':!![]});}return null;})[_0xe00f('0x24')](function(_0x247578){if(_0x247578){_0x29168b=_[_0xe00f('0x70')](_0x247578,'id');var _0x3e5a1d;var _0x341c2b=squel[_0xe00f('0x71')]();_0x341c2b[_0xe00f('0x72')](_0x482fe0[_0xe00f('0x73')]);for(var _0x586276=0x0;_0x586276<_0x21f801[_0xe00f('0x46')];_0x586276+=0x1){_0x3e5a1d=_0x21f801[_0x586276][_0xe00f('0x74')]?_0x29168b[_0x21f801[_0x586276][_0xe00f('0x74')]][_0xe00f('0x75')]:_0x21f801[_0x586276][_0xe00f('0x76')];_0x3e5a1d=_0x21f801[_0x586276]['function']?_[_0xe00f('0x77')](_0x4f5235[_0x21f801[_0x586276]['function']],'%s',_0x3e5a1d):_0x3e5a1d;_0x3e5a1d=_0x21f801[_0x586276][_0xe00f('0x78')]?_[_0xe00f('0x77')](_0x436ff3[_0x21f801[_0x586276][_0xe00f('0x78')]],'%s',_0x3e5a1d):_0x3e5a1d;if(_0x21f801[_0x586276][_0xe00f('0x79')]){_0x341c2b[_0xe00f('0x68')](_0x3e5a1d);}_0x21f801[_0x586276][_0xe00f('0x7a')]&&_0x341c2b[_0xe00f('0x3a')](_0x3e5a1d,_0x21f801[_0x586276]['orderBy']===_0xe00f('0x7b')?![]:!![]);_0x341c2b[_0xe00f('0x76')](_0x3e5a1d,_0x21f801[_0x586276]['alias']||_0x3e5a1d);}if(_0x482fe0[_0xe00f('0x7c')]){_0x482fe0[_0xe00f('0x7c')]=JSON[_0xe00f('0x7d')](_0x482fe0[_0xe00f('0x7c')]);for(var _0x5a7866=0x0;_0x5a7866<_0x482fe0[_0xe00f('0x7c')][_0xe00f('0x46')];_0x5a7866+=0x1){if(_0x482fe0[_0xe00f('0x7c')][_0x5a7866]['type']&&_[_0xe00f('0x62')](_0x569175,_0x482fe0['joins'][_0x5a7866][_0xe00f('0x2f')])&&_0x482fe0[_0xe00f('0x7c')][_0x5a7866][_0xe00f('0x7e')]&&_0x482fe0['joins'][_0x5a7866][_0xe00f('0x7f')]&&_0x482fe0[_0xe00f('0x7c')][_0x5a7866][_0xe00f('0x80')]){_0x341c2b[_0x482fe0[_0xe00f('0x7c')][_0x5a7866][_0xe00f('0x2f')]](_0x482fe0['joins'][_0x5a7866][_0xe00f('0x7f')],null,util[_0xe00f('0x78')](_0xe00f('0x81'),_0x482fe0[_0xe00f('0x73')],_0x482fe0[_0xe00f('0x7c')][_0x5a7866][_0xe00f('0x7e')],_0x482fe0[_0xe00f('0x7c')][_0x5a7866][_0xe00f('0x7f')],_0x482fe0['joins'][_0x5a7866]['foreignKey']));}}}if(_0x482fe0[_0xe00f('0x82')]){_0x482fe0['conditions']=JSON[_0xe00f('0x7d')](_0x482fe0['conditions']);_0x341c2b['where'](_0x500c98(_0x482fe0[_0xe00f('0x82')][_0xe00f('0x68')]));}_0x510473=_0x341c2b['clone']();_0x341c2b[_0xe00f('0x1d')](_0x48dbf7);_0x341c2b[_0xe00f('0x1b')](0x0);logger[_0xe00f('0x83')](_0xe00f('0x84'),_0x341c2b[_0xe00f('0x85')]());return dbH[_0xe00f('0x86')][_0xe00f('0x31')](_0x341c2b[_0xe00f('0x85')](),{'type':dbH['sequelize'][_0xe00f('0x87')][_0xe00f('0x88')]});}})[_0xe00f('0x24')](respondWithResult(_0x50aa93,null))[_0xe00f('0x45')](handleError(_0x50aa93,null));};function runReport(_0x292123,_0x465c66,_0x4737c1){var _0x411a12=_0x465c66[_0xe00f('0x28')];var _0x4cc3fd=0xa;var _0x594ec1=[_0xe00f('0x54'),'left_join',_0xe00f('0x89'),_0xe00f('0x8a')];var _0x346f8f={'SUM':'SUM(%s)','COUNT':_0xe00f('0x57'),'COUNT DISTINCT':_0xe00f('0x58'),'MAX':_0xe00f('0x8b'),'MIN':_0xe00f('0x59'),'AVG':_0xe00f('0x5a'),'GROUP_CONCAT':_0xe00f('0x8c'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0xe00f('0x5c')};var _0x1f54f7={'SEC_TO_TIME':_0xe00f('0x5d'),'DATE':_0xe00f('0x5e'),'HOUR':'HOUR(%s)','ROUND':_0xe00f('0x60'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x52ed9e=function(_0x298af9){return!_[_0xe00f('0x62')]([_0xe00f('0x63'),'IS\x20NOT\x20NULL',_0xe00f('0x8d'),_0xe00f('0x65')],_0x298af9);};var _0x38934e=function(_0x31a185){if(!_0x31a185||!_0x31a185[_0xe00f('0x66')]['length']){return'';}for(var _0x53c7ab='(',_0x33db75=0x0;_0x33db75<_0x31a185[_0xe00f('0x66')][_0xe00f('0x46')];_0x33db75+=0x1){_0x33db75>0x0&&(_0x53c7ab+='\x20'+_0x31a185[_0xe00f('0x67')]+'\x20');_0x53c7ab+=_0x31a185[_0xe00f('0x66')][_0x33db75][_0xe00f('0x68')]?_0x38934e(_0x31a185['rules'][_0x33db75][_0xe00f('0x68')]):_0x31a185[_0xe00f('0x66')][_0x33db75][_0xe00f('0x76')]+'\x20'+_0x31a185['rules'][_0x33db75][_0xe00f('0x69')]+(_0x52ed9e(_0x31a185['rules'][_0x33db75]['condition'])?'\x20'+_0x31a185[_0xe00f('0x66')][_0x33db75][_0xe00f('0x6a')]:'');}return _0x53c7ab+')';};var _0x38f0c9={'where':{'id':_0x292123['id']}},_0x2cca73,_0x4520b4,_0x11b4e0,_0x1b9d5f,_0x1c2986;_0x38f0c9=_['merge']({},_0x38f0c9,_0x4737c1);return db[_0xe00f('0x2c')][_0xe00f('0x47')](_0x38f0c9)[_0xe00f('0x24')](function(_0x1fa188){if(_0x1fa188){_0x2cca73=_0x1fa188;return _0x1fa188[_0xe00f('0x6b')]();}return null;})[_0xe00f('0x24')](function(_0xed9495){if(_0xed9495){if(!_0xed9495[_0xe00f('0x46')]){throw new db[(_0xe00f('0x6c'))][(_0xe00f('0x6d'))](_0xe00f('0x6e'),0x193);}_0x4520b4=_0xed9495;return db['AnalyticMetric'][_0xe00f('0x43')]({'raw':!![]});}return null;})['then'](function(_0x13b242){if(_0x13b242){_0x11b4e0=_['keyBy'](_0x13b242,'id');var _0xf536c2;var _0x2174d7=squel[_0xe00f('0x71')]();_0x2174d7[_0xe00f('0x72')](_0x2cca73['table']);for(var _0xe88464=0x0;_0xe88464<_0x4520b4['length'];_0xe88464+=0x1){_0xf536c2=_0x4520b4[_0xe88464]['MetricId']?_0x11b4e0[_0x4520b4[_0xe88464][_0xe00f('0x74')]][_0xe00f('0x75')]:_0x4520b4[_0xe88464]['field'];_0xf536c2=_0x4520b4[_0xe88464][_0xe00f('0x8e')]?_['replace'](_0x346f8f[_0x4520b4[_0xe88464][_0xe00f('0x8e')]],'%s',_0xf536c2):_0xf536c2;_0xf536c2=_0x4520b4[_0xe88464][_0xe00f('0x78')]?_[_0xe00f('0x77')](_0x1f54f7[_0x4520b4[_0xe88464][_0xe00f('0x78')]],'%s',_0xf536c2):_0xf536c2;if(_0x4520b4[_0xe88464][_0xe00f('0x79')]){_0x2174d7['group'](_0xf536c2);}_0x4520b4[_0xe88464][_0xe00f('0x7a')]&&_0x2174d7[_0xe00f('0x3a')](_0xf536c2,_0x4520b4[_0xe88464][_0xe00f('0x7a')]==='DESC'?![]:!![]);_0x2174d7[_0xe00f('0x76')](_0xf536c2,_0x4520b4[_0xe88464][_0xe00f('0x8f')]||_0xf536c2);}if(_0x2cca73[_0xe00f('0x7c')]){_0x2cca73[_0xe00f('0x7c')]=JSON[_0xe00f('0x7d')](_0x2cca73[_0xe00f('0x7c')]);for(var _0x495fdf=0x0;_0x495fdf<_0x2cca73['joins']['length'];_0x495fdf+=0x1){if(_0x2cca73['joins'][_0x495fdf]['type']&&_[_0xe00f('0x62')](_0x594ec1,_0x2cca73['joins'][_0x495fdf][_0xe00f('0x2f')])&&_0x2cca73[_0xe00f('0x7c')][_0x495fdf][_0xe00f('0x7e')]&&_0x2cca73[_0xe00f('0x7c')][_0x495fdf]['foreignTable']&&_0x2cca73[_0xe00f('0x7c')][_0x495fdf]['foreignKey']){_0x2174d7[_0x2cca73[_0xe00f('0x7c')][_0x495fdf][_0xe00f('0x2f')]](_0x2cca73['joins'][_0x495fdf][_0xe00f('0x7f')],null,util[_0xe00f('0x78')]('%s.%s\x20=\x20%s.%s',_0x2cca73[_0xe00f('0x73')],_0x2cca73['joins'][_0x495fdf][_0xe00f('0x7e')],_0x2cca73['joins'][_0x495fdf][_0xe00f('0x7f')],_0x2cca73[_0xe00f('0x7c')][_0x495fdf][_0xe00f('0x80')]));}}}if(_0x2cca73[_0xe00f('0x82')]){_0x2cca73[_0xe00f('0x82')]=JSON[_0xe00f('0x7d')](_0x2cca73[_0xe00f('0x82')]);_0x2174d7[_0xe00f('0x3c')](_0x38934e(_0x2cca73[_0xe00f('0x82')][_0xe00f('0x68')]));}_0x1c2986=_0x2174d7['clone']();_0x2174d7[_0xe00f('0x1d')](_0x4cc3fd);_0x2174d7[_0xe00f('0x1b')](0x0);return;}})[_0xe00f('0x24')](function(){if(_0x465c66[_0xe00f('0x90')]==='web'){return null;}var _0x164d2e=_[_0xe00f('0x3e')](_0x465c66,{'name':_0x465c66[_0xe00f('0x91')]||_0x465c66[_0xe00f('0x28')]||_0x2cca73[_0xe00f('0x28')],'basename':_0x411a12,'savename':util[_0xe00f('0x78')](_0xe00f('0x92'),_0x465c66[_0xe00f('0x28')]||_0x2cca73[_0xe00f('0x28')],require('randomstring')[_0xe00f('0x93')](0x4),_0x465c66[_0xe00f('0x90')]||_0xe00f('0x94')),'reportId':_0x2cca73['id'],'reportType':_0xe00f('0x95')});return db[_0xe00f('0x96')][_0xe00f('0x48')](_0x164d2e,{'raw':!![]});})[_0xe00f('0x24')](function(_0x3dfe53){if(_0x2cca73['table']==='cdr'){_0x1c2986[_0xe00f('0x3c')](_0x2cca73['table']+_0xe00f('0x97'),_0x465c66['startDate'],_0x465c66[_0xe00f('0x98')]);}else{_0x1c2986['where'](_0x2cca73[_0xe00f('0x73')]+_0xe00f('0x99'),_0x465c66['startDate'],_0x465c66[_0xe00f('0x98')]);}if(_0x3dfe53){logger[_0xe00f('0x9a')]('Run\x20Query:',_0x1c2986[_0xe00f('0x85')]());require(_0xe00f('0x9b'))[_0xe00f('0x9c')](path[_0xe00f('0x54')](__dirname,'../../components/export/',_0x3dfe53[_0xe00f('0x90')]),[_0x3dfe53['id'],_0x1c2986[_0xe00f('0x85')](),path[_0xe00f('0x54')](__dirname,'../../files/reports',_0x3dfe53['savename']),_0x411a12]);return _0x3dfe53;}else{var _0x47abd1=squel['select']();_0x47abd1['from']('('+_0x1c2986[_0xe00f('0x85')]()+')','countTable');_0x47abd1[_0xe00f('0x76')](_0xe00f('0x9d'),_0xe00f('0x1e'));_0x1c2986[_0xe00f('0x1d')](_0x465c66[_0xe00f('0x1d')]||_0x4cc3fd);_0x1c2986[_0xe00f('0x1b')](_0x465c66[_0xe00f('0x1b')]||0x0);return dbH[_0xe00f('0x86')][_0xe00f('0x31')](_0x47abd1[_0xe00f('0x85')](),{'type':dbH[_0xe00f('0x86')][_0xe00f('0x87')][_0xe00f('0x88')]})[_0xe00f('0x24')](function(_0x34076b){if(!_0x34076b[_0xe00f('0x46')]){_0x1b9d5f=0x0;}else{_0x1b9d5f=_0x34076b[0x0][_0xe00f('0x1e')]||0x0;}return dbH['sequelize'][_0xe00f('0x31')](_0x1c2986[_0xe00f('0x85')](),{'type':dbH['sequelize'][_0xe00f('0x87')][_0xe00f('0x88')]});})[_0xe00f('0x24')](function(_0x4a6914){return{'rows':_0x4a6914||[],'count':_0x1b9d5f};});}});}exports[_0xe00f('0x9e')]=function(_0x369416,_0x1a5bf5){return runReport(_0x369416[_0xe00f('0x52')],_0x369416[_0xe00f('0x31')],_0x369416['options'])[_0xe00f('0x24')](respondWithResult(_0x1a5bf5,null))['catch'](handleError(_0x1a5bf5,null));};exports['runReport']=runReport;exports[_0xe00f('0x31')]=function(_0x1eb41c,_0x3263e4){var _0x258c14=0xa;var _0x1dafe0=[_0xe00f('0x54'),_0xe00f('0x55'),_0xe00f('0x89'),_0xe00f('0x8a')];var _0xd2d2e0={'SUM':_0xe00f('0x56'),'COUNT':_0xe00f('0x57'),'COUNT DISTINCT':_0xe00f('0x58'),'MAX':'MAX(%s)','MIN':_0xe00f('0x59'),'AVG':'AVG(%s)','GROUP_CONCAT':_0xe00f('0x8c'),'GROUP_CONCAT ASC':_0xe00f('0x5b'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x2c5481={'SEC_TO_TIME':_0xe00f('0x5d'),'DATE':_0xe00f('0x5e'),'HOUR':_0xe00f('0x5f'),'ROUND':_0xe00f('0x60'),'UNIX_TIMESTAMP':_0xe00f('0x61')};var _0xe91eb5=function(_0x57aa8b){return!_['includes']([_0xe00f('0x63'),_0xe00f('0x64'),_0xe00f('0x8d'),_0xe00f('0x65')],_0x57aa8b);};var _0x3ba060=function(_0x3e9d4a){if(!_0x3e9d4a||!_0x3e9d4a[_0xe00f('0x66')][_0xe00f('0x46')]){return'';}for(var _0x3366c5='(',_0x22a996=0x0;_0x22a996<_0x3e9d4a['rules'][_0xe00f('0x46')];_0x22a996+=0x1){_0x22a996>0x0&&(_0x3366c5+='\x20'+_0x3e9d4a['operator']+'\x20');_0x3366c5+=_0x3e9d4a[_0xe00f('0x66')][_0x22a996]['group']?_0x3ba060(_0x3e9d4a[_0xe00f('0x66')][_0x22a996][_0xe00f('0x68')]):_0x3e9d4a['rules'][_0x22a996][_0xe00f('0x76')]+'\x20'+_0x3e9d4a['rules'][_0x22a996][_0xe00f('0x69')]+(_0xe91eb5(_0x3e9d4a['rules'][_0x22a996]['condition'])?'\x20'+_0x3e9d4a[_0xe00f('0x66')][_0x22a996][_0xe00f('0x6a')]:'');}return _0x3366c5+')';};var _0x41303e={'where':{'id':_0x1eb41c[_0xe00f('0x52')]['id']}},_0x4a0c75,_0x1fcadc,_0x3b973a,_0x59af8e,_0x2f0748;_0x41303e=_[_0xe00f('0x3e')]({},_0x41303e,_0x1eb41c[_0xe00f('0x40')]);return db[_0xe00f('0x2c')][_0xe00f('0x47')](_0x41303e)[_0xe00f('0x24')](function(_0x4d490e){if(_0x4d490e){_0x4a0c75=_0x4d490e;return _0x4d490e['getFields']();}return null;})[_0xe00f('0x24')](function(_0x3347d2){if(_0x3347d2){if(!_0x3347d2['length']){throw new db[(_0xe00f('0x6c'))][(_0xe00f('0x6d'))](_0xe00f('0x6e'),0x193);}_0x1fcadc=_0x3347d2;return db['AnalyticMetric'][_0xe00f('0x43')]({'raw':!![]});}return null;})[_0xe00f('0x24')](function(_0x535fa0){if(_0x535fa0){_0x3b973a=_[_0xe00f('0x70')](_0x535fa0,'id');var _0x2930de;var _0x1db780=squel[_0xe00f('0x71')]();_0x1db780[_0xe00f('0x72')](_0x4a0c75['table']);for(var _0x24f056=0x0;_0x24f056<_0x1fcadc[_0xe00f('0x46')];_0x24f056+=0x1){_0x2930de=_0x1fcadc[_0x24f056][_0xe00f('0x74')]?_0x3b973a[_0x1fcadc[_0x24f056]['MetricId']][_0xe00f('0x75')]:_0x1fcadc[_0x24f056][_0xe00f('0x76')];_0x2930de=_0x1fcadc[_0x24f056][_0xe00f('0x8e')]?_['replace'](_0xd2d2e0[_0x1fcadc[_0x24f056]['function']],'%s',_0x2930de):_0x2930de;_0x2930de=_0x1fcadc[_0x24f056][_0xe00f('0x78')]?_[_0xe00f('0x77')](_0x2c5481[_0x1fcadc[_0x24f056][_0xe00f('0x78')]],'%s',_0x2930de):_0x2930de;if(_0x1fcadc[_0x24f056][_0xe00f('0x79')]){_0x1db780[_0xe00f('0x68')](_0x2930de);}_0x1fcadc[_0x24f056]['orderBy']&&_0x1db780['order'](_0x2930de,_0x1fcadc[_0x24f056][_0xe00f('0x7a')]==='DESC'?![]:!![]);_0x1db780[_0xe00f('0x76')](_0x2930de,_0x1fcadc[_0x24f056][_0xe00f('0x8f')]||_0x2930de);}if(_0x4a0c75[_0xe00f('0x7c')]){_0x4a0c75['joins']=JSON['parse'](_0x4a0c75['joins']);for(var _0xcac4f3=0x0;_0xcac4f3<_0x4a0c75[_0xe00f('0x7c')][_0xe00f('0x46')];_0xcac4f3+=0x1){if(_0x4a0c75[_0xe00f('0x7c')][_0xcac4f3][_0xe00f('0x2f')]&&_[_0xe00f('0x62')](_0x1dafe0,_0x4a0c75[_0xe00f('0x7c')][_0xcac4f3]['type'])&&_0x4a0c75['joins'][_0xcac4f3][_0xe00f('0x7e')]&&_0x4a0c75[_0xe00f('0x7c')][_0xcac4f3]['foreignTable']&&_0x4a0c75[_0xe00f('0x7c')][_0xcac4f3][_0xe00f('0x80')]){_0x1db780[_0x4a0c75['joins'][_0xcac4f3][_0xe00f('0x2f')]](_0x4a0c75[_0xe00f('0x7c')][_0xcac4f3][_0xe00f('0x7f')],null,util[_0xe00f('0x78')](_0xe00f('0x81'),_0x4a0c75[_0xe00f('0x73')],_0x4a0c75[_0xe00f('0x7c')][_0xcac4f3][_0xe00f('0x7e')],_0x4a0c75[_0xe00f('0x7c')][_0xcac4f3]['foreignTable'],_0x4a0c75[_0xe00f('0x7c')][_0xcac4f3][_0xe00f('0x80')]));}}}if(_0x4a0c75[_0xe00f('0x82')]){_0x4a0c75[_0xe00f('0x82')]=JSON[_0xe00f('0x7d')](_0x4a0c75[_0xe00f('0x82')]);_0x1db780[_0xe00f('0x3c')](_0x3ba060(_0x4a0c75['conditions'][_0xe00f('0x68')]));}_0x2f0748=_0x1db780['clone']();_0x1db780[_0xe00f('0x1d')](_0x258c14);_0x1db780[_0xe00f('0x1b')](0x0);logger['debug'](_0xe00f('0x84'),_0x1db780[_0xe00f('0x85')]());return dbH[_0xe00f('0x86')][_0xe00f('0x31')](_0x1db780[_0xe00f('0x85')](),{'type':dbH[_0xe00f('0x86')]['QueryTypes'][_0xe00f('0x88')]});}})[_0xe00f('0x24')](function(){return{'sql':_0x2f0748['toString']()};})[_0xe00f('0x24')](respondWithResult(_0x3263e4,null))['catch'](handleError(_0x3263e4,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff