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 _0x84c5=['rows','show','params','include','options','find','catch','create','body','destroy','getFields','SugarcrmField','length','nolimit','getSubjects','findOne','pick','hasOwnProperty','getDescriptions','eml-format','zip-dir','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','fs-extra','lodash','squel','crypto','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','save','update','then','error','stack','send','index','map','SugarcrmConfiguration','rawAttributes','fieldName','type','key','model','name','query','keys','filters','intersection','attributes','fields','order','sort','where','merge','VIRTUAL','filter','includeAll','findAll'];(function(_0x5e9fdb,_0xa09eeb){var _0x1ebf70=function(_0x211ba0){while(--_0x211ba0){_0x5e9fdb['push'](_0x5e9fdb['shift']());}};_0x1ebf70(++_0xa09eeb);}(_0x84c5,0x112));var _0x584c=function(_0x17eb14,_0x214eb2){_0x17eb14=_0x17eb14-0x0;var _0x261011=_0x84c5[_0x17eb14];return _0x261011;};'use strict';var emlformat=require(_0x584c('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x584c('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0x584c('0x2'));var moment=require(_0x584c('0x3'));var BPromise=require(_0x584c('0x4'));var Mustache=require(_0x584c('0x5'));var util=require(_0x584c('0x6'));var path=require(_0x584c('0x7'));var sox=require('sox');var csv=require(_0x584c('0x8'));var ejs=require(_0x584c('0x9'));var fs=require('fs');var fs_extra=require(_0x584c('0xa'));var _=require(_0x584c('0xb'));var squel=require(_0x584c('0xc'));var crypto=require(_0x584c('0xd'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0x584c('0xe'));var Papa=require(_0x584c('0xf'));var Redis=require(_0x584c('0x10'));var authService=require('../../components/auth/service');var qs=require(_0x584c('0x11'));var as=require(_0x584c('0x12'));var hardwareService=require(_0x584c('0x13'));var logger=require(_0x584c('0x14'))(_0x584c('0x15'));var utils=require(_0x584c('0x16'));var config=require(_0x584c('0x17'));var licenseUtil=require(_0x584c('0x18'));var db=require(_0x584c('0x19'))['db'];function respondWithStatusCode(_0x56b1eb,_0x5dc8fc){_0x5dc8fc=_0x5dc8fc||0xcc;return function(_0xc97583){if(_0xc97583){return _0x56b1eb[_0x584c('0x1a')](_0x5dc8fc);}return _0x56b1eb[_0x584c('0x1b')](_0x5dc8fc)[_0x584c('0x1c')]();};}function respondWithResult(_0x4c2eb2,_0x79a031){_0x79a031=_0x79a031||0xc8;return function(_0x3f7472){if(_0x3f7472){return _0x4c2eb2[_0x584c('0x1b')](_0x79a031)[_0x584c('0x1d')](_0x3f7472);}};}function respondWithFilteredResult(_0x19aa44,_0x5831c1){return function(_0x89e8c1){if(_0x89e8c1){var _0x196ca9=typeof _0x5831c1[_0x584c('0x1e')]===_0x584c('0x1f')&&typeof _0x5831c1[_0x584c('0x20')]===_0x584c('0x1f');var _0x3dc2e7=_0x89e8c1[_0x584c('0x21')];var _0x3b870c=_0x196ca9?0x0:_0x5831c1[_0x584c('0x1e')];var _0x34a98a=_0x196ca9?_0x89e8c1[_0x584c('0x21')]:_0x5831c1['offset']+_0x5831c1[_0x584c('0x20')];var _0x57ae34;if(_0x34a98a>=_0x3dc2e7){_0x34a98a=_0x3dc2e7;_0x57ae34=0xc8;}else{_0x57ae34=0xce;}_0x19aa44[_0x584c('0x1b')](_0x57ae34);return _0x19aa44[_0x584c('0x22')](_0x584c('0x23'),_0x3b870c+'-'+_0x34a98a+'/'+_0x3dc2e7)[_0x584c('0x1d')](_0x89e8c1);}return null;};}function patchUpdates(_0x5b687f){return function(_0x36cfe5){try{jsonpatch[_0x584c('0x24')](_0x36cfe5,_0x5b687f,!![]);}catch(_0x590fdf){return BPromise['reject'](_0x590fdf);}return _0x36cfe5[_0x584c('0x25')]();};}function saveUpdates(_0x524cd1,_0x46f8dc){return function(_0x103ad6){if(_0x103ad6){return _0x103ad6[_0x584c('0x26')](_0x524cd1)[_0x584c('0x27')](function(_0x2c4137){return _0x2c4137;});}return null;};}function removeEntity(_0x19e353,_0x41fdab){return function(_0x34e23a){if(_0x34e23a){return _0x34e23a['destroy']()[_0x584c('0x27')](function(){_0x19e353['status'](0xcc)[_0x584c('0x1c')]();});}};}function handleEntityNotFound(_0x30a0e4,_0x776689){return function(_0x32706c){if(!_0x32706c){_0x30a0e4['sendStatus'](0x194);}return _0x32706c;};}function handleError(_0x56f05,_0xe6bd94){_0xe6bd94=_0xe6bd94||0x1f4;return function(_0x25c02f){logger[_0x584c('0x28')](_0x25c02f[_0x584c('0x29')]);if(_0x25c02f['name']){delete _0x25c02f['name'];}_0x56f05['status'](_0xe6bd94)[_0x584c('0x2a')](_0x25c02f);};}exports[_0x584c('0x2b')]=function(_0x4150bd,_0x17094a){var _0x169492={},_0x5b1997={},_0x1c11d4={'count':0x0,'rows':[]};var _0x21d1bf=_[_0x584c('0x2c')](db[_0x584c('0x2d')][_0x584c('0x2e')],function(_0x2c362e){return{'name':_0x2c362e[_0x584c('0x2f')],'type':_0x2c362e[_0x584c('0x30')][_0x584c('0x31')]};});_0x5b1997[_0x584c('0x32')]=_[_0x584c('0x2c')](_0x21d1bf,_0x584c('0x33'));_0x5b1997[_0x584c('0x34')]=_[_0x584c('0x35')](_0x4150bd['query']);_0x5b1997[_0x584c('0x36')]=_[_0x584c('0x37')](_0x5b1997[_0x584c('0x32')],_0x5b1997[_0x584c('0x34')]);_0x169492[_0x584c('0x38')]=_['intersection'](_0x5b1997[_0x584c('0x32')],qs[_0x584c('0x39')](_0x4150bd['query'][_0x584c('0x39')]));_0x169492[_0x584c('0x38')]=_0x169492['attributes']['length']?_0x169492[_0x584c('0x38')]:_0x5b1997[_0x584c('0x32')];if(!_0x4150bd['query']['hasOwnProperty']('nolimit')){_0x169492[_0x584c('0x20')]=qs[_0x584c('0x20')](_0x4150bd[_0x584c('0x34')][_0x584c('0x20')]);_0x169492[_0x584c('0x1e')]=qs[_0x584c('0x1e')](_0x4150bd[_0x584c('0x34')][_0x584c('0x1e')]);}_0x169492[_0x584c('0x3a')]=qs[_0x584c('0x3b')](_0x4150bd[_0x584c('0x34')][_0x584c('0x3b')]);_0x169492[_0x584c('0x3c')]=qs[_0x584c('0x36')](_['pick'](_0x4150bd['query'],_0x5b1997[_0x584c('0x36')]),_0x21d1bf);if(_0x4150bd[_0x584c('0x34')]['filter']){_0x169492['where']=_[_0x584c('0x3d')](_0x169492[_0x584c('0x3c')],{'$or':_['map'](_0x21d1bf,function(_0x2c0682){if(_0x2c0682['type']!==_0x584c('0x3e')){var _0x49c1f8={};_0x49c1f8[_0x2c0682[_0x584c('0x33')]]={'$like':'%'+_0x4150bd[_0x584c('0x34')][_0x584c('0x3f')]+'%'};return _0x49c1f8;}})});}_0x169492=_[_0x584c('0x3d')]({},_0x169492,_0x4150bd['options']);var _0x3bd0a7={'where':_0x169492[_0x584c('0x3c')]};return db[_0x584c('0x2d')][_0x584c('0x21')](_0x3bd0a7)[_0x584c('0x27')](function(_0x5e8698){_0x1c11d4[_0x584c('0x21')]=_0x5e8698;if(_0x4150bd['query'][_0x584c('0x40')]){_0x169492['include']=[{'all':!![]}];}return db[_0x584c('0x2d')][_0x584c('0x41')](_0x169492);})[_0x584c('0x27')](function(_0x49c435){_0x1c11d4[_0x584c('0x42')]=_0x49c435;return _0x1c11d4;})[_0x584c('0x27')](respondWithFilteredResult(_0x17094a,_0x169492))['catch'](handleError(_0x17094a,null));};exports[_0x584c('0x43')]=function(_0x2dced0,_0x8262d8){var _0x1feafa={'raw':![],'where':{'id':_0x2dced0[_0x584c('0x44')]['id']}},_0x4b9762={};_0x4b9762[_0x584c('0x32')]=_[_0x584c('0x35')](db[_0x584c('0x2d')][_0x584c('0x2e')]);_0x4b9762[_0x584c('0x34')]=_[_0x584c('0x35')](_0x2dced0[_0x584c('0x34')]);_0x4b9762['filters']=_[_0x584c('0x37')](_0x4b9762[_0x584c('0x32')],_0x4b9762['query']);_0x1feafa[_0x584c('0x38')]=_['intersection'](_0x4b9762['model'],qs[_0x584c('0x39')](_0x2dced0['query'][_0x584c('0x39')]));_0x1feafa['attributes']=_0x1feafa[_0x584c('0x38')]['length']?_0x1feafa[_0x584c('0x38')]:_0x4b9762[_0x584c('0x32')];if(_0x2dced0['query'][_0x584c('0x40')]){_0x1feafa[_0x584c('0x45')]=[{'all':!![]}];}_0x1feafa=_[_0x584c('0x3d')]({},_0x1feafa,_0x2dced0[_0x584c('0x46')]);return db['SugarcrmConfiguration'][_0x584c('0x47')](_0x1feafa)[_0x584c('0x27')](handleEntityNotFound(_0x8262d8,null))[_0x584c('0x27')](respondWithResult(_0x8262d8,null))[_0x584c('0x48')](handleError(_0x8262d8,null));};exports[_0x584c('0x49')]=function(_0x4ff512,_0x518891){return db[_0x584c('0x2d')][_0x584c('0x49')](_0x4ff512[_0x584c('0x4a')],{})[_0x584c('0x27')](respondWithResult(_0x518891,0xc9))['catch'](handleError(_0x518891,null));};exports[_0x584c('0x26')]=function(_0x327384,_0x5dd614){if(_0x327384[_0x584c('0x4a')]['id']){delete _0x327384[_0x584c('0x4a')]['id'];}return db[_0x584c('0x2d')][_0x584c('0x47')]({'where':{'id':_0x327384['params']['id']}})[_0x584c('0x27')](handleEntityNotFound(_0x5dd614,null))[_0x584c('0x27')](saveUpdates(_0x327384['body'],null))['then'](respondWithResult(_0x5dd614,null))[_0x584c('0x48')](handleError(_0x5dd614,null));};exports[_0x584c('0x4b')]=function(_0x476d20,_0x2797e8){return db['SugarcrmConfiguration'][_0x584c('0x47')]({'where':{'id':_0x476d20[_0x584c('0x44')]['id']}})[_0x584c('0x27')](handleEntityNotFound(_0x2797e8,null))['then'](removeEntity(_0x2797e8,null))[_0x584c('0x48')](handleError(_0x2797e8,null));};exports[_0x584c('0x4c')]=function(_0x5492eb,_0x31f6e3,_0x53eef0){var _0x3e7811={};var _0x51903b={};var _0x2d0e2e;var _0xcd0e19;return db[_0x584c('0x2d')]['findOne']({'where':{'id':_0x5492eb[_0x584c('0x44')]['id']}})[_0x584c('0x27')](handleEntityNotFound(_0x31f6e3,null))['then'](function(_0xec97b1){if(_0xec97b1){_0x2d0e2e=_0xec97b1;_0x51903b[_0x584c('0x32')]=_['keys'](db[_0x584c('0x4d')]['rawAttributes']);_0x51903b[_0x584c('0x34')]=_['keys'](_0x5492eb[_0x584c('0x34')]);_0x51903b[_0x584c('0x36')]=_[_0x584c('0x37')](_0x51903b[_0x584c('0x32')],_0x51903b[_0x584c('0x34')]);_0x3e7811[_0x584c('0x38')]=_['intersection'](_0x51903b['model'],qs[_0x584c('0x39')](_0x5492eb[_0x584c('0x34')][_0x584c('0x39')]));_0x3e7811[_0x584c('0x38')]=_0x3e7811['attributes'][_0x584c('0x4e')]?_0x3e7811[_0x584c('0x38')]:_0x51903b[_0x584c('0x32')];_0x3e7811['order']=qs['sort'](_0x5492eb[_0x584c('0x34')]['sort']);_0x3e7811[_0x584c('0x3c')]=qs[_0x584c('0x36')](_['pick'](_0x5492eb['query'],_0x51903b[_0x584c('0x36')]));if(_0x5492eb[_0x584c('0x34')][_0x584c('0x3f')]){_0x3e7811[_0x584c('0x3c')]=_[_0x584c('0x3d')](_0x3e7811[_0x584c('0x3c')],{'$or':_['map'](_0x3e7811[_0x584c('0x38')],function(_0x1cf773){var _0x4fc7e2={};_0x4fc7e2[_0x1cf773]={'$like':'%'+_0x5492eb[_0x584c('0x34')][_0x584c('0x3f')]+'%'};return _0x4fc7e2;})});}_0x3e7811=_[_0x584c('0x3d')]({},_0x3e7811,_0x5492eb[_0x584c('0x46')]);return _0x2d0e2e['getFields'](_0x3e7811);}})[_0x584c('0x27')](function(_0x5406c3){if(_0x5406c3){_0xcd0e19=_0x5406c3[_0x584c('0x4e')];if(!_0x5492eb[_0x584c('0x34')]['hasOwnProperty'](_0x584c('0x4f'))){_0x3e7811[_0x584c('0x20')]=qs['limit'](_0x5492eb['query']['limit']);_0x3e7811[_0x584c('0x1e')]=qs[_0x584c('0x1e')](_0x5492eb[_0x584c('0x34')][_0x584c('0x1e')]);}return _0x2d0e2e['getFields'](_0x3e7811);}})['then'](function(_0x406e13){if(_0x406e13){return _0x406e13?{'count':_0xcd0e19,'rows':_0x406e13}:null;}})['then'](respondWithResult(_0x31f6e3,null))[_0x584c('0x48')](handleError(_0x31f6e3,null));};exports[_0x584c('0x50')]=function(_0x17460e,_0x4dcac6,_0x51c3e9){var _0x2b5579={};var _0x5ee03e={};var _0x1cd283;var _0x45a09b;return db[_0x584c('0x2d')][_0x584c('0x51')]({'where':{'id':_0x17460e[_0x584c('0x44')]['id']}})[_0x584c('0x27')](handleEntityNotFound(_0x4dcac6,null))['then'](function(_0x3e0f6b){if(_0x3e0f6b){_0x1cd283=_0x3e0f6b;_0x5ee03e[_0x584c('0x32')]=_[_0x584c('0x35')](db[_0x584c('0x4d')][_0x584c('0x2e')]);_0x5ee03e[_0x584c('0x34')]=_[_0x584c('0x35')](_0x17460e['query']);_0x5ee03e[_0x584c('0x36')]=_[_0x584c('0x37')](_0x5ee03e['model'],_0x5ee03e[_0x584c('0x34')]);_0x2b5579[_0x584c('0x38')]=_[_0x584c('0x37')](_0x5ee03e[_0x584c('0x32')],qs['fields'](_0x17460e[_0x584c('0x34')][_0x584c('0x39')]));_0x2b5579['attributes']=_0x2b5579['attributes'][_0x584c('0x4e')]?_0x2b5579[_0x584c('0x38')]:_0x5ee03e[_0x584c('0x32')];_0x2b5579['order']=qs['sort'](_0x17460e[_0x584c('0x34')][_0x584c('0x3b')]);_0x2b5579[_0x584c('0x3c')]=qs[_0x584c('0x36')](_[_0x584c('0x52')](_0x17460e[_0x584c('0x34')],_0x5ee03e[_0x584c('0x36')]));if(_0x17460e[_0x584c('0x34')][_0x584c('0x3f')]){_0x2b5579[_0x584c('0x3c')]=_[_0x584c('0x3d')](_0x2b5579[_0x584c('0x3c')],{'$or':_[_0x584c('0x2c')](_0x2b5579[_0x584c('0x38')],function(_0x2a78f7){var _0x5c2f78={};_0x5c2f78[_0x2a78f7]={'$like':'%'+_0x17460e[_0x584c('0x34')][_0x584c('0x3f')]+'%'};return _0x5c2f78;})});}_0x2b5579=_[_0x584c('0x3d')]({},_0x2b5579,_0x17460e[_0x584c('0x46')]);return _0x1cd283[_0x584c('0x50')](_0x2b5579);}})[_0x584c('0x27')](function(_0x218a4d){if(_0x218a4d){_0x45a09b=_0x218a4d[_0x584c('0x4e')];if(!_0x17460e['query'][_0x584c('0x53')]('nolimit')){_0x2b5579[_0x584c('0x20')]=qs['limit'](_0x17460e[_0x584c('0x34')][_0x584c('0x20')]);_0x2b5579[_0x584c('0x1e')]=qs[_0x584c('0x1e')](_0x17460e[_0x584c('0x34')]['offset']);}return _0x1cd283['getSubjects'](_0x2b5579);}})[_0x584c('0x27')](function(_0x5a32d6){if(_0x5a32d6){return _0x5a32d6?{'count':_0x45a09b,'rows':_0x5a32d6}:null;}})[_0x584c('0x27')](respondWithResult(_0x4dcac6,null))[_0x584c('0x48')](handleError(_0x4dcac6,null));};exports[_0x584c('0x54')]=function(_0x4cccba,_0x215ac2,_0x126b56){var _0x48fdd2={};var _0x1c0565={};var _0x1ad091;var _0x3c1892;return db['SugarcrmConfiguration'][_0x584c('0x51')]({'where':{'id':_0x4cccba[_0x584c('0x44')]['id']}})[_0x584c('0x27')](handleEntityNotFound(_0x215ac2,null))[_0x584c('0x27')](function(_0x2a01ac){if(_0x2a01ac){_0x1ad091=_0x2a01ac;_0x1c0565['model']=_['keys'](db[_0x584c('0x4d')][_0x584c('0x2e')]);_0x1c0565[_0x584c('0x34')]=_['keys'](_0x4cccba['query']);_0x1c0565[_0x584c('0x36')]=_[_0x584c('0x37')](_0x1c0565[_0x584c('0x32')],_0x1c0565[_0x584c('0x34')]);_0x48fdd2[_0x584c('0x38')]=_[_0x584c('0x37')](_0x1c0565[_0x584c('0x32')],qs[_0x584c('0x39')](_0x4cccba['query'][_0x584c('0x39')]));_0x48fdd2[_0x584c('0x38')]=_0x48fdd2['attributes'][_0x584c('0x4e')]?_0x48fdd2[_0x584c('0x38')]:_0x1c0565['model'];_0x48fdd2[_0x584c('0x3a')]=qs[_0x584c('0x3b')](_0x4cccba['query'][_0x584c('0x3b')]);_0x48fdd2[_0x584c('0x3c')]=qs['filters'](_['pick'](_0x4cccba[_0x584c('0x34')],_0x1c0565[_0x584c('0x36')]));if(_0x4cccba[_0x584c('0x34')][_0x584c('0x3f')]){_0x48fdd2[_0x584c('0x3c')]=_[_0x584c('0x3d')](_0x48fdd2[_0x584c('0x3c')],{'$or':_[_0x584c('0x2c')](_0x48fdd2[_0x584c('0x38')],function(_0x20c3af){var _0x456106={};_0x456106[_0x20c3af]={'$like':'%'+_0x4cccba[_0x584c('0x34')][_0x584c('0x3f')]+'%'};return _0x456106;})});}_0x48fdd2=_[_0x584c('0x3d')]({},_0x48fdd2,_0x4cccba[_0x584c('0x46')]);return _0x1ad091[_0x584c('0x54')](_0x48fdd2);}})[_0x584c('0x27')](function(_0x5e08a7){if(_0x5e08a7){_0x3c1892=_0x5e08a7[_0x584c('0x4e')];if(!_0x4cccba['query'][_0x584c('0x53')]('nolimit')){_0x48fdd2[_0x584c('0x20')]=qs[_0x584c('0x20')](_0x4cccba[_0x584c('0x34')]['limit']);_0x48fdd2['offset']=qs[_0x584c('0x1e')](_0x4cccba[_0x584c('0x34')][_0x584c('0x1e')]);}return _0x1ad091[_0x584c('0x54')](_0x48fdd2);}})[_0x584c('0x27')](function(_0x220737){if(_0x220737){return _0x220737?{'count':_0x3c1892,'rows':_0x220737}:null;}})[_0x584c('0x27')](respondWithResult(_0x215ac2,null))[_0x584c('0x48')](handleError(_0x215ac2,null));};