4d70e8588a8eb1bc1db2c92e53f60f53c7f8b276
[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 _0x1bb7=['pick','filter','merge','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','params','find','create','body','getConfigurations','findOne','SugarcrmConfiguration','rawAttributes','nolimit','AccountId','Subjects','channel','SugarcrmField','Descriptions','getFields','description','date_start','duration_hours','duration_minutes','parent_type','password','remoteUri','slice','substring','lastIndexOf','POST','format','%s%s','/service/v4_1/rest.php','login','JSON','stringify','PLAIN','Invalid\x20Login','Password\x20Expired','get_module_fields','values','module_fields','remove','label','endsWith','value','test','send','Wrong\x20credentials','statusCode','eml-format','rimraf','fast-json-patch','mustache','util','sox','to-csv','ejs','fs-extra','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../components/integrations/configuration','sendStatus','end','status','json','count','limit','set','apply','reject','save','update','destroy','then','error','stack','name','map','SugarcrmAccount','type','key','keys','query','filters','attributes','intersection','fields','length','model','hasOwnProperty','offset','order','sort','where'];(function(_0xe3b0f9,_0x1ad07a){var _0x23ffe9=function(_0x555acc){while(--_0x555acc){_0xe3b0f9['push'](_0xe3b0f9['shift']());}};_0x23ffe9(++_0x1ad07a);}(_0x1bb7,0x192));var _0x71bb=function(_0x2c91e9,_0x2fb965){_0x2c91e9=_0x2c91e9-0x0;var _0x13f0ff=_0x1bb7[_0x2c91e9];return _0x13f0ff;};'use strict';var emlformat=require(_0x71bb('0x0'));var rimraf=require(_0x71bb('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x71bb('0x2'));var rp=require('request-promise');var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x71bb('0x3'));var util=require(_0x71bb('0x4'));var path=require('path');var sox=require(_0x71bb('0x5'));var csv=require(_0x71bb('0x6'));var ejs=require(_0x71bb('0x7'));var fs=require('fs');var fs_extra=require(_0x71bb('0x8'));var _=require('lodash');var squel=require(_0x71bb('0x9'));var crypto=require(_0x71bb('0xa'));var jsforce=require(_0x71bb('0xb'));var deskjs=require('desk.js');var toCsv=require(_0x71bb('0x6'));var querystring=require(_0x71bb('0xc'));var Papa=require(_0x71bb('0xd'));var Redis=require(_0x71bb('0xe'));var authService=require(_0x71bb('0xf'));var qs=require(_0x71bb('0x10'));var as=require(_0x71bb('0x11'));var hardwareService=require(_0x71bb('0x12'));var logger=require(_0x71bb('0x13'))(_0x71bb('0x14'));var utils=require(_0x71bb('0x15'));var config=require(_0x71bb('0x16'));var licenseUtil=require(_0x71bb('0x17'));var db=require('../../mysqldb')['db'];var integrations=require(_0x71bb('0x18'));function respondWithStatusCode(_0x5256ae,_0x28dce3){_0x28dce3=_0x28dce3||0xcc;return function(_0x389800){if(_0x389800){return _0x5256ae[_0x71bb('0x19')](_0x28dce3);}return _0x5256ae['status'](_0x28dce3)[_0x71bb('0x1a')]();};}function respondWithResult(_0x54d069,_0x1fdec6){_0x1fdec6=_0x1fdec6||0xc8;return function(_0x5c86d0){if(_0x5c86d0){return _0x54d069[_0x71bb('0x1b')](_0x1fdec6)[_0x71bb('0x1c')](_0x5c86d0);}};}function respondWithFilteredResult(_0x59d82e,_0x5bfafb){return function(_0x44cc68){if(_0x44cc68){var _0x4d6c93=typeof _0x5bfafb['offset']==='undefined'&&typeof _0x5bfafb['limit']==='undefined';var _0x21feeb=_0x44cc68[_0x71bb('0x1d')];var _0x241375=_0x4d6c93?0x0:_0x5bfafb['offset'];var _0x13c67d=_0x4d6c93?_0x44cc68[_0x71bb('0x1d')]:_0x5bfafb['offset']+_0x5bfafb[_0x71bb('0x1e')];var _0x297447;if(_0x13c67d>=_0x21feeb){_0x13c67d=_0x21feeb;_0x297447=0xc8;}else{_0x297447=0xce;}_0x59d82e['status'](_0x297447);return _0x59d82e[_0x71bb('0x1f')]('Content-Range',_0x241375+'-'+_0x13c67d+'/'+_0x21feeb)[_0x71bb('0x1c')](_0x44cc68);}return null;};}function patchUpdates(_0x4e9988){return function(_0x33645a){try{jsonpatch[_0x71bb('0x20')](_0x33645a,_0x4e9988,!![]);}catch(_0x5e5254){return BPromise[_0x71bb('0x21')](_0x5e5254);}return _0x33645a[_0x71bb('0x22')]();};}function saveUpdates(_0x44faf9,_0x2982f7){return function(_0xe62d3e){if(_0xe62d3e){return _0xe62d3e[_0x71bb('0x23')](_0x44faf9)['then'](function(_0x70b0f5){return _0x70b0f5;});}return null;};}function removeEntity(_0x166d4a,_0x4ee056){return function(_0x2fa3ae){if(_0x2fa3ae){return _0x2fa3ae[_0x71bb('0x24')]()[_0x71bb('0x25')](function(){_0x166d4a[_0x71bb('0x1b')](0xcc)[_0x71bb('0x1a')]();});}};}function handleEntityNotFound(_0x5514a3,_0x5dd9ac){return function(_0x300fc3){if(!_0x300fc3){_0x5514a3['sendStatus'](0x194);}return _0x300fc3;};}function handleError(_0x54c858,_0x332ec2){_0x332ec2=_0x332ec2||0x1f4;return function(_0x384e0e){logger[_0x71bb('0x26')](_0x384e0e[_0x71bb('0x27')]);if(_0x384e0e[_0x71bb('0x28')]){delete _0x384e0e[_0x71bb('0x28')];}_0x54c858[_0x71bb('0x1b')](_0x332ec2)['send'](_0x384e0e);};}exports['index']=function(_0x1feb98,_0x1323ba){var _0x4760df={},_0x529049={},_0x3ef191={'count':0x0,'rows':[]};var _0x5f38c3=_[_0x71bb('0x29')](db[_0x71bb('0x2a')]['rawAttributes'],function(_0xba195b){return{'name':_0xba195b['fieldName'],'type':_0xba195b[_0x71bb('0x2b')][_0x71bb('0x2c')]};});_0x529049['model']=_[_0x71bb('0x29')](_0x5f38c3,_0x71bb('0x28'));_0x529049['query']=_[_0x71bb('0x2d')](_0x1feb98[_0x71bb('0x2e')]);_0x529049[_0x71bb('0x2f')]=_['intersection'](_0x529049['model'],_0x529049[_0x71bb('0x2e')]);_0x4760df[_0x71bb('0x30')]=_[_0x71bb('0x31')](_0x529049['model'],qs[_0x71bb('0x32')](_0x1feb98['query'][_0x71bb('0x32')]));_0x4760df['attributes']=_0x4760df[_0x71bb('0x30')][_0x71bb('0x33')]?_0x4760df[_0x71bb('0x30')]:_0x529049[_0x71bb('0x34')];if(!_0x1feb98[_0x71bb('0x2e')][_0x71bb('0x35')]('nolimit')){_0x4760df['limit']=qs['limit'](_0x1feb98[_0x71bb('0x2e')][_0x71bb('0x1e')]);_0x4760df['offset']=qs['offset'](_0x1feb98[_0x71bb('0x2e')][_0x71bb('0x36')]);}_0x4760df[_0x71bb('0x37')]=qs[_0x71bb('0x38')](_0x1feb98['query'][_0x71bb('0x38')]);_0x4760df[_0x71bb('0x39')]=qs[_0x71bb('0x2f')](_[_0x71bb('0x3a')](_0x1feb98[_0x71bb('0x2e')],_0x529049[_0x71bb('0x2f')]),_0x5f38c3);if(_0x1feb98[_0x71bb('0x2e')][_0x71bb('0x3b')]){_0x4760df[_0x71bb('0x39')]=_[_0x71bb('0x3c')](_0x4760df[_0x71bb('0x39')],{'$or':_[_0x71bb('0x29')](_0x5f38c3,function(_0x1a3ff6){if(_0x1a3ff6[_0x71bb('0x2b')]!==_0x71bb('0x3d')){var _0x4b0089={};_0x4b0089[_0x1a3ff6['name']]={'$like':'%'+_0x1feb98[_0x71bb('0x2e')][_0x71bb('0x3b')]+'%'};return _0x4b0089;}})});}_0x4760df=_[_0x71bb('0x3c')]({},_0x4760df,_0x1feb98[_0x71bb('0x3e')]);var _0xf1e545={'where':_0x4760df[_0x71bb('0x39')]};return db['SugarcrmAccount']['count'](_0xf1e545)['then'](function(_0x30fe0d){_0x3ef191[_0x71bb('0x1d')]=_0x30fe0d;if(_0x1feb98['query'][_0x71bb('0x3f')]){_0x4760df[_0x71bb('0x40')]=[{'all':!![]}];}return db[_0x71bb('0x2a')][_0x71bb('0x41')](_0x4760df);})[_0x71bb('0x25')](function(_0x1c03f2){_0x3ef191[_0x71bb('0x42')]=_0x1c03f2;return _0x3ef191;})[_0x71bb('0x25')](respondWithFilteredResult(_0x1323ba,_0x4760df))[_0x71bb('0x43')](handleError(_0x1323ba,null));};exports[_0x71bb('0x44')]=function(_0x1302a6,_0x134b06){var _0x20b773={'raw':![],'where':{'id':_0x1302a6[_0x71bb('0x45')]['id']}},_0x55b05c={};_0x55b05c['model']=_[_0x71bb('0x2d')](db[_0x71bb('0x2a')]['rawAttributes']);_0x55b05c[_0x71bb('0x2e')]=_[_0x71bb('0x2d')](_0x1302a6[_0x71bb('0x2e')]);_0x55b05c[_0x71bb('0x2f')]=_[_0x71bb('0x31')](_0x55b05c[_0x71bb('0x34')],_0x55b05c[_0x71bb('0x2e')]);_0x20b773[_0x71bb('0x30')]=_['intersection'](_0x55b05c['model'],qs[_0x71bb('0x32')](_0x1302a6[_0x71bb('0x2e')]['fields']));_0x20b773[_0x71bb('0x30')]=_0x20b773[_0x71bb('0x30')][_0x71bb('0x33')]?_0x20b773[_0x71bb('0x30')]:_0x55b05c['model'];if(_0x1302a6['query'][_0x71bb('0x3f')]){_0x20b773['include']=[{'all':!![]}];}_0x20b773=_['merge']({},_0x20b773,_0x1302a6['options']);return db['SugarcrmAccount'][_0x71bb('0x46')](_0x20b773)['then'](handleEntityNotFound(_0x134b06,null))[_0x71bb('0x25')](respondWithResult(_0x134b06,null))[_0x71bb('0x43')](handleError(_0x134b06,null));};exports[_0x71bb('0x47')]=function(_0x340533,_0x59da9d){return db[_0x71bb('0x2a')][_0x71bb('0x47')](_0x340533[_0x71bb('0x48')],{})[_0x71bb('0x25')](respondWithResult(_0x59da9d,0xc9))[_0x71bb('0x43')](handleError(_0x59da9d,null));};exports['update']=function(_0x2ff5de,_0x39472c){if(_0x2ff5de['body']['id']){delete _0x2ff5de[_0x71bb('0x48')]['id'];}return db[_0x71bb('0x2a')][_0x71bb('0x46')]({'where':{'id':_0x2ff5de[_0x71bb('0x45')]['id']}})[_0x71bb('0x25')](handleEntityNotFound(_0x39472c,null))[_0x71bb('0x25')](saveUpdates(_0x2ff5de[_0x71bb('0x48')],null))['then'](respondWithResult(_0x39472c,null))[_0x71bb('0x43')](handleError(_0x39472c,null));};exports[_0x71bb('0x24')]=function(_0x28099d,_0x14f6c2){return db[_0x71bb('0x2a')][_0x71bb('0x46')]({'where':{'id':_0x28099d['params']['id']}})[_0x71bb('0x25')](handleEntityNotFound(_0x14f6c2,null))[_0x71bb('0x25')](removeEntity(_0x14f6c2,null))['catch'](handleError(_0x14f6c2,null));};exports[_0x71bb('0x49')]=function(_0x16c56,_0x58c300,_0x453e82){var _0x3214e5={};var _0x281abd={};var _0x2972c3;var _0x57d5ea;return db[_0x71bb('0x2a')][_0x71bb('0x4a')]({'where':{'id':_0x16c56[_0x71bb('0x45')]['id']}})[_0x71bb('0x25')](handleEntityNotFound(_0x58c300,null))[_0x71bb('0x25')](function(_0x1ef15d){if(_0x1ef15d){_0x2972c3=_0x1ef15d;_0x281abd[_0x71bb('0x34')]=_['keys'](db[_0x71bb('0x4b')][_0x71bb('0x4c')]);_0x281abd['query']=_[_0x71bb('0x2d')](_0x16c56[_0x71bb('0x2e')]);_0x281abd[_0x71bb('0x2f')]=_[_0x71bb('0x31')](_0x281abd[_0x71bb('0x34')],_0x281abd[_0x71bb('0x2e')]);_0x3214e5['attributes']=_[_0x71bb('0x31')](_0x281abd[_0x71bb('0x34')],qs[_0x71bb('0x32')](_0x16c56['query']['fields']));_0x3214e5[_0x71bb('0x30')]=_0x3214e5[_0x71bb('0x30')][_0x71bb('0x33')]?_0x3214e5[_0x71bb('0x30')]:_0x281abd[_0x71bb('0x34')];_0x3214e5[_0x71bb('0x37')]=qs[_0x71bb('0x38')](_0x16c56[_0x71bb('0x2e')]['sort']);_0x3214e5[_0x71bb('0x39')]=qs[_0x71bb('0x2f')](_[_0x71bb('0x3a')](_0x16c56[_0x71bb('0x2e')],_0x281abd[_0x71bb('0x2f')]));if(_0x16c56[_0x71bb('0x2e')][_0x71bb('0x3b')]){_0x3214e5[_0x71bb('0x39')]=_[_0x71bb('0x3c')](_0x3214e5[_0x71bb('0x39')],{'$or':_[_0x71bb('0x29')](_0x3214e5[_0x71bb('0x30')],function(_0x5efa34){var _0x45752a={};_0x45752a[_0x5efa34]={'$like':'%'+_0x16c56[_0x71bb('0x2e')]['filter']+'%'};return _0x45752a;})});}_0x3214e5=_[_0x71bb('0x3c')]({},_0x3214e5,_0x16c56['options']);return _0x2972c3['getConfigurations'](_0x3214e5);}})['then'](function(_0xe21958){if(_0xe21958){_0x57d5ea=_0xe21958[_0x71bb('0x33')];if(!_0x16c56['query'][_0x71bb('0x35')](_0x71bb('0x4d'))){_0x3214e5[_0x71bb('0x1e')]=qs['limit'](_0x16c56['query'][_0x71bb('0x1e')]);_0x3214e5['offset']=qs[_0x71bb('0x36')](_0x16c56[_0x71bb('0x2e')][_0x71bb('0x36')]);}return _0x2972c3['getConfigurations'](_0x3214e5);}})[_0x71bb('0x25')](function(_0x5ac7ec){if(_0x5ac7ec){return _0x5ac7ec?{'count':_0x57d5ea,'rows':_0x5ac7ec}:null;}})[_0x71bb('0x25')](respondWithResult(_0x58c300,null))[_0x71bb('0x43')](handleError(_0x58c300,null));};exports['addConfiguration']=function(_0x280617,_0x3d5435,_0x485b9c){if(_0x280617[_0x71bb('0x48')]['id']){delete _0x280617[_0x71bb('0x48')]['id'];}return db[_0x71bb('0x2a')][_0x71bb('0x4a')]({'where':{'id':_0x280617[_0x71bb('0x45')]['id']}})[_0x71bb('0x25')](handleEntityNotFound(_0x3d5435,null))[_0x71bb('0x25')](function(_0x53a415){if(_0x53a415){_0x280617[_0x71bb('0x48')][_0x71bb('0x4e')]=_0x53a415['id'];_0x280617[_0x71bb('0x48')][_0x71bb('0x4f')]=integrations['getSubjects'](_0x280617[_0x71bb('0x48')][_0x71bb('0x50')],_0x280617[_0x71bb('0x48')]['type']);_0x280617[_0x71bb('0x48')]['Descriptions']=integrations['getDescriptions'](_0x280617[_0x71bb('0x48')][_0x71bb('0x50')],_0x280617[_0x71bb('0x48')][_0x71bb('0x2b')]);return db[_0x71bb('0x4b')][_0x71bb('0x47')](_0x280617[_0x71bb('0x48')],{'include':[{'model':db[_0x71bb('0x51')],'as':_0x71bb('0x4f')},{'model':db[_0x71bb('0x51')],'as':_0x71bb('0x52')}]});}return null;})[_0x71bb('0x25')](respondWithResult(_0x3d5435,null))[_0x71bb('0x43')](handleError(_0x3d5435,null));};exports[_0x71bb('0x53')]=function(_0x8f311b,_0x5d0501,_0xb574b7){var _0x293a0c='';var _0x3fa5a6=['id','name','assigned_user_id','created_by',_0x71bb('0x54'),_0x71bb('0x55'),_0x71bb('0x56'),_0x71bb('0x57'),'parent_id',_0x71bb('0x58'),'parent_name','direction'];return db[_0x71bb('0x2a')][_0x71bb('0x4a')]({'where':{'id':_0x8f311b[_0x71bb('0x45')]['id']},'attributes':['id','username',_0x71bb('0x59'),_0x71bb('0x5a')]})[_0x71bb('0x25')](handleEntityNotFound(_0x5d0501,null))[_0x71bb('0x25')](function(_0x12c50e){if(_0x12c50e){_0x293a0c=_0x12c50e[_0x71bb('0x5a')];var _0x4d8294=_0x293a0c[_0x71bb('0x5b')](-0x1);if(_0x4d8294==='/'){_0x293a0c=_0x293a0c[_0x71bb('0x5c')](0x0,_0x293a0c[_0x71bb('0x5d')](_0x4d8294));}return rp({'method':_0x71bb('0x5e'),'uri':util[_0x71bb('0x5f')](_0x71bb('0x60'),_0x293a0c,_0x71bb('0x61')),'json':!![],'form':{'method':_0x71bb('0x62'),'input_type':_0x71bb('0x63'),'response_type':_0x71bb('0x63'),'rest_data':JSON[_0x71bb('0x64')]({'user_auth':{'user_name':_0x12c50e['username'],'password':_0x12c50e['password'],'encryption':_0x71bb('0x65')},'application':'xCALLY\x20Motion\x20Integration'})}});}})[_0x71bb('0x25')](function(_0x3127e0){if(_0x3127e0&&_0x3127e0[_0x71bb('0x28')]!==_0x71bb('0x66')&&_0x3127e0['name']!==_0x71bb('0x67')){return rp({'method':'POST','uri':util[_0x71bb('0x5f')]('%s%s',_0x293a0c,_0x71bb('0x61')),'json':!![],'form':{'method':_0x71bb('0x68'),'input_type':_0x71bb('0x63'),'response_type':'JSON','rest_data':JSON[_0x71bb('0x64')]({'session':_0x3127e0['id'],'module_name':'Calls'})}})[_0x71bb('0x25')](function(_0x3d5ed0){if(_0x3d5ed0){var _0x8f22ff=_[_0x71bb('0x69')](_0x3d5ed0[_0x71bb('0x6a')]);_[_0x71bb('0x6b')](_0x8f22ff,function(_0x15eb80){return _0x3fa5a6['includes'](_0x15eb80['name']);});return{'count':_0x8f22ff['length'],'rows':_[_0x71bb('0x29')](_0x8f22ff,function(_0x5d58e7){return{'id':_0x5d58e7[_0x71bb('0x28')],'name':_0x5d58e7[_0x71bb('0x6c')],'custom':_[_0x71bb('0x6d')](_0x5d58e7[_0x71bb('0x28')],'_c')?!![]:![],'options':_0x5d58e7[_0x71bb('0x3e')]?_[_0x71bb('0x29')](_[_0x71bb('0x69')](_0x5d58e7[_0x71bb('0x3e')]),function(_0x6f3c92){return{'name':_0x6f3c92[_0x71bb('0x6e')],'value':_0x6f3c92['name']};}):[]};})};}})[_0x71bb('0x25')](respondWithResult(_0x5d0501,null))['catch'](function(_0x130c36){var _0x17a80e=_0x8f311b[_0x71bb('0x2e')][_0x71bb('0x6f')]?0x1f4:_0x130c36['statusCode']||0x1f4;logger[_0x71bb('0x26')]('getFields,\x20%s,\x20%s,\x20%s',_0x71bb('0x53'),_0x17a80e,JSON['stringify'](_0x130c36));delete _0x130c36[_0x71bb('0x28')];if(_0x17a80e===0x191){_0x17a80e=0x190;}_0x5d0501[_0x71bb('0x1b')](_0x17a80e)[_0x71bb('0x70')](_0x8f311b[_0x71bb('0x2e')][_0x71bb('0x6f')]?{'message':_0x71bb('0x71'),'statusCode':_0x130c36[_0x71bb('0x72')]}:_0x130c36);});}else{var _0x1146ec=0x1f4;_0x5d0501[_0x71bb('0x1b')](_0x1146ec)[_0x71bb('0x70')]({'message':_0x71bb('0x71'),'statusCode':0x190});}});};