// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x7e04=['getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','keyBy','select','from','table','MetricId','format','replace','orderBy','DESC','joins','parse','foreignTable','%s.%s\x20=\x20%s.%s','foreignKey','conditions','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','join','DATE(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','AnalyticMetric','metric','function','alias','clone','output','fullPath','%s-%s.%s','randomstring','custom','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','Run\x20Query:','child_process','fork','../../components/export/','../../files/reports','savename','runReport','MIN(%s)','groupBy','parentKey','html-pdf','eml-format','rimraf','fast-json-patch','bluebird','mustache','path','to-csv','ejs','lodash','jsforce','desk.js','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','status','end','json','count','offset','set','Content-Range','apply','reject','save','update','then','destroy','get','CustomReports','UserProfileResource','error','stack','name','map','AnalyticCustomReport','rawAttributes','fieldName','type','key','query','keys','intersection','model','attributes','length','hasOwnProperty','nolimit','limit','order','sort','where','filters','pick','merge','VIRTUAL','filter','options','includeAll','include','findAll','catch','show','params','create','body','user','role','Reports','UserProfileSection','find','userProfileId','autoAssociation','preview','left_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)','HOUR(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','value'];(function(_0x3a13cf,_0x478c62){var _0x4817c=function(_0x3a2e75){while(--_0x3a2e75){_0x3a13cf['push'](_0x3a13cf['shift']());}};_0x4817c(++_0x478c62);}(_0x7e04,0xd6));var _0x47e0=function(_0x16535d,_0xe13222){_0x16535d=_0x16535d-0x0;var _0x4a0239=_0x7e04[_0x16535d];return _0x4a0239;};'use strict';var pdf=require(_0x47e0('0x0'));var emlformat=require(_0x47e0('0x1'));var rimraf=require(_0x47e0('0x2'));var zipdir=require('zip-dir');var jsonpatch=require(_0x47e0('0x3'));var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0x47e0('0x4'));var Mustache=require(_0x47e0('0x5'));var util=require('util');var path=require(_0x47e0('0x6'));var sox=require('sox');var csv=require(_0x47e0('0x7'));var ejs=require(_0x47e0('0x8'));var fs=require('fs');var _=require(_0x47e0('0x9'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x47e0('0xa'));var deskjs=require(_0x47e0('0xb'));var toCsv=require(_0x47e0('0x7'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0x47e0('0xc'));var authService=require(_0x47e0('0xd'));var qs=require(_0x47e0('0xe'));var as=require(_0x47e0('0xf'));var hardwareService=require(_0x47e0('0x10'));var logger=require(_0x47e0('0x11'))(_0x47e0('0x12'));var utils=require('../../config/utils');var config=require(_0x47e0('0x13'));var licenseUtil=require(_0x47e0('0x14'));var db=require(_0x47e0('0x15'))['db'];var dbH=require(_0x47e0('0x15'))['dbH'];function respondWithStatusCode(_0x1966ad,_0x23ae8f){_0x23ae8f=_0x23ae8f||0xcc;return function(_0x107196){if(_0x107196){return _0x1966ad['sendStatus'](_0x23ae8f);}return _0x1966ad[_0x47e0('0x16')](_0x23ae8f)[_0x47e0('0x17')]();};}function respondWithResult(_0x25bd9c,_0x82d917){_0x82d917=_0x82d917||0xc8;return function(_0x11013a){if(_0x11013a){return _0x25bd9c['status'](_0x82d917)[_0x47e0('0x18')](_0x11013a);}};}function respondWithFilteredResult(_0x5196c2,_0x3c28bf){return function(_0x2831dd){if(_0x2831dd){var _0x216df1=_0x2831dd[_0x47e0('0x19')],_0x194854=_0x3c28bf[_0x47e0('0x1a')],_0x188181=_0x3c28bf[_0x47e0('0x1a')]+_0x3c28bf['limit'],_0x4a00e4;if(_0x188181>=_0x216df1){_0x188181=_0x216df1;_0x4a00e4=0xc8;}else{_0x4a00e4=0xce;}_0x5196c2['status'](_0x4a00e4);return _0x5196c2[_0x47e0('0x1b')](_0x47e0('0x1c'),_0x194854+'-'+_0x188181+'/'+_0x216df1)[_0x47e0('0x18')](_0x2831dd);}return null;};}function patchUpdates(_0x8cb888){return function(_0x8af38){try{jsonpatch[_0x47e0('0x1d')](_0x8af38,_0x8cb888,!![]);}catch(_0x39b7aa){return BPromise[_0x47e0('0x1e')](_0x39b7aa);}return _0x8af38[_0x47e0('0x1f')]();};}function saveUpdates(_0x5b010f,_0x115f3f){return function(_0x362a28){if(_0x362a28){return _0x362a28[_0x47e0('0x20')](_0x5b010f)[_0x47e0('0x21')](function(_0x48f542){return _0x48f542;});}return null;};}function removeEntity(_0x199d94,_0x5a8c3e){return function(_0x45c7c7){if(_0x45c7c7){return _0x45c7c7[_0x47e0('0x22')]()[_0x47e0('0x21')](function(){var _0x149bbb=_0x45c7c7[_0x47e0('0x23')]({'plain':!![]});var _0x5b4458=_0x47e0('0x24');return db[_0x47e0('0x25')][_0x47e0('0x22')]({'where':{'type':_0x5b4458,'resourceId':_0x149bbb['id']}})[_0x47e0('0x21')](function(){return _0x45c7c7;});})[_0x47e0('0x21')](function(){_0x199d94[_0x47e0('0x16')](0xcc)[_0x47e0('0x17')]();});}};}function handleEntityNotFound(_0x317402,_0xe32518){return function(_0x3779c4){if(!_0x3779c4){_0x317402['sendStatus'](0x194);}return _0x3779c4;};}function handleError(_0x574c79,_0x320bf0){_0x320bf0=_0x320bf0||0x1f4;return function(_0x23c205){logger[_0x47e0('0x26')](_0x23c205[_0x47e0('0x27')]);if(_0x23c205[_0x47e0('0x28')]){delete _0x23c205[_0x47e0('0x28')];}_0x574c79[_0x47e0('0x16')](_0x320bf0)['send'](_0x23c205);};}exports['index']=function(_0x509e63,_0x38fcad){var _0x5c9e14={},_0x320398={},_0x225a48={'count':0x0,'rows':[]};var _0x8413d9=_[_0x47e0('0x29')](db[_0x47e0('0x2a')][_0x47e0('0x2b')],function(_0x38b3db){return{'name':_0x38b3db[_0x47e0('0x2c')],'type':_0x38b3db[_0x47e0('0x2d')][_0x47e0('0x2e')]};});_0x320398['model']=_[_0x47e0('0x29')](_0x8413d9,_0x47e0('0x28'));_0x320398[_0x47e0('0x2f')]=_[_0x47e0('0x30')](_0x509e63[_0x47e0('0x2f')]);_0x320398['filters']=_[_0x47e0('0x31')](_0x320398[_0x47e0('0x32')],_0x320398['query']);_0x5c9e14['attributes']=_[_0x47e0('0x31')](_0x320398[_0x47e0('0x32')],qs['fields'](_0x509e63[_0x47e0('0x2f')]['fields']));_0x5c9e14[_0x47e0('0x33')]=_0x5c9e14[_0x47e0('0x33')][_0x47e0('0x34')]?_0x5c9e14[_0x47e0('0x33')]:_0x320398[_0x47e0('0x32')];if(!_0x509e63[_0x47e0('0x2f')][_0x47e0('0x35')](_0x47e0('0x36'))){_0x5c9e14[_0x47e0('0x37')]=qs[_0x47e0('0x37')](_0x509e63[_0x47e0('0x2f')][_0x47e0('0x37')]);_0x5c9e14['offset']=qs[_0x47e0('0x1a')](_0x509e63['query'][_0x47e0('0x1a')]);}_0x5c9e14[_0x47e0('0x38')]=qs[_0x47e0('0x39')](_0x509e63['query']['sort']);_0x5c9e14[_0x47e0('0x3a')]=qs[_0x47e0('0x3b')](_[_0x47e0('0x3c')](_0x509e63['query'],_0x320398[_0x47e0('0x3b')]),_0x8413d9);if(_0x509e63[_0x47e0('0x2f')]['filter']){_0x5c9e14[_0x47e0('0x3a')]=_[_0x47e0('0x3d')](_0x5c9e14[_0x47e0('0x3a')],{'$or':_[_0x47e0('0x29')](_0x8413d9,function(_0x4699db){if(_0x4699db[_0x47e0('0x2d')]!==_0x47e0('0x3e')){var _0x3a3b26={};_0x3a3b26[_0x4699db[_0x47e0('0x28')]]={'$like':'%'+_0x509e63[_0x47e0('0x2f')][_0x47e0('0x3f')]+'%'};return _0x3a3b26;}})});}_0x5c9e14=_[_0x47e0('0x3d')]({},_0x5c9e14,_0x509e63[_0x47e0('0x40')]);var _0x3e3de0={'where':_0x5c9e14[_0x47e0('0x3a')]};return db[_0x47e0('0x2a')]['count'](_0x3e3de0)[_0x47e0('0x21')](function(_0x3d429c){_0x225a48[_0x47e0('0x19')]=_0x3d429c;if(_0x509e63[_0x47e0('0x2f')][_0x47e0('0x41')]){_0x5c9e14[_0x47e0('0x42')]=[{'all':!![]}];}return db['AnalyticCustomReport'][_0x47e0('0x43')](_0x5c9e14);})[_0x47e0('0x21')](function(_0x58a9f3){_0x225a48['rows']=_0x58a9f3;return _0x225a48;})[_0x47e0('0x21')](respondWithFilteredResult(_0x38fcad,_0x5c9e14))[_0x47e0('0x44')](handleError(_0x38fcad,null));};exports[_0x47e0('0x45')]=function(_0x521e62,_0x207724){var _0x6c1547={'raw':![],'where':{'id':_0x521e62[_0x47e0('0x46')]['id']}},_0x1ccf36={};_0x1ccf36[_0x47e0('0x32')]=_[_0x47e0('0x30')](db[_0x47e0('0x2a')][_0x47e0('0x2b')]);_0x1ccf36[_0x47e0('0x2f')]=_[_0x47e0('0x30')](_0x521e62[_0x47e0('0x2f')]);_0x1ccf36['filters']=_[_0x47e0('0x31')](_0x1ccf36[_0x47e0('0x32')],_0x1ccf36['query']);_0x6c1547['attributes']=_[_0x47e0('0x31')](_0x1ccf36['model'],qs['fields'](_0x521e62[_0x47e0('0x2f')]['fields']));_0x6c1547['attributes']=_0x6c1547[_0x47e0('0x33')]['length']?_0x6c1547[_0x47e0('0x33')]:_0x1ccf36[_0x47e0('0x32')];if(_0x521e62[_0x47e0('0x2f')][_0x47e0('0x41')]){_0x6c1547[_0x47e0('0x42')]=[{'all':!![]}];}_0x6c1547=_[_0x47e0('0x3d')]({},_0x6c1547,_0x521e62['options']);return db[_0x47e0('0x2a')]['find'](_0x6c1547)[_0x47e0('0x21')](handleEntityNotFound(_0x207724,null))[_0x47e0('0x21')](respondWithResult(_0x207724,null))[_0x47e0('0x44')](handleError(_0x207724,null));};exports[_0x47e0('0x47')]=function(_0x2a2839,_0x127747){return db[_0x47e0('0x2a')][_0x47e0('0x47')](_0x2a2839[_0x47e0('0x48')],{})['then'](function(_0x5e3c50){var _0x2036de=_0x2a2839[_0x47e0('0x49')][_0x47e0('0x23')]({'plain':!![]});if(!_0x2036de)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x2036de[_0x47e0('0x4a')]===_0x47e0('0x49')){var _0x31ac76=_0x5e3c50['get']({'plain':!![]});var _0x577e3b=_0x47e0('0x4b');return db[_0x47e0('0x4c')][_0x47e0('0x4d')]({'where':{'name':_0x577e3b,'userProfileId':_0x2036de[_0x47e0('0x4e')]},'raw':!![]})[_0x47e0('0x21')](function(_0x117c7c){if(_0x117c7c&&_0x117c7c[_0x47e0('0x4f')]===0x0){return db[_0x47e0('0x25')][_0x47e0('0x47')]({'name':_0x31ac76['name'],'resourceId':_0x31ac76['id'],'type':_0x47e0('0x24'),'sectionId':_0x117c7c['id']},{})[_0x47e0('0x21')](function(){return _0x5e3c50;});}else{return _0x5e3c50;}})[_0x47e0('0x44')](function(_0xd3f1a3){logger[_0x47e0('0x26')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0xd3f1a3);throw _0xd3f1a3;});}return _0x5e3c50;})[_0x47e0('0x21')](respondWithResult(_0x127747,0xc9))[_0x47e0('0x44')](handleError(_0x127747,null));};exports[_0x47e0('0x20')]=function(_0x51ff0,_0x4107ae){if(_0x51ff0['body']['id']){delete _0x51ff0['body']['id'];}return db[_0x47e0('0x2a')]['find']({'where':{'id':_0x51ff0['params']['id']}})[_0x47e0('0x21')](handleEntityNotFound(_0x4107ae,null))[_0x47e0('0x21')](saveUpdates(_0x51ff0['body'],null))['then'](respondWithResult(_0x4107ae,null))['catch'](handleError(_0x4107ae,null));};exports[_0x47e0('0x22')]=function(_0x177e56,_0x129656){return db['AnalyticCustomReport'][_0x47e0('0x4d')]({'where':{'id':_0x177e56[_0x47e0('0x46')]['id']}})[_0x47e0('0x21')](handleEntityNotFound(_0x129656,null))[_0x47e0('0x21')](removeEntity(_0x129656,null))['catch'](handleError(_0x129656,null));};exports[_0x47e0('0x50')]=function(_0x7b304,_0x258bb5){var _0x170925=0xa;var _0x2a3105=['join',_0x47e0('0x51'),_0x47e0('0x52'),_0x47e0('0x53')];var _0x3d54e5={'SUM':_0x47e0('0x54'),'COUNT':_0x47e0('0x55'),'COUNT DISTINCT':_0x47e0('0x56'),'MAX':_0x47e0('0x57'),'MIN':'MIN(%s)','AVG':_0x47e0('0x58'),'GROUP_CONCAT':_0x47e0('0x59'),'GROUP_CONCAT ASC':_0x47e0('0x5a'),'GROUP_CONCAT DESC':_0x47e0('0x5b')};var _0x4868e0={'SEC_TO_TIME':_0x47e0('0x5c'),'DATE':'DATE(%s)','HOUR':_0x47e0('0x5d'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x4d85b1=function(_0x27c1aa){return!_[_0x47e0('0x5e')]([_0x47e0('0x5f'),_0x47e0('0x60'),'IS\x20EMPTY',_0x47e0('0x61')],_0x27c1aa);};var _0x3c411d=function(_0x539097){if(!_0x539097||!_0x539097[_0x47e0('0x62')]['length']){return'';}for(var _0x356902='(',_0x56c8d8=0x0;_0x56c8d8<_0x539097[_0x47e0('0x62')][_0x47e0('0x34')];_0x56c8d8+=0x1){_0x56c8d8>0x0&&(_0x356902+='\x20'+_0x539097[_0x47e0('0x63')]+'\x20');_0x356902+=_0x539097[_0x47e0('0x62')][_0x56c8d8][_0x47e0('0x64')]?_0x3c411d(_0x539097['rules'][_0x56c8d8][_0x47e0('0x64')]):_0x539097[_0x47e0('0x62')][_0x56c8d8][_0x47e0('0x65')]+'\x20'+_0x539097[_0x47e0('0x62')][_0x56c8d8][_0x47e0('0x66')]+(_0x4d85b1(_0x539097[_0x47e0('0x62')][_0x56c8d8][_0x47e0('0x66')])?'\x20'+_0x539097['rules'][_0x56c8d8][_0x47e0('0x67')]:'');}return _0x356902+')';};var _0x5570cc={'where':{'id':_0x7b304[_0x47e0('0x46')]['id']}},_0xe51aff,_0x448dbf,_0x55d2b8,_0x3ad23a,_0x39f38f;_0x5570cc=_[_0x47e0('0x3d')]({},_0x5570cc,_0x7b304[_0x47e0('0x40')]);return db[_0x47e0('0x2a')][_0x47e0('0x4d')](_0x5570cc)[_0x47e0('0x21')](function(_0x5c4200){if(_0x5c4200){_0xe51aff=_0x5c4200;return _0x5c4200[_0x47e0('0x68')]();}return null;})[_0x47e0('0x21')](function(_0x578b5a){if(_0x578b5a){if(!_0x578b5a[_0x47e0('0x34')]){throw new db[(_0x47e0('0x69'))][(_0x47e0('0x6a'))](_0x47e0('0x6b'),0x193);}_0x448dbf=_0x578b5a;return db['AnalyticMetric']['findAll']({'raw':!![]});}return null;})[_0x47e0('0x21')](function(_0x271f52){if(_0x271f52){_0x55d2b8=_[_0x47e0('0x6c')](_0x271f52,'id');var _0x16dec5;var _0x3adfb7=squel[_0x47e0('0x6d')]();_0x3adfb7[_0x47e0('0x6e')](_0xe51aff[_0x47e0('0x6f')]);for(var _0x4a3cd1=0x0;_0x4a3cd1<_0x448dbf[_0x47e0('0x34')];_0x4a3cd1+=0x1){_0x16dec5=_0x448dbf[_0x4a3cd1]['MetricId']?_0x55d2b8[_0x448dbf[_0x4a3cd1][_0x47e0('0x70')]]['metric']:_0x448dbf[_0x4a3cd1]['field'];_0x16dec5=_0x448dbf[_0x4a3cd1]['function']?_['replace'](_0x3d54e5[_0x448dbf[_0x4a3cd1]['function']],'%s',_0x16dec5):_0x16dec5;_0x16dec5=_0x448dbf[_0x4a3cd1][_0x47e0('0x71')]?_[_0x47e0('0x72')](_0x4868e0[_0x448dbf[_0x4a3cd1][_0x47e0('0x71')]],'%s',_0x16dec5):_0x16dec5;if(_0x448dbf[_0x4a3cd1]['groupBy']){_0x3adfb7[_0x47e0('0x64')](_0x16dec5);}_0x448dbf[_0x4a3cd1][_0x47e0('0x73')]&&_0x3adfb7[_0x47e0('0x38')](_0x16dec5,_0x448dbf[_0x4a3cd1][_0x47e0('0x73')]===_0x47e0('0x74')?![]:!![]);_0x3adfb7['field'](_0x16dec5,_0x448dbf[_0x4a3cd1]['alias']||_0x16dec5);}if(_0xe51aff['joins']){_0xe51aff[_0x47e0('0x75')]=JSON[_0x47e0('0x76')](_0xe51aff[_0x47e0('0x75')]);for(var _0x4b3446=0x0;_0x4b3446<_0xe51aff[_0x47e0('0x75')][_0x47e0('0x34')];_0x4b3446+=0x1){if(_0xe51aff[_0x47e0('0x75')][_0x4b3446][_0x47e0('0x2d')]&&_[_0x47e0('0x5e')](_0x2a3105,_0xe51aff['joins'][_0x4b3446][_0x47e0('0x2d')])&&_0xe51aff[_0x47e0('0x75')][_0x4b3446]['parentKey']&&_0xe51aff[_0x47e0('0x75')][_0x4b3446][_0x47e0('0x77')]&&_0xe51aff[_0x47e0('0x75')][_0x4b3446]['foreignKey']){_0x3adfb7[_0xe51aff[_0x47e0('0x75')][_0x4b3446][_0x47e0('0x2d')]](_0xe51aff[_0x47e0('0x75')][_0x4b3446][_0x47e0('0x77')],null,util[_0x47e0('0x71')](_0x47e0('0x78'),_0xe51aff[_0x47e0('0x6f')],_0xe51aff['joins'][_0x4b3446]['parentKey'],_0xe51aff[_0x47e0('0x75')][_0x4b3446][_0x47e0('0x77')],_0xe51aff['joins'][_0x4b3446][_0x47e0('0x79')]));}}}if(_0xe51aff[_0x47e0('0x7a')]){_0xe51aff[_0x47e0('0x7a')]=JSON['parse'](_0xe51aff[_0x47e0('0x7a')]);_0x3adfb7['where'](_0x3c411d(_0xe51aff[_0x47e0('0x7a')][_0x47e0('0x64')]));}_0x39f38f=_0x3adfb7['clone']();_0x3adfb7[_0x47e0('0x37')](_0x170925);_0x3adfb7['offset'](0x0);logger[_0x47e0('0x7b')](_0x47e0('0x7c'),_0x3adfb7[_0x47e0('0x7d')]());return dbH[_0x47e0('0x7e')][_0x47e0('0x2f')](_0x3adfb7[_0x47e0('0x7d')](),{'type':dbH['sequelize'][_0x47e0('0x7f')][_0x47e0('0x80')]});}})[_0x47e0('0x21')](respondWithResult(_0x258bb5,null))[_0x47e0('0x44')](handleError(_0x258bb5,null));};function runReport(_0x53216f,_0x2c86fc,_0x5f0a61){var _0x3e25d5=_0x2c86fc[_0x47e0('0x28')];var _0x281b65=0xa;var _0x385dea=[_0x47e0('0x81'),_0x47e0('0x51'),_0x47e0('0x52'),_0x47e0('0x53')];var _0x2efbbc={'SUM':_0x47e0('0x54'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x47e0('0x56'),'MAX':_0x47e0('0x57'),'MIN':'MIN(%s)','AVG':_0x47e0('0x58'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x47e0('0x5a'),'GROUP_CONCAT DESC':_0x47e0('0x5b')};var _0xc5eefa={'SEC_TO_TIME':_0x47e0('0x5c'),'DATE':_0x47e0('0x82'),'HOUR':_0x47e0('0x5d'),'ROUND':_0x47e0('0x83'),'UNIX_TIMESTAMP':_0x47e0('0x84')};var _0x4a9058=function(_0x558f26){return!_['includes']([_0x47e0('0x5f'),'IS\x20NOT\x20NULL','IS\x20EMPTY',_0x47e0('0x61')],_0x558f26);};var _0x28537a=function(_0x1e6d03){if(!_0x1e6d03||!_0x1e6d03['rules'][_0x47e0('0x34')]){return'';}for(var _0x37fba6='(',_0x402ec9=0x0;_0x402ec9<_0x1e6d03['rules'][_0x47e0('0x34')];_0x402ec9+=0x1){_0x402ec9>0x0&&(_0x37fba6+='\x20'+_0x1e6d03[_0x47e0('0x63')]+'\x20');_0x37fba6+=_0x1e6d03['rules'][_0x402ec9][_0x47e0('0x64')]?_0x28537a(_0x1e6d03[_0x47e0('0x62')][_0x402ec9][_0x47e0('0x64')]):_0x1e6d03[_0x47e0('0x62')][_0x402ec9][_0x47e0('0x65')]+'\x20'+_0x1e6d03[_0x47e0('0x62')][_0x402ec9]['condition']+(_0x4a9058(_0x1e6d03[_0x47e0('0x62')][_0x402ec9][_0x47e0('0x66')])?'\x20'+_0x1e6d03[_0x47e0('0x62')][_0x402ec9]['value']:'');}return _0x37fba6+')';};var _0x18d01f={'where':{'id':_0x53216f['id']}},_0x47e4f8,_0x4eb9ca,_0xbd46dd,_0x3930d3,_0x1cdce3;_0x18d01f=_[_0x47e0('0x3d')]({},_0x18d01f,_0x5f0a61);return db[_0x47e0('0x2a')][_0x47e0('0x4d')](_0x18d01f)[_0x47e0('0x21')](function(_0x228279){if(_0x228279){_0x47e4f8=_0x228279;return _0x228279[_0x47e0('0x68')]();}return null;})[_0x47e0('0x21')](function(_0x3d8505){if(_0x3d8505){if(!_0x3d8505['length']){throw new db['Sequelize'][(_0x47e0('0x6a'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x4eb9ca=_0x3d8505;return db[_0x47e0('0x85')][_0x47e0('0x43')]({'raw':!![]});}return null;})[_0x47e0('0x21')](function(_0x447c6a){if(_0x447c6a){_0xbd46dd=_[_0x47e0('0x6c')](_0x447c6a,'id');var _0x464afc;var _0x549268=squel[_0x47e0('0x6d')]();_0x549268[_0x47e0('0x6e')](_0x47e4f8[_0x47e0('0x6f')]);for(var _0x527641=0x0;_0x527641<_0x4eb9ca[_0x47e0('0x34')];_0x527641+=0x1){_0x464afc=_0x4eb9ca[_0x527641][_0x47e0('0x70')]?_0xbd46dd[_0x4eb9ca[_0x527641][_0x47e0('0x70')]][_0x47e0('0x86')]:_0x4eb9ca[_0x527641][_0x47e0('0x65')];_0x464afc=_0x4eb9ca[_0x527641][_0x47e0('0x87')]?_[_0x47e0('0x72')](_0x2efbbc[_0x4eb9ca[_0x527641]['function']],'%s',_0x464afc):_0x464afc;_0x464afc=_0x4eb9ca[_0x527641]['format']?_[_0x47e0('0x72')](_0xc5eefa[_0x4eb9ca[_0x527641][_0x47e0('0x71')]],'%s',_0x464afc):_0x464afc;if(_0x4eb9ca[_0x527641]['groupBy']){_0x549268['group'](_0x464afc);}_0x4eb9ca[_0x527641]['orderBy']&&_0x549268[_0x47e0('0x38')](_0x464afc,_0x4eb9ca[_0x527641]['orderBy']===_0x47e0('0x74')?![]:!![]);_0x549268[_0x47e0('0x65')](_0x464afc,_0x4eb9ca[_0x527641][_0x47e0('0x88')]||_0x464afc);}if(_0x47e4f8['joins']){_0x47e4f8[_0x47e0('0x75')]=JSON[_0x47e0('0x76')](_0x47e4f8[_0x47e0('0x75')]);for(var _0x2c766e=0x0;_0x2c766e<_0x47e4f8['joins']['length'];_0x2c766e+=0x1){if(_0x47e4f8[_0x47e0('0x75')][_0x2c766e]['type']&&_[_0x47e0('0x5e')](_0x385dea,_0x47e4f8[_0x47e0('0x75')][_0x2c766e][_0x47e0('0x2d')])&&_0x47e4f8[_0x47e0('0x75')][_0x2c766e]['parentKey']&&_0x47e4f8['joins'][_0x2c766e][_0x47e0('0x77')]&&_0x47e4f8[_0x47e0('0x75')][_0x2c766e][_0x47e0('0x79')]){_0x549268[_0x47e4f8['joins'][_0x2c766e]['type']](_0x47e4f8[_0x47e0('0x75')][_0x2c766e][_0x47e0('0x77')],null,util[_0x47e0('0x71')]('%s.%s\x20=\x20%s.%s',_0x47e4f8[_0x47e0('0x6f')],_0x47e4f8[_0x47e0('0x75')][_0x2c766e]['parentKey'],_0x47e4f8[_0x47e0('0x75')][_0x2c766e][_0x47e0('0x77')],_0x47e4f8[_0x47e0('0x75')][_0x2c766e][_0x47e0('0x79')]));}}}if(_0x47e4f8[_0x47e0('0x7a')]){_0x47e4f8['conditions']=JSON['parse'](_0x47e4f8['conditions']);_0x549268[_0x47e0('0x3a')](_0x28537a(_0x47e4f8[_0x47e0('0x7a')][_0x47e0('0x64')]));}_0x1cdce3=_0x549268[_0x47e0('0x89')]();_0x549268['limit'](_0x281b65);_0x549268[_0x47e0('0x1a')](0x0);return;}})['then'](function(){if(_0x2c86fc[_0x47e0('0x8a')]==='web'){return null;}var _0x21d6b4=_[_0x47e0('0x3d')](_0x2c86fc,{'name':_0x2c86fc[_0x47e0('0x8b')]||_0x2c86fc[_0x47e0('0x28')]||_0x47e4f8[_0x47e0('0x28')],'basename':_0x3e25d5,'savename':util[_0x47e0('0x71')](_0x47e0('0x8c'),_0x2c86fc[_0x47e0('0x28')]||_0x47e4f8['name'],require(_0x47e0('0x8d'))['generate'](0x4),_0x2c86fc[_0x47e0('0x8a')]||'csv'),'reportId':_0x47e4f8['id'],'reportType':_0x47e0('0x8e')});return db[_0x47e0('0x8f')][_0x47e0('0x47')](_0x21d6b4,{'raw':!![]});})[_0x47e0('0x21')](function(_0x1677c6){if(_0x47e4f8['table']===_0x47e0('0x90')){_0x1cdce3[_0x47e0('0x3a')](_0x47e4f8[_0x47e0('0x6f')]+_0x47e0('0x91'),_0x2c86fc[_0x47e0('0x92')],_0x2c86fc[_0x47e0('0x93')]);}else{_0x1cdce3['where'](_0x47e4f8['table']+_0x47e0('0x94'),_0x2c86fc[_0x47e0('0x92')],_0x2c86fc[_0x47e0('0x93')]);}if(_0x1677c6){logger['info'](_0x47e0('0x95'),_0x1cdce3[_0x47e0('0x7d')]());require(_0x47e0('0x96'))[_0x47e0('0x97')](path['join'](__dirname,_0x47e0('0x98'),_0x1677c6[_0x47e0('0x8a')]),[_0x1677c6['id'],_0x1cdce3[_0x47e0('0x7d')](),path['join'](__dirname,_0x47e0('0x99'),_0x1677c6[_0x47e0('0x9a')]),_0x3e25d5]);return _0x1677c6;}else{var _0x6c8ced=squel[_0x47e0('0x6d')]();_0x6c8ced[_0x47e0('0x6e')]('('+_0x1cdce3[_0x47e0('0x7d')]()+')','countTable');_0x6c8ced[_0x47e0('0x65')]('COUNT(*)','count');_0x1cdce3[_0x47e0('0x37')](_0x2c86fc[_0x47e0('0x37')]||_0x281b65);_0x1cdce3[_0x47e0('0x1a')](_0x2c86fc[_0x47e0('0x1a')]||0x0);return dbH[_0x47e0('0x7e')]['query'](_0x6c8ced[_0x47e0('0x7d')](),{'type':dbH['sequelize'][_0x47e0('0x7f')]['SELECT']})[_0x47e0('0x21')](function(_0x5df981){if(!_0x5df981['length']){_0x3930d3=0x0;}else{_0x3930d3=_0x5df981[0x0][_0x47e0('0x19')]||0x0;}return dbH[_0x47e0('0x7e')][_0x47e0('0x2f')](_0x1cdce3[_0x47e0('0x7d')](),{'type':dbH[_0x47e0('0x7e')][_0x47e0('0x7f')][_0x47e0('0x80')]});})[_0x47e0('0x21')](function(_0x241b8c){return{'rows':_0x241b8c||[],'count':_0x3930d3};});}});}exports['run']=function(_0x11a137,_0x1a51bb){return runReport(_0x11a137['params'],_0x11a137['query'],_0x11a137['options'])[_0x47e0('0x21')](respondWithResult(_0x1a51bb,null))[_0x47e0('0x44')](handleError(_0x1a51bb,null));};exports[_0x47e0('0x9b')]=runReport;exports['query']=function(_0x5c19a0,_0x18cc44){var _0x215cfb=0xa;var _0x68cf98=[_0x47e0('0x81'),_0x47e0('0x51'),_0x47e0('0x52'),'cross_join'];var _0x313ffe={'SUM':_0x47e0('0x54'),'COUNT':_0x47e0('0x55'),'COUNT DISTINCT':_0x47e0('0x56'),'MAX':'MAX(%s)','MIN':_0x47e0('0x9c'),'AVG':_0x47e0('0x58'),'GROUP_CONCAT':_0x47e0('0x59'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x217232={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':'ROUND(%s)','UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x2ab1fd=function(_0x432ba8){return!_[_0x47e0('0x5e')]([_0x47e0('0x5f'),_0x47e0('0x60'),'IS\x20EMPTY',_0x47e0('0x61')],_0x432ba8);};var _0x1a60d0=function(_0x1d76b2){if(!_0x1d76b2||!_0x1d76b2[_0x47e0('0x62')]['length']){return'';}for(var _0x5bb533='(',_0x2977f8=0x0;_0x2977f8<_0x1d76b2[_0x47e0('0x62')]['length'];_0x2977f8+=0x1){_0x2977f8>0x0&&(_0x5bb533+='\x20'+_0x1d76b2[_0x47e0('0x63')]+'\x20');_0x5bb533+=_0x1d76b2[_0x47e0('0x62')][_0x2977f8][_0x47e0('0x64')]?_0x1a60d0(_0x1d76b2[_0x47e0('0x62')][_0x2977f8][_0x47e0('0x64')]):_0x1d76b2[_0x47e0('0x62')][_0x2977f8][_0x47e0('0x65')]+'\x20'+_0x1d76b2[_0x47e0('0x62')][_0x2977f8][_0x47e0('0x66')]+(_0x2ab1fd(_0x1d76b2[_0x47e0('0x62')][_0x2977f8][_0x47e0('0x66')])?'\x20'+_0x1d76b2[_0x47e0('0x62')][_0x2977f8][_0x47e0('0x67')]:'');}return _0x5bb533+')';};var _0x507fe8={'where':{'id':_0x5c19a0[_0x47e0('0x46')]['id']}},_0x4af737,_0x465a06,_0x5e27b9,_0x255196,_0x4e8a98;_0x507fe8=_[_0x47e0('0x3d')]({},_0x507fe8,_0x5c19a0[_0x47e0('0x40')]);return db[_0x47e0('0x2a')][_0x47e0('0x4d')](_0x507fe8)['then'](function(_0x32aa95){if(_0x32aa95){_0x4af737=_0x32aa95;return _0x32aa95['getFields']();}return null;})[_0x47e0('0x21')](function(_0x49283b){if(_0x49283b){if(!_0x49283b[_0x47e0('0x34')]){throw new db['Sequelize'][(_0x47e0('0x6a'))](_0x47e0('0x6b'),0x193);}_0x465a06=_0x49283b;return db[_0x47e0('0x85')]['findAll']({'raw':!![]});}return null;})[_0x47e0('0x21')](function(_0x1f7c0c){if(_0x1f7c0c){_0x5e27b9=_[_0x47e0('0x6c')](_0x1f7c0c,'id');var _0x40e3b3;var _0x4a8296=squel[_0x47e0('0x6d')]();_0x4a8296[_0x47e0('0x6e')](_0x4af737['table']);for(var _0x2e9c1f=0x0;_0x2e9c1f<_0x465a06[_0x47e0('0x34')];_0x2e9c1f+=0x1){_0x40e3b3=_0x465a06[_0x2e9c1f][_0x47e0('0x70')]?_0x5e27b9[_0x465a06[_0x2e9c1f][_0x47e0('0x70')]][_0x47e0('0x86')]:_0x465a06[_0x2e9c1f]['field'];_0x40e3b3=_0x465a06[_0x2e9c1f]['function']?_[_0x47e0('0x72')](_0x313ffe[_0x465a06[_0x2e9c1f][_0x47e0('0x87')]],'%s',_0x40e3b3):_0x40e3b3;_0x40e3b3=_0x465a06[_0x2e9c1f][_0x47e0('0x71')]?_[_0x47e0('0x72')](_0x217232[_0x465a06[_0x2e9c1f]['format']],'%s',_0x40e3b3):_0x40e3b3;if(_0x465a06[_0x2e9c1f][_0x47e0('0x9d')]){_0x4a8296[_0x47e0('0x64')](_0x40e3b3);}_0x465a06[_0x2e9c1f]['orderBy']&&_0x4a8296[_0x47e0('0x38')](_0x40e3b3,_0x465a06[_0x2e9c1f][_0x47e0('0x73')]===_0x47e0('0x74')?![]:!![]);_0x4a8296[_0x47e0('0x65')](_0x40e3b3,_0x465a06[_0x2e9c1f]['alias']||_0x40e3b3);}if(_0x4af737[_0x47e0('0x75')]){_0x4af737[_0x47e0('0x75')]=JSON[_0x47e0('0x76')](_0x4af737[_0x47e0('0x75')]);for(var _0x4618d7=0x0;_0x4618d7<_0x4af737[_0x47e0('0x75')][_0x47e0('0x34')];_0x4618d7+=0x1){if(_0x4af737[_0x47e0('0x75')][_0x4618d7][_0x47e0('0x2d')]&&_[_0x47e0('0x5e')](_0x68cf98,_0x4af737[_0x47e0('0x75')][_0x4618d7][_0x47e0('0x2d')])&&_0x4af737[_0x47e0('0x75')][_0x4618d7][_0x47e0('0x9e')]&&_0x4af737[_0x47e0('0x75')][_0x4618d7][_0x47e0('0x77')]&&_0x4af737[_0x47e0('0x75')][_0x4618d7][_0x47e0('0x79')]){_0x4a8296[_0x4af737[_0x47e0('0x75')][_0x4618d7][_0x47e0('0x2d')]](_0x4af737['joins'][_0x4618d7]['foreignTable'],null,util['format'](_0x47e0('0x78'),_0x4af737[_0x47e0('0x6f')],_0x4af737[_0x47e0('0x75')][_0x4618d7][_0x47e0('0x9e')],_0x4af737[_0x47e0('0x75')][_0x4618d7]['foreignTable'],_0x4af737[_0x47e0('0x75')][_0x4618d7][_0x47e0('0x79')]));}}}if(_0x4af737[_0x47e0('0x7a')]){_0x4af737[_0x47e0('0x7a')]=JSON[_0x47e0('0x76')](_0x4af737['conditions']);_0x4a8296[_0x47e0('0x3a')](_0x1a60d0(_0x4af737[_0x47e0('0x7a')][_0x47e0('0x64')]));}_0x4e8a98=_0x4a8296[_0x47e0('0x89')]();_0x4a8296[_0x47e0('0x37')](_0x215cfb);_0x4a8296['offset'](0x0);logger[_0x47e0('0x7b')](_0x47e0('0x7c'),_0x4a8296['toString']());return dbH[_0x47e0('0x7e')][_0x47e0('0x2f')](_0x4a8296[_0x47e0('0x7d')](),{'type':dbH[_0x47e0('0x7e')][_0x47e0('0x7f')][_0x47e0('0x80')]});}})[_0x47e0('0x21')](function(){return{'sql':_0x4e8a98[_0x47e0('0x7d')]()};})[_0x47e0('0x21')](respondWithResult(_0x18cc44,null))[_0x47e0('0x44')](handleError(_0x18cc44,null));};
\ No newline at end of file
+var _0x5c1a=['key','model','query','filters','intersection','attributes','fields','length','hasOwnProperty','limit','sort','pick','where','merge','type','VIRTUAL','filter','options','includeAll','include','findAll','catch','show','params','keys','find','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','Reports','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','preview','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)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','value','Sequelize','ValidationErrorItem','AnalyticMetric','select','from','table','MetricId','metric','function','replace','format','groupBy','order','orderBy','joins','parse','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','conditions','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','join','left_join','cross_join','GROUP_CONCAT(%s)','Please\x20insert\x20at\x20least\x20one\x20field','keyBy','DESC','alias','clone','output','web','fullPath','randomstring','generate','csv','custom','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','startDate','info','Run\x20Query:','child_process','fork','../../components/export/','countTable','run','runReport','getFields','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','path','sox','lodash','squel','crypto','desk.js','to-csv','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','sendStatus','status','end','offset','count','set','Content-Range','json','update','then','destroy','get','CustomReports','UserProfileResource','error','stack','name','send','index','map','AnalyticCustomReport','rawAttributes','fieldName'];(function(_0x2ff55f,_0x19e45d){var _0x49d1db=function(_0x54c6fe){while(--_0x54c6fe){_0x2ff55f['push'](_0x2ff55f['shift']());}};_0x49d1db(++_0x19e45d);}(_0x5c1a,0x1c9));var _0xa5c1=function(_0x45d55e,_0x2fede3){_0x45d55e=_0x45d55e-0x0;var _0x29812a=_0x5c1a[_0x45d55e];return _0x29812a;};'use strict';var emlformat=require(_0xa5c1('0x0'));var rimraf=require(_0xa5c1('0x1'));var zipdir=require(_0xa5c1('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0xa5c1('0x3'));var moment=require(_0xa5c1('0x4'));var BPromise=require(_0xa5c1('0x5'));var Mustache=require(_0xa5c1('0x6'));var util=require('util');var path=require(_0xa5c1('0x7'));var sox=require(_0xa5c1('0x8'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xa5c1('0x9'));var squel=require(_0xa5c1('0xa'));var crypto=require(_0xa5c1('0xb'));var jsforce=require('jsforce');var deskjs=require(_0xa5c1('0xc'));var toCsv=require(_0xa5c1('0xd'));var querystring=require(_0xa5c1('0xe'));var Papa=require(_0xa5c1('0xf'));var Redis=require(_0xa5c1('0x10'));var authService=require(_0xa5c1('0x11'));var qs=require(_0xa5c1('0x12'));var as=require(_0xa5c1('0x13'));var hardwareService=require(_0xa5c1('0x14'));var logger=require(_0xa5c1('0x15'))(_0xa5c1('0x16'));var utils=require(_0xa5c1('0x17'));var config=require(_0xa5c1('0x18'));var licenseUtil=require(_0xa5c1('0x19'));var db=require(_0xa5c1('0x1a'))['db'];var dbH=require(_0xa5c1('0x1a'))['dbH'];function respondWithStatusCode(_0x43cab5,_0x4915ea){_0x4915ea=_0x4915ea||0xcc;return function(_0x52688c){if(_0x52688c){return _0x43cab5[_0xa5c1('0x1b')](_0x4915ea);}return _0x43cab5[_0xa5c1('0x1c')](_0x4915ea)[_0xa5c1('0x1d')]();};}function respondWithResult(_0x590098,_0x174319){_0x174319=_0x174319||0xc8;return function(_0x2a531e){if(_0x2a531e){return _0x590098[_0xa5c1('0x1c')](_0x174319)['json'](_0x2a531e);}};}function respondWithFilteredResult(_0x572bbc,_0x694b5){return function(_0x4d77e1){if(_0x4d77e1){var _0x2a37be=typeof _0x694b5[_0xa5c1('0x1e')]==='undefined'&&typeof _0x694b5['limit']==='undefined';var _0x534841=_0x4d77e1[_0xa5c1('0x1f')];var _0x329206=_0x2a37be?0x0:_0x694b5[_0xa5c1('0x1e')];var _0x1b2524=_0x2a37be?_0x4d77e1['count']:_0x694b5[_0xa5c1('0x1e')]+_0x694b5['limit'];var _0x270053;if(_0x1b2524>=_0x534841){_0x1b2524=_0x534841;_0x270053=0xc8;}else{_0x270053=0xce;}_0x572bbc['status'](_0x270053);return _0x572bbc[_0xa5c1('0x20')](_0xa5c1('0x21'),_0x329206+'-'+_0x1b2524+'/'+_0x534841)[_0xa5c1('0x22')](_0x4d77e1);}return null;};}function patchUpdates(_0x13f69d){return function(_0x15ae4b){try{jsonpatch['apply'](_0x15ae4b,_0x13f69d,!![]);}catch(_0x31836c){return BPromise['reject'](_0x31836c);}return _0x15ae4b['save']();};}function saveUpdates(_0x6ccfe8,_0x28379f){return function(_0x9c4153){if(_0x9c4153){return _0x9c4153[_0xa5c1('0x23')](_0x6ccfe8)[_0xa5c1('0x24')](function(_0x44806f){return _0x44806f;});}return null;};}function removeEntity(_0x363d16,_0x37b036){return function(_0x26aa57){if(_0x26aa57){return _0x26aa57[_0xa5c1('0x25')]()[_0xa5c1('0x24')](function(){var _0x4cd7a1=_0x26aa57[_0xa5c1('0x26')]({'plain':!![]});var _0x46cfc5=_0xa5c1('0x27');return db[_0xa5c1('0x28')][_0xa5c1('0x25')]({'where':{'type':_0x46cfc5,'resourceId':_0x4cd7a1['id']}})[_0xa5c1('0x24')](function(){return _0x26aa57;});})[_0xa5c1('0x24')](function(){_0x363d16['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x1f95d8,_0x51219e){return function(_0x388af0){if(!_0x388af0){_0x1f95d8[_0xa5c1('0x1b')](0x194);}return _0x388af0;};}function handleError(_0x619f4d,_0x583cba){_0x583cba=_0x583cba||0x1f4;return function(_0x436e91){logger[_0xa5c1('0x29')](_0x436e91[_0xa5c1('0x2a')]);if(_0x436e91[_0xa5c1('0x2b')]){delete _0x436e91[_0xa5c1('0x2b')];}_0x619f4d[_0xa5c1('0x1c')](_0x583cba)[_0xa5c1('0x2c')](_0x436e91);};}exports[_0xa5c1('0x2d')]=function(_0x410da5,_0x320d31){var _0x192383={},_0x90989e={},_0x4d3ce6={'count':0x0,'rows':[]};var _0x3c7125=_[_0xa5c1('0x2e')](db[_0xa5c1('0x2f')][_0xa5c1('0x30')],function(_0x169bec){return{'name':_0x169bec[_0xa5c1('0x31')],'type':_0x169bec['type'][_0xa5c1('0x32')]};});_0x90989e[_0xa5c1('0x33')]=_[_0xa5c1('0x2e')](_0x3c7125,_0xa5c1('0x2b'));_0x90989e[_0xa5c1('0x34')]=_['keys'](_0x410da5['query']);_0x90989e[_0xa5c1('0x35')]=_[_0xa5c1('0x36')](_0x90989e[_0xa5c1('0x33')],_0x90989e[_0xa5c1('0x34')]);_0x192383[_0xa5c1('0x37')]=_['intersection'](_0x90989e[_0xa5c1('0x33')],qs[_0xa5c1('0x38')](_0x410da5['query']['fields']));_0x192383['attributes']=_0x192383['attributes'][_0xa5c1('0x39')]?_0x192383['attributes']:_0x90989e[_0xa5c1('0x33')];if(!_0x410da5[_0xa5c1('0x34')][_0xa5c1('0x3a')]('nolimit')){_0x192383[_0xa5c1('0x3b')]=qs[_0xa5c1('0x3b')](_0x410da5[_0xa5c1('0x34')][_0xa5c1('0x3b')]);_0x192383['offset']=qs[_0xa5c1('0x1e')](_0x410da5['query'][_0xa5c1('0x1e')]);}_0x192383['order']=qs['sort'](_0x410da5[_0xa5c1('0x34')][_0xa5c1('0x3c')]);_0x192383['where']=qs[_0xa5c1('0x35')](_[_0xa5c1('0x3d')](_0x410da5[_0xa5c1('0x34')],_0x90989e[_0xa5c1('0x35')]),_0x3c7125);if(_0x410da5['query']['filter']){_0x192383[_0xa5c1('0x3e')]=_[_0xa5c1('0x3f')](_0x192383[_0xa5c1('0x3e')],{'$or':_[_0xa5c1('0x2e')](_0x3c7125,function(_0x5b9cde){if(_0x5b9cde[_0xa5c1('0x40')]!==_0xa5c1('0x41')){var _0x278cc={};_0x278cc[_0x5b9cde[_0xa5c1('0x2b')]]={'$like':'%'+_0x410da5[_0xa5c1('0x34')][_0xa5c1('0x42')]+'%'};return _0x278cc;}})});}_0x192383=_[_0xa5c1('0x3f')]({},_0x192383,_0x410da5[_0xa5c1('0x43')]);var _0xbeadf0={'where':_0x192383[_0xa5c1('0x3e')]};return db['AnalyticCustomReport']['count'](_0xbeadf0)['then'](function(_0x1e7bdd){_0x4d3ce6['count']=_0x1e7bdd;if(_0x410da5['query'][_0xa5c1('0x44')]){_0x192383[_0xa5c1('0x45')]=[{'all':!![]}];}return db[_0xa5c1('0x2f')][_0xa5c1('0x46')](_0x192383);})['then'](function(_0x258307){_0x4d3ce6['rows']=_0x258307;return _0x4d3ce6;})[_0xa5c1('0x24')](respondWithFilteredResult(_0x320d31,_0x192383))[_0xa5c1('0x47')](handleError(_0x320d31,null));};exports[_0xa5c1('0x48')]=function(_0x3037f4,_0x3284bf){var _0x999661={'raw':![],'where':{'id':_0x3037f4[_0xa5c1('0x49')]['id']}},_0x4bba99={};_0x4bba99['model']=_['keys'](db[_0xa5c1('0x2f')]['rawAttributes']);_0x4bba99['query']=_[_0xa5c1('0x4a')](_0x3037f4[_0xa5c1('0x34')]);_0x4bba99[_0xa5c1('0x35')]=_[_0xa5c1('0x36')](_0x4bba99[_0xa5c1('0x33')],_0x4bba99[_0xa5c1('0x34')]);_0x999661[_0xa5c1('0x37')]=_[_0xa5c1('0x36')](_0x4bba99[_0xa5c1('0x33')],qs['fields'](_0x3037f4[_0xa5c1('0x34')]['fields']));_0x999661[_0xa5c1('0x37')]=_0x999661[_0xa5c1('0x37')][_0xa5c1('0x39')]?_0x999661['attributes']:_0x4bba99[_0xa5c1('0x33')];if(_0x3037f4[_0xa5c1('0x34')][_0xa5c1('0x44')]){_0x999661[_0xa5c1('0x45')]=[{'all':!![]}];}_0x999661=_['merge']({},_0x999661,_0x3037f4['options']);return db[_0xa5c1('0x2f')][_0xa5c1('0x4b')](_0x999661)[_0xa5c1('0x24')](handleEntityNotFound(_0x3284bf,null))[_0xa5c1('0x24')](respondWithResult(_0x3284bf,null))[_0xa5c1('0x47')](handleError(_0x3284bf,null));};exports[_0xa5c1('0x4c')]=function(_0x2d2b77,_0x5cba79){return db[_0xa5c1('0x2f')]['create'](_0x2d2b77[_0xa5c1('0x4d')],{})['then'](function(_0x2d71a4){var _0x17c336=_0x2d2b77['user'][_0xa5c1('0x26')]({'plain':!![]});if(!_0x17c336)throw new Error(_0xa5c1('0x4e'));if(_0x17c336[_0xa5c1('0x4f')]===_0xa5c1('0x50')){var _0x182369=_0x2d71a4[_0xa5c1('0x26')]({'plain':!![]});var _0x2bd0e4=_0xa5c1('0x51');return db[_0xa5c1('0x52')][_0xa5c1('0x4b')]({'where':{'name':_0x2bd0e4,'userProfileId':_0x17c336[_0xa5c1('0x53')]},'raw':!![]})[_0xa5c1('0x24')](function(_0x1dff17){if(_0x1dff17&&_0x1dff17[_0xa5c1('0x54')]===0x0){return db[_0xa5c1('0x28')][_0xa5c1('0x4c')]({'name':_0x182369['name'],'resourceId':_0x182369['id'],'type':'CustomReports','sectionId':_0x1dff17['id']},{})['then'](function(){return _0x2d71a4;});}else{return _0x2d71a4;}})[_0xa5c1('0x47')](function(_0x2bd409){logger['error'](_0xa5c1('0x55'),_0x2bd409);throw _0x2bd409;});}return _0x2d71a4;})[_0xa5c1('0x24')](respondWithResult(_0x5cba79,0xc9))[_0xa5c1('0x47')](handleError(_0x5cba79,null));};exports['update']=function(_0x5229a7,_0x1c2017){if(_0x5229a7[_0xa5c1('0x4d')]['id']){delete _0x5229a7[_0xa5c1('0x4d')]['id'];}return db['AnalyticCustomReport'][_0xa5c1('0x4b')]({'where':{'id':_0x5229a7[_0xa5c1('0x49')]['id']}})[_0xa5c1('0x24')](handleEntityNotFound(_0x1c2017,null))[_0xa5c1('0x24')](saveUpdates(_0x5229a7[_0xa5c1('0x4d')],null))[_0xa5c1('0x24')](respondWithResult(_0x1c2017,null))[_0xa5c1('0x47')](handleError(_0x1c2017,null));};exports['destroy']=function(_0x2668be,_0x1cdb12){return db['AnalyticCustomReport'][_0xa5c1('0x4b')]({'where':{'id':_0x2668be[_0xa5c1('0x49')]['id']}})[_0xa5c1('0x24')](handleEntityNotFound(_0x1cdb12,null))[_0xa5c1('0x24')](removeEntity(_0x1cdb12,null))[_0xa5c1('0x47')](handleError(_0x1cdb12,null));};exports[_0xa5c1('0x56')]=function(_0x2a6c58,_0x5e11b2){var _0x184b06=0xa;var _0x3292a1=['join','left_join',_0xa5c1('0x57'),'cross_join'];var _0x42b76a={'SUM':_0xa5c1('0x58'),'COUNT':_0xa5c1('0x59'),'COUNT DISTINCT':_0xa5c1('0x5a'),'MAX':_0xa5c1('0x5b'),'MIN':_0xa5c1('0x5c'),'AVG':_0xa5c1('0x5d'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0xa5c1('0x5e'),'GROUP_CONCAT DESC':_0xa5c1('0x5f')};var _0x14daa6={'SEC_TO_TIME':_0xa5c1('0x60'),'DATE':_0xa5c1('0x61'),'HOUR':_0xa5c1('0x62'),'ROUND':_0xa5c1('0x63'),'UNIX_TIMESTAMP':_0xa5c1('0x64')};var _0x2aefdc=function(_0xa1958f){return!_[_0xa5c1('0x65')]([_0xa5c1('0x66'),_0xa5c1('0x67'),_0xa5c1('0x68'),_0xa5c1('0x69')],_0xa1958f);};var _0x2bf9db=function(_0x4052b){if(!_0x4052b||!_0x4052b[_0xa5c1('0x6a')][_0xa5c1('0x39')]){return'';}for(var _0x3f89fd='(',_0x2378c1=0x0;_0x2378c1<_0x4052b[_0xa5c1('0x6a')][_0xa5c1('0x39')];_0x2378c1+=0x1){_0x2378c1>0x0&&(_0x3f89fd+='\x20'+_0x4052b[_0xa5c1('0x6b')]+'\x20');_0x3f89fd+=_0x4052b['rules'][_0x2378c1]['group']?_0x2bf9db(_0x4052b['rules'][_0x2378c1][_0xa5c1('0x6c')]):_0x4052b[_0xa5c1('0x6a')][_0x2378c1][_0xa5c1('0x6d')]+'\x20'+_0x4052b[_0xa5c1('0x6a')][_0x2378c1][_0xa5c1('0x6e')]+(_0x2aefdc(_0x4052b[_0xa5c1('0x6a')][_0x2378c1][_0xa5c1('0x6e')])?'\x20'+_0x4052b[_0xa5c1('0x6a')][_0x2378c1][_0xa5c1('0x6f')]:'');}return _0x3f89fd+')';};var _0x51331a={'where':{'id':_0x2a6c58[_0xa5c1('0x49')]['id']}},_0x182f0b,_0x22db84,_0x42b4be,_0x53ae94,_0x2fe229;_0x51331a=_[_0xa5c1('0x3f')]({},_0x51331a,_0x2a6c58[_0xa5c1('0x43')]);return db[_0xa5c1('0x2f')]['find'](_0x51331a)['then'](function(_0x415a7d){if(_0x415a7d){_0x182f0b=_0x415a7d;return _0x415a7d['getFields']();}return null;})[_0xa5c1('0x24')](function(_0x3c774c){if(_0x3c774c){if(!_0x3c774c['length']){throw new db[(_0xa5c1('0x70'))][(_0xa5c1('0x71'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x22db84=_0x3c774c;return db[_0xa5c1('0x72')]['findAll']({'raw':!![]});}return null;})['then'](function(_0x13a046){if(_0x13a046){_0x42b4be=_['keyBy'](_0x13a046,'id');var _0x23cc03;var _0x2d247d=squel[_0xa5c1('0x73')]();_0x2d247d[_0xa5c1('0x74')](_0x182f0b[_0xa5c1('0x75')]);for(var _0x26ae73=0x0;_0x26ae73<_0x22db84[_0xa5c1('0x39')];_0x26ae73+=0x1){_0x23cc03=_0x22db84[_0x26ae73][_0xa5c1('0x76')]?_0x42b4be[_0x22db84[_0x26ae73][_0xa5c1('0x76')]][_0xa5c1('0x77')]:_0x22db84[_0x26ae73]['field'];_0x23cc03=_0x22db84[_0x26ae73][_0xa5c1('0x78')]?_[_0xa5c1('0x79')](_0x42b76a[_0x22db84[_0x26ae73][_0xa5c1('0x78')]],'%s',_0x23cc03):_0x23cc03;_0x23cc03=_0x22db84[_0x26ae73][_0xa5c1('0x7a')]?_['replace'](_0x14daa6[_0x22db84[_0x26ae73][_0xa5c1('0x7a')]],'%s',_0x23cc03):_0x23cc03;if(_0x22db84[_0x26ae73][_0xa5c1('0x7b')]){_0x2d247d[_0xa5c1('0x6c')](_0x23cc03);}_0x22db84[_0x26ae73]['orderBy']&&_0x2d247d[_0xa5c1('0x7c')](_0x23cc03,_0x22db84[_0x26ae73][_0xa5c1('0x7d')]==='DESC'?![]:!![]);_0x2d247d['field'](_0x23cc03,_0x22db84[_0x26ae73]['alias']||_0x23cc03);}if(_0x182f0b['joins']){_0x182f0b[_0xa5c1('0x7e')]=JSON[_0xa5c1('0x7f')](_0x182f0b[_0xa5c1('0x7e')]);for(var _0x41c9d4=0x0;_0x41c9d4<_0x182f0b['joins'][_0xa5c1('0x39')];_0x41c9d4+=0x1){if(_0x182f0b[_0xa5c1('0x7e')][_0x41c9d4][_0xa5c1('0x40')]&&_[_0xa5c1('0x65')](_0x3292a1,_0x182f0b['joins'][_0x41c9d4]['type'])&&_0x182f0b[_0xa5c1('0x7e')][_0x41c9d4][_0xa5c1('0x80')]&&_0x182f0b[_0xa5c1('0x7e')][_0x41c9d4][_0xa5c1('0x81')]&&_0x182f0b[_0xa5c1('0x7e')][_0x41c9d4][_0xa5c1('0x82')]){_0x2d247d[_0x182f0b['joins'][_0x41c9d4][_0xa5c1('0x40')]](_0x182f0b[_0xa5c1('0x7e')][_0x41c9d4][_0xa5c1('0x81')],null,util[_0xa5c1('0x7a')](_0xa5c1('0x83'),_0x182f0b[_0xa5c1('0x75')],_0x182f0b[_0xa5c1('0x7e')][_0x41c9d4][_0xa5c1('0x80')],_0x182f0b[_0xa5c1('0x7e')][_0x41c9d4]['foreignTable'],_0x182f0b['joins'][_0x41c9d4][_0xa5c1('0x82')]));}}}if(_0x182f0b[_0xa5c1('0x84')]){_0x182f0b['conditions']=JSON['parse'](_0x182f0b['conditions']);_0x2d247d[_0xa5c1('0x3e')](_0x2bf9db(_0x182f0b['conditions'][_0xa5c1('0x6c')]));}_0x2fe229=_0x2d247d['clone']();_0x2d247d[_0xa5c1('0x3b')](_0x184b06);_0x2d247d[_0xa5c1('0x1e')](0x0);logger[_0xa5c1('0x85')](_0xa5c1('0x86'),_0x2d247d[_0xa5c1('0x87')]());return dbH[_0xa5c1('0x88')][_0xa5c1('0x34')](_0x2d247d[_0xa5c1('0x87')](),{'type':dbH[_0xa5c1('0x88')][_0xa5c1('0x89')][_0xa5c1('0x8a')]});}})[_0xa5c1('0x24')](respondWithResult(_0x5e11b2,null))[_0xa5c1('0x47')](handleError(_0x5e11b2,null));};function runReport(_0x9879f9,_0x1d8631,_0x12eba9){var _0x3986e1=_0x1d8631[_0xa5c1('0x2b')];var _0x5a695b=0xa;var _0x55c619=[_0xa5c1('0x8b'),_0xa5c1('0x8c'),'right_join',_0xa5c1('0x8d')];var _0x3d28ed={'SUM':_0xa5c1('0x58'),'COUNT':_0xa5c1('0x59'),'COUNT DISTINCT':_0xa5c1('0x5a'),'MAX':_0xa5c1('0x5b'),'MIN':'MIN(%s)','AVG':_0xa5c1('0x5d'),'GROUP_CONCAT':_0xa5c1('0x8e'),'GROUP_CONCAT ASC':_0xa5c1('0x5e'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x390f58={'SEC_TO_TIME':_0xa5c1('0x60'),'DATE':_0xa5c1('0x61'),'HOUR':'HOUR(%s)','ROUND':_0xa5c1('0x63'),'UNIX_TIMESTAMP':_0xa5c1('0x64')};var _0x27b1de=function(_0x2eedc7){return!_['includes']([_0xa5c1('0x66'),_0xa5c1('0x67'),'IS\x20EMPTY',_0xa5c1('0x69')],_0x2eedc7);};var _0x3e56b0=function(_0x377b99){if(!_0x377b99||!_0x377b99['rules'][_0xa5c1('0x39')]){return'';}for(var _0x2bd068='(',_0x2f5985=0x0;_0x2f5985<_0x377b99['rules'][_0xa5c1('0x39')];_0x2f5985+=0x1){_0x2f5985>0x0&&(_0x2bd068+='\x20'+_0x377b99[_0xa5c1('0x6b')]+'\x20');_0x2bd068+=_0x377b99['rules'][_0x2f5985][_0xa5c1('0x6c')]?_0x3e56b0(_0x377b99['rules'][_0x2f5985][_0xa5c1('0x6c')]):_0x377b99[_0xa5c1('0x6a')][_0x2f5985][_0xa5c1('0x6d')]+'\x20'+_0x377b99['rules'][_0x2f5985][_0xa5c1('0x6e')]+(_0x27b1de(_0x377b99['rules'][_0x2f5985][_0xa5c1('0x6e')])?'\x20'+_0x377b99[_0xa5c1('0x6a')][_0x2f5985][_0xa5c1('0x6f')]:'');}return _0x2bd068+')';};var _0x5cc94c={'where':{'id':_0x9879f9['id']}},_0x160153,_0x10556a,_0xdc16f5,_0x2a6830,_0x142817;_0x5cc94c=_[_0xa5c1('0x3f')]({},_0x5cc94c,_0x12eba9);return db[_0xa5c1('0x2f')][_0xa5c1('0x4b')](_0x5cc94c)[_0xa5c1('0x24')](function(_0x25eefc){if(_0x25eefc){_0x160153=_0x25eefc;return _0x25eefc['getFields']();}return null;})[_0xa5c1('0x24')](function(_0x2044ef){if(_0x2044ef){if(!_0x2044ef[_0xa5c1('0x39')]){throw new db[(_0xa5c1('0x70'))][(_0xa5c1('0x71'))](_0xa5c1('0x8f'),0x193);}_0x10556a=_0x2044ef;return db[_0xa5c1('0x72')][_0xa5c1('0x46')]({'raw':!![]});}return null;})[_0xa5c1('0x24')](function(_0x2f3a6a){if(_0x2f3a6a){_0xdc16f5=_[_0xa5c1('0x90')](_0x2f3a6a,'id');var _0x65bf45;var _0x5e4276=squel['select']();_0x5e4276[_0xa5c1('0x74')](_0x160153[_0xa5c1('0x75')]);for(var _0x587df1=0x0;_0x587df1<_0x10556a['length'];_0x587df1+=0x1){_0x65bf45=_0x10556a[_0x587df1][_0xa5c1('0x76')]?_0xdc16f5[_0x10556a[_0x587df1][_0xa5c1('0x76')]][_0xa5c1('0x77')]:_0x10556a[_0x587df1]['field'];_0x65bf45=_0x10556a[_0x587df1][_0xa5c1('0x78')]?_[_0xa5c1('0x79')](_0x3d28ed[_0x10556a[_0x587df1][_0xa5c1('0x78')]],'%s',_0x65bf45):_0x65bf45;_0x65bf45=_0x10556a[_0x587df1][_0xa5c1('0x7a')]?_[_0xa5c1('0x79')](_0x390f58[_0x10556a[_0x587df1][_0xa5c1('0x7a')]],'%s',_0x65bf45):_0x65bf45;if(_0x10556a[_0x587df1]['groupBy']){_0x5e4276['group'](_0x65bf45);}_0x10556a[_0x587df1][_0xa5c1('0x7d')]&&_0x5e4276[_0xa5c1('0x7c')](_0x65bf45,_0x10556a[_0x587df1][_0xa5c1('0x7d')]===_0xa5c1('0x91')?![]:!![]);_0x5e4276[_0xa5c1('0x6d')](_0x65bf45,_0x10556a[_0x587df1][_0xa5c1('0x92')]||_0x65bf45);}if(_0x160153['joins']){_0x160153[_0xa5c1('0x7e')]=JSON[_0xa5c1('0x7f')](_0x160153[_0xa5c1('0x7e')]);for(var _0x53eed0=0x0;_0x53eed0<_0x160153[_0xa5c1('0x7e')][_0xa5c1('0x39')];_0x53eed0+=0x1){if(_0x160153['joins'][_0x53eed0][_0xa5c1('0x40')]&&_[_0xa5c1('0x65')](_0x55c619,_0x160153[_0xa5c1('0x7e')][_0x53eed0]['type'])&&_0x160153[_0xa5c1('0x7e')][_0x53eed0][_0xa5c1('0x80')]&&_0x160153[_0xa5c1('0x7e')][_0x53eed0]['foreignTable']&&_0x160153['joins'][_0x53eed0][_0xa5c1('0x82')]){_0x5e4276[_0x160153[_0xa5c1('0x7e')][_0x53eed0][_0xa5c1('0x40')]](_0x160153[_0xa5c1('0x7e')][_0x53eed0][_0xa5c1('0x81')],null,util[_0xa5c1('0x7a')](_0xa5c1('0x83'),_0x160153[_0xa5c1('0x75')],_0x160153[_0xa5c1('0x7e')][_0x53eed0][_0xa5c1('0x80')],_0x160153[_0xa5c1('0x7e')][_0x53eed0][_0xa5c1('0x81')],_0x160153[_0xa5c1('0x7e')][_0x53eed0][_0xa5c1('0x82')]));}}}if(_0x160153[_0xa5c1('0x84')]){_0x160153[_0xa5c1('0x84')]=JSON['parse'](_0x160153[_0xa5c1('0x84')]);_0x5e4276['where'](_0x3e56b0(_0x160153[_0xa5c1('0x84')][_0xa5c1('0x6c')]));}_0x142817=_0x5e4276[_0xa5c1('0x93')]();_0x5e4276[_0xa5c1('0x3b')](_0x5a695b);_0x5e4276[_0xa5c1('0x1e')](0x0);return;}})['then'](function(){if(_0x1d8631[_0xa5c1('0x94')]===_0xa5c1('0x95')){return null;}var _0x3d03ad=_[_0xa5c1('0x3f')](_0x1d8631,{'name':_0x1d8631[_0xa5c1('0x96')]||_0x1d8631[_0xa5c1('0x2b')]||_0x160153[_0xa5c1('0x2b')],'basename':_0x3986e1,'savename':util[_0xa5c1('0x7a')]('%s-%s.%s',_0x1d8631['name']||_0x160153[_0xa5c1('0x2b')],require(_0xa5c1('0x97'))[_0xa5c1('0x98')](0x4),_0x1d8631[_0xa5c1('0x94')]||_0xa5c1('0x99')),'reportId':_0x160153['id'],'reportType':_0xa5c1('0x9a')});return db['AnalyticExtractedReport']['create'](_0x3d03ad,{'raw':!![]});})[_0xa5c1('0x24')](function(_0x1a1a1f){if(_0x160153[_0xa5c1('0x75')]===_0xa5c1('0x9b')){_0x142817[_0xa5c1('0x3e')](_0x160153[_0xa5c1('0x75')]+_0xa5c1('0x9c'),_0x1d8631['startDate'],_0x1d8631[_0xa5c1('0x9d')]);}else{_0x142817[_0xa5c1('0x3e')](_0x160153[_0xa5c1('0x75')]+_0xa5c1('0x9e'),_0x1d8631[_0xa5c1('0x9f')],_0x1d8631['endDate']);}if(_0x1a1a1f){logger[_0xa5c1('0xa0')](_0xa5c1('0xa1'),_0x142817[_0xa5c1('0x87')]());require(_0xa5c1('0xa2'))[_0xa5c1('0xa3')](path[_0xa5c1('0x8b')](__dirname,_0xa5c1('0xa4'),_0x1a1a1f[_0xa5c1('0x94')]),[_0x1a1a1f['id'],_0x142817[_0xa5c1('0x87')](),path[_0xa5c1('0x8b')](__dirname,'../../files/reports',_0x1a1a1f['savename']),_0x3986e1]);return _0x1a1a1f;}else{var _0x4c7233=squel['select']();_0x4c7233['from']('('+_0x142817['toString']()+')',_0xa5c1('0xa5'));_0x4c7233[_0xa5c1('0x6d')]('COUNT(*)',_0xa5c1('0x1f'));_0x142817['limit'](_0x1d8631['limit']||_0x5a695b);_0x142817['offset'](_0x1d8631[_0xa5c1('0x1e')]||0x0);return dbH[_0xa5c1('0x88')][_0xa5c1('0x34')](_0x4c7233[_0xa5c1('0x87')](),{'type':dbH[_0xa5c1('0x88')][_0xa5c1('0x89')][_0xa5c1('0x8a')]})[_0xa5c1('0x24')](function(_0xe361bd){if(!_0xe361bd['length']){_0x2a6830=0x0;}else{_0x2a6830=_0xe361bd[0x0][_0xa5c1('0x1f')]||0x0;}return dbH['sequelize']['query'](_0x142817[_0xa5c1('0x87')](),{'type':dbH[_0xa5c1('0x88')][_0xa5c1('0x89')][_0xa5c1('0x8a')]});})['then'](function(_0xde9d47){return{'rows':_0xde9d47||[],'count':_0x2a6830};});}});}exports[_0xa5c1('0xa6')]=function(_0x1052e5,_0x35c27f){return runReport(_0x1052e5[_0xa5c1('0x49')],_0x1052e5['query'],_0x1052e5[_0xa5c1('0x43')])['then'](respondWithResult(_0x35c27f,null))[_0xa5c1('0x47')](handleError(_0x35c27f,null));};exports[_0xa5c1('0xa7')]=runReport;exports[_0xa5c1('0x34')]=function(_0x178cef,_0x26f958){var _0x383e35=0xa;var _0x1baaeb=[_0xa5c1('0x8b'),'left_join',_0xa5c1('0x57'),_0xa5c1('0x8d')];var _0x1e4df3={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0xa5c1('0x5b'),'MIN':_0xa5c1('0x5c'),'AVG':_0xa5c1('0x5d'),'GROUP_CONCAT':_0xa5c1('0x8e'),'GROUP_CONCAT ASC':_0xa5c1('0x5e'),'GROUP_CONCAT DESC':_0xa5c1('0x5f')};var _0x5f3c50={'SEC_TO_TIME':_0xa5c1('0x60'),'DATE':_0xa5c1('0x61'),'HOUR':'HOUR(%s)','ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0xa5c1('0x64')};var _0x4de217=function(_0x2eaacf){return!_['includes']([_0xa5c1('0x66'),_0xa5c1('0x67'),'IS\x20EMPTY',_0xa5c1('0x69')],_0x2eaacf);};var _0x86ba1a=function(_0x20e7bf){if(!_0x20e7bf||!_0x20e7bf[_0xa5c1('0x6a')]['length']){return'';}for(var _0x4a108f='(',_0xd1e09b=0x0;_0xd1e09b<_0x20e7bf[_0xa5c1('0x6a')][_0xa5c1('0x39')];_0xd1e09b+=0x1){_0xd1e09b>0x0&&(_0x4a108f+='\x20'+_0x20e7bf[_0xa5c1('0x6b')]+'\x20');_0x4a108f+=_0x20e7bf['rules'][_0xd1e09b][_0xa5c1('0x6c')]?_0x86ba1a(_0x20e7bf[_0xa5c1('0x6a')][_0xd1e09b]['group']):_0x20e7bf[_0xa5c1('0x6a')][_0xd1e09b][_0xa5c1('0x6d')]+'\x20'+_0x20e7bf['rules'][_0xd1e09b][_0xa5c1('0x6e')]+(_0x4de217(_0x20e7bf[_0xa5c1('0x6a')][_0xd1e09b][_0xa5c1('0x6e')])?'\x20'+_0x20e7bf[_0xa5c1('0x6a')][_0xd1e09b][_0xa5c1('0x6f')]:'');}return _0x4a108f+')';};var _0x2f0384={'where':{'id':_0x178cef['params']['id']}},_0x22a472,_0x2806bc,_0x13334f,_0x20d1bc,_0x374edb;_0x2f0384=_['merge']({},_0x2f0384,_0x178cef[_0xa5c1('0x43')]);return db[_0xa5c1('0x2f')][_0xa5c1('0x4b')](_0x2f0384)[_0xa5c1('0x24')](function(_0x6068a5){if(_0x6068a5){_0x22a472=_0x6068a5;return _0x6068a5[_0xa5c1('0xa8')]();}return null;})['then'](function(_0x22bc20){if(_0x22bc20){if(!_0x22bc20[_0xa5c1('0x39')]){throw new db[(_0xa5c1('0x70'))][(_0xa5c1('0x71'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x2806bc=_0x22bc20;return db[_0xa5c1('0x72')][_0xa5c1('0x46')]({'raw':!![]});}return null;})[_0xa5c1('0x24')](function(_0x1d40dd){if(_0x1d40dd){_0x13334f=_[_0xa5c1('0x90')](_0x1d40dd,'id');var _0x1b2b3b;var _0x1d5cca=squel[_0xa5c1('0x73')]();_0x1d5cca[_0xa5c1('0x74')](_0x22a472[_0xa5c1('0x75')]);for(var _0x4ce0c5=0x0;_0x4ce0c5<_0x2806bc['length'];_0x4ce0c5+=0x1){_0x1b2b3b=_0x2806bc[_0x4ce0c5][_0xa5c1('0x76')]?_0x13334f[_0x2806bc[_0x4ce0c5][_0xa5c1('0x76')]]['metric']:_0x2806bc[_0x4ce0c5][_0xa5c1('0x6d')];_0x1b2b3b=_0x2806bc[_0x4ce0c5]['function']?_[_0xa5c1('0x79')](_0x1e4df3[_0x2806bc[_0x4ce0c5][_0xa5c1('0x78')]],'%s',_0x1b2b3b):_0x1b2b3b;_0x1b2b3b=_0x2806bc[_0x4ce0c5]['format']?_[_0xa5c1('0x79')](_0x5f3c50[_0x2806bc[_0x4ce0c5][_0xa5c1('0x7a')]],'%s',_0x1b2b3b):_0x1b2b3b;if(_0x2806bc[_0x4ce0c5][_0xa5c1('0x7b')]){_0x1d5cca[_0xa5c1('0x6c')](_0x1b2b3b);}_0x2806bc[_0x4ce0c5]['orderBy']&&_0x1d5cca['order'](_0x1b2b3b,_0x2806bc[_0x4ce0c5]['orderBy']===_0xa5c1('0x91')?![]:!![]);_0x1d5cca[_0xa5c1('0x6d')](_0x1b2b3b,_0x2806bc[_0x4ce0c5][_0xa5c1('0x92')]||_0x1b2b3b);}if(_0x22a472[_0xa5c1('0x7e')]){_0x22a472[_0xa5c1('0x7e')]=JSON[_0xa5c1('0x7f')](_0x22a472[_0xa5c1('0x7e')]);for(var _0x52f625=0x0;_0x52f625<_0x22a472[_0xa5c1('0x7e')]['length'];_0x52f625+=0x1){if(_0x22a472['joins'][_0x52f625][_0xa5c1('0x40')]&&_[_0xa5c1('0x65')](_0x1baaeb,_0x22a472['joins'][_0x52f625]['type'])&&_0x22a472['joins'][_0x52f625]['parentKey']&&_0x22a472['joins'][_0x52f625][_0xa5c1('0x81')]&&_0x22a472[_0xa5c1('0x7e')][_0x52f625]['foreignKey']){_0x1d5cca[_0x22a472[_0xa5c1('0x7e')][_0x52f625][_0xa5c1('0x40')]](_0x22a472['joins'][_0x52f625][_0xa5c1('0x81')],null,util['format'](_0xa5c1('0x83'),_0x22a472['table'],_0x22a472[_0xa5c1('0x7e')][_0x52f625][_0xa5c1('0x80')],_0x22a472[_0xa5c1('0x7e')][_0x52f625]['foreignTable'],_0x22a472['joins'][_0x52f625][_0xa5c1('0x82')]));}}}if(_0x22a472[_0xa5c1('0x84')]){_0x22a472['conditions']=JSON[_0xa5c1('0x7f')](_0x22a472[_0xa5c1('0x84')]);_0x1d5cca[_0xa5c1('0x3e')](_0x86ba1a(_0x22a472[_0xa5c1('0x84')][_0xa5c1('0x6c')]));}_0x374edb=_0x1d5cca[_0xa5c1('0x93')]();_0x1d5cca[_0xa5c1('0x3b')](_0x383e35);_0x1d5cca[_0xa5c1('0x1e')](0x0);logger[_0xa5c1('0x85')](_0xa5c1('0x86'),_0x1d5cca[_0xa5c1('0x87')]());return dbH[_0xa5c1('0x88')]['query'](_0x1d5cca[_0xa5c1('0x87')](),{'type':dbH[_0xa5c1('0x88')]['QueryTypes'][_0xa5c1('0x8a')]});}})[_0xa5c1('0x24')](function(){return{'sql':_0x374edb['toString']()};})['then'](respondWithResult(_0x26f958,null))[_0xa5c1('0x47')](handleError(_0x26f958,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff