// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x049e=['metric','function','replace','format','groupBy','orderBy','DESC','joins','parse','foreignKey','foreignTable','%s.%s\x20=\x20%s.%s','parentKey','conditions','clone','Limited\x20Query:','toString','sequelize','SELECT','HOUR(%s)','UNIX_TIMESTAMP(%s)','AnalyticMetric','alias','debug','No\x20available\x20data','output','fullPath','randomstring','generate','csv','custom','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','Run\x20Query:','child_process','fork','../../components/export/','COUNT(*)','count','QueryTypes','runReport','SUM(%s)','MIN(%s)','html-pdf','eml-format','zip-dir','request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','lodash','squel','crypto','jsforce','querystring','papaparse','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/environment','../../mysqldb','dbH','sendStatus','end','json','offset','status','reject','save','update','then','UserProfileResource','stack','name','send','index','map','AnalyticCustomReport','rawAttributes','fieldName','type','model','filters','intersection','query','attributes','fields','length','hasOwnProperty','nolimit','limit','order','sort','where','pick','merge','VIRTUAL','options','includeAll','include','findAll','rows','show','params','keys','find','catch','create','body','user','role','get','Reports','UserProfileSection','userProfileId','CustomReports','preview','join','left_join','right_join','cross_join','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','DATE(%s)','ROUND(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','value','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','keyBy','select','from','table','MetricId'];(function(_0xd1d73e,_0x5ea73a){var _0x4eb7fe=function(_0x4a214a){while(--_0x4a214a){_0xd1d73e['push'](_0xd1d73e['shift']());}};_0x4eb7fe(++_0x5ea73a);}(_0x049e,0x16a));var _0xe049=function(_0x4b8156,_0x437af2){_0x4b8156=_0x4b8156-0x0;var _0x4a819c=_0x049e[_0x4b8156];return _0x4a819c;};'use strict';var pdf=require(_0xe049('0x0'));var emlformat=require(_0xe049('0x1'));var rimraf=require('rimraf');var zipdir=require(_0xe049('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0xe049('0x3'));var moment=require(_0xe049('0x4'));var BPromise=require(_0xe049('0x5'));var Mustache=require(_0xe049('0x6'));var util=require(_0xe049('0x7'));var path=require('path');var sox=require(_0xe049('0x8'));var csv=require(_0xe049('0x9'));var ejs=require(_0xe049('0xa'));var fs=require('fs');var _=require(_0xe049('0xb'));var squel=require(_0xe049('0xc'));var crypto=require(_0xe049('0xd'));var jsforce=require(_0xe049('0xe'));var deskjs=require('desk.js');var toCsv=require(_0xe049('0x9'));var querystring=require(_0xe049('0xf'));var Papa=require(_0xe049('0x10'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0xe049('0x11'));var as=require(_0xe049('0x12'));var hardwareService=require(_0xe049('0x13'));var logger=require('../../config/logger')('api');var utils=require('../../config/utils');var config=require(_0xe049('0x14'));var db=require(_0xe049('0x15'))['db'];var dbH=require(_0xe049('0x15'))[_0xe049('0x16')];function respondWithStatusCode(_0x301c7e,_0x1021e7){_0x1021e7=_0x1021e7||0xcc;return function(_0xdd1814){if(_0xdd1814){return _0x301c7e[_0xe049('0x17')](_0x1021e7);}return _0x301c7e['status'](_0x1021e7)[_0xe049('0x18')]();};}function respondWithResult(_0x3f4a57,_0x3924a4){_0x3924a4=_0x3924a4||0xc8;return function(_0x35fd0d){if(_0x35fd0d){return _0x3f4a57['status'](_0x3924a4)[_0xe049('0x19')](_0x35fd0d);}};}function respondWithFilteredResult(_0xcc35b6,_0x5c90fd){return function(_0x388be0){if(_0x388be0){var _0x26b40c=_0x388be0['count'],_0x526d25=_0x5c90fd[_0xe049('0x1a')],_0x8b9bfe=_0x5c90fd['offset']+_0x5c90fd['limit'],_0x5291a9;if(_0x8b9bfe>=_0x26b40c){_0x8b9bfe=_0x26b40c;_0x5291a9=0xc8;}else{_0x5291a9=0xce;}_0xcc35b6[_0xe049('0x1b')](_0x5291a9);return _0xcc35b6['set']('Content-Range',_0x526d25+'-'+_0x8b9bfe+'/'+_0x26b40c)[_0xe049('0x19')](_0x388be0);}return null;};}function patchUpdates(_0x1092ec){return function(_0x5ae414){try{jsonpatch['apply'](_0x5ae414,_0x1092ec,!![]);}catch(_0x22af56){return BPromise[_0xe049('0x1c')](_0x22af56);}return _0x5ae414[_0xe049('0x1d')]();};}function saveUpdates(_0x430421,_0x517aea){return function(_0x572f29){if(_0x572f29){return _0x572f29[_0xe049('0x1e')](_0x430421)[_0xe049('0x1f')](function(_0x572a80){return _0x572a80;});}return null;};}function removeEntity(_0x36a03b,_0x3f14eb){return function(_0x10cb90){if(_0x10cb90){return _0x10cb90['destroy']()[_0xe049('0x1f')](function(){var _0x3b0f54=_0x10cb90['get']({'plain':!![]});var _0x4848c9='CustomReports';return db[_0xe049('0x20')]['destroy']({'where':{'type':_0x4848c9,'resourceId':_0x3b0f54['id']}})['then'](function(){return _0x10cb90;});})[_0xe049('0x1f')](function(){_0x36a03b[_0xe049('0x1b')](0xcc)['end']();});}};}function handleEntityNotFound(_0x1f5233,_0x181432){return function(_0x3e5c7f){if(!_0x3e5c7f){_0x1f5233[_0xe049('0x17')](0x194);}return _0x3e5c7f;};}function handleError(_0x293dd2,_0x1843b8){_0x1843b8=_0x1843b8||0x1f4;return function(_0x5b0e64){logger['error'](_0x5b0e64[_0xe049('0x21')]);if(_0x5b0e64['name']){delete _0x5b0e64[_0xe049('0x22')];}_0x293dd2['status'](_0x1843b8)[_0xe049('0x23')](_0x5b0e64);};}exports[_0xe049('0x24')]=function(_0x5adcd6,_0x432a6e){var _0x364630={},_0xb64700={},_0x33353d={'count':0x0,'rows':[]};var _0x4464b2=_[_0xe049('0x25')](db[_0xe049('0x26')][_0xe049('0x27')],function(_0x4038f0){return{'name':_0x4038f0[_0xe049('0x28')],'type':_0x4038f0[_0xe049('0x29')]['key']};});_0xb64700[_0xe049('0x2a')]=_[_0xe049('0x25')](_0x4464b2,'name');_0xb64700['query']=_['keys'](_0x5adcd6['query']);_0xb64700[_0xe049('0x2b')]=_[_0xe049('0x2c')](_0xb64700[_0xe049('0x2a')],_0xb64700[_0xe049('0x2d')]);_0x364630[_0xe049('0x2e')]=_['intersection'](_0xb64700[_0xe049('0x2a')],qs[_0xe049('0x2f')](_0x5adcd6[_0xe049('0x2d')][_0xe049('0x2f')]));_0x364630[_0xe049('0x2e')]=_0x364630['attributes'][_0xe049('0x30')]?_0x364630['attributes']:_0xb64700[_0xe049('0x2a')];if(!_0x5adcd6['query'][_0xe049('0x31')](_0xe049('0x32'))){_0x364630[_0xe049('0x33')]=qs[_0xe049('0x33')](_0x5adcd6[_0xe049('0x2d')][_0xe049('0x33')]);_0x364630[_0xe049('0x1a')]=qs[_0xe049('0x1a')](_0x5adcd6[_0xe049('0x2d')][_0xe049('0x1a')]);}_0x364630[_0xe049('0x34')]=qs['sort'](_0x5adcd6[_0xe049('0x2d')][_0xe049('0x35')]);_0x364630[_0xe049('0x36')]=qs[_0xe049('0x2b')](_[_0xe049('0x37')](_0x5adcd6[_0xe049('0x2d')],_0xb64700[_0xe049('0x2b')]),_0x4464b2);if(_0x5adcd6[_0xe049('0x2d')]['filter']){_0x364630[_0xe049('0x36')]=_[_0xe049('0x38')](_0x364630[_0xe049('0x36')],{'$or':_[_0xe049('0x25')](_0x4464b2,function(_0x5e9613){if(_0x5e9613[_0xe049('0x29')]!==_0xe049('0x39')){var _0x3963e6={};_0x3963e6[_0x5e9613[_0xe049('0x22')]]={'$like':'%'+_0x5adcd6[_0xe049('0x2d')]['filter']+'%'};return _0x3963e6;}})});}_0x364630=_[_0xe049('0x38')]({},_0x364630,_0x5adcd6[_0xe049('0x3a')]);var _0x21f6e6={'where':_0x364630['where']};return db[_0xe049('0x26')]['count'](_0x21f6e6)['then'](function(_0x19dbc4){_0x33353d['count']=_0x19dbc4;if(_0x5adcd6[_0xe049('0x2d')][_0xe049('0x3b')]){_0x364630[_0xe049('0x3c')]=[{'all':!![]}];}return db[_0xe049('0x26')][_0xe049('0x3d')](_0x364630);})['then'](function(_0x4261da){_0x33353d[_0xe049('0x3e')]=_0x4261da;return _0x33353d;})['then'](respondWithFilteredResult(_0x432a6e,_0x364630))['catch'](handleError(_0x432a6e,null));};exports[_0xe049('0x3f')]=function(_0x20d264,_0x482072){var _0x215eea={'raw':![],'where':{'id':_0x20d264[_0xe049('0x40')]['id']}},_0x82e245={};_0x82e245['model']=_[_0xe049('0x41')](db[_0xe049('0x26')]['rawAttributes']);_0x82e245[_0xe049('0x2d')]=_[_0xe049('0x41')](_0x20d264[_0xe049('0x2d')]);_0x82e245[_0xe049('0x2b')]=_[_0xe049('0x2c')](_0x82e245['model'],_0x82e245['query']);_0x215eea[_0xe049('0x2e')]=_[_0xe049('0x2c')](_0x82e245[_0xe049('0x2a')],qs[_0xe049('0x2f')](_0x20d264[_0xe049('0x2d')][_0xe049('0x2f')]));_0x215eea['attributes']=_0x215eea[_0xe049('0x2e')][_0xe049('0x30')]?_0x215eea['attributes']:_0x82e245[_0xe049('0x2a')];if(_0x20d264['query'][_0xe049('0x3b')]){_0x215eea['include']=[{'all':!![]}];}_0x215eea=_[_0xe049('0x38')]({},_0x215eea,_0x20d264['options']);return db[_0xe049('0x26')][_0xe049('0x42')](_0x215eea)[_0xe049('0x1f')](handleEntityNotFound(_0x482072,null))[_0xe049('0x1f')](respondWithResult(_0x482072,null))[_0xe049('0x43')](handleError(_0x482072,null));};exports['create']=function(_0x210a1c,_0x2310ff){return db[_0xe049('0x26')][_0xe049('0x44')](_0x210a1c[_0xe049('0x45')],{})[_0xe049('0x1f')](function(_0x12f9b8){var _0x1b94b5=_0x210a1c[_0xe049('0x46')]['get']({'plain':!![]});if(!_0x1b94b5)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x1b94b5[_0xe049('0x47')]===_0xe049('0x46')){var _0x32ff60=_0x12f9b8[_0xe049('0x48')]({'plain':!![]});var _0x254dc6=_0xe049('0x49');return db[_0xe049('0x4a')][_0xe049('0x42')]({'where':{'name':_0x254dc6,'userProfileId':_0x1b94b5[_0xe049('0x4b')]},'raw':!![]})[_0xe049('0x1f')](function(_0x451883){if(_0x451883&&_0x451883['autoAssociation']===0x0){return db[_0xe049('0x20')][_0xe049('0x44')]({'name':_0x32ff60[_0xe049('0x22')],'resourceId':_0x32ff60['id'],'type':_0xe049('0x4c'),'sectionId':_0x451883['id']},{})[_0xe049('0x1f')](function(){return _0x12f9b8;});}else{return _0x12f9b8;}})[_0xe049('0x43')](function(_0x373a49){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x373a49);throw _0x373a49;});}return _0x12f9b8;})['then'](respondWithResult(_0x2310ff,0xc9))[_0xe049('0x43')](handleError(_0x2310ff,null));};exports[_0xe049('0x1e')]=function(_0x47f0c5,_0x2e361b){if(_0x47f0c5[_0xe049('0x45')]['id']){delete _0x47f0c5[_0xe049('0x45')]['id'];}return db[_0xe049('0x26')]['find']({'where':{'id':_0x47f0c5['params']['id']}})[_0xe049('0x1f')](handleEntityNotFound(_0x2e361b,null))[_0xe049('0x1f')](saveUpdates(_0x47f0c5['body'],null))['then'](respondWithResult(_0x2e361b,null))[_0xe049('0x43')](handleError(_0x2e361b,null));};exports['destroy']=function(_0x3ef1fa,_0x2a1e06){return db['AnalyticCustomReport'][_0xe049('0x42')]({'where':{'id':_0x3ef1fa['params']['id']}})[_0xe049('0x1f')](handleEntityNotFound(_0x2a1e06,null))[_0xe049('0x1f')](removeEntity(_0x2a1e06,null))['catch'](handleError(_0x2a1e06,null));};exports[_0xe049('0x4d')]=function(_0x3508f8,_0x21c0dc){var _0x439be7=0xa;var _0x421d54=[_0xe049('0x4e'),_0xe049('0x4f'),_0xe049('0x50'),_0xe049('0x51')];var _0x35f367={'SUM':'SUM(%s)','COUNT':_0xe049('0x52'),'COUNT DISTINCT':_0xe049('0x53'),'MAX':_0xe049('0x54'),'MIN':'MIN(%s)','AVG':_0xe049('0x55'),'GROUP_CONCAT':_0xe049('0x56'),'GROUP_CONCAT ASC':_0xe049('0x57'),'GROUP_CONCAT DESC':_0xe049('0x58')};var _0x1840b6={'SEC_TO_TIME':_0xe049('0x59'),'DATE':_0xe049('0x5a'),'HOUR':'HOUR(%s)','ROUND':_0xe049('0x5b'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x440b63=function(_0x51f90a){return!_[_0xe049('0x5c')]([_0xe049('0x5d'),_0xe049('0x5e'),_0xe049('0x5f'),_0xe049('0x60')],_0x51f90a);};var _0x4af8a3=function(_0x329a6d){if(!_0x329a6d||!_0x329a6d[_0xe049('0x61')][_0xe049('0x30')]){return'';}for(var _0xad43b0='(',_0x190bd4=0x0;_0x190bd4<_0x329a6d[_0xe049('0x61')][_0xe049('0x30')];_0x190bd4+=0x1){_0x190bd4>0x0&&(_0xad43b0+='\x20'+_0x329a6d[_0xe049('0x62')]+'\x20');_0xad43b0+=_0x329a6d['rules'][_0x190bd4]['group']?_0x4af8a3(_0x329a6d[_0xe049('0x61')][_0x190bd4][_0xe049('0x63')]):_0x329a6d['rules'][_0x190bd4][_0xe049('0x64')]+'\x20'+_0x329a6d[_0xe049('0x61')][_0x190bd4][_0xe049('0x65')]+(_0x440b63(_0x329a6d[_0xe049('0x61')][_0x190bd4]['condition'])?'\x20'+_0x329a6d['rules'][_0x190bd4][_0xe049('0x66')]:'');}return _0xad43b0+')';};var _0x57290e={'where':{'id':_0x3508f8[_0xe049('0x40')]['id']}},_0x4386c5,_0x3cfaf6,_0x3c61f8,_0x1a109a,_0x1ffabc;_0x57290e=_[_0xe049('0x38')]({},_0x57290e,_0x3508f8[_0xe049('0x3a')]);return db['AnalyticCustomReport'][_0xe049('0x42')](_0x57290e)[_0xe049('0x1f')](function(_0x334522){if(_0x334522){_0x4386c5=_0x334522;return _0x334522[_0xe049('0x67')]();}return null;})[_0xe049('0x1f')](function(_0x5496c9){if(_0x5496c9){if(!_0x5496c9[_0xe049('0x30')]){throw new db[(_0xe049('0x68'))][(_0xe049('0x69'))](_0xe049('0x6a'),0x193);}_0x3cfaf6=_0x5496c9;return db['AnalyticMetric']['findAll']({'raw':!![]});}return null;})[_0xe049('0x1f')](function(_0xde9419){if(_0xde9419){_0x3c61f8=_[_0xe049('0x6b')](_0xde9419,'id');var _0x51678c;var _0x35f98f=squel[_0xe049('0x6c')]();_0x35f98f[_0xe049('0x6d')](_0x4386c5[_0xe049('0x6e')]);for(var _0x3227d3=0x0;_0x3227d3<_0x3cfaf6[_0xe049('0x30')];_0x3227d3+=0x1){_0x51678c=_0x3cfaf6[_0x3227d3][_0xe049('0x6f')]?_0x3c61f8[_0x3cfaf6[_0x3227d3][_0xe049('0x6f')]][_0xe049('0x70')]:_0x3cfaf6[_0x3227d3][_0xe049('0x64')];_0x51678c=_0x3cfaf6[_0x3227d3][_0xe049('0x71')]?_[_0xe049('0x72')](_0x35f367[_0x3cfaf6[_0x3227d3]['function']],'%s',_0x51678c):_0x51678c;_0x51678c=_0x3cfaf6[_0x3227d3]['format']?_[_0xe049('0x72')](_0x1840b6[_0x3cfaf6[_0x3227d3][_0xe049('0x73')]],'%s',_0x51678c):_0x51678c;if(_0x3cfaf6[_0x3227d3][_0xe049('0x74')]){_0x35f98f['group'](_0x51678c);}_0x3cfaf6[_0x3227d3][_0xe049('0x75')]&&_0x35f98f[_0xe049('0x34')](_0x51678c,_0x3cfaf6[_0x3227d3]['orderBy']===_0xe049('0x76')?![]:!![]);_0x35f98f[_0xe049('0x64')](_0x51678c,_0x3cfaf6[_0x3227d3]['alias']||_0x51678c);}if(_0x4386c5[_0xe049('0x77')]){_0x4386c5[_0xe049('0x77')]=JSON[_0xe049('0x78')](_0x4386c5[_0xe049('0x77')]);for(var _0xf95e5c=0x0;_0xf95e5c<_0x4386c5[_0xe049('0x77')][_0xe049('0x30')];_0xf95e5c+=0x1){if(_0x4386c5[_0xe049('0x77')][_0xf95e5c][_0xe049('0x29')]&&_[_0xe049('0x5c')](_0x421d54,_0x4386c5[_0xe049('0x77')][_0xf95e5c][_0xe049('0x29')])&&_0x4386c5[_0xe049('0x77')][_0xf95e5c]['parentKey']&&_0x4386c5[_0xe049('0x77')][_0xf95e5c]['foreignTable']&&_0x4386c5['joins'][_0xf95e5c][_0xe049('0x79')]){_0x35f98f[_0x4386c5[_0xe049('0x77')][_0xf95e5c][_0xe049('0x29')]](_0x4386c5['joins'][_0xf95e5c][_0xe049('0x7a')],null,util['format'](_0xe049('0x7b'),_0x4386c5['table'],_0x4386c5[_0xe049('0x77')][_0xf95e5c][_0xe049('0x7c')],_0x4386c5[_0xe049('0x77')][_0xf95e5c][_0xe049('0x7a')],_0x4386c5[_0xe049('0x77')][_0xf95e5c][_0xe049('0x79')]));}}}if(_0x4386c5[_0xe049('0x7d')]){_0x4386c5[_0xe049('0x7d')]=JSON['parse'](_0x4386c5['conditions']);_0x35f98f[_0xe049('0x36')](_0x4af8a3(_0x4386c5[_0xe049('0x7d')][_0xe049('0x63')]));}_0x1ffabc=_0x35f98f[_0xe049('0x7e')]();_0x35f98f[_0xe049('0x33')](_0x439be7);_0x35f98f[_0xe049('0x1a')](0x0);logger['debug'](_0xe049('0x7f'),_0x35f98f['toString']());return db['sequelize'][_0xe049('0x2d')](_0x35f98f[_0xe049('0x80')](),{'type':db[_0xe049('0x81')]['QueryTypes'][_0xe049('0x82')]});}})['then'](respondWithResult(_0x21c0dc,null))['catch'](handleError(_0x21c0dc,null));};function runReport(_0x36d52b,_0x7f31d7,_0x3f11a7){var _0x5c2340=_0x7f31d7['name'];var _0x287fc8=0xa;var _0xb12f8e=['join',_0xe049('0x4f'),_0xe049('0x50'),_0xe049('0x51')];var _0x328c13={'SUM':'SUM(%s)','COUNT':_0xe049('0x52'),'COUNT DISTINCT':_0xe049('0x53'),'MAX':_0xe049('0x54'),'MIN':'MIN(%s)','AVG':_0xe049('0x55'),'GROUP_CONCAT':_0xe049('0x56'),'GROUP_CONCAT ASC':_0xe049('0x57'),'GROUP_CONCAT DESC':_0xe049('0x58')};var _0x5dc69b={'SEC_TO_TIME':_0xe049('0x59'),'DATE':_0xe049('0x5a'),'HOUR':_0xe049('0x83'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0xe049('0x84')};var _0x9aa9d0=function(_0x5afbd0){return!_[_0xe049('0x5c')]([_0xe049('0x5d'),'IS\x20NOT\x20NULL',_0xe049('0x5f'),_0xe049('0x60')],_0x5afbd0);};var _0x1950ae=function(_0x37ca72){if(!_0x37ca72||!_0x37ca72[_0xe049('0x61')][_0xe049('0x30')]){return'';}for(var _0x142105='(',_0x5746ff=0x0;_0x5746ff<_0x37ca72['rules']['length'];_0x5746ff+=0x1){_0x5746ff>0x0&&(_0x142105+='\x20'+_0x37ca72[_0xe049('0x62')]+'\x20');_0x142105+=_0x37ca72['rules'][_0x5746ff][_0xe049('0x63')]?_0x1950ae(_0x37ca72[_0xe049('0x61')][_0x5746ff][_0xe049('0x63')]):_0x37ca72[_0xe049('0x61')][_0x5746ff][_0xe049('0x64')]+'\x20'+_0x37ca72[_0xe049('0x61')][_0x5746ff][_0xe049('0x65')]+(_0x9aa9d0(_0x37ca72['rules'][_0x5746ff]['condition'])?'\x20'+_0x37ca72[_0xe049('0x61')][_0x5746ff][_0xe049('0x66')]:'');}return _0x142105+')';};var _0x5c1322={'where':{'id':_0x36d52b['id']}},_0x4c1a59,_0x221836,_0x4e2ebf,_0x51324d,_0x328318;_0x5c1322=_[_0xe049('0x38')]({},_0x5c1322,_0x3f11a7);return db[_0xe049('0x26')][_0xe049('0x42')](_0x5c1322)[_0xe049('0x1f')](function(_0x4475c4){if(_0x4475c4){_0x4c1a59=_0x4475c4;return _0x4475c4['getFields']();}return null;})[_0xe049('0x1f')](function(_0x112dc4){if(_0x112dc4){if(!_0x112dc4[_0xe049('0x30')]){throw new db['Sequelize']['ValidationErrorItem'](_0xe049('0x6a'),0x193);}_0x221836=_0x112dc4;return db[_0xe049('0x85')][_0xe049('0x3d')]({'raw':!![]});}return null;})['then'](function(_0x97af2c){if(_0x97af2c){_0x4e2ebf=_[_0xe049('0x6b')](_0x97af2c,'id');var _0x1e733b;var _0x1b60de=squel[_0xe049('0x6c')]();_0x1b60de[_0xe049('0x6d')](_0x4c1a59[_0xe049('0x6e')]);for(var _0x2090aa=0x0;_0x2090aa<_0x221836['length'];_0x2090aa+=0x1){_0x1e733b=_0x221836[_0x2090aa][_0xe049('0x6f')]?_0x4e2ebf[_0x221836[_0x2090aa][_0xe049('0x6f')]][_0xe049('0x70')]:_0x221836[_0x2090aa][_0xe049('0x64')];_0x1e733b=_0x221836[_0x2090aa][_0xe049('0x71')]?_[_0xe049('0x72')](_0x328c13[_0x221836[_0x2090aa][_0xe049('0x71')]],'%s',_0x1e733b):_0x1e733b;_0x1e733b=_0x221836[_0x2090aa][_0xe049('0x73')]?_[_0xe049('0x72')](_0x5dc69b[_0x221836[_0x2090aa][_0xe049('0x73')]],'%s',_0x1e733b):_0x1e733b;if(_0x221836[_0x2090aa]['groupBy']){_0x1b60de['group'](_0x1e733b);}_0x221836[_0x2090aa]['orderBy']&&_0x1b60de['order'](_0x1e733b,_0x221836[_0x2090aa][_0xe049('0x75')]==='DESC'?![]:!![]);_0x1b60de['field'](_0x1e733b,_0x221836[_0x2090aa][_0xe049('0x86')]||_0x1e733b);}if(_0x4c1a59['joins']){_0x4c1a59['joins']=JSON[_0xe049('0x78')](_0x4c1a59[_0xe049('0x77')]);for(var _0x47d39e=0x0;_0x47d39e<_0x4c1a59[_0xe049('0x77')][_0xe049('0x30')];_0x47d39e+=0x1){if(_0x4c1a59[_0xe049('0x77')][_0x47d39e]['type']&&_[_0xe049('0x5c')](_0xb12f8e,_0x4c1a59[_0xe049('0x77')][_0x47d39e]['type'])&&_0x4c1a59[_0xe049('0x77')][_0x47d39e][_0xe049('0x7c')]&&_0x4c1a59[_0xe049('0x77')][_0x47d39e][_0xe049('0x7a')]&&_0x4c1a59[_0xe049('0x77')][_0x47d39e][_0xe049('0x79')]){_0x1b60de[_0x4c1a59[_0xe049('0x77')][_0x47d39e][_0xe049('0x29')]](_0x4c1a59[_0xe049('0x77')][_0x47d39e][_0xe049('0x7a')],null,util[_0xe049('0x73')](_0xe049('0x7b'),_0x4c1a59[_0xe049('0x6e')],_0x4c1a59[_0xe049('0x77')][_0x47d39e]['parentKey'],_0x4c1a59['joins'][_0x47d39e]['foreignTable'],_0x4c1a59[_0xe049('0x77')][_0x47d39e]['foreignKey']));}}}if(_0x4c1a59[_0xe049('0x7d')]){_0x4c1a59['conditions']=JSON[_0xe049('0x78')](_0x4c1a59[_0xe049('0x7d')]);_0x1b60de['where'](_0x1950ae(_0x4c1a59[_0xe049('0x7d')][_0xe049('0x63')]));}_0x328318=_0x1b60de['clone']();_0x1b60de[_0xe049('0x33')](_0x287fc8);_0x1b60de['offset'](0x0);logger[_0xe049('0x87')](_0xe049('0x7f'),_0x1b60de[_0xe049('0x80')]());return db[_0xe049('0x81')]['query'](_0x1b60de[_0xe049('0x80')](),{'type':db['sequelize']['QueryTypes']['SELECT']});}})[_0xe049('0x1f')](function(_0x300fe7){if(!_0x300fe7[_0xe049('0x30')]){throw new db[(_0xe049('0x68'))][(_0xe049('0x69'))](_0xe049('0x88'),0xcc);}if(_0x7f31d7[_0xe049('0x89')]==='web'){return null;}var _0xfee72d=_['merge'](_0x7f31d7,{'name':_0x7f31d7[_0xe049('0x8a')]||_0x7f31d7['name']||_0x4c1a59[_0xe049('0x22')],'basename':_0x5c2340,'savename':util[_0xe049('0x73')]('%s-%s.%s',_0x7f31d7[_0xe049('0x22')]||_0x4c1a59[_0xe049('0x22')],require(_0xe049('0x8b'))[_0xe049('0x8c')](0x4),_0x7f31d7[_0xe049('0x89')]||_0xe049('0x8d')),'reportId':_0x4c1a59['id'],'reportType':_0xe049('0x8e')});return db['AnalyticExtractedReport'][_0xe049('0x44')](_0xfee72d,{'raw':!![]});})['then'](function(_0x3008f5){if(_0x4c1a59[_0xe049('0x6e')]==='cdr'){_0x328318[_0xe049('0x36')](_0x4c1a59[_0xe049('0x6e')]+_0xe049('0x8f'),_0x7f31d7[_0xe049('0x90')],_0x7f31d7[_0xe049('0x91')]);}else{_0x328318['where'](_0x4c1a59[_0xe049('0x6e')]+_0xe049('0x92'),_0x7f31d7[_0xe049('0x90')],_0x7f31d7[_0xe049('0x91')]);}if(_0x3008f5){logger[_0xe049('0x93')](_0xe049('0x94'),_0x328318[_0xe049('0x80')]());require(_0xe049('0x95'))[_0xe049('0x96')](path[_0xe049('0x4e')](__dirname,_0xe049('0x97'),_0x3008f5[_0xe049('0x89')]),[_0x3008f5['id'],_0x328318[_0xe049('0x80')](),path[_0xe049('0x4e')](__dirname,'../../files/reports',_0x3008f5['savename']),_0x5c2340]);return _0x3008f5;}else{var _0x185144=squel[_0xe049('0x6c')]();_0x185144[_0xe049('0x6d')]('('+_0x328318['toString']()+')','countTable');_0x185144[_0xe049('0x64')](_0xe049('0x98'),_0xe049('0x99'));_0x328318[_0xe049('0x33')](_0x7f31d7[_0xe049('0x33')]||_0x287fc8);_0x328318[_0xe049('0x1a')](_0x7f31d7[_0xe049('0x1a')]||0x0);return dbH[_0xe049('0x81')][_0xe049('0x2d')](_0x185144['toString'](),{'type':dbH[_0xe049('0x81')][_0xe049('0x9a')][_0xe049('0x82')]})['then'](function(_0x4ffe16){if(!_0x4ffe16['length']){_0x51324d=0x0;}else{_0x51324d=_0x4ffe16[0x0]['count']||0x0;}return dbH[_0xe049('0x81')][_0xe049('0x2d')](_0x328318['toString'](),{'type':dbH[_0xe049('0x81')][_0xe049('0x9a')][_0xe049('0x82')]});})[_0xe049('0x1f')](function(_0x19b8d7){return{'rows':_0x19b8d7||[],'count':_0x51324d};});}});}exports['run']=function(_0x49dbd7,_0x4d8a25){return runReport(_0x49dbd7[_0xe049('0x40')],_0x49dbd7['query'],_0x49dbd7[_0xe049('0x3a')])[_0xe049('0x1f')](respondWithResult(_0x4d8a25,null))[_0xe049('0x43')](handleError(_0x4d8a25,null));};exports[_0xe049('0x9b')]=runReport;exports[_0xe049('0x2d')]=function(_0x369598,_0x224fba){var _0xf8ff=0xa;var _0x1ffb01=[_0xe049('0x4e'),_0xe049('0x4f'),_0xe049('0x50'),_0xe049('0x51')];var _0x2509f5={'SUM':_0xe049('0x9c'),'COUNT':_0xe049('0x52'),'COUNT DISTINCT':_0xe049('0x53'),'MAX':'MAX(%s)','MIN':_0xe049('0x9d'),'AVG':_0xe049('0x55'),'GROUP_CONCAT':_0xe049('0x56'),'GROUP_CONCAT ASC':_0xe049('0x57'),'GROUP_CONCAT DESC':_0xe049('0x58')};var _0x14d545={'SEC_TO_TIME':_0xe049('0x59'),'DATE':_0xe049('0x5a'),'HOUR':_0xe049('0x83'),'ROUND':_0xe049('0x5b'),'UNIX_TIMESTAMP':_0xe049('0x84')};var _0x507bdc=function(_0x4ef9f5){return!_[_0xe049('0x5c')]([_0xe049('0x5d'),'IS\x20NOT\x20NULL',_0xe049('0x5f'),'IS\x20NOT\x20EMPTY'],_0x4ef9f5);};var _0x32ecdd=function(_0x5e4a2a){if(!_0x5e4a2a||!_0x5e4a2a[_0xe049('0x61')]['length']){return'';}for(var _0x391b44='(',_0x55a8fe=0x0;_0x55a8fe<_0x5e4a2a['rules'][_0xe049('0x30')];_0x55a8fe+=0x1){_0x55a8fe>0x0&&(_0x391b44+='\x20'+_0x5e4a2a['operator']+'\x20');_0x391b44+=_0x5e4a2a[_0xe049('0x61')][_0x55a8fe][_0xe049('0x63')]?_0x32ecdd(_0x5e4a2a[_0xe049('0x61')][_0x55a8fe][_0xe049('0x63')]):_0x5e4a2a['rules'][_0x55a8fe][_0xe049('0x64')]+'\x20'+_0x5e4a2a[_0xe049('0x61')][_0x55a8fe][_0xe049('0x65')]+(_0x507bdc(_0x5e4a2a[_0xe049('0x61')][_0x55a8fe][_0xe049('0x65')])?'\x20'+_0x5e4a2a[_0xe049('0x61')][_0x55a8fe]['value']:'');}return _0x391b44+')';};var _0x4344fb={'where':{'id':_0x369598[_0xe049('0x40')]['id']}},_0xaa7e8d,_0x3d7a5f,_0x756119,_0x52a94b,_0x17e0b6;_0x4344fb=_['merge']({},_0x4344fb,_0x369598[_0xe049('0x3a')]);return db[_0xe049('0x26')]['find'](_0x4344fb)[_0xe049('0x1f')](function(_0x1613c9){if(_0x1613c9){_0xaa7e8d=_0x1613c9;return _0x1613c9['getFields']();}return null;})[_0xe049('0x1f')](function(_0x1597e1){if(_0x1597e1){if(!_0x1597e1['length']){throw new db[(_0xe049('0x68'))][(_0xe049('0x69'))](_0xe049('0x6a'),0x193);}_0x3d7a5f=_0x1597e1;return db[_0xe049('0x85')][_0xe049('0x3d')]({'raw':!![]});}return null;})[_0xe049('0x1f')](function(_0x470888){if(_0x470888){_0x756119=_[_0xe049('0x6b')](_0x470888,'id');var _0x5e99ab;var _0x142cdb=squel['select']();_0x142cdb[_0xe049('0x6d')](_0xaa7e8d[_0xe049('0x6e')]);for(var _0x4049bd=0x0;_0x4049bd<_0x3d7a5f[_0xe049('0x30')];_0x4049bd+=0x1){_0x5e99ab=_0x3d7a5f[_0x4049bd][_0xe049('0x6f')]?_0x756119[_0x3d7a5f[_0x4049bd][_0xe049('0x6f')]][_0xe049('0x70')]:_0x3d7a5f[_0x4049bd][_0xe049('0x64')];_0x5e99ab=_0x3d7a5f[_0x4049bd]['function']?_['replace'](_0x2509f5[_0x3d7a5f[_0x4049bd][_0xe049('0x71')]],'%s',_0x5e99ab):_0x5e99ab;_0x5e99ab=_0x3d7a5f[_0x4049bd]['format']?_['replace'](_0x14d545[_0x3d7a5f[_0x4049bd][_0xe049('0x73')]],'%s',_0x5e99ab):_0x5e99ab;if(_0x3d7a5f[_0x4049bd]['groupBy']){_0x142cdb['group'](_0x5e99ab);}_0x3d7a5f[_0x4049bd]['orderBy']&&_0x142cdb[_0xe049('0x34')](_0x5e99ab,_0x3d7a5f[_0x4049bd][_0xe049('0x75')]===_0xe049('0x76')?![]:!![]);_0x142cdb[_0xe049('0x64')](_0x5e99ab,_0x3d7a5f[_0x4049bd][_0xe049('0x86')]||_0x5e99ab);}if(_0xaa7e8d[_0xe049('0x77')]){_0xaa7e8d['joins']=JSON[_0xe049('0x78')](_0xaa7e8d[_0xe049('0x77')]);for(var _0x1dd2e9=0x0;_0x1dd2e9<_0xaa7e8d[_0xe049('0x77')][_0xe049('0x30')];_0x1dd2e9+=0x1){if(_0xaa7e8d[_0xe049('0x77')][_0x1dd2e9][_0xe049('0x29')]&&_[_0xe049('0x5c')](_0x1ffb01,_0xaa7e8d['joins'][_0x1dd2e9][_0xe049('0x29')])&&_0xaa7e8d[_0xe049('0x77')][_0x1dd2e9][_0xe049('0x7c')]&&_0xaa7e8d[_0xe049('0x77')][_0x1dd2e9][_0xe049('0x7a')]&&_0xaa7e8d[_0xe049('0x77')][_0x1dd2e9][_0xe049('0x79')]){_0x142cdb[_0xaa7e8d[_0xe049('0x77')][_0x1dd2e9][_0xe049('0x29')]](_0xaa7e8d[_0xe049('0x77')][_0x1dd2e9]['foreignTable'],null,util[_0xe049('0x73')](_0xe049('0x7b'),_0xaa7e8d[_0xe049('0x6e')],_0xaa7e8d[_0xe049('0x77')][_0x1dd2e9][_0xe049('0x7c')],_0xaa7e8d[_0xe049('0x77')][_0x1dd2e9]['foreignTable'],_0xaa7e8d[_0xe049('0x77')][_0x1dd2e9]['foreignKey']));}}}if(_0xaa7e8d[_0xe049('0x7d')]){_0xaa7e8d[_0xe049('0x7d')]=JSON[_0xe049('0x78')](_0xaa7e8d[_0xe049('0x7d')]);_0x142cdb[_0xe049('0x36')](_0x32ecdd(_0xaa7e8d[_0xe049('0x7d')][_0xe049('0x63')]));}_0x17e0b6=_0x142cdb[_0xe049('0x7e')]();_0x142cdb[_0xe049('0x33')](_0xf8ff);_0x142cdb[_0xe049('0x1a')](0x0);logger[_0xe049('0x87')]('Limited\x20Query:',_0x142cdb['toString']());return db[_0xe049('0x81')][_0xe049('0x2d')](_0x142cdb['toString'](),{'type':db['sequelize'][_0xe049('0x9a')][_0xe049('0x82')]});}})['then'](function(){return{'sql':_0x17e0b6['toString']()};})['then'](respondWithResult(_0x224fba,null))[_0xe049('0x43')](handleError(_0x224fba,null));};
\ No newline at end of file
+var _0x9221=['filter','merge','options','include','findAll','rows','show','rawAttributes','length','includeAll','find','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','get','autoAssociation','catch','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','preview','join','left_join','right_join','cross_join','SUM(%s)','COUNT(DISTINCT\x20%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','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','getFields','Sequelize','Please\x20insert\x20at\x20least\x20one\x20field','from','MetricId','metric','function','replace','format','groupBy','orderBy','DESC','alias','joins','parse','parentKey','foreignTable','foreignKey','table','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','MAX(%s)','ValidationErrorItem','AnalyticMetric','keyBy','select','No\x20available\x20data','output','web','fullPath','randomstring','generate','csv','custom','cdr','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','Run\x20Query:','child_process','../../components/export/','../../files/reports','savename','COUNT(*)','run','runReport','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','%s.%s\x20=\x20%s.%s','eml-format','rimraf','fast-json-patch','request-promise','bluebird','mustache','util','path','sox','to-csv','ejs','squel','crypto','jsforce','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/environment','../../mysqldb','dbH','sendStatus','status','end','count','limit','set','Content-Range','reject','save','update','then','destroy','CustomReports','UserProfileResource','error','stack','name','send','index','map','AnalyticCustomReport','fieldName','type','key','model','keys','query','filters','intersection','fields','attributes','hasOwnProperty','nolimit','offset','order','sort','where','VIRTUAL'];(function(_0x564df0,_0xfb8dfe){var _0x1ba957=function(_0x2a2845){while(--_0x2a2845){_0x564df0['push'](_0x564df0['shift']());}};_0x1ba957(++_0xfb8dfe);}(_0x9221,0x64));var _0x1922=function(_0xde0a7f,_0x33437f){_0xde0a7f=_0xde0a7f-0x0;var _0x1b5b69=_0x9221[_0xde0a7f];return _0x1b5b69;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x1922('0x0'));var rimraf=require(_0x1922('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x1922('0x2'));var rp=require(_0x1922('0x3'));var moment=require('moment');var BPromise=require(_0x1922('0x4'));var Mustache=require(_0x1922('0x5'));var util=require(_0x1922('0x6'));var path=require(_0x1922('0x7'));var sox=require(_0x1922('0x8'));var csv=require(_0x1922('0x9'));var ejs=require(_0x1922('0xa'));var fs=require('fs');var _=require('lodash');var squel=require(_0x1922('0xb'));var crypto=require(_0x1922('0xc'));var jsforce=require(_0x1922('0xd'));var deskjs=require('desk.js');var toCsv=require(_0x1922('0x9'));var querystring=require('querystring');var Papa=require(_0x1922('0xe'));var Redis=require(_0x1922('0xf'));var authService=require(_0x1922('0x10'));var qs=require('../../components/parsers/qs');var as=require(_0x1922('0x11'));var hardwareService=require(_0x1922('0x12'));var logger=require('../../config/logger')(_0x1922('0x13'));var utils=require('../../config/utils');var config=require(_0x1922('0x14'));var db=require('../../mysqldb')['db'];var dbH=require(_0x1922('0x15'))[_0x1922('0x16')];function respondWithStatusCode(_0x2db5b9,_0x58cfe7){_0x58cfe7=_0x58cfe7||0xcc;return function(_0x514b6d){if(_0x514b6d){return _0x2db5b9[_0x1922('0x17')](_0x58cfe7);}return _0x2db5b9[_0x1922('0x18')](_0x58cfe7)[_0x1922('0x19')]();};}function respondWithResult(_0x3116dc,_0x33b35d){_0x33b35d=_0x33b35d||0xc8;return function(_0x4a76f7){if(_0x4a76f7){return _0x3116dc[_0x1922('0x18')](_0x33b35d)['json'](_0x4a76f7);}};}function respondWithFilteredResult(_0x6b9389,_0x474f72){return function(_0x22e548){if(_0x22e548){var _0x207ff4=_0x22e548[_0x1922('0x1a')],_0x533390=_0x474f72['offset'],_0x459511=_0x474f72['offset']+_0x474f72[_0x1922('0x1b')],_0x195b86;if(_0x459511>=_0x207ff4){_0x459511=_0x207ff4;_0x195b86=0xc8;}else{_0x195b86=0xce;}_0x6b9389['status'](_0x195b86);return _0x6b9389[_0x1922('0x1c')](_0x1922('0x1d'),_0x533390+'-'+_0x459511+'/'+_0x207ff4)['json'](_0x22e548);}return null;};}function patchUpdates(_0x4c60f8){return function(_0xdd6f6c){try{jsonpatch['apply'](_0xdd6f6c,_0x4c60f8,!![]);}catch(_0x23984c){return BPromise[_0x1922('0x1e')](_0x23984c);}return _0xdd6f6c[_0x1922('0x1f')]();};}function saveUpdates(_0x1803be,_0x5dacc5){return function(_0x2f2c49){if(_0x2f2c49){return _0x2f2c49[_0x1922('0x20')](_0x1803be)[_0x1922('0x21')](function(_0x15fd74){return _0x15fd74;});}return null;};}function removeEntity(_0x554f8b,_0xa5a368){return function(_0x287af9){if(_0x287af9){return _0x287af9[_0x1922('0x22')]()['then'](function(){var _0x29b92f=_0x287af9['get']({'plain':!![]});var _0x547b8c=_0x1922('0x23');return db[_0x1922('0x24')][_0x1922('0x22')]({'where':{'type':_0x547b8c,'resourceId':_0x29b92f['id']}})[_0x1922('0x21')](function(){return _0x287af9;});})[_0x1922('0x21')](function(){_0x554f8b[_0x1922('0x18')](0xcc)[_0x1922('0x19')]();});}};}function handleEntityNotFound(_0x1402ae,_0x341b01){return function(_0x12f468){if(!_0x12f468){_0x1402ae[_0x1922('0x17')](0x194);}return _0x12f468;};}function handleError(_0x49176c,_0x3db249){_0x3db249=_0x3db249||0x1f4;return function(_0x58ebb5){logger[_0x1922('0x25')](_0x58ebb5[_0x1922('0x26')]);if(_0x58ebb5[_0x1922('0x27')]){delete _0x58ebb5[_0x1922('0x27')];}_0x49176c[_0x1922('0x18')](_0x3db249)[_0x1922('0x28')](_0x58ebb5);};}exports[_0x1922('0x29')]=function(_0x6f6d8c,_0x5c6535){var _0x4b0799={},_0x17ecaa={},_0x153ebd={'count':0x0,'rows':[]};var _0x353c71=_[_0x1922('0x2a')](db[_0x1922('0x2b')]['rawAttributes'],function(_0x10f398){return{'name':_0x10f398[_0x1922('0x2c')],'type':_0x10f398[_0x1922('0x2d')][_0x1922('0x2e')]};});_0x17ecaa[_0x1922('0x2f')]=_[_0x1922('0x2a')](_0x353c71,_0x1922('0x27'));_0x17ecaa['query']=_[_0x1922('0x30')](_0x6f6d8c[_0x1922('0x31')]);_0x17ecaa[_0x1922('0x32')]=_[_0x1922('0x33')](_0x17ecaa[_0x1922('0x2f')],_0x17ecaa[_0x1922('0x31')]);_0x4b0799['attributes']=_[_0x1922('0x33')](_0x17ecaa[_0x1922('0x2f')],qs[_0x1922('0x34')](_0x6f6d8c[_0x1922('0x31')][_0x1922('0x34')]));_0x4b0799[_0x1922('0x35')]=_0x4b0799[_0x1922('0x35')]['length']?_0x4b0799[_0x1922('0x35')]:_0x17ecaa[_0x1922('0x2f')];if(!_0x6f6d8c[_0x1922('0x31')][_0x1922('0x36')](_0x1922('0x37'))){_0x4b0799[_0x1922('0x1b')]=qs['limit'](_0x6f6d8c[_0x1922('0x31')][_0x1922('0x1b')]);_0x4b0799['offset']=qs[_0x1922('0x38')](_0x6f6d8c[_0x1922('0x31')]['offset']);}_0x4b0799[_0x1922('0x39')]=qs[_0x1922('0x3a')](_0x6f6d8c[_0x1922('0x31')]['sort']);_0x4b0799[_0x1922('0x3b')]=qs[_0x1922('0x32')](_['pick'](_0x6f6d8c[_0x1922('0x31')],_0x17ecaa[_0x1922('0x32')]),_0x353c71);if(_0x6f6d8c[_0x1922('0x31')]['filter']){_0x4b0799[_0x1922('0x3b')]=_['merge'](_0x4b0799[_0x1922('0x3b')],{'$or':_['map'](_0x353c71,function(_0x53572f){if(_0x53572f[_0x1922('0x2d')]!==_0x1922('0x3c')){var _0x5f423d={};_0x5f423d[_0x53572f[_0x1922('0x27')]]={'$like':'%'+_0x6f6d8c[_0x1922('0x31')][_0x1922('0x3d')]+'%'};return _0x5f423d;}})});}_0x4b0799=_[_0x1922('0x3e')]({},_0x4b0799,_0x6f6d8c[_0x1922('0x3f')]);var _0x4c2295={'where':_0x4b0799['where']};return db[_0x1922('0x2b')][_0x1922('0x1a')](_0x4c2295)[_0x1922('0x21')](function(_0x1183a7){_0x153ebd[_0x1922('0x1a')]=_0x1183a7;if(_0x6f6d8c[_0x1922('0x31')]['includeAll']){_0x4b0799[_0x1922('0x40')]=[{'all':!![]}];}return db[_0x1922('0x2b')][_0x1922('0x41')](_0x4b0799);})[_0x1922('0x21')](function(_0x29b8af){_0x153ebd[_0x1922('0x42')]=_0x29b8af;return _0x153ebd;})[_0x1922('0x21')](respondWithFilteredResult(_0x5c6535,_0x4b0799))['catch'](handleError(_0x5c6535,null));};exports[_0x1922('0x43')]=function(_0x1e474b,_0x3f9f64){var _0x5df17d={'raw':![],'where':{'id':_0x1e474b['params']['id']}},_0x18a891={};_0x18a891[_0x1922('0x2f')]=_[_0x1922('0x30')](db[_0x1922('0x2b')][_0x1922('0x44')]);_0x18a891[_0x1922('0x31')]=_['keys'](_0x1e474b[_0x1922('0x31')]);_0x18a891[_0x1922('0x32')]=_[_0x1922('0x33')](_0x18a891[_0x1922('0x2f')],_0x18a891['query']);_0x5df17d[_0x1922('0x35')]=_['intersection'](_0x18a891[_0x1922('0x2f')],qs[_0x1922('0x34')](_0x1e474b[_0x1922('0x31')][_0x1922('0x34')]));_0x5df17d[_0x1922('0x35')]=_0x5df17d[_0x1922('0x35')][_0x1922('0x45')]?_0x5df17d['attributes']:_0x18a891['model'];if(_0x1e474b['query'][_0x1922('0x46')]){_0x5df17d[_0x1922('0x40')]=[{'all':!![]}];}_0x5df17d=_[_0x1922('0x3e')]({},_0x5df17d,_0x1e474b[_0x1922('0x3f')]);return db[_0x1922('0x2b')][_0x1922('0x47')](_0x5df17d)[_0x1922('0x21')](handleEntityNotFound(_0x3f9f64,null))[_0x1922('0x21')](respondWithResult(_0x3f9f64,null))['catch'](handleError(_0x3f9f64,null));};exports[_0x1922('0x48')]=function(_0x2b4179,_0x4ed204){return db[_0x1922('0x2b')][_0x1922('0x48')](_0x2b4179[_0x1922('0x49')],{})[_0x1922('0x21')](function(_0x1e6d2f){var _0x5b51c2=_0x2b4179['user']['get']({'plain':!![]});if(!_0x5b51c2)throw new Error(_0x1922('0x4a'));if(_0x5b51c2['role']==='user'){var _0x28adf1=_0x1e6d2f[_0x1922('0x4b')]({'plain':!![]});var _0x22d668='Reports';return db['UserProfileSection']['find']({'where':{'name':_0x22d668,'userProfileId':_0x5b51c2['userProfileId']},'raw':!![]})[_0x1922('0x21')](function(_0x2abb8a){if(_0x2abb8a&&_0x2abb8a[_0x1922('0x4c')]===0x0){return db[_0x1922('0x24')]['create']({'name':_0x28adf1[_0x1922('0x27')],'resourceId':_0x28adf1['id'],'type':_0x1922('0x23'),'sectionId':_0x2abb8a['id']},{})[_0x1922('0x21')](function(){return _0x1e6d2f;});}else{return _0x1e6d2f;}})[_0x1922('0x4d')](function(_0x494b84){logger[_0x1922('0x25')](_0x1922('0x4e'),_0x494b84);throw _0x494b84;});}return _0x1e6d2f;})['then'](respondWithResult(_0x4ed204,0xc9))[_0x1922('0x4d')](handleError(_0x4ed204,null));};exports[_0x1922('0x20')]=function(_0x12a89f,_0x245d6f){if(_0x12a89f[_0x1922('0x49')]['id']){delete _0x12a89f[_0x1922('0x49')]['id'];}return db[_0x1922('0x2b')][_0x1922('0x47')]({'where':{'id':_0x12a89f[_0x1922('0x4f')]['id']}})[_0x1922('0x21')](handleEntityNotFound(_0x245d6f,null))[_0x1922('0x21')](saveUpdates(_0x12a89f[_0x1922('0x49')],null))[_0x1922('0x21')](respondWithResult(_0x245d6f,null))[_0x1922('0x4d')](handleError(_0x245d6f,null));};exports[_0x1922('0x22')]=function(_0x57faf7,_0x11d8b6){return db[_0x1922('0x2b')][_0x1922('0x47')]({'where':{'id':_0x57faf7[_0x1922('0x4f')]['id']}})['then'](handleEntityNotFound(_0x11d8b6,null))['then'](removeEntity(_0x11d8b6,null))['catch'](handleError(_0x11d8b6,null));};exports[_0x1922('0x50')]=function(_0x2777dd,_0x1eef02){var _0x46fb40=0xa;var _0x34c109=[_0x1922('0x51'),_0x1922('0x52'),_0x1922('0x53'),_0x1922('0x54')];var _0x4b2aa0={'SUM':_0x1922('0x55'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x1922('0x56'),'MAX':'MAX(%s)','MIN':_0x1922('0x57'),'AVG':_0x1922('0x58'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x1922('0x59'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0xecb766={'SEC_TO_TIME':_0x1922('0x5a'),'DATE':_0x1922('0x5b'),'HOUR':_0x1922('0x5c'),'ROUND':_0x1922('0x5d'),'UNIX_TIMESTAMP':_0x1922('0x5e')};var _0x53e7ee=function(_0x1e6863){return!_[_0x1922('0x5f')]([_0x1922('0x60'),_0x1922('0x61'),_0x1922('0x62'),_0x1922('0x63')],_0x1e6863);};var _0x10a7ce=function(_0x39f5da){if(!_0x39f5da||!_0x39f5da[_0x1922('0x64')][_0x1922('0x45')]){return'';}for(var _0x41f53f='(',_0x4ff467=0x0;_0x4ff467<_0x39f5da[_0x1922('0x64')][_0x1922('0x45')];_0x4ff467+=0x1){_0x4ff467>0x0&&(_0x41f53f+='\x20'+_0x39f5da[_0x1922('0x65')]+'\x20');_0x41f53f+=_0x39f5da[_0x1922('0x64')][_0x4ff467][_0x1922('0x66')]?_0x10a7ce(_0x39f5da[_0x1922('0x64')][_0x4ff467][_0x1922('0x66')]):_0x39f5da[_0x1922('0x64')][_0x4ff467][_0x1922('0x67')]+'\x20'+_0x39f5da[_0x1922('0x64')][_0x4ff467][_0x1922('0x68')]+(_0x53e7ee(_0x39f5da['rules'][_0x4ff467][_0x1922('0x68')])?'\x20'+_0x39f5da[_0x1922('0x64')][_0x4ff467][_0x1922('0x69')]:'');}return _0x41f53f+')';};var _0x481d81={'where':{'id':_0x2777dd[_0x1922('0x4f')]['id']}},_0x214eb4,_0x2dbb37,_0x287726,_0x4cda1d,_0x48b311;_0x481d81=_['merge']({},_0x481d81,_0x2777dd[_0x1922('0x3f')]);return db[_0x1922('0x2b')][_0x1922('0x47')](_0x481d81)[_0x1922('0x21')](function(_0x51a42d){if(_0x51a42d){_0x214eb4=_0x51a42d;return _0x51a42d[_0x1922('0x6a')]();}return null;})[_0x1922('0x21')](function(_0x20a5ec){if(_0x20a5ec){if(!_0x20a5ec[_0x1922('0x45')]){throw new db[(_0x1922('0x6b'))]['ValidationErrorItem'](_0x1922('0x6c'),0x193);}_0x2dbb37=_0x20a5ec;return db['AnalyticMetric'][_0x1922('0x41')]({'raw':!![]});}return null;})[_0x1922('0x21')](function(_0x139285){if(_0x139285){_0x287726=_['keyBy'](_0x139285,'id');var _0x432706;var _0x577174=squel['select']();_0x577174[_0x1922('0x6d')](_0x214eb4['table']);for(var _0x6c5001=0x0;_0x6c5001<_0x2dbb37[_0x1922('0x45')];_0x6c5001+=0x1){_0x432706=_0x2dbb37[_0x6c5001][_0x1922('0x6e')]?_0x287726[_0x2dbb37[_0x6c5001][_0x1922('0x6e')]][_0x1922('0x6f')]:_0x2dbb37[_0x6c5001][_0x1922('0x67')];_0x432706=_0x2dbb37[_0x6c5001][_0x1922('0x70')]?_[_0x1922('0x71')](_0x4b2aa0[_0x2dbb37[_0x6c5001]['function']],'%s',_0x432706):_0x432706;_0x432706=_0x2dbb37[_0x6c5001][_0x1922('0x72')]?_[_0x1922('0x71')](_0xecb766[_0x2dbb37[_0x6c5001][_0x1922('0x72')]],'%s',_0x432706):_0x432706;if(_0x2dbb37[_0x6c5001][_0x1922('0x73')]){_0x577174[_0x1922('0x66')](_0x432706);}_0x2dbb37[_0x6c5001][_0x1922('0x74')]&&_0x577174[_0x1922('0x39')](_0x432706,_0x2dbb37[_0x6c5001][_0x1922('0x74')]===_0x1922('0x75')?![]:!![]);_0x577174[_0x1922('0x67')](_0x432706,_0x2dbb37[_0x6c5001][_0x1922('0x76')]||_0x432706);}if(_0x214eb4['joins']){_0x214eb4[_0x1922('0x77')]=JSON[_0x1922('0x78')](_0x214eb4[_0x1922('0x77')]);for(var _0x413e52=0x0;_0x413e52<_0x214eb4[_0x1922('0x77')][_0x1922('0x45')];_0x413e52+=0x1){if(_0x214eb4[_0x1922('0x77')][_0x413e52][_0x1922('0x2d')]&&_[_0x1922('0x5f')](_0x34c109,_0x214eb4[_0x1922('0x77')][_0x413e52][_0x1922('0x2d')])&&_0x214eb4[_0x1922('0x77')][_0x413e52][_0x1922('0x79')]&&_0x214eb4[_0x1922('0x77')][_0x413e52][_0x1922('0x7a')]&&_0x214eb4[_0x1922('0x77')][_0x413e52][_0x1922('0x7b')]){_0x577174[_0x214eb4[_0x1922('0x77')][_0x413e52][_0x1922('0x2d')]](_0x214eb4[_0x1922('0x77')][_0x413e52][_0x1922('0x7a')],null,util[_0x1922('0x72')]('%s.%s\x20=\x20%s.%s',_0x214eb4[_0x1922('0x7c')],_0x214eb4[_0x1922('0x77')][_0x413e52][_0x1922('0x79')],_0x214eb4[_0x1922('0x77')][_0x413e52][_0x1922('0x7a')],_0x214eb4['joins'][_0x413e52][_0x1922('0x7b')]));}}}if(_0x214eb4['conditions']){_0x214eb4[_0x1922('0x7d')]=JSON[_0x1922('0x78')](_0x214eb4[_0x1922('0x7d')]);_0x577174[_0x1922('0x3b')](_0x10a7ce(_0x214eb4[_0x1922('0x7d')][_0x1922('0x66')]));}_0x48b311=_0x577174[_0x1922('0x7e')]();_0x577174['limit'](_0x46fb40);_0x577174[_0x1922('0x38')](0x0);logger[_0x1922('0x7f')](_0x1922('0x80'),_0x577174[_0x1922('0x81')]());return db[_0x1922('0x82')][_0x1922('0x31')](_0x577174[_0x1922('0x81')](),{'type':db['sequelize'][_0x1922('0x83')][_0x1922('0x84')]});}})[_0x1922('0x21')](respondWithResult(_0x1eef02,null))[_0x1922('0x4d')](handleError(_0x1eef02,null));};function runReport(_0x3dbf8d,_0x32b23f,_0x22981e){var _0x14b419=_0x32b23f[_0x1922('0x27')];var _0x239e0f=0xa;var _0x50bc2a=[_0x1922('0x51'),'left_join',_0x1922('0x53'),_0x1922('0x54')];var _0x28b5d8={'SUM':_0x1922('0x55'),'COUNT':'COUNT(%s)','COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x1922('0x85'),'MIN':_0x1922('0x57'),'AVG':_0x1922('0x58'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x1922('0x59'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x12204f={'SEC_TO_TIME':_0x1922('0x5a'),'DATE':_0x1922('0x5b'),'HOUR':_0x1922('0x5c'),'ROUND':_0x1922('0x5d'),'UNIX_TIMESTAMP':_0x1922('0x5e')};var _0x13dba6=function(_0x3688c5){return!_['includes'](['IS\x20NULL','IS\x20NOT\x20NULL',_0x1922('0x62'),_0x1922('0x63')],_0x3688c5);};var _0xc04653=function(_0x137fd8){if(!_0x137fd8||!_0x137fd8['rules'][_0x1922('0x45')]){return'';}for(var _0x4dcb1b='(',_0x48b387=0x0;_0x48b387<_0x137fd8['rules'][_0x1922('0x45')];_0x48b387+=0x1){_0x48b387>0x0&&(_0x4dcb1b+='\x20'+_0x137fd8[_0x1922('0x65')]+'\x20');_0x4dcb1b+=_0x137fd8[_0x1922('0x64')][_0x48b387]['group']?_0xc04653(_0x137fd8['rules'][_0x48b387][_0x1922('0x66')]):_0x137fd8[_0x1922('0x64')][_0x48b387][_0x1922('0x67')]+'\x20'+_0x137fd8[_0x1922('0x64')][_0x48b387][_0x1922('0x68')]+(_0x13dba6(_0x137fd8['rules'][_0x48b387][_0x1922('0x68')])?'\x20'+_0x137fd8['rules'][_0x48b387][_0x1922('0x69')]:'');}return _0x4dcb1b+')';};var _0x4672a3={'where':{'id':_0x3dbf8d['id']}},_0x2c70b6,_0x158d39,_0x203037,_0x3137ec,_0x175278;_0x4672a3=_[_0x1922('0x3e')]({},_0x4672a3,_0x22981e);return db[_0x1922('0x2b')][_0x1922('0x47')](_0x4672a3)[_0x1922('0x21')](function(_0x5ab8a4){if(_0x5ab8a4){_0x2c70b6=_0x5ab8a4;return _0x5ab8a4[_0x1922('0x6a')]();}return null;})[_0x1922('0x21')](function(_0xde6c2c){if(_0xde6c2c){if(!_0xde6c2c[_0x1922('0x45')]){throw new db['Sequelize'][(_0x1922('0x86'))](_0x1922('0x6c'),0x193);}_0x158d39=_0xde6c2c;return db[_0x1922('0x87')]['findAll']({'raw':!![]});}return null;})['then'](function(_0x4949e3){if(_0x4949e3){_0x203037=_[_0x1922('0x88')](_0x4949e3,'id');var _0x59a204;var _0x5da23c=squel[_0x1922('0x89')]();_0x5da23c[_0x1922('0x6d')](_0x2c70b6[_0x1922('0x7c')]);for(var _0x4f6c99=0x0;_0x4f6c99<_0x158d39[_0x1922('0x45')];_0x4f6c99+=0x1){_0x59a204=_0x158d39[_0x4f6c99][_0x1922('0x6e')]?_0x203037[_0x158d39[_0x4f6c99]['MetricId']][_0x1922('0x6f')]:_0x158d39[_0x4f6c99][_0x1922('0x67')];_0x59a204=_0x158d39[_0x4f6c99][_0x1922('0x70')]?_[_0x1922('0x71')](_0x28b5d8[_0x158d39[_0x4f6c99][_0x1922('0x70')]],'%s',_0x59a204):_0x59a204;_0x59a204=_0x158d39[_0x4f6c99][_0x1922('0x72')]?_[_0x1922('0x71')](_0x12204f[_0x158d39[_0x4f6c99][_0x1922('0x72')]],'%s',_0x59a204):_0x59a204;if(_0x158d39[_0x4f6c99][_0x1922('0x73')]){_0x5da23c[_0x1922('0x66')](_0x59a204);}_0x158d39[_0x4f6c99][_0x1922('0x74')]&&_0x5da23c[_0x1922('0x39')](_0x59a204,_0x158d39[_0x4f6c99][_0x1922('0x74')]===_0x1922('0x75')?![]:!![]);_0x5da23c[_0x1922('0x67')](_0x59a204,_0x158d39[_0x4f6c99]['alias']||_0x59a204);}if(_0x2c70b6[_0x1922('0x77')]){_0x2c70b6[_0x1922('0x77')]=JSON[_0x1922('0x78')](_0x2c70b6['joins']);for(var _0x76e378=0x0;_0x76e378<_0x2c70b6[_0x1922('0x77')][_0x1922('0x45')];_0x76e378+=0x1){if(_0x2c70b6['joins'][_0x76e378][_0x1922('0x2d')]&&_[_0x1922('0x5f')](_0x50bc2a,_0x2c70b6[_0x1922('0x77')][_0x76e378]['type'])&&_0x2c70b6[_0x1922('0x77')][_0x76e378]['parentKey']&&_0x2c70b6[_0x1922('0x77')][_0x76e378][_0x1922('0x7a')]&&_0x2c70b6[_0x1922('0x77')][_0x76e378][_0x1922('0x7b')]){_0x5da23c[_0x2c70b6[_0x1922('0x77')][_0x76e378][_0x1922('0x2d')]](_0x2c70b6[_0x1922('0x77')][_0x76e378]['foreignTable'],null,util[_0x1922('0x72')]('%s.%s\x20=\x20%s.%s',_0x2c70b6[_0x1922('0x7c')],_0x2c70b6[_0x1922('0x77')][_0x76e378][_0x1922('0x79')],_0x2c70b6[_0x1922('0x77')][_0x76e378]['foreignTable'],_0x2c70b6[_0x1922('0x77')][_0x76e378][_0x1922('0x7b')]));}}}if(_0x2c70b6[_0x1922('0x7d')]){_0x2c70b6[_0x1922('0x7d')]=JSON['parse'](_0x2c70b6['conditions']);_0x5da23c['where'](_0xc04653(_0x2c70b6[_0x1922('0x7d')]['group']));}_0x175278=_0x5da23c[_0x1922('0x7e')]();_0x5da23c['limit'](_0x239e0f);_0x5da23c[_0x1922('0x38')](0x0);logger[_0x1922('0x7f')](_0x1922('0x80'),_0x5da23c[_0x1922('0x81')]());return db[_0x1922('0x82')][_0x1922('0x31')](_0x5da23c[_0x1922('0x81')](),{'type':db['sequelize']['QueryTypes'][_0x1922('0x84')]});}})['then'](function(_0x5d1035){if(!_0x5d1035[_0x1922('0x45')]){throw new db['Sequelize']['ValidationErrorItem'](_0x1922('0x8a'),0xcc);}if(_0x32b23f[_0x1922('0x8b')]===_0x1922('0x8c')){return null;}var _0x471455=_[_0x1922('0x3e')](_0x32b23f,{'name':_0x32b23f[_0x1922('0x8d')]||_0x32b23f[_0x1922('0x27')]||_0x2c70b6[_0x1922('0x27')],'basename':_0x14b419,'savename':util[_0x1922('0x72')]('%s-%s.%s',_0x32b23f[_0x1922('0x27')]||_0x2c70b6[_0x1922('0x27')],require(_0x1922('0x8e'))[_0x1922('0x8f')](0x4),_0x32b23f[_0x1922('0x8b')]||_0x1922('0x90')),'reportId':_0x2c70b6['id'],'reportType':_0x1922('0x91')});return db['AnalyticExtractedReport'][_0x1922('0x48')](_0x471455,{'raw':!![]});})['then'](function(_0x5aa486){if(_0x2c70b6['table']===_0x1922('0x92')){_0x175278[_0x1922('0x3b')](_0x2c70b6[_0x1922('0x7c')]+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x32b23f[_0x1922('0x93')],_0x32b23f[_0x1922('0x94')]);}else{_0x175278[_0x1922('0x3b')](_0x2c70b6['table']+_0x1922('0x95'),_0x32b23f[_0x1922('0x93')],_0x32b23f[_0x1922('0x94')]);}if(_0x5aa486){logger['info'](_0x1922('0x96'),_0x175278[_0x1922('0x81')]());require(_0x1922('0x97'))['fork'](path['join'](__dirname,_0x1922('0x98'),_0x5aa486[_0x1922('0x8b')]),[_0x5aa486['id'],_0x175278[_0x1922('0x81')](),path[_0x1922('0x51')](__dirname,_0x1922('0x99'),_0x5aa486[_0x1922('0x9a')]),_0x14b419]);return _0x5aa486;}else{var _0x259fe0=squel['select']();_0x259fe0[_0x1922('0x6d')]('('+_0x175278[_0x1922('0x81')]()+')','countTable');_0x259fe0[_0x1922('0x67')](_0x1922('0x9b'),_0x1922('0x1a'));_0x175278[_0x1922('0x1b')](_0x32b23f[_0x1922('0x1b')]||_0x239e0f);_0x175278[_0x1922('0x38')](_0x32b23f[_0x1922('0x38')]||0x0);return dbH[_0x1922('0x82')][_0x1922('0x31')](_0x259fe0[_0x1922('0x81')](),{'type':dbH[_0x1922('0x82')][_0x1922('0x83')][_0x1922('0x84')]})['then'](function(_0x19caee){if(!_0x19caee[_0x1922('0x45')]){_0x3137ec=0x0;}else{_0x3137ec=_0x19caee[0x0][_0x1922('0x1a')]||0x0;}return dbH[_0x1922('0x82')][_0x1922('0x31')](_0x175278[_0x1922('0x81')](),{'type':dbH['sequelize']['QueryTypes']['SELECT']});})[_0x1922('0x21')](function(_0x16695a){return{'rows':_0x16695a||[],'count':_0x3137ec};});}});}exports[_0x1922('0x9c')]=function(_0x482413,_0x254300){return runReport(_0x482413[_0x1922('0x4f')],_0x482413[_0x1922('0x31')],_0x482413['options'])[_0x1922('0x21')](respondWithResult(_0x254300,null))[_0x1922('0x4d')](handleError(_0x254300,null));};exports[_0x1922('0x9d')]=runReport;exports[_0x1922('0x31')]=function(_0x5d9d28,_0x1b2e71){var _0x7bd6d0=0xa;var _0x181a90=[_0x1922('0x51'),'left_join',_0x1922('0x53'),_0x1922('0x54')];var _0x5caa8d={'SUM':_0x1922('0x55'),'COUNT':'COUNT(%s)','COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x1922('0x85'),'MIN':_0x1922('0x57'),'AVG':_0x1922('0x58'),'GROUP_CONCAT':_0x1922('0x9e'),'GROUP_CONCAT ASC':_0x1922('0x59'),'GROUP_CONCAT DESC':_0x1922('0x9f')};var _0x4fa8e1={'SEC_TO_TIME':_0x1922('0x5a'),'DATE':_0x1922('0x5b'),'HOUR':_0x1922('0x5c'),'ROUND':_0x1922('0x5d'),'UNIX_TIMESTAMP':_0x1922('0x5e')};var _0x2cff0c=function(_0x495d7c){return!_[_0x1922('0x5f')]([_0x1922('0x60'),_0x1922('0x61'),_0x1922('0x62'),_0x1922('0x63')],_0x495d7c);};var _0x4dce6e=function(_0x5e3fa2){if(!_0x5e3fa2||!_0x5e3fa2[_0x1922('0x64')][_0x1922('0x45')]){return'';}for(var _0x464977='(',_0x2e3c5d=0x0;_0x2e3c5d<_0x5e3fa2['rules'][_0x1922('0x45')];_0x2e3c5d+=0x1){_0x2e3c5d>0x0&&(_0x464977+='\x20'+_0x5e3fa2[_0x1922('0x65')]+'\x20');_0x464977+=_0x5e3fa2[_0x1922('0x64')][_0x2e3c5d][_0x1922('0x66')]?_0x4dce6e(_0x5e3fa2['rules'][_0x2e3c5d][_0x1922('0x66')]):_0x5e3fa2[_0x1922('0x64')][_0x2e3c5d][_0x1922('0x67')]+'\x20'+_0x5e3fa2[_0x1922('0x64')][_0x2e3c5d][_0x1922('0x68')]+(_0x2cff0c(_0x5e3fa2['rules'][_0x2e3c5d][_0x1922('0x68')])?'\x20'+_0x5e3fa2[_0x1922('0x64')][_0x2e3c5d][_0x1922('0x69')]:'');}return _0x464977+')';};var _0x60c7d={'where':{'id':_0x5d9d28[_0x1922('0x4f')]['id']}},_0x5dabda,_0x3e96f0,_0x4eb7d0,_0x5dc157,_0x53a9b9;_0x60c7d=_[_0x1922('0x3e')]({},_0x60c7d,_0x5d9d28[_0x1922('0x3f')]);return db[_0x1922('0x2b')][_0x1922('0x47')](_0x60c7d)[_0x1922('0x21')](function(_0x4cc90b){if(_0x4cc90b){_0x5dabda=_0x4cc90b;return _0x4cc90b[_0x1922('0x6a')]();}return null;})[_0x1922('0x21')](function(_0x51d0cd){if(_0x51d0cd){if(!_0x51d0cd[_0x1922('0x45')]){throw new db['Sequelize'][(_0x1922('0x86'))](_0x1922('0x6c'),0x193);}_0x3e96f0=_0x51d0cd;return db[_0x1922('0x87')]['findAll']({'raw':!![]});}return null;})[_0x1922('0x21')](function(_0x537ed0){if(_0x537ed0){_0x4eb7d0=_[_0x1922('0x88')](_0x537ed0,'id');var _0x1fd925;var _0x3f8672=squel['select']();_0x3f8672[_0x1922('0x6d')](_0x5dabda[_0x1922('0x7c')]);for(var _0x35d2b3=0x0;_0x35d2b3<_0x3e96f0[_0x1922('0x45')];_0x35d2b3+=0x1){_0x1fd925=_0x3e96f0[_0x35d2b3][_0x1922('0x6e')]?_0x4eb7d0[_0x3e96f0[_0x35d2b3]['MetricId']][_0x1922('0x6f')]:_0x3e96f0[_0x35d2b3]['field'];_0x1fd925=_0x3e96f0[_0x35d2b3][_0x1922('0x70')]?_[_0x1922('0x71')](_0x5caa8d[_0x3e96f0[_0x35d2b3][_0x1922('0x70')]],'%s',_0x1fd925):_0x1fd925;_0x1fd925=_0x3e96f0[_0x35d2b3][_0x1922('0x72')]?_[_0x1922('0x71')](_0x4fa8e1[_0x3e96f0[_0x35d2b3]['format']],'%s',_0x1fd925):_0x1fd925;if(_0x3e96f0[_0x35d2b3][_0x1922('0x73')]){_0x3f8672['group'](_0x1fd925);}_0x3e96f0[_0x35d2b3]['orderBy']&&_0x3f8672[_0x1922('0x39')](_0x1fd925,_0x3e96f0[_0x35d2b3]['orderBy']==='DESC'?![]:!![]);_0x3f8672['field'](_0x1fd925,_0x3e96f0[_0x35d2b3][_0x1922('0x76')]||_0x1fd925);}if(_0x5dabda['joins']){_0x5dabda['joins']=JSON[_0x1922('0x78')](_0x5dabda['joins']);for(var _0x56e1b3=0x0;_0x56e1b3<_0x5dabda[_0x1922('0x77')]['length'];_0x56e1b3+=0x1){if(_0x5dabda[_0x1922('0x77')][_0x56e1b3][_0x1922('0x2d')]&&_[_0x1922('0x5f')](_0x181a90,_0x5dabda[_0x1922('0x77')][_0x56e1b3]['type'])&&_0x5dabda[_0x1922('0x77')][_0x56e1b3][_0x1922('0x79')]&&_0x5dabda[_0x1922('0x77')][_0x56e1b3][_0x1922('0x7a')]&&_0x5dabda['joins'][_0x56e1b3][_0x1922('0x7b')]){_0x3f8672[_0x5dabda['joins'][_0x56e1b3][_0x1922('0x2d')]](_0x5dabda[_0x1922('0x77')][_0x56e1b3][_0x1922('0x7a')],null,util['format'](_0x1922('0xa0'),_0x5dabda[_0x1922('0x7c')],_0x5dabda[_0x1922('0x77')][_0x56e1b3][_0x1922('0x79')],_0x5dabda[_0x1922('0x77')][_0x56e1b3][_0x1922('0x7a')],_0x5dabda[_0x1922('0x77')][_0x56e1b3][_0x1922('0x7b')]));}}}if(_0x5dabda[_0x1922('0x7d')]){_0x5dabda['conditions']=JSON[_0x1922('0x78')](_0x5dabda[_0x1922('0x7d')]);_0x3f8672[_0x1922('0x3b')](_0x4dce6e(_0x5dabda[_0x1922('0x7d')][_0x1922('0x66')]));}_0x53a9b9=_0x3f8672[_0x1922('0x7e')]();_0x3f8672[_0x1922('0x1b')](_0x7bd6d0);_0x3f8672['offset'](0x0);logger[_0x1922('0x7f')](_0x1922('0x80'),_0x3f8672[_0x1922('0x81')]());return db['sequelize']['query'](_0x3f8672[_0x1922('0x81')](),{'type':db[_0x1922('0x82')]['QueryTypes'][_0x1922('0x84')]});}})[_0x1922('0x21')](function(){return{'sql':_0x53a9b9[_0x1922('0x81')]()};})['then'](respondWithResult(_0x1b2e71,null))[_0x1922('0x4d')](handleError(_0x1b2e71,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff