// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x8a6d=['value','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','findAll','keyBy','from','table','MetricId','metric','field','format','replace','groupBy','orderBy','DESC','alias','joins','parse','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','conditions','clone','debug','sequelize','toString','QueryTypes','SELECT','join','COUNT(%s)','select','function','output','web','fullPath','%s-%s.%s','generate','csv','custom','cdr','startDate','endDate','Run\x20Query:','child_process','fork','../../components/export/','../../files/reports','savename','countTable','COUNT(*)','count','run','runReport','Limited\x20Query:','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','dbH','sendStatus','status','end','offset','undefined','limit','set','Content-Range','json','apply','save','then','destroy','get','CustomReports','UserProfileResource','error','stack','name','send','index','map','AnalyticCustomReport','rawAttributes','fieldName','key','model','query','keys','filters','intersection','fields','attributes','hasOwnProperty','nolimit','order','sort','filter','merge','where','type','VIRTUAL','options','includeAll','include','rows','catch','params','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','body','preview','left_join','right_join','cross_join','SUM(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','DATE(%s)','HOUR(%s)','ROUND(%s)','includes','IS\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','length','rules','operator','group','condition'];(function(_0x376489,_0x9ac1a4){var _0x54d58e=function(_0x15b8b2){while(--_0x15b8b2){_0x376489['push'](_0x376489['shift']());}};_0x54d58e(++_0x9ac1a4);}(_0x8a6d,0xe4));var _0xd8a6=function(_0x4ba5fa,_0x1a936f){_0x4ba5fa=_0x4ba5fa-0x0;var _0x372377=_0x8a6d[_0x4ba5fa];return _0x372377;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xd8a6('0x0'));var zipdir=require(_0xd8a6('0x1'));var jsonpatch=require(_0xd8a6('0x2'));var rp=require(_0xd8a6('0x3'));var moment=require('moment');var BPromise=require(_0xd8a6('0x4'));var Mustache=require(_0xd8a6('0x5'));var util=require(_0xd8a6('0x6'));var path=require('path');var sox=require(_0xd8a6('0x7'));var csv=require(_0xd8a6('0x8'));var ejs=require(_0xd8a6('0x9'));var fs=require('fs');var fs_extra=require(_0xd8a6('0xa'));var _=require(_0xd8a6('0xb'));var squel=require(_0xd8a6('0xc'));var crypto=require(_0xd8a6('0xd'));var jsforce=require(_0xd8a6('0xe'));var deskjs=require(_0xd8a6('0xf'));var toCsv=require(_0xd8a6('0x8'));var querystring=require(_0xd8a6('0x10'));var Papa=require(_0xd8a6('0x11'));var Redis=require('ioredis');var authService=require(_0xd8a6('0x12'));var qs=require(_0xd8a6('0x13'));var as=require(_0xd8a6('0x14'));var hardwareService=require(_0xd8a6('0x15'));var logger=require(_0xd8a6('0x16'))(_0xd8a6('0x17'));var utils=require(_0xd8a6('0x18'));var config=require(_0xd8a6('0x19'));var licenseUtil=require(_0xd8a6('0x1a'));var db=require(_0xd8a6('0x1b'))['db'];var dbH=require(_0xd8a6('0x1b'))[_0xd8a6('0x1c')];function respondWithStatusCode(_0x4391b8,_0x1a2820){_0x1a2820=_0x1a2820||0xcc;return function(_0x2a973d){if(_0x2a973d){return _0x4391b8[_0xd8a6('0x1d')](_0x1a2820);}return _0x4391b8[_0xd8a6('0x1e')](_0x1a2820)[_0xd8a6('0x1f')]();};}function respondWithResult(_0x498d7b,_0x2ff518){_0x2ff518=_0x2ff518||0xc8;return function(_0x1d33a8){if(_0x1d33a8){return _0x498d7b[_0xd8a6('0x1e')](_0x2ff518)['json'](_0x1d33a8);}};}function respondWithFilteredResult(_0x75ed5,_0x2f1965){return function(_0x2c81ee){if(_0x2c81ee){var _0x693fc0=typeof _0x2f1965[_0xd8a6('0x20')]===_0xd8a6('0x21')&&typeof _0x2f1965[_0xd8a6('0x22')]===_0xd8a6('0x21');var _0x19b55e=_0x2c81ee['count'];var _0x43f27d=_0x693fc0?0x0:_0x2f1965[_0xd8a6('0x20')];var _0x51839c=_0x693fc0?_0x2c81ee['count']:_0x2f1965[_0xd8a6('0x20')]+_0x2f1965['limit'];var _0x2284bd;if(_0x51839c>=_0x19b55e){_0x51839c=_0x19b55e;_0x2284bd=0xc8;}else{_0x2284bd=0xce;}_0x75ed5[_0xd8a6('0x1e')](_0x2284bd);return _0x75ed5[_0xd8a6('0x23')](_0xd8a6('0x24'),_0x43f27d+'-'+_0x51839c+'/'+_0x19b55e)[_0xd8a6('0x25')](_0x2c81ee);}return null;};}function patchUpdates(_0x46f11d){return function(_0x313187){try{jsonpatch[_0xd8a6('0x26')](_0x313187,_0x46f11d,!![]);}catch(_0x2db89d){return BPromise['reject'](_0x2db89d);}return _0x313187[_0xd8a6('0x27')]();};}function saveUpdates(_0x490a27,_0x1ad47c){return function(_0x431432){if(_0x431432){return _0x431432['update'](_0x490a27)[_0xd8a6('0x28')](function(_0x1e8904){return _0x1e8904;});}return null;};}function removeEntity(_0x2cdf6f,_0x23fbbd){return function(_0x744629){if(_0x744629){return _0x744629[_0xd8a6('0x29')]()[_0xd8a6('0x28')](function(){var _0x21def5=_0x744629[_0xd8a6('0x2a')]({'plain':!![]});var _0x15a7b0=_0xd8a6('0x2b');return db[_0xd8a6('0x2c')][_0xd8a6('0x29')]({'where':{'type':_0x15a7b0,'resourceId':_0x21def5['id']}})[_0xd8a6('0x28')](function(){return _0x744629;});})[_0xd8a6('0x28')](function(){_0x2cdf6f[_0xd8a6('0x1e')](0xcc)['end']();});}};}function handleEntityNotFound(_0x56635a,_0x423c2f){return function(_0x4de7ca){if(!_0x4de7ca){_0x56635a[_0xd8a6('0x1d')](0x194);}return _0x4de7ca;};}function handleError(_0x59bbbe,_0x19e08e){_0x19e08e=_0x19e08e||0x1f4;return function(_0x52410a){logger[_0xd8a6('0x2d')](_0x52410a[_0xd8a6('0x2e')]);if(_0x52410a[_0xd8a6('0x2f')]){delete _0x52410a[_0xd8a6('0x2f')];}_0x59bbbe[_0xd8a6('0x1e')](_0x19e08e)[_0xd8a6('0x30')](_0x52410a);};}exports[_0xd8a6('0x31')]=function(_0xf8e71,_0x25db1a){var _0x2c2d84={},_0x123533={},_0x279bac={'count':0x0,'rows':[]};var _0x5286af=_[_0xd8a6('0x32')](db[_0xd8a6('0x33')][_0xd8a6('0x34')],function(_0x3fa6f0){return{'name':_0x3fa6f0[_0xd8a6('0x35')],'type':_0x3fa6f0['type'][_0xd8a6('0x36')]};});_0x123533[_0xd8a6('0x37')]=_[_0xd8a6('0x32')](_0x5286af,_0xd8a6('0x2f'));_0x123533[_0xd8a6('0x38')]=_[_0xd8a6('0x39')](_0xf8e71[_0xd8a6('0x38')]);_0x123533[_0xd8a6('0x3a')]=_[_0xd8a6('0x3b')](_0x123533[_0xd8a6('0x37')],_0x123533[_0xd8a6('0x38')]);_0x2c2d84['attributes']=_[_0xd8a6('0x3b')](_0x123533[_0xd8a6('0x37')],qs[_0xd8a6('0x3c')](_0xf8e71['query']['fields']));_0x2c2d84[_0xd8a6('0x3d')]=_0x2c2d84[_0xd8a6('0x3d')]['length']?_0x2c2d84['attributes']:_0x123533[_0xd8a6('0x37')];if(!_0xf8e71['query'][_0xd8a6('0x3e')](_0xd8a6('0x3f'))){_0x2c2d84[_0xd8a6('0x22')]=qs['limit'](_0xf8e71[_0xd8a6('0x38')][_0xd8a6('0x22')]);_0x2c2d84[_0xd8a6('0x20')]=qs[_0xd8a6('0x20')](_0xf8e71[_0xd8a6('0x38')][_0xd8a6('0x20')]);}_0x2c2d84[_0xd8a6('0x40')]=qs[_0xd8a6('0x41')](_0xf8e71[_0xd8a6('0x38')][_0xd8a6('0x41')]);_0x2c2d84['where']=qs[_0xd8a6('0x3a')](_['pick'](_0xf8e71[_0xd8a6('0x38')],_0x123533[_0xd8a6('0x3a')]),_0x5286af);if(_0xf8e71[_0xd8a6('0x38')][_0xd8a6('0x42')]){_0x2c2d84['where']=_[_0xd8a6('0x43')](_0x2c2d84[_0xd8a6('0x44')],{'$or':_[_0xd8a6('0x32')](_0x5286af,function(_0x45def2){if(_0x45def2[_0xd8a6('0x45')]!==_0xd8a6('0x46')){var _0x435f28={};_0x435f28[_0x45def2[_0xd8a6('0x2f')]]={'$like':'%'+_0xf8e71[_0xd8a6('0x38')][_0xd8a6('0x42')]+'%'};return _0x435f28;}})});}_0x2c2d84=_[_0xd8a6('0x43')]({},_0x2c2d84,_0xf8e71[_0xd8a6('0x47')]);var _0x21c513={'where':_0x2c2d84['where']};return db[_0xd8a6('0x33')]['count'](_0x21c513)['then'](function(_0x534dc3){_0x279bac['count']=_0x534dc3;if(_0xf8e71[_0xd8a6('0x38')][_0xd8a6('0x48')]){_0x2c2d84[_0xd8a6('0x49')]=[{'all':!![]}];}return db[_0xd8a6('0x33')]['findAll'](_0x2c2d84);})[_0xd8a6('0x28')](function(_0x128ca4){_0x279bac[_0xd8a6('0x4a')]=_0x128ca4;return _0x279bac;})['then'](respondWithFilteredResult(_0x25db1a,_0x2c2d84))[_0xd8a6('0x4b')](handleError(_0x25db1a,null));};exports['show']=function(_0x1a38b1,_0x16f533){var _0x36a06f={'raw':![],'where':{'id':_0x1a38b1[_0xd8a6('0x4c')]['id']}},_0x57afbc={};_0x57afbc[_0xd8a6('0x37')]=_[_0xd8a6('0x39')](db[_0xd8a6('0x33')][_0xd8a6('0x34')]);_0x57afbc[_0xd8a6('0x38')]=_[_0xd8a6('0x39')](_0x1a38b1[_0xd8a6('0x38')]);_0x57afbc['filters']=_['intersection'](_0x57afbc[_0xd8a6('0x37')],_0x57afbc[_0xd8a6('0x38')]);_0x36a06f[_0xd8a6('0x3d')]=_[_0xd8a6('0x3b')](_0x57afbc[_0xd8a6('0x37')],qs[_0xd8a6('0x3c')](_0x1a38b1[_0xd8a6('0x38')][_0xd8a6('0x3c')]));_0x36a06f['attributes']=_0x36a06f['attributes']['length']?_0x36a06f[_0xd8a6('0x3d')]:_0x57afbc[_0xd8a6('0x37')];if(_0x1a38b1[_0xd8a6('0x38')][_0xd8a6('0x48')]){_0x36a06f[_0xd8a6('0x49')]=[{'all':!![]}];}_0x36a06f=_[_0xd8a6('0x43')]({},_0x36a06f,_0x1a38b1['options']);return db[_0xd8a6('0x33')][_0xd8a6('0x4d')](_0x36a06f)[_0xd8a6('0x28')](handleEntityNotFound(_0x16f533,null))[_0xd8a6('0x28')](respondWithResult(_0x16f533,null))['catch'](handleError(_0x16f533,null));};exports[_0xd8a6('0x4e')]=function(_0x35fe95,_0x336d8f){return db['AnalyticCustomReport']['create'](_0x35fe95['body'],{})[_0xd8a6('0x28')](function(_0x5b337b){var _0x411e89=_0x35fe95[_0xd8a6('0x4f')][_0xd8a6('0x2a')]({'plain':!![]});if(!_0x411e89)throw new Error(_0xd8a6('0x50'));if(_0x411e89[_0xd8a6('0x51')]===_0xd8a6('0x4f')){var _0x5b24d5=_0x5b337b['get']({'plain':!![]});var _0x4c29ae='Reports';return db[_0xd8a6('0x52')][_0xd8a6('0x4d')]({'where':{'name':_0x4c29ae,'userProfileId':_0x411e89['userProfileId']},'raw':!![]})[_0xd8a6('0x28')](function(_0x14e3f6){if(_0x14e3f6&&_0x14e3f6[_0xd8a6('0x53')]===0x0){return db[_0xd8a6('0x2c')][_0xd8a6('0x4e')]({'name':_0x5b24d5[_0xd8a6('0x2f')],'resourceId':_0x5b24d5['id'],'type':_0xd8a6('0x2b'),'sectionId':_0x14e3f6['id']},{})['then'](function(){return _0x5b337b;});}else{return _0x5b337b;}})['catch'](function(_0x32b819){logger[_0xd8a6('0x2d')](_0xd8a6('0x54'),_0x32b819);throw _0x32b819;});}return _0x5b337b;})[_0xd8a6('0x28')](respondWithResult(_0x336d8f,0xc9))[_0xd8a6('0x4b')](handleError(_0x336d8f,null));};exports[_0xd8a6('0x55')]=function(_0x762d97,_0x4f8b76){if(_0x762d97['body']['id']){delete _0x762d97[_0xd8a6('0x56')]['id'];}return db['AnalyticCustomReport'][_0xd8a6('0x4d')]({'where':{'id':_0x762d97[_0xd8a6('0x4c')]['id']}})['then'](handleEntityNotFound(_0x4f8b76,null))[_0xd8a6('0x28')](saveUpdates(_0x762d97['body'],null))['then'](respondWithResult(_0x4f8b76,null))[_0xd8a6('0x4b')](handleError(_0x4f8b76,null));};exports[_0xd8a6('0x29')]=function(_0x3bf1bd,_0x20c40c){return db[_0xd8a6('0x33')]['find']({'where':{'id':_0x3bf1bd[_0xd8a6('0x4c')]['id']}})[_0xd8a6('0x28')](handleEntityNotFound(_0x20c40c,null))[_0xd8a6('0x28')](removeEntity(_0x20c40c,null))[_0xd8a6('0x4b')](handleError(_0x20c40c,null));};exports[_0xd8a6('0x57')]=function(_0x2f32f5,_0x2fa7fb){var _0x574d14=0xa;var _0x27cd4e=['join',_0xd8a6('0x58'),_0xd8a6('0x59'),_0xd8a6('0x5a')];var _0xa433d6={'SUM':_0xd8a6('0x5b'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0xd8a6('0x5c'),'MAX':_0xd8a6('0x5d'),'MIN':_0xd8a6('0x5e'),'AVG':_0xd8a6('0x5f'),'GROUP_CONCAT':_0xd8a6('0x60'),'GROUP_CONCAT ASC':_0xd8a6('0x61'),'GROUP_CONCAT DESC':_0xd8a6('0x62')};var _0x1600b6={'SEC_TO_TIME':_0xd8a6('0x63'),'DATE':_0xd8a6('0x64'),'HOUR':_0xd8a6('0x65'),'ROUND':_0xd8a6('0x66'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x20ec8e=function(_0x3ff123){return!_[_0xd8a6('0x67')]([_0xd8a6('0x68'),'IS\x20NOT\x20NULL',_0xd8a6('0x69'),_0xd8a6('0x6a')],_0x3ff123);};var _0x711e73=function(_0x563bc8){if(!_0x563bc8||!_0x563bc8['rules'][_0xd8a6('0x6b')]){return'';}for(var _0x348143='(',_0x13963e=0x0;_0x13963e<_0x563bc8[_0xd8a6('0x6c')][_0xd8a6('0x6b')];_0x13963e+=0x1){_0x13963e>0x0&&(_0x348143+='\x20'+_0x563bc8[_0xd8a6('0x6d')]+'\x20');_0x348143+=_0x563bc8['rules'][_0x13963e][_0xd8a6('0x6e')]?_0x711e73(_0x563bc8['rules'][_0x13963e][_0xd8a6('0x6e')]):_0x563bc8[_0xd8a6('0x6c')][_0x13963e]['field']+'\x20'+_0x563bc8[_0xd8a6('0x6c')][_0x13963e]['condition']+(_0x20ec8e(_0x563bc8[_0xd8a6('0x6c')][_0x13963e][_0xd8a6('0x6f')])?'\x20'+_0x563bc8[_0xd8a6('0x6c')][_0x13963e][_0xd8a6('0x70')]:'');}return _0x348143+')';};var _0x1541fa={'where':{'id':_0x2f32f5[_0xd8a6('0x4c')]['id']}},_0x2b25c7,_0x59b1d9,_0x21a75b,_0x2c0c5a,_0x562e13;_0x1541fa=_[_0xd8a6('0x43')]({},_0x1541fa,_0x2f32f5[_0xd8a6('0x47')]);return db[_0xd8a6('0x33')]['find'](_0x1541fa)[_0xd8a6('0x28')](function(_0x10e2ef){if(_0x10e2ef){_0x2b25c7=_0x10e2ef;return _0x10e2ef[_0xd8a6('0x71')]();}return null;})[_0xd8a6('0x28')](function(_0x115666){if(_0x115666){if(!_0x115666['length']){throw new db[(_0xd8a6('0x72'))][(_0xd8a6('0x73'))](_0xd8a6('0x74'),0x193);}_0x59b1d9=_0x115666;return db[_0xd8a6('0x75')][_0xd8a6('0x76')]({'raw':!![]});}return null;})[_0xd8a6('0x28')](function(_0x35c6f5){if(_0x35c6f5){_0x21a75b=_[_0xd8a6('0x77')](_0x35c6f5,'id');var _0x5c58fe;var _0x141df9=squel['select']();_0x141df9[_0xd8a6('0x78')](_0x2b25c7[_0xd8a6('0x79')]);for(var _0xe37ac7=0x0;_0xe37ac7<_0x59b1d9[_0xd8a6('0x6b')];_0xe37ac7+=0x1){_0x5c58fe=_0x59b1d9[_0xe37ac7][_0xd8a6('0x7a')]?_0x21a75b[_0x59b1d9[_0xe37ac7][_0xd8a6('0x7a')]][_0xd8a6('0x7b')]:_0x59b1d9[_0xe37ac7][_0xd8a6('0x7c')];_0x5c58fe=_0x59b1d9[_0xe37ac7]['function']?_['replace'](_0xa433d6[_0x59b1d9[_0xe37ac7]['function']],'%s',_0x5c58fe):_0x5c58fe;_0x5c58fe=_0x59b1d9[_0xe37ac7][_0xd8a6('0x7d')]?_[_0xd8a6('0x7e')](_0x1600b6[_0x59b1d9[_0xe37ac7]['format']],'%s',_0x5c58fe):_0x5c58fe;if(_0x59b1d9[_0xe37ac7][_0xd8a6('0x7f')]){_0x141df9[_0xd8a6('0x6e')](_0x5c58fe);}_0x59b1d9[_0xe37ac7][_0xd8a6('0x80')]&&_0x141df9[_0xd8a6('0x40')](_0x5c58fe,_0x59b1d9[_0xe37ac7][_0xd8a6('0x80')]===_0xd8a6('0x81')?![]:!![]);_0x141df9[_0xd8a6('0x7c')](_0x5c58fe,_0x59b1d9[_0xe37ac7][_0xd8a6('0x82')]||_0x5c58fe);}if(_0x2b25c7[_0xd8a6('0x83')]){_0x2b25c7[_0xd8a6('0x83')]=JSON[_0xd8a6('0x84')](_0x2b25c7['joins']);for(var _0x5d68c3=0x0;_0x5d68c3<_0x2b25c7['joins'][_0xd8a6('0x6b')];_0x5d68c3+=0x1){if(_0x2b25c7[_0xd8a6('0x83')][_0x5d68c3][_0xd8a6('0x45')]&&_[_0xd8a6('0x67')](_0x27cd4e,_0x2b25c7[_0xd8a6('0x83')][_0x5d68c3]['type'])&&_0x2b25c7[_0xd8a6('0x83')][_0x5d68c3][_0xd8a6('0x85')]&&_0x2b25c7[_0xd8a6('0x83')][_0x5d68c3][_0xd8a6('0x86')]&&_0x2b25c7[_0xd8a6('0x83')][_0x5d68c3][_0xd8a6('0x87')]){_0x141df9[_0x2b25c7[_0xd8a6('0x83')][_0x5d68c3][_0xd8a6('0x45')]](_0x2b25c7[_0xd8a6('0x83')][_0x5d68c3][_0xd8a6('0x86')],null,util[_0xd8a6('0x7d')](_0xd8a6('0x88'),_0x2b25c7[_0xd8a6('0x79')],_0x2b25c7[_0xd8a6('0x83')][_0x5d68c3][_0xd8a6('0x85')],_0x2b25c7[_0xd8a6('0x83')][_0x5d68c3][_0xd8a6('0x86')],_0x2b25c7[_0xd8a6('0x83')][_0x5d68c3][_0xd8a6('0x87')]));}}}if(_0x2b25c7[_0xd8a6('0x89')]){_0x2b25c7[_0xd8a6('0x89')]=JSON[_0xd8a6('0x84')](_0x2b25c7[_0xd8a6('0x89')]);_0x141df9[_0xd8a6('0x44')](_0x711e73(_0x2b25c7[_0xd8a6('0x89')][_0xd8a6('0x6e')]));}_0x562e13=_0x141df9[_0xd8a6('0x8a')]();_0x141df9[_0xd8a6('0x22')](_0x574d14);_0x141df9[_0xd8a6('0x20')](0x0);logger[_0xd8a6('0x8b')]('Limited\x20Query:',_0x141df9['toString']());return dbH[_0xd8a6('0x8c')][_0xd8a6('0x38')](_0x141df9[_0xd8a6('0x8d')](),{'type':dbH['sequelize'][_0xd8a6('0x8e')][_0xd8a6('0x8f')]});}})[_0xd8a6('0x28')](respondWithResult(_0x2fa7fb,null))[_0xd8a6('0x4b')](handleError(_0x2fa7fb,null));};function runReport(_0x175f26,_0x41ac2a,_0x1fff2b){var _0x5f6345=_0x41ac2a['name'];var _0x5e4422=0xa;var _0x4af92c=[_0xd8a6('0x90'),_0xd8a6('0x58'),_0xd8a6('0x59'),_0xd8a6('0x5a')];var _0x7c95d9={'SUM':_0xd8a6('0x5b'),'COUNT':_0xd8a6('0x91'),'COUNT DISTINCT':_0xd8a6('0x5c'),'MAX':_0xd8a6('0x5d'),'MIN':_0xd8a6('0x5e'),'AVG':_0xd8a6('0x5f'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0xd8a6('0x61'),'GROUP_CONCAT DESC':_0xd8a6('0x62')};var _0x60ac43={'SEC_TO_TIME':_0xd8a6('0x63'),'DATE':'DATE(%s)','HOUR':_0xd8a6('0x65'),'ROUND':_0xd8a6('0x66'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x1c5817=function(_0x45dc7f){return!_[_0xd8a6('0x67')](['IS\x20NULL','IS\x20NOT\x20NULL',_0xd8a6('0x69'),_0xd8a6('0x6a')],_0x45dc7f);};var _0x161e6f=function(_0x14f75b){if(!_0x14f75b||!_0x14f75b[_0xd8a6('0x6c')][_0xd8a6('0x6b')]){return'';}for(var _0x1685a7='(',_0x1ca32f=0x0;_0x1ca32f<_0x14f75b[_0xd8a6('0x6c')][_0xd8a6('0x6b')];_0x1ca32f+=0x1){_0x1ca32f>0x0&&(_0x1685a7+='\x20'+_0x14f75b[_0xd8a6('0x6d')]+'\x20');_0x1685a7+=_0x14f75b[_0xd8a6('0x6c')][_0x1ca32f][_0xd8a6('0x6e')]?_0x161e6f(_0x14f75b['rules'][_0x1ca32f]['group']):_0x14f75b[_0xd8a6('0x6c')][_0x1ca32f][_0xd8a6('0x7c')]+'\x20'+_0x14f75b[_0xd8a6('0x6c')][_0x1ca32f][_0xd8a6('0x6f')]+(_0x1c5817(_0x14f75b['rules'][_0x1ca32f][_0xd8a6('0x6f')])?'\x20'+_0x14f75b[_0xd8a6('0x6c')][_0x1ca32f][_0xd8a6('0x70')]:'');}return _0x1685a7+')';};var _0x1f22ed={'where':{'id':_0x175f26['id']}},_0x59e550,_0xe5cad6,_0x116e0f,_0x5c82f5,_0x1e37f1;_0x1f22ed=_[_0xd8a6('0x43')]({},_0x1f22ed,_0x1fff2b);return db[_0xd8a6('0x33')][_0xd8a6('0x4d')](_0x1f22ed)[_0xd8a6('0x28')](function(_0x4bfbde){if(_0x4bfbde){_0x59e550=_0x4bfbde;return _0x4bfbde['getFields']();}return null;})[_0xd8a6('0x28')](function(_0x5d987f){if(_0x5d987f){if(!_0x5d987f[_0xd8a6('0x6b')]){throw new db[(_0xd8a6('0x72'))][(_0xd8a6('0x73'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0xe5cad6=_0x5d987f;return db[_0xd8a6('0x75')][_0xd8a6('0x76')]({'raw':!![]});}return null;})[_0xd8a6('0x28')](function(_0x31d144){if(_0x31d144){_0x116e0f=_[_0xd8a6('0x77')](_0x31d144,'id');var _0x361e9c;var _0xe2d4ff=squel[_0xd8a6('0x92')]();_0xe2d4ff[_0xd8a6('0x78')](_0x59e550[_0xd8a6('0x79')]);for(var _0x188502=0x0;_0x188502<_0xe5cad6[_0xd8a6('0x6b')];_0x188502+=0x1){_0x361e9c=_0xe5cad6[_0x188502][_0xd8a6('0x7a')]?_0x116e0f[_0xe5cad6[_0x188502][_0xd8a6('0x7a')]][_0xd8a6('0x7b')]:_0xe5cad6[_0x188502][_0xd8a6('0x7c')];_0x361e9c=_0xe5cad6[_0x188502][_0xd8a6('0x93')]?_[_0xd8a6('0x7e')](_0x7c95d9[_0xe5cad6[_0x188502]['function']],'%s',_0x361e9c):_0x361e9c;_0x361e9c=_0xe5cad6[_0x188502][_0xd8a6('0x7d')]?_[_0xd8a6('0x7e')](_0x60ac43[_0xe5cad6[_0x188502][_0xd8a6('0x7d')]],'%s',_0x361e9c):_0x361e9c;if(_0xe5cad6[_0x188502][_0xd8a6('0x7f')]){_0xe2d4ff[_0xd8a6('0x6e')](_0x361e9c);}_0xe5cad6[_0x188502][_0xd8a6('0x80')]&&_0xe2d4ff[_0xd8a6('0x40')](_0x361e9c,_0xe5cad6[_0x188502][_0xd8a6('0x80')]==='DESC'?![]:!![]);_0xe2d4ff[_0xd8a6('0x7c')](_0x361e9c,_0xe5cad6[_0x188502][_0xd8a6('0x82')]||_0x361e9c);}if(_0x59e550[_0xd8a6('0x83')]){_0x59e550[_0xd8a6('0x83')]=JSON['parse'](_0x59e550[_0xd8a6('0x83')]);for(var _0x1fb924=0x0;_0x1fb924<_0x59e550[_0xd8a6('0x83')][_0xd8a6('0x6b')];_0x1fb924+=0x1){if(_0x59e550[_0xd8a6('0x83')][_0x1fb924][_0xd8a6('0x45')]&&_[_0xd8a6('0x67')](_0x4af92c,_0x59e550[_0xd8a6('0x83')][_0x1fb924][_0xd8a6('0x45')])&&_0x59e550['joins'][_0x1fb924][_0xd8a6('0x85')]&&_0x59e550[_0xd8a6('0x83')][_0x1fb924][_0xd8a6('0x86')]&&_0x59e550['joins'][_0x1fb924][_0xd8a6('0x87')]){_0xe2d4ff[_0x59e550[_0xd8a6('0x83')][_0x1fb924][_0xd8a6('0x45')]](_0x59e550['joins'][_0x1fb924][_0xd8a6('0x86')],null,util[_0xd8a6('0x7d')](_0xd8a6('0x88'),_0x59e550['table'],_0x59e550[_0xd8a6('0x83')][_0x1fb924][_0xd8a6('0x85')],_0x59e550[_0xd8a6('0x83')][_0x1fb924]['foreignTable'],_0x59e550[_0xd8a6('0x83')][_0x1fb924][_0xd8a6('0x87')]));}}}if(_0x59e550[_0xd8a6('0x89')]){_0x59e550[_0xd8a6('0x89')]=JSON[_0xd8a6('0x84')](_0x59e550['conditions']);_0xe2d4ff['where'](_0x161e6f(_0x59e550[_0xd8a6('0x89')][_0xd8a6('0x6e')]));}_0x1e37f1=_0xe2d4ff[_0xd8a6('0x8a')]();_0xe2d4ff[_0xd8a6('0x22')](_0x5e4422);_0xe2d4ff[_0xd8a6('0x20')](0x0);return;}})['then'](function(){if(_0x41ac2a[_0xd8a6('0x94')]===_0xd8a6('0x95')){return null;}var _0x2dee06=_[_0xd8a6('0x43')](_0x41ac2a,{'name':_0x41ac2a[_0xd8a6('0x96')]||_0x41ac2a[_0xd8a6('0x2f')]||_0x59e550[_0xd8a6('0x2f')],'basename':_0x5f6345,'savename':util[_0xd8a6('0x7d')](_0xd8a6('0x97'),_0x41ac2a[_0xd8a6('0x2f')]||_0x59e550[_0xd8a6('0x2f')],require('randomstring')[_0xd8a6('0x98')](0x4),_0x41ac2a[_0xd8a6('0x94')]||_0xd8a6('0x99')),'reportId':_0x59e550['id'],'reportType':_0xd8a6('0x9a')});return db['AnalyticExtractedReport'][_0xd8a6('0x4e')](_0x2dee06,{'raw':!![]});})[_0xd8a6('0x28')](function(_0x4d95cd){if(_0x59e550[_0xd8a6('0x79')]===_0xd8a6('0x9b')){_0x1e37f1['where'](_0x59e550['table']+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x41ac2a[_0xd8a6('0x9c')],_0x41ac2a[_0xd8a6('0x9d')]);}else{_0x1e37f1['where'](_0x59e550[_0xd8a6('0x79')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x41ac2a[_0xd8a6('0x9c')],_0x41ac2a['endDate']);}if(_0x4d95cd){logger['info'](_0xd8a6('0x9e'),_0x1e37f1[_0xd8a6('0x8d')]());require(_0xd8a6('0x9f'))[_0xd8a6('0xa0')](path[_0xd8a6('0x90')](__dirname,_0xd8a6('0xa1'),_0x4d95cd[_0xd8a6('0x94')]),[_0x4d95cd['id'],_0x1e37f1[_0xd8a6('0x8d')](),path[_0xd8a6('0x90')](__dirname,_0xd8a6('0xa2'),_0x4d95cd[_0xd8a6('0xa3')]),_0x5f6345]);return _0x4d95cd;}else{var _0x439113=squel['select']();_0x439113[_0xd8a6('0x78')]('('+_0x1e37f1['toString']()+')',_0xd8a6('0xa4'));_0x439113[_0xd8a6('0x7c')](_0xd8a6('0xa5'),_0xd8a6('0xa6'));_0x1e37f1['limit'](_0x41ac2a[_0xd8a6('0x22')]||_0x5e4422);_0x1e37f1[_0xd8a6('0x20')](_0x41ac2a['offset']||0x0);return dbH[_0xd8a6('0x8c')][_0xd8a6('0x38')](_0x439113['toString'](),{'type':dbH['sequelize']['QueryTypes'][_0xd8a6('0x8f')]})[_0xd8a6('0x28')](function(_0xf3a3da){if(!_0xf3a3da[_0xd8a6('0x6b')]){_0x5c82f5=0x0;}else{_0x5c82f5=_0xf3a3da[0x0][_0xd8a6('0xa6')]||0x0;}return dbH[_0xd8a6('0x8c')]['query'](_0x1e37f1[_0xd8a6('0x8d')](),{'type':dbH[_0xd8a6('0x8c')][_0xd8a6('0x8e')]['SELECT']});})[_0xd8a6('0x28')](function(_0x4da13e){return{'rows':_0x4da13e||[],'count':_0x5c82f5};});}});}exports[_0xd8a6('0xa7')]=function(_0x15f7a6,_0x2e6834){return runReport(_0x15f7a6[_0xd8a6('0x4c')],_0x15f7a6[_0xd8a6('0x38')],_0x15f7a6['options'])[_0xd8a6('0x28')](respondWithResult(_0x2e6834,null))[_0xd8a6('0x4b')](handleError(_0x2e6834,null));};exports[_0xd8a6('0xa8')]=runReport;exports[_0xd8a6('0x38')]=function(_0x312159,_0xa3944d){var _0x407e40=0xa;var _0x5a4e69=[_0xd8a6('0x90'),_0xd8a6('0x58'),_0xd8a6('0x59'),_0xd8a6('0x5a')];var _0x1ae66a={'SUM':_0xd8a6('0x5b'),'COUNT':_0xd8a6('0x91'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':_0xd8a6('0x5f'),'GROUP_CONCAT':_0xd8a6('0x60'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x4482fa={'SEC_TO_TIME':_0xd8a6('0x63'),'DATE':'DATE(%s)','HOUR':_0xd8a6('0x65'),'ROUND':_0xd8a6('0x66'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x45a5dc=function(_0x1b8127){return!_['includes']([_0xd8a6('0x68'),'IS\x20NOT\x20NULL',_0xd8a6('0x69'),_0xd8a6('0x6a')],_0x1b8127);};var _0x64f9c7=function(_0x57bc8a){if(!_0x57bc8a||!_0x57bc8a[_0xd8a6('0x6c')][_0xd8a6('0x6b')]){return'';}for(var _0xbfff0e='(',_0x592082=0x0;_0x592082<_0x57bc8a[_0xd8a6('0x6c')][_0xd8a6('0x6b')];_0x592082+=0x1){_0x592082>0x0&&(_0xbfff0e+='\x20'+_0x57bc8a[_0xd8a6('0x6d')]+'\x20');_0xbfff0e+=_0x57bc8a['rules'][_0x592082][_0xd8a6('0x6e')]?_0x64f9c7(_0x57bc8a['rules'][_0x592082][_0xd8a6('0x6e')]):_0x57bc8a[_0xd8a6('0x6c')][_0x592082]['field']+'\x20'+_0x57bc8a[_0xd8a6('0x6c')][_0x592082][_0xd8a6('0x6f')]+(_0x45a5dc(_0x57bc8a['rules'][_0x592082][_0xd8a6('0x6f')])?'\x20'+_0x57bc8a['rules'][_0x592082][_0xd8a6('0x70')]:'');}return _0xbfff0e+')';};var _0x11412f={'where':{'id':_0x312159['params']['id']}},_0x54f597,_0x166342,_0x277c86,_0x252138,_0x17c6d7;_0x11412f=_[_0xd8a6('0x43')]({},_0x11412f,_0x312159[_0xd8a6('0x47')]);return db['AnalyticCustomReport'][_0xd8a6('0x4d')](_0x11412f)[_0xd8a6('0x28')](function(_0x3e6ae8){if(_0x3e6ae8){_0x54f597=_0x3e6ae8;return _0x3e6ae8[_0xd8a6('0x71')]();}return null;})[_0xd8a6('0x28')](function(_0x1562e6){if(_0x1562e6){if(!_0x1562e6[_0xd8a6('0x6b')]){throw new db['Sequelize'][(_0xd8a6('0x73'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x166342=_0x1562e6;return db[_0xd8a6('0x75')][_0xd8a6('0x76')]({'raw':!![]});}return null;})['then'](function(_0x3a063f){if(_0x3a063f){_0x277c86=_[_0xd8a6('0x77')](_0x3a063f,'id');var _0x46ad3c;var _0x5c30cb=squel['select']();_0x5c30cb[_0xd8a6('0x78')](_0x54f597[_0xd8a6('0x79')]);for(var _0x5521d3=0x0;_0x5521d3<_0x166342[_0xd8a6('0x6b')];_0x5521d3+=0x1){_0x46ad3c=_0x166342[_0x5521d3][_0xd8a6('0x7a')]?_0x277c86[_0x166342[_0x5521d3]['MetricId']][_0xd8a6('0x7b')]:_0x166342[_0x5521d3]['field'];_0x46ad3c=_0x166342[_0x5521d3][_0xd8a6('0x93')]?_['replace'](_0x1ae66a[_0x166342[_0x5521d3][_0xd8a6('0x93')]],'%s',_0x46ad3c):_0x46ad3c;_0x46ad3c=_0x166342[_0x5521d3]['format']?_[_0xd8a6('0x7e')](_0x4482fa[_0x166342[_0x5521d3][_0xd8a6('0x7d')]],'%s',_0x46ad3c):_0x46ad3c;if(_0x166342[_0x5521d3][_0xd8a6('0x7f')]){_0x5c30cb['group'](_0x46ad3c);}_0x166342[_0x5521d3]['orderBy']&&_0x5c30cb[_0xd8a6('0x40')](_0x46ad3c,_0x166342[_0x5521d3][_0xd8a6('0x80')]==='DESC'?![]:!![]);_0x5c30cb['field'](_0x46ad3c,_0x166342[_0x5521d3][_0xd8a6('0x82')]||_0x46ad3c);}if(_0x54f597[_0xd8a6('0x83')]){_0x54f597[_0xd8a6('0x83')]=JSON[_0xd8a6('0x84')](_0x54f597[_0xd8a6('0x83')]);for(var _0x34bcec=0x0;_0x34bcec<_0x54f597[_0xd8a6('0x83')][_0xd8a6('0x6b')];_0x34bcec+=0x1){if(_0x54f597['joins'][_0x34bcec][_0xd8a6('0x45')]&&_[_0xd8a6('0x67')](_0x5a4e69,_0x54f597['joins'][_0x34bcec][_0xd8a6('0x45')])&&_0x54f597['joins'][_0x34bcec][_0xd8a6('0x85')]&&_0x54f597[_0xd8a6('0x83')][_0x34bcec]['foreignTable']&&_0x54f597['joins'][_0x34bcec][_0xd8a6('0x87')]){_0x5c30cb[_0x54f597[_0xd8a6('0x83')][_0x34bcec][_0xd8a6('0x45')]](_0x54f597[_0xd8a6('0x83')][_0x34bcec][_0xd8a6('0x86')],null,util[_0xd8a6('0x7d')](_0xd8a6('0x88'),_0x54f597[_0xd8a6('0x79')],_0x54f597[_0xd8a6('0x83')][_0x34bcec]['parentKey'],_0x54f597[_0xd8a6('0x83')][_0x34bcec][_0xd8a6('0x86')],_0x54f597[_0xd8a6('0x83')][_0x34bcec][_0xd8a6('0x87')]));}}}if(_0x54f597[_0xd8a6('0x89')]){_0x54f597[_0xd8a6('0x89')]=JSON[_0xd8a6('0x84')](_0x54f597['conditions']);_0x5c30cb[_0xd8a6('0x44')](_0x64f9c7(_0x54f597[_0xd8a6('0x89')][_0xd8a6('0x6e')]));}_0x17c6d7=_0x5c30cb[_0xd8a6('0x8a')]();_0x5c30cb['limit'](_0x407e40);_0x5c30cb[_0xd8a6('0x20')](0x0);logger[_0xd8a6('0x8b')](_0xd8a6('0xa9'),_0x5c30cb[_0xd8a6('0x8d')]());return dbH['sequelize'][_0xd8a6('0x38')](_0x5c30cb[_0xd8a6('0x8d')](),{'type':dbH[_0xd8a6('0x8c')][_0xd8a6('0x8e')][_0xd8a6('0x8f')]});}})[_0xd8a6('0x28')](function(){return{'sql':_0x17c6d7[_0xd8a6('0x8d')]()};})[_0xd8a6('0x28')](respondWithResult(_0xa3944d,null))[_0xd8a6('0x4b')](handleError(_0xa3944d,null));};
\ No newline at end of file
+var _0x012b=['limit','set','Content-Range','apply','reject','save','update','then','CustomReports','UserProfileResource','destroy','error','name','send','index','AnalyticCustomReport','rawAttributes','fieldName','type','model','map','query','filters','attributes','intersection','fields','nolimit','sort','where','filter','merge','options','includeAll','show','params','keys','include','find','catch','create','user','get','role','Reports','UserProfileSection','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','preview','join','right_join','cross_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%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)','includes','IS\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','length','operator','group','condition','value','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','select','from','table','MetricId','metric','field','function','format','replace','groupBy','orderBy','order','DESC','alias','joins','parse','parentKey','foreignKey','foreignTable','%s.%s\x20=\x20%s.%s','conditions','clone','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','left_join','IS\x20NOT\x20NULL','findAll','output','fullPath','%s-%s.%s','generate','csv','AnalyticExtractedReport','cdr','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','Run\x20Query:','fork','../../components/export/','../../files/reports','savename','run','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','fs-extra','squel','crypto','jsforce','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','undefined','count'];(function(_0x10c44f,_0x46c752){var _0x3065c1=function(_0x422238){while(--_0x422238){_0x10c44f['push'](_0x10c44f['shift']());}};_0x3065c1(++_0x46c752);}(_0x012b,0x11c));var _0xb012=function(_0x190792,_0x1b93ea){_0x190792=_0x190792-0x0;var _0xa63f9b=_0x012b[_0x190792];return _0xa63f9b;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0xb012('0x0'));var jsonpatch=require('fast-json-patch');var rp=require(_0xb012('0x1'));var moment=require(_0xb012('0x2'));var BPromise=require(_0xb012('0x3'));var Mustache=require(_0xb012('0x4'));var util=require(_0xb012('0x5'));var path=require(_0xb012('0x6'));var sox=require(_0xb012('0x7'));var csv=require(_0xb012('0x8'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xb012('0x9'));var _=require('lodash');var squel=require(_0xb012('0xa'));var crypto=require(_0xb012('0xb'));var jsforce=require(_0xb012('0xc'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0xb012('0xd'));var authService=require(_0xb012('0xe'));var qs=require(_0xb012('0xf'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xb012('0x10'));var logger=require(_0xb012('0x11'))(_0xb012('0x12'));var utils=require(_0xb012('0x13'));var config=require(_0xb012('0x14'));var licenseUtil=require(_0xb012('0x15'));var db=require(_0xb012('0x16'))['db'];var dbH=require(_0xb012('0x16'))['dbH'];function respondWithStatusCode(_0x3ac288,_0x2ac644){_0x2ac644=_0x2ac644||0xcc;return function(_0x997d21){if(_0x997d21){return _0x3ac288[_0xb012('0x17')](_0x2ac644);}return _0x3ac288[_0xb012('0x18')](_0x2ac644)[_0xb012('0x19')]();};}function respondWithResult(_0x1645dd,_0x4b282e){_0x4b282e=_0x4b282e||0xc8;return function(_0xac2575){if(_0xac2575){return _0x1645dd['status'](_0x4b282e)[_0xb012('0x1a')](_0xac2575);}};}function respondWithFilteredResult(_0xaf9581,_0x476306){return function(_0x23e7e0){if(_0x23e7e0){var _0x3f98f1=typeof _0x476306[_0xb012('0x1b')]===_0xb012('0x1c')&&typeof _0x476306['limit']===_0xb012('0x1c');var _0x315ad6=_0x23e7e0['count'];var _0x574e64=_0x3f98f1?0x0:_0x476306[_0xb012('0x1b')];var _0x1e814f=_0x3f98f1?_0x23e7e0[_0xb012('0x1d')]:_0x476306[_0xb012('0x1b')]+_0x476306[_0xb012('0x1e')];var _0x6de4ae;if(_0x1e814f>=_0x315ad6){_0x1e814f=_0x315ad6;_0x6de4ae=0xc8;}else{_0x6de4ae=0xce;}_0xaf9581[_0xb012('0x18')](_0x6de4ae);return _0xaf9581[_0xb012('0x1f')](_0xb012('0x20'),_0x574e64+'-'+_0x1e814f+'/'+_0x315ad6)[_0xb012('0x1a')](_0x23e7e0);}return null;};}function patchUpdates(_0x48ecf0){return function(_0x5c1cf7){try{jsonpatch[_0xb012('0x21')](_0x5c1cf7,_0x48ecf0,!![]);}catch(_0x32ea0b){return BPromise[_0xb012('0x22')](_0x32ea0b);}return _0x5c1cf7[_0xb012('0x23')]();};}function saveUpdates(_0x48b7d8,_0x4f5254){return function(_0x1221f1){if(_0x1221f1){return _0x1221f1[_0xb012('0x24')](_0x48b7d8)[_0xb012('0x25')](function(_0x20f61d){return _0x20f61d;});}return null;};}function removeEntity(_0x16285b,_0x53e906){return function(_0x6e42a1){if(_0x6e42a1){return _0x6e42a1['destroy']()[_0xb012('0x25')](function(){var _0x43b794=_0x6e42a1['get']({'plain':!![]});var _0x3247cd=_0xb012('0x26');return db[_0xb012('0x27')][_0xb012('0x28')]({'where':{'type':_0x3247cd,'resourceId':_0x43b794['id']}})[_0xb012('0x25')](function(){return _0x6e42a1;});})[_0xb012('0x25')](function(){_0x16285b[_0xb012('0x18')](0xcc)['end']();});}};}function handleEntityNotFound(_0x23e777,_0x280dfd){return function(_0x367ed8){if(!_0x367ed8){_0x23e777[_0xb012('0x17')](0x194);}return _0x367ed8;};}function handleError(_0x4f8892,_0x2e98b2){_0x2e98b2=_0x2e98b2||0x1f4;return function(_0x4fad8b){logger[_0xb012('0x29')](_0x4fad8b['stack']);if(_0x4fad8b[_0xb012('0x2a')]){delete _0x4fad8b[_0xb012('0x2a')];}_0x4f8892[_0xb012('0x18')](_0x2e98b2)[_0xb012('0x2b')](_0x4fad8b);};}exports[_0xb012('0x2c')]=function(_0x16891e,_0x6b08da){var _0x5d3a87={},_0x3bb248={},_0xbd3364={'count':0x0,'rows':[]};var _0x204bec=_['map'](db[_0xb012('0x2d')][_0xb012('0x2e')],function(_0x109a67){return{'name':_0x109a67[_0xb012('0x2f')],'type':_0x109a67[_0xb012('0x30')]['key']};});_0x3bb248[_0xb012('0x31')]=_[_0xb012('0x32')](_0x204bec,_0xb012('0x2a'));_0x3bb248[_0xb012('0x33')]=_['keys'](_0x16891e['query']);_0x3bb248[_0xb012('0x34')]=_['intersection'](_0x3bb248['model'],_0x3bb248['query']);_0x5d3a87[_0xb012('0x35')]=_[_0xb012('0x36')](_0x3bb248['model'],qs[_0xb012('0x37')](_0x16891e[_0xb012('0x33')][_0xb012('0x37')]));_0x5d3a87['attributes']=_0x5d3a87[_0xb012('0x35')]['length']?_0x5d3a87[_0xb012('0x35')]:_0x3bb248['model'];if(!_0x16891e['query']['hasOwnProperty'](_0xb012('0x38'))){_0x5d3a87[_0xb012('0x1e')]=qs[_0xb012('0x1e')](_0x16891e[_0xb012('0x33')][_0xb012('0x1e')]);_0x5d3a87[_0xb012('0x1b')]=qs[_0xb012('0x1b')](_0x16891e['query'][_0xb012('0x1b')]);}_0x5d3a87['order']=qs[_0xb012('0x39')](_0x16891e['query'][_0xb012('0x39')]);_0x5d3a87[_0xb012('0x3a')]=qs[_0xb012('0x34')](_['pick'](_0x16891e[_0xb012('0x33')],_0x3bb248[_0xb012('0x34')]),_0x204bec);if(_0x16891e['query'][_0xb012('0x3b')]){_0x5d3a87[_0xb012('0x3a')]=_[_0xb012('0x3c')](_0x5d3a87['where'],{'$or':_['map'](_0x204bec,function(_0x38be76){if(_0x38be76[_0xb012('0x30')]!=='VIRTUAL'){var _0x10feab={};_0x10feab[_0x38be76[_0xb012('0x2a')]]={'$like':'%'+_0x16891e['query']['filter']+'%'};return _0x10feab;}})});}_0x5d3a87=_[_0xb012('0x3c')]({},_0x5d3a87,_0x16891e[_0xb012('0x3d')]);var _0x3e24b9={'where':_0x5d3a87[_0xb012('0x3a')]};return db[_0xb012('0x2d')][_0xb012('0x1d')](_0x3e24b9)[_0xb012('0x25')](function(_0x117f41){_0xbd3364[_0xb012('0x1d')]=_0x117f41;if(_0x16891e[_0xb012('0x33')][_0xb012('0x3e')]){_0x5d3a87['include']=[{'all':!![]}];}return db['AnalyticCustomReport']['findAll'](_0x5d3a87);})[_0xb012('0x25')](function(_0x18379e){_0xbd3364['rows']=_0x18379e;return _0xbd3364;})[_0xb012('0x25')](respondWithFilteredResult(_0x6b08da,_0x5d3a87))['catch'](handleError(_0x6b08da,null));};exports[_0xb012('0x3f')]=function(_0x24381b,_0x50afd5){var _0x4a0dde={'raw':![],'where':{'id':_0x24381b[_0xb012('0x40')]['id']}},_0x5a93ca={};_0x5a93ca[_0xb012('0x31')]=_['keys'](db[_0xb012('0x2d')][_0xb012('0x2e')]);_0x5a93ca[_0xb012('0x33')]=_[_0xb012('0x41')](_0x24381b[_0xb012('0x33')]);_0x5a93ca[_0xb012('0x34')]=_[_0xb012('0x36')](_0x5a93ca[_0xb012('0x31')],_0x5a93ca[_0xb012('0x33')]);_0x4a0dde[_0xb012('0x35')]=_[_0xb012('0x36')](_0x5a93ca['model'],qs[_0xb012('0x37')](_0x24381b['query'][_0xb012('0x37')]));_0x4a0dde[_0xb012('0x35')]=_0x4a0dde[_0xb012('0x35')]['length']?_0x4a0dde[_0xb012('0x35')]:_0x5a93ca[_0xb012('0x31')];if(_0x24381b['query']['includeAll']){_0x4a0dde[_0xb012('0x42')]=[{'all':!![]}];}_0x4a0dde=_[_0xb012('0x3c')]({},_0x4a0dde,_0x24381b['options']);return db[_0xb012('0x2d')][_0xb012('0x43')](_0x4a0dde)['then'](handleEntityNotFound(_0x50afd5,null))[_0xb012('0x25')](respondWithResult(_0x50afd5,null))[_0xb012('0x44')](handleError(_0x50afd5,null));};exports[_0xb012('0x45')]=function(_0x22c654,_0x56ee4d){return db['AnalyticCustomReport']['create'](_0x22c654['body'],{})[_0xb012('0x25')](function(_0x43e7f4){var _0x2d8103=_0x22c654[_0xb012('0x46')][_0xb012('0x47')]({'plain':!![]});if(!_0x2d8103)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x2d8103[_0xb012('0x48')]===_0xb012('0x46')){var _0xf9e00f=_0x43e7f4[_0xb012('0x47')]({'plain':!![]});var _0x1e2d55=_0xb012('0x49');return db[_0xb012('0x4a')][_0xb012('0x43')]({'where':{'name':_0x1e2d55,'userProfileId':_0x2d8103['userProfileId']},'raw':!![]})[_0xb012('0x25')](function(_0x5ad1aa){if(_0x5ad1aa&&_0x5ad1aa[_0xb012('0x4b')]===0x0){return db[_0xb012('0x27')][_0xb012('0x45')]({'name':_0xf9e00f[_0xb012('0x2a')],'resourceId':_0xf9e00f['id'],'type':'CustomReports','sectionId':_0x5ad1aa['id']},{})[_0xb012('0x25')](function(){return _0x43e7f4;});}else{return _0x43e7f4;}})['catch'](function(_0xc9ad5b){logger['error'](_0xb012('0x4c'),_0xc9ad5b);throw _0xc9ad5b;});}return _0x43e7f4;})[_0xb012('0x25')](respondWithResult(_0x56ee4d,0xc9))['catch'](handleError(_0x56ee4d,null));};exports[_0xb012('0x24')]=function(_0x27aad0,_0x6b4407){if(_0x27aad0[_0xb012('0x4d')]['id']){delete _0x27aad0[_0xb012('0x4d')]['id'];}return db[_0xb012('0x2d')][_0xb012('0x43')]({'where':{'id':_0x27aad0[_0xb012('0x40')]['id']}})[_0xb012('0x25')](handleEntityNotFound(_0x6b4407,null))[_0xb012('0x25')](saveUpdates(_0x27aad0[_0xb012('0x4d')],null))[_0xb012('0x25')](respondWithResult(_0x6b4407,null))[_0xb012('0x44')](handleError(_0x6b4407,null));};exports[_0xb012('0x28')]=function(_0x21751f,_0x197e4f){return db[_0xb012('0x2d')][_0xb012('0x43')]({'where':{'id':_0x21751f[_0xb012('0x40')]['id']}})[_0xb012('0x25')](handleEntityNotFound(_0x197e4f,null))[_0xb012('0x25')](removeEntity(_0x197e4f,null))[_0xb012('0x44')](handleError(_0x197e4f,null));};exports[_0xb012('0x4e')]=function(_0x2db06,_0x165ea3){var _0x5abb2d=0xa;var _0x23c6fc=[_0xb012('0x4f'),'left_join',_0xb012('0x50'),_0xb012('0x51')];var _0x52f1b7={'SUM':_0xb012('0x52'),'COUNT':_0xb012('0x53'),'COUNT DISTINCT':_0xb012('0x54'),'MAX':_0xb012('0x55'),'MIN':'MIN(%s)','AVG':_0xb012('0x56'),'GROUP_CONCAT':_0xb012('0x57'),'GROUP_CONCAT ASC':_0xb012('0x58'),'GROUP_CONCAT DESC':_0xb012('0x59')};var _0x508be6={'SEC_TO_TIME':_0xb012('0x5a'),'DATE':_0xb012('0x5b'),'HOUR':_0xb012('0x5c'),'ROUND':_0xb012('0x5d'),'UNIX_TIMESTAMP':_0xb012('0x5e')};var _0x2e1067=function(_0x152f22){return!_[_0xb012('0x5f')]([_0xb012('0x60'),'IS\x20NOT\x20NULL',_0xb012('0x61'),_0xb012('0x62')],_0x152f22);};var _0x3c213e=function(_0x48502f){if(!_0x48502f||!_0x48502f[_0xb012('0x63')][_0xb012('0x64')]){return'';}for(var _0xe12621='(',_0x56b467=0x0;_0x56b467<_0x48502f[_0xb012('0x63')][_0xb012('0x64')];_0x56b467+=0x1){_0x56b467>0x0&&(_0xe12621+='\x20'+_0x48502f[_0xb012('0x65')]+'\x20');_0xe12621+=_0x48502f['rules'][_0x56b467][_0xb012('0x66')]?_0x3c213e(_0x48502f['rules'][_0x56b467][_0xb012('0x66')]):_0x48502f[_0xb012('0x63')][_0x56b467]['field']+'\x20'+_0x48502f['rules'][_0x56b467][_0xb012('0x67')]+(_0x2e1067(_0x48502f['rules'][_0x56b467]['condition'])?'\x20'+_0x48502f[_0xb012('0x63')][_0x56b467][_0xb012('0x68')]:'');}return _0xe12621+')';};var _0x4e2985={'where':{'id':_0x2db06[_0xb012('0x40')]['id']}},_0x267e46,_0x56a6f2,_0x1c9e3d,_0x5fbc55,_0x2ed666;_0x4e2985=_[_0xb012('0x3c')]({},_0x4e2985,_0x2db06['options']);return db[_0xb012('0x2d')]['find'](_0x4e2985)[_0xb012('0x25')](function(_0x5ed1bf){if(_0x5ed1bf){_0x267e46=_0x5ed1bf;return _0x5ed1bf['getFields']();}return null;})[_0xb012('0x25')](function(_0x233b3b){if(_0x233b3b){if(!_0x233b3b[_0xb012('0x64')]){throw new db[(_0xb012('0x69'))][(_0xb012('0x6a'))](_0xb012('0x6b'),0x193);}_0x56a6f2=_0x233b3b;return db[_0xb012('0x6c')]['findAll']({'raw':!![]});}return null;})[_0xb012('0x25')](function(_0x2b9b29){if(_0x2b9b29){_0x1c9e3d=_[_0xb012('0x6d')](_0x2b9b29,'id');var _0x44a89d;var _0x5286d0=squel[_0xb012('0x6e')]();_0x5286d0[_0xb012('0x6f')](_0x267e46[_0xb012('0x70')]);for(var _0x2e6128=0x0;_0x2e6128<_0x56a6f2['length'];_0x2e6128+=0x1){_0x44a89d=_0x56a6f2[_0x2e6128][_0xb012('0x71')]?_0x1c9e3d[_0x56a6f2[_0x2e6128]['MetricId']][_0xb012('0x72')]:_0x56a6f2[_0x2e6128][_0xb012('0x73')];_0x44a89d=_0x56a6f2[_0x2e6128]['function']?_['replace'](_0x52f1b7[_0x56a6f2[_0x2e6128][_0xb012('0x74')]],'%s',_0x44a89d):_0x44a89d;_0x44a89d=_0x56a6f2[_0x2e6128][_0xb012('0x75')]?_[_0xb012('0x76')](_0x508be6[_0x56a6f2[_0x2e6128][_0xb012('0x75')]],'%s',_0x44a89d):_0x44a89d;if(_0x56a6f2[_0x2e6128][_0xb012('0x77')]){_0x5286d0[_0xb012('0x66')](_0x44a89d);}_0x56a6f2[_0x2e6128][_0xb012('0x78')]&&_0x5286d0[_0xb012('0x79')](_0x44a89d,_0x56a6f2[_0x2e6128][_0xb012('0x78')]===_0xb012('0x7a')?![]:!![]);_0x5286d0[_0xb012('0x73')](_0x44a89d,_0x56a6f2[_0x2e6128][_0xb012('0x7b')]||_0x44a89d);}if(_0x267e46[_0xb012('0x7c')]){_0x267e46[_0xb012('0x7c')]=JSON[_0xb012('0x7d')](_0x267e46[_0xb012('0x7c')]);for(var _0x5aeed8=0x0;_0x5aeed8<_0x267e46[_0xb012('0x7c')][_0xb012('0x64')];_0x5aeed8+=0x1){if(_0x267e46[_0xb012('0x7c')][_0x5aeed8]['type']&&_['includes'](_0x23c6fc,_0x267e46['joins'][_0x5aeed8][_0xb012('0x30')])&&_0x267e46[_0xb012('0x7c')][_0x5aeed8][_0xb012('0x7e')]&&_0x267e46[_0xb012('0x7c')][_0x5aeed8]['foreignTable']&&_0x267e46['joins'][_0x5aeed8][_0xb012('0x7f')]){_0x5286d0[_0x267e46[_0xb012('0x7c')][_0x5aeed8][_0xb012('0x30')]](_0x267e46[_0xb012('0x7c')][_0x5aeed8][_0xb012('0x80')],null,util[_0xb012('0x75')](_0xb012('0x81'),_0x267e46['table'],_0x267e46['joins'][_0x5aeed8][_0xb012('0x7e')],_0x267e46['joins'][_0x5aeed8][_0xb012('0x80')],_0x267e46[_0xb012('0x7c')][_0x5aeed8][_0xb012('0x7f')]));}}}if(_0x267e46['conditions']){_0x267e46[_0xb012('0x82')]=JSON[_0xb012('0x7d')](_0x267e46['conditions']);_0x5286d0[_0xb012('0x3a')](_0x3c213e(_0x267e46[_0xb012('0x82')][_0xb012('0x66')]));}_0x2ed666=_0x5286d0[_0xb012('0x83')]();_0x5286d0[_0xb012('0x1e')](_0x5abb2d);_0x5286d0[_0xb012('0x1b')](0x0);logger['debug'](_0xb012('0x84'),_0x5286d0[_0xb012('0x85')]());return dbH[_0xb012('0x86')][_0xb012('0x33')](_0x5286d0['toString'](),{'type':dbH[_0xb012('0x86')][_0xb012('0x87')][_0xb012('0x88')]});}})[_0xb012('0x25')](respondWithResult(_0x165ea3,null))[_0xb012('0x44')](handleError(_0x165ea3,null));};function runReport(_0x5d2c4d,_0x229517,_0xa91891){var _0x10bf1c=_0x229517['name'];var _0x3559d8=0xa;var _0x10c9a0=[_0xb012('0x4f'),_0xb012('0x89'),_0xb012('0x50'),_0xb012('0x51')];var _0x301fa5={'SUM':'SUM(%s)','COUNT':_0xb012('0x53'),'COUNT DISTINCT':_0xb012('0x54'),'MAX':_0xb012('0x55'),'MIN':'MIN(%s)','AVG':_0xb012('0x56'),'GROUP_CONCAT':_0xb012('0x57'),'GROUP_CONCAT ASC':_0xb012('0x58'),'GROUP_CONCAT DESC':_0xb012('0x59')};var _0xde636b={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0xb012('0x5b'),'HOUR':'HOUR(%s)','ROUND':_0xb012('0x5d'),'UNIX_TIMESTAMP':_0xb012('0x5e')};var _0x3b582b=function(_0x36efe1){return!_['includes']([_0xb012('0x60'),_0xb012('0x8a'),_0xb012('0x61'),_0xb012('0x62')],_0x36efe1);};var _0x45e890=function(_0x4d9c67){if(!_0x4d9c67||!_0x4d9c67['rules'][_0xb012('0x64')]){return'';}for(var _0x31e835='(',_0x2fae49=0x0;_0x2fae49<_0x4d9c67[_0xb012('0x63')][_0xb012('0x64')];_0x2fae49+=0x1){_0x2fae49>0x0&&(_0x31e835+='\x20'+_0x4d9c67[_0xb012('0x65')]+'\x20');_0x31e835+=_0x4d9c67[_0xb012('0x63')][_0x2fae49][_0xb012('0x66')]?_0x45e890(_0x4d9c67[_0xb012('0x63')][_0x2fae49]['group']):_0x4d9c67[_0xb012('0x63')][_0x2fae49][_0xb012('0x73')]+'\x20'+_0x4d9c67[_0xb012('0x63')][_0x2fae49]['condition']+(_0x3b582b(_0x4d9c67[_0xb012('0x63')][_0x2fae49][_0xb012('0x67')])?'\x20'+_0x4d9c67[_0xb012('0x63')][_0x2fae49][_0xb012('0x68')]:'');}return _0x31e835+')';};var _0x35c1bb={'where':{'id':_0x5d2c4d['id']}},_0x19b9f9,_0x5deb65,_0x46a67d,_0x21efb7,_0x28a7c6;_0x35c1bb=_[_0xb012('0x3c')]({},_0x35c1bb,_0xa91891);return db['AnalyticCustomReport']['find'](_0x35c1bb)[_0xb012('0x25')](function(_0x3ac25e){if(_0x3ac25e){_0x19b9f9=_0x3ac25e;return _0x3ac25e['getFields']();}return null;})['then'](function(_0x27391f){if(_0x27391f){if(!_0x27391f[_0xb012('0x64')]){throw new db[(_0xb012('0x69'))][(_0xb012('0x6a'))](_0xb012('0x6b'),0x193);}_0x5deb65=_0x27391f;return db['AnalyticMetric'][_0xb012('0x8b')]({'raw':!![]});}return null;})[_0xb012('0x25')](function(_0x25aa8e){if(_0x25aa8e){_0x46a67d=_['keyBy'](_0x25aa8e,'id');var _0x137af8;var _0x3fe241=squel[_0xb012('0x6e')]();_0x3fe241[_0xb012('0x6f')](_0x19b9f9['table']);for(var _0x375732=0x0;_0x375732<_0x5deb65[_0xb012('0x64')];_0x375732+=0x1){_0x137af8=_0x5deb65[_0x375732][_0xb012('0x71')]?_0x46a67d[_0x5deb65[_0x375732][_0xb012('0x71')]][_0xb012('0x72')]:_0x5deb65[_0x375732][_0xb012('0x73')];_0x137af8=_0x5deb65[_0x375732][_0xb012('0x74')]?_[_0xb012('0x76')](_0x301fa5[_0x5deb65[_0x375732][_0xb012('0x74')]],'%s',_0x137af8):_0x137af8;_0x137af8=_0x5deb65[_0x375732][_0xb012('0x75')]?_[_0xb012('0x76')](_0xde636b[_0x5deb65[_0x375732][_0xb012('0x75')]],'%s',_0x137af8):_0x137af8;if(_0x5deb65[_0x375732]['groupBy']){_0x3fe241['group'](_0x137af8);}_0x5deb65[_0x375732][_0xb012('0x78')]&&_0x3fe241[_0xb012('0x79')](_0x137af8,_0x5deb65[_0x375732][_0xb012('0x78')]===_0xb012('0x7a')?![]:!![]);_0x3fe241[_0xb012('0x73')](_0x137af8,_0x5deb65[_0x375732][_0xb012('0x7b')]||_0x137af8);}if(_0x19b9f9[_0xb012('0x7c')]){_0x19b9f9[_0xb012('0x7c')]=JSON[_0xb012('0x7d')](_0x19b9f9[_0xb012('0x7c')]);for(var _0x53d9f4=0x0;_0x53d9f4<_0x19b9f9[_0xb012('0x7c')][_0xb012('0x64')];_0x53d9f4+=0x1){if(_0x19b9f9[_0xb012('0x7c')][_0x53d9f4][_0xb012('0x30')]&&_[_0xb012('0x5f')](_0x10c9a0,_0x19b9f9[_0xb012('0x7c')][_0x53d9f4][_0xb012('0x30')])&&_0x19b9f9[_0xb012('0x7c')][_0x53d9f4][_0xb012('0x7e')]&&_0x19b9f9[_0xb012('0x7c')][_0x53d9f4][_0xb012('0x80')]&&_0x19b9f9[_0xb012('0x7c')][_0x53d9f4][_0xb012('0x7f')]){_0x3fe241[_0x19b9f9[_0xb012('0x7c')][_0x53d9f4][_0xb012('0x30')]](_0x19b9f9[_0xb012('0x7c')][_0x53d9f4][_0xb012('0x80')],null,util[_0xb012('0x75')](_0xb012('0x81'),_0x19b9f9[_0xb012('0x70')],_0x19b9f9[_0xb012('0x7c')][_0x53d9f4]['parentKey'],_0x19b9f9['joins'][_0x53d9f4][_0xb012('0x80')],_0x19b9f9['joins'][_0x53d9f4]['foreignKey']));}}}if(_0x19b9f9[_0xb012('0x82')]){_0x19b9f9['conditions']=JSON[_0xb012('0x7d')](_0x19b9f9[_0xb012('0x82')]);_0x3fe241[_0xb012('0x3a')](_0x45e890(_0x19b9f9[_0xb012('0x82')][_0xb012('0x66')]));}_0x28a7c6=_0x3fe241[_0xb012('0x83')]();_0x3fe241['limit'](_0x3559d8);_0x3fe241[_0xb012('0x1b')](0x0);return;}})[_0xb012('0x25')](function(){if(_0x229517[_0xb012('0x8c')]==='web'){return null;}var _0x4ee182=_['merge'](_0x229517,{'name':_0x229517[_0xb012('0x8d')]||_0x229517[_0xb012('0x2a')]||_0x19b9f9[_0xb012('0x2a')],'basename':_0x10bf1c,'savename':util['format'](_0xb012('0x8e'),_0x229517[_0xb012('0x2a')]||_0x19b9f9[_0xb012('0x2a')],require('randomstring')[_0xb012('0x8f')](0x4),_0x229517[_0xb012('0x8c')]||_0xb012('0x90')),'reportId':_0x19b9f9['id'],'reportType':'custom'});return db[_0xb012('0x91')]['create'](_0x4ee182,{'raw':!![]});})[_0xb012('0x25')](function(_0x1a826e){if(_0x19b9f9[_0xb012('0x70')]===_0xb012('0x92')){_0x28a7c6['where'](_0x19b9f9[_0xb012('0x70')]+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x229517[_0xb012('0x93')],_0x229517[_0xb012('0x94')]);}else{_0x28a7c6[_0xb012('0x3a')](_0x19b9f9[_0xb012('0x70')]+_0xb012('0x95'),_0x229517[_0xb012('0x93')],_0x229517[_0xb012('0x94')]);}if(_0x1a826e){logger[_0xb012('0x96')](_0xb012('0x97'),_0x28a7c6[_0xb012('0x85')]());require('child_process')[_0xb012('0x98')](path[_0xb012('0x4f')](__dirname,_0xb012('0x99'),_0x1a826e[_0xb012('0x8c')]),[_0x1a826e['id'],_0x28a7c6[_0xb012('0x85')](),path[_0xb012('0x4f')](__dirname,_0xb012('0x9a'),_0x1a826e[_0xb012('0x9b')]),_0x10bf1c]);return _0x1a826e;}else{var _0x527ff8=squel[_0xb012('0x6e')]();_0x527ff8[_0xb012('0x6f')]('('+_0x28a7c6[_0xb012('0x85')]()+')','countTable');_0x527ff8['field']('COUNT(*)',_0xb012('0x1d'));_0x28a7c6[_0xb012('0x1e')](_0x229517[_0xb012('0x1e')]||_0x3559d8);_0x28a7c6['offset'](_0x229517['offset']||0x0);return dbH[_0xb012('0x86')][_0xb012('0x33')](_0x527ff8[_0xb012('0x85')](),{'type':dbH[_0xb012('0x86')]['QueryTypes']['SELECT']})[_0xb012('0x25')](function(_0x2343bc){if(!_0x2343bc[_0xb012('0x64')]){_0x21efb7=0x0;}else{_0x21efb7=_0x2343bc[0x0][_0xb012('0x1d')]||0x0;}return dbH[_0xb012('0x86')][_0xb012('0x33')](_0x28a7c6[_0xb012('0x85')](),{'type':dbH[_0xb012('0x86')]['QueryTypes'][_0xb012('0x88')]});})[_0xb012('0x25')](function(_0x4484cb){return{'rows':_0x4484cb||[],'count':_0x21efb7};});}});}exports[_0xb012('0x9c')]=function(_0x20e555,_0x36c999){return runReport(_0x20e555['params'],_0x20e555['query'],_0x20e555[_0xb012('0x3d')])[_0xb012('0x25')](respondWithResult(_0x36c999,null))[_0xb012('0x44')](handleError(_0x36c999,null));};exports['runReport']=runReport;exports[_0xb012('0x33')]=function(_0x326955,_0x5cfcd7){var _0x5ded9a=0xa;var _0xca4849=['join','left_join',_0xb012('0x50'),'cross_join'];var _0x809313={'SUM':_0xb012('0x52'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0xb012('0x54'),'MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':_0xb012('0x56'),'GROUP_CONCAT':_0xb012('0x57'),'GROUP_CONCAT ASC':_0xb012('0x58'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x42bb62={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0xb012('0x5b'),'HOUR':_0xb012('0x5c'),'ROUND':_0xb012('0x5d'),'UNIX_TIMESTAMP':_0xb012('0x5e')};var _0x4d83f4=function(_0x471732){return!_[_0xb012('0x5f')]([_0xb012('0x60'),_0xb012('0x8a'),_0xb012('0x61'),'IS\x20NOT\x20EMPTY'],_0x471732);};var _0x422665=function(_0x43d694){if(!_0x43d694||!_0x43d694[_0xb012('0x63')]['length']){return'';}for(var _0x3e9902='(',_0x1bbc2b=0x0;_0x1bbc2b<_0x43d694[_0xb012('0x63')][_0xb012('0x64')];_0x1bbc2b+=0x1){_0x1bbc2b>0x0&&(_0x3e9902+='\x20'+_0x43d694[_0xb012('0x65')]+'\x20');_0x3e9902+=_0x43d694[_0xb012('0x63')][_0x1bbc2b][_0xb012('0x66')]?_0x422665(_0x43d694[_0xb012('0x63')][_0x1bbc2b][_0xb012('0x66')]):_0x43d694[_0xb012('0x63')][_0x1bbc2b][_0xb012('0x73')]+'\x20'+_0x43d694['rules'][_0x1bbc2b][_0xb012('0x67')]+(_0x4d83f4(_0x43d694['rules'][_0x1bbc2b][_0xb012('0x67')])?'\x20'+_0x43d694['rules'][_0x1bbc2b][_0xb012('0x68')]:'');}return _0x3e9902+')';};var _0x30e334={'where':{'id':_0x326955[_0xb012('0x40')]['id']}},_0x2a4e96,_0x43376d,_0x4910f6,_0xa08599,_0x4a3932;_0x30e334=_[_0xb012('0x3c')]({},_0x30e334,_0x326955[_0xb012('0x3d')]);return db[_0xb012('0x2d')][_0xb012('0x43')](_0x30e334)[_0xb012('0x25')](function(_0x1d5c32){if(_0x1d5c32){_0x2a4e96=_0x1d5c32;return _0x1d5c32['getFields']();}return null;})[_0xb012('0x25')](function(_0x3ec7f3){if(_0x3ec7f3){if(!_0x3ec7f3[_0xb012('0x64')]){throw new db['Sequelize']['ValidationErrorItem'](_0xb012('0x6b'),0x193);}_0x43376d=_0x3ec7f3;return db[_0xb012('0x6c')][_0xb012('0x8b')]({'raw':!![]});}return null;})[_0xb012('0x25')](function(_0x10fbbf){if(_0x10fbbf){_0x4910f6=_[_0xb012('0x6d')](_0x10fbbf,'id');var _0x501cfc;var _0x3f0c85=squel['select']();_0x3f0c85[_0xb012('0x6f')](_0x2a4e96[_0xb012('0x70')]);for(var _0x4ec41b=0x0;_0x4ec41b<_0x43376d[_0xb012('0x64')];_0x4ec41b+=0x1){_0x501cfc=_0x43376d[_0x4ec41b][_0xb012('0x71')]?_0x4910f6[_0x43376d[_0x4ec41b][_0xb012('0x71')]][_0xb012('0x72')]:_0x43376d[_0x4ec41b]['field'];_0x501cfc=_0x43376d[_0x4ec41b][_0xb012('0x74')]?_[_0xb012('0x76')](_0x809313[_0x43376d[_0x4ec41b][_0xb012('0x74')]],'%s',_0x501cfc):_0x501cfc;_0x501cfc=_0x43376d[_0x4ec41b][_0xb012('0x75')]?_[_0xb012('0x76')](_0x42bb62[_0x43376d[_0x4ec41b][_0xb012('0x75')]],'%s',_0x501cfc):_0x501cfc;if(_0x43376d[_0x4ec41b][_0xb012('0x77')]){_0x3f0c85[_0xb012('0x66')](_0x501cfc);}_0x43376d[_0x4ec41b][_0xb012('0x78')]&&_0x3f0c85[_0xb012('0x79')](_0x501cfc,_0x43376d[_0x4ec41b][_0xb012('0x78')]==='DESC'?![]:!![]);_0x3f0c85['field'](_0x501cfc,_0x43376d[_0x4ec41b][_0xb012('0x7b')]||_0x501cfc);}if(_0x2a4e96[_0xb012('0x7c')]){_0x2a4e96[_0xb012('0x7c')]=JSON['parse'](_0x2a4e96[_0xb012('0x7c')]);for(var _0x58a7a2=0x0;_0x58a7a2<_0x2a4e96['joins'][_0xb012('0x64')];_0x58a7a2+=0x1){if(_0x2a4e96[_0xb012('0x7c')][_0x58a7a2]['type']&&_[_0xb012('0x5f')](_0xca4849,_0x2a4e96[_0xb012('0x7c')][_0x58a7a2][_0xb012('0x30')])&&_0x2a4e96[_0xb012('0x7c')][_0x58a7a2]['parentKey']&&_0x2a4e96['joins'][_0x58a7a2]['foreignTable']&&_0x2a4e96[_0xb012('0x7c')][_0x58a7a2][_0xb012('0x7f')]){_0x3f0c85[_0x2a4e96[_0xb012('0x7c')][_0x58a7a2]['type']](_0x2a4e96[_0xb012('0x7c')][_0x58a7a2][_0xb012('0x80')],null,util[_0xb012('0x75')]('%s.%s\x20=\x20%s.%s',_0x2a4e96[_0xb012('0x70')],_0x2a4e96[_0xb012('0x7c')][_0x58a7a2][_0xb012('0x7e')],_0x2a4e96[_0xb012('0x7c')][_0x58a7a2][_0xb012('0x80')],_0x2a4e96[_0xb012('0x7c')][_0x58a7a2][_0xb012('0x7f')]));}}}if(_0x2a4e96['conditions']){_0x2a4e96[_0xb012('0x82')]=JSON[_0xb012('0x7d')](_0x2a4e96['conditions']);_0x3f0c85[_0xb012('0x3a')](_0x422665(_0x2a4e96[_0xb012('0x82')]['group']));}_0x4a3932=_0x3f0c85[_0xb012('0x83')]();_0x3f0c85['limit'](_0x5ded9a);_0x3f0c85['offset'](0x0);logger['debug'](_0xb012('0x84'),_0x3f0c85[_0xb012('0x85')]());return dbH[_0xb012('0x86')][_0xb012('0x33')](_0x3f0c85[_0xb012('0x85')](),{'type':dbH[_0xb012('0x86')][_0xb012('0x87')][_0xb012('0x88')]});}})['then'](function(){return{'sql':_0x4a3932[_0xb012('0x85')]()};})[_0xb012('0x25')](respondWithResult(_0x5cfcd7,null))[_0xb012('0x44')](handleError(_0x5cfcd7,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff