fdc4699b11a15f1a1b4e663R130">130 
+    # Generate the output filename with a timestamp
131 
+    timestamp = datetime.now().strftime("%Y%m%d_%H%M%S")
132 
+    output_path = f"{prefix_filename}_{timestamp}.xlsx"
133 
+    workbook.save(output_path)
134 
+
135 
+    return output_path
136 
+
137 
+if __name__ == "__main__":
138 
+    # Example usage
139 
+    data = {
140 
+        "customer": "Tum Coder",
141 
+        "inspect_date": "2025-01-15",
142 
+        "lot_no": "12345",
143 
+        "staff_name":  "Tum 8888",
144 
+        "man_name":  "Tum 999",
145 
+        "size": "Large",
146 
+        "pcs": "10 pcs",
147 
+        "spec": "Spec-A",
148 
+        "hardness.d1_act": "10",
149 
+        "hardness.d2_act": "0[24:28]",  # Hide rows 24 to 28 if the prefix is "0"
150 
+        "hardness.acc": True,  # Hide rows 24 to 28 if the prefix is "0"
151 
+        "hardness.spe_acc": False,  # Hide rows 24 to 28 if the prefix is "0"
152 
+        "dimension_app.d1_act": "33",
153 
+        "dimension_app.d2_act": "0[26:32]",  # Hide rows 24 to 28 if the prefix is "0"
154 
+        "dimension_app.acc": True,  # Hide rows 24 to 28 if the prefix is "0"
155 
+        "dimension_app.spe_acc": True,  # Hide rows 24 to 28 if the prefix is "0"
156 
+    }
157 
+
158 
+
159 
+
160 
+
161 
+    output_file = gen_xlsx(
162 
+        template_file="./hardness.xlsx",
163 
+        selected_sheets=["hardness", "dimension_app"],  # Replace with your actual sheet names
164 
+        prefix_filename="./output/output",
165 
+        data=data
166 
+    )
167 
+
168 
+    print(f"Generated file: {output_file}")

+ 42 - 0
app/report/views.py
Voir le fichier 

@@ -8,6 +8,10 @@ from .filters import ReportFilter
8 8 
 from .forms import ExportOptionsForm
9 9 
 from pprint import pprint
10 10
11 
+from .gen_report import gen_xlsx
12 
+from django.core.files.base import File
13 
+from pathlib import Path
14 
+
11 15
12 16 
 def index(request):
13 17 
     reports = Report.objects.all()
 
@@ -61,6 +65,44 @@ class ReportCRUDView(ConfigurableCRUDView):
61 65 
 def coi_view(request):
62 66 
     pprint(f"xxxx method = xxx {request.method}")
63 67 
     if request.method == "POST":
68 
+        pprint(request.POST)
69 
+        if 'export' in request.POST:
70 
+
71 
+            data = {
72 
+                "customer": "Tum Coder",
73 
+                "inspect_date": "2025-01-15",
74 
+                "lot_no": "12345",
75 
+                "staff_name":  "Tum 8888",
76 
+                "man_name":  "Tum 999",
77 
+                "size": "Large",
78 
+                "pcs": "10 pcs",
79 
+                "spec": "Spec-A",
80 
+                "hardness.d1_act": "10",
81 
+                "hardness.d2_act": "0[24:28]",  # Hide rows 24 to 28 if the prefix is "0"
82 
+                "hardness.acc": True,  # Hide rows 24 to 28 if the prefix is "0"
83 
+                "hardness.spe_acc": False,  # Hide rows 24 to 28 if the prefix is "0"
84 
+                "dimension_app.d1_act": "33",
85 
+                "dimension_app.d2_act": "0[26:32]",  # Hide rows 24 to 28 if the prefix is "0"
86 
+                "dimension_app.acc": True,  # Hide rows 24 to 28 if the prefix is "0"
87 
+                "dimension_app.spe_acc": True,  # Hide rows 24 to 28 if the prefix is "0"
88 
+            }
89 
+            output_file = gen_xlsx(
90 
+                template_file="/app/report/coi_templates.xlsx",
91 
+                selected_sheets=["hardness", "dimension_app"],  # Replace with your actual sheet names
92 
+                prefix_filename="/app/media/coi",
93 
+                data=data
94 
+            )
95 
+            report = Report.objects.create(
96 
+                name=request.POST.get('lot_no','Untitled'),
97 
+                created_by=request.user,
98 
+                file=None  # Leave this as None or assign a file if required
99 
+            )
100 
+            output_file_path = Path(output_file)  # Convert to a Path object for convenience
101 
+            with open(output_file_path, "rb") as f:
102 
+                report.file.save(output_file_path.name, File(f), save=True)
103 
+
104 
+            pprint(f"outputfile = {output_file}")
105 
+
64 106 
         if 'search_lot' in request.POST:
65 107 
             lot_no = request.POST.get('lot_no', None)
66 108 
             if lot_no:

+ 3 - 0
app/sysadmin/apps.py
Voir le fichier 

@@ -4,3 +4,6 @@ from django.apps import AppConfig
4 4 
 class SysadminConfig(AppConfig):
5 5 
     default_auto_field = 'django.db.models.BigAutoField'
6 6 
     name = 'sysadmin'
7 
+
8 
+    def ready(self):
9 
+        import sysadmin.signals

+ 8 - 0
app/sysadmin/forms.py
Voir le fichier 

@@ -14,6 +14,8 @@ class CustomLoginForm(AuthenticationForm):
14 14 
 from django.contrib.auth.forms import UserCreationForm
15 15 
 from django.contrib.auth.models import User
16 16
17 
+from .models import UserProfile
18 
+
17 19 
 class CustomUserCreationForm(UserCreationForm):
18 20 
     class Meta:
19 21 
         model = User
 
@@ -33,3 +35,9 @@ class CustomUserCreationForm(UserCreationForm):
33 35 
         self.fields['password2'].widget.attrs.update({
34 36 
             'placeholder': 'Confirm Password'
35 37 
         })
38 
+
39 
+
40 
+class UserProfileForm(forms.ModelForm):
41 
+    class Meta:
42 
+        model = UserProfile
43 
+        fields = ['profile_picture', 'position', 'signed_picture']  # Include the fields you want to manage

+ 29 - 0
app/sysadmin/migrations/0001_initial.py
Voir le fichier 

@@ -0,0 +1,29 @@
1 
+# Generated by Django 4.2 on 2025-01-17 04:58
2 
+
3 
+from django.conf import settings
4 
+from django.db import migrations, models
5 
+import django.db.models.deletion
6 
+
7 
+
8 
+class Migration(migrations.Migration):
9 
+
10 
+    initial = True
11 
+
12 
+    dependencies = [
13 
+        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
14 
+    ]
15 
+
16 
+    operations = [
17 
+        migrations.CreateModel(
18 
+            name='UserProfile',
19 
+            fields=[
20 
+                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
21 
+                ('bio', models.TextField(blank=True, null=True)),
22 
+                ('profile_picture', models.ImageField(blank=True, null=True, upload_to='profile/%Y/%m/%d/')),
23 
+                ('signed_picture', models.ImageField(blank=True, null=True, upload_to='signed/%Y/%m/%d/')),
24 
+                ('email', models.EmailField(blank=True, max_length=254, null=True)),
25 
+                ('position', models.CharField(blank=True, choices=[('QA_STAFF', 'QA Staff'), ('QA_MANAGER', 'QA Manager')], max_length=20, null=True)),
26 
+                ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='profile', to=settings.AUTH_USER_MODEL)),
27 
+            ],
28 
+        ),
29 
+    ]

