Before we create the screens, we need to add the menu items in our dynamic menu. To do so, we will execute the following scripts in the Menu
table:
INSERT INTO `sakila`.`Menu` (`id`, `text`, `iconCls`) VALUES ('4', 'staticData', 'menu_staticdata');
First, we add the new Menu Module that we will call Static Data.
INSERT INTO `sakila`.`Menu` (`text`, `iconCls`, `parent_id`, `className`) VALUES ('actor', 'menu_actor', '4', 'actorsgrid'), ('category', 'menu_category', '4', 'categoriesgrid'), ('language', 'menu_language', '4', 'languagesgrid'), ('city', 'menu_city', '4', 'citiesgrid'), ('country', 'menu_country', '4', 'countriesgrid');
Next, we add each menu item that has the Static Data menu as its parent.
Our Menu
table looks like the following as of now:
And as the username we are using to log in to the application is a part of the admin
group, we will also manually add to the database all the permissions to this group:
INSERT INTO `sakila`.`Permissions` (`Menu_id`, `Group_id...