RackTables/racktables — pull request #2 by jamestutton (2012-09-13 14:21:56+00:00)
Title: At Location Info to RackRows

Please bare with me a little as first time using git and dont think this has gone 100% to plan. The sections I would like to merge are noted below. If basically add a link back to the location page on a rack row.

wwwroot/inc/interface.php Line 559
echo "
Location:	'location','location_id'=>$rowInfo['Location_id']))."\">${rowInfo['Location']}
\n";

www/root/database.php Line 257
"IF(ISNULL(SUM(Rack.height)),0,SUM(Rack.height)) AS sum, " .
"Location.id AS Location_id, Location.name AS Location " .
"FROM Row LEFT JOIN Rack ON Rack.row_id = Row.id " .
"LEFT OUTER JOIN Location ON Row.Location_id = Location.id " .
"WHERE Row.id = ? " .
"GROUP BY Row.id";