Totally Zenned
- Join Date:
- Jun 2005
- Location:
- Kelowna, BC Canada
- Posts:
- 1,033
- Plugin Contributions:
- 4
Stock For Product With Different Attributes (OLD)
Couple of small mods you might be interesed in:
First... this 2-liner will pre-fill the quantity box when you are editing a stock level. This seems logical to me so that you have a visual reminder of what stock is currently entered.
in /admin/includes/products_with_attributes_stock.php, Find (Line 349 of a fresh copy)
echo '<p><strong>Quantity: </strong>'.zen_draw_input_field('quantity').'</p>'."\n";
And replace with```
echo '<p><strong>Quantity: </strong>'.zen_draw_input_field('quantity', $_GET['q']).'</p>'."\n"; //s_mack:prefill_quantity
And find (Line 458 of a fresh copy)
echo '<a href="'.zen_href_link(FILENAME_PRODUCTS_WITH_ATTRIBUTES_STOCK, "action=edit&products_id=".$products->fields['products_id'].'&attributes='.$attribute_products->fields['stock_attributes'], 'NONSSL').'">Edit Quantity</a>';
And replace with
echo '<a href="'.zen_href_link(FILENAME_PRODUCTS_WITH_ATTRIBUTES_STOCK, "action=edit&products_id=".$products->fields['products_id'].'&attributes='.$attribute_products->fields['stock_attributes'].'&q='.$attribute_products->fields['quantity'], 'NONSSL').'">Edit Quantity</a>'; //s_mack:prefill_quantity
The second mod is a little more involved. This skips the confirmation step for add and edit. It bugged me when I was trying to change the quantity on several items - its kinda useless anyway. The changes are to the same file as the above mod... its too sporatic to show the changes individually, so here is the file in its entirety - look for lines that end with "s_mack:noconfirm".
<p><input type="submit" value="submit"></p>
</form>
<p><input type="submit" value="submit"></p>
</form>
<p><input type="submit" value="Yes" name="confirm"> * <input type="submit" value="No" name="confirm"></p>
</form>
<p><input type="submit" value="submit"></p>
</form>
<table width="100%" style="text-align: left">
<tr>
// Show a list of the products
$query = 'select distinct
attrib.products_id, description.products_name, products.products_quantity
FROM
'.TABLE_PRODUCTS_ATTRIBUTES.' attrib, '.TABLE_PRODUCTS_DESCRIPTION.' description, '.TABLE_PRODUCTS.' products
WHERE
attrib.products_id = description.products_id and
attrib.products_id = products.products_id and description.language_id='.$language_id.' order by description.products_name ';
$products = $db->Execute($query);
while(!$products->EOF)
{
echo '<tr style="background: #ccc">'."\n";
echo '<td>'.$products->fields['products_id'].'</td>';
echo '<td>'.$products->fields['products_name'].'</td>';
echo '<td>'.$products->fields['products_quantity'].'</td>';
echo '<td><a href="'.zen_href_link(FILENAME_PRODUCTS_WITH_ATTRIBUTES_STOCK, "action=add&products_id=".$products->fields['products_id'], 'NONSSL').'">Add Quantity For Product Variant</a></td>';
echo '<td><a href="'.zen_href_link(FILENAME_PRODUCTS_WITH_ATTRIBUTES_STOCK, "action=resync&products_id=".$products->fields['products_id'], 'NONSSL').'">Sync Quantities</a></td>';
echo '</tr>'."\n";
$query = 'select * from '.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK.' where products_id="'.$products->fields['products_id'].'"';
$attribute_products = $db->Execute($query);
if($attribute_products->RecordCount() > 0)
{
echo '<tr>'."\n";
echo '<td colspan="5" style="padding:10px;">'."\n";
echo '<table width="100%" style="text-align: left">';
echo '<tr>';
echo '<th style="border-bottom: 1px solid #ccc">Stock id</th><th style="border-bottom: 1px solid #ccc">Variant</th><th style="border-bottom: 1px solid #ccc">Quantity in stock</th><th style="border-bottom: 1px solid #ccc">Edit</th><th style="border-bottom: 1px solid #ccc">Delete</th>';
echo '</tr>';
while(!$attribute_products->EOF)
{
echo '<tr>';
echo '<td style="border-bottom: 1px dashed #ccc">'."\n";
echo $attribute_products->fields['stock_id'];
echo '</td>'."\n";
echo '<td style="border-bottom: 1px dashed #ccc">'."\n";
$attributes_of_stock = explode(',',$attribute_products->fields['stock_attributes']);
$attributes_output = array();
foreach($attributes_of_stock as $attri_id)
{
$stock_attribute = $stock->get_attributes_name($attri_id);
$attributes_output[] = '<strong>'.$stock_attribute['option'].':</strong> '.$stock_attribute['value'].'<br/>';
}
sort($attributes_output);
echo implode("\n",$attributes_output);
echo '</td>'."\n";
echo '<td style="border-bottom: 1px dashed #ccc">'."\n";
echo $attribute_products->fields['quantity'];
echo '</td>'."\n";
echo '<td style="border-bottom: 1px dashed #ccc">'."\n";
echo '<a href="'.zen_href_link(FILENAME_PRODUCTS_WITH_ATTRIBUTES_STOCK, "action=edit&products_id=".$products->fields['products_id'].'&attributes='.$attribute_products->fields['stock_attributes'], 'NONSSL').'">Edit Quantity</a>';
echo '</td>'."\n";
echo '<td style="border-bottom: 1px dashed #ccc">'."\n";
echo '<a href="'.zen_href_link(FILENAME_PRODUCTS_WITH_ATTRIBUTES_STOCK, "action=delete&products_id=".$products->fields['products_id'].'&attributes='.$attribute_products->fields['stock_attributes'], 'NONSSL').'">Delete Variant</a>';
echo '</td>'."\n";
echo '</tr>';
$attribute_products->MoveNext();
}
echo '</table>';
echo '</td>'."\n";
echo '</tr>'."\n";
}
$products->MoveNext();
}
?>
</table>
- Steven
