Revize df1d9555
Přidáno uživatelem Filip Miškařík před téměř 5 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]