Datatable - 按日期范围过滤 - 不返回正确的结果 [英] Datatable - Filtering by date range - Not returning correct results
本文介绍了Datatable - 按日期范围过滤 - 不返回正确的结果的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我目前正在使用jQuery https://datatables.net/ 的数据表插件在这里找到的插件 http://www.daterangepicker.com/ 。
我几乎让他们一起工作，但目前坚持这两个问题。
1）当我选择我的日期范围时，它会过滤但是dosent提供正确的结果。
2）当我清除日期范围的结果，它不会删除过滤器。
我制作了一个非常类似于我现在工作的JSfiddle。日期范围过滤器是左上角的输入。 http://jsfiddle.net/evcfespn/18/
此时不用担心任何帮助。
JavaScript代码：
//开始数据表
$（document）.ready（function （）{
var table = $（'＃example'）。DataTable（{
dom：'<toolbar> frtip'
}）;
$（div.toolbar）。html（'< input id =date_rangetype =text>'）;
//数据表的END
/ /日期范围脚本 - 开始sscript
$（＃date_range）。daterangepicker（{
autoUpdateInput：false，
locale：{
cancelLabel：清除 ，
}
}）;
$（＃date_range）。on（'apply.daterangepicker'，function（ev，picker）{
$这个）.val（picker.startDate.format（'YYYY-MM-DD'）+'to'+ picker.endDate.format（'YYYY-MM-DD'））;
table.draw（）;
$（＃date_range）。on（'cancel.daterangepicker'，function（ev，picker）{
$（this）.val '）;
table.draw（）;
}）;
//日期范围脚本 - 脚本结束
$ .fn.dataTableExt .afnFiltering.push（
function（oSettings，aData，iDataIndex）{
var grab_daterange = $（＃date_range）。val（）;
var give_results_daterange = grab_daterange.split（to）;
var filterstart = give_results_daterange [0];
var filterend = give_results_daterange [1];
var iStartDateCol = 5; //在此实例中使用第2列
var iEndDateCol = 5;
var tabledatestart = aData [iStartDateCol];
var tabledateend = aData [iEndDateCol];
if（filterstart ===&& filtererend ===）
{
return true;
}
else if（（moment（filterstart）.isSame（tabledatestart）|| moment（filterstart）.isBefore（tabledatestart））&& filterend ===）
{
返回true;
}
else if（（moment（filterstart）.isSame（tabledatestart）|| moment（filterstart）.isAfter（tabledatestart））&& filterstart ===）
{
返回true;
}
else if（（moment（filterstart）.isSame（tabledatestart）|| moment（filterstart）.isBefore（tabledatestart））&&（moment（filterend）.isSame（tabledateend）时刻（filterend）.isAfter（tabledateend）））
{
return true;
}
返回false;
}
）;
//结束datable
}）;
HTML表：
< table id =exampleclass =displaycellspacing =0width =100％>
< thead>
< tr>
< th> Name< / th>
< th> Position< / th>
< th> Office< / th>
< th>年龄< / th>
< th>开始日期< / th>
< th>工资< / th>
< / tr>
< / thead>
< tfoot>
< tr>
< th> Name< / th>
< th> Position< / th>
< th> Office< / th>
< th>年龄< / th>
< th>开始日期< / th>
< th>工资< / th>
< / tr>
< / tfoot>
< tbody>
< tr>
< td> Tiger Nixon< / td>
< td>系统架构师< / td>
< td>爱丁堡< / td>
< td> 61< / td>
< td> 2015-10-01< / td>
< td> $ 320,800< / td>
< / tr>
< tr>
< td> Garrett Winters< / td>
< td>会计< / td>
< td>东京< / td>
< td> 63< / td>
< td> 2015-10-03< / td>
< td> $ 170,750< / td>
< / tr>
< tr>
< td> Ashton Cox< / td>
< td>初级技术作者< / td>
< td>旧金山< / td>
< td> 66< / td>
< td> 2015-10-03< / td>
< td> $ 86,000< / td>
< / tr>
< tr>
< td> Cedric Kelly< / td>
< td>高级Javascript开发者< / td>
< td>爱丁堡< / td>
< td> 22< / td>
< td> 2015-10-05< / td>
< td> $ 433,060< / td>
< / tr>
< tr>
< td> Airi Satou< / td>
< td>< / td>
< td>东京< / td>
< td>< / td>
< td> 2015-10-05< / td>
< td>< / td>
< / tr>
< tr>
< td> Brielle Williamson< / td>
< td>集成专家< / td>
< td>纽约< / td>
< td> 61< / td>
< td> 2015-10-05< / td>
< td> $ 372,000< / td>
< / tr>
< tr>
< td> Herrod Chandler< / td>
< td>销售助理< / td>
< td>旧金山< / td>
< td> 59< / td>
< td> 2015-10-05< / td>
< td> $ 137,500< / td>
< / tr>
< tr>
< td> Rhona Davidson< / td>
< td>集成专家< / td>
< td>东京< / td>
< td> 55< / td>
< td> 2015-10-07< / td>
< td> $ 327,900< / td>
< / tr>
< tr>
< td> Colleen Hurst< / td>
< td> Javascript Developer< / td>
< td>旧金山< / td>
< td> 39< / td>
< td> 2015-10-08< / td>
< td> $ 205,500< / td>
< / tr>
< tr>
< td> Sonya Frost< / td>
< td>软件工程师< / td>
< td>爱丁堡< / td>
< td> 23< / td>
< td> 2015-10-13< / td>
< td> $ 103,600< / td>
< / tr>
< tr>
< td> Jena Gaines< / td>
< td> Office Manager< / td>
< td>伦敦< / td>
< td> 30< / td>
< td> 2015-10-13< / td>
< td> $ 90,560< / td>
< / tr>
< tr>
< td> Quinn Flynn< / td>
< td>支持Lead< / td>
< td>爱丁堡< / td>
< td> 22< / td>
< td> 2015-10-15< / td>
< td> $ 342,000< / td>
< / tr>
< tr>
< td> Charde Marshall< / td>
< td>区域总监< / td>
< td>旧金山< / td>
< td> 36< / td>
< td> 2015-10-16< / td>
< td> $ 470,600< / td>
< / tr>
< tr>
< td> Haley Kennedy< / td>
< td>高级营销设计师< / td>
< td>伦敦< / td>
< td> 43< / td>
< td> 2015-10-17< / td>
< td> $ 313,500< / td>
< / tr>
< tr>
< td> Tatyana Fitzpatrick< / td>
< td>区域总监< / td>
< td>伦敦< / td>
< td> 19< / td>
< td> 2015-01-18< / td>
< td> $ 385,750< / td>
< / tr>
< tr>
< td> Michael Silva< / td>
< td>营销设计师< / td>
< td>伦敦< / td>
< td> 66< / td>
< td> 2015-10-19< / td>
< td> $ 198,500< / td>
< / tr>
< tr>
< td> Paul Byrd< / td>
< td>首席财务官（CFO）< / td>
< td>纽约< / td>
< td> 64< / td>
< td> 2015-10-20< / td>
< td> $ 725,000< / td>
< / tr>
< tr>
< td> Gloria Little< / td>
< td>系统管理员< / td>
< td>纽约< / td>
< td> 59< / td>
< td> 2015-10-25< / td>
< td> $ 237,500< / td>
< / tr>
< tr>
< td> Bradley Greer< / td>
< td>软件工程师< / td>
< td>伦敦< / td>
< td> 41< / td>
< td> 2015-11-26< / td>
< td> $ 132,000< / td>
< / tr>
< tr>
< td> Dai Rios< / td>
< td>人事负责人< / td>
< td>爱丁堡< / td>
< td> 35< / td>
< td> 2015-10-26< / td>
< td> $ 217,500< / td>
< / tr>
< tr>
< td> Jenette Caldwell< / td>
< td>开发负责人< / td>
< td>纽约< / td>
< td> 30< / td>
< td> 2015-10-27< / td>
< td> $ 345,000< / td>
< / tr>
< tr>
< td> Yuri Berry< / td>
< td>首席营销官（CMO）< / td>
< td>纽约< / td>
< td> 40< / td>
< td> 2015-10-28< / td>
< td> $ 675,000< / td>
< / tr>
< tr>
< td>凯撒万斯< / td>
< td>售前支持< / td>
< td>纽约< / td>
< td> 21< / td>
< td> 2015-10-28< / td>
< td> $ 106,450< / td>
< / tr>
< tr>
< td> Doris Wilder< / td>
< td>销售助理< / td>
< td> Sidney< / td>
< td> 23< / td>
< td> 2015-10-29< / td>
< td> $ 85,600< / td>
< / tr>
< tr>
< td> Angelica Ramos< / td>
< td>首席执行官（CEO）< / td>
< td>伦敦< / td>
< td> 47< / td>
< td> 2015-10-29< / td>
< td> $ 1,200,000< / td>
< / tr>
< tr>
< td> Gavin Joyce< / td>
< td>开发者< / td>
< td>爱丁堡< / td>
< td> 42< / td>
< td> 2015-10-29< / td>
< td> $ 92,575< / td>
< / tr>
< tr>
< td> Jennifer Chang< / td>
< td>区域总监< / td>
< td>新加坡< / td>
< td> 28< / td>
< td> 2015-10-29< / td>
< td> $ 357,650< / td>
< / tr>
< tr>
< td> Brenden Wagner< / td>
< td>软件工程师< / td>
< td>旧金山< / td>
< td> 28< / td>
< td> 2015-11-01< / td>
< td> $ 206,850< / td>
< / tr>
< tr>
< td> Fiona Green< / td>
< td>首席运营官（COO）< / td>
< td>旧金山< / td>
< td> 48< / td>
< td> 2015-11-01< / td>
< td> $ 850,000< / td>
< / tr>
< tr>
< td> Shou Itou< / td>
< td>区域营销< / td>
< td>东京< / td>
< td> 20< / td>
< td> 2015-11-03< / td>
< td> $ 163,000< / td>
< / tr>
< tr>
< td> Michelle House< / td>
< td>集成专家< / td>
< td> Sidney< / td>
< td> 37< / td>
< td> 2015-11-04< / td>
< td> $ 95,400< / td>
< / tr>
< tr>
< td> Suki Burks< / td>
< td>开发者< / td>
< td>伦敦< / td>
< td> 53< / td>
< td> 2015-11-06< / td>
< td> $ 114,500< / td>
< / tr>
< tr>
< td> Prescott Bartlett< / td>
< td>技术作者< / td>
< td>伦敦< / td>
< td> 27< / td>
< td> 2015-11-07< / td>
< td> $ 145,000< / td>
< / tr>
< tr>
< td> Gavin Cortez< / td>
< td>团队领导< / td>
< td>旧金山< / td>
< td> 22< / td>
< td> 2015-11-07< / td>
< td> $ 235,500< / td>
< / tr>
< tr>
< td> Martena Mccray< / td>
< td>售后支持< / td>
< td>爱丁堡< / td>
< td> 46< / td>
< td> 2015-11-07< / td>
< td> $ 324,050< / td>
< / tr>
< tr>
< td> Unity Butler< / td>
< td>营销设计师< / td>
< td>旧金山< / td>
< td> 47< / td>
< td> 2015-11-08< / td>
< td> $ 85,675< / td>
< / tr>
< tr>
< td> Howard Hatfield< / td>
< td> Office Manager< / td>
< td>旧金山< / td>
< td> 51< / td>
< td> 2015-11-08< / td>
< td> $ 164,500< / td>
< / tr>
< tr>
< td> Hope Fuentes< / td>
< td>秘书< / td>
< td>旧金山< / td>
< td> 41< / td>
< td> 2015-11-09< / td>
< td> $ 109,850< / td>
< / tr>
< tr>
< td> Vivian Harrell< / td>
< td>财务控制器< / td>
< td>旧金山< / td>
< td> 62< / td>
< td> 2015-11-09< / td>
< td> $ 452,500< / td>
< / tr>
< tr>
< td> Timothy Mooney< / td>
< td> Office Manager< / td>
< td>伦敦< / td>
< td> 37< / td>
< td> 2015-11-10< / td>
< td> $ 136,200< / td>
< / tr>
< tr>
< td> Jackson Bradshaw< / td>
< td> Director< / td>
< td>纽约< / td>
< td> 65< / td>
< td> 2015-11-10< / td>
< td> $ 645,750< / td>
< / tr>
< tr>
< td> Olivia Liang< / td>
< td>支持工程师< / td>
< td>新加坡< / td>
< td> 64< / td>
< td> 2015-11-11< / td>
< td> $ 234,500< / td>
< / tr>
< tr>
< td> Bruno Nash< / td>
< td>软件工程师< / td>
< td>伦敦< / td>
< td> 38< / td>
< td> 2015-11-11< / td>
< td> $ 163,500< / td>
< / tr>
< tr>
< td> Sakura Yamamoto< / td>
< td>支持工程师< / td>
< td>东京< / td>
< td> $ 139,575< / td>
< / tr>
< tr>
< td> Thor Walton< / td>
< td>开发者< / td>
< td>纽约< / td>
< td> 61< / td>
< td> 2015-11-13< / td>
< td> $ 98,540< / td>
< / tr>
< tr>
< td> Finn Camacho< / td>
< td>支持工程师< / td>
< td>旧金山< / td>
< td> 47< / td>
< td> 2015-11-13< / td>
< td> $ 87,500< / td>
< / tr>
< tr>
< td> Serge Baldwin< / td>
< td>数据协调器< / td>
< td>新加坡< / td>
< td> 64< / td>
< td> 2015-11-13< / td>
< td> $ 138,575< / td>
< / tr>
< tr>
< td> Zenaida Frank< / td>
< td>软件工程师< / td>
< td>纽约< / td>
< td> 63< / td>
< td> 2015-11-13< / td>
< td> $ 125,250< / td>
< / tr>
< tr>
< td> Zorita Serrano< / td>
< td>软件工程师< / td>
< td>旧金山< / td>
< td> 56< / td>
< td> 2015-11-13< / td>
< td> $ 115,000< / td>
< / tr>
< tr>
< td> Jennifer Acosta< / td>
< td>初级JavaScript开发者< / td>
< td>爱丁堡< / td>
< td> 43< / td>
< td> 2013/02/01< / td>
< td> $ 75,650< / td>
< / tr>
< tr>
< td> Cara Stevens< / td>
< td>销售助理< / td>
< td>纽约< / td>
< td> 46< / td>
< td> 2015-11-13< / td>
< td> $ 145,600< / td>
< / tr>
< tr>
< td> Hermione Butler< / td>
< td>区域总监< / td>
< td>伦敦< / td>
< td> 47< / td>
< td> 2015-11-13< / td>
< td> $ 356,250< / td>
< / tr>
< tr>
< td> Lael Greer< / td>
< td>系统管理员< / td>
< td>伦敦< / td>
< td> 21< / td>
< td> 2009/02/27< / td>
< td> $ 103,500< / td>
< / tr>
< tr>
< td> Jonas Alexander< / td>
< td>开发者< / td>
< td>旧金山< / td>
< td> 30< / td>
< td> 2015-11-13< / td>
< td> $ 86,500< / td>
< / tr>
< tr>
< td> Shad Decker< / td>
< td>区域总监< / td>
< td>爱丁堡< / td>
< td> 51< / td>
< td> 2015-11-13< / td>
< td> $ 183,000< / td>
< / tr>
< tr>
< td> Michael Bruce< / td>
< td> Javascript Developer< / td>
< td>新加坡< / td>
< td> 29< / td>
< td> 2015-11-13< / td>
< td> $ 183,000< / td>
< / tr>
< tr>
< td> Donna Snider< / td>
< td>客户支持< / td>
< td>纽约< / td>
< td> 27< / td>
< td> 2015-11-13< / td>
< td> $ 112,000< / td>
< / tr>
< / tbody>
< / table>
解决方案
将您的变量索引更改为4而不是5.
var iStartDateCol = 4;
var iEndDateCol = 4;
数组为0，所以如果你想要第5列，你需要索引4。 >
此外，要清除，您需要将过滤器中的第一个检查更改为：
if（！filterstart&&！filterend）
{
return true;
}
自：
var give_results_daterange = grab_daterange.split（to）;
var filterstart = give_results_daterange [0];
var filterend = give_results_daterange [1];
将导致过滤器未定义。
更新的小提琴：
http： //jsfiddle.net/evcfespn/26/
I am currently using the datatables plug-in for the jQuery https://datatables.net/ with a daterange plugin found here http://www.daterangepicker.com/.
I almost got them to work together but currently stuck with these two issues.
1) when I select my date range it does filter but dosent provide correct results.
2) When I clear my date range results it's not removing the filter.
I made a JSfiddle that closely resembles what I got working at the moment. The Date range filters is the input on the top left. http://jsfiddle.net/evcfespn/18/
Any help would be appreciated at this point. Javascript code:
//Start of the data table
$(document).ready( function () {
var table = $('#example').DataTable({
"dom": '<"toolbar">frtip'
});
$("div.toolbar").html('<input id="date_range" type="text">');
//END of the data table
// Date range script - Start of the sscript
$("#date_range").daterangepicker({
autoUpdateInput: false,
locale: {
"cancelLabel": "Clear",
}
});
$("#date_range").on('apply.daterangepicker', function(ev, picker) {
$(this).val(picker.startDate.format('YYYY-MM-DD') + ' to ' + picker.endDate.format('YYYY-MM-DD'));
table.draw();
});
$("#date_range").on('cancel.daterangepicker', function(ev, picker) {
$(this).val('');
table.draw();
});
// Date range script - END of the script
$.fn.dataTableExt.afnFiltering.push(
function( oSettings, aData, iDataIndex ) {
var grab_daterange = $("#date_range").val();
var give_results_daterange = grab_daterange.split(" to ");
var filterstart = give_results_daterange[0];
var filterend = give_results_daterange[1];
var iStartDateCol = 5; //using column 2 in this instance
var iEndDateCol = 5;
var tabledatestart = aData[iStartDateCol];
var tabledateend= aData[iEndDateCol];
if ( filterstart === "" && filterend === "" )
{
return true;
}
else if ((moment(filterstart).isSame(tabledatestart) || moment(filterstart).isBefore(tabledatestart)) && filterend === "")
{
return true;
}
else if ((moment(filterstart).isSame(tabledatestart) || moment(filterstart).isAfter(tabledatestart)) && filterstart === "")
{
return true;
}
else if ((moment(filterstart).isSame(tabledatestart) || moment(filterstart).isBefore(tabledatestart)) && (moment(filterend).isSame(tabledateend) || moment(filterend).isAfter(tabledateend)))
{
return true;
}
return false;
}
);
//End of the datable
});
HTML table:
<table id="example" class="display" cellspacing="0" width="100%">
<thead>
<tr>
<th>Name</th>
<th>Position</th>
<th>Office</th>
<th>Age</th>
<th>Start date</th>
<th>Salary</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Name</th>
<th>Position</th>
<th>Office</th>
<th>Age</th>
<th>Start date</th>
<th>Salary</th>
</tr>
</tfoot>
<tbody>
<tr>
<td>Tiger Nixon</td>
<td>System Architect</td>
<td>Edinburgh</td>
<td>61</td>
<td>2015-10-01</td>
<td>$320,800</td>
</tr>
<tr>
<td>Garrett Winters</td>
<td>Accountant</td>
<td>Tokyo</td>
<td>63</td>
<td>2015-10-03</td>
<td>$170,750</td>
</tr>
<tr>
<td>Ashton Cox</td>
<td>Junior Technical Author</td>
<td>San Francisco</td>
<td>66</td>
<td>2015-10-03</td>
<td>$86,000</td>
</tr>
<tr>
<td>Cedric Kelly</td>
<td>Senior Javascript Developer</td>
<td>Edinburgh</td>
<td>22</td>
<td>2015-10-05</td>
<td>$433,060</td>
</tr>
<tr>
<td>Airi Satou</td>
<td></td>
<td>Tokyo</td>
<td></td>
<td>2015-10-05</td>
<td></td>
</tr>
<tr>
<td>Brielle Williamson</td>
<td>Integration Specialist</td>
<td>New York</td>
<td>61</td>
<td>2015-10-05</td>
<td>$372,000</td>
</tr>
<tr>
<td>Herrod Chandler</td>
<td>Sales Assistant</td>
<td>San Francisco</td>
<td>59</td>
<td>2015-10-05</td>
<td>$137,500</td>
</tr>
<tr>
<td>Rhona Davidson</td>
<td>Integration Specialist</td>
<td>Tokyo</td>
<td>55</td>
<td>2015-10-07</td>
<td>$327,900</td>
</tr>
<tr>
<td>Colleen Hurst</td>
<td>Javascript Developer</td>
<td>San Francisco</td>
<td>39</td>
<td>2015-10-08</td>
<td>$205,500</td>
</tr>
<tr>
<td>Sonya Frost</td>
<td>Software Engineer</td>
<td>Edinburgh</td>
<td>23</td>
<td>2015-10-13</td>
<td>$103,600</td>
</tr>
<tr>
<td>Jena Gaines</td>
<td>Office Manager</td>
<td>London</td>
<td>30</td>
<td>2015-10-13</td>
<td>$90,560</td>
</tr>
<tr>
<td>Quinn Flynn</td>
<td>Support Lead</td>
<td>Edinburgh</td>
<td>22</td>
<td>2015-10-15</td>
<td>$342,000</td>
</tr>
<tr>
<td>Charde Marshall</td>
<td>Regional Director</td>
<td>San Francisco</td>
<td>36</td>
<td>2015-10-16</td>
<td>$470,600</td>
</tr>
<tr>
<td>Haley Kennedy</td>
<td>Senior Marketing Designer</td>
<td>London</td>
<td>43</td>
<td>2015-10-17</td>
<td>$313,500</td>
</tr>
<tr>
<td>Tatyana Fitzpatrick</td>
<td>Regional Director</td>
<td>London</td>
<td>19</td>
<td>2015-01-18</td>
<td>$385,750</td>
</tr>
<tr>
<td>Michael Silva</td>
<td>Marketing Designer</td>
<td>London</td>
<td>66</td>
<td>2015-10-19</td>
<td>$198,500</td>
</tr>
<tr>
<td>Paul Byrd</td>
<td>Chief Financial Officer (CFO)</td>
<td>New York</td>
<td>64</td>
<td>2015-10-20</td>
<td>$725,000</td>
</tr>
<tr>
<td>Gloria Little</td>
<td>Systems Administrator</td>
<td>New York</td>
<td>59</td>
<td>2015-10-25</td>
<td>$237,500</td>
</tr>
<tr>
<td>Bradley Greer</td>
<td>Software Engineer</td>
<td>London</td>
<td>41</td>
<td>2015-11-26</td>
<td>$132,000</td>
</tr>
<tr>
<td>Dai Rios</td>
<td>Personnel Lead</td>
<td>Edinburgh</td>
<td>35</td>
<td>2015-10-26</td>
<td>$217,500</td>
</tr>
<tr>
<td>Jenette Caldwell</td>
<td>Development Lead</td>
<td>New York</td>
<td>30</td>
<td>2015-10-27</td>
<td>$345,000</td>
</tr>
<tr>
<td>Yuri Berry</td>
<td>Chief Marketing Officer (CMO)</td>
<td>New York</td>
<td>40</td>
<td>2015-10-28</td>
<td>$675,000</td>
</tr>
<tr>
<td>Caesar Vance</td>
<td>Pre-Sales Support</td>
<td>New York</td>
<td>21</td>
<td>2015-10-28</td>
<td>$106,450</td>
</tr>
<tr>
<td>Doris Wilder</td>
<td>Sales Assistant</td>
<td>Sidney</td>
<td>23</td>
<td>2015-10-29</td>
<td>$85,600</td>
</tr>
<tr>
<td>Angelica Ramos</td>
<td>Chief Executive Officer (CEO)</td>
<td>London</td>
<td>47</td>
<td>2015-10-29</td>
<td>$1,200,000</td>
</tr>
<tr>
<td>Gavin Joyce</td>
<td>Developer</td>
<td>Edinburgh</td>
<td>42</td>
<td>2015-10-29</td>
<td>$92,575</td>
</tr>
<tr>
<td>Jennifer Chang</td>
<td>Regional Director</td>
<td>Singapore</td>
<td>28</td>
<td>2015-10-29</td>
<td>$357,650</td>
</tr>
<tr>
<td>Brenden Wagner</td>
<td>Software Engineer</td>
<td>San Francisco</td>
<td>28</td>
<td>2015-11-01</td>
<td>$206,850</td>
</tr>
<tr>
<td>Fiona Green</td>
<td>Chief Operating Officer (COO)</td>
<td>San Francisco</td>
<td>48</td>
<td>2015-11-01</td>
<td>$850,000</td>
</tr>
<tr>
<td>Shou Itou</td>
<td>Regional Marketing</td>
<td>Tokyo</td>
<td>20</td>
<td>2015-11-03</td>
<td>$163,000</td>
</tr>
<tr>
<td>Michelle House</td>
<td>Integration Specialist</td>
<td>Sidney</td>
<td>37</td>
<td>2015-11-04</td>
<td>$95,400</td>
</tr>
<tr>
<td>Suki Burks</td>
<td>Developer</td>
<td>London</td>
<td>53</td>
<td>2015-11-06</td>
<td>$114,500</td>
</tr>
<tr>
<td>Prescott Bartlett</td>
<td>Technical Author</td>
<td>London</td>
<td>27</td>
<td>2015-11-07</td>
<td>$145,000</td>
</tr>
<tr>
<td>Gavin Cortez</td>
<td>Team Leader</td>
<td>San Francisco</td>
<td>22</td>
<td>2015-11-07</td>
<td>$235,500</td>
</tr>
<tr>
<td>Martena Mccray</td>
<td>Post-Sales support</td>
<td>Edinburgh</td>
<td>46</td>
<td>2015-11-07</td>
<td>$324,050</td>
</tr>
<tr>
<td>Unity Butler</td>
<td>Marketing Designer</td>
<td>San Francisco</td>
<td>47</td>
<td>2015-11-08</td>
<td>$85,675</td>
</tr>
<tr>
<td>Howard Hatfield</td>
<td>Office Manager</td>
<td>San Francisco</td>
<td>51</td>
<td>2015-11-08</td>
<td>$164,500</td>
</tr>
<tr>
<td>Hope Fuentes</td>
<td>Secretary</td>
<td>San Francisco</td>
<td>41</td>
<td>2015-11-09</td>
<td>$109,850</td>
</tr>
<tr>
<td>Vivian Harrell</td>
<td>Financial Controller</td>
<td>San Francisco</td>
<td>62</td>
<td>2015-11-09</td>
<td>$452,500</td>
</tr>
<tr>
<td>Timothy Mooney</td>
<td>Office Manager</td>
<td>London</td>
<td>37</td>
<td>2015-11-10</td>
<td>$136,200</td>
</tr>
<tr>
<td>Jackson Bradshaw</td>
<td>Director</td>
<td>New York</td>
<td>65</td>
<td>2015-11-10</td>
<td>$645,750</td>
</tr>
<tr>
<td>Olivia Liang</td>
<td>Support Engineer</td>
<td>Singapore</td>
<td>64</td>
<td>2015-11-11</td>
<td>$234,500</td>
</tr>
<tr>
<td>Bruno Nash</td>
<td>Software Engineer</td>
<td>London</td>
<td>38</td>
<td>2015-11-11</td>
<td>$163,500</td>
</tr>
<tr>
<td>Sakura Yamamoto</td>
<td>Support Engineer</td>
<td>Tokyo</td>
<td>37</td>
<td>2015-11-12</td>
<td>$139,575</td>
</tr>
<tr>
<td>Thor Walton</td>
<td>Developer</td>
<td>New York</td>
<td>61</td>
<td>2015-11-13</td>
<td>$98,540</td>
</tr>
<tr>
<td>Finn Camacho</td>
<td>Support Engineer</td>
<td>San Francisco</td>
<td>47</td>
<td>2015-11-13</td>
<td>$87,500</td>
</tr>
<tr>
<td>Serge Baldwin</td>
<td>Data Coordinator</td>
<td>Singapore</td>
<td>64</td>
<td>2015-11-13</td>
<td>$138,575</td>
</tr>
<tr>
<td>Zenaida Frank</td>
<td>Software Engineer</td>
<td>New York</td>
<td>63</td>
<td>2015-11-13</td>
<td>$125,250</td>
</tr>
<tr>
<td>Zorita Serrano</td>
<td>Software Engineer</td>
<td>San Francisco</td>
<td>56</td>
<td>2015-11-13</td>
<td>$115,000</td>
</tr>
<tr>
<td>Jennifer Acosta</td>
<td>Junior Javascript Developer</td>
<td>Edinburgh</td>
<td>43</td>
<td>2013/02/01</td>
<td>$75,650</td>
</tr>
<tr>
<td>Cara Stevens</td>
<td>Sales Assistant</td>
<td>New York</td>
<td>46</td>
<td>2015-11-13</td>
<td>$145,600</td>
</tr>
<tr>
<td>Hermione Butler</td>
<td>Regional Director</td>
<td>London</td>
<td>47</td>
<td>2015-11-13</td>
<td>$356,250</td>
</tr>
<tr>
<td>Lael Greer</td>
<td>Systems Administrator</td>
<td>London</td>
<td>21</td>
<td>2009/02/27</td>
<td>$103,500</td>
</tr>
<tr>
<td>Jonas Alexander</td>
<td>Developer</td>
<td>San Francisco</td>
<td>30</td>
<td>2015-11-13</td>
<td>$86,500</td>
</tr>
<tr>
<td>Shad Decker</td>
<td>Regional Director</td>
<td>Edinburgh</td>
<td>51</td>
<td>2015-11-13</td>
<td>$183,000</td>
</tr>
<tr>
<td>Michael Bruce</td>
<td>Javascript Developer</td>
<td>Singapore</td>
<td>29</td>
<td>2015-11-13</td>
<td>$183,000</td>
</tr>
<tr>
<td>Donna Snider</td>
<td>Customer Support</td>
<td>New York</td>
<td>27</td>
<td>2015-11-13</td>
<td>$112,000</td>
</tr>
</tbody>
</table>
解决方案
Change your variable index to 4 instead of 5.
var iStartDateCol = 4;
var iEndDateCol = 4;
The array is 0 based, so if you want column 5, you need index 4.
Also, to clear, you need to change the first check in your filter to:
if ( !filterstart && !filterend )
{
return true;
}
Since:
var give_results_daterange = grab_daterange.split(" to ");
var filterstart = give_results_daterange[0];
var filterend = give_results_daterange[1];
Will cause filterend to be undefined. Heres an updated fiddle:
http://jsfiddle.net/evcfespn/26/
这篇关于Datatable - 按日期范围过滤 - 不返回正确的结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
