b1248be1cdef35974b2f4ee9441274efcc9dd178
[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 _0x31d0=['util','path','sox','to-csv','ejs','fs-extra','squel','crypto','querystring','papaparse','ioredis','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','undefined','limit','count','offset','set','Content-Range','json','apply','reject','save','update','then','destroy','stack','name','index','SugarcrmConfiguration','rawAttributes','fieldName','key','model','map','query','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','where','filters','type','filter','merge','options','includeAll','findAll','rows','catch','show','params','keys','length','include','find','create','body','getFields','findOne','SugarcrmField','pick','getSubjects','getDescriptions','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache'];(function(_0x2c293b,_0x9cf42d){var _0x55253c=function(_0x13bf0a){while(--_0x13bf0a){_0x2c293b['push'](_0x2c293b['shift']());}};_0x55253c(++_0x9cf42d);}(_0x31d0,0x145));var _0x031d=function(_0x1b8e60,_0x21b885){_0x1b8e60=_0x1b8e60-0x0;var _0x363363=_0x31d0[_0x1b8e60];return _0x363363;};'use strict';var emlformat=require(_0x031d('0x0'));var rimraf=require(_0x031d('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x031d('0x2'));var rp=require(_0x031d('0x3'));var moment=require(_0x031d('0x4'));var BPromise=require(_0x031d('0x5'));var Mustache=require(_0x031d('0x6'));var util=require(_0x031d('0x7'));var path=require(_0x031d('0x8'));var sox=require(_0x031d('0x9'));var csv=require(_0x031d('0xa'));var ejs=require(_0x031d('0xb'));var fs=require('fs');var fs_extra=require(_0x031d('0xc'));var _=require('lodash');var squel=require(_0x031d('0xd'));var crypto=require(_0x031d('0xe'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0x031d('0xf'));var Papa=require(_0x031d('0x10'));var Redis=require(_0x031d('0x11'));var authService=require('../../components/auth/service');var qs=require(_0x031d('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x031d('0x13'));var logger=require(_0x031d('0x14'))(_0x031d('0x15'));var utils=require(_0x031d('0x16'));var config=require(_0x031d('0x17'));var licenseUtil=require(_0x031d('0x18'));var db=require(_0x031d('0x19'))['db'];function respondWithStatusCode(_0xe5dafa,_0x4e8181){_0x4e8181=_0x4e8181||0xcc;return function(_0x4239d7){if(_0x4239d7){return _0xe5dafa[_0x031d('0x1a')](_0x4e8181);}return _0xe5dafa[_0x031d('0x1b')](_0x4e8181)[_0x031d('0x1c')]();};}function respondWithResult(_0x4f2bd2,_0xc20d40){_0xc20d40=_0xc20d40||0xc8;return function(_0x5ae4ff){if(_0x5ae4ff){return _0x4f2bd2[_0x031d('0x1b')](_0xc20d40)['json'](_0x5ae4ff);}};}function respondWithFilteredResult(_0x44b06a,_0x5c83fb){return function(_0x54520f){if(_0x54520f){var _0x5a9736=typeof _0x5c83fb['offset']===_0x031d('0x1d')&&typeof _0x5c83fb[_0x031d('0x1e')]===_0x031d('0x1d');var _0x7b3356=_0x54520f[_0x031d('0x1f')];var _0x3f1ff9=_0x5a9736?0x0:_0x5c83fb['offset'];var _0x45969d=_0x5a9736?_0x54520f['count']:_0x5c83fb[_0x031d('0x20')]+_0x5c83fb[_0x031d('0x1e')];var _0xb21e46;if(_0x45969d>=_0x7b3356){_0x45969d=_0x7b3356;_0xb21e46=0xc8;}else{_0xb21e46=0xce;}_0x44b06a['status'](_0xb21e46);return _0x44b06a[_0x031d('0x21')](_0x031d('0x22'),_0x3f1ff9+'-'+_0x45969d+'/'+_0x7b3356)[_0x031d('0x23')](_0x54520f);}return null;};}function patchUpdates(_0xbf0fcc){return function(_0x46a1dc){try{jsonpatch[_0x031d('0x24')](_0x46a1dc,_0xbf0fcc,!![]);}catch(_0x2dee0c){return BPromise[_0x031d('0x25')](_0x2dee0c);}return _0x46a1dc[_0x031d('0x26')]();};}function saveUpdates(_0x439f78,_0xc6a29a){return function(_0x2b5671){if(_0x2b5671){return _0x2b5671[_0x031d('0x27')](_0x439f78)[_0x031d('0x28')](function(_0x223edf){return _0x223edf;});}return null;};}function removeEntity(_0x477e7f,_0x2ae838){return function(_0x2a2c9f){if(_0x2a2c9f){return _0x2a2c9f[_0x031d('0x29')]()['then'](function(){_0x477e7f[_0x031d('0x1b')](0xcc)[_0x031d('0x1c')]();});}};}function handleEntityNotFound(_0x398511,_0x2d125c){return function(_0x21107b){if(!_0x21107b){_0x398511[_0x031d('0x1a')](0x194);}return _0x21107b;};}function handleError(_0x1fd1a4,_0x104390){_0x104390=_0x104390||0x1f4;return function(_0x149169){logger['error'](_0x149169[_0x031d('0x2a')]);if(_0x149169['name']){delete _0x149169[_0x031d('0x2b')];}_0x1fd1a4[_0x031d('0x1b')](_0x104390)['send'](_0x149169);};}exports[_0x031d('0x2c')]=function(_0x56ab56,_0x55e548){var _0x507a13={},_0x37d8f9={},_0x477594={'count':0x0,'rows':[]};var _0x127022=_['map'](db[_0x031d('0x2d')][_0x031d('0x2e')],function(_0x314b9f){return{'name':_0x314b9f[_0x031d('0x2f')],'type':_0x314b9f['type'][_0x031d('0x30')]};});_0x37d8f9[_0x031d('0x31')]=_[_0x031d('0x32')](_0x127022,_0x031d('0x2b'));_0x37d8f9[_0x031d('0x33')]=_['keys'](_0x56ab56[_0x031d('0x33')]);_0x37d8f9['filters']=_[_0x031d('0x34')](_0x37d8f9[_0x031d('0x31')],_0x37d8f9[_0x031d('0x33')]);_0x507a13[_0x031d('0x35')]=_[_0x031d('0x34')](_0x37d8f9[_0x031d('0x31')],qs[_0x031d('0x36')](_0x56ab56[_0x031d('0x33')][_0x031d('0x36')]));_0x507a13[_0x031d('0x35')]=_0x507a13[_0x031d('0x35')]['length']?_0x507a13[_0x031d('0x35')]:_0x37d8f9[_0x031d('0x31')];if(!_0x56ab56[_0x031d('0x33')][_0x031d('0x37')](_0x031d('0x38'))){_0x507a13[_0x031d('0x1e')]=qs['limit'](_0x56ab56[_0x031d('0x33')][_0x031d('0x1e')]);_0x507a13['offset']=qs[_0x031d('0x20')](_0x56ab56[_0x031d('0x33')][_0x031d('0x20')]);}_0x507a13[_0x031d('0x39')]=qs[_0x031d('0x3a')](_0x56ab56[_0x031d('0x33')][_0x031d('0x3a')]);_0x507a13[_0x031d('0x3b')]=qs[_0x031d('0x3c')](_['pick'](_0x56ab56[_0x031d('0x33')],_0x37d8f9[_0x031d('0x3c')]),_0x127022);if(_0x56ab56[_0x031d('0x33')]['filter']){_0x507a13[_0x031d('0x3b')]=_['merge'](_0x507a13[_0x031d('0x3b')],{'$or':_['map'](_0x127022,function(_0x4f1fad){if(_0x4f1fad[_0x031d('0x3d')]!=='VIRTUAL'){var _0x171980={};_0x171980[_0x4f1fad[_0x031d('0x2b')]]={'$like':'%'+_0x56ab56[_0x031d('0x33')][_0x031d('0x3e')]+'%'};return _0x171980;}})});}_0x507a13=_[_0x031d('0x3f')]({},_0x507a13,_0x56ab56[_0x031d('0x40')]);var _0x4a8c7b={'where':_0x507a13[_0x031d('0x3b')]};return db[_0x031d('0x2d')][_0x031d('0x1f')](_0x4a8c7b)[_0x031d('0x28')](function(_0x2eb4ce){_0x477594['count']=_0x2eb4ce;if(_0x56ab56[_0x031d('0x33')][_0x031d('0x41')]){_0x507a13['include']=[{'all':!![]}];}return db[_0x031d('0x2d')][_0x031d('0x42')](_0x507a13);})[_0x031d('0x28')](function(_0x22cd52){_0x477594[_0x031d('0x43')]=_0x22cd52;return _0x477594;})[_0x031d('0x28')](respondWithFilteredResult(_0x55e548,_0x507a13))[_0x031d('0x44')](handleError(_0x55e548,null));};exports[_0x031d('0x45')]=function(_0x136d4a,_0x24cfc3){var _0x59cc1d={'raw':![],'where':{'id':_0x136d4a[_0x031d('0x46')]['id']}},_0x36e243={};_0x36e243['model']=_[_0x031d('0x47')](db[_0x031d('0x2d')][_0x031d('0x2e')]);_0x36e243[_0x031d('0x33')]=_[_0x031d('0x47')](_0x136d4a['query']);_0x36e243['filters']=_[_0x031d('0x34')](_0x36e243[_0x031d('0x31')],_0x36e243['query']);_0x59cc1d['attributes']=_[_0x031d('0x34')](_0x36e243[_0x031d('0x31')],qs[_0x031d('0x36')](_0x136d4a['query'][_0x031d('0x36')]));_0x59cc1d[_0x031d('0x35')]=_0x59cc1d['attributes'][_0x031d('0x48')]?_0x59cc1d[_0x031d('0x35')]:_0x36e243[_0x031d('0x31')];if(_0x136d4a[_0x031d('0x33')][_0x031d('0x41')]){_0x59cc1d[_0x031d('0x49')]=[{'all':!![]}];}_0x59cc1d=_[_0x031d('0x3f')]({},_0x59cc1d,_0x136d4a[_0x031d('0x40')]);return db[_0x031d('0x2d')][_0x031d('0x4a')](_0x59cc1d)[_0x031d('0x28')](handleEntityNotFound(_0x24cfc3,null))[_0x031d('0x28')](respondWithResult(_0x24cfc3,null))[_0x031d('0x44')](handleError(_0x24cfc3,null));};exports['create']=function(_0x23e729,_0xe3030c){return db['SugarcrmConfiguration'][_0x031d('0x4b')](_0x23e729['body'],{})[_0x031d('0x28')](respondWithResult(_0xe3030c,0xc9))[_0x031d('0x44')](handleError(_0xe3030c,null));};exports[_0x031d('0x27')]=function(_0x4e42df,_0x3aef43){if(_0x4e42df[_0x031d('0x4c')]['id']){delete _0x4e42df[_0x031d('0x4c')]['id'];}return db[_0x031d('0x2d')][_0x031d('0x4a')]({'where':{'id':_0x4e42df['params']['id']}})[_0x031d('0x28')](handleEntityNotFound(_0x3aef43,null))['then'](saveUpdates(_0x4e42df['body'],null))[_0x031d('0x28')](respondWithResult(_0x3aef43,null))['catch'](handleError(_0x3aef43,null));};exports[_0x031d('0x29')]=function(_0x3b2b2e,_0x526ba2){return db[_0x031d('0x2d')][_0x031d('0x4a')]({'where':{'id':_0x3b2b2e[_0x031d('0x46')]['id']}})[_0x031d('0x28')](handleEntityNotFound(_0x526ba2,null))['then'](removeEntity(_0x526ba2,null))[_0x031d('0x44')](handleError(_0x526ba2,null));};exports[_0x031d('0x4d')]=function(_0x239cdb,_0x5e2dc8,_0x4b7d67){var _0x1e4d37={};var _0x568407={};var _0x174c8b;var _0x1f07ac;return db[_0x031d('0x2d')][_0x031d('0x4e')]({'where':{'id':_0x239cdb[_0x031d('0x46')]['id']}})['then'](handleEntityNotFound(_0x5e2dc8,null))[_0x031d('0x28')](function(_0x484f30){if(_0x484f30){_0x174c8b=_0x484f30;_0x568407['model']=_[_0x031d('0x47')](db[_0x031d('0x4f')]['rawAttributes']);_0x568407['query']=_[_0x031d('0x47')](_0x239cdb[_0x031d('0x33')]);_0x568407[_0x031d('0x3c')]=_[_0x031d('0x34')](_0x568407[_0x031d('0x31')],_0x568407[_0x031d('0x33')]);_0x1e4d37['attributes']=_['intersection'](_0x568407['model'],qs[_0x031d('0x36')](_0x239cdb['query'][_0x031d('0x36')]));_0x1e4d37['attributes']=_0x1e4d37[_0x031d('0x35')][_0x031d('0x48')]?_0x1e4d37[_0x031d('0x35')]:_0x568407['model'];_0x1e4d37['order']=qs['sort'](_0x239cdb['query']['sort']);_0x1e4d37[_0x031d('0x3b')]=qs[_0x031d('0x3c')](_[_0x031d('0x50')](_0x239cdb[_0x031d('0x33')],_0x568407['filters']));if(_0x239cdb[_0x031d('0x33')]['filter']){_0x1e4d37['where']=_[_0x031d('0x3f')](_0x1e4d37[_0x031d('0x3b')],{'$or':_['map'](_0x1e4d37[_0x031d('0x35')],function(_0x1ca47f){var _0x19f25a={};_0x19f25a[_0x1ca47f]={'$like':'%'+_0x239cdb['query']['filter']+'%'};return _0x19f25a;})});}_0x1e4d37=_[_0x031d('0x3f')]({},_0x1e4d37,_0x239cdb['options']);return _0x174c8b[_0x031d('0x4d')](_0x1e4d37);}})['then'](function(_0x38e9ea){if(_0x38e9ea){_0x1f07ac=_0x38e9ea[_0x031d('0x48')];if(!_0x239cdb[_0x031d('0x33')][_0x031d('0x37')](_0x031d('0x38'))){_0x1e4d37[_0x031d('0x1e')]=qs[_0x031d('0x1e')](_0x239cdb[_0x031d('0x33')][_0x031d('0x1e')]);_0x1e4d37[_0x031d('0x20')]=qs[_0x031d('0x20')](_0x239cdb[_0x031d('0x33')]['offset']);}return _0x174c8b['getFields'](_0x1e4d37);}})[_0x031d('0x28')](function(_0x43dff2){if(_0x43dff2){return _0x43dff2?{'count':_0x1f07ac,'rows':_0x43dff2}:null;}})['then'](respondWithResult(_0x5e2dc8,null))['catch'](handleError(_0x5e2dc8,null));};exports[_0x031d('0x51')]=function(_0x34f468,_0x51cd3f,_0x4615dc){var _0x5f1c1e={};var _0x4226c2={};var _0x5d870d;var _0x1b093a;return db[_0x031d('0x2d')][_0x031d('0x4e')]({'where':{'id':_0x34f468[_0x031d('0x46')]['id']}})[_0x031d('0x28')](handleEntityNotFound(_0x51cd3f,null))[_0x031d('0x28')](function(_0x34a1b9){if(_0x34a1b9){_0x5d870d=_0x34a1b9;_0x4226c2[_0x031d('0x31')]=_[_0x031d('0x47')](db['SugarcrmField']['rawAttributes']);_0x4226c2[_0x031d('0x33')]=_[_0x031d('0x47')](_0x34f468[_0x031d('0x33')]);_0x4226c2['filters']=_['intersection'](_0x4226c2[_0x031d('0x31')],_0x4226c2[_0x031d('0x33')]);_0x5f1c1e['attributes']=_[_0x031d('0x34')](_0x4226c2[_0x031d('0x31')],qs[_0x031d('0x36')](_0x34f468[_0x031d('0x33')][_0x031d('0x36')]));_0x5f1c1e['attributes']=_0x5f1c1e[_0x031d('0x35')]['length']?_0x5f1c1e[_0x031d('0x35')]:_0x4226c2[_0x031d('0x31')];_0x5f1c1e[_0x031d('0x39')]=qs[_0x031d('0x3a')](_0x34f468['query'][_0x031d('0x3a')]);_0x5f1c1e['where']=qs['filters'](_[_0x031d('0x50')](_0x34f468[_0x031d('0x33')],_0x4226c2[_0x031d('0x3c')]));if(_0x34f468['query'][_0x031d('0x3e')]){_0x5f1c1e[_0x031d('0x3b')]=_[_0x031d('0x3f')](_0x5f1c1e[_0x031d('0x3b')],{'$or':_[_0x031d('0x32')](_0x5f1c1e['attributes'],function(_0xdbca98){var _0x46e333={};_0x46e333[_0xdbca98]={'$like':'%'+_0x34f468[_0x031d('0x33')][_0x031d('0x3e')]+'%'};return _0x46e333;})});}_0x5f1c1e=_['merge']({},_0x5f1c1e,_0x34f468['options']);return _0x5d870d[_0x031d('0x51')](_0x5f1c1e);}})['then'](function(_0x4fd86b){if(_0x4fd86b){_0x1b093a=_0x4fd86b['length'];if(!_0x34f468[_0x031d('0x33')]['hasOwnProperty'](_0x031d('0x38'))){_0x5f1c1e[_0x031d('0x1e')]=qs['limit'](_0x34f468[_0x031d('0x33')][_0x031d('0x1e')]);_0x5f1c1e[_0x031d('0x20')]=qs['offset'](_0x34f468['query'][_0x031d('0x20')]);}return _0x5d870d[_0x031d('0x51')](_0x5f1c1e);}})[_0x031d('0x28')](function(_0x35d903){if(_0x35d903){return _0x35d903?{'count':_0x1b093a,'rows':_0x35d903}:null;}})[_0x031d('0x28')](respondWithResult(_0x51cd3f,null))['catch'](handleError(_0x51cd3f,null));};exports[_0x031d('0x52')]=function(_0x2a6aa9,_0x541baa,_0x30a9e7){var _0x4f384f={};var _0x21c56d={};var _0x5488fb;var _0x13b8ae;return db[_0x031d('0x2d')]['findOne']({'where':{'id':_0x2a6aa9['params']['id']}})['then'](handleEntityNotFound(_0x541baa,null))[_0x031d('0x28')](function(_0x497b3d){if(_0x497b3d){_0x5488fb=_0x497b3d;_0x21c56d[_0x031d('0x31')]=_[_0x031d('0x47')](db[_0x031d('0x4f')][_0x031d('0x2e')]);_0x21c56d[_0x031d('0x33')]=_[_0x031d('0x47')](_0x2a6aa9['query']);_0x21c56d[_0x031d('0x3c')]=_[_0x031d('0x34')](_0x21c56d[_0x031d('0x31')],_0x21c56d[_0x031d('0x33')]);_0x4f384f['attributes']=_[_0x031d('0x34')](_0x21c56d[_0x031d('0x31')],qs[_0x031d('0x36')](_0x2a6aa9['query']['fields']));_0x4f384f[_0x031d('0x35')]=_0x4f384f['attributes'][_0x031d('0x48')]?_0x4f384f[_0x031d('0x35')]:_0x21c56d[_0x031d('0x31')];_0x4f384f['order']=qs[_0x031d('0x3a')](_0x2a6aa9['query'][_0x031d('0x3a')]);_0x4f384f['where']=qs['filters'](_[_0x031d('0x50')](_0x2a6aa9['query'],_0x21c56d[_0x031d('0x3c')]));if(_0x2a6aa9[_0x031d('0x33')][_0x031d('0x3e')]){_0x4f384f['where']=_[_0x031d('0x3f')](_0x4f384f[_0x031d('0x3b')],{'$or':_[_0x031d('0x32')](_0x4f384f[_0x031d('0x35')],function(_0x1a9488){var _0x516b2d={};_0x516b2d[_0x1a9488]={'$like':'%'+_0x2a6aa9[_0x031d('0x33')][_0x031d('0x3e')]+'%'};return _0x516b2d;})});}_0x4f384f=_[_0x031d('0x3f')]({},_0x4f384f,_0x2a6aa9['options']);return _0x5488fb['getDescriptions'](_0x4f384f);}})[_0x031d('0x28')](function(_0x5692e5){if(_0x5692e5){_0x13b8ae=_0x5692e5[_0x031d('0x48')];if(!_0x2a6aa9[_0x031d('0x33')]['hasOwnProperty'](_0x031d('0x38'))){_0x4f384f[_0x031d('0x1e')]=qs['limit'](_0x2a6aa9[_0x031d('0x33')][_0x031d('0x1e')]);_0x4f384f[_0x031d('0x20')]=qs[_0x031d('0x20')](_0x2a6aa9['query'][_0x031d('0x20')]);}return _0x5488fb[_0x031d('0x52')](_0x4f384f);}})[_0x031d('0x28')](function(_0x57f98f){if(_0x57f98f){return _0x57f98f?{'count':_0x13b8ae,'rows':_0x57f98f}:null;}})[_0x031d('0x28')](respondWithResult(_0x541baa,null))[_0x031d('0x44')](handleError(_0x541baa,null));};