04.老師小幫手副本 | 程式專案

{"id":99699,"student_id":888,"content":"{\"html\":\"\u003c!DOCTYPE html\u003e\\n\u003chtml\u003e\\n\u003chead\u003e\\n\\t\u003ctitle\u003eDocument\u003c/title\u003e\\n\\t\u003cscript src=\\\"https://code.jquery.com/jquery-3.4.1.min.js\\\"\u003e\u003c/script\u003e\\n\u003c/head\u003e\\n\u003cbody\u003e\\n    \u003cimg src=\\\"owl.png\\\"/\u003e\\n    \u003ctable\u003e\\n        \u003cthead\u003e\\n            \u003ctr\u003e\\n                \u003cth\u003e姓名\u003c/th\u003e\\n                \u003cth id=\\\"order_by_a\\\"\u003e國文A\u003c/th\u003e\\n                \u003cth id=\\\"order_by_b\\\"\u003e英文B\u003c/th\u003e\\n                \u003cth id=\\\"order_by_c\\\"\u003e數學C\u003c/th\u003e\\n                \u003cth id=\\\"order_by_sum\\\"\u003e總成績\u003c/th\u003e\\n                \u003cth\u003e\u003c/th\u003e\\n            \u003c/tr\u003e\\n        \u003c/thead\u003e\\n        \u003ctbody\u003e\\n            \u003c!-- 這是用來複製的範例，專案完成後即可刪除 --\u003e    \\n            \u003ctr\u003e\\n                \u003ctd\u003e束凱文\u003c/td\u003e\\n                \u003ctd\u003e46\u003c/td\u003e\\n                \u003ctd\u003e88\u003c/td\u003e\\n                \u003ctd\u003e91\u003c/td\u003e\\n                \u003ctd\u003e225\u003c/td\u003e\\n                \u003ctd\u003e刪除\u003c/td\u003e\\n            \u003c/tr\u003e\\n            \u003ctr\u003e\\n                \u003ctd\u003e劉大偉\u003c/td\u003e\\n                \u003ctd\u003e95\u003c/td\u003e\\n                \u003ctd\u003e99\u003c/td\u003e\\n                \u003ctd\u003e85\u003c/td\u003e\\n                \u003ctd\u003e279\u003c/td\u003e\\n                \u003ctd\u003e刪除\u003c/td\u003e\\n            \u003c/tr\u003e\\n            \u003ctr\u003e\\n                \u003ctd\u003e何小妹\u003c/td\u003e\\n                \u003ctd\u003e75\u003c/td\u003e\\n                \u003ctd\u003e100\u003c/td\u003e\\n                \u003ctd\u003e68\u003c/td\u003e\\n                \u003ctd\u003e243\u003c/td\u003e\\n                \u003ctd\u003e刪除\u003c/td\u003e\\n            \u003c/tr\u003e\\n            \u003ctr\u003e\\n                \u003ctd\u003e邱小玉\u003c/td\u003e\\n                \u003ctd\u003e97\u003c/td\u003e\\n                \u003ctd\u003e81\u003c/td\u003e\\n                \u003ctd\u003e35\u003c/td\u003e\\n                \u003ctd\u003e213\u003c/td\u003e\\n                \u003ctd\u003e刪除\u003c/td\u003e\\n            \u003c/tr\u003e\\n            \u003ctr\u003e\\n                \u003ctd\u003e張育瑋\u003c/td\u003e\\n                \u003ctd\u003e88\u003c/td\u003e\\n                \u003ctd\u003e93\u003c/td\u003e\\n                \u003ctd\u003e100\u003c/td\u003e\\n                \u003ctd\u003e281\u003c/td\u003e\\n                \u003ctd\u003e刪除\u003c/td\u003e\\n            \u003c/tr\u003e\\n        \u003c/tbody\u003e\\n    \u003c/table\u003e\\n    \u003cbutton id=\\\"create\\\"\u003e新增成績\u003c/button\u003e\\n\u003c/body\u003e\\n\u003c/html\u003e\",\"css\":\"body {\\n    padding: 45px;\\n    background-color: #eee;\\n    text-align: center;\\n}\\n\\ntable {\\n    border-collapse: collapse;\\n    width: 100%;\\n    margin: 15px 0px;\\n    border: 1px solid #eee;\\n    background-color: #fff;\\n}\\n\\nth, td {\\n    padding: 15px;\\n    border-bottom: 1px solid #ddd;\\n    color: #333;\\n}\\n\\ntr td:last-child {\\n    color: red;\\n    cursor: pointer;\\n}\\n\\nimg {\\n    width: 150px;\\n}\\n\\nbutton {\\n    padding: 5px 10px;\\n    border: none;\\n    font-size: 1rem;\\n    color: #fff;\\n    background-color: #4CAF50;\\n}\\n\\n#order_by_a,\\n#order_by_b,\\n#order_by_c,\\n#order_by_sum {\\n    cursor: pointer;\\n}\\n\\n#order_by_a:hover,\\n#order_by_b:hover,\\n#order_by_c:hover,\\n#order_by_sum:hover {\\n    color: orange;\\n}\",\"js\":\"var grade = DB.table('score');\\nvar a_Byhow = -1;\\nvar b_Byhow = -1\\nvar c_Byhow = -1\\n$('#create').click(create);\\n$('#order_by_sum').click(orderBySum);\\n$('#order_by_a').click(orderBya);\\n$('#order_by_b').click(orderByb);\\n$('#order_by_c').click(orderByc);\\n\\n$('tbody').on('click', '.js-delete', removeGrade);\\n\\nfunction create() {\\n    // 1.寫入成績並計算\\n    var name = prompt('姓名?');\\n    var a = Number(prompt('國文成績?'));\\n    var b = Number(prompt('英文成績?'));\\n    var c = Number(prompt('數學成績?'));\\n    \\n    // 2.寫入資料表讀出\\n    grade.create({\\n        name: name,\\n        a: a,\\n        b: b,\\n        c: c,\\n        //多一個sum?\\n    });\\n    grade.read({}, renderTable);\\n}\\n\\nfunction renderTable(data) {\\n    $('tbody').empty();\\n    \\n    data.forEach(function (d) {\\n        \\n        var a = '';\\n        var b = '';\\n        var c = '';\\n        if (a \u003c 60) {\\n            a = 'bg-red';\\n        }\\n        if (b \u003c 60) {\\n            b = 'bg-red';\\n        }\\n        if (c \u003c 60) {\\n            c = 'bg-red';\\n        }\\n        \\n        \\n        var html = `\\n        \u003ctr\u003e\\n            \u003ctd\u003e${d.name}\u003c/td\u003e\\n            \u003ctd class=\\\"${a}\\\"\u003e${d.a}\u003c/td\u003e\\n            \u003ctd class=\\\"${b}\\\"\u003e${d.b}\u003c/td\u003e\\n            \u003ctd class=\\\"${c}\\\"\u003e${d.c}\u003c/td\u003e\\n            \u003ctd\u003e${d.a + d.b + d.c}\u003c/td\u003e\\n            \u003ctd id=\\\"${d.id}\\\" class=\\\"js-delete\\\"\u003e刪除\u003c/td\u003e\\n        \u003c/tr\u003e\\n        `\\n        $('tbody').append(html);\\n    });\\n}\\n\\nfunction removeGrade () {\\n    var id = $(this).attr('id');\\n    grade.delete({\\n        id: id\\n    });\\n    grade.read({}, renderTable);\\n}\\n\\nfunction orderBySum() {\\n    grade.read({}, {\\n        $orderBy: {\\n            sum: -1,\\n        }\\n    }, renderTable);\\n}\\n\\ngrade.read({}, renderTable);\\n\\n\\nfunction orderBya() {\\n    a_Byhow == 1? a_Byhow = -1:a_Byhow = 1\\n    grade.read({}, {\\n        $orderBy: {\\n            a: a_Byhow,\\n        }\\n    }, renderTable);\\n}\\n\\nfunction orderByb() {\\n    b_Byhow == 1? b_Byhow = -1:b_Byhow = 1\\n    grade.read({}, {\\n        $orderBy: {\\n            b: b_Byhow,\\n        }\\n    }, renderTable);\\n}\\n\\nfunction orderByc() {\\n    c_Byhow == 1? c_Byhow = -1:c_Byhow = 1\\n    grade.read({}, {\\n        $orderBy: {\\n            c: c_Byhow,\\n        }\\n    }, renderTable);\\n}\\n\"}","created_at":"2019-10-04T17:28:04.155+08:00","updated_at":"2019-11-10T23:37:13.382+08:00","name":"04.老師小幫手 副本","language":"web","screenshot":{"url":null},"parent_id":95155,"plugin":"","description":null,"note":null,"status":"public","like_student_ids":[],"is_featured":false,"views":433,"hashid":"d5ms8evz","is_content_changed":false,"review_status":"unsubmitted","submitted_at":null,"reviewed_at":null,"advise":null,"is_deleted":false}