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 _0x781c=['query','keys','intersection','fields','attributes','length','nolimit','offset','order','sort','filters','pick','filter','merge','where','VIRTUAL','options','includeAll','findAll','rows','catch','show','params','include','find','create','body','user','role','Variables','UserProfileSection','userProfileId','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','rimraf','fast-json-patch','request-promise','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','desk.js','querystring','papaparse','ioredis','../../components/auth/service','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','undefined','limit','count','set','Content-Range','json','reject','save','update','then','destroy','get','end','error','stack','name','send','Variable','rawAttributes','type','model','map'];(function(_0x4c5e4d,_0x3d7857){var _0x5822bd=function(_0x1f26d5){while(--_0x1f26d5){_0x4c5e4d['push'](_0x4c5e4d['shift']());}};_0x5822bd(++_0x3d7857);}(_0x781c,0xc5));var _0xc781=function(_0x5979f9,_0x1ce132){_0x5979f9=_0x5979f9-0x0;var _0xb25ea1=_0x781c[_0x5979f9];return _0xb25ea1;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xc781('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0xc781('0x1'));var rp=require(_0xc781('0x2'));var moment=require('moment');var BPromise=require(_0xc781('0x3'));var Mustache=require(_0xc781('0x4'));var util=require(_0xc781('0x5'));var path=require(_0xc781('0x6'));var sox=require(_0xc781('0x7'));var csv=require(_0xc781('0x8'));var ejs=require(_0xc781('0x9'));var fs=require('fs');var fs_extra=require(_0xc781('0xa'));var _=require(_0xc781('0xb'));var squel=require('squel');var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0xc781('0xc'));var toCsv=require(_0xc781('0x8'));var querystring=require(_0xc781('0xd'));var Papa=require(_0xc781('0xe'));var Redis=require(_0xc781('0xf'));var authService=require(_0xc781('0x10'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0xc781('0x11'));var utils=require(_0xc781('0x12'));var config=require(_0xc781('0x13'));var licenseUtil=require(_0xc781('0x14'));var db=require(_0xc781('0x15'))['db'];function respondWithStatusCode(_0x770318,_0x3e21f2){_0x3e21f2=_0x3e21f2||0xcc;return function(_0x27c51f){if(_0x27c51f){return _0x770318[_0xc781('0x16')](_0x3e21f2);}return _0x770318[_0xc781('0x17')](_0x3e21f2)['end']();};}function respondWithResult(_0x17d9dd,_0x3c8ea5){_0x3c8ea5=_0x3c8ea5||0xc8;return function(_0x1c4dac){if(_0x1c4dac){return _0x17d9dd['status'](_0x3c8ea5)['json'](_0x1c4dac);}};}function respondWithFilteredResult(_0x566f28,_0x21fdfc){return function(_0x3c744a){if(_0x3c744a){var _0x47ad9a=typeof _0x21fdfc['offset']===_0xc781('0x18')&&typeof _0x21fdfc[_0xc781('0x19')]==='undefined';var _0x46aa0e=_0x3c744a[_0xc781('0x1a')];var _0x253b34=_0x47ad9a?0x0:_0x21fdfc['offset'];var _0x31146b=_0x47ad9a?_0x3c744a[_0xc781('0x1a')]:_0x21fdfc['offset']+_0x21fdfc[_0xc781('0x19')];var _0x597504;if(_0x31146b>=_0x46aa0e){_0x31146b=_0x46aa0e;_0x597504=0xc8;}else{_0x597504=0xce;}_0x566f28[_0xc781('0x17')](_0x597504);return _0x566f28[_0xc781('0x1b')](_0xc781('0x1c'),_0x253b34+'-'+_0x31146b+'/'+_0x46aa0e)[_0xc781('0x1d')](_0x3c744a);}return null;};}function patchUpdates(_0xbc8da6){return function(_0x4fd5d7){try{jsonpatch['apply'](_0x4fd5d7,_0xbc8da6,!![]);}catch(_0x1a87a9){return BPromise[_0xc781('0x1e')](_0x1a87a9);}return _0x4fd5d7[_0xc781('0x1f')]();};}function saveUpdates(_0x43dbe1,_0x592961){return function(_0x12bf5a){if(_0x12bf5a){return _0x12bf5a[_0xc781('0x20')](_0x43dbe1)[_0xc781('0x21')](function(_0x1cf808){return _0x1cf808;});}return null;};}function removeEntity(_0x141aca,_0x43d99b){return function(_0x9ca049){if(_0x9ca049){return _0x9ca049[_0xc781('0x22')]()['then'](function(){var _0x38ee85=_0x9ca049[_0xc781('0x23')]({'plain':!![]});var _0x36a46d='Variables';return db['UserProfileResource'][_0xc781('0x22')]({'where':{'type':_0x36a46d,'resourceId':_0x38ee85['id']}})[_0xc781('0x21')](function(){return _0x9ca049;});})[_0xc781('0x21')](function(){_0x141aca['status'](0xcc)[_0xc781('0x24')]();});}};}function handleEntityNotFound(_0xe68702,_0x41e3d7){return function(_0x3f69a7){if(!_0x3f69a7){_0xe68702[_0xc781('0x16')](0x194);}return _0x3f69a7;};}function handleError(_0x51e2fc,_0x1890cb){_0x1890cb=_0x1890cb||0x1f4;return function(_0x391084){logger[_0xc781('0x25')](_0x391084[_0xc781('0x26')]);if(_0x391084[_0xc781('0x27')]){delete _0x391084[_0xc781('0x27')];}_0x51e2fc[_0xc781('0x17')](_0x1890cb)[_0xc781('0x28')](_0x391084);};}exports['index']=function(_0x29034b,_0x426391){var _0x45f5ad={},_0x541671={},_0x5dc519={'count':0x0,'rows':[]};var _0x4e9710=_['map'](db[_0xc781('0x29')][_0xc781('0x2a')],function(_0x2f503d){return{'name':_0x2f503d['fieldName'],'type':_0x2f503d[_0xc781('0x2b')]['key']};});_0x541671[_0xc781('0x2c')]=_[_0xc781('0x2d')](_0x4e9710,_0xc781('0x27'));_0x541671[_0xc781('0x2e')]=_[_0xc781('0x2f')](_0x29034b[_0xc781('0x2e')]);_0x541671['filters']=_[_0xc781('0x30')](_0x541671[_0xc781('0x2c')],_0x541671[_0xc781('0x2e')]);_0x45f5ad['attributes']=_[_0xc781('0x30')](_0x541671[_0xc781('0x2c')],qs[_0xc781('0x31')](_0x29034b[_0xc781('0x2e')]['fields']));_0x45f5ad['attributes']=_0x45f5ad[_0xc781('0x32')][_0xc781('0x33')]?_0x45f5ad[_0xc781('0x32')]:_0x541671[_0xc781('0x2c')];if(!_0x29034b[_0xc781('0x2e')]['hasOwnProperty'](_0xc781('0x34'))){_0x45f5ad[_0xc781('0x19')]=qs[_0xc781('0x19')](_0x29034b[_0xc781('0x2e')][_0xc781('0x19')]);_0x45f5ad['offset']=qs[_0xc781('0x35')](_0x29034b['query'][_0xc781('0x35')]);}_0x45f5ad[_0xc781('0x36')]=qs[_0xc781('0x37')](_0x29034b[_0xc781('0x2e')][_0xc781('0x37')]);_0x45f5ad['where']=qs[_0xc781('0x38')](_[_0xc781('0x39')](_0x29034b[_0xc781('0x2e')],_0x541671[_0xc781('0x38')]),_0x4e9710);if(_0x29034b['query'][_0xc781('0x3a')]){_0x45f5ad['where']=_[_0xc781('0x3b')](_0x45f5ad[_0xc781('0x3c')],{'$or':_['map'](_0x4e9710,function(_0x400ce4){if(_0x400ce4[_0xc781('0x2b')]!==_0xc781('0x3d')){var _0xd67f88={};_0xd67f88[_0x400ce4[_0xc781('0x27')]]={'$like':'%'+_0x29034b['query']['filter']+'%'};return _0xd67f88;}})});}_0x45f5ad=_['merge']({},_0x45f5ad,_0x29034b[_0xc781('0x3e')]);var _0x1aa930={'where':_0x45f5ad[_0xc781('0x3c')]};return db[_0xc781('0x29')][_0xc781('0x1a')](_0x1aa930)[_0xc781('0x21')](function(_0x2788ab){_0x5dc519[_0xc781('0x1a')]=_0x2788ab;if(_0x29034b[_0xc781('0x2e')][_0xc781('0x3f')]){_0x45f5ad['include']=[{'all':!![]}];}return db[_0xc781('0x29')][_0xc781('0x40')](_0x45f5ad);})['then'](function(_0x20eb38){_0x5dc519[_0xc781('0x41')]=_0x20eb38;return _0x5dc519;})[_0xc781('0x21')](respondWithFilteredResult(_0x426391,_0x45f5ad))[_0xc781('0x42')](handleError(_0x426391,null));};exports[_0xc781('0x43')]=function(_0x1a545e,_0x473e17){var _0x418258={'raw':!![],'where':{'id':_0x1a545e[_0xc781('0x44')]['id']}},_0x2fde90={};_0x2fde90[_0xc781('0x2c')]=_['keys'](db[_0xc781('0x29')][_0xc781('0x2a')]);_0x2fde90[_0xc781('0x2e')]=_[_0xc781('0x2f')](_0x1a545e[_0xc781('0x2e')]);_0x2fde90['filters']=_[_0xc781('0x30')](_0x2fde90[_0xc781('0x2c')],_0x2fde90['query']);_0x418258['attributes']=_[_0xc781('0x30')](_0x2fde90['model'],qs[_0xc781('0x31')](_0x1a545e[_0xc781('0x2e')]['fields']));_0x418258[_0xc781('0x32')]=_0x418258['attributes'][_0xc781('0x33')]?_0x418258[_0xc781('0x32')]:_0x2fde90[_0xc781('0x2c')];if(_0x1a545e[_0xc781('0x2e')][_0xc781('0x3f')]){_0x418258[_0xc781('0x45')]=[{'all':!![]}];}_0x418258=_[_0xc781('0x3b')]({},_0x418258,_0x1a545e[_0xc781('0x3e')]);return db['Variable'][_0xc781('0x46')](_0x418258)[_0xc781('0x21')](handleEntityNotFound(_0x473e17,null))[_0xc781('0x21')](respondWithResult(_0x473e17,null))[_0xc781('0x42')](handleError(_0x473e17,null));};exports[_0xc781('0x47')]=function(_0x422c12,_0x329f67){return db[_0xc781('0x29')][_0xc781('0x47')](_0x422c12[_0xc781('0x48')],{})[_0xc781('0x21')](function(_0x8397c9){var _0x4fa45c=_0x422c12[_0xc781('0x49')]['get']({'plain':!![]});if(!_0x4fa45c)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x4fa45c[_0xc781('0x4a')]===_0xc781('0x49')){var _0x2bb85c=_0x8397c9[_0xc781('0x23')]({'plain':!![]});var _0x3fe90c=_0xc781('0x4b');return db[_0xc781('0x4c')]['find']({'where':{'name':_0x3fe90c,'userProfileId':_0x4fa45c[_0xc781('0x4d')]},'raw':!![]})[_0xc781('0x21')](function(_0x595e69){if(_0x595e69&&_0x595e69[_0xc781('0x4e')]===0x0){return db[_0xc781('0x4f')][_0xc781('0x47')]({'name':_0x2bb85c[_0xc781('0x27')],'resourceId':_0x2bb85c['id'],'type':_0x595e69[_0xc781('0x27')],'sectionId':_0x595e69['id']},{})[_0xc781('0x21')](function(){return _0x8397c9;});}else{return _0x8397c9;}})[_0xc781('0x42')](function(_0x25e332){logger[_0xc781('0x25')](_0xc781('0x50'),_0x25e332);throw _0x25e332;});}return _0x8397c9;})['then'](respondWithResult(_0x329f67,0xc9))[_0xc781('0x42')](handleError(_0x329f67,null));};exports[_0xc781('0x20')]=function(_0x56427f,_0x54491f){if(_0x56427f[_0xc781('0x48')]['id']){delete _0x56427f[_0xc781('0x48')]['id'];}return db[_0xc781('0x29')]['find']({'where':{'id':_0x56427f['params']['id']}})[_0xc781('0x21')](handleEntityNotFound(_0x54491f,null))[_0xc781('0x21')](saveUpdates(_0x56427f[_0xc781('0x48')],null))['then'](respondWithResult(_0x54491f,null))[_0xc781('0x42')](handleError(_0x54491f,null));};exports[_0xc781('0x22')]=function(_0x2be8d3,_0xa98d76){return db[_0xc781('0x29')][_0xc781('0x46')]({'where':{'id':_0x2be8d3[_0xc781('0x44')]['id']}})[_0xc781('0x21')](handleEntityNotFound(_0xa98d76,null))[_0xc781('0x21')](removeEntity(_0xa98d76,null))[_0xc781('0x42')](handleError(_0xa98d76,null));};