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 _0xf22c=['../../config/license/hardware','api','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','count','Content-Range','apply','reject','save','update','then','destroy','error','stack','name','send','index','map','rawAttributes','type','keys','query','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','VIRTUAL','merge','VtigerConfiguration','includeAll','include','findAll','catch','show','params','options','find','create','body','getFields','VtigerField','getSubjects','findOne','getDescriptions','zip-dir','fast-json-patch','request-promise','bluebird','mustache','sox','to-csv','ejs','fs-extra','lodash','squel','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch'];(function(_0x46f4f1,_0x896f68){var _0x2d2e79=function(_0x461f19){while(--_0x461f19){_0x46f4f1['push'](_0x46f4f1['shift']());}};_0x2d2e79(++_0x896f68);}(_0xf22c,0x11c));var _0xcf22=function(_0x525900,_0x1d14da){_0x525900=_0x525900-0x0;var _0x3a6c50=_0xf22c[_0x525900];return _0x3a6c50;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0xcf22('0x0'));var jsonpatch=require(_0xcf22('0x1'));var rp=require(_0xcf22('0x2'));var moment=require('moment');var BPromise=require(_0xcf22('0x3'));var Mustache=require(_0xcf22('0x4'));var util=require('util');var path=require('path');var sox=require(_0xcf22('0x5'));var csv=require(_0xcf22('0x6'));var ejs=require(_0xcf22('0x7'));var fs=require('fs');var fs_extra=require(_0xcf22('0x8'));var _=require(_0xcf22('0x9'));var squel=require(_0xcf22('0xa'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0xcf22('0x6'));var querystring=require(_0xcf22('0xb'));var Papa=require(_0xcf22('0xc'));var Redis=require(_0xcf22('0xd'));var authService=require(_0xcf22('0xe'));var qs=require('../../components/parsers/qs');var as=require(_0xcf22('0xf'));var hardwareService=require(_0xcf22('0x10'));var logger=require('../../config/logger')(_0xcf22('0x11'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require(_0xcf22('0x12'))['db'];function respondWithStatusCode(_0x75aa14,_0x3c1325){_0x3c1325=_0x3c1325||0xcc;return function(_0x284bb2){if(_0x284bb2){return _0x75aa14[_0xcf22('0x13')](_0x3c1325);}return _0x75aa14[_0xcf22('0x14')](_0x3c1325)[_0xcf22('0x15')]();};}function respondWithResult(_0x5e85dd,_0x367de9){_0x367de9=_0x367de9||0xc8;return function(_0x30fc63){if(_0x30fc63){return _0x5e85dd[_0xcf22('0x14')](_0x367de9)[_0xcf22('0x16')](_0x30fc63);}};}function respondWithFilteredResult(_0x5c3332,_0x53af40){return function(_0xc7f8ff){if(_0xc7f8ff){var _0x3263c1=typeof _0x53af40[_0xcf22('0x17')]===_0xcf22('0x18')&&typeof _0x53af40[_0xcf22('0x19')]==='undefined';var _0x145c15=_0xc7f8ff[_0xcf22('0x1a')];var _0x1b2893=_0x3263c1?0x0:_0x53af40[_0xcf22('0x17')];var _0x30b229=_0x3263c1?_0xc7f8ff['count']:_0x53af40[_0xcf22('0x17')]+_0x53af40[_0xcf22('0x19')];var _0x4be913;if(_0x30b229>=_0x145c15){_0x30b229=_0x145c15;_0x4be913=0xc8;}else{_0x4be913=0xce;}_0x5c3332[_0xcf22('0x14')](_0x4be913);return _0x5c3332['set'](_0xcf22('0x1b'),_0x1b2893+'-'+_0x30b229+'/'+_0x145c15)[_0xcf22('0x16')](_0xc7f8ff);}return null;};}function patchUpdates(_0x4a18d2){return function(_0x163c3c){try{jsonpatch[_0xcf22('0x1c')](_0x163c3c,_0x4a18d2,!![]);}catch(_0x913ae2){return BPromise[_0xcf22('0x1d')](_0x913ae2);}return _0x163c3c[_0xcf22('0x1e')]();};}function saveUpdates(_0x599c4a,_0x3a8bcf){return function(_0x388aa2){if(_0x388aa2){return _0x388aa2[_0xcf22('0x1f')](_0x599c4a)[_0xcf22('0x20')](function(_0x17f603){return _0x17f603;});}return null;};}function removeEntity(_0x5bbc3c,_0x54fcf2){return function(_0x39a2c7){if(_0x39a2c7){return _0x39a2c7[_0xcf22('0x21')]()['then'](function(){_0x5bbc3c[_0xcf22('0x14')](0xcc)[_0xcf22('0x15')]();});}};}function handleEntityNotFound(_0x3c4136,_0xd17d8a){return function(_0x51824e){if(!_0x51824e){_0x3c4136[_0xcf22('0x13')](0x194);}return _0x51824e;};}function handleError(_0x3f4907,_0x4ff84e){_0x4ff84e=_0x4ff84e||0x1f4;return function(_0x3d5ba0){logger[_0xcf22('0x22')](_0x3d5ba0[_0xcf22('0x23')]);if(_0x3d5ba0['name']){delete _0x3d5ba0[_0xcf22('0x24')];}_0x3f4907['status'](_0x4ff84e)[_0xcf22('0x25')](_0x3d5ba0);};}exports[_0xcf22('0x26')]=function(_0x194e9c,_0x29f511){var _0x30599d={},_0x180b6b={},_0x12fcd3={'count':0x0,'rows':[]};var _0x44372e=_[_0xcf22('0x27')](db['VtigerConfiguration'][_0xcf22('0x28')],function(_0x5aafed){return{'name':_0x5aafed['fieldName'],'type':_0x5aafed[_0xcf22('0x29')]['key']};});_0x180b6b['model']=_['map'](_0x44372e,'name');_0x180b6b['query']=_[_0xcf22('0x2a')](_0x194e9c[_0xcf22('0x2b')]);_0x180b6b['filters']=_[_0xcf22('0x2c')](_0x180b6b[_0xcf22('0x2d')],_0x180b6b[_0xcf22('0x2b')]);_0x30599d[_0xcf22('0x2e')]=_[_0xcf22('0x2c')](_0x180b6b[_0xcf22('0x2d')],qs[_0xcf22('0x2f')](_0x194e9c[_0xcf22('0x2b')][_0xcf22('0x2f')]));_0x30599d['attributes']=_0x30599d[_0xcf22('0x2e')][_0xcf22('0x30')]?_0x30599d[_0xcf22('0x2e')]:_0x180b6b[_0xcf22('0x2d')];if(!_0x194e9c[_0xcf22('0x2b')][_0xcf22('0x31')](_0xcf22('0x32'))){_0x30599d[_0xcf22('0x19')]=qs[_0xcf22('0x19')](_0x194e9c[_0xcf22('0x2b')][_0xcf22('0x19')]);_0x30599d[_0xcf22('0x17')]=qs['offset'](_0x194e9c[_0xcf22('0x2b')][_0xcf22('0x17')]);}_0x30599d[_0xcf22('0x33')]=qs[_0xcf22('0x34')](_0x194e9c[_0xcf22('0x2b')][_0xcf22('0x34')]);_0x30599d[_0xcf22('0x35')]=qs[_0xcf22('0x36')](_[_0xcf22('0x37')](_0x194e9c[_0xcf22('0x2b')],_0x180b6b['filters']),_0x44372e);if(_0x194e9c[_0xcf22('0x2b')][_0xcf22('0x38')]){_0x30599d[_0xcf22('0x35')]=_['merge'](_0x30599d[_0xcf22('0x35')],{'$or':_['map'](_0x44372e,function(_0xe6c759){if(_0xe6c759['type']!==_0xcf22('0x39')){var _0x5a9de1={};_0x5a9de1[_0xe6c759['name']]={'$like':'%'+_0x194e9c[_0xcf22('0x2b')][_0xcf22('0x38')]+'%'};return _0x5a9de1;}})});}_0x30599d=_[_0xcf22('0x3a')]({},_0x30599d,_0x194e9c['options']);var _0x179ba6={'where':_0x30599d[_0xcf22('0x35')]};return db[_0xcf22('0x3b')][_0xcf22('0x1a')](_0x179ba6)[_0xcf22('0x20')](function(_0x5a5947){_0x12fcd3[_0xcf22('0x1a')]=_0x5a5947;if(_0x194e9c[_0xcf22('0x2b')][_0xcf22('0x3c')]){_0x30599d[_0xcf22('0x3d')]=[{'all':!![]}];}return db[_0xcf22('0x3b')][_0xcf22('0x3e')](_0x30599d);})['then'](function(_0x3eaef7){_0x12fcd3['rows']=_0x3eaef7;return _0x12fcd3;})[_0xcf22('0x20')](respondWithFilteredResult(_0x29f511,_0x30599d))[_0xcf22('0x3f')](handleError(_0x29f511,null));};exports[_0xcf22('0x40')]=function(_0xb1e396,_0x18cada){var _0x5f2ae4={'raw':![],'where':{'id':_0xb1e396[_0xcf22('0x41')]['id']}},_0x5a4d41={};_0x5a4d41[_0xcf22('0x2d')]=_['keys'](db[_0xcf22('0x3b')][_0xcf22('0x28')]);_0x5a4d41[_0xcf22('0x2b')]=_[_0xcf22('0x2a')](_0xb1e396[_0xcf22('0x2b')]);_0x5a4d41[_0xcf22('0x36')]=_[_0xcf22('0x2c')](_0x5a4d41[_0xcf22('0x2d')],_0x5a4d41[_0xcf22('0x2b')]);_0x5f2ae4['attributes']=_[_0xcf22('0x2c')](_0x5a4d41[_0xcf22('0x2d')],qs[_0xcf22('0x2f')](_0xb1e396[_0xcf22('0x2b')][_0xcf22('0x2f')]));_0x5f2ae4[_0xcf22('0x2e')]=_0x5f2ae4['attributes'][_0xcf22('0x30')]?_0x5f2ae4[_0xcf22('0x2e')]:_0x5a4d41['model'];if(_0xb1e396[_0xcf22('0x2b')][_0xcf22('0x3c')]){_0x5f2ae4[_0xcf22('0x3d')]=[{'all':!![]}];}_0x5f2ae4=_[_0xcf22('0x3a')]({},_0x5f2ae4,_0xb1e396[_0xcf22('0x42')]);return db['VtigerConfiguration'][_0xcf22('0x43')](_0x5f2ae4)[_0xcf22('0x20')](handleEntityNotFound(_0x18cada,null))[_0xcf22('0x20')](respondWithResult(_0x18cada,null))[_0xcf22('0x3f')](handleError(_0x18cada,null));};exports['create']=function(_0x5c099c,_0x40d7d9){return db['VtigerConfiguration'][_0xcf22('0x44')](_0x5c099c[_0xcf22('0x45')],{})[_0xcf22('0x20')](respondWithResult(_0x40d7d9,0xc9))['catch'](handleError(_0x40d7d9,null));};exports['update']=function(_0x1a5d90,_0x2b1200){if(_0x1a5d90[_0xcf22('0x45')]['id']){delete _0x1a5d90[_0xcf22('0x45')]['id'];}return db['VtigerConfiguration']['find']({'where':{'id':_0x1a5d90[_0xcf22('0x41')]['id']}})['then'](handleEntityNotFound(_0x2b1200,null))[_0xcf22('0x20')](saveUpdates(_0x1a5d90[_0xcf22('0x45')],null))[_0xcf22('0x20')](respondWithResult(_0x2b1200,null))[_0xcf22('0x3f')](handleError(_0x2b1200,null));};exports[_0xcf22('0x21')]=function(_0x217d5a,_0x1acb9a){return db[_0xcf22('0x3b')][_0xcf22('0x43')]({'where':{'id':_0x217d5a['params']['id']}})[_0xcf22('0x20')](handleEntityNotFound(_0x1acb9a,null))[_0xcf22('0x20')](removeEntity(_0x1acb9a,null))['catch'](handleError(_0x1acb9a,null));};exports[_0xcf22('0x46')]=function(_0x36bd3b,_0x203896,_0xaf7145){var _0x530e75={};var _0xefdbf9={};var _0x11f862;var _0x5e8c62;return db[_0xcf22('0x3b')]['findOne']({'where':{'id':_0x36bd3b[_0xcf22('0x41')]['id']}})['then'](handleEntityNotFound(_0x203896,null))['then'](function(_0xaa95d1){if(_0xaa95d1){_0x11f862=_0xaa95d1;_0xefdbf9['model']=_[_0xcf22('0x2a')](db[_0xcf22('0x47')][_0xcf22('0x28')]);_0xefdbf9[_0xcf22('0x2b')]=_[_0xcf22('0x2a')](_0x36bd3b[_0xcf22('0x2b')]);_0xefdbf9[_0xcf22('0x36')]=_['intersection'](_0xefdbf9[_0xcf22('0x2d')],_0xefdbf9[_0xcf22('0x2b')]);_0x530e75[_0xcf22('0x2e')]=_[_0xcf22('0x2c')](_0xefdbf9[_0xcf22('0x2d')],qs[_0xcf22('0x2f')](_0x36bd3b[_0xcf22('0x2b')][_0xcf22('0x2f')]));_0x530e75['attributes']=_0x530e75['attributes'][_0xcf22('0x30')]?_0x530e75[_0xcf22('0x2e')]:_0xefdbf9[_0xcf22('0x2d')];_0x530e75['order']=qs['sort'](_0x36bd3b['query'][_0xcf22('0x34')]);_0x530e75[_0xcf22('0x35')]=qs[_0xcf22('0x36')](_[_0xcf22('0x37')](_0x36bd3b[_0xcf22('0x2b')],_0xefdbf9[_0xcf22('0x36')]));if(_0x36bd3b[_0xcf22('0x2b')][_0xcf22('0x38')]){_0x530e75[_0xcf22('0x35')]=_['merge'](_0x530e75['where'],{'$or':_[_0xcf22('0x27')](_0x530e75[_0xcf22('0x2e')],function(_0x1883d1){var _0x35b4b4={};_0x35b4b4[_0x1883d1]={'$like':'%'+_0x36bd3b[_0xcf22('0x2b')][_0xcf22('0x38')]+'%'};return _0x35b4b4;})});}_0x530e75=_[_0xcf22('0x3a')]({},_0x530e75,_0x36bd3b[_0xcf22('0x42')]);return _0x11f862[_0xcf22('0x46')](_0x530e75);}})[_0xcf22('0x20')](function(_0x3160bd){if(_0x3160bd){_0x5e8c62=_0x3160bd[_0xcf22('0x30')];if(!_0x36bd3b['query'][_0xcf22('0x31')](_0xcf22('0x32'))){_0x530e75[_0xcf22('0x19')]=qs['limit'](_0x36bd3b[_0xcf22('0x2b')][_0xcf22('0x19')]);_0x530e75[_0xcf22('0x17')]=qs[_0xcf22('0x17')](_0x36bd3b[_0xcf22('0x2b')][_0xcf22('0x17')]);}return _0x11f862[_0xcf22('0x46')](_0x530e75);}})[_0xcf22('0x20')](function(_0x2ed82b){if(_0x2ed82b){return _0x2ed82b?{'count':_0x5e8c62,'rows':_0x2ed82b}:null;}})[_0xcf22('0x20')](respondWithResult(_0x203896,null))[_0xcf22('0x3f')](handleError(_0x203896,null));};exports[_0xcf22('0x48')]=function(_0x4c3514,_0x3de826,_0x48436d){var _0x50f33b={};var _0x259b88={};var _0x2a19f3;var _0x114df0;return db[_0xcf22('0x3b')][_0xcf22('0x49')]({'where':{'id':_0x4c3514[_0xcf22('0x41')]['id']}})[_0xcf22('0x20')](handleEntityNotFound(_0x3de826,null))[_0xcf22('0x20')](function(_0x275714){if(_0x275714){_0x2a19f3=_0x275714;_0x259b88['model']=_[_0xcf22('0x2a')](db[_0xcf22('0x47')]['rawAttributes']);_0x259b88[_0xcf22('0x2b')]=_[_0xcf22('0x2a')](_0x4c3514['query']);_0x259b88['filters']=_[_0xcf22('0x2c')](_0x259b88[_0xcf22('0x2d')],_0x259b88[_0xcf22('0x2b')]);_0x50f33b[_0xcf22('0x2e')]=_[_0xcf22('0x2c')](_0x259b88['model'],qs['fields'](_0x4c3514[_0xcf22('0x2b')][_0xcf22('0x2f')]));_0x50f33b[_0xcf22('0x2e')]=_0x50f33b[_0xcf22('0x2e')]['length']?_0x50f33b[_0xcf22('0x2e')]:_0x259b88[_0xcf22('0x2d')];_0x50f33b['order']=qs[_0xcf22('0x34')](_0x4c3514[_0xcf22('0x2b')][_0xcf22('0x34')]);_0x50f33b['where']=qs[_0xcf22('0x36')](_[_0xcf22('0x37')](_0x4c3514[_0xcf22('0x2b')],_0x259b88[_0xcf22('0x36')]));if(_0x4c3514[_0xcf22('0x2b')]['filter']){_0x50f33b[_0xcf22('0x35')]=_['merge'](_0x50f33b['where'],{'$or':_[_0xcf22('0x27')](_0x50f33b[_0xcf22('0x2e')],function(_0x1fa30a){var _0x512e3e={};_0x512e3e[_0x1fa30a]={'$like':'%'+_0x4c3514[_0xcf22('0x2b')][_0xcf22('0x38')]+'%'};return _0x512e3e;})});}_0x50f33b=_[_0xcf22('0x3a')]({},_0x50f33b,_0x4c3514[_0xcf22('0x42')]);return _0x2a19f3[_0xcf22('0x48')](_0x50f33b);}})[_0xcf22('0x20')](function(_0x152818){if(_0x152818){_0x114df0=_0x152818[_0xcf22('0x30')];if(!_0x4c3514['query'][_0xcf22('0x31')](_0xcf22('0x32'))){_0x50f33b[_0xcf22('0x19')]=qs[_0xcf22('0x19')](_0x4c3514[_0xcf22('0x2b')]['limit']);_0x50f33b['offset']=qs[_0xcf22('0x17')](_0x4c3514['query'][_0xcf22('0x17')]);}return _0x2a19f3['getSubjects'](_0x50f33b);}})[_0xcf22('0x20')](function(_0x12ca2d){if(_0x12ca2d){return _0x12ca2d?{'count':_0x114df0,'rows':_0x12ca2d}:null;}})[_0xcf22('0x20')](respondWithResult(_0x3de826,null))[_0xcf22('0x3f')](handleError(_0x3de826,null));};exports['getDescriptions']=function(_0x55091e,_0x196b9c,_0x23ab18){var _0x3a3014={};var _0x140fe3={};var _0x274d71;var _0x13384;return db[_0xcf22('0x3b')][_0xcf22('0x49')]({'where':{'id':_0x55091e['params']['id']}})[_0xcf22('0x20')](handleEntityNotFound(_0x196b9c,null))['then'](function(_0x57f75b){if(_0x57f75b){_0x274d71=_0x57f75b;_0x140fe3['model']=_[_0xcf22('0x2a')](db[_0xcf22('0x47')][_0xcf22('0x28')]);_0x140fe3['query']=_['keys'](_0x55091e[_0xcf22('0x2b')]);_0x140fe3[_0xcf22('0x36')]=_[_0xcf22('0x2c')](_0x140fe3[_0xcf22('0x2d')],_0x140fe3[_0xcf22('0x2b')]);_0x3a3014[_0xcf22('0x2e')]=_[_0xcf22('0x2c')](_0x140fe3['model'],qs[_0xcf22('0x2f')](_0x55091e['query'][_0xcf22('0x2f')]));_0x3a3014['attributes']=_0x3a3014[_0xcf22('0x2e')][_0xcf22('0x30')]?_0x3a3014[_0xcf22('0x2e')]:_0x140fe3['model'];_0x3a3014[_0xcf22('0x33')]=qs[_0xcf22('0x34')](_0x55091e[_0xcf22('0x2b')]['sort']);_0x3a3014[_0xcf22('0x35')]=qs[_0xcf22('0x36')](_[_0xcf22('0x37')](_0x55091e[_0xcf22('0x2b')],_0x140fe3[_0xcf22('0x36')]));if(_0x55091e[_0xcf22('0x2b')][_0xcf22('0x38')]){_0x3a3014[_0xcf22('0x35')]=_[_0xcf22('0x3a')](_0x3a3014[_0xcf22('0x35')],{'$or':_[_0xcf22('0x27')](_0x3a3014[_0xcf22('0x2e')],function(_0x3f001d){var _0xa309c8={};_0xa309c8[_0x3f001d]={'$like':'%'+_0x55091e['query'][_0xcf22('0x38')]+'%'};return _0xa309c8;})});}_0x3a3014=_['merge']({},_0x3a3014,_0x55091e['options']);return _0x274d71[_0xcf22('0x4a')](_0x3a3014);}})[_0xcf22('0x20')](function(_0x5c8c5c){if(_0x5c8c5c){_0x13384=_0x5c8c5c['length'];if(!_0x55091e[_0xcf22('0x2b')][_0xcf22('0x31')](_0xcf22('0x32'))){_0x3a3014[_0xcf22('0x19')]=qs[_0xcf22('0x19')](_0x55091e['query']['limit']);_0x3a3014[_0xcf22('0x17')]=qs['offset'](_0x55091e[_0xcf22('0x2b')][_0xcf22('0x17')]);}return _0x274d71[_0xcf22('0x4a')](_0x3a3014);}})[_0xcf22('0x20')](function(_0x4fd9d7){if(_0x4fd9d7){return _0x4fd9d7?{'count':_0x13384,'rows':_0x4fd9d7}:null;}})['then'](respondWithResult(_0x196b9c,null))[_0xcf22('0x3f')](handleError(_0x196b9c,null));};