-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathadmin.js
130 lines (118 loc) · 6.93 KB
/
admin.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
function domReady(fn) {
if (
document.readyState === "complete" ||
document.readyState === "interactive"
) {
setTimeout(fn, 1000);
} else {
document.addEventListener("DOMContentLoaded", fn);
}
}
let data = "";
domReady(function () {
// If found you qr code
function onScanSuccess(decodeText, decodeResult) {
// alert("You Qr is : " + decodeText, decodeResult);
data = decodeText;
createTable();
}
let htmlscanner = new Html5QrcodeScanner(
"my-qr-reader",
{ fps: 10, qrbos: 250 }
);
htmlscanner.render(onScanSuccess);
});
function parseText() {
// Separate the text in data which is separated by a | for example "1|2|3" would mean match one, two cubes, 3 cones
const splitData = data.split("|");
// return the array
return splitData;
}
function createTable() {
// Redo with for loops
// Create .env file to store API link
//The index of the nums in lines 53-60 & 66-73 are not sequential. Did this to put values extracted from QR code is a specific order in table.
//Do not change the ordering as this will change how data is displayed for user and also how data is sent to the spreadsheet.
document.getElementById("myTable").innerHTML = `
<table style="font-family: arial, sans-serif; border-collapse: collapse; width: 100%;">
<tr>
<th style="border: 1px solid #dddddd; text-align: left; padding: 8px;">Team Number</th>
<th style="border: 1px solid #dddddd; text-align: left; padding: 8px;">Match Number</th>
<th style="border: 1px solid #dddddd; text-align: left; padding: 8px;">In Our Alliance</th>
</tr>
<tr>
<td style="border: 1px solid #dddddd; text-align: left; padding: 8px;">`+ parseText()[0]+ `</td>
<td style="border: 1px solid #dddddd; text-align: left; padding: 8px;">`+ parseText()[1]+ `</td>
<td style="border: 1px solid #dddddd; text-align: left; padding: 8px;">`+ parseText()[9]+ `</td>
</tr>
<tr>
<th style="border: 1px solid #dddddd; text-align: left; padding: 8px;">Left Community</th>
<th style="border: 1px solid #dddddd; text-align: left; padding: 8px;">Notes in Speaker</th>
<th style="border: 1px solid #dddddd; text-align: left; padding: 8px;">Notes in Amp</th>
</tr>
<tr>
<td style="border: 1px solid #dddddd; text-align: left; padding: 8px;">`+ parseText()[10]+ `</td>
<td style="border: 1px solid #dddddd; text-align: left; padding: 8px;">`+ parseText()[2]+ `</td>
<td style="border: 1px solid #dddddd; text-align: left; padding: 8px;">`+ parseText()[3]+ `</td>
</tr>
<tr>
<th style="border: 1px solid #dddddd; text-align: left; padding: 8px;">Total Score</th>
<th style="border: 1px solid #dddddd; text-align: left; padding: 8px;">Auto Ranking</th>
<th style="border: 1px solid #dddddd; text-align: left; padding: 8px;">Shot in Speaker Teleop</th>
</tr>
<tr>
<td style="border: 1px solid #dddddd; text-align: left; padding: 8px;">`+ parseText()[11]+ `</td>
<td style="border: 1px solid #dddddd; text-align: left; padding: 8px;">`+ parseText()[4]+ `</td>
<td style="border: 1px solid #dddddd; text-align: left; padding: 8px;">`+ parseText()[5]+ `</td>
</tr>
<tr>
<th style="border: 1px solid #dddddd; text-align: left; padding: 8px;">Shot in Amp Teleop</th>
<th style="border: 1px solid #dddddd; text-align: left; padding: 8px;">Speed Teleop</th>
<th style="border: 1px solid #dddddd; text-align: left; padding: 8px;">Coopertition Bonus</th>
</tr>
<tr>
<td style="border: 1px solid #dddddd; text-align: left; padding: 8px;">`+ parseText()[6]+ `</td>
<td style="border: 1px solid #dddddd; text-align: left; padding: 8px;">`+ parseText()[7]+ `</td>
<td style="border: 1px solid #dddddd; text-align: left; padding: 8px;">`+ parseText()[12]+ `</td>
</tr>
<tr>
<th style="border: 1px solid #dddddd; text-align: left; padding: 8px;">Complete Throw</th>
<th style="border: 1px solid #dddddd; text-align: left; padding: 8px;">Robot Parked</th>
<th style="border: 1px solid #dddddd; text-align: left; padding: 8px;">Where On Chain</th>
</tr>
<tr>
<td style="border: 1px solid #dddddd; text-align: left; padding: 8px;">`+ parseText()[13]+ `</td>
<td style="border: 1px solid #dddddd; text-align: left; padding: 8px;">`+ parseText()[14]+ `</td>
<td style="border: 1px solid #dddddd; text-align: left; padding: 8px;">`+ parseText()[15]+ `</td>
</tr>
<tr>
<th style="border: 1px solid #dddddd; text-align: left; padding: 8px;">How Many Teams</th>
<th style="border: 1px solid #dddddd; text-align: left; padding: 8px;">Score In Trap</th>
</tr>
<tr>
<td style="border: 1px solid #dddddd; text-align: left; padding: 8px;">`+ parseText()[8]+ `</td>
<td style="border: 1px solid #dddddd; text-align: left; padding: 8px;">`+ parseText()[16]+ `</td>
</tr>
</table>
<form method="POST" action="https://script.google.com/macros/s/AKfycbyuop7CV1OKZhyZ-m1nqhgLdCMDOwluWWRIsVWVCMKKqxSE4YdOq8pYmuqC0efHHzkwPw/exec">
<input type="hidden" name="Team Number" value="`+ parseText()[0]+ `">
<input type="hidden" name="Match Number" value="`+ parseText()[1]+ `">
<input type="hidden" name="In Our Alliance" value="`+ parseText()[9]+ `">
<input type="hidden" name="Left Community" value="`+ parseText()[10]+ `">
<input type="hidden" name="Notes in Speaker" value="`+ parseText()[2]+ `">
<input type="hidden" name="Notes in Amp" value="`+ parseText()[3]+ `">
<input type="hidden" name="Total Score" value="`+ parseText()[11]+ `">
<input type="hidden" name="Ranking" value="`+ parseText()[4]+ `">
<input type="hidden" name="Shot in Speaker Teleop" value="`+ parseText()[5]+ `">
<input type="hidden" name="Shot in Amp Teleop" value="`+ parseText()[6]+ `">
<input type="hidden" name="Speed Teleop" value="`+ parseText()[7]+ `">
<input type="hidden" name="Coopertition Bonus" value="`+ parseText()[12]+ `">
<input type="hidden" name="Complete Throw" value="`+ parseText()[13]+ `">
<input type="hidden" name="Robot Parked" value="`+ parseText()[14]+ `">
<input type="hidden" name="Where On Chain" value="`+ parseText()[15]+ `">
<input type="hidden" name="How Many Teams" value="`+ parseText()[8]+ `">
<input type="hidden" name="Score In Trap" value="`+ parseText()[16]+ `">
<button type="submit">Send to Spreadsheet</button>
</form>
`;
}