[Develop] 教職員基本資料不顯示已停權的人員

在mysql 建立 "teacher_online"

CREATE
    /*[ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
    [DEFINER = { user | CURRENT_USER }]
    [SQL SECURITY { DEFINER | INVOKER }]*/
    VIEW `school`.`teacher_online`
    AS
    (
    select teacher.*
    from
    userights
    inner join
    teacher
    on userights.account = teacher.account
    WHERE
    userights.pause=0
    )

修改檔案：
school/basic/index_intro.php
school/basic/index_intro_area.php

修改內容：
將所有的 SQL 指令中的 " from teacher " ==> " from teacher_online "