c4f5481bf81e40a69dff175670489c82100d009a
[motion2.git] / server / api / intServicenowAccount / intServicenowAccount.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 _0xb4b6=['sys_created_by','knowledge','calendar_stc','closed_at','delivery_plan','impact','active','work_notes_list','priority','sys_domain_path','time_worked','opened_at','business_duration','group_list','work_end','reopened_time','resolved_at','caller_id','approval_set','work_notes','short_description','correlation_display','delivery_task','work_start','assignment_group','business_stc','description','notify','sys_class_name','follow_up','sys_id','contact_type','reopened_by','urgency','problem_id','company','reassignment_count','approval','comments_and_work_notes','sys_mod_count','sys_tags','escalation','upon_approval','correlation_id','location','password','email','serverUrl','remoteUri','slice','substring','lastIndexOf','format','%s/api/now/doc/table/schema/','%s/api/now/table/','username','GET','incident?sysparm_display_value=all','log','incident\x20table\x20objects','forEach','internalType','label','push','all','assign','TCL:\x20_object','remove','includes','TCL:\x20exports.getEntityFields\x20->\x20_objectsCustom','ServiceNow\x20error:\x20','statusCode','Wrong\x20credentials','boolean','True','true','False','false','inactive','value','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','mustache','path','sox','ejs','lodash','squel','crypto','jsforce','desk.js','to-csv','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','../../components/integrations/configuration','jayson/promise','client','http','test','Sequelize','ValidationError','request','then','info','ServicenowAccount,\x20%s,\x20%s','debug','ServicenowAccount,\x20%s,\x20%s,\x20%s','request\x20sent','stringify','error','code','message','result','sendStatus','status','count','offset','set','json','apply','reject','destroy','end','stack','name','rawAttributes','type','key','model','map','query','keys','filters','attributes','intersection','fields','length','hasOwnProperty','nolimit','limit','order','sort','where','pick','filter','merge','VIRTUAL','options','ServicenowAccount','include','findAll','rows','catch','show','params','includeAll','create','body','find','getConfigurations','ServicenowConfiguration','addConfiguration','findOne','Subjects','getSubjects','channel','Descriptions','getDescriptions','made_sla','hold_reason','subcategory','close_code','incident_state','severity','category','parent','caused_by','watch_list','upon_reject','sys_updated_on','child_incidents','number','resolved_by','opened_by','sys_created_on','sys_domain','state'];(function(_0x6c33b4,_0x457e91){var _0x3623d5=function(_0x41b870){while(--_0x41b870){_0x6c33b4['push'](_0x6c33b4['shift']());}};_0x3623d5(++_0x457e91);}(_0xb4b6,0x115));var _0x6b4b=function(_0x19e22c,_0x512d80){_0x19e22c=_0x19e22c-0x0;var _0x2c6991=_0xb4b6[_0x19e22c];return _0x2c6991;};'use strict';var pdf=require(_0x6b4b('0x0'));var emlformat=require(_0x6b4b('0x1'));var rimraf=require(_0x6b4b('0x2'));var zipdir=require(_0x6b4b('0x3'));var jsonpatch=require(_0x6b4b('0x4'));var rp=require('request-promise');var moment=require(_0x6b4b('0x5'));var BPromise=require('bluebird');var Mustache=require(_0x6b4b('0x6'));var util=require('util');var path=require(_0x6b4b('0x7'));var sox=require(_0x6b4b('0x8'));var csv=require('to-csv');var ejs=require(_0x6b4b('0x9'));var fs=require('fs');var _=require(_0x6b4b('0xa'));var squel=require(_0x6b4b('0xb'));var crypto=require(_0x6b4b('0xc'));var jsforce=require(_0x6b4b('0xd'));var deskjs=require(_0x6b4b('0xe'));var toCsv=require(_0x6b4b('0xf'));var querystring=require(_0x6b4b('0x10'));var Papa=require('papaparse');var Redis=require(_0x6b4b('0x11'));var authService=require(_0x6b4b('0x12'));var qs=require(_0x6b4b('0x13'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x6b4b('0x14'))('api');var utils=require(_0x6b4b('0x15'));var config=require(_0x6b4b('0x16'));var db=require(_0x6b4b('0x17'))['db'];var integrations=require(_0x6b4b('0x18'));var jayson=require(_0x6b4b('0x19'));var client=jayson[_0x6b4b('0x1a')][_0x6b4b('0x1b')]({'port':0x232a});function checkPasswordPattern(_0x1b683b,_0x185657,_0x17bac6){if(_0x17bac6){var _0x347566=new RegExp(/(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[?!@#\$%\^&\*~\-_=+[{\]\}])(?=.{8,})/);if(_0x347566[_0x6b4b('0x1c')](_0x185657)){return _0x1b683b;}else{throw new db[(_0x6b4b('0x1d'))][(_0x6b4b('0x1e'))]('The\x20password\x20must\x20be\x20at\x20least\x208\x20characters\x20long\x20and\x20have\x201\x20lowercase\x20character,\x201\x20uppercase\x20character,\x201\x20number\x20and\x201\x20special\x20character\x20~!@#$%^&-_=+[{]}.');}}else{return _0x1b683b;}}function respondWithRpcPromise(_0x541d0d,_0x39c461,_0x2f166a,_0x50f184){return new BPromise(function(_0x16074b,_0x2116ce){var _0x20639f=_0x50f184||client;return _0x20639f[_0x6b4b('0x1f')](_0x541d0d,_0x2f166a)[_0x6b4b('0x20')](function(_0x2da081){logger[_0x6b4b('0x21')](_0x6b4b('0x22'),_0x39c461,'request\x20sent');logger[_0x6b4b('0x23')](_0x6b4b('0x24'),_0x39c461,_0x6b4b('0x25'),JSON[_0x6b4b('0x26')](_0x2da081));if(_0x2da081[_0x6b4b('0x27')]){if(_0x2da081[_0x6b4b('0x27')][_0x6b4b('0x28')]===0x1f4){logger[_0x6b4b('0x27')]('ServicenowAccount,\x20%s,\x20%s',_0x39c461,_0x2da081[_0x6b4b('0x27')][_0x6b4b('0x29')]);return _0x2116ce(_0x2da081[_0x6b4b('0x27')]['message']);}logger[_0x6b4b('0x27')](_0x6b4b('0x22'),_0x39c461,_0x2da081['error']['message']);return _0x16074b(_0x2da081[_0x6b4b('0x27')][_0x6b4b('0x29')]);}else{logger[_0x6b4b('0x21')]('ServicenowAccount,\x20%s,\x20%s',_0x39c461,_0x6b4b('0x25'));_0x16074b(_0x2da081[_0x6b4b('0x2a')][_0x6b4b('0x29')]);}})['catch'](function(_0x5367ec){logger[_0x6b4b('0x27')](_0x6b4b('0x22'),_0x39c461,_0x5367ec);_0x2116ce(_0x5367ec);});});}function respondWithStatusCode(_0x25fdcf,_0x50f004){_0x50f004=_0x50f004||0xcc;return function(_0xad1085){if(_0xad1085){return _0x25fdcf[_0x6b4b('0x2b')](_0x50f004);}return _0x25fdcf[_0x6b4b('0x2c')](_0x50f004)['end']();};}function respondWithResult(_0x2ccdee,_0x51475b){_0x51475b=_0x51475b||0xc8;return function(_0x2147af){if(_0x2147af){return _0x2ccdee[_0x6b4b('0x2c')](_0x51475b)['json'](_0x2147af);}};}function respondWithFilteredResult(_0x20aff0,_0x354011){return function(_0x50fd87){if(_0x50fd87){var _0x1f4bf6=_0x50fd87[_0x6b4b('0x2d')],_0x504fef=_0x354011[_0x6b4b('0x2e')],_0x143d31=_0x354011[_0x6b4b('0x2e')]+_0x354011['limit'],_0x1c0676;if(_0x143d31>=_0x1f4bf6){_0x143d31=_0x1f4bf6;_0x1c0676=0xc8;}else{_0x1c0676=0xce;}_0x20aff0[_0x6b4b('0x2c')](_0x1c0676);return _0x20aff0[_0x6b4b('0x2f')]('Content-Range',_0x504fef+'-'+_0x143d31+'/'+_0x1f4bf6)[_0x6b4b('0x30')](_0x50fd87);}return null;};}function patchUpdates(_0xf8d83a){return function(_0x5eb285){try{jsonpatch[_0x6b4b('0x31')](_0x5eb285,_0xf8d83a,!![]);}catch(_0x44fae8){return BPromise[_0x6b4b('0x32')](_0x44fae8);}return _0x5eb285['save']();};}function saveUpdates(_0x276fa4,_0x3b1017){return function(_0x299360){if(_0x299360){return _0x299360['update'](_0x276fa4)['then'](function(_0x2104f4){return _0x2104f4;});}return null;};}function removeEntity(_0x1cae3a,_0x892909){return function(_0x17b0a6){if(_0x17b0a6){return _0x17b0a6[_0x6b4b('0x33')]()[_0x6b4b('0x20')](function(){_0x1cae3a[_0x6b4b('0x2c')](0xcc)[_0x6b4b('0x34')]();});}};}function handleEntityNotFound(_0x53cc24,_0x4b9128){return function(_0x410803){if(!_0x410803){_0x53cc24['sendStatus'](0x194);}return _0x410803;};}function handleError(_0xf30bfb,_0x26f8b4){_0x26f8b4=_0x26f8b4||0x1f4;return function(_0x1a9217){logger[_0x6b4b('0x27')](_0x1a9217[_0x6b4b('0x35')]);if(_0x1a9217['name']){delete _0x1a9217[_0x6b4b('0x36')];}_0xf30bfb[_0x6b4b('0x2c')](_0x26f8b4)['send'](_0x1a9217);};}exports['index']=function(_0x3cd63e,_0x2412a8){var _0x3ae78b={},_0x30dcea={},_0x4207fc={'count':0x0,'rows':[]};var _0x1b67bc=_['map'](db['ServicenowAccount'][_0x6b4b('0x37')],function(_0x438b0b){return{'name':_0x438b0b['fieldName'],'type':_0x438b0b[_0x6b4b('0x38')][_0x6b4b('0x39')]};});_0x30dcea[_0x6b4b('0x3a')]=_[_0x6b4b('0x3b')](_0x1b67bc,_0x6b4b('0x36'));_0x30dcea[_0x6b4b('0x3c')]=_[_0x6b4b('0x3d')](_0x3cd63e[_0x6b4b('0x3c')]);_0x30dcea[_0x6b4b('0x3e')]=_['intersection'](_0x30dcea[_0x6b4b('0x3a')],_0x30dcea['query']);_0x3ae78b[_0x6b4b('0x3f')]=_[_0x6b4b('0x40')](_0x30dcea[_0x6b4b('0x3a')],qs['fields'](_0x3cd63e[_0x6b4b('0x3c')][_0x6b4b('0x41')]));_0x3ae78b['attributes']=_0x3ae78b[_0x6b4b('0x3f')][_0x6b4b('0x42')]?_0x3ae78b['attributes']:_0x30dcea['model'];if(!_0x3cd63e[_0x6b4b('0x3c')][_0x6b4b('0x43')](_0x6b4b('0x44'))){_0x3ae78b[_0x6b4b('0x45')]=qs[_0x6b4b('0x45')](_0x3cd63e[_0x6b4b('0x3c')][_0x6b4b('0x45')]);_0x3ae78b[_0x6b4b('0x2e')]=qs['offset'](_0x3cd63e[_0x6b4b('0x3c')]['offset']);}_0x3ae78b[_0x6b4b('0x46')]=qs[_0x6b4b('0x47')](_0x3cd63e[_0x6b4b('0x3c')]['sort']);_0x3ae78b[_0x6b4b('0x48')]=qs[_0x6b4b('0x3e')](_[_0x6b4b('0x49')](_0x3cd63e[_0x6b4b('0x3c')],_0x30dcea[_0x6b4b('0x3e')]),_0x1b67bc);if(_0x3cd63e[_0x6b4b('0x3c')][_0x6b4b('0x4a')]){_0x3ae78b['where']=_[_0x6b4b('0x4b')](_0x3ae78b['where'],{'$or':_[_0x6b4b('0x3b')](_0x1b67bc,function(_0x3db40c){if(_0x3db40c[_0x6b4b('0x38')]!==_0x6b4b('0x4c')){var _0x2c9430={};_0x2c9430[_0x3db40c[_0x6b4b('0x36')]]={'$like':'%'+_0x3cd63e[_0x6b4b('0x3c')][_0x6b4b('0x4a')]+'%'};return _0x2c9430;}})});}_0x3ae78b=_[_0x6b4b('0x4b')]({},_0x3ae78b,_0x3cd63e[_0x6b4b('0x4d')]);var _0x437fc1={'where':_0x3ae78b['where']};return db[_0x6b4b('0x4e')][_0x6b4b('0x2d')](_0x437fc1)[_0x6b4b('0x20')](function(_0x4f5d3f){_0x4207fc[_0x6b4b('0x2d')]=_0x4f5d3f;if(_0x3cd63e[_0x6b4b('0x3c')]['includeAll']){_0x3ae78b[_0x6b4b('0x4f')]=[{'all':!![]}];}return db['ServicenowAccount'][_0x6b4b('0x50')](_0x3ae78b);})['then'](function(_0x419463){_0x4207fc[_0x6b4b('0x51')]=_0x419463;return _0x4207fc;})[_0x6b4b('0x20')](respondWithFilteredResult(_0x2412a8,_0x3ae78b))[_0x6b4b('0x52')](handleError(_0x2412a8,null));};exports[_0x6b4b('0x53')]=function(_0x278c0f,_0x4a48b3){var _0x5e02d5={'raw':![],'where':{'id':_0x278c0f[_0x6b4b('0x54')]['id']}},_0x3afeda={};_0x3afeda[_0x6b4b('0x3a')]=_[_0x6b4b('0x3d')](db[_0x6b4b('0x4e')]['rawAttributes']);_0x3afeda[_0x6b4b('0x3c')]=_['keys'](_0x278c0f[_0x6b4b('0x3c')]);_0x3afeda['filters']=_['intersection'](_0x3afeda['model'],_0x3afeda[_0x6b4b('0x3c')]);_0x5e02d5[_0x6b4b('0x3f')]=_[_0x6b4b('0x40')](_0x3afeda[_0x6b4b('0x3a')],qs[_0x6b4b('0x41')](_0x278c0f['query'][_0x6b4b('0x41')]));_0x5e02d5[_0x6b4b('0x3f')]=_0x5e02d5['attributes']['length']?_0x5e02d5[_0x6b4b('0x3f')]:_0x3afeda['model'];if(_0x278c0f['query'][_0x6b4b('0x55')]){_0x5e02d5['include']=[{'all':!![]}];}_0x5e02d5=_[_0x6b4b('0x4b')]({},_0x5e02d5,_0x278c0f[_0x6b4b('0x4d')]);return db['ServicenowAccount']['find'](_0x5e02d5)[_0x6b4b('0x20')](handleEntityNotFound(_0x4a48b3,null))[_0x6b4b('0x20')](respondWithResult(_0x4a48b3,null))['catch'](handleError(_0x4a48b3,null));};exports[_0x6b4b('0x56')]=function(_0x27f887,_0x3deca2){return db[_0x6b4b('0x4e')]['create'](_0x27f887[_0x6b4b('0x57')],{})[_0x6b4b('0x20')](respondWithResult(_0x3deca2,0xc9))[_0x6b4b('0x52')](handleError(_0x3deca2,null));};exports['update']=function(_0x93c223,_0x4de3e){if(_0x93c223[_0x6b4b('0x57')]['id']){delete _0x93c223[_0x6b4b('0x57')]['id'];}return db['ServicenowAccount'][_0x6b4b('0x58')]({'where':{'id':_0x93c223['params']['id']}})[_0x6b4b('0x20')](handleEntityNotFound(_0x4de3e,null))[_0x6b4b('0x20')](saveUpdates(_0x93c223['body'],null))[_0x6b4b('0x20')](respondWithResult(_0x4de3e,null))[_0x6b4b('0x52')](handleError(_0x4de3e,null));};exports[_0x6b4b('0x33')]=function(_0x39d06c,_0x1453b2){return db[_0x6b4b('0x4e')][_0x6b4b('0x58')]({'where':{'id':_0x39d06c['params']['id']}})[_0x6b4b('0x20')](handleEntityNotFound(_0x1453b2,null))[_0x6b4b('0x20')](removeEntity(_0x1453b2,null))[_0x6b4b('0x52')](handleError(_0x1453b2,null));};exports[_0x6b4b('0x59')]=function(_0x16d4f0,_0x5f4091,_0x53640c){var _0x546b74={};var _0x490664={};var _0x523185;var _0xa72292;return db[_0x6b4b('0x4e')]['findOne']({'where':{'id':_0x16d4f0[_0x6b4b('0x54')]['id']}})[_0x6b4b('0x20')](handleEntityNotFound(_0x5f4091,null))[_0x6b4b('0x20')](function(_0x167fbb){if(_0x167fbb){_0x523185=_0x167fbb;_0x490664[_0x6b4b('0x3a')]=_['keys'](db[_0x6b4b('0x5a')][_0x6b4b('0x37')]);_0x490664[_0x6b4b('0x3c')]=_[_0x6b4b('0x3d')](_0x16d4f0[_0x6b4b('0x3c')]);_0x490664['filters']=_[_0x6b4b('0x40')](_0x490664[_0x6b4b('0x3a')],_0x490664['query']);_0x546b74[_0x6b4b('0x3f')]=_[_0x6b4b('0x40')](_0x490664[_0x6b4b('0x3a')],qs[_0x6b4b('0x41')](_0x16d4f0[_0x6b4b('0x3c')][_0x6b4b('0x41')]));_0x546b74[_0x6b4b('0x3f')]=_0x546b74[_0x6b4b('0x3f')]['length']?_0x546b74[_0x6b4b('0x3f')]:_0x490664[_0x6b4b('0x3a')];_0x546b74[_0x6b4b('0x46')]=qs[_0x6b4b('0x47')](_0x16d4f0[_0x6b4b('0x3c')][_0x6b4b('0x47')]);_0x546b74[_0x6b4b('0x48')]=qs[_0x6b4b('0x3e')](_['pick'](_0x16d4f0[_0x6b4b('0x3c')],_0x490664['filters']));if(_0x16d4f0[_0x6b4b('0x3c')][_0x6b4b('0x4a')]){_0x546b74[_0x6b4b('0x48')]=_['merge'](_0x546b74[_0x6b4b('0x48')],{'$or':_[_0x6b4b('0x3b')](_0x546b74[_0x6b4b('0x3f')],function(_0x3786f5){var _0x40268a={};_0x40268a[_0x3786f5]={'$like':'%'+_0x16d4f0['query'][_0x6b4b('0x4a')]+'%'};return _0x40268a;})});}_0x546b74=_[_0x6b4b('0x4b')]({},_0x546b74,_0x16d4f0['options']);return _0x523185[_0x6b4b('0x59')](_0x546b74);}})[_0x6b4b('0x20')](function(_0x1145c8){if(_0x1145c8){_0xa72292=_0x1145c8[_0x6b4b('0x42')];if(!_0x16d4f0[_0x6b4b('0x3c')]['hasOwnProperty'](_0x6b4b('0x44'))){_0x546b74[_0x6b4b('0x45')]=qs[_0x6b4b('0x45')](_0x16d4f0[_0x6b4b('0x3c')]['limit']);_0x546b74[_0x6b4b('0x2e')]=qs[_0x6b4b('0x2e')](_0x16d4f0[_0x6b4b('0x3c')][_0x6b4b('0x2e')]);}return _0x523185[_0x6b4b('0x59')](_0x546b74);}})[_0x6b4b('0x20')](function(_0x235cb7){if(_0x235cb7){return _0x235cb7?{'count':_0xa72292,'rows':_0x235cb7}:null;}})[_0x6b4b('0x20')](respondWithResult(_0x5f4091,null))[_0x6b4b('0x52')](handleError(_0x5f4091,null));};exports[_0x6b4b('0x5b')]=function(_0x5a0437,_0x173393,_0x5a256f){if(_0x5a0437[_0x6b4b('0x57')]['id']){delete _0x5a0437[_0x6b4b('0x57')]['id'];}return db['ServicenowAccount'][_0x6b4b('0x5c')]({'where':{'id':_0x5a0437[_0x6b4b('0x54')]['id']}})[_0x6b4b('0x20')](handleEntityNotFound(_0x173393,null))[_0x6b4b('0x20')](function(_0x194971){if(_0x194971){_0x5a0437['body']['AccountId']=_0x194971['id'];_0x5a0437[_0x6b4b('0x57')][_0x6b4b('0x5d')]=integrations[_0x6b4b('0x5e')](_0x5a0437[_0x6b4b('0x57')][_0x6b4b('0x5f')],_0x5a0437[_0x6b4b('0x57')][_0x6b4b('0x38')]);_0x5a0437['body'][_0x6b4b('0x60')]=integrations[_0x6b4b('0x61')](_0x5a0437[_0x6b4b('0x57')][_0x6b4b('0x5f')],_0x5a0437['body']['type']);return db[_0x6b4b('0x5a')][_0x6b4b('0x56')](_0x5a0437['body'],{'include':[{'model':db['ServicenowField'],'as':_0x6b4b('0x5d')},{'model':db['ServicenowField'],'as':_0x6b4b('0x60')}]});}return null;})[_0x6b4b('0x20')](respondWithResult(_0x173393,null))[_0x6b4b('0x52')](handleError(_0x173393,null));};exports['getFields']=function(_0x1d5a10,_0x2cbc96,_0x588fda){var _0x27eeba=[_0x6b4b('0x62'),_0x6b4b('0x63'),'knowledge',_0x6b4b('0x64'),_0x6b4b('0x65'),'notify',_0x6b4b('0x66'),_0x6b4b('0x67'),_0x6b4b('0x68')];var _0x3cd9a7=[_0x6b4b('0x69'),_0x6b4b('0x62'),_0x6b4b('0x6a'),_0x6b4b('0x6b'),_0x6b4b('0x6c'),_0x6b4b('0x6d'),_0x6b4b('0x6e'),_0x6b4b('0x63'),'approval_history',_0x6b4b('0x6f'),_0x6b4b('0x70'),'sys_updated_by',_0x6b4b('0x71'),'user_input',_0x6b4b('0x72'),_0x6b4b('0x73'),_0x6b4b('0x74'),_0x6b4b('0x75'),_0x6b4b('0x76'),_0x6b4b('0x46'),_0x6b4b('0x77'),_0x6b4b('0x78'),'cmdb_ci',_0x6b4b('0x79'),_0x6b4b('0x7a'),_0x6b4b('0x7b'),_0x6b4b('0x7c'),'business_service',_0x6b4b('0x7d'),_0x6b4b('0x7e'),'rfc',_0x6b4b('0x7f'),'expected_start',_0x6b4b('0x80'),_0x6b4b('0x81'),_0x6b4b('0x82'),_0x6b4b('0x83'),_0x6b4b('0x84'),_0x6b4b('0x85'),_0x6b4b('0x86'),_0x6b4b('0x87'),_0x6b4b('0x64'),_0x6b4b('0x88'),_0x6b4b('0x89'),'close_code',_0x6b4b('0x8a'),_0x6b4b('0x8b'),_0x6b4b('0x8c'),_0x6b4b('0x8d'),_0x6b4b('0x8e'),'additional_assignee_list',_0x6b4b('0x8f'),'calendar_duration',_0x6b4b('0x90'),_0x6b4b('0x91'),'close_notes','closed_by',_0x6b4b('0x92'),'parent_incident',_0x6b4b('0x93'),_0x6b4b('0x94'),_0x6b4b('0x95'),_0x6b4b('0x66'),_0x6b4b('0x96'),_0x6b4b('0x97'),_0x6b4b('0x98'),_0x6b4b('0x99'),'activity_due','assigned_to',_0x6b4b('0x67'),'comments','sla_due',_0x6b4b('0x9a'),_0x6b4b('0x9b'),'due_date',_0x6b4b('0x9c'),'reopen_count',_0x6b4b('0x9d'),_0x6b4b('0x9e'),_0x6b4b('0x9f'),_0x6b4b('0xa0'),_0x6b4b('0xa1'),_0x6b4b('0x68')];var _0x514f2a='';var _0x4eb1e0='';var _0x4ecfb6=[];var _0xdeae95='';var _0xb39cb2='';var _0x9bfe8e=[];var _0x36bd4f='';var _0x2b21a6='';var _0x47fe1d={};var _0xa796a4='';return db[_0x6b4b('0x4e')][_0x6b4b('0x5c')]({'where':{'id':_0x1d5a10[_0x6b4b('0x54')]['id']},'attributes':['id','username',_0x6b4b('0xa2'),_0x6b4b('0xa3'),'remoteUri',_0x6b4b('0xa4')]})[_0x6b4b('0x20')](handleEntityNotFound(_0x2cbc96,null))['then'](function(_0x57bd17){if(_0x57bd17){_0xa796a4=_0x57bd17[_0x6b4b('0xa5')];var _0x4bb08c=_0xa796a4[_0x6b4b('0xa6')](-0x1);if(_0x4bb08c==='/'){_0xa796a4=_0xa796a4[_0x6b4b('0xa7')](0x0,_0xa796a4[_0x6b4b('0xa8')](_0x4bb08c));}_0x2b21a6=util[_0x6b4b('0xa9')](_0x6b4b('0xaa'),_0xa796a4);_0x36bd4f=util[_0x6b4b('0xa9')](_0x6b4b('0xab'),_0xa796a4);_0x47fe1d={'user':_0x57bd17[_0x6b4b('0xac')],'pass':_0x57bd17[_0x6b4b('0xa2')]};var _0xc1c06={'method':_0x6b4b('0xad'),'uri':_0x2b21a6+_0x6b4b('0xae'),'auth':_0x47fe1d,'json':!![]};return rp(_0xc1c06);}})[_0x6b4b('0x20')](function(_0x1c09a5){if(_0x1c09a5[_0x6b4b('0x2a')][_0x6b4b('0x42')]>0x0){_0x514f2a=_0x1c09a5['result'];}console[_0x6b4b('0xaf')](_0x6b4b('0xb0'),_0x514f2a);_0x9bfe8e=[];_0x4eb1e0=Object['assign']([],_0x514f2a);_['remove'](_0x4eb1e0,function(_0x518b28){return!_0x27eeba['includes'](_0x518b28[_0x6b4b('0x36')]);});_0x4eb1e0[_0x6b4b('0xb1')](function(_0x35d326){var _0x2433ef=createFieldObject(_0x36bd4f,_0x47fe1d,_0x35d326[_0x6b4b('0xb2')],_0x35d326[_0x6b4b('0x36')],_0x35d326[_0x6b4b('0xb3')],![]);_0x9bfe8e[_0x6b4b('0xb4')](_0x2433ef);});return Promise[_0x6b4b('0xb5')](_0x9bfe8e);})['then'](function(_0x2dd83c){_0x4ecfb6=_0x2dd83c;_0xdeae95=Object[_0x6b4b('0xb6')]([],_0x514f2a);console[_0x6b4b('0xaf')](_0x6b4b('0xb7'),_0x514f2a);_[_0x6b4b('0xb8')](_0xdeae95,function(_0x4254cc){return _0x3cd9a7[_0x6b4b('0xb9')](_0x4254cc['name']);});console[_0x6b4b('0xaf')](_0x6b4b('0xba'),_0xdeae95);_0x9bfe8e=[];_0xdeae95[_0x6b4b('0xb1')](function(_0xc01133){var _0x2f359b=createFieldObject(_0x36bd4f,_0x47fe1d,_0xc01133[_0x6b4b('0xb2')],_0xc01133[_0x6b4b('0x36')],_0xc01133[_0x6b4b('0xb3')],!![]);_0x9bfe8e[_0x6b4b('0xb4')](_0x2f359b);});return Promise[_0x6b4b('0xb5')](_0x9bfe8e);})[_0x6b4b('0x20')](function(_0x21761b){_0xb39cb2=_0x21761b;var _0x4b4424=_0x4ecfb6['concat'](_0xb39cb2);return{'count':_0x4b4424[_0x6b4b('0x42')],'rows':_0x4b4424};})['then'](respondWithResult(_0x2cbc96,null))['catch'](function(_0x44881f){console['log'](_0x6b4b('0xbb')+_0x44881f);var _0x44e59d=_0x1d5a10[_0x6b4b('0x3c')][_0x6b4b('0x1c')]?0x1f4:_0x44881f[_0x6b4b('0xbc')]||0x1f4;logger[_0x6b4b('0x27')](_0x44881f[_0x6b4b('0x35')]);delete _0x44881f[_0x6b4b('0x36')];if(_0x44e59d===0x191){_0x44e59d=0x190;}_0x2cbc96[_0x6b4b('0x2c')](_0x44e59d)['send'](_0x1d5a10[_0x6b4b('0x3c')][_0x6b4b('0x1c')]?{'message':_0x6b4b('0xbd'),'statusCode':_0x44881f['statusCode']}:_0x44881f);});};function createFieldObject(_0x1cd937,_0x553ef2,_0x30de11,_0x882964,_0x41f6ca,_0x368758){return new Promise(function(_0x2cce63,_0x926603){var _0x701d6e={'id':_0x882964,'name':_0x41f6ca,'custom':_0x368758};if(_0x30de11===_0x6b4b('0xbe')){_0x701d6e['options']=[{'name':_0x6b4b('0xbf'),'value':_0x6b4b('0xc0')},{'name':_0x6b4b('0xc1'),'value':_0x6b4b('0xc2')}];_0x2cce63(_0x701d6e);}else{var _0x41d674={'method':'GET','uri':_0x1cd937+'sys_choice?sysparm_query=name=incident^element='+_0x882964,'auth':_0x553ef2,'json':!![]};return rp(_0x41d674)[_0x6b4b('0x20')](function(_0x314993){var _0x5a4dcb=[];if(_0x314993[_0x6b4b('0x2a')][_0x6b4b('0x42')]>0x0){_0x314993[_0x6b4b('0x2a')][_0x6b4b('0xb1')](function(_0x144ac8){if(_0x144ac8[_0x6b4b('0xc3')]==='false'){var _0x599d71={'name':_0x144ac8[_0x6b4b('0xb3')],'value':_0x144ac8[_0x6b4b('0xc4')]};_0x5a4dcb[_0x6b4b('0xb4')](_0x599d71);}});}_0x701d6e[_0x6b4b('0x4d')]=_0x5a4dcb;if(_0x701d6e[_0x6b4b('0x4d')][_0x6b4b('0x42')]>0x0){_0x2cce63(_0x701d6e);}else{if(_0x368758==![]){_0x2cce63();}else{_0x2cce63(_0x701d6e);}}});}});}