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 _0x0a94=['sendStatus','error','stack','name','index','Variable','rawAttributes','fieldName','type','key','model','map','query','keys','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','VIRTUAL','options','includeAll','include','findAll','show','catch','create','body','user','role','UserProfileSection','find','userProfileId','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','destroy','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','sox','to-csv','ejs','lodash','squel','jsforce','desk.js','papaparse','../../components/auth/service','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/license/util','../../mysqldb','status','end','json','offset','undefined','limit','count','set','apply','reject','save','then','get','Variables'];(function(_0x455d88,_0x13e17b){var _0xdcdbee=function(_0x3faa36){while(--_0x3faa36){_0x455d88['push'](_0x455d88['shift']());}};_0xdcdbee(++_0x13e17b);}(_0x0a94,0x17e));var _0x40a9=function(_0x217831,_0x2f2cfb){_0x217831=_0x217831-0x0;var _0x1e4f0e=_0x0a94[_0x217831];return _0x1e4f0e;};'use strict';var emlformat=require(_0x40a9('0x0'));var rimraf=require(_0x40a9('0x1'));var zipdir=require(_0x40a9('0x2'));var jsonpatch=require(_0x40a9('0x3'));var rp=require(_0x40a9('0x4'));var moment=require(_0x40a9('0x5'));var BPromise=require(_0x40a9('0x6'));var Mustache=require(_0x40a9('0x7'));var util=require('util');var path=require(_0x40a9('0x8'));var sox=require(_0x40a9('0x9'));var csv=require(_0x40a9('0xa'));var ejs=require(_0x40a9('0xb'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x40a9('0xc'));var squel=require(_0x40a9('0xd'));var crypto=require('crypto');var jsforce=require(_0x40a9('0xe'));var deskjs=require(_0x40a9('0xf'));var toCsv=require(_0x40a9('0xa'));var querystring=require('querystring');var Papa=require(_0x40a9('0x10'));var Redis=require('ioredis');var authService=require(_0x40a9('0x11'));var qs=require('../../components/parsers/qs');var as=require(_0x40a9('0x12'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x40a9('0x13'))(_0x40a9('0x14'));var utils=require(_0x40a9('0x15'));var config=require('../../config/environment');var licenseUtil=require(_0x40a9('0x16'));var db=require(_0x40a9('0x17'))['db'];function respondWithStatusCode(_0x2af8d4,_0x979f2a){_0x979f2a=_0x979f2a||0xcc;return function(_0x5a4dcd){if(_0x5a4dcd){return _0x2af8d4['sendStatus'](_0x979f2a);}return _0x2af8d4[_0x40a9('0x18')](_0x979f2a)[_0x40a9('0x19')]();};}function respondWithResult(_0x1bff7e,_0x495c27){_0x495c27=_0x495c27||0xc8;return function(_0x2495a0){if(_0x2495a0){return _0x1bff7e[_0x40a9('0x18')](_0x495c27)[_0x40a9('0x1a')](_0x2495a0);}};}function respondWithFilteredResult(_0xe20f91,_0x5828d2){return function(_0x39f5d3){if(_0x39f5d3){var _0x5a706d=typeof _0x5828d2[_0x40a9('0x1b')]===_0x40a9('0x1c')&&typeof _0x5828d2[_0x40a9('0x1d')]===_0x40a9('0x1c');var _0x4df387=_0x39f5d3[_0x40a9('0x1e')];var _0x52ca4e=_0x5a706d?0x0:_0x5828d2['offset'];var _0x31aa51=_0x5a706d?_0x39f5d3[_0x40a9('0x1e')]:_0x5828d2[_0x40a9('0x1b')]+_0x5828d2[_0x40a9('0x1d')];var _0x5252ce;if(_0x31aa51>=_0x4df387){_0x31aa51=_0x4df387;_0x5252ce=0xc8;}else{_0x5252ce=0xce;}_0xe20f91['status'](_0x5252ce);return _0xe20f91[_0x40a9('0x1f')]('Content-Range',_0x52ca4e+'-'+_0x31aa51+'/'+_0x4df387)[_0x40a9('0x1a')](_0x39f5d3);}return null;};}function patchUpdates(_0x9382f3){return function(_0x4ed824){try{jsonpatch[_0x40a9('0x20')](_0x4ed824,_0x9382f3,!![]);}catch(_0x29dd96){return BPromise[_0x40a9('0x21')](_0x29dd96);}return _0x4ed824[_0x40a9('0x22')]();};}function saveUpdates(_0x10c41e,_0xea3bea){return function(_0x12b227){if(_0x12b227){return _0x12b227['update'](_0x10c41e)[_0x40a9('0x23')](function(_0x5a6e67){return _0x5a6e67;});}return null;};}function removeEntity(_0x341f76,_0x1f999a){return function(_0x291e4b){if(_0x291e4b){return _0x291e4b['destroy']()['then'](function(){var _0x53ee47=_0x291e4b[_0x40a9('0x24')]({'plain':!![]});var _0x1223e1=_0x40a9('0x25');return db['UserProfileResource']['destroy']({'where':{'type':_0x1223e1,'resourceId':_0x53ee47['id']}})[_0x40a9('0x23')](function(){return _0x291e4b;});})[_0x40a9('0x23')](function(){_0x341f76[_0x40a9('0x18')](0xcc)[_0x40a9('0x19')]();});}};}function handleEntityNotFound(_0x2754a8,_0x49d202){return function(_0x2dfd90){if(!_0x2dfd90){_0x2754a8[_0x40a9('0x26')](0x194);}return _0x2dfd90;};}function handleError(_0x14ced8,_0x5e24be){_0x5e24be=_0x5e24be||0x1f4;return function(_0x1fe600){logger[_0x40a9('0x27')](_0x1fe600[_0x40a9('0x28')]);if(_0x1fe600[_0x40a9('0x29')]){delete _0x1fe600['name'];}_0x14ced8['status'](_0x5e24be)['send'](_0x1fe600);};}exports[_0x40a9('0x2a')]=function(_0x181197,_0x4c6e60){var _0x479e5d={},_0x1bf680={},_0x1e44d6={'count':0x0,'rows':[]};var _0x2bad9f=_['map'](db[_0x40a9('0x2b')][_0x40a9('0x2c')],function(_0x3e214c){return{'name':_0x3e214c[_0x40a9('0x2d')],'type':_0x3e214c[_0x40a9('0x2e')][_0x40a9('0x2f')]};});_0x1bf680[_0x40a9('0x30')]=_[_0x40a9('0x31')](_0x2bad9f,_0x40a9('0x29'));_0x1bf680[_0x40a9('0x32')]=_[_0x40a9('0x33')](_0x181197['query']);_0x1bf680[_0x40a9('0x34')]=_[_0x40a9('0x35')](_0x1bf680[_0x40a9('0x30')],_0x1bf680[_0x40a9('0x32')]);_0x479e5d['attributes']=_[_0x40a9('0x35')](_0x1bf680[_0x40a9('0x30')],qs['fields'](_0x181197[_0x40a9('0x32')][_0x40a9('0x36')]));_0x479e5d[_0x40a9('0x37')]=_0x479e5d['attributes'][_0x40a9('0x38')]?_0x479e5d['attributes']:_0x1bf680[_0x40a9('0x30')];if(!_0x181197[_0x40a9('0x32')][_0x40a9('0x39')](_0x40a9('0x3a'))){_0x479e5d['limit']=qs[_0x40a9('0x1d')](_0x181197[_0x40a9('0x32')]['limit']);_0x479e5d[_0x40a9('0x1b')]=qs[_0x40a9('0x1b')](_0x181197['query']['offset']);}_0x479e5d[_0x40a9('0x3b')]=qs['sort'](_0x181197[_0x40a9('0x32')][_0x40a9('0x3c')]);_0x479e5d['where']=qs[_0x40a9('0x34')](_[_0x40a9('0x3d')](_0x181197[_0x40a9('0x32')],_0x1bf680[_0x40a9('0x34')]),_0x2bad9f);if(_0x181197['query'][_0x40a9('0x3e')]){_0x479e5d[_0x40a9('0x3f')]=_[_0x40a9('0x40')](_0x479e5d[_0x40a9('0x3f')],{'$or':_[_0x40a9('0x31')](_0x2bad9f,function(_0x2623e3){if(_0x2623e3['type']!==_0x40a9('0x41')){var _0x92c8c2={};_0x92c8c2[_0x2623e3[_0x40a9('0x29')]]={'$like':'%'+_0x181197['query'][_0x40a9('0x3e')]+'%'};return _0x92c8c2;}})});}_0x479e5d=_[_0x40a9('0x40')]({},_0x479e5d,_0x181197[_0x40a9('0x42')]);var _0x3245a0={'where':_0x479e5d[_0x40a9('0x3f')]};return db['Variable'][_0x40a9('0x1e')](_0x3245a0)['then'](function(_0x25f688){_0x1e44d6[_0x40a9('0x1e')]=_0x25f688;if(_0x181197[_0x40a9('0x32')][_0x40a9('0x43')]){_0x479e5d[_0x40a9('0x44')]=[{'all':!![]}];}return db[_0x40a9('0x2b')][_0x40a9('0x45')](_0x479e5d);})[_0x40a9('0x23')](function(_0x1fdfa3){_0x1e44d6['rows']=_0x1fdfa3;return _0x1e44d6;})[_0x40a9('0x23')](respondWithFilteredResult(_0x4c6e60,_0x479e5d))['catch'](handleError(_0x4c6e60,null));};exports[_0x40a9('0x46')]=function(_0x55d06d,_0x4ab542){var _0x7798c4={'raw':!![],'where':{'id':_0x55d06d['params']['id']}},_0x25aff4={};_0x25aff4[_0x40a9('0x30')]=_['keys'](db[_0x40a9('0x2b')][_0x40a9('0x2c')]);_0x25aff4[_0x40a9('0x32')]=_['keys'](_0x55d06d['query']);_0x25aff4[_0x40a9('0x34')]=_[_0x40a9('0x35')](_0x25aff4[_0x40a9('0x30')],_0x25aff4['query']);_0x7798c4[_0x40a9('0x37')]=_[_0x40a9('0x35')](_0x25aff4[_0x40a9('0x30')],qs[_0x40a9('0x36')](_0x55d06d[_0x40a9('0x32')][_0x40a9('0x36')]));_0x7798c4['attributes']=_0x7798c4[_0x40a9('0x37')][_0x40a9('0x38')]?_0x7798c4[_0x40a9('0x37')]:_0x25aff4[_0x40a9('0x30')];if(_0x55d06d[_0x40a9('0x32')][_0x40a9('0x43')]){_0x7798c4['include']=[{'all':!![]}];}_0x7798c4=_[_0x40a9('0x40')]({},_0x7798c4,_0x55d06d[_0x40a9('0x42')]);return db[_0x40a9('0x2b')]['find'](_0x7798c4)[_0x40a9('0x23')](handleEntityNotFound(_0x4ab542,null))[_0x40a9('0x23')](respondWithResult(_0x4ab542,null))[_0x40a9('0x47')](handleError(_0x4ab542,null));};exports[_0x40a9('0x48')]=function(_0x521826,_0x29e94d){return db[_0x40a9('0x2b')][_0x40a9('0x48')](_0x521826[_0x40a9('0x49')],{})['then'](function(_0x5af005){var _0x20a652=_0x521826[_0x40a9('0x4a')][_0x40a9('0x24')]({'plain':!![]});if(!_0x20a652)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x20a652[_0x40a9('0x4b')]==='user'){var _0x5538b4=_0x5af005['get']({'plain':!![]});var _0x3d4cf2=_0x40a9('0x25');return db[_0x40a9('0x4c')][_0x40a9('0x4d')]({'where':{'name':_0x3d4cf2,'userProfileId':_0x20a652[_0x40a9('0x4e')]},'raw':!![]})['then'](function(_0x27d921){if(_0x27d921&&_0x27d921[_0x40a9('0x4f')]===0x0){return db[_0x40a9('0x50')][_0x40a9('0x48')]({'name':_0x5538b4[_0x40a9('0x29')],'resourceId':_0x5538b4['id'],'type':_0x27d921[_0x40a9('0x29')],'sectionId':_0x27d921['id']},{})['then'](function(){return _0x5af005;});}else{return _0x5af005;}})[_0x40a9('0x47')](function(_0x3c88eb){logger[_0x40a9('0x27')](_0x40a9('0x51'),_0x3c88eb);throw _0x3c88eb;});}return _0x5af005;})[_0x40a9('0x23')](respondWithResult(_0x29e94d,0xc9))[_0x40a9('0x47')](handleError(_0x29e94d,null));};exports['update']=function(_0x55098d,_0x35c1c6){if(_0x55098d[_0x40a9('0x49')]['id']){delete _0x55098d[_0x40a9('0x49')]['id'];}return db[_0x40a9('0x2b')][_0x40a9('0x4d')]({'where':{'id':_0x55098d[_0x40a9('0x52')]['id']}})[_0x40a9('0x23')](handleEntityNotFound(_0x35c1c6,null))[_0x40a9('0x23')](saveUpdates(_0x55098d[_0x40a9('0x49')],null))[_0x40a9('0x23')](respondWithResult(_0x35c1c6,null))[_0x40a9('0x47')](handleError(_0x35c1c6,null));};exports[_0x40a9('0x53')]=function(_0x66afe8,_0x339453){return db['Variable'][_0x40a9('0x4d')]({'where':{'id':_0x66afe8[_0x40a9('0x52')]['id']}})['then'](handleEntityNotFound(_0x339453,null))[_0x40a9('0x23')](removeEntity(_0x339453,null))[_0x40a9('0x47')](handleError(_0x339453,null));};