~[text:nicktech.merit.error.portal_unavailable]
~(studentname)
~[tlist_sql; SELECT balance, CASE WHEN balance = 1 THEN '~[wc:meritstore/meritPointsSingular]' ELSE '~[wc:meritstore/meritPointsPlural]' END AS balword FROM (SELECT NVL((SELECT SUM(points) FROM u_nt_merit_points WHERE studentsdcid = ~(rn) AND (yearid = ~(curyearid) OR '~[wc:meritstore/meritPrefCarryOver]' = '1')),0) - NVL((SELECT SUM(points_spent) FROM u_nt_merit_redemption WHERE studentsdcid = ~(rn) AND (yearid = ~(curyearid) OR '~[wc:meritstore/meritPrefCarryOver]' = '1')),0) AS balance FROM dual)]~[text:nicktech.merit.label.available_balance] ~(balance) ~(balword)
[/tlist_sql]~[text:nicktech.merit.heading.items_in_store]
~[tlist_sql;
SELECT
NVL(c.name,'') AS icatname,
NVL(c.sort_order,0) AS icatorder,
i.point_cost AS icost,
NVL(i.image_data, TO_CLOB('/images/meritStore.svg')) AS iimage,
i.name AS iname,
CASE WHEN i.point_cost = 1 THEN '~[wc:meritstore/meritPointsSingular]' ELSE '~[wc:meritstore/meritPointsPlural]' END AS iword
FROM u_nt_merit_item i
LEFT JOIN u_nt_merit_item_cat c ON c.id = i.category_id
WHERE i.schoolid = ~(curschoolid)
AND (i.closed is null OR i.closed = 0)
AND (i.qty_total IS NULL OR i.qty_total > 0)
AND (
i.grade_levels IS NULL
OR i.grade_levels = ''
OR INSTR(','||i.grade_levels||',', ','||(SELECT grade_level FROM students WHERE dcid = ~(rn))||',') > 0
)
ORDER BY i.sort_order, i.name]
)
[/tlist_sql]
~(iname)
~(icost) ~(iword)
~[text:nicktech.merit.feedback.no_items_filter]
~[wc:meritstore/meritLabelEarned]
| ~[text:nicktech.merit.th.date] | ~[wc:meritstore/meritPointsPlural] | ~[text:nicktech.merit.th.behavior] | ~[text:nicktech.merit.th.note] |
|---|---|---|---|
| ~(edate) | ~(epts) | ~(edesc) | ~(enote) |
~[text:nicktech.merit.heading.past_redemptions]
| ~[text:nicktech.merit.th.date] | ~[text:nicktech.merit.th.item] | ~[wc:meritstore/meritPointsPlural] |
|---|---|---|
| ~(rdate) | ~(ritem) | ~(rpts) |