Built motion from commit ffdca78c.|2.6.24
[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 _0xa5e0=['options','includeAll','include','findAll','rows','catch','show','params','length','find','body','update','destroy','getConfigurations','SalesforceConfiguration','addConfiguration','AccountId','getSubjects','Descriptions','channel','SalesforceField','getFields','findOne','remoteUri','clientId','clientSecret','username','slice','substring','lastIndexOf','Connection','login','password','concat','ticketType','sobject','describe','OwnerId','IsReminderSet','Subject','string','int','boolean','email','textarea','remove','includes','custom','picklistValues','label','value','true','False','false','error','stringify','Wrong\x20credentials','eml-format','rimraf','zip-dir','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/license/util','../../mysqldb','../../components/integrations/configuration','status','end','json','offset','count','set','Content-Range','reject','save','then','stack','name','send','map','SalesforceAccount','rawAttributes','type','key','model','query','keys','filters','attributes','intersection','fields','hasOwnProperty','nolimit','limit','order','sort','where','pick','filter','VIRTUAL','merge'];(function(_0xa1e2fd,_0x1c9305){var _0x218880=function(_0x405167){while(--_0x405167){_0xa1e2fd['push'](_0xa1e2fd['shift']());}};_0x218880(++_0x1c9305);}(_0xa5e0,0x1a1));var _0x0a5e=function(_0x4699a8,_0x87378b){_0x4699a8=_0x4699a8-0x0;var _0x4dc70a=_0xa5e0[_0x4699a8];return _0x4dc70a;};'use strict';var emlformat=require(_0x0a5e('0x0'));var rimraf=require(_0x0a5e('0x1'));var zipdir=require(_0x0a5e('0x2'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0x0a5e('0x3'));var BPromise=require(_0x0a5e('0x4'));var Mustache=require(_0x0a5e('0x5'));var util=require(_0x0a5e('0x6'));var path=require(_0x0a5e('0x7'));var sox=require(_0x0a5e('0x8'));var csv=require(_0x0a5e('0x9'));var ejs=require(_0x0a5e('0xa'));var fs=require('fs');var fs_extra=require(_0x0a5e('0xb'));var _=require(_0x0a5e('0xc'));var squel=require(_0x0a5e('0xd'));var crypto=require(_0x0a5e('0xe'));var jsforce=require(_0x0a5e('0xf'));var deskjs=require(_0x0a5e('0x10'));var toCsv=require('to-csv');var querystring=require(_0x0a5e('0x11'));var Papa=require(_0x0a5e('0x12'));var Redis=require(_0x0a5e('0x13'));var authService=require(_0x0a5e('0x14'));var qs=require(_0x0a5e('0x15'));var as=require(_0x0a5e('0x16'));var hardwareService=require(_0x0a5e('0x17'));var logger=require('../../config/logger')(_0x0a5e('0x18'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0x0a5e('0x19'));var db=require(_0x0a5e('0x1a'))['db'];var integrations=require(_0x0a5e('0x1b'));function respondWithStatusCode(_0x2d6ab3,_0x1726d9){_0x1726d9=_0x1726d9||0xcc;return function(_0x1ca8fe){if(_0x1ca8fe){return _0x2d6ab3['sendStatus'](_0x1726d9);}return _0x2d6ab3[_0x0a5e('0x1c')](_0x1726d9)[_0x0a5e('0x1d')]();};}function respondWithResult(_0x2b0226,_0x139a73){_0x139a73=_0x139a73||0xc8;return function(_0xcecf8){if(_0xcecf8){return _0x2b0226[_0x0a5e('0x1c')](_0x139a73)[_0x0a5e('0x1e')](_0xcecf8);}};}function respondWithFilteredResult(_0x5d75fb,_0x3ba77b){return function(_0x5c545f){if(_0x5c545f){var _0x258e66=typeof _0x3ba77b[_0x0a5e('0x1f')]==='undefined'&&typeof _0x3ba77b['limit']==='undefined';var _0x7e56c8=_0x5c545f['count'];var _0x5aaadd=_0x258e66?0x0:_0x3ba77b['offset'];var _0x598e42=_0x258e66?_0x5c545f[_0x0a5e('0x20')]:_0x3ba77b['offset']+_0x3ba77b['limit'];var _0x438da6;if(_0x598e42>=_0x7e56c8){_0x598e42=_0x7e56c8;_0x438da6=0xc8;}else{_0x438da6=0xce;}_0x5d75fb[_0x0a5e('0x1c')](_0x438da6);return _0x5d75fb[_0x0a5e('0x21')](_0x0a5e('0x22'),_0x5aaadd+'-'+_0x598e42+'/'+_0x7e56c8)[_0x0a5e('0x1e')](_0x5c545f);}return null;};}function patchUpdates(_0x3d558b){return function(_0x5563ef){try{jsonpatch['apply'](_0x5563ef,_0x3d558b,!![]);}catch(_0x3fcc25){return BPromise[_0x0a5e('0x23')](_0x3fcc25);}return _0x5563ef[_0x0a5e('0x24')]();};}function saveUpdates(_0x3f6e23,_0x322852){return function(_0x34cb77){if(_0x34cb77){return _0x34cb77['update'](_0x3f6e23)[_0x0a5e('0x25')](function(_0x1aff78){return _0x1aff78;});}return null;};}function removeEntity(_0xe2f3d3,_0x5902cd){return function(_0x28b476){if(_0x28b476){return _0x28b476['destroy']()['then'](function(){_0xe2f3d3[_0x0a5e('0x1c')](0xcc)['end']();});}};}function handleEntityNotFound(_0x48df88,_0x5d557f){return function(_0x25ec88){if(!_0x25ec88){_0x48df88['sendStatus'](0x194);}return _0x25ec88;};}function handleError(_0xf9c4df,_0x504fb0){_0x504fb0=_0x504fb0||0x1f4;return function(_0x514c81){logger['error'](_0x514c81[_0x0a5e('0x26')]);if(_0x514c81[_0x0a5e('0x27')]){delete _0x514c81[_0x0a5e('0x27')];}_0xf9c4df['status'](_0x504fb0)[_0x0a5e('0x28')](_0x514c81);};}exports['index']=function(_0x4fa974,_0x432618){var _0x3f043c={},_0x4075ff={},_0x275c68={'count':0x0,'rows':[]};var _0x57997c=_[_0x0a5e('0x29')](db[_0x0a5e('0x2a')][_0x0a5e('0x2b')],function(_0x556100){return{'name':_0x556100['fieldName'],'type':_0x556100[_0x0a5e('0x2c')][_0x0a5e('0x2d')]};});_0x4075ff[_0x0a5e('0x2e')]=_[_0x0a5e('0x29')](_0x57997c,_0x0a5e('0x27'));_0x4075ff[_0x0a5e('0x2f')]=_[_0x0a5e('0x30')](_0x4fa974[_0x0a5e('0x2f')]);_0x4075ff[_0x0a5e('0x31')]=_['intersection'](_0x4075ff[_0x0a5e('0x2e')],_0x4075ff[_0x0a5e('0x2f')]);_0x3f043c[_0x0a5e('0x32')]=_[_0x0a5e('0x33')](_0x4075ff['model'],qs['fields'](_0x4fa974[_0x0a5e('0x2f')][_0x0a5e('0x34')]));_0x3f043c[_0x0a5e('0x32')]=_0x3f043c[_0x0a5e('0x32')]['length']?_0x3f043c[_0x0a5e('0x32')]:_0x4075ff[_0x0a5e('0x2e')];if(!_0x4fa974[_0x0a5e('0x2f')][_0x0a5e('0x35')](_0x0a5e('0x36'))){_0x3f043c[_0x0a5e('0x37')]=qs[_0x0a5e('0x37')](_0x4fa974[_0x0a5e('0x2f')]['limit']);_0x3f043c[_0x0a5e('0x1f')]=qs['offset'](_0x4fa974[_0x0a5e('0x2f')][_0x0a5e('0x1f')]);}_0x3f043c[_0x0a5e('0x38')]=qs[_0x0a5e('0x39')](_0x4fa974[_0x0a5e('0x2f')][_0x0a5e('0x39')]);_0x3f043c[_0x0a5e('0x3a')]=qs[_0x0a5e('0x31')](_[_0x0a5e('0x3b')](_0x4fa974[_0x0a5e('0x2f')],_0x4075ff[_0x0a5e('0x31')]),_0x57997c);if(_0x4fa974['query'][_0x0a5e('0x3c')]){_0x3f043c[_0x0a5e('0x3a')]=_['merge'](_0x3f043c[_0x0a5e('0x3a')],{'$or':_['map'](_0x57997c,function(_0x1ea4d0){if(_0x1ea4d0[_0x0a5e('0x2c')]!==_0x0a5e('0x3d')){var _0x97ec41={};_0x97ec41[_0x1ea4d0['name']]={'$like':'%'+_0x4fa974[_0x0a5e('0x2f')][_0x0a5e('0x3c')]+'%'};return _0x97ec41;}})});}_0x3f043c=_[_0x0a5e('0x3e')]({},_0x3f043c,_0x4fa974[_0x0a5e('0x3f')]);var _0x456fcc={'where':_0x3f043c[_0x0a5e('0x3a')]};return db['SalesforceAccount']['count'](_0x456fcc)[_0x0a5e('0x25')](function(_0x54a753){_0x275c68[_0x0a5e('0x20')]=_0x54a753;if(_0x4fa974[_0x0a5e('0x2f')][_0x0a5e('0x40')]){_0x3f043c[_0x0a5e('0x41')]=[{'all':!![]}];}return db[_0x0a5e('0x2a')][_0x0a5e('0x42')](_0x3f043c);})[_0x0a5e('0x25')](function(_0x42f51a){_0x275c68[_0x0a5e('0x43')]=_0x42f51a;return _0x275c68;})[_0x0a5e('0x25')](respondWithFilteredResult(_0x432618,_0x3f043c))[_0x0a5e('0x44')](handleError(_0x432618,null));};exports[_0x0a5e('0x45')]=function(_0x1939a5,_0x51ecdb){var _0x26ba66={'raw':![],'where':{'id':_0x1939a5[_0x0a5e('0x46')]['id']}},_0x39cdbf={};_0x39cdbf['model']=_[_0x0a5e('0x30')](db['SalesforceAccount'][_0x0a5e('0x2b')]);_0x39cdbf[_0x0a5e('0x2f')]=_[_0x0a5e('0x30')](_0x1939a5[_0x0a5e('0x2f')]);_0x39cdbf[_0x0a5e('0x31')]=_[_0x0a5e('0x33')](_0x39cdbf[_0x0a5e('0x2e')],_0x39cdbf[_0x0a5e('0x2f')]);_0x26ba66[_0x0a5e('0x32')]=_[_0x0a5e('0x33')](_0x39cdbf['model'],qs[_0x0a5e('0x34')](_0x1939a5[_0x0a5e('0x2f')]['fields']));_0x26ba66[_0x0a5e('0x32')]=_0x26ba66[_0x0a5e('0x32')][_0x0a5e('0x47')]?_0x26ba66[_0x0a5e('0x32')]:_0x39cdbf['model'];if(_0x1939a5[_0x0a5e('0x2f')]['includeAll']){_0x26ba66[_0x0a5e('0x41')]=[{'all':!![]}];}_0x26ba66=_['merge']({},_0x26ba66,_0x1939a5[_0x0a5e('0x3f')]);return db[_0x0a5e('0x2a')][_0x0a5e('0x48')](_0x26ba66)['then'](handleEntityNotFound(_0x51ecdb,null))[_0x0a5e('0x25')](respondWithResult(_0x51ecdb,null))[_0x0a5e('0x44')](handleError(_0x51ecdb,null));};exports['create']=function(_0x274d1d,_0xc61aea){return db[_0x0a5e('0x2a')]['create'](_0x274d1d[_0x0a5e('0x49')],{})[_0x0a5e('0x25')](respondWithResult(_0xc61aea,0xc9))[_0x0a5e('0x44')](handleError(_0xc61aea,null));};exports[_0x0a5e('0x4a')]=function(_0x497ac7,_0x15cf8a){if(_0x497ac7['body']['id']){delete _0x497ac7[_0x0a5e('0x49')]['id'];}return db[_0x0a5e('0x2a')]['find']({'where':{'id':_0x497ac7['params']['id']}})[_0x0a5e('0x25')](handleEntityNotFound(_0x15cf8a,null))[_0x0a5e('0x25')](saveUpdates(_0x497ac7[_0x0a5e('0x49')],null))[_0x0a5e('0x25')](respondWithResult(_0x15cf8a,null))['catch'](handleError(_0x15cf8a,null));};exports[_0x0a5e('0x4b')]=function(_0x1e5ea7,_0xca8b3b){return db['SalesforceAccount'][_0x0a5e('0x48')]({'where':{'id':_0x1e5ea7[_0x0a5e('0x46')]['id']}})[_0x0a5e('0x25')](handleEntityNotFound(_0xca8b3b,null))[_0x0a5e('0x25')](removeEntity(_0xca8b3b,null))['catch'](handleError(_0xca8b3b,null));};exports[_0x0a5e('0x4c')]=function(_0x476b03,_0x1821fb,_0x291d4f){var _0x507546={};var _0x423b53={};var _0x170114;var _0x17cc1d;return db[_0x0a5e('0x2a')]['findOne']({'where':{'id':_0x476b03['params']['id']}})['then'](handleEntityNotFound(_0x1821fb,null))[_0x0a5e('0x25')](function(_0x3066cf){if(_0x3066cf){_0x170114=_0x3066cf;_0x423b53[_0x0a5e('0x2e')]=_[_0x0a5e('0x30')](db[_0x0a5e('0x4d')][_0x0a5e('0x2b')]);_0x423b53[_0x0a5e('0x2f')]=_[_0x0a5e('0x30')](_0x476b03[_0x0a5e('0x2f')]);_0x423b53[_0x0a5e('0x31')]=_[_0x0a5e('0x33')](_0x423b53[_0x0a5e('0x2e')],_0x423b53[_0x0a5e('0x2f')]);_0x507546[_0x0a5e('0x32')]=_[_0x0a5e('0x33')](_0x423b53[_0x0a5e('0x2e')],qs[_0x0a5e('0x34')](_0x476b03[_0x0a5e('0x2f')][_0x0a5e('0x34')]));_0x507546['attributes']=_0x507546[_0x0a5e('0x32')][_0x0a5e('0x47')]?_0x507546['attributes']:_0x423b53['model'];_0x507546[_0x0a5e('0x38')]=qs[_0x0a5e('0x39')](_0x476b03['query'][_0x0a5e('0x39')]);_0x507546['where']=qs['filters'](_[_0x0a5e('0x3b')](_0x476b03[_0x0a5e('0x2f')],_0x423b53[_0x0a5e('0x31')]));if(_0x476b03['query']['filter']){_0x507546['where']=_[_0x0a5e('0x3e')](_0x507546[_0x0a5e('0x3a')],{'$or':_[_0x0a5e('0x29')](_0x507546[_0x0a5e('0x32')],function(_0x4e7d3f){var _0x39625c={};_0x39625c[_0x4e7d3f]={'$like':'%'+_0x476b03[_0x0a5e('0x2f')]['filter']+'%'};return _0x39625c;})});}_0x507546=_[_0x0a5e('0x3e')]({},_0x507546,_0x476b03[_0x0a5e('0x3f')]);return _0x170114[_0x0a5e('0x4c')](_0x507546);}})['then'](function(_0x13e51a){if(_0x13e51a){_0x17cc1d=_0x13e51a[_0x0a5e('0x47')];if(!_0x476b03[_0x0a5e('0x2f')][_0x0a5e('0x35')](_0x0a5e('0x36'))){_0x507546['limit']=qs['limit'](_0x476b03[_0x0a5e('0x2f')][_0x0a5e('0x37')]);_0x507546['offset']=qs[_0x0a5e('0x1f')](_0x476b03[_0x0a5e('0x2f')][_0x0a5e('0x1f')]);}return _0x170114[_0x0a5e('0x4c')](_0x507546);}})[_0x0a5e('0x25')](function(_0x19254c){if(_0x19254c){return _0x19254c?{'count':_0x17cc1d,'rows':_0x19254c}:null;}})[_0x0a5e('0x25')](respondWithResult(_0x1821fb,null))['catch'](handleError(_0x1821fb,null));};exports[_0x0a5e('0x4e')]=function(_0x2bc040,_0x559735,_0x58ebc0){if(_0x2bc040['body']['id']){delete _0x2bc040[_0x0a5e('0x49')]['id'];}return db[_0x0a5e('0x2a')]['findOne']({'where':{'id':_0x2bc040[_0x0a5e('0x46')]['id']}})[_0x0a5e('0x25')](handleEntityNotFound(_0x559735,null))['then'](function(_0x3ebff4){if(_0x3ebff4){_0x2bc040[_0x0a5e('0x49')][_0x0a5e('0x4f')]=_0x3ebff4['id'];_0x2bc040[_0x0a5e('0x49')]['Subjects']=integrations[_0x0a5e('0x50')](_0x2bc040[_0x0a5e('0x49')]['channel'],_0x2bc040['body']['type']);_0x2bc040[_0x0a5e('0x49')][_0x0a5e('0x51')]=integrations['getDescriptions'](_0x2bc040[_0x0a5e('0x49')][_0x0a5e('0x52')],_0x2bc040[_0x0a5e('0x49')][_0x0a5e('0x2c')]);return db[_0x0a5e('0x4d')]['create'](_0x2bc040['body'],{'include':[{'model':db[_0x0a5e('0x53')],'as':'Subjects'},{'model':db['SalesforceField'],'as':'Descriptions'}]});}return null;})[_0x0a5e('0x25')](respondWithResult(_0x559735,null))[_0x0a5e('0x44')](handleError(_0x559735,null));};exports[_0x0a5e('0x54')]=function(_0x281b35,_0x2be4c2,_0x4004e6){var _0x1eade7;var _0x35c0c3='';var _0x8793fd='Task';return db[_0x0a5e('0x2a')][_0x0a5e('0x55')]({'where':{'id':_0x281b35[_0x0a5e('0x46')]['id']},'attributes':['id',_0x0a5e('0x56'),_0x0a5e('0x57'),_0x0a5e('0x58'),_0x0a5e('0x59'),'password','securityToken']})['then'](handleEntityNotFound(_0x2be4c2,null))[_0x0a5e('0x25')](function(_0x3d113f){if(_0x3d113f){_0x35c0c3=_0x3d113f[_0x0a5e('0x56')];var _0x13249e=_0x35c0c3[_0x0a5e('0x5a')](-0x1);if(_0x13249e==='/'){_0x35c0c3=_0x35c0c3[_0x0a5e('0x5b')](0x0,_0x35c0c3[_0x0a5e('0x5c')](_0x13249e));}_0x1eade7=new jsforce[(_0x0a5e('0x5d'))]({'oauth2':{'loginUrl':_0x35c0c3,'clientId':_0x3d113f[_0x0a5e('0x57')],'clientSecret':_0x3d113f['clientSecret']}});return _0x1eade7[_0x0a5e('0x5e')](_0x3d113f[_0x0a5e('0x59')],_0x3d113f[_0x0a5e('0x5f')][_0x0a5e('0x60')](_0x3d113f['securityToken']));}})[_0x0a5e('0x25')](function(_0x2dfd0f){if(_0x2dfd0f){if(!_['isNil'](_0x281b35[_0x0a5e('0x2f')][_0x0a5e('0x61')])){_0x8793fd=_0x281b35['query'][_0x0a5e('0x61')];}return _0x1eade7[_0x0a5e('0x62')](_0x8793fd)[_0x0a5e('0x63')]();}})[_0x0a5e('0x25')](function(_0x5501bd){var _0x36879a=[_0x0a5e('0x64'),'ActivityDate',_0x0a5e('0x65'),'IsRecurrence',_0x0a5e('0x66'),'Description'];var _0x29c156=[_0x0a5e('0x67'),_0x0a5e('0x68'),'picklist',_0x0a5e('0x69'),_0x0a5e('0x6a'),_0x0a5e('0x6b'),'phone'];if(_0x5501bd){_[_0x0a5e('0x6c')](_0x5501bd[_0x0a5e('0x34')],function(_0x3eabc8){return _0x36879a['includes'](_0x3eabc8[_0x0a5e('0x27')])||!_0x29c156[_0x0a5e('0x6d')](_0x3eabc8[_0x0a5e('0x2c')]);});return{'count':_0x5501bd[_0x0a5e('0x34')][_0x0a5e('0x47')],'rows':_[_0x0a5e('0x29')](_0x5501bd[_0x0a5e('0x34')],function(_0x31c83d){return{'id':_0x31c83d['name'],'name':_0x31c83d['label'],'custom':_0x31c83d[_0x0a5e('0x6e')],'options':_0x31c83d[_0x0a5e('0x6f')][_0x0a5e('0x47')]>0x0?_['map'](_0x31c83d[_0x0a5e('0x6f')],function(_0x3f449e){return{'name':_0x3f449e[_0x0a5e('0x70')],'value':_0x3f449e[_0x0a5e('0x71')]};}):_0x31c83d['type']=='boolean'?[{'name':'True','value':_0x0a5e('0x72')},{'name':_0x0a5e('0x73'),'value':_0x0a5e('0x74')}]:[]};})};}})['then'](respondWithResult(_0x2be4c2,null))[_0x0a5e('0x44')](function(_0x4ff324){var _0x1cd7ea=_0x281b35[_0x0a5e('0x2f')]['test']?0x1f4:_0x4ff324['statusCode']||0x1f4;logger[_0x0a5e('0x75')]('getFields,\x20%s,\x20%s,\x20%s','getFields',_0x1cd7ea,JSON[_0x0a5e('0x76')](_0x4ff324));delete _0x4ff324['name'];if(_0x1cd7ea===0x191){_0x1cd7ea=0x190;}_0x2be4c2[_0x0a5e('0x1c')](_0x1cd7ea)[_0x0a5e('0x28')](_0x281b35['query']['test']?{'message':_0x0a5e('0x77'),'statusCode':_0x4ff324['statusCode']}:_0x4ff324);});};