2fbcd9c8a5248ff18a441fd202b9730dffc152a4
[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 _0x62cd=['substring','lastIndexOf','%s/webservice.php','getchallenge','success','POST','login','token','GET','result','autogenerated','reference','owner','remove','includes','false','cf_','picklist','picklistValues','value','vTiger\x20error:\x20','test','getFields,\x20%s,\x20%s,\x20%s','getFields','stringify','Wrong\x20credentials','statusCode','request-promise','bluebird','mustache','sox','to-csv','lodash','squel','crypto','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../mysqldb','../../components/integrations/configuration','sendStatus','end','status','undefined','limit','count','offset','set','Content-Range','json','apply','save','then','error','stack','name','send','index','map','VtigerAccount','rawAttributes','fieldName','type','model','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','where','filter','VIRTUAL','merge','options','includeAll','findAll','catch','show','params','keys','find','create','body','destroy','findOne','VtigerConfiguration','sort','pick','getConfigurations','addConfiguration','AccountId','Subjects','channel','Descriptions','VtigerField','username','description','moduleName','serverUrl','accessKey','remoteUri'];(function(_0x6ec61f,_0x3343d3){var _0x499c35=function(_0x515af5){while(--_0x515af5){_0x6ec61f['push'](_0x6ec61f['shift']());}};_0x499c35(++_0x3343d3);}(_0x62cd,0x16b));var _0xd62c=function(_0x2c0092,_0x164e34){_0x2c0092=_0x2c0092-0x0;var _0x4f2ccc=_0x62cd[_0x2c0092];return _0x4f2ccc;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0xd62c('0x0'));var moment=require('moment');var BPromise=require(_0xd62c('0x1'));var Mustache=require(_0xd62c('0x2'));var util=require('util');var path=require('path');var sox=require(_0xd62c('0x3'));var csv=require(_0xd62c('0x4'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xd62c('0x5'));var squel=require(_0xd62c('0x6'));var crypto=require(_0xd62c('0x7'));var jsforce=require('jsforce');var deskjs=require(_0xd62c('0x8'));var toCsv=require(_0xd62c('0x4'));var querystring=require(_0xd62c('0x9'));var Papa=require(_0xd62c('0xa'));var Redis=require(_0xd62c('0xb'));var authService=require(_0xd62c('0xc'));var qs=require(_0xd62c('0xd'));var as=require(_0xd62c('0xe'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xd62c('0xf'))(_0xd62c('0x10'));var utils=require(_0xd62c('0x11'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require(_0xd62c('0x12'))['db'];var integrations=require(_0xd62c('0x13'));function respondWithStatusCode(_0x172ae1,_0x433735){_0x433735=_0x433735||0xcc;return function(_0x2258a3){if(_0x2258a3){return _0x172ae1[_0xd62c('0x14')](_0x433735);}return _0x172ae1['status'](_0x433735)[_0xd62c('0x15')]();};}function respondWithResult(_0x22f975,_0x42b55b){_0x42b55b=_0x42b55b||0xc8;return function(_0x4718b1){if(_0x4718b1){return _0x22f975[_0xd62c('0x16')](_0x42b55b)['json'](_0x4718b1);}};}function respondWithFilteredResult(_0x44e1ee,_0x35c758){return function(_0x18aa58){if(_0x18aa58){var _0xd41a4d=typeof _0x35c758['offset']===_0xd62c('0x17')&&typeof _0x35c758[_0xd62c('0x18')]===_0xd62c('0x17');var _0x4e841a=_0x18aa58[_0xd62c('0x19')];var _0x1a2557=_0xd41a4d?0x0:_0x35c758['offset'];var _0x3df67e=_0xd41a4d?_0x18aa58[_0xd62c('0x19')]:_0x35c758[_0xd62c('0x1a')]+_0x35c758[_0xd62c('0x18')];var _0x34a444;if(_0x3df67e>=_0x4e841a){_0x3df67e=_0x4e841a;_0x34a444=0xc8;}else{_0x34a444=0xce;}_0x44e1ee['status'](_0x34a444);return _0x44e1ee[_0xd62c('0x1b')](_0xd62c('0x1c'),_0x1a2557+'-'+_0x3df67e+'/'+_0x4e841a)[_0xd62c('0x1d')](_0x18aa58);}return null;};}function patchUpdates(_0x1a3a25){return function(_0x19dca3){try{jsonpatch[_0xd62c('0x1e')](_0x19dca3,_0x1a3a25,!![]);}catch(_0x185a34){return BPromise['reject'](_0x185a34);}return _0x19dca3[_0xd62c('0x1f')]();};}function saveUpdates(_0x3f967b,_0x4e3e58){return function(_0x1df754){if(_0x1df754){return _0x1df754['update'](_0x3f967b)[_0xd62c('0x20')](function(_0x5ae6d8){return _0x5ae6d8;});}return null;};}function removeEntity(_0x4385f9,_0x2a17fd){return function(_0x4b8ce5){if(_0x4b8ce5){return _0x4b8ce5['destroy']()['then'](function(){_0x4385f9[_0xd62c('0x16')](0xcc)['end']();});}};}function handleEntityNotFound(_0x1d922f,_0x8a1696){return function(_0x545ca2){if(!_0x545ca2){_0x1d922f[_0xd62c('0x14')](0x194);}return _0x545ca2;};}function handleError(_0x553354,_0x55d92f){_0x55d92f=_0x55d92f||0x1f4;return function(_0xbb12bf){logger[_0xd62c('0x21')](_0xbb12bf[_0xd62c('0x22')]);if(_0xbb12bf[_0xd62c('0x23')]){delete _0xbb12bf[_0xd62c('0x23')];}_0x553354['status'](_0x55d92f)[_0xd62c('0x24')](_0xbb12bf);};}exports[_0xd62c('0x25')]=function(_0x14c625,_0x5eac6a){var _0x594b65={},_0x135059={},_0x502490={'count':0x0,'rows':[]};var _0x394ab4=_[_0xd62c('0x26')](db[_0xd62c('0x27')][_0xd62c('0x28')],function(_0x3ca41f){return{'name':_0x3ca41f[_0xd62c('0x29')],'type':_0x3ca41f[_0xd62c('0x2a')]['key']};});_0x135059[_0xd62c('0x2b')]=_[_0xd62c('0x26')](_0x394ab4,_0xd62c('0x23'));_0x135059[_0xd62c('0x2c')]=_['keys'](_0x14c625[_0xd62c('0x2c')]);_0x135059[_0xd62c('0x2d')]=_[_0xd62c('0x2e')](_0x135059[_0xd62c('0x2b')],_0x135059[_0xd62c('0x2c')]);_0x594b65[_0xd62c('0x2f')]=_[_0xd62c('0x2e')](_0x135059[_0xd62c('0x2b')],qs[_0xd62c('0x30')](_0x14c625['query']['fields']));_0x594b65[_0xd62c('0x2f')]=_0x594b65[_0xd62c('0x2f')][_0xd62c('0x31')]?_0x594b65['attributes']:_0x135059['model'];if(!_0x14c625[_0xd62c('0x2c')][_0xd62c('0x32')](_0xd62c('0x33'))){_0x594b65[_0xd62c('0x18')]=qs['limit'](_0x14c625[_0xd62c('0x2c')][_0xd62c('0x18')]);_0x594b65[_0xd62c('0x1a')]=qs['offset'](_0x14c625[_0xd62c('0x2c')][_0xd62c('0x1a')]);}_0x594b65[_0xd62c('0x34')]=qs['sort'](_0x14c625[_0xd62c('0x2c')]['sort']);_0x594b65[_0xd62c('0x35')]=qs[_0xd62c('0x2d')](_['pick'](_0x14c625[_0xd62c('0x2c')],_0x135059['filters']),_0x394ab4);if(_0x14c625[_0xd62c('0x2c')][_0xd62c('0x36')]){_0x594b65['where']=_['merge'](_0x594b65[_0xd62c('0x35')],{'$or':_[_0xd62c('0x26')](_0x394ab4,function(_0x4260ad){if(_0x4260ad[_0xd62c('0x2a')]!==_0xd62c('0x37')){var _0x45ea69={};_0x45ea69[_0x4260ad[_0xd62c('0x23')]]={'$like':'%'+_0x14c625['query'][_0xd62c('0x36')]+'%'};return _0x45ea69;}})});}_0x594b65=_[_0xd62c('0x38')]({},_0x594b65,_0x14c625[_0xd62c('0x39')]);var _0x165bf3={'where':_0x594b65[_0xd62c('0x35')]};return db[_0xd62c('0x27')]['count'](_0x165bf3)[_0xd62c('0x20')](function(_0x4df2a7){_0x502490[_0xd62c('0x19')]=_0x4df2a7;if(_0x14c625['query'][_0xd62c('0x3a')]){_0x594b65['include']=[{'all':!![]}];}return db[_0xd62c('0x27')][_0xd62c('0x3b')](_0x594b65);})[_0xd62c('0x20')](function(_0x4761a2){_0x502490['rows']=_0x4761a2;return _0x502490;})[_0xd62c('0x20')](respondWithFilteredResult(_0x5eac6a,_0x594b65))[_0xd62c('0x3c')](handleError(_0x5eac6a,null));};exports[_0xd62c('0x3d')]=function(_0x4092ea,_0x23932f){var _0x322db1={'raw':![],'where':{'id':_0x4092ea[_0xd62c('0x3e')]['id']}},_0x4c4739={};_0x4c4739['model']=_[_0xd62c('0x3f')](db[_0xd62c('0x27')][_0xd62c('0x28')]);_0x4c4739[_0xd62c('0x2c')]=_[_0xd62c('0x3f')](_0x4092ea[_0xd62c('0x2c')]);_0x4c4739[_0xd62c('0x2d')]=_['intersection'](_0x4c4739[_0xd62c('0x2b')],_0x4c4739[_0xd62c('0x2c')]);_0x322db1[_0xd62c('0x2f')]=_['intersection'](_0x4c4739[_0xd62c('0x2b')],qs['fields'](_0x4092ea[_0xd62c('0x2c')][_0xd62c('0x30')]));_0x322db1['attributes']=_0x322db1[_0xd62c('0x2f')][_0xd62c('0x31')]?_0x322db1['attributes']:_0x4c4739[_0xd62c('0x2b')];if(_0x4092ea['query'][_0xd62c('0x3a')]){_0x322db1['include']=[{'all':!![]}];}_0x322db1=_[_0xd62c('0x38')]({},_0x322db1,_0x4092ea[_0xd62c('0x39')]);return db['VtigerAccount'][_0xd62c('0x40')](_0x322db1)[_0xd62c('0x20')](handleEntityNotFound(_0x23932f,null))['then'](respondWithResult(_0x23932f,null))[_0xd62c('0x3c')](handleError(_0x23932f,null));};exports['create']=function(_0x204716,_0x30c343){return db[_0xd62c('0x27')][_0xd62c('0x41')](_0x204716[_0xd62c('0x42')],{})['then'](respondWithResult(_0x30c343,0xc9))[_0xd62c('0x3c')](handleError(_0x30c343,null));};exports['update']=function(_0x1cbe9c,_0x28fccc){if(_0x1cbe9c[_0xd62c('0x42')]['id']){delete _0x1cbe9c[_0xd62c('0x42')]['id'];}return db[_0xd62c('0x27')][_0xd62c('0x40')]({'where':{'id':_0x1cbe9c['params']['id']}})[_0xd62c('0x20')](handleEntityNotFound(_0x28fccc,null))[_0xd62c('0x20')](saveUpdates(_0x1cbe9c[_0xd62c('0x42')],null))['then'](respondWithResult(_0x28fccc,null))[_0xd62c('0x3c')](handleError(_0x28fccc,null));};exports[_0xd62c('0x43')]=function(_0x39145f,_0x2b4320){return db[_0xd62c('0x27')][_0xd62c('0x40')]({'where':{'id':_0x39145f['params']['id']}})['then'](handleEntityNotFound(_0x2b4320,null))['then'](removeEntity(_0x2b4320,null))['catch'](handleError(_0x2b4320,null));};exports['getConfigurations']=function(_0x53a64f,_0x1cc2f6,_0x3253c8){var _0x5cdca5={};var _0x3f9885={};var _0x3507b9;var _0xee6e47;return db[_0xd62c('0x27')][_0xd62c('0x44')]({'where':{'id':_0x53a64f[_0xd62c('0x3e')]['id']}})[_0xd62c('0x20')](handleEntityNotFound(_0x1cc2f6,null))['then'](function(_0x160314){if(_0x160314){_0x3507b9=_0x160314;_0x3f9885['model']=_[_0xd62c('0x3f')](db[_0xd62c('0x45')][_0xd62c('0x28')]);_0x3f9885[_0xd62c('0x2c')]=_[_0xd62c('0x3f')](_0x53a64f[_0xd62c('0x2c')]);_0x3f9885[_0xd62c('0x2d')]=_[_0xd62c('0x2e')](_0x3f9885[_0xd62c('0x2b')],_0x3f9885[_0xd62c('0x2c')]);_0x5cdca5[_0xd62c('0x2f')]=_['intersection'](_0x3f9885[_0xd62c('0x2b')],qs['fields'](_0x53a64f[_0xd62c('0x2c')][_0xd62c('0x30')]));_0x5cdca5['attributes']=_0x5cdca5[_0xd62c('0x2f')][_0xd62c('0x31')]?_0x5cdca5[_0xd62c('0x2f')]:_0x3f9885[_0xd62c('0x2b')];_0x5cdca5[_0xd62c('0x34')]=qs[_0xd62c('0x46')](_0x53a64f[_0xd62c('0x2c')][_0xd62c('0x46')]);_0x5cdca5[_0xd62c('0x35')]=qs['filters'](_[_0xd62c('0x47')](_0x53a64f[_0xd62c('0x2c')],_0x3f9885[_0xd62c('0x2d')]));if(_0x53a64f['query'][_0xd62c('0x36')]){_0x5cdca5[_0xd62c('0x35')]=_['merge'](_0x5cdca5[_0xd62c('0x35')],{'$or':_[_0xd62c('0x26')](_0x5cdca5[_0xd62c('0x2f')],function(_0x4f8f91){var _0x40a387={};_0x40a387[_0x4f8f91]={'$like':'%'+_0x53a64f[_0xd62c('0x2c')][_0xd62c('0x36')]+'%'};return _0x40a387;})});}_0x5cdca5=_[_0xd62c('0x38')]({},_0x5cdca5,_0x53a64f['options']);return _0x3507b9[_0xd62c('0x48')](_0x5cdca5);}})[_0xd62c('0x20')](function(_0x41552f){if(_0x41552f){_0xee6e47=_0x41552f[_0xd62c('0x31')];if(!_0x53a64f[_0xd62c('0x2c')][_0xd62c('0x32')]('nolimit')){_0x5cdca5[_0xd62c('0x18')]=qs['limit'](_0x53a64f[_0xd62c('0x2c')][_0xd62c('0x18')]);_0x5cdca5[_0xd62c('0x1a')]=qs[_0xd62c('0x1a')](_0x53a64f[_0xd62c('0x2c')][_0xd62c('0x1a')]);}return _0x3507b9['getConfigurations'](_0x5cdca5);}})[_0xd62c('0x20')](function(_0x1665db){if(_0x1665db){return _0x1665db?{'count':_0xee6e47,'rows':_0x1665db}:null;}})[_0xd62c('0x20')](respondWithResult(_0x1cc2f6,null))[_0xd62c('0x3c')](handleError(_0x1cc2f6,null));};exports[_0xd62c('0x49')]=function(_0x2496b3,_0x43fe78,_0x5cc3d7){if(_0x2496b3['body']['id']){delete _0x2496b3['body']['id'];}return db[_0xd62c('0x27')][_0xd62c('0x44')]({'where':{'id':_0x2496b3['params']['id']}})['then'](handleEntityNotFound(_0x43fe78,null))[_0xd62c('0x20')](function(_0x224269){if(_0x224269){_0x2496b3['body'][_0xd62c('0x4a')]=_0x224269['id'];_0x2496b3[_0xd62c('0x42')][_0xd62c('0x4b')]=integrations['getSubjects'](_0x2496b3[_0xd62c('0x42')][_0xd62c('0x4c')],_0x2496b3['body'][_0xd62c('0x2a')]);_0x2496b3[_0xd62c('0x42')][_0xd62c('0x4d')]=integrations['getDescriptions'](_0x2496b3[_0xd62c('0x42')][_0xd62c('0x4c')],_0x2496b3['body'][_0xd62c('0x2a')]);return db[_0xd62c('0x45')][_0xd62c('0x41')](_0x2496b3[_0xd62c('0x42')],{'include':[{'model':db[_0xd62c('0x4e')],'as':_0xd62c('0x4b')},{'model':db['VtigerField'],'as':_0xd62c('0x4d')}]});}return null;})[_0xd62c('0x20')](respondWithResult(_0x43fe78,null))[_0xd62c('0x3c')](handleError(_0x43fe78,null));};var md5=require('md5');exports['getFields']=function(_0x20f19d,_0x36e7dc,_0x4f3a37){var _0x4503e9=null;var _0xcab2c=null;var _0x7d2273=null;var _0x3c226b=null;var _0x30ac32='';return db[_0xd62c('0x27')][_0xd62c('0x44')]({'where':{'id':_0x20f19d[_0xd62c('0x3e')]['id']},'attributes':['id','name',_0xd62c('0x4f'),_0xd62c('0x50'),_0xd62c('0x51'),'remoteUri',_0xd62c('0x52'),_0xd62c('0x53')]})[_0xd62c('0x20')](handleEntityNotFound(_0x36e7dc,null))['then'](function(_0x1a3722){if(_0x1a3722){_0x4503e9=_0x1a3722[_0xd62c('0x4f')];_0xcab2c=_0x1a3722[_0xd62c('0x53')];_0x7d2273=_0x1a3722['moduleName'];_0x30ac32=_0x1a3722[_0xd62c('0x54')];var _0x2d911c=_0x30ac32['slice'](-0x1);if(_0x2d911c==='/'){_0x30ac32=_0x30ac32[_0xd62c('0x55')](0x0,_0x30ac32[_0xd62c('0x56')](_0x2d911c));}_0x3c226b=util['format'](_0xd62c('0x57'),_0x30ac32);var _0x106032={'method':'GET','uri':_0x3c226b,'qs':{'operation':_0xd62c('0x58'),'username':_0x1a3722[_0xd62c('0x4f')]},'json':!![]};return rp(_0x106032);}})['then'](function(_0x507e02){if(_0x507e02[_0xd62c('0x59')]){var _0x20ddc2={'method':_0xd62c('0x5a'),'uri':_0x3c226b,'form':{'operation':_0xd62c('0x5b'),'username':_0x4503e9,'accessKey':md5(_0x507e02['result'][_0xd62c('0x5c')]+_0xcab2c)},'json':!![]};return rp(_0x20ddc2);}})[_0xd62c('0x20')](function(_0x4e9a59){if(_0x4e9a59[_0xd62c('0x59')]){var _0x3c6b54={'method':_0xd62c('0x5d'),'uri':_0x3c226b,'qs':{'operation':'describe','username':_0x4503e9,'sessionName':_0x4e9a59[_0xd62c('0x5e')]['sessionName'],'elementType':_0x7d2273},'json':!![]};return rp(_0x3c6b54);}})['then'](function(_0x542ec8){if(_0x542ec8[_0xd62c('0x59')]){var _0xd17a50=[_0xd62c('0x5f'),_0xd62c('0x60'),_0xd62c('0x61')];_[_0xd62c('0x62')](_0x542ec8[_0xd62c('0x5e')][_0xd62c('0x30')],function(_0x37256d){return _0xd17a50[_0xd62c('0x63')](_0x37256d[_0xd62c('0x2a')][_0xd62c('0x23')]);});_[_0xd62c('0x62')](_0x542ec8[_0xd62c('0x5e')][_0xd62c('0x30')],function(_0x447c22){return _0x447c22['editable']===_0xd62c('0x64');});return{'count':_0x542ec8[_0xd62c('0x5e')][_0xd62c('0x30')]['length'],'rows':_['map'](_0x542ec8['result'][_0xd62c('0x30')],function(_0x5bc4c1){return{'id':_0x5bc4c1[_0xd62c('0x23')],'name':_0x5bc4c1['label'],'custom':_['startsWith'](_0x5bc4c1[_0xd62c('0x23')],_0xd62c('0x65'))?!![]:![],'options':_0x5bc4c1[_0xd62c('0x2a')][_0xd62c('0x23')]===_0xd62c('0x66')&&_0x5bc4c1[_0xd62c('0x2a')]['picklistValues'][_0xd62c('0x31')]>0x0?_[_0xd62c('0x26')](_0x5bc4c1[_0xd62c('0x2a')][_0xd62c('0x67')],function(_0x4e3cc5){return{'name':_0x4e3cc5['label'],'value':_0x4e3cc5[_0xd62c('0x68')]};}):[]};})};}})[_0xd62c('0x20')](respondWithResult(_0x36e7dc,null))[_0xd62c('0x3c')](function(_0xdbc650){console['log'](_0xd62c('0x69')+_0xdbc650);var _0x29fc5d=_0x20f19d[_0xd62c('0x2c')][_0xd62c('0x6a')]?0x1f4:_0xdbc650['statusCode']||0x1f4;logger[_0xd62c('0x21')](_0xd62c('0x6b'),_0xd62c('0x6c'),_0x29fc5d,JSON[_0xd62c('0x6d')](_0xdbc650));delete _0xdbc650[_0xd62c('0x23')];if(_0x29fc5d===0x191){_0x29fc5d=0x190;}_0x36e7dc['status'](_0x29fc5d)[_0xd62c('0x24')](_0x20f19d[_0xd62c('0x2c')][_0xd62c('0x6a')]?{'message':_0xd62c('0x6e'),'statusCode':_0xdbc650[_0xd62c('0x6f')]}:_0xdbc650);});};