73992daddab0637e6f022889b2874984a99481de
[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 _0xcefc=['json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','then','destroy','error','stack','name','send','index','map','SugarcrmConfiguration','fieldName','type','key','query','keys','intersection','model','attributes','fields','length','nolimit','order','sort','where','filters','pick','filter','merge','options','includeAll','include','findAll','rows','catch','show','params','rawAttributes','find','create','body','SugarcrmField','getFields','hasOwnProperty','getSubjects','getDescriptions','findOne','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','util','sox','to-csv','fs-extra','lodash','squel','crypto','jsforce','desk.js','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end'];(function(_0x57405d,_0x5b87c6){var _0x3cf792=function(_0x434e0c){while(--_0x434e0c){_0x57405d['push'](_0x57405d['shift']());}};_0x3cf792(++_0x5b87c6);}(_0xcefc,0x131));var _0xccef=function(_0x46f769,_0x37c80c){_0x46f769=_0x46f769-0x0;var _0x5e7dfd=_0xcefc[_0x46f769];return _0x5e7dfd;};'use strict';var emlformat=require(_0xccef('0x0'));var rimraf=require(_0xccef('0x1'));var zipdir=require(_0xccef('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0xccef('0x3'));var moment=require(_0xccef('0x4'));var BPromise=require(_0xccef('0x5'));var Mustache=require('mustache');var util=require(_0xccef('0x6'));var path=require('path');var sox=require(_0xccef('0x7'));var csv=require(_0xccef('0x8'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xccef('0x9'));var _=require(_0xccef('0xa'));var squel=require(_0xccef('0xb'));var crypto=require(_0xccef('0xc'));var jsforce=require(_0xccef('0xd'));var deskjs=require(_0xccef('0xe'));var toCsv=require(_0xccef('0x8'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0xccef('0xf'));var qs=require(_0xccef('0x10'));var as=require(_0xccef('0x11'));var hardwareService=require(_0xccef('0x12'));var logger=require(_0xccef('0x13'))(_0xccef('0x14'));var utils=require('../../config/utils');var config=require(_0xccef('0x15'));var licenseUtil=require(_0xccef('0x16'));var db=require(_0xccef('0x17'))['db'];function respondWithStatusCode(_0xb07e54,_0x3e1730){_0x3e1730=_0x3e1730||0xcc;return function(_0x20ef9a){if(_0x20ef9a){return _0xb07e54[_0xccef('0x18')](_0x3e1730);}return _0xb07e54[_0xccef('0x19')](_0x3e1730)[_0xccef('0x1a')]();};}function respondWithResult(_0x189898,_0x4f6e3a){_0x4f6e3a=_0x4f6e3a||0xc8;return function(_0x409711){if(_0x409711){return _0x189898['status'](_0x4f6e3a)[_0xccef('0x1b')](_0x409711);}};}function respondWithFilteredResult(_0x37e761,_0x3e04af){return function(_0x285f3f){if(_0x285f3f){var _0x11dbe6=typeof _0x3e04af[_0xccef('0x1c')]===_0xccef('0x1d')&&typeof _0x3e04af[_0xccef('0x1e')]===_0xccef('0x1d');var _0x583547=_0x285f3f[_0xccef('0x1f')];var _0xfe29f3=_0x11dbe6?0x0:_0x3e04af[_0xccef('0x1c')];var _0x1a186f=_0x11dbe6?_0x285f3f[_0xccef('0x1f')]:_0x3e04af[_0xccef('0x1c')]+_0x3e04af[_0xccef('0x1e')];var _0x5f5292;if(_0x1a186f>=_0x583547){_0x1a186f=_0x583547;_0x5f5292=0xc8;}else{_0x5f5292=0xce;}_0x37e761[_0xccef('0x19')](_0x5f5292);return _0x37e761[_0xccef('0x20')](_0xccef('0x21'),_0xfe29f3+'-'+_0x1a186f+'/'+_0x583547)[_0xccef('0x1b')](_0x285f3f);}return null;};}function patchUpdates(_0x3722c8){return function(_0x5653f3){try{jsonpatch[_0xccef('0x22')](_0x5653f3,_0x3722c8,!![]);}catch(_0x486036){return BPromise[_0xccef('0x23')](_0x486036);}return _0x5653f3[_0xccef('0x24')]();};}function saveUpdates(_0x3270f6,_0x4eb885){return function(_0x3df255){if(_0x3df255){return _0x3df255[_0xccef('0x25')](_0x3270f6)[_0xccef('0x26')](function(_0x131f6b){return _0x131f6b;});}return null;};}function removeEntity(_0x253681,_0x1ae15a){return function(_0x19a593){if(_0x19a593){return _0x19a593[_0xccef('0x27')]()[_0xccef('0x26')](function(){_0x253681[_0xccef('0x19')](0xcc)[_0xccef('0x1a')]();});}};}function handleEntityNotFound(_0x35d132,_0x4ae293){return function(_0x1893f4){if(!_0x1893f4){_0x35d132[_0xccef('0x18')](0x194);}return _0x1893f4;};}function handleError(_0x18a8fc,_0x5166e2){_0x5166e2=_0x5166e2||0x1f4;return function(_0x4d1ed1){logger[_0xccef('0x28')](_0x4d1ed1[_0xccef('0x29')]);if(_0x4d1ed1[_0xccef('0x2a')]){delete _0x4d1ed1[_0xccef('0x2a')];}_0x18a8fc[_0xccef('0x19')](_0x5166e2)[_0xccef('0x2b')](_0x4d1ed1);};}exports[_0xccef('0x2c')]=function(_0x151677,_0x220ffa){var _0x33ccf9={},_0xea7ad5={},_0xf4d00d={'count':0x0,'rows':[]};var _0x1f817b=_[_0xccef('0x2d')](db[_0xccef('0x2e')]['rawAttributes'],function(_0x1a2229){return{'name':_0x1a2229[_0xccef('0x2f')],'type':_0x1a2229[_0xccef('0x30')][_0xccef('0x31')]};});_0xea7ad5['model']=_['map'](_0x1f817b,_0xccef('0x2a'));_0xea7ad5[_0xccef('0x32')]=_[_0xccef('0x33')](_0x151677[_0xccef('0x32')]);_0xea7ad5['filters']=_[_0xccef('0x34')](_0xea7ad5[_0xccef('0x35')],_0xea7ad5[_0xccef('0x32')]);_0x33ccf9[_0xccef('0x36')]=_[_0xccef('0x34')](_0xea7ad5[_0xccef('0x35')],qs[_0xccef('0x37')](_0x151677['query']['fields']));_0x33ccf9[_0xccef('0x36')]=_0x33ccf9[_0xccef('0x36')][_0xccef('0x38')]?_0x33ccf9['attributes']:_0xea7ad5['model'];if(!_0x151677[_0xccef('0x32')]['hasOwnProperty'](_0xccef('0x39'))){_0x33ccf9[_0xccef('0x1e')]=qs['limit'](_0x151677[_0xccef('0x32')]['limit']);_0x33ccf9[_0xccef('0x1c')]=qs[_0xccef('0x1c')](_0x151677[_0xccef('0x32')][_0xccef('0x1c')]);}_0x33ccf9[_0xccef('0x3a')]=qs['sort'](_0x151677[_0xccef('0x32')][_0xccef('0x3b')]);_0x33ccf9[_0xccef('0x3c')]=qs[_0xccef('0x3d')](_[_0xccef('0x3e')](_0x151677['query'],_0xea7ad5['filters']),_0x1f817b);if(_0x151677['query'][_0xccef('0x3f')]){_0x33ccf9[_0xccef('0x3c')]=_[_0xccef('0x40')](_0x33ccf9['where'],{'$or':_[_0xccef('0x2d')](_0x1f817b,function(_0x2ba57e){if(_0x2ba57e[_0xccef('0x30')]!=='VIRTUAL'){var _0x11c6c4={};_0x11c6c4[_0x2ba57e[_0xccef('0x2a')]]={'$like':'%'+_0x151677[_0xccef('0x32')][_0xccef('0x3f')]+'%'};return _0x11c6c4;}})});}_0x33ccf9=_['merge']({},_0x33ccf9,_0x151677[_0xccef('0x41')]);var _0x18b7b6={'where':_0x33ccf9[_0xccef('0x3c')]};return db['SugarcrmConfiguration'][_0xccef('0x1f')](_0x18b7b6)[_0xccef('0x26')](function(_0x78b843){_0xf4d00d['count']=_0x78b843;if(_0x151677['query'][_0xccef('0x42')]){_0x33ccf9[_0xccef('0x43')]=[{'all':!![]}];}return db[_0xccef('0x2e')][_0xccef('0x44')](_0x33ccf9);})[_0xccef('0x26')](function(_0x43b640){_0xf4d00d[_0xccef('0x45')]=_0x43b640;return _0xf4d00d;})['then'](respondWithFilteredResult(_0x220ffa,_0x33ccf9))[_0xccef('0x46')](handleError(_0x220ffa,null));};exports[_0xccef('0x47')]=function(_0xb903b3,_0x25764c){var _0x71ac7b={'raw':![],'where':{'id':_0xb903b3[_0xccef('0x48')]['id']}},_0xc8cb72={};_0xc8cb72[_0xccef('0x35')]=_[_0xccef('0x33')](db['SugarcrmConfiguration'][_0xccef('0x49')]);_0xc8cb72[_0xccef('0x32')]=_[_0xccef('0x33')](_0xb903b3[_0xccef('0x32')]);_0xc8cb72[_0xccef('0x3d')]=_[_0xccef('0x34')](_0xc8cb72[_0xccef('0x35')],_0xc8cb72['query']);_0x71ac7b[_0xccef('0x36')]=_[_0xccef('0x34')](_0xc8cb72['model'],qs[_0xccef('0x37')](_0xb903b3[_0xccef('0x32')][_0xccef('0x37')]));_0x71ac7b['attributes']=_0x71ac7b['attributes'][_0xccef('0x38')]?_0x71ac7b[_0xccef('0x36')]:_0xc8cb72[_0xccef('0x35')];if(_0xb903b3[_0xccef('0x32')]['includeAll']){_0x71ac7b[_0xccef('0x43')]=[{'all':!![]}];}_0x71ac7b=_[_0xccef('0x40')]({},_0x71ac7b,_0xb903b3[_0xccef('0x41')]);return db[_0xccef('0x2e')][_0xccef('0x4a')](_0x71ac7b)[_0xccef('0x26')](handleEntityNotFound(_0x25764c,null))[_0xccef('0x26')](respondWithResult(_0x25764c,null))['catch'](handleError(_0x25764c,null));};exports[_0xccef('0x4b')]=function(_0x46b652,_0x5c8eac){return db[_0xccef('0x2e')][_0xccef('0x4b')](_0x46b652['body'],{})[_0xccef('0x26')](respondWithResult(_0x5c8eac,0xc9))[_0xccef('0x46')](handleError(_0x5c8eac,null));};exports['update']=function(_0x1f3b47,_0x33e254){if(_0x1f3b47['body']['id']){delete _0x1f3b47[_0xccef('0x4c')]['id'];}return db[_0xccef('0x2e')]['find']({'where':{'id':_0x1f3b47[_0xccef('0x48')]['id']}})[_0xccef('0x26')](handleEntityNotFound(_0x33e254,null))[_0xccef('0x26')](saveUpdates(_0x1f3b47[_0xccef('0x4c')],null))['then'](respondWithResult(_0x33e254,null))[_0xccef('0x46')](handleError(_0x33e254,null));};exports[_0xccef('0x27')]=function(_0x204039,_0x3f3ebe){return db[_0xccef('0x2e')][_0xccef('0x4a')]({'where':{'id':_0x204039[_0xccef('0x48')]['id']}})[_0xccef('0x26')](handleEntityNotFound(_0x3f3ebe,null))[_0xccef('0x26')](removeEntity(_0x3f3ebe,null))['catch'](handleError(_0x3f3ebe,null));};exports['getFields']=function(_0x3a63c,_0x39d415,_0x28e32c){var _0x583598={};var _0x5b8b43={};var _0x3914b8;var _0x12f04c;return db[_0xccef('0x2e')]['findOne']({'where':{'id':_0x3a63c[_0xccef('0x48')]['id']}})[_0xccef('0x26')](handleEntityNotFound(_0x39d415,null))[_0xccef('0x26')](function(_0x47e08e){if(_0x47e08e){_0x3914b8=_0x47e08e;_0x5b8b43[_0xccef('0x35')]=_[_0xccef('0x33')](db[_0xccef('0x4d')]['rawAttributes']);_0x5b8b43[_0xccef('0x32')]=_[_0xccef('0x33')](_0x3a63c[_0xccef('0x32')]);_0x5b8b43[_0xccef('0x3d')]=_[_0xccef('0x34')](_0x5b8b43[_0xccef('0x35')],_0x5b8b43[_0xccef('0x32')]);_0x583598['attributes']=_[_0xccef('0x34')](_0x5b8b43['model'],qs[_0xccef('0x37')](_0x3a63c[_0xccef('0x32')][_0xccef('0x37')]));_0x583598[_0xccef('0x36')]=_0x583598[_0xccef('0x36')][_0xccef('0x38')]?_0x583598['attributes']:_0x5b8b43[_0xccef('0x35')];_0x583598[_0xccef('0x3a')]=qs['sort'](_0x3a63c['query'][_0xccef('0x3b')]);_0x583598[_0xccef('0x3c')]=qs[_0xccef('0x3d')](_['pick'](_0x3a63c[_0xccef('0x32')],_0x5b8b43[_0xccef('0x3d')]));if(_0x3a63c[_0xccef('0x32')][_0xccef('0x3f')]){_0x583598[_0xccef('0x3c')]=_[_0xccef('0x40')](_0x583598[_0xccef('0x3c')],{'$or':_[_0xccef('0x2d')](_0x583598[_0xccef('0x36')],function(_0x4d35d3){var _0x3243f4={};_0x3243f4[_0x4d35d3]={'$like':'%'+_0x3a63c[_0xccef('0x32')]['filter']+'%'};return _0x3243f4;})});}_0x583598=_[_0xccef('0x40')]({},_0x583598,_0x3a63c[_0xccef('0x41')]);return _0x3914b8[_0xccef('0x4e')](_0x583598);}})['then'](function(_0x249e02){if(_0x249e02){_0x12f04c=_0x249e02['length'];if(!_0x3a63c['query'][_0xccef('0x4f')](_0xccef('0x39'))){_0x583598[_0xccef('0x1e')]=qs[_0xccef('0x1e')](_0x3a63c[_0xccef('0x32')][_0xccef('0x1e')]);_0x583598[_0xccef('0x1c')]=qs[_0xccef('0x1c')](_0x3a63c[_0xccef('0x32')][_0xccef('0x1c')]);}return _0x3914b8[_0xccef('0x4e')](_0x583598);}})[_0xccef('0x26')](function(_0x18082f){if(_0x18082f){return _0x18082f?{'count':_0x12f04c,'rows':_0x18082f}:null;}})[_0xccef('0x26')](respondWithResult(_0x39d415,null))[_0xccef('0x46')](handleError(_0x39d415,null));};exports[_0xccef('0x50')]=function(_0x45b393,_0x28a056,_0x13ceed){var _0x45ef22={};var _0xae7234={};var _0x4bfdf0;var _0x366631;return db[_0xccef('0x2e')]['findOne']({'where':{'id':_0x45b393['params']['id']}})[_0xccef('0x26')](handleEntityNotFound(_0x28a056,null))[_0xccef('0x26')](function(_0x3d8cbb){if(_0x3d8cbb){_0x4bfdf0=_0x3d8cbb;_0xae7234[_0xccef('0x35')]=_['keys'](db[_0xccef('0x4d')][_0xccef('0x49')]);_0xae7234[_0xccef('0x32')]=_[_0xccef('0x33')](_0x45b393[_0xccef('0x32')]);_0xae7234[_0xccef('0x3d')]=_[_0xccef('0x34')](_0xae7234['model'],_0xae7234[_0xccef('0x32')]);_0x45ef22[_0xccef('0x36')]=_[_0xccef('0x34')](_0xae7234[_0xccef('0x35')],qs[_0xccef('0x37')](_0x45b393[_0xccef('0x32')][_0xccef('0x37')]));_0x45ef22[_0xccef('0x36')]=_0x45ef22[_0xccef('0x36')]['length']?_0x45ef22[_0xccef('0x36')]:_0xae7234[_0xccef('0x35')];_0x45ef22[_0xccef('0x3a')]=qs[_0xccef('0x3b')](_0x45b393['query'][_0xccef('0x3b')]);_0x45ef22['where']=qs['filters'](_[_0xccef('0x3e')](_0x45b393[_0xccef('0x32')],_0xae7234['filters']));if(_0x45b393['query']['filter']){_0x45ef22[_0xccef('0x3c')]=_[_0xccef('0x40')](_0x45ef22[_0xccef('0x3c')],{'$or':_[_0xccef('0x2d')](_0x45ef22[_0xccef('0x36')],function(_0x147b28){var _0x1e5416={};_0x1e5416[_0x147b28]={'$like':'%'+_0x45b393[_0xccef('0x32')]['filter']+'%'};return _0x1e5416;})});}_0x45ef22=_['merge']({},_0x45ef22,_0x45b393[_0xccef('0x41')]);return _0x4bfdf0[_0xccef('0x50')](_0x45ef22);}})['then'](function(_0x3516d8){if(_0x3516d8){_0x366631=_0x3516d8['length'];if(!_0x45b393[_0xccef('0x32')][_0xccef('0x4f')]('nolimit')){_0x45ef22[_0xccef('0x1e')]=qs['limit'](_0x45b393['query'][_0xccef('0x1e')]);_0x45ef22[_0xccef('0x1c')]=qs['offset'](_0x45b393['query'][_0xccef('0x1c')]);}return _0x4bfdf0[_0xccef('0x50')](_0x45ef22);}})[_0xccef('0x26')](function(_0x1d414e){if(_0x1d414e){return _0x1d414e?{'count':_0x366631,'rows':_0x1d414e}:null;}})['then'](respondWithResult(_0x28a056,null))['catch'](handleError(_0x28a056,null));};exports[_0xccef('0x51')]=function(_0xb69aca,_0xbcbd6e,_0x451b54){var _0x4fa238={};var _0x11bf3b={};var _0xb9f1c7;var _0x100678;return db[_0xccef('0x2e')][_0xccef('0x52')]({'where':{'id':_0xb69aca[_0xccef('0x48')]['id']}})[_0xccef('0x26')](handleEntityNotFound(_0xbcbd6e,null))[_0xccef('0x26')](function(_0x639e35){if(_0x639e35){_0xb9f1c7=_0x639e35;_0x11bf3b[_0xccef('0x35')]=_['keys'](db[_0xccef('0x4d')][_0xccef('0x49')]);_0x11bf3b['query']=_[_0xccef('0x33')](_0xb69aca['query']);_0x11bf3b['filters']=_[_0xccef('0x34')](_0x11bf3b[_0xccef('0x35')],_0x11bf3b[_0xccef('0x32')]);_0x4fa238['attributes']=_['intersection'](_0x11bf3b[_0xccef('0x35')],qs[_0xccef('0x37')](_0xb69aca[_0xccef('0x32')][_0xccef('0x37')]));_0x4fa238[_0xccef('0x36')]=_0x4fa238['attributes'][_0xccef('0x38')]?_0x4fa238[_0xccef('0x36')]:_0x11bf3b[_0xccef('0x35')];_0x4fa238[_0xccef('0x3a')]=qs[_0xccef('0x3b')](_0xb69aca[_0xccef('0x32')]['sort']);_0x4fa238[_0xccef('0x3c')]=qs[_0xccef('0x3d')](_[_0xccef('0x3e')](_0xb69aca['query'],_0x11bf3b['filters']));if(_0xb69aca['query'][_0xccef('0x3f')]){_0x4fa238[_0xccef('0x3c')]=_[_0xccef('0x40')](_0x4fa238[_0xccef('0x3c')],{'$or':_['map'](_0x4fa238[_0xccef('0x36')],function(_0x24e731){var _0x1a02f6={};_0x1a02f6[_0x24e731]={'$like':'%'+_0xb69aca[_0xccef('0x32')][_0xccef('0x3f')]+'%'};return _0x1a02f6;})});}_0x4fa238=_[_0xccef('0x40')]({},_0x4fa238,_0xb69aca[_0xccef('0x41')]);return _0xb9f1c7[_0xccef('0x51')](_0x4fa238);}})['then'](function(_0x34b1e2){if(_0x34b1e2){_0x100678=_0x34b1e2[_0xccef('0x38')];if(!_0xb69aca['query'][_0xccef('0x4f')]('nolimit')){_0x4fa238[_0xccef('0x1e')]=qs[_0xccef('0x1e')](_0xb69aca[_0xccef('0x32')][_0xccef('0x1e')]);_0x4fa238['offset']=qs[_0xccef('0x1c')](_0xb69aca[_0xccef('0x32')][_0xccef('0x1c')]);}return _0xb9f1c7[_0xccef('0x51')](_0x4fa238);}})[_0xccef('0x26')](function(_0x2ff3ec){if(_0x2ff3ec){return _0x2ff3ec?{'count':_0x100678,'rows':_0x2ff3ec}:null;}})['then'](respondWithResult(_0xbcbd6e,null))['catch'](handleError(_0xbcbd6e,null));};