// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xa37a=['fs-extra','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','dbH','sendStatus','end','undefined','limit','offset','status','set','apply','reject','then','get','CustomReports','error','name','send','index','rawAttributes','fieldName','type','model','map','query','keys','filters','intersection','attributes','fields','length','order','sort','filter','where','merge','options','count','includeAll','rows','catch','show','params','include','AnalyticCustomReport','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','UserProfileSection','userProfileId','autoAssociation','UserProfileResource','update','destroy','join','left_join','right_join','cross_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','rules','group','field','condition','value','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','findAll','keyBy','select','from','table','MetricId','metric','function','format','groupBy','orderBy','DESC','alias','joins','parentKey','foreignTable','foreignKey','conditions','parse','clone','debug','Limited\x20Query:','toString','sequelize','SELECT','MAX(%s)','MIN(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','DATE(%s)','HOUR(%s)','IS\x20NOT\x20EMPTY','operator','Sequelize','replace','web','fullPath','randomstring','generate','custom','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','Run\x20Query:','child_process','../../components/export/','output','savename','countTable','QueryTypes','runReport','getFields','rimraf','moment','bluebird','mustache','util','path','sox','to-csv','ejs'];(function(_0x5834bc,_0x3d4801){var _0x3e183a=function(_0x18b023){while(--_0x18b023){_0x5834bc['push'](_0x5834bc['shift']());}};_0x3e183a(++_0x3d4801);}(_0xa37a,0x135));var _0xaa37=function(_0x385e66,_0x4fb091){_0x385e66=_0x385e66-0x0;var _0x105823=_0xa37a[_0x385e66];return _0x105823;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xaa37('0x0'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0xaa37('0x1'));var BPromise=require(_0xaa37('0x2'));var Mustache=require(_0xaa37('0x3'));var util=require(_0xaa37('0x4'));var path=require(_0xaa37('0x5'));var sox=require(_0xaa37('0x6'));var csv=require(_0xaa37('0x7'));var ejs=require(_0xaa37('0x8'));var fs=require('fs');var fs_extra=require(_0xaa37('0x9'));var _=require('lodash');var squel=require(_0xaa37('0xa'));var crypto=require(_0xaa37('0xb'));var jsforce=require(_0xaa37('0xc'));var deskjs=require(_0xaa37('0xd'));var toCsv=require(_0xaa37('0x7'));var querystring=require('querystring');var Papa=require(_0xaa37('0xe'));var Redis=require(_0xaa37('0xf'));var authService=require(_0xaa37('0x10'));var qs=require(_0xaa37('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xaa37('0x12'));var logger=require(_0xaa37('0x13'))(_0xaa37('0x14'));var utils=require(_0xaa37('0x15'));var config=require(_0xaa37('0x16'));var licenseUtil=require(_0xaa37('0x17'));var db=require(_0xaa37('0x18'))['db'];var dbH=require(_0xaa37('0x18'))[_0xaa37('0x19')];function respondWithStatusCode(_0x16f29c,_0x194e53){_0x194e53=_0x194e53||0xcc;return function(_0x309699){if(_0x309699){return _0x16f29c[_0xaa37('0x1a')](_0x194e53);}return _0x16f29c['status'](_0x194e53)[_0xaa37('0x1b')]();};}function respondWithResult(_0x2b4427,_0x4390fc){_0x4390fc=_0x4390fc||0xc8;return function(_0x2ec730){if(_0x2ec730){return _0x2b4427['status'](_0x4390fc)['json'](_0x2ec730);}};}function respondWithFilteredResult(_0x4e2a45,_0x1ebcf2){return function(_0x2ebc04){if(_0x2ebc04){var _0x342e98=typeof _0x1ebcf2['offset']===_0xaa37('0x1c')&&typeof _0x1ebcf2[_0xaa37('0x1d')]===_0xaa37('0x1c');var _0x125178=_0x2ebc04['count'];var _0x646053=_0x342e98?0x0:_0x1ebcf2[_0xaa37('0x1e')];var _0x4a814a=_0x342e98?_0x2ebc04['count']:_0x1ebcf2[_0xaa37('0x1e')]+_0x1ebcf2['limit'];var _0x3e5abf;if(_0x4a814a>=_0x125178){_0x4a814a=_0x125178;_0x3e5abf=0xc8;}else{_0x3e5abf=0xce;}_0x4e2a45[_0xaa37('0x1f')](_0x3e5abf);return _0x4e2a45[_0xaa37('0x20')]('Content-Range',_0x646053+'-'+_0x4a814a+'/'+_0x125178)['json'](_0x2ebc04);}return null;};}function patchUpdates(_0x4f0781){return function(_0x52aaec){try{jsonpatch[_0xaa37('0x21')](_0x52aaec,_0x4f0781,!![]);}catch(_0x1097d4){return BPromise[_0xaa37('0x22')](_0x1097d4);}return _0x52aaec['save']();};}function saveUpdates(_0x104668,_0x31a8ed){return function(_0x53ae5e){if(_0x53ae5e){return _0x53ae5e['update'](_0x104668)['then'](function(_0xac0e0e){return _0xac0e0e;});}return null;};}function removeEntity(_0xb75470,_0x1f85f8){return function(_0x1df029){if(_0x1df029){return _0x1df029['destroy']()[_0xaa37('0x23')](function(){var _0xfc50ba=_0x1df029[_0xaa37('0x24')]({'plain':!![]});var _0x25e130=_0xaa37('0x25');return db['UserProfileResource']['destroy']({'where':{'type':_0x25e130,'resourceId':_0xfc50ba['id']}})['then'](function(){return _0x1df029;});})['then'](function(){_0xb75470[_0xaa37('0x1f')](0xcc)['end']();});}};}function handleEntityNotFound(_0x8bf85c,_0x44767b){return function(_0x160705){if(!_0x160705){_0x8bf85c[_0xaa37('0x1a')](0x194);}return _0x160705;};}function handleError(_0x22d46d,_0x4f6992){_0x4f6992=_0x4f6992||0x1f4;return function(_0x98a6e7){logger[_0xaa37('0x26')](_0x98a6e7['stack']);if(_0x98a6e7['name']){delete _0x98a6e7[_0xaa37('0x27')];}_0x22d46d[_0xaa37('0x1f')](_0x4f6992)[_0xaa37('0x28')](_0x98a6e7);};}exports[_0xaa37('0x29')]=function(_0x472ea4,_0x26d3df){var _0x548d4d={},_0x36dd97={},_0x3563b8={'count':0x0,'rows':[]};var _0x4bb250=_['map'](db['AnalyticCustomReport'][_0xaa37('0x2a')],function(_0x37c78f){return{'name':_0x37c78f[_0xaa37('0x2b')],'type':_0x37c78f[_0xaa37('0x2c')]['key']};});_0x36dd97[_0xaa37('0x2d')]=_[_0xaa37('0x2e')](_0x4bb250,_0xaa37('0x27'));_0x36dd97[_0xaa37('0x2f')]=_[_0xaa37('0x30')](_0x472ea4[_0xaa37('0x2f')]);_0x36dd97[_0xaa37('0x31')]=_[_0xaa37('0x32')](_0x36dd97[_0xaa37('0x2d')],_0x36dd97[_0xaa37('0x2f')]);_0x548d4d[_0xaa37('0x33')]=_[_0xaa37('0x32')](_0x36dd97[_0xaa37('0x2d')],qs[_0xaa37('0x34')](_0x472ea4[_0xaa37('0x2f')][_0xaa37('0x34')]));_0x548d4d[_0xaa37('0x33')]=_0x548d4d[_0xaa37('0x33')][_0xaa37('0x35')]?_0x548d4d[_0xaa37('0x33')]:_0x36dd97[_0xaa37('0x2d')];if(!_0x472ea4[_0xaa37('0x2f')]['hasOwnProperty']('nolimit')){_0x548d4d[_0xaa37('0x1d')]=qs['limit'](_0x472ea4[_0xaa37('0x2f')][_0xaa37('0x1d')]);_0x548d4d[_0xaa37('0x1e')]=qs[_0xaa37('0x1e')](_0x472ea4[_0xaa37('0x2f')][_0xaa37('0x1e')]);}_0x548d4d[_0xaa37('0x36')]=qs[_0xaa37('0x37')](_0x472ea4['query'][_0xaa37('0x37')]);_0x548d4d['where']=qs[_0xaa37('0x31')](_['pick'](_0x472ea4[_0xaa37('0x2f')],_0x36dd97[_0xaa37('0x31')]),_0x4bb250);if(_0x472ea4[_0xaa37('0x2f')][_0xaa37('0x38')]){_0x548d4d[_0xaa37('0x39')]=_[_0xaa37('0x3a')](_0x548d4d[_0xaa37('0x39')],{'$or':_['map'](_0x4bb250,function(_0x43014f){if(_0x43014f['type']!=='VIRTUAL'){var _0x4ee8dd={};_0x4ee8dd[_0x43014f[_0xaa37('0x27')]]={'$like':'%'+_0x472ea4[_0xaa37('0x2f')][_0xaa37('0x38')]+'%'};return _0x4ee8dd;}})});}_0x548d4d=_[_0xaa37('0x3a')]({},_0x548d4d,_0x472ea4[_0xaa37('0x3b')]);var _0x4ba432={'where':_0x548d4d['where']};return db['AnalyticCustomReport'][_0xaa37('0x3c')](_0x4ba432)['then'](function(_0x29e14b){_0x3563b8[_0xaa37('0x3c')]=_0x29e14b;if(_0x472ea4[_0xaa37('0x2f')][_0xaa37('0x3d')]){_0x548d4d['include']=[{'all':!![]}];}return db['AnalyticCustomReport']['findAll'](_0x548d4d);})[_0xaa37('0x23')](function(_0x37f427){_0x3563b8[_0xaa37('0x3e')]=_0x37f427;return _0x3563b8;})['then'](respondWithFilteredResult(_0x26d3df,_0x548d4d))[_0xaa37('0x3f')](handleError(_0x26d3df,null));};exports[_0xaa37('0x40')]=function(_0x425342,_0x2721de){var _0x1ee65b={'raw':![],'where':{'id':_0x425342[_0xaa37('0x41')]['id']}},_0x59d3c5={};_0x59d3c5[_0xaa37('0x2d')]=_[_0xaa37('0x30')](db['AnalyticCustomReport'][_0xaa37('0x2a')]);_0x59d3c5[_0xaa37('0x2f')]=_[_0xaa37('0x30')](_0x425342[_0xaa37('0x2f')]);_0x59d3c5[_0xaa37('0x31')]=_[_0xaa37('0x32')](_0x59d3c5[_0xaa37('0x2d')],_0x59d3c5[_0xaa37('0x2f')]);_0x1ee65b[_0xaa37('0x33')]=_['intersection'](_0x59d3c5[_0xaa37('0x2d')],qs[_0xaa37('0x34')](_0x425342[_0xaa37('0x2f')]['fields']));_0x1ee65b['attributes']=_0x1ee65b[_0xaa37('0x33')][_0xaa37('0x35')]?_0x1ee65b[_0xaa37('0x33')]:_0x59d3c5[_0xaa37('0x2d')];if(_0x425342[_0xaa37('0x2f')][_0xaa37('0x3d')]){_0x1ee65b[_0xaa37('0x42')]=[{'all':!![]}];}_0x1ee65b=_[_0xaa37('0x3a')]({},_0x1ee65b,_0x425342[_0xaa37('0x3b')]);return db[_0xaa37('0x43')][_0xaa37('0x44')](_0x1ee65b)[_0xaa37('0x23')](handleEntityNotFound(_0x2721de,null))[_0xaa37('0x23')](respondWithResult(_0x2721de,null))[_0xaa37('0x3f')](handleError(_0x2721de,null));};exports[_0xaa37('0x45')]=function(_0x50678b,_0x52f712){return db[_0xaa37('0x43')]['create'](_0x50678b[_0xaa37('0x46')],{})[_0xaa37('0x23')](function(_0x26a2cd){var _0x54cb68=_0x50678b[_0xaa37('0x47')][_0xaa37('0x24')]({'plain':!![]});if(!_0x54cb68)throw new Error(_0xaa37('0x48'));if(_0x54cb68[_0xaa37('0x49')]===_0xaa37('0x47')){var _0x130fa2=_0x26a2cd['get']({'plain':!![]});var _0x258284=_0xaa37('0x4a');return db[_0xaa37('0x4b')]['find']({'where':{'name':_0x258284,'userProfileId':_0x54cb68[_0xaa37('0x4c')]},'raw':!![]})[_0xaa37('0x23')](function(_0x49fa2a){if(_0x49fa2a&&_0x49fa2a[_0xaa37('0x4d')]===0x0){return db[_0xaa37('0x4e')]['create']({'name':_0x130fa2[_0xaa37('0x27')],'resourceId':_0x130fa2['id'],'type':_0xaa37('0x25'),'sectionId':_0x49fa2a['id']},{})['then'](function(){return _0x26a2cd;});}else{return _0x26a2cd;}})[_0xaa37('0x3f')](function(_0x103457){logger[_0xaa37('0x26')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x103457);throw _0x103457;});}return _0x26a2cd;})[_0xaa37('0x23')](respondWithResult(_0x52f712,0xc9))[_0xaa37('0x3f')](handleError(_0x52f712,null));};exports[_0xaa37('0x4f')]=function(_0x511e4c,_0x36f0b5){if(_0x511e4c[_0xaa37('0x46')]['id']){delete _0x511e4c[_0xaa37('0x46')]['id'];}return db[_0xaa37('0x43')][_0xaa37('0x44')]({'where':{'id':_0x511e4c[_0xaa37('0x41')]['id']}})[_0xaa37('0x23')](handleEntityNotFound(_0x36f0b5,null))[_0xaa37('0x23')](saveUpdates(_0x511e4c[_0xaa37('0x46')],null))[_0xaa37('0x23')](respondWithResult(_0x36f0b5,null))['catch'](handleError(_0x36f0b5,null));};exports[_0xaa37('0x50')]=function(_0x22b402,_0x1888ff){return db[_0xaa37('0x43')][_0xaa37('0x44')]({'where':{'id':_0x22b402[_0xaa37('0x41')]['id']}})['then'](handleEntityNotFound(_0x1888ff,null))[_0xaa37('0x23')](removeEntity(_0x1888ff,null))[_0xaa37('0x3f')](handleError(_0x1888ff,null));};exports['preview']=function(_0x4148d3,_0x5586af){var _0x31e8a3=0xa;var _0x172726=[_0xaa37('0x51'),_0xaa37('0x52'),_0xaa37('0x53'),_0xaa37('0x54')];var _0x28b53a={'SUM':_0xaa37('0x55'),'COUNT':_0xaa37('0x56'),'COUNT DISTINCT':_0xaa37('0x57'),'MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':_0xaa37('0x58'),'GROUP_CONCAT':_0xaa37('0x59'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0xaa37('0x5a')};var _0x22a9c9={'SEC_TO_TIME':_0xaa37('0x5b'),'DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':_0xaa37('0x5c'),'UNIX_TIMESTAMP':_0xaa37('0x5d')};var _0x1c1986=function(_0x55a06b){return!_[_0xaa37('0x5e')]([_0xaa37('0x5f'),_0xaa37('0x60'),_0xaa37('0x61'),'IS\x20NOT\x20EMPTY'],_0x55a06b);};var _0x11653e=function(_0x4b0d61){if(!_0x4b0d61||!_0x4b0d61[_0xaa37('0x62')][_0xaa37('0x35')]){return'';}for(var _0x4a7e55='(',_0x10fa7b=0x0;_0x10fa7b<_0x4b0d61[_0xaa37('0x62')][_0xaa37('0x35')];_0x10fa7b+=0x1){_0x10fa7b>0x0&&(_0x4a7e55+='\x20'+_0x4b0d61['operator']+'\x20');_0x4a7e55+=_0x4b0d61[_0xaa37('0x62')][_0x10fa7b]['group']?_0x11653e(_0x4b0d61['rules'][_0x10fa7b][_0xaa37('0x63')]):_0x4b0d61['rules'][_0x10fa7b][_0xaa37('0x64')]+'\x20'+_0x4b0d61['rules'][_0x10fa7b][_0xaa37('0x65')]+(_0x1c1986(_0x4b0d61[_0xaa37('0x62')][_0x10fa7b][_0xaa37('0x65')])?'\x20'+_0x4b0d61[_0xaa37('0x62')][_0x10fa7b][_0xaa37('0x66')]:'');}return _0x4a7e55+')';};var _0xd12a8={'where':{'id':_0x4148d3['params']['id']}},_0x4a74df,_0xd964a2,_0x2e0779,_0x4f28d0,_0x4a4ef5;_0xd12a8=_[_0xaa37('0x3a')]({},_0xd12a8,_0x4148d3[_0xaa37('0x3b')]);return db['AnalyticCustomReport'][_0xaa37('0x44')](_0xd12a8)[_0xaa37('0x23')](function(_0x4962da){if(_0x4962da){_0x4a74df=_0x4962da;return _0x4962da['getFields']();}return null;})[_0xaa37('0x23')](function(_0x2589e4){if(_0x2589e4){if(!_0x2589e4[_0xaa37('0x35')]){throw new db['Sequelize'][(_0xaa37('0x67'))](_0xaa37('0x68'),0x193);}_0xd964a2=_0x2589e4;return db[_0xaa37('0x69')][_0xaa37('0x6a')]({'raw':!![]});}return null;})['then'](function(_0x57dcea){if(_0x57dcea){_0x2e0779=_[_0xaa37('0x6b')](_0x57dcea,'id');var _0xd62dde;var _0x345eca=squel[_0xaa37('0x6c')]();_0x345eca[_0xaa37('0x6d')](_0x4a74df[_0xaa37('0x6e')]);for(var _0x50e24c=0x0;_0x50e24c<_0xd964a2[_0xaa37('0x35')];_0x50e24c+=0x1){_0xd62dde=_0xd964a2[_0x50e24c]['MetricId']?_0x2e0779[_0xd964a2[_0x50e24c][_0xaa37('0x6f')]][_0xaa37('0x70')]:_0xd964a2[_0x50e24c][_0xaa37('0x64')];_0xd62dde=_0xd964a2[_0x50e24c][_0xaa37('0x71')]?_['replace'](_0x28b53a[_0xd964a2[_0x50e24c][_0xaa37('0x71')]],'%s',_0xd62dde):_0xd62dde;_0xd62dde=_0xd964a2[_0x50e24c][_0xaa37('0x72')]?_['replace'](_0x22a9c9[_0xd964a2[_0x50e24c]['format']],'%s',_0xd62dde):_0xd62dde;if(_0xd964a2[_0x50e24c][_0xaa37('0x73')]){_0x345eca[_0xaa37('0x63')](_0xd62dde);}_0xd964a2[_0x50e24c][_0xaa37('0x74')]&&_0x345eca[_0xaa37('0x36')](_0xd62dde,_0xd964a2[_0x50e24c][_0xaa37('0x74')]===_0xaa37('0x75')?![]:!![]);_0x345eca[_0xaa37('0x64')](_0xd62dde,_0xd964a2[_0x50e24c][_0xaa37('0x76')]||_0xd62dde);}if(_0x4a74df[_0xaa37('0x77')]){_0x4a74df[_0xaa37('0x77')]=JSON['parse'](_0x4a74df[_0xaa37('0x77')]);for(var _0x2b1127=0x0;_0x2b1127<_0x4a74df['joins'][_0xaa37('0x35')];_0x2b1127+=0x1){if(_0x4a74df['joins'][_0x2b1127][_0xaa37('0x2c')]&&_[_0xaa37('0x5e')](_0x172726,_0x4a74df[_0xaa37('0x77')][_0x2b1127][_0xaa37('0x2c')])&&_0x4a74df['joins'][_0x2b1127][_0xaa37('0x78')]&&_0x4a74df[_0xaa37('0x77')][_0x2b1127][_0xaa37('0x79')]&&_0x4a74df[_0xaa37('0x77')][_0x2b1127][_0xaa37('0x7a')]){_0x345eca[_0x4a74df['joins'][_0x2b1127]['type']](_0x4a74df['joins'][_0x2b1127][_0xaa37('0x79')],null,util[_0xaa37('0x72')]('%s.%s\x20=\x20%s.%s',_0x4a74df['table'],_0x4a74df[_0xaa37('0x77')][_0x2b1127][_0xaa37('0x78')],_0x4a74df['joins'][_0x2b1127][_0xaa37('0x79')],_0x4a74df[_0xaa37('0x77')][_0x2b1127][_0xaa37('0x7a')]));}}}if(_0x4a74df[_0xaa37('0x7b')]){_0x4a74df[_0xaa37('0x7b')]=JSON[_0xaa37('0x7c')](_0x4a74df[_0xaa37('0x7b')]);_0x345eca['where'](_0x11653e(_0x4a74df[_0xaa37('0x7b')]['group']));}_0x4a4ef5=_0x345eca[_0xaa37('0x7d')]();_0x345eca[_0xaa37('0x1d')](_0x31e8a3);_0x345eca['offset'](0x0);logger[_0xaa37('0x7e')](_0xaa37('0x7f'),_0x345eca[_0xaa37('0x80')]());return dbH[_0xaa37('0x81')]['query'](_0x345eca[_0xaa37('0x80')](),{'type':dbH['sequelize']['QueryTypes'][_0xaa37('0x82')]});}})[_0xaa37('0x23')](respondWithResult(_0x5586af,null))[_0xaa37('0x3f')](handleError(_0x5586af,null));};function runReport(_0x345552,_0x178f8b,_0x1437fc){var _0x58f375=_0x178f8b[_0xaa37('0x27')];var _0x142cbf=0xa;var _0x7e1ed1=[_0xaa37('0x51'),'left_join',_0xaa37('0x53'),'cross_join'];var _0x234d28={'SUM':_0xaa37('0x55'),'COUNT':_0xaa37('0x56'),'COUNT DISTINCT':_0xaa37('0x57'),'MAX':_0xaa37('0x83'),'MIN':_0xaa37('0x84'),'AVG':_0xaa37('0x58'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0xaa37('0x85'),'GROUP_CONCAT DESC':_0xaa37('0x5a')};var _0x3156a4={'SEC_TO_TIME':_0xaa37('0x5b'),'DATE':_0xaa37('0x86'),'HOUR':_0xaa37('0x87'),'ROUND':_0xaa37('0x5c'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x39f7b9=function(_0x18c2af){return!_[_0xaa37('0x5e')]([_0xaa37('0x5f'),_0xaa37('0x60'),_0xaa37('0x61'),_0xaa37('0x88')],_0x18c2af);};var _0x433a7c=function(_0x36b5df){if(!_0x36b5df||!_0x36b5df[_0xaa37('0x62')]['length']){return'';}for(var _0x3071b5='(',_0x3df706=0x0;_0x3df706<_0x36b5df[_0xaa37('0x62')][_0xaa37('0x35')];_0x3df706+=0x1){_0x3df706>0x0&&(_0x3071b5+='\x20'+_0x36b5df[_0xaa37('0x89')]+'\x20');_0x3071b5+=_0x36b5df[_0xaa37('0x62')][_0x3df706]['group']?_0x433a7c(_0x36b5df[_0xaa37('0x62')][_0x3df706]['group']):_0x36b5df[_0xaa37('0x62')][_0x3df706][_0xaa37('0x64')]+'\x20'+_0x36b5df[_0xaa37('0x62')][_0x3df706][_0xaa37('0x65')]+(_0x39f7b9(_0x36b5df[_0xaa37('0x62')][_0x3df706]['condition'])?'\x20'+_0x36b5df['rules'][_0x3df706][_0xaa37('0x66')]:'');}return _0x3071b5+')';};var _0x485591={'where':{'id':_0x345552['id']}},_0x5d4350,_0x1b21bb,_0x4c59e6,_0x5718c2,_0x541e5b;_0x485591=_[_0xaa37('0x3a')]({},_0x485591,_0x1437fc);return db[_0xaa37('0x43')][_0xaa37('0x44')](_0x485591)['then'](function(_0x2a52cf){if(_0x2a52cf){_0x5d4350=_0x2a52cf;return _0x2a52cf['getFields']();}return null;})[_0xaa37('0x23')](function(_0x501a4b){if(_0x501a4b){if(!_0x501a4b['length']){throw new db[(_0xaa37('0x8a'))]['ValidationErrorItem'](_0xaa37('0x68'),0x193);}_0x1b21bb=_0x501a4b;return db[_0xaa37('0x69')][_0xaa37('0x6a')]({'raw':!![]});}return null;})['then'](function(_0x37c9ad){if(_0x37c9ad){_0x4c59e6=_[_0xaa37('0x6b')](_0x37c9ad,'id');var _0x1651d7;var _0x310029=squel[_0xaa37('0x6c')]();_0x310029[_0xaa37('0x6d')](_0x5d4350[_0xaa37('0x6e')]);for(var _0x56b770=0x0;_0x56b770<_0x1b21bb[_0xaa37('0x35')];_0x56b770+=0x1){_0x1651d7=_0x1b21bb[_0x56b770][_0xaa37('0x6f')]?_0x4c59e6[_0x1b21bb[_0x56b770]['MetricId']][_0xaa37('0x70')]:_0x1b21bb[_0x56b770]['field'];_0x1651d7=_0x1b21bb[_0x56b770][_0xaa37('0x71')]?_[_0xaa37('0x8b')](_0x234d28[_0x1b21bb[_0x56b770]['function']],'%s',_0x1651d7):_0x1651d7;_0x1651d7=_0x1b21bb[_0x56b770][_0xaa37('0x72')]?_[_0xaa37('0x8b')](_0x3156a4[_0x1b21bb[_0x56b770][_0xaa37('0x72')]],'%s',_0x1651d7):_0x1651d7;if(_0x1b21bb[_0x56b770]['groupBy']){_0x310029[_0xaa37('0x63')](_0x1651d7);}_0x1b21bb[_0x56b770]['orderBy']&&_0x310029['order'](_0x1651d7,_0x1b21bb[_0x56b770][_0xaa37('0x74')]===_0xaa37('0x75')?![]:!![]);_0x310029['field'](_0x1651d7,_0x1b21bb[_0x56b770][_0xaa37('0x76')]||_0x1651d7);}if(_0x5d4350[_0xaa37('0x77')]){_0x5d4350[_0xaa37('0x77')]=JSON[_0xaa37('0x7c')](_0x5d4350[_0xaa37('0x77')]);for(var _0x3b9df9=0x0;_0x3b9df9<_0x5d4350[_0xaa37('0x77')]['length'];_0x3b9df9+=0x1){if(_0x5d4350[_0xaa37('0x77')][_0x3b9df9][_0xaa37('0x2c')]&&_[_0xaa37('0x5e')](_0x7e1ed1,_0x5d4350[_0xaa37('0x77')][_0x3b9df9][_0xaa37('0x2c')])&&_0x5d4350[_0xaa37('0x77')][_0x3b9df9]['parentKey']&&_0x5d4350[_0xaa37('0x77')][_0x3b9df9]['foreignTable']&&_0x5d4350[_0xaa37('0x77')][_0x3b9df9][_0xaa37('0x7a')]){_0x310029[_0x5d4350[_0xaa37('0x77')][_0x3b9df9][_0xaa37('0x2c')]](_0x5d4350[_0xaa37('0x77')][_0x3b9df9][_0xaa37('0x79')],null,util[_0xaa37('0x72')]('%s.%s\x20=\x20%s.%s',_0x5d4350[_0xaa37('0x6e')],_0x5d4350[_0xaa37('0x77')][_0x3b9df9][_0xaa37('0x78')],_0x5d4350[_0xaa37('0x77')][_0x3b9df9][_0xaa37('0x79')],_0x5d4350[_0xaa37('0x77')][_0x3b9df9][_0xaa37('0x7a')]));}}}if(_0x5d4350[_0xaa37('0x7b')]){_0x5d4350[_0xaa37('0x7b')]=JSON[_0xaa37('0x7c')](_0x5d4350['conditions']);_0x310029[_0xaa37('0x39')](_0x433a7c(_0x5d4350[_0xaa37('0x7b')][_0xaa37('0x63')]));}_0x541e5b=_0x310029['clone']();_0x310029[_0xaa37('0x1d')](_0x142cbf);_0x310029['offset'](0x0);return;}})[_0xaa37('0x23')](function(){if(_0x178f8b['output']===_0xaa37('0x8c')){return null;}var _0x5466d6=_[_0xaa37('0x3a')](_0x178f8b,{'name':_0x178f8b[_0xaa37('0x8d')]||_0x178f8b[_0xaa37('0x27')]||_0x5d4350[_0xaa37('0x27')],'basename':_0x58f375,'savename':util['format']('%s-%s.%s',_0x178f8b[_0xaa37('0x27')]||_0x5d4350[_0xaa37('0x27')],require(_0xaa37('0x8e'))[_0xaa37('0x8f')](0x4),_0x178f8b['output']||'csv'),'reportId':_0x5d4350['id'],'reportType':_0xaa37('0x90')});return db['AnalyticExtractedReport']['create'](_0x5466d6,{'raw':!![]});})[_0xaa37('0x23')](function(_0x275797){if(_0x5d4350[_0xaa37('0x6e')]===_0xaa37('0x91')){_0x541e5b[_0xaa37('0x39')](_0x5d4350['table']+_0xaa37('0x92'),_0x178f8b[_0xaa37('0x93')],_0x178f8b[_0xaa37('0x94')]);}else{_0x541e5b[_0xaa37('0x39')](_0x5d4350['table']+_0xaa37('0x95'),_0x178f8b[_0xaa37('0x93')],_0x178f8b[_0xaa37('0x94')]);}if(_0x275797){logger['info'](_0xaa37('0x96'),_0x541e5b[_0xaa37('0x80')]());require(_0xaa37('0x97'))['fork'](path[_0xaa37('0x51')](__dirname,_0xaa37('0x98'),_0x275797[_0xaa37('0x99')]),[_0x275797['id'],_0x541e5b[_0xaa37('0x80')](),path[_0xaa37('0x51')](__dirname,'../../files/reports',_0x275797[_0xaa37('0x9a')]),_0x58f375]);return _0x275797;}else{var _0x127238=squel[_0xaa37('0x6c')]();_0x127238[_0xaa37('0x6d')]('('+_0x541e5b[_0xaa37('0x80')]()+')',_0xaa37('0x9b'));_0x127238[_0xaa37('0x64')]('COUNT(*)',_0xaa37('0x3c'));_0x541e5b[_0xaa37('0x1d')](_0x178f8b[_0xaa37('0x1d')]||_0x142cbf);_0x541e5b[_0xaa37('0x1e')](_0x178f8b['offset']||0x0);return dbH['sequelize']['query'](_0x127238[_0xaa37('0x80')](),{'type':dbH[_0xaa37('0x81')]['QueryTypes']['SELECT']})['then'](function(_0x5bf1e4){if(!_0x5bf1e4[_0xaa37('0x35')]){_0x5718c2=0x0;}else{_0x5718c2=_0x5bf1e4[0x0][_0xaa37('0x3c')]||0x0;}return dbH[_0xaa37('0x81')][_0xaa37('0x2f')](_0x541e5b[_0xaa37('0x80')](),{'type':dbH[_0xaa37('0x81')][_0xaa37('0x9c')][_0xaa37('0x82')]});})[_0xaa37('0x23')](function(_0x4adf14){return{'rows':_0x4adf14||[],'count':_0x5718c2};});}});}exports['run']=function(_0x4d477a,_0xa5ef64){return runReport(_0x4d477a[_0xaa37('0x41')],_0x4d477a[_0xaa37('0x2f')],_0x4d477a[_0xaa37('0x3b')])[_0xaa37('0x23')](respondWithResult(_0xa5ef64,null))[_0xaa37('0x3f')](handleError(_0xa5ef64,null));};exports[_0xaa37('0x9d')]=runReport;exports[_0xaa37('0x2f')]=function(_0x2e9e9d,_0x49c7db){var _0x274455=0xa;var _0x25ecf=[_0xaa37('0x51'),'left_join',_0xaa37('0x53'),_0xaa37('0x54')];var _0x3417c8={'SUM':'SUM(%s)','COUNT':_0xaa37('0x56'),'COUNT DISTINCT':_0xaa37('0x57'),'MAX':_0xaa37('0x83'),'MIN':_0xaa37('0x84'),'AVG':_0xaa37('0x58'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0xaa37('0x85'),'GROUP_CONCAT DESC':_0xaa37('0x5a')};var _0x6b10d0={'SEC_TO_TIME':_0xaa37('0x5b'),'DATE':_0xaa37('0x86'),'HOUR':_0xaa37('0x87'),'ROUND':_0xaa37('0x5c'),'UNIX_TIMESTAMP':_0xaa37('0x5d')};var _0x58ffb3=function(_0x140000){return!_[_0xaa37('0x5e')]([_0xaa37('0x5f'),'IS\x20NOT\x20NULL',_0xaa37('0x61'),_0xaa37('0x88')],_0x140000);};var _0x173676=function(_0x1210c7){if(!_0x1210c7||!_0x1210c7[_0xaa37('0x62')][_0xaa37('0x35')]){return'';}for(var _0x716aaa='(',_0x1cabb7=0x0;_0x1cabb7<_0x1210c7[_0xaa37('0x62')][_0xaa37('0x35')];_0x1cabb7+=0x1){_0x1cabb7>0x0&&(_0x716aaa+='\x20'+_0x1210c7[_0xaa37('0x89')]+'\x20');_0x716aaa+=_0x1210c7[_0xaa37('0x62')][_0x1cabb7][_0xaa37('0x63')]?_0x173676(_0x1210c7[_0xaa37('0x62')][_0x1cabb7]['group']):_0x1210c7[_0xaa37('0x62')][_0x1cabb7][_0xaa37('0x64')]+'\x20'+_0x1210c7['rules'][_0x1cabb7][_0xaa37('0x65')]+(_0x58ffb3(_0x1210c7[_0xaa37('0x62')][_0x1cabb7][_0xaa37('0x65')])?'\x20'+_0x1210c7[_0xaa37('0x62')][_0x1cabb7][_0xaa37('0x66')]:'');}return _0x716aaa+')';};var _0x5b6050={'where':{'id':_0x2e9e9d[_0xaa37('0x41')]['id']}},_0x546309,_0x54705b,_0x20dd73,_0x2d5ffa,_0x4b318b;_0x5b6050=_[_0xaa37('0x3a')]({},_0x5b6050,_0x2e9e9d[_0xaa37('0x3b')]);return db[_0xaa37('0x43')]['find'](_0x5b6050)[_0xaa37('0x23')](function(_0x34c902){if(_0x34c902){_0x546309=_0x34c902;return _0x34c902[_0xaa37('0x9e')]();}return null;})['then'](function(_0x166ddf){if(_0x166ddf){if(!_0x166ddf['length']){throw new db[(_0xaa37('0x8a'))]['ValidationErrorItem']('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x54705b=_0x166ddf;return db['AnalyticMetric'][_0xaa37('0x6a')]({'raw':!![]});}return null;})[_0xaa37('0x23')](function(_0x2c27e9){if(_0x2c27e9){_0x20dd73=_['keyBy'](_0x2c27e9,'id');var _0x5d1c5e;var _0x298739=squel[_0xaa37('0x6c')]();_0x298739[_0xaa37('0x6d')](_0x546309[_0xaa37('0x6e')]);for(var _0x5c609b=0x0;_0x5c609b<_0x54705b[_0xaa37('0x35')];_0x5c609b+=0x1){_0x5d1c5e=_0x54705b[_0x5c609b]['MetricId']?_0x20dd73[_0x54705b[_0x5c609b]['MetricId']][_0xaa37('0x70')]:_0x54705b[_0x5c609b][_0xaa37('0x64')];_0x5d1c5e=_0x54705b[_0x5c609b][_0xaa37('0x71')]?_['replace'](_0x3417c8[_0x54705b[_0x5c609b][_0xaa37('0x71')]],'%s',_0x5d1c5e):_0x5d1c5e;_0x5d1c5e=_0x54705b[_0x5c609b]['format']?_['replace'](_0x6b10d0[_0x54705b[_0x5c609b][_0xaa37('0x72')]],'%s',_0x5d1c5e):_0x5d1c5e;if(_0x54705b[_0x5c609b]['groupBy']){_0x298739[_0xaa37('0x63')](_0x5d1c5e);}_0x54705b[_0x5c609b][_0xaa37('0x74')]&&_0x298739[_0xaa37('0x36')](_0x5d1c5e,_0x54705b[_0x5c609b]['orderBy']==='DESC'?![]:!![]);_0x298739[_0xaa37('0x64')](_0x5d1c5e,_0x54705b[_0x5c609b][_0xaa37('0x76')]||_0x5d1c5e);}if(_0x546309['joins']){_0x546309[_0xaa37('0x77')]=JSON[_0xaa37('0x7c')](_0x546309[_0xaa37('0x77')]);for(var _0x4eb9c=0x0;_0x4eb9c<_0x546309['joins'][_0xaa37('0x35')];_0x4eb9c+=0x1){if(_0x546309[_0xaa37('0x77')][_0x4eb9c][_0xaa37('0x2c')]&&_['includes'](_0x25ecf,_0x546309[_0xaa37('0x77')][_0x4eb9c][_0xaa37('0x2c')])&&_0x546309[_0xaa37('0x77')][_0x4eb9c][_0xaa37('0x78')]&&_0x546309[_0xaa37('0x77')][_0x4eb9c]['foreignTable']&&_0x546309['joins'][_0x4eb9c][_0xaa37('0x7a')]){_0x298739[_0x546309['joins'][_0x4eb9c][_0xaa37('0x2c')]](_0x546309['joins'][_0x4eb9c][_0xaa37('0x79')],null,util['format']('%s.%s\x20=\x20%s.%s',_0x546309[_0xaa37('0x6e')],_0x546309[_0xaa37('0x77')][_0x4eb9c]['parentKey'],_0x546309[_0xaa37('0x77')][_0x4eb9c][_0xaa37('0x79')],_0x546309['joins'][_0x4eb9c]['foreignKey']));}}}if(_0x546309[_0xaa37('0x7b')]){_0x546309[_0xaa37('0x7b')]=JSON[_0xaa37('0x7c')](_0x546309[_0xaa37('0x7b')]);_0x298739[_0xaa37('0x39')](_0x173676(_0x546309[_0xaa37('0x7b')][_0xaa37('0x63')]));}_0x4b318b=_0x298739[_0xaa37('0x7d')]();_0x298739[_0xaa37('0x1d')](_0x274455);_0x298739['offset'](0x0);logger[_0xaa37('0x7e')]('Limited\x20Query:',_0x298739[_0xaa37('0x80')]());return dbH[_0xaa37('0x81')]['query'](_0x298739[_0xaa37('0x80')](),{'type':dbH[_0xaa37('0x81')][_0xaa37('0x9c')]['SELECT']});}})[_0xaa37('0x23')](function(){return{'sql':_0x4b318b[_0xaa37('0x80')]()};})[_0xaa37('0x23')](respondWithResult(_0x49c7db,null))['catch'](handleError(_0x49c7db,null));};
\ No newline at end of file
+var _0xc094=['rawAttributes','fieldName','type','key','query','keys','intersection','attributes','model','fields','length','hasOwnProperty','nolimit','order','sort','where','filters','filter','merge','VIRTUAL','options','includeAll','include','findAll','rows','show','params','find','catch','create','body','role','user','Reports','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','preview','left_join','cross_join','SUM(%s)','COUNT(%s)','MAX(%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)','UNIX_TIMESTAMP(%s)','includes','IS\x20NOT\x20NULL','IS\x20EMPTY','rules','operator','group','condition','getFields','Sequelize','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','from','table','MetricId','metric','field','function','format','replace','orderBy','DESC','alias','joins','parse','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','join','right_join','COUNT(DISTINCT\x20%s)','IS\x20NOT\x20EMPTY','value','ValidationErrorItem','groupBy','output','fullPath','generate','custom','AnalyticExtractedReport','startDate','endDate','info','Run\x20Query:','child_process','../../components/export/','savename','select','countTable','COUNT(*)','run','runReport','MIN(%s)','ROUND(%s)','IS\x20NULL','eml-format','zip-dir','fast-json-patch','request-promise','bluebird','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/utils','../../mysqldb','dbH','sendStatus','end','status','json','limit','undefined','offset','count','Content-Range','apply','reject','save','update','then','get','UserProfileResource','stack','name','index','map','AnalyticCustomReport'];(function(_0x4953da,_0x5adaca){var _0x2d3780=function(_0x458f36){while(--_0x458f36){_0x4953da['push'](_0x4953da['shift']());}};_0x2d3780(++_0x5adaca);}(_0xc094,0x71));var _0x4c09=function(_0x33100a,_0x55d520){_0x33100a=_0x33100a-0x0;var _0x84faac=_0xc094[_0x33100a];return _0x84faac;};'use strict';var emlformat=require(_0x4c09('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x4c09('0x1'));var jsonpatch=require(_0x4c09('0x2'));var rp=require(_0x4c09('0x3'));var moment=require('moment');var BPromise=require(_0x4c09('0x4'));var Mustache=require('mustache');var util=require(_0x4c09('0x5'));var path=require(_0x4c09('0x6'));var sox=require(_0x4c09('0x7'));var csv=require(_0x4c09('0x8'));var ejs=require(_0x4c09('0x9'));var fs=require('fs');var fs_extra=require(_0x4c09('0xa'));var _=require(_0x4c09('0xb'));var squel=require(_0x4c09('0xc'));var crypto=require('crypto');var jsforce=require(_0x4c09('0xd'));var deskjs=require('desk.js');var toCsv=require(_0x4c09('0x8'));var querystring=require(_0x4c09('0xe'));var Papa=require(_0x4c09('0xf'));var Redis=require(_0x4c09('0x10'));var authService=require(_0x4c09('0x11'));var qs=require(_0x4c09('0x12'));var as=require(_0x4c09('0x13'));var hardwareService=require(_0x4c09('0x14'));var logger=require('../../config/logger')('api');var utils=require(_0x4c09('0x15'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];var dbH=require(_0x4c09('0x16'))[_0x4c09('0x17')];function respondWithStatusCode(_0x71249f,_0x38274e){_0x38274e=_0x38274e||0xcc;return function(_0x362042){if(_0x362042){return _0x71249f[_0x4c09('0x18')](_0x38274e);}return _0x71249f['status'](_0x38274e)[_0x4c09('0x19')]();};}function respondWithResult(_0x4db0e2,_0x55899a){_0x55899a=_0x55899a||0xc8;return function(_0x59fa47){if(_0x59fa47){return _0x4db0e2[_0x4c09('0x1a')](_0x55899a)[_0x4c09('0x1b')](_0x59fa47);}};}function respondWithFilteredResult(_0x14bf5f,_0x2b99d5){return function(_0x3851a5){if(_0x3851a5){var _0x5ee4e4=typeof _0x2b99d5['offset']==='undefined'&&typeof _0x2b99d5[_0x4c09('0x1c')]===_0x4c09('0x1d');var _0x50cc4e=_0x3851a5['count'];var _0x378bff=_0x5ee4e4?0x0:_0x2b99d5[_0x4c09('0x1e')];var _0x399de8=_0x5ee4e4?_0x3851a5[_0x4c09('0x1f')]:_0x2b99d5[_0x4c09('0x1e')]+_0x2b99d5[_0x4c09('0x1c')];var _0x5e999d;if(_0x399de8>=_0x50cc4e){_0x399de8=_0x50cc4e;_0x5e999d=0xc8;}else{_0x5e999d=0xce;}_0x14bf5f[_0x4c09('0x1a')](_0x5e999d);return _0x14bf5f['set'](_0x4c09('0x20'),_0x378bff+'-'+_0x399de8+'/'+_0x50cc4e)['json'](_0x3851a5);}return null;};}function patchUpdates(_0x19e794){return function(_0x23fbff){try{jsonpatch[_0x4c09('0x21')](_0x23fbff,_0x19e794,!![]);}catch(_0x222d5e){return BPromise[_0x4c09('0x22')](_0x222d5e);}return _0x23fbff[_0x4c09('0x23')]();};}function saveUpdates(_0x27d848,_0xf8ecc){return function(_0x156565){if(_0x156565){return _0x156565[_0x4c09('0x24')](_0x27d848)['then'](function(_0x416b90){return _0x416b90;});}return null;};}function removeEntity(_0x4563eb,_0x2eef0d){return function(_0x187606){if(_0x187606){return _0x187606['destroy']()[_0x4c09('0x25')](function(){var _0x1f7404=_0x187606[_0x4c09('0x26')]({'plain':!![]});var _0x3a07ac='CustomReports';return db[_0x4c09('0x27')]['destroy']({'where':{'type':_0x3a07ac,'resourceId':_0x1f7404['id']}})[_0x4c09('0x25')](function(){return _0x187606;});})[_0x4c09('0x25')](function(){_0x4563eb[_0x4c09('0x1a')](0xcc)['end']();});}};}function handleEntityNotFound(_0x1f557d,_0x38660b){return function(_0x710511){if(!_0x710511){_0x1f557d[_0x4c09('0x18')](0x194);}return _0x710511;};}function handleError(_0x4bf7d4,_0x47dc77){_0x47dc77=_0x47dc77||0x1f4;return function(_0x3990c8){logger['error'](_0x3990c8[_0x4c09('0x28')]);if(_0x3990c8['name']){delete _0x3990c8[_0x4c09('0x29')];}_0x4bf7d4['status'](_0x47dc77)['send'](_0x3990c8);};}exports[_0x4c09('0x2a')]=function(_0x222388,_0x49b396){var _0x1d7006={},_0x3227f7={},_0xa983d3={'count':0x0,'rows':[]};var _0x13c3c2=_[_0x4c09('0x2b')](db[_0x4c09('0x2c')][_0x4c09('0x2d')],function(_0x5b70bb){return{'name':_0x5b70bb[_0x4c09('0x2e')],'type':_0x5b70bb[_0x4c09('0x2f')][_0x4c09('0x30')]};});_0x3227f7['model']=_[_0x4c09('0x2b')](_0x13c3c2,_0x4c09('0x29'));_0x3227f7[_0x4c09('0x31')]=_[_0x4c09('0x32')](_0x222388[_0x4c09('0x31')]);_0x3227f7['filters']=_[_0x4c09('0x33')](_0x3227f7['model'],_0x3227f7[_0x4c09('0x31')]);_0x1d7006[_0x4c09('0x34')]=_[_0x4c09('0x33')](_0x3227f7[_0x4c09('0x35')],qs['fields'](_0x222388['query'][_0x4c09('0x36')]));_0x1d7006['attributes']=_0x1d7006[_0x4c09('0x34')][_0x4c09('0x37')]?_0x1d7006[_0x4c09('0x34')]:_0x3227f7[_0x4c09('0x35')];if(!_0x222388[_0x4c09('0x31')][_0x4c09('0x38')](_0x4c09('0x39'))){_0x1d7006[_0x4c09('0x1c')]=qs['limit'](_0x222388[_0x4c09('0x31')]['limit']);_0x1d7006[_0x4c09('0x1e')]=qs[_0x4c09('0x1e')](_0x222388[_0x4c09('0x31')]['offset']);}_0x1d7006[_0x4c09('0x3a')]=qs[_0x4c09('0x3b')](_0x222388[_0x4c09('0x31')][_0x4c09('0x3b')]);_0x1d7006[_0x4c09('0x3c')]=qs['filters'](_['pick'](_0x222388['query'],_0x3227f7[_0x4c09('0x3d')]),_0x13c3c2);if(_0x222388[_0x4c09('0x31')][_0x4c09('0x3e')]){_0x1d7006[_0x4c09('0x3c')]=_[_0x4c09('0x3f')](_0x1d7006[_0x4c09('0x3c')],{'$or':_[_0x4c09('0x2b')](_0x13c3c2,function(_0x32792f){if(_0x32792f['type']!==_0x4c09('0x40')){var _0x45d98c={};_0x45d98c[_0x32792f[_0x4c09('0x29')]]={'$like':'%'+_0x222388[_0x4c09('0x31')][_0x4c09('0x3e')]+'%'};return _0x45d98c;}})});}_0x1d7006=_['merge']({},_0x1d7006,_0x222388[_0x4c09('0x41')]);var _0x43e35f={'where':_0x1d7006[_0x4c09('0x3c')]};return db[_0x4c09('0x2c')][_0x4c09('0x1f')](_0x43e35f)[_0x4c09('0x25')](function(_0x2129de){_0xa983d3[_0x4c09('0x1f')]=_0x2129de;if(_0x222388[_0x4c09('0x31')][_0x4c09('0x42')]){_0x1d7006[_0x4c09('0x43')]=[{'all':!![]}];}return db['AnalyticCustomReport'][_0x4c09('0x44')](_0x1d7006);})[_0x4c09('0x25')](function(_0x197437){_0xa983d3[_0x4c09('0x45')]=_0x197437;return _0xa983d3;})[_0x4c09('0x25')](respondWithFilteredResult(_0x49b396,_0x1d7006))['catch'](handleError(_0x49b396,null));};exports[_0x4c09('0x46')]=function(_0x3fcfbc,_0x3f72c8){var _0x1f238b={'raw':![],'where':{'id':_0x3fcfbc[_0x4c09('0x47')]['id']}},_0x21bb31={};_0x21bb31[_0x4c09('0x35')]=_[_0x4c09('0x32')](db[_0x4c09('0x2c')][_0x4c09('0x2d')]);_0x21bb31['query']=_['keys'](_0x3fcfbc['query']);_0x21bb31[_0x4c09('0x3d')]=_[_0x4c09('0x33')](_0x21bb31['model'],_0x21bb31['query']);_0x1f238b[_0x4c09('0x34')]=_[_0x4c09('0x33')](_0x21bb31[_0x4c09('0x35')],qs[_0x4c09('0x36')](_0x3fcfbc[_0x4c09('0x31')][_0x4c09('0x36')]));_0x1f238b[_0x4c09('0x34')]=_0x1f238b[_0x4c09('0x34')]['length']?_0x1f238b[_0x4c09('0x34')]:_0x21bb31[_0x4c09('0x35')];if(_0x3fcfbc[_0x4c09('0x31')][_0x4c09('0x42')]){_0x1f238b['include']=[{'all':!![]}];}_0x1f238b=_[_0x4c09('0x3f')]({},_0x1f238b,_0x3fcfbc['options']);return db[_0x4c09('0x2c')][_0x4c09('0x48')](_0x1f238b)[_0x4c09('0x25')](handleEntityNotFound(_0x3f72c8,null))[_0x4c09('0x25')](respondWithResult(_0x3f72c8,null))[_0x4c09('0x49')](handleError(_0x3f72c8,null));};exports[_0x4c09('0x4a')]=function(_0x3f0110,_0x44f999){return db[_0x4c09('0x2c')][_0x4c09('0x4a')](_0x3f0110[_0x4c09('0x4b')],{})[_0x4c09('0x25')](function(_0x5b469f){var _0x55457c=_0x3f0110['user']['get']({'plain':!![]});if(!_0x55457c)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x55457c[_0x4c09('0x4c')]===_0x4c09('0x4d')){var _0x56360e=_0x5b469f[_0x4c09('0x26')]({'plain':!![]});var _0x26d330=_0x4c09('0x4e');return db['UserProfileSection']['find']({'where':{'name':_0x26d330,'userProfileId':_0x55457c[_0x4c09('0x4f')]},'raw':!![]})['then'](function(_0x54dea8){if(_0x54dea8&&_0x54dea8['autoAssociation']===0x0){return db[_0x4c09('0x27')][_0x4c09('0x4a')]({'name':_0x56360e['name'],'resourceId':_0x56360e['id'],'type':'CustomReports','sectionId':_0x54dea8['id']},{})['then'](function(){return _0x5b469f;});}else{return _0x5b469f;}})['catch'](function(_0x43c161){logger['error'](_0x4c09('0x50'),_0x43c161);throw _0x43c161;});}return _0x5b469f;})['then'](respondWithResult(_0x44f999,0xc9))['catch'](handleError(_0x44f999,null));};exports[_0x4c09('0x24')]=function(_0x163a3e,_0x183813){if(_0x163a3e[_0x4c09('0x4b')]['id']){delete _0x163a3e[_0x4c09('0x4b')]['id'];}return db[_0x4c09('0x2c')][_0x4c09('0x48')]({'where':{'id':_0x163a3e[_0x4c09('0x47')]['id']}})[_0x4c09('0x25')](handleEntityNotFound(_0x183813,null))['then'](saveUpdates(_0x163a3e[_0x4c09('0x4b')],null))[_0x4c09('0x25')](respondWithResult(_0x183813,null))[_0x4c09('0x49')](handleError(_0x183813,null));};exports['destroy']=function(_0x18db97,_0x3b4201){return db[_0x4c09('0x2c')][_0x4c09('0x48')]({'where':{'id':_0x18db97[_0x4c09('0x47')]['id']}})['then'](handleEntityNotFound(_0x3b4201,null))[_0x4c09('0x25')](removeEntity(_0x3b4201,null))[_0x4c09('0x49')](handleError(_0x3b4201,null));};exports[_0x4c09('0x51')]=function(_0x3d96ee,_0x550da9){var _0x10eef6=0xa;var _0x38c2b0=['join',_0x4c09('0x52'),'right_join',_0x4c09('0x53')];var _0x505d9e={'SUM':_0x4c09('0x54'),'COUNT':_0x4c09('0x55'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x4c09('0x56'),'MIN':'MIN(%s)','AVG':_0x4c09('0x57'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x4c09('0x58'),'GROUP_CONCAT DESC':_0x4c09('0x59')};var _0x536269={'SEC_TO_TIME':_0x4c09('0x5a'),'DATE':_0x4c09('0x5b'),'HOUR':_0x4c09('0x5c'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x4c09('0x5d')};var _0x8704a7=function(_0x4e70eb){return!_[_0x4c09('0x5e')](['IS\x20NULL',_0x4c09('0x5f'),_0x4c09('0x60'),'IS\x20NOT\x20EMPTY'],_0x4e70eb);};var _0x46db79=function(_0xbfd75a){if(!_0xbfd75a||!_0xbfd75a[_0x4c09('0x61')]['length']){return'';}for(var _0x59bb8b='(',_0x305521=0x0;_0x305521<_0xbfd75a['rules']['length'];_0x305521+=0x1){_0x305521>0x0&&(_0x59bb8b+='\x20'+_0xbfd75a[_0x4c09('0x62')]+'\x20');_0x59bb8b+=_0xbfd75a[_0x4c09('0x61')][_0x305521]['group']?_0x46db79(_0xbfd75a[_0x4c09('0x61')][_0x305521][_0x4c09('0x63')]):_0xbfd75a[_0x4c09('0x61')][_0x305521]['field']+'\x20'+_0xbfd75a[_0x4c09('0x61')][_0x305521][_0x4c09('0x64')]+(_0x8704a7(_0xbfd75a[_0x4c09('0x61')][_0x305521][_0x4c09('0x64')])?'\x20'+_0xbfd75a['rules'][_0x305521]['value']:'');}return _0x59bb8b+')';};var _0x898d76={'where':{'id':_0x3d96ee[_0x4c09('0x47')]['id']}},_0x5b79f4,_0x43671f,_0x19c192,_0x1bace9,_0x31f952;_0x898d76=_[_0x4c09('0x3f')]({},_0x898d76,_0x3d96ee['options']);return db[_0x4c09('0x2c')][_0x4c09('0x48')](_0x898d76)[_0x4c09('0x25')](function(_0x427d9d){if(_0x427d9d){_0x5b79f4=_0x427d9d;return _0x427d9d[_0x4c09('0x65')]();}return null;})[_0x4c09('0x25')](function(_0x190a02){if(_0x190a02){if(!_0x190a02[_0x4c09('0x37')]){throw new db[(_0x4c09('0x66'))]['ValidationErrorItem'](_0x4c09('0x67'),0x193);}_0x43671f=_0x190a02;return db[_0x4c09('0x68')][_0x4c09('0x44')]({'raw':!![]});}return null;})[_0x4c09('0x25')](function(_0x45f542){if(_0x45f542){_0x19c192=_[_0x4c09('0x69')](_0x45f542,'id');var _0x51fc80;var _0x4b9bba=squel['select']();_0x4b9bba[_0x4c09('0x6a')](_0x5b79f4[_0x4c09('0x6b')]);for(var _0x1395cd=0x0;_0x1395cd<_0x43671f[_0x4c09('0x37')];_0x1395cd+=0x1){_0x51fc80=_0x43671f[_0x1395cd]['MetricId']?_0x19c192[_0x43671f[_0x1395cd][_0x4c09('0x6c')]][_0x4c09('0x6d')]:_0x43671f[_0x1395cd][_0x4c09('0x6e')];_0x51fc80=_0x43671f[_0x1395cd][_0x4c09('0x6f')]?_['replace'](_0x505d9e[_0x43671f[_0x1395cd][_0x4c09('0x6f')]],'%s',_0x51fc80):_0x51fc80;_0x51fc80=_0x43671f[_0x1395cd][_0x4c09('0x70')]?_[_0x4c09('0x71')](_0x536269[_0x43671f[_0x1395cd]['format']],'%s',_0x51fc80):_0x51fc80;if(_0x43671f[_0x1395cd]['groupBy']){_0x4b9bba[_0x4c09('0x63')](_0x51fc80);}_0x43671f[_0x1395cd][_0x4c09('0x72')]&&_0x4b9bba[_0x4c09('0x3a')](_0x51fc80,_0x43671f[_0x1395cd][_0x4c09('0x72')]===_0x4c09('0x73')?![]:!![]);_0x4b9bba[_0x4c09('0x6e')](_0x51fc80,_0x43671f[_0x1395cd][_0x4c09('0x74')]||_0x51fc80);}if(_0x5b79f4[_0x4c09('0x75')]){_0x5b79f4[_0x4c09('0x75')]=JSON[_0x4c09('0x76')](_0x5b79f4[_0x4c09('0x75')]);for(var _0x51508a=0x0;_0x51508a<_0x5b79f4[_0x4c09('0x75')][_0x4c09('0x37')];_0x51508a+=0x1){if(_0x5b79f4[_0x4c09('0x75')][_0x51508a]['type']&&_[_0x4c09('0x5e')](_0x38c2b0,_0x5b79f4['joins'][_0x51508a][_0x4c09('0x2f')])&&_0x5b79f4[_0x4c09('0x75')][_0x51508a][_0x4c09('0x77')]&&_0x5b79f4[_0x4c09('0x75')][_0x51508a][_0x4c09('0x78')]&&_0x5b79f4[_0x4c09('0x75')][_0x51508a][_0x4c09('0x79')]){_0x4b9bba[_0x5b79f4['joins'][_0x51508a]['type']](_0x5b79f4['joins'][_0x51508a][_0x4c09('0x78')],null,util[_0x4c09('0x70')](_0x4c09('0x7a'),_0x5b79f4[_0x4c09('0x6b')],_0x5b79f4[_0x4c09('0x75')][_0x51508a][_0x4c09('0x77')],_0x5b79f4['joins'][_0x51508a][_0x4c09('0x78')],_0x5b79f4[_0x4c09('0x75')][_0x51508a][_0x4c09('0x79')]));}}}if(_0x5b79f4[_0x4c09('0x7b')]){_0x5b79f4[_0x4c09('0x7b')]=JSON[_0x4c09('0x76')](_0x5b79f4[_0x4c09('0x7b')]);_0x4b9bba['where'](_0x46db79(_0x5b79f4['conditions']['group']));}_0x31f952=_0x4b9bba[_0x4c09('0x7c')]();_0x4b9bba[_0x4c09('0x1c')](_0x10eef6);_0x4b9bba[_0x4c09('0x1e')](0x0);logger[_0x4c09('0x7d')](_0x4c09('0x7e'),_0x4b9bba[_0x4c09('0x7f')]());return dbH[_0x4c09('0x80')][_0x4c09('0x31')](_0x4b9bba[_0x4c09('0x7f')](),{'type':dbH[_0x4c09('0x80')][_0x4c09('0x81')][_0x4c09('0x82')]});}})[_0x4c09('0x25')](respondWithResult(_0x550da9,null))[_0x4c09('0x49')](handleError(_0x550da9,null));};function runReport(_0x173a3d,_0xffb5e1,_0x3e60c3){var _0x5e3484=_0xffb5e1[_0x4c09('0x29')];var _0xc82fa9=0xa;var _0x5aecb6=[_0x4c09('0x83'),_0x4c09('0x52'),_0x4c09('0x84'),_0x4c09('0x53')];var _0x258a99={'SUM':_0x4c09('0x54'),'COUNT':_0x4c09('0x55'),'COUNT DISTINCT':_0x4c09('0x85'),'MAX':_0x4c09('0x56'),'MIN':'MIN(%s)','AVG':'AVG(%s)','GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x131b3d={'SEC_TO_TIME':_0x4c09('0x5a'),'DATE':'DATE(%s)','HOUR':_0x4c09('0x5c'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x207d1a=function(_0x342b69){return!_[_0x4c09('0x5e')](['IS\x20NULL',_0x4c09('0x5f'),_0x4c09('0x60'),_0x4c09('0x86')],_0x342b69);};var _0x49136b=function(_0x330a20){if(!_0x330a20||!_0x330a20[_0x4c09('0x61')][_0x4c09('0x37')]){return'';}for(var _0x15abd7='(',_0x13a26d=0x0;_0x13a26d<_0x330a20['rules'][_0x4c09('0x37')];_0x13a26d+=0x1){_0x13a26d>0x0&&(_0x15abd7+='\x20'+_0x330a20[_0x4c09('0x62')]+'\x20');_0x15abd7+=_0x330a20['rules'][_0x13a26d][_0x4c09('0x63')]?_0x49136b(_0x330a20['rules'][_0x13a26d][_0x4c09('0x63')]):_0x330a20[_0x4c09('0x61')][_0x13a26d]['field']+'\x20'+_0x330a20[_0x4c09('0x61')][_0x13a26d][_0x4c09('0x64')]+(_0x207d1a(_0x330a20[_0x4c09('0x61')][_0x13a26d][_0x4c09('0x64')])?'\x20'+_0x330a20[_0x4c09('0x61')][_0x13a26d][_0x4c09('0x87')]:'');}return _0x15abd7+')';};var _0x5b631c={'where':{'id':_0x173a3d['id']}},_0x4512be,_0x8097f3,_0x333a00,_0x2fcbca,_0x131894;_0x5b631c=_[_0x4c09('0x3f')]({},_0x5b631c,_0x3e60c3);return db[_0x4c09('0x2c')][_0x4c09('0x48')](_0x5b631c)[_0x4c09('0x25')](function(_0x523428){if(_0x523428){_0x4512be=_0x523428;return _0x523428['getFields']();}return null;})[_0x4c09('0x25')](function(_0x31c73f){if(_0x31c73f){if(!_0x31c73f['length']){throw new db[(_0x4c09('0x66'))][(_0x4c09('0x88'))](_0x4c09('0x67'),0x193);}_0x8097f3=_0x31c73f;return db[_0x4c09('0x68')][_0x4c09('0x44')]({'raw':!![]});}return null;})[_0x4c09('0x25')](function(_0x16bdea){if(_0x16bdea){_0x333a00=_[_0x4c09('0x69')](_0x16bdea,'id');var _0x3c69d4;var _0xa1147f=squel['select']();_0xa1147f[_0x4c09('0x6a')](_0x4512be['table']);for(var _0x5b0b35=0x0;_0x5b0b35<_0x8097f3[_0x4c09('0x37')];_0x5b0b35+=0x1){_0x3c69d4=_0x8097f3[_0x5b0b35][_0x4c09('0x6c')]?_0x333a00[_0x8097f3[_0x5b0b35][_0x4c09('0x6c')]]['metric']:_0x8097f3[_0x5b0b35][_0x4c09('0x6e')];_0x3c69d4=_0x8097f3[_0x5b0b35][_0x4c09('0x6f')]?_[_0x4c09('0x71')](_0x258a99[_0x8097f3[_0x5b0b35][_0x4c09('0x6f')]],'%s',_0x3c69d4):_0x3c69d4;_0x3c69d4=_0x8097f3[_0x5b0b35][_0x4c09('0x70')]?_['replace'](_0x131b3d[_0x8097f3[_0x5b0b35][_0x4c09('0x70')]],'%s',_0x3c69d4):_0x3c69d4;if(_0x8097f3[_0x5b0b35][_0x4c09('0x89')]){_0xa1147f[_0x4c09('0x63')](_0x3c69d4);}_0x8097f3[_0x5b0b35][_0x4c09('0x72')]&&_0xa1147f['order'](_0x3c69d4,_0x8097f3[_0x5b0b35][_0x4c09('0x72')]===_0x4c09('0x73')?![]:!![]);_0xa1147f[_0x4c09('0x6e')](_0x3c69d4,_0x8097f3[_0x5b0b35][_0x4c09('0x74')]||_0x3c69d4);}if(_0x4512be[_0x4c09('0x75')]){_0x4512be[_0x4c09('0x75')]=JSON[_0x4c09('0x76')](_0x4512be['joins']);for(var _0x383aa5=0x0;_0x383aa5<_0x4512be[_0x4c09('0x75')][_0x4c09('0x37')];_0x383aa5+=0x1){if(_0x4512be[_0x4c09('0x75')][_0x383aa5][_0x4c09('0x2f')]&&_[_0x4c09('0x5e')](_0x5aecb6,_0x4512be[_0x4c09('0x75')][_0x383aa5][_0x4c09('0x2f')])&&_0x4512be[_0x4c09('0x75')][_0x383aa5]['parentKey']&&_0x4512be['joins'][_0x383aa5][_0x4c09('0x78')]&&_0x4512be[_0x4c09('0x75')][_0x383aa5][_0x4c09('0x79')]){_0xa1147f[_0x4512be['joins'][_0x383aa5][_0x4c09('0x2f')]](_0x4512be[_0x4c09('0x75')][_0x383aa5][_0x4c09('0x78')],null,util['format']('%s.%s\x20=\x20%s.%s',_0x4512be['table'],_0x4512be[_0x4c09('0x75')][_0x383aa5][_0x4c09('0x77')],_0x4512be[_0x4c09('0x75')][_0x383aa5][_0x4c09('0x78')],_0x4512be['joins'][_0x383aa5][_0x4c09('0x79')]));}}}if(_0x4512be[_0x4c09('0x7b')]){_0x4512be['conditions']=JSON[_0x4c09('0x76')](_0x4512be[_0x4c09('0x7b')]);_0xa1147f[_0x4c09('0x3c')](_0x49136b(_0x4512be[_0x4c09('0x7b')]['group']));}_0x131894=_0xa1147f[_0x4c09('0x7c')]();_0xa1147f[_0x4c09('0x1c')](_0xc82fa9);_0xa1147f[_0x4c09('0x1e')](0x0);return;}})[_0x4c09('0x25')](function(){if(_0xffb5e1[_0x4c09('0x8a')]==='web'){return null;}var _0x199d0e=_['merge'](_0xffb5e1,{'name':_0xffb5e1[_0x4c09('0x8b')]||_0xffb5e1[_0x4c09('0x29')]||_0x4512be[_0x4c09('0x29')],'basename':_0x5e3484,'savename':util[_0x4c09('0x70')]('%s-%s.%s',_0xffb5e1[_0x4c09('0x29')]||_0x4512be['name'],require('randomstring')[_0x4c09('0x8c')](0x4),_0xffb5e1['output']||'csv'),'reportId':_0x4512be['id'],'reportType':_0x4c09('0x8d')});return db[_0x4c09('0x8e')][_0x4c09('0x4a')](_0x199d0e,{'raw':!![]});})[_0x4c09('0x25')](function(_0x2165ec){if(_0x4512be[_0x4c09('0x6b')]==='cdr'){_0x131894[_0x4c09('0x3c')](_0x4512be[_0x4c09('0x6b')]+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0xffb5e1[_0x4c09('0x8f')],_0xffb5e1[_0x4c09('0x90')]);}else{_0x131894['where'](_0x4512be[_0x4c09('0x6b')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0xffb5e1[_0x4c09('0x8f')],_0xffb5e1[_0x4c09('0x90')]);}if(_0x2165ec){logger[_0x4c09('0x91')](_0x4c09('0x92'),_0x131894['toString']());require(_0x4c09('0x93'))['fork'](path[_0x4c09('0x83')](__dirname,_0x4c09('0x94'),_0x2165ec[_0x4c09('0x8a')]),[_0x2165ec['id'],_0x131894['toString'](),path[_0x4c09('0x83')](__dirname,'../../files/reports',_0x2165ec[_0x4c09('0x95')]),_0x5e3484]);return _0x2165ec;}else{var _0x18253b=squel[_0x4c09('0x96')]();_0x18253b[_0x4c09('0x6a')]('('+_0x131894['toString']()+')',_0x4c09('0x97'));_0x18253b[_0x4c09('0x6e')](_0x4c09('0x98'),_0x4c09('0x1f'));_0x131894[_0x4c09('0x1c')](_0xffb5e1['limit']||_0xc82fa9);_0x131894[_0x4c09('0x1e')](_0xffb5e1[_0x4c09('0x1e')]||0x0);return dbH[_0x4c09('0x80')][_0x4c09('0x31')](_0x18253b[_0x4c09('0x7f')](),{'type':dbH[_0x4c09('0x80')][_0x4c09('0x81')][_0x4c09('0x82')]})[_0x4c09('0x25')](function(_0x189088){if(!_0x189088[_0x4c09('0x37')]){_0x2fcbca=0x0;}else{_0x2fcbca=_0x189088[0x0][_0x4c09('0x1f')]||0x0;}return dbH[_0x4c09('0x80')][_0x4c09('0x31')](_0x131894['toString'](),{'type':dbH['sequelize']['QueryTypes'][_0x4c09('0x82')]});})[_0x4c09('0x25')](function(_0x39329e){return{'rows':_0x39329e||[],'count':_0x2fcbca};});}});}exports[_0x4c09('0x99')]=function(_0x1e0c86,_0x5551d2){return runReport(_0x1e0c86[_0x4c09('0x47')],_0x1e0c86[_0x4c09('0x31')],_0x1e0c86[_0x4c09('0x41')])[_0x4c09('0x25')](respondWithResult(_0x5551d2,null))['catch'](handleError(_0x5551d2,null));};exports[_0x4c09('0x9a')]=runReport;exports['query']=function(_0xc29ab0,_0xb62626){var _0xaa7354=0xa;var _0x53e30c=['join',_0x4c09('0x52'),_0x4c09('0x84'),_0x4c09('0x53')];var _0x4f1902={'SUM':'SUM(%s)','COUNT':_0x4c09('0x55'),'COUNT DISTINCT':_0x4c09('0x85'),'MAX':_0x4c09('0x56'),'MIN':_0x4c09('0x9b'),'AVG':'AVG(%s)','GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0x4c09('0x59')};var _0x16442e={'SEC_TO_TIME':_0x4c09('0x5a'),'DATE':_0x4c09('0x5b'),'HOUR':_0x4c09('0x5c'),'ROUND':_0x4c09('0x9c'),'UNIX_TIMESTAMP':_0x4c09('0x5d')};var _0x109116=function(_0x2a9227){return!_[_0x4c09('0x5e')]([_0x4c09('0x9d'),_0x4c09('0x5f'),'IS\x20EMPTY',_0x4c09('0x86')],_0x2a9227);};var _0x46b4c7=function(_0x31b5a0){if(!_0x31b5a0||!_0x31b5a0[_0x4c09('0x61')][_0x4c09('0x37')]){return'';}for(var _0x4d6b3d='(',_0x2a3444=0x0;_0x2a3444<_0x31b5a0[_0x4c09('0x61')]['length'];_0x2a3444+=0x1){_0x2a3444>0x0&&(_0x4d6b3d+='\x20'+_0x31b5a0[_0x4c09('0x62')]+'\x20');_0x4d6b3d+=_0x31b5a0['rules'][_0x2a3444][_0x4c09('0x63')]?_0x46b4c7(_0x31b5a0[_0x4c09('0x61')][_0x2a3444]['group']):_0x31b5a0[_0x4c09('0x61')][_0x2a3444]['field']+'\x20'+_0x31b5a0[_0x4c09('0x61')][_0x2a3444][_0x4c09('0x64')]+(_0x109116(_0x31b5a0[_0x4c09('0x61')][_0x2a3444][_0x4c09('0x64')])?'\x20'+_0x31b5a0[_0x4c09('0x61')][_0x2a3444]['value']:'');}return _0x4d6b3d+')';};var _0x5b10ff={'where':{'id':_0xc29ab0['params']['id']}},_0xd3c57c,_0x2cc8e7,_0x5ab7b0,_0x4b5897,_0x1c4fa9;_0x5b10ff=_['merge']({},_0x5b10ff,_0xc29ab0[_0x4c09('0x41')]);return db[_0x4c09('0x2c')]['find'](_0x5b10ff)['then'](function(_0x5e72a2){if(_0x5e72a2){_0xd3c57c=_0x5e72a2;return _0x5e72a2[_0x4c09('0x65')]();}return null;})[_0x4c09('0x25')](function(_0x9a80b5){if(_0x9a80b5){if(!_0x9a80b5[_0x4c09('0x37')]){throw new db['Sequelize'][(_0x4c09('0x88'))](_0x4c09('0x67'),0x193);}_0x2cc8e7=_0x9a80b5;return db['AnalyticMetric'][_0x4c09('0x44')]({'raw':!![]});}return null;})[_0x4c09('0x25')](function(_0xefc867){if(_0xefc867){_0x5ab7b0=_[_0x4c09('0x69')](_0xefc867,'id');var _0x3cb80f;var _0x260f8e=squel[_0x4c09('0x96')]();_0x260f8e[_0x4c09('0x6a')](_0xd3c57c[_0x4c09('0x6b')]);for(var _0x21deee=0x0;_0x21deee<_0x2cc8e7['length'];_0x21deee+=0x1){_0x3cb80f=_0x2cc8e7[_0x21deee]['MetricId']?_0x5ab7b0[_0x2cc8e7[_0x21deee][_0x4c09('0x6c')]]['metric']:_0x2cc8e7[_0x21deee][_0x4c09('0x6e')];_0x3cb80f=_0x2cc8e7[_0x21deee][_0x4c09('0x6f')]?_[_0x4c09('0x71')](_0x4f1902[_0x2cc8e7[_0x21deee][_0x4c09('0x6f')]],'%s',_0x3cb80f):_0x3cb80f;_0x3cb80f=_0x2cc8e7[_0x21deee][_0x4c09('0x70')]?_[_0x4c09('0x71')](_0x16442e[_0x2cc8e7[_0x21deee]['format']],'%s',_0x3cb80f):_0x3cb80f;if(_0x2cc8e7[_0x21deee][_0x4c09('0x89')]){_0x260f8e[_0x4c09('0x63')](_0x3cb80f);}_0x2cc8e7[_0x21deee][_0x4c09('0x72')]&&_0x260f8e['order'](_0x3cb80f,_0x2cc8e7[_0x21deee][_0x4c09('0x72')]===_0x4c09('0x73')?![]:!![]);_0x260f8e[_0x4c09('0x6e')](_0x3cb80f,_0x2cc8e7[_0x21deee][_0x4c09('0x74')]||_0x3cb80f);}if(_0xd3c57c[_0x4c09('0x75')]){_0xd3c57c[_0x4c09('0x75')]=JSON[_0x4c09('0x76')](_0xd3c57c['joins']);for(var _0x41ad1d=0x0;_0x41ad1d<_0xd3c57c[_0x4c09('0x75')]['length'];_0x41ad1d+=0x1){if(_0xd3c57c[_0x4c09('0x75')][_0x41ad1d]['type']&&_[_0x4c09('0x5e')](_0x53e30c,_0xd3c57c['joins'][_0x41ad1d][_0x4c09('0x2f')])&&_0xd3c57c[_0x4c09('0x75')][_0x41ad1d][_0x4c09('0x77')]&&_0xd3c57c[_0x4c09('0x75')][_0x41ad1d][_0x4c09('0x78')]&&_0xd3c57c[_0x4c09('0x75')][_0x41ad1d][_0x4c09('0x79')]){_0x260f8e[_0xd3c57c[_0x4c09('0x75')][_0x41ad1d]['type']](_0xd3c57c[_0x4c09('0x75')][_0x41ad1d][_0x4c09('0x78')],null,util[_0x4c09('0x70')](_0x4c09('0x7a'),_0xd3c57c[_0x4c09('0x6b')],_0xd3c57c['joins'][_0x41ad1d]['parentKey'],_0xd3c57c['joins'][_0x41ad1d][_0x4c09('0x78')],_0xd3c57c[_0x4c09('0x75')][_0x41ad1d][_0x4c09('0x79')]));}}}if(_0xd3c57c[_0x4c09('0x7b')]){_0xd3c57c[_0x4c09('0x7b')]=JSON[_0x4c09('0x76')](_0xd3c57c[_0x4c09('0x7b')]);_0x260f8e[_0x4c09('0x3c')](_0x46b4c7(_0xd3c57c[_0x4c09('0x7b')][_0x4c09('0x63')]));}_0x1c4fa9=_0x260f8e[_0x4c09('0x7c')]();_0x260f8e['limit'](_0xaa7354);_0x260f8e[_0x4c09('0x1e')](0x0);logger['debug']('Limited\x20Query:',_0x260f8e['toString']());return dbH['sequelize']['query'](_0x260f8e[_0x4c09('0x7f')](),{'type':dbH[_0x4c09('0x80')][_0x4c09('0x81')][_0x4c09('0x82')]});}})[_0x4c09('0x25')](function(){return{'sql':_0x1c4fa9[_0x4c09('0x7f')]()};})[_0x4c09('0x25')](respondWithResult(_0xb62626,null))['catch'](handleError(_0xb62626,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff