checkTheAccount.php 12.9 KB

Raw Blame History Permalink

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

<body>
<div class="page-container">
    <form class="" onreset="resetHandler()">
        <?php //$this->load->view('work/search2'); ?>

        <div class="col-xs-2">
            <span class="select-box">
                <select class="select table_search" size="1" name="code" >
                    <option value="" selected>时间类型</option>
                    <?php foreach ($ret as $k=>$v):?>
                        <option value="<?=$k?>"><?=$v?></option>
                    <?php endforeach;?>
                </select>
            </span>
        </div>


        <div class="date mb-20">
            <input type="text" onfocus="WdatePicker({ maxDate:'#F{$dp.$D(\'max\')||\'%y-%M-%d\'}'})" id="min" class="input-text Wdate"> -
            <input type="text" onfocus="WdatePicker({ minDate:'#F{$dp.$D(\'min\')}',maxDate:'%y-%M-%d'})" id="max" class="input-text Wdate">
        </div>
        <div class="row cl mb-20">
            <div class="col-xs-2">
        <span class="select-box">
            <select class="select table_search" size="1">
                <option value="" selected>还款状态</option>
                <?php foreach ($this->session->repaymentPlans as $k=>$v):?>
                    <option value="<?=$k?>"><?=$v?></option>
                <?php endforeach;?>
            </select>
        </span>
            </div>
            <div class="col-xs-2">
        <span class="select-box">
            <select class="select table_search" size="1" column="6">
                <option value="" selected>网点</option>
                <?php foreach ($this->session->departments as $k=>$v):?>
                    <option value="<?=$v->id?>"><?=$v->name?></option>
                    <?php if($v->children && !empty($v->children)):?>
                        <?php foreach ($v->children as $kk=>$vv):?>
                            <option value="<?=$vv->id?>"><?=$vv->name?></option>
                        <?php endforeach;?>
                    <?php endif;?>
                <?php endforeach;?>
            </select>
        </span>
            </div>
<!--            <div class="col-xs-2">-->
<!--        <span class="select-box">-->
<!--            <select class="select table_search" size="1">-->
<!--                <option value="" selected>是否逾期</option>-->
<!--                <option value="1">是</option>-->
<!--                <option value="0">否</option>-->
<!--            </select>-->
<!--        </span>-->
<!--            </div>-->
<!--            <div class="col-xs-2">-->
<!--        <span class="select-box">-->
<!--            <select class="select table_search" size="1">-->
<!--                <option value="" selected>来源</option>-->
<!--                --><?php // foreach ($this->session->repaymentPlanSource as $k=>$v):?>
<!--                    <option value="--><?//=$k?><!--">--><?//=$v?><!--</option>-->
<!--                --><?php //endforeach;?>
<!--            </select>-->
<!--        </span>-->
<!--            </div>-->
            <div class="col-xs-2">
                <input type="text" class="form-control input-text table_search" value="" placeholder="姓名" column="3" name="proposerName">
            </div>
            <div class="col-xs-2">
                <input type="text" class="form-control input-text table_search" value="" placeholder="手机号" column="5" name="phoneNumber">
            </div>
        </div>


        <div>
            <button class="btn btn-primary radius" type="button" onclick="$('#table').DataTable().draw()">搜索</button>
            <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>
                <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">
            </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 + 'manage/financial/repayments/nonePay',
            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:;pass(' + data + ')">确认到款</a></li>\
                            </ul></span>';
                }
            },
            {data: "source"},//来源
            {data: "orderNumber"},//订单编号
            {data: "applyAmount"},//订单编号
            {name: "branchName", data: "branchName"},//网点名称
            {data: "clientManager"},//客户经理

//                {data: "confirmDate"},//确认到账日期
            {data: function (data) {
                if(!data.confirmDate)
                    return '';
                return getNowFormatDate(new Date(parseInt(data.confirmDate)));
            }},//计划还款日期
            {data: "currentBalance"},//当月应还
            {data: "currentPeriods"},//当月期数
