From db48d5f65579e7c69ce11d5258e7d9f647108f1f Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Thu, 1 Aug 2019 11:48:05 +0200
Subject: [locations] Sort subnets by address in subnet view

---
 modules-available/locations/pages/subnets.inc.php | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/modules-available/locations/pages/subnets.inc.php b/modules-available/locations/pages/subnets.inc.php
index 6c37129a..381023d2 100644
--- a/modules-available/locations/pages/subnets.inc.php
+++ b/modules-available/locations/pages/subnets.inc.php
@@ -51,7 +51,9 @@ class SubPage
 	{
 		if ($getAction === false) {
 			User::assertPermission('subnets.edit', NULL, '?do=locations');
-			$res = Database::simpleQuery("SELECT subnetid, startaddr, endaddr, locationid FROM subnet");
+			$res = Database::simpleQuery("SELECT subnetid, startaddr, endaddr, locationid
+					FROM subnet
+					ORDER BY startaddr ASC, endaddr DESC");
 			$rows = array();
 			while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
 				$row['startaddr'] = long2ip($row['startaddr']);
-- 
cgit v1.2.3-55-g7522