ordinare articoli per categoria in packing slip

[zaffiro74]

Salve, avrei una esigenza, di far comparire in order.php in admin e conseguentemente nella packing slip che si genera
gli articoli ordinati prima per categoria (products_id order by categories_name) pescando dati dalla tabella categories_description (categories_id, categories_name)

e poi quindi poi per ordine alfabetico (products_id order by products_name).

Questo per velocizzare la ricerca in magazzino degli articoli ordinati che sono suddivisi fisicamente per categoria.

so che devo lavorare sulla parte finale del file order.php

$index = 0;
$orders_products_query = tep_db_query("select products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "' and products_id=products_id order by products_name");


while ($orders_products = tep_db_fetch_array($orders_products_query)) {
$this->products[$index] = array('qty' => $orders_products['products_quantity'],
'name' => $orders_products['products_name'],
'model' => $orders_products['products_model'],
'tax' => $orders_products['products_tax'],
'price' => $orders_products['products_price'],
'final_price' => $orders_products['final_price']);

$subindex = 0;





$attributes_query = tep_db_query("select products_options, products_options_values, options_values_price, price_prefix from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int)$order_id . "' and orders_products_id = '" . (int)$orders_products['orders_products_id'] . "'");
if (tep_db_num_rows($attributes_query)) {
while ($attributes = tep_db_fetch_array($attributes_query)) {
$this->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options'],
'value' => $attributes['products_options_values'],
'prefix' => $attributes['price_prefix'],
'price' => $attributes['options_values_price']);

$subindex++;
}
}
$index++;
}
}
}
?>


ma non sono espertissimo. Mi potete aiutare?

[zaffiro74]

nessuno riesce ad aiutarmi?