8db237edb2a263eec8b3a716bf4efc059fbca894
[motion2.git] / 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 _0x0748=['reject','save','update','then','destroy','error','stack','name','send','index','fieldName','type','model','query','filters','attributes','intersection','fields','length','sort','pick','filter','where','map','VIRTUAL','merge','options','SalesforceConfiguration','includeAll','include','findAll','catch','show','params','keys','find','create','body','SalesforceField','rawAttributes','order','getFields','hasOwnProperty','findOne','getSubjects','getDescriptions','eml-format','rimraf','request-promise','moment','bluebird','mustache','util','sox','ejs','fs-extra','lodash','squel','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','end','status','json','offset','undefined','limit','count','Content-Range','apply'];(function(_0x5a5ece,_0x612749){var _0x470616=function(_0xb28c2f){while(--_0xb28c2f){_0x5a5ece['push'](_0x5a5ece['shift']());}};_0x470616(++_0x612749);}(_0x0748,0xce));var _0x8074=function(_0x20c9b2,_0x55d7b1){_0x20c9b2=_0x20c9b2-0x0;var _0x2c6030=_0x0748[_0x20c9b2];return _0x2c6030;};'use strict';var emlformat=require(_0x8074('0x0'));var rimraf=require(_0x8074('0x1'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0x8074('0x2'));var moment=require(_0x8074('0x3'));var BPromise=require(_0x8074('0x4'));var Mustache=require(_0x8074('0x5'));var util=require(_0x8074('0x6'));var path=require('path');var sox=require(_0x8074('0x7'));var csv=require('to-csv');var ejs=require(_0x8074('0x8'));var fs=require('fs');var fs_extra=require(_0x8074('0x9'));var _=require(_0x8074('0xa'));var squel=require(_0x8074('0xb'));var crypto=require('crypto');var jsforce=require(_0x8074('0xc'));var deskjs=require(_0x8074('0xd'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x8074('0xe'));var Redis=require(_0x8074('0xf'));var authService=require(_0x8074('0x10'));var qs=require('../../components/parsers/qs');var as=require(_0x8074('0x11'));var hardwareService=require(_0x8074('0x12'));var logger=require(_0x8074('0x13'))(_0x8074('0x14'));var utils=require('../../config/utils');var config=require(_0x8074('0x15'));var licenseUtil=require(_0x8074('0x16'));var db=require(_0x8074('0x17'))['db'];function respondWithStatusCode(_0x49ab3b,_0x5b8f27){_0x5b8f27=_0x5b8f27||0xcc;return function(_0x5f0a44){if(_0x5f0a44){return _0x49ab3b[_0x8074('0x18')](_0x5b8f27);}return _0x49ab3b['status'](_0x5b8f27)[_0x8074('0x19')]();};}function respondWithResult(_0x5258d2,_0x24ec6d){_0x24ec6d=_0x24ec6d||0xc8;return function(_0x3f64cd){if(_0x3f64cd){return _0x5258d2[_0x8074('0x1a')](_0x24ec6d)[_0x8074('0x1b')](_0x3f64cd);}};}function respondWithFilteredResult(_0x46c8be,_0x4f3cc1){return function(_0x2b1e76){if(_0x2b1e76){var _0x457e66=typeof _0x4f3cc1[_0x8074('0x1c')]===_0x8074('0x1d')&&typeof _0x4f3cc1[_0x8074('0x1e')]===_0x8074('0x1d');var _0x26626e=_0x2b1e76[_0x8074('0x1f')];var _0x4bda1a=_0x457e66?0x0:_0x4f3cc1['offset'];var _0x3a5e8b=_0x457e66?_0x2b1e76[_0x8074('0x1f')]:_0x4f3cc1['offset']+_0x4f3cc1[_0x8074('0x1e')];var _0xba499c;if(_0x3a5e8b>=_0x26626e){_0x3a5e8b=_0x26626e;_0xba499c=0xc8;}else{_0xba499c=0xce;}_0x46c8be['status'](_0xba499c);return _0x46c8be['set'](_0x8074('0x20'),_0x4bda1a+'-'+_0x3a5e8b+'/'+_0x26626e)[_0x8074('0x1b')](_0x2b1e76);}return null;};}function patchUpdates(_0x1a8f3b){return function(_0x1ead2a){try{jsonpatch[_0x8074('0x21')](_0x1ead2a,_0x1a8f3b,!![]);}catch(_0x34ea45){return BPromise[_0x8074('0x22')](_0x34ea45);}return _0x1ead2a[_0x8074('0x23')]();};}function saveUpdates(_0x4e713b,_0x41d722){return function(_0x69d35f){if(_0x69d35f){return _0x69d35f[_0x8074('0x24')](_0x4e713b)[_0x8074('0x25')](function(_0x3864e7){return _0x3864e7;});}return null;};}function removeEntity(_0x252fe9,_0xc3a022){return function(_0x321e1a){if(_0x321e1a){return _0x321e1a[_0x8074('0x26')]()['then'](function(){_0x252fe9[_0x8074('0x1a')](0xcc)['end']();});}};}function handleEntityNotFound(_0x5bb290,_0x459c90){return function(_0x80a1f9){if(!_0x80a1f9){_0x5bb290[_0x8074('0x18')](0x194);}return _0x80a1f9;};}function handleError(_0x301b7c,_0x56a395){_0x56a395=_0x56a395||0x1f4;return function(_0x57ac9f){logger[_0x8074('0x27')](_0x57ac9f[_0x8074('0x28')]);if(_0x57ac9f[_0x8074('0x29')]){delete _0x57ac9f[_0x8074('0x29')];}_0x301b7c[_0x8074('0x1a')](_0x56a395)[_0x8074('0x2a')](_0x57ac9f);};}exports[_0x8074('0x2b')]=function(_0x6e555d,_0x5848a3){var _0x3200c6={},_0x4b99be={},_0x2af335={'count':0x0,'rows':[]};var _0x40677e=_['map'](db['SalesforceConfiguration']['rawAttributes'],function(_0x529f47){return{'name':_0x529f47[_0x8074('0x2c')],'type':_0x529f47[_0x8074('0x2d')]['key']};});_0x4b99be[_0x8074('0x2e')]=_['map'](_0x40677e,_0x8074('0x29'));_0x4b99be[_0x8074('0x2f')]=_['keys'](_0x6e555d[_0x8074('0x2f')]);_0x4b99be[_0x8074('0x30')]=_['intersection'](_0x4b99be[_0x8074('0x2e')],_0x4b99be[_0x8074('0x2f')]);_0x3200c6[_0x8074('0x31')]=_[_0x8074('0x32')](_0x4b99be['model'],qs[_0x8074('0x33')](_0x6e555d[_0x8074('0x2f')]['fields']));_0x3200c6[_0x8074('0x31')]=_0x3200c6[_0x8074('0x31')][_0x8074('0x34')]?_0x3200c6['attributes']:_0x4b99be['model'];if(!_0x6e555d['query']['hasOwnProperty']('nolimit')){_0x3200c6['limit']=qs[_0x8074('0x1e')](_0x6e555d[_0x8074('0x2f')][_0x8074('0x1e')]);_0x3200c6[_0x8074('0x1c')]=qs['offset'](_0x6e555d[_0x8074('0x2f')][_0x8074('0x1c')]);}_0x3200c6['order']=qs[_0x8074('0x35')](_0x6e555d[_0x8074('0x2f')][_0x8074('0x35')]);_0x3200c6['where']=qs['filters'](_[_0x8074('0x36')](_0x6e555d[_0x8074('0x2f')],_0x4b99be[_0x8074('0x30')]),_0x40677e);if(_0x6e555d[_0x8074('0x2f')][_0x8074('0x37')]){_0x3200c6[_0x8074('0x38')]=_['merge'](_0x3200c6[_0x8074('0x38')],{'$or':_[_0x8074('0x39')](_0x40677e,function(_0x5d81d5){if(_0x5d81d5[_0x8074('0x2d')]!==_0x8074('0x3a')){var _0x4ebb94={};_0x4ebb94[_0x5d81d5[_0x8074('0x29')]]={'$like':'%'+_0x6e555d[_0x8074('0x2f')][_0x8074('0x37')]+'%'};return _0x4ebb94;}})});}_0x3200c6=_[_0x8074('0x3b')]({},_0x3200c6,_0x6e555d[_0x8074('0x3c')]);var _0x2681ce={'where':_0x3200c6[_0x8074('0x38')]};return db[_0x8074('0x3d')][_0x8074('0x1f')](_0x2681ce)[_0x8074('0x25')](function(_0x1f6797){_0x2af335[_0x8074('0x1f')]=_0x1f6797;if(_0x6e555d[_0x8074('0x2f')][_0x8074('0x3e')]){_0x3200c6[_0x8074('0x3f')]=[{'all':!![]}];}return db[_0x8074('0x3d')][_0x8074('0x40')](_0x3200c6);})[_0x8074('0x25')](function(_0x51d7a7){_0x2af335['rows']=_0x51d7a7;return _0x2af335;})[_0x8074('0x25')](respondWithFilteredResult(_0x5848a3,_0x3200c6))[_0x8074('0x41')](handleError(_0x5848a3,null));};exports[_0x8074('0x42')]=function(_0x1fe1f4,_0x3f9ebb){var _0x1015b3={'raw':![],'where':{'id':_0x1fe1f4[_0x8074('0x43')]['id']}},_0x2f34f3={};_0x2f34f3[_0x8074('0x2e')]=_[_0x8074('0x44')](db[_0x8074('0x3d')]['rawAttributes']);_0x2f34f3[_0x8074('0x2f')]=_[_0x8074('0x44')](_0x1fe1f4[_0x8074('0x2f')]);_0x2f34f3[_0x8074('0x30')]=_[_0x8074('0x32')](_0x2f34f3[_0x8074('0x2e')],_0x2f34f3['query']);_0x1015b3[_0x8074('0x31')]=_['intersection'](_0x2f34f3['model'],qs[_0x8074('0x33')](_0x1fe1f4[_0x8074('0x2f')][_0x8074('0x33')]));_0x1015b3['attributes']=_0x1015b3['attributes'][_0x8074('0x34')]?_0x1015b3['attributes']:_0x2f34f3[_0x8074('0x2e')];if(_0x1fe1f4['query'][_0x8074('0x3e')]){_0x1015b3['include']=[{'all':!![]}];}_0x1015b3=_[_0x8074('0x3b')]({},_0x1015b3,_0x1fe1f4['options']);return db['SalesforceConfiguration'][_0x8074('0x45')](_0x1015b3)['then'](handleEntityNotFound(_0x3f9ebb,null))[_0x8074('0x25')](respondWithResult(_0x3f9ebb,null))['catch'](handleError(_0x3f9ebb,null));};exports[_0x8074('0x46')]=function(_0x4ff015,_0x4c3fe6){return db[_0x8074('0x3d')][_0x8074('0x46')](_0x4ff015[_0x8074('0x47')],{})[_0x8074('0x25')](respondWithResult(_0x4c3fe6,0xc9))[_0x8074('0x41')](handleError(_0x4c3fe6,null));};exports[_0x8074('0x24')]=function(_0x3c2186,_0xc382b5){if(_0x3c2186['body']['id']){delete _0x3c2186['body']['id'];}return db['SalesforceConfiguration'][_0x8074('0x45')]({'where':{'id':_0x3c2186[_0x8074('0x43')]['id']}})[_0x8074('0x25')](handleEntityNotFound(_0xc382b5,null))['then'](saveUpdates(_0x3c2186[_0x8074('0x47')],null))[_0x8074('0x25')](respondWithResult(_0xc382b5,null))[_0x8074('0x41')](handleError(_0xc382b5,null));};exports[_0x8074('0x26')]=function(_0x2e0daf,_0xeb0973){return db[_0x8074('0x3d')]['find']({'where':{'id':_0x2e0daf['params']['id']}})[_0x8074('0x25')](handleEntityNotFound(_0xeb0973,null))[_0x8074('0x25')](removeEntity(_0xeb0973,null))['catch'](handleError(_0xeb0973,null));};exports['getFields']=function(_0xfc8d57,_0x4c3b68,_0x5e7a3b){var _0x5bbaad={};var _0x54c6c1={};var _0x24f3ce;var _0x47c16c;return db['SalesforceConfiguration']['findOne']({'where':{'id':_0xfc8d57['params']['id']}})[_0x8074('0x25')](handleEntityNotFound(_0x4c3b68,null))[_0x8074('0x25')](function(_0x4685fa){if(_0x4685fa){_0x24f3ce=_0x4685fa;_0x54c6c1[_0x8074('0x2e')]=_[_0x8074('0x44')](db[_0x8074('0x48')][_0x8074('0x49')]);_0x54c6c1[_0x8074('0x2f')]=_[_0x8074('0x44')](_0xfc8d57['query']);_0x54c6c1[_0x8074('0x30')]=_[_0x8074('0x32')](_0x54c6c1[_0x8074('0x2e')],_0x54c6c1[_0x8074('0x2f')]);_0x5bbaad[_0x8074('0x31')]=_['intersection'](_0x54c6c1['model'],qs[_0x8074('0x33')](_0xfc8d57[_0x8074('0x2f')][_0x8074('0x33')]));_0x5bbaad[_0x8074('0x31')]=_0x5bbaad[_0x8074('0x31')][_0x8074('0x34')]?_0x5bbaad[_0x8074('0x31')]:_0x54c6c1['model'];_0x5bbaad[_0x8074('0x4a')]=qs[_0x8074('0x35')](_0xfc8d57['query'][_0x8074('0x35')]);_0x5bbaad[_0x8074('0x38')]=qs[_0x8074('0x30')](_[_0x8074('0x36')](_0xfc8d57[_0x8074('0x2f')],_0x54c6c1[_0x8074('0x30')]));if(_0xfc8d57[_0x8074('0x2f')][_0x8074('0x37')]){_0x5bbaad[_0x8074('0x38')]=_[_0x8074('0x3b')](_0x5bbaad[_0x8074('0x38')],{'$or':_[_0x8074('0x39')](_0x5bbaad[_0x8074('0x31')],function(_0x503b54){var _0x3c7dc9={};_0x3c7dc9[_0x503b54]={'$like':'%'+_0xfc8d57[_0x8074('0x2f')][_0x8074('0x37')]+'%'};return _0x3c7dc9;})});}_0x5bbaad=_[_0x8074('0x3b')]({},_0x5bbaad,_0xfc8d57[_0x8074('0x3c')]);return _0x24f3ce[_0x8074('0x4b')](_0x5bbaad);}})[_0x8074('0x25')](function(_0x4e94c6){if(_0x4e94c6){_0x47c16c=_0x4e94c6[_0x8074('0x34')];if(!_0xfc8d57['query'][_0x8074('0x4c')]('nolimit')){_0x5bbaad[_0x8074('0x1e')]=qs[_0x8074('0x1e')](_0xfc8d57[_0x8074('0x2f')][_0x8074('0x1e')]);_0x5bbaad['offset']=qs[_0x8074('0x1c')](_0xfc8d57[_0x8074('0x2f')][_0x8074('0x1c')]);}return _0x24f3ce[_0x8074('0x4b')](_0x5bbaad);}})[_0x8074('0x25')](function(_0x1f8f1f){if(_0x1f8f1f){return _0x1f8f1f?{'count':_0x47c16c,'rows':_0x1f8f1f}:null;}})[_0x8074('0x25')](respondWithResult(_0x4c3b68,null))[_0x8074('0x41')](handleError(_0x4c3b68,null));};exports['getSubjects']=function(_0x4b93a0,_0xdda1dd,_0x438563){var _0x45b2e2={};var _0x2aee9f={};var _0x36a33c;var _0x1ad598;return db[_0x8074('0x3d')][_0x8074('0x4d')]({'where':{'id':_0x4b93a0[_0x8074('0x43')]['id']}})[_0x8074('0x25')](handleEntityNotFound(_0xdda1dd,null))[_0x8074('0x25')](function(_0x22793d){if(_0x22793d){_0x36a33c=_0x22793d;_0x2aee9f[_0x8074('0x2e')]=_[_0x8074('0x44')](db[_0x8074('0x48')][_0x8074('0x49')]);_0x2aee9f[_0x8074('0x2f')]=_[_0x8074('0x44')](_0x4b93a0[_0x8074('0x2f')]);_0x2aee9f['filters']=_[_0x8074('0x32')](_0x2aee9f[_0x8074('0x2e')],_0x2aee9f[_0x8074('0x2f')]);_0x45b2e2[_0x8074('0x31')]=_[_0x8074('0x32')](_0x2aee9f[_0x8074('0x2e')],qs['fields'](_0x4b93a0[_0x8074('0x2f')]['fields']));_0x45b2e2[_0x8074('0x31')]=_0x45b2e2[_0x8074('0x31')][_0x8074('0x34')]?_0x45b2e2['attributes']:_0x2aee9f[_0x8074('0x2e')];_0x45b2e2[_0x8074('0x4a')]=qs[_0x8074('0x35')](_0x4b93a0['query'][_0x8074('0x35')]);_0x45b2e2[_0x8074('0x38')]=qs['filters'](_[_0x8074('0x36')](_0x4b93a0[_0x8074('0x2f')],_0x2aee9f[_0x8074('0x30')]));if(_0x4b93a0[_0x8074('0x2f')]['filter']){_0x45b2e2[_0x8074('0x38')]=_[_0x8074('0x3b')](_0x45b2e2[_0x8074('0x38')],{'$or':_[_0x8074('0x39')](_0x45b2e2[_0x8074('0x31')],function(_0x47da4f){var _0x24372d={};_0x24372d[_0x47da4f]={'$like':'%'+_0x4b93a0[_0x8074('0x2f')][_0x8074('0x37')]+'%'};return _0x24372d;})});}_0x45b2e2=_[_0x8074('0x3b')]({},_0x45b2e2,_0x4b93a0[_0x8074('0x3c')]);return _0x36a33c[_0x8074('0x4e')](_0x45b2e2);}})[_0x8074('0x25')](function(_0xd0b135){if(_0xd0b135){_0x1ad598=_0xd0b135['length'];if(!_0x4b93a0[_0x8074('0x2f')][_0x8074('0x4c')]('nolimit')){_0x45b2e2['limit']=qs[_0x8074('0x1e')](_0x4b93a0['query'][_0x8074('0x1e')]);_0x45b2e2['offset']=qs[_0x8074('0x1c')](_0x4b93a0[_0x8074('0x2f')][_0x8074('0x1c')]);}return _0x36a33c[_0x8074('0x4e')](_0x45b2e2);}})['then'](function(_0xd028d7){if(_0xd028d7){return _0xd028d7?{'count':_0x1ad598,'rows':_0xd028d7}:null;}})[_0x8074('0x25')](respondWithResult(_0xdda1dd,null))[_0x8074('0x41')](handleError(_0xdda1dd,null));};exports[_0x8074('0x4f')]=function(_0x1ecf9f,_0x1e77c3,_0x157975){var _0xe7b612={};var _0x4409be={};var _0x26cbc4;var _0x49b5d1;return db[_0x8074('0x3d')][_0x8074('0x4d')]({'where':{'id':_0x1ecf9f[_0x8074('0x43')]['id']}})['then'](handleEntityNotFound(_0x1e77c3,null))[_0x8074('0x25')](function(_0x568298){if(_0x568298){_0x26cbc4=_0x568298;_0x4409be[_0x8074('0x2e')]=_['keys'](db[_0x8074('0x48')][_0x8074('0x49')]);_0x4409be['query']=_['keys'](_0x1ecf9f[_0x8074('0x2f')]);_0x4409be['filters']=_[_0x8074('0x32')](_0x4409be[_0x8074('0x2e')],_0x4409be[_0x8074('0x2f')]);_0xe7b612[_0x8074('0x31')]=_[_0x8074('0x32')](_0x4409be[_0x8074('0x2e')],qs['fields'](_0x1ecf9f[_0x8074('0x2f')][_0x8074('0x33')]));_0xe7b612[_0x8074('0x31')]=_0xe7b612[_0x8074('0x31')][_0x8074('0x34')]?_0xe7b612[_0x8074('0x31')]:_0x4409be[_0x8074('0x2e')];_0xe7b612[_0x8074('0x4a')]=qs[_0x8074('0x35')](_0x1ecf9f[_0x8074('0x2f')][_0x8074('0x35')]);_0xe7b612[_0x8074('0x38')]=qs['filters'](_['pick'](_0x1ecf9f[_0x8074('0x2f')],_0x4409be[_0x8074('0x30')]));if(_0x1ecf9f['query'][_0x8074('0x37')]){_0xe7b612[_0x8074('0x38')]=_['merge'](_0xe7b612['where'],{'$or':_[_0x8074('0x39')](_0xe7b612[_0x8074('0x31')],function(_0x6c9f56){var _0x37b5f6={};_0x37b5f6[_0x6c9f56]={'$like':'%'+_0x1ecf9f['query'][_0x8074('0x37')]+'%'};return _0x37b5f6;})});}_0xe7b612=_[_0x8074('0x3b')]({},_0xe7b612,_0x1ecf9f[_0x8074('0x3c')]);return _0x26cbc4[_0x8074('0x4f')](_0xe7b612);}})[_0x8074('0x25')](function(_0x3727d7){if(_0x3727d7){_0x49b5d1=_0x3727d7['length'];if(!_0x1ecf9f['query'][_0x8074('0x4c')]('nolimit')){_0xe7b612[_0x8074('0x1e')]=qs[_0x8074('0x1e')](_0x1ecf9f[_0x8074('0x2f')]['limit']);_0xe7b612[_0x8074('0x1c')]=qs[_0x8074('0x1c')](_0x1ecf9f[_0x8074('0x2f')]['offset']);}return _0x26cbc4[_0x8074('0x4f')](_0xe7b612);}})[_0x8074('0x25')](function(_0x4929eb){if(_0x4929eb){return _0x4929eb?{'count':_0x49b5d1,'rows':_0x4929eb}:null;}})['then'](respondWithResult(_0x1e77c3,null))[_0x8074('0x41')](handleError(_0x1e77c3,null));};