[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 _0xdf65=['squel','crypto','jsforce','querystring','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','end','json','offset','undefined','limit','count','Content-Range','apply','save','update','destroy','status','error','stack','name','send','index','SugarcrmConfiguration','fieldName','type','key','model','map','keys','filters','intersection','query','attributes','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','VIRTUAL','merge','then','include','findAll','rows','show','params','rawAttributes','fields','includeAll','options','find','create','body','catch','getFields','findOne','SugarcrmField','getSubjects','getDescriptions','eml-format','zip-dir','fast-json-patch','request-promise','moment','util','path','sox','to-csv','ejs','fs-extra'];(function(_0xf3bf0b,_0x5c17ed){var _0x3e5c44=function(_0x111dd6){while(--_0x111dd6){_0xf3bf0b['push'](_0xf3bf0b['shift']());}};_0x3e5c44(++_0x5c17ed);}(_0xdf65,0x13d));var _0x5df6=function(_0x115149,_0x1fca9e){_0x115149=_0x115149-0x0;var _0x2a91dc=_0xdf65[_0x115149];return _0x2a91dc;};'use strict';var emlformat=require(_0x5df6('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x5df6('0x1'));var jsonpatch=require(_0x5df6('0x2'));var rp=require(_0x5df6('0x3'));var moment=require(_0x5df6('0x4'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x5df6('0x5'));var path=require(_0x5df6('0x6'));var sox=require(_0x5df6('0x7'));var csv=require(_0x5df6('0x8'));var ejs=require(_0x5df6('0x9'));var fs=require('fs');var fs_extra=require(_0x5df6('0xa'));var _=require('lodash');var squel=require(_0x5df6('0xb'));var crypto=require(_0x5df6('0xc'));var jsforce=require(_0x5df6('0xd'));var deskjs=require('desk.js');var toCsv=require(_0x5df6('0x8'));var querystring=require(_0x5df6('0xe'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x5df6('0xf'));var qs=require(_0x5df6('0x10'));var as=require(_0x5df6('0x11'));var hardwareService=require(_0x5df6('0x12'));var logger=require(_0x5df6('0x13'))(_0x5df6('0x14'));var utils=require(_0x5df6('0x15'));var config=require(_0x5df6('0x16'));var licenseUtil=require('../../config/license/util');var db=require(_0x5df6('0x17'))['db'];function respondWithStatusCode(_0x10cf4f,_0xd8be85){_0xd8be85=_0xd8be85||0xcc;return function(_0x577f2a){if(_0x577f2a){return _0x10cf4f[_0x5df6('0x18')](_0xd8be85);}return _0x10cf4f['status'](_0xd8be85)[_0x5df6('0x19')]();};}function respondWithResult(_0x220aaa,_0x3b4c45){_0x3b4c45=_0x3b4c45||0xc8;return function(_0x50862c){if(_0x50862c){return _0x220aaa['status'](_0x3b4c45)[_0x5df6('0x1a')](_0x50862c);}};}function respondWithFilteredResult(_0x3aa495,_0x3ff0ad){return function(_0x4d2aa7){if(_0x4d2aa7){var _0x5281fb=typeof _0x3ff0ad[_0x5df6('0x1b')]===_0x5df6('0x1c')&&typeof _0x3ff0ad[_0x5df6('0x1d')]===_0x5df6('0x1c');var _0x339f70=_0x4d2aa7[_0x5df6('0x1e')];var _0x3827f7=_0x5281fb?0x0:_0x3ff0ad['offset'];var _0x38adc1=_0x5281fb?_0x4d2aa7['count']:_0x3ff0ad[_0x5df6('0x1b')]+_0x3ff0ad[_0x5df6('0x1d')];var _0x2e5de3;if(_0x38adc1>=_0x339f70){_0x38adc1=_0x339f70;_0x2e5de3=0xc8;}else{_0x2e5de3=0xce;}_0x3aa495['status'](_0x2e5de3);return _0x3aa495['set'](_0x5df6('0x1f'),_0x3827f7+'-'+_0x38adc1+'/'+_0x339f70)[_0x5df6('0x1a')](_0x4d2aa7);}return null;};}function patchUpdates(_0x5b3358){return function(_0x345ccc){try{jsonpatch[_0x5df6('0x20')](_0x345ccc,_0x5b3358,!![]);}catch(_0x55a71b){return BPromise['reject'](_0x55a71b);}return _0x345ccc[_0x5df6('0x21')]();};}function saveUpdates(_0x200dee,_0x19927b){return function(_0x439570){if(_0x439570){return _0x439570[_0x5df6('0x22')](_0x200dee)['then'](function(_0x338f5b){return _0x338f5b;});}return null;};}function removeEntity(_0x5851e2,_0x398539){return function(_0x2388e9){if(_0x2388e9){return _0x2388e9[_0x5df6('0x23')]()['then'](function(){_0x5851e2[_0x5df6('0x24')](0xcc)[_0x5df6('0x19')]();});}};}function handleEntityNotFound(_0x332a76,_0x242847){return function(_0x4ffbd7){if(!_0x4ffbd7){_0x332a76[_0x5df6('0x18')](0x194);}return _0x4ffbd7;};}function handleError(_0x3e61fd,_0x176495){_0x176495=_0x176495||0x1f4;return function(_0x13fbb8){logger[_0x5df6('0x25')](_0x13fbb8[_0x5df6('0x26')]);if(_0x13fbb8[_0x5df6('0x27')]){delete _0x13fbb8[_0x5df6('0x27')];}_0x3e61fd[_0x5df6('0x24')](_0x176495)[_0x5df6('0x28')](_0x13fbb8);};}exports[_0x5df6('0x29')]=function(_0x37f490,_0x60d6c8){var _0x1a4642={},_0x35a545={},_0x327f69={'count':0x0,'rows':[]};var _0x3d1dd7=_['map'](db[_0x5df6('0x2a')]['rawAttributes'],function(_0x516aea){return{'name':_0x516aea[_0x5df6('0x2b')],'type':_0x516aea[_0x5df6('0x2c')][_0x5df6('0x2d')]};});_0x35a545[_0x5df6('0x2e')]=_[_0x5df6('0x2f')](_0x3d1dd7,_0x5df6('0x27'));_0x35a545['query']=_[_0x5df6('0x30')](_0x37f490['query']);_0x35a545[_0x5df6('0x31')]=_[_0x5df6('0x32')](_0x35a545[_0x5df6('0x2e')],_0x35a545[_0x5df6('0x33')]);_0x1a4642[_0x5df6('0x34')]=_['intersection'](_0x35a545[_0x5df6('0x2e')],qs['fields'](_0x37f490['query']['fields']));_0x1a4642[_0x5df6('0x34')]=_0x1a4642[_0x5df6('0x34')][_0x5df6('0x35')]?_0x1a4642[_0x5df6('0x34')]:_0x35a545[_0x5df6('0x2e')];if(!_0x37f490[_0x5df6('0x33')][_0x5df6('0x36')](_0x5df6('0x37'))){_0x1a4642['limit']=qs[_0x5df6('0x1d')](_0x37f490['query'][_0x5df6('0x1d')]);_0x1a4642[_0x5df6('0x1b')]=qs[_0x5df6('0x1b')](_0x37f490[_0x5df6('0x33')][_0x5df6('0x1b')]);}_0x1a4642[_0x5df6('0x38')]=qs[_0x5df6('0x39')](_0x37f490['query'][_0x5df6('0x39')]);_0x1a4642[_0x5df6('0x3a')]=qs[_0x5df6('0x31')](_[_0x5df6('0x3b')](_0x37f490['query'],_0x35a545[_0x5df6('0x31')]),_0x3d1dd7);if(_0x37f490[_0x5df6('0x33')][_0x5df6('0x3c')]){_0x1a4642['where']=_['merge'](_0x1a4642[_0x5df6('0x3a')],{'$or':_[_0x5df6('0x2f')](_0x3d1dd7,function(_0x5ed024){if(_0x5ed024['type']!==_0x5df6('0x3d')){var _0x2c5343={};_0x2c5343[_0x5ed024[_0x5df6('0x27')]]={'$like':'%'+_0x37f490['query']['filter']+'%'};return _0x2c5343;}})});}_0x1a4642=_[_0x5df6('0x3e')]({},_0x1a4642,_0x37f490['options']);var _0x1608fb={'where':_0x1a4642[_0x5df6('0x3a')]};return db[_0x5df6('0x2a')]['count'](_0x1608fb)[_0x5df6('0x3f')](function(_0x34c152){_0x327f69[_0x5df6('0x1e')]=_0x34c152;if(_0x37f490[_0x5df6('0x33')]['includeAll']){_0x1a4642[_0x5df6('0x40')]=[{'all':!![]}];}return db[_0x5df6('0x2a')][_0x5df6('0x41')](_0x1a4642);})[_0x5df6('0x3f')](function(_0x549cc8){_0x327f69[_0x5df6('0x42')]=_0x549cc8;return _0x327f69;})[_0x5df6('0x3f')](respondWithFilteredResult(_0x60d6c8,_0x1a4642))['catch'](handleError(_0x60d6c8,null));};exports[_0x5df6('0x43')]=function(_0x49cf39,_0x52769c){var _0x5d6a66={'raw':![],'where':{'id':_0x49cf39[_0x5df6('0x44')]['id']}},_0x7f9d2={};_0x7f9d2[_0x5df6('0x2e')]=_[_0x5df6('0x30')](db['SugarcrmConfiguration'][_0x5df6('0x45')]);_0x7f9d2[_0x5df6('0x33')]=_[_0x5df6('0x30')](_0x49cf39['query']);_0x7f9d2[_0x5df6('0x31')]=_[_0x5df6('0x32')](_0x7f9d2['model'],_0x7f9d2[_0x5df6('0x33')]);_0x5d6a66['attributes']=_[_0x5df6('0x32')](_0x7f9d2[_0x5df6('0x2e')],qs[_0x5df6('0x46')](_0x49cf39['query']['fields']));_0x5d6a66[_0x5df6('0x34')]=_0x5d6a66[_0x5df6('0x34')]['length']?_0x5d6a66[_0x5df6('0x34')]:_0x7f9d2['model'];if(_0x49cf39['query'][_0x5df6('0x47')]){_0x5d6a66[_0x5df6('0x40')]=[{'all':!![]}];}_0x5d6a66=_[_0x5df6('0x3e')]({},_0x5d6a66,_0x49cf39[_0x5df6('0x48')]);return db[_0x5df6('0x2a')][_0x5df6('0x49')](_0x5d6a66)[_0x5df6('0x3f')](handleEntityNotFound(_0x52769c,null))[_0x5df6('0x3f')](respondWithResult(_0x52769c,null))['catch'](handleError(_0x52769c,null));};exports[_0x5df6('0x4a')]=function(_0x38e7ef,_0x2c62d7){return db[_0x5df6('0x2a')][_0x5df6('0x4a')](_0x38e7ef[_0x5df6('0x4b')],{})['then'](respondWithResult(_0x2c62d7,0xc9))[_0x5df6('0x4c')](handleError(_0x2c62d7,null));};exports[_0x5df6('0x22')]=function(_0x237f4c,_0x1a783e){if(_0x237f4c['body']['id']){delete _0x237f4c[_0x5df6('0x4b')]['id'];}return db['SugarcrmConfiguration']['find']({'where':{'id':_0x237f4c[_0x5df6('0x44')]['id']}})[_0x5df6('0x3f')](handleEntityNotFound(_0x1a783e,null))[_0x5df6('0x3f')](saveUpdates(_0x237f4c[_0x5df6('0x4b')],null))['then'](respondWithResult(_0x1a783e,null))['catch'](handleError(_0x1a783e,null));};exports[_0x5df6('0x23')]=function(_0x1edfb7,_0x4967bb){return db[_0x5df6('0x2a')][_0x5df6('0x49')]({'where':{'id':_0x1edfb7[_0x5df6('0x44')]['id']}})[_0x5df6('0x3f')](handleEntityNotFound(_0x4967bb,null))[_0x5df6('0x3f')](removeEntity(_0x4967bb,null))[_0x5df6('0x4c')](handleError(_0x4967bb,null));};exports[_0x5df6('0x4d')]=function(_0x6beec1,_0x46de68,_0x1d3feb){var _0x5dc51c={};var _0x40f2e5={};var _0x1b75cc;var _0x3ca3f5;return db[_0x5df6('0x2a')][_0x5df6('0x4e')]({'where':{'id':_0x6beec1[_0x5df6('0x44')]['id']}})[_0x5df6('0x3f')](handleEntityNotFound(_0x46de68,null))['then'](function(_0x565481){if(_0x565481){_0x1b75cc=_0x565481;_0x40f2e5[_0x5df6('0x2e')]=_[_0x5df6('0x30')](db[_0x5df6('0x4f')][_0x5df6('0x45')]);_0x40f2e5[_0x5df6('0x33')]=_[_0x5df6('0x30')](_0x6beec1[_0x5df6('0x33')]);_0x40f2e5['filters']=_[_0x5df6('0x32')](_0x40f2e5[_0x5df6('0x2e')],_0x40f2e5['query']);_0x5dc51c[_0x5df6('0x34')]=_[_0x5df6('0x32')](_0x40f2e5['model'],qs[_0x5df6('0x46')](_0x6beec1[_0x5df6('0x33')][_0x5df6('0x46')]));_0x5dc51c['attributes']=_0x5dc51c[_0x5df6('0x34')][_0x5df6('0x35')]?_0x5dc51c[_0x5df6('0x34')]:_0x40f2e5[_0x5df6('0x2e')];_0x5dc51c[_0x5df6('0x38')]=qs['sort'](_0x6beec1['query']['sort']);_0x5dc51c[_0x5df6('0x3a')]=qs[_0x5df6('0x31')](_[_0x5df6('0x3b')](_0x6beec1['query'],_0x40f2e5[_0x5df6('0x31')]));if(_0x6beec1['query'][_0x5df6('0x3c')]){_0x5dc51c[_0x5df6('0x3a')]=_[_0x5df6('0x3e')](_0x5dc51c[_0x5df6('0x3a')],{'$or':_['map'](_0x5dc51c['attributes'],function(_0x4ac672){var _0x3053c1={};_0x3053c1[_0x4ac672]={'$like':'%'+_0x6beec1[_0x5df6('0x33')][_0x5df6('0x3c')]+'%'};return _0x3053c1;})});}_0x5dc51c=_[_0x5df6('0x3e')]({},_0x5dc51c,_0x6beec1[_0x5df6('0x48')]);return _0x1b75cc[_0x5df6('0x4d')](_0x5dc51c);}})[_0x5df6('0x3f')](function(_0x348fc3){if(_0x348fc3){_0x3ca3f5=_0x348fc3['length'];if(!_0x6beec1['query'][_0x5df6('0x36')](_0x5df6('0x37'))){_0x5dc51c[_0x5df6('0x1d')]=qs[_0x5df6('0x1d')](_0x6beec1[_0x5df6('0x33')][_0x5df6('0x1d')]);_0x5dc51c[_0x5df6('0x1b')]=qs[_0x5df6('0x1b')](_0x6beec1[_0x5df6('0x33')]['offset']);}return _0x1b75cc['getFields'](_0x5dc51c);}})[_0x5df6('0x3f')](function(_0x97fffa){if(_0x97fffa){return _0x97fffa?{'count':_0x3ca3f5,'rows':_0x97fffa}:null;}})[_0x5df6('0x3f')](respondWithResult(_0x46de68,null))[_0x5df6('0x4c')](handleError(_0x46de68,null));};exports['getSubjects']=function(_0x5a189a,_0x3fd0b5,_0x390f9f){var _0x4b6237={};var _0x5e736e={};var _0x751c82;var _0xb273e;return db[_0x5df6('0x2a')][_0x5df6('0x4e')]({'where':{'id':_0x5a189a[_0x5df6('0x44')]['id']}})['then'](handleEntityNotFound(_0x3fd0b5,null))[_0x5df6('0x3f')](function(_0x41b3a7){if(_0x41b3a7){_0x751c82=_0x41b3a7;_0x5e736e[_0x5df6('0x2e')]=_[_0x5df6('0x30')](db['SugarcrmField'][_0x5df6('0x45')]);_0x5e736e[_0x5df6('0x33')]=_[_0x5df6('0x30')](_0x5a189a['query']);_0x5e736e[_0x5df6('0x31')]=_[_0x5df6('0x32')](_0x5e736e[_0x5df6('0x2e')],_0x5e736e[_0x5df6('0x33')]);_0x4b6237['attributes']=_['intersection'](_0x5e736e[_0x5df6('0x2e')],qs[_0x5df6('0x46')](_0x5a189a[_0x5df6('0x33')][_0x5df6('0x46')]));_0x4b6237[_0x5df6('0x34')]=_0x4b6237['attributes']['length']?_0x4b6237['attributes']:_0x5e736e[_0x5df6('0x2e')];_0x4b6237[_0x5df6('0x38')]=qs[_0x5df6('0x39')](_0x5a189a[_0x5df6('0x33')][_0x5df6('0x39')]);_0x4b6237['where']=qs['filters'](_[_0x5df6('0x3b')](_0x5a189a['query'],_0x5e736e[_0x5df6('0x31')]));if(_0x5a189a[_0x5df6('0x33')]['filter']){_0x4b6237['where']=_['merge'](_0x4b6237[_0x5df6('0x3a')],{'$or':_[_0x5df6('0x2f')](_0x4b6237['attributes'],function(_0x4ba447){var _0x5b8760={};_0x5b8760[_0x4ba447]={'$like':'%'+_0x5a189a[_0x5df6('0x33')][_0x5df6('0x3c')]+'%'};return _0x5b8760;})});}_0x4b6237=_[_0x5df6('0x3e')]({},_0x4b6237,_0x5a189a[_0x5df6('0x48')]);return _0x751c82[_0x5df6('0x50')](_0x4b6237);}})[_0x5df6('0x3f')](function(_0x3eebe4){if(_0x3eebe4){_0xb273e=_0x3eebe4['length'];if(!_0x5a189a[_0x5df6('0x33')]['hasOwnProperty'](_0x5df6('0x37'))){_0x4b6237[_0x5df6('0x1d')]=qs[_0x5df6('0x1d')](_0x5a189a[_0x5df6('0x33')][_0x5df6('0x1d')]);_0x4b6237[_0x5df6('0x1b')]=qs[_0x5df6('0x1b')](_0x5a189a[_0x5df6('0x33')][_0x5df6('0x1b')]);}return _0x751c82[_0x5df6('0x50')](_0x4b6237);}})[_0x5df6('0x3f')](function(_0xba102c){if(_0xba102c){return _0xba102c?{'count':_0xb273e,'rows':_0xba102c}:null;}})[_0x5df6('0x3f')](respondWithResult(_0x3fd0b5,null))[_0x5df6('0x4c')](handleError(_0x3fd0b5,null));};exports[_0x5df6('0x51')]=function(_0x27e596,_0x1597a4,_0x1641cc){var _0x3aeb80={};var _0x234c1f={};var _0x52ea14;var _0x3f06e2;return db[_0x5df6('0x2a')][_0x5df6('0x4e')]({'where':{'id':_0x27e596[_0x5df6('0x44')]['id']}})[_0x5df6('0x3f')](handleEntityNotFound(_0x1597a4,null))[_0x5df6('0x3f')](function(_0x30e721){if(_0x30e721){_0x52ea14=_0x30e721;_0x234c1f[_0x5df6('0x2e')]=_[_0x5df6('0x30')](db[_0x5df6('0x4f')]['rawAttributes']);_0x234c1f['query']=_['keys'](_0x27e596['query']);_0x234c1f['filters']=_[_0x5df6('0x32')](_0x234c1f[_0x5df6('0x2e')],_0x234c1f[_0x5df6('0x33')]);_0x3aeb80[_0x5df6('0x34')]=_[_0x5df6('0x32')](_0x234c1f['model'],qs[_0x5df6('0x46')](_0x27e596['query'][_0x5df6('0x46')]));_0x3aeb80[_0x5df6('0x34')]=_0x3aeb80['attributes'][_0x5df6('0x35')]?_0x3aeb80[_0x5df6('0x34')]:_0x234c1f['model'];_0x3aeb80[_0x5df6('0x38')]=qs[_0x5df6('0x39')](_0x27e596[_0x5df6('0x33')][_0x5df6('0x39')]);_0x3aeb80[_0x5df6('0x3a')]=qs['filters'](_['pick'](_0x27e596['query'],_0x234c1f['filters']));if(_0x27e596[_0x5df6('0x33')][_0x5df6('0x3c')]){_0x3aeb80[_0x5df6('0x3a')]=_[_0x5df6('0x3e')](_0x3aeb80[_0x5df6('0x3a')],{'$or':_[_0x5df6('0x2f')](_0x3aeb80['attributes'],function(_0x14c4f1){var _0x28fc43={};_0x28fc43[_0x14c4f1]={'$like':'%'+_0x27e596[_0x5df6('0x33')][_0x5df6('0x3c')]+'%'};return _0x28fc43;})});}_0x3aeb80=_[_0x5df6('0x3e')]({},_0x3aeb80,_0x27e596['options']);return _0x52ea14[_0x5df6('0x51')](_0x3aeb80);}})[_0x5df6('0x3f')](function(_0x49125b){if(_0x49125b){_0x3f06e2=_0x49125b[_0x5df6('0x35')];if(!_0x27e596[_0x5df6('0x33')]['hasOwnProperty'](_0x5df6('0x37'))){_0x3aeb80[_0x5df6('0x1d')]=qs[_0x5df6('0x1d')](_0x27e596[_0x5df6('0x33')]['limit']);_0x3aeb80['offset']=qs['offset'](_0x27e596[_0x5df6('0x33')][_0x5df6('0x1b')]);}return _0x52ea14[_0x5df6('0x51')](_0x3aeb80);}})[_0x5df6('0x3f')](function(_0x5504c9){if(_0x5504c9){return _0x5504c9?{'count':_0x3f06e2,'rows':_0x5504c9}:null;}})['then'](respondWithResult(_0x1597a4,null))['catch'](handleError(_0x1597a4,null));};