고객 정보 찾기 예제

 

예제 설명 및 예시

고객 정보는 데이터 베이스에 입력된 상황에서 진행한다

성별에 따라 남자 이미지 또는 여자 이미지 출력    <== 이미지는 각자 알아서 구하시오

근무년수 : 8년

평점 : 최우수         <== jikwon_rating으로 a: 최우수    b:우수   c: 일반 으로 출력

 

 

settings.py

"""
Django settings for test_test project.

Generated by 'django-admin startproject' using Django 4.1.2.

For more information on this file, see
https://docs.djangoproject.com/en/4.1/topics/settings/

For the full list of settings and their values, see
https://docs.djangoproject.com/en/4.1/ref/settings/
"""

from pathlib import Path

# Build paths inside the project like this: BASE_DIR / 'subdir'.
BASE_DIR = Path(__file__).resolve().parent.parent


# Quick-start development settings - unsuitable for production
# See https://docs.djangoproject.com/en/4.1/howto/deployment/checklist/

# SECURITY WARNING: keep the secret key used in production secret!
SECRET_KEY = "django-insecure-1&&!1lqpmk(^o$b+e%zr_=#rjx&w59di0!l+gchfp8tco%&1&%"

# SECURITY WARNING: don't run with debug turned on in production!
DEBUG = True

ALLOWED_HOSTS = []


# Application definition

INSTALLED_APPS = [
    "django.contrib.admin",
    "django.contrib.auth",
    "django.contrib.contenttypes",
    "django.contrib.sessions",
    "django.contrib.messages",
    "django.contrib.staticfiles",
    "myapp",
]

MIDDLEWARE = [
    "django.middleware.security.SecurityMiddleware",
    "django.contrib.sessions.middleware.SessionMiddleware",
    "django.middleware.common.CommonMiddleware",
    "django.middleware.csrf.CsrfViewMiddleware",
    "django.contrib.auth.middleware.AuthenticationMiddleware",
    "django.contrib.messages.middleware.MessageMiddleware",
    "django.middleware.clickjacking.XFrameOptionsMiddleware",
]

ROOT_URLCONF = "test_test.urls"

TEMPLATES = [
    {
        "BACKEND": "django.template.backends.django.DjangoTemplates",
        "DIRS": [],
        "APP_DIRS": True,
        "OPTIONS": {
            "context_processors": [
                "django.template.context_processors.debug",
                "django.template.context_processors.request",
                "django.contrib.auth.context_processors.auth",
                "django.contrib.messages.context_processors.messages",
            ],
        },
    },
]

WSGI_APPLICATION = "test_test.wsgi.application"


# Database
# https://docs.djangoproject.com/en/4.1/ref/settings/#databases

DATABASES = { #리모트(원격) 디비를 걸어놓았다 
    'default': {
        'ENGINE': 'django.db.backends.mysql', 
        'NAME': 'test',                #<--- DB명 : db는 미리 작성되어 있어야 함.       
        'USER': 'root',                #<--- 계정명 
        'PASSWORD': '123',            #<--- 계정 암호           
        'HOST': '127.0.0.1',          #<--- DB가 설치된 컴의 ip          
        'PORT': '3306',               #<--- DBMS의 port 번호     
    }
}


# Password validation
# https://docs.djangoproject.com/en/4.1/ref/settings/#auth-password-validators

AUTH_PASSWORD_VALIDATORS = [
    {
        "NAME": "django.contrib.auth.password_validation.UserAttributeSimilarityValidator",
    },
    {"NAME": "django.contrib.auth.password_validation.MinimumLengthValidator",},
    {"NAME": "django.contrib.auth.password_validation.CommonPasswordValidator",},
    {"NAME": "django.contrib.auth.password_validation.NumericPasswordValidator",},
]


# Internationalization
# https://docs.djangoproject.com/en/4.1/topics/i18n/

LANGUAGE_CODE = "en-us"

TIME_ZONE = "UTC"

USE_I18N = True

USE_TZ = True


# Static files (CSS, JavaScript, Images)
# https://docs.djangoproject.com/en/4.1/howto/static-files/

STATIC_URL = "static/"

# Default primary key field type
# https://docs.djangoproject.com/en/4.1/ref/settings/#default-auto-field

