Activity #2474: Develop database functions to retrieve menus based on user role - VARUNAMAALAA-Work package 2-Software Modules-Storage and GUI [VARUNAMAALAA WEB]] - Health and Technology Group

Actions

Copy link

Activity #2474

closed

Feature #3752: Design of the web framework for Data Centre Software

Feature #1850: Design and Development for web based ANRS

Module #1852: Development for HomePage

Sub module #2471: Development for menu listings

Develop database functions to retrieve menus based on user role

Added by Thara S Pillai over 2 years ago. Updated about 2 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Siji Mathew

Start date:

04/11/2024

Due date:

04/15/2024

% Done:

100%

Estimated time:

Planned Due Date:

Description

@Shameera S L , to guide and review
Refer PKG_CONF.get_user_menu

Actions

Copy link

Updated by Thara S Pillai over 2 years ago

Assignee changed from Shameera S L to Siji Mathew

Actions

Copy link

Updated by Siji Mathew over 2 years ago

Status changed from New to In Progress
% Done changed from 0 to 20

Actions

Copy link

Updated by Thara S Pillai over 2 years ago

The database function to retrieve a JSON response as

{
  "menus": [
    {
      "menu_id": 1,
      "menu_name": "Main Menu 1",
      "menu_description": "This is the description for Main Menu 1.",
      "display_order": 1,
      "parent": null,
      "submenus": [
        {
          "menu_name": "Submenu 1-1",
          "menu_description": "This is the description for Submenu 1-1.",
          "display_order": 1,
          "menu_url": "",
          "parent": 1,
          "submenus": [
            {
              "menu_name": "Submenu 1-1-1",
              "menu_description": "This is the description for Submenu 1-1-1.",
              "display_order": 1,
              "menu_url": "",
              "parent": 1
            },
            {
              "menu_name": "Submenu 1-1-2",
              "menu_description": "This is the description for Submenu 1-1-2.",
              "display_order": 2,
              "menu_url": "",
              "parent": 1
            }
          ]
        },
        {
          "menu_name": "Submenu 1-2",
          "menu_description": "This is the description for Submenu 1-2.",
          "display_order": 2,
          "menu_url": "",
          "parent": 1
        }
      ]
    },
    {
      "menu_id": 2,
      "menu_name": "Main Menu 2",
      "menu_description": "This is the description for Main Menu 2.",
      "display_order": 2,
      "parent": null,
      "submenus": [
        {
          "menu_name": "Submenu 2-1",
          "menu_description": "This is the description for Submenu 2-1.",
          "display_order": 1,
          "menu_url": "",
          "parent": 2
        },
        {
          "menu_name": "Submenu 2-2",
          "menu_description": "This is the description for Submenu 2-2.",
          "display_order": 2,
          "menu_url": "",
          "parent": 2,
          "submenus": [
            {
              "menu_name": "Submenu 2-2-1",
              "menu_description": "This is the description for Submenu 2-2-1.",
              "display_order": 1,
              "menu_url": "",
              "parent": 2
            },
            {
              "menu_name": "Submenu 2-2-2",
              "menu_description": "This is the description for Submenu 2-2-2.",
              "display_order": 2,
              "menu_url": "",
              "parent": 2
            }
          ]
        },
        {
          "menu_name": "Submenu 2-3",
          "menu_description": "This is the description for Submenu 2-3.",
          "display_order": 3,
          "menu_url": "",
          "parent": 2
        }
      ]
    }
  ]
}