Revize 1319
Přidáno uživatelem Michal Kliment před téměř 13 roky(ů)
| freenetis/branches/testing/application/models/member.php | ||
|---|---|---|
|
IF(mi.id IS NOT NULL, ?, ?) AS membership_interrupt,
|
||
|
IF(mi.id IS NOT NULL, 1, 0) AS interrupt,
|
||
|
m.organization_identifier, m.comment,
|
||
|
m.entrance_date, m.leaving_date
|
||
|
m.entrance_date, m.leaving_date, m.entrance_fee
|
||
|
FROM members m
|
||
|
LEFT JOIN enum_types e ON m.type = e.id
|
||
|
LEFT JOIN translations t ON e.value = t.original_term AND lang = ?
|
||
| ... | ... | |
|
IFNULL(t.translated_term, e.value) AS type,
|
||
|
IF(mi.id IS NOT NULL, ?, ?) AS membership_interrupt,
|
||
|
m.organization_identifier, m.comment,
|
||
|
m.entrance_date, m.leaving_date
|
||
|
m.entrance_date, m.leaving_date, m.entrance_fee
|
||
|
FROM members m
|
||
|
LEFT JOIN enum_types e ON m.type = e.id
|
||
|
LEFT JOIN translations t ON e.value = t.original_term AND lang = ?
|
||
| freenetis/branches/testing/application/controllers/members.php | ||
|---|---|---|
|
$filter_form->add('leaving_date')
|
||
|
->type('date');
|
||
|
|
||
|
$filter_form->add('entrance_fee')
|
||
|
->type('number');
|
||
|
|
||
|
$filter_form->add('comment');
|
||
|
|
||
|
$filter_form->add('registration')
|
||
Také k dispozici: Unified diff
U zobrazeni vsech clenu pridan filtr na vstupni prispevek.