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 _0x637e=['sendStatus','status','end','json','count','offset','set','apply','reject','save','update','then','error','send','map','rawAttributes','fieldName','model','name','query','keys','filters','intersection','attributes','fields','length','nolimit','limit','order','sort','where','pick','filter','merge','VIRTUAL','options','AnalyticFieldReport','include','findAll','rows','catch','params','includeAll','find','create','body','bulkCreate','bulkDestroy','ids','AnalyticCustomReport','findOne','sequelize','destroy','CustomReportId','zip-dir','fast-json-patch','moment','path','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb'];(function(_0x3167a8,_0x4d5006){var _0x20073f=function(_0x5b7216){while(--_0x5b7216){_0x3167a8['push'](_0x3167a8['shift']());}};_0x20073f(++_0x4d5006);}(_0x637e,0xcc));var _0xe637=function(_0x131aac,_0x20f54c){_0x131aac=_0x131aac-0x0;var _0x240ff8=_0x637e[_0x131aac];return _0x240ff8;};'use strict';var pdf=require('html-pdf');var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0xe637('0x0'));var jsonpatch=require(_0xe637('0x1'));var rp=require('request-promise');var moment=require(_0xe637('0x2'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require('util');var path=require(_0xe637('0x3'));var sox=require('sox');var csv=require(_0xe637('0x4'));var ejs=require(_0xe637('0x5'));var fs=require('fs');var _=require(_0xe637('0x6'));var squel=require(_0xe637('0x7'));var crypto=require(_0xe637('0x8'));var jsforce=require(_0xe637('0x9'));var deskjs=require(_0xe637('0xa'));var toCsv=require(_0xe637('0x4'));var querystring=require(_0xe637('0xb'));var Papa=require('papaparse');var Redis=require(_0xe637('0xc'));var authService=require('../../components/auth/service');var qs=require(_0xe637('0xd'));var as=require(_0xe637('0xe'));var hardwareService=require(_0xe637('0xf'));var logger=require(_0xe637('0x10'))(_0xe637('0x11'));var utils=require(_0xe637('0x12'));var config=require(_0xe637('0x13'));var db=require(_0xe637('0x14'))['db'];function respondWithStatusCode(_0xf63d98,_0x517d19){_0x517d19=_0x517d19||0xcc;return function(_0x1b0f1f){if(_0x1b0f1f){return _0xf63d98[_0xe637('0x15')](_0x517d19);}return _0xf63d98[_0xe637('0x16')](_0x517d19)[_0xe637('0x17')]();};}function respondWithResult(_0x3f76b4,_0x2578f9){_0x2578f9=_0x2578f9||0xc8;return function(_0x377af1){if(_0x377af1){return _0x3f76b4[_0xe637('0x16')](_0x2578f9)[_0xe637('0x18')](_0x377af1);}};}function respondWithFilteredResult(_0x271884,_0x3982f4){return function(_0x1cf3d2){if(_0x1cf3d2){var _0x2dc1e8=_0x1cf3d2[_0xe637('0x19')],_0x453b47=_0x3982f4[_0xe637('0x1a')],_0x440e64=_0x3982f4['offset']+_0x3982f4['limit'],_0x5de76b;if(_0x440e64>=_0x2dc1e8){_0x440e64=_0x2dc1e8;_0x5de76b=0xc8;}else{_0x5de76b=0xce;}_0x271884[_0xe637('0x16')](_0x5de76b);return _0x271884[_0xe637('0x1b')]('Content-Range',_0x453b47+'-'+_0x440e64+'/'+_0x2dc1e8)['json'](_0x1cf3d2);}return null;};}function patchUpdates(_0x5b81de){return function(_0x388f58){try{jsonpatch[_0xe637('0x1c')](_0x388f58,_0x5b81de,!![]);}catch(_0x2f572f){return BPromise[_0xe637('0x1d')](_0x2f572f);}return _0x388f58[_0xe637('0x1e')]();};}function saveUpdates(_0x54438c,_0x218266){return function(_0x31fb70){if(_0x31fb70){return _0x31fb70[_0xe637('0x1f')](_0x54438c)[_0xe637('0x20')](function(_0x47504c){return _0x47504c;});}return null;};}function removeEntity(_0x48b9b6,_0x57fb07){return function(_0x80c8b8){if(_0x80c8b8){return _0x80c8b8['destroy']()[_0xe637('0x20')](function(){_0x48b9b6[_0xe637('0x16')](0xcc)['end']();});}};}function handleEntityNotFound(_0x19c489,_0x1b344e){return function(_0x8d44a1){if(!_0x8d44a1){_0x19c489[_0xe637('0x15')](0x194);}return _0x8d44a1;};}function handleError(_0x1e9162,_0x18b82b){_0x18b82b=_0x18b82b||0x1f4;return function(_0x4628d6){logger[_0xe637('0x21')](_0x4628d6['stack']);if(_0x4628d6['name']){delete _0x4628d6['name'];}_0x1e9162[_0xe637('0x16')](_0x18b82b)[_0xe637('0x22')](_0x4628d6);};}exports['index']=function(_0x387745,_0x1f3f9e){var _0x2e9dcb={},_0x3d8f23={},_0x38c2dd={'count':0x0,'rows':[]};var _0xdf0a38=_[_0xe637('0x23')](db['AnalyticFieldReport'][_0xe637('0x24')],function(_0x467fc8){return{'name':_0x467fc8[_0xe637('0x25')],'type':_0x467fc8['type']['key']};});_0x3d8f23[_0xe637('0x26')]=_['map'](_0xdf0a38,_0xe637('0x27'));_0x3d8f23[_0xe637('0x28')]=_[_0xe637('0x29')](_0x387745[_0xe637('0x28')]);_0x3d8f23[_0xe637('0x2a')]=_[_0xe637('0x2b')](_0x3d8f23[_0xe637('0x26')],_0x3d8f23[_0xe637('0x28')]);_0x2e9dcb[_0xe637('0x2c')]=_[_0xe637('0x2b')](_0x3d8f23[_0xe637('0x26')],qs[_0xe637('0x2d')](_0x387745[_0xe637('0x28')][_0xe637('0x2d')]));_0x2e9dcb[_0xe637('0x2c')]=_0x2e9dcb[_0xe637('0x2c')][_0xe637('0x2e')]?_0x2e9dcb[_0xe637('0x2c')]:_0x3d8f23[_0xe637('0x26')];if(!_0x387745[_0xe637('0x28')]['hasOwnProperty'](_0xe637('0x2f'))){_0x2e9dcb[_0xe637('0x30')]=qs['limit'](_0x387745[_0xe637('0x28')]['limit']);_0x2e9dcb[_0xe637('0x1a')]=qs[_0xe637('0x1a')](_0x387745['query'][_0xe637('0x1a')]);}_0x2e9dcb[_0xe637('0x31')]=qs['sort'](_0x387745[_0xe637('0x28')][_0xe637('0x32')]);_0x2e9dcb[_0xe637('0x33')]=qs[_0xe637('0x2a')](_[_0xe637('0x34')](_0x387745['query'],_0x3d8f23[_0xe637('0x2a')]),_0xdf0a38);if(_0x387745[_0xe637('0x28')][_0xe637('0x35')]){_0x2e9dcb[_0xe637('0x33')]=_[_0xe637('0x36')](_0x2e9dcb[_0xe637('0x33')],{'$or':_[_0xe637('0x23')](_0xdf0a38,function(_0x2f5229){if(_0x2f5229['type']!==_0xe637('0x37')){var _0x19b935={};_0x19b935[_0x2f5229[_0xe637('0x27')]]={'$like':'%'+_0x387745['query'][_0xe637('0x35')]+'%'};return _0x19b935;}})});}_0x2e9dcb=_[_0xe637('0x36')]({},_0x2e9dcb,_0x387745[_0xe637('0x38')]);var _0x30ff25={'where':_0x2e9dcb[_0xe637('0x33')]};return db[_0xe637('0x39')][_0xe637('0x19')](_0x30ff25)[_0xe637('0x20')](function(_0x4db487){_0x38c2dd[_0xe637('0x19')]=_0x4db487;if(_0x387745[_0xe637('0x28')]['includeAll']){_0x2e9dcb[_0xe637('0x3a')]=[{'all':!![]}];}return db['AnalyticFieldReport'][_0xe637('0x3b')](_0x2e9dcb);})[_0xe637('0x20')](function(_0x169ac2){_0x38c2dd[_0xe637('0x3c')]=_0x169ac2;return _0x38c2dd;})[_0xe637('0x20')](respondWithFilteredResult(_0x1f3f9e,_0x2e9dcb))[_0xe637('0x3d')](handleError(_0x1f3f9e,null));};exports['show']=function(_0x1420f0,_0x3561db){var _0x3a04dd={'raw':![],'where':{'id':_0x1420f0[_0xe637('0x3e')]['id']}},_0x5a6913={};_0x5a6913[_0xe637('0x26')]=_[_0xe637('0x29')](db['AnalyticFieldReport'][_0xe637('0x24')]);_0x5a6913[_0xe637('0x28')]=_[_0xe637('0x29')](_0x1420f0['query']);_0x5a6913[_0xe637('0x2a')]=_['intersection'](_0x5a6913['model'],_0x5a6913[_0xe637('0x28')]);_0x3a04dd[_0xe637('0x2c')]=_['intersection'](_0x5a6913['model'],qs[_0xe637('0x2d')](_0x1420f0[_0xe637('0x28')][_0xe637('0x2d')]));_0x3a04dd[_0xe637('0x2c')]=_0x3a04dd[_0xe637('0x2c')][_0xe637('0x2e')]?_0x3a04dd[_0xe637('0x2c')]:_0x5a6913['model'];if(_0x1420f0[_0xe637('0x28')][_0xe637('0x3f')]){_0x3a04dd[_0xe637('0x3a')]=[{'all':!![]}];}_0x3a04dd=_[_0xe637('0x36')]({},_0x3a04dd,_0x1420f0[_0xe637('0x38')]);return db[_0xe637('0x39')][_0xe637('0x40')](_0x3a04dd)[_0xe637('0x20')](handleEntityNotFound(_0x3561db,null))['then'](respondWithResult(_0x3561db,null))[_0xe637('0x3d')](handleError(_0x3561db,null));};exports[_0xe637('0x41')]=function(_0x17fe46,_0x31d102){return db[_0xe637('0x39')]['create'](_0x17fe46[_0xe637('0x42')],{})[_0xe637('0x20')](respondWithResult(_0x31d102,0xc9))['catch'](handleError(_0x31d102,null));};exports[_0xe637('0x43')]=function(_0x4fa534,_0x4ecc77){return db[_0xe637('0x39')][_0xe637('0x43')](_0x4fa534['body'],{'raw':![],'individualHooks':!![]})[_0xe637('0x20')](respondWithResult(_0x4ecc77,0xc9))['catch'](handleError(_0x4ecc77,null));};exports[_0xe637('0x1f')]=function(_0x2a1eda,_0x115855){if(_0x2a1eda[_0xe637('0x42')]['id']){delete _0x2a1eda['body']['id'];}return db[_0xe637('0x39')]['find']({'where':{'id':_0x2a1eda[_0xe637('0x3e')]['id']}})[_0xe637('0x20')](handleEntityNotFound(_0x115855,null))['then'](saveUpdates(_0x2a1eda['body'],null))[_0xe637('0x20')](respondWithResult(_0x115855,null))[_0xe637('0x3d')](handleError(_0x115855,null));};exports['destroy']=function(_0x59e9fd,_0xdcec84){return db['AnalyticFieldReport'][_0xe637('0x40')]({'where':{'id':_0x59e9fd[_0xe637('0x3e')]['id']}})[_0xe637('0x20')](handleEntityNotFound(_0xdcec84,null))[_0xe637('0x20')](removeEntity(_0xdcec84,null))[_0xe637('0x3d')](handleError(_0xdcec84,null));};exports[_0xe637('0x44')]=function(_0x3c4ad5,_0x4de117){return db[_0xe637('0x39')]['destroy']({'where':{'id':_0x3c4ad5['query'][_0xe637('0x45')]||[]},'raw':![],'individualHooks':!![]})[_0xe637('0x20')](respondWithResult(_0x4de117,0xcc))[_0xe637('0x3d')](handleError(_0x4de117,null));};exports['addFields']=function(_0x234e36,_0x49a426,_0x39341c){return db[_0xe637('0x46')][_0xe637('0x47')]({'where':{'id':_0x234e36[_0xe637('0x3e')]['id']}})[_0xe637('0x20')](handleEntityNotFound(_0x49a426,null))[_0xe637('0x20')](function(_0x1b3c20){if(_0x1b3c20){return db[_0xe637('0x48')]['transaction'](function(_0xdbf9e3){return db[_0xe637('0x39')][_0xe637('0x49')]({'where':{'CustomReportId':_0x234e36[_0xe637('0x3e')]['id']},'transaction':_0xdbf9e3})[_0xe637('0x20')](function(_0x5774a4){var _0x26801e=_[_0xe637('0x23')](_0x234e36[_0xe637('0x42')],function(_0x36e734){delete _0x36e734['id'];_0x36e734[_0xe637('0x4a')]=_0x234e36[_0xe637('0x3e')]['id'];return _0x36e734;});return db[_0xe637('0x39')][_0xe637('0x43')](_0x26801e,{'transaction':_0xdbf9e3});});})[_0xe637('0x20')](function(){return db[_0xe637('0x39')][_0xe637('0x3b')]({'where':{'CustomReportId':_0x234e36[_0xe637('0x3e')]['id']}});});}})[_0xe637('0x20')](respondWithResult(_0x49a426,null))[_0xe637('0x3d')](handleError(_0x49a426,null));};