1 files changed, 68 insertions, 0 deletions
diff --git a/vartak-results-final.awk b/vartak-results-final.awk
new file mode 100755
index 0000000..a156277
--- /dev/null
+++ b/vartak-results-final.awk
@@ -0,0 +1,68 @@
+#!/bin/awk -f
+
+BEGIN { FS="," }
+FNR == 1 { next }
+FILENAME ~ /\/?names.csv$/ { names[$1] = $NF; next }
+FILENAME ~ /\/?marks.csv$/ { marks[$1] = $NF; next }
+FILENAME ~ /\/?CGP.csv$/ { gpas[$1] = $NF; next }
+
+END {
+	i = 1
+	for (sn in names) {
+		order[i++] = sn
+		if (marks[sn] == 0) { marks[sn] = ""; results[sn] = "AB" }
+		else if (gpas[sn] == 0) results[sn] = "F"
+		else results[sn] = gpas[sn]
+	}
+
+	if (sort == "yes") {
+		rank="\n\t\t\t<th>Rank</th>\n"
+		n = length(order)
+		for (i in order) {
+			max = i
+			for (j = i; j <= n; j++) {
+				sn1 = order[max]; sn2 = order[j]
+				if (results[sn1] == results[sn2]) {
+					if (marks[sn1] < marks[sn2]) max = j
+				}
+				else if (results[sn1] == "AB") max = j
+				else if (results[sn1] == "F") {
+					if (results[sn2] != "AB") max = j
+				}
+				else if (gpas[sn1] < gpas[sn2]) max = j
+			}
+			if (max != i) { t = order[i]; order[i] = order[max]; order[max] = t }
+		}
+	}
+
+	print("<table>\n\
+	<thead>\n\
+		<tr>\n" rank\
+"			<th>Seat<br>No.</th>\n\
+			<th>Name</th>\n\
+			<th>Total<br>Marks</th>\n\
+			<th>GPA</th>\n\
+		</tr>\n\
+	</thead>\n\
+	<tbody>")
+	for (i in order) {
+		sn = order[i]
+		if (results[sn] == "AB") {
+			print("\t\t<tr class=\"absent\">")
+		} else if (results[sn] == "F") {
+			print("\t\t<tr class=\"fail\">")
+		} else if (gpas[sn] >= 9) {
+			print("\t\t<tr class=\"pass notable\">")
+		} else {
+			print("\t\t<tr class=\"pass\">")
+		}
+		if (sort == "yes") printf("\t\t\t<td class=\"numeric\">%s</td>\n", i)
+		printf("\t\t\t<td class=\"numeric\">%s</td>\n", sn)
+		printf("\t\t\t<td class=\"name\">%s</td>\n", names[sn])
+		printf("\t\t\t<td class=\"numeric\">%s</td>\n", marks[sn])
+		printf("\t\t\t<td class=\"numeric\">%s</td>\n", results[sn])
+		print("\t\t</tr>")
+	}
+	print("\t</tbody>")
+	print("</table>")
+}