Built motion from commit e6806ed6.|2.6.0
[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 _0xa4af=['then','sendStatus','error','name','send','index','map','VtigerAccount','rawAttributes','fieldName','type','model','query','keys','intersection','attributes','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','merge','VIRTUAL','options','count','includeAll','findAll','rows','catch','show','params','fields','length','include','find','create','body','destroy','VtigerConfiguration','getConfigurations','findOne','AccountId','Subjects','getSubjects','channel','Descriptions','getDescriptions','VtigerField','description','moduleName','remoteUri','serverUrl','accessKey','username','slice','substring','lastIndexOf','format','%s/webservice.php','POST','token','success','describe','result','sessionName','reference','owner','remove','includes','editable','false','startsWith','picklist','label','value','log','vTiger\x20error:\x20','statusCode','getFields','test','Wrong\x20credentials','rimraf','fast-json-patch','request-promise','mustache','util','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','../../components/integrations/configuration','status','end','json','offset','undefined','limit','set','Content-Range','apply','reject','save','update'];(function(_0x586e62,_0x58ce46){var _0x361bf0=function(_0x4e54bf){while(--_0x4e54bf){_0x586e62['push'](_0x586e62['shift']());}};_0x361bf0(++_0x58ce46);}(_0xa4af,0x144));var _0xfa4a=function(_0xf4891c,_0xfadc7a){_0xf4891c=_0xf4891c-0x0;var _0x197319=_0xa4af[_0xf4891c];return _0x197319;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xfa4a('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0xfa4a('0x1'));var rp=require(_0xfa4a('0x2'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0xfa4a('0x3'));var util=require(_0xfa4a('0x4'));var path=require('path');var sox=require(_0xfa4a('0x5'));var csv=require(_0xfa4a('0x6'));var ejs=require(_0xfa4a('0x7'));var fs=require('fs');var fs_extra=require(_0xfa4a('0x8'));var _=require(_0xfa4a('0x9'));var squel=require(_0xfa4a('0xa'));var crypto=require(_0xfa4a('0xb'));var jsforce=require('jsforce');var deskjs=require(_0xfa4a('0xc'));var toCsv=require(_0xfa4a('0x6'));var querystring=require(_0xfa4a('0xd'));var Papa=require(_0xfa4a('0xe'));var Redis=require('ioredis');var authService=require(_0xfa4a('0xf'));var qs=require(_0xfa4a('0x10'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0xfa4a('0x11'))(_0xfa4a('0x12'));var utils=require(_0xfa4a('0x13'));var config=require(_0xfa4a('0x14'));var licenseUtil=require(_0xfa4a('0x15'));var db=require(_0xfa4a('0x16'))['db'];var integrations=require(_0xfa4a('0x17'));function respondWithStatusCode(_0x360723,_0x48b535){_0x48b535=_0x48b535||0xcc;return function(_0x518374){if(_0x518374){return _0x360723['sendStatus'](_0x48b535);}return _0x360723[_0xfa4a('0x18')](_0x48b535)[_0xfa4a('0x19')]();};}function respondWithResult(_0x19a71b,_0x176365){_0x176365=_0x176365||0xc8;return function(_0xcbd892){if(_0xcbd892){return _0x19a71b[_0xfa4a('0x18')](_0x176365)[_0xfa4a('0x1a')](_0xcbd892);}};}function respondWithFilteredResult(_0x5aafd8,_0x36f51b){return function(_0x3a3b46){if(_0x3a3b46){var _0x63dae7=typeof _0x36f51b[_0xfa4a('0x1b')]===_0xfa4a('0x1c')&&typeof _0x36f51b[_0xfa4a('0x1d')]===_0xfa4a('0x1c');var _0x507c69=_0x3a3b46['count'];var _0x53a850=_0x63dae7?0x0:_0x36f51b['offset'];var _0x58ff63=_0x63dae7?_0x3a3b46['count']:_0x36f51b[_0xfa4a('0x1b')]+_0x36f51b[_0xfa4a('0x1d')];var _0x4b5437;if(_0x58ff63>=_0x507c69){_0x58ff63=_0x507c69;_0x4b5437=0xc8;}else{_0x4b5437=0xce;}_0x5aafd8[_0xfa4a('0x18')](_0x4b5437);return _0x5aafd8[_0xfa4a('0x1e')](_0xfa4a('0x1f'),_0x53a850+'-'+_0x58ff63+'/'+_0x507c69)[_0xfa4a('0x1a')](_0x3a3b46);}return null;};}function patchUpdates(_0x5cf6d8){return function(_0x21903d){try{jsonpatch[_0xfa4a('0x20')](_0x21903d,_0x5cf6d8,!![]);}catch(_0x1bc200){return BPromise[_0xfa4a('0x21')](_0x1bc200);}return _0x21903d[_0xfa4a('0x22')]();};}function saveUpdates(_0x3675c7,_0x383d8c){return function(_0x2b58a8){if(_0x2b58a8){return _0x2b58a8[_0xfa4a('0x23')](_0x3675c7)['then'](function(_0x36984b){return _0x36984b;});}return null;};}function removeEntity(_0x40e388,_0x37af58){return function(_0x374222){if(_0x374222){return _0x374222['destroy']()[_0xfa4a('0x24')](function(){_0x40e388[_0xfa4a('0x18')](0xcc)['end']();});}};}function handleEntityNotFound(_0x21da01,_0x1e092f){return function(_0x3e8f55){if(!_0x3e8f55){_0x21da01[_0xfa4a('0x25')](0x194);}return _0x3e8f55;};}function handleError(_0x401edf,_0x5e1a56){_0x5e1a56=_0x5e1a56||0x1f4;return function(_0x3e619c){logger[_0xfa4a('0x26')](_0x3e619c['stack']);if(_0x3e619c['name']){delete _0x3e619c[_0xfa4a('0x27')];}_0x401edf['status'](_0x5e1a56)[_0xfa4a('0x28')](_0x3e619c);};}exports[_0xfa4a('0x29')]=function(_0x585da4,_0x2c02ce){var _0x8324b6={},_0x3f22d7={},_0x3c9c28={'count':0x0,'rows':[]};var _0x4fe708=_[_0xfa4a('0x2a')](db[_0xfa4a('0x2b')][_0xfa4a('0x2c')],function(_0x2dbf98){return{'name':_0x2dbf98[_0xfa4a('0x2d')],'type':_0x2dbf98[_0xfa4a('0x2e')]['key']};});_0x3f22d7[_0xfa4a('0x2f')]=_[_0xfa4a('0x2a')](_0x4fe708,_0xfa4a('0x27'));_0x3f22d7[_0xfa4a('0x30')]=_[_0xfa4a('0x31')](_0x585da4[_0xfa4a('0x30')]);_0x3f22d7['filters']=_[_0xfa4a('0x32')](_0x3f22d7[_0xfa4a('0x2f')],_0x3f22d7[_0xfa4a('0x30')]);_0x8324b6['attributes']=_[_0xfa4a('0x32')](_0x3f22d7[_0xfa4a('0x2f')],qs['fields'](_0x585da4[_0xfa4a('0x30')]['fields']));_0x8324b6[_0xfa4a('0x33')]=_0x8324b6[_0xfa4a('0x33')]['length']?_0x8324b6[_0xfa4a('0x33')]:_0x3f22d7[_0xfa4a('0x2f')];if(!_0x585da4[_0xfa4a('0x30')][_0xfa4a('0x34')](_0xfa4a('0x35'))){_0x8324b6['limit']=qs[_0xfa4a('0x1d')](_0x585da4[_0xfa4a('0x30')]['limit']);_0x8324b6['offset']=qs['offset'](_0x585da4[_0xfa4a('0x30')][_0xfa4a('0x1b')]);}_0x8324b6[_0xfa4a('0x36')]=qs[_0xfa4a('0x37')](_0x585da4[_0xfa4a('0x30')][_0xfa4a('0x37')]);_0x8324b6[_0xfa4a('0x38')]=qs[_0xfa4a('0x39')](_[_0xfa4a('0x3a')](_0x585da4['query'],_0x3f22d7[_0xfa4a('0x39')]),_0x4fe708);if(_0x585da4['query'][_0xfa4a('0x3b')]){_0x8324b6[_0xfa4a('0x38')]=_[_0xfa4a('0x3c')](_0x8324b6[_0xfa4a('0x38')],{'$or':_[_0xfa4a('0x2a')](_0x4fe708,function(_0x5b0ef4){if(_0x5b0ef4[_0xfa4a('0x2e')]!==_0xfa4a('0x3d')){var _0x2323f9={};_0x2323f9[_0x5b0ef4[_0xfa4a('0x27')]]={'$like':'%'+_0x585da4['query'][_0xfa4a('0x3b')]+'%'};return _0x2323f9;}})});}_0x8324b6=_[_0xfa4a('0x3c')]({},_0x8324b6,_0x585da4[_0xfa4a('0x3e')]);var _0x32416f={'where':_0x8324b6[_0xfa4a('0x38')]};return db['VtigerAccount'][_0xfa4a('0x3f')](_0x32416f)[_0xfa4a('0x24')](function(_0x2e9998){_0x3c9c28['count']=_0x2e9998;if(_0x585da4['query'][_0xfa4a('0x40')]){_0x8324b6['include']=[{'all':!![]}];}return db['VtigerAccount'][_0xfa4a('0x41')](_0x8324b6);})[_0xfa4a('0x24')](function(_0x4503e8){_0x3c9c28[_0xfa4a('0x42')]=_0x4503e8;return _0x3c9c28;})[_0xfa4a('0x24')](respondWithFilteredResult(_0x2c02ce,_0x8324b6))[_0xfa4a('0x43')](handleError(_0x2c02ce,null));};exports[_0xfa4a('0x44')]=function(_0x39a00a,_0x1bb5b1){var _0x54a2c6={'raw':![],'where':{'id':_0x39a00a[_0xfa4a('0x45')]['id']}},_0x5cf096={};_0x5cf096[_0xfa4a('0x2f')]=_['keys'](db[_0xfa4a('0x2b')]['rawAttributes']);_0x5cf096[_0xfa4a('0x30')]=_[_0xfa4a('0x31')](_0x39a00a[_0xfa4a('0x30')]);_0x5cf096['filters']=_[_0xfa4a('0x32')](_0x5cf096[_0xfa4a('0x2f')],_0x5cf096[_0xfa4a('0x30')]);_0x54a2c6[_0xfa4a('0x33')]=_[_0xfa4a('0x32')](_0x5cf096[_0xfa4a('0x2f')],qs[_0xfa4a('0x46')](_0x39a00a[_0xfa4a('0x30')][_0xfa4a('0x46')]));_0x54a2c6[_0xfa4a('0x33')]=_0x54a2c6[_0xfa4a('0x33')][_0xfa4a('0x47')]?_0x54a2c6[_0xfa4a('0x33')]:_0x5cf096['model'];if(_0x39a00a['query'][_0xfa4a('0x40')]){_0x54a2c6[_0xfa4a('0x48')]=[{'all':!![]}];}_0x54a2c6=_[_0xfa4a('0x3c')]({},_0x54a2c6,_0x39a00a[_0xfa4a('0x3e')]);return db['VtigerAccount'][_0xfa4a('0x49')](_0x54a2c6)[_0xfa4a('0x24')](handleEntityNotFound(_0x1bb5b1,null))['then'](respondWithResult(_0x1bb5b1,null))[_0xfa4a('0x43')](handleError(_0x1bb5b1,null));};exports['create']=function(_0x4fbd69,_0x45078b){return db['VtigerAccount'][_0xfa4a('0x4a')](_0x4fbd69[_0xfa4a('0x4b')],{})[_0xfa4a('0x24')](respondWithResult(_0x45078b,0xc9))[_0xfa4a('0x43')](handleError(_0x45078b,null));};exports[_0xfa4a('0x23')]=function(_0x4783ab,_0x3b8f2d){if(_0x4783ab[_0xfa4a('0x4b')]['id']){delete _0x4783ab[_0xfa4a('0x4b')]['id'];}return db[_0xfa4a('0x2b')][_0xfa4a('0x49')]({'where':{'id':_0x4783ab[_0xfa4a('0x45')]['id']}})['then'](handleEntityNotFound(_0x3b8f2d,null))[_0xfa4a('0x24')](saveUpdates(_0x4783ab[_0xfa4a('0x4b')],null))[_0xfa4a('0x24')](respondWithResult(_0x3b8f2d,null))[_0xfa4a('0x43')](handleError(_0x3b8f2d,null));};exports[_0xfa4a('0x4c')]=function(_0x4ab6be,_0x1cf23e){return db[_0xfa4a('0x2b')][_0xfa4a('0x49')]({'where':{'id':_0x4ab6be[_0xfa4a('0x45')]['id']}})[_0xfa4a('0x24')](handleEntityNotFound(_0x1cf23e,null))[_0xfa4a('0x24')](removeEntity(_0x1cf23e,null))['catch'](handleError(_0x1cf23e,null));};exports['getConfigurations']=function(_0x54f32c,_0x4a9e7b,_0x5c8822){var _0x10512c={};var _0xf1b637={};var _0x5ab31a;var _0x110431;return db['VtigerAccount']['findOne']({'where':{'id':_0x54f32c['params']['id']}})[_0xfa4a('0x24')](handleEntityNotFound(_0x4a9e7b,null))[_0xfa4a('0x24')](function(_0x40fcb1){if(_0x40fcb1){_0x5ab31a=_0x40fcb1;_0xf1b637[_0xfa4a('0x2f')]=_[_0xfa4a('0x31')](db[_0xfa4a('0x4d')][_0xfa4a('0x2c')]);_0xf1b637['query']=_[_0xfa4a('0x31')](_0x54f32c[_0xfa4a('0x30')]);_0xf1b637[_0xfa4a('0x39')]=_['intersection'](_0xf1b637['model'],_0xf1b637[_0xfa4a('0x30')]);_0x10512c[_0xfa4a('0x33')]=_[_0xfa4a('0x32')](_0xf1b637[_0xfa4a('0x2f')],qs[_0xfa4a('0x46')](_0x54f32c[_0xfa4a('0x30')][_0xfa4a('0x46')]));_0x10512c[_0xfa4a('0x33')]=_0x10512c['attributes'][_0xfa4a('0x47')]?_0x10512c[_0xfa4a('0x33')]:_0xf1b637[_0xfa4a('0x2f')];_0x10512c[_0xfa4a('0x36')]=qs[_0xfa4a('0x37')](_0x54f32c['query'][_0xfa4a('0x37')]);_0x10512c[_0xfa4a('0x38')]=qs[_0xfa4a('0x39')](_['pick'](_0x54f32c[_0xfa4a('0x30')],_0xf1b637[_0xfa4a('0x39')]));if(_0x54f32c[_0xfa4a('0x30')]['filter']){_0x10512c['where']=_[_0xfa4a('0x3c')](_0x10512c['where'],{'$or':_[_0xfa4a('0x2a')](_0x10512c['attributes'],function(_0x454ed8){var _0x55dc03={};_0x55dc03[_0x454ed8]={'$like':'%'+_0x54f32c['query'][_0xfa4a('0x3b')]+'%'};return _0x55dc03;})});}_0x10512c=_[_0xfa4a('0x3c')]({},_0x10512c,_0x54f32c[_0xfa4a('0x3e')]);return _0x5ab31a['getConfigurations'](_0x10512c);}})[_0xfa4a('0x24')](function(_0x4637e6){if(_0x4637e6){_0x110431=_0x4637e6[_0xfa4a('0x47')];if(!_0x54f32c['query'][_0xfa4a('0x34')]('nolimit')){_0x10512c['limit']=qs[_0xfa4a('0x1d')](_0x54f32c[_0xfa4a('0x30')]['limit']);_0x10512c[_0xfa4a('0x1b')]=qs[_0xfa4a('0x1b')](_0x54f32c[_0xfa4a('0x30')][_0xfa4a('0x1b')]);}return _0x5ab31a[_0xfa4a('0x4e')](_0x10512c);}})['then'](function(_0x50efe7){if(_0x50efe7){return _0x50efe7?{'count':_0x110431,'rows':_0x50efe7}:null;}})['then'](respondWithResult(_0x4a9e7b,null))[_0xfa4a('0x43')](handleError(_0x4a9e7b,null));};exports['addConfiguration']=function(_0x22e0cd,_0x18322f,_0x5c426d){if(_0x22e0cd[_0xfa4a('0x4b')]['id']){delete _0x22e0cd[_0xfa4a('0x4b')]['id'];}return db[_0xfa4a('0x2b')][_0xfa4a('0x4f')]({'where':{'id':_0x22e0cd[_0xfa4a('0x45')]['id']}})[_0xfa4a('0x24')](handleEntityNotFound(_0x18322f,null))['then'](function(_0x40908e){if(_0x40908e){_0x22e0cd['body'][_0xfa4a('0x50')]=_0x40908e['id'];_0x22e0cd[_0xfa4a('0x4b')][_0xfa4a('0x51')]=integrations[_0xfa4a('0x52')](_0x22e0cd[_0xfa4a('0x4b')][_0xfa4a('0x53')],_0x22e0cd[_0xfa4a('0x4b')]['type']);_0x22e0cd[_0xfa4a('0x4b')][_0xfa4a('0x54')]=integrations[_0xfa4a('0x55')](_0x22e0cd['body'][_0xfa4a('0x53')],_0x22e0cd[_0xfa4a('0x4b')][_0xfa4a('0x2e')]);return db[_0xfa4a('0x4d')][_0xfa4a('0x4a')](_0x22e0cd[_0xfa4a('0x4b')],{'include':[{'model':db[_0xfa4a('0x56')],'as':_0xfa4a('0x51')},{'model':db[_0xfa4a('0x56')],'as':'Descriptions'}]});}return null;})[_0xfa4a('0x24')](respondWithResult(_0x18322f,null))[_0xfa4a('0x43')](handleError(_0x18322f,null));};var md5=require('md5');exports['getFields']=function(_0x47367d,_0x25c676,_0x28e798){var _0x43e5f7=null;var _0x2b5585=null;var _0xab1901=null;var _0x1f9248=null;var _0x33e1e9='';return db[_0xfa4a('0x2b')][_0xfa4a('0x4f')]({'where':{'id':_0x47367d[_0xfa4a('0x45')]['id']},'attributes':['id',_0xfa4a('0x27'),'username',_0xfa4a('0x57'),_0xfa4a('0x58'),_0xfa4a('0x59'),_0xfa4a('0x5a'),_0xfa4a('0x5b')]})['then'](handleEntityNotFound(_0x25c676,null))[_0xfa4a('0x24')](function(_0x14d894){if(_0x14d894){_0x43e5f7=_0x14d894[_0xfa4a('0x5c')];_0x2b5585=_0x14d894[_0xfa4a('0x5b')];_0xab1901=_0x14d894[_0xfa4a('0x58')];_0x33e1e9=_0x14d894['remoteUri'];var _0x176198=_0x33e1e9[_0xfa4a('0x5d')](-0x1);if(_0x176198==='/'){_0x33e1e9=_0x33e1e9[_0xfa4a('0x5e')](0x0,_0x33e1e9[_0xfa4a('0x5f')](_0x176198));}_0x1f9248=util[_0xfa4a('0x60')](_0xfa4a('0x61'),_0x33e1e9);var _0x2f023e={'method':'GET','uri':_0x1f9248,'qs':{'operation':'getchallenge','username':_0x14d894[_0xfa4a('0x5c')]},'json':!![]};return rp(_0x2f023e);}})[_0xfa4a('0x24')](function(_0x4dbdd5){if(_0x4dbdd5['success']){var _0x2d2576={'method':_0xfa4a('0x62'),'uri':_0x1f9248,'form':{'operation':'login','username':_0x43e5f7,'accessKey':md5(_0x4dbdd5['result'][_0xfa4a('0x63')]+_0x2b5585)},'json':!![]};return rp(_0x2d2576);}})[_0xfa4a('0x24')](function(_0xfa8ef9){if(_0xfa8ef9[_0xfa4a('0x64')]){var _0x72fc90={'method':'GET','uri':_0x1f9248,'qs':{'operation':_0xfa4a('0x65'),'username':_0x43e5f7,'sessionName':_0xfa8ef9[_0xfa4a('0x66')][_0xfa4a('0x67')],'elementType':_0xab1901},'json':!![]};return rp(_0x72fc90);}})['then'](function(_0x572e3e){if(_0x572e3e['success']){var _0x559d1c=['autogenerated',_0xfa4a('0x68'),_0xfa4a('0x69')];_[_0xfa4a('0x6a')](_0x572e3e[_0xfa4a('0x66')][_0xfa4a('0x46')],function(_0xd24a91){return _0x559d1c[_0xfa4a('0x6b')](_0xd24a91[_0xfa4a('0x2e')][_0xfa4a('0x27')]);});_['remove'](_0x572e3e[_0xfa4a('0x66')][_0xfa4a('0x46')],function(_0x2d56b3){return _0x2d56b3[_0xfa4a('0x6c')]===_0xfa4a('0x6d');});return{'count':_0x572e3e[_0xfa4a('0x66')][_0xfa4a('0x46')]['length'],'rows':_[_0xfa4a('0x2a')](_0x572e3e[_0xfa4a('0x66')][_0xfa4a('0x46')],function(_0x1dfb64){return{'id':_0x1dfb64[_0xfa4a('0x27')],'name':_0x1dfb64['label'],'custom':_[_0xfa4a('0x6e')](_0x1dfb64[_0xfa4a('0x27')],'cf_')?!![]:![],'options':_0x1dfb64[_0xfa4a('0x2e')][_0xfa4a('0x27')]===_0xfa4a('0x6f')&&_0x1dfb64[_0xfa4a('0x2e')]['picklistValues'][_0xfa4a('0x47')]>0x0?_[_0xfa4a('0x2a')](_0x1dfb64[_0xfa4a('0x2e')]['picklistValues'],function(_0x335aaf){return{'name':_0x335aaf[_0xfa4a('0x70')],'value':_0x335aaf[_0xfa4a('0x71')]};}):[]};})};}})['then'](respondWithResult(_0x25c676,null))['catch'](function(_0x410c40){console[_0xfa4a('0x72')](_0xfa4a('0x73')+_0x410c40);var _0xae1be6=_0x47367d['query']['test']?0x1f4:_0x410c40[_0xfa4a('0x74')]||0x1f4;logger[_0xfa4a('0x26')]('getFields,\x20%s,\x20%s,\x20%s',_0xfa4a('0x75'),_0xae1be6,JSON['stringify'](_0x410c40));delete _0x410c40['name'];if(_0xae1be6===0x191){_0xae1be6=0x190;}_0x25c676[_0xfa4a('0x18')](_0xae1be6)['send'](_0x47367d[_0xfa4a('0x30')][_0xfa4a('0x76')]?{'message':_0xfa4a('0x77'),'statusCode':_0x410c40[_0xfa4a('0x74')]}:_0x410c40);});};