1. Project Overview

Java Low Code Platform for ALL Enterprise web applications

Pumpkin Tree Data Platform is a comprehensive platform that helps enterprises achieve digital transformation and eliminates 90% of repetitive tasks in Java backend projects.

The Pumpkin Tree Data Platform provides capabilities such as employee sub-information management, unified organization/user identity management, online workflow design, and rapid API service development based on SQL (currently supporting MySQL, Oracle, and SQL Server), among others! Future plans include ETL data governance and dashboard design features.

The mission of the Pumpkin Tree Data Platform is: Build an enterprise data-sharing platform where all business data sources are centrally managed. Simple data services can provide API services by simply writing SQL on the platform. Complex functions can be generated using the code generator and manually merged. It combines the advantages of low-code development with flexible coding, overcoming the common limitation of inflexibility found in current low-code products!

2. Open Source License

Licensed under MIT

3. Screenshots

System Overview

Tenant Organizations/Users and Subsets

PC End

Data Service APIs

4. Feature Overview

Applicable Projects

The Pumpkin Tree Data Platform is positioned as a comprehensive data platform, while also providing capabilities such as workflow design, unified user information management, and low-code business development. Therefore, it can be used in the development of any J2EE project, especially SAAS projects, Management Information Systems (MIS), Office Automation systems (OA), Enterprise Resource Planning systems (ERP), Customer Relationship Management systems (CRM), and more.

Why Choose the Pumpkin Tree Data Platform?

• 1. Uses the latest mainstream frontend-backend separated architecture (based on the RuoYi framework), making it easy to get started;
• 2. High development efficiency. Uses a code generator and provides the core capabilities of the RuoYi framework;
• 3. Integrates workflow functionality and provides open-source underlying workflow code to meet enterprises' customized workflow requirements, making secondary development very easy;
• 4. One-stop data source management: Supports connecting to MySQL, Oracle, and SQL Server data sources for code generation. Enables multiple internal enterprise project teams to independently develop their projects on the same platform;
• 5. Provides unified organization and user management capabilities: Acts as a channel for enterprise data, receiving organization and user data from upstream human resource management systems. Accelerates downstream business expansion without the burden of repetitive work.
• 6. Rapid API development capabilities: APIs can be quickly developed simply by writing SQL, enabling rapid delivery of business data services and dynamic API publishing. This reduces development pressure and minimizes the impact of functional defects.

Basic System Function Modules

User Management: Users are the operators of the system. This function is primarily used to configure system users.
Department Management: Configures the system's organizational structure (companies, departments, and teams). Displays a tree structure and supports data permissions.
Position Management: Configures the positions held by system users.
Menu Management: Configures system menus, operation permissions, button permission identifiers, and more.
Role Management: Assigns menu permissions to roles and configures data access permissions by organization.
Dictionary Management: Maintains relatively fixed data frequently used in the system.
Parameter Management: Manages commonly used dynamic system configuration parameters.
Notifications and Announcements: Publishes and maintains system notifications and announcements.
Operation Logs: Records and provides queries for normal system operations and abnormal system events.
Login Logs: Records and provides queries for system login activity, including login errors.
Online Users: Monitors the activity status of users currently online in the system.
Scheduled Tasks: Supports online task scheduling (add, modify, and delete), including execution result logs.
Code Generation: Generates frontend and backend code (Java, HTML, XML, SQL) and supports CRUD code downloads.
System API: Automatically generates relevant API documentation based on business code.
Service Monitoring: Monitors system CPU, memory, disk, stack, and other related information.
Cache Monitoring: Supports querying, deleting, and clearing system caches.
Online Builder: Generates corresponding HTML code by dragging and dropping form elements.
Connection Pool Monitoring: Monitors the status of the current system's database connection pool and supports SQL analysis to identify system performance bottlenecks.
   

Employee Management Function Modules

Tenant Organizations: Receives organizational data provided by the enterprise's internal human resources system and supplements and extends management capabilities for third-party partner organizations;
Tenant Users: Receives user data provided by the enterprise's internal human resources system and supplements and extends management capabilities for third-party personnel;
Home Addresses: Manages employee home address information.
Contract Information: Manages employee contract information.
Education History: Manages employee educational background information.
Computer Skills: Manages employee computer skills information.
Work Experience: Manages employee work experience information.
Overseas Travel: Manages employee overseas travel information.
Certification Information: Manages information about certificates obtained by employees.
Rewards and Disciplinary Records: Manages employee rewards and disciplinary records.
Publications and Papers: Manages information about papers and publications authored by employees.
Training Information: Manages employee training information.
Assessment Information: Manages employee performance assessment information.
Family Relationships: Manages employee family information.
Professional Qualification Certifications: Manages employee professional qualification certification information.
Position History: Manages employee position history information.
Foreign Language Skills: Manages employee foreign language proficiency information.
   

Workflow Management Function Modules

Workflow Models: Design workflows online.
Node Configuration: After a workflow is published, configure the approval personnel and role information for each approval node.
Workflow List: View the current processing status of workflows.
.... Developers can perform secondary development of additional functions based on their specific requirements.

Data Service Function Modules

Data Service API: Write SQL online to generate data service APIs.
Cloud Data Sources: Retrieves and displays all data sources registered with the data platform.
Cloud Database Tables: Builds database tables from data sources registered with the data platform. After building, code is automatically generated under "Code Generation".

5. Tech Stack

Technical Architecture:

Development environment

• Language: Java 8
• IDE (Java): Install the Lombok plugin in IDEA / Eclipse
• IDE (Frontend): WebStorm or IDEA
• Dependency Management: Maven
• Database: MySQL5.7+ & Oracle 11g & Sqlserver2017
• Cache: Redis

Backend Development Environment and Dependencies

• java
• maven
• jdk8
• mysql
• redis