Built motion from commit 753c950e.|2.5.42
[motion2.git] / server / api / intDynamics365Configuration / intDynamics365Configuration.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 _0xf2d9=['status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','destroy','then','error','stack','name','index','map','rawAttributes','key','model','query','keys','filters','intersection','attributes','length','hasOwnProperty','nolimit','order','sort','pick','filter','where','type','VIRTUAL','options','Dynamics365Configuration','includeAll','include','findAll','rows','catch','show','params','fields','merge','body','find','findOne','Dynamics365Field','getFields','getSubjects','getDescriptions','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','to-csv','ejs','fs-extra','lodash','squel','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus'];(function(_0x321bb2,_0x202794){var _0x9c12ed=function(_0x263dd3){while(--_0x263dd3){_0x321bb2['push'](_0x321bb2['shift']());}};_0x9c12ed(++_0x202794);}(_0xf2d9,0x125));var _0x9f2d=function(_0x4a6298,_0x2e53fe){_0x4a6298=_0x4a6298-0x0;var _0x975f6e=_0xf2d9[_0x4a6298];return _0x975f6e;};'use strict';var emlformat=require(_0x9f2d('0x0'));var rimraf=require(_0x9f2d('0x1'));var zipdir=require(_0x9f2d('0x2'));var jsonpatch=require(_0x9f2d('0x3'));var rp=require('request-promise');var moment=require(_0x9f2d('0x4'));var BPromise=require(_0x9f2d('0x5'));var Mustache=require(_0x9f2d('0x6'));var util=require(_0x9f2d('0x7'));var path=require('path');var sox=require('sox');var csv=require(_0x9f2d('0x8'));var ejs=require(_0x9f2d('0x9'));var fs=require('fs');var fs_extra=require(_0x9f2d('0xa'));var _=require(_0x9f2d('0xb'));var squel=require(_0x9f2d('0xc'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x9f2d('0x8'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x9f2d('0xd'));var qs=require(_0x9f2d('0xe'));var as=require(_0x9f2d('0xf'));var hardwareService=require(_0x9f2d('0x10'));var logger=require(_0x9f2d('0x11'))(_0x9f2d('0x12'));var utils=require('../../config/utils');var config=require(_0x9f2d('0x13'));var licenseUtil=require(_0x9f2d('0x14'));var db=require(_0x9f2d('0x15'))['db'];function respondWithStatusCode(_0x5bfe93,_0x481719){_0x481719=_0x481719||0xcc;return function(_0x535709){if(_0x535709){return _0x5bfe93[_0x9f2d('0x16')](_0x481719);}return _0x5bfe93[_0x9f2d('0x17')](_0x481719)[_0x9f2d('0x18')]();};}function respondWithResult(_0x344f91,_0x329b49){_0x329b49=_0x329b49||0xc8;return function(_0x4fef61){if(_0x4fef61){return _0x344f91[_0x9f2d('0x17')](_0x329b49)[_0x9f2d('0x19')](_0x4fef61);}};}function respondWithFilteredResult(_0x5b9f16,_0x2e689d){return function(_0x560e0c){if(_0x560e0c){var _0x434ad6=typeof _0x2e689d[_0x9f2d('0x1a')]===_0x9f2d('0x1b')&&typeof _0x2e689d[_0x9f2d('0x1c')]===_0x9f2d('0x1b');var _0xc5b122=_0x560e0c['count'];var _0x55e908=_0x434ad6?0x0:_0x2e689d[_0x9f2d('0x1a')];var _0x3299be=_0x434ad6?_0x560e0c[_0x9f2d('0x1d')]:_0x2e689d[_0x9f2d('0x1a')]+_0x2e689d['limit'];var _0x1e8a58;if(_0x3299be>=_0xc5b122){_0x3299be=_0xc5b122;_0x1e8a58=0xc8;}else{_0x1e8a58=0xce;}_0x5b9f16[_0x9f2d('0x17')](_0x1e8a58);return _0x5b9f16[_0x9f2d('0x1e')](_0x9f2d('0x1f'),_0x55e908+'-'+_0x3299be+'/'+_0xc5b122)[_0x9f2d('0x19')](_0x560e0c);}return null;};}function patchUpdates(_0xa79578){return function(_0x25af62){try{jsonpatch[_0x9f2d('0x20')](_0x25af62,_0xa79578,!![]);}catch(_0x2e67e0){return BPromise[_0x9f2d('0x21')](_0x2e67e0);}return _0x25af62[_0x9f2d('0x22')]();};}function saveUpdates(_0x3cdc1a,_0xc02faf){return function(_0x1a3ad3){if(_0x1a3ad3){return _0x1a3ad3[_0x9f2d('0x23')](_0x3cdc1a)['then'](function(_0x383f68){return _0x383f68;});}return null;};}function removeEntity(_0x461a97,_0x7e34fe){return function(_0x44329){if(_0x44329){return _0x44329[_0x9f2d('0x24')]()[_0x9f2d('0x25')](function(){_0x461a97['status'](0xcc)[_0x9f2d('0x18')]();});}};}function handleEntityNotFound(_0x66a0a4,_0xa27f09){return function(_0x3b5098){if(!_0x3b5098){_0x66a0a4[_0x9f2d('0x16')](0x194);}return _0x3b5098;};}function handleError(_0x4e2505,_0x585b67){_0x585b67=_0x585b67||0x1f4;return function(_0xda309b){logger[_0x9f2d('0x26')](_0xda309b[_0x9f2d('0x27')]);if(_0xda309b[_0x9f2d('0x28')]){delete _0xda309b[_0x9f2d('0x28')];}_0x4e2505[_0x9f2d('0x17')](_0x585b67)['send'](_0xda309b);};}exports[_0x9f2d('0x29')]=function(_0x1aa075,_0x470e56){var _0x4616b1={},_0x423e72={},_0x4673f5={'count':0x0,'rows':[]};var _0x7ad17a=_[_0x9f2d('0x2a')](db['Dynamics365Configuration'][_0x9f2d('0x2b')],function(_0x424653){return{'name':_0x424653['fieldName'],'type':_0x424653['type'][_0x9f2d('0x2c')]};});_0x423e72[_0x9f2d('0x2d')]=_[_0x9f2d('0x2a')](_0x7ad17a,'name');_0x423e72[_0x9f2d('0x2e')]=_[_0x9f2d('0x2f')](_0x1aa075[_0x9f2d('0x2e')]);_0x423e72[_0x9f2d('0x30')]=_[_0x9f2d('0x31')](_0x423e72[_0x9f2d('0x2d')],_0x423e72[_0x9f2d('0x2e')]);_0x4616b1[_0x9f2d('0x32')]=_[_0x9f2d('0x31')](_0x423e72['model'],qs['fields'](_0x1aa075[_0x9f2d('0x2e')]['fields']));_0x4616b1[_0x9f2d('0x32')]=_0x4616b1[_0x9f2d('0x32')][_0x9f2d('0x33')]?_0x4616b1[_0x9f2d('0x32')]:_0x423e72['model'];if(!_0x1aa075[_0x9f2d('0x2e')][_0x9f2d('0x34')](_0x9f2d('0x35'))){_0x4616b1[_0x9f2d('0x1c')]=qs[_0x9f2d('0x1c')](_0x1aa075['query'][_0x9f2d('0x1c')]);_0x4616b1[_0x9f2d('0x1a')]=qs['offset'](_0x1aa075['query'][_0x9f2d('0x1a')]);}_0x4616b1[_0x9f2d('0x36')]=qs['sort'](_0x1aa075[_0x9f2d('0x2e')][_0x9f2d('0x37')]);_0x4616b1['where']=qs[_0x9f2d('0x30')](_[_0x9f2d('0x38')](_0x1aa075[_0x9f2d('0x2e')],_0x423e72[_0x9f2d('0x30')]),_0x7ad17a);if(_0x1aa075[_0x9f2d('0x2e')][_0x9f2d('0x39')]){_0x4616b1[_0x9f2d('0x3a')]=_['merge'](_0x4616b1[_0x9f2d('0x3a')],{'$or':_['map'](_0x7ad17a,function(_0x5d16aa){if(_0x5d16aa[_0x9f2d('0x3b')]!==_0x9f2d('0x3c')){var _0x52ce88={};_0x52ce88[_0x5d16aa[_0x9f2d('0x28')]]={'$like':'%'+_0x1aa075[_0x9f2d('0x2e')][_0x9f2d('0x39')]+'%'};return _0x52ce88;}})});}_0x4616b1=_['merge']({},_0x4616b1,_0x1aa075[_0x9f2d('0x3d')]);var _0x5a7e9e={'where':_0x4616b1[_0x9f2d('0x3a')]};return db[_0x9f2d('0x3e')][_0x9f2d('0x1d')](_0x5a7e9e)[_0x9f2d('0x25')](function(_0x53c9a3){_0x4673f5[_0x9f2d('0x1d')]=_0x53c9a3;if(_0x1aa075[_0x9f2d('0x2e')][_0x9f2d('0x3f')]){_0x4616b1[_0x9f2d('0x40')]=[{'all':!![]}];}return db[_0x9f2d('0x3e')][_0x9f2d('0x41')](_0x4616b1);})[_0x9f2d('0x25')](function(_0x543175){_0x4673f5[_0x9f2d('0x42')]=_0x543175;return _0x4673f5;})[_0x9f2d('0x25')](respondWithFilteredResult(_0x470e56,_0x4616b1))[_0x9f2d('0x43')](handleError(_0x470e56,null));};exports[_0x9f2d('0x44')]=function(_0x581597,_0x59d63b){var _0x57b3be={'raw':![],'where':{'id':_0x581597[_0x9f2d('0x45')]['id']}},_0x29d611={};_0x29d611['model']=_[_0x9f2d('0x2f')](db[_0x9f2d('0x3e')]['rawAttributes']);_0x29d611[_0x9f2d('0x2e')]=_[_0x9f2d('0x2f')](_0x581597[_0x9f2d('0x2e')]);_0x29d611[_0x9f2d('0x30')]=_[_0x9f2d('0x31')](_0x29d611[_0x9f2d('0x2d')],_0x29d611[_0x9f2d('0x2e')]);_0x57b3be[_0x9f2d('0x32')]=_['intersection'](_0x29d611[_0x9f2d('0x2d')],qs[_0x9f2d('0x46')](_0x581597[_0x9f2d('0x2e')][_0x9f2d('0x46')]));_0x57b3be[_0x9f2d('0x32')]=_0x57b3be[_0x9f2d('0x32')]['length']?_0x57b3be[_0x9f2d('0x32')]:_0x29d611[_0x9f2d('0x2d')];if(_0x581597[_0x9f2d('0x2e')]['includeAll']){_0x57b3be[_0x9f2d('0x40')]=[{'all':!![]}];}_0x57b3be=_[_0x9f2d('0x47')]({},_0x57b3be,_0x581597['options']);return db[_0x9f2d('0x3e')]['find'](_0x57b3be)[_0x9f2d('0x25')](handleEntityNotFound(_0x59d63b,null))[_0x9f2d('0x25')](respondWithResult(_0x59d63b,null))['catch'](handleError(_0x59d63b,null));};exports['create']=function(_0x34358f,_0x574116){return db[_0x9f2d('0x3e')]['create'](_0x34358f[_0x9f2d('0x48')],{})[_0x9f2d('0x25')](respondWithResult(_0x574116,0xc9))['catch'](handleError(_0x574116,null));};exports[_0x9f2d('0x23')]=function(_0x45e726,_0x35e86b){if(_0x45e726[_0x9f2d('0x48')]['id']){delete _0x45e726['body']['id'];}return db[_0x9f2d('0x3e')]['find']({'where':{'id':_0x45e726[_0x9f2d('0x45')]['id']}})[_0x9f2d('0x25')](handleEntityNotFound(_0x35e86b,null))[_0x9f2d('0x25')](saveUpdates(_0x45e726[_0x9f2d('0x48')],null))['then'](respondWithResult(_0x35e86b,null))[_0x9f2d('0x43')](handleError(_0x35e86b,null));};exports[_0x9f2d('0x24')]=function(_0xc2a3c5,_0x1514f6){return db['Dynamics365Configuration'][_0x9f2d('0x49')]({'where':{'id':_0xc2a3c5[_0x9f2d('0x45')]['id']}})[_0x9f2d('0x25')](handleEntityNotFound(_0x1514f6,null))['then'](removeEntity(_0x1514f6,null))[_0x9f2d('0x43')](handleError(_0x1514f6,null));};exports['getFields']=function(_0x204cd3,_0x2cafdc,_0x27feb3){var _0x2c55a3={};var _0x2cf44a={};var _0x1bd7ac;var _0x34997c;return db[_0x9f2d('0x3e')][_0x9f2d('0x4a')]({'where':{'id':_0x204cd3['params']['id']}})[_0x9f2d('0x25')](handleEntityNotFound(_0x2cafdc,null))[_0x9f2d('0x25')](function(_0x53744a){if(_0x53744a){_0x1bd7ac=_0x53744a;_0x2cf44a[_0x9f2d('0x2d')]=_[_0x9f2d('0x2f')](db[_0x9f2d('0x4b')][_0x9f2d('0x2b')]);_0x2cf44a[_0x9f2d('0x2e')]=_['keys'](_0x204cd3[_0x9f2d('0x2e')]);_0x2cf44a[_0x9f2d('0x30')]=_['intersection'](_0x2cf44a['model'],_0x2cf44a[_0x9f2d('0x2e')]);_0x2c55a3[_0x9f2d('0x32')]=_[_0x9f2d('0x31')](_0x2cf44a['model'],qs[_0x9f2d('0x46')](_0x204cd3[_0x9f2d('0x2e')]['fields']));_0x2c55a3[_0x9f2d('0x32')]=_0x2c55a3[_0x9f2d('0x32')][_0x9f2d('0x33')]?_0x2c55a3[_0x9f2d('0x32')]:_0x2cf44a[_0x9f2d('0x2d')];_0x2c55a3[_0x9f2d('0x36')]=qs['sort'](_0x204cd3[_0x9f2d('0x2e')]['sort']);_0x2c55a3['where']=qs[_0x9f2d('0x30')](_[_0x9f2d('0x38')](_0x204cd3[_0x9f2d('0x2e')],_0x2cf44a[_0x9f2d('0x30')]));if(_0x204cd3[_0x9f2d('0x2e')][_0x9f2d('0x39')]){_0x2c55a3[_0x9f2d('0x3a')]=_[_0x9f2d('0x47')](_0x2c55a3[_0x9f2d('0x3a')],{'$or':_['map'](_0x2c55a3[_0x9f2d('0x32')],function(_0x257e66){var _0x20b231={};_0x20b231[_0x257e66]={'$like':'%'+_0x204cd3[_0x9f2d('0x2e')][_0x9f2d('0x39')]+'%'};return _0x20b231;})});}_0x2c55a3=_['merge']({},_0x2c55a3,_0x204cd3['options']);return _0x1bd7ac[_0x9f2d('0x4c')](_0x2c55a3);}})[_0x9f2d('0x25')](function(_0x58b53a){if(_0x58b53a){_0x34997c=_0x58b53a[_0x9f2d('0x33')];if(!_0x204cd3[_0x9f2d('0x2e')][_0x9f2d('0x34')](_0x9f2d('0x35'))){_0x2c55a3[_0x9f2d('0x1c')]=qs[_0x9f2d('0x1c')](_0x204cd3['query'][_0x9f2d('0x1c')]);_0x2c55a3['offset']=qs[_0x9f2d('0x1a')](_0x204cd3[_0x9f2d('0x2e')][_0x9f2d('0x1a')]);}return _0x1bd7ac['getFields'](_0x2c55a3);}})[_0x9f2d('0x25')](function(_0x54d0cc){if(_0x54d0cc){return _0x54d0cc?{'count':_0x34997c,'rows':_0x54d0cc}:null;}})[_0x9f2d('0x25')](respondWithResult(_0x2cafdc,null))[_0x9f2d('0x43')](handleError(_0x2cafdc,null));};exports['getSubjects']=function(_0x2e08ca,_0x130dad,_0x322fc0){var _0x30d7e4={};var _0x394b58={};var _0x1db89c;var _0x508062;return db[_0x9f2d('0x3e')][_0x9f2d('0x4a')]({'where':{'id':_0x2e08ca[_0x9f2d('0x45')]['id']}})[_0x9f2d('0x25')](handleEntityNotFound(_0x130dad,null))[_0x9f2d('0x25')](function(_0x19e1f4){if(_0x19e1f4){_0x1db89c=_0x19e1f4;_0x394b58['model']=_[_0x9f2d('0x2f')](db[_0x9f2d('0x4b')][_0x9f2d('0x2b')]);_0x394b58[_0x9f2d('0x2e')]=_[_0x9f2d('0x2f')](_0x2e08ca['query']);_0x394b58[_0x9f2d('0x30')]=_['intersection'](_0x394b58[_0x9f2d('0x2d')],_0x394b58['query']);_0x30d7e4[_0x9f2d('0x32')]=_[_0x9f2d('0x31')](_0x394b58[_0x9f2d('0x2d')],qs[_0x9f2d('0x46')](_0x2e08ca[_0x9f2d('0x2e')][_0x9f2d('0x46')]));_0x30d7e4[_0x9f2d('0x32')]=_0x30d7e4[_0x9f2d('0x32')][_0x9f2d('0x33')]?_0x30d7e4[_0x9f2d('0x32')]:_0x394b58[_0x9f2d('0x2d')];_0x30d7e4['order']=qs[_0x9f2d('0x37')](_0x2e08ca[_0x9f2d('0x2e')][_0x9f2d('0x37')]);_0x30d7e4[_0x9f2d('0x3a')]=qs[_0x9f2d('0x30')](_['pick'](_0x2e08ca[_0x9f2d('0x2e')],_0x394b58[_0x9f2d('0x30')]));if(_0x2e08ca[_0x9f2d('0x2e')]['filter']){_0x30d7e4['where']=_[_0x9f2d('0x47')](_0x30d7e4[_0x9f2d('0x3a')],{'$or':_['map'](_0x30d7e4['attributes'],function(_0x5592b2){var _0x4abf12={};_0x4abf12[_0x5592b2]={'$like':'%'+_0x2e08ca['query']['filter']+'%'};return _0x4abf12;})});}_0x30d7e4=_[_0x9f2d('0x47')]({},_0x30d7e4,_0x2e08ca['options']);return _0x1db89c['getSubjects'](_0x30d7e4);}})['then'](function(_0x37533f){if(_0x37533f){_0x508062=_0x37533f[_0x9f2d('0x33')];if(!_0x2e08ca[_0x9f2d('0x2e')][_0x9f2d('0x34')](_0x9f2d('0x35'))){_0x30d7e4[_0x9f2d('0x1c')]=qs[_0x9f2d('0x1c')](_0x2e08ca['query'][_0x9f2d('0x1c')]);_0x30d7e4['offset']=qs[_0x9f2d('0x1a')](_0x2e08ca[_0x9f2d('0x2e')][_0x9f2d('0x1a')]);}return _0x1db89c[_0x9f2d('0x4d')](_0x30d7e4);}})[_0x9f2d('0x25')](function(_0x2cec70){if(_0x2cec70){return _0x2cec70?{'count':_0x508062,'rows':_0x2cec70}:null;}})['then'](respondWithResult(_0x130dad,null))[_0x9f2d('0x43')](handleError(_0x130dad,null));};exports['getDescriptions']=function(_0x3cc7ab,_0x3b54b0,_0x130c30){var _0x1a5bb0={};var _0x3f331f={};var _0x3360e6;var _0x1bb993;return db['Dynamics365Configuration'][_0x9f2d('0x4a')]({'where':{'id':_0x3cc7ab[_0x9f2d('0x45')]['id']}})['then'](handleEntityNotFound(_0x3b54b0,null))['then'](function(_0x256788){if(_0x256788){_0x3360e6=_0x256788;_0x3f331f[_0x9f2d('0x2d')]=_['keys'](db['Dynamics365Field']['rawAttributes']);_0x3f331f[_0x9f2d('0x2e')]=_[_0x9f2d('0x2f')](_0x3cc7ab[_0x9f2d('0x2e')]);_0x3f331f[_0x9f2d('0x30')]=_[_0x9f2d('0x31')](_0x3f331f[_0x9f2d('0x2d')],_0x3f331f[_0x9f2d('0x2e')]);_0x1a5bb0[_0x9f2d('0x32')]=_[_0x9f2d('0x31')](_0x3f331f['model'],qs[_0x9f2d('0x46')](_0x3cc7ab[_0x9f2d('0x2e')]['fields']));_0x1a5bb0[_0x9f2d('0x32')]=_0x1a5bb0[_0x9f2d('0x32')][_0x9f2d('0x33')]?_0x1a5bb0[_0x9f2d('0x32')]:_0x3f331f[_0x9f2d('0x2d')];_0x1a5bb0[_0x9f2d('0x36')]=qs['sort'](_0x3cc7ab[_0x9f2d('0x2e')][_0x9f2d('0x37')]);_0x1a5bb0[_0x9f2d('0x3a')]=qs[_0x9f2d('0x30')](_[_0x9f2d('0x38')](_0x3cc7ab['query'],_0x3f331f[_0x9f2d('0x30')]));if(_0x3cc7ab[_0x9f2d('0x2e')]['filter']){_0x1a5bb0['where']=_[_0x9f2d('0x47')](_0x1a5bb0['where'],{'$or':_[_0x9f2d('0x2a')](_0x1a5bb0['attributes'],function(_0xf52588){var _0x24ffbe={};_0x24ffbe[_0xf52588]={'$like':'%'+_0x3cc7ab[_0x9f2d('0x2e')]['filter']+'%'};return _0x24ffbe;})});}_0x1a5bb0=_[_0x9f2d('0x47')]({},_0x1a5bb0,_0x3cc7ab[_0x9f2d('0x3d')]);return _0x3360e6[_0x9f2d('0x4e')](_0x1a5bb0);}})['then'](function(_0x1df63e){if(_0x1df63e){_0x1bb993=_0x1df63e[_0x9f2d('0x33')];if(!_0x3cc7ab[_0x9f2d('0x2e')][_0x9f2d('0x34')]('nolimit')){_0x1a5bb0['limit']=qs[_0x9f2d('0x1c')](_0x3cc7ab[_0x9f2d('0x2e')][_0x9f2d('0x1c')]);_0x1a5bb0['offset']=qs['offset'](_0x3cc7ab[_0x9f2d('0x2e')][_0x9f2d('0x1a')]);}return _0x3360e6['getDescriptions'](_0x1a5bb0);}})[_0x9f2d('0x25')](function(_0x46f2ab){if(_0x46f2ab){return _0x46f2ab?{'count':_0x1bb993,'rows':_0x46f2ab}:null;}})[_0x9f2d('0x25')](respondWithResult(_0x3b54b0,null))[_0x9f2d('0x43')](handleError(_0x3b54b0,null));};