// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x708d=['jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','dbH','sendStatus','status','end','undefined','count','offset','limit','set','Content-Range','json','reject','update','then','destroy','CustomReports','UserProfileResource','error','stack','name','send','index','map','rawAttributes','fieldName','type','key','model','query','keys','intersection','attributes','fields','length','hasOwnProperty','nolimit','sort','where','filters','merge','VIRTUAL','filter','options','includeAll','AnalyticCustomReport','findAll','params','include','create','body','get','user','Reports','UserProfileSection','find','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','catch','preview','join','left_join','right_join','cross_join','SUM(%s)','COUNT(%s)','MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','SEC_TO_TIME(%s)','DATE(%s)','UNIX_TIMESTAMP(%s)','IS\x20NULL','IS\x20EMPTY','rules','group','condition','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','select','from','table','MetricId','field','replace','format','groupBy','orderBy','order','DESC','alias','joins','parse','parentKey','foreignTable','foreignKey','conditions','clone','debug','Limited\x20Query:','toString','sequelize','SELECT','COUNT(DISTINCT\x20%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','HOUR(%s)','includes','IS\x20NOT\x20NULL','IS\x20NOT\x20EMPTY','operator','value','metric','output','web','%s-%s.%s','randomstring','generate','csv','custom','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','endDate','child_process','fork','../../components/export/','../../files/reports','savename','countTable','COUNT(*)','QueryTypes','run','runReport','function','%s.%s\x20=\x20%s.%s','eml-format','rimraf','zip-dir','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto'];(function(_0x5404e9,_0x2d43e8){var _0x1ba85e=function(_0x45ceb9){while(--_0x45ceb9){_0x5404e9['push'](_0x5404e9['shift']());}};_0x1ba85e(++_0x2d43e8);}(_0x708d,0x145));var _0xd708=function(_0x3aeea1,_0x4cfbb9){_0x3aeea1=_0x3aeea1-0x0;var _0x424cc1=_0x708d[_0x3aeea1];return _0x424cc1;};'use strict';var emlformat=require(_0xd708('0x0'));var rimraf=require(_0xd708('0x1'));var zipdir=require(_0xd708('0x2'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0xd708('0x3'));var BPromise=require(_0xd708('0x4'));var Mustache=require(_0xd708('0x5'));var util=require(_0xd708('0x6'));var path=require(_0xd708('0x7'));var sox=require(_0xd708('0x8'));var csv=require(_0xd708('0x9'));var ejs=require(_0xd708('0xa'));var fs=require('fs');var fs_extra=require(_0xd708('0xb'));var _=require(_0xd708('0xc'));var squel=require(_0xd708('0xd'));var crypto=require(_0xd708('0xe'));var jsforce=require(_0xd708('0xf'));var deskjs=require(_0xd708('0x10'));var toCsv=require(_0xd708('0x9'));var querystring=require('querystring');var Papa=require(_0xd708('0x11'));var Redis=require(_0xd708('0x12'));var authService=require(_0xd708('0x13'));var qs=require(_0xd708('0x14'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xd708('0x15'));var logger=require(_0xd708('0x16'))(_0xd708('0x17'));var utils=require('../../config/utils');var config=require(_0xd708('0x18'));var licenseUtil=require(_0xd708('0x19'));var db=require(_0xd708('0x1a'))['db'];var dbH=require(_0xd708('0x1a'))[_0xd708('0x1b')];function respondWithStatusCode(_0x7c6d24,_0x3e9369){_0x3e9369=_0x3e9369||0xcc;return function(_0x1dfd9e){if(_0x1dfd9e){return _0x7c6d24[_0xd708('0x1c')](_0x3e9369);}return _0x7c6d24[_0xd708('0x1d')](_0x3e9369)[_0xd708('0x1e')]();};}function respondWithResult(_0xda4aff,_0x455ee2){_0x455ee2=_0x455ee2||0xc8;return function(_0x806648){if(_0x806648){return _0xda4aff[_0xd708('0x1d')](_0x455ee2)['json'](_0x806648);}};}function respondWithFilteredResult(_0x171a0a,_0x299a79){return function(_0x446453){if(_0x446453){var _0x3f199a=typeof _0x299a79['offset']===_0xd708('0x1f')&&typeof _0x299a79['limit']===_0xd708('0x1f');var _0x27ef86=_0x446453[_0xd708('0x20')];var _0x138cd6=_0x3f199a?0x0:_0x299a79[_0xd708('0x21')];var _0x1e7139=_0x3f199a?_0x446453[_0xd708('0x20')]:_0x299a79[_0xd708('0x21')]+_0x299a79[_0xd708('0x22')];var _0x22cf52;if(_0x1e7139>=_0x27ef86){_0x1e7139=_0x27ef86;_0x22cf52=0xc8;}else{_0x22cf52=0xce;}_0x171a0a['status'](_0x22cf52);return _0x171a0a[_0xd708('0x23')](_0xd708('0x24'),_0x138cd6+'-'+_0x1e7139+'/'+_0x27ef86)[_0xd708('0x25')](_0x446453);}return null;};}function patchUpdates(_0x4a4bcc){return function(_0x41a7e7){try{jsonpatch['apply'](_0x41a7e7,_0x4a4bcc,!![]);}catch(_0x29526b){return BPromise[_0xd708('0x26')](_0x29526b);}return _0x41a7e7['save']();};}function saveUpdates(_0x5a4067,_0x102259){return function(_0x3f0093){if(_0x3f0093){return _0x3f0093[_0xd708('0x27')](_0x5a4067)[_0xd708('0x28')](function(_0x2044f7){return _0x2044f7;});}return null;};}function removeEntity(_0xecbdf2,_0x2c2cfb){return function(_0x2787bf){if(_0x2787bf){return _0x2787bf[_0xd708('0x29')]()[_0xd708('0x28')](function(){var _0x5883ce=_0x2787bf['get']({'plain':!![]});var _0x3444a5=_0xd708('0x2a');return db[_0xd708('0x2b')][_0xd708('0x29')]({'where':{'type':_0x3444a5,'resourceId':_0x5883ce['id']}})[_0xd708('0x28')](function(){return _0x2787bf;});})[_0xd708('0x28')](function(){_0xecbdf2['status'](0xcc)[_0xd708('0x1e')]();});}};}function handleEntityNotFound(_0x3cda91,_0x543fb1){return function(_0x2e541a){if(!_0x2e541a){_0x3cda91[_0xd708('0x1c')](0x194);}return _0x2e541a;};}function handleError(_0x357c9c,_0x59bfad){_0x59bfad=_0x59bfad||0x1f4;return function(_0x436cc7){logger[_0xd708('0x2c')](_0x436cc7[_0xd708('0x2d')]);if(_0x436cc7[_0xd708('0x2e')]){delete _0x436cc7[_0xd708('0x2e')];}_0x357c9c[_0xd708('0x1d')](_0x59bfad)[_0xd708('0x2f')](_0x436cc7);};}exports[_0xd708('0x30')]=function(_0x620ee2,_0x4c4557){var _0x3759f5={},_0x3114a3={},_0xaa92eb={'count':0x0,'rows':[]};var _0x5ccb5a=_[_0xd708('0x31')](db['AnalyticCustomReport'][_0xd708('0x32')],function(_0x48a1f0){return{'name':_0x48a1f0[_0xd708('0x33')],'type':_0x48a1f0[_0xd708('0x34')][_0xd708('0x35')]};});_0x3114a3[_0xd708('0x36')]=_[_0xd708('0x31')](_0x5ccb5a,_0xd708('0x2e'));_0x3114a3[_0xd708('0x37')]=_[_0xd708('0x38')](_0x620ee2[_0xd708('0x37')]);_0x3114a3['filters']=_[_0xd708('0x39')](_0x3114a3[_0xd708('0x36')],_0x3114a3[_0xd708('0x37')]);_0x3759f5[_0xd708('0x3a')]=_[_0xd708('0x39')](_0x3114a3[_0xd708('0x36')],qs[_0xd708('0x3b')](_0x620ee2[_0xd708('0x37')][_0xd708('0x3b')]));_0x3759f5['attributes']=_0x3759f5[_0xd708('0x3a')][_0xd708('0x3c')]?_0x3759f5[_0xd708('0x3a')]:_0x3114a3[_0xd708('0x36')];if(!_0x620ee2['query'][_0xd708('0x3d')](_0xd708('0x3e'))){_0x3759f5[_0xd708('0x22')]=qs[_0xd708('0x22')](_0x620ee2[_0xd708('0x37')]['limit']);_0x3759f5[_0xd708('0x21')]=qs[_0xd708('0x21')](_0x620ee2[_0xd708('0x37')][_0xd708('0x21')]);}_0x3759f5['order']=qs[_0xd708('0x3f')](_0x620ee2[_0xd708('0x37')][_0xd708('0x3f')]);_0x3759f5[_0xd708('0x40')]=qs['filters'](_['pick'](_0x620ee2['query'],_0x3114a3[_0xd708('0x41')]),_0x5ccb5a);if(_0x620ee2['query']['filter']){_0x3759f5[_0xd708('0x40')]=_[_0xd708('0x42')](_0x3759f5[_0xd708('0x40')],{'$or':_[_0xd708('0x31')](_0x5ccb5a,function(_0x9767ed){if(_0x9767ed['type']!==_0xd708('0x43')){var _0x2b9707={};_0x2b9707[_0x9767ed[_0xd708('0x2e')]]={'$like':'%'+_0x620ee2[_0xd708('0x37')][_0xd708('0x44')]+'%'};return _0x2b9707;}})});}_0x3759f5=_['merge']({},_0x3759f5,_0x620ee2[_0xd708('0x45')]);var _0x384b35={'where':_0x3759f5[_0xd708('0x40')]};return db['AnalyticCustomReport'][_0xd708('0x20')](_0x384b35)['then'](function(_0x48ab04){_0xaa92eb[_0xd708('0x20')]=_0x48ab04;if(_0x620ee2[_0xd708('0x37')][_0xd708('0x46')]){_0x3759f5['include']=[{'all':!![]}];}return db[_0xd708('0x47')][_0xd708('0x48')](_0x3759f5);})[_0xd708('0x28')](function(_0x20f9cf){_0xaa92eb['rows']=_0x20f9cf;return _0xaa92eb;})[_0xd708('0x28')](respondWithFilteredResult(_0x4c4557,_0x3759f5))['catch'](handleError(_0x4c4557,null));};exports['show']=function(_0x44d296,_0x5c2cdc){var _0x4b1751={'raw':![],'where':{'id':_0x44d296[_0xd708('0x49')]['id']}},_0x5b0c83={};_0x5b0c83['model']=_['keys'](db[_0xd708('0x47')][_0xd708('0x32')]);_0x5b0c83[_0xd708('0x37')]=_[_0xd708('0x38')](_0x44d296[_0xd708('0x37')]);_0x5b0c83[_0xd708('0x41')]=_['intersection'](_0x5b0c83[_0xd708('0x36')],_0x5b0c83['query']);_0x4b1751[_0xd708('0x3a')]=_['intersection'](_0x5b0c83[_0xd708('0x36')],qs[_0xd708('0x3b')](_0x44d296[_0xd708('0x37')]['fields']));_0x4b1751['attributes']=_0x4b1751[_0xd708('0x3a')][_0xd708('0x3c')]?_0x4b1751[_0xd708('0x3a')]:_0x5b0c83['model'];if(_0x44d296[_0xd708('0x37')]['includeAll']){_0x4b1751[_0xd708('0x4a')]=[{'all':!![]}];}_0x4b1751=_[_0xd708('0x42')]({},_0x4b1751,_0x44d296['options']);return db['AnalyticCustomReport']['find'](_0x4b1751)['then'](handleEntityNotFound(_0x5c2cdc,null))[_0xd708('0x28')](respondWithResult(_0x5c2cdc,null))['catch'](handleError(_0x5c2cdc,null));};exports['create']=function(_0x7913db,_0x33848d){return db[_0xd708('0x47')][_0xd708('0x4b')](_0x7913db[_0xd708('0x4c')],{})['then'](function(_0x496268){var _0x3bfbff=_0x7913db['user'][_0xd708('0x4d')]({'plain':!![]});if(!_0x3bfbff)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x3bfbff['role']===_0xd708('0x4e')){var _0x2b624b=_0x496268[_0xd708('0x4d')]({'plain':!![]});var _0x54b307=_0xd708('0x4f');return db[_0xd708('0x50')][_0xd708('0x51')]({'where':{'name':_0x54b307,'userProfileId':_0x3bfbff[_0xd708('0x52')]},'raw':!![]})['then'](function(_0x301904){if(_0x301904&&_0x301904[_0xd708('0x53')]===0x0){return db[_0xd708('0x2b')]['create']({'name':_0x2b624b[_0xd708('0x2e')],'resourceId':_0x2b624b['id'],'type':_0xd708('0x2a'),'sectionId':_0x301904['id']},{})[_0xd708('0x28')](function(){return _0x496268;});}else{return _0x496268;}})['catch'](function(_0x4d5f5b){logger['error'](_0xd708('0x54'),_0x4d5f5b);throw _0x4d5f5b;});}return _0x496268;})[_0xd708('0x28')](respondWithResult(_0x33848d,0xc9))[_0xd708('0x55')](handleError(_0x33848d,null));};exports[_0xd708('0x27')]=function(_0x15a263,_0x2aaa20){if(_0x15a263[_0xd708('0x4c')]['id']){delete _0x15a263['body']['id'];}return db[_0xd708('0x47')][_0xd708('0x51')]({'where':{'id':_0x15a263[_0xd708('0x49')]['id']}})[_0xd708('0x28')](handleEntityNotFound(_0x2aaa20,null))[_0xd708('0x28')](saveUpdates(_0x15a263['body'],null))[_0xd708('0x28')](respondWithResult(_0x2aaa20,null))[_0xd708('0x55')](handleError(_0x2aaa20,null));};exports['destroy']=function(_0x46502d,_0x56ca16){return db['AnalyticCustomReport'][_0xd708('0x51')]({'where':{'id':_0x46502d[_0xd708('0x49')]['id']}})[_0xd708('0x28')](handleEntityNotFound(_0x56ca16,null))[_0xd708('0x28')](removeEntity(_0x56ca16,null))[_0xd708('0x55')](handleError(_0x56ca16,null));};exports[_0xd708('0x56')]=function(_0x1b8e8e,_0x52a793){var _0xf70e6=0xa;var _0x56708b=[_0xd708('0x57'),_0xd708('0x58'),_0xd708('0x59'),_0xd708('0x5a')];var _0x969628={'SUM':_0xd708('0x5b'),'COUNT':_0xd708('0x5c'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0xd708('0x5d'),'MIN':_0xd708('0x5e'),'AVG':_0xd708('0x5f'),'GROUP_CONCAT':_0xd708('0x60'),'GROUP_CONCAT ASC':_0xd708('0x61'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x1f94c9={'SEC_TO_TIME':_0xd708('0x62'),'DATE':_0xd708('0x63'),'HOUR':'HOUR(%s)','ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0xd708('0x64')};var _0x37012b=function(_0xce1c8a){return!_['includes']([_0xd708('0x65'),'IS\x20NOT\x20NULL',_0xd708('0x66'),'IS\x20NOT\x20EMPTY'],_0xce1c8a);};var _0x28cfe3=function(_0x535a33){if(!_0x535a33||!_0x535a33[_0xd708('0x67')][_0xd708('0x3c')]){return'';}for(var _0x47cfa9='(',_0x2b6a7e=0x0;_0x2b6a7e<_0x535a33[_0xd708('0x67')][_0xd708('0x3c')];_0x2b6a7e+=0x1){_0x2b6a7e>0x0&&(_0x47cfa9+='\x20'+_0x535a33['operator']+'\x20');_0x47cfa9+=_0x535a33[_0xd708('0x67')][_0x2b6a7e]['group']?_0x28cfe3(_0x535a33[_0xd708('0x67')][_0x2b6a7e][_0xd708('0x68')]):_0x535a33['rules'][_0x2b6a7e]['field']+'\x20'+_0x535a33[_0xd708('0x67')][_0x2b6a7e][_0xd708('0x69')]+(_0x37012b(_0x535a33[_0xd708('0x67')][_0x2b6a7e][_0xd708('0x69')])?'\x20'+_0x535a33[_0xd708('0x67')][_0x2b6a7e]['value']:'');}return _0x47cfa9+')';};var _0x56c80b={'where':{'id':_0x1b8e8e[_0xd708('0x49')]['id']}},_0x42b338,_0x362e24,_0x22ed22,_0x72c1e,_0x2e233c;_0x56c80b=_[_0xd708('0x42')]({},_0x56c80b,_0x1b8e8e[_0xd708('0x45')]);return db[_0xd708('0x47')][_0xd708('0x51')](_0x56c80b)[_0xd708('0x28')](function(_0x5b0b8c){if(_0x5b0b8c){_0x42b338=_0x5b0b8c;return _0x5b0b8c[_0xd708('0x6a')]();}return null;})[_0xd708('0x28')](function(_0x2a6fad){if(_0x2a6fad){if(!_0x2a6fad[_0xd708('0x3c')]){throw new db[(_0xd708('0x6b'))][(_0xd708('0x6c'))](_0xd708('0x6d'),0x193);}_0x362e24=_0x2a6fad;return db[_0xd708('0x6e')][_0xd708('0x48')]({'raw':!![]});}return null;})[_0xd708('0x28')](function(_0x1e0065){if(_0x1e0065){_0x22ed22=_[_0xd708('0x6f')](_0x1e0065,'id');var _0x39ad6b;var _0x4be557=squel[_0xd708('0x70')]();_0x4be557[_0xd708('0x71')](_0x42b338[_0xd708('0x72')]);for(var _0x13f1b9=0x0;_0x13f1b9<_0x362e24[_0xd708('0x3c')];_0x13f1b9+=0x1){_0x39ad6b=_0x362e24[_0x13f1b9]['MetricId']?_0x22ed22[_0x362e24[_0x13f1b9][_0xd708('0x73')]]['metric']:_0x362e24[_0x13f1b9][_0xd708('0x74')];_0x39ad6b=_0x362e24[_0x13f1b9]['function']?_[_0xd708('0x75')](_0x969628[_0x362e24[_0x13f1b9]['function']],'%s',_0x39ad6b):_0x39ad6b;_0x39ad6b=_0x362e24[_0x13f1b9][_0xd708('0x76')]?_[_0xd708('0x75')](_0x1f94c9[_0x362e24[_0x13f1b9]['format']],'%s',_0x39ad6b):_0x39ad6b;if(_0x362e24[_0x13f1b9][_0xd708('0x77')]){_0x4be557[_0xd708('0x68')](_0x39ad6b);}_0x362e24[_0x13f1b9][_0xd708('0x78')]&&_0x4be557[_0xd708('0x79')](_0x39ad6b,_0x362e24[_0x13f1b9]['orderBy']===_0xd708('0x7a')?![]:!![]);_0x4be557[_0xd708('0x74')](_0x39ad6b,_0x362e24[_0x13f1b9][_0xd708('0x7b')]||_0x39ad6b);}if(_0x42b338['joins']){_0x42b338[_0xd708('0x7c')]=JSON[_0xd708('0x7d')](_0x42b338[_0xd708('0x7c')]);for(var _0x2f1c29=0x0;_0x2f1c29<_0x42b338[_0xd708('0x7c')]['length'];_0x2f1c29+=0x1){if(_0x42b338[_0xd708('0x7c')][_0x2f1c29][_0xd708('0x34')]&&_['includes'](_0x56708b,_0x42b338[_0xd708('0x7c')][_0x2f1c29]['type'])&&_0x42b338[_0xd708('0x7c')][_0x2f1c29][_0xd708('0x7e')]&&_0x42b338[_0xd708('0x7c')][_0x2f1c29][_0xd708('0x7f')]&&_0x42b338[_0xd708('0x7c')][_0x2f1c29][_0xd708('0x80')]){_0x4be557[_0x42b338[_0xd708('0x7c')][_0x2f1c29][_0xd708('0x34')]](_0x42b338[_0xd708('0x7c')][_0x2f1c29][_0xd708('0x7f')],null,util[_0xd708('0x76')]('%s.%s\x20=\x20%s.%s',_0x42b338['table'],_0x42b338[_0xd708('0x7c')][_0x2f1c29][_0xd708('0x7e')],_0x42b338[_0xd708('0x7c')][_0x2f1c29][_0xd708('0x7f')],_0x42b338['joins'][_0x2f1c29][_0xd708('0x80')]));}}}if(_0x42b338['conditions']){_0x42b338[_0xd708('0x81')]=JSON[_0xd708('0x7d')](_0x42b338[_0xd708('0x81')]);_0x4be557['where'](_0x28cfe3(_0x42b338[_0xd708('0x81')]['group']));}_0x2e233c=_0x4be557[_0xd708('0x82')]();_0x4be557['limit'](_0xf70e6);_0x4be557['offset'](0x0);logger[_0xd708('0x83')](_0xd708('0x84'),_0x4be557[_0xd708('0x85')]());return dbH[_0xd708('0x86')][_0xd708('0x37')](_0x4be557[_0xd708('0x85')](),{'type':dbH[_0xd708('0x86')]['QueryTypes'][_0xd708('0x87')]});}})[_0xd708('0x28')](respondWithResult(_0x52a793,null))['catch'](handleError(_0x52a793,null));};function runReport(_0x109dfe,_0x1a13e4,_0x10db9c){var _0x1d5cff=_0x1a13e4[_0xd708('0x2e')];var _0x408cd3=0xa;var _0x46f4d4=['join',_0xd708('0x58'),_0xd708('0x59'),_0xd708('0x5a')];var _0x5f3bc4={'SUM':_0xd708('0x5b'),'COUNT':_0xd708('0x5c'),'COUNT DISTINCT':_0xd708('0x88'),'MAX':_0xd708('0x5d'),'MIN':_0xd708('0x5e'),'AVG':_0xd708('0x5f'),'GROUP_CONCAT':_0xd708('0x60'),'GROUP_CONCAT ASC':_0xd708('0x61'),'GROUP_CONCAT DESC':_0xd708('0x89')};var _0x3ce18e={'SEC_TO_TIME':_0xd708('0x62'),'DATE':_0xd708('0x63'),'HOUR':_0xd708('0x8a'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x2d6959=function(_0x4a5ae0){return!_[_0xd708('0x8b')](['IS\x20NULL',_0xd708('0x8c'),_0xd708('0x66'),_0xd708('0x8d')],_0x4a5ae0);};var _0x95a311=function(_0x2d6627){if(!_0x2d6627||!_0x2d6627[_0xd708('0x67')][_0xd708('0x3c')]){return'';}for(var _0x34ad99='(',_0x22c331=0x0;_0x22c331<_0x2d6627[_0xd708('0x67')][_0xd708('0x3c')];_0x22c331+=0x1){_0x22c331>0x0&&(_0x34ad99+='\x20'+_0x2d6627[_0xd708('0x8e')]+'\x20');_0x34ad99+=_0x2d6627['rules'][_0x22c331][_0xd708('0x68')]?_0x95a311(_0x2d6627[_0xd708('0x67')][_0x22c331]['group']):_0x2d6627[_0xd708('0x67')][_0x22c331]['field']+'\x20'+_0x2d6627['rules'][_0x22c331][_0xd708('0x69')]+(_0x2d6959(_0x2d6627[_0xd708('0x67')][_0x22c331]['condition'])?'\x20'+_0x2d6627[_0xd708('0x67')][_0x22c331][_0xd708('0x8f')]:'');}return _0x34ad99+')';};var _0x439f34={'where':{'id':_0x109dfe['id']}},_0x28bd27,_0x2e64fa,_0x44f435,_0x5f1af4,_0x3f9378;_0x439f34=_['merge']({},_0x439f34,_0x10db9c);return db['AnalyticCustomReport'][_0xd708('0x51')](_0x439f34)[_0xd708('0x28')](function(_0x4d6360){if(_0x4d6360){_0x28bd27=_0x4d6360;return _0x4d6360[_0xd708('0x6a')]();}return null;})[_0xd708('0x28')](function(_0x1f4e7e){if(_0x1f4e7e){if(!_0x1f4e7e['length']){throw new db[(_0xd708('0x6b'))][(_0xd708('0x6c'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x2e64fa=_0x1f4e7e;return db[_0xd708('0x6e')]['findAll']({'raw':!![]});}return null;})[_0xd708('0x28')](function(_0x16f8ba){if(_0x16f8ba){_0x44f435=_['keyBy'](_0x16f8ba,'id');var _0x2894d6;var _0x346e7f=squel[_0xd708('0x70')]();_0x346e7f['from'](_0x28bd27['table']);for(var _0x55fb4b=0x0;_0x55fb4b<_0x2e64fa[_0xd708('0x3c')];_0x55fb4b+=0x1){_0x2894d6=_0x2e64fa[_0x55fb4b][_0xd708('0x73')]?_0x44f435[_0x2e64fa[_0x55fb4b]['MetricId']][_0xd708('0x90')]:_0x2e64fa[_0x55fb4b][_0xd708('0x74')];_0x2894d6=_0x2e64fa[_0x55fb4b]['function']?_[_0xd708('0x75')](_0x5f3bc4[_0x2e64fa[_0x55fb4b]['function']],'%s',_0x2894d6):_0x2894d6;_0x2894d6=_0x2e64fa[_0x55fb4b][_0xd708('0x76')]?_[_0xd708('0x75')](_0x3ce18e[_0x2e64fa[_0x55fb4b]['format']],'%s',_0x2894d6):_0x2894d6;if(_0x2e64fa[_0x55fb4b][_0xd708('0x77')]){_0x346e7f[_0xd708('0x68')](_0x2894d6);}_0x2e64fa[_0x55fb4b]['orderBy']&&_0x346e7f[_0xd708('0x79')](_0x2894d6,_0x2e64fa[_0x55fb4b][_0xd708('0x78')]===_0xd708('0x7a')?![]:!![]);_0x346e7f[_0xd708('0x74')](_0x2894d6,_0x2e64fa[_0x55fb4b]['alias']||_0x2894d6);}if(_0x28bd27[_0xd708('0x7c')]){_0x28bd27[_0xd708('0x7c')]=JSON['parse'](_0x28bd27[_0xd708('0x7c')]);for(var _0x2d78ef=0x0;_0x2d78ef<_0x28bd27[_0xd708('0x7c')][_0xd708('0x3c')];_0x2d78ef+=0x1){if(_0x28bd27[_0xd708('0x7c')][_0x2d78ef][_0xd708('0x34')]&&_[_0xd708('0x8b')](_0x46f4d4,_0x28bd27[_0xd708('0x7c')][_0x2d78ef][_0xd708('0x34')])&&_0x28bd27['joins'][_0x2d78ef][_0xd708('0x7e')]&&_0x28bd27[_0xd708('0x7c')][_0x2d78ef][_0xd708('0x7f')]&&_0x28bd27[_0xd708('0x7c')][_0x2d78ef][_0xd708('0x80')]){_0x346e7f[_0x28bd27[_0xd708('0x7c')][_0x2d78ef][_0xd708('0x34')]](_0x28bd27[_0xd708('0x7c')][_0x2d78ef][_0xd708('0x7f')],null,util[_0xd708('0x76')]('%s.%s\x20=\x20%s.%s',_0x28bd27[_0xd708('0x72')],_0x28bd27[_0xd708('0x7c')][_0x2d78ef]['parentKey'],_0x28bd27[_0xd708('0x7c')][_0x2d78ef][_0xd708('0x7f')],_0x28bd27['joins'][_0x2d78ef][_0xd708('0x80')]));}}}if(_0x28bd27[_0xd708('0x81')]){_0x28bd27[_0xd708('0x81')]=JSON[_0xd708('0x7d')](_0x28bd27[_0xd708('0x81')]);_0x346e7f[_0xd708('0x40')](_0x95a311(_0x28bd27[_0xd708('0x81')][_0xd708('0x68')]));}_0x3f9378=_0x346e7f['clone']();_0x346e7f['limit'](_0x408cd3);_0x346e7f[_0xd708('0x21')](0x0);return;}})[_0xd708('0x28')](function(){if(_0x1a13e4[_0xd708('0x91')]===_0xd708('0x92')){return null;}var _0x38dfdb=_[_0xd708('0x42')](_0x1a13e4,{'name':_0x1a13e4['fullPath']||_0x1a13e4['name']||_0x28bd27[_0xd708('0x2e')],'basename':_0x1d5cff,'savename':util[_0xd708('0x76')](_0xd708('0x93'),_0x1a13e4[_0xd708('0x2e')]||_0x28bd27[_0xd708('0x2e')],require(_0xd708('0x94'))[_0xd708('0x95')](0x4),_0x1a13e4[_0xd708('0x91')]||_0xd708('0x96')),'reportId':_0x28bd27['id'],'reportType':_0xd708('0x97')});return db[_0xd708('0x98')][_0xd708('0x4b')](_0x38dfdb,{'raw':!![]});})[_0xd708('0x28')](function(_0x8ebc5d){if(_0x28bd27[_0xd708('0x72')]===_0xd708('0x99')){_0x3f9378[_0xd708('0x40')](_0x28bd27[_0xd708('0x72')]+_0xd708('0x9a'),_0x1a13e4[_0xd708('0x9b')],_0x1a13e4['endDate']);}else{_0x3f9378[_0xd708('0x40')](_0x28bd27['table']+_0xd708('0x9c'),_0x1a13e4[_0xd708('0x9b')],_0x1a13e4[_0xd708('0x9d')]);}if(_0x8ebc5d){logger['info']('Run\x20Query:',_0x3f9378[_0xd708('0x85')]());require(_0xd708('0x9e'))[_0xd708('0x9f')](path[_0xd708('0x57')](__dirname,_0xd708('0xa0'),_0x8ebc5d['output']),[_0x8ebc5d['id'],_0x3f9378[_0xd708('0x85')](),path[_0xd708('0x57')](__dirname,_0xd708('0xa1'),_0x8ebc5d[_0xd708('0xa2')]),_0x1d5cff]);return _0x8ebc5d;}else{var _0x39ecf7=squel['select']();_0x39ecf7[_0xd708('0x71')]('('+_0x3f9378[_0xd708('0x85')]()+')',_0xd708('0xa3'));_0x39ecf7['field'](_0xd708('0xa4'),_0xd708('0x20'));_0x3f9378[_0xd708('0x22')](_0x1a13e4[_0xd708('0x22')]||_0x408cd3);_0x3f9378[_0xd708('0x21')](_0x1a13e4[_0xd708('0x21')]||0x0);return dbH[_0xd708('0x86')][_0xd708('0x37')](_0x39ecf7[_0xd708('0x85')](),{'type':dbH[_0xd708('0x86')]['QueryTypes'][_0xd708('0x87')]})[_0xd708('0x28')](function(_0x138ab6){if(!_0x138ab6['length']){_0x5f1af4=0x0;}else{_0x5f1af4=_0x138ab6[0x0]['count']||0x0;}return dbH[_0xd708('0x86')][_0xd708('0x37')](_0x3f9378['toString'](),{'type':dbH[_0xd708('0x86')][_0xd708('0xa5')]['SELECT']});})['then'](function(_0x707158){return{'rows':_0x707158||[],'count':_0x5f1af4};});}});}exports[_0xd708('0xa6')]=function(_0x4e070f,_0xa975e9){return runReport(_0x4e070f[_0xd708('0x49')],_0x4e070f[_0xd708('0x37')],_0x4e070f[_0xd708('0x45')])[_0xd708('0x28')](respondWithResult(_0xa975e9,null))['catch'](handleError(_0xa975e9,null));};exports[_0xd708('0xa7')]=runReport;exports[_0xd708('0x37')]=function(_0x3b6a5a,_0x5d30e6){var _0x5f2768=0xa;var _0x3db9aa=[_0xd708('0x57'),_0xd708('0x58'),_0xd708('0x59'),_0xd708('0x5a')];var _0x3b0060={'SUM':'SUM(%s)','COUNT':_0xd708('0x5c'),'COUNT DISTINCT':_0xd708('0x88'),'MAX':'MAX(%s)','MIN':_0xd708('0x5e'),'AVG':_0xd708('0x5f'),'GROUP_CONCAT':_0xd708('0x60'),'GROUP_CONCAT ASC':_0xd708('0x61'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x512b2e={'SEC_TO_TIME':_0xd708('0x62'),'DATE':_0xd708('0x63'),'HOUR':_0xd708('0x8a'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x4c2ce0=function(_0x494134){return!_['includes']([_0xd708('0x65'),_0xd708('0x8c'),_0xd708('0x66'),_0xd708('0x8d')],_0x494134);};var _0x333058=function(_0x28ed1d){if(!_0x28ed1d||!_0x28ed1d[_0xd708('0x67')]['length']){return'';}for(var _0x2a71ad='(',_0x3535b7=0x0;_0x3535b7<_0x28ed1d['rules'][_0xd708('0x3c')];_0x3535b7+=0x1){_0x3535b7>0x0&&(_0x2a71ad+='\x20'+_0x28ed1d[_0xd708('0x8e')]+'\x20');_0x2a71ad+=_0x28ed1d[_0xd708('0x67')][_0x3535b7][_0xd708('0x68')]?_0x333058(_0x28ed1d[_0xd708('0x67')][_0x3535b7][_0xd708('0x68')]):_0x28ed1d[_0xd708('0x67')][_0x3535b7]['field']+'\x20'+_0x28ed1d[_0xd708('0x67')][_0x3535b7][_0xd708('0x69')]+(_0x4c2ce0(_0x28ed1d[_0xd708('0x67')][_0x3535b7][_0xd708('0x69')])?'\x20'+_0x28ed1d['rules'][_0x3535b7]['value']:'');}return _0x2a71ad+')';};var _0xeeacc5={'where':{'id':_0x3b6a5a['params']['id']}},_0x130d1e,_0x2af7d3,_0x5d30ad,_0x2ab3f5,_0x4d9e74;_0xeeacc5=_[_0xd708('0x42')]({},_0xeeacc5,_0x3b6a5a['options']);return db[_0xd708('0x47')][_0xd708('0x51')](_0xeeacc5)[_0xd708('0x28')](function(_0x11c7c1){if(_0x11c7c1){_0x130d1e=_0x11c7c1;return _0x11c7c1[_0xd708('0x6a')]();}return null;})[_0xd708('0x28')](function(_0x2df880){if(_0x2df880){if(!_0x2df880[_0xd708('0x3c')]){throw new db[(_0xd708('0x6b'))][(_0xd708('0x6c'))](_0xd708('0x6d'),0x193);}_0x2af7d3=_0x2df880;return db['AnalyticMetric'][_0xd708('0x48')]({'raw':!![]});}return null;})[_0xd708('0x28')](function(_0x52e2b5){if(_0x52e2b5){_0x5d30ad=_['keyBy'](_0x52e2b5,'id');var _0x570cea;var _0x106af3=squel[_0xd708('0x70')]();_0x106af3['from'](_0x130d1e['table']);for(var _0x212ed9=0x0;_0x212ed9<_0x2af7d3[_0xd708('0x3c')];_0x212ed9+=0x1){_0x570cea=_0x2af7d3[_0x212ed9]['MetricId']?_0x5d30ad[_0x2af7d3[_0x212ed9][_0xd708('0x73')]]['metric']:_0x2af7d3[_0x212ed9]['field'];_0x570cea=_0x2af7d3[_0x212ed9]['function']?_['replace'](_0x3b0060[_0x2af7d3[_0x212ed9][_0xd708('0xa8')]],'%s',_0x570cea):_0x570cea;_0x570cea=_0x2af7d3[_0x212ed9]['format']?_[_0xd708('0x75')](_0x512b2e[_0x2af7d3[_0x212ed9][_0xd708('0x76')]],'%s',_0x570cea):_0x570cea;if(_0x2af7d3[_0x212ed9]['groupBy']){_0x106af3[_0xd708('0x68')](_0x570cea);}_0x2af7d3[_0x212ed9][_0xd708('0x78')]&&_0x106af3[_0xd708('0x79')](_0x570cea,_0x2af7d3[_0x212ed9][_0xd708('0x78')]===_0xd708('0x7a')?![]:!![]);_0x106af3[_0xd708('0x74')](_0x570cea,_0x2af7d3[_0x212ed9]['alias']||_0x570cea);}if(_0x130d1e[_0xd708('0x7c')]){_0x130d1e[_0xd708('0x7c')]=JSON['parse'](_0x130d1e[_0xd708('0x7c')]);for(var _0x4f91e0=0x0;_0x4f91e0<_0x130d1e[_0xd708('0x7c')]['length'];_0x4f91e0+=0x1){if(_0x130d1e[_0xd708('0x7c')][_0x4f91e0][_0xd708('0x34')]&&_[_0xd708('0x8b')](_0x3db9aa,_0x130d1e[_0xd708('0x7c')][_0x4f91e0][_0xd708('0x34')])&&_0x130d1e[_0xd708('0x7c')][_0x4f91e0]['parentKey']&&_0x130d1e[_0xd708('0x7c')][_0x4f91e0][_0xd708('0x7f')]&&_0x130d1e['joins'][_0x4f91e0][_0xd708('0x80')]){_0x106af3[_0x130d1e[_0xd708('0x7c')][_0x4f91e0][_0xd708('0x34')]](_0x130d1e['joins'][_0x4f91e0][_0xd708('0x7f')],null,util[_0xd708('0x76')](_0xd708('0xa9'),_0x130d1e['table'],_0x130d1e[_0xd708('0x7c')][_0x4f91e0][_0xd708('0x7e')],_0x130d1e[_0xd708('0x7c')][_0x4f91e0][_0xd708('0x7f')],_0x130d1e[_0xd708('0x7c')][_0x4f91e0][_0xd708('0x80')]));}}}if(_0x130d1e[_0xd708('0x81')]){_0x130d1e[_0xd708('0x81')]=JSON[_0xd708('0x7d')](_0x130d1e['conditions']);_0x106af3[_0xd708('0x40')](_0x333058(_0x130d1e[_0xd708('0x81')][_0xd708('0x68')]));}_0x4d9e74=_0x106af3[_0xd708('0x82')]();_0x106af3[_0xd708('0x22')](_0x5f2768);_0x106af3[_0xd708('0x21')](0x0);logger['debug'](_0xd708('0x84'),_0x106af3[_0xd708('0x85')]());return dbH[_0xd708('0x86')][_0xd708('0x37')](_0x106af3[_0xd708('0x85')](),{'type':dbH[_0xd708('0x86')]['QueryTypes']['SELECT']});}})[_0xd708('0x28')](function(){return{'sql':_0x4d9e74['toString']()};})[_0xd708('0x28')](respondWithResult(_0x5d30e6,null))['catch'](handleError(_0x5d30e6,null));};
\ No newline at end of file
+var _0x5554=['fields','attributes','hasOwnProperty','nolimit','limit','sort','where','filter','merge','options','count','includeAll','include','findAll','rows','show','params','length','catch','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','UserProfileSection','find','userProfileId','autoAssociation','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','preview','join','left_join','cross_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','DATE(%s)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20NOT\x20EMPTY','rules','operator','group','condition','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','keyBy','from','MetricId','metric','field','function','replace','orderBy','order','DESC','alias','joins','parse','foreignTable','format','%s.%s\x20=\x20%s.%s','table','parentKey','foreignKey','conditions','clone','debug','toString','sequelize','SELECT','right_join','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','AnalyticMetric','output','web','fullPath','%s-%s.%s','randomstring','generate','csv','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','info','Run\x20Query:','child_process','fork','../../components/export/','savename','select','countTable','COUNT(*)','QueryTypes','run','IS\x20EMPTY','value','groupBy','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','util','path','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','dbH','status','end','json','offset','undefined','set','Content-Range','apply','reject','save','update','then','destroy','get','CustomReports','UserProfileResource','sendStatus','stack','name','map','AnalyticCustomReport','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection'];(function(_0x9c173a,_0x461c9c){var _0x88d611=function(_0x4900c7){while(--_0x4900c7){_0x9c173a['push'](_0x9c173a['shift']());}};_0x88d611(++_0x461c9c);}(_0x5554,0x70));var _0x4555=function(_0x139a3c,_0x4fc883){_0x139a3c=_0x139a3c-0x0;var _0x2b375b=_0x5554[_0x139a3c];return _0x2b375b;};'use strict';var emlformat=require(_0x4555('0x0'));var rimraf=require(_0x4555('0x1'));var zipdir=require(_0x4555('0x2'));var jsonpatch=require(_0x4555('0x3'));var rp=require(_0x4555('0x4'));var moment=require('moment');var BPromise=require(_0x4555('0x5'));var Mustache=require('mustache');var util=require(_0x4555('0x6'));var path=require(_0x4555('0x7'));var sox=require('sox');var csv=require(_0x4555('0x8'));var ejs=require(_0x4555('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x4555('0xa'));var squel=require(_0x4555('0xb'));var crypto=require(_0x4555('0xc'));var jsforce=require(_0x4555('0xd'));var deskjs=require(_0x4555('0xe'));var toCsv=require(_0x4555('0x8'));var querystring=require(_0x4555('0xf'));var Papa=require(_0x4555('0x10'));var Redis=require(_0x4555('0x11'));var authService=require('../../components/auth/service');var qs=require(_0x4555('0x12'));var as=require(_0x4555('0x13'));var hardwareService=require(_0x4555('0x14'));var logger=require(_0x4555('0x15'))('api');var utils=require(_0x4555('0x16'));var config=require(_0x4555('0x17'));var licenseUtil=require(_0x4555('0x18'));var db=require(_0x4555('0x19'))['db'];var dbH=require('../../mysqldb')[_0x4555('0x1a')];function respondWithStatusCode(_0x252d8e,_0x3176cd){_0x3176cd=_0x3176cd||0xcc;return function(_0x5b90e1){if(_0x5b90e1){return _0x252d8e['sendStatus'](_0x3176cd);}return _0x252d8e[_0x4555('0x1b')](_0x3176cd)[_0x4555('0x1c')]();};}function respondWithResult(_0x37ca01,_0x2ce7d1){_0x2ce7d1=_0x2ce7d1||0xc8;return function(_0x345b35){if(_0x345b35){return _0x37ca01[_0x4555('0x1b')](_0x2ce7d1)[_0x4555('0x1d')](_0x345b35);}};}function respondWithFilteredResult(_0x105429,_0x3cb791){return function(_0x5618f6){if(_0x5618f6){var _0x370016=typeof _0x3cb791[_0x4555('0x1e')]==='undefined'&&typeof _0x3cb791['limit']===_0x4555('0x1f');var _0x5d618f=_0x5618f6['count'];var _0x3f571c=_0x370016?0x0:_0x3cb791['offset'];var _0x498914=_0x370016?_0x5618f6['count']:_0x3cb791[_0x4555('0x1e')]+_0x3cb791['limit'];var _0x1573ca;if(_0x498914>=_0x5d618f){_0x498914=_0x5d618f;_0x1573ca=0xc8;}else{_0x1573ca=0xce;}_0x105429['status'](_0x1573ca);return _0x105429[_0x4555('0x20')](_0x4555('0x21'),_0x3f571c+'-'+_0x498914+'/'+_0x5d618f)[_0x4555('0x1d')](_0x5618f6);}return null;};}function patchUpdates(_0x3d43ac){return function(_0x2bdd9c){try{jsonpatch[_0x4555('0x22')](_0x2bdd9c,_0x3d43ac,!![]);}catch(_0x4d0ad5){return BPromise[_0x4555('0x23')](_0x4d0ad5);}return _0x2bdd9c[_0x4555('0x24')]();};}function saveUpdates(_0x5bb5c3,_0x5e9b5c){return function(_0xb18ff6){if(_0xb18ff6){return _0xb18ff6[_0x4555('0x25')](_0x5bb5c3)[_0x4555('0x26')](function(_0x5170f9){return _0x5170f9;});}return null;};}function removeEntity(_0x4053d6,_0x276b29){return function(_0x2d7b55){if(_0x2d7b55){return _0x2d7b55[_0x4555('0x27')]()[_0x4555('0x26')](function(){var _0x2eb1bc=_0x2d7b55[_0x4555('0x28')]({'plain':!![]});var _0x1dd476=_0x4555('0x29');return db[_0x4555('0x2a')]['destroy']({'where':{'type':_0x1dd476,'resourceId':_0x2eb1bc['id']}})[_0x4555('0x26')](function(){return _0x2d7b55;});})[_0x4555('0x26')](function(){_0x4053d6[_0x4555('0x1b')](0xcc)['end']();});}};}function handleEntityNotFound(_0x3c9627,_0x47a689){return function(_0x28d2ee){if(!_0x28d2ee){_0x3c9627[_0x4555('0x2b')](0x194);}return _0x28d2ee;};}function handleError(_0x337de2,_0x6af5cd){_0x6af5cd=_0x6af5cd||0x1f4;return function(_0x59fcb4){logger['error'](_0x59fcb4[_0x4555('0x2c')]);if(_0x59fcb4['name']){delete _0x59fcb4[_0x4555('0x2d')];}_0x337de2[_0x4555('0x1b')](_0x6af5cd)['send'](_0x59fcb4);};}exports['index']=function(_0x8ba98,_0x17ce60){var _0x56f340={},_0xf9bb24={},_0x560f75={'count':0x0,'rows':[]};var _0x283d1b=_[_0x4555('0x2e')](db[_0x4555('0x2f')][_0x4555('0x30')],function(_0x1b8499){return{'name':_0x1b8499[_0x4555('0x31')],'type':_0x1b8499[_0x4555('0x32')][_0x4555('0x33')]};});_0xf9bb24[_0x4555('0x34')]=_[_0x4555('0x2e')](_0x283d1b,_0x4555('0x2d'));_0xf9bb24[_0x4555('0x35')]=_[_0x4555('0x36')](_0x8ba98[_0x4555('0x35')]);_0xf9bb24[_0x4555('0x37')]=_[_0x4555('0x38')](_0xf9bb24[_0x4555('0x34')],_0xf9bb24['query']);_0x56f340['attributes']=_[_0x4555('0x38')](_0xf9bb24['model'],qs[_0x4555('0x39')](_0x8ba98['query'][_0x4555('0x39')]));_0x56f340[_0x4555('0x3a')]=_0x56f340['attributes']['length']?_0x56f340['attributes']:_0xf9bb24[_0x4555('0x34')];if(!_0x8ba98[_0x4555('0x35')][_0x4555('0x3b')](_0x4555('0x3c'))){_0x56f340['limit']=qs[_0x4555('0x3d')](_0x8ba98[_0x4555('0x35')][_0x4555('0x3d')]);_0x56f340['offset']=qs[_0x4555('0x1e')](_0x8ba98[_0x4555('0x35')][_0x4555('0x1e')]);}_0x56f340['order']=qs[_0x4555('0x3e')](_0x8ba98[_0x4555('0x35')][_0x4555('0x3e')]);_0x56f340[_0x4555('0x3f')]=qs[_0x4555('0x37')](_['pick'](_0x8ba98['query'],_0xf9bb24[_0x4555('0x37')]),_0x283d1b);if(_0x8ba98[_0x4555('0x35')][_0x4555('0x40')]){_0x56f340[_0x4555('0x3f')]=_[_0x4555('0x41')](_0x56f340[_0x4555('0x3f')],{'$or':_[_0x4555('0x2e')](_0x283d1b,function(_0xaaa4df){if(_0xaaa4df[_0x4555('0x32')]!=='VIRTUAL'){var _0x181344={};_0x181344[_0xaaa4df[_0x4555('0x2d')]]={'$like':'%'+_0x8ba98['query'][_0x4555('0x40')]+'%'};return _0x181344;}})});}_0x56f340=_[_0x4555('0x41')]({},_0x56f340,_0x8ba98[_0x4555('0x42')]);var _0x356faa={'where':_0x56f340['where']};return db[_0x4555('0x2f')][_0x4555('0x43')](_0x356faa)[_0x4555('0x26')](function(_0x385b98){_0x560f75[_0x4555('0x43')]=_0x385b98;if(_0x8ba98[_0x4555('0x35')][_0x4555('0x44')]){_0x56f340[_0x4555('0x45')]=[{'all':!![]}];}return db['AnalyticCustomReport'][_0x4555('0x46')](_0x56f340);})[_0x4555('0x26')](function(_0x2d3242){_0x560f75[_0x4555('0x47')]=_0x2d3242;return _0x560f75;})[_0x4555('0x26')](respondWithFilteredResult(_0x17ce60,_0x56f340))['catch'](handleError(_0x17ce60,null));};exports[_0x4555('0x48')]=function(_0x517752,_0x54355c){var _0x1d207e={'raw':![],'where':{'id':_0x517752[_0x4555('0x49')]['id']}},_0x4ae09c={};_0x4ae09c['model']=_[_0x4555('0x36')](db['AnalyticCustomReport'][_0x4555('0x30')]);_0x4ae09c['query']=_['keys'](_0x517752[_0x4555('0x35')]);_0x4ae09c[_0x4555('0x37')]=_['intersection'](_0x4ae09c['model'],_0x4ae09c[_0x4555('0x35')]);_0x1d207e[_0x4555('0x3a')]=_['intersection'](_0x4ae09c[_0x4555('0x34')],qs[_0x4555('0x39')](_0x517752[_0x4555('0x35')]['fields']));_0x1d207e[_0x4555('0x3a')]=_0x1d207e[_0x4555('0x3a')][_0x4555('0x4a')]?_0x1d207e[_0x4555('0x3a')]:_0x4ae09c[_0x4555('0x34')];if(_0x517752[_0x4555('0x35')][_0x4555('0x44')]){_0x1d207e[_0x4555('0x45')]=[{'all':!![]}];}_0x1d207e=_['merge']({},_0x1d207e,_0x517752[_0x4555('0x42')]);return db[_0x4555('0x2f')]['find'](_0x1d207e)[_0x4555('0x26')](handleEntityNotFound(_0x54355c,null))['then'](respondWithResult(_0x54355c,null))[_0x4555('0x4b')](handleError(_0x54355c,null));};exports[_0x4555('0x4c')]=function(_0x460ebc,_0x2918ac){return db['AnalyticCustomReport'][_0x4555('0x4c')](_0x460ebc[_0x4555('0x4d')],{})[_0x4555('0x26')](function(_0x3474c0){var _0xa95828=_0x460ebc['user'][_0x4555('0x28')]({'plain':!![]});if(!_0xa95828)throw new Error(_0x4555('0x4e'));if(_0xa95828[_0x4555('0x4f')]==='user'){var _0x146cbb=_0x3474c0[_0x4555('0x28')]({'plain':!![]});var _0x55e135=_0x4555('0x50');return db[_0x4555('0x51')][_0x4555('0x52')]({'where':{'name':_0x55e135,'userProfileId':_0xa95828[_0x4555('0x53')]},'raw':!![]})['then'](function(_0x40c14d){if(_0x40c14d&&_0x40c14d[_0x4555('0x54')]===0x0){return db[_0x4555('0x2a')][_0x4555('0x4c')]({'name':_0x146cbb[_0x4555('0x2d')],'resourceId':_0x146cbb['id'],'type':_0x4555('0x29'),'sectionId':_0x40c14d['id']},{})[_0x4555('0x26')](function(){return _0x3474c0;});}else{return _0x3474c0;}})[_0x4555('0x4b')](function(_0x5afc03){logger[_0x4555('0x55')](_0x4555('0x56'),_0x5afc03);throw _0x5afc03;});}return _0x3474c0;})['then'](respondWithResult(_0x2918ac,0xc9))[_0x4555('0x4b')](handleError(_0x2918ac,null));};exports[_0x4555('0x25')]=function(_0x2be64b,_0x5d908f){if(_0x2be64b[_0x4555('0x4d')]['id']){delete _0x2be64b[_0x4555('0x4d')]['id'];}return db[_0x4555('0x2f')][_0x4555('0x52')]({'where':{'id':_0x2be64b[_0x4555('0x49')]['id']}})['then'](handleEntityNotFound(_0x5d908f,null))[_0x4555('0x26')](saveUpdates(_0x2be64b[_0x4555('0x4d')],null))[_0x4555('0x26')](respondWithResult(_0x5d908f,null))[_0x4555('0x4b')](handleError(_0x5d908f,null));};exports[_0x4555('0x27')]=function(_0x5bd5b6,_0x4666b4){return db[_0x4555('0x2f')]['find']({'where':{'id':_0x5bd5b6[_0x4555('0x49')]['id']}})['then'](handleEntityNotFound(_0x4666b4,null))['then'](removeEntity(_0x4666b4,null))[_0x4555('0x4b')](handleError(_0x4666b4,null));};exports[_0x4555('0x57')]=function(_0x35c17f,_0x11c744){var _0x37fa01=0xa;var _0x30b645=[_0x4555('0x58'),_0x4555('0x59'),'right_join',_0x4555('0x5a')];var _0x51351b={'SUM':_0x4555('0x5b'),'COUNT':_0x4555('0x5c'),'COUNT DISTINCT':_0x4555('0x5d'),'MAX':_0x4555('0x5e'),'MIN':_0x4555('0x5f'),'AVG':_0x4555('0x60'),'GROUP_CONCAT':_0x4555('0x61'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0x4555('0x62')};var _0x3b7050={'SEC_TO_TIME':_0x4555('0x63'),'DATE':_0x4555('0x64'),'HOUR':_0x4555('0x65'),'ROUND':_0x4555('0x66'),'UNIX_TIMESTAMP':_0x4555('0x67')};var _0x33f6ad=function(_0x386013){return!_[_0x4555('0x68')]([_0x4555('0x69'),_0x4555('0x6a'),'IS\x20EMPTY',_0x4555('0x6b')],_0x386013);};var _0x32e65b=function(_0x297268){if(!_0x297268||!_0x297268[_0x4555('0x6c')]['length']){return'';}for(var _0x24eee3='(',_0x28cd1c=0x0;_0x28cd1c<_0x297268['rules']['length'];_0x28cd1c+=0x1){_0x28cd1c>0x0&&(_0x24eee3+='\x20'+_0x297268[_0x4555('0x6d')]+'\x20');_0x24eee3+=_0x297268[_0x4555('0x6c')][_0x28cd1c][_0x4555('0x6e')]?_0x32e65b(_0x297268['rules'][_0x28cd1c]['group']):_0x297268[_0x4555('0x6c')][_0x28cd1c]['field']+'\x20'+_0x297268[_0x4555('0x6c')][_0x28cd1c]['condition']+(_0x33f6ad(_0x297268[_0x4555('0x6c')][_0x28cd1c][_0x4555('0x6f')])?'\x20'+_0x297268[_0x4555('0x6c')][_0x28cd1c]['value']:'');}return _0x24eee3+')';};var _0x5dd139={'where':{'id':_0x35c17f['params']['id']}},_0x104b62,_0x75923f,_0x16e93b,_0x5d6fd6,_0x202367;_0x5dd139=_['merge']({},_0x5dd139,_0x35c17f[_0x4555('0x42')]);return db[_0x4555('0x2f')][_0x4555('0x52')](_0x5dd139)[_0x4555('0x26')](function(_0x5bd729){if(_0x5bd729){_0x104b62=_0x5bd729;return _0x5bd729[_0x4555('0x70')]();}return null;})[_0x4555('0x26')](function(_0x3c1250){if(_0x3c1250){if(!_0x3c1250[_0x4555('0x4a')]){throw new db[(_0x4555('0x71'))][(_0x4555('0x72'))](_0x4555('0x73'),0x193);}_0x75923f=_0x3c1250;return db['AnalyticMetric'][_0x4555('0x46')]({'raw':!![]});}return null;})[_0x4555('0x26')](function(_0x1c7dd6){if(_0x1c7dd6){_0x16e93b=_[_0x4555('0x74')](_0x1c7dd6,'id');var _0x48b277;var _0x2c0ace=squel['select']();_0x2c0ace[_0x4555('0x75')](_0x104b62['table']);for(var _0x5e9635=0x0;_0x5e9635<_0x75923f[_0x4555('0x4a')];_0x5e9635+=0x1){_0x48b277=_0x75923f[_0x5e9635][_0x4555('0x76')]?_0x16e93b[_0x75923f[_0x5e9635][_0x4555('0x76')]][_0x4555('0x77')]:_0x75923f[_0x5e9635][_0x4555('0x78')];_0x48b277=_0x75923f[_0x5e9635][_0x4555('0x79')]?_['replace'](_0x51351b[_0x75923f[_0x5e9635][_0x4555('0x79')]],'%s',_0x48b277):_0x48b277;_0x48b277=_0x75923f[_0x5e9635]['format']?_[_0x4555('0x7a')](_0x3b7050[_0x75923f[_0x5e9635]['format']],'%s',_0x48b277):_0x48b277;if(_0x75923f[_0x5e9635]['groupBy']){_0x2c0ace[_0x4555('0x6e')](_0x48b277);}_0x75923f[_0x5e9635][_0x4555('0x7b')]&&_0x2c0ace[_0x4555('0x7c')](_0x48b277,_0x75923f[_0x5e9635]['orderBy']===_0x4555('0x7d')?![]:!![]);_0x2c0ace[_0x4555('0x78')](_0x48b277,_0x75923f[_0x5e9635][_0x4555('0x7e')]||_0x48b277);}if(_0x104b62[_0x4555('0x7f')]){_0x104b62['joins']=JSON[_0x4555('0x80')](_0x104b62['joins']);for(var _0x2fec54=0x0;_0x2fec54<_0x104b62['joins']['length'];_0x2fec54+=0x1){if(_0x104b62['joins'][_0x2fec54][_0x4555('0x32')]&&_[_0x4555('0x68')](_0x30b645,_0x104b62[_0x4555('0x7f')][_0x2fec54]['type'])&&_0x104b62[_0x4555('0x7f')][_0x2fec54]['parentKey']&&_0x104b62[_0x4555('0x7f')][_0x2fec54][_0x4555('0x81')]&&_0x104b62[_0x4555('0x7f')][_0x2fec54]['foreignKey']){_0x2c0ace[_0x104b62['joins'][_0x2fec54][_0x4555('0x32')]](_0x104b62[_0x4555('0x7f')][_0x2fec54]['foreignTable'],null,util[_0x4555('0x82')](_0x4555('0x83'),_0x104b62[_0x4555('0x84')],_0x104b62[_0x4555('0x7f')][_0x2fec54][_0x4555('0x85')],_0x104b62[_0x4555('0x7f')][_0x2fec54][_0x4555('0x81')],_0x104b62[_0x4555('0x7f')][_0x2fec54][_0x4555('0x86')]));}}}if(_0x104b62[_0x4555('0x87')]){_0x104b62[_0x4555('0x87')]=JSON[_0x4555('0x80')](_0x104b62['conditions']);_0x2c0ace[_0x4555('0x3f')](_0x32e65b(_0x104b62[_0x4555('0x87')][_0x4555('0x6e')]));}_0x202367=_0x2c0ace[_0x4555('0x88')]();_0x2c0ace[_0x4555('0x3d')](_0x37fa01);_0x2c0ace['offset'](0x0);logger[_0x4555('0x89')]('Limited\x20Query:',_0x2c0ace['toString']());return dbH['sequelize'][_0x4555('0x35')](_0x2c0ace[_0x4555('0x8a')](),{'type':dbH[_0x4555('0x8b')]['QueryTypes'][_0x4555('0x8c')]});}})[_0x4555('0x26')](respondWithResult(_0x11c744,null))[_0x4555('0x4b')](handleError(_0x11c744,null));};function runReport(_0x16daab,_0xc3e9bf,_0x1e3a55){var _0x5bd8f1=_0xc3e9bf[_0x4555('0x2d')];var _0x5653ce=0xa;var _0x2b068d=[_0x4555('0x58'),'left_join',_0x4555('0x8d'),'cross_join'];var _0x4772f3={'SUM':_0x4555('0x5b'),'COUNT':_0x4555('0x5c'),'COUNT DISTINCT':_0x4555('0x5d'),'MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':_0x4555('0x60'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x4555('0x8e'),'GROUP_CONCAT DESC':_0x4555('0x62')};var _0x40cef0={'SEC_TO_TIME':_0x4555('0x63'),'DATE':_0x4555('0x64'),'HOUR':_0x4555('0x65'),'ROUND':_0x4555('0x66'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x26e695=function(_0x22eba6){return!_['includes']([_0x4555('0x69'),_0x4555('0x6a'),'IS\x20EMPTY',_0x4555('0x6b')],_0x22eba6);};var _0x5607a1=function(_0x1b91f7){if(!_0x1b91f7||!_0x1b91f7[_0x4555('0x6c')][_0x4555('0x4a')]){return'';}for(var _0x1bc5df='(',_0x51af5a=0x0;_0x51af5a<_0x1b91f7[_0x4555('0x6c')][_0x4555('0x4a')];_0x51af5a+=0x1){_0x51af5a>0x0&&(_0x1bc5df+='\x20'+_0x1b91f7[_0x4555('0x6d')]+'\x20');_0x1bc5df+=_0x1b91f7[_0x4555('0x6c')][_0x51af5a][_0x4555('0x6e')]?_0x5607a1(_0x1b91f7[_0x4555('0x6c')][_0x51af5a][_0x4555('0x6e')]):_0x1b91f7[_0x4555('0x6c')][_0x51af5a]['field']+'\x20'+_0x1b91f7[_0x4555('0x6c')][_0x51af5a][_0x4555('0x6f')]+(_0x26e695(_0x1b91f7['rules'][_0x51af5a]['condition'])?'\x20'+_0x1b91f7[_0x4555('0x6c')][_0x51af5a]['value']:'');}return _0x1bc5df+')';};var _0x4503a8={'where':{'id':_0x16daab['id']}},_0x392e41,_0x23d762,_0x1ee0c8,_0x45f782,_0x5228c0;_0x4503a8=_[_0x4555('0x41')]({},_0x4503a8,_0x1e3a55);return db['AnalyticCustomReport'][_0x4555('0x52')](_0x4503a8)['then'](function(_0x4b0c2a){if(_0x4b0c2a){_0x392e41=_0x4b0c2a;return _0x4b0c2a['getFields']();}return null;})['then'](function(_0x35bad8){if(_0x35bad8){if(!_0x35bad8[_0x4555('0x4a')]){throw new db[(_0x4555('0x71'))][(_0x4555('0x72'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x23d762=_0x35bad8;return db[_0x4555('0x8f')][_0x4555('0x46')]({'raw':!![]});}return null;})[_0x4555('0x26')](function(_0x5d1d26){if(_0x5d1d26){_0x1ee0c8=_['keyBy'](_0x5d1d26,'id');var _0x5823db;var _0x2fb914=squel['select']();_0x2fb914[_0x4555('0x75')](_0x392e41[_0x4555('0x84')]);for(var _0x1e7443=0x0;_0x1e7443<_0x23d762[_0x4555('0x4a')];_0x1e7443+=0x1){_0x5823db=_0x23d762[_0x1e7443][_0x4555('0x76')]?_0x1ee0c8[_0x23d762[_0x1e7443][_0x4555('0x76')]][_0x4555('0x77')]:_0x23d762[_0x1e7443]['field'];_0x5823db=_0x23d762[_0x1e7443][_0x4555('0x79')]?_[_0x4555('0x7a')](_0x4772f3[_0x23d762[_0x1e7443][_0x4555('0x79')]],'%s',_0x5823db):_0x5823db;_0x5823db=_0x23d762[_0x1e7443][_0x4555('0x82')]?_[_0x4555('0x7a')](_0x40cef0[_0x23d762[_0x1e7443]['format']],'%s',_0x5823db):_0x5823db;if(_0x23d762[_0x1e7443]['groupBy']){_0x2fb914[_0x4555('0x6e')](_0x5823db);}_0x23d762[_0x1e7443][_0x4555('0x7b')]&&_0x2fb914[_0x4555('0x7c')](_0x5823db,_0x23d762[_0x1e7443]['orderBy']==='DESC'?![]:!![]);_0x2fb914[_0x4555('0x78')](_0x5823db,_0x23d762[_0x1e7443][_0x4555('0x7e')]||_0x5823db);}if(_0x392e41[_0x4555('0x7f')]){_0x392e41[_0x4555('0x7f')]=JSON[_0x4555('0x80')](_0x392e41['joins']);for(var _0x523744=0x0;_0x523744<_0x392e41['joins'][_0x4555('0x4a')];_0x523744+=0x1){if(_0x392e41['joins'][_0x523744][_0x4555('0x32')]&&_[_0x4555('0x68')](_0x2b068d,_0x392e41[_0x4555('0x7f')][_0x523744]['type'])&&_0x392e41[_0x4555('0x7f')][_0x523744]['parentKey']&&_0x392e41['joins'][_0x523744][_0x4555('0x81')]&&_0x392e41[_0x4555('0x7f')][_0x523744][_0x4555('0x86')]){_0x2fb914[_0x392e41[_0x4555('0x7f')][_0x523744][_0x4555('0x32')]](_0x392e41[_0x4555('0x7f')][_0x523744][_0x4555('0x81')],null,util[_0x4555('0x82')](_0x4555('0x83'),_0x392e41[_0x4555('0x84')],_0x392e41[_0x4555('0x7f')][_0x523744]['parentKey'],_0x392e41[_0x4555('0x7f')][_0x523744][_0x4555('0x81')],_0x392e41[_0x4555('0x7f')][_0x523744][_0x4555('0x86')]));}}}if(_0x392e41[_0x4555('0x87')]){_0x392e41[_0x4555('0x87')]=JSON[_0x4555('0x80')](_0x392e41[_0x4555('0x87')]);_0x2fb914['where'](_0x5607a1(_0x392e41[_0x4555('0x87')][_0x4555('0x6e')]));}_0x5228c0=_0x2fb914[_0x4555('0x88')]();_0x2fb914[_0x4555('0x3d')](_0x5653ce);_0x2fb914[_0x4555('0x1e')](0x0);return;}})[_0x4555('0x26')](function(){if(_0xc3e9bf[_0x4555('0x90')]===_0x4555('0x91')){return null;}var _0x279a92=_[_0x4555('0x41')](_0xc3e9bf,{'name':_0xc3e9bf[_0x4555('0x92')]||_0xc3e9bf[_0x4555('0x2d')]||_0x392e41[_0x4555('0x2d')],'basename':_0x5bd8f1,'savename':util[_0x4555('0x82')](_0x4555('0x93'),_0xc3e9bf[_0x4555('0x2d')]||_0x392e41[_0x4555('0x2d')],require(_0x4555('0x94'))[_0x4555('0x95')](0x4),_0xc3e9bf[_0x4555('0x90')]||_0x4555('0x96')),'reportId':_0x392e41['id'],'reportType':'custom'});return db['AnalyticExtractedReport'][_0x4555('0x4c')](_0x279a92,{'raw':!![]});})[_0x4555('0x26')](function(_0x233a11){if(_0x392e41[_0x4555('0x84')]===_0x4555('0x97')){_0x5228c0[_0x4555('0x3f')](_0x392e41[_0x4555('0x84')]+_0x4555('0x98'),_0xc3e9bf[_0x4555('0x99')],_0xc3e9bf[_0x4555('0x9a')]);}else{_0x5228c0[_0x4555('0x3f')](_0x392e41[_0x4555('0x84')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0xc3e9bf[_0x4555('0x99')],_0xc3e9bf[_0x4555('0x9a')]);}if(_0x233a11){logger[_0x4555('0x9b')](_0x4555('0x9c'),_0x5228c0['toString']());require(_0x4555('0x9d'))[_0x4555('0x9e')](path[_0x4555('0x58')](__dirname,_0x4555('0x9f'),_0x233a11['output']),[_0x233a11['id'],_0x5228c0['toString'](),path[_0x4555('0x58')](__dirname,'../../files/reports',_0x233a11[_0x4555('0xa0')]),_0x5bd8f1]);return _0x233a11;}else{var _0x28caa8=squel[_0x4555('0xa1')]();_0x28caa8[_0x4555('0x75')]('('+_0x5228c0['toString']()+')',_0x4555('0xa2'));_0x28caa8[_0x4555('0x78')](_0x4555('0xa3'),_0x4555('0x43'));_0x5228c0[_0x4555('0x3d')](_0xc3e9bf[_0x4555('0x3d')]||_0x5653ce);_0x5228c0[_0x4555('0x1e')](_0xc3e9bf['offset']||0x0);return dbH[_0x4555('0x8b')][_0x4555('0x35')](_0x28caa8[_0x4555('0x8a')](),{'type':dbH[_0x4555('0x8b')][_0x4555('0xa4')][_0x4555('0x8c')]})[_0x4555('0x26')](function(_0x22946e){if(!_0x22946e[_0x4555('0x4a')]){_0x45f782=0x0;}else{_0x45f782=_0x22946e[0x0][_0x4555('0x43')]||0x0;}return dbH[_0x4555('0x8b')]['query'](_0x5228c0[_0x4555('0x8a')](),{'type':dbH['sequelize']['QueryTypes']['SELECT']});})[_0x4555('0x26')](function(_0x5ec227){return{'rows':_0x5ec227||[],'count':_0x45f782};});}});}exports[_0x4555('0xa5')]=function(_0x2d0b8f,_0x3ddb47){return runReport(_0x2d0b8f[_0x4555('0x49')],_0x2d0b8f[_0x4555('0x35')],_0x2d0b8f[_0x4555('0x42')])[_0x4555('0x26')](respondWithResult(_0x3ddb47,null))['catch'](handleError(_0x3ddb47,null));};exports['runReport']=runReport;exports['query']=function(_0x57674a,_0x52c76f){var _0x5eb19d=0xa;var _0x4b9472=[_0x4555('0x58'),_0x4555('0x59'),_0x4555('0x8d'),_0x4555('0x5a')];var _0x528b55={'SUM':_0x4555('0x5b'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x4555('0x5d'),'MAX':_0x4555('0x5e'),'MIN':_0x4555('0x5f'),'AVG':'AVG(%s)','GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x4555('0x8e'),'GROUP_CONCAT DESC':_0x4555('0x62')};var _0x32db47={'SEC_TO_TIME':_0x4555('0x63'),'DATE':_0x4555('0x64'),'HOUR':_0x4555('0x65'),'ROUND':_0x4555('0x66'),'UNIX_TIMESTAMP':_0x4555('0x67')};var _0x585f10=function(_0x3059bc){return!_['includes'](['IS\x20NULL',_0x4555('0x6a'),_0x4555('0xa6'),_0x4555('0x6b')],_0x3059bc);};var _0x38bb7e=function(_0x781db5){if(!_0x781db5||!_0x781db5[_0x4555('0x6c')][_0x4555('0x4a')]){return'';}for(var _0x7fdb6a='(',_0x3b3f90=0x0;_0x3b3f90<_0x781db5[_0x4555('0x6c')][_0x4555('0x4a')];_0x3b3f90+=0x1){_0x3b3f90>0x0&&(_0x7fdb6a+='\x20'+_0x781db5[_0x4555('0x6d')]+'\x20');_0x7fdb6a+=_0x781db5['rules'][_0x3b3f90]['group']?_0x38bb7e(_0x781db5['rules'][_0x3b3f90][_0x4555('0x6e')]):_0x781db5[_0x4555('0x6c')][_0x3b3f90][_0x4555('0x78')]+'\x20'+_0x781db5['rules'][_0x3b3f90][_0x4555('0x6f')]+(_0x585f10(_0x781db5[_0x4555('0x6c')][_0x3b3f90][_0x4555('0x6f')])?'\x20'+_0x781db5['rules'][_0x3b3f90][_0x4555('0xa7')]:'');}return _0x7fdb6a+')';};var _0x154681={'where':{'id':_0x57674a[_0x4555('0x49')]['id']}},_0x5ea282,_0x1a26f7,_0x39b03b,_0x1afbec,_0x33f482;_0x154681=_['merge']({},_0x154681,_0x57674a['options']);return db[_0x4555('0x2f')][_0x4555('0x52')](_0x154681)['then'](function(_0xc0441){if(_0xc0441){_0x5ea282=_0xc0441;return _0xc0441[_0x4555('0x70')]();}return null;})[_0x4555('0x26')](function(_0x57cc43){if(_0x57cc43){if(!_0x57cc43[_0x4555('0x4a')]){throw new db[(_0x4555('0x71'))][(_0x4555('0x72'))](_0x4555('0x73'),0x193);}_0x1a26f7=_0x57cc43;return db[_0x4555('0x8f')]['findAll']({'raw':!![]});}return null;})[_0x4555('0x26')](function(_0x281362){if(_0x281362){_0x39b03b=_['keyBy'](_0x281362,'id');var _0x4d4dc4;var _0x412fe8=squel[_0x4555('0xa1')]();_0x412fe8[_0x4555('0x75')](_0x5ea282[_0x4555('0x84')]);for(var _0x1ff167=0x0;_0x1ff167<_0x1a26f7[_0x4555('0x4a')];_0x1ff167+=0x1){_0x4d4dc4=_0x1a26f7[_0x1ff167][_0x4555('0x76')]?_0x39b03b[_0x1a26f7[_0x1ff167]['MetricId']]['metric']:_0x1a26f7[_0x1ff167]['field'];_0x4d4dc4=_0x1a26f7[_0x1ff167]['function']?_['replace'](_0x528b55[_0x1a26f7[_0x1ff167][_0x4555('0x79')]],'%s',_0x4d4dc4):_0x4d4dc4;_0x4d4dc4=_0x1a26f7[_0x1ff167][_0x4555('0x82')]?_['replace'](_0x32db47[_0x1a26f7[_0x1ff167][_0x4555('0x82')]],'%s',_0x4d4dc4):_0x4d4dc4;if(_0x1a26f7[_0x1ff167][_0x4555('0xa8')]){_0x412fe8[_0x4555('0x6e')](_0x4d4dc4);}_0x1a26f7[_0x1ff167][_0x4555('0x7b')]&&_0x412fe8[_0x4555('0x7c')](_0x4d4dc4,_0x1a26f7[_0x1ff167][_0x4555('0x7b')]==='DESC'?![]:!![]);_0x412fe8[_0x4555('0x78')](_0x4d4dc4,_0x1a26f7[_0x1ff167][_0x4555('0x7e')]||_0x4d4dc4);}if(_0x5ea282[_0x4555('0x7f')]){_0x5ea282['joins']=JSON[_0x4555('0x80')](_0x5ea282[_0x4555('0x7f')]);for(var _0x227959=0x0;_0x227959<_0x5ea282['joins'][_0x4555('0x4a')];_0x227959+=0x1){if(_0x5ea282[_0x4555('0x7f')][_0x227959]['type']&&_[_0x4555('0x68')](_0x4b9472,_0x5ea282[_0x4555('0x7f')][_0x227959]['type'])&&_0x5ea282[_0x4555('0x7f')][_0x227959][_0x4555('0x85')]&&_0x5ea282[_0x4555('0x7f')][_0x227959][_0x4555('0x81')]&&_0x5ea282['joins'][_0x227959]['foreignKey']){_0x412fe8[_0x5ea282['joins'][_0x227959][_0x4555('0x32')]](_0x5ea282[_0x4555('0x7f')][_0x227959][_0x4555('0x81')],null,util[_0x4555('0x82')](_0x4555('0x83'),_0x5ea282['table'],_0x5ea282[_0x4555('0x7f')][_0x227959][_0x4555('0x85')],_0x5ea282['joins'][_0x227959]['foreignTable'],_0x5ea282[_0x4555('0x7f')][_0x227959][_0x4555('0x86')]));}}}if(_0x5ea282[_0x4555('0x87')]){_0x5ea282[_0x4555('0x87')]=JSON[_0x4555('0x80')](_0x5ea282[_0x4555('0x87')]);_0x412fe8[_0x4555('0x3f')](_0x38bb7e(_0x5ea282[_0x4555('0x87')][_0x4555('0x6e')]));}_0x33f482=_0x412fe8[_0x4555('0x88')]();_0x412fe8['limit'](_0x5eb19d);_0x412fe8['offset'](0x0);logger[_0x4555('0x89')]('Limited\x20Query:',_0x412fe8[_0x4555('0x8a')]());return dbH[_0x4555('0x8b')][_0x4555('0x35')](_0x412fe8[_0x4555('0x8a')](),{'type':dbH[_0x4555('0x8b')][_0x4555('0xa4')][_0x4555('0x8c')]});}})['then'](function(){return{'sql':_0x33f482[_0x4555('0x8a')]()};})[_0x4555('0x26')](respondWithResult(_0x52c76f,null))[_0x4555('0x4b')](handleError(_0x52c76f,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff