// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xdff2=['UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','value','getFields','ValidationErrorItem','AnalyticMetric','keyBy','select','table','MetricId','metric','replace','format','groupBy','orderBy','DESC','alias','joins','parse','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','conditions','clone','debug','Limited\x20Query:','toString','SELECT','SUM(%s)','COUNT(DISTINCT\x20%s)','MIN(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','DATE(%s)','HOUR(%s)','from','function','output','web','%s-%s.%s','randomstring','generate','csv','default','AnalyticExtractedReport','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','startDate','Run\x20Query:','fork','../../files/reports','savename','sequelize','QueryTypes','run','AVG(%s)','Sequelize','Please\x20insert\x20at\x20least\x20one\x20field','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','to-csv','lodash','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','dbH','status','end','json','offset','limit','undefined','count','set','Content-Range','apply','update','then','get','DefaultReports','destroy','sendStatus','error','name','send','render','body','contact','message','agent','interaction','account','index','rawAttributes','fieldName','type','model','keys','intersection','query','attributes','fields','length','nolimit','order','sort','where','filters','pick','merge','map','options','AnalyticDefaultReport','findAll','rows','catch','show','includeAll','include','find','create','user','role','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','preview','join','left_join','right_join','cross_join','COUNT(%s)','MAX(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','ROUND(%s)'];(function(_0x12eb81,_0x1fa5d1){var _0x1852f4=function(_0xae73a0){while(--_0xae73a0){_0x12eb81['push'](_0x12eb81['shift']());}};_0x1852f4(++_0x1fa5d1);}(_0xdff2,0xe9));var _0x2dff=function(_0x22ea7a,_0x36f82b){_0x22ea7a=_0x22ea7a-0x0;var _0x462110=_0xdff2[_0x22ea7a];return _0x462110;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0x2dff('0x0'));var jsonpatch=require(_0x2dff('0x1'));var rp=require(_0x2dff('0x2'));var moment=require(_0x2dff('0x3'));var BPromise=require(_0x2dff('0x4'));var Mustache=require(_0x2dff('0x5'));var util=require(_0x2dff('0x6'));var path=require(_0x2dff('0x7'));var sox=require('sox');var csv=require(_0x2dff('0x8'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x2dff('0x9'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x2dff('0xa'));var deskjs=require(_0x2dff('0xb'));var toCsv=require(_0x2dff('0x8'));var querystring=require(_0x2dff('0xc'));var Papa=require(_0x2dff('0xd'));var Redis=require(_0x2dff('0xe'));var authService=require(_0x2dff('0xf'));var qs=require(_0x2dff('0x10'));var as=require(_0x2dff('0x11'));var hardwareService=require(_0x2dff('0x12'));var logger=require(_0x2dff('0x13'))(_0x2dff('0x14'));var utils=require(_0x2dff('0x15'));var config=require(_0x2dff('0x16'));var licenseUtil=require(_0x2dff('0x17'));var db=require('../../mysqldb')['db'];var dbH=require(_0x2dff('0x18'))[_0x2dff('0x19')];function respondWithStatusCode(_0x59bd46,_0x5a2358){_0x5a2358=_0x5a2358||0xcc;return function(_0xb20d45){if(_0xb20d45){return _0x59bd46['sendStatus'](_0x5a2358);}return _0x59bd46[_0x2dff('0x1a')](_0x5a2358)[_0x2dff('0x1b')]();};}function respondWithResult(_0x4f6d14,_0x179551){_0x179551=_0x179551||0xc8;return function(_0x236476){if(_0x236476){return _0x4f6d14[_0x2dff('0x1a')](_0x179551)[_0x2dff('0x1c')](_0x236476);}};}function respondWithFilteredResult(_0x2254bf,_0x43363b){return function(_0x484e70){if(_0x484e70){var _0x5479b9=typeof _0x43363b[_0x2dff('0x1d')]==='undefined'&&typeof _0x43363b[_0x2dff('0x1e')]===_0x2dff('0x1f');var _0x284039=_0x484e70['count'];var _0x4b9837=_0x5479b9?0x0:_0x43363b[_0x2dff('0x1d')];var _0x3d62f7=_0x5479b9?_0x484e70[_0x2dff('0x20')]:_0x43363b['offset']+_0x43363b[_0x2dff('0x1e')];var _0x3b90eb;if(_0x3d62f7>=_0x284039){_0x3d62f7=_0x284039;_0x3b90eb=0xc8;}else{_0x3b90eb=0xce;}_0x2254bf[_0x2dff('0x1a')](_0x3b90eb);return _0x2254bf[_0x2dff('0x21')](_0x2dff('0x22'),_0x4b9837+'-'+_0x3d62f7+'/'+_0x284039)[_0x2dff('0x1c')](_0x484e70);}return null;};}function patchUpdates(_0x3599c4){return function(_0x6546b){try{jsonpatch[_0x2dff('0x23')](_0x6546b,_0x3599c4,!![]);}catch(_0x3e352d){return BPromise['reject'](_0x3e352d);}return _0x6546b['save']();};}function saveUpdates(_0x2f73b4,_0x142b21){return function(_0x5f1118){if(_0x5f1118){return _0x5f1118[_0x2dff('0x24')](_0x2f73b4)[_0x2dff('0x25')](function(_0x50fa26){return _0x50fa26;});}return null;};}function removeEntity(_0x2d5588,_0x4d9c60){return function(_0x2ca02c){if(_0x2ca02c){return _0x2ca02c['destroy']()[_0x2dff('0x25')](function(){var _0x19e7fb=_0x2ca02c[_0x2dff('0x26')]({'plain':!![]});var _0x52a507=_0x2dff('0x27');return db['UserProfileResource'][_0x2dff('0x28')]({'where':{'type':_0x52a507,'resourceId':_0x19e7fb['id']}})[_0x2dff('0x25')](function(){return _0x2ca02c;});})[_0x2dff('0x25')](function(){_0x2d5588['status'](0xcc)[_0x2dff('0x1b')]();});}};}function handleEntityNotFound(_0xbb4cde,_0x4c7d0d){return function(_0x459ce3){if(!_0x459ce3){_0xbb4cde[_0x2dff('0x29')](0x194);}return _0x459ce3;};}function handleError(_0x3f0edc,_0x4d8b0c){_0x4d8b0c=_0x4d8b0c||0x1f4;return function(_0x8d3000){logger[_0x2dff('0x2a')](_0x8d3000['stack']);if(_0x8d3000[_0x2dff('0x2b')]){delete _0x8d3000[_0x2dff('0x2b')];}_0x3f0edc['status'](_0x4d8b0c)[_0x2dff('0x2c')](_0x8d3000);};}function getMustacheRender(_0x302c6d,_0x5ec408){return Mustache[_0x2dff('0x2d')](_0x302c6d,_['merge'](_0x5ec408[_0x2dff('0x2e')],{'contact':_0x5ec408[_0x2dff('0x2f')],'message':_0x5ec408[_0x2dff('0x30')],'agent':_0x5ec408[_0x2dff('0x31')],'interaction':_0x5ec408[_0x2dff('0x32')],'account':_0x5ec408[_0x2dff('0x33')]}))||'';}exports[_0x2dff('0x34')]=function(_0x22ac1c,_0x42ec35){var _0x4faabc={},_0x5e84c0={},_0x44805d={'count':0x0,'rows':[]};var _0x2a198c=_['map'](db['AnalyticDefaultReport'][_0x2dff('0x35')],function(_0x409898){return{'name':_0x409898[_0x2dff('0x36')],'type':_0x409898[_0x2dff('0x37')]['key']};});_0x5e84c0[_0x2dff('0x38')]=_['map'](_0x2a198c,_0x2dff('0x2b'));_0x5e84c0['query']=_[_0x2dff('0x39')](_0x22ac1c['query']);_0x5e84c0['filters']=_[_0x2dff('0x3a')](_0x5e84c0[_0x2dff('0x38')],_0x5e84c0[_0x2dff('0x3b')]);_0x4faabc[_0x2dff('0x3c')]=_[_0x2dff('0x3a')](_0x5e84c0[_0x2dff('0x38')],qs[_0x2dff('0x3d')](_0x22ac1c['query']['fields']));_0x4faabc['attributes']=_0x4faabc[_0x2dff('0x3c')][_0x2dff('0x3e')]?_0x4faabc[_0x2dff('0x3c')]:_0x5e84c0[_0x2dff('0x38')];if(!_0x22ac1c['query']['hasOwnProperty'](_0x2dff('0x3f'))){_0x4faabc['limit']=qs[_0x2dff('0x1e')](_0x22ac1c[_0x2dff('0x3b')][_0x2dff('0x1e')]);_0x4faabc[_0x2dff('0x1d')]=qs[_0x2dff('0x1d')](_0x22ac1c['query'][_0x2dff('0x1d')]);}_0x4faabc[_0x2dff('0x40')]=qs['sort'](_0x22ac1c[_0x2dff('0x3b')][_0x2dff('0x41')]);_0x4faabc[_0x2dff('0x42')]=qs[_0x2dff('0x43')](_[_0x2dff('0x44')](_0x22ac1c['query'],_0x5e84c0['filters']),_0x2a198c);if(_0x22ac1c[_0x2dff('0x3b')]['filter']){_0x4faabc[_0x2dff('0x42')]=_[_0x2dff('0x45')](_0x4faabc[_0x2dff('0x42')],{'$or':_[_0x2dff('0x46')](_0x2a198c,function(_0x3f7317){if(_0x3f7317[_0x2dff('0x37')]!=='VIRTUAL'){var _0x409650={};_0x409650[_0x3f7317[_0x2dff('0x2b')]]={'$like':'%'+_0x22ac1c['query']['filter']+'%'};return _0x409650;}})});}_0x4faabc=_['merge']({},_0x4faabc,_0x22ac1c[_0x2dff('0x47')]);var _0x36f87f={'where':_0x4faabc['where']};return db[_0x2dff('0x48')][_0x2dff('0x20')](_0x36f87f)['then'](function(_0x5f5669){_0x44805d[_0x2dff('0x20')]=_0x5f5669;if(_0x22ac1c[_0x2dff('0x3b')]['includeAll']){_0x4faabc['include']=[{'all':!![]}];}return db['AnalyticDefaultReport'][_0x2dff('0x49')](_0x4faabc);})[_0x2dff('0x25')](function(_0x553d3b){_0x44805d[_0x2dff('0x4a')]=_0x553d3b;return _0x44805d;})['then'](respondWithFilteredResult(_0x42ec35,_0x4faabc))[_0x2dff('0x4b')](handleError(_0x42ec35,null));};exports[_0x2dff('0x4c')]=function(_0x325145,_0x355823){var _0x28f126={'raw':!![],'where':{'id':_0x325145['params']['id']}},_0x466cec={};_0x466cec[_0x2dff('0x38')]=_[_0x2dff('0x39')](db['AnalyticDefaultReport']['rawAttributes']);_0x466cec[_0x2dff('0x3b')]=_[_0x2dff('0x39')](_0x325145[_0x2dff('0x3b')]);_0x466cec[_0x2dff('0x43')]=_[_0x2dff('0x3a')](_0x466cec[_0x2dff('0x38')],_0x466cec['query']);_0x28f126['attributes']=_[_0x2dff('0x3a')](_0x466cec[_0x2dff('0x38')],qs[_0x2dff('0x3d')](_0x325145['query'][_0x2dff('0x3d')]));_0x28f126['attributes']=_0x28f126[_0x2dff('0x3c')]['length']?_0x28f126[_0x2dff('0x3c')]:_0x466cec['model'];if(_0x325145['query'][_0x2dff('0x4d')]){_0x28f126[_0x2dff('0x4e')]=[{'all':!![]}];}_0x28f126=_[_0x2dff('0x45')]({},_0x28f126,_0x325145['options']);return db[_0x2dff('0x48')][_0x2dff('0x4f')](_0x28f126)['then'](handleEntityNotFound(_0x355823,null))['then'](respondWithResult(_0x355823,null))[_0x2dff('0x4b')](handleError(_0x355823,null));};exports[_0x2dff('0x50')]=function(_0x158e0c,_0x3984f4){return db[_0x2dff('0x48')][_0x2dff('0x50')](_0x158e0c[_0x2dff('0x2e')],{})[_0x2dff('0x25')](function(_0x2d24b5){var _0x3d226e=_0x158e0c[_0x2dff('0x51')][_0x2dff('0x26')]({'plain':!![]});if(!_0x3d226e)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x3d226e[_0x2dff('0x52')]==='user'){var _0x5c27a0=_0x2d24b5[_0x2dff('0x26')]({'plain':!![]});var _0xc14602='Reports';return db[_0x2dff('0x53')][_0x2dff('0x4f')]({'where':{'name':_0xc14602,'userProfileId':_0x3d226e[_0x2dff('0x54')]},'raw':!![]})[_0x2dff('0x25')](function(_0x15159c){if(_0x15159c&&_0x15159c[_0x2dff('0x55')]===0x0){return db['UserProfileResource']['create']({'name':_0x5c27a0['name'],'resourceId':_0x5c27a0['id'],'type':'DefaultReports','sectionId':_0x15159c['id']},{})[_0x2dff('0x25')](function(){return _0x2d24b5;});}else{return _0x2d24b5;}})[_0x2dff('0x4b')](function(_0x24df1c){logger['error'](_0x2dff('0x56'),_0x24df1c);throw _0x24df1c;});}return _0x2d24b5;})[_0x2dff('0x25')](respondWithResult(_0x3984f4,0xc9))[_0x2dff('0x4b')](handleError(_0x3984f4,null));};exports[_0x2dff('0x24')]=function(_0x5cff10,_0x5709db){if(_0x5cff10[_0x2dff('0x2e')]['id']){delete _0x5cff10[_0x2dff('0x2e')]['id'];}return db[_0x2dff('0x48')]['find']({'where':{'id':_0x5cff10[_0x2dff('0x57')]['id']}})['then'](handleEntityNotFound(_0x5709db,null))[_0x2dff('0x25')](saveUpdates(_0x5cff10[_0x2dff('0x2e')],null))[_0x2dff('0x25')](respondWithResult(_0x5709db,null))[_0x2dff('0x4b')](handleError(_0x5709db,null));};exports[_0x2dff('0x28')]=function(_0x4dc108,_0x57e2a9){return db[_0x2dff('0x48')][_0x2dff('0x4f')]({'where':{'id':_0x4dc108[_0x2dff('0x57')]['id']}})[_0x2dff('0x25')](handleEntityNotFound(_0x57e2a9,null))[_0x2dff('0x25')](removeEntity(_0x57e2a9,null))[_0x2dff('0x4b')](handleError(_0x57e2a9,null));};exports[_0x2dff('0x58')]=function(_0x69e97,_0x585ab7){var _0x55ec2a=0xa;var _0xe0115e=[_0x2dff('0x59'),_0x2dff('0x5a'),_0x2dff('0x5b'),_0x2dff('0x5c')];var _0x32e8e2={'SUM':'SUM(%s)','COUNT':_0x2dff('0x5d'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x2dff('0x5e'),'MIN':'MIN(%s)','AVG':'AVG(%s)','GROUP_CONCAT':_0x2dff('0x5f'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0x2dff('0x60')};var _0x1c6e33={'SEC_TO_TIME':_0x2dff('0x61'),'DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':_0x2dff('0x62'),'UNIX_TIMESTAMP':_0x2dff('0x63')};var _0x2db1f1=function(_0x490f6c){return!_[_0x2dff('0x64')]([_0x2dff('0x65'),_0x2dff('0x66'),_0x2dff('0x67'),_0x2dff('0x68')],_0x490f6c);};var _0x4dbe23=function(_0x3fc932){if(!_0x3fc932||!_0x3fc932[_0x2dff('0x69')][_0x2dff('0x3e')]){return'';}for(var _0x46624c='(',_0x5b5b73=0x0;_0x5b5b73<_0x3fc932['rules'][_0x2dff('0x3e')];_0x5b5b73+=0x1){_0x5b5b73>0x0&&(_0x46624c+='\x20'+_0x3fc932[_0x2dff('0x6a')]+'\x20');_0x46624c+=_0x3fc932[_0x2dff('0x69')][_0x5b5b73]['group']?_0x4dbe23(_0x3fc932['rules'][_0x5b5b73][_0x2dff('0x6b')]):_0x3fc932[_0x2dff('0x69')][_0x5b5b73][_0x2dff('0x6c')]+'\x20'+_0x3fc932[_0x2dff('0x69')][_0x5b5b73][_0x2dff('0x6d')]+(_0x2db1f1(_0x3fc932['rules'][_0x5b5b73]['condition'])?'\x20'+_0x3fc932[_0x2dff('0x69')][_0x5b5b73][_0x2dff('0x6e')]:'');}return _0x46624c+')';};var _0x14c4c9={'where':{'id':_0x69e97['params']['id']}},_0x105fc0,_0x13ae8c,_0x5ede45,_0x4ec52f,_0x5b29ce;_0x14c4c9=_[_0x2dff('0x45')]({},_0x14c4c9,_0x69e97['options']);return db[_0x2dff('0x48')][_0x2dff('0x4f')](_0x14c4c9)[_0x2dff('0x25')](function(_0x512cd8){if(_0x512cd8){_0x105fc0=_0x512cd8;return _0x512cd8[_0x2dff('0x6f')]();}return null;})['then'](function(_0x3e8111){if(_0x3e8111){if(!_0x3e8111['length']){throw new db['Sequelize'][(_0x2dff('0x70'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x13ae8c=_0x3e8111;return db[_0x2dff('0x71')][_0x2dff('0x49')]({'raw':!![]});}return null;})[_0x2dff('0x25')](function(_0x1c0948){if(_0x1c0948){_0x5ede45=_[_0x2dff('0x72')](_0x1c0948,'id');var _0x1f0a49;var _0x38f736=squel[_0x2dff('0x73')]();_0x38f736['from'](_0x105fc0[_0x2dff('0x74')]);for(var _0x246aed=0x0;_0x246aed<_0x13ae8c[_0x2dff('0x3e')];_0x246aed+=0x1){_0x1f0a49=_0x13ae8c[_0x246aed]['MetricId']?_0x5ede45[_0x13ae8c[_0x246aed][_0x2dff('0x75')]][_0x2dff('0x76')]:_0x13ae8c[_0x246aed][_0x2dff('0x6c')];_0x1f0a49=_0x13ae8c[_0x246aed]['function']?_[_0x2dff('0x77')](_0x32e8e2[_0x13ae8c[_0x246aed]['function']],'%s',_0x1f0a49):_0x1f0a49;_0x1f0a49=_0x13ae8c[_0x246aed][_0x2dff('0x78')]?_['replace'](_0x1c6e33[_0x13ae8c[_0x246aed][_0x2dff('0x78')]],'%s',_0x1f0a49):_0x1f0a49;if(_0x13ae8c[_0x246aed][_0x2dff('0x79')]){_0x38f736[_0x2dff('0x6b')](_0x1f0a49);}_0x13ae8c[_0x246aed]['orderBy']&&_0x38f736[_0x2dff('0x40')](_0x1f0a49,_0x13ae8c[_0x246aed][_0x2dff('0x7a')]===_0x2dff('0x7b')?![]:!![]);_0x38f736[_0x2dff('0x6c')](_0x1f0a49,_0x13ae8c[_0x246aed][_0x2dff('0x7c')]||_0x1f0a49);}if(_0x105fc0[_0x2dff('0x7d')]){_0x105fc0[_0x2dff('0x7d')]=JSON[_0x2dff('0x7e')](_0x105fc0[_0x2dff('0x7d')]);for(var _0x100726=0x0;_0x100726<_0x105fc0[_0x2dff('0x7d')][_0x2dff('0x3e')];_0x100726+=0x1){if(_0x105fc0[_0x2dff('0x7d')][_0x100726][_0x2dff('0x37')]&&_['includes'](_0xe0115e,_0x105fc0[_0x2dff('0x7d')][_0x100726]['type'])&&_0x105fc0['joins'][_0x100726][_0x2dff('0x7f')]&&_0x105fc0[_0x2dff('0x7d')][_0x100726][_0x2dff('0x80')]&&_0x105fc0[_0x2dff('0x7d')][_0x100726][_0x2dff('0x81')]){_0x38f736[_0x105fc0[_0x2dff('0x7d')][_0x100726][_0x2dff('0x37')]](_0x105fc0[_0x2dff('0x7d')][_0x100726][_0x2dff('0x80')],null,util[_0x2dff('0x78')](_0x2dff('0x82'),_0x105fc0[_0x2dff('0x74')],_0x105fc0[_0x2dff('0x7d')][_0x100726][_0x2dff('0x7f')],_0x105fc0[_0x2dff('0x7d')][_0x100726][_0x2dff('0x80')],_0x105fc0[_0x2dff('0x7d')][_0x100726][_0x2dff('0x81')]));}}}if(_0x105fc0[_0x2dff('0x83')]){_0x105fc0[_0x2dff('0x83')]=JSON[_0x2dff('0x7e')](_0x105fc0[_0x2dff('0x83')]);_0x38f736[_0x2dff('0x42')](_0x4dbe23(_0x105fc0[_0x2dff('0x83')][_0x2dff('0x6b')]));}_0x5b29ce=_0x38f736[_0x2dff('0x84')]();_0x38f736['limit'](_0x55ec2a);_0x38f736[_0x2dff('0x1d')](0x0);logger[_0x2dff('0x85')](_0x2dff('0x86'),_0x38f736[_0x2dff('0x87')]());return dbH['sequelize'][_0x2dff('0x3b')](_0x38f736['toString'](),{'type':dbH['sequelize']['QueryTypes'][_0x2dff('0x88')]});}})['then'](respondWithResult(_0x585ab7,null))[_0x2dff('0x4b')](handleError(_0x585ab7,null));};function runReport(_0x2980a0,_0x327141,_0x51d26f){var _0x92c079=_0x327141[_0x2dff('0x2b')];var _0x402208=0xa;var _0x3ff63b=[_0x2dff('0x59'),_0x2dff('0x5a'),_0x2dff('0x5b'),_0x2dff('0x5c')];var _0x4adf5d={'SUM':_0x2dff('0x89'),'COUNT':_0x2dff('0x5d'),'COUNT DISTINCT':_0x2dff('0x8a'),'MAX':_0x2dff('0x5e'),'MIN':_0x2dff('0x8b'),'AVG':'AVG(%s)','GROUP_CONCAT':_0x2dff('0x5f'),'GROUP_CONCAT ASC':_0x2dff('0x8c'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x58e5de={'SEC_TO_TIME':_0x2dff('0x61'),'DATE':_0x2dff('0x8d'),'HOUR':_0x2dff('0x8e'),'ROUND':_0x2dff('0x62'),'UNIX_TIMESTAMP':_0x2dff('0x63')};var _0x50b2c1=function(_0x3c8b9a){return!_[_0x2dff('0x64')]([_0x2dff('0x65'),'IS\x20NOT\x20NULL','IS\x20EMPTY',_0x2dff('0x68')],_0x3c8b9a);};var _0x218ef2=function(_0x34a01c){if(!_0x34a01c||!_0x34a01c['rules'][_0x2dff('0x3e')]){return'';}for(var _0x383d19='(',_0x24de26=0x0;_0x24de26<_0x34a01c[_0x2dff('0x69')][_0x2dff('0x3e')];_0x24de26+=0x1){_0x24de26>0x0&&(_0x383d19+='\x20'+_0x34a01c[_0x2dff('0x6a')]+'\x20');_0x383d19+=_0x34a01c[_0x2dff('0x69')][_0x24de26][_0x2dff('0x6b')]?_0x218ef2(_0x34a01c[_0x2dff('0x69')][_0x24de26][_0x2dff('0x6b')]):_0x34a01c[_0x2dff('0x69')][_0x24de26][_0x2dff('0x6c')]+'\x20'+_0x34a01c[_0x2dff('0x69')][_0x24de26][_0x2dff('0x6d')]+(_0x50b2c1(_0x34a01c['rules'][_0x24de26]['condition'])?'\x20'+_0x34a01c['rules'][_0x24de26]['value']:'');}return _0x383d19+')';};var _0x4ebc3a={'where':{'id':_0x2980a0['id']}},_0x1460de,_0x1c4810,_0x15854b,_0x44e516,_0x2a8d1b;_0x4ebc3a=_[_0x2dff('0x45')]({},_0x4ebc3a,_0x51d26f);return db['AnalyticDefaultReport'][_0x2dff('0x4f')](_0x4ebc3a)[_0x2dff('0x25')](function(_0x49b2b9){if(_0x49b2b9){_0x1460de=_0x49b2b9;return _0x49b2b9['getFields']();}return null;})[_0x2dff('0x25')](function(_0x212f94){if(_0x212f94){if(!_0x212f94[_0x2dff('0x3e')]){throw new db['Sequelize']['ValidationErrorItem']('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x1c4810=_0x212f94;return db[_0x2dff('0x71')]['findAll']({'raw':!![]});}return null;})[_0x2dff('0x25')](function(_0x474c7c){if(_0x474c7c){_0x15854b=_[_0x2dff('0x72')](_0x474c7c,'id');var _0x20d55e;var _0x2fba0e=squel[_0x2dff('0x73')]();_0x2fba0e[_0x2dff('0x8f')](_0x1460de[_0x2dff('0x74')]);for(var _0xcdc401=0x0;_0xcdc401<_0x1c4810[_0x2dff('0x3e')];_0xcdc401+=0x1){_0x20d55e=_0x1c4810[_0xcdc401]['MetricId']?_0x15854b[_0x1c4810[_0xcdc401][_0x2dff('0x75')]][_0x2dff('0x76')]:_0x1c4810[_0xcdc401][_0x2dff('0x6c')];_0x20d55e=_0x1c4810[_0xcdc401][_0x2dff('0x90')]?_[_0x2dff('0x77')](_0x4adf5d[_0x1c4810[_0xcdc401]['function']],'%s',_0x20d55e):_0x20d55e;_0x20d55e=_0x1c4810[_0xcdc401][_0x2dff('0x78')]?_['replace'](_0x58e5de[_0x1c4810[_0xcdc401][_0x2dff('0x78')]],'%s',_0x20d55e):_0x20d55e;if(_0x1c4810[_0xcdc401][_0x2dff('0x79')]){_0x2fba0e[_0x2dff('0x6b')](_0x20d55e);}_0x1c4810[_0xcdc401]['orderBy']&&_0x2fba0e[_0x2dff('0x40')](_0x20d55e,_0x1c4810[_0xcdc401][_0x2dff('0x7a')]===_0x2dff('0x7b')?![]:!![]);_0x2fba0e[_0x2dff('0x6c')](_0x20d55e,_0x1c4810[_0xcdc401][_0x2dff('0x7c')]||_0x20d55e);}if(_0x1460de[_0x2dff('0x7d')]){_0x1460de['joins']=JSON[_0x2dff('0x7e')](_0x1460de['joins']);for(var _0x4facf7=0x0;_0x4facf7<_0x1460de[_0x2dff('0x7d')][_0x2dff('0x3e')];_0x4facf7+=0x1){if(_0x1460de[_0x2dff('0x7d')][_0x4facf7][_0x2dff('0x37')]&&_[_0x2dff('0x64')](_0x3ff63b,_0x1460de[_0x2dff('0x7d')][_0x4facf7][_0x2dff('0x37')])&&_0x1460de[_0x2dff('0x7d')][_0x4facf7][_0x2dff('0x7f')]&&_0x1460de['joins'][_0x4facf7][_0x2dff('0x80')]&&_0x1460de[_0x2dff('0x7d')][_0x4facf7][_0x2dff('0x81')]){_0x2fba0e[_0x1460de[_0x2dff('0x7d')][_0x4facf7]['type']](_0x1460de[_0x2dff('0x7d')][_0x4facf7][_0x2dff('0x80')],null,util['format'](_0x2dff('0x82'),_0x1460de[_0x2dff('0x74')],_0x1460de[_0x2dff('0x7d')][_0x4facf7][_0x2dff('0x7f')],_0x1460de[_0x2dff('0x7d')][_0x4facf7][_0x2dff('0x80')],_0x1460de[_0x2dff('0x7d')][_0x4facf7][_0x2dff('0x81')]));}}}if(_0x1460de[_0x2dff('0x83')]){_0x1460de[_0x2dff('0x83')]=JSON['parse'](_0x1460de[_0x2dff('0x83')]);_0x2fba0e['where'](_0x218ef2(_0x1460de[_0x2dff('0x83')][_0x2dff('0x6b')]));}_0x2a8d1b=_0x2fba0e[_0x2dff('0x84')]();_0x2fba0e[_0x2dff('0x1e')](_0x402208);_0x2fba0e[_0x2dff('0x1d')](0x0);return;}})[_0x2dff('0x25')](function(){if(_0x327141[_0x2dff('0x91')]===_0x2dff('0x92')){return null;}var _0x441eb=_[_0x2dff('0x45')](_0x327141,{'name':_0x327141['fullPath']||_0x327141[_0x2dff('0x2b')]||_0x1460de['name'],'basename':_0x92c079,'savename':util['format'](_0x2dff('0x93'),_0x327141[_0x2dff('0x2b')]||_0x1460de[_0x2dff('0x2b')],require(_0x2dff('0x94'))[_0x2dff('0x95')](0x4),_0x327141[_0x2dff('0x91')]||_0x2dff('0x96')),'reportId':_0x1460de['id'],'reportType':_0x2dff('0x97')});return db[_0x2dff('0x98')][_0x2dff('0x50')](_0x441eb,{'raw':!![]});})[_0x2dff('0x25')](function(_0x2439ca){if(_0x1460de[_0x2dff('0x74')]==='cdr'){_0x2a8d1b[_0x2dff('0x42')](_0x1460de[_0x2dff('0x74')]+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x327141['startDate'],_0x327141[_0x2dff('0x99')]);}else{_0x2a8d1b[_0x2dff('0x42')](_0x1460de[_0x2dff('0x74')]+_0x2dff('0x9a'),_0x327141[_0x2dff('0x9b')],_0x327141['endDate']);}if(_0x2439ca){logger['info'](_0x2dff('0x9c'),_0x2a8d1b['toString']());require('child_process')[_0x2dff('0x9d')](path['join'](__dirname,'../../components/export/',_0x2439ca['output']),[_0x2439ca['id'],_0x2a8d1b[_0x2dff('0x87')](),path[_0x2dff('0x59')](__dirname,_0x2dff('0x9e'),_0x2439ca[_0x2dff('0x9f')]),_0x92c079]);return _0x2439ca;}else{var _0x493b0f=squel[_0x2dff('0x73')]();_0x493b0f[_0x2dff('0x8f')]('('+_0x2a8d1b[_0x2dff('0x87')]()+')','countTable');_0x493b0f[_0x2dff('0x6c')]('COUNT(*)',_0x2dff('0x20'));_0x2a8d1b[_0x2dff('0x1e')](_0x327141[_0x2dff('0x1e')]||_0x402208);_0x2a8d1b['offset'](_0x327141['offset']||0x0);return dbH['sequelize']['query'](_0x493b0f[_0x2dff('0x87')](),{'type':dbH[_0x2dff('0xa0')][_0x2dff('0xa1')]['SELECT']})[_0x2dff('0x25')](function(_0x38568d){if(!_0x38568d[_0x2dff('0x3e')]){_0x44e516=0x0;}else{_0x44e516=_0x38568d[0x0]['count']||0x0;}return dbH[_0x2dff('0xa0')]['query'](_0x2a8d1b[_0x2dff('0x87')](),{'type':dbH['sequelize']['QueryTypes'][_0x2dff('0x88')]});})[_0x2dff('0x25')](function(_0x59c5eb){return{'rows':_0x59c5eb||[],'count':_0x44e516};});}});}exports[_0x2dff('0xa2')]=function(_0xa6e0c8,_0x33b12f){return runReport(_0xa6e0c8['params'],_0xa6e0c8[_0x2dff('0x3b')],_0xa6e0c8[_0x2dff('0x47')])[_0x2dff('0x25')](respondWithResult(_0x33b12f,null))[_0x2dff('0x4b')](handleError(_0x33b12f,null));};exports['runReport']=runReport;exports[_0x2dff('0x3b')]=function(_0x2cf6da,_0x5255b1){var _0x34591e=0xa;var _0x367a04=[_0x2dff('0x59'),_0x2dff('0x5a'),'right_join',_0x2dff('0x5c')];var _0x5c1362={'SUM':_0x2dff('0x89'),'COUNT':_0x2dff('0x5d'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x2dff('0x5e'),'MIN':_0x2dff('0x8b'),'AVG':_0x2dff('0xa3'),'GROUP_CONCAT':_0x2dff('0x5f'),'GROUP_CONCAT ASC':_0x2dff('0x8c'),'GROUP_CONCAT DESC':_0x2dff('0x60')};var _0x4d4dd2={'SEC_TO_TIME':_0x2dff('0x61'),'DATE':'DATE(%s)','HOUR':_0x2dff('0x8e'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x125769=function(_0x45047f){return!_['includes']([_0x2dff('0x65'),_0x2dff('0x66'),_0x2dff('0x67'),'IS\x20NOT\x20EMPTY'],_0x45047f);};var _0x3b4a74=function(_0x1ff10d){if(!_0x1ff10d||!_0x1ff10d[_0x2dff('0x69')][_0x2dff('0x3e')]){return'';}for(var _0x5a22c8='(',_0x370f1=0x0;_0x370f1<_0x1ff10d[_0x2dff('0x69')][_0x2dff('0x3e')];_0x370f1+=0x1){_0x370f1>0x0&&(_0x5a22c8+='\x20'+_0x1ff10d[_0x2dff('0x6a')]+'\x20');_0x5a22c8+=_0x1ff10d[_0x2dff('0x69')][_0x370f1][_0x2dff('0x6b')]?_0x3b4a74(_0x1ff10d[_0x2dff('0x69')][_0x370f1][_0x2dff('0x6b')]):_0x1ff10d['rules'][_0x370f1][_0x2dff('0x6c')]+'\x20'+_0x1ff10d[_0x2dff('0x69')][_0x370f1][_0x2dff('0x6d')]+(_0x125769(_0x1ff10d[_0x2dff('0x69')][_0x370f1][_0x2dff('0x6d')])?'\x20'+_0x1ff10d[_0x2dff('0x69')][_0x370f1][_0x2dff('0x6e')]:'');}return _0x5a22c8+')';};var _0x12674e={'where':{'id':_0x2cf6da[_0x2dff('0x57')]['id']}},_0x1964c0,_0x1cda7a,_0x41d06c,_0x5c21e7,_0x40650f;_0x12674e=_['merge']({},_0x12674e,_0x2cf6da[_0x2dff('0x47')]);return db['AnalyticDefaultReport'][_0x2dff('0x4f')](_0x12674e)['then'](function(_0x1c577f){if(_0x1c577f){_0x1964c0=_0x1c577f;return _0x1c577f['getFields']();}return null;})['then'](function(_0x289673){if(_0x289673){if(!_0x289673[_0x2dff('0x3e')]){throw new db[(_0x2dff('0xa4'))][(_0x2dff('0x70'))](_0x2dff('0xa5'),0x193);}_0x1cda7a=_0x289673;return db[_0x2dff('0x71')][_0x2dff('0x49')]({'raw':!![]});}return null;})[_0x2dff('0x25')](function(_0x1f69c1){if(_0x1f69c1){_0x41d06c=_[_0x2dff('0x72')](_0x1f69c1,'id');var _0x30b83f;var _0x489598=squel['select']();_0x489598['from'](_0x1964c0[_0x2dff('0x74')]);for(var _0xbaf60e=0x0;_0xbaf60e<_0x1cda7a[_0x2dff('0x3e')];_0xbaf60e+=0x1){_0x30b83f=_0x1cda7a[_0xbaf60e][_0x2dff('0x75')]?_0x41d06c[_0x1cda7a[_0xbaf60e][_0x2dff('0x75')]][_0x2dff('0x76')]:_0x1cda7a[_0xbaf60e][_0x2dff('0x6c')];_0x30b83f=_0x1cda7a[_0xbaf60e]['function']?_['replace'](_0x5c1362[_0x1cda7a[_0xbaf60e][_0x2dff('0x90')]],'%s',_0x30b83f):_0x30b83f;_0x30b83f=_0x1cda7a[_0xbaf60e][_0x2dff('0x78')]?_[_0x2dff('0x77')](_0x4d4dd2[_0x1cda7a[_0xbaf60e][_0x2dff('0x78')]],'%s',_0x30b83f):_0x30b83f;if(_0x1cda7a[_0xbaf60e][_0x2dff('0x79')]){_0x489598[_0x2dff('0x6b')](_0x30b83f);}_0x1cda7a[_0xbaf60e][_0x2dff('0x7a')]&&_0x489598[_0x2dff('0x40')](_0x30b83f,_0x1cda7a[_0xbaf60e][_0x2dff('0x7a')]===_0x2dff('0x7b')?![]:!![]);_0x489598['field'](_0x30b83f,_0x1cda7a[_0xbaf60e][_0x2dff('0x7c')]||_0x30b83f);}if(_0x1964c0[_0x2dff('0x7d')]){_0x1964c0['joins']=JSON[_0x2dff('0x7e')](_0x1964c0[_0x2dff('0x7d')]);for(var _0x54422e=0x0;_0x54422e<_0x1964c0['joins'][_0x2dff('0x3e')];_0x54422e+=0x1){if(_0x1964c0['joins'][_0x54422e]['type']&&_['includes'](_0x367a04,_0x1964c0[_0x2dff('0x7d')][_0x54422e][_0x2dff('0x37')])&&_0x1964c0[_0x2dff('0x7d')][_0x54422e][_0x2dff('0x7f')]&&_0x1964c0[_0x2dff('0x7d')][_0x54422e][_0x2dff('0x80')]&&_0x1964c0[_0x2dff('0x7d')][_0x54422e][_0x2dff('0x81')]){_0x489598[_0x1964c0[_0x2dff('0x7d')][_0x54422e][_0x2dff('0x37')]](_0x1964c0[_0x2dff('0x7d')][_0x54422e][_0x2dff('0x80')],null,util['format'](_0x2dff('0x82'),_0x1964c0[_0x2dff('0x74')],_0x1964c0[_0x2dff('0x7d')][_0x54422e][_0x2dff('0x7f')],_0x1964c0[_0x2dff('0x7d')][_0x54422e][_0x2dff('0x80')],_0x1964c0[_0x2dff('0x7d')][_0x54422e]['foreignKey']));}}}if(_0x1964c0[_0x2dff('0x83')]){_0x1964c0['conditions']=JSON[_0x2dff('0x7e')](_0x1964c0[_0x2dff('0x83')]);_0x489598[_0x2dff('0x42')](_0x3b4a74(_0x1964c0[_0x2dff('0x83')][_0x2dff('0x6b')]));}_0x40650f=_0x489598[_0x2dff('0x84')]();_0x489598['limit'](_0x34591e);_0x489598[_0x2dff('0x1d')](0x0);logger['debug']('Limited\x20Query:',_0x489598[_0x2dff('0x87')]());return dbH[_0x2dff('0xa0')][_0x2dff('0x3b')](_0x489598[_0x2dff('0x87')](),{'type':dbH[_0x2dff('0xa0')][_0x2dff('0xa1')]['SELECT']});}})[_0x2dff('0x25')](function(){return{'sql':_0x40650f[_0x2dff('0x87')]()};})[_0x2dff('0x25')](respondWithResult(_0x5255b1,null))[_0x2dff('0x4b')](handleError(_0x5255b1,null));};
\ No newline at end of file
+var _0x2899=['limit','set','Content-Range','apply','reject','save','update','then','destroy','get','DefaultReports','sendStatus','name','send','render','merge','contact','message','agent','interaction','index','AnalyticDefaultReport','rawAttributes','fieldName','type','key','model','map','keys','filters','intersection','query','attributes','fields','length','nolimit','order','sort','where','filter','VIRTUAL','options','includeAll','findAll','catch','show','params','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','userProfileId','UserProfileResource','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','preview','join','right_join','cross_join','SUM(%s)','COUNT(%s)','MAX(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','value','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','keyBy','select','from','table','MetricId','metric','function','replace','format','groupBy','orderBy','alias','joins','parse','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','MIN(%s)','DATE(%s)','HOUR(%s)','ROUND(%s)','AnalyticMetric','output','fullPath','%s-%s.%s','randomstring','generate','csv','default','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','Run\x20Query:','fork','../../files/reports','savename','countTable','COUNT(*)','run','runReport','left_join','COUNT(DISTINCT\x20%s)','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/license/util','../../mysqldb','dbH','end','status','json','offset','undefined','count'];(function(_0x204d67,_0x48889f){var _0xc988ae=function(_0x4bd8a7){while(--_0x4bd8a7){_0x204d67['push'](_0x204d67['shift']());}};_0xc988ae(++_0x48889f);}(_0x2899,0x135));var _0x9289=function(_0x1ffebd,_0x375666){_0x1ffebd=_0x1ffebd-0x0;var _0xc42f74=_0x2899[_0x1ffebd];return _0xc42f74;};'use strict';var emlformat=require(_0x9289('0x0'));var rimraf=require(_0x9289('0x1'));var zipdir=require(_0x9289('0x2'));var jsonpatch=require(_0x9289('0x3'));var rp=require(_0x9289('0x4'));var moment=require(_0x9289('0x5'));var BPromise=require('bluebird');var Mustache=require(_0x9289('0x6'));var util=require(_0x9289('0x7'));var path=require(_0x9289('0x8'));var sox=require(_0x9289('0x9'));var csv=require(_0x9289('0xa'));var ejs=require(_0x9289('0xb'));var fs=require('fs');var fs_extra=require(_0x9289('0xc'));var _=require(_0x9289('0xd'));var squel=require(_0x9289('0xe'));var crypto=require(_0x9289('0xf'));var jsforce=require('jsforce');var deskjs=require(_0x9289('0x10'));var toCsv=require(_0x9289('0xa'));var querystring=require(_0x9289('0x11'));var Papa=require(_0x9289('0x12'));var Redis=require(_0x9289('0x13'));var authService=require('../../components/auth/service');var qs=require(_0x9289('0x14'));var as=require(_0x9289('0x15'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x9289('0x16'))(_0x9289('0x17'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0x9289('0x18'));var db=require(_0x9289('0x19'))['db'];var dbH=require(_0x9289('0x19'))[_0x9289('0x1a')];function respondWithStatusCode(_0x33992d,_0x64b930){_0x64b930=_0x64b930||0xcc;return function(_0x58f166){if(_0x58f166){return _0x33992d['sendStatus'](_0x64b930);}return _0x33992d['status'](_0x64b930)[_0x9289('0x1b')]();};}function respondWithResult(_0x23b722,_0x45f8b5){_0x45f8b5=_0x45f8b5||0xc8;return function(_0x51a03f){if(_0x51a03f){return _0x23b722[_0x9289('0x1c')](_0x45f8b5)[_0x9289('0x1d')](_0x51a03f);}};}function respondWithFilteredResult(_0x2ceb61,_0x588bbf){return function(_0x54704d){if(_0x54704d){var _0x140398=typeof _0x588bbf[_0x9289('0x1e')]===_0x9289('0x1f')&&typeof _0x588bbf['limit']==='undefined';var _0x19e2a0=_0x54704d[_0x9289('0x20')];var _0x4d7316=_0x140398?0x0:_0x588bbf[_0x9289('0x1e')];var _0x974d6a=_0x140398?_0x54704d[_0x9289('0x20')]:_0x588bbf[_0x9289('0x1e')]+_0x588bbf[_0x9289('0x21')];var _0x3f1bc0;if(_0x974d6a>=_0x19e2a0){_0x974d6a=_0x19e2a0;_0x3f1bc0=0xc8;}else{_0x3f1bc0=0xce;}_0x2ceb61['status'](_0x3f1bc0);return _0x2ceb61[_0x9289('0x22')](_0x9289('0x23'),_0x4d7316+'-'+_0x974d6a+'/'+_0x19e2a0)[_0x9289('0x1d')](_0x54704d);}return null;};}function patchUpdates(_0x51ae74){return function(_0x49f035){try{jsonpatch[_0x9289('0x24')](_0x49f035,_0x51ae74,!![]);}catch(_0x53dbe6){return BPromise[_0x9289('0x25')](_0x53dbe6);}return _0x49f035[_0x9289('0x26')]();};}function saveUpdates(_0x3b4309,_0x40f831){return function(_0x43af54){if(_0x43af54){return _0x43af54[_0x9289('0x27')](_0x3b4309)[_0x9289('0x28')](function(_0xed6c64){return _0xed6c64;});}return null;};}function removeEntity(_0x1442a7,_0x1696d){return function(_0x6789c1){if(_0x6789c1){return _0x6789c1[_0x9289('0x29')]()['then'](function(){var _0x45615d=_0x6789c1[_0x9289('0x2a')]({'plain':!![]});var _0x2b2182=_0x9289('0x2b');return db['UserProfileResource']['destroy']({'where':{'type':_0x2b2182,'resourceId':_0x45615d['id']}})[_0x9289('0x28')](function(){return _0x6789c1;});})[_0x9289('0x28')](function(){_0x1442a7[_0x9289('0x1c')](0xcc)['end']();});}};}function handleEntityNotFound(_0x2f7759,_0x7e0e6f){return function(_0x357aa8){if(!_0x357aa8){_0x2f7759[_0x9289('0x2c')](0x194);}return _0x357aa8;};}function handleError(_0x1d0d5b,_0x46e75e){_0x46e75e=_0x46e75e||0x1f4;return function(_0x2007a5){logger['error'](_0x2007a5['stack']);if(_0x2007a5[_0x9289('0x2d')]){delete _0x2007a5['name'];}_0x1d0d5b[_0x9289('0x1c')](_0x46e75e)[_0x9289('0x2e')](_0x2007a5);};}function getMustacheRender(_0x2d4203,_0x47cf72){return Mustache[_0x9289('0x2f')](_0x2d4203,_[_0x9289('0x30')](_0x47cf72['body'],{'contact':_0x47cf72[_0x9289('0x31')],'message':_0x47cf72[_0x9289('0x32')],'agent':_0x47cf72[_0x9289('0x33')],'interaction':_0x47cf72[_0x9289('0x34')],'account':_0x47cf72['account']}))||'';}exports[_0x9289('0x35')]=function(_0x1d8ef6,_0x5c8d96){var _0x39449b={},_0x13a700={},_0x5b26f3={'count':0x0,'rows':[]};var _0x2c59d6=_['map'](db[_0x9289('0x36')][_0x9289('0x37')],function(_0x559131){return{'name':_0x559131[_0x9289('0x38')],'type':_0x559131[_0x9289('0x39')][_0x9289('0x3a')]};});_0x13a700[_0x9289('0x3b')]=_[_0x9289('0x3c')](_0x2c59d6,'name');_0x13a700['query']=_[_0x9289('0x3d')](_0x1d8ef6['query']);_0x13a700[_0x9289('0x3e')]=_[_0x9289('0x3f')](_0x13a700[_0x9289('0x3b')],_0x13a700[_0x9289('0x40')]);_0x39449b[_0x9289('0x41')]=_[_0x9289('0x3f')](_0x13a700[_0x9289('0x3b')],qs['fields'](_0x1d8ef6[_0x9289('0x40')][_0x9289('0x42')]));_0x39449b[_0x9289('0x41')]=_0x39449b[_0x9289('0x41')][_0x9289('0x43')]?_0x39449b[_0x9289('0x41')]:_0x13a700[_0x9289('0x3b')];if(!_0x1d8ef6[_0x9289('0x40')]['hasOwnProperty'](_0x9289('0x44'))){_0x39449b['limit']=qs[_0x9289('0x21')](_0x1d8ef6[_0x9289('0x40')][_0x9289('0x21')]);_0x39449b[_0x9289('0x1e')]=qs[_0x9289('0x1e')](_0x1d8ef6[_0x9289('0x40')][_0x9289('0x1e')]);}_0x39449b[_0x9289('0x45')]=qs[_0x9289('0x46')](_0x1d8ef6['query'][_0x9289('0x46')]);_0x39449b[_0x9289('0x47')]=qs[_0x9289('0x3e')](_['pick'](_0x1d8ef6[_0x9289('0x40')],_0x13a700[_0x9289('0x3e')]),_0x2c59d6);if(_0x1d8ef6[_0x9289('0x40')][_0x9289('0x48')]){_0x39449b['where']=_[_0x9289('0x30')](_0x39449b[_0x9289('0x47')],{'$or':_[_0x9289('0x3c')](_0x2c59d6,function(_0x395888){if(_0x395888[_0x9289('0x39')]!==_0x9289('0x49')){var _0x26bd16={};_0x26bd16[_0x395888[_0x9289('0x2d')]]={'$like':'%'+_0x1d8ef6[_0x9289('0x40')]['filter']+'%'};return _0x26bd16;}})});}_0x39449b=_['merge']({},_0x39449b,_0x1d8ef6[_0x9289('0x4a')]);var _0x20294f={'where':_0x39449b['where']};return db[_0x9289('0x36')][_0x9289('0x20')](_0x20294f)[_0x9289('0x28')](function(_0x3fddb7){_0x5b26f3['count']=_0x3fddb7;if(_0x1d8ef6[_0x9289('0x40')][_0x9289('0x4b')]){_0x39449b['include']=[{'all':!![]}];}return db[_0x9289('0x36')][_0x9289('0x4c')](_0x39449b);})['then'](function(_0xefac29){_0x5b26f3['rows']=_0xefac29;return _0x5b26f3;})[_0x9289('0x28')](respondWithFilteredResult(_0x5c8d96,_0x39449b))[_0x9289('0x4d')](handleError(_0x5c8d96,null));};exports[_0x9289('0x4e')]=function(_0xe16498,_0x401059){var _0x258321={'raw':!![],'where':{'id':_0xe16498[_0x9289('0x4f')]['id']}},_0x6bf7f={};_0x6bf7f[_0x9289('0x3b')]=_[_0x9289('0x3d')](db[_0x9289('0x36')][_0x9289('0x37')]);_0x6bf7f['query']=_[_0x9289('0x3d')](_0xe16498[_0x9289('0x40')]);_0x6bf7f[_0x9289('0x3e')]=_[_0x9289('0x3f')](_0x6bf7f[_0x9289('0x3b')],_0x6bf7f[_0x9289('0x40')]);_0x258321['attributes']=_[_0x9289('0x3f')](_0x6bf7f[_0x9289('0x3b')],qs[_0x9289('0x42')](_0xe16498[_0x9289('0x40')][_0x9289('0x42')]));_0x258321[_0x9289('0x41')]=_0x258321[_0x9289('0x41')]['length']?_0x258321[_0x9289('0x41')]:_0x6bf7f[_0x9289('0x3b')];if(_0xe16498[_0x9289('0x40')][_0x9289('0x4b')]){_0x258321['include']=[{'all':!![]}];}_0x258321=_[_0x9289('0x30')]({},_0x258321,_0xe16498[_0x9289('0x4a')]);return db[_0x9289('0x36')][_0x9289('0x50')](_0x258321)[_0x9289('0x28')](handleEntityNotFound(_0x401059,null))['then'](respondWithResult(_0x401059,null))[_0x9289('0x4d')](handleError(_0x401059,null));};exports[_0x9289('0x51')]=function(_0x26340d,_0x59b232){return db['AnalyticDefaultReport'][_0x9289('0x51')](_0x26340d['body'],{})[_0x9289('0x28')](function(_0x37f703){var _0x9c776d=_0x26340d[_0x9289('0x52')]['get']({'plain':!![]});if(!_0x9c776d)throw new Error(_0x9289('0x53'));if(_0x9c776d[_0x9289('0x54')]==='user'){var _0x2eb759=_0x37f703[_0x9289('0x2a')]({'plain':!![]});var _0xe53fea=_0x9289('0x55');return db['UserProfileSection'][_0x9289('0x50')]({'where':{'name':_0xe53fea,'userProfileId':_0x9c776d[_0x9289('0x56')]},'raw':!![]})[_0x9289('0x28')](function(_0x4c993d){if(_0x4c993d&&_0x4c993d['autoAssociation']===0x0){return db[_0x9289('0x57')][_0x9289('0x51')]({'name':_0x2eb759[_0x9289('0x2d')],'resourceId':_0x2eb759['id'],'type':_0x9289('0x2b'),'sectionId':_0x4c993d['id']},{})[_0x9289('0x28')](function(){return _0x37f703;});}else{return _0x37f703;}})['catch'](function(_0x5d077b){logger[_0x9289('0x58')](_0x9289('0x59'),_0x5d077b);throw _0x5d077b;});}return _0x37f703;})['then'](respondWithResult(_0x59b232,0xc9))['catch'](handleError(_0x59b232,null));};exports['update']=function(_0x3827d,_0x5c780c){if(_0x3827d[_0x9289('0x5a')]['id']){delete _0x3827d[_0x9289('0x5a')]['id'];}return db[_0x9289('0x36')][_0x9289('0x50')]({'where':{'id':_0x3827d[_0x9289('0x4f')]['id']}})[_0x9289('0x28')](handleEntityNotFound(_0x5c780c,null))['then'](saveUpdates(_0x3827d[_0x9289('0x5a')],null))[_0x9289('0x28')](respondWithResult(_0x5c780c,null))[_0x9289('0x4d')](handleError(_0x5c780c,null));};exports[_0x9289('0x29')]=function(_0xcb0324,_0x3f4ee3){return db['AnalyticDefaultReport'][_0x9289('0x50')]({'where':{'id':_0xcb0324['params']['id']}})[_0x9289('0x28')](handleEntityNotFound(_0x3f4ee3,null))[_0x9289('0x28')](removeEntity(_0x3f4ee3,null))[_0x9289('0x4d')](handleError(_0x3f4ee3,null));};exports[_0x9289('0x5b')]=function(_0x5d81e2,_0x4ccb5a){var _0xc83088=0xa;var _0x1d287a=[_0x9289('0x5c'),'left_join',_0x9289('0x5d'),_0x9289('0x5e')];var _0x594a48={'SUM':_0x9289('0x5f'),'COUNT':_0x9289('0x60'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x9289('0x61'),'MIN':'MIN(%s)','AVG':_0x9289('0x62'),'GROUP_CONCAT':_0x9289('0x63'),'GROUP_CONCAT ASC':_0x9289('0x64'),'GROUP_CONCAT DESC':_0x9289('0x65')};var _0x34284d={'SEC_TO_TIME':_0x9289('0x66'),'DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x9289('0x67')};var _0x228144=function(_0x548d01){return!_[_0x9289('0x68')]([_0x9289('0x69'),_0x9289('0x6a'),_0x9289('0x6b'),_0x9289('0x6c')],_0x548d01);};var _0xf2037d=function(_0x43833e){if(!_0x43833e||!_0x43833e[_0x9289('0x6d')][_0x9289('0x43')]){return'';}for(var _0x49ebdd='(',_0x46ba2a=0x0;_0x46ba2a<_0x43833e['rules']['length'];_0x46ba2a+=0x1){_0x46ba2a>0x0&&(_0x49ebdd+='\x20'+_0x43833e[_0x9289('0x6e')]+'\x20');_0x49ebdd+=_0x43833e[_0x9289('0x6d')][_0x46ba2a][_0x9289('0x6f')]?_0xf2037d(_0x43833e['rules'][_0x46ba2a][_0x9289('0x6f')]):_0x43833e[_0x9289('0x6d')][_0x46ba2a][_0x9289('0x70')]+'\x20'+_0x43833e['rules'][_0x46ba2a][_0x9289('0x71')]+(_0x228144(_0x43833e[_0x9289('0x6d')][_0x46ba2a]['condition'])?'\x20'+_0x43833e[_0x9289('0x6d')][_0x46ba2a][_0x9289('0x72')]:'');}return _0x49ebdd+')';};var _0x411ea7={'where':{'id':_0x5d81e2['params']['id']}},_0x32aa9d,_0x13ae36,_0x192049,_0x1d17fe,_0x5de4c8;_0x411ea7=_['merge']({},_0x411ea7,_0x5d81e2[_0x9289('0x4a')]);return db[_0x9289('0x36')][_0x9289('0x50')](_0x411ea7)[_0x9289('0x28')](function(_0x314ffd){if(_0x314ffd){_0x32aa9d=_0x314ffd;return _0x314ffd[_0x9289('0x73')]();}return null;})[_0x9289('0x28')](function(_0x3d0937){if(_0x3d0937){if(!_0x3d0937[_0x9289('0x43')]){throw new db[(_0x9289('0x74'))][(_0x9289('0x75'))](_0x9289('0x76'),0x193);}_0x13ae36=_0x3d0937;return db['AnalyticMetric'][_0x9289('0x4c')]({'raw':!![]});}return null;})[_0x9289('0x28')](function(_0x475033){if(_0x475033){_0x192049=_[_0x9289('0x77')](_0x475033,'id');var _0x2c69fc;var _0x380412=squel[_0x9289('0x78')]();_0x380412[_0x9289('0x79')](_0x32aa9d[_0x9289('0x7a')]);for(var _0x120493=0x0;_0x120493<_0x13ae36['length'];_0x120493+=0x1){_0x2c69fc=_0x13ae36[_0x120493][_0x9289('0x7b')]?_0x192049[_0x13ae36[_0x120493][_0x9289('0x7b')]][_0x9289('0x7c')]:_0x13ae36[_0x120493][_0x9289('0x70')];_0x2c69fc=_0x13ae36[_0x120493][_0x9289('0x7d')]?_[_0x9289('0x7e')](_0x594a48[_0x13ae36[_0x120493][_0x9289('0x7d')]],'%s',_0x2c69fc):_0x2c69fc;_0x2c69fc=_0x13ae36[_0x120493]['format']?_[_0x9289('0x7e')](_0x34284d[_0x13ae36[_0x120493][_0x9289('0x7f')]],'%s',_0x2c69fc):_0x2c69fc;if(_0x13ae36[_0x120493][_0x9289('0x80')]){_0x380412[_0x9289('0x6f')](_0x2c69fc);}_0x13ae36[_0x120493][_0x9289('0x81')]&&_0x380412[_0x9289('0x45')](_0x2c69fc,_0x13ae36[_0x120493]['orderBy']==='DESC'?![]:!![]);_0x380412['field'](_0x2c69fc,_0x13ae36[_0x120493][_0x9289('0x82')]||_0x2c69fc);}if(_0x32aa9d[_0x9289('0x83')]){_0x32aa9d[_0x9289('0x83')]=JSON[_0x9289('0x84')](_0x32aa9d[_0x9289('0x83')]);for(var _0x3adf3e=0x0;_0x3adf3e<_0x32aa9d[_0x9289('0x83')][_0x9289('0x43')];_0x3adf3e+=0x1){if(_0x32aa9d[_0x9289('0x83')][_0x3adf3e][_0x9289('0x39')]&&_[_0x9289('0x68')](_0x1d287a,_0x32aa9d['joins'][_0x3adf3e][_0x9289('0x39')])&&_0x32aa9d[_0x9289('0x83')][_0x3adf3e][_0x9289('0x85')]&&_0x32aa9d[_0x9289('0x83')][_0x3adf3e][_0x9289('0x86')]&&_0x32aa9d[_0x9289('0x83')][_0x3adf3e][_0x9289('0x87')]){_0x380412[_0x32aa9d[_0x9289('0x83')][_0x3adf3e][_0x9289('0x39')]](_0x32aa9d['joins'][_0x3adf3e][_0x9289('0x86')],null,util[_0x9289('0x7f')](_0x9289('0x88'),_0x32aa9d[_0x9289('0x7a')],_0x32aa9d[_0x9289('0x83')][_0x3adf3e]['parentKey'],_0x32aa9d[_0x9289('0x83')][_0x3adf3e][_0x9289('0x86')],_0x32aa9d[_0x9289('0x83')][_0x3adf3e]['foreignKey']));}}}if(_0x32aa9d[_0x9289('0x89')]){_0x32aa9d[_0x9289('0x89')]=JSON['parse'](_0x32aa9d[_0x9289('0x89')]);_0x380412[_0x9289('0x47')](_0xf2037d(_0x32aa9d[_0x9289('0x89')][_0x9289('0x6f')]));}_0x5de4c8=_0x380412[_0x9289('0x8a')]();_0x380412[_0x9289('0x21')](_0xc83088);_0x380412[_0x9289('0x1e')](0x0);logger[_0x9289('0x8b')](_0x9289('0x8c'),_0x380412[_0x9289('0x8d')]());return dbH['sequelize'][_0x9289('0x40')](_0x380412[_0x9289('0x8d')](),{'type':dbH[_0x9289('0x8e')][_0x9289('0x8f')][_0x9289('0x90')]});}})[_0x9289('0x28')](respondWithResult(_0x4ccb5a,null))[_0x9289('0x4d')](handleError(_0x4ccb5a,null));};function runReport(_0x4a3368,_0x48c309,_0x315a4b){var _0x5aacf0=_0x48c309[_0x9289('0x2d')];var _0x4cc41a=0xa;var _0x185e02=[_0x9289('0x5c'),'left_join',_0x9289('0x5d'),_0x9289('0x5e')];var _0x124f0e={'SUM':_0x9289('0x5f'),'COUNT':_0x9289('0x60'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x9289('0x61'),'MIN':_0x9289('0x91'),'AVG':'AVG(%s)','GROUP_CONCAT':_0x9289('0x63'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0x9289('0x65')};var _0x112465={'SEC_TO_TIME':_0x9289('0x66'),'DATE':_0x9289('0x92'),'HOUR':_0x9289('0x93'),'ROUND':_0x9289('0x94'),'UNIX_TIMESTAMP':_0x9289('0x67')};var _0x38a04a=function(_0x47fc34){return!_[_0x9289('0x68')]([_0x9289('0x69'),_0x9289('0x6a'),_0x9289('0x6b'),'IS\x20NOT\x20EMPTY'],_0x47fc34);};var _0x2af95d=function(_0x198fbe){if(!_0x198fbe||!_0x198fbe[_0x9289('0x6d')][_0x9289('0x43')]){return'';}for(var _0x5cef9d='(',_0x32ad7e=0x0;_0x32ad7e<_0x198fbe['rules'][_0x9289('0x43')];_0x32ad7e+=0x1){_0x32ad7e>0x0&&(_0x5cef9d+='\x20'+_0x198fbe['operator']+'\x20');_0x5cef9d+=_0x198fbe[_0x9289('0x6d')][_0x32ad7e]['group']?_0x2af95d(_0x198fbe[_0x9289('0x6d')][_0x32ad7e]['group']):_0x198fbe['rules'][_0x32ad7e][_0x9289('0x70')]+'\x20'+_0x198fbe[_0x9289('0x6d')][_0x32ad7e]['condition']+(_0x38a04a(_0x198fbe[_0x9289('0x6d')][_0x32ad7e][_0x9289('0x71')])?'\x20'+_0x198fbe['rules'][_0x32ad7e][_0x9289('0x72')]:'');}return _0x5cef9d+')';};var _0x4c302={'where':{'id':_0x4a3368['id']}},_0x5d6510,_0x488144,_0x17ccd7,_0x28792a,_0x28daef;_0x4c302=_[_0x9289('0x30')]({},_0x4c302,_0x315a4b);return db[_0x9289('0x36')][_0x9289('0x50')](_0x4c302)[_0x9289('0x28')](function(_0x43da5f){if(_0x43da5f){_0x5d6510=_0x43da5f;return _0x43da5f[_0x9289('0x73')]();}return null;})['then'](function(_0x472886){if(_0x472886){if(!_0x472886[_0x9289('0x43')]){throw new db['Sequelize'][(_0x9289('0x75'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x488144=_0x472886;return db[_0x9289('0x95')]['findAll']({'raw':!![]});}return null;})[_0x9289('0x28')](function(_0x44ea3a){if(_0x44ea3a){_0x17ccd7=_[_0x9289('0x77')](_0x44ea3a,'id');var _0x27e3f6;var _0x42c204=squel[_0x9289('0x78')]();_0x42c204['from'](_0x5d6510[_0x9289('0x7a')]);for(var _0x28d946=0x0;_0x28d946<_0x488144['length'];_0x28d946+=0x1){_0x27e3f6=_0x488144[_0x28d946][_0x9289('0x7b')]?_0x17ccd7[_0x488144[_0x28d946][_0x9289('0x7b')]][_0x9289('0x7c')]:_0x488144[_0x28d946][_0x9289('0x70')];_0x27e3f6=_0x488144[_0x28d946][_0x9289('0x7d')]?_[_0x9289('0x7e')](_0x124f0e[_0x488144[_0x28d946][_0x9289('0x7d')]],'%s',_0x27e3f6):_0x27e3f6;_0x27e3f6=_0x488144[_0x28d946][_0x9289('0x7f')]?_['replace'](_0x112465[_0x488144[_0x28d946][_0x9289('0x7f')]],'%s',_0x27e3f6):_0x27e3f6;if(_0x488144[_0x28d946][_0x9289('0x80')]){_0x42c204[_0x9289('0x6f')](_0x27e3f6);}_0x488144[_0x28d946][_0x9289('0x81')]&&_0x42c204[_0x9289('0x45')](_0x27e3f6,_0x488144[_0x28d946][_0x9289('0x81')]==='DESC'?![]:!![]);_0x42c204[_0x9289('0x70')](_0x27e3f6,_0x488144[_0x28d946][_0x9289('0x82')]||_0x27e3f6);}if(_0x5d6510[_0x9289('0x83')]){_0x5d6510[_0x9289('0x83')]=JSON[_0x9289('0x84')](_0x5d6510['joins']);for(var _0x2bb97a=0x0;_0x2bb97a<_0x5d6510['joins'][_0x9289('0x43')];_0x2bb97a+=0x1){if(_0x5d6510[_0x9289('0x83')][_0x2bb97a][_0x9289('0x39')]&&_[_0x9289('0x68')](_0x185e02,_0x5d6510['joins'][_0x2bb97a][_0x9289('0x39')])&&_0x5d6510[_0x9289('0x83')][_0x2bb97a][_0x9289('0x85')]&&_0x5d6510[_0x9289('0x83')][_0x2bb97a][_0x9289('0x86')]&&_0x5d6510['joins'][_0x2bb97a][_0x9289('0x87')]){_0x42c204[_0x5d6510['joins'][_0x2bb97a][_0x9289('0x39')]](_0x5d6510[_0x9289('0x83')][_0x2bb97a]['foreignTable'],null,util['format']('%s.%s\x20=\x20%s.%s',_0x5d6510[_0x9289('0x7a')],_0x5d6510[_0x9289('0x83')][_0x2bb97a][_0x9289('0x85')],_0x5d6510[_0x9289('0x83')][_0x2bb97a]['foreignTable'],_0x5d6510[_0x9289('0x83')][_0x2bb97a][_0x9289('0x87')]));}}}if(_0x5d6510[_0x9289('0x89')]){_0x5d6510[_0x9289('0x89')]=JSON[_0x9289('0x84')](_0x5d6510['conditions']);_0x42c204[_0x9289('0x47')](_0x2af95d(_0x5d6510[_0x9289('0x89')][_0x9289('0x6f')]));}_0x28daef=_0x42c204[_0x9289('0x8a')]();_0x42c204[_0x9289('0x21')](_0x4cc41a);_0x42c204[_0x9289('0x1e')](0x0);return;}})['then'](function(){if(_0x48c309[_0x9289('0x96')]==='web'){return null;}var _0x3d6797=_['merge'](_0x48c309,{'name':_0x48c309[_0x9289('0x97')]||_0x48c309[_0x9289('0x2d')]||_0x5d6510[_0x9289('0x2d')],'basename':_0x5aacf0,'savename':util[_0x9289('0x7f')](_0x9289('0x98'),_0x48c309['name']||_0x5d6510[_0x9289('0x2d')],require(_0x9289('0x99'))[_0x9289('0x9a')](0x4),_0x48c309[_0x9289('0x96')]||_0x9289('0x9b')),'reportId':_0x5d6510['id'],'reportType':_0x9289('0x9c')});return db['AnalyticExtractedReport']['create'](_0x3d6797,{'raw':!![]});})[_0x9289('0x28')](function(_0x15c8f9){if(_0x5d6510[_0x9289('0x7a')]==='cdr'){_0x28daef[_0x9289('0x47')](_0x5d6510[_0x9289('0x7a')]+_0x9289('0x9d'),_0x48c309[_0x9289('0x9e')],_0x48c309[_0x9289('0x9f')]);}else{_0x28daef['where'](_0x5d6510[_0x9289('0x7a')]+_0x9289('0xa0'),_0x48c309[_0x9289('0x9e')],_0x48c309[_0x9289('0x9f')]);}if(_0x15c8f9){logger['info'](_0x9289('0xa1'),_0x28daef['toString']());require('child_process')[_0x9289('0xa2')](path['join'](__dirname,'../../components/export/',_0x15c8f9['output']),[_0x15c8f9['id'],_0x28daef['toString'](),path[_0x9289('0x5c')](__dirname,_0x9289('0xa3'),_0x15c8f9[_0x9289('0xa4')]),_0x5aacf0]);return _0x15c8f9;}else{var _0x70e977=squel[_0x9289('0x78')]();_0x70e977[_0x9289('0x79')]('('+_0x28daef['toString']()+')',_0x9289('0xa5'));_0x70e977[_0x9289('0x70')](_0x9289('0xa6'),_0x9289('0x20'));_0x28daef[_0x9289('0x21')](_0x48c309[_0x9289('0x21')]||_0x4cc41a);_0x28daef['offset'](_0x48c309['offset']||0x0);return dbH[_0x9289('0x8e')][_0x9289('0x40')](_0x70e977['toString'](),{'type':dbH[_0x9289('0x8e')][_0x9289('0x8f')]['SELECT']})['then'](function(_0x27b248){if(!_0x27b248[_0x9289('0x43')]){_0x28792a=0x0;}else{_0x28792a=_0x27b248[0x0]['count']||0x0;}return dbH[_0x9289('0x8e')]['query'](_0x28daef[_0x9289('0x8d')](),{'type':dbH[_0x9289('0x8e')]['QueryTypes'][_0x9289('0x90')]});})[_0x9289('0x28')](function(_0x306be4){return{'rows':_0x306be4||[],'count':_0x28792a};});}});}exports[_0x9289('0xa7')]=function(_0xb66f77,_0x33074f){return runReport(_0xb66f77[_0x9289('0x4f')],_0xb66f77[_0x9289('0x40')],_0xb66f77[_0x9289('0x4a')])[_0x9289('0x28')](respondWithResult(_0x33074f,null))[_0x9289('0x4d')](handleError(_0x33074f,null));};exports[_0x9289('0xa8')]=runReport;exports[_0x9289('0x40')]=function(_0xf407a8,_0x279a79){var _0x370f03=0xa;var _0x11f0b8=[_0x9289('0x5c'),_0x9289('0xa9'),_0x9289('0x5d'),_0x9289('0x5e')];var _0x3b7666={'SUM':_0x9289('0x5f'),'COUNT':_0x9289('0x60'),'COUNT DISTINCT':_0x9289('0xaa'),'MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':_0x9289('0x62'),'GROUP_CONCAT':_0x9289('0x63'),'GROUP_CONCAT ASC':_0x9289('0x64'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x2e114b={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x9289('0x92'),'HOUR':_0x9289('0x93'),'ROUND':_0x9289('0x94'),'UNIX_TIMESTAMP':_0x9289('0x67')};var _0x11fa0a=function(_0xbe4127){return!_['includes']([_0x9289('0x69'),_0x9289('0x6a'),_0x9289('0x6b'),'IS\x20NOT\x20EMPTY'],_0xbe4127);};var _0x44769c=function(_0x264824){if(!_0x264824||!_0x264824[_0x9289('0x6d')][_0x9289('0x43')]){return'';}for(var _0xb225d8='(',_0x8b19a6=0x0;_0x8b19a6<_0x264824[_0x9289('0x6d')]['length'];_0x8b19a6+=0x1){_0x8b19a6>0x0&&(_0xb225d8+='\x20'+_0x264824[_0x9289('0x6e')]+'\x20');_0xb225d8+=_0x264824[_0x9289('0x6d')][_0x8b19a6][_0x9289('0x6f')]?_0x44769c(_0x264824[_0x9289('0x6d')][_0x8b19a6][_0x9289('0x6f')]):_0x264824['rules'][_0x8b19a6][_0x9289('0x70')]+'\x20'+_0x264824[_0x9289('0x6d')][_0x8b19a6]['condition']+(_0x11fa0a(_0x264824[_0x9289('0x6d')][_0x8b19a6][_0x9289('0x71')])?'\x20'+_0x264824[_0x9289('0x6d')][_0x8b19a6][_0x9289('0x72')]:'');}return _0xb225d8+')';};var _0x9cbc70={'where':{'id':_0xf407a8[_0x9289('0x4f')]['id']}},_0x5cab38,_0x4e3df1,_0x28997c,_0x8da862,_0x19c13d;_0x9cbc70=_['merge']({},_0x9cbc70,_0xf407a8['options']);return db['AnalyticDefaultReport']['find'](_0x9cbc70)[_0x9289('0x28')](function(_0x5200f3){if(_0x5200f3){_0x5cab38=_0x5200f3;return _0x5200f3[_0x9289('0x73')]();}return null;})[_0x9289('0x28')](function(_0x440d1a){if(_0x440d1a){if(!_0x440d1a[_0x9289('0x43')]){throw new db[(_0x9289('0x74'))][(_0x9289('0x75'))](_0x9289('0x76'),0x193);}_0x4e3df1=_0x440d1a;return db['AnalyticMetric']['findAll']({'raw':!![]});}return null;})[_0x9289('0x28')](function(_0x18a6c6){if(_0x18a6c6){_0x28997c=_[_0x9289('0x77')](_0x18a6c6,'id');var _0x4357ad;var _0x21ea44=squel['select']();_0x21ea44[_0x9289('0x79')](_0x5cab38[_0x9289('0x7a')]);for(var _0x173cdf=0x0;_0x173cdf<_0x4e3df1['length'];_0x173cdf+=0x1){_0x4357ad=_0x4e3df1[_0x173cdf]['MetricId']?_0x28997c[_0x4e3df1[_0x173cdf][_0x9289('0x7b')]][_0x9289('0x7c')]:_0x4e3df1[_0x173cdf][_0x9289('0x70')];_0x4357ad=_0x4e3df1[_0x173cdf][_0x9289('0x7d')]?_['replace'](_0x3b7666[_0x4e3df1[_0x173cdf][_0x9289('0x7d')]],'%s',_0x4357ad):_0x4357ad;_0x4357ad=_0x4e3df1[_0x173cdf][_0x9289('0x7f')]?_['replace'](_0x2e114b[_0x4e3df1[_0x173cdf][_0x9289('0x7f')]],'%s',_0x4357ad):_0x4357ad;if(_0x4e3df1[_0x173cdf][_0x9289('0x80')]){_0x21ea44[_0x9289('0x6f')](_0x4357ad);}_0x4e3df1[_0x173cdf][_0x9289('0x81')]&&_0x21ea44['order'](_0x4357ad,_0x4e3df1[_0x173cdf][_0x9289('0x81')]==='DESC'?![]:!![]);_0x21ea44[_0x9289('0x70')](_0x4357ad,_0x4e3df1[_0x173cdf][_0x9289('0x82')]||_0x4357ad);}if(_0x5cab38[_0x9289('0x83')]){_0x5cab38[_0x9289('0x83')]=JSON['parse'](_0x5cab38[_0x9289('0x83')]);for(var _0xb0db71=0x0;_0xb0db71<_0x5cab38[_0x9289('0x83')][_0x9289('0x43')];_0xb0db71+=0x1){if(_0x5cab38['joins'][_0xb0db71][_0x9289('0x39')]&&_[_0x9289('0x68')](_0x11f0b8,_0x5cab38[_0x9289('0x83')][_0xb0db71]['type'])&&_0x5cab38[_0x9289('0x83')][_0xb0db71][_0x9289('0x85')]&&_0x5cab38[_0x9289('0x83')][_0xb0db71][_0x9289('0x86')]&&_0x5cab38[_0x9289('0x83')][_0xb0db71][_0x9289('0x87')]){_0x21ea44[_0x5cab38[_0x9289('0x83')][_0xb0db71]['type']](_0x5cab38[_0x9289('0x83')][_0xb0db71][_0x9289('0x86')],null,util[_0x9289('0x7f')](_0x9289('0x88'),_0x5cab38[_0x9289('0x7a')],_0x5cab38[_0x9289('0x83')][_0xb0db71][_0x9289('0x85')],_0x5cab38['joins'][_0xb0db71][_0x9289('0x86')],_0x5cab38[_0x9289('0x83')][_0xb0db71][_0x9289('0x87')]));}}}if(_0x5cab38['conditions']){_0x5cab38['conditions']=JSON['parse'](_0x5cab38[_0x9289('0x89')]);_0x21ea44[_0x9289('0x47')](_0x44769c(_0x5cab38[_0x9289('0x89')][_0x9289('0x6f')]));}_0x19c13d=_0x21ea44[_0x9289('0x8a')]();_0x21ea44['limit'](_0x370f03);_0x21ea44[_0x9289('0x1e')](0x0);logger[_0x9289('0x8b')](_0x9289('0x8c'),_0x21ea44[_0x9289('0x8d')]());return dbH[_0x9289('0x8e')][_0x9289('0x40')](_0x21ea44[_0x9289('0x8d')](),{'type':dbH[_0x9289('0x8e')][_0x9289('0x8f')][_0x9289('0x90')]});}})[_0x9289('0x28')](function(){return{'sql':_0x19c13d['toString']()};})[_0x9289('0x28')](respondWithResult(_0x279a79,null))[_0x9289('0x4d')](handleError(_0x279a79,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff