Skip to content

Get data from google doc for Announcements #1332

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
fhemberger merged 6 commits into from
Sep 6, 2017
Merged

Get data from google doc for Announcements #1332

Changes from 1 commit
Commits
Show all changes
6 commits
Select commit Hold shift + click to select a range
e66db3c
Get data from google doc for Announcements
pierreneter Aug 9, 2017
20a72fe
layouts/announcements.hbs: Use JS standard style
pierreneter Sep 6, 2017
4c0f2d2
remove yarn.lock
pierreneter Sep 6, 2017
b3a81d8
Merge branch 'master' into Announcements
pierreneter Sep 6, 2017
0b2208d
Update in-the-news.hbs
fhemberger Sep 6, 2017
b58216f
Update announcements.hbs
fhemberger Sep 6, 2017
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
layouts/announcements.hbs: Use JS standard style
  • Loading branch information
@pierreneter
pierreneter committed Sep 6, 2017
commit 20a72fe7abdd0fffaf1bb110ae2eb50a9ed154b5
64 changes: 34 additions & 30 deletions layouts/announcements.hbs
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -21,59 +21,63 @@
</div>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/tabletop.js/1.4.2/tabletop.min.js"></script>
<script type="text/javascript">
var public_spreadsheet_url = 'https://docs.google.com/spreadsheets/d/1xwQ6ciZLADL43My_XBIWLVRuDMl8cx_omYd1FRkBZ58/pubhtml';
var mdList = {{{getListJson collections.blogAnnounce}}};
var siteLocal = "/{{site.locale}}/";
var public_spreadsheet_url = 'https://docs.google.com/spreadsheets/d/1xwQ6ciZLADL43My_XBIWLVRuDMl8cx_omYd1FRkBZ58/pubhtml'
var mdList = {{{getListJson collections.blogAnnounce}}}
var siteLocal = "/{{site.locale}}/"

window.onload = function () {
Tabletop.init( { key: public_spreadsheet_url,
callback: showInfo,
simpleSheet: true } )
Tabletop.init(
{
key: public_spreadsheet_url,
callback: showInfo,
simpleSheet: true
}
)

function pad(str) { return ("0"+str).substr(-2) };
function pad (str) { return ('0' + str).substr(-2) }

function parseDate(date) {
function parseDate (date) {
try {
var parsedDate = date.split('.')
return new Date('20' + parsedDate[2], parsedDate[0] - 1, parsedDate[1]);
} catch(_){
return date;
return new Date('20' + parsedDate[2], parsedDate[0] - 1, parsedDate[1])
} catch (_) {
return date
}
}

function formatDate(date) {
return date == "Invalid Date" ? '' : date.getFullYear()+'-'+pad(date.getMonth()+1)+'-'+pad(date.getDate());
function formatDate (date) {
return date === 'Invalid Date' ? '' : date.getFullYear() + '-' + pad(date.getMonth() + 1) + '-' + pad(date.getDate())
}

function showInfo(data, tabletop) {
data.reverse();
var html = '';
var list = document.getElementsByClassName('news-list');
var docList = [];
function showInfo (data, tabletop) {
data.reverse()
var html = ''
var list = document.getElementsByClassName('news-list')
var docList = []

data.forEach(function (row) {
docList.push({
path: row.Link,
title: row.Title,
local: false,
date: parseDate(row.Date)
});
});
})
})

allList = mdList.concat(docList);
allList.sort(function(a, b) {
return new Date(b.date).getTime() - new Date(a.date).getTime();
});
var allList = mdList.concat(docList)
allList.sort(function (a, b) {
return new Date(b.date).getTime() - new Date(a.date).getTime()
})

allList.forEach(function (row) {
if (row && row.date) {
html += '<li><time datetime="'+row.date+'">'+formatDate(new Date(row.date))+'</time>';
html += '<a href="';
html += (row.local) ? siteLocal + row.path : row.path;
html += '">'+row.title+'</a></li>';
html += '<li><time datetime="' + row.date + '">' + formatDate(new Date(row.date)) + '</time>'
html += '<a href="'
html += (row.local) ? siteLocal + row.path : row.path
html += '">' + row.title + '</a></li>'
}
});
if (list && list[0]) list[0].innerHTML = html;
})
if (list && list[0]) list[0].innerHTML = html
}
}
</script>
Expand Down