Automating Handcraft Workshop Delivery with Chengwu Low-Code Platform & LogicFlow

1. Finished Product Delivery Management Requirements

In handcraft workshop operations, finished product delivery is a critical step involving multiple management aspects: from raw material usage records to loss ratio calculation, and finally to finished product quality inspection and delivery confirmation. Efficient delivery management improves work efficiency, ensures product quality, avoids raw material waste, and reduces operational costs.

Handcraft workshops typically rely on part-time personnel distributed across locations who receive materials and deliver finished goods via courier. Therefore, automation and precision in delivery management are essential.

2. Database Design and Table Structure Generation

2.1 Table Design

Based on the workshop business process, the following main tables are designed, with relationships established through associated fields rather than foreign keys:

Worker table ( worker ) : Records part-time personnel basic information including name, contact, assigned tasks.

Batch table ( batch ) : Records detailed information for each production batch, including batch number, production task, progress.

Raw Materials table ( raw_materials ) : Records all raw material basic information including name, quantity, purchase price.

Material Issue table ( material_issue ) : Records raw material issuance for each batch, linked to batch and raw material tables.

Finished Goods Delivery table ( finished_goods_delivery ) : Records delivery status, updates raw material usage status, loss ratio.

Sales table ( sales ) : Records finished goods sales including quantity sold, sale price.

Manual Fee Settlement table ( manual_fee ) : Records part-time personnel fee settlement including status, settlement voucher upload.

2.2 SQL Statements (Without Primary/Foreign Keys)

In the Chengwu low-code platform, SQL can be automatically generated via AI tools, simplifying table design. Below are simplified SQL statements without foreign keys, with concise field descriptions:

1. Worker Table ( worker )

CREATE TABLE `worker` (</code><code>  `name` VARCHAR(255) NOT NULL COMMENT '兼职人员姓名',</code><code>  `contact` VARCHAR(20) NOT NULL COMMENT '联系电话',</code><code>  `address` VARCHAR(255) NOT NULL COMMENT '收货地址',</code><code>  `status` VARCHAR(50) NOT NULL COMMENT '人员状态'</code><code>) COMMENT='兼职人员表';

2. Batch Table ( batch )

CREATE TABLE `batch` (</code><code>  `batch_number` VARCHAR(50) NOT NULL COMMENT '批次编号',</code><code>  `task_description` VARCHAR(255) NOT NULL COMMENT '生产任务描述',</code><code>  `worker_id` INT NOT NULL COMMENT '兼职人员ID',</code><code>  `start_date` DATETIME NOT NULL COMMENT '生产开始时间',</code><code>  `end_date` DATETIME DEFAULT NULL COMMENT '生产结束时间',</code><code>  `status` VARCHAR(50) NOT NULL COMMENT '批次状态'</code><code>) COMMENT='批次表';

3. Raw Materials Table ( raw_materials )

CREATE TABLE `raw_materials` (</code><code>  `name` VARCHAR(255) NOT NULL COMMENT '原材料名称',</code><code>  `quantity` INT NOT NULL COMMENT '库存数量',</code><code>  `unit_price` DOUBLE NOT NULL COMMENT '单价'</code><code>) COMMENT='原材料表';

4. Material Issue Table ( material_issue )

CREATE TABLE `material_issue` (</code><code>  `batch_id` INT NOT NULL COMMENT '批次ID',</code><code>  `material_id` INT NOT NULL COMMENT '原材料ID',</code><code>  `quantity_issued` INT NOT NULL COMMENT '领取数量',</code><code>  `issue_date` DATETIME NOT NULL COMMENT '领取日期'</code><code>) COMMENT='原材料领取表';

5. Finished Goods Delivery Table ( finished_goods_delivery )

CREATE TABLE `finished_goods_delivery` (</code><code>  `batch_id` INT NOT NULL COMMENT '批次ID',</code><code>  `delivery_date` DATETIME NOT NULL COMMENT '交付日期',</code><code>  `status` VARCHAR(50) NOT NULL COMMENT '交付状态',</code><code>  `material_usage` TEXT NOT NULL COMMENT '原材料使用情况',</code><code>  `loss_ratio` DOUBLE NOT NULL COMMENT '损耗比',</code><code>  `quality_check_status` VARCHAR(50) NOT NULL COMMENT '质量检查状态'</code><code>) COMMENT='成品交付表';

6. Sales Table ( sales )

CREATE TABLE `sales` (</code><code>  `finished_goods_id` INT NOT NULL COMMENT '成品ID',</code><code>  `quantity_sold` INT NOT NULL COMMENT '销售数量',</code><code>  `sale_price` DOUBLE NOT NULL COMMENT '售价',</code><code>  `sale_date` DATETIME NOT NULL COMMENT '销售日期',</code><code>  `batch_id` INT NOT NULL COMMENT '来源批次ID'</code><code>) COMMENT='成品售卖表';

