# 模块标题
sys_title: "Template Demo - Master & Slave"
sys_title_en: "Template Demo - Master & Slave"
sys_title_zhcn: "主从表展示"
sys_title_zhtw: ""
# 模块图标
sys_icon: "wpforms"
# 模块对应的插件DLL名称
sys_plugin: "toptemplateclassplugin"
# 模块对应的类名
sys_class: "TopTemplateClass5"
# 许可证验证键
sys_license_key: ""
# 打开模块的权限
sys_open_right: ""
# 语言包，默认包含自己模块的语言包
sys_lang_list: []
# 当关闭窗口时，如果提示是否保存，保存调用的action
sys_save_action: ""
# 该模块用到的枚举列表
sys_enum_list: [
  "pdm-job-status"
]
# 该模块用到的除了Action之外的权限列表
sys_permission_list: []

navi: {
    __type__: UiLoader
}

# 主表格
master_view {
  # 数据项， 默认包含表头中配置的数据项
  data_keys: [ "id" ]
  # 主键
  primary_key: "id"
  # 水平表头
  horizontal_header: [
    { 
      "name": "id",
      "display": "Group ID",
      "displayRole": "$id"
    },
    {
      "name": "name",
      "display": "Group Name",
      "displayRole": "$name",
      "width": 150,
      "search": "string"
    },
    { 
      "name": "title",
      "display": "Group Title",
      "displayRole": "$title",
      "sorting_enabled": 0
    }
  ]
  # 默认排序列
  sort_by: "id DESC"
  # 数据集
  data_set {
    # 数据库表名
    db_table_name: "pdm_spec_group"
    # 若有sql, 以sql为最优先
    # 若无sql, 默认根据表头的配置进行查询
    db_sql: ""
  }
  # 主从表关系配置
  relation {
    type: "hasMany"
    through: "pdm_spec_group_lnk_spec"
    master_foreign_key: "group_id"
    master_key: "id"
    slave_foreign_key: "spec_name"
    slave_key: "name"
  }
}

# 从表格
slave_view {
  # 数据项， 默认包含表头中配置的数据项
  data_keys: [ "id" ]
  # 主键
  primary_key: "id"
  # 水平表头
  horizontal_header: [
    {
      "name": "id",
      "display": "Spec ID",
      "displayRole": "$id",
      "width": 150
    },
    {
      "name": "name",
      "display": "Spec Name",
      "displayRole": "$name"
    },
    { 
      "name": "title",
      "display": "Spec Title",
      "displayRole": "$title",
      "sorting_enabled": 0
    },
    { 
      "name": "category",
      "display": "Spec Category",
      "displayRole": "$category",
      "sorting_enabled": 0
    }
  ]
  # 默认排序列
  sort_by: "id DESC"
  # 数据集
  data_set {
    # 数据库表名
    db_table_name: "pdm_spec"
    # 若有sql, 以sql为最优先
    # 若无sql, 默认根据表头的配置进行查询
    db_sql: ""
  }
}