Changeset 11891

Timestamp:

2006-05-30T16:47:04+12:00 (18 years ago)

Author:

mdewsnip

Message:

Now shows the construction date of the places on the architect pages.

File:

• trunk/cic-hcap/perllib/plugins/CICPlug.pm (modified) (3 diffs)

trunk/cic-hcap/perllib/plugins/CICPlug.pm

@@ -638 +638 @@
     $place_images_sql_handle->{LongReadLen} = 65536;
 
+    # Prepare SQL statement for getting the Place "date of construction"
+    my $place_construction_date_sql_statement = "SELECT Date FROM tblConstruction_and_Dates WHERE Entry_ID=?";
+    my $place_construction_date_sql_handle = $dbh->prepare($place_construction_date_sql_statement);
+
     # Get a list of all the designers, and the places they worked on
     my %designer_name_to_place_ids_mapping;
@@ -671 +675 @@
     my $designer_places_image_html = "";
     foreach my $designer_place_id (@{$designer_name_to_place_ids_mapping{$designer_name}}) {
+        # Get place date of construction
+        $place_construction_date_sql_handle->execute($designer_place_id) or die "Could not execute SQL statement.";
+        my $designer_place_construction_date_value = $place_construction_date_sql_handle->fetchrow() || "";
+
         # Get the first image for this place
         $place_images_sql_handle->execute($designer_place_id) or die "Could not execute SQL statement.";
@@ -682 +690 @@
         $designer_place_image_small_file_name =~ s/ /%20/g;
         my $designer_place_image_small_file_link = "_httpcollection_/index/assoc/[assocfilepath]/$designer_place_image_small_file_name";
-        $designer_places_image_html .= "<tr><td valign=\"top\"><a href=\"_gwcgi_?a=d&d=p$designer_place_id\"><img src=\"$designer_place_image_small_file_link\"/></a></td><td valign=\"top\"><a href=\"_gwcgi_?a=d&d=p$designer_place_id\"><span class=\"cictext\">$designer_place_image_name</span></a></td></tr>\n";
+        $designer_places_image_html .= "<tr><td valign=\"top\"><a href=\"_gwcgi_?a=d&d=p$designer_place_id\"><img src=\"$designer_place_image_small_file_link\"/></a></td><td valign=\"top\"><a href=\"_gwcgi_?a=d&d=p$designer_place_id\"><span class=\"cictext\">$designer_place_image_name</span></a><br /><b>Date of construction:</b> $designer_place_construction_date_value</td></tr>\n";
         }
     }