server/api/intVtigerConfiguration/intVtigerConfiguration.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 _0x0df9=['ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','offset','limit','undefined','count','Content-Range','json','apply','update','then','stack','name','send','index','rawAttributes','fieldName','type','model','map','query','attributes','intersection','fields','hasOwnProperty','nolimit','order','sort','where','filters','merge','filter','VtigerConfiguration','include','show','params','keys','length','includeAll','catch','create','body','find','destroy','VtigerField','pick','getFields','findOne','options','getDescriptions','eml-format','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','jsforce','desk.js','querystring','papaparse'];(function(_0x256e7e,_0x4bd682){var _0x5cd898=function(_0x272713){while(--_0x272713){_0x256e7e['push'](_0x256e7e['shift']());}};_0x5cd898(++_0x4bd682);}(_0x0df9,0x170));var _0x90df=function(_0x26344b,_0xc28ced){_0x26344b=_0x26344b-0x0;var _0x222791=_0x0df9[_0x26344b];return _0x222791;};'use strict';var emlformat=require(_0x90df('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x90df('0x1'));var jsonpatch=require(_0x90df('0x2'));var rp=require('request-promise');var moment=require(_0x90df('0x3'));var BPromise=require(_0x90df('0x4'));var Mustache=require(_0x90df('0x5'));var util=require(_0x90df('0x6'));var path=require(_0x90df('0x7'));var sox=require(_0x90df('0x8'));var csv=require(_0x90df('0x9'));var ejs=require(_0x90df('0xa'));var fs=require('fs');var fs_extra=require(_0x90df('0xb'));var _=require(_0x90df('0xc'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x90df('0xd'));var deskjs=require(_0x90df('0xe'));var toCsv=require('to-csv');var querystring=require(_0x90df('0xf'));var Papa=require(_0x90df('0x10'));var Redis=require(_0x90df('0x11'));var authService=require(_0x90df('0x12'));var qs=require(_0x90df('0x13'));var as=require(_0x90df('0x14'));var hardwareService=require(_0x90df('0x15'));var logger=require('../../config/logger')('api');var utils=require(_0x90df('0x16'));var config=require(_0x90df('0x17'));var licenseUtil=require(_0x90df('0x18'));var db=require(_0x90df('0x19'))['db'];function respondWithStatusCode(_0x5b1a00,_0x1aa960){_0x1aa960=_0x1aa960||0xcc;return function(_0x1f4ab7){if(_0x1f4ab7){return _0x5b1a00[_0x90df('0x1a')](_0x1aa960);}return _0x5b1a00[_0x90df('0x1b')](_0x1aa960)[_0x90df('0x1c')]();};}function respondWithResult(_0x5bdab2,_0x52d6bf){_0x52d6bf=_0x52d6bf||0xc8;return function(_0x110966){if(_0x110966){return _0x5bdab2['status'](_0x52d6bf)['json'](_0x110966);}};}function respondWithFilteredResult(_0x5907ee,_0x3746e4){return function(_0x404b64){if(_0x404b64){var _0x4a347b=typeof _0x3746e4[_0x90df('0x1d')]==='undefined'&&typeof _0x3746e4[_0x90df('0x1e')]===_0x90df('0x1f');var _0x448e28=_0x404b64[_0x90df('0x20')];var _0xdee6bb=_0x4a347b?0x0:_0x3746e4['offset'];var _0x224a5b=_0x4a347b?_0x404b64[_0x90df('0x20')]:_0x3746e4[_0x90df('0x1d')]+_0x3746e4['limit'];var _0x3a214e;if(_0x224a5b>=_0x448e28){_0x224a5b=_0x448e28;_0x3a214e=0xc8;}else{_0x3a214e=0xce;}_0x5907ee[_0x90df('0x1b')](_0x3a214e);return _0x5907ee['set'](_0x90df('0x21'),_0xdee6bb+'-'+_0x224a5b+'/'+_0x448e28)[_0x90df('0x22')](_0x404b64);}return null;};}function patchUpdates(_0xc49922){return function(_0x1ca4c1){try{jsonpatch[_0x90df('0x23')](_0x1ca4c1,_0xc49922,!![]);}catch(_0x4117bf){return BPromise['reject'](_0x4117bf);}return _0x1ca4c1['save']();};}function saveUpdates(_0x11d47e,_0x50e9a5){return function(_0x38734e){if(_0x38734e){return _0x38734e[_0x90df('0x24')](_0x11d47e)['then'](function(_0x50f384){return _0x50f384;});}return null;};}function removeEntity(_0x12dce2,_0x47abe1){return function(_0xc1abf0){if(_0xc1abf0){return _0xc1abf0['destroy']()[_0x90df('0x25')](function(){_0x12dce2[_0x90df('0x1b')](0xcc)[_0x90df('0x1c')]();});}};}function handleEntityNotFound(_0x56e7ae,_0x1daa9b){return function(_0x1d4531){if(!_0x1d4531){_0x56e7ae[_0x90df('0x1a')](0x194);}return _0x1d4531;};}function handleError(_0x49690b,_0x45d732){_0x45d732=_0x45d732||0x1f4;return function(_0x5203ad){logger['error'](_0x5203ad[_0x90df('0x26')]);if(_0x5203ad[_0x90df('0x27')]){delete _0x5203ad[_0x90df('0x27')];}_0x49690b[_0x90df('0x1b')](_0x45d732)[_0x90df('0x28')](_0x5203ad);};}exports[_0x90df('0x29')]=function(_0x5f95c8,_0x33d1fb){var _0x37cf9d={},_0x4e6ea2={},_0x1e2c38={'count':0x0,'rows':[]};var _0x2ff8f4=_['map'](db['VtigerConfiguration'][_0x90df('0x2a')],function(_0x589f73){return{'name':_0x589f73[_0x90df('0x2b')],'type':_0x589f73[_0x90df('0x2c')]['key']};});_0x4e6ea2[_0x90df('0x2d')]=_[_0x90df('0x2e')](_0x2ff8f4,_0x90df('0x27'));_0x4e6ea2[_0x90df('0x2f')]=_['keys'](_0x5f95c8[_0x90df('0x2f')]);_0x4e6ea2['filters']=_['intersection'](_0x4e6ea2[_0x90df('0x2d')],_0x4e6ea2[_0x90df('0x2f')]);_0x37cf9d[_0x90df('0x30')]=_[_0x90df('0x31')](_0x4e6ea2[_0x90df('0x2d')],qs[_0x90df('0x32')](_0x5f95c8[_0x90df('0x2f')][_0x90df('0x32')]));_0x37cf9d[_0x90df('0x30')]=_0x37cf9d['attributes']['length']?_0x37cf9d['attributes']:_0x4e6ea2[_0x90df('0x2d')];if(!_0x5f95c8['query'][_0x90df('0x33')](_0x90df('0x34'))){_0x37cf9d[_0x90df('0x1e')]=qs['limit'](_0x5f95c8[_0x90df('0x2f')][_0x90df('0x1e')]);_0x37cf9d[_0x90df('0x1d')]=qs[_0x90df('0x1d')](_0x5f95c8[_0x90df('0x2f')][_0x90df('0x1d')]);}_0x37cf9d[_0x90df('0x35')]=qs['sort'](_0x5f95c8['query'][_0x90df('0x36')]);_0x37cf9d[_0x90df('0x37')]=qs[_0x90df('0x38')](_['pick'](_0x5f95c8[_0x90df('0x2f')],_0x4e6ea2[_0x90df('0x38')]),_0x2ff8f4);if(_0x5f95c8['query']['filter']){_0x37cf9d[_0x90df('0x37')]=_[_0x90df('0x39')](_0x37cf9d[_0x90df('0x37')],{'$or':_['map'](_0x2ff8f4,function(_0x879d3e){if(_0x879d3e[_0x90df('0x2c')]!=='VIRTUAL'){var _0x20480b={};_0x20480b[_0x879d3e[_0x90df('0x27')]]={'$like':'%'+_0x5f95c8[_0x90df('0x2f')][_0x90df('0x3a')]+'%'};return _0x20480b;}})});}_0x37cf9d=_[_0x90df('0x39')]({},_0x37cf9d,_0x5f95c8['options']);var _0x190437={'where':_0x37cf9d[_0x90df('0x37')]};return db[_0x90df('0x3b')]['count'](_0x190437)[_0x90df('0x25')](function(_0x78f6b0){_0x1e2c38['count']=_0x78f6b0;if(_0x5f95c8[_0x90df('0x2f')]['includeAll']){_0x37cf9d[_0x90df('0x3c')]=[{'all':!![]}];}return db[_0x90df('0x3b')]['findAll'](_0x37cf9d);})[_0x90df('0x25')](function(_0x341d21){_0x1e2c38['rows']=_0x341d21;return _0x1e2c38;})[_0x90df('0x25')](respondWithFilteredResult(_0x33d1fb,_0x37cf9d))['catch'](handleError(_0x33d1fb,null));};exports[_0x90df('0x3d')]=function(_0x4c1ac2,_0x2bfdf2){var _0x37214d={'raw':![],'where':{'id':_0x4c1ac2[_0x90df('0x3e')]['id']}},_0x104f77={};_0x104f77[_0x90df('0x2d')]=_[_0x90df('0x3f')](db[_0x90df('0x3b')]['rawAttributes']);_0x104f77['query']=_['keys'](_0x4c1ac2[_0x90df('0x2f')]);_0x104f77[_0x90df('0x38')]=_[_0x90df('0x31')](_0x104f77['model'],_0x104f77['query']);_0x37214d['attributes']=_[_0x90df('0x31')](_0x104f77[_0x90df('0x2d')],qs[_0x90df('0x32')](_0x4c1ac2[_0x90df('0x2f')][_0x90df('0x32')]));_0x37214d['attributes']=_0x37214d[_0x90df('0x30')][_0x90df('0x40')]?_0x37214d[_0x90df('0x30')]:_0x104f77[_0x90df('0x2d')];if(_0x4c1ac2[_0x90df('0x2f')][_0x90df('0x41')]){_0x37214d['include']=[{'all':!![]}];}_0x37214d=_[_0x90df('0x39')]({},_0x37214d,_0x4c1ac2['options']);return db['VtigerConfiguration']['find'](_0x37214d)[_0x90df('0x25')](handleEntityNotFound(_0x2bfdf2,null))[_0x90df('0x25')](respondWithResult(_0x2bfdf2,null))[_0x90df('0x42')](handleError(_0x2bfdf2,null));};exports[_0x90df('0x43')]=function(_0x519dfb,_0xbc15cb){return db[_0x90df('0x3b')][_0x90df('0x43')](_0x519dfb[_0x90df('0x44')],{})[_0x90df('0x25')](respondWithResult(_0xbc15cb,0xc9))[_0x90df('0x42')](handleError(_0xbc15cb,null));};exports[_0x90df('0x24')]=function(_0xb552d,_0x90ad25){if(_0xb552d[_0x90df('0x44')]['id']){delete _0xb552d[_0x90df('0x44')]['id'];}return db[_0x90df('0x3b')][_0x90df('0x45')]({'where':{'id':_0xb552d[_0x90df('0x3e')]['id']}})[_0x90df('0x25')](handleEntityNotFound(_0x90ad25,null))[_0x90df('0x25')](saveUpdates(_0xb552d[_0x90df('0x44')],null))[_0x90df('0x25')](respondWithResult(_0x90ad25,null))[_0x90df('0x42')](handleError(_0x90ad25,null));};exports[_0x90df('0x46')]=function(_0x1d004c,_0x3717ea){return db['VtigerConfiguration']['find']({'where':{'id':_0x1d004c[_0x90df('0x3e')]['id']}})[_0x90df('0x25')](handleEntityNotFound(_0x3717ea,null))[_0x90df('0x25')](removeEntity(_0x3717ea,null))['catch'](handleError(_0x3717ea,null));};exports['getFields']=function(_0x18860a,_0x1acec5,_0x2e92bf){var _0x16ba03={};var _0x5568dc={};var _0x24f463;var _0x47ca8f;return db['VtigerConfiguration']['findOne']({'where':{'id':_0x18860a[_0x90df('0x3e')]['id']}})[_0x90df('0x25')](handleEntityNotFound(_0x1acec5,null))[_0x90df('0x25')](function(_0x1f9306){if(_0x1f9306){_0x24f463=_0x1f9306;_0x5568dc[_0x90df('0x2d')]=_['keys'](db[_0x90df('0x47')]['rawAttributes']);_0x5568dc[_0x90df('0x2f')]=_['keys'](_0x18860a[_0x90df('0x2f')]);_0x5568dc[_0x90df('0x38')]=_['intersection'](_0x5568dc[_0x90df('0x2d')],_0x5568dc[_0x90df('0x2f')]);_0x16ba03['attributes']=_[_0x90df('0x31')](_0x5568dc[_0x90df('0x2d')],qs['fields'](_0x18860a[_0x90df('0x2f')][_0x90df('0x32')]));_0x16ba03['attributes']=_0x16ba03[_0x90df('0x30')][_0x90df('0x40')]?_0x16ba03['attributes']:_0x5568dc[_0x90df('0x2d')];_0x16ba03['order']=qs[_0x90df('0x36')](_0x18860a[_0x90df('0x2f')]['sort']);_0x16ba03['where']=qs[_0x90df('0x38')](_[_0x90df('0x48')](_0x18860a[_0x90df('0x2f')],_0x5568dc['filters']));if(_0x18860a[_0x90df('0x2f')][_0x90df('0x3a')]){_0x16ba03[_0x90df('0x37')]=_[_0x90df('0x39')](_0x16ba03[_0x90df('0x37')],{'$or':_[_0x90df('0x2e')](_0x16ba03[_0x90df('0x30')],function(_0xd1ff53){var _0x31eed3={};_0x31eed3[_0xd1ff53]={'$like':'%'+_0x18860a[_0x90df('0x2f')][_0x90df('0x3a')]+'%'};return _0x31eed3;})});}_0x16ba03=_['merge']({},_0x16ba03,_0x18860a['options']);return _0x24f463[_0x90df('0x49')](_0x16ba03);}})[_0x90df('0x25')](function(_0x2523ae){if(_0x2523ae){_0x47ca8f=_0x2523ae[_0x90df('0x40')];if(!_0x18860a[_0x90df('0x2f')][_0x90df('0x33')]('nolimit')){_0x16ba03[_0x90df('0x1e')]=qs['limit'](_0x18860a[_0x90df('0x2f')][_0x90df('0x1e')]);_0x16ba03[_0x90df('0x1d')]=qs['offset'](_0x18860a[_0x90df('0x2f')][_0x90df('0x1d')]);}return _0x24f463[_0x90df('0x49')](_0x16ba03);}})['then'](function(_0x2913e1){if(_0x2913e1){return _0x2913e1?{'count':_0x47ca8f,'rows':_0x2913e1}:null;}})[_0x90df('0x25')](respondWithResult(_0x1acec5,null))[_0x90df('0x42')](handleError(_0x1acec5,null));};exports['getSubjects']=function(_0xd70b45,_0x599188,_0x13e7a3){var _0x40311b={};var _0x4336cd={};var _0x22ba61;var _0x105752;return db[_0x90df('0x3b')][_0x90df('0x4a')]({'where':{'id':_0xd70b45[_0x90df('0x3e')]['id']}})[_0x90df('0x25')](handleEntityNotFound(_0x599188,null))[_0x90df('0x25')](function(_0x206ac1){if(_0x206ac1){_0x22ba61=_0x206ac1;_0x4336cd['model']=_['keys'](db[_0x90df('0x47')]['rawAttributes']);_0x4336cd[_0x90df('0x2f')]=_[_0x90df('0x3f')](_0xd70b45['query']);_0x4336cd[_0x90df('0x38')]=_[_0x90df('0x31')](_0x4336cd[_0x90df('0x2d')],_0x4336cd['query']);_0x40311b[_0x90df('0x30')]=_[_0x90df('0x31')](_0x4336cd[_0x90df('0x2d')],qs['fields'](_0xd70b45[_0x90df('0x2f')]['fields']));_0x40311b[_0x90df('0x30')]=_0x40311b[_0x90df('0x30')][_0x90df('0x40')]?_0x40311b[_0x90df('0x30')]:_0x4336cd['model'];_0x40311b[_0x90df('0x35')]=qs[_0x90df('0x36')](_0xd70b45[_0x90df('0x2f')]['sort']);_0x40311b[_0x90df('0x37')]=qs[_0x90df('0x38')](_['pick'](_0xd70b45['query'],_0x4336cd[_0x90df('0x38')]));if(_0xd70b45[_0x90df('0x2f')][_0x90df('0x3a')]){_0x40311b['where']=_[_0x90df('0x39')](_0x40311b['where'],{'$or':_[_0x90df('0x2e')](_0x40311b[_0x90df('0x30')],function(_0x538320){var _0x501766={};_0x501766[_0x538320]={'$like':'%'+_0xd70b45[_0x90df('0x2f')]['filter']+'%'};return _0x501766;})});}_0x40311b=_[_0x90df('0x39')]({},_0x40311b,_0xd70b45['options']);return _0x22ba61['getSubjects'](_0x40311b);}})[_0x90df('0x25')](function(_0x21bcd1){if(_0x21bcd1){_0x105752=_0x21bcd1[_0x90df('0x40')];if(!_0xd70b45[_0x90df('0x2f')][_0x90df('0x33')]('nolimit')){_0x40311b[_0x90df('0x1e')]=qs[_0x90df('0x1e')](_0xd70b45[_0x90df('0x2f')][_0x90df('0x1e')]);_0x40311b[_0x90df('0x1d')]=qs[_0x90df('0x1d')](_0xd70b45[_0x90df('0x2f')][_0x90df('0x1d')]);}return _0x22ba61['getSubjects'](_0x40311b);}})[_0x90df('0x25')](function(_0x2f9eab){if(_0x2f9eab){return _0x2f9eab?{'count':_0x105752,'rows':_0x2f9eab}:null;}})[_0x90df('0x25')](respondWithResult(_0x599188,null))[_0x90df('0x42')](handleError(_0x599188,null));};exports['getDescriptions']=function(_0x3b1895,_0x26ac9a,_0x396946){var _0x45f1fc={};var _0x3be2f8={};var _0x16130e;var _0x2ab2a2;return db[_0x90df('0x3b')][_0x90df('0x4a')]({'where':{'id':_0x3b1895[_0x90df('0x3e')]['id']}})['then'](handleEntityNotFound(_0x26ac9a,null))[_0x90df('0x25')](function(_0x3320d3){if(_0x3320d3){_0x16130e=_0x3320d3;_0x3be2f8[_0x90df('0x2d')]=_[_0x90df('0x3f')](db[_0x90df('0x47')]['rawAttributes']);_0x3be2f8['query']=_[_0x90df('0x3f')](_0x3b1895[_0x90df('0x2f')]);_0x3be2f8[_0x90df('0x38')]=_['intersection'](_0x3be2f8[_0x90df('0x2d')],_0x3be2f8['query']);_0x45f1fc[_0x90df('0x30')]=_[_0x90df('0x31')](_0x3be2f8[_0x90df('0x2d')],qs[_0x90df('0x32')](_0x3b1895[_0x90df('0x2f')][_0x90df('0x32')]));_0x45f1fc[_0x90df('0x30')]=_0x45f1fc[_0x90df('0x30')][_0x90df('0x40')]?_0x45f1fc['attributes']:_0x3be2f8[_0x90df('0x2d')];_0x45f1fc[_0x90df('0x35')]=qs[_0x90df('0x36')](_0x3b1895[_0x90df('0x2f')]['sort']);_0x45f1fc[_0x90df('0x37')]=qs[_0x90df('0x38')](_[_0x90df('0x48')](_0x3b1895['query'],_0x3be2f8[_0x90df('0x38')]));if(_0x3b1895[_0x90df('0x2f')]['filter']){_0x45f1fc[_0x90df('0x37')]=_[_0x90df('0x39')](_0x45f1fc[_0x90df('0x37')],{'$or':_['map'](_0x45f1fc[_0x90df('0x30')],function(_0x5ab7e2){var _0x1bea6c={};_0x1bea6c[_0x5ab7e2]={'$like':'%'+_0x3b1895['query'][_0x90df('0x3a')]+'%'};return _0x1bea6c;})});}_0x45f1fc=_[_0x90df('0x39')]({},_0x45f1fc,_0x3b1895[_0x90df('0x4b')]);return _0x16130e['getDescriptions'](_0x45f1fc);}})[_0x90df('0x25')](function(_0x314dd7){if(_0x314dd7){_0x2ab2a2=_0x314dd7[_0x90df('0x40')];if(!_0x3b1895[_0x90df('0x2f')][_0x90df('0x33')]('nolimit')){_0x45f1fc[_0x90df('0x1e')]=qs['limit'](_0x3b1895[_0x90df('0x2f')][_0x90df('0x1e')]);_0x45f1fc[_0x90df('0x1d')]=qs[_0x90df('0x1d')](_0x3b1895[_0x90df('0x2f')][_0x90df('0x1d')]);}return _0x16130e[_0x90df('0x4c')](_0x45f1fc);}})[_0x90df('0x25')](function(_0x29c0cd){if(_0x29c0cd){return _0x29c0cd?{'count':_0x2ab2a2,'rows':_0x29c0cd}:null;}})[_0x90df('0x25')](respondWithResult(_0x26ac9a,null))[_0x90df('0x42')](handleError(_0x26ac9a,null));};