Built motion from commit 9d0783e6.|2.6.13
[motion2.git] / server / api / intSugarcrmConfiguration / intSugarcrmConfiguration.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 _0xe0db=['../../components/parsers/qs','../../config/license/hardware','api','../../config/utils','../../config/license/util','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','update','then','destroy','error','stack','name','send','index','map','rawAttributes','type','key','query','keys','filters','intersection','model','fields','attributes','length','order','sort','where','pick','VIRTUAL','options','SugarcrmConfiguration','includeAll','include','findAll','rows','catch','show','params','find','create','body','getFields','SugarcrmField','filter','merge','hasOwnProperty','getSubjects','findOne','nolimit','getDescriptions','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','path','sox','to-csv','ejs','fs-extra','lodash','jsforce','querystring','papaparse','ioredis','../../components/auth/service'];(function(_0x587fb5,_0x59cb3b){var _0x551105=function(_0x5bbef4){while(--_0x5bbef4){_0x587fb5['push'](_0x587fb5['shift']());}};_0x551105(++_0x59cb3b);}(_0xe0db,0xe1));var _0xbe0d=function(_0x58dc25,_0x49b9d5){_0x58dc25=_0x58dc25-0x0;var _0x21b0a7=_0xe0db[_0x58dc25];return _0x21b0a7;};'use strict';var emlformat=require(_0xbe0d('0x0'));var rimraf=require(_0xbe0d('0x1'));var zipdir=require(_0xbe0d('0x2'));var jsonpatch=require(_0xbe0d('0x3'));var rp=require('request-promise');var moment=require(_0xbe0d('0x4'));var BPromise=require(_0xbe0d('0x5'));var Mustache=require(_0xbe0d('0x6'));var util=require('util');var path=require(_0xbe0d('0x7'));var sox=require(_0xbe0d('0x8'));var csv=require(_0xbe0d('0x9'));var ejs=require(_0xbe0d('0xa'));var fs=require('fs');var fs_extra=require(_0xbe0d('0xb'));var _=require(_0xbe0d('0xc'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0xbe0d('0xd'));var deskjs=require('desk.js');var toCsv=require(_0xbe0d('0x9'));var querystring=require(_0xbe0d('0xe'));var Papa=require(_0xbe0d('0xf'));var Redis=require(_0xbe0d('0x10'));var authService=require(_0xbe0d('0x11'));var qs=require(_0xbe0d('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xbe0d('0x13'));var logger=require('../../config/logger')(_0xbe0d('0x14'));var utils=require(_0xbe0d('0x15'));var config=require('../../config/environment');var licenseUtil=require(_0xbe0d('0x16'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x3bdfa,_0x1344ff){_0x1344ff=_0x1344ff||0xcc;return function(_0x4556c0){if(_0x4556c0){return _0x3bdfa[_0xbe0d('0x17')](_0x1344ff);}return _0x3bdfa[_0xbe0d('0x18')](_0x1344ff)[_0xbe0d('0x19')]();};}function respondWithResult(_0x2d8c41,_0x43e823){_0x43e823=_0x43e823||0xc8;return function(_0x5786ba){if(_0x5786ba){return _0x2d8c41[_0xbe0d('0x18')](_0x43e823)[_0xbe0d('0x1a')](_0x5786ba);}};}function respondWithFilteredResult(_0x2849ed,_0x7a0aca){return function(_0x18becc){if(_0x18becc){var _0x3cd50b=typeof _0x7a0aca[_0xbe0d('0x1b')]===_0xbe0d('0x1c')&&typeof _0x7a0aca[_0xbe0d('0x1d')]===_0xbe0d('0x1c');var _0x3eaa1e=_0x18becc[_0xbe0d('0x1e')];var _0x4cdc30=_0x3cd50b?0x0:_0x7a0aca[_0xbe0d('0x1b')];var _0xe195da=_0x3cd50b?_0x18becc[_0xbe0d('0x1e')]:_0x7a0aca[_0xbe0d('0x1b')]+_0x7a0aca[_0xbe0d('0x1d')];var _0x320650;if(_0xe195da>=_0x3eaa1e){_0xe195da=_0x3eaa1e;_0x320650=0xc8;}else{_0x320650=0xce;}_0x2849ed['status'](_0x320650);return _0x2849ed[_0xbe0d('0x1f')](_0xbe0d('0x20'),_0x4cdc30+'-'+_0xe195da+'/'+_0x3eaa1e)[_0xbe0d('0x1a')](_0x18becc);}return null;};}function patchUpdates(_0x172c55){return function(_0x290689){try{jsonpatch[_0xbe0d('0x21')](_0x290689,_0x172c55,!![]);}catch(_0x217367){return BPromise[_0xbe0d('0x22')](_0x217367);}return _0x290689['save']();};}function saveUpdates(_0x379617,_0x5a78e1){return function(_0x416208){if(_0x416208){return _0x416208[_0xbe0d('0x23')](_0x379617)[_0xbe0d('0x24')](function(_0x6f51c4){return _0x6f51c4;});}return null;};}function removeEntity(_0x440402,_0x3a2e21){return function(_0x4f1f0b){if(_0x4f1f0b){return _0x4f1f0b[_0xbe0d('0x25')]()[_0xbe0d('0x24')](function(){_0x440402['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x3928ae,_0x4b0da1){return function(_0x540d85){if(!_0x540d85){_0x3928ae['sendStatus'](0x194);}return _0x540d85;};}function handleError(_0x15868d,_0x3af25f){_0x3af25f=_0x3af25f||0x1f4;return function(_0x1d24bf){logger[_0xbe0d('0x26')](_0x1d24bf[_0xbe0d('0x27')]);if(_0x1d24bf[_0xbe0d('0x28')]){delete _0x1d24bf[_0xbe0d('0x28')];}_0x15868d[_0xbe0d('0x18')](_0x3af25f)[_0xbe0d('0x29')](_0x1d24bf);};}exports[_0xbe0d('0x2a')]=function(_0x1d62ba,_0xb739ba){var _0x4889c4={},_0x1c33d2={},_0x57ccd8={'count':0x0,'rows':[]};var _0x27dce1=_[_0xbe0d('0x2b')](db['SugarcrmConfiguration'][_0xbe0d('0x2c')],function(_0xbdc0dc){return{'name':_0xbdc0dc['fieldName'],'type':_0xbdc0dc[_0xbe0d('0x2d')][_0xbe0d('0x2e')]};});_0x1c33d2['model']=_[_0xbe0d('0x2b')](_0x27dce1,'name');_0x1c33d2[_0xbe0d('0x2f')]=_[_0xbe0d('0x30')](_0x1d62ba['query']);_0x1c33d2[_0xbe0d('0x31')]=_[_0xbe0d('0x32')](_0x1c33d2[_0xbe0d('0x33')],_0x1c33d2[_0xbe0d('0x2f')]);_0x4889c4['attributes']=_[_0xbe0d('0x32')](_0x1c33d2['model'],qs[_0xbe0d('0x34')](_0x1d62ba[_0xbe0d('0x2f')][_0xbe0d('0x34')]));_0x4889c4[_0xbe0d('0x35')]=_0x4889c4['attributes'][_0xbe0d('0x36')]?_0x4889c4[_0xbe0d('0x35')]:_0x1c33d2[_0xbe0d('0x33')];if(!_0x1d62ba[_0xbe0d('0x2f')]['hasOwnProperty']('nolimit')){_0x4889c4[_0xbe0d('0x1d')]=qs['limit'](_0x1d62ba[_0xbe0d('0x2f')]['limit']);_0x4889c4[_0xbe0d('0x1b')]=qs['offset'](_0x1d62ba[_0xbe0d('0x2f')]['offset']);}_0x4889c4[_0xbe0d('0x37')]=qs[_0xbe0d('0x38')](_0x1d62ba[_0xbe0d('0x2f')]['sort']);_0x4889c4[_0xbe0d('0x39')]=qs[_0xbe0d('0x31')](_[_0xbe0d('0x3a')](_0x1d62ba['query'],_0x1c33d2['filters']),_0x27dce1);if(_0x1d62ba['query']['filter']){_0x4889c4[_0xbe0d('0x39')]=_['merge'](_0x4889c4[_0xbe0d('0x39')],{'$or':_['map'](_0x27dce1,function(_0x16498d){if(_0x16498d[_0xbe0d('0x2d')]!==_0xbe0d('0x3b')){var _0x54f96d={};_0x54f96d[_0x16498d[_0xbe0d('0x28')]]={'$like':'%'+_0x1d62ba['query']['filter']+'%'};return _0x54f96d;}})});}_0x4889c4=_['merge']({},_0x4889c4,_0x1d62ba[_0xbe0d('0x3c')]);var _0x1de34f={'where':_0x4889c4[_0xbe0d('0x39')]};return db[_0xbe0d('0x3d')][_0xbe0d('0x1e')](_0x1de34f)[_0xbe0d('0x24')](function(_0x20cc70){_0x57ccd8[_0xbe0d('0x1e')]=_0x20cc70;if(_0x1d62ba[_0xbe0d('0x2f')][_0xbe0d('0x3e')]){_0x4889c4[_0xbe0d('0x3f')]=[{'all':!![]}];}return db[_0xbe0d('0x3d')][_0xbe0d('0x40')](_0x4889c4);})['then'](function(_0x533f03){_0x57ccd8[_0xbe0d('0x41')]=_0x533f03;return _0x57ccd8;})[_0xbe0d('0x24')](respondWithFilteredResult(_0xb739ba,_0x4889c4))[_0xbe0d('0x42')](handleError(_0xb739ba,null));};exports[_0xbe0d('0x43')]=function(_0x6f173d,_0x11f044){var _0x4c9da0={'raw':![],'where':{'id':_0x6f173d[_0xbe0d('0x44')]['id']}},_0x2074e4={};_0x2074e4['model']=_[_0xbe0d('0x30')](db['SugarcrmConfiguration'][_0xbe0d('0x2c')]);_0x2074e4[_0xbe0d('0x2f')]=_[_0xbe0d('0x30')](_0x6f173d[_0xbe0d('0x2f')]);_0x2074e4['filters']=_[_0xbe0d('0x32')](_0x2074e4['model'],_0x2074e4['query']);_0x4c9da0[_0xbe0d('0x35')]=_[_0xbe0d('0x32')](_0x2074e4['model'],qs[_0xbe0d('0x34')](_0x6f173d[_0xbe0d('0x2f')]['fields']));_0x4c9da0[_0xbe0d('0x35')]=_0x4c9da0[_0xbe0d('0x35')]['length']?_0x4c9da0[_0xbe0d('0x35')]:_0x2074e4['model'];if(_0x6f173d[_0xbe0d('0x2f')][_0xbe0d('0x3e')]){_0x4c9da0['include']=[{'all':!![]}];}_0x4c9da0=_['merge']({},_0x4c9da0,_0x6f173d[_0xbe0d('0x3c')]);return db[_0xbe0d('0x3d')][_0xbe0d('0x45')](_0x4c9da0)[_0xbe0d('0x24')](handleEntityNotFound(_0x11f044,null))[_0xbe0d('0x24')](respondWithResult(_0x11f044,null))[_0xbe0d('0x42')](handleError(_0x11f044,null));};exports[_0xbe0d('0x46')]=function(_0x25ab24,_0x146620){return db[_0xbe0d('0x3d')][_0xbe0d('0x46')](_0x25ab24[_0xbe0d('0x47')],{})[_0xbe0d('0x24')](respondWithResult(_0x146620,0xc9))['catch'](handleError(_0x146620,null));};exports['update']=function(_0x544bf9,_0x4986d0){if(_0x544bf9[_0xbe0d('0x47')]['id']){delete _0x544bf9[_0xbe0d('0x47')]['id'];}return db[_0xbe0d('0x3d')]['find']({'where':{'id':_0x544bf9['params']['id']}})[_0xbe0d('0x24')](handleEntityNotFound(_0x4986d0,null))['then'](saveUpdates(_0x544bf9[_0xbe0d('0x47')],null))['then'](respondWithResult(_0x4986d0,null))[_0xbe0d('0x42')](handleError(_0x4986d0,null));};exports['destroy']=function(_0x172c7b,_0x55d25e){return db[_0xbe0d('0x3d')][_0xbe0d('0x45')]({'where':{'id':_0x172c7b['params']['id']}})['then'](handleEntityNotFound(_0x55d25e,null))[_0xbe0d('0x24')](removeEntity(_0x55d25e,null))[_0xbe0d('0x42')](handleError(_0x55d25e,null));};exports[_0xbe0d('0x48')]=function(_0x244b86,_0x2073d4,_0x45cdea){var _0x22d372={};var _0x24c354={};var _0x35141f;var _0x567026;return db[_0xbe0d('0x3d')]['findOne']({'where':{'id':_0x244b86[_0xbe0d('0x44')]['id']}})[_0xbe0d('0x24')](handleEntityNotFound(_0x2073d4,null))[_0xbe0d('0x24')](function(_0x5e01ae){if(_0x5e01ae){_0x35141f=_0x5e01ae;_0x24c354[_0xbe0d('0x33')]=_[_0xbe0d('0x30')](db[_0xbe0d('0x49')][_0xbe0d('0x2c')]);_0x24c354[_0xbe0d('0x2f')]=_[_0xbe0d('0x30')](_0x244b86['query']);_0x24c354[_0xbe0d('0x31')]=_[_0xbe0d('0x32')](_0x24c354[_0xbe0d('0x33')],_0x24c354['query']);_0x22d372['attributes']=_[_0xbe0d('0x32')](_0x24c354['model'],qs[_0xbe0d('0x34')](_0x244b86[_0xbe0d('0x2f')][_0xbe0d('0x34')]));_0x22d372[_0xbe0d('0x35')]=_0x22d372[_0xbe0d('0x35')][_0xbe0d('0x36')]?_0x22d372[_0xbe0d('0x35')]:_0x24c354['model'];_0x22d372[_0xbe0d('0x37')]=qs[_0xbe0d('0x38')](_0x244b86['query'][_0xbe0d('0x38')]);_0x22d372[_0xbe0d('0x39')]=qs[_0xbe0d('0x31')](_[_0xbe0d('0x3a')](_0x244b86[_0xbe0d('0x2f')],_0x24c354[_0xbe0d('0x31')]));if(_0x244b86[_0xbe0d('0x2f')][_0xbe0d('0x4a')]){_0x22d372[_0xbe0d('0x39')]=_[_0xbe0d('0x4b')](_0x22d372[_0xbe0d('0x39')],{'$or':_[_0xbe0d('0x2b')](_0x22d372[_0xbe0d('0x35')],function(_0x7d03d5){var _0x2d8ddc={};_0x2d8ddc[_0x7d03d5]={'$like':'%'+_0x244b86[_0xbe0d('0x2f')][_0xbe0d('0x4a')]+'%'};return _0x2d8ddc;})});}_0x22d372=_[_0xbe0d('0x4b')]({},_0x22d372,_0x244b86[_0xbe0d('0x3c')]);return _0x35141f['getFields'](_0x22d372);}})[_0xbe0d('0x24')](function(_0xcf6f99){if(_0xcf6f99){_0x567026=_0xcf6f99['length'];if(!_0x244b86['query'][_0xbe0d('0x4c')]('nolimit')){_0x22d372['limit']=qs['limit'](_0x244b86[_0xbe0d('0x2f')][_0xbe0d('0x1d')]);_0x22d372[_0xbe0d('0x1b')]=qs['offset'](_0x244b86[_0xbe0d('0x2f')][_0xbe0d('0x1b')]);}return _0x35141f[_0xbe0d('0x48')](_0x22d372);}})['then'](function(_0x2d5c66){if(_0x2d5c66){return _0x2d5c66?{'count':_0x567026,'rows':_0x2d5c66}:null;}})['then'](respondWithResult(_0x2073d4,null))[_0xbe0d('0x42')](handleError(_0x2073d4,null));};exports[_0xbe0d('0x4d')]=function(_0x4c5a60,_0x237c8e,_0x5ba372){var _0x2482af={};var _0x3fba18={};var _0x5de554;var _0x1e3799;return db[_0xbe0d('0x3d')][_0xbe0d('0x4e')]({'where':{'id':_0x4c5a60[_0xbe0d('0x44')]['id']}})[_0xbe0d('0x24')](handleEntityNotFound(_0x237c8e,null))['then'](function(_0x12f1af){if(_0x12f1af){_0x5de554=_0x12f1af;_0x3fba18[_0xbe0d('0x33')]=_[_0xbe0d('0x30')](db[_0xbe0d('0x49')][_0xbe0d('0x2c')]);_0x3fba18[_0xbe0d('0x2f')]=_['keys'](_0x4c5a60[_0xbe0d('0x2f')]);_0x3fba18['filters']=_[_0xbe0d('0x32')](_0x3fba18['model'],_0x3fba18['query']);_0x2482af[_0xbe0d('0x35')]=_[_0xbe0d('0x32')](_0x3fba18['model'],qs[_0xbe0d('0x34')](_0x4c5a60['query'][_0xbe0d('0x34')]));_0x2482af[_0xbe0d('0x35')]=_0x2482af[_0xbe0d('0x35')][_0xbe0d('0x36')]?_0x2482af[_0xbe0d('0x35')]:_0x3fba18[_0xbe0d('0x33')];_0x2482af[_0xbe0d('0x37')]=qs[_0xbe0d('0x38')](_0x4c5a60['query'][_0xbe0d('0x38')]);_0x2482af[_0xbe0d('0x39')]=qs[_0xbe0d('0x31')](_['pick'](_0x4c5a60[_0xbe0d('0x2f')],_0x3fba18['filters']));if(_0x4c5a60['query']['filter']){_0x2482af[_0xbe0d('0x39')]=_[_0xbe0d('0x4b')](_0x2482af[_0xbe0d('0x39')],{'$or':_['map'](_0x2482af[_0xbe0d('0x35')],function(_0x4035db){var _0x48ed48={};_0x48ed48[_0x4035db]={'$like':'%'+_0x4c5a60[_0xbe0d('0x2f')][_0xbe0d('0x4a')]+'%'};return _0x48ed48;})});}_0x2482af=_[_0xbe0d('0x4b')]({},_0x2482af,_0x4c5a60['options']);return _0x5de554[_0xbe0d('0x4d')](_0x2482af);}})[_0xbe0d('0x24')](function(_0x2f0cf1){if(_0x2f0cf1){_0x1e3799=_0x2f0cf1[_0xbe0d('0x36')];if(!_0x4c5a60['query'][_0xbe0d('0x4c')](_0xbe0d('0x4f'))){_0x2482af[_0xbe0d('0x1d')]=qs[_0xbe0d('0x1d')](_0x4c5a60['query'][_0xbe0d('0x1d')]);_0x2482af['offset']=qs[_0xbe0d('0x1b')](_0x4c5a60[_0xbe0d('0x2f')]['offset']);}return _0x5de554[_0xbe0d('0x4d')](_0x2482af);}})['then'](function(_0x3c35ee){if(_0x3c35ee){return _0x3c35ee?{'count':_0x1e3799,'rows':_0x3c35ee}:null;}})[_0xbe0d('0x24')](respondWithResult(_0x237c8e,null))['catch'](handleError(_0x237c8e,null));};exports['getDescriptions']=function(_0x4821fd,_0x26964c,_0x2602bc){var _0x5af110={};var _0x5e49d7={};var _0x3f86e1;var _0x565595;return db[_0xbe0d('0x3d')][_0xbe0d('0x4e')]({'where':{'id':_0x4821fd[_0xbe0d('0x44')]['id']}})[_0xbe0d('0x24')](handleEntityNotFound(_0x26964c,null))[_0xbe0d('0x24')](function(_0x172ef8){if(_0x172ef8){_0x3f86e1=_0x172ef8;_0x5e49d7['model']=_[_0xbe0d('0x30')](db[_0xbe0d('0x49')][_0xbe0d('0x2c')]);_0x5e49d7[_0xbe0d('0x2f')]=_[_0xbe0d('0x30')](_0x4821fd[_0xbe0d('0x2f')]);_0x5e49d7[_0xbe0d('0x31')]=_[_0xbe0d('0x32')](_0x5e49d7[_0xbe0d('0x33')],_0x5e49d7[_0xbe0d('0x2f')]);_0x5af110['attributes']=_[_0xbe0d('0x32')](_0x5e49d7[_0xbe0d('0x33')],qs[_0xbe0d('0x34')](_0x4821fd['query'][_0xbe0d('0x34')]));_0x5af110[_0xbe0d('0x35')]=_0x5af110['attributes']['length']?_0x5af110['attributes']:_0x5e49d7[_0xbe0d('0x33')];_0x5af110[_0xbe0d('0x37')]=qs[_0xbe0d('0x38')](_0x4821fd[_0xbe0d('0x2f')][_0xbe0d('0x38')]);_0x5af110[_0xbe0d('0x39')]=qs[_0xbe0d('0x31')](_[_0xbe0d('0x3a')](_0x4821fd[_0xbe0d('0x2f')],_0x5e49d7['filters']));if(_0x4821fd[_0xbe0d('0x2f')][_0xbe0d('0x4a')]){_0x5af110['where']=_['merge'](_0x5af110[_0xbe0d('0x39')],{'$or':_[_0xbe0d('0x2b')](_0x5af110[_0xbe0d('0x35')],function(_0x4c2cfb){var _0x52fa90={};_0x52fa90[_0x4c2cfb]={'$like':'%'+_0x4821fd[_0xbe0d('0x2f')][_0xbe0d('0x4a')]+'%'};return _0x52fa90;})});}_0x5af110=_[_0xbe0d('0x4b')]({},_0x5af110,_0x4821fd[_0xbe0d('0x3c')]);return _0x3f86e1[_0xbe0d('0x50')](_0x5af110);}})[_0xbe0d('0x24')](function(_0x358970){if(_0x358970){_0x565595=_0x358970['length'];if(!_0x4821fd['query'][_0xbe0d('0x4c')](_0xbe0d('0x4f'))){_0x5af110[_0xbe0d('0x1d')]=qs[_0xbe0d('0x1d')](_0x4821fd['query'][_0xbe0d('0x1d')]);_0x5af110[_0xbe0d('0x1b')]=qs[_0xbe0d('0x1b')](_0x4821fd[_0xbe0d('0x2f')][_0xbe0d('0x1b')]);}return _0x3f86e1[_0xbe0d('0x50')](_0x5af110);}})['then'](function(_0x5812e9){if(_0x5812e9){return _0x5812e9?{'count':_0x565595,'rows':_0x5812e9}:null;}})['then'](respondWithResult(_0x26964c,null))[_0xbe0d('0x42')](handleError(_0x26964c,null));};