Changeset 11908

Timestamp:

2006-06-02T12:17:06+12:00 (18 years ago)

Author:

mdewsnip

Message:

Now handles the no_image.jpg file for the designer pages.

File:

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

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

@@ -647 +647 @@
     my $place_construction_date_sql_handle = $dbh->prepare($place_construction_date_sql_statement);
 
+    # Prepare SQL statement for getting the Place name
+    my $place_name_sql_statement = "SELECT Current_name FROM tblPlace WHERE Entry_ID=?";
+    my $place_name_sql_handle = $dbh->prepare($place_name_sql_statement);
+
     # Get a list of all the designers, and the places they worked on
     my %designer_name_to_place_ids_mapping;
@@ -692 +696 @@
 
         my $designer_place_image_name = $designer_place_image_match_hashref->{"FileName"};
-        my $designer_place_image_small_file_name = $designer_place_image_name . "-small.jpg";
-        $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";
+        my $designer_place_image_small_file_link;
+        if (defined($designer_place_image_name)) {
+            my $designer_place_image_small_file_name = $designer_place_image_name . "-small.jpg";
+            $designer_place_image_small_file_name =~ s/ /%20/g;
+            $designer_place_image_small_file_link = "_httpcollection_/index/assoc/[assocfilepath]/$designer_place_image_small_file_name";
+        }
+        else {
+            # Get the name of this place (since we don't have a filename)
+            $place_name_sql_handle->execute($designer_place_id) or die "Could not execute SQL statement.";
+            $designer_place_image_name = $place_name_sql_handle->fetchrow() || "";
+            $designer_place_image_small_file_link = "_httpcollection_/images/no_image.jpg";
+        }
         $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";
         }