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

{"id":41833,"student_id":1587,"content":"{\"html\":\"\u003c!DOCTYPE html\u003e\\n\u003chtml\u003e\\n\u003chead\u003e\\n\\t\u003ctitle\u003e我的迷你記帳本\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    \u003ch1 class=\\\"add text-center\\\"\u003eADD\u003c/h1\u003e\\n    \u003cdiv class=\\\"row\\\"\u003e\\n        \u003cdiv class=\\\"col-4\\\"\u003e\\n            \u003cselect class=\\\"form-control 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                \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 js-add-description\\\" type=\\\"text\\\" placeholder=\\\"描述\\\"\u003e\\n        \u003c/div\u003e\\n        \u003cdiv class=\\\"col-4\\\"\u003e\\n            \u003cinput class=\\\"form-control js-add-price\\\" type=\\\"text\\\" placeholder=\\\"價格\\\"\u003e\\n        \u003c/div\u003e\\n    \u003c/div\u003e\\n    \u003cbutton class=\\\"btn btn-danger btn-block my-3 js-add\\\"\u003e新增\u003c/button\u003e\\n    \u003chr\u003e\\n    \u003ch1 class=\\\"search text-center\\\"\u003eSEARCH\u003c/h1\u003e\\n    \u003cdiv class=\\\"row\\\"\u003e\\n        \u003cdiv class=\\\"col-4\\\"\u003e\\n            \u003cselect class=\\\"form-control 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                \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 start\\\"\u003e\\n            \u003cinput class=\\\"form-control js-search-startTime\\\" type=\\\"date\\\" value=\\\"2000-01-01\\\"\u003e\\n        \u003c/div\u003e\\n        \u003cdiv class=\\\"col-4 end\\\"\u003e\\n            \u003cinput class=\\\"form-control js-search-endTime\\\" 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 js-search\\\"\u003e搜尋\u003c/button\u003e\\n    \\n    \\n    \u003ch1 class=\\\"delete text-center\\\"\u003eDELETE\u003c/h1\u003e\\n    \u003cdiv class=\\\"row\\\"\u003e\\n        \u003cdiv class=\\\"col-4\\\"\u003e\\n            \u003cselect class=\\\"form-control js-delete-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                \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 start\\\"\u003e\\n            \u003cinput class=\\\"form-control js-delete-startTime\\\" type=\\\"date\\\" value=\\\"2000-01-01\\\"\u003e\\n        \u003c/div\u003e\\n        \u003cdiv class=\\\"col-4 end\\\"\u003e\\n            \u003cinput class=\\\"form-control js-delete-endTime\\\" type=\\\"date\\\" value=\\\"2020-12-31\\\"\u003e\\n        \u003c/div\u003e\\n    \u003c/div\u003e\\n    \u003cbutton class=\\\"btn btn-warning btn-block my-3 js-delete\\\"\u003e刪除\u003c/button\u003e\\n    \\n    \\n    \u003cp class=\\\"alert alert-warning js-total\\\"\u003e總和:\u003c/p\u003e\\n    \u003cp class=\\\"alert alert-warning js-times\\\"\u003e筆數:\u003c/p\u003e\\n    \u003ctable class=\\\"table table-striped\\\"\u003e\\n        \u003cthead class=\\\"thread\\\"\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        \u003c!--\u003ctr class=\\\"date1\\\"\u003e\u003c/tr\u003e\\n        \u003ctr class=\\\"category1\\\"\u003e\u003c/tr\u003e\\n        \u003ctr class=\\\"description1\\\"\u003e\u003c/tr\u003e\\n        \u003ctr class=\\\"price1\\\"\u003e\u003c/tr\u003e\\n        /--\u003e\\n        \u003ctbody\u003e\\n        \u003c/tbody\u003e\\n    \u003c/table\u003e\\n\u003c/body\u003e\\n\u003c/html\u003e\",\"css\":\"\",\"js\":\"var billing = DB.table('billing');\\nvar category;\\nvar description;\\nvar addprice = 0;\\nvar data1;\\nvar date;\\nvar totalprice = 0;\\n\\nbilling.find({}, updateTable);\\n\\n\\n/*\\nfor (var i; i \u003c billing.length; i++) {\\n    category = billing[i].category;\\n    console.log(category);\\n    description = billing[i].description;\\n    price = billing[i].price;\\n\\n    $('category1').append(\\\"\u003ctd\u003e\\\"+category+\\\"\u003c/td\u003e\\\");\\n    $('description1').append(\\\"\u003ctd\u003e\\\"+description+\\\"\u003c/td\u003e\\\");\\n    $('price1').append(\\\"\u003ctd\u003e\\\"+price+\\\"\u003c/td\u003e\\\");\\n}*/\\n\\n$('.js-add').click(function() {\\n    console.log(\\\"{add___\\\");\\n    console.log($('.js-add-category').val());\\n    console.log($('.js-add-description').val());\\n    console.log($('.js-add-price').val());\\n    console.log(\\\"______}\\\");\\n\\n    category = $('.js-add-category').val();\\n    description = $('.js-add-description').val();\\n    addprice = $('.js-add-price').val();\\n    console.log(addprice);\\n    if ($('.js-add-price').val() == \\\"\\\") {\\n        addprice = 0;\\n    }\\n    date = new Date();\\n    /*\\n    console.log(category);\\n    console.log(description);\\n    console.log(price);\\n    console.log(date);\\n    */\\n\\n    billing.insert({\\n        date: date,\\n        category: category,\\n        description: description,\\n        price: addprice,\\n    });\\n\\n    // $('.thread').html(\\\"\\\");\\n\\n    date = date.slice(0, 10);\\n    console.log(date);\\n\\n    billing.find({}, updateTable);\\n    /*\\n    $('.date1').append(\\\"\u003ctd\u003e\\\"+date+\\\"\u003c/td\u003e\\\");\\n    $('.category1').append(\\\"\u003ctd\u003e\\\"+category+\\\"\u003c/td\u003e\\\");\\n    $('.description1').append(\\\"\u003ctd\u003e\\\"+description+\\\"\u003c/td\u003e\\\");\\n    $('.price1').append(\\\"\u003ctd\u003e\\\"+addprice+\\\"\u003c/td\u003e\\\");\\n    */\\n    $('.thread').append(\\\"\u003ctr\u003e\u003c/tr\u003e\\\");\\n    $('.thread').append(\\\"\u003ctd\u003e\\\"+date+\\\"\u003c/td\u003e\\\");\\n    $('.thread').append(\\\"\u003ctd\u003e\\\"+category+\\\"\u003c/td\u003e\\\");\\n    $('.thread').append(\\\"\u003ctd\u003e\\\"+description+\\\"\u003c/td\u003e\\\");\\n    $('.thread').append(\\\"\u003ctd\u003e\\\"+addprice+\\\"\u003c/td\u003e\\\");\\n    $('.thread').append(\\\"\u003ctr\u003e\u003c/tr\u003e\\\");\\n\\n    $('.js-add-description').val(\\\"\\\");\\n    $('.js-add-price').val(\\\"\\\");\\n});\\n\\n//-----------------------------------------------------------------------\\n\\n$('.js-search').click(function() {\\n    $('.thread').html(\\\"\\\");\\n    // console.log(\\\"01\\\");\\n    if ($('.js-search-category').val() == \\\"全部\\\") {\\n        billing.find({\\n            date: {\\n                $gte: new Date($('.js-search-startTime').val()),\\n                $lt: new Date($('.js-search-endTime').val())\\n            }\\n        }, updateTable);\\n    }\\n\\n    // gte --\u003e greater than equal\\n\\n    if ($('.js-search-category').val() == \\\"食物(食)\\\") {\\n        billing.find({\\n            category: \\\"食物(食)\\\",\\n            date: {\\n                $gte: new Date($('.js-search-startTime').val()),\\n                $lt: new Date($('.js-search-endTime').val())\\n            }\\n        }, updateTable);\\n    }\\n    if ($('.js-search-category').val() == \\\"衣服(衣)\\\") {\\n        billing.find({\\n            category: \\\"衣服(衣)\\\",\\n            date: {\\n                $gte: new Date($('.js-search-startTime').val()),\\n                $lt: new Date($('.js-search-endTime').val())\\n            }\\n        }, updateTable);\\n    }\\n    if ($('.js-search-category').val() == \\\"房屋(住)\\\") {\\n        billing.find({\\n            category: \\\"房屋(住)\\\",\\n            date: {\\n                $gte: new Date($('.js-search-startTime').val()),\\n                $lt: new Date($('.js-search-endTime').val())\\n            }\\n        }, updateTable);\\n    }\\n    if ($('.js-search-category').val() == \\\"交通(行)\\\") {\\n        billing.find({\\n            category: \\\"交通(行)\\\",\\n            date: {\\n                $gte: new Date($('.js-search-startTime').val()),\\n                $lt: new Date($('.js-search-endTime').val())\\n            }\\n        }, updateTable);\\n    }\\n    if ($('.js-search-category').val() == \\\"教育(育)\\\") {\\n        billing.find({\\n            category: \\\"教育(育)\\\",\\n            date: {\\n                $gte: new Date($('.js-search-startTime').val()),\\n                $lt: new Date($('.js-search-endTime').val())\\n            }\\n        }, updateTable);\\n    }\\n    if ($('.js-search-category').val() == \\\"娛樂(樂)\\\") {\\n        billing.find({\\n            category: \\\"娛樂(樂)\\\",\\n            date: {\\n                $gte: new Date($('.js-search-startTime').val()),\\n                $lt: new Date($('.js-search-endTime').val())\\n            }\\n        }, updateTable);\\n    }\\n    if ($('.js-search-category').val() == \\\"其他\\\") {\\n        billing.find({\\n            category: \\\"其他\\\",\\n            date: {\\n                $gte: new Date($('.js-search-startTime').val()),\\n                $lt: new Date($('.js-search-endTime').val())\\n            }\\n        }, updateTable);\\n    }\\n    // console.log(\\\"02\\\");\\n});\\n\\n//----------------------------------------------------------------------\\n\\n$('.js-delete').click(function() {\\n    $('.thread').html(\\\"\\\");\\n    // console.log(\\\"01\\\");\\n    if ($('.js-delete-category').val() == \\\"全部\\\") {\\n        billing.remove({\\n            date: {\\n                $gte: new Date($('.js-delete-startTime').val()),\\n                $lt: new Date($('.js-delete-endTime').val())\\n            }\\n        }, updateTable);\\n    }\\n    if ($('.js-delete-category').val() == \\\"食物(食)\\\") {\\n        billing.remove({\\n            category: \\\"食物(食)\\\",\\n            date: {\\n                $gte: new Date($('.js-delete-startTime').val()),\\n                $lt: new Date($('.js-delete-endTime').val())\\n            }\\n        }, updateTable);\\n    }\\n    if ($('.js-delete-category').val() == \\\"衣服(衣)\\\") {\\n        billing.remove({\\n            category: \\\"衣服(衣)\\\",\\n            date: {\\n                $gte: new Date($('.js-delete-startTime').val()),\\n                $lt: new Date($('.js-delete-endTime').val())\\n            }\\n        }, updateTable);\\n    }\\n    if ($('.js-delete-category').val() == \\\"房屋(住)\\\") {\\n        billing.remove({\\n            category: \\\"房屋(住)\\\",\\n            date: {\\n                $gte: new Date($('.js-delete-startTime').val()),\\n                $lt: new Date($('.js-delete-endTime').val())\\n            }\\n        }, updateTable);\\n    }\\n    if ($('.js-delete-category').val() == \\\"交通(行)\\\") {\\n        billing.remove({\\n            category: \\\"交通(行)\\\",\\n            date: {\\n                $gte: new Date($('.js-delete-startTime').val()),\\n                $lt: new Date($('.js-delete-endTime').val())\\n            }\\n        }, updateTable);\\n    }\\n    if ($('.js-delete-category').val() == \\\"教育(育)\\\") {\\n        billing.remove({\\n            category: \\\"教育(育)\\\",\\n            date: {\\n                $gte: new Date($('.js-delete-startTime').val()),\\n                $lt: new Date($('.js-delete-endTime').val())\\n            }\\n        }, updateTable);\\n    }\\n    if ($('.js-delete-category').val() == \\\"娛樂(樂)\\\") {\\n        billing.remove({\\n            category: \\\"娛樂(樂)\\\",\\n            date: {\\n                $gte: new Date($('.js-delete-startTime').val()),\\n                $lt: new Date($('.js-delete-endTime').val())\\n            }\\n        }, updateTable);\\n    }\\n    if ($('.js-delete-category').val() == \\\"其他\\\") {\\n        billing.remove({\\n            category: \\\"其他\\\",\\n            date: {\\n                $gte: new Date($('.js-delete-startTime').val()),\\n                $lt: new Date($('.js-delete-endTime').val())\\n            }\\n        }, updateTable);\\n    }\\n    // console.log(\\\"02\\\");\\n    addprice = 0;\\n    billing.find({}, updateTable);\\n});\\n\\n//-----------------------------------------------------------------------\\n\\nfunction updateTable(data) {\\n    // console.log(data);\\n    $('.thread').html(\\\"\\\");\\n    data1 = data;\\n    // console.log(data1);\\n    // console.log(data1.length);\\n    $('.js-times').text(\\\"筆數: \\\"+data1.length);\\n\\n    totalprice = 0;\\n    for (var i = 0; i \u003c data1.length; i++) {\\n        addprice = data1[i].price;\\n        addprice = parseInt(addprice);\\n        totalprice += addprice;\\n    }\\n\\n\\n    $('.js-total').text(\\\"總和: \\\"+totalprice);\\n\\n    for (var e = 0; e \u003c data1.length; e++) {\\n        // console.log(\\\"yes\\\");\\n        category = data1[e].category;\\n        // console.log(category);\\n        description = data1[e].description;\\n        price = data1[e].price;\\n        date = data1[e].date;\\n\\n        date = date.slice(0, 10);\\n        // console.log(date);\\n\\n        $('.thread').append(\\\"\u003ctr\u003e\u003c/tr\u003e\\\");\\n        $('.thread').append(\\\"\u003ctd\u003e\\\"+date+\\\"\u003c/td\u003e\\\");\\n        $('.thread').append(\\\"\u003ctd\u003e\\\"+category+\\\"\u003c/td\u003e\\\");\\n        $('.thread').append(\\\"\u003ctd\u003e\\\"+description+\\\"\u003c/td\u003e\\\");\\n        $('.thread').append(\\\"\u003ctd\u003e\\\"+price+\\\"\u003c/td\u003e\\\");\\n        $('.thread').append(\\\"\u003ctr\u003e\u003c/tr\u003e\\\");\\n\\n        price = 0;\\n    }\\n}\"}","created_at":"2018-09-08T18:43:09.946+08:00","updated_at":"2019-11-03T07:34:23.409+08:00","name":"我的記帳小本本","language":"web","screenshot":{"url":"https://cdn6.koding.school/uploads/project/screenshot/41833/5d85545ae7020f3c18da47bed27d4746.jpg"},"parent_id":23181,"plugin":"","description":null,"note":null,"status":"public","like_student_ids":[],"is_featured":false,"views":120,"hashid":"meysvkdw","is_content_changed":false,"review_status":"unsubmitted","submitted_at":null,"reviewed_at":null,"advise":null,"is_deleted":false}