// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xda3f=['SELECT','No\x20available\x20data','web','fullPath','randomstring','generate','csv','default','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','Run\x20Query:','fork','output','savename','countTable','COUNT(*)','count','run','runReport','AVG(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','html-pdf','eml-format','zip-dir','request-promise','moment','bluebird','mustache','path','sox','ejs','lodash','squel','jsforce','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','dbH','sendStatus','end','status','json','offset','limit','set','Content-Range','apply','save','then','destroy','get','DefaultReports','UserProfileResource','stack','name','send','map','AnalyticDefaultReport','rawAttributes','fieldName','model','keys','filters','intersection','query','attributes','fields','sort','where','pick','filter','merge','type','VIRTUAL','includeAll','include','findAll','rows','catch','show','params','length','options','find','create','Unable\x20to\x20retrieve\x20the\x20current\x20user','Reports','UserProfileSection','error','update','body','preview','join','left_join','right_join','cross_join','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%s)','GROUP_CONCAT(%s)','DATE(%s)','HOUR(%s)','ROUND(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','value','Sequelize','ValidationErrorItem','AnalyticMetric','keyBy','select','from','MetricId','metric','function','replace','format','orderBy','order','field','joins','parse','foreignKey','foreignTable','table','conditions','debug','Limited\x20Query:','toString','sequelize','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','SEC_TO_TIME(%s)','UNIX_TIMESTAMP(%s)','condition','getFields','Please\x20insert\x20at\x20least\x20one\x20field','groupBy','alias','parentKey','%s.%s\x20=\x20%s.%s','clone','QueryTypes'];(function(_0x1e2080,_0x53283b){var _0x260111=function(_0x15da5e){while(--_0x15da5e){_0x1e2080['push'](_0x1e2080['shift']());}};_0x260111(++_0x53283b);}(_0xda3f,0x159));var _0xfda3=function(_0x27dfa0,_0x18b118){_0x27dfa0=_0x27dfa0-0x0;var _0x47701b=_0xda3f[_0x27dfa0];return _0x47701b;};'use strict';var pdf=require(_0xfda3('0x0'));var emlformat=require(_0xfda3('0x1'));var rimraf=require('rimraf');var zipdir=require(_0xfda3('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0xfda3('0x3'));var moment=require(_0xfda3('0x4'));var BPromise=require(_0xfda3('0x5'));var Mustache=require(_0xfda3('0x6'));var util=require('util');var path=require(_0xfda3('0x7'));var sox=require(_0xfda3('0x8'));var csv=require('to-csv');var ejs=require(_0xfda3('0x9'));var fs=require('fs');var _=require(_0xfda3('0xa'));var squel=require(_0xfda3('0xb'));var crypto=require('crypto');var jsforce=require(_0xfda3('0xc'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0xfda3('0xd'));var Redis=require(_0xfda3('0xe'));var authService=require(_0xfda3('0xf'));var qs=require(_0xfda3('0x10'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xfda3('0x11'));var logger=require(_0xfda3('0x12'))(_0xfda3('0x13'));var utils=require(_0xfda3('0x14'));var config=require(_0xfda3('0x15'));var db=require('../../mysqldb')['db'];var dbH=require(_0xfda3('0x16'))[_0xfda3('0x17')];function respondWithStatusCode(_0x42c4f0,_0x7b1eb1){_0x7b1eb1=_0x7b1eb1||0xcc;return function(_0xea9969){if(_0xea9969){return _0x42c4f0[_0xfda3('0x18')](_0x7b1eb1);}return _0x42c4f0['status'](_0x7b1eb1)[_0xfda3('0x19')]();};}function respondWithResult(_0xc70280,_0x13d98f){_0x13d98f=_0x13d98f||0xc8;return function(_0x53c893){if(_0x53c893){return _0xc70280[_0xfda3('0x1a')](_0x13d98f)[_0xfda3('0x1b')](_0x53c893);}};}function respondWithFilteredResult(_0x5ee1fd,_0x344292){return function(_0x4312c1){if(_0x4312c1){var _0x1496fd=_0x4312c1['count'],_0xf2fca=_0x344292['offset'],_0x1269e9=_0x344292[_0xfda3('0x1c')]+_0x344292[_0xfda3('0x1d')],_0x468ea7;if(_0x1269e9>=_0x1496fd){_0x1269e9=_0x1496fd;_0x468ea7=0xc8;}else{_0x468ea7=0xce;}_0x5ee1fd[_0xfda3('0x1a')](_0x468ea7);return _0x5ee1fd[_0xfda3('0x1e')](_0xfda3('0x1f'),_0xf2fca+'-'+_0x1269e9+'/'+_0x1496fd)[_0xfda3('0x1b')](_0x4312c1);}return null;};}function patchUpdates(_0x104556){return function(_0x223cf6){try{jsonpatch[_0xfda3('0x20')](_0x223cf6,_0x104556,!![]);}catch(_0x5c4d1e){return BPromise['reject'](_0x5c4d1e);}return _0x223cf6[_0xfda3('0x21')]();};}function saveUpdates(_0x3e91e5,_0x5a184f){return function(_0x433485){if(_0x433485){return _0x433485['update'](_0x3e91e5)[_0xfda3('0x22')](function(_0x25946a){return _0x25946a;});}return null;};}function removeEntity(_0x3e81c8,_0x2a264d){return function(_0x13b4ea){if(_0x13b4ea){return _0x13b4ea[_0xfda3('0x23')]()[_0xfda3('0x22')](function(){var _0x13f0c7=_0x13b4ea[_0xfda3('0x24')]({'plain':!![]});var _0x540e14=_0xfda3('0x25');return db[_0xfda3('0x26')][_0xfda3('0x23')]({'where':{'type':_0x540e14,'resourceId':_0x13f0c7['id']}})[_0xfda3('0x22')](function(){return _0x13b4ea;});})[_0xfda3('0x22')](function(){_0x3e81c8[_0xfda3('0x1a')](0xcc)[_0xfda3('0x19')]();});}};}function handleEntityNotFound(_0x2dfca,_0x45415b){return function(_0x300306){if(!_0x300306){_0x2dfca[_0xfda3('0x18')](0x194);}return _0x300306;};}function handleError(_0x1ea340,_0x1b434d){_0x1b434d=_0x1b434d||0x1f4;return function(_0x53f2c8){logger['error'](_0x53f2c8[_0xfda3('0x27')]);if(_0x53f2c8['name']){delete _0x53f2c8[_0xfda3('0x28')];}_0x1ea340[_0xfda3('0x1a')](_0x1b434d)[_0xfda3('0x29')](_0x53f2c8);};}exports['index']=function(_0x29bb55,_0x18d2ff){var _0x2d43e={},_0x4d816d={},_0x46979b={'count':0x0,'rows':[]};var _0x420290=_[_0xfda3('0x2a')](db[_0xfda3('0x2b')][_0xfda3('0x2c')],function(_0x23550c){return{'name':_0x23550c[_0xfda3('0x2d')],'type':_0x23550c['type']['key']};});_0x4d816d[_0xfda3('0x2e')]=_[_0xfda3('0x2a')](_0x420290,_0xfda3('0x28'));_0x4d816d['query']=_[_0xfda3('0x2f')](_0x29bb55['query']);_0x4d816d[_0xfda3('0x30')]=_[_0xfda3('0x31')](_0x4d816d[_0xfda3('0x2e')],_0x4d816d[_0xfda3('0x32')]);_0x2d43e[_0xfda3('0x33')]=_[_0xfda3('0x31')](_0x4d816d[_0xfda3('0x2e')],qs[_0xfda3('0x34')](_0x29bb55[_0xfda3('0x32')][_0xfda3('0x34')]));_0x2d43e['attributes']=_0x2d43e['attributes']['length']?_0x2d43e['attributes']:_0x4d816d[_0xfda3('0x2e')];if(!_0x29bb55[_0xfda3('0x32')]['hasOwnProperty']('nolimit')){_0x2d43e[_0xfda3('0x1d')]=qs[_0xfda3('0x1d')](_0x29bb55[_0xfda3('0x32')]['limit']);_0x2d43e['offset']=qs[_0xfda3('0x1c')](_0x29bb55[_0xfda3('0x32')][_0xfda3('0x1c')]);}_0x2d43e['order']=qs[_0xfda3('0x35')](_0x29bb55[_0xfda3('0x32')][_0xfda3('0x35')]);_0x2d43e[_0xfda3('0x36')]=qs['filters'](_[_0xfda3('0x37')](_0x29bb55[_0xfda3('0x32')],_0x4d816d[_0xfda3('0x30')]),_0x420290);if(_0x29bb55[_0xfda3('0x32')][_0xfda3('0x38')]){_0x2d43e[_0xfda3('0x36')]=_[_0xfda3('0x39')](_0x2d43e[_0xfda3('0x36')],{'$or':_[_0xfda3('0x2a')](_0x420290,function(_0x32987e){if(_0x32987e[_0xfda3('0x3a')]!==_0xfda3('0x3b')){var _0xe5a90f={};_0xe5a90f[_0x32987e[_0xfda3('0x28')]]={'$like':'%'+_0x29bb55[_0xfda3('0x32')][_0xfda3('0x38')]+'%'};return _0xe5a90f;}})});}_0x2d43e=_['merge']({},_0x2d43e,_0x29bb55['options']);var _0x15a5ad={'where':_0x2d43e[_0xfda3('0x36')]};return db[_0xfda3('0x2b')]['count'](_0x15a5ad)[_0xfda3('0x22')](function(_0x533108){_0x46979b['count']=_0x533108;if(_0x29bb55[_0xfda3('0x32')][_0xfda3('0x3c')]){_0x2d43e[_0xfda3('0x3d')]=[{'all':!![]}];}return db[_0xfda3('0x2b')][_0xfda3('0x3e')](_0x2d43e);})[_0xfda3('0x22')](function(_0xb60722){_0x46979b[_0xfda3('0x3f')]=_0xb60722;return _0x46979b;})[_0xfda3('0x22')](respondWithFilteredResult(_0x18d2ff,_0x2d43e))[_0xfda3('0x40')](handleError(_0x18d2ff,null));};exports[_0xfda3('0x41')]=function(_0x5e7ebc,_0x4032e1){var _0x1cf601={'raw':!![],'where':{'id':_0x5e7ebc[_0xfda3('0x42')]['id']}},_0x14b158={};_0x14b158[_0xfda3('0x2e')]=_['keys'](db['AnalyticDefaultReport'][_0xfda3('0x2c')]);_0x14b158[_0xfda3('0x32')]=_[_0xfda3('0x2f')](_0x5e7ebc['query']);_0x14b158[_0xfda3('0x30')]=_[_0xfda3('0x31')](_0x14b158[_0xfda3('0x2e')],_0x14b158[_0xfda3('0x32')]);_0x1cf601['attributes']=_[_0xfda3('0x31')](_0x14b158[_0xfda3('0x2e')],qs[_0xfda3('0x34')](_0x5e7ebc[_0xfda3('0x32')]['fields']));_0x1cf601['attributes']=_0x1cf601[_0xfda3('0x33')][_0xfda3('0x43')]?_0x1cf601[_0xfda3('0x33')]:_0x14b158[_0xfda3('0x2e')];if(_0x5e7ebc[_0xfda3('0x32')][_0xfda3('0x3c')]){_0x1cf601[_0xfda3('0x3d')]=[{'all':!![]}];}_0x1cf601=_[_0xfda3('0x39')]({},_0x1cf601,_0x5e7ebc[_0xfda3('0x44')]);return db[_0xfda3('0x2b')][_0xfda3('0x45')](_0x1cf601)[_0xfda3('0x22')](handleEntityNotFound(_0x4032e1,null))[_0xfda3('0x22')](respondWithResult(_0x4032e1,null))['catch'](handleError(_0x4032e1,null));};exports[_0xfda3('0x46')]=function(_0x337798,_0x1f63f3){return db[_0xfda3('0x2b')][_0xfda3('0x46')](_0x337798['body'],{})['then'](function(_0x96778f){var _0x449356=_0x337798['user'][_0xfda3('0x24')]({'plain':!![]});if(!_0x449356)throw new Error(_0xfda3('0x47'));if(_0x449356['role']==='user'){var _0x5d41a5=_0x96778f[_0xfda3('0x24')]({'plain':!![]});var _0xe0ef8b=_0xfda3('0x48');return db[_0xfda3('0x49')][_0xfda3('0x45')]({'where':{'name':_0xe0ef8b,'userProfileId':_0x449356['userProfileId']},'raw':!![]})['then'](function(_0x23f98f){if(_0x23f98f&&_0x23f98f['autoAssociation']===0x0){return db[_0xfda3('0x26')][_0xfda3('0x46')]({'name':_0x5d41a5[_0xfda3('0x28')],'resourceId':_0x5d41a5['id'],'type':_0xfda3('0x25'),'sectionId':_0x23f98f['id']},{})[_0xfda3('0x22')](function(){return _0x96778f;});}else{return _0x96778f;}})[_0xfda3('0x40')](function(_0xe1d898){logger[_0xfda3('0x4a')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0xe1d898);throw _0xe1d898;});}return _0x96778f;})['then'](respondWithResult(_0x1f63f3,0xc9))[_0xfda3('0x40')](handleError(_0x1f63f3,null));};exports[_0xfda3('0x4b')]=function(_0x3ce790,_0x32fc65){if(_0x3ce790[_0xfda3('0x4c')]['id']){delete _0x3ce790[_0xfda3('0x4c')]['id'];}return db[_0xfda3('0x2b')][_0xfda3('0x45')]({'where':{'id':_0x3ce790[_0xfda3('0x42')]['id']}})['then'](handleEntityNotFound(_0x32fc65,null))[_0xfda3('0x22')](saveUpdates(_0x3ce790['body'],null))[_0xfda3('0x22')](respondWithResult(_0x32fc65,null))[_0xfda3('0x40')](handleError(_0x32fc65,null));};exports[_0xfda3('0x23')]=function(_0x5ee2ed,_0x495f7a){return db[_0xfda3('0x2b')][_0xfda3('0x45')]({'where':{'id':_0x5ee2ed[_0xfda3('0x42')]['id']}})[_0xfda3('0x22')](handleEntityNotFound(_0x495f7a,null))['then'](removeEntity(_0x495f7a,null))[_0xfda3('0x40')](handleError(_0x495f7a,null));};exports[_0xfda3('0x4d')]=function(_0x2eeb82,_0x3eeb0d){var _0x287554=0xa;var _0x1fb551=[_0xfda3('0x4e'),_0xfda3('0x4f'),_0xfda3('0x50'),_0xfda3('0x51')];var _0x366cde={'SUM':'SUM(%s)','COUNT':_0xfda3('0x52'),'COUNT DISTINCT':_0xfda3('0x53'),'MAX':_0xfda3('0x54'),'MIN':_0xfda3('0x55'),'AVG':'AVG(%s)','GROUP_CONCAT':_0xfda3('0x56'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x1781fe={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0xfda3('0x57'),'HOUR':_0xfda3('0x58'),'ROUND':_0xfda3('0x59'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x951663=function(_0x26e11a){return!_[_0xfda3('0x5a')]([_0xfda3('0x5b'),_0xfda3('0x5c'),_0xfda3('0x5d'),_0xfda3('0x5e')],_0x26e11a);};var _0x470c13=function(_0x22473a){if(!_0x22473a||!_0x22473a[_0xfda3('0x5f')][_0xfda3('0x43')]){return'';}for(var _0x1f0692='(',_0x49074e=0x0;_0x49074e<_0x22473a[_0xfda3('0x5f')][_0xfda3('0x43')];_0x49074e+=0x1){_0x49074e>0x0&&(_0x1f0692+='\x20'+_0x22473a[_0xfda3('0x60')]+'\x20');_0x1f0692+=_0x22473a['rules'][_0x49074e][_0xfda3('0x61')]?_0x470c13(_0x22473a[_0xfda3('0x5f')][_0x49074e][_0xfda3('0x61')]):_0x22473a['rules'][_0x49074e]['field']+'\x20'+_0x22473a[_0xfda3('0x5f')][_0x49074e]['condition']+(_0x951663(_0x22473a[_0xfda3('0x5f')][_0x49074e]['condition'])?'\x20'+_0x22473a['rules'][_0x49074e][_0xfda3('0x62')]:'');}return _0x1f0692+')';};var _0x4978fc={'where':{'id':_0x2eeb82['params']['id']}},_0x82b843,_0xae622,_0x3f9663,_0x383a29,_0xe0a2db;_0x4978fc=_[_0xfda3('0x39')]({},_0x4978fc,_0x2eeb82[_0xfda3('0x44')]);return db['AnalyticDefaultReport']['find'](_0x4978fc)['then'](function(_0xcf486a){if(_0xcf486a){_0x82b843=_0xcf486a;return _0xcf486a['getFields']();}return null;})[_0xfda3('0x22')](function(_0x2aeb8c){if(_0x2aeb8c){if(!_0x2aeb8c[_0xfda3('0x43')]){throw new db[(_0xfda3('0x63'))][(_0xfda3('0x64'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0xae622=_0x2aeb8c;return db[_0xfda3('0x65')]['findAll']({'raw':!![]});}return null;})[_0xfda3('0x22')](function(_0x450280){if(_0x450280){_0x3f9663=_[_0xfda3('0x66')](_0x450280,'id');var _0x5926a3;var _0x17059f=squel[_0xfda3('0x67')]();_0x17059f[_0xfda3('0x68')](_0x82b843['table']);for(var _0x45310b=0x0;_0x45310b<_0xae622[_0xfda3('0x43')];_0x45310b+=0x1){_0x5926a3=_0xae622[_0x45310b][_0xfda3('0x69')]?_0x3f9663[_0xae622[_0x45310b][_0xfda3('0x69')]][_0xfda3('0x6a')]:_0xae622[_0x45310b]['field'];_0x5926a3=_0xae622[_0x45310b][_0xfda3('0x6b')]?_[_0xfda3('0x6c')](_0x366cde[_0xae622[_0x45310b]['function']],'%s',_0x5926a3):_0x5926a3;_0x5926a3=_0xae622[_0x45310b][_0xfda3('0x6d')]?_['replace'](_0x1781fe[_0xae622[_0x45310b][_0xfda3('0x6d')]],'%s',_0x5926a3):_0x5926a3;if(_0xae622[_0x45310b]['groupBy']){_0x17059f[_0xfda3('0x61')](_0x5926a3);}_0xae622[_0x45310b][_0xfda3('0x6e')]&&_0x17059f[_0xfda3('0x6f')](_0x5926a3,_0xae622[_0x45310b][_0xfda3('0x6e')]==='DESC'?![]:!![]);_0x17059f[_0xfda3('0x70')](_0x5926a3,_0xae622[_0x45310b]['alias']||_0x5926a3);}if(_0x82b843[_0xfda3('0x71')]){_0x82b843['joins']=JSON[_0xfda3('0x72')](_0x82b843[_0xfda3('0x71')]);for(var _0x389c6b=0x0;_0x389c6b<_0x82b843[_0xfda3('0x71')][_0xfda3('0x43')];_0x389c6b+=0x1){if(_0x82b843[_0xfda3('0x71')][_0x389c6b][_0xfda3('0x3a')]&&_[_0xfda3('0x5a')](_0x1fb551,_0x82b843[_0xfda3('0x71')][_0x389c6b]['type'])&&_0x82b843[_0xfda3('0x71')][_0x389c6b]['parentKey']&&_0x82b843['joins'][_0x389c6b]['foreignTable']&&_0x82b843[_0xfda3('0x71')][_0x389c6b][_0xfda3('0x73')]){_0x17059f[_0x82b843['joins'][_0x389c6b]['type']](_0x82b843[_0xfda3('0x71')][_0x389c6b][_0xfda3('0x74')],null,util[_0xfda3('0x6d')]('%s.%s\x20=\x20%s.%s',_0x82b843[_0xfda3('0x75')],_0x82b843[_0xfda3('0x71')][_0x389c6b]['parentKey'],_0x82b843[_0xfda3('0x71')][_0x389c6b][_0xfda3('0x74')],_0x82b843['joins'][_0x389c6b][_0xfda3('0x73')]));}}}if(_0x82b843[_0xfda3('0x76')]){_0x82b843[_0xfda3('0x76')]=JSON['parse'](_0x82b843[_0xfda3('0x76')]);_0x17059f[_0xfda3('0x36')](_0x470c13(_0x82b843[_0xfda3('0x76')][_0xfda3('0x61')]));}_0xe0a2db=_0x17059f['clone']();_0x17059f[_0xfda3('0x1d')](_0x287554);_0x17059f[_0xfda3('0x1c')](0x0);logger[_0xfda3('0x77')](_0xfda3('0x78'),_0x17059f[_0xfda3('0x79')]());return db[_0xfda3('0x7a')]['query'](_0x17059f[_0xfda3('0x79')](),{'type':db[_0xfda3('0x7a')]['QueryTypes']['SELECT']});}})[_0xfda3('0x22')](respondWithResult(_0x3eeb0d,null))[_0xfda3('0x40')](handleError(_0x3eeb0d,null));};function runReport(_0x289518,_0x51183d,_0xb8fb33){var _0x5115c4=_0x51183d['name'];var _0x339470=0xa;var _0x134921=['join','left_join','right_join',_0xfda3('0x51')];var _0xf02286={'SUM':'SUM(%s)','COUNT':_0xfda3('0x52'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0xfda3('0x54'),'MIN':_0xfda3('0x55'),'AVG':'AVG(%s)','GROUP_CONCAT':_0xfda3('0x56'),'GROUP_CONCAT ASC':_0xfda3('0x7b'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x16fb21={'SEC_TO_TIME':_0xfda3('0x7c'),'DATE':_0xfda3('0x57'),'HOUR':_0xfda3('0x58'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0xfda3('0x7d')};var _0x3bf17f=function(_0x4bb275){return!_['includes'](['IS\x20NULL',_0xfda3('0x5c'),_0xfda3('0x5d'),_0xfda3('0x5e')],_0x4bb275);};var _0xe69bce=function(_0x15536a){if(!_0x15536a||!_0x15536a['rules'][_0xfda3('0x43')]){return'';}for(var _0x12233d='(',_0x26f933=0x0;_0x26f933<_0x15536a['rules']['length'];_0x26f933+=0x1){_0x26f933>0x0&&(_0x12233d+='\x20'+_0x15536a[_0xfda3('0x60')]+'\x20');_0x12233d+=_0x15536a[_0xfda3('0x5f')][_0x26f933][_0xfda3('0x61')]?_0xe69bce(_0x15536a[_0xfda3('0x5f')][_0x26f933][_0xfda3('0x61')]):_0x15536a[_0xfda3('0x5f')][_0x26f933][_0xfda3('0x70')]+'\x20'+_0x15536a['rules'][_0x26f933][_0xfda3('0x7e')]+(_0x3bf17f(_0x15536a[_0xfda3('0x5f')][_0x26f933][_0xfda3('0x7e')])?'\x20'+_0x15536a[_0xfda3('0x5f')][_0x26f933]['value']:'');}return _0x12233d+')';};var _0xf0bd63={'where':{'id':_0x289518['id']}},_0x5d3098,_0x4e3b26,_0x525826,_0x19009a,_0x45cf4e;_0xf0bd63=_['merge']({},_0xf0bd63,_0xb8fb33);return db[_0xfda3('0x2b')][_0xfda3('0x45')](_0xf0bd63)[_0xfda3('0x22')](function(_0x27693a){if(_0x27693a){_0x5d3098=_0x27693a;return _0x27693a[_0xfda3('0x7f')]();}return null;})[_0xfda3('0x22')](function(_0x155ec6){if(_0x155ec6){if(!_0x155ec6[_0xfda3('0x43')]){throw new db[(_0xfda3('0x63'))][(_0xfda3('0x64'))](_0xfda3('0x80'),0x193);}_0x4e3b26=_0x155ec6;return db[_0xfda3('0x65')][_0xfda3('0x3e')]({'raw':!![]});}return null;})['then'](function(_0x2e1e41){if(_0x2e1e41){_0x525826=_[_0xfda3('0x66')](_0x2e1e41,'id');var _0x5a7ede;var _0x1c1e3d=squel['select']();_0x1c1e3d[_0xfda3('0x68')](_0x5d3098[_0xfda3('0x75')]);for(var _0x4d204f=0x0;_0x4d204f<_0x4e3b26['length'];_0x4d204f+=0x1){_0x5a7ede=_0x4e3b26[_0x4d204f][_0xfda3('0x69')]?_0x525826[_0x4e3b26[_0x4d204f][_0xfda3('0x69')]]['metric']:_0x4e3b26[_0x4d204f][_0xfda3('0x70')];_0x5a7ede=_0x4e3b26[_0x4d204f]['function']?_['replace'](_0xf02286[_0x4e3b26[_0x4d204f][_0xfda3('0x6b')]],'%s',_0x5a7ede):_0x5a7ede;_0x5a7ede=_0x4e3b26[_0x4d204f]['format']?_[_0xfda3('0x6c')](_0x16fb21[_0x4e3b26[_0x4d204f]['format']],'%s',_0x5a7ede):_0x5a7ede;if(_0x4e3b26[_0x4d204f][_0xfda3('0x81')]){_0x1c1e3d[_0xfda3('0x61')](_0x5a7ede);}_0x4e3b26[_0x4d204f]['orderBy']&&_0x1c1e3d[_0xfda3('0x6f')](_0x5a7ede,_0x4e3b26[_0x4d204f][_0xfda3('0x6e')]==='DESC'?![]:!![]);_0x1c1e3d[_0xfda3('0x70')](_0x5a7ede,_0x4e3b26[_0x4d204f][_0xfda3('0x82')]||_0x5a7ede);}if(_0x5d3098['joins']){_0x5d3098['joins']=JSON['parse'](_0x5d3098['joins']);for(var _0x26b1f7=0x0;_0x26b1f7<_0x5d3098[_0xfda3('0x71')][_0xfda3('0x43')];_0x26b1f7+=0x1){if(_0x5d3098[_0xfda3('0x71')][_0x26b1f7]['type']&&_[_0xfda3('0x5a')](_0x134921,_0x5d3098['joins'][_0x26b1f7][_0xfda3('0x3a')])&&_0x5d3098['joins'][_0x26b1f7][_0xfda3('0x83')]&&_0x5d3098['joins'][_0x26b1f7][_0xfda3('0x74')]&&_0x5d3098[_0xfda3('0x71')][_0x26b1f7][_0xfda3('0x73')]){_0x1c1e3d[_0x5d3098['joins'][_0x26b1f7][_0xfda3('0x3a')]](_0x5d3098['joins'][_0x26b1f7][_0xfda3('0x74')],null,util['format'](_0xfda3('0x84'),_0x5d3098[_0xfda3('0x75')],_0x5d3098['joins'][_0x26b1f7][_0xfda3('0x83')],_0x5d3098[_0xfda3('0x71')][_0x26b1f7][_0xfda3('0x74')],_0x5d3098[_0xfda3('0x71')][_0x26b1f7][_0xfda3('0x73')]));}}}if(_0x5d3098[_0xfda3('0x76')]){_0x5d3098[_0xfda3('0x76')]=JSON[_0xfda3('0x72')](_0x5d3098[_0xfda3('0x76')]);_0x1c1e3d[_0xfda3('0x36')](_0xe69bce(_0x5d3098['conditions'][_0xfda3('0x61')]));}_0x45cf4e=_0x1c1e3d[_0xfda3('0x85')]();_0x1c1e3d[_0xfda3('0x1d')](_0x339470);_0x1c1e3d[_0xfda3('0x1c')](0x0);logger['debug'](_0xfda3('0x78'),_0x1c1e3d['toString']());return db[_0xfda3('0x7a')][_0xfda3('0x32')](_0x1c1e3d['toString'](),{'type':db[_0xfda3('0x7a')][_0xfda3('0x86')][_0xfda3('0x87')]});}})[_0xfda3('0x22')](function(_0x31b8bb){if(!_0x31b8bb[_0xfda3('0x43')]){throw new db[(_0xfda3('0x63'))][(_0xfda3('0x64'))](_0xfda3('0x88'),0xcc);}if(_0x51183d['output']===_0xfda3('0x89')){return null;}var _0x42a9e4=_[_0xfda3('0x39')](_0x51183d,{'name':_0x51183d[_0xfda3('0x8a')]||_0x51183d[_0xfda3('0x28')]||_0x5d3098[_0xfda3('0x28')],'basename':_0x5115c4,'savename':util[_0xfda3('0x6d')]('%s-%s.%s',_0x51183d[_0xfda3('0x28')]||_0x5d3098['name'],require(_0xfda3('0x8b'))[_0xfda3('0x8c')](0x4),_0x51183d['output']||_0xfda3('0x8d')),'reportId':_0x5d3098['id'],'reportType':_0xfda3('0x8e')});return db[_0xfda3('0x8f')][_0xfda3('0x46')](_0x42a9e4,{'raw':!![]});})['then'](function(_0x9c1fdc){if(_0x5d3098[_0xfda3('0x75')]===_0xfda3('0x90')){_0x45cf4e[_0xfda3('0x36')](_0x5d3098[_0xfda3('0x75')]+_0xfda3('0x91'),_0x51183d[_0xfda3('0x92')],_0x51183d[_0xfda3('0x93')]);}else{_0x45cf4e[_0xfda3('0x36')](_0x5d3098['table']+_0xfda3('0x94'),_0x51183d['startDate'],_0x51183d[_0xfda3('0x93')]);}if(_0x9c1fdc){logger['info'](_0xfda3('0x95'),_0x45cf4e['toString']());require('child_process')[_0xfda3('0x96')](path[_0xfda3('0x4e')](__dirname,'../../components/export/',_0x9c1fdc[_0xfda3('0x97')]),[_0x9c1fdc['id'],_0x45cf4e[_0xfda3('0x79')](),path[_0xfda3('0x4e')](__dirname,'../../files/reports',_0x9c1fdc[_0xfda3('0x98')]),_0x5115c4]);return _0x9c1fdc;}else{var _0x45c418=squel[_0xfda3('0x67')]();_0x45c418[_0xfda3('0x68')]('('+_0x45cf4e['toString']()+')',_0xfda3('0x99'));_0x45c418[_0xfda3('0x70')](_0xfda3('0x9a'),_0xfda3('0x9b'));_0x45cf4e[_0xfda3('0x1d')](_0x51183d[_0xfda3('0x1d')]||_0x339470);_0x45cf4e[_0xfda3('0x1c')](_0x51183d[_0xfda3('0x1c')]||0x0);return dbH[_0xfda3('0x7a')]['query'](_0x45c418[_0xfda3('0x79')](),{'type':dbH[_0xfda3('0x7a')][_0xfda3('0x86')]['SELECT']})['then'](function(_0x20c354){if(!_0x20c354[_0xfda3('0x43')]){_0x19009a=0x0;}else{_0x19009a=_0x20c354[0x0][_0xfda3('0x9b')]||0x0;}return dbH[_0xfda3('0x7a')][_0xfda3('0x32')](_0x45cf4e[_0xfda3('0x79')](),{'type':dbH[_0xfda3('0x7a')][_0xfda3('0x86')][_0xfda3('0x87')]});})['then'](function(_0x43c3b1){return{'rows':_0x43c3b1||[],'count':_0x19009a};});}});}exports[_0xfda3('0x9c')]=function(_0x160bfd,_0x5942bc){return runReport(_0x160bfd[_0xfda3('0x42')],_0x160bfd[_0xfda3('0x32')],_0x160bfd[_0xfda3('0x44')])[_0xfda3('0x22')](respondWithResult(_0x5942bc,null))[_0xfda3('0x40')](handleError(_0x5942bc,null));};exports[_0xfda3('0x9d')]=runReport;exports[_0xfda3('0x32')]=function(_0xac76e6,_0x370fe9){var _0x4eb28c=0xa;var _0x5b39df=[_0xfda3('0x4e'),'left_join',_0xfda3('0x50'),_0xfda3('0x51')];var _0x4e2174={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT DISTINCT':_0xfda3('0x53'),'MAX':_0xfda3('0x54'),'MIN':'MIN(%s)','AVG':_0xfda3('0x9e'),'GROUP_CONCAT':_0xfda3('0x56'),'GROUP_CONCAT ASC':_0xfda3('0x7b'),'GROUP_CONCAT DESC':_0xfda3('0x9f')};var _0x225337={'SEC_TO_TIME':_0xfda3('0x7c'),'DATE':'DATE(%s)','HOUR':_0xfda3('0x58'),'ROUND':_0xfda3('0x59'),'UNIX_TIMESTAMP':_0xfda3('0x7d')};var _0x108bd5=function(_0x436b51){return!_['includes']([_0xfda3('0x5b'),_0xfda3('0x5c'),_0xfda3('0x5d'),_0xfda3('0x5e')],_0x436b51);};var _0x1a2d7c=function(_0x5a75d0){if(!_0x5a75d0||!_0x5a75d0[_0xfda3('0x5f')][_0xfda3('0x43')]){return'';}for(var _0x4b5825='(',_0x500d5f=0x0;_0x500d5f<_0x5a75d0[_0xfda3('0x5f')][_0xfda3('0x43')];_0x500d5f+=0x1){_0x500d5f>0x0&&(_0x4b5825+='\x20'+_0x5a75d0[_0xfda3('0x60')]+'\x20');_0x4b5825+=_0x5a75d0[_0xfda3('0x5f')][_0x500d5f][_0xfda3('0x61')]?_0x1a2d7c(_0x5a75d0[_0xfda3('0x5f')][_0x500d5f][_0xfda3('0x61')]):_0x5a75d0[_0xfda3('0x5f')][_0x500d5f][_0xfda3('0x70')]+'\x20'+_0x5a75d0[_0xfda3('0x5f')][_0x500d5f]['condition']+(_0x108bd5(_0x5a75d0['rules'][_0x500d5f]['condition'])?'\x20'+_0x5a75d0['rules'][_0x500d5f]['value']:'');}return _0x4b5825+')';};var _0x9f6049={'where':{'id':_0xac76e6[_0xfda3('0x42')]['id']}},_0x28d9dc,_0x3480e5,_0x519ae,_0x3c0a6c,_0x16ca54;_0x9f6049=_['merge']({},_0x9f6049,_0xac76e6['options']);return db[_0xfda3('0x2b')][_0xfda3('0x45')](_0x9f6049)['then'](function(_0x5e0b5a){if(_0x5e0b5a){_0x28d9dc=_0x5e0b5a;return _0x5e0b5a['getFields']();}return null;})[_0xfda3('0x22')](function(_0x6595c7){if(_0x6595c7){if(!_0x6595c7[_0xfda3('0x43')]){throw new db['Sequelize'][(_0xfda3('0x64'))](_0xfda3('0x80'),0x193);}_0x3480e5=_0x6595c7;return db[_0xfda3('0x65')][_0xfda3('0x3e')]({'raw':!![]});}return null;})[_0xfda3('0x22')](function(_0x1daa9c){if(_0x1daa9c){_0x519ae=_['keyBy'](_0x1daa9c,'id');var _0x566755;var _0xd24c0e=squel[_0xfda3('0x67')]();_0xd24c0e['from'](_0x28d9dc['table']);for(var _0x4394cf=0x0;_0x4394cf<_0x3480e5[_0xfda3('0x43')];_0x4394cf+=0x1){_0x566755=_0x3480e5[_0x4394cf][_0xfda3('0x69')]?_0x519ae[_0x3480e5[_0x4394cf][_0xfda3('0x69')]][_0xfda3('0x6a')]:_0x3480e5[_0x4394cf][_0xfda3('0x70')];_0x566755=_0x3480e5[_0x4394cf][_0xfda3('0x6b')]?_['replace'](_0x4e2174[_0x3480e5[_0x4394cf]['function']],'%s',_0x566755):_0x566755;_0x566755=_0x3480e5[_0x4394cf][_0xfda3('0x6d')]?_[_0xfda3('0x6c')](_0x225337[_0x3480e5[_0x4394cf]['format']],'%s',_0x566755):_0x566755;if(_0x3480e5[_0x4394cf]['groupBy']){_0xd24c0e[_0xfda3('0x61')](_0x566755);}_0x3480e5[_0x4394cf]['orderBy']&&_0xd24c0e[_0xfda3('0x6f')](_0x566755,_0x3480e5[_0x4394cf][_0xfda3('0x6e')]==='DESC'?![]:!![]);_0xd24c0e[_0xfda3('0x70')](_0x566755,_0x3480e5[_0x4394cf]['alias']||_0x566755);}if(_0x28d9dc[_0xfda3('0x71')]){_0x28d9dc[_0xfda3('0x71')]=JSON[_0xfda3('0x72')](_0x28d9dc[_0xfda3('0x71')]);for(var _0x18d3c4=0x0;_0x18d3c4<_0x28d9dc[_0xfda3('0x71')]['length'];_0x18d3c4+=0x1){if(_0x28d9dc[_0xfda3('0x71')][_0x18d3c4]['type']&&_[_0xfda3('0x5a')](_0x5b39df,_0x28d9dc[_0xfda3('0x71')][_0x18d3c4]['type'])&&_0x28d9dc[_0xfda3('0x71')][_0x18d3c4][_0xfda3('0x83')]&&_0x28d9dc[_0xfda3('0x71')][_0x18d3c4][_0xfda3('0x74')]&&_0x28d9dc['joins'][_0x18d3c4][_0xfda3('0x73')]){_0xd24c0e[_0x28d9dc['joins'][_0x18d3c4][_0xfda3('0x3a')]](_0x28d9dc[_0xfda3('0x71')][_0x18d3c4][_0xfda3('0x74')],null,util[_0xfda3('0x6d')](_0xfda3('0x84'),_0x28d9dc[_0xfda3('0x75')],_0x28d9dc['joins'][_0x18d3c4][_0xfda3('0x83')],_0x28d9dc[_0xfda3('0x71')][_0x18d3c4][_0xfda3('0x74')],_0x28d9dc[_0xfda3('0x71')][_0x18d3c4][_0xfda3('0x73')]));}}}if(_0x28d9dc[_0xfda3('0x76')]){_0x28d9dc[_0xfda3('0x76')]=JSON[_0xfda3('0x72')](_0x28d9dc[_0xfda3('0x76')]);_0xd24c0e[_0xfda3('0x36')](_0x1a2d7c(_0x28d9dc['conditions'][_0xfda3('0x61')]));}_0x16ca54=_0xd24c0e[_0xfda3('0x85')]();_0xd24c0e['limit'](_0x4eb28c);_0xd24c0e[_0xfda3('0x1c')](0x0);logger[_0xfda3('0x77')](_0xfda3('0x78'),_0xd24c0e[_0xfda3('0x79')]());return db[_0xfda3('0x7a')][_0xfda3('0x32')](_0xd24c0e[_0xfda3('0x79')](),{'type':db['sequelize'][_0xfda3('0x86')][_0xfda3('0x87')]});}})[_0xfda3('0x22')](function(){return{'sql':_0x16ca54['toString']()};})['then'](respondWithResult(_0x370fe9,null))[_0xfda3('0x40')](handleError(_0x370fe9,null));};
\ No newline at end of file
+var _0x80a7=['request-promise','moment','mustache','util','path','sox','ejs','squel','crypto','jsforce','to-csv','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','status','end','count','offset','limit','set','Content-Range','json','apply','save','update','then','destroy','get','DefaultReports','UserProfileResource','error','stack','name','index','map','AnalyticDefaultReport','rawAttributes','fieldName','type','key','model','query','filters','intersection','attributes','length','hasOwnProperty','order','sort','where','pick','filter','merge','VIRTUAL','includeAll','include','findAll','rows','catch','show','params','keys','fields','options','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','preview','join','right_join','cross_join','COUNT(%s)','COUNT(DISTINCT\x20%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\x20NULL','IS\x20NOT\x20NULL','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','value','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','select','from','table','MetricId','function','replace','format','groupBy','orderBy','DESC','joins','parse','includes','foreignTable','%s.%s\x20=\x20%s.%s','parentKey','foreignKey','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','left_join','SUM(%s)','MAX(%s)','alias','No\x20available\x20data','output','web','fullPath','%s-%s.%s','generate','csv','AnalyticExtractedReport','.calldate\x20BETWEEN\x20?\x20AND\x20?','endDate','info','fork','../../components/export/','savename','IS\x20EMPTY','metric','rimraf'];(function(_0x1e888f,_0x45b38c){var _0x289447=function(_0x57993f){while(--_0x57993f){_0x1e888f['push'](_0x1e888f['shift']());}};_0x289447(++_0x45b38c);}(_0x80a7,0x13f));var _0x780a=function(_0x1f8053,_0x111077){_0x1f8053=_0x1f8053-0x0;var _0x174fd8=_0x80a7[_0x1f8053];return _0x174fd8;};'use strict';var pdf=require('html-pdf');var emlformat=require('eml-format');var rimraf=require(_0x780a('0x0'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0x780a('0x1'));var moment=require(_0x780a('0x2'));var BPromise=require('bluebird');var Mustache=require(_0x780a('0x3'));var util=require(_0x780a('0x4'));var path=require(_0x780a('0x5'));var sox=require(_0x780a('0x6'));var csv=require('to-csv');var ejs=require(_0x780a('0x7'));var fs=require('fs');var _=require('lodash');var squel=require(_0x780a('0x8'));var crypto=require(_0x780a('0x9'));var jsforce=require(_0x780a('0xa'));var deskjs=require('desk.js');var toCsv=require(_0x780a('0xb'));var querystring=require(_0x780a('0xc'));var Papa=require(_0x780a('0xd'));var Redis=require(_0x780a('0xe'));var authService=require('../../components/auth/service');var qs=require(_0x780a('0xf'));var as=require(_0x780a('0x10'));var hardwareService=require(_0x780a('0x11'));var logger=require(_0x780a('0x12'))(_0x780a('0x13'));var utils=require(_0x780a('0x14'));var config=require(_0x780a('0x15'));var db=require(_0x780a('0x16'))['db'];var dbH=require(_0x780a('0x16'))['dbH'];function respondWithStatusCode(_0x315f6c,_0x3a4867){_0x3a4867=_0x3a4867||0xcc;return function(_0x2ad587){if(_0x2ad587){return _0x315f6c['sendStatus'](_0x3a4867);}return _0x315f6c[_0x780a('0x17')](_0x3a4867)[_0x780a('0x18')]();};}function respondWithResult(_0x24d136,_0x48dc4a){_0x48dc4a=_0x48dc4a||0xc8;return function(_0x4a7691){if(_0x4a7691){return _0x24d136[_0x780a('0x17')](_0x48dc4a)['json'](_0x4a7691);}};}function respondWithFilteredResult(_0x3bea86,_0x3275e1){return function(_0x1f4930){if(_0x1f4930){var _0x3c5db8=_0x1f4930[_0x780a('0x19')],_0x4bf222=_0x3275e1[_0x780a('0x1a')],_0x45dd4b=_0x3275e1[_0x780a('0x1a')]+_0x3275e1[_0x780a('0x1b')],_0x13dea6;if(_0x45dd4b>=_0x3c5db8){_0x45dd4b=_0x3c5db8;_0x13dea6=0xc8;}else{_0x13dea6=0xce;}_0x3bea86[_0x780a('0x17')](_0x13dea6);return _0x3bea86[_0x780a('0x1c')](_0x780a('0x1d'),_0x4bf222+'-'+_0x45dd4b+'/'+_0x3c5db8)[_0x780a('0x1e')](_0x1f4930);}return null;};}function patchUpdates(_0x127683){return function(_0x216644){try{jsonpatch[_0x780a('0x1f')](_0x216644,_0x127683,!![]);}catch(_0x17a60f){return BPromise['reject'](_0x17a60f);}return _0x216644[_0x780a('0x20')]();};}function saveUpdates(_0x50cbec,_0x3f724f){return function(_0x2a1b42){if(_0x2a1b42){return _0x2a1b42[_0x780a('0x21')](_0x50cbec)[_0x780a('0x22')](function(_0x541f02){return _0x541f02;});}return null;};}function removeEntity(_0x6ed595,_0x3f8257){return function(_0x59c8a2){if(_0x59c8a2){return _0x59c8a2[_0x780a('0x23')]()['then'](function(){var _0x9b58c7=_0x59c8a2[_0x780a('0x24')]({'plain':!![]});var _0x1db958=_0x780a('0x25');return db[_0x780a('0x26')]['destroy']({'where':{'type':_0x1db958,'resourceId':_0x9b58c7['id']}})[_0x780a('0x22')](function(){return _0x59c8a2;});})[_0x780a('0x22')](function(){_0x6ed595[_0x780a('0x17')](0xcc)[_0x780a('0x18')]();});}};}function handleEntityNotFound(_0x272947,_0x42ca53){return function(_0xa178aa){if(!_0xa178aa){_0x272947['sendStatus'](0x194);}return _0xa178aa;};}function handleError(_0x2c6a48,_0x199e06){_0x199e06=_0x199e06||0x1f4;return function(_0x4fb118){logger[_0x780a('0x27')](_0x4fb118[_0x780a('0x28')]);if(_0x4fb118[_0x780a('0x29')]){delete _0x4fb118[_0x780a('0x29')];}_0x2c6a48[_0x780a('0x17')](_0x199e06)['send'](_0x4fb118);};}exports[_0x780a('0x2a')]=function(_0x322832,_0x1d4d9c){var _0x6251e0={},_0x1c21d1={},_0x23af03={'count':0x0,'rows':[]};var _0x2e690d=_[_0x780a('0x2b')](db[_0x780a('0x2c')][_0x780a('0x2d')],function(_0x507094){return{'name':_0x507094[_0x780a('0x2e')],'type':_0x507094[_0x780a('0x2f')][_0x780a('0x30')]};});_0x1c21d1[_0x780a('0x31')]=_[_0x780a('0x2b')](_0x2e690d,_0x780a('0x29'));_0x1c21d1[_0x780a('0x32')]=_['keys'](_0x322832[_0x780a('0x32')]);_0x1c21d1[_0x780a('0x33')]=_['intersection'](_0x1c21d1[_0x780a('0x31')],_0x1c21d1[_0x780a('0x32')]);_0x6251e0['attributes']=_[_0x780a('0x34')](_0x1c21d1['model'],qs['fields'](_0x322832[_0x780a('0x32')]['fields']));_0x6251e0[_0x780a('0x35')]=_0x6251e0[_0x780a('0x35')][_0x780a('0x36')]?_0x6251e0[_0x780a('0x35')]:_0x1c21d1[_0x780a('0x31')];if(!_0x322832[_0x780a('0x32')][_0x780a('0x37')]('nolimit')){_0x6251e0[_0x780a('0x1b')]=qs['limit'](_0x322832['query']['limit']);_0x6251e0[_0x780a('0x1a')]=qs[_0x780a('0x1a')](_0x322832[_0x780a('0x32')][_0x780a('0x1a')]);}_0x6251e0[_0x780a('0x38')]=qs[_0x780a('0x39')](_0x322832['query']['sort']);_0x6251e0[_0x780a('0x3a')]=qs[_0x780a('0x33')](_[_0x780a('0x3b')](_0x322832[_0x780a('0x32')],_0x1c21d1[_0x780a('0x33')]),_0x2e690d);if(_0x322832[_0x780a('0x32')][_0x780a('0x3c')]){_0x6251e0[_0x780a('0x3a')]=_[_0x780a('0x3d')](_0x6251e0['where'],{'$or':_[_0x780a('0x2b')](_0x2e690d,function(_0x3c7622){if(_0x3c7622[_0x780a('0x2f')]!==_0x780a('0x3e')){var _0x2c74b5={};_0x2c74b5[_0x3c7622[_0x780a('0x29')]]={'$like':'%'+_0x322832[_0x780a('0x32')][_0x780a('0x3c')]+'%'};return _0x2c74b5;}})});}_0x6251e0=_[_0x780a('0x3d')]({},_0x6251e0,_0x322832['options']);var _0x429eb2={'where':_0x6251e0[_0x780a('0x3a')]};return db[_0x780a('0x2c')][_0x780a('0x19')](_0x429eb2)[_0x780a('0x22')](function(_0x4e53af){_0x23af03['count']=_0x4e53af;if(_0x322832['query'][_0x780a('0x3f')]){_0x6251e0[_0x780a('0x40')]=[{'all':!![]}];}return db[_0x780a('0x2c')][_0x780a('0x41')](_0x6251e0);})[_0x780a('0x22')](function(_0x2fdb0e){_0x23af03[_0x780a('0x42')]=_0x2fdb0e;return _0x23af03;})[_0x780a('0x22')](respondWithFilteredResult(_0x1d4d9c,_0x6251e0))[_0x780a('0x43')](handleError(_0x1d4d9c,null));};exports[_0x780a('0x44')]=function(_0x5ac5b8,_0x12b4cd){var _0x5d023d={'raw':!![],'where':{'id':_0x5ac5b8[_0x780a('0x45')]['id']}},_0x4dfbe3={};_0x4dfbe3[_0x780a('0x31')]=_[_0x780a('0x46')](db[_0x780a('0x2c')][_0x780a('0x2d')]);_0x4dfbe3[_0x780a('0x32')]=_[_0x780a('0x46')](_0x5ac5b8[_0x780a('0x32')]);_0x4dfbe3[_0x780a('0x33')]=_[_0x780a('0x34')](_0x4dfbe3[_0x780a('0x31')],_0x4dfbe3[_0x780a('0x32')]);_0x5d023d[_0x780a('0x35')]=_[_0x780a('0x34')](_0x4dfbe3[_0x780a('0x31')],qs[_0x780a('0x47')](_0x5ac5b8['query'][_0x780a('0x47')]));_0x5d023d[_0x780a('0x35')]=_0x5d023d[_0x780a('0x35')][_0x780a('0x36')]?_0x5d023d['attributes']:_0x4dfbe3[_0x780a('0x31')];if(_0x5ac5b8[_0x780a('0x32')]['includeAll']){_0x5d023d[_0x780a('0x40')]=[{'all':!![]}];}_0x5d023d=_[_0x780a('0x3d')]({},_0x5d023d,_0x5ac5b8[_0x780a('0x48')]);return db[_0x780a('0x2c')][_0x780a('0x49')](_0x5d023d)[_0x780a('0x22')](handleEntityNotFound(_0x12b4cd,null))[_0x780a('0x22')](respondWithResult(_0x12b4cd,null))[_0x780a('0x43')](handleError(_0x12b4cd,null));};exports[_0x780a('0x4a')]=function(_0x59d8bd,_0x48fcb6){return db['AnalyticDefaultReport'][_0x780a('0x4a')](_0x59d8bd['body'],{})[_0x780a('0x22')](function(_0x43ada1){var _0x3ca694=_0x59d8bd[_0x780a('0x4b')][_0x780a('0x24')]({'plain':!![]});if(!_0x3ca694)throw new Error(_0x780a('0x4c'));if(_0x3ca694[_0x780a('0x4d')]===_0x780a('0x4b')){var _0x15e714=_0x43ada1[_0x780a('0x24')]({'plain':!![]});var _0x376089=_0x780a('0x4e');return db[_0x780a('0x4f')][_0x780a('0x49')]({'where':{'name':_0x376089,'userProfileId':_0x3ca694[_0x780a('0x50')]},'raw':!![]})[_0x780a('0x22')](function(_0x33650c){if(_0x33650c&&_0x33650c[_0x780a('0x51')]===0x0){return db['UserProfileResource'][_0x780a('0x4a')]({'name':_0x15e714[_0x780a('0x29')],'resourceId':_0x15e714['id'],'type':_0x780a('0x25'),'sectionId':_0x33650c['id']},{})[_0x780a('0x22')](function(){return _0x43ada1;});}else{return _0x43ada1;}})[_0x780a('0x43')](function(_0x32c359){logger[_0x780a('0x27')](_0x780a('0x52'),_0x32c359);throw _0x32c359;});}return _0x43ada1;})[_0x780a('0x22')](respondWithResult(_0x48fcb6,0xc9))['catch'](handleError(_0x48fcb6,null));};exports[_0x780a('0x21')]=function(_0x4129f0,_0x33d7ec){if(_0x4129f0[_0x780a('0x53')]['id']){delete _0x4129f0[_0x780a('0x53')]['id'];}return db['AnalyticDefaultReport'][_0x780a('0x49')]({'where':{'id':_0x4129f0[_0x780a('0x45')]['id']}})['then'](handleEntityNotFound(_0x33d7ec,null))[_0x780a('0x22')](saveUpdates(_0x4129f0['body'],null))[_0x780a('0x22')](respondWithResult(_0x33d7ec,null))['catch'](handleError(_0x33d7ec,null));};exports[_0x780a('0x23')]=function(_0x585684,_0x448623){return db[_0x780a('0x2c')][_0x780a('0x49')]({'where':{'id':_0x585684[_0x780a('0x45')]['id']}})[_0x780a('0x22')](handleEntityNotFound(_0x448623,null))[_0x780a('0x22')](removeEntity(_0x448623,null))['catch'](handleError(_0x448623,null));};exports[_0x780a('0x54')]=function(_0x221d79,_0x29d58c){var _0x47ec7a=0xa;var _0x263d53=[_0x780a('0x55'),'left_join',_0x780a('0x56'),_0x780a('0x57')];var _0x5be96a={'SUM':'SUM(%s)','COUNT':_0x780a('0x58'),'COUNT DISTINCT':_0x780a('0x59'),'MAX':'MAX(%s)','MIN':_0x780a('0x5a'),'AVG':_0x780a('0x5b'),'GROUP_CONCAT':_0x780a('0x5c'),'GROUP_CONCAT ASC':_0x780a('0x5d'),'GROUP_CONCAT DESC':_0x780a('0x5e')};var _0x2257af={'SEC_TO_TIME':_0x780a('0x5f'),'DATE':_0x780a('0x60'),'HOUR':_0x780a('0x61'),'ROUND':_0x780a('0x62'),'UNIX_TIMESTAMP':_0x780a('0x63')};var _0x51ec51=function(_0x4d6220){return!_['includes']([_0x780a('0x64'),_0x780a('0x65'),'IS\x20EMPTY',_0x780a('0x66')],_0x4d6220);};var _0x16f549=function(_0x4f2472){if(!_0x4f2472||!_0x4f2472[_0x780a('0x67')][_0x780a('0x36')]){return'';}for(var _0x108f63='(',_0x2a2d3e=0x0;_0x2a2d3e<_0x4f2472[_0x780a('0x67')][_0x780a('0x36')];_0x2a2d3e+=0x1){_0x2a2d3e>0x0&&(_0x108f63+='\x20'+_0x4f2472[_0x780a('0x68')]+'\x20');_0x108f63+=_0x4f2472[_0x780a('0x67')][_0x2a2d3e][_0x780a('0x69')]?_0x16f549(_0x4f2472[_0x780a('0x67')][_0x2a2d3e][_0x780a('0x69')]):_0x4f2472[_0x780a('0x67')][_0x2a2d3e][_0x780a('0x6a')]+'\x20'+_0x4f2472[_0x780a('0x67')][_0x2a2d3e]['condition']+(_0x51ec51(_0x4f2472['rules'][_0x2a2d3e][_0x780a('0x6b')])?'\x20'+_0x4f2472[_0x780a('0x67')][_0x2a2d3e][_0x780a('0x6c')]:'');}return _0x108f63+')';};var _0x2aedf4={'where':{'id':_0x221d79[_0x780a('0x45')]['id']}},_0x40ad99,_0x47f6dd,_0xb9f53d,_0x45b35d,_0x4ccffc;_0x2aedf4=_[_0x780a('0x3d')]({},_0x2aedf4,_0x221d79['options']);return db['AnalyticDefaultReport'][_0x780a('0x49')](_0x2aedf4)[_0x780a('0x22')](function(_0x10971b){if(_0x10971b){_0x40ad99=_0x10971b;return _0x10971b[_0x780a('0x6d')]();}return null;})[_0x780a('0x22')](function(_0x906aa8){if(_0x906aa8){if(!_0x906aa8['length']){throw new db[(_0x780a('0x6e'))][(_0x780a('0x6f'))](_0x780a('0x70'),0x193);}_0x47f6dd=_0x906aa8;return db[_0x780a('0x71')][_0x780a('0x41')]({'raw':!![]});}return null;})[_0x780a('0x22')](function(_0x13168b){if(_0x13168b){_0xb9f53d=_[_0x780a('0x72')](_0x13168b,'id');var _0x353be8;var _0x47b269=squel[_0x780a('0x73')]();_0x47b269[_0x780a('0x74')](_0x40ad99[_0x780a('0x75')]);for(var _0x205ff6=0x0;_0x205ff6<_0x47f6dd[_0x780a('0x36')];_0x205ff6+=0x1){_0x353be8=_0x47f6dd[_0x205ff6][_0x780a('0x76')]?_0xb9f53d[_0x47f6dd[_0x205ff6][_0x780a('0x76')]]['metric']:_0x47f6dd[_0x205ff6]['field'];_0x353be8=_0x47f6dd[_0x205ff6][_0x780a('0x77')]?_[_0x780a('0x78')](_0x5be96a[_0x47f6dd[_0x205ff6][_0x780a('0x77')]],'%s',_0x353be8):_0x353be8;_0x353be8=_0x47f6dd[_0x205ff6][_0x780a('0x79')]?_[_0x780a('0x78')](_0x2257af[_0x47f6dd[_0x205ff6][_0x780a('0x79')]],'%s',_0x353be8):_0x353be8;if(_0x47f6dd[_0x205ff6][_0x780a('0x7a')]){_0x47b269['group'](_0x353be8);}_0x47f6dd[_0x205ff6][_0x780a('0x7b')]&&_0x47b269[_0x780a('0x38')](_0x353be8,_0x47f6dd[_0x205ff6][_0x780a('0x7b')]===_0x780a('0x7c')?![]:!![]);_0x47b269[_0x780a('0x6a')](_0x353be8,_0x47f6dd[_0x205ff6]['alias']||_0x353be8);}if(_0x40ad99[_0x780a('0x7d')]){_0x40ad99[_0x780a('0x7d')]=JSON[_0x780a('0x7e')](_0x40ad99['joins']);for(var _0x5baad8=0x0;_0x5baad8<_0x40ad99[_0x780a('0x7d')][_0x780a('0x36')];_0x5baad8+=0x1){if(_0x40ad99[_0x780a('0x7d')][_0x5baad8][_0x780a('0x2f')]&&_[_0x780a('0x7f')](_0x263d53,_0x40ad99['joins'][_0x5baad8][_0x780a('0x2f')])&&_0x40ad99['joins'][_0x5baad8]['parentKey']&&_0x40ad99[_0x780a('0x7d')][_0x5baad8]['foreignTable']&&_0x40ad99[_0x780a('0x7d')][_0x5baad8]['foreignKey']){_0x47b269[_0x40ad99[_0x780a('0x7d')][_0x5baad8][_0x780a('0x2f')]](_0x40ad99[_0x780a('0x7d')][_0x5baad8][_0x780a('0x80')],null,util[_0x780a('0x79')](_0x780a('0x81'),_0x40ad99[_0x780a('0x75')],_0x40ad99[_0x780a('0x7d')][_0x5baad8][_0x780a('0x82')],_0x40ad99[_0x780a('0x7d')][_0x5baad8]['foreignTable'],_0x40ad99['joins'][_0x5baad8][_0x780a('0x83')]));}}}if(_0x40ad99[_0x780a('0x84')]){_0x40ad99['conditions']=JSON[_0x780a('0x7e')](_0x40ad99[_0x780a('0x84')]);_0x47b269[_0x780a('0x3a')](_0x16f549(_0x40ad99['conditions'][_0x780a('0x69')]));}_0x4ccffc=_0x47b269[_0x780a('0x85')]();_0x47b269['limit'](_0x47ec7a);_0x47b269[_0x780a('0x1a')](0x0);logger[_0x780a('0x86')](_0x780a('0x87'),_0x47b269[_0x780a('0x88')]());return db[_0x780a('0x89')][_0x780a('0x32')](_0x47b269[_0x780a('0x88')](),{'type':db['sequelize'][_0x780a('0x8a')][_0x780a('0x8b')]});}})[_0x780a('0x22')](respondWithResult(_0x29d58c,null))[_0x780a('0x43')](handleError(_0x29d58c,null));};function runReport(_0x4a400c,_0xf82e9,_0x5dcaf4){var _0x368cfc=_0xf82e9['name'];var _0x21c7a9=0xa;var _0x360ebe=[_0x780a('0x55'),_0x780a('0x8c'),_0x780a('0x56'),_0x780a('0x57')];var _0x465c8a={'SUM':_0x780a('0x8d'),'COUNT':_0x780a('0x58'),'COUNT DISTINCT':_0x780a('0x59'),'MAX':_0x780a('0x8e'),'MIN':'MIN(%s)','AVG':_0x780a('0x5b'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x780a('0x5d'),'GROUP_CONCAT DESC':_0x780a('0x5e')};var _0x52d58f={'SEC_TO_TIME':_0x780a('0x5f'),'DATE':'DATE(%s)','HOUR':_0x780a('0x61'),'ROUND':_0x780a('0x62'),'UNIX_TIMESTAMP':_0x780a('0x63')};var _0x20e5cc=function(_0x6d8b36){return!_[_0x780a('0x7f')]([_0x780a('0x64'),_0x780a('0x65'),'IS\x20EMPTY',_0x780a('0x66')],_0x6d8b36);};var _0x59dcdc=function(_0x1429cf){if(!_0x1429cf||!_0x1429cf['rules'][_0x780a('0x36')]){return'';}for(var _0x4355f3='(',_0x3ea0bc=0x0;_0x3ea0bc<_0x1429cf[_0x780a('0x67')][_0x780a('0x36')];_0x3ea0bc+=0x1){_0x3ea0bc>0x0&&(_0x4355f3+='\x20'+_0x1429cf['operator']+'\x20');_0x4355f3+=_0x1429cf[_0x780a('0x67')][_0x3ea0bc][_0x780a('0x69')]?_0x59dcdc(_0x1429cf[_0x780a('0x67')][_0x3ea0bc][_0x780a('0x69')]):_0x1429cf[_0x780a('0x67')][_0x3ea0bc][_0x780a('0x6a')]+'\x20'+_0x1429cf[_0x780a('0x67')][_0x3ea0bc][_0x780a('0x6b')]+(_0x20e5cc(_0x1429cf[_0x780a('0x67')][_0x3ea0bc][_0x780a('0x6b')])?'\x20'+_0x1429cf['rules'][_0x3ea0bc][_0x780a('0x6c')]:'');}return _0x4355f3+')';};var _0x23d84a={'where':{'id':_0x4a400c['id']}},_0x125ba9,_0x5959f9,_0x1ad90b,_0x5a1b0a,_0x39b93f;_0x23d84a=_[_0x780a('0x3d')]({},_0x23d84a,_0x5dcaf4);return db[_0x780a('0x2c')]['find'](_0x23d84a)[_0x780a('0x22')](function(_0x16c9a2){if(_0x16c9a2){_0x125ba9=_0x16c9a2;return _0x16c9a2['getFields']();}return null;})['then'](function(_0x22c770){if(_0x22c770){if(!_0x22c770[_0x780a('0x36')]){throw new db['Sequelize'][(_0x780a('0x6f'))](_0x780a('0x70'),0x193);}_0x5959f9=_0x22c770;return db['AnalyticMetric']['findAll']({'raw':!![]});}return null;})['then'](function(_0x53837b){if(_0x53837b){_0x1ad90b=_['keyBy'](_0x53837b,'id');var _0x1d6059;var _0x13ff52=squel[_0x780a('0x73')]();_0x13ff52['from'](_0x125ba9[_0x780a('0x75')]);for(var _0x563e8b=0x0;_0x563e8b<_0x5959f9[_0x780a('0x36')];_0x563e8b+=0x1){_0x1d6059=_0x5959f9[_0x563e8b][_0x780a('0x76')]?_0x1ad90b[_0x5959f9[_0x563e8b][_0x780a('0x76')]]['metric']:_0x5959f9[_0x563e8b][_0x780a('0x6a')];_0x1d6059=_0x5959f9[_0x563e8b][_0x780a('0x77')]?_[_0x780a('0x78')](_0x465c8a[_0x5959f9[_0x563e8b]['function']],'%s',_0x1d6059):_0x1d6059;_0x1d6059=_0x5959f9[_0x563e8b][_0x780a('0x79')]?_['replace'](_0x52d58f[_0x5959f9[_0x563e8b][_0x780a('0x79')]],'%s',_0x1d6059):_0x1d6059;if(_0x5959f9[_0x563e8b]['groupBy']){_0x13ff52[_0x780a('0x69')](_0x1d6059);}_0x5959f9[_0x563e8b][_0x780a('0x7b')]&&_0x13ff52[_0x780a('0x38')](_0x1d6059,_0x5959f9[_0x563e8b][_0x780a('0x7b')]===_0x780a('0x7c')?![]:!![]);_0x13ff52[_0x780a('0x6a')](_0x1d6059,_0x5959f9[_0x563e8b][_0x780a('0x8f')]||_0x1d6059);}if(_0x125ba9['joins']){_0x125ba9[_0x780a('0x7d')]=JSON[_0x780a('0x7e')](_0x125ba9[_0x780a('0x7d')]);for(var _0x3ba451=0x0;_0x3ba451<_0x125ba9[_0x780a('0x7d')]['length'];_0x3ba451+=0x1){if(_0x125ba9[_0x780a('0x7d')][_0x3ba451][_0x780a('0x2f')]&&_[_0x780a('0x7f')](_0x360ebe,_0x125ba9[_0x780a('0x7d')][_0x3ba451]['type'])&&_0x125ba9['joins'][_0x3ba451][_0x780a('0x82')]&&_0x125ba9[_0x780a('0x7d')][_0x3ba451]['foreignTable']&&_0x125ba9[_0x780a('0x7d')][_0x3ba451][_0x780a('0x83')]){_0x13ff52[_0x125ba9['joins'][_0x3ba451][_0x780a('0x2f')]](_0x125ba9[_0x780a('0x7d')][_0x3ba451][_0x780a('0x80')],null,util[_0x780a('0x79')](_0x780a('0x81'),_0x125ba9[_0x780a('0x75')],_0x125ba9['joins'][_0x3ba451][_0x780a('0x82')],_0x125ba9[_0x780a('0x7d')][_0x3ba451][_0x780a('0x80')],_0x125ba9[_0x780a('0x7d')][_0x3ba451][_0x780a('0x83')]));}}}if(_0x125ba9[_0x780a('0x84')]){_0x125ba9[_0x780a('0x84')]=JSON['parse'](_0x125ba9['conditions']);_0x13ff52[_0x780a('0x3a')](_0x59dcdc(_0x125ba9[_0x780a('0x84')][_0x780a('0x69')]));}_0x39b93f=_0x13ff52['clone']();_0x13ff52[_0x780a('0x1b')](_0x21c7a9);_0x13ff52[_0x780a('0x1a')](0x0);logger['debug']('Limited\x20Query:',_0x13ff52[_0x780a('0x88')]());return db[_0x780a('0x89')]['query'](_0x13ff52['toString'](),{'type':db[_0x780a('0x89')]['QueryTypes'][_0x780a('0x8b')]});}})[_0x780a('0x22')](function(_0x4ad444){if(!_0x4ad444[_0x780a('0x36')]){throw new db[(_0x780a('0x6e'))][(_0x780a('0x6f'))](_0x780a('0x90'),0xcc);}if(_0xf82e9[_0x780a('0x91')]===_0x780a('0x92')){return null;}var _0x1de42a=_[_0x780a('0x3d')](_0xf82e9,{'name':_0xf82e9[_0x780a('0x93')]||_0xf82e9[_0x780a('0x29')]||_0x125ba9[_0x780a('0x29')],'basename':_0x368cfc,'savename':util[_0x780a('0x79')](_0x780a('0x94'),_0xf82e9[_0x780a('0x29')]||_0x125ba9[_0x780a('0x29')],require('randomstring')[_0x780a('0x95')](0x4),_0xf82e9['output']||_0x780a('0x96')),'reportId':_0x125ba9['id'],'reportType':'default'});return db[_0x780a('0x97')]['create'](_0x1de42a,{'raw':!![]});})['then'](function(_0xccc75f){if(_0x125ba9['table']==='cdr'){_0x39b93f[_0x780a('0x3a')](_0x125ba9[_0x780a('0x75')]+_0x780a('0x98'),_0xf82e9['startDate'],_0xf82e9['endDate']);}else{_0x39b93f['where'](_0x125ba9['table']+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0xf82e9['startDate'],_0xf82e9[_0x780a('0x99')]);}if(_0xccc75f){logger[_0x780a('0x9a')]('Run\x20Query:',_0x39b93f[_0x780a('0x88')]());require('child_process')[_0x780a('0x9b')](path[_0x780a('0x55')](__dirname,_0x780a('0x9c'),_0xccc75f[_0x780a('0x91')]),[_0xccc75f['id'],_0x39b93f['toString'](),path['join'](__dirname,'../../files/reports',_0xccc75f[_0x780a('0x9d')]),_0x368cfc]);return _0xccc75f;}else{var _0x50bd22=squel['select']();_0x50bd22['from']('('+_0x39b93f[_0x780a('0x88')]()+')','countTable');_0x50bd22[_0x780a('0x6a')]('COUNT(*)',_0x780a('0x19'));_0x39b93f['limit'](_0xf82e9[_0x780a('0x1b')]||_0x21c7a9);_0x39b93f[_0x780a('0x1a')](_0xf82e9[_0x780a('0x1a')]||0x0);return dbH[_0x780a('0x89')][_0x780a('0x32')](_0x50bd22[_0x780a('0x88')](),{'type':dbH[_0x780a('0x89')][_0x780a('0x8a')][_0x780a('0x8b')]})[_0x780a('0x22')](function(_0x469f91){if(!_0x469f91['length']){_0x5a1b0a=0x0;}else{_0x5a1b0a=_0x469f91[0x0][_0x780a('0x19')]||0x0;}return dbH[_0x780a('0x89')][_0x780a('0x32')](_0x39b93f[_0x780a('0x88')](),{'type':dbH[_0x780a('0x89')][_0x780a('0x8a')][_0x780a('0x8b')]});})[_0x780a('0x22')](function(_0xa209ab){return{'rows':_0xa209ab||[],'count':_0x5a1b0a};});}});}exports['run']=function(_0x28fb08,_0x41d6c2){return runReport(_0x28fb08[_0x780a('0x45')],_0x28fb08['query'],_0x28fb08[_0x780a('0x48')])['then'](respondWithResult(_0x41d6c2,null))[_0x780a('0x43')](handleError(_0x41d6c2,null));};exports['runReport']=runReport;exports[_0x780a('0x32')]=function(_0x50ad5d,_0x1b8b4c){var _0x5c66c0=0xa;var _0x3c101a=[_0x780a('0x55'),_0x780a('0x8c'),_0x780a('0x56'),_0x780a('0x57')];var _0x360838={'SUM':_0x780a('0x8d'),'COUNT':_0x780a('0x58'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x780a('0x8e'),'MIN':_0x780a('0x5a'),'AVG':'AVG(%s)','GROUP_CONCAT':_0x780a('0x5c'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0x780a('0x5e')};var _0x1fe4c0={'SEC_TO_TIME':_0x780a('0x5f'),'DATE':'DATE(%s)','HOUR':_0x780a('0x61'),'ROUND':_0x780a('0x62'),'UNIX_TIMESTAMP':_0x780a('0x63')};var _0x3d218b=function(_0x1427e3){return!_[_0x780a('0x7f')]([_0x780a('0x64'),_0x780a('0x65'),_0x780a('0x9e'),'IS\x20NOT\x20EMPTY'],_0x1427e3);};var _0x531960=function(_0x5e8b02){if(!_0x5e8b02||!_0x5e8b02[_0x780a('0x67')][_0x780a('0x36')]){return'';}for(var _0xe05973='(',_0x3907a6=0x0;_0x3907a6<_0x5e8b02['rules']['length'];_0x3907a6+=0x1){_0x3907a6>0x0&&(_0xe05973+='\x20'+_0x5e8b02[_0x780a('0x68')]+'\x20');_0xe05973+=_0x5e8b02[_0x780a('0x67')][_0x3907a6]['group']?_0x531960(_0x5e8b02['rules'][_0x3907a6]['group']):_0x5e8b02[_0x780a('0x67')][_0x3907a6][_0x780a('0x6a')]+'\x20'+_0x5e8b02[_0x780a('0x67')][_0x3907a6][_0x780a('0x6b')]+(_0x3d218b(_0x5e8b02[_0x780a('0x67')][_0x3907a6]['condition'])?'\x20'+_0x5e8b02['rules'][_0x3907a6]['value']:'');}return _0xe05973+')';};var _0x10bb28={'where':{'id':_0x50ad5d[_0x780a('0x45')]['id']}},_0x3ed4b1,_0x1de716,_0x39888a,_0x3a39fb,_0x1f6333;_0x10bb28=_[_0x780a('0x3d')]({},_0x10bb28,_0x50ad5d[_0x780a('0x48')]);return db['AnalyticDefaultReport'][_0x780a('0x49')](_0x10bb28)[_0x780a('0x22')](function(_0x5e2f3d){if(_0x5e2f3d){_0x3ed4b1=_0x5e2f3d;return _0x5e2f3d['getFields']();}return null;})['then'](function(_0x1a7fd1){if(_0x1a7fd1){if(!_0x1a7fd1[_0x780a('0x36')]){throw new db[(_0x780a('0x6e'))][(_0x780a('0x6f'))](_0x780a('0x70'),0x193);}_0x1de716=_0x1a7fd1;return db[_0x780a('0x71')][_0x780a('0x41')]({'raw':!![]});}return null;})[_0x780a('0x22')](function(_0x23cddb){if(_0x23cddb){_0x39888a=_[_0x780a('0x72')](_0x23cddb,'id');var _0x1267da;var _0x5da351=squel[_0x780a('0x73')]();_0x5da351[_0x780a('0x74')](_0x3ed4b1['table']);for(var _0x3e39b1=0x0;_0x3e39b1<_0x1de716['length'];_0x3e39b1+=0x1){_0x1267da=_0x1de716[_0x3e39b1][_0x780a('0x76')]?_0x39888a[_0x1de716[_0x3e39b1][_0x780a('0x76')]][_0x780a('0x9f')]:_0x1de716[_0x3e39b1][_0x780a('0x6a')];_0x1267da=_0x1de716[_0x3e39b1]['function']?_[_0x780a('0x78')](_0x360838[_0x1de716[_0x3e39b1][_0x780a('0x77')]],'%s',_0x1267da):_0x1267da;_0x1267da=_0x1de716[_0x3e39b1][_0x780a('0x79')]?_[_0x780a('0x78')](_0x1fe4c0[_0x1de716[_0x3e39b1]['format']],'%s',_0x1267da):_0x1267da;if(_0x1de716[_0x3e39b1][_0x780a('0x7a')]){_0x5da351['group'](_0x1267da);}_0x1de716[_0x3e39b1]['orderBy']&&_0x5da351[_0x780a('0x38')](_0x1267da,_0x1de716[_0x3e39b1][_0x780a('0x7b')]===_0x780a('0x7c')?![]:!![]);_0x5da351[_0x780a('0x6a')](_0x1267da,_0x1de716[_0x3e39b1]['alias']||_0x1267da);}if(_0x3ed4b1[_0x780a('0x7d')]){_0x3ed4b1['joins']=JSON[_0x780a('0x7e')](_0x3ed4b1[_0x780a('0x7d')]);for(var _0x24ebe7=0x0;_0x24ebe7<_0x3ed4b1[_0x780a('0x7d')][_0x780a('0x36')];_0x24ebe7+=0x1){if(_0x3ed4b1['joins'][_0x24ebe7][_0x780a('0x2f')]&&_[_0x780a('0x7f')](_0x3c101a,_0x3ed4b1[_0x780a('0x7d')][_0x24ebe7][_0x780a('0x2f')])&&_0x3ed4b1['joins'][_0x24ebe7]['parentKey']&&_0x3ed4b1[_0x780a('0x7d')][_0x24ebe7][_0x780a('0x80')]&&_0x3ed4b1['joins'][_0x24ebe7][_0x780a('0x83')]){_0x5da351[_0x3ed4b1[_0x780a('0x7d')][_0x24ebe7][_0x780a('0x2f')]](_0x3ed4b1[_0x780a('0x7d')][_0x24ebe7][_0x780a('0x80')],null,util[_0x780a('0x79')]('%s.%s\x20=\x20%s.%s',_0x3ed4b1[_0x780a('0x75')],_0x3ed4b1[_0x780a('0x7d')][_0x24ebe7]['parentKey'],_0x3ed4b1['joins'][_0x24ebe7][_0x780a('0x80')],_0x3ed4b1[_0x780a('0x7d')][_0x24ebe7][_0x780a('0x83')]));}}}if(_0x3ed4b1[_0x780a('0x84')]){_0x3ed4b1[_0x780a('0x84')]=JSON[_0x780a('0x7e')](_0x3ed4b1[_0x780a('0x84')]);_0x5da351[_0x780a('0x3a')](_0x531960(_0x3ed4b1[_0x780a('0x84')]['group']));}_0x1f6333=_0x5da351[_0x780a('0x85')]();_0x5da351['limit'](_0x5c66c0);_0x5da351[_0x780a('0x1a')](0x0);logger[_0x780a('0x86')]('Limited\x20Query:',_0x5da351[_0x780a('0x88')]());return db[_0x780a('0x89')][_0x780a('0x32')](_0x5da351['toString'](),{'type':db[_0x780a('0x89')]['QueryTypes'][_0x780a('0x8b')]});}})[_0x780a('0x22')](function(){return{'sql':_0x1f6333[_0x780a('0x88')]()};})[_0x780a('0x22')](respondWithResult(_0x1b8b4c,null))['catch'](handleError(_0x1b8b4c,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff