-
Notifications
You must be signed in to change notification settings - Fork 0
/
sets.php
124 lines (102 loc) · 5.75 KB
/
sets.php
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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
<?php
require("_header.php");
if(!isset($_GET['set']))
{
if(!isset($_GET['country']))
{
NavBar("Home","Sets");
echo '<h2>Sets</h2>';
echo '<center>';
$buttonArray = MySQL::Cluster("SELECT * FROM bottlecaps INNER JOIN breweries ON bottlecaps.breweryID = breweries.id INNER JOIN countries ON breweries.countryID = countries.id WHERE isSet = '1' GROUP BY countries.countryShort");
foreach($buttonArray AS $button) echo CountryButton($button['countryShort'],false,true,true);
echo '</center>';
}
else
{
NavBar("Home","Sets","CountrySets:".$_GET['country']);
$country = $_GET['country'];
$countryData = MySQL::Row("SELECT * FROM countries WHERE countryShort = ?",'s',$country);
echo '<h2>Sets aus '.$countryData['countryDE'].'</h2>';
$permissionCheck = CheckEditPermission();
$setDataArray = MySQL::Cluster("SELECT * FROM sets INNER JOIN bottlecaps ON sets.id = bottlecaps.setID INNER JOIN breweries ON bottlecaps.breweryID = breweries.id INNER JOIN countries ON breweries.countryID = countries.id WHERE countries.countryShort = ? GROUP BY bottlecaps.setID ORDER BY breweries.breweryName ASC, sets.setName ASC",'s',$country);
echo '<center>';
foreach($setDataArray AS $setTile) echo SetTile($setTile['setID'],$permissionCheck);
echo '</center>';
}
}
else
{
NavBar("Home","Sets","CountrySets:".$_GET['country'],"Set:".$_GET['set']);
$pager = new Pager(20);
$pagerOffset = $pager->GetOffset();
$pagerSize = $pager->GetPagerSize();
$setFilepath = $_GET['set'];
$setData = MySQL::Row("SELECT * FROM sets INNER JOIN bottlecaps ON sets.id = bottlecaps.setID INNER JOIN breweries ON bottlecaps.breweryID = breweries.id INNER JOIN countries ON breweries.countryID = countries.id WHERE sets.setFilepath = ?",'s',$setFilepath);
if(MySQL::Exist("SELECT regions.id FROM regions INNER JOIN countries ON regions.countryID = countries.id WHERE countries.countryShort = ?",'s',$setData['countryShort'])) $countryHasRegions = true;
else $countryHasRegions = false;
$sqlStatement = "SELECT *,
bottlecaps.id AS bottlecapID,
capColor.colorShort AS bottlecapCapColorShort,
capColor.colorDE AS bottlecapCapColorName,
baseColor.hex AS bottlecapBaseColorValue,
baseColor.colorDE AS bottlecapBaseColorName,
textColor.hex AS bottlecapTextColorValue,
textColor.colorDE AS bottlecapTextColorName
FROM bottlecaps
INNER JOIN breweries ON bottlecaps.breweryID = breweries.id
INNER JOIN countries ON breweries.countryID = countries.id
".($countryHasRegions ? "INNER JOIN regions ON breweries.regionID = regions.id" : "")."
INNER JOIN flavors ON bottlecaps.flavorID = flavors.id
INNER JOIN sidesigns ON bottlecaps.sidesignID = sidesigns.id
INNER JOIN sets ON bottlecaps.setID = sets.id
INNER JOIN colors AS capColor ON bottlecaps.capColorID = capColor.id
INNER JOIN colors AS baseColor ON bottlecaps.baseColorID = baseColor.id
INNER JOIN colors AS textColor ON bottlecaps.textColorID = textColor.id
WHERE countries.countryShort = ?
AND sets.setFilepath = ?
ORDER BY breweries.breweryName, bottlecaps.capNumber ASC
LIMIT $pagerOffset,$pagerSize";
$capDataArray = MySQL::Cluster($sqlStatement,'@s',$setData['countryShort'],$setFilepath);
$sqlPager = $pager->SQLAuto(str_replace(" LIMIT $pagerOffset,$pagerSize","",$sqlStatement),'@s',$setData['countryShort'],$setFilepath);
echo '<h2>'.$setData['setName'].'</h2>';
$capThumbnailArray = MySQL::Cluster("SELECT * FROM bottlecaps WHERE setID = ?",'i',$setData['setID']);
echo '<center><div class="setCapThumbnailContainer">';
for($i=0;$i<count($capThumbnailArray);$i++)
{
if($i < $pager->GetPagerSize() * 10) $page = 10;
if($i < $pager->GetPagerSize() * 9) $page = 9;
if($i < $pager->GetPagerSize() * 8) $page = 8;
if($i < $pager->GetPagerSize() * 7) $page = 7;
if($i < $pager->GetPagerSize() * 6) $page = 6;
if($i < $pager->GetPagerSize() * 5) $page = 5;
if($i < $pager->GetPagerSize() * 4) $page = 4;
if($i < $pager->GetPagerSize() * 3) $page = 3;
if($i < $pager->GetPagerSize() * 2) $page = 2;
if($i < $pager->GetPagerSize() * 1) $page = 1;
$imagePath = '/files/sets/'.$setData['countryShort'].'/'.$setData['setFilepath'].'/'.$capThumbnailArray[$i]['capImage'];
$altMessage = '';
if(!file_exists(ltrim($imagePath,'/')))
{
$altMessage = $imagePath;
$imagePath = '/content/not_found.png';
}
echo '<a href="?page='.$page.'#cap'.$capThumbnailArray[$i]['id'].'"><img src="'.$imagePath.'" alt="'.$altMessage.'"/></a>';
}
echo '</div>';
echo '
<br>
'.$sqlPager.'
<div class="bottlecapRowContainer">
<table class="capDisplay">
<tr>
<td colspan=5>Set "'.$setData['setName'].'" von '.$setData['breweryName'].'</td>
</tr>
';
$permissionCheck = CheckEditPermission();
foreach($capDataArray AS $capData) echo BottleCapRowData($capData, true, $countryHasRegions, $permissionCheck);
echo '</table><div class="infoOverlays">';
foreach($capDataArray AS $capData) echo BottleCapRowInfoOverlay($capData);
echo '</div></div><br>'.$sqlPager.'</center>';
}
include("_footer.php");
?>