Building an Enterprise HRMS on Chengwu Low-Code with Deepseek, AMIS & LogicFlow

Introduction

Enterprise human resource management systems (HRMS) are core organizational systems covering employee information, payroll, attendance, and performance. As companies grow, manual management becomes insufficient. This article shows how to construct an enterprise-grade HRMS on the Chengwu low-code platform using three key tools: Deepseek for SQL script generation and database import, AMIS for frontend page generation, and LogicFlow for automated business logic such as attendance check-in and salary calculation.

Scenario Description

Background

A large enterprise requires integrated digital management of employee information, attendance, payroll, and performance evaluation. The system must support:

Employee profile management : record basic information such as name, position, hire date, department.

Attendance management : track clock-in/out, leave, overtime with automatic approval.

Payroll management : calculate salaries based on attendance and overtime.

Performance evaluation : generate performance reports from KPI assessments.

System Requirements

Employee management : basic info, position, department, salary.

Attendance management : clock-in records, leave requests, overtime statistics.

Payroll calculation : automatic salary computation from attendance and overtime.

Performance management : generate performance reports from project and KPI evaluations.

System Architecture

The HRMS is divided into three layers:

Database layer : Deepseek generates SQL scripts to define data structures.

Frontend page layer : AMIS builds user interfaces for employee profiles, attendance, payroll, and performance.

Business logic layer : LogicFlow process engine automates workflows such as attendance approval and payroll disbursement.

Database Design: Using Deepseek to Generate SQL

In the Chengwu platform, Deepseek can generate SQL scripts and import them to automatically set up the database schema. The article provides three concrete examples of prompting Deepseek and the resulting SQL.

1. Employee Table

Prompt : "Please generate an employee table ( employees) with fields for employee ID, name, position, department, hire date, etc."

CREATE TABLE employees (
     employee_id INT PRIMARY KEY AUTO_INCREMENT,
     name VARCHAR(255) NOT NULL,
     position VARCHAR(255),
     department VARCHAR(255),
     hire_date DATE,
     salary DECIMAL(10, 2),
     created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
     updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

2. Attendance Table

Prompt : "Please generate an attendance table ( attendance) including employee ID, clock-in date, clock-in time, leave status, etc."

CREATE TABLE attendance (
     attendance_id INT PRIMARY KEY AUTO_INCREMENT,
     employee_id INT,
     clock_in DATETIME,
     clock_out DATETIME,
     leave_status VARCHAR(50),
     created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
     updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

3. Salary Table

Prompt : "Please generate a salary table ( salaries) with employee ID, salary amount, payment date, etc."

CREATE TABLE salaries (
     salary_id INT PRIMARY KEY AUTO_INCREMENT,
     employee_id INT,
     amount DECIMAL(10, 2),
     payment_date DATE,
     created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
     updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

These SQL statements quickly establish the core data tables for employee information, attendance, and payroll.

Page Design: Using AMIS Page Generation Tool

Employee Management Pages

Employee List Page

AMIS Configuration Example :

{
     "type": "table",
     "title": "员工列表",
     "columns": [
         {"name": "employee_id", "label": "员工ID"},
         {"name": "name", "label": "姓名"},
         {"name": "position", "label": "职位"},
         {"name": "department", "label": "部门"},
         {"name": "salary", "label": "薪水"}
     ],
     "api": "/api/employees"
}

The table component displays employee information and supports filtering and sorting by department, position, and other fields.

Employee Detail Page

Uses card and form components to show detailed employee information including personal profile, attendance records, and salary history.

Attendance Management Pages

Attendance Record Page

AMIS Configuration Example :

{
     "type": "table",
     "title": "考勤记录",
     "columns": [
         {"name": "employee_id", "label": "员工ID"},
         {"name": "clock_in", "label": "打卡时间"},
         {"name": "clock_out", "label": "打卡时间"},
         {"name": "leave_status", "label": "请假状态"}
     ],
     "api": "/api/attendance"
}

The table component presents attendance data with filtering by date and employee ID.

Process Design: Using LogicFlow for Automated Business Logic

Leave Approval Workflow

Problem : When employees request leave or arrive late, the request must be approved; upon approval the attendance status is updated.

LogicFlow Process Design

Leave request submission : Employee submits leave request, triggering the LogicFlow process.

Approval process : Manager reviews the request; if approved, the attendance record is updated.

Attendance status update : Leave or late attendance records are updated, and the system automatically generates related reports.

Implementation Steps

Leave request submission : Automatic trigger when employee submits request.

Approval action : Manager approves/rejects; on approval, attendance record is updated.

Update attendance table : Modify attendance status for leave or late arrival.

LogicFlow Configuration Example

{
     "type": "flow",
     "nodes": [
         {
             "type": "start",
             "name": "员工提交请假申请"
         },
         {
             "type": "action",
             "name": "审批请假申请",
             "action": "approve_leave_request"
         },
         {
             "type": "decision",
             "name": "请假是否批准",
             "condition": "leave_approved = true",
             "yes": {
                 "type": "action",
                 "name": "更新考勤状态",
                 "action": "update_attendance"
             },
             "no": {
                 "type": "end",
                 "name": "结束流程"
             }
         }
     ]
}

Summary and Future Outlook

Using the Chengwu low-code platform, an enterprise-grade HRMS can be rapidly assembled. Deepseek accelerates database schema creation, AMIS enables visual frontend construction with table, card, and form components, and LogicFlow automates complex approval workflows. Together they deliver employee management, attendance tracking, payroll calculation, and performance evaluation efficiently.

Key Takeaways

Database design : Deepseek quickly defines and imports required database structures (employee, attendance, salary tables), ensuring normalized and consistent data storage.

Frontend page design : AMIS visual tooling rapidly builds management pages for employees, attendance, and payroll, greatly improving usability and efficiency.

Automated business logic : LogicFlow handles complex approval flows and automatic processing (e.g., leave requests, attendance updates), reducing manual intervention and ensuring accuracy and real-time data handling.

Future Extensions

Intelligent data analysis : Integrate AI/ML modules to predict and analyze employee performance and compensation.

Third-party system integration : Connect with attendance machines, financial systems, etc., to automate data flow and boost overall efficiency.

Mobile support : Develop mobile interfaces so employees can view and handle attendance, payroll, and leave anytime, anywhere.

The Chengwu low-code platform will remain a key tool for developing efficient enterprise systems, helping organizations achieve faster and more efficient application development and delivery during digital transformation.