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 _0xc87e=['filter','merge','VIRTUAL','count','includeAll','include','findAll','rows','catch','show','params','keys','options','find','create','body','destroy','getFields','Dynamics365Field','sort','hasOwnProperty','getSubjects','findOne','getDescriptions','nolimit','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','fs-extra','lodash','crypto','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','json','offset','undefined','limit','set','Content-Range','apply','save','update','then','end','error','stack','name','index','map','Dynamics365Configuration','rawAttributes','fieldName','type','key','model','query','filters','intersection','attributes','fields','length','order','where','pick'];(function(_0x36f243,_0x188505){var _0x426436=function(_0x1c8622){while(--_0x1c8622){_0x36f243['push'](_0x36f243['shift']());}};_0x426436(++_0x188505);}(_0xc87e,0x1b8));var _0xec87=function(_0x5d51a6,_0x40a51a){_0x5d51a6=_0x5d51a6-0x0;var _0x1e20b1=_0xc87e[_0x5d51a6];return _0x1e20b1;};'use strict';var emlformat=require(_0xec87('0x0'));var rimraf=require(_0xec87('0x1'));var zipdir=require(_0xec87('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0xec87('0x3'));var moment=require(_0xec87('0x4'));var BPromise=require(_0xec87('0x5'));var Mustache=require(_0xec87('0x6'));var util=require(_0xec87('0x7'));var path=require('path');var sox=require(_0xec87('0x8'));var csv=require(_0xec87('0x9'));var ejs=require(_0xec87('0xa'));var fs=require('fs');var fs_extra=require(_0xec87('0xb'));var _=require(_0xec87('0xc'));var squel=require('squel');var crypto=require(_0xec87('0xd'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0xec87('0x9'));var querystring=require(_0xec87('0xe'));var Papa=require('papaparse');var Redis=require(_0xec87('0xf'));var authService=require(_0xec87('0x10'));var qs=require(_0xec87('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xec87('0x12'));var logger=require(_0xec87('0x13'))(_0xec87('0x14'));var utils=require(_0xec87('0x15'));var config=require(_0xec87('0x16'));var licenseUtil=require(_0xec87('0x17'));var db=require(_0xec87('0x18'))['db'];function respondWithStatusCode(_0x37d4c7,_0x5d2102){_0x5d2102=_0x5d2102||0xcc;return function(_0x24eec0){if(_0x24eec0){return _0x37d4c7[_0xec87('0x19')](_0x5d2102);}return _0x37d4c7[_0xec87('0x1a')](_0x5d2102)['end']();};}function respondWithResult(_0x9caebb,_0x49eab2){_0x49eab2=_0x49eab2||0xc8;return function(_0x2173ec){if(_0x2173ec){return _0x9caebb[_0xec87('0x1a')](_0x49eab2)[_0xec87('0x1b')](_0x2173ec);}};}function respondWithFilteredResult(_0x4f4ff5,_0x4a9ea4){return function(_0x4c6889){if(_0x4c6889){var _0x11de5d=typeof _0x4a9ea4[_0xec87('0x1c')]===_0xec87('0x1d')&&typeof _0x4a9ea4[_0xec87('0x1e')]===_0xec87('0x1d');var _0x3ba76c=_0x4c6889['count'];var _0x32c989=_0x11de5d?0x0:_0x4a9ea4[_0xec87('0x1c')];var _0x521ecb=_0x11de5d?_0x4c6889['count']:_0x4a9ea4[_0xec87('0x1c')]+_0x4a9ea4[_0xec87('0x1e')];var _0x1794f8;if(_0x521ecb>=_0x3ba76c){_0x521ecb=_0x3ba76c;_0x1794f8=0xc8;}else{_0x1794f8=0xce;}_0x4f4ff5[_0xec87('0x1a')](_0x1794f8);return _0x4f4ff5[_0xec87('0x1f')](_0xec87('0x20'),_0x32c989+'-'+_0x521ecb+'/'+_0x3ba76c)['json'](_0x4c6889);}return null;};}function patchUpdates(_0xf0488e){return function(_0x4f66ed){try{jsonpatch[_0xec87('0x21')](_0x4f66ed,_0xf0488e,!![]);}catch(_0x177310){return BPromise['reject'](_0x177310);}return _0x4f66ed[_0xec87('0x22')]();};}function saveUpdates(_0x3917e5,_0x39b089){return function(_0xb95912){if(_0xb95912){return _0xb95912[_0xec87('0x23')](_0x3917e5)[_0xec87('0x24')](function(_0x4fb635){return _0x4fb635;});}return null;};}function removeEntity(_0x158cfb,_0x4206a0){return function(_0x4f228d){if(_0x4f228d){return _0x4f228d['destroy']()[_0xec87('0x24')](function(){_0x158cfb[_0xec87('0x1a')](0xcc)[_0xec87('0x25')]();});}};}function handleEntityNotFound(_0x20eb32,_0x3692c6){return function(_0x388617){if(!_0x388617){_0x20eb32['sendStatus'](0x194);}return _0x388617;};}function handleError(_0x111a37,_0x217e06){_0x217e06=_0x217e06||0x1f4;return function(_0x4b4cee){logger[_0xec87('0x26')](_0x4b4cee[_0xec87('0x27')]);if(_0x4b4cee['name']){delete _0x4b4cee[_0xec87('0x28')];}_0x111a37[_0xec87('0x1a')](_0x217e06)['send'](_0x4b4cee);};}exports[_0xec87('0x29')]=function(_0x41c514,_0x111e2c){var _0x330baf={},_0x544843={},_0x57c727={'count':0x0,'rows':[]};var _0x567013=_[_0xec87('0x2a')](db[_0xec87('0x2b')][_0xec87('0x2c')],function(_0x327031){return{'name':_0x327031[_0xec87('0x2d')],'type':_0x327031[_0xec87('0x2e')][_0xec87('0x2f')]};});_0x544843[_0xec87('0x30')]=_[_0xec87('0x2a')](_0x567013,_0xec87('0x28'));_0x544843[_0xec87('0x31')]=_['keys'](_0x41c514[_0xec87('0x31')]);_0x544843[_0xec87('0x32')]=_[_0xec87('0x33')](_0x544843['model'],_0x544843[_0xec87('0x31')]);_0x330baf[_0xec87('0x34')]=_['intersection'](_0x544843[_0xec87('0x30')],qs['fields'](_0x41c514[_0xec87('0x31')][_0xec87('0x35')]));_0x330baf['attributes']=_0x330baf[_0xec87('0x34')][_0xec87('0x36')]?_0x330baf[_0xec87('0x34')]:_0x544843[_0xec87('0x30')];if(!_0x41c514[_0xec87('0x31')]['hasOwnProperty']('nolimit')){_0x330baf[_0xec87('0x1e')]=qs[_0xec87('0x1e')](_0x41c514[_0xec87('0x31')][_0xec87('0x1e')]);_0x330baf[_0xec87('0x1c')]=qs[_0xec87('0x1c')](_0x41c514[_0xec87('0x31')][_0xec87('0x1c')]);}_0x330baf[_0xec87('0x37')]=qs['sort'](_0x41c514[_0xec87('0x31')]['sort']);_0x330baf[_0xec87('0x38')]=qs['filters'](_[_0xec87('0x39')](_0x41c514[_0xec87('0x31')],_0x544843[_0xec87('0x32')]),_0x567013);if(_0x41c514['query'][_0xec87('0x3a')]){_0x330baf[_0xec87('0x38')]=_[_0xec87('0x3b')](_0x330baf[_0xec87('0x38')],{'$or':_['map'](_0x567013,function(_0x1c3eb2){if(_0x1c3eb2[_0xec87('0x2e')]!==_0xec87('0x3c')){var _0x434a5d={};_0x434a5d[_0x1c3eb2[_0xec87('0x28')]]={'$like':'%'+_0x41c514[_0xec87('0x31')][_0xec87('0x3a')]+'%'};return _0x434a5d;}})});}_0x330baf=_[_0xec87('0x3b')]({},_0x330baf,_0x41c514['options']);var _0x3bb3bd={'where':_0x330baf[_0xec87('0x38')]};return db[_0xec87('0x2b')][_0xec87('0x3d')](_0x3bb3bd)[_0xec87('0x24')](function(_0x163c1d){_0x57c727[_0xec87('0x3d')]=_0x163c1d;if(_0x41c514[_0xec87('0x31')][_0xec87('0x3e')]){_0x330baf[_0xec87('0x3f')]=[{'all':!![]}];}return db['Dynamics365Configuration'][_0xec87('0x40')](_0x330baf);})[_0xec87('0x24')](function(_0x5670b1){_0x57c727[_0xec87('0x41')]=_0x5670b1;return _0x57c727;})[_0xec87('0x24')](respondWithFilteredResult(_0x111e2c,_0x330baf))[_0xec87('0x42')](handleError(_0x111e2c,null));};exports[_0xec87('0x43')]=function(_0x5ec9d5,_0x1d4579){var _0x58784a={'raw':![],'where':{'id':_0x5ec9d5[_0xec87('0x44')]['id']}},_0x33f4a8={};_0x33f4a8[_0xec87('0x30')]=_[_0xec87('0x45')](db[_0xec87('0x2b')][_0xec87('0x2c')]);_0x33f4a8['query']=_[_0xec87('0x45')](_0x5ec9d5[_0xec87('0x31')]);_0x33f4a8[_0xec87('0x32')]=_[_0xec87('0x33')](_0x33f4a8[_0xec87('0x30')],_0x33f4a8[_0xec87('0x31')]);_0x58784a['attributes']=_[_0xec87('0x33')](_0x33f4a8[_0xec87('0x30')],qs['fields'](_0x5ec9d5[_0xec87('0x31')][_0xec87('0x35')]));_0x58784a[_0xec87('0x34')]=_0x58784a[_0xec87('0x34')][_0xec87('0x36')]?_0x58784a['attributes']:_0x33f4a8[_0xec87('0x30')];if(_0x5ec9d5['query']['includeAll']){_0x58784a[_0xec87('0x3f')]=[{'all':!![]}];}_0x58784a=_['merge']({},_0x58784a,_0x5ec9d5[_0xec87('0x46')]);return db[_0xec87('0x2b')][_0xec87('0x47')](_0x58784a)[_0xec87('0x24')](handleEntityNotFound(_0x1d4579,null))['then'](respondWithResult(_0x1d4579,null))[_0xec87('0x42')](handleError(_0x1d4579,null));};exports[_0xec87('0x48')]=function(_0x471209,_0x45b514){return db[_0xec87('0x2b')]['create'](_0x471209['body'],{})[_0xec87('0x24')](respondWithResult(_0x45b514,0xc9))[_0xec87('0x42')](handleError(_0x45b514,null));};exports['update']=function(_0x5217fd,_0x1cc023){if(_0x5217fd['body']['id']){delete _0x5217fd[_0xec87('0x49')]['id'];}return db[_0xec87('0x2b')][_0xec87('0x47')]({'where':{'id':_0x5217fd[_0xec87('0x44')]['id']}})[_0xec87('0x24')](handleEntityNotFound(_0x1cc023,null))['then'](saveUpdates(_0x5217fd[_0xec87('0x49')],null))[_0xec87('0x24')](respondWithResult(_0x1cc023,null))[_0xec87('0x42')](handleError(_0x1cc023,null));};exports[_0xec87('0x4a')]=function(_0x3c616a,_0x457292){return db[_0xec87('0x2b')]['find']({'where':{'id':_0x3c616a[_0xec87('0x44')]['id']}})[_0xec87('0x24')](handleEntityNotFound(_0x457292,null))[_0xec87('0x24')](removeEntity(_0x457292,null))[_0xec87('0x42')](handleError(_0x457292,null));};exports[_0xec87('0x4b')]=function(_0x3e01be,_0x242ee9,_0xfd19a){var _0x8f9074={};var _0x218bab={};var _0x554305;var _0x3ca6b0;return db[_0xec87('0x2b')]['findOne']({'where':{'id':_0x3e01be[_0xec87('0x44')]['id']}})['then'](handleEntityNotFound(_0x242ee9,null))[_0xec87('0x24')](function(_0xc5aaf8){if(_0xc5aaf8){_0x554305=_0xc5aaf8;_0x218bab[_0xec87('0x30')]=_[_0xec87('0x45')](db[_0xec87('0x4c')][_0xec87('0x2c')]);_0x218bab[_0xec87('0x31')]=_[_0xec87('0x45')](_0x3e01be['query']);_0x218bab['filters']=_[_0xec87('0x33')](_0x218bab['model'],_0x218bab[_0xec87('0x31')]);_0x8f9074[_0xec87('0x34')]=_[_0xec87('0x33')](_0x218bab[_0xec87('0x30')],qs[_0xec87('0x35')](_0x3e01be[_0xec87('0x31')][_0xec87('0x35')]));_0x8f9074['attributes']=_0x8f9074['attributes'][_0xec87('0x36')]?_0x8f9074[_0xec87('0x34')]:_0x218bab['model'];_0x8f9074[_0xec87('0x37')]=qs[_0xec87('0x4d')](_0x3e01be[_0xec87('0x31')][_0xec87('0x4d')]);_0x8f9074[_0xec87('0x38')]=qs[_0xec87('0x32')](_[_0xec87('0x39')](_0x3e01be[_0xec87('0x31')],_0x218bab[_0xec87('0x32')]));if(_0x3e01be[_0xec87('0x31')]['filter']){_0x8f9074[_0xec87('0x38')]=_['merge'](_0x8f9074[_0xec87('0x38')],{'$or':_['map'](_0x8f9074['attributes'],function(_0x2c4735){var _0xaa9217={};_0xaa9217[_0x2c4735]={'$like':'%'+_0x3e01be['query'][_0xec87('0x3a')]+'%'};return _0xaa9217;})});}_0x8f9074=_[_0xec87('0x3b')]({},_0x8f9074,_0x3e01be[_0xec87('0x46')]);return _0x554305[_0xec87('0x4b')](_0x8f9074);}})[_0xec87('0x24')](function(_0x46b26d){if(_0x46b26d){_0x3ca6b0=_0x46b26d[_0xec87('0x36')];if(!_0x3e01be['query'][_0xec87('0x4e')]('nolimit')){_0x8f9074[_0xec87('0x1e')]=qs['limit'](_0x3e01be['query'][_0xec87('0x1e')]);_0x8f9074[_0xec87('0x1c')]=qs[_0xec87('0x1c')](_0x3e01be[_0xec87('0x31')][_0xec87('0x1c')]);}return _0x554305[_0xec87('0x4b')](_0x8f9074);}})[_0xec87('0x24')](function(_0x1b388f){if(_0x1b388f){return _0x1b388f?{'count':_0x3ca6b0,'rows':_0x1b388f}:null;}})[_0xec87('0x24')](respondWithResult(_0x242ee9,null))[_0xec87('0x42')](handleError(_0x242ee9,null));};exports[_0xec87('0x4f')]=function(_0x8e657c,_0xc803df,_0x1ab586){var _0x481927={};var _0x349c7e={};var _0xed33e6;var _0x343846;return db['Dynamics365Configuration'][_0xec87('0x50')]({'where':{'id':_0x8e657c[_0xec87('0x44')]['id']}})['then'](handleEntityNotFound(_0xc803df,null))['then'](function(_0x5da873){if(_0x5da873){_0xed33e6=_0x5da873;_0x349c7e[_0xec87('0x30')]=_['keys'](db['Dynamics365Field'][_0xec87('0x2c')]);_0x349c7e[_0xec87('0x31')]=_[_0xec87('0x45')](_0x8e657c[_0xec87('0x31')]);_0x349c7e[_0xec87('0x32')]=_[_0xec87('0x33')](_0x349c7e[_0xec87('0x30')],_0x349c7e[_0xec87('0x31')]);_0x481927['attributes']=_[_0xec87('0x33')](_0x349c7e['model'],qs['fields'](_0x8e657c[_0xec87('0x31')][_0xec87('0x35')]));_0x481927[_0xec87('0x34')]=_0x481927[_0xec87('0x34')][_0xec87('0x36')]?_0x481927[_0xec87('0x34')]:_0x349c7e[_0xec87('0x30')];_0x481927[_0xec87('0x37')]=qs[_0xec87('0x4d')](_0x8e657c[_0xec87('0x31')][_0xec87('0x4d')]);_0x481927[_0xec87('0x38')]=qs[_0xec87('0x32')](_[_0xec87('0x39')](_0x8e657c[_0xec87('0x31')],_0x349c7e['filters']));if(_0x8e657c[_0xec87('0x31')][_0xec87('0x3a')]){_0x481927[_0xec87('0x38')]=_[_0xec87('0x3b')](_0x481927['where'],{'$or':_[_0xec87('0x2a')](_0x481927['attributes'],function(_0x3bfcee){var _0x2ea778={};_0x2ea778[_0x3bfcee]={'$like':'%'+_0x8e657c['query'][_0xec87('0x3a')]+'%'};return _0x2ea778;})});}_0x481927=_[_0xec87('0x3b')]({},_0x481927,_0x8e657c[_0xec87('0x46')]);return _0xed33e6['getSubjects'](_0x481927);}})[_0xec87('0x24')](function(_0x406c5e){if(_0x406c5e){_0x343846=_0x406c5e['length'];if(!_0x8e657c['query'][_0xec87('0x4e')]('nolimit')){_0x481927[_0xec87('0x1e')]=qs[_0xec87('0x1e')](_0x8e657c[_0xec87('0x31')][_0xec87('0x1e')]);_0x481927['offset']=qs['offset'](_0x8e657c[_0xec87('0x31')][_0xec87('0x1c')]);}return _0xed33e6[_0xec87('0x4f')](_0x481927);}})['then'](function(_0x2f083c){if(_0x2f083c){return _0x2f083c?{'count':_0x343846,'rows':_0x2f083c}:null;}})[_0xec87('0x24')](respondWithResult(_0xc803df,null))['catch'](handleError(_0xc803df,null));};exports[_0xec87('0x51')]=function(_0x47b124,_0x867a1c,_0x598410){var _0x5c405f={};var _0x5b8850={};var _0x56142f;var _0x527663;return db['Dynamics365Configuration']['findOne']({'where':{'id':_0x47b124[_0xec87('0x44')]['id']}})['then'](handleEntityNotFound(_0x867a1c,null))[_0xec87('0x24')](function(_0x5c0c7c){if(_0x5c0c7c){_0x56142f=_0x5c0c7c;_0x5b8850[_0xec87('0x30')]=_['keys'](db['Dynamics365Field'][_0xec87('0x2c')]);_0x5b8850[_0xec87('0x31')]=_[_0xec87('0x45')](_0x47b124[_0xec87('0x31')]);_0x5b8850[_0xec87('0x32')]=_['intersection'](_0x5b8850[_0xec87('0x30')],_0x5b8850[_0xec87('0x31')]);_0x5c405f[_0xec87('0x34')]=_['intersection'](_0x5b8850['model'],qs[_0xec87('0x35')](_0x47b124[_0xec87('0x31')][_0xec87('0x35')]));_0x5c405f['attributes']=_0x5c405f[_0xec87('0x34')][_0xec87('0x36')]?_0x5c405f[_0xec87('0x34')]:_0x5b8850['model'];_0x5c405f['order']=qs['sort'](_0x47b124['query'][_0xec87('0x4d')]);_0x5c405f[_0xec87('0x38')]=qs[_0xec87('0x32')](_['pick'](_0x47b124[_0xec87('0x31')],_0x5b8850[_0xec87('0x32')]));if(_0x47b124[_0xec87('0x31')][_0xec87('0x3a')]){_0x5c405f[_0xec87('0x38')]=_[_0xec87('0x3b')](_0x5c405f[_0xec87('0x38')],{'$or':_[_0xec87('0x2a')](_0x5c405f[_0xec87('0x34')],function(_0x4cecae){var _0x4b366a={};_0x4b366a[_0x4cecae]={'$like':'%'+_0x47b124[_0xec87('0x31')][_0xec87('0x3a')]+'%'};return _0x4b366a;})});}_0x5c405f=_[_0xec87('0x3b')]({},_0x5c405f,_0x47b124[_0xec87('0x46')]);return _0x56142f['getDescriptions'](_0x5c405f);}})[_0xec87('0x24')](function(_0x2bbf9f){if(_0x2bbf9f){_0x527663=_0x2bbf9f[_0xec87('0x36')];if(!_0x47b124[_0xec87('0x31')][_0xec87('0x4e')](_0xec87('0x52'))){_0x5c405f['limit']=qs[_0xec87('0x1e')](_0x47b124[_0xec87('0x31')][_0xec87('0x1e')]);_0x5c405f[_0xec87('0x1c')]=qs[_0xec87('0x1c')](_0x47b124[_0xec87('0x31')][_0xec87('0x1c')]);}return _0x56142f[_0xec87('0x51')](_0x5c405f);}})[_0xec87('0x24')](function(_0x1ced67){if(_0x1ced67){return _0x1ced67?{'count':_0x527663,'rows':_0x1ced67}:null;}})[_0xec87('0x24')](respondWithResult(_0x867a1c,null))[_0xec87('0x42')](handleError(_0x867a1c,null));};