OpenCart Community

sw!tch wrote: ↑

Sun May 20, 2018 10:01 am

If you look at the model for download.php.

https://github.com/opencart/opencart/bl ... hp#L21-L45

Code: Select all

$order_statuses = $this->config->get('config_complete_status');

^ Note this line.

In other words, its looking to only show downloads when a order status is "complete".

Check your payment module settings and see if the order status is set to the complete status you have set in the store settings. If it's not then they most likely won't show up.

Might be the issue or might not.

<?php
class ModelAccountDownload extends Model {
	public function getDownload($download_id) {
		$implode = array();

		$order_statuses = $this->config->get('config_complete_status');

		foreach ($order_statuses as $order_status_id) {
			$implode[] = "o.order_status_id = '" . (int)$order_status_id . "'";
		}

		if ($implode) {
			$query = $this->db->query("SELECT d.filename, d.mask FROM `" . DB_PREFIX . "order` o LEFT JOIN " . DB_PREFIX . "order_product op ON (o.order_id = op.order_id) LEFT JOIN " . DB_PREFIX . "product_to_download p2d ON (op.product_id = p2d.product_id) LEFT JOIN " . DB_PREFIX . "download d ON (p2d.download_id = d.download_id) WHERE o.customer_id = '" . (int)$this->customer->getId() . "' AND (" . implode(" OR ", $implode) . ") AND d.download_id = '" . (int)$download_id . "'");

			return $query->row;
		} else {
			return;
		}
	}

	public function getDownloads($start = 0, $limit = 20) {
		if ($start < 0) {
			$start = 0;
		}

		if ($limit < 1) {
			$limit = 20;
		}

		$implode = array();

		$order_statuses = $this->config->get('config_complete_status');

		foreach ($order_statuses as $order_status_id) {
			$implode[] = "o.order_status_id = '" . (int)$order_status_id . "'";
		}

		if ($implode) {
			$query = $this->db->query("SELECT DISTINCT d.download_id, o.order_id, o.date_added, dd.name, d.filename FROM `" . DB_PREFIX . "order` o LEFT JOIN " . DB_PREFIX . "order_product op ON (o.order_id = op.order_id) LEFT JOIN " . DB_PREFIX . "product_to_download p2d ON (op.product_id = p2d.product_id) LEFT JOIN " . DB_PREFIX . "download d ON (p2d.download_id = d.download_id) LEFT JOIN " . DB_PREFIX . "download_description dd ON (d.download_id = dd.download_id) WHERE o.customer_id = '" . (int)$this->customer->getId() . "' AND dd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND (" . implode(" OR ", $implode) . ") ORDER BY o.date_added DESC LIMIT " . (int)$start . "," . (int)$limit);

			return $query->rows;
		} else {
			return array();
		}
	}

	public function getTotalDownloads() {
		$implode = array();

		$order_statuses = $this->config->get('config_complete_status');

		foreach ($order_statuses as $order_status_id) {
			$implode[] = "o.order_status_id = '" . (int)$order_status_id . "'";
		}

		if ($implode) {
			$query = $this->db->query("SELECT COUNT(*) AS total FROM `" . DB_PREFIX . "order` o LEFT JOIN " . DB_PREFIX . "order_product op ON (o.order_id = op.order_id) LEFT JOIN " . DB_PREFIX . "product_to_download p2d ON (op.product_id = p2d.product_id) WHERE o.customer_id = '" . (int)$this->customer->getId() . "' AND (" . implode(" OR ", $implode) . ")");

			return $query->row['total'];
		} else {
			return 0;
		}
	}
}

cyclops12 wrote: ↑

Mon May 21, 2018 3:20 am

This is the settings i have in a test 3.0.2.0 version with a test download file...

And this works fine

Hope it helps

sw!tch wrote: ↑

Mon May 21, 2018 12:58 am

The only thing I can suggest is going to one of your free orders and add an order history of complete. Then login to the account and see if the download shows.

If you updated the payment module to a complete status, that won't actually do anything to existing orders. You would need to run through with another test order.

SusieRucy wrote: ↑

Tue May 22, 2018 11:11 pm

Any more help and suggestions anyone please

$this->model_checkout_order->addOrderHistory($this->session->data['order_id'], $this->config->get('payment_free_checkout_order_status_id'));

S.M.T.F wrote: ↑

Sat May 26, 2018 1:00 am

hello everyone
i have also this problem , i enable the free checkout module and it works on website but the download file don't go to download page of user.

i checked my module and understand when i setting the status of that to "Complete" and save it , it doesn't set on complete and again it back to "canceled "

many times i change the status to "Complete" and save it but when i check it again it going back to "canceled"

Can some help me about this ?

sw!tch wrote: ↑

Sat May 26, 2018 1:09 am

S.M.T.F wrote: ↑

Sat May 26, 2018 1:00 am

hello everyone
i have also this problem , i enable the free checkout module and it works on website but the download file don't go to download page of user.

i checked my module and understand when i setting the status of that to "Complete" and save it , it doesn't set on complete and again it back to "canceled "

many times i change the status to "Complete" and save it but when i check it again it going back to "canceled"

Can some help me about this ?

Did you read what I posted above?

Apparently there is already a fix for this, you may want to try below.

viewtopic.php?t=192113

sw!tch wrote: ↑

Sat May 26, 2018 2:09 am

Just follow the instructions on the first post - viewtopic.php?f=201&t=192113#p692020

Make sure you Uninstall the free checkout payment module first.

Clear the OC cache when done.

S.M.T.F wrote: ↑

Sat May 26, 2018 12:06 pm

Hello again
first i uninstall the free checkout and after that , i reload in the modification and also i did the clean the cache and also i open my admin page with "CTRL+F5"
after that i edit those 2 "free_checkout.php" and "free_checkout.twig" files.
and after that i install free checkout again but nothing changed
can you please tell what i do wrong in my steps ?
thanks

sw!tch wrote: ↑

Sat May 26, 2018 1:20 pm

S.M.T.F wrote: ↑

Sat May 26, 2018 12:06 pm

Hello again
first i uninstall the free checkout and after that , i reload in the modification and also i did the clean the cache and also i open my admin page with "CTRL+F5"
after that i edit those 2 "free_checkout.php" and "free_checkout.twig" files.
and after that i install free checkout again but nothing changed
can you please tell what i do wrong in my steps ?
thanks

Did you clear the cache in the dashboard? You have to click the COG icon. Are the order statutes saving in the backend under free checkout? If not you didn't do something correct.

I just tested the fix with a downloadable file and having a completed status. it works fine.

DigitCart wrote: ↑

Sat May 26, 2018 7:33 pm

Hi,
To clear Twig cache:
In Admin panel dashboard there's a blue button with a cog icon (bellow Logout link), click on this button and then click on refresh button.