python项目篇-酒店（会议室，电影）预定

最新推荐文章于 2024-08-03 12:22:30 发布

Twish

最新推荐文章于 2024-08-03 12:22:30 发布

阅读量2.4k

点赞数 1

分类专栏： Python Django 项目

本文链接：https://blog.csdn.net/qq_27695659/article/details/87799542

版权

Python 同时被 3 个专栏收录

283 篇文章 1 订阅

订阅专栏

Django

54 篇文章 0 订阅

订阅专栏

项目

35 篇文章 0 订阅

订阅专栏

1、views.py中

from django.shortcuts import render,redirect,HttpResponse

# Create your views here.

from django.contrib import auth


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")


from .models import *
import datetime
def index(request):
    date=datetime.datetime.now().date()
    book_date=request.GET.get("book_date",date)
    print("book_date",book_date)

    time_choices=Book.time_choices
    room_list=Room.objects.all()
    book_list=Book.objects.filter(date=book_date)
    print("time_choices",time_choices)


    htmls=""
    for room in room_list:
        htmls+="<tr><td>{}({})</td>".format(room.caption,room.num)

        for time_choice in time_choices:
            book=None
            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 item'  room_id={} time_id={}>{}</td>".format(room.pk, time_choice[0],book.user.username)
                else:
                     htmls += "<td class='another_active item'  room_id={} time_id={}>{}</td>".format(room.pk, time_choice[0],
                                                                                        book.user.username)
            else:
                 htmls+="<td room_id={} time_id={} class='item'></td>".format(room.pk,time_choice[0])

        htmls+="</tr>"




    # print(htmls)


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

import json


def book(request):

    # print("request.POST",request.POST)

    post_data=json.loads(request.POST.get("post_data")) # {"ADD":{"1":["5"],"2":["5","6"]},"DEL":{"3":["9","10"]}}
    # print("post_data", post_data)
    choose_date=request.POST.get("choose_date")

    res={"state":True,"msg":None}
    try:
        # 添加预定
        #post_data["ADD"] : {"1":["5"],"2":["5","6"]}

        book_list=[]
        for room_id,time_id_list in post_data["ADD"].items():

            for time_id in time_id_list:
                book_obj=Book(user=request.user,room_id=room_id,time_id=time_id,date=choose_date)
                book_list.append(book_obj)

        Book.objects.bulk_create(book_list)


        # 删除预定
        from django.db.models import Q
        # post_data["DEL"]: {"2":["2","3"]}

        # print("post_data['DEL']:", post_data["DEL"].items())
        remove_book = Q()
        for room_id,time_id_list in post_data["DEL"].items():

            temp = Q()
            for time_id in time_id_list:
                temp.children.append(("room_id",room_id))
                temp.children.append(("time_id",time_id))
                temp.children.append(("user_id",request.user.pk))
                temp.children.append(("date",choose_date))
                remove_book.add(temp,"OR")
        if remove_book:
             Book.objects.filter(remove_book).delete()



    except Exception as e:
        res["state"]=False
        res["msg"]=str(e)

    return HttpResponse(json.dumps(res))

2、HTML

<!DOCTYPE html>
<html lang="zh-CN">
<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>

<div class="calender pull-right">
      <div class='input-group' style="width: 230px;">
            <input type='text' class="form-control" id='datetimepicker11' placeholder="请选择日期"/>
            <span class="input-group-addon">
                <span class="glyphicon glyphicon-calendar">
                </span>
            </span>

      </div>
</div>

<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>
<button class="btn btn-success pull-right keep">保存</button>




<script>
    // 日期格式化方法
    Date.prototype.yuan = function (fmt) { //author: meizz
            var o = {
                "M+": this.getMonth() + 1, //月份
                "d+": this.getDate(), //日
                "h+": this.getHours(), //小时
                "m+": this.getMinutes(), //分
                "s+": this.getSeconds(), //秒
                "q+": Math.floor((this.getMonth() + 3) / 3), //季度
                "S": this.getMilliseconds() //毫秒
            };
            if (/(y+)/.test(fmt)) fmt = fmt.replace(RegExp.$1, (this.getFullYear() + "").substr(4 - RegExp.$1.length));
            for (var k in o)
                if (new RegExp("(" + k + ")").test(fmt)) fmt = fmt.replace(RegExp.$1, (RegExp.$1.length == 1) ? (o[k]) : (("00" + o[k]).substr(("" + o[k]).length)));
            return fmt;
        };

    var POST_DATA={
        "ADD":{},
        "DEL":{},

    };

    // 为td绑定单击事件

    function BindTd() {
        $(".item").click(function () {

             var room_id=$(this).attr("room_id");
             var time_id=$(this).attr("time_id");

             // 取消预定
             if($(this).hasClass("active")){
                $(this).removeClass("active").empty();

                 if(POST_DATA.DEL[room_id]){
                      POST_DATA.DEL[room_id].push(time_id)
                  }else {
                      POST_DATA.DEL[room_id]=[time_id,]
                     console.log(POST_DATA.DEL[room_id]=[time_id,])
                  }
             }
             // 临时取消预定
             else if ($(this).hasClass("td_active")){
                 $(this).removeClass("td_active");
                 POST_DATA.ADD[room_id].pop()

             }
             else{ // 添加预定
                  $(this).addClass("td_active");
                  if(POST_DATA.ADD[room_id]){
                      POST_DATA.ADD[room_id].push(time_id)
                  }else {
                      POST_DATA.ADD[room_id]=[time_id,]
                  }
             }
        })
    }
    BindTd();
    // 日期

     if (location.search.slice(11)){
           CHOOSE_DATE = location.search.slice(11)
          }
      else {
           CHOOSE_DATE = new Date().yuan('yyyy-MM-dd');
           }
    // 发送ajax

    $(".keep").click(function() {
        $.ajax({
            url:"/book/",
            type:"POST",
            data:{
                 choose_date:CHOOSE_DATE,
                 post_data:JSON.stringify(POST_DATA),
            },
            dataType:"json",
            success:function (data) {
                console.log(data)
                if(data.state){
                    // 预定成功
                    location.href=""
                }else {
                    alert("预定的房间已经被预定")
                    location.href=""
                }
        }
        })
    });
    // 日历插件

    $('#datetimepicker11').datetimepicker({
                minView: "month",
                language: "zh-CN",
                sideBySide: true,
                format: 'yyyy-mm-dd',
                startDate: new Date(),
                bootcssVer: 3,
                autoclose: true,
            }).on('changeDate', book_query);

     function book_query(e) {
         CHOOSE_DATE=e.date.yuan("yyyy-MM-dd");
         location.href="/index/?book_date="+CHOOSE_DATE;
     }
</script>


</body>
</html>

3、model.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)

里面用到一个日历插件datetimepicker

效果图
在这里插入图片描述