Built motion from commit 449495f6.|2.6.27
[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 _0xb150=['pick','filter','merge','VIRTUAL','options','includeAll','findAll','rows','catch','show','params','find','create','body','getFields','SugarcrmField','map','getSubjects','findOne','getDescriptions','eml-format','zip-dir','request-promise','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','status','end','offset','undefined','count','limit','set','save','update','then','destroy','sendStatus','error','stack','name','send','index','SugarcrmConfiguration','rawAttributes','fieldName','type','key','query','keys','filters','intersection','model','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where'];(function(_0x4620bb,_0x442ff6){var _0x3c23df=function(_0x22d21e){while(--_0x22d21e){_0x4620bb['push'](_0x4620bb['shift']());}};_0x3c23df(++_0x442ff6);}(_0xb150,0xb8));var _0x0b15=function(_0x29adb1,_0x98a1c2){_0x29adb1=_0x29adb1-0x0;var _0x16bc9e=_0xb150[_0x29adb1];return _0x16bc9e;};'use strict';var emlformat=require(_0x0b15('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x0b15('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0x0b15('0x2'));var moment=require('moment');var BPromise=require(_0x0b15('0x3'));var Mustache=require(_0x0b15('0x4'));var util=require(_0x0b15('0x5'));var path=require(_0x0b15('0x6'));var sox=require(_0x0b15('0x7'));var csv=require(_0x0b15('0x8'));var ejs=require(_0x0b15('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x0b15('0xa'));var squel=require(_0x0b15('0xb'));var crypto=require(_0x0b15('0xc'));var jsforce=require(_0x0b15('0xd'));var deskjs=require(_0x0b15('0xe'));var toCsv=require(_0x0b15('0x8'));var querystring=require(_0x0b15('0xf'));var Papa=require(_0x0b15('0x10'));var Redis=require(_0x0b15('0x11'));var authService=require(_0x0b15('0x12'));var qs=require(_0x0b15('0x13'));var as=require(_0x0b15('0x14'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x0b15('0x15'))(_0x0b15('0x16'));var utils=require(_0x0b15('0x17'));var config=require(_0x0b15('0x18'));var licenseUtil=require(_0x0b15('0x19'));var db=require(_0x0b15('0x1a'))['db'];function respondWithStatusCode(_0x1d0ade,_0x57cdf2){_0x57cdf2=_0x57cdf2||0xcc;return function(_0x3df598){if(_0x3df598){return _0x1d0ade['sendStatus'](_0x57cdf2);}return _0x1d0ade[_0x0b15('0x1b')](_0x57cdf2)[_0x0b15('0x1c')]();};}function respondWithResult(_0x37d5c0,_0xfb7a2b){_0xfb7a2b=_0xfb7a2b||0xc8;return function(_0x459674){if(_0x459674){return _0x37d5c0['status'](_0xfb7a2b)['json'](_0x459674);}};}function respondWithFilteredResult(_0x4e157d,_0x29b969){return function(_0x4440fb){if(_0x4440fb){var _0xcda949=typeof _0x29b969[_0x0b15('0x1d')]===_0x0b15('0x1e')&&typeof _0x29b969['limit']===_0x0b15('0x1e');var _0x9a784=_0x4440fb['count'];var _0x4ba1a8=_0xcda949?0x0:_0x29b969['offset'];var _0x37e692=_0xcda949?_0x4440fb[_0x0b15('0x1f')]:_0x29b969[_0x0b15('0x1d')]+_0x29b969[_0x0b15('0x20')];var _0x1d830a;if(_0x37e692>=_0x9a784){_0x37e692=_0x9a784;_0x1d830a=0xc8;}else{_0x1d830a=0xce;}_0x4e157d['status'](_0x1d830a);return _0x4e157d[_0x0b15('0x21')]('Content-Range',_0x4ba1a8+'-'+_0x37e692+'/'+_0x9a784)['json'](_0x4440fb);}return null;};}function patchUpdates(_0x156e44){return function(_0xbc33a3){try{jsonpatch['apply'](_0xbc33a3,_0x156e44,!![]);}catch(_0x2963d8){return BPromise['reject'](_0x2963d8);}return _0xbc33a3[_0x0b15('0x22')]();};}function saveUpdates(_0x3de282,_0x5d8701){return function(_0x269293){if(_0x269293){return _0x269293[_0x0b15('0x23')](_0x3de282)[_0x0b15('0x24')](function(_0x3539d9){return _0x3539d9;});}return null;};}function removeEntity(_0x103544,_0x4a5445){return function(_0x221751){if(_0x221751){return _0x221751[_0x0b15('0x25')]()[_0x0b15('0x24')](function(){_0x103544[_0x0b15('0x1b')](0xcc)[_0x0b15('0x1c')]();});}};}function handleEntityNotFound(_0xa04547,_0x4cc78f){return function(_0x1a6d7a){if(!_0x1a6d7a){_0xa04547[_0x0b15('0x26')](0x194);}return _0x1a6d7a;};}function handleError(_0x30e669,_0x21c327){_0x21c327=_0x21c327||0x1f4;return function(_0x2a0fdf){logger[_0x0b15('0x27')](_0x2a0fdf[_0x0b15('0x28')]);if(_0x2a0fdf[_0x0b15('0x29')]){delete _0x2a0fdf['name'];}_0x30e669[_0x0b15('0x1b')](_0x21c327)[_0x0b15('0x2a')](_0x2a0fdf);};}exports[_0x0b15('0x2b')]=function(_0x4da157,_0x43b636){var _0x45aab9={},_0x178328={},_0x1a0237={'count':0x0,'rows':[]};var _0xa45fa6=_['map'](db[_0x0b15('0x2c')][_0x0b15('0x2d')],function(_0x41ab5e){return{'name':_0x41ab5e[_0x0b15('0x2e')],'type':_0x41ab5e[_0x0b15('0x2f')][_0x0b15('0x30')]};});_0x178328['model']=_['map'](_0xa45fa6,_0x0b15('0x29'));_0x178328[_0x0b15('0x31')]=_[_0x0b15('0x32')](_0x4da157[_0x0b15('0x31')]);_0x178328[_0x0b15('0x33')]=_[_0x0b15('0x34')](_0x178328[_0x0b15('0x35')],_0x178328[_0x0b15('0x31')]);_0x45aab9['attributes']=_['intersection'](_0x178328[_0x0b15('0x35')],qs[_0x0b15('0x36')](_0x4da157[_0x0b15('0x31')]['fields']));_0x45aab9[_0x0b15('0x37')]=_0x45aab9['attributes'][_0x0b15('0x38')]?_0x45aab9['attributes']:_0x178328[_0x0b15('0x35')];if(!_0x4da157[_0x0b15('0x31')][_0x0b15('0x39')](_0x0b15('0x3a'))){_0x45aab9[_0x0b15('0x20')]=qs['limit'](_0x4da157[_0x0b15('0x31')]['limit']);_0x45aab9[_0x0b15('0x1d')]=qs[_0x0b15('0x1d')](_0x4da157['query']['offset']);}_0x45aab9[_0x0b15('0x3b')]=qs[_0x0b15('0x3c')](_0x4da157[_0x0b15('0x31')][_0x0b15('0x3c')]);_0x45aab9[_0x0b15('0x3d')]=qs['filters'](_[_0x0b15('0x3e')](_0x4da157[_0x0b15('0x31')],_0x178328[_0x0b15('0x33')]),_0xa45fa6);if(_0x4da157['query'][_0x0b15('0x3f')]){_0x45aab9[_0x0b15('0x3d')]=_[_0x0b15('0x40')](_0x45aab9[_0x0b15('0x3d')],{'$or':_['map'](_0xa45fa6,function(_0x2542b8){if(_0x2542b8[_0x0b15('0x2f')]!==_0x0b15('0x41')){var _0x18d661={};_0x18d661[_0x2542b8[_0x0b15('0x29')]]={'$like':'%'+_0x4da157[_0x0b15('0x31')][_0x0b15('0x3f')]+'%'};return _0x18d661;}})});}_0x45aab9=_['merge']({},_0x45aab9,_0x4da157[_0x0b15('0x42')]);var _0x46626f={'where':_0x45aab9['where']};return db['SugarcrmConfiguration']['count'](_0x46626f)['then'](function(_0x385b04){_0x1a0237[_0x0b15('0x1f')]=_0x385b04;if(_0x4da157['query'][_0x0b15('0x43')]){_0x45aab9['include']=[{'all':!![]}];}return db[_0x0b15('0x2c')][_0x0b15('0x44')](_0x45aab9);})[_0x0b15('0x24')](function(_0x27497d){_0x1a0237[_0x0b15('0x45')]=_0x27497d;return _0x1a0237;})[_0x0b15('0x24')](respondWithFilteredResult(_0x43b636,_0x45aab9))[_0x0b15('0x46')](handleError(_0x43b636,null));};exports[_0x0b15('0x47')]=function(_0x5267d3,_0x38b6c1){var _0x22d973={'raw':![],'where':{'id':_0x5267d3[_0x0b15('0x48')]['id']}},_0x5d700e={};_0x5d700e['model']=_[_0x0b15('0x32')](db[_0x0b15('0x2c')]['rawAttributes']);_0x5d700e[_0x0b15('0x31')]=_[_0x0b15('0x32')](_0x5267d3[_0x0b15('0x31')]);_0x5d700e[_0x0b15('0x33')]=_['intersection'](_0x5d700e[_0x0b15('0x35')],_0x5d700e[_0x0b15('0x31')]);_0x22d973['attributes']=_[_0x0b15('0x34')](_0x5d700e[_0x0b15('0x35')],qs[_0x0b15('0x36')](_0x5267d3['query'][_0x0b15('0x36')]));_0x22d973[_0x0b15('0x37')]=_0x22d973['attributes'][_0x0b15('0x38')]?_0x22d973[_0x0b15('0x37')]:_0x5d700e[_0x0b15('0x35')];if(_0x5267d3[_0x0b15('0x31')][_0x0b15('0x43')]){_0x22d973['include']=[{'all':!![]}];}_0x22d973=_[_0x0b15('0x40')]({},_0x22d973,_0x5267d3['options']);return db['SugarcrmConfiguration'][_0x0b15('0x49')](_0x22d973)[_0x0b15('0x24')](handleEntityNotFound(_0x38b6c1,null))[_0x0b15('0x24')](respondWithResult(_0x38b6c1,null))[_0x0b15('0x46')](handleError(_0x38b6c1,null));};exports['create']=function(_0x27dbce,_0x355ad9){return db[_0x0b15('0x2c')][_0x0b15('0x4a')](_0x27dbce[_0x0b15('0x4b')],{})[_0x0b15('0x24')](respondWithResult(_0x355ad9,0xc9))[_0x0b15('0x46')](handleError(_0x355ad9,null));};exports[_0x0b15('0x23')]=function(_0x361259,_0x14b66f){if(_0x361259[_0x0b15('0x4b')]['id']){delete _0x361259['body']['id'];}return db['SugarcrmConfiguration'][_0x0b15('0x49')]({'where':{'id':_0x361259[_0x0b15('0x48')]['id']}})['then'](handleEntityNotFound(_0x14b66f,null))[_0x0b15('0x24')](saveUpdates(_0x361259['body'],null))[_0x0b15('0x24')](respondWithResult(_0x14b66f,null))[_0x0b15('0x46')](handleError(_0x14b66f,null));};exports[_0x0b15('0x25')]=function(_0xcb9fe8,_0x33c2c9){return db['SugarcrmConfiguration'][_0x0b15('0x49')]({'where':{'id':_0xcb9fe8[_0x0b15('0x48')]['id']}})[_0x0b15('0x24')](handleEntityNotFound(_0x33c2c9,null))[_0x0b15('0x24')](removeEntity(_0x33c2c9,null))['catch'](handleError(_0x33c2c9,null));};exports[_0x0b15('0x4c')]=function(_0x13517a,_0x469e70,_0x7978e4){var _0x1926ef={};var _0xaad442={};var _0x5955bb;var _0x1f45ea;return db[_0x0b15('0x2c')]['findOne']({'where':{'id':_0x13517a[_0x0b15('0x48')]['id']}})[_0x0b15('0x24')](handleEntityNotFound(_0x469e70,null))[_0x0b15('0x24')](function(_0x4fc93e){if(_0x4fc93e){_0x5955bb=_0x4fc93e;_0xaad442[_0x0b15('0x35')]=_[_0x0b15('0x32')](db[_0x0b15('0x4d')][_0x0b15('0x2d')]);_0xaad442[_0x0b15('0x31')]=_[_0x0b15('0x32')](_0x13517a[_0x0b15('0x31')]);_0xaad442['filters']=_[_0x0b15('0x34')](_0xaad442[_0x0b15('0x35')],_0xaad442[_0x0b15('0x31')]);_0x1926ef['attributes']=_[_0x0b15('0x34')](_0xaad442[_0x0b15('0x35')],qs[_0x0b15('0x36')](_0x13517a[_0x0b15('0x31')]['fields']));_0x1926ef[_0x0b15('0x37')]=_0x1926ef['attributes'][_0x0b15('0x38')]?_0x1926ef['attributes']:_0xaad442[_0x0b15('0x35')];_0x1926ef['order']=qs[_0x0b15('0x3c')](_0x13517a['query'][_0x0b15('0x3c')]);_0x1926ef[_0x0b15('0x3d')]=qs[_0x0b15('0x33')](_[_0x0b15('0x3e')](_0x13517a[_0x0b15('0x31')],_0xaad442[_0x0b15('0x33')]));if(_0x13517a['query'][_0x0b15('0x3f')]){_0x1926ef[_0x0b15('0x3d')]=_[_0x0b15('0x40')](_0x1926ef['where'],{'$or':_[_0x0b15('0x4e')](_0x1926ef['attributes'],function(_0x1bd4d1){var _0x2be2d6={};_0x2be2d6[_0x1bd4d1]={'$like':'%'+_0x13517a[_0x0b15('0x31')][_0x0b15('0x3f')]+'%'};return _0x2be2d6;})});}_0x1926ef=_['merge']({},_0x1926ef,_0x13517a[_0x0b15('0x42')]);return _0x5955bb[_0x0b15('0x4c')](_0x1926ef);}})['then'](function(_0x379ec1){if(_0x379ec1){_0x1f45ea=_0x379ec1['length'];if(!_0x13517a[_0x0b15('0x31')][_0x0b15('0x39')]('nolimit')){_0x1926ef[_0x0b15('0x20')]=qs[_0x0b15('0x20')](_0x13517a[_0x0b15('0x31')]['limit']);_0x1926ef['offset']=qs[_0x0b15('0x1d')](_0x13517a['query']['offset']);}return _0x5955bb[_0x0b15('0x4c')](_0x1926ef);}})[_0x0b15('0x24')](function(_0x5ae0c6){if(_0x5ae0c6){return _0x5ae0c6?{'count':_0x1f45ea,'rows':_0x5ae0c6}:null;}})['then'](respondWithResult(_0x469e70,null))[_0x0b15('0x46')](handleError(_0x469e70,null));};exports[_0x0b15('0x4f')]=function(_0x2d3f80,_0x2972cb,_0xc6a637){var _0x45176f={};var _0x4c4114={};var _0x5b0e71;var _0x4234f4;return db[_0x0b15('0x2c')][_0x0b15('0x50')]({'where':{'id':_0x2d3f80[_0x0b15('0x48')]['id']}})[_0x0b15('0x24')](handleEntityNotFound(_0x2972cb,null))['then'](function(_0x50d140){if(_0x50d140){_0x5b0e71=_0x50d140;_0x4c4114['model']=_[_0x0b15('0x32')](db[_0x0b15('0x4d')][_0x0b15('0x2d')]);_0x4c4114['query']=_[_0x0b15('0x32')](_0x2d3f80[_0x0b15('0x31')]);_0x4c4114[_0x0b15('0x33')]=_[_0x0b15('0x34')](_0x4c4114[_0x0b15('0x35')],_0x4c4114[_0x0b15('0x31')]);_0x45176f[_0x0b15('0x37')]=_[_0x0b15('0x34')](_0x4c4114[_0x0b15('0x35')],qs[_0x0b15('0x36')](_0x2d3f80[_0x0b15('0x31')][_0x0b15('0x36')]));_0x45176f['attributes']=_0x45176f[_0x0b15('0x37')][_0x0b15('0x38')]?_0x45176f[_0x0b15('0x37')]:_0x4c4114[_0x0b15('0x35')];_0x45176f[_0x0b15('0x3b')]=qs[_0x0b15('0x3c')](_0x2d3f80[_0x0b15('0x31')]['sort']);_0x45176f['where']=qs[_0x0b15('0x33')](_[_0x0b15('0x3e')](_0x2d3f80['query'],_0x4c4114['filters']));if(_0x2d3f80[_0x0b15('0x31')][_0x0b15('0x3f')]){_0x45176f['where']=_[_0x0b15('0x40')](_0x45176f[_0x0b15('0x3d')],{'$or':_[_0x0b15('0x4e')](_0x45176f['attributes'],function(_0x18f47a){var _0x47c002={};_0x47c002[_0x18f47a]={'$like':'%'+_0x2d3f80[_0x0b15('0x31')]['filter']+'%'};return _0x47c002;})});}_0x45176f=_[_0x0b15('0x40')]({},_0x45176f,_0x2d3f80[_0x0b15('0x42')]);return _0x5b0e71[_0x0b15('0x4f')](_0x45176f);}})['then'](function(_0x4c377c){if(_0x4c377c){_0x4234f4=_0x4c377c[_0x0b15('0x38')];if(!_0x2d3f80[_0x0b15('0x31')][_0x0b15('0x39')](_0x0b15('0x3a'))){_0x45176f[_0x0b15('0x20')]=qs['limit'](_0x2d3f80[_0x0b15('0x31')][_0x0b15('0x20')]);_0x45176f[_0x0b15('0x1d')]=qs[_0x0b15('0x1d')](_0x2d3f80['query'][_0x0b15('0x1d')]);}return _0x5b0e71[_0x0b15('0x4f')](_0x45176f);}})[_0x0b15('0x24')](function(_0xda9f06){if(_0xda9f06){return _0xda9f06?{'count':_0x4234f4,'rows':_0xda9f06}:null;}})[_0x0b15('0x24')](respondWithResult(_0x2972cb,null))['catch'](handleError(_0x2972cb,null));};exports[_0x0b15('0x51')]=function(_0x5f52ab,_0x13ab11,_0x2a3c78){var _0x326fdf={};var _0x30894a={};var _0x261c01;var _0x469c8e;return db['SugarcrmConfiguration']['findOne']({'where':{'id':_0x5f52ab[_0x0b15('0x48')]['id']}})[_0x0b15('0x24')](handleEntityNotFound(_0x13ab11,null))['then'](function(_0x5f11b6){if(_0x5f11b6){_0x261c01=_0x5f11b6;_0x30894a[_0x0b15('0x35')]=_['keys'](db[_0x0b15('0x4d')]['rawAttributes']);_0x30894a[_0x0b15('0x31')]=_[_0x0b15('0x32')](_0x5f52ab[_0x0b15('0x31')]);_0x30894a[_0x0b15('0x33')]=_['intersection'](_0x30894a['model'],_0x30894a[_0x0b15('0x31')]);_0x326fdf[_0x0b15('0x37')]=_[_0x0b15('0x34')](_0x30894a[_0x0b15('0x35')],qs[_0x0b15('0x36')](_0x5f52ab['query'][_0x0b15('0x36')]));_0x326fdf['attributes']=_0x326fdf[_0x0b15('0x37')][_0x0b15('0x38')]?_0x326fdf['attributes']:_0x30894a[_0x0b15('0x35')];_0x326fdf[_0x0b15('0x3b')]=qs[_0x0b15('0x3c')](_0x5f52ab['query'][_0x0b15('0x3c')]);_0x326fdf[_0x0b15('0x3d')]=qs[_0x0b15('0x33')](_['pick'](_0x5f52ab['query'],_0x30894a[_0x0b15('0x33')]));if(_0x5f52ab['query'][_0x0b15('0x3f')]){_0x326fdf[_0x0b15('0x3d')]=_['merge'](_0x326fdf['where'],{'$or':_[_0x0b15('0x4e')](_0x326fdf[_0x0b15('0x37')],function(_0x38ff13){var _0x2c9257={};_0x2c9257[_0x38ff13]={'$like':'%'+_0x5f52ab['query'][_0x0b15('0x3f')]+'%'};return _0x2c9257;})});}_0x326fdf=_[_0x0b15('0x40')]({},_0x326fdf,_0x5f52ab[_0x0b15('0x42')]);return _0x261c01[_0x0b15('0x51')](_0x326fdf);}})[_0x0b15('0x24')](function(_0x4e6125){if(_0x4e6125){_0x469c8e=_0x4e6125[_0x0b15('0x38')];if(!_0x5f52ab[_0x0b15('0x31')][_0x0b15('0x39')](_0x0b15('0x3a'))){_0x326fdf['limit']=qs[_0x0b15('0x20')](_0x5f52ab['query'][_0x0b15('0x20')]);_0x326fdf['offset']=qs[_0x0b15('0x1d')](_0x5f52ab[_0x0b15('0x31')]['offset']);}return _0x261c01[_0x0b15('0x51')](_0x326fdf);}})[_0x0b15('0x24')](function(_0x550895){if(_0x550895){return _0x550895?{'count':_0x469c8e,'rows':_0x550895}:null;}})[_0x0b15('0x24')](respondWithResult(_0x13ab11,null))[_0x0b15('0x46')](handleError(_0x13ab11,null));};