教师排课状态翻转

#### 此表格老师排课状态修改为永久性停课suspend = 1

UPDATE
    arranging_edit_log
SET
    suspend = 1,
    reson = '其他原因',
    user_id = #### 操作人ID    
WHERE
    teacher_id in  (SELECT t.teacher_id FROM view_teacher t WHERE t.teacher_no in ('CH845189','GE539495'))


#### 此表格老师排课状态修改为阶段性停课 t.suspend=0 and start_time is not null and end_time >curdate()

UPDATE
    arranging_edit_log
SET
    suspend = 0 and start_time = curdate() and end_time = '2019-07-21',
    reson = '其他原因',
    user_id = #### 操作人ID
WHERE
    teacher_id in (SELECT t.teacher_id FROM view_teacher t WHERE t.teacher_no in ('PH586230','EN605171'))

伦红叶日常需求

SELECT
    t.teacher_no 教师编号,
    t.email_personal 教师邮箱,
    (select hrm_teacher_id from jx_teacher_hrm_id where teacher_id=t.teacher_id) HRMid
FROM
    view_teacher t
WHERE
    t.teacher_no in ()
文档更新时间: 2019-03-08 11:44   作者:admin