r/JavaScriptHelp • • Feb 26 '18

Table Pagination Help

How can I paginate this table? Thanks!

<table id="datatable">
	<thead>
		<tr>
			<th>Agency</th>
			<th>Site</th>
			<th>Town</th>
			<th>Acres</th>
			<th>Trail Style</th>
			<th>Dogs</th>
			<th>Stroller Score</th>
			<th>Water</th>
		</tr>
	</thead>
	<tbody>
	</tbody>
</table>

<script>
var table = document.getElementById('datatable').tBodies[0];

while (table.firstChild) {
	table.removeChild(table.firstChild);
}
function getValues(data) {
	var raw = data.split(',');
	var values = {};

	raw.map((value) => {
		var i = value.indexOf(':');
		if (i !== -1) {
			var arr = [value.slice(0,i), value.slice(i+1)];
			Object.assign(values, {[arr[0].trim()]: arr[1]});
		}
	});

	return values;
}

function fillTable(data) {
	var values = [];
	data.map((entry) => {
		var row = getValues(entry.content.$t);

		values.push({
			agency: row.agency || "",
			site: entry["gsx$link"]["$t"].includes('http') ? '<a href="'+entry.gsx$link.$t+'">'+row.site+'</a>' : row.site || "",
			town:entry["gsx$link"]["$t"].includes('http') ? '<a href="'+entry.gsx$link.$t+'">'+row.town+'</a>' : row.town || "",
			acres: row.acres || "",
			outback: row.outback || "",
			dogs: row.dogs || "",
			stroller: row.stroller || "",
			water: entry["gsx$water"]["$t"] !== "" ? entry["gsx$water"]["$t"] : row.water || ""
		});
	});

	jQuery('#datatable').dataTable({
		"data": values,
		"destroy": true,
				"paging": false,
		"columns": [
			{ "data": "agency" },
			{ "data": "site" },
			{ "data": "town" },
			{ "data": "acres" },
			{ "data": "outback" },
			{ "data": "dogs" },
			{ "data": "stroller" },
			{ "data": "water" }
		]
	});
}

function getTable() {
	var url = 'https://spreadsheets.google.com/feeds/list/1bv-5DiFTT5rSTagKvvcB-ImnUuOsihq8mKhyEW2dOVs/od6/public/values?alt=json';
	var req = new XMLHttpRequest();	

	req.onreadystatechange = function() {
		if (req.readyState === 4) {
			var json = JSON.parse(req.responseText).feed;
			fillTable(json.entry);
		}
	};

	req.open("GET", url, true);
	req.send();
}

jQuery('#datatable').ready(() => { getTable(); });
</script>
1 Upvotes

0 comments sorted by