// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xa33b=['MAX(%s)','MIN(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','SEC_TO_TIME(%s)','DATE(%s)','HOUR(%s)','ROUND(%s)','IS\x20NULL','rules','operator','group','condition','value','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','findAll','keyBy','select','from','table','MetricId','metric','replace','function','format','groupBy','orderBy','DESC','alias','joins','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','conditions','parse','clone','sequelize','QueryTypes','SELECT','AVG(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','UNIX_TIMESTAMP(%s)','includes','IS\x20NOT\x20NULL','IS\x20EMPTY','toString','No\x20available\x20data','output','fullPath','%s-%s.%s','randomstring','generate','csv','cdr','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','Run\x20Query:','child_process','../../components/export/','../../files/reports','savename','COUNT(*)','run','runReport','IS\x20NOT\x20EMPTY','debug','Limited\x20Query:','rimraf','zip-dir','fast-json-patch','moment','bluebird','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','json','count','offset','limit','set','Content-Range','apply','reject','save','then','destroy','DefaultReports','UserProfileResource','end','error','stack','name','send','index','AnalyticDefaultReport','rawAttributes','model','keys','query','filters','intersection','attributes','fields','length','nolimit','order','sort','where','merge','map','type','key','VIRTUAL','field','filter','options','includeAll','include','catch','show','params','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','user','Reports','find','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','preview','join','left_join','right_join','cross_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)'];(function(_0x4650f2,_0x24baec){var _0x1da197=function(_0x2c7555){while(--_0x2c7555){_0x4650f2['push'](_0x4650f2['shift']());}};_0x1da197(++_0x24baec);}(_0xa33b,0x18d));var _0xba33=function(_0x167cc1,_0x56ef5a){_0x167cc1=_0x167cc1-0x0;var _0x10bc4b=_0xa33b[_0x167cc1];return _0x10bc4b;};'use strict';var pdf=require('html-pdf');var emlformat=require('eml-format');var rimraf=require(_0xba33('0x0'));var zipdir=require(_0xba33('0x1'));var jsonpatch=require(_0xba33('0x2'));var rp=require('request-promise');var moment=require(_0xba33('0x3'));var BPromise=require(_0xba33('0x4'));var Mustache=require('mustache');var util=require(_0xba33('0x5'));var path=require(_0xba33('0x6'));var sox=require(_0xba33('0x7'));var csv=require(_0xba33('0x8'));var ejs=require(_0xba33('0x9'));var fs=require('fs');var _=require(_0xba33('0xa'));var squel=require(_0xba33('0xb'));var crypto=require(_0xba33('0xc'));var jsforce=require(_0xba33('0xd'));var deskjs=require(_0xba33('0xe'));var toCsv=require(_0xba33('0x8'));var querystring=require(_0xba33('0xf'));var Papa=require(_0xba33('0x10'));var Redis=require(_0xba33('0x11'));var authService=require(_0xba33('0x12'));var qs=require(_0xba33('0x13'));var hardwareService=require(_0xba33('0x14'));var logger=require('../../config/logger')(_0xba33('0x15'));var utils=require(_0xba33('0x16'));var config=require(_0xba33('0x17'));var db=require(_0xba33('0x18'))['db'];function respondWithStatusCode(_0x8260c1,_0x3cda46){_0x3cda46=_0x3cda46||0xcc;return function(_0x108ad1){if(_0x108ad1){return _0x8260c1[_0xba33('0x19')](_0x3cda46);}return _0x8260c1['status'](_0x3cda46)['end']();};}function respondWithResult(_0xdc96d7,_0x16504f){_0x16504f=_0x16504f||0xc8;return function(_0x7796c0){if(_0x7796c0){return _0xdc96d7[_0xba33('0x1a')](_0x16504f)[_0xba33('0x1b')](_0x7796c0);}};}function respondWithFilteredResult(_0x53401a,_0x1d7253){return function(_0x10d85a){if(_0x10d85a){var _0x1a47cc=_0x10d85a[_0xba33('0x1c')],_0x22795f=_0x1d7253[_0xba33('0x1d')],_0x35aab9=_0x1d7253[_0xba33('0x1d')]+_0x1d7253[_0xba33('0x1e')],_0x4ffab3;if(_0x35aab9>=_0x1a47cc){_0x35aab9=_0x1a47cc;_0x4ffab3=0xc8;}else{_0x4ffab3=0xce;}_0x53401a[_0xba33('0x1a')](_0x4ffab3);return _0x53401a[_0xba33('0x1f')](_0xba33('0x20'),_0x22795f+'-'+_0x35aab9+'/'+_0x1a47cc)['json'](_0x10d85a);}return null;};}function patchUpdates(_0x207334){return function(_0x46784b){try{jsonpatch[_0xba33('0x21')](_0x46784b,_0x207334,!![]);}catch(_0x2588dc){return BPromise[_0xba33('0x22')](_0x2588dc);}return _0x46784b[_0xba33('0x23')]();};}function saveUpdates(_0x369bb1,_0x44a08d){return function(_0x36f3fd){if(_0x36f3fd){return _0x36f3fd['update'](_0x369bb1)[_0xba33('0x24')](function(_0x3b73a9){return _0x3b73a9;});}return null;};}function removeEntity(_0xfdb87d,_0x184ba4){return function(_0x4d28e0){if(_0x4d28e0){return _0x4d28e0[_0xba33('0x25')]()[_0xba33('0x24')](function(){var _0x4d77e8=_0x4d28e0['get']({'plain':!![]});var _0x2307c4=_0xba33('0x26');return db[_0xba33('0x27')][_0xba33('0x25')]({'where':{'type':_0x2307c4,'resourceId':_0x4d77e8['id']}})[_0xba33('0x24')](function(){return _0x4d28e0;});})[_0xba33('0x24')](function(){_0xfdb87d[_0xba33('0x1a')](0xcc)[_0xba33('0x28')]();});}};}function handleEntityNotFound(_0x119fd9,_0x226452){return function(_0x430e11){if(!_0x430e11){_0x119fd9[_0xba33('0x19')](0x194);}return _0x430e11;};}function handleError(_0x3b793a,_0x1ebe43){_0x1ebe43=_0x1ebe43||0x1f4;return function(_0x3c1345){logger[_0xba33('0x29')](_0x3c1345[_0xba33('0x2a')]);if(_0x3c1345[_0xba33('0x2b')]){delete _0x3c1345[_0xba33('0x2b')];}_0x3b793a[_0xba33('0x1a')](_0x1ebe43)[_0xba33('0x2c')](_0x3c1345);};}exports[_0xba33('0x2d')]=function(_0x1268d9,_0xee2ad1){var _0x44e693={},_0x36f4ad={},_0x5ae9be={'count':0x0,'rows':[]};var _0x502722=db[_0xba33('0x2e')][_0xba33('0x2f')];_0x36f4ad[_0xba33('0x30')]=_[_0xba33('0x31')](_0x502722);_0x36f4ad[_0xba33('0x32')]=_['keys'](_0x1268d9[_0xba33('0x32')]);_0x36f4ad[_0xba33('0x33')]=_[_0xba33('0x34')](_0x36f4ad[_0xba33('0x30')],_0x36f4ad[_0xba33('0x32')]);_0x44e693[_0xba33('0x35')]=_[_0xba33('0x34')](_0x36f4ad['model'],qs['fields'](_0x1268d9[_0xba33('0x32')][_0xba33('0x36')]));_0x44e693[_0xba33('0x35')]=_0x44e693[_0xba33('0x35')][_0xba33('0x37')]?_0x44e693[_0xba33('0x35')]:_0x36f4ad[_0xba33('0x30')];if(!_0x1268d9[_0xba33('0x32')]['hasOwnProperty'](_0xba33('0x38'))){_0x44e693[_0xba33('0x1e')]=qs['limit'](_0x1268d9['query'][_0xba33('0x1e')]);_0x44e693[_0xba33('0x1d')]=qs[_0xba33('0x1d')](_0x1268d9[_0xba33('0x32')][_0xba33('0x1d')]);}_0x44e693[_0xba33('0x39')]=qs[_0xba33('0x3a')](_0x1268d9[_0xba33('0x32')][_0xba33('0x3a')]);_0x44e693['where']=qs[_0xba33('0x33')](_['pick'](_0x1268d9[_0xba33('0x32')],_0x36f4ad['filters']));if(_0x1268d9[_0xba33('0x32')]['filter']){_0x44e693[_0xba33('0x3b')]=_[_0xba33('0x3c')](_0x44e693['where'],{'$or':_[_0xba33('0x3d')](_0x502722,function(_0x489765){if(_0x489765[_0xba33('0x3e')][_0xba33('0x3f')]!==_0xba33('0x40')){var _0x43734a={};_0x43734a[_0x489765[_0xba33('0x41')]]={'$like':'%'+_0x1268d9[_0xba33('0x32')][_0xba33('0x42')]+'%'};return _0x43734a;}})});}_0x44e693=_[_0xba33('0x3c')]({},_0x44e693,_0x1268d9[_0xba33('0x43')]);var _0x46b4a5={'where':_0x44e693[_0xba33('0x3b')]};return db[_0xba33('0x2e')][_0xba33('0x1c')](_0x46b4a5)[_0xba33('0x24')](function(_0x39e87e){_0x5ae9be[_0xba33('0x1c')]=_0x39e87e;if(_0x1268d9[_0xba33('0x32')][_0xba33('0x44')]){_0x44e693[_0xba33('0x45')]=[{'all':!![]}];}return db[_0xba33('0x2e')]['findAll'](_0x44e693);})[_0xba33('0x24')](function(_0x29ffc2){_0x5ae9be['rows']=_0x29ffc2;return _0x5ae9be;})[_0xba33('0x24')](respondWithFilteredResult(_0xee2ad1,_0x44e693))[_0xba33('0x46')](handleError(_0xee2ad1,null));};exports[_0xba33('0x47')]=function(_0x264119,_0x33cd11){var _0x493600={'raw':!![],'where':{'id':_0x264119[_0xba33('0x48')]['id']}},_0x1bb6a8={};_0x1bb6a8[_0xba33('0x30')]=_['keys'](db[_0xba33('0x2e')][_0xba33('0x2f')]);_0x1bb6a8['query']=_['keys'](_0x264119['query']);_0x1bb6a8[_0xba33('0x33')]=_['intersection'](_0x1bb6a8[_0xba33('0x30')],_0x1bb6a8['query']);_0x493600[_0xba33('0x35')]=_[_0xba33('0x34')](_0x1bb6a8['model'],qs[_0xba33('0x36')](_0x264119[_0xba33('0x32')][_0xba33('0x36')]));_0x493600['attributes']=_0x493600[_0xba33('0x35')][_0xba33('0x37')]?_0x493600['attributes']:_0x1bb6a8[_0xba33('0x30')];if(_0x264119[_0xba33('0x32')][_0xba33('0x44')]){_0x493600[_0xba33('0x45')]=[{'all':!![]}];}_0x493600=_['merge']({},_0x493600,_0x264119[_0xba33('0x43')]);return db[_0xba33('0x2e')]['find'](_0x493600)[_0xba33('0x24')](handleEntityNotFound(_0x33cd11,null))[_0xba33('0x24')](respondWithResult(_0x33cd11,null))[_0xba33('0x46')](handleError(_0x33cd11,null));};exports[_0xba33('0x49')]=function(_0x5d07ad,_0x2707d2){return db[_0xba33('0x2e')][_0xba33('0x49')](_0x5d07ad[_0xba33('0x4a')],{})[_0xba33('0x24')](function(_0x3325ba){var _0x59a691=_0x5d07ad['user']['get']({'plain':!![]});if(!_0x59a691)throw new Error(_0xba33('0x4b'));if(_0x59a691['role']===_0xba33('0x4c')){var _0xd88373=_0x3325ba['get']({'plain':!![]});var _0xbf0db7=_0xba33('0x4d');return db['UserProfileSection'][_0xba33('0x4e')]({'where':{'name':_0xbf0db7,'userProfileId':_0x59a691['userProfileId']},'raw':!![]})[_0xba33('0x24')](function(_0x28b633){if(_0x28b633&&_0x28b633[_0xba33('0x4f')]===0x0){return db[_0xba33('0x27')][_0xba33('0x49')]({'name':_0xd88373['name'],'resourceId':_0xd88373['id'],'type':_0xba33('0x26'),'sectionId':_0x28b633['id']},{})[_0xba33('0x24')](function(){return _0x3325ba;});}else{return _0x3325ba;}})[_0xba33('0x46')](function(_0x43b41b){logger[_0xba33('0x29')](_0xba33('0x50'),_0x43b41b);throw _0x43b41b;});}return _0x3325ba;})[_0xba33('0x24')](respondWithResult(_0x2707d2,0xc9))['catch'](handleError(_0x2707d2,null));};exports['update']=function(_0x87d20f,_0x189a39){if(_0x87d20f['body']['id']){delete _0x87d20f['body']['id'];}return db[_0xba33('0x2e')]['find']({'where':{'id':_0x87d20f[_0xba33('0x48')]['id']}})[_0xba33('0x24')](handleEntityNotFound(_0x189a39,null))[_0xba33('0x24')](saveUpdates(_0x87d20f[_0xba33('0x4a')],null))[_0xba33('0x24')](respondWithResult(_0x189a39,null))[_0xba33('0x46')](handleError(_0x189a39,null));};exports[_0xba33('0x25')]=function(_0xd8f1fd,_0x42fe65){return db['AnalyticDefaultReport'][_0xba33('0x4e')]({'where':{'id':_0xd8f1fd[_0xba33('0x48')]['id']}})['then'](handleEntityNotFound(_0x42fe65,null))['then'](removeEntity(_0x42fe65,null))[_0xba33('0x46')](handleError(_0x42fe65,null));};exports[_0xba33('0x51')]=function(_0x1c709a,_0x2ddce0){var _0x20bd81=0xa;var _0x281215=[_0xba33('0x52'),_0xba33('0x53'),_0xba33('0x54'),_0xba33('0x55')];var _0xe776e3={'SUM':_0xba33('0x56'),'COUNT':_0xba33('0x57'),'COUNT DISTINCT':_0xba33('0x58'),'MAX':_0xba33('0x59'),'MIN':_0xba33('0x5a'),'AVG':'AVG(%s)','GROUP_CONCAT':_0xba33('0x5b'),'GROUP_CONCAT ASC':_0xba33('0x5c'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x1ce276={'SEC_TO_TIME':_0xba33('0x5d'),'DATE':_0xba33('0x5e'),'HOUR':_0xba33('0x5f'),'ROUND':_0xba33('0x60'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x375adb=function(_0x26f4c2){return!_['includes']([_0xba33('0x61'),'IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY'],_0x26f4c2);};var _0x5f23ee=function(_0x5c55e4){if(!_0x5c55e4||!_0x5c55e4[_0xba33('0x62')][_0xba33('0x37')]){return'';}for(var _0x485639='(',_0x275248=0x0;_0x275248<_0x5c55e4[_0xba33('0x62')][_0xba33('0x37')];_0x275248+=0x1){_0x275248>0x0&&(_0x485639+='\x20'+_0x5c55e4[_0xba33('0x63')]+'\x20');_0x485639+=_0x5c55e4[_0xba33('0x62')][_0x275248]['group']?_0x5f23ee(_0x5c55e4[_0xba33('0x62')][_0x275248][_0xba33('0x64')]):_0x5c55e4[_0xba33('0x62')][_0x275248][_0xba33('0x41')]+'\x20'+_0x5c55e4['rules'][_0x275248][_0xba33('0x65')]+(_0x375adb(_0x5c55e4[_0xba33('0x62')][_0x275248]['condition'])?'\x20'+_0x5c55e4[_0xba33('0x62')][_0x275248][_0xba33('0x66')]:'');}return _0x485639+')';};var _0x571fac={'where':{'id':_0x1c709a[_0xba33('0x48')]['id']}},_0x1ccb9b,_0x15e6a9,_0x125e1c,_0x4100fe,_0x30ea05;_0x571fac=_[_0xba33('0x3c')]({},_0x571fac,_0x1c709a[_0xba33('0x43')]);return db[_0xba33('0x2e')]['find'](_0x571fac)['then'](function(_0x2d7268){if(_0x2d7268){_0x1ccb9b=_0x2d7268;return _0x2d7268[_0xba33('0x67')]();}return null;})[_0xba33('0x24')](function(_0x30737b){if(_0x30737b){if(!_0x30737b[_0xba33('0x37')]){throw new db[(_0xba33('0x68'))][(_0xba33('0x69'))](_0xba33('0x6a'),0x193);}_0x15e6a9=_0x30737b;return db[_0xba33('0x6b')][_0xba33('0x6c')]({'raw':!![]});}return null;})['then'](function(_0x24b407){if(_0x24b407){_0x125e1c=_[_0xba33('0x6d')](_0x24b407,'id');var _0x937ed8;var _0x58e2bc=squel[_0xba33('0x6e')]();_0x58e2bc[_0xba33('0x6f')](_0x1ccb9b[_0xba33('0x70')]);for(var _0x55565d=0x0;_0x55565d<_0x15e6a9[_0xba33('0x37')];_0x55565d+=0x1){_0x937ed8=_0x15e6a9[_0x55565d][_0xba33('0x71')]?_0x125e1c[_0x15e6a9[_0x55565d][_0xba33('0x71')]][_0xba33('0x72')]:_0x15e6a9[_0x55565d]['field'];_0x937ed8=_0x15e6a9[_0x55565d]['function']?_[_0xba33('0x73')](_0xe776e3[_0x15e6a9[_0x55565d][_0xba33('0x74')]],'%s',_0x937ed8):_0x937ed8;_0x937ed8=_0x15e6a9[_0x55565d]['format']?_[_0xba33('0x73')](_0x1ce276[_0x15e6a9[_0x55565d][_0xba33('0x75')]],'%s',_0x937ed8):_0x937ed8;if(_0x15e6a9[_0x55565d][_0xba33('0x76')]){_0x58e2bc[_0xba33('0x64')](_0x937ed8);}_0x15e6a9[_0x55565d][_0xba33('0x77')]&&_0x58e2bc[_0xba33('0x39')](_0x937ed8,_0x15e6a9[_0x55565d][_0xba33('0x77')]===_0xba33('0x78')?![]:!![]);_0x58e2bc[_0xba33('0x41')](_0x937ed8,_0x15e6a9[_0x55565d][_0xba33('0x79')]||_0x937ed8);}if(_0x1ccb9b[_0xba33('0x7a')]){_0x1ccb9b[_0xba33('0x7a')]=JSON['parse'](_0x1ccb9b[_0xba33('0x7a')]);for(var _0x3345ee=0x0;_0x3345ee<_0x1ccb9b[_0xba33('0x7a')][_0xba33('0x37')];_0x3345ee+=0x1){if(_0x1ccb9b[_0xba33('0x7a')][_0x3345ee][_0xba33('0x3e')]&&_['includes'](_0x281215,_0x1ccb9b[_0xba33('0x7a')][_0x3345ee][_0xba33('0x3e')])&&_0x1ccb9b[_0xba33('0x7a')][_0x3345ee][_0xba33('0x7b')]&&_0x1ccb9b[_0xba33('0x7a')][_0x3345ee][_0xba33('0x7c')]&&_0x1ccb9b[_0xba33('0x7a')][_0x3345ee][_0xba33('0x7d')]){_0x58e2bc[_0x1ccb9b['joins'][_0x3345ee]['type']](_0x1ccb9b[_0xba33('0x7a')][_0x3345ee][_0xba33('0x7c')],null,util[_0xba33('0x75')](_0xba33('0x7e'),_0x1ccb9b[_0xba33('0x70')],_0x1ccb9b[_0xba33('0x7a')][_0x3345ee][_0xba33('0x7b')],_0x1ccb9b[_0xba33('0x7a')][_0x3345ee][_0xba33('0x7c')],_0x1ccb9b['joins'][_0x3345ee][_0xba33('0x7d')]));}}}if(_0x1ccb9b[_0xba33('0x7f')]){_0x1ccb9b[_0xba33('0x7f')]=JSON[_0xba33('0x80')](_0x1ccb9b[_0xba33('0x7f')]);_0x58e2bc[_0xba33('0x3b')](_0x5f23ee(_0x1ccb9b[_0xba33('0x7f')][_0xba33('0x64')]));}_0x30ea05=_0x58e2bc[_0xba33('0x81')]();_0x58e2bc[_0xba33('0x1e')](_0x20bd81);_0x58e2bc[_0xba33('0x1d')](0x0);logger['debug']('Limited\x20Query:',_0x58e2bc['toString']());return db[_0xba33('0x82')][_0xba33('0x32')](_0x58e2bc['toString'](),{'type':db[_0xba33('0x82')][_0xba33('0x83')][_0xba33('0x84')]});}})[_0xba33('0x24')](respondWithResult(_0x2ddce0,null))[_0xba33('0x46')](handleError(_0x2ddce0,null));};function runReport(_0xb066d3,_0x3bef43,_0x5918f0){var _0x2b7f47=_0x3bef43[_0xba33('0x2b')];var _0x559682=0xa;var _0x3f11e2=[_0xba33('0x52'),_0xba33('0x53'),_0xba33('0x54'),_0xba33('0x55')];var _0x124952={'SUM':_0xba33('0x56'),'COUNT':_0xba33('0x57'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0xba33('0x59'),'MIN':_0xba33('0x5a'),'AVG':_0xba33('0x85'),'GROUP_CONCAT':_0xba33('0x5b'),'GROUP_CONCAT ASC':_0xba33('0x5c'),'GROUP_CONCAT DESC':_0xba33('0x86')};var _0x2bebe4={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0xba33('0x5e'),'HOUR':_0xba33('0x5f'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0xba33('0x87')};var _0x10903b=function(_0x1f39d8){return!_[_0xba33('0x88')]([_0xba33('0x61'),_0xba33('0x89'),_0xba33('0x8a'),'IS\x20NOT\x20EMPTY'],_0x1f39d8);};var _0xe5c93f=function(_0x2df818){if(!_0x2df818||!_0x2df818[_0xba33('0x62')]['length']){return'';}for(var _0x57443c='(',_0x6eec6e=0x0;_0x6eec6e<_0x2df818['rules'][_0xba33('0x37')];_0x6eec6e+=0x1){_0x6eec6e>0x0&&(_0x57443c+='\x20'+_0x2df818[_0xba33('0x63')]+'\x20');_0x57443c+=_0x2df818[_0xba33('0x62')][_0x6eec6e]['group']?_0xe5c93f(_0x2df818['rules'][_0x6eec6e][_0xba33('0x64')]):_0x2df818[_0xba33('0x62')][_0x6eec6e]['field']+'\x20'+_0x2df818[_0xba33('0x62')][_0x6eec6e]['condition']+(_0x10903b(_0x2df818[_0xba33('0x62')][_0x6eec6e][_0xba33('0x65')])?'\x20'+_0x2df818[_0xba33('0x62')][_0x6eec6e]['value']:'');}return _0x57443c+')';};var _0x4c7018={'where':{'id':_0xb066d3['id']}},_0x4d2762,_0x1944ad,_0x30fd5e,_0x4a0292,_0x14f0e8;_0x4c7018=_['merge']({},_0x4c7018,_0x5918f0);return db['AnalyticDefaultReport'][_0xba33('0x4e')](_0x4c7018)[_0xba33('0x24')](function(_0x581078){if(_0x581078){_0x4d2762=_0x581078;return _0x581078[_0xba33('0x67')]();}return null;})[_0xba33('0x24')](function(_0x19730b){if(_0x19730b){if(!_0x19730b[_0xba33('0x37')]){throw new db[(_0xba33('0x68'))][(_0xba33('0x69'))](_0xba33('0x6a'),0x193);}_0x1944ad=_0x19730b;return db[_0xba33('0x6b')][_0xba33('0x6c')]({'raw':!![]});}return null;})[_0xba33('0x24')](function(_0x506b2c){if(_0x506b2c){_0x30fd5e=_[_0xba33('0x6d')](_0x506b2c,'id');var _0x56853d;var _0x22c94f=squel['select']();_0x22c94f[_0xba33('0x6f')](_0x4d2762[_0xba33('0x70')]);for(var _0x20f59b=0x0;_0x20f59b<_0x1944ad['length'];_0x20f59b+=0x1){_0x56853d=_0x1944ad[_0x20f59b][_0xba33('0x71')]?_0x30fd5e[_0x1944ad[_0x20f59b][_0xba33('0x71')]]['metric']:_0x1944ad[_0x20f59b][_0xba33('0x41')];_0x56853d=_0x1944ad[_0x20f59b]['function']?_['replace'](_0x124952[_0x1944ad[_0x20f59b][_0xba33('0x74')]],'%s',_0x56853d):_0x56853d;_0x56853d=_0x1944ad[_0x20f59b][_0xba33('0x75')]?_['replace'](_0x2bebe4[_0x1944ad[_0x20f59b][_0xba33('0x75')]],'%s',_0x56853d):_0x56853d;if(_0x1944ad[_0x20f59b][_0xba33('0x76')]){_0x22c94f[_0xba33('0x64')](_0x56853d);}_0x1944ad[_0x20f59b]['orderBy']&&_0x22c94f[_0xba33('0x39')](_0x56853d,_0x1944ad[_0x20f59b][_0xba33('0x77')]==='DESC'?![]:!![]);_0x22c94f[_0xba33('0x41')](_0x56853d,_0x1944ad[_0x20f59b]['alias']||_0x56853d);}if(_0x4d2762['joins']){_0x4d2762[_0xba33('0x7a')]=JSON[_0xba33('0x80')](_0x4d2762['joins']);for(var _0x3742a0=0x0;_0x3742a0<_0x4d2762['joins']['length'];_0x3742a0+=0x1){if(_0x4d2762[_0xba33('0x7a')][_0x3742a0][_0xba33('0x3e')]&&_[_0xba33('0x88')](_0x3f11e2,_0x4d2762[_0xba33('0x7a')][_0x3742a0]['type'])&&_0x4d2762[_0xba33('0x7a')][_0x3742a0][_0xba33('0x7b')]&&_0x4d2762[_0xba33('0x7a')][_0x3742a0][_0xba33('0x7c')]&&_0x4d2762[_0xba33('0x7a')][_0x3742a0][_0xba33('0x7d')]){_0x22c94f[_0x4d2762['joins'][_0x3742a0][_0xba33('0x3e')]](_0x4d2762[_0xba33('0x7a')][_0x3742a0][_0xba33('0x7c')],null,util['format'](_0xba33('0x7e'),_0x4d2762[_0xba33('0x70')],_0x4d2762[_0xba33('0x7a')][_0x3742a0][_0xba33('0x7b')],_0x4d2762[_0xba33('0x7a')][_0x3742a0][_0xba33('0x7c')],_0x4d2762[_0xba33('0x7a')][_0x3742a0][_0xba33('0x7d')]));}}}if(_0x4d2762[_0xba33('0x7f')]){_0x4d2762[_0xba33('0x7f')]=JSON[_0xba33('0x80')](_0x4d2762[_0xba33('0x7f')]);_0x22c94f[_0xba33('0x3b')](_0xe5c93f(_0x4d2762[_0xba33('0x7f')]['group']));}_0x14f0e8=_0x22c94f[_0xba33('0x81')]();_0x22c94f[_0xba33('0x1e')](_0x559682);_0x22c94f[_0xba33('0x1d')](0x0);logger['debug']('Limited\x20Query:',_0x22c94f[_0xba33('0x8b')]());return db[_0xba33('0x82')][_0xba33('0x32')](_0x22c94f['toString'](),{'type':db[_0xba33('0x82')][_0xba33('0x83')][_0xba33('0x84')]});}})['then'](function(_0x23542f){if(!_0x23542f[_0xba33('0x37')]){throw new db[(_0xba33('0x68'))][(_0xba33('0x69'))](_0xba33('0x8c'),0xcc);}if(_0x3bef43[_0xba33('0x8d')]==='web'){return null;}var _0xfce22b=_[_0xba33('0x3c')](_0x3bef43,{'name':_0x3bef43[_0xba33('0x8e')]||_0x3bef43[_0xba33('0x2b')]||_0x4d2762[_0xba33('0x2b')],'basename':_0x2b7f47,'savename':util['format'](_0xba33('0x8f'),_0x3bef43['name']||_0x4d2762['name'],require(_0xba33('0x90'))[_0xba33('0x91')](0x4),_0x3bef43[_0xba33('0x8d')]||_0xba33('0x92')),'reportId':_0x4d2762['id'],'reportType':'default'});return db['AnalyticExtractedReport'][_0xba33('0x49')](_0xfce22b,{'raw':!![]});})[_0xba33('0x24')](function(_0x2ea19e){if(_0x4d2762[_0xba33('0x70')]===_0xba33('0x93')){_0x14f0e8[_0xba33('0x3b')](_0x4d2762[_0xba33('0x70')]+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x3bef43['startDate'],_0x3bef43[_0xba33('0x94')]);}else{_0x14f0e8[_0xba33('0x3b')](_0x4d2762[_0xba33('0x70')]+_0xba33('0x95'),_0x3bef43['startDate'],_0x3bef43['endDate']);}if(_0x2ea19e){logger[_0xba33('0x96')](_0xba33('0x97'),_0x14f0e8['toString']());require(_0xba33('0x98'))['fork'](path['join'](__dirname,_0xba33('0x99'),_0x2ea19e[_0xba33('0x8d')]),[_0x2ea19e['id'],_0x14f0e8['toString'](),path['join'](__dirname,_0xba33('0x9a'),_0x2ea19e[_0xba33('0x9b')]),_0x2b7f47]);return _0x2ea19e;}else{var _0x202a83=squel[_0xba33('0x6e')]();_0x202a83[_0xba33('0x6f')]('('+_0x14f0e8[_0xba33('0x8b')]()+')','countTable');_0x202a83[_0xba33('0x41')](_0xba33('0x9c'),'count');_0x14f0e8[_0xba33('0x1e')](_0x3bef43[_0xba33('0x1e')]||_0x559682);_0x14f0e8['offset'](_0x3bef43[_0xba33('0x1d')]||0x0);return db[_0xba33('0x82')][_0xba33('0x32')](_0x202a83[_0xba33('0x8b')](),{'type':db[_0xba33('0x82')]['QueryTypes'][_0xba33('0x84')]})[_0xba33('0x24')](function(_0x109343){if(!_0x109343['length']){_0x4a0292=0x0;}else{_0x4a0292=_0x109343[0x0][_0xba33('0x1c')]||0x0;}return db['sequelize'][_0xba33('0x32')](_0x14f0e8[_0xba33('0x8b')](),{'type':db[_0xba33('0x82')][_0xba33('0x83')][_0xba33('0x84')]});})[_0xba33('0x24')](function(_0x32e9f8){return{'rows':_0x32e9f8||[],'count':_0x4a0292};});}});}exports[_0xba33('0x9d')]=function(_0x34c81b,_0x45001e){return runReport(_0x34c81b[_0xba33('0x48')],_0x34c81b['query'],_0x34c81b['options'])[_0xba33('0x24')](respondWithResult(_0x45001e,null))[_0xba33('0x46')](handleError(_0x45001e,null));};exports[_0xba33('0x9e')]=runReport;exports['query']=function(_0x1d3c26,_0x395a23){var _0x574011=0xa;var _0x12f281=[_0xba33('0x52'),_0xba33('0x53'),'right_join',_0xba33('0x55')];var _0x1493f9={'SUM':_0xba33('0x56'),'COUNT':_0xba33('0x57'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':_0xba33('0x85'),'GROUP_CONCAT':_0xba33('0x5b'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0xba33('0x86')};var _0x4871af={'SEC_TO_TIME':_0xba33('0x5d'),'DATE':_0xba33('0x5e'),'HOUR':_0xba33('0x5f'),'ROUND':_0xba33('0x60'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x1d772c=function(_0x5a1546){return!_[_0xba33('0x88')]([_0xba33('0x61'),_0xba33('0x89'),_0xba33('0x8a'),_0xba33('0x9f')],_0x5a1546);};var _0x58460f=function(_0x35a0d8){if(!_0x35a0d8||!_0x35a0d8[_0xba33('0x62')]['length']){return'';}for(var _0x5c87dd='(',_0x1120eb=0x0;_0x1120eb<_0x35a0d8[_0xba33('0x62')]['length'];_0x1120eb+=0x1){_0x1120eb>0x0&&(_0x5c87dd+='\x20'+_0x35a0d8[_0xba33('0x63')]+'\x20');_0x5c87dd+=_0x35a0d8[_0xba33('0x62')][_0x1120eb][_0xba33('0x64')]?_0x58460f(_0x35a0d8[_0xba33('0x62')][_0x1120eb][_0xba33('0x64')]):_0x35a0d8[_0xba33('0x62')][_0x1120eb][_0xba33('0x41')]+'\x20'+_0x35a0d8['rules'][_0x1120eb][_0xba33('0x65')]+(_0x1d772c(_0x35a0d8[_0xba33('0x62')][_0x1120eb][_0xba33('0x65')])?'\x20'+_0x35a0d8[_0xba33('0x62')][_0x1120eb][_0xba33('0x66')]:'');}return _0x5c87dd+')';};var _0x3d8f2c={'where':{'id':_0x1d3c26[_0xba33('0x48')]['id']}},_0x3e0876,_0x25c14e,_0x2afe97,_0x464455,_0x50117b;_0x3d8f2c=_['merge']({},_0x3d8f2c,_0x1d3c26[_0xba33('0x43')]);return db[_0xba33('0x2e')][_0xba33('0x4e')](_0x3d8f2c)[_0xba33('0x24')](function(_0xb25930){if(_0xb25930){_0x3e0876=_0xb25930;return _0xb25930[_0xba33('0x67')]();}return null;})[_0xba33('0x24')](function(_0x3ab985){if(_0x3ab985){if(!_0x3ab985[_0xba33('0x37')]){throw new db[(_0xba33('0x68'))][(_0xba33('0x69'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x25c14e=_0x3ab985;return db[_0xba33('0x6b')][_0xba33('0x6c')]({'raw':!![]});}return null;})[_0xba33('0x24')](function(_0x3ad476){if(_0x3ad476){_0x2afe97=_[_0xba33('0x6d')](_0x3ad476,'id');var _0x1e9dd0;var _0x4b7f56=squel[_0xba33('0x6e')]();_0x4b7f56[_0xba33('0x6f')](_0x3e0876[_0xba33('0x70')]);for(var _0x30f127=0x0;_0x30f127<_0x25c14e[_0xba33('0x37')];_0x30f127+=0x1){_0x1e9dd0=_0x25c14e[_0x30f127]['MetricId']?_0x2afe97[_0x25c14e[_0x30f127][_0xba33('0x71')]][_0xba33('0x72')]:_0x25c14e[_0x30f127][_0xba33('0x41')];_0x1e9dd0=_0x25c14e[_0x30f127]['function']?_[_0xba33('0x73')](_0x1493f9[_0x25c14e[_0x30f127][_0xba33('0x74')]],'%s',_0x1e9dd0):_0x1e9dd0;_0x1e9dd0=_0x25c14e[_0x30f127][_0xba33('0x75')]?_['replace'](_0x4871af[_0x25c14e[_0x30f127][_0xba33('0x75')]],'%s',_0x1e9dd0):_0x1e9dd0;if(_0x25c14e[_0x30f127][_0xba33('0x76')]){_0x4b7f56['group'](_0x1e9dd0);}_0x25c14e[_0x30f127][_0xba33('0x77')]&&_0x4b7f56[_0xba33('0x39')](_0x1e9dd0,_0x25c14e[_0x30f127][_0xba33('0x77')]===_0xba33('0x78')?![]:!![]);_0x4b7f56[_0xba33('0x41')](_0x1e9dd0,_0x25c14e[_0x30f127]['alias']||_0x1e9dd0);}if(_0x3e0876[_0xba33('0x7a')]){_0x3e0876[_0xba33('0x7a')]=JSON['parse'](_0x3e0876[_0xba33('0x7a')]);for(var _0x53bad3=0x0;_0x53bad3<_0x3e0876[_0xba33('0x7a')][_0xba33('0x37')];_0x53bad3+=0x1){if(_0x3e0876['joins'][_0x53bad3][_0xba33('0x3e')]&&_[_0xba33('0x88')](_0x12f281,_0x3e0876['joins'][_0x53bad3]['type'])&&_0x3e0876[_0xba33('0x7a')][_0x53bad3][_0xba33('0x7b')]&&_0x3e0876[_0xba33('0x7a')][_0x53bad3][_0xba33('0x7c')]&&_0x3e0876[_0xba33('0x7a')][_0x53bad3][_0xba33('0x7d')]){_0x4b7f56[_0x3e0876[_0xba33('0x7a')][_0x53bad3][_0xba33('0x3e')]](_0x3e0876[_0xba33('0x7a')][_0x53bad3][_0xba33('0x7c')],null,util[_0xba33('0x75')](_0xba33('0x7e'),_0x3e0876[_0xba33('0x70')],_0x3e0876[_0xba33('0x7a')][_0x53bad3][_0xba33('0x7b')],_0x3e0876[_0xba33('0x7a')][_0x53bad3][_0xba33('0x7c')],_0x3e0876['joins'][_0x53bad3][_0xba33('0x7d')]));}}}if(_0x3e0876[_0xba33('0x7f')]){_0x3e0876[_0xba33('0x7f')]=JSON[_0xba33('0x80')](_0x3e0876[_0xba33('0x7f')]);_0x4b7f56['where'](_0x58460f(_0x3e0876[_0xba33('0x7f')][_0xba33('0x64')]));}_0x50117b=_0x4b7f56['clone']();_0x4b7f56['limit'](_0x574011);_0x4b7f56[_0xba33('0x1d')](0x0);logger[_0xba33('0xa0')](_0xba33('0xa1'),_0x4b7f56[_0xba33('0x8b')]());return db['sequelize'][_0xba33('0x32')](_0x4b7f56['toString'](),{'type':db[_0xba33('0x82')][_0xba33('0x83')][_0xba33('0x84')]});}})[_0xba33('0x24')](function(){return{'sql':_0x50117b[_0xba33('0x8b')]()};})[_0xba33('0x24')](respondWithResult(_0x395a23,null))['catch'](handleError(_0x395a23,null));};
\ No newline at end of file
+var _0x8137=['query','filters','intersection','attributes','fields','length','hasOwnProperty','order','sort','where','pick','filter','merge','type','key','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','create','role','user','Reports','find','userProfileId','autoAssociation','DefaultReports','body','params','preview','join','left_join','right_join','cross_join','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','DATE(%s)','HOUR(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','condition','value','getFields','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','select','table','MetricId','field','function','replace','format','groupBy','orderBy','DESC','alias','joins','parse','foreignKey','%s.%s\x20=\x20%s.%s','parentKey','foreignTable','conditions','clone','debug','Limited\x20Query:','sequelize','toString','QueryTypes','SUM(%s)','SEC_TO_TIME(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','Sequelize','ValidationErrorItem','from','metric','SELECT','output','web','randomstring','generate','csv','AnalyticExtractedReport','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','Run\x20Query:','child_process','fork','../../components/export/','../../files/reports','COUNT(*)','run','runReport','AVG(%s)','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','ejs','lodash','squel','crypto','desk.js','to-csv','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','json','count','offset','limit','Content-Range','apply','reject','save','update','then','get','UserProfileResource','destroy','error','stack','name','index','AnalyticDefaultReport','rawAttributes','model','keys'];(function(_0x2cc569,_0x4e9568){var _0x1bfc2e=function(_0x5b8fcb){while(--_0x5b8fcb){_0x2cc569['push'](_0x2cc569['shift']());}};_0x1bfc2e(++_0x4e9568);}(_0x8137,0x116));var _0x7813=function(_0x4792c8,_0x5158a1){_0x4792c8=_0x4792c8-0x0;var _0x35edb1=_0x8137[_0x4792c8];return _0x35edb1;};'use strict';var pdf=require(_0x7813('0x0'));var emlformat=require(_0x7813('0x1'));var rimraf=require(_0x7813('0x2'));var zipdir=require(_0x7813('0x3'));var jsonpatch=require(_0x7813('0x4'));var rp=require(_0x7813('0x5'));var moment=require(_0x7813('0x6'));var BPromise=require(_0x7813('0x7'));var Mustache=require(_0x7813('0x8'));var util=require(_0x7813('0x9'));var path=require('path');var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x7813('0xa'));var fs=require('fs');var _=require(_0x7813('0xb'));var squel=require(_0x7813('0xc'));var crypto=require(_0x7813('0xd'));var jsforce=require('jsforce');var deskjs=require(_0x7813('0xe'));var toCsv=require(_0x7813('0xf'));var querystring=require(_0x7813('0x10'));var Papa=require('papaparse');var Redis=require(_0x7813('0x11'));var authService=require(_0x7813('0x12'));var qs=require(_0x7813('0x13'));var hardwareService=require(_0x7813('0x14'));var logger=require(_0x7813('0x15'))(_0x7813('0x16'));var utils=require(_0x7813('0x17'));var config=require(_0x7813('0x18'));var db=require(_0x7813('0x19'))['db'];function respondWithStatusCode(_0x2033a1,_0xae4060){_0xae4060=_0xae4060||0xcc;return function(_0x5dbb57){if(_0x5dbb57){return _0x2033a1[_0x7813('0x1a')](_0xae4060);}return _0x2033a1[_0x7813('0x1b')](_0xae4060)[_0x7813('0x1c')]();};}function respondWithResult(_0x577ea8,_0x2f6b81){_0x2f6b81=_0x2f6b81||0xc8;return function(_0x17d2f0){if(_0x17d2f0){return _0x577ea8['status'](_0x2f6b81)[_0x7813('0x1d')](_0x17d2f0);}};}function respondWithFilteredResult(_0x5ca82f,_0x1bc972){return function(_0x35f3c1){if(_0x35f3c1){var _0x19a6ca=_0x35f3c1[_0x7813('0x1e')],_0x410980=_0x1bc972[_0x7813('0x1f')],_0x1dba76=_0x1bc972[_0x7813('0x1f')]+_0x1bc972[_0x7813('0x20')],_0x533d09;if(_0x1dba76>=_0x19a6ca){_0x1dba76=_0x19a6ca;_0x533d09=0xc8;}else{_0x533d09=0xce;}_0x5ca82f['status'](_0x533d09);return _0x5ca82f['set'](_0x7813('0x21'),_0x410980+'-'+_0x1dba76+'/'+_0x19a6ca)[_0x7813('0x1d')](_0x35f3c1);}return null;};}function patchUpdates(_0x22725e){return function(_0x203c0a){try{jsonpatch[_0x7813('0x22')](_0x203c0a,_0x22725e,!![]);}catch(_0x489697){return BPromise[_0x7813('0x23')](_0x489697);}return _0x203c0a[_0x7813('0x24')]();};}function saveUpdates(_0x51d8b5,_0x4f4b4b){return function(_0x29febd){if(_0x29febd){return _0x29febd[_0x7813('0x25')](_0x51d8b5)['then'](function(_0x46d743){return _0x46d743;});}return null;};}function removeEntity(_0x8983c,_0x351162){return function(_0x1902d2){if(_0x1902d2){return _0x1902d2['destroy']()[_0x7813('0x26')](function(){var _0x5188b0=_0x1902d2[_0x7813('0x27')]({'plain':!![]});var _0x35cf3a='DefaultReports';return db[_0x7813('0x28')][_0x7813('0x29')]({'where':{'type':_0x35cf3a,'resourceId':_0x5188b0['id']}})[_0x7813('0x26')](function(){return _0x1902d2;});})[_0x7813('0x26')](function(){_0x8983c['status'](0xcc)[_0x7813('0x1c')]();});}};}function handleEntityNotFound(_0x39b26b,_0x2eda3a){return function(_0x7a0190){if(!_0x7a0190){_0x39b26b['sendStatus'](0x194);}return _0x7a0190;};}function handleError(_0x20461f,_0x53f3d4){_0x53f3d4=_0x53f3d4||0x1f4;return function(_0x2544eb){logger[_0x7813('0x2a')](_0x2544eb[_0x7813('0x2b')]);if(_0x2544eb[_0x7813('0x2c')]){delete _0x2544eb[_0x7813('0x2c')];}_0x20461f['status'](_0x53f3d4)['send'](_0x2544eb);};}exports[_0x7813('0x2d')]=function(_0x336db2,_0x539994){var _0x42492e={},_0x2e450e={},_0x5b6476={'count':0x0,'rows':[]};var _0x316c98=db[_0x7813('0x2e')][_0x7813('0x2f')];_0x2e450e[_0x7813('0x30')]=_[_0x7813('0x31')](_0x316c98);_0x2e450e[_0x7813('0x32')]=_[_0x7813('0x31')](_0x336db2[_0x7813('0x32')]);_0x2e450e[_0x7813('0x33')]=_[_0x7813('0x34')](_0x2e450e[_0x7813('0x30')],_0x2e450e[_0x7813('0x32')]);_0x42492e[_0x7813('0x35')]=_[_0x7813('0x34')](_0x2e450e[_0x7813('0x30')],qs['fields'](_0x336db2['query'][_0x7813('0x36')]));_0x42492e['attributes']=_0x42492e[_0x7813('0x35')][_0x7813('0x37')]?_0x42492e[_0x7813('0x35')]:_0x2e450e[_0x7813('0x30')];if(!_0x336db2[_0x7813('0x32')][_0x7813('0x38')]('nolimit')){_0x42492e[_0x7813('0x20')]=qs[_0x7813('0x20')](_0x336db2[_0x7813('0x32')][_0x7813('0x20')]);_0x42492e[_0x7813('0x1f')]=qs[_0x7813('0x1f')](_0x336db2[_0x7813('0x32')]['offset']);}_0x42492e[_0x7813('0x39')]=qs[_0x7813('0x3a')](_0x336db2[_0x7813('0x32')][_0x7813('0x3a')]);_0x42492e[_0x7813('0x3b')]=qs[_0x7813('0x33')](_[_0x7813('0x3c')](_0x336db2['query'],_0x2e450e['filters']));if(_0x336db2[_0x7813('0x32')][_0x7813('0x3d')]){_0x42492e['where']=_[_0x7813('0x3e')](_0x42492e[_0x7813('0x3b')],{'$or':_['map'](_0x316c98,function(_0x129ea6){if(_0x129ea6[_0x7813('0x3f')][_0x7813('0x40')]!==_0x7813('0x41')){var _0x23e3ac={};_0x23e3ac[_0x129ea6['field']]={'$like':'%'+_0x336db2[_0x7813('0x32')][_0x7813('0x3d')]+'%'};return _0x23e3ac;}})});}_0x42492e=_[_0x7813('0x3e')]({},_0x42492e,_0x336db2[_0x7813('0x42')]);var _0x5750ff={'where':_0x42492e[_0x7813('0x3b')]};return db[_0x7813('0x2e')][_0x7813('0x1e')](_0x5750ff)['then'](function(_0x40fd73){_0x5b6476['count']=_0x40fd73;if(_0x336db2[_0x7813('0x32')][_0x7813('0x43')]){_0x42492e[_0x7813('0x44')]=[{'all':!![]}];}return db[_0x7813('0x2e')][_0x7813('0x45')](_0x42492e);})['then'](function(_0x42fcf6){_0x5b6476[_0x7813('0x46')]=_0x42fcf6;return _0x5b6476;})['then'](respondWithFilteredResult(_0x539994,_0x42492e))[_0x7813('0x47')](handleError(_0x539994,null));};exports[_0x7813('0x48')]=function(_0x2a1328,_0x5a1bce){var _0x145b57={'raw':!![],'where':{'id':_0x2a1328['params']['id']}},_0x3cc204={};_0x3cc204['model']=_[_0x7813('0x31')](db[_0x7813('0x2e')]['rawAttributes']);_0x3cc204[_0x7813('0x32')]=_['keys'](_0x2a1328['query']);_0x3cc204[_0x7813('0x33')]=_[_0x7813('0x34')](_0x3cc204[_0x7813('0x30')],_0x3cc204[_0x7813('0x32')]);_0x145b57[_0x7813('0x35')]=_[_0x7813('0x34')](_0x3cc204[_0x7813('0x30')],qs['fields'](_0x2a1328[_0x7813('0x32')][_0x7813('0x36')]));_0x145b57['attributes']=_0x145b57['attributes'][_0x7813('0x37')]?_0x145b57[_0x7813('0x35')]:_0x3cc204[_0x7813('0x30')];if(_0x2a1328['query'][_0x7813('0x43')]){_0x145b57[_0x7813('0x44')]=[{'all':!![]}];}_0x145b57=_[_0x7813('0x3e')]({},_0x145b57,_0x2a1328['options']);return db[_0x7813('0x2e')]['find'](_0x145b57)['then'](handleEntityNotFound(_0x5a1bce,null))[_0x7813('0x26')](respondWithResult(_0x5a1bce,null))[_0x7813('0x47')](handleError(_0x5a1bce,null));};exports[_0x7813('0x49')]=function(_0x5d423d,_0x280226){return db[_0x7813('0x2e')]['create'](_0x5d423d['body'],{})[_0x7813('0x26')](function(_0xed119b){var _0x39899e=_0x5d423d['user'][_0x7813('0x27')]({'plain':!![]});if(!_0x39899e)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x39899e[_0x7813('0x4a')]===_0x7813('0x4b')){var _0x4b3461=_0xed119b['get']({'plain':!![]});var _0x4f1d40=_0x7813('0x4c');return db['UserProfileSection'][_0x7813('0x4d')]({'where':{'name':_0x4f1d40,'userProfileId':_0x39899e[_0x7813('0x4e')]},'raw':!![]})[_0x7813('0x26')](function(_0x5ac55f){if(_0x5ac55f&&_0x5ac55f[_0x7813('0x4f')]===0x0){return db[_0x7813('0x28')][_0x7813('0x49')]({'name':_0x4b3461['name'],'resourceId':_0x4b3461['id'],'type':_0x7813('0x50'),'sectionId':_0x5ac55f['id']},{})['then'](function(){return _0xed119b;});}else{return _0xed119b;}})[_0x7813('0x47')](function(_0x17f388){logger[_0x7813('0x2a')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x17f388);throw _0x17f388;});}return _0xed119b;})[_0x7813('0x26')](respondWithResult(_0x280226,0xc9))[_0x7813('0x47')](handleError(_0x280226,null));};exports[_0x7813('0x25')]=function(_0x53878e,_0x452173){if(_0x53878e[_0x7813('0x51')]['id']){delete _0x53878e[_0x7813('0x51')]['id'];}return db[_0x7813('0x2e')][_0x7813('0x4d')]({'where':{'id':_0x53878e[_0x7813('0x52')]['id']}})[_0x7813('0x26')](handleEntityNotFound(_0x452173,null))[_0x7813('0x26')](saveUpdates(_0x53878e['body'],null))[_0x7813('0x26')](respondWithResult(_0x452173,null))[_0x7813('0x47')](handleError(_0x452173,null));};exports[_0x7813('0x29')]=function(_0x27e11a,_0x1b3668){return db['AnalyticDefaultReport'][_0x7813('0x4d')]({'where':{'id':_0x27e11a[_0x7813('0x52')]['id']}})[_0x7813('0x26')](handleEntityNotFound(_0x1b3668,null))[_0x7813('0x26')](removeEntity(_0x1b3668,null))[_0x7813('0x47')](handleError(_0x1b3668,null));};exports[_0x7813('0x53')]=function(_0x29ebb4,_0x4e020a){var _0x574434=0xa;var _0x21371c=[_0x7813('0x54'),_0x7813('0x55'),_0x7813('0x56'),_0x7813('0x57')];var _0x574d1c={'SUM':'SUM(%s)','COUNT':_0x7813('0x58'),'COUNT DISTINCT':_0x7813('0x59'),'MAX':_0x7813('0x5a'),'MIN':_0x7813('0x5b'),'AVG':'AVG(%s)','GROUP_CONCAT':_0x7813('0x5c'),'GROUP_CONCAT ASC':_0x7813('0x5d'),'GROUP_CONCAT DESC':_0x7813('0x5e')};var _0x3fe98d={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x7813('0x5f'),'HOUR':_0x7813('0x60'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x579b05=function(_0x40fa3d){return!_[_0x7813('0x61')]([_0x7813('0x62'),_0x7813('0x63'),_0x7813('0x64'),_0x7813('0x65')],_0x40fa3d);};var _0xfc4b2e=function(_0x90109d){if(!_0x90109d||!_0x90109d[_0x7813('0x66')][_0x7813('0x37')]){return'';}for(var _0x417882='(',_0x1d97aa=0x0;_0x1d97aa<_0x90109d['rules']['length'];_0x1d97aa+=0x1){_0x1d97aa>0x0&&(_0x417882+='\x20'+_0x90109d[_0x7813('0x67')]+'\x20');_0x417882+=_0x90109d['rules'][_0x1d97aa][_0x7813('0x68')]?_0xfc4b2e(_0x90109d[_0x7813('0x66')][_0x1d97aa][_0x7813('0x68')]):_0x90109d[_0x7813('0x66')][_0x1d97aa]['field']+'\x20'+_0x90109d[_0x7813('0x66')][_0x1d97aa][_0x7813('0x69')]+(_0x579b05(_0x90109d[_0x7813('0x66')][_0x1d97aa]['condition'])?'\x20'+_0x90109d[_0x7813('0x66')][_0x1d97aa][_0x7813('0x6a')]:'');}return _0x417882+')';};var _0x38eca0={'where':{'id':_0x29ebb4[_0x7813('0x52')]['id']}},_0x10c9d3,_0x50baa7,_0x49dcbe,_0x5ace3a,_0x26caad;_0x38eca0=_['merge']({},_0x38eca0,_0x29ebb4['options']);return db[_0x7813('0x2e')][_0x7813('0x4d')](_0x38eca0)[_0x7813('0x26')](function(_0x2bfa11){if(_0x2bfa11){_0x10c9d3=_0x2bfa11;return _0x2bfa11[_0x7813('0x6b')]();}return null;})[_0x7813('0x26')](function(_0x4de48e){if(_0x4de48e){if(!_0x4de48e[_0x7813('0x37')]){throw new db['Sequelize']['ValidationErrorItem'](_0x7813('0x6c'),0x193);}_0x50baa7=_0x4de48e;return db[_0x7813('0x6d')][_0x7813('0x45')]({'raw':!![]});}return null;})[_0x7813('0x26')](function(_0x1a4f82){if(_0x1a4f82){_0x49dcbe=_[_0x7813('0x6e')](_0x1a4f82,'id');var _0xd4fe81;var _0xb7b1f=squel[_0x7813('0x6f')]();_0xb7b1f['from'](_0x10c9d3[_0x7813('0x70')]);for(var _0x2bd01b=0x0;_0x2bd01b<_0x50baa7[_0x7813('0x37')];_0x2bd01b+=0x1){_0xd4fe81=_0x50baa7[_0x2bd01b][_0x7813('0x71')]?_0x49dcbe[_0x50baa7[_0x2bd01b][_0x7813('0x71')]]['metric']:_0x50baa7[_0x2bd01b][_0x7813('0x72')];_0xd4fe81=_0x50baa7[_0x2bd01b][_0x7813('0x73')]?_[_0x7813('0x74')](_0x574d1c[_0x50baa7[_0x2bd01b][_0x7813('0x73')]],'%s',_0xd4fe81):_0xd4fe81;_0xd4fe81=_0x50baa7[_0x2bd01b]['format']?_[_0x7813('0x74')](_0x3fe98d[_0x50baa7[_0x2bd01b][_0x7813('0x75')]],'%s',_0xd4fe81):_0xd4fe81;if(_0x50baa7[_0x2bd01b][_0x7813('0x76')]){_0xb7b1f['group'](_0xd4fe81);}_0x50baa7[_0x2bd01b][_0x7813('0x77')]&&_0xb7b1f[_0x7813('0x39')](_0xd4fe81,_0x50baa7[_0x2bd01b]['orderBy']===_0x7813('0x78')?![]:!![]);_0xb7b1f[_0x7813('0x72')](_0xd4fe81,_0x50baa7[_0x2bd01b][_0x7813('0x79')]||_0xd4fe81);}if(_0x10c9d3[_0x7813('0x7a')]){_0x10c9d3[_0x7813('0x7a')]=JSON[_0x7813('0x7b')](_0x10c9d3[_0x7813('0x7a')]);for(var _0x2eea3b=0x0;_0x2eea3b<_0x10c9d3[_0x7813('0x7a')][_0x7813('0x37')];_0x2eea3b+=0x1){if(_0x10c9d3[_0x7813('0x7a')][_0x2eea3b]['type']&&_['includes'](_0x21371c,_0x10c9d3['joins'][_0x2eea3b]['type'])&&_0x10c9d3['joins'][_0x2eea3b]['parentKey']&&_0x10c9d3[_0x7813('0x7a')][_0x2eea3b]['foreignTable']&&_0x10c9d3[_0x7813('0x7a')][_0x2eea3b][_0x7813('0x7c')]){_0xb7b1f[_0x10c9d3[_0x7813('0x7a')][_0x2eea3b][_0x7813('0x3f')]](_0x10c9d3[_0x7813('0x7a')][_0x2eea3b]['foreignTable'],null,util['format'](_0x7813('0x7d'),_0x10c9d3['table'],_0x10c9d3[_0x7813('0x7a')][_0x2eea3b][_0x7813('0x7e')],_0x10c9d3[_0x7813('0x7a')][_0x2eea3b][_0x7813('0x7f')],_0x10c9d3[_0x7813('0x7a')][_0x2eea3b][_0x7813('0x7c')]));}}}if(_0x10c9d3[_0x7813('0x80')]){_0x10c9d3[_0x7813('0x80')]=JSON[_0x7813('0x7b')](_0x10c9d3[_0x7813('0x80')]);_0xb7b1f[_0x7813('0x3b')](_0xfc4b2e(_0x10c9d3[_0x7813('0x80')][_0x7813('0x68')]));}_0x26caad=_0xb7b1f[_0x7813('0x81')]();_0xb7b1f[_0x7813('0x20')](_0x574434);_0xb7b1f['offset'](0x0);logger[_0x7813('0x82')](_0x7813('0x83'),_0xb7b1f['toString']());return db[_0x7813('0x84')][_0x7813('0x32')](_0xb7b1f[_0x7813('0x85')](),{'type':db[_0x7813('0x84')][_0x7813('0x86')]['SELECT']});}})[_0x7813('0x26')](respondWithResult(_0x4e020a,null))[_0x7813('0x47')](handleError(_0x4e020a,null));};function runReport(_0x5c4ee0,_0x263e97,_0x227b95){var _0x3c5e4a=_0x263e97[_0x7813('0x2c')];var _0x43e9ce=0xa;var _0x308557=[_0x7813('0x54'),_0x7813('0x55'),_0x7813('0x56'),_0x7813('0x57')];var _0x217e94={'SUM':_0x7813('0x87'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x7813('0x59'),'MAX':'MAX(%s)','MIN':_0x7813('0x5b'),'AVG':'AVG(%s)','GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x7813('0x5d'),'GROUP_CONCAT DESC':_0x7813('0x5e')};var _0x5e5ac4={'SEC_TO_TIME':_0x7813('0x88'),'DATE':_0x7813('0x5f'),'HOUR':'HOUR(%s)','ROUND':_0x7813('0x89'),'UNIX_TIMESTAMP':_0x7813('0x8a')};var _0x4fb8d6=function(_0x32ebe6){return!_['includes']([_0x7813('0x62'),_0x7813('0x63'),_0x7813('0x64'),'IS\x20NOT\x20EMPTY'],_0x32ebe6);};var _0x43bb46=function(_0x4cb68e){if(!_0x4cb68e||!_0x4cb68e[_0x7813('0x66')][_0x7813('0x37')]){return'';}for(var _0x5978e8='(',_0x2bea06=0x0;_0x2bea06<_0x4cb68e[_0x7813('0x66')][_0x7813('0x37')];_0x2bea06+=0x1){_0x2bea06>0x0&&(_0x5978e8+='\x20'+_0x4cb68e['operator']+'\x20');_0x5978e8+=_0x4cb68e[_0x7813('0x66')][_0x2bea06][_0x7813('0x68')]?_0x43bb46(_0x4cb68e[_0x7813('0x66')][_0x2bea06]['group']):_0x4cb68e['rules'][_0x2bea06]['field']+'\x20'+_0x4cb68e[_0x7813('0x66')][_0x2bea06][_0x7813('0x69')]+(_0x4fb8d6(_0x4cb68e['rules'][_0x2bea06][_0x7813('0x69')])?'\x20'+_0x4cb68e[_0x7813('0x66')][_0x2bea06]['value']:'');}return _0x5978e8+')';};var _0x1189e6={'where':{'id':_0x5c4ee0['id']}},_0x27fe2f,_0xeba775,_0x2f5cf5,_0xf97f84,_0x90a91f;_0x1189e6=_[_0x7813('0x3e')]({},_0x1189e6,_0x227b95);return db[_0x7813('0x2e')][_0x7813('0x4d')](_0x1189e6)[_0x7813('0x26')](function(_0x31cf03){if(_0x31cf03){_0x27fe2f=_0x31cf03;return _0x31cf03[_0x7813('0x6b')]();}return null;})['then'](function(_0x354b95){if(_0x354b95){if(!_0x354b95['length']){throw new db[(_0x7813('0x8b'))][(_0x7813('0x8c'))](_0x7813('0x6c'),0x193);}_0xeba775=_0x354b95;return db['AnalyticMetric'][_0x7813('0x45')]({'raw':!![]});}return null;})[_0x7813('0x26')](function(_0x16fb88){if(_0x16fb88){_0x2f5cf5=_['keyBy'](_0x16fb88,'id');var _0x26175a;var _0x632037=squel['select']();_0x632037[_0x7813('0x8d')](_0x27fe2f[_0x7813('0x70')]);for(var _0x242383=0x0;_0x242383<_0xeba775[_0x7813('0x37')];_0x242383+=0x1){_0x26175a=_0xeba775[_0x242383][_0x7813('0x71')]?_0x2f5cf5[_0xeba775[_0x242383][_0x7813('0x71')]][_0x7813('0x8e')]:_0xeba775[_0x242383]['field'];_0x26175a=_0xeba775[_0x242383][_0x7813('0x73')]?_[_0x7813('0x74')](_0x217e94[_0xeba775[_0x242383][_0x7813('0x73')]],'%s',_0x26175a):_0x26175a;_0x26175a=_0xeba775[_0x242383][_0x7813('0x75')]?_[_0x7813('0x74')](_0x5e5ac4[_0xeba775[_0x242383]['format']],'%s',_0x26175a):_0x26175a;if(_0xeba775[_0x242383][_0x7813('0x76')]){_0x632037[_0x7813('0x68')](_0x26175a);}_0xeba775[_0x242383][_0x7813('0x77')]&&_0x632037[_0x7813('0x39')](_0x26175a,_0xeba775[_0x242383][_0x7813('0x77')]===_0x7813('0x78')?![]:!![]);_0x632037[_0x7813('0x72')](_0x26175a,_0xeba775[_0x242383][_0x7813('0x79')]||_0x26175a);}if(_0x27fe2f[_0x7813('0x7a')]){_0x27fe2f[_0x7813('0x7a')]=JSON[_0x7813('0x7b')](_0x27fe2f['joins']);for(var _0x1bcca6=0x0;_0x1bcca6<_0x27fe2f[_0x7813('0x7a')]['length'];_0x1bcca6+=0x1){if(_0x27fe2f['joins'][_0x1bcca6]['type']&&_[_0x7813('0x61')](_0x308557,_0x27fe2f[_0x7813('0x7a')][_0x1bcca6][_0x7813('0x3f')])&&_0x27fe2f[_0x7813('0x7a')][_0x1bcca6][_0x7813('0x7e')]&&_0x27fe2f['joins'][_0x1bcca6]['foreignTable']&&_0x27fe2f[_0x7813('0x7a')][_0x1bcca6][_0x7813('0x7c')]){_0x632037[_0x27fe2f[_0x7813('0x7a')][_0x1bcca6]['type']](_0x27fe2f[_0x7813('0x7a')][_0x1bcca6][_0x7813('0x7f')],null,util['format'](_0x7813('0x7d'),_0x27fe2f['table'],_0x27fe2f[_0x7813('0x7a')][_0x1bcca6][_0x7813('0x7e')],_0x27fe2f['joins'][_0x1bcca6][_0x7813('0x7f')],_0x27fe2f[_0x7813('0x7a')][_0x1bcca6][_0x7813('0x7c')]));}}}if(_0x27fe2f['conditions']){_0x27fe2f[_0x7813('0x80')]=JSON[_0x7813('0x7b')](_0x27fe2f[_0x7813('0x80')]);_0x632037[_0x7813('0x3b')](_0x43bb46(_0x27fe2f[_0x7813('0x80')][_0x7813('0x68')]));}_0x90a91f=_0x632037['clone']();_0x632037[_0x7813('0x20')](_0x43e9ce);_0x632037['offset'](0x0);logger[_0x7813('0x82')](_0x7813('0x83'),_0x632037[_0x7813('0x85')]());return db[_0x7813('0x84')]['query'](_0x632037['toString'](),{'type':db[_0x7813('0x84')][_0x7813('0x86')][_0x7813('0x8f')]});}})['then'](function(_0x5093a6){if(!_0x5093a6['length']){throw new db[(_0x7813('0x8b'))][(_0x7813('0x8c'))]('No\x20available\x20data',0xcc);}if(_0x263e97[_0x7813('0x90')]===_0x7813('0x91')){return null;}var _0x49fb93=_[_0x7813('0x3e')](_0x263e97,{'name':_0x263e97['fullPath']||_0x263e97[_0x7813('0x2c')]||_0x27fe2f['name'],'basename':_0x3c5e4a,'savename':util[_0x7813('0x75')]('%s-%s.%s',_0x263e97['name']||_0x27fe2f['name'],require(_0x7813('0x92'))[_0x7813('0x93')](0x4),_0x263e97['output']||_0x7813('0x94')),'reportId':_0x27fe2f['id'],'reportType':'default'});return db[_0x7813('0x95')][_0x7813('0x49')](_0x49fb93,{'raw':!![]});})['then'](function(_0xe154b9){if(_0x27fe2f[_0x7813('0x70')]==='cdr'){_0x90a91f[_0x7813('0x3b')](_0x27fe2f['table']+_0x7813('0x96'),_0x263e97[_0x7813('0x97')],_0x263e97[_0x7813('0x98')]);}else{_0x90a91f[_0x7813('0x3b')](_0x27fe2f[_0x7813('0x70')]+_0x7813('0x99'),_0x263e97['startDate'],_0x263e97[_0x7813('0x98')]);}if(_0xe154b9){logger[_0x7813('0x9a')](_0x7813('0x9b'),_0x90a91f[_0x7813('0x85')]());require(_0x7813('0x9c'))[_0x7813('0x9d')](path[_0x7813('0x54')](__dirname,_0x7813('0x9e'),_0xe154b9[_0x7813('0x90')]),[_0xe154b9['id'],_0x90a91f['toString'](),path['join'](__dirname,_0x7813('0x9f'),_0xe154b9['savename']),_0x3c5e4a]);return _0xe154b9;}else{var _0x1fd50e=squel[_0x7813('0x6f')]();_0x1fd50e[_0x7813('0x8d')]('('+_0x90a91f[_0x7813('0x85')]()+')','countTable');_0x1fd50e[_0x7813('0x72')](_0x7813('0xa0'),_0x7813('0x1e'));_0x90a91f[_0x7813('0x20')](_0x263e97[_0x7813('0x20')]||_0x43e9ce);_0x90a91f[_0x7813('0x1f')](_0x263e97['offset']||0x0);return db[_0x7813('0x84')][_0x7813('0x32')](_0x1fd50e[_0x7813('0x85')](),{'type':db[_0x7813('0x84')][_0x7813('0x86')][_0x7813('0x8f')]})[_0x7813('0x26')](function(_0x5b237e){if(!_0x5b237e['length']){_0xf97f84=0x0;}else{_0xf97f84=_0x5b237e[0x0]['count']||0x0;}return db['sequelize'][_0x7813('0x32')](_0x90a91f[_0x7813('0x85')](),{'type':db[_0x7813('0x84')]['QueryTypes'][_0x7813('0x8f')]});})[_0x7813('0x26')](function(_0x467331){return{'rows':_0x467331||[],'count':_0xf97f84};});}});}exports[_0x7813('0xa1')]=function(_0x2e63a5,_0x5cca34){return runReport(_0x2e63a5[_0x7813('0x52')],_0x2e63a5[_0x7813('0x32')],_0x2e63a5[_0x7813('0x42')])[_0x7813('0x26')](respondWithResult(_0x5cca34,null))['catch'](handleError(_0x5cca34,null));};exports[_0x7813('0xa2')]=runReport;exports[_0x7813('0x32')]=function(_0x4181be,_0x330901){var _0x57cb76=0xa;var _0x1b905c=['join',_0x7813('0x55'),_0x7813('0x56'),_0x7813('0x57')];var _0xffe031={'SUM':_0x7813('0x87'),'COUNT':_0x7813('0x58'),'COUNT DISTINCT':_0x7813('0x59'),'MAX':_0x7813('0x5a'),'MIN':_0x7813('0x5b'),'AVG':_0x7813('0xa3'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x7813('0x5d'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x41cfb5={'SEC_TO_TIME':_0x7813('0x88'),'DATE':_0x7813('0x5f'),'HOUR':_0x7813('0x60'),'ROUND':_0x7813('0x89'),'UNIX_TIMESTAMP':_0x7813('0x8a')};var _0x4f0e24=function(_0x257615){return!_['includes']([_0x7813('0x62'),_0x7813('0x63'),'IS\x20EMPTY','IS\x20NOT\x20EMPTY'],_0x257615);};var _0x30a260=function(_0x188374){if(!_0x188374||!_0x188374['rules'][_0x7813('0x37')]){return'';}for(var _0xdcd30='(',_0xd21ca1=0x0;_0xd21ca1<_0x188374[_0x7813('0x66')][_0x7813('0x37')];_0xd21ca1+=0x1){_0xd21ca1>0x0&&(_0xdcd30+='\x20'+_0x188374[_0x7813('0x67')]+'\x20');_0xdcd30+=_0x188374[_0x7813('0x66')][_0xd21ca1]['group']?_0x30a260(_0x188374['rules'][_0xd21ca1]['group']):_0x188374['rules'][_0xd21ca1]['field']+'\x20'+_0x188374['rules'][_0xd21ca1][_0x7813('0x69')]+(_0x4f0e24(_0x188374[_0x7813('0x66')][_0xd21ca1][_0x7813('0x69')])?'\x20'+_0x188374['rules'][_0xd21ca1][_0x7813('0x6a')]:'');}return _0xdcd30+')';};var _0x34fa5b={'where':{'id':_0x4181be[_0x7813('0x52')]['id']}},_0x436435,_0x5ed404,_0x1e46fe,_0x2cd343,_0x5f49e4;_0x34fa5b=_[_0x7813('0x3e')]({},_0x34fa5b,_0x4181be[_0x7813('0x42')]);return db['AnalyticDefaultReport'][_0x7813('0x4d')](_0x34fa5b)['then'](function(_0x3899f9){if(_0x3899f9){_0x436435=_0x3899f9;return _0x3899f9[_0x7813('0x6b')]();}return null;})[_0x7813('0x26')](function(_0x1585bb){if(_0x1585bb){if(!_0x1585bb[_0x7813('0x37')]){throw new db['Sequelize']['ValidationErrorItem'](_0x7813('0x6c'),0x193);}_0x5ed404=_0x1585bb;return db['AnalyticMetric']['findAll']({'raw':!![]});}return null;})[_0x7813('0x26')](function(_0x589a1b){if(_0x589a1b){_0x1e46fe=_[_0x7813('0x6e')](_0x589a1b,'id');var _0x1247f5;var _0x49ffcf=squel[_0x7813('0x6f')]();_0x49ffcf[_0x7813('0x8d')](_0x436435[_0x7813('0x70')]);for(var _0x15f0a9=0x0;_0x15f0a9<_0x5ed404['length'];_0x15f0a9+=0x1){_0x1247f5=_0x5ed404[_0x15f0a9][_0x7813('0x71')]?_0x1e46fe[_0x5ed404[_0x15f0a9][_0x7813('0x71')]]['metric']:_0x5ed404[_0x15f0a9][_0x7813('0x72')];_0x1247f5=_0x5ed404[_0x15f0a9][_0x7813('0x73')]?_[_0x7813('0x74')](_0xffe031[_0x5ed404[_0x15f0a9][_0x7813('0x73')]],'%s',_0x1247f5):_0x1247f5;_0x1247f5=_0x5ed404[_0x15f0a9][_0x7813('0x75')]?_[_0x7813('0x74')](_0x41cfb5[_0x5ed404[_0x15f0a9][_0x7813('0x75')]],'%s',_0x1247f5):_0x1247f5;if(_0x5ed404[_0x15f0a9]['groupBy']){_0x49ffcf[_0x7813('0x68')](_0x1247f5);}_0x5ed404[_0x15f0a9][_0x7813('0x77')]&&_0x49ffcf[_0x7813('0x39')](_0x1247f5,_0x5ed404[_0x15f0a9][_0x7813('0x77')]==='DESC'?![]:!![]);_0x49ffcf[_0x7813('0x72')](_0x1247f5,_0x5ed404[_0x15f0a9][_0x7813('0x79')]||_0x1247f5);}if(_0x436435[_0x7813('0x7a')]){_0x436435[_0x7813('0x7a')]=JSON['parse'](_0x436435[_0x7813('0x7a')]);for(var _0x3403a5=0x0;_0x3403a5<_0x436435[_0x7813('0x7a')][_0x7813('0x37')];_0x3403a5+=0x1){if(_0x436435['joins'][_0x3403a5][_0x7813('0x3f')]&&_['includes'](_0x1b905c,_0x436435[_0x7813('0x7a')][_0x3403a5]['type'])&&_0x436435[_0x7813('0x7a')][_0x3403a5]['parentKey']&&_0x436435[_0x7813('0x7a')][_0x3403a5]['foreignTable']&&_0x436435[_0x7813('0x7a')][_0x3403a5][_0x7813('0x7c')]){_0x49ffcf[_0x436435[_0x7813('0x7a')][_0x3403a5]['type']](_0x436435[_0x7813('0x7a')][_0x3403a5][_0x7813('0x7f')],null,util['format'](_0x7813('0x7d'),_0x436435[_0x7813('0x70')],_0x436435[_0x7813('0x7a')][_0x3403a5][_0x7813('0x7e')],_0x436435['joins'][_0x3403a5][_0x7813('0x7f')],_0x436435[_0x7813('0x7a')][_0x3403a5][_0x7813('0x7c')]));}}}if(_0x436435[_0x7813('0x80')]){_0x436435[_0x7813('0x80')]=JSON[_0x7813('0x7b')](_0x436435[_0x7813('0x80')]);_0x49ffcf[_0x7813('0x3b')](_0x30a260(_0x436435[_0x7813('0x80')]['group']));}_0x5f49e4=_0x49ffcf[_0x7813('0x81')]();_0x49ffcf['limit'](_0x57cb76);_0x49ffcf[_0x7813('0x1f')](0x0);logger['debug'](_0x7813('0x83'),_0x49ffcf[_0x7813('0x85')]());return db[_0x7813('0x84')][_0x7813('0x32')](_0x49ffcf['toString'](),{'type':db[_0x7813('0x84')][_0x7813('0x86')][_0x7813('0x8f')]});}})['then'](function(){return{'sql':_0x5f49e4[_0x7813('0x85')]()};})[_0x7813('0x26')](respondWithResult(_0x330901,null))[_0x7813('0x47')](handleError(_0x330901,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff