Revize df1d9555
Přidáno uživatelem Filip Miškařík před více než 4 roky(ů)
application/models/member.php | ||
---|---|---|
{
|
||
$order_by_direction = 'asc';
|
||
}
|
||
|
||
$account_type_credit = Account_attribute_Model::CREDIT;
|
||
|
||
// query
|
||
return $this->db->query("
|
||
SELECT id, id AS member_id, name AS member_name, registration, registrations,
|
||
... | ... | |
LEFT JOIN address_points ap ON m.address_point_id = ap.id
|
||
LEFT JOIN streets s ON ap.street_id = s.id
|
||
LEFT JOIN towns t ON ap.town_id = t.id
|
||
LEFT JOIN accounts a ON a.member_id = m.id AND m.id <> 1
|
||
LEFT JOIN accounts a ON a.member_id = m.id AND m.id <> 1 AND a.account_attribute_id = ?
|
||
LEFT JOIN variable_symbols vs ON vs.account_id = a.id
|
||
LEFT JOIN
|
||
(
|
||
... | ... | |
__('Yes'),
|
||
__('No'),
|
||
Config::get('lang'),
|
||
$account_type_credit,
|
||
Config::get('lang'),
|
||
// redir shortcuts
|
||
__('IM'),
|
Také k dispozici: Unified diff
Issue #940: Account balance on list of all members showing only credit account balance [develop]