在表格中判断当前日期是否快到期

判断是否快到期

功能描述:如果快到期(小于5天),将背景变红。需要引入jQuery。

这里写图片描述

有一个问题,如图所示:
这里写图片描述
在QQ浏览器、谷歌浏览器、火狐浏览器测试过,这三个浏览器中,只有火狐对日期格式比较严格,其余两个均能正常运行。加上.trim()去除空格。另外,IE中new Date(str)日期转换貌似不行,暂时没解决。

原因是:
这里写图片描述

<!DOCTYPE html>
<html>

    <head>
        <meta charset="UTF-8">
        <title></title>
    </head>
    <style>
        .bg {
            background-color: red;
        }
    </style>

    <body>

        <table id="warehouseTable" class="table table-bordered table-hover dataTable no-footer" role="grid" aria-describedby="warehouseTable_info" width="100%">
            <thead>
                <tr role="row">
                    <th style="padding-left:0px;padding-right:0px;text-align: center;" class="sorting_asc" tabindex="0" aria-controls="warehouseTable" rowspan="1" colspan="1" aria-sort="ascending" aria-label="序号: activate to sort column descending">序号</th>
                    <th style="padding-left:0px;padding-right:0px;text-align: center;" class="sorting_disabled" rowspan="1" colspan="1" aria-label="公司代码">公司代码</th>
                    <th style="padding-left:0px;padding-right:0px;text-align: center;" class="sorting_disabled" rowspan="1" colspan="1" aria-label="仓库代码">仓库代码</th>
                    <th style="padding-left:0px;padding-right:0px;text-align: center;" class="sorting_disabled" rowspan="1" colspan="1" aria-label="仓库名称">仓库名称</th>
                    <th style="padding-left:0px;padding-right:0px;text-align: center;" class="sorting_disabled" rowspan="1" colspan="1" aria-label="仓库地址">仓库地址</th>
                    <th style="padding-left:0px;padding-right:0px;text-align: center;" class="sorting_disabled" rowspan="1" colspan="1" aria-label="联系人">联系人</th>
                    <th style="padding-left:0px;padding-right:0px;text-align: center;" class="sorting_disabled" rowspan="1" colspan="1" aria-label="联系电话">联系电话</th>
                    <th style="padding-left:0px;padding-right:0px;text-align: center;" class="sorting_disabled" rowspan="1" colspan="1" aria-label="邮政编码">邮政编码</th>
                    <th style="padding-left:0px;padding-right:0px;text-align: center;" class="sorting_disabled" rowspan="1" colspan="1" aria-label="传真">传真</th>
                    <th style="padding-left:0px;padding-right:0px;text-align: center;" class="sorting_disabled" rowspan="1" colspan="1" aria-label="仓库到期时间">仓库到期时间</th>
                    <th style="padding-left:0px;padding-right:0px;text-align: center;" class="sorting_disabled" rowspan="1" colspan="1" aria-label="仓库管理">仓库管理</th>
                </tr>
            </thead>
            <tbody>
                <tr role="row" class="odd">
                    <td class="sorting_1" width="6%">1</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="6%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="6%">---</td>
                    <td width="8%"> 2016-11-26 11:19:18</td>
                    <td style="text-align:center" width="8%">
                        <a type="button" class="glyphicon glyphicon-user" href="javascript:addAdmin(&quot;GZYYC&quot;,&quot;albb&quot;,&quot;e5a65693a0e1716487a3e70d7fd5295d&quot;);" style="font-size:24px;line-height:48px" data-toggle="tooltip" data-placement="top" title="新增管理员"></a>
                        <a type="button" class="glyphicon glyphicon-log-in" href="javascript:addAdmin(&quot;GZYYC&quot;,&quot;albb&quot;,&quot;e5a65693a0e1716487a3e70d7fd5295d&quot;);" style="font-size:24px;line-height:48px" data-toggle="tooltip" data-placement="top" title="新增开始时间与到期时间"></a>
                    </td>
                </tr>
                <tr role="row" class="even">
                    <td class="sorting_1" width="6%">2</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="6%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="6%">---</td>
                    <td width="8%">---</td>
                    <td style="text-align:center" width="8%">
                        <a type="button" class="glyphicon glyphicon-user" href="javascript:addAdmin(&quot;LJ0001&quot;,&quot;albb&quot;,&quot;21338d07cccff6016561ac43d496b5e6&quot;);" style="font-size:24px;line-height:48px" data-toggle="tooltip" data-placement="top" title="新增管理员"></a>
                        <a type="button" class="glyphicon glyphicon-log-in" href="javascript:addAdmin(&quot;LJ0001&quot;,&quot;albb&quot;,&quot;21338d07cccff6016561ac43d496b5e6&quot;);" style="font-size:24px;line-height:48px" data-toggle="tooltip" data-placement="top" title="新增开始时间与到期时间"></a>
                    </td>
                </tr>
                <tr role="row" class="odd">
                    <td class="sorting_1" width="6%">3</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="6%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="6%">---</td>
                    <td width="8%">2016-12-10 11:19:18</td>
                    <td style="text-align:center" width="8%">
                        <a type="button" class="glyphicon glyphicon-user" href="javascript:addAdmin(&quot;LJ0003&quot;,&quot;albb&quot;,&quot;5ad8b2002e5372ad773f37da347f0b27&quot;);" style="font-size:24px;line-height:48px" data-toggle="tooltip" data-placement="top" title="新增管理员"></a>
                        <a type="button" class="glyphicon glyphicon-log-in" href="javascript:addAdmin(&quot;LJ0003&quot;,&quot;albb&quot;,&quot;5ad8b2002e5372ad773f37da347f0b27&quot;);" style="font-size:24px;line-height:48px" data-toggle="tooltip" data-placement="top" title="新增开始时间与到期时间"></a>
                    </td>
                </tr>
                <tr role="row" class="even">
                    <td class="sorting_1" width="6%">4</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="6%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="6%">---</td>
                    <td width="8%">---</td>
                    <td style="text-align:center" width="8%">
                        <a type="button" class="glyphicon glyphicon-user" href="javascript:addAdmin(&quot;LJ0002&quot;,&quot;albb&quot;,&quot;5de38064f11c1c2c556107a3ab71d092&quot;);" style="font-size:24px;line-height:48px" data-toggle="tooltip" data-placement="top" title="新增管理员"></a>
                        <a type="button" class="glyphicon glyphicon-log-in" href="javascript:addAdmin(&quot;LJ0002&quot;,&quot;albb&quot;,&quot;5de38064f11c1c2c556107a3ab71d092&quot;);" style="font-size:24px;line-height:48px" data-toggle="tooltip" data-placement="top" title="新增开始时间与到期时间"></a>
                    </td>
                </tr>
                <tr role="row" class="odd">
                    <td class="sorting_1" width="6%">5</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="6%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="6%">---</td>
                    <td width="8%">2016-11-27</td>
                    <td style="text-align:center" width="8%">
                        <a type="button" class="glyphicon glyphicon-user" href="javascript:addAdmin(&quot;1005&quot;,&quot;albb&quot;,&quot;cc9d7c8560a3e2b296bc78ca5cc23b21&quot;);" style="font-size:24px;line-height:48px" data-toggle="tooltip" data-placement="top" title="新增管理员"></a>
                        <a type="button" class="glyphicon glyphicon-log-in" href="javascript:addAdmin(&quot;1005&quot;,&quot;albb&quot;,&quot;cc9d7c8560a3e2b296bc78ca5cc23b21&quot;);" style="font-size:24px;line-height:48px" data-toggle="tooltip" data-placement="top" title="新增开始时间与到期时间"></a>
                    </td>
                </tr>
                <tr role="row" class="even">
                    <td class="sorting_1" width="6%">6</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="6%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="6%">---</td>
                    <td width="8%">---</td>
                    <td style="text-align:center" width="8%">
                        <a type="button" class="glyphicon glyphicon-user" href="javascript:addAdmin(&quot;1000&quot;,&quot;albb&quot;,&quot;b025cbd463e12dcd56abdd2c86f61312&quot;);" style="font-size:24px;line-height:48px" data-toggle="tooltip" data-placement="top" title="新增管理员"></a>
                        <a type="button" class="glyphicon glyphicon-log-in" href="javascript:addAdmin(&quot;1000&quot;,&quot;albb&quot;,&quot;b025cbd463e12dcd56abdd2c86f61312&quot;);" style="font-size:24px;line-height:48px" data-toggle="tooltip" data-placement="top" title="新增开始时间与到期时间"></a>
                    </td>
                </tr>
                <tr role="row" class="odd">
                    <td class="sorting_1" width="6%">7</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="6%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="6%">---</td>
                    <td width="8%">---</td>
                    <td style="text-align:center" width="8%">
                        <a type="button" class="glyphicon glyphicon-user" href="javascript:addAdmin(&quot;1008&quot;,&quot;albb&quot;,&quot;e0a605adab9aa91dfc2b1d75d39ffbd4&quot;);" style="font-size:24px;line-height:48px" data-toggle="tooltip" data-placement="top" title="新增管理员"></a>
                        <a type="button" class="glyphicon glyphicon-log-in" href="javascript:addAdmin(&quot;1008&quot;,&quot;albb&quot;,&quot;e0a605adab9aa91dfc2b1d75d39ffbd4&quot;);" style="font-size:24px;line-height:48px" data-toggle="tooltip" data-placement="top" title="新增开始时间与到期时间"></a>
                    </td>
                </tr>
                <tr role="row" class="even">
                    <td class="sorting_1" width="6%">8</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="6%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="6%">---</td>
                    <td width="8%">2016-12-25</td>
                    <td style="text-align:center" width="8%">
                        <a type="button" class="glyphicon glyphicon-user" href="javascript:addAdmin(&quot;1009&quot;,&quot;albb&quot;,&quot;7eb4f78e2f85d0d5c6015525e5929445&quot;);" style="font-size:24px;line-height:48px" data-toggle="tooltip" data-placement="top" title="新增管理员"></a>
                        <a type="button" class="glyphicon glyphicon-log-in" href="javascript:addAdmin(&quot;1009&quot;,&quot;albb&quot;,&quot;7eb4f78e2f85d0d5c6015525e5929445&quot;);" style="font-size:24px;line-height:48px" data-toggle="tooltip" data-placement="top" title="新增开始时间与到期时间"></a>
                    </td>
                </tr>
                <tr role="row" class="odd">
                    <td class="sorting_1" width="6%">9</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="6%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="6%">---</td>
                    <td width="8%">---</td>
                    <td style="text-align:center" width="8%">
                        <a type="button" class="glyphicon glyphicon-user" href="javascript:addAdmin(&quot;1001&quot;,&quot;albb&quot;,&quot;124bfa02a6d85ea95f988e7e04a44cfc&quot;);" style="font-size:24px;line-height:48px" data-toggle="tooltip" data-placement="top" title="新增管理员"></a>
                        <a type="button" class="glyphicon glyphicon-log-in" href="javascript:addAdmin(&quot;1001&quot;,&quot;albb&quot;,&quot;124bfa02a6d85ea95f988e7e04a44cfc&quot;);" style="font-size:24px;line-height:48px" data-toggle="tooltip" data-placement="top" title="新增开始时间与到期时间"></a>
                    </td>
                </tr>
                <tr role="row" class="even">
                    <td class="sorting_1" width="6%">10</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="6%">---</td>
                    <td width="8%">---</td>
                    <td width="8%">---</td>
                    <td width="6%">---</td>
                    <td width="8%">---</td>
                    <td style="text-align:center" width="8%">
                        <a type="button" class="glyphicon glyphicon-user" href="javascript:addAdmin(&quot;1003&quot;,&quot;albb&quot;,&quot;2cf066356db535cadf9c19ec176a5b6a&quot;);" style="font-size:24px;line-height:48px" data-toggle="tooltip" data-placement="top" title="新增管理员"></a>
                        <a type="button" class="glyphicon glyphicon-log-in" href="javascript:addAdmin(&quot;1003&quot;,&quot;albb&quot;,&quot;2cf066356db535cadf9c19ec176a5b6a&quot;);" style="font-size:24px;line-height:48px" data-toggle="tooltip" data-placement="top" title="新增开始时间与到期时间"></a>
                    </td>
                </tr>
            </tbody>

        </table>

    </body>
    <script type="text/javascript" src="jquery-2.2.3.min.js"></script>
    <script>
        $(function() {
            var nowTime = new Date().valueOf();
            $("#warehouseTable tbody tr").each(function(index, element) {
                var str = $(element).children().eq(9).text().trim();
                console.log(str);
                var dateTime = new Date(str).valueOf();
                var leftTime = (dateTime - nowTime) / (86400000);
                if(leftTime < 5) {
                    $(element).children().eq(9).attr({
                        'class': 'bg'
                    });
                }
            });
        })
    </script>

</html>
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值