a4a84da41ce5e919eef8d91088c6803aa224a0c8
[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 _0xc305=['rimraf','fast-json-patch','request-promise','moment','mustache','path','to-csv','lodash','squel','crypto','jsforce','desk.js','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','../../components/integrations/configuration','sendStatus','status','end','offset','undefined','limit','count','set','Content-Range','json','apply','reject','update','then','error','name','send','index','map','fieldName','type','model','keys','query','filters','attributes','intersection','fields','length','hasOwnProperty','nolimit','sort','where','filter','merge','VIRTUAL','options','SalesforceAccount','includeAll','findAll','catch','show','rawAttributes','include','find','create','body','params','destroy','getConfigurations','findOne','SalesforceConfiguration','order','pick','AccountId','Subjects','getSubjects','channel','Descriptions','getDescriptions','SalesforceField','getFields','Task','remoteUri','clientId','clientSecret','username','password','securityToken','slice','substring','lastIndexOf','Connection','login','concat','isNil','ticketType','sobject','describe','OwnerId','ActivityDate','IsRecurrence','Subject','string','int','boolean','textarea','phone','includes','label','custom','picklistValues','value','true','False','false','test','statusCode','getFields,\x20%s,\x20%s,\x20%s','stringify','Wrong\x20credentials','eml-format'];(function(_0x1890e0,_0x1ab8e9){var _0x477f94=function(_0x2975ae){while(--_0x2975ae){_0x1890e0['push'](_0x1890e0['shift']());}};_0x477f94(++_0x1ab8e9);}(_0xc305,0xf7));var _0x5c30=function(_0x4fe19c,_0x45d0fe){_0x4fe19c=_0x4fe19c-0x0;var _0x952ac7=_0xc305[_0x4fe19c];return _0x952ac7;};'use strict';var emlformat=require(_0x5c30('0x0'));var rimraf=require(_0x5c30('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x5c30('0x2'));var rp=require(_0x5c30('0x3'));var moment=require(_0x5c30('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x5c30('0x5'));var util=require('util');var path=require(_0x5c30('0x6'));var sox=require('sox');var csv=require(_0x5c30('0x7'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x5c30('0x8'));var squel=require(_0x5c30('0x9'));var crypto=require(_0x5c30('0xa'));var jsforce=require(_0x5c30('0xb'));var deskjs=require(_0x5c30('0xc'));var toCsv=require(_0x5c30('0x7'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0x5c30('0xd'));var authService=require('../../components/auth/service');var qs=require(_0x5c30('0xe'));var as=require(_0x5c30('0xf'));var hardwareService=require(_0x5c30('0x10'));var logger=require(_0x5c30('0x11'))(_0x5c30('0x12'));var utils=require(_0x5c30('0x13'));var config=require(_0x5c30('0x14'));var licenseUtil=require('../../config/license/util');var db=require(_0x5c30('0x15'))['db'];var integrations=require(_0x5c30('0x16'));function respondWithStatusCode(_0xbd7fdc,_0x511af2){_0x511af2=_0x511af2||0xcc;return function(_0x34bc43){if(_0x34bc43){return _0xbd7fdc[_0x5c30('0x17')](_0x511af2);}return _0xbd7fdc[_0x5c30('0x18')](_0x511af2)[_0x5c30('0x19')]();};}function respondWithResult(_0x3b3e80,_0x1e2aa1){_0x1e2aa1=_0x1e2aa1||0xc8;return function(_0x3ffbf4){if(_0x3ffbf4){return _0x3b3e80[_0x5c30('0x18')](_0x1e2aa1)['json'](_0x3ffbf4);}};}function respondWithFilteredResult(_0xbabef9,_0x2cab0b){return function(_0x20da86){if(_0x20da86){var _0x34fe8e=typeof _0x2cab0b[_0x5c30('0x1a')]===_0x5c30('0x1b')&&typeof _0x2cab0b[_0x5c30('0x1c')]===_0x5c30('0x1b');var _0x5ba79a=_0x20da86[_0x5c30('0x1d')];var _0x136bec=_0x34fe8e?0x0:_0x2cab0b[_0x5c30('0x1a')];var _0x17502a=_0x34fe8e?_0x20da86[_0x5c30('0x1d')]:_0x2cab0b['offset']+_0x2cab0b[_0x5c30('0x1c')];var _0xb703f9;if(_0x17502a>=_0x5ba79a){_0x17502a=_0x5ba79a;_0xb703f9=0xc8;}else{_0xb703f9=0xce;}_0xbabef9[_0x5c30('0x18')](_0xb703f9);return _0xbabef9[_0x5c30('0x1e')](_0x5c30('0x1f'),_0x136bec+'-'+_0x17502a+'/'+_0x5ba79a)[_0x5c30('0x20')](_0x20da86);}return null;};}function patchUpdates(_0x1b7c91){return function(_0x5e38be){try{jsonpatch[_0x5c30('0x21')](_0x5e38be,_0x1b7c91,!![]);}catch(_0x150cd9){return BPromise[_0x5c30('0x22')](_0x150cd9);}return _0x5e38be['save']();};}function saveUpdates(_0x49c646,_0x5bf5a0){return function(_0x16b07b){if(_0x16b07b){return _0x16b07b[_0x5c30('0x23')](_0x49c646)[_0x5c30('0x24')](function(_0xbb891f){return _0xbb891f;});}return null;};}function removeEntity(_0x5dbe3a,_0x36b983){return function(_0x42037d){if(_0x42037d){return _0x42037d['destroy']()[_0x5c30('0x24')](function(){_0x5dbe3a['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x582a9d,_0x10ce63){return function(_0x58011c){if(!_0x58011c){_0x582a9d['sendStatus'](0x194);}return _0x58011c;};}function handleError(_0x3ce37b,_0x50d7d1){_0x50d7d1=_0x50d7d1||0x1f4;return function(_0x59dacd){logger[_0x5c30('0x25')](_0x59dacd['stack']);if(_0x59dacd['name']){delete _0x59dacd[_0x5c30('0x26')];}_0x3ce37b['status'](_0x50d7d1)[_0x5c30('0x27')](_0x59dacd);};}exports[_0x5c30('0x28')]=function(_0x51b69f,_0x12d9e2){var _0x1b8c7b={},_0x3310d4={},_0x461240={'count':0x0,'rows':[]};var _0x238bdb=_[_0x5c30('0x29')](db['SalesforceAccount']['rawAttributes'],function(_0x204a79){return{'name':_0x204a79[_0x5c30('0x2a')],'type':_0x204a79[_0x5c30('0x2b')]['key']};});_0x3310d4[_0x5c30('0x2c')]=_['map'](_0x238bdb,_0x5c30('0x26'));_0x3310d4['query']=_[_0x5c30('0x2d')](_0x51b69f[_0x5c30('0x2e')]);_0x3310d4[_0x5c30('0x2f')]=_['intersection'](_0x3310d4[_0x5c30('0x2c')],_0x3310d4['query']);_0x1b8c7b[_0x5c30('0x30')]=_[_0x5c30('0x31')](_0x3310d4['model'],qs[_0x5c30('0x32')](_0x51b69f[_0x5c30('0x2e')][_0x5c30('0x32')]));_0x1b8c7b[_0x5c30('0x30')]=_0x1b8c7b['attributes'][_0x5c30('0x33')]?_0x1b8c7b[_0x5c30('0x30')]:_0x3310d4['model'];if(!_0x51b69f[_0x5c30('0x2e')][_0x5c30('0x34')](_0x5c30('0x35'))){_0x1b8c7b['limit']=qs[_0x5c30('0x1c')](_0x51b69f[_0x5c30('0x2e')][_0x5c30('0x1c')]);_0x1b8c7b[_0x5c30('0x1a')]=qs[_0x5c30('0x1a')](_0x51b69f['query'][_0x5c30('0x1a')]);}_0x1b8c7b['order']=qs[_0x5c30('0x36')](_0x51b69f[_0x5c30('0x2e')]['sort']);_0x1b8c7b[_0x5c30('0x37')]=qs[_0x5c30('0x2f')](_['pick'](_0x51b69f[_0x5c30('0x2e')],_0x3310d4[_0x5c30('0x2f')]),_0x238bdb);if(_0x51b69f[_0x5c30('0x2e')][_0x5c30('0x38')]){_0x1b8c7b[_0x5c30('0x37')]=_[_0x5c30('0x39')](_0x1b8c7b[_0x5c30('0x37')],{'$or':_[_0x5c30('0x29')](_0x238bdb,function(_0x56eba2){if(_0x56eba2[_0x5c30('0x2b')]!==_0x5c30('0x3a')){var _0x7f5bed={};_0x7f5bed[_0x56eba2[_0x5c30('0x26')]]={'$like':'%'+_0x51b69f[_0x5c30('0x2e')]['filter']+'%'};return _0x7f5bed;}})});}_0x1b8c7b=_[_0x5c30('0x39')]({},_0x1b8c7b,_0x51b69f[_0x5c30('0x3b')]);var _0x384b7c={'where':_0x1b8c7b[_0x5c30('0x37')]};return db[_0x5c30('0x3c')][_0x5c30('0x1d')](_0x384b7c)['then'](function(_0xbbdb9b){_0x461240[_0x5c30('0x1d')]=_0xbbdb9b;if(_0x51b69f[_0x5c30('0x2e')][_0x5c30('0x3d')]){_0x1b8c7b['include']=[{'all':!![]}];}return db['SalesforceAccount'][_0x5c30('0x3e')](_0x1b8c7b);})['then'](function(_0x1e2c09){_0x461240['rows']=_0x1e2c09;return _0x461240;})[_0x5c30('0x24')](respondWithFilteredResult(_0x12d9e2,_0x1b8c7b))[_0x5c30('0x3f')](handleError(_0x12d9e2,null));};exports[_0x5c30('0x40')]=function(_0xfc7380,_0x404a02){var _0x39527e={'raw':![],'where':{'id':_0xfc7380['params']['id']}},_0x5adb16={};_0x5adb16[_0x5c30('0x2c')]=_['keys'](db['SalesforceAccount'][_0x5c30('0x41')]);_0x5adb16[_0x5c30('0x2e')]=_['keys'](_0xfc7380[_0x5c30('0x2e')]);_0x5adb16[_0x5c30('0x2f')]=_['intersection'](_0x5adb16['model'],_0x5adb16[_0x5c30('0x2e')]);_0x39527e[_0x5c30('0x30')]=_[_0x5c30('0x31')](_0x5adb16[_0x5c30('0x2c')],qs[_0x5c30('0x32')](_0xfc7380[_0x5c30('0x2e')][_0x5c30('0x32')]));_0x39527e[_0x5c30('0x30')]=_0x39527e['attributes']['length']?_0x39527e[_0x5c30('0x30')]:_0x5adb16[_0x5c30('0x2c')];if(_0xfc7380['query']['includeAll']){_0x39527e[_0x5c30('0x42')]=[{'all':!![]}];}_0x39527e=_[_0x5c30('0x39')]({},_0x39527e,_0xfc7380[_0x5c30('0x3b')]);return db[_0x5c30('0x3c')][_0x5c30('0x43')](_0x39527e)[_0x5c30('0x24')](handleEntityNotFound(_0x404a02,null))[_0x5c30('0x24')](respondWithResult(_0x404a02,null))[_0x5c30('0x3f')](handleError(_0x404a02,null));};exports[_0x5c30('0x44')]=function(_0x183cde,_0x5ca0c3){return db[_0x5c30('0x3c')][_0x5c30('0x44')](_0x183cde['body'],{})['then'](respondWithResult(_0x5ca0c3,0xc9))[_0x5c30('0x3f')](handleError(_0x5ca0c3,null));};exports['update']=function(_0x3b125c,_0x4f47c4){if(_0x3b125c[_0x5c30('0x45')]['id']){delete _0x3b125c[_0x5c30('0x45')]['id'];}return db['SalesforceAccount'][_0x5c30('0x43')]({'where':{'id':_0x3b125c[_0x5c30('0x46')]['id']}})[_0x5c30('0x24')](handleEntityNotFound(_0x4f47c4,null))[_0x5c30('0x24')](saveUpdates(_0x3b125c[_0x5c30('0x45')],null))[_0x5c30('0x24')](respondWithResult(_0x4f47c4,null))[_0x5c30('0x3f')](handleError(_0x4f47c4,null));};exports[_0x5c30('0x47')]=function(_0x2e7e46,_0x2d5069){return db[_0x5c30('0x3c')]['find']({'where':{'id':_0x2e7e46[_0x5c30('0x46')]['id']}})['then'](handleEntityNotFound(_0x2d5069,null))[_0x5c30('0x24')](removeEntity(_0x2d5069,null))[_0x5c30('0x3f')](handleError(_0x2d5069,null));};exports[_0x5c30('0x48')]=function(_0x21d157,_0x1d3234,_0x492356){var _0x36d4b4={};var _0x216c12={};var _0x41cf2d;var _0x1cc7cf;return db[_0x5c30('0x3c')][_0x5c30('0x49')]({'where':{'id':_0x21d157[_0x5c30('0x46')]['id']}})['then'](handleEntityNotFound(_0x1d3234,null))[_0x5c30('0x24')](function(_0x40629c){if(_0x40629c){_0x41cf2d=_0x40629c;_0x216c12[_0x5c30('0x2c')]=_[_0x5c30('0x2d')](db[_0x5c30('0x4a')][_0x5c30('0x41')]);_0x216c12[_0x5c30('0x2e')]=_['keys'](_0x21d157[_0x5c30('0x2e')]);_0x216c12['filters']=_[_0x5c30('0x31')](_0x216c12['model'],_0x216c12[_0x5c30('0x2e')]);_0x36d4b4['attributes']=_[_0x5c30('0x31')](_0x216c12[_0x5c30('0x2c')],qs['fields'](_0x21d157[_0x5c30('0x2e')][_0x5c30('0x32')]));_0x36d4b4[_0x5c30('0x30')]=_0x36d4b4[_0x5c30('0x30')][_0x5c30('0x33')]?_0x36d4b4[_0x5c30('0x30')]:_0x216c12[_0x5c30('0x2c')];_0x36d4b4[_0x5c30('0x4b')]=qs[_0x5c30('0x36')](_0x21d157[_0x5c30('0x2e')]['sort']);_0x36d4b4['where']=qs[_0x5c30('0x2f')](_[_0x5c30('0x4c')](_0x21d157[_0x5c30('0x2e')],_0x216c12['filters']));if(_0x21d157[_0x5c30('0x2e')][_0x5c30('0x38')]){_0x36d4b4['where']=_[_0x5c30('0x39')](_0x36d4b4['where'],{'$or':_[_0x5c30('0x29')](_0x36d4b4['attributes'],function(_0xc88e83){var _0x3614c6={};_0x3614c6[_0xc88e83]={'$like':'%'+_0x21d157[_0x5c30('0x2e')][_0x5c30('0x38')]+'%'};return _0x3614c6;})});}_0x36d4b4=_[_0x5c30('0x39')]({},_0x36d4b4,_0x21d157[_0x5c30('0x3b')]);return _0x41cf2d['getConfigurations'](_0x36d4b4);}})[_0x5c30('0x24')](function(_0x4a2b9e){if(_0x4a2b9e){_0x1cc7cf=_0x4a2b9e['length'];if(!_0x21d157['query'][_0x5c30('0x34')]('nolimit')){_0x36d4b4[_0x5c30('0x1c')]=qs[_0x5c30('0x1c')](_0x21d157[_0x5c30('0x2e')][_0x5c30('0x1c')]);_0x36d4b4['offset']=qs[_0x5c30('0x1a')](_0x21d157['query'][_0x5c30('0x1a')]);}return _0x41cf2d[_0x5c30('0x48')](_0x36d4b4);}})[_0x5c30('0x24')](function(_0x95b4f8){if(_0x95b4f8){return _0x95b4f8?{'count':_0x1cc7cf,'rows':_0x95b4f8}:null;}})[_0x5c30('0x24')](respondWithResult(_0x1d3234,null))['catch'](handleError(_0x1d3234,null));};exports['addConfiguration']=function(_0x2e139e,_0x240075,_0x33b515){if(_0x2e139e[_0x5c30('0x45')]['id']){delete _0x2e139e['body']['id'];}return db[_0x5c30('0x3c')][_0x5c30('0x49')]({'where':{'id':_0x2e139e[_0x5c30('0x46')]['id']}})[_0x5c30('0x24')](handleEntityNotFound(_0x240075,null))[_0x5c30('0x24')](function(_0x33c520){if(_0x33c520){_0x2e139e[_0x5c30('0x45')][_0x5c30('0x4d')]=_0x33c520['id'];_0x2e139e['body'][_0x5c30('0x4e')]=integrations[_0x5c30('0x4f')](_0x2e139e[_0x5c30('0x45')][_0x5c30('0x50')],_0x2e139e[_0x5c30('0x45')][_0x5c30('0x2b')]);_0x2e139e[_0x5c30('0x45')][_0x5c30('0x51')]=integrations[_0x5c30('0x52')](_0x2e139e[_0x5c30('0x45')][_0x5c30('0x50')],_0x2e139e[_0x5c30('0x45')][_0x5c30('0x2b')]);return db['SalesforceConfiguration'][_0x5c30('0x44')](_0x2e139e[_0x5c30('0x45')],{'include':[{'model':db[_0x5c30('0x53')],'as':_0x5c30('0x4e')},{'model':db['SalesforceField'],'as':'Descriptions'}]});}return null;})['then'](respondWithResult(_0x240075,null))[_0x5c30('0x3f')](handleError(_0x240075,null));};exports[_0x5c30('0x54')]=function(_0x5bf8ed,_0x382845,_0x5b21a2){var _0x5a1789;var _0x145002='';var _0x2639f4=_0x5c30('0x55');return db['SalesforceAccount']['findOne']({'where':{'id':_0x5bf8ed[_0x5c30('0x46')]['id']},'attributes':['id',_0x5c30('0x56'),_0x5c30('0x57'),_0x5c30('0x58'),_0x5c30('0x59'),_0x5c30('0x5a'),_0x5c30('0x5b')]})[_0x5c30('0x24')](handleEntityNotFound(_0x382845,null))[_0x5c30('0x24')](function(_0x15bbe3){if(_0x15bbe3){_0x145002=_0x15bbe3[_0x5c30('0x56')];var _0x1ee54a=_0x145002[_0x5c30('0x5c')](-0x1);if(_0x1ee54a==='/'){_0x145002=_0x145002[_0x5c30('0x5d')](0x0,_0x145002[_0x5c30('0x5e')](_0x1ee54a));}_0x5a1789=new jsforce[(_0x5c30('0x5f'))]({'oauth2':{'loginUrl':_0x145002,'clientId':_0x15bbe3[_0x5c30('0x57')],'clientSecret':_0x15bbe3[_0x5c30('0x58')]}});return _0x5a1789[_0x5c30('0x60')](_0x15bbe3[_0x5c30('0x59')],_0x15bbe3[_0x5c30('0x5a')][_0x5c30('0x61')](_0x15bbe3[_0x5c30('0x5b')]));}})[_0x5c30('0x24')](function(_0x433918){if(_0x433918){if(!_[_0x5c30('0x62')](_0x5bf8ed[_0x5c30('0x2e')][_0x5c30('0x63')])){_0x2639f4=_0x5bf8ed[_0x5c30('0x2e')][_0x5c30('0x63')];}return _0x5a1789[_0x5c30('0x64')](_0x2639f4)[_0x5c30('0x65')]();}})[_0x5c30('0x24')](function(_0x39f931){var _0x1785b9=[_0x5c30('0x66'),_0x5c30('0x67'),'IsReminderSet',_0x5c30('0x68'),_0x5c30('0x69'),'Description'];var _0x2dda28=[_0x5c30('0x6a'),_0x5c30('0x6b'),'picklist',_0x5c30('0x6c'),'email',_0x5c30('0x6d'),_0x5c30('0x6e')];if(_0x39f931){_['remove'](_0x39f931['fields'],function(_0x199b52){return _0x1785b9[_0x5c30('0x6f')](_0x199b52[_0x5c30('0x26')])||!_0x2dda28['includes'](_0x199b52[_0x5c30('0x2b')]);});return{'count':_0x39f931[_0x5c30('0x32')][_0x5c30('0x33')],'rows':_[_0x5c30('0x29')](_0x39f931[_0x5c30('0x32')],function(_0x54ae38){return{'id':_0x54ae38['name'],'name':_0x54ae38[_0x5c30('0x70')],'custom':_0x54ae38[_0x5c30('0x71')],'options':_0x54ae38[_0x5c30('0x72')][_0x5c30('0x33')]>0x0?_['map'](_0x54ae38[_0x5c30('0x72')],function(_0x58d396){return{'name':_0x58d396['label'],'value':_0x58d396[_0x5c30('0x73')]};}):_0x54ae38[_0x5c30('0x2b')]=='boolean'?[{'name':'True','value':_0x5c30('0x74')},{'name':_0x5c30('0x75'),'value':_0x5c30('0x76')}]:[]};})};}})[_0x5c30('0x24')](respondWithResult(_0x382845,null))[_0x5c30('0x3f')](function(_0x1516b4){var _0x36a0cd=_0x5bf8ed[_0x5c30('0x2e')][_0x5c30('0x77')]?0x1f4:_0x1516b4[_0x5c30('0x78')]||0x1f4;logger[_0x5c30('0x25')](_0x5c30('0x79'),_0x5c30('0x54'),_0x36a0cd,JSON[_0x5c30('0x7a')](_0x1516b4));delete _0x1516b4[_0x5c30('0x26')];if(_0x36a0cd===0x191){_0x36a0cd=0x190;}_0x382845['status'](_0x36a0cd)['send'](_0x5bf8ed[_0x5c30('0x2e')][_0x5c30('0x77')]?{'message':_0x5c30('0x7b'),'statusCode':_0x1516b4[_0x5c30('0x78')]}:_0x1516b4);});};