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 _0x1bb8=['AccountId','getSubjects','channel','VtigerConfiguration','create','VtigerField','Subjects','md5','getFields','username','remoteUri','serverUrl','accessKey','moduleName','slice','lastIndexOf','format','%s/webservice.php','GET','success','POST','login','result','token','describe','sessionName','autogenerated','reference','remove','includes','editable','false','label','startsWith','picklist','picklistValues','value','log','vTiger\x20error:\x20','statusCode','stringify','test','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','sox','to-csv','ejs','lodash','squel','crypto','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/license/util','../../mysqldb','../../components/integrations/configuration','sendStatus','status','end','undefined','limit','offset','count','set','Content-Range','json','apply','reject','save','update','destroy','error','stack','name','send','index','rawAttributes','fieldName','model','map','query','keys','filters','intersection','fields','attributes','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','type','VIRTUAL','options','VtigerAccount','then','includeAll','include','rows','catch','show','params','length','find','body','getConfigurations','findOne'];(function(_0x3bc72d,_0x5aaa33){var _0x3b7fbf=function(_0x106a76){while(--_0x106a76){_0x3bc72d['push'](_0x3bc72d['shift']());}};_0x3b7fbf(++_0x5aaa33);}(_0x1bb8,0x11e));var _0x81bb=function(_0x1c3513,_0x5da79f){_0x1c3513=_0x1c3513-0x0;var _0x162992=_0x1bb8[_0x1c3513];return _0x162992;};'use strict';var emlformat=require(_0x81bb('0x0'));var rimraf=require(_0x81bb('0x1'));var zipdir=require(_0x81bb('0x2'));var jsonpatch=require(_0x81bb('0x3'));var rp=require(_0x81bb('0x4'));var moment=require(_0x81bb('0x5'));var BPromise=require(_0x81bb('0x6'));var Mustache=require('mustache');var util=require(_0x81bb('0x7'));var path=require(_0x81bb('0x8'));var sox=require(_0x81bb('0x9'));var csv=require(_0x81bb('0xa'));var ejs=require(_0x81bb('0xb'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x81bb('0xc'));var squel=require(_0x81bb('0xd'));var crypto=require(_0x81bb('0xe'));var jsforce=require('jsforce');var deskjs=require(_0x81bb('0xf'));var toCsv=require('to-csv');var querystring=require(_0x81bb('0x10'));var Papa=require(_0x81bb('0x11'));var Redis=require(_0x81bb('0x12'));var authService=require('../../components/auth/service');var qs=require(_0x81bb('0x13'));var as=require(_0x81bb('0x14'));var hardwareService=require(_0x81bb('0x15'));var logger=require(_0x81bb('0x16'))('api');var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0x81bb('0x17'));var db=require(_0x81bb('0x18'))['db'];var integrations=require(_0x81bb('0x19'));function respondWithStatusCode(_0x25ae76,_0x41e871){_0x41e871=_0x41e871||0xcc;return function(_0x4d8e74){if(_0x4d8e74){return _0x25ae76[_0x81bb('0x1a')](_0x41e871);}return _0x25ae76[_0x81bb('0x1b')](_0x41e871)[_0x81bb('0x1c')]();};}function respondWithResult(_0x153fd5,_0x8e13e2){_0x8e13e2=_0x8e13e2||0xc8;return function(_0x25e4f1){if(_0x25e4f1){return _0x153fd5[_0x81bb('0x1b')](_0x8e13e2)['json'](_0x25e4f1);}};}function respondWithFilteredResult(_0x5e539c,_0x1592a2){return function(_0x452a9d){if(_0x452a9d){var _0x22985e=typeof _0x1592a2['offset']===_0x81bb('0x1d')&&typeof _0x1592a2[_0x81bb('0x1e')]===_0x81bb('0x1d');var _0x23abc8=_0x452a9d['count'];var _0x3073b8=_0x22985e?0x0:_0x1592a2[_0x81bb('0x1f')];var _0x4c4fa2=_0x22985e?_0x452a9d[_0x81bb('0x20')]:_0x1592a2[_0x81bb('0x1f')]+_0x1592a2[_0x81bb('0x1e')];var _0xdbdda9;if(_0x4c4fa2>=_0x23abc8){_0x4c4fa2=_0x23abc8;_0xdbdda9=0xc8;}else{_0xdbdda9=0xce;}_0x5e539c[_0x81bb('0x1b')](_0xdbdda9);return _0x5e539c[_0x81bb('0x21')](_0x81bb('0x22'),_0x3073b8+'-'+_0x4c4fa2+'/'+_0x23abc8)[_0x81bb('0x23')](_0x452a9d);}return null;};}function patchUpdates(_0x360541){return function(_0x3d778d){try{jsonpatch[_0x81bb('0x24')](_0x3d778d,_0x360541,!![]);}catch(_0x280aae){return BPromise[_0x81bb('0x25')](_0x280aae);}return _0x3d778d[_0x81bb('0x26')]();};}function saveUpdates(_0x5c5cc9,_0x48302c){return function(_0x387fae){if(_0x387fae){return _0x387fae[_0x81bb('0x27')](_0x5c5cc9)['then'](function(_0x79f9e7){return _0x79f9e7;});}return null;};}function removeEntity(_0x23a004,_0x462aef){return function(_0xff5fab){if(_0xff5fab){return _0xff5fab[_0x81bb('0x28')]()['then'](function(){_0x23a004[_0x81bb('0x1b')](0xcc)[_0x81bb('0x1c')]();});}};}function handleEntityNotFound(_0x3834e2,_0x3398c8){return function(_0x2fa3c3){if(!_0x2fa3c3){_0x3834e2['sendStatus'](0x194);}return _0x2fa3c3;};}function handleError(_0x4a33cf,_0x1f295e){_0x1f295e=_0x1f295e||0x1f4;return function(_0x265906){logger[_0x81bb('0x29')](_0x265906[_0x81bb('0x2a')]);if(_0x265906[_0x81bb('0x2b')]){delete _0x265906[_0x81bb('0x2b')];}_0x4a33cf[_0x81bb('0x1b')](_0x1f295e)[_0x81bb('0x2c')](_0x265906);};}exports[_0x81bb('0x2d')]=function(_0x1e9383,_0xae967b){var _0x1d2b02={},_0x23815b={},_0xc99f={'count':0x0,'rows':[]};var _0x4f9678=_['map'](db['VtigerAccount'][_0x81bb('0x2e')],function(_0x24ab34){return{'name':_0x24ab34[_0x81bb('0x2f')],'type':_0x24ab34['type']['key']};});_0x23815b[_0x81bb('0x30')]=_[_0x81bb('0x31')](_0x4f9678,_0x81bb('0x2b'));_0x23815b[_0x81bb('0x32')]=_[_0x81bb('0x33')](_0x1e9383[_0x81bb('0x32')]);_0x23815b[_0x81bb('0x34')]=_[_0x81bb('0x35')](_0x23815b['model'],_0x23815b[_0x81bb('0x32')]);_0x1d2b02['attributes']=_[_0x81bb('0x35')](_0x23815b[_0x81bb('0x30')],qs[_0x81bb('0x36')](_0x1e9383[_0x81bb('0x32')]['fields']));_0x1d2b02[_0x81bb('0x37')]=_0x1d2b02[_0x81bb('0x37')]['length']?_0x1d2b02[_0x81bb('0x37')]:_0x23815b[_0x81bb('0x30')];if(!_0x1e9383[_0x81bb('0x32')][_0x81bb('0x38')](_0x81bb('0x39'))){_0x1d2b02[_0x81bb('0x1e')]=qs[_0x81bb('0x1e')](_0x1e9383[_0x81bb('0x32')]['limit']);_0x1d2b02[_0x81bb('0x1f')]=qs[_0x81bb('0x1f')](_0x1e9383[_0x81bb('0x32')][_0x81bb('0x1f')]);}_0x1d2b02[_0x81bb('0x3a')]=qs['sort'](_0x1e9383['query'][_0x81bb('0x3b')]);_0x1d2b02[_0x81bb('0x3c')]=qs[_0x81bb('0x34')](_[_0x81bb('0x3d')](_0x1e9383[_0x81bb('0x32')],_0x23815b[_0x81bb('0x34')]),_0x4f9678);if(_0x1e9383[_0x81bb('0x32')][_0x81bb('0x3e')]){_0x1d2b02[_0x81bb('0x3c')]=_[_0x81bb('0x3f')](_0x1d2b02[_0x81bb('0x3c')],{'$or':_[_0x81bb('0x31')](_0x4f9678,function(_0x4a434e){if(_0x4a434e[_0x81bb('0x40')]!==_0x81bb('0x41')){var _0x474071={};_0x474071[_0x4a434e[_0x81bb('0x2b')]]={'$like':'%'+_0x1e9383[_0x81bb('0x32')][_0x81bb('0x3e')]+'%'};return _0x474071;}})});}_0x1d2b02=_[_0x81bb('0x3f')]({},_0x1d2b02,_0x1e9383[_0x81bb('0x42')]);var _0x383c80={'where':_0x1d2b02[_0x81bb('0x3c')]};return db[_0x81bb('0x43')]['count'](_0x383c80)[_0x81bb('0x44')](function(_0x53e8f9){_0xc99f[_0x81bb('0x20')]=_0x53e8f9;if(_0x1e9383[_0x81bb('0x32')][_0x81bb('0x45')]){_0x1d2b02[_0x81bb('0x46')]=[{'all':!![]}];}return db['VtigerAccount']['findAll'](_0x1d2b02);})['then'](function(_0x3ae72d){_0xc99f[_0x81bb('0x47')]=_0x3ae72d;return _0xc99f;})[_0x81bb('0x44')](respondWithFilteredResult(_0xae967b,_0x1d2b02))[_0x81bb('0x48')](handleError(_0xae967b,null));};exports[_0x81bb('0x49')]=function(_0x2ef8ff,_0x21e80c){var _0x359a28={'raw':![],'where':{'id':_0x2ef8ff[_0x81bb('0x4a')]['id']}},_0x57b3e2={};_0x57b3e2[_0x81bb('0x30')]=_['keys'](db[_0x81bb('0x43')][_0x81bb('0x2e')]);_0x57b3e2[_0x81bb('0x32')]=_['keys'](_0x2ef8ff['query']);_0x57b3e2[_0x81bb('0x34')]=_[_0x81bb('0x35')](_0x57b3e2[_0x81bb('0x30')],_0x57b3e2['query']);_0x359a28[_0x81bb('0x37')]=_[_0x81bb('0x35')](_0x57b3e2[_0x81bb('0x30')],qs[_0x81bb('0x36')](_0x2ef8ff[_0x81bb('0x32')][_0x81bb('0x36')]));_0x359a28[_0x81bb('0x37')]=_0x359a28['attributes'][_0x81bb('0x4b')]?_0x359a28[_0x81bb('0x37')]:_0x57b3e2[_0x81bb('0x30')];if(_0x2ef8ff[_0x81bb('0x32')][_0x81bb('0x45')]){_0x359a28['include']=[{'all':!![]}];}_0x359a28=_['merge']({},_0x359a28,_0x2ef8ff[_0x81bb('0x42')]);return db[_0x81bb('0x43')][_0x81bb('0x4c')](_0x359a28)[_0x81bb('0x44')](handleEntityNotFound(_0x21e80c,null))[_0x81bb('0x44')](respondWithResult(_0x21e80c,null))['catch'](handleError(_0x21e80c,null));};exports['create']=function(_0x52fbd1,_0x4bc5e1){return db['VtigerAccount']['create'](_0x52fbd1[_0x81bb('0x4d')],{})[_0x81bb('0x44')](respondWithResult(_0x4bc5e1,0xc9))[_0x81bb('0x48')](handleError(_0x4bc5e1,null));};exports[_0x81bb('0x27')]=function(_0x432472,_0x50d5a8){if(_0x432472[_0x81bb('0x4d')]['id']){delete _0x432472[_0x81bb('0x4d')]['id'];}return db[_0x81bb('0x43')][_0x81bb('0x4c')]({'where':{'id':_0x432472[_0x81bb('0x4a')]['id']}})[_0x81bb('0x44')](handleEntityNotFound(_0x50d5a8,null))[_0x81bb('0x44')](saveUpdates(_0x432472[_0x81bb('0x4d')],null))[_0x81bb('0x44')](respondWithResult(_0x50d5a8,null))[_0x81bb('0x48')](handleError(_0x50d5a8,null));};exports[_0x81bb('0x28')]=function(_0x55581d,_0xd757d1){return db[_0x81bb('0x43')][_0x81bb('0x4c')]({'where':{'id':_0x55581d[_0x81bb('0x4a')]['id']}})[_0x81bb('0x44')](handleEntityNotFound(_0xd757d1,null))[_0x81bb('0x44')](removeEntity(_0xd757d1,null))['catch'](handleError(_0xd757d1,null));};exports[_0x81bb('0x4e')]=function(_0x578c18,_0x2a2cd6,_0x2763b3){var _0x5aa739={};var _0x327e4c={};var _0x19e083;var _0x5d897a;return db[_0x81bb('0x43')][_0x81bb('0x4f')]({'where':{'id':_0x578c18[_0x81bb('0x4a')]['id']}})[_0x81bb('0x44')](handleEntityNotFound(_0x2a2cd6,null))['then'](function(_0x12270f){if(_0x12270f){_0x19e083=_0x12270f;_0x327e4c[_0x81bb('0x30')]=_[_0x81bb('0x33')](db['VtigerConfiguration'][_0x81bb('0x2e')]);_0x327e4c['query']=_[_0x81bb('0x33')](_0x578c18[_0x81bb('0x32')]);_0x327e4c[_0x81bb('0x34')]=_[_0x81bb('0x35')](_0x327e4c[_0x81bb('0x30')],_0x327e4c[_0x81bb('0x32')]);_0x5aa739[_0x81bb('0x37')]=_[_0x81bb('0x35')](_0x327e4c[_0x81bb('0x30')],qs['fields'](_0x578c18[_0x81bb('0x32')]['fields']));_0x5aa739[_0x81bb('0x37')]=_0x5aa739[_0x81bb('0x37')][_0x81bb('0x4b')]?_0x5aa739[_0x81bb('0x37')]:_0x327e4c[_0x81bb('0x30')];_0x5aa739[_0x81bb('0x3a')]=qs[_0x81bb('0x3b')](_0x578c18[_0x81bb('0x32')][_0x81bb('0x3b')]);_0x5aa739[_0x81bb('0x3c')]=qs[_0x81bb('0x34')](_[_0x81bb('0x3d')](_0x578c18[_0x81bb('0x32')],_0x327e4c['filters']));if(_0x578c18[_0x81bb('0x32')][_0x81bb('0x3e')]){_0x5aa739['where']=_[_0x81bb('0x3f')](_0x5aa739[_0x81bb('0x3c')],{'$or':_['map'](_0x5aa739[_0x81bb('0x37')],function(_0x1a73bd){var _0x2870b7={};_0x2870b7[_0x1a73bd]={'$like':'%'+_0x578c18['query'][_0x81bb('0x3e')]+'%'};return _0x2870b7;})});}_0x5aa739=_[_0x81bb('0x3f')]({},_0x5aa739,_0x578c18[_0x81bb('0x42')]);return _0x19e083[_0x81bb('0x4e')](_0x5aa739);}})['then'](function(_0x480ba8){if(_0x480ba8){_0x5d897a=_0x480ba8[_0x81bb('0x4b')];if(!_0x578c18[_0x81bb('0x32')][_0x81bb('0x38')](_0x81bb('0x39'))){_0x5aa739[_0x81bb('0x1e')]=qs[_0x81bb('0x1e')](_0x578c18[_0x81bb('0x32')][_0x81bb('0x1e')]);_0x5aa739[_0x81bb('0x1f')]=qs[_0x81bb('0x1f')](_0x578c18[_0x81bb('0x32')][_0x81bb('0x1f')]);}return _0x19e083['getConfigurations'](_0x5aa739);}})['then'](function(_0x3c51b3){if(_0x3c51b3){return _0x3c51b3?{'count':_0x5d897a,'rows':_0x3c51b3}:null;}})[_0x81bb('0x44')](respondWithResult(_0x2a2cd6,null))['catch'](handleError(_0x2a2cd6,null));};exports['addConfiguration']=function(_0x130ffd,_0x37bcd8,_0x257ba3){if(_0x130ffd[_0x81bb('0x4d')]['id']){delete _0x130ffd[_0x81bb('0x4d')]['id'];}return db['VtigerAccount'][_0x81bb('0x4f')]({'where':{'id':_0x130ffd[_0x81bb('0x4a')]['id']}})['then'](handleEntityNotFound(_0x37bcd8,null))['then'](function(_0x4314f2){if(_0x4314f2){_0x130ffd[_0x81bb('0x4d')][_0x81bb('0x50')]=_0x4314f2['id'];_0x130ffd['body']['Subjects']=integrations[_0x81bb('0x51')](_0x130ffd['body'][_0x81bb('0x52')],_0x130ffd['body'][_0x81bb('0x40')]);_0x130ffd[_0x81bb('0x4d')]['Descriptions']=integrations['getDescriptions'](_0x130ffd[_0x81bb('0x4d')][_0x81bb('0x52')],_0x130ffd['body'][_0x81bb('0x40')]);return db[_0x81bb('0x53')][_0x81bb('0x54')](_0x130ffd['body'],{'include':[{'model':db[_0x81bb('0x55')],'as':_0x81bb('0x56')},{'model':db['VtigerField'],'as':'Descriptions'}]});}return null;})[_0x81bb('0x44')](respondWithResult(_0x37bcd8,null))[_0x81bb('0x48')](handleError(_0x37bcd8,null));};var md5=require(_0x81bb('0x57'));exports[_0x81bb('0x58')]=function(_0x5eac0e,_0x235218,_0x5bf366){var _0x5db02c=null;var _0x25626c=null;var _0x22e001=null;var _0x14e1c6=null;var _0x1548c2='';return db[_0x81bb('0x43')][_0x81bb('0x4f')]({'where':{'id':_0x5eac0e[_0x81bb('0x4a')]['id']},'attributes':['id',_0x81bb('0x2b'),_0x81bb('0x59'),'description','moduleName',_0x81bb('0x5a'),_0x81bb('0x5b'),_0x81bb('0x5c')]})[_0x81bb('0x44')](handleEntityNotFound(_0x235218,null))[_0x81bb('0x44')](function(_0x2f1e0b){if(_0x2f1e0b){_0x5db02c=_0x2f1e0b['username'];_0x25626c=_0x2f1e0b[_0x81bb('0x5c')];_0x22e001=_0x2f1e0b[_0x81bb('0x5d')];_0x1548c2=_0x2f1e0b[_0x81bb('0x5a')];var _0x4e6d11=_0x1548c2[_0x81bb('0x5e')](-0x1);if(_0x4e6d11==='/'){_0x1548c2=_0x1548c2['substring'](0x0,_0x1548c2[_0x81bb('0x5f')](_0x4e6d11));}_0x14e1c6=util[_0x81bb('0x60')](_0x81bb('0x61'),_0x1548c2);var _0x596994={'method':_0x81bb('0x62'),'uri':_0x14e1c6,'qs':{'operation':'getchallenge','username':_0x2f1e0b[_0x81bb('0x59')]},'json':!![]};return rp(_0x596994);}})['then'](function(_0x365d22){if(_0x365d22[_0x81bb('0x63')]){var _0x7378e={'method':_0x81bb('0x64'),'uri':_0x14e1c6,'form':{'operation':_0x81bb('0x65'),'username':_0x5db02c,'accessKey':md5(_0x365d22[_0x81bb('0x66')][_0x81bb('0x67')]+_0x25626c)},'json':!![]};return rp(_0x7378e);}})[_0x81bb('0x44')](function(_0x52bfe5){if(_0x52bfe5[_0x81bb('0x63')]){var _0x980972={'method':_0x81bb('0x62'),'uri':_0x14e1c6,'qs':{'operation':_0x81bb('0x68'),'username':_0x5db02c,'sessionName':_0x52bfe5[_0x81bb('0x66')][_0x81bb('0x69')],'elementType':_0x22e001},'json':!![]};return rp(_0x980972);}})['then'](function(_0x1e147d){if(_0x1e147d['success']){var _0x3125b1=[_0x81bb('0x6a'),_0x81bb('0x6b'),'owner'];_[_0x81bb('0x6c')](_0x1e147d[_0x81bb('0x66')][_0x81bb('0x36')],function(_0x26defb){return _0x3125b1[_0x81bb('0x6d')](_0x26defb[_0x81bb('0x40')][_0x81bb('0x2b')]);});_[_0x81bb('0x6c')](_0x1e147d[_0x81bb('0x66')][_0x81bb('0x36')],function(_0x3c060d){return _0x3c060d[_0x81bb('0x6e')]===_0x81bb('0x6f');});return{'count':_0x1e147d[_0x81bb('0x66')][_0x81bb('0x36')][_0x81bb('0x4b')],'rows':_[_0x81bb('0x31')](_0x1e147d[_0x81bb('0x66')][_0x81bb('0x36')],function(_0x49c330){return{'id':_0x49c330[_0x81bb('0x2b')],'name':_0x49c330[_0x81bb('0x70')],'custom':_[_0x81bb('0x71')](_0x49c330['name'],'cf_')?!![]:![],'options':_0x49c330[_0x81bb('0x40')][_0x81bb('0x2b')]===_0x81bb('0x72')&&_0x49c330['type'][_0x81bb('0x73')][_0x81bb('0x4b')]>0x0?_[_0x81bb('0x31')](_0x49c330[_0x81bb('0x40')]['picklistValues'],function(_0x24ace8){return{'name':_0x24ace8[_0x81bb('0x70')],'value':_0x24ace8[_0x81bb('0x74')]};}):[]};})};}})[_0x81bb('0x44')](respondWithResult(_0x235218,null))[_0x81bb('0x48')](function(_0x55e48a){console[_0x81bb('0x75')](_0x81bb('0x76')+_0x55e48a);var _0x55b35a=_0x5eac0e[_0x81bb('0x32')]['test']?0x1f4:_0x55e48a[_0x81bb('0x77')]||0x1f4;logger['error']('getFields,\x20%s,\x20%s,\x20%s',_0x81bb('0x58'),_0x55b35a,JSON[_0x81bb('0x78')](_0x55e48a));delete _0x55e48a[_0x81bb('0x2b')];if(_0x55b35a===0x191){_0x55b35a=0x190;}_0x235218['status'](_0x55b35a)[_0x81bb('0x2c')](_0x5eac0e[_0x81bb('0x32')][_0x81bb('0x79')]?{'message':'Wrong\x20credentials','statusCode':_0x55e48a[_0x81bb('0x77')]}:_0x55e48a);});};