//                {data: "hasDue"},//是否逾期
            {data: function (data) {
                if(data.hasDue == 1){
                    return '是';
                }else if(data.hasDue == 0){
                    return '否';
                }else{
                    return '';
                }
            }},//是否逾期
            {data: "dueDay"},//逾期天数
//                {data: "enterDate"},//进件时间
            {data: function (data) {
                if(!data.enterDate)
                    return '';
                return getNowFormatDate(new Date(parseInt(data.enterDate)));
            }},//进件时间
//                {data: "hasClean"},//是否结清
            {data: function (data) {
                if(data.hasClean == 1){
                    return '是';
                }else if(data.hasClean == 0){
                    return '否';
                }else{
                    return '';
                }
            }},//是否结清
            {data: "idNumber"},//身份证
            {data: "interestPenalty"},//罚息
//                {data: "loanDate"},//放款日期
            {data: function (data) {
                if(!data.loanDate)
                    return '';
                return getNowFormatDate(new Date(parseInt(data.loanDate)));
            }},//放款日期
            {data: "overdueFine"},//滞纳金
            {data: "phoneNumber"},//手机号
//                {data: "planRepaymentDate"},//计划还款日期
            {data: function (data) {
                if(!data.planRepaymentDate)
                    return '';
                return getNowFormatDate(new Date(parseInt(data.planRepaymentDate)));
            }},//计划还款日期
            {name: "productId", data: "productName"},//产品名称
            {data: "proposerName"},//申请人
            {data: "prosecuteStatus"},//起诉状态
            {data: "ratifyAmount"},//审批金额
//                {data: "realRepaymentDate"},//实际还款日
            {data: function (data) {
                if(!data.realRepaymentDate)
                    return '';
                return getNowFormatDate(new Date(parseInt(data.realRepaymentDate)));
            }},//计划还款日期
//                {data: "repayStatus"},//还款状态
            {data: function (data) {
                if(data.repayStatus == 0){
                    return '未还';
                }else if(data.repayStatus == 1){
                    return '逾期未还';
                }else if(data.repayStatus == 2){
                    return '逾期已还';
                }else if(data.repayStatus == 3){
                    return '已还';
                }else{
                    return '';
                }
            }},//计划还款日期
//                {name: "repayStatus", data: "repayStatus"},//还款状态
            {data: "totalPeriods"},//总期数
        ]
    });

    $.fn.dataTableExt.afnFiltering.push(
        function (oSettings, aData, iDataIndex) {
            var min = document.getElementById('min').value;
            var max = document.getElementById('max').value;
            var iDateCol = 5; //进件时间

            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();
    });

    $('.table_search').on('keyup', 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();
    }

    function pass(id) {
//        var url = 'Finance/addtime?id='+id;
        layer.open({
            type: 2,
            title: '确认时间',
            shadeClose: true,
            area: ['400px', '400px'],
            content: '<?=site_url('Finance/addtime?id=')?>'+id
        });
    }


    //    function pass(id) {
//        layer.confirm('通过之后, 账单同步更新到收款明细列表', {
//            btn: ['通过', '取消'],
//            title: '确认到账',
//            icon: 3
//        }, function () {
//            var data = {
//                realRepaymentDate: getNowFormatDate()
//            };
//            $.ajax({
//                type: 'patch',
//                url: apiBaseUrl + 'manage/financial/confirm/' + id + '?realRepaymentDate=' + Date.now(),
//                cache: false,
//                dataType: 'json',
//                data: JSON.stringify(data),
//                contentType: "application/json; charset=UTF-8",
//                success: function (data) {
//                    if (data.msg) {
//                        layer.alert(data.msg);
//                    } else if (data.code != 0) {
//                        layer.alert('操作失败');
//                    } else {
//                        layer.msg('通过');
//                    }
//                },
//                error: function () {
//                    layer.alert("操作失败")
//                }
//            })
//
//        });
//    }
</script>
</body>
<html>