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 _0xcf95=['limit','set','Content-Range','json','apply','reject','update','then','destroy','stack','name','send','index','SugarcrmConfiguration','rawAttributes','fieldName','type','map','query','keys','intersection','attributes','model','fields','length','hasOwnProperty','order','sort','where','pick','filters','filter','merge','VIRTUAL','options','includeAll','include','rows','catch','params','create','body','find','getFields','SugarcrmField','nolimit','getSubjects','getDescriptions','findOne','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','to-csv','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','offset','undefined','count'];(function(_0x4726d0,_0x59835d){var _0x1aac2d=function(_0x52510a){while(--_0x52510a){_0x4726d0['push'](_0x4726d0['shift']());}};_0x1aac2d(++_0x59835d);}(_0xcf95,0x82));var _0x5cf9=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0xcf95[_0x3dd15e];return _0x231fd0;};'use strict';var emlformat=require(_0x5cf9('0x0'));var rimraf=require(_0x5cf9('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x5cf9('0x2'));var rp=require(_0x5cf9('0x3'));var moment=require(_0x5cf9('0x4'));var BPromise=require(_0x5cf9('0x5'));var Mustache=require(_0x5cf9('0x6'));var util=require(_0x5cf9('0x7'));var path=require(_0x5cf9('0x8'));var sox=require('sox');var csv=require(_0x5cf9('0x9'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x5cf9('0xa'));var _=require(_0x5cf9('0xb'));var squel=require(_0x5cf9('0xc'));var crypto=require(_0x5cf9('0xd'));var jsforce=require(_0x5cf9('0xe'));var deskjs=require(_0x5cf9('0xf'));var toCsv=require(_0x5cf9('0x9'));var querystring=require(_0x5cf9('0x10'));var Papa=require(_0x5cf9('0x11'));var Redis=require(_0x5cf9('0x12'));var authService=require(_0x5cf9('0x13'));var qs=require('../../components/parsers/qs');var as=require(_0x5cf9('0x14'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x5cf9('0x15'))(_0x5cf9('0x16'));var utils=require(_0x5cf9('0x17'));var config=require(_0x5cf9('0x18'));var licenseUtil=require('../../config/license/util');var db=require(_0x5cf9('0x19'))['db'];function respondWithStatusCode(_0x3f62ba,_0x35e3c2){_0x35e3c2=_0x35e3c2||0xcc;return function(_0x3550c1){if(_0x3550c1){return _0x3f62ba[_0x5cf9('0x1a')](_0x35e3c2);}return _0x3f62ba[_0x5cf9('0x1b')](_0x35e3c2)[_0x5cf9('0x1c')]();};}function respondWithResult(_0x4ec8d9,_0x488a11){_0x488a11=_0x488a11||0xc8;return function(_0x1c52cf){if(_0x1c52cf){return _0x4ec8d9['status'](_0x488a11)['json'](_0x1c52cf);}};}function respondWithFilteredResult(_0x222f51,_0x1dcff3){return function(_0x5b6e7e){if(_0x5b6e7e){var _0x319b96=typeof _0x1dcff3[_0x5cf9('0x1d')]==='undefined'&&typeof _0x1dcff3['limit']===_0x5cf9('0x1e');var _0x121159=_0x5b6e7e[_0x5cf9('0x1f')];var _0xf6ce07=_0x319b96?0x0:_0x1dcff3['offset'];var _0x2501a8=_0x319b96?_0x5b6e7e[_0x5cf9('0x1f')]:_0x1dcff3[_0x5cf9('0x1d')]+_0x1dcff3[_0x5cf9('0x20')];var _0x44e4fd;if(_0x2501a8>=_0x121159){_0x2501a8=_0x121159;_0x44e4fd=0xc8;}else{_0x44e4fd=0xce;}_0x222f51['status'](_0x44e4fd);return _0x222f51[_0x5cf9('0x21')](_0x5cf9('0x22'),_0xf6ce07+'-'+_0x2501a8+'/'+_0x121159)[_0x5cf9('0x23')](_0x5b6e7e);}return null;};}function patchUpdates(_0x4832d7){return function(_0x1e6a62){try{jsonpatch[_0x5cf9('0x24')](_0x1e6a62,_0x4832d7,!![]);}catch(_0x1efe28){return BPromise[_0x5cf9('0x25')](_0x1efe28);}return _0x1e6a62['save']();};}function saveUpdates(_0x496b01,_0x2578c8){return function(_0x43a4a3){if(_0x43a4a3){return _0x43a4a3[_0x5cf9('0x26')](_0x496b01)[_0x5cf9('0x27')](function(_0x4c739a){return _0x4c739a;});}return null;};}function removeEntity(_0x52ca43,_0x1744a4){return function(_0x25bb49){if(_0x25bb49){return _0x25bb49[_0x5cf9('0x28')]()['then'](function(){_0x52ca43[_0x5cf9('0x1b')](0xcc)[_0x5cf9('0x1c')]();});}};}function handleEntityNotFound(_0x1960e6,_0x13f9fb){return function(_0x371701){if(!_0x371701){_0x1960e6[_0x5cf9('0x1a')](0x194);}return _0x371701;};}function handleError(_0x570988,_0x21dd9b){_0x21dd9b=_0x21dd9b||0x1f4;return function(_0x2a8bab){logger['error'](_0x2a8bab[_0x5cf9('0x29')]);if(_0x2a8bab[_0x5cf9('0x2a')]){delete _0x2a8bab['name'];}_0x570988['status'](_0x21dd9b)[_0x5cf9('0x2b')](_0x2a8bab);};}exports[_0x5cf9('0x2c')]=function(_0x5a8074,_0x457aa5){var _0x1a66b9={},_0x4f3e0c={},_0x17c8aa={'count':0x0,'rows':[]};var _0x3ae7dc=_['map'](db[_0x5cf9('0x2d')][_0x5cf9('0x2e')],function(_0x4adc9e){return{'name':_0x4adc9e[_0x5cf9('0x2f')],'type':_0x4adc9e[_0x5cf9('0x30')]['key']};});_0x4f3e0c['model']=_[_0x5cf9('0x31')](_0x3ae7dc,_0x5cf9('0x2a'));_0x4f3e0c[_0x5cf9('0x32')]=_[_0x5cf9('0x33')](_0x5a8074[_0x5cf9('0x32')]);_0x4f3e0c['filters']=_[_0x5cf9('0x34')](_0x4f3e0c['model'],_0x4f3e0c[_0x5cf9('0x32')]);_0x1a66b9[_0x5cf9('0x35')]=_[_0x5cf9('0x34')](_0x4f3e0c[_0x5cf9('0x36')],qs[_0x5cf9('0x37')](_0x5a8074['query'][_0x5cf9('0x37')]));_0x1a66b9[_0x5cf9('0x35')]=_0x1a66b9[_0x5cf9('0x35')][_0x5cf9('0x38')]?_0x1a66b9[_0x5cf9('0x35')]:_0x4f3e0c[_0x5cf9('0x36')];if(!_0x5a8074['query'][_0x5cf9('0x39')]('nolimit')){_0x1a66b9[_0x5cf9('0x20')]=qs[_0x5cf9('0x20')](_0x5a8074[_0x5cf9('0x32')][_0x5cf9('0x20')]);_0x1a66b9['offset']=qs['offset'](_0x5a8074[_0x5cf9('0x32')][_0x5cf9('0x1d')]);}_0x1a66b9[_0x5cf9('0x3a')]=qs[_0x5cf9('0x3b')](_0x5a8074['query']['sort']);_0x1a66b9[_0x5cf9('0x3c')]=qs['filters'](_[_0x5cf9('0x3d')](_0x5a8074[_0x5cf9('0x32')],_0x4f3e0c[_0x5cf9('0x3e')]),_0x3ae7dc);if(_0x5a8074['query'][_0x5cf9('0x3f')]){_0x1a66b9[_0x5cf9('0x3c')]=_[_0x5cf9('0x40')](_0x1a66b9[_0x5cf9('0x3c')],{'$or':_['map'](_0x3ae7dc,function(_0x42687d){if(_0x42687d[_0x5cf9('0x30')]!==_0x5cf9('0x41')){var _0x25e137={};_0x25e137[_0x42687d[_0x5cf9('0x2a')]]={'$like':'%'+_0x5a8074[_0x5cf9('0x32')][_0x5cf9('0x3f')]+'%'};return _0x25e137;}})});}_0x1a66b9=_[_0x5cf9('0x40')]({},_0x1a66b9,_0x5a8074[_0x5cf9('0x42')]);var _0x4f68ce={'where':_0x1a66b9[_0x5cf9('0x3c')]};return db['SugarcrmConfiguration'][_0x5cf9('0x1f')](_0x4f68ce)['then'](function(_0x5b2713){_0x17c8aa[_0x5cf9('0x1f')]=_0x5b2713;if(_0x5a8074['query'][_0x5cf9('0x43')]){_0x1a66b9[_0x5cf9('0x44')]=[{'all':!![]}];}return db[_0x5cf9('0x2d')]['findAll'](_0x1a66b9);})[_0x5cf9('0x27')](function(_0xb27e8b){_0x17c8aa[_0x5cf9('0x45')]=_0xb27e8b;return _0x17c8aa;})[_0x5cf9('0x27')](respondWithFilteredResult(_0x457aa5,_0x1a66b9))[_0x5cf9('0x46')](handleError(_0x457aa5,null));};exports['show']=function(_0x1a45e8,_0x175bb2){var _0x5a929f={'raw':![],'where':{'id':_0x1a45e8[_0x5cf9('0x47')]['id']}},_0x5525bb={};_0x5525bb[_0x5cf9('0x36')]=_['keys'](db[_0x5cf9('0x2d')][_0x5cf9('0x2e')]);_0x5525bb[_0x5cf9('0x32')]=_['keys'](_0x1a45e8['query']);_0x5525bb[_0x5cf9('0x3e')]=_[_0x5cf9('0x34')](_0x5525bb[_0x5cf9('0x36')],_0x5525bb[_0x5cf9('0x32')]);_0x5a929f[_0x5cf9('0x35')]=_['intersection'](_0x5525bb[_0x5cf9('0x36')],qs[_0x5cf9('0x37')](_0x1a45e8['query'][_0x5cf9('0x37')]));_0x5a929f[_0x5cf9('0x35')]=_0x5a929f['attributes'][_0x5cf9('0x38')]?_0x5a929f[_0x5cf9('0x35')]:_0x5525bb[_0x5cf9('0x36')];if(_0x1a45e8[_0x5cf9('0x32')][_0x5cf9('0x43')]){_0x5a929f['include']=[{'all':!![]}];}_0x5a929f=_[_0x5cf9('0x40')]({},_0x5a929f,_0x1a45e8[_0x5cf9('0x42')]);return db[_0x5cf9('0x2d')]['find'](_0x5a929f)[_0x5cf9('0x27')](handleEntityNotFound(_0x175bb2,null))[_0x5cf9('0x27')](respondWithResult(_0x175bb2,null))[_0x5cf9('0x46')](handleError(_0x175bb2,null));};exports[_0x5cf9('0x48')]=function(_0x36f3f6,_0x929acb){return db[_0x5cf9('0x2d')][_0x5cf9('0x48')](_0x36f3f6[_0x5cf9('0x49')],{})[_0x5cf9('0x27')](respondWithResult(_0x929acb,0xc9))[_0x5cf9('0x46')](handleError(_0x929acb,null));};exports[_0x5cf9('0x26')]=function(_0x4424b1,_0x24d226){if(_0x4424b1[_0x5cf9('0x49')]['id']){delete _0x4424b1[_0x5cf9('0x49')]['id'];}return db['SugarcrmConfiguration'][_0x5cf9('0x4a')]({'where':{'id':_0x4424b1[_0x5cf9('0x47')]['id']}})['then'](handleEntityNotFound(_0x24d226,null))[_0x5cf9('0x27')](saveUpdates(_0x4424b1[_0x5cf9('0x49')],null))[_0x5cf9('0x27')](respondWithResult(_0x24d226,null))['catch'](handleError(_0x24d226,null));};exports[_0x5cf9('0x28')]=function(_0x3c85fd,_0x15a0a4){return db[_0x5cf9('0x2d')][_0x5cf9('0x4a')]({'where':{'id':_0x3c85fd['params']['id']}})[_0x5cf9('0x27')](handleEntityNotFound(_0x15a0a4,null))[_0x5cf9('0x27')](removeEntity(_0x15a0a4,null))[_0x5cf9('0x46')](handleError(_0x15a0a4,null));};exports[_0x5cf9('0x4b')]=function(_0x54cbd0,_0x1ce6ff,_0x39b22c){var _0x3613dc={};var _0x52325c={};var _0x55e39d;var _0x357f6f;return db[_0x5cf9('0x2d')]['findOne']({'where':{'id':_0x54cbd0[_0x5cf9('0x47')]['id']}})[_0x5cf9('0x27')](handleEntityNotFound(_0x1ce6ff,null))[_0x5cf9('0x27')](function(_0x545a6d){if(_0x545a6d){_0x55e39d=_0x545a6d;_0x52325c[_0x5cf9('0x36')]=_[_0x5cf9('0x33')](db[_0x5cf9('0x4c')][_0x5cf9('0x2e')]);_0x52325c['query']=_['keys'](_0x54cbd0[_0x5cf9('0x32')]);_0x52325c[_0x5cf9('0x3e')]=_[_0x5cf9('0x34')](_0x52325c[_0x5cf9('0x36')],_0x52325c[_0x5cf9('0x32')]);_0x3613dc['attributes']=_[_0x5cf9('0x34')](_0x52325c[_0x5cf9('0x36')],qs[_0x5cf9('0x37')](_0x54cbd0[_0x5cf9('0x32')]['fields']));_0x3613dc[_0x5cf9('0x35')]=_0x3613dc[_0x5cf9('0x35')][_0x5cf9('0x38')]?_0x3613dc[_0x5cf9('0x35')]:_0x52325c['model'];_0x3613dc[_0x5cf9('0x3a')]=qs['sort'](_0x54cbd0[_0x5cf9('0x32')]['sort']);_0x3613dc[_0x5cf9('0x3c')]=qs[_0x5cf9('0x3e')](_[_0x5cf9('0x3d')](_0x54cbd0['query'],_0x52325c[_0x5cf9('0x3e')]));if(_0x54cbd0[_0x5cf9('0x32')][_0x5cf9('0x3f')]){_0x3613dc[_0x5cf9('0x3c')]=_[_0x5cf9('0x40')](_0x3613dc['where'],{'$or':_['map'](_0x3613dc[_0x5cf9('0x35')],function(_0x32c444){var _0x52199a={};_0x52199a[_0x32c444]={'$like':'%'+_0x54cbd0['query'][_0x5cf9('0x3f')]+'%'};return _0x52199a;})});}_0x3613dc=_[_0x5cf9('0x40')]({},_0x3613dc,_0x54cbd0[_0x5cf9('0x42')]);return _0x55e39d[_0x5cf9('0x4b')](_0x3613dc);}})[_0x5cf9('0x27')](function(_0x206d6e){if(_0x206d6e){_0x357f6f=_0x206d6e[_0x5cf9('0x38')];if(!_0x54cbd0[_0x5cf9('0x32')][_0x5cf9('0x39')](_0x5cf9('0x4d'))){_0x3613dc[_0x5cf9('0x20')]=qs[_0x5cf9('0x20')](_0x54cbd0[_0x5cf9('0x32')][_0x5cf9('0x20')]);_0x3613dc['offset']=qs[_0x5cf9('0x1d')](_0x54cbd0['query']['offset']);}return _0x55e39d[_0x5cf9('0x4b')](_0x3613dc);}})[_0x5cf9('0x27')](function(_0x54f1b1){if(_0x54f1b1){return _0x54f1b1?{'count':_0x357f6f,'rows':_0x54f1b1}:null;}})[_0x5cf9('0x27')](respondWithResult(_0x1ce6ff,null))['catch'](handleError(_0x1ce6ff,null));};exports[_0x5cf9('0x4e')]=function(_0x5344da,_0x5e315f,_0x45964f){var _0x29f3d1={};var _0x7bf8b7={};var _0x228757;var _0x334444;return db[_0x5cf9('0x2d')]['findOne']({'where':{'id':_0x5344da[_0x5cf9('0x47')]['id']}})['then'](handleEntityNotFound(_0x5e315f,null))[_0x5cf9('0x27')](function(_0x3e400c){if(_0x3e400c){_0x228757=_0x3e400c;_0x7bf8b7['model']=_['keys'](db[_0x5cf9('0x4c')][_0x5cf9('0x2e')]);_0x7bf8b7[_0x5cf9('0x32')]=_[_0x5cf9('0x33')](_0x5344da['query']);_0x7bf8b7[_0x5cf9('0x3e')]=_[_0x5cf9('0x34')](_0x7bf8b7['model'],_0x7bf8b7[_0x5cf9('0x32')]);_0x29f3d1[_0x5cf9('0x35')]=_[_0x5cf9('0x34')](_0x7bf8b7['model'],qs[_0x5cf9('0x37')](_0x5344da[_0x5cf9('0x32')][_0x5cf9('0x37')]));_0x29f3d1[_0x5cf9('0x35')]=_0x29f3d1[_0x5cf9('0x35')][_0x5cf9('0x38')]?_0x29f3d1[_0x5cf9('0x35')]:_0x7bf8b7['model'];_0x29f3d1[_0x5cf9('0x3a')]=qs[_0x5cf9('0x3b')](_0x5344da[_0x5cf9('0x32')][_0x5cf9('0x3b')]);_0x29f3d1[_0x5cf9('0x3c')]=qs[_0x5cf9('0x3e')](_[_0x5cf9('0x3d')](_0x5344da[_0x5cf9('0x32')],_0x7bf8b7['filters']));if(_0x5344da['query'][_0x5cf9('0x3f')]){_0x29f3d1[_0x5cf9('0x3c')]=_['merge'](_0x29f3d1[_0x5cf9('0x3c')],{'$or':_[_0x5cf9('0x31')](_0x29f3d1[_0x5cf9('0x35')],function(_0x292096){var _0x1c0ab7={};_0x1c0ab7[_0x292096]={'$like':'%'+_0x5344da[_0x5cf9('0x32')][_0x5cf9('0x3f')]+'%'};return _0x1c0ab7;})});}_0x29f3d1=_[_0x5cf9('0x40')]({},_0x29f3d1,_0x5344da['options']);return _0x228757[_0x5cf9('0x4e')](_0x29f3d1);}})[_0x5cf9('0x27')](function(_0x303476){if(_0x303476){_0x334444=_0x303476[_0x5cf9('0x38')];if(!_0x5344da['query'][_0x5cf9('0x39')]('nolimit')){_0x29f3d1[_0x5cf9('0x20')]=qs['limit'](_0x5344da['query'][_0x5cf9('0x20')]);_0x29f3d1[_0x5cf9('0x1d')]=qs[_0x5cf9('0x1d')](_0x5344da['query'][_0x5cf9('0x1d')]);}return _0x228757[_0x5cf9('0x4e')](_0x29f3d1);}})[_0x5cf9('0x27')](function(_0x139164){if(_0x139164){return _0x139164?{'count':_0x334444,'rows':_0x139164}:null;}})['then'](respondWithResult(_0x5e315f,null))[_0x5cf9('0x46')](handleError(_0x5e315f,null));};exports[_0x5cf9('0x4f')]=function(_0xda5c97,_0x1cb094,_0x17c346){var _0x59d312={};var _0x377686={};var _0x14df6a;var _0x4c38e1;return db[_0x5cf9('0x2d')][_0x5cf9('0x50')]({'where':{'id':_0xda5c97[_0x5cf9('0x47')]['id']}})[_0x5cf9('0x27')](handleEntityNotFound(_0x1cb094,null))['then'](function(_0x410fff){if(_0x410fff){_0x14df6a=_0x410fff;_0x377686[_0x5cf9('0x36')]=_[_0x5cf9('0x33')](db[_0x5cf9('0x4c')][_0x5cf9('0x2e')]);_0x377686['query']=_['keys'](_0xda5c97[_0x5cf9('0x32')]);_0x377686[_0x5cf9('0x3e')]=_[_0x5cf9('0x34')](_0x377686[_0x5cf9('0x36')],_0x377686['query']);_0x59d312[_0x5cf9('0x35')]=_['intersection'](_0x377686[_0x5cf9('0x36')],qs['fields'](_0xda5c97[_0x5cf9('0x32')][_0x5cf9('0x37')]));_0x59d312['attributes']=_0x59d312[_0x5cf9('0x35')][_0x5cf9('0x38')]?_0x59d312[_0x5cf9('0x35')]:_0x377686[_0x5cf9('0x36')];_0x59d312[_0x5cf9('0x3a')]=qs[_0x5cf9('0x3b')](_0xda5c97[_0x5cf9('0x32')][_0x5cf9('0x3b')]);_0x59d312['where']=qs[_0x5cf9('0x3e')](_[_0x5cf9('0x3d')](_0xda5c97[_0x5cf9('0x32')],_0x377686[_0x5cf9('0x3e')]));if(_0xda5c97[_0x5cf9('0x32')][_0x5cf9('0x3f')]){_0x59d312[_0x5cf9('0x3c')]=_['merge'](_0x59d312[_0x5cf9('0x3c')],{'$or':_[_0x5cf9('0x31')](_0x59d312[_0x5cf9('0x35')],function(_0x465746){var _0x8b9640={};_0x8b9640[_0x465746]={'$like':'%'+_0xda5c97[_0x5cf9('0x32')][_0x5cf9('0x3f')]+'%'};return _0x8b9640;})});}_0x59d312=_['merge']({},_0x59d312,_0xda5c97[_0x5cf9('0x42')]);return _0x14df6a[_0x5cf9('0x4f')](_0x59d312);}})[_0x5cf9('0x27')](function(_0x2de54d){if(_0x2de54d){_0x4c38e1=_0x2de54d[_0x5cf9('0x38')];if(!_0xda5c97[_0x5cf9('0x32')][_0x5cf9('0x39')](_0x5cf9('0x4d'))){_0x59d312['limit']=qs[_0x5cf9('0x20')](_0xda5c97[_0x5cf9('0x32')][_0x5cf9('0x20')]);_0x59d312[_0x5cf9('0x1d')]=qs[_0x5cf9('0x1d')](_0xda5c97['query'][_0x5cf9('0x1d')]);}return _0x14df6a[_0x5cf9('0x4f')](_0x59d312);}})['then'](function(_0x305403){if(_0x305403){return _0x305403?{'count':_0x4c38e1,'rows':_0x305403}:null;}})[_0x5cf9('0x27')](respondWithResult(_0x1cb094,null))[_0x5cf9('0x46')](handleError(_0x1cb094,null));};