+ 17 - 0
app/sysadmin/models.py
Voir le fichier 

@@ -1,3 +1,20 @@
1 1 
 from django.db import models
2 2
3 3 
 # Create your models here.
4 
+
5 
+from django.contrib.auth.models import User
6 
+
7 
+class UserProfile(models.Model):
8 
+    POSITION_CHOICES = [
9 
+        ('QA_STAFF', 'QA Staff'),
10 
+        ('QA_MANAGER', 'QA Manager'),
11 
+    ]
12 
+    user = models.OneToOneField(User, on_delete=models.CASCADE, related_name='profile')
13 
+    bio = models.TextField(blank=True, null=True)
14 
+    profile_picture = models.ImageField(upload_to="profile/%Y/%m/%d/", blank=True, null=True)
15 
+    signed_picture = models.ImageField(upload_to="signed/%Y/%m/%d/", blank=True, null=True)
16 
+    email = models.EmailField(blank=True, null=True)  # New email field
17 
+    position = models.CharField(max_length=20, choices=POSITION_CHOICES, blank=True, null=True)  # New position field
18 
+
19 
+    def __str__(self):
20 
+        return self.user.username

+ 13 - 0
app/sysadmin/signals.py
Voir le fichier 

@@ -0,0 +1,13 @@
1 
+from django.db.models.signals import post_save
2 
+from django.dispatch import receiver
3 
+from django.contrib.auth.models import User
4 
+from .models import UserProfile
5 
+
6 
+@receiver(post_save, sender=User)
7 
+def create_user_profile(sender, instance, created, **kwargs):
8 
+    if created:
9 
+        UserProfile.objects.create(user=instance)
10 
+
11 
+@receiver(post_save, sender=User)
12 
+def save_user_profile(sender, instance, **kwargs):
13 
+    instance.profile.save()

+ 94 - 0
app/sysadmin/templates/sysadmin/profile.html
Voir le fichier 

@@ -0,0 +1,94 @@
1 
+{% extends "base.html" %}
2 
+{% load tailwind_filters %}
3 
+
4 
+{% block title %}Report Dashboard{% endblock %}
5 
+{% block content %}
6 
+<div class="container mx-auto px-4 py-8">
7 
+<h1 class="text-2xl font-bold text-gray-700 mb-6">Your Profile</h1>
8 
+
9 
+ <div class="grid grid-cols-1 md:grid-cols-2 gap-6">
10 
+            <!-- Username -->
11 
+            <div class="flex items-center bg-gray-50 p-4 rounded-lg shadow-sm border">
12 
+                <div class="flex-shrink-0 bg-indigo-100 rounded-full h-12 w-12 flex items-center justify-center">
13 
+                    <svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 24 24" strokeWidth={1.5} stroke="currentColor" className="size-6">
14 
+  <path strokeLinecap="round" strokeLinejoin="round" d="M17.982 18.725A7.488 7.488 0 0 0 12 15.75a7.488 7.488 0 0 0-5.982 2.975m11.963 0a9 9 0 1 0-11.963 0m11.963 0A8.966 8.966 0 0 1 12 21a8.966 8.966 0 0 1-5.982-2.275M15 9.75a3 3 0 1 1-6 0 3 3 0 0 1 6 0Z" />
15 
+</svg>
16 
+
17 
+                </div>
18 
+                <div class="ml-4">
19 
+                    <h3 class="text-lg font-medium text-gray-900">Username</h3>
20 
+                    <p class="text-gray-600">{{ user.username }}</p>
21 
+                </div>
22 
+            </div>
23 
+
24 
+            <!-- Email -->
25 
+            <div class="flex items-center bg-gray-50 p-4 rounded-lg shadow-sm border">
26 
+                <div class="flex-shrink-0 bg-indigo-100 rounded-full h-12 w-12 flex items-center justify-center">
27 
+                    <svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 24 24" stroke-width="1.5" stroke="currentColor" class="size-6">
28 
+  <path stroke-linecap="round" stroke-linejoin="round" d="M21.75 6.75v10.5a2.25 2.25 0 0 1-2.25 2.25h-15a2.25 2.25 0 0 1-2.25-2.25V6.75m19.5 0A2.25 2.25 0 0 0 19.5 4.5h-15a2.25 2.25 0 0 0-2.25 2.25m19.5 0v.243a2.25 2.25 0 0 1-1.07 1.916l-7.5 4.615a2.25 2.25 0 0 1-2.36 0L3.32 8.91a2.25 2.25 0 0 1-1.07-1.916V6.75" />
29 
+</svg>
30 
+
31 
+                </div>
32 
+                <div class="ml-4">
33 
+                    <h3 class="text-lg font-medium text-gray-900">Email</h3>
34 
+                    <p class="text-gray-600">{{ user.email }}</p>
35 
+                </div>
36 
+            </div>
37 
+        </div>
38 
+<form method="POST" enctype="multipart/form-data" class='space-y-4'>
39 
+    {% csrf_token %}
40 
+              <!-- First Name -->
41 
+              <div class="grid grid-cols-1 sm:grid-cols-2 gap-6">
42 
+
43 
+                <div>
44 
+                  <label for="first_name" class="block text-sm font-medium text-gray-700">First Name</label>
45 
+                  <input
46 
+                      type="text"
47 
+                      name="first_name"
48 
+                      id="first_name"
49 
+                      value="{{ user.first_name }}"
50 
+                      class="block w-full mt-2 rounded-md border-gray-300 shadow-sm focus:ring-indigo-500 focus:border-indigo-500 sm:text-sm"
51 
+                      />
52 
+                </div>
53 
+
54 
+                <!-- Last Name -->
55 
+                <div>
56 
+                  <label for="last_name" class="block text-sm font-medium text-gray-700">Last Name</label>
57 
+                  <input
58 
+                      type="text"
59 
+                      name="last_name"
60 
+                      id="last_name"
61 
+                      value="{{ user.last_name }}"
62 
+                      class="block w-full mt-2 rounded-md border-gray-300 shadow-sm focus:ring-indigo-500 focus:border-indigo-500 sm:text-sm"
63 
+                      />
64 
+                </div>
65 
+              </div>
66 
+    {% if form.instance.profile_picture %}
67 
+    <!-- Show uploaded profile picture -->
68 
+    <img src="{{ form.instance.profile_picture.url }}"
69 
+         alt="Profile Picture"
70 
+         class="w-32 h-32 rounded-full mb-4 shadow-md">
71 
+    {% else %}
72 
+    <!-- Placeholder image if no profile picture -->
73 
+    <div class="w-32 h-32 rounded-full bg-gray-200 flex items-center justify-center text-gray-500 mb-4">
74 
+      <span>No Image</span>
75 
+    </div>
76 
+    {% endif %}
77 
+    {{ form.profile_picture }}
78 
+    {% if form.instance.signed_picture %}
79 
+    <!-- Show uploaded profile picture -->
80 
+    <img src="{{ form.instance.signed_picture.url }}"
81 
+         alt="Profile Picture"
82 
+         class="w-32 mb-4 shadow-md">
83 
+    {% else %}
84 
+    <!-- Placeholder image if no profile picture -->
85 
+    <div class="w-32 h-32 rounded-full bg-gray-200 flex items-center justify-center text-gray-500 mb-4">
86 
+      <span>No Image</span>
87 
+    </div>
88 
+    {% endif %}
89 
+    {{ form.signed_picture }}
90 
+    {{ form.position | as_crispy_field }}
91 
+    <button type="submit" class="px-6 py-2 bg-indigo-600 text-white font-medium rounded-md hover:bg-indigo-700 focus:outline-none focus:ring-2 focus:ring-indigo-500 focus:ring-offset-2">Save Changes</button>
92 
+</form>
93 
+</div>
94 
+{% endblock %}

