[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 _0xf337=['desk.js','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','end','status','offset','undefined','limit','set','Content-Range','json','apply','save','update','then','error','stack','name','send','rawAttributes','fieldName','type','key','model','map','query','keys','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','VIRTUAL','options','VtigerConfiguration','count','includeAll','include','catch','show','params','find','create','body','getFields','findOne','VtigerField','getSubjects','getDescriptions','rimraf','request-promise','moment','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce'];(function(_0x318256,_0xa773f3){var _0xb1e352=function(_0x4bb14e){while(--_0x4bb14e){_0x318256['push'](_0x318256['shift']());}};_0xb1e352(++_0xa773f3);}(_0xf337,0x174));var _0x7f33=function(_0x1a332f,_0x5e7365){_0x1a332f=_0x1a332f-0x0;var _0x611ed5=_0xf337[_0x1a332f];return _0x611ed5;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x7f33('0x0'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0x7f33('0x1'));var moment=require(_0x7f33('0x2'));var BPromise=require('bluebird');var Mustache=require(_0x7f33('0x3'));var util=require(_0x7f33('0x4'));var path=require(_0x7f33('0x5'));var sox=require(_0x7f33('0x6'));var csv=require(_0x7f33('0x7'));var ejs=require(_0x7f33('0x8'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x7f33('0x9'));var squel=require(_0x7f33('0xa'));var crypto=require(_0x7f33('0xb'));var jsforce=require(_0x7f33('0xc'));var deskjs=require(_0x7f33('0xd'));var toCsv=require(_0x7f33('0x7'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0x7f33('0xe'));var authService=require(_0x7f33('0xf'));var qs=require(_0x7f33('0x10'));var as=require(_0x7f33('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x7f33('0x12'))('api');var utils=require(_0x7f33('0x13'));var config=require('../../config/environment');var licenseUtil=require(_0x7f33('0x14'));var db=require(_0x7f33('0x15'))['db'];function respondWithStatusCode(_0x38294e,_0x3617c5){_0x3617c5=_0x3617c5||0xcc;return function(_0x2b13a3){if(_0x2b13a3){return _0x38294e[_0x7f33('0x16')](_0x3617c5);}return _0x38294e['status'](_0x3617c5)[_0x7f33('0x17')]();};}function respondWithResult(_0x22f4d6,_0x17f699){_0x17f699=_0x17f699||0xc8;return function(_0x5c23e2){if(_0x5c23e2){return _0x22f4d6[_0x7f33('0x18')](_0x17f699)['json'](_0x5c23e2);}};}function respondWithFilteredResult(_0x5ea40f,_0x4c12d7){return function(_0x1f0ec8){if(_0x1f0ec8){var _0x4ef498=typeof _0x4c12d7[_0x7f33('0x19')]===_0x7f33('0x1a')&&typeof _0x4c12d7[_0x7f33('0x1b')]==='undefined';var _0x2bbf16=_0x1f0ec8['count'];var _0x1f7ce9=_0x4ef498?0x0:_0x4c12d7[_0x7f33('0x19')];var _0x5cb525=_0x4ef498?_0x1f0ec8['count']:_0x4c12d7[_0x7f33('0x19')]+_0x4c12d7[_0x7f33('0x1b')];var _0x13e0b2;if(_0x5cb525>=_0x2bbf16){_0x5cb525=_0x2bbf16;_0x13e0b2=0xc8;}else{_0x13e0b2=0xce;}_0x5ea40f[_0x7f33('0x18')](_0x13e0b2);return _0x5ea40f[_0x7f33('0x1c')](_0x7f33('0x1d'),_0x1f7ce9+'-'+_0x5cb525+'/'+_0x2bbf16)[_0x7f33('0x1e')](_0x1f0ec8);}return null;};}function patchUpdates(_0x2328ab){return function(_0xdc2610){try{jsonpatch[_0x7f33('0x1f')](_0xdc2610,_0x2328ab,!![]);}catch(_0x3d014b){return BPromise['reject'](_0x3d014b);}return _0xdc2610[_0x7f33('0x20')]();};}function saveUpdates(_0x22109e,_0x583e8d){return function(_0x75804a){if(_0x75804a){return _0x75804a[_0x7f33('0x21')](_0x22109e)[_0x7f33('0x22')](function(_0x31f1ec){return _0x31f1ec;});}return null;};}function removeEntity(_0xf5fa60,_0x137cb0){return function(_0x1961a3){if(_0x1961a3){return _0x1961a3['destroy']()[_0x7f33('0x22')](function(){_0xf5fa60[_0x7f33('0x18')](0xcc)[_0x7f33('0x17')]();});}};}function handleEntityNotFound(_0x154966,_0x1f80ad){return function(_0x17a00f){if(!_0x17a00f){_0x154966[_0x7f33('0x16')](0x194);}return _0x17a00f;};}function handleError(_0x4602a8,_0x576f50){_0x576f50=_0x576f50||0x1f4;return function(_0x4f1498){logger[_0x7f33('0x23')](_0x4f1498[_0x7f33('0x24')]);if(_0x4f1498[_0x7f33('0x25')]){delete _0x4f1498[_0x7f33('0x25')];}_0x4602a8[_0x7f33('0x18')](_0x576f50)[_0x7f33('0x26')](_0x4f1498);};}exports['index']=function(_0x4296c3,_0x58ba21){var _0x1661b5={},_0x256cc0={},_0x2095fe={'count':0x0,'rows':[]};var _0x527c86=_['map'](db['VtigerConfiguration'][_0x7f33('0x27')],function(_0x32b0ab){return{'name':_0x32b0ab[_0x7f33('0x28')],'type':_0x32b0ab[_0x7f33('0x29')][_0x7f33('0x2a')]};});_0x256cc0[_0x7f33('0x2b')]=_[_0x7f33('0x2c')](_0x527c86,_0x7f33('0x25'));_0x256cc0[_0x7f33('0x2d')]=_[_0x7f33('0x2e')](_0x4296c3[_0x7f33('0x2d')]);_0x256cc0[_0x7f33('0x2f')]=_[_0x7f33('0x30')](_0x256cc0[_0x7f33('0x2b')],_0x256cc0[_0x7f33('0x2d')]);_0x1661b5['attributes']=_[_0x7f33('0x30')](_0x256cc0[_0x7f33('0x2b')],qs[_0x7f33('0x31')](_0x4296c3[_0x7f33('0x2d')][_0x7f33('0x31')]));_0x1661b5[_0x7f33('0x32')]=_0x1661b5[_0x7f33('0x32')][_0x7f33('0x33')]?_0x1661b5['attributes']:_0x256cc0[_0x7f33('0x2b')];if(!_0x4296c3[_0x7f33('0x2d')][_0x7f33('0x34')](_0x7f33('0x35'))){_0x1661b5['limit']=qs[_0x7f33('0x1b')](_0x4296c3[_0x7f33('0x2d')][_0x7f33('0x1b')]);_0x1661b5[_0x7f33('0x19')]=qs['offset'](_0x4296c3['query'][_0x7f33('0x19')]);}_0x1661b5[_0x7f33('0x36')]=qs[_0x7f33('0x37')](_0x4296c3[_0x7f33('0x2d')][_0x7f33('0x37')]);_0x1661b5['where']=qs['filters'](_[_0x7f33('0x38')](_0x4296c3[_0x7f33('0x2d')],_0x256cc0['filters']),_0x527c86);if(_0x4296c3['query'][_0x7f33('0x39')]){_0x1661b5[_0x7f33('0x3a')]=_[_0x7f33('0x3b')](_0x1661b5[_0x7f33('0x3a')],{'$or':_[_0x7f33('0x2c')](_0x527c86,function(_0x4d5e3c){if(_0x4d5e3c[_0x7f33('0x29')]!==_0x7f33('0x3c')){var _0x15bd2b={};_0x15bd2b[_0x4d5e3c[_0x7f33('0x25')]]={'$like':'%'+_0x4296c3[_0x7f33('0x2d')][_0x7f33('0x39')]+'%'};return _0x15bd2b;}})});}_0x1661b5=_[_0x7f33('0x3b')]({},_0x1661b5,_0x4296c3[_0x7f33('0x3d')]);var _0x33f5a9={'where':_0x1661b5[_0x7f33('0x3a')]};return db[_0x7f33('0x3e')]['count'](_0x33f5a9)[_0x7f33('0x22')](function(_0x4a84ef){_0x2095fe[_0x7f33('0x3f')]=_0x4a84ef;if(_0x4296c3[_0x7f33('0x2d')][_0x7f33('0x40')]){_0x1661b5[_0x7f33('0x41')]=[{'all':!![]}];}return db[_0x7f33('0x3e')]['findAll'](_0x1661b5);})[_0x7f33('0x22')](function(_0x1d3f4b){_0x2095fe['rows']=_0x1d3f4b;return _0x2095fe;})['then'](respondWithFilteredResult(_0x58ba21,_0x1661b5))[_0x7f33('0x42')](handleError(_0x58ba21,null));};exports[_0x7f33('0x43')]=function(_0x1ced77,_0x1a2ba9){var _0x3f418e={'raw':![],'where':{'id':_0x1ced77[_0x7f33('0x44')]['id']}},_0x4e2ae7={};_0x4e2ae7[_0x7f33('0x2b')]=_['keys'](db[_0x7f33('0x3e')][_0x7f33('0x27')]);_0x4e2ae7[_0x7f33('0x2d')]=_[_0x7f33('0x2e')](_0x1ced77[_0x7f33('0x2d')]);_0x4e2ae7[_0x7f33('0x2f')]=_[_0x7f33('0x30')](_0x4e2ae7[_0x7f33('0x2b')],_0x4e2ae7[_0x7f33('0x2d')]);_0x3f418e[_0x7f33('0x32')]=_[_0x7f33('0x30')](_0x4e2ae7[_0x7f33('0x2b')],qs['fields'](_0x1ced77[_0x7f33('0x2d')]['fields']));_0x3f418e[_0x7f33('0x32')]=_0x3f418e[_0x7f33('0x32')][_0x7f33('0x33')]?_0x3f418e[_0x7f33('0x32')]:_0x4e2ae7['model'];if(_0x1ced77[_0x7f33('0x2d')]['includeAll']){_0x3f418e['include']=[{'all':!![]}];}_0x3f418e=_['merge']({},_0x3f418e,_0x1ced77[_0x7f33('0x3d')]);return db[_0x7f33('0x3e')][_0x7f33('0x45')](_0x3f418e)['then'](handleEntityNotFound(_0x1a2ba9,null))[_0x7f33('0x22')](respondWithResult(_0x1a2ba9,null))['catch'](handleError(_0x1a2ba9,null));};exports[_0x7f33('0x46')]=function(_0x4bcddf,_0x4d42cb){return db[_0x7f33('0x3e')][_0x7f33('0x46')](_0x4bcddf['body'],{})[_0x7f33('0x22')](respondWithResult(_0x4d42cb,0xc9))[_0x7f33('0x42')](handleError(_0x4d42cb,null));};exports['update']=function(_0x4a9739,_0x3859ea){if(_0x4a9739[_0x7f33('0x47')]['id']){delete _0x4a9739['body']['id'];}return db[_0x7f33('0x3e')]['find']({'where':{'id':_0x4a9739[_0x7f33('0x44')]['id']}})[_0x7f33('0x22')](handleEntityNotFound(_0x3859ea,null))[_0x7f33('0x22')](saveUpdates(_0x4a9739[_0x7f33('0x47')],null))[_0x7f33('0x22')](respondWithResult(_0x3859ea,null))[_0x7f33('0x42')](handleError(_0x3859ea,null));};exports['destroy']=function(_0x20ccd9,_0x57c776){return db[_0x7f33('0x3e')][_0x7f33('0x45')]({'where':{'id':_0x20ccd9['params']['id']}})[_0x7f33('0x22')](handleEntityNotFound(_0x57c776,null))[_0x7f33('0x22')](removeEntity(_0x57c776,null))['catch'](handleError(_0x57c776,null));};exports[_0x7f33('0x48')]=function(_0x552126,_0x55e54e,_0x1d58b8){var _0x2b9449={};var _0x1a5380={};var _0x2be467;var _0x3fc225;return db[_0x7f33('0x3e')][_0x7f33('0x49')]({'where':{'id':_0x552126[_0x7f33('0x44')]['id']}})[_0x7f33('0x22')](handleEntityNotFound(_0x55e54e,null))[_0x7f33('0x22')](function(_0x567c60){if(_0x567c60){_0x2be467=_0x567c60;_0x1a5380[_0x7f33('0x2b')]=_['keys'](db[_0x7f33('0x4a')][_0x7f33('0x27')]);_0x1a5380[_0x7f33('0x2d')]=_[_0x7f33('0x2e')](_0x552126[_0x7f33('0x2d')]);_0x1a5380[_0x7f33('0x2f')]=_[_0x7f33('0x30')](_0x1a5380[_0x7f33('0x2b')],_0x1a5380[_0x7f33('0x2d')]);_0x2b9449[_0x7f33('0x32')]=_['intersection'](_0x1a5380[_0x7f33('0x2b')],qs[_0x7f33('0x31')](_0x552126[_0x7f33('0x2d')][_0x7f33('0x31')]));_0x2b9449['attributes']=_0x2b9449[_0x7f33('0x32')][_0x7f33('0x33')]?_0x2b9449[_0x7f33('0x32')]:_0x1a5380[_0x7f33('0x2b')];_0x2b9449[_0x7f33('0x36')]=qs['sort'](_0x552126[_0x7f33('0x2d')][_0x7f33('0x37')]);_0x2b9449[_0x7f33('0x3a')]=qs[_0x7f33('0x2f')](_[_0x7f33('0x38')](_0x552126[_0x7f33('0x2d')],_0x1a5380['filters']));if(_0x552126['query'][_0x7f33('0x39')]){_0x2b9449[_0x7f33('0x3a')]=_[_0x7f33('0x3b')](_0x2b9449[_0x7f33('0x3a')],{'$or':_[_0x7f33('0x2c')](_0x2b9449[_0x7f33('0x32')],function(_0x2fdb0c){var _0x2d46ea={};_0x2d46ea[_0x2fdb0c]={'$like':'%'+_0x552126[_0x7f33('0x2d')][_0x7f33('0x39')]+'%'};return _0x2d46ea;})});}_0x2b9449=_[_0x7f33('0x3b')]({},_0x2b9449,_0x552126[_0x7f33('0x3d')]);return _0x2be467[_0x7f33('0x48')](_0x2b9449);}})[_0x7f33('0x22')](function(_0x5963bc){if(_0x5963bc){_0x3fc225=_0x5963bc['length'];if(!_0x552126[_0x7f33('0x2d')][_0x7f33('0x34')](_0x7f33('0x35'))){_0x2b9449['limit']=qs['limit'](_0x552126[_0x7f33('0x2d')][_0x7f33('0x1b')]);_0x2b9449[_0x7f33('0x19')]=qs['offset'](_0x552126[_0x7f33('0x2d')][_0x7f33('0x19')]);}return _0x2be467[_0x7f33('0x48')](_0x2b9449);}})[_0x7f33('0x22')](function(_0x3f5e49){if(_0x3f5e49){return _0x3f5e49?{'count':_0x3fc225,'rows':_0x3f5e49}:null;}})[_0x7f33('0x22')](respondWithResult(_0x55e54e,null))[_0x7f33('0x42')](handleError(_0x55e54e,null));};exports[_0x7f33('0x4b')]=function(_0x5361f5,_0x4270a3,_0x3616c9){var _0x5e4da1={};var _0x5a9ef7={};var _0x1688b4;var _0xdc7f16;return db['VtigerConfiguration']['findOne']({'where':{'id':_0x5361f5[_0x7f33('0x44')]['id']}})[_0x7f33('0x22')](handleEntityNotFound(_0x4270a3,null))[_0x7f33('0x22')](function(_0x869d58){if(_0x869d58){_0x1688b4=_0x869d58;_0x5a9ef7['model']=_[_0x7f33('0x2e')](db[_0x7f33('0x4a')][_0x7f33('0x27')]);_0x5a9ef7[_0x7f33('0x2d')]=_['keys'](_0x5361f5['query']);_0x5a9ef7[_0x7f33('0x2f')]=_['intersection'](_0x5a9ef7[_0x7f33('0x2b')],_0x5a9ef7['query']);_0x5e4da1['attributes']=_[_0x7f33('0x30')](_0x5a9ef7['model'],qs[_0x7f33('0x31')](_0x5361f5[_0x7f33('0x2d')][_0x7f33('0x31')]));_0x5e4da1[_0x7f33('0x32')]=_0x5e4da1[_0x7f33('0x32')][_0x7f33('0x33')]?_0x5e4da1[_0x7f33('0x32')]:_0x5a9ef7[_0x7f33('0x2b')];_0x5e4da1[_0x7f33('0x36')]=qs['sort'](_0x5361f5['query']['sort']);_0x5e4da1[_0x7f33('0x3a')]=qs[_0x7f33('0x2f')](_[_0x7f33('0x38')](_0x5361f5[_0x7f33('0x2d')],_0x5a9ef7['filters']));if(_0x5361f5['query']['filter']){_0x5e4da1[_0x7f33('0x3a')]=_['merge'](_0x5e4da1[_0x7f33('0x3a')],{'$or':_[_0x7f33('0x2c')](_0x5e4da1[_0x7f33('0x32')],function(_0x121b24){var _0x11096f={};_0x11096f[_0x121b24]={'$like':'%'+_0x5361f5[_0x7f33('0x2d')][_0x7f33('0x39')]+'%'};return _0x11096f;})});}_0x5e4da1=_[_0x7f33('0x3b')]({},_0x5e4da1,_0x5361f5[_0x7f33('0x3d')]);return _0x1688b4[_0x7f33('0x4b')](_0x5e4da1);}})[_0x7f33('0x22')](function(_0xac50cc){if(_0xac50cc){_0xdc7f16=_0xac50cc[_0x7f33('0x33')];if(!_0x5361f5[_0x7f33('0x2d')][_0x7f33('0x34')](_0x7f33('0x35'))){_0x5e4da1[_0x7f33('0x1b')]=qs['limit'](_0x5361f5['query'][_0x7f33('0x1b')]);_0x5e4da1[_0x7f33('0x19')]=qs[_0x7f33('0x19')](_0x5361f5[_0x7f33('0x2d')][_0x7f33('0x19')]);}return _0x1688b4[_0x7f33('0x4b')](_0x5e4da1);}})[_0x7f33('0x22')](function(_0x1ace34){if(_0x1ace34){return _0x1ace34?{'count':_0xdc7f16,'rows':_0x1ace34}:null;}})[_0x7f33('0x22')](respondWithResult(_0x4270a3,null))[_0x7f33('0x42')](handleError(_0x4270a3,null));};exports[_0x7f33('0x4c')]=function(_0x594f91,_0x22466e,_0x1cc46f){var _0x2d8947={};var _0x1c7a8f={};var _0x809a09;var _0x3ae171;return db[_0x7f33('0x3e')][_0x7f33('0x49')]({'where':{'id':_0x594f91['params']['id']}})['then'](handleEntityNotFound(_0x22466e,null))[_0x7f33('0x22')](function(_0x127aaf){if(_0x127aaf){_0x809a09=_0x127aaf;_0x1c7a8f[_0x7f33('0x2b')]=_[_0x7f33('0x2e')](db[_0x7f33('0x4a')][_0x7f33('0x27')]);_0x1c7a8f['query']=_[_0x7f33('0x2e')](_0x594f91['query']);_0x1c7a8f[_0x7f33('0x2f')]=_[_0x7f33('0x30')](_0x1c7a8f[_0x7f33('0x2b')],_0x1c7a8f[_0x7f33('0x2d')]);_0x2d8947[_0x7f33('0x32')]=_[_0x7f33('0x30')](_0x1c7a8f[_0x7f33('0x2b')],qs[_0x7f33('0x31')](_0x594f91[_0x7f33('0x2d')][_0x7f33('0x31')]));_0x2d8947[_0x7f33('0x32')]=_0x2d8947[_0x7f33('0x32')]['length']?_0x2d8947[_0x7f33('0x32')]:_0x1c7a8f['model'];_0x2d8947[_0x7f33('0x36')]=qs[_0x7f33('0x37')](_0x594f91[_0x7f33('0x2d')][_0x7f33('0x37')]);_0x2d8947[_0x7f33('0x3a')]=qs['filters'](_['pick'](_0x594f91[_0x7f33('0x2d')],_0x1c7a8f['filters']));if(_0x594f91[_0x7f33('0x2d')][_0x7f33('0x39')]){_0x2d8947['where']=_[_0x7f33('0x3b')](_0x2d8947['where'],{'$or':_[_0x7f33('0x2c')](_0x2d8947[_0x7f33('0x32')],function(_0x539407){var _0x12b047={};_0x12b047[_0x539407]={'$like':'%'+_0x594f91[_0x7f33('0x2d')][_0x7f33('0x39')]+'%'};return _0x12b047;})});}_0x2d8947=_[_0x7f33('0x3b')]({},_0x2d8947,_0x594f91['options']);return _0x809a09[_0x7f33('0x4c')](_0x2d8947);}})[_0x7f33('0x22')](function(_0xb6dfe6){if(_0xb6dfe6){_0x3ae171=_0xb6dfe6['length'];if(!_0x594f91[_0x7f33('0x2d')][_0x7f33('0x34')](_0x7f33('0x35'))){_0x2d8947[_0x7f33('0x1b')]=qs['limit'](_0x594f91[_0x7f33('0x2d')]['limit']);_0x2d8947['offset']=qs[_0x7f33('0x19')](_0x594f91['query'][_0x7f33('0x19')]);}return _0x809a09[_0x7f33('0x4c')](_0x2d8947);}})[_0x7f33('0x22')](function(_0x18e7e2){if(_0x18e7e2){return _0x18e7e2?{'count':_0x3ae171,'rows':_0x18e7e2}:null;}})[_0x7f33('0x22')](respondWithResult(_0x22466e,null))[_0x7f33('0x42')](handleError(_0x22466e,null));};