Can anyone please help?
Code: Select all
<?php
class ModelAccountGiftvoucher extends Model {
public function getGifttotal() {
$db = "SELECT v.voucher_id, (v.amount + SUM(vh.amount)) as total FROM " . DB_PREFIX . "voucher_history vh JOIN " . DB_PREFIX . "voucher v JOIN " . DB_PREFIX . "customer c WHERE v.voucher_id = vh.voucher_id AND v.to_email = c.email AND c.customer_id = '" . (int)$this->customer->getId() . "'"; $db .= " GROUP BY v.voucher_id";
$result = $this->db->query($db);
return $result->rows;
}
public function getVouchergift() {
$db = "SELECT v.voucher_id, v.code, v.from_name, v.date_added, v.amount FROM " . DB_PREFIX . "voucher v JOIN " . DB_PREFIX . "customer c WHERE v.to_email = c.email AND c.customer_id = '" . (int)$this->customer->getId() . "'"; $db .= " ORDER BY v.date_added DESC";
$query = $this->db->query($db);
return $query->rows;
}
}