18 var _0xa65a=['MetricId','metric','function','replace','format','groupBy','orderBy','joins','parentKey','foreignKey','foreignTable','conditions','parse','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','IS\x20NOT\x20NULL','findAll','select','DESC','alias','%s.%s\x20=\x20%s.%s','output','web','fullPath','%s-%s.%s','randomstring','generate','csv','custom','AnalyticExtractedReport','cdr','startDate','endDate','info','../../components/export/','../../files/reports','savename','countTable','COUNT(*)','run','runReport','right_join','cross_join','AVG(%s)','operator','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','sox','to-csv','ejs','fs-extra','lodash','crypto','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','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','save','then','get','CustomReports','UserProfileResource','destroy','error','stack','name','send','map','AnalyticCustomReport','rawAttributes','fieldName','key','model','query','keys','filters','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','pick','filter','merge','where','type','VIRTUAL','options','includeAll','include','catch','show','params','length','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','body','preview','join','left_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','DATE(%s)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','group','field','condition','value','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','from','table'];(function(_0x5c3643,_0x1a68cc){var _0x5ec5db=function(_0x1af501){while(--_0x1af501){_0x5c3643['push'](_0x5c3643['shift']());}};_0x5ec5db(++_0x1a68cc);}(_0xa65a,0xe3));var _0xaa65=function(_0xbf781d,_0x61733c){_0xbf781d=_0xbf781d-0x0;var _0x56b026=_0xa65a[_0xbf781d];return _0x56b026;};'use strict';var emlformat=require(_0xaa65('0x0'));var rimraf=require(_0xaa65('0x1'));var zipdir=require(_0xaa65('0x2'));var jsonpatch=require(_0xaa65('0x3'));var rp=require(_0xaa65('0x4'));var moment=require(_0xaa65('0x5'));var BPromise=require(_0xaa65('0x6'));var Mustache=require('mustache');var util=require(_0xaa65('0x7'));var path=require(_0xaa65('0x8'));var sox=require(_0xaa65('0x9'));var csv=require(_0xaa65('0xa'));var ejs=require(_0xaa65('0xb'));var fs=require('fs');var fs_extra=require(_0xaa65('0xc'));var _=require(_0xaa65('0xd'));var squel=require('squel');var crypto=require(_0xaa65('0xe'));var jsforce=require(_0xaa65('0xf'));var deskjs=require(_0xaa65('0x10'));var toCsv=require(_0xaa65('0xa'));var querystring=require(_0xaa65('0x11'));var Papa=require(_0xaa65('0x12'));var Redis=require(_0xaa65('0x13'));var authService=require(_0xaa65('0x14'));var qs=require(_0xaa65('0x15'));var as=require(_0xaa65('0x16'));var hardwareService=require(_0xaa65('0x17'));var logger=require(_0xaa65('0x18'))(_0xaa65('0x19'));var utils=require(_0xaa65('0x1a'));var config=require(_0xaa65('0x1b'));var licenseUtil=require(_0xaa65('0x1c'));var db=require(_0xaa65('0x1d'))['db'];var dbH=require(_0xaa65('0x1d'))[_0xaa65('0x1e')];function respondWithStatusCode(_0x32d896,_0x109822){_0x109822=_0x109822||0xcc;return function(_0x54249a){if(_0x54249a){return _0x32d896[_0xaa65('0x1f')](_0x109822);}return _0x32d896[_0xaa65('0x20')](_0x109822)[_0xaa65('0x21')]();};}function respondWithResult(_0x5bc284,_0x13cd6d){_0x13cd6d=_0x13cd6d||0xc8;return function(_0x20a460){if(_0x20a460){return _0x5bc284[_0xaa65('0x20')](_0x13cd6d)[_0xaa65('0x22')](_0x20a460);}};}function respondWithFilteredResult(_0x17fc5a,_0x5425bc){return function(_0x2ed863){if(_0x2ed863){var _0x24b74a=typeof _0x5425bc[_0xaa65('0x23')]===_0xaa65('0x24')&&typeof _0x5425bc[_0xaa65('0x25')]===_0xaa65('0x24');var _0x40ae2a=_0x2ed863[_0xaa65('0x26')];var _0x1d61cb=_0x24b74a?0x0:_0x5425bc[_0xaa65('0x23')];var _0x23c298=_0x24b74a?_0x2ed863[_0xaa65('0x26')]:_0x5425bc['offset']+_0x5425bc[_0xaa65('0x25')];var _0x1b6d20;if(_0x23c298>=_0x40ae2a){_0x23c298=_0x40ae2a;_0x1b6d20=0xc8;}else{_0x1b6d20=0xce;}_0x17fc5a[_0xaa65('0x20')](_0x1b6d20);return _0x17fc5a[_0xaa65('0x27')](_0xaa65('0x28'),_0x1d61cb+'-'+_0x23c298+'/'+_0x40ae2a)[_0xaa65('0x22')](_0x2ed863);}return null;};}function patchUpdates(_0x5d63e8){return function(_0x18c02c){try{jsonpatch[_0xaa65('0x29')](_0x18c02c,_0x5d63e8,!![]);}catch(_0x1bdec8){return BPromise['reject'](_0x1bdec8);}return _0x18c02c[_0xaa65('0x2a')]();};}function saveUpdates(_0x47ddb2,_0x203023){return function(_0x19c4d2){if(_0x19c4d2){return _0x19c4d2['update'](_0x47ddb2)[_0xaa65('0x2b')](function(_0x15eb3e){return _0x15eb3e;});}return null;};}function removeEntity(_0x3640a0,_0x42502b){return function(_0x1c064e){if(_0x1c064e){return _0x1c064e['destroy']()[_0xaa65('0x2b')](function(){var _0x314f21=_0x1c064e[_0xaa65('0x2c')]({'plain':!![]});var _0x54ce6c=_0xaa65('0x2d');return db[_0xaa65('0x2e')][_0xaa65('0x2f')]({'where':{'type':_0x54ce6c,'resourceId':_0x314f21['id']}})[_0xaa65('0x2b')](function(){return _0x1c064e;});})[_0xaa65('0x2b')](function(){_0x3640a0[_0xaa65('0x20')](0xcc)[_0xaa65('0x21')]();});}};}function handleEntityNotFound(_0x5f306b,_0x591a00){return function(_0x53d8f4){if(!_0x53d8f4){_0x5f306b[_0xaa65('0x1f')](0x194);}return _0x53d8f4;};}function handleError(_0x455bc6,_0x89bb9a){_0x89bb9a=_0x89bb9a||0x1f4;return function(_0x21a72b){logger[_0xaa65('0x30')](_0x21a72b[_0xaa65('0x31')]);if(_0x21a72b[_0xaa65('0x32')]){delete _0x21a72b['name'];}_0x455bc6[_0xaa65('0x20')](_0x89bb9a)[_0xaa65('0x33')](_0x21a72b);};}exports['index']=function(_0x2de546,_0x2ce9d2){var _0x5eab1c={},_0x4b59bb={},_0x3d1fe9={'count':0x0,'rows':[]};var _0x5d1a7f=_[_0xaa65('0x34')](db[_0xaa65('0x35')][_0xaa65('0x36')],function(_0xcb6223){return{'name':_0xcb6223[_0xaa65('0x37')],'type':_0xcb6223['type'][_0xaa65('0x38')]};});_0x4b59bb[_0xaa65('0x39')]=_[_0xaa65('0x34')](_0x5d1a7f,_0xaa65('0x32'));_0x4b59bb[_0xaa65('0x3a')]=_[_0xaa65('0x3b')](_0x2de546[_0xaa65('0x3a')]);_0x4b59bb[_0xaa65('0x3c')]=_[_0xaa65('0x3d')](_0x4b59bb['model'],_0x4b59bb['query']);_0x5eab1c[_0xaa65('0x3e')]=_[_0xaa65('0x3d')](_0x4b59bb[_0xaa65('0x39')],qs[_0xaa65('0x3f')](_0x2de546[_0xaa65('0x3a')][_0xaa65('0x3f')]));_0x5eab1c['attributes']=_0x5eab1c['attributes']['length']?_0x5eab1c[_0xaa65('0x3e')]:_0x4b59bb[_0xaa65('0x39')];if(!_0x2de546[_0xaa65('0x3a')][_0xaa65('0x40')](_0xaa65('0x41'))){_0x5eab1c['limit']=qs['limit'](_0x2de546[_0xaa65('0x3a')][_0xaa65('0x25')]);_0x5eab1c[_0xaa65('0x23')]=qs['offset'](_0x2de546[_0xaa65('0x3a')][_0xaa65('0x23')]);}_0x5eab1c[_0xaa65('0x42')]=qs['sort'](_0x2de546[_0xaa65('0x3a')][_0xaa65('0x43')]);_0x5eab1c['where']=qs[_0xaa65('0x3c')](_[_0xaa65('0x44')](_0x2de546[_0xaa65('0x3a')],_0x4b59bb[_0xaa65('0x3c')]),_0x5d1a7f);if(_0x2de546[_0xaa65('0x3a')][_0xaa65('0x45')]){_0x5eab1c['where']=_[_0xaa65('0x46')](_0x5eab1c[_0xaa65('0x47')],{'$or':_[_0xaa65('0x34')](_0x5d1a7f,function(_0x4f1579){if(_0x4f1579[_0xaa65('0x48')]!==_0xaa65('0x49')){var _0x1c325d={};_0x1c325d[_0x4f1579[_0xaa65('0x32')]]={'$like':'%'+_0x2de546[_0xaa65('0x3a')]['filter']+'%'};return _0x1c325d;}})});}_0x5eab1c=_[_0xaa65('0x46')]({},_0x5eab1c,_0x2de546[_0xaa65('0x4a')]);var _0x4c8a9c={'where':_0x5eab1c[_0xaa65('0x47')]};return db[_0xaa65('0x35')]['count'](_0x4c8a9c)[_0xaa65('0x2b')](function(_0x416f50){_0x3d1fe9[_0xaa65('0x26')]=_0x416f50;if(_0x2de546[_0xaa65('0x3a')][_0xaa65('0x4b')]){_0x5eab1c[_0xaa65('0x4c')]=[{'all':!![]}];}return db[_0xaa65('0x35')]['findAll'](_0x5eab1c);})['then'](function(_0x216842){_0x3d1fe9['rows']=_0x216842;return _0x3d1fe9;})[_0xaa65('0x2b')](respondWithFilteredResult(_0x2ce9d2,_0x5eab1c))[_0xaa65('0x4d')](handleError(_0x2ce9d2,null));};exports[_0xaa65('0x4e')]=function(_0x5e3ff4,_0x5b8b77){var _0x4c5ece={'raw':![],'where':{'id':_0x5e3ff4[_0xaa65('0x4f')]['id']}},_0x16a74d={};_0x16a74d[_0xaa65('0x39')]=_[_0xaa65('0x3b')](db['AnalyticCustomReport'][_0xaa65('0x36')]);_0x16a74d[_0xaa65('0x3a')]=_[_0xaa65('0x3b')](_0x5e3ff4['query']);_0x16a74d['filters']=_[_0xaa65('0x3d')](_0x16a74d[_0xaa65('0x39')],_0x16a74d[_0xaa65('0x3a')]);_0x4c5ece[_0xaa65('0x3e')]=_[_0xaa65('0x3d')](_0x16a74d[_0xaa65('0x39')],qs[_0xaa65('0x3f')](_0x5e3ff4[_0xaa65('0x3a')][_0xaa65('0x3f')]));_0x4c5ece['attributes']=_0x4c5ece['attributes'][_0xaa65('0x50')]?_0x4c5ece[_0xaa65('0x3e')]:_0x16a74d[_0xaa65('0x39')];if(_0x5e3ff4[_0xaa65('0x3a')][_0xaa65('0x4b')]){_0x4c5ece['include']=[{'all':!![]}];}_0x4c5ece=_[_0xaa65('0x46')]({},_0x4c5ece,_0x5e3ff4[_0xaa65('0x4a')]);return db[_0xaa65('0x35')][_0xaa65('0x51')](_0x4c5ece)[_0xaa65('0x2b')](handleEntityNotFound(_0x5b8b77,null))[_0xaa65('0x2b')](respondWithResult(_0x5b8b77,null))[_0xaa65('0x4d')](handleError(_0x5b8b77,null));};exports[_0xaa65('0x52')]=function(_0x23c90c,_0x2d8851){return db[_0xaa65('0x35')][_0xaa65('0x52')](_0x23c90c['body'],{})['then'](function(_0x3a5f51){var _0x408e8a=_0x23c90c[_0xaa65('0x53')][_0xaa65('0x2c')]({'plain':!![]});if(!_0x408e8a)throw new Error(_0xaa65('0x54'));if(_0x408e8a[_0xaa65('0x55')]===_0xaa65('0x53')){var _0x41f230=_0x3a5f51['get']({'plain':!![]});var _0xe3aea3=_0xaa65('0x56');return db[_0xaa65('0x57')][_0xaa65('0x51')]({'where':{'name':_0xe3aea3,'userProfileId':_0x408e8a[_0xaa65('0x58')]},'raw':!![]})[_0xaa65('0x2b')](function(_0x40a2ee){if(_0x40a2ee&&_0x40a2ee[_0xaa65('0x59')]===0x0){return db['UserProfileResource'][_0xaa65('0x52')]({'name':_0x41f230[_0xaa65('0x32')],'resourceId':_0x41f230['id'],'type':_0xaa65('0x2d'),'sectionId':_0x40a2ee['id']},{})[_0xaa65('0x2b')](function(){return _0x3a5f51;});}else{return _0x3a5f51;}})[_0xaa65('0x4d')](function(_0x4cac0){logger[_0xaa65('0x30')](_0xaa65('0x5a'),_0x4cac0);throw _0x4cac0;});}return _0x3a5f51;})[_0xaa65('0x2b')](respondWithResult(_0x2d8851,0xc9))[_0xaa65('0x4d')](handleError(_0x2d8851,null));};exports[_0xaa65('0x5b')]=function(_0x5ab04b,_0x5333c4){if(_0x5ab04b[_0xaa65('0x5c')]['id']){delete _0x5ab04b['body']['id'];}return db[_0xaa65('0x35')][_0xaa65('0x51')]({'where':{'id':_0x5ab04b[_0xaa65('0x4f')]['id']}})['then'](handleEntityNotFound(_0x5333c4,null))[_0xaa65('0x2b')](saveUpdates(_0x5ab04b[_0xaa65('0x5c')],null))[_0xaa65('0x2b')](respondWithResult(_0x5333c4,null))['catch'](handleError(_0x5333c4,null));};exports[_0xaa65('0x2f')]=function(_0x2e53ed,_0x36a973){return db[_0xaa65('0x35')][_0xaa65('0x51')]({'where':{'id':_0x2e53ed['params']['id']}})[_0xaa65('0x2b')](handleEntityNotFound(_0x36a973,null))[_0xaa65('0x2b')](removeEntity(_0x36a973,null))[_0xaa65('0x4d')](handleError(_0x36a973,null));};exports[_0xaa65('0x5d')]=function(_0x42f3d7,_0x5d9663){var _0x2259c6=0xa;var _0xced8d3=[_0xaa65('0x5e'),_0xaa65('0x5f'),'right_join','cross_join'];var _0xe29e5={'SUM':_0xaa65('0x60'),'COUNT':_0xaa65('0x61'),'COUNT DISTINCT':_0xaa65('0x62'),'MAX':_0xaa65('0x63'),'MIN':_0xaa65('0x64'),'AVG':'AVG(%s)','GROUP_CONCAT':_0xaa65('0x65'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0xaa65('0x66')};var _0x1f1675={'SEC_TO_TIME':_0xaa65('0x67'),'DATE':_0xaa65('0x68'),'HOUR':_0xaa65('0x69'),'ROUND':_0xaa65('0x6a'),'UNIX_TIMESTAMP':_0xaa65('0x6b')};var _0x629f68=function(_0x1bca6d){return!_[_0xaa65('0x6c')]([_0xaa65('0x6d'),'IS\x20NOT\x20NULL',_0xaa65('0x6e'),_0xaa65('0x6f')],_0x1bca6d);};var _0x777492=function(_0x3b38ca){if(!_0x3b38ca||!_0x3b38ca[_0xaa65('0x70')][_0xaa65('0x50')]){return'';}for(var _0x19b0c7='(',_0x35138a=0x0;_0x35138a<_0x3b38ca[_0xaa65('0x70')][_0xaa65('0x50')];_0x35138a+=0x1){_0x35138a>0x0&&(_0x19b0c7+='\x20'+_0x3b38ca['operator']+'\x20');_0x19b0c7+=_0x3b38ca[_0xaa65('0x70')][_0x35138a][_0xaa65('0x71')]?_0x777492(_0x3b38ca[_0xaa65('0x70')][_0x35138a][_0xaa65('0x71')]):_0x3b38ca[_0xaa65('0x70')][_0x35138a][_0xaa65('0x72')]+'\x20'+_0x3b38ca[_0xaa65('0x70')][_0x35138a][_0xaa65('0x73')]+(_0x629f68(_0x3b38ca[_0xaa65('0x70')][_0x35138a][_0xaa65('0x73')])?'\x20'+_0x3b38ca[_0xaa65('0x70')][_0x35138a][_0xaa65('0x74')]:'');}return _0x19b0c7+')';};var _0x3ba35f={'where':{'id':_0x42f3d7['params']['id']}},_0x4bf83f,_0x443bf2,_0x5b3f96,_0x44aa56,_0x54d71e;_0x3ba35f=_[_0xaa65('0x46')]({},_0x3ba35f,_0x42f3d7[_0xaa65('0x4a')]);return db[_0xaa65('0x35')][_0xaa65('0x51')](_0x3ba35f)[_0xaa65('0x2b')](function(_0x38ea27){if(_0x38ea27){_0x4bf83f=_0x38ea27;return _0x38ea27[_0xaa65('0x75')]();}return null;})[_0xaa65('0x2b')](function(_0x3f088b){if(_0x3f088b){if(!_0x3f088b[_0xaa65('0x50')]){throw new db[(_0xaa65('0x76'))][(_0xaa65('0x77'))](_0xaa65('0x78'),0x193);}_0x443bf2=_0x3f088b;return db[_0xaa65('0x79')]['findAll']({'raw':!![]});}return null;})[_0xaa65('0x2b')](function(_0xe07674){if(_0xe07674){_0x5b3f96=_[_0xaa65('0x7a')](_0xe07674,'id');var _0x21c339;var _0x3e12f6=squel['select']();_0x3e12f6[_0xaa65('0x7b')](_0x4bf83f[_0xaa65('0x7c')]);for(var _0x3dd1ab=0x0;_0x3dd1ab<_0x443bf2[_0xaa65('0x50')];_0x3dd1ab+=0x1){_0x21c339=_0x443bf2[_0x3dd1ab][_0xaa65('0x7d')]?_0x5b3f96[_0x443bf2[_0x3dd1ab][_0xaa65('0x7d')]][_0xaa65('0x7e')]:_0x443bf2[_0x3dd1ab][_0xaa65('0x72')];_0x21c339=_0x443bf2[_0x3dd1ab][_0xaa65('0x7f')]?_[_0xaa65('0x80')](_0xe29e5[_0x443bf2[_0x3dd1ab][_0xaa65('0x7f')]],'%s',_0x21c339):_0x21c339;_0x21c339=_0x443bf2[_0x3dd1ab][_0xaa65('0x81')]?_[_0xaa65('0x80')](_0x1f1675[_0x443bf2[_0x3dd1ab][_0xaa65('0x81')]],'%s',_0x21c339):_0x21c339;if(_0x443bf2[_0x3dd1ab][_0xaa65('0x82')]){_0x3e12f6[_0xaa65('0x71')](_0x21c339);}_0x443bf2[_0x3dd1ab][_0xaa65('0x83')]&&_0x3e12f6[_0xaa65('0x42')](_0x21c339,_0x443bf2[_0x3dd1ab][_0xaa65('0x83')]==='DESC'?![]:!![]);_0x3e12f6['field'](_0x21c339,_0x443bf2[_0x3dd1ab]['alias']||_0x21c339);}if(_0x4bf83f[_0xaa65('0x84')]){_0x4bf83f['joins']=JSON['parse'](_0x4bf83f[_0xaa65('0x84')]);for(var _0x5e45c4=0x0;_0x5e45c4<_0x4bf83f['joins']['length'];_0x5e45c4+=0x1){if(_0x4bf83f['joins'][_0x5e45c4]['type']&&_[_0xaa65('0x6c')](_0xced8d3,_0x4bf83f[_0xaa65('0x84')][_0x5e45c4]['type'])&&_0x4bf83f[_0xaa65('0x84')][_0x5e45c4][_0xaa65('0x85')]&&_0x4bf83f['joins'][_0x5e45c4]['foreignTable']&&_0x4bf83f[_0xaa65('0x84')][_0x5e45c4][_0xaa65('0x86')]){_0x3e12f6[_0x4bf83f[_0xaa65('0x84')][_0x5e45c4]['type']](_0x4bf83f['joins'][_0x5e45c4][_0xaa65('0x87')],null,util['format']('%s.%s\x20=\x20%s.%s',_0x4bf83f[_0xaa65('0x7c')],_0x4bf83f[_0xaa65('0x84')][_0x5e45c4][_0xaa65('0x85')],_0x4bf83f[_0xaa65('0x84')][_0x5e45c4]['foreignTable'],_0x4bf83f['joins'][_0x5e45c4][_0xaa65('0x86')]));}}}if(_0x4bf83f[_0xaa65('0x88')]){_0x4bf83f[_0xaa65('0x88')]=JSON[_0xaa65('0x89')](_0x4bf83f[_0xaa65('0x88')]);_0x3e12f6[_0xaa65('0x47')](_0x777492(_0x4bf83f['conditions'][_0xaa65('0x71')]));}_0x54d71e=_0x3e12f6[_0xaa65('0x8a')]();_0x3e12f6[_0xaa65('0x25')](_0x2259c6);_0x3e12f6[_0xaa65('0x23')](0x0);logger[_0xaa65('0x8b')](_0xaa65('0x8c'),_0x3e12f6[_0xaa65('0x8d')]());return dbH[_0xaa65('0x8e')][_0xaa65('0x3a')](_0x3e12f6[_0xaa65('0x8d')](),{'type':dbH['sequelize'][_0xaa65('0x8f')][_0xaa65('0x90')]});}})['then'](respondWithResult(_0x5d9663,null))[_0xaa65('0x4d')](handleError(_0x5d9663,null));};function runReport(_0x16816e,_0x2699fa,_0xd15fbe){var _0xd470c0=_0x2699fa[_0xaa65('0x32')];var _0x2be9e7=0xa;var _0x5a3ffd=[_0xaa65('0x5e'),_0xaa65('0x5f'),'right_join','cross_join'];var _0x300e06={'SUM':_0xaa65('0x60'),'COUNT':_0xaa65('0x61'),'COUNT DISTINCT':_0xaa65('0x62'),'MAX':_0xaa65('0x63'),'MIN':_0xaa65('0x64'),'AVG':'AVG(%s)','GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0xaa65('0x91'),'GROUP_CONCAT DESC':_0xaa65('0x66')};var _0x5d2047={'SEC_TO_TIME':_0xaa65('0x67'),'DATE':_0xaa65('0x68'),'HOUR':_0xaa65('0x69'),'ROUND':_0xaa65('0x6a'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x135f2d=function(_0x2a4bb7){return!_['includes'](['IS\x20NULL',_0xaa65('0x92'),_0xaa65('0x6e'),_0xaa65('0x6f')],_0x2a4bb7);};var _0x219d3a=function(_0x1c9bd6){if(!_0x1c9bd6||!_0x1c9bd6['rules'][_0xaa65('0x50')]){return'';}for(var _0xa67c17='(',_0x4fb9dc=0x0;_0x4fb9dc<_0x1c9bd6['rules'][_0xaa65('0x50')];_0x4fb9dc+=0x1){_0x4fb9dc>0x0&&(_0xa67c17+='\x20'+_0x1c9bd6['operator']+'\x20');_0xa67c17+=_0x1c9bd6[_0xaa65('0x70')][_0x4fb9dc]['group']?_0x219d3a(_0x1c9bd6['rules'][_0x4fb9dc]['group']):_0x1c9bd6[_0xaa65('0x70')][_0x4fb9dc][_0xaa65('0x72')]+'\x20'+_0x1c9bd6['rules'][_0x4fb9dc][_0xaa65('0x73')]+(_0x135f2d(_0x1c9bd6[_0xaa65('0x70')][_0x4fb9dc]['condition'])?'\x20'+_0x1c9bd6[_0xaa65('0x70')][_0x4fb9dc]['value']:'');}return _0xa67c17+')';};var _0x152ba2={'where':{'id':_0x16816e['id']}},_0x1bda19,_0x37804e,_0x29a306,_0x26e82c,_0x378af5;_0x152ba2=_[_0xaa65('0x46')]({},_0x152ba2,_0xd15fbe);return db[_0xaa65('0x35')][_0xaa65('0x51')](_0x152ba2)[_0xaa65('0x2b')](function(_0xff8672){if(_0xff8672){_0x1bda19=_0xff8672;return _0xff8672[_0xaa65('0x75')]();}return null;})[_0xaa65('0x2b')](function(_0x334781){if(_0x334781){if(!_0x334781['length']){throw new db[(_0xaa65('0x76'))]['ValidationErrorItem'](_0xaa65('0x78'),0x193);}_0x37804e=_0x334781;return db['AnalyticMetric'][_0xaa65('0x93')]({'raw':!![]});}return null;})[_0xaa65('0x2b')](function(_0x1d4fa3){if(_0x1d4fa3){_0x29a306=_[_0xaa65('0x7a')](_0x1d4fa3,'id');var _0x605c13;var _0x3d0e51=squel[_0xaa65('0x94')]();_0x3d0e51[_0xaa65('0x7b')](_0x1bda19[_0xaa65('0x7c')]);for(var _0x4216e5=0x0;_0x4216e5<_0x37804e['length'];_0x4216e5+=0x1){_0x605c13=_0x37804e[_0x4216e5][_0xaa65('0x7d')]?_0x29a306[_0x37804e[_0x4216e5][_0xaa65('0x7d')]][_0xaa65('0x7e')]:_0x37804e[_0x4216e5][_0xaa65('0x72')];_0x605c13=_0x37804e[_0x4216e5][_0xaa65('0x7f')]?_[_0xaa65('0x80')](_0x300e06[_0x37804e[_0x4216e5][_0xaa65('0x7f')]],'%s',_0x605c13):_0x605c13;_0x605c13=_0x37804e[_0x4216e5]['format']?_[_0xaa65('0x80')](_0x5d2047[_0x37804e[_0x4216e5][_0xaa65('0x81')]],'%s',_0x605c13):_0x605c13;if(_0x37804e[_0x4216e5]['groupBy']){_0x3d0e51[_0xaa65('0x71')](_0x605c13);}_0x37804e[_0x4216e5][_0xaa65('0x83')]&&_0x3d0e51[_0xaa65('0x42')](_0x605c13,_0x37804e[_0x4216e5][_0xaa65('0x83')]===_0xaa65('0x95')?![]:!![]);_0x3d0e51[_0xaa65('0x72')](_0x605c13,_0x37804e[_0x4216e5][_0xaa65('0x96')]||_0x605c13);}if(_0x1bda19[_0xaa65('0x84')]){_0x1bda19['joins']=JSON[_0xaa65('0x89')](_0x1bda19['joins']);for(var _0x391ace=0x0;_0x391ace<_0x1bda19[_0xaa65('0x84')][_0xaa65('0x50')];_0x391ace+=0x1){if(_0x1bda19[_0xaa65('0x84')][_0x391ace][_0xaa65('0x48')]&&_[_0xaa65('0x6c')](_0x5a3ffd,_0x1bda19[_0xaa65('0x84')][_0x391ace][_0xaa65('0x48')])&&_0x1bda19[_0xaa65('0x84')][_0x391ace][_0xaa65('0x85')]&&_0x1bda19['joins'][_0x391ace]['foreignTable']&&_0x1bda19[_0xaa65('0x84')][_0x391ace][_0xaa65('0x86')]){_0x3d0e51[_0x1bda19[_0xaa65('0x84')][_0x391ace]['type']](_0x1bda19[_0xaa65('0x84')][_0x391ace]['foreignTable'],null,util[_0xaa65('0x81')](_0xaa65('0x97'),_0x1bda19[_0xaa65('0x7c')],_0x1bda19['joins'][_0x391ace][_0xaa65('0x85')],_0x1bda19[_0xaa65('0x84')][_0x391ace]['foreignTable'],_0x1bda19[_0xaa65('0x84')][_0x391ace][_0xaa65('0x86')]));}}}if(_0x1bda19[_0xaa65('0x88')]){_0x1bda19['conditions']=JSON[_0xaa65('0x89')](_0x1bda19[_0xaa65('0x88')]);_0x3d0e51['where'](_0x219d3a(_0x1bda19[_0xaa65('0x88')][_0xaa65('0x71')]));}_0x378af5=_0x3d0e51[_0xaa65('0x8a')]();_0x3d0e51['limit'](_0x2be9e7);_0x3d0e51[_0xaa65('0x23')](0x0);return;}})[_0xaa65('0x2b')](function(){if(_0x2699fa[_0xaa65('0x98')]===_0xaa65('0x99')){return null;}var _0x36c782=_[_0xaa65('0x46')](_0x2699fa,{'name':_0x2699fa[_0xaa65('0x9a')]||_0x2699fa[_0xaa65('0x32')]||_0x1bda19[_0xaa65('0x32')],'basename':_0xd470c0,'savename':util['format'](_0xaa65('0x9b'),_0x2699fa[_0xaa65('0x32')]||_0x1bda19[_0xaa65('0x32')],require(_0xaa65('0x9c'))[_0xaa65('0x9d')](0x4),_0x2699fa['output']||_0xaa65('0x9e')),'reportId':_0x1bda19['id'],'reportType':_0xaa65('0x9f')});return db[_0xaa65('0xa0')]['create'](_0x36c782,{'raw':!![]});})[_0xaa65('0x2b')](function(_0x4d2fb4){if(_0x1bda19[_0xaa65('0x7c')]===_0xaa65('0xa1')){_0x378af5[_0xaa65('0x47')](_0x1bda19[_0xaa65('0x7c')]+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x2699fa[_0xaa65('0xa2')],_0x2699fa[_0xaa65('0xa3')]);}else{_0x378af5[_0xaa65('0x47')](_0x1bda19[_0xaa65('0x7c')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x2699fa['startDate'],_0x2699fa[_0xaa65('0xa3')]);}if(_0x4d2fb4){logger[_0xaa65('0xa4')]('Run\x20Query:',_0x378af5[_0xaa65('0x8d')]());require('child_process')['fork'](path[_0xaa65('0x5e')](__dirname,_0xaa65('0xa5'),_0x4d2fb4[_0xaa65('0x98')]),[_0x4d2fb4['id'],_0x378af5['toString'](),path[_0xaa65('0x5e')](__dirname,_0xaa65('0xa6'),_0x4d2fb4[_0xaa65('0xa7')]),_0xd470c0]);return _0x4d2fb4;}else{var _0x3910c4=squel['select']();_0x3910c4[_0xaa65('0x7b')]('('+_0x378af5[_0xaa65('0x8d')]()+')',_0xaa65('0xa8'));_0x3910c4[_0xaa65('0x72')](_0xaa65('0xa9'),_0xaa65('0x26'));_0x378af5[_0xaa65('0x25')](_0x2699fa[_0xaa65('0x25')]||_0x2be9e7);_0x378af5[_0xaa65('0x23')](_0x2699fa[_0xaa65('0x23')]||0x0);return dbH[_0xaa65('0x8e')]['query'](_0x3910c4[_0xaa65('0x8d')](),{'type':dbH['sequelize'][_0xaa65('0x8f')][_0xaa65('0x90')]})[_0xaa65('0x2b')](function(_0x4106b7){if(!_0x4106b7[_0xaa65('0x50')]){_0x26e82c=0x0;}else{_0x26e82c=_0x4106b7[0x0][_0xaa65('0x26')]||0x0;}return dbH[_0xaa65('0x8e')][_0xaa65('0x3a')](_0x378af5[_0xaa65('0x8d')](),{'type':dbH[_0xaa65('0x8e')]['QueryTypes']['SELECT']});})[_0xaa65('0x2b')](function(_0x85710d){return{'rows':_0x85710d||[],'count':_0x26e82c};});}});}exports[_0xaa65('0xaa')]=function(_0x2643a3,_0x328b2e){return runReport(_0x2643a3['params'],_0x2643a3[_0xaa65('0x3a')],_0x2643a3[_0xaa65('0x4a')])['then'](respondWithResult(_0x328b2e,null))[_0xaa65('0x4d')](handleError(_0x328b2e,null));};exports[_0xaa65('0xab')]=runReport;exports[_0xaa65('0x3a')]=function(_0x1723c2,_0x3c0298){var _0x217df4=0xa;var _0x44170a=[_0xaa65('0x5e'),_0xaa65('0x5f'),_0xaa65('0xac'),_0xaa65('0xad')];var _0x66d4c3={'SUM':_0xaa65('0x60'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0xaa65('0x62'),'MAX':_0xaa65('0x63'),'MIN':_0xaa65('0x64'),'AVG':_0xaa65('0xae'),'GROUP_CONCAT':_0xaa65('0x65'),'GROUP_CONCAT ASC':_0xaa65('0x91'),'GROUP_CONCAT DESC':_0xaa65('0x66')};var _0x56bbda={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':'DATE(%s)','HOUR':_0xaa65('0x69'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0xaa65('0x6b')};var _0x39cb2f=function(_0x588b1b){return!_['includes']([_0xaa65('0x6d'),_0xaa65('0x92'),_0xaa65('0x6e'),_0xaa65('0x6f')],_0x588b1b);};var _0x43da24=function(_0x1b3479){if(!_0x1b3479||!_0x1b3479[_0xaa65('0x70')][_0xaa65('0x50')]){return'';}for(var _0x5f00c7='(',_0x2bd1b8=0x0;_0x2bd1b8<_0x1b3479['rules'][_0xaa65('0x50')];_0x2bd1b8+=0x1){_0x2bd1b8>0x0&&(_0x5f00c7+='\x20'+_0x1b3479[_0xaa65('0xaf')]+'\x20');_0x5f00c7+=_0x1b3479[_0xaa65('0x70')][_0x2bd1b8][_0xaa65('0x71')]?_0x43da24(_0x1b3479[_0xaa65('0x70')][_0x2bd1b8][_0xaa65('0x71')]):_0x1b3479[_0xaa65('0x70')][_0x2bd1b8]['field']+'\x20'+_0x1b3479[_0xaa65('0x70')][_0x2bd1b8][_0xaa65('0x73')]+(_0x39cb2f(_0x1b3479['rules'][_0x2bd1b8]['condition'])?'\x20'+_0x1b3479['rules'][_0x2bd1b8][_0xaa65('0x74')]:'');}return _0x5f00c7+')';};var _0x1a6a6d={'where':{'id':_0x1723c2['params']['id']}},_0x363639,_0x3cdcb9,_0x3f6c95,_0x30ef13,_0x92d5b4;_0x1a6a6d=_[_0xaa65('0x46')]({},_0x1a6a6d,_0x1723c2[_0xaa65('0x4a')]);return db[_0xaa65('0x35')][_0xaa65('0x51')](_0x1a6a6d)[_0xaa65('0x2b')](function(_0x2430b0){if(_0x2430b0){_0x363639=_0x2430b0;return _0x2430b0[_0xaa65('0x75')]();}return null;})[_0xaa65('0x2b')](function(_0x27cf3e){if(_0x27cf3e){if(!_0x27cf3e[_0xaa65('0x50')]){throw new db[(_0xaa65('0x76'))][(_0xaa65('0x77'))](_0xaa65('0x78'),0x193);}_0x3cdcb9=_0x27cf3e;return db['AnalyticMetric'][_0xaa65('0x93')]({'raw':!![]});}return null;})['then'](function(_0x5dda17){if(_0x5dda17){_0x3f6c95=_[_0xaa65('0x7a')](_0x5dda17,'id');var _0x5d52a0;var _0x382794=squel[_0xaa65('0x94')]();_0x382794[_0xaa65('0x7b')](_0x363639[_0xaa65('0x7c')]);for(var _0x1648be=0x0;_0x1648be<_0x3cdcb9[_0xaa65('0x50')];_0x1648be+=0x1){_0x5d52a0=_0x3cdcb9[_0x1648be][_0xaa65('0x7d')]?_0x3f6c95[_0x3cdcb9[_0x1648be][_0xaa65('0x7d')]][_0xaa65('0x7e')]:_0x3cdcb9[_0x1648be]['field'];_0x5d52a0=_0x3cdcb9[_0x1648be][_0xaa65('0x7f')]?_[_0xaa65('0x80')](_0x66d4c3[_0x3cdcb9[_0x1648be][_0xaa65('0x7f')]],'%s',_0x5d52a0):_0x5d52a0;_0x5d52a0=_0x3cdcb9[_0x1648be][_0xaa65('0x81')]?_['replace'](_0x56bbda[_0x3cdcb9[_0x1648be]['format']],'%s',_0x5d52a0):_0x5d52a0;if(_0x3cdcb9[_0x1648be][_0xaa65('0x82')]){_0x382794['group'](_0x5d52a0);}_0x3cdcb9[_0x1648be]['orderBy']&&_0x382794[_0xaa65('0x42')](_0x5d52a0,_0x3cdcb9[_0x1648be]['orderBy']===_0xaa65('0x95')?![]:!![]);_0x382794[_0xaa65('0x72')](_0x5d52a0,_0x3cdcb9[_0x1648be][_0xaa65('0x96')]||_0x5d52a0);}if(_0x363639['joins']){_0x363639[_0xaa65('0x84')]=JSON['parse'](_0x363639[_0xaa65('0x84')]);for(var _0x147aee=0x0;_0x147aee<_0x363639[_0xaa65('0x84')][_0xaa65('0x50')];_0x147aee+=0x1){if(_0x363639['joins'][_0x147aee][_0xaa65('0x48')]&&_[_0xaa65('0x6c')](_0x44170a,_0x363639[_0xaa65('0x84')][_0x147aee][_0xaa65('0x48')])&&_0x363639[_0xaa65('0x84')][_0x147aee]['parentKey']&&_0x363639['joins'][_0x147aee][_0xaa65('0x87')]&&_0x363639['joins'][_0x147aee][_0xaa65('0x86')]){_0x382794[_0x363639[_0xaa65('0x84')][_0x147aee]['type']](_0x363639[_0xaa65('0x84')][_0x147aee][_0xaa65('0x87')],null,util[_0xaa65('0x81')](_0xaa65('0x97'),_0x363639['table'],_0x363639[_0xaa65('0x84')][_0x147aee][_0xaa65('0x85')],_0x363639[_0xaa65('0x84')][_0x147aee][_0xaa65('0x87')],_0x363639[_0xaa65('0x84')][_0x147aee][_0xaa65('0x86')]));}}}if(_0x363639[_0xaa65('0x88')]){_0x363639['conditions']=JSON[_0xaa65('0x89')](_0x363639[_0xaa65('0x88')]);_0x382794[_0xaa65('0x47')](_0x43da24(_0x363639[_0xaa65('0x88')][_0xaa65('0x71')]));}_0x92d5b4=_0x382794[_0xaa65('0x8a')]();_0x382794[_0xaa65('0x25')](_0x217df4);_0x382794[_0xaa65('0x23')](0x0);logger[_0xaa65('0x8b')]('Limited\x20Query:',_0x382794[_0xaa65('0x8d')]());return dbH['sequelize'][_0xaa65('0x3a')](_0x382794[_0xaa65('0x8d')](),{'type':dbH[_0xaa65('0x8e')]['QueryTypes'][_0xaa65('0x90')]});}})['then'](function(){return{'sql':_0x92d5b4[_0xaa65('0x8d')]()};})[_0xaa65('0x2b')](respondWithResult(_0x3c0298,null))[_0xaa65('0x4d')](handleError(_0x3c0298,null));};
git://repos.xcallymotion.com / motion2.git / blob