a1e4485051a2719151062d64a10017fb338a5a29
[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 _0x2b3b=['request-promise','moment','mustache','path','sox','to-csv','ejs','lodash','crypto','jsforce','querystring','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/license/util','../../components/integrations/configuration','jayson/promise','client','http','request','then','info','ServicenowAccount,\x20%s,\x20%s','request\x20sent','debug','ServicenowAccount,\x20%s,\x20%s,\x20%s','stringify','error','message','result','sendStatus','status','end','json','offset','undefined','limit','count','apply','reject','save','update','name','send','contact','agent','interaction','index','map','ServicenowAccount','rawAttributes','type','model','query','keys','filters','attributes','intersection','fields','hasOwnProperty','nolimit','sort','where','pick','filter','merge','VIRTUAL','options','includeAll','findAll','rows','catch','show','params','length','include','find','create','body','destroy','getConfigurations','findOne','ServicenowConfiguration','order','addConfiguration','AccountId','channel','Descriptions','getDescriptions','ServicenowField','made_sla','hold_reason','knowledge','notify','severity','category','parent','caused_by','sys_updated_on','child_incidents','approval_history','number','sys_updated_by','opened_by','sys_created_on','state','calendar_stc','closed_at','cmdb_ci','impact','active','work_notes_list','business_service','priority','sys_domain_path','rfc','time_worked','expected_start','opened_at','work_end','resolved_at','caller_id','approval_set','subcategory','work_notes','short_description','delivery_task','work_start','assignment_group','additional_assignee_list','description','calendar_duration','sys_class_name','close_notes','follow_up','parent_incident','contact_type','reopened_by','urgency','problem_id','company','reassignment_count','activity_due','comments','sla_due','due_date','escalation','upon_approval','correlation_id','location','username','email','remoteUri','serverUrl','slice','substring','lastIndexOf','format','%s/api/now/table/','password','GET','incident?sysparm_display_value=all','incident\x20table\x20objects','remove','includes','forEach','internalType','label','all','assign','TCL:\x20_object','log','TCL:\x20exports.getEntityFields\x20->\x20_objectsCustom','push','ServiceNow\x20error:\x20','statusCode','stack','test','Wrong\x20credentials','True','False','false','sys_choice?sysparm_query=name=incident^element=','inactive','eml-format','rimraf','zip-dir'];(function(_0x4c12ec,_0x2e9103){var _0x3ae42c=function(_0x5a728f){while(--_0x5a728f){_0x4c12ec['push'](_0x4c12ec['shift']());}};_0x3ae42c(++_0x2e9103);}(_0x2b3b,0x175));var _0xb2b3=function(_0x363ef8,_0x4ecb1a){_0x363ef8=_0x363ef8-0x0;var _0x148822=_0x2b3b[_0x363ef8];return _0x148822;};'use strict';var emlformat=require(_0xb2b3('0x0'));var rimraf=require(_0xb2b3('0x1'));var zipdir=require(_0xb2b3('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0xb2b3('0x3'));var moment=require(_0xb2b3('0x4'));var BPromise=require('bluebird');var Mustache=require(_0xb2b3('0x5'));var util=require('util');var path=require(_0xb2b3('0x6'));var sox=require(_0xb2b3('0x7'));var csv=require(_0xb2b3('0x8'));var ejs=require(_0xb2b3('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xb2b3('0xa'));var squel=require('squel');var crypto=require(_0xb2b3('0xb'));var jsforce=require(_0xb2b3('0xc'));var deskjs=require('desk.js');var toCsv=require(_0xb2b3('0x8'));var querystring=require(_0xb2b3('0xd'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0xb2b3('0xe'));var hardwareService=require(_0xb2b3('0xf'));var logger=require(_0xb2b3('0x10'))('api');var utils=require(_0xb2b3('0x11'));var config=require('../../config/environment');var licenseUtil=require(_0xb2b3('0x12'));var db=require('../../mysqldb')['db'];var integrations=require(_0xb2b3('0x13'));var jayson=require(_0xb2b3('0x14'));var client=jayson[_0xb2b3('0x15')][_0xb2b3('0x16')]({'port':0x232a});function respondWithRpcPromise(_0xbe21c4,_0x30fce7,_0x366ebd,_0xa47b05){return new BPromise(function(_0x25f4fa,_0x4c3901){var _0x48ed01=_0xa47b05||client;return _0x48ed01[_0xb2b3('0x17')](_0xbe21c4,_0x366ebd)[_0xb2b3('0x18')](function(_0x297e96){logger[_0xb2b3('0x19')](_0xb2b3('0x1a'),_0x30fce7,_0xb2b3('0x1b'));logger[_0xb2b3('0x1c')](_0xb2b3('0x1d'),_0x30fce7,_0xb2b3('0x1b'),JSON[_0xb2b3('0x1e')](_0x297e96));if(_0x297e96[_0xb2b3('0x1f')]){if(_0x297e96[_0xb2b3('0x1f')]['code']===0x1f4){logger[_0xb2b3('0x1f')]('ServicenowAccount,\x20%s,\x20%s',_0x30fce7,_0x297e96['error'][_0xb2b3('0x20')]);return _0x4c3901(_0x297e96[_0xb2b3('0x1f')][_0xb2b3('0x20')]);}logger['error'](_0xb2b3('0x1a'),_0x30fce7,_0x297e96[_0xb2b3('0x1f')][_0xb2b3('0x20')]);return _0x25f4fa(_0x297e96[_0xb2b3('0x1f')][_0xb2b3('0x20')]);}else{logger[_0xb2b3('0x19')](_0xb2b3('0x1a'),_0x30fce7,_0xb2b3('0x1b'));_0x25f4fa(_0x297e96[_0xb2b3('0x21')][_0xb2b3('0x20')]);}})['catch'](function(_0x59a595){logger[_0xb2b3('0x1f')](_0xb2b3('0x1a'),_0x30fce7,_0x59a595);_0x4c3901(_0x59a595);});});}function respondWithStatusCode(_0x10ef29,_0x2be06e){_0x2be06e=_0x2be06e||0xcc;return function(_0x5dda55){if(_0x5dda55){return _0x10ef29[_0xb2b3('0x22')](_0x2be06e);}return _0x10ef29[_0xb2b3('0x23')](_0x2be06e)[_0xb2b3('0x24')]();};}function respondWithResult(_0x3c802f,_0x5a3d7a){_0x5a3d7a=_0x5a3d7a||0xc8;return function(_0x20d6bf){if(_0x20d6bf){return _0x3c802f[_0xb2b3('0x23')](_0x5a3d7a)[_0xb2b3('0x25')](_0x20d6bf);}};}function respondWithFilteredResult(_0x32fc44,_0x2661b7){return function(_0x23493f){if(_0x23493f){var _0x1c3eb5=typeof _0x2661b7[_0xb2b3('0x26')]===_0xb2b3('0x27')&&typeof _0x2661b7[_0xb2b3('0x28')]===_0xb2b3('0x27');var _0x20df63=_0x23493f[_0xb2b3('0x29')];var _0x15c62f=_0x1c3eb5?0x0:_0x2661b7['offset'];var _0x217e32=_0x1c3eb5?_0x23493f['count']:_0x2661b7['offset']+_0x2661b7[_0xb2b3('0x28')];var _0x31549e;if(_0x217e32>=_0x20df63){_0x217e32=_0x20df63;_0x31549e=0xc8;}else{_0x31549e=0xce;}_0x32fc44[_0xb2b3('0x23')](_0x31549e);return _0x32fc44['set']('Content-Range',_0x15c62f+'-'+_0x217e32+'/'+_0x20df63)[_0xb2b3('0x25')](_0x23493f);}return null;};}function patchUpdates(_0x4c3329){return function(_0x375b53){try{jsonpatch[_0xb2b3('0x2a')](_0x375b53,_0x4c3329,!![]);}catch(_0x1d18a2){return BPromise[_0xb2b3('0x2b')](_0x1d18a2);}return _0x375b53[_0xb2b3('0x2c')]();};}function saveUpdates(_0x1cc5b1,_0x4c3e5b){return function(_0x345ffc){if(_0x345ffc){return _0x345ffc[_0xb2b3('0x2d')](_0x1cc5b1)[_0xb2b3('0x18')](function(_0x692663){return _0x692663;});}return null;};}function removeEntity(_0x53fbc5,_0x2e7124){return function(_0x5efa29){if(_0x5efa29){return _0x5efa29['destroy']()[_0xb2b3('0x18')](function(){_0x53fbc5[_0xb2b3('0x23')](0xcc)[_0xb2b3('0x24')]();});}};}function handleEntityNotFound(_0x282b40,_0x511eb4){return function(_0xd98d98){if(!_0xd98d98){_0x282b40[_0xb2b3('0x22')](0x194);}return _0xd98d98;};}function handleError(_0x484b9b,_0x538351){_0x538351=_0x538351||0x1f4;return function(_0x44a4e7){logger[_0xb2b3('0x1f')](_0x44a4e7['stack']);if(_0x44a4e7[_0xb2b3('0x2e')]){delete _0x44a4e7[_0xb2b3('0x2e')];}_0x484b9b[_0xb2b3('0x23')](_0x538351)[_0xb2b3('0x2f')](_0x44a4e7);};}function getMustacheRender(_0xeec902,_0x3fcdf0){return Mustache['render'](_0xeec902,_['merge'](_0x3fcdf0['body'],{'contact':_0x3fcdf0[_0xb2b3('0x30')],'message':_0x3fcdf0[_0xb2b3('0x20')],'agent':_0x3fcdf0[_0xb2b3('0x31')],'interaction':_0x3fcdf0[_0xb2b3('0x32')],'account':_0x3fcdf0['account']}))||'';}exports[_0xb2b3('0x33')]=function(_0x4e6369,_0x2738a3){var _0x3d86ba={},_0x28ce37={},_0x4fb417={'count':0x0,'rows':[]};var _0xf9aa4=_[_0xb2b3('0x34')](db[_0xb2b3('0x35')][_0xb2b3('0x36')],function(_0x1f6d69){return{'name':_0x1f6d69['fieldName'],'type':_0x1f6d69[_0xb2b3('0x37')]['key']};});_0x28ce37[_0xb2b3('0x38')]=_[_0xb2b3('0x34')](_0xf9aa4,_0xb2b3('0x2e'));_0x28ce37[_0xb2b3('0x39')]=_[_0xb2b3('0x3a')](_0x4e6369[_0xb2b3('0x39')]);_0x28ce37[_0xb2b3('0x3b')]=_['intersection'](_0x28ce37[_0xb2b3('0x38')],_0x28ce37[_0xb2b3('0x39')]);_0x3d86ba[_0xb2b3('0x3c')]=_[_0xb2b3('0x3d')](_0x28ce37['model'],qs[_0xb2b3('0x3e')](_0x4e6369['query'][_0xb2b3('0x3e')]));_0x3d86ba['attributes']=_0x3d86ba[_0xb2b3('0x3c')]['length']?_0x3d86ba[_0xb2b3('0x3c')]:_0x28ce37['model'];if(!_0x4e6369[_0xb2b3('0x39')][_0xb2b3('0x3f')](_0xb2b3('0x40'))){_0x3d86ba['limit']=qs[_0xb2b3('0x28')](_0x4e6369[_0xb2b3('0x39')][_0xb2b3('0x28')]);_0x3d86ba[_0xb2b3('0x26')]=qs[_0xb2b3('0x26')](_0x4e6369[_0xb2b3('0x39')][_0xb2b3('0x26')]);}_0x3d86ba['order']=qs[_0xb2b3('0x41')](_0x4e6369[_0xb2b3('0x39')][_0xb2b3('0x41')]);_0x3d86ba[_0xb2b3('0x42')]=qs['filters'](_[_0xb2b3('0x43')](_0x4e6369['query'],_0x28ce37[_0xb2b3('0x3b')]),_0xf9aa4);if(_0x4e6369[_0xb2b3('0x39')][_0xb2b3('0x44')]){_0x3d86ba['where']=_[_0xb2b3('0x45')](_0x3d86ba[_0xb2b3('0x42')],{'$or':_[_0xb2b3('0x34')](_0xf9aa4,function(_0x280a4c){if(_0x280a4c[_0xb2b3('0x37')]!==_0xb2b3('0x46')){var _0x297174={};_0x297174[_0x280a4c[_0xb2b3('0x2e')]]={'$like':'%'+_0x4e6369['query']['filter']+'%'};return _0x297174;}})});}_0x3d86ba=_[_0xb2b3('0x45')]({},_0x3d86ba,_0x4e6369[_0xb2b3('0x47')]);var _0x5cbfd1={'where':_0x3d86ba['where']};return db['ServicenowAccount'][_0xb2b3('0x29')](_0x5cbfd1)[_0xb2b3('0x18')](function(_0x4651c1){_0x4fb417[_0xb2b3('0x29')]=_0x4651c1;if(_0x4e6369[_0xb2b3('0x39')][_0xb2b3('0x48')]){_0x3d86ba['include']=[{'all':!![]}];}return db[_0xb2b3('0x35')][_0xb2b3('0x49')](_0x3d86ba);})[_0xb2b3('0x18')](function(_0x49083c){_0x4fb417[_0xb2b3('0x4a')]=_0x49083c;return _0x4fb417;})['then'](respondWithFilteredResult(_0x2738a3,_0x3d86ba))[_0xb2b3('0x4b')](handleError(_0x2738a3,null));};exports[_0xb2b3('0x4c')]=function(_0x5b9633,_0x3136cc){var _0x35878a={'raw':![],'where':{'id':_0x5b9633[_0xb2b3('0x4d')]['id']}},_0x16fdc0={};_0x16fdc0[_0xb2b3('0x38')]=_[_0xb2b3('0x3a')](db[_0xb2b3('0x35')]['rawAttributes']);_0x16fdc0[_0xb2b3('0x39')]=_[_0xb2b3('0x3a')](_0x5b9633['query']);_0x16fdc0[_0xb2b3('0x3b')]=_['intersection'](_0x16fdc0[_0xb2b3('0x38')],_0x16fdc0[_0xb2b3('0x39')]);_0x35878a[_0xb2b3('0x3c')]=_[_0xb2b3('0x3d')](_0x16fdc0['model'],qs[_0xb2b3('0x3e')](_0x5b9633[_0xb2b3('0x39')][_0xb2b3('0x3e')]));_0x35878a[_0xb2b3('0x3c')]=_0x35878a['attributes'][_0xb2b3('0x4e')]?_0x35878a[_0xb2b3('0x3c')]:_0x16fdc0[_0xb2b3('0x38')];if(_0x5b9633[_0xb2b3('0x39')]['includeAll']){_0x35878a[_0xb2b3('0x4f')]=[{'all':!![]}];}_0x35878a=_[_0xb2b3('0x45')]({},_0x35878a,_0x5b9633['options']);return db[_0xb2b3('0x35')][_0xb2b3('0x50')](_0x35878a)['then'](handleEntityNotFound(_0x3136cc,null))[_0xb2b3('0x18')](respondWithResult(_0x3136cc,null))[_0xb2b3('0x4b')](handleError(_0x3136cc,null));};exports['create']=function(_0x511b74,_0x38a114){return db[_0xb2b3('0x35')][_0xb2b3('0x51')](_0x511b74[_0xb2b3('0x52')],{})[_0xb2b3('0x18')](respondWithResult(_0x38a114,0xc9))[_0xb2b3('0x4b')](handleError(_0x38a114,null));};exports['update']=function(_0x309b90,_0x432019){if(_0x309b90[_0xb2b3('0x52')]['id']){delete _0x309b90[_0xb2b3('0x52')]['id'];}return db['ServicenowAccount'][_0xb2b3('0x50')]({'where':{'id':_0x309b90[_0xb2b3('0x4d')]['id']}})[_0xb2b3('0x18')](handleEntityNotFound(_0x432019,null))[_0xb2b3('0x18')](saveUpdates(_0x309b90[_0xb2b3('0x52')],null))[_0xb2b3('0x18')](respondWithResult(_0x432019,null))['catch'](handleError(_0x432019,null));};exports[_0xb2b3('0x53')]=function(_0x1afc4f,_0xb646c1){return db[_0xb2b3('0x35')][_0xb2b3('0x50')]({'where':{'id':_0x1afc4f['params']['id']}})['then'](handleEntityNotFound(_0xb646c1,null))['then'](removeEntity(_0xb646c1,null))[_0xb2b3('0x4b')](handleError(_0xb646c1,null));};exports[_0xb2b3('0x54')]=function(_0x3f98bf,_0x80bc5,_0x16a8e4){var _0x77077d={};var _0x4a4768={};var _0x2f9ce7;var _0x228c75;return db[_0xb2b3('0x35')][_0xb2b3('0x55')]({'where':{'id':_0x3f98bf['params']['id']}})[_0xb2b3('0x18')](handleEntityNotFound(_0x80bc5,null))[_0xb2b3('0x18')](function(_0x4224c9){if(_0x4224c9){_0x2f9ce7=_0x4224c9;_0x4a4768[_0xb2b3('0x38')]=_[_0xb2b3('0x3a')](db[_0xb2b3('0x56')][_0xb2b3('0x36')]);_0x4a4768[_0xb2b3('0x39')]=_[_0xb2b3('0x3a')](_0x3f98bf[_0xb2b3('0x39')]);_0x4a4768[_0xb2b3('0x3b')]=_[_0xb2b3('0x3d')](_0x4a4768[_0xb2b3('0x38')],_0x4a4768[_0xb2b3('0x39')]);_0x77077d[_0xb2b3('0x3c')]=_[_0xb2b3('0x3d')](_0x4a4768[_0xb2b3('0x38')],qs[_0xb2b3('0x3e')](_0x3f98bf[_0xb2b3('0x39')][_0xb2b3('0x3e')]));_0x77077d[_0xb2b3('0x3c')]=_0x77077d[_0xb2b3('0x3c')][_0xb2b3('0x4e')]?_0x77077d[_0xb2b3('0x3c')]:_0x4a4768[_0xb2b3('0x38')];_0x77077d[_0xb2b3('0x57')]=qs[_0xb2b3('0x41')](_0x3f98bf[_0xb2b3('0x39')][_0xb2b3('0x41')]);_0x77077d['where']=qs[_0xb2b3('0x3b')](_['pick'](_0x3f98bf[_0xb2b3('0x39')],_0x4a4768[_0xb2b3('0x3b')]));if(_0x3f98bf[_0xb2b3('0x39')][_0xb2b3('0x44')]){_0x77077d['where']=_[_0xb2b3('0x45')](_0x77077d[_0xb2b3('0x42')],{'$or':_[_0xb2b3('0x34')](_0x77077d[_0xb2b3('0x3c')],function(_0x48587d){var _0x45e9a9={};_0x45e9a9[_0x48587d]={'$like':'%'+_0x3f98bf[_0xb2b3('0x39')][_0xb2b3('0x44')]+'%'};return _0x45e9a9;})});}_0x77077d=_[_0xb2b3('0x45')]({},_0x77077d,_0x3f98bf['options']);return _0x2f9ce7[_0xb2b3('0x54')](_0x77077d);}})[_0xb2b3('0x18')](function(_0x19a542){if(_0x19a542){_0x228c75=_0x19a542[_0xb2b3('0x4e')];if(!_0x3f98bf[_0xb2b3('0x39')][_0xb2b3('0x3f')]('nolimit')){_0x77077d[_0xb2b3('0x28')]=qs[_0xb2b3('0x28')](_0x3f98bf[_0xb2b3('0x39')]['limit']);_0x77077d[_0xb2b3('0x26')]=qs[_0xb2b3('0x26')](_0x3f98bf[_0xb2b3('0x39')][_0xb2b3('0x26')]);}return _0x2f9ce7['getConfigurations'](_0x77077d);}})['then'](function(_0x2f7eb9){if(_0x2f7eb9){return _0x2f7eb9?{'count':_0x228c75,'rows':_0x2f7eb9}:null;}})['then'](respondWithResult(_0x80bc5,null))[_0xb2b3('0x4b')](handleError(_0x80bc5,null));};exports[_0xb2b3('0x58')]=function(_0x5abd01,_0x2e3e9f,_0x589255){if(_0x5abd01['body']['id']){delete _0x5abd01[_0xb2b3('0x52')]['id'];}return db[_0xb2b3('0x35')][_0xb2b3('0x55')]({'where':{'id':_0x5abd01['params']['id']}})[_0xb2b3('0x18')](handleEntityNotFound(_0x2e3e9f,null))[_0xb2b3('0x18')](function(_0x51196c){if(_0x51196c){_0x5abd01['body'][_0xb2b3('0x59')]=_0x51196c['id'];_0x5abd01['body']['Subjects']=integrations['getSubjects'](_0x5abd01[_0xb2b3('0x52')][_0xb2b3('0x5a')],_0x5abd01[_0xb2b3('0x52')]['type']);_0x5abd01[_0xb2b3('0x52')][_0xb2b3('0x5b')]=integrations[_0xb2b3('0x5c')](_0x5abd01[_0xb2b3('0x52')][_0xb2b3('0x5a')],_0x5abd01[_0xb2b3('0x52')][_0xb2b3('0x37')]);return db['ServicenowConfiguration']['create'](_0x5abd01['body'],{'include':[{'model':db['ServicenowField'],'as':'Subjects'},{'model':db[_0xb2b3('0x5d')],'as':_0xb2b3('0x5b')}]});}return null;})[_0xb2b3('0x18')](respondWithResult(_0x2e3e9f,null))['catch'](handleError(_0x2e3e9f,null));};exports['getFields']=function(_0x450014,_0x794a5d,_0x21178f){var _0x183f52=[_0xb2b3('0x5e'),_0xb2b3('0x5f'),_0xb2b3('0x60'),'subcategory','close_code',_0xb2b3('0x61'),'incident_state',_0xb2b3('0x62'),_0xb2b3('0x63')];var _0x1de1bf=[_0xb2b3('0x64'),'made_sla',_0xb2b3('0x65'),'watch_list','upon_reject',_0xb2b3('0x66'),_0xb2b3('0x67'),_0xb2b3('0x5f'),_0xb2b3('0x68'),_0xb2b3('0x69'),'resolved_by',_0xb2b3('0x6a'),_0xb2b3('0x6b'),'user_input',_0xb2b3('0x6c'),'sys_domain',_0xb2b3('0x6d'),'sys_created_by',_0xb2b3('0x60'),_0xb2b3('0x57'),_0xb2b3('0x6e'),_0xb2b3('0x6f'),_0xb2b3('0x70'),'delivery_plan',_0xb2b3('0x71'),_0xb2b3('0x72'),_0xb2b3('0x73'),_0xb2b3('0x74'),_0xb2b3('0x75'),_0xb2b3('0x76'),_0xb2b3('0x77'),_0xb2b3('0x78'),_0xb2b3('0x79'),_0xb2b3('0x7a'),'business_duration','group_list',_0xb2b3('0x7b'),'reopened_time',_0xb2b3('0x7c'),_0xb2b3('0x7d'),_0xb2b3('0x7e'),_0xb2b3('0x7f'),_0xb2b3('0x80'),_0xb2b3('0x81'),'close_code','correlation_display',_0xb2b3('0x82'),_0xb2b3('0x83'),_0xb2b3('0x84'),'business_stc',_0xb2b3('0x85'),_0xb2b3('0x86'),_0xb2b3('0x87'),_0xb2b3('0x61'),_0xb2b3('0x88'),_0xb2b3('0x89'),'closed_by',_0xb2b3('0x8a'),_0xb2b3('0x8b'),'sys_id',_0xb2b3('0x8c'),_0xb2b3('0x8d'),'incident_state',_0xb2b3('0x8e'),_0xb2b3('0x8f'),_0xb2b3('0x90'),_0xb2b3('0x91'),_0xb2b3('0x92'),'assigned_to','severity',_0xb2b3('0x93'),_0xb2b3('0x94'),'approval','comments_and_work_notes',_0xb2b3('0x95'),'sys_mod_count','reopen_count','sys_tags',_0xb2b3('0x96'),_0xb2b3('0x97'),_0xb2b3('0x98'),_0xb2b3('0x99'),_0xb2b3('0x63')];var _0x319c85='';var _0x4e68e6='';var _0x56a4c3=[];var _0x2df581='';var _0x3c6aad='';var _0x1c0bbd=[];var _0x213512='';var _0x110004='';var _0x5aa630={};var _0x5686d0='';return db[_0xb2b3('0x35')][_0xb2b3('0x55')]({'where':{'id':_0x450014['params']['id']},'attributes':['id',_0xb2b3('0x9a'),'password',_0xb2b3('0x9b'),_0xb2b3('0x9c'),_0xb2b3('0x9d')]})[_0xb2b3('0x18')](handleEntityNotFound(_0x794a5d,null))['then'](function(_0xc1678c){if(_0xc1678c){_0x5686d0=_0xc1678c[_0xb2b3('0x9c')];var _0x18c447=_0x5686d0[_0xb2b3('0x9e')](-0x1);if(_0x18c447==='/'){_0x5686d0=_0x5686d0[_0xb2b3('0x9f')](0x0,_0x5686d0[_0xb2b3('0xa0')](_0x18c447));}_0x110004=util[_0xb2b3('0xa1')]('%s/api/now/doc/table/schema/',_0x5686d0);_0x213512=util[_0xb2b3('0xa1')](_0xb2b3('0xa2'),_0x5686d0);_0x5aa630={'user':_0xc1678c['username'],'pass':_0xc1678c[_0xb2b3('0xa3')]};var _0x1b57da={'method':_0xb2b3('0xa4'),'uri':_0x110004+_0xb2b3('0xa5'),'auth':_0x5aa630,'json':!![]};return rp(_0x1b57da);}})[_0xb2b3('0x18')](function(_0x463bb3){if(_0x463bb3['result'][_0xb2b3('0x4e')]>0x0){_0x319c85=_0x463bb3[_0xb2b3('0x21')];}console['log'](_0xb2b3('0xa6'),_0x319c85);_0x1c0bbd=[];_0x4e68e6=Object['assign']([],_0x319c85);_[_0xb2b3('0xa7')](_0x4e68e6,function(_0x4fc79b){return!_0x183f52[_0xb2b3('0xa8')](_0x4fc79b['name']);});_0x4e68e6[_0xb2b3('0xa9')](function(_0x1fa40f){var _0x48ed26=createFieldObject(_0x213512,_0x5aa630,_0x1fa40f[_0xb2b3('0xaa')],_0x1fa40f[_0xb2b3('0x2e')],_0x1fa40f[_0xb2b3('0xab')],![]);_0x1c0bbd['push'](_0x48ed26);});return Promise[_0xb2b3('0xac')](_0x1c0bbd);})[_0xb2b3('0x18')](function(_0x122763){_0x56a4c3=_0x122763;_0x2df581=Object[_0xb2b3('0xad')]([],_0x319c85);console['log'](_0xb2b3('0xae'),_0x319c85);_['remove'](_0x2df581,function(_0x1033ab){return _0x1de1bf[_0xb2b3('0xa8')](_0x1033ab[_0xb2b3('0x2e')]);});console[_0xb2b3('0xaf')](_0xb2b3('0xb0'),_0x2df581);_0x1c0bbd=[];_0x2df581['forEach'](function(_0x3ec9dd){var _0x3714e5=createFieldObject(_0x213512,_0x5aa630,_0x3ec9dd[_0xb2b3('0xaa')],_0x3ec9dd[_0xb2b3('0x2e')],_0x3ec9dd['label'],!![]);_0x1c0bbd[_0xb2b3('0xb1')](_0x3714e5);});return Promise[_0xb2b3('0xac')](_0x1c0bbd);})[_0xb2b3('0x18')](function(_0x7c0aff){_0x3c6aad=_0x7c0aff;var _0x357cc5=_0x56a4c3['concat'](_0x3c6aad);return{'count':_0x357cc5[_0xb2b3('0x4e')],'rows':_0x357cc5};})[_0xb2b3('0x18')](respondWithResult(_0x794a5d,null))[_0xb2b3('0x4b')](function(_0x50e796){console[_0xb2b3('0xaf')](_0xb2b3('0xb2')+_0x50e796);var _0x408bcf=_0x450014[_0xb2b3('0x39')]['test']?0x1f4:_0x50e796[_0xb2b3('0xb3')]||0x1f4;logger[_0xb2b3('0x1f')](_0x50e796[_0xb2b3('0xb4')]);delete _0x50e796['name'];if(_0x408bcf===0x191){_0x408bcf=0x190;}_0x794a5d[_0xb2b3('0x23')](_0x408bcf)['send'](_0x450014[_0xb2b3('0x39')][_0xb2b3('0xb5')]?{'message':_0xb2b3('0xb6'),'statusCode':_0x50e796['statusCode']}:_0x50e796);});};function createFieldObject(_0x4a0fcb,_0x34b59d,_0x1e2204,_0x3af6d4,_0x32c10a,_0x22ae7b){return new Promise(function(_0x38cb00,_0x328270){var _0x1a329b={'id':_0x3af6d4,'name':_0x32c10a,'custom':_0x22ae7b};if(_0x1e2204==='boolean'){_0x1a329b[_0xb2b3('0x47')]=[{'name':_0xb2b3('0xb7'),'value':'true'},{'name':_0xb2b3('0xb8'),'value':_0xb2b3('0xb9')}];_0x38cb00(_0x1a329b);}else{var _0x24c2b9={'method':'GET','uri':_0x4a0fcb+_0xb2b3('0xba')+_0x3af6d4,'auth':_0x34b59d,'json':!![]};return rp(_0x24c2b9)[_0xb2b3('0x18')](function(_0x1c4352){var _0x3afdff=[];if(_0x1c4352[_0xb2b3('0x21')]['length']>0x0){_0x1c4352['result']['forEach'](function(_0x1884ec){if(_0x1884ec[_0xb2b3('0xbb')]===_0xb2b3('0xb9')){var _0x5397af={'name':_0x1884ec[_0xb2b3('0xab')],'value':_0x1884ec['value']};_0x3afdff['push'](_0x5397af);}});}_0x1a329b[_0xb2b3('0x47')]=_0x3afdff;if(_0x1a329b[_0xb2b3('0x47')][_0xb2b3('0x4e')]>0x0){_0x38cb00(_0x1a329b);}else{if(_0x22ae7b==![]){_0x38cb00();}else{_0x38cb00(_0x1a329b);}}});}});}