// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x2067=['../../config/utils','../../config/environment','../../mysqldb','status','end','json','count','limit','set','Content-Range','apply','save','update','destroy','get','UserProfileResource','sendStatus','error','stack','name','index','map','AnalyticDefaultReport','fieldName','type','key','model','query','keys','filters','attributes','length','hasOwnProperty','offset','order','where','pick','filter','merge','VIRTUAL','options','then','include','findAll','catch','params','rawAttributes','intersection','fields','includeAll','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','UserProfileSection','find','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','preview','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)','IS\x20NOT\x20NULL','IS\x20EMPTY','rules','operator','group','field','value','getFields','Sequelize','ValidationErrorItem','AnalyticMetric','keyBy','select','from','MetricId','metric','function','replace','format','groupBy','orderBy','DESC','joins','includes','parentKey','foreignKey','foreignTable','%s.%s\x20=\x20%s.%s','table','conditions','parse','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','join','COUNT(DISTINCT\x20%s)','IS\x20NOT\x20EMPTY','condition','Please\x20insert\x20at\x20least\x20one\x20field','alias','No\x20available\x20data','output','web','fullPath','%s-%s.%s','generate','csv','default','cdr','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','startDate','info','child_process','fork','../../components/export/','../../files/reports','savename','countTable','COUNT(*)','runReport','html-pdf','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api'];(function(_0x146319,_0x2ca027){var _0x18128a=function(_0x317a9d){while(--_0x317a9d){_0x146319['push'](_0x146319['shift']());}};_0x18128a(++_0x2ca027);}(_0x2067,0x8f));var _0x7206=function(_0x509dad,_0x459580){_0x509dad=_0x509dad-0x0;var _0x31ae78=_0x2067[_0x509dad];return _0x31ae78;};'use strict';var pdf=require(_0x7206('0x0'));var emlformat=require(_0x7206('0x1'));var rimraf=require(_0x7206('0x2'));var zipdir=require(_0x7206('0x3'));var jsonpatch=require('fast-json-patch');var rp=require(_0x7206('0x4'));var moment=require(_0x7206('0x5'));var BPromise=require(_0x7206('0x6'));var Mustache=require(_0x7206('0x7'));var util=require(_0x7206('0x8'));var path=require(_0x7206('0x9'));var sox=require('sox');var csv=require(_0x7206('0xa'));var ejs=require(_0x7206('0xb'));var fs=require('fs');var _=require(_0x7206('0xc'));var squel=require(_0x7206('0xd'));var crypto=require(_0x7206('0xe'));var jsforce=require(_0x7206('0xf'));var deskjs=require(_0x7206('0x10'));var toCsv=require(_0x7206('0xa'));var querystring=require(_0x7206('0x11'));var Papa=require(_0x7206('0x12'));var Redis=require('ioredis');var authService=require(_0x7206('0x13'));var qs=require(_0x7206('0x14'));var as=require(_0x7206('0x15'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x7206('0x16'))(_0x7206('0x17'));var utils=require(_0x7206('0x18'));var config=require(_0x7206('0x19'));var db=require(_0x7206('0x1a'))['db'];var dbH=require(_0x7206('0x1a'))['dbH'];function respondWithStatusCode(_0xb13b54,_0x22da92){_0x22da92=_0x22da92||0xcc;return function(_0x2b30df){if(_0x2b30df){return _0xb13b54['sendStatus'](_0x22da92);}return _0xb13b54[_0x7206('0x1b')](_0x22da92)[_0x7206('0x1c')]();};}function respondWithResult(_0x479c14,_0x3aa7a8){_0x3aa7a8=_0x3aa7a8||0xc8;return function(_0xbda2aa){if(_0xbda2aa){return _0x479c14[_0x7206('0x1b')](_0x3aa7a8)[_0x7206('0x1d')](_0xbda2aa);}};}function respondWithFilteredResult(_0x3f5f59,_0x45f5f0){return function(_0x1d0160){if(_0x1d0160){var _0x2eea16=_0x1d0160[_0x7206('0x1e')],_0x32eea9=_0x45f5f0['offset'],_0x2ca2ac=_0x45f5f0['offset']+_0x45f5f0[_0x7206('0x1f')],_0x5715b2;if(_0x2ca2ac>=_0x2eea16){_0x2ca2ac=_0x2eea16;_0x5715b2=0xc8;}else{_0x5715b2=0xce;}_0x3f5f59['status'](_0x5715b2);return _0x3f5f59[_0x7206('0x20')](_0x7206('0x21'),_0x32eea9+'-'+_0x2ca2ac+'/'+_0x2eea16)[_0x7206('0x1d')](_0x1d0160);}return null;};}function patchUpdates(_0x253ff3){return function(_0x3f0cb0){try{jsonpatch[_0x7206('0x22')](_0x3f0cb0,_0x253ff3,!![]);}catch(_0x4ffe4e){return BPromise['reject'](_0x4ffe4e);}return _0x3f0cb0[_0x7206('0x23')]();};}function saveUpdates(_0x5b5df7,_0x223635){return function(_0x307a09){if(_0x307a09){return _0x307a09[_0x7206('0x24')](_0x5b5df7)['then'](function(_0x4960fe){return _0x4960fe;});}return null;};}function removeEntity(_0x411c80,_0x37e6b3){return function(_0x1027aa){if(_0x1027aa){return _0x1027aa[_0x7206('0x25')]()['then'](function(){var _0x33e1ae=_0x1027aa[_0x7206('0x26')]({'plain':!![]});var _0x33044b='DefaultReports';return db[_0x7206('0x27')][_0x7206('0x25')]({'where':{'type':_0x33044b,'resourceId':_0x33e1ae['id']}})['then'](function(){return _0x1027aa;});})['then'](function(){_0x411c80[_0x7206('0x1b')](0xcc)[_0x7206('0x1c')]();});}};}function handleEntityNotFound(_0x13aada,_0x3ceaab){return function(_0xc78427){if(!_0xc78427){_0x13aada[_0x7206('0x28')](0x194);}return _0xc78427;};}function handleError(_0x25870b,_0x15f68b){_0x15f68b=_0x15f68b||0x1f4;return function(_0x452238){logger[_0x7206('0x29')](_0x452238[_0x7206('0x2a')]);if(_0x452238[_0x7206('0x2b')]){delete _0x452238[_0x7206('0x2b')];}_0x25870b[_0x7206('0x1b')](_0x15f68b)['send'](_0x452238);};}exports[_0x7206('0x2c')]=function(_0x2b8a43,_0x596aff){var _0x3e8452={},_0x458333={},_0x53bf33={'count':0x0,'rows':[]};var _0x61220a=_[_0x7206('0x2d')](db[_0x7206('0x2e')]['rawAttributes'],function(_0x13bca9){return{'name':_0x13bca9[_0x7206('0x2f')],'type':_0x13bca9[_0x7206('0x30')][_0x7206('0x31')]};});_0x458333[_0x7206('0x32')]=_[_0x7206('0x2d')](_0x61220a,'name');_0x458333[_0x7206('0x33')]=_[_0x7206('0x34')](_0x2b8a43[_0x7206('0x33')]);_0x458333[_0x7206('0x35')]=_['intersection'](_0x458333[_0x7206('0x32')],_0x458333[_0x7206('0x33')]);_0x3e8452['attributes']=_['intersection'](_0x458333[_0x7206('0x32')],qs['fields'](_0x2b8a43[_0x7206('0x33')]['fields']));_0x3e8452[_0x7206('0x36')]=_0x3e8452[_0x7206('0x36')][_0x7206('0x37')]?_0x3e8452[_0x7206('0x36')]:_0x458333['model'];if(!_0x2b8a43[_0x7206('0x33')][_0x7206('0x38')]('nolimit')){_0x3e8452[_0x7206('0x1f')]=qs[_0x7206('0x1f')](_0x2b8a43['query'][_0x7206('0x1f')]);_0x3e8452[_0x7206('0x39')]=qs['offset'](_0x2b8a43['query'][_0x7206('0x39')]);}_0x3e8452[_0x7206('0x3a')]=qs['sort'](_0x2b8a43[_0x7206('0x33')]['sort']);_0x3e8452[_0x7206('0x3b')]=qs[_0x7206('0x35')](_[_0x7206('0x3c')](_0x2b8a43[_0x7206('0x33')],_0x458333['filters']),_0x61220a);if(_0x2b8a43[_0x7206('0x33')][_0x7206('0x3d')]){_0x3e8452['where']=_[_0x7206('0x3e')](_0x3e8452[_0x7206('0x3b')],{'$or':_['map'](_0x61220a,function(_0x380795){if(_0x380795[_0x7206('0x30')]!==_0x7206('0x3f')){var _0x33b7ed={};_0x33b7ed[_0x380795[_0x7206('0x2b')]]={'$like':'%'+_0x2b8a43['query'][_0x7206('0x3d')]+'%'};return _0x33b7ed;}})});}_0x3e8452=_[_0x7206('0x3e')]({},_0x3e8452,_0x2b8a43[_0x7206('0x40')]);var _0x24fdc4={'where':_0x3e8452['where']};return db[_0x7206('0x2e')]['count'](_0x24fdc4)[_0x7206('0x41')](function(_0x36db6c){_0x53bf33[_0x7206('0x1e')]=_0x36db6c;if(_0x2b8a43['query']['includeAll']){_0x3e8452[_0x7206('0x42')]=[{'all':!![]}];}return db['AnalyticDefaultReport'][_0x7206('0x43')](_0x3e8452);})[_0x7206('0x41')](function(_0x2b35f3){_0x53bf33['rows']=_0x2b35f3;return _0x53bf33;})[_0x7206('0x41')](respondWithFilteredResult(_0x596aff,_0x3e8452))[_0x7206('0x44')](handleError(_0x596aff,null));};exports['show']=function(_0x529cc1,_0x2c3ab2){var _0x2c700c={'raw':!![],'where':{'id':_0x529cc1[_0x7206('0x45')]['id']}},_0x57e7c1={};_0x57e7c1[_0x7206('0x32')]=_[_0x7206('0x34')](db[_0x7206('0x2e')][_0x7206('0x46')]);_0x57e7c1[_0x7206('0x33')]=_['keys'](_0x529cc1['query']);_0x57e7c1[_0x7206('0x35')]=_[_0x7206('0x47')](_0x57e7c1[_0x7206('0x32')],_0x57e7c1['query']);_0x2c700c[_0x7206('0x36')]=_[_0x7206('0x47')](_0x57e7c1['model'],qs[_0x7206('0x48')](_0x529cc1[_0x7206('0x33')][_0x7206('0x48')]));_0x2c700c[_0x7206('0x36')]=_0x2c700c[_0x7206('0x36')][_0x7206('0x37')]?_0x2c700c[_0x7206('0x36')]:_0x57e7c1[_0x7206('0x32')];if(_0x529cc1['query'][_0x7206('0x49')]){_0x2c700c[_0x7206('0x42')]=[{'all':!![]}];}_0x2c700c=_[_0x7206('0x3e')]({},_0x2c700c,_0x529cc1[_0x7206('0x40')]);return db[_0x7206('0x2e')]['find'](_0x2c700c)[_0x7206('0x41')](handleEntityNotFound(_0x2c3ab2,null))[_0x7206('0x41')](respondWithResult(_0x2c3ab2,null))[_0x7206('0x44')](handleError(_0x2c3ab2,null));};exports[_0x7206('0x4a')]=function(_0x5a3638,_0xa2f00b){return db['AnalyticDefaultReport'][_0x7206('0x4a')](_0x5a3638['body'],{})[_0x7206('0x41')](function(_0x2f30ec){var _0x3f3386=_0x5a3638[_0x7206('0x4b')]['get']({'plain':!![]});if(!_0x3f3386)throw new Error(_0x7206('0x4c'));if(_0x3f3386[_0x7206('0x4d')]===_0x7206('0x4b')){var _0xb70c3b=_0x2f30ec['get']({'plain':!![]});var _0x4078e2=_0x7206('0x4e');return db[_0x7206('0x4f')][_0x7206('0x50')]({'where':{'name':_0x4078e2,'userProfileId':_0x3f3386[_0x7206('0x51')]},'raw':!![]})[_0x7206('0x41')](function(_0x4996d6){if(_0x4996d6&&_0x4996d6[_0x7206('0x52')]===0x0){return db[_0x7206('0x27')][_0x7206('0x4a')]({'name':_0xb70c3b[_0x7206('0x2b')],'resourceId':_0xb70c3b['id'],'type':'DefaultReports','sectionId':_0x4996d6['id']},{})[_0x7206('0x41')](function(){return _0x2f30ec;});}else{return _0x2f30ec;}})[_0x7206('0x44')](function(_0x41f2e8){logger[_0x7206('0x29')](_0x7206('0x53'),_0x41f2e8);throw _0x41f2e8;});}return _0x2f30ec;})[_0x7206('0x41')](respondWithResult(_0xa2f00b,0xc9))[_0x7206('0x44')](handleError(_0xa2f00b,null));};exports[_0x7206('0x24')]=function(_0x50c3d0,_0xa47182){if(_0x50c3d0[_0x7206('0x54')]['id']){delete _0x50c3d0[_0x7206('0x54')]['id'];}return db[_0x7206('0x2e')][_0x7206('0x50')]({'where':{'id':_0x50c3d0['params']['id']}})[_0x7206('0x41')](handleEntityNotFound(_0xa47182,null))[_0x7206('0x41')](saveUpdates(_0x50c3d0[_0x7206('0x54')],null))['then'](respondWithResult(_0xa47182,null))[_0x7206('0x44')](handleError(_0xa47182,null));};exports[_0x7206('0x25')]=function(_0x1b166c,_0x399cd1){return db[_0x7206('0x2e')][_0x7206('0x50')]({'where':{'id':_0x1b166c['params']['id']}})[_0x7206('0x41')](handleEntityNotFound(_0x399cd1,null))['then'](removeEntity(_0x399cd1,null))[_0x7206('0x44')](handleError(_0x399cd1,null));};exports[_0x7206('0x55')]=function(_0xf17895,_0x38d47b){var _0x4fcebf=0xa;var _0x46f62c=['join',_0x7206('0x56'),_0x7206('0x57'),_0x7206('0x58')];var _0x55e33a={'SUM':_0x7206('0x59'),'COUNT':_0x7206('0x5a'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x7206('0x5b'),'MIN':_0x7206('0x5c'),'AVG':_0x7206('0x5d'),'GROUP_CONCAT':_0x7206('0x5e'),'GROUP_CONCAT ASC':_0x7206('0x5f'),'GROUP_CONCAT DESC':_0x7206('0x60')};var _0x472b2a={'SEC_TO_TIME':_0x7206('0x61'),'DATE':_0x7206('0x62'),'HOUR':_0x7206('0x63'),'ROUND':_0x7206('0x64'),'UNIX_TIMESTAMP':_0x7206('0x65')};var _0x5bca3d=function(_0xe4dd78){return!_['includes'](['IS\x20NULL',_0x7206('0x66'),_0x7206('0x67'),'IS\x20NOT\x20EMPTY'],_0xe4dd78);};var _0x2eedb8=function(_0x28e125){if(!_0x28e125||!_0x28e125[_0x7206('0x68')][_0x7206('0x37')]){return'';}for(var _0x5b7ab7='(',_0x1621b2=0x0;_0x1621b2<_0x28e125[_0x7206('0x68')]['length'];_0x1621b2+=0x1){_0x1621b2>0x0&&(_0x5b7ab7+='\x20'+_0x28e125[_0x7206('0x69')]+'\x20');_0x5b7ab7+=_0x28e125[_0x7206('0x68')][_0x1621b2]['group']?_0x2eedb8(_0x28e125[_0x7206('0x68')][_0x1621b2][_0x7206('0x6a')]):_0x28e125['rules'][_0x1621b2][_0x7206('0x6b')]+'\x20'+_0x28e125[_0x7206('0x68')][_0x1621b2]['condition']+(_0x5bca3d(_0x28e125[_0x7206('0x68')][_0x1621b2]['condition'])?'\x20'+_0x28e125['rules'][_0x1621b2][_0x7206('0x6c')]:'');}return _0x5b7ab7+')';};var _0x2a8abd={'where':{'id':_0xf17895[_0x7206('0x45')]['id']}},_0x2c6e4e,_0x5c71c9,_0x4fc2ba,_0xe4d0b3,_0x106412;_0x2a8abd=_[_0x7206('0x3e')]({},_0x2a8abd,_0xf17895[_0x7206('0x40')]);return db['AnalyticDefaultReport'][_0x7206('0x50')](_0x2a8abd)[_0x7206('0x41')](function(_0x3e5c67){if(_0x3e5c67){_0x2c6e4e=_0x3e5c67;return _0x3e5c67[_0x7206('0x6d')]();}return null;})[_0x7206('0x41')](function(_0x387dba){if(_0x387dba){if(!_0x387dba[_0x7206('0x37')]){throw new db[(_0x7206('0x6e'))][(_0x7206('0x6f'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x5c71c9=_0x387dba;return db[_0x7206('0x70')][_0x7206('0x43')]({'raw':!![]});}return null;})[_0x7206('0x41')](function(_0x1f2a05){if(_0x1f2a05){_0x4fc2ba=_[_0x7206('0x71')](_0x1f2a05,'id');var _0x279fd1;var _0x2921b7=squel[_0x7206('0x72')]();_0x2921b7[_0x7206('0x73')](_0x2c6e4e['table']);for(var _0xc519a9=0x0;_0xc519a9<_0x5c71c9[_0x7206('0x37')];_0xc519a9+=0x1){_0x279fd1=_0x5c71c9[_0xc519a9][_0x7206('0x74')]?_0x4fc2ba[_0x5c71c9[_0xc519a9]['MetricId']][_0x7206('0x75')]:_0x5c71c9[_0xc519a9]['field'];_0x279fd1=_0x5c71c9[_0xc519a9][_0x7206('0x76')]?_[_0x7206('0x77')](_0x55e33a[_0x5c71c9[_0xc519a9][_0x7206('0x76')]],'%s',_0x279fd1):_0x279fd1;_0x279fd1=_0x5c71c9[_0xc519a9]['format']?_[_0x7206('0x77')](_0x472b2a[_0x5c71c9[_0xc519a9][_0x7206('0x78')]],'%s',_0x279fd1):_0x279fd1;if(_0x5c71c9[_0xc519a9][_0x7206('0x79')]){_0x2921b7[_0x7206('0x6a')](_0x279fd1);}_0x5c71c9[_0xc519a9][_0x7206('0x7a')]&&_0x2921b7[_0x7206('0x3a')](_0x279fd1,_0x5c71c9[_0xc519a9][_0x7206('0x7a')]===_0x7206('0x7b')?![]:!![]);_0x2921b7[_0x7206('0x6b')](_0x279fd1,_0x5c71c9[_0xc519a9]['alias']||_0x279fd1);}if(_0x2c6e4e[_0x7206('0x7c')]){_0x2c6e4e['joins']=JSON['parse'](_0x2c6e4e[_0x7206('0x7c')]);for(var _0x3f1d69=0x0;_0x3f1d69<_0x2c6e4e[_0x7206('0x7c')][_0x7206('0x37')];_0x3f1d69+=0x1){if(_0x2c6e4e[_0x7206('0x7c')][_0x3f1d69][_0x7206('0x30')]&&_[_0x7206('0x7d')](_0x46f62c,_0x2c6e4e['joins'][_0x3f1d69][_0x7206('0x30')])&&_0x2c6e4e[_0x7206('0x7c')][_0x3f1d69][_0x7206('0x7e')]&&_0x2c6e4e[_0x7206('0x7c')][_0x3f1d69]['foreignTable']&&_0x2c6e4e['joins'][_0x3f1d69][_0x7206('0x7f')]){_0x2921b7[_0x2c6e4e[_0x7206('0x7c')][_0x3f1d69][_0x7206('0x30')]](_0x2c6e4e[_0x7206('0x7c')][_0x3f1d69][_0x7206('0x80')],null,util[_0x7206('0x78')](_0x7206('0x81'),_0x2c6e4e[_0x7206('0x82')],_0x2c6e4e[_0x7206('0x7c')][_0x3f1d69][_0x7206('0x7e')],_0x2c6e4e[_0x7206('0x7c')][_0x3f1d69][_0x7206('0x80')],_0x2c6e4e[_0x7206('0x7c')][_0x3f1d69]['foreignKey']));}}}if(_0x2c6e4e[_0x7206('0x83')]){_0x2c6e4e[_0x7206('0x83')]=JSON[_0x7206('0x84')](_0x2c6e4e[_0x7206('0x83')]);_0x2921b7[_0x7206('0x3b')](_0x2eedb8(_0x2c6e4e[_0x7206('0x83')][_0x7206('0x6a')]));}_0x106412=_0x2921b7[_0x7206('0x85')]();_0x2921b7['limit'](_0x4fcebf);_0x2921b7[_0x7206('0x39')](0x0);logger[_0x7206('0x86')](_0x7206('0x87'),_0x2921b7[_0x7206('0x88')]());return db[_0x7206('0x89')][_0x7206('0x33')](_0x2921b7['toString'](),{'type':db['sequelize'][_0x7206('0x8a')][_0x7206('0x8b')]});}})[_0x7206('0x41')](respondWithResult(_0x38d47b,null))[_0x7206('0x44')](handleError(_0x38d47b,null));};function runReport(_0x33fe57,_0x48aefa,_0x32ca33){var _0x156810=_0x48aefa[_0x7206('0x2b')];var _0x533cf3=0xa;var _0x4684b4=[_0x7206('0x8c'),_0x7206('0x56'),_0x7206('0x57'),_0x7206('0x58')];var _0x2382f2={'SUM':_0x7206('0x59'),'COUNT':_0x7206('0x5a'),'COUNT DISTINCT':_0x7206('0x8d'),'MAX':_0x7206('0x5b'),'MIN':_0x7206('0x5c'),'AVG':_0x7206('0x5d'),'GROUP_CONCAT':_0x7206('0x5e'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x10ff1f={'SEC_TO_TIME':_0x7206('0x61'),'DATE':_0x7206('0x62'),'HOUR':'HOUR(%s)','ROUND':_0x7206('0x64'),'UNIX_TIMESTAMP':_0x7206('0x65')};var _0x2bc18e=function(_0x55140e){return!_[_0x7206('0x7d')](['IS\x20NULL','IS\x20NOT\x20NULL',_0x7206('0x67'),_0x7206('0x8e')],_0x55140e);};var _0x4e2797=function(_0x16e7ef){if(!_0x16e7ef||!_0x16e7ef[_0x7206('0x68')]['length']){return'';}for(var _0x4e3866='(',_0x949067=0x0;_0x949067<_0x16e7ef[_0x7206('0x68')][_0x7206('0x37')];_0x949067+=0x1){_0x949067>0x0&&(_0x4e3866+='\x20'+_0x16e7ef['operator']+'\x20');_0x4e3866+=_0x16e7ef[_0x7206('0x68')][_0x949067]['group']?_0x4e2797(_0x16e7ef[_0x7206('0x68')][_0x949067][_0x7206('0x6a')]):_0x16e7ef[_0x7206('0x68')][_0x949067][_0x7206('0x6b')]+'\x20'+_0x16e7ef[_0x7206('0x68')][_0x949067][_0x7206('0x8f')]+(_0x2bc18e(_0x16e7ef[_0x7206('0x68')][_0x949067][_0x7206('0x8f')])?'\x20'+_0x16e7ef['rules'][_0x949067]['value']:'');}return _0x4e3866+')';};var _0x59bbd7={'where':{'id':_0x33fe57['id']}},_0x28acf5,_0x44adb4,_0x1cb424,_0x236a2c,_0x565c36;_0x59bbd7=_['merge']({},_0x59bbd7,_0x32ca33);return db[_0x7206('0x2e')][_0x7206('0x50')](_0x59bbd7)[_0x7206('0x41')](function(_0x610ebb){if(_0x610ebb){_0x28acf5=_0x610ebb;return _0x610ebb['getFields']();}return null;})[_0x7206('0x41')](function(_0x50389d){if(_0x50389d){if(!_0x50389d[_0x7206('0x37')]){throw new db[(_0x7206('0x6e'))][(_0x7206('0x6f'))](_0x7206('0x90'),0x193);}_0x44adb4=_0x50389d;return db['AnalyticMetric'][_0x7206('0x43')]({'raw':!![]});}return null;})['then'](function(_0x46ddc3){if(_0x46ddc3){_0x1cb424=_[_0x7206('0x71')](_0x46ddc3,'id');var _0x210e7e;var _0x4408ff=squel[_0x7206('0x72')]();_0x4408ff[_0x7206('0x73')](_0x28acf5[_0x7206('0x82')]);for(var _0x49376a=0x0;_0x49376a<_0x44adb4[_0x7206('0x37')];_0x49376a+=0x1){_0x210e7e=_0x44adb4[_0x49376a][_0x7206('0x74')]?_0x1cb424[_0x44adb4[_0x49376a][_0x7206('0x74')]][_0x7206('0x75')]:_0x44adb4[_0x49376a][_0x7206('0x6b')];_0x210e7e=_0x44adb4[_0x49376a][_0x7206('0x76')]?_['replace'](_0x2382f2[_0x44adb4[_0x49376a][_0x7206('0x76')]],'%s',_0x210e7e):_0x210e7e;_0x210e7e=_0x44adb4[_0x49376a][_0x7206('0x78')]?_[_0x7206('0x77')](_0x10ff1f[_0x44adb4[_0x49376a][_0x7206('0x78')]],'%s',_0x210e7e):_0x210e7e;if(_0x44adb4[_0x49376a][_0x7206('0x79')]){_0x4408ff[_0x7206('0x6a')](_0x210e7e);}_0x44adb4[_0x49376a][_0x7206('0x7a')]&&_0x4408ff[_0x7206('0x3a')](_0x210e7e,_0x44adb4[_0x49376a]['orderBy']==='DESC'?![]:!![]);_0x4408ff[_0x7206('0x6b')](_0x210e7e,_0x44adb4[_0x49376a][_0x7206('0x91')]||_0x210e7e);}if(_0x28acf5[_0x7206('0x7c')]){_0x28acf5['joins']=JSON[_0x7206('0x84')](_0x28acf5[_0x7206('0x7c')]);for(var _0x222fd9=0x0;_0x222fd9<_0x28acf5[_0x7206('0x7c')]['length'];_0x222fd9+=0x1){if(_0x28acf5['joins'][_0x222fd9]['type']&&_[_0x7206('0x7d')](_0x4684b4,_0x28acf5[_0x7206('0x7c')][_0x222fd9][_0x7206('0x30')])&&_0x28acf5[_0x7206('0x7c')][_0x222fd9][_0x7206('0x7e')]&&_0x28acf5[_0x7206('0x7c')][_0x222fd9][_0x7206('0x80')]&&_0x28acf5[_0x7206('0x7c')][_0x222fd9]['foreignKey']){_0x4408ff[_0x28acf5[_0x7206('0x7c')][_0x222fd9][_0x7206('0x30')]](_0x28acf5[_0x7206('0x7c')][_0x222fd9]['foreignTable'],null,util[_0x7206('0x78')](_0x7206('0x81'),_0x28acf5[_0x7206('0x82')],_0x28acf5['joins'][_0x222fd9][_0x7206('0x7e')],_0x28acf5['joins'][_0x222fd9][_0x7206('0x80')],_0x28acf5['joins'][_0x222fd9][_0x7206('0x7f')]));}}}if(_0x28acf5[_0x7206('0x83')]){_0x28acf5[_0x7206('0x83')]=JSON[_0x7206('0x84')](_0x28acf5[_0x7206('0x83')]);_0x4408ff[_0x7206('0x3b')](_0x4e2797(_0x28acf5['conditions'][_0x7206('0x6a')]));}_0x565c36=_0x4408ff[_0x7206('0x85')]();_0x4408ff[_0x7206('0x1f')](_0x533cf3);_0x4408ff[_0x7206('0x39')](0x0);logger[_0x7206('0x86')](_0x7206('0x87'),_0x4408ff['toString']());return db['sequelize'][_0x7206('0x33')](_0x4408ff[_0x7206('0x88')](),{'type':db[_0x7206('0x89')]['QueryTypes']['SELECT']});}})[_0x7206('0x41')](function(_0x51265c){if(!_0x51265c[_0x7206('0x37')]){throw new db[(_0x7206('0x6e'))][(_0x7206('0x6f'))](_0x7206('0x92'),0xcc);}if(_0x48aefa[_0x7206('0x93')]===_0x7206('0x94')){return null;}var _0x543761=_[_0x7206('0x3e')](_0x48aefa,{'name':_0x48aefa[_0x7206('0x95')]||_0x48aefa['name']||_0x28acf5['name'],'basename':_0x156810,'savename':util[_0x7206('0x78')](_0x7206('0x96'),_0x48aefa[_0x7206('0x2b')]||_0x28acf5[_0x7206('0x2b')],require('randomstring')[_0x7206('0x97')](0x4),_0x48aefa[_0x7206('0x93')]||_0x7206('0x98')),'reportId':_0x28acf5['id'],'reportType':_0x7206('0x99')});return db['AnalyticExtractedReport']['create'](_0x543761,{'raw':!![]});})[_0x7206('0x41')](function(_0x1a9f68){if(_0x28acf5[_0x7206('0x82')]===_0x7206('0x9a')){_0x565c36[_0x7206('0x3b')](_0x28acf5[_0x7206('0x82')]+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x48aefa['startDate'],_0x48aefa[_0x7206('0x9b')]);}else{_0x565c36[_0x7206('0x3b')](_0x28acf5['table']+_0x7206('0x9c'),_0x48aefa[_0x7206('0x9d')],_0x48aefa['endDate']);}if(_0x1a9f68){logger[_0x7206('0x9e')]('Run\x20Query:',_0x565c36['toString']());require(_0x7206('0x9f'))[_0x7206('0xa0')](path[_0x7206('0x8c')](__dirname,_0x7206('0xa1'),_0x1a9f68[_0x7206('0x93')]),[_0x1a9f68['id'],_0x565c36[_0x7206('0x88')](),path[_0x7206('0x8c')](__dirname,_0x7206('0xa2'),_0x1a9f68[_0x7206('0xa3')]),_0x156810]);return _0x1a9f68;}else{var _0x4b2412=squel[_0x7206('0x72')]();_0x4b2412[_0x7206('0x73')]('('+_0x565c36[_0x7206('0x88')]()+')',_0x7206('0xa4'));_0x4b2412['field'](_0x7206('0xa5'),_0x7206('0x1e'));_0x565c36[_0x7206('0x1f')](_0x48aefa[_0x7206('0x1f')]||_0x533cf3);_0x565c36[_0x7206('0x39')](_0x48aefa['offset']||0x0);return dbH[_0x7206('0x89')][_0x7206('0x33')](_0x4b2412['toString'](),{'type':dbH[_0x7206('0x89')][_0x7206('0x8a')][_0x7206('0x8b')]})[_0x7206('0x41')](function(_0x17ab06){if(!_0x17ab06['length']){_0x236a2c=0x0;}else{_0x236a2c=_0x17ab06[0x0][_0x7206('0x1e')]||0x0;}return dbH['sequelize'][_0x7206('0x33')](_0x565c36[_0x7206('0x88')](),{'type':dbH[_0x7206('0x89')][_0x7206('0x8a')][_0x7206('0x8b')]});})[_0x7206('0x41')](function(_0x4168fe){return{'rows':_0x4168fe||[],'count':_0x236a2c};});}});}exports['run']=function(_0x59625b,_0xeb3252){return runReport(_0x59625b[_0x7206('0x45')],_0x59625b[_0x7206('0x33')],_0x59625b['options'])['then'](respondWithResult(_0xeb3252,null))[_0x7206('0x44')](handleError(_0xeb3252,null));};exports[_0x7206('0xa6')]=runReport;exports['query']=function(_0x36faa9,_0x4ab8fc){var _0x33d3fc=0xa;var _0x258ecd=[_0x7206('0x8c'),_0x7206('0x56'),_0x7206('0x57'),_0x7206('0x58')];var _0x37d5e0={'SUM':_0x7206('0x59'),'COUNT':_0x7206('0x5a'),'COUNT DISTINCT':_0x7206('0x8d'),'MAX':_0x7206('0x5b'),'MIN':_0x7206('0x5c'),'AVG':_0x7206('0x5d'),'GROUP_CONCAT':_0x7206('0x5e'),'GROUP_CONCAT ASC':_0x7206('0x5f'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x5cad48={'SEC_TO_TIME':_0x7206('0x61'),'DATE':_0x7206('0x62'),'HOUR':'HOUR(%s)','ROUND':_0x7206('0x64'),'UNIX_TIMESTAMP':_0x7206('0x65')};var _0x3f1cd2=function(_0x1ff876){return!_['includes'](['IS\x20NULL',_0x7206('0x66'),_0x7206('0x67'),_0x7206('0x8e')],_0x1ff876);};var _0xaaf2b6=function(_0x501e23){if(!_0x501e23||!_0x501e23[_0x7206('0x68')][_0x7206('0x37')]){return'';}for(var _0x4c5f39='(',_0x22b260=0x0;_0x22b260<_0x501e23[_0x7206('0x68')][_0x7206('0x37')];_0x22b260+=0x1){_0x22b260>0x0&&(_0x4c5f39+='\x20'+_0x501e23[_0x7206('0x69')]+'\x20');_0x4c5f39+=_0x501e23[_0x7206('0x68')][_0x22b260][_0x7206('0x6a')]?_0xaaf2b6(_0x501e23[_0x7206('0x68')][_0x22b260][_0x7206('0x6a')]):_0x501e23['rules'][_0x22b260]['field']+'\x20'+_0x501e23[_0x7206('0x68')][_0x22b260][_0x7206('0x8f')]+(_0x3f1cd2(_0x501e23[_0x7206('0x68')][_0x22b260][_0x7206('0x8f')])?'\x20'+_0x501e23[_0x7206('0x68')][_0x22b260]['value']:'');}return _0x4c5f39+')';};var _0x48abb4={'where':{'id':_0x36faa9[_0x7206('0x45')]['id']}},_0x4d30ae,_0x253958,_0x57478f,_0x3aae29,_0x119f75;_0x48abb4=_[_0x7206('0x3e')]({},_0x48abb4,_0x36faa9[_0x7206('0x40')]);return db[_0x7206('0x2e')][_0x7206('0x50')](_0x48abb4)[_0x7206('0x41')](function(_0x4136e3){if(_0x4136e3){_0x4d30ae=_0x4136e3;return _0x4136e3['getFields']();}return null;})[_0x7206('0x41')](function(_0x18c2c5){if(_0x18c2c5){if(!_0x18c2c5['length']){throw new db[(_0x7206('0x6e'))]['ValidationErrorItem'](_0x7206('0x90'),0x193);}_0x253958=_0x18c2c5;return db[_0x7206('0x70')][_0x7206('0x43')]({'raw':!![]});}return null;})[_0x7206('0x41')](function(_0x4be336){if(_0x4be336){_0x57478f=_[_0x7206('0x71')](_0x4be336,'id');var _0x162b4e;var _0x318468=squel['select']();_0x318468[_0x7206('0x73')](_0x4d30ae[_0x7206('0x82')]);for(var _0x48d741=0x0;_0x48d741<_0x253958[_0x7206('0x37')];_0x48d741+=0x1){_0x162b4e=_0x253958[_0x48d741][_0x7206('0x74')]?_0x57478f[_0x253958[_0x48d741][_0x7206('0x74')]]['metric']:_0x253958[_0x48d741]['field'];_0x162b4e=_0x253958[_0x48d741][_0x7206('0x76')]?_['replace'](_0x37d5e0[_0x253958[_0x48d741][_0x7206('0x76')]],'%s',_0x162b4e):_0x162b4e;_0x162b4e=_0x253958[_0x48d741][_0x7206('0x78')]?_[_0x7206('0x77')](_0x5cad48[_0x253958[_0x48d741][_0x7206('0x78')]],'%s',_0x162b4e):_0x162b4e;if(_0x253958[_0x48d741]['groupBy']){_0x318468['group'](_0x162b4e);}_0x253958[_0x48d741][_0x7206('0x7a')]&&_0x318468[_0x7206('0x3a')](_0x162b4e,_0x253958[_0x48d741][_0x7206('0x7a')]===_0x7206('0x7b')?![]:!![]);_0x318468[_0x7206('0x6b')](_0x162b4e,_0x253958[_0x48d741][_0x7206('0x91')]||_0x162b4e);}if(_0x4d30ae[_0x7206('0x7c')]){_0x4d30ae[_0x7206('0x7c')]=JSON[_0x7206('0x84')](_0x4d30ae[_0x7206('0x7c')]);for(var _0x3c6b76=0x0;_0x3c6b76<_0x4d30ae[_0x7206('0x7c')][_0x7206('0x37')];_0x3c6b76+=0x1){if(_0x4d30ae[_0x7206('0x7c')][_0x3c6b76][_0x7206('0x30')]&&_['includes'](_0x258ecd,_0x4d30ae['joins'][_0x3c6b76][_0x7206('0x30')])&&_0x4d30ae[_0x7206('0x7c')][_0x3c6b76][_0x7206('0x7e')]&&_0x4d30ae[_0x7206('0x7c')][_0x3c6b76][_0x7206('0x80')]&&_0x4d30ae[_0x7206('0x7c')][_0x3c6b76][_0x7206('0x7f')]){_0x318468[_0x4d30ae['joins'][_0x3c6b76][_0x7206('0x30')]](_0x4d30ae[_0x7206('0x7c')][_0x3c6b76][_0x7206('0x80')],null,util[_0x7206('0x78')](_0x7206('0x81'),_0x4d30ae[_0x7206('0x82')],_0x4d30ae[_0x7206('0x7c')][_0x3c6b76][_0x7206('0x7e')],_0x4d30ae[_0x7206('0x7c')][_0x3c6b76][_0x7206('0x80')],_0x4d30ae[_0x7206('0x7c')][_0x3c6b76]['foreignKey']));}}}if(_0x4d30ae[_0x7206('0x83')]){_0x4d30ae[_0x7206('0x83')]=JSON[_0x7206('0x84')](_0x4d30ae[_0x7206('0x83')]);_0x318468[_0x7206('0x3b')](_0xaaf2b6(_0x4d30ae[_0x7206('0x83')][_0x7206('0x6a')]));}_0x119f75=_0x318468['clone']();_0x318468[_0x7206('0x1f')](_0x33d3fc);_0x318468['offset'](0x0);logger[_0x7206('0x86')](_0x7206('0x87'),_0x318468[_0x7206('0x88')]());return db[_0x7206('0x89')][_0x7206('0x33')](_0x318468[_0x7206('0x88')](),{'type':db[_0x7206('0x89')][_0x7206('0x8a')]['SELECT']});}})[_0x7206('0x41')](function(){return{'sql':_0x119f75[_0x7206('0x88')]()};})['then'](respondWithResult(_0x4ab8fc,null))[_0x7206('0x44')](handleError(_0x4ab8fc,null));};
\ No newline at end of file
+var _0xe532=['name','query','keys','filters','intersection','model','attributes','fields','length','hasOwnProperty','sort','where','filter','merge','VIRTUAL','options','includeAll','findAll','rows','catch','params','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','userProfileId','DefaultReports','error','body','join','left_join','right_join','cross_join','SUM(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%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','IS\x20EMPTY','rules','operator','group','field','condition','value','ValidationErrorItem','AnalyticMetric','keyBy','select','MetricId','metric','function','format','replace','orderBy','order','DESC','alias','joins','parse','parentKey','%s.%s\x20=\x20%s.%s','foreignTable','foreignKey','conditions','clone','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','AVG(%s)','GROUP_CONCAT(%s)','IS\x20NOT\x20NULL','IS\x20NOT\x20EMPTY','getFields','Sequelize','Please\x20insert\x20at\x20least\x20one\x20field','from','groupBy','table','No\x20available\x20data','output','web','fullPath','%s-%s.%s','generate','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','startDate','info','fork','../../components/export/','countTable','COUNT(*)','runReport','COUNT(%s)','debug','html-pdf','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','sox','to-csv','ejs','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','dbH','sendStatus','end','status','json','count','offset','limit','set','apply','reject','update','then','destroy','get','UserProfileResource','stack','index','map','AnalyticDefaultReport','rawAttributes','fieldName','type','key'];(function(_0x4d4812,_0x5c4e9c){var _0x472210=function(_0x309b02){while(--_0x309b02){_0x4d4812['push'](_0x4d4812['shift']());}};_0x472210(++_0x5c4e9c);}(_0xe532,0x6e));var _0x2e53=function(_0x54edc9,_0x345f01){_0x54edc9=_0x54edc9-0x0;var _0x2ae7a9=_0xe532[_0x54edc9];return _0x2ae7a9;};'use strict';var pdf=require(_0x2e53('0x0'));var emlformat=require(_0x2e53('0x1'));var rimraf=require('rimraf');var zipdir=require(_0x2e53('0x2'));var jsonpatch=require(_0x2e53('0x3'));var rp=require(_0x2e53('0x4'));var moment=require(_0x2e53('0x5'));var BPromise=require(_0x2e53('0x6'));var Mustache=require('mustache');var util=require(_0x2e53('0x7'));var path=require('path');var sox=require(_0x2e53('0x8'));var csv=require(_0x2e53('0x9'));var ejs=require(_0x2e53('0xa'));var fs=require('fs');var _=require('lodash');var squel=require(_0x2e53('0xb'));var crypto=require('crypto');var jsforce=require(_0x2e53('0xc'));var deskjs=require(_0x2e53('0xd'));var toCsv=require('to-csv');var querystring=require(_0x2e53('0xe'));var Papa=require(_0x2e53('0xf'));var Redis=require(_0x2e53('0x10'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0x2e53('0x11'));var hardwareService=require(_0x2e53('0x12'));var logger=require(_0x2e53('0x13'))(_0x2e53('0x14'));var utils=require(_0x2e53('0x15'));var config=require(_0x2e53('0x16'));var db=require(_0x2e53('0x17'))['db'];var dbH=require(_0x2e53('0x17'))[_0x2e53('0x18')];function respondWithStatusCode(_0x1b2689,_0x279ac7){_0x279ac7=_0x279ac7||0xcc;return function(_0x27acfe){if(_0x27acfe){return _0x1b2689[_0x2e53('0x19')](_0x279ac7);}return _0x1b2689['status'](_0x279ac7)[_0x2e53('0x1a')]();};}function respondWithResult(_0xf0ae81,_0x28516f){_0x28516f=_0x28516f||0xc8;return function(_0x302ddc){if(_0x302ddc){return _0xf0ae81[_0x2e53('0x1b')](_0x28516f)[_0x2e53('0x1c')](_0x302ddc);}};}function respondWithFilteredResult(_0x24ec11,_0x1140ae){return function(_0x104b6c){if(_0x104b6c){var _0x1d13a3=_0x104b6c[_0x2e53('0x1d')],_0x3702a7=_0x1140ae[_0x2e53('0x1e')],_0x548800=_0x1140ae[_0x2e53('0x1e')]+_0x1140ae[_0x2e53('0x1f')],_0x16bf65;if(_0x548800>=_0x1d13a3){_0x548800=_0x1d13a3;_0x16bf65=0xc8;}else{_0x16bf65=0xce;}_0x24ec11[_0x2e53('0x1b')](_0x16bf65);return _0x24ec11[_0x2e53('0x20')]('Content-Range',_0x3702a7+'-'+_0x548800+'/'+_0x1d13a3)[_0x2e53('0x1c')](_0x104b6c);}return null;};}function patchUpdates(_0x2b382c){return function(_0x1e4c80){try{jsonpatch[_0x2e53('0x21')](_0x1e4c80,_0x2b382c,!![]);}catch(_0xdd3a40){return BPromise[_0x2e53('0x22')](_0xdd3a40);}return _0x1e4c80['save']();};}function saveUpdates(_0x4123e5,_0x32ac95){return function(_0x4958bf){if(_0x4958bf){return _0x4958bf[_0x2e53('0x23')](_0x4123e5)[_0x2e53('0x24')](function(_0x49b5c6){return _0x49b5c6;});}return null;};}function removeEntity(_0x18bbc6,_0x287cc4){return function(_0x4a4dcd){if(_0x4a4dcd){return _0x4a4dcd[_0x2e53('0x25')]()['then'](function(){var _0x279bcc=_0x4a4dcd[_0x2e53('0x26')]({'plain':!![]});var _0x3bbffe='DefaultReports';return db[_0x2e53('0x27')][_0x2e53('0x25')]({'where':{'type':_0x3bbffe,'resourceId':_0x279bcc['id']}})[_0x2e53('0x24')](function(){return _0x4a4dcd;});})[_0x2e53('0x24')](function(){_0x18bbc6[_0x2e53('0x1b')](0xcc)[_0x2e53('0x1a')]();});}};}function handleEntityNotFound(_0x1e8084,_0x315483){return function(_0x311c86){if(!_0x311c86){_0x1e8084[_0x2e53('0x19')](0x194);}return _0x311c86;};}function handleError(_0x4e39a8,_0x3ac808){_0x3ac808=_0x3ac808||0x1f4;return function(_0x47e372){logger['error'](_0x47e372[_0x2e53('0x28')]);if(_0x47e372['name']){delete _0x47e372['name'];}_0x4e39a8[_0x2e53('0x1b')](_0x3ac808)['send'](_0x47e372);};}exports[_0x2e53('0x29')]=function(_0x3b882a,_0x47dad6){var _0x39f1f1={},_0x404335={},_0x5623ba={'count':0x0,'rows':[]};var _0x37f2fb=_[_0x2e53('0x2a')](db[_0x2e53('0x2b')][_0x2e53('0x2c')],function(_0x2ff8c9){return{'name':_0x2ff8c9[_0x2e53('0x2d')],'type':_0x2ff8c9[_0x2e53('0x2e')][_0x2e53('0x2f')]};});_0x404335['model']=_['map'](_0x37f2fb,_0x2e53('0x30'));_0x404335[_0x2e53('0x31')]=_[_0x2e53('0x32')](_0x3b882a[_0x2e53('0x31')]);_0x404335[_0x2e53('0x33')]=_[_0x2e53('0x34')](_0x404335[_0x2e53('0x35')],_0x404335['query']);_0x39f1f1[_0x2e53('0x36')]=_[_0x2e53('0x34')](_0x404335[_0x2e53('0x35')],qs[_0x2e53('0x37')](_0x3b882a[_0x2e53('0x31')][_0x2e53('0x37')]));_0x39f1f1[_0x2e53('0x36')]=_0x39f1f1['attributes'][_0x2e53('0x38')]?_0x39f1f1[_0x2e53('0x36')]:_0x404335['model'];if(!_0x3b882a[_0x2e53('0x31')][_0x2e53('0x39')]('nolimit')){_0x39f1f1[_0x2e53('0x1f')]=qs['limit'](_0x3b882a[_0x2e53('0x31')][_0x2e53('0x1f')]);_0x39f1f1[_0x2e53('0x1e')]=qs[_0x2e53('0x1e')](_0x3b882a['query'][_0x2e53('0x1e')]);}_0x39f1f1['order']=qs[_0x2e53('0x3a')](_0x3b882a['query']['sort']);_0x39f1f1[_0x2e53('0x3b')]=qs['filters'](_['pick'](_0x3b882a[_0x2e53('0x31')],_0x404335[_0x2e53('0x33')]),_0x37f2fb);if(_0x3b882a['query'][_0x2e53('0x3c')]){_0x39f1f1[_0x2e53('0x3b')]=_[_0x2e53('0x3d')](_0x39f1f1[_0x2e53('0x3b')],{'$or':_['map'](_0x37f2fb,function(_0x78c5e4){if(_0x78c5e4[_0x2e53('0x2e')]!==_0x2e53('0x3e')){var _0x524b97={};_0x524b97[_0x78c5e4[_0x2e53('0x30')]]={'$like':'%'+_0x3b882a[_0x2e53('0x31')][_0x2e53('0x3c')]+'%'};return _0x524b97;}})});}_0x39f1f1=_['merge']({},_0x39f1f1,_0x3b882a[_0x2e53('0x3f')]);var _0xa43024={'where':_0x39f1f1[_0x2e53('0x3b')]};return db[_0x2e53('0x2b')]['count'](_0xa43024)[_0x2e53('0x24')](function(_0x2ac822){_0x5623ba[_0x2e53('0x1d')]=_0x2ac822;if(_0x3b882a[_0x2e53('0x31')][_0x2e53('0x40')]){_0x39f1f1['include']=[{'all':!![]}];}return db[_0x2e53('0x2b')][_0x2e53('0x41')](_0x39f1f1);})[_0x2e53('0x24')](function(_0x5d8bbe){_0x5623ba[_0x2e53('0x42')]=_0x5d8bbe;return _0x5623ba;})[_0x2e53('0x24')](respondWithFilteredResult(_0x47dad6,_0x39f1f1))[_0x2e53('0x43')](handleError(_0x47dad6,null));};exports['show']=function(_0x3f7443,_0x3fcba9){var _0x2267d4={'raw':!![],'where':{'id':_0x3f7443[_0x2e53('0x44')]['id']}},_0x306b93={};_0x306b93['model']=_[_0x2e53('0x32')](db['AnalyticDefaultReport'][_0x2e53('0x2c')]);_0x306b93[_0x2e53('0x31')]=_['keys'](_0x3f7443[_0x2e53('0x31')]);_0x306b93[_0x2e53('0x33')]=_['intersection'](_0x306b93[_0x2e53('0x35')],_0x306b93['query']);_0x2267d4['attributes']=_[_0x2e53('0x34')](_0x306b93['model'],qs[_0x2e53('0x37')](_0x3f7443[_0x2e53('0x31')][_0x2e53('0x37')]));_0x2267d4[_0x2e53('0x36')]=_0x2267d4[_0x2e53('0x36')][_0x2e53('0x38')]?_0x2267d4['attributes']:_0x306b93[_0x2e53('0x35')];if(_0x3f7443[_0x2e53('0x31')]['includeAll']){_0x2267d4['include']=[{'all':!![]}];}_0x2267d4=_['merge']({},_0x2267d4,_0x3f7443[_0x2e53('0x3f')]);return db[_0x2e53('0x2b')][_0x2e53('0x45')](_0x2267d4)[_0x2e53('0x24')](handleEntityNotFound(_0x3fcba9,null))[_0x2e53('0x24')](respondWithResult(_0x3fcba9,null))[_0x2e53('0x43')](handleError(_0x3fcba9,null));};exports[_0x2e53('0x46')]=function(_0x12c2db,_0x302f7b){return db['AnalyticDefaultReport'][_0x2e53('0x46')](_0x12c2db['body'],{})['then'](function(_0x27f3ad){var _0x2a7c71=_0x12c2db[_0x2e53('0x47')][_0x2e53('0x26')]({'plain':!![]});if(!_0x2a7c71)throw new Error(_0x2e53('0x48'));if(_0x2a7c71[_0x2e53('0x49')]===_0x2e53('0x47')){var _0x5b6bb4=_0x27f3ad[_0x2e53('0x26')]({'plain':!![]});var _0x41668c='Reports';return db['UserProfileSection'][_0x2e53('0x45')]({'where':{'name':_0x41668c,'userProfileId':_0x2a7c71[_0x2e53('0x4a')]},'raw':!![]})[_0x2e53('0x24')](function(_0x525b87){if(_0x525b87&&_0x525b87['autoAssociation']===0x0){return db[_0x2e53('0x27')][_0x2e53('0x46')]({'name':_0x5b6bb4[_0x2e53('0x30')],'resourceId':_0x5b6bb4['id'],'type':_0x2e53('0x4b'),'sectionId':_0x525b87['id']},{})[_0x2e53('0x24')](function(){return _0x27f3ad;});}else{return _0x27f3ad;}})[_0x2e53('0x43')](function(_0x569f14){logger[_0x2e53('0x4c')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x569f14);throw _0x569f14;});}return _0x27f3ad;})['then'](respondWithResult(_0x302f7b,0xc9))['catch'](handleError(_0x302f7b,null));};exports[_0x2e53('0x23')]=function(_0x39938a,_0x40542b){if(_0x39938a[_0x2e53('0x4d')]['id']){delete _0x39938a[_0x2e53('0x4d')]['id'];}return db[_0x2e53('0x2b')][_0x2e53('0x45')]({'where':{'id':_0x39938a[_0x2e53('0x44')]['id']}})['then'](handleEntityNotFound(_0x40542b,null))['then'](saveUpdates(_0x39938a[_0x2e53('0x4d')],null))[_0x2e53('0x24')](respondWithResult(_0x40542b,null))[_0x2e53('0x43')](handleError(_0x40542b,null));};exports['destroy']=function(_0x535ada,_0x46e2eb){return db[_0x2e53('0x2b')][_0x2e53('0x45')]({'where':{'id':_0x535ada[_0x2e53('0x44')]['id']}})['then'](handleEntityNotFound(_0x46e2eb,null))[_0x2e53('0x24')](removeEntity(_0x46e2eb,null))['catch'](handleError(_0x46e2eb,null));};exports['preview']=function(_0x3daa02,_0x4fda77){var _0x4ad043=0xa;var _0x38a88f=[_0x2e53('0x4e'),_0x2e53('0x4f'),_0x2e53('0x50'),_0x2e53('0x51')];var _0x3fa006={'SUM':_0x2e53('0x52'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x2e53('0x53'),'MAX':_0x2e53('0x54'),'MIN':_0x2e53('0x55'),'AVG':'AVG(%s)','GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x2e53('0x56'),'GROUP_CONCAT DESC':_0x2e53('0x57')};var _0x545334={'SEC_TO_TIME':_0x2e53('0x58'),'DATE':_0x2e53('0x59'),'HOUR':_0x2e53('0x5a'),'ROUND':_0x2e53('0x5b'),'UNIX_TIMESTAMP':_0x2e53('0x5c')};var _0x5f121b=function(_0xb35e96){return!_[_0x2e53('0x5d')]([_0x2e53('0x5e'),'IS\x20NOT\x20NULL',_0x2e53('0x5f'),'IS\x20NOT\x20EMPTY'],_0xb35e96);};var _0x1a24ce=function(_0xcc674d){if(!_0xcc674d||!_0xcc674d[_0x2e53('0x60')]['length']){return'';}for(var _0x3b0712='(',_0x586f17=0x0;_0x586f17<_0xcc674d[_0x2e53('0x60')]['length'];_0x586f17+=0x1){_0x586f17>0x0&&(_0x3b0712+='\x20'+_0xcc674d[_0x2e53('0x61')]+'\x20');_0x3b0712+=_0xcc674d[_0x2e53('0x60')][_0x586f17][_0x2e53('0x62')]?_0x1a24ce(_0xcc674d[_0x2e53('0x60')][_0x586f17][_0x2e53('0x62')]):_0xcc674d[_0x2e53('0x60')][_0x586f17][_0x2e53('0x63')]+'\x20'+_0xcc674d[_0x2e53('0x60')][_0x586f17]['condition']+(_0x5f121b(_0xcc674d[_0x2e53('0x60')][_0x586f17][_0x2e53('0x64')])?'\x20'+_0xcc674d[_0x2e53('0x60')][_0x586f17][_0x2e53('0x65')]:'');}return _0x3b0712+')';};var _0x5382d4={'where':{'id':_0x3daa02[_0x2e53('0x44')]['id']}},_0x500525,_0x11efd5,_0x539165,_0x472802,_0x44600e;_0x5382d4=_[_0x2e53('0x3d')]({},_0x5382d4,_0x3daa02[_0x2e53('0x3f')]);return db[_0x2e53('0x2b')]['find'](_0x5382d4)[_0x2e53('0x24')](function(_0x1e4a15){if(_0x1e4a15){_0x500525=_0x1e4a15;return _0x1e4a15['getFields']();}return null;})[_0x2e53('0x24')](function(_0x21c1ea){if(_0x21c1ea){if(!_0x21c1ea['length']){throw new db['Sequelize'][(_0x2e53('0x66'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x11efd5=_0x21c1ea;return db[_0x2e53('0x67')][_0x2e53('0x41')]({'raw':!![]});}return null;})['then'](function(_0x4d7d65){if(_0x4d7d65){_0x539165=_[_0x2e53('0x68')](_0x4d7d65,'id');var _0x14b597;var _0x4bbdd2=squel[_0x2e53('0x69')]();_0x4bbdd2['from'](_0x500525['table']);for(var _0x30e8c1=0x0;_0x30e8c1<_0x11efd5['length'];_0x30e8c1+=0x1){_0x14b597=_0x11efd5[_0x30e8c1][_0x2e53('0x6a')]?_0x539165[_0x11efd5[_0x30e8c1][_0x2e53('0x6a')]][_0x2e53('0x6b')]:_0x11efd5[_0x30e8c1]['field'];_0x14b597=_0x11efd5[_0x30e8c1]['function']?_['replace'](_0x3fa006[_0x11efd5[_0x30e8c1][_0x2e53('0x6c')]],'%s',_0x14b597):_0x14b597;_0x14b597=_0x11efd5[_0x30e8c1][_0x2e53('0x6d')]?_[_0x2e53('0x6e')](_0x545334[_0x11efd5[_0x30e8c1][_0x2e53('0x6d')]],'%s',_0x14b597):_0x14b597;if(_0x11efd5[_0x30e8c1]['groupBy']){_0x4bbdd2['group'](_0x14b597);}_0x11efd5[_0x30e8c1][_0x2e53('0x6f')]&&_0x4bbdd2[_0x2e53('0x70')](_0x14b597,_0x11efd5[_0x30e8c1][_0x2e53('0x6f')]===_0x2e53('0x71')?![]:!![]);_0x4bbdd2[_0x2e53('0x63')](_0x14b597,_0x11efd5[_0x30e8c1][_0x2e53('0x72')]||_0x14b597);}if(_0x500525[_0x2e53('0x73')]){_0x500525[_0x2e53('0x73')]=JSON[_0x2e53('0x74')](_0x500525[_0x2e53('0x73')]);for(var _0x55e443=0x0;_0x55e443<_0x500525[_0x2e53('0x73')][_0x2e53('0x38')];_0x55e443+=0x1){if(_0x500525[_0x2e53('0x73')][_0x55e443]['type']&&_[_0x2e53('0x5d')](_0x38a88f,_0x500525[_0x2e53('0x73')][_0x55e443][_0x2e53('0x2e')])&&_0x500525[_0x2e53('0x73')][_0x55e443][_0x2e53('0x75')]&&_0x500525[_0x2e53('0x73')][_0x55e443]['foreignTable']&&_0x500525[_0x2e53('0x73')][_0x55e443]['foreignKey']){_0x4bbdd2[_0x500525[_0x2e53('0x73')][_0x55e443]['type']](_0x500525[_0x2e53('0x73')][_0x55e443]['foreignTable'],null,util[_0x2e53('0x6d')](_0x2e53('0x76'),_0x500525['table'],_0x500525['joins'][_0x55e443][_0x2e53('0x75')],_0x500525[_0x2e53('0x73')][_0x55e443][_0x2e53('0x77')],_0x500525[_0x2e53('0x73')][_0x55e443][_0x2e53('0x78')]));}}}if(_0x500525[_0x2e53('0x79')]){_0x500525[_0x2e53('0x79')]=JSON[_0x2e53('0x74')](_0x500525[_0x2e53('0x79')]);_0x4bbdd2[_0x2e53('0x3b')](_0x1a24ce(_0x500525[_0x2e53('0x79')][_0x2e53('0x62')]));}_0x44600e=_0x4bbdd2[_0x2e53('0x7a')]();_0x4bbdd2['limit'](_0x4ad043);_0x4bbdd2['offset'](0x0);logger['debug'](_0x2e53('0x7b'),_0x4bbdd2[_0x2e53('0x7c')]());return db[_0x2e53('0x7d')][_0x2e53('0x31')](_0x4bbdd2['toString'](),{'type':db['sequelize'][_0x2e53('0x7e')][_0x2e53('0x7f')]});}})[_0x2e53('0x24')](respondWithResult(_0x4fda77,null))['catch'](handleError(_0x4fda77,null));};function runReport(_0x2d3d9c,_0x336e94,_0x3d4481){var _0x1f6aa1=_0x336e94['name'];var _0x4b2790=0xa;var _0x3cd2f1=[_0x2e53('0x4e'),'left_join',_0x2e53('0x50'),_0x2e53('0x51')];var _0x4ddb1b={'SUM':_0x2e53('0x52'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x2e53('0x53'),'MAX':_0x2e53('0x54'),'MIN':_0x2e53('0x55'),'AVG':_0x2e53('0x80'),'GROUP_CONCAT':_0x2e53('0x81'),'GROUP_CONCAT ASC':_0x2e53('0x56'),'GROUP_CONCAT DESC':_0x2e53('0x57')};var _0x1a8f0b={'SEC_TO_TIME':_0x2e53('0x58'),'DATE':_0x2e53('0x59'),'HOUR':_0x2e53('0x5a'),'ROUND':_0x2e53('0x5b'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x1b6578=function(_0x49876a){return!_['includes']([_0x2e53('0x5e'),_0x2e53('0x82'),_0x2e53('0x5f'),_0x2e53('0x83')],_0x49876a);};var _0x4cf834=function(_0x15ee4b){if(!_0x15ee4b||!_0x15ee4b[_0x2e53('0x60')][_0x2e53('0x38')]){return'';}for(var _0x190690='(',_0x1232a2=0x0;_0x1232a2<_0x15ee4b[_0x2e53('0x60')][_0x2e53('0x38')];_0x1232a2+=0x1){_0x1232a2>0x0&&(_0x190690+='\x20'+_0x15ee4b[_0x2e53('0x61')]+'\x20');_0x190690+=_0x15ee4b['rules'][_0x1232a2][_0x2e53('0x62')]?_0x4cf834(_0x15ee4b[_0x2e53('0x60')][_0x1232a2][_0x2e53('0x62')]):_0x15ee4b['rules'][_0x1232a2][_0x2e53('0x63')]+'\x20'+_0x15ee4b[_0x2e53('0x60')][_0x1232a2][_0x2e53('0x64')]+(_0x1b6578(_0x15ee4b[_0x2e53('0x60')][_0x1232a2][_0x2e53('0x64')])?'\x20'+_0x15ee4b[_0x2e53('0x60')][_0x1232a2][_0x2e53('0x65')]:'');}return _0x190690+')';};var _0x474c3f={'where':{'id':_0x2d3d9c['id']}},_0x2b4e86,_0x183d94,_0x171965,_0x35f676,_0x58d5f5;_0x474c3f=_[_0x2e53('0x3d')]({},_0x474c3f,_0x3d4481);return db[_0x2e53('0x2b')][_0x2e53('0x45')](_0x474c3f)[_0x2e53('0x24')](function(_0x2c4b44){if(_0x2c4b44){_0x2b4e86=_0x2c4b44;return _0x2c4b44[_0x2e53('0x84')]();}return null;})[_0x2e53('0x24')](function(_0x5c92a6){if(_0x5c92a6){if(!_0x5c92a6[_0x2e53('0x38')]){throw new db[(_0x2e53('0x85'))][(_0x2e53('0x66'))](_0x2e53('0x86'),0x193);}_0x183d94=_0x5c92a6;return db[_0x2e53('0x67')][_0x2e53('0x41')]({'raw':!![]});}return null;})[_0x2e53('0x24')](function(_0x548823){if(_0x548823){_0x171965=_['keyBy'](_0x548823,'id');var _0xaa7ea4;var _0x5f00f8=squel[_0x2e53('0x69')]();_0x5f00f8[_0x2e53('0x87')](_0x2b4e86['table']);for(var _0xba2ff1=0x0;_0xba2ff1<_0x183d94[_0x2e53('0x38')];_0xba2ff1+=0x1){_0xaa7ea4=_0x183d94[_0xba2ff1][_0x2e53('0x6a')]?_0x171965[_0x183d94[_0xba2ff1][_0x2e53('0x6a')]][_0x2e53('0x6b')]:_0x183d94[_0xba2ff1][_0x2e53('0x63')];_0xaa7ea4=_0x183d94[_0xba2ff1]['function']?_[_0x2e53('0x6e')](_0x4ddb1b[_0x183d94[_0xba2ff1]['function']],'%s',_0xaa7ea4):_0xaa7ea4;_0xaa7ea4=_0x183d94[_0xba2ff1]['format']?_[_0x2e53('0x6e')](_0x1a8f0b[_0x183d94[_0xba2ff1]['format']],'%s',_0xaa7ea4):_0xaa7ea4;if(_0x183d94[_0xba2ff1][_0x2e53('0x88')]){_0x5f00f8[_0x2e53('0x62')](_0xaa7ea4);}_0x183d94[_0xba2ff1][_0x2e53('0x6f')]&&_0x5f00f8[_0x2e53('0x70')](_0xaa7ea4,_0x183d94[_0xba2ff1][_0x2e53('0x6f')]===_0x2e53('0x71')?![]:!![]);_0x5f00f8[_0x2e53('0x63')](_0xaa7ea4,_0x183d94[_0xba2ff1][_0x2e53('0x72')]||_0xaa7ea4);}if(_0x2b4e86[_0x2e53('0x73')]){_0x2b4e86['joins']=JSON[_0x2e53('0x74')](_0x2b4e86['joins']);for(var _0x49bf90=0x0;_0x49bf90<_0x2b4e86[_0x2e53('0x73')]['length'];_0x49bf90+=0x1){if(_0x2b4e86[_0x2e53('0x73')][_0x49bf90]['type']&&_[_0x2e53('0x5d')](_0x3cd2f1,_0x2b4e86[_0x2e53('0x73')][_0x49bf90][_0x2e53('0x2e')])&&_0x2b4e86[_0x2e53('0x73')][_0x49bf90]['parentKey']&&_0x2b4e86[_0x2e53('0x73')][_0x49bf90]['foreignTable']&&_0x2b4e86[_0x2e53('0x73')][_0x49bf90][_0x2e53('0x78')]){_0x5f00f8[_0x2b4e86[_0x2e53('0x73')][_0x49bf90][_0x2e53('0x2e')]](_0x2b4e86['joins'][_0x49bf90]['foreignTable'],null,util[_0x2e53('0x6d')]('%s.%s\x20=\x20%s.%s',_0x2b4e86[_0x2e53('0x89')],_0x2b4e86[_0x2e53('0x73')][_0x49bf90]['parentKey'],_0x2b4e86[_0x2e53('0x73')][_0x49bf90]['foreignTable'],_0x2b4e86[_0x2e53('0x73')][_0x49bf90][_0x2e53('0x78')]));}}}if(_0x2b4e86['conditions']){_0x2b4e86[_0x2e53('0x79')]=JSON[_0x2e53('0x74')](_0x2b4e86[_0x2e53('0x79')]);_0x5f00f8[_0x2e53('0x3b')](_0x4cf834(_0x2b4e86[_0x2e53('0x79')][_0x2e53('0x62')]));}_0x58d5f5=_0x5f00f8['clone']();_0x5f00f8[_0x2e53('0x1f')](_0x4b2790);_0x5f00f8[_0x2e53('0x1e')](0x0);logger['debug'](_0x2e53('0x7b'),_0x5f00f8['toString']());return db[_0x2e53('0x7d')][_0x2e53('0x31')](_0x5f00f8[_0x2e53('0x7c')](),{'type':db['sequelize'][_0x2e53('0x7e')][_0x2e53('0x7f')]});}})[_0x2e53('0x24')](function(_0x327b81){if(!_0x327b81['length']){throw new db['Sequelize']['ValidationErrorItem'](_0x2e53('0x8a'),0xcc);}if(_0x336e94[_0x2e53('0x8b')]===_0x2e53('0x8c')){return null;}var _0x13c726=_['merge'](_0x336e94,{'name':_0x336e94[_0x2e53('0x8d')]||_0x336e94[_0x2e53('0x30')]||_0x2b4e86['name'],'basename':_0x1f6aa1,'savename':util[_0x2e53('0x6d')](_0x2e53('0x8e'),_0x336e94[_0x2e53('0x30')]||_0x2b4e86['name'],require('randomstring')[_0x2e53('0x8f')](0x4),_0x336e94[_0x2e53('0x8b')]||'csv'),'reportId':_0x2b4e86['id'],'reportType':'default'});return db[_0x2e53('0x90')][_0x2e53('0x46')](_0x13c726,{'raw':!![]});})[_0x2e53('0x24')](function(_0x674b42){if(_0x2b4e86[_0x2e53('0x89')]===_0x2e53('0x91')){_0x58d5f5[_0x2e53('0x3b')](_0x2b4e86[_0x2e53('0x89')]+_0x2e53('0x92'),_0x336e94['startDate'],_0x336e94[_0x2e53('0x93')]);}else{_0x58d5f5[_0x2e53('0x3b')](_0x2b4e86[_0x2e53('0x89')]+_0x2e53('0x94'),_0x336e94[_0x2e53('0x95')],_0x336e94[_0x2e53('0x93')]);}if(_0x674b42){logger[_0x2e53('0x96')]('Run\x20Query:',_0x58d5f5['toString']());require('child_process')[_0x2e53('0x97')](path[_0x2e53('0x4e')](__dirname,_0x2e53('0x98'),_0x674b42[_0x2e53('0x8b')]),[_0x674b42['id'],_0x58d5f5[_0x2e53('0x7c')](),path[_0x2e53('0x4e')](__dirname,'../../files/reports',_0x674b42['savename']),_0x1f6aa1]);return _0x674b42;}else{var _0x3aa8b0=squel['select']();_0x3aa8b0[_0x2e53('0x87')]('('+_0x58d5f5[_0x2e53('0x7c')]()+')',_0x2e53('0x99'));_0x3aa8b0[_0x2e53('0x63')](_0x2e53('0x9a'),_0x2e53('0x1d'));_0x58d5f5[_0x2e53('0x1f')](_0x336e94[_0x2e53('0x1f')]||_0x4b2790);_0x58d5f5[_0x2e53('0x1e')](_0x336e94[_0x2e53('0x1e')]||0x0);return dbH[_0x2e53('0x7d')][_0x2e53('0x31')](_0x3aa8b0[_0x2e53('0x7c')](),{'type':dbH[_0x2e53('0x7d')][_0x2e53('0x7e')]['SELECT']})['then'](function(_0x5bd250){if(!_0x5bd250[_0x2e53('0x38')]){_0x35f676=0x0;}else{_0x35f676=_0x5bd250[0x0][_0x2e53('0x1d')]||0x0;}return dbH[_0x2e53('0x7d')]['query'](_0x58d5f5[_0x2e53('0x7c')](),{'type':dbH[_0x2e53('0x7d')][_0x2e53('0x7e')][_0x2e53('0x7f')]});})[_0x2e53('0x24')](function(_0x255974){return{'rows':_0x255974||[],'count':_0x35f676};});}});}exports['run']=function(_0x301eac,_0x2bcb50){return runReport(_0x301eac[_0x2e53('0x44')],_0x301eac[_0x2e53('0x31')],_0x301eac[_0x2e53('0x3f')])[_0x2e53('0x24')](respondWithResult(_0x2bcb50,null))[_0x2e53('0x43')](handleError(_0x2bcb50,null));};exports[_0x2e53('0x9b')]=runReport;exports['query']=function(_0x2466db,_0x2cbac9){var _0xc5e69c=0xa;var _0x192380=[_0x2e53('0x4e'),_0x2e53('0x4f'),_0x2e53('0x50'),'cross_join'];var _0x2ebd9c={'SUM':_0x2e53('0x52'),'COUNT':_0x2e53('0x9c'),'COUNT DISTINCT':_0x2e53('0x53'),'MAX':_0x2e53('0x54'),'MIN':'MIN(%s)','AVG':_0x2e53('0x80'),'GROUP_CONCAT':_0x2e53('0x81'),'GROUP_CONCAT ASC':_0x2e53('0x56'),'GROUP_CONCAT DESC':_0x2e53('0x57')};var _0x5304d1={'SEC_TO_TIME':_0x2e53('0x58'),'DATE':_0x2e53('0x59'),'HOUR':_0x2e53('0x5a'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x2e53('0x5c')};var _0x3883ce=function(_0x5d8267){return!_['includes']([_0x2e53('0x5e'),'IS\x20NOT\x20NULL',_0x2e53('0x5f'),'IS\x20NOT\x20EMPTY'],_0x5d8267);};var _0x12da96=function(_0x48b909){if(!_0x48b909||!_0x48b909['rules']['length']){return'';}for(var _0x978c94='(',_0x572ae8=0x0;_0x572ae8<_0x48b909[_0x2e53('0x60')]['length'];_0x572ae8+=0x1){_0x572ae8>0x0&&(_0x978c94+='\x20'+_0x48b909[_0x2e53('0x61')]+'\x20');_0x978c94+=_0x48b909[_0x2e53('0x60')][_0x572ae8][_0x2e53('0x62')]?_0x12da96(_0x48b909[_0x2e53('0x60')][_0x572ae8][_0x2e53('0x62')]):_0x48b909[_0x2e53('0x60')][_0x572ae8][_0x2e53('0x63')]+'\x20'+_0x48b909['rules'][_0x572ae8][_0x2e53('0x64')]+(_0x3883ce(_0x48b909[_0x2e53('0x60')][_0x572ae8]['condition'])?'\x20'+_0x48b909[_0x2e53('0x60')][_0x572ae8][_0x2e53('0x65')]:'');}return _0x978c94+')';};var _0x51a454={'where':{'id':_0x2466db[_0x2e53('0x44')]['id']}},_0x456161,_0x5071cf,_0x214c5a,_0x5156f8,_0x317281;_0x51a454=_[_0x2e53('0x3d')]({},_0x51a454,_0x2466db[_0x2e53('0x3f')]);return db[_0x2e53('0x2b')][_0x2e53('0x45')](_0x51a454)[_0x2e53('0x24')](function(_0x1ff939){if(_0x1ff939){_0x456161=_0x1ff939;return _0x1ff939[_0x2e53('0x84')]();}return null;})[_0x2e53('0x24')](function(_0x29ee62){if(_0x29ee62){if(!_0x29ee62[_0x2e53('0x38')]){throw new db['Sequelize'][(_0x2e53('0x66'))](_0x2e53('0x86'),0x193);}_0x5071cf=_0x29ee62;return db['AnalyticMetric'][_0x2e53('0x41')]({'raw':!![]});}return null;})[_0x2e53('0x24')](function(_0x368307){if(_0x368307){_0x214c5a=_['keyBy'](_0x368307,'id');var _0x112fce;var _0x22d945=squel[_0x2e53('0x69')]();_0x22d945['from'](_0x456161['table']);for(var _0x385271=0x0;_0x385271<_0x5071cf[_0x2e53('0x38')];_0x385271+=0x1){_0x112fce=_0x5071cf[_0x385271]['MetricId']?_0x214c5a[_0x5071cf[_0x385271][_0x2e53('0x6a')]]['metric']:_0x5071cf[_0x385271][_0x2e53('0x63')];_0x112fce=_0x5071cf[_0x385271]['function']?_[_0x2e53('0x6e')](_0x2ebd9c[_0x5071cf[_0x385271][_0x2e53('0x6c')]],'%s',_0x112fce):_0x112fce;_0x112fce=_0x5071cf[_0x385271][_0x2e53('0x6d')]?_[_0x2e53('0x6e')](_0x5304d1[_0x5071cf[_0x385271]['format']],'%s',_0x112fce):_0x112fce;if(_0x5071cf[_0x385271][_0x2e53('0x88')]){_0x22d945[_0x2e53('0x62')](_0x112fce);}_0x5071cf[_0x385271][_0x2e53('0x6f')]&&_0x22d945[_0x2e53('0x70')](_0x112fce,_0x5071cf[_0x385271]['orderBy']==='DESC'?![]:!![]);_0x22d945[_0x2e53('0x63')](_0x112fce,_0x5071cf[_0x385271][_0x2e53('0x72')]||_0x112fce);}if(_0x456161[_0x2e53('0x73')]){_0x456161[_0x2e53('0x73')]=JSON[_0x2e53('0x74')](_0x456161[_0x2e53('0x73')]);for(var _0xf5e67a=0x0;_0xf5e67a<_0x456161[_0x2e53('0x73')][_0x2e53('0x38')];_0xf5e67a+=0x1){if(_0x456161[_0x2e53('0x73')][_0xf5e67a][_0x2e53('0x2e')]&&_[_0x2e53('0x5d')](_0x192380,_0x456161['joins'][_0xf5e67a]['type'])&&_0x456161[_0x2e53('0x73')][_0xf5e67a][_0x2e53('0x75')]&&_0x456161[_0x2e53('0x73')][_0xf5e67a][_0x2e53('0x77')]&&_0x456161[_0x2e53('0x73')][_0xf5e67a][_0x2e53('0x78')]){_0x22d945[_0x456161['joins'][_0xf5e67a][_0x2e53('0x2e')]](_0x456161[_0x2e53('0x73')][_0xf5e67a][_0x2e53('0x77')],null,util['format']('%s.%s\x20=\x20%s.%s',_0x456161[_0x2e53('0x89')],_0x456161[_0x2e53('0x73')][_0xf5e67a]['parentKey'],_0x456161[_0x2e53('0x73')][_0xf5e67a][_0x2e53('0x77')],_0x456161[_0x2e53('0x73')][_0xf5e67a]['foreignKey']));}}}if(_0x456161[_0x2e53('0x79')]){_0x456161[_0x2e53('0x79')]=JSON[_0x2e53('0x74')](_0x456161[_0x2e53('0x79')]);_0x22d945[_0x2e53('0x3b')](_0x12da96(_0x456161[_0x2e53('0x79')][_0x2e53('0x62')]));}_0x317281=_0x22d945[_0x2e53('0x7a')]();_0x22d945[_0x2e53('0x1f')](_0xc5e69c);_0x22d945['offset'](0x0);logger[_0x2e53('0x9d')](_0x2e53('0x7b'),_0x22d945['toString']());return db['sequelize']['query'](_0x22d945['toString'](),{'type':db[_0x2e53('0x7d')][_0x2e53('0x7e')][_0x2e53('0x7f')]});}})[_0x2e53('0x24')](function(){return{'sql':_0x317281[_0x2e53('0x7c')]()};})[_0x2e53('0x24')](respondWithResult(_0x2cbac9,null))[_0x2e53('0x43')](handleError(_0x2cbac9,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff