Built motion from commit ffdca78c.|2.6.24
[motion2.git] / server / api / intVtigerAccount / intVtigerAccount.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 _0x6c12=['VtigerConfiguration','VtigerField','Subjects','md5','username','moduleName','remoteUri','serverUrl','accessKey','slice','lastIndexOf','format','%s/webservice.php','GET','getchallenge','success','POST','login','result','token','describe','owner','remove','includes','false','startsWith','cf_','picklist','picklistValues','label','value','vTiger\x20error:\x20','test','getFields,\x20%s,\x20%s,\x20%s','getFields','Wrong\x20credentials','statusCode','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','../../components/integrations/configuration','status','end','offset','undefined','limit','count','set','Content-Range','json','apply','reject','save','then','destroy','sendStatus','error','stack','name','index','VtigerAccount','rawAttributes','key','model','query','keys','filters','intersection','attributes','fields','hasOwnProperty','order','sort','where','pick','filter','merge','map','type','VIRTUAL','options','include','findAll','rows','show','params','find','catch','body','update','getConfigurations','findOne','length','nolimit','addConfiguration','AccountId','channel','Descriptions'];(function(_0x197185,_0x251145){var _0x2c8af1=function(_0x1dbcfd){while(--_0x1dbcfd){_0x197185['push'](_0x197185['shift']());}};_0x2c8af1(++_0x251145);}(_0x6c12,0x117));var _0x26c1=function(_0x3f6b1b,_0x58d3d6){_0x3f6b1b=_0x3f6b1b-0x0;var _0x4a3d2b=_0x6c12[_0x3f6b1b];return _0x4a3d2b;};'use strict';var emlformat=require(_0x26c1('0x0'));var rimraf=require(_0x26c1('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x26c1('0x2'));var rp=require(_0x26c1('0x3'));var moment=require(_0x26c1('0x4'));var BPromise=require(_0x26c1('0x5'));var Mustache=require(_0x26c1('0x6'));var util=require(_0x26c1('0x7'));var path=require('path');var sox=require(_0x26c1('0x8'));var csv=require(_0x26c1('0x9'));var ejs=require(_0x26c1('0xa'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require('lodash');var squel=require(_0x26c1('0xb'));var crypto=require(_0x26c1('0xc'));var jsforce=require(_0x26c1('0xd'));var deskjs=require('desk.js');var toCsv=require(_0x26c1('0x9'));var querystring=require(_0x26c1('0xe'));var Papa=require(_0x26c1('0xf'));var Redis=require(_0x26c1('0x10'));var authService=require(_0x26c1('0x11'));var qs=require('../../components/parsers/qs');var as=require(_0x26c1('0x12'));var hardwareService=require(_0x26c1('0x13'));var logger=require(_0x26c1('0x14'))(_0x26c1('0x15'));var utils=require(_0x26c1('0x16'));var config=require(_0x26c1('0x17'));var licenseUtil=require(_0x26c1('0x18'));var db=require(_0x26c1('0x19'))['db'];var integrations=require(_0x26c1('0x1a'));function respondWithStatusCode(_0x1bda53,_0x34d0af){_0x34d0af=_0x34d0af||0xcc;return function(_0x24428b){if(_0x24428b){return _0x1bda53['sendStatus'](_0x34d0af);}return _0x1bda53[_0x26c1('0x1b')](_0x34d0af)[_0x26c1('0x1c')]();};}function respondWithResult(_0x24239d,_0x5459c7){_0x5459c7=_0x5459c7||0xc8;return function(_0x5a8c88){if(_0x5a8c88){return _0x24239d['status'](_0x5459c7)['json'](_0x5a8c88);}};}function respondWithFilteredResult(_0x15b4ce,_0x49e836){return function(_0x11bba5){if(_0x11bba5){var _0x45ed30=typeof _0x49e836[_0x26c1('0x1d')]===_0x26c1('0x1e')&&typeof _0x49e836[_0x26c1('0x1f')]===_0x26c1('0x1e');var _0x2d57a6=_0x11bba5[_0x26c1('0x20')];var _0x1445a6=_0x45ed30?0x0:_0x49e836[_0x26c1('0x1d')];var _0x46249d=_0x45ed30?_0x11bba5[_0x26c1('0x20')]:_0x49e836[_0x26c1('0x1d')]+_0x49e836[_0x26c1('0x1f')];var _0xfd2139;if(_0x46249d>=_0x2d57a6){_0x46249d=_0x2d57a6;_0xfd2139=0xc8;}else{_0xfd2139=0xce;}_0x15b4ce[_0x26c1('0x1b')](_0xfd2139);return _0x15b4ce[_0x26c1('0x21')](_0x26c1('0x22'),_0x1445a6+'-'+_0x46249d+'/'+_0x2d57a6)[_0x26c1('0x23')](_0x11bba5);}return null;};}function patchUpdates(_0x50cbfb){return function(_0x1f9b9b){try{jsonpatch[_0x26c1('0x24')](_0x1f9b9b,_0x50cbfb,!![]);}catch(_0x251766){return BPromise[_0x26c1('0x25')](_0x251766);}return _0x1f9b9b[_0x26c1('0x26')]();};}function saveUpdates(_0x4c64f5,_0x4cdac6){return function(_0x49d872){if(_0x49d872){return _0x49d872['update'](_0x4c64f5)[_0x26c1('0x27')](function(_0x869bf9){return _0x869bf9;});}return null;};}function removeEntity(_0x5e2112,_0xdb428d){return function(_0x143cbf){if(_0x143cbf){return _0x143cbf[_0x26c1('0x28')]()[_0x26c1('0x27')](function(){_0x5e2112[_0x26c1('0x1b')](0xcc)[_0x26c1('0x1c')]();});}};}function handleEntityNotFound(_0x5ea3b6,_0x213854){return function(_0x34646f){if(!_0x34646f){_0x5ea3b6[_0x26c1('0x29')](0x194);}return _0x34646f;};}function handleError(_0x17f955,_0x48aa84){_0x48aa84=_0x48aa84||0x1f4;return function(_0x5e4e3c){logger[_0x26c1('0x2a')](_0x5e4e3c[_0x26c1('0x2b')]);if(_0x5e4e3c[_0x26c1('0x2c')]){delete _0x5e4e3c[_0x26c1('0x2c')];}_0x17f955[_0x26c1('0x1b')](_0x48aa84)['send'](_0x5e4e3c);};}exports[_0x26c1('0x2d')]=function(_0x2c40fa,_0x16dc39){var _0x478f51={},_0x2d2757={},_0x5f0c05={'count':0x0,'rows':[]};var _0x3d4c0d=_['map'](db[_0x26c1('0x2e')][_0x26c1('0x2f')],function(_0x10a48a){return{'name':_0x10a48a['fieldName'],'type':_0x10a48a['type'][_0x26c1('0x30')]};});_0x2d2757[_0x26c1('0x31')]=_['map'](_0x3d4c0d,_0x26c1('0x2c'));_0x2d2757[_0x26c1('0x32')]=_[_0x26c1('0x33')](_0x2c40fa['query']);_0x2d2757[_0x26c1('0x34')]=_[_0x26c1('0x35')](_0x2d2757[_0x26c1('0x31')],_0x2d2757[_0x26c1('0x32')]);_0x478f51[_0x26c1('0x36')]=_['intersection'](_0x2d2757[_0x26c1('0x31')],qs[_0x26c1('0x37')](_0x2c40fa[_0x26c1('0x32')][_0x26c1('0x37')]));_0x478f51['attributes']=_0x478f51[_0x26c1('0x36')]['length']?_0x478f51[_0x26c1('0x36')]:_0x2d2757[_0x26c1('0x31')];if(!_0x2c40fa[_0x26c1('0x32')][_0x26c1('0x38')]('nolimit')){_0x478f51['limit']=qs[_0x26c1('0x1f')](_0x2c40fa[_0x26c1('0x32')][_0x26c1('0x1f')]);_0x478f51[_0x26c1('0x1d')]=qs['offset'](_0x2c40fa['query'][_0x26c1('0x1d')]);}_0x478f51[_0x26c1('0x39')]=qs[_0x26c1('0x3a')](_0x2c40fa[_0x26c1('0x32')][_0x26c1('0x3a')]);_0x478f51[_0x26c1('0x3b')]=qs[_0x26c1('0x34')](_[_0x26c1('0x3c')](_0x2c40fa['query'],_0x2d2757['filters']),_0x3d4c0d);if(_0x2c40fa[_0x26c1('0x32')][_0x26c1('0x3d')]){_0x478f51['where']=_[_0x26c1('0x3e')](_0x478f51[_0x26c1('0x3b')],{'$or':_[_0x26c1('0x3f')](_0x3d4c0d,function(_0xc4d693){if(_0xc4d693[_0x26c1('0x40')]!==_0x26c1('0x41')){var _0x53629c={};_0x53629c[_0xc4d693[_0x26c1('0x2c')]]={'$like':'%'+_0x2c40fa[_0x26c1('0x32')]['filter']+'%'};return _0x53629c;}})});}_0x478f51=_['merge']({},_0x478f51,_0x2c40fa[_0x26c1('0x42')]);var _0x2d24f8={'where':_0x478f51['where']};return db[_0x26c1('0x2e')][_0x26c1('0x20')](_0x2d24f8)[_0x26c1('0x27')](function(_0x8af3da){_0x5f0c05['count']=_0x8af3da;if(_0x2c40fa[_0x26c1('0x32')]['includeAll']){_0x478f51[_0x26c1('0x43')]=[{'all':!![]}];}return db[_0x26c1('0x2e')][_0x26c1('0x44')](_0x478f51);})[_0x26c1('0x27')](function(_0x35aade){_0x5f0c05[_0x26c1('0x45')]=_0x35aade;return _0x5f0c05;})[_0x26c1('0x27')](respondWithFilteredResult(_0x16dc39,_0x478f51))['catch'](handleError(_0x16dc39,null));};exports[_0x26c1('0x46')]=function(_0x3e47df,_0x2bd0f5){var _0x6f36d2={'raw':![],'where':{'id':_0x3e47df[_0x26c1('0x47')]['id']}},_0x14f0bf={};_0x14f0bf[_0x26c1('0x31')]=_[_0x26c1('0x33')](db[_0x26c1('0x2e')][_0x26c1('0x2f')]);_0x14f0bf[_0x26c1('0x32')]=_[_0x26c1('0x33')](_0x3e47df['query']);_0x14f0bf[_0x26c1('0x34')]=_['intersection'](_0x14f0bf[_0x26c1('0x31')],_0x14f0bf[_0x26c1('0x32')]);_0x6f36d2[_0x26c1('0x36')]=_[_0x26c1('0x35')](_0x14f0bf[_0x26c1('0x31')],qs['fields'](_0x3e47df[_0x26c1('0x32')][_0x26c1('0x37')]));_0x6f36d2['attributes']=_0x6f36d2[_0x26c1('0x36')]['length']?_0x6f36d2[_0x26c1('0x36')]:_0x14f0bf['model'];if(_0x3e47df['query']['includeAll']){_0x6f36d2['include']=[{'all':!![]}];}_0x6f36d2=_['merge']({},_0x6f36d2,_0x3e47df['options']);return db['VtigerAccount'][_0x26c1('0x48')](_0x6f36d2)['then'](handleEntityNotFound(_0x2bd0f5,null))[_0x26c1('0x27')](respondWithResult(_0x2bd0f5,null))[_0x26c1('0x49')](handleError(_0x2bd0f5,null));};exports['create']=function(_0x479d25,_0x3bbae1){return db['VtigerAccount']['create'](_0x479d25[_0x26c1('0x4a')],{})[_0x26c1('0x27')](respondWithResult(_0x3bbae1,0xc9))[_0x26c1('0x49')](handleError(_0x3bbae1,null));};exports[_0x26c1('0x4b')]=function(_0x23a14b,_0x2ad634){if(_0x23a14b['body']['id']){delete _0x23a14b[_0x26c1('0x4a')]['id'];}return db[_0x26c1('0x2e')][_0x26c1('0x48')]({'where':{'id':_0x23a14b[_0x26c1('0x47')]['id']}})[_0x26c1('0x27')](handleEntityNotFound(_0x2ad634,null))['then'](saveUpdates(_0x23a14b[_0x26c1('0x4a')],null))[_0x26c1('0x27')](respondWithResult(_0x2ad634,null))[_0x26c1('0x49')](handleError(_0x2ad634,null));};exports[_0x26c1('0x28')]=function(_0x1c23e4,_0x5c126b){return db[_0x26c1('0x2e')][_0x26c1('0x48')]({'where':{'id':_0x1c23e4[_0x26c1('0x47')]['id']}})['then'](handleEntityNotFound(_0x5c126b,null))[_0x26c1('0x27')](removeEntity(_0x5c126b,null))[_0x26c1('0x49')](handleError(_0x5c126b,null));};exports[_0x26c1('0x4c')]=function(_0x29211f,_0x478a14,_0x483e95){var _0x2e32a6={};var _0x15317d={};var _0x34b423;var _0x500ff9;return db[_0x26c1('0x2e')][_0x26c1('0x4d')]({'where':{'id':_0x29211f[_0x26c1('0x47')]['id']}})['then'](handleEntityNotFound(_0x478a14,null))['then'](function(_0x51eeef){if(_0x51eeef){_0x34b423=_0x51eeef;_0x15317d['model']=_['keys'](db['VtigerConfiguration'][_0x26c1('0x2f')]);_0x15317d[_0x26c1('0x32')]=_[_0x26c1('0x33')](_0x29211f[_0x26c1('0x32')]);_0x15317d[_0x26c1('0x34')]=_[_0x26c1('0x35')](_0x15317d['model'],_0x15317d[_0x26c1('0x32')]);_0x2e32a6[_0x26c1('0x36')]=_['intersection'](_0x15317d[_0x26c1('0x31')],qs[_0x26c1('0x37')](_0x29211f['query']['fields']));_0x2e32a6[_0x26c1('0x36')]=_0x2e32a6[_0x26c1('0x36')][_0x26c1('0x4e')]?_0x2e32a6[_0x26c1('0x36')]:_0x15317d[_0x26c1('0x31')];_0x2e32a6[_0x26c1('0x39')]=qs['sort'](_0x29211f[_0x26c1('0x32')][_0x26c1('0x3a')]);_0x2e32a6['where']=qs[_0x26c1('0x34')](_['pick'](_0x29211f['query'],_0x15317d['filters']));if(_0x29211f[_0x26c1('0x32')][_0x26c1('0x3d')]){_0x2e32a6['where']=_[_0x26c1('0x3e')](_0x2e32a6['where'],{'$or':_[_0x26c1('0x3f')](_0x2e32a6[_0x26c1('0x36')],function(_0x4c321c){var _0x2e731c={};_0x2e731c[_0x4c321c]={'$like':'%'+_0x29211f[_0x26c1('0x32')][_0x26c1('0x3d')]+'%'};return _0x2e731c;})});}_0x2e32a6=_[_0x26c1('0x3e')]({},_0x2e32a6,_0x29211f[_0x26c1('0x42')]);return _0x34b423[_0x26c1('0x4c')](_0x2e32a6);}})[_0x26c1('0x27')](function(_0x115b88){if(_0x115b88){_0x500ff9=_0x115b88[_0x26c1('0x4e')];if(!_0x29211f[_0x26c1('0x32')][_0x26c1('0x38')](_0x26c1('0x4f'))){_0x2e32a6[_0x26c1('0x1f')]=qs[_0x26c1('0x1f')](_0x29211f[_0x26c1('0x32')][_0x26c1('0x1f')]);_0x2e32a6['offset']=qs[_0x26c1('0x1d')](_0x29211f[_0x26c1('0x32')][_0x26c1('0x1d')]);}return _0x34b423['getConfigurations'](_0x2e32a6);}})[_0x26c1('0x27')](function(_0x25f324){if(_0x25f324){return _0x25f324?{'count':_0x500ff9,'rows':_0x25f324}:null;}})['then'](respondWithResult(_0x478a14,null))[_0x26c1('0x49')](handleError(_0x478a14,null));};exports[_0x26c1('0x50')]=function(_0x229620,_0x401a10,_0x4a602e){if(_0x229620['body']['id']){delete _0x229620['body']['id'];}return db[_0x26c1('0x2e')][_0x26c1('0x4d')]({'where':{'id':_0x229620['params']['id']}})[_0x26c1('0x27')](handleEntityNotFound(_0x401a10,null))[_0x26c1('0x27')](function(_0x41c1d3){if(_0x41c1d3){_0x229620[_0x26c1('0x4a')][_0x26c1('0x51')]=_0x41c1d3['id'];_0x229620[_0x26c1('0x4a')]['Subjects']=integrations['getSubjects'](_0x229620[_0x26c1('0x4a')][_0x26c1('0x52')],_0x229620[_0x26c1('0x4a')][_0x26c1('0x40')]);_0x229620[_0x26c1('0x4a')][_0x26c1('0x53')]=integrations['getDescriptions'](_0x229620[_0x26c1('0x4a')]['channel'],_0x229620[_0x26c1('0x4a')]['type']);return db[_0x26c1('0x54')]['create'](_0x229620[_0x26c1('0x4a')],{'include':[{'model':db[_0x26c1('0x55')],'as':_0x26c1('0x56')},{'model':db['VtigerField'],'as':_0x26c1('0x53')}]});}return null;})[_0x26c1('0x27')](respondWithResult(_0x401a10,null))[_0x26c1('0x49')](handleError(_0x401a10,null));};var md5=require(_0x26c1('0x57'));exports['getFields']=function(_0x7327ba,_0x2d5f68,_0x5ccc65){var _0x2e493b=null;var _0x502090=null;var _0x3f518d=null;var _0x22451d=null;var _0x2d1fbf='';return db[_0x26c1('0x2e')][_0x26c1('0x4d')]({'where':{'id':_0x7327ba['params']['id']},'attributes':['id',_0x26c1('0x2c'),_0x26c1('0x58'),'description',_0x26c1('0x59'),_0x26c1('0x5a'),_0x26c1('0x5b'),_0x26c1('0x5c')]})['then'](handleEntityNotFound(_0x2d5f68,null))['then'](function(_0x43b8bf){if(_0x43b8bf){_0x2e493b=_0x43b8bf[_0x26c1('0x58')];_0x502090=_0x43b8bf['accessKey'];_0x3f518d=_0x43b8bf['moduleName'];_0x2d1fbf=_0x43b8bf['remoteUri'];var _0x4cd000=_0x2d1fbf[_0x26c1('0x5d')](-0x1);if(_0x4cd000==='/'){_0x2d1fbf=_0x2d1fbf['substring'](0x0,_0x2d1fbf[_0x26c1('0x5e')](_0x4cd000));}_0x22451d=util[_0x26c1('0x5f')](_0x26c1('0x60'),_0x2d1fbf);var _0x34d88f={'method':_0x26c1('0x61'),'uri':_0x22451d,'qs':{'operation':_0x26c1('0x62'),'username':_0x43b8bf['username']},'json':!![]};return rp(_0x34d88f);}})['then'](function(_0x203525){if(_0x203525[_0x26c1('0x63')]){var _0x453570={'method':_0x26c1('0x64'),'uri':_0x22451d,'form':{'operation':_0x26c1('0x65'),'username':_0x2e493b,'accessKey':md5(_0x203525[_0x26c1('0x66')][_0x26c1('0x67')]+_0x502090)},'json':!![]};return rp(_0x453570);}})[_0x26c1('0x27')](function(_0x46370a){if(_0x46370a[_0x26c1('0x63')]){var _0x3e944f={'method':_0x26c1('0x61'),'uri':_0x22451d,'qs':{'operation':_0x26c1('0x68'),'username':_0x2e493b,'sessionName':_0x46370a[_0x26c1('0x66')]['sessionName'],'elementType':_0x3f518d},'json':!![]};return rp(_0x3e944f);}})['then'](function(_0x118ff7){if(_0x118ff7['success']){var _0x54deea=['autogenerated','reference',_0x26c1('0x69')];_[_0x26c1('0x6a')](_0x118ff7['result'][_0x26c1('0x37')],function(_0x131872){return _0x54deea[_0x26c1('0x6b')](_0x131872['type']['name']);});_[_0x26c1('0x6a')](_0x118ff7['result'][_0x26c1('0x37')],function(_0x38a215){return _0x38a215['editable']===_0x26c1('0x6c');});return{'count':_0x118ff7[_0x26c1('0x66')][_0x26c1('0x37')]['length'],'rows':_[_0x26c1('0x3f')](_0x118ff7[_0x26c1('0x66')][_0x26c1('0x37')],function(_0x18e1cd){return{'id':_0x18e1cd[_0x26c1('0x2c')],'name':_0x18e1cd['label'],'custom':_[_0x26c1('0x6d')](_0x18e1cd[_0x26c1('0x2c')],_0x26c1('0x6e'))?!![]:![],'options':_0x18e1cd[_0x26c1('0x40')][_0x26c1('0x2c')]===_0x26c1('0x6f')&&_0x18e1cd[_0x26c1('0x40')][_0x26c1('0x70')][_0x26c1('0x4e')]>0x0?_[_0x26c1('0x3f')](_0x18e1cd[_0x26c1('0x40')][_0x26c1('0x70')],function(_0x5810db){return{'name':_0x5810db[_0x26c1('0x71')],'value':_0x5810db[_0x26c1('0x72')]};}):[]};})};}})[_0x26c1('0x27')](respondWithResult(_0x2d5f68,null))[_0x26c1('0x49')](function(_0x35f5ab){console['log'](_0x26c1('0x73')+_0x35f5ab);var _0x56c397=_0x7327ba[_0x26c1('0x32')][_0x26c1('0x74')]?0x1f4:_0x35f5ab['statusCode']||0x1f4;logger['error'](_0x26c1('0x75'),_0x26c1('0x76'),_0x56c397,JSON['stringify'](_0x35f5ab));delete _0x35f5ab['name'];if(_0x56c397===0x191){_0x56c397=0x190;}_0x2d5f68[_0x26c1('0x1b')](_0x56c397)['send'](_0x7327ba['query'][_0x26c1('0x74')]?{'message':_0x26c1('0x77'),'statusCode':_0x35f5ab[_0x26c1('0x78')]}:_0x35f5ab);});};