Built motion from commit bab6f49e.|2.6.17
[motion2.git] / server / api / intServicenowConfiguration / intServicenowConfiguration.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 _0x6e4d=['query','filters','attributes','intersection','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','type','VIRTUAL','options','catch','show','params','includeAll','include','create','update','body','destroy','find','getFields','findOne','getSubjects','getDescriptions','ServicenowField','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/environment','../../mysqldb','sendStatus','status','offset','undefined','limit','count','set','Content-Range','json','apply','reject','save','then','end','error','stack','name','send','index','ServicenowConfiguration','rawAttributes','fieldName','key','model','map','keys'];(function(_0x476a89,_0x2a2c36){var _0x387d92=function(_0x4472f8){while(--_0x4472f8){_0x476a89['push'](_0x476a89['shift']());}};_0x387d92(++_0x2a2c36);}(_0x6e4d,0xc4));var _0xd6e4=function(_0x29703e,_0x1272b9){_0x29703e=_0x29703e-0x0;var _0x4f7985=_0x6e4d[_0x29703e];return _0x4f7985;};'use strict';var emlformat=require(_0xd6e4('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xd6e4('0x1'));var jsonpatch=require(_0xd6e4('0x2'));var rp=require(_0xd6e4('0x3'));var moment=require(_0xd6e4('0x4'));var BPromise=require(_0xd6e4('0x5'));var Mustache=require('mustache');var util=require(_0xd6e4('0x6'));var path=require(_0xd6e4('0x7'));var sox=require(_0xd6e4('0x8'));var csv=require(_0xd6e4('0x9'));var ejs=require(_0xd6e4('0xa'));var fs=require('fs');var fs_extra=require(_0xd6e4('0xb'));var _=require(_0xd6e4('0xc'));var squel=require(_0xd6e4('0xd'));var crypto=require('crypto');var jsforce=require(_0xd6e4('0xe'));var deskjs=require(_0xd6e4('0xf'));var toCsv=require(_0xd6e4('0x9'));var querystring=require(_0xd6e4('0x10'));var Papa=require(_0xd6e4('0x11'));var Redis=require(_0xd6e4('0x12'));var authService=require(_0xd6e4('0x13'));var qs=require('../../components/parsers/qs');var as=require(_0xd6e4('0x14'));var hardwareService=require(_0xd6e4('0x15'));var logger=require('../../config/logger')('api');var utils=require('../../config/utils');var config=require(_0xd6e4('0x16'));var licenseUtil=require('../../config/license/util');var db=require(_0xd6e4('0x17'))['db'];function respondWithStatusCode(_0x32c12a,_0x2ded47){_0x2ded47=_0x2ded47||0xcc;return function(_0x30fe13){if(_0x30fe13){return _0x32c12a[_0xd6e4('0x18')](_0x2ded47);}return _0x32c12a[_0xd6e4('0x19')](_0x2ded47)['end']();};}function respondWithResult(_0x179024,_0x2d8709){_0x2d8709=_0x2d8709||0xc8;return function(_0x381d62){if(_0x381d62){return _0x179024[_0xd6e4('0x19')](_0x2d8709)['json'](_0x381d62);}};}function respondWithFilteredResult(_0x5cd425,_0x304add){return function(_0x1da084){if(_0x1da084){var _0x1e053c=typeof _0x304add[_0xd6e4('0x1a')]===_0xd6e4('0x1b')&&typeof _0x304add[_0xd6e4('0x1c')]===_0xd6e4('0x1b');var _0x2ace09=_0x1da084[_0xd6e4('0x1d')];var _0x1c94db=_0x1e053c?0x0:_0x304add[_0xd6e4('0x1a')];var _0x121830=_0x1e053c?_0x1da084['count']:_0x304add['offset']+_0x304add[_0xd6e4('0x1c')];var _0x180396;if(_0x121830>=_0x2ace09){_0x121830=_0x2ace09;_0x180396=0xc8;}else{_0x180396=0xce;}_0x5cd425[_0xd6e4('0x19')](_0x180396);return _0x5cd425[_0xd6e4('0x1e')](_0xd6e4('0x1f'),_0x1c94db+'-'+_0x121830+'/'+_0x2ace09)[_0xd6e4('0x20')](_0x1da084);}return null;};}function patchUpdates(_0x3dd4f3){return function(_0x393481){try{jsonpatch[_0xd6e4('0x21')](_0x393481,_0x3dd4f3,!![]);}catch(_0x4b711f){return BPromise[_0xd6e4('0x22')](_0x4b711f);}return _0x393481[_0xd6e4('0x23')]();};}function saveUpdates(_0x548125,_0xc2952e){return function(_0x54afcd){if(_0x54afcd){return _0x54afcd['update'](_0x548125)[_0xd6e4('0x24')](function(_0x25a9a7){return _0x25a9a7;});}return null;};}function removeEntity(_0xcae186,_0xdcee2c){return function(_0x4a415f){if(_0x4a415f){return _0x4a415f['destroy']()[_0xd6e4('0x24')](function(){_0xcae186[_0xd6e4('0x19')](0xcc)[_0xd6e4('0x25')]();});}};}function handleEntityNotFound(_0x12212f,_0x1091a0){return function(_0x44cf21){if(!_0x44cf21){_0x12212f[_0xd6e4('0x18')](0x194);}return _0x44cf21;};}function handleError(_0x320297,_0x151f1d){_0x151f1d=_0x151f1d||0x1f4;return function(_0x9cf75e){logger[_0xd6e4('0x26')](_0x9cf75e[_0xd6e4('0x27')]);if(_0x9cf75e[_0xd6e4('0x28')]){delete _0x9cf75e[_0xd6e4('0x28')];}_0x320297[_0xd6e4('0x19')](_0x151f1d)[_0xd6e4('0x29')](_0x9cf75e);};}exports[_0xd6e4('0x2a')]=function(_0x2cb76e,_0x15ec44){var _0x3bdaf1={},_0x5e58eb={},_0x527431={'count':0x0,'rows':[]};var _0x1d1a2c=_['map'](db[_0xd6e4('0x2b')][_0xd6e4('0x2c')],function(_0x52c77e){return{'name':_0x52c77e[_0xd6e4('0x2d')],'type':_0x52c77e['type'][_0xd6e4('0x2e')]};});_0x5e58eb[_0xd6e4('0x2f')]=_[_0xd6e4('0x30')](_0x1d1a2c,_0xd6e4('0x28'));_0x5e58eb['query']=_[_0xd6e4('0x31')](_0x2cb76e[_0xd6e4('0x32')]);_0x5e58eb[_0xd6e4('0x33')]=_['intersection'](_0x5e58eb[_0xd6e4('0x2f')],_0x5e58eb[_0xd6e4('0x32')]);_0x3bdaf1[_0xd6e4('0x34')]=_[_0xd6e4('0x35')](_0x5e58eb['model'],qs[_0xd6e4('0x36')](_0x2cb76e[_0xd6e4('0x32')][_0xd6e4('0x36')]));_0x3bdaf1['attributes']=_0x3bdaf1['attributes'][_0xd6e4('0x37')]?_0x3bdaf1[_0xd6e4('0x34')]:_0x5e58eb['model'];if(!_0x2cb76e[_0xd6e4('0x32')][_0xd6e4('0x38')](_0xd6e4('0x39'))){_0x3bdaf1['limit']=qs[_0xd6e4('0x1c')](_0x2cb76e[_0xd6e4('0x32')][_0xd6e4('0x1c')]);_0x3bdaf1[_0xd6e4('0x1a')]=qs['offset'](_0x2cb76e['query'][_0xd6e4('0x1a')]);}_0x3bdaf1[_0xd6e4('0x3a')]=qs['sort'](_0x2cb76e[_0xd6e4('0x32')][_0xd6e4('0x3b')]);_0x3bdaf1[_0xd6e4('0x3c')]=qs[_0xd6e4('0x33')](_[_0xd6e4('0x3d')](_0x2cb76e[_0xd6e4('0x32')],_0x5e58eb[_0xd6e4('0x33')]),_0x1d1a2c);if(_0x2cb76e[_0xd6e4('0x32')][_0xd6e4('0x3e')]){_0x3bdaf1[_0xd6e4('0x3c')]=_[_0xd6e4('0x3f')](_0x3bdaf1[_0xd6e4('0x3c')],{'$or':_[_0xd6e4('0x30')](_0x1d1a2c,function(_0x43f73f){if(_0x43f73f[_0xd6e4('0x40')]!==_0xd6e4('0x41')){var _0x5a252e={};_0x5a252e[_0x43f73f[_0xd6e4('0x28')]]={'$like':'%'+_0x2cb76e[_0xd6e4('0x32')][_0xd6e4('0x3e')]+'%'};return _0x5a252e;}})});}_0x3bdaf1=_[_0xd6e4('0x3f')]({},_0x3bdaf1,_0x2cb76e[_0xd6e4('0x42')]);var _0x19d507={'where':_0x3bdaf1[_0xd6e4('0x3c')]};return db[_0xd6e4('0x2b')][_0xd6e4('0x1d')](_0x19d507)[_0xd6e4('0x24')](function(_0x8a2f8b){_0x527431[_0xd6e4('0x1d')]=_0x8a2f8b;if(_0x2cb76e[_0xd6e4('0x32')]['includeAll']){_0x3bdaf1['include']=[{'all':!![]}];}return db[_0xd6e4('0x2b')]['findAll'](_0x3bdaf1);})[_0xd6e4('0x24')](function(_0xb6ac4c){_0x527431['rows']=_0xb6ac4c;return _0x527431;})['then'](respondWithFilteredResult(_0x15ec44,_0x3bdaf1))[_0xd6e4('0x43')](handleError(_0x15ec44,null));};exports[_0xd6e4('0x44')]=function(_0x49341a,_0x382e14){var _0x1e8fce={'raw':![],'where':{'id':_0x49341a[_0xd6e4('0x45')]['id']}},_0x24d5b={};_0x24d5b[_0xd6e4('0x2f')]=_[_0xd6e4('0x31')](db[_0xd6e4('0x2b')][_0xd6e4('0x2c')]);_0x24d5b[_0xd6e4('0x32')]=_[_0xd6e4('0x31')](_0x49341a[_0xd6e4('0x32')]);_0x24d5b['filters']=_['intersection'](_0x24d5b[_0xd6e4('0x2f')],_0x24d5b[_0xd6e4('0x32')]);_0x1e8fce['attributes']=_[_0xd6e4('0x35')](_0x24d5b['model'],qs[_0xd6e4('0x36')](_0x49341a[_0xd6e4('0x32')]['fields']));_0x1e8fce['attributes']=_0x1e8fce[_0xd6e4('0x34')]['length']?_0x1e8fce['attributes']:_0x24d5b['model'];if(_0x49341a[_0xd6e4('0x32')][_0xd6e4('0x46')]){_0x1e8fce[_0xd6e4('0x47')]=[{'all':!![]}];}_0x1e8fce=_[_0xd6e4('0x3f')]({},_0x1e8fce,_0x49341a['options']);return db[_0xd6e4('0x2b')]['find'](_0x1e8fce)['then'](handleEntityNotFound(_0x382e14,null))[_0xd6e4('0x24')](respondWithResult(_0x382e14,null))['catch'](handleError(_0x382e14,null));};exports[_0xd6e4('0x48')]=function(_0x23c969,_0x2e22ca){return db['ServicenowConfiguration'][_0xd6e4('0x48')](_0x23c969['body'],{})[_0xd6e4('0x24')](respondWithResult(_0x2e22ca,0xc9))[_0xd6e4('0x43')](handleError(_0x2e22ca,null));};exports[_0xd6e4('0x49')]=function(_0xeb15cb,_0x5500e6){if(_0xeb15cb[_0xd6e4('0x4a')]['id']){delete _0xeb15cb[_0xd6e4('0x4a')]['id'];}return db[_0xd6e4('0x2b')]['find']({'where':{'id':_0xeb15cb[_0xd6e4('0x45')]['id']}})[_0xd6e4('0x24')](handleEntityNotFound(_0x5500e6,null))['then'](saveUpdates(_0xeb15cb[_0xd6e4('0x4a')],null))[_0xd6e4('0x24')](respondWithResult(_0x5500e6,null))[_0xd6e4('0x43')](handleError(_0x5500e6,null));};exports[_0xd6e4('0x4b')]=function(_0x66f4be,_0x5b3afd){return db['ServicenowConfiguration'][_0xd6e4('0x4c')]({'where':{'id':_0x66f4be['params']['id']}})[_0xd6e4('0x24')](handleEntityNotFound(_0x5b3afd,null))['then'](removeEntity(_0x5b3afd,null))[_0xd6e4('0x43')](handleError(_0x5b3afd,null));};exports[_0xd6e4('0x4d')]=function(_0x3589ab,_0x5ffb96,_0x134a1c){var _0x1c1be2={};var _0x48010b={};var _0x152322;var _0x407785;return db[_0xd6e4('0x2b')][_0xd6e4('0x4e')]({'where':{'id':_0x3589ab[_0xd6e4('0x45')]['id']}})[_0xd6e4('0x24')](handleEntityNotFound(_0x5ffb96,null))['then'](function(_0x210411){if(_0x210411){_0x152322=_0x210411;_0x48010b[_0xd6e4('0x2f')]=_[_0xd6e4('0x31')](db['ServicenowField'][_0xd6e4('0x2c')]);_0x48010b[_0xd6e4('0x32')]=_[_0xd6e4('0x31')](_0x3589ab[_0xd6e4('0x32')]);_0x48010b[_0xd6e4('0x33')]=_[_0xd6e4('0x35')](_0x48010b['model'],_0x48010b[_0xd6e4('0x32')]);_0x1c1be2[_0xd6e4('0x34')]=_['intersection'](_0x48010b[_0xd6e4('0x2f')],qs[_0xd6e4('0x36')](_0x3589ab[_0xd6e4('0x32')][_0xd6e4('0x36')]));_0x1c1be2[_0xd6e4('0x34')]=_0x1c1be2[_0xd6e4('0x34')][_0xd6e4('0x37')]?_0x1c1be2[_0xd6e4('0x34')]:_0x48010b['model'];_0x1c1be2[_0xd6e4('0x3a')]=qs[_0xd6e4('0x3b')](_0x3589ab[_0xd6e4('0x32')][_0xd6e4('0x3b')]);_0x1c1be2['where']=qs[_0xd6e4('0x33')](_[_0xd6e4('0x3d')](_0x3589ab['query'],_0x48010b[_0xd6e4('0x33')]));if(_0x3589ab['query']['filter']){_0x1c1be2[_0xd6e4('0x3c')]=_[_0xd6e4('0x3f')](_0x1c1be2['where'],{'$or':_[_0xd6e4('0x30')](_0x1c1be2[_0xd6e4('0x34')],function(_0x376ab0){var _0x52355a={};_0x52355a[_0x376ab0]={'$like':'%'+_0x3589ab[_0xd6e4('0x32')][_0xd6e4('0x3e')]+'%'};return _0x52355a;})});}_0x1c1be2=_[_0xd6e4('0x3f')]({},_0x1c1be2,_0x3589ab[_0xd6e4('0x42')]);return _0x152322[_0xd6e4('0x4d')](_0x1c1be2);}})['then'](function(_0x158e2d){if(_0x158e2d){_0x407785=_0x158e2d[_0xd6e4('0x37')];if(!_0x3589ab[_0xd6e4('0x32')][_0xd6e4('0x38')]('nolimit')){_0x1c1be2['limit']=qs['limit'](_0x3589ab['query'][_0xd6e4('0x1c')]);_0x1c1be2[_0xd6e4('0x1a')]=qs['offset'](_0x3589ab[_0xd6e4('0x32')][_0xd6e4('0x1a')]);}return _0x152322[_0xd6e4('0x4d')](_0x1c1be2);}})[_0xd6e4('0x24')](function(_0x29806d){if(_0x29806d){return _0x29806d?{'count':_0x407785,'rows':_0x29806d}:null;}})['then'](respondWithResult(_0x5ffb96,null))[_0xd6e4('0x43')](handleError(_0x5ffb96,null));};exports['getSubjects']=function(_0x17fd1e,_0x43cbb9,_0x5e1edd){var _0x515648={};var _0x4785ff={};var _0xf9ed3;var _0x2efd73;return db[_0xd6e4('0x2b')][_0xd6e4('0x4e')]({'where':{'id':_0x17fd1e[_0xd6e4('0x45')]['id']}})[_0xd6e4('0x24')](handleEntityNotFound(_0x43cbb9,null))['then'](function(_0x4514f0){if(_0x4514f0){_0xf9ed3=_0x4514f0;_0x4785ff['model']=_['keys'](db['ServicenowField'][_0xd6e4('0x2c')]);_0x4785ff['query']=_['keys'](_0x17fd1e[_0xd6e4('0x32')]);_0x4785ff[_0xd6e4('0x33')]=_[_0xd6e4('0x35')](_0x4785ff[_0xd6e4('0x2f')],_0x4785ff[_0xd6e4('0x32')]);_0x515648['attributes']=_[_0xd6e4('0x35')](_0x4785ff[_0xd6e4('0x2f')],qs[_0xd6e4('0x36')](_0x17fd1e['query'][_0xd6e4('0x36')]));_0x515648[_0xd6e4('0x34')]=_0x515648[_0xd6e4('0x34')][_0xd6e4('0x37')]?_0x515648[_0xd6e4('0x34')]:_0x4785ff[_0xd6e4('0x2f')];_0x515648[_0xd6e4('0x3a')]=qs['sort'](_0x17fd1e[_0xd6e4('0x32')][_0xd6e4('0x3b')]);_0x515648[_0xd6e4('0x3c')]=qs[_0xd6e4('0x33')](_['pick'](_0x17fd1e[_0xd6e4('0x32')],_0x4785ff['filters']));if(_0x17fd1e[_0xd6e4('0x32')][_0xd6e4('0x3e')]){_0x515648[_0xd6e4('0x3c')]=_[_0xd6e4('0x3f')](_0x515648[_0xd6e4('0x3c')],{'$or':_[_0xd6e4('0x30')](_0x515648['attributes'],function(_0x41481d){var _0x7343ce={};_0x7343ce[_0x41481d]={'$like':'%'+_0x17fd1e[_0xd6e4('0x32')][_0xd6e4('0x3e')]+'%'};return _0x7343ce;})});}_0x515648=_[_0xd6e4('0x3f')]({},_0x515648,_0x17fd1e[_0xd6e4('0x42')]);return _0xf9ed3[_0xd6e4('0x4f')](_0x515648);}})[_0xd6e4('0x24')](function(_0x55bd8a){if(_0x55bd8a){_0x2efd73=_0x55bd8a[_0xd6e4('0x37')];if(!_0x17fd1e[_0xd6e4('0x32')][_0xd6e4('0x38')](_0xd6e4('0x39'))){_0x515648[_0xd6e4('0x1c')]=qs['limit'](_0x17fd1e['query'][_0xd6e4('0x1c')]);_0x515648['offset']=qs[_0xd6e4('0x1a')](_0x17fd1e[_0xd6e4('0x32')]['offset']);}return _0xf9ed3[_0xd6e4('0x4f')](_0x515648);}})[_0xd6e4('0x24')](function(_0x329338){if(_0x329338){return _0x329338?{'count':_0x2efd73,'rows':_0x329338}:null;}})[_0xd6e4('0x24')](respondWithResult(_0x43cbb9,null))[_0xd6e4('0x43')](handleError(_0x43cbb9,null));};exports[_0xd6e4('0x50')]=function(_0x585a94,_0x444f6b,_0x533840){var _0x150c0a={};var _0x2c0083={};var _0x3a23b1;var _0x33183f;return db[_0xd6e4('0x2b')][_0xd6e4('0x4e')]({'where':{'id':_0x585a94[_0xd6e4('0x45')]['id']}})['then'](handleEntityNotFound(_0x444f6b,null))['then'](function(_0x5ef8e5){if(_0x5ef8e5){_0x3a23b1=_0x5ef8e5;_0x2c0083[_0xd6e4('0x2f')]=_[_0xd6e4('0x31')](db[_0xd6e4('0x51')]['rawAttributes']);_0x2c0083[_0xd6e4('0x32')]=_[_0xd6e4('0x31')](_0x585a94['query']);_0x2c0083[_0xd6e4('0x33')]=_[_0xd6e4('0x35')](_0x2c0083[_0xd6e4('0x2f')],_0x2c0083['query']);_0x150c0a[_0xd6e4('0x34')]=_[_0xd6e4('0x35')](_0x2c0083[_0xd6e4('0x2f')],qs[_0xd6e4('0x36')](_0x585a94[_0xd6e4('0x32')]['fields']));_0x150c0a[_0xd6e4('0x34')]=_0x150c0a[_0xd6e4('0x34')][_0xd6e4('0x37')]?_0x150c0a[_0xd6e4('0x34')]:_0x2c0083['model'];_0x150c0a['order']=qs['sort'](_0x585a94[_0xd6e4('0x32')][_0xd6e4('0x3b')]);_0x150c0a['where']=qs['filters'](_[_0xd6e4('0x3d')](_0x585a94['query'],_0x2c0083['filters']));if(_0x585a94['query'][_0xd6e4('0x3e')]){_0x150c0a['where']=_[_0xd6e4('0x3f')](_0x150c0a[_0xd6e4('0x3c')],{'$or':_['map'](_0x150c0a[_0xd6e4('0x34')],function(_0x2d5434){var _0x1a8e09={};_0x1a8e09[_0x2d5434]={'$like':'%'+_0x585a94['query']['filter']+'%'};return _0x1a8e09;})});}_0x150c0a=_[_0xd6e4('0x3f')]({},_0x150c0a,_0x585a94[_0xd6e4('0x42')]);return _0x3a23b1['getDescriptions'](_0x150c0a);}})[_0xd6e4('0x24')](function(_0x3eb8f0){if(_0x3eb8f0){_0x33183f=_0x3eb8f0[_0xd6e4('0x37')];if(!_0x585a94[_0xd6e4('0x32')][_0xd6e4('0x38')](_0xd6e4('0x39'))){_0x150c0a[_0xd6e4('0x1c')]=qs[_0xd6e4('0x1c')](_0x585a94[_0xd6e4('0x32')][_0xd6e4('0x1c')]);_0x150c0a[_0xd6e4('0x1a')]=qs[_0xd6e4('0x1a')](_0x585a94[_0xd6e4('0x32')][_0xd6e4('0x1a')]);}return _0x3a23b1[_0xd6e4('0x50')](_0x150c0a);}})[_0xd6e4('0x24')](function(_0x530e01){if(_0x530e01){return _0x530e01?{'count':_0x33183f,'rows':_0x530e01}:null;}})[_0xd6e4('0x24')](respondWithResult(_0x444f6b,null))[_0xd6e4('0x43')](handleError(_0x444f6b,null));};