Golang模板中如何在同一HTML表格内遍历两个切片

在Golang模板中同时遍历两个切片需要使用索引来对齐数据。你的代码问题在于内层循环会遍历所有users，而不是匹配当前userAccount的user。以下是解决方案：

{{ define "useraccount/list.html" }}
{{ template "01Temps/header.html" . }}
<table border="1">
    <tr align="right">
        <th>USER</th>
        <th>FullName</th>
        <th>Email</th>
        <th>Department</th>
        <th>Level</th>
        <th>Role</th>
        <th>Action</th>
    </tr>
    <tbody id="myTbl">
        {{range $index, $account := .userAccounts}}
        <tr align="left">
            <td>
                <a href="/user/getrecord/{{$account.UserRefer}}"
                    onclick="return confirm('Redirect to USER:{{$account.UserRefer}} ?')">
                    USR:{{$account.UserRefer}}</a>
            </td>
            
            {{if lt $index (len $.users)}}
            {{$user := index $.users $index}}
            <td>{{$user.FullName}}</td>
            <td>{{$user.Email}}</td>
            {{else}}
            <td>N/A</td>
            <td>N/A</td>
            {{end}}
            
            <td>{{$account.Department}}</td>
            <td>{{$account.SystemLevel}}</td>
            <td>{{$account.CompanyRank}}</td>
            <td>
                <a href="/useraccount/updaterecord/{{$account.Id}}"
                    onclick="return confirm('Update USER:{{$account.UserRefer}} ?')">Update</a>
                <label>||</label>
                <a href="/useraccount/deleterecord/{{$account.Id}}"
                    onclick="return confirm('Delete USER:{{$account.UserRefer}} ?')">Del</a>
                <label>||</label>
                <a href="/useraccount/getrecord/{{$account.Id}}"
                    onclick="return confirm('Display USER:{{$account.UserRefer}} ?')">Display</a>
            </td>
        </tr>
        {{end}}
    </tbody>
</table>
{{ template "01Temps/footer.html" . }}
{{end}}

对于外键问题，如果你需要存储用户全名的冗余字段，可以这样修改结构体：

type UserAccount struct {
    Id              uint64 `gorm:"primaryKey"`
    CompanyRank     string `json:"company_rank"`
    SystemLevel     string `json:"system_level"`
    Department      string `json:"department"`
    UserRefer       int    `json:"fkuser_id"`
    UserFullName    string `json:"fkuser_full_name"` // 冗余字段
    User            User   `gorm:"foreignKey:UserRefer"`
}

然后在查询时填充这个字段：

func (h handler) GetUserAccounts(ctx *gin.Context) {
    userAccounts := []model.UserAccount{}
    links := model.BodyNLinks()
    links.Title = "Roles List"
    links.Heading = "Roles List"

    if result := h.DB.Preload("User").Find(&userAccounts); result.Error != nil {
        ctx.AbortWithError(http.StatusNotFound, result.Error)
        return
    }

    // 填充冗余字段
    for i := range userAccounts {
        userAccounts[i].UserFullName = userAccounts[i].User.FullName
    }

    ctx.HTML(200, "useraccount/list.html", gin.H{
        "userAccounts": userAccounts,
        "link":         links,
    })
}

这样在模板中可以直接使用：

<td>{{$account.UserFullName}}</td>

更好的做法是使用GORM的Preload预加载关联数据，这样就不需要单独查询users切片：

func (h handler) GetUserAccounts(ctx *gin.Context) {
    userAccounts := []model.UserAccount{}
    links := model.BodyNLinks()
    links.Title = "Roles List"
    links.Heading = "Roles List"

    if result := h.DB.Preload("User").Find(&userAccounts); result.Error != nil {
        ctx.AbortWithError(http.StatusNotFound, result.Error)
        return
    }

    ctx.HTML(200, "useraccount/list.html", gin.H{
        "userAccounts": userAccounts,
        "link":         links,
    })
}

然后在模板中通过关联访问：

{{range $account := .userAccounts}}
<tr align="left">
    <td>
        <a href="/user/getrecord/{{$account.UserRefer}}"
            onclick="return confirm('Redirect to USER:{{$account.UserRefer}} ?')">
            USR:{{$account.UserRefer}}</a>
    </td>
    
    <td>{{$account.User.FullName}}</td>
    <td>{{$account.User.Email}}</td>
    
    <td>{{$account.Department}}</td>
    <td>{{$account.SystemLevel}}</td>
    <td>{{$account.CompanyRank}}</td>
    <td>
        <a href="/useraccount/updaterecord/{{$account.Id}}"
            onclick="return confirm('Update USER:{{$account.UserRefer}} ?')">Update</a>
        <label>||</label>
        <a href="/useraccount/deleterecord/{{$account.Id}}"
            onclick="return confirm('Delete USER:{{$account.UserRefer}} ?')">Del</a>
        <label>||</label>
        <a href="/useraccount/getrecord/{{$account.Id}}"
            onclick="return confirm('Display USER:{{$account.UserRefer}} ?')">Display</a>
    </td>
</tr>
{{end}}