Tanks
query("sites", "SELECT * FROM sites WHERE 1 ORDER BY `name` ASC");
while ($site = $sites_res->fetch_assoc()) {
?>
query("tanks", "SELECT * FROM tanks WHERE site_id = " . $site['record_id'] . " ORDER BY `name` ASC");
while ($tank = $tanks_res->fetch_assoc()) {
renderTankBlock($tank['record_id'], true, true);
}
?>
query("clients", "SELECT * FROM clients WHERE 1 ORDER BY `name` ASC");
while ($clients = $clients_res->fetch_assoc()) {
?>
query("tanks", "SELECT * FROM tanks WHERE client_id = " . $clients['record_id'] . "");
if ($tanks_res->num_rows > 0) {
while ($tank = $tanks_res->fetch_assoc()) {
renderTankBlock($tank['record_id'], true, true);
}
} else {
echo "--NO TANKS LOADED--";
}
?>
query("clients", "SELECT * FROM clients WHERE record_id = {$_SESSION['client_id']} ORDER BY `name` ASC");
while ($clients = $clients_res->fetch_assoc()) {
?>
query("tanks", "SELECT * FROM tanks WHERE client_id = {$_SESSION['client_id']}");
if ($tanks_res->num_rows > 0) {
while ($tank = $tanks_res->fetch_assoc()) {
renderTankBlock($tank['record_id'], true, true);
}
} else {
echo "--NO TANKS LOADED--";
}
?>
query("sites", "SELECT s.name as name, s.record_id as id FROM sites as s LEFT JOIN tanks as t ON s.record_id = t.site_id WHERE t.record_id IN ({$_SESSION['tanks']}) ");
$prev_name = "";
while ($site = $sites_res->fetch_assoc()) {
if ($site['name'] != $prev_name) {
$prev_name = $site['name'];
?>
query("tanks", "SELECT * FROM tanks WHERE site_id = " . $site['id'] . " ORDER BY `name` ASC");
while ($tank = $tanks_res->fetch_assoc()) {
renderTankBlock($tank['record_id'], true, true);
}
?>
query("clients", "SELECT c.name as name, c.record_id as id FROM clients as c LEFT JOIN tanks as t ON c.record_id = t.client_id WHERE t.client_id IN ($client_search) ");
$prev_name = "";
while ($clients = $clients_res->fetch_assoc()) {
if ($clients['name'] != $prev_name) {
$prev_name = $clients['name'];
?>
query("tanks", "SELECT * FROM tanks WHERE client_id = " . $clients['id'] . " ORDER BY `name` ASC");
while ($tank = $tanks_res->fetch_assoc()) {
renderTankBlock($tank['record_id'], true, true);
}
?>