menu_setup.sql

Java的框架

USE PRRM;

ALTER TABLE MENU_ITEM AUTO_INCREMENT = 1;

## ----------------- Road Defect -------------------------------------------


INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (-1, 'RoadDefectMenu', 'menu.roadDefectMenu', 'Road Defect', '_self', '', 1);

SET @RDID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@RDID, 'admin');

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (@RDID, 'RoadDefectMenu.Main', 'menu.roadDefectMenu.mainRoadDefect', 'Road Defect Main Page', '_self', '/roadDefectMain.action', 0);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @RDID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@RDID, 'RoadDefectMenu.List', 'menu.roadDefectMenu.listRoadDefects', 'List Road Defects', '_self', '/roadDefects.action', 1);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @RDID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (@RDID, 'RoadDefectMenu.Add', 'menu.roadDefectMenu.addRoadDefect', 'Add Road Defect', '_self', '/roadDefectForm.action?method=add&from=list', 2);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @RDID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (@RDID, 'RoadDefectMenu.Purge', 'menu.roadDefectMenu.purgeRoadDefect', 'Purge Road Defect', '_self', '/searchRoadDefect.action?method=purge', 3);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @RDID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (@RDID, 'RoadDefectMenu.Archive', 'menu.roadDefectMenu.archiveRoadDefect', 'Archive Road Defect', '_self', '/searchRoadDefect.action?method=archive', 4);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @RDID);



## ----------------- Task  -------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (-1, 'TaskMenu', 'menu.taskMenu', 'Task  Menu', '_self', '', 2);

SET @TASKID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@TASKID, 'member');

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (@TASKID, 'TaskMenu.List', 'menu.taskMenu.ListRoadDefect', 'List all tasks', '_self', '/tasks.action', 0);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@LASTID, 'member');

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @TASKID);


## ----------------- User Report -------------------------------------------


INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (-1, 'UserReportMenu', 'menu.userReportMenu', 'User Report', '_self', '', 3);

SET @USRRPTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@USRRPTID, 'reportAdmin');

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@USRRPTID, 'admin');

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@USRRPTID, 'member');

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (@LASTID, 'UserReportMenu.List', 'menu.userReportMenu.listReports', 'List Reports', '_self', '/userReports.action', 0);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @USRRPTID);


## ----------------- User Document -------------------------------------------


INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (-1, 'UserDocumentMenu', 'menu.userDocumentMenu', 'User Documents', '_self', '', 4);

SET @USRDOCID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@USRDOCID, 'reportAdmin');

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@USRDOCID, 'admin');

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@USRDOCID, 'member');

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (@LASTID, 'UserDocumentMenu.List', 'menu.userDocumentMenu.listDocuments', 'List Documents', '_self', '/docManPub.action', 0);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @USRDOCID);

## ----------------- Admin ------------------------------------------------


INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (-1, 'AdminMenu', 'menu.admin', 'Administration', '_self', '', 5);

SET @ADMINID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@ADMINID, 'admin');
INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@ADMINID, 'alertAdmin');
INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@ADMINID, 'alertSender');
INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@ADMINID, 'reportAdmin');
INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@ADMINID, 'schedulerAdmin');
INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@ADMINID, 'mapAdmin');


## ----------------- User  ------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@ADMINID, 'UserMenu', 'menu.userMenu', 'User  Menu', '_self', '', 0);

SET @USERID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@USERID, 'admin');

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@USERID, @ADMINID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (@USERID, 'UserMenu.List', 'menu.userMenu.listUser', 'List all users', '_self', '/listUsers.action', 0);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @USERID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@USERID, 'UserMenu.Add', 'menu.userMenu.addUser', 'Add user', '_self', '/editUser.action?method=Add&from=list', 1);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @USERID);
 
 
## ----------------- Role  ------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@ADMINID, 'RoleMenu', 'menu.roleMenu', 'Role  Menu', '_self', '', 1);

SET @ROLEID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@ROLEID, 'admin');

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@ROLEID, @ADMINID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@ROLEID, 'RoleMenu.List', 'menu.roleMenu.listRole', 'List all role', '_self', '/listRoles.action', 0);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @ROLEID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@ROLEID, 'RoleMenu.Add', 'menu.roleMenu.addRole', 'Add new role', '_self', '/editRole.action?method=Add&from=list', 1);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @ROLEID);


## ----------------- Preference  ------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (@ADMINID, 'PreferenceMenu', 'menu.preferenceMenu', 'Preference  Menu', '_self', '', 2);

SET @PREFID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@PREFID, 'admin');

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@PREFID, @ADMINID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@PREFID, 'PreferenceMenu.List', 'menu.preferenceMenu.listPreference', 'List all preference', '_self', '/listPreferences.action', 0);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @PREFID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@PREFID, 'PreferenceMenu.Add', 'menu.preferenceMenu.addPreference', 'Add new preference', '_self', '/editPreference.action?method=add&from=list', 1);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @PREFID);      
     	
## ----------------- Menu  ------------------------------------------------


INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@ADMINID, 'MenuConfigMenu', 'menu.menuConfigMenu', 'Menu  Menu', '_self', '', 3);

SET @MENUID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@MENUID, 'admin');

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@MENUID, @ADMINID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (@MENUID, 'MenuConfigMenu.List', 'menu.menuConfigMenu.listMenu', 'List all menu', '_self', '/listMenus.action', 0);

SET @LASTID = LAST_INSERT_ID();