Changeset 12185

Timestamp:

2006-07-13T09:36:41+12:00 (18 years ago)

Author:

mdewsnip

Message:

The institution best place images now link to the place's page.

File:

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

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

@@ -307 +307 @@
 
     # Prepare SQL statement for getting the Institution best place image location
-    my $institution_best_place_image_location_sql_statement = "SELECT Location FROM tblImages WHERE FileType=1 AND FileName=?";
+    my $institution_best_place_image_location_sql_statement = "SELECT Location,Entry_ID FROM tblImages WHERE FileType=1 AND FileName=?";
     my $institution_best_place_image_location_sql_handle = $dbh->prepare($institution_best_place_image_location_sql_statement);
     $institution_best_place_image_location_sql_handle->{LongReadLen} = 65536;
@@ -371 +371 @@
         # Get the file location of the best place image for this institution
         $institution_best_place_image_location_sql_handle->execute($institution_best_place_image_name) or die "Could not execute SQL statement.";
-        my $institution_best_place_image_location = $institution_best_place_image_location_sql_handle->fetchrow();
+        my $institution_best_place_image_hashref = $institution_best_place_image_location_sql_handle->fetchrow_hashref();
+
+        my $institution_best_place_image_location = $institution_best_place_image_hashref->{"Location"};
         if (!defined($institution_best_place_image_location) || $institution_best_place_image_location eq "") {
         print STDERR "<ProcessingError n='Institution $institution_id' p='CICPlug' r='Could not match best image $institution_best_place_image_name to a file'>\n" if ($self->{'gli'});
@@ -389 +391 @@
         }
 
+        my $institution_best_place_id = $institution_best_place_image_hashref->{"Entry_ID"};
         my $institution_best_place_image_medium_file_href = $self->generate_place_image_variant($institution_doc_obj, $institution_best_place_image_location, "medium");
-        my $institution_best_place_image_large_file_href = $self->generate_place_image_variant($institution_doc_obj, $institution_best_place_image_location, "large");
-        &new_metadata_entry($institution_doc_obj, "InstitutionBestPlaceImageHTML", "<a href=\"$institution_best_place_image_large_file_href\"><img src=\"$institution_best_place_image_medium_file_href\"/><br /><span class=\"cictext\">$institution_best_place_image_name</span></a>");
+        &new_metadata_entry($institution_doc_obj, "InstitutionBestPlaceImageHTML", "<a href=\"_gwcgi_?a=d&d=p$institution_best_place_id\"><img src=\"$institution_best_place_image_medium_file_href\"/><br /><span class=\"cictext\">$institution_best_place_image_name</span></a>");
     }