summaryrefslogtreecommitdiff
path: root/web/template/tu_list.php
blob: 16dd690199495db0104ff2e79d127f4526771423 (plain)
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
<div class="pgbox">
		<div class="pgboxtitle" style="text-align:right;">
			<span class='f3'><?php print $type ?></span>
		</div>
			<table class='results'>
				<tr>
					<th class='header'><span class='f2'><?php print __("Proposal") ?></span></th>
					<th class='header'><span class='f2'>
						<a href='?off=<?php print $off ?>&amp;by=<?php print $by_next ?>'><?php print __("Start") ?></a>
					</span></th>
					<th class='header'><span class='f2'><?php print __("End") ?></span></th>
					<th class='header'><span class='f2'><?php print __("User") ?></span></th>
					<th class='header'><span class='f2'><?php print __("Yes") ?></span></th>
					<th class='header'><span class='f2'><?php print __("No") ?></span></th>
					<th class='header'><span class='f2'><?php print __('Voted') ?></span></th>
				</tr>
				<?php if (mysql_num_rows($result) == 0) { ?>
				<tr><td align='center' colspan='0'><?php print __("No results found.") ?></td></tr>
				<?php } else { for ($i = 0; $row = mysql_fetch_assoc($result); $i++) { (($i % 2) == 0) ? $c = "data1" : $c = "data2"; ?>
				<tr>
					<td class='<?php print $c ?>'><span class='f4'><span class='blue'>
						<?php
							$row["Agenda"] = htmlspecialchars(substr($row["Agenda"], 0, $prev_Len));
						?>
						<a href='tu.php?id=<?php print $row['ID'] ?>'><?php print $row["Agenda"] ?></a></span></span>
					</td>
					<td class='<?php print $c ?>'><span class='f5'><span class='blue'><?php print gmdate("Y-m-d", $row["Submitted"]) ?></span></span></td>
					<td class='<?php print $c ?>'><span class='f5'><span class='blue'><?php print gmdate("Y-m-d", $row["End"]) ?></span></span></td>
					<td class='<?php print $c ?>'><span class='f6'><span class='blue'>
					<?php
					if (!empty($row['User'])) {
						print "<a href='packages.php?K=" . $row['User'] . "&amp;SeB=m'>" . $row['User'] . "</a>";
					} else {
						print "N/A";
					}
					?>
					</span></span></td>
					<td class='<?php print $c ?>'><span class='f5'><span class='blue'><?php print $row['Yes'] ?></span></span></td>
					<td class='<?php print $c ?>'><span class='f5'><span class='blue'><?php print $row['No'] ?></span></span></td>
					<td class='<?php print $c ?>'>
						<?php
						$q = "SELECT * FROM TU_Votes WHERE VoteID = " . $row['ID'] . " AND UserID = " . uid_from_sid($_COOKIE["AURSID"]);
						$result_tulist = db_query($q, $dbh);
						if ($result_tulist) {
							$hasvoted = mysql_num_rows($result_tulist);
						}
						else {
							$hasvoted = 0;
						}
						?>
						<span class='f5'><span class='blue'>
						<?php if ($hasvoted == 0) { ?>
						<span style='color: red; font-weight: bold'><?php print __("No") ?></span>
						<?php } else { ?>
						<span style='color: green; font-weight: bold'><?php print __("Yes") ?></span>
						<?php } ?>
						</span></span>
					</td>
				</tr>
				<?php } } ?>
			</table>
</div>