datatable 在服务器端动态调用数据的方法

1、先构造一个简单的包含datatble的html页面
def Pendingorder(request):
pdetailjs=[]
pdetailcolumns=[‘客服流水号’, ‘受理号码’, ‘用户套餐’, ‘区域’, ‘工单状态’, ‘投诉地址’, ‘重复投诉单’]
for x in pdetailcolumns:
temp={}
temp[“data”] = x
pdetailjs.append(temp)
print(pdetailjs)
pdetailjs=json.dumps(pdetailjs)
return render(request, ‘CustomPeformanceSite-ComplaintsWorkOrders1.html’,
{‘pdetailcolumns’:pdetailcolumns,‘pdetailjs’:pdetailjs})

2、在页面js中加入服务器更新数据的属性，并调用ajax数据引用

3、在服务器端构造数据
from django.views.decorators.csrf import csrf_exempt
@csrf_exempt
def work_list(request):

if request.method == "POST":
    # 获取所有数据
    csql = 'select * from 投诉单汇总明细表  where 解决回复内容!=\'\' and position(\'%s\' in 系统接单时间)>0  and 工单状态=\'处理中\'  order by 系统接单时间' % (
        '2022')
    cphon = pd.read_sql(csql, con=engine)

    cphon['重复投诉单'] = cphon['投诉内容'].apply(lambda x: ';'.join(re.findall('TS\d+', x)))
    cphon['投诉地址'] = cphon['投诉内容'].apply(lambda x: ';'.join(re.findall('安徽省(.*)13', x)))
    cphon.reset_index(inplace=True)
    print(cphon.head())
    all_result = cphon[['客服流水号', '受理号码', '用户套餐', '区域', '工单状态', '投诉地址', '重复投诉单']]
     # all_result = running_list.objects.all().order_by("-start_time")
        # 数据条数
    recordsTotal = len(all_result)
    recordsFiltered = recordsTotal
        # 第一条数据的起始位置
    start = int(request.POST['start'])
        # 每页显示的长度，默认为10
    length = int(request.POST['length'])
        # 计数器，确保ajax从服务器返回是对应的
    draw = int(request.POST['draw'])
        # 全局收索条件
    new_search = request.POST['search[value]']
        # 排序列的序号
    new_order= request.POST['order[0][column]']
        # 排序列名
    by_name = request.POST['columns[{0}][data]'.format(new_order)]
        # 排序类型，升序降序
    fun_order = request.POST['order[0][dir]']
        # 排序开启，匹配表格列
    if by_name:
            if fun_order == "asc":
                all_result = all_result.sort_values(by_name)
            else:
                all_result = all_result.sort_values("{0}".format(by_name))
        # 模糊查询，包含内容就查询
    if new_search:
        all_result = all_result[(all_result.客服流水号== new_search) | (all_result.受理号码==new_search) |
                                (all_result.用户套餐==new_search) | (all_result.区域.str.contains(new_search)) |
                                (all_result.工单状态==new_search) | (all_result.投诉地址==new_search)|
                                (all_result.重复投诉单==new_search)]
        # 获取首页的数据
    datas = all_result[start:(start+length)]
        # 转为字典
    resp = datas.to_dict('records')
    print(resp)
    # resp=json.dumps(resp)
    # resp

    #返回计数，总条数，返回数据
    result = {
        'draw': draw,
        'recordsTotal': recordsTotal,
        'recordsFiltered': recordsFiltered,
        'data': resp,
        }
    print('oooodoodosjs')
    print(result)
    # result=json.loads(result)
    # print(result)
    return HttpResponse(json.dumps(result), content_type="application/json")