+ 2 - 0
app/sysadmin/urls.py
Voir le fichier 

@@ -7,4 +7,6 @@ urlpatterns = [
7 7 
     path('login/', views.login_view, name='login'),
8 8 
     path('register/', views.register_view, name='register'),
9 9 
     path('logout/', views.logout_view, name='logout'),
10 
+    path('profile/', views.profile_view, name='profile'),  # Add profile view URL
11 
+
10 12 
 ]

+ 32 - 1
app/sysadmin/views.py
Voir le fichier 

@@ -1,7 +1,10 @@
1 1 
 # views.py
2 2 
 from django.contrib.auth import authenticate, login, logout
3 3 
 from django.shortcuts import render, redirect
4 
-from .forms import CustomLoginForm, CustomUserCreationForm
4 
+from .forms import CustomLoginForm, CustomUserCreationForm, UserProfileForm
5 
+from .models import UserProfile
6 
+from django.contrib.auth.decorators import login_required
7 
+from django.contrib import messages
5 8
6 9 
 def login_view(request):
7 10 
     if request.method == "POST":
 
@@ -30,3 +33,31 @@ def register_view(request):
30 33 
 def logout_view(request):
31 34 
     logout(request)  # Logs out the user
32 35 
     return redirect('sysadmin:login')  # Redirect to the login page after logout
36 
+
37 
+@login_required
38 
+def profile_view(request):
39 
+    try:
40 
+        # Get the profile for the current user
41 
+        profile = request.user.profile
42 
+    except UserProfile.DoesNotExist:
43 
+        # Create a profile if it doesn't exist
44 
+        profile = UserProfile.objects.create(user=request.user)
45 
+
46 
+    if request.method == "POST":
47 
+        form = UserProfileForm(request.POST, request.FILES, instance=profile)
48 
+
49 
+        user = request.user
50 
+        user.first_name = request.POST.get('first_name', user.first_name)
51 
+        user.last_name = request.POST.get('last_name', user.last_name)
52 
+
53 
+        if form.is_valid():
54 
+            form.save()
55 
+            user.save()
56 
+            messages.success(request, "Profile Updated")
57 
+            return redirect('sysadmin:profile')  # Redirect to the profile page after saving
58 
+        else:
59 
+            messages.error(request, form.errors)
60 
+    else:
61 
+        form = UserProfileForm(instance=profile)
62 
+
63 
+    return render(request, 'sysadmin/profile.html', {'form': form})

+ 2 - 2
app/templates/base.html
Voir le fichier 

@@ -7,7 +7,7 @@
7 7 
 <head>
8 8 
     <meta charset="UTF-8">
9 9 
     <meta name="viewport" content="width=device-width, initial-scale=1.0">
10 
-    <title>{% block title %}My Django App{% endblock %}</title>
10 
+    <title>{% block title %}COI System{% endblock %}</title>
11 11
12 12 
     <!-- TailwindCSS -->
13 13 
     <!--
 
@@ -39,7 +39,7 @@
39 39
40 40 
                 {% if user.is_authenticated %}
41 41 
                     <!-- Logged-in User -->
42 
-                    <span class="text-gray-600 dark:text-gray-300">Hello, {{ user.username }}</span>
42 
+                    <a href="{% url 'sysadmin:profile' %}"><span class="text-gray-600 dark:text-gray-300">Hello, {{ user.username }}</span></a>
43 43 
                     <a href="{% url 'sysadmin:logout' %}" class="text-blue-500 hover:underline">Logout</a>
44 44 
                 {% else %}
45 45 
                     <!-- Guest User -->

BIN
hardness.xlsx
Voir le fichier


+ 3 - 1
test_xlsx2.py
Voir le fichier 

@@ -139,6 +139,8 @@ if __name__ == "__main__":
139 139 
         "customer": "Tum Coder",
140 140 
         "inspect_date": "2025-01-15",
141 141 
         "lot_no": "12345",
142 
+        "staff_name":  "Tum 8888",
143 
+        "man_name":  "Tum 999",
142 144 
         "size": "Large",
143 145 
         "pcs": "10 pcs",
144 146 
         "spec": "Spec-A",
 
@@ -149,7 +151,7 @@ if __name__ == "__main__":
149 151 
         "dimension_app.d1_act": "33",
150 152 
         "dimension_app.d2_act": "0[26:32]",  # Hide rows 24 to 28 if the prefix is "0"
151 153 
         "dimension_app.acc": True,  # Hide rows 24 to 28 if the prefix is "0"
152 
-        "dimension_app.spe_acc": False,  # Hide rows 24 to 28 if the prefix is "0"
154 
+        "dimension_app.spe_acc": True,  # Hide rows 24 to 28 if the prefix is "0"
153 155 
     }
154 156
155 157

tum/coi - Gogs: Simplico Git Service
首頁 探索 說明
登入
tum
/
coi
關註 1
讚好 0
複刻 0
代碼 問題管理 0 合併請求 0 提交歷史 51 版本發佈 0 Wiki

暫無描述

目錄樹: f98beedea7
分支列表 標籤列表
coi
/
app
/
core
/
models.py

