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 _0xa000=['crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/environment','../../config/license/util','sendStatus','status','end','json','offset','limit','count','set','Content-Range','apply','save','then','destroy','error','stack','name','index','map','VtigerConfiguration','rawAttributes','type','key','model','query','keys','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','VIRTUAL','filter','merge','options','findAll','rows','catch','show','params','includeAll','find','create','body','update','findOne','VtigerField','getFields','getSubjects','getDescriptions','eml-format','rimraf','fast-json-patch','moment','mustache','util','sox','to-csv','fs-extra','squel'];(function(_0x1e8aab,_0x27d782){var _0x528966=function(_0x1d47dd){while(--_0x1d47dd){_0x1e8aab['push'](_0x1e8aab['shift']());}};_0x528966(++_0x27d782);}(_0xa000,0x177));var _0x0a00=function(_0x25f2da,_0x2bc56f){_0x25f2da=_0x25f2da-0x0;var _0x1ef2e1=_0xa000[_0x25f2da];return _0x1ef2e1;};'use strict';var emlformat=require(_0x0a00('0x0'));var rimraf=require(_0x0a00('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x0a00('0x2'));var rp=require('request-promise');var moment=require(_0x0a00('0x3'));var BPromise=require('bluebird');var Mustache=require(_0x0a00('0x4'));var util=require(_0x0a00('0x5'));var path=require('path');var sox=require(_0x0a00('0x6'));var csv=require(_0x0a00('0x7'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x0a00('0x8'));var _=require('lodash');var squel=require(_0x0a00('0x9'));var crypto=require(_0x0a00('0xa'));var jsforce=require(_0x0a00('0xb'));var deskjs=require(_0x0a00('0xc'));var toCsv=require('to-csv');var querystring=require(_0x0a00('0xd'));var Papa=require(_0x0a00('0xe'));var Redis=require(_0x0a00('0xf'));var authService=require('../../components/auth/service');var qs=require(_0x0a00('0x10'));var as=require(_0x0a00('0x11'));var hardwareService=require(_0x0a00('0x12'));var logger=require('../../config/logger')(_0x0a00('0x13'));var utils=require('../../config/utils');var config=require(_0x0a00('0x14'));var licenseUtil=require(_0x0a00('0x15'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x30247,_0x37faaa){_0x37faaa=_0x37faaa||0xcc;return function(_0x1e2cb2){if(_0x1e2cb2){return _0x30247[_0x0a00('0x16')](_0x37faaa);}return _0x30247[_0x0a00('0x17')](_0x37faaa)[_0x0a00('0x18')]();};}function respondWithResult(_0x26f286,_0x2e9fc0){_0x2e9fc0=_0x2e9fc0||0xc8;return function(_0x38fcae){if(_0x38fcae){return _0x26f286['status'](_0x2e9fc0)[_0x0a00('0x19')](_0x38fcae);}};}function respondWithFilteredResult(_0x282194,_0x3bb494){return function(_0x4dad6d){if(_0x4dad6d){var _0x4033e7=typeof _0x3bb494[_0x0a00('0x1a')]==='undefined'&&typeof _0x3bb494[_0x0a00('0x1b')]==='undefined';var _0x5444bd=_0x4dad6d[_0x0a00('0x1c')];var _0x2bfb4a=_0x4033e7?0x0:_0x3bb494['offset'];var _0x14f674=_0x4033e7?_0x4dad6d['count']:_0x3bb494[_0x0a00('0x1a')]+_0x3bb494[_0x0a00('0x1b')];var _0x21fe0c;if(_0x14f674>=_0x5444bd){_0x14f674=_0x5444bd;_0x21fe0c=0xc8;}else{_0x21fe0c=0xce;}_0x282194[_0x0a00('0x17')](_0x21fe0c);return _0x282194[_0x0a00('0x1d')](_0x0a00('0x1e'),_0x2bfb4a+'-'+_0x14f674+'/'+_0x5444bd)['json'](_0x4dad6d);}return null;};}function patchUpdates(_0x37ff9f){return function(_0xfb3245){try{jsonpatch[_0x0a00('0x1f')](_0xfb3245,_0x37ff9f,!![]);}catch(_0x57fdaa){return BPromise['reject'](_0x57fdaa);}return _0xfb3245[_0x0a00('0x20')]();};}function saveUpdates(_0x424af6,_0x35253b){return function(_0x160098){if(_0x160098){return _0x160098['update'](_0x424af6)[_0x0a00('0x21')](function(_0x1a61f9){return _0x1a61f9;});}return null;};}function removeEntity(_0x4ea2e1,_0x3a7ceb){return function(_0x4b8c06){if(_0x4b8c06){return _0x4b8c06[_0x0a00('0x22')]()[_0x0a00('0x21')](function(){_0x4ea2e1['status'](0xcc)[_0x0a00('0x18')]();});}};}function handleEntityNotFound(_0x47ce7e,_0x744ccc){return function(_0x84b43b){if(!_0x84b43b){_0x47ce7e[_0x0a00('0x16')](0x194);}return _0x84b43b;};}function handleError(_0x1f9414,_0x3d37b4){_0x3d37b4=_0x3d37b4||0x1f4;return function(_0x32afe2){logger[_0x0a00('0x23')](_0x32afe2[_0x0a00('0x24')]);if(_0x32afe2['name']){delete _0x32afe2[_0x0a00('0x25')];}_0x1f9414['status'](_0x3d37b4)['send'](_0x32afe2);};}exports[_0x0a00('0x26')]=function(_0x2e9f78,_0x141f06){var _0x42ebbb={},_0x186a71={},_0x30c952={'count':0x0,'rows':[]};var _0x3accba=_[_0x0a00('0x27')](db[_0x0a00('0x28')][_0x0a00('0x29')],function(_0x153e06){return{'name':_0x153e06['fieldName'],'type':_0x153e06[_0x0a00('0x2a')][_0x0a00('0x2b')]};});_0x186a71[_0x0a00('0x2c')]=_[_0x0a00('0x27')](_0x3accba,_0x0a00('0x25'));_0x186a71[_0x0a00('0x2d')]=_[_0x0a00('0x2e')](_0x2e9f78[_0x0a00('0x2d')]);_0x186a71['filters']=_[_0x0a00('0x2f')](_0x186a71[_0x0a00('0x2c')],_0x186a71[_0x0a00('0x2d')]);_0x42ebbb[_0x0a00('0x30')]=_['intersection'](_0x186a71['model'],qs[_0x0a00('0x31')](_0x2e9f78['query'][_0x0a00('0x31')]));_0x42ebbb[_0x0a00('0x30')]=_0x42ebbb[_0x0a00('0x30')][_0x0a00('0x32')]?_0x42ebbb[_0x0a00('0x30')]:_0x186a71[_0x0a00('0x2c')];if(!_0x2e9f78[_0x0a00('0x2d')][_0x0a00('0x33')](_0x0a00('0x34'))){_0x42ebbb[_0x0a00('0x1b')]=qs[_0x0a00('0x1b')](_0x2e9f78[_0x0a00('0x2d')][_0x0a00('0x1b')]);_0x42ebbb[_0x0a00('0x1a')]=qs['offset'](_0x2e9f78[_0x0a00('0x2d')][_0x0a00('0x1a')]);}_0x42ebbb[_0x0a00('0x35')]=qs[_0x0a00('0x36')](_0x2e9f78['query'][_0x0a00('0x36')]);_0x42ebbb[_0x0a00('0x37')]=qs[_0x0a00('0x38')](_[_0x0a00('0x39')](_0x2e9f78[_0x0a00('0x2d')],_0x186a71['filters']),_0x3accba);if(_0x2e9f78[_0x0a00('0x2d')]['filter']){_0x42ebbb['where']=_['merge'](_0x42ebbb[_0x0a00('0x37')],{'$or':_[_0x0a00('0x27')](_0x3accba,function(_0x357aa7){if(_0x357aa7[_0x0a00('0x2a')]!==_0x0a00('0x3a')){var _0x3e8d7c={};_0x3e8d7c[_0x357aa7[_0x0a00('0x25')]]={'$like':'%'+_0x2e9f78[_0x0a00('0x2d')][_0x0a00('0x3b')]+'%'};return _0x3e8d7c;}})});}_0x42ebbb=_[_0x0a00('0x3c')]({},_0x42ebbb,_0x2e9f78[_0x0a00('0x3d')]);var _0x499619={'where':_0x42ebbb['where']};return db[_0x0a00('0x28')][_0x0a00('0x1c')](_0x499619)['then'](function(_0x12bf4e){_0x30c952[_0x0a00('0x1c')]=_0x12bf4e;if(_0x2e9f78['query']['includeAll']){_0x42ebbb['include']=[{'all':!![]}];}return db[_0x0a00('0x28')][_0x0a00('0x3e')](_0x42ebbb);})[_0x0a00('0x21')](function(_0xdd205a){_0x30c952[_0x0a00('0x3f')]=_0xdd205a;return _0x30c952;})[_0x0a00('0x21')](respondWithFilteredResult(_0x141f06,_0x42ebbb))[_0x0a00('0x40')](handleError(_0x141f06,null));};exports[_0x0a00('0x41')]=function(_0x1a6daf,_0xfe3503){var _0x188eb2={'raw':![],'where':{'id':_0x1a6daf[_0x0a00('0x42')]['id']}},_0x15112f={};_0x15112f[_0x0a00('0x2c')]=_[_0x0a00('0x2e')](db['VtigerConfiguration'][_0x0a00('0x29')]);_0x15112f[_0x0a00('0x2d')]=_[_0x0a00('0x2e')](_0x1a6daf[_0x0a00('0x2d')]);_0x15112f[_0x0a00('0x38')]=_['intersection'](_0x15112f[_0x0a00('0x2c')],_0x15112f[_0x0a00('0x2d')]);_0x188eb2[_0x0a00('0x30')]=_['intersection'](_0x15112f[_0x0a00('0x2c')],qs[_0x0a00('0x31')](_0x1a6daf[_0x0a00('0x2d')][_0x0a00('0x31')]));_0x188eb2['attributes']=_0x188eb2['attributes'][_0x0a00('0x32')]?_0x188eb2['attributes']:_0x15112f[_0x0a00('0x2c')];if(_0x1a6daf[_0x0a00('0x2d')][_0x0a00('0x43')]){_0x188eb2['include']=[{'all':!![]}];}_0x188eb2=_[_0x0a00('0x3c')]({},_0x188eb2,_0x1a6daf[_0x0a00('0x3d')]);return db[_0x0a00('0x28')][_0x0a00('0x44')](_0x188eb2)[_0x0a00('0x21')](handleEntityNotFound(_0xfe3503,null))[_0x0a00('0x21')](respondWithResult(_0xfe3503,null))[_0x0a00('0x40')](handleError(_0xfe3503,null));};exports[_0x0a00('0x45')]=function(_0x23cc8d,_0x5316b8){return db[_0x0a00('0x28')][_0x0a00('0x45')](_0x23cc8d[_0x0a00('0x46')],{})[_0x0a00('0x21')](respondWithResult(_0x5316b8,0xc9))[_0x0a00('0x40')](handleError(_0x5316b8,null));};exports[_0x0a00('0x47')]=function(_0x5c1552,_0x351eee){if(_0x5c1552[_0x0a00('0x46')]['id']){delete _0x5c1552[_0x0a00('0x46')]['id'];}return db[_0x0a00('0x28')]['find']({'where':{'id':_0x5c1552[_0x0a00('0x42')]['id']}})[_0x0a00('0x21')](handleEntityNotFound(_0x351eee,null))[_0x0a00('0x21')](saveUpdates(_0x5c1552[_0x0a00('0x46')],null))[_0x0a00('0x21')](respondWithResult(_0x351eee,null))['catch'](handleError(_0x351eee,null));};exports['destroy']=function(_0x3ce2db,_0x4f178b){return db[_0x0a00('0x28')][_0x0a00('0x44')]({'where':{'id':_0x3ce2db['params']['id']}})[_0x0a00('0x21')](handleEntityNotFound(_0x4f178b,null))[_0x0a00('0x21')](removeEntity(_0x4f178b,null))[_0x0a00('0x40')](handleError(_0x4f178b,null));};exports['getFields']=function(_0x355559,_0x11a2e9,_0x429e9b){var _0x1b72b8={};var _0xacc791={};var _0x5b4717;var _0x4c727f;return db['VtigerConfiguration'][_0x0a00('0x48')]({'where':{'id':_0x355559[_0x0a00('0x42')]['id']}})[_0x0a00('0x21')](handleEntityNotFound(_0x11a2e9,null))[_0x0a00('0x21')](function(_0x4aefdf){if(_0x4aefdf){_0x5b4717=_0x4aefdf;_0xacc791[_0x0a00('0x2c')]=_[_0x0a00('0x2e')](db[_0x0a00('0x49')]['rawAttributes']);_0xacc791[_0x0a00('0x2d')]=_[_0x0a00('0x2e')](_0x355559[_0x0a00('0x2d')]);_0xacc791['filters']=_[_0x0a00('0x2f')](_0xacc791[_0x0a00('0x2c')],_0xacc791[_0x0a00('0x2d')]);_0x1b72b8['attributes']=_[_0x0a00('0x2f')](_0xacc791['model'],qs[_0x0a00('0x31')](_0x355559[_0x0a00('0x2d')][_0x0a00('0x31')]));_0x1b72b8[_0x0a00('0x30')]=_0x1b72b8[_0x0a00('0x30')][_0x0a00('0x32')]?_0x1b72b8[_0x0a00('0x30')]:_0xacc791[_0x0a00('0x2c')];_0x1b72b8[_0x0a00('0x35')]=qs[_0x0a00('0x36')](_0x355559['query']['sort']);_0x1b72b8['where']=qs[_0x0a00('0x38')](_['pick'](_0x355559[_0x0a00('0x2d')],_0xacc791[_0x0a00('0x38')]));if(_0x355559[_0x0a00('0x2d')][_0x0a00('0x3b')]){_0x1b72b8[_0x0a00('0x37')]=_['merge'](_0x1b72b8[_0x0a00('0x37')],{'$or':_['map'](_0x1b72b8[_0x0a00('0x30')],function(_0x490199){var _0x3490fe={};_0x3490fe[_0x490199]={'$like':'%'+_0x355559[_0x0a00('0x2d')]['filter']+'%'};return _0x3490fe;})});}_0x1b72b8=_['merge']({},_0x1b72b8,_0x355559[_0x0a00('0x3d')]);return _0x5b4717[_0x0a00('0x4a')](_0x1b72b8);}})[_0x0a00('0x21')](function(_0xb86241){if(_0xb86241){_0x4c727f=_0xb86241[_0x0a00('0x32')];if(!_0x355559[_0x0a00('0x2d')][_0x0a00('0x33')]('nolimit')){_0x1b72b8[_0x0a00('0x1b')]=qs[_0x0a00('0x1b')](_0x355559['query']['limit']);_0x1b72b8[_0x0a00('0x1a')]=qs['offset'](_0x355559[_0x0a00('0x2d')][_0x0a00('0x1a')]);}return _0x5b4717['getFields'](_0x1b72b8);}})[_0x0a00('0x21')](function(_0x47d273){if(_0x47d273){return _0x47d273?{'count':_0x4c727f,'rows':_0x47d273}:null;}})[_0x0a00('0x21')](respondWithResult(_0x11a2e9,null))[_0x0a00('0x40')](handleError(_0x11a2e9,null));};exports[_0x0a00('0x4b')]=function(_0xcbc971,_0x524d36,_0x5627c8){var _0x49dc0c={};var _0x18dcb3={};var _0x5c3cc6;var _0x3cd59b;return db[_0x0a00('0x28')][_0x0a00('0x48')]({'where':{'id':_0xcbc971[_0x0a00('0x42')]['id']}})[_0x0a00('0x21')](handleEntityNotFound(_0x524d36,null))[_0x0a00('0x21')](function(_0x1f1c94){if(_0x1f1c94){_0x5c3cc6=_0x1f1c94;_0x18dcb3[_0x0a00('0x2c')]=_[_0x0a00('0x2e')](db['VtigerField'][_0x0a00('0x29')]);_0x18dcb3['query']=_[_0x0a00('0x2e')](_0xcbc971[_0x0a00('0x2d')]);_0x18dcb3[_0x0a00('0x38')]=_['intersection'](_0x18dcb3['model'],_0x18dcb3['query']);_0x49dc0c[_0x0a00('0x30')]=_[_0x0a00('0x2f')](_0x18dcb3['model'],qs[_0x0a00('0x31')](_0xcbc971['query'][_0x0a00('0x31')]));_0x49dc0c[_0x0a00('0x30')]=_0x49dc0c[_0x0a00('0x30')]['length']?_0x49dc0c[_0x0a00('0x30')]:_0x18dcb3[_0x0a00('0x2c')];_0x49dc0c[_0x0a00('0x35')]=qs[_0x0a00('0x36')](_0xcbc971[_0x0a00('0x2d')]['sort']);_0x49dc0c[_0x0a00('0x37')]=qs['filters'](_[_0x0a00('0x39')](_0xcbc971['query'],_0x18dcb3[_0x0a00('0x38')]));if(_0xcbc971[_0x0a00('0x2d')][_0x0a00('0x3b')]){_0x49dc0c['where']=_[_0x0a00('0x3c')](_0x49dc0c[_0x0a00('0x37')],{'$or':_[_0x0a00('0x27')](_0x49dc0c[_0x0a00('0x30')],function(_0x365c05){var _0x5350d7={};_0x5350d7[_0x365c05]={'$like':'%'+_0xcbc971[_0x0a00('0x2d')][_0x0a00('0x3b')]+'%'};return _0x5350d7;})});}_0x49dc0c=_['merge']({},_0x49dc0c,_0xcbc971['options']);return _0x5c3cc6['getSubjects'](_0x49dc0c);}})[_0x0a00('0x21')](function(_0x41e4ab){if(_0x41e4ab){_0x3cd59b=_0x41e4ab['length'];if(!_0xcbc971[_0x0a00('0x2d')][_0x0a00('0x33')]('nolimit')){_0x49dc0c['limit']=qs[_0x0a00('0x1b')](_0xcbc971[_0x0a00('0x2d')][_0x0a00('0x1b')]);_0x49dc0c['offset']=qs[_0x0a00('0x1a')](_0xcbc971[_0x0a00('0x2d')]['offset']);}return _0x5c3cc6[_0x0a00('0x4b')](_0x49dc0c);}})['then'](function(_0x19fc9a){if(_0x19fc9a){return _0x19fc9a?{'count':_0x3cd59b,'rows':_0x19fc9a}:null;}})['then'](respondWithResult(_0x524d36,null))[_0x0a00('0x40')](handleError(_0x524d36,null));};exports['getDescriptions']=function(_0x3d48b6,_0x128c9b,_0x12d2e9){var _0x260dba={};var _0x4773c5={};var _0x4fec54;var _0x5d456c;return db['VtigerConfiguration'][_0x0a00('0x48')]({'where':{'id':_0x3d48b6['params']['id']}})['then'](handleEntityNotFound(_0x128c9b,null))['then'](function(_0xd6f9fd){if(_0xd6f9fd){_0x4fec54=_0xd6f9fd;_0x4773c5[_0x0a00('0x2c')]=_[_0x0a00('0x2e')](db[_0x0a00('0x49')][_0x0a00('0x29')]);_0x4773c5[_0x0a00('0x2d')]=_[_0x0a00('0x2e')](_0x3d48b6['query']);_0x4773c5[_0x0a00('0x38')]=_[_0x0a00('0x2f')](_0x4773c5[_0x0a00('0x2c')],_0x4773c5[_0x0a00('0x2d')]);_0x260dba[_0x0a00('0x30')]=_['intersection'](_0x4773c5[_0x0a00('0x2c')],qs[_0x0a00('0x31')](_0x3d48b6[_0x0a00('0x2d')][_0x0a00('0x31')]));_0x260dba[_0x0a00('0x30')]=_0x260dba[_0x0a00('0x30')][_0x0a00('0x32')]?_0x260dba[_0x0a00('0x30')]:_0x4773c5[_0x0a00('0x2c')];_0x260dba[_0x0a00('0x35')]=qs[_0x0a00('0x36')](_0x3d48b6[_0x0a00('0x2d')][_0x0a00('0x36')]);_0x260dba[_0x0a00('0x37')]=qs['filters'](_['pick'](_0x3d48b6[_0x0a00('0x2d')],_0x4773c5[_0x0a00('0x38')]));if(_0x3d48b6[_0x0a00('0x2d')]['filter']){_0x260dba['where']=_[_0x0a00('0x3c')](_0x260dba['where'],{'$or':_['map'](_0x260dba[_0x0a00('0x30')],function(_0x17a604){var _0x49e84a={};_0x49e84a[_0x17a604]={'$like':'%'+_0x3d48b6['query'][_0x0a00('0x3b')]+'%'};return _0x49e84a;})});}_0x260dba=_[_0x0a00('0x3c')]({},_0x260dba,_0x3d48b6[_0x0a00('0x3d')]);return _0x4fec54[_0x0a00('0x4c')](_0x260dba);}})[_0x0a00('0x21')](function(_0x3d741d){if(_0x3d741d){_0x5d456c=_0x3d741d[_0x0a00('0x32')];if(!_0x3d48b6['query'][_0x0a00('0x33')](_0x0a00('0x34'))){_0x260dba[_0x0a00('0x1b')]=qs[_0x0a00('0x1b')](_0x3d48b6['query'][_0x0a00('0x1b')]);_0x260dba[_0x0a00('0x1a')]=qs[_0x0a00('0x1a')](_0x3d48b6['query']['offset']);}return _0x4fec54[_0x0a00('0x4c')](_0x260dba);}})[_0x0a00('0x21')](function(_0x26fe46){if(_0x26fe46){return _0x26fe46?{'count':_0x5d456c,'rows':_0x26fe46}:null;}})[_0x0a00('0x21')](respondWithResult(_0x128c9b,null))[_0x0a00('0x40')](handleError(_0x128c9b,null));};