Ordering download files

-- url of the page with the problem -- : mywebsite.com/mypage
-- HikaShop version -- : 2.3.2
-- Joomla version -- : 3.3
-- PHP version -- : 5.4

Hello,

For a downloadable product that has several files to be downloaded, is it possible to sort the download files so that they appear alphabetically? Right now they seem to be in almost random order and I can't find any way to order them (see attachment).

Thanks in advance!

Andre

Many thanks for your answer, but what you are saying is not really clear:

In the view "backend | your_backend_temple | product | file"

The easier will be to re-generate the file list before the display.

Ok thanks, I found the file, but your previous message is still not clear. Am I supposed to insert your code anywhere in the file ? Or should I replace all the existing code in the file with your code?

It's still not working.

When you write "at the beginning of the file" I assume you mean after the initial <?php , correct?

Still, when I add your code, it completely messes up the backend display so that Joomla becomes inoperable. And the notification email continues to display the download links in an apparently random order (see attached). How to order them alphabetically?

Andre

Hi,

Thanks to use that code:

<?php
$product_id = hikashop_getCID('product_id');
$database = JFactory::getDBO();
if(!empty($product_id)) {
	$query = 'SELECT * FROM '.hikashop_table('file').' WHERE file_ref_id = '.$product_id.' AND file_type=\'file\' ORDER BY file_name ASC, file_ordering ASC, file_id ASC';
	$database->setQuery($query);
	$this->element->files = $database->loadObjectList('file_id');
	if(!empty($this->element->files)){
		$query = 'SELECT SUM(download_number) AS download_number,file_id FROM '.hikashop_table('download').' WHERE file_id IN ( '.implode(',',array_keys($this->element->files)).' ) GROUP BY file_id';
		$database->setQuery($query);
		$downloads = $database->loadObjectList('file_id');
		if(!empty($downloads)){
			foreach($downloads as $download){
				$this->element->files[$download->file_id]->download_number = $download->download_number;
			}
		}
	}
}
?>

Thanks, but it still doesn't work. I have added the code at the beginning of the file as you indicated, but it makes no difference at all.

The download links are still disorganized and apparently in random order, either when looking at the product in the back end, or also in the customer notification email.

Still hoping for a solution.

Your code fixed the ordering problem in the backend display - thanks!

However, changing the line in order.php did not fix the order of the downloads in the notification email. They are still disordered.

OK, I was finally able to fix the problem in the notification email.

There was a second query on line 905 of order.php which I changed to

$query = 'SELECT b.*,a.* FROM '.hikashop_table('file').' AS a LEFT JOIN '.hikashop_table('download').' AS b ON b.order_id='.$order->order_id.' AND a.file_id = b.file_id WHERE '.implode(' AND ',$filters).' ORDER BY file_ref_id ASC, file_path ASC, file_ordering, file_pos ASC';

Thank you!

Hello Nicolas and Xavier,

To come back to an old post: I was wondering if it were possible to add the fixes above in a future update of Hikashop, so that the download files are always ordered in both the backend and in the confirmation email? It is rather tedious to have to go back and to change the core files every time Hikashop is updated.

Thanks!

Andre

I am disappointed that more than 2 years later, this problem is still ongoing: for a product with multiple download files, the notification email to the customer lists the files in random and totally disorganized order. Does this mean that every time I update Hikashop I will have to hack the core files just to get the downloads to display in order? When will this be fixed?

Thanks,

You are talking about the site backend - and good, I'm glad that's now possible. But I'm talking about the order email sent to the customer with the download links. These links were listed in totally disorganized manner until I hacked the order.php file to have them list alphabetically. So the problem still exists in the notification email.

In the HikaShop order class, the product files are loaded and added in the order object.
That is mostly done by the function "_setDownloadFile".