7. Manual Fee Settlement Table ( manual_fee )

CREATE TABLE `manual_fee` (</code><code>  `worker_id` INT NOT NULL COMMENT '兼职人员ID',</code><code>  `batch_id` INT NOT NULL COMMENT '批次ID',</code><code>  `fee_amount` DOUBLE NOT NULL COMMENT '结算金额',</code><code>  `settlement_status` VARCHAR(50) NOT NULL COMMENT '结算状态',</code><code>  `settlement_date` DATETIME DEFAULT NULL COMMENT '结算日期',</code><code>  `settlement_proof` VARCHAR(255) DEFAULT NULL COMMENT '结算凭证'</code><code>) COMMENT='手工费结算表';

2.3 Generating SQL with DeepSeek and Importing to Database

Using the Chengwu low-code platform's DeepSeek tool, developers can quickly generate SQL statements and import them into MySQL. Based on these table designs and page generation requirements, developers can proceed with subsequent system development and feature implementation.

3. Auto-Generating CRUD Pages and Process Design

3.1 Page Generation

In the Chengwu low-code platform, users generate pages based on database tables. Through the platform's Resource Management module, selecting tables to manage (e.g., worker, batch, raw_materials) automatically generates corresponding CRUD pages.

Batch Management Page : View, edit, delete, search batch information.

Worker Management Page : Record worker basic info, task assignments.

Material Issue Page : View material quantities issued per batch, with edit and delete capabilities.

Finished Goods Delivery Page : Record batch delivery status, material usage, loss ratio.

3.2 Process Orchestration and Finished Product Delivery Process

The finished product delivery step involves multiple stages closely tied to raw material usage status, loss ratio, and quality inspection. Using the Chengwu low-code platform's Process Orchestration feature, an automated delivery workflow can be designed.

1. Designing Finished Product Delivery Process

Using the platform's visual drag-and-drop design tool, multiple nodes can be dragged in the LogicFlow module to configure the entire delivery process:

Start Node : Triggers when batch production completes.

Quality Check Node : Checks if product passes. If failed, flow jumps to Issue Handling node; if passed, continues.

Update Material Usage Status Node : After delivery, automatically updates raw material usage status, records material consumption per batch, and calculates loss ratio.

Loss Ratio Calculation Node : System calculates loss ratio per batch based on material usage, ensuring data accuracy.

Finished Goods Delivery Node : After quality pass and material update, delivery status becomes Delivered and delivery record is generated.

Manual Fee Settlement Node : Automatically generates fee settlement records for each part-time worker and updates status upon completion.

2. Configuring Process Nodes

By dragging process nodes, each step's operations and conditions can be configured:

Quality Check Node : Set pass/fail condition. On fail, jump to Issue Handling ; on pass, continue.

Update Material Usage Node : System automatically retrieves data from Material Issue table to update material usage. This node can also compute loss ratio via formula.

Loss Ratio Calculation Node : Uses simple formula loss_ratio = quantity_used / quantity_issued to automatically calculate and store loss ratio in database for production efficiency analysis.

Finished Goods Delivery Node : After all steps, automatically updates batch delivery status to Delivered and generates delivery record stored in Finished Goods Delivery table for traceability.

Manual Fee Settlement Node : Based on delivery outcome, automatically calculates worker fees, supports voucher upload, and updates settlement status automatically.

4. Configuring Menus, Roles, and Users

4.1 Configuring Menus

Create Menus : Create menu items such as Worker Management , Batch Management , Raw Material Management , Finished Goods Delivery Management for a clean, clear interface.

Associate Functions : Link functional pages to menus so users can quickly access relevant pages.

4.2 Configuring Roles and Permissions

Create Roles : e.g., Administrator , Part-time Worker , Auditor .

Assign Permissions : Grant each role appropriate access rights, ensuring users only operate pages and data within their permission scope.

4.3 Configuring Users

Assign roles to each user to ensure correct access permissions and data security.

5. Summary

By using the Chengwu low-code platform , handcraft workshops can efficiently manage part-time personnel, batch production, raw material issuance, finished product delivery, quality inspection, loss ratio calculation, sales, and manual fee settlement. In particular, the platform's LogicFlow process orchestration automates the delivery step, greatly improving production efficiency while ensuring data accuracy and real-time updates. Drag-and-drop workflow design enables workshops to easily complete delivery, material usage updates, loss ratio calculation, and fee settlement, ensuring efficient and precise execution at every stage.

This automated management approach reduces manual operations, improves work efficiency, and provides part-time workers with a smoother experience, driving overall operational optimization for handcraft workshops.