Built motion from commit a61a4a20.|2.5.46
[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 _0xecd3=['../../config/logger','../../config/utils','../../config/license/util','../../mysqldb','status','end','offset','limit','count','set','Content-Range','apply','reject','update','then','destroy','sendStatus','error','stack','name','send','map','rawAttributes','type','key','query','keys','intersection','attributes','model','fields','length','hasOwnProperty','nolimit','order','sort','where','filters','merge','VIRTUAL','filter','options','includeAll','include','SugarcrmConfiguration','findAll','rows','params','find','catch','create','body','getFields','findOne','SugarcrmField','getSubjects','pick','getDescriptions','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','sox','ejs','lodash','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch'];(function(_0x497ddb,_0x4ed2c5){var _0x3974fa=function(_0x43b482){while(--_0x43b482){_0x497ddb['push'](_0x497ddb['shift']());}};_0x3974fa(++_0x4ed2c5);}(_0xecd3,0x121));var _0x3ecd=function(_0x8aa35c,_0x2baaf2){_0x8aa35c=_0x8aa35c-0x0;var _0x58d35d=_0xecd3[_0x8aa35c];return _0x58d35d;};'use strict';var emlformat=require(_0x3ecd('0x0'));var rimraf=require(_0x3ecd('0x1'));var zipdir=require(_0x3ecd('0x2'));var jsonpatch=require(_0x3ecd('0x3'));var rp=require(_0x3ecd('0x4'));var moment=require(_0x3ecd('0x5'));var BPromise=require(_0x3ecd('0x6'));var Mustache=require(_0x3ecd('0x7'));var util=require('util');var path=require('path');var sox=require(_0x3ecd('0x8'));var csv=require('to-csv');var ejs=require(_0x3ecd('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x3ecd('0xa'));var squel=require(_0x3ecd('0xb'));var crypto=require(_0x3ecd('0xc'));var jsforce=require(_0x3ecd('0xd'));var deskjs=require(_0x3ecd('0xe'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x3ecd('0xf'));var Redis=require(_0x3ecd('0x10'));var authService=require(_0x3ecd('0x11'));var qs=require('../../components/parsers/qs');var as=require(_0x3ecd('0x12'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x3ecd('0x13'))('api');var utils=require(_0x3ecd('0x14'));var config=require('../../config/environment');var licenseUtil=require(_0x3ecd('0x15'));var db=require(_0x3ecd('0x16'))['db'];function respondWithStatusCode(_0x1d2261,_0x47a931){_0x47a931=_0x47a931||0xcc;return function(_0xd72fff){if(_0xd72fff){return _0x1d2261['sendStatus'](_0x47a931);}return _0x1d2261[_0x3ecd('0x17')](_0x47a931)[_0x3ecd('0x18')]();};}function respondWithResult(_0x1e727a,_0x15e782){_0x15e782=_0x15e782||0xc8;return function(_0xc52fa3){if(_0xc52fa3){return _0x1e727a[_0x3ecd('0x17')](_0x15e782)['json'](_0xc52fa3);}};}function respondWithFilteredResult(_0x53ae3c,_0x1a8f8f){return function(_0x12b14c){if(_0x12b14c){var _0x3c1e6c=typeof _0x1a8f8f[_0x3ecd('0x19')]==='undefined'&&typeof _0x1a8f8f[_0x3ecd('0x1a')]==='undefined';var _0x17d695=_0x12b14c[_0x3ecd('0x1b')];var _0xe21850=_0x3c1e6c?0x0:_0x1a8f8f[_0x3ecd('0x19')];var _0x3d3a72=_0x3c1e6c?_0x12b14c[_0x3ecd('0x1b')]:_0x1a8f8f[_0x3ecd('0x19')]+_0x1a8f8f[_0x3ecd('0x1a')];var _0x3b9829;if(_0x3d3a72>=_0x17d695){_0x3d3a72=_0x17d695;_0x3b9829=0xc8;}else{_0x3b9829=0xce;}_0x53ae3c[_0x3ecd('0x17')](_0x3b9829);return _0x53ae3c[_0x3ecd('0x1c')](_0x3ecd('0x1d'),_0xe21850+'-'+_0x3d3a72+'/'+_0x17d695)['json'](_0x12b14c);}return null;};}function patchUpdates(_0xff3522){return function(_0x2722f0){try{jsonpatch[_0x3ecd('0x1e')](_0x2722f0,_0xff3522,!![]);}catch(_0x5e680c){return BPromise[_0x3ecd('0x1f')](_0x5e680c);}return _0x2722f0['save']();};}function saveUpdates(_0x307874,_0x512f06){return function(_0x4555e5){if(_0x4555e5){return _0x4555e5[_0x3ecd('0x20')](_0x307874)[_0x3ecd('0x21')](function(_0x2c2854){return _0x2c2854;});}return null;};}function removeEntity(_0x174fab,_0x1e2aeb){return function(_0x22fd2f){if(_0x22fd2f){return _0x22fd2f[_0x3ecd('0x22')]()['then'](function(){_0x174fab[_0x3ecd('0x17')](0xcc)[_0x3ecd('0x18')]();});}};}function handleEntityNotFound(_0x1b0b3f,_0x55a3a){return function(_0x2bad4c){if(!_0x2bad4c){_0x1b0b3f[_0x3ecd('0x23')](0x194);}return _0x2bad4c;};}function handleError(_0x1b3feb,_0x3a14a9){_0x3a14a9=_0x3a14a9||0x1f4;return function(_0x54e0f5){logger[_0x3ecd('0x24')](_0x54e0f5[_0x3ecd('0x25')]);if(_0x54e0f5[_0x3ecd('0x26')]){delete _0x54e0f5[_0x3ecd('0x26')];}_0x1b3feb[_0x3ecd('0x17')](_0x3a14a9)[_0x3ecd('0x27')](_0x54e0f5);};}exports['index']=function(_0x678734,_0x1c9979){var _0x457e09={},_0xb05cf5={},_0x33e6cc={'count':0x0,'rows':[]};var _0x3e415e=_[_0x3ecd('0x28')](db['SugarcrmConfiguration'][_0x3ecd('0x29')],function(_0x532f61){return{'name':_0x532f61['fieldName'],'type':_0x532f61[_0x3ecd('0x2a')][_0x3ecd('0x2b')]};});_0xb05cf5['model']=_[_0x3ecd('0x28')](_0x3e415e,_0x3ecd('0x26'));_0xb05cf5[_0x3ecd('0x2c')]=_[_0x3ecd('0x2d')](_0x678734[_0x3ecd('0x2c')]);_0xb05cf5['filters']=_[_0x3ecd('0x2e')](_0xb05cf5['model'],_0xb05cf5['query']);_0x457e09[_0x3ecd('0x2f')]=_[_0x3ecd('0x2e')](_0xb05cf5[_0x3ecd('0x30')],qs[_0x3ecd('0x31')](_0x678734['query'][_0x3ecd('0x31')]));_0x457e09[_0x3ecd('0x2f')]=_0x457e09[_0x3ecd('0x2f')][_0x3ecd('0x32')]?_0x457e09[_0x3ecd('0x2f')]:_0xb05cf5[_0x3ecd('0x30')];if(!_0x678734[_0x3ecd('0x2c')][_0x3ecd('0x33')](_0x3ecd('0x34'))){_0x457e09['limit']=qs['limit'](_0x678734[_0x3ecd('0x2c')][_0x3ecd('0x1a')]);_0x457e09['offset']=qs[_0x3ecd('0x19')](_0x678734[_0x3ecd('0x2c')][_0x3ecd('0x19')]);}_0x457e09[_0x3ecd('0x35')]=qs[_0x3ecd('0x36')](_0x678734[_0x3ecd('0x2c')][_0x3ecd('0x36')]);_0x457e09[_0x3ecd('0x37')]=qs[_0x3ecd('0x38')](_['pick'](_0x678734[_0x3ecd('0x2c')],_0xb05cf5[_0x3ecd('0x38')]),_0x3e415e);if(_0x678734[_0x3ecd('0x2c')]['filter']){_0x457e09[_0x3ecd('0x37')]=_[_0x3ecd('0x39')](_0x457e09[_0x3ecd('0x37')],{'$or':_['map'](_0x3e415e,function(_0x24272f){if(_0x24272f[_0x3ecd('0x2a')]!==_0x3ecd('0x3a')){var _0x518682={};_0x518682[_0x24272f[_0x3ecd('0x26')]]={'$like':'%'+_0x678734['query'][_0x3ecd('0x3b')]+'%'};return _0x518682;}})});}_0x457e09=_['merge']({},_0x457e09,_0x678734[_0x3ecd('0x3c')]);var _0xc0eb03={'where':_0x457e09['where']};return db['SugarcrmConfiguration'][_0x3ecd('0x1b')](_0xc0eb03)[_0x3ecd('0x21')](function(_0x343eba){_0x33e6cc[_0x3ecd('0x1b')]=_0x343eba;if(_0x678734[_0x3ecd('0x2c')][_0x3ecd('0x3d')]){_0x457e09[_0x3ecd('0x3e')]=[{'all':!![]}];}return db[_0x3ecd('0x3f')][_0x3ecd('0x40')](_0x457e09);})[_0x3ecd('0x21')](function(_0x59e055){_0x33e6cc[_0x3ecd('0x41')]=_0x59e055;return _0x33e6cc;})[_0x3ecd('0x21')](respondWithFilteredResult(_0x1c9979,_0x457e09))['catch'](handleError(_0x1c9979,null));};exports['show']=function(_0x13a197,_0x3ac754){var _0x1f9bdd={'raw':![],'where':{'id':_0x13a197[_0x3ecd('0x42')]['id']}},_0x596eda={};_0x596eda[_0x3ecd('0x30')]=_[_0x3ecd('0x2d')](db[_0x3ecd('0x3f')][_0x3ecd('0x29')]);_0x596eda[_0x3ecd('0x2c')]=_['keys'](_0x13a197['query']);_0x596eda[_0x3ecd('0x38')]=_['intersection'](_0x596eda['model'],_0x596eda[_0x3ecd('0x2c')]);_0x1f9bdd[_0x3ecd('0x2f')]=_[_0x3ecd('0x2e')](_0x596eda['model'],qs[_0x3ecd('0x31')](_0x13a197['query']['fields']));_0x1f9bdd[_0x3ecd('0x2f')]=_0x1f9bdd[_0x3ecd('0x2f')]['length']?_0x1f9bdd['attributes']:_0x596eda[_0x3ecd('0x30')];if(_0x13a197[_0x3ecd('0x2c')][_0x3ecd('0x3d')]){_0x1f9bdd['include']=[{'all':!![]}];}_0x1f9bdd=_[_0x3ecd('0x39')]({},_0x1f9bdd,_0x13a197['options']);return db[_0x3ecd('0x3f')][_0x3ecd('0x43')](_0x1f9bdd)[_0x3ecd('0x21')](handleEntityNotFound(_0x3ac754,null))[_0x3ecd('0x21')](respondWithResult(_0x3ac754,null))[_0x3ecd('0x44')](handleError(_0x3ac754,null));};exports[_0x3ecd('0x45')]=function(_0x5b22bc,_0x197cd4){return db[_0x3ecd('0x3f')][_0x3ecd('0x45')](_0x5b22bc[_0x3ecd('0x46')],{})['then'](respondWithResult(_0x197cd4,0xc9))[_0x3ecd('0x44')](handleError(_0x197cd4,null));};exports['update']=function(_0x5c170f,_0xdfe427){if(_0x5c170f['body']['id']){delete _0x5c170f['body']['id'];}return db[_0x3ecd('0x3f')][_0x3ecd('0x43')]({'where':{'id':_0x5c170f[_0x3ecd('0x42')]['id']}})[_0x3ecd('0x21')](handleEntityNotFound(_0xdfe427,null))['then'](saveUpdates(_0x5c170f[_0x3ecd('0x46')],null))[_0x3ecd('0x21')](respondWithResult(_0xdfe427,null))[_0x3ecd('0x44')](handleError(_0xdfe427,null));};exports['destroy']=function(_0x3d0724,_0x3d2708){return db[_0x3ecd('0x3f')]['find']({'where':{'id':_0x3d0724[_0x3ecd('0x42')]['id']}})['then'](handleEntityNotFound(_0x3d2708,null))[_0x3ecd('0x21')](removeEntity(_0x3d2708,null))[_0x3ecd('0x44')](handleError(_0x3d2708,null));};exports[_0x3ecd('0x47')]=function(_0x5b53f8,_0x14a3b0,_0x3b373c){var _0x4bbff0={};var _0xda03ad={};var _0x1dec8e;var _0x351c07;return db['SugarcrmConfiguration'][_0x3ecd('0x48')]({'where':{'id':_0x5b53f8[_0x3ecd('0x42')]['id']}})[_0x3ecd('0x21')](handleEntityNotFound(_0x14a3b0,null))[_0x3ecd('0x21')](function(_0x584fe9){if(_0x584fe9){_0x1dec8e=_0x584fe9;_0xda03ad[_0x3ecd('0x30')]=_[_0x3ecd('0x2d')](db[_0x3ecd('0x49')][_0x3ecd('0x29')]);_0xda03ad[_0x3ecd('0x2c')]=_[_0x3ecd('0x2d')](_0x5b53f8[_0x3ecd('0x2c')]);_0xda03ad['filters']=_['intersection'](_0xda03ad[_0x3ecd('0x30')],_0xda03ad[_0x3ecd('0x2c')]);_0x4bbff0[_0x3ecd('0x2f')]=_['intersection'](_0xda03ad[_0x3ecd('0x30')],qs['fields'](_0x5b53f8[_0x3ecd('0x2c')][_0x3ecd('0x31')]));_0x4bbff0[_0x3ecd('0x2f')]=_0x4bbff0[_0x3ecd('0x2f')][_0x3ecd('0x32')]?_0x4bbff0[_0x3ecd('0x2f')]:_0xda03ad[_0x3ecd('0x30')];_0x4bbff0['order']=qs[_0x3ecd('0x36')](_0x5b53f8[_0x3ecd('0x2c')][_0x3ecd('0x36')]);_0x4bbff0[_0x3ecd('0x37')]=qs[_0x3ecd('0x38')](_['pick'](_0x5b53f8[_0x3ecd('0x2c')],_0xda03ad['filters']));if(_0x5b53f8['query'][_0x3ecd('0x3b')]){_0x4bbff0[_0x3ecd('0x37')]=_[_0x3ecd('0x39')](_0x4bbff0[_0x3ecd('0x37')],{'$or':_[_0x3ecd('0x28')](_0x4bbff0[_0x3ecd('0x2f')],function(_0x55a167){var _0x468dd0={};_0x468dd0[_0x55a167]={'$like':'%'+_0x5b53f8['query'][_0x3ecd('0x3b')]+'%'};return _0x468dd0;})});}_0x4bbff0=_[_0x3ecd('0x39')]({},_0x4bbff0,_0x5b53f8[_0x3ecd('0x3c')]);return _0x1dec8e[_0x3ecd('0x47')](_0x4bbff0);}})['then'](function(_0x1f6ed6){if(_0x1f6ed6){_0x351c07=_0x1f6ed6[_0x3ecd('0x32')];if(!_0x5b53f8['query'][_0x3ecd('0x33')]('nolimit')){_0x4bbff0[_0x3ecd('0x1a')]=qs['limit'](_0x5b53f8[_0x3ecd('0x2c')][_0x3ecd('0x1a')]);_0x4bbff0[_0x3ecd('0x19')]=qs[_0x3ecd('0x19')](_0x5b53f8[_0x3ecd('0x2c')][_0x3ecd('0x19')]);}return _0x1dec8e[_0x3ecd('0x47')](_0x4bbff0);}})['then'](function(_0x521e73){if(_0x521e73){return _0x521e73?{'count':_0x351c07,'rows':_0x521e73}:null;}})[_0x3ecd('0x21')](respondWithResult(_0x14a3b0,null))['catch'](handleError(_0x14a3b0,null));};exports[_0x3ecd('0x4a')]=function(_0x408d31,_0x2a673b,_0x4472a4){var _0x50ea6b={};var _0x12bfed={};var _0x1d5aca;var _0x280354;return db[_0x3ecd('0x3f')][_0x3ecd('0x48')]({'where':{'id':_0x408d31[_0x3ecd('0x42')]['id']}})[_0x3ecd('0x21')](handleEntityNotFound(_0x2a673b,null))[_0x3ecd('0x21')](function(_0x929865){if(_0x929865){_0x1d5aca=_0x929865;_0x12bfed[_0x3ecd('0x30')]=_['keys'](db['SugarcrmField'][_0x3ecd('0x29')]);_0x12bfed[_0x3ecd('0x2c')]=_[_0x3ecd('0x2d')](_0x408d31['query']);_0x12bfed['filters']=_[_0x3ecd('0x2e')](_0x12bfed[_0x3ecd('0x30')],_0x12bfed[_0x3ecd('0x2c')]);_0x50ea6b[_0x3ecd('0x2f')]=_[_0x3ecd('0x2e')](_0x12bfed[_0x3ecd('0x30')],qs[_0x3ecd('0x31')](_0x408d31['query'][_0x3ecd('0x31')]));_0x50ea6b[_0x3ecd('0x2f')]=_0x50ea6b[_0x3ecd('0x2f')][_0x3ecd('0x32')]?_0x50ea6b['attributes']:_0x12bfed[_0x3ecd('0x30')];_0x50ea6b[_0x3ecd('0x35')]=qs[_0x3ecd('0x36')](_0x408d31[_0x3ecd('0x2c')][_0x3ecd('0x36')]);_0x50ea6b[_0x3ecd('0x37')]=qs[_0x3ecd('0x38')](_[_0x3ecd('0x4b')](_0x408d31[_0x3ecd('0x2c')],_0x12bfed[_0x3ecd('0x38')]));if(_0x408d31[_0x3ecd('0x2c')][_0x3ecd('0x3b')]){_0x50ea6b[_0x3ecd('0x37')]=_[_0x3ecd('0x39')](_0x50ea6b['where'],{'$or':_['map'](_0x50ea6b[_0x3ecd('0x2f')],function(_0x4e63fa){var _0x3358f5={};_0x3358f5[_0x4e63fa]={'$like':'%'+_0x408d31[_0x3ecd('0x2c')][_0x3ecd('0x3b')]+'%'};return _0x3358f5;})});}_0x50ea6b=_[_0x3ecd('0x39')]({},_0x50ea6b,_0x408d31[_0x3ecd('0x3c')]);return _0x1d5aca[_0x3ecd('0x4a')](_0x50ea6b);}})[_0x3ecd('0x21')](function(_0x2772f4){if(_0x2772f4){_0x280354=_0x2772f4[_0x3ecd('0x32')];if(!_0x408d31[_0x3ecd('0x2c')][_0x3ecd('0x33')](_0x3ecd('0x34'))){_0x50ea6b[_0x3ecd('0x1a')]=qs[_0x3ecd('0x1a')](_0x408d31[_0x3ecd('0x2c')][_0x3ecd('0x1a')]);_0x50ea6b[_0x3ecd('0x19')]=qs['offset'](_0x408d31[_0x3ecd('0x2c')][_0x3ecd('0x19')]);}return _0x1d5aca[_0x3ecd('0x4a')](_0x50ea6b);}})[_0x3ecd('0x21')](function(_0x3e7008){if(_0x3e7008){return _0x3e7008?{'count':_0x280354,'rows':_0x3e7008}:null;}})['then'](respondWithResult(_0x2a673b,null))[_0x3ecd('0x44')](handleError(_0x2a673b,null));};exports[_0x3ecd('0x4c')]=function(_0x5763fe,_0x30100e,_0x247f99){var _0x10ca4e={};var _0x2b2a07={};var _0x401c5d;var _0x500ad5;return db[_0x3ecd('0x3f')]['findOne']({'where':{'id':_0x5763fe['params']['id']}})[_0x3ecd('0x21')](handleEntityNotFound(_0x30100e,null))['then'](function(_0x1d040b){if(_0x1d040b){_0x401c5d=_0x1d040b;_0x2b2a07['model']=_[_0x3ecd('0x2d')](db[_0x3ecd('0x49')][_0x3ecd('0x29')]);_0x2b2a07[_0x3ecd('0x2c')]=_[_0x3ecd('0x2d')](_0x5763fe['query']);_0x2b2a07[_0x3ecd('0x38')]=_[_0x3ecd('0x2e')](_0x2b2a07[_0x3ecd('0x30')],_0x2b2a07[_0x3ecd('0x2c')]);_0x10ca4e[_0x3ecd('0x2f')]=_['intersection'](_0x2b2a07[_0x3ecd('0x30')],qs[_0x3ecd('0x31')](_0x5763fe[_0x3ecd('0x2c')][_0x3ecd('0x31')]));_0x10ca4e['attributes']=_0x10ca4e[_0x3ecd('0x2f')]['length']?_0x10ca4e['attributes']:_0x2b2a07[_0x3ecd('0x30')];_0x10ca4e[_0x3ecd('0x35')]=qs[_0x3ecd('0x36')](_0x5763fe['query'][_0x3ecd('0x36')]);_0x10ca4e[_0x3ecd('0x37')]=qs[_0x3ecd('0x38')](_['pick'](_0x5763fe[_0x3ecd('0x2c')],_0x2b2a07['filters']));if(_0x5763fe[_0x3ecd('0x2c')][_0x3ecd('0x3b')]){_0x10ca4e[_0x3ecd('0x37')]=_[_0x3ecd('0x39')](_0x10ca4e[_0x3ecd('0x37')],{'$or':_[_0x3ecd('0x28')](_0x10ca4e[_0x3ecd('0x2f')],function(_0x9065e){var _0x3cc84d={};_0x3cc84d[_0x9065e]={'$like':'%'+_0x5763fe['query']['filter']+'%'};return _0x3cc84d;})});}_0x10ca4e=_[_0x3ecd('0x39')]({},_0x10ca4e,_0x5763fe[_0x3ecd('0x3c')]);return _0x401c5d['getDescriptions'](_0x10ca4e);}})[_0x3ecd('0x21')](function(_0x2a0741){if(_0x2a0741){_0x500ad5=_0x2a0741[_0x3ecd('0x32')];if(!_0x5763fe[_0x3ecd('0x2c')]['hasOwnProperty'](_0x3ecd('0x34'))){_0x10ca4e[_0x3ecd('0x1a')]=qs[_0x3ecd('0x1a')](_0x5763fe['query'][_0x3ecd('0x1a')]);_0x10ca4e[_0x3ecd('0x19')]=qs[_0x3ecd('0x19')](_0x5763fe[_0x3ecd('0x2c')][_0x3ecd('0x19')]);}return _0x401c5d['getDescriptions'](_0x10ca4e);}})[_0x3ecd('0x21')](function(_0x323446){if(_0x323446){return _0x323446?{'count':_0x500ad5,'rows':_0x323446}:null;}})[_0x3ecd('0x21')](respondWithResult(_0x30100e,null))[_0x3ecd('0x44')](handleError(_0x30100e,null));};