資料庫 DEMO | 程式專案 | 橘蘋學習平台

{"id":18832,"student_id":70,"content":"{\"html\":\"\u003c!DOCTYPE html\u003e\\n\u003chtml\u003e\\n\u003chead\u003e\\n\\t\u003ctitle\u003eDocument\u003c/title\u003e\\n    \u003cscript src=\\\"https://code.jquery.com/jquery-3.2.1.min.js\\\" integrity=\\\"sha256-hwg4gsxgFZhOsEEamdOYGBf13FyQuiTwlAQgxVSNgt4=\\\" crossorigin=\\\"anonymous\\\"\u003e\u003c/script\u003e\\n\u003c/head\u003e\\n\u003cbody\u003e\\n    \u003ctable\u003e\\n        \u003cthead\u003e\\n            \u003ctr\u003e\\n                \u003cth\u003e物品\u003c/th\u003e\\n                \u003cth\u003e所屬人\u003c/th\u003e\\n            \u003c/tr\u003e\\n        \u003c/thead\u003e\\n        \u003ctbody id=\\\"yolo\\\"\u003e\\n        \u003c/tbody\u003e\\n    \u003c/table\u003e\\n    \u003cbutton id=\\\"button\\\"\u003e抽獎\u003c/button\u003e\\n\u003c/body\u003e\\n\u003c/html\u003e\",\"css\":\"\",\"js\":\"var itemsTable = DB.table(\\\"souvenirs\\\"),\\n    ownersTable = DB.table(\\\"owners\\\");\\n\\nitemsTable.find({},function(items){\\n    if(items.length==0){\\n        itemsTable.insert({name:\\\"小酒1\\\",belongsTo:\\\"\\\"});\\n        itemsTable.insert({name:\\\"小酒2\\\",belongsTo:\\\"\\\"});\\n        itemsTable.insert({name:\\\"小酒3\\\",belongsTo:\\\"\\\"});\\n        itemsTable.insert({name:\\\"小酒4\\\",belongsTo:\\\"\\\"});\\n        itemsTable.insert({name:\\\"小酒5\\\",belongsTo:\\\"\\\"});\\n        itemsTable.insert({name:\\\"某種豆子\\\",belongsTo:\\\"\\\"});\\n        itemsTable.insert({name:\\\"金楚糕\\\",belongsTo:\\\"\\\"});\\n        itemsTable.insert({name:\\\"紅芋巧克力\\\",belongsTo:\\\"\\\"});\\n        ownersTable.remove();\\n    }\\n});\\nalert(\\\"Hello \\\"+USER_NAME);\\n\\nrefreshTable();\\n\\n$(\\\"#button\\\").click(function(){\\n    $(this).attr('disabled', true);\\n})\\n\\nfunction refreshTable(){\\n    $(\\\"#yolo\\\").html(\\\"\\\");\\n    itemsTable.find({},function(items){\\n        for(var i=0; i\u003citems.length; i++){\\n            $(\\\"#yolo\\\").append(\\\"\u003ctr\u003e\u003ctd\u003e\\\"+items[i].name+\\\"\u003c/td\u003e\u003ctd\u003e\\\"+items[i].belongsTo+\\\"\u003c/td\u003e\u003c/tr\u003e\\\")\\n        }\\n    });\\n}\\n\\nfunction draw(){\\n    ownersTable.find({},function(owners){\\n        var itemIds = [];\\n        owners.forEach(function(owner){\\n            itemIds.push(owner.itemId);\\n        });\\n        itemsTable.find({_id:{$nin:itemIds}},function(items){\\n            var item = items[Math.floor(Math.random()*items.length)];\\n            ownersTable.insert(\\n                {\\n                    name: USER_NAME,\\n                    itemId: item._id\\n                },\\n                function(){\\n                    \\n                }\\n            );\\n        });\\n    });\\n    itemsTable.find({belongsTo:\\\"\\\"},function(items){\\n        var item = items[Math.floor(Math.random()*items.length)];\\n        itemsTable.update({name:item.name},{belongsTo:USER_NAME},function(){\\n            refreshTable();\\n            alert(\\\"恭喜你抽到：\\\"+item.name);\\n        });\\n    });\\n\\n}\"}","created_at":"2018-01-02T11:50:19.023+08:00","updated_at":"2019-11-12T06:31:47.106+08:00","name":"資料庫 DEMO","language":"web","screenshot":{"url":"https://cdn9.koding.school/uploads/project/screenshot/18832/9ecb256dab78c2b7dbdfb5dcfdefe365.jpg"},"parent_id":null,"plugin":"","description":null,"note":null,"status":"public","like_student_ids":[],"is_featured":false,"views":353,"hashid":"gk4spg34","is_content_changed":false,"review_status":"unsubmitted","submitted_at":null,"reviewed_at":null,"advise":null,"is_deleted":false}