待辦事項 - 學生版副本 | 程式專案

{"id":121010,"student_id":3647,"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    \u003ch1\u003e待辦事項\u003c/h1\u003e\\n    \\n    \u003c!-- 新增表單 --\u003e\\n    \u003cdiv class=\\\"box\\\"\u003e\\n        \u003cinput id=\\\"input\\\"/\u003e\\n        \u003cspan id=\\\"create\\\"\u003e新增\u003c/span\u003e\\n    \u003c/div\u003e\\n    \\n    \u003c!-- 事項列表 --\u003e\\n    \u003cdiv class=\\\"box\\\"\u003e\\n        \u003cdiv id=\\\"list\\\"\u003e\\n            \u003cdiv class=\\\"item\\\"\u003e\\n                \u003cspan class=\\\"text\\\"\u003e數學回家作業\u003c/span\u003e\\n                \u003cspan class=\\\"delete\\\"\u003e移除\u003c/span\u003e\\n                \u003cspan class=\\\"update\\\"\u003e修改\u003c/span\u003e\\n            \u003c/div\u003e\\n            \u003cdiv class=\\\"item\\\"\u003e\\n                \u003cspan class=\\\"text\\\"\u003e自然報告\u003c/span\u003e\\n                \u003cspan class=\\\"delete\\\"\u003e移除\u003c/span\u003e\\n                \u003cspan class=\\\"update\\\"\u003e修改\u003c/span\u003e\\n            \u003c/div\u003e\\n            \u003cdiv class=\\\"item\\\"\u003e\\n                \u003cspan class=\\\"text\\\"\u003e買水彩用品、筆記本\u003c/span\u003e\\n                \u003cspan class=\\\"delete\\\"\u003e移除\u003c/span\u003e\\n                \u003cspan class=\\\"update\\\"\u003e修改\u003c/span\u003e\\n            \u003c/div\u003e\\n            \u003cdiv class=\\\"item\\\"\u003e\\n                \u003cspan class=\\\"text\\\"\u003e訂電影票\u003c/span\u003e\\n                \u003cspan class=\\\"delete\\\"\u003e移除\u003c/span\u003e\\n                \u003cspan class=\\\"update\\\"\u003e修改\u003c/span\u003e\\n            \u003c/div\u003e\\n            \u003cdiv class=\\\"item\\\"\u003e\\n                \u003cspan class=\\\"text\\\"\u003e幫媽媽寄送包裹\u003c/span\u003e\\n                \u003cspan class=\\\"delete\\\"\u003e移除\u003c/span\u003e\\n                \u003cspan class=\\\"update\\\"\u003e修改\u003c/span\u003e\\n            \u003c/div\u003e\\n        \u003c/div\u003e    \\n        \u003cspan id=\\\"deleteAll\\\"\u003e移除全部\u003c/span\u003e\\n    \u003c/div\u003e\\n    \\n\u003c/body\u003e\\n\u003c/html\u003e\",\"css\":\"body {\\n    font-size: 1rem;\\n    padding: 0px 30px;\\n    min-height: 100vh;\\n    background-image: linear-gradient(#ff6161,#ff768c);\\n}\\n\\nh1 {\\n    color: #fff;\\n    text-align: center;\\n}\\n\\n#input {\\n    outline: none;\\n    width: 300px;\\n    font-size: 1rem;\\n    padding: 5px 10px;\\n    border: 1px solid #eee;\\n    display: inline-block;\\n}\\n\\n#create {\\n    padding: 5px 0px;\\n    color: #369eff;\\n    float: right;\\n    cursor: pointer;\\n    font-weight: bold;\\n}\\n\\n#deleteAll {\\n    font-size: 0.9rem;\\n    display: inline-block;\\n    color: #ff768c;\\n    padding: 10px 0px;\\n    cursor: pointer;\\n}\\n\\n.box {\\n    box-sizing: border-box;\\n    width: 400px;\\n    padding: 10px;\\n    margin: auto;\\n    border-radius: 1px;\\n    margin-bottom: 20px;\\n    background-color: #fff;\\n    box-shadow: 0px 5px 2px rgba(0, 0, 0, .1);\\n}\\n\\n.item {\\n    color: #555;\\n    padding: 10px 0px;\\n    border-bottom: 1px solid #eee;\\n}\\n\\n.update, .delete {\\n    float: right;\\n    padding: 0px 5px;\\n    font-size: 0.9rem;\\n    cursor: pointer;\\n    opacity: 0.6;\\n}\\n.update {\\n    color: #369eff;\\n}\\n.delete {\\n    color: #ff768c;\\n}\\n.delete:hover, .update:hover {\\n    opacity: 1;\\n}\\n\\n\",\"js\":\"var task = DB.table('task'); // task 資料表存放事項資料\\ntask.read({}, updateList); // 查詢所有資料並更新至畫面\\n\\n$('#create').click(create); //「新增」被點擊時執行 create 指令\\n$('#deleteAll').click(deleteAll); //「移除全部」被點擊時執行 deleteAll 指令\\n$('.delete').click(deleteTask); //「刪除」被點擊時執行 deleteTask 指令\\n$('.update').click(updateTask); //「修改」被點擊時執行 updateTask 指令\\n\\n\\n// 新增一筆資料至資料庫\\nfunction create () {\\n    var text = $(\\\"#input\\\").val();\\n    $(\\\"#input\\\").val(\\\"\\\");\\n    task.create({\\n        text: text\\n    });\\n    task.read({}, console.log);\\n}\\n\\n// 將查詢的資料新增到介面列表上\\nfunction updateList (data) {\\n    $('#list').empty();\\n    for (var i = 0; i \u003c data.length; i++) {\\n        var row = `\\n        \u003cdiv class=\\\"item\\\" data -id=${data[i].id}\u003e\\n        \u003cspan class=\\\"text\\\"\u003e${data[i].text}\u003c/span\u003e\\n        \u003cspan class=\\\"delete\\\"\u003e移除\u003c/span\u003e\\n        \u003cspan class=\\\"update\\\"\u003e修改\u003c/span\u003e\\n        \u003c/div\u003e`;\\n        $('#list').append(row);\\n    }\\n}\\n\\n\\n\\n\\n\\n\\n\\n// 刪除全部事項\\nfunction deleteAll () {\\n\\n    task.delete({});\\n\\n\\n}\\n$('#list').on('click', '.delete', deleteTask);\\n$('#list').on('click', '.update', updateTask);\\n// 刪除指定事項\\nfunction deleteTask () {\\n    alert(\\\"確定刪除此事項?\\\");\\n    var id =\\n    $(this).parent().data(\\\"id\\\");\\n    task.delete({\\n        id: id\\n    });\\n    task.read({}, updateList);\\n    alert(\\\"此事項表示:(O n O)\\\");\\n}\\n\\n// 更新指定事項\\nfunction updateTask () {\\n    var oldtext =\\n    $(this).parent().find('.text').text();\\n    alert(\\\"確定更新此事項?\\\");\\n\\n    var newtext = prompt('你要修改成...?');\\n\\n    task.update({\\n        text: oldtext\\n    }, {\\n        text: newtext\\n    });\\n    task.read({}, updateList)\\n}\"}","created_at":"2020-01-18T18:37:06.247+08:00","updated_at":"2020-03-15T00:04:43.820+08:00","name":"待辦事項 - 學生版 副本","language":"web","screenshot":{"url":"https://cdn3.koding.school/uploads/project/screenshot/121010/78bb056eab228422467df9f03479dd10.jpg"},"parent_id":113125,"plugin":"","description":null,"note":null,"status":"public","like_student_ids":[],"is_featured":false,"views":218,"hashid":"d5ms4v22","is_content_changed":false,"review_status":"unsubmitted","submitted_at":null,"reviewed_at":null,"advise":null,"is_deleted":false}