Built motion from commit 753c950e.|2.5.42
[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 _0xe308=['length','includeAll','create','body','update','find','getConfigurations','findOne','SalesforceConfiguration','addConfiguration','AccountId','Subjects','getSubjects','channel','Descriptions','getDescriptions','SalesforceField','getFields','remoteUri','clientId','clientSecret','username','password','securityToken','slice','substring','lastIndexOf','Connection','concat','isNil','sobject','ActivityDate','IsReminderSet','IsRecurrence','int','picklist','boolean','email','textarea','remove','includes','label','custom','value','True','False','false','test','statusCode','stringify','eml-format','zip-dir','request-promise','bluebird','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','../../components/integrations/configuration','sendStatus','status','json','offset','undefined','limit','count','Content-Range','apply','reject','then','end','error','name','send','index','rawAttributes','type','key','model','query','keys','filters','intersection','fields','attributes','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','map','VIRTUAL','options','SalesforceAccount','include','rows','catch','params'];(function(_0x10b30e,_0x381b54){var _0x5591c0=function(_0x29de51){while(--_0x29de51){_0x10b30e['push'](_0x10b30e['shift']());}};_0x5591c0(++_0x381b54);}(_0xe308,0x194));var _0x8e30=function(_0x267e32,_0x5c23bd){_0x267e32=_0x267e32-0x0;var _0x437a60=_0xe308[_0x267e32];return _0x437a60;};'use strict';var emlformat=require(_0x8e30('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x8e30('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0x8e30('0x2'));var moment=require('moment');var BPromise=require(_0x8e30('0x3'));var Mustache=require('mustache');var util=require(_0x8e30('0x4'));var path=require(_0x8e30('0x5'));var sox=require(_0x8e30('0x6'));var csv=require(_0x8e30('0x7'));var ejs=require(_0x8e30('0x8'));var fs=require('fs');var fs_extra=require(_0x8e30('0x9'));var _=require(_0x8e30('0xa'));var squel=require(_0x8e30('0xb'));var crypto=require(_0x8e30('0xc'));var jsforce=require(_0x8e30('0xd'));var deskjs=require(_0x8e30('0xe'));var toCsv=require(_0x8e30('0x7'));var querystring=require(_0x8e30('0xf'));var Papa=require(_0x8e30('0x10'));var Redis=require(_0x8e30('0x11'));var authService=require(_0x8e30('0x12'));var qs=require('../../components/parsers/qs');var as=require(_0x8e30('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0x8e30('0x14'));var utils=require(_0x8e30('0x15'));var config=require(_0x8e30('0x16'));var licenseUtil=require(_0x8e30('0x17'));var db=require(_0x8e30('0x18'))['db'];var integrations=require(_0x8e30('0x19'));function respondWithStatusCode(_0x4cf69d,_0x245f16){_0x245f16=_0x245f16||0xcc;return function(_0x4ba722){if(_0x4ba722){return _0x4cf69d[_0x8e30('0x1a')](_0x245f16);}return _0x4cf69d[_0x8e30('0x1b')](_0x245f16)['end']();};}function respondWithResult(_0x1ee440,_0x3962e2){_0x3962e2=_0x3962e2||0xc8;return function(_0x229746){if(_0x229746){return _0x1ee440[_0x8e30('0x1b')](_0x3962e2)[_0x8e30('0x1c')](_0x229746);}};}function respondWithFilteredResult(_0x5781e6,_0x1e1e05){return function(_0xc65638){if(_0xc65638){var _0x141656=typeof _0x1e1e05[_0x8e30('0x1d')]===_0x8e30('0x1e')&&typeof _0x1e1e05[_0x8e30('0x1f')]===_0x8e30('0x1e');var _0x4113d9=_0xc65638[_0x8e30('0x20')];var _0x9dc302=_0x141656?0x0:_0x1e1e05[_0x8e30('0x1d')];var _0x28bbb8=_0x141656?_0xc65638['count']:_0x1e1e05[_0x8e30('0x1d')]+_0x1e1e05[_0x8e30('0x1f')];var _0x538aa5;if(_0x28bbb8>=_0x4113d9){_0x28bbb8=_0x4113d9;_0x538aa5=0xc8;}else{_0x538aa5=0xce;}_0x5781e6[_0x8e30('0x1b')](_0x538aa5);return _0x5781e6['set'](_0x8e30('0x21'),_0x9dc302+'-'+_0x28bbb8+'/'+_0x4113d9)[_0x8e30('0x1c')](_0xc65638);}return null;};}function patchUpdates(_0x23533d){return function(_0x5f1def){try{jsonpatch[_0x8e30('0x22')](_0x5f1def,_0x23533d,!![]);}catch(_0x532c5c){return BPromise[_0x8e30('0x23')](_0x532c5c);}return _0x5f1def['save']();};}function saveUpdates(_0x517816,_0x2d5ae8){return function(_0x483818){if(_0x483818){return _0x483818['update'](_0x517816)['then'](function(_0x2301b4){return _0x2301b4;});}return null;};}function removeEntity(_0x39078e,_0x5cc2dc){return function(_0x1f1dad){if(_0x1f1dad){return _0x1f1dad['destroy']()[_0x8e30('0x24')](function(){_0x39078e['status'](0xcc)[_0x8e30('0x25')]();});}};}function handleEntityNotFound(_0x417728,_0x709da2){return function(_0x377f61){if(!_0x377f61){_0x417728['sendStatus'](0x194);}return _0x377f61;};}function handleError(_0x1ded3d,_0x13c7cb){_0x13c7cb=_0x13c7cb||0x1f4;return function(_0x2b7b60){logger[_0x8e30('0x26')](_0x2b7b60['stack']);if(_0x2b7b60[_0x8e30('0x27')]){delete _0x2b7b60[_0x8e30('0x27')];}_0x1ded3d[_0x8e30('0x1b')](_0x13c7cb)[_0x8e30('0x28')](_0x2b7b60);};}exports[_0x8e30('0x29')]=function(_0x48eaaa,_0x3d1697){var _0x469bab={},_0x28bb21={},_0x2e3164={'count':0x0,'rows':[]};var _0x41310c=_['map'](db['SalesforceAccount'][_0x8e30('0x2a')],function(_0x32c282){return{'name':_0x32c282['fieldName'],'type':_0x32c282[_0x8e30('0x2b')][_0x8e30('0x2c')]};});_0x28bb21[_0x8e30('0x2d')]=_['map'](_0x41310c,_0x8e30('0x27'));_0x28bb21[_0x8e30('0x2e')]=_[_0x8e30('0x2f')](_0x48eaaa['query']);_0x28bb21[_0x8e30('0x30')]=_[_0x8e30('0x31')](_0x28bb21[_0x8e30('0x2d')],_0x28bb21['query']);_0x469bab['attributes']=_['intersection'](_0x28bb21['model'],qs[_0x8e30('0x32')](_0x48eaaa[_0x8e30('0x2e')][_0x8e30('0x32')]));_0x469bab[_0x8e30('0x33')]=_0x469bab[_0x8e30('0x33')]['length']?_0x469bab['attributes']:_0x28bb21['model'];if(!_0x48eaaa[_0x8e30('0x2e')][_0x8e30('0x34')](_0x8e30('0x35'))){_0x469bab[_0x8e30('0x1f')]=qs[_0x8e30('0x1f')](_0x48eaaa[_0x8e30('0x2e')]['limit']);_0x469bab[_0x8e30('0x1d')]=qs[_0x8e30('0x1d')](_0x48eaaa[_0x8e30('0x2e')]['offset']);}_0x469bab[_0x8e30('0x36')]=qs[_0x8e30('0x37')](_0x48eaaa[_0x8e30('0x2e')][_0x8e30('0x37')]);_0x469bab[_0x8e30('0x38')]=qs[_0x8e30('0x30')](_[_0x8e30('0x39')](_0x48eaaa['query'],_0x28bb21[_0x8e30('0x30')]),_0x41310c);if(_0x48eaaa[_0x8e30('0x2e')][_0x8e30('0x3a')]){_0x469bab[_0x8e30('0x38')]=_[_0x8e30('0x3b')](_0x469bab[_0x8e30('0x38')],{'$or':_[_0x8e30('0x3c')](_0x41310c,function(_0x49cc82){if(_0x49cc82[_0x8e30('0x2b')]!==_0x8e30('0x3d')){var _0x57aedd={};_0x57aedd[_0x49cc82[_0x8e30('0x27')]]={'$like':'%'+_0x48eaaa[_0x8e30('0x2e')][_0x8e30('0x3a')]+'%'};return _0x57aedd;}})});}_0x469bab=_[_0x8e30('0x3b')]({},_0x469bab,_0x48eaaa[_0x8e30('0x3e')]);var _0x1d5baf={'where':_0x469bab[_0x8e30('0x38')]};return db[_0x8e30('0x3f')][_0x8e30('0x20')](_0x1d5baf)[_0x8e30('0x24')](function(_0x8f8e03){_0x2e3164[_0x8e30('0x20')]=_0x8f8e03;if(_0x48eaaa[_0x8e30('0x2e')]['includeAll']){_0x469bab[_0x8e30('0x40')]=[{'all':!![]}];}return db[_0x8e30('0x3f')]['findAll'](_0x469bab);})[_0x8e30('0x24')](function(_0x33822e){_0x2e3164[_0x8e30('0x41')]=_0x33822e;return _0x2e3164;})[_0x8e30('0x24')](respondWithFilteredResult(_0x3d1697,_0x469bab))[_0x8e30('0x42')](handleError(_0x3d1697,null));};exports['show']=function(_0x2566ff,_0x1f7117){var _0x32acf0={'raw':![],'where':{'id':_0x2566ff[_0x8e30('0x43')]['id']}},_0x3ac576={};_0x3ac576[_0x8e30('0x2d')]=_[_0x8e30('0x2f')](db[_0x8e30('0x3f')][_0x8e30('0x2a')]);_0x3ac576[_0x8e30('0x2e')]=_['keys'](_0x2566ff[_0x8e30('0x2e')]);_0x3ac576['filters']=_['intersection'](_0x3ac576[_0x8e30('0x2d')],_0x3ac576['query']);_0x32acf0[_0x8e30('0x33')]=_['intersection'](_0x3ac576[_0x8e30('0x2d')],qs[_0x8e30('0x32')](_0x2566ff[_0x8e30('0x2e')][_0x8e30('0x32')]));_0x32acf0[_0x8e30('0x33')]=_0x32acf0['attributes'][_0x8e30('0x44')]?_0x32acf0['attributes']:_0x3ac576[_0x8e30('0x2d')];if(_0x2566ff[_0x8e30('0x2e')][_0x8e30('0x45')]){_0x32acf0[_0x8e30('0x40')]=[{'all':!![]}];}_0x32acf0=_['merge']({},_0x32acf0,_0x2566ff[_0x8e30('0x3e')]);return db['SalesforceAccount']['find'](_0x32acf0)[_0x8e30('0x24')](handleEntityNotFound(_0x1f7117,null))[_0x8e30('0x24')](respondWithResult(_0x1f7117,null))['catch'](handleError(_0x1f7117,null));};exports[_0x8e30('0x46')]=function(_0x24dfd0,_0x5b1df7){return db['SalesforceAccount'][_0x8e30('0x46')](_0x24dfd0[_0x8e30('0x47')],{})[_0x8e30('0x24')](respondWithResult(_0x5b1df7,0xc9))[_0x8e30('0x42')](handleError(_0x5b1df7,null));};exports[_0x8e30('0x48')]=function(_0x494c2a,_0x23ce46){if(_0x494c2a['body']['id']){delete _0x494c2a['body']['id'];}return db[_0x8e30('0x3f')][_0x8e30('0x49')]({'where':{'id':_0x494c2a['params']['id']}})['then'](handleEntityNotFound(_0x23ce46,null))['then'](saveUpdates(_0x494c2a[_0x8e30('0x47')],null))[_0x8e30('0x24')](respondWithResult(_0x23ce46,null))[_0x8e30('0x42')](handleError(_0x23ce46,null));};exports['destroy']=function(_0x3e627b,_0x41c0e1){return db[_0x8e30('0x3f')][_0x8e30('0x49')]({'where':{'id':_0x3e627b[_0x8e30('0x43')]['id']}})[_0x8e30('0x24')](handleEntityNotFound(_0x41c0e1,null))['then'](removeEntity(_0x41c0e1,null))[_0x8e30('0x42')](handleError(_0x41c0e1,null));};exports[_0x8e30('0x4a')]=function(_0x163a26,_0x53c7ba,_0x216f28){var _0x2eb27c={};var _0x2c31ab={};var _0x13a7b0;var _0x260e18;return db[_0x8e30('0x3f')][_0x8e30('0x4b')]({'where':{'id':_0x163a26['params']['id']}})[_0x8e30('0x24')](handleEntityNotFound(_0x53c7ba,null))[_0x8e30('0x24')](function(_0x1e76d1){if(_0x1e76d1){_0x13a7b0=_0x1e76d1;_0x2c31ab[_0x8e30('0x2d')]=_[_0x8e30('0x2f')](db[_0x8e30('0x4c')][_0x8e30('0x2a')]);_0x2c31ab['query']=_[_0x8e30('0x2f')](_0x163a26[_0x8e30('0x2e')]);_0x2c31ab[_0x8e30('0x30')]=_[_0x8e30('0x31')](_0x2c31ab[_0x8e30('0x2d')],_0x2c31ab[_0x8e30('0x2e')]);_0x2eb27c[_0x8e30('0x33')]=_[_0x8e30('0x31')](_0x2c31ab[_0x8e30('0x2d')],qs['fields'](_0x163a26[_0x8e30('0x2e')]['fields']));_0x2eb27c['attributes']=_0x2eb27c['attributes']['length']?_0x2eb27c[_0x8e30('0x33')]:_0x2c31ab[_0x8e30('0x2d')];_0x2eb27c[_0x8e30('0x36')]=qs[_0x8e30('0x37')](_0x163a26[_0x8e30('0x2e')][_0x8e30('0x37')]);_0x2eb27c[_0x8e30('0x38')]=qs[_0x8e30('0x30')](_[_0x8e30('0x39')](_0x163a26[_0x8e30('0x2e')],_0x2c31ab[_0x8e30('0x30')]));if(_0x163a26[_0x8e30('0x2e')]['filter']){_0x2eb27c[_0x8e30('0x38')]=_[_0x8e30('0x3b')](_0x2eb27c[_0x8e30('0x38')],{'$or':_[_0x8e30('0x3c')](_0x2eb27c[_0x8e30('0x33')],function(_0x94bcb7){var _0x29160a={};_0x29160a[_0x94bcb7]={'$like':'%'+_0x163a26['query'][_0x8e30('0x3a')]+'%'};return _0x29160a;})});}_0x2eb27c=_['merge']({},_0x2eb27c,_0x163a26[_0x8e30('0x3e')]);return _0x13a7b0[_0x8e30('0x4a')](_0x2eb27c);}})[_0x8e30('0x24')](function(_0x5a85bf){if(_0x5a85bf){_0x260e18=_0x5a85bf['length'];if(!_0x163a26[_0x8e30('0x2e')]['hasOwnProperty']('nolimit')){_0x2eb27c[_0x8e30('0x1f')]=qs[_0x8e30('0x1f')](_0x163a26[_0x8e30('0x2e')]['limit']);_0x2eb27c[_0x8e30('0x1d')]=qs[_0x8e30('0x1d')](_0x163a26[_0x8e30('0x2e')][_0x8e30('0x1d')]);}return _0x13a7b0[_0x8e30('0x4a')](_0x2eb27c);}})[_0x8e30('0x24')](function(_0x4ed66c){if(_0x4ed66c){return _0x4ed66c?{'count':_0x260e18,'rows':_0x4ed66c}:null;}})[_0x8e30('0x24')](respondWithResult(_0x53c7ba,null))[_0x8e30('0x42')](handleError(_0x53c7ba,null));};exports[_0x8e30('0x4d')]=function(_0x23c7b3,_0x3513ca,_0x2406e0){if(_0x23c7b3[_0x8e30('0x47')]['id']){delete _0x23c7b3['body']['id'];}return db[_0x8e30('0x3f')][_0x8e30('0x4b')]({'where':{'id':_0x23c7b3[_0x8e30('0x43')]['id']}})[_0x8e30('0x24')](handleEntityNotFound(_0x3513ca,null))['then'](function(_0x43f6c8){if(_0x43f6c8){_0x23c7b3[_0x8e30('0x47')][_0x8e30('0x4e')]=_0x43f6c8['id'];_0x23c7b3[_0x8e30('0x47')][_0x8e30('0x4f')]=integrations[_0x8e30('0x50')](_0x23c7b3[_0x8e30('0x47')][_0x8e30('0x51')],_0x23c7b3['body'][_0x8e30('0x2b')]);_0x23c7b3[_0x8e30('0x47')][_0x8e30('0x52')]=integrations[_0x8e30('0x53')](_0x23c7b3[_0x8e30('0x47')]['channel'],_0x23c7b3[_0x8e30('0x47')][_0x8e30('0x2b')]);return db[_0x8e30('0x4c')][_0x8e30('0x46')](_0x23c7b3['body'],{'include':[{'model':db[_0x8e30('0x54')],'as':'Subjects'},{'model':db[_0x8e30('0x54')],'as':'Descriptions'}]});}return null;})['then'](respondWithResult(_0x3513ca,null))[_0x8e30('0x42')](handleError(_0x3513ca,null));};exports[_0x8e30('0x55')]=function(_0x285ba2,_0x2df212,_0x86b125){var _0x1fccd6;var _0x651c31='';var _0x27b229='Task';return db[_0x8e30('0x3f')]['findOne']({'where':{'id':_0x285ba2[_0x8e30('0x43')]['id']},'attributes':['id',_0x8e30('0x56'),_0x8e30('0x57'),_0x8e30('0x58'),_0x8e30('0x59'),_0x8e30('0x5a'),_0x8e30('0x5b')]})[_0x8e30('0x24')](handleEntityNotFound(_0x2df212,null))[_0x8e30('0x24')](function(_0x2ea432){if(_0x2ea432){_0x651c31=_0x2ea432[_0x8e30('0x56')];var _0x586fce=_0x651c31[_0x8e30('0x5c')](-0x1);if(_0x586fce==='/'){_0x651c31=_0x651c31[_0x8e30('0x5d')](0x0,_0x651c31[_0x8e30('0x5e')](_0x586fce));}_0x1fccd6=new jsforce[(_0x8e30('0x5f'))]({'oauth2':{'loginUrl':_0x651c31,'clientId':_0x2ea432[_0x8e30('0x57')],'clientSecret':_0x2ea432[_0x8e30('0x58')]}});return _0x1fccd6['login'](_0x2ea432[_0x8e30('0x59')],_0x2ea432[_0x8e30('0x5a')][_0x8e30('0x60')](_0x2ea432['securityToken']));}})[_0x8e30('0x24')](function(_0x53763e){if(_0x53763e){if(!_[_0x8e30('0x61')](_0x285ba2['query']['ticketType'])){_0x27b229=_0x285ba2['query']['ticketType'];}return _0x1fccd6[_0x8e30('0x62')](_0x27b229)['describe']();}})[_0x8e30('0x24')](function(_0x19f03f){var _0x552235=['OwnerId',_0x8e30('0x63'),_0x8e30('0x64'),_0x8e30('0x65'),'Subject','Description'];var _0xb99c05=['string',_0x8e30('0x66'),_0x8e30('0x67'),_0x8e30('0x68'),_0x8e30('0x69'),_0x8e30('0x6a'),'phone'];if(_0x19f03f){_[_0x8e30('0x6b')](_0x19f03f[_0x8e30('0x32')],function(_0x1c6937){return _0x552235[_0x8e30('0x6c')](_0x1c6937[_0x8e30('0x27')])||!_0xb99c05[_0x8e30('0x6c')](_0x1c6937['type']);});return{'count':_0x19f03f[_0x8e30('0x32')][_0x8e30('0x44')],'rows':_[_0x8e30('0x3c')](_0x19f03f[_0x8e30('0x32')],function(_0x115a27){return{'id':_0x115a27[_0x8e30('0x27')],'name':_0x115a27[_0x8e30('0x6d')],'custom':_0x115a27[_0x8e30('0x6e')],'options':_0x115a27['picklistValues'][_0x8e30('0x44')]>0x0?_[_0x8e30('0x3c')](_0x115a27['picklistValues'],function(_0x39c2a0){return{'name':_0x39c2a0[_0x8e30('0x6d')],'value':_0x39c2a0[_0x8e30('0x6f')]};}):_0x115a27[_0x8e30('0x2b')]==_0x8e30('0x68')?[{'name':_0x8e30('0x70'),'value':'true'},{'name':_0x8e30('0x71'),'value':_0x8e30('0x72')}]:[]};})};}})['then'](respondWithResult(_0x2df212,null))[_0x8e30('0x42')](function(_0x5294b6){var _0x33ad33=_0x285ba2['query'][_0x8e30('0x73')]?0x1f4:_0x5294b6[_0x8e30('0x74')]||0x1f4;logger[_0x8e30('0x26')]('getFields,\x20%s,\x20%s,\x20%s',_0x8e30('0x55'),_0x33ad33,JSON[_0x8e30('0x75')](_0x5294b6));delete _0x5294b6[_0x8e30('0x27')];if(_0x33ad33===0x191){_0x33ad33=0x190;}_0x2df212['status'](_0x33ad33)[_0x8e30('0x28')](_0x285ba2[_0x8e30('0x2e')][_0x8e30('0x73')]?{'message':'Wrong\x20credentials','statusCode':_0x5294b6[_0x8e30('0x74')]}:_0x5294b6);});};