Home » Forums » Ubercart » Support

Extracting List of Options for Product Page to build a color swatch grid

Submitted by dstrickland on Mon, 02/11/2008 - 14:17
dstrickland

Posts: 28
 Joined: 01/14/2008

I have what is turning into a little bit of a maintenance nightmare.

I am thinking about adding a bit of php code to the product description that would produce a color swatch based on options for that product (copper vien, satin blck, etc). So that the same code could be in each product description.

I am a bit of drupal newbie. I look at the variables avaible through the Content Template, but it didn't reference how to make this happen.

I am looking for something like this

foreach (option in $content->options)
{
print 'id + '-color.jpg" /> '+ option->title + ;
}

I am looking to replicate what is found http://ironpickets.com/ucart/node/11
in an automated and predictable way, not just being very careful and keeping it up to date.

Thanks,
David Strickland

--

David Strickland
Delante Solutions
permalink #1 Tue, 02/12/2008 - 16:38
dstrickland

Posts: 28
 Joined: 01/14/2008

I found my own answer and it is a bit a twist on the some examples on the drupal site. If there is a more "Drupal" way to do this, I would welcome the comments. Here is what I settled on and plan on buying the pro drupal book so that i can refrain from asking such basic questions.
First, I installed the content templates. I modified the product / body template as follows. It now (http://ironpickets.com/ucart/node/31) displays color thumbnails and large images (thickbox) for each one.

<?php print $node->content['#children'] ?>

<?php $sql = 'SELECT aopt.name, aopt.oid FROM `uc_products` AS prd '.
       ' LEFT JOIN `uc_product_options` AS opt ON opt.nid = prd.nid' .
       ' LEFT JOIN `uc_attribute_options` AS aopt ON aopt.oid = opt.oid' .
       ' LEFT JOIN `node` AS n ON prd.nid = n.nid ' .
       ' WHERE prd.nid = ' .  $node->nid ;

  $r = db_query($sql);
?>

<fieldset style="text-align:left;">
<legend><b>Available Finishes</b></legend>

<?php

  // Loop over options to build fieldset.
  while ($row = db_fetch_array($r)) {

     $base_image_name = '"/ucart/images/colors/' . strtolower(str_replace(' ', '-', $row['name'], $cnt));

     print '<a href=' . $base_image_name . '-large.jpg" title="Large ' . $row['name'] . ' Sample" class="thickbox">' ;
     print '<img src='. $base_image_name . '.jpg" /></a>';
     print  $row['name'] . '<br />';
  } ?>
</fieldset>

Hope this helps you in your adventure,
David

--

David Strickland
Delante Solutions

permalink #2 Sat, 02/16/2008 - 02:10
giggler
Posts: 48
 Joined: 01/31/2008

That's cool, thanks for sharing. Maybe with some script it can be done as onmouseovers...