server/api/intSalesforceConfiguration/intSalesforceConfiguration.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 _0x724d=['../../components/auth/service','../../components/parsers/advancedSearch','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','then','stack','name','send','index','map','SalesforceConfiguration','rawAttributes','fieldName','type','key','query','filters','attributes','intersection','model','length','order','sort','pick','filter','where','merge','VIRTUAL','options','includeAll','include','rows','keys','fields','catch','body','find','params','destroy','getFields','findOne','hasOwnProperty','nolimit','SalesforceField','getSubjects','getDescriptions','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','desk.js','querystring','papaparse','ioredis'];(function(_0x587dc0,_0x2a409f){var _0x4abb3e=function(_0x3fdcec){while(--_0x3fdcec){_0x587dc0['push'](_0x587dc0['shift']());}};_0x4abb3e(++_0x2a409f);}(_0x724d,0xe5));var _0xd724=function(_0x5bf2b3,_0xfcd364){_0x5bf2b3=_0x5bf2b3-0x0;var _0x5e8a9b=_0x724d[_0x5bf2b3];return _0x5e8a9b;};'use strict';var emlformat=require(_0xd724('0x0'));var rimraf=require(_0xd724('0x1'));var zipdir=require(_0xd724('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0xd724('0x3'));var moment=require(_0xd724('0x4'));var BPromise=require(_0xd724('0x5'));var Mustache=require(_0xd724('0x6'));var util=require(_0xd724('0x7'));var path=require(_0xd724('0x8'));var sox=require(_0xd724('0x9'));var csv=require(_0xd724('0xa'));var ejs=require(_0xd724('0xb'));var fs=require('fs');var fs_extra=require(_0xd724('0xc'));var _=require(_0xd724('0xd'));var squel=require(_0xd724('0xe'));var crypto=require(_0xd724('0xf'));var jsforce=require('jsforce');var deskjs=require(_0xd724('0x10'));var toCsv=require(_0xd724('0xa'));var querystring=require(_0xd724('0x11'));var Papa=require(_0xd724('0x12'));var Redis=require(_0xd724('0x13'));var authService=require(_0xd724('0x14'));var qs=require('../../components/parsers/qs');var as=require(_0xd724('0x15'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0xd724('0x16'));var utils=require(_0xd724('0x17'));var config=require(_0xd724('0x18'));var licenseUtil=require(_0xd724('0x19'));var db=require(_0xd724('0x1a'))['db'];function respondWithStatusCode(_0x3628a4,_0x4438ca){_0x4438ca=_0x4438ca||0xcc;return function(_0x17e1ea){if(_0x17e1ea){return _0x3628a4[_0xd724('0x1b')](_0x4438ca);}return _0x3628a4[_0xd724('0x1c')](_0x4438ca)[_0xd724('0x1d')]();};}function respondWithResult(_0x1a20c9,_0x3a9867){_0x3a9867=_0x3a9867||0xc8;return function(_0x1017d6){if(_0x1017d6){return _0x1a20c9[_0xd724('0x1c')](_0x3a9867)[_0xd724('0x1e')](_0x1017d6);}};}function respondWithFilteredResult(_0x48f9f7,_0x24a95d){return function(_0x29f82c){if(_0x29f82c){var _0x394ffc=typeof _0x24a95d[_0xd724('0x1f')]===_0xd724('0x20')&&typeof _0x24a95d[_0xd724('0x21')]===_0xd724('0x20');var _0x4572a9=_0x29f82c[_0xd724('0x22')];var _0x734b54=_0x394ffc?0x0:_0x24a95d[_0xd724('0x1f')];var _0x32985b=_0x394ffc?_0x29f82c[_0xd724('0x22')]:_0x24a95d[_0xd724('0x1f')]+_0x24a95d[_0xd724('0x21')];var _0x50d5ea;if(_0x32985b>=_0x4572a9){_0x32985b=_0x4572a9;_0x50d5ea=0xc8;}else{_0x50d5ea=0xce;}_0x48f9f7['status'](_0x50d5ea);return _0x48f9f7[_0xd724('0x23')](_0xd724('0x24'),_0x734b54+'-'+_0x32985b+'/'+_0x4572a9)[_0xd724('0x1e')](_0x29f82c);}return null;};}function patchUpdates(_0x180411){return function(_0x1bc827){try{jsonpatch[_0xd724('0x25')](_0x1bc827,_0x180411,!![]);}catch(_0x24d90a){return BPromise[_0xd724('0x26')](_0x24d90a);}return _0x1bc827[_0xd724('0x27')]();};}function saveUpdates(_0x379d26,_0x588079){return function(_0x135955){if(_0x135955){return _0x135955[_0xd724('0x28')](_0x379d26)['then'](function(_0x9b0f81){return _0x9b0f81;});}return null;};}function removeEntity(_0x4a4a0c,_0x8fa74){return function(_0x1522d2){if(_0x1522d2){return _0x1522d2['destroy']()[_0xd724('0x29')](function(){_0x4a4a0c[_0xd724('0x1c')](0xcc)['end']();});}};}function handleEntityNotFound(_0x2af376,_0x314e6b){return function(_0x435d2b){if(!_0x435d2b){_0x2af376[_0xd724('0x1b')](0x194);}return _0x435d2b;};}function handleError(_0x18e4de,_0x450abe){_0x450abe=_0x450abe||0x1f4;return function(_0x1fe8a0){logger['error'](_0x1fe8a0[_0xd724('0x2a')]);if(_0x1fe8a0[_0xd724('0x2b')]){delete _0x1fe8a0[_0xd724('0x2b')];}_0x18e4de[_0xd724('0x1c')](_0x450abe)[_0xd724('0x2c')](_0x1fe8a0);};}exports[_0xd724('0x2d')]=function(_0x26b09a,_0x58ef99){var _0x27a34e={},_0x244b2f={},_0x455d57={'count':0x0,'rows':[]};var _0x4ee6d9=_[_0xd724('0x2e')](db[_0xd724('0x2f')][_0xd724('0x30')],function(_0x32fa73){return{'name':_0x32fa73[_0xd724('0x31')],'type':_0x32fa73[_0xd724('0x32')][_0xd724('0x33')]};});_0x244b2f['model']=_[_0xd724('0x2e')](_0x4ee6d9,_0xd724('0x2b'));_0x244b2f[_0xd724('0x34')]=_['keys'](_0x26b09a[_0xd724('0x34')]);_0x244b2f[_0xd724('0x35')]=_['intersection'](_0x244b2f['model'],_0x244b2f[_0xd724('0x34')]);_0x27a34e[_0xd724('0x36')]=_[_0xd724('0x37')](_0x244b2f[_0xd724('0x38')],qs['fields'](_0x26b09a[_0xd724('0x34')]['fields']));_0x27a34e[_0xd724('0x36')]=_0x27a34e[_0xd724('0x36')][_0xd724('0x39')]?_0x27a34e[_0xd724('0x36')]:_0x244b2f[_0xd724('0x38')];if(!_0x26b09a[_0xd724('0x34')]['hasOwnProperty']('nolimit')){_0x27a34e[_0xd724('0x21')]=qs['limit'](_0x26b09a['query']['limit']);_0x27a34e[_0xd724('0x1f')]=qs[_0xd724('0x1f')](_0x26b09a[_0xd724('0x34')][_0xd724('0x1f')]);}_0x27a34e[_0xd724('0x3a')]=qs['sort'](_0x26b09a[_0xd724('0x34')][_0xd724('0x3b')]);_0x27a34e['where']=qs[_0xd724('0x35')](_[_0xd724('0x3c')](_0x26b09a[_0xd724('0x34')],_0x244b2f[_0xd724('0x35')]),_0x4ee6d9);if(_0x26b09a[_0xd724('0x34')][_0xd724('0x3d')]){_0x27a34e[_0xd724('0x3e')]=_[_0xd724('0x3f')](_0x27a34e['where'],{'$or':_['map'](_0x4ee6d9,function(_0x26178d){if(_0x26178d[_0xd724('0x32')]!==_0xd724('0x40')){var _0x17c945={};_0x17c945[_0x26178d[_0xd724('0x2b')]]={'$like':'%'+_0x26b09a[_0xd724('0x34')][_0xd724('0x3d')]+'%'};return _0x17c945;}})});}_0x27a34e=_['merge']({},_0x27a34e,_0x26b09a[_0xd724('0x41')]);var _0x2cd6e2={'where':_0x27a34e[_0xd724('0x3e')]};return db[_0xd724('0x2f')]['count'](_0x2cd6e2)[_0xd724('0x29')](function(_0x2b93c2){_0x455d57[_0xd724('0x22')]=_0x2b93c2;if(_0x26b09a[_0xd724('0x34')][_0xd724('0x42')]){_0x27a34e[_0xd724('0x43')]=[{'all':!![]}];}return db['SalesforceConfiguration']['findAll'](_0x27a34e);})[_0xd724('0x29')](function(_0x9bdf3d){_0x455d57[_0xd724('0x44')]=_0x9bdf3d;return _0x455d57;})['then'](respondWithFilteredResult(_0x58ef99,_0x27a34e))['catch'](handleError(_0x58ef99,null));};exports['show']=function(_0xaa0d1b,_0x49a416){var _0x26935f={'raw':![],'where':{'id':_0xaa0d1b['params']['id']}},_0x2487d4={};_0x2487d4['model']=_[_0xd724('0x45')](db[_0xd724('0x2f')][_0xd724('0x30')]);_0x2487d4['query']=_[_0xd724('0x45')](_0xaa0d1b['query']);_0x2487d4[_0xd724('0x35')]=_[_0xd724('0x37')](_0x2487d4[_0xd724('0x38')],_0x2487d4[_0xd724('0x34')]);_0x26935f[_0xd724('0x36')]=_[_0xd724('0x37')](_0x2487d4[_0xd724('0x38')],qs[_0xd724('0x46')](_0xaa0d1b[_0xd724('0x34')][_0xd724('0x46')]));_0x26935f[_0xd724('0x36')]=_0x26935f[_0xd724('0x36')][_0xd724('0x39')]?_0x26935f[_0xd724('0x36')]:_0x2487d4['model'];if(_0xaa0d1b['query'][_0xd724('0x42')]){_0x26935f['include']=[{'all':!![]}];}_0x26935f=_[_0xd724('0x3f')]({},_0x26935f,_0xaa0d1b['options']);return db[_0xd724('0x2f')]['find'](_0x26935f)['then'](handleEntityNotFound(_0x49a416,null))[_0xd724('0x29')](respondWithResult(_0x49a416,null))[_0xd724('0x47')](handleError(_0x49a416,null));};exports['create']=function(_0x473573,_0xe4b3a8){return db[_0xd724('0x2f')]['create'](_0x473573[_0xd724('0x48')],{})[_0xd724('0x29')](respondWithResult(_0xe4b3a8,0xc9))[_0xd724('0x47')](handleError(_0xe4b3a8,null));};exports[_0xd724('0x28')]=function(_0x334295,_0xbc3b0f){if(_0x334295[_0xd724('0x48')]['id']){delete _0x334295[_0xd724('0x48')]['id'];}return db[_0xd724('0x2f')][_0xd724('0x49')]({'where':{'id':_0x334295[_0xd724('0x4a')]['id']}})[_0xd724('0x29')](handleEntityNotFound(_0xbc3b0f,null))[_0xd724('0x29')](saveUpdates(_0x334295[_0xd724('0x48')],null))[_0xd724('0x29')](respondWithResult(_0xbc3b0f,null))['catch'](handleError(_0xbc3b0f,null));};exports[_0xd724('0x4b')]=function(_0x1acf63,_0x5e250f){return db[_0xd724('0x2f')][_0xd724('0x49')]({'where':{'id':_0x1acf63[_0xd724('0x4a')]['id']}})[_0xd724('0x29')](handleEntityNotFound(_0x5e250f,null))[_0xd724('0x29')](removeEntity(_0x5e250f,null))[_0xd724('0x47')](handleError(_0x5e250f,null));};exports[_0xd724('0x4c')]=function(_0x2e0a05,_0x3c8cd2,_0xda92c8){var _0x12b669={};var _0x173dbe={};var _0x43b1b3;var _0x2ae97e;return db[_0xd724('0x2f')][_0xd724('0x4d')]({'where':{'id':_0x2e0a05['params']['id']}})[_0xd724('0x29')](handleEntityNotFound(_0x3c8cd2,null))[_0xd724('0x29')](function(_0x4b7b95){if(_0x4b7b95){_0x43b1b3=_0x4b7b95;_0x173dbe['model']=_[_0xd724('0x45')](db['SalesforceField'][_0xd724('0x30')]);_0x173dbe[_0xd724('0x34')]=_[_0xd724('0x45')](_0x2e0a05[_0xd724('0x34')]);_0x173dbe[_0xd724('0x35')]=_[_0xd724('0x37')](_0x173dbe[_0xd724('0x38')],_0x173dbe[_0xd724('0x34')]);_0x12b669['attributes']=_[_0xd724('0x37')](_0x173dbe[_0xd724('0x38')],qs[_0xd724('0x46')](_0x2e0a05[_0xd724('0x34')][_0xd724('0x46')]));_0x12b669['attributes']=_0x12b669['attributes'][_0xd724('0x39')]?_0x12b669[_0xd724('0x36')]:_0x173dbe[_0xd724('0x38')];_0x12b669[_0xd724('0x3a')]=qs['sort'](_0x2e0a05['query'][_0xd724('0x3b')]);_0x12b669[_0xd724('0x3e')]=qs[_0xd724('0x35')](_[_0xd724('0x3c')](_0x2e0a05[_0xd724('0x34')],_0x173dbe[_0xd724('0x35')]));if(_0x2e0a05[_0xd724('0x34')][_0xd724('0x3d')]){_0x12b669[_0xd724('0x3e')]=_[_0xd724('0x3f')](_0x12b669[_0xd724('0x3e')],{'$or':_['map'](_0x12b669[_0xd724('0x36')],function(_0x34d909){var _0x558e62={};_0x558e62[_0x34d909]={'$like':'%'+_0x2e0a05[_0xd724('0x34')][_0xd724('0x3d')]+'%'};return _0x558e62;})});}_0x12b669=_[_0xd724('0x3f')]({},_0x12b669,_0x2e0a05[_0xd724('0x41')]);return _0x43b1b3[_0xd724('0x4c')](_0x12b669);}})[_0xd724('0x29')](function(_0x342531){if(_0x342531){_0x2ae97e=_0x342531[_0xd724('0x39')];if(!_0x2e0a05[_0xd724('0x34')][_0xd724('0x4e')](_0xd724('0x4f'))){_0x12b669['limit']=qs[_0xd724('0x21')](_0x2e0a05[_0xd724('0x34')][_0xd724('0x21')]);_0x12b669[_0xd724('0x1f')]=qs[_0xd724('0x1f')](_0x2e0a05[_0xd724('0x34')][_0xd724('0x1f')]);}return _0x43b1b3[_0xd724('0x4c')](_0x12b669);}})[_0xd724('0x29')](function(_0x197e76){if(_0x197e76){return _0x197e76?{'count':_0x2ae97e,'rows':_0x197e76}:null;}})[_0xd724('0x29')](respondWithResult(_0x3c8cd2,null))[_0xd724('0x47')](handleError(_0x3c8cd2,null));};exports['getSubjects']=function(_0x11165f,_0x226d83,_0x36f2f9){var _0x489726={};var _0xa8e287={};var _0x56c106;var _0x46977a;return db[_0xd724('0x2f')][_0xd724('0x4d')]({'where':{'id':_0x11165f[_0xd724('0x4a')]['id']}})['then'](handleEntityNotFound(_0x226d83,null))[_0xd724('0x29')](function(_0x12e87f){if(_0x12e87f){_0x56c106=_0x12e87f;_0xa8e287[_0xd724('0x38')]=_['keys'](db[_0xd724('0x50')][_0xd724('0x30')]);_0xa8e287[_0xd724('0x34')]=_[_0xd724('0x45')](_0x11165f[_0xd724('0x34')]);_0xa8e287['filters']=_[_0xd724('0x37')](_0xa8e287['model'],_0xa8e287[_0xd724('0x34')]);_0x489726[_0xd724('0x36')]=_[_0xd724('0x37')](_0xa8e287[_0xd724('0x38')],qs[_0xd724('0x46')](_0x11165f[_0xd724('0x34')][_0xd724('0x46')]));_0x489726[_0xd724('0x36')]=_0x489726['attributes'][_0xd724('0x39')]?_0x489726[_0xd724('0x36')]:_0xa8e287['model'];_0x489726[_0xd724('0x3a')]=qs[_0xd724('0x3b')](_0x11165f[_0xd724('0x34')][_0xd724('0x3b')]);_0x489726['where']=qs['filters'](_[_0xd724('0x3c')](_0x11165f[_0xd724('0x34')],_0xa8e287[_0xd724('0x35')]));if(_0x11165f[_0xd724('0x34')]['filter']){_0x489726['where']=_['merge'](_0x489726['where'],{'$or':_[_0xd724('0x2e')](_0x489726['attributes'],function(_0x41aee6){var _0x3d04f2={};_0x3d04f2[_0x41aee6]={'$like':'%'+_0x11165f[_0xd724('0x34')]['filter']+'%'};return _0x3d04f2;})});}_0x489726=_['merge']({},_0x489726,_0x11165f[_0xd724('0x41')]);return _0x56c106[_0xd724('0x51')](_0x489726);}})['then'](function(_0x9ef09){if(_0x9ef09){_0x46977a=_0x9ef09[_0xd724('0x39')];if(!_0x11165f['query'][_0xd724('0x4e')](_0xd724('0x4f'))){_0x489726[_0xd724('0x21')]=qs[_0xd724('0x21')](_0x11165f[_0xd724('0x34')][_0xd724('0x21')]);_0x489726[_0xd724('0x1f')]=qs[_0xd724('0x1f')](_0x11165f['query'][_0xd724('0x1f')]);}return _0x56c106[_0xd724('0x51')](_0x489726);}})['then'](function(_0x3d688e){if(_0x3d688e){return _0x3d688e?{'count':_0x46977a,'rows':_0x3d688e}:null;}})[_0xd724('0x29')](respondWithResult(_0x226d83,null))[_0xd724('0x47')](handleError(_0x226d83,null));};exports[_0xd724('0x52')]=function(_0x5807dc,_0xfc693b,_0x36a3a9){var _0x19fee1={};var _0x136ac5={};var _0xe067d4;var _0x2e7660;return db[_0xd724('0x2f')][_0xd724('0x4d')]({'where':{'id':_0x5807dc[_0xd724('0x4a')]['id']}})[_0xd724('0x29')](handleEntityNotFound(_0xfc693b,null))[_0xd724('0x29')](function(_0x50231b){if(_0x50231b){_0xe067d4=_0x50231b;_0x136ac5[_0xd724('0x38')]=_[_0xd724('0x45')](db[_0xd724('0x50')][_0xd724('0x30')]);_0x136ac5[_0xd724('0x34')]=_['keys'](_0x5807dc['query']);_0x136ac5[_0xd724('0x35')]=_['intersection'](_0x136ac5[_0xd724('0x38')],_0x136ac5[_0xd724('0x34')]);_0x19fee1[_0xd724('0x36')]=_[_0xd724('0x37')](_0x136ac5['model'],qs[_0xd724('0x46')](_0x5807dc[_0xd724('0x34')][_0xd724('0x46')]));_0x19fee1[_0xd724('0x36')]=_0x19fee1[_0xd724('0x36')][_0xd724('0x39')]?_0x19fee1[_0xd724('0x36')]:_0x136ac5[_0xd724('0x38')];_0x19fee1[_0xd724('0x3a')]=qs[_0xd724('0x3b')](_0x5807dc[_0xd724('0x34')]['sort']);_0x19fee1['where']=qs[_0xd724('0x35')](_['pick'](_0x5807dc[_0xd724('0x34')],_0x136ac5[_0xd724('0x35')]));if(_0x5807dc['query']['filter']){_0x19fee1[_0xd724('0x3e')]=_[_0xd724('0x3f')](_0x19fee1['where'],{'$or':_[_0xd724('0x2e')](_0x19fee1[_0xd724('0x36')],function(_0x5480c3){var _0x5c7251={};_0x5c7251[_0x5480c3]={'$like':'%'+_0x5807dc[_0xd724('0x34')][_0xd724('0x3d')]+'%'};return _0x5c7251;})});}_0x19fee1=_[_0xd724('0x3f')]({},_0x19fee1,_0x5807dc[_0xd724('0x41')]);return _0xe067d4[_0xd724('0x52')](_0x19fee1);}})[_0xd724('0x29')](function(_0x18d2af){if(_0x18d2af){_0x2e7660=_0x18d2af[_0xd724('0x39')];if(!_0x5807dc[_0xd724('0x34')]['hasOwnProperty'](_0xd724('0x4f'))){_0x19fee1[_0xd724('0x21')]=qs['limit'](_0x5807dc['query'][_0xd724('0x21')]);_0x19fee1['offset']=qs[_0xd724('0x1f')](_0x5807dc['query'][_0xd724('0x1f')]);}return _0xe067d4[_0xd724('0x52')](_0x19fee1);}})[_0xd724('0x29')](function(_0x520902){if(_0x520902){return _0x520902?{'count':_0x2e7660,'rows':_0x520902}:null;}})[_0xd724('0x29')](respondWithResult(_0xfc693b,null))[_0xd724('0x47')](handleError(_0xfc693b,null));};