server/api/analyticFieldReport/analyticFieldReport.controller.js

   1 // *************************************************************************
   2 // *                                                                       *
   3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
   4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
   5 // *                                                                       *
   6 // *************************************************************************
   7 // *                                                                       *
   8 // * Email: info@xcally.com                                                *
   9 // * Website: https://www.xcally.com                                       *
  10 // *                                                                       *
  11 // *************************************************************************
  12 // *                                                                       *
  13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
  14 // * copyright treaties, as well as other intellectual property laws and   *
  15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
  16 // *                                                                       *
  17 // *************************************************************************
  18 var _0x0633=['../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','json','offset','undefined','limit','count','set','Content-Range','apply','reject','then','end','error','stack','name','map','AnalyticFieldReport','fieldName','type','key','model','keys','query','filters','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','where','pick','VIRTUAL','merge','options','includeAll','include','findAll','rows','catch','show','length','find','create','body','bulkCreate','update','params','destroy','bulkDestroy','ids','findOne','sequelize','transaction','CustomReportId','eml-format','rimraf','zip-dir','moment','bluebird','mustache','util','path','sox','to-csv','fs-extra','squel','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/advancedSearch'];(function(_0x4d0fdc,_0x3c4278){var _0x50015a=function(_0x3f97ac){while(--_0x3f97ac){_0x4d0fdc['push'](_0x4d0fdc['shift']());}};_0x50015a(++_0x3c4278);}(_0x0633,0x188));var _0x3063=function(_0x1767ac,_0x9d099c){_0x1767ac=_0x1767ac-0x0;var _0x24986c=_0x0633[_0x1767ac];return _0x24986c;};'use strict';var emlformat=require(_0x3063('0x0'));var rimraf=require(_0x3063('0x1'));var zipdir=require(_0x3063('0x2'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0x3063('0x3'));var BPromise=require(_0x3063('0x4'));var Mustache=require(_0x3063('0x5'));var util=require(_0x3063('0x6'));var path=require(_0x3063('0x7'));var sox=require(_0x3063('0x8'));var csv=require(_0x3063('0x9'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x3063('0xa'));var _=require('lodash');var squel=require(_0x3063('0xb'));var crypto=require('crypto');var jsforce=require(_0x3063('0xc'));var deskjs=require(_0x3063('0xd'));var toCsv=require(_0x3063('0x9'));var querystring=require(_0x3063('0xe'));var Papa=require(_0x3063('0xf'));var Redis=require('ioredis');var authService=require(_0x3063('0x10'));var qs=require('../../components/parsers/qs');var as=require(_0x3063('0x11'));var hardwareService=require(_0x3063('0x12'));var logger=require(_0x3063('0x13'))(_0x3063('0x14'));var utils=require(_0x3063('0x15'));var config=require(_0x3063('0x16'));var licenseUtil=require(_0x3063('0x17'));var db=require(_0x3063('0x18'))['db'];function respondWithStatusCode(_0x108f1e,_0x3234ea){_0x3234ea=_0x3234ea||0xcc;return function(_0x497925){if(_0x497925){return _0x108f1e[_0x3063('0x19')](_0x3234ea);}return _0x108f1e['status'](_0x3234ea)['end']();};}function respondWithResult(_0x419970,_0x1f7cab){_0x1f7cab=_0x1f7cab||0xc8;return function(_0xc0999a){if(_0xc0999a){return _0x419970[_0x3063('0x1a')](_0x1f7cab)[_0x3063('0x1b')](_0xc0999a);}};}function respondWithFilteredResult(_0x15d514,_0x446aaa){return function(_0x24348c){if(_0x24348c){var _0x2b86c3=typeof _0x446aaa[_0x3063('0x1c')]===_0x3063('0x1d')&&typeof _0x446aaa[_0x3063('0x1e')]===_0x3063('0x1d');var _0xa91a96=_0x24348c[_0x3063('0x1f')];var _0x550caa=_0x2b86c3?0x0:_0x446aaa[_0x3063('0x1c')];var _0x4f70ce=_0x2b86c3?_0x24348c[_0x3063('0x1f')]:_0x446aaa[_0x3063('0x1c')]+_0x446aaa['limit'];var _0x2d1f84;if(_0x4f70ce>=_0xa91a96){_0x4f70ce=_0xa91a96;_0x2d1f84=0xc8;}else{_0x2d1f84=0xce;}_0x15d514[_0x3063('0x1a')](_0x2d1f84);return _0x15d514[_0x3063('0x20')](_0x3063('0x21'),_0x550caa+'-'+_0x4f70ce+'/'+_0xa91a96)[_0x3063('0x1b')](_0x24348c);}return null;};}function patchUpdates(_0x195802){return function(_0x100669){try{jsonpatch[_0x3063('0x22')](_0x100669,_0x195802,!![]);}catch(_0x5d442f){return BPromise[_0x3063('0x23')](_0x5d442f);}return _0x100669['save']();};}function saveUpdates(_0x46fcae,_0x591870){return function(_0x522629){if(_0x522629){return _0x522629['update'](_0x46fcae)[_0x3063('0x24')](function(_0x428745){return _0x428745;});}return null;};}function removeEntity(_0xa23657,_0x48044a){return function(_0x5af250){if(_0x5af250){return _0x5af250['destroy']()[_0x3063('0x24')](function(){_0xa23657[_0x3063('0x1a')](0xcc)[_0x3063('0x25')]();});}};}function handleEntityNotFound(_0x4a8594,_0x550f10){return function(_0x4c0b9e){if(!_0x4c0b9e){_0x4a8594['sendStatus'](0x194);}return _0x4c0b9e;};}function handleError(_0x3ed4be,_0x5f0427){_0x5f0427=_0x5f0427||0x1f4;return function(_0x47c210){logger[_0x3063('0x26')](_0x47c210[_0x3063('0x27')]);if(_0x47c210['name']){delete _0x47c210[_0x3063('0x28')];}_0x3ed4be[_0x3063('0x1a')](_0x5f0427)['send'](_0x47c210);};}exports['index']=function(_0xa1d6ae,_0x540c78){var _0x2d6a18={},_0x18f800={},_0x3e5f1f={'count':0x0,'rows':[]};var _0x3a88b9=_[_0x3063('0x29')](db[_0x3063('0x2a')]['rawAttributes'],function(_0x1de5db){return{'name':_0x1de5db[_0x3063('0x2b')],'type':_0x1de5db[_0x3063('0x2c')][_0x3063('0x2d')]};});_0x18f800[_0x3063('0x2e')]=_[_0x3063('0x29')](_0x3a88b9,_0x3063('0x28'));_0x18f800['query']=_[_0x3063('0x2f')](_0xa1d6ae[_0x3063('0x30')]);_0x18f800[_0x3063('0x31')]=_[_0x3063('0x32')](_0x18f800[_0x3063('0x2e')],_0x18f800['query']);_0x2d6a18[_0x3063('0x33')]=_[_0x3063('0x32')](_0x18f800[_0x3063('0x2e')],qs[_0x3063('0x34')](_0xa1d6ae[_0x3063('0x30')][_0x3063('0x34')]));_0x2d6a18[_0x3063('0x33')]=_0x2d6a18[_0x3063('0x33')]['length']?_0x2d6a18['attributes']:_0x18f800['model'];if(!_0xa1d6ae[_0x3063('0x30')][_0x3063('0x35')](_0x3063('0x36'))){_0x2d6a18[_0x3063('0x1e')]=qs[_0x3063('0x1e')](_0xa1d6ae['query']['limit']);_0x2d6a18['offset']=qs[_0x3063('0x1c')](_0xa1d6ae[_0x3063('0x30')][_0x3063('0x1c')]);}_0x2d6a18[_0x3063('0x37')]=qs[_0x3063('0x38')](_0xa1d6ae[_0x3063('0x30')][_0x3063('0x38')]);_0x2d6a18[_0x3063('0x39')]=qs[_0x3063('0x31')](_[_0x3063('0x3a')](_0xa1d6ae[_0x3063('0x30')],_0x18f800['filters']),_0x3a88b9);if(_0xa1d6ae['query']['filter']){_0x2d6a18[_0x3063('0x39')]=_['merge'](_0x2d6a18['where'],{'$or':_[_0x3063('0x29')](_0x3a88b9,function(_0x23a821){if(_0x23a821[_0x3063('0x2c')]!==_0x3063('0x3b')){var _0x92b081={};_0x92b081[_0x23a821[_0x3063('0x28')]]={'$like':'%'+_0xa1d6ae[_0x3063('0x30')]['filter']+'%'};return _0x92b081;}})});}_0x2d6a18=_[_0x3063('0x3c')]({},_0x2d6a18,_0xa1d6ae[_0x3063('0x3d')]);var _0x9267bf={'where':_0x2d6a18[_0x3063('0x39')]};return db[_0x3063('0x2a')][_0x3063('0x1f')](_0x9267bf)[_0x3063('0x24')](function(_0x194600){_0x3e5f1f[_0x3063('0x1f')]=_0x194600;if(_0xa1d6ae[_0x3063('0x30')][_0x3063('0x3e')]){_0x2d6a18[_0x3063('0x3f')]=[{'all':!![]}];}return db[_0x3063('0x2a')][_0x3063('0x40')](_0x2d6a18);})[_0x3063('0x24')](function(_0x144288){_0x3e5f1f[_0x3063('0x41')]=_0x144288;return _0x3e5f1f;})[_0x3063('0x24')](respondWithFilteredResult(_0x540c78,_0x2d6a18))[_0x3063('0x42')](handleError(_0x540c78,null));};exports[_0x3063('0x43')]=function(_0x33722b,_0x5e8683){var _0x51e79d={'raw':![],'where':{'id':_0x33722b['params']['id']}},_0xbe5341={};_0xbe5341[_0x3063('0x2e')]=_[_0x3063('0x2f')](db['AnalyticFieldReport']['rawAttributes']);_0xbe5341['query']=_['keys'](_0x33722b[_0x3063('0x30')]);_0xbe5341[_0x3063('0x31')]=_[_0x3063('0x32')](_0xbe5341[_0x3063('0x2e')],_0xbe5341[_0x3063('0x30')]);_0x51e79d[_0x3063('0x33')]=_['intersection'](_0xbe5341[_0x3063('0x2e')],qs[_0x3063('0x34')](_0x33722b['query'][_0x3063('0x34')]));_0x51e79d['attributes']=_0x51e79d[_0x3063('0x33')][_0x3063('0x44')]?_0x51e79d[_0x3063('0x33')]:_0xbe5341[_0x3063('0x2e')];if(_0x33722b['query'][_0x3063('0x3e')]){_0x51e79d[_0x3063('0x3f')]=[{'all':!![]}];}_0x51e79d=_[_0x3063('0x3c')]({},_0x51e79d,_0x33722b[_0x3063('0x3d')]);return db[_0x3063('0x2a')][_0x3063('0x45')](_0x51e79d)['then'](handleEntityNotFound(_0x5e8683,null))['then'](respondWithResult(_0x5e8683,null))[_0x3063('0x42')](handleError(_0x5e8683,null));};exports[_0x3063('0x46')]=function(_0x2c0c03,_0x4ce1a6){return db[_0x3063('0x2a')][_0x3063('0x46')](_0x2c0c03[_0x3063('0x47')],{})['then'](respondWithResult(_0x4ce1a6,0xc9))[_0x3063('0x42')](handleError(_0x4ce1a6,null));};exports['bulkCreate']=function(_0x264e61,_0x463bf0){return db['AnalyticFieldReport'][_0x3063('0x48')](_0x264e61['body'],{'raw':![],'individualHooks':!![]})[_0x3063('0x24')](respondWithResult(_0x463bf0,0xc9))[_0x3063('0x42')](handleError(_0x463bf0,null));};exports[_0x3063('0x49')]=function(_0x5ddb6d,_0x505a45){if(_0x5ddb6d['body']['id']){delete _0x5ddb6d['body']['id'];}return db['AnalyticFieldReport'][_0x3063('0x45')]({'where':{'id':_0x5ddb6d[_0x3063('0x4a')]['id']}})[_0x3063('0x24')](handleEntityNotFound(_0x505a45,null))['then'](saveUpdates(_0x5ddb6d['body'],null))[_0x3063('0x24')](respondWithResult(_0x505a45,null))[_0x3063('0x42')](handleError(_0x505a45,null));};exports[_0x3063('0x4b')]=function(_0x117361,_0x47902b){return db[_0x3063('0x2a')]['find']({'where':{'id':_0x117361[_0x3063('0x4a')]['id']}})[_0x3063('0x24')](handleEntityNotFound(_0x47902b,null))[_0x3063('0x24')](removeEntity(_0x47902b,null))['catch'](handleError(_0x47902b,null));};exports[_0x3063('0x4c')]=function(_0x2777bd,_0x4964e9){return db['AnalyticFieldReport']['destroy']({'where':{'id':_0x2777bd[_0x3063('0x30')][_0x3063('0x4d')]||[]},'raw':![],'individualHooks':!![]})['then'](respondWithResult(_0x4964e9,0xcc))[_0x3063('0x42')](handleError(_0x4964e9,null));};exports['addFields']=function(_0x1234dc,_0x39946a,_0x5440b5){return db['AnalyticCustomReport'][_0x3063('0x4e')]({'where':{'id':_0x1234dc[_0x3063('0x4a')]['id']}})['then'](handleEntityNotFound(_0x39946a,null))[_0x3063('0x24')](function(_0x379348){if(_0x379348){return db[_0x3063('0x4f')][_0x3063('0x50')](function(_0x3127f8){return db[_0x3063('0x2a')][_0x3063('0x4b')]({'where':{'CustomReportId':_0x1234dc['params']['id']},'transaction':_0x3127f8})[_0x3063('0x24')](function(_0x20bfd0){var _0x145dd5=_[_0x3063('0x29')](_0x1234dc[_0x3063('0x47')],function(_0x4aae99){delete _0x4aae99['id'];_0x4aae99[_0x3063('0x51')]=_0x1234dc[_0x3063('0x4a')]['id'];return _0x4aae99;});return db[_0x3063('0x2a')][_0x3063('0x48')](_0x145dd5,{'transaction':_0x3127f8});});})[_0x3063('0x24')](function(){return db['AnalyticFieldReport'][_0x3063('0x40')]({'where':{'CustomReportId':_0x1234dc[_0x3063('0x4a')]['id']}});});}})[_0x3063('0x24')](respondWithResult(_0x39946a,null))[_0x3063('0x42')](handleError(_0x39946a,null));};