Built motion from commit 3e059bc2.|2.5.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 _0xf403=['rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','sox','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','to-csv','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','json','undefined','count','offset','limit','set','Content-Range','reject','save','update','then','destroy','end','name','send','SugarcrmConfiguration','rawAttributes','fieldName','type','key','model','map','query','keys','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','sort','pick','filter','where','merge','options','findAll','rows','params','includeAll','include','catch','create','body','find','findOne','order','getFields','SugarcrmField','getSubjects','getDescriptions'];(function(_0x3dd64c,_0x24763e){var _0x537931=function(_0x30c12b){while(--_0x30c12b){_0x3dd64c['push'](_0x3dd64c['shift']());}};_0x537931(++_0x24763e);}(_0xf403,0x1ec));var _0x3f40=function(_0x599b4c,_0x20c1e9){_0x599b4c=_0x599b4c-0x0;var _0x8f82c4=_0xf403[_0x599b4c];return _0x8f82c4;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x3f40('0x0'));var zipdir=require(_0x3f40('0x1'));var jsonpatch=require(_0x3f40('0x2'));var rp=require(_0x3f40('0x3'));var moment=require(_0x3f40('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x3f40('0x5'));var util=require(_0x3f40('0x6'));var path=require('path');var sox=require(_0x3f40('0x7'));var csv=require('to-csv');var ejs=require(_0x3f40('0x8'));var fs=require('fs');var fs_extra=require(_0x3f40('0x9'));var _=require(_0x3f40('0xa'));var squel=require(_0x3f40('0xb'));var crypto=require(_0x3f40('0xc'));var jsforce=require(_0x3f40('0xd'));var deskjs=require(_0x3f40('0xe'));var toCsv=require(_0x3f40('0xf'));var querystring=require('querystring');var Papa=require(_0x3f40('0x10'));var Redis=require(_0x3f40('0x11'));var authService=require(_0x3f40('0x12'));var qs=require(_0x3f40('0x13'));var as=require(_0x3f40('0x14'));var hardwareService=require(_0x3f40('0x15'));var logger=require(_0x3f40('0x16'))(_0x3f40('0x17'));var utils=require(_0x3f40('0x18'));var config=require(_0x3f40('0x19'));var licenseUtil=require(_0x3f40('0x1a'));var db=require(_0x3f40('0x1b'))['db'];function respondWithStatusCode(_0x273795,_0xa49bc1){_0xa49bc1=_0xa49bc1||0xcc;return function(_0x4b5b7f){if(_0x4b5b7f){return _0x273795[_0x3f40('0x1c')](_0xa49bc1);}return _0x273795[_0x3f40('0x1d')](_0xa49bc1)['end']();};}function respondWithResult(_0x52ccd7,_0xaa0cfd){_0xaa0cfd=_0xaa0cfd||0xc8;return function(_0x589e5b){if(_0x589e5b){return _0x52ccd7[_0x3f40('0x1d')](_0xaa0cfd)[_0x3f40('0x1e')](_0x589e5b);}};}function respondWithFilteredResult(_0x190cd2,_0x2a4cfd){return function(_0x10319e){if(_0x10319e){var _0x561c1f=typeof _0x2a4cfd['offset']===_0x3f40('0x1f')&&typeof _0x2a4cfd['limit']===_0x3f40('0x1f');var _0x30ed7a=_0x10319e[_0x3f40('0x20')];var _0x277182=_0x561c1f?0x0:_0x2a4cfd[_0x3f40('0x21')];var _0x13253b=_0x561c1f?_0x10319e[_0x3f40('0x20')]:_0x2a4cfd[_0x3f40('0x21')]+_0x2a4cfd[_0x3f40('0x22')];var _0x42399c;if(_0x13253b>=_0x30ed7a){_0x13253b=_0x30ed7a;_0x42399c=0xc8;}else{_0x42399c=0xce;}_0x190cd2[_0x3f40('0x1d')](_0x42399c);return _0x190cd2[_0x3f40('0x23')](_0x3f40('0x24'),_0x277182+'-'+_0x13253b+'/'+_0x30ed7a)['json'](_0x10319e);}return null;};}function patchUpdates(_0x6deda7){return function(_0x114a78){try{jsonpatch['apply'](_0x114a78,_0x6deda7,!![]);}catch(_0x105063){return BPromise[_0x3f40('0x25')](_0x105063);}return _0x114a78[_0x3f40('0x26')]();};}function saveUpdates(_0x19425c,_0x5a2dcd){return function(_0xa2d3a7){if(_0xa2d3a7){return _0xa2d3a7[_0x3f40('0x27')](_0x19425c)[_0x3f40('0x28')](function(_0x309295){return _0x309295;});}return null;};}function removeEntity(_0x5447dc,_0x164abb){return function(_0x2afe44){if(_0x2afe44){return _0x2afe44[_0x3f40('0x29')]()['then'](function(){_0x5447dc[_0x3f40('0x1d')](0xcc)[_0x3f40('0x2a')]();});}};}function handleEntityNotFound(_0x269448,_0x50f3ad){return function(_0x4a8af4){if(!_0x4a8af4){_0x269448[_0x3f40('0x1c')](0x194);}return _0x4a8af4;};}function handleError(_0x72044d,_0x1e49ea){_0x1e49ea=_0x1e49ea||0x1f4;return function(_0x1d38af){logger['error'](_0x1d38af['stack']);if(_0x1d38af['name']){delete _0x1d38af[_0x3f40('0x2b')];}_0x72044d['status'](_0x1e49ea)[_0x3f40('0x2c')](_0x1d38af);};}exports['index']=function(_0x4fdaba,_0x2182f1){var _0x34ca93={},_0x26a017={},_0x332a14={'count':0x0,'rows':[]};var _0x1a58ef=_['map'](db[_0x3f40('0x2d')][_0x3f40('0x2e')],function(_0x246e37){return{'name':_0x246e37[_0x3f40('0x2f')],'type':_0x246e37[_0x3f40('0x30')][_0x3f40('0x31')]};});_0x26a017[_0x3f40('0x32')]=_[_0x3f40('0x33')](_0x1a58ef,_0x3f40('0x2b'));_0x26a017[_0x3f40('0x34')]=_[_0x3f40('0x35')](_0x4fdaba['query']);_0x26a017[_0x3f40('0x36')]=_[_0x3f40('0x37')](_0x26a017[_0x3f40('0x32')],_0x26a017[_0x3f40('0x34')]);_0x34ca93['attributes']=_[_0x3f40('0x37')](_0x26a017[_0x3f40('0x32')],qs[_0x3f40('0x38')](_0x4fdaba['query'][_0x3f40('0x38')]));_0x34ca93['attributes']=_0x34ca93[_0x3f40('0x39')][_0x3f40('0x3a')]?_0x34ca93['attributes']:_0x26a017['model'];if(!_0x4fdaba['query'][_0x3f40('0x3b')](_0x3f40('0x3c'))){_0x34ca93[_0x3f40('0x22')]=qs[_0x3f40('0x22')](_0x4fdaba[_0x3f40('0x34')]['limit']);_0x34ca93['offset']=qs[_0x3f40('0x21')](_0x4fdaba['query']['offset']);}_0x34ca93['order']=qs['sort'](_0x4fdaba[_0x3f40('0x34')][_0x3f40('0x3d')]);_0x34ca93['where']=qs[_0x3f40('0x36')](_[_0x3f40('0x3e')](_0x4fdaba['query'],_0x26a017[_0x3f40('0x36')]),_0x1a58ef);if(_0x4fdaba[_0x3f40('0x34')][_0x3f40('0x3f')]){_0x34ca93[_0x3f40('0x40')]=_[_0x3f40('0x41')](_0x34ca93['where'],{'$or':_[_0x3f40('0x33')](_0x1a58ef,function(_0xa8462){if(_0xa8462[_0x3f40('0x30')]!=='VIRTUAL'){var _0x2857e3={};_0x2857e3[_0xa8462['name']]={'$like':'%'+_0x4fdaba[_0x3f40('0x34')][_0x3f40('0x3f')]+'%'};return _0x2857e3;}})});}_0x34ca93=_[_0x3f40('0x41')]({},_0x34ca93,_0x4fdaba[_0x3f40('0x42')]);var _0x1366c9={'where':_0x34ca93[_0x3f40('0x40')]};return db[_0x3f40('0x2d')][_0x3f40('0x20')](_0x1366c9)[_0x3f40('0x28')](function(_0x2b44d2){_0x332a14['count']=_0x2b44d2;if(_0x4fdaba[_0x3f40('0x34')]['includeAll']){_0x34ca93['include']=[{'all':!![]}];}return db[_0x3f40('0x2d')][_0x3f40('0x43')](_0x34ca93);})[_0x3f40('0x28')](function(_0x424ff8){_0x332a14[_0x3f40('0x44')]=_0x424ff8;return _0x332a14;})[_0x3f40('0x28')](respondWithFilteredResult(_0x2182f1,_0x34ca93))['catch'](handleError(_0x2182f1,null));};exports['show']=function(_0x540375,_0xdd2f44){var _0x29fdee={'raw':![],'where':{'id':_0x540375[_0x3f40('0x45')]['id']}},_0x4b9d3f={};_0x4b9d3f['model']=_['keys'](db[_0x3f40('0x2d')][_0x3f40('0x2e')]);_0x4b9d3f[_0x3f40('0x34')]=_[_0x3f40('0x35')](_0x540375[_0x3f40('0x34')]);_0x4b9d3f[_0x3f40('0x36')]=_[_0x3f40('0x37')](_0x4b9d3f[_0x3f40('0x32')],_0x4b9d3f[_0x3f40('0x34')]);_0x29fdee[_0x3f40('0x39')]=_[_0x3f40('0x37')](_0x4b9d3f[_0x3f40('0x32')],qs[_0x3f40('0x38')](_0x540375['query']['fields']));_0x29fdee['attributes']=_0x29fdee[_0x3f40('0x39')][_0x3f40('0x3a')]?_0x29fdee[_0x3f40('0x39')]:_0x4b9d3f[_0x3f40('0x32')];if(_0x540375['query'][_0x3f40('0x46')]){_0x29fdee[_0x3f40('0x47')]=[{'all':!![]}];}_0x29fdee=_[_0x3f40('0x41')]({},_0x29fdee,_0x540375[_0x3f40('0x42')]);return db[_0x3f40('0x2d')]['find'](_0x29fdee)[_0x3f40('0x28')](handleEntityNotFound(_0xdd2f44,null))[_0x3f40('0x28')](respondWithResult(_0xdd2f44,null))[_0x3f40('0x48')](handleError(_0xdd2f44,null));};exports['create']=function(_0x122bcc,_0x24e8d6){return db[_0x3f40('0x2d')][_0x3f40('0x49')](_0x122bcc[_0x3f40('0x4a')],{})['then'](respondWithResult(_0x24e8d6,0xc9))[_0x3f40('0x48')](handleError(_0x24e8d6,null));};exports[_0x3f40('0x27')]=function(_0x45bdd6,_0x103ce6){if(_0x45bdd6[_0x3f40('0x4a')]['id']){delete _0x45bdd6[_0x3f40('0x4a')]['id'];}return db[_0x3f40('0x2d')][_0x3f40('0x4b')]({'where':{'id':_0x45bdd6[_0x3f40('0x45')]['id']}})[_0x3f40('0x28')](handleEntityNotFound(_0x103ce6,null))[_0x3f40('0x28')](saveUpdates(_0x45bdd6[_0x3f40('0x4a')],null))[_0x3f40('0x28')](respondWithResult(_0x103ce6,null))['catch'](handleError(_0x103ce6,null));};exports[_0x3f40('0x29')]=function(_0x3ae4b4,_0x22bd2d){return db['SugarcrmConfiguration'][_0x3f40('0x4b')]({'where':{'id':_0x3ae4b4[_0x3f40('0x45')]['id']}})[_0x3f40('0x28')](handleEntityNotFound(_0x22bd2d,null))[_0x3f40('0x28')](removeEntity(_0x22bd2d,null))[_0x3f40('0x48')](handleError(_0x22bd2d,null));};exports['getFields']=function(_0x41739d,_0x452fbb,_0x57d2c7){var _0x5d8074={};var _0x4770fd={};var _0x5a2568;var _0x56f7ce;return db['SugarcrmConfiguration'][_0x3f40('0x4c')]({'where':{'id':_0x41739d[_0x3f40('0x45')]['id']}})[_0x3f40('0x28')](handleEntityNotFound(_0x452fbb,null))['then'](function(_0x3829a8){if(_0x3829a8){_0x5a2568=_0x3829a8;_0x4770fd[_0x3f40('0x32')]=_[_0x3f40('0x35')](db['SugarcrmField'][_0x3f40('0x2e')]);_0x4770fd[_0x3f40('0x34')]=_[_0x3f40('0x35')](_0x41739d[_0x3f40('0x34')]);_0x4770fd['filters']=_['intersection'](_0x4770fd['model'],_0x4770fd[_0x3f40('0x34')]);_0x5d8074['attributes']=_[_0x3f40('0x37')](_0x4770fd[_0x3f40('0x32')],qs[_0x3f40('0x38')](_0x41739d['query']['fields']));_0x5d8074[_0x3f40('0x39')]=_0x5d8074[_0x3f40('0x39')][_0x3f40('0x3a')]?_0x5d8074['attributes']:_0x4770fd[_0x3f40('0x32')];_0x5d8074[_0x3f40('0x4d')]=qs[_0x3f40('0x3d')](_0x41739d[_0x3f40('0x34')][_0x3f40('0x3d')]);_0x5d8074['where']=qs[_0x3f40('0x36')](_[_0x3f40('0x3e')](_0x41739d[_0x3f40('0x34')],_0x4770fd['filters']));if(_0x41739d['query']['filter']){_0x5d8074[_0x3f40('0x40')]=_['merge'](_0x5d8074['where'],{'$or':_[_0x3f40('0x33')](_0x5d8074['attributes'],function(_0x3284e7){var _0x173313={};_0x173313[_0x3284e7]={'$like':'%'+_0x41739d[_0x3f40('0x34')]['filter']+'%'};return _0x173313;})});}_0x5d8074=_['merge']({},_0x5d8074,_0x41739d[_0x3f40('0x42')]);return _0x5a2568[_0x3f40('0x4e')](_0x5d8074);}})[_0x3f40('0x28')](function(_0x823fff){if(_0x823fff){_0x56f7ce=_0x823fff[_0x3f40('0x3a')];if(!_0x41739d[_0x3f40('0x34')][_0x3f40('0x3b')]('nolimit')){_0x5d8074[_0x3f40('0x22')]=qs['limit'](_0x41739d[_0x3f40('0x34')][_0x3f40('0x22')]);_0x5d8074[_0x3f40('0x21')]=qs['offset'](_0x41739d[_0x3f40('0x34')][_0x3f40('0x21')]);}return _0x5a2568['getFields'](_0x5d8074);}})[_0x3f40('0x28')](function(_0x551056){if(_0x551056){return _0x551056?{'count':_0x56f7ce,'rows':_0x551056}:null;}})[_0x3f40('0x28')](respondWithResult(_0x452fbb,null))['catch'](handleError(_0x452fbb,null));};exports['getSubjects']=function(_0x3b6d3a,_0x4a2b4c,_0x326664){var _0x4e5372={};var _0x3b4214={};var _0x3a50d5;var _0x3259bb;return db[_0x3f40('0x2d')][_0x3f40('0x4c')]({'where':{'id':_0x3b6d3a[_0x3f40('0x45')]['id']}})['then'](handleEntityNotFound(_0x4a2b4c,null))[_0x3f40('0x28')](function(_0x26a869){if(_0x26a869){_0x3a50d5=_0x26a869;_0x3b4214[_0x3f40('0x32')]=_[_0x3f40('0x35')](db[_0x3f40('0x4f')][_0x3f40('0x2e')]);_0x3b4214[_0x3f40('0x34')]=_['keys'](_0x3b6d3a[_0x3f40('0x34')]);_0x3b4214['filters']=_[_0x3f40('0x37')](_0x3b4214['model'],_0x3b4214[_0x3f40('0x34')]);_0x4e5372[_0x3f40('0x39')]=_[_0x3f40('0x37')](_0x3b4214[_0x3f40('0x32')],qs[_0x3f40('0x38')](_0x3b6d3a[_0x3f40('0x34')][_0x3f40('0x38')]));_0x4e5372['attributes']=_0x4e5372[_0x3f40('0x39')]['length']?_0x4e5372[_0x3f40('0x39')]:_0x3b4214[_0x3f40('0x32')];_0x4e5372['order']=qs['sort'](_0x3b6d3a['query'][_0x3f40('0x3d')]);_0x4e5372[_0x3f40('0x40')]=qs[_0x3f40('0x36')](_[_0x3f40('0x3e')](_0x3b6d3a[_0x3f40('0x34')],_0x3b4214[_0x3f40('0x36')]));if(_0x3b6d3a[_0x3f40('0x34')][_0x3f40('0x3f')]){_0x4e5372[_0x3f40('0x40')]=_['merge'](_0x4e5372[_0x3f40('0x40')],{'$or':_[_0x3f40('0x33')](_0x4e5372[_0x3f40('0x39')],function(_0x37e398){var _0x3adca9={};_0x3adca9[_0x37e398]={'$like':'%'+_0x3b6d3a[_0x3f40('0x34')]['filter']+'%'};return _0x3adca9;})});}_0x4e5372=_[_0x3f40('0x41')]({},_0x4e5372,_0x3b6d3a[_0x3f40('0x42')]);return _0x3a50d5[_0x3f40('0x50')](_0x4e5372);}})['then'](function(_0x267d7c){if(_0x267d7c){_0x3259bb=_0x267d7c[_0x3f40('0x3a')];if(!_0x3b6d3a[_0x3f40('0x34')][_0x3f40('0x3b')](_0x3f40('0x3c'))){_0x4e5372['limit']=qs[_0x3f40('0x22')](_0x3b6d3a[_0x3f40('0x34')][_0x3f40('0x22')]);_0x4e5372[_0x3f40('0x21')]=qs[_0x3f40('0x21')](_0x3b6d3a[_0x3f40('0x34')]['offset']);}return _0x3a50d5[_0x3f40('0x50')](_0x4e5372);}})[_0x3f40('0x28')](function(_0x3290bc){if(_0x3290bc){return _0x3290bc?{'count':_0x3259bb,'rows':_0x3290bc}:null;}})[_0x3f40('0x28')](respondWithResult(_0x4a2b4c,null))['catch'](handleError(_0x4a2b4c,null));};exports[_0x3f40('0x51')]=function(_0x576623,_0x5b00ed,_0x5e6739){var _0x2a8700={};var _0x2f419f={};var _0x31dbdb;var _0x5bde61;return db[_0x3f40('0x2d')][_0x3f40('0x4c')]({'where':{'id':_0x576623[_0x3f40('0x45')]['id']}})[_0x3f40('0x28')](handleEntityNotFound(_0x5b00ed,null))['then'](function(_0x58ab58){if(_0x58ab58){_0x31dbdb=_0x58ab58;_0x2f419f[_0x3f40('0x32')]=_['keys'](db['SugarcrmField']['rawAttributes']);_0x2f419f['query']=_[_0x3f40('0x35')](_0x576623[_0x3f40('0x34')]);_0x2f419f[_0x3f40('0x36')]=_[_0x3f40('0x37')](_0x2f419f[_0x3f40('0x32')],_0x2f419f[_0x3f40('0x34')]);_0x2a8700[_0x3f40('0x39')]=_[_0x3f40('0x37')](_0x2f419f['model'],qs[_0x3f40('0x38')](_0x576623['query']['fields']));_0x2a8700[_0x3f40('0x39')]=_0x2a8700[_0x3f40('0x39')][_0x3f40('0x3a')]?_0x2a8700[_0x3f40('0x39')]:_0x2f419f[_0x3f40('0x32')];_0x2a8700[_0x3f40('0x4d')]=qs['sort'](_0x576623[_0x3f40('0x34')][_0x3f40('0x3d')]);_0x2a8700['where']=qs['filters'](_['pick'](_0x576623[_0x3f40('0x34')],_0x2f419f[_0x3f40('0x36')]));if(_0x576623[_0x3f40('0x34')][_0x3f40('0x3f')]){_0x2a8700[_0x3f40('0x40')]=_[_0x3f40('0x41')](_0x2a8700[_0x3f40('0x40')],{'$or':_['map'](_0x2a8700[_0x3f40('0x39')],function(_0x3094b3){var _0x51fa47={};_0x51fa47[_0x3094b3]={'$like':'%'+_0x576623[_0x3f40('0x34')][_0x3f40('0x3f')]+'%'};return _0x51fa47;})});}_0x2a8700=_[_0x3f40('0x41')]({},_0x2a8700,_0x576623[_0x3f40('0x42')]);return _0x31dbdb[_0x3f40('0x51')](_0x2a8700);}})[_0x3f40('0x28')](function(_0x3c6f05){if(_0x3c6f05){_0x5bde61=_0x3c6f05[_0x3f40('0x3a')];if(!_0x576623[_0x3f40('0x34')]['hasOwnProperty'](_0x3f40('0x3c'))){_0x2a8700[_0x3f40('0x22')]=qs[_0x3f40('0x22')](_0x576623[_0x3f40('0x34')][_0x3f40('0x22')]);_0x2a8700['offset']=qs[_0x3f40('0x21')](_0x576623[_0x3f40('0x34')][_0x3f40('0x21')]);}return _0x31dbdb[_0x3f40('0x51')](_0x2a8700);}})[_0x3f40('0x28')](function(_0x49ea08){if(_0x49ea08){return _0x49ea08?{'count':_0x5bde61,'rows':_0x49ea08}:null;}})[_0x3f40('0x28')](respondWithResult(_0x5b00ed,null))[_0x3f40('0x48')](handleError(_0x5b00ed,null));};