Python分页案例

我不是女神ヾ 2024-04-17 05:28 75阅读 0赞

from django.http import HttpResponse
    from django.http import JsonResponse
    from django.core import serializers
    from polls.models import *
    import datetime
    import time
    from django.db.models import Sum
    from django.core.paginator import Paginator
    from django.forms.models import model_to_dict
    
    
    def GetRetainData(request):
        """
        留存数据
        """
    
        beginTime = request.GET.get('begintime') if request.GET.get('begintime') else "2010-07-8"
        endTime = request.GET.get('endtime') if request.GET.get('endtime') else "2019-07-8"
    
    
        #转换成时间戳
        start = int(time.mktime(time.strptime(beginTime, "%Y-%m-%d")))
        end = int(time.mktime(time.strptime(endTime, "%Y-%m-%d")))
    
    
        obj = TbUserStatistics.objects.filter(time__range=(start,end)).order_by('time').all() #时间段查询
        
    
        #分页
        paginator = Paginator(obj, 2)  #每页条数
        page = request.GET.get('page') #页码
        data = paginator.get_page(page)
        
        #print(obj.query)  #打印sql
        #print(data,data.object_list)
        # data = model_to_dict(obj.first()) #将model转成字典格式
        
        data_list = []
        dnu_sum = 0
    
        for i in data.object_list:
            data_list.append(model_to_dict(i))
            dnu_sum += i.dnu  #统计总数
    
    
        des = {}
        des['data_list'] = data_list
        des['dnu_sum'] = dnu_sum
    
        return JsonResponse(des,safe=False)

2.完整分页带前端代码

views.py：

from polls.models import *
    from django.core.paginator import Paginator
    from django.shortcuts import render
    
    
    type_list = TbProjectStatistics.objects.all().values('localtype') #下拉框数据
    
    obj = TbProjectDownload.objects.all()[:5]  #查询5条数据
    
    #分页
    paginator = Paginator(obj, 2)  # 每页2条
    
    page = request.GET.get('page') #页码参数
    
    data = paginator.get_page(page)
    
    return render(request, 'index.html', {'type_list':type_list,'data':data})

html：

<!DOCTYPE html>
    <html lang="en">
    <head>
        <style>
            ul{list-style-type:none}
            .d1{
                position: absolute;
                left: 0;
                top: 108px;
                width: 174px;
                height: 779px;
                overflow-x: hidden;
                overflow-y: auto;
                padding: 5px 0 0 5px;
                border-right: 1px solid #D7D7D7;
                background-color: #39bfbb;
            }
            .d2{
                margin-left: 200px;margin-top: 110px;
            }
            .d4{
                margin-top: 20px;
            }
            .d4 table{ background:#39bfbb}
            .d4 table td{ background: #FFF}
            .d4 table tr{ background: #FFF}
            a {
                font-size: 16px;
                text-decoration: none;
                color: blue;
            }
            .th-m{
                padding-left: 100px;
                padding-right: 100px;
            }
            .td-c{
                text-align: center;
            }
            .d5{
                margin-top: 20px;
            }
    
        </style>
        <meta charset="UTF-8">
        <title>Title</title>
    </head>
    <body>
        
        <div class="d1">
            <ul>
                <li><a href="retain_data"><span><font>留存数据</font></span></a></li>
                <li><a href="product_data"><span><font>产品数据</font></span></a></li>
                <li><a href="download_data"><span><font>下载数据</font></span></a></li>
            </ul>
        </div>
    
        
        <div class="d2">
            <div class="d3">
                  位置：
                <select name="name" id="">
                    <option value="">--请选择--</option>
                    {% if type_list %}
                        {% for item in type_list %}
                            <option value="{
       { item.localtype }}">{
       { item.localtype }}</option>
                        {% endfor %}
                    {% endif %}
                </select>
                  <button>搜索</button>
            </div>
    
            
            <div class="d4">
                <table border="0" cellspacing="1" cellpadding="0">
                    <tr>
                        <th class="th-m">下载时间</th>
                        <th  class="th-m">下载次数</th>
                        <th  class="th-m">浏览</th>
                    </tr>
                    {% if data %}
                        {% for item in data %}
                            <tr>
                                <td class="td-c">{
       { item.time }}</td>
                                <td class="td-c">{
       { item.download_count }}</td>
                                <td class="td-c">{
       { item.browse_count }}</td>
                            </tr>
                        {% endfor %}
                    {% else %}
                        <p>No polls are available.</p>
                    {% endif %}
                </table>
            </div>
    
            
            <div class="d5">
                <div class="pagination">
                    <span class="step-links">
                        {% if data.has_previous %}
                            <a href="?page=1">« 首页</a>
                            <a href="?page={
       { data.previous_page_number }}">上一页</a>
                        {% endif %}
    
                        <span class="current">
                            Page {
       { data.number }} of {
       { data.paginator.num_pages }}.
                        </span>
    
                        {% if data.has_next %}
                            <a href="?page={
       { data.next_page_number }}">下一页</a>
                            <a href="?page={
       { data.paginator.num_pages }}">尾页 »</a>
                        {% endif %}
                    </span>
                </div>
            </div>
        </div>
    </body>
    </html>

效果图：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L05BTkdFX0JPSw_size_16_color_FFFFFF_t_70][]

这就是一简单的测试，写的low了一点，大家别介意，哈哈！

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L05BTkdFX0JPSw_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/1b5808ead179403f9b0fb56f46c00bc9.png