180 likes | 403 Vues
行街 喇. Crowdsourcing Shopping Website with Incentives. Hung Chun Ka 2011550385 See Kwan Hon Brian 2011580794 Wong Kin Chung 2011503813. 行街 喇. Introduction. Web 2.0 Crowdsourcing. 行街 喇. Project Scope. Focus on shopping Obtain shop information
E N D
行街喇 Crowdsourcing Shopping Website with Incentives Hung Chun Ka 2011550385 See Kwan Hon Brian 2011580794 Wong Kin Chung 2011503813
行街喇 Introduction • Web 2.0 • Crowdsourcing
行街喇 Project Scope • Focus on shopping • Obtain shop information • Share shopping experience • Discuss
行街喇 Key Elements • User • Normal user • Shop user • Site administrator • Shop • Added by normal users • Created by shop users • Company • Created by shop users • Mall • Collection of shops
行街喇 Crowdsourcing Features • Add new shops • Change shop information • Provide discount / promotion information • Provide featured products • Upload shop / product images • Report inappropriate contents
行街喇 Social Interactions • In site discussion • Share • Like • Pin • Further discussion on external site
行街喇 Technical Aspects
行街喇 Technical Aspects • Webserver: Apache 2 • Database: MySQL 5.6 • Server-side language: PHP • Symfony 2 • Twig • YAML • Client-side language: HTML, JavaScript
行街喇 Database Design • Finite number of tables & columns • Infinite number of data for shops, users… • Goal: • Allow adding more information WITHOUT modifications to the database structure (avoid dangerous schema update) • Web manageable interface for Administrators and Shop Staff
行街喇 Database Design • Shop Name • Image • Address • District • Category • Phone • Opening Hours • …. • What do to when adding more information to the shop? Shop
行街喇 Database Design Attribute Attribute User • Shop Name • Image • Address • District • Category • Phone • Opening Hours • Login ID • Password • Nickname • Profile Picture Shop Attribute Set
行街喇 Database Design AttributeSet AttributeSetAttribute Attribute
行街喇 Database Design ShopAttributeValue Attribute
行街喇 Future Plans
行街喇 Features to be Implemented • User • Follow other users / shops • Coupons for good reviews • Custom user page
行街喇 Features to be Implemented • Shop / Mall • Ranking • Location • Discount / promotion
行街喇 Features to be Implemented • Administration • Validate company information • Manage site content • Inappropriate content removal • Updating old information • Manage user accounts • Role assignment • Suspension
行街喇 - The End -