Built motion from commit f7863d46.|2.5.41
[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 _0x5568=['VtigerConfiguration','rawAttributes','fieldName','type','filters','intersection','model','query','attributes','fields','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','options','includeAll','findAll','rows','catch','keys','length','include','find','body','params','getFields','findOne','VtigerField','getSubjects','hasOwnProperty','getDescriptions','rimraf','fast-json-patch','moment','bluebird','mustache','path','sox','to-csv','ejs','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/environment','../../mysqldb','sendStatus','end','status','json','undefined','limit','count','offset','set','Content-Range','apply','save','update','destroy','then','error','name','map'];(function(_0x27c24e,_0x5db1c7){var _0x39004a=function(_0x44286d){while(--_0x44286d){_0x27c24e['push'](_0x27c24e['shift']());}};_0x39004a(++_0x5db1c7);}(_0x5568,0x6f));var _0x8556=function(_0x15fe58,_0x3f9c92){_0x15fe58=_0x15fe58-0x0;var _0x4cf91c=_0x5568[_0x15fe58];return _0x4cf91c;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x8556('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0x8556('0x1'));var rp=require('request-promise');var moment=require(_0x8556('0x2'));var BPromise=require(_0x8556('0x3'));var Mustache=require(_0x8556('0x4'));var util=require('util');var path=require(_0x8556('0x5'));var sox=require(_0x8556('0x6'));var csv=require(_0x8556('0x7'));var ejs=require(_0x8556('0x8'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x8556('0x9'));var squel=require(_0x8556('0xa'));var crypto=require('crypto');var jsforce=require(_0x8556('0xb'));var deskjs=require(_0x8556('0xc'));var toCsv=require('to-csv');var querystring=require(_0x8556('0xd'));var Papa=require(_0x8556('0xe'));var Redis=require(_0x8556('0xf'));var authService=require(_0x8556('0x10'));var qs=require(_0x8556('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x8556('0x12'));var logger=require(_0x8556('0x13'))(_0x8556('0x14'));var utils=require('../../config/utils');var config=require(_0x8556('0x15'));var licenseUtil=require('../../config/license/util');var db=require(_0x8556('0x16'))['db'];function respondWithStatusCode(_0x31e638,_0x5bd215){_0x5bd215=_0x5bd215||0xcc;return function(_0xef0525){if(_0xef0525){return _0x31e638[_0x8556('0x17')](_0x5bd215);}return _0x31e638['status'](_0x5bd215)[_0x8556('0x18')]();};}function respondWithResult(_0x52b197,_0xaf2107){_0xaf2107=_0xaf2107||0xc8;return function(_0x277900){if(_0x277900){return _0x52b197[_0x8556('0x19')](_0xaf2107)[_0x8556('0x1a')](_0x277900);}};}function respondWithFilteredResult(_0x3bae94,_0x9d71b2){return function(_0x4531a3){if(_0x4531a3){var _0x4b1b03=typeof _0x9d71b2['offset']===_0x8556('0x1b')&&typeof _0x9d71b2[_0x8556('0x1c')]===_0x8556('0x1b');var _0x5b15ad=_0x4531a3[_0x8556('0x1d')];var _0x52e508=_0x4b1b03?0x0:_0x9d71b2[_0x8556('0x1e')];var _0x443f41=_0x4b1b03?_0x4531a3['count']:_0x9d71b2[_0x8556('0x1e')]+_0x9d71b2[_0x8556('0x1c')];var _0x121bba;if(_0x443f41>=_0x5b15ad){_0x443f41=_0x5b15ad;_0x121bba=0xc8;}else{_0x121bba=0xce;}_0x3bae94[_0x8556('0x19')](_0x121bba);return _0x3bae94[_0x8556('0x1f')](_0x8556('0x20'),_0x52e508+'-'+_0x443f41+'/'+_0x5b15ad)[_0x8556('0x1a')](_0x4531a3);}return null;};}function patchUpdates(_0x22abbe){return function(_0x412f82){try{jsonpatch[_0x8556('0x21')](_0x412f82,_0x22abbe,!![]);}catch(_0xf13f2b){return BPromise['reject'](_0xf13f2b);}return _0x412f82[_0x8556('0x22')]();};}function saveUpdates(_0x13e18a,_0x35634f){return function(_0x51de8d){if(_0x51de8d){return _0x51de8d[_0x8556('0x23')](_0x13e18a)['then'](function(_0xeb9f3e){return _0xeb9f3e;});}return null;};}function removeEntity(_0x55f2af,_0x5e1c51){return function(_0x516769){if(_0x516769){return _0x516769[_0x8556('0x24')]()[_0x8556('0x25')](function(){_0x55f2af[_0x8556('0x19')](0xcc)[_0x8556('0x18')]();});}};}function handleEntityNotFound(_0x2cabe5,_0x4b9c00){return function(_0x2a8731){if(!_0x2a8731){_0x2cabe5[_0x8556('0x17')](0x194);}return _0x2a8731;};}function handleError(_0x3aef80,_0x4438fd){_0x4438fd=_0x4438fd||0x1f4;return function(_0x380b52){logger[_0x8556('0x26')](_0x380b52['stack']);if(_0x380b52[_0x8556('0x27')]){delete _0x380b52[_0x8556('0x27')];}_0x3aef80[_0x8556('0x19')](_0x4438fd)['send'](_0x380b52);};}exports['index']=function(_0x1eee74,_0x544abe){var _0x4c61ed={},_0x933b52={},_0x25c0f1={'count':0x0,'rows':[]};var _0x17e8ae=_[_0x8556('0x28')](db[_0x8556('0x29')][_0x8556('0x2a')],function(_0x1b426e){return{'name':_0x1b426e[_0x8556('0x2b')],'type':_0x1b426e[_0x8556('0x2c')]['key']};});_0x933b52['model']=_[_0x8556('0x28')](_0x17e8ae,_0x8556('0x27'));_0x933b52['query']=_['keys'](_0x1eee74['query']);_0x933b52[_0x8556('0x2d')]=_[_0x8556('0x2e')](_0x933b52[_0x8556('0x2f')],_0x933b52[_0x8556('0x30')]);_0x4c61ed[_0x8556('0x31')]=_[_0x8556('0x2e')](_0x933b52['model'],qs[_0x8556('0x32')](_0x1eee74[_0x8556('0x30')][_0x8556('0x32')]));_0x4c61ed[_0x8556('0x31')]=_0x4c61ed[_0x8556('0x31')]['length']?_0x4c61ed[_0x8556('0x31')]:_0x933b52[_0x8556('0x2f')];if(!_0x1eee74[_0x8556('0x30')]['hasOwnProperty'](_0x8556('0x33'))){_0x4c61ed['limit']=qs[_0x8556('0x1c')](_0x1eee74['query'][_0x8556('0x1c')]);_0x4c61ed[_0x8556('0x1e')]=qs[_0x8556('0x1e')](_0x1eee74[_0x8556('0x30')][_0x8556('0x1e')]);}_0x4c61ed[_0x8556('0x34')]=qs[_0x8556('0x35')](_0x1eee74[_0x8556('0x30')][_0x8556('0x35')]);_0x4c61ed[_0x8556('0x36')]=qs[_0x8556('0x2d')](_[_0x8556('0x37')](_0x1eee74[_0x8556('0x30')],_0x933b52[_0x8556('0x2d')]),_0x17e8ae);if(_0x1eee74[_0x8556('0x30')][_0x8556('0x38')]){_0x4c61ed['where']=_[_0x8556('0x39')](_0x4c61ed[_0x8556('0x36')],{'$or':_[_0x8556('0x28')](_0x17e8ae,function(_0xd52551){if(_0xd52551[_0x8556('0x2c')]!==_0x8556('0x3a')){var _0x243370={};_0x243370[_0xd52551[_0x8556('0x27')]]={'$like':'%'+_0x1eee74[_0x8556('0x30')][_0x8556('0x38')]+'%'};return _0x243370;}})});}_0x4c61ed=_['merge']({},_0x4c61ed,_0x1eee74[_0x8556('0x3b')]);var _0x3165e9={'where':_0x4c61ed[_0x8556('0x36')]};return db[_0x8556('0x29')]['count'](_0x3165e9)[_0x8556('0x25')](function(_0x57b5d5){_0x25c0f1[_0x8556('0x1d')]=_0x57b5d5;if(_0x1eee74[_0x8556('0x30')][_0x8556('0x3c')]){_0x4c61ed['include']=[{'all':!![]}];}return db['VtigerConfiguration'][_0x8556('0x3d')](_0x4c61ed);})[_0x8556('0x25')](function(_0x3a240b){_0x25c0f1[_0x8556('0x3e')]=_0x3a240b;return _0x25c0f1;})[_0x8556('0x25')](respondWithFilteredResult(_0x544abe,_0x4c61ed))[_0x8556('0x3f')](handleError(_0x544abe,null));};exports['show']=function(_0x48ccf,_0x27fa66){var _0x48d41c={'raw':![],'where':{'id':_0x48ccf['params']['id']}},_0x235de3={};_0x235de3['model']=_[_0x8556('0x40')](db[_0x8556('0x29')][_0x8556('0x2a')]);_0x235de3['query']=_[_0x8556('0x40')](_0x48ccf[_0x8556('0x30')]);_0x235de3[_0x8556('0x2d')]=_['intersection'](_0x235de3[_0x8556('0x2f')],_0x235de3['query']);_0x48d41c[_0x8556('0x31')]=_['intersection'](_0x235de3[_0x8556('0x2f')],qs[_0x8556('0x32')](_0x48ccf[_0x8556('0x30')][_0x8556('0x32')]));_0x48d41c[_0x8556('0x31')]=_0x48d41c['attributes'][_0x8556('0x41')]?_0x48d41c[_0x8556('0x31')]:_0x235de3[_0x8556('0x2f')];if(_0x48ccf[_0x8556('0x30')][_0x8556('0x3c')]){_0x48d41c[_0x8556('0x42')]=[{'all':!![]}];}_0x48d41c=_['merge']({},_0x48d41c,_0x48ccf['options']);return db[_0x8556('0x29')][_0x8556('0x43')](_0x48d41c)['then'](handleEntityNotFound(_0x27fa66,null))[_0x8556('0x25')](respondWithResult(_0x27fa66,null))['catch'](handleError(_0x27fa66,null));};exports['create']=function(_0x11a824,_0x16d181){return db[_0x8556('0x29')]['create'](_0x11a824[_0x8556('0x44')],{})[_0x8556('0x25')](respondWithResult(_0x16d181,0xc9))[_0x8556('0x3f')](handleError(_0x16d181,null));};exports[_0x8556('0x23')]=function(_0x382082,_0x16d947){if(_0x382082[_0x8556('0x44')]['id']){delete _0x382082[_0x8556('0x44')]['id'];}return db[_0x8556('0x29')][_0x8556('0x43')]({'where':{'id':_0x382082['params']['id']}})[_0x8556('0x25')](handleEntityNotFound(_0x16d947,null))[_0x8556('0x25')](saveUpdates(_0x382082[_0x8556('0x44')],null))['then'](respondWithResult(_0x16d947,null))[_0x8556('0x3f')](handleError(_0x16d947,null));};exports[_0x8556('0x24')]=function(_0x47fdeb,_0x55f6b4){return db[_0x8556('0x29')][_0x8556('0x43')]({'where':{'id':_0x47fdeb[_0x8556('0x45')]['id']}})[_0x8556('0x25')](handleEntityNotFound(_0x55f6b4,null))[_0x8556('0x25')](removeEntity(_0x55f6b4,null))['catch'](handleError(_0x55f6b4,null));};exports[_0x8556('0x46')]=function(_0x51a3f1,_0x4a3af0,_0x2f012d){var _0xe26929={};var _0x5db36d={};var _0x513851;var _0x5abf1f;return db[_0x8556('0x29')][_0x8556('0x47')]({'where':{'id':_0x51a3f1[_0x8556('0x45')]['id']}})['then'](handleEntityNotFound(_0x4a3af0,null))[_0x8556('0x25')](function(_0x28bce0){if(_0x28bce0){_0x513851=_0x28bce0;_0x5db36d[_0x8556('0x2f')]=_[_0x8556('0x40')](db[_0x8556('0x48')][_0x8556('0x2a')]);_0x5db36d[_0x8556('0x30')]=_[_0x8556('0x40')](_0x51a3f1[_0x8556('0x30')]);_0x5db36d[_0x8556('0x2d')]=_[_0x8556('0x2e')](_0x5db36d['model'],_0x5db36d[_0x8556('0x30')]);_0xe26929[_0x8556('0x31')]=_['intersection'](_0x5db36d[_0x8556('0x2f')],qs[_0x8556('0x32')](_0x51a3f1['query'][_0x8556('0x32')]));_0xe26929['attributes']=_0xe26929[_0x8556('0x31')][_0x8556('0x41')]?_0xe26929[_0x8556('0x31')]:_0x5db36d[_0x8556('0x2f')];_0xe26929[_0x8556('0x34')]=qs['sort'](_0x51a3f1[_0x8556('0x30')][_0x8556('0x35')]);_0xe26929['where']=qs[_0x8556('0x2d')](_[_0x8556('0x37')](_0x51a3f1[_0x8556('0x30')],_0x5db36d['filters']));if(_0x51a3f1[_0x8556('0x30')][_0x8556('0x38')]){_0xe26929[_0x8556('0x36')]=_['merge'](_0xe26929[_0x8556('0x36')],{'$or':_['map'](_0xe26929[_0x8556('0x31')],function(_0x3bfbeb){var _0x3f43b1={};_0x3f43b1[_0x3bfbeb]={'$like':'%'+_0x51a3f1['query']['filter']+'%'};return _0x3f43b1;})});}_0xe26929=_[_0x8556('0x39')]({},_0xe26929,_0x51a3f1[_0x8556('0x3b')]);return _0x513851[_0x8556('0x46')](_0xe26929);}})['then'](function(_0x204a7b){if(_0x204a7b){_0x5abf1f=_0x204a7b['length'];if(!_0x51a3f1['query']['hasOwnProperty'](_0x8556('0x33'))){_0xe26929[_0x8556('0x1c')]=qs[_0x8556('0x1c')](_0x51a3f1[_0x8556('0x30')]['limit']);_0xe26929['offset']=qs[_0x8556('0x1e')](_0x51a3f1[_0x8556('0x30')][_0x8556('0x1e')]);}return _0x513851[_0x8556('0x46')](_0xe26929);}})[_0x8556('0x25')](function(_0x497e04){if(_0x497e04){return _0x497e04?{'count':_0x5abf1f,'rows':_0x497e04}:null;}})['then'](respondWithResult(_0x4a3af0,null))[_0x8556('0x3f')](handleError(_0x4a3af0,null));};exports[_0x8556('0x49')]=function(_0x5ce82e,_0x307aee,_0x49ae75){var _0x2cfea9={};var _0x5a014e={};var _0xe49d5d;var _0x5a6467;return db[_0x8556('0x29')][_0x8556('0x47')]({'where':{'id':_0x5ce82e[_0x8556('0x45')]['id']}})[_0x8556('0x25')](handleEntityNotFound(_0x307aee,null))['then'](function(_0x81bff){if(_0x81bff){_0xe49d5d=_0x81bff;_0x5a014e[_0x8556('0x2f')]=_[_0x8556('0x40')](db[_0x8556('0x48')][_0x8556('0x2a')]);_0x5a014e[_0x8556('0x30')]=_[_0x8556('0x40')](_0x5ce82e[_0x8556('0x30')]);_0x5a014e['filters']=_[_0x8556('0x2e')](_0x5a014e['model'],_0x5a014e[_0x8556('0x30')]);_0x2cfea9['attributes']=_[_0x8556('0x2e')](_0x5a014e[_0x8556('0x2f')],qs[_0x8556('0x32')](_0x5ce82e[_0x8556('0x30')][_0x8556('0x32')]));_0x2cfea9[_0x8556('0x31')]=_0x2cfea9[_0x8556('0x31')]['length']?_0x2cfea9[_0x8556('0x31')]:_0x5a014e[_0x8556('0x2f')];_0x2cfea9[_0x8556('0x34')]=qs['sort'](_0x5ce82e[_0x8556('0x30')]['sort']);_0x2cfea9[_0x8556('0x36')]=qs['filters'](_['pick'](_0x5ce82e[_0x8556('0x30')],_0x5a014e[_0x8556('0x2d')]));if(_0x5ce82e[_0x8556('0x30')][_0x8556('0x38')]){_0x2cfea9[_0x8556('0x36')]=_[_0x8556('0x39')](_0x2cfea9[_0x8556('0x36')],{'$or':_['map'](_0x2cfea9[_0x8556('0x31')],function(_0x2f0f44){var _0x34237b={};_0x34237b[_0x2f0f44]={'$like':'%'+_0x5ce82e[_0x8556('0x30')][_0x8556('0x38')]+'%'};return _0x34237b;})});}_0x2cfea9=_['merge']({},_0x2cfea9,_0x5ce82e['options']);return _0xe49d5d['getSubjects'](_0x2cfea9);}})['then'](function(_0x59494f){if(_0x59494f){_0x5a6467=_0x59494f[_0x8556('0x41')];if(!_0x5ce82e[_0x8556('0x30')][_0x8556('0x4a')](_0x8556('0x33'))){_0x2cfea9[_0x8556('0x1c')]=qs['limit'](_0x5ce82e[_0x8556('0x30')]['limit']);_0x2cfea9['offset']=qs[_0x8556('0x1e')](_0x5ce82e[_0x8556('0x30')][_0x8556('0x1e')]);}return _0xe49d5d['getSubjects'](_0x2cfea9);}})[_0x8556('0x25')](function(_0x347a8e){if(_0x347a8e){return _0x347a8e?{'count':_0x5a6467,'rows':_0x347a8e}:null;}})[_0x8556('0x25')](respondWithResult(_0x307aee,null))[_0x8556('0x3f')](handleError(_0x307aee,null));};exports['getDescriptions']=function(_0x1620dd,_0x13d1bd,_0x3a8166){var _0x37c4ce={};var _0x545ecf={};var _0x16f886;var _0x2b5da1;return db['VtigerConfiguration']['findOne']({'where':{'id':_0x1620dd['params']['id']}})[_0x8556('0x25')](handleEntityNotFound(_0x13d1bd,null))['then'](function(_0x176b6c){if(_0x176b6c){_0x16f886=_0x176b6c;_0x545ecf['model']=_[_0x8556('0x40')](db[_0x8556('0x48')][_0x8556('0x2a')]);_0x545ecf[_0x8556('0x30')]=_[_0x8556('0x40')](_0x1620dd[_0x8556('0x30')]);_0x545ecf[_0x8556('0x2d')]=_[_0x8556('0x2e')](_0x545ecf[_0x8556('0x2f')],_0x545ecf[_0x8556('0x30')]);_0x37c4ce[_0x8556('0x31')]=_[_0x8556('0x2e')](_0x545ecf[_0x8556('0x2f')],qs[_0x8556('0x32')](_0x1620dd['query'][_0x8556('0x32')]));_0x37c4ce[_0x8556('0x31')]=_0x37c4ce[_0x8556('0x31')][_0x8556('0x41')]?_0x37c4ce['attributes']:_0x545ecf[_0x8556('0x2f')];_0x37c4ce['order']=qs['sort'](_0x1620dd[_0x8556('0x30')]['sort']);_0x37c4ce['where']=qs[_0x8556('0x2d')](_[_0x8556('0x37')](_0x1620dd[_0x8556('0x30')],_0x545ecf[_0x8556('0x2d')]));if(_0x1620dd[_0x8556('0x30')][_0x8556('0x38')]){_0x37c4ce[_0x8556('0x36')]=_['merge'](_0x37c4ce[_0x8556('0x36')],{'$or':_[_0x8556('0x28')](_0x37c4ce[_0x8556('0x31')],function(_0xd8c1af){var _0x111a7d={};_0x111a7d[_0xd8c1af]={'$like':'%'+_0x1620dd[_0x8556('0x30')][_0x8556('0x38')]+'%'};return _0x111a7d;})});}_0x37c4ce=_[_0x8556('0x39')]({},_0x37c4ce,_0x1620dd['options']);return _0x16f886[_0x8556('0x4b')](_0x37c4ce);}})['then'](function(_0x4f9056){if(_0x4f9056){_0x2b5da1=_0x4f9056[_0x8556('0x41')];if(!_0x1620dd[_0x8556('0x30')][_0x8556('0x4a')](_0x8556('0x33'))){_0x37c4ce['limit']=qs['limit'](_0x1620dd[_0x8556('0x30')][_0x8556('0x1c')]);_0x37c4ce[_0x8556('0x1e')]=qs[_0x8556('0x1e')](_0x1620dd[_0x8556('0x30')]['offset']);}return _0x16f886[_0x8556('0x4b')](_0x37c4ce);}})[_0x8556('0x25')](function(_0x5bd107){if(_0x5bd107){return _0x5bd107?{'count':_0x2b5da1,'rows':_0x5bd107}:null;}})[_0x8556('0x25')](respondWithResult(_0x13d1bd,null))[_0x8556('0x3f')](handleError(_0x13d1bd,null));};