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 _0xe39c=['VtigerField','getDescriptions','eml-format','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','sendStatus','status','end','json','undefined','limit','count','offset','set','apply','reject','save','update','then','destroy','error','stack','name','send','index','map','VtigerConfiguration','rawAttributes','fieldName','key','query','keys','filters','model','intersection','fields','attributes','nolimit','order','sort','where','pick','filter','VIRTUAL','merge','includeAll','include','findAll','rows','catch','params','length','find','create','body','getFields','findOne','options','hasOwnProperty','getSubjects'];(function(_0x296db4,_0x3244dc){var _0x44e41c=function(_0x3c2119){while(--_0x3c2119){_0x296db4['push'](_0x296db4['shift']());}};_0x44e41c(++_0x3244dc);}(_0xe39c,0x14a));var _0xce39=function(_0x1f1222,_0x2a4de8){_0x1f1222=_0x1f1222-0x0;var _0x37ade0=_0xe39c[_0x1f1222];return _0x37ade0;};'use strict';var emlformat=require(_0xce39('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0xce39('0x1'));var rp=require(_0xce39('0x2'));var moment=require(_0xce39('0x3'));var BPromise=require(_0xce39('0x4'));var Mustache=require(_0xce39('0x5'));var util=require(_0xce39('0x6'));var path=require(_0xce39('0x7'));var sox=require(_0xce39('0x8'));var csv=require(_0xce39('0x9'));var ejs=require(_0xce39('0xa'));var fs=require('fs');var fs_extra=require(_0xce39('0xb'));var _=require(_0xce39('0xc'));var squel=require(_0xce39('0xd'));var crypto=require('crypto');var jsforce=require(_0xce39('0xe'));var deskjs=require(_0xce39('0xf'));var toCsv=require(_0xce39('0x9'));var querystring=require('querystring');var Papa=require(_0xce39('0x10'));var Redis=require(_0xce39('0x11'));var authService=require(_0xce39('0x12'));var qs=require('../../components/parsers/qs');var as=require(_0xce39('0x13'));var hardwareService=require(_0xce39('0x14'));var logger=require('../../config/logger')(_0xce39('0x15'));var utils=require(_0xce39('0x16'));var config=require(_0xce39('0x17'));var licenseUtil=require(_0xce39('0x18'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x4caf51,_0x1ff2e4){_0x1ff2e4=_0x1ff2e4||0xcc;return function(_0x4cd43a){if(_0x4cd43a){return _0x4caf51[_0xce39('0x19')](_0x1ff2e4);}return _0x4caf51[_0xce39('0x1a')](_0x1ff2e4)[_0xce39('0x1b')]();};}function respondWithResult(_0x567617,_0x537a64){_0x537a64=_0x537a64||0xc8;return function(_0x4342c6){if(_0x4342c6){return _0x567617[_0xce39('0x1a')](_0x537a64)[_0xce39('0x1c')](_0x4342c6);}};}function respondWithFilteredResult(_0x486b01,_0x1f1b5b){return function(_0x3a5572){if(_0x3a5572){var _0x281362=typeof _0x1f1b5b['offset']===_0xce39('0x1d')&&typeof _0x1f1b5b[_0xce39('0x1e')]===_0xce39('0x1d');var _0x529a71=_0x3a5572[_0xce39('0x1f')];var _0x31de58=_0x281362?0x0:_0x1f1b5b['offset'];var _0x42e280=_0x281362?_0x3a5572['count']:_0x1f1b5b[_0xce39('0x20')]+_0x1f1b5b[_0xce39('0x1e')];var _0x3d9935;if(_0x42e280>=_0x529a71){_0x42e280=_0x529a71;_0x3d9935=0xc8;}else{_0x3d9935=0xce;}_0x486b01[_0xce39('0x1a')](_0x3d9935);return _0x486b01[_0xce39('0x21')]('Content-Range',_0x31de58+'-'+_0x42e280+'/'+_0x529a71)[_0xce39('0x1c')](_0x3a5572);}return null;};}function patchUpdates(_0x45d657){return function(_0x36a736){try{jsonpatch[_0xce39('0x22')](_0x36a736,_0x45d657,!![]);}catch(_0x5c6045){return BPromise[_0xce39('0x23')](_0x5c6045);}return _0x36a736[_0xce39('0x24')]();};}function saveUpdates(_0x1e12e9,_0xd1f528){return function(_0x20d61a){if(_0x20d61a){return _0x20d61a[_0xce39('0x25')](_0x1e12e9)[_0xce39('0x26')](function(_0x47ea91){return _0x47ea91;});}return null;};}function removeEntity(_0x1f1bce,_0x6009cb){return function(_0xc8a4c4){if(_0xc8a4c4){return _0xc8a4c4[_0xce39('0x27')]()[_0xce39('0x26')](function(){_0x1f1bce[_0xce39('0x1a')](0xcc)[_0xce39('0x1b')]();});}};}function handleEntityNotFound(_0x10b1e9,_0x435b11){return function(_0x16d6d4){if(!_0x16d6d4){_0x10b1e9['sendStatus'](0x194);}return _0x16d6d4;};}function handleError(_0x2455aa,_0x201f3e){_0x201f3e=_0x201f3e||0x1f4;return function(_0x21fa19){logger[_0xce39('0x28')](_0x21fa19[_0xce39('0x29')]);if(_0x21fa19[_0xce39('0x2a')]){delete _0x21fa19[_0xce39('0x2a')];}_0x2455aa[_0xce39('0x1a')](_0x201f3e)[_0xce39('0x2b')](_0x21fa19);};}exports[_0xce39('0x2c')]=function(_0xc504ef,_0x419abf){var _0x1848db={},_0x17343b={},_0x22a791={'count':0x0,'rows':[]};var _0x10d475=_[_0xce39('0x2d')](db[_0xce39('0x2e')][_0xce39('0x2f')],function(_0x5ca555){return{'name':_0x5ca555[_0xce39('0x30')],'type':_0x5ca555['type'][_0xce39('0x31')]};});_0x17343b['model']=_[_0xce39('0x2d')](_0x10d475,_0xce39('0x2a'));_0x17343b[_0xce39('0x32')]=_[_0xce39('0x33')](_0xc504ef['query']);_0x17343b[_0xce39('0x34')]=_['intersection'](_0x17343b[_0xce39('0x35')],_0x17343b['query']);_0x1848db['attributes']=_[_0xce39('0x36')](_0x17343b['model'],qs['fields'](_0xc504ef[_0xce39('0x32')][_0xce39('0x37')]));_0x1848db[_0xce39('0x38')]=_0x1848db[_0xce39('0x38')]['length']?_0x1848db[_0xce39('0x38')]:_0x17343b[_0xce39('0x35')];if(!_0xc504ef['query']['hasOwnProperty'](_0xce39('0x39'))){_0x1848db[_0xce39('0x1e')]=qs[_0xce39('0x1e')](_0xc504ef[_0xce39('0x32')]['limit']);_0x1848db[_0xce39('0x20')]=qs['offset'](_0xc504ef['query'][_0xce39('0x20')]);}_0x1848db[_0xce39('0x3a')]=qs[_0xce39('0x3b')](_0xc504ef[_0xce39('0x32')][_0xce39('0x3b')]);_0x1848db[_0xce39('0x3c')]=qs[_0xce39('0x34')](_[_0xce39('0x3d')](_0xc504ef[_0xce39('0x32')],_0x17343b[_0xce39('0x34')]),_0x10d475);if(_0xc504ef['query'][_0xce39('0x3e')]){_0x1848db[_0xce39('0x3c')]=_['merge'](_0x1848db[_0xce39('0x3c')],{'$or':_[_0xce39('0x2d')](_0x10d475,function(_0x5e6757){if(_0x5e6757['type']!==_0xce39('0x3f')){var _0x3a190e={};_0x3a190e[_0x5e6757[_0xce39('0x2a')]]={'$like':'%'+_0xc504ef[_0xce39('0x32')][_0xce39('0x3e')]+'%'};return _0x3a190e;}})});}_0x1848db=_[_0xce39('0x40')]({},_0x1848db,_0xc504ef['options']);var _0x4c3288={'where':_0x1848db['where']};return db[_0xce39('0x2e')][_0xce39('0x1f')](_0x4c3288)[_0xce39('0x26')](function(_0x3d9a5d){_0x22a791['count']=_0x3d9a5d;if(_0xc504ef[_0xce39('0x32')][_0xce39('0x41')]){_0x1848db[_0xce39('0x42')]=[{'all':!![]}];}return db[_0xce39('0x2e')][_0xce39('0x43')](_0x1848db);})['then'](function(_0x1ba9f2){_0x22a791[_0xce39('0x44')]=_0x1ba9f2;return _0x22a791;})[_0xce39('0x26')](respondWithFilteredResult(_0x419abf,_0x1848db))[_0xce39('0x45')](handleError(_0x419abf,null));};exports['show']=function(_0x3a6457,_0x559fea){var _0x295826={'raw':![],'where':{'id':_0x3a6457[_0xce39('0x46')]['id']}},_0x3c1e04={};_0x3c1e04[_0xce39('0x35')]=_['keys'](db[_0xce39('0x2e')][_0xce39('0x2f')]);_0x3c1e04[_0xce39('0x32')]=_[_0xce39('0x33')](_0x3a6457[_0xce39('0x32')]);_0x3c1e04['filters']=_[_0xce39('0x36')](_0x3c1e04[_0xce39('0x35')],_0x3c1e04['query']);_0x295826[_0xce39('0x38')]=_[_0xce39('0x36')](_0x3c1e04[_0xce39('0x35')],qs[_0xce39('0x37')](_0x3a6457[_0xce39('0x32')]['fields']));_0x295826[_0xce39('0x38')]=_0x295826[_0xce39('0x38')][_0xce39('0x47')]?_0x295826[_0xce39('0x38')]:_0x3c1e04[_0xce39('0x35')];if(_0x3a6457[_0xce39('0x32')][_0xce39('0x41')]){_0x295826['include']=[{'all':!![]}];}_0x295826=_['merge']({},_0x295826,_0x3a6457['options']);return db[_0xce39('0x2e')][_0xce39('0x48')](_0x295826)[_0xce39('0x26')](handleEntityNotFound(_0x559fea,null))[_0xce39('0x26')](respondWithResult(_0x559fea,null))[_0xce39('0x45')](handleError(_0x559fea,null));};exports[_0xce39('0x49')]=function(_0x483eaa,_0x497317){return db['VtigerConfiguration'][_0xce39('0x49')](_0x483eaa['body'],{})[_0xce39('0x26')](respondWithResult(_0x497317,0xc9))[_0xce39('0x45')](handleError(_0x497317,null));};exports[_0xce39('0x25')]=function(_0x424798,_0x4b2cb2){if(_0x424798['body']['id']){delete _0x424798['body']['id'];}return db[_0xce39('0x2e')][_0xce39('0x48')]({'where':{'id':_0x424798[_0xce39('0x46')]['id']}})[_0xce39('0x26')](handleEntityNotFound(_0x4b2cb2,null))[_0xce39('0x26')](saveUpdates(_0x424798[_0xce39('0x4a')],null))[_0xce39('0x26')](respondWithResult(_0x4b2cb2,null))[_0xce39('0x45')](handleError(_0x4b2cb2,null));};exports[_0xce39('0x27')]=function(_0x18e8af,_0x7c4bdc){return db[_0xce39('0x2e')][_0xce39('0x48')]({'where':{'id':_0x18e8af[_0xce39('0x46')]['id']}})[_0xce39('0x26')](handleEntityNotFound(_0x7c4bdc,null))['then'](removeEntity(_0x7c4bdc,null))[_0xce39('0x45')](handleError(_0x7c4bdc,null));};exports[_0xce39('0x4b')]=function(_0x2fa7e9,_0x4b9f18,_0x580298){var _0xb3cbf9={};var _0x1aa70e={};var _0x4a877a;var _0x3cefc4;return db[_0xce39('0x2e')][_0xce39('0x4c')]({'where':{'id':_0x2fa7e9[_0xce39('0x46')]['id']}})['then'](handleEntityNotFound(_0x4b9f18,null))[_0xce39('0x26')](function(_0x421eee){if(_0x421eee){_0x4a877a=_0x421eee;_0x1aa70e[_0xce39('0x35')]=_['keys'](db['VtigerField']['rawAttributes']);_0x1aa70e[_0xce39('0x32')]=_['keys'](_0x2fa7e9[_0xce39('0x32')]);_0x1aa70e[_0xce39('0x34')]=_[_0xce39('0x36')](_0x1aa70e[_0xce39('0x35')],_0x1aa70e['query']);_0xb3cbf9[_0xce39('0x38')]=_[_0xce39('0x36')](_0x1aa70e[_0xce39('0x35')],qs[_0xce39('0x37')](_0x2fa7e9[_0xce39('0x32')][_0xce39('0x37')]));_0xb3cbf9[_0xce39('0x38')]=_0xb3cbf9['attributes'][_0xce39('0x47')]?_0xb3cbf9['attributes']:_0x1aa70e['model'];_0xb3cbf9[_0xce39('0x3a')]=qs[_0xce39('0x3b')](_0x2fa7e9[_0xce39('0x32')][_0xce39('0x3b')]);_0xb3cbf9[_0xce39('0x3c')]=qs[_0xce39('0x34')](_['pick'](_0x2fa7e9['query'],_0x1aa70e[_0xce39('0x34')]));if(_0x2fa7e9[_0xce39('0x32')][_0xce39('0x3e')]){_0xb3cbf9['where']=_[_0xce39('0x40')](_0xb3cbf9[_0xce39('0x3c')],{'$or':_[_0xce39('0x2d')](_0xb3cbf9[_0xce39('0x38')],function(_0x31b51c){var _0x242910={};_0x242910[_0x31b51c]={'$like':'%'+_0x2fa7e9[_0xce39('0x32')][_0xce39('0x3e')]+'%'};return _0x242910;})});}_0xb3cbf9=_[_0xce39('0x40')]({},_0xb3cbf9,_0x2fa7e9[_0xce39('0x4d')]);return _0x4a877a[_0xce39('0x4b')](_0xb3cbf9);}})[_0xce39('0x26')](function(_0x3f3738){if(_0x3f3738){_0x3cefc4=_0x3f3738[_0xce39('0x47')];if(!_0x2fa7e9[_0xce39('0x32')][_0xce39('0x4e')](_0xce39('0x39'))){_0xb3cbf9[_0xce39('0x1e')]=qs[_0xce39('0x1e')](_0x2fa7e9[_0xce39('0x32')][_0xce39('0x1e')]);_0xb3cbf9[_0xce39('0x20')]=qs[_0xce39('0x20')](_0x2fa7e9[_0xce39('0x32')]['offset']);}return _0x4a877a[_0xce39('0x4b')](_0xb3cbf9);}})[_0xce39('0x26')](function(_0x57ed34){if(_0x57ed34){return _0x57ed34?{'count':_0x3cefc4,'rows':_0x57ed34}:null;}})[_0xce39('0x26')](respondWithResult(_0x4b9f18,null))[_0xce39('0x45')](handleError(_0x4b9f18,null));};exports[_0xce39('0x4f')]=function(_0x535b75,_0xcda15a,_0x39ad0e){var _0x258efa={};var _0x528114={};var _0x574dd0;var _0x564ee3;return db[_0xce39('0x2e')]['findOne']({'where':{'id':_0x535b75['params']['id']}})[_0xce39('0x26')](handleEntityNotFound(_0xcda15a,null))[_0xce39('0x26')](function(_0x3dd924){if(_0x3dd924){_0x574dd0=_0x3dd924;_0x528114[_0xce39('0x35')]=_[_0xce39('0x33')](db[_0xce39('0x50')]['rawAttributes']);_0x528114[_0xce39('0x32')]=_[_0xce39('0x33')](_0x535b75[_0xce39('0x32')]);_0x528114[_0xce39('0x34')]=_[_0xce39('0x36')](_0x528114[_0xce39('0x35')],_0x528114[_0xce39('0x32')]);_0x258efa[_0xce39('0x38')]=_[_0xce39('0x36')](_0x528114[_0xce39('0x35')],qs[_0xce39('0x37')](_0x535b75[_0xce39('0x32')][_0xce39('0x37')]));_0x258efa['attributes']=_0x258efa['attributes'][_0xce39('0x47')]?_0x258efa[_0xce39('0x38')]:_0x528114[_0xce39('0x35')];_0x258efa[_0xce39('0x3a')]=qs[_0xce39('0x3b')](_0x535b75[_0xce39('0x32')][_0xce39('0x3b')]);_0x258efa['where']=qs[_0xce39('0x34')](_[_0xce39('0x3d')](_0x535b75[_0xce39('0x32')],_0x528114[_0xce39('0x34')]));if(_0x535b75[_0xce39('0x32')][_0xce39('0x3e')]){_0x258efa[_0xce39('0x3c')]=_[_0xce39('0x40')](_0x258efa['where'],{'$or':_[_0xce39('0x2d')](_0x258efa[_0xce39('0x38')],function(_0x1bf458){var _0x3516e6={};_0x3516e6[_0x1bf458]={'$like':'%'+_0x535b75[_0xce39('0x32')]['filter']+'%'};return _0x3516e6;})});}_0x258efa=_['merge']({},_0x258efa,_0x535b75[_0xce39('0x4d')]);return _0x574dd0[_0xce39('0x4f')](_0x258efa);}})[_0xce39('0x26')](function(_0x3f6502){if(_0x3f6502){_0x564ee3=_0x3f6502[_0xce39('0x47')];if(!_0x535b75[_0xce39('0x32')][_0xce39('0x4e')](_0xce39('0x39'))){_0x258efa[_0xce39('0x1e')]=qs[_0xce39('0x1e')](_0x535b75[_0xce39('0x32')]['limit']);_0x258efa[_0xce39('0x20')]=qs[_0xce39('0x20')](_0x535b75[_0xce39('0x32')][_0xce39('0x20')]);}return _0x574dd0[_0xce39('0x4f')](_0x258efa);}})['then'](function(_0x57a516){if(_0x57a516){return _0x57a516?{'count':_0x564ee3,'rows':_0x57a516}:null;}})['then'](respondWithResult(_0xcda15a,null))[_0xce39('0x45')](handleError(_0xcda15a,null));};exports['getDescriptions']=function(_0x14d235,_0x3a916b,_0x43e1d6){var _0x202253={};var _0x146bfa={};var _0x2addd8;var _0x2e980a;return db['VtigerConfiguration'][_0xce39('0x4c')]({'where':{'id':_0x14d235[_0xce39('0x46')]['id']}})['then'](handleEntityNotFound(_0x3a916b,null))[_0xce39('0x26')](function(_0x18df2e){if(_0x18df2e){_0x2addd8=_0x18df2e;_0x146bfa[_0xce39('0x35')]=_[_0xce39('0x33')](db[_0xce39('0x50')][_0xce39('0x2f')]);_0x146bfa['query']=_[_0xce39('0x33')](_0x14d235[_0xce39('0x32')]);_0x146bfa[_0xce39('0x34')]=_[_0xce39('0x36')](_0x146bfa[_0xce39('0x35')],_0x146bfa[_0xce39('0x32')]);_0x202253[_0xce39('0x38')]=_[_0xce39('0x36')](_0x146bfa[_0xce39('0x35')],qs[_0xce39('0x37')](_0x14d235[_0xce39('0x32')][_0xce39('0x37')]));_0x202253['attributes']=_0x202253[_0xce39('0x38')][_0xce39('0x47')]?_0x202253[_0xce39('0x38')]:_0x146bfa[_0xce39('0x35')];_0x202253[_0xce39('0x3a')]=qs['sort'](_0x14d235['query'][_0xce39('0x3b')]);_0x202253['where']=qs[_0xce39('0x34')](_[_0xce39('0x3d')](_0x14d235['query'],_0x146bfa['filters']));if(_0x14d235['query']['filter']){_0x202253[_0xce39('0x3c')]=_['merge'](_0x202253[_0xce39('0x3c')],{'$or':_[_0xce39('0x2d')](_0x202253[_0xce39('0x38')],function(_0x3e9840){var _0x2ba722={};_0x2ba722[_0x3e9840]={'$like':'%'+_0x14d235['query'][_0xce39('0x3e')]+'%'};return _0x2ba722;})});}_0x202253=_['merge']({},_0x202253,_0x14d235['options']);return _0x2addd8[_0xce39('0x51')](_0x202253);}})[_0xce39('0x26')](function(_0x349d7f){if(_0x349d7f){_0x2e980a=_0x349d7f[_0xce39('0x47')];if(!_0x14d235[_0xce39('0x32')]['hasOwnProperty'](_0xce39('0x39'))){_0x202253['limit']=qs[_0xce39('0x1e')](_0x14d235['query'][_0xce39('0x1e')]);_0x202253['offset']=qs[_0xce39('0x20')](_0x14d235[_0xce39('0x32')][_0xce39('0x20')]);}return _0x2addd8[_0xce39('0x51')](_0x202253);}})['then'](function(_0x1f5ad0){if(_0x1f5ad0){return _0x1f5ad0?{'count':_0x2e980a,'rows':_0x1f5ad0}:null;}})[_0xce39('0x26')](respondWithResult(_0x3a916b,null))[_0xce39('0x45')](handleError(_0x3a916b,null));};