Regarding the admin product page - how do I add Category to the columns that are shown? Thanks.
No - that is not what I asked. I would like Category to be one of the columns shown on the PRODUCT page so when I look at my list of products, I see the category I assigned it to.
OK Sorry.
Here is a quick and dirty way of doing what I think you want.
Script: admin/view/template/catelog/product_list.tpl
Phil.
Here is a quick and dirty way of doing what I think you want.
Script: admin/view/template/catelog/product_list.tpl
Code: Select all
<?php if ($error_warning) { ?>
<div class="warning"><?php echo $error_warning; ?></div>
<?php } ?>
<?php if ($success) { ?>
<div class="success"><?php echo $success; ?></div>
<?php } ?>
<div class="heading">
<h1><?php echo $heading_title; ?></h1>
<div class="buttons"><a onclick="location='<?php echo $insert; ?>'" class="button"><span class="button_left button_insert"></span><span class="button_middle"><?php echo $button_insert; ?></span><span class="button_right"></span></a><a onclick="$('form').submit();" class="button"><span class="button_left button_delete"></span><span class="button_middle"><?php echo $button_delete; ?></span><span class="button_right"></span></a></div>
</div>
<form action="<?php echo $delete; ?>" method="post" enctype="multipart/form-data" id="form">
<table class="list">
<thead>
<tr>
<td width="1" style="align: center;"><input type="checkbox" onclick="$('input[name*=\'delete\']').attr('checked', this.checked);" /></td>
<td class="left"><?php if ($sort == 'pd.name') { ?>
<a href="<?php echo $sort_name; ?>" class="<?php echo strtolower($order); ?>"><?php echo $column_name; ?></a>
<?php } else { ?>
<a href="<?php echo $sort_name; ?>"><?php echo $column_name; ?></a>
<?php } ?></td>
<!-- Added Display Category -->
<td class="left"><?php echo 'Category';?></td>
<!-- End Display Category -->
<td class="left"><?php if ($sort == 'p.model') { ?>
<a href="<?php echo $sort_model; ?>" class="<?php echo strtolower($order); ?>"><?php echo $column_model; ?></a>
<?php } else { ?>
<a href="<?php echo $sort_model; ?>"><?php echo $column_model; ?></a>
<?php } ?></td>
<td class="left"><?php if ($sort == 'p.status') { ?>
<a href="<?php echo $sort_status; ?>" class="<?php echo strtolower($order); ?>"><?php echo $column_status; ?></a>
<?php } else { ?>
<a href="<?php echo $sort_status; ?>"><?php echo $column_status; ?></a>
<?php } ?></td>
<td class="right"><?php echo $column_action; ?></td>
</tr>
</thead>
<tbody>
<tr class="filter">
<td></td>
<td><input type="text" name="filter_name" value="<?php echo $filter_name; ?>" /></td>
<!-- Added Display Category -->
<td class="left"> </td>
<!-- End Display Category -->
<td><input type="text" name="filter_model" value="<?php echo $filter_model; ?>" /></td>
<td><select name="filter_status">
<option value="*"></option>
<?php if ($filter_status) { ?>
<option value="1" selected="selected"><?php echo $text_enabled; ?></option>
<?php } else { ?>
<option value="1"><?php echo $text_enabled; ?></option>
<?php } ?>
<?php if (!is_null($filter_status) && !$filter_status) { ?>
<option value="0" selected="selected"><?php echo $text_disabled; ?></option>
<?php } else { ?>
<option value="0"><?php echo $text_disabled; ?></option>
<?php } ?>
</select></td>
<td align="right"><input type="button" value="<?php echo $button_filter; ?>" onclick="filter();" /></td>
</tr>
<?php if ($products) { ?>
<?php $class = 'odd'; ?>
<?php foreach ($products as $product) { ?>
<?php $class = ($class == 'even' ? 'odd' : 'even'); ?>
<tr class="<?php echo $class; ?>">
<td style="align: center;"><?php if ($product['delete']) { ?>
<input type="checkbox" name="delete[]" value="<?php echo $product['product_id']; ?>" checked="checked" />
<?php } else { ?>
<input type="checkbox" name="delete[]" value="<?php echo $product['product_id']; ?>" />
<?php } ?></td>
<td class="left"><?php echo $product['name']; ?></td>
<!-- Added Display Category -->
<?php
$result = mysql_query("SELECT `category_id` FROM `product_to_category` WHERE `product_id` = '" . $product['product_id'] . "'");
$row = mysql_fetch_assoc($result);
$result = mysql_query("SELECT `name` FROM `category_description` WHERE `category_id` = '" . $row['category_id'] . "'");
$row = mysql_fetch_assoc($result);
?>
<td class="left"><?php echo $row['name'];?></td>
<!-- End Display Category -->
<td class="left"><?php echo $product['model']; ?></td>
<td class="left"><?php echo $product['status']; ?></td>
<td class="right"><?php foreach ($product['action'] as $action) { ?>
[ <a href="<?php echo $action['href']; ?>"><?php echo $action['text']; ?></a> ]
<?php } ?></td>
</tr>
<?php } ?>
<?php } else { ?>
<tr class="even">
<td class="center" colspan="5"><?php echo $text_no_results; ?></td>
</tr>
<?php } ?>
</tbody>
</table>
</form>
<div class="pagination"><?php echo $pagination; ?></div>
<script type="text/javascript"><!--
function filter() {
url = 'index.php?route=catalog/product';
var filter_name = $('input[name=\'filter_name\']').attr('value');
if (filter_name) {
url += '&filter_name=' + encodeURIComponent(filter_name);
}
var filter_model = $('input[name=\'filter_model\']').attr('value');
if (filter_model) {
url += '&filter_model=' + encodeURIComponent(filter_model);
}
var filter_status = $('select[name=\'filter_status\']').attr('value');
if (filter_status != '*') {
url += '&filter_status=' + encodeURIComponent(filter_status);
}
location = url;
}
//--></script>
And I'm sorry I didn't tell you I am using version 0.? . What is the location of the file I need to change ?
Thanks much !
Thanks much !
Who is online
Users browsing this forum: No registered users and 4 guests