普通网友 2019-06-21 06:38
浏览 41
已采纳

如何在两天之间显示表格行?

I have a table. I want to show only table rows which match between two days

<table id ="Table">
 <thead>
<tr>
<th>Date</th>
<th>Name</th>
<th>Desc</th>
</tr>
 </thead>
  <tbody>
       <tr>
            <td> 20-06-2019</td>
            <td> Payment </td>     
            <td >ajay </td>
            <td>By cash</td>  
        </tr>
        <tr> 
            <td>21-06-2019</td>
            <td> Payment </td>     
            <td>ajay</td>
            <td>By Cash</td>
        </tr>
         <tr>

            <td>22-06-2019</td>
            <td>Payment </td>     
            <td>ajay </td>
            <td>Tran</td>
        </tr>
          <tr>
            <td>23-06-2019</td>
            <td> Payment </td>     
            <td class="table_account capitalize">ajay </td>
            <td>By cash</td>
        </tr>
</tbody>
   </table>        

I want to show rows between date 20-6-2019 to 22-6-2019.

 20-6-2019 |Payment | Ajay | By cash| 
 21-6-2019 |Payment | Ajay |By cash |
 22-6-2019 |Payment | Ajay |Tran    |
  • 写回答

2条回答 默认 最新

  • dsbj66959 2019-06-21 07:30
    关注

    As your data is getting from server , you should hidden table first by css . Then get data and send to javascript function as param I test with displayInterval as below

    function displayInterval(from, to) {
      $("#Table tbody tr td:first-child").each(function() {
        var curDate = setJsDate($(this).html());
        var froms =setJsDate(from);
        var tos = setJsDate(to);
        if(curDate >= froms && curDate <= tos) {     
        } else {
          $(this).parent().hide();
        }
      });
      $("#Table tbody").show();
    }
    function setJsDate(d) {
     if(typeof d == "number" || typeof d == "undefined") return;
       var pattern = d.split('-');
       var dt = new Date(pattern[2]+"-"+pattern[1] + "-"+pattern[0]);
       return dt.getTime();
    }
    displayInterval('20-06-2019','22-06-2019');
    #Table tbody {
    display : none;
    }
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
    <table id ="Table">
     <thead>
    <tr>
    <th>Date</th>
    <th>Name</th>
    <th>Desc</th>
    </tr>
     </thead>
      <tbody>
           <tr>
                <td>20-06-2019</td>
                <td> Payment </td>     
                <td >ajay </td>
                <td>By cash</td>  
            </tr>
            <tr> 
                <td>21-06-2019</td>
                <td> Payment </td>     
                <td>ajay</td>
                <td>By Cash</td>
            </tr>
             <tr>
    
                <td>22-06-2019</td>
                <td>Payment </td>     
                <td>ajay </td>
                <td>Tran</td>
            </tr>
              <tr>
                <td>23-06-2019</td>
                <td> Payment </td>     
                <td class="table_account capitalize">ajay </td>
                <td>By cash</td>
            </tr>
    </tbody>
       </table>

    </div>
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 delphi webbrowser组件网页下拉菜单自动选择问题
  • ¥15 linux驱动,linux应用,多线程
  • ¥20 我要一个分身加定位两个功能的安卓app
  • ¥15 基于FOC驱动器,如何实现卡丁车下坡无阻力的遛坡的效果
  • ¥15 IAR程序莫名变量多重定义
  • ¥15 (标签-UDP|关键词-client)
  • ¥15 关于库卡officelite无法与虚拟机通讯的问题
  • ¥15 目标检测项目无法读取视频
  • ¥15 GEO datasets中基因芯片数据仅仅提供了normalized signal如何进行差异分析
  • ¥100 求采集电商背景音乐的方法