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 _0x288a=['fast-json-patch','bluebird','util','path','sox','ejs','lodash','squel','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','api','../../config/utils','../../mysqldb','sendStatus','status','end','json','count','offset','limit','set','Content-Range','apply','save','update','then','error','stack','name','send','index','map','AnalyticFieldReport','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','filter','where','VIRTUAL','merge','includeAll','include','catch','show','params','options','create','body','bulkCreate','destroy','find','bulkDestroy','AnalyticCustomReport','findOne','sequelize','transaction','CustomReportId','eml-format','rimraf','zip-dir'];(function(_0x2f086b,_0x5333f7){var _0x330112=function(_0x9b07d9){while(--_0x9b07d9){_0x2f086b['push'](_0x2f086b['shift']());}};_0x330112(++_0x5333f7);}(_0x288a,0x188));var _0xa288=function(_0x1ae27f,_0x56ddac){_0x1ae27f=_0x1ae27f-0x0;var _0x2cd8ae=_0x288a[_0x1ae27f];return _0x2cd8ae;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0xa288('0x0'));var rimraf=require(_0xa288('0x1'));var zipdir=require(_0xa288('0x2'));var jsonpatch=require(_0xa288('0x3'));var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0xa288('0x4'));var Mustache=require('mustache');var util=require(_0xa288('0x5'));var path=require(_0xa288('0x6'));var sox=require(_0xa288('0x7'));var csv=require('to-csv');var ejs=require(_0xa288('0x8'));var fs=require('fs');var _=require(_0xa288('0x9'));var squel=require(_0xa288('0xa'));var crypto=require('crypto');var jsforce=require(_0xa288('0xb'));var deskjs=require(_0xa288('0xc'));var toCsv=require(_0xa288('0xd'));var querystring=require(_0xa288('0xe'));var Papa=require(_0xa288('0xf'));var Redis=require(_0xa288('0x10'));var authService=require(_0xa288('0x11'));var qs=require(_0xa288('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0xa288('0x13'));var utils=require(_0xa288('0x14'));var config=require('../../config/environment');var db=require(_0xa288('0x15'))['db'];function respondWithStatusCode(_0x46d577,_0x3ea123){_0x3ea123=_0x3ea123||0xcc;return function(_0x1cabf2){if(_0x1cabf2){return _0x46d577[_0xa288('0x16')](_0x3ea123);}return _0x46d577[_0xa288('0x17')](_0x3ea123)[_0xa288('0x18')]();};}function respondWithResult(_0x22f401,_0x3a529f){_0x3a529f=_0x3a529f||0xc8;return function(_0x687ba8){if(_0x687ba8){return _0x22f401[_0xa288('0x17')](_0x3a529f)[_0xa288('0x19')](_0x687ba8);}};}function respondWithFilteredResult(_0x31d950,_0x2ab249){return function(_0x21ec88){if(_0x21ec88){var _0x138b4e=_0x21ec88[_0xa288('0x1a')],_0x571259=_0x2ab249[_0xa288('0x1b')],_0xc060c2=_0x2ab249[_0xa288('0x1b')]+_0x2ab249[_0xa288('0x1c')],_0x24883d;if(_0xc060c2>=_0x138b4e){_0xc060c2=_0x138b4e;_0x24883d=0xc8;}else{_0x24883d=0xce;}_0x31d950['status'](_0x24883d);return _0x31d950[_0xa288('0x1d')](_0xa288('0x1e'),_0x571259+'-'+_0xc060c2+'/'+_0x138b4e)['json'](_0x21ec88);}return null;};}function patchUpdates(_0x58fa1a){return function(_0x3558f4){try{jsonpatch[_0xa288('0x1f')](_0x3558f4,_0x58fa1a,!![]);}catch(_0x46e988){return BPromise['reject'](_0x46e988);}return _0x3558f4[_0xa288('0x20')]();};}function saveUpdates(_0x2dfb2d,_0x1979d9){return function(_0x4c489e){if(_0x4c489e){return _0x4c489e[_0xa288('0x21')](_0x2dfb2d)[_0xa288('0x22')](function(_0x200839){return _0x200839;});}return null;};}function removeEntity(_0x1d85e3,_0x32e47d){return function(_0x51c835){if(_0x51c835){return _0x51c835['destroy']()[_0xa288('0x22')](function(){_0x1d85e3[_0xa288('0x17')](0xcc)[_0xa288('0x18')]();});}};}function handleEntityNotFound(_0x2f9465,_0x4895bb){return function(_0x21eebc){if(!_0x21eebc){_0x2f9465[_0xa288('0x16')](0x194);}return _0x21eebc;};}function handleError(_0x1f94ab,_0x3fe4b0){_0x3fe4b0=_0x3fe4b0||0x1f4;return function(_0x44f4a4){logger[_0xa288('0x23')](_0x44f4a4[_0xa288('0x24')]);if(_0x44f4a4[_0xa288('0x25')]){delete _0x44f4a4[_0xa288('0x25')];}_0x1f94ab[_0xa288('0x17')](_0x3fe4b0)[_0xa288('0x26')](_0x44f4a4);};}exports[_0xa288('0x27')]=function(_0x2755fc,_0xb3d84d){var _0x26b038={},_0x5878fb={},_0x5575eb={'count':0x0,'rows':[]};var _0x3a429e=_[_0xa288('0x28')](db[_0xa288('0x29')][_0xa288('0x2a')],function(_0x3b2d3e){return{'name':_0x3b2d3e[_0xa288('0x2b')],'type':_0x3b2d3e[_0xa288('0x2c')][_0xa288('0x2d')]};});_0x5878fb[_0xa288('0x2e')]=_[_0xa288('0x28')](_0x3a429e,_0xa288('0x25'));_0x5878fb[_0xa288('0x2f')]=_[_0xa288('0x30')](_0x2755fc[_0xa288('0x2f')]);_0x5878fb[_0xa288('0x31')]=_[_0xa288('0x32')](_0x5878fb[_0xa288('0x2e')],_0x5878fb['query']);_0x26b038[_0xa288('0x33')]=_['intersection'](_0x5878fb[_0xa288('0x2e')],qs[_0xa288('0x34')](_0x2755fc[_0xa288('0x2f')]['fields']));_0x26b038[_0xa288('0x33')]=_0x26b038[_0xa288('0x33')][_0xa288('0x35')]?_0x26b038[_0xa288('0x33')]:_0x5878fb[_0xa288('0x2e')];if(!_0x2755fc[_0xa288('0x2f')][_0xa288('0x36')](_0xa288('0x37'))){_0x26b038[_0xa288('0x1c')]=qs['limit'](_0x2755fc['query']['limit']);_0x26b038[_0xa288('0x1b')]=qs['offset'](_0x2755fc[_0xa288('0x2f')][_0xa288('0x1b')]);}_0x26b038[_0xa288('0x38')]=qs[_0xa288('0x39')](_0x2755fc[_0xa288('0x2f')][_0xa288('0x39')]);_0x26b038['where']=qs['filters'](_['pick'](_0x2755fc[_0xa288('0x2f')],_0x5878fb[_0xa288('0x31')]));if(_0x2755fc['query'][_0xa288('0x3a')]){_0x26b038[_0xa288('0x3b')]=_['merge'](_0x26b038[_0xa288('0x3b')],{'$or':_[_0xa288('0x28')](_0x3a429e,function(_0x347d56){if(_0x347d56[_0xa288('0x2c')]!==_0xa288('0x3c')){var _0x1fbcbc={};_0x1fbcbc[_0x347d56['name']]={'$like':'%'+_0x2755fc[_0xa288('0x2f')][_0xa288('0x3a')]+'%'};return _0x1fbcbc;}})});}_0x26b038=_[_0xa288('0x3d')]({},_0x26b038,_0x2755fc['options']);var _0x241d4f={'where':_0x26b038[_0xa288('0x3b')]};return db[_0xa288('0x29')][_0xa288('0x1a')](_0x241d4f)[_0xa288('0x22')](function(_0x2f3c68){_0x5575eb[_0xa288('0x1a')]=_0x2f3c68;if(_0x2755fc['query'][_0xa288('0x3e')]){_0x26b038[_0xa288('0x3f')]=[{'all':!![]}];}return db[_0xa288('0x29')]['findAll'](_0x26b038);})[_0xa288('0x22')](function(_0x201bc0){_0x5575eb['rows']=_0x201bc0;return _0x5575eb;})[_0xa288('0x22')](respondWithFilteredResult(_0xb3d84d,_0x26b038))[_0xa288('0x40')](handleError(_0xb3d84d,null));};exports[_0xa288('0x41')]=function(_0x5835ed,_0x933982){var _0x2a4ead={'raw':![],'where':{'id':_0x5835ed[_0xa288('0x42')]['id']}},_0x535866={};_0x535866[_0xa288('0x2e')]=_[_0xa288('0x30')](db[_0xa288('0x29')][_0xa288('0x2a')]);_0x535866['query']=_[_0xa288('0x30')](_0x5835ed[_0xa288('0x2f')]);_0x535866[_0xa288('0x31')]=_[_0xa288('0x32')](_0x535866[_0xa288('0x2e')],_0x535866[_0xa288('0x2f')]);_0x2a4ead[_0xa288('0x33')]=_[_0xa288('0x32')](_0x535866[_0xa288('0x2e')],qs[_0xa288('0x34')](_0x5835ed[_0xa288('0x2f')]['fields']));_0x2a4ead['attributes']=_0x2a4ead[_0xa288('0x33')][_0xa288('0x35')]?_0x2a4ead[_0xa288('0x33')]:_0x535866['model'];if(_0x5835ed['query'][_0xa288('0x3e')]){_0x2a4ead[_0xa288('0x3f')]=[{'all':!![]}];}_0x2a4ead=_['merge']({},_0x2a4ead,_0x5835ed[_0xa288('0x43')]);return db['AnalyticFieldReport']['find'](_0x2a4ead)[_0xa288('0x22')](handleEntityNotFound(_0x933982,null))[_0xa288('0x22')](respondWithResult(_0x933982,null))[_0xa288('0x40')](handleError(_0x933982,null));};exports['create']=function(_0x2578c6,_0x39e116){return db[_0xa288('0x29')][_0xa288('0x44')](_0x2578c6[_0xa288('0x45')],{})[_0xa288('0x22')](respondWithResult(_0x39e116,0xc9))['catch'](handleError(_0x39e116,null));};exports[_0xa288('0x46')]=function(_0x5b56f3,_0x2013be){return db[_0xa288('0x29')][_0xa288('0x46')](_0x5b56f3[_0xa288('0x45')],{'raw':![],'individualHooks':!![]})[_0xa288('0x22')](respondWithResult(_0x2013be,0xc9))[_0xa288('0x40')](handleError(_0x2013be,null));};exports[_0xa288('0x21')]=function(_0x1a3dff,_0x6d79c){if(_0x1a3dff[_0xa288('0x45')]['id']){delete _0x1a3dff[_0xa288('0x45')]['id'];}return db[_0xa288('0x29')]['find']({'where':{'id':_0x1a3dff[_0xa288('0x42')]['id']}})[_0xa288('0x22')](handleEntityNotFound(_0x6d79c,null))['then'](saveUpdates(_0x1a3dff['body'],null))[_0xa288('0x22')](respondWithResult(_0x6d79c,null))[_0xa288('0x40')](handleError(_0x6d79c,null));};exports[_0xa288('0x47')]=function(_0x5156c2,_0x48a9e0){return db[_0xa288('0x29')][_0xa288('0x48')]({'where':{'id':_0x5156c2[_0xa288('0x42')]['id']}})['then'](handleEntityNotFound(_0x48a9e0,null))[_0xa288('0x22')](removeEntity(_0x48a9e0,null))[_0xa288('0x40')](handleError(_0x48a9e0,null));};exports[_0xa288('0x49')]=function(_0x1a00be,_0x2c7641){return db['AnalyticFieldReport'][_0xa288('0x47')]({'where':{'id':_0x1a00be[_0xa288('0x2f')]['ids']||[]},'raw':![],'individualHooks':!![]})[_0xa288('0x22')](respondWithResult(_0x2c7641,0xcc))['catch'](handleError(_0x2c7641,null));};exports['addFields']=function(_0x5a561d,_0x1af83e,_0xe91dc2){return db[_0xa288('0x4a')][_0xa288('0x4b')]({'where':{'id':_0x5a561d['params']['id']}})[_0xa288('0x22')](handleEntityNotFound(_0x1af83e,null))[_0xa288('0x22')](function(_0x5deef5){if(_0x5deef5){return db[_0xa288('0x4c')][_0xa288('0x4d')](function(_0x3b8737){return db[_0xa288('0x29')][_0xa288('0x47')]({'where':{'CustomReportId':_0x5a561d[_0xa288('0x42')]['id']},'transaction':_0x3b8737})[_0xa288('0x22')](function(_0x4a8ee4){var _0x6b1448=_[_0xa288('0x28')](_0x5a561d[_0xa288('0x45')],function(_0x2ff9fa){delete _0x2ff9fa['id'];_0x2ff9fa[_0xa288('0x4e')]=_0x5a561d[_0xa288('0x42')]['id'];return _0x2ff9fa;});return db[_0xa288('0x29')][_0xa288('0x46')](_0x6b1448,{'transaction':_0x3b8737});});})['then'](function(){return db[_0xa288('0x29')]['findAll']({'where':{'CustomReportId':_0x5a561d[_0xa288('0x42')]['id']}});});}})['then'](respondWithResult(_0x1af83e,null))[_0xa288('0x40')](handleError(_0x1af83e,null));};