models.py 25KB
文件歷史 原始文件

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533 
  1. from django.db import models
    2. 

  2. 

  3. # Create your models here.
    4. 

  4. from django.contrib.auth.models import User  # Assuming you're using Django's built-in User model
    5. 

  5. 

  6. class Report(models.Model):
    7. 

  7.     name = models.CharField(max_length=255)  # Name of the report
    8. 

  8.     created_by = models.ForeignKey(
    9. 

  9.         User,
    10. 

  10.         on_delete=models.CASCADE,
    11. 

  11.         related_name="reports"
    12. 

  12.     )  # Reference to the user who created the report
    13. 

  13.     created_at = models.DateTimeField(auto_now_add=True)  # Automatically set when created
    14. 

  14.     updated_at = models.DateTimeField(auto_now=True)  # Automatically updated when modified
    15. 

  15.     file = models.FileField(upload_to='reports/files/', null=True, blank=True)  # File field
    16. 

  16.     
    17. 

  17.     def __str__(self):
    18. 

  18.         return self.name
    19. 

  19. 

  20. 

  21. class MgMasterView(models.Model):
    22. 

  22.     # ProcessControl.dbo.[Q-PRO-DATA]
    23. 

  23.     PRO0 = models.CharField(primary_key=True,max_length=255, null=False)
    24. 

  24.     PRO1 = models.CharField(max_length=255, null=True)
    25. 

  25.     PRO1C = models.CharField(max_length=255, null=True)
    26. 

  26.     PRO2 = models.CharField(max_length=255, null=True)
    27. 

  27.     PRO5 = models.CharField(max_length=255, null=True)
    28. 

  28.     PRO8 = models.CharField(max_length=255, null=True)
    29. 

  29.     PRO9 = models.CharField(max_length=255, null=True)
    30. 

  30.     PRO10 = models.CharField(max_length=255, null=True)
    31. 

  31.     PRO11 = models.CharField(max_length=255, null=True)
    32. 

  32.     PRO12 = models.CharField(max_length=255, null=True)
    33. 

  33.     PRO13 = models.CharField(max_length=255, null=True)
    34. 

  34.     PRO14 = models.CharField(max_length=255, null=True)
    35. 

  35.     PRO15 = models.CharField(max_length=255, null=True)
    36. 

  36.     PRO16 = models.CharField(max_length=255, null=True)
    37. 

  37.     PRO17 = models.CharField(max_length=255, null=True)
    38. 

  38.     PRO18 = models.CharField(max_length=255, null=True)
    39. 

  39.     PRO21 = models.CharField(max_length=255, null=True)
    40. 

  40.     PRO25 = models.CharField(max_length=255, null=True)
    41. 

  41.     PRO27 = models.CharField(max_length=255, null=True)
    42. 

  42.     P2 = models.CharField(max_length=255, null=True)  # PRO-P2
    43. 

  43.     SPEED = models.CharField(max_length=255, null=True)  # PRO-SPEED
    44. 

  44.     PRO_TOOL = models.CharField(max_length=255, null=True)  # PRO-TOOL
    45. 

  45.     PRO4 = models.CharField(max_length=255, null=True)
    46. 

  46.     
    47. 

  47.     # dbo.[MG-MAS-1]
    48. 

  48.     MC11 = models.CharField(max_length=255, null=True)
    49. 

  49.     MC12 = models.CharField(max_length=255, null=True)
    50. 

  50.     MC14 = models.CharField(max_length=255, null=True)
    51. 

  51.     MC15 = models.CharField(max_length=255, null=True)
    52. 

  52.     MC16 = models.CharField(max_length=255, null=True)
    53. 

  53.     MC19 = models.CharField(max_length=255, null=True)
    54. 

  54.     MC20 = models.CharField(max_length=255, null=True)
    55. 

  55.     MC21 = models.CharField(max_length=255, null=True)
    56. 

  56.     MC22 = models.CharField(max_length=255, null=True)
    57. 

  57.     MC23 = models.CharField(max_length=255, null=True)
    58. 

  58.     MC24 = models.CharField(max_length=255, null=True)
    59. 

  59.     
    60. 

  60.     # dbo.[MG-MAS-2]
    61. 

  61.     MP45 = models.CharField(max_length=255, null=True)
    62. 

  62.     MP49 = models.CharField(max_length=255, null=True)
    63. 

  63.     
    64. 

  64.     # dbo.[MG-MAS-3]
    65. 

  65.     MI13 = models.CharField(max_length=255, null=True)
    66. 

  66.     TC = models.CharField(max_length=255, null=True)
    67. 

  67.     MI14 = models.CharField(max_length=255, null=True)
    68. 

  68.     MI15 = models.CharField(max_length=255, null=True)
    69. 

  69.     MI16 = models.CharField(max_length=255, null=True)
    70. 

  70.     MI17 = models.CharField(max_length=255, null=True)
    71. 

  71.     MI18 = models.CharField(max_length=255, null=True)
    72. 

  72.     MI19 = models.CharField(max_length=255, null=True)
    73. 

  73.     MI20 = models.CharField(max_length=255, null=True)
    74. 

  74.     MI21 = models.CharField(max_length=255, null=True)
    75. 

  75.     MI22 = models.CharField(max_length=255, null=True)
    76. 

  76.     MI23 = models.CharField(max_length=255, null=True)
    77. 

  77.     MI31 = models.CharField(max_length=255, null=True)
    78. 

  78.     MI33 = models.CharField(max_length=255, null=True)
    79. 

  79.     INSAGM = models.CharField(max_length=255, null=True)
    80. 

  80.     MARAGM = models.CharField(max_length=255, null=True)
    81. 

  81.     MI53 = models.CharField(max_length=255, null=True)
    82. 

  82.     MI55 = models.CharField(max_length=255, null=True)
    83. 

  83.     MI36 = models.CharField(max_length=255, null=True)
    84. 

  84.     MI39 = models.CharField(max_length=255, null=True)
    85. 

  85.     MI24 = models.CharField(max_length=255, null=True)
    86. 

  86.     
    87. 

  87.     # MGT_Config.dbo.[TABLE_TI-T1], [TABLE_TI-T5], [TABLE_TI-T6]
    88. 

  88.     Ind1 = models.CharField(max_length=255, null=True)  # TIT1NE
    89. 

  89.     Ind2 = models.CharField(max_length=255, null=True)  # TIT5NE
    90. 

  90.     Ind3 = models.CharField(max_length=255, null=True)  # TIT6NE
    91. 

  91.     
    92. 

  92.     # Conditional Fields
    93. 

  93.     AGR1 = models.CharField(max_length=255, null=True)
    94. 

  94.     AGR2 = models.CharField(max_length=255, null=True)
    95. 

  95.     ob_Condition = models.CharField(max_length=255, null=True)  # TIT4NE
    96. 

  96. 

  97.     class Meta:
    98. 

  98.         managed = False
    99. 

  99.         db_table = 'mg_master_view'
    100. 

  100.         app_label = "legacy"
    101. 

  101.         #db_table = 'MgMasterView_Full_Mockup_Data'
    102. 

  102. 

  103. class VMasterView(models.Model):
    104. 

  104.     # Fields from ProcessControl.dbo.[Q-PRO-DATA]
    105. 

  105.     PRO0 = models.CharField(primary_key=True, max_length=255, null=False)
    106. 

  106.     PRO1 = models.CharField(max_length=255, null=True)
    107. 

  107.     PRO1C = models.CharField(max_length=255, null=True)
    108. 

  108.     PRO2 = models.CharField(max_length=255, null=True)
    109. 

  109.     PRO5 = models.CharField(max_length=255, null=True)
    110. 

  110.     PRO8 = models.CharField(max_length=255, null=True)
    111. 

  111.     PRO9 = models.CharField(max_length=255, null=True)
    112. 

  112.     PRO10 = models.CharField(max_length=255, null=True)
    113. 

  113.     PRO11 = models.CharField(max_length=255, null=True)
    114. 

  114.     PRO12 = models.CharField(max_length=255, null=True)
    115. 

  115.     PRO13 = models.CharField(max_length=255, null=True)
    116. 

  116.     PRO14 = models.CharField(max_length=255, null=True)
    117. 

  117.     PRO15 = models.CharField(max_length=255, null=True)
    118. 

  118.     PRO16 = models.CharField(max_length=255, null=True)
    119. 

  119.     PRO17 = models.CharField(max_length=255, null=True)
    120. 

  120.     PRO18 = models.CharField(max_length=255, null=True)
    121. 

  121.     PRO21 = models.CharField(max_length=255, null=True)
    122. 

  122.     PRO25 = models.CharField(max_length=255, null=True)
    123. 

  123.     PRO27 = models.CharField(max_length=255, null=True)
    124. 

  124.     P2 = models.CharField(max_length=255, null=True)  # PRO-P2
    125. 

  125.     PRO6 = models.CharField(max_length=255, null=True)
    126. 

  126.     SPEED = models.CharField(max_length=255, null=True)  # PRO-SPEED
    127. 

  127.     PRO_TOOL = models.CharField(max_length=255, null=True)  # PRO-TOOL
    128. 

  128.     PRO4 = models.CharField(max_length=255, null=True)
    129. 

  129.     
    130. 

  130.     # Fields from dbo.[V-MAS-1]
    131. 

  131.     MC11 = models.CharField(max_length=255, null=True)
    132. 

  132.     MC12 = models.CharField(max_length=255, null=True)
    133. 

  133.     MC14 = models.CharField(max_length=255, null=True)
    134. 

  134.     MC15 = models.CharField(max_length=255, null=True)
    135. 

  135.     MC16 = models.CharField(max_length=255, null=True)
    136. 

  136.     MC19 = models.CharField(max_length=255, null=True)
    137. 

  137.     MC20 = models.CharField(max_length=255, null=True)
    138. 

  138.     MC21 = models.CharField(max_length=255, null=True)
    139. 

  139.     MC22 = models.CharField(max_length=255, null=True)
    140. 

  140.     MC23 = models.CharField(max_length=255, null=True)
    141. 

  141.     MC24 = models.CharField(max_length=255, null=True)
    142. 

  142.     
    143. 

  143.     # Fields from dbo.[V-MAS-2]
    144. 

  144.     MP34 = models.CharField(max_length=255, null=True)
    145. 

  145.     MP39 = models.CharField(max_length=255, null=True)
    146. 

  146.     
    147. 

  147.     # Fields from dbo.[V-MAS-3]
    148. 

  148.     MI13 = models.CharField(max_length=255, null=True)
    149. 

  149.     TC = models.CharField(max_length=255, null=True)
    150. 

  150.     MI14 = models.CharField(max_length=255, null=True)
    151. 

  151.     MI15 = models.CharField(max_length=255, null=True)
    152. 

  152.     MI16 = models.CharField(max_length=255, null=True)
    153. 

  153.     MI17 = models.CharField(max_length=255, null=True)
    154. 

  154.     MI18 = models.CharField(max_length=255, null=True)
    155. 

  155.     MI19 = models.CharField(max_length=255, null=True)
    156. 

  156.     MI20 = models.CharField(max_length=255, null=True)
    157. 

  157.     MI21 = models.CharField(max_length=255, null=True)
    158. 

  158.     MI22 = models.CharField(max_length=255, null=True)
    159. 

  159.     MI23 = models.CharField(max_length=255, null=True)
    160. 

  160.     MI31 = models.CharField(max_length=255, null=True)
    161. 

  161.     MI33 = models.CharField(max_length=255, null=True)
    162. 

  162.     INSAGM = models.CharField(max_length=255, null=True)
    163. 

  163.     MARAGM = models.CharField(max_length=255, null=True)
    164. 

  164.     MI53 = models.CharField(max_length=255, null=True)
    165. 

  165.     MI55 = models.CharField(max_length=255, null=True)
    166. 

  166.     MI36 = models.CharField(max_length=255, null=True)
    167. 

  167.     MI39 = models.CharField(max_length=255, null=True)
    168. 

  168.     MI24 = models.CharField(max_length=255, null=True)
    169. 

  169.     
    170. 

  170.     # Fields from MGT_Config.dbo.[TABLE_TI-T1], [TABLE_TI-T5], [TABLE_TI-T6]
    171. 

  171.     Ind1 = models.CharField(max_length=255, null=True)  # TIT1NE
    172. 

  172.     Ind2 = models.CharField(max_length=255, null=True)  # TIT5NE
    173. 

  173.     Ind3 = models.CharField(max_length=255, null=True)  # TIT6NE
    174. 

  174.     
    175. 

  175.     # Conditional Fields
    176. 

  176.     AGR1 = models.CharField(max_length=255, null=True)
    177. 

  177.     AGR2 = models.CharField(max_length=255, null=True)
    178. 

  178.     ob_Condition = models.CharField(max_length=255, null=True)  # TIT4NE
    179. 

  179. 

  180. 

  181.     class Meta:
    182. 

  182.         managed = False
    183. 

  183.         #db_table = 'VMasterView_Full_Mockup_Data'
    184. 

  184.         db_table = 'v_master_view'
    185. 

  185.         app_label = "legacy"
    186. 

  186. 

  187. 

  188. class VwRotateLog(models.Model):
    189. 

  189.     # Fields from the SQL view
    190. 

  190.     PROD_CODE = models.CharField(max_length=255, null=True)
    191. 

  191.     LOT_NO = models.CharField(max_length=255, null=True)
    192. 

  192.     SPEED_SPEC = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    193. 

  193.     SPEED_TEST = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    194. 

  194.     SPEED_NG = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    195. 

  195.     CREATED_DT = models.DateTimeField(null=True)
    196. 

  196.     LAST_UPD_DT = models.DateTimeField(null=True)
    197. 

  197.     QTY = models.IntegerField(null=True)
    198. 

  198.     STATION_NO = models.CharField(max_length=255, null=True)
    199. 

  199. 

  200.     class Meta:
    201. 

  201.         managed = False  # This model corresponds to a database view
    202. 

  202.         db_table = 'VwRotateLog_Mockup_Data'
    203. 

  203. 

  204. 

  205. class VwRotateResult(models.Model):
    206. 

  206.     # Fields from the SQL view
    207. 

  207.     PROD_CODE = models.CharField(max_length=255, null=True)
    208. 

  208.     LOT_NO = models.CharField(max_length=255, null=True)
    209. 

  209.     SPEED_SPEC = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    210. 

  210.     QTY = models.IntegerField(null=True)
    211. 

  211.     STATION_NO = models.CharField(max_length=255, null=True)
    212. 

  212.     START_DT = models.DateTimeField(null=True)  # T1.TEST_DT as START_DT
    213. 

  213.     TEST_NO = models.CharField(max_length=255, null=True)
    214. 

  214.     SPEED_TEST_VAL = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    215. 

  215.     SPEED_NG_VAL = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    216. 

  216.     TEST_END_DT = models.DateTimeField(null=True)  # T2.TEST_DT as TEST_END_DT
    217. 

  217. 

  218.     class Meta:
    219. 

  219.         managed = False  # This model corresponds to a database view
    220. 

  220.         db_table = 'VW_ROTATE_RESULT'  # Name of the database view
    221. 

  221. 

  222. 

  223. class BelMasterView(models.Model):
    224. 

  224.     # Fields from ProcessControl.dbo.[Q-PRO-DATA]
    225. 

  225.     PRO0 = models.CharField(primary_key=True, max_length=255, null=False)
    226. 

  226.     PRO1 = models.CharField(max_length=255, null=True)
    227. 

  227.     PRO1C = models.CharField(max_length=255, null=True)
    228. 

  228.     PRO2 = models.CharField(max_length=255, null=True)
    229. 

  229.     PRO5 = models.CharField(max_length=255, null=True)
    230. 

  230.     PRO8 = models.CharField(max_length=255, null=True)
    231. 

  231.     PRO9 = models.CharField(max_length=255, null=True)
    232. 

  232.     PRO10 = models.CharField(max_length=255, null=True)
    233. 

  233.     PRO11 = models.CharField(max_length=255, null=True)
    234. 

  234.     PRO12 = models.CharField(max_length=255, null=True)
    235. 

  235.     PRO13 = models.CharField(max_length=255, null=True)
    236. 

  236.     PRO14 = models.CharField(max_length=255, null=True)
    237. 

  237.     PRO15 = models.CharField(max_length=255, null=True)
    238. 

  238.     PRO16 = models.CharField(max_length=255, null=True)
    239. 

  239.     PRO17 = models.CharField(max_length=255, null=True)
    240. 

  240.     PRO18 = models.CharField(max_length=255, null=True)
    241. 

  241.     PRO21 = models.CharField(max_length=255, null=True)
    242. 

  242.     PRO25 = models.CharField(max_length=255, null=True)
    243. 

  243.     PRO27 = models.CharField(max_length=255, null=True)
    244. 

  244.     P2 = models.CharField(max_length=255, null=True)  # PRO-P2
    245. 

  245.     PRO6 = models.CharField(max_length=255, null=True)
    246. 

  246.     SPEED = models.CharField(max_length=255, null=True)  # PRO-SPEED
    247. 

  247.     PRO_TOOL = models.CharField(max_length=255, null=True)  # PRO-TOOL
    248. 

  248.     PRO4 = models.CharField(max_length=255, null=True)
    249. 

  249.     
    250. 

  250.     # Fields from dbo.[BEL-MAS-1]
    251. 

  251.     MC11 = models.CharField(max_length=255, null=True)
    252. 

  252.     MC12 = models.CharField(max_length=255, null=True)
    253. 

  253.     MC14 = models.CharField(max_length=255, null=True)
    254. 

  254.     MC15 = models.CharField(max_length=255, null=True)
    255. 

  255.     MC16 = models.CharField(max_length=255, null=True)
    256. 

  256.     MC19 = models.CharField(max_length=255, null=True)
    257. 

  257.     MC20 = models.CharField(max_length=255, null=True)
    258. 

  258.     MC21 = models.CharField(max_length=255, null=True)
    259. 

  259.     MC22 = models.CharField(max_length=255, null=True)
    260. 

  260.     MC23 = models.CharField(max_length=255, null=True)
    261. 

  261.     MC24 = models.CharField(max_length=255, null=True)
    262. 

  262.     
    263. 

  263.     # Fields from dbo.[BEL-MAS-2]
    264. 

  264.     MP45 = models.CharField(max_length=255, null=True)
    265. 

  265.     MP49 = models.CharField(max_length=255, null=True)
    266. 

  266.     
    267. 

  267.     # Fields from dbo.[BEL-MAS-3]
    268. 

  268.     MI13 = models.CharField(max_length=255, null=True)
    269. 

  269.     TC = models.CharField(max_length=255, null=True)
    270. 

  270.     MI14 = models.CharField(max_length=255, null=True)
    271. 

  271.     MI15 = models.CharField(max_length=255, null=True)
    272. 

  272.     MI16 = models.CharField(max_length=255, null=True)
    273. 

  273.     MI17 = models.CharField(max_length=255, null=True)
    274. 

  274.     MI18 = models.CharField(max_length=255, null=True)
    275. 

  275.     MI19 = models.CharField(max_length=255, null=True)
    276. 

  276.     MI20 = models.CharField(max_length=255, null=True)
    277. 

  277.     MI21 = models.CharField(max_length=255, null=True)
    278. 

  278.     MI22 = models.CharField(max_length=255, null=True)
    279. 

  279.     MI23 = models.CharField(max_length=255, null=True)
    280. 

  280.     MI31 = models.CharField(max_length=255, null=True)
    281. 

  281.     MI33 = models.CharField(max_length=255, null=True)
    282. 

  282.     INSAGM = models.CharField(max_length=255, null=True)
    283. 

  283.     MARAGM = models.CharField(max_length=255, null=True)
    284. 

  284.     MI53 = models.CharField(max_length=255, null=True)
    285. 

  285.     MI55 = models.CharField(max_length=255, null=True)
    286. 

  286.     MI36 = models.CharField(max_length=255, null=True)
    287. 

  287.     MI39 = models.CharField(max_length=255, null=True)
    288. 

  288.     MI24 = models.CharField(max_length=255, null=True)
    289. 

  289.     
    290. 

  290.     # Fields from MGT_Config.dbo.[TABLE_TI-T1], [TABLE_TI-T5], [TABLE_TI-T6]
    291. 

  291.     Ind1 = models.CharField(max_length=255, null=True)  # TIT1NE
    292. 

  292.     Ind2 = models.CharField(max_length=255, null=True)  # TIT5NE
    293. 

  293.     Ind3 = models.CharField(max_length=255, null=True)  # TIT6NE
    294. 

  294.     
    295. 

  295.     # Conditional Fields
    296. 

  296.     AGR1 = models.CharField(max_length=255, null=True)
    297. 

  297.     AGR2 = models.CharField(max_length=255, null=True)
    298. 

  298.     ob_Condition = models.CharField(max_length=255, null=True)  # TIT4NE
    299. 

  299. 

  300.     class Meta:
    301. 

  301.         managed = False  # This model corresponds to a database view
    302. 

  302.         app_label = "legacy"
    303. 

  303.         db_table = 'bel_master_view'  # Name of the database view
    304. 

  304. 

  305. class EMasterView(models.Model):
    306. 

  306.     # Fields from ProcessControl.dbo.[Q-PRO-DATA]
    307. 

  307.     PRO0 = models.CharField(primary_key=True, max_length=255, null=False)
    308. 

  308.     PRO1 = models.CharField(max_length=255, null=True)
    309. 

  309.     PRO1C = models.CharField(max_length=255, null=True)
    310. 

  310.     PRO2 = models.CharField(max_length=255, null=True)
    311. 

  311.     PRO5 = models.CharField(max_length=255, null=True)
    312. 

  312.     PRO8 = models.CharField(max_length=255, null=True)
    313. 

  313.     PRO9 = models.CharField(max_length=255, null=True)
    314. 

  314.     PRO10 = models.CharField(max_length=255, null=True)
    315. 

  315.     PRO11 = models.CharField(max_length=255, null=True)
    316. 

  316.     PRO12 = models.CharField(max_length=255, null=True)
    317. 

  317.     PRO13 = models.CharField(max_length=255, null=True)
    318. 

  318.     PRO14 = models.CharField(max_length=255, null=True)
    319. 

  319.     PRO15 = models.CharField(max_length=255, null=True)
    320. 

  320.     PRO16 = models.CharField(max_length=255, null=True)
    321. 

  321.     PRO17 = models.CharField(max_length=255, null=True)
    322. 

  322.     PRO18 = models.CharField(max_length=255, null=True)
    323. 

  323.     PRO21 = models.CharField(max_length=255, null=True)
    324. 

  324.     PRO25 = models.CharField(max_length=255, null=True)
    325. 

  325.     PRO27 = models.CharField(max_length=255, null=True)
    326. 

  326.     P2 = models.CharField(max_length=255, null=True)  # PRO-P2
    327. 

  327.     PRO6 = models.CharField(max_length=255, null=True)
    328. 

  328.     SPEED = models.CharField(max_length=255, null=True)  # PRO-SPEED
    329. 

  329.     PRO_TOOL = models.CharField(max_length=255, null=True)  # PRO-TOOL
    330. 

  330.     PRO4 = models.CharField(max_length=255, null=True)
    331. 

  331.     
    332. 

  332.     # Fields from dbo.[E-MAS-1]
    333. 

  333.     MC11 = models.CharField(max_length=255, null=True)
    334. 

  334.     MC12 = models.CharField(max_length=255, null=True)
    335. 

  335.     MC14 = models.CharField(max_length=255, null=True)
    336. 

  336.     MC15 = models.CharField(max_length=255, null=True)
    337. 

  337.     MC16 = models.CharField(max_length=255, null=True)
    338. 

  338.     MC19 = models.CharField(max_length=255, null=True)
    339. 

  339.     MC20 = models.CharField(max_length=255, null=True)
    340. 

  340.     MC21 = models.CharField(max_length=255, null=True)
    341. 

  341.     MC22 = models.CharField(max_length=255, null=True)
    342. 

  342.     MC23 = models.CharField(max_length=255, null=True)
    343. 

  343.     MC24 = models.CharField(max_length=255, null=True)
    344. 

  344.     
    345. 

  345.     # Fields from dbo.[E-MAS-2]
    346. 

  346.     MP45 = models.CharField(max_length=255, null=True)
    347. 

  347.     MP49 = models.CharField(max_length=255, null=True)
    348. 

  348.     
    349. 

  349.     # Fields from dbo.[E-MAS-3]
    350. 

  350.     MI13 = models.CharField(max_length=255, null=True)
    351. 

  351.     TC = models.CharField(max_length=255, null=True)
    352. 

  352.     MI14 = models.CharField(max_length=255, null=True)
    353. 

  353.     MI15 = models.CharField(max_length=255, null=True)
    354. 

  354.     MI16 = models.CharField(max_length=255, null=True)
    355. 

  355.     MI17 = models.CharField(max_length=255, null=True)
    356. 

  356.     MI18 = models.CharField(max_length=255, null=True)
    357. 

  357.     MI19 = models.CharField(max_length=255, null=True)
    358. 

  358.     MI20 = models.CharField(max_length=255, null=True)
    359. 

  359.     MI21 = models.CharField(max_length=255, null=True)
    360. 

  360.     MI22 = models.CharField(max_length=255, null=True)
    361. 

  361.     MI23 = models.CharField(max_length=255, null=True)
    362. 

  362.     MI31 = models.CharField(max_length=255, null=True)
    363. 

  363.     MI33 = models.CharField(max_length=255, null=True)
    364. 

  364.     INSAGM = models.CharField(max_length=255, null=True)
    365. 

  365.     MARAGM = models.CharField(max_length=255, null=True)
    366. 

  366.     MI53 = models.CharField(max_length=255, null=True)
    367. 

  367.     MI55 = models.CharField(max_length=255, null=True)
    368. 

  368.     MI36 = models.CharField(max_length=255, null=True)
    369. 

  369.     MI39 = models.CharField(max_length=255, null=True)
    370. 

  370.     MI24 = models.CharField(max_length=255, null=True)
    371. 

  371.     
    372. 

  372.     # Fields from MGT_Config.dbo.[TABLE_TI-T1], [TABLE_TI-T5], [TABLE_TI-T6]
    373. 

  373.     Ind1 = models.CharField(max_length=255, null=True)  # TIT1NE
    374. 

  374.     Ind2 = models.CharField(max_length=255, null=True)  # TIT5NE
    375. 

  375.     Ind3 = models.CharField(max_length=255, null=True)  # TIT6NE
    376. 

  376.     
    377. 

  377.     # Conditional Fields
    378. 

  378.     AGR1 = models.CharField(max_length=255, null=True)
    379. 

  379.     AGR2 = models.CharField(max_length=255, null=True)
    380. 

  380.     ob_Condition = models.CharField(max_length=255, null=True)  # TIT4NE
    381. 

  381. 

  382.     class Meta:
    383. 

  383.         managed = False  # This model corresponds to a database view
    384. 

  384.         app_label = "legacy"
    385. 

  385.         db_table = 'e_master_view'  # Name of the database view
    386. 

  386. 

  387. class AllProductAverageObMinMaxView(models.Model):
    388. 

  388.     ProductCode = models.CharField(max_length=255, null=True)  # RE01
    389. 

  389.     out_min = models.DecimalField(max_digits=10, decimal_places=2, null=True)  # Minimum of [OB-O]
    390. 

  390.     out_max = models.DecimalField(max_digits=10, decimal_places=2, null=True)  # Maximum of [OB-O]
    391. 

  391.     in_min = models.DecimalField(max_digits=10, decimal_places=2, null=True)  # Minimum of [OB-I]
    392. 

  392.     in_max = models.DecimalField(max_digits=10, decimal_places=2, null=True)  # Maximum of [OB-I]
    393. 

  393. 

  394.     class Meta:
    395. 

  395.         managed = False  # This model corresponds to a database view
    396. 

  396.         app_label = "legacy"
    397. 

  397.         db_table = 'AllProduct_Average_OB_MIN_MAX_view'  # Name of the database view
    398. 

  398. 

  399. class AllProductDimensionForInsProcess(models.Model):
    400. 

  400.     ProdType = models.CharField(max_length=255, null=True)  # Product type (e.g., 'V', 'E', 'BEL', 'MG')
    401. 

  401.     ProductCode = models.CharField(max_length=255, primary_key=True) # Product code# Product code
    402. 

  402.     Size_Id = models.CharField(max_length=255, null=True)  # Size ID (e.g., '001', '002')
    403. 

  403.     Size_Name = models.CharField(max_length=255, null=True)  # Size name (e.g., 'D', 'T', 'H')
    404. 

  404.     Std = models.DecimalField(max_digits=10, decimal_places=2, null=True)  # Standard value
    405. 

  405.     TolUn = models.DecimalField(max_digits=10, decimal_places=2, null=True)  # Tolerance lower limit
    406. 

  406.     TolUp = models.DecimalField(max_digits=10, decimal_places=2, null=True)  # Tolerance upper limit
    407. 

  407. 

  408.     class Meta:
    409. 

  409.         managed = False  # This model corresponds to a database view
    410. 

  410.         app_label = "legacy"
    411. 

  411.         db_table = 'AllProduct_Dimension_ForInsProcess'  # Name of the database view
    412. 

  412. 

  413. class AllProductPressPositionPressWeight(models.Model):
    414. 

  414.     ProductCode = models.CharField(max_length=255, null=True)
    415. 

  415.     Lot_No = models.CharField(max_length=255, null=True)
    416. 

  416.     PO_Qty = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    417. 

  417.     UWeight = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    418. 

  418.     Current_ProNo = models.CharField(max_length=255, null=True)
    419. 

  419.     Press_Time = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    420. 

  420.     PressType_1 = models.CharField(max_length=255, null=True)
    421. 

  421.     PressWeight_1 = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    422. 

  422.     PressType_2 = models.CharField(max_length=255, null=True)
    423. 

  423.     PressWeight_2 = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    424. 

  424.     Press_Ton = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    425. 

  425.     Press_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    426. 

  426.     Press_T_Tol = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    427. 

  427.     Mold_D = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    428. 

  428.     Mold_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    429. 

  429.     SegMold_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    430. 

  430.     SegMold_D = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    431. 

  431.     Center_D = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    432. 

  432.     Center_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    433. 

  433.     LowerPlate_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    434. 

  434.     StudPlate_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    435. 

  435.     UpperPlate_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    436. 

  436.     PinPlate_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    437. 

  437.     TopConcave_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    438. 

  438.     BottomConcave_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    439. 

  439. 

  440.     class Meta:
    441. 

  441.         managed = False  # This model corresponds to a database view
    442. 

  442.         app_label = "legacy"
    443. 

  443.         db_table = 'AllProduct_PressPosition_PressWeight'  # Name of the database view
    444. 

  444. 

  445. class RotateBrokenTest(models.Model):
    446. 

  446.     row_no = models.IntegerField(null=True, blank=True)
    447. 

  447.     speed_spec = models.FloatField(null=True, blank=True)
    448. 

  448.     speed_test = models.FloatField(null=True, blank=True)
    449. 

  449.     speedOk = models.CharField(max_length=4, null=True, blank=True)
    450. 

  450.     qty = models.IntegerField()
    451. 

  451.     station_no = models.IntegerField()
    452. 

  452.     created_at = models.DateTimeField(null=True, blank=True)
    453. 

  453.     updated_at = models.DateTimeField(null=True, blank=True)
    454. 

  454.     lot_no = models.CharField(max_length=50, null=True, blank=True)
    455. 

  455.     machine_id = models.IntegerField(null=True, blank=True)
    456. 

  456.     code = models.CharField(max_length=50, null=True, blank=True)
    457. 

  457.     emp_id = models.IntegerField()
    458. 

  458.     devid = models.CharField(max_length=40, null=True, blank=True)
    459. 

  459.     mode = models.CharField(max_length=10, null=True, blank=True)
    460. 

  460.     cal_mode = models.IntegerField(null=True, blank=True)
    461. 

  461. 

  462.     class Meta:
    463. 

  463.         managed = False  # This model corresponds to a database view
    464. 

  464.         app_label = "legacy"
    465. 

  465.         db_table = "rotate_broken_test"  # Matches SQL Server table name
    466. 

  466. 

  467. class LotType(models.Model):
    468. 

  468.     lot_no = models.CharField(primary_key=True,max_length=20, db_column='LotNo')
    469. 

  469.     group = models.CharField(max_length=10, db_column='Group')
    470. 

  470.     sub_group = models.CharField(max_length=10, db_column='SubGroup')
    471. 

  471. 

  472.     class Meta:
    473. 

  473.         db_table = 'T-LotType'
    474. 

  474.         managed = False  # Since it's an existing table in SQL Server
    475. 

  475.         app_label = "trans"
    476. 

  476. 

  477. 

  478. TEMPLATE_CHOICES = [
    479. 

  479.     "hardness_out",
    480. 

  480.     "hardness_out_in",
    481. 

  481.     "hardness_both_size",
    482. 

  482.     "dimension",
    483. 

  483.     "dimension_app",
    484. 

  484.     "dimension_bal_weight",
    485. 

  485.     "dim_bal_app_hard",
    486. 

  486.     "dim_bal_app_rot_hard",
    487. 

  487.     "thickness_8_point",
    488. 

  488.     "centering"
    489. 

  489. ]
    490. 

  490. 

  491. class CustomerTemplateMapping(models.Model):
    492. 

  492.     customer_name = models.CharField(max_length=255)
    493. 

  493.     template_names = models.JSONField(default=list, blank=True, null=True)  # stores list of template names
    494. 

  494. 

  495.     created_by = models.ForeignKey(
    496. 

  496.         User,
    497. 

  497.         on_delete=models.SET_NULL,
    498. 

  498.         null=True,
    499. 

  499.         blank=True, 
    500. 

  500.     )  # Reference to the user who created the report
    501. 

  501.     created_at = models.DateTimeField(auto_now_add=True)  # Automatically set when created
    502. 

  502.     updated_at = models.DateTimeField(auto_now=True)  # Automatically updated when modified
    503. 

  503.     def __str__(self):
    504. 

  504.         return self.customer_name
    505. 

  505. 

  506. class ProductDrawing(models.Model):
    507. 

  507.     code_no = models.CharField(max_length=100, null=True, blank=True)
    508. 

  508.     code_no_mks = models.CharField(max_length=100, null=True, blank=True)
    509. 

  509.     lot_no = models.CharField(max_length=100, null=True, blank=True)
    510. 

  510.     drawing = models.ImageField(upload_to='drawings/')
    511. 

  511.     description = models.TextField(null=True, blank=True)
    512. 

  512.     created_at = models.DateTimeField(auto_now_add=True)
    513. 

  513.     updated_at = models.DateTimeField(auto_now=True)
    514. 

  514. 

  515.     created_by = models.ForeignKey(
    516. 

  516.         User,
    517. 

  517.         on_delete=models.SET_NULL,
    518. 

  518.         null=True,
    519. 

  519.         blank=True, 
    520. 

  520.     )  # Reference to the user who created the report
    521. 

  521.     
    522. 

  522.     def __str__(self):
    523. 

  523.         return f"{self.code_no} - {self.lot_no}"
    524. 

  524. 

  525. class MksCodeMap(models.Model):
    526. 

  526.     mgt_code = models.CharField(max_length=100)
    527. 

  527.     mks_code = models.CharField(max_length=100)
    528. 

  528.     created_at = models.DateTimeField(auto_now_add=True)
    529. 

  529.     updated_at = models.DateTimeField(auto_now=True)
    530. 

  530. 

  531.     def __str__(self):
    532. 

  532.         return f"{self.mgt_code} ⇄ {self.mks_code}"
    533. 

  533.