Built motion from commit 4d4d9a88.|2.6.26
[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 _0xabb6=['crypto','jsforce','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','../../components/integrations/configuration','status','end','json','undefined','limit','count','offset','set','apply','reject','save','update','then','destroy','sendStatus','error','stack','name','send','index','map','SugarcrmAccount','rawAttributes','fieldName','type','key','model','query','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','params','keys','find','create','body','findOne','SugarcrmConfiguration','getConfigurations','Subjects','getDescriptions','channel','SugarcrmField','created_by','date_start','duration_hours','parent_type','username','password','remoteUri','slice','substring','POST','format','login','JSON','stringify','PLAIN','Password\x20Expired','%s%s','/service/v4_1/rest.php','get_module_fields','Calls','values','module_fields','remove','includes','label','endsWith','test','statusCode','getFields,\x20%s,\x20%s,\x20%s','getFields','Wrong\x20credentials','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','util','sox','to-csv','ejs','squel'];(function(_0xcdc4a2,_0x3996d3){var _0x31c30f=function(_0x2044de){while(--_0x2044de){_0xcdc4a2['push'](_0xcdc4a2['shift']());}};_0x31c30f(++_0x3996d3);}(_0xabb6,0x151));var _0x6abb=function(_0x2402ab,_0x110d5a){_0x2402ab=_0x2402ab-0x0;var _0x1c7a9e=_0xabb6[_0x2402ab];return _0x1c7a9e;};'use strict';var emlformat=require(_0x6abb('0x0'));var rimraf=require(_0x6abb('0x1'));var zipdir=require(_0x6abb('0x2'));var jsonpatch=require(_0x6abb('0x3'));var rp=require(_0x6abb('0x4'));var moment=require('moment');var BPromise=require(_0x6abb('0x5'));var Mustache=require('mustache');var util=require(_0x6abb('0x6'));var path=require('path');var sox=require(_0x6abb('0x7'));var csv=require(_0x6abb('0x8'));var ejs=require(_0x6abb('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require('lodash');var squel=require(_0x6abb('0xa'));var crypto=require(_0x6abb('0xb'));var jsforce=require(_0x6abb('0xc'));var deskjs=require('desk.js');var toCsv=require(_0x6abb('0x8'));var querystring=require(_0x6abb('0xd'));var Papa=require('papaparse');var Redis=require(_0x6abb('0xe'));var authService=require(_0x6abb('0xf'));var qs=require(_0x6abb('0x10'));var as=require(_0x6abb('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0x6abb('0x12'));var utils=require(_0x6abb('0x13'));var config=require(_0x6abb('0x14'));var licenseUtil=require(_0x6abb('0x15'));var db=require(_0x6abb('0x16'))['db'];var integrations=require(_0x6abb('0x17'));function respondWithStatusCode(_0x4a4a9f,_0x44d840){_0x44d840=_0x44d840||0xcc;return function(_0x236dca){if(_0x236dca){return _0x4a4a9f['sendStatus'](_0x44d840);}return _0x4a4a9f[_0x6abb('0x18')](_0x44d840)[_0x6abb('0x19')]();};}function respondWithResult(_0x367ab7,_0x471c23){_0x471c23=_0x471c23||0xc8;return function(_0x191d4b){if(_0x191d4b){return _0x367ab7[_0x6abb('0x18')](_0x471c23)[_0x6abb('0x1a')](_0x191d4b);}};}function respondWithFilteredResult(_0x240c16,_0x36acd2){return function(_0x543094){if(_0x543094){var _0x348f58=typeof _0x36acd2['offset']===_0x6abb('0x1b')&&typeof _0x36acd2[_0x6abb('0x1c')]===_0x6abb('0x1b');var _0x40ef3c=_0x543094[_0x6abb('0x1d')];var _0x3a8d6c=_0x348f58?0x0:_0x36acd2[_0x6abb('0x1e')];var _0x5065e4=_0x348f58?_0x543094[_0x6abb('0x1d')]:_0x36acd2[_0x6abb('0x1e')]+_0x36acd2['limit'];var _0xc59fd3;if(_0x5065e4>=_0x40ef3c){_0x5065e4=_0x40ef3c;_0xc59fd3=0xc8;}else{_0xc59fd3=0xce;}_0x240c16['status'](_0xc59fd3);return _0x240c16[_0x6abb('0x1f')]('Content-Range',_0x3a8d6c+'-'+_0x5065e4+'/'+_0x40ef3c)[_0x6abb('0x1a')](_0x543094);}return null;};}function patchUpdates(_0x257deb){return function(_0x22b748){try{jsonpatch[_0x6abb('0x20')](_0x22b748,_0x257deb,!![]);}catch(_0x127c5f){return BPromise[_0x6abb('0x21')](_0x127c5f);}return _0x22b748[_0x6abb('0x22')]();};}function saveUpdates(_0x2d71a6,_0x1efd00){return function(_0x3f6260){if(_0x3f6260){return _0x3f6260[_0x6abb('0x23')](_0x2d71a6)[_0x6abb('0x24')](function(_0x3bf75f){return _0x3bf75f;});}return null;};}function removeEntity(_0x233d57,_0x50b08f){return function(_0x41480c){if(_0x41480c){return _0x41480c[_0x6abb('0x25')]()['then'](function(){_0x233d57[_0x6abb('0x18')](0xcc)['end']();});}};}function handleEntityNotFound(_0x4e0062,_0x456a46){return function(_0x20c0ab){if(!_0x20c0ab){_0x4e0062[_0x6abb('0x26')](0x194);}return _0x20c0ab;};}function handleError(_0x9d9ec4,_0x2d7c79){_0x2d7c79=_0x2d7c79||0x1f4;return function(_0x5b9cb2){logger[_0x6abb('0x27')](_0x5b9cb2[_0x6abb('0x28')]);if(_0x5b9cb2['name']){delete _0x5b9cb2[_0x6abb('0x29')];}_0x9d9ec4['status'](_0x2d7c79)[_0x6abb('0x2a')](_0x5b9cb2);};}exports[_0x6abb('0x2b')]=function(_0x334308,_0x5ad943){var _0x5c80ca={},_0x591e07={},_0x3c7798={'count':0x0,'rows':[]};var _0x52414d=_[_0x6abb('0x2c')](db[_0x6abb('0x2d')][_0x6abb('0x2e')],function(_0x512745){return{'name':_0x512745[_0x6abb('0x2f')],'type':_0x512745[_0x6abb('0x30')][_0x6abb('0x31')]};});_0x591e07[_0x6abb('0x32')]=_[_0x6abb('0x2c')](_0x52414d,_0x6abb('0x29'));_0x591e07[_0x6abb('0x33')]=_['keys'](_0x334308[_0x6abb('0x33')]);_0x591e07[_0x6abb('0x34')]=_['intersection'](_0x591e07[_0x6abb('0x32')],_0x591e07['query']);_0x5c80ca['attributes']=_[_0x6abb('0x35')](_0x591e07[_0x6abb('0x32')],qs['fields'](_0x334308[_0x6abb('0x33')][_0x6abb('0x36')]));_0x5c80ca[_0x6abb('0x37')]=_0x5c80ca[_0x6abb('0x37')][_0x6abb('0x38')]?_0x5c80ca['attributes']:_0x591e07[_0x6abb('0x32')];if(!_0x334308[_0x6abb('0x33')][_0x6abb('0x39')](_0x6abb('0x3a'))){_0x5c80ca[_0x6abb('0x1c')]=qs[_0x6abb('0x1c')](_0x334308['query'][_0x6abb('0x1c')]);_0x5c80ca[_0x6abb('0x1e')]=qs['offset'](_0x334308[_0x6abb('0x33')][_0x6abb('0x1e')]);}_0x5c80ca[_0x6abb('0x3b')]=qs[_0x6abb('0x3c')](_0x334308['query']['sort']);_0x5c80ca[_0x6abb('0x3d')]=qs[_0x6abb('0x34')](_[_0x6abb('0x3e')](_0x334308[_0x6abb('0x33')],_0x591e07[_0x6abb('0x34')]),_0x52414d);if(_0x334308[_0x6abb('0x33')][_0x6abb('0x3f')]){_0x5c80ca[_0x6abb('0x3d')]=_[_0x6abb('0x40')](_0x5c80ca['where'],{'$or':_[_0x6abb('0x2c')](_0x52414d,function(_0x5c9dd9){if(_0x5c9dd9[_0x6abb('0x30')]!==_0x6abb('0x41')){var _0x21b300={};_0x21b300[_0x5c9dd9['name']]={'$like':'%'+_0x334308['query'][_0x6abb('0x3f')]+'%'};return _0x21b300;}})});}_0x5c80ca=_[_0x6abb('0x40')]({},_0x5c80ca,_0x334308[_0x6abb('0x42')]);var _0x2d3bc4={'where':_0x5c80ca[_0x6abb('0x3d')]};return db[_0x6abb('0x2d')]['count'](_0x2d3bc4)[_0x6abb('0x24')](function(_0x3a08cd){_0x3c7798[_0x6abb('0x1d')]=_0x3a08cd;if(_0x334308[_0x6abb('0x33')][_0x6abb('0x43')]){_0x5c80ca[_0x6abb('0x44')]=[{'all':!![]}];}return db[_0x6abb('0x2d')][_0x6abb('0x45')](_0x5c80ca);})['then'](function(_0x3a90e4){_0x3c7798[_0x6abb('0x46')]=_0x3a90e4;return _0x3c7798;})[_0x6abb('0x24')](respondWithFilteredResult(_0x5ad943,_0x5c80ca))[_0x6abb('0x47')](handleError(_0x5ad943,null));};exports[_0x6abb('0x48')]=function(_0x27fd87,_0x3446fe){var _0x43567d={'raw':![],'where':{'id':_0x27fd87[_0x6abb('0x49')]['id']}},_0x1dc061={};_0x1dc061['model']=_[_0x6abb('0x4a')](db[_0x6abb('0x2d')][_0x6abb('0x2e')]);_0x1dc061[_0x6abb('0x33')]=_[_0x6abb('0x4a')](_0x27fd87['query']);_0x1dc061[_0x6abb('0x34')]=_['intersection'](_0x1dc061['model'],_0x1dc061[_0x6abb('0x33')]);_0x43567d[_0x6abb('0x37')]=_[_0x6abb('0x35')](_0x1dc061[_0x6abb('0x32')],qs[_0x6abb('0x36')](_0x27fd87[_0x6abb('0x33')][_0x6abb('0x36')]));_0x43567d[_0x6abb('0x37')]=_0x43567d['attributes'][_0x6abb('0x38')]?_0x43567d[_0x6abb('0x37')]:_0x1dc061['model'];if(_0x27fd87[_0x6abb('0x33')][_0x6abb('0x43')]){_0x43567d['include']=[{'all':!![]}];}_0x43567d=_[_0x6abb('0x40')]({},_0x43567d,_0x27fd87[_0x6abb('0x42')]);return db[_0x6abb('0x2d')][_0x6abb('0x4b')](_0x43567d)['then'](handleEntityNotFound(_0x3446fe,null))[_0x6abb('0x24')](respondWithResult(_0x3446fe,null))[_0x6abb('0x47')](handleError(_0x3446fe,null));};exports[_0x6abb('0x4c')]=function(_0x100299,_0x2648f4){return db['SugarcrmAccount'][_0x6abb('0x4c')](_0x100299[_0x6abb('0x4d')],{})['then'](respondWithResult(_0x2648f4,0xc9))[_0x6abb('0x47')](handleError(_0x2648f4,null));};exports['update']=function(_0x1871cf,_0x4dfcdf){if(_0x1871cf['body']['id']){delete _0x1871cf[_0x6abb('0x4d')]['id'];}return db['SugarcrmAccount'][_0x6abb('0x4b')]({'where':{'id':_0x1871cf[_0x6abb('0x49')]['id']}})['then'](handleEntityNotFound(_0x4dfcdf,null))[_0x6abb('0x24')](saveUpdates(_0x1871cf[_0x6abb('0x4d')],null))[_0x6abb('0x24')](respondWithResult(_0x4dfcdf,null))[_0x6abb('0x47')](handleError(_0x4dfcdf,null));};exports[_0x6abb('0x25')]=function(_0x304e99,_0x1b94b7){return db[_0x6abb('0x2d')][_0x6abb('0x4b')]({'where':{'id':_0x304e99[_0x6abb('0x49')]['id']}})['then'](handleEntityNotFound(_0x1b94b7,null))[_0x6abb('0x24')](removeEntity(_0x1b94b7,null))[_0x6abb('0x47')](handleError(_0x1b94b7,null));};exports['getConfigurations']=function(_0x2d0023,_0x196249,_0x3b3fca){var _0x3d7816={};var _0x50c13a={};var _0x38cf41;var _0x3358d6;return db[_0x6abb('0x2d')][_0x6abb('0x4e')]({'where':{'id':_0x2d0023['params']['id']}})[_0x6abb('0x24')](handleEntityNotFound(_0x196249,null))[_0x6abb('0x24')](function(_0x33c138){if(_0x33c138){_0x38cf41=_0x33c138;_0x50c13a[_0x6abb('0x32')]=_[_0x6abb('0x4a')](db[_0x6abb('0x4f')][_0x6abb('0x2e')]);_0x50c13a[_0x6abb('0x33')]=_[_0x6abb('0x4a')](_0x2d0023['query']);_0x50c13a[_0x6abb('0x34')]=_[_0x6abb('0x35')](_0x50c13a[_0x6abb('0x32')],_0x50c13a[_0x6abb('0x33')]);_0x3d7816[_0x6abb('0x37')]=_[_0x6abb('0x35')](_0x50c13a[_0x6abb('0x32')],qs[_0x6abb('0x36')](_0x2d0023['query']['fields']));_0x3d7816[_0x6abb('0x37')]=_0x3d7816[_0x6abb('0x37')][_0x6abb('0x38')]?_0x3d7816[_0x6abb('0x37')]:_0x50c13a['model'];_0x3d7816['order']=qs[_0x6abb('0x3c')](_0x2d0023[_0x6abb('0x33')][_0x6abb('0x3c')]);_0x3d7816[_0x6abb('0x3d')]=qs[_0x6abb('0x34')](_[_0x6abb('0x3e')](_0x2d0023[_0x6abb('0x33')],_0x50c13a[_0x6abb('0x34')]));if(_0x2d0023[_0x6abb('0x33')][_0x6abb('0x3f')]){_0x3d7816[_0x6abb('0x3d')]=_[_0x6abb('0x40')](_0x3d7816['where'],{'$or':_[_0x6abb('0x2c')](_0x3d7816[_0x6abb('0x37')],function(_0x5a0a5d){var _0x15745c={};_0x15745c[_0x5a0a5d]={'$like':'%'+_0x2d0023['query'][_0x6abb('0x3f')]+'%'};return _0x15745c;})});}_0x3d7816=_[_0x6abb('0x40')]({},_0x3d7816,_0x2d0023['options']);return _0x38cf41[_0x6abb('0x50')](_0x3d7816);}})[_0x6abb('0x24')](function(_0x745d5e){if(_0x745d5e){_0x3358d6=_0x745d5e[_0x6abb('0x38')];if(!_0x2d0023['query'][_0x6abb('0x39')](_0x6abb('0x3a'))){_0x3d7816[_0x6abb('0x1c')]=qs[_0x6abb('0x1c')](_0x2d0023[_0x6abb('0x33')][_0x6abb('0x1c')]);_0x3d7816[_0x6abb('0x1e')]=qs[_0x6abb('0x1e')](_0x2d0023[_0x6abb('0x33')][_0x6abb('0x1e')]);}return _0x38cf41[_0x6abb('0x50')](_0x3d7816);}})[_0x6abb('0x24')](function(_0x307ab2){if(_0x307ab2){return _0x307ab2?{'count':_0x3358d6,'rows':_0x307ab2}:null;}})[_0x6abb('0x24')](respondWithResult(_0x196249,null))[_0x6abb('0x47')](handleError(_0x196249,null));};exports['addConfiguration']=function(_0x115a00,_0x468e53,_0x44e0e9){if(_0x115a00[_0x6abb('0x4d')]['id']){delete _0x115a00['body']['id'];}return db[_0x6abb('0x2d')][_0x6abb('0x4e')]({'where':{'id':_0x115a00[_0x6abb('0x49')]['id']}})['then'](handleEntityNotFound(_0x468e53,null))['then'](function(_0x5f057a){if(_0x5f057a){_0x115a00[_0x6abb('0x4d')]['AccountId']=_0x5f057a['id'];_0x115a00[_0x6abb('0x4d')][_0x6abb('0x51')]=integrations['getSubjects'](_0x115a00[_0x6abb('0x4d')]['channel'],_0x115a00[_0x6abb('0x4d')][_0x6abb('0x30')]);_0x115a00[_0x6abb('0x4d')]['Descriptions']=integrations[_0x6abb('0x52')](_0x115a00[_0x6abb('0x4d')][_0x6abb('0x53')],_0x115a00[_0x6abb('0x4d')][_0x6abb('0x30')]);return db['SugarcrmConfiguration'][_0x6abb('0x4c')](_0x115a00[_0x6abb('0x4d')],{'include':[{'model':db[_0x6abb('0x54')],'as':'Subjects'},{'model':db[_0x6abb('0x54')],'as':'Descriptions'}]});}return null;})[_0x6abb('0x24')](respondWithResult(_0x468e53,null))['catch'](handleError(_0x468e53,null));};exports['getFields']=function(_0x2837f6,_0x260ce1,_0x443f1e){var _0x4cfbd6='';var _0x3aff05=['id',_0x6abb('0x29'),'assigned_user_id',_0x6abb('0x55'),'description',_0x6abb('0x56'),_0x6abb('0x57'),'duration_minutes','parent_id',_0x6abb('0x58'),'parent_name','direction'];return db['SugarcrmAccount'][_0x6abb('0x4e')]({'where':{'id':_0x2837f6[_0x6abb('0x49')]['id']},'attributes':['id',_0x6abb('0x59'),_0x6abb('0x5a'),_0x6abb('0x5b')]})['then'](handleEntityNotFound(_0x260ce1,null))[_0x6abb('0x24')](function(_0x359a0c){if(_0x359a0c){_0x4cfbd6=_0x359a0c[_0x6abb('0x5b')];var _0x5c6d0a=_0x4cfbd6[_0x6abb('0x5c')](-0x1);if(_0x5c6d0a==='/'){_0x4cfbd6=_0x4cfbd6[_0x6abb('0x5d')](0x0,_0x4cfbd6['lastIndexOf'](_0x5c6d0a));}return rp({'method':_0x6abb('0x5e'),'uri':util[_0x6abb('0x5f')]('%s%s',_0x4cfbd6,'/service/v4_1/rest.php'),'json':!![],'form':{'method':_0x6abb('0x60'),'input_type':_0x6abb('0x61'),'response_type':_0x6abb('0x61'),'rest_data':JSON[_0x6abb('0x62')]({'user_auth':{'user_name':_0x359a0c[_0x6abb('0x59')],'password':_0x359a0c[_0x6abb('0x5a')],'encryption':_0x6abb('0x63')},'application':'xCALLY\x20Motion\x20Integration'})}});}})[_0x6abb('0x24')](function(_0x58bcdc){if(_0x58bcdc&&_0x58bcdc[_0x6abb('0x29')]!=='Invalid\x20Login'&&_0x58bcdc[_0x6abb('0x29')]!==_0x6abb('0x64')){return rp({'method':_0x6abb('0x5e'),'uri':util['format'](_0x6abb('0x65'),_0x4cfbd6,_0x6abb('0x66')),'json':!![],'form':{'method':_0x6abb('0x67'),'input_type':_0x6abb('0x61'),'response_type':_0x6abb('0x61'),'rest_data':JSON[_0x6abb('0x62')]({'session':_0x58bcdc['id'],'module_name':_0x6abb('0x68')})}})[_0x6abb('0x24')](function(_0x39d141){if(_0x39d141){var _0x2443cc=_[_0x6abb('0x69')](_0x39d141[_0x6abb('0x6a')]);_[_0x6abb('0x6b')](_0x2443cc,function(_0x48e794){return _0x3aff05[_0x6abb('0x6c')](_0x48e794['name']);});return{'count':_0x2443cc[_0x6abb('0x38')],'rows':_['map'](_0x2443cc,function(_0xdaedc6){return{'id':_0xdaedc6[_0x6abb('0x29')],'name':_0xdaedc6[_0x6abb('0x6d')],'custom':_[_0x6abb('0x6e')](_0xdaedc6[_0x6abb('0x29')],'_c')?!![]:![],'options':_0xdaedc6['options']?_[_0x6abb('0x2c')](_[_0x6abb('0x69')](_0xdaedc6[_0x6abb('0x42')]),function(_0x4ddb24){return{'name':_0x4ddb24['value'],'value':_0x4ddb24[_0x6abb('0x29')]};}):[]};})};}})[_0x6abb('0x24')](respondWithResult(_0x260ce1,null))[_0x6abb('0x47')](function(_0x33d7cb){var _0x3dfa0f=_0x2837f6['query'][_0x6abb('0x6f')]?0x1f4:_0x33d7cb[_0x6abb('0x70')]||0x1f4;logger[_0x6abb('0x27')](_0x6abb('0x71'),_0x6abb('0x72'),_0x3dfa0f,JSON[_0x6abb('0x62')](_0x33d7cb));delete _0x33d7cb[_0x6abb('0x29')];if(_0x3dfa0f===0x191){_0x3dfa0f=0x190;}_0x260ce1[_0x6abb('0x18')](_0x3dfa0f)['send'](_0x2837f6[_0x6abb('0x33')]['test']?{'message':'Wrong\x20credentials','statusCode':_0x33d7cb[_0x6abb('0x70')]}:_0x33d7cb);});}else{var _0x41568a=0x1f4;_0x260ce1[_0x6abb('0x18')](_0x41568a)[_0x6abb('0x2a')]({'message':_0x6abb('0x73'),'statusCode':0x190});}});};