919a3fe212f0ebe1387e294577cb48cae693615f
[motion2.git] / server / api / intSalesforceAccount / intSalesforceAccount.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 _0x6ea0=['securityToken','slice','substring','lastIndexOf','login','concat','isNil','ticketType','sobject','OwnerId','ActivityDate','Subject','Description','email','textarea','phone','remove','includes','custom','picklistValues','label','value','boolean','true','False','false','test','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','lodash','jsforce','desk.js','to-csv','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','api','../../config/environment','../../config/license/util','../../components/integrations/configuration','sendStatus','status','end','json','undefined','count','offset','limit','Content-Range','apply','reject','save','update','then','stack','name','index','map','SalesforceAccount','rawAttributes','key','model','query','filters','intersection','attributes','fields','length','nolimit','order','sort','pick','filter','where','merge','type','VIRTUAL','includeAll','findAll','rows','show','params','options','find','catch','create','body','destroy','findOne','keys','SalesforceConfiguration','getConfigurations','hasOwnProperty','addConfiguration','AccountId','Subjects','getSubjects','channel','Descriptions','getDescriptions','SalesforceField','getFields','Task','remoteUri','clientId','clientSecret','username','password'];(function(_0x490883,_0x5448c1){var _0x188a52=function(_0x58cd76){while(--_0x58cd76){_0x490883['push'](_0x490883['shift']());}};_0x188a52(++_0x5448c1);}(_0x6ea0,0x1eb));var _0x06ea=function(_0x20e75a,_0x86ef5b){_0x20e75a=_0x20e75a-0x0;var _0x405bd4=_0x6ea0[_0x20e75a];return _0x405bd4;};'use strict';var emlformat=require(_0x06ea('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x06ea('0x1'));var jsonpatch=require(_0x06ea('0x2'));var rp=require(_0x06ea('0x3'));var moment=require(_0x06ea('0x4'));var BPromise=require(_0x06ea('0x5'));var Mustache=require(_0x06ea('0x6'));var util=require(_0x06ea('0x7'));var path=require('path');var sox=require('sox');var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x06ea('0x8'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x06ea('0x9'));var deskjs=require(_0x06ea('0xa'));var toCsv=require(_0x06ea('0xb'));var querystring=require(_0x06ea('0xc'));var Papa=require(_0x06ea('0xd'));var Redis=require('ioredis');var authService=require(_0x06ea('0xe'));var qs=require(_0x06ea('0xf'));var as=require(_0x06ea('0x10'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0x06ea('0x11'));var utils=require('../../config/utils');var config=require(_0x06ea('0x12'));var licenseUtil=require(_0x06ea('0x13'));var db=require('../../mysqldb')['db'];var integrations=require(_0x06ea('0x14'));function respondWithStatusCode(_0x22db41,_0x17b524){_0x17b524=_0x17b524||0xcc;return function(_0x77ac25){if(_0x77ac25){return _0x22db41[_0x06ea('0x15')](_0x17b524);}return _0x22db41[_0x06ea('0x16')](_0x17b524)[_0x06ea('0x17')]();};}function respondWithResult(_0x4fb2fd,_0x23ebac){_0x23ebac=_0x23ebac||0xc8;return function(_0x2ad738){if(_0x2ad738){return _0x4fb2fd['status'](_0x23ebac)[_0x06ea('0x18')](_0x2ad738);}};}function respondWithFilteredResult(_0x4ee43c,_0x5efbd7){return function(_0xd95e6e){if(_0xd95e6e){var _0x3ece16=typeof _0x5efbd7['offset']==='undefined'&&typeof _0x5efbd7['limit']===_0x06ea('0x19');var _0x7ca5cf=_0xd95e6e[_0x06ea('0x1a')];var _0x4b08ce=_0x3ece16?0x0:_0x5efbd7[_0x06ea('0x1b')];var _0x379ea3=_0x3ece16?_0xd95e6e[_0x06ea('0x1a')]:_0x5efbd7[_0x06ea('0x1b')]+_0x5efbd7[_0x06ea('0x1c')];var _0x49f13b;if(_0x379ea3>=_0x7ca5cf){_0x379ea3=_0x7ca5cf;_0x49f13b=0xc8;}else{_0x49f13b=0xce;}_0x4ee43c['status'](_0x49f13b);return _0x4ee43c['set'](_0x06ea('0x1d'),_0x4b08ce+'-'+_0x379ea3+'/'+_0x7ca5cf)['json'](_0xd95e6e);}return null;};}function patchUpdates(_0x6c795a){return function(_0x45f5ad){try{jsonpatch[_0x06ea('0x1e')](_0x45f5ad,_0x6c795a,!![]);}catch(_0x3d99c4){return BPromise[_0x06ea('0x1f')](_0x3d99c4);}return _0x45f5ad[_0x06ea('0x20')]();};}function saveUpdates(_0x509c26,_0x57b9c5){return function(_0x1e880b){if(_0x1e880b){return _0x1e880b[_0x06ea('0x21')](_0x509c26)[_0x06ea('0x22')](function(_0x1eba6e){return _0x1eba6e;});}return null;};}function removeEntity(_0x3b26ea,_0x1f1c7f){return function(_0x383c61){if(_0x383c61){return _0x383c61['destroy']()[_0x06ea('0x22')](function(){_0x3b26ea[_0x06ea('0x16')](0xcc)[_0x06ea('0x17')]();});}};}function handleEntityNotFound(_0x5b9ff8,_0x45d827){return function(_0x445f3e){if(!_0x445f3e){_0x5b9ff8[_0x06ea('0x15')](0x194);}return _0x445f3e;};}function handleError(_0x2cf596,_0x52a416){_0x52a416=_0x52a416||0x1f4;return function(_0xb24f66){logger['error'](_0xb24f66[_0x06ea('0x23')]);if(_0xb24f66['name']){delete _0xb24f66[_0x06ea('0x24')];}_0x2cf596[_0x06ea('0x16')](_0x52a416)['send'](_0xb24f66);};}exports[_0x06ea('0x25')]=function(_0x312b12,_0x5065a8){var _0x51a143={},_0x2b38b8={},_0x239c1d={'count':0x0,'rows':[]};var _0x4f9d20=_[_0x06ea('0x26')](db[_0x06ea('0x27')][_0x06ea('0x28')],function(_0x27b114){return{'name':_0x27b114['fieldName'],'type':_0x27b114['type'][_0x06ea('0x29')]};});_0x2b38b8[_0x06ea('0x2a')]=_[_0x06ea('0x26')](_0x4f9d20,_0x06ea('0x24'));_0x2b38b8['query']=_['keys'](_0x312b12[_0x06ea('0x2b')]);_0x2b38b8[_0x06ea('0x2c')]=_[_0x06ea('0x2d')](_0x2b38b8[_0x06ea('0x2a')],_0x2b38b8['query']);_0x51a143[_0x06ea('0x2e')]=_[_0x06ea('0x2d')](_0x2b38b8[_0x06ea('0x2a')],qs[_0x06ea('0x2f')](_0x312b12[_0x06ea('0x2b')][_0x06ea('0x2f')]));_0x51a143[_0x06ea('0x2e')]=_0x51a143['attributes'][_0x06ea('0x30')]?_0x51a143[_0x06ea('0x2e')]:_0x2b38b8[_0x06ea('0x2a')];if(!_0x312b12['query']['hasOwnProperty'](_0x06ea('0x31'))){_0x51a143[_0x06ea('0x1c')]=qs[_0x06ea('0x1c')](_0x312b12[_0x06ea('0x2b')][_0x06ea('0x1c')]);_0x51a143[_0x06ea('0x1b')]=qs[_0x06ea('0x1b')](_0x312b12[_0x06ea('0x2b')]['offset']);}_0x51a143[_0x06ea('0x32')]=qs[_0x06ea('0x33')](_0x312b12['query'][_0x06ea('0x33')]);_0x51a143['where']=qs[_0x06ea('0x2c')](_[_0x06ea('0x34')](_0x312b12['query'],_0x2b38b8[_0x06ea('0x2c')]),_0x4f9d20);if(_0x312b12[_0x06ea('0x2b')][_0x06ea('0x35')]){_0x51a143[_0x06ea('0x36')]=_[_0x06ea('0x37')](_0x51a143[_0x06ea('0x36')],{'$or':_[_0x06ea('0x26')](_0x4f9d20,function(_0xc72215){if(_0xc72215[_0x06ea('0x38')]!==_0x06ea('0x39')){var _0x47c7a9={};_0x47c7a9[_0xc72215[_0x06ea('0x24')]]={'$like':'%'+_0x312b12[_0x06ea('0x2b')][_0x06ea('0x35')]+'%'};return _0x47c7a9;}})});}_0x51a143=_[_0x06ea('0x37')]({},_0x51a143,_0x312b12['options']);var _0x22c940={'where':_0x51a143[_0x06ea('0x36')]};return db['SalesforceAccount'][_0x06ea('0x1a')](_0x22c940)[_0x06ea('0x22')](function(_0x4f078c){_0x239c1d[_0x06ea('0x1a')]=_0x4f078c;if(_0x312b12[_0x06ea('0x2b')][_0x06ea('0x3a')]){_0x51a143['include']=[{'all':!![]}];}return db[_0x06ea('0x27')][_0x06ea('0x3b')](_0x51a143);})['then'](function(_0x21a75d){_0x239c1d[_0x06ea('0x3c')]=_0x21a75d;return _0x239c1d;})[_0x06ea('0x22')](respondWithFilteredResult(_0x5065a8,_0x51a143))['catch'](handleError(_0x5065a8,null));};exports[_0x06ea('0x3d')]=function(_0x416a39,_0x360011){var _0x944e67={'raw':![],'where':{'id':_0x416a39[_0x06ea('0x3e')]['id']}},_0xe6dbdf={};_0xe6dbdf[_0x06ea('0x2a')]=_['keys'](db['SalesforceAccount'][_0x06ea('0x28')]);_0xe6dbdf['query']=_['keys'](_0x416a39[_0x06ea('0x2b')]);_0xe6dbdf[_0x06ea('0x2c')]=_[_0x06ea('0x2d')](_0xe6dbdf[_0x06ea('0x2a')],_0xe6dbdf[_0x06ea('0x2b')]);_0x944e67[_0x06ea('0x2e')]=_['intersection'](_0xe6dbdf[_0x06ea('0x2a')],qs[_0x06ea('0x2f')](_0x416a39['query'][_0x06ea('0x2f')]));_0x944e67[_0x06ea('0x2e')]=_0x944e67[_0x06ea('0x2e')][_0x06ea('0x30')]?_0x944e67['attributes']:_0xe6dbdf[_0x06ea('0x2a')];if(_0x416a39[_0x06ea('0x2b')][_0x06ea('0x3a')]){_0x944e67['include']=[{'all':!![]}];}_0x944e67=_[_0x06ea('0x37')]({},_0x944e67,_0x416a39[_0x06ea('0x3f')]);return db[_0x06ea('0x27')][_0x06ea('0x40')](_0x944e67)[_0x06ea('0x22')](handleEntityNotFound(_0x360011,null))[_0x06ea('0x22')](respondWithResult(_0x360011,null))[_0x06ea('0x41')](handleError(_0x360011,null));};exports[_0x06ea('0x42')]=function(_0x5edb80,_0x3acdbf){return db['SalesforceAccount'][_0x06ea('0x42')](_0x5edb80['body'],{})['then'](respondWithResult(_0x3acdbf,0xc9))[_0x06ea('0x41')](handleError(_0x3acdbf,null));};exports[_0x06ea('0x21')]=function(_0x39e20f,_0x477c93){if(_0x39e20f[_0x06ea('0x43')]['id']){delete _0x39e20f[_0x06ea('0x43')]['id'];}return db[_0x06ea('0x27')][_0x06ea('0x40')]({'where':{'id':_0x39e20f[_0x06ea('0x3e')]['id']}})[_0x06ea('0x22')](handleEntityNotFound(_0x477c93,null))[_0x06ea('0x22')](saveUpdates(_0x39e20f[_0x06ea('0x43')],null))[_0x06ea('0x22')](respondWithResult(_0x477c93,null))[_0x06ea('0x41')](handleError(_0x477c93,null));};exports[_0x06ea('0x44')]=function(_0x1cfdb8,_0x427a40){return db[_0x06ea('0x27')][_0x06ea('0x40')]({'where':{'id':_0x1cfdb8['params']['id']}})[_0x06ea('0x22')](handleEntityNotFound(_0x427a40,null))['then'](removeEntity(_0x427a40,null))[_0x06ea('0x41')](handleError(_0x427a40,null));};exports['getConfigurations']=function(_0xed3195,_0x1e8cac,_0x2c466e){var _0x511f2e={};var _0x38a7e3={};var _0x1619fc;var _0x54dffe;return db[_0x06ea('0x27')][_0x06ea('0x45')]({'where':{'id':_0xed3195[_0x06ea('0x3e')]['id']}})[_0x06ea('0x22')](handleEntityNotFound(_0x1e8cac,null))[_0x06ea('0x22')](function(_0x18b708){if(_0x18b708){_0x1619fc=_0x18b708;_0x38a7e3['model']=_[_0x06ea('0x46')](db[_0x06ea('0x47')]['rawAttributes']);_0x38a7e3['query']=_['keys'](_0xed3195[_0x06ea('0x2b')]);_0x38a7e3['filters']=_[_0x06ea('0x2d')](_0x38a7e3[_0x06ea('0x2a')],_0x38a7e3[_0x06ea('0x2b')]);_0x511f2e['attributes']=_[_0x06ea('0x2d')](_0x38a7e3[_0x06ea('0x2a')],qs[_0x06ea('0x2f')](_0xed3195[_0x06ea('0x2b')]['fields']));_0x511f2e[_0x06ea('0x2e')]=_0x511f2e[_0x06ea('0x2e')][_0x06ea('0x30')]?_0x511f2e[_0x06ea('0x2e')]:_0x38a7e3[_0x06ea('0x2a')];_0x511f2e['order']=qs[_0x06ea('0x33')](_0xed3195[_0x06ea('0x2b')]['sort']);_0x511f2e[_0x06ea('0x36')]=qs['filters'](_[_0x06ea('0x34')](_0xed3195[_0x06ea('0x2b')],_0x38a7e3[_0x06ea('0x2c')]));if(_0xed3195[_0x06ea('0x2b')][_0x06ea('0x35')]){_0x511f2e['where']=_[_0x06ea('0x37')](_0x511f2e[_0x06ea('0x36')],{'$or':_['map'](_0x511f2e[_0x06ea('0x2e')],function(_0x5c3e80){var _0x110cd3={};_0x110cd3[_0x5c3e80]={'$like':'%'+_0xed3195[_0x06ea('0x2b')]['filter']+'%'};return _0x110cd3;})});}_0x511f2e=_[_0x06ea('0x37')]({},_0x511f2e,_0xed3195[_0x06ea('0x3f')]);return _0x1619fc[_0x06ea('0x48')](_0x511f2e);}})[_0x06ea('0x22')](function(_0x186ad6){if(_0x186ad6){_0x54dffe=_0x186ad6[_0x06ea('0x30')];if(!_0xed3195['query'][_0x06ea('0x49')](_0x06ea('0x31'))){_0x511f2e['limit']=qs[_0x06ea('0x1c')](_0xed3195[_0x06ea('0x2b')]['limit']);_0x511f2e[_0x06ea('0x1b')]=qs[_0x06ea('0x1b')](_0xed3195[_0x06ea('0x2b')][_0x06ea('0x1b')]);}return _0x1619fc[_0x06ea('0x48')](_0x511f2e);}})['then'](function(_0x40dcdb){if(_0x40dcdb){return _0x40dcdb?{'count':_0x54dffe,'rows':_0x40dcdb}:null;}})[_0x06ea('0x22')](respondWithResult(_0x1e8cac,null))[_0x06ea('0x41')](handleError(_0x1e8cac,null));};exports[_0x06ea('0x4a')]=function(_0x262e7e,_0x763c7d,_0x41e57b){if(_0x262e7e[_0x06ea('0x43')]['id']){delete _0x262e7e[_0x06ea('0x43')]['id'];}return db[_0x06ea('0x27')][_0x06ea('0x45')]({'where':{'id':_0x262e7e[_0x06ea('0x3e')]['id']}})[_0x06ea('0x22')](handleEntityNotFound(_0x763c7d,null))['then'](function(_0x432c3a){if(_0x432c3a){_0x262e7e['body'][_0x06ea('0x4b')]=_0x432c3a['id'];_0x262e7e['body'][_0x06ea('0x4c')]=integrations[_0x06ea('0x4d')](_0x262e7e[_0x06ea('0x43')][_0x06ea('0x4e')],_0x262e7e['body'][_0x06ea('0x38')]);_0x262e7e[_0x06ea('0x43')][_0x06ea('0x4f')]=integrations[_0x06ea('0x50')](_0x262e7e[_0x06ea('0x43')][_0x06ea('0x4e')],_0x262e7e[_0x06ea('0x43')][_0x06ea('0x38')]);return db['SalesforceConfiguration'][_0x06ea('0x42')](_0x262e7e[_0x06ea('0x43')],{'include':[{'model':db[_0x06ea('0x51')],'as':_0x06ea('0x4c')},{'model':db[_0x06ea('0x51')],'as':_0x06ea('0x4f')}]});}return null;})['then'](respondWithResult(_0x763c7d,null))[_0x06ea('0x41')](handleError(_0x763c7d,null));};exports[_0x06ea('0x52')]=function(_0x17cf35,_0x554424,_0x3854cd){var _0x3e889e;var _0x5bb681='';var _0x3ee3f1=_0x06ea('0x53');return db[_0x06ea('0x27')][_0x06ea('0x45')]({'where':{'id':_0x17cf35[_0x06ea('0x3e')]['id']},'attributes':['id',_0x06ea('0x54'),_0x06ea('0x55'),_0x06ea('0x56'),_0x06ea('0x57'),_0x06ea('0x58'),_0x06ea('0x59')]})[_0x06ea('0x22')](handleEntityNotFound(_0x554424,null))['then'](function(_0x518854){if(_0x518854){_0x5bb681=_0x518854[_0x06ea('0x54')];var _0x1df750=_0x5bb681[_0x06ea('0x5a')](-0x1);if(_0x1df750==='/'){_0x5bb681=_0x5bb681[_0x06ea('0x5b')](0x0,_0x5bb681[_0x06ea('0x5c')](_0x1df750));}_0x3e889e=new jsforce['Connection']({'oauth2':{'loginUrl':_0x5bb681,'clientId':_0x518854[_0x06ea('0x55')],'clientSecret':_0x518854[_0x06ea('0x56')]}});return _0x3e889e[_0x06ea('0x5d')](_0x518854[_0x06ea('0x57')],_0x518854[_0x06ea('0x58')][_0x06ea('0x5e')](_0x518854[_0x06ea('0x59')]));}})['then'](function(_0x235c86){if(_0x235c86){if(!_[_0x06ea('0x5f')](_0x17cf35[_0x06ea('0x2b')][_0x06ea('0x60')])){_0x3ee3f1=_0x17cf35['query'][_0x06ea('0x60')];}return _0x3e889e[_0x06ea('0x61')](_0x3ee3f1)['describe']();}})[_0x06ea('0x22')](function(_0x1f7c3f){var _0x350515=[_0x06ea('0x62'),_0x06ea('0x63'),'IsReminderSet','IsRecurrence',_0x06ea('0x64'),_0x06ea('0x65')];var _0x7b17a7=['string','int','picklist','boolean',_0x06ea('0x66'),_0x06ea('0x67'),_0x06ea('0x68')];if(_0x1f7c3f){_[_0x06ea('0x69')](_0x1f7c3f[_0x06ea('0x2f')],function(_0xe0f923){return _0x350515[_0x06ea('0x6a')](_0xe0f923[_0x06ea('0x24')])||!_0x7b17a7[_0x06ea('0x6a')](_0xe0f923[_0x06ea('0x38')]);});return{'count':_0x1f7c3f[_0x06ea('0x2f')][_0x06ea('0x30')],'rows':_[_0x06ea('0x26')](_0x1f7c3f[_0x06ea('0x2f')],function(_0x390ed2){return{'id':_0x390ed2[_0x06ea('0x24')],'name':_0x390ed2['label'],'custom':_0x390ed2[_0x06ea('0x6b')],'options':_0x390ed2[_0x06ea('0x6c')][_0x06ea('0x30')]>0x0?_[_0x06ea('0x26')](_0x390ed2['picklistValues'],function(_0x2b0e97){return{'name':_0x2b0e97[_0x06ea('0x6d')],'value':_0x2b0e97[_0x06ea('0x6e')]};}):_0x390ed2['type']==_0x06ea('0x6f')?[{'name':'True','value':_0x06ea('0x70')},{'name':_0x06ea('0x71'),'value':_0x06ea('0x72')}]:[]};})};}})[_0x06ea('0x22')](respondWithResult(_0x554424,null))[_0x06ea('0x41')](function(_0x1aaafa){var _0x340b90=_0x17cf35[_0x06ea('0x2b')][_0x06ea('0x73')]?0x1f4:_0x1aaafa['statusCode']||0x1f4;logger['error']('getFields,\x20%s,\x20%s,\x20%s',_0x06ea('0x52'),_0x340b90,JSON['stringify'](_0x1aaafa));delete _0x1aaafa['name'];if(_0x340b90===0x191){_0x340b90=0x190;}_0x554424[_0x06ea('0x16')](_0x340b90)['send'](_0x17cf35[_0x06ea('0x2b')][_0x06ea('0x73')]?{'message':'Wrong\x20credentials','statusCode':_0x1aaafa['statusCode']}:_0x1aaafa);});};