123456789101112131415 |
- SELECT
- sch.name,sch.organ_id,sch.id
- FROM
- base_organ_school sch
- {{if .user_id }}
- INNER JOIN
- base_user_organ_school user_sch
- ON
- sch.id= user_sch.os_id
- WHERE
- sch.del_flag = 0
- and user_sch.del_flag = 0
- and onoff =98
- and user_sch.user_id = '{{.user_id}}'
- {{end}}
|