26d2aa99442ad4b8d4914b528a5f1ee3fd2b0e81
[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 _0xb5fd=['body','getConfigurations','findOne','SalesforceConfiguration','order','AccountId','getSubjects','channel','Descriptions','getDescriptions','SalesforceField','getFields','remoteUri','clientId','username','password','slice','substring','Connection','login','concat','isNil','ticketType','sobject','describe','OwnerId','ActivityDate','IsReminderSet','IsRecurrence','Description','string','int','picklist','boolean','email','textarea','phone','remove','includes','label','custom','picklistValues','value','False','false','statusCode','getFields,\x20%s,\x20%s,\x20%s','stringify','Wrong\x20credentials','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','to-csv','ejs','fs-extra','lodash','crypto','jsforce','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','../../components/integrations/configuration','sendStatus','end','status','json','undefined','limit','count','offset','set','Content-Range','apply','save','destroy','then','error','stack','name','send','index','map','SalesforceAccount','rawAttributes','type','key','keys','query','filters','model','attributes','intersection','fields','length','hasOwnProperty','nolimit','sort','pick','where','merge','VIRTUAL','filter','options','findAll','catch','show','params','include','find','create'];(function(_0x6805bc,_0x55aeab){var _0x212f64=function(_0x41c889){while(--_0x41c889){_0x6805bc['push'](_0x6805bc['shift']());}};_0x212f64(++_0x55aeab);}(_0xb5fd,0xa9));var _0xdb5f=function(_0x3fa398,_0x23fddd){_0x3fa398=_0x3fa398-0x0;var _0x33377d=_0xb5fd[_0x3fa398];return _0x33377d;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xdb5f('0x0'));var zipdir=require(_0xdb5f('0x1'));var jsonpatch=require(_0xdb5f('0x2'));var rp=require('request-promise');var moment=require(_0xdb5f('0x3'));var BPromise=require(_0xdb5f('0x4'));var Mustache=require(_0xdb5f('0x5'));var util=require(_0xdb5f('0x6'));var path=require('path');var sox=require('sox');var csv=require(_0xdb5f('0x7'));var ejs=require(_0xdb5f('0x8'));var fs=require('fs');var fs_extra=require(_0xdb5f('0x9'));var _=require(_0xdb5f('0xa'));var squel=require('squel');var crypto=require(_0xdb5f('0xb'));var jsforce=require(_0xdb5f('0xc'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0xdb5f('0xd'));var authService=require('../../components/auth/service');var qs=require(_0xdb5f('0xe'));var as=require(_0xdb5f('0xf'));var hardwareService=require(_0xdb5f('0x10'));var logger=require(_0xdb5f('0x11'))(_0xdb5f('0x12'));var utils=require(_0xdb5f('0x13'));var config=require(_0xdb5f('0x14'));var licenseUtil=require('../../config/license/util');var db=require(_0xdb5f('0x15'))['db'];var integrations=require(_0xdb5f('0x16'));function respondWithStatusCode(_0x2edab2,_0x3f7d7f){_0x3f7d7f=_0x3f7d7f||0xcc;return function(_0x1d85e2){if(_0x1d85e2){return _0x2edab2[_0xdb5f('0x17')](_0x3f7d7f);}return _0x2edab2['status'](_0x3f7d7f)[_0xdb5f('0x18')]();};}function respondWithResult(_0x1802dc,_0x53b5a8){_0x53b5a8=_0x53b5a8||0xc8;return function(_0x5bbdd4){if(_0x5bbdd4){return _0x1802dc[_0xdb5f('0x19')](_0x53b5a8)[_0xdb5f('0x1a')](_0x5bbdd4);}};}function respondWithFilteredResult(_0x1a19f0,_0x6ea5a){return function(_0x4ec5c8){if(_0x4ec5c8){var _0x4dc239=typeof _0x6ea5a['offset']===_0xdb5f('0x1b')&&typeof _0x6ea5a[_0xdb5f('0x1c')]===_0xdb5f('0x1b');var _0x563384=_0x4ec5c8[_0xdb5f('0x1d')];var _0x5092c7=_0x4dc239?0x0:_0x6ea5a[_0xdb5f('0x1e')];var _0x3ee08b=_0x4dc239?_0x4ec5c8[_0xdb5f('0x1d')]:_0x6ea5a[_0xdb5f('0x1e')]+_0x6ea5a[_0xdb5f('0x1c')];var _0x1c2be0;if(_0x3ee08b>=_0x563384){_0x3ee08b=_0x563384;_0x1c2be0=0xc8;}else{_0x1c2be0=0xce;}_0x1a19f0[_0xdb5f('0x19')](_0x1c2be0);return _0x1a19f0[_0xdb5f('0x1f')](_0xdb5f('0x20'),_0x5092c7+'-'+_0x3ee08b+'/'+_0x563384)[_0xdb5f('0x1a')](_0x4ec5c8);}return null;};}function patchUpdates(_0x5a0807){return function(_0x4ad4a8){try{jsonpatch[_0xdb5f('0x21')](_0x4ad4a8,_0x5a0807,!![]);}catch(_0x56184d){return BPromise['reject'](_0x56184d);}return _0x4ad4a8[_0xdb5f('0x22')]();};}function saveUpdates(_0x3a0114,_0x5813ea){return function(_0x58b151){if(_0x58b151){return _0x58b151['update'](_0x3a0114)['then'](function(_0x55d9f6){return _0x55d9f6;});}return null;};}function removeEntity(_0x5a9ccc,_0x1f84bb){return function(_0x157290){if(_0x157290){return _0x157290[_0xdb5f('0x23')]()[_0xdb5f('0x24')](function(){_0x5a9ccc[_0xdb5f('0x19')](0xcc)[_0xdb5f('0x18')]();});}};}function handleEntityNotFound(_0x52399b,_0x73e189){return function(_0x41a222){if(!_0x41a222){_0x52399b[_0xdb5f('0x17')](0x194);}return _0x41a222;};}function handleError(_0x43277a,_0x30161){_0x30161=_0x30161||0x1f4;return function(_0x5dcf14){logger[_0xdb5f('0x25')](_0x5dcf14[_0xdb5f('0x26')]);if(_0x5dcf14['name']){delete _0x5dcf14[_0xdb5f('0x27')];}_0x43277a[_0xdb5f('0x19')](_0x30161)[_0xdb5f('0x28')](_0x5dcf14);};}exports[_0xdb5f('0x29')]=function(_0x10523c,_0x345f40){var _0x4c88ca={},_0x373d9d={},_0x5b30f3={'count':0x0,'rows':[]};var _0x15b445=_[_0xdb5f('0x2a')](db[_0xdb5f('0x2b')][_0xdb5f('0x2c')],function(_0x5579db){return{'name':_0x5579db['fieldName'],'type':_0x5579db[_0xdb5f('0x2d')][_0xdb5f('0x2e')]};});_0x373d9d['model']=_[_0xdb5f('0x2a')](_0x15b445,_0xdb5f('0x27'));_0x373d9d['query']=_[_0xdb5f('0x2f')](_0x10523c[_0xdb5f('0x30')]);_0x373d9d[_0xdb5f('0x31')]=_['intersection'](_0x373d9d[_0xdb5f('0x32')],_0x373d9d[_0xdb5f('0x30')]);_0x4c88ca[_0xdb5f('0x33')]=_[_0xdb5f('0x34')](_0x373d9d[_0xdb5f('0x32')],qs[_0xdb5f('0x35')](_0x10523c[_0xdb5f('0x30')][_0xdb5f('0x35')]));_0x4c88ca[_0xdb5f('0x33')]=_0x4c88ca[_0xdb5f('0x33')][_0xdb5f('0x36')]?_0x4c88ca[_0xdb5f('0x33')]:_0x373d9d[_0xdb5f('0x32')];if(!_0x10523c['query'][_0xdb5f('0x37')](_0xdb5f('0x38'))){_0x4c88ca[_0xdb5f('0x1c')]=qs['limit'](_0x10523c[_0xdb5f('0x30')]['limit']);_0x4c88ca['offset']=qs['offset'](_0x10523c['query'][_0xdb5f('0x1e')]);}_0x4c88ca['order']=qs[_0xdb5f('0x39')](_0x10523c[_0xdb5f('0x30')][_0xdb5f('0x39')]);_0x4c88ca['where']=qs['filters'](_[_0xdb5f('0x3a')](_0x10523c[_0xdb5f('0x30')],_0x373d9d[_0xdb5f('0x31')]),_0x15b445);if(_0x10523c[_0xdb5f('0x30')]['filter']){_0x4c88ca[_0xdb5f('0x3b')]=_[_0xdb5f('0x3c')](_0x4c88ca[_0xdb5f('0x3b')],{'$or':_[_0xdb5f('0x2a')](_0x15b445,function(_0xec746){if(_0xec746[_0xdb5f('0x2d')]!==_0xdb5f('0x3d')){var _0x3cce5f={};_0x3cce5f[_0xec746[_0xdb5f('0x27')]]={'$like':'%'+_0x10523c[_0xdb5f('0x30')][_0xdb5f('0x3e')]+'%'};return _0x3cce5f;}})});}_0x4c88ca=_['merge']({},_0x4c88ca,_0x10523c[_0xdb5f('0x3f')]);var _0x5bf809={'where':_0x4c88ca[_0xdb5f('0x3b')]};return db['SalesforceAccount'][_0xdb5f('0x1d')](_0x5bf809)[_0xdb5f('0x24')](function(_0x40dece){_0x5b30f3[_0xdb5f('0x1d')]=_0x40dece;if(_0x10523c[_0xdb5f('0x30')]['includeAll']){_0x4c88ca['include']=[{'all':!![]}];}return db[_0xdb5f('0x2b')][_0xdb5f('0x40')](_0x4c88ca);})[_0xdb5f('0x24')](function(_0x1fc921){_0x5b30f3['rows']=_0x1fc921;return _0x5b30f3;})[_0xdb5f('0x24')](respondWithFilteredResult(_0x345f40,_0x4c88ca))[_0xdb5f('0x41')](handleError(_0x345f40,null));};exports[_0xdb5f('0x42')]=function(_0x2dbde4,_0x4efba6){var _0x133ef3={'raw':![],'where':{'id':_0x2dbde4[_0xdb5f('0x43')]['id']}},_0x586f6b={};_0x586f6b[_0xdb5f('0x32')]=_[_0xdb5f('0x2f')](db[_0xdb5f('0x2b')][_0xdb5f('0x2c')]);_0x586f6b[_0xdb5f('0x30')]=_[_0xdb5f('0x2f')](_0x2dbde4[_0xdb5f('0x30')]);_0x586f6b[_0xdb5f('0x31')]=_[_0xdb5f('0x34')](_0x586f6b[_0xdb5f('0x32')],_0x586f6b[_0xdb5f('0x30')]);_0x133ef3[_0xdb5f('0x33')]=_[_0xdb5f('0x34')](_0x586f6b[_0xdb5f('0x32')],qs[_0xdb5f('0x35')](_0x2dbde4[_0xdb5f('0x30')][_0xdb5f('0x35')]));_0x133ef3[_0xdb5f('0x33')]=_0x133ef3[_0xdb5f('0x33')][_0xdb5f('0x36')]?_0x133ef3['attributes']:_0x586f6b[_0xdb5f('0x32')];if(_0x2dbde4[_0xdb5f('0x30')]['includeAll']){_0x133ef3[_0xdb5f('0x44')]=[{'all':!![]}];}_0x133ef3=_[_0xdb5f('0x3c')]({},_0x133ef3,_0x2dbde4[_0xdb5f('0x3f')]);return db['SalesforceAccount'][_0xdb5f('0x45')](_0x133ef3)[_0xdb5f('0x24')](handleEntityNotFound(_0x4efba6,null))[_0xdb5f('0x24')](respondWithResult(_0x4efba6,null))['catch'](handleError(_0x4efba6,null));};exports[_0xdb5f('0x46')]=function(_0x3ecab8,_0x124db5){return db['SalesforceAccount']['create'](_0x3ecab8[_0xdb5f('0x47')],{})[_0xdb5f('0x24')](respondWithResult(_0x124db5,0xc9))[_0xdb5f('0x41')](handleError(_0x124db5,null));};exports['update']=function(_0x37a767,_0x293c8d){if(_0x37a767['body']['id']){delete _0x37a767[_0xdb5f('0x47')]['id'];}return db[_0xdb5f('0x2b')][_0xdb5f('0x45')]({'where':{'id':_0x37a767[_0xdb5f('0x43')]['id']}})['then'](handleEntityNotFound(_0x293c8d,null))[_0xdb5f('0x24')](saveUpdates(_0x37a767[_0xdb5f('0x47')],null))[_0xdb5f('0x24')](respondWithResult(_0x293c8d,null))['catch'](handleError(_0x293c8d,null));};exports['destroy']=function(_0x558e14,_0x27f618){return db[_0xdb5f('0x2b')][_0xdb5f('0x45')]({'where':{'id':_0x558e14['params']['id']}})[_0xdb5f('0x24')](handleEntityNotFound(_0x27f618,null))['then'](removeEntity(_0x27f618,null))[_0xdb5f('0x41')](handleError(_0x27f618,null));};exports[_0xdb5f('0x48')]=function(_0x618e21,_0x2735b3,_0x37d073){var _0x4b12ad={};var _0x51a041={};var _0x1ca928;var _0x24efd2;return db['SalesforceAccount'][_0xdb5f('0x49')]({'where':{'id':_0x618e21[_0xdb5f('0x43')]['id']}})[_0xdb5f('0x24')](handleEntityNotFound(_0x2735b3,null))[_0xdb5f('0x24')](function(_0x32e4e9){if(_0x32e4e9){_0x1ca928=_0x32e4e9;_0x51a041['model']=_[_0xdb5f('0x2f')](db[_0xdb5f('0x4a')]['rawAttributes']);_0x51a041[_0xdb5f('0x30')]=_[_0xdb5f('0x2f')](_0x618e21[_0xdb5f('0x30')]);_0x51a041[_0xdb5f('0x31')]=_[_0xdb5f('0x34')](_0x51a041['model'],_0x51a041['query']);_0x4b12ad[_0xdb5f('0x33')]=_[_0xdb5f('0x34')](_0x51a041[_0xdb5f('0x32')],qs[_0xdb5f('0x35')](_0x618e21[_0xdb5f('0x30')]['fields']));_0x4b12ad[_0xdb5f('0x33')]=_0x4b12ad[_0xdb5f('0x33')][_0xdb5f('0x36')]?_0x4b12ad[_0xdb5f('0x33')]:_0x51a041[_0xdb5f('0x32')];_0x4b12ad[_0xdb5f('0x4b')]=qs['sort'](_0x618e21[_0xdb5f('0x30')][_0xdb5f('0x39')]);_0x4b12ad[_0xdb5f('0x3b')]=qs['filters'](_[_0xdb5f('0x3a')](_0x618e21['query'],_0x51a041[_0xdb5f('0x31')]));if(_0x618e21[_0xdb5f('0x30')][_0xdb5f('0x3e')]){_0x4b12ad[_0xdb5f('0x3b')]=_[_0xdb5f('0x3c')](_0x4b12ad[_0xdb5f('0x3b')],{'$or':_[_0xdb5f('0x2a')](_0x4b12ad[_0xdb5f('0x33')],function(_0x17c40d){var _0x1e8a16={};_0x1e8a16[_0x17c40d]={'$like':'%'+_0x618e21[_0xdb5f('0x30')][_0xdb5f('0x3e')]+'%'};return _0x1e8a16;})});}_0x4b12ad=_[_0xdb5f('0x3c')]({},_0x4b12ad,_0x618e21[_0xdb5f('0x3f')]);return _0x1ca928[_0xdb5f('0x48')](_0x4b12ad);}})[_0xdb5f('0x24')](function(_0x4f00e0){if(_0x4f00e0){_0x24efd2=_0x4f00e0[_0xdb5f('0x36')];if(!_0x618e21[_0xdb5f('0x30')][_0xdb5f('0x37')]('nolimit')){_0x4b12ad[_0xdb5f('0x1c')]=qs[_0xdb5f('0x1c')](_0x618e21[_0xdb5f('0x30')][_0xdb5f('0x1c')]);_0x4b12ad[_0xdb5f('0x1e')]=qs[_0xdb5f('0x1e')](_0x618e21['query'][_0xdb5f('0x1e')]);}return _0x1ca928[_0xdb5f('0x48')](_0x4b12ad);}})[_0xdb5f('0x24')](function(_0x23205d){if(_0x23205d){return _0x23205d?{'count':_0x24efd2,'rows':_0x23205d}:null;}})[_0xdb5f('0x24')](respondWithResult(_0x2735b3,null))[_0xdb5f('0x41')](handleError(_0x2735b3,null));};exports['addConfiguration']=function(_0x232d97,_0x1608c4,_0x3e769f){if(_0x232d97[_0xdb5f('0x47')]['id']){delete _0x232d97[_0xdb5f('0x47')]['id'];}return db[_0xdb5f('0x2b')]['findOne']({'where':{'id':_0x232d97[_0xdb5f('0x43')]['id']}})[_0xdb5f('0x24')](handleEntityNotFound(_0x1608c4,null))[_0xdb5f('0x24')](function(_0x44dfb2){if(_0x44dfb2){_0x232d97[_0xdb5f('0x47')][_0xdb5f('0x4c')]=_0x44dfb2['id'];_0x232d97['body']['Subjects']=integrations[_0xdb5f('0x4d')](_0x232d97[_0xdb5f('0x47')][_0xdb5f('0x4e')],_0x232d97[_0xdb5f('0x47')][_0xdb5f('0x2d')]);_0x232d97[_0xdb5f('0x47')][_0xdb5f('0x4f')]=integrations[_0xdb5f('0x50')](_0x232d97[_0xdb5f('0x47')][_0xdb5f('0x4e')],_0x232d97[_0xdb5f('0x47')]['type']);return db[_0xdb5f('0x4a')][_0xdb5f('0x46')](_0x232d97['body'],{'include':[{'model':db[_0xdb5f('0x51')],'as':'Subjects'},{'model':db[_0xdb5f('0x51')],'as':_0xdb5f('0x4f')}]});}return null;})[_0xdb5f('0x24')](respondWithResult(_0x1608c4,null))[_0xdb5f('0x41')](handleError(_0x1608c4,null));};exports[_0xdb5f('0x52')]=function(_0x41077f,_0x1e32c1,_0x22e37b){var _0x53dd85;var _0x58beed='';var _0x5b2d5c='Task';return db[_0xdb5f('0x2b')][_0xdb5f('0x49')]({'where':{'id':_0x41077f[_0xdb5f('0x43')]['id']},'attributes':['id',_0xdb5f('0x53'),_0xdb5f('0x54'),'clientSecret',_0xdb5f('0x55'),_0xdb5f('0x56'),'securityToken']})['then'](handleEntityNotFound(_0x1e32c1,null))[_0xdb5f('0x24')](function(_0x55332b){if(_0x55332b){_0x58beed=_0x55332b['remoteUri'];var _0x52f651=_0x58beed[_0xdb5f('0x57')](-0x1);if(_0x52f651==='/'){_0x58beed=_0x58beed[_0xdb5f('0x58')](0x0,_0x58beed['lastIndexOf'](_0x52f651));}_0x53dd85=new jsforce[(_0xdb5f('0x59'))]({'oauth2':{'loginUrl':_0x58beed,'clientId':_0x55332b[_0xdb5f('0x54')],'clientSecret':_0x55332b['clientSecret']}});return _0x53dd85[_0xdb5f('0x5a')](_0x55332b[_0xdb5f('0x55')],_0x55332b[_0xdb5f('0x56')][_0xdb5f('0x5b')](_0x55332b['securityToken']));}})[_0xdb5f('0x24')](function(_0x12ba9a){if(_0x12ba9a){if(!_[_0xdb5f('0x5c')](_0x41077f['query'][_0xdb5f('0x5d')])){_0x5b2d5c=_0x41077f[_0xdb5f('0x30')][_0xdb5f('0x5d')];}return _0x53dd85[_0xdb5f('0x5e')](_0x5b2d5c)[_0xdb5f('0x5f')]();}})[_0xdb5f('0x24')](function(_0x35e793){var _0x1c3aa3=[_0xdb5f('0x60'),_0xdb5f('0x61'),_0xdb5f('0x62'),_0xdb5f('0x63'),'Subject',_0xdb5f('0x64')];var _0x8e2d73=[_0xdb5f('0x65'),_0xdb5f('0x66'),_0xdb5f('0x67'),_0xdb5f('0x68'),_0xdb5f('0x69'),_0xdb5f('0x6a'),_0xdb5f('0x6b')];if(_0x35e793){_[_0xdb5f('0x6c')](_0x35e793[_0xdb5f('0x35')],function(_0x49a480){return _0x1c3aa3[_0xdb5f('0x6d')](_0x49a480['name'])||!_0x8e2d73[_0xdb5f('0x6d')](_0x49a480[_0xdb5f('0x2d')]);});return{'count':_0x35e793[_0xdb5f('0x35')]['length'],'rows':_[_0xdb5f('0x2a')](_0x35e793[_0xdb5f('0x35')],function(_0x21a575){return{'id':_0x21a575[_0xdb5f('0x27')],'name':_0x21a575[_0xdb5f('0x6e')],'custom':_0x21a575[_0xdb5f('0x6f')],'options':_0x21a575[_0xdb5f('0x70')][_0xdb5f('0x36')]>0x0?_[_0xdb5f('0x2a')](_0x21a575[_0xdb5f('0x70')],function(_0xa540e6){return{'name':_0xa540e6[_0xdb5f('0x6e')],'value':_0xa540e6[_0xdb5f('0x71')]};}):_0x21a575['type']==_0xdb5f('0x68')?[{'name':'True','value':'true'},{'name':_0xdb5f('0x72'),'value':_0xdb5f('0x73')}]:[]};})};}})[_0xdb5f('0x24')](respondWithResult(_0x1e32c1,null))[_0xdb5f('0x41')](function(_0x52d36e){var _0x23bdbc=_0x41077f[_0xdb5f('0x30')]['test']?0x1f4:_0x52d36e[_0xdb5f('0x74')]||0x1f4;logger[_0xdb5f('0x25')](_0xdb5f('0x75'),'getFields',_0x23bdbc,JSON[_0xdb5f('0x76')](_0x52d36e));delete _0x52d36e[_0xdb5f('0x27')];if(_0x23bdbc===0x191){_0x23bdbc=0x190;}_0x1e32c1[_0xdb5f('0x19')](_0x23bdbc)[_0xdb5f('0x28')](_0x41077f[_0xdb5f('0x30')]['test']?{'message':_0xdb5f('0x77'),'statusCode':_0x52d36e[_0xdb5f('0x74')]}:_0x52d36e);});};