根据开始日期和结束日期筛选JSON
Filter JSON based on startdate and enddate
我的JSON如下所示:
[
{
"date": "2015-06-19",
"operator": "ums.dam",
"type": "General Query",
"subType": "Sales",
"message": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque tempus odio purus, sit amet semper leo congue eu. Aliquam erat."
},
{
"date": "2015-06-17",
"operator": "ums.rdl",
"type": "General Query",
"subType": "Media",
"message": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque tempus odio purus, sit amet semper leo congue eu. Aliquam erat."
},
{
"date": "2015-06-17",
"operator": "ums.dam",
"type": "General Query",
"subType": "Other",
"message": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque tempus odio purus, sit amet semper leo congue eu. Aliquam erat."
},
{
"date": "2015-06-16",
"operator": "ums.djf",
"type": "General Query",
"subType": "Press",
"message": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque tempus odio purus, sit amet semper leo congue eu. Aliquam erat."
},
{
"date": "2015-06-15",
"operator": "ums.djf",
"type": "Troubleshooting",
"subType": "Service",
"message": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque tempus odio purus, sit amet semper leo congue eu. Aliquam erat."
},
{
"date": "2015-06-15",
"operator": "ums.djf",
"type": "General Query",
"subType": "Sales",
"message": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque tempus odio purus, sit amet semper leo congue eu. Aliquam erat."
},
{
"date": "2015-06-15",
"operator": "ums.djf",
"type": "General Query",
"subType": "Other",
"message": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque tempus odio purus, sit amet semper leo congue eu. Aliquam erat."
},
{
"date": "2015-06-04",
"operator": "ums.jxh",
"type": "Account Maintenance",
"subType": "Add/Remove Feature",
"message": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque tempus odio purus, sit amet semper leo congue eu. Aliquam erat."
},
{
"date": "2015-06-04",
"operator": "ums.djf",
"type": "Account Maintenance",
"subType": "Add/Remove Feature",
"message": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque tempus odio purus, sit amet semper leo congue eu. Aliquam erat."
},
{
"date": "2015-06-04",
"operator": "ums.djf",
"type": "Troubleshooting",
"subType": "Service",
"message": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque tempus odio purus, sit amet semper leo congue eu. Aliquam erat."
},
{
"date": "2015-06-04",
"operator": "ums.djf",
"type": "General Query",
"subType": "Other",
"message": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque tempus odio purus, sit amet semper leo congue eu. Aliquam erat."
},
{
"date": "2015-06-01",
"operator": "ums.djf",
"type": "General Query",
"subType": "Manual Activation",
"message": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque tempus odio purus, sit amet semper leo congue eu. Aliquam erat."
},
{
"date": "2015-06-01",
"operator": "ums.djf",
"type": "General Query",
"subType": "Manual Activation",
"message": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque tempus odio purus, sit amet semper leo congue eu. Aliquam erat."
}
]
JSON来自外部来源,在生产中是动态的,但所有来源都具有相同的结构。
用户将有三个输入:
- 选择JSON源的第一个输入(出于演示目的删除)
- 选择开始日期以开始返回JSON数据的第二个输入(例如2015-06-01)
- 选择结束日期以结束返回JSON数据的第三个输入(例如2015-06-19)
这是表单HTML:
<div class="row">
<form id="search" role="form" style="border:0">
<div class="col-md-3">
<ul class="nav nav-stacked">
<li><strong>From Date</strong></li>
<li>
<input type="text" class="form-control" placeholder="yyyy-mm-dd" id="dateFrom" />
</li>
</ul>
</div>
<div class="col-md-3">
<ul class="nav nav-stacked">
<li><strong>To Date</strong></li>
<li>
<input type="text" class="form-control" placeholder="yyyy-mm-dd" id="dateTo" />
</li>
</ul>
</div>
<div class="col-md-3">
<ul class="nav nav-stacked">
<li> </li>
<li>
<button class="btn btn-primary" type="button" id="getJsonSrc">Search</button>
</li>
</ul>
</div>
</form>
</div>
<!-- Row -->
这是javascript:
$("#getJsonSrc").click(function() {
var $table = $("#dataTable"),
$startDate = $("#dateFrom").val(),
$endDate = $("#dateTo").val(),
$jsonSrc = "https://s3-us-west-2.amazonaws.com/s.cdpn.io/77979/demo.json"; //for demo only - in production this will come from 1st input val()
/* This is the code that is not working */
$jsonSrc = filter(function(i, fromDate, toDate) {
return ($jsonSrc.date < $startDate && $jsonSrc.date > $endDate)
});
$table.bootstrapTable("destroy");
$table.bootstrapTable();
$table.bootstrapTable("refresh", {
url: $jsonSrc
});
});
本质上,我想要的是当用户点击搜索时,页面会获得JSON源URL,但只返回输入日期之间的数据(包括输入日期)。JSON随后被输出到引导数据表中。
我通常提供一个jsFiddle示例,但是我没有办法让fiddle读取外部JSON文件,所以希望代码笔示例可以:)
http://codepen.io/lordtubington/pen/GJOVpy
注意:我意识到引导表有一个过滤器扩展https://github.com/lukaskral/bootstrap-table-filter然而,这个过滤器扩展在数据被提取之后工作。我的用户将请求包含数千条记录的文件,我不能让他们获取所有记录,然后应用日期过滤器:)
我通过以下方式修复了代码:
http://codepen.io/anon/pen/pJdMxv
我所做的更改:我通过jquery加载json,为开始日期、结束日期和obj日期创建日期对象,然后创建一个新的Array,并在数组中推送所有匹配的日期。
$("#getJsonSrc").click(function() {
var $table = $("#dataTable"),
$startDate = new Date($("#dateFrom").val()),
$endDate = new Date($("#dateTo").val()),
$jsonSrc = "https://s3-us-west-2.amazonaws.com/s.cdpn.io/77979/demo.json";
$.getJSON($jsonSrc).success(function(data) {
my_array = new Array();
for (var i = 0; i < data.length; i++) {
var this_date = new Date(data[i].date);
if ((this_date >= $startDate) && (this_date <= $endDate)) {
my_array.push(data[i]);
}
}
console.log(my_array);
$table.bootstrapTable("destroy");
$table.bootstrapTable();
$table.bootstrapTable("refresh", {
url: my_array
});
});
});
原来我不需要JSON.stringify(my_array)
,我需要使用load
选项而不是data
。以下是工作代码:
$("#getJsonSrc").click(function() {
$("#dataTable thead").show();
var $table = $("#dataTable"),
$startDate = new Date($("#dateFrom").val()),
$endDate = new Date($("#dateTo").val()),
$jsonSrc = "https://s3-us-west-2.amazonaws.com/s.cdpn.io/77979/demo.json";
var my_array;
$.getJSON($jsonSrc).success(function(data) {
my_array = [];
for (var i = 0; i < data.length; i++) {
var this_date = new Date(data[i].date);
if ((this_date >= $startDate) && (this_date <= $endDate)) {
my_array.push(data[i]);
}
}
$table.bootstrapTable("load", my_array);
});
});
<link href="//maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css" rel="stylesheet" />
<link href="https://rawgit.com/wenzhixin/bootstrap-table/master/src/bootstrap-table.css" rel="stylesheet" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js"></script>
<script src="https://rawgit.com/wenzhixin/bootstrap-table/master/src/bootstrap-table.js"></script>
<div class="container">
<div class="row">
<form id="search" role="form" style="border:0">
<div class="col-md-3">
<ul class="nav nav-stacked">
<li><strong>From Date</strong>
</li>
<li>
<input type="text" class="form-control" placeholder="yyyy-mm-dd" id="dateFrom" value="2015-06-17" />
</li>
</ul>
</div>
<div class="col-md-3">
<ul class="nav nav-stacked">
<li><strong>To Date</strong>
</li>
<li>
<input type="text" class="form-control" placeholder="yyyy-mm-dd" id="dateTo" value="2015-06-19" />
</li>
</ul>
</div>
<div class="col-md-3">
<ul class="nav nav-stacked">
<li> </li>
<li>
<button class="btn btn-primary" type="button" id="getJsonSrc">Search</button>
</li>
</ul>
</div>
</form>
</div>
<!-- Row -->
<div class="row">
<div class="col-md-12">
<table id="dataTable" data-toggle="table" data-pagination="true" data-page-size="5" data-page-list="5, 10, All" data-search="true" data-search-align="left" data-striped="true" data-show-refresh="true" data-sort-name="date" data-sort-order="desc">
<thead>
<tr>
<th class="col-xs-1" data-field="date">Date</th>
<th class="col-xs-1" data-field="operator">Operator</th>
<th class="col-xs-2" data-field="type">Type</th>
<th class="col-xs-2" data-field="subType">Sub Type</th>
<th class="col-xs-5" data-field="message">Message</th>
</tr>
</thead>
</table>
</div>
</div>
</div>
相关文章:
- 按日期排序和筛选
- 拉力赛应用程序 SDK 2.0:无法按日期筛选
- 开始日期和结束日期输入字段的 JQuery 筛选器表
- 如何使用 OData 查询选项按日期进行筛选
- 我们可以将控制器中的JSON数据(MM/DD/YYYY格式)与今天的's日期,并在数组中显示筛选列表
- 范围中匹配日期值的自定义ng筛选器
- 使用new date()将数据与当前日期的MM/DD/YYYY格式的日期进行比较和筛选,同时从用户输入值中减去new d
- Videogular-hh:mm:ss格式的日期筛选器不起作用
- mongoDB动态查询中的日期筛选器
- 多次应用日期筛选器
- 用于筛选日期范围之间的数据的沙发基视图
- 将“剑道网格”列显示为“日期时间”,但在筛选时忽略“时间”
- 剑道 UI 中列表视图的日期筛选器
- 角度日期筛选器未在 ng 值中筛选
- 按日期筛选角度数据
- 具有/Date(###########)格式的AngularJS日期筛选器
- AngularJS日期筛选器未生成结果
- 根据开始日期和结束日期筛选JSON
- Angular JS按日期筛选不起作用
- 角度日期筛选器不适用于Stripe时间戳