// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xbeb2=['destroy','UserProfileResource','end','stack','name','index','map','AnalyticCustomReport','rawAttributes','fieldName','key','model','keys','filters','intersection','query','fields','attributes','hasOwnProperty','sort','where','filter','merge','type','includeAll','include','findAll','rows','catch','show','params','find','create','body','user','get','Reports','userProfileId','CustomReports','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','preview','join','left_join','right_join','cross_join','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)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20NOT\x20EMPTY','rules','length','operator','group','field','condition','value','options','getFields','Sequelize','ValidationErrorItem','AnalyticMetric','keyBy','table','MetricId','function','replace','format','groupBy','orderBy','order','DESC','joins','parse','foreignKey','foreignTable','%s.%s\x20=\x20%s.%s','parentKey','conditions','clone','debug','Limited\x20Query:','sequelize','QueryTypes','SUM(%s)','HOUR(%s)','IS\x20EMPTY','Please\x20insert\x20at\x20least\x20one\x20field','select','from','metric','alias','output','%s-%s.%s','randomstring','generate','custom','cdr','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','child_process','fork','../../components/export/','toString','../../files/reports','savename','countTable','COUNT(*)','SELECT','run','runReport','COUNT(%s)','rimraf','zip-dir','bluebird','mustache','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../mysqldb','sendStatus','status','json','offset','limit','undefined','count','set','Content-Range','apply','reject','save','then'];(function(_0x1a0e44,_0x2492ee){var _0x4db347=function(_0x51ae55){while(--_0x51ae55){_0x1a0e44['push'](_0x1a0e44['shift']());}};_0x4db347(++_0x2492ee);}(_0xbeb2,0x1ba));var _0x2beb=function(_0x1aa52b,_0x4665e2){_0x1aa52b=_0x1aa52b-0x0;var _0x3201ab=_0xbeb2[_0x1aa52b];return _0x3201ab;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x2beb('0x0'));var zipdir=require(_0x2beb('0x1'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0x2beb('0x2'));var Mustache=require(_0x2beb('0x3'));var util=require('util');var path=require('path');var sox=require(_0x2beb('0x4'));var csv=require(_0x2beb('0x5'));var ejs=require(_0x2beb('0x6'));var fs=require('fs');var fs_extra=require(_0x2beb('0x7'));var _=require(_0x2beb('0x8'));var squel=require(_0x2beb('0x9'));var crypto=require(_0x2beb('0xa'));var jsforce=require(_0x2beb('0xb'));var deskjs=require(_0x2beb('0xc'));var toCsv=require(_0x2beb('0x5'));var querystring=require(_0x2beb('0xd'));var Papa=require(_0x2beb('0xe'));var Redis=require(_0x2beb('0xf'));var authService=require(_0x2beb('0x10'));var qs=require('../../components/parsers/qs');var as=require(_0x2beb('0x11'));var hardwareService=require(_0x2beb('0x12'));var logger=require(_0x2beb('0x13'))('api');var utils=require(_0x2beb('0x14'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require(_0x2beb('0x15'))['db'];var dbH=require(_0x2beb('0x15'))['dbH'];function respondWithStatusCode(_0x1ecd30,_0x55305c){_0x55305c=_0x55305c||0xcc;return function(_0x36e48b){if(_0x36e48b){return _0x1ecd30[_0x2beb('0x16')](_0x55305c);}return _0x1ecd30[_0x2beb('0x17')](_0x55305c)['end']();};}function respondWithResult(_0xb52087,_0x51c821){_0x51c821=_0x51c821||0xc8;return function(_0x43a9c8){if(_0x43a9c8){return _0xb52087['status'](_0x51c821)[_0x2beb('0x18')](_0x43a9c8);}};}function respondWithFilteredResult(_0x548184,_0x281cc6){return function(_0x3f399c){if(_0x3f399c){var _0x35e66e=typeof _0x281cc6[_0x2beb('0x19')]==='undefined'&&typeof _0x281cc6[_0x2beb('0x1a')]===_0x2beb('0x1b');var _0x4f3ee7=_0x3f399c['count'];var _0x2c2c34=_0x35e66e?0x0:_0x281cc6[_0x2beb('0x19')];var _0x30840c=_0x35e66e?_0x3f399c[_0x2beb('0x1c')]:_0x281cc6[_0x2beb('0x19')]+_0x281cc6[_0x2beb('0x1a')];var _0x4b85cf;if(_0x30840c>=_0x4f3ee7){_0x30840c=_0x4f3ee7;_0x4b85cf=0xc8;}else{_0x4b85cf=0xce;}_0x548184['status'](_0x4b85cf);return _0x548184[_0x2beb('0x1d')](_0x2beb('0x1e'),_0x2c2c34+'-'+_0x30840c+'/'+_0x4f3ee7)[_0x2beb('0x18')](_0x3f399c);}return null;};}function patchUpdates(_0x593da4){return function(_0xc063f2){try{jsonpatch[_0x2beb('0x1f')](_0xc063f2,_0x593da4,!![]);}catch(_0x4f4c71){return BPromise[_0x2beb('0x20')](_0x4f4c71);}return _0xc063f2[_0x2beb('0x21')]();};}function saveUpdates(_0x21d364,_0x84740d){return function(_0x92b55f){if(_0x92b55f){return _0x92b55f['update'](_0x21d364)[_0x2beb('0x22')](function(_0x5bf0b8){return _0x5bf0b8;});}return null;};}function removeEntity(_0x4cb1b5,_0x15b35b){return function(_0x532925){if(_0x532925){return _0x532925[_0x2beb('0x23')]()[_0x2beb('0x22')](function(){var _0x27162c=_0x532925['get']({'plain':!![]});var _0x235f81='CustomReports';return db[_0x2beb('0x24')][_0x2beb('0x23')]({'where':{'type':_0x235f81,'resourceId':_0x27162c['id']}})[_0x2beb('0x22')](function(){return _0x532925;});})[_0x2beb('0x22')](function(){_0x4cb1b5[_0x2beb('0x17')](0xcc)[_0x2beb('0x25')]();});}};}function handleEntityNotFound(_0x17b97c,_0x31151c){return function(_0x1b199c){if(!_0x1b199c){_0x17b97c[_0x2beb('0x16')](0x194);}return _0x1b199c;};}function handleError(_0x427f65,_0x48649b){_0x48649b=_0x48649b||0x1f4;return function(_0x2dc6d4){logger['error'](_0x2dc6d4[_0x2beb('0x26')]);if(_0x2dc6d4[_0x2beb('0x27')]){delete _0x2dc6d4[_0x2beb('0x27')];}_0x427f65['status'](_0x48649b)['send'](_0x2dc6d4);};}exports[_0x2beb('0x28')]=function(_0x38ac5a,_0x5b022e){var _0x3ab779={},_0x296d04={},_0x41a68f={'count':0x0,'rows':[]};var _0x4e136d=_[_0x2beb('0x29')](db[_0x2beb('0x2a')][_0x2beb('0x2b')],function(_0x1fc7d0){return{'name':_0x1fc7d0[_0x2beb('0x2c')],'type':_0x1fc7d0['type'][_0x2beb('0x2d')]};});_0x296d04[_0x2beb('0x2e')]=_[_0x2beb('0x29')](_0x4e136d,_0x2beb('0x27'));_0x296d04['query']=_[_0x2beb('0x2f')](_0x38ac5a['query']);_0x296d04[_0x2beb('0x30')]=_[_0x2beb('0x31')](_0x296d04[_0x2beb('0x2e')],_0x296d04[_0x2beb('0x32')]);_0x3ab779['attributes']=_[_0x2beb('0x31')](_0x296d04[_0x2beb('0x2e')],qs['fields'](_0x38ac5a['query'][_0x2beb('0x33')]));_0x3ab779[_0x2beb('0x34')]=_0x3ab779['attributes']['length']?_0x3ab779[_0x2beb('0x34')]:_0x296d04[_0x2beb('0x2e')];if(!_0x38ac5a[_0x2beb('0x32')][_0x2beb('0x35')]('nolimit')){_0x3ab779[_0x2beb('0x1a')]=qs['limit'](_0x38ac5a[_0x2beb('0x32')][_0x2beb('0x1a')]);_0x3ab779[_0x2beb('0x19')]=qs[_0x2beb('0x19')](_0x38ac5a['query']['offset']);}_0x3ab779['order']=qs[_0x2beb('0x36')](_0x38ac5a[_0x2beb('0x32')][_0x2beb('0x36')]);_0x3ab779[_0x2beb('0x37')]=qs['filters'](_['pick'](_0x38ac5a[_0x2beb('0x32')],_0x296d04[_0x2beb('0x30')]),_0x4e136d);if(_0x38ac5a[_0x2beb('0x32')][_0x2beb('0x38')]){_0x3ab779[_0x2beb('0x37')]=_[_0x2beb('0x39')](_0x3ab779['where'],{'$or':_[_0x2beb('0x29')](_0x4e136d,function(_0x1d05a6){if(_0x1d05a6[_0x2beb('0x3a')]!=='VIRTUAL'){var _0x4c28ea={};_0x4c28ea[_0x1d05a6[_0x2beb('0x27')]]={'$like':'%'+_0x38ac5a['query'][_0x2beb('0x38')]+'%'};return _0x4c28ea;}})});}_0x3ab779=_[_0x2beb('0x39')]({},_0x3ab779,_0x38ac5a['options']);var _0x3f7151={'where':_0x3ab779[_0x2beb('0x37')]};return db[_0x2beb('0x2a')][_0x2beb('0x1c')](_0x3f7151)[_0x2beb('0x22')](function(_0xdb9edf){_0x41a68f[_0x2beb('0x1c')]=_0xdb9edf;if(_0x38ac5a[_0x2beb('0x32')][_0x2beb('0x3b')]){_0x3ab779[_0x2beb('0x3c')]=[{'all':!![]}];}return db[_0x2beb('0x2a')][_0x2beb('0x3d')](_0x3ab779);})['then'](function(_0x569718){_0x41a68f[_0x2beb('0x3e')]=_0x569718;return _0x41a68f;})[_0x2beb('0x22')](respondWithFilteredResult(_0x5b022e,_0x3ab779))[_0x2beb('0x3f')](handleError(_0x5b022e,null));};exports[_0x2beb('0x40')]=function(_0x468dd4,_0x1b75ab){var _0x57110c={'raw':![],'where':{'id':_0x468dd4[_0x2beb('0x41')]['id']}},_0x669191={};_0x669191[_0x2beb('0x2e')]=_['keys'](db[_0x2beb('0x2a')][_0x2beb('0x2b')]);_0x669191[_0x2beb('0x32')]=_[_0x2beb('0x2f')](_0x468dd4[_0x2beb('0x32')]);_0x669191[_0x2beb('0x30')]=_[_0x2beb('0x31')](_0x669191[_0x2beb('0x2e')],_0x669191[_0x2beb('0x32')]);_0x57110c['attributes']=_[_0x2beb('0x31')](_0x669191['model'],qs[_0x2beb('0x33')](_0x468dd4[_0x2beb('0x32')][_0x2beb('0x33')]));_0x57110c[_0x2beb('0x34')]=_0x57110c[_0x2beb('0x34')]['length']?_0x57110c[_0x2beb('0x34')]:_0x669191[_0x2beb('0x2e')];if(_0x468dd4[_0x2beb('0x32')]['includeAll']){_0x57110c[_0x2beb('0x3c')]=[{'all':!![]}];}_0x57110c=_['merge']({},_0x57110c,_0x468dd4['options']);return db['AnalyticCustomReport'][_0x2beb('0x42')](_0x57110c)['then'](handleEntityNotFound(_0x1b75ab,null))[_0x2beb('0x22')](respondWithResult(_0x1b75ab,null))[_0x2beb('0x3f')](handleError(_0x1b75ab,null));};exports[_0x2beb('0x43')]=function(_0x517638,_0x38a149){return db['AnalyticCustomReport'][_0x2beb('0x43')](_0x517638[_0x2beb('0x44')],{})['then'](function(_0x1bf2e2){var _0x144ca3=_0x517638[_0x2beb('0x45')][_0x2beb('0x46')]({'plain':!![]});if(!_0x144ca3)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x144ca3['role']===_0x2beb('0x45')){var _0x2293ec=_0x1bf2e2['get']({'plain':!![]});var _0x7107c=_0x2beb('0x47');return db['UserProfileSection'][_0x2beb('0x42')]({'where':{'name':_0x7107c,'userProfileId':_0x144ca3[_0x2beb('0x48')]},'raw':!![]})['then'](function(_0x439edd){if(_0x439edd&&_0x439edd['autoAssociation']===0x0){return db[_0x2beb('0x24')]['create']({'name':_0x2293ec[_0x2beb('0x27')],'resourceId':_0x2293ec['id'],'type':_0x2beb('0x49'),'sectionId':_0x439edd['id']},{})[_0x2beb('0x22')](function(){return _0x1bf2e2;});}else{return _0x1bf2e2;}})[_0x2beb('0x3f')](function(_0x27a56e){logger[_0x2beb('0x4a')](_0x2beb('0x4b'),_0x27a56e);throw _0x27a56e;});}return _0x1bf2e2;})[_0x2beb('0x22')](respondWithResult(_0x38a149,0xc9))[_0x2beb('0x3f')](handleError(_0x38a149,null));};exports['update']=function(_0x46ba81,_0x4831a3){if(_0x46ba81[_0x2beb('0x44')]['id']){delete _0x46ba81[_0x2beb('0x44')]['id'];}return db['AnalyticCustomReport'][_0x2beb('0x42')]({'where':{'id':_0x46ba81[_0x2beb('0x41')]['id']}})[_0x2beb('0x22')](handleEntityNotFound(_0x4831a3,null))[_0x2beb('0x22')](saveUpdates(_0x46ba81['body'],null))[_0x2beb('0x22')](respondWithResult(_0x4831a3,null))[_0x2beb('0x3f')](handleError(_0x4831a3,null));};exports[_0x2beb('0x23')]=function(_0x14c078,_0x29cad0){return db[_0x2beb('0x2a')][_0x2beb('0x42')]({'where':{'id':_0x14c078['params']['id']}})[_0x2beb('0x22')](handleEntityNotFound(_0x29cad0,null))[_0x2beb('0x22')](removeEntity(_0x29cad0,null))[_0x2beb('0x3f')](handleError(_0x29cad0,null));};exports[_0x2beb('0x4c')]=function(_0x1211c1,_0xff2664){var _0x160bb0=0xa;var _0x5d5e79=[_0x2beb('0x4d'),_0x2beb('0x4e'),_0x2beb('0x4f'),_0x2beb('0x50')];var _0x100b00={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT DISTINCT':_0x2beb('0x51'),'MAX':_0x2beb('0x52'),'MIN':'MIN(%s)','AVG':_0x2beb('0x53'),'GROUP_CONCAT':_0x2beb('0x54'),'GROUP_CONCAT ASC':_0x2beb('0x55'),'GROUP_CONCAT DESC':_0x2beb('0x56')};var _0x1d6390={'SEC_TO_TIME':_0x2beb('0x57'),'DATE':_0x2beb('0x58'),'HOUR':'HOUR(%s)','ROUND':_0x2beb('0x59'),'UNIX_TIMESTAMP':_0x2beb('0x5a')};var _0x124830=function(_0x3cd80c){return!_[_0x2beb('0x5b')]([_0x2beb('0x5c'),_0x2beb('0x5d'),'IS\x20EMPTY',_0x2beb('0x5e')],_0x3cd80c);};var _0x14b93c=function(_0x5076cc){if(!_0x5076cc||!_0x5076cc[_0x2beb('0x5f')][_0x2beb('0x60')]){return'';}for(var _0x50a1ee='(',_0x17f877=0x0;_0x17f877<_0x5076cc['rules']['length'];_0x17f877+=0x1){_0x17f877>0x0&&(_0x50a1ee+='\x20'+_0x5076cc[_0x2beb('0x61')]+'\x20');_0x50a1ee+=_0x5076cc['rules'][_0x17f877]['group']?_0x14b93c(_0x5076cc['rules'][_0x17f877][_0x2beb('0x62')]):_0x5076cc[_0x2beb('0x5f')][_0x17f877][_0x2beb('0x63')]+'\x20'+_0x5076cc[_0x2beb('0x5f')][_0x17f877][_0x2beb('0x64')]+(_0x124830(_0x5076cc[_0x2beb('0x5f')][_0x17f877][_0x2beb('0x64')])?'\x20'+_0x5076cc[_0x2beb('0x5f')][_0x17f877][_0x2beb('0x65')]:'');}return _0x50a1ee+')';};var _0xae979={'where':{'id':_0x1211c1['params']['id']}},_0x9f6a9b,_0x5975bf,_0x2abbd8,_0x18f305,_0x305274;_0xae979=_['merge']({},_0xae979,_0x1211c1[_0x2beb('0x66')]);return db[_0x2beb('0x2a')][_0x2beb('0x42')](_0xae979)[_0x2beb('0x22')](function(_0x38c36d){if(_0x38c36d){_0x9f6a9b=_0x38c36d;return _0x38c36d[_0x2beb('0x67')]();}return null;})[_0x2beb('0x22')](function(_0x19e3e2){if(_0x19e3e2){if(!_0x19e3e2[_0x2beb('0x60')]){throw new db[(_0x2beb('0x68'))][(_0x2beb('0x69'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x5975bf=_0x19e3e2;return db[_0x2beb('0x6a')]['findAll']({'raw':!![]});}return null;})['then'](function(_0x2448fe){if(_0x2448fe){_0x2abbd8=_[_0x2beb('0x6b')](_0x2448fe,'id');var _0x20fa29;var _0x148af8=squel['select']();_0x148af8['from'](_0x9f6a9b[_0x2beb('0x6c')]);for(var _0x4057bd=0x0;_0x4057bd<_0x5975bf[_0x2beb('0x60')];_0x4057bd+=0x1){_0x20fa29=_0x5975bf[_0x4057bd][_0x2beb('0x6d')]?_0x2abbd8[_0x5975bf[_0x4057bd][_0x2beb('0x6d')]]['metric']:_0x5975bf[_0x4057bd][_0x2beb('0x63')];_0x20fa29=_0x5975bf[_0x4057bd][_0x2beb('0x6e')]?_[_0x2beb('0x6f')](_0x100b00[_0x5975bf[_0x4057bd][_0x2beb('0x6e')]],'%s',_0x20fa29):_0x20fa29;_0x20fa29=_0x5975bf[_0x4057bd][_0x2beb('0x70')]?_['replace'](_0x1d6390[_0x5975bf[_0x4057bd][_0x2beb('0x70')]],'%s',_0x20fa29):_0x20fa29;if(_0x5975bf[_0x4057bd][_0x2beb('0x71')]){_0x148af8[_0x2beb('0x62')](_0x20fa29);}_0x5975bf[_0x4057bd][_0x2beb('0x72')]&&_0x148af8[_0x2beb('0x73')](_0x20fa29,_0x5975bf[_0x4057bd][_0x2beb('0x72')]===_0x2beb('0x74')?![]:!![]);_0x148af8[_0x2beb('0x63')](_0x20fa29,_0x5975bf[_0x4057bd]['alias']||_0x20fa29);}if(_0x9f6a9b['joins']){_0x9f6a9b[_0x2beb('0x75')]=JSON[_0x2beb('0x76')](_0x9f6a9b[_0x2beb('0x75')]);for(var _0x45b449=0x0;_0x45b449<_0x9f6a9b[_0x2beb('0x75')][_0x2beb('0x60')];_0x45b449+=0x1){if(_0x9f6a9b[_0x2beb('0x75')][_0x45b449][_0x2beb('0x3a')]&&_[_0x2beb('0x5b')](_0x5d5e79,_0x9f6a9b[_0x2beb('0x75')][_0x45b449]['type'])&&_0x9f6a9b['joins'][_0x45b449]['parentKey']&&_0x9f6a9b[_0x2beb('0x75')][_0x45b449]['foreignTable']&&_0x9f6a9b['joins'][_0x45b449][_0x2beb('0x77')]){_0x148af8[_0x9f6a9b[_0x2beb('0x75')][_0x45b449][_0x2beb('0x3a')]](_0x9f6a9b[_0x2beb('0x75')][_0x45b449][_0x2beb('0x78')],null,util['format'](_0x2beb('0x79'),_0x9f6a9b[_0x2beb('0x6c')],_0x9f6a9b[_0x2beb('0x75')][_0x45b449][_0x2beb('0x7a')],_0x9f6a9b['joins'][_0x45b449][_0x2beb('0x78')],_0x9f6a9b[_0x2beb('0x75')][_0x45b449][_0x2beb('0x77')]));}}}if(_0x9f6a9b[_0x2beb('0x7b')]){_0x9f6a9b[_0x2beb('0x7b')]=JSON['parse'](_0x9f6a9b[_0x2beb('0x7b')]);_0x148af8[_0x2beb('0x37')](_0x14b93c(_0x9f6a9b[_0x2beb('0x7b')][_0x2beb('0x62')]));}_0x305274=_0x148af8[_0x2beb('0x7c')]();_0x148af8[_0x2beb('0x1a')](_0x160bb0);_0x148af8[_0x2beb('0x19')](0x0);logger[_0x2beb('0x7d')](_0x2beb('0x7e'),_0x148af8['toString']());return dbH[_0x2beb('0x7f')][_0x2beb('0x32')](_0x148af8['toString'](),{'type':dbH[_0x2beb('0x7f')][_0x2beb('0x80')]['SELECT']});}})[_0x2beb('0x22')](respondWithResult(_0xff2664,null))[_0x2beb('0x3f')](handleError(_0xff2664,null));};function runReport(_0x401ab6,_0x3ca54a,_0x1af9c6){var _0x125802=_0x3ca54a[_0x2beb('0x27')];var _0xcbc1a2=0xa;var _0x3ce371=[_0x2beb('0x4d'),'left_join',_0x2beb('0x4f'),_0x2beb('0x50')];var _0x368a13={'SUM':_0x2beb('0x81'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x2beb('0x51'),'MAX':_0x2beb('0x52'),'MIN':'MIN(%s)','AVG':_0x2beb('0x53'),'GROUP_CONCAT':_0x2beb('0x54'),'GROUP_CONCAT ASC':_0x2beb('0x55'),'GROUP_CONCAT DESC':_0x2beb('0x56')};var _0xc74e0d={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x2beb('0x58'),'HOUR':_0x2beb('0x82'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x2beb('0x5a')};var _0x2d3ced=function(_0x255e38){return!_['includes']([_0x2beb('0x5c'),_0x2beb('0x5d'),_0x2beb('0x83'),_0x2beb('0x5e')],_0x255e38);};var _0x459dee=function(_0x208196){if(!_0x208196||!_0x208196[_0x2beb('0x5f')][_0x2beb('0x60')]){return'';}for(var _0x3cf553='(',_0x4b0458=0x0;_0x4b0458<_0x208196[_0x2beb('0x5f')]['length'];_0x4b0458+=0x1){_0x4b0458>0x0&&(_0x3cf553+='\x20'+_0x208196[_0x2beb('0x61')]+'\x20');_0x3cf553+=_0x208196[_0x2beb('0x5f')][_0x4b0458][_0x2beb('0x62')]?_0x459dee(_0x208196['rules'][_0x4b0458]['group']):_0x208196[_0x2beb('0x5f')][_0x4b0458][_0x2beb('0x63')]+'\x20'+_0x208196['rules'][_0x4b0458][_0x2beb('0x64')]+(_0x2d3ced(_0x208196[_0x2beb('0x5f')][_0x4b0458]['condition'])?'\x20'+_0x208196['rules'][_0x4b0458][_0x2beb('0x65')]:'');}return _0x3cf553+')';};var _0x2054a2={'where':{'id':_0x401ab6['id']}},_0x30bf0f,_0x351bda,_0x37a4fc,_0x58c740,_0x53906b;_0x2054a2=_['merge']({},_0x2054a2,_0x1af9c6);return db[_0x2beb('0x2a')][_0x2beb('0x42')](_0x2054a2)[_0x2beb('0x22')](function(_0x40a94e){if(_0x40a94e){_0x30bf0f=_0x40a94e;return _0x40a94e[_0x2beb('0x67')]();}return null;})[_0x2beb('0x22')](function(_0x26aad1){if(_0x26aad1){if(!_0x26aad1[_0x2beb('0x60')]){throw new db[(_0x2beb('0x68'))][(_0x2beb('0x69'))](_0x2beb('0x84'),0x193);}_0x351bda=_0x26aad1;return db['AnalyticMetric'][_0x2beb('0x3d')]({'raw':!![]});}return null;})[_0x2beb('0x22')](function(_0x18e61c){if(_0x18e61c){_0x37a4fc=_[_0x2beb('0x6b')](_0x18e61c,'id');var _0xe600b5;var _0x23ee2e=squel[_0x2beb('0x85')]();_0x23ee2e[_0x2beb('0x86')](_0x30bf0f[_0x2beb('0x6c')]);for(var _0x51de54=0x0;_0x51de54<_0x351bda[_0x2beb('0x60')];_0x51de54+=0x1){_0xe600b5=_0x351bda[_0x51de54][_0x2beb('0x6d')]?_0x37a4fc[_0x351bda[_0x51de54][_0x2beb('0x6d')]][_0x2beb('0x87')]:_0x351bda[_0x51de54][_0x2beb('0x63')];_0xe600b5=_0x351bda[_0x51de54][_0x2beb('0x6e')]?_[_0x2beb('0x6f')](_0x368a13[_0x351bda[_0x51de54][_0x2beb('0x6e')]],'%s',_0xe600b5):_0xe600b5;_0xe600b5=_0x351bda[_0x51de54][_0x2beb('0x70')]?_[_0x2beb('0x6f')](_0xc74e0d[_0x351bda[_0x51de54][_0x2beb('0x70')]],'%s',_0xe600b5):_0xe600b5;if(_0x351bda[_0x51de54]['groupBy']){_0x23ee2e[_0x2beb('0x62')](_0xe600b5);}_0x351bda[_0x51de54]['orderBy']&&_0x23ee2e[_0x2beb('0x73')](_0xe600b5,_0x351bda[_0x51de54]['orderBy']==='DESC'?![]:!![]);_0x23ee2e[_0x2beb('0x63')](_0xe600b5,_0x351bda[_0x51de54][_0x2beb('0x88')]||_0xe600b5);}if(_0x30bf0f['joins']){_0x30bf0f['joins']=JSON[_0x2beb('0x76')](_0x30bf0f[_0x2beb('0x75')]);for(var _0x2926ab=0x0;_0x2926ab<_0x30bf0f[_0x2beb('0x75')][_0x2beb('0x60')];_0x2926ab+=0x1){if(_0x30bf0f['joins'][_0x2926ab][_0x2beb('0x3a')]&&_['includes'](_0x3ce371,_0x30bf0f[_0x2beb('0x75')][_0x2926ab][_0x2beb('0x3a')])&&_0x30bf0f['joins'][_0x2926ab]['parentKey']&&_0x30bf0f['joins'][_0x2926ab]['foreignTable']&&_0x30bf0f[_0x2beb('0x75')][_0x2926ab][_0x2beb('0x77')]){_0x23ee2e[_0x30bf0f['joins'][_0x2926ab][_0x2beb('0x3a')]](_0x30bf0f['joins'][_0x2926ab][_0x2beb('0x78')],null,util[_0x2beb('0x70')](_0x2beb('0x79'),_0x30bf0f[_0x2beb('0x6c')],_0x30bf0f['joins'][_0x2926ab][_0x2beb('0x7a')],_0x30bf0f[_0x2beb('0x75')][_0x2926ab]['foreignTable'],_0x30bf0f['joins'][_0x2926ab][_0x2beb('0x77')]));}}}if(_0x30bf0f[_0x2beb('0x7b')]){_0x30bf0f[_0x2beb('0x7b')]=JSON['parse'](_0x30bf0f[_0x2beb('0x7b')]);_0x23ee2e[_0x2beb('0x37')](_0x459dee(_0x30bf0f[_0x2beb('0x7b')][_0x2beb('0x62')]));}_0x53906b=_0x23ee2e[_0x2beb('0x7c')]();_0x23ee2e['limit'](_0xcbc1a2);_0x23ee2e[_0x2beb('0x19')](0x0);return;}})[_0x2beb('0x22')](function(){if(_0x3ca54a[_0x2beb('0x89')]==='web'){return null;}var _0x433d5f=_[_0x2beb('0x39')](_0x3ca54a,{'name':_0x3ca54a['fullPath']||_0x3ca54a[_0x2beb('0x27')]||_0x30bf0f[_0x2beb('0x27')],'basename':_0x125802,'savename':util[_0x2beb('0x70')](_0x2beb('0x8a'),_0x3ca54a[_0x2beb('0x27')]||_0x30bf0f['name'],require(_0x2beb('0x8b'))[_0x2beb('0x8c')](0x4),_0x3ca54a[_0x2beb('0x89')]||'csv'),'reportId':_0x30bf0f['id'],'reportType':_0x2beb('0x8d')});return db['AnalyticExtractedReport'][_0x2beb('0x43')](_0x433d5f,{'raw':!![]});})[_0x2beb('0x22')](function(_0x394f51){if(_0x30bf0f[_0x2beb('0x6c')]===_0x2beb('0x8e')){_0x53906b[_0x2beb('0x37')](_0x30bf0f[_0x2beb('0x6c')]+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x3ca54a[_0x2beb('0x8f')],_0x3ca54a[_0x2beb('0x90')]);}else{_0x53906b['where'](_0x30bf0f[_0x2beb('0x6c')]+_0x2beb('0x91'),_0x3ca54a[_0x2beb('0x8f')],_0x3ca54a[_0x2beb('0x90')]);}if(_0x394f51){logger[_0x2beb('0x92')]('Run\x20Query:',_0x53906b['toString']());require(_0x2beb('0x93'))[_0x2beb('0x94')](path['join'](__dirname,_0x2beb('0x95'),_0x394f51[_0x2beb('0x89')]),[_0x394f51['id'],_0x53906b[_0x2beb('0x96')](),path['join'](__dirname,_0x2beb('0x97'),_0x394f51[_0x2beb('0x98')]),_0x125802]);return _0x394f51;}else{var _0x198baf=squel[_0x2beb('0x85')]();_0x198baf[_0x2beb('0x86')]('('+_0x53906b[_0x2beb('0x96')]()+')',_0x2beb('0x99'));_0x198baf[_0x2beb('0x63')](_0x2beb('0x9a'),_0x2beb('0x1c'));_0x53906b[_0x2beb('0x1a')](_0x3ca54a[_0x2beb('0x1a')]||_0xcbc1a2);_0x53906b[_0x2beb('0x19')](_0x3ca54a[_0x2beb('0x19')]||0x0);return dbH[_0x2beb('0x7f')][_0x2beb('0x32')](_0x198baf[_0x2beb('0x96')](),{'type':dbH[_0x2beb('0x7f')][_0x2beb('0x80')]['SELECT']})[_0x2beb('0x22')](function(_0x45d6b2){if(!_0x45d6b2[_0x2beb('0x60')]){_0x58c740=0x0;}else{_0x58c740=_0x45d6b2[0x0]['count']||0x0;}return dbH[_0x2beb('0x7f')][_0x2beb('0x32')](_0x53906b['toString'](),{'type':dbH[_0x2beb('0x7f')][_0x2beb('0x80')][_0x2beb('0x9b')]});})[_0x2beb('0x22')](function(_0x2de4b1){return{'rows':_0x2de4b1||[],'count':_0x58c740};});}});}exports[_0x2beb('0x9c')]=function(_0x42a53d,_0x49d527){return runReport(_0x42a53d['params'],_0x42a53d[_0x2beb('0x32')],_0x42a53d['options'])['then'](respondWithResult(_0x49d527,null))['catch'](handleError(_0x49d527,null));};exports[_0x2beb('0x9d')]=runReport;exports[_0x2beb('0x32')]=function(_0x274f1a,_0x304aa9){var _0xd9cb92=0xa;var _0x3d5df9=['join','left_join','right_join',_0x2beb('0x50')];var _0x33ab0b={'SUM':_0x2beb('0x81'),'COUNT':_0x2beb('0x9e'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x2beb('0x52'),'MIN':'MIN(%s)','AVG':'AVG(%s)','GROUP_CONCAT':_0x2beb('0x54'),'GROUP_CONCAT ASC':_0x2beb('0x55'),'GROUP_CONCAT DESC':_0x2beb('0x56')};var _0x3bcde4={'SEC_TO_TIME':_0x2beb('0x57'),'DATE':_0x2beb('0x58'),'HOUR':_0x2beb('0x82'),'ROUND':_0x2beb('0x59'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x3408fe=function(_0x2a193e){return!_['includes']([_0x2beb('0x5c'),'IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY'],_0x2a193e);};var _0x3f65fb=function(_0x3ee5f5){if(!_0x3ee5f5||!_0x3ee5f5[_0x2beb('0x5f')][_0x2beb('0x60')]){return'';}for(var _0x507f37='(',_0x1661f3=0x0;_0x1661f3<_0x3ee5f5[_0x2beb('0x5f')][_0x2beb('0x60')];_0x1661f3+=0x1){_0x1661f3>0x0&&(_0x507f37+='\x20'+_0x3ee5f5[_0x2beb('0x61')]+'\x20');_0x507f37+=_0x3ee5f5[_0x2beb('0x5f')][_0x1661f3][_0x2beb('0x62')]?_0x3f65fb(_0x3ee5f5['rules'][_0x1661f3]['group']):_0x3ee5f5[_0x2beb('0x5f')][_0x1661f3][_0x2beb('0x63')]+'\x20'+_0x3ee5f5['rules'][_0x1661f3][_0x2beb('0x64')]+(_0x3408fe(_0x3ee5f5['rules'][_0x1661f3]['condition'])?'\x20'+_0x3ee5f5['rules'][_0x1661f3][_0x2beb('0x65')]:'');}return _0x507f37+')';};var _0x57a64e={'where':{'id':_0x274f1a[_0x2beb('0x41')]['id']}},_0x464a5d,_0x2efbf9,_0x4751f0,_0x44a28e,_0x2e8a0b;_0x57a64e=_[_0x2beb('0x39')]({},_0x57a64e,_0x274f1a[_0x2beb('0x66')]);return db[_0x2beb('0x2a')]['find'](_0x57a64e)[_0x2beb('0x22')](function(_0xa2a2b5){if(_0xa2a2b5){_0x464a5d=_0xa2a2b5;return _0xa2a2b5['getFields']();}return null;})[_0x2beb('0x22')](function(_0x33fd15){if(_0x33fd15){if(!_0x33fd15[_0x2beb('0x60')]){throw new db[(_0x2beb('0x68'))][(_0x2beb('0x69'))](_0x2beb('0x84'),0x193);}_0x2efbf9=_0x33fd15;return db[_0x2beb('0x6a')][_0x2beb('0x3d')]({'raw':!![]});}return null;})[_0x2beb('0x22')](function(_0x5dbaf0){if(_0x5dbaf0){_0x4751f0=_[_0x2beb('0x6b')](_0x5dbaf0,'id');var _0x584fc9;var _0x245921=squel[_0x2beb('0x85')]();_0x245921['from'](_0x464a5d[_0x2beb('0x6c')]);for(var _0x1e7023=0x0;_0x1e7023<_0x2efbf9[_0x2beb('0x60')];_0x1e7023+=0x1){_0x584fc9=_0x2efbf9[_0x1e7023]['MetricId']?_0x4751f0[_0x2efbf9[_0x1e7023][_0x2beb('0x6d')]][_0x2beb('0x87')]:_0x2efbf9[_0x1e7023][_0x2beb('0x63')];_0x584fc9=_0x2efbf9[_0x1e7023]['function']?_['replace'](_0x33ab0b[_0x2efbf9[_0x1e7023][_0x2beb('0x6e')]],'%s',_0x584fc9):_0x584fc9;_0x584fc9=_0x2efbf9[_0x1e7023][_0x2beb('0x70')]?_[_0x2beb('0x6f')](_0x3bcde4[_0x2efbf9[_0x1e7023][_0x2beb('0x70')]],'%s',_0x584fc9):_0x584fc9;if(_0x2efbf9[_0x1e7023][_0x2beb('0x71')]){_0x245921['group'](_0x584fc9);}_0x2efbf9[_0x1e7023][_0x2beb('0x72')]&&_0x245921[_0x2beb('0x73')](_0x584fc9,_0x2efbf9[_0x1e7023][_0x2beb('0x72')]===_0x2beb('0x74')?![]:!![]);_0x245921[_0x2beb('0x63')](_0x584fc9,_0x2efbf9[_0x1e7023][_0x2beb('0x88')]||_0x584fc9);}if(_0x464a5d[_0x2beb('0x75')]){_0x464a5d[_0x2beb('0x75')]=JSON[_0x2beb('0x76')](_0x464a5d[_0x2beb('0x75')]);for(var _0x36c15e=0x0;_0x36c15e<_0x464a5d[_0x2beb('0x75')][_0x2beb('0x60')];_0x36c15e+=0x1){if(_0x464a5d[_0x2beb('0x75')][_0x36c15e][_0x2beb('0x3a')]&&_[_0x2beb('0x5b')](_0x3d5df9,_0x464a5d[_0x2beb('0x75')][_0x36c15e]['type'])&&_0x464a5d[_0x2beb('0x75')][_0x36c15e][_0x2beb('0x7a')]&&_0x464a5d['joins'][_0x36c15e][_0x2beb('0x78')]&&_0x464a5d['joins'][_0x36c15e][_0x2beb('0x77')]){_0x245921[_0x464a5d[_0x2beb('0x75')][_0x36c15e][_0x2beb('0x3a')]](_0x464a5d['joins'][_0x36c15e]['foreignTable'],null,util[_0x2beb('0x70')](_0x2beb('0x79'),_0x464a5d[_0x2beb('0x6c')],_0x464a5d[_0x2beb('0x75')][_0x36c15e][_0x2beb('0x7a')],_0x464a5d[_0x2beb('0x75')][_0x36c15e][_0x2beb('0x78')],_0x464a5d[_0x2beb('0x75')][_0x36c15e][_0x2beb('0x77')]));}}}if(_0x464a5d['conditions']){_0x464a5d[_0x2beb('0x7b')]=JSON['parse'](_0x464a5d['conditions']);_0x245921[_0x2beb('0x37')](_0x3f65fb(_0x464a5d[_0x2beb('0x7b')][_0x2beb('0x62')]));}_0x2e8a0b=_0x245921[_0x2beb('0x7c')]();_0x245921[_0x2beb('0x1a')](_0xd9cb92);_0x245921[_0x2beb('0x19')](0x0);logger['debug']('Limited\x20Query:',_0x245921[_0x2beb('0x96')]());return dbH[_0x2beb('0x7f')]['query'](_0x245921[_0x2beb('0x96')](),{'type':dbH[_0x2beb('0x7f')]['QueryTypes'][_0x2beb('0x9b')]});}})[_0x2beb('0x22')](function(){return{'sql':_0x2e8a0b['toString']()};})['then'](respondWithResult(_0x304aa9,null))[_0x2beb('0x3f')](handleError(_0x304aa9,null));};
\ No newline at end of file
+var _0x731b=['left_join','right_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','DATE(%s)','HOUR(%s)','ROUND(%s)','includes','IS\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','value','getFields','Sequelize','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','select','table','MetricId','function','replace','format','groupBy','orderBy','order','alias','joins','parse','foreignKey','%s.%s\x20=\x20%s.%s','parentKey','foreignTable','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','cross_join','GROUP_CONCAT(%s)','UNIX_TIMESTAMP(%s)','IS\x20NOT\x20NULL','DESC','output','web','fullPath','%s-%s.%s','csv','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','endDate','info','Run\x20Query:','child_process','fork','../../files/reports','savename','countTable','COUNT(*)','SELECT','run','ValidationErrorItem','keyBy','from','metric','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','desk.js','querystring','papaparse','ioredis','../../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','end','status','json','offset','undefined','limit','count','Content-Range','apply','save','update','destroy','then','CustomReports','UserProfileResource','error','stack','name','AnalyticCustomReport','rawAttributes','fieldName','type','model','map','query','keys','filters','attributes','intersection','fields','length','hasOwnProperty','nolimit','sort','where','filter','merge','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','params','create','body','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','find','userProfileId','autoAssociation','preview','join'];(function(_0x390bfb,_0x3fc1e6){var _0x2c074f=function(_0x52b79c){while(--_0x52b79c){_0x390bfb['push'](_0x390bfb['shift']());}};_0x2c074f(++_0x3fc1e6);}(_0x731b,0xf7));var _0xb731=function(_0x23295c,_0x459613){_0x23295c=_0x23295c-0x0;var _0x28944b=_0x731b[_0x23295c];return _0x28944b;};'use strict';var emlformat=require(_0xb731('0x0'));var rimraf=require(_0xb731('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xb731('0x2'));var rp=require(_0xb731('0x3'));var moment=require(_0xb731('0x4'));var BPromise=require(_0xb731('0x5'));var Mustache=require(_0xb731('0x6'));var util=require(_0xb731('0x7'));var path=require('path');var sox=require(_0xb731('0x8'));var csv=require(_0xb731('0x9'));var ejs=require(_0xb731('0xa'));var fs=require('fs');var fs_extra=require(_0xb731('0xb'));var _=require(_0xb731('0xc'));var squel=require(_0xb731('0xd'));var crypto=require(_0xb731('0xe'));var jsforce=require('jsforce');var deskjs=require(_0xb731('0xf'));var toCsv=require(_0xb731('0x9'));var querystring=require(_0xb731('0x10'));var Papa=require(_0xb731('0x11'));var Redis=require(_0xb731('0x12'));var authService=require(_0xb731('0x13'));var qs=require(_0xb731('0x14'));var as=require(_0xb731('0x15'));var hardwareService=require(_0xb731('0x16'));var logger=require(_0xb731('0x17'))(_0xb731('0x18'));var utils=require(_0xb731('0x19'));var config=require(_0xb731('0x1a'));var licenseUtil=require(_0xb731('0x1b'));var db=require(_0xb731('0x1c'))['db'];var dbH=require('../../mysqldb')[_0xb731('0x1d')];function respondWithStatusCode(_0x5f4f12,_0x180a92){_0x180a92=_0x180a92||0xcc;return function(_0x1b670e){if(_0x1b670e){return _0x5f4f12[_0xb731('0x1e')](_0x180a92);}return _0x5f4f12['status'](_0x180a92)[_0xb731('0x1f')]();};}function respondWithResult(_0x4b433a,_0x524c0d){_0x524c0d=_0x524c0d||0xc8;return function(_0x579641){if(_0x579641){return _0x4b433a[_0xb731('0x20')](_0x524c0d)[_0xb731('0x21')](_0x579641);}};}function respondWithFilteredResult(_0x4962e8,_0x47829e){return function(_0x15c596){if(_0x15c596){var _0x5e4ca6=typeof _0x47829e[_0xb731('0x22')]===_0xb731('0x23')&&typeof _0x47829e[_0xb731('0x24')]===_0xb731('0x23');var _0x4e0c6d=_0x15c596[_0xb731('0x25')];var _0x1eaaf7=_0x5e4ca6?0x0:_0x47829e[_0xb731('0x22')];var _0x2c5c62=_0x5e4ca6?_0x15c596['count']:_0x47829e[_0xb731('0x22')]+_0x47829e['limit'];var _0x4b4cb4;if(_0x2c5c62>=_0x4e0c6d){_0x2c5c62=_0x4e0c6d;_0x4b4cb4=0xc8;}else{_0x4b4cb4=0xce;}_0x4962e8[_0xb731('0x20')](_0x4b4cb4);return _0x4962e8['set'](_0xb731('0x26'),_0x1eaaf7+'-'+_0x2c5c62+'/'+_0x4e0c6d)[_0xb731('0x21')](_0x15c596);}return null;};}function patchUpdates(_0x474f0c){return function(_0x36374e){try{jsonpatch[_0xb731('0x27')](_0x36374e,_0x474f0c,!![]);}catch(_0x49af50){return BPromise['reject'](_0x49af50);}return _0x36374e[_0xb731('0x28')]();};}function saveUpdates(_0x3e4623,_0x4f7424){return function(_0x4972cb){if(_0x4972cb){return _0x4972cb[_0xb731('0x29')](_0x3e4623)['then'](function(_0x1f6bc3){return _0x1f6bc3;});}return null;};}function removeEntity(_0x15be09,_0x573432){return function(_0x396790){if(_0x396790){return _0x396790[_0xb731('0x2a')]()[_0xb731('0x2b')](function(){var _0x29944a=_0x396790['get']({'plain':!![]});var _0x9fabd8=_0xb731('0x2c');return db[_0xb731('0x2d')][_0xb731('0x2a')]({'where':{'type':_0x9fabd8,'resourceId':_0x29944a['id']}})[_0xb731('0x2b')](function(){return _0x396790;});})['then'](function(){_0x15be09['status'](0xcc)[_0xb731('0x1f')]();});}};}function handleEntityNotFound(_0x3519c8,_0x513a26){return function(_0x5b6df7){if(!_0x5b6df7){_0x3519c8[_0xb731('0x1e')](0x194);}return _0x5b6df7;};}function handleError(_0x5e4a21,_0x41f8d3){_0x41f8d3=_0x41f8d3||0x1f4;return function(_0x4fbad1){logger[_0xb731('0x2e')](_0x4fbad1[_0xb731('0x2f')]);if(_0x4fbad1[_0xb731('0x30')]){delete _0x4fbad1[_0xb731('0x30')];}_0x5e4a21[_0xb731('0x20')](_0x41f8d3)['send'](_0x4fbad1);};}exports['index']=function(_0x5edd1f,_0x4c0a33){var _0x257dd2={},_0x325a04={},_0x5c20d0={'count':0x0,'rows':[]};var _0x189b34=_['map'](db[_0xb731('0x31')][_0xb731('0x32')],function(_0x4918f7){return{'name':_0x4918f7[_0xb731('0x33')],'type':_0x4918f7[_0xb731('0x34')]['key']};});_0x325a04[_0xb731('0x35')]=_[_0xb731('0x36')](_0x189b34,_0xb731('0x30'));_0x325a04[_0xb731('0x37')]=_[_0xb731('0x38')](_0x5edd1f[_0xb731('0x37')]);_0x325a04[_0xb731('0x39')]=_['intersection'](_0x325a04[_0xb731('0x35')],_0x325a04[_0xb731('0x37')]);_0x257dd2[_0xb731('0x3a')]=_[_0xb731('0x3b')](_0x325a04[_0xb731('0x35')],qs[_0xb731('0x3c')](_0x5edd1f[_0xb731('0x37')][_0xb731('0x3c')]));_0x257dd2[_0xb731('0x3a')]=_0x257dd2[_0xb731('0x3a')][_0xb731('0x3d')]?_0x257dd2[_0xb731('0x3a')]:_0x325a04[_0xb731('0x35')];if(!_0x5edd1f[_0xb731('0x37')][_0xb731('0x3e')](_0xb731('0x3f'))){_0x257dd2[_0xb731('0x24')]=qs[_0xb731('0x24')](_0x5edd1f['query'][_0xb731('0x24')]);_0x257dd2['offset']=qs[_0xb731('0x22')](_0x5edd1f[_0xb731('0x37')][_0xb731('0x22')]);}_0x257dd2['order']=qs['sort'](_0x5edd1f[_0xb731('0x37')][_0xb731('0x40')]);_0x257dd2[_0xb731('0x41')]=qs['filters'](_['pick'](_0x5edd1f['query'],_0x325a04[_0xb731('0x39')]),_0x189b34);if(_0x5edd1f[_0xb731('0x37')][_0xb731('0x42')]){_0x257dd2[_0xb731('0x41')]=_[_0xb731('0x43')](_0x257dd2[_0xb731('0x41')],{'$or':_[_0xb731('0x36')](_0x189b34,function(_0x321441){if(_0x321441[_0xb731('0x34')]!==_0xb731('0x44')){var _0x2c2152={};_0x2c2152[_0x321441[_0xb731('0x30')]]={'$like':'%'+_0x5edd1f[_0xb731('0x37')][_0xb731('0x42')]+'%'};return _0x2c2152;}})});}_0x257dd2=_[_0xb731('0x43')]({},_0x257dd2,_0x5edd1f[_0xb731('0x45')]);var _0x1fb0a1={'where':_0x257dd2[_0xb731('0x41')]};return db[_0xb731('0x31')][_0xb731('0x25')](_0x1fb0a1)[_0xb731('0x2b')](function(_0x21204a){_0x5c20d0[_0xb731('0x25')]=_0x21204a;if(_0x5edd1f['query'][_0xb731('0x46')]){_0x257dd2[_0xb731('0x47')]=[{'all':!![]}];}return db[_0xb731('0x31')][_0xb731('0x48')](_0x257dd2);})['then'](function(_0x5394b2){_0x5c20d0[_0xb731('0x49')]=_0x5394b2;return _0x5c20d0;})[_0xb731('0x2b')](respondWithFilteredResult(_0x4c0a33,_0x257dd2))[_0xb731('0x4a')](handleError(_0x4c0a33,null));};exports[_0xb731('0x4b')]=function(_0x132a97,_0x46a1e1){var _0x411370={'raw':![],'where':{'id':_0x132a97[_0xb731('0x4c')]['id']}},_0x573941={};_0x573941[_0xb731('0x35')]=_[_0xb731('0x38')](db['AnalyticCustomReport'][_0xb731('0x32')]);_0x573941[_0xb731('0x37')]=_[_0xb731('0x38')](_0x132a97[_0xb731('0x37')]);_0x573941[_0xb731('0x39')]=_[_0xb731('0x3b')](_0x573941[_0xb731('0x35')],_0x573941[_0xb731('0x37')]);_0x411370[_0xb731('0x3a')]=_['intersection'](_0x573941['model'],qs[_0xb731('0x3c')](_0x132a97[_0xb731('0x37')][_0xb731('0x3c')]));_0x411370[_0xb731('0x3a')]=_0x411370[_0xb731('0x3a')][_0xb731('0x3d')]?_0x411370[_0xb731('0x3a')]:_0x573941[_0xb731('0x35')];if(_0x132a97['query']['includeAll']){_0x411370[_0xb731('0x47')]=[{'all':!![]}];}_0x411370=_[_0xb731('0x43')]({},_0x411370,_0x132a97[_0xb731('0x45')]);return db[_0xb731('0x31')]['find'](_0x411370)[_0xb731('0x2b')](handleEntityNotFound(_0x46a1e1,null))['then'](respondWithResult(_0x46a1e1,null))[_0xb731('0x4a')](handleError(_0x46a1e1,null));};exports[_0xb731('0x4d')]=function(_0x493f70,_0x5673f9){return db[_0xb731('0x31')]['create'](_0x493f70[_0xb731('0x4e')],{})[_0xb731('0x2b')](function(_0xb699d){var _0x4db993=_0x493f70[_0xb731('0x4f')][_0xb731('0x50')]({'plain':!![]});if(!_0x4db993)throw new Error(_0xb731('0x51'));if(_0x4db993[_0xb731('0x52')]===_0xb731('0x4f')){var _0x49a174=_0xb699d[_0xb731('0x50')]({'plain':!![]});var _0x4cf35d='Reports';return db[_0xb731('0x53')][_0xb731('0x54')]({'where':{'name':_0x4cf35d,'userProfileId':_0x4db993[_0xb731('0x55')]},'raw':!![]})[_0xb731('0x2b')](function(_0x26bc63){if(_0x26bc63&&_0x26bc63[_0xb731('0x56')]===0x0){return db[_0xb731('0x2d')]['create']({'name':_0x49a174[_0xb731('0x30')],'resourceId':_0x49a174['id'],'type':_0xb731('0x2c'),'sectionId':_0x26bc63['id']},{})[_0xb731('0x2b')](function(){return _0xb699d;});}else{return _0xb699d;}})['catch'](function(_0x529b84){logger[_0xb731('0x2e')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x529b84);throw _0x529b84;});}return _0xb699d;})[_0xb731('0x2b')](respondWithResult(_0x5673f9,0xc9))[_0xb731('0x4a')](handleError(_0x5673f9,null));};exports[_0xb731('0x29')]=function(_0x1b82c1,_0x58a4cc){if(_0x1b82c1[_0xb731('0x4e')]['id']){delete _0x1b82c1['body']['id'];}return db['AnalyticCustomReport'][_0xb731('0x54')]({'where':{'id':_0x1b82c1[_0xb731('0x4c')]['id']}})[_0xb731('0x2b')](handleEntityNotFound(_0x58a4cc,null))[_0xb731('0x2b')](saveUpdates(_0x1b82c1[_0xb731('0x4e')],null))[_0xb731('0x2b')](respondWithResult(_0x58a4cc,null))['catch'](handleError(_0x58a4cc,null));};exports[_0xb731('0x2a')]=function(_0x1fa078,_0x3c9ad2){return db[_0xb731('0x31')][_0xb731('0x54')]({'where':{'id':_0x1fa078['params']['id']}})['then'](handleEntityNotFound(_0x3c9ad2,null))[_0xb731('0x2b')](removeEntity(_0x3c9ad2,null))[_0xb731('0x4a')](handleError(_0x3c9ad2,null));};exports[_0xb731('0x57')]=function(_0x84a0c3,_0x14daea){var _0x20b321=0xa;var _0x4c4132=[_0xb731('0x58'),_0xb731('0x59'),_0xb731('0x5a'),'cross_join'];var _0x4796a8={'SUM':_0xb731('0x5b'),'COUNT':_0xb731('0x5c'),'COUNT DISTINCT':_0xb731('0x5d'),'MAX':_0xb731('0x5e'),'MIN':_0xb731('0x5f'),'AVG':_0xb731('0x60'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0xb731('0x61'),'GROUP_CONCAT DESC':_0xb731('0x62')};var _0x39f272={'SEC_TO_TIME':_0xb731('0x63'),'DATE':_0xb731('0x64'),'HOUR':_0xb731('0x65'),'ROUND':_0xb731('0x66'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x4a9ed9=function(_0x515e84){return!_[_0xb731('0x67')]([_0xb731('0x68'),'IS\x20NOT\x20NULL',_0xb731('0x69'),_0xb731('0x6a')],_0x515e84);};var _0x509f25=function(_0x3fdc27){if(!_0x3fdc27||!_0x3fdc27[_0xb731('0x6b')]['length']){return'';}for(var _0x236126='(',_0x142ccb=0x0;_0x142ccb<_0x3fdc27['rules'][_0xb731('0x3d')];_0x142ccb+=0x1){_0x142ccb>0x0&&(_0x236126+='\x20'+_0x3fdc27[_0xb731('0x6c')]+'\x20');_0x236126+=_0x3fdc27[_0xb731('0x6b')][_0x142ccb]['group']?_0x509f25(_0x3fdc27[_0xb731('0x6b')][_0x142ccb][_0xb731('0x6d')]):_0x3fdc27[_0xb731('0x6b')][_0x142ccb][_0xb731('0x6e')]+'\x20'+_0x3fdc27[_0xb731('0x6b')][_0x142ccb]['condition']+(_0x4a9ed9(_0x3fdc27[_0xb731('0x6b')][_0x142ccb][_0xb731('0x6f')])?'\x20'+_0x3fdc27[_0xb731('0x6b')][_0x142ccb][_0xb731('0x70')]:'');}return _0x236126+')';};var _0x76cc37={'where':{'id':_0x84a0c3[_0xb731('0x4c')]['id']}},_0x3424d1,_0x3cb2e4,_0x335068,_0xf99729,_0x4c9dc5;_0x76cc37=_[_0xb731('0x43')]({},_0x76cc37,_0x84a0c3[_0xb731('0x45')]);return db['AnalyticCustomReport']['find'](_0x76cc37)[_0xb731('0x2b')](function(_0x59b071){if(_0x59b071){_0x3424d1=_0x59b071;return _0x59b071[_0xb731('0x71')]();}return null;})[_0xb731('0x2b')](function(_0x197ab3){if(_0x197ab3){if(!_0x197ab3[_0xb731('0x3d')]){throw new db[(_0xb731('0x72'))]['ValidationErrorItem'](_0xb731('0x73'),0x193);}_0x3cb2e4=_0x197ab3;return db[_0xb731('0x74')][_0xb731('0x48')]({'raw':!![]});}return null;})[_0xb731('0x2b')](function(_0x56af26){if(_0x56af26){_0x335068=_['keyBy'](_0x56af26,'id');var _0x657805;var _0x23bda6=squel[_0xb731('0x75')]();_0x23bda6['from'](_0x3424d1[_0xb731('0x76')]);for(var _0x46f928=0x0;_0x46f928<_0x3cb2e4[_0xb731('0x3d')];_0x46f928+=0x1){_0x657805=_0x3cb2e4[_0x46f928][_0xb731('0x77')]?_0x335068[_0x3cb2e4[_0x46f928][_0xb731('0x77')]]['metric']:_0x3cb2e4[_0x46f928][_0xb731('0x6e')];_0x657805=_0x3cb2e4[_0x46f928][_0xb731('0x78')]?_[_0xb731('0x79')](_0x4796a8[_0x3cb2e4[_0x46f928][_0xb731('0x78')]],'%s',_0x657805):_0x657805;_0x657805=_0x3cb2e4[_0x46f928][_0xb731('0x7a')]?_[_0xb731('0x79')](_0x39f272[_0x3cb2e4[_0x46f928][_0xb731('0x7a')]],'%s',_0x657805):_0x657805;if(_0x3cb2e4[_0x46f928][_0xb731('0x7b')]){_0x23bda6[_0xb731('0x6d')](_0x657805);}_0x3cb2e4[_0x46f928][_0xb731('0x7c')]&&_0x23bda6[_0xb731('0x7d')](_0x657805,_0x3cb2e4[_0x46f928][_0xb731('0x7c')]==='DESC'?![]:!![]);_0x23bda6[_0xb731('0x6e')](_0x657805,_0x3cb2e4[_0x46f928][_0xb731('0x7e')]||_0x657805);}if(_0x3424d1['joins']){_0x3424d1[_0xb731('0x7f')]=JSON[_0xb731('0x80')](_0x3424d1[_0xb731('0x7f')]);for(var _0x4c0826=0x0;_0x4c0826<_0x3424d1[_0xb731('0x7f')][_0xb731('0x3d')];_0x4c0826+=0x1){if(_0x3424d1[_0xb731('0x7f')][_0x4c0826]['type']&&_['includes'](_0x4c4132,_0x3424d1[_0xb731('0x7f')][_0x4c0826]['type'])&&_0x3424d1[_0xb731('0x7f')][_0x4c0826]['parentKey']&&_0x3424d1['joins'][_0x4c0826]['foreignTable']&&_0x3424d1[_0xb731('0x7f')][_0x4c0826][_0xb731('0x81')]){_0x23bda6[_0x3424d1[_0xb731('0x7f')][_0x4c0826][_0xb731('0x34')]](_0x3424d1[_0xb731('0x7f')][_0x4c0826]['foreignTable'],null,util[_0xb731('0x7a')](_0xb731('0x82'),_0x3424d1['table'],_0x3424d1[_0xb731('0x7f')][_0x4c0826][_0xb731('0x83')],_0x3424d1['joins'][_0x4c0826][_0xb731('0x84')],_0x3424d1[_0xb731('0x7f')][_0x4c0826][_0xb731('0x81')]));}}}if(_0x3424d1[_0xb731('0x85')]){_0x3424d1[_0xb731('0x85')]=JSON[_0xb731('0x80')](_0x3424d1[_0xb731('0x85')]);_0x23bda6[_0xb731('0x41')](_0x509f25(_0x3424d1[_0xb731('0x85')][_0xb731('0x6d')]));}_0x4c9dc5=_0x23bda6[_0xb731('0x86')]();_0x23bda6['limit'](_0x20b321);_0x23bda6[_0xb731('0x22')](0x0);logger[_0xb731('0x87')](_0xb731('0x88'),_0x23bda6[_0xb731('0x89')]());return dbH['sequelize'][_0xb731('0x37')](_0x23bda6[_0xb731('0x89')](),{'type':dbH[_0xb731('0x8a')][_0xb731('0x8b')]['SELECT']});}})[_0xb731('0x2b')](respondWithResult(_0x14daea,null))['catch'](handleError(_0x14daea,null));};function runReport(_0x59d39c,_0x133e4c,_0x928b61){var _0x4ce877=_0x133e4c[_0xb731('0x30')];var _0x199cd7=0xa;var _0x3e38d8=['join',_0xb731('0x59'),_0xb731('0x5a'),_0xb731('0x8c')];var _0x27101d={'SUM':'SUM(%s)','COUNT':_0xb731('0x5c'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0xb731('0x5e'),'MIN':_0xb731('0x5f'),'AVG':_0xb731('0x60'),'GROUP_CONCAT':_0xb731('0x8d'),'GROUP_CONCAT ASC':_0xb731('0x61'),'GROUP_CONCAT DESC':_0xb731('0x62')};var _0x47abb9={'SEC_TO_TIME':_0xb731('0x63'),'DATE':_0xb731('0x64'),'HOUR':'HOUR(%s)','ROUND':_0xb731('0x66'),'UNIX_TIMESTAMP':_0xb731('0x8e')};var _0x30c379=function(_0x2d6c11){return!_['includes']([_0xb731('0x68'),_0xb731('0x8f'),_0xb731('0x69'),'IS\x20NOT\x20EMPTY'],_0x2d6c11);};var _0x451f2f=function(_0x599d9d){if(!_0x599d9d||!_0x599d9d[_0xb731('0x6b')][_0xb731('0x3d')]){return'';}for(var _0x2d45a4='(',_0x3cec58=0x0;_0x3cec58<_0x599d9d['rules']['length'];_0x3cec58+=0x1){_0x3cec58>0x0&&(_0x2d45a4+='\x20'+_0x599d9d[_0xb731('0x6c')]+'\x20');_0x2d45a4+=_0x599d9d['rules'][_0x3cec58][_0xb731('0x6d')]?_0x451f2f(_0x599d9d[_0xb731('0x6b')][_0x3cec58]['group']):_0x599d9d[_0xb731('0x6b')][_0x3cec58]['field']+'\x20'+_0x599d9d[_0xb731('0x6b')][_0x3cec58][_0xb731('0x6f')]+(_0x30c379(_0x599d9d[_0xb731('0x6b')][_0x3cec58]['condition'])?'\x20'+_0x599d9d['rules'][_0x3cec58][_0xb731('0x70')]:'');}return _0x2d45a4+')';};var _0x38dfdf={'where':{'id':_0x59d39c['id']}},_0x423ab0,_0x3501cf,_0x3af421,_0x190c75,_0x49f5dd;_0x38dfdf=_['merge']({},_0x38dfdf,_0x928b61);return db['AnalyticCustomReport'][_0xb731('0x54')](_0x38dfdf)[_0xb731('0x2b')](function(_0x32b9bb){if(_0x32b9bb){_0x423ab0=_0x32b9bb;return _0x32b9bb[_0xb731('0x71')]();}return null;})[_0xb731('0x2b')](function(_0x5ad732){if(_0x5ad732){if(!_0x5ad732[_0xb731('0x3d')]){throw new db[(_0xb731('0x72'))]['ValidationErrorItem'](_0xb731('0x73'),0x193);}_0x3501cf=_0x5ad732;return db[_0xb731('0x74')]['findAll']({'raw':!![]});}return null;})[_0xb731('0x2b')](function(_0x1cbcc4){if(_0x1cbcc4){_0x3af421=_['keyBy'](_0x1cbcc4,'id');var _0x5d9830;var _0xf64460=squel[_0xb731('0x75')]();_0xf64460['from'](_0x423ab0[_0xb731('0x76')]);for(var _0x4db474=0x0;_0x4db474<_0x3501cf['length'];_0x4db474+=0x1){_0x5d9830=_0x3501cf[_0x4db474][_0xb731('0x77')]?_0x3af421[_0x3501cf[_0x4db474][_0xb731('0x77')]]['metric']:_0x3501cf[_0x4db474][_0xb731('0x6e')];_0x5d9830=_0x3501cf[_0x4db474][_0xb731('0x78')]?_[_0xb731('0x79')](_0x27101d[_0x3501cf[_0x4db474][_0xb731('0x78')]],'%s',_0x5d9830):_0x5d9830;_0x5d9830=_0x3501cf[_0x4db474][_0xb731('0x7a')]?_['replace'](_0x47abb9[_0x3501cf[_0x4db474][_0xb731('0x7a')]],'%s',_0x5d9830):_0x5d9830;if(_0x3501cf[_0x4db474]['groupBy']){_0xf64460[_0xb731('0x6d')](_0x5d9830);}_0x3501cf[_0x4db474][_0xb731('0x7c')]&&_0xf64460[_0xb731('0x7d')](_0x5d9830,_0x3501cf[_0x4db474][_0xb731('0x7c')]===_0xb731('0x90')?![]:!![]);_0xf64460['field'](_0x5d9830,_0x3501cf[_0x4db474][_0xb731('0x7e')]||_0x5d9830);}if(_0x423ab0[_0xb731('0x7f')]){_0x423ab0[_0xb731('0x7f')]=JSON[_0xb731('0x80')](_0x423ab0[_0xb731('0x7f')]);for(var _0x2beeb8=0x0;_0x2beeb8<_0x423ab0[_0xb731('0x7f')]['length'];_0x2beeb8+=0x1){if(_0x423ab0[_0xb731('0x7f')][_0x2beeb8][_0xb731('0x34')]&&_['includes'](_0x3e38d8,_0x423ab0[_0xb731('0x7f')][_0x2beeb8]['type'])&&_0x423ab0[_0xb731('0x7f')][_0x2beeb8][_0xb731('0x83')]&&_0x423ab0[_0xb731('0x7f')][_0x2beeb8][_0xb731('0x84')]&&_0x423ab0[_0xb731('0x7f')][_0x2beeb8]['foreignKey']){_0xf64460[_0x423ab0[_0xb731('0x7f')][_0x2beeb8]['type']](_0x423ab0[_0xb731('0x7f')][_0x2beeb8]['foreignTable'],null,util['format']('%s.%s\x20=\x20%s.%s',_0x423ab0['table'],_0x423ab0['joins'][_0x2beeb8]['parentKey'],_0x423ab0[_0xb731('0x7f')][_0x2beeb8][_0xb731('0x84')],_0x423ab0[_0xb731('0x7f')][_0x2beeb8][_0xb731('0x81')]));}}}if(_0x423ab0[_0xb731('0x85')]){_0x423ab0[_0xb731('0x85')]=JSON[_0xb731('0x80')](_0x423ab0[_0xb731('0x85')]);_0xf64460[_0xb731('0x41')](_0x451f2f(_0x423ab0[_0xb731('0x85')]['group']));}_0x49f5dd=_0xf64460[_0xb731('0x86')]();_0xf64460['limit'](_0x199cd7);_0xf64460[_0xb731('0x22')](0x0);return;}})['then'](function(){if(_0x133e4c[_0xb731('0x91')]===_0xb731('0x92')){return null;}var _0x3b528c=_['merge'](_0x133e4c,{'name':_0x133e4c[_0xb731('0x93')]||_0x133e4c[_0xb731('0x30')]||_0x423ab0['name'],'basename':_0x4ce877,'savename':util[_0xb731('0x7a')](_0xb731('0x94'),_0x133e4c[_0xb731('0x30')]||_0x423ab0[_0xb731('0x30')],require('randomstring')['generate'](0x4),_0x133e4c[_0xb731('0x91')]||_0xb731('0x95')),'reportId':_0x423ab0['id'],'reportType':'custom'});return db[_0xb731('0x96')][_0xb731('0x4d')](_0x3b528c,{'raw':!![]});})[_0xb731('0x2b')](function(_0x1c0efe){if(_0x423ab0[_0xb731('0x76')]===_0xb731('0x97')){_0x49f5dd[_0xb731('0x41')](_0x423ab0[_0xb731('0x76')]+_0xb731('0x98'),_0x133e4c['startDate'],_0x133e4c[_0xb731('0x99')]);}else{_0x49f5dd[_0xb731('0x41')](_0x423ab0[_0xb731('0x76')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x133e4c['startDate'],_0x133e4c[_0xb731('0x99')]);}if(_0x1c0efe){logger[_0xb731('0x9a')](_0xb731('0x9b'),_0x49f5dd[_0xb731('0x89')]());require(_0xb731('0x9c'))[_0xb731('0x9d')](path['join'](__dirname,'../../components/export/',_0x1c0efe[_0xb731('0x91')]),[_0x1c0efe['id'],_0x49f5dd[_0xb731('0x89')](),path['join'](__dirname,_0xb731('0x9e'),_0x1c0efe[_0xb731('0x9f')]),_0x4ce877]);return _0x1c0efe;}else{var _0x33e2ec=squel['select']();_0x33e2ec['from']('('+_0x49f5dd[_0xb731('0x89')]()+')',_0xb731('0xa0'));_0x33e2ec['field'](_0xb731('0xa1'),_0xb731('0x25'));_0x49f5dd[_0xb731('0x24')](_0x133e4c[_0xb731('0x24')]||_0x199cd7);_0x49f5dd['offset'](_0x133e4c[_0xb731('0x22')]||0x0);return dbH[_0xb731('0x8a')][_0xb731('0x37')](_0x33e2ec[_0xb731('0x89')](),{'type':dbH[_0xb731('0x8a')]['QueryTypes']['SELECT']})[_0xb731('0x2b')](function(_0x39c0cd){if(!_0x39c0cd[_0xb731('0x3d')]){_0x190c75=0x0;}else{_0x190c75=_0x39c0cd[0x0]['count']||0x0;}return dbH[_0xb731('0x8a')][_0xb731('0x37')](_0x49f5dd[_0xb731('0x89')](),{'type':dbH[_0xb731('0x8a')][_0xb731('0x8b')][_0xb731('0xa2')]});})['then'](function(_0x1e360a){return{'rows':_0x1e360a||[],'count':_0x190c75};});}});}exports[_0xb731('0xa3')]=function(_0x367d26,_0x56e7df){return runReport(_0x367d26[_0xb731('0x4c')],_0x367d26[_0xb731('0x37')],_0x367d26['options'])[_0xb731('0x2b')](respondWithResult(_0x56e7df,null))[_0xb731('0x4a')](handleError(_0x56e7df,null));};exports['runReport']=runReport;exports[_0xb731('0x37')]=function(_0x42013d,_0x1c853f){var _0x2f9086=0xa;var _0x1462a6=[_0xb731('0x58'),'left_join',_0xb731('0x5a'),_0xb731('0x8c')];var _0x3e1cd3={'SUM':_0xb731('0x5b'),'COUNT':_0xb731('0x5c'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0xb731('0x5e'),'MIN':_0xb731('0x5f'),'AVG':_0xb731('0x60'),'GROUP_CONCAT':_0xb731('0x8d'),'GROUP_CONCAT ASC':_0xb731('0x61'),'GROUP_CONCAT DESC':_0xb731('0x62')};var _0xe890ba={'SEC_TO_TIME':_0xb731('0x63'),'DATE':_0xb731('0x64'),'HOUR':_0xb731('0x65'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0xb731('0x8e')};var _0x25b4ac=function(_0x2262c7){return!_['includes']([_0xb731('0x68'),_0xb731('0x8f'),'IS\x20EMPTY',_0xb731('0x6a')],_0x2262c7);};var _0x9b06c5=function(_0x4fc06a){if(!_0x4fc06a||!_0x4fc06a[_0xb731('0x6b')][_0xb731('0x3d')]){return'';}for(var _0x2e0494='(',_0x1f5200=0x0;_0x1f5200<_0x4fc06a[_0xb731('0x6b')][_0xb731('0x3d')];_0x1f5200+=0x1){_0x1f5200>0x0&&(_0x2e0494+='\x20'+_0x4fc06a['operator']+'\x20');_0x2e0494+=_0x4fc06a[_0xb731('0x6b')][_0x1f5200]['group']?_0x9b06c5(_0x4fc06a[_0xb731('0x6b')][_0x1f5200]['group']):_0x4fc06a[_0xb731('0x6b')][_0x1f5200][_0xb731('0x6e')]+'\x20'+_0x4fc06a['rules'][_0x1f5200]['condition']+(_0x25b4ac(_0x4fc06a[_0xb731('0x6b')][_0x1f5200][_0xb731('0x6f')])?'\x20'+_0x4fc06a[_0xb731('0x6b')][_0x1f5200][_0xb731('0x70')]:'');}return _0x2e0494+')';};var _0xf6e179={'where':{'id':_0x42013d[_0xb731('0x4c')]['id']}},_0x6db50e,_0x4b6720,_0x5a10be,_0x13225f,_0x381c7a;_0xf6e179=_['merge']({},_0xf6e179,_0x42013d[_0xb731('0x45')]);return db[_0xb731('0x31')][_0xb731('0x54')](_0xf6e179)['then'](function(_0x2a3cef){if(_0x2a3cef){_0x6db50e=_0x2a3cef;return _0x2a3cef[_0xb731('0x71')]();}return null;})[_0xb731('0x2b')](function(_0x236ef8){if(_0x236ef8){if(!_0x236ef8[_0xb731('0x3d')]){throw new db['Sequelize'][(_0xb731('0xa4'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x4b6720=_0x236ef8;return db[_0xb731('0x74')][_0xb731('0x48')]({'raw':!![]});}return null;})[_0xb731('0x2b')](function(_0x4c841d){if(_0x4c841d){_0x5a10be=_[_0xb731('0xa5')](_0x4c841d,'id');var _0x495e8e;var _0xb68b89=squel[_0xb731('0x75')]();_0xb68b89[_0xb731('0xa6')](_0x6db50e[_0xb731('0x76')]);for(var _0x1e2b7e=0x0;_0x1e2b7e<_0x4b6720['length'];_0x1e2b7e+=0x1){_0x495e8e=_0x4b6720[_0x1e2b7e][_0xb731('0x77')]?_0x5a10be[_0x4b6720[_0x1e2b7e][_0xb731('0x77')]][_0xb731('0xa7')]:_0x4b6720[_0x1e2b7e][_0xb731('0x6e')];_0x495e8e=_0x4b6720[_0x1e2b7e][_0xb731('0x78')]?_[_0xb731('0x79')](_0x3e1cd3[_0x4b6720[_0x1e2b7e][_0xb731('0x78')]],'%s',_0x495e8e):_0x495e8e;_0x495e8e=_0x4b6720[_0x1e2b7e][_0xb731('0x7a')]?_[_0xb731('0x79')](_0xe890ba[_0x4b6720[_0x1e2b7e][_0xb731('0x7a')]],'%s',_0x495e8e):_0x495e8e;if(_0x4b6720[_0x1e2b7e][_0xb731('0x7b')]){_0xb68b89[_0xb731('0x6d')](_0x495e8e);}_0x4b6720[_0x1e2b7e][_0xb731('0x7c')]&&_0xb68b89[_0xb731('0x7d')](_0x495e8e,_0x4b6720[_0x1e2b7e]['orderBy']===_0xb731('0x90')?![]:!![]);_0xb68b89[_0xb731('0x6e')](_0x495e8e,_0x4b6720[_0x1e2b7e][_0xb731('0x7e')]||_0x495e8e);}if(_0x6db50e[_0xb731('0x7f')]){_0x6db50e['joins']=JSON[_0xb731('0x80')](_0x6db50e['joins']);for(var _0x4fdf04=0x0;_0x4fdf04<_0x6db50e['joins'][_0xb731('0x3d')];_0x4fdf04+=0x1){if(_0x6db50e['joins'][_0x4fdf04][_0xb731('0x34')]&&_[_0xb731('0x67')](_0x1462a6,_0x6db50e['joins'][_0x4fdf04][_0xb731('0x34')])&&_0x6db50e[_0xb731('0x7f')][_0x4fdf04]['parentKey']&&_0x6db50e[_0xb731('0x7f')][_0x4fdf04][_0xb731('0x84')]&&_0x6db50e[_0xb731('0x7f')][_0x4fdf04][_0xb731('0x81')]){_0xb68b89[_0x6db50e[_0xb731('0x7f')][_0x4fdf04]['type']](_0x6db50e[_0xb731('0x7f')][_0x4fdf04][_0xb731('0x84')],null,util[_0xb731('0x7a')](_0xb731('0x82'),_0x6db50e['table'],_0x6db50e[_0xb731('0x7f')][_0x4fdf04]['parentKey'],_0x6db50e[_0xb731('0x7f')][_0x4fdf04][_0xb731('0x84')],_0x6db50e[_0xb731('0x7f')][_0x4fdf04][_0xb731('0x81')]));}}}if(_0x6db50e[_0xb731('0x85')]){_0x6db50e[_0xb731('0x85')]=JSON[_0xb731('0x80')](_0x6db50e[_0xb731('0x85')]);_0xb68b89[_0xb731('0x41')](_0x9b06c5(_0x6db50e['conditions']['group']));}_0x381c7a=_0xb68b89[_0xb731('0x86')]();_0xb68b89[_0xb731('0x24')](_0x2f9086);_0xb68b89['offset'](0x0);logger[_0xb731('0x87')]('Limited\x20Query:',_0xb68b89[_0xb731('0x89')]());return dbH[_0xb731('0x8a')]['query'](_0xb68b89[_0xb731('0x89')](),{'type':dbH[_0xb731('0x8a')][_0xb731('0x8b')]['SELECT']});}})['then'](function(){return{'sql':_0x381c7a[_0xb731('0x89')]()};})[_0xb731('0x2b')](respondWithResult(_0x1c853f,null))[_0xb731('0x4a')](handleError(_0x1c853f,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff