1 var load_l3 = function(sheet, prefix, cb)
3 var req = new XMLHttpRequest();
4 req.onload = function(e) {
5 var response = JSON.parse(req.responseText);
8 for (i = 0; i < response.values.length; ++i) {
9 if (response.values[i][0] === 'Number') {
15 for ( ; response.values[i] !== undefined && response.values[i].length >= 3; ++i) {
16 var number = response.values[i][0];
17 var display_number = response.values[i][1];
19 number = display_number;
21 var text = response.values[i][2];
22 if (display_number !== undefined && display_number !== '') {
23 text = " " + display_number + " " + text;
25 var subtext = response.values[i][3];
26 if (subtext === undefined || subtext === '') {
27 subtext = 'TrønDisk 2017';
30 l3s[prefix + number] = {
37 req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/1RciMlauWxqM9LYKdsY6lPjJbIAcHJpCXTqyZSEHxH3U/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU');
41 var current_quick_l3s = [];
43 function quicklowerthird()
45 var code = current_quick_l3s[state['code']];
46 if (code === undefined) {
49 document.getElementById('lowerthird-headline-content').innerHTML = code.text;
50 document.getElementById('lowerthird-subheading-content').innerHTML = code.subtext;
53 if (state['code'].match(/^C/) === null) {
54 setTimeout(function() { hidelowerthird(); }, 4000);
58 function loadquickl3s()
60 var sheet_a = state['A'];
61 var sheet_b = state['B'];
62 var sheet_c = 'Calls';
67 var cb = function(response, group_name) {
68 for (var p in response) {
69 if (response.hasOwnProperty(p)) {
70 newl3s[p] = response[p];
73 if (--num_left == 0) {
74 current_quick_l3s = newl3s;
78 load_l3(sheet_a, 'A', cb);
79 load_l3(sheet_b, 'B', cb);
80 load_l3(sheet_c, 'C', cb);
84 state = { 'A': 'TFK', 'B': 'ESK' };