EventLog.md 755 B
queryByPage
SELECT @pageTag(){
- @} FROM event_log WHERE 1=1
queryById
SELECT
el.*,
a.apply_name apply_name,
e.event_name event_name
FROM event_log el
LEFT JOIN event e on el.event_id = e.id
LEFT JOIN apply a on el.apply_id = a.uuid
WHERE 1=1
@if(!isEmpty(id)){
and el.id=#id#
@}
ORDER BY el.id
queryByPage2
SELECT
@pageTag(){
el.*,
a.apply_name apply_name,
e.event_name event_name
@}
FROM event_log el
LEFT JOIN event e on el.event_id = e.id
LEFT JOIN apply a on el.apply_id = a.uuid
WHERE 1=1
@if(!isEmpty(applyId)){
and a.uuid=#applyId#
@}
@if(!isEmpty(eventId)){
and e.id=#eventId#
@}
@if(!isEmpty(applyName)){
and a.apply_name like #applyName#
@}
@if(!isEmpty(eventName)){
and e.event_name like #eventName#
@}
ORDER BY el.id