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 _0x4111=['undefined','count','limit','Content-Range','apply','reject','update','then','destroy','error','name','send','index','map','Dynamics365Configuration','fieldName','type','key','model','query','keys','intersection','attributes','fields','length','hasOwnProperty','sort','where','filters','filter','merge','VIRTUAL','options','include','findAll','rows','catch','show','params','rawAttributes','includeAll','find','create','body','getFields','findOne','Dynamics365Field','pick','nolimit','getSubjects','order','getDescriptions','eml-format','rimraf','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','squel','crypto','jsforce','desk.js','papaparse','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','end','status','json','offset'];(function(_0x21abc7,_0x1d5384){var _0x273d51=function(_0x298d09){while(--_0x298d09){_0x21abc7['push'](_0x21abc7['shift']());}};_0x273d51(++_0x1d5384);}(_0x4111,0x85));var _0x1411=function(_0x321bb2,_0x202794){_0x321bb2=_0x321bb2-0x0;var _0x9c12ed=_0x4111[_0x321bb2];return _0x9c12ed;};'use strict';var emlformat=require(_0x1411('0x0'));var rimraf=require(_0x1411('0x1'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0x1411('0x2'));var Mustache=require(_0x1411('0x3'));var util=require(_0x1411('0x4'));var path=require(_0x1411('0x5'));var sox=require(_0x1411('0x6'));var csv=require(_0x1411('0x7'));var ejs=require(_0x1411('0x8'));var fs=require('fs');var fs_extra=require(_0x1411('0x9'));var _=require('lodash');var squel=require(_0x1411('0xa'));var crypto=require(_0x1411('0xb'));var jsforce=require(_0x1411('0xc'));var deskjs=require(_0x1411('0xd'));var toCsv=require(_0x1411('0x7'));var querystring=require('querystring');var Papa=require(_0x1411('0xe'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0x1411('0xf'));var as=require(_0x1411('0x10'));var hardwareService=require(_0x1411('0x11'));var logger=require(_0x1411('0x12'))(_0x1411('0x13'));var utils=require(_0x1411('0x14'));var config=require(_0x1411('0x15'));var licenseUtil=require(_0x1411('0x16'));var db=require(_0x1411('0x17'))['db'];function respondWithStatusCode(_0x306c8f,_0x193aba){_0x193aba=_0x193aba||0xcc;return function(_0x3d73e2){if(_0x3d73e2){return _0x306c8f[_0x1411('0x18')](_0x193aba);}return _0x306c8f['status'](_0x193aba)[_0x1411('0x19')]();};}function respondWithResult(_0x53c0cb,_0x104e6f){_0x104e6f=_0x104e6f||0xc8;return function(_0x44e00c){if(_0x44e00c){return _0x53c0cb[_0x1411('0x1a')](_0x104e6f)[_0x1411('0x1b')](_0x44e00c);}};}function respondWithFilteredResult(_0x25d2b1,_0xaf1487){return function(_0x1819f2){if(_0x1819f2){var _0x421657=typeof _0xaf1487[_0x1411('0x1c')]===_0x1411('0x1d')&&typeof _0xaf1487['limit']==='undefined';var _0x4f8928=_0x1819f2[_0x1411('0x1e')];var _0x68fe50=_0x421657?0x0:_0xaf1487['offset'];var _0x8cfabe=_0x421657?_0x1819f2[_0x1411('0x1e')]:_0xaf1487['offset']+_0xaf1487[_0x1411('0x1f')];var _0x31c952;if(_0x8cfabe>=_0x4f8928){_0x8cfabe=_0x4f8928;_0x31c952=0xc8;}else{_0x31c952=0xce;}_0x25d2b1[_0x1411('0x1a')](_0x31c952);return _0x25d2b1['set'](_0x1411('0x20'),_0x68fe50+'-'+_0x8cfabe+'/'+_0x4f8928)[_0x1411('0x1b')](_0x1819f2);}return null;};}function patchUpdates(_0x3e8d29){return function(_0x4177d1){try{jsonpatch[_0x1411('0x21')](_0x4177d1,_0x3e8d29,!![]);}catch(_0x30ab76){return BPromise[_0x1411('0x22')](_0x30ab76);}return _0x4177d1['save']();};}function saveUpdates(_0xcdf357,_0x491478){return function(_0x18137f){if(_0x18137f){return _0x18137f[_0x1411('0x23')](_0xcdf357)[_0x1411('0x24')](function(_0x878289){return _0x878289;});}return null;};}function removeEntity(_0x5b5a82,_0x285cc8){return function(_0x53553c){if(_0x53553c){return _0x53553c[_0x1411('0x25')]()[_0x1411('0x24')](function(){_0x5b5a82[_0x1411('0x1a')](0xcc)[_0x1411('0x19')]();});}};}function handleEntityNotFound(_0x5509da,_0x14fee6){return function(_0x23c8b4){if(!_0x23c8b4){_0x5509da[_0x1411('0x18')](0x194);}return _0x23c8b4;};}function handleError(_0x5ef5c7,_0x1fb085){_0x1fb085=_0x1fb085||0x1f4;return function(_0x37cf5d){logger[_0x1411('0x26')](_0x37cf5d['stack']);if(_0x37cf5d['name']){delete _0x37cf5d[_0x1411('0x27')];}_0x5ef5c7[_0x1411('0x1a')](_0x1fb085)[_0x1411('0x28')](_0x37cf5d);};}exports[_0x1411('0x29')]=function(_0xfcc48e,_0x14be39){var _0x1c4777={},_0x4ffbb5={},_0x50ac24={'count':0x0,'rows':[]};var _0x3c3edb=_[_0x1411('0x2a')](db[_0x1411('0x2b')]['rawAttributes'],function(_0x221e2d){return{'name':_0x221e2d[_0x1411('0x2c')],'type':_0x221e2d[_0x1411('0x2d')][_0x1411('0x2e')]};});_0x4ffbb5[_0x1411('0x2f')]=_[_0x1411('0x2a')](_0x3c3edb,_0x1411('0x27'));_0x4ffbb5[_0x1411('0x30')]=_[_0x1411('0x31')](_0xfcc48e[_0x1411('0x30')]);_0x4ffbb5['filters']=_[_0x1411('0x32')](_0x4ffbb5[_0x1411('0x2f')],_0x4ffbb5[_0x1411('0x30')]);_0x1c4777[_0x1411('0x33')]=_[_0x1411('0x32')](_0x4ffbb5['model'],qs[_0x1411('0x34')](_0xfcc48e[_0x1411('0x30')]['fields']));_0x1c4777[_0x1411('0x33')]=_0x1c4777[_0x1411('0x33')][_0x1411('0x35')]?_0x1c4777[_0x1411('0x33')]:_0x4ffbb5[_0x1411('0x2f')];if(!_0xfcc48e['query'][_0x1411('0x36')]('nolimit')){_0x1c4777[_0x1411('0x1f')]=qs[_0x1411('0x1f')](_0xfcc48e[_0x1411('0x30')][_0x1411('0x1f')]);_0x1c4777['offset']=qs[_0x1411('0x1c')](_0xfcc48e[_0x1411('0x30')][_0x1411('0x1c')]);}_0x1c4777['order']=qs[_0x1411('0x37')](_0xfcc48e[_0x1411('0x30')][_0x1411('0x37')]);_0x1c4777[_0x1411('0x38')]=qs[_0x1411('0x39')](_['pick'](_0xfcc48e['query'],_0x4ffbb5[_0x1411('0x39')]),_0x3c3edb);if(_0xfcc48e[_0x1411('0x30')][_0x1411('0x3a')]){_0x1c4777[_0x1411('0x38')]=_[_0x1411('0x3b')](_0x1c4777[_0x1411('0x38')],{'$or':_[_0x1411('0x2a')](_0x3c3edb,function(_0x5747d2){if(_0x5747d2[_0x1411('0x2d')]!==_0x1411('0x3c')){var _0x54c42f={};_0x54c42f[_0x5747d2[_0x1411('0x27')]]={'$like':'%'+_0xfcc48e[_0x1411('0x30')][_0x1411('0x3a')]+'%'};return _0x54c42f;}})});}_0x1c4777=_[_0x1411('0x3b')]({},_0x1c4777,_0xfcc48e[_0x1411('0x3d')]);var _0x3d64c6={'where':_0x1c4777[_0x1411('0x38')]};return db[_0x1411('0x2b')]['count'](_0x3d64c6)[_0x1411('0x24')](function(_0x2c3950){_0x50ac24[_0x1411('0x1e')]=_0x2c3950;if(_0xfcc48e[_0x1411('0x30')]['includeAll']){_0x1c4777[_0x1411('0x3e')]=[{'all':!![]}];}return db[_0x1411('0x2b')][_0x1411('0x3f')](_0x1c4777);})[_0x1411('0x24')](function(_0x5c9a7a){_0x50ac24[_0x1411('0x40')]=_0x5c9a7a;return _0x50ac24;})[_0x1411('0x24')](respondWithFilteredResult(_0x14be39,_0x1c4777))[_0x1411('0x41')](handleError(_0x14be39,null));};exports[_0x1411('0x42')]=function(_0x4892f0,_0xc06308){var _0x459463={'raw':![],'where':{'id':_0x4892f0[_0x1411('0x43')]['id']}},_0x3ce5c7={};_0x3ce5c7[_0x1411('0x2f')]=_[_0x1411('0x31')](db['Dynamics365Configuration'][_0x1411('0x44')]);_0x3ce5c7[_0x1411('0x30')]=_[_0x1411('0x31')](_0x4892f0[_0x1411('0x30')]);_0x3ce5c7[_0x1411('0x39')]=_['intersection'](_0x3ce5c7[_0x1411('0x2f')],_0x3ce5c7[_0x1411('0x30')]);_0x459463[_0x1411('0x33')]=_[_0x1411('0x32')](_0x3ce5c7['model'],qs['fields'](_0x4892f0[_0x1411('0x30')][_0x1411('0x34')]));_0x459463[_0x1411('0x33')]=_0x459463[_0x1411('0x33')][_0x1411('0x35')]?_0x459463['attributes']:_0x3ce5c7['model'];if(_0x4892f0[_0x1411('0x30')][_0x1411('0x45')]){_0x459463[_0x1411('0x3e')]=[{'all':!![]}];}_0x459463=_[_0x1411('0x3b')]({},_0x459463,_0x4892f0[_0x1411('0x3d')]);return db['Dynamics365Configuration'][_0x1411('0x46')](_0x459463)[_0x1411('0x24')](handleEntityNotFound(_0xc06308,null))['then'](respondWithResult(_0xc06308,null))['catch'](handleError(_0xc06308,null));};exports[_0x1411('0x47')]=function(_0x3f3ac4,_0x489218){return db[_0x1411('0x2b')][_0x1411('0x47')](_0x3f3ac4[_0x1411('0x48')],{})['then'](respondWithResult(_0x489218,0xc9))[_0x1411('0x41')](handleError(_0x489218,null));};exports[_0x1411('0x23')]=function(_0x1cf1d3,_0x3a78e6){if(_0x1cf1d3['body']['id']){delete _0x1cf1d3[_0x1411('0x48')]['id'];}return db[_0x1411('0x2b')][_0x1411('0x46')]({'where':{'id':_0x1cf1d3[_0x1411('0x43')]['id']}})[_0x1411('0x24')](handleEntityNotFound(_0x3a78e6,null))['then'](saveUpdates(_0x1cf1d3['body'],null))[_0x1411('0x24')](respondWithResult(_0x3a78e6,null))[_0x1411('0x41')](handleError(_0x3a78e6,null));};exports[_0x1411('0x25')]=function(_0x541f5a,_0x5c734a){return db[_0x1411('0x2b')][_0x1411('0x46')]({'where':{'id':_0x541f5a[_0x1411('0x43')]['id']}})[_0x1411('0x24')](handleEntityNotFound(_0x5c734a,null))[_0x1411('0x24')](removeEntity(_0x5c734a,null))[_0x1411('0x41')](handleError(_0x5c734a,null));};exports[_0x1411('0x49')]=function(_0x528c75,_0x1f0a89,_0x1bff83){var _0x1af80a={};var _0xbf6117={};var _0x585e76;var _0x48a6a7;return db[_0x1411('0x2b')][_0x1411('0x4a')]({'where':{'id':_0x528c75['params']['id']}})['then'](handleEntityNotFound(_0x1f0a89,null))[_0x1411('0x24')](function(_0x1bbcc1){if(_0x1bbcc1){_0x585e76=_0x1bbcc1;_0xbf6117[_0x1411('0x2f')]=_[_0x1411('0x31')](db[_0x1411('0x4b')][_0x1411('0x44')]);_0xbf6117[_0x1411('0x30')]=_[_0x1411('0x31')](_0x528c75['query']);_0xbf6117[_0x1411('0x39')]=_[_0x1411('0x32')](_0xbf6117[_0x1411('0x2f')],_0xbf6117[_0x1411('0x30')]);_0x1af80a[_0x1411('0x33')]=_['intersection'](_0xbf6117['model'],qs['fields'](_0x528c75['query'][_0x1411('0x34')]));_0x1af80a['attributes']=_0x1af80a['attributes']['length']?_0x1af80a['attributes']:_0xbf6117[_0x1411('0x2f')];_0x1af80a['order']=qs[_0x1411('0x37')](_0x528c75[_0x1411('0x30')][_0x1411('0x37')]);_0x1af80a['where']=qs[_0x1411('0x39')](_[_0x1411('0x4c')](_0x528c75[_0x1411('0x30')],_0xbf6117[_0x1411('0x39')]));if(_0x528c75[_0x1411('0x30')][_0x1411('0x3a')]){_0x1af80a['where']=_['merge'](_0x1af80a[_0x1411('0x38')],{'$or':_[_0x1411('0x2a')](_0x1af80a[_0x1411('0x33')],function(_0x9c5346){var _0x4294c5={};_0x4294c5[_0x9c5346]={'$like':'%'+_0x528c75[_0x1411('0x30')][_0x1411('0x3a')]+'%'};return _0x4294c5;})});}_0x1af80a=_[_0x1411('0x3b')]({},_0x1af80a,_0x528c75['options']);return _0x585e76['getFields'](_0x1af80a);}})[_0x1411('0x24')](function(_0x12f368){if(_0x12f368){_0x48a6a7=_0x12f368[_0x1411('0x35')];if(!_0x528c75[_0x1411('0x30')][_0x1411('0x36')](_0x1411('0x4d'))){_0x1af80a[_0x1411('0x1f')]=qs[_0x1411('0x1f')](_0x528c75['query']['limit']);_0x1af80a[_0x1411('0x1c')]=qs['offset'](_0x528c75[_0x1411('0x30')][_0x1411('0x1c')]);}return _0x585e76['getFields'](_0x1af80a);}})[_0x1411('0x24')](function(_0x2a5ef7){if(_0x2a5ef7){return _0x2a5ef7?{'count':_0x48a6a7,'rows':_0x2a5ef7}:null;}})[_0x1411('0x24')](respondWithResult(_0x1f0a89,null))[_0x1411('0x41')](handleError(_0x1f0a89,null));};exports[_0x1411('0x4e')]=function(_0x13a645,_0x507868,_0x571a84){var _0x17c5f8={};var _0x19d36b={};var _0x5159e6;var _0x45bdc1;return db[_0x1411('0x2b')][_0x1411('0x4a')]({'where':{'id':_0x13a645['params']['id']}})[_0x1411('0x24')](handleEntityNotFound(_0x507868,null))['then'](function(_0x21823a){if(_0x21823a){_0x5159e6=_0x21823a;_0x19d36b[_0x1411('0x2f')]=_[_0x1411('0x31')](db[_0x1411('0x4b')][_0x1411('0x44')]);_0x19d36b[_0x1411('0x30')]=_[_0x1411('0x31')](_0x13a645[_0x1411('0x30')]);_0x19d36b[_0x1411('0x39')]=_[_0x1411('0x32')](_0x19d36b['model'],_0x19d36b[_0x1411('0x30')]);_0x17c5f8[_0x1411('0x33')]=_['intersection'](_0x19d36b['model'],qs[_0x1411('0x34')](_0x13a645[_0x1411('0x30')]['fields']));_0x17c5f8[_0x1411('0x33')]=_0x17c5f8[_0x1411('0x33')][_0x1411('0x35')]?_0x17c5f8[_0x1411('0x33')]:_0x19d36b[_0x1411('0x2f')];_0x17c5f8[_0x1411('0x4f')]=qs['sort'](_0x13a645[_0x1411('0x30')]['sort']);_0x17c5f8['where']=qs[_0x1411('0x39')](_[_0x1411('0x4c')](_0x13a645[_0x1411('0x30')],_0x19d36b[_0x1411('0x39')]));if(_0x13a645[_0x1411('0x30')][_0x1411('0x3a')]){_0x17c5f8[_0x1411('0x38')]=_['merge'](_0x17c5f8[_0x1411('0x38')],{'$or':_[_0x1411('0x2a')](_0x17c5f8[_0x1411('0x33')],function(_0x43b0e6){var _0x55bedb={};_0x55bedb[_0x43b0e6]={'$like':'%'+_0x13a645[_0x1411('0x30')]['filter']+'%'};return _0x55bedb;})});}_0x17c5f8=_[_0x1411('0x3b')]({},_0x17c5f8,_0x13a645[_0x1411('0x3d')]);return _0x5159e6['getSubjects'](_0x17c5f8);}})[_0x1411('0x24')](function(_0x507131){if(_0x507131){_0x45bdc1=_0x507131[_0x1411('0x35')];if(!_0x13a645[_0x1411('0x30')][_0x1411('0x36')](_0x1411('0x4d'))){_0x17c5f8[_0x1411('0x1f')]=qs[_0x1411('0x1f')](_0x13a645['query'][_0x1411('0x1f')]);_0x17c5f8['offset']=qs['offset'](_0x13a645[_0x1411('0x30')][_0x1411('0x1c')]);}return _0x5159e6[_0x1411('0x4e')](_0x17c5f8);}})['then'](function(_0x58232d){if(_0x58232d){return _0x58232d?{'count':_0x45bdc1,'rows':_0x58232d}:null;}})[_0x1411('0x24')](respondWithResult(_0x507868,null))[_0x1411('0x41')](handleError(_0x507868,null));};exports[_0x1411('0x50')]=function(_0x4d5e2b,_0x5ac045,_0x3e186b){var _0x390a65={};var _0x522376={};var _0x59c5de;var _0x41f742;return db['Dynamics365Configuration'][_0x1411('0x4a')]({'where':{'id':_0x4d5e2b['params']['id']}})['then'](handleEntityNotFound(_0x5ac045,null))[_0x1411('0x24')](function(_0x2f3312){if(_0x2f3312){_0x59c5de=_0x2f3312;_0x522376['model']=_[_0x1411('0x31')](db['Dynamics365Field'][_0x1411('0x44')]);_0x522376[_0x1411('0x30')]=_[_0x1411('0x31')](_0x4d5e2b[_0x1411('0x30')]);_0x522376[_0x1411('0x39')]=_[_0x1411('0x32')](_0x522376[_0x1411('0x2f')],_0x522376[_0x1411('0x30')]);_0x390a65[_0x1411('0x33')]=_[_0x1411('0x32')](_0x522376[_0x1411('0x2f')],qs[_0x1411('0x34')](_0x4d5e2b[_0x1411('0x30')][_0x1411('0x34')]));_0x390a65[_0x1411('0x33')]=_0x390a65[_0x1411('0x33')][_0x1411('0x35')]?_0x390a65[_0x1411('0x33')]:_0x522376[_0x1411('0x2f')];_0x390a65['order']=qs[_0x1411('0x37')](_0x4d5e2b['query'][_0x1411('0x37')]);_0x390a65[_0x1411('0x38')]=qs[_0x1411('0x39')](_[_0x1411('0x4c')](_0x4d5e2b[_0x1411('0x30')],_0x522376['filters']));if(_0x4d5e2b[_0x1411('0x30')][_0x1411('0x3a')]){_0x390a65[_0x1411('0x38')]=_[_0x1411('0x3b')](_0x390a65['where'],{'$or':_[_0x1411('0x2a')](_0x390a65[_0x1411('0x33')],function(_0x15d411){var _0x479265={};_0x479265[_0x15d411]={'$like':'%'+_0x4d5e2b['query'][_0x1411('0x3a')]+'%'};return _0x479265;})});}_0x390a65=_[_0x1411('0x3b')]({},_0x390a65,_0x4d5e2b['options']);return _0x59c5de[_0x1411('0x50')](_0x390a65);}})[_0x1411('0x24')](function(_0x405837){if(_0x405837){_0x41f742=_0x405837[_0x1411('0x35')];if(!_0x4d5e2b[_0x1411('0x30')][_0x1411('0x36')](_0x1411('0x4d'))){_0x390a65[_0x1411('0x1f')]=qs['limit'](_0x4d5e2b[_0x1411('0x30')][_0x1411('0x1f')]);_0x390a65[_0x1411('0x1c')]=qs[_0x1411('0x1c')](_0x4d5e2b['query'][_0x1411('0x1c')]);}return _0x59c5de[_0x1411('0x50')](_0x390a65);}})[_0x1411('0x24')](function(_0x58f86d){if(_0x58f86d){return _0x58f86d?{'count':_0x41f742,'rows':_0x58f86d}:null;}})[_0x1411('0x24')](respondWithResult(_0x5ac045,null))[_0x1411('0x41')](handleError(_0x5ac045,null));};