상세 컨텐츠

본문 제목

수정 화물 등 추가

카테고리 없음

by bumychoi 2024. 3. 28. 12:09

본문

from flask import Flask, render_template, request, url_for, abort, redirect, redirect
from bson.objectid import ObjectId
from pymongo import MongoClient
import math


client = MongoClient("")
db = client.d_bar

application = app = Flask(__name__)


@app.route("/", methods=["GET"])
def home():
    # 페이지 값(값이 없는 경우 기본값은 1)
    page = request.args.get("page", 1, type=int)
    #한페이지당 몇개의 게시물을 출력할지
    limit = request.args.get("limit", 10, type=int)

    search = request.args.get("search", -1, type=int)
    keyword = request.args.get("keyword",type=str)

    # 최종적으로 완성된 쿼리를 만들 변수
    query = {}

    # 검색어 상태를 추가할 리스트 변수
    search_list = []

    if search == 0:
        search_list.append({"date":{"$regex":keyword}})
    elif search == 1:
        search_list.append({"mv_name":{"$regex":keyword}})            
    elif search == 3:
        search_list.append({"port_name":{"$regex":keyword}})
    elif search == 4:
        search_list.append({"remark":{"$regex":keyword}})
   
    if len(search_list)>0:
        query={"$or":search_list}
   
    print(query)

    # 여기  중요  강의 다른부분  count_documents
    mv_list = list(db.mv.find({}).skip((page-1)*limit).limit(limit).sort({"date":-1}))
    tot_count = db.mv.count_documents({})
    # 마지막 페이지의 수
    last_page_num = math.ceil(tot_count / limit)
    # 페이지 블럭울 5개씩 표기
    block_size = 5
    # 현재블럭의 위치
    block_num = int((page - 1)/ block_size)
    # 블럭의 시작의 위치
    block_start = int((block_size * block_num )+ 1)
    #  블럭의 끝 위치
    block_last = math.ceil(block_start +(block_size) - 1)

    return render_template("home.html",
        lists=mv_list,
        limit=limit,
        page=page,
        block_start=block_start,
        block_last=block_last,
        last_page_num=last_page_num)


@app.route("/mv_create/", methods=["GET", "POST"])
def mv_create():
    if request.method == "GET":
        return render_template("mv_create.html")
    elif request.method == "POST":
        date = request.form["inport_date"]
        mv_name = request.form["mv_name"]
        port_name = request.form["port_name"]
        cago_name = request.form["cago_name"]
        agency_name = request.form["agency_name"]
        remark = request.form["remark"]
        doc = {
            "date": date,
            "mv_name": mv_name,
            "port_name": port_name,
            "cago_name":cago_name,
            "agency_name":agency_name,
            "remark": remark,
        }
        x = db.mv.insert_one(doc)
        return redirect(url_for("read", idx=x.inserted_id))


@app.route("/read/<idx>")
def read(idx):
    if idx is not None:
        data = db.mv.find_one({"_id": ObjectId(idx)})

        if data is not None:
            result = {
                "id": data.get("_id"),
                "date": data.get("date"),
                "mv_name": data.get("mv_name"),
                "port_name": data.get("port_name"),
                "cago_name":data.get("cago_name"),
                "agency_name":data.get("agency_name"),
                "remark": data.get("remark"),
            }
        return render_template("read.html", result=result)
    return abort(404)


@app.route("/update/<idx>", methods=["GET", "POST"])
def update(idx):
    if request.method == "GET":
        if id is not None:
            data = db.mv.find_one({"_id": ObjectId(idx)})
            if data is not None:
                result = {
                    "id": data.get("_id"),
                    "date": data.get("date"),
                    "mv_name": data.get("mv_name"),
                    "port_name": data.get("port_name"),
                    "cago_name":data.get("cago_name"),
                    "agency_name":data.get("agency_name"),
                    "remark": data.get("remark"),
                }
            return render_template("update.html", result=result,title="수정페이지")
    elif request.method == "POST":
        idx = ObjectId(idx)
        date = request.form["inport_date"]
        mv_name = request.form["mv_name"]
        port_name = request.form["port_name"]
        cago_name = request.form["cago_name"]
        agency_name = request.form["agency_name"]
        remark = request.form["remark"]

        db.mv.update_one(
            {"_id": idx},
            {
                "$set": {
                    "date": date,
                    "mv_name": mv_name,
                    "port_name": port_name,
                    "cago_name":cago_name,
                    "agency_name":agency_name,
                    "remark": remark,
                }
            },
        )
        return redirect(url_for("read", idx=idx,title="수정완료"))


@app.route("/delete/<idx>/", methods=["POST"])
def delete(idx):
    idx = ObjectId(idx)
    db.mv.delete_one({"_id": idx})
    return redirect("/")


