1 / 1

braith
Download Presentation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Leave where bCancelTimeOff!=1 and iYear=100 and iSemester=2 and cStudentID='A000C134' and iCourseID='33610' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(distinct send_date) from CM_care_send_msg_record where sender='T100000055' and username='A000C134' and send_date>='2012-06-29' and send_date<='2012-06-28' ----- ----- (mysql): select count(1) from CM_warning_course_item_light where iYear=100 and iSemester=2 and cStudentID='A000C134' and course_id='33610' and course_no='AC2040' and teacher_id='T100000055' ----- ----- (mysql): update CM_warning_course_item_light set attendance_light='green',care_light='green' where iYear=100 and iSemester=2 and cStudentID='A000C134' and course_id='33610' and course_no='AC2040' and teacher_id='T100000055' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Late where iYear=100 and iSemester=2 and cStudentID='A000C138' and iCourseID='33610' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_LeaveEarly where iYear=100 and iSemester=2 and cStudentID='A000C138' and iCourseID='33610' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Truancy where iYear=100 and iSemester=2 and cStudentID='A000C138' and iCourseID='33610' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Leave where bCancelTimeOff!=1 and iYear=100 and iSemester=2 and cStudentID='A000C138' and iCourseID='33610' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(distinct send_date) from CM_care_send_msg_record where sender='T100000055' and username='A000C138' and send_date>='2012-06-29' and send_date<='2012-06-28' ----- ----- (mysql): select count(1) from CM_warning_course_item_light where iYear=100 and iSemester=2 and cStudentID='A000C138' and course_id='33610' and course_no='AC2040' and teacher_id='T100000055' ----- ----- (mysql): update CM_warning_course_item_light set attendance_light='green',care_light='green' where iYear=100 and iSemester=2 and cStudentID='A000C138' and course_id='33610' and course_no='AC2040' and teacher_id='T100000055' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Late where iYear=100 and iSemester=2 and cStudentID='A000C139' and iCourseID='33610' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_LeaveEarly where iYear=100 and iSemester=2 and cStudentID='A000C139' and iCourseID='33610' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Truancy where iYear=100 and iSemester=2 and cStudentID='A000C139' and iCourseID='33610' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Leave where bCancelTimeOff!=1 and iYear=100 and iSemester=2 and cStudentID='A000C139' and iCourseID='33610' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(distinct send_date) from CM_care_send_msg_record where sender='T100000055' and username='A000C139' and send_date>='2012-06-29' and send_date<='2012-06-28' ----- ----- (mysql): select count(1) from CM_warning_course_item_light where iYear=100 and iSemester=2 and cStudentID='A000C139' and course_id='33610' and course_no='AC2040' and teacher_id='T100000055' ----- ----- (mysql): update CM_warning_course_item_light set attendance_light='green',care_light='green' where iYear=100 and iSemester=2 and cStudentID='A000C139' and course_id='33610' and course_no='AC2040' and teacher_id='T100000055' ----- ----- (mysql): delete from CM_warning_course_update_record where iYear=100 and iSemester=2 and course_id='33610' and course_no='AC2040' and teacher_id='T100000055' ----- ----- (mysql): select class_id from CM_class where department_id=(select distinct department_id from CMM_course_view where course_year='100' and course_semester='2' and SUBSTRING(course_id,1,LENGTH(course_id)-1)='33612' and course_no='AC2060') ----- ----- (mysql): select cmwi.item_id,cmwi.item_en_name,cmwilr.light_color,cmwis.subitem_id,cmwis.subitem_en_name,cmwilr.limit_condition,cmwilr.limit_count,cmws.`interval`,cmws.isUpdate from CM_warning_item as cmwi join CM_warning_status as cmws on cmwi.apply_role like '%courseteacher%' and cmws.iYear=100 and cmws.iSemester=2 and cmws.status=1 and cmwi.item_id=cmws.item_id join CM_warning_item_subitem as cmwis on cmwis.is_set=1 and cmwi.item_id=cmwis.item_id join CM_warning_item_light_rule as cmwilr on cmwilr.class_id in (1000000) and cmws.iYear=cmwilr.iYear and cmws.iSemester=cmwilr.iSemester and cmwis.subitem_id=cmwilr.subitem_id order by cmwi.item_id,cmwilr.light_color,cmwis.subitem_id ----- ----- (mysql): select cmmcg.username from (select SUBSTRING(course_id,1,LENGTH(course_id)-1) as course_id,course_no from CMM_course_view where teacher_id='T094000111' and course_year='100' and course_semester='2' and class_id='1009' and course_no='AC2060' having course_id='33612') as cmmc join CMM_course_grade as cmmcg on cmmc.course_id=cmmcg.course_id and cmmc.course_no=cmmcg.course_no join CMM_student as cmmst on cmmcg.username=cmmst.username order by cmmcg.username ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Late where iYear=100 and iSemester=2 and cStudentID='A000C101' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_LeaveEarly where iYear=100 and iSemester=2 and cStudentID='A000C101' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Truancy where iYear=100 and iSemester=2 and cStudentID='A000C101' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Leave where bCancelTimeOff!=1 and iYear=100 and iSemester=2 and cStudentID='A000C101' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(distinct send_date) from CM_care_send_msg_record where sender='T094000111' and username='A000C101' and send_date>='2012-06-29' and send_date<='2012-06-28' ----- ----- (mysql): select count(1) from CM_warning_course_item_light where iYear=100 and iSemester=2 and cStudentID='A000C101' and course_id='33612' and course_no='AC2060' and teacher_id='T094000111' ----- ----- (mysql): update CM_warning_course_item_light set attendance_light='green',care_light='green' where iYear=100 and iSemester=2 and cStudentID='A000C101' and course_id='33612' and course_no='AC2060' and teacher_id='T094000111' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Late where iYear=100 and iSemester=2 and cStudentID='A000C103' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_LeaveEarly where iYear=100 and iSemester=2 and cStudentID='A000C103' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Truancy where iYear=100 and iSemester=2 and cStudentID='A000C103' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Leave where bCancelTimeOff!=1 and iYear=100 and iSemester=2 and cStudentID='A000C103' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(distinct send_date) from CM_care_send_msg_record where sender='T094000111' and username='A000C103' and send_date>='2012-06-29' and send_date<='2012-06-28' ----- ----- (mysql): select count(1) from CM_warning_course_item_light where iYear=100 and iSemester=2 and cStudentID='A000C103' and course_id='33612' and course_no='AC2060' and teacher_id='T094000111' ----- ----- (mysql): update CM_warning_course_item_light set attendance_light='green',care_light='green' where iYear=100 and iSemester=2 and cStudentID='A000C103' and course_id='33612' and course_no='AC2060' and teacher_id='T094000111' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Late where iYear=100 and iSemester=2 and cStudentID='A000C104' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_LeaveEarly where iYear=100 and iSemester=2 and cStudentID='A000C104' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Truancy where iYear=100 and iSemester=2 and cStudentID='A000C104' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Leave where bCancelTimeOff!=1 and iYear=100 and iSemester=2 and cStudentID='A000C104' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(distinct send_date) from CM_care_send_msg_record where sender='T094000111' and username='A000C104' and send_date>='2012-06-29' and send_date<='2012-06-28' ----- ----- (mysql): select count(1) from CM_warning_course_item_light where iYear=100 and iSemester=2 and cStudentID='A000C104' and course_id='33612' and course_no='AC2060' and teacher_id='T094000111' ----- ----- (mysql): update CM_warning_course_item_light set attendance_light='green',care_light='green' where iYear=100 and iSemester=2 and cStudentID='A000C104' and course_id='33612' and course_no='AC2060' and teacher_id='T094000111' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Late where iYear=100 and iSemester=2 and cStudentID='A000C105' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_LeaveEarly where iYear=100 and iSemester=2 and cStudentID='A000C105' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Truancy where iYear=100 and iSemester=2 and cStudentID='A000C105' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Leave where bCancelTimeOff!=1 and iYear=100 and iSemester=2 and cStudentID='A000C105' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(distinct send_date) from CM_care_send_msg_record where sender='T094000111' and username='A000C105' and send_date>='2012-06-29' and send_date<='2012-06-28' ----- ----- (mysql): select count(1) from CM_warning_course_item_light where iYear=100 and iSemester=2 and cStudentID='A000C105' and course_id='33612' and course_no='AC2060' and teacher_id='T094000111' ----- ----- (mysql): update CM_warning_course_item_light set attendance_light='green',care_light='green' where iYear=100 and iSemester=2 and cStudentID='A000C105' and course_id='33612' and course_no='AC2060' and teacher_id='T094000111' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Late where iYear=100 and iSemester=2 and cStudentID='A000C106' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_LeaveEarly where iYear=100 and iSemester=2 and cStudentID='A000C106' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Truancy where iYear=100 and iSemester=2 and cStudentID='A000C106' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Leave where bCancelTimeOff!=1 and iYear=100 and iSemester=2 and cStudentID='A000C106' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(distinct send_date) from CM_care_send_msg_record where sender='T094000111' and username='A000C106' and send_date>='2012-06-29' and send_date<='2012-06-28' ----- ----- (mysql): select count(1) from CM_warning_course_item_light where iYear=100 and iSemester=2 and cStudentID='A000C106' and course_id='33612' and course_no='AC2060' and teacher_id='T094000111' ----- ----- (mysql): update CM_warning_course_item_light set attendance_light='green',care_light='green' where iYear=100 and iSemester=2 and cStudentID='A000C106' and course_id='33612' and course_no='AC2060' and teacher_id='T094000111' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Late where iYear=100 and iSemester=2 and cStudentID='A000C107' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_LeaveEarly where iYear=100 and iSemester=2 and cStudentID='A000C107' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Truancy where iYear=100 and iSemester=2 and cStudentID='A000C107' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Leave where bCancelTimeOff!=1 and iYear=100 and iSemester=2 and cStudentID='A000C107' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(distinct send_date) from CM_care_send_msg_record where sender='T094000111' and username='A000C107' and send_date>='2012-06-29' and send_date<='2012-06-28' ----- ----- (mysql): select count(1) from CM_warning_course_item_light where iYear=100 and iSemester=2 and cStudentID='A000C107' and course_id='33612' and course_no='AC2060' and teacher_id='T094000111' ----- ----- (mysql): update CM_warning_course_item_light set attendance_light='green',care_light='green' where iYear=100 and iSemester=2 and cStudentID='A000C107' and course_id='33612' and course_no='AC2060' and teacher_id='T094000111' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Late where iYear=100 and iSemester=2 and cStudentID='A000C109' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_LeaveEarly where iYear=100 and iSemester=2 and cStudentID='A000C109' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Truancy where iYear=100 and iSemester=2 and cStudentID='A000C109' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Leave where bCancelTimeOff!=1 and iYear=100 and iSemester=2 and cStudentID='A000C109' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(distinct send_date) from CM_care_send_msg_record where sender='T094000111' and username='A000C109' and send_date>='2012-06-29' and send_date<='2012-06-28' ----- ----- (mysql): select count(1) from CM_warning_course_item_light where iYear=100 and iSemester=2 and cStudentID='A000C109' and course_id='33612' and course_no='AC2060' and teacher_id='T094000111' ----- ----- (mysql): update CM_warning_course_item_light set attendance_light='green',care_light='green' where iYear=100 and iSemester=2 and cStudentID='A000C109' and course_id='33612' and course_no='AC2060' and teacher_id='T094000111' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Late where iYear=100 and iSemester=2 and cStudentID='A000C110' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_LeaveEarly where iYear=100 and iSemester=2 and cStudentID='A000C110' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Truancy where iYear=100 and iSemester=2 and cStudentID='A000C110' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Leave where bCancelTimeOff!=1 and iYear=100 and iSemester=2 and cStudentID='A000C110' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(distinct send_date) from CM_care_send_msg_record where sender='T094000111' and username='A000C110' and send_date>='2012-06-29' and send_date<='2012-06-28' ----- ----- (mysql): select count(1) from CM_warning_course_item_light where iYear=100 and iSemester=2 and cStudentID='A000C110' and course_id='33612' and course_no='AC2060' and teacher_id='T094000111' ----- ----- (mysql): update CM_warning_course_item_light set attendance_light='green',care_light='green' where iYear=100 and iSemester=2 and cStudentID='A000C110' and course_id='33612' and course_no='AC2060' and teacher_id='T094000111' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Late where iYear=100 and iSemester=2 and cStudentID='A000C111' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_LeaveEarly where iYear=100 and iSemester=2 and cStudentID='A000C111' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Truancy where iYear=100 and iSemester=2 and cStudentID='A000C111' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Leave where bCancelTimeOff!=1 and iYear=100 and iSemester=2 and cStudentID='A000C111' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(distinct send_date) from CM_care_send_msg_record where sender='T094000111' and username='A000C111' and send_date>='2012-06-29' and send_date<='2012-06-28' ----- ----- (mysql): select count(1) from CM_warning_course_item_light where iYear=100 and iSemester=2 and cStudentID='A000C111' and course_id='33612' and course_no='AC2060' and teacher_id='T094000111' ----- ----- (mysql): update CM_warning_course_item_light set attendance_light='green',care_light='green' where iYear=100 and iSemester=2 and cStudentID='A000C111' and course_id='33612' and course_no='AC2060' and teacher_id='T094000111' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Late where iYear=100 and iSemester=2 and cStudentID='A000C112' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_LeaveEarly where iYear=100 and iSemester=2 and cStudentID='A000C112' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Truancy where iYear=100 and iSemester=2 and cStudentID='A000C112' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Leave where bCancelTimeOff!=1 and iYear=100 and iSemester=2 and cStudentID='A000C112' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(distinct send_date) from CM_care_send_msg_record where sender='T094000111' and username='A000C112' and send_date>='2012-06-29' and send_date<='2012-06-28' ----- ----- (mysql): select count(1) from CM_warning_course_item_light where iYear=100 and iSemester=2 and cStudentID='A000C112' and course_id='33612' and course_no='AC2060' and teacher_id='T094000111' ----- ----- (mysql): update CM_warning_course_item_light set attendance_light='green',care_light='green' where iYear=100 and iSemester=2 and cStudentID='A000C112' and course_id='33612' and course_no='AC2060' and teacher_id='T094000111' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Late where iYear=100 and iSemester=2 and cStudentID='A000C113' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_LeaveEarly where iYear=100 and iSemester=2 and cStudentID='A000C113' and iCourseID='33612' and dDate>='2012-06-29' and dDate<='2012-06-28' ----- ----- (mysql): select count(*) from View_ePortfolio_StudentDashboard_Truancy where iYear=100 and iSemester=2 and cStudentID='A000C113' and iCourseID='33612' and dDate>='2012-06-2

More Related