// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x78bd=['from','eml-format','rimraf','zip-dir','moment','bluebird','mustache','util','sox','ejs','lodash','crypto','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/license/util','../../mysqldb','dbH','sendStatus','status','end','json','offset','limit','undefined','count','set','apply','reject','then','destroy','get','CustomReports','UserProfileResource','error','stack','name','send','index','AnalyticCustomReport','rawAttributes','key','map','keys','query','intersection','attributes','fields','length','model','nolimit','order','where','filters','pick','type','VIRTUAL','merge','options','includeAll','include','findAll','catch','show','params','find','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','Reports','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','preview','join','left_join','cross_join','COUNT(%s)','COUNT(DISTINCT\x20%s)','MIN(%s)','GROUP_CONCAT(%s)','DATE(%s)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','value','Sequelize','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','select','MetricId','metric','function','replace','format','orderBy','alias','joins','parse','parentKey','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','table','conditions','clone','debug','Limited\x20Query:','toString','sequelize','SELECT','right_join','SUM(%s)','MAX(%s)','AVG(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','ValidationErrorItem','groupBy','DESC','output','fullPath','%s-%s.%s','randomstring','csv','custom','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','Run\x20Query:','child_process','fork','../../components/export/','../../files/reports','savename','countTable','COUNT(*)','QueryTypes','runReport','getFields'];(function(_0x1d1727,_0x3bf08b){var _0x1f6d13=function(_0x430941){while(--_0x430941){_0x1d1727['push'](_0x1d1727['shift']());}};_0x1f6d13(++_0x3bf08b);}(_0x78bd,0x1f0));var _0xd78b=function(_0x490be3,_0xf0fca3){_0x490be3=_0x490be3-0x0;var _0x3f5140=_0x78bd[_0x490be3];return _0x3f5140;};'use strict';var emlformat=require(_0xd78b('0x0'));var rimraf=require(_0xd78b('0x1'));var zipdir=require(_0xd78b('0x2'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0xd78b('0x3'));var BPromise=require(_0xd78b('0x4'));var Mustache=require(_0xd78b('0x5'));var util=require(_0xd78b('0x6'));var path=require('path');var sox=require(_0xd78b('0x7'));var csv=require('to-csv');var ejs=require(_0xd78b('0x8'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xd78b('0x9'));var squel=require('squel');var crypto=require(_0xd78b('0xa'));var jsforce=require(_0xd78b('0xb'));var deskjs=require(_0xd78b('0xc'));var toCsv=require(_0xd78b('0xd'));var querystring=require(_0xd78b('0xe'));var Papa=require(_0xd78b('0xf'));var Redis=require(_0xd78b('0x10'));var authService=require(_0xd78b('0x11'));var qs=require(_0xd78b('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0xd78b('0x13'))(_0xd78b('0x14'));var utils=require(_0xd78b('0x15'));var config=require('../../config/environment');var licenseUtil=require(_0xd78b('0x16'));var db=require(_0xd78b('0x17'))['db'];var dbH=require(_0xd78b('0x17'))[_0xd78b('0x18')];function respondWithStatusCode(_0x27cc76,_0x5eabac){_0x5eabac=_0x5eabac||0xcc;return function(_0x33610f){if(_0x33610f){return _0x27cc76[_0xd78b('0x19')](_0x5eabac);}return _0x27cc76[_0xd78b('0x1a')](_0x5eabac)[_0xd78b('0x1b')]();};}function respondWithResult(_0x2a783a,_0x2f36a7){_0x2f36a7=_0x2f36a7||0xc8;return function(_0x168df1){if(_0x168df1){return _0x2a783a['status'](_0x2f36a7)[_0xd78b('0x1c')](_0x168df1);}};}function respondWithFilteredResult(_0x57395b,_0xfdc037){return function(_0x4da9fa){if(_0x4da9fa){var _0x2a7e10=typeof _0xfdc037[_0xd78b('0x1d')]==='undefined'&&typeof _0xfdc037[_0xd78b('0x1e')]===_0xd78b('0x1f');var _0x8879fe=_0x4da9fa[_0xd78b('0x20')];var _0x66f6d0=_0x2a7e10?0x0:_0xfdc037[_0xd78b('0x1d')];var _0x4c5f8b=_0x2a7e10?_0x4da9fa['count']:_0xfdc037[_0xd78b('0x1d')]+_0xfdc037['limit'];var _0x43968f;if(_0x4c5f8b>=_0x8879fe){_0x4c5f8b=_0x8879fe;_0x43968f=0xc8;}else{_0x43968f=0xce;}_0x57395b[_0xd78b('0x1a')](_0x43968f);return _0x57395b[_0xd78b('0x21')]('Content-Range',_0x66f6d0+'-'+_0x4c5f8b+'/'+_0x8879fe)['json'](_0x4da9fa);}return null;};}function patchUpdates(_0x14e5ab){return function(_0x11b6a2){try{jsonpatch[_0xd78b('0x22')](_0x11b6a2,_0x14e5ab,!![]);}catch(_0x1b4c10){return BPromise[_0xd78b('0x23')](_0x1b4c10);}return _0x11b6a2['save']();};}function saveUpdates(_0x16bfbc,_0x27c21a){return function(_0x1b093d){if(_0x1b093d){return _0x1b093d['update'](_0x16bfbc)[_0xd78b('0x24')](function(_0x2054b3){return _0x2054b3;});}return null;};}function removeEntity(_0x332b5e,_0x3b435a){return function(_0x46a6ab){if(_0x46a6ab){return _0x46a6ab[_0xd78b('0x25')]()[_0xd78b('0x24')](function(){var _0x59e9cf=_0x46a6ab[_0xd78b('0x26')]({'plain':!![]});var _0x3649e7=_0xd78b('0x27');return db[_0xd78b('0x28')][_0xd78b('0x25')]({'where':{'type':_0x3649e7,'resourceId':_0x59e9cf['id']}})[_0xd78b('0x24')](function(){return _0x46a6ab;});})[_0xd78b('0x24')](function(){_0x332b5e['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x397dc6,_0x39bdf5){return function(_0x1f411a){if(!_0x1f411a){_0x397dc6[_0xd78b('0x19')](0x194);}return _0x1f411a;};}function handleError(_0x20ae4b,_0x4e90d9){_0x4e90d9=_0x4e90d9||0x1f4;return function(_0x2a9d4c){logger[_0xd78b('0x29')](_0x2a9d4c[_0xd78b('0x2a')]);if(_0x2a9d4c[_0xd78b('0x2b')]){delete _0x2a9d4c[_0xd78b('0x2b')];}_0x20ae4b['status'](_0x4e90d9)[_0xd78b('0x2c')](_0x2a9d4c);};}exports[_0xd78b('0x2d')]=function(_0x2ddb0d,_0x37afe1){var _0x1f7555={},_0x17db8b={},_0x2d7eb5={'count':0x0,'rows':[]};var _0x87c72=_['map'](db[_0xd78b('0x2e')][_0xd78b('0x2f')],function(_0x3f02cb){return{'name':_0x3f02cb['fieldName'],'type':_0x3f02cb['type'][_0xd78b('0x30')]};});_0x17db8b['model']=_[_0xd78b('0x31')](_0x87c72,_0xd78b('0x2b'));_0x17db8b['query']=_[_0xd78b('0x32')](_0x2ddb0d[_0xd78b('0x33')]);_0x17db8b['filters']=_[_0xd78b('0x34')](_0x17db8b['model'],_0x17db8b[_0xd78b('0x33')]);_0x1f7555[_0xd78b('0x35')]=_[_0xd78b('0x34')](_0x17db8b['model'],qs[_0xd78b('0x36')](_0x2ddb0d[_0xd78b('0x33')][_0xd78b('0x36')]));_0x1f7555[_0xd78b('0x35')]=_0x1f7555[_0xd78b('0x35')][_0xd78b('0x37')]?_0x1f7555[_0xd78b('0x35')]:_0x17db8b[_0xd78b('0x38')];if(!_0x2ddb0d[_0xd78b('0x33')]['hasOwnProperty'](_0xd78b('0x39'))){_0x1f7555[_0xd78b('0x1e')]=qs['limit'](_0x2ddb0d['query'][_0xd78b('0x1e')]);_0x1f7555['offset']=qs[_0xd78b('0x1d')](_0x2ddb0d[_0xd78b('0x33')][_0xd78b('0x1d')]);}_0x1f7555[_0xd78b('0x3a')]=qs['sort'](_0x2ddb0d[_0xd78b('0x33')]['sort']);_0x1f7555[_0xd78b('0x3b')]=qs[_0xd78b('0x3c')](_[_0xd78b('0x3d')](_0x2ddb0d[_0xd78b('0x33')],_0x17db8b[_0xd78b('0x3c')]),_0x87c72);if(_0x2ddb0d[_0xd78b('0x33')]['filter']){_0x1f7555['where']=_['merge'](_0x1f7555['where'],{'$or':_['map'](_0x87c72,function(_0x4c8f96){if(_0x4c8f96[_0xd78b('0x3e')]!==_0xd78b('0x3f')){var _0x1be7ed={};_0x1be7ed[_0x4c8f96[_0xd78b('0x2b')]]={'$like':'%'+_0x2ddb0d[_0xd78b('0x33')]['filter']+'%'};return _0x1be7ed;}})});}_0x1f7555=_[_0xd78b('0x40')]({},_0x1f7555,_0x2ddb0d[_0xd78b('0x41')]);var _0x545ba7={'where':_0x1f7555[_0xd78b('0x3b')]};return db[_0xd78b('0x2e')][_0xd78b('0x20')](_0x545ba7)['then'](function(_0x163f7e){_0x2d7eb5[_0xd78b('0x20')]=_0x163f7e;if(_0x2ddb0d['query'][_0xd78b('0x42')]){_0x1f7555[_0xd78b('0x43')]=[{'all':!![]}];}return db['AnalyticCustomReport'][_0xd78b('0x44')](_0x1f7555);})['then'](function(_0x3806c1){_0x2d7eb5['rows']=_0x3806c1;return _0x2d7eb5;})[_0xd78b('0x24')](respondWithFilteredResult(_0x37afe1,_0x1f7555))[_0xd78b('0x45')](handleError(_0x37afe1,null));};exports[_0xd78b('0x46')]=function(_0x238a87,_0x51a963){var _0x10cbf1={'raw':![],'where':{'id':_0x238a87[_0xd78b('0x47')]['id']}},_0x1b6637={};_0x1b6637[_0xd78b('0x38')]=_[_0xd78b('0x32')](db[_0xd78b('0x2e')][_0xd78b('0x2f')]);_0x1b6637[_0xd78b('0x33')]=_[_0xd78b('0x32')](_0x238a87[_0xd78b('0x33')]);_0x1b6637[_0xd78b('0x3c')]=_[_0xd78b('0x34')](_0x1b6637[_0xd78b('0x38')],_0x1b6637['query']);_0x10cbf1[_0xd78b('0x35')]=_[_0xd78b('0x34')](_0x1b6637['model'],qs[_0xd78b('0x36')](_0x238a87[_0xd78b('0x33')]['fields']));_0x10cbf1[_0xd78b('0x35')]=_0x10cbf1[_0xd78b('0x35')]['length']?_0x10cbf1[_0xd78b('0x35')]:_0x1b6637['model'];if(_0x238a87[_0xd78b('0x33')]['includeAll']){_0x10cbf1[_0xd78b('0x43')]=[{'all':!![]}];}_0x10cbf1=_['merge']({},_0x10cbf1,_0x238a87[_0xd78b('0x41')]);return db['AnalyticCustomReport'][_0xd78b('0x48')](_0x10cbf1)[_0xd78b('0x24')](handleEntityNotFound(_0x51a963,null))[_0xd78b('0x24')](respondWithResult(_0x51a963,null))['catch'](handleError(_0x51a963,null));};exports[_0xd78b('0x49')]=function(_0x60f39f,_0x4c1468){return db['AnalyticCustomReport'][_0xd78b('0x49')](_0x60f39f[_0xd78b('0x4a')],{})[_0xd78b('0x24')](function(_0x243784){var _0x25df36=_0x60f39f['user'][_0xd78b('0x26')]({'plain':!![]});if(!_0x25df36)throw new Error(_0xd78b('0x4b'));if(_0x25df36[_0xd78b('0x4c')]===_0xd78b('0x4d')){var _0x312366=_0x243784[_0xd78b('0x26')]({'plain':!![]});var _0x13a1b3=_0xd78b('0x4e');return db[_0xd78b('0x4f')][_0xd78b('0x48')]({'where':{'name':_0x13a1b3,'userProfileId':_0x25df36[_0xd78b('0x50')]},'raw':!![]})[_0xd78b('0x24')](function(_0x5d6503){if(_0x5d6503&&_0x5d6503[_0xd78b('0x51')]===0x0){return db[_0xd78b('0x28')][_0xd78b('0x49')]({'name':_0x312366[_0xd78b('0x2b')],'resourceId':_0x312366['id'],'type':_0xd78b('0x27'),'sectionId':_0x5d6503['id']},{})['then'](function(){return _0x243784;});}else{return _0x243784;}})[_0xd78b('0x45')](function(_0x189de8){logger[_0xd78b('0x29')](_0xd78b('0x52'),_0x189de8);throw _0x189de8;});}return _0x243784;})[_0xd78b('0x24')](respondWithResult(_0x4c1468,0xc9))[_0xd78b('0x45')](handleError(_0x4c1468,null));};exports['update']=function(_0x3a269a,_0x4200f4){if(_0x3a269a[_0xd78b('0x4a')]['id']){delete _0x3a269a[_0xd78b('0x4a')]['id'];}return db[_0xd78b('0x2e')][_0xd78b('0x48')]({'where':{'id':_0x3a269a[_0xd78b('0x47')]['id']}})['then'](handleEntityNotFound(_0x4200f4,null))['then'](saveUpdates(_0x3a269a['body'],null))['then'](respondWithResult(_0x4200f4,null))[_0xd78b('0x45')](handleError(_0x4200f4,null));};exports[_0xd78b('0x25')]=function(_0x35fbc,_0x5c3109){return db['AnalyticCustomReport']['find']({'where':{'id':_0x35fbc[_0xd78b('0x47')]['id']}})[_0xd78b('0x24')](handleEntityNotFound(_0x5c3109,null))['then'](removeEntity(_0x5c3109,null))[_0xd78b('0x45')](handleError(_0x5c3109,null));};exports[_0xd78b('0x53')]=function(_0x307a05,_0xf7ad56){var _0xb87fe4=0xa;var _0xf383ed=[_0xd78b('0x54'),_0xd78b('0x55'),'right_join',_0xd78b('0x56')];var _0x5b46fa={'SUM':'SUM(%s)','COUNT':_0xd78b('0x57'),'COUNT DISTINCT':_0xd78b('0x58'),'MAX':'MAX(%s)','MIN':_0xd78b('0x59'),'AVG':'AVG(%s)','GROUP_CONCAT':_0xd78b('0x5a'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0xbee3db={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0xd78b('0x5b'),'HOUR':_0xd78b('0x5c'),'ROUND':_0xd78b('0x5d'),'UNIX_TIMESTAMP':_0xd78b('0x5e')};var _0x1c6ff4=function(_0x66bf4e){return!_[_0xd78b('0x5f')]([_0xd78b('0x60'),_0xd78b('0x61'),_0xd78b('0x62'),_0xd78b('0x63')],_0x66bf4e);};var _0x195e18=function(_0x11e4b0){if(!_0x11e4b0||!_0x11e4b0[_0xd78b('0x64')]['length']){return'';}for(var _0x277364='(',_0x1dafcb=0x0;_0x1dafcb<_0x11e4b0[_0xd78b('0x64')][_0xd78b('0x37')];_0x1dafcb+=0x1){_0x1dafcb>0x0&&(_0x277364+='\x20'+_0x11e4b0[_0xd78b('0x65')]+'\x20');_0x277364+=_0x11e4b0[_0xd78b('0x64')][_0x1dafcb][_0xd78b('0x66')]?_0x195e18(_0x11e4b0['rules'][_0x1dafcb][_0xd78b('0x66')]):_0x11e4b0[_0xd78b('0x64')][_0x1dafcb][_0xd78b('0x67')]+'\x20'+_0x11e4b0[_0xd78b('0x64')][_0x1dafcb][_0xd78b('0x68')]+(_0x1c6ff4(_0x11e4b0['rules'][_0x1dafcb][_0xd78b('0x68')])?'\x20'+_0x11e4b0[_0xd78b('0x64')][_0x1dafcb][_0xd78b('0x69')]:'');}return _0x277364+')';};var _0x46f8ce={'where':{'id':_0x307a05[_0xd78b('0x47')]['id']}},_0x2c5346,_0x3cee3c,_0x54fe4d,_0x1b6e51,_0x51e8de;_0x46f8ce=_[_0xd78b('0x40')]({},_0x46f8ce,_0x307a05[_0xd78b('0x41')]);return db[_0xd78b('0x2e')][_0xd78b('0x48')](_0x46f8ce)[_0xd78b('0x24')](function(_0x51eaf1){if(_0x51eaf1){_0x2c5346=_0x51eaf1;return _0x51eaf1['getFields']();}return null;})[_0xd78b('0x24')](function(_0x17bb7a){if(_0x17bb7a){if(!_0x17bb7a[_0xd78b('0x37')]){throw new db[(_0xd78b('0x6a'))]['ValidationErrorItem'](_0xd78b('0x6b'),0x193);}_0x3cee3c=_0x17bb7a;return db[_0xd78b('0x6c')]['findAll']({'raw':!![]});}return null;})['then'](function(_0x3afe25){if(_0x3afe25){_0x54fe4d=_[_0xd78b('0x6d')](_0x3afe25,'id');var _0x2d69ab;var _0xb000c6=squel[_0xd78b('0x6e')]();_0xb000c6['from'](_0x2c5346['table']);for(var _0x265553=0x0;_0x265553<_0x3cee3c[_0xd78b('0x37')];_0x265553+=0x1){_0x2d69ab=_0x3cee3c[_0x265553][_0xd78b('0x6f')]?_0x54fe4d[_0x3cee3c[_0x265553][_0xd78b('0x6f')]][_0xd78b('0x70')]:_0x3cee3c[_0x265553][_0xd78b('0x67')];_0x2d69ab=_0x3cee3c[_0x265553][_0xd78b('0x71')]?_[_0xd78b('0x72')](_0x5b46fa[_0x3cee3c[_0x265553][_0xd78b('0x71')]],'%s',_0x2d69ab):_0x2d69ab;_0x2d69ab=_0x3cee3c[_0x265553][_0xd78b('0x73')]?_[_0xd78b('0x72')](_0xbee3db[_0x3cee3c[_0x265553]['format']],'%s',_0x2d69ab):_0x2d69ab;if(_0x3cee3c[_0x265553]['groupBy']){_0xb000c6[_0xd78b('0x66')](_0x2d69ab);}_0x3cee3c[_0x265553][_0xd78b('0x74')]&&_0xb000c6['order'](_0x2d69ab,_0x3cee3c[_0x265553][_0xd78b('0x74')]==='DESC'?![]:!![]);_0xb000c6[_0xd78b('0x67')](_0x2d69ab,_0x3cee3c[_0x265553][_0xd78b('0x75')]||_0x2d69ab);}if(_0x2c5346[_0xd78b('0x76')]){_0x2c5346[_0xd78b('0x76')]=JSON[_0xd78b('0x77')](_0x2c5346[_0xd78b('0x76')]);for(var _0xb8a651=0x0;_0xb8a651<_0x2c5346['joins']['length'];_0xb8a651+=0x1){if(_0x2c5346[_0xd78b('0x76')][_0xb8a651][_0xd78b('0x3e')]&&_[_0xd78b('0x5f')](_0xf383ed,_0x2c5346[_0xd78b('0x76')][_0xb8a651][_0xd78b('0x3e')])&&_0x2c5346['joins'][_0xb8a651][_0xd78b('0x78')]&&_0x2c5346['joins'][_0xb8a651][_0xd78b('0x79')]&&_0x2c5346[_0xd78b('0x76')][_0xb8a651][_0xd78b('0x7a')]){_0xb000c6[_0x2c5346[_0xd78b('0x76')][_0xb8a651][_0xd78b('0x3e')]](_0x2c5346[_0xd78b('0x76')][_0xb8a651][_0xd78b('0x79')],null,util[_0xd78b('0x73')](_0xd78b('0x7b'),_0x2c5346[_0xd78b('0x7c')],_0x2c5346[_0xd78b('0x76')][_0xb8a651][_0xd78b('0x78')],_0x2c5346[_0xd78b('0x76')][_0xb8a651][_0xd78b('0x79')],_0x2c5346[_0xd78b('0x76')][_0xb8a651][_0xd78b('0x7a')]));}}}if(_0x2c5346[_0xd78b('0x7d')]){_0x2c5346['conditions']=JSON[_0xd78b('0x77')](_0x2c5346[_0xd78b('0x7d')]);_0xb000c6['where'](_0x195e18(_0x2c5346[_0xd78b('0x7d')][_0xd78b('0x66')]));}_0x51e8de=_0xb000c6[_0xd78b('0x7e')]();_0xb000c6[_0xd78b('0x1e')](_0xb87fe4);_0xb000c6[_0xd78b('0x1d')](0x0);logger[_0xd78b('0x7f')](_0xd78b('0x80'),_0xb000c6[_0xd78b('0x81')]());return dbH[_0xd78b('0x82')][_0xd78b('0x33')](_0xb000c6[_0xd78b('0x81')](),{'type':dbH['sequelize']['QueryTypes'][_0xd78b('0x83')]});}})[_0xd78b('0x24')](respondWithResult(_0xf7ad56,null))[_0xd78b('0x45')](handleError(_0xf7ad56,null));};function runReport(_0x232f8f,_0x3ffac6,_0x4ee224){var _0x37bbc9=_0x3ffac6['name'];var _0x1260a3=0xa;var _0x33c6d3=['join',_0xd78b('0x55'),_0xd78b('0x84'),'cross_join'];var _0x1e1100={'SUM':_0xd78b('0x85'),'COUNT':_0xd78b('0x57'),'COUNT DISTINCT':_0xd78b('0x58'),'MAX':_0xd78b('0x86'),'MIN':'MIN(%s)','AVG':_0xd78b('0x87'),'GROUP_CONCAT':_0xd78b('0x5a'),'GROUP_CONCAT ASC':_0xd78b('0x88'),'GROUP_CONCAT DESC':_0xd78b('0x89')};var _0x2dc1c4={'SEC_TO_TIME':_0xd78b('0x8a'),'DATE':_0xd78b('0x5b'),'HOUR':'HOUR(%s)','ROUND':_0xd78b('0x5d'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x32a867=function(_0x3577fb){return!_[_0xd78b('0x5f')]([_0xd78b('0x60'),_0xd78b('0x61'),_0xd78b('0x62'),_0xd78b('0x63')],_0x3577fb);};var _0x1e8d98=function(_0x1cc3ec){if(!_0x1cc3ec||!_0x1cc3ec[_0xd78b('0x64')]['length']){return'';}for(var _0x19490e='(',_0x598b20=0x0;_0x598b20<_0x1cc3ec['rules']['length'];_0x598b20+=0x1){_0x598b20>0x0&&(_0x19490e+='\x20'+_0x1cc3ec[_0xd78b('0x65')]+'\x20');_0x19490e+=_0x1cc3ec['rules'][_0x598b20]['group']?_0x1e8d98(_0x1cc3ec['rules'][_0x598b20][_0xd78b('0x66')]):_0x1cc3ec[_0xd78b('0x64')][_0x598b20][_0xd78b('0x67')]+'\x20'+_0x1cc3ec[_0xd78b('0x64')][_0x598b20][_0xd78b('0x68')]+(_0x32a867(_0x1cc3ec[_0xd78b('0x64')][_0x598b20]['condition'])?'\x20'+_0x1cc3ec['rules'][_0x598b20][_0xd78b('0x69')]:'');}return _0x19490e+')';};var _0x4cb086={'where':{'id':_0x232f8f['id']}},_0x17408d,_0x44855b,_0x5a44f2,_0x257c14,_0x39dd13;_0x4cb086=_[_0xd78b('0x40')]({},_0x4cb086,_0x4ee224);return db[_0xd78b('0x2e')][_0xd78b('0x48')](_0x4cb086)['then'](function(_0x392637){if(_0x392637){_0x17408d=_0x392637;return _0x392637['getFields']();}return null;})[_0xd78b('0x24')](function(_0x2d8cbd){if(_0x2d8cbd){if(!_0x2d8cbd[_0xd78b('0x37')]){throw new db['Sequelize'][(_0xd78b('0x8b'))](_0xd78b('0x6b'),0x193);}_0x44855b=_0x2d8cbd;return db[_0xd78b('0x6c')][_0xd78b('0x44')]({'raw':!![]});}return null;})[_0xd78b('0x24')](function(_0x72089d){if(_0x72089d){_0x5a44f2=_[_0xd78b('0x6d')](_0x72089d,'id');var _0x398021;var _0x5319e5=squel[_0xd78b('0x6e')]();_0x5319e5['from'](_0x17408d[_0xd78b('0x7c')]);for(var _0x19de12=0x0;_0x19de12<_0x44855b['length'];_0x19de12+=0x1){_0x398021=_0x44855b[_0x19de12][_0xd78b('0x6f')]?_0x5a44f2[_0x44855b[_0x19de12][_0xd78b('0x6f')]][_0xd78b('0x70')]:_0x44855b[_0x19de12][_0xd78b('0x67')];_0x398021=_0x44855b[_0x19de12][_0xd78b('0x71')]?_[_0xd78b('0x72')](_0x1e1100[_0x44855b[_0x19de12][_0xd78b('0x71')]],'%s',_0x398021):_0x398021;_0x398021=_0x44855b[_0x19de12][_0xd78b('0x73')]?_['replace'](_0x2dc1c4[_0x44855b[_0x19de12][_0xd78b('0x73')]],'%s',_0x398021):_0x398021;if(_0x44855b[_0x19de12][_0xd78b('0x8c')]){_0x5319e5[_0xd78b('0x66')](_0x398021);}_0x44855b[_0x19de12][_0xd78b('0x74')]&&_0x5319e5[_0xd78b('0x3a')](_0x398021,_0x44855b[_0x19de12][_0xd78b('0x74')]===_0xd78b('0x8d')?![]:!![]);_0x5319e5['field'](_0x398021,_0x44855b[_0x19de12][_0xd78b('0x75')]||_0x398021);}if(_0x17408d[_0xd78b('0x76')]){_0x17408d[_0xd78b('0x76')]=JSON[_0xd78b('0x77')](_0x17408d[_0xd78b('0x76')]);for(var _0x34568c=0x0;_0x34568c<_0x17408d[_0xd78b('0x76')][_0xd78b('0x37')];_0x34568c+=0x1){if(_0x17408d[_0xd78b('0x76')][_0x34568c]['type']&&_[_0xd78b('0x5f')](_0x33c6d3,_0x17408d[_0xd78b('0x76')][_0x34568c][_0xd78b('0x3e')])&&_0x17408d[_0xd78b('0x76')][_0x34568c][_0xd78b('0x78')]&&_0x17408d[_0xd78b('0x76')][_0x34568c][_0xd78b('0x79')]&&_0x17408d[_0xd78b('0x76')][_0x34568c][_0xd78b('0x7a')]){_0x5319e5[_0x17408d['joins'][_0x34568c][_0xd78b('0x3e')]](_0x17408d[_0xd78b('0x76')][_0x34568c][_0xd78b('0x79')],null,util[_0xd78b('0x73')]('%s.%s\x20=\x20%s.%s',_0x17408d[_0xd78b('0x7c')],_0x17408d[_0xd78b('0x76')][_0x34568c][_0xd78b('0x78')],_0x17408d[_0xd78b('0x76')][_0x34568c][_0xd78b('0x79')],_0x17408d['joins'][_0x34568c]['foreignKey']));}}}if(_0x17408d[_0xd78b('0x7d')]){_0x17408d['conditions']=JSON[_0xd78b('0x77')](_0x17408d[_0xd78b('0x7d')]);_0x5319e5[_0xd78b('0x3b')](_0x1e8d98(_0x17408d['conditions']['group']));}_0x39dd13=_0x5319e5['clone']();_0x5319e5[_0xd78b('0x1e')](_0x1260a3);_0x5319e5[_0xd78b('0x1d')](0x0);return;}})['then'](function(){if(_0x3ffac6[_0xd78b('0x8e')]==='web'){return null;}var _0x5650cf=_[_0xd78b('0x40')](_0x3ffac6,{'name':_0x3ffac6[_0xd78b('0x8f')]||_0x3ffac6[_0xd78b('0x2b')]||_0x17408d[_0xd78b('0x2b')],'basename':_0x37bbc9,'savename':util['format'](_0xd78b('0x90'),_0x3ffac6['name']||_0x17408d[_0xd78b('0x2b')],require(_0xd78b('0x91'))['generate'](0x4),_0x3ffac6['output']||_0xd78b('0x92')),'reportId':_0x17408d['id'],'reportType':_0xd78b('0x93')});return db['AnalyticExtractedReport'][_0xd78b('0x49')](_0x5650cf,{'raw':!![]});})[_0xd78b('0x24')](function(_0x4b5ea9){if(_0x17408d[_0xd78b('0x7c')]===_0xd78b('0x94')){_0x39dd13[_0xd78b('0x3b')](_0x17408d[_0xd78b('0x7c')]+_0xd78b('0x95'),_0x3ffac6[_0xd78b('0x96')],_0x3ffac6[_0xd78b('0x97')]);}else{_0x39dd13[_0xd78b('0x3b')](_0x17408d[_0xd78b('0x7c')]+_0xd78b('0x98'),_0x3ffac6[_0xd78b('0x96')],_0x3ffac6[_0xd78b('0x97')]);}if(_0x4b5ea9){logger['info'](_0xd78b('0x99'),_0x39dd13['toString']());require(_0xd78b('0x9a'))[_0xd78b('0x9b')](path[_0xd78b('0x54')](__dirname,_0xd78b('0x9c'),_0x4b5ea9[_0xd78b('0x8e')]),[_0x4b5ea9['id'],_0x39dd13[_0xd78b('0x81')](),path[_0xd78b('0x54')](__dirname,_0xd78b('0x9d'),_0x4b5ea9[_0xd78b('0x9e')]),_0x37bbc9]);return _0x4b5ea9;}else{var _0x6dfebd=squel['select']();_0x6dfebd['from']('('+_0x39dd13[_0xd78b('0x81')]()+')',_0xd78b('0x9f'));_0x6dfebd['field'](_0xd78b('0xa0'),'count');_0x39dd13['limit'](_0x3ffac6[_0xd78b('0x1e')]||_0x1260a3);_0x39dd13[_0xd78b('0x1d')](_0x3ffac6[_0xd78b('0x1d')]||0x0);return dbH[_0xd78b('0x82')][_0xd78b('0x33')](_0x6dfebd[_0xd78b('0x81')](),{'type':dbH[_0xd78b('0x82')][_0xd78b('0xa1')]['SELECT']})[_0xd78b('0x24')](function(_0x159236){if(!_0x159236[_0xd78b('0x37')]){_0x257c14=0x0;}else{_0x257c14=_0x159236[0x0]['count']||0x0;}return dbH[_0xd78b('0x82')][_0xd78b('0x33')](_0x39dd13[_0xd78b('0x81')](),{'type':dbH[_0xd78b('0x82')][_0xd78b('0xa1')][_0xd78b('0x83')]});})['then'](function(_0x139d38){return{'rows':_0x139d38||[],'count':_0x257c14};});}});}exports['run']=function(_0x1c5147,_0x2d5e6d){return runReport(_0x1c5147[_0xd78b('0x47')],_0x1c5147[_0xd78b('0x33')],_0x1c5147[_0xd78b('0x41')])['then'](respondWithResult(_0x2d5e6d,null))[_0xd78b('0x45')](handleError(_0x2d5e6d,null));};exports[_0xd78b('0xa2')]=runReport;exports[_0xd78b('0x33')]=function(_0x2cbb92,_0x1951ea){var _0x38c37e=0xa;var _0x22154e=[_0xd78b('0x54'),_0xd78b('0x55'),'right_join','cross_join'];var _0x83d42={'SUM':_0xd78b('0x85'),'COUNT':_0xd78b('0x57'),'COUNT DISTINCT':_0xd78b('0x58'),'MAX':_0xd78b('0x86'),'MIN':_0xd78b('0x59'),'AVG':_0xd78b('0x87'),'GROUP_CONCAT':_0xd78b('0x5a'),'GROUP_CONCAT ASC':_0xd78b('0x88'),'GROUP_CONCAT DESC':_0xd78b('0x89')};var _0x49a267={'SEC_TO_TIME':_0xd78b('0x8a'),'DATE':_0xd78b('0x5b'),'HOUR':_0xd78b('0x5c'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x1c1532=function(_0x3880fc){return!_[_0xd78b('0x5f')]([_0xd78b('0x60'),_0xd78b('0x61'),_0xd78b('0x62'),_0xd78b('0x63')],_0x3880fc);};var _0x280f72=function(_0xfd6806){if(!_0xfd6806||!_0xfd6806['rules'][_0xd78b('0x37')]){return'';}for(var _0x31306b='(',_0x49db29=0x0;_0x49db29<_0xfd6806[_0xd78b('0x64')][_0xd78b('0x37')];_0x49db29+=0x1){_0x49db29>0x0&&(_0x31306b+='\x20'+_0xfd6806[_0xd78b('0x65')]+'\x20');_0x31306b+=_0xfd6806['rules'][_0x49db29]['group']?_0x280f72(_0xfd6806[_0xd78b('0x64')][_0x49db29][_0xd78b('0x66')]):_0xfd6806[_0xd78b('0x64')][_0x49db29][_0xd78b('0x67')]+'\x20'+_0xfd6806['rules'][_0x49db29][_0xd78b('0x68')]+(_0x1c1532(_0xfd6806[_0xd78b('0x64')][_0x49db29][_0xd78b('0x68')])?'\x20'+_0xfd6806['rules'][_0x49db29][_0xd78b('0x69')]:'');}return _0x31306b+')';};var _0x184411={'where':{'id':_0x2cbb92[_0xd78b('0x47')]['id']}},_0x37a6a5,_0x19c294,_0x113ac6,_0x4b93f0,_0x176b00;_0x184411=_[_0xd78b('0x40')]({},_0x184411,_0x2cbb92['options']);return db[_0xd78b('0x2e')][_0xd78b('0x48')](_0x184411)[_0xd78b('0x24')](function(_0xc48067){if(_0xc48067){_0x37a6a5=_0xc48067;return _0xc48067[_0xd78b('0xa3')]();}return null;})[_0xd78b('0x24')](function(_0x57e4b9){if(_0x57e4b9){if(!_0x57e4b9['length']){throw new db[(_0xd78b('0x6a'))][(_0xd78b('0x8b'))](_0xd78b('0x6b'),0x193);}_0x19c294=_0x57e4b9;return db[_0xd78b('0x6c')][_0xd78b('0x44')]({'raw':!![]});}return null;})[_0xd78b('0x24')](function(_0x138216){if(_0x138216){_0x113ac6=_[_0xd78b('0x6d')](_0x138216,'id');var _0x246ca9;var _0x3aa61b=squel[_0xd78b('0x6e')]();_0x3aa61b[_0xd78b('0xa4')](_0x37a6a5[_0xd78b('0x7c')]);for(var _0x3590cb=0x0;_0x3590cb<_0x19c294[_0xd78b('0x37')];_0x3590cb+=0x1){_0x246ca9=_0x19c294[_0x3590cb][_0xd78b('0x6f')]?_0x113ac6[_0x19c294[_0x3590cb][_0xd78b('0x6f')]][_0xd78b('0x70')]:_0x19c294[_0x3590cb][_0xd78b('0x67')];_0x246ca9=_0x19c294[_0x3590cb]['function']?_[_0xd78b('0x72')](_0x83d42[_0x19c294[_0x3590cb]['function']],'%s',_0x246ca9):_0x246ca9;_0x246ca9=_0x19c294[_0x3590cb]['format']?_[_0xd78b('0x72')](_0x49a267[_0x19c294[_0x3590cb][_0xd78b('0x73')]],'%s',_0x246ca9):_0x246ca9;if(_0x19c294[_0x3590cb][_0xd78b('0x8c')]){_0x3aa61b[_0xd78b('0x66')](_0x246ca9);}_0x19c294[_0x3590cb][_0xd78b('0x74')]&&_0x3aa61b['order'](_0x246ca9,_0x19c294[_0x3590cb][_0xd78b('0x74')]===_0xd78b('0x8d')?![]:!![]);_0x3aa61b[_0xd78b('0x67')](_0x246ca9,_0x19c294[_0x3590cb][_0xd78b('0x75')]||_0x246ca9);}if(_0x37a6a5['joins']){_0x37a6a5[_0xd78b('0x76')]=JSON[_0xd78b('0x77')](_0x37a6a5[_0xd78b('0x76')]);for(var _0x412185=0x0;_0x412185<_0x37a6a5[_0xd78b('0x76')][_0xd78b('0x37')];_0x412185+=0x1){if(_0x37a6a5[_0xd78b('0x76')][_0x412185][_0xd78b('0x3e')]&&_[_0xd78b('0x5f')](_0x22154e,_0x37a6a5['joins'][_0x412185][_0xd78b('0x3e')])&&_0x37a6a5['joins'][_0x412185][_0xd78b('0x78')]&&_0x37a6a5[_0xd78b('0x76')][_0x412185][_0xd78b('0x79')]&&_0x37a6a5[_0xd78b('0x76')][_0x412185]['foreignKey']){_0x3aa61b[_0x37a6a5[_0xd78b('0x76')][_0x412185][_0xd78b('0x3e')]](_0x37a6a5[_0xd78b('0x76')][_0x412185][_0xd78b('0x79')],null,util[_0xd78b('0x73')](_0xd78b('0x7b'),_0x37a6a5[_0xd78b('0x7c')],_0x37a6a5[_0xd78b('0x76')][_0x412185][_0xd78b('0x78')],_0x37a6a5[_0xd78b('0x76')][_0x412185][_0xd78b('0x79')],_0x37a6a5['joins'][_0x412185][_0xd78b('0x7a')]));}}}if(_0x37a6a5[_0xd78b('0x7d')]){_0x37a6a5[_0xd78b('0x7d')]=JSON['parse'](_0x37a6a5['conditions']);_0x3aa61b[_0xd78b('0x3b')](_0x280f72(_0x37a6a5[_0xd78b('0x7d')][_0xd78b('0x66')]));}_0x176b00=_0x3aa61b[_0xd78b('0x7e')]();_0x3aa61b['limit'](_0x38c37e);_0x3aa61b[_0xd78b('0x1d')](0x0);logger[_0xd78b('0x7f')](_0xd78b('0x80'),_0x3aa61b['toString']());return dbH[_0xd78b('0x82')][_0xd78b('0x33')](_0x3aa61b['toString'](),{'type':dbH[_0xd78b('0x82')][_0xd78b('0xa1')][_0xd78b('0x83')]});}})[_0xd78b('0x24')](function(){return{'sql':_0x176b00[_0xd78b('0x81')]()};})[_0xd78b('0x24')](respondWithResult(_0x1951ea,null))[_0xd78b('0x45')](handleError(_0x1951ea,null));};
\ No newline at end of file
+var _0x94c9=['pick','filter','VIRTUAL','merge','options','count','includeAll','findAll','rows','catch','show','rawAttributes','include','create','body','user','role','find','params','preview','left_join','right_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%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)','DATE(%s)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','group','rules','field','condition','getFields','Sequelize','ValidationErrorItem','AnalyticMetric','keyBy','select','from','table','MetricId','function','format','replace','groupBy','orderBy','order','DESC','alias','joins','parentKey','foreignTable','foreignKey','conditions','parse','clone','debug','Limited\x20Query:','toString','sequelize','SELECT','join','Please\x20insert\x20at\x20least\x20one\x20field','web','%s-%s.%s','randomstring','generate','output','csv','custom','AnalyticExtractedReport','cdr','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','child_process','../../components/export/','../../files/reports','savename','countTable','COUNT(*)','run','runReport','operator','%s.%s\x20=\x20%s.%s','eml-format','rimraf','zip-dir','request-promise','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','desk.js','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','dbH','status','end','offset','undefined','limit','set','Content-Range','json','apply','reject','save','update','then','destroy','get','CustomReports','UserProfileResource','error','name','send','index','map','AnalyticCustomReport','fieldName','type','key','model','query','keys','intersection','fields','attributes','length','nolimit','sort','where','filters'];(function(_0x2d0bfd,_0x2ba336){var _0x4d806c=function(_0x47938d){while(--_0x47938d){_0x2d0bfd['push'](_0x2d0bfd['shift']());}};_0x4d806c(++_0x2ba336);}(_0x94c9,0x1a7));var _0x994c=function(_0x3cc575,_0x3e8ae6){_0x3cc575=_0x3cc575-0x0;var _0x276e6b=_0x94c9[_0x3cc575];return _0x276e6b;};'use strict';var emlformat=require(_0x994c('0x0'));var rimraf=require(_0x994c('0x1'));var zipdir=require(_0x994c('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x994c('0x3'));var moment=require('moment');var BPromise=require(_0x994c('0x4'));var Mustache=require(_0x994c('0x5'));var util=require(_0x994c('0x6'));var path=require(_0x994c('0x7'));var sox=require(_0x994c('0x8'));var csv=require(_0x994c('0x9'));var ejs=require(_0x994c('0xa'));var fs=require('fs');var fs_extra=require(_0x994c('0xb'));var _=require(_0x994c('0xc'));var squel=require(_0x994c('0xd'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0x994c('0xe'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x994c('0xf'));var Redis=require(_0x994c('0x10'));var authService=require('../../components/auth/service');var qs=require(_0x994c('0x11'));var as=require(_0x994c('0x12'));var hardwareService=require(_0x994c('0x13'));var logger=require(_0x994c('0x14'))(_0x994c('0x15'));var utils=require(_0x994c('0x16'));var config=require(_0x994c('0x17'));var licenseUtil=require('../../config/license/util');var db=require(_0x994c('0x18'))['db'];var dbH=require(_0x994c('0x18'))[_0x994c('0x19')];function respondWithStatusCode(_0x14a6e3,_0x5c1383){_0x5c1383=_0x5c1383||0xcc;return function(_0x4cadf7){if(_0x4cadf7){return _0x14a6e3['sendStatus'](_0x5c1383);}return _0x14a6e3[_0x994c('0x1a')](_0x5c1383)[_0x994c('0x1b')]();};}function respondWithResult(_0x48a799,_0x218af3){_0x218af3=_0x218af3||0xc8;return function(_0x30e52e){if(_0x30e52e){return _0x48a799[_0x994c('0x1a')](_0x218af3)['json'](_0x30e52e);}};}function respondWithFilteredResult(_0x56965c,_0x3d55e5){return function(_0x49d510){if(_0x49d510){var _0x4fa2ab=typeof _0x3d55e5[_0x994c('0x1c')]===_0x994c('0x1d')&&typeof _0x3d55e5['limit']===_0x994c('0x1d');var _0x2f0640=_0x49d510['count'];var _0x536b4b=_0x4fa2ab?0x0:_0x3d55e5['offset'];var _0x158d13=_0x4fa2ab?_0x49d510['count']:_0x3d55e5[_0x994c('0x1c')]+_0x3d55e5[_0x994c('0x1e')];var _0x218077;if(_0x158d13>=_0x2f0640){_0x158d13=_0x2f0640;_0x218077=0xc8;}else{_0x218077=0xce;}_0x56965c[_0x994c('0x1a')](_0x218077);return _0x56965c[_0x994c('0x1f')](_0x994c('0x20'),_0x536b4b+'-'+_0x158d13+'/'+_0x2f0640)[_0x994c('0x21')](_0x49d510);}return null;};}function patchUpdates(_0x5833f6){return function(_0x2cb1b5){try{jsonpatch[_0x994c('0x22')](_0x2cb1b5,_0x5833f6,!![]);}catch(_0x5efae7){return BPromise[_0x994c('0x23')](_0x5efae7);}return _0x2cb1b5[_0x994c('0x24')]();};}function saveUpdates(_0x87be60,_0xa8417f){return function(_0x4b25e6){if(_0x4b25e6){return _0x4b25e6[_0x994c('0x25')](_0x87be60)[_0x994c('0x26')](function(_0x2d6a77){return _0x2d6a77;});}return null;};}function removeEntity(_0x999b85,_0x5808f7){return function(_0x434b58){if(_0x434b58){return _0x434b58[_0x994c('0x27')]()['then'](function(){var _0x2d890d=_0x434b58[_0x994c('0x28')]({'plain':!![]});var _0x343268=_0x994c('0x29');return db[_0x994c('0x2a')][_0x994c('0x27')]({'where':{'type':_0x343268,'resourceId':_0x2d890d['id']}})[_0x994c('0x26')](function(){return _0x434b58;});})[_0x994c('0x26')](function(){_0x999b85[_0x994c('0x1a')](0xcc)[_0x994c('0x1b')]();});}};}function handleEntityNotFound(_0x5b265c,_0x5d35d2){return function(_0x28a213){if(!_0x28a213){_0x5b265c['sendStatus'](0x194);}return _0x28a213;};}function handleError(_0x1122a1,_0x2985ff){_0x2985ff=_0x2985ff||0x1f4;return function(_0xf15830){logger[_0x994c('0x2b')](_0xf15830['stack']);if(_0xf15830['name']){delete _0xf15830[_0x994c('0x2c')];}_0x1122a1[_0x994c('0x1a')](_0x2985ff)[_0x994c('0x2d')](_0xf15830);};}exports[_0x994c('0x2e')]=function(_0x15e06f,_0x39d291){var _0xaf5343={},_0x268cbe={},_0x49c3c6={'count':0x0,'rows':[]};var _0x1f9cfe=_[_0x994c('0x2f')](db[_0x994c('0x30')]['rawAttributes'],function(_0x26ef10){return{'name':_0x26ef10[_0x994c('0x31')],'type':_0x26ef10[_0x994c('0x32')][_0x994c('0x33')]};});_0x268cbe[_0x994c('0x34')]=_[_0x994c('0x2f')](_0x1f9cfe,_0x994c('0x2c'));_0x268cbe[_0x994c('0x35')]=_[_0x994c('0x36')](_0x15e06f[_0x994c('0x35')]);_0x268cbe['filters']=_[_0x994c('0x37')](_0x268cbe['model'],_0x268cbe[_0x994c('0x35')]);_0xaf5343['attributes']=_['intersection'](_0x268cbe[_0x994c('0x34')],qs[_0x994c('0x38')](_0x15e06f[_0x994c('0x35')][_0x994c('0x38')]));_0xaf5343[_0x994c('0x39')]=_0xaf5343[_0x994c('0x39')][_0x994c('0x3a')]?_0xaf5343[_0x994c('0x39')]:_0x268cbe[_0x994c('0x34')];if(!_0x15e06f[_0x994c('0x35')]['hasOwnProperty'](_0x994c('0x3b'))){_0xaf5343[_0x994c('0x1e')]=qs[_0x994c('0x1e')](_0x15e06f[_0x994c('0x35')][_0x994c('0x1e')]);_0xaf5343[_0x994c('0x1c')]=qs[_0x994c('0x1c')](_0x15e06f['query'][_0x994c('0x1c')]);}_0xaf5343['order']=qs[_0x994c('0x3c')](_0x15e06f[_0x994c('0x35')]['sort']);_0xaf5343[_0x994c('0x3d')]=qs[_0x994c('0x3e')](_[_0x994c('0x3f')](_0x15e06f[_0x994c('0x35')],_0x268cbe[_0x994c('0x3e')]),_0x1f9cfe);if(_0x15e06f[_0x994c('0x35')][_0x994c('0x40')]){_0xaf5343[_0x994c('0x3d')]=_['merge'](_0xaf5343[_0x994c('0x3d')],{'$or':_[_0x994c('0x2f')](_0x1f9cfe,function(_0x2c694f){if(_0x2c694f[_0x994c('0x32')]!==_0x994c('0x41')){var _0x25bb9b={};_0x25bb9b[_0x2c694f['name']]={'$like':'%'+_0x15e06f[_0x994c('0x35')][_0x994c('0x40')]+'%'};return _0x25bb9b;}})});}_0xaf5343=_[_0x994c('0x42')]({},_0xaf5343,_0x15e06f[_0x994c('0x43')]);var _0x2713c8={'where':_0xaf5343[_0x994c('0x3d')]};return db['AnalyticCustomReport'][_0x994c('0x44')](_0x2713c8)['then'](function(_0x1b77ab){_0x49c3c6[_0x994c('0x44')]=_0x1b77ab;if(_0x15e06f[_0x994c('0x35')][_0x994c('0x45')]){_0xaf5343['include']=[{'all':!![]}];}return db[_0x994c('0x30')][_0x994c('0x46')](_0xaf5343);})[_0x994c('0x26')](function(_0x1bcebd){_0x49c3c6[_0x994c('0x47')]=_0x1bcebd;return _0x49c3c6;})[_0x994c('0x26')](respondWithFilteredResult(_0x39d291,_0xaf5343))[_0x994c('0x48')](handleError(_0x39d291,null));};exports[_0x994c('0x49')]=function(_0x101e85,_0x4cd941){var _0x51a363={'raw':![],'where':{'id':_0x101e85['params']['id']}},_0x5caaef={};_0x5caaef[_0x994c('0x34')]=_[_0x994c('0x36')](db[_0x994c('0x30')][_0x994c('0x4a')]);_0x5caaef[_0x994c('0x35')]=_[_0x994c('0x36')](_0x101e85[_0x994c('0x35')]);_0x5caaef[_0x994c('0x3e')]=_['intersection'](_0x5caaef[_0x994c('0x34')],_0x5caaef[_0x994c('0x35')]);_0x51a363['attributes']=_['intersection'](_0x5caaef[_0x994c('0x34')],qs[_0x994c('0x38')](_0x101e85[_0x994c('0x35')][_0x994c('0x38')]));_0x51a363[_0x994c('0x39')]=_0x51a363[_0x994c('0x39')]['length']?_0x51a363[_0x994c('0x39')]:_0x5caaef[_0x994c('0x34')];if(_0x101e85[_0x994c('0x35')][_0x994c('0x45')]){_0x51a363[_0x994c('0x4b')]=[{'all':!![]}];}_0x51a363=_[_0x994c('0x42')]({},_0x51a363,_0x101e85[_0x994c('0x43')]);return db['AnalyticCustomReport']['find'](_0x51a363)['then'](handleEntityNotFound(_0x4cd941,null))['then'](respondWithResult(_0x4cd941,null))[_0x994c('0x48')](handleError(_0x4cd941,null));};exports['create']=function(_0xfe85a4,_0x20c953){return db[_0x994c('0x30')][_0x994c('0x4c')](_0xfe85a4[_0x994c('0x4d')],{})[_0x994c('0x26')](function(_0x4e88bd){var _0x2a9360=_0xfe85a4[_0x994c('0x4e')][_0x994c('0x28')]({'plain':!![]});if(!_0x2a9360)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x2a9360[_0x994c('0x4f')]===_0x994c('0x4e')){var _0x9b67fe=_0x4e88bd['get']({'plain':!![]});var _0x37f422='Reports';return db['UserProfileSection'][_0x994c('0x50')]({'where':{'name':_0x37f422,'userProfileId':_0x2a9360['userProfileId']},'raw':!![]})[_0x994c('0x26')](function(_0x13703e){if(_0x13703e&&_0x13703e['autoAssociation']===0x0){return db[_0x994c('0x2a')][_0x994c('0x4c')]({'name':_0x9b67fe[_0x994c('0x2c')],'resourceId':_0x9b67fe['id'],'type':'CustomReports','sectionId':_0x13703e['id']},{})['then'](function(){return _0x4e88bd;});}else{return _0x4e88bd;}})[_0x994c('0x48')](function(_0x149525){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x149525);throw _0x149525;});}return _0x4e88bd;})['then'](respondWithResult(_0x20c953,0xc9))[_0x994c('0x48')](handleError(_0x20c953,null));};exports['update']=function(_0x3b4c72,_0x28b424){if(_0x3b4c72[_0x994c('0x4d')]['id']){delete _0x3b4c72[_0x994c('0x4d')]['id'];}return db[_0x994c('0x30')][_0x994c('0x50')]({'where':{'id':_0x3b4c72[_0x994c('0x51')]['id']}})[_0x994c('0x26')](handleEntityNotFound(_0x28b424,null))[_0x994c('0x26')](saveUpdates(_0x3b4c72[_0x994c('0x4d')],null))['then'](respondWithResult(_0x28b424,null))[_0x994c('0x48')](handleError(_0x28b424,null));};exports[_0x994c('0x27')]=function(_0x5085b9,_0x1e0edc){return db['AnalyticCustomReport'][_0x994c('0x50')]({'where':{'id':_0x5085b9[_0x994c('0x51')]['id']}})[_0x994c('0x26')](handleEntityNotFound(_0x1e0edc,null))[_0x994c('0x26')](removeEntity(_0x1e0edc,null))['catch'](handleError(_0x1e0edc,null));};exports[_0x994c('0x52')]=function(_0x2640ce,_0x5e3807){var _0x4b73cb=0xa;var _0x1a0b0f=['join',_0x994c('0x53'),_0x994c('0x54'),'cross_join'];var _0x23111b={'SUM':_0x994c('0x55'),'COUNT':_0x994c('0x56'),'COUNT DISTINCT':_0x994c('0x57'),'MAX':_0x994c('0x58'),'MIN':_0x994c('0x59'),'AVG':_0x994c('0x5a'),'GROUP_CONCAT':_0x994c('0x5b'),'GROUP_CONCAT ASC':_0x994c('0x5c'),'GROUP_CONCAT DESC':_0x994c('0x5d')};var _0x23c18e={'SEC_TO_TIME':_0x994c('0x5e'),'DATE':_0x994c('0x5f'),'HOUR':_0x994c('0x60'),'ROUND':_0x994c('0x61'),'UNIX_TIMESTAMP':_0x994c('0x62')};var _0x51a005=function(_0x17fedc){return!_[_0x994c('0x63')]([_0x994c('0x64'),_0x994c('0x65'),_0x994c('0x66'),_0x994c('0x67')],_0x17fedc);};var _0x140a66=function(_0x22986b){if(!_0x22986b||!_0x22986b['rules'][_0x994c('0x3a')]){return'';}for(var _0x3a2831='(',_0x53d0b6=0x0;_0x53d0b6<_0x22986b['rules'][_0x994c('0x3a')];_0x53d0b6+=0x1){_0x53d0b6>0x0&&(_0x3a2831+='\x20'+_0x22986b['operator']+'\x20');_0x3a2831+=_0x22986b['rules'][_0x53d0b6][_0x994c('0x68')]?_0x140a66(_0x22986b[_0x994c('0x69')][_0x53d0b6][_0x994c('0x68')]):_0x22986b[_0x994c('0x69')][_0x53d0b6][_0x994c('0x6a')]+'\x20'+_0x22986b[_0x994c('0x69')][_0x53d0b6][_0x994c('0x6b')]+(_0x51a005(_0x22986b[_0x994c('0x69')][_0x53d0b6][_0x994c('0x6b')])?'\x20'+_0x22986b[_0x994c('0x69')][_0x53d0b6]['value']:'');}return _0x3a2831+')';};var _0xc8d654={'where':{'id':_0x2640ce[_0x994c('0x51')]['id']}},_0x47cd86,_0x414210,_0x578b03,_0x92aa1,_0x192b6e;_0xc8d654=_[_0x994c('0x42')]({},_0xc8d654,_0x2640ce[_0x994c('0x43')]);return db[_0x994c('0x30')][_0x994c('0x50')](_0xc8d654)[_0x994c('0x26')](function(_0xb4f83f){if(_0xb4f83f){_0x47cd86=_0xb4f83f;return _0xb4f83f[_0x994c('0x6c')]();}return null;})[_0x994c('0x26')](function(_0x130500){if(_0x130500){if(!_0x130500[_0x994c('0x3a')]){throw new db[(_0x994c('0x6d'))][(_0x994c('0x6e'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x414210=_0x130500;return db[_0x994c('0x6f')][_0x994c('0x46')]({'raw':!![]});}return null;})[_0x994c('0x26')](function(_0x23aec3){if(_0x23aec3){_0x578b03=_[_0x994c('0x70')](_0x23aec3,'id');var _0x125ef0;var _0x4834e6=squel[_0x994c('0x71')]();_0x4834e6[_0x994c('0x72')](_0x47cd86[_0x994c('0x73')]);for(var _0x39469d=0x0;_0x39469d<_0x414210[_0x994c('0x3a')];_0x39469d+=0x1){_0x125ef0=_0x414210[_0x39469d][_0x994c('0x74')]?_0x578b03[_0x414210[_0x39469d][_0x994c('0x74')]]['metric']:_0x414210[_0x39469d][_0x994c('0x6a')];_0x125ef0=_0x414210[_0x39469d][_0x994c('0x75')]?_['replace'](_0x23111b[_0x414210[_0x39469d][_0x994c('0x75')]],'%s',_0x125ef0):_0x125ef0;_0x125ef0=_0x414210[_0x39469d][_0x994c('0x76')]?_[_0x994c('0x77')](_0x23c18e[_0x414210[_0x39469d][_0x994c('0x76')]],'%s',_0x125ef0):_0x125ef0;if(_0x414210[_0x39469d][_0x994c('0x78')]){_0x4834e6[_0x994c('0x68')](_0x125ef0);}_0x414210[_0x39469d][_0x994c('0x79')]&&_0x4834e6[_0x994c('0x7a')](_0x125ef0,_0x414210[_0x39469d]['orderBy']===_0x994c('0x7b')?![]:!![]);_0x4834e6[_0x994c('0x6a')](_0x125ef0,_0x414210[_0x39469d][_0x994c('0x7c')]||_0x125ef0);}if(_0x47cd86[_0x994c('0x7d')]){_0x47cd86[_0x994c('0x7d')]=JSON['parse'](_0x47cd86[_0x994c('0x7d')]);for(var _0x2ef87c=0x0;_0x2ef87c<_0x47cd86[_0x994c('0x7d')][_0x994c('0x3a')];_0x2ef87c+=0x1){if(_0x47cd86[_0x994c('0x7d')][_0x2ef87c][_0x994c('0x32')]&&_[_0x994c('0x63')](_0x1a0b0f,_0x47cd86['joins'][_0x2ef87c][_0x994c('0x32')])&&_0x47cd86[_0x994c('0x7d')][_0x2ef87c][_0x994c('0x7e')]&&_0x47cd86['joins'][_0x2ef87c][_0x994c('0x7f')]&&_0x47cd86[_0x994c('0x7d')][_0x2ef87c][_0x994c('0x80')]){_0x4834e6[_0x47cd86[_0x994c('0x7d')][_0x2ef87c][_0x994c('0x32')]](_0x47cd86[_0x994c('0x7d')][_0x2ef87c]['foreignTable'],null,util[_0x994c('0x76')]('%s.%s\x20=\x20%s.%s',_0x47cd86[_0x994c('0x73')],_0x47cd86['joins'][_0x2ef87c][_0x994c('0x7e')],_0x47cd86['joins'][_0x2ef87c][_0x994c('0x7f')],_0x47cd86[_0x994c('0x7d')][_0x2ef87c]['foreignKey']));}}}if(_0x47cd86[_0x994c('0x81')]){_0x47cd86[_0x994c('0x81')]=JSON[_0x994c('0x82')](_0x47cd86[_0x994c('0x81')]);_0x4834e6[_0x994c('0x3d')](_0x140a66(_0x47cd86[_0x994c('0x81')]['group']));}_0x192b6e=_0x4834e6[_0x994c('0x83')]();_0x4834e6[_0x994c('0x1e')](_0x4b73cb);_0x4834e6[_0x994c('0x1c')](0x0);logger[_0x994c('0x84')](_0x994c('0x85'),_0x4834e6[_0x994c('0x86')]());return dbH[_0x994c('0x87')][_0x994c('0x35')](_0x4834e6['toString'](),{'type':dbH['sequelize']['QueryTypes'][_0x994c('0x88')]});}})['then'](respondWithResult(_0x5e3807,null))[_0x994c('0x48')](handleError(_0x5e3807,null));};function runReport(_0x4cb2e0,_0x264568,_0x1db0c8){var _0x11bf24=_0x264568[_0x994c('0x2c')];var _0x97df2b=0xa;var _0x25db9c=[_0x994c('0x89'),_0x994c('0x53'),'right_join','cross_join'];var _0x2657a6={'SUM':_0x994c('0x55'),'COUNT':_0x994c('0x56'),'COUNT DISTINCT':_0x994c('0x57'),'MAX':_0x994c('0x58'),'MIN':_0x994c('0x59'),'AVG':_0x994c('0x5a'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x994c('0x5c'),'GROUP_CONCAT DESC':_0x994c('0x5d')};var _0x284149={'SEC_TO_TIME':_0x994c('0x5e'),'DATE':_0x994c('0x5f'),'HOUR':_0x994c('0x60'),'ROUND':_0x994c('0x61'),'UNIX_TIMESTAMP':_0x994c('0x62')};var _0xe88654=function(_0x98bdb){return!_['includes']([_0x994c('0x64'),_0x994c('0x65'),_0x994c('0x66'),_0x994c('0x67')],_0x98bdb);};var _0x561245=function(_0xf9872b){if(!_0xf9872b||!_0xf9872b['rules']['length']){return'';}for(var _0x559f37='(',_0x430966=0x0;_0x430966<_0xf9872b[_0x994c('0x69')][_0x994c('0x3a')];_0x430966+=0x1){_0x430966>0x0&&(_0x559f37+='\x20'+_0xf9872b['operator']+'\x20');_0x559f37+=_0xf9872b[_0x994c('0x69')][_0x430966][_0x994c('0x68')]?_0x561245(_0xf9872b[_0x994c('0x69')][_0x430966][_0x994c('0x68')]):_0xf9872b[_0x994c('0x69')][_0x430966]['field']+'\x20'+_0xf9872b['rules'][_0x430966][_0x994c('0x6b')]+(_0xe88654(_0xf9872b[_0x994c('0x69')][_0x430966][_0x994c('0x6b')])?'\x20'+_0xf9872b[_0x994c('0x69')][_0x430966]['value']:'');}return _0x559f37+')';};var _0x136975={'where':{'id':_0x4cb2e0['id']}},_0x415398,_0x2fcd54,_0x4f0399,_0x4680c1,_0x3c45d5;_0x136975=_[_0x994c('0x42')]({},_0x136975,_0x1db0c8);return db[_0x994c('0x30')]['find'](_0x136975)['then'](function(_0x412332){if(_0x412332){_0x415398=_0x412332;return _0x412332[_0x994c('0x6c')]();}return null;})[_0x994c('0x26')](function(_0x360fa4){if(_0x360fa4){if(!_0x360fa4[_0x994c('0x3a')]){throw new db[(_0x994c('0x6d'))][(_0x994c('0x6e'))](_0x994c('0x8a'),0x193);}_0x2fcd54=_0x360fa4;return db[_0x994c('0x6f')][_0x994c('0x46')]({'raw':!![]});}return null;})['then'](function(_0x46b495){if(_0x46b495){_0x4f0399=_[_0x994c('0x70')](_0x46b495,'id');var _0x3508b9;var _0x380a45=squel['select']();_0x380a45['from'](_0x415398[_0x994c('0x73')]);for(var _0x50caf6=0x0;_0x50caf6<_0x2fcd54[_0x994c('0x3a')];_0x50caf6+=0x1){_0x3508b9=_0x2fcd54[_0x50caf6]['MetricId']?_0x4f0399[_0x2fcd54[_0x50caf6][_0x994c('0x74')]]['metric']:_0x2fcd54[_0x50caf6]['field'];_0x3508b9=_0x2fcd54[_0x50caf6]['function']?_['replace'](_0x2657a6[_0x2fcd54[_0x50caf6][_0x994c('0x75')]],'%s',_0x3508b9):_0x3508b9;_0x3508b9=_0x2fcd54[_0x50caf6][_0x994c('0x76')]?_['replace'](_0x284149[_0x2fcd54[_0x50caf6][_0x994c('0x76')]],'%s',_0x3508b9):_0x3508b9;if(_0x2fcd54[_0x50caf6]['groupBy']){_0x380a45[_0x994c('0x68')](_0x3508b9);}_0x2fcd54[_0x50caf6][_0x994c('0x79')]&&_0x380a45[_0x994c('0x7a')](_0x3508b9,_0x2fcd54[_0x50caf6][_0x994c('0x79')]==='DESC'?![]:!![]);_0x380a45[_0x994c('0x6a')](_0x3508b9,_0x2fcd54[_0x50caf6][_0x994c('0x7c')]||_0x3508b9);}if(_0x415398[_0x994c('0x7d')]){_0x415398[_0x994c('0x7d')]=JSON['parse'](_0x415398[_0x994c('0x7d')]);for(var _0x50f1ac=0x0;_0x50f1ac<_0x415398[_0x994c('0x7d')][_0x994c('0x3a')];_0x50f1ac+=0x1){if(_0x415398[_0x994c('0x7d')][_0x50f1ac]['type']&&_[_0x994c('0x63')](_0x25db9c,_0x415398[_0x994c('0x7d')][_0x50f1ac][_0x994c('0x32')])&&_0x415398['joins'][_0x50f1ac][_0x994c('0x7e')]&&_0x415398[_0x994c('0x7d')][_0x50f1ac]['foreignTable']&&_0x415398[_0x994c('0x7d')][_0x50f1ac][_0x994c('0x80')]){_0x380a45[_0x415398[_0x994c('0x7d')][_0x50f1ac][_0x994c('0x32')]](_0x415398[_0x994c('0x7d')][_0x50f1ac][_0x994c('0x7f')],null,util['format']('%s.%s\x20=\x20%s.%s',_0x415398[_0x994c('0x73')],_0x415398[_0x994c('0x7d')][_0x50f1ac][_0x994c('0x7e')],_0x415398[_0x994c('0x7d')][_0x50f1ac][_0x994c('0x7f')],_0x415398['joins'][_0x50f1ac][_0x994c('0x80')]));}}}if(_0x415398[_0x994c('0x81')]){_0x415398[_0x994c('0x81')]=JSON[_0x994c('0x82')](_0x415398[_0x994c('0x81')]);_0x380a45[_0x994c('0x3d')](_0x561245(_0x415398[_0x994c('0x81')][_0x994c('0x68')]));}_0x3c45d5=_0x380a45['clone']();_0x380a45[_0x994c('0x1e')](_0x97df2b);_0x380a45['offset'](0x0);return;}})[_0x994c('0x26')](function(){if(_0x264568['output']===_0x994c('0x8b')){return null;}var _0x21b728=_[_0x994c('0x42')](_0x264568,{'name':_0x264568['fullPath']||_0x264568[_0x994c('0x2c')]||_0x415398[_0x994c('0x2c')],'basename':_0x11bf24,'savename':util[_0x994c('0x76')](_0x994c('0x8c'),_0x264568[_0x994c('0x2c')]||_0x415398[_0x994c('0x2c')],require(_0x994c('0x8d'))[_0x994c('0x8e')](0x4),_0x264568[_0x994c('0x8f')]||_0x994c('0x90')),'reportId':_0x415398['id'],'reportType':_0x994c('0x91')});return db[_0x994c('0x92')][_0x994c('0x4c')](_0x21b728,{'raw':!![]});})[_0x994c('0x26')](function(_0x1bad63){if(_0x415398['table']===_0x994c('0x93')){_0x3c45d5[_0x994c('0x3d')](_0x415398[_0x994c('0x73')]+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x264568[_0x994c('0x94')],_0x264568[_0x994c('0x95')]);}else{_0x3c45d5[_0x994c('0x3d')](_0x415398['table']+_0x994c('0x96'),_0x264568[_0x994c('0x94')],_0x264568[_0x994c('0x95')]);}if(_0x1bad63){logger[_0x994c('0x97')]('Run\x20Query:',_0x3c45d5[_0x994c('0x86')]());require(_0x994c('0x98'))['fork'](path[_0x994c('0x89')](__dirname,_0x994c('0x99'),_0x1bad63[_0x994c('0x8f')]),[_0x1bad63['id'],_0x3c45d5['toString'](),path['join'](__dirname,_0x994c('0x9a'),_0x1bad63[_0x994c('0x9b')]),_0x11bf24]);return _0x1bad63;}else{var _0x4eaf96=squel['select']();_0x4eaf96[_0x994c('0x72')]('('+_0x3c45d5[_0x994c('0x86')]()+')',_0x994c('0x9c'));_0x4eaf96['field'](_0x994c('0x9d'),_0x994c('0x44'));_0x3c45d5[_0x994c('0x1e')](_0x264568[_0x994c('0x1e')]||_0x97df2b);_0x3c45d5[_0x994c('0x1c')](_0x264568['offset']||0x0);return dbH[_0x994c('0x87')][_0x994c('0x35')](_0x4eaf96[_0x994c('0x86')](),{'type':dbH['sequelize']['QueryTypes'][_0x994c('0x88')]})[_0x994c('0x26')](function(_0x3ae4ff){if(!_0x3ae4ff[_0x994c('0x3a')]){_0x4680c1=0x0;}else{_0x4680c1=_0x3ae4ff[0x0]['count']||0x0;}return dbH['sequelize'][_0x994c('0x35')](_0x3c45d5[_0x994c('0x86')](),{'type':dbH[_0x994c('0x87')]['QueryTypes'][_0x994c('0x88')]});})['then'](function(_0x1e9802){return{'rows':_0x1e9802||[],'count':_0x4680c1};});}});}exports[_0x994c('0x9e')]=function(_0x316804,_0x4ad2cf){return runReport(_0x316804[_0x994c('0x51')],_0x316804['query'],_0x316804['options'])['then'](respondWithResult(_0x4ad2cf,null))[_0x994c('0x48')](handleError(_0x4ad2cf,null));};exports[_0x994c('0x9f')]=runReport;exports[_0x994c('0x35')]=function(_0x141e4f,_0x2c1e53){var _0x30f23e=0xa;var _0x53a014=[_0x994c('0x89'),'left_join',_0x994c('0x54'),'cross_join'];var _0x3d6539={'SUM':_0x994c('0x55'),'COUNT':_0x994c('0x56'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x994c('0x58'),'MIN':'MIN(%s)','AVG':_0x994c('0x5a'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x994c('0x5c'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x22d56e={'SEC_TO_TIME':_0x994c('0x5e'),'DATE':_0x994c('0x5f'),'HOUR':_0x994c('0x60'),'ROUND':_0x994c('0x61'),'UNIX_TIMESTAMP':_0x994c('0x62')};var _0x38c958=function(_0x1d1950){return!_[_0x994c('0x63')]([_0x994c('0x64'),'IS\x20NOT\x20NULL',_0x994c('0x66'),_0x994c('0x67')],_0x1d1950);};var _0x2c340a=function(_0x5d73af){if(!_0x5d73af||!_0x5d73af['rules'][_0x994c('0x3a')]){return'';}for(var _0x2d7101='(',_0xa1a78d=0x0;_0xa1a78d<_0x5d73af[_0x994c('0x69')]['length'];_0xa1a78d+=0x1){_0xa1a78d>0x0&&(_0x2d7101+='\x20'+_0x5d73af[_0x994c('0xa0')]+'\x20');_0x2d7101+=_0x5d73af[_0x994c('0x69')][_0xa1a78d][_0x994c('0x68')]?_0x2c340a(_0x5d73af[_0x994c('0x69')][_0xa1a78d]['group']):_0x5d73af[_0x994c('0x69')][_0xa1a78d][_0x994c('0x6a')]+'\x20'+_0x5d73af[_0x994c('0x69')][_0xa1a78d][_0x994c('0x6b')]+(_0x38c958(_0x5d73af[_0x994c('0x69')][_0xa1a78d][_0x994c('0x6b')])?'\x20'+_0x5d73af[_0x994c('0x69')][_0xa1a78d]['value']:'');}return _0x2d7101+')';};var _0xfe9640={'where':{'id':_0x141e4f['params']['id']}},_0x30acda,_0x1f5ec4,_0x6acf79,_0x22cc49,_0x39f26b;_0xfe9640=_[_0x994c('0x42')]({},_0xfe9640,_0x141e4f['options']);return db[_0x994c('0x30')][_0x994c('0x50')](_0xfe9640)[_0x994c('0x26')](function(_0x17429c){if(_0x17429c){_0x30acda=_0x17429c;return _0x17429c[_0x994c('0x6c')]();}return null;})[_0x994c('0x26')](function(_0x1f7a70){if(_0x1f7a70){if(!_0x1f7a70[_0x994c('0x3a')]){throw new db[(_0x994c('0x6d'))][(_0x994c('0x6e'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x1f5ec4=_0x1f7a70;return db[_0x994c('0x6f')][_0x994c('0x46')]({'raw':!![]});}return null;})['then'](function(_0x506938){if(_0x506938){_0x6acf79=_[_0x994c('0x70')](_0x506938,'id');var _0x146b1e;var _0x2cfe95=squel['select']();_0x2cfe95[_0x994c('0x72')](_0x30acda[_0x994c('0x73')]);for(var _0x5a9798=0x0;_0x5a9798<_0x1f5ec4[_0x994c('0x3a')];_0x5a9798+=0x1){_0x146b1e=_0x1f5ec4[_0x5a9798][_0x994c('0x74')]?_0x6acf79[_0x1f5ec4[_0x5a9798]['MetricId']]['metric']:_0x1f5ec4[_0x5a9798][_0x994c('0x6a')];_0x146b1e=_0x1f5ec4[_0x5a9798][_0x994c('0x75')]?_[_0x994c('0x77')](_0x3d6539[_0x1f5ec4[_0x5a9798][_0x994c('0x75')]],'%s',_0x146b1e):_0x146b1e;_0x146b1e=_0x1f5ec4[_0x5a9798][_0x994c('0x76')]?_[_0x994c('0x77')](_0x22d56e[_0x1f5ec4[_0x5a9798]['format']],'%s',_0x146b1e):_0x146b1e;if(_0x1f5ec4[_0x5a9798][_0x994c('0x78')]){_0x2cfe95['group'](_0x146b1e);}_0x1f5ec4[_0x5a9798]['orderBy']&&_0x2cfe95[_0x994c('0x7a')](_0x146b1e,_0x1f5ec4[_0x5a9798][_0x994c('0x79')]==='DESC'?![]:!![]);_0x2cfe95[_0x994c('0x6a')](_0x146b1e,_0x1f5ec4[_0x5a9798][_0x994c('0x7c')]||_0x146b1e);}if(_0x30acda[_0x994c('0x7d')]){_0x30acda[_0x994c('0x7d')]=JSON[_0x994c('0x82')](_0x30acda[_0x994c('0x7d')]);for(var _0x50e942=0x0;_0x50e942<_0x30acda['joins']['length'];_0x50e942+=0x1){if(_0x30acda['joins'][_0x50e942][_0x994c('0x32')]&&_[_0x994c('0x63')](_0x53a014,_0x30acda['joins'][_0x50e942][_0x994c('0x32')])&&_0x30acda['joins'][_0x50e942][_0x994c('0x7e')]&&_0x30acda['joins'][_0x50e942][_0x994c('0x7f')]&&_0x30acda[_0x994c('0x7d')][_0x50e942]['foreignKey']){_0x2cfe95[_0x30acda[_0x994c('0x7d')][_0x50e942]['type']](_0x30acda[_0x994c('0x7d')][_0x50e942][_0x994c('0x7f')],null,util[_0x994c('0x76')](_0x994c('0xa1'),_0x30acda[_0x994c('0x73')],_0x30acda[_0x994c('0x7d')][_0x50e942][_0x994c('0x7e')],_0x30acda[_0x994c('0x7d')][_0x50e942][_0x994c('0x7f')],_0x30acda[_0x994c('0x7d')][_0x50e942]['foreignKey']));}}}if(_0x30acda['conditions']){_0x30acda[_0x994c('0x81')]=JSON[_0x994c('0x82')](_0x30acda[_0x994c('0x81')]);_0x2cfe95[_0x994c('0x3d')](_0x2c340a(_0x30acda[_0x994c('0x81')][_0x994c('0x68')]));}_0x39f26b=_0x2cfe95[_0x994c('0x83')]();_0x2cfe95['limit'](_0x30f23e);_0x2cfe95[_0x994c('0x1c')](0x0);logger[_0x994c('0x84')](_0x994c('0x85'),_0x2cfe95[_0x994c('0x86')]());return dbH[_0x994c('0x87')]['query'](_0x2cfe95[_0x994c('0x86')](),{'type':dbH[_0x994c('0x87')]['QueryTypes']['SELECT']});}})[_0x994c('0x26')](function(){return{'sql':_0x39f26b[_0x994c('0x86')]()};})['then'](respondWithResult(_0x2c1e53,null))[_0x994c('0x48')](handleError(_0x2c1e53,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff