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 _0x16ac=['options','includeAll','include','findAll','rows','catch','find','create','params','destroy','SugarcrmField','getFields','getSubjects','findOne','getDescriptions','order','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','to-csv','fs-extra','lodash','squel','crypto','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','then','sendStatus','error','stack','name','send','index','SugarcrmConfiguration','rawAttributes','model','map','keys','filters','intersection','query','fields','length','attributes','hasOwnProperty','nolimit','sort','where','pick','filter','merge','VIRTUAL'];(function(_0x56562d,_0x578183){var _0xdafef9=function(_0x27453e){while(--_0x27453e){_0x56562d['push'](_0x56562d['shift']());}};_0xdafef9(++_0x578183);}(_0x16ac,0x1f0));var _0xc16a=function(_0x2a1f5c,_0x49b13f){_0x2a1f5c=_0x2a1f5c-0x0;var _0x43ce3d=_0x16ac[_0x2a1f5c];return _0x43ce3d;};'use strict';var emlformat=require(_0xc16a('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xc16a('0x1'));var jsonpatch=require(_0xc16a('0x2'));var rp=require(_0xc16a('0x3'));var moment=require(_0xc16a('0x4'));var BPromise=require(_0xc16a('0x5'));var Mustache=require(_0xc16a('0x6'));var util=require('util');var path=require(_0xc16a('0x7'));var sox=require('sox');var csv=require(_0xc16a('0x8'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xc16a('0x9'));var _=require(_0xc16a('0xa'));var squel=require(_0xc16a('0xb'));var crypto=require(_0xc16a('0xc'));var jsforce=require('jsforce');var deskjs=require(_0xc16a('0xd'));var toCsv=require('to-csv');var querystring=require(_0xc16a('0xe'));var Papa=require(_0xc16a('0xf'));var Redis=require(_0xc16a('0x10'));var authService=require(_0xc16a('0x11'));var qs=require(_0xc16a('0x12'));var as=require(_0xc16a('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xc16a('0x14'))(_0xc16a('0x15'));var utils=require(_0xc16a('0x16'));var config=require(_0xc16a('0x17'));var licenseUtil=require('../../config/license/util');var db=require(_0xc16a('0x18'))['db'];function respondWithStatusCode(_0x5a716f,_0x2c9687){_0x2c9687=_0x2c9687||0xcc;return function(_0x424fda){if(_0x424fda){return _0x5a716f['sendStatus'](_0x2c9687);}return _0x5a716f[_0xc16a('0x19')](_0x2c9687)[_0xc16a('0x1a')]();};}function respondWithResult(_0x22a97b,_0x31fb0e){_0x31fb0e=_0x31fb0e||0xc8;return function(_0xd2119a){if(_0xd2119a){return _0x22a97b[_0xc16a('0x19')](_0x31fb0e)[_0xc16a('0x1b')](_0xd2119a);}};}function respondWithFilteredResult(_0xb1db0f,_0x47f254){return function(_0x439a01){if(_0x439a01){var _0x36324c=typeof _0x47f254[_0xc16a('0x1c')]===_0xc16a('0x1d')&&typeof _0x47f254[_0xc16a('0x1e')]==='undefined';var _0xe7aa41=_0x439a01['count'];var _0x3ee9e3=_0x36324c?0x0:_0x47f254['offset'];var _0x35d6a6=_0x36324c?_0x439a01[_0xc16a('0x1f')]:_0x47f254[_0xc16a('0x1c')]+_0x47f254['limit'];var _0x145f73;if(_0x35d6a6>=_0xe7aa41){_0x35d6a6=_0xe7aa41;_0x145f73=0xc8;}else{_0x145f73=0xce;}_0xb1db0f[_0xc16a('0x19')](_0x145f73);return _0xb1db0f[_0xc16a('0x20')](_0xc16a('0x21'),_0x3ee9e3+'-'+_0x35d6a6+'/'+_0xe7aa41)[_0xc16a('0x1b')](_0x439a01);}return null;};}function patchUpdates(_0x352f10){return function(_0x541cfd){try{jsonpatch[_0xc16a('0x22')](_0x541cfd,_0x352f10,!![]);}catch(_0xa03987){return BPromise[_0xc16a('0x23')](_0xa03987);}return _0x541cfd[_0xc16a('0x24')]();};}function saveUpdates(_0x283fbe,_0x14fe0c){return function(_0x44d676){if(_0x44d676){return _0x44d676[_0xc16a('0x25')](_0x283fbe)[_0xc16a('0x26')](function(_0xfc0ef8){return _0xfc0ef8;});}return null;};}function removeEntity(_0x3bbb61,_0x3fef0c){return function(_0x3e6c57){if(_0x3e6c57){return _0x3e6c57['destroy']()[_0xc16a('0x26')](function(){_0x3bbb61[_0xc16a('0x19')](0xcc)[_0xc16a('0x1a')]();});}};}function handleEntityNotFound(_0x322868,_0xef1236){return function(_0x5a8fa9){if(!_0x5a8fa9){_0x322868[_0xc16a('0x27')](0x194);}return _0x5a8fa9;};}function handleError(_0x352dcd,_0x2e0100){_0x2e0100=_0x2e0100||0x1f4;return function(_0x5a814b){logger[_0xc16a('0x28')](_0x5a814b[_0xc16a('0x29')]);if(_0x5a814b[_0xc16a('0x2a')]){delete _0x5a814b['name'];}_0x352dcd[_0xc16a('0x19')](_0x2e0100)[_0xc16a('0x2b')](_0x5a814b);};}exports[_0xc16a('0x2c')]=function(_0xabe6e1,_0x466fa2){var _0x4eb4ab={},_0x19a428={},_0x25b3ac={'count':0x0,'rows':[]};var _0x4a5475=_['map'](db[_0xc16a('0x2d')][_0xc16a('0x2e')],function(_0x2fa405){return{'name':_0x2fa405['fieldName'],'type':_0x2fa405['type']['key']};});_0x19a428[_0xc16a('0x2f')]=_[_0xc16a('0x30')](_0x4a5475,'name');_0x19a428['query']=_[_0xc16a('0x31')](_0xabe6e1['query']);_0x19a428[_0xc16a('0x32')]=_[_0xc16a('0x33')](_0x19a428[_0xc16a('0x2f')],_0x19a428[_0xc16a('0x34')]);_0x4eb4ab['attributes']=_['intersection'](_0x19a428['model'],qs['fields'](_0xabe6e1[_0xc16a('0x34')][_0xc16a('0x35')]));_0x4eb4ab['attributes']=_0x4eb4ab['attributes'][_0xc16a('0x36')]?_0x4eb4ab[_0xc16a('0x37')]:_0x19a428['model'];if(!_0xabe6e1[_0xc16a('0x34')][_0xc16a('0x38')](_0xc16a('0x39'))){_0x4eb4ab[_0xc16a('0x1e')]=qs[_0xc16a('0x1e')](_0xabe6e1[_0xc16a('0x34')][_0xc16a('0x1e')]);_0x4eb4ab[_0xc16a('0x1c')]=qs[_0xc16a('0x1c')](_0xabe6e1[_0xc16a('0x34')][_0xc16a('0x1c')]);}_0x4eb4ab['order']=qs[_0xc16a('0x3a')](_0xabe6e1[_0xc16a('0x34')][_0xc16a('0x3a')]);_0x4eb4ab[_0xc16a('0x3b')]=qs[_0xc16a('0x32')](_[_0xc16a('0x3c')](_0xabe6e1[_0xc16a('0x34')],_0x19a428['filters']),_0x4a5475);if(_0xabe6e1[_0xc16a('0x34')][_0xc16a('0x3d')]){_0x4eb4ab[_0xc16a('0x3b')]=_[_0xc16a('0x3e')](_0x4eb4ab['where'],{'$or':_['map'](_0x4a5475,function(_0x4b0c45){if(_0x4b0c45['type']!==_0xc16a('0x3f')){var _0x3b2ffc={};_0x3b2ffc[_0x4b0c45[_0xc16a('0x2a')]]={'$like':'%'+_0xabe6e1[_0xc16a('0x34')][_0xc16a('0x3d')]+'%'};return _0x3b2ffc;}})});}_0x4eb4ab=_['merge']({},_0x4eb4ab,_0xabe6e1[_0xc16a('0x40')]);var _0x2a264f={'where':_0x4eb4ab[_0xc16a('0x3b')]};return db[_0xc16a('0x2d')][_0xc16a('0x1f')](_0x2a264f)[_0xc16a('0x26')](function(_0x429b3e){_0x25b3ac[_0xc16a('0x1f')]=_0x429b3e;if(_0xabe6e1[_0xc16a('0x34')][_0xc16a('0x41')]){_0x4eb4ab[_0xc16a('0x42')]=[{'all':!![]}];}return db[_0xc16a('0x2d')][_0xc16a('0x43')](_0x4eb4ab);})[_0xc16a('0x26')](function(_0x2da184){_0x25b3ac[_0xc16a('0x44')]=_0x2da184;return _0x25b3ac;})[_0xc16a('0x26')](respondWithFilteredResult(_0x466fa2,_0x4eb4ab))[_0xc16a('0x45')](handleError(_0x466fa2,null));};exports['show']=function(_0x22444e,_0x5ac231){var _0x42b983={'raw':![],'where':{'id':_0x22444e['params']['id']}},_0x50c360={};_0x50c360['model']=_['keys'](db[_0xc16a('0x2d')][_0xc16a('0x2e')]);_0x50c360[_0xc16a('0x34')]=_[_0xc16a('0x31')](_0x22444e[_0xc16a('0x34')]);_0x50c360[_0xc16a('0x32')]=_['intersection'](_0x50c360[_0xc16a('0x2f')],_0x50c360[_0xc16a('0x34')]);_0x42b983['attributes']=_['intersection'](_0x50c360[_0xc16a('0x2f')],qs['fields'](_0x22444e[_0xc16a('0x34')]['fields']));_0x42b983[_0xc16a('0x37')]=_0x42b983[_0xc16a('0x37')][_0xc16a('0x36')]?_0x42b983['attributes']:_0x50c360['model'];if(_0x22444e[_0xc16a('0x34')][_0xc16a('0x41')]){_0x42b983['include']=[{'all':!![]}];}_0x42b983=_[_0xc16a('0x3e')]({},_0x42b983,_0x22444e[_0xc16a('0x40')]);return db[_0xc16a('0x2d')][_0xc16a('0x46')](_0x42b983)[_0xc16a('0x26')](handleEntityNotFound(_0x5ac231,null))[_0xc16a('0x26')](respondWithResult(_0x5ac231,null))[_0xc16a('0x45')](handleError(_0x5ac231,null));};exports[_0xc16a('0x47')]=function(_0x14fa01,_0x634899){return db[_0xc16a('0x2d')]['create'](_0x14fa01['body'],{})[_0xc16a('0x26')](respondWithResult(_0x634899,0xc9))[_0xc16a('0x45')](handleError(_0x634899,null));};exports[_0xc16a('0x25')]=function(_0xe639fe,_0x3a2fe4){if(_0xe639fe['body']['id']){delete _0xe639fe['body']['id'];}return db[_0xc16a('0x2d')][_0xc16a('0x46')]({'where':{'id':_0xe639fe[_0xc16a('0x48')]['id']}})['then'](handleEntityNotFound(_0x3a2fe4,null))['then'](saveUpdates(_0xe639fe['body'],null))[_0xc16a('0x26')](respondWithResult(_0x3a2fe4,null))[_0xc16a('0x45')](handleError(_0x3a2fe4,null));};exports[_0xc16a('0x49')]=function(_0x1fb21d,_0x414f07){return db[_0xc16a('0x2d')]['find']({'where':{'id':_0x1fb21d[_0xc16a('0x48')]['id']}})['then'](handleEntityNotFound(_0x414f07,null))['then'](removeEntity(_0x414f07,null))[_0xc16a('0x45')](handleError(_0x414f07,null));};exports['getFields']=function(_0x4b3d1c,_0x142ee7,_0x51d7c2){var _0x3cf108={};var _0x543ccd={};var _0x1cc6be;var _0x6f0dc4;return db[_0xc16a('0x2d')]['findOne']({'where':{'id':_0x4b3d1c['params']['id']}})[_0xc16a('0x26')](handleEntityNotFound(_0x142ee7,null))[_0xc16a('0x26')](function(_0x2d2201){if(_0x2d2201){_0x1cc6be=_0x2d2201;_0x543ccd[_0xc16a('0x2f')]=_[_0xc16a('0x31')](db[_0xc16a('0x4a')][_0xc16a('0x2e')]);_0x543ccd[_0xc16a('0x34')]=_[_0xc16a('0x31')](_0x4b3d1c['query']);_0x543ccd[_0xc16a('0x32')]=_[_0xc16a('0x33')](_0x543ccd[_0xc16a('0x2f')],_0x543ccd['query']);_0x3cf108[_0xc16a('0x37')]=_[_0xc16a('0x33')](_0x543ccd['model'],qs[_0xc16a('0x35')](_0x4b3d1c[_0xc16a('0x34')][_0xc16a('0x35')]));_0x3cf108[_0xc16a('0x37')]=_0x3cf108['attributes'][_0xc16a('0x36')]?_0x3cf108[_0xc16a('0x37')]:_0x543ccd[_0xc16a('0x2f')];_0x3cf108['order']=qs[_0xc16a('0x3a')](_0x4b3d1c[_0xc16a('0x34')][_0xc16a('0x3a')]);_0x3cf108[_0xc16a('0x3b')]=qs[_0xc16a('0x32')](_[_0xc16a('0x3c')](_0x4b3d1c[_0xc16a('0x34')],_0x543ccd[_0xc16a('0x32')]));if(_0x4b3d1c[_0xc16a('0x34')][_0xc16a('0x3d')]){_0x3cf108[_0xc16a('0x3b')]=_[_0xc16a('0x3e')](_0x3cf108[_0xc16a('0x3b')],{'$or':_[_0xc16a('0x30')](_0x3cf108['attributes'],function(_0x14a2fc){var _0x23ed5d={};_0x23ed5d[_0x14a2fc]={'$like':'%'+_0x4b3d1c[_0xc16a('0x34')][_0xc16a('0x3d')]+'%'};return _0x23ed5d;})});}_0x3cf108=_[_0xc16a('0x3e')]({},_0x3cf108,_0x4b3d1c[_0xc16a('0x40')]);return _0x1cc6be[_0xc16a('0x4b')](_0x3cf108);}})[_0xc16a('0x26')](function(_0x376fbe){if(_0x376fbe){_0x6f0dc4=_0x376fbe[_0xc16a('0x36')];if(!_0x4b3d1c['query']['hasOwnProperty']('nolimit')){_0x3cf108['limit']=qs['limit'](_0x4b3d1c[_0xc16a('0x34')][_0xc16a('0x1e')]);_0x3cf108[_0xc16a('0x1c')]=qs[_0xc16a('0x1c')](_0x4b3d1c[_0xc16a('0x34')][_0xc16a('0x1c')]);}return _0x1cc6be[_0xc16a('0x4b')](_0x3cf108);}})[_0xc16a('0x26')](function(_0x23a286){if(_0x23a286){return _0x23a286?{'count':_0x6f0dc4,'rows':_0x23a286}:null;}})[_0xc16a('0x26')](respondWithResult(_0x142ee7,null))[_0xc16a('0x45')](handleError(_0x142ee7,null));};exports[_0xc16a('0x4c')]=function(_0x514c86,_0x31fc74,_0x343825){var _0x149e27={};var _0x10d2bf={};var _0x1e450f;var _0x5e56b5;return db[_0xc16a('0x2d')][_0xc16a('0x4d')]({'where':{'id':_0x514c86[_0xc16a('0x48')]['id']}})[_0xc16a('0x26')](handleEntityNotFound(_0x31fc74,null))[_0xc16a('0x26')](function(_0x5e7ff1){if(_0x5e7ff1){_0x1e450f=_0x5e7ff1;_0x10d2bf[_0xc16a('0x2f')]=_[_0xc16a('0x31')](db[_0xc16a('0x4a')]['rawAttributes']);_0x10d2bf[_0xc16a('0x34')]=_[_0xc16a('0x31')](_0x514c86[_0xc16a('0x34')]);_0x10d2bf['filters']=_[_0xc16a('0x33')](_0x10d2bf['model'],_0x10d2bf['query']);_0x149e27[_0xc16a('0x37')]=_[_0xc16a('0x33')](_0x10d2bf[_0xc16a('0x2f')],qs[_0xc16a('0x35')](_0x514c86[_0xc16a('0x34')][_0xc16a('0x35')]));_0x149e27[_0xc16a('0x37')]=_0x149e27[_0xc16a('0x37')]['length']?_0x149e27[_0xc16a('0x37')]:_0x10d2bf[_0xc16a('0x2f')];_0x149e27['order']=qs[_0xc16a('0x3a')](_0x514c86['query'][_0xc16a('0x3a')]);_0x149e27[_0xc16a('0x3b')]=qs[_0xc16a('0x32')](_[_0xc16a('0x3c')](_0x514c86[_0xc16a('0x34')],_0x10d2bf['filters']));if(_0x514c86[_0xc16a('0x34')][_0xc16a('0x3d')]){_0x149e27['where']=_['merge'](_0x149e27['where'],{'$or':_[_0xc16a('0x30')](_0x149e27[_0xc16a('0x37')],function(_0x2ae2e1){var _0x1c711b={};_0x1c711b[_0x2ae2e1]={'$like':'%'+_0x514c86[_0xc16a('0x34')][_0xc16a('0x3d')]+'%'};return _0x1c711b;})});}_0x149e27=_['merge']({},_0x149e27,_0x514c86[_0xc16a('0x40')]);return _0x1e450f['getSubjects'](_0x149e27);}})[_0xc16a('0x26')](function(_0x5d53f6){if(_0x5d53f6){_0x5e56b5=_0x5d53f6[_0xc16a('0x36')];if(!_0x514c86[_0xc16a('0x34')][_0xc16a('0x38')](_0xc16a('0x39'))){_0x149e27[_0xc16a('0x1e')]=qs[_0xc16a('0x1e')](_0x514c86[_0xc16a('0x34')]['limit']);_0x149e27[_0xc16a('0x1c')]=qs[_0xc16a('0x1c')](_0x514c86['query'][_0xc16a('0x1c')]);}return _0x1e450f[_0xc16a('0x4c')](_0x149e27);}})[_0xc16a('0x26')](function(_0x5a8d86){if(_0x5a8d86){return _0x5a8d86?{'count':_0x5e56b5,'rows':_0x5a8d86}:null;}})['then'](respondWithResult(_0x31fc74,null))['catch'](handleError(_0x31fc74,null));};exports[_0xc16a('0x4e')]=function(_0xf2854f,_0x27eda0,_0x5e5b11){var _0x4e0e79={};var _0x3b4f42={};var _0x2c8da3;var _0x1e0341;return db[_0xc16a('0x2d')][_0xc16a('0x4d')]({'where':{'id':_0xf2854f[_0xc16a('0x48')]['id']}})['then'](handleEntityNotFound(_0x27eda0,null))['then'](function(_0xb8daeb){if(_0xb8daeb){_0x2c8da3=_0xb8daeb;_0x3b4f42['model']=_['keys'](db[_0xc16a('0x4a')][_0xc16a('0x2e')]);_0x3b4f42[_0xc16a('0x34')]=_['keys'](_0xf2854f[_0xc16a('0x34')]);_0x3b4f42[_0xc16a('0x32')]=_[_0xc16a('0x33')](_0x3b4f42[_0xc16a('0x2f')],_0x3b4f42[_0xc16a('0x34')]);_0x4e0e79[_0xc16a('0x37')]=_[_0xc16a('0x33')](_0x3b4f42[_0xc16a('0x2f')],qs[_0xc16a('0x35')](_0xf2854f[_0xc16a('0x34')][_0xc16a('0x35')]));_0x4e0e79[_0xc16a('0x37')]=_0x4e0e79[_0xc16a('0x37')]['length']?_0x4e0e79[_0xc16a('0x37')]:_0x3b4f42['model'];_0x4e0e79[_0xc16a('0x4f')]=qs[_0xc16a('0x3a')](_0xf2854f[_0xc16a('0x34')]['sort']);_0x4e0e79[_0xc16a('0x3b')]=qs['filters'](_[_0xc16a('0x3c')](_0xf2854f['query'],_0x3b4f42[_0xc16a('0x32')]));if(_0xf2854f[_0xc16a('0x34')][_0xc16a('0x3d')]){_0x4e0e79[_0xc16a('0x3b')]=_[_0xc16a('0x3e')](_0x4e0e79[_0xc16a('0x3b')],{'$or':_[_0xc16a('0x30')](_0x4e0e79[_0xc16a('0x37')],function(_0x4444d4){var _0x1095d6={};_0x1095d6[_0x4444d4]={'$like':'%'+_0xf2854f[_0xc16a('0x34')]['filter']+'%'};return _0x1095d6;})});}_0x4e0e79=_[_0xc16a('0x3e')]({},_0x4e0e79,_0xf2854f[_0xc16a('0x40')]);return _0x2c8da3[_0xc16a('0x4e')](_0x4e0e79);}})[_0xc16a('0x26')](function(_0x53baf2){if(_0x53baf2){_0x1e0341=_0x53baf2[_0xc16a('0x36')];if(!_0xf2854f[_0xc16a('0x34')][_0xc16a('0x38')](_0xc16a('0x39'))){_0x4e0e79['limit']=qs['limit'](_0xf2854f[_0xc16a('0x34')][_0xc16a('0x1e')]);_0x4e0e79[_0xc16a('0x1c')]=qs[_0xc16a('0x1c')](_0xf2854f[_0xc16a('0x34')][_0xc16a('0x1c')]);}return _0x2c8da3[_0xc16a('0x4e')](_0x4e0e79);}})[_0xc16a('0x26')](function(_0x14149b){if(_0x14149b){return _0x14149b?{'count':_0x1e0341,'rows':_0x14149b}:null;}})['then'](respondWithResult(_0x27eda0,null))[_0xc16a('0x45')](handleError(_0x27eda0,null));};