驴行旅游系统

（Donkey Kong Travelling System）


1. 简介(Overview)


简介：驴行网(Donkey Kong，以下简称驴行)是一家优秀的的旅游网站，帮助旅行者发现每次旅行中的更多精彩。该网站向用户提供根据旅游信息和相关预定服务（包括各城市景点、酒店、美食、旅行者游记等），提供超过650万个住宿、景点和餐厅信息，汇集众智帮助旅行者选择吃住玩乐。通过该平台，用户可查看各城市热门景点信息，搜索酒店、餐厅等信息，注册后可通过该平台预定酒店和餐厅，此外，用户在旅行期间或旅行结束后可随时发布旅游游记，和所有旅游爱好者共享旅游体验和旅游指南，认识更多朋友，另外用户也可通过该平台召集小组游，集结拥有相同爱好的旅游爱好者一起组团旅游。

Introduction: Donkey Kong Website is one of the most excellent travelling websites that helps travelers to explore more and discover more in each trip. The website provides users with travelling information (such as information about scenic spots, hotels, food restaurants, traveller notes, etc.) and concerned reservation services. Users are able to search and view details of popular scenic spots, hotels, restaurants through the platform, and then make reservations for hotels and restaurants after registration. Besides, users are free to post travelling notes at any time during or after a trip so as to share their travelling experience with other people sharing the same interests, give them guidance and make more friends, moreover, a user can also launch a group travelling to call on people with the same interests to travel as a group.

2. 项目技术选型(Project Skill Combo)

· Database & Web Application: PHP + MySQL

· Development IDE: Net Beans / Dream Weaver [Free to choose]

· Front End: HTML-5 / Java Script/ jQuery

· UI Framework: Bootstrap

· Cross Platform Application: jQuery Mobile


n 在某些查询中添加数据分页功能

Add the data paging functionality in some of the queries

n 请在所有需要发送异步请求的功能里使用Ajax

Use Ajax anywhere where a asynchronous request is needed

在景点页面通过Web 服务显示当前城市的天气信息。

Show weather information about the current city through using web services.

3. 数据字典设计(参考示例)

Data Dictionary Design(Example for Reference)


表(User-用户表)

字段名称

Field Name

数据类型

DATA TYPE

是否为空

IS NULL

默认值

DEFAULT VALUE

说明

Description

备注

Remark

USER_ID

VARCHAR(50)

否

用户id

PK，大小写英文和数字

PASS_WORD

VARCHAR(50)

否

密码

MD5加密



该表只是一个格式,具体数据库表格自行设计，请将所有的表设计写入一个excel表

Here is just a format for reference, please complete database table design on your own, and put them all in one excel file.

4. 功能需求（Functionality Requirements）：

提供登录表单，允许用户以不同身份（管理员或学员）登录，登录后转到不同页面执行不同操作。

There must be a login form that allows a user to log in either as a student or as an administrator, and redirect the user to either a student page or an administrator page correspondingly, thus handling different operations.

1. 管理员登录后可进行如下操作(Administrator Functionality)：

i. 修改管理员密码

Change administrator password

ii. 管理注册用户，可对注册用户进行增删改查和禁用，一旦禁用用户，用户需要向管理员发送通知或邮件请求账户解冻。

Manage registered users, including adding a new user, modify information of a user, delete a user, view details of a user, and disable a user. Once a user is disabled, the user needs to apply for account unfreezing through sending a message or an email to the administrator side.

iii. 管理景点、酒店、美食店信息，对这些信息进行增删改查。

Manage details about scenic spots, hotels, etc, and implement CRUD operations on the same.

iv. 审核组团游申请，管理员批准后，其他旅游爱好者才能参与该组团游活动。

Verify and approve applications for group travelling, users interested can not apply for one group traveling unless the activity gets verified and approved.

v. 删除游记功能，例如对用户举报的游记进行删除，并发送通知或邮件给发布游记的用户。

Delete travelling notes, for example, delete a note reported by other users, and send a notice or an email to the user who published that note.

vi. 查询功能（Search Requirement）


除非查询的数据为单条记录，否则请使用分页功能将查询结果分页

Please implement data paging for the result retrieved unless only a single record is retrieved

除非有特殊需求，查询数据尽量不要跳转页面，所以请使用Ajax发送异步请求在本页面进行局部刷新

Please send ajax requests for querying data and display result on the same page unless you have a need for displaying data on a different page

1) 按照关键字、城市检索美食店、景点、酒店信息，显示列表后可对每项信息进行修改、删除和查看详情，并可根据一些条件，如好评，对检索的结果列表进行排序。

Search for information about restaurants, scenic spots, hotels based on a keyword or a city, administrators are able to implement CRUD operations on the list retrieved, and sort the same based on some criteria such as rating of the hotels, restaurants or scenic sports in the result list.

2) 按照关键字、作者、发布日期、日期范围检索游记，并对检索出的游记进行查看、禁止浏览、删除等。并可根据作者、发布日期等进行排序。

Search for travelling notes based on such criteria as a keyword, an author, a publishing date, or a date range, and view details, disable or delete a note in the list. Result list can also be sorted based on author name or publishing date.

3) 按照用户ID、名称、等级（根据注册天数更新等级，等级自行定义）检索用户，向用户发送通知给指定用户以及删除指定用户等。

Search for a user or users based on user ID, or user name or rating of a user (Each team decides how to rate a user on your own, rating shall be updated based on the number of days passed after registration), administrators can also send notices to specified users or delete selected users.

