ccDangJianExamForOpenGauss/target/classes/Sql/graduationAction.sql

#namespace("graduation")

  -- 获取当前年份是否已处理完毕业
  #sql("checkCurrentYearIsGraduation")
      select count(1) as count from t_base_graduation where finish_year=?
  #end

  -- 获取需要处理的班级个数
  #sql("getNeedActionClass")
    select class_id from t_base_class where entry_year+school_length=? and b_use=1 limit ?
  #end

  -- 修改指定班级下的学生和家长为毕业状态
  #sql("changeToGraduationByClassId")
    update t_sys_loginperson set b_use=0,status_code='07' where s_class_id=?
  #end

  -- 修改班级为毕业状态
  #sql("changeClassBuse")
    update t_base_class set b_use=0 where class_id=?
  #end

#end