diff options
| -rwxr-xr-x | cli.js | 10 | ||||
| -rw-r--r-- | db.js | 6 | ||||
| -rw-r--r-- | zeitung/parts/citations.tex | 2 | ||||
| -rw-r--r-- | zeitung/parts/generated/quotes/.gitkeep | 0 |
4 files changed, 16 insertions, 2 deletions
@@ -197,6 +197,16 @@ if ((idx = params.indexOf("-r")) > -1) { // Quotes boats coats floats goats oats textex = ""; + textex += `\\subsection*{${data.quotes[0].class}}\n` + data.quotes.forEach((quote, i) => { + if (i > 1 && quote.class !== data.quotes[i-1].class) textex += `\\subsection*{${quote.class}}\n`; + textex += `\\textbf{${quote.name} ${quote.middlename || ""} ${quote.surname}}: ${quote.quote}\\newline \n`.replace(/ +/, " ").replace(/%/g, "\\%"); + + }); + await fs.writeFile( + __dirname + "/zeitung/parts/generated/quotes/quotes.tex", + textex, + ); }); }); console.log("Probably finished?"); @@ -270,7 +270,11 @@ class DB { user.chars = await this.query("SELECT txt from profile_char where profile_id=" + user.id); } - return { users, profile, questions, ranking }; + const quotes = await this.query( + "SELECT q.id, a.name, a.middlename, a.surname, q.quote, c.name class FROM quotes q INNER JOIN users a ON q.author_id = a.id INNER JOIN class c ON a.class_id = c.id ORDER BY c.id, a.surname, a.name, a.middlename", + ); + + return { users, profile, questions, ranking, quotes }; } async query(query, params) { diff --git a/zeitung/parts/citations.tex b/zeitung/parts/citations.tex index 62e23e5..a05185c 100644 --- a/zeitung/parts/citations.tex +++ b/zeitung/parts/citations.tex @@ -1,2 +1,2 @@ \title{Zitate} -\lipsum[1-2] +\generated{quotes/quotes}
\ No newline at end of file diff --git a/zeitung/parts/generated/quotes/.gitkeep b/zeitung/parts/generated/quotes/.gitkeep new file mode 100644 index 0000000..e69de29 --- /dev/null +++ b/zeitung/parts/generated/quotes/.gitkeep |