Python-S9—Day86-ORM项目实战之会议室预定相关

• 01 会议室预定1

• 02 会议室预定2

• 03 会议室预定3

• 04 会议室预定4

• 05 会议室预定5

• 06 会议室预定6

01 会议室预定1

 1.1 项目的架构目录；

1.2 使用Pycharm创建Django项目：MRBS并建立引用app01（Django版本指向全局解释器，为Django =“1.11.1”）

1.3 settings.py中配置STATICFILES_DIRS以及AUTH_USER_DIRS

AUTH_USER_MODEL = "app01.UserInfo"
STATICFILES_DIRS = [
    os.path.join(BASE_DIR, 'static'),
]

1.4 models.py中配置ORM并在admin.py中进行注册；

from django.db import models

# Create your models here.
from django.db import models
from django.contrib.auth.models import AbstractUser


class UserInfo(AbstractUser):
    tel = models.CharField(max_length=32)


class Room(models.Model):
    """
    会议室表;
    """
    caption = models.CharField(max_length=32)
    num = models.IntegerField()  # 容纳的人数;

    def __str__(self):
        return self.caption


class Book(models.Model):
    """
    会议室预定信息;
    """
    user = models.ForeignKey("UserInfo", on_delete=models.CASCADE)  # 级联删除;
    room = models.ForeignKey("Room", on_delete=models.CASCADE)
    date = models.DateField()
    time_choices = (
        (1, "8:00"),
        (2, "9:00"),
        (3, "10:00"),
        (4, "11:00"),
        (5, "12:00"),
        (6, "13:00"),
        (7, "14:00"),
        (8, "15:00"),
        (9, "16:00"),
        (10, "17:00"),
        (11, "18:00"),
        (12, "19:00"),
        (13, "20:00"),
    )
    time_id = models.IntegerField(choices=time_choices)  #

    class Meta:
        unique_together = (
            ('room', 'date', 'time_id')
        )  # 联合唯一！

    def __str__(self):
        return str(self.user) + "预定了" + str(self.room)

1.5 配置urls.py;

"""MRBS URL Configuration

The `urlpatterns` list routes URLs to views. For more information please see:
    https://docs.djangoproject.com/en/1.11/topics/http/urls/
Examples:
Function views
    1. Add an import:  from my_app import views
    2. Add a URL to urlpatterns:  url(r'^$', views.home, name='home')
Class-based views
    1. Add an import:  from other_app.views import Home
    2. Add a URL to urlpatterns:  url(r'^$', Home.as_view(), name='home')
Including another URLconf
    1. Import the include() function: from django.conf.urls import url, include
    2. Add a URL to urlpatterns:  url(r'^blog/', include('blog.urls'))
"""
from django.conf.urls import url
from django.contrib import admin
from app01 import views

urlpatterns = [
    url(r'^admin/', admin.site.urls),
    url(r'^login/', views.login),
    url(r'^index/', views.index),
]

1.6 编写views.py视图函数；

from django.shortcuts import render, redirect

# Create your views here.
from django.contrib import auth
from .models import *
import datetime


def login(request):
    if request.method == "POST":
        user = request.POST.get('user')
        pwd = request.POST.get('pwd')
        user = auth.authenticate(username=user, password=pwd)
        if user:
            auth.login(request, user)  # request.user
            return redirect("/index/")
    return render(request, "login.html")


def index(request):
    date = datetime.datetime.now().date()
    book_date = request.GET.get("book_date", date)
    time_choices = Book.time_choices
    room_list = Room.objects.all()
    book_list = Book.objects.filter(date=book_date)

    htmls = ""
    for room in room_list:
        htmls += "<tr><td>{}({})</td>".format(room.caption, room.num)
        for time_choice in time_choices:
            flag = False
            for book in book_list:
                if book.room.pk == room.pk and book.time_id == time_choice[0]:
                    flag = True
                    break  # 意味着这个单元格已经被预定;
            if flag:
                if request.user.pk == book.user.pk:
                    htmls += "<td class = 'active' room_id={} time_id={} >{}</td>".format(room.pk, time_choice[0],
                                                                                          book.user)
                else:
                    htmls += "<td class = 'another_active' room_id={} time_id={} >{}</td>".format(room.pk,
                                                                                                  time_choice[0],
                                                                                                  book.user)
            else:
                htmls += "<td room_id={} time_id={} ></td>".format(room.pk, time_choice[0],
                                                                   )
        htmls += "</tr>"

    print(htmls)
    return render(request, "index.html", locals())

1.7 编写templates；

index.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Index</title>
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link rel="stylesheet" href="/static/bootstrap/css/bootstrap.css">
    <script src="/static/js/jquery-1.12.4.min.js"></script>
    <script src="/static/datetimepicker/bootstrap-datetimepicker.min.js"></script>
    <script src="/static/datetimepicker/bootstrap-datetimepicker.zh-CN.js"></script>
    <style>
        .active {
            background-color: green !important;
            color: white;
        }

        .another_active {
            background-color: #2b669a;
            color: white;
        }

        .td_active {
            background-color: lightblue;
            color: white;
        }
    </style>
</head>
<body>
<h3>会议室预定</h3>
<table class="table table-bordered table-striped">
    <thead>
    <tr>
        <th>会议室/时间</th>
        {% for time_choice in time_choices %}
            <th>{{ time_choice.1 }}</th>
        {% endfor %}
    </tr>

    </thead>
    <tbody>
    {{ htmls|safe }}
    </tbody>
</table>
</body>
</html>

1.8 创建static目录并添加jquery、Bootstrap以及datetimerpicker；

1.9 基本的页面展示如下：

 

02 会议室预定2

 

03 会议室预定3

 

 

04 会议室预定4

 

05 会议室预定5

 

06 会议室预定6