I know that this is asked before, I even tryied to do as on this question: How to Sort Multi-dimensional Array by Value?
But in my case it doesn't work. If anybody can help me I will be very thankful.
My code:
$product_var_tpl = array(
'name' => $product['name'].(isset($product['attributes']) ? ' - '.$product['attributes'] : ''),
'unit_price' => Tools::displayPrice($product_price, $this->context->currency, false),
'price' => Tools::displayPrice($product_price * $product['quantity'], $this->context->currency, false),
'quantity' => $product['quantity'],
'reference' => $seller_name,
'customization' => array()
);
I want to sort this array by "reference" in alphabetical order.
I tried this:
usort($product_var_tpl, function($a, $b) {
return $a['reference'] - $b['reference'];
});
But the result is null or empty.
By default the output is:
Referance | Product name | Unite price | Qty | Price
testshop2 | pere | 42,00 | 0.5 | 21,00
testshoptwo | portocale | 21,00 | 1 | 21,00
irinatestshop | qiwi | 34,00 | 0.5 | 17,00
irinatestshop | Banane | 12,00 | 1 | 12,00
If I use "usort" I only get 4 empty rows
This si the full code:
// Construct order detail table for the email
$products_list = '';
$virtual_product = true;
$product_var_tpl_list = array();
foreach ($order->product_list as $product) {
$price = Product::getPriceStatic((int)$product['id_product'], false, ($product['id_product_attribute'] ? (int)$product['id_product_attribute'] : null), 6, null, false, true, $product['cart_quantity'], false, (int)$order->id_customer, (int)$order->id_cart, (int)$order->{Configuration::get('PS_TAX_ADDRESS_TYPE')});
$price_wt = Product::getPriceStatic((int)$product['id_product'], true, ($product['id_product_attribute'] ? (int)$product['id_product_attribute'] : null), 2, null, false, true, $product['cart_quantity'], false, (int)$order->id_customer, (int)$order->id_cart, (int)$order->{Configuration::get('PS_TAX_ADDRESS_TYPE')});
$product_price = Product::getTaxCalculationMethod() == PS_TAX_EXC ? Tools::ps_round($price, 2) : $price_wt;
//aici se pune date despre vinzaor
$idProduct = (int)$product['id_product'];
$SellerInfoOverride = Db::getInstance()->executeS('SELECT * FROM `'._DB_PREFIX_.'wk_mp_seller_product` WHERE `id_ps_product` = '.(int) $idProduct);
//print_r ($SellerInfoOverride);
foreach ($SellerInfoOverride as $key => $value) {
$sellerid = $value['id_seller'];
//$seller = $mpSeller->getSeller($value['id_seller'], $this->context->language->id);
$SellerInfoDetails = Db::getInstance()->executeS('SELECT * FROM `'._DB_PREFIX_.'wk_mp_seller` WHERE `id_seller` = '.(int) $sellerid);
foreach ($SellerInfoDetails as $key => $value) {
$seller_name = $value['shop_name_unique'];
}
}
$product_var_tpl = array(
'name' => $product['name'].(isset($product['attributes']) ? ' - '.$product['attributes'] : ''),
'unit_price' => Tools::displayPrice($product_price, $this->context->currency, false),
'price' => Tools::displayPrice($product_price * $product['quantity'], $this->context->currency, false),
'quantity' => $product['quantity'],
'reference' => $seller_name,
'customization' => array()
);
usort($product_var_tpl, function($a, $b) {
return $a['reference'] - $b['reference'];
});
$customized_datas = Product::getAllCustomizedDatas((int)$order->id_cart);
if (isset($customized_datas[$product['id_product']][$product['id_product_attribute']])) {
$product_var_tpl['customization'] = array();
foreach ($customized_datas[$product['id_product']][$product['id_product_attribute']][$order->id_address_delivery] as $customization) {
$customization_text = '';
if (isset($customization['datas'][Product::CUSTOMIZE_TEXTFIELD])) {
foreach ($customization['datas'][Product::CUSTOMIZE_TEXTFIELD] as $text) {
$customization_text .= $text['name'].': '.$text['value'].'<br />';
}
}
if (isset($customization['datas'][Product::CUSTOMIZE_FILE])) {
$customization_text .= sprintf(Tools::displayError('%d image(s)'), count($customization['datas'][Product::CUSTOMIZE_FILE])).'<br />';
}
$customization_quantity = (int)$product['customization_quantity'];
$product_var_tpl['customization'][] = array(
'customization_text' => $customization_text,
'customization_quantity' => $customization_quantity,
'quantity' => Tools::displayPrice($customization_quantity * $product_price, $this->context->currency, false)
);
}
}
$product_var_tpl_list[] = $product_var_tpl;
// Check if is not a virutal product for the displaying of shipping
if (!$product['is_virtual']) {
$virtual_product &= false;
}
} // end foreach ($products)