function uc_catalog_orphaned_products in Ubercart 5

Same name and namespace in other branches

1. 6.2 uc_catalog/uc_catalog.admin.inc \uc_catalog_orphaned_products()
2. 7.3 uc_catalog/uc_catalog.admin.inc \uc_catalog_orphaned_products()

Display links to all products that have not been categorized.

1 string reference to 'uc_catalog_orphaned_products'

uc_catalog_menu in uc_catalog/uc_catalog.module

Implementation of hook_menu().

File

uc_catalog/uc_catalog.module, line 1203

Übercart Catalog module.

Code

function uc_catalog_orphaned_products() {
  $output = '<p>' . t('Orphaned products are products that you have created but
     not yet assigned to a category in your product catalog. All such
     products will appear as links below that you can follow to edit
     the product listings to assign them to categories.') . '</p>';
  $query = "SELECT DISTINCT n.nid, n.title FROM {node} AS n LEFT JOIN {term_node} AS tn ON n.nid = tn.nid LEFT JOIN {vocabulary_node_types} AS vnt ON n.type = vnt.type WHERE n.type != 'image' AND tn.tid IS NULL AND vnt.vid = %d";
  $vid = variable_get('uc_catalog_vid', 0);
  $result = db_query($query, $vid);
  $rows = array();
  while ($node = db_fetch_object($result)) {
    $rows[] = l($node->title, 'node/' . $node->nid . '/edit', array(), 'destination=admin/store/products/orphans');
  }
  if (count($rows) > 0) {
    $output .= theme('item_list', $rows);
  }
  else {
    $output .= '<p>' . t('All products are currently listed in the catalog.') . '</p>';
  }
  return $output;
}