product_inventory.ihtml

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

<?php
  search_header($product_inventory_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, 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 product.product_id=product_category_xref.product_id ";
     $q .= "AND product_in_stock > 0 ";
     $q .= "ORDER BY product_name ";
     $list .= $q . " LIMIT $offset, " . SEARCH_ROWS;
     $count .= $q;
  }
  elseif ($keyword) {
     $list  = "SELECT * FROM product WHERE ";
     $count = "SELECT count(*) as num_rows FROM product 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_in_stock > 0 ";
     $q .= "ORDER BY product_name ";
     $list .= $q . " LIMIT $offset, " . SEARCH_ROWS;
     $count .= $q;   
  }
  else 
  {
     $list  = "SELECT * FROM product WHERE ";
     $count = "SELECT count(*) as num_rows FROM product WHERE ";
     $q  = "product.vendor_id = '$ps_vendor_id' ";
     if (!$allproducts) $q .= "AND product_in_stock > 0 ";
     $q .= "ORDER BY 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 width="50%" class="RecordsTableHeader"><?php echo $product_list_name?></td>
     <td width="15%" class="RecordsTableHeader"><?php echo $product_list_sku?></td>
     <td width="5%" class="RecordsTableHeader"><?php echo $product_inventory_price ?></td>
     <td width="5%" class="RecordsTableHeader"><?php echo $product_inventory_weight ?></td>
     <td width="5%" class="RecordsTableHeader"><?php echo $product_inventory_stock ?></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");
       if ($db->f("product_parent_id")) {
           $url .= "&product_parent_id=" . $db->f("product_parent_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>
       <td><?php $price=$ps_product->get_price($db->f("product_id"));
        if ($price) {
            if ($price["item"]) {
              echo $price["product_price"];
            } else {
              echo "none";
            } 
          } else {
            echo "none";
          } 
       ?></td>
       <td><?php echo $db->f("product_weight"); ?></td>
       <td><?php echo $db->f("product_in_stock"); ?></td>
      </tr>
<?php
    } 
  }
?>
</table>
<?php
  search_footer($modulename, "product_inventory", $offset, $num_rows, $keyword);
?>