18 var _0x0c1a=['undefined','count','limit','set','Content-Range','reject','save','update','then','destroy','CustomReports','UserProfileResource','error','stack','name','index','map','AnalyticCustomReport','rawAttributes','fieldName','type','key','model','keys','filters','intersection','attributes','query','fields','length','hasOwnProperty','nolimit','sort','where','pick','filter','merge','VIRTUAL','options','includeAll','include','findAll','catch','show','create','body','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','UserProfileSection','userProfileId','autoAssociation','find','params','join','left_join','right_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','MIN(%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)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','value','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','select','from','MetricId','metric','function','replace','format','groupBy','orderBy','order','DESC','alias','joins','includes','parentKey','foreignTable','%s.%s\x20=\x20%s.%s','table','foreignKey','conditions','parse','clone','debug','toString','sequelize','QueryTypes','SELECT','cross_join','MAX(%s)','DATE(%s)','IS\x20NULL','web','fullPath','%s-%s.%s','generate','output','csv','custom','AnalyticExtractedReport','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','Run\x20Query:','child_process','fork','../../components/export/','../../files/reports','savename','countTable','runReport','IS\x20NOT\x20NULL','Limited\x20Query:','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','path','ejs','fs-extra','jsforce','desk.js','to-csv','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/license/util','../../mysqldb','dbH','sendStatus','status','end','json','offset'];(function(_0x31ed12,_0x2a38f9){var _0x1afd40=function(_0x23a8ca){while(--_0x23a8ca){_0x31ed12['push'](_0x31ed12['shift']());}};_0x1afd40(++_0x2a38f9);}(_0x0c1a,0x1d6));var _0xa0c1=function(_0x297dc0,_0x430b7b){_0x297dc0=_0x297dc0-0x0;var _0x59f9fd=_0x0c1a[_0x297dc0];return _0x59f9fd;};'use strict';var emlformat=require(_0xa0c1('0x0'));var rimraf=require(_0xa0c1('0x1'));var zipdir=require(_0xa0c1('0x2'));var jsonpatch=require(_0xa0c1('0x3'));var rp=require(_0xa0c1('0x4'));var moment=require(_0xa0c1('0x5'));var BPromise=require('bluebird');var Mustache=require(_0xa0c1('0x6'));var util=require('util');var path=require(_0xa0c1('0x7'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0xa0c1('0x8'));var fs=require('fs');var fs_extra=require(_0xa0c1('0x9'));var _=require('lodash');var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0xa0c1('0xa'));var deskjs=require(_0xa0c1('0xb'));var toCsv=require(_0xa0c1('0xc'));var querystring=require('querystring');var Papa=require(_0xa0c1('0xd'));var Redis=require(_0xa0c1('0xe'));var authService=require('../../components/auth/service');var qs=require(_0xa0c1('0xf'));var as=require(_0xa0c1('0x10'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xa0c1('0x11'))(_0xa0c1('0x12'));var utils=require(_0xa0c1('0x13'));var config=require('../../config/environment');var licenseUtil=require(_0xa0c1('0x14'));var db=require('../../mysqldb')['db'];var dbH=require(_0xa0c1('0x15'))[_0xa0c1('0x16')];function respondWithStatusCode(_0x174811,_0x46ca12){_0x46ca12=_0x46ca12||0xcc;return function(_0x5ee530){if(_0x5ee530){return _0x174811[_0xa0c1('0x17')](_0x46ca12);}return _0x174811[_0xa0c1('0x18')](_0x46ca12)[_0xa0c1('0x19')]();};}function respondWithResult(_0x1e471a,_0x214d26){_0x214d26=_0x214d26||0xc8;return function(_0x583d08){if(_0x583d08){return _0x1e471a[_0xa0c1('0x18')](_0x214d26)[_0xa0c1('0x1a')](_0x583d08);}};}function respondWithFilteredResult(_0x1cda39,_0x32e488){return function(_0x28b425){if(_0x28b425){var _0x15551e=typeof _0x32e488[_0xa0c1('0x1b')]===_0xa0c1('0x1c')&&typeof _0x32e488['limit']===_0xa0c1('0x1c');var _0x5a038c=_0x28b425[_0xa0c1('0x1d')];var _0xfe894c=_0x15551e?0x0:_0x32e488[_0xa0c1('0x1b')];var _0x15227f=_0x15551e?_0x28b425[_0xa0c1('0x1d')]:_0x32e488[_0xa0c1('0x1b')]+_0x32e488[_0xa0c1('0x1e')];var _0x436a8f;if(_0x15227f>=_0x5a038c){_0x15227f=_0x5a038c;_0x436a8f=0xc8;}else{_0x436a8f=0xce;}_0x1cda39[_0xa0c1('0x18')](_0x436a8f);return _0x1cda39[_0xa0c1('0x1f')](_0xa0c1('0x20'),_0xfe894c+'-'+_0x15227f+'/'+_0x5a038c)['json'](_0x28b425);}return null;};}function patchUpdates(_0xa99a46){return function(_0x7e5c12){try{jsonpatch['apply'](_0x7e5c12,_0xa99a46,!![]);}catch(_0x186f27){return BPromise[_0xa0c1('0x21')](_0x186f27);}return _0x7e5c12[_0xa0c1('0x22')]();};}function saveUpdates(_0x455012,_0x1f83b8){return function(_0xe6848e){if(_0xe6848e){return _0xe6848e[_0xa0c1('0x23')](_0x455012)[_0xa0c1('0x24')](function(_0x1e1aab){return _0x1e1aab;});}return null;};}function removeEntity(_0xc2afa9,_0x1e3cfe){return function(_0x4a648b){if(_0x4a648b){return _0x4a648b[_0xa0c1('0x25')]()[_0xa0c1('0x24')](function(){var _0x51adfe=_0x4a648b['get']({'plain':!![]});var _0x449193=_0xa0c1('0x26');return db[_0xa0c1('0x27')][_0xa0c1('0x25')]({'where':{'type':_0x449193,'resourceId':_0x51adfe['id']}})['then'](function(){return _0x4a648b;});})['then'](function(){_0xc2afa9['status'](0xcc)[_0xa0c1('0x19')]();});}};}function handleEntityNotFound(_0x595989,_0x54f349){return function(_0x1dcd5c){if(!_0x1dcd5c){_0x595989['sendStatus'](0x194);}return _0x1dcd5c;};}function handleError(_0x3ff5f4,_0x3d1868){_0x3d1868=_0x3d1868||0x1f4;return function(_0x5776eb){logger[_0xa0c1('0x28')](_0x5776eb[_0xa0c1('0x29')]);if(_0x5776eb[_0xa0c1('0x2a')]){delete _0x5776eb['name'];}_0x3ff5f4[_0xa0c1('0x18')](_0x3d1868)['send'](_0x5776eb);};}exports[_0xa0c1('0x2b')]=function(_0x390a71,_0x4b3e11){var _0x2866b4={},_0x1f1b94={},_0x795f9a={'count':0x0,'rows':[]};var _0x2e9577=_[_0xa0c1('0x2c')](db[_0xa0c1('0x2d')][_0xa0c1('0x2e')],function(_0x119cbb){return{'name':_0x119cbb[_0xa0c1('0x2f')],'type':_0x119cbb[_0xa0c1('0x30')][_0xa0c1('0x31')]};});_0x1f1b94[_0xa0c1('0x32')]=_[_0xa0c1('0x2c')](_0x2e9577,_0xa0c1('0x2a'));_0x1f1b94['query']=_[_0xa0c1('0x33')](_0x390a71['query']);_0x1f1b94[_0xa0c1('0x34')]=_[_0xa0c1('0x35')](_0x1f1b94['model'],_0x1f1b94['query']);_0x2866b4[_0xa0c1('0x36')]=_[_0xa0c1('0x35')](_0x1f1b94[_0xa0c1('0x32')],qs['fields'](_0x390a71[_0xa0c1('0x37')][_0xa0c1('0x38')]));_0x2866b4[_0xa0c1('0x36')]=_0x2866b4[_0xa0c1('0x36')][_0xa0c1('0x39')]?_0x2866b4[_0xa0c1('0x36')]:_0x1f1b94[_0xa0c1('0x32')];if(!_0x390a71['query'][_0xa0c1('0x3a')](_0xa0c1('0x3b'))){_0x2866b4[_0xa0c1('0x1e')]=qs[_0xa0c1('0x1e')](_0x390a71[_0xa0c1('0x37')][_0xa0c1('0x1e')]);_0x2866b4[_0xa0c1('0x1b')]=qs[_0xa0c1('0x1b')](_0x390a71[_0xa0c1('0x37')]['offset']);}_0x2866b4['order']=qs[_0xa0c1('0x3c')](_0x390a71[_0xa0c1('0x37')]['sort']);_0x2866b4[_0xa0c1('0x3d')]=qs[_0xa0c1('0x34')](_[_0xa0c1('0x3e')](_0x390a71[_0xa0c1('0x37')],_0x1f1b94[_0xa0c1('0x34')]),_0x2e9577);if(_0x390a71['query'][_0xa0c1('0x3f')]){_0x2866b4[_0xa0c1('0x3d')]=_[_0xa0c1('0x40')](_0x2866b4[_0xa0c1('0x3d')],{'$or':_[_0xa0c1('0x2c')](_0x2e9577,function(_0xaf853f){if(_0xaf853f['type']!==_0xa0c1('0x41')){var _0x3881b7={};_0x3881b7[_0xaf853f[_0xa0c1('0x2a')]]={'$like':'%'+_0x390a71['query'][_0xa0c1('0x3f')]+'%'};return _0x3881b7;}})});}_0x2866b4=_[_0xa0c1('0x40')]({},_0x2866b4,_0x390a71[_0xa0c1('0x42')]);var _0x2f7dc6={'where':_0x2866b4['where']};return db['AnalyticCustomReport']['count'](_0x2f7dc6)['then'](function(_0x494126){_0x795f9a[_0xa0c1('0x1d')]=_0x494126;if(_0x390a71['query'][_0xa0c1('0x43')]){_0x2866b4[_0xa0c1('0x44')]=[{'all':!![]}];}return db[_0xa0c1('0x2d')][_0xa0c1('0x45')](_0x2866b4);})[_0xa0c1('0x24')](function(_0x2075d9){_0x795f9a['rows']=_0x2075d9;return _0x795f9a;})['then'](respondWithFilteredResult(_0x4b3e11,_0x2866b4))[_0xa0c1('0x46')](handleError(_0x4b3e11,null));};exports[_0xa0c1('0x47')]=function(_0x503a8b,_0x3d4752){var _0x1a8992={'raw':![],'where':{'id':_0x503a8b['params']['id']}},_0x4f3875={};_0x4f3875[_0xa0c1('0x32')]=_['keys'](db[_0xa0c1('0x2d')]['rawAttributes']);_0x4f3875[_0xa0c1('0x37')]=_[_0xa0c1('0x33')](_0x503a8b[_0xa0c1('0x37')]);_0x4f3875[_0xa0c1('0x34')]=_[_0xa0c1('0x35')](_0x4f3875[_0xa0c1('0x32')],_0x4f3875[_0xa0c1('0x37')]);_0x1a8992[_0xa0c1('0x36')]=_['intersection'](_0x4f3875[_0xa0c1('0x32')],qs[_0xa0c1('0x38')](_0x503a8b[_0xa0c1('0x37')][_0xa0c1('0x38')]));_0x1a8992[_0xa0c1('0x36')]=_0x1a8992['attributes'][_0xa0c1('0x39')]?_0x1a8992[_0xa0c1('0x36')]:_0x4f3875[_0xa0c1('0x32')];if(_0x503a8b[_0xa0c1('0x37')]['includeAll']){_0x1a8992[_0xa0c1('0x44')]=[{'all':!![]}];}_0x1a8992=_[_0xa0c1('0x40')]({},_0x1a8992,_0x503a8b['options']);return db[_0xa0c1('0x2d')]['find'](_0x1a8992)[_0xa0c1('0x24')](handleEntityNotFound(_0x3d4752,null))[_0xa0c1('0x24')](respondWithResult(_0x3d4752,null))[_0xa0c1('0x46')](handleError(_0x3d4752,null));};exports[_0xa0c1('0x48')]=function(_0x20dded,_0x46d489){return db[_0xa0c1('0x2d')][_0xa0c1('0x48')](_0x20dded[_0xa0c1('0x49')],{})[_0xa0c1('0x24')](function(_0x4300b4){var _0x58984b=_0x20dded['user'][_0xa0c1('0x4a')]({'plain':!![]});if(!_0x58984b)throw new Error(_0xa0c1('0x4b'));if(_0x58984b[_0xa0c1('0x4c')]===_0xa0c1('0x4d')){var _0x53fbfa=_0x4300b4['get']({'plain':!![]});var _0x84dd30='Reports';return db[_0xa0c1('0x4e')]['find']({'where':{'name':_0x84dd30,'userProfileId':_0x58984b[_0xa0c1('0x4f')]},'raw':!![]})['then'](function(_0x5820b8){if(_0x5820b8&&_0x5820b8[_0xa0c1('0x50')]===0x0){return db[_0xa0c1('0x27')][_0xa0c1('0x48')]({'name':_0x53fbfa['name'],'resourceId':_0x53fbfa['id'],'type':_0xa0c1('0x26'),'sectionId':_0x5820b8['id']},{})[_0xa0c1('0x24')](function(){return _0x4300b4;});}else{return _0x4300b4;}})[_0xa0c1('0x46')](function(_0x5ac664){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x5ac664);throw _0x5ac664;});}return _0x4300b4;})[_0xa0c1('0x24')](respondWithResult(_0x46d489,0xc9))[_0xa0c1('0x46')](handleError(_0x46d489,null));};exports[_0xa0c1('0x23')]=function(_0x3b2922,_0x147a79){if(_0x3b2922[_0xa0c1('0x49')]['id']){delete _0x3b2922[_0xa0c1('0x49')]['id'];}return db['AnalyticCustomReport'][_0xa0c1('0x51')]({'where':{'id':_0x3b2922[_0xa0c1('0x52')]['id']}})[_0xa0c1('0x24')](handleEntityNotFound(_0x147a79,null))[_0xa0c1('0x24')](saveUpdates(_0x3b2922[_0xa0c1('0x49')],null))['then'](respondWithResult(_0x147a79,null))[_0xa0c1('0x46')](handleError(_0x147a79,null));};exports[_0xa0c1('0x25')]=function(_0x14418e,_0x45c586){return db['AnalyticCustomReport']['find']({'where':{'id':_0x14418e['params']['id']}})[_0xa0c1('0x24')](handleEntityNotFound(_0x45c586,null))['then'](removeEntity(_0x45c586,null))[_0xa0c1('0x46')](handleError(_0x45c586,null));};exports['preview']=function(_0x240534,_0x349ecd){var _0x63b6ca=0xa;var _0x5ccb8b=[_0xa0c1('0x53'),_0xa0c1('0x54'),_0xa0c1('0x55'),'cross_join'];var _0xb46e9e={'SUM':_0xa0c1('0x56'),'COUNT':_0xa0c1('0x57'),'COUNT DISTINCT':_0xa0c1('0x58'),'MAX':'MAX(%s)','MIN':_0xa0c1('0x59'),'AVG':_0xa0c1('0x5a'),'GROUP_CONCAT':_0xa0c1('0x5b'),'GROUP_CONCAT ASC':_0xa0c1('0x5c'),'GROUP_CONCAT DESC':_0xa0c1('0x5d')};var _0x2497ab={'SEC_TO_TIME':_0xa0c1('0x5e'),'DATE':'DATE(%s)','HOUR':_0xa0c1('0x5f'),'ROUND':_0xa0c1('0x60'),'UNIX_TIMESTAMP':_0xa0c1('0x61')};var _0x235b8e=function(_0x45fde2){return!_['includes'](['IS\x20NULL','IS\x20NOT\x20NULL',_0xa0c1('0x62'),_0xa0c1('0x63')],_0x45fde2);};var _0x1b1e21=function(_0xa5c7ea){if(!_0xa5c7ea||!_0xa5c7ea[_0xa0c1('0x64')]['length']){return'';}for(var _0x1fa667='(',_0x43247b=0x0;_0x43247b<_0xa5c7ea[_0xa0c1('0x64')][_0xa0c1('0x39')];_0x43247b+=0x1){_0x43247b>0x0&&(_0x1fa667+='\x20'+_0xa5c7ea[_0xa0c1('0x65')]+'\x20');_0x1fa667+=_0xa5c7ea[_0xa0c1('0x64')][_0x43247b][_0xa0c1('0x66')]?_0x1b1e21(_0xa5c7ea[_0xa0c1('0x64')][_0x43247b][_0xa0c1('0x66')]):_0xa5c7ea[_0xa0c1('0x64')][_0x43247b][_0xa0c1('0x67')]+'\x20'+_0xa5c7ea[_0xa0c1('0x64')][_0x43247b][_0xa0c1('0x68')]+(_0x235b8e(_0xa5c7ea['rules'][_0x43247b][_0xa0c1('0x68')])?'\x20'+_0xa5c7ea['rules'][_0x43247b][_0xa0c1('0x69')]:'');}return _0x1fa667+')';};var _0x51d7ec={'where':{'id':_0x240534['params']['id']}},_0x15b0b4,_0x25d1a4,_0x1bb32b,_0x3ecbcc,_0x511c41;_0x51d7ec=_[_0xa0c1('0x40')]({},_0x51d7ec,_0x240534[_0xa0c1('0x42')]);return db[_0xa0c1('0x2d')][_0xa0c1('0x51')](_0x51d7ec)[_0xa0c1('0x24')](function(_0x8a5455){if(_0x8a5455){_0x15b0b4=_0x8a5455;return _0x8a5455[_0xa0c1('0x6a')]();}return null;})[_0xa0c1('0x24')](function(_0x58e1c4){if(_0x58e1c4){if(!_0x58e1c4['length']){throw new db[(_0xa0c1('0x6b'))][(_0xa0c1('0x6c'))](_0xa0c1('0x6d'),0x193);}_0x25d1a4=_0x58e1c4;return db[_0xa0c1('0x6e')][_0xa0c1('0x45')]({'raw':!![]});}return null;})[_0xa0c1('0x24')](function(_0x1cbbbe){if(_0x1cbbbe){_0x1bb32b=_[_0xa0c1('0x6f')](_0x1cbbbe,'id');var _0x48a209;var _0x275ca6=squel[_0xa0c1('0x70')]();_0x275ca6[_0xa0c1('0x71')](_0x15b0b4['table']);for(var _0x1298ff=0x0;_0x1298ff<_0x25d1a4[_0xa0c1('0x39')];_0x1298ff+=0x1){_0x48a209=_0x25d1a4[_0x1298ff]['MetricId']?_0x1bb32b[_0x25d1a4[_0x1298ff][_0xa0c1('0x72')]][_0xa0c1('0x73')]:_0x25d1a4[_0x1298ff][_0xa0c1('0x67')];_0x48a209=_0x25d1a4[_0x1298ff][_0xa0c1('0x74')]?_[_0xa0c1('0x75')](_0xb46e9e[_0x25d1a4[_0x1298ff]['function']],'%s',_0x48a209):_0x48a209;_0x48a209=_0x25d1a4[_0x1298ff]['format']?_[_0xa0c1('0x75')](_0x2497ab[_0x25d1a4[_0x1298ff][_0xa0c1('0x76')]],'%s',_0x48a209):_0x48a209;if(_0x25d1a4[_0x1298ff][_0xa0c1('0x77')]){_0x275ca6[_0xa0c1('0x66')](_0x48a209);}_0x25d1a4[_0x1298ff][_0xa0c1('0x78')]&&_0x275ca6[_0xa0c1('0x79')](_0x48a209,_0x25d1a4[_0x1298ff][_0xa0c1('0x78')]===_0xa0c1('0x7a')?![]:!![]);_0x275ca6[_0xa0c1('0x67')](_0x48a209,_0x25d1a4[_0x1298ff][_0xa0c1('0x7b')]||_0x48a209);}if(_0x15b0b4['joins']){_0x15b0b4[_0xa0c1('0x7c')]=JSON['parse'](_0x15b0b4[_0xa0c1('0x7c')]);for(var _0x29cdae=0x0;_0x29cdae<_0x15b0b4[_0xa0c1('0x7c')][_0xa0c1('0x39')];_0x29cdae+=0x1){if(_0x15b0b4[_0xa0c1('0x7c')][_0x29cdae][_0xa0c1('0x30')]&&_[_0xa0c1('0x7d')](_0x5ccb8b,_0x15b0b4[_0xa0c1('0x7c')][_0x29cdae][_0xa0c1('0x30')])&&_0x15b0b4[_0xa0c1('0x7c')][_0x29cdae][_0xa0c1('0x7e')]&&_0x15b0b4['joins'][_0x29cdae][_0xa0c1('0x7f')]&&_0x15b0b4['joins'][_0x29cdae]['foreignKey']){_0x275ca6[_0x15b0b4[_0xa0c1('0x7c')][_0x29cdae][_0xa0c1('0x30')]](_0x15b0b4['joins'][_0x29cdae]['foreignTable'],null,util[_0xa0c1('0x76')](_0xa0c1('0x80'),_0x15b0b4[_0xa0c1('0x81')],_0x15b0b4['joins'][_0x29cdae]['parentKey'],_0x15b0b4[_0xa0c1('0x7c')][_0x29cdae][_0xa0c1('0x7f')],_0x15b0b4[_0xa0c1('0x7c')][_0x29cdae][_0xa0c1('0x82')]));}}}if(_0x15b0b4[_0xa0c1('0x83')]){_0x15b0b4[_0xa0c1('0x83')]=JSON[_0xa0c1('0x84')](_0x15b0b4[_0xa0c1('0x83')]);_0x275ca6[_0xa0c1('0x3d')](_0x1b1e21(_0x15b0b4[_0xa0c1('0x83')][_0xa0c1('0x66')]));}_0x511c41=_0x275ca6[_0xa0c1('0x85')]();_0x275ca6[_0xa0c1('0x1e')](_0x63b6ca);_0x275ca6[_0xa0c1('0x1b')](0x0);logger[_0xa0c1('0x86')]('Limited\x20Query:',_0x275ca6[_0xa0c1('0x87')]());return dbH[_0xa0c1('0x88')][_0xa0c1('0x37')](_0x275ca6[_0xa0c1('0x87')](),{'type':dbH[_0xa0c1('0x88')][_0xa0c1('0x89')][_0xa0c1('0x8a')]});}})[_0xa0c1('0x24')](respondWithResult(_0x349ecd,null))[_0xa0c1('0x46')](handleError(_0x349ecd,null));};function runReport(_0x42746f,_0x2fa291,_0x50f9b8){var _0x25b515=_0x2fa291[_0xa0c1('0x2a')];var _0x966ddb=0xa;var _0x3edf22=[_0xa0c1('0x53'),_0xa0c1('0x54'),_0xa0c1('0x55'),_0xa0c1('0x8b')];var _0x5e7066={'SUM':_0xa0c1('0x56'),'COUNT':_0xa0c1('0x57'),'COUNT DISTINCT':_0xa0c1('0x58'),'MAX':_0xa0c1('0x8c'),'MIN':_0xa0c1('0x59'),'AVG':_0xa0c1('0x5a'),'GROUP_CONCAT':_0xa0c1('0x5b'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0xa0c1('0x5d')};var _0x277395={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0xa0c1('0x8d'),'HOUR':_0xa0c1('0x5f'),'ROUND':_0xa0c1('0x60'),'UNIX_TIMESTAMP':_0xa0c1('0x61')};var _0x3fd239=function(_0x382863){return!_['includes']([_0xa0c1('0x8e'),'IS\x20NOT\x20NULL',_0xa0c1('0x62'),_0xa0c1('0x63')],_0x382863);};var _0x17af85=function(_0x531835){if(!_0x531835||!_0x531835[_0xa0c1('0x64')][_0xa0c1('0x39')]){return'';}for(var _0x2adf24='(',_0x128441=0x0;_0x128441<_0x531835[_0xa0c1('0x64')][_0xa0c1('0x39')];_0x128441+=0x1){_0x128441>0x0&&(_0x2adf24+='\x20'+_0x531835[_0xa0c1('0x65')]+'\x20');_0x2adf24+=_0x531835[_0xa0c1('0x64')][_0x128441]['group']?_0x17af85(_0x531835[_0xa0c1('0x64')][_0x128441][_0xa0c1('0x66')]):_0x531835[_0xa0c1('0x64')][_0x128441][_0xa0c1('0x67')]+'\x20'+_0x531835[_0xa0c1('0x64')][_0x128441][_0xa0c1('0x68')]+(_0x3fd239(_0x531835[_0xa0c1('0x64')][_0x128441][_0xa0c1('0x68')])?'\x20'+_0x531835[_0xa0c1('0x64')][_0x128441][_0xa0c1('0x69')]:'');}return _0x2adf24+')';};var _0x5b6f7f={'where':{'id':_0x42746f['id']}},_0x3f8042,_0x5f8c80,_0x4eddbc,_0x38ced3,_0x5cf136;_0x5b6f7f=_[_0xa0c1('0x40')]({},_0x5b6f7f,_0x50f9b8);return db[_0xa0c1('0x2d')][_0xa0c1('0x51')](_0x5b6f7f)[_0xa0c1('0x24')](function(_0x46cc0f){if(_0x46cc0f){_0x3f8042=_0x46cc0f;return _0x46cc0f[_0xa0c1('0x6a')]();}return null;})[_0xa0c1('0x24')](function(_0x4281c9){if(_0x4281c9){if(!_0x4281c9[_0xa0c1('0x39')]){throw new db['Sequelize']['ValidationErrorItem']('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x5f8c80=_0x4281c9;return db[_0xa0c1('0x6e')][_0xa0c1('0x45')]({'raw':!![]});}return null;})[_0xa0c1('0x24')](function(_0x3018fe){if(_0x3018fe){_0x4eddbc=_[_0xa0c1('0x6f')](_0x3018fe,'id');var _0x2d1b38;var _0x176bf8=squel[_0xa0c1('0x70')]();_0x176bf8['from'](_0x3f8042[_0xa0c1('0x81')]);for(var _0x530858=0x0;_0x530858<_0x5f8c80[_0xa0c1('0x39')];_0x530858+=0x1){_0x2d1b38=_0x5f8c80[_0x530858][_0xa0c1('0x72')]?_0x4eddbc[_0x5f8c80[_0x530858][_0xa0c1('0x72')]][_0xa0c1('0x73')]:_0x5f8c80[_0x530858]['field'];_0x2d1b38=_0x5f8c80[_0x530858][_0xa0c1('0x74')]?_[_0xa0c1('0x75')](_0x5e7066[_0x5f8c80[_0x530858][_0xa0c1('0x74')]],'%s',_0x2d1b38):_0x2d1b38;_0x2d1b38=_0x5f8c80[_0x530858]['format']?_[_0xa0c1('0x75')](_0x277395[_0x5f8c80[_0x530858][_0xa0c1('0x76')]],'%s',_0x2d1b38):_0x2d1b38;if(_0x5f8c80[_0x530858][_0xa0c1('0x77')]){_0x176bf8[_0xa0c1('0x66')](_0x2d1b38);}_0x5f8c80[_0x530858][_0xa0c1('0x78')]&&_0x176bf8[_0xa0c1('0x79')](_0x2d1b38,_0x5f8c80[_0x530858][_0xa0c1('0x78')]===_0xa0c1('0x7a')?![]:!![]);_0x176bf8['field'](_0x2d1b38,_0x5f8c80[_0x530858][_0xa0c1('0x7b')]||_0x2d1b38);}if(_0x3f8042[_0xa0c1('0x7c')]){_0x3f8042[_0xa0c1('0x7c')]=JSON[_0xa0c1('0x84')](_0x3f8042[_0xa0c1('0x7c')]);for(var _0x2c8d48=0x0;_0x2c8d48<_0x3f8042[_0xa0c1('0x7c')][_0xa0c1('0x39')];_0x2c8d48+=0x1){if(_0x3f8042[_0xa0c1('0x7c')][_0x2c8d48]['type']&&_[_0xa0c1('0x7d')](_0x3edf22,_0x3f8042[_0xa0c1('0x7c')][_0x2c8d48]['type'])&&_0x3f8042[_0xa0c1('0x7c')][_0x2c8d48]['parentKey']&&_0x3f8042[_0xa0c1('0x7c')][_0x2c8d48][_0xa0c1('0x7f')]&&_0x3f8042[_0xa0c1('0x7c')][_0x2c8d48][_0xa0c1('0x82')]){_0x176bf8[_0x3f8042[_0xa0c1('0x7c')][_0x2c8d48]['type']](_0x3f8042[_0xa0c1('0x7c')][_0x2c8d48][_0xa0c1('0x7f')],null,util[_0xa0c1('0x76')](_0xa0c1('0x80'),_0x3f8042[_0xa0c1('0x81')],_0x3f8042[_0xa0c1('0x7c')][_0x2c8d48][_0xa0c1('0x7e')],_0x3f8042[_0xa0c1('0x7c')][_0x2c8d48][_0xa0c1('0x7f')],_0x3f8042[_0xa0c1('0x7c')][_0x2c8d48]['foreignKey']));}}}if(_0x3f8042[_0xa0c1('0x83')]){_0x3f8042['conditions']=JSON[_0xa0c1('0x84')](_0x3f8042[_0xa0c1('0x83')]);_0x176bf8['where'](_0x17af85(_0x3f8042[_0xa0c1('0x83')][_0xa0c1('0x66')]));}_0x5cf136=_0x176bf8[_0xa0c1('0x85')]();_0x176bf8['limit'](_0x966ddb);_0x176bf8[_0xa0c1('0x1b')](0x0);return;}})['then'](function(){if(_0x2fa291['output']===_0xa0c1('0x8f')){return null;}var _0xa192dc=_[_0xa0c1('0x40')](_0x2fa291,{'name':_0x2fa291[_0xa0c1('0x90')]||_0x2fa291[_0xa0c1('0x2a')]||_0x3f8042[_0xa0c1('0x2a')],'basename':_0x25b515,'savename':util[_0xa0c1('0x76')](_0xa0c1('0x91'),_0x2fa291[_0xa0c1('0x2a')]||_0x3f8042[_0xa0c1('0x2a')],require('randomstring')[_0xa0c1('0x92')](0x4),_0x2fa291[_0xa0c1('0x93')]||_0xa0c1('0x94')),'reportId':_0x3f8042['id'],'reportType':_0xa0c1('0x95')});return db[_0xa0c1('0x96')][_0xa0c1('0x48')](_0xa192dc,{'raw':!![]});})[_0xa0c1('0x24')](function(_0x99524d){if(_0x3f8042[_0xa0c1('0x81')]==='cdr'){_0x5cf136[_0xa0c1('0x3d')](_0x3f8042[_0xa0c1('0x81')]+_0xa0c1('0x97'),_0x2fa291[_0xa0c1('0x98')],_0x2fa291[_0xa0c1('0x99')]);}else{_0x5cf136[_0xa0c1('0x3d')](_0x3f8042[_0xa0c1('0x81')]+_0xa0c1('0x9a'),_0x2fa291[_0xa0c1('0x98')],_0x2fa291[_0xa0c1('0x99')]);}if(_0x99524d){logger[_0xa0c1('0x9b')](_0xa0c1('0x9c'),_0x5cf136[_0xa0c1('0x87')]());require(_0xa0c1('0x9d'))[_0xa0c1('0x9e')](path[_0xa0c1('0x53')](__dirname,_0xa0c1('0x9f'),_0x99524d[_0xa0c1('0x93')]),[_0x99524d['id'],_0x5cf136[_0xa0c1('0x87')](),path[_0xa0c1('0x53')](__dirname,_0xa0c1('0xa0'),_0x99524d[_0xa0c1('0xa1')]),_0x25b515]);return _0x99524d;}else{var _0x26559c=squel['select']();_0x26559c['from']('('+_0x5cf136['toString']()+')',_0xa0c1('0xa2'));_0x26559c[_0xa0c1('0x67')]('COUNT(*)',_0xa0c1('0x1d'));_0x5cf136[_0xa0c1('0x1e')](_0x2fa291[_0xa0c1('0x1e')]||_0x966ddb);_0x5cf136[_0xa0c1('0x1b')](_0x2fa291['offset']||0x0);return dbH[_0xa0c1('0x88')]['query'](_0x26559c[_0xa0c1('0x87')](),{'type':dbH[_0xa0c1('0x88')][_0xa0c1('0x89')][_0xa0c1('0x8a')]})[_0xa0c1('0x24')](function(_0xc8d979){if(!_0xc8d979[_0xa0c1('0x39')]){_0x38ced3=0x0;}else{_0x38ced3=_0xc8d979[0x0]['count']||0x0;}return dbH[_0xa0c1('0x88')][_0xa0c1('0x37')](_0x5cf136[_0xa0c1('0x87')](),{'type':dbH[_0xa0c1('0x88')][_0xa0c1('0x89')][_0xa0c1('0x8a')]});})['then'](function(_0x2abf2c){return{'rows':_0x2abf2c||[],'count':_0x38ced3};});}});}exports['run']=function(_0x17e96c,_0x4bd848){return runReport(_0x17e96c[_0xa0c1('0x52')],_0x17e96c['query'],_0x17e96c[_0xa0c1('0x42')])[_0xa0c1('0x24')](respondWithResult(_0x4bd848,null))['catch'](handleError(_0x4bd848,null));};exports[_0xa0c1('0xa3')]=runReport;exports[_0xa0c1('0x37')]=function(_0x74a8fb,_0x484368){var _0x3e0fc5=0xa;var _0x43c3c8=[_0xa0c1('0x53'),'left_join','right_join',_0xa0c1('0x8b')];var _0x3455b6={'SUM':_0xa0c1('0x56'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0xa0c1('0x58'),'MAX':_0xa0c1('0x8c'),'MIN':_0xa0c1('0x59'),'AVG':_0xa0c1('0x5a'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0xa0c1('0x5c'),'GROUP_CONCAT DESC':_0xa0c1('0x5d')};var _0x40bffe={'SEC_TO_TIME':_0xa0c1('0x5e'),'DATE':_0xa0c1('0x8d'),'HOUR':'HOUR(%s)','ROUND':_0xa0c1('0x60'),'UNIX_TIMESTAMP':_0xa0c1('0x61')};var _0x37b2ca=function(_0x1857af){return!_['includes']([_0xa0c1('0x8e'),_0xa0c1('0xa4'),_0xa0c1('0x62'),_0xa0c1('0x63')],_0x1857af);};var _0x18726f=function(_0x348e11){if(!_0x348e11||!_0x348e11['rules'][_0xa0c1('0x39')]){return'';}for(var _0x349ad4='(',_0x30fca3=0x0;_0x30fca3<_0x348e11['rules'][_0xa0c1('0x39')];_0x30fca3+=0x1){_0x30fca3>0x0&&(_0x349ad4+='\x20'+_0x348e11[_0xa0c1('0x65')]+'\x20');_0x349ad4+=_0x348e11[_0xa0c1('0x64')][_0x30fca3][_0xa0c1('0x66')]?_0x18726f(_0x348e11[_0xa0c1('0x64')][_0x30fca3][_0xa0c1('0x66')]):_0x348e11['rules'][_0x30fca3][_0xa0c1('0x67')]+'\x20'+_0x348e11[_0xa0c1('0x64')][_0x30fca3]['condition']+(_0x37b2ca(_0x348e11[_0xa0c1('0x64')][_0x30fca3][_0xa0c1('0x68')])?'\x20'+_0x348e11[_0xa0c1('0x64')][_0x30fca3]['value']:'');}return _0x349ad4+')';};var _0x36894e={'where':{'id':_0x74a8fb[_0xa0c1('0x52')]['id']}},_0x528b68,_0x2beb64,_0x1793e1,_0x37024e,_0x1ebcf6;_0x36894e=_[_0xa0c1('0x40')]({},_0x36894e,_0x74a8fb[_0xa0c1('0x42')]);return db[_0xa0c1('0x2d')][_0xa0c1('0x51')](_0x36894e)['then'](function(_0x2326a7){if(_0x2326a7){_0x528b68=_0x2326a7;return _0x2326a7[_0xa0c1('0x6a')]();}return null;})['then'](function(_0x3b4c05){if(_0x3b4c05){if(!_0x3b4c05[_0xa0c1('0x39')]){throw new db[(_0xa0c1('0x6b'))][(_0xa0c1('0x6c'))](_0xa0c1('0x6d'),0x193);}_0x2beb64=_0x3b4c05;return db[_0xa0c1('0x6e')][_0xa0c1('0x45')]({'raw':!![]});}return null;})[_0xa0c1('0x24')](function(_0x3bffe1){if(_0x3bffe1){_0x1793e1=_[_0xa0c1('0x6f')](_0x3bffe1,'id');var _0x4200be;var _0x55d60a=squel[_0xa0c1('0x70')]();_0x55d60a[_0xa0c1('0x71')](_0x528b68['table']);for(var _0xb0392f=0x0;_0xb0392f<_0x2beb64[_0xa0c1('0x39')];_0xb0392f+=0x1){_0x4200be=_0x2beb64[_0xb0392f][_0xa0c1('0x72')]?_0x1793e1[_0x2beb64[_0xb0392f]['MetricId']][_0xa0c1('0x73')]:_0x2beb64[_0xb0392f][_0xa0c1('0x67')];_0x4200be=_0x2beb64[_0xb0392f]['function']?_[_0xa0c1('0x75')](_0x3455b6[_0x2beb64[_0xb0392f][_0xa0c1('0x74')]],'%s',_0x4200be):_0x4200be;_0x4200be=_0x2beb64[_0xb0392f][_0xa0c1('0x76')]?_[_0xa0c1('0x75')](_0x40bffe[_0x2beb64[_0xb0392f][_0xa0c1('0x76')]],'%s',_0x4200be):_0x4200be;if(_0x2beb64[_0xb0392f][_0xa0c1('0x77')]){_0x55d60a['group'](_0x4200be);}_0x2beb64[_0xb0392f][_0xa0c1('0x78')]&&_0x55d60a[_0xa0c1('0x79')](_0x4200be,_0x2beb64[_0xb0392f][_0xa0c1('0x78')]==='DESC'?![]:!![]);_0x55d60a[_0xa0c1('0x67')](_0x4200be,_0x2beb64[_0xb0392f]['alias']||_0x4200be);}if(_0x528b68[_0xa0c1('0x7c')]){_0x528b68[_0xa0c1('0x7c')]=JSON[_0xa0c1('0x84')](_0x528b68[_0xa0c1('0x7c')]);for(var _0x5027a2=0x0;_0x5027a2<_0x528b68['joins'][_0xa0c1('0x39')];_0x5027a2+=0x1){if(_0x528b68[_0xa0c1('0x7c')][_0x5027a2]['type']&&_[_0xa0c1('0x7d')](_0x43c3c8,_0x528b68[_0xa0c1('0x7c')][_0x5027a2][_0xa0c1('0x30')])&&_0x528b68['joins'][_0x5027a2][_0xa0c1('0x7e')]&&_0x528b68[_0xa0c1('0x7c')][_0x5027a2][_0xa0c1('0x7f')]&&_0x528b68['joins'][_0x5027a2][_0xa0c1('0x82')]){_0x55d60a[_0x528b68[_0xa0c1('0x7c')][_0x5027a2][_0xa0c1('0x30')]](_0x528b68[_0xa0c1('0x7c')][_0x5027a2][_0xa0c1('0x7f')],null,util['format']('%s.%s\x20=\x20%s.%s',_0x528b68[_0xa0c1('0x81')],_0x528b68[_0xa0c1('0x7c')][_0x5027a2][_0xa0c1('0x7e')],_0x528b68[_0xa0c1('0x7c')][_0x5027a2]['foreignTable'],_0x528b68['joins'][_0x5027a2]['foreignKey']));}}}if(_0x528b68[_0xa0c1('0x83')]){_0x528b68[_0xa0c1('0x83')]=JSON['parse'](_0x528b68[_0xa0c1('0x83')]);_0x55d60a[_0xa0c1('0x3d')](_0x18726f(_0x528b68[_0xa0c1('0x83')][_0xa0c1('0x66')]));}_0x1ebcf6=_0x55d60a[_0xa0c1('0x85')]();_0x55d60a[_0xa0c1('0x1e')](_0x3e0fc5);_0x55d60a[_0xa0c1('0x1b')](0x0);logger['debug'](_0xa0c1('0xa5'),_0x55d60a[_0xa0c1('0x87')]());return dbH[_0xa0c1('0x88')]['query'](_0x55d60a['toString'](),{'type':dbH['sequelize'][_0xa0c1('0x89')]['SELECT']});}})[_0xa0c1('0x24')](function(){return{'sql':_0x1ebcf6['toString']()};})[_0xa0c1('0x24')](respondWithResult(_0x484368,null))[_0xa0c1('0x46')](handleError(_0x484368,null));};
git://repos.xcallymotion.com / motion2.git / blob