我的記帳小本本副本 | 程式專案

{"id":44563,"student_id":73,"content":"{\"html\":\"\u003c!DOCTYPE html\u003e\\n\u003chtml\u003e\\n\u003chead\u003e\\n\\t\u003ctitle\u003eDocument\u003c/title\u003e\\n    \u003clink rel=\\\"stylesheet\\\" href=\\\"https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css\\\" integrity=\\\"sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm\\\" crossorigin=\\\"anonymous\\\"\u003e\\n    \u003cscript src=\\\"https://code.jquery.com/jquery-3.2.1.slim.min.js\\\" integrity=\\\"sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN\\\" crossorigin=\\\"anonymous\\\"\u003e\u003c/script\u003e\\n    \u003cscript src=\\\"https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js\\\" integrity=\\\"sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q\\\" crossorigin=\\\"anonymous\\\"\u003e\u003c/script\u003e\\n    \u003cscript src=\\\"https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js\\\" integrity=\\\"sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl\\\" crossorigin=\\\"anonymous\\\"\u003e\u003c/script\u003e\\n\u003c/head\u003e\\n\u003cbody class=\\\"p-3\\\"\u003e\\n    \u003ch1 class=\\\"h4 text-center\\\"\u003e我的迷你記帳本\u003c/h1\u003e\\n    \u003chr\u003e\\n    \u003cdiv class=\\\"row\\\"\u003e\\n        \u003cdiv class=\\\"col-4\\\"\u003e\\n            \u003cselect class=\\\"form-control\\\" id =\\\"js-add-category\\\"\u003e\\n                \u003coption value=\\\"食物\\\"\u003e食物\u003c/option\u003e\\n                \u003coption value=\\\"交通\\\"\u003e交通\u003c/option\u003e\\n                \u003coption value=\\\"食物\\\"\u003e衣服\u003c/option\u003e\\n                \u003coption value=\\\"交通\\\"\u003e娛樂\u003c/option\u003e\\n                 \u003coption value=\\\"食物\\\"\u003e生活用品\u003c/option\u003e\\n                \u003coption value=\\\"交通\\\"\u003e其他\u003c/option\u003e\\n            \u003c/select\u003e\\n        \u003c/div\u003e\\n        \u003cdiv class=\\\"col-4\\\"\u003e\\n            \u003cinput class=\\\"form-control\\\" id=\\\"js-add-description\\\" type=\\\"text\\\" placeholder=\\\"描述\\\"\u003e\\n        \u003c/div\u003e\\n        \u003cdiv class=\\\"col-4\\\"\u003e\\n            \u003cinput class=\\\"form-control\\\" type=\\\"number\\\" id =\\\"js-add-price\\\" placeholder=\\\"價格\\\"\u003e\\n        \u003c/div\u003e\\n    \u003c/div\u003e\\n    \u003cbutton class=\\\"btn btn-danger btn-block my-3\\\" id=\\\"js-add\\\" \u003e新增\u003c/button\u003e\\n    \u003chr\u003e\\n    \u003cdiv class=\\\"row\\\"\u003e\\n        \u003cdiv class=\\\"col-4\\\"\u003e\\n            \u003cselect class=\\\"form-control\\\" id =\\\"js-search-category\\\"\u003e\\n                \u003coption value=\\\"食物\\\"\u003e食物\u003c/option\u003e\\n                \u003coption value=\\\"交通\\\"\u003e交通\u003c/option\u003e\\n                 \u003coption value=\\\"食物\\\"\u003e衣服\u003c/option\u003e\\n                \u003coption value=\\\"交通\\\"\u003e娛樂\u003c/option\u003e\\n                 \u003coption value=\\\"食物\\\"\u003e生活用品\u003c/option\u003e\\n                \u003coption value=\\\"交通\\\"\u003e其他\u003c/option\u003e\\n            \u003c/select\u003e\\n        \u003c/div\u003e\\n        \u003cdiv class=\\\"col-4\\\"\u003e\\n            \u003cinput class=\\\"form-control\\\" id =\\\"js-search-startTime\\\" type=\\\"date\\\" value=\\\"2000-01-01\\\"\u003e\\n        \u003c/div\u003e\\n        \u003cdiv class=\\\"col-4\\\"\u003e\\n            \u003cinput class=\\\"form-control\\\" id =\\\"js-search-endTimerch\\\" type=\\\"date\\\" value=\\\"2020-12-31\\\"\u003e\\n        \u003c/div\u003e\\n    \u003c/div\u003e\\n    \u003cbutton class=\\\"btn btn-primary btn-block my-3\\\" id = \\\"js-search\\\" \u003e搜尋\u003c/button\u003e\\n    \u003cp class=\\\"alert alert-warning js-total\\\"\u003e總和:\u003c/p\u003e\\n    \u003ctable class=\\\"table table-striped\\\"\u003e\\n        \u003cthead\u003e\\n            \u003ctr\u003e\\n        \\t\\t\u003cth\u003e日期\u003c/th\u003e\\n                \u003cth\u003e類型\u003c/th\u003e\\n                \u003cth\u003e名稱\u003c/th\u003e\\n                \u003cth\u003e花費\u003c/th\u003e\\n        \\t\u003c/tr\u003e\\n        \u003c/thead\u003e\\n        \u003ctbody\u003e\\n        \u003c/tbody\u003e\\n    \u003c/table\u003e\\n\u003c/body\u003e\\n\u003c/html\u003e\",\"css\":\"\",\"js\":\"var billing = new DB.table('billing')\\nbilling.find({}, undateTable);\\n$('#js-add').click(function() {\\n    console.log(\\\"時間:\\\"+ new Date());\\n    console.log(\\\"種類:\\\"+$(\\\"#js-add-category\\\").val())\\n    console.log(\\\"描述:\\\"+$(\\\"#js-add-description\\\").val())\\n    console.log(\\\"價錢:\\\"+$(\\\"#js-add-price\\\").val())\\n    $(\\\"#js-search\\\").on(\\\"click\\\", function() {\\n        var category = $(\\\"#js-search-category\\\").val()\\n        var startTime = $(\\\"#js-search-startTime\\\").val()\\n        var endtTime = $(\\\"#js-search-endTime\\\").val()\\n        return number;\\n        billing.find({\\n            \\\"category\\\": category,\\n            \\\"date\\\":{\\n                \\\"gte\\\":startTime,\\n                \\\"lt\\\":endtTime\\n            }\\n        }, undateTable);\\n\\n    })\\n    billing.insert ({\\n        date: new Date(),\\n        \\\"category\\\": $(\\\"#js-add-category\\\").val(),\\n        \\\"description\\\": $(\\\"#js-add-description\\\").val(),\\n        \\\"price\\\": $(\\\"#js-add-price\\\").val()\\n       \\n    })\\n    billing.find({}, undateTable);\\n   \\n})\\n\\nfunction undateTable(datas) {\\n    $(\\\"tbody\\\").html(\\\"\\\")\\n    var amount =0;\\n    for (var i = 0; i \u003c datas.length; i++) {\\n        var date = datas[i].date\\n        var category = datas[i].category\\n        var description = datas[i].description\\n        var price = datas[i].price\\n\\n        var html = `\\n        \u003ctr\u003e\\n        \u003ctd\u003e${date}\u003c/td\u003e\\n        \u003ctd\u003e${category}\u003c/td\u003e\\n        \u003ctd\u003e${description}\u003c/td\u003e\\n        \u003ctd\u003e${price}\u003c/td\u003e\\n        \u003c/tr\u003e`\\n        $(\\\"tbody\\\").append(html)\\n    }\\n}\"}","created_at":"2018-10-06T18:43:51.779+08:00","updated_at":"2019-10-15T20:36:41.094+08:00","name":"我的記帳小本本 副本","language":"web","screenshot":{"url":"https://cdn1.koding.school/uploads/project/screenshot/44563/ed198b6a0e2c895bc11a8f799b959417.jpg"},"parent_id":23181,"plugin":"","description":null,"note":null,"status":"public","like_student_ids":[],"is_featured":false,"views":177,"hashid":"rdvsdw66","is_content_changed":false,"review_status":"unsubmitted","submitted_at":null,"reviewed_at":null,"advise":null,"is_deleted":false}