edu项目的改进

edu 项目后期还可改进的

 1、市 县的页面加查看使用计时 可以方便市县的查看。

2、老师添加课程表的那块 （那节课有人上了，他就添加不了了）可以加个查看总课表。

3、总课表显示老师名字 

4、点击学校跳到学校页面 点击老师跳到老师页面的解决方法。

 

客户端的修改

目前问题 连续点击刷新会报错

 

 

可以加建议做成向畅言的页面  方便后期添加功能

使用说明 那些数据怎么产生的等  帮助视频 通知 

查看课程表 老师注册等

意见反馈 弹出h5页面的，方便收集信息

客户端选课的时候直接出第几节课

常用sql 

1、删除安装表 没做关联删除 班级删除了安装记录还在 所以要把安装记录删除了 

DELETE from t_install where id in (
select * from (
SELECT a.id from t_install as a
LEFT JOIN d_school_classes as b on b.id= a.classes_id
where b.status='0'
)as a
)

2、删除一张表中重复数据

 

//多个条件 删除课程表 年级 班级 星期几 第几节
delete from d_school_curriculum where id in (
select * from (
SELECT id from d_school_curriculum as a where (a.grade_id,a.classes_id,a.week,a.lesson) in
(select grade_id,classes_id,week,lesson from d_school_curriculum group by grade_id,classes_id,week,lesson having count(*) > 1) and
addtime not in (select max(addtime) from d_school_curriculum group by grade_id,classes_id,week,lesson having count(*) > 1 )
)as a
)

//删除课程表 老师同时添加
delete from d_school_curriculum where id in (
select * from (
SELECT id from d_school_curriculum as a where (a.addtime,a.teacher_id,a.week,a.lesson) in
(select addtime,teacher_id,week,lesson from d_school_curriculum group by addtime,teacher_id,week,lesson having count(*) > 1)
and id not in (select min(id) from d_school_curriculum group by addtime,teacher_id,week,lesson having count(*)>1)
)as a
)

 

单个条件
delete from t_install where id in (
select * from (
select id from t_install
where classes_id in (select classes_id from t_install group by classes_id having count(classes_id) > 1 ) and
updatetime not in (select max(updatetime) from t_install group by classes_id having count(classes_id) > 1)
)as a

)