Built motion from commit 953226e6.|2.6.32
[motion2.git] / 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 _0x702d=['bluebird','mustache','util','path','to-csv','fs-extra','lodash','squel','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','limit','undefined','count','set','Content-Range','apply','save','destroy','then','error','stack','name','send','index','map','VtigerConfiguration','rawAttributes','fieldName','type','key','model','query','keys','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filters','merge','VIRTUAL','filter','options','includeAll','findAll','rows','catch','show','params','create','body','update','find','findOne','VtigerField','pick','getFields','getSubjects','getDescriptions','eml-format','rimraf','zip-dir','fast-json-patch','request-promise'];(function(_0x2ba05e,_0x40009a){var _0xd4dd07=function(_0x20e0eb){while(--_0x20e0eb){_0x2ba05e['push'](_0x2ba05e['shift']());}};_0xd4dd07(++_0x40009a);}(_0x702d,0x147));var _0xd702=function(_0x519bac,_0x5e4af1){_0x519bac=_0x519bac-0x0;var _0x571631=_0x702d[_0x519bac];return _0x571631;};'use strict';var emlformat=require(_0xd702('0x0'));var rimraf=require(_0xd702('0x1'));var zipdir=require(_0xd702('0x2'));var jsonpatch=require(_0xd702('0x3'));var rp=require(_0xd702('0x4'));var moment=require('moment');var BPromise=require(_0xd702('0x5'));var Mustache=require(_0xd702('0x6'));var util=require(_0xd702('0x7'));var path=require(_0xd702('0x8'));var sox=require('sox');var csv=require(_0xd702('0x9'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xd702('0xa'));var _=require(_0xd702('0xb'));var squel=require(_0xd702('0xc'));var crypto=require('crypto');var jsforce=require(_0xd702('0xd'));var deskjs=require('desk.js');var toCsv=require(_0xd702('0x9'));var querystring=require(_0xd702('0xe'));var Papa=require(_0xd702('0xf'));var Redis=require(_0xd702('0x10'));var authService=require(_0xd702('0x11'));var qs=require(_0xd702('0x12'));var as=require(_0xd702('0x13'));var hardwareService=require(_0xd702('0x14'));var logger=require(_0xd702('0x15'))(_0xd702('0x16'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0xd702('0x17'));var db=require(_0xd702('0x18'))['db'];function respondWithStatusCode(_0x273577,_0x5c0dad){_0x5c0dad=_0x5c0dad||0xcc;return function(_0x13ee5a){if(_0x13ee5a){return _0x273577[_0xd702('0x19')](_0x5c0dad);}return _0x273577[_0xd702('0x1a')](_0x5c0dad)[_0xd702('0x1b')]();};}function respondWithResult(_0x3948f8,_0x181ff2){_0x181ff2=_0x181ff2||0xc8;return function(_0x59dd33){if(_0x59dd33){return _0x3948f8[_0xd702('0x1a')](_0x181ff2)[_0xd702('0x1c')](_0x59dd33);}};}function respondWithFilteredResult(_0x5d7978,_0x707b9){return function(_0x4922f8){if(_0x4922f8){var _0x268c66=typeof _0x707b9[_0xd702('0x1d')]==='undefined'&&typeof _0x707b9[_0xd702('0x1e')]===_0xd702('0x1f');var _0x2a87f2=_0x4922f8['count'];var _0x5b3b1d=_0x268c66?0x0:_0x707b9[_0xd702('0x1d')];var _0x5a296e=_0x268c66?_0x4922f8[_0xd702('0x20')]:_0x707b9[_0xd702('0x1d')]+_0x707b9[_0xd702('0x1e')];var _0x265b1b;if(_0x5a296e>=_0x2a87f2){_0x5a296e=_0x2a87f2;_0x265b1b=0xc8;}else{_0x265b1b=0xce;}_0x5d7978[_0xd702('0x1a')](_0x265b1b);return _0x5d7978[_0xd702('0x21')](_0xd702('0x22'),_0x5b3b1d+'-'+_0x5a296e+'/'+_0x2a87f2)['json'](_0x4922f8);}return null;};}function patchUpdates(_0x4be140){return function(_0x536ca8){try{jsonpatch[_0xd702('0x23')](_0x536ca8,_0x4be140,!![]);}catch(_0x109284){return BPromise['reject'](_0x109284);}return _0x536ca8[_0xd702('0x24')]();};}function saveUpdates(_0x5d91fd,_0xc4c246){return function(_0x5824ec){if(_0x5824ec){return _0x5824ec['update'](_0x5d91fd)['then'](function(_0x21c00e){return _0x21c00e;});}return null;};}function removeEntity(_0xeec2e4,_0x459184){return function(_0x49761c){if(_0x49761c){return _0x49761c[_0xd702('0x25')]()[_0xd702('0x26')](function(){_0xeec2e4[_0xd702('0x1a')](0xcc)[_0xd702('0x1b')]();});}};}function handleEntityNotFound(_0x1200ed,_0x146f35){return function(_0x94c58d){if(!_0x94c58d){_0x1200ed[_0xd702('0x19')](0x194);}return _0x94c58d;};}function handleError(_0x22328a,_0x50d7ad){_0x50d7ad=_0x50d7ad||0x1f4;return function(_0x116b2f){logger[_0xd702('0x27')](_0x116b2f[_0xd702('0x28')]);if(_0x116b2f[_0xd702('0x29')]){delete _0x116b2f[_0xd702('0x29')];}_0x22328a[_0xd702('0x1a')](_0x50d7ad)[_0xd702('0x2a')](_0x116b2f);};}exports[_0xd702('0x2b')]=function(_0x5f1084,_0x47c9a2){var _0x1870b7={},_0x43cd38={},_0x56bc8d={'count':0x0,'rows':[]};var _0x45cd22=_[_0xd702('0x2c')](db[_0xd702('0x2d')][_0xd702('0x2e')],function(_0x56e9cd){return{'name':_0x56e9cd[_0xd702('0x2f')],'type':_0x56e9cd[_0xd702('0x30')][_0xd702('0x31')]};});_0x43cd38[_0xd702('0x32')]=_[_0xd702('0x2c')](_0x45cd22,'name');_0x43cd38[_0xd702('0x33')]=_[_0xd702('0x34')](_0x5f1084[_0xd702('0x33')]);_0x43cd38['filters']=_[_0xd702('0x35')](_0x43cd38['model'],_0x43cd38['query']);_0x1870b7[_0xd702('0x36')]=_[_0xd702('0x35')](_0x43cd38[_0xd702('0x32')],qs['fields'](_0x5f1084[_0xd702('0x33')][_0xd702('0x37')]));_0x1870b7['attributes']=_0x1870b7[_0xd702('0x36')][_0xd702('0x38')]?_0x1870b7[_0xd702('0x36')]:_0x43cd38[_0xd702('0x32')];if(!_0x5f1084[_0xd702('0x33')][_0xd702('0x39')](_0xd702('0x3a'))){_0x1870b7[_0xd702('0x1e')]=qs[_0xd702('0x1e')](_0x5f1084[_0xd702('0x33')][_0xd702('0x1e')]);_0x1870b7[_0xd702('0x1d')]=qs[_0xd702('0x1d')](_0x5f1084['query'][_0xd702('0x1d')]);}_0x1870b7[_0xd702('0x3b')]=qs[_0xd702('0x3c')](_0x5f1084[_0xd702('0x33')][_0xd702('0x3c')]);_0x1870b7[_0xd702('0x3d')]=qs[_0xd702('0x3e')](_['pick'](_0x5f1084['query'],_0x43cd38[_0xd702('0x3e')]),_0x45cd22);if(_0x5f1084[_0xd702('0x33')]['filter']){_0x1870b7['where']=_[_0xd702('0x3f')](_0x1870b7[_0xd702('0x3d')],{'$or':_['map'](_0x45cd22,function(_0x3a7aee){if(_0x3a7aee[_0xd702('0x30')]!==_0xd702('0x40')){var _0x4822d9={};_0x4822d9[_0x3a7aee[_0xd702('0x29')]]={'$like':'%'+_0x5f1084[_0xd702('0x33')][_0xd702('0x41')]+'%'};return _0x4822d9;}})});}_0x1870b7=_['merge']({},_0x1870b7,_0x5f1084[_0xd702('0x42')]);var _0x512854={'where':_0x1870b7[_0xd702('0x3d')]};return db[_0xd702('0x2d')][_0xd702('0x20')](_0x512854)[_0xd702('0x26')](function(_0x6af8d6){_0x56bc8d[_0xd702('0x20')]=_0x6af8d6;if(_0x5f1084[_0xd702('0x33')][_0xd702('0x43')]){_0x1870b7['include']=[{'all':!![]}];}return db[_0xd702('0x2d')][_0xd702('0x44')](_0x1870b7);})[_0xd702('0x26')](function(_0x3d703e){_0x56bc8d[_0xd702('0x45')]=_0x3d703e;return _0x56bc8d;})['then'](respondWithFilteredResult(_0x47c9a2,_0x1870b7))[_0xd702('0x46')](handleError(_0x47c9a2,null));};exports[_0xd702('0x47')]=function(_0x3424a3,_0x4c56ae){var _0xd48ad0={'raw':![],'where':{'id':_0x3424a3[_0xd702('0x48')]['id']}},_0x3a1ed5={};_0x3a1ed5[_0xd702('0x32')]=_['keys'](db[_0xd702('0x2d')][_0xd702('0x2e')]);_0x3a1ed5[_0xd702('0x33')]=_[_0xd702('0x34')](_0x3424a3[_0xd702('0x33')]);_0x3a1ed5['filters']=_[_0xd702('0x35')](_0x3a1ed5[_0xd702('0x32')],_0x3a1ed5['query']);_0xd48ad0['attributes']=_[_0xd702('0x35')](_0x3a1ed5[_0xd702('0x32')],qs[_0xd702('0x37')](_0x3424a3[_0xd702('0x33')][_0xd702('0x37')]));_0xd48ad0[_0xd702('0x36')]=_0xd48ad0[_0xd702('0x36')][_0xd702('0x38')]?_0xd48ad0[_0xd702('0x36')]:_0x3a1ed5['model'];if(_0x3424a3['query'][_0xd702('0x43')]){_0xd48ad0['include']=[{'all':!![]}];}_0xd48ad0=_[_0xd702('0x3f')]({},_0xd48ad0,_0x3424a3['options']);return db[_0xd702('0x2d')]['find'](_0xd48ad0)[_0xd702('0x26')](handleEntityNotFound(_0x4c56ae,null))['then'](respondWithResult(_0x4c56ae,null))[_0xd702('0x46')](handleError(_0x4c56ae,null));};exports[_0xd702('0x49')]=function(_0x543b8f,_0x160f5e){return db[_0xd702('0x2d')][_0xd702('0x49')](_0x543b8f[_0xd702('0x4a')],{})[_0xd702('0x26')](respondWithResult(_0x160f5e,0xc9))['catch'](handleError(_0x160f5e,null));};exports[_0xd702('0x4b')]=function(_0x14c1db,_0x2d09be){if(_0x14c1db['body']['id']){delete _0x14c1db[_0xd702('0x4a')]['id'];}return db['VtigerConfiguration'][_0xd702('0x4c')]({'where':{'id':_0x14c1db[_0xd702('0x48')]['id']}})[_0xd702('0x26')](handleEntityNotFound(_0x2d09be,null))['then'](saveUpdates(_0x14c1db['body'],null))[_0xd702('0x26')](respondWithResult(_0x2d09be,null))[_0xd702('0x46')](handleError(_0x2d09be,null));};exports[_0xd702('0x25')]=function(_0x397e91,_0x16e59b){return db[_0xd702('0x2d')][_0xd702('0x4c')]({'where':{'id':_0x397e91[_0xd702('0x48')]['id']}})[_0xd702('0x26')](handleEntityNotFound(_0x16e59b,null))[_0xd702('0x26')](removeEntity(_0x16e59b,null))['catch'](handleError(_0x16e59b,null));};exports['getFields']=function(_0x2980d5,_0x11260a,_0x229d47){var _0x5180c4={};var _0x52efb4={};var _0x831383;var _0x54c7e2;return db[_0xd702('0x2d')][_0xd702('0x4d')]({'where':{'id':_0x2980d5[_0xd702('0x48')]['id']}})[_0xd702('0x26')](handleEntityNotFound(_0x11260a,null))[_0xd702('0x26')](function(_0x3cd4c1){if(_0x3cd4c1){_0x831383=_0x3cd4c1;_0x52efb4[_0xd702('0x32')]=_[_0xd702('0x34')](db[_0xd702('0x4e')]['rawAttributes']);_0x52efb4[_0xd702('0x33')]=_[_0xd702('0x34')](_0x2980d5[_0xd702('0x33')]);_0x52efb4[_0xd702('0x3e')]=_['intersection'](_0x52efb4[_0xd702('0x32')],_0x52efb4['query']);_0x5180c4[_0xd702('0x36')]=_['intersection'](_0x52efb4['model'],qs[_0xd702('0x37')](_0x2980d5[_0xd702('0x33')][_0xd702('0x37')]));_0x5180c4[_0xd702('0x36')]=_0x5180c4[_0xd702('0x36')][_0xd702('0x38')]?_0x5180c4['attributes']:_0x52efb4[_0xd702('0x32')];_0x5180c4[_0xd702('0x3b')]=qs['sort'](_0x2980d5[_0xd702('0x33')][_0xd702('0x3c')]);_0x5180c4[_0xd702('0x3d')]=qs[_0xd702('0x3e')](_[_0xd702('0x4f')](_0x2980d5[_0xd702('0x33')],_0x52efb4['filters']));if(_0x2980d5[_0xd702('0x33')][_0xd702('0x41')]){_0x5180c4[_0xd702('0x3d')]=_[_0xd702('0x3f')](_0x5180c4[_0xd702('0x3d')],{'$or':_['map'](_0x5180c4['attributes'],function(_0xe2796d){var _0x5d09df={};_0x5d09df[_0xe2796d]={'$like':'%'+_0x2980d5['query'][_0xd702('0x41')]+'%'};return _0x5d09df;})});}_0x5180c4=_['merge']({},_0x5180c4,_0x2980d5[_0xd702('0x42')]);return _0x831383[_0xd702('0x50')](_0x5180c4);}})[_0xd702('0x26')](function(_0x1ea97e){if(_0x1ea97e){_0x54c7e2=_0x1ea97e['length'];if(!_0x2980d5[_0xd702('0x33')]['hasOwnProperty'](_0xd702('0x3a'))){_0x5180c4['limit']=qs[_0xd702('0x1e')](_0x2980d5[_0xd702('0x33')][_0xd702('0x1e')]);_0x5180c4[_0xd702('0x1d')]=qs[_0xd702('0x1d')](_0x2980d5[_0xd702('0x33')][_0xd702('0x1d')]);}return _0x831383['getFields'](_0x5180c4);}})['then'](function(_0x3ab474){if(_0x3ab474){return _0x3ab474?{'count':_0x54c7e2,'rows':_0x3ab474}:null;}})['then'](respondWithResult(_0x11260a,null))[_0xd702('0x46')](handleError(_0x11260a,null));};exports[_0xd702('0x51')]=function(_0x4d5772,_0x22f0db,_0x229666){var _0x4c6b33={};var _0x1dbf12={};var _0x5e88cb;var _0x20f7ac;return db[_0xd702('0x2d')][_0xd702('0x4d')]({'where':{'id':_0x4d5772[_0xd702('0x48')]['id']}})['then'](handleEntityNotFound(_0x22f0db,null))[_0xd702('0x26')](function(_0x3777ae){if(_0x3777ae){_0x5e88cb=_0x3777ae;_0x1dbf12[_0xd702('0x32')]=_[_0xd702('0x34')](db[_0xd702('0x4e')]['rawAttributes']);_0x1dbf12[_0xd702('0x33')]=_[_0xd702('0x34')](_0x4d5772[_0xd702('0x33')]);_0x1dbf12[_0xd702('0x3e')]=_[_0xd702('0x35')](_0x1dbf12[_0xd702('0x32')],_0x1dbf12['query']);_0x4c6b33[_0xd702('0x36')]=_['intersection'](_0x1dbf12[_0xd702('0x32')],qs[_0xd702('0x37')](_0x4d5772[_0xd702('0x33')][_0xd702('0x37')]));_0x4c6b33['attributes']=_0x4c6b33[_0xd702('0x36')][_0xd702('0x38')]?_0x4c6b33[_0xd702('0x36')]:_0x1dbf12[_0xd702('0x32')];_0x4c6b33[_0xd702('0x3b')]=qs['sort'](_0x4d5772['query'][_0xd702('0x3c')]);_0x4c6b33[_0xd702('0x3d')]=qs[_0xd702('0x3e')](_[_0xd702('0x4f')](_0x4d5772[_0xd702('0x33')],_0x1dbf12[_0xd702('0x3e')]));if(_0x4d5772[_0xd702('0x33')][_0xd702('0x41')]){_0x4c6b33[_0xd702('0x3d')]=_[_0xd702('0x3f')](_0x4c6b33[_0xd702('0x3d')],{'$or':_[_0xd702('0x2c')](_0x4c6b33[_0xd702('0x36')],function(_0x75b86f){var _0x8b3e15={};_0x8b3e15[_0x75b86f]={'$like':'%'+_0x4d5772[_0xd702('0x33')]['filter']+'%'};return _0x8b3e15;})});}_0x4c6b33=_[_0xd702('0x3f')]({},_0x4c6b33,_0x4d5772['options']);return _0x5e88cb['getSubjects'](_0x4c6b33);}})[_0xd702('0x26')](function(_0x5cea9f){if(_0x5cea9f){_0x20f7ac=_0x5cea9f[_0xd702('0x38')];if(!_0x4d5772[_0xd702('0x33')][_0xd702('0x39')](_0xd702('0x3a'))){_0x4c6b33[_0xd702('0x1e')]=qs[_0xd702('0x1e')](_0x4d5772[_0xd702('0x33')][_0xd702('0x1e')]);_0x4c6b33[_0xd702('0x1d')]=qs[_0xd702('0x1d')](_0x4d5772[_0xd702('0x33')][_0xd702('0x1d')]);}return _0x5e88cb[_0xd702('0x51')](_0x4c6b33);}})[_0xd702('0x26')](function(_0x5e0470){if(_0x5e0470){return _0x5e0470?{'count':_0x20f7ac,'rows':_0x5e0470}:null;}})[_0xd702('0x26')](respondWithResult(_0x22f0db,null))[_0xd702('0x46')](handleError(_0x22f0db,null));};exports[_0xd702('0x52')]=function(_0x3be3c6,_0x5834e8,_0x15cecd){var _0x32c984={};var _0x454209={};var _0x2d8a0b;var _0x3253a8;return db['VtigerConfiguration'][_0xd702('0x4d')]({'where':{'id':_0x3be3c6[_0xd702('0x48')]['id']}})['then'](handleEntityNotFound(_0x5834e8,null))[_0xd702('0x26')](function(_0x12420){if(_0x12420){_0x2d8a0b=_0x12420;_0x454209[_0xd702('0x32')]=_['keys'](db[_0xd702('0x4e')][_0xd702('0x2e')]);_0x454209['query']=_[_0xd702('0x34')](_0x3be3c6[_0xd702('0x33')]);_0x454209[_0xd702('0x3e')]=_[_0xd702('0x35')](_0x454209[_0xd702('0x32')],_0x454209[_0xd702('0x33')]);_0x32c984[_0xd702('0x36')]=_[_0xd702('0x35')](_0x454209[_0xd702('0x32')],qs[_0xd702('0x37')](_0x3be3c6[_0xd702('0x33')]['fields']));_0x32c984[_0xd702('0x36')]=_0x32c984[_0xd702('0x36')]['length']?_0x32c984[_0xd702('0x36')]:_0x454209[_0xd702('0x32')];_0x32c984[_0xd702('0x3b')]=qs[_0xd702('0x3c')](_0x3be3c6[_0xd702('0x33')]['sort']);_0x32c984['where']=qs[_0xd702('0x3e')](_['pick'](_0x3be3c6[_0xd702('0x33')],_0x454209[_0xd702('0x3e')]));if(_0x3be3c6[_0xd702('0x33')][_0xd702('0x41')]){_0x32c984[_0xd702('0x3d')]=_['merge'](_0x32c984[_0xd702('0x3d')],{'$or':_['map'](_0x32c984[_0xd702('0x36')],function(_0x45ba8b){var _0x42c4c0={};_0x42c4c0[_0x45ba8b]={'$like':'%'+_0x3be3c6[_0xd702('0x33')][_0xd702('0x41')]+'%'};return _0x42c4c0;})});}_0x32c984=_[_0xd702('0x3f')]({},_0x32c984,_0x3be3c6['options']);return _0x2d8a0b['getDescriptions'](_0x32c984);}})[_0xd702('0x26')](function(_0x2eab19){if(_0x2eab19){_0x3253a8=_0x2eab19['length'];if(!_0x3be3c6[_0xd702('0x33')][_0xd702('0x39')]('nolimit')){_0x32c984['limit']=qs[_0xd702('0x1e')](_0x3be3c6[_0xd702('0x33')][_0xd702('0x1e')]);_0x32c984['offset']=qs[_0xd702('0x1d')](_0x3be3c6[_0xd702('0x33')][_0xd702('0x1d')]);}return _0x2d8a0b[_0xd702('0x52')](_0x32c984);}})[_0xd702('0x26')](function(_0x5c661c){if(_0x5c661c){return _0x5c661c?{'count':_0x3253a8,'rows':_0x5c661c}:null;}})[_0xd702('0x26')](respondWithResult(_0x5834e8,null))[_0xd702('0x46')](handleError(_0x5834e8,null));};