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 _0xbff3=['querystring','papaparse','../../components/auth/service','../../config/logger','api','../../config/environment','../../mysqldb','sendStatus','status','end','json','undefined','limit','count','offset','set','Content-Range','reject','save','then','destroy','get','Variables','UserProfileResource','error','stack','name','index','map','Variable','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','fields','attributes','length','hasOwnProperty','order','sort','where','pick','filter','merge','VIRTUAL','options','includeAll','findAll','rows','catch','show','params','include','find','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','userProfileId','create','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','path','to-csv','ejs','fs-extra','squel','jsforce','desk.js'];(function(_0x181728,_0x471cc4){var _0x3525db=function(_0x59c05c){while(--_0x59c05c){_0x181728['push'](_0x181728['shift']());}};_0x3525db(++_0x471cc4);}(_0xbff3,0x1dd));var _0x3bff=function(_0x38e6b9,_0x1f73e4){_0x38e6b9=_0x38e6b9-0x0;var _0x3c7899=_0xbff3[_0x38e6b9];return _0x3c7899;};'use strict';var emlformat=require(_0x3bff('0x0'));var rimraf=require(_0x3bff('0x1'));var zipdir=require(_0x3bff('0x2'));var jsonpatch=require(_0x3bff('0x3'));var rp=require(_0x3bff('0x4'));var moment=require('moment');var BPromise=require(_0x3bff('0x5'));var Mustache=require(_0x3bff('0x6'));var util=require(_0x3bff('0x7'));var path=require(_0x3bff('0x8'));var sox=require('sox');var csv=require(_0x3bff('0x9'));var ejs=require(_0x3bff('0xa'));var fs=require('fs');var fs_extra=require(_0x3bff('0xb'));var _=require('lodash');var squel=require(_0x3bff('0xc'));var crypto=require('crypto');var jsforce=require(_0x3bff('0xd'));var deskjs=require(_0x3bff('0xe'));var toCsv=require(_0x3bff('0x9'));var querystring=require(_0x3bff('0xf'));var Papa=require(_0x3bff('0x10'));var Redis=require('ioredis');var authService=require(_0x3bff('0x11'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x3bff('0x12'))(_0x3bff('0x13'));var utils=require('../../config/utils');var config=require(_0x3bff('0x14'));var licenseUtil=require('../../config/license/util');var db=require(_0x3bff('0x15'))['db'];function respondWithStatusCode(_0x245004,_0x24e111){_0x24e111=_0x24e111||0xcc;return function(_0x178e80){if(_0x178e80){return _0x245004[_0x3bff('0x16')](_0x24e111);}return _0x245004[_0x3bff('0x17')](_0x24e111)[_0x3bff('0x18')]();};}function respondWithResult(_0x3f443e,_0x443304){_0x443304=_0x443304||0xc8;return function(_0x55f6d2){if(_0x55f6d2){return _0x3f443e[_0x3bff('0x17')](_0x443304)[_0x3bff('0x19')](_0x55f6d2);}};}function respondWithFilteredResult(_0xc74b45,_0x1ec63c){return function(_0x36256e){if(_0x36256e){var _0x53fdad=typeof _0x1ec63c['offset']===_0x3bff('0x1a')&&typeof _0x1ec63c[_0x3bff('0x1b')]==='undefined';var _0x4c5003=_0x36256e[_0x3bff('0x1c')];var _0x1f5197=_0x53fdad?0x0:_0x1ec63c[_0x3bff('0x1d')];var _0x2c8d2d=_0x53fdad?_0x36256e['count']:_0x1ec63c['offset']+_0x1ec63c['limit'];var _0x31e1a8;if(_0x2c8d2d>=_0x4c5003){_0x2c8d2d=_0x4c5003;_0x31e1a8=0xc8;}else{_0x31e1a8=0xce;}_0xc74b45['status'](_0x31e1a8);return _0xc74b45[_0x3bff('0x1e')](_0x3bff('0x1f'),_0x1f5197+'-'+_0x2c8d2d+'/'+_0x4c5003)['json'](_0x36256e);}return null;};}function patchUpdates(_0x514162){return function(_0x1ff083){try{jsonpatch['apply'](_0x1ff083,_0x514162,!![]);}catch(_0x370a3b){return BPromise[_0x3bff('0x20')](_0x370a3b);}return _0x1ff083[_0x3bff('0x21')]();};}function saveUpdates(_0x5e0721,_0x51310e){return function(_0x3d3f7f){if(_0x3d3f7f){return _0x3d3f7f['update'](_0x5e0721)[_0x3bff('0x22')](function(_0x12b733){return _0x12b733;});}return null;};}function removeEntity(_0x4df903,_0x5701bd){return function(_0x5e8e2c){if(_0x5e8e2c){return _0x5e8e2c[_0x3bff('0x23')]()[_0x3bff('0x22')](function(){var _0x2984dd=_0x5e8e2c[_0x3bff('0x24')]({'plain':!![]});var _0x3d40dc=_0x3bff('0x25');return db[_0x3bff('0x26')][_0x3bff('0x23')]({'where':{'type':_0x3d40dc,'resourceId':_0x2984dd['id']}})[_0x3bff('0x22')](function(){return _0x5e8e2c;});})[_0x3bff('0x22')](function(){_0x4df903['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x304dce,_0xb0b862){return function(_0x462270){if(!_0x462270){_0x304dce[_0x3bff('0x16')](0x194);}return _0x462270;};}function handleError(_0x5c641a,_0x3242b0){_0x3242b0=_0x3242b0||0x1f4;return function(_0x29da80){logger[_0x3bff('0x27')](_0x29da80[_0x3bff('0x28')]);if(_0x29da80['name']){delete _0x29da80[_0x3bff('0x29')];}_0x5c641a[_0x3bff('0x17')](_0x3242b0)['send'](_0x29da80);};}exports[_0x3bff('0x2a')]=function(_0x400970,_0x17fd2e){var _0x4343fc={},_0x465179={},_0x5e9a9b={'count':0x0,'rows':[]};var _0x1aaf3f=_[_0x3bff('0x2b')](db[_0x3bff('0x2c')][_0x3bff('0x2d')],function(_0x18bfd0){return{'name':_0x18bfd0[_0x3bff('0x2e')],'type':_0x18bfd0[_0x3bff('0x2f')][_0x3bff('0x30')]};});_0x465179[_0x3bff('0x31')]=_[_0x3bff('0x2b')](_0x1aaf3f,_0x3bff('0x29'));_0x465179[_0x3bff('0x32')]=_[_0x3bff('0x33')](_0x400970[_0x3bff('0x32')]);_0x465179[_0x3bff('0x34')]=_[_0x3bff('0x35')](_0x465179[_0x3bff('0x31')],_0x465179[_0x3bff('0x32')]);_0x4343fc['attributes']=_['intersection'](_0x465179[_0x3bff('0x31')],qs['fields'](_0x400970[_0x3bff('0x32')][_0x3bff('0x36')]));_0x4343fc[_0x3bff('0x37')]=_0x4343fc[_0x3bff('0x37')][_0x3bff('0x38')]?_0x4343fc['attributes']:_0x465179['model'];if(!_0x400970['query'][_0x3bff('0x39')]('nolimit')){_0x4343fc[_0x3bff('0x1b')]=qs[_0x3bff('0x1b')](_0x400970[_0x3bff('0x32')][_0x3bff('0x1b')]);_0x4343fc[_0x3bff('0x1d')]=qs[_0x3bff('0x1d')](_0x400970[_0x3bff('0x32')][_0x3bff('0x1d')]);}_0x4343fc[_0x3bff('0x3a')]=qs[_0x3bff('0x3b')](_0x400970['query'][_0x3bff('0x3b')]);_0x4343fc[_0x3bff('0x3c')]=qs['filters'](_[_0x3bff('0x3d')](_0x400970[_0x3bff('0x32')],_0x465179['filters']),_0x1aaf3f);if(_0x400970[_0x3bff('0x32')][_0x3bff('0x3e')]){_0x4343fc[_0x3bff('0x3c')]=_[_0x3bff('0x3f')](_0x4343fc['where'],{'$or':_[_0x3bff('0x2b')](_0x1aaf3f,function(_0x11bb4d){if(_0x11bb4d[_0x3bff('0x2f')]!==_0x3bff('0x40')){var _0x203815={};_0x203815[_0x11bb4d['name']]={'$like':'%'+_0x400970['query'][_0x3bff('0x3e')]+'%'};return _0x203815;}})});}_0x4343fc=_[_0x3bff('0x3f')]({},_0x4343fc,_0x400970[_0x3bff('0x41')]);var _0x2f312f={'where':_0x4343fc[_0x3bff('0x3c')]};return db[_0x3bff('0x2c')][_0x3bff('0x1c')](_0x2f312f)[_0x3bff('0x22')](function(_0x3bd915){_0x5e9a9b['count']=_0x3bd915;if(_0x400970[_0x3bff('0x32')][_0x3bff('0x42')]){_0x4343fc['include']=[{'all':!![]}];}return db[_0x3bff('0x2c')][_0x3bff('0x43')](_0x4343fc);})[_0x3bff('0x22')](function(_0x38ce71){_0x5e9a9b[_0x3bff('0x44')]=_0x38ce71;return _0x5e9a9b;})[_0x3bff('0x22')](respondWithFilteredResult(_0x17fd2e,_0x4343fc))[_0x3bff('0x45')](handleError(_0x17fd2e,null));};exports[_0x3bff('0x46')]=function(_0x4bfe4d,_0x3b908a){var _0x3cda9f={'raw':!![],'where':{'id':_0x4bfe4d[_0x3bff('0x47')]['id']}},_0x59af9f={};_0x59af9f[_0x3bff('0x31')]=_['keys'](db['Variable'][_0x3bff('0x2d')]);_0x59af9f[_0x3bff('0x32')]=_[_0x3bff('0x33')](_0x4bfe4d['query']);_0x59af9f[_0x3bff('0x34')]=_[_0x3bff('0x35')](_0x59af9f[_0x3bff('0x31')],_0x59af9f[_0x3bff('0x32')]);_0x3cda9f['attributes']=_[_0x3bff('0x35')](_0x59af9f[_0x3bff('0x31')],qs[_0x3bff('0x36')](_0x4bfe4d['query'][_0x3bff('0x36')]));_0x3cda9f[_0x3bff('0x37')]=_0x3cda9f[_0x3bff('0x37')][_0x3bff('0x38')]?_0x3cda9f[_0x3bff('0x37')]:_0x59af9f[_0x3bff('0x31')];if(_0x4bfe4d[_0x3bff('0x32')][_0x3bff('0x42')]){_0x3cda9f[_0x3bff('0x48')]=[{'all':!![]}];}_0x3cda9f=_[_0x3bff('0x3f')]({},_0x3cda9f,_0x4bfe4d[_0x3bff('0x41')]);return db[_0x3bff('0x2c')][_0x3bff('0x49')](_0x3cda9f)[_0x3bff('0x22')](handleEntityNotFound(_0x3b908a,null))[_0x3bff('0x22')](respondWithResult(_0x3b908a,null))[_0x3bff('0x45')](handleError(_0x3b908a,null));};exports['create']=function(_0x6996be,_0x32b531){return db['Variable']['create'](_0x6996be[_0x3bff('0x4a')],{})[_0x3bff('0x22')](function(_0x3756e8){var _0x58be99=_0x6996be[_0x3bff('0x4b')]['get']({'plain':!![]});if(!_0x58be99)throw new Error(_0x3bff('0x4c'));if(_0x58be99[_0x3bff('0x4d')]===_0x3bff('0x4b')){var _0x244ec9=_0x3756e8['get']({'plain':!![]});var _0xb16c0d=_0x3bff('0x25');return db['UserProfileSection'][_0x3bff('0x49')]({'where':{'name':_0xb16c0d,'userProfileId':_0x58be99[_0x3bff('0x4e')]},'raw':!![]})[_0x3bff('0x22')](function(_0x471ac7){if(_0x471ac7&&_0x471ac7['autoAssociation']===0x0){return db[_0x3bff('0x26')][_0x3bff('0x4f')]({'name':_0x244ec9[_0x3bff('0x29')],'resourceId':_0x244ec9['id'],'type':_0x471ac7['name'],'sectionId':_0x471ac7['id']},{})[_0x3bff('0x22')](function(){return _0x3756e8;});}else{return _0x3756e8;}})[_0x3bff('0x45')](function(_0x46d91c){logger[_0x3bff('0x27')](_0x3bff('0x50'),_0x46d91c);throw _0x46d91c;});}return _0x3756e8;})['then'](respondWithResult(_0x32b531,0xc9))['catch'](handleError(_0x32b531,null));};exports[_0x3bff('0x51')]=function(_0x41ca5b,_0x5f2c28){if(_0x41ca5b[_0x3bff('0x4a')]['id']){delete _0x41ca5b[_0x3bff('0x4a')]['id'];}return db[_0x3bff('0x2c')][_0x3bff('0x49')]({'where':{'id':_0x41ca5b['params']['id']}})[_0x3bff('0x22')](handleEntityNotFound(_0x5f2c28,null))['then'](saveUpdates(_0x41ca5b[_0x3bff('0x4a')],null))[_0x3bff('0x22')](respondWithResult(_0x5f2c28,null))[_0x3bff('0x45')](handleError(_0x5f2c28,null));};exports[_0x3bff('0x23')]=function(_0xa08e24,_0x3bc0f0){return db[_0x3bff('0x2c')]['find']({'where':{'id':_0xa08e24[_0x3bff('0x47')]['id']}})[_0x3bff('0x22')](handleEntityNotFound(_0x3bc0f0,null))[_0x3bff('0x22')](removeEntity(_0x3bc0f0,null))[_0x3bff('0x45')](handleError(_0x3bc0f0,null));};