Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var sortedJSONData=[];
- var arr = [];
- var crr=[];
- crr=[{date:"2014-10-29 01:47:47.0",assigned: 0.5},{date:"2014-10-30 01:47:36.0",assigned: 0.4},{date:"2014-10-31 01:47:32.0",assigned: 0.4},{date:"2014-11-01 01:47:36.0",assigned: 0.4},{date:"2014-11-02 01:47:40.0",assigned: 0.4},{date:"2014-11-03 01:47:27.0",assigned: 0.4},{date:"2014-11-04 01:47:54.0",assigned: 0.4},{date:"2014-11-05 01:47:32.0",assigned: 0.5},{date:"2014-11-06 01:47:41.0",assigned: 0.4},{date:"2014-11-07 01:47:37.0",assigned: 0.4},{date:"2014-11-08 01:47:40.0",assigned: 0.5},{date:"2014-11-09 01:47:33.0",assigned: 0.5},{date:"2014-11-10 01:47:25.0",assigned: 0.5},{date:"2014-11-11 01:47:35.0",assigned: 0.6},{date:"2014-11-12 01:47:34.0",assigned: 0.6},{date:"2014-11-13 01:47:39.0",assigned: 0.6},{date:"2014-11-14 01:47:37.0",assigned: 0.5},{date:"2014-11-15 01:47:35.0",assigned: 0.5},{date:"2014-11-16 01:47:24.0",assigned: 0.5},{date:"2014-11-17 01:47:22.0",assigned: 0.5},{date:"2014-11-18 01:47:04.0",assigned: 0.4},{date:"2014-11-19 01:47:41.0",assigned: 0.4},{date:"2014-11-20 01:47:06.0",assigned: 0.5},{date:"2014-11-21 01:47:56.0",assigned: 0.6},{date:"2014-11-22 01:47:37.0",assigned: 0.5},{date:"2014-11-23 01:47:34.0",assigned: 0.5},{date:"2014-11-24 01:47:42.0",assigned: 0.5},{date:"2014-11-25 01:47:32.0",assigned: 0.4},{date:"2014-11-26 01:47:25.0",assigned: 0.4},{date:"2014-11-27 01:47:36.0",assigned: 0.4},{date:"2014-11-28 01:47:30.0",assigned: 0.4},{date:"2014-11-29 01:47:25.0",assigned: 0.4},{date:"2014-11-30 01:47:44.0",assigned: 0.4},{date:"2014-12-01 01:47:44.0",assigned: 0.5},{date:"2014-12-02 01:47:32.0",assigned: 0.5},{date:"2014-12-03 01:47:49.0",assigned: 0.4},{date:"2014-12-04 01:47:42.0",assigned: 0.4},{date:"2014-12-05 01:47:42.0",assigned: 0.3},{date:"2014-12-06 01:47:39.0",assigned: 0.4},{date:"2014-12-07 01:47:41.0",assigned: 0.4},{date:"2014-12-08 01:47:39.0",assigned: 0.4},{date:"2014-12-09 01:47:28.0",assigned: 0.4},{date:"2014-12-10 01:47:59.0",assigned: 0.4},{date:"2014-12-11 01:47:48.0",assigned: 0.4},{date:"2014-12-12 01:47:37.0",assigned: 0.5},{date:"2014-12-13 01:47:36.0",assigned: 0.4},{date:"2014-12-14 01:47:27.0",assigned: 0.4},{date:"2014-12-15 01:47:30.0",assigned: 0.4},{date:"2014-12-16 01:47:32.0",assigned: 0.5},{date:"2014-12-17 01:47:33.0",assigned: 0.4},{date:"2014-12-18 01:47:44.0",assigned: 0.5},{date:"2014-12-19 01:47:22.0",assigned: 0.4},{date:"2014-12-20 01:47:31.0",assigned: 0.4},{date:"2014-12-21 01:47:22.0",assigned: 0.4},{date:"2014-12-22 01:47:17.0",assigned: 0.4},{date:"2014-12-23 01:47:17.0",assigned: 0.4},{date:"2014-12-24 01:47:26.0",assigned: 0.4},{date:"2014-12-25 01:47:13.0",assigned: 0.4},{date:"2014-12-26 01:47:22.0",assigned: 0.4},{date:"2014-12-27 01:47:37.0",assigned: 0.4},{date:"2014-12-28 01:47:26.0",assigned: 0.4},{date:"2014-12-29 01:47:54.0",assigned: 0.4},{date:"2014-12-30 01:47:58.0",assigned: 0.3},{date:"2014-12-31 01:47:39.0",assigned: 0.3},{date:"2015-01-01 01:47:56.0",assigned: 0.2},{date:"2015-01-02 01:47:40.0",assigned: 0.2},{date:"2015-01-03 01:47:31.0",assigned: 0.2},{date:"2015-01-04 01:47:30.0",assigned: 0.2},{date:"2015-01-05 01:47:22.0",assigned: 0.2},{date:"2015-01-06 01:47:38.0",assigned: 0.3},{date:"2015-01-07 01:47:34.0",assigned: 0.2},{date:"2015-01-08 01:47:30.0",assigned: 0.2},{date:"2015-01-09 01:47:31.0",assigned: 0.2},{date:"2015-01-10 01:47:29.0",assigned: 0.2},{date:"2015-01-11 01:47:31.0",assigned: 0.2},{date:"2015-01-12 01:47:28.0",assigned: 0.2},{date:"2015-01-13 01:48:03.0",assigned: 0.2},{date:"2015-01-14 01:47:55.0",assigned: 0.2},{date:"2015-01-15 01:48:15.0",assigned: 0.2},{date:"2015-01-16 01:47:45.0",assigned: 0.3},{date:"2015-01-17 01:47:33.0",assigned: 0.3},{date:"2015-01-18 01:47:14.0",assigned: 0.3},{date:"2015-01-19 01:47:20.0",assigned: 0.3},{date:"2015-01-20 01:47:35.0",assigned: 0.3},{date:"2015-01-21 01:47:29.0",assigned: 0.3},{date:"2015-01-22 01:47:16.0",assigned: 0.3},{date:"2014-10-29 01:47:47.0",unassigned: 0.0},{date:"2014-10-30 01:47:36.0",unassigned: 0.0},{date:"2014-10-31 01:47:32.0",unassigned: 0.0},{date:"2014-11-01 01:47:36.0",unassigned: 0.0},{date:"2014-11-02 01:47:40.0",unassigned: 0.0},{date:"2014-11-03 01:47:27.0",unassigned: 0.0},{date:"2014-11-04 01:47:54.0",unassigned: 0.0},{date:"2014-11-05 01:47:32.0",unassigned: 0.0},{date:"2014-11-06 01:47:41.0",unassigned: 0.0},{date:"2014-11-07 01:47:37.0",unassigned: 0.0},{date:"2014-11-08 01:47:40.0",unassigned: 0.0},{date:"2014-11-09 01:47:33.0",unassigned: 0.0},{date:"2014-11-10 01:47:25.0",unassigned: 0.0},{date:"2014-11-11 01:47:35.0",unassigned: 0.0},{date:"2014-11-12 01:47:34.0",unassigned: 0.0},{date:"2014-11-13 01:47:39.0",unassigned: 0.0},{date:"2014-11-14 01:47:37.0",unassigned: 0.0},{date:"2014-11-15 01:47:35.0",unassigned: 0.0},{date:"2014-11-16 01:47:24.0",unassigned: 0.0},{date:"2014-11-17 01:47:22.0",unassigned: 0.0},{date:"2014-11-18 01:47:04.0",unassigned: 0.0},{date:"2014-11-19 01:47:41.0",unassigned: 0.0},{date:"2014-11-20 01:47:06.0",unassigned: 0.0},{date:"2014-11-21 01:47:56.0",unassigned: 0.0},{date:"2014-11-22 01:47:37.0",unassigned: 0.0},{date:"2014-11-23 01:47:34.0",unassigned: 0.0},{date:"2014-11-24 01:47:42.0",unassigned: 0.0},{date:"2014-11-25 01:47:32.0",unassigned: 0.0},{date:"2014-11-26 01:47:25.0",unassigned: 0.0},{date:"2014-11-27 01:47:36.0",unassigned: 0.0},{date:"2014-11-28 01:47:30.0",unassigned: 0.0},{date:"2014-11-29 01:47:25.0",unassigned: 0.0},{date:"2014-11-30 01:47:44.0",unassigned: 0.0},{date:"2014-12-01 01:47:44.0",unassigned: 0.0},{date:"2014-12-02 01:47:32.0",unassigned: 0.0},{date:"2014-12-03 01:47:49.0",unassigned: 0.0},{date:"2014-12-04 01:47:42.0",unassigned: 0.0},{date:"2014-12-05 01:47:42.0",unassigned: 0.0},{date:"2014-12-06 01:47:39.0",unassigned: 0.0},{date:"2014-12-07 01:47:41.0",unassigned: 0.0},{date:"2014-12-08 01:47:39.0",unassigned: 0.0},{date:"2014-12-09 01:47:28.0",unassigned: 0.0},{date:"2014-12-10 01:47:59.0",unassigned: 0.0},{date:"2014-12-11 01:47:48.0",unassigned: 0.0},{date:"2014-12-12 01:47:37.0",unassigned: 0.0},{date:"2014-12-13 01:47:36.0",unassigned: 0.0},{date:"2014-12-14 01:47:27.0",unassigned: 0.0},{date:"2014-12-15 01:47:30.0",unassigned: 0.0},{date:"2014-12-16 01:47:32.0",unassigned: 0.0},{date:"2014-12-17 01:47:33.0",unassigned: 0.0},{date:"2014-12-18 01:47:44.0",unassigned: 0.0},{date:"2014-12-19 01:47:22.0",unassigned: 0.0},{date:"2014-12-20 01:47:31.0",unassigned: 0.0},{date:"2014-12-21 01:47:22.0",unassigned: 0.0},{date:"2014-12-22 01:47:17.0",unassigned: 0.0},{date:"2014-12-23 01:47:17.0",unassigned: 0.0},{date:"2014-12-24 01:47:26.0",unassigned: 0.0},{date:"2014-12-25 01:47:13.0",unassigned: 0.0},{date:"2014-12-26 01:47:22.0",unassigned: 0.0},{date:"2014-12-27 01:47:37.0",unassigned: 0.0},{date:"2014-12-28 01:47:26.0",unassigned: 0.0},{date:"2014-12-29 01:47:54.0",unassigned: 0.0},{date:"2014-12-30 01:47:58.0",unassigned: 0.0},{date:"2014-12-31 01:47:39.0",unassigned: 0.0},{date:"2015-01-01 01:47:56.0",unassigned: 0.0},{date:"2015-01-02 01:47:40.0",unassigned: 0.0},{date:"2015-01-03 01:47:31.0",unassigned: 0.0},{date:"2015-01-04 01:47:30.0",unassigned: 0.0},{date:"2015-01-05 01:47:22.0",unassigned: 0.0},{date:"2015-01-06 01:47:38.0",unassigned: 0.0},{date:"2015-01-07 01:47:34.0",unassigned: 0.0},{date:"2015-01-08 01:47:30.0",unassigned: 0.0},{date:"2015-01-09 01:47:31.0",unassigned: 0.0},{date:"2015-01-10 01:47:29.0",unassigned: 0.0},{date:"2015-01-11 01:47:31.0",unassigned: 0.0},{date:"2015-01-12 01:47:28.0",unassigned: 0.0},{date:"2015-01-13 01:48:03.0",unassigned: 0.0},{date:"2015-01-14 01:47:55.0",unassigned: 0.0},{date:"2015-01-15 01:48:15.0",unassigned: 0.0},{date:"2015-01-16 01:47:45.0",unassigned: 0.0},{date:"2015-01-17 01:47:33.0",unassigned: 0.0},{date:"2015-01-18 01:47:14.0",unassigned: 0.0},{date:"2015-01-19 01:47:20.0",unassigned: 0.0},{date:"2015-01-20 01:47:35.0",unassigned: 0.0},{date:"2015-01-21 01:47:29.0",unassigned: 0.0},{date:"2015-01-22 01:47:16.0",unassigned: 99.0}];
- for (var i = 0; i < crr.length; i++) {
- crr[i].date=crr[i].date.substring(0, 10);
- }
- //console.log(crr);
- // Create a comparison function to sort on the pubDate element in each object
- function getSortedJSONData(a, b) {
- var prevDate = Date.parse(a.date); // Get milliseconds for date/time string
- var nextDate = Date.parse(b.date); // Get milliseconds for date/time string
- return prevDate - nextDate;
- }
- // Sort all objects in the array using the comparison function
- sortedJSONData=crr.sort(getSortedJSONData);
- var input = [];
- for (var i = 0; i < sortedJSONData.length; i++) {
- if ((i + 1) != sortedJSONData.length && i % 2 != 1) {
- if (sortedJSONData[i].unassigned!=null) {
- input.push({
- "Date": sortedJSONData[i].date,
- "Assigned": sortedJSONData[i].unassigned,
- "Unassigned": sortedJSONData[i + 1].assigned
- });}else
- input.push({
- "Date": sortedJSONData[i].date,
- "Assigned": sortedJSONData[i].assigned,
- "Unassigned": sortedJSONData[i + 1].unassigned
- });
- }
- }
- console.log(input);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement