product_list.ihtml

phpShop是一个基于php的分布式电子商务模块

<?php
  search_header($product_list_lbl, "product", "product_list");
  // Enable the multi-page search result display
  if (empty($offset))
 	$offset=0;

  // Check to see if this is a search or a browse by category
  // Default is to show all products
  if ($category_id) {
     $list  = "SELECT * FROM product, category, product_category_xref WHERE ";
     $count  = "SELECT count(*) as num_rows FROM product, 
		product_category_xref, category WHERE ";
     $q  = "product.vendor_id = '$ps_vendor_id' ";
     $q .= "AND product_category_xref.category_id='$category_id' "; 
     $q .= "AND category.category_id=product_category_xref.category_id ";
     $q .= "AND product.product_id=product_category_xref.product_id ";
     $q .= "AND product.product_parent_id='' ";
     $q .= "ORDER BY product_publish DESC,product_name ";
     $list .= $q . " LIMIT $offset, " . SEARCH_ROWS;
     $count .= $q;
  }
  elseif ($keyword) {
     $list  = "SELECT * FROM product, product_category_xref, category WHERE ";
     $count = "SELECT count(*) as num_rows FROM product, 
	       product_category_xref, category WHERE ";
     $q  = "product.vendor_id = '$ps_vendor_id' ";
     $q .= "AND (product.product_name LIKE '%$keyword%' OR ";
     $q .= "product.product_sku LIKE '%$keyword%' OR ";
     $q .= "product.product_s_desc LIKE '%$keyword%' OR ";
     $q .= "category.category_name LIKE '%$keyword%' OR ";
     $q .= "product.product_desc LIKE '%$keyword%'";
     $q .= ") ";
     $q .= "AND product.product_parent_id='' ";
     $q .= "AND product.product_id=product_category_xref.product_id ";
     $q .= "AND category.category_id=product_category_xref.category_id ";
     $q .= "ORDER BY product_publish DESC,product_name ";
     $list .= $q . " LIMIT $offset, " . SEARCH_ROWS;
     $count .= $q;   
  }
  else 
  {
     $list  = "SELECT * FROM product, product_category_xref, category WHERE ";
     $count = "SELECT count(*) as num_rows FROM product, 
              product_category_xref, category WHERE ";
     $q  = "product.vendor_id = '$ps_vendor_id' ";
     $q .= "AND product_parent_id='' ";
     $q .= "AND product.product_id=product_category_xref.product_id ";
     $q .= "AND category.category_id=product_category_xref.category_id ";
     $q .= "ORDER BY product_publish DESC,product_name ";
     $list .= $q . " LIMIT $offset, " . SEARCH_ROWS;
     $count .= $q;   
  }
  $db->query($count);
  $db->next_record();
  $num_rows = $db->f("num_rows");
  if ($num_rows == 0) {
     echo "Your search returned 0 results.<BR>";
  }
  else { ?>
    <table width="100%" border="0" cellspacing="0" cellpadding="5" class="RecordsTable">
    <tr>
     <td class="RecordsTableHeader"><?php echo $product_list_name?></td>
     <td class="RecordsTableHeader"><?php echo $product_list_sku?></td>
     <td align="center" class="RecordsTableHeader"><?php echo $product_list_category?></td>
     <td align="center" class="RecordsTableHeader"><?php echo $product_list_publish ?></td>
    </tr>
<?php
    $db->query($list);
    $i = 0;
    while ($db->next_record()) {
      if ($i++ % 2)
        $bgcolor=SEARCH_COLOR_1;
      else
        $bgcolor=SEARCH_COLOR_2;
?>
      <tr nowrap="nowrap" bgcolor="<?php echo $bgcolor; ?>">
       <td><?php
       $url = SECUREURL . "?page=$modulename/product_form&product_id=" . $db->f("product_id");
       echo "<A class=\"bLink\" HREF=\"" . $sess->url($url) . "\">";
       echo $db->f("product_name"); 
       echo "</A>"; ?></td>
       <td><?php echo $db->f("product_sku"); ?></td>
	   <?php
	   $q = "SELECT category.category_name FROM product,category,product_category_xref WHERE product.product_id='".$db->f('product_id')."' ";
	   $q .= "AND product_category_xref.product_id=product.product_id and category.category_id=product_category_xref.category_id";
	   $db2 = new ps_DB;
	   $db2->query($q);
	   $db2->next_record(); ?>
       <td align="center"><?php echo $db2->f("category_name"); ?></td>
	   
       <td align="center"><?php echo $db->f("product_publish"); ?></td>
      </tr>
<?php
    } 
  }
?>
</table>
<?php
  search_footer($modulename, "product_list", $offset, $num_rows, $keyword);
?>