Implementation method of reservation ordering function in food ordering system developed with Go language

With the advent of the digital era, various industries are accelerating digital transformation, and the catering industry is no exception. More and more restaurants are beginning to use ordering systems to provide customers with a more convenient and efficient dining experience. Among them, reservation ordering is a very popular ordering method. It allows customers to place orders and pay in advance before arriving at the store, reducing customer waiting time and bringing better revenue to the restaurant.

This article will introduce how to use Go language to develop a reservation ordering system, mainly including the following aspects: database design, interface design and code examples.

1. Database design

The database of the system needs to save the following information:

1. User information (user_info): including user name, password, mobile phone number, email, etc. Information;
2. Recipe information (menu_info): including dish name, price, picture and other information;
3. Order information (order_info): including order number, reservation time, dining time, number of diners and other information ;
4. Dish order information (menu_order_info): includes order number, dish ID, quantity and other information.

2. Interface design

1. User login interface

    func login(username string, password string) bool {
        // 在数据库中查询是否存在该用户，密码是否正确
        // 如果存在，则返回true，否则返回false
    }

2. Get menu list interface

    type Menu struct {
        Id int
        Name string
        Price float64
        Image string
    }

    func getMenuList() []Menu {
        // 查询数据库，获取菜品列表信息
        // 将信息封装为Menu类型的slice返回
    }

3. Reservation interface

    type MenuOrder struct {
        MenuId int
        Count int
    }

    func reserve(username string, orderTime string, eatTime string, eatNumber int, menuOrder []MenuOrder) bool {
        // 生成订单编号
        // 在订单表中新增一条订单信息
        // 在菜品订单表中新增相关信息
        // 返回预约结果（成功或失败）
    }

4. Query order interface

    type OrderInfo struct {
        OrderId int
        OrderTime string
        EatTime string
        EatNumber int
        MenuList []MenuOrder
        Status int   // 1表示预约成功，2表示已就餐，3表示已取消
    }

    func getOrderList(username string) []OrderInfo {
        // 查询指定用户的订单信息
        // 将信息封装为OrderInfo类型的slice返回
    }

3. Code example

1. User login interface

    func login(username string, password string) bool {
        db, err := sql.Open("mysql", "root:password@tcp(localhost:3306)/restaurant")
        if err != nil {
            log.Fatal(err)
        }
        defer db.Close()

        rows, err := db.Query("SELECT * FROM user_info WHERE username = ? AND password = ?", username, password)
        if err != nil {
            log.Fatal(err)
        }
        defer rows.Close()

        if rows.Next() {
            return true
        } else {
            return false
        }
    }

2. Get the menu list interface

    type Menu struct {
        Id int
        Name string
        Price float64
        Image string
    }

    func getMenuList() []Menu {
        db, err := sql.Open("mysql", "root:password@tcp(localhost:3306)/restaurant")
        if err != nil {
            log.Fatal(err)
        }
        defer db.Close()

        rows, err := db.Query("SELECT id, name, price, image FROM menu_info")
        if err != nil {
            log.Fatal(err)
        }
        defer rows.Close()

        var menuList []Menu
        for rows.Next() {
            var id int
            var name string
            var price float64
            var image string
            err := rows.Scan(&id, &name, &price, &image)
            if err != nil {
                log.Fatal(err)
            }

            menu := Menu{
                Id: id,
                Name: name,
                Price: price,
                Image: image,
            }
            menuList = append(menuList, menu)
        }
        return menuList
    }

3. Reservation interface

    type MenuOrder struct {
        MenuId int
        Count int
    }

    func reserve(username string, orderTime string, eatTime string, eatNumber int, menuOrder []MenuOrder) bool {
        db, err := sql.Open("mysql", "root:password@tcp(localhost:3306)/restaurant")
        if err != nil {
            log.Fatal(err)
        }
        defer db.Close()

        tx, err := db.Begin()
        if err != nil {
            log.Fatal(err)
        }

        stmt1, err := tx.Prepare("INSERT INTO order_info(order_time, eat_time, eat_number, status) VALUES (?, ?, ?, ?)")
        if err != nil {
            tx.Rollback()
            log.Fatal(err)
        }
        defer stmt1.Close()

        res, err := stmt1.Exec(orderTime, eatTime, eatNumber, 1) // 预约成功
        if err != nil {
            tx.Rollback()
            log.Fatal(err)
        }

        orderId, err := res.LastInsertId()
        if err != nil {
            tx.Rollback()
            log.Fatal(err)
        }

        stmt2, err := tx.Prepare("INSERT INTO menu_order_info(order_id, menu_id, count) VALUES (?, ?, ?)")
        if err != nil {
            tx.Rollback()
            log.Fatal(err)
        }
        defer stmt2.Close()

        for _, menu := range menuOrder {
            _, err := stmt2.Exec(orderId, menu.MenuId, menu.Count)
            if err != nil {
                tx.Rollback()
                log.Fatal(err)
            }
        }

        err = tx.Commit()
        if err != nil {
            tx.Rollback()
            log.Fatal(err)
        }

        return true
    }

4. Query order interface

    type OrderInfo struct {
        OrderId int
        OrderTime string
        EatTime string
        EatNumber int
        MenuList []MenuOrder
        Status int   // 1表示预约成功，2表示已就餐，3表示已取消
    }

    func getOrderList(username string) []OrderInfo {
        db, err := sql.Open("mysql", "root:password@tcp(localhost:3306)/restaurant")
        if err != nil {
            log.Fatal(err)
        }
        defer db.Close()

        rows, err := db.Query("SELECT order_info.id, order_time, eat_time, eat_number, status, menu_id, count FROM order_info INNER JOIN menu_order_info ON order_info.id = menu_order_info.order_id WHERE username = ?", username)
        if err != nil {
            log.Fatal(err)
        }
        defer rows.Close()

        var orderList []OrderInfo
        for rows.Next() {
            var orderId int
            var orderTime string
            var eatTime string
            var eatNumber int
            var status int
            var menuId int
            var count int
            err := rows.Scan(&orderId, &orderTime, &eatTime, &eatNumber, &status, &menuId, &count)
            if err != nil {
                log.Fatal(err)
            }

            var order *OrderInfo
            for i, item := range orderList {
                if item.OrderId == orderId {
                    order = &orderList[i]
                    break
                }
            }

            if order == nil {
                order = &OrderInfo{
                    OrderId: orderId,
                    OrderTime: orderTime,
                    EatTime: eatTime,
                    EatNumber: eatNumber,
                    Status: status,
                    MenuList: make([]MenuOrder, 0),
                }
                orderList = append(orderList, *order)
            }

            menuOrder := MenuOrder{
                MenuId: menuId,
                Count: count,
            }
            order.MenuList = append(order.MenuList, menuOrder)
        }
        return orderList
    }

4. Summary

This article introduces the method of using Go language to develop a reservation ordering system, and provides detailed code examples. By studying this article, readers can master the basic principles and implementation methods of the reservation ordering system, and provide technical support for the development of similar systems. In addition, we also need to pay attention to maintaining the stability and security of the system, such as preventing SQL injection, authentication and other security issues.

The above is the detailed content of Implementation method of reservation ordering function in food ordering system developed with Go language. For more information, please follow other related articles on the PHP Chinese website!