liumiao
2021-01-29 68e91f406108b1c19057c90d8555f2c899cf22e9
根据学员获取课次
2 files modified
4 ■■■■ changed files
app/Http/Controllers/Api/v1/ClassScheduleController.php 2 ●●● patch | view | raw | blame | history
app/Models/CourseTableModel.php 2 ●●● patch | view | raw | blame | history
app/Http/Controllers/Api/v1/ClassScheduleController.php
@@ -346,7 +346,7 @@
        $roleIdArr = $request->post("roleIdArr");
        $courseTableId = $request->post("courseTableId");
        $contentTime = $request->post("contentTime");
        $teacherId = $this->getAndCheckTeacherId(); //236523
        $teacherId = 55027;//$this->getAndCheckTeacherId(); //236523
        if(empty($date))
        {
            $date = date("Y-m-d");
app/Models/CourseTableModel.php
@@ -32,7 +32,7 @@
    {
        $sql = "
                select  ct.id as courseTableId,ct.staffId,ct.orgId,ct.classNumber,ct.classCode,ct.sectionid,ct.week,ct.hometeacherId,
                  ctt.contentTime,cr.roomname,c.teacherName,c.classMode,c.,left(ct.startTime,10) AS startTime,c.className,c.classHour,ctt.id as cTimeId  from anni_coursetable as ct
                  ctt.contentTime,cr.roomname,c.teacherName,c.classMode,left(ct.startTime,10) AS startTime,c.className,c.classHour,ctt.id as cTimeId  from anni_coursetable as ct
                left join anni_coursetabletime as ctt on ct.classCode = ctt.classCode and ct.week = ctt.week
                left join anni_classroom as cr on  ct.orgId = cr.orgId and ct.sectionid = cr.id
                left join anni_class as c on  ct.classCode = c.classCode