2022-02-14 02:18:30 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_ADMIN 2022-02-14 02:18:40 manageCourse.php (18) checking tablename : semester 2022-02-14 02:19:46 manageOffer.php (109) Insert table offer 2022-02-14 02:19:46 manageOffer.php (121) User: admin 2022-02-14 02:19:46 manageOffer.php (122) SemesterId: 1000002 2022-02-14 02:19:46 manageOffer.php (123) CourseId: 1000006 2022-02-14 02:19:46 manageOffer.php (124) MT Date: 2022-2-21 2022-02-14 02:19:46 manageOffer.php (125) MT Start Time: 2022-2-21 10:00:00 2022-02-14 02:19:46 manageOffer.php (126) MT End Time: 2022-2-21 13:00:00 2022-02-14 02:19:46 manageOffer.php (127) FT Date: 2022-3-29 2022-02-14 02:19:46 manageOffer.php (128) FT Start Time: 2022-3-29 13:00:00 2022-02-14 02:19:46 manageOffer.php (129) FT End Time: 2022-3-29 16:00:00 2022-02-14 02:19:50 manageCourse.php (18) checking tablename : semester 2022-02-14 02:19:50 manageCourse.php (98) checking tablename : course & offer 2022-02-14 02:19:50 manageCourse.php (100) checking semester : 1000002 2022-02-14 02:19:50 manageCourse.php (102) checking session type : administrator 2022-02-14 02:19:50 manageCourse.php (132) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, null as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ?) as c LEFT JOIN (SELECT courseId, offerId, enrollmentStatus FROM enrollment ) as en ON en.courseId = c.courseId; 2022-02-14 02:20:44 manageOffer.php (109) Insert table offer 2022-02-14 02:20:44 manageOffer.php (121) User: admin 2022-02-14 02:20:44 manageOffer.php (122) SemesterId: 1000002 2022-02-14 02:20:44 manageOffer.php (123) CourseId: 1000007 2022-02-14 02:20:44 manageOffer.php (124) MT Date: 2022-2-22 2022-02-14 02:20:44 manageOffer.php (125) MT Start Time: 2022-2-22 9:00:00 2022-02-14 02:20:44 manageOffer.php (126) MT End Time: 2022-2-22 12:00:00 2022-02-14 02:20:44 manageOffer.php (127) FT Date: 2022-3-29 2022-02-14 02:20:44 manageOffer.php (128) FT Start Time: 2022-3-29 13:00:00 2022-02-14 02:20:44 manageOffer.php (129) FT End Time: 2022-3-29 16:00:00 2022-02-14 02:22:17 manageOffer.php (109) Insert table offer 2022-02-14 02:22:17 manageOffer.php (121) User: admin 2022-02-14 02:22:17 manageOffer.php (122) SemesterId: 1000002 2022-02-14 02:22:17 manageOffer.php (123) CourseId: 1000008 2022-02-14 02:22:17 manageOffer.php (124) MT Date: 2022-2-23 2022-02-14 02:22:17 manageOffer.php (125) MT Start Time: 2022-2-23 8:00:00 2022-02-14 02:22:17 manageOffer.php (126) MT End Time: 2022-2-23 11:00:00 2022-02-14 02:22:17 manageOffer.php (127) FT Date: 2022-3-30 2022-02-14 02:22:17 manageOffer.php (128) FT Start Time: 2022-3-30 10:00:00 2022-02-14 02:22:17 manageOffer.php (129) FT End Time: 2022-3-30 13:00:00 2022-02-14 02:23:06 manageOffer.php (109) Insert table offer 2022-02-14 02:23:06 manageOffer.php (121) User: admin 2022-02-14 02:23:06 manageOffer.php (122) SemesterId: 1000002 2022-02-14 02:23:06 manageOffer.php (123) CourseId: 1000009 2022-02-14 02:23:06 manageOffer.php (124) MT Date: 2022-2-21 2022-02-14 02:23:06 manageOffer.php (125) MT Start Time: 2022-2-21 13:00:00 2022-02-14 02:23:06 manageOffer.php (126) MT End Time: 2022-2-21 16:00:00 2022-02-14 02:23:06 manageOffer.php (127) FT Date: 2022-3-29 2022-02-14 02:23:06 manageOffer.php (128) FT Start Time: 2022-3-29 13:00:00 2022-02-14 02:23:06 manageOffer.php (129) FT End Time: 2022-3-29 16:00:00 2022-02-14 02:23:19 manageCourse.php (18) checking tablename : semester 2022-02-14 02:23:27 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_LECTURER 2022-02-14 02:44:03 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_ADMIN 2022-02-14 02:44:33 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_STU 2022-02-14 02:44:44 manageEnrollment.php (90) Get student enrollment courses 2022-02-14 02:45:03 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_STU 2022-02-14 02:45:21 manageUser.php (14) Received 'POST' parameters: [action] = UP_STU [pf] = น.ส. [fn] = กนก [ln] = ก้องเกษมทรัพย์ [fne] = Kanok [lne] = Gongkasemsab [idCrd] = undefined [add] = 3333 [sDis] = ในเมือง [dis] = เมืองนครราชสีมา [prov] = นครราชสีมา [zip] = 30000 [edu] = มัธยมศึกษาตอนปลาย [occ] = นร [ph] = 0911111111 [em] = t@g.com [scode] = [inpState] = 1 [usr] = kanok [pwd] = 123456 [id] = ZMhjZ9jhd3qdulaGyFzD5A== 2022-02-14 02:45:21 manageUser.php->upload.php (10) ไม่มีไฟล์รูปใหม่ให้อัพเดต 2022-02-14 02:45:21 manageUser.php (545) Update table student 2022-02-14 02:45:22 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_STU 2022-02-14 02:45:59 manageEnrollment.php (90) Get student enrollment courses 2022-02-14 02:46:02 manageEnrollment.php (289) Update table enrollment 2022-02-14 02:46:02 manageEnrollment.php (298) usr :admin 2022-02-14 02:46:02 manageEnrollment.php (299) id :1000001 2022-02-14 02:46:02 manageEnrollment.php (300) semId :1000002 2022-02-14 02:46:02 manageEnrollment.php (320) offer Id :1000001 2022-02-14 02:46:02 manageEnrollment.php (321) course Id :1000001 2022-02-14 02:46:02 manageEnrollment.php (325) 2. check enrollment existed 2022-02-14 02:46:02 manageEnrollment.php (341) enrollment Id :1000001 2022-02-14 02:46:02 manageEnrollment.php (349) 3.update existing enrollment 2022-02-14 02:46:02 manageEnrollment.php (351) pArr true 2022-02-14 02:46:02 manageEnrollment.php (352) boolVal 1 2022-02-14 02:46:02 manageEnrollment.php (357) qry :UPDATE enrollment SET enrollmentStatus = ?, editedDate = ?, editedBy = ? WHERE enrollmentId = ?; 2022-02-14 02:46:02 manageEnrollment.php (358) enrollmentStatus :1 2022-02-14 02:46:02 manageEnrollment.php (359) editedDate :2022-02-14 2:46:02 2022-02-14 02:46:02 manageEnrollment.php (360) editedBy :admin 2022-02-14 02:46:02 manageEnrollment.php (361) enrollmentId :1000001 2022-02-14 02:46:02 manageEnrollment.php (320) offer Id :1000002 2022-02-14 02:46:02 manageEnrollment.php (321) course Id :1000002 2022-02-14 02:46:02 manageEnrollment.php (325) 2. check enrollment existed 2022-02-14 02:46:02 manageEnrollment.php (341) enrollment Id :1000002 2022-02-14 02:46:02 manageEnrollment.php (349) 3.update existing enrollment 2022-02-14 02:46:02 manageEnrollment.php (351) pArr false 2022-02-14 02:46:02 manageEnrollment.php (352) boolVal 1 2022-02-14 02:46:02 manageEnrollment.php (357) qry :UPDATE enrollment SET enrollmentStatus = ?, editedDate = ?, editedBy = ? WHERE enrollmentId = ?; 2022-02-14 02:46:02 manageEnrollment.php (358) enrollmentStatus :0 2022-02-14 02:46:02 manageEnrollment.php (359) editedDate :2022-02-14 2:46:02 2022-02-14 02:46:02 manageEnrollment.php (360) editedBy :admin 2022-02-14 02:46:02 manageEnrollment.php (361) enrollmentId :1000002 2022-02-14 02:46:02 manageEnrollment.php (464) insert successfully 2022-02-14 02:52:48 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_ADMIN 2022-02-14 02:52:55 manageCourse.php (18) checking tablename : semester 2022-02-14 02:53:30 manageOffer.php (155) Update table offer 2022-02-14 02:53:30 manageOffer.php (167) User: admin 2022-02-14 02:53:30 manageOffer.php (168) SemesterId: 1000002 2022-02-14 02:53:30 manageOffer.php (169) CourseId: 1000001 2022-02-14 02:53:30 manageOffer.php (170) MT Date: 2022-2-15 2022-02-14 02:53:30 manageOffer.php (171) MT Start Time: 2022-2-15 9:00:00 2022-02-14 02:53:30 manageOffer.php (172) MT End Time: 2022-2-15 12:00:00 2022-02-14 02:53:30 manageOffer.php (173) FT Date: 2022-3-10 2022-02-14 02:53:30 manageOffer.php (174) FT Start Time: 2022-3-10 9:00:00 2022-02-14 02:53:30 manageOffer.php (175) FT End Time: 2022-3-10 12:00:00 2022-02-14 02:54:41 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_ADMIN 2022-02-14 02:56:42 manageOffer.php (155) Update table offer 2022-02-14 02:56:42 manageOffer.php (167) User: admin 2022-02-14 02:56:42 manageOffer.php (168) SemesterId: 1000002 2022-02-14 02:56:42 manageOffer.php (169) CourseId: 1000001 2022-02-14 02:56:42 manageOffer.php (170) MT Date: 2022-2-15 2022-02-14 02:56:42 manageOffer.php (171) MT Start Time: 2022-2-15 9:00:00 2022-02-14 02:56:42 manageOffer.php (172) MT End Time: 2022-2-15 12:00:00 2022-02-14 02:56:42 manageOffer.php (173) FT Date: 2022-3-10 2022-02-14 02:56:42 manageOffer.php (174) FT Start Time: 2022-3-10 9:00:00 2022-02-14 02:56:42 manageOffer.php (175) FT End Time: 2022-3-10 12:00:00 2022-02-14 03:20:51 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_ADMIN 2022-02-14 03:21:00 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_STU 2022-02-14 03:21:21 manageUser.php (14) Received 'POST' parameters: [action] = UP_STU [pf] = น.ส. [fn] = กนก [ln] = ก้องเกษมทรัพย์ [fne] = Kanok [lne] = Kanok [idCrd] = undefined [add] = 3333 [sDis] = ในเมือง [dis] = เมืองนครราชสีมา [prov] = นครราชสีมา [zip] = 30000 [edu] = มัธยมศึกษาตอนปลาย [occ] = นร [ph] = 0911111111 [em] = t@g.com [scode] = [inpState] = 1 [usr] = kanok [pwd] = 123456 [id] = ZMhjZ9jhd3qdulaGyFzD5A== 2022-02-14 03:21:21 manageUser.php->upload.php (10) ไม่มีไฟล์รูปใหม่ให้อัพเดต 2022-02-14 03:21:21 manageUser.php (545) Update table student 2022-02-14 03:21:21 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_STU 2022-02-14 03:24:17 manageUser.php (14) Received 'POST' parameters: [action] = UP_STU [pf] = น.ส. [fn] = กนก [ln] = ก้องเกษมทรัพย์ [fne] = Kanok [lne] = Kanok [idCrd] = undefined [add] = 3333 [sDis] = ในเมือง [dis] = เมืองนครราชสีมา [prov] = นครราชสีมา [zip] = 30000 [edu] = มัธยมศึกษาตอนปลาย [occ] = นร [ph] = 0911111111 [em] = t@g.com [scode] = 3333333 [inpState] = 1 [usr] = kanok [pwd] = 123456 [id] = ZMhjZ9jhd3qdulaGyFzD5A== 2022-02-14 03:24:17 manageUser.php->upload.php (10) ไม่มีไฟล์รูปใหม่ให้อัพเดต 2022-02-14 03:24:17 manageUser.php (545) Update table student 2022-02-14 03:24:17 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_STU 2022-02-14 03:30:32 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_ADMIN 2022-02-14 03:30:37 manageCourse.php (18) checking tablename : semester 2022-02-14 03:30:43 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_LECTURER [courseId] = ZMhjZ9jhd3qdulaGyFzD5A== 2022-02-14 03:32:29 manageCourse.php (18) checking tablename : semester 2022-02-14 03:33:54 manageCourse.php (18) checking tablename : semester 2022-02-14 03:33:59 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_LECTURER [courseId] = ZMhjZ9jhd3qdulaGyFzD5A== 2022-02-14 03:36:46 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_LECTURER [courseId] = ZMhjZ9jhd3qdulaGyFzD5A== 2022-02-14 16:07:39 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_ADMIN 2022-02-14 16:08:14 manageCourse.php (19) checking tablename : semester 2022-02-14 16:09:33 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_LECTURER [courseId] = ZMhjZ9jhd3qdulaGyFzD5A== 2022-02-14 16:52:20 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_ADMIN 2022-02-14 16:52:26 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_LECTURER 2022-02-14 17:31:45 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_LECTURER 2022-02-14 17:32:25 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_ADMIN 2022-02-14 18:26:30 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_ADMIN 2022-02-14 18:26:37 manageCourse.php (19) checking tablename : semester 2022-02-14 18:26:40 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_LECTURER [courseId] = ZMhjZ9jhd3qdulaGyFzD5A== 2022-02-14 20:55:14 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_ADMIN 2022-02-14 20:56:24 manageOffer.php (155) Update table offer 2022-02-14 20:56:24 manageOffer.php (167) User: admin 2022-02-14 20:56:24 manageOffer.php (168) SemesterId: 1000002 2022-02-14 20:56:24 manageOffer.php (169) CourseId: 1000001 2022-02-14 20:56:24 manageOffer.php (170) MT Date: 2022-2-14 2022-02-14 20:56:24 manageOffer.php (171) MT Start Time: 2022-2-14 21:00:00 2022-02-14 20:56:24 manageOffer.php (172) MT End Time: 2022-2-14 22:00:00 2022-02-14 20:56:24 manageOffer.php (173) FT Date: 2022-3-10 2022-02-14 20:56:24 manageOffer.php (174) FT Start Time: 2022-3-10 9:00:00 2022-02-14 20:56:24 manageOffer.php (175) FT End Time: 2022-3-10 12:00:00 2022-02-14 21:08:00 manageCourse.php (19) checking tablename : semester 2022-02-14 21:08:08 manageCourse.php (19) checking tablename : semester 2022-02-14 21:08:08 manageCourse.php (185) checking tablename : course 2022-02-14 21:08:08 manageCourse.php (186) checking course Id : 1000001 2022-02-14 21:08:12 manageCourse.php (19) checking tablename : semester 2022-02-14 21:08:13 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_LECTURER [courseId] = ZMhjZ9jhd3qdulaGyFzD5A== 2022-02-14 21:09:31 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_LECTURER [courseId] = ZMhjZ9jhd3qdulaGyFzD5A== 2022-02-14 21:13:34 manageCourse.php (19) checking tablename : semester 2022-02-14 21:13:34 manageCourse.php (53) checking tablename : course & offer 2022-02-14 21:13:34 manageCourse.php (19) checking tablename : semester 2022-02-14 21:13:34 manageCourse.php (99) checking tablename : course & offer 2022-02-14 21:13:34 manageCourse.php (101) checking semester : 1000002 2022-02-14 21:13:34 manageCourse.php (102) filter Dep : 2022-02-14 21:13:34 manageCourse.php (104) checking session type : administrator 2022-02-14 21:13:34 manageCourse.php (138) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, null as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT courseId, offerId, enrollmentStatus FROM enrollment ) as en ON en.courseId = c.courseId; 2022-02-14 21:19:50 manageCourse.php (19) checking tablename : semester 2022-02-14 21:19:50 manageCourse.php (53) checking tablename : course & offer 2022-02-14 21:19:50 manageCourse.php (19) checking tablename : semester 2022-02-14 21:19:50 manageCourse.php (99) checking tablename : course & offer 2022-02-14 21:19:50 manageCourse.php (101) checking semester : 1000002 2022-02-14 21:19:50 manageCourse.php (102) filter Dep : 2022-02-14 21:19:50 manageCourse.php (104) checking session type : administrator 2022-02-14 21:19:50 manageCourse.php (138) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, null as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT courseId, offerId, enrollmentStatus FROM enrollment ) as en ON en.courseId = c.courseId; 2022-02-14 21:19:56 manageCourse.php (19) checking tablename : semester 2022-02-14 21:19:56 manageCourse.php (19) checking tablename : semester 2022-02-14 21:19:56 manageCourse.php (53) checking tablename : course & offer 2022-02-14 21:19:56 manageCourse.php (99) checking tablename : course & offer 2022-02-14 21:19:56 manageCourse.php (101) checking semester : 1000002 2022-02-14 21:19:56 manageCourse.php (102) filter Dep : 2022-02-14 21:19:56 manageCourse.php (104) checking session type : administrator 2022-02-14 21:19:56 manageCourse.php (138) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, null as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT courseId, offerId, enrollmentStatus FROM enrollment ) as en ON en.courseId = c.courseId; 2022-02-14 21:20:13 manageCourse.php (19) checking tablename : semester 2022-02-14 21:20:13 manageCourse.php (53) checking tablename : course & offer 2022-02-14 21:20:13 manageCourse.php (19) checking tablename : semester 2022-02-14 21:20:13 manageCourse.php (99) checking tablename : course & offer 2022-02-14 21:20:13 manageCourse.php (101) checking semester : 1000002 2022-02-14 21:20:13 manageCourse.php (102) filter Dep : 2022-02-14 21:20:13 manageCourse.php (104) checking session type : administrator 2022-02-14 21:20:13 manageCourse.php (138) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, null as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT courseId, offerId, enrollmentStatus FROM enrollment ) as en ON en.courseId = c.courseId; 2022-02-14 21:20:46 manageCourse.php (19) checking tablename : semester 2022-02-14 21:20:46 manageCourse.php (53) checking tablename : course & offer 2022-02-14 21:20:46 manageCourse.php (19) checking tablename : semester 2022-02-14 21:20:46 manageCourse.php (99) checking tablename : course & offer 2022-02-14 21:20:46 manageCourse.php (101) checking semester : 1000002 2022-02-14 21:20:46 manageCourse.php (102) filter Dep : 2022-02-14 21:20:46 manageCourse.php (104) checking session type : administrator 2022-02-14 21:20:46 manageCourse.php (138) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, null as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT courseId, offerId, enrollmentStatus FROM enrollment ) as en ON en.courseId = c.courseId; 2022-02-14 21:52:27 manageCourse.php (19) checking tablename : semester 2022-02-14 21:52:27 manageCourse.php (99) checking tablename : course & offer 2022-02-14 21:52:27 manageCourse.php (101) checking semester : 1000002 2022-02-14 21:52:27 manageCourse.php (102) filter Dep : 2022-02-14 21:52:27 manageCourse.php (104) checking session type : administrator 2022-02-14 21:52:27 manageCourse.php (138) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, null as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT courseId, offerId, enrollmentStatus FROM enrollment ) as en ON en.courseId = c.courseId; 2022-02-14 21:52:31 manageCourse.php (19) checking tablename : semester 2022-02-14 21:52:31 manageCourse.php (185) checking tablename : course 2022-02-14 21:52:31 manageCourse.php (186) checking course Id : 1000003 2022-02-14 22:03:08 manageCourse.php (19) checking tablename : semester 2022-02-14 22:03:08 manageCourse.php (45) ไม่พบข้อมูลในตาราง semester 2022-02-14 22:31:35 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_ADMIN 2022-02-14 22:33:51 manageEnrollment.php (91) Get student enrollment courses 2022-02-14 22:33:57 manageUser.php (14) Received 'POST' parameters: [action] = GET_LIST_STU 2022-02-14 22:34:17 manageCourse.php (19) checking tablename : semester 2022-02-14 22:34:17 manageCourse.php (99) checking tablename : course & offer 2022-02-14 22:34:17 manageCourse.php (101) checking semester : 1000002 2022-02-14 22:34:17 manageCourse.php (102) filter Dep : 2022-02-14 22:34:17 manageCourse.php (104) checking session type : administrator 2022-02-14 22:34:17 manageCourse.php (138) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, null as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT courseId, offerId, enrollmentStatus FROM enrollment ) as en ON en.courseId = c.courseId;