8796a702cf4757e3b60734611839cf4dc318a932
[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 _0x4cad=['nolimit','getSubjects','hasOwnProperty','getDescriptions','eml-format','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','fs-extra','lodash','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/logger','api','../../config/license/util','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','save','update','then','error','stack','name','index','VtigerConfiguration','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','fields','attributes','length','order','sort','where','pick','merge','map','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','params','find','create','body','findOne','VtigerField','filter','getFields'];(function(_0x3da27c,_0x15a0c2){var _0x465617=function(_0x1d0266){while(--_0x1d0266){_0x3da27c['push'](_0x3da27c['shift']());}};_0x465617(++_0x15a0c2);}(_0x4cad,0x1d8));var _0xd4ca=function(_0x49ecfc,_0x20caa5){_0x49ecfc=_0x49ecfc-0x0;var _0x2cca9c=_0x4cad[_0x49ecfc];return _0x2cca9c;};'use strict';var emlformat=require(_0xd4ca('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0xd4ca('0x1'));var rp=require(_0xd4ca('0x2'));var moment=require(_0xd4ca('0x3'));var BPromise=require(_0xd4ca('0x4'));var Mustache=require(_0xd4ca('0x5'));var util=require(_0xd4ca('0x6'));var path=require(_0xd4ca('0x7'));var sox=require('sox');var csv=require(_0xd4ca('0x8'));var ejs=require(_0xd4ca('0x9'));var fs=require('fs');var fs_extra=require(_0xd4ca('0xa'));var _=require(_0xd4ca('0xb'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0xd4ca('0xc'));var deskjs=require('desk.js');var toCsv=require(_0xd4ca('0x8'));var querystring=require(_0xd4ca('0xd'));var Papa=require(_0xd4ca('0xe'));var Redis=require(_0xd4ca('0xf'));var authService=require(_0xd4ca('0x10'));var qs=require(_0xd4ca('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0xd4ca('0x12'))(_0xd4ca('0x13'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0xd4ca('0x14'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x3678d0,_0x2c866b){_0x2c866b=_0x2c866b||0xcc;return function(_0x32fccb){if(_0x32fccb){return _0x3678d0[_0xd4ca('0x15')](_0x2c866b);}return _0x3678d0[_0xd4ca('0x16')](_0x2c866b)[_0xd4ca('0x17')]();};}function respondWithResult(_0x4186ab,_0xe424e){_0xe424e=_0xe424e||0xc8;return function(_0x4a79f2){if(_0x4a79f2){return _0x4186ab[_0xd4ca('0x16')](_0xe424e)[_0xd4ca('0x18')](_0x4a79f2);}};}function respondWithFilteredResult(_0x1385b0,_0x504a3a){return function(_0x230331){if(_0x230331){var _0xe39a91=typeof _0x504a3a[_0xd4ca('0x19')]===_0xd4ca('0x1a')&&typeof _0x504a3a[_0xd4ca('0x1b')]==='undefined';var _0xa60278=_0x230331[_0xd4ca('0x1c')];var _0x58fb14=_0xe39a91?0x0:_0x504a3a[_0xd4ca('0x19')];var _0x5ec1dc=_0xe39a91?_0x230331[_0xd4ca('0x1c')]:_0x504a3a[_0xd4ca('0x19')]+_0x504a3a[_0xd4ca('0x1b')];var _0x2d8c3c;if(_0x5ec1dc>=_0xa60278){_0x5ec1dc=_0xa60278;_0x2d8c3c=0xc8;}else{_0x2d8c3c=0xce;}_0x1385b0[_0xd4ca('0x16')](_0x2d8c3c);return _0x1385b0[_0xd4ca('0x1d')](_0xd4ca('0x1e'),_0x58fb14+'-'+_0x5ec1dc+'/'+_0xa60278)[_0xd4ca('0x18')](_0x230331);}return null;};}function patchUpdates(_0x5d9b33){return function(_0x3a7023){try{jsonpatch[_0xd4ca('0x1f')](_0x3a7023,_0x5d9b33,!![]);}catch(_0x5ab4e9){return BPromise['reject'](_0x5ab4e9);}return _0x3a7023[_0xd4ca('0x20')]();};}function saveUpdates(_0x4dac50,_0x2f73f5){return function(_0x31ea99){if(_0x31ea99){return _0x31ea99[_0xd4ca('0x21')](_0x4dac50)['then'](function(_0x37d12b){return _0x37d12b;});}return null;};}function removeEntity(_0xbb7f09,_0x45b86d){return function(_0x2364fe){if(_0x2364fe){return _0x2364fe['destroy']()[_0xd4ca('0x22')](function(){_0xbb7f09['status'](0xcc)[_0xd4ca('0x17')]();});}};}function handleEntityNotFound(_0x3f8a73,_0xf98d54){return function(_0x134636){if(!_0x134636){_0x3f8a73['sendStatus'](0x194);}return _0x134636;};}function handleError(_0x1191a4,_0x172d54){_0x172d54=_0x172d54||0x1f4;return function(_0x2f0243){logger[_0xd4ca('0x23')](_0x2f0243[_0xd4ca('0x24')]);if(_0x2f0243[_0xd4ca('0x25')]){delete _0x2f0243[_0xd4ca('0x25')];}_0x1191a4[_0xd4ca('0x16')](_0x172d54)['send'](_0x2f0243);};}exports[_0xd4ca('0x26')]=function(_0x3180ce,_0x2b3e93){var _0x4e2c9a={},_0x131a03={},_0x5e56d1={'count':0x0,'rows':[]};var _0x305d71=_['map'](db[_0xd4ca('0x27')][_0xd4ca('0x28')],function(_0x4d60d8){return{'name':_0x4d60d8[_0xd4ca('0x29')],'type':_0x4d60d8[_0xd4ca('0x2a')][_0xd4ca('0x2b')]};});_0x131a03[_0xd4ca('0x2c')]=_['map'](_0x305d71,_0xd4ca('0x25'));_0x131a03[_0xd4ca('0x2d')]=_[_0xd4ca('0x2e')](_0x3180ce[_0xd4ca('0x2d')]);_0x131a03[_0xd4ca('0x2f')]=_[_0xd4ca('0x30')](_0x131a03['model'],_0x131a03[_0xd4ca('0x2d')]);_0x4e2c9a['attributes']=_['intersection'](_0x131a03['model'],qs[_0xd4ca('0x31')](_0x3180ce['query'][_0xd4ca('0x31')]));_0x4e2c9a[_0xd4ca('0x32')]=_0x4e2c9a[_0xd4ca('0x32')][_0xd4ca('0x33')]?_0x4e2c9a['attributes']:_0x131a03['model'];if(!_0x3180ce['query']['hasOwnProperty']('nolimit')){_0x4e2c9a[_0xd4ca('0x1b')]=qs[_0xd4ca('0x1b')](_0x3180ce['query']['limit']);_0x4e2c9a[_0xd4ca('0x19')]=qs[_0xd4ca('0x19')](_0x3180ce[_0xd4ca('0x2d')][_0xd4ca('0x19')]);}_0x4e2c9a[_0xd4ca('0x34')]=qs[_0xd4ca('0x35')](_0x3180ce['query'][_0xd4ca('0x35')]);_0x4e2c9a[_0xd4ca('0x36')]=qs['filters'](_[_0xd4ca('0x37')](_0x3180ce[_0xd4ca('0x2d')],_0x131a03[_0xd4ca('0x2f')]),_0x305d71);if(_0x3180ce[_0xd4ca('0x2d')]['filter']){_0x4e2c9a['where']=_[_0xd4ca('0x38')](_0x4e2c9a[_0xd4ca('0x36')],{'$or':_[_0xd4ca('0x39')](_0x305d71,function(_0x4efb11){if(_0x4efb11[_0xd4ca('0x2a')]!==_0xd4ca('0x3a')){var _0x40b260={};_0x40b260[_0x4efb11['name']]={'$like':'%'+_0x3180ce[_0xd4ca('0x2d')]['filter']+'%'};return _0x40b260;}})});}_0x4e2c9a=_['merge']({},_0x4e2c9a,_0x3180ce[_0xd4ca('0x3b')]);var _0x487333={'where':_0x4e2c9a[_0xd4ca('0x36')]};return db[_0xd4ca('0x27')]['count'](_0x487333)[_0xd4ca('0x22')](function(_0x1701b4){_0x5e56d1[_0xd4ca('0x1c')]=_0x1701b4;if(_0x3180ce['query'][_0xd4ca('0x3c')]){_0x4e2c9a[_0xd4ca('0x3d')]=[{'all':!![]}];}return db[_0xd4ca('0x27')][_0xd4ca('0x3e')](_0x4e2c9a);})['then'](function(_0x174db5){_0x5e56d1[_0xd4ca('0x3f')]=_0x174db5;return _0x5e56d1;})[_0xd4ca('0x22')](respondWithFilteredResult(_0x2b3e93,_0x4e2c9a))[_0xd4ca('0x40')](handleError(_0x2b3e93,null));};exports[_0xd4ca('0x41')]=function(_0xf1f629,_0x3c08b1){var _0x40e2df={'raw':![],'where':{'id':_0xf1f629[_0xd4ca('0x42')]['id']}},_0x39e594={};_0x39e594['model']=_[_0xd4ca('0x2e')](db['VtigerConfiguration'][_0xd4ca('0x28')]);_0x39e594[_0xd4ca('0x2d')]=_[_0xd4ca('0x2e')](_0xf1f629['query']);_0x39e594[_0xd4ca('0x2f')]=_[_0xd4ca('0x30')](_0x39e594[_0xd4ca('0x2c')],_0x39e594['query']);_0x40e2df['attributes']=_[_0xd4ca('0x30')](_0x39e594[_0xd4ca('0x2c')],qs[_0xd4ca('0x31')](_0xf1f629['query']['fields']));_0x40e2df[_0xd4ca('0x32')]=_0x40e2df[_0xd4ca('0x32')]['length']?_0x40e2df[_0xd4ca('0x32')]:_0x39e594['model'];if(_0xf1f629[_0xd4ca('0x2d')][_0xd4ca('0x3c')]){_0x40e2df[_0xd4ca('0x3d')]=[{'all':!![]}];}_0x40e2df=_[_0xd4ca('0x38')]({},_0x40e2df,_0xf1f629[_0xd4ca('0x3b')]);return db[_0xd4ca('0x27')][_0xd4ca('0x43')](_0x40e2df)[_0xd4ca('0x22')](handleEntityNotFound(_0x3c08b1,null))[_0xd4ca('0x22')](respondWithResult(_0x3c08b1,null))[_0xd4ca('0x40')](handleError(_0x3c08b1,null));};exports[_0xd4ca('0x44')]=function(_0x5925cf,_0x5cd8e8){return db[_0xd4ca('0x27')][_0xd4ca('0x44')](_0x5925cf['body'],{})[_0xd4ca('0x22')](respondWithResult(_0x5cd8e8,0xc9))[_0xd4ca('0x40')](handleError(_0x5cd8e8,null));};exports[_0xd4ca('0x21')]=function(_0x27f36f,_0x25902c){if(_0x27f36f[_0xd4ca('0x45')]['id']){delete _0x27f36f['body']['id'];}return db['VtigerConfiguration'][_0xd4ca('0x43')]({'where':{'id':_0x27f36f['params']['id']}})[_0xd4ca('0x22')](handleEntityNotFound(_0x25902c,null))[_0xd4ca('0x22')](saveUpdates(_0x27f36f['body'],null))[_0xd4ca('0x22')](respondWithResult(_0x25902c,null))['catch'](handleError(_0x25902c,null));};exports['destroy']=function(_0x524ebb,_0x1547c4){return db['VtigerConfiguration'][_0xd4ca('0x43')]({'where':{'id':_0x524ebb['params']['id']}})[_0xd4ca('0x22')](handleEntityNotFound(_0x1547c4,null))[_0xd4ca('0x22')](removeEntity(_0x1547c4,null))[_0xd4ca('0x40')](handleError(_0x1547c4,null));};exports['getFields']=function(_0x566564,_0x8d081b,_0x2458e3){var _0x280641={};var _0x3c5337={};var _0x51b0ab;var _0x2ead44;return db[_0xd4ca('0x27')][_0xd4ca('0x46')]({'where':{'id':_0x566564['params']['id']}})[_0xd4ca('0x22')](handleEntityNotFound(_0x8d081b,null))['then'](function(_0x398042){if(_0x398042){_0x51b0ab=_0x398042;_0x3c5337[_0xd4ca('0x2c')]=_['keys'](db[_0xd4ca('0x47')][_0xd4ca('0x28')]);_0x3c5337[_0xd4ca('0x2d')]=_[_0xd4ca('0x2e')](_0x566564[_0xd4ca('0x2d')]);_0x3c5337[_0xd4ca('0x2f')]=_[_0xd4ca('0x30')](_0x3c5337[_0xd4ca('0x2c')],_0x3c5337[_0xd4ca('0x2d')]);_0x280641['attributes']=_['intersection'](_0x3c5337[_0xd4ca('0x2c')],qs[_0xd4ca('0x31')](_0x566564[_0xd4ca('0x2d')][_0xd4ca('0x31')]));_0x280641[_0xd4ca('0x32')]=_0x280641[_0xd4ca('0x32')]['length']?_0x280641[_0xd4ca('0x32')]:_0x3c5337[_0xd4ca('0x2c')];_0x280641['order']=qs['sort'](_0x566564['query'][_0xd4ca('0x35')]);_0x280641[_0xd4ca('0x36')]=qs[_0xd4ca('0x2f')](_[_0xd4ca('0x37')](_0x566564[_0xd4ca('0x2d')],_0x3c5337[_0xd4ca('0x2f')]));if(_0x566564[_0xd4ca('0x2d')]['filter']){_0x280641['where']=_[_0xd4ca('0x38')](_0x280641['where'],{'$or':_['map'](_0x280641[_0xd4ca('0x32')],function(_0x309227){var _0x2c2e79={};_0x2c2e79[_0x309227]={'$like':'%'+_0x566564[_0xd4ca('0x2d')][_0xd4ca('0x48')]+'%'};return _0x2c2e79;})});}_0x280641=_[_0xd4ca('0x38')]({},_0x280641,_0x566564['options']);return _0x51b0ab[_0xd4ca('0x49')](_0x280641);}})['then'](function(_0x468e9c){if(_0x468e9c){_0x2ead44=_0x468e9c['length'];if(!_0x566564[_0xd4ca('0x2d')]['hasOwnProperty'](_0xd4ca('0x4a'))){_0x280641['limit']=qs['limit'](_0x566564[_0xd4ca('0x2d')][_0xd4ca('0x1b')]);_0x280641[_0xd4ca('0x19')]=qs[_0xd4ca('0x19')](_0x566564[_0xd4ca('0x2d')][_0xd4ca('0x19')]);}return _0x51b0ab[_0xd4ca('0x49')](_0x280641);}})[_0xd4ca('0x22')](function(_0x3da995){if(_0x3da995){return _0x3da995?{'count':_0x2ead44,'rows':_0x3da995}:null;}})[_0xd4ca('0x22')](respondWithResult(_0x8d081b,null))[_0xd4ca('0x40')](handleError(_0x8d081b,null));};exports[_0xd4ca('0x4b')]=function(_0x4406af,_0x2f824,_0x52aabe){var _0x5ab573={};var _0x56e076={};var _0x143b68;var _0x2573b2;return db[_0xd4ca('0x27')][_0xd4ca('0x46')]({'where':{'id':_0x4406af[_0xd4ca('0x42')]['id']}})[_0xd4ca('0x22')](handleEntityNotFound(_0x2f824,null))[_0xd4ca('0x22')](function(_0x192d71){if(_0x192d71){_0x143b68=_0x192d71;_0x56e076[_0xd4ca('0x2c')]=_[_0xd4ca('0x2e')](db[_0xd4ca('0x47')]['rawAttributes']);_0x56e076[_0xd4ca('0x2d')]=_['keys'](_0x4406af[_0xd4ca('0x2d')]);_0x56e076[_0xd4ca('0x2f')]=_[_0xd4ca('0x30')](_0x56e076[_0xd4ca('0x2c')],_0x56e076['query']);_0x5ab573['attributes']=_[_0xd4ca('0x30')](_0x56e076['model'],qs[_0xd4ca('0x31')](_0x4406af[_0xd4ca('0x2d')][_0xd4ca('0x31')]));_0x5ab573['attributes']=_0x5ab573[_0xd4ca('0x32')][_0xd4ca('0x33')]?_0x5ab573[_0xd4ca('0x32')]:_0x56e076[_0xd4ca('0x2c')];_0x5ab573[_0xd4ca('0x34')]=qs[_0xd4ca('0x35')](_0x4406af[_0xd4ca('0x2d')][_0xd4ca('0x35')]);_0x5ab573[_0xd4ca('0x36')]=qs[_0xd4ca('0x2f')](_['pick'](_0x4406af[_0xd4ca('0x2d')],_0x56e076[_0xd4ca('0x2f')]));if(_0x4406af[_0xd4ca('0x2d')]['filter']){_0x5ab573[_0xd4ca('0x36')]=_[_0xd4ca('0x38')](_0x5ab573[_0xd4ca('0x36')],{'$or':_['map'](_0x5ab573[_0xd4ca('0x32')],function(_0x4443ca){var _0x1db681={};_0x1db681[_0x4443ca]={'$like':'%'+_0x4406af[_0xd4ca('0x2d')][_0xd4ca('0x48')]+'%'};return _0x1db681;})});}_0x5ab573=_[_0xd4ca('0x38')]({},_0x5ab573,_0x4406af['options']);return _0x143b68[_0xd4ca('0x4b')](_0x5ab573);}})['then'](function(_0x113059){if(_0x113059){_0x2573b2=_0x113059[_0xd4ca('0x33')];if(!_0x4406af['query'][_0xd4ca('0x4c')](_0xd4ca('0x4a'))){_0x5ab573[_0xd4ca('0x1b')]=qs[_0xd4ca('0x1b')](_0x4406af[_0xd4ca('0x2d')]['limit']);_0x5ab573['offset']=qs[_0xd4ca('0x19')](_0x4406af['query'][_0xd4ca('0x19')]);}return _0x143b68[_0xd4ca('0x4b')](_0x5ab573);}})['then'](function(_0x25d9c9){if(_0x25d9c9){return _0x25d9c9?{'count':_0x2573b2,'rows':_0x25d9c9}:null;}})[_0xd4ca('0x22')](respondWithResult(_0x2f824,null))[_0xd4ca('0x40')](handleError(_0x2f824,null));};exports['getDescriptions']=function(_0xee449f,_0x1e927f,_0x25c37f){var _0x5129f1={};var _0x55a765={};var _0x1f6307;var _0x495a0c;return db['VtigerConfiguration'][_0xd4ca('0x46')]({'where':{'id':_0xee449f[_0xd4ca('0x42')]['id']}})['then'](handleEntityNotFound(_0x1e927f,null))[_0xd4ca('0x22')](function(_0x5793ae){if(_0x5793ae){_0x1f6307=_0x5793ae;_0x55a765[_0xd4ca('0x2c')]=_[_0xd4ca('0x2e')](db[_0xd4ca('0x47')][_0xd4ca('0x28')]);_0x55a765[_0xd4ca('0x2d')]=_['keys'](_0xee449f[_0xd4ca('0x2d')]);_0x55a765['filters']=_[_0xd4ca('0x30')](_0x55a765[_0xd4ca('0x2c')],_0x55a765[_0xd4ca('0x2d')]);_0x5129f1[_0xd4ca('0x32')]=_[_0xd4ca('0x30')](_0x55a765[_0xd4ca('0x2c')],qs['fields'](_0xee449f['query'][_0xd4ca('0x31')]));_0x5129f1['attributes']=_0x5129f1['attributes'][_0xd4ca('0x33')]?_0x5129f1[_0xd4ca('0x32')]:_0x55a765['model'];_0x5129f1['order']=qs[_0xd4ca('0x35')](_0xee449f[_0xd4ca('0x2d')][_0xd4ca('0x35')]);_0x5129f1['where']=qs['filters'](_[_0xd4ca('0x37')](_0xee449f[_0xd4ca('0x2d')],_0x55a765['filters']));if(_0xee449f[_0xd4ca('0x2d')][_0xd4ca('0x48')]){_0x5129f1[_0xd4ca('0x36')]=_['merge'](_0x5129f1['where'],{'$or':_['map'](_0x5129f1[_0xd4ca('0x32')],function(_0x5b2b87){var _0x5617ab={};_0x5617ab[_0x5b2b87]={'$like':'%'+_0xee449f[_0xd4ca('0x2d')]['filter']+'%'};return _0x5617ab;})});}_0x5129f1=_[_0xd4ca('0x38')]({},_0x5129f1,_0xee449f['options']);return _0x1f6307['getDescriptions'](_0x5129f1);}})['then'](function(_0x3f6b2c){if(_0x3f6b2c){_0x495a0c=_0x3f6b2c[_0xd4ca('0x33')];if(!_0xee449f[_0xd4ca('0x2d')]['hasOwnProperty']('nolimit')){_0x5129f1['limit']=qs[_0xd4ca('0x1b')](_0xee449f['query']['limit']);_0x5129f1['offset']=qs[_0xd4ca('0x19')](_0xee449f[_0xd4ca('0x2d')][_0xd4ca('0x19')]);}return _0x1f6307[_0xd4ca('0x4d')](_0x5129f1);}})[_0xd4ca('0x22')](function(_0x126fc9){if(_0x126fc9){return _0x126fc9?{'count':_0x495a0c,'rows':_0x126fc9}:null;}})[_0xd4ca('0x22')](respondWithResult(_0x1e927f,null))[_0xd4ca('0x40')](handleError(_0x1e927f,null));};