bootstraptable

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
    <link rel="stylesheet" href="/static/bs/dist/css/bootstrap.css">
    <link rel="stylesheet" href="/static/bstable/src/extensions/editable/bootstrap-editable.css">
    <link rel="stylesheet" href="/static/bstable/dist/bootstrap-table.css">
    <script src="https://img.hcharts.cn/highcharts/highcharts.js"></script>
    <script src="https://img.hcharts.cn/highcharts/modules/exporting.js"></script>
    <script src="https://img.hcharts.cn/highcharts/modules/series-label.js"></script>
    <script src="https://img.hcharts.cn/highcharts/modules/oldie.js"></script>
    <script src="https://img.hcharts.cn/highcharts-plugins/highcharts-zh_CN.js"></script>
</head>
<body>

<h2>服务器列表管理</h2>

<div class="container">
    <div id="container" style="max-width:800px;height:400px"></div>
     <div id="toolbar" class="btn-group">
            <button id="btn_add" type="button" class="btn btn-default">
                <span class="glyphicon glyphicon-plus" aria-hidden="true"></span>新增
            </button>
            <button id="btn_delete" type="button" class="btn btn-danger">
                <span class="glyphicon glyphicon-remove" aria-hidden="true"></span>删除
            </button>
     </div>
    <table id="server">

    </table>
</div>


</body>

<script src="/static/js/jquery-1.12.4.js"></script>
<script src="/static/bs/dist/js/bootstrap.js"></script>
<script src="/static/bstable/dist/bootstrap-table.js"></script>
<script src="/static/bstable/dist/locale/bootstrap-table-zh-CN.js"></script>
<script src="/static/bstable/src/extensions/editable/bootstrap-table-editable.js"></script>
<script src="/static/bstable/bootstrap-editable.min.js"></script>

<script src="/static/bstable/src/extensions/export/bootstrap-table-export.js"></script>

<script src="/static/js/nblist.js"></script>
<script>

    var chart = Highcharts.chart('container', {
        title: {
            text: '2010 ~  年太阳能行业就业人员发展情况'
        },
        subtitle: {
            text: ':thesolarfoundation.com'
        },
        yAxis: {
            title: {
                text: 'xxxxxx'
            }
        },
        legend: {
            layout: 'vertical',
            align: 'right',
            verticalAlign: 'middle'
        },
        plotOptions: {
            series: {
                // label: {
                //     connectorAllowed: false
                // },
                pointStart: 2011
            }
        },
        series: [{
            name: '安装,实施人员',
            data: [43934, 52503, 57177, 69658, 97031, 119931, 137133, 154175]
        }, {
            name: '工人',
            data: [24916, 24064, 29742, 29851, 32490, 30282, 38121, 40434]
        }, {
            name: '销售',
            data: [11744, 17722, 16005, 19771, 20185, 24377, 32147, 39387]
        }, {
            name: '项目开发',
            data: [null, null, 7988, 12169, 15112, 22452, 34400, 34227]
        }, {
            name: '其他',
            data: [12908, 5948, 8105, 11248, 8989, 11816, 18274, 18111]
        }],
        tooltip:{
            'backgroundColor':'red'
        },
        credits:{
            enabled:true,
            text:'xxxxxx',
            href: 'http://www.baidu.com'
        }
    });










    $.fn.editable.defaults.mode = 'inline';
    $('#server').bootstrapTable({
                url: '/backend/ajax_server/',         //请求后台的URL(*)
                method: 'get',          //请求方式(*)
                toolbar: '#toolbar',    //工具按钮用哪个容器
                striped: true,          //是否显示行间隔色
                cache: false,     //是否使用缓存,默认为true,所以一般情况下需要设置一下这个属性(*)
                pagination: true,       //是否显示分页(*)
                sortable: true,        //是否启用排序
                sortOrder: "desc",       //排序方式
                sidePagination: "client",           //分页方式:client客户端分页,server服务端分页(*)
                pageNumber:1,                       //初始化加载第一页,默认第一页
                pageSize: 10,                       //每页的记录行数(*)
                pageList: [10, 25, 50, 100],        //可供选择的每页的行数(*)
                search: true,                       //是否显示表格搜索,此搜索是客户端搜索,不会进服务端,所以,个人感觉意义不大
                strictSearch: true,
                showPaginationSwitch: true,
                showColumns: true,                  //是否显示所有的列
                showRefresh: true,                  //是否显示刷新按钮
                clickToSelect: true,                //是否启用点击选中行
                uniqueId: "id",                     //每一行的唯一标识,一般为主键列
                showToggle:true,                    //是否显示详细视图和列表视图的切换按钮
                cardView: false,                    //是否显示详细视图
                showExport: true,                     //是否显示导出
                exportDataType: "basic",              //basic', 'all', 'selected'.


                onEditableSave: function (field, row, oldValue, $el) {

                    // delete row[0];
                    updata = {};
                    updata[field] = row[field];
                    updata['id'] = row['id'];
                    $.ajax({
                        type: "POST",
                        url: "/backend/modify/",
                        data: {postdata: JSON.stringify(updata), 'action': 'edit'},
                        success: function (data, status) {
                            if (status == "success") {
                                alert("编辑成功");
                            }
                        },
                        error: function () {
                            alert("Error");
                        },
                        complete: function () {
                        }
                    });
                },
                columns: [
                    {checkbox: true},
                    {
                        "field": 'id',
                        "title": 'id',
                    },
                    {
                        "field": 'hostname',
                        "title": '主机名',
                        editable: {
                            type: 'text',

                            validate: function (v) {
                                if (!v) return '用户名不能为空';
                            }
                        }
                    },
                    {
                        "field": 'sn',
                        "title": 'sn号',
                    }
                ]
            });


    $("#btn_delete").click(function(){
        deleteData('server');
    });


    function deleteData(tableid) {
            //获取所有被选中的记录
            var rows = $("#"+tableid).bootstrapTable('getSelections');
            console.log(rows);


            if (rows.length== 0) {
                alert("请先选择要删除的记录!");
                return;
            }
            var ids = [];
            for (var i = 0; i < rows.length; i++) {
                ids.push(rows[i]['id']);
            }


            console.log(ids);
            var msg = "您真的确定要删除吗?";
            if (confirm(msg) == true) {
                $.ajax({
                    url: "/backend/modify/",
                    type: "post",
                    traditional: true,
                    data: {'ids': ids, 'action':'del'},
                    success: function (data) {
                        alert(data);
                        //重新加载数据
                        $("#servers").bootstrapTable('refresh');
                    }
                });
            }
        }
</script>


</html>

 

posted @ 2020-09-06 17:45  xuqidong  阅读(127)  评论(0编辑  收藏  举报