if __name__ == "__main__":
    app.run()
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>{{title}}</title>
        integrity="sha384-4bw+/aepP/YC94hEpVNVgiZdgIC5+VKNBQNGCHeKRQN+PtmoHDEXuppvnDJzQIu9" crossorigin="anonymous">
        integrity="sha384-HwwvtgBNo3bZJJLYd8oVXjrBZt8cqVSpeBNS5n7C8IVInixGAoxmnlMuBnhbgrkm" crossorigin="anonymous">

            function search() {
                var v_search = document.getElementById("search").value;
                var v_keyword = document.getElementById("keyword").value;

                if (v_search == "" || v_keyword == "") {
                    return false;
                } else {
                    self.location.href = "{{url_for('home')}}?search=" + v_search + "&keyword=" + v_keyword;
                }
            }
        </script>
</head>

<body>
    <nav class="navbar navbar-expand-lg bg-body-tertiary">
        <div class="container-fluid">
            <a class="navbar-brand" href="/">MAIN</a>
            <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav"
                aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
                <span class="navbar-toggler-icon"></span>
            </button>
            <div class="collapse navbar-collapse" id="navbarNav">
                <ul class="navbar-nav">
                    <li class="nav-item">
                        <a class="nav-link active" aria-current="page" href="/mv_create/">본선등록</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="#">본선내역관리</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="#">화주관리</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link disabled" aria-disabled="true">화종관리</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link disabled" aria-disabled="true">인원관리</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link disabled" aria-disabled="true">장비관리</a>
                    </li>
                </ul>
            </div>
        </div>
    </nav>
    <div class="body">
        <table class="table table-striped table table-bordered">
            <thead class="table-primary">
                <tr>
                    <td>순 번</td>
                    <td>입 항 일</td>
                    <td>본 선 명</td>
                    <td>화   종</td>
                    <td>대 리 점</td>
                    <td>비 고</td>
                    <td>하 역 사</td>
                </tr>
                <hr>
            </thead>
            <tbody>
                {% for list in lists %}
                <tr>
                    <td>
                        <a href="{{url_for('read',idx=list._id)}}">
                            {{loop.index +(page -1)* limit}}
                        </a>
                    </td>
                    <td>
                        <a href="{{url_for('read',idx=list._id)}}">
                            {{list.date}}
                        </a>
                    </td>
                    <td>
                        <a href="{{url_for('read',idx=list._id)}}">
                            {{list.mv_name}}
                        </a>
                    </td>
                    <td>{{list.cago_name}}</td>
                    <td>{{list.agency_name}}</td>
                    <td>{{list.remark}}</td>
                    <td>{{list.port_name}}</td>
                </tr>
                {% endfor %}
            </tbody>

        </table>
        <nav aria-label="Page navigation example ">
            <ul class="pagination pagination justify-content-center">
                {% if block_start -1 >0 %}
                <li class="page-item"><a class="page-link" href="{{url_for('home',page=block_start  -1)}}">이전</a></li>
                {% endif %}

                {% for i in range(block_start, block_last +1) %}
                {% if i > last_page_num %}
                <li class="page-item"><a class="page-link pointer-events: none ">{{i}}</a></li>
                {% else %}
                {% if i == page %}
                <li class="page-item active" aria-current="page">
                    <span class="page-link">{{i}}</span>
                </li>
                {% else %}
                <li class="page-item"><a class="page-link pointer-events: none "
                        href="{{url_for('home',page=i)}}">{{i}}</a>
                </li>
                {% endif %}
                {% endif %}
                {% endfor %}
                {% if block_last < last_page_num %} <li class="page-item"><a class="page-link"
                        href="{{url_for('home',page=block_last +1)}}">다음</a></li>
                    {% endif %}
            </ul>
        </nav>
        <div class="pagination justify-content-center">
            <select name="search" id="search">
                <option value="">검색대상</option>
                <option value="0">입항일</option>
                <option value="1">본선명</option>
                <option value="2">하역사</option>
                <option value="3">비 고</option>
            </select>
            <input type="text" name="keyword" id="keyword">
            <input type="button" class="btn btn-info" value="검색" onclick="search()">
        </div>
</body>

</html>
<!DOCTYPE html>
<html lang="en">


<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>{{title}}</title>
        integrity="sha384-4bw+/aepP/YC94hEpVNVgiZdgIC5+VKNBQNGCHeKRQN+PtmoHDEXuppvnDJzQIu9" crossorigin="anonymous">
        integrity="sha384-HwwvtgBNo3bZJJLYd8oVXjrBZt8cqVSpeBNS5n7C8IVInixGAoxmnlMuBnhbgrkm"
        crossorigin="anonymous"></script>
</head>

