// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xf3f8=['fast-json-patch','request-promise','moment','mustache','util','sox','to-csv','ejs','fs-extra','lodash','squel','jsforce','desk.js','querystring','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/environment','../../config/license/util','../../mysqldb','dbH','end','json','offset','undefined','limit','count','status','set','Content-Range','apply','reject','save','destroy','then','get','CustomReports','error','stack','name','render','body','message','agent','interaction','account','index','map','AnalyticCustomReport','rawAttributes','type','model','query','keys','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','merge','VIRTUAL','options','includeAll','findAll','rows','catch','show','params','include','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','find','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','join','right_join','cross_join','COUNT(%s)','MAX(%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)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','rules','operator','group','field','condition','value','Sequelize','ValidationErrorItem','AnalyticMetric','keyBy','select','from','table','MetricId','metric','function','replace','format','groupBy','orderBy','DESC','alias','joins','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','parentKey','conditions','parse','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','left_join','SUM(%s)','COUNT(DISTINCT\x20%s)','AVG(%s)','ROUND(%s)','getFields','Please\x20insert\x20at\x20least\x20one\x20field','web','%s-%s.%s','randomstring','generate','output','csv','custom','AnalyticExtractedReport','cdr','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','Run\x20Query:','child_process','fork','../../components/export/','../../files/reports','savename','countTable','run','runReport','MIN(%s)','IS\x20NOT\x20EMPTY','rimraf','zip-dir'];(function(_0xd421d7,_0x59635e){var _0x4a8eb4=function(_0x74aa1a){while(--_0x74aa1a){_0xd421d7['push'](_0xd421d7['shift']());}};_0x4a8eb4(++_0x59635e);}(_0xf3f8,0xa7));var _0x8f3f=function(_0x5f31fe,_0x465734){_0x5f31fe=_0x5f31fe-0x0;var _0x14eb19=_0xf3f8[_0x5f31fe];return _0x14eb19;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x8f3f('0x0'));var zipdir=require(_0x8f3f('0x1'));var jsonpatch=require(_0x8f3f('0x2'));var rp=require(_0x8f3f('0x3'));var moment=require(_0x8f3f('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x8f3f('0x5'));var util=require(_0x8f3f('0x6'));var path=require('path');var sox=require(_0x8f3f('0x7'));var csv=require(_0x8f3f('0x8'));var ejs=require(_0x8f3f('0x9'));var fs=require('fs');var fs_extra=require(_0x8f3f('0xa'));var _=require(_0x8f3f('0xb'));var squel=require(_0x8f3f('0xc'));var crypto=require('crypto');var jsforce=require(_0x8f3f('0xd'));var deskjs=require(_0x8f3f('0xe'));var toCsv=require('to-csv');var querystring=require(_0x8f3f('0xf'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0x8f3f('0x10'));var as=require(_0x8f3f('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')('api');var utils=require('../../config/utils');var config=require(_0x8f3f('0x12'));var licenseUtil=require(_0x8f3f('0x13'));var db=require(_0x8f3f('0x14'))['db'];var dbH=require('../../mysqldb')[_0x8f3f('0x15')];function respondWithStatusCode(_0x1b203b,_0x3c3d1a){_0x3c3d1a=_0x3c3d1a||0xcc;return function(_0x42dfb7){if(_0x42dfb7){return _0x1b203b['sendStatus'](_0x3c3d1a);}return _0x1b203b['status'](_0x3c3d1a)[_0x8f3f('0x16')]();};}function respondWithResult(_0x56980d,_0x33d77d){_0x33d77d=_0x33d77d||0xc8;return function(_0x1bac66){if(_0x1bac66){return _0x56980d['status'](_0x33d77d)[_0x8f3f('0x17')](_0x1bac66);}};}function respondWithFilteredResult(_0x1fddda,_0x2c5623){return function(_0x50d0eb){if(_0x50d0eb){var _0x24cbb3=typeof _0x2c5623[_0x8f3f('0x18')]===_0x8f3f('0x19')&&typeof _0x2c5623[_0x8f3f('0x1a')]===_0x8f3f('0x19');var _0xf34423=_0x50d0eb[_0x8f3f('0x1b')];var _0x5c6aee=_0x24cbb3?0x0:_0x2c5623[_0x8f3f('0x18')];var _0x45d8ff=_0x24cbb3?_0x50d0eb[_0x8f3f('0x1b')]:_0x2c5623[_0x8f3f('0x18')]+_0x2c5623['limit'];var _0x4af487;if(_0x45d8ff>=_0xf34423){_0x45d8ff=_0xf34423;_0x4af487=0xc8;}else{_0x4af487=0xce;}_0x1fddda[_0x8f3f('0x1c')](_0x4af487);return _0x1fddda[_0x8f3f('0x1d')](_0x8f3f('0x1e'),_0x5c6aee+'-'+_0x45d8ff+'/'+_0xf34423)[_0x8f3f('0x17')](_0x50d0eb);}return null;};}function patchUpdates(_0x54a7ef){return function(_0xbcb522){try{jsonpatch[_0x8f3f('0x1f')](_0xbcb522,_0x54a7ef,!![]);}catch(_0x55502f){return BPromise[_0x8f3f('0x20')](_0x55502f);}return _0xbcb522[_0x8f3f('0x21')]();};}function saveUpdates(_0x5aafa2,_0x1e674f){return function(_0x5efb98){if(_0x5efb98){return _0x5efb98['update'](_0x5aafa2)['then'](function(_0x2c00c2){return _0x2c00c2;});}return null;};}function removeEntity(_0x3e1e17,_0xc05329){return function(_0x5d65f6){if(_0x5d65f6){return _0x5d65f6[_0x8f3f('0x22')]()[_0x8f3f('0x23')](function(){var _0x4fc460=_0x5d65f6[_0x8f3f('0x24')]({'plain':!![]});var _0x314471=_0x8f3f('0x25');return db['UserProfileResource']['destroy']({'where':{'type':_0x314471,'resourceId':_0x4fc460['id']}})[_0x8f3f('0x23')](function(){return _0x5d65f6;});})[_0x8f3f('0x23')](function(){_0x3e1e17[_0x8f3f('0x1c')](0xcc)['end']();});}};}function handleEntityNotFound(_0x50567a,_0x21b3a1){return function(_0x2a51e3){if(!_0x2a51e3){_0x50567a['sendStatus'](0x194);}return _0x2a51e3;};}function handleError(_0x29912f,_0x5275d4){_0x5275d4=_0x5275d4||0x1f4;return function(_0x86f093){logger[_0x8f3f('0x26')](_0x86f093[_0x8f3f('0x27')]);if(_0x86f093[_0x8f3f('0x28')]){delete _0x86f093[_0x8f3f('0x28')];}_0x29912f[_0x8f3f('0x1c')](_0x5275d4)['send'](_0x86f093);};}function getMustacheRender(_0x31f19a,_0x3d0a3f){return Mustache[_0x8f3f('0x29')](_0x31f19a,_['merge'](_0x3d0a3f[_0x8f3f('0x2a')],{'contact':_0x3d0a3f['contact'],'message':_0x3d0a3f[_0x8f3f('0x2b')],'agent':_0x3d0a3f[_0x8f3f('0x2c')],'interaction':_0x3d0a3f[_0x8f3f('0x2d')],'account':_0x3d0a3f[_0x8f3f('0x2e')]}))||'';}exports[_0x8f3f('0x2f')]=function(_0x221ac9,_0xfe6596){var _0x373f5f={},_0x282749={},_0xb4e472={'count':0x0,'rows':[]};var _0x5e03e9=_[_0x8f3f('0x30')](db[_0x8f3f('0x31')][_0x8f3f('0x32')],function(_0x4b8208){return{'name':_0x4b8208['fieldName'],'type':_0x4b8208[_0x8f3f('0x33')]['key']};});_0x282749[_0x8f3f('0x34')]=_[_0x8f3f('0x30')](_0x5e03e9,_0x8f3f('0x28'));_0x282749[_0x8f3f('0x35')]=_[_0x8f3f('0x36')](_0x221ac9[_0x8f3f('0x35')]);_0x282749['filters']=_[_0x8f3f('0x37')](_0x282749[_0x8f3f('0x34')],_0x282749[_0x8f3f('0x35')]);_0x373f5f[_0x8f3f('0x38')]=_[_0x8f3f('0x37')](_0x282749[_0x8f3f('0x34')],qs[_0x8f3f('0x39')](_0x221ac9['query'][_0x8f3f('0x39')]));_0x373f5f[_0x8f3f('0x38')]=_0x373f5f[_0x8f3f('0x38')][_0x8f3f('0x3a')]?_0x373f5f[_0x8f3f('0x38')]:_0x282749['model'];if(!_0x221ac9[_0x8f3f('0x35')][_0x8f3f('0x3b')](_0x8f3f('0x3c'))){_0x373f5f[_0x8f3f('0x1a')]=qs['limit'](_0x221ac9[_0x8f3f('0x35')][_0x8f3f('0x1a')]);_0x373f5f[_0x8f3f('0x18')]=qs[_0x8f3f('0x18')](_0x221ac9[_0x8f3f('0x35')]['offset']);}_0x373f5f[_0x8f3f('0x3d')]=qs['sort'](_0x221ac9[_0x8f3f('0x35')][_0x8f3f('0x3e')]);_0x373f5f[_0x8f3f('0x3f')]=qs[_0x8f3f('0x40')](_[_0x8f3f('0x41')](_0x221ac9[_0x8f3f('0x35')],_0x282749[_0x8f3f('0x40')]),_0x5e03e9);if(_0x221ac9[_0x8f3f('0x35')][_0x8f3f('0x42')]){_0x373f5f['where']=_[_0x8f3f('0x43')](_0x373f5f[_0x8f3f('0x3f')],{'$or':_[_0x8f3f('0x30')](_0x5e03e9,function(_0x2c5e26){if(_0x2c5e26[_0x8f3f('0x33')]!==_0x8f3f('0x44')){var _0x54d01e={};_0x54d01e[_0x2c5e26[_0x8f3f('0x28')]]={'$like':'%'+_0x221ac9[_0x8f3f('0x35')][_0x8f3f('0x42')]+'%'};return _0x54d01e;}})});}_0x373f5f=_['merge']({},_0x373f5f,_0x221ac9[_0x8f3f('0x45')]);var _0x195551={'where':_0x373f5f[_0x8f3f('0x3f')]};return db[_0x8f3f('0x31')][_0x8f3f('0x1b')](_0x195551)[_0x8f3f('0x23')](function(_0x47217c){_0xb4e472[_0x8f3f('0x1b')]=_0x47217c;if(_0x221ac9[_0x8f3f('0x35')][_0x8f3f('0x46')]){_0x373f5f['include']=[{'all':!![]}];}return db['AnalyticCustomReport'][_0x8f3f('0x47')](_0x373f5f);})[_0x8f3f('0x23')](function(_0x20490b){_0xb4e472[_0x8f3f('0x48')]=_0x20490b;return _0xb4e472;})['then'](respondWithFilteredResult(_0xfe6596,_0x373f5f))[_0x8f3f('0x49')](handleError(_0xfe6596,null));};exports[_0x8f3f('0x4a')]=function(_0x21a371,_0x3f9ebb){var _0x2e7dc3={'raw':![],'where':{'id':_0x21a371[_0x8f3f('0x4b')]['id']}},_0x5d1630={};_0x5d1630[_0x8f3f('0x34')]=_[_0x8f3f('0x36')](db[_0x8f3f('0x31')][_0x8f3f('0x32')]);_0x5d1630[_0x8f3f('0x35')]=_['keys'](_0x21a371[_0x8f3f('0x35')]);_0x5d1630[_0x8f3f('0x40')]=_[_0x8f3f('0x37')](_0x5d1630[_0x8f3f('0x34')],_0x5d1630['query']);_0x2e7dc3[_0x8f3f('0x38')]=_['intersection'](_0x5d1630[_0x8f3f('0x34')],qs[_0x8f3f('0x39')](_0x21a371[_0x8f3f('0x35')][_0x8f3f('0x39')]));_0x2e7dc3[_0x8f3f('0x38')]=_0x2e7dc3[_0x8f3f('0x38')][_0x8f3f('0x3a')]?_0x2e7dc3[_0x8f3f('0x38')]:_0x5d1630[_0x8f3f('0x34')];if(_0x21a371[_0x8f3f('0x35')]['includeAll']){_0x2e7dc3[_0x8f3f('0x4c')]=[{'all':!![]}];}_0x2e7dc3=_[_0x8f3f('0x43')]({},_0x2e7dc3,_0x21a371[_0x8f3f('0x45')]);return db[_0x8f3f('0x31')]['find'](_0x2e7dc3)[_0x8f3f('0x23')](handleEntityNotFound(_0x3f9ebb,null))[_0x8f3f('0x23')](respondWithResult(_0x3f9ebb,null))[_0x8f3f('0x49')](handleError(_0x3f9ebb,null));};exports[_0x8f3f('0x4d')]=function(_0x449236,_0x3925c1){return db[_0x8f3f('0x31')][_0x8f3f('0x4d')](_0x449236[_0x8f3f('0x2a')],{})[_0x8f3f('0x23')](function(_0x23a729){var _0x2f0b9c=_0x449236[_0x8f3f('0x4e')]['get']({'plain':!![]});if(!_0x2f0b9c)throw new Error(_0x8f3f('0x4f'));if(_0x2f0b9c[_0x8f3f('0x50')]===_0x8f3f('0x4e')){var _0x22140c=_0x23a729['get']({'plain':!![]});var _0x58268c=_0x8f3f('0x51');return db['UserProfileSection'][_0x8f3f('0x52')]({'where':{'name':_0x58268c,'userProfileId':_0x2f0b9c['userProfileId']},'raw':!![]})[_0x8f3f('0x23')](function(_0x135a6e){if(_0x135a6e&&_0x135a6e[_0x8f3f('0x53')]===0x0){return db[_0x8f3f('0x54')][_0x8f3f('0x4d')]({'name':_0x22140c[_0x8f3f('0x28')],'resourceId':_0x22140c['id'],'type':_0x8f3f('0x25'),'sectionId':_0x135a6e['id']},{})[_0x8f3f('0x23')](function(){return _0x23a729;});}else{return _0x23a729;}})[_0x8f3f('0x49')](function(_0x527155){logger[_0x8f3f('0x26')](_0x8f3f('0x55'),_0x527155);throw _0x527155;});}return _0x23a729;})[_0x8f3f('0x23')](respondWithResult(_0x3925c1,0xc9))[_0x8f3f('0x49')](handleError(_0x3925c1,null));};exports[_0x8f3f('0x56')]=function(_0x5b9805,_0x11c263){if(_0x5b9805[_0x8f3f('0x2a')]['id']){delete _0x5b9805[_0x8f3f('0x2a')]['id'];}return db[_0x8f3f('0x31')][_0x8f3f('0x52')]({'where':{'id':_0x5b9805['params']['id']}})['then'](handleEntityNotFound(_0x11c263,null))['then'](saveUpdates(_0x5b9805[_0x8f3f('0x2a')],null))[_0x8f3f('0x23')](respondWithResult(_0x11c263,null))['catch'](handleError(_0x11c263,null));};exports[_0x8f3f('0x22')]=function(_0x334b65,_0x3448d7){return db[_0x8f3f('0x31')]['find']({'where':{'id':_0x334b65[_0x8f3f('0x4b')]['id']}})[_0x8f3f('0x23')](handleEntityNotFound(_0x3448d7,null))[_0x8f3f('0x23')](removeEntity(_0x3448d7,null))[_0x8f3f('0x49')](handleError(_0x3448d7,null));};exports['preview']=function(_0x19d9e4,_0x40fa3c){var _0x872f25=0xa;var _0x308d92=[_0x8f3f('0x57'),'left_join',_0x8f3f('0x58'),_0x8f3f('0x59')];var _0x3613de={'SUM':'SUM(%s)','COUNT':_0x8f3f('0x5a'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x8f3f('0x5b'),'MIN':'MIN(%s)','AVG':'AVG(%s)','GROUP_CONCAT':_0x8f3f('0x5c'),'GROUP_CONCAT ASC':_0x8f3f('0x5d'),'GROUP_CONCAT DESC':_0x8f3f('0x5e')};var _0x15d350={'SEC_TO_TIME':_0x8f3f('0x5f'),'DATE':_0x8f3f('0x60'),'HOUR':_0x8f3f('0x61'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x8f3f('0x62')};var _0x2cafac=function(_0x19d623){return!_[_0x8f3f('0x63')]([_0x8f3f('0x64'),_0x8f3f('0x65'),_0x8f3f('0x66'),'IS\x20NOT\x20EMPTY'],_0x19d623);};var _0x2e771a=function(_0x38bb07){if(!_0x38bb07||!_0x38bb07[_0x8f3f('0x67')][_0x8f3f('0x3a')]){return'';}for(var _0x9a5e10='(',_0x8becc1=0x0;_0x8becc1<_0x38bb07[_0x8f3f('0x67')][_0x8f3f('0x3a')];_0x8becc1+=0x1){_0x8becc1>0x0&&(_0x9a5e10+='\x20'+_0x38bb07[_0x8f3f('0x68')]+'\x20');_0x9a5e10+=_0x38bb07[_0x8f3f('0x67')][_0x8becc1]['group']?_0x2e771a(_0x38bb07['rules'][_0x8becc1][_0x8f3f('0x69')]):_0x38bb07['rules'][_0x8becc1][_0x8f3f('0x6a')]+'\x20'+_0x38bb07[_0x8f3f('0x67')][_0x8becc1][_0x8f3f('0x6b')]+(_0x2cafac(_0x38bb07[_0x8f3f('0x67')][_0x8becc1][_0x8f3f('0x6b')])?'\x20'+_0x38bb07[_0x8f3f('0x67')][_0x8becc1][_0x8f3f('0x6c')]:'');}return _0x9a5e10+')';};var _0x1c207d={'where':{'id':_0x19d9e4[_0x8f3f('0x4b')]['id']}},_0x531a3b,_0x3fb9f4,_0xd34bae,_0x171c84,_0x29db6b;_0x1c207d=_[_0x8f3f('0x43')]({},_0x1c207d,_0x19d9e4[_0x8f3f('0x45')]);return db[_0x8f3f('0x31')][_0x8f3f('0x52')](_0x1c207d)[_0x8f3f('0x23')](function(_0x1a3c1c){if(_0x1a3c1c){_0x531a3b=_0x1a3c1c;return _0x1a3c1c['getFields']();}return null;})[_0x8f3f('0x23')](function(_0x118277){if(_0x118277){if(!_0x118277[_0x8f3f('0x3a')]){throw new db[(_0x8f3f('0x6d'))][(_0x8f3f('0x6e'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x3fb9f4=_0x118277;return db[_0x8f3f('0x6f')][_0x8f3f('0x47')]({'raw':!![]});}return null;})[_0x8f3f('0x23')](function(_0x282afb){if(_0x282afb){_0xd34bae=_[_0x8f3f('0x70')](_0x282afb,'id');var _0x4e9fae;var _0x68d56a=squel[_0x8f3f('0x71')]();_0x68d56a[_0x8f3f('0x72')](_0x531a3b[_0x8f3f('0x73')]);for(var _0x1caece=0x0;_0x1caece<_0x3fb9f4[_0x8f3f('0x3a')];_0x1caece+=0x1){_0x4e9fae=_0x3fb9f4[_0x1caece][_0x8f3f('0x74')]?_0xd34bae[_0x3fb9f4[_0x1caece][_0x8f3f('0x74')]][_0x8f3f('0x75')]:_0x3fb9f4[_0x1caece][_0x8f3f('0x6a')];_0x4e9fae=_0x3fb9f4[_0x1caece][_0x8f3f('0x76')]?_[_0x8f3f('0x77')](_0x3613de[_0x3fb9f4[_0x1caece][_0x8f3f('0x76')]],'%s',_0x4e9fae):_0x4e9fae;_0x4e9fae=_0x3fb9f4[_0x1caece][_0x8f3f('0x78')]?_[_0x8f3f('0x77')](_0x15d350[_0x3fb9f4[_0x1caece]['format']],'%s',_0x4e9fae):_0x4e9fae;if(_0x3fb9f4[_0x1caece][_0x8f3f('0x79')]){_0x68d56a['group'](_0x4e9fae);}_0x3fb9f4[_0x1caece][_0x8f3f('0x7a')]&&_0x68d56a[_0x8f3f('0x3d')](_0x4e9fae,_0x3fb9f4[_0x1caece]['orderBy']===_0x8f3f('0x7b')?![]:!![]);_0x68d56a[_0x8f3f('0x6a')](_0x4e9fae,_0x3fb9f4[_0x1caece][_0x8f3f('0x7c')]||_0x4e9fae);}if(_0x531a3b['joins']){_0x531a3b[_0x8f3f('0x7d')]=JSON['parse'](_0x531a3b['joins']);for(var _0x472abf=0x0;_0x472abf<_0x531a3b['joins'][_0x8f3f('0x3a')];_0x472abf+=0x1){if(_0x531a3b[_0x8f3f('0x7d')][_0x472abf][_0x8f3f('0x33')]&&_['includes'](_0x308d92,_0x531a3b[_0x8f3f('0x7d')][_0x472abf][_0x8f3f('0x33')])&&_0x531a3b['joins'][_0x472abf]['parentKey']&&_0x531a3b[_0x8f3f('0x7d')][_0x472abf][_0x8f3f('0x7e')]&&_0x531a3b[_0x8f3f('0x7d')][_0x472abf][_0x8f3f('0x7f')]){_0x68d56a[_0x531a3b[_0x8f3f('0x7d')][_0x472abf][_0x8f3f('0x33')]](_0x531a3b['joins'][_0x472abf][_0x8f3f('0x7e')],null,util[_0x8f3f('0x78')](_0x8f3f('0x80'),_0x531a3b[_0x8f3f('0x73')],_0x531a3b[_0x8f3f('0x7d')][_0x472abf][_0x8f3f('0x81')],_0x531a3b[_0x8f3f('0x7d')][_0x472abf][_0x8f3f('0x7e')],_0x531a3b[_0x8f3f('0x7d')][_0x472abf][_0x8f3f('0x7f')]));}}}if(_0x531a3b[_0x8f3f('0x82')]){_0x531a3b[_0x8f3f('0x82')]=JSON[_0x8f3f('0x83')](_0x531a3b['conditions']);_0x68d56a['where'](_0x2e771a(_0x531a3b[_0x8f3f('0x82')][_0x8f3f('0x69')]));}_0x29db6b=_0x68d56a[_0x8f3f('0x84')]();_0x68d56a[_0x8f3f('0x1a')](_0x872f25);_0x68d56a[_0x8f3f('0x18')](0x0);logger[_0x8f3f('0x85')](_0x8f3f('0x86'),_0x68d56a[_0x8f3f('0x87')]());return dbH[_0x8f3f('0x88')]['query'](_0x68d56a[_0x8f3f('0x87')](),{'type':dbH[_0x8f3f('0x88')][_0x8f3f('0x89')][_0x8f3f('0x8a')]});}})[_0x8f3f('0x23')](respondWithResult(_0x40fa3c,null))[_0x8f3f('0x49')](handleError(_0x40fa3c,null));};function runReport(_0x1e46e4,_0x5e5cc2,_0x4df1a8){var _0x3548b4=_0x5e5cc2[_0x8f3f('0x28')];var _0x1bc146=0xa;var _0x527496=['join',_0x8f3f('0x8b'),'right_join',_0x8f3f('0x59')];var _0x5b3240={'SUM':_0x8f3f('0x8c'),'COUNT':_0x8f3f('0x5a'),'COUNT DISTINCT':_0x8f3f('0x8d'),'MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':_0x8f3f('0x8e'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x8f3f('0x5d'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x374b70={'SEC_TO_TIME':_0x8f3f('0x5f'),'DATE':'DATE(%s)','HOUR':_0x8f3f('0x61'),'ROUND':_0x8f3f('0x8f'),'UNIX_TIMESTAMP':_0x8f3f('0x62')};var _0x698af=function(_0x56fac6){return!_[_0x8f3f('0x63')](['IS\x20NULL',_0x8f3f('0x65'),_0x8f3f('0x66'),'IS\x20NOT\x20EMPTY'],_0x56fac6);};var _0x212985=function(_0x16fb24){if(!_0x16fb24||!_0x16fb24['rules'][_0x8f3f('0x3a')]){return'';}for(var _0x4a3f2b='(',_0x16fb7b=0x0;_0x16fb7b<_0x16fb24[_0x8f3f('0x67')][_0x8f3f('0x3a')];_0x16fb7b+=0x1){_0x16fb7b>0x0&&(_0x4a3f2b+='\x20'+_0x16fb24[_0x8f3f('0x68')]+'\x20');_0x4a3f2b+=_0x16fb24['rules'][_0x16fb7b][_0x8f3f('0x69')]?_0x212985(_0x16fb24[_0x8f3f('0x67')][_0x16fb7b]['group']):_0x16fb24['rules'][_0x16fb7b][_0x8f3f('0x6a')]+'\x20'+_0x16fb24[_0x8f3f('0x67')][_0x16fb7b][_0x8f3f('0x6b')]+(_0x698af(_0x16fb24['rules'][_0x16fb7b]['condition'])?'\x20'+_0x16fb24['rules'][_0x16fb7b][_0x8f3f('0x6c')]:'');}return _0x4a3f2b+')';};var _0xd659df={'where':{'id':_0x1e46e4['id']}},_0xabf2a,_0x2a1d44,_0x281355,_0x2c5726,_0x27dbd1;_0xd659df=_['merge']({},_0xd659df,_0x4df1a8);return db['AnalyticCustomReport'][_0x8f3f('0x52')](_0xd659df)[_0x8f3f('0x23')](function(_0x2c8f37){if(_0x2c8f37){_0xabf2a=_0x2c8f37;return _0x2c8f37[_0x8f3f('0x90')]();}return null;})[_0x8f3f('0x23')](function(_0x55ce6d){if(_0x55ce6d){if(!_0x55ce6d['length']){throw new db['Sequelize'][(_0x8f3f('0x6e'))](_0x8f3f('0x91'),0x193);}_0x2a1d44=_0x55ce6d;return db['AnalyticMetric'][_0x8f3f('0x47')]({'raw':!![]});}return null;})[_0x8f3f('0x23')](function(_0x24ec0c){if(_0x24ec0c){_0x281355=_[_0x8f3f('0x70')](_0x24ec0c,'id');var _0x4955c2;var _0x1d8f9f=squel[_0x8f3f('0x71')]();_0x1d8f9f[_0x8f3f('0x72')](_0xabf2a[_0x8f3f('0x73')]);for(var _0x358107=0x0;_0x358107<_0x2a1d44['length'];_0x358107+=0x1){_0x4955c2=_0x2a1d44[_0x358107][_0x8f3f('0x74')]?_0x281355[_0x2a1d44[_0x358107][_0x8f3f('0x74')]][_0x8f3f('0x75')]:_0x2a1d44[_0x358107][_0x8f3f('0x6a')];_0x4955c2=_0x2a1d44[_0x358107][_0x8f3f('0x76')]?_[_0x8f3f('0x77')](_0x5b3240[_0x2a1d44[_0x358107][_0x8f3f('0x76')]],'%s',_0x4955c2):_0x4955c2;_0x4955c2=_0x2a1d44[_0x358107][_0x8f3f('0x78')]?_['replace'](_0x374b70[_0x2a1d44[_0x358107][_0x8f3f('0x78')]],'%s',_0x4955c2):_0x4955c2;if(_0x2a1d44[_0x358107][_0x8f3f('0x79')]){_0x1d8f9f[_0x8f3f('0x69')](_0x4955c2);}_0x2a1d44[_0x358107][_0x8f3f('0x7a')]&&_0x1d8f9f[_0x8f3f('0x3d')](_0x4955c2,_0x2a1d44[_0x358107][_0x8f3f('0x7a')]==='DESC'?![]:!![]);_0x1d8f9f[_0x8f3f('0x6a')](_0x4955c2,_0x2a1d44[_0x358107][_0x8f3f('0x7c')]||_0x4955c2);}if(_0xabf2a['joins']){_0xabf2a[_0x8f3f('0x7d')]=JSON[_0x8f3f('0x83')](_0xabf2a['joins']);for(var _0x2e7377=0x0;_0x2e7377<_0xabf2a[_0x8f3f('0x7d')][_0x8f3f('0x3a')];_0x2e7377+=0x1){if(_0xabf2a[_0x8f3f('0x7d')][_0x2e7377][_0x8f3f('0x33')]&&_[_0x8f3f('0x63')](_0x527496,_0xabf2a[_0x8f3f('0x7d')][_0x2e7377][_0x8f3f('0x33')])&&_0xabf2a[_0x8f3f('0x7d')][_0x2e7377]['parentKey']&&_0xabf2a[_0x8f3f('0x7d')][_0x2e7377][_0x8f3f('0x7e')]&&_0xabf2a['joins'][_0x2e7377][_0x8f3f('0x7f')]){_0x1d8f9f[_0xabf2a['joins'][_0x2e7377][_0x8f3f('0x33')]](_0xabf2a[_0x8f3f('0x7d')][_0x2e7377][_0x8f3f('0x7e')],null,util['format'](_0x8f3f('0x80'),_0xabf2a[_0x8f3f('0x73')],_0xabf2a[_0x8f3f('0x7d')][_0x2e7377][_0x8f3f('0x81')],_0xabf2a[_0x8f3f('0x7d')][_0x2e7377][_0x8f3f('0x7e')],_0xabf2a[_0x8f3f('0x7d')][_0x2e7377][_0x8f3f('0x7f')]));}}}if(_0xabf2a[_0x8f3f('0x82')]){_0xabf2a[_0x8f3f('0x82')]=JSON['parse'](_0xabf2a['conditions']);_0x1d8f9f[_0x8f3f('0x3f')](_0x212985(_0xabf2a['conditions'][_0x8f3f('0x69')]));}_0x27dbd1=_0x1d8f9f[_0x8f3f('0x84')]();_0x1d8f9f[_0x8f3f('0x1a')](_0x1bc146);_0x1d8f9f[_0x8f3f('0x18')](0x0);return;}})[_0x8f3f('0x23')](function(){if(_0x5e5cc2['output']===_0x8f3f('0x92')){return null;}var _0x38dd29=_[_0x8f3f('0x43')](_0x5e5cc2,{'name':_0x5e5cc2['fullPath']||_0x5e5cc2['name']||_0xabf2a['name'],'basename':_0x3548b4,'savename':util['format'](_0x8f3f('0x93'),_0x5e5cc2[_0x8f3f('0x28')]||_0xabf2a[_0x8f3f('0x28')],require(_0x8f3f('0x94'))[_0x8f3f('0x95')](0x4),_0x5e5cc2[_0x8f3f('0x96')]||_0x8f3f('0x97')),'reportId':_0xabf2a['id'],'reportType':_0x8f3f('0x98')});return db[_0x8f3f('0x99')][_0x8f3f('0x4d')](_0x38dd29,{'raw':!![]});})[_0x8f3f('0x23')](function(_0x231258){if(_0xabf2a['table']===_0x8f3f('0x9a')){_0x27dbd1[_0x8f3f('0x3f')](_0xabf2a['table']+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x5e5cc2[_0x8f3f('0x9b')],_0x5e5cc2[_0x8f3f('0x9c')]);}else{_0x27dbd1[_0x8f3f('0x3f')](_0xabf2a[_0x8f3f('0x73')]+_0x8f3f('0x9d'),_0x5e5cc2['startDate'],_0x5e5cc2[_0x8f3f('0x9c')]);}if(_0x231258){logger['info'](_0x8f3f('0x9e'),_0x27dbd1[_0x8f3f('0x87')]());require(_0x8f3f('0x9f'))[_0x8f3f('0xa0')](path['join'](__dirname,_0x8f3f('0xa1'),_0x231258[_0x8f3f('0x96')]),[_0x231258['id'],_0x27dbd1[_0x8f3f('0x87')](),path[_0x8f3f('0x57')](__dirname,_0x8f3f('0xa2'),_0x231258[_0x8f3f('0xa3')]),_0x3548b4]);return _0x231258;}else{var _0x3e6a34=squel[_0x8f3f('0x71')]();_0x3e6a34['from']('('+_0x27dbd1['toString']()+')',_0x8f3f('0xa4'));_0x3e6a34[_0x8f3f('0x6a')]('COUNT(*)',_0x8f3f('0x1b'));_0x27dbd1['limit'](_0x5e5cc2[_0x8f3f('0x1a')]||_0x1bc146);_0x27dbd1[_0x8f3f('0x18')](_0x5e5cc2[_0x8f3f('0x18')]||0x0);return dbH['sequelize']['query'](_0x3e6a34['toString'](),{'type':dbH[_0x8f3f('0x88')]['QueryTypes']['SELECT']})[_0x8f3f('0x23')](function(_0x5d8b31){if(!_0x5d8b31[_0x8f3f('0x3a')]){_0x2c5726=0x0;}else{_0x2c5726=_0x5d8b31[0x0][_0x8f3f('0x1b')]||0x0;}return dbH[_0x8f3f('0x88')]['query'](_0x27dbd1[_0x8f3f('0x87')](),{'type':dbH[_0x8f3f('0x88')][_0x8f3f('0x89')][_0x8f3f('0x8a')]});})[_0x8f3f('0x23')](function(_0xba61ca){return{'rows':_0xba61ca||[],'count':_0x2c5726};});}});}exports[_0x8f3f('0xa5')]=function(_0x262f1f,_0x1bad88){return runReport(_0x262f1f['params'],_0x262f1f[_0x8f3f('0x35')],_0x262f1f[_0x8f3f('0x45')])['then'](respondWithResult(_0x1bad88,null))[_0x8f3f('0x49')](handleError(_0x1bad88,null));};exports[_0x8f3f('0xa6')]=runReport;exports[_0x8f3f('0x35')]=function(_0x167b3a,_0x6caf09){var _0x2d01f3=0xa;var _0x290e8c=[_0x8f3f('0x57'),_0x8f3f('0x8b'),'right_join',_0x8f3f('0x59')];var _0x52f383={'SUM':_0x8f3f('0x8c'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x8f3f('0x8d'),'MAX':_0x8f3f('0x5b'),'MIN':_0x8f3f('0xa7'),'AVG':_0x8f3f('0x8e'),'GROUP_CONCAT':_0x8f3f('0x5c'),'GROUP_CONCAT ASC':_0x8f3f('0x5d'),'GROUP_CONCAT DESC':_0x8f3f('0x5e')};var _0xc7d1c6={'SEC_TO_TIME':_0x8f3f('0x5f'),'DATE':'DATE(%s)','HOUR':_0x8f3f('0x61'),'ROUND':_0x8f3f('0x8f'),'UNIX_TIMESTAMP':_0x8f3f('0x62')};var _0x25d6fb=function(_0x2a1855){return!_['includes']([_0x8f3f('0x64'),_0x8f3f('0x65'),'IS\x20EMPTY',_0x8f3f('0xa8')],_0x2a1855);};var _0xf5f1dd=function(_0x2de002){if(!_0x2de002||!_0x2de002[_0x8f3f('0x67')][_0x8f3f('0x3a')]){return'';}for(var _0x508726='(',_0x453e04=0x0;_0x453e04<_0x2de002[_0x8f3f('0x67')][_0x8f3f('0x3a')];_0x453e04+=0x1){_0x453e04>0x0&&(_0x508726+='\x20'+_0x2de002[_0x8f3f('0x68')]+'\x20');_0x508726+=_0x2de002[_0x8f3f('0x67')][_0x453e04][_0x8f3f('0x69')]?_0xf5f1dd(_0x2de002[_0x8f3f('0x67')][_0x453e04][_0x8f3f('0x69')]):_0x2de002[_0x8f3f('0x67')][_0x453e04]['field']+'\x20'+_0x2de002[_0x8f3f('0x67')][_0x453e04][_0x8f3f('0x6b')]+(_0x25d6fb(_0x2de002['rules'][_0x453e04][_0x8f3f('0x6b')])?'\x20'+_0x2de002['rules'][_0x453e04][_0x8f3f('0x6c')]:'');}return _0x508726+')';};var _0x717d8d={'where':{'id':_0x167b3a[_0x8f3f('0x4b')]['id']}},_0x355e9c,_0xbdc752,_0x30c509,_0x19261b,_0x3e9ed9;_0x717d8d=_['merge']({},_0x717d8d,_0x167b3a[_0x8f3f('0x45')]);return db[_0x8f3f('0x31')]['find'](_0x717d8d)[_0x8f3f('0x23')](function(_0x5383cf){if(_0x5383cf){_0x355e9c=_0x5383cf;return _0x5383cf[_0x8f3f('0x90')]();}return null;})[_0x8f3f('0x23')](function(_0x18d34f){if(_0x18d34f){if(!_0x18d34f[_0x8f3f('0x3a')]){throw new db['Sequelize'][(_0x8f3f('0x6e'))](_0x8f3f('0x91'),0x193);}_0xbdc752=_0x18d34f;return db['AnalyticMetric'][_0x8f3f('0x47')]({'raw':!![]});}return null;})['then'](function(_0x131809){if(_0x131809){_0x30c509=_[_0x8f3f('0x70')](_0x131809,'id');var _0x11ed35;var _0x2ac1da=squel[_0x8f3f('0x71')]();_0x2ac1da[_0x8f3f('0x72')](_0x355e9c['table']);for(var _0x396c24=0x0;_0x396c24<_0xbdc752[_0x8f3f('0x3a')];_0x396c24+=0x1){_0x11ed35=_0xbdc752[_0x396c24][_0x8f3f('0x74')]?_0x30c509[_0xbdc752[_0x396c24][_0x8f3f('0x74')]][_0x8f3f('0x75')]:_0xbdc752[_0x396c24][_0x8f3f('0x6a')];_0x11ed35=_0xbdc752[_0x396c24]['function']?_[_0x8f3f('0x77')](_0x52f383[_0xbdc752[_0x396c24][_0x8f3f('0x76')]],'%s',_0x11ed35):_0x11ed35;_0x11ed35=_0xbdc752[_0x396c24]['format']?_[_0x8f3f('0x77')](_0xc7d1c6[_0xbdc752[_0x396c24][_0x8f3f('0x78')]],'%s',_0x11ed35):_0x11ed35;if(_0xbdc752[_0x396c24][_0x8f3f('0x79')]){_0x2ac1da['group'](_0x11ed35);}_0xbdc752[_0x396c24][_0x8f3f('0x7a')]&&_0x2ac1da['order'](_0x11ed35,_0xbdc752[_0x396c24][_0x8f3f('0x7a')]===_0x8f3f('0x7b')?![]:!![]);_0x2ac1da[_0x8f3f('0x6a')](_0x11ed35,_0xbdc752[_0x396c24][_0x8f3f('0x7c')]||_0x11ed35);}if(_0x355e9c[_0x8f3f('0x7d')]){_0x355e9c[_0x8f3f('0x7d')]=JSON[_0x8f3f('0x83')](_0x355e9c[_0x8f3f('0x7d')]);for(var _0xc4e0f=0x0;_0xc4e0f<_0x355e9c['joins'][_0x8f3f('0x3a')];_0xc4e0f+=0x1){if(_0x355e9c[_0x8f3f('0x7d')][_0xc4e0f][_0x8f3f('0x33')]&&_['includes'](_0x290e8c,_0x355e9c[_0x8f3f('0x7d')][_0xc4e0f][_0x8f3f('0x33')])&&_0x355e9c['joins'][_0xc4e0f][_0x8f3f('0x81')]&&_0x355e9c[_0x8f3f('0x7d')][_0xc4e0f][_0x8f3f('0x7e')]&&_0x355e9c[_0x8f3f('0x7d')][_0xc4e0f][_0x8f3f('0x7f')]){_0x2ac1da[_0x355e9c[_0x8f3f('0x7d')][_0xc4e0f][_0x8f3f('0x33')]](_0x355e9c[_0x8f3f('0x7d')][_0xc4e0f][_0x8f3f('0x7e')],null,util[_0x8f3f('0x78')]('%s.%s\x20=\x20%s.%s',_0x355e9c['table'],_0x355e9c['joins'][_0xc4e0f]['parentKey'],_0x355e9c[_0x8f3f('0x7d')][_0xc4e0f][_0x8f3f('0x7e')],_0x355e9c[_0x8f3f('0x7d')][_0xc4e0f][_0x8f3f('0x7f')]));}}}if(_0x355e9c[_0x8f3f('0x82')]){_0x355e9c[_0x8f3f('0x82')]=JSON[_0x8f3f('0x83')](_0x355e9c[_0x8f3f('0x82')]);_0x2ac1da['where'](_0xf5f1dd(_0x355e9c[_0x8f3f('0x82')][_0x8f3f('0x69')]));}_0x3e9ed9=_0x2ac1da[_0x8f3f('0x84')]();_0x2ac1da['limit'](_0x2d01f3);_0x2ac1da[_0x8f3f('0x18')](0x0);logger[_0x8f3f('0x85')]('Limited\x20Query:',_0x2ac1da['toString']());return dbH[_0x8f3f('0x88')][_0x8f3f('0x35')](_0x2ac1da['toString'](),{'type':dbH[_0x8f3f('0x88')]['QueryTypes'][_0x8f3f('0x8a')]});}})[_0x8f3f('0x23')](function(){return{'sql':_0x3e9ed9[_0x8f3f('0x87')]()};})[_0x8f3f('0x23')](respondWithResult(_0x6caf09,null))[_0x8f3f('0x49')](handleError(_0x6caf09,null));};
\ No newline at end of file
+var _0x2881=['api','../../config/utils','../../config/environment','../../config/license/util','dbH','status','json','offset','undefined','limit','count','Content-Range','apply','reject','save','update','then','destroy','get','CustomReports','end','sendStatus','error','stack','name','render','merge','body','contact','message','agent','interaction','index','map','AnalyticCustomReport','fieldName','type','key','keys','filters','intersection','model','attributes','query','length','nolimit','order','sort','where','filter','VIRTUAL','options','includeAll','findAll','rows','catch','show','fields','include','find','create','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','Reports','UserProfileSection','userProfileId','autoAssociation','UserProfileResource','params','preview','left_join','right_join','cross_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','SEC_TO_TIME(%s)','DATE(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','keyBy','select','table','MetricId','replace','function','format','groupBy','orderBy','alias','joins','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','conditions','clone','toString','sequelize','SELECT','join','MAX(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','HOUR(%s)','IS\x20NULL','AnalyticMetric','from','metric','DESC','parse','output','fullPath','%s-%s.%s','randomstring','generate','csv','custom','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','endDate','Run\x20Query:','fork','../../components/export/','../../files/reports','savename','countTable','QueryTypes','runReport','IS\x20NOT\x20NULL','value','debug','Limited\x20Query:','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','squel','jsforce','desk.js','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger'];(function(_0x164faa,_0x13185f){var _0x57d88e=function(_0x34545f){while(--_0x34545f){_0x164faa['push'](_0x164faa['shift']());}};_0x57d88e(++_0x13185f);}(_0x2881,0x146));var _0x1288=function(_0x4f8ee7,_0x211559){_0x4f8ee7=_0x4f8ee7-0x0;var _0x566f99=_0x2881[_0x4f8ee7];return _0x566f99;};'use strict';var emlformat=require(_0x1288('0x0'));var rimraf=require(_0x1288('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x1288('0x2'));var rp=require(_0x1288('0x3'));var moment=require(_0x1288('0x4'));var BPromise=require(_0x1288('0x5'));var Mustache=require(_0x1288('0x6'));var util=require(_0x1288('0x7'));var path=require(_0x1288('0x8'));var sox=require(_0x1288('0x9'));var csv=require(_0x1288('0xa'));var ejs=require(_0x1288('0xb'));var fs=require('fs');var fs_extra=require(_0x1288('0xc'));var _=require('lodash');var squel=require(_0x1288('0xd'));var crypto=require('crypto');var jsforce=require(_0x1288('0xe'));var deskjs=require(_0x1288('0xf'));var toCsv=require(_0x1288('0xa'));var querystring=require('querystring');var Papa=require(_0x1288('0x10'));var Redis=require('ioredis');var authService=require(_0x1288('0x11'));var qs=require(_0x1288('0x12'));var as=require(_0x1288('0x13'));var hardwareService=require(_0x1288('0x14'));var logger=require(_0x1288('0x15'))(_0x1288('0x16'));var utils=require(_0x1288('0x17'));var config=require(_0x1288('0x18'));var licenseUtil=require(_0x1288('0x19'));var db=require('../../mysqldb')['db'];var dbH=require('../../mysqldb')[_0x1288('0x1a')];function respondWithStatusCode(_0x319d9f,_0x5595d2){_0x5595d2=_0x5595d2||0xcc;return function(_0x465995){if(_0x465995){return _0x319d9f['sendStatus'](_0x5595d2);}return _0x319d9f[_0x1288('0x1b')](_0x5595d2)['end']();};}function respondWithResult(_0x542bfc,_0x1a6483){_0x1a6483=_0x1a6483||0xc8;return function(_0x108aa7){if(_0x108aa7){return _0x542bfc['status'](_0x1a6483)[_0x1288('0x1c')](_0x108aa7);}};}function respondWithFilteredResult(_0x6efd85,_0x5532d5){return function(_0x4594d9){if(_0x4594d9){var _0x323c02=typeof _0x5532d5[_0x1288('0x1d')]===_0x1288('0x1e')&&typeof _0x5532d5[_0x1288('0x1f')]==='undefined';var _0x54f38d=_0x4594d9[_0x1288('0x20')];var _0x1a49f0=_0x323c02?0x0:_0x5532d5['offset'];var _0x5bd2ce=_0x323c02?_0x4594d9[_0x1288('0x20')]:_0x5532d5[_0x1288('0x1d')]+_0x5532d5['limit'];var _0xe3f74c;if(_0x5bd2ce>=_0x54f38d){_0x5bd2ce=_0x54f38d;_0xe3f74c=0xc8;}else{_0xe3f74c=0xce;}_0x6efd85['status'](_0xe3f74c);return _0x6efd85['set'](_0x1288('0x21'),_0x1a49f0+'-'+_0x5bd2ce+'/'+_0x54f38d)[_0x1288('0x1c')](_0x4594d9);}return null;};}function patchUpdates(_0x5ac126){return function(_0x3f3217){try{jsonpatch[_0x1288('0x22')](_0x3f3217,_0x5ac126,!![]);}catch(_0x3f002e){return BPromise[_0x1288('0x23')](_0x3f002e);}return _0x3f3217[_0x1288('0x24')]();};}function saveUpdates(_0x33eeb0,_0x59f9b8){return function(_0x429e23){if(_0x429e23){return _0x429e23[_0x1288('0x25')](_0x33eeb0)[_0x1288('0x26')](function(_0x47dd56){return _0x47dd56;});}return null;};}function removeEntity(_0x22864c,_0x55d75a){return function(_0x521e22){if(_0x521e22){return _0x521e22[_0x1288('0x27')]()[_0x1288('0x26')](function(){var _0x279c90=_0x521e22[_0x1288('0x28')]({'plain':!![]});var _0x3cff1a=_0x1288('0x29');return db['UserProfileResource'][_0x1288('0x27')]({'where':{'type':_0x3cff1a,'resourceId':_0x279c90['id']}})['then'](function(){return _0x521e22;});})[_0x1288('0x26')](function(){_0x22864c[_0x1288('0x1b')](0xcc)[_0x1288('0x2a')]();});}};}function handleEntityNotFound(_0x4d3d91,_0x3a274f){return function(_0x3a0de7){if(!_0x3a0de7){_0x4d3d91[_0x1288('0x2b')](0x194);}return _0x3a0de7;};}function handleError(_0x39fff2,_0xe8f5e){_0xe8f5e=_0xe8f5e||0x1f4;return function(_0x340d9e){logger[_0x1288('0x2c')](_0x340d9e[_0x1288('0x2d')]);if(_0x340d9e[_0x1288('0x2e')]){delete _0x340d9e[_0x1288('0x2e')];}_0x39fff2[_0x1288('0x1b')](_0xe8f5e)['send'](_0x340d9e);};}function getMustacheRender(_0x551814,_0x327cc6){return Mustache[_0x1288('0x2f')](_0x551814,_[_0x1288('0x30')](_0x327cc6[_0x1288('0x31')],{'contact':_0x327cc6[_0x1288('0x32')],'message':_0x327cc6[_0x1288('0x33')],'agent':_0x327cc6[_0x1288('0x34')],'interaction':_0x327cc6[_0x1288('0x35')],'account':_0x327cc6['account']}))||'';}exports[_0x1288('0x36')]=function(_0x237c27,_0x473656){var _0x367e3f={},_0x1759a0={},_0x113d53={'count':0x0,'rows':[]};var _0xd75485=_[_0x1288('0x37')](db[_0x1288('0x38')]['rawAttributes'],function(_0x40a659){return{'name':_0x40a659[_0x1288('0x39')],'type':_0x40a659[_0x1288('0x3a')][_0x1288('0x3b')]};});_0x1759a0['model']=_[_0x1288('0x37')](_0xd75485,_0x1288('0x2e'));_0x1759a0['query']=_[_0x1288('0x3c')](_0x237c27['query']);_0x1759a0[_0x1288('0x3d')]=_[_0x1288('0x3e')](_0x1759a0[_0x1288('0x3f')],_0x1759a0['query']);_0x367e3f[_0x1288('0x40')]=_['intersection'](_0x1759a0[_0x1288('0x3f')],qs['fields'](_0x237c27[_0x1288('0x41')]['fields']));_0x367e3f[_0x1288('0x40')]=_0x367e3f[_0x1288('0x40')][_0x1288('0x42')]?_0x367e3f[_0x1288('0x40')]:_0x1759a0[_0x1288('0x3f')];if(!_0x237c27[_0x1288('0x41')]['hasOwnProperty'](_0x1288('0x43'))){_0x367e3f[_0x1288('0x1f')]=qs[_0x1288('0x1f')](_0x237c27['query'][_0x1288('0x1f')]);_0x367e3f[_0x1288('0x1d')]=qs[_0x1288('0x1d')](_0x237c27[_0x1288('0x41')][_0x1288('0x1d')]);}_0x367e3f[_0x1288('0x44')]=qs[_0x1288('0x45')](_0x237c27[_0x1288('0x41')][_0x1288('0x45')]);_0x367e3f[_0x1288('0x46')]=qs['filters'](_['pick'](_0x237c27[_0x1288('0x41')],_0x1759a0[_0x1288('0x3d')]),_0xd75485);if(_0x237c27[_0x1288('0x41')][_0x1288('0x47')]){_0x367e3f['where']=_[_0x1288('0x30')](_0x367e3f[_0x1288('0x46')],{'$or':_['map'](_0xd75485,function(_0x4969a1){if(_0x4969a1[_0x1288('0x3a')]!==_0x1288('0x48')){var _0x145aaa={};_0x145aaa[_0x4969a1[_0x1288('0x2e')]]={'$like':'%'+_0x237c27[_0x1288('0x41')][_0x1288('0x47')]+'%'};return _0x145aaa;}})});}_0x367e3f=_[_0x1288('0x30')]({},_0x367e3f,_0x237c27[_0x1288('0x49')]);var _0x62e7c1={'where':_0x367e3f['where']};return db[_0x1288('0x38')]['count'](_0x62e7c1)[_0x1288('0x26')](function(_0xb2a49){_0x113d53[_0x1288('0x20')]=_0xb2a49;if(_0x237c27['query'][_0x1288('0x4a')]){_0x367e3f['include']=[{'all':!![]}];}return db[_0x1288('0x38')][_0x1288('0x4b')](_0x367e3f);})['then'](function(_0x58f5e9){_0x113d53[_0x1288('0x4c')]=_0x58f5e9;return _0x113d53;})['then'](respondWithFilteredResult(_0x473656,_0x367e3f))[_0x1288('0x4d')](handleError(_0x473656,null));};exports[_0x1288('0x4e')]=function(_0x5be9d6,_0x2489ca){var _0x103c1e={'raw':![],'where':{'id':_0x5be9d6['params']['id']}},_0x373f0e={};_0x373f0e[_0x1288('0x3f')]=_['keys'](db[_0x1288('0x38')]['rawAttributes']);_0x373f0e[_0x1288('0x41')]=_['keys'](_0x5be9d6[_0x1288('0x41')]);_0x373f0e['filters']=_['intersection'](_0x373f0e['model'],_0x373f0e[_0x1288('0x41')]);_0x103c1e[_0x1288('0x40')]=_[_0x1288('0x3e')](_0x373f0e[_0x1288('0x3f')],qs[_0x1288('0x4f')](_0x5be9d6[_0x1288('0x41')][_0x1288('0x4f')]));_0x103c1e[_0x1288('0x40')]=_0x103c1e[_0x1288('0x40')][_0x1288('0x42')]?_0x103c1e[_0x1288('0x40')]:_0x373f0e[_0x1288('0x3f')];if(_0x5be9d6[_0x1288('0x41')][_0x1288('0x4a')]){_0x103c1e[_0x1288('0x50')]=[{'all':!![]}];}_0x103c1e=_[_0x1288('0x30')]({},_0x103c1e,_0x5be9d6[_0x1288('0x49')]);return db[_0x1288('0x38')][_0x1288('0x51')](_0x103c1e)['then'](handleEntityNotFound(_0x2489ca,null))['then'](respondWithResult(_0x2489ca,null))[_0x1288('0x4d')](handleError(_0x2489ca,null));};exports[_0x1288('0x52')]=function(_0x134e19,_0x413ae5){return db[_0x1288('0x38')][_0x1288('0x52')](_0x134e19[_0x1288('0x31')],{})[_0x1288('0x26')](function(_0x1389ba){var _0x5a81ed=_0x134e19['user'][_0x1288('0x28')]({'plain':!![]});if(!_0x5a81ed)throw new Error(_0x1288('0x53'));if(_0x5a81ed[_0x1288('0x54')]===_0x1288('0x55')){var _0x2ac03b=_0x1389ba['get']({'plain':!![]});var _0x196646=_0x1288('0x56');return db[_0x1288('0x57')][_0x1288('0x51')]({'where':{'name':_0x196646,'userProfileId':_0x5a81ed[_0x1288('0x58')]},'raw':!![]})[_0x1288('0x26')](function(_0x52034f){if(_0x52034f&&_0x52034f[_0x1288('0x59')]===0x0){return db[_0x1288('0x5a')][_0x1288('0x52')]({'name':_0x2ac03b[_0x1288('0x2e')],'resourceId':_0x2ac03b['id'],'type':_0x1288('0x29'),'sectionId':_0x52034f['id']},{})['then'](function(){return _0x1389ba;});}else{return _0x1389ba;}})['catch'](function(_0x4e6016){logger[_0x1288('0x2c')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x4e6016);throw _0x4e6016;});}return _0x1389ba;})[_0x1288('0x26')](respondWithResult(_0x413ae5,0xc9))['catch'](handleError(_0x413ae5,null));};exports['update']=function(_0x484618,_0x24619a){if(_0x484618[_0x1288('0x31')]['id']){delete _0x484618['body']['id'];}return db[_0x1288('0x38')]['find']({'where':{'id':_0x484618[_0x1288('0x5b')]['id']}})['then'](handleEntityNotFound(_0x24619a,null))[_0x1288('0x26')](saveUpdates(_0x484618[_0x1288('0x31')],null))[_0x1288('0x26')](respondWithResult(_0x24619a,null))['catch'](handleError(_0x24619a,null));};exports[_0x1288('0x27')]=function(_0x2b63a6,_0x486310){return db[_0x1288('0x38')][_0x1288('0x51')]({'where':{'id':_0x2b63a6[_0x1288('0x5b')]['id']}})['then'](handleEntityNotFound(_0x486310,null))[_0x1288('0x26')](removeEntity(_0x486310,null))[_0x1288('0x4d')](handleError(_0x486310,null));};exports[_0x1288('0x5c')]=function(_0xd2b89c,_0x3298cf){var _0x5a7153=0xa;var _0x2a79d6=['join',_0x1288('0x5d'),_0x1288('0x5e'),_0x1288('0x5f')];var _0x3c7fb0={'SUM':_0x1288('0x60'),'COUNT':_0x1288('0x61'),'COUNT DISTINCT':_0x1288('0x62'),'MAX':'MAX(%s)','MIN':_0x1288('0x63'),'AVG':_0x1288('0x64'),'GROUP_CONCAT':_0x1288('0x65'),'GROUP_CONCAT ASC':_0x1288('0x66'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x2b1b7d={'SEC_TO_TIME':_0x1288('0x67'),'DATE':_0x1288('0x68'),'HOUR':'HOUR(%s)','ROUND':_0x1288('0x69'),'UNIX_TIMESTAMP':_0x1288('0x6a')};var _0x5bc8b6=function(_0x987ecd){return!_[_0x1288('0x6b')](['IS\x20NULL','IS\x20NOT\x20NULL',_0x1288('0x6c'),_0x1288('0x6d')],_0x987ecd);};var _0x3f5fcb=function(_0x2365df){if(!_0x2365df||!_0x2365df[_0x1288('0x6e')][_0x1288('0x42')]){return'';}for(var _0x2b4fe8='(',_0x330e5d=0x0;_0x330e5d<_0x2365df[_0x1288('0x6e')]['length'];_0x330e5d+=0x1){_0x330e5d>0x0&&(_0x2b4fe8+='\x20'+_0x2365df[_0x1288('0x6f')]+'\x20');_0x2b4fe8+=_0x2365df[_0x1288('0x6e')][_0x330e5d][_0x1288('0x70')]?_0x3f5fcb(_0x2365df[_0x1288('0x6e')][_0x330e5d][_0x1288('0x70')]):_0x2365df[_0x1288('0x6e')][_0x330e5d][_0x1288('0x71')]+'\x20'+_0x2365df[_0x1288('0x6e')][_0x330e5d][_0x1288('0x72')]+(_0x5bc8b6(_0x2365df[_0x1288('0x6e')][_0x330e5d][_0x1288('0x72')])?'\x20'+_0x2365df[_0x1288('0x6e')][_0x330e5d]['value']:'');}return _0x2b4fe8+')';};var _0x1c4167={'where':{'id':_0xd2b89c[_0x1288('0x5b')]['id']}},_0x341885,_0x16d308,_0x1616be,_0x1bb910,_0x198326;_0x1c4167=_['merge']({},_0x1c4167,_0xd2b89c[_0x1288('0x49')]);return db[_0x1288('0x38')][_0x1288('0x51')](_0x1c4167)[_0x1288('0x26')](function(_0x2fc41f){if(_0x2fc41f){_0x341885=_0x2fc41f;return _0x2fc41f[_0x1288('0x73')]();}return null;})[_0x1288('0x26')](function(_0x3ddbf7){if(_0x3ddbf7){if(!_0x3ddbf7[_0x1288('0x42')]){throw new db[(_0x1288('0x74'))][(_0x1288('0x75'))](_0x1288('0x76'),0x193);}_0x16d308=_0x3ddbf7;return db['AnalyticMetric'][_0x1288('0x4b')]({'raw':!![]});}return null;})[_0x1288('0x26')](function(_0x1524af){if(_0x1524af){_0x1616be=_[_0x1288('0x77')](_0x1524af,'id');var _0x37437f;var _0x4cfcfd=squel[_0x1288('0x78')]();_0x4cfcfd['from'](_0x341885[_0x1288('0x79')]);for(var _0x3f001f=0x0;_0x3f001f<_0x16d308[_0x1288('0x42')];_0x3f001f+=0x1){_0x37437f=_0x16d308[_0x3f001f][_0x1288('0x7a')]?_0x1616be[_0x16d308[_0x3f001f][_0x1288('0x7a')]]['metric']:_0x16d308[_0x3f001f]['field'];_0x37437f=_0x16d308[_0x3f001f]['function']?_[_0x1288('0x7b')](_0x3c7fb0[_0x16d308[_0x3f001f][_0x1288('0x7c')]],'%s',_0x37437f):_0x37437f;_0x37437f=_0x16d308[_0x3f001f][_0x1288('0x7d')]?_[_0x1288('0x7b')](_0x2b1b7d[_0x16d308[_0x3f001f]['format']],'%s',_0x37437f):_0x37437f;if(_0x16d308[_0x3f001f][_0x1288('0x7e')]){_0x4cfcfd['group'](_0x37437f);}_0x16d308[_0x3f001f]['orderBy']&&_0x4cfcfd[_0x1288('0x44')](_0x37437f,_0x16d308[_0x3f001f][_0x1288('0x7f')]==='DESC'?![]:!![]);_0x4cfcfd[_0x1288('0x71')](_0x37437f,_0x16d308[_0x3f001f][_0x1288('0x80')]||_0x37437f);}if(_0x341885[_0x1288('0x81')]){_0x341885[_0x1288('0x81')]=JSON['parse'](_0x341885[_0x1288('0x81')]);for(var _0x26202c=0x0;_0x26202c<_0x341885['joins'][_0x1288('0x42')];_0x26202c+=0x1){if(_0x341885['joins'][_0x26202c][_0x1288('0x3a')]&&_[_0x1288('0x6b')](_0x2a79d6,_0x341885['joins'][_0x26202c][_0x1288('0x3a')])&&_0x341885['joins'][_0x26202c][_0x1288('0x82')]&&_0x341885[_0x1288('0x81')][_0x26202c][_0x1288('0x83')]&&_0x341885['joins'][_0x26202c][_0x1288('0x84')]){_0x4cfcfd[_0x341885[_0x1288('0x81')][_0x26202c][_0x1288('0x3a')]](_0x341885[_0x1288('0x81')][_0x26202c][_0x1288('0x83')],null,util[_0x1288('0x7d')](_0x1288('0x85'),_0x341885[_0x1288('0x79')],_0x341885['joins'][_0x26202c][_0x1288('0x82')],_0x341885[_0x1288('0x81')][_0x26202c][_0x1288('0x83')],_0x341885[_0x1288('0x81')][_0x26202c]['foreignKey']));}}}if(_0x341885[_0x1288('0x86')]){_0x341885[_0x1288('0x86')]=JSON['parse'](_0x341885[_0x1288('0x86')]);_0x4cfcfd[_0x1288('0x46')](_0x3f5fcb(_0x341885[_0x1288('0x86')][_0x1288('0x70')]));}_0x198326=_0x4cfcfd[_0x1288('0x87')]();_0x4cfcfd[_0x1288('0x1f')](_0x5a7153);_0x4cfcfd['offset'](0x0);logger['debug']('Limited\x20Query:',_0x4cfcfd[_0x1288('0x88')]());return dbH['sequelize'][_0x1288('0x41')](_0x4cfcfd[_0x1288('0x88')](),{'type':dbH[_0x1288('0x89')]['QueryTypes'][_0x1288('0x8a')]});}})['then'](respondWithResult(_0x3298cf,null))['catch'](handleError(_0x3298cf,null));};function runReport(_0x14cba0,_0x2d1a4f,_0x55494d){var _0x37b46d=_0x2d1a4f[_0x1288('0x2e')];var _0x4cefd3=0xa;var _0x50370e=[_0x1288('0x8b'),_0x1288('0x5d'),'right_join',_0x1288('0x5f')];var _0x23e54e={'SUM':_0x1288('0x60'),'COUNT':_0x1288('0x61'),'COUNT DISTINCT':_0x1288('0x62'),'MAX':_0x1288('0x8c'),'MIN':_0x1288('0x63'),'AVG':'AVG(%s)','GROUP_CONCAT':_0x1288('0x65'),'GROUP_CONCAT ASC':_0x1288('0x66'),'GROUP_CONCAT DESC':_0x1288('0x8d')};var _0x4dd13d={'SEC_TO_TIME':_0x1288('0x67'),'DATE':_0x1288('0x68'),'HOUR':_0x1288('0x8e'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x1288('0x6a')};var _0x14213f=function(_0xce6b04){return!_[_0x1288('0x6b')]([_0x1288('0x8f'),'IS\x20NOT\x20NULL',_0x1288('0x6c'),_0x1288('0x6d')],_0xce6b04);};var _0x2c5123=function(_0x50ed15){if(!_0x50ed15||!_0x50ed15['rules'][_0x1288('0x42')]){return'';}for(var _0x1108b3='(',_0x2367ed=0x0;_0x2367ed<_0x50ed15[_0x1288('0x6e')]['length'];_0x2367ed+=0x1){_0x2367ed>0x0&&(_0x1108b3+='\x20'+_0x50ed15[_0x1288('0x6f')]+'\x20');_0x1108b3+=_0x50ed15[_0x1288('0x6e')][_0x2367ed][_0x1288('0x70')]?_0x2c5123(_0x50ed15[_0x1288('0x6e')][_0x2367ed][_0x1288('0x70')]):_0x50ed15[_0x1288('0x6e')][_0x2367ed][_0x1288('0x71')]+'\x20'+_0x50ed15[_0x1288('0x6e')][_0x2367ed]['condition']+(_0x14213f(_0x50ed15[_0x1288('0x6e')][_0x2367ed][_0x1288('0x72')])?'\x20'+_0x50ed15['rules'][_0x2367ed]['value']:'');}return _0x1108b3+')';};var _0x141c3e={'where':{'id':_0x14cba0['id']}},_0x4c2e3f,_0x41076d,_0x13f591,_0xb22503,_0x5d8e0f;_0x141c3e=_[_0x1288('0x30')]({},_0x141c3e,_0x55494d);return db[_0x1288('0x38')][_0x1288('0x51')](_0x141c3e)['then'](function(_0x47fcfb){if(_0x47fcfb){_0x4c2e3f=_0x47fcfb;return _0x47fcfb['getFields']();}return null;})[_0x1288('0x26')](function(_0xe28bfd){if(_0xe28bfd){if(!_0xe28bfd[_0x1288('0x42')]){throw new db['Sequelize'][(_0x1288('0x75'))](_0x1288('0x76'),0x193);}_0x41076d=_0xe28bfd;return db[_0x1288('0x90')][_0x1288('0x4b')]({'raw':!![]});}return null;})[_0x1288('0x26')](function(_0x49562e){if(_0x49562e){_0x13f591=_[_0x1288('0x77')](_0x49562e,'id');var _0xef781d;var _0x1f9c00=squel['select']();_0x1f9c00[_0x1288('0x91')](_0x4c2e3f[_0x1288('0x79')]);for(var _0x54ecd5=0x0;_0x54ecd5<_0x41076d[_0x1288('0x42')];_0x54ecd5+=0x1){_0xef781d=_0x41076d[_0x54ecd5][_0x1288('0x7a')]?_0x13f591[_0x41076d[_0x54ecd5]['MetricId']][_0x1288('0x92')]:_0x41076d[_0x54ecd5][_0x1288('0x71')];_0xef781d=_0x41076d[_0x54ecd5][_0x1288('0x7c')]?_[_0x1288('0x7b')](_0x23e54e[_0x41076d[_0x54ecd5][_0x1288('0x7c')]],'%s',_0xef781d):_0xef781d;_0xef781d=_0x41076d[_0x54ecd5][_0x1288('0x7d')]?_[_0x1288('0x7b')](_0x4dd13d[_0x41076d[_0x54ecd5]['format']],'%s',_0xef781d):_0xef781d;if(_0x41076d[_0x54ecd5][_0x1288('0x7e')]){_0x1f9c00[_0x1288('0x70')](_0xef781d);}_0x41076d[_0x54ecd5]['orderBy']&&_0x1f9c00[_0x1288('0x44')](_0xef781d,_0x41076d[_0x54ecd5]['orderBy']===_0x1288('0x93')?![]:!![]);_0x1f9c00['field'](_0xef781d,_0x41076d[_0x54ecd5]['alias']||_0xef781d);}if(_0x4c2e3f[_0x1288('0x81')]){_0x4c2e3f[_0x1288('0x81')]=JSON[_0x1288('0x94')](_0x4c2e3f[_0x1288('0x81')]);for(var _0x233e0f=0x0;_0x233e0f<_0x4c2e3f[_0x1288('0x81')][_0x1288('0x42')];_0x233e0f+=0x1){if(_0x4c2e3f[_0x1288('0x81')][_0x233e0f]['type']&&_[_0x1288('0x6b')](_0x50370e,_0x4c2e3f[_0x1288('0x81')][_0x233e0f][_0x1288('0x3a')])&&_0x4c2e3f['joins'][_0x233e0f][_0x1288('0x82')]&&_0x4c2e3f[_0x1288('0x81')][_0x233e0f][_0x1288('0x83')]&&_0x4c2e3f[_0x1288('0x81')][_0x233e0f][_0x1288('0x84')]){_0x1f9c00[_0x4c2e3f[_0x1288('0x81')][_0x233e0f][_0x1288('0x3a')]](_0x4c2e3f[_0x1288('0x81')][_0x233e0f][_0x1288('0x83')],null,util[_0x1288('0x7d')](_0x1288('0x85'),_0x4c2e3f[_0x1288('0x79')],_0x4c2e3f[_0x1288('0x81')][_0x233e0f][_0x1288('0x82')],_0x4c2e3f[_0x1288('0x81')][_0x233e0f]['foreignTable'],_0x4c2e3f[_0x1288('0x81')][_0x233e0f][_0x1288('0x84')]));}}}if(_0x4c2e3f['conditions']){_0x4c2e3f[_0x1288('0x86')]=JSON[_0x1288('0x94')](_0x4c2e3f[_0x1288('0x86')]);_0x1f9c00[_0x1288('0x46')](_0x2c5123(_0x4c2e3f['conditions'][_0x1288('0x70')]));}_0x5d8e0f=_0x1f9c00[_0x1288('0x87')]();_0x1f9c00[_0x1288('0x1f')](_0x4cefd3);_0x1f9c00[_0x1288('0x1d')](0x0);return;}})[_0x1288('0x26')](function(){if(_0x2d1a4f[_0x1288('0x95')]==='web'){return null;}var _0x16fa7f=_[_0x1288('0x30')](_0x2d1a4f,{'name':_0x2d1a4f[_0x1288('0x96')]||_0x2d1a4f['name']||_0x4c2e3f[_0x1288('0x2e')],'basename':_0x37b46d,'savename':util['format'](_0x1288('0x97'),_0x2d1a4f[_0x1288('0x2e')]||_0x4c2e3f['name'],require(_0x1288('0x98'))[_0x1288('0x99')](0x4),_0x2d1a4f[_0x1288('0x95')]||_0x1288('0x9a')),'reportId':_0x4c2e3f['id'],'reportType':_0x1288('0x9b')});return db[_0x1288('0x9c')]['create'](_0x16fa7f,{'raw':!![]});})[_0x1288('0x26')](function(_0x44c098){if(_0x4c2e3f[_0x1288('0x79')]===_0x1288('0x9d')){_0x5d8e0f[_0x1288('0x46')](_0x4c2e3f[_0x1288('0x79')]+_0x1288('0x9e'),_0x2d1a4f[_0x1288('0x9f')],_0x2d1a4f['endDate']);}else{_0x5d8e0f[_0x1288('0x46')](_0x4c2e3f['table']+_0x1288('0xa0'),_0x2d1a4f['startDate'],_0x2d1a4f[_0x1288('0xa1')]);}if(_0x44c098){logger['info'](_0x1288('0xa2'),_0x5d8e0f[_0x1288('0x88')]());require('child_process')[_0x1288('0xa3')](path[_0x1288('0x8b')](__dirname,_0x1288('0xa4'),_0x44c098['output']),[_0x44c098['id'],_0x5d8e0f[_0x1288('0x88')](),path[_0x1288('0x8b')](__dirname,_0x1288('0xa5'),_0x44c098[_0x1288('0xa6')]),_0x37b46d]);return _0x44c098;}else{var _0x346085=squel[_0x1288('0x78')]();_0x346085[_0x1288('0x91')]('('+_0x5d8e0f[_0x1288('0x88')]()+')',_0x1288('0xa7'));_0x346085[_0x1288('0x71')]('COUNT(*)',_0x1288('0x20'));_0x5d8e0f[_0x1288('0x1f')](_0x2d1a4f['limit']||_0x4cefd3);_0x5d8e0f[_0x1288('0x1d')](_0x2d1a4f[_0x1288('0x1d')]||0x0);return dbH[_0x1288('0x89')][_0x1288('0x41')](_0x346085[_0x1288('0x88')](),{'type':dbH[_0x1288('0x89')]['QueryTypes'][_0x1288('0x8a')]})[_0x1288('0x26')](function(_0x2dfe9e){if(!_0x2dfe9e[_0x1288('0x42')]){_0xb22503=0x0;}else{_0xb22503=_0x2dfe9e[0x0][_0x1288('0x20')]||0x0;}return dbH[_0x1288('0x89')][_0x1288('0x41')](_0x5d8e0f[_0x1288('0x88')](),{'type':dbH['sequelize'][_0x1288('0xa8')][_0x1288('0x8a')]});})[_0x1288('0x26')](function(_0x1a9a36){return{'rows':_0x1a9a36||[],'count':_0xb22503};});}});}exports['run']=function(_0x575965,_0x2a533d){return runReport(_0x575965[_0x1288('0x5b')],_0x575965[_0x1288('0x41')],_0x575965[_0x1288('0x49')])[_0x1288('0x26')](respondWithResult(_0x2a533d,null))[_0x1288('0x4d')](handleError(_0x2a533d,null));};exports[_0x1288('0xa9')]=runReport;exports['query']=function(_0x57009a,_0x12930d){var _0x6b0b52=0xa;var _0x8015e1=[_0x1288('0x8b'),_0x1288('0x5d'),_0x1288('0x5e'),_0x1288('0x5f')];var _0x50a3ab={'SUM':_0x1288('0x60'),'COUNT':_0x1288('0x61'),'COUNT DISTINCT':_0x1288('0x62'),'MAX':_0x1288('0x8c'),'MIN':_0x1288('0x63'),'AVG':_0x1288('0x64'),'GROUP_CONCAT':_0x1288('0x65'),'GROUP_CONCAT ASC':_0x1288('0x66'),'GROUP_CONCAT DESC':_0x1288('0x8d')};var _0x1cda6c={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x1288('0x68'),'HOUR':_0x1288('0x8e'),'ROUND':_0x1288('0x69'),'UNIX_TIMESTAMP':_0x1288('0x6a')};var _0x171646=function(_0x54eaa1){return!_[_0x1288('0x6b')]([_0x1288('0x8f'),_0x1288('0xaa'),_0x1288('0x6c'),_0x1288('0x6d')],_0x54eaa1);};var _0x2ae398=function(_0x3de225){if(!_0x3de225||!_0x3de225[_0x1288('0x6e')][_0x1288('0x42')]){return'';}for(var _0xde323e='(',_0x5d44fa=0x0;_0x5d44fa<_0x3de225[_0x1288('0x6e')][_0x1288('0x42')];_0x5d44fa+=0x1){_0x5d44fa>0x0&&(_0xde323e+='\x20'+_0x3de225[_0x1288('0x6f')]+'\x20');_0xde323e+=_0x3de225[_0x1288('0x6e')][_0x5d44fa]['group']?_0x2ae398(_0x3de225['rules'][_0x5d44fa][_0x1288('0x70')]):_0x3de225[_0x1288('0x6e')][_0x5d44fa][_0x1288('0x71')]+'\x20'+_0x3de225['rules'][_0x5d44fa][_0x1288('0x72')]+(_0x171646(_0x3de225['rules'][_0x5d44fa][_0x1288('0x72')])?'\x20'+_0x3de225['rules'][_0x5d44fa][_0x1288('0xab')]:'');}return _0xde323e+')';};var _0xe06749={'where':{'id':_0x57009a[_0x1288('0x5b')]['id']}},_0x41d56f,_0x402ce6,_0x2e4ace,_0x1e93a0,_0x15728b;_0xe06749=_[_0x1288('0x30')]({},_0xe06749,_0x57009a[_0x1288('0x49')]);return db['AnalyticCustomReport'][_0x1288('0x51')](_0xe06749)[_0x1288('0x26')](function(_0x28bff4){if(_0x28bff4){_0x41d56f=_0x28bff4;return _0x28bff4[_0x1288('0x73')]();}return null;})['then'](function(_0x3298e5){if(_0x3298e5){if(!_0x3298e5[_0x1288('0x42')]){throw new db[(_0x1288('0x74'))][(_0x1288('0x75'))](_0x1288('0x76'),0x193);}_0x402ce6=_0x3298e5;return db[_0x1288('0x90')][_0x1288('0x4b')]({'raw':!![]});}return null;})['then'](function(_0x1ce12b){if(_0x1ce12b){_0x2e4ace=_[_0x1288('0x77')](_0x1ce12b,'id');var _0x33ca2e;var _0x267b53=squel[_0x1288('0x78')]();_0x267b53[_0x1288('0x91')](_0x41d56f[_0x1288('0x79')]);for(var _0x4daa12=0x0;_0x4daa12<_0x402ce6[_0x1288('0x42')];_0x4daa12+=0x1){_0x33ca2e=_0x402ce6[_0x4daa12][_0x1288('0x7a')]?_0x2e4ace[_0x402ce6[_0x4daa12][_0x1288('0x7a')]][_0x1288('0x92')]:_0x402ce6[_0x4daa12]['field'];_0x33ca2e=_0x402ce6[_0x4daa12][_0x1288('0x7c')]?_[_0x1288('0x7b')](_0x50a3ab[_0x402ce6[_0x4daa12][_0x1288('0x7c')]],'%s',_0x33ca2e):_0x33ca2e;_0x33ca2e=_0x402ce6[_0x4daa12][_0x1288('0x7d')]?_['replace'](_0x1cda6c[_0x402ce6[_0x4daa12]['format']],'%s',_0x33ca2e):_0x33ca2e;if(_0x402ce6[_0x4daa12][_0x1288('0x7e')]){_0x267b53[_0x1288('0x70')](_0x33ca2e);}_0x402ce6[_0x4daa12][_0x1288('0x7f')]&&_0x267b53[_0x1288('0x44')](_0x33ca2e,_0x402ce6[_0x4daa12][_0x1288('0x7f')]===_0x1288('0x93')?![]:!![]);_0x267b53[_0x1288('0x71')](_0x33ca2e,_0x402ce6[_0x4daa12][_0x1288('0x80')]||_0x33ca2e);}if(_0x41d56f[_0x1288('0x81')]){_0x41d56f[_0x1288('0x81')]=JSON[_0x1288('0x94')](_0x41d56f[_0x1288('0x81')]);for(var _0x162d62=0x0;_0x162d62<_0x41d56f['joins']['length'];_0x162d62+=0x1){if(_0x41d56f[_0x1288('0x81')][_0x162d62]['type']&&_[_0x1288('0x6b')](_0x8015e1,_0x41d56f[_0x1288('0x81')][_0x162d62]['type'])&&_0x41d56f[_0x1288('0x81')][_0x162d62]['parentKey']&&_0x41d56f[_0x1288('0x81')][_0x162d62]['foreignTable']&&_0x41d56f['joins'][_0x162d62][_0x1288('0x84')]){_0x267b53[_0x41d56f['joins'][_0x162d62]['type']](_0x41d56f[_0x1288('0x81')][_0x162d62][_0x1288('0x83')],null,util[_0x1288('0x7d')](_0x1288('0x85'),_0x41d56f[_0x1288('0x79')],_0x41d56f[_0x1288('0x81')][_0x162d62][_0x1288('0x82')],_0x41d56f[_0x1288('0x81')][_0x162d62][_0x1288('0x83')],_0x41d56f[_0x1288('0x81')][_0x162d62]['foreignKey']));}}}if(_0x41d56f[_0x1288('0x86')]){_0x41d56f[_0x1288('0x86')]=JSON['parse'](_0x41d56f['conditions']);_0x267b53[_0x1288('0x46')](_0x2ae398(_0x41d56f[_0x1288('0x86')][_0x1288('0x70')]));}_0x15728b=_0x267b53['clone']();_0x267b53[_0x1288('0x1f')](_0x6b0b52);_0x267b53[_0x1288('0x1d')](0x0);logger[_0x1288('0xac')](_0x1288('0xad'),_0x267b53[_0x1288('0x88')]());return dbH[_0x1288('0x89')][_0x1288('0x41')](_0x267b53['toString'](),{'type':dbH[_0x1288('0x89')][_0x1288('0xa8')][_0x1288('0x8a')]});}})[_0x1288('0x26')](function(){return{'sql':_0x15728b[_0x1288('0x88')]()};})['then'](respondWithResult(_0x12930d,null))[_0x1288('0x4d')](handleError(_0x12930d,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff