[MOD] - How to display downloads when using Free Checkout
Posted: Sun Jul 10, 2011 12:37 am
I wanted to display downloads when they were bought with the Free Checkout payment option and that option was set to Complete.
I modified catalog\model\account\download.php
May be there is a better way... I didn't find.
I modified catalog\model\account\download.php
Code: Select all
public function getDownload($order_download_id) {
$q="SELECT * FROM " . DB_PREFIX . "order_download od LEFT JOIN `" .
DB_PREFIX . "order` o ON (od.order_id = o.order_id) WHERE o.customer_id = '" .
(int)$this->customer->getId().
"' AND o.order_status_id > '0' AND (o.order_status_id = '" .
(int)$this->config->get('config_download_status') .
"' OR o.payment_method = 'Free Checkout') AND od.order_download_id = '" .
(int)$order_download_id . "' AND od.remaining > 0";
$query = $this->db->query($q);
return $query->row;
}Code: Select all
public function getDownloads($start = 0, $limit = 20) {
if ($start < 0) {
$start = 0;
}
$q="SELECT o.order_id, o.date_added, od.order_download_id, od.name, od.filename, od.remaining FROM " .
DB_PREFIX . "order_download od LEFT JOIN `" .
DB_PREFIX . "order` o ON (od.order_id = o.order_id) WHERE o.customer_id = '" .
(int)$this->customer->getId() .
"' AND o.order_status_id > '0' ".
" AND (o.order_status_id = '" .
(int)$this->config->get('config_download_status') .
"' OR o.payment_method = 'Free Checkout') ".
"ORDER BY o.date_added DESC LIMIT " .
(int)$start . "," . (int)$limit;
$query = $this->db->query($q);
//$query = $this->db->query("SELECT o.order_id, o.date_added, od.order_download_id, od.name, od.filename, od.remaining FROM " . DB_PREFIX . "order_download od LEFT JOIN `" . DB_PREFIX . "order` o ON (od.order_id = o.order_id) WHERE o.customer_id = '" . (int)$this->customer->getId() . "' AND o.order_status_id > '0' AND o.order_status_id = '" . (int)$this->config->get('config_download_status') . "' ORDER BY o.date_added DESC LIMIT " . (int)$start . "," . (int)$limit);
return $query->rows;
}