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 _0x7051=['intersection','fields','attributes','hasOwnProperty','order','sort','where','pick','filter','merge','type','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','AnalyticFieldReport','length','find','create','body','bulkCreate','params','bulkDestroy','findOne','sequelize','transaction','CustomReportId','eml-format','request-promise','moment','bluebird','mustache','util','sox','to-csv','fs-extra','lodash','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','then','destroy','error','stack','name','send','index','map','rawAttributes','fieldName','key','model','query','keys','filters'];(function(_0x40a045,_0x516f0e){var _0x1a687c=function(_0x48c9fe){while(--_0x48c9fe){_0x40a045['push'](_0x40a045['shift']());}};_0x1a687c(++_0x516f0e);}(_0x7051,0x11b));var _0x1705=function(_0x20aadb,_0x5a607a){_0x20aadb=_0x20aadb-0x0;var _0x520018=_0x7051[_0x20aadb];return _0x520018;};'use strict';var emlformat=require(_0x1705('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0x1705('0x1'));var moment=require(_0x1705('0x2'));var BPromise=require(_0x1705('0x3'));var Mustache=require(_0x1705('0x4'));var util=require(_0x1705('0x5'));var path=require('path');var sox=require(_0x1705('0x6'));var csv=require(_0x1705('0x7'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x1705('0x8'));var _=require(_0x1705('0x9'));var squel=require(_0x1705('0xa'));var crypto=require(_0x1705('0xb'));var jsforce=require(_0x1705('0xc'));var deskjs=require('desk.js');var toCsv=require(_0x1705('0x7'));var querystring=require(_0x1705('0xd'));var Papa=require(_0x1705('0xe'));var Redis=require(_0x1705('0xf'));var authService=require(_0x1705('0x10'));var qs=require(_0x1705('0x11'));var as=require(_0x1705('0x12'));var hardwareService=require(_0x1705('0x13'));var logger=require('../../config/logger')(_0x1705('0x14'));var utils=require('../../config/utils');var config=require(_0x1705('0x15'));var licenseUtil=require(_0x1705('0x16'));var db=require(_0x1705('0x17'))['db'];function respondWithStatusCode(_0xe1b70,_0x1c116b){_0x1c116b=_0x1c116b||0xcc;return function(_0x5122be){if(_0x5122be){return _0xe1b70[_0x1705('0x18')](_0x1c116b);}return _0xe1b70[_0x1705('0x19')](_0x1c116b)[_0x1705('0x1a')]();};}function respondWithResult(_0x7e7c4b,_0x2ebeb7){_0x2ebeb7=_0x2ebeb7||0xc8;return function(_0x19177b){if(_0x19177b){return _0x7e7c4b[_0x1705('0x19')](_0x2ebeb7)[_0x1705('0x1b')](_0x19177b);}};}function respondWithFilteredResult(_0x5e9834,_0x24fc8e){return function(_0x3367ea){if(_0x3367ea){var _0x1952a3=typeof _0x24fc8e[_0x1705('0x1c')]===_0x1705('0x1d')&&typeof _0x24fc8e[_0x1705('0x1e')]===_0x1705('0x1d');var _0x55c66d=_0x3367ea[_0x1705('0x1f')];var _0x45b0d6=_0x1952a3?0x0:_0x24fc8e['offset'];var _0x2fdfc2=_0x1952a3?_0x3367ea[_0x1705('0x1f')]:_0x24fc8e[_0x1705('0x1c')]+_0x24fc8e['limit'];var _0x194e5a;if(_0x2fdfc2>=_0x55c66d){_0x2fdfc2=_0x55c66d;_0x194e5a=0xc8;}else{_0x194e5a=0xce;}_0x5e9834[_0x1705('0x19')](_0x194e5a);return _0x5e9834[_0x1705('0x20')](_0x1705('0x21'),_0x45b0d6+'-'+_0x2fdfc2+'/'+_0x55c66d)[_0x1705('0x1b')](_0x3367ea);}return null;};}function patchUpdates(_0x320440){return function(_0x30c08a){try{jsonpatch[_0x1705('0x22')](_0x30c08a,_0x320440,!![]);}catch(_0x207a71){return BPromise[_0x1705('0x23')](_0x207a71);}return _0x30c08a[_0x1705('0x24')]();};}function saveUpdates(_0x409b94,_0x2d2ea1){return function(_0x1c7c66){if(_0x1c7c66){return _0x1c7c66[_0x1705('0x25')](_0x409b94)[_0x1705('0x26')](function(_0x56e8f3){return _0x56e8f3;});}return null;};}function removeEntity(_0x4bfc6a,_0x238665){return function(_0x12e9d8){if(_0x12e9d8){return _0x12e9d8[_0x1705('0x27')]()[_0x1705('0x26')](function(){_0x4bfc6a[_0x1705('0x19')](0xcc)[_0x1705('0x1a')]();});}};}function handleEntityNotFound(_0x2459a3,_0x1a06e6){return function(_0x80c9ea){if(!_0x80c9ea){_0x2459a3[_0x1705('0x18')](0x194);}return _0x80c9ea;};}function handleError(_0x17e11f,_0x3e80a0){_0x3e80a0=_0x3e80a0||0x1f4;return function(_0x283431){logger[_0x1705('0x28')](_0x283431[_0x1705('0x29')]);if(_0x283431[_0x1705('0x2a')]){delete _0x283431['name'];}_0x17e11f['status'](_0x3e80a0)[_0x1705('0x2b')](_0x283431);};}exports[_0x1705('0x2c')]=function(_0x4981e3,_0x163ab3){var _0x59a820={},_0x34fea2={},_0x3d69f9={'count':0x0,'rows':[]};var _0x16317a=_[_0x1705('0x2d')](db['AnalyticFieldReport'][_0x1705('0x2e')],function(_0x4303c9){return{'name':_0x4303c9[_0x1705('0x2f')],'type':_0x4303c9['type'][_0x1705('0x30')]};});_0x34fea2[_0x1705('0x31')]=_[_0x1705('0x2d')](_0x16317a,_0x1705('0x2a'));_0x34fea2[_0x1705('0x32')]=_[_0x1705('0x33')](_0x4981e3[_0x1705('0x32')]);_0x34fea2[_0x1705('0x34')]=_[_0x1705('0x35')](_0x34fea2[_0x1705('0x31')],_0x34fea2['query']);_0x59a820['attributes']=_[_0x1705('0x35')](_0x34fea2[_0x1705('0x31')],qs[_0x1705('0x36')](_0x4981e3[_0x1705('0x32')]['fields']));_0x59a820[_0x1705('0x37')]=_0x59a820[_0x1705('0x37')]['length']?_0x59a820[_0x1705('0x37')]:_0x34fea2['model'];if(!_0x4981e3[_0x1705('0x32')][_0x1705('0x38')]('nolimit')){_0x59a820[_0x1705('0x1e')]=qs[_0x1705('0x1e')](_0x4981e3[_0x1705('0x32')][_0x1705('0x1e')]);_0x59a820[_0x1705('0x1c')]=qs[_0x1705('0x1c')](_0x4981e3['query']['offset']);}_0x59a820[_0x1705('0x39')]=qs[_0x1705('0x3a')](_0x4981e3['query'][_0x1705('0x3a')]);_0x59a820[_0x1705('0x3b')]=qs['filters'](_[_0x1705('0x3c')](_0x4981e3[_0x1705('0x32')],_0x34fea2[_0x1705('0x34')]),_0x16317a);if(_0x4981e3['query'][_0x1705('0x3d')]){_0x59a820[_0x1705('0x3b')]=_[_0x1705('0x3e')](_0x59a820[_0x1705('0x3b')],{'$or':_[_0x1705('0x2d')](_0x16317a,function(_0x58868c){if(_0x58868c[_0x1705('0x3f')]!==_0x1705('0x40')){var _0x4e30ae={};_0x4e30ae[_0x58868c['name']]={'$like':'%'+_0x4981e3[_0x1705('0x32')][_0x1705('0x3d')]+'%'};return _0x4e30ae;}})});}_0x59a820=_[_0x1705('0x3e')]({},_0x59a820,_0x4981e3[_0x1705('0x41')]);var _0x100b34={'where':_0x59a820[_0x1705('0x3b')]};return db['AnalyticFieldReport'][_0x1705('0x1f')](_0x100b34)[_0x1705('0x26')](function(_0x59f961){_0x3d69f9['count']=_0x59f961;if(_0x4981e3[_0x1705('0x32')][_0x1705('0x42')]){_0x59a820[_0x1705('0x43')]=[{'all':!![]}];}return db['AnalyticFieldReport'][_0x1705('0x44')](_0x59a820);})[_0x1705('0x26')](function(_0x1ca6f2){_0x3d69f9[_0x1705('0x45')]=_0x1ca6f2;return _0x3d69f9;})[_0x1705('0x26')](respondWithFilteredResult(_0x163ab3,_0x59a820))[_0x1705('0x46')](handleError(_0x163ab3,null));};exports[_0x1705('0x47')]=function(_0x23fc55,_0x283fb4){var _0x4441e6={'raw':![],'where':{'id':_0x23fc55['params']['id']}},_0x126c8e={};_0x126c8e['model']=_[_0x1705('0x33')](db[_0x1705('0x48')][_0x1705('0x2e')]);_0x126c8e[_0x1705('0x32')]=_[_0x1705('0x33')](_0x23fc55[_0x1705('0x32')]);_0x126c8e[_0x1705('0x34')]=_[_0x1705('0x35')](_0x126c8e[_0x1705('0x31')],_0x126c8e[_0x1705('0x32')]);_0x4441e6[_0x1705('0x37')]=_[_0x1705('0x35')](_0x126c8e[_0x1705('0x31')],qs[_0x1705('0x36')](_0x23fc55[_0x1705('0x32')][_0x1705('0x36')]));_0x4441e6[_0x1705('0x37')]=_0x4441e6[_0x1705('0x37')][_0x1705('0x49')]?_0x4441e6[_0x1705('0x37')]:_0x126c8e[_0x1705('0x31')];if(_0x23fc55[_0x1705('0x32')][_0x1705('0x42')]){_0x4441e6[_0x1705('0x43')]=[{'all':!![]}];}_0x4441e6=_['merge']({},_0x4441e6,_0x23fc55[_0x1705('0x41')]);return db[_0x1705('0x48')][_0x1705('0x4a')](_0x4441e6)[_0x1705('0x26')](handleEntityNotFound(_0x283fb4,null))['then'](respondWithResult(_0x283fb4,null))[_0x1705('0x46')](handleError(_0x283fb4,null));};exports[_0x1705('0x4b')]=function(_0x2214d7,_0x442f3f){return db[_0x1705('0x48')][_0x1705('0x4b')](_0x2214d7[_0x1705('0x4c')],{})[_0x1705('0x26')](respondWithResult(_0x442f3f,0xc9))[_0x1705('0x46')](handleError(_0x442f3f,null));};exports[_0x1705('0x4d')]=function(_0xbe19f3,_0x394154){return db['AnalyticFieldReport'][_0x1705('0x4d')](_0xbe19f3['body'],{'raw':![],'individualHooks':!![]})[_0x1705('0x26')](respondWithResult(_0x394154,0xc9))[_0x1705('0x46')](handleError(_0x394154,null));};exports[_0x1705('0x25')]=function(_0x4d0c55,_0x480e81){if(_0x4d0c55[_0x1705('0x4c')]['id']){delete _0x4d0c55[_0x1705('0x4c')]['id'];}return db['AnalyticFieldReport'][_0x1705('0x4a')]({'where':{'id':_0x4d0c55['params']['id']}})[_0x1705('0x26')](handleEntityNotFound(_0x480e81,null))[_0x1705('0x26')](saveUpdates(_0x4d0c55[_0x1705('0x4c')],null))[_0x1705('0x26')](respondWithResult(_0x480e81,null))[_0x1705('0x46')](handleError(_0x480e81,null));};exports[_0x1705('0x27')]=function(_0x99f27b,_0x22fd3a){return db[_0x1705('0x48')][_0x1705('0x4a')]({'where':{'id':_0x99f27b[_0x1705('0x4e')]['id']}})['then'](handleEntityNotFound(_0x22fd3a,null))[_0x1705('0x26')](removeEntity(_0x22fd3a,null))[_0x1705('0x46')](handleError(_0x22fd3a,null));};exports[_0x1705('0x4f')]=function(_0x2f1910,_0x545f84){return db[_0x1705('0x48')]['destroy']({'where':{'id':_0x2f1910[_0x1705('0x32')]['ids']||[]},'raw':![],'individualHooks':!![]})['then'](respondWithResult(_0x545f84,0xcc))[_0x1705('0x46')](handleError(_0x545f84,null));};exports['addFields']=function(_0x49ca92,_0x270a03,_0x6792b3){return db['AnalyticCustomReport'][_0x1705('0x50')]({'where':{'id':_0x49ca92[_0x1705('0x4e')]['id']}})[_0x1705('0x26')](handleEntityNotFound(_0x270a03,null))[_0x1705('0x26')](function(_0x54c492){if(_0x54c492){return db[_0x1705('0x51')][_0x1705('0x52')](function(_0x42d773){return db[_0x1705('0x48')][_0x1705('0x27')]({'where':{'CustomReportId':_0x49ca92[_0x1705('0x4e')]['id']},'transaction':_0x42d773})[_0x1705('0x26')](function(_0x52ed7c){var _0x56c198=_[_0x1705('0x2d')](_0x49ca92[_0x1705('0x4c')],function(_0x6bc39f){delete _0x6bc39f['id'];_0x6bc39f[_0x1705('0x53')]=_0x49ca92[_0x1705('0x4e')]['id'];return _0x6bc39f;});return db['AnalyticFieldReport']['bulkCreate'](_0x56c198,{'transaction':_0x42d773});});})[_0x1705('0x26')](function(){return db[_0x1705('0x48')]['findAll']({'where':{'CustomReportId':_0x49ca92[_0x1705('0x4e')]['id']}});});}})[_0x1705('0x26')](respondWithResult(_0x270a03,null))[_0x1705('0x46')](handleError(_0x270a03,null));};