"; }else{ echo "
Bulletins from $towns
"; echo "Download bulletin scans by clicking on their associated hyperlinks in the file column. Some bulletin scans span multiple years, and have large file sizes as a result."; $cmd = pg_query("SELECT DISTINCT publication FROM isc.reference WHERE townid = '$town_val' AND scan IS NOT NULL"); } //$pub = str_replace("'","''",$pub); // $cmdloc = pg_query("SELECT address,town,region,country,other,type,gmtoffset,amptype,ampunits // FROM isc.reference // WHERE townid = '$town_val'"); // // $resultloc = pg_fetch_array($cmdloc); // $address = $resultloc['address']; // $town = $resultloc['town']; // $region = $resultloc['region']; // $country = $resultloc['country']; // $other = $resultloc['other']; // $type = $resultloc['type']; // $gmtoffset = $resultloc['gmtoffset']; // $amptype = $resultloc['amptype']; // $ampunits = $resultloc['ampunits']; # Collect all those years that has been published $cmdYear = pg_query("select distinct year from isc.reference where townid = '$town_val' order by 1"); ?>
| Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | File | Size |
|---|
"; # Reference exists $no = "
![](\"images/noS.png\")
"; # Reference doesn't exist
while($resultMonth = pg_fetch_array($cmdMonth)){
$smonth = $resultMonth['startmonth'];
$emonth = $resultMonth['endmonth'];
$refid = $resultMonth['refid'];
$other = $resultMonth['other'];
$scan = $resultMonth['scan'];
$filename = $resultMonth['filename'];
if($resultMonth['filesize'] == NULL){
$filesize = filesize($filename);
$sqlup = "UPDATE isc.reference SET filesize = $filesize WHERE refid = $refid";
$x = pg_query($sqlup);
}else{
$filesize = number_format($resultMonth['filesize']/100000, 2) . "MB";
}
# one year with starting and ending month
if(empty($other) and isset($emonth)){
// echo "A ";
for ($j=1; $j<=12; $j++){
if ($j >= $smonth and $j <= $emonth){
$box[$year][$j] = "$yes";
}
}
# Just one month of data
}elseif(empty($other) and empty($emonth)){
// echo "B ";
for ($j=1; $j<=12; $j++){
if ($j == $smonth){
$box[$year][$j] = "$yes";
}
}
}
# When there is a time period of years
if(isset($other) and preg_match("/\+/", $other)){
$lastmonth = substr($other,1,2);
$lastyear = substr($other,4,8);
# Just one extra year
if ($lastyear == $year + 1){
// echo "C ";
# Months in between
for ($j=1; $j<=12; $j++){
if ($j >= $smonth ){
$box[$year][$j] = "$yes";
}
}
# months of the last year
for ($j=1; $j<=$lastmonth; $j++){
if ($j <= $lastmonth){
$box[$lastyear][$j] = "$yes";
}
}
# For more than 1 year
}else{
// echo "D ";
# all the months in between
for ($j=1; $j<=12; $j++){
if ($j >= $smonth ){
$box[$year][$j] = "$yes";
}
}
# All the years in between
for ($y = $year +1; $y <= $lastyear -1; $y++){
for ($j=1; $j<=12; $j++){
$box[$y][$j] = "$yes";
}
}
# months of the last year
for ($j=1; $j<=$lastmonth; $j++){
if ($j <= $lastmonth){
$box[$lastyear][$j] = "$yes";
}
}
}
# Other time periods smaller than years
}else{
# Just one year with starting and ending month
if(isset($emonth)){
// echo "E ";
for ($j=1; $j<=12; $j++){
if ($j >= $smonth and $j <= $emonth){
$box[$year][$j] = "$yes";
}
}
# Just one month of data
}elseif(empty($emonth)){
// echo "F ";
for ($j=1; $j<=12; $j++){
if ($j == $smonth){
$box[$year][$j] = "$yes";
}
}
} else { $box = null; }
}
}
# Return rows of information
$boxes = "";
foreach ((array)$box as $year => $value) { //this line will throw errors when box is uninitilized :( but still works as intended, initializing box breaks it.
$boxes .= "$rFile\n";
$filesizes .= "$rSize\n";
}
$boxes .= "$scan