[motion2.git] / server / api / intSugarcrmConfiguration / intSugarcrmConfiguration.controller.js

// *************************************************************************
// *                                                                       *
// * xCALLY Motion -  The Omnichannel Contact Center                       *
// * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * Email: info@xcally.com                                                *
// * Website: https://www.xcally.com                                       *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * The SOFTWARE PRODUCT is protected by copyright laws and international *
// * copyright treaties, as well as other intellectual property laws and   *
// * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
// *                                                                       *
// *************************************************************************
var _0x445d=['fast-json-patch','request-promise','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','crypto','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/license/util','sendStatus','end','json','offset','undefined','limit','count','status','set','Content-Range','apply','save','then','name','index','rawAttributes','type','key','model','map','keys','query','filters','intersection','attributes','fields','length','nolimit','sort','where','filter','VIRTUAL','merge','options','SugarcrmConfiguration','include','rows','catch','show','params','includeAll','find','create','body','getFields','findOne','SugarcrmField','order','hasOwnProperty','pick','getSubjects','getDescriptions','eml-format','rimraf'];(function(_0x20a584,_0xe384a5){var _0x4b41a8=function(_0x2127c6){while(--_0x2127c6){_0x20a584['push'](_0x20a584['shift']());}};_0x4b41a8(++_0xe384a5);}(_0x445d,0x136));var _0xd445=function(_0x214692,_0x47e3c4){_0x214692=_0x214692-0x0;var _0x186b94=_0x445d[_0x214692];return _0x186b94;};'use strict';var emlformat=require(_0xd445('0x0'));var rimraf=require(_0xd445('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xd445('0x2'));var rp=require(_0xd445('0x3'));var moment=require('moment');var BPromise=require(_0xd445('0x4'));var Mustache=require(_0xd445('0x5'));var util=require(_0xd445('0x6'));var path=require(_0xd445('0x7'));var sox=require(_0xd445('0x8'));var csv=require(_0xd445('0x9'));var ejs=require(_0xd445('0xa'));var fs=require('fs');var fs_extra=require(_0xd445('0xb'));var _=require(_0xd445('0xc'));var squel=require('squel');var crypto=require(_0xd445('0xd'));var jsforce=require('jsforce');var deskjs=require(_0xd445('0xe'));var toCsv=require('to-csv');var querystring=require(_0xd445('0xf'));var Papa=require(_0xd445('0x10'));var Redis=require(_0xd445('0x11'));var authService=require(_0xd445('0x12'));var qs=require(_0xd445('0x13'));var as=require(_0xd445('0x14'));var hardwareService=require(_0xd445('0x15'));var logger=require(_0xd445('0x16'))(_0xd445('0x17'));var utils=require(_0xd445('0x18'));var config=require('../../config/environment');var licenseUtil=require(_0xd445('0x19'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x29871c,_0x59fe20){_0x59fe20=_0x59fe20||0xcc;return function(_0x5a9bd0){if(_0x5a9bd0){return _0x29871c[_0xd445('0x1a')](_0x59fe20);}return _0x29871c['status'](_0x59fe20)[_0xd445('0x1b')]();};}function respondWithResult(_0x5e8786,_0x9b00d6){_0x9b00d6=_0x9b00d6||0xc8;return function(_0x29384e){if(_0x29384e){return _0x5e8786['status'](_0x9b00d6)[_0xd445('0x1c')](_0x29384e);}};}function respondWithFilteredResult(_0x5d81d9,_0x38d28d){return function(_0x3a3c57){if(_0x3a3c57){var _0x31ced9=typeof _0x38d28d[_0xd445('0x1d')]===_0xd445('0x1e')&&typeof _0x38d28d[_0xd445('0x1f')]==='undefined';var _0x35253c=_0x3a3c57[_0xd445('0x20')];var _0x55fa7=_0x31ced9?0x0:_0x38d28d['offset'];var _0x1e99d3=_0x31ced9?_0x3a3c57['count']:_0x38d28d[_0xd445('0x1d')]+_0x38d28d[_0xd445('0x1f')];var _0x422799;if(_0x1e99d3>=_0x35253c){_0x1e99d3=_0x35253c;_0x422799=0xc8;}else{_0x422799=0xce;}_0x5d81d9[_0xd445('0x21')](_0x422799);return _0x5d81d9[_0xd445('0x22')](_0xd445('0x23'),_0x55fa7+'-'+_0x1e99d3+'/'+_0x35253c)['json'](_0x3a3c57);}return null;};}function patchUpdates(_0x22e7a7){return function(_0x22417a){try{jsonpatch[_0xd445('0x24')](_0x22417a,_0x22e7a7,!![]);}catch(_0x2aeea8){return BPromise['reject'](_0x2aeea8);}return _0x22417a[_0xd445('0x25')]();};}function saveUpdates(_0x10c44b,_0x11ccdd){return function(_0xb31dc9){if(_0xb31dc9){return _0xb31dc9['update'](_0x10c44b)[_0xd445('0x26')](function(_0x49ba32){return _0x49ba32;});}return null;};}function removeEntity(_0x4ede2b,_0x371fe5){return function(_0x5bc803){if(_0x5bc803){return _0x5bc803['destroy']()[_0xd445('0x26')](function(){_0x4ede2b[_0xd445('0x21')](0xcc)[_0xd445('0x1b')]();});}};}function handleEntityNotFound(_0x5dfdf4,_0x1b02d0){return function(_0x323a4a){if(!_0x323a4a){_0x5dfdf4['sendStatus'](0x194);}return _0x323a4a;};}function handleError(_0x1b5feb,_0x1035db){_0x1035db=_0x1035db||0x1f4;return function(_0xa02060){logger['error'](_0xa02060['stack']);if(_0xa02060[_0xd445('0x27')]){delete _0xa02060[_0xd445('0x27')];}_0x1b5feb['status'](_0x1035db)['send'](_0xa02060);};}exports[_0xd445('0x28')]=function(_0x58df93,_0x2bb39b){var _0x52d3c2={},_0x4bd58a={},_0x3121fc={'count':0x0,'rows':[]};var _0x106f1d=_['map'](db['SugarcrmConfiguration'][_0xd445('0x29')],function(_0x534c73){return{'name':_0x534c73['fieldName'],'type':_0x534c73[_0xd445('0x2a')][_0xd445('0x2b')]};});_0x4bd58a[_0xd445('0x2c')]=_[_0xd445('0x2d')](_0x106f1d,_0xd445('0x27'));_0x4bd58a['query']=_[_0xd445('0x2e')](_0x58df93[_0xd445('0x2f')]);_0x4bd58a[_0xd445('0x30')]=_[_0xd445('0x31')](_0x4bd58a[_0xd445('0x2c')],_0x4bd58a[_0xd445('0x2f')]);_0x52d3c2[_0xd445('0x32')]=_['intersection'](_0x4bd58a[_0xd445('0x2c')],qs[_0xd445('0x33')](_0x58df93[_0xd445('0x2f')][_0xd445('0x33')]));_0x52d3c2[_0xd445('0x32')]=_0x52d3c2[_0xd445('0x32')][_0xd445('0x34')]?_0x52d3c2[_0xd445('0x32')]:_0x4bd58a['model'];if(!_0x58df93[_0xd445('0x2f')]['hasOwnProperty'](_0xd445('0x35'))){_0x52d3c2['limit']=qs[_0xd445('0x1f')](_0x58df93[_0xd445('0x2f')][_0xd445('0x1f')]);_0x52d3c2[_0xd445('0x1d')]=qs[_0xd445('0x1d')](_0x58df93[_0xd445('0x2f')][_0xd445('0x1d')]);}_0x52d3c2['order']=qs[_0xd445('0x36')](_0x58df93[_0xd445('0x2f')]['sort']);_0x52d3c2[_0xd445('0x37')]=qs[_0xd445('0x30')](_['pick'](_0x58df93[_0xd445('0x2f')],_0x4bd58a['filters']),_0x106f1d);if(_0x58df93[_0xd445('0x2f')][_0xd445('0x38')]){_0x52d3c2[_0xd445('0x37')]=_['merge'](_0x52d3c2['where'],{'$or':_['map'](_0x106f1d,function(_0x32581d){if(_0x32581d[_0xd445('0x2a')]!==_0xd445('0x39')){var _0x40d845={};_0x40d845[_0x32581d[_0xd445('0x27')]]={'$like':'%'+_0x58df93[_0xd445('0x2f')]['filter']+'%'};return _0x40d845;}})});}_0x52d3c2=_[_0xd445('0x3a')]({},_0x52d3c2,_0x58df93[_0xd445('0x3b')]);var _0x46c46d={'where':_0x52d3c2[_0xd445('0x37')]};return db[_0xd445('0x3c')][_0xd445('0x20')](_0x46c46d)[_0xd445('0x26')](function(_0x3f6bf2){_0x3121fc[_0xd445('0x20')]=_0x3f6bf2;if(_0x58df93[_0xd445('0x2f')]['includeAll']){_0x52d3c2[_0xd445('0x3d')]=[{'all':!![]}];}return db[_0xd445('0x3c')]['findAll'](_0x52d3c2);})[_0xd445('0x26')](function(_0x5d201d){_0x3121fc[_0xd445('0x3e')]=_0x5d201d;return _0x3121fc;})[_0xd445('0x26')](respondWithFilteredResult(_0x2bb39b,_0x52d3c2))[_0xd445('0x3f')](handleError(_0x2bb39b,null));};exports[_0xd445('0x40')]=function(_0x55bcda,_0x3484fa){var _0x3b5ea7={'raw':![],'where':{'id':_0x55bcda[_0xd445('0x41')]['id']}},_0x279eca={};_0x279eca['model']=_[_0xd445('0x2e')](db[_0xd445('0x3c')][_0xd445('0x29')]);_0x279eca[_0xd445('0x2f')]=_[_0xd445('0x2e')](_0x55bcda[_0xd445('0x2f')]);_0x279eca['filters']=_[_0xd445('0x31')](_0x279eca[_0xd445('0x2c')],_0x279eca[_0xd445('0x2f')]);_0x3b5ea7[_0xd445('0x32')]=_[_0xd445('0x31')](_0x279eca[_0xd445('0x2c')],qs[_0xd445('0x33')](_0x55bcda[_0xd445('0x2f')][_0xd445('0x33')]));_0x3b5ea7[_0xd445('0x32')]=_0x3b5ea7[_0xd445('0x32')][_0xd445('0x34')]?_0x3b5ea7['attributes']:_0x279eca['model'];if(_0x55bcda['query'][_0xd445('0x42')]){_0x3b5ea7[_0xd445('0x3d')]=[{'all':!![]}];}_0x3b5ea7=_[_0xd445('0x3a')]({},_0x3b5ea7,_0x55bcda[_0xd445('0x3b')]);return db['SugarcrmConfiguration'][_0xd445('0x43')](_0x3b5ea7)['then'](handleEntityNotFound(_0x3484fa,null))[_0xd445('0x26')](respondWithResult(_0x3484fa,null))[_0xd445('0x3f')](handleError(_0x3484fa,null));};exports[_0xd445('0x44')]=function(_0x4a93f9,_0x5e8178){return db[_0xd445('0x3c')][_0xd445('0x44')](_0x4a93f9['body'],{})[_0xd445('0x26')](respondWithResult(_0x5e8178,0xc9))[_0xd445('0x3f')](handleError(_0x5e8178,null));};exports['update']=function(_0xad4f71,_0x56b823){if(_0xad4f71['body']['id']){delete _0xad4f71[_0xd445('0x45')]['id'];}return db[_0xd445('0x3c')][_0xd445('0x43')]({'where':{'id':_0xad4f71['params']['id']}})[_0xd445('0x26')](handleEntityNotFound(_0x56b823,null))['then'](saveUpdates(_0xad4f71['body'],null))[_0xd445('0x26')](respondWithResult(_0x56b823,null))[_0xd445('0x3f')](handleError(_0x56b823,null));};exports['destroy']=function(_0xabb6c1,_0x445ecf){return db[_0xd445('0x3c')][_0xd445('0x43')]({'where':{'id':_0xabb6c1[_0xd445('0x41')]['id']}})[_0xd445('0x26')](handleEntityNotFound(_0x445ecf,null))[_0xd445('0x26')](removeEntity(_0x445ecf,null))[_0xd445('0x3f')](handleError(_0x445ecf,null));};exports[_0xd445('0x46')]=function(_0x48a7a3,_0x44c165,_0x48213e){var _0x9c746f={};var _0x27f0e8={};var _0x45ffda;var _0x180215;return db[_0xd445('0x3c')][_0xd445('0x47')]({'where':{'id':_0x48a7a3[_0xd445('0x41')]['id']}})[_0xd445('0x26')](handleEntityNotFound(_0x44c165,null))[_0xd445('0x26')](function(_0xff1365){if(_0xff1365){_0x45ffda=_0xff1365;_0x27f0e8[_0xd445('0x2c')]=_[_0xd445('0x2e')](db[_0xd445('0x48')][_0xd445('0x29')]);_0x27f0e8[_0xd445('0x2f')]=_[_0xd445('0x2e')](_0x48a7a3[_0xd445('0x2f')]);_0x27f0e8[_0xd445('0x30')]=_[_0xd445('0x31')](_0x27f0e8[_0xd445('0x2c')],_0x27f0e8[_0xd445('0x2f')]);_0x9c746f['attributes']=_['intersection'](_0x27f0e8[_0xd445('0x2c')],qs['fields'](_0x48a7a3['query']['fields']));_0x9c746f['attributes']=_0x9c746f[_0xd445('0x32')][_0xd445('0x34')]?_0x9c746f[_0xd445('0x32')]:_0x27f0e8[_0xd445('0x2c')];_0x9c746f[_0xd445('0x49')]=qs[_0xd445('0x36')](_0x48a7a3[_0xd445('0x2f')][_0xd445('0x36')]);_0x9c746f[_0xd445('0x37')]=qs[_0xd445('0x30')](_['pick'](_0x48a7a3[_0xd445('0x2f')],_0x27f0e8['filters']));if(_0x48a7a3[_0xd445('0x2f')][_0xd445('0x38')]){_0x9c746f['where']=_['merge'](_0x9c746f['where'],{'$or':_[_0xd445('0x2d')](_0x9c746f['attributes'],function(_0x51f89c){var _0x129bee={};_0x129bee[_0x51f89c]={'$like':'%'+_0x48a7a3[_0xd445('0x2f')]['filter']+'%'};return _0x129bee;})});}_0x9c746f=_[_0xd445('0x3a')]({},_0x9c746f,_0x48a7a3['options']);return _0x45ffda[_0xd445('0x46')](_0x9c746f);}})[_0xd445('0x26')](function(_0x45e0ff){if(_0x45e0ff){_0x180215=_0x45e0ff['length'];if(!_0x48a7a3[_0xd445('0x2f')][_0xd445('0x4a')](_0xd445('0x35'))){_0x9c746f[_0xd445('0x1f')]=qs[_0xd445('0x1f')](_0x48a7a3['query'][_0xd445('0x1f')]);_0x9c746f['offset']=qs[_0xd445('0x1d')](_0x48a7a3[_0xd445('0x2f')][_0xd445('0x1d')]);}return _0x45ffda[_0xd445('0x46')](_0x9c746f);}})[_0xd445('0x26')](function(_0x3abb92){if(_0x3abb92){return _0x3abb92?{'count':_0x180215,'rows':_0x3abb92}:null;}})[_0xd445('0x26')](respondWithResult(_0x44c165,null))['catch'](handleError(_0x44c165,null));};exports['getSubjects']=function(_0x4fd5a8,_0x54a953,_0x2e3a01){var _0x18c715={};var _0x5c0cec={};var _0x1097a5;var _0x4ac970;return db[_0xd445('0x3c')]['findOne']({'where':{'id':_0x4fd5a8[_0xd445('0x41')]['id']}})[_0xd445('0x26')](handleEntityNotFound(_0x54a953,null))[_0xd445('0x26')](function(_0x551d69){if(_0x551d69){_0x1097a5=_0x551d69;_0x5c0cec[_0xd445('0x2c')]=_[_0xd445('0x2e')](db[_0xd445('0x48')][_0xd445('0x29')]);_0x5c0cec['query']=_[_0xd445('0x2e')](_0x4fd5a8['query']);_0x5c0cec[_0xd445('0x30')]=_['intersection'](_0x5c0cec[_0xd445('0x2c')],_0x5c0cec['query']);_0x18c715['attributes']=_['intersection'](_0x5c0cec[_0xd445('0x2c')],qs[_0xd445('0x33')](_0x4fd5a8[_0xd445('0x2f')]['fields']));_0x18c715[_0xd445('0x32')]=_0x18c715[_0xd445('0x32')]['length']?_0x18c715[_0xd445('0x32')]:_0x5c0cec['model'];_0x18c715[_0xd445('0x49')]=qs[_0xd445('0x36')](_0x4fd5a8['query']['sort']);_0x18c715[_0xd445('0x37')]=qs[_0xd445('0x30')](_[_0xd445('0x4b')](_0x4fd5a8[_0xd445('0x2f')],_0x5c0cec[_0xd445('0x30')]));if(_0x4fd5a8[_0xd445('0x2f')][_0xd445('0x38')]){_0x18c715[_0xd445('0x37')]=_[_0xd445('0x3a')](_0x18c715[_0xd445('0x37')],{'$or':_[_0xd445('0x2d')](_0x18c715[_0xd445('0x32')],function(_0x2e68a3){var _0x363b7e={};_0x363b7e[_0x2e68a3]={'$like':'%'+_0x4fd5a8[_0xd445('0x2f')][_0xd445('0x38')]+'%'};return _0x363b7e;})});}_0x18c715=_[_0xd445('0x3a')]({},_0x18c715,_0x4fd5a8[_0xd445('0x3b')]);return _0x1097a5[_0xd445('0x4c')](_0x18c715);}})['then'](function(_0x20d9f6){if(_0x20d9f6){_0x4ac970=_0x20d9f6[_0xd445('0x34')];if(!_0x4fd5a8[_0xd445('0x2f')][_0xd445('0x4a')](_0xd445('0x35'))){_0x18c715[_0xd445('0x1f')]=qs[_0xd445('0x1f')](_0x4fd5a8[_0xd445('0x2f')][_0xd445('0x1f')]);_0x18c715[_0xd445('0x1d')]=qs[_0xd445('0x1d')](_0x4fd5a8[_0xd445('0x2f')]['offset']);}return _0x1097a5[_0xd445('0x4c')](_0x18c715);}})[_0xd445('0x26')](function(_0x476cf1){if(_0x476cf1){return _0x476cf1?{'count':_0x4ac970,'rows':_0x476cf1}:null;}})[_0xd445('0x26')](respondWithResult(_0x54a953,null))['catch'](handleError(_0x54a953,null));};exports[_0xd445('0x4d')]=function(_0x16f797,_0x5d2db9,_0x5e65ff){var _0x2319db={};var _0x50cb86={};var _0x13f337;var _0x24ed8f;return db[_0xd445('0x3c')][_0xd445('0x47')]({'where':{'id':_0x16f797[_0xd445('0x41')]['id']}})[_0xd445('0x26')](handleEntityNotFound(_0x5d2db9,null))[_0xd445('0x26')](function(_0x5c5382){if(_0x5c5382){_0x13f337=_0x5c5382;_0x50cb86[_0xd445('0x2c')]=_[_0xd445('0x2e')](db[_0xd445('0x48')][_0xd445('0x29')]);_0x50cb86['query']=_['keys'](_0x16f797[_0xd445('0x2f')]);_0x50cb86[_0xd445('0x30')]=_[_0xd445('0x31')](_0x50cb86[_0xd445('0x2c')],_0x50cb86[_0xd445('0x2f')]);_0x2319db[_0xd445('0x32')]=_[_0xd445('0x31')](_0x50cb86[_0xd445('0x2c')],qs[_0xd445('0x33')](_0x16f797[_0xd445('0x2f')][_0xd445('0x33')]));_0x2319db[_0xd445('0x32')]=_0x2319db[_0xd445('0x32')][_0xd445('0x34')]?_0x2319db[_0xd445('0x32')]:_0x50cb86[_0xd445('0x2c')];_0x2319db['order']=qs[_0xd445('0x36')](_0x16f797[_0xd445('0x2f')][_0xd445('0x36')]);_0x2319db[_0xd445('0x37')]=qs[_0xd445('0x30')](_[_0xd445('0x4b')](_0x16f797[_0xd445('0x2f')],_0x50cb86[_0xd445('0x30')]));if(_0x16f797[_0xd445('0x2f')][_0xd445('0x38')]){_0x2319db[_0xd445('0x37')]=_[_0xd445('0x3a')](_0x2319db[_0xd445('0x37')],{'$or':_[_0xd445('0x2d')](_0x2319db[_0xd445('0x32')],function(_0x2c20f7){var _0x1bcd43={};_0x1bcd43[_0x2c20f7]={'$like':'%'+_0x16f797[_0xd445('0x2f')]['filter']+'%'};return _0x1bcd43;})});}_0x2319db=_[_0xd445('0x3a')]({},_0x2319db,_0x16f797[_0xd445('0x3b')]);return _0x13f337['getDescriptions'](_0x2319db);}})[_0xd445('0x26')](function(_0xef4c44){if(_0xef4c44){_0x24ed8f=_0xef4c44['length'];if(!_0x16f797[_0xd445('0x2f')]['hasOwnProperty'](_0xd445('0x35'))){_0x2319db['limit']=qs['limit'](_0x16f797['query']['limit']);_0x2319db[_0xd445('0x1d')]=qs[_0xd445('0x1d')](_0x16f797[_0xd445('0x2f')]['offset']);}return _0x13f337[_0xd445('0x4d')](_0x2319db);}})['then'](function(_0x54b2a6){if(_0x54b2a6){return _0x54b2a6?{'count':_0x24ed8f,'rows':_0x54b2a6}:null;}})['then'](respondWithResult(_0x5d2db9,null))['catch'](handleError(_0x5d2db9,null));};