Revize 2a205303
Přidáno uživatelem Michal Kliment před více než 9 roky(ů)
| application/models/bank_account.php | ||
|---|---|---|
|
m.name AS member_name, ba.member_id, ba.type, ba.settings
|
||
|
FROM bank_accounts ba
|
||
|
LEFT JOIN members m ON m.id = ba.member_id
|
||
|
WHERE ba.member_id <> 1 $where
|
||
|
WHERE (ba.member_id <> 1 OR ba.member_id IS NULL) $where
|
||
|
ORDER BY ".$this->db->escape_column($order_by)." $order_by_direction
|
||
|
LIMIT " . intval($limit_from) . ", " . intval($limit_results) . "
|
||
|
");
|
||
| ... | ... | |
|
return $this->db->query("
|
||
|
SELECT COUNT(*) AS total
|
||
|
FROM bank_accounts ba
|
||
|
WHERE ba.member_id <> 1 $where"
|
||
|
WHERE (ba.member_id <> 1 OR ba.member_id IS NULL) $where"
|
||
|
)->current()->total;
|
||
|
}
|
||
|
|
||
Také k dispozici: Unified diff
Release 1.1.10