server/api/intSugarcrmConfiguration/intSugarcrmConfiguration.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 _0x7b8a=['getDescriptions','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','sox','to-csv','ejs','fs-extra','squel','crypto','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','undefined','count','limit','Content-Range','apply','reject','save','then','destroy','error','stack','name','index','SugarcrmConfiguration','rawAttributes','fieldName','type','key','model','map','query','keys','filters','attributes','intersection','fields','length','hasOwnProperty','order','sort','where','pick','filter','VIRTUAL','merge','options','includeAll','include','rows','show','find','catch','create','body','update','params','getFields','findOne','SugarcrmField','nolimit','getSubjects'];(function(_0x302650,_0x2238a5){var _0xfd6ab=function(_0x1cb5e9){while(--_0x1cb5e9){_0x302650['push'](_0x302650['shift']());}};_0xfd6ab(++_0x2238a5);}(_0x7b8a,0x19b));var _0xa7b8=function(_0x326d35,_0x4f65b3){_0x326d35=_0x326d35-0x0;var _0xd3f8f3=_0x7b8a[_0x326d35];return _0xd3f8f3;};'use strict';var emlformat=require(_0xa7b8('0x0'));var rimraf=require(_0xa7b8('0x1'));var zipdir=require(_0xa7b8('0x2'));var jsonpatch=require(_0xa7b8('0x3'));var rp=require(_0xa7b8('0x4'));var moment=require(_0xa7b8('0x5'));var BPromise=require(_0xa7b8('0x6'));var Mustache=require('mustache');var util=require(_0xa7b8('0x7'));var path=require('path');var sox=require(_0xa7b8('0x8'));var csv=require(_0xa7b8('0x9'));var ejs=require(_0xa7b8('0xa'));var fs=require('fs');var fs_extra=require(_0xa7b8('0xb'));var _=require('lodash');var squel=require(_0xa7b8('0xc'));var crypto=require(_0xa7b8('0xd'));var jsforce=require('jsforce');var deskjs=require(_0xa7b8('0xe'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0xa7b8('0xf'));var Redis=require(_0xa7b8('0x10'));var authService=require(_0xa7b8('0x11'));var qs=require(_0xa7b8('0x12'));var as=require(_0xa7b8('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xa7b8('0x14'))(_0xa7b8('0x15'));var utils=require(_0xa7b8('0x16'));var config=require('../../config/environment');var licenseUtil=require(_0xa7b8('0x17'));var db=require(_0xa7b8('0x18'))['db'];function respondWithStatusCode(_0x575763,_0x202902){_0x202902=_0x202902||0xcc;return function(_0x3be170){if(_0x3be170){return _0x575763[_0xa7b8('0x19')](_0x202902);}return _0x575763[_0xa7b8('0x1a')](_0x202902)[_0xa7b8('0x1b')]();};}function respondWithResult(_0x3fdcc6,_0x1f45dd){_0x1f45dd=_0x1f45dd||0xc8;return function(_0x5e2faf){if(_0x5e2faf){return _0x3fdcc6[_0xa7b8('0x1a')](_0x1f45dd)[_0xa7b8('0x1c')](_0x5e2faf);}};}function respondWithFilteredResult(_0x7b40f9,_0x1c7e88){return function(_0x596744){if(_0x596744){var _0x10ca93=typeof _0x1c7e88[_0xa7b8('0x1d')]===_0xa7b8('0x1e')&&typeof _0x1c7e88['limit']===_0xa7b8('0x1e');var _0x20e9de=_0x596744[_0xa7b8('0x1f')];var _0x3285a7=_0x10ca93?0x0:_0x1c7e88[_0xa7b8('0x1d')];var _0x31768c=_0x10ca93?_0x596744[_0xa7b8('0x1f')]:_0x1c7e88[_0xa7b8('0x1d')]+_0x1c7e88[_0xa7b8('0x20')];var _0x1441f4;if(_0x31768c>=_0x20e9de){_0x31768c=_0x20e9de;_0x1441f4=0xc8;}else{_0x1441f4=0xce;}_0x7b40f9[_0xa7b8('0x1a')](_0x1441f4);return _0x7b40f9['set'](_0xa7b8('0x21'),_0x3285a7+'-'+_0x31768c+'/'+_0x20e9de)['json'](_0x596744);}return null;};}function patchUpdates(_0x7581a0){return function(_0x2b5c80){try{jsonpatch[_0xa7b8('0x22')](_0x2b5c80,_0x7581a0,!![]);}catch(_0x1aa514){return BPromise[_0xa7b8('0x23')](_0x1aa514);}return _0x2b5c80[_0xa7b8('0x24')]();};}function saveUpdates(_0x1d449a,_0x112e99){return function(_0x46b22d){if(_0x46b22d){return _0x46b22d['update'](_0x1d449a)[_0xa7b8('0x25')](function(_0x804b7){return _0x804b7;});}return null;};}function removeEntity(_0x252069,_0xa9adb){return function(_0x3182c9){if(_0x3182c9){return _0x3182c9[_0xa7b8('0x26')]()[_0xa7b8('0x25')](function(){_0x252069[_0xa7b8('0x1a')](0xcc)[_0xa7b8('0x1b')]();});}};}function handleEntityNotFound(_0x2aa63c,_0x44c60e){return function(_0x14c728){if(!_0x14c728){_0x2aa63c['sendStatus'](0x194);}return _0x14c728;};}function handleError(_0x51afc7,_0x1e0a81){_0x1e0a81=_0x1e0a81||0x1f4;return function(_0x4b075d){logger[_0xa7b8('0x27')](_0x4b075d[_0xa7b8('0x28')]);if(_0x4b075d[_0xa7b8('0x29')]){delete _0x4b075d[_0xa7b8('0x29')];}_0x51afc7['status'](_0x1e0a81)['send'](_0x4b075d);};}exports[_0xa7b8('0x2a')]=function(_0x1b6300,_0x593549){var _0x454e7b={},_0x41c6cb={},_0x3c537b={'count':0x0,'rows':[]};var _0x546206=_['map'](db[_0xa7b8('0x2b')][_0xa7b8('0x2c')],function(_0x2913a2){return{'name':_0x2913a2[_0xa7b8('0x2d')],'type':_0x2913a2[_0xa7b8('0x2e')][_0xa7b8('0x2f')]};});_0x41c6cb[_0xa7b8('0x30')]=_[_0xa7b8('0x31')](_0x546206,'name');_0x41c6cb[_0xa7b8('0x32')]=_[_0xa7b8('0x33')](_0x1b6300[_0xa7b8('0x32')]);_0x41c6cb[_0xa7b8('0x34')]=_['intersection'](_0x41c6cb['model'],_0x41c6cb[_0xa7b8('0x32')]);_0x454e7b[_0xa7b8('0x35')]=_[_0xa7b8('0x36')](_0x41c6cb[_0xa7b8('0x30')],qs[_0xa7b8('0x37')](_0x1b6300[_0xa7b8('0x32')][_0xa7b8('0x37')]));_0x454e7b[_0xa7b8('0x35')]=_0x454e7b[_0xa7b8('0x35')][_0xa7b8('0x38')]?_0x454e7b[_0xa7b8('0x35')]:_0x41c6cb['model'];if(!_0x1b6300[_0xa7b8('0x32')][_0xa7b8('0x39')]('nolimit')){_0x454e7b[_0xa7b8('0x20')]=qs['limit'](_0x1b6300['query'][_0xa7b8('0x20')]);_0x454e7b[_0xa7b8('0x1d')]=qs['offset'](_0x1b6300['query']['offset']);}_0x454e7b[_0xa7b8('0x3a')]=qs[_0xa7b8('0x3b')](_0x1b6300[_0xa7b8('0x32')]['sort']);_0x454e7b[_0xa7b8('0x3c')]=qs[_0xa7b8('0x34')](_[_0xa7b8('0x3d')](_0x1b6300[_0xa7b8('0x32')],_0x41c6cb[_0xa7b8('0x34')]),_0x546206);if(_0x1b6300['query'][_0xa7b8('0x3e')]){_0x454e7b['where']=_['merge'](_0x454e7b[_0xa7b8('0x3c')],{'$or':_[_0xa7b8('0x31')](_0x546206,function(_0x4cff9b){if(_0x4cff9b[_0xa7b8('0x2e')]!==_0xa7b8('0x3f')){var _0x2b2661={};_0x2b2661[_0x4cff9b['name']]={'$like':'%'+_0x1b6300[_0xa7b8('0x32')]['filter']+'%'};return _0x2b2661;}})});}_0x454e7b=_[_0xa7b8('0x40')]({},_0x454e7b,_0x1b6300[_0xa7b8('0x41')]);var _0xfa3f7a={'where':_0x454e7b['where']};return db['SugarcrmConfiguration'][_0xa7b8('0x1f')](_0xfa3f7a)[_0xa7b8('0x25')](function(_0x2348fd){_0x3c537b['count']=_0x2348fd;if(_0x1b6300['query'][_0xa7b8('0x42')]){_0x454e7b[_0xa7b8('0x43')]=[{'all':!![]}];}return db[_0xa7b8('0x2b')]['findAll'](_0x454e7b);})[_0xa7b8('0x25')](function(_0xe3c9e7){_0x3c537b[_0xa7b8('0x44')]=_0xe3c9e7;return _0x3c537b;})[_0xa7b8('0x25')](respondWithFilteredResult(_0x593549,_0x454e7b))['catch'](handleError(_0x593549,null));};exports[_0xa7b8('0x45')]=function(_0x38185a,_0x210c02){var _0x3b0678={'raw':![],'where':{'id':_0x38185a['params']['id']}},_0x439c88={};_0x439c88[_0xa7b8('0x30')]=_[_0xa7b8('0x33')](db['SugarcrmConfiguration'][_0xa7b8('0x2c')]);_0x439c88['query']=_[_0xa7b8('0x33')](_0x38185a['query']);_0x439c88['filters']=_[_0xa7b8('0x36')](_0x439c88['model'],_0x439c88[_0xa7b8('0x32')]);_0x3b0678[_0xa7b8('0x35')]=_[_0xa7b8('0x36')](_0x439c88[_0xa7b8('0x30')],qs['fields'](_0x38185a[_0xa7b8('0x32')][_0xa7b8('0x37')]));_0x3b0678['attributes']=_0x3b0678[_0xa7b8('0x35')][_0xa7b8('0x38')]?_0x3b0678['attributes']:_0x439c88[_0xa7b8('0x30')];if(_0x38185a['query'][_0xa7b8('0x42')]){_0x3b0678[_0xa7b8('0x43')]=[{'all':!![]}];}_0x3b0678=_[_0xa7b8('0x40')]({},_0x3b0678,_0x38185a['options']);return db['SugarcrmConfiguration'][_0xa7b8('0x46')](_0x3b0678)[_0xa7b8('0x25')](handleEntityNotFound(_0x210c02,null))[_0xa7b8('0x25')](respondWithResult(_0x210c02,null))[_0xa7b8('0x47')](handleError(_0x210c02,null));};exports[_0xa7b8('0x48')]=function(_0x521272,_0x2d3ac8){return db[_0xa7b8('0x2b')][_0xa7b8('0x48')](_0x521272[_0xa7b8('0x49')],{})['then'](respondWithResult(_0x2d3ac8,0xc9))[_0xa7b8('0x47')](handleError(_0x2d3ac8,null));};exports[_0xa7b8('0x4a')]=function(_0x1530fb,_0x2765ed){if(_0x1530fb[_0xa7b8('0x49')]['id']){delete _0x1530fb['body']['id'];}return db[_0xa7b8('0x2b')][_0xa7b8('0x46')]({'where':{'id':_0x1530fb[_0xa7b8('0x4b')]['id']}})[_0xa7b8('0x25')](handleEntityNotFound(_0x2765ed,null))[_0xa7b8('0x25')](saveUpdates(_0x1530fb['body'],null))['then'](respondWithResult(_0x2765ed,null))[_0xa7b8('0x47')](handleError(_0x2765ed,null));};exports[_0xa7b8('0x26')]=function(_0x58ccee,_0x1e3066){return db[_0xa7b8('0x2b')][_0xa7b8('0x46')]({'where':{'id':_0x58ccee[_0xa7b8('0x4b')]['id']}})[_0xa7b8('0x25')](handleEntityNotFound(_0x1e3066,null))['then'](removeEntity(_0x1e3066,null))['catch'](handleError(_0x1e3066,null));};exports[_0xa7b8('0x4c')]=function(_0xdc935e,_0x398a93,_0x2c55c8){var _0x3a41fa={};var _0x2efa5e={};var _0x2bcdcf;var _0x548837;return db['SugarcrmConfiguration'][_0xa7b8('0x4d')]({'where':{'id':_0xdc935e[_0xa7b8('0x4b')]['id']}})[_0xa7b8('0x25')](handleEntityNotFound(_0x398a93,null))[_0xa7b8('0x25')](function(_0x44fd26){if(_0x44fd26){_0x2bcdcf=_0x44fd26;_0x2efa5e[_0xa7b8('0x30')]=_['keys'](db[_0xa7b8('0x4e')][_0xa7b8('0x2c')]);_0x2efa5e[_0xa7b8('0x32')]=_['keys'](_0xdc935e[_0xa7b8('0x32')]);_0x2efa5e['filters']=_['intersection'](_0x2efa5e[_0xa7b8('0x30')],_0x2efa5e[_0xa7b8('0x32')]);_0x3a41fa[_0xa7b8('0x35')]=_[_0xa7b8('0x36')](_0x2efa5e[_0xa7b8('0x30')],qs[_0xa7b8('0x37')](_0xdc935e[_0xa7b8('0x32')][_0xa7b8('0x37')]));_0x3a41fa['attributes']=_0x3a41fa[_0xa7b8('0x35')][_0xa7b8('0x38')]?_0x3a41fa['attributes']:_0x2efa5e[_0xa7b8('0x30')];_0x3a41fa[_0xa7b8('0x3a')]=qs['sort'](_0xdc935e[_0xa7b8('0x32')][_0xa7b8('0x3b')]);_0x3a41fa['where']=qs[_0xa7b8('0x34')](_[_0xa7b8('0x3d')](_0xdc935e[_0xa7b8('0x32')],_0x2efa5e[_0xa7b8('0x34')]));if(_0xdc935e[_0xa7b8('0x32')]['filter']){_0x3a41fa[_0xa7b8('0x3c')]=_['merge'](_0x3a41fa[_0xa7b8('0x3c')],{'$or':_[_0xa7b8('0x31')](_0x3a41fa['attributes'],function(_0x3d2a16){var _0x4310a7={};_0x4310a7[_0x3d2a16]={'$like':'%'+_0xdc935e[_0xa7b8('0x32')][_0xa7b8('0x3e')]+'%'};return _0x4310a7;})});}_0x3a41fa=_[_0xa7b8('0x40')]({},_0x3a41fa,_0xdc935e[_0xa7b8('0x41')]);return _0x2bcdcf['getFields'](_0x3a41fa);}})[_0xa7b8('0x25')](function(_0x20ed07){if(_0x20ed07){_0x548837=_0x20ed07[_0xa7b8('0x38')];if(!_0xdc935e['query'][_0xa7b8('0x39')](_0xa7b8('0x4f'))){_0x3a41fa[_0xa7b8('0x20')]=qs[_0xa7b8('0x20')](_0xdc935e[_0xa7b8('0x32')][_0xa7b8('0x20')]);_0x3a41fa[_0xa7b8('0x1d')]=qs[_0xa7b8('0x1d')](_0xdc935e[_0xa7b8('0x32')][_0xa7b8('0x1d')]);}return _0x2bcdcf[_0xa7b8('0x4c')](_0x3a41fa);}})[_0xa7b8('0x25')](function(_0x381ca8){if(_0x381ca8){return _0x381ca8?{'count':_0x548837,'rows':_0x381ca8}:null;}})[_0xa7b8('0x25')](respondWithResult(_0x398a93,null))[_0xa7b8('0x47')](handleError(_0x398a93,null));};exports[_0xa7b8('0x50')]=function(_0xf3bce5,_0x39c159,_0x56f11f){var _0x47bb2a={};var _0x9f1f3={};var _0x20baef;var _0x162204;return db[_0xa7b8('0x2b')][_0xa7b8('0x4d')]({'where':{'id':_0xf3bce5[_0xa7b8('0x4b')]['id']}})['then'](handleEntityNotFound(_0x39c159,null))[_0xa7b8('0x25')](function(_0x1f4d0d){if(_0x1f4d0d){_0x20baef=_0x1f4d0d;_0x9f1f3['model']=_[_0xa7b8('0x33')](db['SugarcrmField'][_0xa7b8('0x2c')]);_0x9f1f3[_0xa7b8('0x32')]=_[_0xa7b8('0x33')](_0xf3bce5[_0xa7b8('0x32')]);_0x9f1f3[_0xa7b8('0x34')]=_['intersection'](_0x9f1f3[_0xa7b8('0x30')],_0x9f1f3[_0xa7b8('0x32')]);_0x47bb2a[_0xa7b8('0x35')]=_[_0xa7b8('0x36')](_0x9f1f3[_0xa7b8('0x30')],qs[_0xa7b8('0x37')](_0xf3bce5[_0xa7b8('0x32')][_0xa7b8('0x37')]));_0x47bb2a[_0xa7b8('0x35')]=_0x47bb2a[_0xa7b8('0x35')][_0xa7b8('0x38')]?_0x47bb2a['attributes']:_0x9f1f3[_0xa7b8('0x30')];_0x47bb2a['order']=qs[_0xa7b8('0x3b')](_0xf3bce5[_0xa7b8('0x32')][_0xa7b8('0x3b')]);_0x47bb2a[_0xa7b8('0x3c')]=qs[_0xa7b8('0x34')](_[_0xa7b8('0x3d')](_0xf3bce5[_0xa7b8('0x32')],_0x9f1f3['filters']));if(_0xf3bce5[_0xa7b8('0x32')][_0xa7b8('0x3e')]){_0x47bb2a[_0xa7b8('0x3c')]=_[_0xa7b8('0x40')](_0x47bb2a['where'],{'$or':_[_0xa7b8('0x31')](_0x47bb2a[_0xa7b8('0x35')],function(_0x3a8693){var _0x4d658a={};_0x4d658a[_0x3a8693]={'$like':'%'+_0xf3bce5[_0xa7b8('0x32')][_0xa7b8('0x3e')]+'%'};return _0x4d658a;})});}_0x47bb2a=_[_0xa7b8('0x40')]({},_0x47bb2a,_0xf3bce5['options']);return _0x20baef[_0xa7b8('0x50')](_0x47bb2a);}})['then'](function(_0x22e35e){if(_0x22e35e){_0x162204=_0x22e35e['length'];if(!_0xf3bce5[_0xa7b8('0x32')][_0xa7b8('0x39')](_0xa7b8('0x4f'))){_0x47bb2a['limit']=qs['limit'](_0xf3bce5[_0xa7b8('0x32')][_0xa7b8('0x20')]);_0x47bb2a[_0xa7b8('0x1d')]=qs[_0xa7b8('0x1d')](_0xf3bce5[_0xa7b8('0x32')][_0xa7b8('0x1d')]);}return _0x20baef[_0xa7b8('0x50')](_0x47bb2a);}})[_0xa7b8('0x25')](function(_0x14743e){if(_0x14743e){return _0x14743e?{'count':_0x162204,'rows':_0x14743e}:null;}})[_0xa7b8('0x25')](respondWithResult(_0x39c159,null))[_0xa7b8('0x47')](handleError(_0x39c159,null));};exports[_0xa7b8('0x51')]=function(_0x29b857,_0x4b3818,_0x3405a8){var _0x5e4630={};var _0x41dc6f={};var _0x40dd79;var _0x46e107;return db[_0xa7b8('0x2b')]['findOne']({'where':{'id':_0x29b857[_0xa7b8('0x4b')]['id']}})[_0xa7b8('0x25')](handleEntityNotFound(_0x4b3818,null))[_0xa7b8('0x25')](function(_0x171b98){if(_0x171b98){_0x40dd79=_0x171b98;_0x41dc6f['model']=_[_0xa7b8('0x33')](db['SugarcrmField'][_0xa7b8('0x2c')]);_0x41dc6f[_0xa7b8('0x32')]=_[_0xa7b8('0x33')](_0x29b857[_0xa7b8('0x32')]);_0x41dc6f[_0xa7b8('0x34')]=_['intersection'](_0x41dc6f[_0xa7b8('0x30')],_0x41dc6f[_0xa7b8('0x32')]);_0x5e4630[_0xa7b8('0x35')]=_[_0xa7b8('0x36')](_0x41dc6f[_0xa7b8('0x30')],qs[_0xa7b8('0x37')](_0x29b857[_0xa7b8('0x32')]['fields']));_0x5e4630['attributes']=_0x5e4630['attributes'][_0xa7b8('0x38')]?_0x5e4630[_0xa7b8('0x35')]:_0x41dc6f[_0xa7b8('0x30')];_0x5e4630[_0xa7b8('0x3a')]=qs[_0xa7b8('0x3b')](_0x29b857[_0xa7b8('0x32')][_0xa7b8('0x3b')]);_0x5e4630[_0xa7b8('0x3c')]=qs['filters'](_[_0xa7b8('0x3d')](_0x29b857[_0xa7b8('0x32')],_0x41dc6f[_0xa7b8('0x34')]));if(_0x29b857['query'][_0xa7b8('0x3e')]){_0x5e4630[_0xa7b8('0x3c')]=_['merge'](_0x5e4630[_0xa7b8('0x3c')],{'$or':_['map'](_0x5e4630[_0xa7b8('0x35')],function(_0x4bb73b){var _0x25dd0a={};_0x25dd0a[_0x4bb73b]={'$like':'%'+_0x29b857[_0xa7b8('0x32')]['filter']+'%'};return _0x25dd0a;})});}_0x5e4630=_[_0xa7b8('0x40')]({},_0x5e4630,_0x29b857['options']);return _0x40dd79[_0xa7b8('0x51')](_0x5e4630);}})[_0xa7b8('0x25')](function(_0x5d9d45){if(_0x5d9d45){_0x46e107=_0x5d9d45['length'];if(!_0x29b857['query'][_0xa7b8('0x39')](_0xa7b8('0x4f'))){_0x5e4630[_0xa7b8('0x20')]=qs[_0xa7b8('0x20')](_0x29b857[_0xa7b8('0x32')][_0xa7b8('0x20')]);_0x5e4630[_0xa7b8('0x1d')]=qs[_0xa7b8('0x1d')](_0x29b857[_0xa7b8('0x32')][_0xa7b8('0x1d')]);}return _0x40dd79[_0xa7b8('0x51')](_0x5e4630);}})[_0xa7b8('0x25')](function(_0x20fc3f){if(_0x20fc3f){return _0x20fc3f?{'count':_0x46e107,'rows':_0x20fc3f}:null;}})[_0xa7b8('0x25')](respondWithResult(_0x4b3818,null))[_0xa7b8('0x47')](handleError(_0x4b3818,null));};