index.php 4.89 KB
<?php $this->load->view('common/header'); ?>

<body>
<?php $this->load->view('common/work_header'); ?>
<div class="page-container">
    <form class="" onreset="resetHandler()">
        <?php $this->load->view('work/search'); ?>
        <div>
            <input class="btn btn-warning radius" type="reset" value="重置">
        </div>
    </form>

    <div class="body mt-20">
        <table class="table table-border table-bordered table-bg" id="table">
            <thead class="text-c">
            <tr>
                <th width="68px">操作</th>
                <th>订单编号</th>
                <th>申请人</th>
                <th>身份证</th>
                <th>手机号</th>
                <th>进件时间</th>
                <th>网点</th>
                <th>产品名称</th>
                <th>申请金额</th>
                <th>审批金额</th>
                <th>客户经理</th>
                <th>流程节点</th>
                <th>流转时间</th>
                <th>处理人</th>
            </tr>
            </thead>
            <tbody class="text-c">
            <tr>
                <td></td>
                <td></td>
            </tr>
            </tbody>
        </table>
    </div>
</div>
<?php $this->load->view('common/footer'); ?>

<script>
    var table = $('#table').dataTable({
        aaSorting: [[1, "desc"]],
        serverSide: true,
        processing: true,
        bSort: false,
        searching: false,//是否显示搜索
        iDisplayLength: 6,
        bLengthChange: false,
        ajax: {
            url: apiBaseUrl + '/order/into/getAllApplyOrder',
            dataFilter: function (json) {
                var ret = {}, json = jQuery.parseJSON(json);
                ret.data = json.data || [];
                var draw = getUrlParam('draw');
                if(draw) {
                    ret.draw = draw;
                }
                ret.recordsTotal = 0;
                ret.recordsFiltered = 0;
                if (json.page) {
                    ret.recordsTotal = parseInt(json.page.totalNumber);
                    ret.recordsFiltered = parseInt(json.page.totalNumber);
                }
                return JSON.stringify(ret);
            },
            data: function (data) {
                data.pageSize = data.length;
                data.currentPage = parseFloat(data.start / data.length) + 1;
                return data;
            }
        },
        columns: [
            {
                data: "id", render: function (data, type, full) {
                    return '<span class="dropDown dropDown_hover">\
                        <button class="btn radius size-M">请选择 <i class="Hui-iconfont">&#xe6d5;</i></button>\
                        <ul class="dropDown-menu menu radius box-shadow"><li><a href="javascript:;" onclick="layer_show(\'订单详情\', \'/index.php/work/detail/' + data + '?tab=0\')">查看详细</a></li>\
                            <li><a href="javascript:;" onclick="layer_show(\'订单详情\', \'/index.php/work/detail/' + data + '?tab=2\')">处理记录</a></li>\
                            <li><a href="#">客户取消</a></li>\
                        </ul></span>';
                }
            },
            {data: "orderNo"},//订单编号
            {data: "userName"},//申请人
            {data: "idCard"},//身份证
            {data: "phoneNumber"},//手机号
            {data: "createTime"},//进件时间
            {data: "departmentName"},//网点
            {data: "productName"},//产品名称
            {data: "applyMoney"},//申请金额
            {data: "agreeMoney"},//审批金额
            {data: "createUser"},//客户经理
            {data: "statusDesc"},//流程节点
            {data: "modifyTime"},//流转时间
            {data: "modifyUser"}//处理人
        ]
    });

    $.fn.dataTableExt.afnFiltering.push(
        function (oSettings, aData, iDataIndex) {
            var min = document.getElementById('min').value;
            var max = document.getElementById('max').value;
            var iDateCol = 12;

            var dateMin = new Date(aData[iDateCol]);
            var dateMax = new Date(aData[iDateCol]);

            if (min === '' && max === '')
                return true;
            else if (new Date(min).getTime() <= dateMin.getTime() && max === '')
                return true;
            else if (new Date(min).getTime() <= dateMin.getTime() && new Date(max).getTime() >= dateMax.getTime())
                return true;
            return false;
        }
    );

    $('.table_search').on('change', function () {
        search = $(this).val();
        column = $(this).attr('column');

        $('#table').DataTable().column(column).search(search).draw();
    });

    $('#min, #max').on('keyup', function () {
        $('#table').DataTable().draw();
    });

    function resetHandler() {
        $('#table').DataTable().columns().search("").draw();
    }
</script>
</body>
<html>