dev-chiefworks
66 lines
2.1 KiB
PHP
66 lines
2.1 KiB
PHP
<?php
|
|
|
|
class Coupons_model extends CI_Model {
|
|
|
|
function __construct() {
|
|
|
|
}
|
|
|
|
public function loadCoupons($filters=[]) {
|
|
$sql = "SELECT id , substring(code,0,4)||'XXXXXXXX' AS code,amount *.01 AS amount, description,created::date , updated::date
|
|
FROM coupons
|
|
WHERE active IS NULL
|
|
ORDER BY id DESC";
|
|
|
|
$q = $this->db->query($sql);
|
|
return $q;
|
|
}
|
|
|
|
public function loadActiveCoupons($fliters=[]){
|
|
$sql="SELECT substring(ca.code,0,4)||'XXXXXXXX' as code, ca.amount,m.username,m.firstname,m.lastname,ca.added
|
|
FROM coupons_allocation ca
|
|
LEFT JOIN members m ON m.id=ca.member_id
|
|
WHERE ca.active IS NULL
|
|
ORDER BY ca.id DESC";
|
|
|
|
$q = $this->db->query($sql);
|
|
return $q;
|
|
}
|
|
|
|
public function loadRedeemCoupons($fliters=[]){
|
|
$sql="SELECT substring(ca.code,0,4)||'XXXXXXXX' as code, ca.amount,m.username,m.firstname,m.lastname,ca.added
|
|
FROM coupons_allocation ca
|
|
LEFT JOIN members m ON m.id=ca.member_id
|
|
WHERE ca.active IS NOT NULL
|
|
ORDER BY ca.id DESC";
|
|
|
|
$q = $this->db->query($sql);
|
|
return $q;
|
|
}
|
|
|
|
public function loadActiveMemberCoupons($member_id, $fliters=[]){
|
|
$sql="SELECT substring(ca.code,0,4)||'XXXXXXXX' as code, ca.amount,ca.added
|
|
FROM coupons_allocation ca
|
|
LEFT JOIN members m ON m.id=ca.member_id
|
|
WHERE ca.active IS NULL
|
|
AND m.id = $member_id
|
|
ORDER BY ca.id DESC";
|
|
|
|
$q = $this->db->query($sql);
|
|
return $q;
|
|
}
|
|
|
|
public function loadRedeemMemberCoupons($member_id, $fliters=[]){
|
|
$sql="SELECT substring(ca.code,0,4)||'XXXXXXXX' as code, ca.amount,ca.active
|
|
FROM coupons_allocation ca
|
|
LEFT JOIN members m ON m.id=ca.member_id
|
|
WHERE ca.active IS NOT NULL
|
|
AND m.id = $member_id
|
|
ORDER BY ca.id DESC";
|
|
|
|
$q = $this->db->query($sql);
|
|
return $q;
|
|
}
|
|
|
|
}
|