同城家政小程序搭建指南：快速落地上门预约O2O服务平台

 用户小程序
      |
师傅端 ---- API服务层 ---- 平台管理后台
      |
     数据库

CREATE TABLE service_item (
 id INT PRIMARY KEY AUTO_INCREMENT,
 category_id INT COMMENT '服务分类ID',
 name VARCHAR(100) COMMENT '服务名称',
 image VARCHAR(255) COMMENT '服务封面图',
 price DECIMAL(10,2) COMMENT '基础价格',
 unit VARCHAR(20) COMMENT '计价单位：小时/次/㎡',
 status TINYINT DEFAULT 1 COMMENT '1上架 0下架'
);

router.get('/service/list', async(req,res)=>{
    const serviceList = await ServiceItem.findAll({
        where:{
            status:1
        }
    })
    res.json({
        code:200,
        data:serviceList
    })
})

function calculateOrderAmount(serviceItem,extendParams){
    let total = serviceItem.price;
    // 处理附加费用：超时费、加急费、面积加价
    if(extendParams.urgent === true){
        total += extendParams.urgentFee
    }
    return total;
}

async function createWorkOrder(userId,serviceItem,extendParams){
    const amount = calculateOrderAmount(serviceItem,extendParams);
    const order = await WorkOrder.create({
        user_id:userId,
        service_id:serviceItem.id,
        appoint_time:extendParams.appointTime,
        address:extendParams.address,
        remark:extendParams.remark,
        amount:amount,
        status:'待支付'
    });
    return order;
}

待支付
 |
已支付
 |
待派单
 |
师傅已接单
 |
师傅出发上门
 |
服务进行中
 |
待用户验收
 |
已完成

const workOrderStatus={
    WAIT_PAY:1,
    WAIT_DISPATCH:2,
    ACCEPTED:3,
    ON_WAY:4,
    SERVICING:5,
    WAIT_CHECK:6,
    FINISH:7
}

router.post('/worker/acceptOrder',async(req,res)=>{
    let orderId=req.body.orderId;
    let workerId=req.body.workerId;
    await WorkOrder.update({
        worker_id:workerId,
        status:3
    },{
        where:{
            id:orderId
        }
    })
    res.json({
        message:"接单成功"
    })
})

function getServiceRoute(start,end){
    return axios.get(
        "[https://api.map.com/direction](https://api.map.com/direction)",
        {
            params:{
                origin:start,
                destination:end
            }
        }
    )
}

用户提交预约工单
↓
生成业务工单记录
↓
调用微信支付接口
↓
用户完成支付
↓
接收微信回调，更新工单状态

router.post('/pay/notify', async(req,res)=>{
    let orderId=req.body.orderId;
    await WorkOrder.update({
        status:"待派单"
    },{
        where:{
            id:orderId
        }
    });
    res.send("success");
})

SELECT 
DATE(create_time) AS day, COUNT(*) AS order_count
FROM work_order
GROUP BY day;

SELECT 
SUM(amount) AS total_income
FROM work_order
WHERE status=7;

housekeeping-system

├── user          用户模块
├── service       家政服务类目模块
├── order         预约工单模块
├── worker        师傅人员管理
├── dispatch      派单调度模块
├── payment       支付模块
└── admin         平台后台