我目前正在尝试使用jtable.org jquery在我的网站上实现table。到目前为止,我已经设法显示了州选项,但城市选项显示为空白。(city_id选项依赖于state_id)。我试了几个小时才发现出了什么问题。
下面是我的javascript:
$(document).ready(function () {
//Prepare jTable
$('#practice_loc').jtable({
paging: false,
pageSize: 1,
sorting: false,
defaultSorting: 'Name ASC',
actions: {
listAction: 'blah.php?action=list',
createAction: 'blah.php?action=create',
updateAction: 'blah.php?action=update',
deleteAction: 'blah.php?action=delete'
},
fields: {
id: {
key: true,
create: false,
edit: false,
list: false
},
name: {
title: 'Nama',
width: '20%'
},
address: {
title: 'Alamat',
width: '40%'
},
phone: {
title: 'Telepon',
width: '20%'
},
type: {
title: 'Jenis',
width: '20%'
},
state_id: {
title: 'Provinsi',
options: 'query/get_common_list.php?action=list_state',
list: false
},
city_id: {
title: 'Kota',
dependsOn: 'stateId', //Cities depends on state (province).
list: false,
options: function(data) {
return 'query/get_common_list.php?action=list_city&state_id=' + data.dependedValues.state_id;
}
}
}
});
请确保dependsOn中引用的字段是正确的。我发现没有下划线的字段名称错误,请将dependsOn:'stateId'更改为dependsOn:'state_id',。此外,在以下字段返回state_id
值:
state_id: {
title: 'Provinsi',
options: 'query/get_common_list.php?action=list_state',
list: false,
display: function (data) { return data.record.state_id;},
},