server/api/variable/variable.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 _0x8c76=['crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/advancedSearch','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','sendStatus','status','end','json','offset','undefined','count','limit','set','Content-Range','reject','save','update','then','destroy','get','Variables','UserProfileResource','error','stack','name','send','index','map','Variable','rawAttributes','fieldName','type','key','query','keys','filters','model','attributes','intersection','fields','length','order','sort','where','filter','merge','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','params','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','eml-format','zip-dir','request-promise','moment','bluebird','util','path','ejs','lodash','squel'];(function(_0x47bc69,_0x5f0e45){var _0x241afb=function(_0x2b1793){while(--_0x2b1793){_0x47bc69['push'](_0x47bc69['shift']());}};_0x241afb(++_0x5f0e45);}(_0x8c76,0x190));var _0x68c7=function(_0x446ab2,_0x5621b8){_0x446ab2=_0x446ab2-0x0;var _0x11e42b=_0x8c76[_0x446ab2];return _0x11e42b;};'use strict';var emlformat=require(_0x68c7('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x68c7('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0x68c7('0x2'));var moment=require(_0x68c7('0x3'));var BPromise=require(_0x68c7('0x4'));var Mustache=require('mustache');var util=require(_0x68c7('0x5'));var path=require(_0x68c7('0x6'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x68c7('0x7'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x68c7('0x8'));var squel=require(_0x68c7('0x9'));var crypto=require(_0x68c7('0xa'));var jsforce=require(_0x68c7('0xb'));var deskjs=require(_0x68c7('0xc'));var toCsv=require('to-csv');var querystring=require(_0x68c7('0xd'));var Papa=require(_0x68c7('0xe'));var Redis=require(_0x68c7('0xf'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0x68c7('0x10'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x68c7('0x11'))('api');var utils=require(_0x68c7('0x12'));var config=require(_0x68c7('0x13'));var licenseUtil=require(_0x68c7('0x14'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x49e9e7,_0x5a456a){_0x5a456a=_0x5a456a||0xcc;return function(_0xcb0017){if(_0xcb0017){return _0x49e9e7[_0x68c7('0x15')](_0x5a456a);}return _0x49e9e7[_0x68c7('0x16')](_0x5a456a)[_0x68c7('0x17')]();};}function respondWithResult(_0x51e93b,_0x2261d9){_0x2261d9=_0x2261d9||0xc8;return function(_0x4b4a2e){if(_0x4b4a2e){return _0x51e93b[_0x68c7('0x16')](_0x2261d9)[_0x68c7('0x18')](_0x4b4a2e);}};}function respondWithFilteredResult(_0x17d18b,_0x92d8ce){return function(_0x5a7c3a){if(_0x5a7c3a){var _0x50c4e5=typeof _0x92d8ce[_0x68c7('0x19')]===_0x68c7('0x1a')&&typeof _0x92d8ce['limit']===_0x68c7('0x1a');var _0x5b4c5a=_0x5a7c3a[_0x68c7('0x1b')];var _0xfb431=_0x50c4e5?0x0:_0x92d8ce[_0x68c7('0x19')];var _0x97e890=_0x50c4e5?_0x5a7c3a[_0x68c7('0x1b')]:_0x92d8ce[_0x68c7('0x19')]+_0x92d8ce[_0x68c7('0x1c')];var _0x3f3d1f;if(_0x97e890>=_0x5b4c5a){_0x97e890=_0x5b4c5a;_0x3f3d1f=0xc8;}else{_0x3f3d1f=0xce;}_0x17d18b[_0x68c7('0x16')](_0x3f3d1f);return _0x17d18b[_0x68c7('0x1d')](_0x68c7('0x1e'),_0xfb431+'-'+_0x97e890+'/'+_0x5b4c5a)[_0x68c7('0x18')](_0x5a7c3a);}return null;};}function patchUpdates(_0x3291b){return function(_0x535d59){try{jsonpatch['apply'](_0x535d59,_0x3291b,!![]);}catch(_0x49a155){return BPromise[_0x68c7('0x1f')](_0x49a155);}return _0x535d59[_0x68c7('0x20')]();};}function saveUpdates(_0x67e36c,_0x64530b){return function(_0x163322){if(_0x163322){return _0x163322[_0x68c7('0x21')](_0x67e36c)[_0x68c7('0x22')](function(_0x5e0fff){return _0x5e0fff;});}return null;};}function removeEntity(_0x164ea8,_0x4b4522){return function(_0x2fc6bc){if(_0x2fc6bc){return _0x2fc6bc[_0x68c7('0x23')]()['then'](function(){var _0x243c52=_0x2fc6bc[_0x68c7('0x24')]({'plain':!![]});var _0x32dcd6=_0x68c7('0x25');return db[_0x68c7('0x26')][_0x68c7('0x23')]({'where':{'type':_0x32dcd6,'resourceId':_0x243c52['id']}})[_0x68c7('0x22')](function(){return _0x2fc6bc;});})[_0x68c7('0x22')](function(){_0x164ea8[_0x68c7('0x16')](0xcc)[_0x68c7('0x17')]();});}};}function handleEntityNotFound(_0x1b044c,_0x1391aa){return function(_0x275fd2){if(!_0x275fd2){_0x1b044c[_0x68c7('0x15')](0x194);}return _0x275fd2;};}function handleError(_0xad7b0b,_0x1695ba){_0x1695ba=_0x1695ba||0x1f4;return function(_0x53b866){logger[_0x68c7('0x27')](_0x53b866[_0x68c7('0x28')]);if(_0x53b866['name']){delete _0x53b866[_0x68c7('0x29')];}_0xad7b0b[_0x68c7('0x16')](_0x1695ba)[_0x68c7('0x2a')](_0x53b866);};}exports[_0x68c7('0x2b')]=function(_0x1744e3,_0x4ea28c){var _0x57e8db={},_0xd10d78={},_0xe7bda5={'count':0x0,'rows':[]};var _0x42cdae=_[_0x68c7('0x2c')](db[_0x68c7('0x2d')][_0x68c7('0x2e')],function(_0x47a643){return{'name':_0x47a643[_0x68c7('0x2f')],'type':_0x47a643[_0x68c7('0x30')][_0x68c7('0x31')]};});_0xd10d78['model']=_[_0x68c7('0x2c')](_0x42cdae,'name');_0xd10d78[_0x68c7('0x32')]=_[_0x68c7('0x33')](_0x1744e3[_0x68c7('0x32')]);_0xd10d78[_0x68c7('0x34')]=_['intersection'](_0xd10d78[_0x68c7('0x35')],_0xd10d78[_0x68c7('0x32')]);_0x57e8db[_0x68c7('0x36')]=_[_0x68c7('0x37')](_0xd10d78[_0x68c7('0x35')],qs[_0x68c7('0x38')](_0x1744e3[_0x68c7('0x32')][_0x68c7('0x38')]));_0x57e8db[_0x68c7('0x36')]=_0x57e8db[_0x68c7('0x36')][_0x68c7('0x39')]?_0x57e8db[_0x68c7('0x36')]:_0xd10d78[_0x68c7('0x35')];if(!_0x1744e3['query']['hasOwnProperty']('nolimit')){_0x57e8db[_0x68c7('0x1c')]=qs['limit'](_0x1744e3['query']['limit']);_0x57e8db[_0x68c7('0x19')]=qs[_0x68c7('0x19')](_0x1744e3[_0x68c7('0x32')][_0x68c7('0x19')]);}_0x57e8db[_0x68c7('0x3a')]=qs['sort'](_0x1744e3['query'][_0x68c7('0x3b')]);_0x57e8db[_0x68c7('0x3c')]=qs[_0x68c7('0x34')](_['pick'](_0x1744e3[_0x68c7('0x32')],_0xd10d78[_0x68c7('0x34')]),_0x42cdae);if(_0x1744e3[_0x68c7('0x32')][_0x68c7('0x3d')]){_0x57e8db['where']=_[_0x68c7('0x3e')](_0x57e8db[_0x68c7('0x3c')],{'$or':_['map'](_0x42cdae,function(_0x32e1de){if(_0x32e1de['type']!==_0x68c7('0x3f')){var _0x2d20a7={};_0x2d20a7[_0x32e1de[_0x68c7('0x29')]]={'$like':'%'+_0x1744e3[_0x68c7('0x32')]['filter']+'%'};return _0x2d20a7;}})});}_0x57e8db=_['merge']({},_0x57e8db,_0x1744e3[_0x68c7('0x40')]);var _0x2e9bec={'where':_0x57e8db[_0x68c7('0x3c')]};return db[_0x68c7('0x2d')]['count'](_0x2e9bec)['then'](function(_0x1f2601){_0xe7bda5['count']=_0x1f2601;if(_0x1744e3[_0x68c7('0x32')][_0x68c7('0x41')]){_0x57e8db[_0x68c7('0x42')]=[{'all':!![]}];}return db['Variable'][_0x68c7('0x43')](_0x57e8db);})['then'](function(_0x1de54b){_0xe7bda5[_0x68c7('0x44')]=_0x1de54b;return _0xe7bda5;})[_0x68c7('0x22')](respondWithFilteredResult(_0x4ea28c,_0x57e8db))[_0x68c7('0x45')](handleError(_0x4ea28c,null));};exports[_0x68c7('0x46')]=function(_0x4c4d8b,_0x24bab0){var _0x6dfef4={'raw':!![],'where':{'id':_0x4c4d8b[_0x68c7('0x47')]['id']}},_0x91447c={};_0x91447c[_0x68c7('0x35')]=_['keys'](db[_0x68c7('0x2d')][_0x68c7('0x2e')]);_0x91447c['query']=_['keys'](_0x4c4d8b[_0x68c7('0x32')]);_0x91447c[_0x68c7('0x34')]=_['intersection'](_0x91447c[_0x68c7('0x35')],_0x91447c['query']);_0x6dfef4['attributes']=_[_0x68c7('0x37')](_0x91447c[_0x68c7('0x35')],qs[_0x68c7('0x38')](_0x4c4d8b[_0x68c7('0x32')][_0x68c7('0x38')]));_0x6dfef4[_0x68c7('0x36')]=_0x6dfef4[_0x68c7('0x36')][_0x68c7('0x39')]?_0x6dfef4[_0x68c7('0x36')]:_0x91447c['model'];if(_0x4c4d8b['query'][_0x68c7('0x41')]){_0x6dfef4[_0x68c7('0x42')]=[{'all':!![]}];}_0x6dfef4=_['merge']({},_0x6dfef4,_0x4c4d8b['options']);return db['Variable'][_0x68c7('0x48')](_0x6dfef4)[_0x68c7('0x22')](handleEntityNotFound(_0x24bab0,null))['then'](respondWithResult(_0x24bab0,null))[_0x68c7('0x45')](handleError(_0x24bab0,null));};exports[_0x68c7('0x49')]=function(_0x19d17c,_0x28d27f){return db[_0x68c7('0x2d')][_0x68c7('0x49')](_0x19d17c['body'],{})[_0x68c7('0x22')](function(_0x20129a){var _0x1b261e=_0x19d17c[_0x68c7('0x4a')][_0x68c7('0x24')]({'plain':!![]});if(!_0x1b261e)throw new Error(_0x68c7('0x4b'));if(_0x1b261e[_0x68c7('0x4c')]===_0x68c7('0x4a')){var _0x42838d=_0x20129a[_0x68c7('0x24')]({'plain':!![]});var _0x3c78f7='Variables';return db[_0x68c7('0x4d')]['find']({'where':{'name':_0x3c78f7,'userProfileId':_0x1b261e[_0x68c7('0x4e')]},'raw':!![]})[_0x68c7('0x22')](function(_0xb85336){if(_0xb85336&&_0xb85336[_0x68c7('0x4f')]===0x0){return db['UserProfileResource'][_0x68c7('0x49')]({'name':_0x42838d[_0x68c7('0x29')],'resourceId':_0x42838d['id'],'type':_0xb85336[_0x68c7('0x29')],'sectionId':_0xb85336['id']},{})['then'](function(){return _0x20129a;});}else{return _0x20129a;}})['catch'](function(_0x3955a6){logger[_0x68c7('0x27')](_0x68c7('0x50'),_0x3955a6);throw _0x3955a6;});}return _0x20129a;})['then'](respondWithResult(_0x28d27f,0xc9))[_0x68c7('0x45')](handleError(_0x28d27f,null));};exports['update']=function(_0x31f049,_0xd97c08){if(_0x31f049[_0x68c7('0x51')]['id']){delete _0x31f049[_0x68c7('0x51')]['id'];}return db[_0x68c7('0x2d')][_0x68c7('0x48')]({'where':{'id':_0x31f049['params']['id']}})['then'](handleEntityNotFound(_0xd97c08,null))[_0x68c7('0x22')](saveUpdates(_0x31f049['body'],null))[_0x68c7('0x22')](respondWithResult(_0xd97c08,null))[_0x68c7('0x45')](handleError(_0xd97c08,null));};exports[_0x68c7('0x23')]=function(_0x41470a,_0x37fe44){return db[_0x68c7('0x2d')]['find']({'where':{'id':_0x41470a[_0x68c7('0x47')]['id']}})[_0x68c7('0x22')](handleEntityNotFound(_0x37fe44,null))[_0x68c7('0x22')](removeEntity(_0x37fe44,null))[_0x68c7('0x45')](handleError(_0x37fe44,null));};