4) 查询被举报的游记的信息，并对其进行处理，如发送通知或邮件给发布用户或直接删除游记。

Search for notes reported by users and deal with the same, such as sending a notice or an email to the user who published that note or deleting a note directly.

5) 查看被举报的用户的信息，并对其进行处理，比如暂时禁用其账号，并发送通知或邮件给用户。

View users reported by other users, and deal with the same, such as disabling a user or send a notice or a email to that user.

6） 查看组团游申请，并对列表中显示的每个申请进行处理，如批准或不批准，并发送通知或邮件给发起人用户。

View applications for group travelling, and implement operations on each application, such as approving or disapproving, and send a notice or email to the user who launched the activity.

vii. 退出登录

Log out

2. 用户可进行如下操作(Student Functionality)：

i. 根据关键字检索酒店、美食店、景点、游记的信息以及对酒店、美食店、景点、游记等点赞或取消点赞、查看评论、发布评论和删除评论，检索的列表可根据一些条件进行排序查看，如游记按照发布日期和点赞数进行排序，酒店可根据价格等排序，美食店可根据好评、类型等排序，景点可根据等级和点赞数量等进行排序等，所有的检索都可根据点赞数进行排序。并可预订酒店和接受预订的美食店

Search for hotels, restaurants, scenic spots by entering a keyword, implement such operations as liking or disliking an item, view details, publish comments or delete your own comments for an item, the result list can be sorted based on some criteria, such as sorting notes by publish date, sorting hotels by price, sorting restaurants by rating or type, sorting scenic sports by rating, etc, all kinds of search can be sorted by the number of likes. And then a user can reserve hotels or restaurants.

ii. 注册成为正式用户，并进行登录

Register as a normal user, and log in thereafter

iii. 查看和修改个人信息（等级信息不可更改，等级根据成为用户天数自动更新）及密码

View personal profile and modify the same, including updating personal information and password, the rating information of a user is not allowed to be modified and should be updated automatically according to the number of days passed after registration.

iv. 发布、修改和删除游记

Publish, modify and delete a travelling note.

v. 举报包含不当言论的游记或行为不当的用户

Report a user who behaves improperly or a travelling note that contains illegal contents to the administrators.

vi. 申请组团游，列出团游标题、景点、时间长短、费用、人数限制、出行方式、入住酒店、截止日期等。发布后可查看和更新申请状态，并可在其他用户申请后查看申请用户列表，用户在团泳结束后可对本次体验进行点评和删除评论. 只有管理员审核通过该申请后，其他用户才可申请加入团游。

Launch a group travelling by providing such details as title, scenic spot, duration, budget, number limited for participants, transporting tool, hotel to check in, deadline, etc. The user who publishes an application can view or update the status of the application and check the list of applicants, and people involved in the activity is allowed to comment on the trip and delete their comments if they want, please note that a trip can not be applied for by other users unless the application gets approved by the administrator side.

vii. 退出登录

Log out

3. 首页要求（Home page requirements）

i. 首页提供导航菜单，方便用户到不同页面查看和检索不同类型的信息，如酒店、景点、美食、游记、组团游。

The homepage shall provide a navigation menu that guides the users to different pages and makes it convenient for users to search for different information, such as hotels, scenic spots, food restaurants, notes and group travelling activities.

ii. 首页提供用户登录和注册的链接

Provide users links for logging and registration on the home page.

iii. 首页提供用户检索功能，方便用户根据关键字检索景点、美食店和酒店检索

Provide users with the functionality of searching for information by entering a keyword on the home page.

iv. 首页显示几个最热门旅游城市和各城市至少6个最热门景点的链接

Show at least 6 hot scenic spots of several hot travelling cities on the home page.

v. 首页显示热门游记的链接

Show links of the top several travelling notes on the home page.

vi. 景点页面显示当前定位的城市，以及热门城市和对应城市的景点推荐，首先显示当前城市的热门景点推荐和景点搜索功能

Show the city of the current location on the scenic spot page, and list  recommended or hot scenic spots from the several hottest cities, the first city should be the current city where a user stays.

vii. 美食页面显示当前定位的城市，并显示当前城市的热门小吃或店家推荐，以及其他热门城市的美食推荐

Show the city of the current location on the food page, list the most popular food or restaurants of the current city, and also food recommendations of other cities.

viii. 游记页面显示热门游记，并提供基于关键字的游记检索以及基于指定条件对游记列表排序，如按照评价数量、好评、发布时间等

Show some of the most popular or best rated travelling notes on the note page, and provide users with the functionality of sorting notes based on some criteria, such as the number of comments or likes, date of publish, etc.

5. 备注：可自行添加其他扩展功能

Remark: Students can add on to the project by implementing more extra functionality.


案例CS&Finance|建模|代码|系统|报告|考试

编程类：C++,JAVA ,数据库,WEB,Linux,Nodejs,JSP,Html,Prolog,Python,Haskell,hadoop算法,系统 机器学习

金融类：统计，计量，风险投资，金融工程，R语言，Python语言，Matlab，建立模型，数据分析，数据处理

服务类：Lab/Assignment/Project/Course/Qzui/Midterm/Final/Exam/Test帮助案例代考辅导

CSGHOSTWRITING,案例CS,案例finance,案例statistics,考试助攻

E-mail:850190831@qq.com   微信：csghostwriting  工作时间：无休息工作日-早上8点到凌晨3点


如果您用的手机请先保存二维码到手机里面，识别图中二维码。如果用电脑，直接掏出手机果断扫描。