c0dc3a0f867f232eb41da4947529d96559f9a7c5
[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 _0x0a7f=['xCALLY\x20Motion\x20Integration','get_module_fields','module_fields','remove','values','test','statusCode','error','getFields,\x20%s,\x20%s,\x20%s','getFields','send','Wrong\x20credentials','zip-dir','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../components/integrations/configuration','sendStatus','status','end','json','offset','undefined','count','limit','Content-Range','apply','reject','update','then','name','map','SugarcrmAccount','model','query','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','type','VIRTUAL','options','includeAll','rows','catch','show','params','keys','rawAttributes','include','find','create','body','getConfigurations','findOne','SugarcrmConfiguration','addConfiguration','AccountId','Subjects','getSubjects','channel','Descriptions','SugarcrmField','assigned_user_id','created_by','date_start','duration_minutes','parent_type','parent_name','password','remoteUri','slice','substring','lastIndexOf','POST','format','%s%s','/service/v4_1/rest.php','login','JSON','stringify','PLAIN'];(function(_0x376c38,_0x48bc5a){var _0x249054=function(_0x2147ee){while(--_0x2147ee){_0x376c38['push'](_0x376c38['shift']());}};_0x249054(++_0x48bc5a);}(_0x0a7f,0xe6));var _0xf0a7=function(_0x5ed045,_0x5a7320){_0x5ed045=_0x5ed045-0x0;var _0x4a6362=_0x0a7f[_0x5ed045];return _0x4a6362;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0xf0a7('0x0'));var jsonpatch=require('fast-json-patch');var rp=require(_0xf0a7('0x1'));var moment=require(_0xf0a7('0x2'));var BPromise=require(_0xf0a7('0x3'));var Mustache=require(_0xf0a7('0x4'));var util=require(_0xf0a7('0x5'));var path=require(_0xf0a7('0x6'));var sox=require('sox');var csv=require(_0xf0a7('0x7'));var ejs=require(_0xf0a7('0x8'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require('lodash');var squel=require(_0xf0a7('0x9'));var crypto=require(_0xf0a7('0xa'));var jsforce=require(_0xf0a7('0xb'));var deskjs=require('desk.js');var toCsv=require(_0xf0a7('0x7'));var querystring=require(_0xf0a7('0xc'));var Papa=require(_0xf0a7('0xd'));var Redis=require(_0xf0a7('0xe'));var authService=require(_0xf0a7('0xf'));var qs=require(_0xf0a7('0x10'));var as=require(_0xf0a7('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xf0a7('0x12'))('api');var utils=require(_0xf0a7('0x13'));var config=require(_0xf0a7('0x14'));var licenseUtil=require(_0xf0a7('0x15'));var db=require('../../mysqldb')['db'];var integrations=require(_0xf0a7('0x16'));function respondWithStatusCode(_0x11c036,_0x23d5fe){_0x23d5fe=_0x23d5fe||0xcc;return function(_0x2804a8){if(_0x2804a8){return _0x11c036[_0xf0a7('0x17')](_0x23d5fe);}return _0x11c036[_0xf0a7('0x18')](_0x23d5fe)[_0xf0a7('0x19')]();};}function respondWithResult(_0x27e3b6,_0x5d5f7e){_0x5d5f7e=_0x5d5f7e||0xc8;return function(_0x2b3bae){if(_0x2b3bae){return _0x27e3b6[_0xf0a7('0x18')](_0x5d5f7e)[_0xf0a7('0x1a')](_0x2b3bae);}};}function respondWithFilteredResult(_0xaafb82,_0x3f457a){return function(_0x22a1fc){if(_0x22a1fc){var _0x163520=typeof _0x3f457a[_0xf0a7('0x1b')]===_0xf0a7('0x1c')&&typeof _0x3f457a['limit']==='undefined';var _0x196424=_0x22a1fc[_0xf0a7('0x1d')];var _0x271583=_0x163520?0x0:_0x3f457a[_0xf0a7('0x1b')];var _0x78ced8=_0x163520?_0x22a1fc[_0xf0a7('0x1d')]:_0x3f457a['offset']+_0x3f457a[_0xf0a7('0x1e')];var _0x16b98c;if(_0x78ced8>=_0x196424){_0x78ced8=_0x196424;_0x16b98c=0xc8;}else{_0x16b98c=0xce;}_0xaafb82[_0xf0a7('0x18')](_0x16b98c);return _0xaafb82['set'](_0xf0a7('0x1f'),_0x271583+'-'+_0x78ced8+'/'+_0x196424)[_0xf0a7('0x1a')](_0x22a1fc);}return null;};}function patchUpdates(_0x5ab854){return function(_0x3c7f0c){try{jsonpatch[_0xf0a7('0x20')](_0x3c7f0c,_0x5ab854,!![]);}catch(_0x1b534d){return BPromise[_0xf0a7('0x21')](_0x1b534d);}return _0x3c7f0c['save']();};}function saveUpdates(_0x49c5fc,_0x4f30d1){return function(_0x58bed1){if(_0x58bed1){return _0x58bed1[_0xf0a7('0x22')](_0x49c5fc)[_0xf0a7('0x23')](function(_0x411bc6){return _0x411bc6;});}return null;};}function removeEntity(_0xb0e2a,_0x29d9c9){return function(_0x4c56c1){if(_0x4c56c1){return _0x4c56c1['destroy']()['then'](function(){_0xb0e2a[_0xf0a7('0x18')](0xcc)[_0xf0a7('0x19')]();});}};}function handleEntityNotFound(_0x2cf972,_0x57010a){return function(_0x5798e1){if(!_0x5798e1){_0x2cf972[_0xf0a7('0x17')](0x194);}return _0x5798e1;};}function handleError(_0xa684a,_0x236b4c){_0x236b4c=_0x236b4c||0x1f4;return function(_0x1dbf6a){logger['error'](_0x1dbf6a['stack']);if(_0x1dbf6a['name']){delete _0x1dbf6a[_0xf0a7('0x24')];}_0xa684a['status'](_0x236b4c)['send'](_0x1dbf6a);};}exports['index']=function(_0x2405b0,_0x1380d6){var _0x387019={},_0x2e6b25={},_0x38d5f0={'count':0x0,'rows':[]};var _0x3be558=_[_0xf0a7('0x25')](db[_0xf0a7('0x26')]['rawAttributes'],function(_0x14a762){return{'name':_0x14a762['fieldName'],'type':_0x14a762['type']['key']};});_0x2e6b25[_0xf0a7('0x27')]=_['map'](_0x3be558,_0xf0a7('0x24'));_0x2e6b25[_0xf0a7('0x28')]=_['keys'](_0x2405b0[_0xf0a7('0x28')]);_0x2e6b25[_0xf0a7('0x29')]=_[_0xf0a7('0x2a')](_0x2e6b25['model'],_0x2e6b25['query']);_0x387019['attributes']=_[_0xf0a7('0x2a')](_0x2e6b25[_0xf0a7('0x27')],qs[_0xf0a7('0x2b')](_0x2405b0[_0xf0a7('0x28')][_0xf0a7('0x2b')]));_0x387019[_0xf0a7('0x2c')]=_0x387019[_0xf0a7('0x2c')][_0xf0a7('0x2d')]?_0x387019[_0xf0a7('0x2c')]:_0x2e6b25['model'];if(!_0x2405b0[_0xf0a7('0x28')][_0xf0a7('0x2e')](_0xf0a7('0x2f'))){_0x387019[_0xf0a7('0x1e')]=qs[_0xf0a7('0x1e')](_0x2405b0['query'][_0xf0a7('0x1e')]);_0x387019['offset']=qs[_0xf0a7('0x1b')](_0x2405b0[_0xf0a7('0x28')][_0xf0a7('0x1b')]);}_0x387019[_0xf0a7('0x30')]=qs[_0xf0a7('0x31')](_0x2405b0[_0xf0a7('0x28')][_0xf0a7('0x31')]);_0x387019['where']=qs[_0xf0a7('0x29')](_[_0xf0a7('0x32')](_0x2405b0[_0xf0a7('0x28')],_0x2e6b25[_0xf0a7('0x29')]),_0x3be558);if(_0x2405b0[_0xf0a7('0x28')][_0xf0a7('0x33')]){_0x387019[_0xf0a7('0x34')]=_[_0xf0a7('0x35')](_0x387019[_0xf0a7('0x34')],{'$or':_[_0xf0a7('0x25')](_0x3be558,function(_0x1359bb){if(_0x1359bb[_0xf0a7('0x36')]!==_0xf0a7('0x37')){var _0x52ca8e={};_0x52ca8e[_0x1359bb[_0xf0a7('0x24')]]={'$like':'%'+_0x2405b0[_0xf0a7('0x28')][_0xf0a7('0x33')]+'%'};return _0x52ca8e;}})});}_0x387019=_[_0xf0a7('0x35')]({},_0x387019,_0x2405b0[_0xf0a7('0x38')]);var _0x36098c={'where':_0x387019[_0xf0a7('0x34')]};return db[_0xf0a7('0x26')][_0xf0a7('0x1d')](_0x36098c)[_0xf0a7('0x23')](function(_0x5e1e95){_0x38d5f0[_0xf0a7('0x1d')]=_0x5e1e95;if(_0x2405b0[_0xf0a7('0x28')][_0xf0a7('0x39')]){_0x387019['include']=[{'all':!![]}];}return db['SugarcrmAccount']['findAll'](_0x387019);})[_0xf0a7('0x23')](function(_0x1c4cfc){_0x38d5f0[_0xf0a7('0x3a')]=_0x1c4cfc;return _0x38d5f0;})[_0xf0a7('0x23')](respondWithFilteredResult(_0x1380d6,_0x387019))[_0xf0a7('0x3b')](handleError(_0x1380d6,null));};exports[_0xf0a7('0x3c')]=function(_0x42cc54,_0x44cf8b){var _0x3278eb={'raw':![],'where':{'id':_0x42cc54[_0xf0a7('0x3d')]['id']}},_0x3c1144={};_0x3c1144['model']=_[_0xf0a7('0x3e')](db[_0xf0a7('0x26')][_0xf0a7('0x3f')]);_0x3c1144[_0xf0a7('0x28')]=_[_0xf0a7('0x3e')](_0x42cc54[_0xf0a7('0x28')]);_0x3c1144[_0xf0a7('0x29')]=_[_0xf0a7('0x2a')](_0x3c1144[_0xf0a7('0x27')],_0x3c1144[_0xf0a7('0x28')]);_0x3278eb[_0xf0a7('0x2c')]=_[_0xf0a7('0x2a')](_0x3c1144['model'],qs[_0xf0a7('0x2b')](_0x42cc54[_0xf0a7('0x28')][_0xf0a7('0x2b')]));_0x3278eb['attributes']=_0x3278eb[_0xf0a7('0x2c')][_0xf0a7('0x2d')]?_0x3278eb[_0xf0a7('0x2c')]:_0x3c1144[_0xf0a7('0x27')];if(_0x42cc54[_0xf0a7('0x28')][_0xf0a7('0x39')]){_0x3278eb[_0xf0a7('0x40')]=[{'all':!![]}];}_0x3278eb=_[_0xf0a7('0x35')]({},_0x3278eb,_0x42cc54[_0xf0a7('0x38')]);return db['SugarcrmAccount'][_0xf0a7('0x41')](_0x3278eb)[_0xf0a7('0x23')](handleEntityNotFound(_0x44cf8b,null))['then'](respondWithResult(_0x44cf8b,null))[_0xf0a7('0x3b')](handleError(_0x44cf8b,null));};exports[_0xf0a7('0x42')]=function(_0x2784f8,_0x48a2b0){return db['SugarcrmAccount'][_0xf0a7('0x42')](_0x2784f8[_0xf0a7('0x43')],{})['then'](respondWithResult(_0x48a2b0,0xc9))[_0xf0a7('0x3b')](handleError(_0x48a2b0,null));};exports['update']=function(_0x1fe20b,_0x45ce7c){if(_0x1fe20b[_0xf0a7('0x43')]['id']){delete _0x1fe20b[_0xf0a7('0x43')]['id'];}return db['SugarcrmAccount'][_0xf0a7('0x41')]({'where':{'id':_0x1fe20b[_0xf0a7('0x3d')]['id']}})[_0xf0a7('0x23')](handleEntityNotFound(_0x45ce7c,null))[_0xf0a7('0x23')](saveUpdates(_0x1fe20b[_0xf0a7('0x43')],null))[_0xf0a7('0x23')](respondWithResult(_0x45ce7c,null))[_0xf0a7('0x3b')](handleError(_0x45ce7c,null));};exports['destroy']=function(_0x579fd8,_0x325f0d){return db[_0xf0a7('0x26')][_0xf0a7('0x41')]({'where':{'id':_0x579fd8[_0xf0a7('0x3d')]['id']}})['then'](handleEntityNotFound(_0x325f0d,null))['then'](removeEntity(_0x325f0d,null))[_0xf0a7('0x3b')](handleError(_0x325f0d,null));};exports[_0xf0a7('0x44')]=function(_0x24a18f,_0x11d90e,_0x424e98){var _0x5ea63a={};var _0x525aa4={};var _0x3a356d;var _0x42d281;return db[_0xf0a7('0x26')][_0xf0a7('0x45')]({'where':{'id':_0x24a18f[_0xf0a7('0x3d')]['id']}})['then'](handleEntityNotFound(_0x11d90e,null))[_0xf0a7('0x23')](function(_0x222a9c){if(_0x222a9c){_0x3a356d=_0x222a9c;_0x525aa4['model']=_[_0xf0a7('0x3e')](db[_0xf0a7('0x46')][_0xf0a7('0x3f')]);_0x525aa4[_0xf0a7('0x28')]=_[_0xf0a7('0x3e')](_0x24a18f[_0xf0a7('0x28')]);_0x525aa4[_0xf0a7('0x29')]=_[_0xf0a7('0x2a')](_0x525aa4[_0xf0a7('0x27')],_0x525aa4[_0xf0a7('0x28')]);_0x5ea63a[_0xf0a7('0x2c')]=_['intersection'](_0x525aa4[_0xf0a7('0x27')],qs[_0xf0a7('0x2b')](_0x24a18f[_0xf0a7('0x28')]['fields']));_0x5ea63a[_0xf0a7('0x2c')]=_0x5ea63a[_0xf0a7('0x2c')]['length']?_0x5ea63a[_0xf0a7('0x2c')]:_0x525aa4[_0xf0a7('0x27')];_0x5ea63a['order']=qs[_0xf0a7('0x31')](_0x24a18f[_0xf0a7('0x28')][_0xf0a7('0x31')]);_0x5ea63a[_0xf0a7('0x34')]=qs[_0xf0a7('0x29')](_[_0xf0a7('0x32')](_0x24a18f[_0xf0a7('0x28')],_0x525aa4[_0xf0a7('0x29')]));if(_0x24a18f['query'][_0xf0a7('0x33')]){_0x5ea63a['where']=_[_0xf0a7('0x35')](_0x5ea63a['where'],{'$or':_[_0xf0a7('0x25')](_0x5ea63a[_0xf0a7('0x2c')],function(_0x1537d2){var _0x2535ce={};_0x2535ce[_0x1537d2]={'$like':'%'+_0x24a18f[_0xf0a7('0x28')][_0xf0a7('0x33')]+'%'};return _0x2535ce;})});}_0x5ea63a=_[_0xf0a7('0x35')]({},_0x5ea63a,_0x24a18f['options']);return _0x3a356d[_0xf0a7('0x44')](_0x5ea63a);}})[_0xf0a7('0x23')](function(_0x48d294){if(_0x48d294){_0x42d281=_0x48d294['length'];if(!_0x24a18f['query'][_0xf0a7('0x2e')]('nolimit')){_0x5ea63a[_0xf0a7('0x1e')]=qs[_0xf0a7('0x1e')](_0x24a18f[_0xf0a7('0x28')]['limit']);_0x5ea63a[_0xf0a7('0x1b')]=qs['offset'](_0x24a18f[_0xf0a7('0x28')][_0xf0a7('0x1b')]);}return _0x3a356d[_0xf0a7('0x44')](_0x5ea63a);}})[_0xf0a7('0x23')](function(_0x244eda){if(_0x244eda){return _0x244eda?{'count':_0x42d281,'rows':_0x244eda}:null;}})[_0xf0a7('0x23')](respondWithResult(_0x11d90e,null))[_0xf0a7('0x3b')](handleError(_0x11d90e,null));};exports[_0xf0a7('0x47')]=function(_0x48de9a,_0x307835,_0x1a01f3){if(_0x48de9a[_0xf0a7('0x43')]['id']){delete _0x48de9a[_0xf0a7('0x43')]['id'];}return db[_0xf0a7('0x26')]['findOne']({'where':{'id':_0x48de9a[_0xf0a7('0x3d')]['id']}})['then'](handleEntityNotFound(_0x307835,null))[_0xf0a7('0x23')](function(_0x164f35){if(_0x164f35){_0x48de9a['body'][_0xf0a7('0x48')]=_0x164f35['id'];_0x48de9a[_0xf0a7('0x43')][_0xf0a7('0x49')]=integrations[_0xf0a7('0x4a')](_0x48de9a[_0xf0a7('0x43')][_0xf0a7('0x4b')],_0x48de9a['body'][_0xf0a7('0x36')]);_0x48de9a[_0xf0a7('0x43')][_0xf0a7('0x4c')]=integrations['getDescriptions'](_0x48de9a[_0xf0a7('0x43')][_0xf0a7('0x4b')],_0x48de9a[_0xf0a7('0x43')][_0xf0a7('0x36')]);return db[_0xf0a7('0x46')][_0xf0a7('0x42')](_0x48de9a[_0xf0a7('0x43')],{'include':[{'model':db[_0xf0a7('0x4d')],'as':_0xf0a7('0x49')},{'model':db[_0xf0a7('0x4d')],'as':_0xf0a7('0x4c')}]});}return null;})['then'](respondWithResult(_0x307835,null))[_0xf0a7('0x3b')](handleError(_0x307835,null));};exports['getFields']=function(_0x1e869a,_0x39ae71,_0x49bfa2){var _0x3733ff='';var _0x429af1=['id',_0xf0a7('0x24'),_0xf0a7('0x4e'),_0xf0a7('0x4f'),'description',_0xf0a7('0x50'),'duration_hours',_0xf0a7('0x51'),'parent_id',_0xf0a7('0x52'),_0xf0a7('0x53'),'direction'];return db[_0xf0a7('0x26')][_0xf0a7('0x45')]({'where':{'id':_0x1e869a[_0xf0a7('0x3d')]['id']},'attributes':['id','username',_0xf0a7('0x54'),_0xf0a7('0x55')]})[_0xf0a7('0x23')](handleEntityNotFound(_0x39ae71,null))[_0xf0a7('0x23')](function(_0x4c9440){if(_0x4c9440){_0x3733ff=_0x4c9440[_0xf0a7('0x55')];var _0x3c7584=_0x3733ff[_0xf0a7('0x56')](-0x1);if(_0x3c7584==='/'){_0x3733ff=_0x3733ff[_0xf0a7('0x57')](0x0,_0x3733ff[_0xf0a7('0x58')](_0x3c7584));}return rp({'method':_0xf0a7('0x59'),'uri':util[_0xf0a7('0x5a')](_0xf0a7('0x5b'),_0x3733ff,_0xf0a7('0x5c')),'json':!![],'form':{'method':_0xf0a7('0x5d'),'input_type':_0xf0a7('0x5e'),'response_type':_0xf0a7('0x5e'),'rest_data':JSON[_0xf0a7('0x5f')]({'user_auth':{'user_name':_0x4c9440['username'],'password':_0x4c9440['password'],'encryption':_0xf0a7('0x60')},'application':_0xf0a7('0x61')})}});}})[_0xf0a7('0x23')](function(_0x21fa21){if(_0x21fa21&&_0x21fa21['name']!=='Invalid\x20Login'&&_0x21fa21[_0xf0a7('0x24')]!=='Password\x20Expired'){return rp({'method':_0xf0a7('0x59'),'uri':util['format'](_0xf0a7('0x5b'),_0x3733ff,_0xf0a7('0x5c')),'json':!![],'form':{'method':_0xf0a7('0x62'),'input_type':_0xf0a7('0x5e'),'response_type':'JSON','rest_data':JSON['stringify']({'session':_0x21fa21['id'],'module_name':'Calls'})}})[_0xf0a7('0x23')](function(_0x17a8f1){if(_0x17a8f1){var _0x54e68c=_['values'](_0x17a8f1[_0xf0a7('0x63')]);_[_0xf0a7('0x64')](_0x54e68c,function(_0x2eb43f){return _0x429af1['includes'](_0x2eb43f['name']);});return{'count':_0x54e68c[_0xf0a7('0x2d')],'rows':_[_0xf0a7('0x25')](_0x54e68c,function(_0x5208bc){return{'id':_0x5208bc[_0xf0a7('0x24')],'name':_0x5208bc['label'],'custom':_['endsWith'](_0x5208bc[_0xf0a7('0x24')],'_c')?!![]:![],'options':_0x5208bc[_0xf0a7('0x38')]?_[_0xf0a7('0x25')](_[_0xf0a7('0x65')](_0x5208bc[_0xf0a7('0x38')]),function(_0x5bd6ce){return{'name':_0x5bd6ce['value'],'value':_0x5bd6ce[_0xf0a7('0x24')]};}):[]};})};}})[_0xf0a7('0x23')](respondWithResult(_0x39ae71,null))[_0xf0a7('0x3b')](function(_0x12db8e){var _0x31f058=_0x1e869a[_0xf0a7('0x28')][_0xf0a7('0x66')]?0x1f4:_0x12db8e[_0xf0a7('0x67')]||0x1f4;logger[_0xf0a7('0x68')](_0xf0a7('0x69'),_0xf0a7('0x6a'),_0x31f058,JSON[_0xf0a7('0x5f')](_0x12db8e));delete _0x12db8e[_0xf0a7('0x24')];if(_0x31f058===0x191){_0x31f058=0x190;}_0x39ae71[_0xf0a7('0x18')](_0x31f058)[_0xf0a7('0x6b')](_0x1e869a[_0xf0a7('0x28')][_0xf0a7('0x66')]?{'message':_0xf0a7('0x6c'),'statusCode':_0x12db8e['statusCode']}:_0x12db8e);});}else{var _0xaf7af9=0x1f4;_0x39ae71[_0xf0a7('0x18')](_0xaf7af9)[_0xf0a7('0x6b')]({'message':_0xf0a7('0x6c'),'statusCode':0x190});}});};