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 _0x2d12=['filter','merge','VIRTUAL','options','includeAll','include','findAll','catch','show','params','find','create','body','getFields','findOne','length','pick','nolimit','getSubjects','Dynamics365Field','getDescriptions','eml-format','rimraf','zip-dir','fast-json-patch','moment','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','status','end','json','undefined','limit','count','offset','set','Content-Range','apply','reject','update','then','destroy','error','name','send','map','Dynamics365Configuration','rawAttributes','type','key','model','keys','query','intersection','fields','attributes','hasOwnProperty','order','sort','where','filters'];(function(_0x319af4,_0x19cce9){var _0x187817=function(_0x28a263){while(--_0x28a263){_0x319af4['push'](_0x319af4['shift']());}};_0x187817(++_0x19cce9);}(_0x2d12,0x1e3));var _0x22d1=function(_0x5f20a8,_0x1581c6){_0x5f20a8=_0x5f20a8-0x0;var _0x482266=_0x2d12[_0x5f20a8];return _0x482266;};'use strict';var emlformat=require(_0x22d1('0x0'));var rimraf=require(_0x22d1('0x1'));var zipdir=require(_0x22d1('0x2'));var jsonpatch=require(_0x22d1('0x3'));var rp=require('request-promise');var moment=require(_0x22d1('0x4'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require('util');var path=require('path');var sox=require('sox');var csv=require(_0x22d1('0x5'));var ejs=require(_0x22d1('0x6'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x22d1('0x7'));var squel=require(_0x22d1('0x8'));var crypto=require(_0x22d1('0x9'));var jsforce=require(_0x22d1('0xa'));var deskjs=require(_0x22d1('0xb'));var toCsv=require(_0x22d1('0x5'));var querystring=require(_0x22d1('0xc'));var Papa=require(_0x22d1('0xd'));var Redis=require('ioredis');var authService=require(_0x22d1('0xe'));var qs=require(_0x22d1('0xf'));var as=require(_0x22d1('0x10'));var hardwareService=require(_0x22d1('0x11'));var logger=require(_0x22d1('0x12'))(_0x22d1('0x13'));var utils=require(_0x22d1('0x14'));var config=require(_0x22d1('0x15'));var licenseUtil=require('../../config/license/util');var db=require(_0x22d1('0x16'))['db'];function respondWithStatusCode(_0x350c66,_0x30da3f){_0x30da3f=_0x30da3f||0xcc;return function(_0x5b52a2){if(_0x5b52a2){return _0x350c66['sendStatus'](_0x30da3f);}return _0x350c66[_0x22d1('0x17')](_0x30da3f)[_0x22d1('0x18')]();};}function respondWithResult(_0x362bd5,_0x16be8c){_0x16be8c=_0x16be8c||0xc8;return function(_0x110dba){if(_0x110dba){return _0x362bd5[_0x22d1('0x17')](_0x16be8c)[_0x22d1('0x19')](_0x110dba);}};}function respondWithFilteredResult(_0x566bda,_0x1f26ea){return function(_0x134417){if(_0x134417){var _0x350bd9=typeof _0x1f26ea['offset']===_0x22d1('0x1a')&&typeof _0x1f26ea[_0x22d1('0x1b')]==='undefined';var _0x260b7b=_0x134417[_0x22d1('0x1c')];var _0x17d3a2=_0x350bd9?0x0:_0x1f26ea[_0x22d1('0x1d')];var _0x1bde18=_0x350bd9?_0x134417[_0x22d1('0x1c')]:_0x1f26ea[_0x22d1('0x1d')]+_0x1f26ea['limit'];var _0x37cade;if(_0x1bde18>=_0x260b7b){_0x1bde18=_0x260b7b;_0x37cade=0xc8;}else{_0x37cade=0xce;}_0x566bda['status'](_0x37cade);return _0x566bda[_0x22d1('0x1e')](_0x22d1('0x1f'),_0x17d3a2+'-'+_0x1bde18+'/'+_0x260b7b)[_0x22d1('0x19')](_0x134417);}return null;};}function patchUpdates(_0x5b748d){return function(_0x3c0c34){try{jsonpatch[_0x22d1('0x20')](_0x3c0c34,_0x5b748d,!![]);}catch(_0x4bb801){return BPromise[_0x22d1('0x21')](_0x4bb801);}return _0x3c0c34['save']();};}function saveUpdates(_0x2d4a15,_0x37e773){return function(_0x25c860){if(_0x25c860){return _0x25c860[_0x22d1('0x22')](_0x2d4a15)[_0x22d1('0x23')](function(_0x43aea5){return _0x43aea5;});}return null;};}function removeEntity(_0xfc1fc,_0x591a58){return function(_0x58732d){if(_0x58732d){return _0x58732d[_0x22d1('0x24')]()['then'](function(){_0xfc1fc[_0x22d1('0x17')](0xcc)[_0x22d1('0x18')]();});}};}function handleEntityNotFound(_0x56d47f,_0x5795aa){return function(_0x532180){if(!_0x532180){_0x56d47f['sendStatus'](0x194);}return _0x532180;};}function handleError(_0x53e36b,_0x1d4330){_0x1d4330=_0x1d4330||0x1f4;return function(_0x9d1e04){logger[_0x22d1('0x25')](_0x9d1e04['stack']);if(_0x9d1e04[_0x22d1('0x26')]){delete _0x9d1e04[_0x22d1('0x26')];}_0x53e36b['status'](_0x1d4330)[_0x22d1('0x27')](_0x9d1e04);};}exports['index']=function(_0x2c1f44,_0x13d3b6){var _0x4b2d81={},_0x55719b={},_0x25ad10={'count':0x0,'rows':[]};var _0x1576dc=_[_0x22d1('0x28')](db[_0x22d1('0x29')][_0x22d1('0x2a')],function(_0x364542){return{'name':_0x364542['fieldName'],'type':_0x364542[_0x22d1('0x2b')][_0x22d1('0x2c')]};});_0x55719b[_0x22d1('0x2d')]=_[_0x22d1('0x28')](_0x1576dc,_0x22d1('0x26'));_0x55719b['query']=_[_0x22d1('0x2e')](_0x2c1f44[_0x22d1('0x2f')]);_0x55719b['filters']=_['intersection'](_0x55719b[_0x22d1('0x2d')],_0x55719b[_0x22d1('0x2f')]);_0x4b2d81['attributes']=_[_0x22d1('0x30')](_0x55719b[_0x22d1('0x2d')],qs[_0x22d1('0x31')](_0x2c1f44[_0x22d1('0x2f')][_0x22d1('0x31')]));_0x4b2d81['attributes']=_0x4b2d81[_0x22d1('0x32')]['length']?_0x4b2d81[_0x22d1('0x32')]:_0x55719b[_0x22d1('0x2d')];if(!_0x2c1f44['query'][_0x22d1('0x33')]('nolimit')){_0x4b2d81[_0x22d1('0x1b')]=qs['limit'](_0x2c1f44[_0x22d1('0x2f')][_0x22d1('0x1b')]);_0x4b2d81['offset']=qs[_0x22d1('0x1d')](_0x2c1f44[_0x22d1('0x2f')][_0x22d1('0x1d')]);}_0x4b2d81[_0x22d1('0x34')]=qs[_0x22d1('0x35')](_0x2c1f44[_0x22d1('0x2f')][_0x22d1('0x35')]);_0x4b2d81[_0x22d1('0x36')]=qs[_0x22d1('0x37')](_['pick'](_0x2c1f44[_0x22d1('0x2f')],_0x55719b[_0x22d1('0x37')]),_0x1576dc);if(_0x2c1f44[_0x22d1('0x2f')][_0x22d1('0x38')]){_0x4b2d81[_0x22d1('0x36')]=_[_0x22d1('0x39')](_0x4b2d81[_0x22d1('0x36')],{'$or':_['map'](_0x1576dc,function(_0x2db7a2){if(_0x2db7a2[_0x22d1('0x2b')]!==_0x22d1('0x3a')){var _0x4183bf={};_0x4183bf[_0x2db7a2[_0x22d1('0x26')]]={'$like':'%'+_0x2c1f44['query']['filter']+'%'};return _0x4183bf;}})});}_0x4b2d81=_[_0x22d1('0x39')]({},_0x4b2d81,_0x2c1f44[_0x22d1('0x3b')]);var _0x34c7f0={'where':_0x4b2d81['where']};return db[_0x22d1('0x29')][_0x22d1('0x1c')](_0x34c7f0)[_0x22d1('0x23')](function(_0x430fe6){_0x25ad10['count']=_0x430fe6;if(_0x2c1f44['query'][_0x22d1('0x3c')]){_0x4b2d81[_0x22d1('0x3d')]=[{'all':!![]}];}return db['Dynamics365Configuration'][_0x22d1('0x3e')](_0x4b2d81);})[_0x22d1('0x23')](function(_0xf42feb){_0x25ad10['rows']=_0xf42feb;return _0x25ad10;})[_0x22d1('0x23')](respondWithFilteredResult(_0x13d3b6,_0x4b2d81))[_0x22d1('0x3f')](handleError(_0x13d3b6,null));};exports[_0x22d1('0x40')]=function(_0x34c8ed,_0x2e35b4){var _0x5d312f={'raw':![],'where':{'id':_0x34c8ed[_0x22d1('0x41')]['id']}},_0x2a491a={};_0x2a491a[_0x22d1('0x2d')]=_[_0x22d1('0x2e')](db[_0x22d1('0x29')]['rawAttributes']);_0x2a491a[_0x22d1('0x2f')]=_['keys'](_0x34c8ed[_0x22d1('0x2f')]);_0x2a491a[_0x22d1('0x37')]=_[_0x22d1('0x30')](_0x2a491a[_0x22d1('0x2d')],_0x2a491a[_0x22d1('0x2f')]);_0x5d312f[_0x22d1('0x32')]=_[_0x22d1('0x30')](_0x2a491a[_0x22d1('0x2d')],qs[_0x22d1('0x31')](_0x34c8ed[_0x22d1('0x2f')][_0x22d1('0x31')]));_0x5d312f[_0x22d1('0x32')]=_0x5d312f['attributes']['length']?_0x5d312f['attributes']:_0x2a491a[_0x22d1('0x2d')];if(_0x34c8ed[_0x22d1('0x2f')][_0x22d1('0x3c')]){_0x5d312f[_0x22d1('0x3d')]=[{'all':!![]}];}_0x5d312f=_[_0x22d1('0x39')]({},_0x5d312f,_0x34c8ed[_0x22d1('0x3b')]);return db[_0x22d1('0x29')][_0x22d1('0x42')](_0x5d312f)[_0x22d1('0x23')](handleEntityNotFound(_0x2e35b4,null))[_0x22d1('0x23')](respondWithResult(_0x2e35b4,null))['catch'](handleError(_0x2e35b4,null));};exports[_0x22d1('0x43')]=function(_0x4a0b2d,_0x55af90){return db[_0x22d1('0x29')][_0x22d1('0x43')](_0x4a0b2d['body'],{})[_0x22d1('0x23')](respondWithResult(_0x55af90,0xc9))[_0x22d1('0x3f')](handleError(_0x55af90,null));};exports[_0x22d1('0x22')]=function(_0x49d56a,_0x4e66e2){if(_0x49d56a['body']['id']){delete _0x49d56a[_0x22d1('0x44')]['id'];}return db[_0x22d1('0x29')][_0x22d1('0x42')]({'where':{'id':_0x49d56a[_0x22d1('0x41')]['id']}})[_0x22d1('0x23')](handleEntityNotFound(_0x4e66e2,null))['then'](saveUpdates(_0x49d56a[_0x22d1('0x44')],null))[_0x22d1('0x23')](respondWithResult(_0x4e66e2,null))['catch'](handleError(_0x4e66e2,null));};exports[_0x22d1('0x24')]=function(_0x5595bb,_0x353679){return db[_0x22d1('0x29')]['find']({'where':{'id':_0x5595bb[_0x22d1('0x41')]['id']}})[_0x22d1('0x23')](handleEntityNotFound(_0x353679,null))[_0x22d1('0x23')](removeEntity(_0x353679,null))[_0x22d1('0x3f')](handleError(_0x353679,null));};exports[_0x22d1('0x45')]=function(_0x15065e,_0x1ddf3b,_0x5765a1){var _0x7f0347={};var _0x27548a={};var _0x3e91ac;var _0x444e81;return db[_0x22d1('0x29')][_0x22d1('0x46')]({'where':{'id':_0x15065e[_0x22d1('0x41')]['id']}})[_0x22d1('0x23')](handleEntityNotFound(_0x1ddf3b,null))[_0x22d1('0x23')](function(_0x548847){if(_0x548847){_0x3e91ac=_0x548847;_0x27548a['model']=_[_0x22d1('0x2e')](db['Dynamics365Field'][_0x22d1('0x2a')]);_0x27548a['query']=_[_0x22d1('0x2e')](_0x15065e['query']);_0x27548a['filters']=_[_0x22d1('0x30')](_0x27548a[_0x22d1('0x2d')],_0x27548a[_0x22d1('0x2f')]);_0x7f0347[_0x22d1('0x32')]=_[_0x22d1('0x30')](_0x27548a[_0x22d1('0x2d')],qs[_0x22d1('0x31')](_0x15065e[_0x22d1('0x2f')]['fields']));_0x7f0347['attributes']=_0x7f0347[_0x22d1('0x32')][_0x22d1('0x47')]?_0x7f0347[_0x22d1('0x32')]:_0x27548a[_0x22d1('0x2d')];_0x7f0347[_0x22d1('0x34')]=qs['sort'](_0x15065e['query'][_0x22d1('0x35')]);_0x7f0347['where']=qs[_0x22d1('0x37')](_[_0x22d1('0x48')](_0x15065e[_0x22d1('0x2f')],_0x27548a[_0x22d1('0x37')]));if(_0x15065e[_0x22d1('0x2f')][_0x22d1('0x38')]){_0x7f0347[_0x22d1('0x36')]=_[_0x22d1('0x39')](_0x7f0347[_0x22d1('0x36')],{'$or':_[_0x22d1('0x28')](_0x7f0347[_0x22d1('0x32')],function(_0x4c69be){var _0x418182={};_0x418182[_0x4c69be]={'$like':'%'+_0x15065e[_0x22d1('0x2f')]['filter']+'%'};return _0x418182;})});}_0x7f0347=_[_0x22d1('0x39')]({},_0x7f0347,_0x15065e[_0x22d1('0x3b')]);return _0x3e91ac['getFields'](_0x7f0347);}})[_0x22d1('0x23')](function(_0x57712d){if(_0x57712d){_0x444e81=_0x57712d[_0x22d1('0x47')];if(!_0x15065e[_0x22d1('0x2f')][_0x22d1('0x33')](_0x22d1('0x49'))){_0x7f0347['limit']=qs[_0x22d1('0x1b')](_0x15065e[_0x22d1('0x2f')][_0x22d1('0x1b')]);_0x7f0347[_0x22d1('0x1d')]=qs[_0x22d1('0x1d')](_0x15065e['query'][_0x22d1('0x1d')]);}return _0x3e91ac[_0x22d1('0x45')](_0x7f0347);}})[_0x22d1('0x23')](function(_0x2e3777){if(_0x2e3777){return _0x2e3777?{'count':_0x444e81,'rows':_0x2e3777}:null;}})[_0x22d1('0x23')](respondWithResult(_0x1ddf3b,null))[_0x22d1('0x3f')](handleError(_0x1ddf3b,null));};exports[_0x22d1('0x4a')]=function(_0x2f78f6,_0x534e79,_0x4e0162){var _0x5823f1={};var _0xcc67a4={};var _0x58c7ac;var _0x36c0f5;return db['Dynamics365Configuration'][_0x22d1('0x46')]({'where':{'id':_0x2f78f6[_0x22d1('0x41')]['id']}})[_0x22d1('0x23')](handleEntityNotFound(_0x534e79,null))[_0x22d1('0x23')](function(_0x1c6690){if(_0x1c6690){_0x58c7ac=_0x1c6690;_0xcc67a4[_0x22d1('0x2d')]=_[_0x22d1('0x2e')](db[_0x22d1('0x4b')]['rawAttributes']);_0xcc67a4['query']=_[_0x22d1('0x2e')](_0x2f78f6[_0x22d1('0x2f')]);_0xcc67a4[_0x22d1('0x37')]=_['intersection'](_0xcc67a4[_0x22d1('0x2d')],_0xcc67a4['query']);_0x5823f1['attributes']=_[_0x22d1('0x30')](_0xcc67a4['model'],qs[_0x22d1('0x31')](_0x2f78f6['query']['fields']));_0x5823f1[_0x22d1('0x32')]=_0x5823f1[_0x22d1('0x32')][_0x22d1('0x47')]?_0x5823f1[_0x22d1('0x32')]:_0xcc67a4[_0x22d1('0x2d')];_0x5823f1[_0x22d1('0x34')]=qs[_0x22d1('0x35')](_0x2f78f6[_0x22d1('0x2f')]['sort']);_0x5823f1['where']=qs[_0x22d1('0x37')](_[_0x22d1('0x48')](_0x2f78f6[_0x22d1('0x2f')],_0xcc67a4[_0x22d1('0x37')]));if(_0x2f78f6['query']['filter']){_0x5823f1[_0x22d1('0x36')]=_[_0x22d1('0x39')](_0x5823f1['where'],{'$or':_[_0x22d1('0x28')](_0x5823f1[_0x22d1('0x32')],function(_0x41c0a1){var _0xf1348={};_0xf1348[_0x41c0a1]={'$like':'%'+_0x2f78f6[_0x22d1('0x2f')][_0x22d1('0x38')]+'%'};return _0xf1348;})});}_0x5823f1=_['merge']({},_0x5823f1,_0x2f78f6['options']);return _0x58c7ac['getSubjects'](_0x5823f1);}})['then'](function(_0x48d356){if(_0x48d356){_0x36c0f5=_0x48d356[_0x22d1('0x47')];if(!_0x2f78f6[_0x22d1('0x2f')][_0x22d1('0x33')]('nolimit')){_0x5823f1[_0x22d1('0x1b')]=qs[_0x22d1('0x1b')](_0x2f78f6[_0x22d1('0x2f')][_0x22d1('0x1b')]);_0x5823f1[_0x22d1('0x1d')]=qs['offset'](_0x2f78f6[_0x22d1('0x2f')][_0x22d1('0x1d')]);}return _0x58c7ac[_0x22d1('0x4a')](_0x5823f1);}})[_0x22d1('0x23')](function(_0xa8463c){if(_0xa8463c){return _0xa8463c?{'count':_0x36c0f5,'rows':_0xa8463c}:null;}})[_0x22d1('0x23')](respondWithResult(_0x534e79,null))[_0x22d1('0x3f')](handleError(_0x534e79,null));};exports[_0x22d1('0x4c')]=function(_0x342744,_0x1973b1,_0x5e8c39){var _0x500068={};var _0x34c6da={};var _0x3ca95c;var _0x17b0ca;return db[_0x22d1('0x29')][_0x22d1('0x46')]({'where':{'id':_0x342744[_0x22d1('0x41')]['id']}})[_0x22d1('0x23')](handleEntityNotFound(_0x1973b1,null))[_0x22d1('0x23')](function(_0x5535dd){if(_0x5535dd){_0x3ca95c=_0x5535dd;_0x34c6da[_0x22d1('0x2d')]=_[_0x22d1('0x2e')](db[_0x22d1('0x4b')][_0x22d1('0x2a')]);_0x34c6da['query']=_[_0x22d1('0x2e')](_0x342744[_0x22d1('0x2f')]);_0x34c6da[_0x22d1('0x37')]=_[_0x22d1('0x30')](_0x34c6da[_0x22d1('0x2d')],_0x34c6da[_0x22d1('0x2f')]);_0x500068[_0x22d1('0x32')]=_[_0x22d1('0x30')](_0x34c6da[_0x22d1('0x2d')],qs['fields'](_0x342744[_0x22d1('0x2f')]['fields']));_0x500068['attributes']=_0x500068[_0x22d1('0x32')][_0x22d1('0x47')]?_0x500068[_0x22d1('0x32')]:_0x34c6da[_0x22d1('0x2d')];_0x500068[_0x22d1('0x34')]=qs[_0x22d1('0x35')](_0x342744[_0x22d1('0x2f')][_0x22d1('0x35')]);_0x500068[_0x22d1('0x36')]=qs[_0x22d1('0x37')](_[_0x22d1('0x48')](_0x342744[_0x22d1('0x2f')],_0x34c6da[_0x22d1('0x37')]));if(_0x342744['query'][_0x22d1('0x38')]){_0x500068[_0x22d1('0x36')]=_[_0x22d1('0x39')](_0x500068['where'],{'$or':_[_0x22d1('0x28')](_0x500068[_0x22d1('0x32')],function(_0x9a22a5){var _0x483ef4={};_0x483ef4[_0x9a22a5]={'$like':'%'+_0x342744[_0x22d1('0x2f')][_0x22d1('0x38')]+'%'};return _0x483ef4;})});}_0x500068=_[_0x22d1('0x39')]({},_0x500068,_0x342744[_0x22d1('0x3b')]);return _0x3ca95c[_0x22d1('0x4c')](_0x500068);}})[_0x22d1('0x23')](function(_0x5cce2a){if(_0x5cce2a){_0x17b0ca=_0x5cce2a[_0x22d1('0x47')];if(!_0x342744[_0x22d1('0x2f')][_0x22d1('0x33')](_0x22d1('0x49'))){_0x500068['limit']=qs[_0x22d1('0x1b')](_0x342744['query'][_0x22d1('0x1b')]);_0x500068[_0x22d1('0x1d')]=qs['offset'](_0x342744[_0x22d1('0x2f')][_0x22d1('0x1d')]);}return _0x3ca95c[_0x22d1('0x4c')](_0x500068);}})[_0x22d1('0x23')](function(_0x5d1190){if(_0x5d1190){return _0x5d1190?{'count':_0x17b0ca,'rows':_0x5d1190}:null;}})[_0x22d1('0x23')](respondWithResult(_0x1973b1,null))[_0x22d1('0x3f')](handleError(_0x1973b1,null));};