[motion2.git] / server / api / intVtigerConfiguration / intVtigerConfiguration.controller.js

// *************************************************************************
// *                                                                       *
// * xCALLY Motion -  The Omnichannel Contact Center                       *
// * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * Email: info@xcally.com                                                *
// * Website: https://www.xcally.com                                       *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * The SOFTWARE PRODUCT is protected by copyright laws and international *
// * copyright treaties, as well as other intellectual property laws and   *
// * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
// *                                                                       *
// *************************************************************************
var _0xc9d9=['path','sox','fs-extra','lodash','squel','crypto','jsforce','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','status','end','json','offset','count','limit','set','apply','reject','save','update','then','destroy','sendStatus','error','stack','name','send','index','map','rawAttributes','type','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','sort','pick','filter','where','merge','options','VtigerConfiguration','includeAll','include','findAll','rows','show','find','catch','create','body','params','getFields','VtigerField','order','nolimit','getSubjects','findOne','getDescriptions','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','util'];(function(_0x43572e,_0x8c3562){var _0x1eb4d1=function(_0x44953e){while(--_0x44953e){_0x43572e['push'](_0x43572e['shift']());}};_0x1eb4d1(++_0x8c3562);}(_0xc9d9,0x141));var _0x9c9d=function(_0x474dda,_0xdc7592){_0x474dda=_0x474dda-0x0;var _0x2c2da6=_0xc9d9[_0x474dda];return _0x2c2da6;};'use strict';var emlformat=require(_0x9c9d('0x0'));var rimraf=require(_0x9c9d('0x1'));var zipdir=require(_0x9c9d('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x9c9d('0x3'));var moment=require(_0x9c9d('0x4'));var BPromise=require(_0x9c9d('0x5'));var Mustache=require('mustache');var util=require(_0x9c9d('0x6'));var path=require(_0x9c9d('0x7'));var sox=require(_0x9c9d('0x8'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x9c9d('0x9'));var _=require(_0x9c9d('0xa'));var squel=require(_0x9c9d('0xb'));var crypto=require(_0x9c9d('0xc'));var jsforce=require(_0x9c9d('0xd'));var deskjs=require('desk.js');var toCsv=require(_0x9c9d('0xe'));var querystring=require(_0x9c9d('0xf'));var Papa=require(_0x9c9d('0x10'));var Redis=require(_0x9c9d('0x11'));var authService=require(_0x9c9d('0x12'));var qs=require(_0x9c9d('0x13'));var as=require(_0x9c9d('0x14'));var hardwareService=require(_0x9c9d('0x15'));var logger=require(_0x9c9d('0x16'))(_0x9c9d('0x17'));var utils=require(_0x9c9d('0x18'));var config=require(_0x9c9d('0x19'));var licenseUtil=require('../../config/license/util');var db=require(_0x9c9d('0x1a'))['db'];function respondWithStatusCode(_0x4e497f,_0x59631b){_0x59631b=_0x59631b||0xcc;return function(_0x581ee8){if(_0x581ee8){return _0x4e497f['sendStatus'](_0x59631b);}return _0x4e497f[_0x9c9d('0x1b')](_0x59631b)[_0x9c9d('0x1c')]();};}function respondWithResult(_0x595c87,_0x41b879){_0x41b879=_0x41b879||0xc8;return function(_0x5d9dde){if(_0x5d9dde){return _0x595c87[_0x9c9d('0x1b')](_0x41b879)[_0x9c9d('0x1d')](_0x5d9dde);}};}function respondWithFilteredResult(_0x18b8cf,_0x45581b){return function(_0x7c4364){if(_0x7c4364){var _0x1268f7=typeof _0x45581b[_0x9c9d('0x1e')]==='undefined'&&typeof _0x45581b['limit']==='undefined';var _0x214c2f=_0x7c4364['count'];var _0x38654e=_0x1268f7?0x0:_0x45581b[_0x9c9d('0x1e')];var _0x2e0fdd=_0x1268f7?_0x7c4364[_0x9c9d('0x1f')]:_0x45581b[_0x9c9d('0x1e')]+_0x45581b[_0x9c9d('0x20')];var _0x2b4233;if(_0x2e0fdd>=_0x214c2f){_0x2e0fdd=_0x214c2f;_0x2b4233=0xc8;}else{_0x2b4233=0xce;}_0x18b8cf['status'](_0x2b4233);return _0x18b8cf[_0x9c9d('0x21')]('Content-Range',_0x38654e+'-'+_0x2e0fdd+'/'+_0x214c2f)[_0x9c9d('0x1d')](_0x7c4364);}return null;};}function patchUpdates(_0x32ca16){return function(_0x44580d){try{jsonpatch[_0x9c9d('0x22')](_0x44580d,_0x32ca16,!![]);}catch(_0x4d0f4f){return BPromise[_0x9c9d('0x23')](_0x4d0f4f);}return _0x44580d[_0x9c9d('0x24')]();};}function saveUpdates(_0x42e6e3,_0x2a7cf0){return function(_0x379da4){if(_0x379da4){return _0x379da4[_0x9c9d('0x25')](_0x42e6e3)[_0x9c9d('0x26')](function(_0x3aa9b0){return _0x3aa9b0;});}return null;};}function removeEntity(_0x333938,_0x41845f){return function(_0x2a8e7f){if(_0x2a8e7f){return _0x2a8e7f[_0x9c9d('0x27')]()[_0x9c9d('0x26')](function(){_0x333938[_0x9c9d('0x1b')](0xcc)[_0x9c9d('0x1c')]();});}};}function handleEntityNotFound(_0x34e2e4,_0x4b20cf){return function(_0xf0a9c8){if(!_0xf0a9c8){_0x34e2e4[_0x9c9d('0x28')](0x194);}return _0xf0a9c8;};}function handleError(_0x347767,_0x1ffb4d){_0x1ffb4d=_0x1ffb4d||0x1f4;return function(_0x263616){logger[_0x9c9d('0x29')](_0x263616[_0x9c9d('0x2a')]);if(_0x263616[_0x9c9d('0x2b')]){delete _0x263616[_0x9c9d('0x2b')];}_0x347767[_0x9c9d('0x1b')](_0x1ffb4d)[_0x9c9d('0x2c')](_0x263616);};}exports[_0x9c9d('0x2d')]=function(_0x3648b3,_0x9f4d53){var _0x54d927={},_0x56b236={},_0x4e5724={'count':0x0,'rows':[]};var _0x1ce904=_[_0x9c9d('0x2e')](db['VtigerConfiguration'][_0x9c9d('0x2f')],function(_0x5c185e){return{'name':_0x5c185e['fieldName'],'type':_0x5c185e[_0x9c9d('0x30')]['key']};});_0x56b236[_0x9c9d('0x31')]=_[_0x9c9d('0x2e')](_0x1ce904,_0x9c9d('0x2b'));_0x56b236[_0x9c9d('0x32')]=_[_0x9c9d('0x33')](_0x3648b3[_0x9c9d('0x32')]);_0x56b236[_0x9c9d('0x34')]=_[_0x9c9d('0x35')](_0x56b236[_0x9c9d('0x31')],_0x56b236[_0x9c9d('0x32')]);_0x54d927[_0x9c9d('0x36')]=_[_0x9c9d('0x35')](_0x56b236['model'],qs[_0x9c9d('0x37')](_0x3648b3[_0x9c9d('0x32')][_0x9c9d('0x37')]));_0x54d927[_0x9c9d('0x36')]=_0x54d927[_0x9c9d('0x36')][_0x9c9d('0x38')]?_0x54d927[_0x9c9d('0x36')]:_0x56b236[_0x9c9d('0x31')];if(!_0x3648b3['query'][_0x9c9d('0x39')]('nolimit')){_0x54d927[_0x9c9d('0x20')]=qs['limit'](_0x3648b3[_0x9c9d('0x32')]['limit']);_0x54d927[_0x9c9d('0x1e')]=qs['offset'](_0x3648b3['query'][_0x9c9d('0x1e')]);}_0x54d927['order']=qs[_0x9c9d('0x3a')](_0x3648b3[_0x9c9d('0x32')]['sort']);_0x54d927['where']=qs[_0x9c9d('0x34')](_[_0x9c9d('0x3b')](_0x3648b3[_0x9c9d('0x32')],_0x56b236[_0x9c9d('0x34')]),_0x1ce904);if(_0x3648b3[_0x9c9d('0x32')][_0x9c9d('0x3c')]){_0x54d927[_0x9c9d('0x3d')]=_['merge'](_0x54d927[_0x9c9d('0x3d')],{'$or':_['map'](_0x1ce904,function(_0x3e354a){if(_0x3e354a['type']!=='VIRTUAL'){var _0x1deb36={};_0x1deb36[_0x3e354a[_0x9c9d('0x2b')]]={'$like':'%'+_0x3648b3[_0x9c9d('0x32')][_0x9c9d('0x3c')]+'%'};return _0x1deb36;}})});}_0x54d927=_[_0x9c9d('0x3e')]({},_0x54d927,_0x3648b3[_0x9c9d('0x3f')]);var _0x181bc4={'where':_0x54d927[_0x9c9d('0x3d')]};return db[_0x9c9d('0x40')][_0x9c9d('0x1f')](_0x181bc4)[_0x9c9d('0x26')](function(_0x1d9d87){_0x4e5724['count']=_0x1d9d87;if(_0x3648b3[_0x9c9d('0x32')][_0x9c9d('0x41')]){_0x54d927[_0x9c9d('0x42')]=[{'all':!![]}];}return db[_0x9c9d('0x40')][_0x9c9d('0x43')](_0x54d927);})[_0x9c9d('0x26')](function(_0x1398b3){_0x4e5724[_0x9c9d('0x44')]=_0x1398b3;return _0x4e5724;})[_0x9c9d('0x26')](respondWithFilteredResult(_0x9f4d53,_0x54d927))['catch'](handleError(_0x9f4d53,null));};exports[_0x9c9d('0x45')]=function(_0x25c4a2,_0xe3eb32){var _0x214b5f={'raw':![],'where':{'id':_0x25c4a2['params']['id']}},_0x2b7fdf={};_0x2b7fdf[_0x9c9d('0x31')]=_[_0x9c9d('0x33')](db[_0x9c9d('0x40')]['rawAttributes']);_0x2b7fdf[_0x9c9d('0x32')]=_[_0x9c9d('0x33')](_0x25c4a2[_0x9c9d('0x32')]);_0x2b7fdf[_0x9c9d('0x34')]=_[_0x9c9d('0x35')](_0x2b7fdf['model'],_0x2b7fdf['query']);_0x214b5f[_0x9c9d('0x36')]=_[_0x9c9d('0x35')](_0x2b7fdf[_0x9c9d('0x31')],qs['fields'](_0x25c4a2[_0x9c9d('0x32')][_0x9c9d('0x37')]));_0x214b5f['attributes']=_0x214b5f[_0x9c9d('0x36')][_0x9c9d('0x38')]?_0x214b5f[_0x9c9d('0x36')]:_0x2b7fdf[_0x9c9d('0x31')];if(_0x25c4a2[_0x9c9d('0x32')][_0x9c9d('0x41')]){_0x214b5f[_0x9c9d('0x42')]=[{'all':!![]}];}_0x214b5f=_['merge']({},_0x214b5f,_0x25c4a2[_0x9c9d('0x3f')]);return db[_0x9c9d('0x40')][_0x9c9d('0x46')](_0x214b5f)[_0x9c9d('0x26')](handleEntityNotFound(_0xe3eb32,null))[_0x9c9d('0x26')](respondWithResult(_0xe3eb32,null))[_0x9c9d('0x47')](handleError(_0xe3eb32,null));};exports[_0x9c9d('0x48')]=function(_0xfecb8f,_0x322264){return db[_0x9c9d('0x40')][_0x9c9d('0x48')](_0xfecb8f[_0x9c9d('0x49')],{})[_0x9c9d('0x26')](respondWithResult(_0x322264,0xc9))['catch'](handleError(_0x322264,null));};exports[_0x9c9d('0x25')]=function(_0x853478,_0x56fee7){if(_0x853478[_0x9c9d('0x49')]['id']){delete _0x853478[_0x9c9d('0x49')]['id'];}return db[_0x9c9d('0x40')][_0x9c9d('0x46')]({'where':{'id':_0x853478[_0x9c9d('0x4a')]['id']}})[_0x9c9d('0x26')](handleEntityNotFound(_0x56fee7,null))[_0x9c9d('0x26')](saveUpdates(_0x853478[_0x9c9d('0x49')],null))[_0x9c9d('0x26')](respondWithResult(_0x56fee7,null))[_0x9c9d('0x47')](handleError(_0x56fee7,null));};exports[_0x9c9d('0x27')]=function(_0x270665,_0x582e53){return db[_0x9c9d('0x40')]['find']({'where':{'id':_0x270665[_0x9c9d('0x4a')]['id']}})[_0x9c9d('0x26')](handleEntityNotFound(_0x582e53,null))[_0x9c9d('0x26')](removeEntity(_0x582e53,null))[_0x9c9d('0x47')](handleError(_0x582e53,null));};exports[_0x9c9d('0x4b')]=function(_0x10bd5a,_0x1a8e8e,_0x1c3eb6){var _0x57a5c0={};var _0x38f60b={};var _0x1ade8a;var _0xc3b40b;return db[_0x9c9d('0x40')]['findOne']({'where':{'id':_0x10bd5a[_0x9c9d('0x4a')]['id']}})['then'](handleEntityNotFound(_0x1a8e8e,null))[_0x9c9d('0x26')](function(_0x322d50){if(_0x322d50){_0x1ade8a=_0x322d50;_0x38f60b[_0x9c9d('0x31')]=_['keys'](db[_0x9c9d('0x4c')][_0x9c9d('0x2f')]);_0x38f60b[_0x9c9d('0x32')]=_[_0x9c9d('0x33')](_0x10bd5a[_0x9c9d('0x32')]);_0x38f60b[_0x9c9d('0x34')]=_['intersection'](_0x38f60b[_0x9c9d('0x31')],_0x38f60b[_0x9c9d('0x32')]);_0x57a5c0['attributes']=_[_0x9c9d('0x35')](_0x38f60b[_0x9c9d('0x31')],qs['fields'](_0x10bd5a[_0x9c9d('0x32')]['fields']));_0x57a5c0[_0x9c9d('0x36')]=_0x57a5c0['attributes']['length']?_0x57a5c0[_0x9c9d('0x36')]:_0x38f60b['model'];_0x57a5c0[_0x9c9d('0x4d')]=qs[_0x9c9d('0x3a')](_0x10bd5a[_0x9c9d('0x32')][_0x9c9d('0x3a')]);_0x57a5c0[_0x9c9d('0x3d')]=qs[_0x9c9d('0x34')](_['pick'](_0x10bd5a['query'],_0x38f60b[_0x9c9d('0x34')]));if(_0x10bd5a[_0x9c9d('0x32')][_0x9c9d('0x3c')]){_0x57a5c0[_0x9c9d('0x3d')]=_[_0x9c9d('0x3e')](_0x57a5c0[_0x9c9d('0x3d')],{'$or':_[_0x9c9d('0x2e')](_0x57a5c0[_0x9c9d('0x36')],function(_0x5e4950){var _0x1b1aec={};_0x1b1aec[_0x5e4950]={'$like':'%'+_0x10bd5a[_0x9c9d('0x32')]['filter']+'%'};return _0x1b1aec;})});}_0x57a5c0=_[_0x9c9d('0x3e')]({},_0x57a5c0,_0x10bd5a['options']);return _0x1ade8a[_0x9c9d('0x4b')](_0x57a5c0);}})['then'](function(_0x3c744f){if(_0x3c744f){_0xc3b40b=_0x3c744f[_0x9c9d('0x38')];if(!_0x10bd5a['query'][_0x9c9d('0x39')](_0x9c9d('0x4e'))){_0x57a5c0[_0x9c9d('0x20')]=qs[_0x9c9d('0x20')](_0x10bd5a['query']['limit']);_0x57a5c0[_0x9c9d('0x1e')]=qs[_0x9c9d('0x1e')](_0x10bd5a[_0x9c9d('0x32')][_0x9c9d('0x1e')]);}return _0x1ade8a[_0x9c9d('0x4b')](_0x57a5c0);}})[_0x9c9d('0x26')](function(_0x1d7ba9){if(_0x1d7ba9){return _0x1d7ba9?{'count':_0xc3b40b,'rows':_0x1d7ba9}:null;}})[_0x9c9d('0x26')](respondWithResult(_0x1a8e8e,null))[_0x9c9d('0x47')](handleError(_0x1a8e8e,null));};exports[_0x9c9d('0x4f')]=function(_0x504d3c,_0x30cb1c,_0x5a37d9){var _0x4ee271={};var _0xa8bebe={};var _0x5af519;var _0x1d29e0;return db['VtigerConfiguration'][_0x9c9d('0x50')]({'where':{'id':_0x504d3c[_0x9c9d('0x4a')]['id']}})[_0x9c9d('0x26')](handleEntityNotFound(_0x30cb1c,null))[_0x9c9d('0x26')](function(_0x33a646){if(_0x33a646){_0x5af519=_0x33a646;_0xa8bebe['model']=_[_0x9c9d('0x33')](db[_0x9c9d('0x4c')][_0x9c9d('0x2f')]);_0xa8bebe[_0x9c9d('0x32')]=_[_0x9c9d('0x33')](_0x504d3c[_0x9c9d('0x32')]);_0xa8bebe[_0x9c9d('0x34')]=_[_0x9c9d('0x35')](_0xa8bebe[_0x9c9d('0x31')],_0xa8bebe[_0x9c9d('0x32')]);_0x4ee271[_0x9c9d('0x36')]=_[_0x9c9d('0x35')](_0xa8bebe[_0x9c9d('0x31')],qs[_0x9c9d('0x37')](_0x504d3c[_0x9c9d('0x32')][_0x9c9d('0x37')]));_0x4ee271['attributes']=_0x4ee271['attributes'][_0x9c9d('0x38')]?_0x4ee271[_0x9c9d('0x36')]:_0xa8bebe['model'];_0x4ee271[_0x9c9d('0x4d')]=qs[_0x9c9d('0x3a')](_0x504d3c['query']['sort']);_0x4ee271[_0x9c9d('0x3d')]=qs[_0x9c9d('0x34')](_[_0x9c9d('0x3b')](_0x504d3c[_0x9c9d('0x32')],_0xa8bebe[_0x9c9d('0x34')]));if(_0x504d3c[_0x9c9d('0x32')][_0x9c9d('0x3c')]){_0x4ee271[_0x9c9d('0x3d')]=_[_0x9c9d('0x3e')](_0x4ee271[_0x9c9d('0x3d')],{'$or':_['map'](_0x4ee271[_0x9c9d('0x36')],function(_0x455655){var _0x19f641={};_0x19f641[_0x455655]={'$like':'%'+_0x504d3c['query'][_0x9c9d('0x3c')]+'%'};return _0x19f641;})});}_0x4ee271=_[_0x9c9d('0x3e')]({},_0x4ee271,_0x504d3c[_0x9c9d('0x3f')]);return _0x5af519[_0x9c9d('0x4f')](_0x4ee271);}})[_0x9c9d('0x26')](function(_0x7b02a2){if(_0x7b02a2){_0x1d29e0=_0x7b02a2[_0x9c9d('0x38')];if(!_0x504d3c[_0x9c9d('0x32')][_0x9c9d('0x39')](_0x9c9d('0x4e'))){_0x4ee271['limit']=qs[_0x9c9d('0x20')](_0x504d3c['query'][_0x9c9d('0x20')]);_0x4ee271['offset']=qs['offset'](_0x504d3c[_0x9c9d('0x32')][_0x9c9d('0x1e')]);}return _0x5af519[_0x9c9d('0x4f')](_0x4ee271);}})[_0x9c9d('0x26')](function(_0x1c7fec){if(_0x1c7fec){return _0x1c7fec?{'count':_0x1d29e0,'rows':_0x1c7fec}:null;}})['then'](respondWithResult(_0x30cb1c,null))[_0x9c9d('0x47')](handleError(_0x30cb1c,null));};exports[_0x9c9d('0x51')]=function(_0x33672c,_0x3fc384,_0x36ed9a){var _0x250bc4={};var _0x69385d={};var _0x410ae2;var _0x3a3bed;return db[_0x9c9d('0x40')][_0x9c9d('0x50')]({'where':{'id':_0x33672c[_0x9c9d('0x4a')]['id']}})[_0x9c9d('0x26')](handleEntityNotFound(_0x3fc384,null))[_0x9c9d('0x26')](function(_0x4bd18c){if(_0x4bd18c){_0x410ae2=_0x4bd18c;_0x69385d[_0x9c9d('0x31')]=_[_0x9c9d('0x33')](db['VtigerField'][_0x9c9d('0x2f')]);_0x69385d[_0x9c9d('0x32')]=_[_0x9c9d('0x33')](_0x33672c[_0x9c9d('0x32')]);_0x69385d[_0x9c9d('0x34')]=_[_0x9c9d('0x35')](_0x69385d['model'],_0x69385d[_0x9c9d('0x32')]);_0x250bc4[_0x9c9d('0x36')]=_[_0x9c9d('0x35')](_0x69385d[_0x9c9d('0x31')],qs['fields'](_0x33672c[_0x9c9d('0x32')][_0x9c9d('0x37')]));_0x250bc4['attributes']=_0x250bc4['attributes'][_0x9c9d('0x38')]?_0x250bc4[_0x9c9d('0x36')]:_0x69385d[_0x9c9d('0x31')];_0x250bc4['order']=qs[_0x9c9d('0x3a')](_0x33672c['query']['sort']);_0x250bc4[_0x9c9d('0x3d')]=qs[_0x9c9d('0x34')](_['pick'](_0x33672c[_0x9c9d('0x32')],_0x69385d['filters']));if(_0x33672c[_0x9c9d('0x32')][_0x9c9d('0x3c')]){_0x250bc4[_0x9c9d('0x3d')]=_[_0x9c9d('0x3e')](_0x250bc4[_0x9c9d('0x3d')],{'$or':_[_0x9c9d('0x2e')](_0x250bc4['attributes'],function(_0x3f407c){var _0x21a236={};_0x21a236[_0x3f407c]={'$like':'%'+_0x33672c[_0x9c9d('0x32')]['filter']+'%'};return _0x21a236;})});}_0x250bc4=_[_0x9c9d('0x3e')]({},_0x250bc4,_0x33672c['options']);return _0x410ae2[_0x9c9d('0x51')](_0x250bc4);}})[_0x9c9d('0x26')](function(_0x49cb91){if(_0x49cb91){_0x3a3bed=_0x49cb91['length'];if(!_0x33672c[_0x9c9d('0x32')]['hasOwnProperty'](_0x9c9d('0x4e'))){_0x250bc4['limit']=qs[_0x9c9d('0x20')](_0x33672c[_0x9c9d('0x32')]['limit']);_0x250bc4[_0x9c9d('0x1e')]=qs[_0x9c9d('0x1e')](_0x33672c[_0x9c9d('0x32')][_0x9c9d('0x1e')]);}return _0x410ae2[_0x9c9d('0x51')](_0x250bc4);}})[_0x9c9d('0x26')](function(_0xf87ef6){if(_0xf87ef6){return _0xf87ef6?{'count':_0x3a3bed,'rows':_0xf87ef6}:null;}})[_0x9c9d('0x26')](respondWithResult(_0x3fc384,null))[_0x9c9d('0x47')](handleError(_0x3fc384,null));};