DEFAULT_AUTO_FIELD = "django.db.models.BigAutoField"

 

 

models.py

from django.db import models

# Create your models here.
class Gogek(models.Model):
    gogek_no = models.IntegerField(primary_key=True)
    gogek_name = models.CharField(max_length=10)
    gogek_tel = models.CharField(max_length=20, blank=True, null=True)
    gogek_jumin = models.CharField(max_length=14, blank=True, null=True)
    gogek_damsano = models.ForeignKey('Jikwon', models.DO_NOTHING, db_column='gogek_damsano', blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'gogek'
        
class Jikwon(models.Model):
    jikwon_no = models.IntegerField(primary_key=True)
    jikwon_name = models.CharField(max_length=10)
    buser_num = models.CharField(max_length=20)
    jikwon_jik = models.CharField(max_length=10, blank=True, null=True)
    jikwon_pay = models.IntegerField(blank=True, null=True)
    jikwon_ibsail = models.DateField(blank=True, null=True)
    jikwon_gen = models.CharField(max_length=4, blank=True, null=True)
    jikwon_rating = models.CharField(max_length=3, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'jikwon'
        
class Buser(models.Model):
    buser_no = models.IntegerField(primary_key=True)
    buser_name = models.CharField(max_length=10)
    buser_loc = models.CharField(max_length=10, blank=True, null=True)
    buser_tel = models.CharField(max_length=15, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'buser'

 

 

urls.py

from django.contrib import admin
from django.urls import path
from myapp import views

urlpatterns = [
    path("admin/", admin.site.urls),
    
    path("", views.main),  
    path("show", views.show), 
]

 

 

views.py

from django.shortcuts import render
from myapp.models import Gogek, Jikwon, Buser
import datetime

# Create your views here.

def main(request):
    return render(request, "main.html")

def show(request):
    try:
        name = request.POST.get('name')
        tel = request.POST.get('tel')
    
        gogekdata = Gogek.objects.select_related('gogek_damsano').get(gogek_name=name, gogek_tel=tel)
        joindata = gogekdata.gogek_damsano    
        buserdata = Buser.objects.get(buser_no=joindata.buser_num)
        
        # 근무 년수 구하기 
        workdays = datetime.date.today() - joindata.jikwon_ibsail
        workyears = workdays.days // 365
        
        return render(request, "show.html", {'joindata':joindata, 'buserdata':buserdata, 'workyears':workyears})
    except Exception as e:
        return render(request, "error.html")

 

 

main.html

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script type="text/javascript">
window.onload=function(){
       document.querySelector("#btnResult").onclick=chkFunc;
    }
    function chkFunc(){
       if(frm.name.value === ""){
          alert('작성자를 입력하세요');
          frm.name.focus();
          return; 
       }else if(frm.tel.value === ""){
           alert('전화번호를 입력하세요');
           frm.tel.focus();
           return; 
       }
    frm.submit();
    }
</script>
</head>
<body>
<form action="/show" name="frm" method="post"> {% csrf_token %}
<h2>고객 정보 입력</h2>
고객명 : <input type="text" name="name"/>
고객전화 : <input type="text" name="tel"/>
<input type="button" value="확인" id="btnResult">
</form>
</body>
</html>

 

 

 

error.html

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
	에러입니다
</body>
</html>

 

 

show.html

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<h1>담당직원</h1>
<table style="width:50%" border=1>
<tr>
<td rowspan="2" style=>
{% if jd.jikwon_gen == "남"  %}
<img style="height:100px;" src="/static/images/man.png">
{% else %}
<img style="height:100px;" src="/static/images/woman.png">
{% endif %}
</td>

<td>직원명</td><td>{{joindata.jikwon_name}}</td><td>직급</td><td>{{joindata.jikwon_jik}}</td></tr>
<tr><td>부서명</td><td>{{buserdata.buser_name}}</td><td>부서전화</td><td>{{buserdata.buser_tel}}</td></tr>
<tr><td>근무년수</td><td colspan="2">{{workyears}}년</td><td>평점</td>
{% if joindata.jikwon_rating == "a" %}
<td>최우수</td>
{% elif joindata.jikwon_rating == "b" %}
<td>우수</td>
{% else %}
<td>일반</td>
{% endif %}
</tr>
</table>
</body>
</html>