Revize 18ac9009
Přidáno uživatelem Ondřej Fibich před asi 9 roky(ů)
application/models/member.php | ||
---|---|---|
// query
|
||
return $this->db->query("
|
||
SELECT id, id AS member_id, name AS member_name, registration, registrations,
|
||
surname, firstname,
|
||
name, street, street_number, town, quarter, variable_symbol, aid, balance,
|
||
a_comment, a_comments_thread_id, type, type_name, entrance_date, leaving_date,
|
||
redirect_type_id, GROUP_CONCAT(DISTINCT redirect_type SEPARATOR ', ') AS redirect,
|
||
GROUP_CONCAT(DISTINCT redirect_type_text SEPARATOR ', \n') AS redirect_text,
|
||
notification_by_redirection, notification_by_email, notification_by_sms,
|
||
whitelisted, interrupt, 1 AS redirection, 1 AS email, 1 AS sms $select_cloud
|
||
applicant_connected_from, whitelisted, interrupt, 1 AS redirection,
|
||
1 AS email, 1 AS sms $select_cloud
|
||
FROM
|
||
(
|
||
SELECT
|
||
m.id, m.registration, m.registrations, m.name,
|
||
u.surname, u.name AS firstname,
|
||
s.street, ap.street_number, t.town, t.quarter,
|
||
vs.variable_symbol, a.id AS aid,
|
||
a.balance, a_comment,
|
||
a.comments_thread_id AS a_comments_thread_id,
|
||
m.type, IFNULL(f.translated_term, e.value) AS type_name,
|
||
m.entrance_date, m.leaving_date, redirect_type,
|
||
m.type, type_name, m.entrance_date, m.leaving_date,
|
||
m.applicant_connected_from, redirect_type,
|
||
redirect_type_id, redirect_type_text, whitelisted,
|
||
m.notification_by_redirection, m.notification_by_email,
|
||
m.notification_by_sms, interrupt $select_cloud
|
||
... | ... | |
IF(m.registration = 1, ?, ?) AS registration,
|
||
m.registration AS registrations,
|
||
m.type,
|
||
IFNULL(t.translated_term, e.value) AS type_name,
|
||
IF(mi.id IS NOT NULL, 1, 0) AS membership_interrupt,
|
||
IF(mi.id IS NOT NULL, 1, 0) AS interrupt,
|
||
m.organization_identifier, m.vat_organization_identifier,
|
||
m.comment, m.entrance_date, m.leaving_date,
|
||
m.entrance_fee, m.speed_class_id, m.notification_by_redirection,
|
||
m.notification_by_email, m.notification_by_sms
|
||
m.notification_by_email, m.notification_by_sms, applicant_connected_from
|
||
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 = ?
|
||
... | ... | |
IF(mi.id IS NOT NULL, 1, 0) AS membership_interrupt,
|
||
m.organization_identifier, m.vat_organization_identifier,
|
||
m.comment, m.entrance_date, m.leaving_date,
|
||
m.entrance_fee, m.speed_class_id
|
||
m.entrance_fee, m.speed_class_id, m.applicant_connected_from
|
||
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 = ?
|
Také k dispozici: Unified diff
Fix merge issue that removed all staff from developer branch :-).