首页 > 解决方案 > 合并两个 JavaScript 插件

问题描述

我创建了一个 php 页面,该页面显示来自 mysql 数据库的用户表并具有许多功能;使用 tabledit 插件编辑或删除每一行并显示/隐藏选定的列,搜索.. 使用数据表插件的用户。我面临的问题是这两个插件似乎不能同时工作,有什么建议吗?下面是管理这些功能的 JavaScript 代码:

<script >

$(document).ready(function(){
  
  
  
  var dataTable = $('#editable_table').DataTable({
    "processing" : true,
    "serverSide" : true,
    "order" : [],
    "ajax" : {
      url:"fetch.php",
      type:"POST"
    }
  });
  
  $('#column_name').selectpicker();

  $('#column_name').change(function(){

    var all_column = ["0", "1", "2", "3", "4","5","6","7","8","9","10","11","12","13","14","15","16","17"];

    var remove_column = $('#column_name').val();

    var remaining_column = all_column.filter(function(obj) { return remove_column.indexOf(obj) == -1; });

    dataTable.columns(remove_column).visible(false);

    dataTable.columns(remaining_column).visible(true);

  });
}); 
</script>

<script>  
$(document).ready(function(){  
     $('#editable_table').Tabledit({
      url:'../action.php',
      columns:{
       identifier:[0, "user_id"],
       editable:[
         [1, 'full_name'], [2, 'username'], [3, 'password']
       , [4, 'mobile_phone'], [5, 'email'], [6, 'role']
       , [7, 'p_a_sejel'], [8, 'p_a_gender'], [9, 'p_a_age_range']
       , [10, 'p_a_family'], [11, 'e'], [12, 'i']
       , [14, 'expiry_date'], [17, 'a']]
      },
      restoreButton:false,
      onSuccess:function(data, textStatus, jqXHR)
      {
       if(data.action == 'delete')
       {
        $('#'+data.id).remove();
       }
      }
     });
 
});  
 </script>

标签: javascriptdatatablestabledit

解决方案


推荐阅读