Django中的DataTables修改列顺序

# views.py
from django.shortcuts import render
from .models import YourModel

def your_view(request):
    data = YourModel.objects.all()
    # 根据需要调整列顺序
    columns_order = ['column1', 'column2', 'column3']
    ordered_data = [{col: getattr(item, col) for col in columns_order} for item in data]
    return render(request, 'your_template.html', {'data': ordered_data})

<!-- your_template.html -->
<!DOCTYPE html>
<html>
<head>
    <title>DataTables Example</title>
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.25/css/jquery.dataTables.css">
    <script type="text/javascript" charset="utf8" src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.10.25/js/jquery.dataTables.js"></script>
</head>
<body>
    <table id="example" class="display" style="width:100%">
        <thead>
            <tr>
                <th>Column 1</th>
                <th>Column 2</th>
                <th>Column 3</th>
            </tr>
        </thead>
        <tbody>
            {% for item in data %}
            <tr>
                <td>{{ item.column1 }}</td>
                <td>{{ item.column2 }}</td>
                <td>{{ item.column3 }}</td>
            </tr>
            {% endfor %}
        </tbody>
    </table>

    <script>
        $(document).ready(function() {
            $('#example').DataTable({
                "columns": [
                    { "data": "column1" },
                    { "data": "column2" },
                    { "data": "column3" }
                ]
            });
        });
    </script>
</body>
</html>