// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xd8ac=['body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','preview','join','left_join','right_join','cross_join','SUM(%s)','COUNT(%s)','MAX(%s)','MIN(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','DATE(%s)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','group','field','condition','value','getFields','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','select','from','table','MetricId','metric','replace','format','groupBy','orderBy','order','DESC','joins','parentKey','foreignTable','foreignKey','conditions','clone','debug','toString','sequelize','QueryTypes','COUNT(DISTINCT\x20%s)','AVG(%s)','Sequelize','function','alias','parse','%s.%s\x20=\x20%s.%s','fullPath','%s-%s.%s','randomstring','generate','output','csv','custom','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','startDate','info','Run\x20Query:','child_process','fork','../../files/reports','savename','countTable','SELECT','operator','Limited\x20Query:','eml-format','rimraf','request-promise','moment','bluebird','mustache','util','to-csv','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','json','offset','limit','undefined','count','set','apply','reject','save','update','then','destroy','get','CustomReports','error','stack','send','index','AnalyticCustomReport','rawAttributes','fieldName','type','model','map','name','query','keys','intersection','fields','attributes','hasOwnProperty','nolimit','sort','where','filters','pick','filter','merge','VIRTUAL','options','includeAll','include','findAll','rows','catch','params','length','find','create'];(function(_0xa18665,_0x5d6110){var _0x521a06=function(_0xfc6c56){while(--_0xfc6c56){_0xa18665['push'](_0xa18665['shift']());}};_0x521a06(++_0x5d6110);}(_0xd8ac,0x100));var _0xcd8a=function(_0x167cc1,_0x56ef5a){_0x167cc1=_0x167cc1-0x0;var _0x10bc4b=_0xd8ac[_0x167cc1];return _0x10bc4b;};'use strict';var emlformat=require(_0xcd8a('0x0'));var rimraf=require(_0xcd8a('0x1'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0xcd8a('0x2'));var moment=require(_0xcd8a('0x3'));var BPromise=require(_0xcd8a('0x4'));var Mustache=require(_0xcd8a('0x5'));var util=require(_0xcd8a('0x6'));var path=require('path');var sox=require('sox');var csv=require(_0xcd8a('0x7'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xcd8a('0x8'));var _=require(_0xcd8a('0x9'));var squel=require(_0xcd8a('0xa'));var crypto=require(_0xcd8a('0xb'));var jsforce=require(_0xcd8a('0xc'));var deskjs=require(_0xcd8a('0xd'));var toCsv=require('to-csv');var querystring=require(_0xcd8a('0xe'));var Papa=require(_0xcd8a('0xf'));var Redis=require(_0xcd8a('0x10'));var authService=require(_0xcd8a('0x11'));var qs=require(_0xcd8a('0x12'));var as=require(_0xcd8a('0x13'));var hardwareService=require(_0xcd8a('0x14'));var logger=require('../../config/logger')(_0xcd8a('0x15'));var utils=require(_0xcd8a('0x16'));var config=require(_0xcd8a('0x17'));var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];var dbH=require(_0xcd8a('0x18'))['dbH'];function respondWithStatusCode(_0x20e7cf,_0x17e086){_0x17e086=_0x17e086||0xcc;return function(_0x1d7c8c){if(_0x1d7c8c){return _0x20e7cf[_0xcd8a('0x19')](_0x17e086);}return _0x20e7cf[_0xcd8a('0x1a')](_0x17e086)['end']();};}function respondWithResult(_0x3eeab3,_0x1b5fe6){_0x1b5fe6=_0x1b5fe6||0xc8;return function(_0x5c118f){if(_0x5c118f){return _0x3eeab3[_0xcd8a('0x1a')](_0x1b5fe6)[_0xcd8a('0x1b')](_0x5c118f);}};}function respondWithFilteredResult(_0x5cc7ed,_0x278f2e){return function(_0xc913d4){if(_0xc913d4){var _0x2395dd=typeof _0x278f2e[_0xcd8a('0x1c')]==='undefined'&&typeof _0x278f2e[_0xcd8a('0x1d')]===_0xcd8a('0x1e');var _0x2dd17c=_0xc913d4[_0xcd8a('0x1f')];var _0x2f001f=_0x2395dd?0x0:_0x278f2e[_0xcd8a('0x1c')];var _0x1b5645=_0x2395dd?_0xc913d4[_0xcd8a('0x1f')]:_0x278f2e['offset']+_0x278f2e[_0xcd8a('0x1d')];var _0x1ff623;if(_0x1b5645>=_0x2dd17c){_0x1b5645=_0x2dd17c;_0x1ff623=0xc8;}else{_0x1ff623=0xce;}_0x5cc7ed[_0xcd8a('0x1a')](_0x1ff623);return _0x5cc7ed[_0xcd8a('0x20')]('Content-Range',_0x2f001f+'-'+_0x1b5645+'/'+_0x2dd17c)[_0xcd8a('0x1b')](_0xc913d4);}return null;};}function patchUpdates(_0x96b094){return function(_0x3e4624){try{jsonpatch[_0xcd8a('0x21')](_0x3e4624,_0x96b094,!![]);}catch(_0x4844c6){return BPromise[_0xcd8a('0x22')](_0x4844c6);}return _0x3e4624[_0xcd8a('0x23')]();};}function saveUpdates(_0xb7238a,_0x1e252e){return function(_0x438fac){if(_0x438fac){return _0x438fac[_0xcd8a('0x24')](_0xb7238a)[_0xcd8a('0x25')](function(_0x3a130e){return _0x3a130e;});}return null;};}function removeEntity(_0x5f2fc9,_0x3239ec){return function(_0x1cbc08){if(_0x1cbc08){return _0x1cbc08[_0xcd8a('0x26')]()[_0xcd8a('0x25')](function(){var _0x7426f3=_0x1cbc08[_0xcd8a('0x27')]({'plain':!![]});var _0x37ed78=_0xcd8a('0x28');return db['UserProfileResource'][_0xcd8a('0x26')]({'where':{'type':_0x37ed78,'resourceId':_0x7426f3['id']}})['then'](function(){return _0x1cbc08;});})['then'](function(){_0x5f2fc9[_0xcd8a('0x1a')](0xcc)['end']();});}};}function handleEntityNotFound(_0x1b00f7,_0x3f93dd){return function(_0x195b2c){if(!_0x195b2c){_0x1b00f7[_0xcd8a('0x19')](0x194);}return _0x195b2c;};}function handleError(_0xc6496b,_0x59a650){_0x59a650=_0x59a650||0x1f4;return function(_0x15648e){logger[_0xcd8a('0x29')](_0x15648e[_0xcd8a('0x2a')]);if(_0x15648e['name']){delete _0x15648e['name'];}_0xc6496b['status'](_0x59a650)[_0xcd8a('0x2b')](_0x15648e);};}exports[_0xcd8a('0x2c')]=function(_0x317c5b,_0x157521){var _0x15b103={},_0x5ca45e={},_0x101a1c={'count':0x0,'rows':[]};var _0x32c2d5=_['map'](db[_0xcd8a('0x2d')][_0xcd8a('0x2e')],function(_0x2e6986){return{'name':_0x2e6986[_0xcd8a('0x2f')],'type':_0x2e6986[_0xcd8a('0x30')]['key']};});_0x5ca45e[_0xcd8a('0x31')]=_[_0xcd8a('0x32')](_0x32c2d5,_0xcd8a('0x33'));_0x5ca45e[_0xcd8a('0x34')]=_[_0xcd8a('0x35')](_0x317c5b['query']);_0x5ca45e['filters']=_[_0xcd8a('0x36')](_0x5ca45e[_0xcd8a('0x31')],_0x5ca45e[_0xcd8a('0x34')]);_0x15b103['attributes']=_[_0xcd8a('0x36')](_0x5ca45e[_0xcd8a('0x31')],qs[_0xcd8a('0x37')](_0x317c5b[_0xcd8a('0x34')][_0xcd8a('0x37')]));_0x15b103[_0xcd8a('0x38')]=_0x15b103[_0xcd8a('0x38')]['length']?_0x15b103[_0xcd8a('0x38')]:_0x5ca45e['model'];if(!_0x317c5b['query'][_0xcd8a('0x39')](_0xcd8a('0x3a'))){_0x15b103[_0xcd8a('0x1d')]=qs[_0xcd8a('0x1d')](_0x317c5b[_0xcd8a('0x34')][_0xcd8a('0x1d')]);_0x15b103['offset']=qs[_0xcd8a('0x1c')](_0x317c5b[_0xcd8a('0x34')][_0xcd8a('0x1c')]);}_0x15b103['order']=qs[_0xcd8a('0x3b')](_0x317c5b['query'][_0xcd8a('0x3b')]);_0x15b103[_0xcd8a('0x3c')]=qs[_0xcd8a('0x3d')](_[_0xcd8a('0x3e')](_0x317c5b[_0xcd8a('0x34')],_0x5ca45e[_0xcd8a('0x3d')]),_0x32c2d5);if(_0x317c5b['query'][_0xcd8a('0x3f')]){_0x15b103['where']=_[_0xcd8a('0x40')](_0x15b103[_0xcd8a('0x3c')],{'$or':_[_0xcd8a('0x32')](_0x32c2d5,function(_0x246015){if(_0x246015[_0xcd8a('0x30')]!==_0xcd8a('0x41')){var _0x230662={};_0x230662[_0x246015[_0xcd8a('0x33')]]={'$like':'%'+_0x317c5b[_0xcd8a('0x34')][_0xcd8a('0x3f')]+'%'};return _0x230662;}})});}_0x15b103=_[_0xcd8a('0x40')]({},_0x15b103,_0x317c5b[_0xcd8a('0x42')]);var _0x517831={'where':_0x15b103[_0xcd8a('0x3c')]};return db['AnalyticCustomReport'][_0xcd8a('0x1f')](_0x517831)[_0xcd8a('0x25')](function(_0x3d5eef){_0x101a1c[_0xcd8a('0x1f')]=_0x3d5eef;if(_0x317c5b[_0xcd8a('0x34')][_0xcd8a('0x43')]){_0x15b103[_0xcd8a('0x44')]=[{'all':!![]}];}return db[_0xcd8a('0x2d')][_0xcd8a('0x45')](_0x15b103);})[_0xcd8a('0x25')](function(_0x4cceef){_0x101a1c[_0xcd8a('0x46')]=_0x4cceef;return _0x101a1c;})['then'](respondWithFilteredResult(_0x157521,_0x15b103))[_0xcd8a('0x47')](handleError(_0x157521,null));};exports['show']=function(_0x3ed899,_0x3f9a1e){var _0x3ed975={'raw':![],'where':{'id':_0x3ed899[_0xcd8a('0x48')]['id']}},_0x295be6={};_0x295be6['model']=_[_0xcd8a('0x35')](db[_0xcd8a('0x2d')][_0xcd8a('0x2e')]);_0x295be6[_0xcd8a('0x34')]=_[_0xcd8a('0x35')](_0x3ed899[_0xcd8a('0x34')]);_0x295be6[_0xcd8a('0x3d')]=_[_0xcd8a('0x36')](_0x295be6[_0xcd8a('0x31')],_0x295be6[_0xcd8a('0x34')]);_0x3ed975[_0xcd8a('0x38')]=_[_0xcd8a('0x36')](_0x295be6[_0xcd8a('0x31')],qs['fields'](_0x3ed899[_0xcd8a('0x34')][_0xcd8a('0x37')]));_0x3ed975['attributes']=_0x3ed975['attributes'][_0xcd8a('0x49')]?_0x3ed975[_0xcd8a('0x38')]:_0x295be6[_0xcd8a('0x31')];if(_0x3ed899[_0xcd8a('0x34')][_0xcd8a('0x43')]){_0x3ed975['include']=[{'all':!![]}];}_0x3ed975=_[_0xcd8a('0x40')]({},_0x3ed975,_0x3ed899[_0xcd8a('0x42')]);return db[_0xcd8a('0x2d')][_0xcd8a('0x4a')](_0x3ed975)[_0xcd8a('0x25')](handleEntityNotFound(_0x3f9a1e,null))[_0xcd8a('0x25')](respondWithResult(_0x3f9a1e,null))['catch'](handleError(_0x3f9a1e,null));};exports[_0xcd8a('0x4b')]=function(_0x2ee260,_0x594e90){return db[_0xcd8a('0x2d')][_0xcd8a('0x4b')](_0x2ee260[_0xcd8a('0x4c')],{})[_0xcd8a('0x25')](function(_0x353c7d){var _0x123d53=_0x2ee260[_0xcd8a('0x4d')][_0xcd8a('0x27')]({'plain':!![]});if(!_0x123d53)throw new Error(_0xcd8a('0x4e'));if(_0x123d53[_0xcd8a('0x4f')]==='user'){var _0x1e67ef=_0x353c7d[_0xcd8a('0x27')]({'plain':!![]});var _0x513da6=_0xcd8a('0x50');return db['UserProfileSection'][_0xcd8a('0x4a')]({'where':{'name':_0x513da6,'userProfileId':_0x123d53['userProfileId']},'raw':!![]})[_0xcd8a('0x25')](function(_0x555e15){if(_0x555e15&&_0x555e15[_0xcd8a('0x51')]===0x0){return db['UserProfileResource'][_0xcd8a('0x4b')]({'name':_0x1e67ef[_0xcd8a('0x33')],'resourceId':_0x1e67ef['id'],'type':_0xcd8a('0x28'),'sectionId':_0x555e15['id']},{})[_0xcd8a('0x25')](function(){return _0x353c7d;});}else{return _0x353c7d;}})[_0xcd8a('0x47')](function(_0x758ac7){logger['error'](_0xcd8a('0x52'),_0x758ac7);throw _0x758ac7;});}return _0x353c7d;})[_0xcd8a('0x25')](respondWithResult(_0x594e90,0xc9))[_0xcd8a('0x47')](handleError(_0x594e90,null));};exports['update']=function(_0x3a7f30,_0x3e0451){if(_0x3a7f30[_0xcd8a('0x4c')]['id']){delete _0x3a7f30['body']['id'];}return db[_0xcd8a('0x2d')][_0xcd8a('0x4a')]({'where':{'id':_0x3a7f30['params']['id']}})[_0xcd8a('0x25')](handleEntityNotFound(_0x3e0451,null))[_0xcd8a('0x25')](saveUpdates(_0x3a7f30[_0xcd8a('0x4c')],null))[_0xcd8a('0x25')](respondWithResult(_0x3e0451,null))['catch'](handleError(_0x3e0451,null));};exports[_0xcd8a('0x26')]=function(_0x4b7a41,_0x566f9b){return db[_0xcd8a('0x2d')]['find']({'where':{'id':_0x4b7a41[_0xcd8a('0x48')]['id']}})[_0xcd8a('0x25')](handleEntityNotFound(_0x566f9b,null))['then'](removeEntity(_0x566f9b,null))[_0xcd8a('0x47')](handleError(_0x566f9b,null));};exports[_0xcd8a('0x53')]=function(_0x24565e,_0x1884f7){var _0x18045b=0xa;var _0x2c3ee4=[_0xcd8a('0x54'),_0xcd8a('0x55'),_0xcd8a('0x56'),_0xcd8a('0x57')];var _0x378a88={'SUM':_0xcd8a('0x58'),'COUNT':_0xcd8a('0x59'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0xcd8a('0x5a'),'MIN':_0xcd8a('0x5b'),'AVG':'AVG(%s)','GROUP_CONCAT':_0xcd8a('0x5c'),'GROUP_CONCAT ASC':_0xcd8a('0x5d'),'GROUP_CONCAT DESC':_0xcd8a('0x5e')};var _0x4d2460={'SEC_TO_TIME':_0xcd8a('0x5f'),'DATE':_0xcd8a('0x60'),'HOUR':_0xcd8a('0x61'),'ROUND':_0xcd8a('0x62'),'UNIX_TIMESTAMP':_0xcd8a('0x63')};var _0x4529c0=function(_0x17f48d){return!_[_0xcd8a('0x64')]([_0xcd8a('0x65'),_0xcd8a('0x66'),_0xcd8a('0x67'),_0xcd8a('0x68')],_0x17f48d);};var _0x565f23=function(_0x41c0b1){if(!_0x41c0b1||!_0x41c0b1[_0xcd8a('0x69')][_0xcd8a('0x49')]){return'';}for(var _0x185a52='(',_0xd2256=0x0;_0xd2256<_0x41c0b1[_0xcd8a('0x69')][_0xcd8a('0x49')];_0xd2256+=0x1){_0xd2256>0x0&&(_0x185a52+='\x20'+_0x41c0b1['operator']+'\x20');_0x185a52+=_0x41c0b1[_0xcd8a('0x69')][_0xd2256][_0xcd8a('0x6a')]?_0x565f23(_0x41c0b1[_0xcd8a('0x69')][_0xd2256][_0xcd8a('0x6a')]):_0x41c0b1[_0xcd8a('0x69')][_0xd2256][_0xcd8a('0x6b')]+'\x20'+_0x41c0b1[_0xcd8a('0x69')][_0xd2256]['condition']+(_0x4529c0(_0x41c0b1[_0xcd8a('0x69')][_0xd2256][_0xcd8a('0x6c')])?'\x20'+_0x41c0b1[_0xcd8a('0x69')][_0xd2256][_0xcd8a('0x6d')]:'');}return _0x185a52+')';};var _0x4e5503={'where':{'id':_0x24565e['params']['id']}},_0x8fcd6c,_0x4bd3f4,_0x581862,_0x55755b,_0x51ab3a;_0x4e5503=_[_0xcd8a('0x40')]({},_0x4e5503,_0x24565e[_0xcd8a('0x42')]);return db['AnalyticCustomReport']['find'](_0x4e5503)[_0xcd8a('0x25')](function(_0x2f47f7){if(_0x2f47f7){_0x8fcd6c=_0x2f47f7;return _0x2f47f7[_0xcd8a('0x6e')]();}return null;})[_0xcd8a('0x25')](function(_0x4575bb){if(_0x4575bb){if(!_0x4575bb[_0xcd8a('0x49')]){throw new db['Sequelize'][(_0xcd8a('0x6f'))](_0xcd8a('0x70'),0x193);}_0x4bd3f4=_0x4575bb;return db[_0xcd8a('0x71')][_0xcd8a('0x45')]({'raw':!![]});}return null;})[_0xcd8a('0x25')](function(_0x1f2743){if(_0x1f2743){_0x581862=_[_0xcd8a('0x72')](_0x1f2743,'id');var _0xcff393;var _0x16a8ac=squel[_0xcd8a('0x73')]();_0x16a8ac[_0xcd8a('0x74')](_0x8fcd6c[_0xcd8a('0x75')]);for(var _0x4e6963=0x0;_0x4e6963<_0x4bd3f4['length'];_0x4e6963+=0x1){_0xcff393=_0x4bd3f4[_0x4e6963]['MetricId']?_0x581862[_0x4bd3f4[_0x4e6963][_0xcd8a('0x76')]][_0xcd8a('0x77')]:_0x4bd3f4[_0x4e6963]['field'];_0xcff393=_0x4bd3f4[_0x4e6963]['function']?_[_0xcd8a('0x78')](_0x378a88[_0x4bd3f4[_0x4e6963]['function']],'%s',_0xcff393):_0xcff393;_0xcff393=_0x4bd3f4[_0x4e6963][_0xcd8a('0x79')]?_[_0xcd8a('0x78')](_0x4d2460[_0x4bd3f4[_0x4e6963][_0xcd8a('0x79')]],'%s',_0xcff393):_0xcff393;if(_0x4bd3f4[_0x4e6963][_0xcd8a('0x7a')]){_0x16a8ac[_0xcd8a('0x6a')](_0xcff393);}_0x4bd3f4[_0x4e6963][_0xcd8a('0x7b')]&&_0x16a8ac[_0xcd8a('0x7c')](_0xcff393,_0x4bd3f4[_0x4e6963][_0xcd8a('0x7b')]===_0xcd8a('0x7d')?![]:!![]);_0x16a8ac['field'](_0xcff393,_0x4bd3f4[_0x4e6963]['alias']||_0xcff393);}if(_0x8fcd6c[_0xcd8a('0x7e')]){_0x8fcd6c[_0xcd8a('0x7e')]=JSON['parse'](_0x8fcd6c['joins']);for(var _0x3333b8=0x0;_0x3333b8<_0x8fcd6c[_0xcd8a('0x7e')][_0xcd8a('0x49')];_0x3333b8+=0x1){if(_0x8fcd6c[_0xcd8a('0x7e')][_0x3333b8][_0xcd8a('0x30')]&&_[_0xcd8a('0x64')](_0x2c3ee4,_0x8fcd6c[_0xcd8a('0x7e')][_0x3333b8][_0xcd8a('0x30')])&&_0x8fcd6c[_0xcd8a('0x7e')][_0x3333b8][_0xcd8a('0x7f')]&&_0x8fcd6c['joins'][_0x3333b8][_0xcd8a('0x80')]&&_0x8fcd6c[_0xcd8a('0x7e')][_0x3333b8]['foreignKey']){_0x16a8ac[_0x8fcd6c[_0xcd8a('0x7e')][_0x3333b8][_0xcd8a('0x30')]](_0x8fcd6c[_0xcd8a('0x7e')][_0x3333b8][_0xcd8a('0x80')],null,util['format']('%s.%s\x20=\x20%s.%s',_0x8fcd6c[_0xcd8a('0x75')],_0x8fcd6c[_0xcd8a('0x7e')][_0x3333b8][_0xcd8a('0x7f')],_0x8fcd6c[_0xcd8a('0x7e')][_0x3333b8][_0xcd8a('0x80')],_0x8fcd6c[_0xcd8a('0x7e')][_0x3333b8][_0xcd8a('0x81')]));}}}if(_0x8fcd6c[_0xcd8a('0x82')]){_0x8fcd6c[_0xcd8a('0x82')]=JSON['parse'](_0x8fcd6c[_0xcd8a('0x82')]);_0x16a8ac['where'](_0x565f23(_0x8fcd6c[_0xcd8a('0x82')][_0xcd8a('0x6a')]));}_0x51ab3a=_0x16a8ac[_0xcd8a('0x83')]();_0x16a8ac[_0xcd8a('0x1d')](_0x18045b);_0x16a8ac[_0xcd8a('0x1c')](0x0);logger[_0xcd8a('0x84')]('Limited\x20Query:',_0x16a8ac['toString']());return dbH['sequelize'][_0xcd8a('0x34')](_0x16a8ac[_0xcd8a('0x85')](),{'type':dbH[_0xcd8a('0x86')][_0xcd8a('0x87')]['SELECT']});}})[_0xcd8a('0x25')](respondWithResult(_0x1884f7,null))[_0xcd8a('0x47')](handleError(_0x1884f7,null));};function runReport(_0x31eec1,_0x51b1c9,_0x376402){var _0x39c79d=_0x51b1c9[_0xcd8a('0x33')];var _0x2632cc=0xa;var _0x1a6fde=[_0xcd8a('0x54'),_0xcd8a('0x55'),_0xcd8a('0x56'),'cross_join'];var _0x2d3b7d={'SUM':_0xcd8a('0x58'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0xcd8a('0x88'),'MAX':_0xcd8a('0x5a'),'MIN':_0xcd8a('0x5b'),'AVG':_0xcd8a('0x89'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x1281aa={'SEC_TO_TIME':_0xcd8a('0x5f'),'DATE':'DATE(%s)','HOUR':_0xcd8a('0x61'),'ROUND':_0xcd8a('0x62'),'UNIX_TIMESTAMP':_0xcd8a('0x63')};var _0x46a54c=function(_0x14a2d8){return!_[_0xcd8a('0x64')](['IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY'],_0x14a2d8);};var _0x92a828=function(_0x1d55ff){if(!_0x1d55ff||!_0x1d55ff['rules'][_0xcd8a('0x49')]){return'';}for(var _0x18deda='(',_0x418ba8=0x0;_0x418ba8<_0x1d55ff['rules']['length'];_0x418ba8+=0x1){_0x418ba8>0x0&&(_0x18deda+='\x20'+_0x1d55ff['operator']+'\x20');_0x18deda+=_0x1d55ff[_0xcd8a('0x69')][_0x418ba8][_0xcd8a('0x6a')]?_0x92a828(_0x1d55ff[_0xcd8a('0x69')][_0x418ba8][_0xcd8a('0x6a')]):_0x1d55ff[_0xcd8a('0x69')][_0x418ba8][_0xcd8a('0x6b')]+'\x20'+_0x1d55ff[_0xcd8a('0x69')][_0x418ba8][_0xcd8a('0x6c')]+(_0x46a54c(_0x1d55ff[_0xcd8a('0x69')][_0x418ba8][_0xcd8a('0x6c')])?'\x20'+_0x1d55ff['rules'][_0x418ba8]['value']:'');}return _0x18deda+')';};var _0x11d2a1={'where':{'id':_0x31eec1['id']}},_0x58c8c7,_0x57d06f,_0xcaebb5,_0x4bbac6,_0x2673db;_0x11d2a1=_[_0xcd8a('0x40')]({},_0x11d2a1,_0x376402);return db[_0xcd8a('0x2d')]['find'](_0x11d2a1)[_0xcd8a('0x25')](function(_0x3d758f){if(_0x3d758f){_0x58c8c7=_0x3d758f;return _0x3d758f[_0xcd8a('0x6e')]();}return null;})[_0xcd8a('0x25')](function(_0x4cd9e7){if(_0x4cd9e7){if(!_0x4cd9e7[_0xcd8a('0x49')]){throw new db[(_0xcd8a('0x8a'))][(_0xcd8a('0x6f'))](_0xcd8a('0x70'),0x193);}_0x57d06f=_0x4cd9e7;return db[_0xcd8a('0x71')][_0xcd8a('0x45')]({'raw':!![]});}return null;})['then'](function(_0x11ed32){if(_0x11ed32){_0xcaebb5=_[_0xcd8a('0x72')](_0x11ed32,'id');var _0x542ff7;var _0x48de67=squel[_0xcd8a('0x73')]();_0x48de67[_0xcd8a('0x74')](_0x58c8c7[_0xcd8a('0x75')]);for(var _0x1b5611=0x0;_0x1b5611<_0x57d06f[_0xcd8a('0x49')];_0x1b5611+=0x1){_0x542ff7=_0x57d06f[_0x1b5611][_0xcd8a('0x76')]?_0xcaebb5[_0x57d06f[_0x1b5611]['MetricId']][_0xcd8a('0x77')]:_0x57d06f[_0x1b5611][_0xcd8a('0x6b')];_0x542ff7=_0x57d06f[_0x1b5611]['function']?_[_0xcd8a('0x78')](_0x2d3b7d[_0x57d06f[_0x1b5611][_0xcd8a('0x8b')]],'%s',_0x542ff7):_0x542ff7;_0x542ff7=_0x57d06f[_0x1b5611][_0xcd8a('0x79')]?_[_0xcd8a('0x78')](_0x1281aa[_0x57d06f[_0x1b5611][_0xcd8a('0x79')]],'%s',_0x542ff7):_0x542ff7;if(_0x57d06f[_0x1b5611][_0xcd8a('0x7a')]){_0x48de67['group'](_0x542ff7);}_0x57d06f[_0x1b5611][_0xcd8a('0x7b')]&&_0x48de67['order'](_0x542ff7,_0x57d06f[_0x1b5611]['orderBy']===_0xcd8a('0x7d')?![]:!![]);_0x48de67[_0xcd8a('0x6b')](_0x542ff7,_0x57d06f[_0x1b5611][_0xcd8a('0x8c')]||_0x542ff7);}if(_0x58c8c7['joins']){_0x58c8c7['joins']=JSON[_0xcd8a('0x8d')](_0x58c8c7[_0xcd8a('0x7e')]);for(var _0x347858=0x0;_0x347858<_0x58c8c7[_0xcd8a('0x7e')][_0xcd8a('0x49')];_0x347858+=0x1){if(_0x58c8c7['joins'][_0x347858][_0xcd8a('0x30')]&&_[_0xcd8a('0x64')](_0x1a6fde,_0x58c8c7[_0xcd8a('0x7e')][_0x347858][_0xcd8a('0x30')])&&_0x58c8c7[_0xcd8a('0x7e')][_0x347858][_0xcd8a('0x7f')]&&_0x58c8c7[_0xcd8a('0x7e')][_0x347858][_0xcd8a('0x80')]&&_0x58c8c7['joins'][_0x347858][_0xcd8a('0x81')]){_0x48de67[_0x58c8c7['joins'][_0x347858][_0xcd8a('0x30')]](_0x58c8c7[_0xcd8a('0x7e')][_0x347858][_0xcd8a('0x80')],null,util[_0xcd8a('0x79')](_0xcd8a('0x8e'),_0x58c8c7[_0xcd8a('0x75')],_0x58c8c7[_0xcd8a('0x7e')][_0x347858]['parentKey'],_0x58c8c7['joins'][_0x347858]['foreignTable'],_0x58c8c7[_0xcd8a('0x7e')][_0x347858]['foreignKey']));}}}if(_0x58c8c7[_0xcd8a('0x82')]){_0x58c8c7['conditions']=JSON[_0xcd8a('0x8d')](_0x58c8c7[_0xcd8a('0x82')]);_0x48de67[_0xcd8a('0x3c')](_0x92a828(_0x58c8c7[_0xcd8a('0x82')][_0xcd8a('0x6a')]));}_0x2673db=_0x48de67[_0xcd8a('0x83')]();_0x48de67['limit'](_0x2632cc);_0x48de67['offset'](0x0);return;}})[_0xcd8a('0x25')](function(){if(_0x51b1c9['output']==='web'){return null;}var _0x3745ed=_[_0xcd8a('0x40')](_0x51b1c9,{'name':_0x51b1c9[_0xcd8a('0x8f')]||_0x51b1c9[_0xcd8a('0x33')]||_0x58c8c7['name'],'basename':_0x39c79d,'savename':util['format'](_0xcd8a('0x90'),_0x51b1c9['name']||_0x58c8c7[_0xcd8a('0x33')],require(_0xcd8a('0x91'))[_0xcd8a('0x92')](0x4),_0x51b1c9[_0xcd8a('0x93')]||_0xcd8a('0x94')),'reportId':_0x58c8c7['id'],'reportType':_0xcd8a('0x95')});return db[_0xcd8a('0x96')]['create'](_0x3745ed,{'raw':!![]});})[_0xcd8a('0x25')](function(_0x298b36){if(_0x58c8c7['table']===_0xcd8a('0x97')){_0x2673db[_0xcd8a('0x3c')](_0x58c8c7['table']+_0xcd8a('0x98'),_0x51b1c9['startDate'],_0x51b1c9[_0xcd8a('0x99')]);}else{_0x2673db[_0xcd8a('0x3c')](_0x58c8c7[_0xcd8a('0x75')]+_0xcd8a('0x9a'),_0x51b1c9[_0xcd8a('0x9b')],_0x51b1c9[_0xcd8a('0x99')]);}if(_0x298b36){logger[_0xcd8a('0x9c')](_0xcd8a('0x9d'),_0x2673db[_0xcd8a('0x85')]());require(_0xcd8a('0x9e'))[_0xcd8a('0x9f')](path[_0xcd8a('0x54')](__dirname,'../../components/export/',_0x298b36['output']),[_0x298b36['id'],_0x2673db['toString'](),path[_0xcd8a('0x54')](__dirname,_0xcd8a('0xa0'),_0x298b36[_0xcd8a('0xa1')]),_0x39c79d]);return _0x298b36;}else{var _0x3c3838=squel[_0xcd8a('0x73')]();_0x3c3838[_0xcd8a('0x74')]('('+_0x2673db[_0xcd8a('0x85')]()+')',_0xcd8a('0xa2'));_0x3c3838[_0xcd8a('0x6b')]('COUNT(*)',_0xcd8a('0x1f'));_0x2673db[_0xcd8a('0x1d')](_0x51b1c9[_0xcd8a('0x1d')]||_0x2632cc);_0x2673db[_0xcd8a('0x1c')](_0x51b1c9['offset']||0x0);return dbH[_0xcd8a('0x86')]['query'](_0x3c3838[_0xcd8a('0x85')](),{'type':dbH[_0xcd8a('0x86')][_0xcd8a('0x87')][_0xcd8a('0xa3')]})[_0xcd8a('0x25')](function(_0x1765e1){if(!_0x1765e1[_0xcd8a('0x49')]){_0x4bbac6=0x0;}else{_0x4bbac6=_0x1765e1[0x0][_0xcd8a('0x1f')]||0x0;}return dbH[_0xcd8a('0x86')][_0xcd8a('0x34')](_0x2673db[_0xcd8a('0x85')](),{'type':dbH[_0xcd8a('0x86')]['QueryTypes'][_0xcd8a('0xa3')]});})[_0xcd8a('0x25')](function(_0x39dbf5){return{'rows':_0x39dbf5||[],'count':_0x4bbac6};});}});}exports['run']=function(_0x5e37a7,_0x5638b7){return runReport(_0x5e37a7[_0xcd8a('0x48')],_0x5e37a7['query'],_0x5e37a7[_0xcd8a('0x42')])[_0xcd8a('0x25')](respondWithResult(_0x5638b7,null))['catch'](handleError(_0x5638b7,null));};exports['runReport']=runReport;exports[_0xcd8a('0x34')]=function(_0x4f227e,_0x4f0103){var _0x5854aa=0xa;var _0x20566f=['join','left_join',_0xcd8a('0x56'),_0xcd8a('0x57')];var _0x227944={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0xcd8a('0x5a'),'MIN':_0xcd8a('0x5b'),'AVG':_0xcd8a('0x89'),'GROUP_CONCAT':_0xcd8a('0x5c'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x5383a1={'SEC_TO_TIME':_0xcd8a('0x5f'),'DATE':'DATE(%s)','HOUR':_0xcd8a('0x61'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0xcd8a('0x63')};var _0x4d778c=function(_0x109dff){return!_[_0xcd8a('0x64')]([_0xcd8a('0x65'),_0xcd8a('0x66'),_0xcd8a('0x67'),'IS\x20NOT\x20EMPTY'],_0x109dff);};var _0x291040=function(_0x5189ca){if(!_0x5189ca||!_0x5189ca[_0xcd8a('0x69')][_0xcd8a('0x49')]){return'';}for(var _0x11154b='(',_0x46ec53=0x0;_0x46ec53<_0x5189ca[_0xcd8a('0x69')][_0xcd8a('0x49')];_0x46ec53+=0x1){_0x46ec53>0x0&&(_0x11154b+='\x20'+_0x5189ca[_0xcd8a('0xa4')]+'\x20');_0x11154b+=_0x5189ca[_0xcd8a('0x69')][_0x46ec53][_0xcd8a('0x6a')]?_0x291040(_0x5189ca[_0xcd8a('0x69')][_0x46ec53]['group']):_0x5189ca['rules'][_0x46ec53][_0xcd8a('0x6b')]+'\x20'+_0x5189ca[_0xcd8a('0x69')][_0x46ec53][_0xcd8a('0x6c')]+(_0x4d778c(_0x5189ca[_0xcd8a('0x69')][_0x46ec53]['condition'])?'\x20'+_0x5189ca[_0xcd8a('0x69')][_0x46ec53][_0xcd8a('0x6d')]:'');}return _0x11154b+')';};var _0x43fd54={'where':{'id':_0x4f227e[_0xcd8a('0x48')]['id']}},_0x24e4e9,_0x37d88b,_0x3f31f4,_0x355226,_0x536e49;_0x43fd54=_[_0xcd8a('0x40')]({},_0x43fd54,_0x4f227e[_0xcd8a('0x42')]);return db[_0xcd8a('0x2d')][_0xcd8a('0x4a')](_0x43fd54)['then'](function(_0x3866dc){if(_0x3866dc){_0x24e4e9=_0x3866dc;return _0x3866dc[_0xcd8a('0x6e')]();}return null;})[_0xcd8a('0x25')](function(_0x3936ff){if(_0x3936ff){if(!_0x3936ff[_0xcd8a('0x49')]){throw new db[(_0xcd8a('0x8a'))][(_0xcd8a('0x6f'))](_0xcd8a('0x70'),0x193);}_0x37d88b=_0x3936ff;return db['AnalyticMetric']['findAll']({'raw':!![]});}return null;})[_0xcd8a('0x25')](function(_0x52c79d){if(_0x52c79d){_0x3f31f4=_['keyBy'](_0x52c79d,'id');var _0x1e34b7;var _0x56bf4e=squel[_0xcd8a('0x73')]();_0x56bf4e[_0xcd8a('0x74')](_0x24e4e9[_0xcd8a('0x75')]);for(var _0x33968d=0x0;_0x33968d<_0x37d88b[_0xcd8a('0x49')];_0x33968d+=0x1){_0x1e34b7=_0x37d88b[_0x33968d]['MetricId']?_0x3f31f4[_0x37d88b[_0x33968d][_0xcd8a('0x76')]]['metric']:_0x37d88b[_0x33968d][_0xcd8a('0x6b')];_0x1e34b7=_0x37d88b[_0x33968d]['function']?_[_0xcd8a('0x78')](_0x227944[_0x37d88b[_0x33968d]['function']],'%s',_0x1e34b7):_0x1e34b7;_0x1e34b7=_0x37d88b[_0x33968d][_0xcd8a('0x79')]?_[_0xcd8a('0x78')](_0x5383a1[_0x37d88b[_0x33968d][_0xcd8a('0x79')]],'%s',_0x1e34b7):_0x1e34b7;if(_0x37d88b[_0x33968d][_0xcd8a('0x7a')]){_0x56bf4e[_0xcd8a('0x6a')](_0x1e34b7);}_0x37d88b[_0x33968d]['orderBy']&&_0x56bf4e[_0xcd8a('0x7c')](_0x1e34b7,_0x37d88b[_0x33968d][_0xcd8a('0x7b')]===_0xcd8a('0x7d')?![]:!![]);_0x56bf4e[_0xcd8a('0x6b')](_0x1e34b7,_0x37d88b[_0x33968d][_0xcd8a('0x8c')]||_0x1e34b7);}if(_0x24e4e9[_0xcd8a('0x7e')]){_0x24e4e9[_0xcd8a('0x7e')]=JSON['parse'](_0x24e4e9[_0xcd8a('0x7e')]);for(var _0xd20e76=0x0;_0xd20e76<_0x24e4e9[_0xcd8a('0x7e')][_0xcd8a('0x49')];_0xd20e76+=0x1){if(_0x24e4e9[_0xcd8a('0x7e')][_0xd20e76][_0xcd8a('0x30')]&&_[_0xcd8a('0x64')](_0x20566f,_0x24e4e9['joins'][_0xd20e76][_0xcd8a('0x30')])&&_0x24e4e9['joins'][_0xd20e76][_0xcd8a('0x7f')]&&_0x24e4e9[_0xcd8a('0x7e')][_0xd20e76]['foreignTable']&&_0x24e4e9['joins'][_0xd20e76][_0xcd8a('0x81')]){_0x56bf4e[_0x24e4e9[_0xcd8a('0x7e')][_0xd20e76][_0xcd8a('0x30')]](_0x24e4e9[_0xcd8a('0x7e')][_0xd20e76][_0xcd8a('0x80')],null,util['format'](_0xcd8a('0x8e'),_0x24e4e9[_0xcd8a('0x75')],_0x24e4e9[_0xcd8a('0x7e')][_0xd20e76][_0xcd8a('0x7f')],_0x24e4e9[_0xcd8a('0x7e')][_0xd20e76]['foreignTable'],_0x24e4e9[_0xcd8a('0x7e')][_0xd20e76][_0xcd8a('0x81')]));}}}if(_0x24e4e9['conditions']){_0x24e4e9[_0xcd8a('0x82')]=JSON[_0xcd8a('0x8d')](_0x24e4e9[_0xcd8a('0x82')]);_0x56bf4e[_0xcd8a('0x3c')](_0x291040(_0x24e4e9['conditions']['group']));}_0x536e49=_0x56bf4e[_0xcd8a('0x83')]();_0x56bf4e['limit'](_0x5854aa);_0x56bf4e['offset'](0x0);logger[_0xcd8a('0x84')](_0xcd8a('0xa5'),_0x56bf4e['toString']());return dbH[_0xcd8a('0x86')][_0xcd8a('0x34')](_0x56bf4e[_0xcd8a('0x85')](),{'type':dbH[_0xcd8a('0x86')][_0xcd8a('0x87')][_0xcd8a('0xa3')]});}})[_0xcd8a('0x25')](function(){return{'sql':_0x536e49[_0xcd8a('0x85')]()};})[_0xcd8a('0x25')](respondWithResult(_0x4f0103,null))['catch'](handleError(_0x4f0103,null));};
\ No newline at end of file
+var _0x31a1=['debug','Limited\x20Query:','sequelize','left_join','GROUP_CONCAT(%s)','field','AnalyticMetric','DESC','alias','clone','output','web','fullPath','%s-%s.%s','randomstring','generate','csv','custom','AnalyticExtractedReport','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','Run\x20Query:','child_process','fork','../../components/export/','toString','../../files/reports','savename','countTable','QueryTypes','SELECT','run','AVG(%s)','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','fs-extra','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../mysqldb','sendStatus','end','status','offset','undefined','limit','count','set','Content-Range','json','apply','reject','update','then','destroy','get','CustomReports','UserProfileResource','name','send','index','map','AnalyticCustomReport','rawAttributes','type','key','query','keys','filters','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','where','filter','merge','VIRTUAL','includeAll','include','findAll','rows','catch','show','options','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','UserProfileSection','find','userProfileId','autoAssociation','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','params','preview','join','right_join','cross_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%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)','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','condition','value','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','keyBy','select','from','table','MetricId','metric','function','replace','format','groupBy','orderBy','order','joins','parse','includes','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','conditions'];(function(_0x42d829,_0x48c650){var _0x1607d7=function(_0x469f78){while(--_0x469f78){_0x42d829['push'](_0x42d829['shift']());}};_0x1607d7(++_0x48c650);}(_0x31a1,0xcf));var _0x131a=function(_0x45bf86,_0x75586e){_0x45bf86=_0x45bf86-0x0;var _0x1f02b7=_0x31a1[_0x45bf86];return _0x1f02b7;};'use strict';var emlformat=require(_0x131a('0x0'));var rimraf=require(_0x131a('0x1'));var zipdir=require(_0x131a('0x2'));var jsonpatch=require(_0x131a('0x3'));var rp=require(_0x131a('0x4'));var moment=require(_0x131a('0x5'));var BPromise=require(_0x131a('0x6'));var Mustache=require(_0x131a('0x7'));var util=require(_0x131a('0x8'));var path=require(_0x131a('0x9'));var sox=require('sox');var csv=require(_0x131a('0xa'));var ejs=require(_0x131a('0xb'));var fs=require('fs');var fs_extra=require(_0x131a('0xc'));var _=require('lodash');var squel=require('squel');var crypto=require(_0x131a('0xd'));var jsforce=require(_0x131a('0xe'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0x131a('0xf'));var Papa=require(_0x131a('0x10'));var Redis=require(_0x131a('0x11'));var authService=require(_0x131a('0x12'));var qs=require(_0x131a('0x13'));var as=require(_0x131a('0x14'));var hardwareService=require(_0x131a('0x15'));var logger=require(_0x131a('0x16'))(_0x131a('0x17'));var utils=require(_0x131a('0x18'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require(_0x131a('0x19'))['db'];var dbH=require(_0x131a('0x19'))['dbH'];function respondWithStatusCode(_0x57b46e,_0x329031){_0x329031=_0x329031||0xcc;return function(_0xc999cc){if(_0xc999cc){return _0x57b46e[_0x131a('0x1a')](_0x329031);}return _0x57b46e['status'](_0x329031)[_0x131a('0x1b')]();};}function respondWithResult(_0xc91bb0,_0x1ec8ac){_0x1ec8ac=_0x1ec8ac||0xc8;return function(_0x5d9753){if(_0x5d9753){return _0xc91bb0[_0x131a('0x1c')](_0x1ec8ac)['json'](_0x5d9753);}};}function respondWithFilteredResult(_0xe1bb71,_0xf8e306){return function(_0x1bbf4c){if(_0x1bbf4c){var _0x51d0bc=typeof _0xf8e306[_0x131a('0x1d')]===_0x131a('0x1e')&&typeof _0xf8e306[_0x131a('0x1f')]===_0x131a('0x1e');var _0x27c0dd=_0x1bbf4c[_0x131a('0x20')];var _0x34125c=_0x51d0bc?0x0:_0xf8e306[_0x131a('0x1d')];var _0x3473ab=_0x51d0bc?_0x1bbf4c['count']:_0xf8e306[_0x131a('0x1d')]+_0xf8e306['limit'];var _0x20d650;if(_0x3473ab>=_0x27c0dd){_0x3473ab=_0x27c0dd;_0x20d650=0xc8;}else{_0x20d650=0xce;}_0xe1bb71[_0x131a('0x1c')](_0x20d650);return _0xe1bb71[_0x131a('0x21')](_0x131a('0x22'),_0x34125c+'-'+_0x3473ab+'/'+_0x27c0dd)[_0x131a('0x23')](_0x1bbf4c);}return null;};}function patchUpdates(_0x1e11bc){return function(_0x789644){try{jsonpatch[_0x131a('0x24')](_0x789644,_0x1e11bc,!![]);}catch(_0x5bef99){return BPromise[_0x131a('0x25')](_0x5bef99);}return _0x789644['save']();};}function saveUpdates(_0x1a4533,_0x1b2fc9){return function(_0x1bcbd7){if(_0x1bcbd7){return _0x1bcbd7[_0x131a('0x26')](_0x1a4533)[_0x131a('0x27')](function(_0x47ebac){return _0x47ebac;});}return null;};}function removeEntity(_0x18f333,_0x3f7b39){return function(_0x505ea0){if(_0x505ea0){return _0x505ea0[_0x131a('0x28')]()[_0x131a('0x27')](function(){var _0x43d9e9=_0x505ea0[_0x131a('0x29')]({'plain':!![]});var _0x4034a2=_0x131a('0x2a');return db[_0x131a('0x2b')][_0x131a('0x28')]({'where':{'type':_0x4034a2,'resourceId':_0x43d9e9['id']}})[_0x131a('0x27')](function(){return _0x505ea0;});})[_0x131a('0x27')](function(){_0x18f333['status'](0xcc)[_0x131a('0x1b')]();});}};}function handleEntityNotFound(_0x56642a,_0x1fc5d1){return function(_0x3cffa6){if(!_0x3cffa6){_0x56642a['sendStatus'](0x194);}return _0x3cffa6;};}function handleError(_0x3e8a96,_0x42fe8b){_0x42fe8b=_0x42fe8b||0x1f4;return function(_0x4ae8d6){logger['error'](_0x4ae8d6['stack']);if(_0x4ae8d6[_0x131a('0x2c')]){delete _0x4ae8d6[_0x131a('0x2c')];}_0x3e8a96[_0x131a('0x1c')](_0x42fe8b)[_0x131a('0x2d')](_0x4ae8d6);};}exports[_0x131a('0x2e')]=function(_0x36aa0b,_0x58fde2){var _0x263d35={},_0x17ef80={},_0x589bbf={'count':0x0,'rows':[]};var _0x2b83fc=_[_0x131a('0x2f')](db[_0x131a('0x30')][_0x131a('0x31')],function(_0x3d896f){return{'name':_0x3d896f['fieldName'],'type':_0x3d896f[_0x131a('0x32')][_0x131a('0x33')]};});_0x17ef80['model']=_[_0x131a('0x2f')](_0x2b83fc,'name');_0x17ef80[_0x131a('0x34')]=_[_0x131a('0x35')](_0x36aa0b[_0x131a('0x34')]);_0x17ef80[_0x131a('0x36')]=_[_0x131a('0x37')](_0x17ef80[_0x131a('0x38')],_0x17ef80[_0x131a('0x34')]);_0x263d35[_0x131a('0x39')]=_['intersection'](_0x17ef80[_0x131a('0x38')],qs['fields'](_0x36aa0b[_0x131a('0x34')][_0x131a('0x3a')]));_0x263d35['attributes']=_0x263d35[_0x131a('0x39')][_0x131a('0x3b')]?_0x263d35[_0x131a('0x39')]:_0x17ef80[_0x131a('0x38')];if(!_0x36aa0b[_0x131a('0x34')][_0x131a('0x3c')](_0x131a('0x3d'))){_0x263d35[_0x131a('0x1f')]=qs[_0x131a('0x1f')](_0x36aa0b[_0x131a('0x34')][_0x131a('0x1f')]);_0x263d35['offset']=qs[_0x131a('0x1d')](_0x36aa0b[_0x131a('0x34')][_0x131a('0x1d')]);}_0x263d35['order']=qs['sort'](_0x36aa0b[_0x131a('0x34')]['sort']);_0x263d35[_0x131a('0x3e')]=qs['filters'](_['pick'](_0x36aa0b[_0x131a('0x34')],_0x17ef80[_0x131a('0x36')]),_0x2b83fc);if(_0x36aa0b[_0x131a('0x34')][_0x131a('0x3f')]){_0x263d35[_0x131a('0x3e')]=_[_0x131a('0x40')](_0x263d35[_0x131a('0x3e')],{'$or':_[_0x131a('0x2f')](_0x2b83fc,function(_0x5a54d){if(_0x5a54d[_0x131a('0x32')]!==_0x131a('0x41')){var _0x327250={};_0x327250[_0x5a54d[_0x131a('0x2c')]]={'$like':'%'+_0x36aa0b[_0x131a('0x34')][_0x131a('0x3f')]+'%'};return _0x327250;}})});}_0x263d35=_['merge']({},_0x263d35,_0x36aa0b['options']);var _0x98f8bd={'where':_0x263d35['where']};return db[_0x131a('0x30')][_0x131a('0x20')](_0x98f8bd)[_0x131a('0x27')](function(_0x2610e7){_0x589bbf[_0x131a('0x20')]=_0x2610e7;if(_0x36aa0b[_0x131a('0x34')][_0x131a('0x42')]){_0x263d35[_0x131a('0x43')]=[{'all':!![]}];}return db[_0x131a('0x30')][_0x131a('0x44')](_0x263d35);})[_0x131a('0x27')](function(_0x4b6edd){_0x589bbf[_0x131a('0x45')]=_0x4b6edd;return _0x589bbf;})[_0x131a('0x27')](respondWithFilteredResult(_0x58fde2,_0x263d35))[_0x131a('0x46')](handleError(_0x58fde2,null));};exports[_0x131a('0x47')]=function(_0x3f2590,_0x33474c){var _0x24297c={'raw':![],'where':{'id':_0x3f2590['params']['id']}},_0x3299b3={};_0x3299b3[_0x131a('0x38')]=_[_0x131a('0x35')](db[_0x131a('0x30')][_0x131a('0x31')]);_0x3299b3[_0x131a('0x34')]=_['keys'](_0x3f2590[_0x131a('0x34')]);_0x3299b3[_0x131a('0x36')]=_['intersection'](_0x3299b3[_0x131a('0x38')],_0x3299b3[_0x131a('0x34')]);_0x24297c[_0x131a('0x39')]=_[_0x131a('0x37')](_0x3299b3[_0x131a('0x38')],qs[_0x131a('0x3a')](_0x3f2590['query'][_0x131a('0x3a')]));_0x24297c[_0x131a('0x39')]=_0x24297c[_0x131a('0x39')][_0x131a('0x3b')]?_0x24297c[_0x131a('0x39')]:_0x3299b3[_0x131a('0x38')];if(_0x3f2590[_0x131a('0x34')][_0x131a('0x42')]){_0x24297c['include']=[{'all':!![]}];}_0x24297c=_[_0x131a('0x40')]({},_0x24297c,_0x3f2590[_0x131a('0x48')]);return db[_0x131a('0x30')]['find'](_0x24297c)[_0x131a('0x27')](handleEntityNotFound(_0x33474c,null))[_0x131a('0x27')](respondWithResult(_0x33474c,null))['catch'](handleError(_0x33474c,null));};exports[_0x131a('0x49')]=function(_0x54bbd2,_0x392942){return db['AnalyticCustomReport'][_0x131a('0x49')](_0x54bbd2['body'],{})[_0x131a('0x27')](function(_0x42e12d){var _0x459bca=_0x54bbd2[_0x131a('0x4a')][_0x131a('0x29')]({'plain':!![]});if(!_0x459bca)throw new Error(_0x131a('0x4b'));if(_0x459bca[_0x131a('0x4c')]===_0x131a('0x4a')){var _0x1b8d77=_0x42e12d[_0x131a('0x29')]({'plain':!![]});var _0xa6ed45=_0x131a('0x4d');return db[_0x131a('0x4e')][_0x131a('0x4f')]({'where':{'name':_0xa6ed45,'userProfileId':_0x459bca[_0x131a('0x50')]},'raw':!![]})[_0x131a('0x27')](function(_0x4fc31b){if(_0x4fc31b&&_0x4fc31b[_0x131a('0x51')]===0x0){return db[_0x131a('0x2b')][_0x131a('0x49')]({'name':_0x1b8d77[_0x131a('0x2c')],'resourceId':_0x1b8d77['id'],'type':_0x131a('0x2a'),'sectionId':_0x4fc31b['id']},{})['then'](function(){return _0x42e12d;});}else{return _0x42e12d;}})[_0x131a('0x46')](function(_0x57bd15){logger[_0x131a('0x52')](_0x131a('0x53'),_0x57bd15);throw _0x57bd15;});}return _0x42e12d;})[_0x131a('0x27')](respondWithResult(_0x392942,0xc9))['catch'](handleError(_0x392942,null));};exports[_0x131a('0x26')]=function(_0x44bdf3,_0x5305a0){if(_0x44bdf3[_0x131a('0x54')]['id']){delete _0x44bdf3['body']['id'];}return db['AnalyticCustomReport']['find']({'where':{'id':_0x44bdf3[_0x131a('0x55')]['id']}})[_0x131a('0x27')](handleEntityNotFound(_0x5305a0,null))[_0x131a('0x27')](saveUpdates(_0x44bdf3['body'],null))[_0x131a('0x27')](respondWithResult(_0x5305a0,null))[_0x131a('0x46')](handleError(_0x5305a0,null));};exports[_0x131a('0x28')]=function(_0x424bcb,_0x55fc0e){return db[_0x131a('0x30')][_0x131a('0x4f')]({'where':{'id':_0x424bcb[_0x131a('0x55')]['id']}})[_0x131a('0x27')](handleEntityNotFound(_0x55fc0e,null))[_0x131a('0x27')](removeEntity(_0x55fc0e,null))[_0x131a('0x46')](handleError(_0x55fc0e,null));};exports[_0x131a('0x56')]=function(_0x352e84,_0x513adf){var _0x3c6982=0xa;var _0x312e96=[_0x131a('0x57'),'left_join',_0x131a('0x58'),_0x131a('0x59')];var _0x2a9b61={'SUM':_0x131a('0x5a'),'COUNT':_0x131a('0x5b'),'COUNT DISTINCT':_0x131a('0x5c'),'MAX':_0x131a('0x5d'),'MIN':_0x131a('0x5e'),'AVG':'AVG(%s)','GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x131a('0x5f'),'GROUP_CONCAT DESC':_0x131a('0x60')};var _0x205b13={'SEC_TO_TIME':_0x131a('0x61'),'DATE':_0x131a('0x62'),'HOUR':_0x131a('0x63'),'ROUND':_0x131a('0x64'),'UNIX_TIMESTAMP':_0x131a('0x65')};var _0x26865f=function(_0x5a6a64){return!_['includes']([_0x131a('0x66'),_0x131a('0x67'),_0x131a('0x68'),_0x131a('0x69')],_0x5a6a64);};var _0x422df1=function(_0x55d852){if(!_0x55d852||!_0x55d852['rules'][_0x131a('0x3b')]){return'';}for(var _0x52867d='(',_0x1c89fa=0x0;_0x1c89fa<_0x55d852[_0x131a('0x6a')][_0x131a('0x3b')];_0x1c89fa+=0x1){_0x1c89fa>0x0&&(_0x52867d+='\x20'+_0x55d852[_0x131a('0x6b')]+'\x20');_0x52867d+=_0x55d852[_0x131a('0x6a')][_0x1c89fa]['group']?_0x422df1(_0x55d852[_0x131a('0x6a')][_0x1c89fa][_0x131a('0x6c')]):_0x55d852[_0x131a('0x6a')][_0x1c89fa]['field']+'\x20'+_0x55d852[_0x131a('0x6a')][_0x1c89fa]['condition']+(_0x26865f(_0x55d852[_0x131a('0x6a')][_0x1c89fa][_0x131a('0x6d')])?'\x20'+_0x55d852[_0x131a('0x6a')][_0x1c89fa][_0x131a('0x6e')]:'');}return _0x52867d+')';};var _0xf694dd={'where':{'id':_0x352e84[_0x131a('0x55')]['id']}},_0x2570fe,_0x512ff1,_0x2efee8,_0x340718,_0x486d9d;_0xf694dd=_[_0x131a('0x40')]({},_0xf694dd,_0x352e84[_0x131a('0x48')]);return db[_0x131a('0x30')][_0x131a('0x4f')](_0xf694dd)[_0x131a('0x27')](function(_0x3c7643){if(_0x3c7643){_0x2570fe=_0x3c7643;return _0x3c7643[_0x131a('0x6f')]();}return null;})['then'](function(_0x33b1a5){if(_0x33b1a5){if(!_0x33b1a5[_0x131a('0x3b')]){throw new db[(_0x131a('0x70'))][(_0x131a('0x71'))](_0x131a('0x72'),0x193);}_0x512ff1=_0x33b1a5;return db['AnalyticMetric']['findAll']({'raw':!![]});}return null;})['then'](function(_0xbbb152){if(_0xbbb152){_0x2efee8=_[_0x131a('0x73')](_0xbbb152,'id');var _0x2c2ee1;var _0x251a87=squel[_0x131a('0x74')]();_0x251a87[_0x131a('0x75')](_0x2570fe[_0x131a('0x76')]);for(var _0x5ac3d2=0x0;_0x5ac3d2<_0x512ff1[_0x131a('0x3b')];_0x5ac3d2+=0x1){_0x2c2ee1=_0x512ff1[_0x5ac3d2][_0x131a('0x77')]?_0x2efee8[_0x512ff1[_0x5ac3d2][_0x131a('0x77')]][_0x131a('0x78')]:_0x512ff1[_0x5ac3d2]['field'];_0x2c2ee1=_0x512ff1[_0x5ac3d2][_0x131a('0x79')]?_[_0x131a('0x7a')](_0x2a9b61[_0x512ff1[_0x5ac3d2][_0x131a('0x79')]],'%s',_0x2c2ee1):_0x2c2ee1;_0x2c2ee1=_0x512ff1[_0x5ac3d2]['format']?_[_0x131a('0x7a')](_0x205b13[_0x512ff1[_0x5ac3d2][_0x131a('0x7b')]],'%s',_0x2c2ee1):_0x2c2ee1;if(_0x512ff1[_0x5ac3d2][_0x131a('0x7c')]){_0x251a87['group'](_0x2c2ee1);}_0x512ff1[_0x5ac3d2][_0x131a('0x7d')]&&_0x251a87[_0x131a('0x7e')](_0x2c2ee1,_0x512ff1[_0x5ac3d2][_0x131a('0x7d')]==='DESC'?![]:!![]);_0x251a87['field'](_0x2c2ee1,_0x512ff1[_0x5ac3d2]['alias']||_0x2c2ee1);}if(_0x2570fe[_0x131a('0x7f')]){_0x2570fe[_0x131a('0x7f')]=JSON[_0x131a('0x80')](_0x2570fe[_0x131a('0x7f')]);for(var _0x222313=0x0;_0x222313<_0x2570fe['joins'][_0x131a('0x3b')];_0x222313+=0x1){if(_0x2570fe[_0x131a('0x7f')][_0x222313][_0x131a('0x32')]&&_[_0x131a('0x81')](_0x312e96,_0x2570fe[_0x131a('0x7f')][_0x222313][_0x131a('0x32')])&&_0x2570fe[_0x131a('0x7f')][_0x222313][_0x131a('0x82')]&&_0x2570fe['joins'][_0x222313][_0x131a('0x83')]&&_0x2570fe[_0x131a('0x7f')][_0x222313][_0x131a('0x84')]){_0x251a87[_0x2570fe['joins'][_0x222313][_0x131a('0x32')]](_0x2570fe['joins'][_0x222313][_0x131a('0x83')],null,util[_0x131a('0x7b')](_0x131a('0x85'),_0x2570fe[_0x131a('0x76')],_0x2570fe[_0x131a('0x7f')][_0x222313][_0x131a('0x82')],_0x2570fe[_0x131a('0x7f')][_0x222313]['foreignTable'],_0x2570fe['joins'][_0x222313]['foreignKey']));}}}if(_0x2570fe[_0x131a('0x86')]){_0x2570fe[_0x131a('0x86')]=JSON['parse'](_0x2570fe[_0x131a('0x86')]);_0x251a87[_0x131a('0x3e')](_0x422df1(_0x2570fe[_0x131a('0x86')][_0x131a('0x6c')]));}_0x486d9d=_0x251a87['clone']();_0x251a87['limit'](_0x3c6982);_0x251a87['offset'](0x0);logger[_0x131a('0x87')](_0x131a('0x88'),_0x251a87['toString']());return dbH[_0x131a('0x89')][_0x131a('0x34')](_0x251a87['toString'](),{'type':dbH['sequelize']['QueryTypes']['SELECT']});}})[_0x131a('0x27')](respondWithResult(_0x513adf,null))['catch'](handleError(_0x513adf,null));};function runReport(_0x456c23,_0x1e0cd7,_0x5c0fd5){var _0x3d14a2=_0x1e0cd7[_0x131a('0x2c')];var _0x2b6e0f=0xa;var _0x2228a4=[_0x131a('0x57'),_0x131a('0x8a'),_0x131a('0x58'),_0x131a('0x59')];var _0x431402={'SUM':_0x131a('0x5a'),'COUNT':_0x131a('0x5b'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':'MAX(%s)','MIN':_0x131a('0x5e'),'AVG':'AVG(%s)','GROUP_CONCAT':_0x131a('0x8b'),'GROUP_CONCAT ASC':_0x131a('0x5f'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x46e395={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':_0x131a('0x64'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x5ed2da=function(_0x356d31){return!_[_0x131a('0x81')](['IS\x20NULL',_0x131a('0x67'),_0x131a('0x68'),'IS\x20NOT\x20EMPTY'],_0x356d31);};var _0x41486d=function(_0x603bf0){if(!_0x603bf0||!_0x603bf0[_0x131a('0x6a')][_0x131a('0x3b')]){return'';}for(var _0x82fb8='(',_0x340e3e=0x0;_0x340e3e<_0x603bf0[_0x131a('0x6a')][_0x131a('0x3b')];_0x340e3e+=0x1){_0x340e3e>0x0&&(_0x82fb8+='\x20'+_0x603bf0['operator']+'\x20');_0x82fb8+=_0x603bf0[_0x131a('0x6a')][_0x340e3e][_0x131a('0x6c')]?_0x41486d(_0x603bf0['rules'][_0x340e3e][_0x131a('0x6c')]):_0x603bf0[_0x131a('0x6a')][_0x340e3e][_0x131a('0x8c')]+'\x20'+_0x603bf0[_0x131a('0x6a')][_0x340e3e]['condition']+(_0x5ed2da(_0x603bf0[_0x131a('0x6a')][_0x340e3e][_0x131a('0x6d')])?'\x20'+_0x603bf0[_0x131a('0x6a')][_0x340e3e][_0x131a('0x6e')]:'');}return _0x82fb8+')';};var _0x364499={'where':{'id':_0x456c23['id']}},_0x18536a,_0x2fb309,_0x181229,_0x4e7ef4,_0x693960;_0x364499=_['merge']({},_0x364499,_0x5c0fd5);return db[_0x131a('0x30')][_0x131a('0x4f')](_0x364499)['then'](function(_0x3e3b72){if(_0x3e3b72){_0x18536a=_0x3e3b72;return _0x3e3b72['getFields']();}return null;})['then'](function(_0x4898fd){if(_0x4898fd){if(!_0x4898fd[_0x131a('0x3b')]){throw new db['Sequelize'][(_0x131a('0x71'))](_0x131a('0x72'),0x193);}_0x2fb309=_0x4898fd;return db[_0x131a('0x8d')][_0x131a('0x44')]({'raw':!![]});}return null;})[_0x131a('0x27')](function(_0x192b64){if(_0x192b64){_0x181229=_[_0x131a('0x73')](_0x192b64,'id');var _0x1da709;var _0x5f4f33=squel[_0x131a('0x74')]();_0x5f4f33[_0x131a('0x75')](_0x18536a['table']);for(var _0x43315b=0x0;_0x43315b<_0x2fb309[_0x131a('0x3b')];_0x43315b+=0x1){_0x1da709=_0x2fb309[_0x43315b][_0x131a('0x77')]?_0x181229[_0x2fb309[_0x43315b]['MetricId']][_0x131a('0x78')]:_0x2fb309[_0x43315b][_0x131a('0x8c')];_0x1da709=_0x2fb309[_0x43315b][_0x131a('0x79')]?_[_0x131a('0x7a')](_0x431402[_0x2fb309[_0x43315b][_0x131a('0x79')]],'%s',_0x1da709):_0x1da709;_0x1da709=_0x2fb309[_0x43315b][_0x131a('0x7b')]?_[_0x131a('0x7a')](_0x46e395[_0x2fb309[_0x43315b][_0x131a('0x7b')]],'%s',_0x1da709):_0x1da709;if(_0x2fb309[_0x43315b][_0x131a('0x7c')]){_0x5f4f33['group'](_0x1da709);}_0x2fb309[_0x43315b]['orderBy']&&_0x5f4f33[_0x131a('0x7e')](_0x1da709,_0x2fb309[_0x43315b]['orderBy']===_0x131a('0x8e')?![]:!![]);_0x5f4f33['field'](_0x1da709,_0x2fb309[_0x43315b][_0x131a('0x8f')]||_0x1da709);}if(_0x18536a['joins']){_0x18536a[_0x131a('0x7f')]=JSON[_0x131a('0x80')](_0x18536a[_0x131a('0x7f')]);for(var _0xc34814=0x0;_0xc34814<_0x18536a[_0x131a('0x7f')][_0x131a('0x3b')];_0xc34814+=0x1){if(_0x18536a[_0x131a('0x7f')][_0xc34814]['type']&&_[_0x131a('0x81')](_0x2228a4,_0x18536a[_0x131a('0x7f')][_0xc34814]['type'])&&_0x18536a['joins'][_0xc34814][_0x131a('0x82')]&&_0x18536a[_0x131a('0x7f')][_0xc34814][_0x131a('0x83')]&&_0x18536a['joins'][_0xc34814][_0x131a('0x84')]){_0x5f4f33[_0x18536a[_0x131a('0x7f')][_0xc34814][_0x131a('0x32')]](_0x18536a[_0x131a('0x7f')][_0xc34814][_0x131a('0x83')],null,util[_0x131a('0x7b')](_0x131a('0x85'),_0x18536a[_0x131a('0x76')],_0x18536a[_0x131a('0x7f')][_0xc34814][_0x131a('0x82')],_0x18536a[_0x131a('0x7f')][_0xc34814][_0x131a('0x83')],_0x18536a[_0x131a('0x7f')][_0xc34814][_0x131a('0x84')]));}}}if(_0x18536a[_0x131a('0x86')]){_0x18536a[_0x131a('0x86')]=JSON[_0x131a('0x80')](_0x18536a[_0x131a('0x86')]);_0x5f4f33[_0x131a('0x3e')](_0x41486d(_0x18536a[_0x131a('0x86')][_0x131a('0x6c')]));}_0x693960=_0x5f4f33[_0x131a('0x90')]();_0x5f4f33[_0x131a('0x1f')](_0x2b6e0f);_0x5f4f33[_0x131a('0x1d')](0x0);return;}})['then'](function(){if(_0x1e0cd7[_0x131a('0x91')]===_0x131a('0x92')){return null;}var _0xcffdf4=_['merge'](_0x1e0cd7,{'name':_0x1e0cd7[_0x131a('0x93')]||_0x1e0cd7[_0x131a('0x2c')]||_0x18536a[_0x131a('0x2c')],'basename':_0x3d14a2,'savename':util[_0x131a('0x7b')](_0x131a('0x94'),_0x1e0cd7[_0x131a('0x2c')]||_0x18536a[_0x131a('0x2c')],require(_0x131a('0x95'))[_0x131a('0x96')](0x4),_0x1e0cd7[_0x131a('0x91')]||_0x131a('0x97')),'reportId':_0x18536a['id'],'reportType':_0x131a('0x98')});return db[_0x131a('0x99')]['create'](_0xcffdf4,{'raw':!![]});})[_0x131a('0x27')](function(_0x2c5c03){if(_0x18536a[_0x131a('0x76')]==='cdr'){_0x693960[_0x131a('0x3e')](_0x18536a[_0x131a('0x76')]+_0x131a('0x9a'),_0x1e0cd7[_0x131a('0x9b')],_0x1e0cd7[_0x131a('0x9c')]);}else{_0x693960[_0x131a('0x3e')](_0x18536a[_0x131a('0x76')]+_0x131a('0x9d'),_0x1e0cd7[_0x131a('0x9b')],_0x1e0cd7['endDate']);}if(_0x2c5c03){logger[_0x131a('0x9e')](_0x131a('0x9f'),_0x693960['toString']());require(_0x131a('0xa0'))[_0x131a('0xa1')](path[_0x131a('0x57')](__dirname,_0x131a('0xa2'),_0x2c5c03['output']),[_0x2c5c03['id'],_0x693960[_0x131a('0xa3')](),path[_0x131a('0x57')](__dirname,_0x131a('0xa4'),_0x2c5c03[_0x131a('0xa5')]),_0x3d14a2]);return _0x2c5c03;}else{var _0x1799ff=squel[_0x131a('0x74')]();_0x1799ff['from']('('+_0x693960[_0x131a('0xa3')]()+')',_0x131a('0xa6'));_0x1799ff[_0x131a('0x8c')]('COUNT(*)',_0x131a('0x20'));_0x693960[_0x131a('0x1f')](_0x1e0cd7['limit']||_0x2b6e0f);_0x693960[_0x131a('0x1d')](_0x1e0cd7[_0x131a('0x1d')]||0x0);return dbH['sequelize'][_0x131a('0x34')](_0x1799ff[_0x131a('0xa3')](),{'type':dbH[_0x131a('0x89')][_0x131a('0xa7')][_0x131a('0xa8')]})[_0x131a('0x27')](function(_0x135bb0){if(!_0x135bb0['length']){_0x4e7ef4=0x0;}else{_0x4e7ef4=_0x135bb0[0x0]['count']||0x0;}return dbH['sequelize']['query'](_0x693960[_0x131a('0xa3')](),{'type':dbH[_0x131a('0x89')][_0x131a('0xa7')]['SELECT']});})[_0x131a('0x27')](function(_0xba1019){return{'rows':_0xba1019||[],'count':_0x4e7ef4};});}});}exports[_0x131a('0xa9')]=function(_0x4087ca,_0x511cc8){return runReport(_0x4087ca[_0x131a('0x55')],_0x4087ca[_0x131a('0x34')],_0x4087ca[_0x131a('0x48')])['then'](respondWithResult(_0x511cc8,null))['catch'](handleError(_0x511cc8,null));};exports['runReport']=runReport;exports[_0x131a('0x34')]=function(_0x1d009e,_0x2aaff8){var _0x97544b=0xa;var _0x5c487b=[_0x131a('0x57'),_0x131a('0x8a'),'right_join',_0x131a('0x59')];var _0xef06aa={'SUM':'SUM(%s)','COUNT':_0x131a('0x5b'),'COUNT DISTINCT':_0x131a('0x5c'),'MAX':_0x131a('0x5d'),'MIN':_0x131a('0x5e'),'AVG':_0x131a('0xaa'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x131a('0x5f'),'GROUP_CONCAT DESC':_0x131a('0x60')};var _0x5bdb99={'SEC_TO_TIME':_0x131a('0x61'),'DATE':'DATE(%s)','HOUR':_0x131a('0x63'),'ROUND':_0x131a('0x64'),'UNIX_TIMESTAMP':_0x131a('0x65')};var _0x4f2d8d=function(_0x1df54a){return!_[_0x131a('0x81')](['IS\x20NULL','IS\x20NOT\x20NULL',_0x131a('0x68'),_0x131a('0x69')],_0x1df54a);};var _0x27c773=function(_0x4a4127){if(!_0x4a4127||!_0x4a4127['rules'][_0x131a('0x3b')]){return'';}for(var _0x4bdb7b='(',_0x2003bc=0x0;_0x2003bc<_0x4a4127[_0x131a('0x6a')][_0x131a('0x3b')];_0x2003bc+=0x1){_0x2003bc>0x0&&(_0x4bdb7b+='\x20'+_0x4a4127[_0x131a('0x6b')]+'\x20');_0x4bdb7b+=_0x4a4127['rules'][_0x2003bc][_0x131a('0x6c')]?_0x27c773(_0x4a4127[_0x131a('0x6a')][_0x2003bc]['group']):_0x4a4127[_0x131a('0x6a')][_0x2003bc][_0x131a('0x8c')]+'\x20'+_0x4a4127[_0x131a('0x6a')][_0x2003bc][_0x131a('0x6d')]+(_0x4f2d8d(_0x4a4127['rules'][_0x2003bc][_0x131a('0x6d')])?'\x20'+_0x4a4127[_0x131a('0x6a')][_0x2003bc][_0x131a('0x6e')]:'');}return _0x4bdb7b+')';};var _0x426c21={'where':{'id':_0x1d009e[_0x131a('0x55')]['id']}},_0x5b1e4a,_0x2ebab6,_0xe5aa3f,_0x42fafe,_0x44bcb2;_0x426c21=_['merge']({},_0x426c21,_0x1d009e[_0x131a('0x48')]);return db['AnalyticCustomReport'][_0x131a('0x4f')](_0x426c21)[_0x131a('0x27')](function(_0x118b9f){if(_0x118b9f){_0x5b1e4a=_0x118b9f;return _0x118b9f['getFields']();}return null;})[_0x131a('0x27')](function(_0x3fc051){if(_0x3fc051){if(!_0x3fc051['length']){throw new db[(_0x131a('0x70'))][(_0x131a('0x71'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x2ebab6=_0x3fc051;return db[_0x131a('0x8d')][_0x131a('0x44')]({'raw':!![]});}return null;})[_0x131a('0x27')](function(_0x10b292){if(_0x10b292){_0xe5aa3f=_[_0x131a('0x73')](_0x10b292,'id');var _0x223eaa;var _0x1b4c1f=squel['select']();_0x1b4c1f[_0x131a('0x75')](_0x5b1e4a[_0x131a('0x76')]);for(var _0x9e1b6f=0x0;_0x9e1b6f<_0x2ebab6[_0x131a('0x3b')];_0x9e1b6f+=0x1){_0x223eaa=_0x2ebab6[_0x9e1b6f][_0x131a('0x77')]?_0xe5aa3f[_0x2ebab6[_0x9e1b6f]['MetricId']][_0x131a('0x78')]:_0x2ebab6[_0x9e1b6f][_0x131a('0x8c')];_0x223eaa=_0x2ebab6[_0x9e1b6f]['function']?_[_0x131a('0x7a')](_0xef06aa[_0x2ebab6[_0x9e1b6f][_0x131a('0x79')]],'%s',_0x223eaa):_0x223eaa;_0x223eaa=_0x2ebab6[_0x9e1b6f][_0x131a('0x7b')]?_['replace'](_0x5bdb99[_0x2ebab6[_0x9e1b6f][_0x131a('0x7b')]],'%s',_0x223eaa):_0x223eaa;if(_0x2ebab6[_0x9e1b6f]['groupBy']){_0x1b4c1f[_0x131a('0x6c')](_0x223eaa);}_0x2ebab6[_0x9e1b6f][_0x131a('0x7d')]&&_0x1b4c1f[_0x131a('0x7e')](_0x223eaa,_0x2ebab6[_0x9e1b6f][_0x131a('0x7d')]===_0x131a('0x8e')?![]:!![]);_0x1b4c1f[_0x131a('0x8c')](_0x223eaa,_0x2ebab6[_0x9e1b6f][_0x131a('0x8f')]||_0x223eaa);}if(_0x5b1e4a[_0x131a('0x7f')]){_0x5b1e4a['joins']=JSON[_0x131a('0x80')](_0x5b1e4a[_0x131a('0x7f')]);for(var _0x2db2ae=0x0;_0x2db2ae<_0x5b1e4a[_0x131a('0x7f')][_0x131a('0x3b')];_0x2db2ae+=0x1){if(_0x5b1e4a[_0x131a('0x7f')][_0x2db2ae][_0x131a('0x32')]&&_['includes'](_0x5c487b,_0x5b1e4a[_0x131a('0x7f')][_0x2db2ae][_0x131a('0x32')])&&_0x5b1e4a[_0x131a('0x7f')][_0x2db2ae][_0x131a('0x82')]&&_0x5b1e4a[_0x131a('0x7f')][_0x2db2ae][_0x131a('0x83')]&&_0x5b1e4a[_0x131a('0x7f')][_0x2db2ae][_0x131a('0x84')]){_0x1b4c1f[_0x5b1e4a[_0x131a('0x7f')][_0x2db2ae][_0x131a('0x32')]](_0x5b1e4a[_0x131a('0x7f')][_0x2db2ae][_0x131a('0x83')],null,util[_0x131a('0x7b')](_0x131a('0x85'),_0x5b1e4a[_0x131a('0x76')],_0x5b1e4a[_0x131a('0x7f')][_0x2db2ae][_0x131a('0x82')],_0x5b1e4a[_0x131a('0x7f')][_0x2db2ae]['foreignTable'],_0x5b1e4a[_0x131a('0x7f')][_0x2db2ae][_0x131a('0x84')]));}}}if(_0x5b1e4a[_0x131a('0x86')]){_0x5b1e4a[_0x131a('0x86')]=JSON[_0x131a('0x80')](_0x5b1e4a[_0x131a('0x86')]);_0x1b4c1f[_0x131a('0x3e')](_0x27c773(_0x5b1e4a['conditions'][_0x131a('0x6c')]));}_0x44bcb2=_0x1b4c1f[_0x131a('0x90')]();_0x1b4c1f['limit'](_0x97544b);_0x1b4c1f[_0x131a('0x1d')](0x0);logger[_0x131a('0x87')](_0x131a('0x88'),_0x1b4c1f[_0x131a('0xa3')]());return dbH[_0x131a('0x89')][_0x131a('0x34')](_0x1b4c1f[_0x131a('0xa3')](),{'type':dbH['sequelize'][_0x131a('0xa7')][_0x131a('0xa8')]});}})[_0x131a('0x27')](function(){return{'sql':_0x44bcb2['toString']()};})[_0x131a('0x27')](respondWithResult(_0x2aaff8,null))[_0x131a('0x46')](handleError(_0x2aaff8,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff