Built motion from commit 953226e6.|2.6.32
[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 _0x04c6=['save','update','then','destroy','sendStatus','stack','name','SugarcrmConfiguration','rawAttributes','fieldName','type','model','map','query','keys','intersection','fields','attributes','hasOwnProperty','nolimit','order','sort','where','pick','merge','VIRTUAL','filter','options','findAll','catch','show','params','filters','length','includeAll','create','body','find','getFields','findOne','getSubjects','getDescriptions','SugarcrmField','eml-format','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','to-csv','ejs','fs-extra','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/license/util','../../mysqldb','status','end','json','offset','undefined','limit','count','set'];(function(_0x1626ac,_0x517818){var _0x3753ef=function(_0x4a9113){while(--_0x4a9113){_0x1626ac['push'](_0x1626ac['shift']());}};_0x3753ef(++_0x517818);}(_0x04c6,0x14f));var _0x604c=function(_0x4ec0c5,_0xbbb1d0){_0x4ec0c5=_0x4ec0c5-0x0;var _0x58a74e=_0x04c6[_0x4ec0c5];return _0x58a74e;};'use strict';var emlformat=require(_0x604c('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x604c('0x1'));var jsonpatch=require(_0x604c('0x2'));var rp=require(_0x604c('0x3'));var moment=require(_0x604c('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x604c('0x5'));var util=require(_0x604c('0x6'));var path=require(_0x604c('0x7'));var sox=require('sox');var csv=require(_0x604c('0x8'));var ejs=require(_0x604c('0x9'));var fs=require('fs');var fs_extra=require(_0x604c('0xa'));var _=require('lodash');var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x604c('0xb'));var deskjs=require('desk.js');var toCsv=require(_0x604c('0x8'));var querystring=require(_0x604c('0xc'));var Papa=require(_0x604c('0xd'));var Redis=require(_0x604c('0xe'));var authService=require(_0x604c('0xf'));var qs=require(_0x604c('0x10'));var as=require(_0x604c('0x11'));var hardwareService=require(_0x604c('0x12'));var logger=require('../../config/logger')(_0x604c('0x13'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0x604c('0x14'));var db=require(_0x604c('0x15'))['db'];function respondWithStatusCode(_0x526337,_0x5b2c7a){_0x5b2c7a=_0x5b2c7a||0xcc;return function(_0xc9fa56){if(_0xc9fa56){return _0x526337['sendStatus'](_0x5b2c7a);}return _0x526337[_0x604c('0x16')](_0x5b2c7a)[_0x604c('0x17')]();};}function respondWithResult(_0x41cd76,_0x45e596){_0x45e596=_0x45e596||0xc8;return function(_0x4e0533){if(_0x4e0533){return _0x41cd76[_0x604c('0x16')](_0x45e596)[_0x604c('0x18')](_0x4e0533);}};}function respondWithFilteredResult(_0xc55e97,_0x5d3ce0){return function(_0x5f5279){if(_0x5f5279){var _0x4ebb56=typeof _0x5d3ce0[_0x604c('0x19')]===_0x604c('0x1a')&&typeof _0x5d3ce0[_0x604c('0x1b')]===_0x604c('0x1a');var _0x15db3c=_0x5f5279['count'];var _0x52ef0c=_0x4ebb56?0x0:_0x5d3ce0[_0x604c('0x19')];var _0x5c1f67=_0x4ebb56?_0x5f5279[_0x604c('0x1c')]:_0x5d3ce0[_0x604c('0x19')]+_0x5d3ce0[_0x604c('0x1b')];var _0x5d1864;if(_0x5c1f67>=_0x15db3c){_0x5c1f67=_0x15db3c;_0x5d1864=0xc8;}else{_0x5d1864=0xce;}_0xc55e97[_0x604c('0x16')](_0x5d1864);return _0xc55e97[_0x604c('0x1d')]('Content-Range',_0x52ef0c+'-'+_0x5c1f67+'/'+_0x15db3c)[_0x604c('0x18')](_0x5f5279);}return null;};}function patchUpdates(_0xb4e7ab){return function(_0x1ea5c4){try{jsonpatch['apply'](_0x1ea5c4,_0xb4e7ab,!![]);}catch(_0x184381){return BPromise['reject'](_0x184381);}return _0x1ea5c4[_0x604c('0x1e')]();};}function saveUpdates(_0x197029,_0x1fdde8){return function(_0x4fab8e){if(_0x4fab8e){return _0x4fab8e[_0x604c('0x1f')](_0x197029)[_0x604c('0x20')](function(_0x9fed63){return _0x9fed63;});}return null;};}function removeEntity(_0x172d9b,_0x295ed9){return function(_0x232edd){if(_0x232edd){return _0x232edd[_0x604c('0x21')]()[_0x604c('0x20')](function(){_0x172d9b[_0x604c('0x16')](0xcc)[_0x604c('0x17')]();});}};}function handleEntityNotFound(_0x3e9ab7,_0x5ab8ba){return function(_0x45bdd7){if(!_0x45bdd7){_0x3e9ab7[_0x604c('0x22')](0x194);}return _0x45bdd7;};}function handleError(_0x314024,_0x4ade75){_0x4ade75=_0x4ade75||0x1f4;return function(_0x38a070){logger['error'](_0x38a070[_0x604c('0x23')]);if(_0x38a070[_0x604c('0x24')]){delete _0x38a070['name'];}_0x314024['status'](_0x4ade75)['send'](_0x38a070);};}exports['index']=function(_0x25e1dc,_0x3b1386){var _0x2904dc={},_0x4838ff={},_0x1d3d50={'count':0x0,'rows':[]};var _0x117424=_['map'](db[_0x604c('0x25')][_0x604c('0x26')],function(_0x496aac){return{'name':_0x496aac[_0x604c('0x27')],'type':_0x496aac[_0x604c('0x28')]['key']};});_0x4838ff[_0x604c('0x29')]=_[_0x604c('0x2a')](_0x117424,_0x604c('0x24'));_0x4838ff[_0x604c('0x2b')]=_[_0x604c('0x2c')](_0x25e1dc[_0x604c('0x2b')]);_0x4838ff['filters']=_[_0x604c('0x2d')](_0x4838ff[_0x604c('0x29')],_0x4838ff['query']);_0x2904dc['attributes']=_[_0x604c('0x2d')](_0x4838ff['model'],qs[_0x604c('0x2e')](_0x25e1dc[_0x604c('0x2b')][_0x604c('0x2e')]));_0x2904dc[_0x604c('0x2f')]=_0x2904dc[_0x604c('0x2f')]['length']?_0x2904dc[_0x604c('0x2f')]:_0x4838ff[_0x604c('0x29')];if(!_0x25e1dc[_0x604c('0x2b')][_0x604c('0x30')](_0x604c('0x31'))){_0x2904dc[_0x604c('0x1b')]=qs[_0x604c('0x1b')](_0x25e1dc[_0x604c('0x2b')]['limit']);_0x2904dc[_0x604c('0x19')]=qs['offset'](_0x25e1dc['query']['offset']);}_0x2904dc[_0x604c('0x32')]=qs[_0x604c('0x33')](_0x25e1dc['query'][_0x604c('0x33')]);_0x2904dc[_0x604c('0x34')]=qs['filters'](_[_0x604c('0x35')](_0x25e1dc[_0x604c('0x2b')],_0x4838ff['filters']),_0x117424);if(_0x25e1dc[_0x604c('0x2b')]['filter']){_0x2904dc['where']=_[_0x604c('0x36')](_0x2904dc[_0x604c('0x34')],{'$or':_['map'](_0x117424,function(_0xa4effc){if(_0xa4effc[_0x604c('0x28')]!==_0x604c('0x37')){var _0xce6686={};_0xce6686[_0xa4effc[_0x604c('0x24')]]={'$like':'%'+_0x25e1dc['query'][_0x604c('0x38')]+'%'};return _0xce6686;}})});}_0x2904dc=_['merge']({},_0x2904dc,_0x25e1dc[_0x604c('0x39')]);var _0x39e119={'where':_0x2904dc[_0x604c('0x34')]};return db[_0x604c('0x25')][_0x604c('0x1c')](_0x39e119)[_0x604c('0x20')](function(_0x4ccf82){_0x1d3d50[_0x604c('0x1c')]=_0x4ccf82;if(_0x25e1dc[_0x604c('0x2b')]['includeAll']){_0x2904dc['include']=[{'all':!![]}];}return db[_0x604c('0x25')][_0x604c('0x3a')](_0x2904dc);})[_0x604c('0x20')](function(_0xbe9904){_0x1d3d50['rows']=_0xbe9904;return _0x1d3d50;})[_0x604c('0x20')](respondWithFilteredResult(_0x3b1386,_0x2904dc))[_0x604c('0x3b')](handleError(_0x3b1386,null));};exports[_0x604c('0x3c')]=function(_0x2a9e68,_0x2b08c5){var _0x15f98b={'raw':![],'where':{'id':_0x2a9e68[_0x604c('0x3d')]['id']}},_0x5ad1ec={};_0x5ad1ec[_0x604c('0x29')]=_[_0x604c('0x2c')](db[_0x604c('0x25')][_0x604c('0x26')]);_0x5ad1ec[_0x604c('0x2b')]=_[_0x604c('0x2c')](_0x2a9e68[_0x604c('0x2b')]);_0x5ad1ec[_0x604c('0x3e')]=_[_0x604c('0x2d')](_0x5ad1ec[_0x604c('0x29')],_0x5ad1ec['query']);_0x15f98b[_0x604c('0x2f')]=_[_0x604c('0x2d')](_0x5ad1ec['model'],qs[_0x604c('0x2e')](_0x2a9e68['query'][_0x604c('0x2e')]));_0x15f98b[_0x604c('0x2f')]=_0x15f98b['attributes'][_0x604c('0x3f')]?_0x15f98b[_0x604c('0x2f')]:_0x5ad1ec[_0x604c('0x29')];if(_0x2a9e68[_0x604c('0x2b')][_0x604c('0x40')]){_0x15f98b['include']=[{'all':!![]}];}_0x15f98b=_['merge']({},_0x15f98b,_0x2a9e68['options']);return db[_0x604c('0x25')]['find'](_0x15f98b)['then'](handleEntityNotFound(_0x2b08c5,null))[_0x604c('0x20')](respondWithResult(_0x2b08c5,null))[_0x604c('0x3b')](handleError(_0x2b08c5,null));};exports['create']=function(_0x30f211,_0x532f84){return db['SugarcrmConfiguration'][_0x604c('0x41')](_0x30f211[_0x604c('0x42')],{})['then'](respondWithResult(_0x532f84,0xc9))[_0x604c('0x3b')](handleError(_0x532f84,null));};exports[_0x604c('0x1f')]=function(_0x32eb98,_0x50ee57){if(_0x32eb98[_0x604c('0x42')]['id']){delete _0x32eb98[_0x604c('0x42')]['id'];}return db[_0x604c('0x25')][_0x604c('0x43')]({'where':{'id':_0x32eb98['params']['id']}})[_0x604c('0x20')](handleEntityNotFound(_0x50ee57,null))[_0x604c('0x20')](saveUpdates(_0x32eb98[_0x604c('0x42')],null))[_0x604c('0x20')](respondWithResult(_0x50ee57,null))['catch'](handleError(_0x50ee57,null));};exports[_0x604c('0x21')]=function(_0x393c31,_0x14bb01){return db[_0x604c('0x25')][_0x604c('0x43')]({'where':{'id':_0x393c31[_0x604c('0x3d')]['id']}})[_0x604c('0x20')](handleEntityNotFound(_0x14bb01,null))['then'](removeEntity(_0x14bb01,null))[_0x604c('0x3b')](handleError(_0x14bb01,null));};exports[_0x604c('0x44')]=function(_0x3957ef,_0x3d0796,_0x4031c6){var _0x2b2ec7={};var _0x428f2c={};var _0x3cbc33;var _0x22fc79;return db[_0x604c('0x25')][_0x604c('0x45')]({'where':{'id':_0x3957ef['params']['id']}})['then'](handleEntityNotFound(_0x3d0796,null))[_0x604c('0x20')](function(_0x131123){if(_0x131123){_0x3cbc33=_0x131123;_0x428f2c[_0x604c('0x29')]=_['keys'](db['SugarcrmField'][_0x604c('0x26')]);_0x428f2c[_0x604c('0x2b')]=_[_0x604c('0x2c')](_0x3957ef[_0x604c('0x2b')]);_0x428f2c[_0x604c('0x3e')]=_[_0x604c('0x2d')](_0x428f2c[_0x604c('0x29')],_0x428f2c[_0x604c('0x2b')]);_0x2b2ec7['attributes']=_['intersection'](_0x428f2c[_0x604c('0x29')],qs[_0x604c('0x2e')](_0x3957ef[_0x604c('0x2b')][_0x604c('0x2e')]));_0x2b2ec7[_0x604c('0x2f')]=_0x2b2ec7[_0x604c('0x2f')][_0x604c('0x3f')]?_0x2b2ec7[_0x604c('0x2f')]:_0x428f2c[_0x604c('0x29')];_0x2b2ec7['order']=qs[_0x604c('0x33')](_0x3957ef['query'][_0x604c('0x33')]);_0x2b2ec7[_0x604c('0x34')]=qs[_0x604c('0x3e')](_[_0x604c('0x35')](_0x3957ef['query'],_0x428f2c[_0x604c('0x3e')]));if(_0x3957ef[_0x604c('0x2b')][_0x604c('0x38')]){_0x2b2ec7[_0x604c('0x34')]=_['merge'](_0x2b2ec7[_0x604c('0x34')],{'$or':_[_0x604c('0x2a')](_0x2b2ec7[_0x604c('0x2f')],function(_0x169a0f){var _0x4ab589={};_0x4ab589[_0x169a0f]={'$like':'%'+_0x3957ef[_0x604c('0x2b')][_0x604c('0x38')]+'%'};return _0x4ab589;})});}_0x2b2ec7=_[_0x604c('0x36')]({},_0x2b2ec7,_0x3957ef[_0x604c('0x39')]);return _0x3cbc33[_0x604c('0x44')](_0x2b2ec7);}})[_0x604c('0x20')](function(_0x4ffffb){if(_0x4ffffb){_0x22fc79=_0x4ffffb[_0x604c('0x3f')];if(!_0x3957ef[_0x604c('0x2b')]['hasOwnProperty'](_0x604c('0x31'))){_0x2b2ec7['limit']=qs['limit'](_0x3957ef[_0x604c('0x2b')][_0x604c('0x1b')]);_0x2b2ec7[_0x604c('0x19')]=qs[_0x604c('0x19')](_0x3957ef['query'][_0x604c('0x19')]);}return _0x3cbc33[_0x604c('0x44')](_0x2b2ec7);}})['then'](function(_0x724cec){if(_0x724cec){return _0x724cec?{'count':_0x22fc79,'rows':_0x724cec}:null;}})[_0x604c('0x20')](respondWithResult(_0x3d0796,null))[_0x604c('0x3b')](handleError(_0x3d0796,null));};exports['getSubjects']=function(_0x350e02,_0x166116,_0x3778b4){var _0x4f62d5={};var _0x2409d6={};var _0x2fc818;var _0x1ef281;return db[_0x604c('0x25')][_0x604c('0x45')]({'where':{'id':_0x350e02[_0x604c('0x3d')]['id']}})[_0x604c('0x20')](handleEntityNotFound(_0x166116,null))[_0x604c('0x20')](function(_0xb515ab){if(_0xb515ab){_0x2fc818=_0xb515ab;_0x2409d6[_0x604c('0x29')]=_[_0x604c('0x2c')](db['SugarcrmField'][_0x604c('0x26')]);_0x2409d6['query']=_[_0x604c('0x2c')](_0x350e02[_0x604c('0x2b')]);_0x2409d6['filters']=_[_0x604c('0x2d')](_0x2409d6[_0x604c('0x29')],_0x2409d6[_0x604c('0x2b')]);_0x4f62d5[_0x604c('0x2f')]=_[_0x604c('0x2d')](_0x2409d6[_0x604c('0x29')],qs[_0x604c('0x2e')](_0x350e02[_0x604c('0x2b')][_0x604c('0x2e')]));_0x4f62d5[_0x604c('0x2f')]=_0x4f62d5['attributes'][_0x604c('0x3f')]?_0x4f62d5[_0x604c('0x2f')]:_0x2409d6[_0x604c('0x29')];_0x4f62d5[_0x604c('0x32')]=qs['sort'](_0x350e02['query'][_0x604c('0x33')]);_0x4f62d5[_0x604c('0x34')]=qs[_0x604c('0x3e')](_[_0x604c('0x35')](_0x350e02[_0x604c('0x2b')],_0x2409d6[_0x604c('0x3e')]));if(_0x350e02[_0x604c('0x2b')]['filter']){_0x4f62d5[_0x604c('0x34')]=_['merge'](_0x4f62d5[_0x604c('0x34')],{'$or':_[_0x604c('0x2a')](_0x4f62d5['attributes'],function(_0x86f646){var _0x3120d4={};_0x3120d4[_0x86f646]={'$like':'%'+_0x350e02[_0x604c('0x2b')][_0x604c('0x38')]+'%'};return _0x3120d4;})});}_0x4f62d5=_['merge']({},_0x4f62d5,_0x350e02['options']);return _0x2fc818['getSubjects'](_0x4f62d5);}})['then'](function(_0x3eb5a8){if(_0x3eb5a8){_0x1ef281=_0x3eb5a8[_0x604c('0x3f')];if(!_0x350e02[_0x604c('0x2b')]['hasOwnProperty'](_0x604c('0x31'))){_0x4f62d5[_0x604c('0x1b')]=qs[_0x604c('0x1b')](_0x350e02[_0x604c('0x2b')][_0x604c('0x1b')]);_0x4f62d5[_0x604c('0x19')]=qs[_0x604c('0x19')](_0x350e02[_0x604c('0x2b')][_0x604c('0x19')]);}return _0x2fc818[_0x604c('0x46')](_0x4f62d5);}})[_0x604c('0x20')](function(_0x402a45){if(_0x402a45){return _0x402a45?{'count':_0x1ef281,'rows':_0x402a45}:null;}})['then'](respondWithResult(_0x166116,null))[_0x604c('0x3b')](handleError(_0x166116,null));};exports[_0x604c('0x47')]=function(_0xcc1d8e,_0x12bdc1,_0x4c12ee){var _0x4b438b={};var _0x3f283b={};var _0x13d68d;var _0x5007ed;return db[_0x604c('0x25')][_0x604c('0x45')]({'where':{'id':_0xcc1d8e[_0x604c('0x3d')]['id']}})[_0x604c('0x20')](handleEntityNotFound(_0x12bdc1,null))[_0x604c('0x20')](function(_0x570f6c){if(_0x570f6c){_0x13d68d=_0x570f6c;_0x3f283b[_0x604c('0x29')]=_['keys'](db[_0x604c('0x48')][_0x604c('0x26')]);_0x3f283b[_0x604c('0x2b')]=_['keys'](_0xcc1d8e[_0x604c('0x2b')]);_0x3f283b[_0x604c('0x3e')]=_['intersection'](_0x3f283b[_0x604c('0x29')],_0x3f283b['query']);_0x4b438b[_0x604c('0x2f')]=_[_0x604c('0x2d')](_0x3f283b[_0x604c('0x29')],qs[_0x604c('0x2e')](_0xcc1d8e[_0x604c('0x2b')][_0x604c('0x2e')]));_0x4b438b['attributes']=_0x4b438b[_0x604c('0x2f')][_0x604c('0x3f')]?_0x4b438b[_0x604c('0x2f')]:_0x3f283b[_0x604c('0x29')];_0x4b438b[_0x604c('0x32')]=qs['sort'](_0xcc1d8e[_0x604c('0x2b')][_0x604c('0x33')]);_0x4b438b['where']=qs[_0x604c('0x3e')](_[_0x604c('0x35')](_0xcc1d8e['query'],_0x3f283b[_0x604c('0x3e')]));if(_0xcc1d8e['query'][_0x604c('0x38')]){_0x4b438b[_0x604c('0x34')]=_['merge'](_0x4b438b[_0x604c('0x34')],{'$or':_[_0x604c('0x2a')](_0x4b438b['attributes'],function(_0x37152d){var _0x5c57f8={};_0x5c57f8[_0x37152d]={'$like':'%'+_0xcc1d8e[_0x604c('0x2b')][_0x604c('0x38')]+'%'};return _0x5c57f8;})});}_0x4b438b=_[_0x604c('0x36')]({},_0x4b438b,_0xcc1d8e[_0x604c('0x39')]);return _0x13d68d[_0x604c('0x47')](_0x4b438b);}})[_0x604c('0x20')](function(_0x222ab7){if(_0x222ab7){_0x5007ed=_0x222ab7[_0x604c('0x3f')];if(!_0xcc1d8e[_0x604c('0x2b')]['hasOwnProperty']('nolimit')){_0x4b438b[_0x604c('0x1b')]=qs[_0x604c('0x1b')](_0xcc1d8e[_0x604c('0x2b')]['limit']);_0x4b438b['offset']=qs[_0x604c('0x19')](_0xcc1d8e[_0x604c('0x2b')][_0x604c('0x19')]);}return _0x13d68d[_0x604c('0x47')](_0x4b438b);}})['then'](function(_0x15de75){if(_0x15de75){return _0x15de75?{'count':_0x5007ed,'rows':_0x15de75}:null;}})[_0x604c('0x20')](respondWithResult(_0x12bdc1,null))['catch'](handleError(_0x12bdc1,null));};