<body>
    <a href="/"><button type="button" class="btn btn-primary">홈</button></a>
    <h1>본선내역</h1>
        <table class="table" style="border: 8px blue;" >
            <tbody>
                <tr>
                    <th>입항일</th>
                    <td>{{result.date}}</td>
                </tr>
                <tr>
                    <th>본선명</th>
                    <td>{{result.mv_name}}</td>
                </tr>
                <tr>
                    <th>하역사</th>
                    <td>{{result.port_name}}</td>
                </tr>
                <tr>
                    <th>화 종</th>
                    <td>{{result.cago_name}}</td>
                </tr>
                <tr>
                    <th>대리점</th>
                    <td>{{result.agency_name}}</td>
                </tr>
                <tr>
                    <th>비 고</th>
                    <td>{{result.remark}}</td>
                </tr>
            </tbody>
           
        </table>
       
        <a href="/update/{{result.id}}"><button type="button" class="btn btn-outline-danger">편집</button></a>
               
</body>

</html>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>{{title}}</title>
        integrity="sha384-4bw+/aepP/YC94hEpVNVgiZdgIC5+VKNBQNGCHeKRQN+PtmoHDEXuppvnDJzQIu9" crossorigin="anonymous">
        integrity="sha384-HwwvtgBNo3bZJJLYd8oVXjrBZt8cqVSpeBNS5n7C8IVInixGAoxmnlMuBnhbgrkm"
        crossorigin="anonymous"></script>
</head>

<body>
    <a href="/"><button type="button" class="btn btn-primary">홈</button></a>
    <h1>본선 등록</h1>
    <form action="/mv_create/" method="POST">
        <p><input class="form-control form-control-lg" type="date" name="inport_date" placeholder="입항일"></p>
        <p><input class="form-control" type="text" type="text" name="mv_name" placeholder="본선명"></p>
       
        <div class="input-group mb-3">
            <select class="form-select" id="inputGroupSelect02">
              <option selected>화물구분</option>
              <option value="잡화">잡화</option>
              <option value="철근">철근</option>
              <option value="빔선적">빔선적</option>
              <option value="중고차">중고차</option>
              <option value="벌크선적">벌크선적</option>
            </select>
          </div>
        <P><input class="form-control" type="text" type="text" name="port_name"  placeholder="하역사" value="동방"></p>
        <p><input class="form-control" type="text" type="text" name="agency_name"  placeholder="대리점"></p>
       
        <div class="form-floating"><textarea textarea class="form-control" placeholder="비  고" id="floatingTextarea2" style="height: 200px" name="remark"></textarea>
        <label for="floatingTextarea2">전달사항</label>    
        </div>
        <input type="submit" class="btn btn-primary" value="등록">
    </form>
    <hr>
    <br>
   
</body>

</html>
<!DOCTYPE html>
<html lang="en">


<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>{{title}}</title>
        integrity="sha384-4bw+/aepP/YC94hEpVNVgiZdgIC5+VKNBQNGCHeKRQN+PtmoHDEXuppvnDJzQIu9" crossorigin="anonymous">
        integrity="sha384-HwwvtgBNo3bZJJLYd8oVXjrBZt8cqVSpeBNS5n7C8IVInixGAoxmnlMuBnhbgrkm"
        crossorigin="anonymous"></script>
</head>

<body>
    <h1>{{title}}</h1>

    <form action="/update/{{result.id}}" method="POST">
        <p><input class="form-control form-control-lg" type="date" name="inport_date" placeholder="입항일" value="{{result.date}}"></p>
        <p><input class="form-control" type="text" type="text" name="mv_name" placeholder="본선명" value="{{result.mv_name}}"></p>
        <!-- <p><input class="form-control" type="text" type="text" name="mv_name" placeholder="본선명" value="{{result.cago_name}}"></p> -->
        <div class="input-group mb-3">
            <select class="form-select" id="inputGroupSelect02" name="cago_name" >
              <option value="잡화" {% if result.cago_name == "잡화" %} selected {% endif %}>잡화</option>
              <option value="철근" {% if result.cago_name == "철근" %} selected {% endif %}>철근</option>
              <option value="빔선적" {% if result.cago_name == "빔선적" %} selected {% endif %}>빔선적</option>
              <option value="중고차" {% if result.cago_name == "중고차" %} selected {% endif %}>중고차</option>
              <option value="벌크선적" {% if result.cago_name == "벌크선적" %} selected {% endif %}>벌크선적</option>
            </select>
          </div>
        <P><input class="form-control" type="text" type="text" name="port_name"  placeholder="하역사" value="{{result.port_name}}"></p>
        <p><input class="form-control" type="text" type="text" name="agency_name"  placeholder="대리점" value="{{result.agency_name}}"></p>
       
        <div class="form-floating"><textarea textarea class="form-control" placeholder="비  고" id="floatingTextarea2" style="height: 200px" name="remark">{{result.remark}}</textarea>
        <label for="floatingTextarea2">전달사항</label>    
        </div>
        <a href="/"><button type="button" class="btn btn-primary">홈</button></a>
        <input type="submit" class="btn btn-warning" value="수정">
    </form>
           
        </table>
        <br>
        <hr>
        <div class="d-grid gap-2 d-md-flex justify-content-md-end">
           
            <form action="/delete/{{result.id}}" method="POST"><input type="submit" class="btn btn-danger" value="삭제"></form>
        </div>
       
               
</body>

</html>

티스토리툴바