dcf1121cf64c60e44ca5786b43bc1b1610e9e207
[motion2.git] / server / api / intSugarcrmAccount / intSugarcrmAccount.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 _0x4717=['substring','POST','%s%s','/service/v4_1/rest.php','login','JSON','stringify','PLAIN','xCALLY\x20Motion\x20Integration','Invalid\x20Login','Password\x20Expired','format','get_module_fields','Calls','values','module_fields','label','endsWith','getFields,\x20%s,\x20%s,\x20%s','send','Wrong\x20credentials','rimraf','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','api','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','count','set','apply','reject','save','update','then','destroy','stack','name','index','map','SugarcrmAccount','rawAttributes','type','model','keys','query','filters','attributes','fields','nolimit','order','sort','where','filter','merge','options','includeAll','include','findAll','rows','params','intersection','length','find','catch','create','body','findOne','pick','getConfigurations','hasOwnProperty','addConfiguration','Subjects','channel','Descriptions','getDescriptions','SugarcrmConfiguration','SugarcrmField','assigned_user_id','created_by','date_start','duration_hours','duration_minutes','parent_type','parent_name','direction','username','password','remoteUri','slice'];(function(_0x12129a,_0x13b125){var _0x22af91=function(_0x2da53b){while(--_0x2da53b){_0x12129a['push'](_0x12129a['shift']());}};_0x22af91(++_0x13b125);}(_0x4717,0x1e1));var _0x7471=function(_0x363ef8,_0x4ecb1a){_0x363ef8=_0x363ef8-0x0;var _0x148822=_0x4717[_0x363ef8];return _0x148822;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x7471('0x0'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0x7471('0x1'));var moment=require(_0x7471('0x2'));var BPromise=require(_0x7471('0x3'));var Mustache=require(_0x7471('0x4'));var util=require(_0x7471('0x5'));var path=require(_0x7471('0x6'));var sox=require(_0x7471('0x7'));var csv=require(_0x7471('0x8'));var ejs=require(_0x7471('0x9'));var fs=require('fs');var fs_extra=require(_0x7471('0xa'));var _=require(_0x7471('0xb'));var squel=require(_0x7471('0xc'));var crypto=require('crypto');var jsforce=require(_0x7471('0xd'));var deskjs=require(_0x7471('0xe'));var toCsv=require(_0x7471('0x8'));var querystring=require(_0x7471('0xf'));var Papa=require(_0x7471('0x10'));var Redis=require(_0x7471('0x11'));var authService=require(_0x7471('0x12'));var qs=require(_0x7471('0x13'));var as=require(_0x7471('0x14'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0x7471('0x15'));var utils=require(_0x7471('0x16'));var config=require('../../config/environment');var licenseUtil=require(_0x7471('0x17'));var db=require(_0x7471('0x18'))['db'];var integrations=require('../../components/integrations/configuration');function respondWithStatusCode(_0x4c7a7b,_0x52bb65){_0x52bb65=_0x52bb65||0xcc;return function(_0x163350){if(_0x163350){return _0x4c7a7b[_0x7471('0x19')](_0x52bb65);}return _0x4c7a7b[_0x7471('0x1a')](_0x52bb65)[_0x7471('0x1b')]();};}function respondWithResult(_0x1aeb7e,_0xdf38bf){_0xdf38bf=_0xdf38bf||0xc8;return function(_0x327573){if(_0x327573){return _0x1aeb7e[_0x7471('0x1a')](_0xdf38bf)[_0x7471('0x1c')](_0x327573);}};}function respondWithFilteredResult(_0x4c006b,_0x49f518){return function(_0x2417bc){if(_0x2417bc){var _0x5d754e=typeof _0x49f518[_0x7471('0x1d')]===_0x7471('0x1e')&&typeof _0x49f518[_0x7471('0x1f')]===_0x7471('0x1e');var _0x50aac1=_0x2417bc[_0x7471('0x20')];var _0x16a659=_0x5d754e?0x0:_0x49f518[_0x7471('0x1d')];var _0x10dd73=_0x5d754e?_0x2417bc[_0x7471('0x20')]:_0x49f518[_0x7471('0x1d')]+_0x49f518[_0x7471('0x1f')];var _0x27ea7d;if(_0x10dd73>=_0x50aac1){_0x10dd73=_0x50aac1;_0x27ea7d=0xc8;}else{_0x27ea7d=0xce;}_0x4c006b[_0x7471('0x1a')](_0x27ea7d);return _0x4c006b[_0x7471('0x21')]('Content-Range',_0x16a659+'-'+_0x10dd73+'/'+_0x50aac1)[_0x7471('0x1c')](_0x2417bc);}return null;};}function patchUpdates(_0x212ad5){return function(_0x16f839){try{jsonpatch[_0x7471('0x22')](_0x16f839,_0x212ad5,!![]);}catch(_0x50082c){return BPromise[_0x7471('0x23')](_0x50082c);}return _0x16f839[_0x7471('0x24')]();};}function saveUpdates(_0x4343c1,_0xae1ae4){return function(_0x46eb94){if(_0x46eb94){return _0x46eb94[_0x7471('0x25')](_0x4343c1)[_0x7471('0x26')](function(_0x55ffd9){return _0x55ffd9;});}return null;};}function removeEntity(_0x72fc62,_0x354cb1){return function(_0x550fb9){if(_0x550fb9){return _0x550fb9[_0x7471('0x27')]()['then'](function(){_0x72fc62['status'](0xcc)[_0x7471('0x1b')]();});}};}function handleEntityNotFound(_0x55bde8,_0x19f019){return function(_0x3eebef){if(!_0x3eebef){_0x55bde8[_0x7471('0x19')](0x194);}return _0x3eebef;};}function handleError(_0x191837,_0x343539){_0x343539=_0x343539||0x1f4;return function(_0x90bbf2){logger['error'](_0x90bbf2[_0x7471('0x28')]);if(_0x90bbf2['name']){delete _0x90bbf2[_0x7471('0x29')];}_0x191837[_0x7471('0x1a')](_0x343539)['send'](_0x90bbf2);};}exports[_0x7471('0x2a')]=function(_0x51c425,_0x2b6af0){var _0x54d3f9={},_0x4f854a={},_0x199d06={'count':0x0,'rows':[]};var _0x1a7775=_[_0x7471('0x2b')](db[_0x7471('0x2c')][_0x7471('0x2d')],function(_0x392406){return{'name':_0x392406['fieldName'],'type':_0x392406[_0x7471('0x2e')]['key']};});_0x4f854a[_0x7471('0x2f')]=_[_0x7471('0x2b')](_0x1a7775,_0x7471('0x29'));_0x4f854a['query']=_[_0x7471('0x30')](_0x51c425[_0x7471('0x31')]);_0x4f854a[_0x7471('0x32')]=_['intersection'](_0x4f854a[_0x7471('0x2f')],_0x4f854a[_0x7471('0x31')]);_0x54d3f9[_0x7471('0x33')]=_['intersection'](_0x4f854a[_0x7471('0x2f')],qs['fields'](_0x51c425[_0x7471('0x31')][_0x7471('0x34')]));_0x54d3f9[_0x7471('0x33')]=_0x54d3f9['attributes']['length']?_0x54d3f9[_0x7471('0x33')]:_0x4f854a[_0x7471('0x2f')];if(!_0x51c425[_0x7471('0x31')]['hasOwnProperty'](_0x7471('0x35'))){_0x54d3f9[_0x7471('0x1f')]=qs[_0x7471('0x1f')](_0x51c425['query'][_0x7471('0x1f')]);_0x54d3f9[_0x7471('0x1d')]=qs[_0x7471('0x1d')](_0x51c425[_0x7471('0x31')][_0x7471('0x1d')]);}_0x54d3f9[_0x7471('0x36')]=qs['sort'](_0x51c425['query'][_0x7471('0x37')]);_0x54d3f9[_0x7471('0x38')]=qs[_0x7471('0x32')](_['pick'](_0x51c425['query'],_0x4f854a[_0x7471('0x32')]),_0x1a7775);if(_0x51c425[_0x7471('0x31')][_0x7471('0x39')]){_0x54d3f9[_0x7471('0x38')]=_[_0x7471('0x3a')](_0x54d3f9[_0x7471('0x38')],{'$or':_['map'](_0x1a7775,function(_0x342219){if(_0x342219[_0x7471('0x2e')]!=='VIRTUAL'){var _0x521857={};_0x521857[_0x342219[_0x7471('0x29')]]={'$like':'%'+_0x51c425[_0x7471('0x31')]['filter']+'%'};return _0x521857;}})});}_0x54d3f9=_['merge']({},_0x54d3f9,_0x51c425[_0x7471('0x3b')]);var _0x47ceb8={'where':_0x54d3f9[_0x7471('0x38')]};return db[_0x7471('0x2c')][_0x7471('0x20')](_0x47ceb8)[_0x7471('0x26')](function(_0x56b568){_0x199d06['count']=_0x56b568;if(_0x51c425[_0x7471('0x31')][_0x7471('0x3c')]){_0x54d3f9[_0x7471('0x3d')]=[{'all':!![]}];}return db['SugarcrmAccount'][_0x7471('0x3e')](_0x54d3f9);})[_0x7471('0x26')](function(_0x134397){_0x199d06[_0x7471('0x3f')]=_0x134397;return _0x199d06;})['then'](respondWithFilteredResult(_0x2b6af0,_0x54d3f9))['catch'](handleError(_0x2b6af0,null));};exports['show']=function(_0x117969,_0x58a96e){var _0x4ce1a5={'raw':![],'where':{'id':_0x117969[_0x7471('0x40')]['id']}},_0x45ca9e={};_0x45ca9e[_0x7471('0x2f')]=_[_0x7471('0x30')](db[_0x7471('0x2c')][_0x7471('0x2d')]);_0x45ca9e['query']=_[_0x7471('0x30')](_0x117969[_0x7471('0x31')]);_0x45ca9e[_0x7471('0x32')]=_[_0x7471('0x41')](_0x45ca9e[_0x7471('0x2f')],_0x45ca9e[_0x7471('0x31')]);_0x4ce1a5[_0x7471('0x33')]=_[_0x7471('0x41')](_0x45ca9e['model'],qs[_0x7471('0x34')](_0x117969[_0x7471('0x31')]['fields']));_0x4ce1a5[_0x7471('0x33')]=_0x4ce1a5['attributes'][_0x7471('0x42')]?_0x4ce1a5[_0x7471('0x33')]:_0x45ca9e['model'];if(_0x117969[_0x7471('0x31')]['includeAll']){_0x4ce1a5[_0x7471('0x3d')]=[{'all':!![]}];}_0x4ce1a5=_[_0x7471('0x3a')]({},_0x4ce1a5,_0x117969[_0x7471('0x3b')]);return db[_0x7471('0x2c')][_0x7471('0x43')](_0x4ce1a5)[_0x7471('0x26')](handleEntityNotFound(_0x58a96e,null))['then'](respondWithResult(_0x58a96e,null))[_0x7471('0x44')](handleError(_0x58a96e,null));};exports[_0x7471('0x45')]=function(_0xeb4e87,_0x56da4b){return db[_0x7471('0x2c')][_0x7471('0x45')](_0xeb4e87['body'],{})[_0x7471('0x26')](respondWithResult(_0x56da4b,0xc9))[_0x7471('0x44')](handleError(_0x56da4b,null));};exports[_0x7471('0x25')]=function(_0xfddaee,_0x1d3bba){if(_0xfddaee[_0x7471('0x46')]['id']){delete _0xfddaee['body']['id'];}return db[_0x7471('0x2c')][_0x7471('0x43')]({'where':{'id':_0xfddaee[_0x7471('0x40')]['id']}})[_0x7471('0x26')](handleEntityNotFound(_0x1d3bba,null))[_0x7471('0x26')](saveUpdates(_0xfddaee[_0x7471('0x46')],null))['then'](respondWithResult(_0x1d3bba,null))[_0x7471('0x44')](handleError(_0x1d3bba,null));};exports[_0x7471('0x27')]=function(_0x587c94,_0x2007d9){return db[_0x7471('0x2c')][_0x7471('0x43')]({'where':{'id':_0x587c94['params']['id']}})[_0x7471('0x26')](handleEntityNotFound(_0x2007d9,null))[_0x7471('0x26')](removeEntity(_0x2007d9,null))[_0x7471('0x44')](handleError(_0x2007d9,null));};exports['getConfigurations']=function(_0x54e2b2,_0x180017,_0xe1a65c){var _0x448581={};var _0x3865aa={};var _0x2fdf85;var _0x36927e;return db[_0x7471('0x2c')][_0x7471('0x47')]({'where':{'id':_0x54e2b2[_0x7471('0x40')]['id']}})[_0x7471('0x26')](handleEntityNotFound(_0x180017,null))['then'](function(_0x4ef46f){if(_0x4ef46f){_0x2fdf85=_0x4ef46f;_0x3865aa['model']=_[_0x7471('0x30')](db['SugarcrmConfiguration'][_0x7471('0x2d')]);_0x3865aa[_0x7471('0x31')]=_[_0x7471('0x30')](_0x54e2b2[_0x7471('0x31')]);_0x3865aa[_0x7471('0x32')]=_[_0x7471('0x41')](_0x3865aa[_0x7471('0x2f')],_0x3865aa[_0x7471('0x31')]);_0x448581[_0x7471('0x33')]=_[_0x7471('0x41')](_0x3865aa[_0x7471('0x2f')],qs[_0x7471('0x34')](_0x54e2b2[_0x7471('0x31')][_0x7471('0x34')]));_0x448581[_0x7471('0x33')]=_0x448581['attributes']['length']?_0x448581[_0x7471('0x33')]:_0x3865aa[_0x7471('0x2f')];_0x448581[_0x7471('0x36')]=qs[_0x7471('0x37')](_0x54e2b2[_0x7471('0x31')][_0x7471('0x37')]);_0x448581[_0x7471('0x38')]=qs[_0x7471('0x32')](_[_0x7471('0x48')](_0x54e2b2['query'],_0x3865aa['filters']));if(_0x54e2b2[_0x7471('0x31')]['filter']){_0x448581[_0x7471('0x38')]=_['merge'](_0x448581[_0x7471('0x38')],{'$or':_[_0x7471('0x2b')](_0x448581[_0x7471('0x33')],function(_0x559141){var _0x37b596={};_0x37b596[_0x559141]={'$like':'%'+_0x54e2b2[_0x7471('0x31')][_0x7471('0x39')]+'%'};return _0x37b596;})});}_0x448581=_[_0x7471('0x3a')]({},_0x448581,_0x54e2b2['options']);return _0x2fdf85[_0x7471('0x49')](_0x448581);}})[_0x7471('0x26')](function(_0x4eda6b){if(_0x4eda6b){_0x36927e=_0x4eda6b[_0x7471('0x42')];if(!_0x54e2b2[_0x7471('0x31')][_0x7471('0x4a')]('nolimit')){_0x448581[_0x7471('0x1f')]=qs[_0x7471('0x1f')](_0x54e2b2['query'][_0x7471('0x1f')]);_0x448581[_0x7471('0x1d')]=qs['offset'](_0x54e2b2[_0x7471('0x31')][_0x7471('0x1d')]);}return _0x2fdf85[_0x7471('0x49')](_0x448581);}})[_0x7471('0x26')](function(_0x43ee44){if(_0x43ee44){return _0x43ee44?{'count':_0x36927e,'rows':_0x43ee44}:null;}})[_0x7471('0x26')](respondWithResult(_0x180017,null))['catch'](handleError(_0x180017,null));};exports[_0x7471('0x4b')]=function(_0x183d14,_0x2b308f,_0x1f1957){if(_0x183d14[_0x7471('0x46')]['id']){delete _0x183d14[_0x7471('0x46')]['id'];}return db[_0x7471('0x2c')]['findOne']({'where':{'id':_0x183d14['params']['id']}})[_0x7471('0x26')](handleEntityNotFound(_0x2b308f,null))[_0x7471('0x26')](function(_0xb216c3){if(_0xb216c3){_0x183d14[_0x7471('0x46')]['AccountId']=_0xb216c3['id'];_0x183d14[_0x7471('0x46')][_0x7471('0x4c')]=integrations['getSubjects'](_0x183d14[_0x7471('0x46')][_0x7471('0x4d')],_0x183d14['body']['type']);_0x183d14['body'][_0x7471('0x4e')]=integrations[_0x7471('0x4f')](_0x183d14[_0x7471('0x46')]['channel'],_0x183d14[_0x7471('0x46')][_0x7471('0x2e')]);return db[_0x7471('0x50')][_0x7471('0x45')](_0x183d14[_0x7471('0x46')],{'include':[{'model':db[_0x7471('0x51')],'as':'Subjects'},{'model':db[_0x7471('0x51')],'as':'Descriptions'}]});}return null;})[_0x7471('0x26')](respondWithResult(_0x2b308f,null))['catch'](handleError(_0x2b308f,null));};exports['getFields']=function(_0x2f51d7,_0x30a80b,_0x5386b9){var _0x1b559a='';var _0x917239=['id','name',_0x7471('0x52'),_0x7471('0x53'),'description',_0x7471('0x54'),_0x7471('0x55'),_0x7471('0x56'),'parent_id',_0x7471('0x57'),_0x7471('0x58'),_0x7471('0x59')];return db[_0x7471('0x2c')][_0x7471('0x47')]({'where':{'id':_0x2f51d7[_0x7471('0x40')]['id']},'attributes':['id',_0x7471('0x5a'),_0x7471('0x5b'),_0x7471('0x5c')]})[_0x7471('0x26')](handleEntityNotFound(_0x30a80b,null))[_0x7471('0x26')](function(_0x3e0817){if(_0x3e0817){_0x1b559a=_0x3e0817['remoteUri'];var _0x14fc58=_0x1b559a[_0x7471('0x5d')](-0x1);if(_0x14fc58==='/'){_0x1b559a=_0x1b559a[_0x7471('0x5e')](0x0,_0x1b559a['lastIndexOf'](_0x14fc58));}return rp({'method':_0x7471('0x5f'),'uri':util['format'](_0x7471('0x60'),_0x1b559a,_0x7471('0x61')),'json':!![],'form':{'method':_0x7471('0x62'),'input_type':_0x7471('0x63'),'response_type':'JSON','rest_data':JSON[_0x7471('0x64')]({'user_auth':{'user_name':_0x3e0817[_0x7471('0x5a')],'password':_0x3e0817[_0x7471('0x5b')],'encryption':_0x7471('0x65')},'application':_0x7471('0x66')})}});}})[_0x7471('0x26')](function(_0x532596){if(_0x532596&&_0x532596['name']!==_0x7471('0x67')&&_0x532596[_0x7471('0x29')]!==_0x7471('0x68')){return rp({'method':'POST','uri':util[_0x7471('0x69')]('%s%s',_0x1b559a,_0x7471('0x61')),'json':!![],'form':{'method':_0x7471('0x6a'),'input_type':_0x7471('0x63'),'response_type':_0x7471('0x63'),'rest_data':JSON[_0x7471('0x64')]({'session':_0x532596['id'],'module_name':_0x7471('0x6b')})}})['then'](function(_0x5d2af6){if(_0x5d2af6){var _0x417605=_[_0x7471('0x6c')](_0x5d2af6[_0x7471('0x6d')]);_['remove'](_0x417605,function(_0xf0c41c){return _0x917239['includes'](_0xf0c41c[_0x7471('0x29')]);});return{'count':_0x417605[_0x7471('0x42')],'rows':_['map'](_0x417605,function(_0x1be62d){return{'id':_0x1be62d[_0x7471('0x29')],'name':_0x1be62d[_0x7471('0x6e')],'custom':_[_0x7471('0x6f')](_0x1be62d[_0x7471('0x29')],'_c')?!![]:![],'options':_0x1be62d[_0x7471('0x3b')]?_[_0x7471('0x2b')](_[_0x7471('0x6c')](_0x1be62d['options']),function(_0x36600b){return{'name':_0x36600b['value'],'value':_0x36600b[_0x7471('0x29')]};}):[]};})};}})['then'](respondWithResult(_0x30a80b,null))['catch'](function(_0x42f1bb){var _0x35fea8=_0x2f51d7[_0x7471('0x31')]['test']?0x1f4:_0x42f1bb['statusCode']||0x1f4;logger['error'](_0x7471('0x70'),'getFields',_0x35fea8,JSON[_0x7471('0x64')](_0x42f1bb));delete _0x42f1bb[_0x7471('0x29')];if(_0x35fea8===0x191){_0x35fea8=0x190;}_0x30a80b[_0x7471('0x1a')](_0x35fea8)[_0x7471('0x71')](_0x2f51d7[_0x7471('0x31')]['test']?{'message':_0x7471('0x72'),'statusCode':_0x42f1bb['statusCode']}:_0x42f1bb);});}else{var _0x5d5425=0x1f4;_0x30a80b[_0x7471('0x1a')](_0x5d5425)['send']({'message':_0x7471('0x72'),'statusCode':0x190});}});};