From 1d5acf5ba24af54ebce139cddd4aa720847357f5 Mon Sep 17 00:00:00 2001
From: Michael Andreen <harv@ruin.nu>
Date: Sun, 27 Jun 2021 11:23:50 +0200
Subject: [PATCH] Add alliance members pscans

---
 lib/NDWeb/Controller/Alliances.pm | 17 +++++++++++++++++
 root/src/alliances/edit.tt2       |  2 +-
 root/src/alliances/pscans.tt2     | 20 ++++++++++++++++++++
 3 files changed, 38 insertions(+), 1 deletion(-)
 create mode 100644 root/src/alliances/pscans.tt2

diff --git a/lib/NDWeb/Controller/Alliances.pm b/lib/NDWeb/Controller/Alliances.pm
index 8f0b6c6..70c6340 100644
--- a/lib/NDWeb/Controller/Alliances.pm
+++ b/lib/NDWeb/Controller/Alliances.pm
@@ -107,6 +107,23 @@ ORDER BY tick DESC, mission
 	$c->stash(intel => $query->fetchall_arrayref({}) );
 }
 
+
+sub pscans : Local {
+	my ( $self, $c, $id ) = @_;
+	my $dbh = $c->model;
+
+	my $members = $dbh->prepare(q{
+		SELECT pid AS id, coords(x,y,z), metal, crystal, eonium, ps.tick
+			,planet_status,hit_us, sizerank, scorerank, valuerank, xprank
+		FROM current_planet_stats p left outer join current_planet_scans ps using (pid)
+		WHERE p.aid = ?
+		ORDER BY x,y,z
+		});
+	$members->execute($id);
+	$c->stash(members => $members->fetchall_arrayref({}) );
+
+}
+
 sub postallianceupdate : Local {
 	my ( $self, $c, $id, $order ) = @_;
 	my $dbh = $c->model;
diff --git a/root/src/alliances/edit.tt2 b/root/src/alliances/edit.tt2
index 609ee4c..cf34eaf 100644
--- a/root/src/alliances/edit.tt2
+++ b/root/src/alliances/edit.tt2
@@ -25,7 +25,7 @@
 </fieldset>
 </div>
 </fieldset>
-<p>Export information <a href="[% c.uri_for('/textexport/alliance',a.id) %]">as text</a>.</p>
+<p><a href="[% c.uri_for('pscans',a.id) %]">Planet scans</a>.</p><p>Export information <a href="[% c.uri_for('/textexport/alliance',a.id) %]">as text</a>.</p>
 <div class="leftinfo">
 <img class="graph" src="[% c.uri_for('/graphs/alliancevsintel',a.id,STICK) %]" alt="Alliance size and score vs members" height="300" width="500">
 <img class="graph" src="[% c.uri_for('/graphs/avgalliancevsintel',a.id,STICK) %]" alt="Avg alliance size and score vs members" height="300" width="500">
diff --git a/root/src/alliances/pscans.tt2 b/root/src/alliances/pscans.tt2
new file mode 100644
index 0000000..8286560
--- /dev/null
+++ b/root/src/alliances/pscans.tt2
@@ -0,0 +1,20 @@
+[% META title = 'Alliance P-Scans' %]
+
+<table class="stats">
+	<tr>
+		<th>Coords</th>
+		<th>Metal</th>
+		<th>Crystal</th>
+		<th>Eonium</th>
+		<th>Tick</th>
+	</tr>
+[% FOR m IN members %]
+	<tr class="[% loop.count % 2 == 0 ? 'even' : 'odd' %]">
+		<td><a href="[% c.uri_for('/stats/planet',m.id) %]">[% m.coords %]</a></td>
+		<td>[% m.metal %]</td>
+		<td>[% m.crystal %]</td>
+		<td>[% m.eonium %]</td>
+		<td>[% m.tick %]</td>
+	</tr>
+[% END %]
+</table>
-- 
2.39.2