5e6dec144504da868b39029fbdf6882cb660aa80
[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 _0xab2b=['json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','then','destroy','sendStatus','error','stack','name','send','map','ServicenowConfiguration','rawAttributes','fieldName','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','order','pick','filter','where','merge','VIRTUAL','includeAll','findAll','catch','show','params','include','find','create','body','getFields','ServicenowField','sort','options','nolimit','getSubjects','findOne','getDescriptions','eml-format','fast-json-patch','request-promise','bluebird','mustache','sox','ejs','lodash','squel','crypto','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','end','status'];(function(_0x38a155,_0x2aa026){var _0x269403=function(_0x47263b){while(--_0x47263b){_0x38a155['push'](_0x38a155['shift']());}};_0x269403(++_0x2aa026);}(_0xab2b,0x121));var _0xbab2=function(_0x4fae1c,_0x10b84f){_0x4fae1c=_0x4fae1c-0x0;var _0x5a6d11=_0xab2b[_0x4fae1c];return _0x5a6d11;};'use strict';var emlformat=require(_0xbab2('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0xbab2('0x1'));var rp=require(_0xbab2('0x2'));var moment=require('moment');var BPromise=require(_0xbab2('0x3'));var Mustache=require(_0xbab2('0x4'));var util=require('util');var path=require('path');var sox=require(_0xbab2('0x5'));var csv=require('to-csv');var ejs=require(_0xbab2('0x6'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xbab2('0x7'));var squel=require(_0xbab2('0x8'));var crypto=require(_0xbab2('0x9'));var jsforce=require('jsforce');var deskjs=require(_0xbab2('0xa'));var toCsv=require('to-csv');var querystring=require(_0xbab2('0xb'));var Papa=require(_0xbab2('0xc'));var Redis=require('ioredis');var authService=require(_0xbab2('0xd'));var qs=require(_0xbab2('0xe'));var as=require(_0xbab2('0xf'));var hardwareService=require(_0xbab2('0x10'));var logger=require(_0xbab2('0x11'))('api');var utils=require(_0xbab2('0x12'));var config=require(_0xbab2('0x13'));var licenseUtil=require('../../config/license/util');var db=require(_0xbab2('0x14'))['db'];function respondWithStatusCode(_0x57c66c,_0x53f091){_0x53f091=_0x53f091||0xcc;return function(_0x1a56d0){if(_0x1a56d0){return _0x57c66c['sendStatus'](_0x53f091);}return _0x57c66c['status'](_0x53f091)[_0xbab2('0x15')]();};}function respondWithResult(_0x4fe5f9,_0x27f361){_0x27f361=_0x27f361||0xc8;return function(_0x246f76){if(_0x246f76){return _0x4fe5f9[_0xbab2('0x16')](_0x27f361)[_0xbab2('0x17')](_0x246f76);}};}function respondWithFilteredResult(_0x1f298d,_0x4b009a){return function(_0x91589){if(_0x91589){var _0x1c1b38=typeof _0x4b009a[_0xbab2('0x18')]===_0xbab2('0x19')&&typeof _0x4b009a[_0xbab2('0x1a')]==='undefined';var _0x1bfef8=_0x91589[_0xbab2('0x1b')];var _0x7e3703=_0x1c1b38?0x0:_0x4b009a[_0xbab2('0x18')];var _0x1c8f90=_0x1c1b38?_0x91589[_0xbab2('0x1b')]:_0x4b009a[_0xbab2('0x18')]+_0x4b009a[_0xbab2('0x1a')];var _0xdba931;if(_0x1c8f90>=_0x1bfef8){_0x1c8f90=_0x1bfef8;_0xdba931=0xc8;}else{_0xdba931=0xce;}_0x1f298d[_0xbab2('0x16')](_0xdba931);return _0x1f298d[_0xbab2('0x1c')](_0xbab2('0x1d'),_0x7e3703+'-'+_0x1c8f90+'/'+_0x1bfef8)[_0xbab2('0x17')](_0x91589);}return null;};}function patchUpdates(_0x2f1f7a){return function(_0x222497){try{jsonpatch[_0xbab2('0x1e')](_0x222497,_0x2f1f7a,!![]);}catch(_0x32ddc1){return BPromise[_0xbab2('0x1f')](_0x32ddc1);}return _0x222497[_0xbab2('0x20')]();};}function saveUpdates(_0x51ac78,_0x3e3035){return function(_0x3dd809){if(_0x3dd809){return _0x3dd809[_0xbab2('0x21')](_0x51ac78)[_0xbab2('0x22')](function(_0x878b02){return _0x878b02;});}return null;};}function removeEntity(_0x4d0a55,_0x4c831e){return function(_0x57695b){if(_0x57695b){return _0x57695b[_0xbab2('0x23')]()[_0xbab2('0x22')](function(){_0x4d0a55[_0xbab2('0x16')](0xcc)[_0xbab2('0x15')]();});}};}function handleEntityNotFound(_0xe85805,_0x11ac7f){return function(_0x2fab37){if(!_0x2fab37){_0xe85805[_0xbab2('0x24')](0x194);}return _0x2fab37;};}function handleError(_0x2ada9f,_0x1d515b){_0x1d515b=_0x1d515b||0x1f4;return function(_0x3c5510){logger[_0xbab2('0x25')](_0x3c5510[_0xbab2('0x26')]);if(_0x3c5510[_0xbab2('0x27')]){delete _0x3c5510[_0xbab2('0x27')];}_0x2ada9f[_0xbab2('0x16')](_0x1d515b)[_0xbab2('0x28')](_0x3c5510);};}exports['index']=function(_0x54fdb1,_0x1b77d0){var _0x11e519={},_0x3bdc48={},_0x460ee5={'count':0x0,'rows':[]};var _0x364d23=_[_0xbab2('0x29')](db[_0xbab2('0x2a')][_0xbab2('0x2b')],function(_0x160a52){return{'name':_0x160a52[_0xbab2('0x2c')],'type':_0x160a52['type'][_0xbab2('0x2d')]};});_0x3bdc48[_0xbab2('0x2e')]=_[_0xbab2('0x29')](_0x364d23,_0xbab2('0x27'));_0x3bdc48[_0xbab2('0x2f')]=_[_0xbab2('0x30')](_0x54fdb1[_0xbab2('0x2f')]);_0x3bdc48[_0xbab2('0x31')]=_[_0xbab2('0x32')](_0x3bdc48[_0xbab2('0x2e')],_0x3bdc48['query']);_0x11e519[_0xbab2('0x33')]=_[_0xbab2('0x32')](_0x3bdc48[_0xbab2('0x2e')],qs[_0xbab2('0x34')](_0x54fdb1[_0xbab2('0x2f')][_0xbab2('0x34')]));_0x11e519[_0xbab2('0x33')]=_0x11e519[_0xbab2('0x33')][_0xbab2('0x35')]?_0x11e519[_0xbab2('0x33')]:_0x3bdc48[_0xbab2('0x2e')];if(!_0x54fdb1[_0xbab2('0x2f')][_0xbab2('0x36')]('nolimit')){_0x11e519[_0xbab2('0x1a')]=qs[_0xbab2('0x1a')](_0x54fdb1[_0xbab2('0x2f')][_0xbab2('0x1a')]);_0x11e519[_0xbab2('0x18')]=qs['offset'](_0x54fdb1[_0xbab2('0x2f')][_0xbab2('0x18')]);}_0x11e519[_0xbab2('0x37')]=qs['sort'](_0x54fdb1[_0xbab2('0x2f')]['sort']);_0x11e519['where']=qs[_0xbab2('0x31')](_[_0xbab2('0x38')](_0x54fdb1[_0xbab2('0x2f')],_0x3bdc48[_0xbab2('0x31')]),_0x364d23);if(_0x54fdb1[_0xbab2('0x2f')][_0xbab2('0x39')]){_0x11e519[_0xbab2('0x3a')]=_[_0xbab2('0x3b')](_0x11e519[_0xbab2('0x3a')],{'$or':_['map'](_0x364d23,function(_0x5d80e8){if(_0x5d80e8['type']!==_0xbab2('0x3c')){var _0xa50df8={};_0xa50df8[_0x5d80e8[_0xbab2('0x27')]]={'$like':'%'+_0x54fdb1[_0xbab2('0x2f')][_0xbab2('0x39')]+'%'};return _0xa50df8;}})});}_0x11e519=_[_0xbab2('0x3b')]({},_0x11e519,_0x54fdb1['options']);var _0xd3d505={'where':_0x11e519[_0xbab2('0x3a')]};return db[_0xbab2('0x2a')]['count'](_0xd3d505)[_0xbab2('0x22')](function(_0x2a2d4b){_0x460ee5[_0xbab2('0x1b')]=_0x2a2d4b;if(_0x54fdb1[_0xbab2('0x2f')][_0xbab2('0x3d')]){_0x11e519['include']=[{'all':!![]}];}return db['ServicenowConfiguration'][_0xbab2('0x3e')](_0x11e519);})[_0xbab2('0x22')](function(_0x440df8){_0x460ee5['rows']=_0x440df8;return _0x460ee5;})['then'](respondWithFilteredResult(_0x1b77d0,_0x11e519))[_0xbab2('0x3f')](handleError(_0x1b77d0,null));};exports[_0xbab2('0x40')]=function(_0x3a2469,_0x1ac0dc){var _0x16c116={'raw':![],'where':{'id':_0x3a2469[_0xbab2('0x41')]['id']}},_0x1f9a3f={};_0x1f9a3f[_0xbab2('0x2e')]=_['keys'](db[_0xbab2('0x2a')]['rawAttributes']);_0x1f9a3f[_0xbab2('0x2f')]=_[_0xbab2('0x30')](_0x3a2469[_0xbab2('0x2f')]);_0x1f9a3f['filters']=_[_0xbab2('0x32')](_0x1f9a3f[_0xbab2('0x2e')],_0x1f9a3f[_0xbab2('0x2f')]);_0x16c116[_0xbab2('0x33')]=_['intersection'](_0x1f9a3f['model'],qs[_0xbab2('0x34')](_0x3a2469[_0xbab2('0x2f')]['fields']));_0x16c116['attributes']=_0x16c116['attributes'][_0xbab2('0x35')]?_0x16c116['attributes']:_0x1f9a3f['model'];if(_0x3a2469[_0xbab2('0x2f')][_0xbab2('0x3d')]){_0x16c116[_0xbab2('0x42')]=[{'all':!![]}];}_0x16c116=_[_0xbab2('0x3b')]({},_0x16c116,_0x3a2469['options']);return db[_0xbab2('0x2a')][_0xbab2('0x43')](_0x16c116)[_0xbab2('0x22')](handleEntityNotFound(_0x1ac0dc,null))[_0xbab2('0x22')](respondWithResult(_0x1ac0dc,null))[_0xbab2('0x3f')](handleError(_0x1ac0dc,null));};exports[_0xbab2('0x44')]=function(_0x2ec286,_0x225051){return db[_0xbab2('0x2a')][_0xbab2('0x44')](_0x2ec286[_0xbab2('0x45')],{})['then'](respondWithResult(_0x225051,0xc9))[_0xbab2('0x3f')](handleError(_0x225051,null));};exports['update']=function(_0x355e81,_0x5dd6cf){if(_0x355e81[_0xbab2('0x45')]['id']){delete _0x355e81[_0xbab2('0x45')]['id'];}return db[_0xbab2('0x2a')][_0xbab2('0x43')]({'where':{'id':_0x355e81[_0xbab2('0x41')]['id']}})[_0xbab2('0x22')](handleEntityNotFound(_0x5dd6cf,null))[_0xbab2('0x22')](saveUpdates(_0x355e81[_0xbab2('0x45')],null))[_0xbab2('0x22')](respondWithResult(_0x5dd6cf,null))[_0xbab2('0x3f')](handleError(_0x5dd6cf,null));};exports['destroy']=function(_0x30d860,_0x145b94){return db[_0xbab2('0x2a')][_0xbab2('0x43')]({'where':{'id':_0x30d860[_0xbab2('0x41')]['id']}})[_0xbab2('0x22')](handleEntityNotFound(_0x145b94,null))[_0xbab2('0x22')](removeEntity(_0x145b94,null))[_0xbab2('0x3f')](handleError(_0x145b94,null));};exports[_0xbab2('0x46')]=function(_0x54c16c,_0xee3d77,_0x7d0e0a){var _0x2a9d44={};var _0x3f588d={};var _0x5f2a4b;var _0x57491a;return db[_0xbab2('0x2a')]['findOne']({'where':{'id':_0x54c16c[_0xbab2('0x41')]['id']}})[_0xbab2('0x22')](handleEntityNotFound(_0xee3d77,null))[_0xbab2('0x22')](function(_0x4ee68a){if(_0x4ee68a){_0x5f2a4b=_0x4ee68a;_0x3f588d['model']=_[_0xbab2('0x30')](db[_0xbab2('0x47')][_0xbab2('0x2b')]);_0x3f588d['query']=_[_0xbab2('0x30')](_0x54c16c['query']);_0x3f588d[_0xbab2('0x31')]=_[_0xbab2('0x32')](_0x3f588d['model'],_0x3f588d[_0xbab2('0x2f')]);_0x2a9d44[_0xbab2('0x33')]=_['intersection'](_0x3f588d[_0xbab2('0x2e')],qs[_0xbab2('0x34')](_0x54c16c['query'][_0xbab2('0x34')]));_0x2a9d44[_0xbab2('0x33')]=_0x2a9d44[_0xbab2('0x33')]['length']?_0x2a9d44['attributes']:_0x3f588d['model'];_0x2a9d44[_0xbab2('0x37')]=qs[_0xbab2('0x48')](_0x54c16c['query'][_0xbab2('0x48')]);_0x2a9d44['where']=qs['filters'](_[_0xbab2('0x38')](_0x54c16c[_0xbab2('0x2f')],_0x3f588d[_0xbab2('0x31')]));if(_0x54c16c['query']['filter']){_0x2a9d44['where']=_['merge'](_0x2a9d44[_0xbab2('0x3a')],{'$or':_['map'](_0x2a9d44[_0xbab2('0x33')],function(_0x2b1ab6){var _0xdd24ab={};_0xdd24ab[_0x2b1ab6]={'$like':'%'+_0x54c16c[_0xbab2('0x2f')][_0xbab2('0x39')]+'%'};return _0xdd24ab;})});}_0x2a9d44=_[_0xbab2('0x3b')]({},_0x2a9d44,_0x54c16c[_0xbab2('0x49')]);return _0x5f2a4b['getFields'](_0x2a9d44);}})[_0xbab2('0x22')](function(_0x3b9ffd){if(_0x3b9ffd){_0x57491a=_0x3b9ffd[_0xbab2('0x35')];if(!_0x54c16c[_0xbab2('0x2f')]['hasOwnProperty'](_0xbab2('0x4a'))){_0x2a9d44[_0xbab2('0x1a')]=qs['limit'](_0x54c16c['query'][_0xbab2('0x1a')]);_0x2a9d44['offset']=qs[_0xbab2('0x18')](_0x54c16c[_0xbab2('0x2f')]['offset']);}return _0x5f2a4b['getFields'](_0x2a9d44);}})[_0xbab2('0x22')](function(_0x35a604){if(_0x35a604){return _0x35a604?{'count':_0x57491a,'rows':_0x35a604}:null;}})[_0xbab2('0x22')](respondWithResult(_0xee3d77,null))[_0xbab2('0x3f')](handleError(_0xee3d77,null));};exports[_0xbab2('0x4b')]=function(_0x156eff,_0x79ddd7,_0x92b50a){var _0x4600ca={};var _0x40c221={};var _0x52e81e;var _0x1fb481;return db[_0xbab2('0x2a')][_0xbab2('0x4c')]({'where':{'id':_0x156eff[_0xbab2('0x41')]['id']}})['then'](handleEntityNotFound(_0x79ddd7,null))['then'](function(_0xa3982f){if(_0xa3982f){_0x52e81e=_0xa3982f;_0x40c221[_0xbab2('0x2e')]=_['keys'](db['ServicenowField']['rawAttributes']);_0x40c221[_0xbab2('0x2f')]=_[_0xbab2('0x30')](_0x156eff[_0xbab2('0x2f')]);_0x40c221[_0xbab2('0x31')]=_[_0xbab2('0x32')](_0x40c221[_0xbab2('0x2e')],_0x40c221[_0xbab2('0x2f')]);_0x4600ca[_0xbab2('0x33')]=_['intersection'](_0x40c221[_0xbab2('0x2e')],qs[_0xbab2('0x34')](_0x156eff[_0xbab2('0x2f')][_0xbab2('0x34')]));_0x4600ca[_0xbab2('0x33')]=_0x4600ca['attributes'][_0xbab2('0x35')]?_0x4600ca[_0xbab2('0x33')]:_0x40c221['model'];_0x4600ca[_0xbab2('0x37')]=qs['sort'](_0x156eff['query'][_0xbab2('0x48')]);_0x4600ca[_0xbab2('0x3a')]=qs[_0xbab2('0x31')](_[_0xbab2('0x38')](_0x156eff['query'],_0x40c221['filters']));if(_0x156eff[_0xbab2('0x2f')]['filter']){_0x4600ca['where']=_['merge'](_0x4600ca[_0xbab2('0x3a')],{'$or':_[_0xbab2('0x29')](_0x4600ca[_0xbab2('0x33')],function(_0x482152){var _0x3f0349={};_0x3f0349[_0x482152]={'$like':'%'+_0x156eff[_0xbab2('0x2f')][_0xbab2('0x39')]+'%'};return _0x3f0349;})});}_0x4600ca=_[_0xbab2('0x3b')]({},_0x4600ca,_0x156eff[_0xbab2('0x49')]);return _0x52e81e[_0xbab2('0x4b')](_0x4600ca);}})['then'](function(_0x4b5362){if(_0x4b5362){_0x1fb481=_0x4b5362[_0xbab2('0x35')];if(!_0x156eff['query'][_0xbab2('0x36')]('nolimit')){_0x4600ca[_0xbab2('0x1a')]=qs[_0xbab2('0x1a')](_0x156eff[_0xbab2('0x2f')][_0xbab2('0x1a')]);_0x4600ca[_0xbab2('0x18')]=qs[_0xbab2('0x18')](_0x156eff[_0xbab2('0x2f')][_0xbab2('0x18')]);}return _0x52e81e[_0xbab2('0x4b')](_0x4600ca);}})['then'](function(_0xf90de){if(_0xf90de){return _0xf90de?{'count':_0x1fb481,'rows':_0xf90de}:null;}})[_0xbab2('0x22')](respondWithResult(_0x79ddd7,null))[_0xbab2('0x3f')](handleError(_0x79ddd7,null));};exports[_0xbab2('0x4d')]=function(_0x310343,_0x33d65c,_0x5ae08b){var _0x2ec888={};var _0x3057f1={};var _0x2a2424;var _0x465cb3;return db['ServicenowConfiguration'][_0xbab2('0x4c')]({'where':{'id':_0x310343[_0xbab2('0x41')]['id']}})[_0xbab2('0x22')](handleEntityNotFound(_0x33d65c,null))['then'](function(_0x20c5cd){if(_0x20c5cd){_0x2a2424=_0x20c5cd;_0x3057f1['model']=_['keys'](db['ServicenowField'][_0xbab2('0x2b')]);_0x3057f1[_0xbab2('0x2f')]=_[_0xbab2('0x30')](_0x310343[_0xbab2('0x2f')]);_0x3057f1['filters']=_['intersection'](_0x3057f1[_0xbab2('0x2e')],_0x3057f1[_0xbab2('0x2f')]);_0x2ec888[_0xbab2('0x33')]=_[_0xbab2('0x32')](_0x3057f1[_0xbab2('0x2e')],qs[_0xbab2('0x34')](_0x310343['query']['fields']));_0x2ec888[_0xbab2('0x33')]=_0x2ec888[_0xbab2('0x33')]['length']?_0x2ec888['attributes']:_0x3057f1[_0xbab2('0x2e')];_0x2ec888['order']=qs[_0xbab2('0x48')](_0x310343[_0xbab2('0x2f')]['sort']);_0x2ec888[_0xbab2('0x3a')]=qs['filters'](_[_0xbab2('0x38')](_0x310343[_0xbab2('0x2f')],_0x3057f1[_0xbab2('0x31')]));if(_0x310343[_0xbab2('0x2f')][_0xbab2('0x39')]){_0x2ec888[_0xbab2('0x3a')]=_[_0xbab2('0x3b')](_0x2ec888[_0xbab2('0x3a')],{'$or':_[_0xbab2('0x29')](_0x2ec888[_0xbab2('0x33')],function(_0xd65d5c){var _0x2fa349={};_0x2fa349[_0xd65d5c]={'$like':'%'+_0x310343[_0xbab2('0x2f')]['filter']+'%'};return _0x2fa349;})});}_0x2ec888=_[_0xbab2('0x3b')]({},_0x2ec888,_0x310343[_0xbab2('0x49')]);return _0x2a2424['getDescriptions'](_0x2ec888);}})[_0xbab2('0x22')](function(_0x35fe7e){if(_0x35fe7e){_0x465cb3=_0x35fe7e['length'];if(!_0x310343[_0xbab2('0x2f')]['hasOwnProperty']('nolimit')){_0x2ec888[_0xbab2('0x1a')]=qs['limit'](_0x310343[_0xbab2('0x2f')][_0xbab2('0x1a')]);_0x2ec888[_0xbab2('0x18')]=qs[_0xbab2('0x18')](_0x310343[_0xbab2('0x2f')][_0xbab2('0x18')]);}return _0x2a2424[_0xbab2('0x4d')](_0x2ec888);}})[_0xbab2('0x22')](function(_0x1af766){if(_0x1af766){return _0x1af766?{'count':_0x465cb3,'rows':_0x1af766}:null;}})['then'](respondWithResult(_0x33d65c,null))[_0xbab2('0x3f')](handleError(_0x33d65c,null));};