spam: the other white meat

Octopus Eats Shark - Google Video

Don’t wanna be a shark in the tank with this.

I wanted to use the default layout of the product module to display store items, but I also wanted it to support taxonomy terms, so that I could easily group my items.

I basically modified the theme_product_view_collection() function to grab term arguments and then added some complexity to the sql. I’m not totally sure that I got the sql right, but it’s functional for me.

This setup allows the calls for all products:

http://yoursite.com/product

and then by various terms:

http://yoursite.com/product/term/1

http://yoursite.com/product/term/1,2,3

Here’s the modified function:

<pre>
function theme_product_view_collection() {

// should these be variables?
$columns = 3;
$rows = 5;

// find out which terms are being passed in
$tids = array(arg(2));

foreach ($tids as $index => $tid) {
$term = taxonomy_get_term($tid);
$tree = taxonomy_get_tree($term->vid, $tid, -1, $depth);
$descendant_tids[] = array_merge(array($tid), array_map('_taxonomy_get_tid_from_term', $tree));
}
$str_tids = implode(',', call_user_func_array('array_merge', $descendant_tids));

$query = 'SELECT DISTINCT(n.nid) FROM {node} n ';
$query .= 'INNER JOIN {ec_product} p ON n.nid = p.nid ';

// if tids are coming in, do this sql
if ($str_tids) {
$query .= 'INNER JOIN {term_node} tn ON n.nid = tn.nid ';
$query .= 'WHERE tn.tid IN (' . $str_tids . ') AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC';
}
else {
$query .= 'WHERE n.status = 1 ORDER BY n.sticky DESC, n.created DESC';
}

//fetch the products
$result = pager_query(db_rewrite_sql($query), $rows * $columns, 0);

$output = '<table width="100%" cellpadding="10">';
for ($i = 0; $node = db_fetch_object($result); $i++) {

if ($i % $columns == 0) {
$output .= '<tr>';
}

$node = node_load(array('nid' => $node->nid));
$teaser = true;
$page = false;

$node->body = str_replace('', ", $node->body);
if (node_hook($node, 'view')) {
node_invoke($node, 'view', $teaser, $page);
}
else {
$node = node_prepare($node, $teaser);
}
node_invoke_nodeapi($node, 'view', $teaser, $page);

$output .= '<td valign="top"><p>'. l($node->title, "node/$node->nid") ."</p><div>$node->teaser</div></td>\n";

if ($i % $columns == $columns - 1) {
$output .= "</tr>\n";
}
}

if ($i % $columns != 0) {
$output .= "</tr>\n";
}
$output .= '</table>';

if ($pager = theme('pager', NULL, $rows * $columns, 0)) {
$output .= $pager;
}

return $output;
}

What this probably needs is:

1) sql clean up.
2) output of term titles
3) review of how i’m formating urls and letting me know if i’m doing this right

Download patch here

I wanted to be able to give users the ability to create a custom filter of various taxonomy data on the fly. I know that there are modules out there that sort of do this, however, nothing quite met my needs.

So this is two parts:

1) a function that returns lists of the terms under a vocabulary (you can feed it more than one vocabulary) with check boxes that a user can check off for what terms they want to display (in an “and” capacity)

2) a javascript function that checks the form that the above code produces and redirects the user to the page

<pre>
// this function returns a list navigation options
function get_navigation($vocab_ids) {

$html = "<form action=\"javascript:void(null);\" name=\"nav_filter\">\n";

// first we want to loop through each of the terms being passed in
foreach ($vocab_ids as $vocab_id) {

$term_title = taxonomy_get_vocabularies('flexinode-1', $vocab_id);
$html .= "<h1>" .$term_title[$vocab_id]->name . "</h1>\n";
$html .= "<ul id=\"nav_$vocab_id\" style=\"display: block;\">\n";

// now loop through each single term

foreach(taxonomy_get_tree($vocab_id, $parent = 0, $depth = -1, $max_depth = NULL) as $term) {

// make sure there are items in this
$the_count = taxonomy_term_count_nodes($term->tid);

if ($the_count > 0) {

$html .= "<li>tid . "\">" . $term->name . " \n";
$html .= "<input name=\"terms\" type=\"checkbox\" value=\"" . $term->tid . "\" />\n";

$html .= "</li> \n";
}
}
$html .= "</ul>\n";
$html .= "<br />\n";

} // end foreach

$html .= "<input type=\"submit\" value=\"List!\" onclick=\"javascript: build_filter(document.nav_filter.terms)\"></form>\n";

return $html;
}
</pre>

so if we do something like:

<pre>
$terms = array(1,2);
print get_navigation($terms);
</pre>

we’ll produce a nice list of terms with checkboxes next to them.

Now we just need this javascript to tie it together.

<pre>
// this is used to build a filter
function build_filter(field){

var terms;
var base;
base = '/taxonomy/term/';

for (i = 0; i < field.length; i++)
if (field[i].checked == true) {
//alert(field[i].value);
if (terms == undefined) {terms = field[i].value;}
else {terms += "+";
terms += field[i].value;
}
}
//alert(terms);
if (terms != undefined) {
window.location=base+terms;
} else { alert ('Please select some options!'); }
}
</pre>

When the form is submitted, the javascript is called, it walks through the form, picking up the ids of each of the terms, and then it build a url. If there are no terms selected, it alerts the user.

I’m doing some display of nodes and I want to sort them as I display them, doing something like this:

$somenodes = taxonomy_select_nodes($terms, ‘or’, 2, FALSE, ‘n.title’);

This lets me sort by title which is handy in listings sometimes. For example, in the hacked up menu system that I’ve been using everywhere, this lets me display nodes by title.

In order to do this, 2 lines in taxonomy module need to be modified:

Line 824 From:

function taxonomy_select_nodes($tids = array(), $operator = ‘or’, $depth = 0, $pager = TRUE) {

To:

function taxonomy_select_nodes($tids = array(), $operator = ‘or’, $depth = 0, $pager = TRUE, $order = ‘n.sticky DESC, n.created DESC’) {

(this leaves the default sort order intact)

Secondly Line 839 From

$sql = ‘SELECT DISTINCT(n.nid), n.sticky, n.title, n.created FROM {node} n INNER JOIN {term_node} tn ON n.nid = tn.nid WHERE tn.tid IN (’. $str_tids .’) AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC’);

To

$sql = ‘SELECT DISTINCT(n.nid), n.sticky, n.title, n.created FROM {node} n INNER JOIN {term_node} tn ON n.nid = tn.nid WHERE tn.tid IN (’. $str_tids .’) AND n.status = 1 ORDER BY ‘ . $order;

Download modified taxonomy.module here