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 _0x918c=['json','reject','then','destroy','get','Variables','UserProfileResource','name','send','index','map','Variable','fieldName','model','query','keys','filters','intersection','fields','attributes','hasOwnProperty','nolimit','limit','order','sort','where','pick','merge','type','VIRTUAL','filter','options','includeAll','include','findAll','rows','catch','show','params','rawAttributes','length','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','UserProfileSection','userProfileId','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','eml-format','rimraf','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','end','status','offset','undefined','count','Content-Range'];(function(_0x2b236b,_0x285b7f){var _0x2c24cb=function(_0x4b25a1){while(--_0x4b25a1){_0x2b236b['push'](_0x2b236b['shift']());}};_0x2c24cb(++_0x285b7f);}(_0x918c,0x1d2));var _0xc918=function(_0x307d86,_0x9264f2){_0x307d86=_0x307d86-0x0;var _0x361745=_0x918c[_0x307d86];return _0x361745;};'use strict';var emlformat=require(_0xc918('0x0'));var rimraf=require(_0xc918('0x1'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0xc918('0x2'));var BPromise=require(_0xc918('0x3'));var Mustache=require(_0xc918('0x4'));var util=require(_0xc918('0x5'));var path=require(_0xc918('0x6'));var sox=require(_0xc918('0x7'));var csv=require(_0xc918('0x8'));var ejs=require(_0xc918('0x9'));var fs=require('fs');var fs_extra=require(_0xc918('0xa'));var _=require(_0xc918('0xb'));var squel=require(_0xc918('0xc'));var crypto=require('crypto');var jsforce=require(_0xc918('0xd'));var deskjs=require('desk.js');var toCsv=require(_0xc918('0x8'));var querystring=require(_0xc918('0xe'));var Papa=require(_0xc918('0xf'));var Redis=require(_0xc918('0x10'));var authService=require(_0xc918('0x11'));var qs=require(_0xc918('0x12'));var as=require(_0xc918('0x13'));var hardwareService=require(_0xc918('0x14'));var logger=require('../../config/logger')(_0xc918('0x15'));var utils=require(_0xc918('0x16'));var config=require(_0xc918('0x17'));var licenseUtil=require('../../config/license/util');var db=require(_0xc918('0x18'))['db'];function respondWithStatusCode(_0x2ac443,_0x292b6d){_0x292b6d=_0x292b6d||0xcc;return function(_0x56350c){if(_0x56350c){return _0x2ac443[_0xc918('0x19')](_0x292b6d);}return _0x2ac443['status'](_0x292b6d)[_0xc918('0x1a')]();};}function respondWithResult(_0x214e42,_0x4bb4bd){_0x4bb4bd=_0x4bb4bd||0xc8;return function(_0x502df3){if(_0x502df3){return _0x214e42[_0xc918('0x1b')](_0x4bb4bd)['json'](_0x502df3);}};}function respondWithFilteredResult(_0x414c70,_0x1b3cec){return function(_0x3101cd){if(_0x3101cd){var _0x50e86f=typeof _0x1b3cec[_0xc918('0x1c')]===_0xc918('0x1d')&&typeof _0x1b3cec['limit']===_0xc918('0x1d');var _0x547bff=_0x3101cd[_0xc918('0x1e')];var _0x12c81d=_0x50e86f?0x0:_0x1b3cec[_0xc918('0x1c')];var _0x355055=_0x50e86f?_0x3101cd[_0xc918('0x1e')]:_0x1b3cec['offset']+_0x1b3cec['limit'];var _0x274de9;if(_0x355055>=_0x547bff){_0x355055=_0x547bff;_0x274de9=0xc8;}else{_0x274de9=0xce;}_0x414c70[_0xc918('0x1b')](_0x274de9);return _0x414c70['set'](_0xc918('0x1f'),_0x12c81d+'-'+_0x355055+'/'+_0x547bff)[_0xc918('0x20')](_0x3101cd);}return null;};}function patchUpdates(_0x446ff2){return function(_0x22e47f){try{jsonpatch['apply'](_0x22e47f,_0x446ff2,!![]);}catch(_0x1edf11){return BPromise[_0xc918('0x21')](_0x1edf11);}return _0x22e47f['save']();};}function saveUpdates(_0x470ed0,_0xc76810){return function(_0x53fb73){if(_0x53fb73){return _0x53fb73['update'](_0x470ed0)[_0xc918('0x22')](function(_0x5e0285){return _0x5e0285;});}return null;};}function removeEntity(_0x180969,_0x524de4){return function(_0x3060ab){if(_0x3060ab){return _0x3060ab[_0xc918('0x23')]()['then'](function(){var _0x126a02=_0x3060ab[_0xc918('0x24')]({'plain':!![]});var _0x4752f7=_0xc918('0x25');return db[_0xc918('0x26')][_0xc918('0x23')]({'where':{'type':_0x4752f7,'resourceId':_0x126a02['id']}})[_0xc918('0x22')](function(){return _0x3060ab;});})[_0xc918('0x22')](function(){_0x180969[_0xc918('0x1b')](0xcc)[_0xc918('0x1a')]();});}};}function handleEntityNotFound(_0xf2712a,_0x6e3077){return function(_0x48e053){if(!_0x48e053){_0xf2712a[_0xc918('0x19')](0x194);}return _0x48e053;};}function handleError(_0x186ada,_0x314a1e){_0x314a1e=_0x314a1e||0x1f4;return function(_0x409ec3){logger['error'](_0x409ec3['stack']);if(_0x409ec3[_0xc918('0x27')]){delete _0x409ec3[_0xc918('0x27')];}_0x186ada[_0xc918('0x1b')](_0x314a1e)[_0xc918('0x28')](_0x409ec3);};}exports[_0xc918('0x29')]=function(_0x6245d4,_0x1a7e57){var _0x17817b={},_0x406419={},_0x377207={'count':0x0,'rows':[]};var _0x379050=_[_0xc918('0x2a')](db[_0xc918('0x2b')]['rawAttributes'],function(_0x19a8f9){return{'name':_0x19a8f9[_0xc918('0x2c')],'type':_0x19a8f9['type']['key']};});_0x406419[_0xc918('0x2d')]=_[_0xc918('0x2a')](_0x379050,_0xc918('0x27'));_0x406419[_0xc918('0x2e')]=_[_0xc918('0x2f')](_0x6245d4[_0xc918('0x2e')]);_0x406419[_0xc918('0x30')]=_['intersection'](_0x406419['model'],_0x406419[_0xc918('0x2e')]);_0x17817b['attributes']=_[_0xc918('0x31')](_0x406419[_0xc918('0x2d')],qs[_0xc918('0x32')](_0x6245d4[_0xc918('0x2e')][_0xc918('0x32')]));_0x17817b[_0xc918('0x33')]=_0x17817b['attributes']['length']?_0x17817b[_0xc918('0x33')]:_0x406419[_0xc918('0x2d')];if(!_0x6245d4['query'][_0xc918('0x34')](_0xc918('0x35'))){_0x17817b[_0xc918('0x36')]=qs[_0xc918('0x36')](_0x6245d4[_0xc918('0x2e')][_0xc918('0x36')]);_0x17817b['offset']=qs['offset'](_0x6245d4[_0xc918('0x2e')][_0xc918('0x1c')]);}_0x17817b[_0xc918('0x37')]=qs[_0xc918('0x38')](_0x6245d4[_0xc918('0x2e')][_0xc918('0x38')]);_0x17817b[_0xc918('0x39')]=qs[_0xc918('0x30')](_[_0xc918('0x3a')](_0x6245d4[_0xc918('0x2e')],_0x406419['filters']),_0x379050);if(_0x6245d4[_0xc918('0x2e')]['filter']){_0x17817b['where']=_[_0xc918('0x3b')](_0x17817b[_0xc918('0x39')],{'$or':_[_0xc918('0x2a')](_0x379050,function(_0x10aa5b){if(_0x10aa5b[_0xc918('0x3c')]!==_0xc918('0x3d')){var _0x6db494={};_0x6db494[_0x10aa5b[_0xc918('0x27')]]={'$like':'%'+_0x6245d4[_0xc918('0x2e')][_0xc918('0x3e')]+'%'};return _0x6db494;}})});}_0x17817b=_[_0xc918('0x3b')]({},_0x17817b,_0x6245d4[_0xc918('0x3f')]);var _0x5605d5={'where':_0x17817b[_0xc918('0x39')]};return db[_0xc918('0x2b')][_0xc918('0x1e')](_0x5605d5)['then'](function(_0x190547){_0x377207[_0xc918('0x1e')]=_0x190547;if(_0x6245d4[_0xc918('0x2e')][_0xc918('0x40')]){_0x17817b[_0xc918('0x41')]=[{'all':!![]}];}return db[_0xc918('0x2b')][_0xc918('0x42')](_0x17817b);})[_0xc918('0x22')](function(_0x1c19f4){_0x377207[_0xc918('0x43')]=_0x1c19f4;return _0x377207;})[_0xc918('0x22')](respondWithFilteredResult(_0x1a7e57,_0x17817b))[_0xc918('0x44')](handleError(_0x1a7e57,null));};exports[_0xc918('0x45')]=function(_0x16a11d,_0x3cf12a){var _0x4c607c={'raw':!![],'where':{'id':_0x16a11d[_0xc918('0x46')]['id']}},_0x3951b9={};_0x3951b9[_0xc918('0x2d')]=_[_0xc918('0x2f')](db['Variable'][_0xc918('0x47')]);_0x3951b9[_0xc918('0x2e')]=_[_0xc918('0x2f')](_0x16a11d[_0xc918('0x2e')]);_0x3951b9[_0xc918('0x30')]=_[_0xc918('0x31')](_0x3951b9[_0xc918('0x2d')],_0x3951b9[_0xc918('0x2e')]);_0x4c607c[_0xc918('0x33')]=_[_0xc918('0x31')](_0x3951b9[_0xc918('0x2d')],qs[_0xc918('0x32')](_0x16a11d['query'][_0xc918('0x32')]));_0x4c607c[_0xc918('0x33')]=_0x4c607c['attributes'][_0xc918('0x48')]?_0x4c607c[_0xc918('0x33')]:_0x3951b9['model'];if(_0x16a11d[_0xc918('0x2e')][_0xc918('0x40')]){_0x4c607c['include']=[{'all':!![]}];}_0x4c607c=_[_0xc918('0x3b')]({},_0x4c607c,_0x16a11d[_0xc918('0x3f')]);return db[_0xc918('0x2b')][_0xc918('0x49')](_0x4c607c)[_0xc918('0x22')](handleEntityNotFound(_0x3cf12a,null))[_0xc918('0x22')](respondWithResult(_0x3cf12a,null))['catch'](handleError(_0x3cf12a,null));};exports[_0xc918('0x4a')]=function(_0x3ea9e5,_0x4b71b5){return db['Variable'][_0xc918('0x4a')](_0x3ea9e5[_0xc918('0x4b')],{})['then'](function(_0x469299){var _0xb32f85=_0x3ea9e5[_0xc918('0x4c')][_0xc918('0x24')]({'plain':!![]});if(!_0xb32f85)throw new Error(_0xc918('0x4d'));if(_0xb32f85['role']==='user'){var _0x588af4=_0x469299[_0xc918('0x24')]({'plain':!![]});var _0x482625=_0xc918('0x25');return db[_0xc918('0x4e')][_0xc918('0x49')]({'where':{'name':_0x482625,'userProfileId':_0xb32f85[_0xc918('0x4f')]},'raw':!![]})[_0xc918('0x22')](function(_0x193532){if(_0x193532&&_0x193532['autoAssociation']===0x0){return db[_0xc918('0x26')]['create']({'name':_0x588af4[_0xc918('0x27')],'resourceId':_0x588af4['id'],'type':_0x193532[_0xc918('0x27')],'sectionId':_0x193532['id']},{})['then'](function(){return _0x469299;});}else{return _0x469299;}})['catch'](function(_0x4ea4fc){logger[_0xc918('0x50')](_0xc918('0x51'),_0x4ea4fc);throw _0x4ea4fc;});}return _0x469299;})[_0xc918('0x22')](respondWithResult(_0x4b71b5,0xc9))[_0xc918('0x44')](handleError(_0x4b71b5,null));};exports[_0xc918('0x52')]=function(_0x1cc2af,_0xa52744){if(_0x1cc2af['body']['id']){delete _0x1cc2af[_0xc918('0x4b')]['id'];}return db[_0xc918('0x2b')][_0xc918('0x49')]({'where':{'id':_0x1cc2af['params']['id']}})[_0xc918('0x22')](handleEntityNotFound(_0xa52744,null))[_0xc918('0x22')](saveUpdates(_0x1cc2af[_0xc918('0x4b')],null))[_0xc918('0x22')](respondWithResult(_0xa52744,null))[_0xc918('0x44')](handleError(_0xa52744,null));};exports[_0xc918('0x23')]=function(_0x92f8f,_0x298e50){return db[_0xc918('0x2b')]['find']({'where':{'id':_0x92f8f['params']['id']}})['then'](handleEntityNotFound(_0x298e50,null))['then'](removeEntity(_0x298e50,null))['catch'](handleError(_0x298e50,null));};