284f93dcdc9e3d6de3a4f6cca8c9e1caadd278f4
[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 _0x72f4=['where','pick','merge','type','VIRTUAL','filter','options','VtigerAccount','includeAll','include','findAll','rows','catch','show','params','create','body','update','find','VtigerConfiguration','getConfigurations','hasOwnProperty','addConfiguration','findOne','AccountId','Subjects','getSubjects','Descriptions','channel','VtigerField','md5','getFields','username','moduleName','remoteUri','serverUrl','accessKey','slice','substring','lastIndexOf','format','GET','success','POST','result','token','describe','autogenerated','reference','owner','includes','remove','editable','label','picklist','picklistValues','value','log','vTiger\x20error:\x20','test','statusCode','error','getFields,\x20%s,\x20%s,\x20%s','stringify','eml-format','zip-dir','request-promise','util','ejs','fs-extra','lodash','crypto','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','../../components/integrations/configuration','status','json','offset','undefined','count','limit','apply','reject','save','then','destroy','end','sendStatus','stack','name','send','index','rawAttributes','fieldName','key','model','map','query','keys','filters','intersection','fields','attributes','length','nolimit','sort'];(function(_0x59ee6f,_0x450239){var _0x4c0979=function(_0x565e92){while(--_0x565e92){_0x59ee6f['push'](_0x59ee6f['shift']());}};_0x4c0979(++_0x450239);}(_0x72f4,0x12e));var _0x472f=function(_0x2378d4,_0x34fd07){_0x2378d4=_0x2378d4-0x0;var _0x106acc=_0x72f4[_0x2378d4];return _0x106acc;};'use strict';var emlformat=require(_0x472f('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x472f('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0x472f('0x2'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x472f('0x3'));var path=require('path');var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x472f('0x4'));var fs=require('fs');var fs_extra=require(_0x472f('0x5'));var _=require(_0x472f('0x6'));var squel=require('squel');var crypto=require(_0x472f('0x7'));var jsforce=require(_0x472f('0x8'));var deskjs=require(_0x472f('0x9'));var toCsv=require(_0x472f('0xa'));var querystring=require(_0x472f('0xb'));var Papa=require(_0x472f('0xc'));var Redis=require(_0x472f('0xd'));var authService=require(_0x472f('0xe'));var qs=require(_0x472f('0xf'));var as=require(_0x472f('0x10'));var hardwareService=require(_0x472f('0x11'));var logger=require('../../config/logger')(_0x472f('0x12'));var utils=require(_0x472f('0x13'));var config=require(_0x472f('0x14'));var licenseUtil=require(_0x472f('0x15'));var db=require(_0x472f('0x16'))['db'];var integrations=require(_0x472f('0x17'));function respondWithStatusCode(_0x81be33,_0xd6899f){_0xd6899f=_0xd6899f||0xcc;return function(_0x3807a7){if(_0x3807a7){return _0x81be33['sendStatus'](_0xd6899f);}return _0x81be33[_0x472f('0x18')](_0xd6899f)['end']();};}function respondWithResult(_0x2dfeca,_0x340544){_0x340544=_0x340544||0xc8;return function(_0x6cd0d1){if(_0x6cd0d1){return _0x2dfeca[_0x472f('0x18')](_0x340544)[_0x472f('0x19')](_0x6cd0d1);}};}function respondWithFilteredResult(_0x1bc4b7,_0xf5b27e){return function(_0x3e3675){if(_0x3e3675){var _0x3896a1=typeof _0xf5b27e[_0x472f('0x1a')]===_0x472f('0x1b')&&typeof _0xf5b27e['limit']===_0x472f('0x1b');var _0x449a27=_0x3e3675['count'];var _0x4b58e=_0x3896a1?0x0:_0xf5b27e[_0x472f('0x1a')];var _0x2e561e=_0x3896a1?_0x3e3675[_0x472f('0x1c')]:_0xf5b27e[_0x472f('0x1a')]+_0xf5b27e[_0x472f('0x1d')];var _0x3f3bc2;if(_0x2e561e>=_0x449a27){_0x2e561e=_0x449a27;_0x3f3bc2=0xc8;}else{_0x3f3bc2=0xce;}_0x1bc4b7['status'](_0x3f3bc2);return _0x1bc4b7['set']('Content-Range',_0x4b58e+'-'+_0x2e561e+'/'+_0x449a27)[_0x472f('0x19')](_0x3e3675);}return null;};}function patchUpdates(_0x507600){return function(_0x5d6afa){try{jsonpatch[_0x472f('0x1e')](_0x5d6afa,_0x507600,!![]);}catch(_0x4e7852){return BPromise[_0x472f('0x1f')](_0x4e7852);}return _0x5d6afa[_0x472f('0x20')]();};}function saveUpdates(_0x2ff3c6,_0x100e44){return function(_0x1e0c17){if(_0x1e0c17){return _0x1e0c17['update'](_0x2ff3c6)[_0x472f('0x21')](function(_0x37116e){return _0x37116e;});}return null;};}function removeEntity(_0x3817e2,_0x5782e5){return function(_0x514fca){if(_0x514fca){return _0x514fca[_0x472f('0x22')]()[_0x472f('0x21')](function(){_0x3817e2[_0x472f('0x18')](0xcc)[_0x472f('0x23')]();});}};}function handleEntityNotFound(_0x544739,_0x23f24a){return function(_0x39d989){if(!_0x39d989){_0x544739[_0x472f('0x24')](0x194);}return _0x39d989;};}function handleError(_0x154f26,_0x59ee03){_0x59ee03=_0x59ee03||0x1f4;return function(_0x2ee243){logger['error'](_0x2ee243[_0x472f('0x25')]);if(_0x2ee243[_0x472f('0x26')]){delete _0x2ee243[_0x472f('0x26')];}_0x154f26['status'](_0x59ee03)[_0x472f('0x27')](_0x2ee243);};}exports[_0x472f('0x28')]=function(_0x454f51,_0x3f6be0){var _0x61e397={},_0x3d959a={},_0x5b8afe={'count':0x0,'rows':[]};var _0x5490c8=_['map'](db['VtigerAccount'][_0x472f('0x29')],function(_0x51de59){return{'name':_0x51de59[_0x472f('0x2a')],'type':_0x51de59['type'][_0x472f('0x2b')]};});_0x3d959a[_0x472f('0x2c')]=_[_0x472f('0x2d')](_0x5490c8,_0x472f('0x26'));_0x3d959a[_0x472f('0x2e')]=_[_0x472f('0x2f')](_0x454f51[_0x472f('0x2e')]);_0x3d959a[_0x472f('0x30')]=_[_0x472f('0x31')](_0x3d959a[_0x472f('0x2c')],_0x3d959a[_0x472f('0x2e')]);_0x61e397['attributes']=_[_0x472f('0x31')](_0x3d959a['model'],qs[_0x472f('0x32')](_0x454f51['query'][_0x472f('0x32')]));_0x61e397[_0x472f('0x33')]=_0x61e397[_0x472f('0x33')][_0x472f('0x34')]?_0x61e397['attributes']:_0x3d959a[_0x472f('0x2c')];if(!_0x454f51[_0x472f('0x2e')]['hasOwnProperty'](_0x472f('0x35'))){_0x61e397[_0x472f('0x1d')]=qs[_0x472f('0x1d')](_0x454f51[_0x472f('0x2e')][_0x472f('0x1d')]);_0x61e397['offset']=qs[_0x472f('0x1a')](_0x454f51['query'][_0x472f('0x1a')]);}_0x61e397['order']=qs['sort'](_0x454f51[_0x472f('0x2e')][_0x472f('0x36')]);_0x61e397[_0x472f('0x37')]=qs['filters'](_[_0x472f('0x38')](_0x454f51['query'],_0x3d959a[_0x472f('0x30')]),_0x5490c8);if(_0x454f51[_0x472f('0x2e')]['filter']){_0x61e397[_0x472f('0x37')]=_[_0x472f('0x39')](_0x61e397['where'],{'$or':_[_0x472f('0x2d')](_0x5490c8,function(_0x1dc242){if(_0x1dc242[_0x472f('0x3a')]!==_0x472f('0x3b')){var _0x5417d0={};_0x5417d0[_0x1dc242['name']]={'$like':'%'+_0x454f51[_0x472f('0x2e')][_0x472f('0x3c')]+'%'};return _0x5417d0;}})});}_0x61e397=_[_0x472f('0x39')]({},_0x61e397,_0x454f51[_0x472f('0x3d')]);var _0x4b4a1b={'where':_0x61e397[_0x472f('0x37')]};return db[_0x472f('0x3e')]['count'](_0x4b4a1b)[_0x472f('0x21')](function(_0x2b367f){_0x5b8afe['count']=_0x2b367f;if(_0x454f51[_0x472f('0x2e')][_0x472f('0x3f')]){_0x61e397[_0x472f('0x40')]=[{'all':!![]}];}return db[_0x472f('0x3e')][_0x472f('0x41')](_0x61e397);})[_0x472f('0x21')](function(_0x31cba9){_0x5b8afe[_0x472f('0x42')]=_0x31cba9;return _0x5b8afe;})['then'](respondWithFilteredResult(_0x3f6be0,_0x61e397))[_0x472f('0x43')](handleError(_0x3f6be0,null));};exports[_0x472f('0x44')]=function(_0xe13d96,_0x5c5adf){var _0x32726a={'raw':![],'where':{'id':_0xe13d96[_0x472f('0x45')]['id']}},_0x2dc555={};_0x2dc555[_0x472f('0x2c')]=_[_0x472f('0x2f')](db[_0x472f('0x3e')][_0x472f('0x29')]);_0x2dc555[_0x472f('0x2e')]=_[_0x472f('0x2f')](_0xe13d96['query']);_0x2dc555[_0x472f('0x30')]=_[_0x472f('0x31')](_0x2dc555['model'],_0x2dc555['query']);_0x32726a['attributes']=_[_0x472f('0x31')](_0x2dc555[_0x472f('0x2c')],qs['fields'](_0xe13d96[_0x472f('0x2e')]['fields']));_0x32726a[_0x472f('0x33')]=_0x32726a[_0x472f('0x33')][_0x472f('0x34')]?_0x32726a[_0x472f('0x33')]:_0x2dc555[_0x472f('0x2c')];if(_0xe13d96[_0x472f('0x2e')][_0x472f('0x3f')]){_0x32726a[_0x472f('0x40')]=[{'all':!![]}];}_0x32726a=_['merge']({},_0x32726a,_0xe13d96[_0x472f('0x3d')]);return db[_0x472f('0x3e')]['find'](_0x32726a)[_0x472f('0x21')](handleEntityNotFound(_0x5c5adf,null))['then'](respondWithResult(_0x5c5adf,null))[_0x472f('0x43')](handleError(_0x5c5adf,null));};exports[_0x472f('0x46')]=function(_0x5ed0de,_0x4e4a1a){return db[_0x472f('0x3e')][_0x472f('0x46')](_0x5ed0de[_0x472f('0x47')],{})['then'](respondWithResult(_0x4e4a1a,0xc9))[_0x472f('0x43')](handleError(_0x4e4a1a,null));};exports[_0x472f('0x48')]=function(_0x2f0b22,_0x3878ef){if(_0x2f0b22[_0x472f('0x47')]['id']){delete _0x2f0b22[_0x472f('0x47')]['id'];}return db[_0x472f('0x3e')][_0x472f('0x49')]({'where':{'id':_0x2f0b22[_0x472f('0x45')]['id']}})[_0x472f('0x21')](handleEntityNotFound(_0x3878ef,null))['then'](saveUpdates(_0x2f0b22[_0x472f('0x47')],null))[_0x472f('0x21')](respondWithResult(_0x3878ef,null))['catch'](handleError(_0x3878ef,null));};exports[_0x472f('0x22')]=function(_0x146acb,_0x4fc5b9){return db[_0x472f('0x3e')][_0x472f('0x49')]({'where':{'id':_0x146acb[_0x472f('0x45')]['id']}})[_0x472f('0x21')](handleEntityNotFound(_0x4fc5b9,null))[_0x472f('0x21')](removeEntity(_0x4fc5b9,null))[_0x472f('0x43')](handleError(_0x4fc5b9,null));};exports['getConfigurations']=function(_0x2f8647,_0x41fa47,_0x24cd71){var _0x4b186d={};var _0x1bafd7={};var _0x195039;var _0x619530;return db[_0x472f('0x3e')]['findOne']({'where':{'id':_0x2f8647[_0x472f('0x45')]['id']}})['then'](handleEntityNotFound(_0x41fa47,null))[_0x472f('0x21')](function(_0x1d39b6){if(_0x1d39b6){_0x195039=_0x1d39b6;_0x1bafd7[_0x472f('0x2c')]=_['keys'](db[_0x472f('0x4a')][_0x472f('0x29')]);_0x1bafd7[_0x472f('0x2e')]=_[_0x472f('0x2f')](_0x2f8647[_0x472f('0x2e')]);_0x1bafd7[_0x472f('0x30')]=_[_0x472f('0x31')](_0x1bafd7[_0x472f('0x2c')],_0x1bafd7[_0x472f('0x2e')]);_0x4b186d[_0x472f('0x33')]=_[_0x472f('0x31')](_0x1bafd7['model'],qs['fields'](_0x2f8647[_0x472f('0x2e')][_0x472f('0x32')]));_0x4b186d['attributes']=_0x4b186d[_0x472f('0x33')]['length']?_0x4b186d[_0x472f('0x33')]:_0x1bafd7['model'];_0x4b186d['order']=qs['sort'](_0x2f8647[_0x472f('0x2e')][_0x472f('0x36')]);_0x4b186d['where']=qs['filters'](_['pick'](_0x2f8647[_0x472f('0x2e')],_0x1bafd7['filters']));if(_0x2f8647[_0x472f('0x2e')][_0x472f('0x3c')]){_0x4b186d[_0x472f('0x37')]=_[_0x472f('0x39')](_0x4b186d[_0x472f('0x37')],{'$or':_[_0x472f('0x2d')](_0x4b186d[_0x472f('0x33')],function(_0x34e341){var _0x589c27={};_0x589c27[_0x34e341]={'$like':'%'+_0x2f8647[_0x472f('0x2e')][_0x472f('0x3c')]+'%'};return _0x589c27;})});}_0x4b186d=_['merge']({},_0x4b186d,_0x2f8647[_0x472f('0x3d')]);return _0x195039[_0x472f('0x4b')](_0x4b186d);}})[_0x472f('0x21')](function(_0xd0dd7a){if(_0xd0dd7a){_0x619530=_0xd0dd7a[_0x472f('0x34')];if(!_0x2f8647[_0x472f('0x2e')][_0x472f('0x4c')](_0x472f('0x35'))){_0x4b186d[_0x472f('0x1d')]=qs[_0x472f('0x1d')](_0x2f8647[_0x472f('0x2e')][_0x472f('0x1d')]);_0x4b186d[_0x472f('0x1a')]=qs[_0x472f('0x1a')](_0x2f8647['query'][_0x472f('0x1a')]);}return _0x195039['getConfigurations'](_0x4b186d);}})[_0x472f('0x21')](function(_0xdf98dd){if(_0xdf98dd){return _0xdf98dd?{'count':_0x619530,'rows':_0xdf98dd}:null;}})['then'](respondWithResult(_0x41fa47,null))[_0x472f('0x43')](handleError(_0x41fa47,null));};exports[_0x472f('0x4d')]=function(_0x29cd74,_0x383ba7,_0x16990f){if(_0x29cd74['body']['id']){delete _0x29cd74[_0x472f('0x47')]['id'];}return db['VtigerAccount'][_0x472f('0x4e')]({'where':{'id':_0x29cd74['params']['id']}})[_0x472f('0x21')](handleEntityNotFound(_0x383ba7,null))['then'](function(_0x43390b){if(_0x43390b){_0x29cd74[_0x472f('0x47')][_0x472f('0x4f')]=_0x43390b['id'];_0x29cd74[_0x472f('0x47')][_0x472f('0x50')]=integrations[_0x472f('0x51')](_0x29cd74[_0x472f('0x47')]['channel'],_0x29cd74[_0x472f('0x47')][_0x472f('0x3a')]);_0x29cd74[_0x472f('0x47')][_0x472f('0x52')]=integrations['getDescriptions'](_0x29cd74['body'][_0x472f('0x53')],_0x29cd74[_0x472f('0x47')]['type']);return db[_0x472f('0x4a')][_0x472f('0x46')](_0x29cd74[_0x472f('0x47')],{'include':[{'model':db[_0x472f('0x54')],'as':_0x472f('0x50')},{'model':db[_0x472f('0x54')],'as':'Descriptions'}]});}return null;})['then'](respondWithResult(_0x383ba7,null))[_0x472f('0x43')](handleError(_0x383ba7,null));};var md5=require(_0x472f('0x55'));exports[_0x472f('0x56')]=function(_0x4e88be,_0x51c387,_0x1e05a8){var _0x10a368=null;var _0x37a096=null;var _0x513756=null;var _0x3dfbb6=null;var _0x423979='';return db[_0x472f('0x3e')][_0x472f('0x4e')]({'where':{'id':_0x4e88be[_0x472f('0x45')]['id']},'attributes':['id',_0x472f('0x26'),_0x472f('0x57'),'description',_0x472f('0x58'),_0x472f('0x59'),_0x472f('0x5a'),'accessKey']})[_0x472f('0x21')](handleEntityNotFound(_0x51c387,null))[_0x472f('0x21')](function(_0x1e0785){if(_0x1e0785){_0x10a368=_0x1e0785[_0x472f('0x57')];_0x37a096=_0x1e0785[_0x472f('0x5b')];_0x513756=_0x1e0785[_0x472f('0x58')];_0x423979=_0x1e0785[_0x472f('0x59')];var _0x2af772=_0x423979[_0x472f('0x5c')](-0x1);if(_0x2af772==='/'){_0x423979=_0x423979[_0x472f('0x5d')](0x0,_0x423979[_0x472f('0x5e')](_0x2af772));}_0x3dfbb6=util[_0x472f('0x5f')]('%s/webservice.php',_0x423979);var _0x1d155c={'method':_0x472f('0x60'),'uri':_0x3dfbb6,'qs':{'operation':'getchallenge','username':_0x1e0785['username']},'json':!![]};return rp(_0x1d155c);}})[_0x472f('0x21')](function(_0x38847c){if(_0x38847c[_0x472f('0x61')]){var _0x47293f={'method':_0x472f('0x62'),'uri':_0x3dfbb6,'form':{'operation':'login','username':_0x10a368,'accessKey':md5(_0x38847c[_0x472f('0x63')][_0x472f('0x64')]+_0x37a096)},'json':!![]};return rp(_0x47293f);}})[_0x472f('0x21')](function(_0x3a4a5f){if(_0x3a4a5f[_0x472f('0x61')]){var _0xe77d02={'method':_0x472f('0x60'),'uri':_0x3dfbb6,'qs':{'operation':_0x472f('0x65'),'username':_0x10a368,'sessionName':_0x3a4a5f[_0x472f('0x63')]['sessionName'],'elementType':_0x513756},'json':!![]};return rp(_0xe77d02);}})[_0x472f('0x21')](function(_0x468f3f){if(_0x468f3f['success']){var _0x5cd993=[_0x472f('0x66'),_0x472f('0x67'),_0x472f('0x68')];_['remove'](_0x468f3f[_0x472f('0x63')][_0x472f('0x32')],function(_0x489f0b){return _0x5cd993[_0x472f('0x69')](_0x489f0b[_0x472f('0x3a')][_0x472f('0x26')]);});_[_0x472f('0x6a')](_0x468f3f[_0x472f('0x63')][_0x472f('0x32')],function(_0x41beaa){return _0x41beaa[_0x472f('0x6b')]==='false';});return{'count':_0x468f3f[_0x472f('0x63')][_0x472f('0x32')]['length'],'rows':_['map'](_0x468f3f['result'][_0x472f('0x32')],function(_0x52c2cf){return{'id':_0x52c2cf[_0x472f('0x26')],'name':_0x52c2cf[_0x472f('0x6c')],'custom':_['startsWith'](_0x52c2cf[_0x472f('0x26')],'cf_')?!![]:![],'options':_0x52c2cf['type'][_0x472f('0x26')]===_0x472f('0x6d')&&_0x52c2cf['type'][_0x472f('0x6e')]['length']>0x0?_[_0x472f('0x2d')](_0x52c2cf[_0x472f('0x3a')]['picklistValues'],function(_0x1b1a57){return{'name':_0x1b1a57[_0x472f('0x6c')],'value':_0x1b1a57[_0x472f('0x6f')]};}):[]};})};}})[_0x472f('0x21')](respondWithResult(_0x51c387,null))[_0x472f('0x43')](function(_0x243df8){console[_0x472f('0x70')](_0x472f('0x71')+_0x243df8);var _0x59b2d5=_0x4e88be[_0x472f('0x2e')][_0x472f('0x72')]?0x1f4:_0x243df8[_0x472f('0x73')]||0x1f4;logger[_0x472f('0x74')](_0x472f('0x75'),_0x472f('0x56'),_0x59b2d5,JSON[_0x472f('0x76')](_0x243df8));delete _0x243df8[_0x472f('0x26')];if(_0x59b2d5===0x191){_0x59b2d5=0x190;}_0x51c387[_0x472f('0x18')](_0x59b2d5)[_0x472f('0x27')](_0x4e88be[_0x472f('0x2e')][_0x472f('0x72')]?{'message':'Wrong\x20credentials','statusCode':_0x243df8['statusCode']}:_0x243df8);});};