PHPMaker Kanban Board

Description

Tables and Their Roles

• tbl_kanban_board: Stores information about Kanban boards, including their names, creation dates, and styling properties such as background color, border color, and font settings.
• tbl_kanban_tasks: Stores tasks associated with each board. Each task has a status, a title, a description, and a position within the board. Tasks can be created, updated, and moved between boards.
• tbl_levels: Manages user roles or levels for permission control. Each role has a unique ID and name.
• tbl_level_permissions: Specifies permissions for each user level, controlling access to various tables and actions within the system.
• tbl_users: Stores user information, including their full name, mobile number, username, password, email, and user level. Users can be managers or regular users, and their status can be active or inactive.

Key Features

• Dynamic Kanban Boards: Users can create and customize Kanban boards with unique names, colors, and fonts. Boards can be styled with custom background colors, border colors, and border widths.
• Task Management: Tasks can be created, updated, and moved between boards. Each task has a status, title, description, and position within the board.
• User Roles and Permissions: The system supports role-based access control, with different levels of permissions for each user role. Permissions are managed via the tbl_level_permissions table.
• User Management: Users can be added, updated, and managed via the tbl_users table. Each user has a unique username, email, and mobile number.
• Real-Time Updates: Changes to boards and tasks are reflected in real-time, allowing users to see updates immediately.

Usage Instructions

1. Setting Up Boards: Add new boards in the tbl_kanban_board table, specifying the board name, background color, border color, and other styling properties.
2. Adding Tasks: Use the tbl_kanban_tasks table to add tasks to each board. Specify the task title, description, status, and position within the board.
3. Managing Users: Add or update users in the tbl_users table. Assign each user a role and set their status to active or inactive.
4. Setting Permissions: Use the tbl_level_permissions table to define permissions for each user role. Specify which tables and actions each role can access.
5. Testing the System: Navigate to the Kanban board interface and try creating, updating, and moving tasks between boards. Observe how the system reflects changes in real-time.

Benefits

• Dynamic and Customizable: Boards and tasks can be customized to fit the needs of different projects and teams.
• User-Centric: The system adapts to the user’s role and permissions, ensuring that each user has access to the appropriate features and data.
• Scalable: New boards, tasks, and users can be added without modifying the underlying code.
• Real-Time Collaboration: Changes to boards and tasks are reflected in real-time, enabling seamless collaboration among team members.

Login

• User: admin
• Password: master
• How to Check: Go to the Kanban board interface and try creating, updating, or moving tasks. Observe how the system dynamically updates the board and tasks based on your actions.