41 lines
1.1 KiB
PHP
41 lines
1.1 KiB
PHP
<?php
|
|
|
|
$userAssocArray = $sql->assoc_array("
|
|
SELECT
|
|
uk_name AS 'Név',
|
|
CASE
|
|
WHEN uk_gender = 1 THEN 'fiú'
|
|
ELSE 'lány'
|
|
END AS 'Nem',
|
|
uk_birth_date AS 'Születési dátum',
|
|
scc_city AS 'Lakhely',
|
|
CASE
|
|
WHEN uk_hand = 1 THEN 'bal'
|
|
ELSE 'jobb'
|
|
END AS 'Kéz',
|
|
sc_name AS 'Iskola',
|
|
uk_email AS 'Email',
|
|
uk_phone AS 'Telefonszám',
|
|
p1.up_name AS 'Szülő',
|
|
p1.up_email AS 'Szülő Email',
|
|
p1.up_phone AS 'Szülő Telefonszám',
|
|
uk_other AS 'Egyéb'
|
|
FROM
|
|
user_kid
|
|
LEFT JOIN
|
|
user_parent p1 ON p1.up_id = uk_parent_1
|
|
LEFT JOIN
|
|
school ON sc_id = uk_school_sc_id
|
|
LEFT JOIN
|
|
user_kid_training_type ON uktt_user_kid_uk_id = uk_id
|
|
LEFT JOIN
|
|
school_city ON uk_address_scc_id = scc_id
|
|
WHERE
|
|
uk_deleted = 0 AND uk_is_active = 1
|
|
GROUP BY uk_name
|
|
ORDER BY uk_name;
|
|
");
|
|
|
|
$smarty->assign("users", $userAssocArray);
|
|
$smarty->display("user_export_list.tpl");
|