l="diff-a5cc2925ca8258af241be7e5b0381edf30266302R151">151 
+
152 
+# End of https://www.toptal.com/developers/gitignore/api/django
153 
+data/
154 
+media/

+ 3 - 0
.vscode/settings.json
Wyświetl plik 

@@ -0,0 +1,3 @@
1 
+{
2 
+    "python.formatting.provider": "yapf"
3 
+}

BIN
071e1563b7c24e91a42ede26fff49a8d.png
Wyświetl plik


+ 11 - 0
Dockerfile
Wyświetl plik 

@@ -0,0 +1,11 @@
1 
+# syntax=docker/dockerfile:1
2 
+FROM python:3
3 
+ENV PYTHONUNBUFFERED=1
4 
+ADD ./app /code
5 
+WORKDIR /code
6 
+RUN apt-get update && apt-get install -y \
7 
+        gettext \
8 
+        xfonts-thai \
9 
+        gdal-bin libgdal-dev python3-gdal binutils libproj-dev \
10 
+        stunnel
11 
+RUN pip install -r requirements.txt

+ 26 - 0
app/cert.pem
Wyświetl plik 

@@ -0,0 +1,26 @@
1 
+-----BEGIN CERTIFICATE-----
2 
+MIIEdTCCAt2gAwIBAgIQHZxX+6y4OViy/tCHkaIX+jANBgkqhkiG9w0BAQsFADCB
3 
+kTEeMBwGA1UEChMVbWtjZXJ0IGRldmVsb3BtZW50IENBMTMwMQYDVQQLDCpzaW1w
4 
+bGljb2x0ZC5AbWFjaGluZS5sb2NhbCAoU2ltcGxpY28gTHRkLikxOjA4BgNVBAMM
5 
+MW1rY2VydCBzaW1wbGljb2x0ZC5AbWFjaGluZS5sb2NhbCAoU2ltcGxpY28gTHRk
6 
+LikwHhcNMjEwNzI0MTAzMjUzWhcNMjMxMDI0MTAzMjUzWjBdMScwJQYDVQQKEx5t
7 
+a2NlcnQgZGV2ZWxvcG1lbnQgY2VydGlmaWNhdGUxMjAwBgNVBAsMKXJvb3RAbWFj
8 
+aGluZS5sb2NhbCAoU3lzdGVtIEFkbWluaXN0cmF0b3IpMIIBIjANBgkqhkiG9w0B
9 
+AQEFAAOCAQ8AMIIBCgKCAQEAzO3kDm8SonO2P/pSOQmFPYoj2+fz8nEd5ss+vL/e
10 
+Rc5BaJsq1651glIdOyUX13B4E0viTF0aa6SP9jZLU6lPluJwW5UYCuVSW67wL0Ev
11 
+C82TBpBz2hMGuC6DcpG0nJgzY04kuz0mJaqWtWD4AMq3BOwgBNy2PrB45cUGBBe3
12 
+bvsCip9ykVW8vHEWKgHpdnZvUYnbbbea9jDR/nB0cDeKd5K45V/Lv2ECBAGa272C
13 
+9a9uqXuzIcVFsdOb9ss6YNyiSs1AJeXTV16M5u6ZlVN95IU9AHqWxeTCVYyGZWZt
14 
+g1XD7MB/M22/mDUjZg1fdK3v2n+RFxyo/FGoNE6ziACz6wIDAQABo3wwejAOBgNV
15 
+HQ8BAf8EBAMCBaAwEwYDVR0lBAwwCgYIKwYBBQUHAwEwHwYDVR0jBBgwFoAUHmGB
16 
+OP5O8TsFjAThvXx+jAsNHWQwMgYDVR0RBCswKYIJbG9jYWxob3N0hwQAAAAAhwR/
17 
+AAABhxAAAAAAAAAAAAAAAAAAAAABMA0GCSqGSIb3DQEBCwUAA4IBgQA/wteJRFk9
18 
+0NqaOKrD1YPXvhq+rXns5yEWgnomi11d5LkHvwtM9A9HmkW0/LB8FPoiY17NUPqR
19 
+xZi2RAQcHn9j1wDuBKEMb5Y/xCt5k+Szhyvgfxyqkt4ef4yJ46vIcSXTLjb/+LWm
20 
+LW+YLl4vbtYnq4zYtcczVQrnDoPNZGjTGIGDs15PzHZoFt7fY7dypFr/McZnI11z
21 
+RRd+z7cjMoxs9UCO7O/f/E8Rpv6pkNuAVzPrezy84fcyN9elbr1eJVNKjLXWf0CR
22 
+Ry2PxLkK/x7tWcE2eLVY+kZC5HfHzkiXgulBazhXprLwIcFwePmkQQ2b8ktY/+io
23 
+a5DUZ56gZV2BpLK0KiokAmRZh5GWBkMwrJu5YgALiqJAGGg+JBPC6SMOp9vlXPqw
24 
+zldZGjtb8jcFpCC6xMvsWag+MF6pIQrOSV+AaPf5/008jbrfwDlBXtMcxWmNtBJv
25 
+CAFZlQ+UNIb/QHEM22WQNGacCmyX+hLy/GwCJVk8wyNfPOz2wYKVeAk=
26 
+-----END CERTIFICATE-----

BIN
app/client.ks
Wyświetl plik


+ 0 - 0
app/front/__init__.py
Wyświetl plik


+ 3 - 0
app/front/admin.py
Wyświetl plik 

@@ -0,0 +1,3 @@
1 
+from django.contrib import admin
2 
+
3 
+# Register your models here.

+ 6 - 0
app/front/apps.py
Wyświetl plik 

@@ -0,0 +1,6 @@
1 
+from django.apps import AppConfig
2 
+
3 
+
4 
+class FrontConfig(AppConfig):
5 
+    default_auto_field = 'django.db.models.BigAutoField'
6 
+    name = 'front'

+ 0 - 0
app/front/migrations/__init__.py
Wyświetl plik


+ 3 - 0
app/front/models.py
Wyświetl plik 

@@ -0,0 +1,3 @@
1 
+from django.db import models
2 
+
3 
+# Create your models here.

+ 13 - 0
app/front/templates/front/_grids.html
Wyświetl plik 

@@ -0,0 +1,13 @@
1 
+<div class="row">
2 
+    {% for o in objs %}
3 
+    <div class="col-md-3">
4 
+        {% if o.featureImage %}
5 
+        <img src='{{ o.featureImage.url }}'>
6 
+        {% endif %}
7 
+        {{ o.name }}
8 
+    </div>
9 
+    {% endfor %}
10 
+</div >
11 
+
12 
+
13 
+

+ 0 - 0
app/front/templates/front/_localSearch.html
Wyświetl plik


+ 49 - 0
app/front/templates/front/_menu.html
Wyświetl plik 

@@ -0,0 +1,49 @@
1 
+{% load mptt_tags %}
2 
+<header class="blog-header py-3">
3 
+	<div class="row flex-nowrap justify-content-between align-items-center">
4 
+		<div class="col-2 pt-1">
5 
+			<a class="text-muted" href="#">Subscribe</a>
6 
+		</div>
7 
+		<div class="col-6 text-center">
8 
+			<a class="blog-header-logo text-dark" href="{% url "front:index" %}">SimpleMarket
9 
+          {% if storeFront %}
10 
+            :{{ storeFront.fullName }}
11 
+          {% endif %}
12 
+      </a>
13 
+		</div>
14 
+		<div class="col-4 d-flex justify-content-end align-items-center">
15 
+        <form class="form-inline mt-2 mt-md-0" action="{% url "front:search" %}" method="GET">
16 
+            {% if storeFront %}
17 
+            <input type="hidden" name='cstr' value='{{ storeFront.storeId }}' />
18 
+            {% endif %}
19 
+            <input class="form-control form-control-sm  mr-sm-2" type="text" placeholder="Search" aria-label="Search" name='q'>
20 
+            <button class="btn  btn-sm btn-outline-success my-2 my-sm-0" type="submit">Search</button>
21 
+        </form>
22 
+            {% if user.is_authenticated %}
23 
+            <a class="ml-2 btn btn-sm btn-outline-secondary" href="{% url "logout" %}">Sign Out</a>
24 
+            {% else  %}
25 
+            <a class="btn btn-sm btn-outline-secondary mx-2" href="{% url "login" %}">Sign In</a>
26 
+            {% endif %}
27 
+		</div>
28 
+	</div>
29 
+</header>
30 
+
31 
+<div class="nav-scroller py-1 mb-2">
32 
+	<nav class="nav d-flex justify-content-between">
33 
+
34 
+      <!--<a class="p-2 text-muted" href="#">Home</a>-->
35 
+		<!--<a class="p-2 text-muted" href="#">News</a>-->
36 
+        <!--<a class="p-2 text-muted" href="#">Market</a>-->
37 
+		<!--<a class="p-2 text-muted" href="#">Articles</a>-->
38 
+		<!--<a class="p-2 text-muted" href="#">Forum</a>-->
39 
+    {% recursetree primaryMenu %}
40 
+    {% if node.name != "root" %}
41 
+    <a class="p-2 text-muted" href="{{ node.url }}">{{ node.name }}</a>
42 
+    {% endif %}
43 
+    {{ children }}
44 
+    {% endrecursetree %}
45 
+	</nav>
46 
+</div>
47 
+
48 
+<hr>
49 
+

+ 14 - 0
app/front/templates/front/_menu_ui.html
Wyświetl plik 

@@ -0,0 +1,14 @@
1 
+{% load mptt_tags %}
2 
+<ul>
3 
+    {% recursetree menu %}
4 
+        <li>
5 
+            <a href="{{ node.url | safe }}">{{ node.name }}</a>
6 
+            {% if not node.is_leaf_node %}
7 
+                <ul class="children">
8 
+                    {{ children }}
9 
+                </ul>
10 
+            {% endif %}
11 
+        </li>
12 
+    {% endrecursetree %}
13 
+</ul>
14 
+

+ 33 - 0
app/front/templates/front/_promotions.html
Wyświetl plik 

@@ -0,0 +1,33 @@
1 
+<div id="promotions" class="carousel slide" data-ride="carousel">
2 
+    <ol class="carousel-indicators">
3 
+        {% for o in objs %}
4 
+            {% if o.featureImage %}
5 
+            <li data-target="#promotions" data-slide-to="{{ forloop.counter0 }}"></li>
6 
+            {% endif %}
7 
+        {% endfor %}
8 
+    </ol>
9 
+  <div class="carousel-inner">
10 
+      {% for o in objs %}
11 
+        {% if o.featureImage %}
12 
+        <div class="carousel-item {{ forloop.first|yesno:"active," }}">
13 
+                <div class='img-container-16-9'>
14 
+                <img src="{{ o.featureImage.url }}" class="d-block w-100 media" alt="...">
15 
+                </div>
16 
+                <div class="carousel-caption d-none d-md-block">
17 
+                    <a href='https://www.google.com' class='text-decoration-none text-white'>
18 
+                    <h5>{{ o.title }}</h5>
19 
+                    <p>{{ o.description }}</p></a>
20 
+                </div>
21 
+            </div>
22 
+        {% endif %}
23 
+      {% endfor %}
24 
+  </div>
25 
+   <button class="carousel-control-prev border-0" type="button" data-target="#promotions" data-slide="prev">
26 
+    <span class="carousel-control-prev-icon" aria-hidden="true"></span>
27 
+    <span class="sr-only">Previous</span>
28 
+  </button>
29 
+  <button class="carousel-control-next border-0" type="button" data-target="#promotions" data-slide="next">
30 
+    <span class="carousel-control-next-icon" aria-hidden="true"></span>
31 
+    <span class="sr-only">Next</span>
32 
+  </button>
33 
+</div>

+ 17 - 0
app/front/templates/front/_recs.html
Wyświetl plik 

@@ -0,0 +1,17 @@
1 
+<h2 class='text-center mt-4 mb-2'>Recommended</h2>
2 
+<div class="card-columns">
3 
+    {% for o in objs %}
4 
+  <div class="card">
5 
+      <img src="{{ o.featureImage.url }}" class="card-img-top" alt="...">
6 
+    <div class="card-body">
7 
+        <h5 class="card-title">
8 
+            <a href="{% url "front:viewPost"   pid=o.id %}?cstr={{ storeFront.storeId }}">{{ o.title }}</a>
9 
+        </h5>
10 
+      <p class="card-text">
11 
+        {{ o.description }}
12 
+        Cras justo odio, dapibus ac facilisis in, egestas eget quam. Sed posuere consectetur est at lobortis.
13 
+      </p>
14 
+    </div>
15 
+  </div>
16 
+    {% endfor %}
17 
+</div>

+ 25 - 0
app/front/templates/front/_relate_menus.html
Wyświetl plik 

@@ -0,0 +1,25 @@
1 
+<h2 class='text-center mt-4 mb-2'>Relate Menus</h2>
2 
+<div class="row">
3 
+    {% for o in objs %}
4 
+    {% if forloop.counter|divisibleby:4 %}
5 
+      <div class="card text-white bg-primary col-md-4 p-0">
6 
+    {% elif forloop.counter|divisibleby:3 %}
7 
+      <div class="card text-white bg-secondary col-md-4 p-0">
8 
+    {% elif forloop.counter|divisibleby:2  %}
9 
+      <div class="card text-white bg-success col-md-4 p-0">
10 
+    {% elif forloop.counter|divisibleby:1 %}
11 
+      <div class="card text-white bg-danger col-md-4 p-0">
12 
+    {% endif %}
13 
+    {% if o.featureImage %}
14 
+        <div class='img-container-16-9'>
15 
+            <img class="card-img-top media" src="{{ o.featureImage.url }}" alt="Card image cap">
16 
+        </div>
17 
+        {% endif %}
18 
+    <div class="card-body">
19 
+        <h5 class="card-title">{{ o.name }}</h5>
20 
+        <p class="card-text">{{ o.description }}</p>
21 
+        <p class="card-text"><small class="text-white">{{ o.created_at }}</small></p>
22 
+    </div>
23 
+  </div>
24 
+  {% endfor %}
25 
+</div>

+ 23 - 0
app/front/templates/front/_reviews.html
Wyświetl plik 

@@ -0,0 +1,23 @@
1 
+<h2 class='text-center mt-4 mb-2'>Reviews</h2>
2 
+<div class="row">
3 
+    {% for o in objs %}
4 
+    {% if forloop.counter|divisibleby:4 %}
5 
+      <div class="card text-white bg-primary col-md-4 p-0">
6 
+    {% elif forloop.counter|divisibleby:3 %}
7 
+      <div class="card text-white bg-secondary col-md-4 p-0">
8 
+    {% elif forloop.counter|divisibleby:2  %}
9 
+      <div class="card text-white bg-success col-md-4 p-0">
10 
+    {% elif forloop.counter|divisibleby:1 %}
11 
+      <div class="card text-white bg-danger col-md-4 p-0">
12 
+    {% endif %}
13 
+        <div class='img-container-16-9'>
14 
+            <img class="card-img-top media" src="{{ o.featureImage.url }}" alt="Card image cap">
15 
+        </div>
16 
+    <div class="card-body">
17 
+        <h5 class="card-title">{{ o.title }}</h5>
18 
+        <p class="card-text">{{ o.description }}</p>
19 
+        <p class="card-text"><small class="text-white">{{ o.created_at }}</small></p>
20 
+    </div>
21 
+  </div>
22 
+  {% endfor %}
23 
+</div>

+ 82 - 0
app/front/templates/front/base.html
Wyświetl plik 

@@ -0,0 +1,82 @@
1 
+{% load static %}
2 
+<!DOCTYPE html>
3 
+<html lang="en">
4 
+<head>
5 
+    <title>
6 
+        FindBed.xyz ทำเพื่อช่วยเหลือในการหาเตียงสำหรับผู้ป่วย COVID19
7 
+    </title>
8 
+    <meta name="description" content="FindBed.xyz ทำเพื่อช่วยเหลือในการหาเตียงสำหรับผู้ป่วย COVID19">
9 
+     <!-- Include meta tag to ensure proper rendering and touch zooming -->
10 
+  <meta name="viewport" content="width=device-width, initial-scale=1">
11 
+  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
12 
+  <!--
13 
+  <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous"> -->
14 
+
15 
+  <!-- Include the jQuery library -->
16 
+  <!--
17 
+  <script src="https://code.jquery.com/jquery-1.11.3.min.js"></script> -->
18 
+  <script src="{% static "bower_components/jQuery/dist/jquery.min.js" %}"></script>
19 
+  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script>
20 
+<!--
21 
+<script src="https://cdn.jsdelivr.net/npm/bootstrap@4.0.0/dist/js/bootstrap.bundle.min.js" integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM" crossorigin="anonymous"></script> -->
22 
+<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.5.0/font/bootstrap-icons.css">
23 
+
24 
+  <link href="https://fonts.googleapis.com/css?family=Playfair+Display:700,900" rel="stylesheet">
25 
+{% block header %}
26 
+{% endblock %}
27 
+    <link href="{% static "front/css/blog.css" %}" rel="stylesheet">
28 
+    <link href="{% static "bower_components/components-font-awesome/css/all.css" %}" rel="stylesheet">
29 
+<script type='text/javascript' src="{% static "js/main.js" %}"></script>
30 
+{% if store %}
31 
+{% autoescape off %}
32 
+    <script type='text/javascript'>
33 
+        {{ store.code.jsCode }}
34 
+    </script>
35 
+    <style>
36 
+        {{ store.code.cssCode }}
37 
+    </style>
38 
+    {{ store.code.pluginCode }}
39 
+{% endautoescape %}
40 
+{% endif %}
41 
+{% block header_script %}
42 
+{% endblock %}
43 
+</head>
44 
+
45 
+<body>
46 
+	<div class="container">
47 
+		{% include "front/_menu.html" %}
48 
+		{% block top_slide %}
49 
+		{% endblock %}
50 
+	</div>
51 
+	<main role="main" class="container">
52 
+        {% include "_messages.html" %}
53 
+		{% block content %}
54 
+		{% endblock %}
55 
+	</main><!-- /.container -->
56 
+	<footer class="blog-footer container">
57 
+      <hr>
58 
+		<p>Blog template built for <a href="https://getbootstrap.com/">Bootstrap</a> by <a href="https://twitter.com/mdo">@mdo</a>.</p>
59 
+		<p>
60 
+		<a href="#">Back to top</a>
61 
+		</p>
62 
+	</footer>
63 
+
64 
+
65 
+<script src="{% static "bower_components/holderjs/holder.min.js" %}"></script>
66 
+<!--
67 
+<script src="{% static "bower_components/popper.js/src/popper.js" %}"></script> -->
68 
+
69 
+    <!--
70 
+     The `defer` attribute causes the callback to execute after the full HTML
71 
+     document has been parsed. For non-blocking uses, avoiding race conditions,
72 
+     and consistent behavior across browsers, consider loading using Promises
73 
+     with https://www.npmjs.com/package/@googlemaps/js-api-loader.
74 
+    -->
75 
+    <script
76 
+      src="https://maps.googleapis.com/maps/api/js?key=AIzaSyAR9ZPbOmfQchxZZn4l71Cxhdet5Ye1DNw&callback=initMap&v=weekly"
77 
+      defer
78 
+    ></script>
79 
+    {% block foot_script %}
80 
+    {% endblock %}
81 
+</body>
82 
+</html>

+ 6 - 0
app/front/templates/front/index.html
Wyświetl plik 

@@ -0,0 +1,6 @@
1 
+{% extends "front/base.html" %}
2 
+
3 
+{% load static %}
4 
+{% block content %}
5 
+Hello World
6 
+{% endblock %}

+ 22 - 0
app/front/templates/front/myStore.html
Wyświetl plik 

@@ -0,0 +1,22 @@
1 
+{% extends "front/base.html" %}
2 
+{% load mptt_tags %}
3 
+{% load static %}
4 
+{% load crispy_forms_tags %}
5 
+
6 
+{% block content %}
7 
+<h1>My Store</h1>
8 
+{{ pos }}
9 
+
10 
+{% for p in primaryMenu %}
11 
+    {{ p.name }}
12 
+{% endfor %}
13 
+
14 
+{% include "front/_menu_ui.html" with menu=primaryMenu %}
15 
+{{ storeInfo | safe }}
16 
+
17 
+<form  method="post">
18 
+    {% csrf_token %}
19 
+    {{ form  | crispy }}
20 
+    <input type="submit" class='btn btn-primary' value="Save">
21 
+</form>
22 
+{% endblock %}

+ 30 - 0
app/front/templates/front/search.html
Wyświetl plik 

@@ -0,0 +1,30 @@
1 
+{% extends "front/storeFront.html" %}
2 
+{% load mptt_tags %}
3 
+{% load static %}
4 
+{% load crispy_forms_tags %}
5 
+{% load pos_filters %}
6 
+
7 
+{% block content %}
8 
+{% if results %}
9 
+<h1 class='text-center mt-4 mb-4'>Search Results</h1>
10 
+<div class='card-columns'>
11 
+{% for r in results %}
12 
+<div class="card">
13 
+    {% if  r|className == "Post" %}
14 
+    <img src="{{ r.featureImage.url }}" class="card-img-top" alt="...">
15 
+    <div class="card-body">
16 
+        <h5 class="card-title">
17 
+            <a href="{% url "front:viewPost"   pid=r.id  %}?cstr={{ r.store.id }}">{{ r.title }}</a>
18 
+        </h5>
19 
+        <p class="card-text">
20 
+        {{ r.description }}</p>
21 
+        <p class="card-text"><small class="text-muted">{{ r.created_at }}</small></p>
22 
+    </div>
23 
+    {% endif %}
24 
+</div>
25 
+{% endfor %}
26 
+</div>
27 
+{% else %}
28 
+<h1 class='text-center mt-4 mb-4'>Your Search not Matched any Records</h1>
29 
+{% endif %}
30 
+{% endblock %}

+ 77 - 0
app/front/templates/front/storeContact.html
Wyświetl plik 

@@ -0,0 +1,77 @@
1 
+{% extends "front/storeFront.html" %}
2 
+{% load mptt_tags %}
3 
+{% load static %}
4 
+{% load crispy_forms_tags %}
5 
+
6 
+{% block content %}
7 
+<h1>{{ storeFront.fullName }}</h1>
8 
+<div class='row'>
9 
+    <div class='col-md-9'>
10 
+        <p>
11 
+        {{ storeFront.description }}
12 
+        </p>
13 
+        <div id='map'>
14 
+        </div>
15 
+    </div>
16 
+    <div class='col-md-3'>
17 
+        <dl>
18 
+            <dt>Address</dt>
19 
+            <dd>
20 
+        {{ storeFront.addressText }}
21 
+            </dd>
22 
+            <dt>Tel</dt>
23 
+            <dd>
24 
+                <a href="callto:{{ storeFront.tel_number }}">
25 
+                    {{ storeFront.tel_number}}
26 
+                </a>
27 
+            </dd>
28 
+            <dt>Fax</dt>
29 
+            <dd>
30 
+                <a href="callto:{{ storeFront.fax_number }}">
31 
+                    {{ storeFront.fax_number }}</a>
32 
+            </dd>
33 
+            <dt>LineID</dt>
34 
+            <dd>
35 
+                <a href="https://line.me/R/{{ storeFront.lineId }}">
36 
+                    {{ storeFront.lineId }}</a>
37 
+            </dd>
38 
+            <dt>Email</dt>
39 
+            <dd>
40 
+                <a href="mailto:{{ storeFront.email }}">
41 
+                    {{ storeFront.email }}</a>
42 
+            </dd>
43 
+        </dl>
44 
+    </div>
45 
+</div>
46 
+{% endblock %}
47 
+
48 
+{% block header_script %}
49 
+<style type='text/css'>
50 
+#map {
51 
+  height: 600px;
52 
+}
53 
+
54 
+</style>
55 
+{% endblock %}
56 
+
57 
+{% block foot_script %}
58 
+    <script type='text/javascript'>
59 
+        let map;
60 
+
61 
+        function initMap() {
62 
+                let latLng = {lat: {{ geo.lat }}, lng: {{ geo.lon }} };
63 
+                map = new google.maps.Map(document.getElementById("map"), {
64 
+                    center: latLng,
65 
+                    zoom: 8,
66 
+                });
67 
+                new google.maps.Marker({
68 
+                        position: latLng,
69 
+                        map,
70 
+                        title: "{{ storeFront.fullName }}",
71 
+                });
72 
+        }
73 
+                //initMap();
74 
+        window.initMap = initMap;
75 
+
76 
+    </script>
77 
+{% endblock %}

+ 34 - 0
app/front/templates/front/storeFront.html
Wyświetl plik 

@@ -0,0 +1,34 @@
1 
+{% extends "front/base.html" %}
2 
+{% load mptt_tags %}
3 
+{% load static %}
4 
+{% load crispy_forms_tags %}
5 
+
6 
+{% block content %}
7 
+{% include "front/_localSearch.html" %}
8 
+{% if storeFront %}
9 
+
10 
+<div class="card mb-3">
11 
+    <div class="row no-gutters">
12 
+        <div class="col-md-4">
13 
+            {% if storeFront.logo %}
14 
+            <img src="{{ storeFront.logo }}" class="rounded-circle" alt="Cinque Terre">
15 
+            {% endif %}
16 
+        </div>
17 
+        <div class="col-md-8">
18 
+            <div class="card-body">
19 
+                <h5 class="card-title">{{ storeFront.fullName }}</h5>
20 
+                <p class="card-text">
21 
+                    {% firstof storeFront.description " " %}
22 
+                </p>
23 
+                <a class='btn btn-primary btn-sm' href="{% url  "front:viewStoreMap" %}?cstr={{ storeFront.storeId }}" target="_blank">View Map</a>
24 
+                <a class='btn btn-danger btn-sm' href="">Follow</a>
25 
+                <a class='btn btn-secondary btn-sm' href="">Share</a>
26 
+            </div>
27 
+        </div>
28 
+    </div>
29 
+</div>
30 
+{% endif %}
31 
+{% include "front/_promotions.html" with objs=promotions %}
32 
+{% include "front/_recs.html" with objs=recs %}
33 
+{% include "front/_reviews.html" with objs=reviews %}
34 
+{% endblock %}

+ 95 - 0
app/front/templates/front/storeMap.html
Wyświetl plik 

@@ -0,0 +1,95 @@
1 
+{% extends "front/storeFront.html" %}
2 
+{% load mptt_tags %}
3 
+{% load static %}
4 
+{% load crispy_forms_tags %}
5 
+
6 
+{% block content %}
7 
+<h1>{{ storeFront.fullName }}</h1>
8 
+<div class='row'>
9 
+    <div class='col-md-9'>
10 
+        <p>
11 
+        {{ storeFront.description }}
12 
+        </p>
13 
+        <form method='post' enctype="multipart/form-data" >
14 
+            {% csrf_token %}
15 
+            <div class="card w-100">
16 
+                 <div class="card-header">Contact Us</div>
17 
+                <div class="card-body">
18 
+            <div class="row">
19 
+            <div class="col-md-6">{{ form.subject | as_crispy_field }}</div>
20 
+            <div class="col-md-6">{{ form.email | as_crispy_field }}</div>
21 
+            <div class="col-md-6">{{ form.tel | as_crispy_field }}</div>
22 
+            <div class="col-md-6">{{ form.lineId | as_crispy_field }}</div>
23 
+            <div class="col-md-12">{{ form.body | as_crispy_field }}</div>
24 
+            <div class="col-md-12">{{ form.messageFile | as_crispy_field }}</div>
25 
+            </div>
26 
+            <input type='submit' value='Save' class='btn btn-primary btn-block'>
27 
+                </div>
28 
+            </div>
29 
+        </form>
30 
+        <hr>
31 
+        <div id='map'>
32 
+        </div>
33 
+    </div>
34 
+    <div class='col-md-3'>
35 
+        <dl>
36 
+            <dt>Address</dt>
37 
+            <dd>
38 
+        {{ storeFront.addressText }}
39 
+            </dd>
40 
+            <dt>Tel</dt>
41 
+            <dd>
42 
+                <a href="callto:{{ storeFront.tel_number }}">
43 
+                    {{ storeFront.tel_number}}
44 
+                </a>
45 
+            </dd>
46 
+            <dt>Fax</dt>
47 
+            <dd>
48 
+                <a href="callto:{{ storeFront.fax_number }}">
49 
+                    {{ storeFront.fax_number }}</a>
50 
+            </dd>
51 
+            <dt>LineID</dt>
52 
+            <dd>
53 
+                <a href="https://line.me/R/{{ storeFront.lineId }}">
54 
+                    {{ storeFront.lineId }}</a>
55 
+            </dd>
56 
+            <dt>Email</dt>
57 
+            <dd>
58 
+                <a href="mailto:{{ storeFront.email }}">
59 
+                    {{ storeFront.email }}</a>
60 
+            </dd>
61 
+        </dl>
62 
+    </div>
63 
+</div>
64 
+{% endblock %}
65 
+
66 
+{% block header_script %}
67 
+<style type='text/css'>
68 
+#map {
69 
+  height: 600px;
70 
+}
71 
+
72 
+</style>
73 
+{% endblock %}
74 
+
75 
+{% block foot_script %}
76 
+    <script type='text/javascript'>
77 
+        let map;
78 
+
79 
+        function initMap() {
80 
+                let latLng = {lat: {{ geo.lat }}, lng: {{ geo.lon }} };
81 
+                map = new google.maps.Map(document.getElementById("map"), {
82 
+                    center: latLng,
83 
+                    zoom: 8,
84 
+                });
85 
+                new google.maps.Marker({
86 
+                        position: latLng,
87 
+                        map,
88 
+                        title: "{{ storeFront.fullName }}",
89 
+                });
90 
+        }
91 
+                //initMap();
92 
+        window.initMap = initMap;
93 
+
94 
+    </script>
95 
+{% endblock %}

+ 18 - 0
app/front/templates/front/viewPost.html
Wyświetl plik 

@@ -0,0 +1,18 @@
1 
+{% extends "front/storeFront.html" %}
2 
+{% load mptt_tags %}
3 
+{% load static %}
4 
+{% load crispy_forms_tags %}
5 
+
6 
+{% block content %}
7 
+<h1>{{ post.title }}</h1>
8 
+<div class='row'>
9 
+    <div class='col-md-9'>
10 
+        <div class='content-wrap'>
11 
+            {{ post.content | safe  }}
12 
+        </div>
13 
+    {% include "front/_relate_menus.html" with objs=post.relateMenus.all %}
14 
+    </div>
15 
+    <div class='col-md-3'>
16 
+    </div>
17 
+</div>
18 
+{% endblock %}

+ 3 - 0
app/front/tests.py
Wyświetl plik 

@@ -0,0 +1,3 @@
1 
+from django.test import TestCase
2 
+
3 
+# Create your tests here.

+ 16 - 0
app/front/urls.py
Wyświetl plik 

@@ -0,0 +1,16 @@
1 
+from django.urls import path
2 
+
3 
+from . import views
4 
+
5 
+urlpatterns = [
6 
+    path('', views.index, name='index'),
7 
+    path('search', views.search, name='search'),
8 
+    path('myStore', views.myStore, name='myStore'),
9 
+    path('store', views.storeFrontView, name='storeFront'),
10 
+    path('store/<storeId>/menus', views.storeMenus, name='viewStoreMenus'),
11 
+    path('menus/<menuId>', views.viewMenu, name='viewMenu'),
12 
+    path('store/posts/<pid>', views.viewPost, name='viewPost'),
13 
+    path('store/map', views.viewStoreMap, name='viewStoreMap'),
14 
+    path('store/contact', views.storeContact, name='storeContact'),
15 
+]
16 
+app_name = 'front'

+ 87 - 0
app/front/views.py
Wyświetl plik 

@@ -0,0 +1,87 @@
1 
+from django.shortcuts import render, redirect, reverse
2 
+from django.contrib.auth.decorators import login_required
3 
+from pos.pos import PosSys
4 
+from pos.storefront import StoreFront
5 
+from django.http import JsonResponse
6 
+from django.contrib import messages
7 
+# Create your views here.
8 
+def index(request):
9 
+    return render(request,'front/index.html')
10 
+
11 
+@login_required
12 
+def myStore(request):
13 
+    pos = PosSys.restoreStore(request.user)
14 
+    storeInfo = pos.uiSys.renderStoreInfo()
15 
+    primaryMenu = pos.uiSys.menu('primary')
16 
+    formInstance = pos.uiSys.form('tableForm')
17 
+
18 
+    print("Instance")
19 
+    print(formInstance)
20 
+
21 
+    if request.method == "POST":
22 
+        formInstance = pos.uiSys.form('tableForm', request=request)
23 
+        if formInstance.is_valid():
24 
+            formInstance.save()
25 
+            print("valid")
26 
+        else:
27 
+            print(formInstance.errors)
28 
+            print("invalide")
29 
+        return redirect('front:myStore')
30 
+
31 
+    return render(request, 'front/mystore.html', {'pos': pos, 'storeInfo': storeInfo, 'primaryMenu': primaryMenu, 'form': formInstance})
32 
+
33 
+def storeFrontView(request):
34 
+    if request.storeFront:
35 
+        menus = request.storeFront.getMenus()[:10]
36 
+        promotions = request.storeFront.getPosts(cat='Promotions')
37 
+        recs = request.storeFront.getPosts(cat="Recommendations")
38 
+        reviews = request.storeFront.getPosts(cat="Reviews")
39 
+        return render(request, 'front/storeFront.html', {'promotions': promotions, 'recs': recs, 'reviews': reviews, 'menus': menus})
40 
+    return JsonResponse({'msg': "Please provide store id in querystring"})
41 
+
42 
+
43 
+def storeMenus(request, storeId):
44 
+    return render(request, 'front/storeMenus.html')
45 
+
46 
+def viewMenu(request, menuId):
47 
+    return render(request, 'front/viewMenu.html')
48 
+
49 
+def viewPost(request, pid):
50 
+    post = request.storeFront.getPostById(pid)
51 
+    return render(request, 'front/viewPost.html', {'post': post})
52 
+
53 
+def viewStoreMap(request):
54 
+    location = request.storeFront.location
55 
+    form = request.storeFront.messageForm()
56 
+    if request.method == 'POST':
57 
+        form = request.storeFront.messageForm(request=request)
58 
+        if form.is_valid():
59 
+            o = form.save(commit=False)
60 
+            o.store = request.storeFront.store
61 
+            o.save()
62 
+            messages.success(request, 'Thank you for your contact')
63 
+            return redirect(reverse('front:viewStoreMap')+f"?cstr={request.storeFront.storeId}")
64 
+    return render(request, 'front/storeMap.html', {'geo': location[1], 'address': location[0], 'form': form})
65 
+
66 
+
67 
+def storeContact(request):
68 
+    form = request.storeFront.messageForm()
69 
+    if request.method == 'POST':
70 
+        form = request.storeFront.messageForm(request=request)
71 
+        if form.is_valid():
72 
+            o = form.save()
73 
+            messages.success(request, 'Thank you for your contact')
74 
+            return redirect(reverse('front:storeContact')+"?cstr="+request.storeFront.storeId)
75 
+    return render(request, 'front/storeContact.html', {'form': form})
76 
+
77 
+def search(request):
78 
+    results  = None
79 
+    q = request.GET.get('q', '')
80 
+    print(q)
81 
+    if request.storeFront:
82 
+        results = request.storeFront.search(q=q)
83 
+    else:
84 
+        results = StoreFront.globalSearch(q)
85 
+        print(results)
86 
+    return render(request, 'front/search.html', {'results': results})
87 
+

+ 28 - 0
app/key.pem
Wyświetl plik 

@@ -0,0 +1,28 @@
1 
+-----BEGIN PRIVATE KEY-----
2 
+MIIEvwIBADANBgkqhkiG9w0BAQEFAASCBKkwggSlAgEAAoIBAQDM7eQObxKic7Y/
3 
++lI5CYU9iiPb5/PycR3myz68v95FzkFomyrXrnWCUh07JRfXcHgTS+JMXRprpI/2
4 
+NktTqU+W4nBblRgK5VJbrvAvQS8LzZMGkHPaEwa4LoNykbScmDNjTiS7PSYlqpa1
5 
+YPgAyrcE7CAE3LY+sHjlxQYEF7du+wKKn3KRVby8cRYqAel2dm9Ridttt5r2MNH+
6 
+cHRwN4p3krjlX8u/YQIEAZrbvYL1r26pe7MhxUWx05v2yzpg3KJKzUAl5dNXXozm
7 
+7pmVU33khT0AepbF5MJVjIZlZm2DVcPswH8zbb+YNSNmDV90re/af5EXHKj8Uag0
8 
+TrOIALPrAgMBAAECggEBALGtmMwC9c8wMFYsPVoCrSl8OjcSV2pfNSPEGLMiUB+K
9 
+AyAlWPID6xKBC6MaOB+s/g8M/jpjhuLJnaBF1u3EoKMb1XsyO9RGnC+t78Wo6Jd9
10 
+N/q7CBeN44eRnJqbRlN3iyaQvDwzen2x+FVuq9hT6nc0G1bb3o9gBpKBTwQBZCOt
11 
+o4djb1dkSx3qB917VC4+0yK1pknliANxxdVcq8ZHfcY3G7xkgV8crn5UB95HmFAp
12 
+9sJ1XxpXHqoD+lgLakQKhgHOTqQdb0mbMOPkHA5Zw2YRV89FaYc2m+if3rWyaK4z
13 
+yk9hSd8/LK71rmYO0YlVDGwWkhUkDAD3q/T20kpeFxECgYEA/Uf5PqKc3Z9k6bTp
14 
+3JnfMNrXY4Nk1pE8apZF1Saho8mKsCX0Vm3x4DC8xZgwE5gvMusopHWp/EoCvMet
15 
+5/EJpNXzjLZB35IdAiGCYQPLEQTQjmCtsQIRoknhZc9nKPw/iWlev68Yrrf16jkj
16 
+9FrvyyFEWQ4wUgQftPC/7u5Ad58CgYEAzyELXIxtXpXdjch0X9L7IRULuQ4Rs7q3
17 
+7+TvFYd5P0X2zBBJ7AHjamaru7C+ytnT7bpSudRv36k9KySsHtqGKl9uSJrGGJeW
18 
+kqQ9wOorwu9PDVvdL2DxG31bK5b+BcQhqSPYJEVe3FpETJgtbFNIIf9LEVg73v91
19 
+iNiNqbwSEDUCgYEAq7poCQrSVwWisz7BrZv6kzJeBY/qB/1TPGWFFZ9qyxV0Xjht
20 
+sUg8TihdZY/pUO/HWLvOw6svxOodbwfoJrHsOwIBbu+IPGDiIDa+Iq8iuPhNu6tb
21 
+OP/RGvsCwzfblxNotO9nmYnLr3L1Xoi9kwkxOsXkhIk1Q/ad1N3DFOofdbsCgYAq
22 
+X2kymqu5INF9MtfTzpZ/Uw3d4qnuabE9S0k5z0gXkJmHb4Gf3VcHqk9RizvMxbkc
23 
+NfS8fWARkk6oJ81qVmwB+RnXkooZ99De2OilMYKYU1qJshRSn/NTG1buWOpIhbIZ
24 
+JvMNoH9idrjoLm2EbpkgE1jpCHLfEMWbpCl+4rGTTQKBgQCvOqqWpwS0fJFwbx1h
25 
+F+jcLf9eQHD5B/kh91f4dvB3Uywi2vP5pkAPkRS2dd6z5ZKNuHCCUYizKDR6d20g
26 
+EnGUuN96uyby4vT5Xar1/6IWcJl2VpjHAUjGAKw2PHRA4ti+RO7oo4TP9J/tF/Ec
27 
+xoO0p1jYKttMAiKBlw10sNBZmg==
28 
+-----END PRIVATE KEY-----

+ 22 - 0
app/manage.py
Wyświetl plik 

@@ -0,0 +1,22 @@
1 
+#!/usr/bin/env python
2 
+"""Django's command-line utility for administrative tasks."""
3 
+import os
4 
+import sys
5 
+
6 
+
7 
+def main():
8 
+    """Run administrative tasks."""
9 
+    os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'simpliPos.settings')
10 
+    try:
11 
+        from django.core.management import execute_from_command_line
12 
+    except ImportError as exc:
13 
+        raise ImportError(
14 
+            "Couldn't import Django. Are you sure it's installed and "
15 
+            "available on your PYTHONPATH environment variable? Did you "
16 
+            "forget to activate a virtual environment?"
17 
+        ) from exc
18 
+    execute_from_command_line(sys.argv)
19 
+
20 
+
21 
+if __name__ == '__main__':
22 
+    main()

BIN
app/mycert.cer
Wyświetl plik


+ 0 - 0
app/pos/__init__.py
Wyświetl plik


+ 70 - 0
app/pos/admin.py
Wyświetl plik 

@@ -0,0 +1,70 @@
1 
+from django.contrib import admin
2 
+from .models import Store, MenuItem, Setting, StoreFile, Table, BookingTable, Order,  MenuFile, OrderItem, UIMenu, PostCategory, Post
3 
+from django_better_admin_arrayfield.admin.mixins import DynamicArrayMixin
4 
+from mptt.admin import MPTTModelAdmin
5 
+from django_admin_hstore_widget.forms import HStoreFormField
6 
+
7 
+from django.contrib.postgres.fields import HStoreField, ArrayField
8 
+
9 
+from django import forms
10 
+
11 
+
12 
+
13 
+
14 
+# Register your models here.
15 
+
16 
+class StoreFileAdmin(admin.TabularInline):
17 
+    model = StoreFile
18 
+
19 
+class MenuItemAdmin(admin.StackedInline):
20 
+    model = MenuItem
21 
+
22 
+class OrderItemAdmin(admin.TabularInline):
23 
+    model = OrderItem
24 
+
25 
+class StoreAdmin(admin.ModelAdmin):
26 
+   inlines = [StoreFileAdmin, MenuItemAdmin]
27 
+   formfield_overrides = {
28 
+        HStoreField: {'widget': HStoreFormField},
29 
+    }
30 
+
31 
+class SettingAdmin(admin.ModelAdmin):
32 
+    pass
33 
+
34 
+class OrderAdmin(admin.ModelAdmin):
35 
+   inlines = [OrderItemAdmin,]
36 
+
37 
+
38 
+class SettingAdminForm(forms.ModelForm):
39 
+    data = HStoreFormField()
40 
+
41 
+    class Meta:
42 
+       model = Setting
43 
+       exclude = ()
44 
+
45 
+@admin.register(Setting)
46 
+class SettingAdmin(admin.ModelAdmin):
47 
+    form = SettingAdminForm
48 
+
49 
+@admin.register(Post)
50 
+class PostAdmin(admin.ModelAdmin):
51 
+    list_display = ('title', 'tag_list', 'cats', 'created_at', 'store', 'featureImage')
52 
+    save_as = True
53 
+
54 
+    def tag_list(self, obj):
55 
+        return u", ".join(o.name for o in obj.tags.all())
56 
+
57 
+
58 
+admin.site.register(Store, StoreAdmin)
59 
+admin.site.register(MenuItem)
60 
+#admin.site.register(Setting, SettingAdmin)
61 
+admin.site.register(StoreFile)
62 
+admin.site.register(Table)
63 
+admin.site.register(BookingTable)
64 
+admin.site.register(Order, OrderAdmin)
65 
+admin.site.register(MenuFile)
66 
+admin.site.register(UIMenu, MPTTModelAdmin)
67 
+#admin.site.register(Post)
68 
+admin.site.register(PostCategory, MPTTModelAdmin)
69 
+
70 
+

+ 6 - 0
app/pos/apps.py
Wyświetl plik 

@@ -0,0 +1,6 @@
1 
+from django.apps import AppConfig
2 
+
3 
+
4 
+class PosConfig(AppConfig):
5 
+    default_auto_field = 'django.db.models.BigAutoField'
6 
+    name = 'pos'

+ 53 - 0
app/pos/context_processors.py
Wyświetl plik 

@@ -0,0 +1,53 @@
1 
+from django.conf import settings
2 
+from .pos import PosSys
3 
+from .storefront import StoreFront
4 
+import json
5 
+from .models import Store
6 
+
7 
+def pos(request):
8 
+    store = Store.objects.get(pk=settings.STORE_ID)
9 
+    cstr = request.GET.get('cstr', None)
10 
+    if cstr:
11 
+        storeFront = StoreFront(int(cstr))
12 
+    else:
13 
+        storeFront = None
14 
+
15 
+    if hasattr(request, 'user') and request.user.is_authenticated:
16 
+        user = request.user
17 
+        pos = PosSys.restoreStore(user)
18 
+        storeInfo = pos.uiSys.renderStoreInfo()
19 
+
20 
+        #ms = jso.loads(pos.settingSys.get('menus'))
21 
+        ms = []
22 
+        try:
23 
+            ms = json.loads(pos.settingSys.get('menus'))
24 
+        except TypeError:
25 
+            ms = []
26 
+
27 
+        print(ms)
28 
+        print(type(ms))
29 
+        temp = []
30 
+        for i in ms:
31 
+            temp.append({'title': i['title'], 'menu': pos.uiSys.menu(i['name'])})
32 
+            #ms.append(pos.uiSys.menu(m))
33 
+
34 
+        ctx  = {
35 
+            'pos': pos,
36 
+            'info': storeInfo,
37 
+            'menus': temp,
38 
+            'primaryMenu': pos.uiSys.menu('primary'),
39 
+            'store': store,
40 
+            'storeFront': storeFront,
41 
+        }
42 
+        return ctx
43 
+    else:
44 
+        ctx = {
45 
+            'pos': None,
46 
+            'info': None,
47 
+            'menus': [],
48 
+            'store': store,
49 
+            'storeFront': storeFront,
50 
+        }
51 
+        return ctx
52 
+
53 
+

+ 159 - 0
app/pos/forms.py
Wyświetl plik 

@@ -0,0 +1,159 @@
1 
+from pos.models import MenuItem, Store, Setting, Table, BookingTable, Order, OrderItem, UIMenu, Post, PostCategory, Customer, Code, Profile, Message
2 
+
3 
+from django.forms import ModelForm
4 
+import django_filters
5 
+
6 
+from django.forms import BaseInlineFormSet, DateField, TimeField, TextInput, ModelMultipleChoiceField, CheckboxSelectMultiple
7 
+
8 
+from mptt.forms import TreeNodeMultipleChoiceField
9 
+from django_editorjs_fields import EditorJsWidget
10 
+from django.contrib.auth.models import User
11 
+from django_google_maps.widgets import GoogleMapsAddressWidget
12 
+
13 
+class TableForm(ModelForm):
14 
+    class Meta:
15 
+        model = Table
16 
+        fields = ('code', 'nSeats', 'occupy',)
17 
+
18 
+class MessageForm(ModelForm):
19 
+    class Meta:
20 
+        model = Message
21 
+        fields = ('subject', 'email', 'tel', 'body', 'messageFile', 'lineId', 'reply', 'parent', )
22 
+
23 
+class UIMenuForm(ModelForm):
24 
+    class Meta:
25 
+        model = UIMenu
26 
+        fields = ('name', 'parent', 'group', 'url', 'icon', 'nOrder', )
27 
+
28 
+class OrderForm(ModelForm):
29 
+    class Meta:
30 
+        model = Order
31 
+        fields = '__all__'
32 
+
33 
+class PostForm(ModelForm):
34 
+    #category = TreeNodeMultipleChoiceField(queryset=PostCategory.objects.all())
35 
+    '''
36 
+    relateMenus = ModelMultipleChoiceField(
37 
+        queryset=MenuItem.objects.all(),
38 
+        widget=CheckboxSelectMultiple,
39 
+        required=False)
40 
+    '''
41 
+
42 
+    class Meta:
43 
+        model = Post
44 
+        fields = ('featureImage', 'title', 'content', 'description', 'category', 'tags', 'relateMenus' )
45 
+
46 
+class CustomerForm(ModelForm):
47 
+    #category = TreeNodeMultipleChoiceField(queryset=PostCategory.objects.all())
48 
+
49 
+    class Meta:
50 
+        model = Customer
51 
+        fields = ('fullName', 'email', 'lineId', 'gender', )
52 
+
53 
+class BookingForm(ModelForm):
54 
+    onDate = DateField(
55 
+        widget=TextInput(
56 
+            attrs={'type': 'date'}
57 
+        )
58 
+    )
59 
+    onTime = TimeField(
60 
+        widget=TextInput(
61 
+            attrs={'type': 'time'}
62 
+        )
63 
+    )
64 
+    class Meta:
65 
+        model = BookingTable
66 
+        fields = ('table', 'onDate',  'onTime', 'note',)
67 
+
68 
+class MenuItemForm(ModelForm):
69 
+    class Meta:
70 
+        model = MenuItem
71 
+        fields = ['featureImage', 'name', ]
72 
+
73 
+class StoreForm(ModelForm):
74 
+    class Meta:
75 
+        model = Store
76 
+        fields = ['logo', 'name','description', 'addressText', 'province','address',  'phone_number', 'fax_number', 'lineId',  'email', 'geolocation',  'storeType']
77 
+
78 
+        widgets = {
79 
+            "address": GoogleMapsAddressWidget,
80 
+        }
81 
+
82 
+class OrderItemFormSet(BaseInlineFormSet):
83 
+    def __init__(self, other_model_queryset, *args, **kwargs):
84 
+        super(BaseInlineFormSet, self).__init__(*args)
85 
+
86 
+        for form in self.forms:
87 
+            form.fields['item'].queryset = other_model_queryset
88 
+
89 
+
90 
+formMap = {
91 
+    'tableForm': TableForm
92 
+}
93 
+
94 
+class OrderFilter(django_filters.FilterSet):
95 
+    note = django_filters.CharFilter(lookup_expr='iexact')
96 
+
97 
+    class Meta:
98 
+        model = Order
99 
+        fields = ['table', 'note']
100 
+
101 
+class MenuItemFilter(django_filters.FilterSet):
102 
+    class Meta:
103 
+        model = MenuItem
104 
+        fields = ['name', ]
105 
+
106 
+class StoreFilter(django_filters.FilterSet):
107 
+    class Meta:
108 
+        model = Store
109 
+        fields = ('name', 'address', 'province','storeType')
110 
+
111 
+class BookingFilter(django_filters.FilterSet):
112 
+    class Meta:
113 
+        model = BookingTable
114 
+        fields = ('table', 'onDate', 'note', )
115 
+
116 
+class CustomerFilter(django_filters.FilterSet):
117 
+    class Meta:
118 
+        model = Customer
119 
+        fields = ('fullName', 'email', 'lineId', 'gender', 'created_at', )
120 
+
121 
+class TableFilter(django_filters.FilterSet):
122 
+    class Meta:
123 
+        model = Table
124 
+        fields = ('code', 'nSeats', 'occupy', )
125 
+
126 
+class UIMenuFilter(django_filters.FilterSet):
127 
+    class Meta:
128 
+        model = UIMenu
129 
+        fields = ('name', 'parent', 'group', 'url', 'icon','nOrder')
130 
+
131 
+class MessageFilter(django_filters.FilterSet):
132 
+    class Meta:
133 
+        model = Message
134 
+        fields = ('subject', 'email', 'tel', 'body', 'reply', 'parent', 'created_at',  )
135 
+
136 
+class PostFilter(django_filters.FilterSet):
137 
+    class Meta:
138 
+        model = Post
139 
+        fields = ('title', 'content', )
140 
+
141 
+class UserFilter(django_filters.FilterSet):
142 
+    profile__role = django_filters.ChoiceFilter(label="Role", choices=Profile.ROLE_CHOICES)
143 
+
144 
+    class Meta:
145 
+        model = User
146 
+        fields = ('username', 'first_name', 'last_name', 'email', )
147 
+
148 
+
149 
+
150 
+
151 
+class CodeForm(ModelForm):
152 
+    class Meta:
153 
+        model = Code
154 
+        exclude = ['store', 'owner',]
155 
+        widgets = {
156 
+            'body_editorjs': EditorJsWidget(config={'minHeight': 100}),
157 
+            'body_editorjs_text': EditorJsWidget(plugins=["@editorjs/image", "@editorjs/header"]),
158 
+        }
159 
+

+ 22 - 0
app/pos/middleware.py
Wyświetl plik 

@@ -0,0 +1,22 @@
1 
+from django.utils.deprecation import MiddlewareMixin
2 
+from .pos import PosSys
3 
+from .storefront import StoreFront
4 
+
5 
+class PosMiddleware(MiddlewareMixin):
6 
+    def process_request(self, request):
7 
+        if not hasattr(request, "user"):
8 
+            raise ImproperlyConfigured(
9 
+                "The Django POS middleware requires auth middleware")
10 
+        user = request.user
11 
+        if user.is_authenticated:
12 
+            if not hasattr(request, 'pos') or request.pos is None:
13 
+                pos = PosSys.restoreStore(user)
14 
+                request.pos = pos
15 
+        else:
16 
+            request.pos = None
17 
+
18 
+        cstr  = request.GET.get('cstr', None)
19 
+        if cstr:
20 
+            request.storeFront = StoreFront(int(cstr))
21 
+        else:
22 
+            request.storeFront = None

+ 22 - 0
app/pos/migrations/0001_initial.py
Wyświetl plik 

@@ -0,0 +1,22 @@
1 
+# Generated by Django 3.2.13 on 2022-05-14 08:48
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    initial = True
9 
+
10 
+    dependencies = [
11 
+    ]
12 
+
13 
+    operations = [
14 
+        migrations.CreateModel(
15 
+            name='MenuItem',
16 
+            fields=[
17 
+                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
18 
+                ('name', models.CharField(max_length=100)),
19 
+                ('tagline', models.TextField()),
20 
+            ],
21 
+        ),
22 
+    ]

+ 31 - 0
app/pos/migrations/0002_setting_store.py
Wyświetl plik 

@@ -0,0 +1,31 @@
1 
+# Generated by Django 3.2.13 on 2022-05-17 06:15
2 
+
3 
+import django.contrib.postgres.fields.hstore
4 
+from django.db import migrations, models
5 
+import django.db.models.deletion
6 
+
7 
+from django.contrib.postgres.operations import HStoreExtension
8 
+
9 
+class Migration(migrations.Migration):
10 
+
11 
+    dependencies = [
12 
+        ('pos', '0001_initial'),
13 
+    ]
14 
+
15 
+    operations = [
16 
+        HStoreExtension(),
17 
+        migrations.CreateModel(
18 
+            name='Store',
19 
+            fields=[
20 
+                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
21 
+                ('name', models.CharField(max_length=100)),
22 
+            ],
23 
+        ),
24 
+        migrations.CreateModel(
25 
+            name='Setting',
26 
+            fields=[
27 
+                ('store', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='pos.store')),
28 
+                ('data', django.contrib.postgres.fields.hstore.HStoreField()),
29 
+            ],
30 
+        ),
31 
+    ]

+ 19 - 0
app/pos/migrations/0003_alter_setting_data.py
Wyświetl plik 

@@ -0,0 +1,19 @@
1 
+# Generated by Django 3.2.13 on 2022-05-17 06:55
2 
+
3 
+import django.contrib.postgres.fields.hstore
4 
+from django.db import migrations
5 
+
6 
+
7 
+class Migration(migrations.Migration):
8 
+
9 
+    dependencies = [
10 
+        ('pos', '0002_setting_store'),
11 
+    ]
12 
+
13 
+    operations = [
14 
+        migrations.AlterField(
15 
+            model_name='setting',
16 
+            name='data',
17 
+            field=django.contrib.postgres.fields.hstore.HStoreField(blank=True),
18 
+        ),
19 
+    ]

+ 31 - 0
app/pos/migrations/0004_auto_20220517_1613.py
Wyświetl plik 

@@ -0,0 +1,31 @@
1 
+# Generated by Django 3.2.13 on 2022-05-17 09:13
2 
+
3 
+import django.contrib.postgres.fields
4 
+from django.db import migrations, models
5 
+import django.db.models.deletion
6 
+
7 
+
8 
+class Migration(migrations.Migration):
9 
+
10 
+    dependencies = [
11 
+        ('pos', '0003_alter_setting_data'),
12 
+    ]
13 
+
14 
+    operations = [
15 
+        migrations.AddField(
16 
+            model_name='menuitem',
17 
+            name='photos',
18 
+            field=django.contrib.postgres.fields.ArrayField(base_field=models.FileField(upload_to='uploads/%Y/%m/%d/'), blank=True, null=True, size=8),
19 
+        ),
20 
+        migrations.AddField(
21 
+            model_name='menuitem',
22 
+            name='store',
23 
+            field=models.ForeignKey(default=None, on_delete=django.db.models.deletion.CASCADE, to='pos.store'),
24 
+            preserve_default=False,
25 
+        ),
26 
+        migrations.AddField(
27 
+            model_name='store',
28 
+            name='photos',
29 
+            field=django.contrib.postgres.fields.ArrayField(base_field=models.FileField(upload_to='uploads/%Y/%m/%d/'), blank=True, null=True, size=8),
30 
+        ),
31 
+    ]

+ 38 - 0
app/pos/migrations/0005_auto_20220517_2027.py
Wyświetl plik 

@@ -0,0 +1,38 @@
1 
+# Generated by Django 3.2.13 on 2022-05-17 13:27
2 
+
3 
+from django.db import migrations, models
4 
+import django.db.models.deletion
5 
+import taggit.managers
6 
+
7 
+
8 
+class Migration(migrations.Migration):
9 
+
10 
+    dependencies = [
11 
+        ('taggit', '0005_auto_20220424_2025'),
12 
+        ('pos', '0004_auto_20220517_1613'),
13 
+    ]
14 
+
15 
+    operations = [
16 
+        migrations.RemoveField(
17 
+            model_name='menuitem',
18 
+            name='photos',
19 
+        ),
20 
+        migrations.CreateModel(
21 
+            name='StoreFile',
22 
+            fields=[
23 
+                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
24 
+                ('storeFile', models.FileField(upload_to='uploads/%Y/%m/%d/')),
25 
+                ('store', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='pos.store')),
26 
+                ('tags', taggit.managers.TaggableManager(help_text='A comma-separated list of tags.', through='taggit.TaggedItem', to='taggit.Tag', verbose_name='Tags')),
27 
+            ],
28 
+        ),
29 
+        migrations.CreateModel(
30 
+            name='MenuFile',
31 
+            fields=[
32 
+                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
33 
+                ('menuFile', models.FileField(upload_to='uploads/%Y/%m/%d/')),
34 
+                ('store', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='pos.store')),
35 
+                ('tags', taggit.managers.TaggableManager(help_text='A comma-separated list of tags.', through='taggit.TaggedItem', to='taggit.Tag', verbose_name='Tags')),
36 
+            ],
37 
+        ),
38 
+    ]

+ 17 - 0
app/pos/migrations/0006_remove_store_photos.py
Wyświetl plik 

@@ -0,0 +1,17 @@
1 
+# Generated by Django 3.2.13 on 2022-05-17 13:28
2 
+
3 
+from django.db import migrations
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0005_auto_20220517_2027'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.RemoveField(
14 
+            model_name='store',
15 
+            name='photos',
16 
+        ),
17 
+    ]

+ 25 - 0
app/pos/migrations/0007_auto_20220517_2038.py
Wyświetl plik 

@@ -0,0 +1,25 @@
1 
+# Generated by Django 3.2.13 on 2022-05-17 13:38
2 
+
3 
+from django.db import migrations, models
4 
+import django.utils.timezone
5 
+
6 
+
7 
+class Migration(migrations.Migration):
8 
+
9 
+    dependencies = [
10 
+        ('pos', '0006_remove_store_photos'),
11 
+    ]
12 
+
13 
+    operations = [
14 
+        migrations.AddField(
15 
+            model_name='menuitem',
16 
+            name='created_at',
17 
+            field=models.DateTimeField(auto_now_add=True, default=django.utils.timezone.now),
18 
+            preserve_default=False,
19 
+        ),
20 
+        migrations.AddField(
21 
+            model_name='menuitem',
22 
+            name='updated_at',
23 
+            field=models.DateTimeField(auto_now=True),
24 
+        ),
25 
+    ]

+ 58 - 0
app/pos/migrations/0008_auto_20220517_2040.py
Wyświetl plik 

@@ -0,0 +1,58 @@
1 
+# Generated by Django 3.2.13 on 2022-05-17 13:40
2 
+
3 
+from django.db import migrations, models
4 
+import django.utils.timezone
5 
+
6 
+
7 
+class Migration(migrations.Migration):
8 
+
9 
+    dependencies = [
10 
+        ('pos', '0007_auto_20220517_2038'),
11 
+    ]
12 
+
13 
+    operations = [
14 
+        migrations.AddField(
15 
+            model_name='menufile',
16 
+            name='created_at',
17 
+            field=models.DateTimeField(auto_now_add=True, default=django.utils.timezone.now),
18 
+            preserve_default=False,
19 
+        ),
20 
+        migrations.AddField(
21 
+            model_name='menufile',
22 
+            name='updated_at',
23 
+            field=models.DateTimeField(auto_now=True),
24 
+        ),
25 
+        migrations.AddField(
26 
+            model_name='setting',
27 
+            name='created_at',
28 
+            field=models.DateTimeField(auto_now_add=True, default=django.utils.timezone.now),
29 
+            preserve_default=False,
30 
+        ),
31 
+        migrations.AddField(
32 
+            model_name='setting',
33 
+            name='updated_at',
34 
+            field=models.DateTimeField(auto_now=True),
35 
+        ),
36 
+        migrations.AddField(
37 
+            model_name='store',
38 
+            name='created_at',
39 
+            field=models.DateTimeField(auto_now_add=True, default=django.utils.timezone.now),
40 
+            preserve_default=False,
41 
+        ),
42 
+        migrations.AddField(
43 
+            model_name='store',
44 
+            name='updated_at',
45 
+            field=models.DateTimeField(auto_now=True),
46 
+        ),
47 
+        migrations.AddField(
48 
+            model_name='storefile',
49 
+            name='created_at',
50 
+            field=models.DateTimeField(auto_now_add=True, default=django.utils.timezone.now),
51 
+            preserve_default=False,
52 
+        ),
53 
+        migrations.AddField(
54 
+            model_name='storefile',
55 
+            name='updated_at',
56 
+            field=models.DateTimeField(auto_now=True),
57 
+        ),
58 
+    ]

+ 55 - 0
app/pos/migrations/0009_bookingtable_order_table.py
Wyświetl plik 

@@ -0,0 +1,55 @@
1 
+# Generated by Django 3.2.13 on 2022-05-17 15:57
2 
+
3 
+from django.db import migrations, models
4 
+import django.db.models.deletion
5 
+
6 
+
7 
+class Migration(migrations.Migration):
8 
+
9 
+    dependencies = [
10 
+        ('pos', '0008_auto_20220517_2040'),
11 
+    ]
12 
+
13 
+    operations = [
14 
+        migrations.CreateModel(
15 
+            name='Table',
16 
+            fields=[
17 
+                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
18 
+                ('created_at', models.DateTimeField(auto_now_add=True)),
19 
+                ('updated_at', models.DateTimeField(auto_now=True)),
20 
+                ('nSeats', models.IntegerField(default=1)),
21 
+                ('occupy', models.BooleanField(default=False)),
22 
+                ('store', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='pos.store')),
23 
+            ],
24 
+            options={
25 
+                'abstract': False,
26 
+            },
27 
+        ),
28 
+        migrations.CreateModel(
29 
+            name='Order',
30 
+            fields=[
31 
+                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
32 
+                ('created_at', models.DateTimeField(auto_now_add=True)),
33 
+                ('updated_at', models.DateTimeField(auto_now=True)),
34 
+                ('items', models.ManyToManyField(to='pos.MenuItem')),
35 
+                ('table', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='pos.table')),
36 
+            ],
37 
+            options={
38 
+                'abstract': False,
39 
+            },
40 
+        ),
41 
+        migrations.CreateModel(
42 
+            name='BookingTable',
43 
+            fields=[
44 
+                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
45 
+                ('created_at', models.DateTimeField(auto_now_add=True)),
46 
+                ('updated_at', models.DateTimeField(auto_now=True)),
47 
+                ('onDate', models.DateTimeField()),
48 
+                ('note', models.TextField(blank=True, null=True)),
49 
+                ('table', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='pos.table')),
50 
+            ],
51 
+            options={
52 
+                'abstract': False,
53 
+            },
54 
+        ),
55 
+    ]

+ 18 - 0
app/pos/migrations/0010_table_code.py
Wyświetl plik 

@@ -0,0 +1,18 @@
1 
+# Generated by Django 3.2.13 on 2022-05-17 16:02
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0009_bookingtable_order_table'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AddField(
14 
+            model_name='table',
15 
+            name='code',
16 
+            field=models.CharField(default='N\\A', max_length=100),
17 
+        ),
18 
+    ]

+ 32 - 0
app/pos/migrations/0011_auto_20220517_2307.py
Wyświetl plik 

@@ -0,0 +1,32 @@
1 
+# Generated by Django 3.2.13 on 2022-05-17 16:07
2 
+
3 
+from django.db import migrations, models
4 
+import django.db.models.deletion
5 
+
6 
+
7 
+class Migration(migrations.Migration):
8 
+
9 
+    dependencies = [
10 
+        ('pos', '0010_table_code'),
11 
+    ]
12 
+
13 
+    operations = [
14 
+        migrations.RemoveField(
15 
+            model_name='order',
16 
+            name='items',
17 
+        ),
18 
+        migrations.CreateModel(
19 
+            name='OrderItem',
20 
+            fields=[
21 
+                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
22 
+                ('created_at', models.DateTimeField(auto_now_add=True)),
23 
+                ('updated_at', models.DateTimeField(auto_now=True)),
24 
+                ('qty', models.IntegerField(default=1)),
25 
+                ('item', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='pos.menuitem')),
26 
+                ('order', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='pos.order')),
27 
+            ],
28 
+            options={
29 
+                'abstract': False,
30 
+            },
31 
+        ),
32 
+    ]

+ 18 - 0
app/pos/migrations/0012_alter_menuitem_tagline.py
Wyświetl plik 

@@ -0,0 +1,18 @@
1 
+# Generated by Django 3.2.13 on 2022-05-17 16:12
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0011_auto_20220517_2307'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AlterField(
14 
+            model_name='menuitem',
15 
+            name='tagline',
16 
+            field=models.TextField(blank=True, null=True),
17 
+        ),
18 
+    ]

+ 103 - 0
app/pos/migrations/0013_auto_20220518_1430.py
Wyświetl plik 

@@ -0,0 +1,103 @@
1 
+# Generated by Django 3.2.13 on 2022-05-18 07:30
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0012_alter_menuitem_tagline'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AddField(
14 
+            model_name='bookingtable',
15 
+            name='inProcess',
16 
+            field=models.CharField(blank=True, max_length=100, null=True),
17 
+        ),
18 
+        migrations.AddField(
19 
+            model_name='bookingtable',
20 
+            name='status',
21 
+            field=models.CharField(choices=[('process', 'Process'), ('fn', 'Finished')], default='process', max_length=100),
22 
+        ),
23 
+        migrations.AddField(
24 
+            model_name='menufile',
25 
+            name='inProcess',
26 
+            field=models.CharField(blank=True, max_length=100, null=True),
27 
+        ),
28 
+        migrations.AddField(
29 
+            model_name='menufile',
30 
+            name='status',
31 
+            field=models.CharField(choices=[('process', 'Process'), ('fn', 'Finished')], default='process', max_length=100),
32 
+        ),
33 
+        migrations.AddField(
34 
+            model_name='menuitem',
35 
+            name='inProcess',
36 
+            field=models.CharField(blank=True, max_length=100, null=True),
37 
+        ),
38 
+        migrations.AddField(
39 
+            model_name='menuitem',
40 
+            name='status',
41 
+            field=models.CharField(choices=[('process', 'Process'), ('fn', 'Finished')], default='process', max_length=100),
42 
+        ),
43 
+        migrations.AddField(
44 
+            model_name='order',
45 
+            name='inProcess',
46 
+            field=models.CharField(blank=True, max_length=100, null=True),
47 
+        ),
48 
+        migrations.AddField(
49 
+            model_name='order',
50 
+            name='status',
51 
+            field=models.CharField(choices=[('process', 'Process'), ('fn', 'Finished')], default='process', max_length=100),
52 
+        ),
53 
+        migrations.AddField(
54 
+            model_name='orderitem',
55 
+            name='inProcess',
56 
+            field=models.CharField(blank=True, max_length=100, null=True),
57 
+        ),
58 
+        migrations.AddField(
59 
+            model_name='orderitem',
60 
+            name='status',
61 
+            field=models.CharField(choices=[('process', 'Process'), ('fn', 'Finished')], default='process', max_length=100),
62 
+        ),
63 
+        migrations.AddField(
64 
+            model_name='setting',
65 
+            name='inProcess',
66 
+            field=models.CharField(blank=True, max_length=100, null=True),
67 
+        ),
68 
+        migrations.AddField(
69 
+            model_name='setting',
70 
+            name='status',
71 
+            field=models.CharField(choices=[('process', 'Process'), ('fn', 'Finished')], default='process', max_length=100),
72 
+        ),
73 
+        migrations.AddField(
74 
+            model_name='store',
75 
+            name='inProcess',
76 
+            field=models.CharField(blank=True, max_length=100, null=True),
77 
+        ),
78 
+        migrations.AddField(
79 
+            model_name='store',
80 
+            name='status',
81 
+            field=models.CharField(choices=[('process', 'Process'), ('fn', 'Finished')], default='process', max_length=100),
82 
+        ),
83 
+        migrations.AddField(
84 
+            model_name='storefile',
85 
+            name='inProcess',
86 
+            field=models.CharField(blank=True, max_length=100, null=True),
87 
+        ),
88 
+        migrations.AddField(
89 
+            model_name='storefile',
90 
+            name='status',
91 
+            field=models.CharField(choices=[('process', 'Process'), ('fn', 'Finished')], default='process', max_length=100),
92 
+        ),
93 
+        migrations.AddField(
94 
+            model_name='table',
95 
+            name='inProcess',
96 
+            field=models.CharField(blank=True, max_length=100, null=True),
97 
+        ),
98 
+        migrations.AddField(
99 
+            model_name='table',
100 
+            name='status',
101 
+            field=models.CharField(choices=[('process', 'Process'), ('fn', 'Finished')], default='process', max_length=100),
102 
+        ),
103 
+    ]

+ 18 - 0
app/pos/migrations/0014_order_note.py
Wyświetl plik 

@@ -0,0 +1,18 @@
1 
+# Generated by Django 3.2.13 on 2022-05-19 14:23
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0013_auto_20220518_1430'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AddField(
14 
+            model_name='order',
15 
+            name='note',
16 
+            field=models.TextField(blank=True, null=True),
17 
+        ),
18 
+    ]

+ 32 - 0
app/pos/migrations/0015_ingredient.py
Wyświetl plik 

@@ -0,0 +1,32 @@
1 
+# Generated by Django 3.2.13 on 2022-05-19 14:30
2 
+
3 
+from django.db import migrations, models
4 
+import django.db.models.deletion
5 
+
6 
+
7 
+class Migration(migrations.Migration):
8 
+
9 
+    dependencies = [
10 
+        ('pos', '0014_order_note'),
11 
+    ]
12 
+
13 
+    operations = [
14 
+        migrations.CreateModel(
15 
+            name='Ingredient',
16 
+            fields=[
17 
+                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
18 
+                ('created_at', models.DateTimeField(auto_now_add=True)),
19 
+                ('updated_at', models.DateTimeField(auto_now=True)),
20 
+                ('inProcess', models.CharField(blank=True, max_length=100, null=True)),
21 
+                ('status', models.CharField(choices=[('process', 'Process'), ('fn', 'Finished')], default='process', max_length=100)),
22 
+                ('name', models.CharField(max_length=200)),
23 
+                ('qty', models.DecimalField(decimal_places=2, max_digits=5)),
24 
+                ('unit', models.CharField(max_length=10)),
25 
+                ('comment', models.TextField(blank=True, null=True)),
26 
+                ('menu', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='pos.menuitem')),
27 
+            ],
28 
+            options={
29 
+                'abstract': False,
30 
+            },
31 
+        ),
32 
+    ]

+ 26 - 0
app/pos/migrations/0016_profile.py
Wyświetl plik 

@@ -0,0 +1,26 @@
1 
+# Generated by Django 3.2.13 on 2022-05-19 14:40
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 
+    dependencies = [
11 
+        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
12 
+        ('pos', '0015_ingredient'),
13 
+    ]
14 
+
15 
+    operations = [
16 
+        migrations.CreateModel(
17 
+            name='Profile',
18 
+            fields=[
19 
+                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
20 
+                ('location', models.CharField(blank=True, max_length=30)),
21 
+                ('birthdate', models.DateField(blank=True, null=True)),
22 
+                ('role', models.PositiveSmallIntegerField(blank=True, choices=[(1, 'Store Owner'), (2, 'Chef'), (3, 'Employee')], null=True)),
23 
+                ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
24 
+            ],
25 
+        ),
26 
+    ]

+ 66 - 0
app/pos/migrations/0017_auto_20220519_2146.py
Wyświetl plik 

@@ -0,0 +1,66 @@
1 
+# Generated by Django 3.2.13 on 2022-05-19 14:46
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 
+    dependencies = [
11 
+        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
12 
+        ('pos', '0016_profile'),
13 
+    ]
14 
+
15 
+    operations = [
16 
+        migrations.AddField(
17 
+            model_name='bookingtable',
18 
+            name='owner',
19 
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
20 
+        ),
21 
+        migrations.AddField(
22 
+            model_name='ingredient',
23 
+            name='owner',
24 
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
25 
+        ),
26 
+        migrations.AddField(
27 
+            model_name='menufile',
28 
+            name='owner',
29 
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
30 
+        ),
31 
+        migrations.AddField(
32 
+            model_name='menuitem',
33 
+            name='owner',
34 
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
35 
+        ),
36 
+        migrations.AddField(
37 
+            model_name='order',
38 
+            name='owner',
39 
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
40 
+        ),
41 
+        migrations.AddField(
42 
+            model_name='orderitem',
43 
+            name='owner',
44 
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
45 
+        ),
46 
+        migrations.AddField(
47 
+            model_name='setting',
48 
+            name='owner',
49 
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
50 
+        ),
51 
+        migrations.AddField(
52 
+            model_name='store',
53 
+            name='owner',
54 
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
55 
+        ),
56 
+        migrations.AddField(
57 
+            model_name='storefile',
58 
+            name='owner',
59 
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
60 
+        ),
61 
+        migrations.AddField(
62 
+            model_name='table',
63 
+            name='owner',
64 
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
65 
+        ),
66 
+    ]

+ 68 - 0
app/pos/migrations/0018_auto_20220520_2029.py
Wyświetl plik 

@@ -0,0 +1,68 @@
1 
+# Generated by Django 3.2.13 on 2022-05-20 13:29
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0017_auto_20220519_2146'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AddField(
14 
+            model_name='orderitem',
15 
+            name='note',
16 
+            field=models.TextField(blank=True, null=True),
17 
+        ),
18 
+        migrations.AlterField(
19 
+            model_name='bookingtable',
20 
+            name='status',
21 
+            field=models.CharField(choices=[('process', 'Process'), ('fn', 'Finished'), ('purchase', 'Purchase')], default='process', max_length=100),
22 
+        ),
23 
+        migrations.AlterField(
24 
+            model_name='ingredient',
25 
+            name='status',
26 
+            field=models.CharField(choices=[('process', 'Process'), ('fn', 'Finished'), ('purchase', 'Purchase')], default='process', max_length=100),
27 
+        ),
28 
+        migrations.AlterField(
29 
+            model_name='menufile',
30 
+            name='status',
31 
+            field=models.CharField(choices=[('process', 'Process'), ('fn', 'Finished'), ('purchase', 'Purchase')], default='process', max_length=100),
32 
+        ),
33 
+        migrations.AlterField(
34 
+            model_name='menuitem',
35 
+            name='status',
36 
+            field=models.CharField(choices=[('process', 'Process'), ('fn', 'Finished'), ('purchase', 'Purchase')], default='process', max_length=100),
37 
+        ),
38 
+        migrations.AlterField(
39 
+            model_name='order',
40 
+            name='status',
41 
+            field=models.CharField(choices=[('process', 'Process'), ('fn', 'Finished'), ('purchase', 'Purchase')], default='process', max_length=100),
42 
+        ),
43 
+        migrations.AlterField(
44 
+            model_name='orderitem',
45 
+            name='status',
46 
+            field=models.CharField(choices=[('process', 'Process'), ('fn', 'Finished'), ('purchase', 'Purchase')], default='process', max_length=100),
47 
+        ),
48 
+        migrations.AlterField(
49 
+            model_name='setting',
50 
+            name='status',
51 
+            field=models.CharField(choices=[('process', 'Process'), ('fn', 'Finished'), ('purchase', 'Purchase')], default='process', max_length=100),
52 
+        ),
53 
+        migrations.AlterField(
54 
+            model_name='store',
55 
+            name='status',
56 
+            field=models.CharField(choices=[('process', 'Process'), ('fn', 'Finished'), ('purchase', 'Purchase')], default='process', max_length=100),
57 
+        ),
58 
+        migrations.AlterField(
59 
+            model_name='storefile',
60 
+            name='status',
61 
+            field=models.CharField(choices=[('process', 'Process'), ('fn', 'Finished'), ('purchase', 'Purchase')], default='process', max_length=100),
62 
+        ),
63 
+        migrations.AlterField(
64 
+            model_name='table',
65 
+            name='status',
66 
+            field=models.CharField(choices=[('process', 'Process'), ('fn', 'Finished'), ('purchase', 'Purchase')], default='process', max_length=100),
67 
+        ),
68 
+    ]

+ 39 - 0
app/pos/migrations/0019_uimenu.py
Wyświetl plik 

@@ -0,0 +1,39 @@
1 
+# Generated by Django 3.2.13 on 2022-05-21 03:32
2 
+
3 
+from django.conf import settings
4 
+from django.db import migrations, models
5 
+import django.db.models.deletion
6 
+import mptt.fields
7 
+
8 
+
9 
+class Migration(migrations.Migration):
10 
+
11 
+    dependencies = [
12 
+        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
13 
+        ('pos', '0018_auto_20220520_2029'),
14 
+    ]
15 
+
16 
+    operations = [
17 
+        migrations.CreateModel(
18 
+            name='UIMenu',
19 
+            fields=[
20 
+                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
21 
+                ('created_at', models.DateTimeField(auto_now_add=True)),
22 
+                ('updated_at', models.DateTimeField(auto_now=True)),
23 
+                ('inProcess', models.CharField(blank=True, max_length=100, null=True)),
24 
+                ('status', models.CharField(choices=[('process', 'Process'), ('fn', 'Finished'), ('purchase', 'Purchase')], default='process', max_length=100)),
25 
+                ('name', models.CharField(max_length=200)),
26 
+                ('group', models.CharField(max_length=200)),
27 
+                ('url', models.URLField()),
28 
+                ('lft', models.PositiveIntegerField(editable=False)),
29 
+                ('rght', models.PositiveIntegerField(editable=False)),
30 
+                ('tree_id', models.PositiveIntegerField(db_index=True, editable=False)),
31 
+                ('level', models.PositiveIntegerField(editable=False)),
32 
+                ('owner', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
33 
+                ('parent', mptt.fields.TreeForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='children', to='pos.uimenu')),
34 
+            ],
35 
+            options={
36 
+                'abstract': False,
37 
+            },
38 
+        ),
39 
+    ]

+ 22 - 0
app/pos/migrations/0020_setting_note.py
Wyświetl plik 

@@ -0,0 +1,22 @@
1 
+# Generated by Django 3.2.13 on 2022-05-21 04:43
2 
+
3 
+from django.db import migrations, models
4 
+from django.contrib.postgres.operations import HStoreExtension, UnaccentExtension
5 
+
6 
+
7 
+
8 
+class Migration(migrations.Migration):
9 
+
10 
+    dependencies = [
11 
+        ('pos', '0019_uimenu'),
12 
+    ]
13 
+
14 
+    operations = [
15 
+        HStoreExtension(),
16 
+        UnaccentExtension(),
17 
+        migrations.AddField(
18 
+            model_name='setting',
19 
+            name='note',
20 
+            field=models.CharField(blank=True, max_length=200, null=True),
21 
+        ),
22 
+    ]

+ 19 - 0
app/pos/migrations/0021_alter_setting_data.py
Wyświetl plik 

@@ -0,0 +1,19 @@
1 
+# Generated by Django 3.2.13 on 2022-05-21 04:45
2 
+
3 
+import django.contrib.postgres.fields.hstore
4 
+from django.db import migrations
5 
+
6 
+
7 
+class Migration(migrations.Migration):
8 
+
9 
+    dependencies = [
10 
+        ('pos', '0020_setting_note'),
11 
+    ]
12 
+
13 
+    operations = [
14 
+        migrations.AlterField(
15 
+            model_name='setting',
16 
+            name='data',
17 
+            field=django.contrib.postgres.fields.hstore.HStoreField(blank=True, null=True),
18 
+        ),
19 
+    ]

+ 18 - 0
app/pos/migrations/0022_alter_uimenu_url.py
Wyświetl plik 

@@ -0,0 +1,18 @@
1 
+# Generated by Django 3.2.13 on 2022-05-21 05:21
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0021_alter_setting_data'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AlterField(
14 
+            model_name='uimenu',
15 
+            name='url',
16 
+            field=models.CharField(max_length=200),
17 
+        ),
18 
+    ]

+ 18 - 0
app/pos/migrations/0023_alter_store_name.py
Wyświetl plik 

@@ -0,0 +1,18 @@
1 
+# Generated by Django 3.2.13 on 2022-05-21 05:27
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0022_alter_uimenu_url'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AlterField(
14 
+            model_name='store',
15 
+            name='name',
16 
+            field=models.CharField(default='Unititled', max_length=100),
17 
+        ),
18 
+    ]

+ 19 - 0
app/pos/migrations/0024_uimenu_store.py
Wyświetl plik 

@@ -0,0 +1,19 @@
1 
+# Generated by Django 3.2.13 on 2022-05-21 07:33
2 
+
3 
+from django.db import migrations, models
4 
+import django.db.models.deletion
5 
+
6 
+
7 
+class Migration(migrations.Migration):
8 
+
9 
+    dependencies = [
10 
+        ('pos', '0023_alter_store_name'),
11 
+    ]
12 
+
13 
+    operations = [
14 
+        migrations.AddField(
15 
+            model_name='uimenu',
16 
+            name='store',
17 
+            field=models.ForeignKey(default=None, null=True, on_delete=django.db.models.deletion.CASCADE, to='pos.store'),
18 
+        ),
19 
+    ]

+ 18 - 0
app/pos/migrations/0025_uimenu_icon.py
Wyświetl plik 

@@ -0,0 +1,18 @@
1 
+# Generated by Django 3.2.13 on 2022-05-22 16:34
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0024_uimenu_store'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AddField(
14 
+            model_name='uimenu',
15 
+            name='icon',
16 
+            field=models.CharField(blank=True, default='file', max_length=100, null=True),
17 
+        ),
18 
+    ]

+ 19 - 0
app/pos/migrations/0026_order_store.py
Wyświetl plik 

@@ -0,0 +1,19 @@
1 
+# Generated by Django 3.2.13 on 2022-05-23 05:24
2 
+
3 
+from django.db import migrations, models
4 
+import django.db.models.deletion
5 
+
6 
+
7 
+class Migration(migrations.Migration):
8 
+
9 
+    dependencies = [
10 
+        ('pos', '0025_uimenu_icon'),
11 
+    ]
12 
+
13 
+    operations = [
14 
+        migrations.AddField(
15 
+            model_name='order',
16 
+            name='store',
17 
+            field=models.ForeignKey(default=None, null=True, on_delete=django.db.models.deletion.SET_NULL, to='pos.store'),
18 
+        ),
19 
+    ]

+ 19 - 0
app/pos/migrations/0027_orderitem_store.py
Wyświetl plik 

@@ -0,0 +1,19 @@
1 
+# Generated by Django 3.2.13 on 2022-05-24 04:51
2 
+
3 
+from django.db import migrations, models
4 
+import django.db.models.deletion
5 
+
6 
+
7 
+class Migration(migrations.Migration):
8 
+
9 
+    dependencies = [
10 
+        ('pos', '0026_order_store'),
11 
+    ]
12 
+
13 
+    operations = [
14 
+        migrations.AddField(
15 
+            model_name='orderitem',
16 
+            name='store',
17 
+            field=models.ForeignKey(default=None, null=True, on_delete=django.db.models.deletion.SET_NULL, to='pos.store'),
18 
+        ),
19 
+    ]

+ 28 - 0
app/pos/migrations/0028_auto_20220529_1350.py
Wyświetl plik 

@@ -0,0 +1,28 @@
1 
+# Generated by Django 3.2.13 on 2022-05-29 06:50
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0027_orderitem_store'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AddField(
14 
+            model_name='store',
15 
+            name='address',
16 
+            field=models.TextField(blank=True, null=True),
17 
+        ),
18 
+        migrations.AddField(
19 
+            model_name='store',
20 
+            name='province',
21 
+            field=models.CharField(blank=True, max_length=100, null=True),
22 
+        ),
23 
+        migrations.AddField(
24 
+            model_name='store',
25 
+            name='storeType',
26 
+            field=models.CharField(blank=True, max_length=100, null=True),
27 
+        ),
28 
+    ]

+ 40 - 0
app/pos/migrations/0029_auto_20220530_1225.py
Wyświetl plik 

@@ -0,0 +1,40 @@
1 
+# Generated by Django 3.2.13 on 2022-05-30 05:25
2 
+
3 
+from django.db import migrations, models
4 
+import django.db.models.deletion
5 
+import taggit.managers
6 
+
7 
+
8 
+class Migration(migrations.Migration):
9 
+
10 
+    dependencies = [
11 
+        ('taggit', '0005_auto_20220424_2025'),
12 
+        ('pos', '0028_auto_20220529_1350'),
13 
+    ]
14 
+
15 
+    operations = [
16 
+        migrations.RemoveField(
17 
+            model_name='menufile',
18 
+            name='store',
19 
+        ),
20 
+        migrations.AddField(
21 
+            model_name='menufile',
22 
+            name='menuItem',
23 
+            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='pos.menuitem'),
24 
+        ),
25 
+        migrations.AlterField(
26 
+            model_name='menufile',
27 
+            name='tags',
28 
+            field=taggit.managers.TaggableManager(blank=True, help_text='A comma-separated list of tags.', through='taggit.TaggedItem', to='taggit.Tag', verbose_name='Tags'),
29 
+        ),
30 
+        migrations.AlterField(
31 
+            model_name='store',
32 
+            name='storeType',
33 
+            field=models.CharField(blank=True, max_length=100, null=True, verbose_name='Store Type'),
34 
+        ),
35 
+        migrations.AlterField(
36 
+            model_name='storefile',
37 
+            name='tags',
38 
+            field=taggit.managers.TaggableManager(blank=True, help_text='A comma-separated list of tags.', through='taggit.TaggedItem', to='taggit.Tag', verbose_name='Tags'),
39 
+        ),
40 
+    ]

+ 19 - 0
app/pos/migrations/0030_bookingtable_store.py
Wyświetl plik 

@@ -0,0 +1,19 @@
1 
+# Generated by Django 3.2.13 on 2022-05-30 07:10
2 
+
3 
+from django.db import migrations, models
4 
+import django.db.models.deletion
5 
+
6 
+
7 
+class Migration(migrations.Migration):
8 
+
9 
+    dependencies = [
10 
+        ('pos', '0029_auto_20220530_1225'),
11 
+    ]
12 
+
13 
+    operations = [
14 
+        migrations.AddField(
15 
+            model_name='bookingtable',
16 
+            name='store',
17 
+            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='pos.store'),
18 
+        ),
19 
+    ]

+ 23 - 0
app/pos/migrations/0031_auto_20220530_1417.py
Wyświetl plik 

@@ -0,0 +1,23 @@
1 
+# Generated by Django 3.2.13 on 2022-05-30 07:17
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0030_bookingtable_store'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AddField(
14 
+            model_name='bookingtable',
15 
+            name='onTime',
16 
+            field=models.TimeField(null=True),
17 
+        ),
18 
+        migrations.AlterField(
19 
+            model_name='bookingtable',
20 
+            name='onDate',
21 
+            field=models.DateField(null=True),
22 
+        ),
23 
+    ]

+ 135 - 0
app/pos/migrations/0032_auto_20220530_1510.py
Wyświetl plik 

@@ -0,0 +1,135 @@
1 
+# Generated by Django 3.2.13 on 2022-05-30 08:10
2 
+
3 
+from django.conf import settings
4 
+from django.db import migrations, models
5 
+import django.db.models.deletion
6 
+import djrichtextfield.models
7 
+import mptt.fields
8 
+
9 
+
10 
+class Migration(migrations.Migration):
11 
+
12 
+    dependencies = [
13 
+        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
14 
+        ('pos', '0031_auto_20220530_1417'),
15 
+    ]
16 
+
17 
+    operations = [
18 
+        migrations.RemoveField(
19 
+            model_name='bookingtable',
20 
+            name='inProcess',
21 
+        ),
22 
+        migrations.RemoveField(
23 
+            model_name='bookingtable',
24 
+            name='status',
25 
+        ),
26 
+        migrations.RemoveField(
27 
+            model_name='ingredient',
28 
+            name='inProcess',
29 
+        ),
30 
+        migrations.RemoveField(
31 
+            model_name='ingredient',
32 
+            name='status',
33 
+        ),
34 
+        migrations.RemoveField(
35 
+            model_name='menufile',
36 
+            name='inProcess',
37 
+        ),
38 
+        migrations.RemoveField(
39 
+            model_name='menufile',
40 
+            name='status',
41 
+        ),
42 
+        migrations.RemoveField(
43 
+            model_name='menuitem',
44 
+            name='inProcess',
45 
+        ),
46 
+        migrations.RemoveField(
47 
+            model_name='menuitem',
48 
+            name='status',
49 
+        ),
50 
+        migrations.RemoveField(
51 
+            model_name='order',
52 
+            name='inProcess',
53 
+        ),
54 
+        migrations.RemoveField(
55 
+            model_name='order',
56 
+            name='status',
57 
+        ),
58 
+        migrations.RemoveField(
59 
+            model_name='orderitem',
60 
+            name='inProcess',
61 
+        ),
62 
+        migrations.RemoveField(
63 
+            model_name='orderitem',
64 
+            name='status',
65 
+        ),
66 
+        migrations.RemoveField(
67 
+            model_name='setting',
68 
+            name='inProcess',
69 
+        ),
70 
+        migrations.RemoveField(
71 
+            model_name='setting',
72 
+            name='status',
73 
+        ),
74 
+        migrations.RemoveField(
75 
+            model_name='store',
76 
+            name='inProcess',
77 
+        ),
78 
+        migrations.RemoveField(
79 
+            model_name='store',
80 
+            name='status',
81 
+        ),
82 
+        migrations.RemoveField(
83 
+            model_name='storefile',
84 
+            name='inProcess',
85 
+        ),
86 
+        migrations.RemoveField(
87 
+            model_name='storefile',
88 
+            name='status',
89 
+        ),
90 
+        migrations.RemoveField(
91 
+            model_name='table',
92 
+            name='inProcess',
93 
+        ),
94 
+        migrations.RemoveField(
95 
+            model_name='table',
96 
+            name='status',
97 
+        ),
98 
+        migrations.RemoveField(
99 
+            model_name='uimenu',
100 
+            name='inProcess',
101 
+        ),
102 
+        migrations.RemoveField(
103 
+            model_name='uimenu',
104 
+            name='status',
105 
+        ),
106 
+        migrations.CreateModel(
107 
+            name='PostCategory',
108 
+            fields=[
109 
+                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
110 
+                ('name', models.CharField(max_length=200)),
111 
+                ('lft', models.PositiveIntegerField(editable=False)),
112 
+                ('rght', models.PositiveIntegerField(editable=False)),
113 
+                ('tree_id', models.PositiveIntegerField(db_index=True, editable=False)),
114 
+                ('level', models.PositiveIntegerField(editable=False)),
115 
+                ('parent', mptt.fields.TreeForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='children', to='pos.postcategory')),
116 
+            ],
117 
+            options={
118 
+                'abstract': False,
119 
+            },
120 
+        ),
121 
+        migrations.CreateModel(
122 
+            name='Post',
123 
+            fields=[
124 
+                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
125 
+                ('created_at', models.DateTimeField(auto_now_add=True)),
126 
+                ('updated_at', models.DateTimeField(auto_now=True)),
127 
+                ('title', models.CharField(max_length=200)),
128 
+                ('content', djrichtextfield.models.RichTextField()),
129 
+                ('owner', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
130 
+            ],
131 
+            options={
132 
+                'abstract': False,
133 
+            },
134 
+        ),
135 
+    ]

+ 19 - 0
app/pos/migrations/0033_post_store.py
Wyświetl plik 

@@ -0,0 +1,19 @@
1 
+# Generated by Django 3.2.13 on 2022-05-30 08:29
2 
+
3 
+from django.db import migrations, models
4 
+import django.db.models.deletion
5 
+
6 
+
7 
+class Migration(migrations.Migration):
8 
+
9 
+    dependencies = [
10 
+        ('pos', '0032_auto_20220530_1510'),
11 
+    ]
12 
+
13 
+    operations = [
14 
+        migrations.AddField(
15 
+            model_name='post',
16 
+            name='store',
17 
+            field=models.ForeignKey(default=None, null=True, on_delete=django.db.models.deletion.CASCADE, to='pos.store'),
18 
+        ),
19 
+    ]

+ 31 - 0
app/pos/migrations/0034_auto_20220531_2134.py
Wyświetl plik 

@@ -0,0 +1,31 @@
1 
+# Generated by Django 3.2.13 on 2022-05-31 14:34
2 
+
3 
+from django.db import migrations, models
4 
+import django.db.models.deletion
5 
+import djrichtextfield.models
6 
+import mptt.fields
7 
+
8 
+
9 
+class Migration(migrations.Migration):
10 
+
11 
+    dependencies = [
12 
+        ('pos', '0033_post_store'),
13 
+    ]
14 
+
15 
+    operations = [
16 
+        migrations.AddField(
17 
+            model_name='post',
18 
+            name='category',
19 
+            field=mptt.fields.TreeForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='pos.postcategory'),
20 
+        ),
21 
+        migrations.AddField(
22 
+            model_name='post',
23 
+            name='featureImage',
24 
+            field=models.ImageField(blank=True, height_field=800, null=True, upload_to='uploads/%Y/%m/%d/', width_field=450),
25 
+        ),
26 
+        migrations.AlterField(
27 
+            model_name='post',
28 
+            name='content',
29 
+            field=djrichtextfield.models.RichTextField(blank=True),
30 
+        ),
31 
+    ]

+ 23 - 0
app/pos/migrations/0035_auto_20220531_2151.py
Wyświetl plik 

@@ -0,0 +1,23 @@
1 
+# Generated by Django 3.2.13 on 2022-05-31 14:51
2 
+
3 
+from django.db import migrations
4 
+import mptt.fields
5 
+
6 
+
7 
+class Migration(migrations.Migration):
8 
+
9 
+    dependencies = [
10 
+        ('pos', '0034_auto_20220531_2134'),
11 
+    ]
12 
+
13 
+    operations = [
14 
+        migrations.RemoveField(
15 
+            model_name='post',
16 
+            name='category',
17 
+        ),
18 
+        migrations.AddField(
19 
+            model_name='post',
20 
+            name='category',
21 
+            field=mptt.fields.TreeManyToManyField(blank=True, null=True, to='pos.PostCategory'),
22 
+        ),
23 
+    ]

+ 18 - 0
app/pos/migrations/0036_alter_post_featureimage.py
Wyświetl plik 

@@ -0,0 +1,18 @@
1 
+# Generated by Django 3.2.13 on 2022-05-31 15:01
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0035_auto_20220531_2151'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AlterField(
14 
+            model_name='post',
15 
+            name='featureImage',
16 
+            field=models.ImageField(blank=True, null=True, upload_to='uploads/%Y/%m/%d/'),
17 
+        ),
18 
+    ]

+ 19 - 0
app/pos/migrations/0037_post_photos.py
Wyświetl plik 

@@ -0,0 +1,19 @@
1 
+# Generated by Django 3.2.13 on 2022-05-31 15:06
2 
+
3 
+import django.contrib.postgres.fields
4 
+from django.db import migrations, models
5 
+
6 
+
7 
+class Migration(migrations.Migration):
8 
+
9 
+    dependencies = [
10 
+        ('pos', '0036_alter_post_featureimage'),
11 
+    ]
12 
+
13 
+    operations = [
14 
+        migrations.AddField(
15 
+            model_name='post',
16 
+            name='photos',
17 
+            field=django.contrib.postgres.fields.ArrayField(base_field=models.ImageField(upload_to='uploads/%Y/%m/%d/'), blank=True, null=True, size=None),
18 
+        ),
19 
+    ]

+ 37 - 0
app/pos/migrations/0038_auto_20220531_2208.py
Wyświetl plik 

@@ -0,0 +1,37 @@
1 
+# Generated by Django 3.2.13 on 2022-05-31 15:08
2 
+
3 
+from django.conf import settings
4 
+from django.db import migrations, models
5 
+import django.db.models.deletion
6 
+import taggit.managers
7 
+
8 
+
9 
+class Migration(migrations.Migration):
10 
+
11 
+    dependencies = [
12 
+        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
13 
+        ('taggit', '0005_auto_20220424_2025'),
14 
+        ('pos', '0037_post_photos'),
15 
+    ]
16 
+
17 
+    operations = [
18 
+        migrations.RemoveField(
19 
+            model_name='post',
20 
+            name='photos',
21 
+        ),
22 
+        migrations.CreateModel(
23 
+            name='PostFile',
24 
+            fields=[
25 
+                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
26 
+                ('created_at', models.DateTimeField(auto_now_add=True)),
27 
+                ('updated_at', models.DateTimeField(auto_now=True)),
28 
+                ('file', models.FileField(upload_to='uploads/%Y/%m/%d/')),
29 
+                ('owner', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
30 
+                ('post', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='pos.post')),
31 
+                ('tags', taggit.managers.TaggableManager(blank=True, help_text='A comma-separated list of tags.', through='taggit.TaggedItem', to='taggit.Tag', verbose_name='Tags')),
32 
+            ],
33 
+            options={
34 
+                'abstract': False,
35 
+            },
36 
+        ),
37 
+    ]

+ 20 - 0
app/pos/migrations/0039_post_tags.py
Wyświetl plik 

@@ -0,0 +1,20 @@
1 
+# Generated by Django 3.2.13 on 2022-06-01 07:23
2 
+
3 
+from django.db import migrations
4 
+import taggit.managers
5 
+
6 
+
7 
+class Migration(migrations.Migration):
8 
+
9 
+    dependencies = [
10 
+        ('taggit', '0005_auto_20220424_2025'),
11 
+        ('pos', '0038_auto_20220531_2208'),
12 
+    ]
13 
+
14 
+    operations = [
15 
+        migrations.AddField(
16 
+            model_name='post',
17 
+            name='tags',
18 
+            field=taggit.managers.TaggableManager(blank=True, help_text='A comma-separated list of tags.', through='taggit.TaggedItem', to='taggit.Tag', verbose_name='Tags'),
19 
+        ),
20 
+    ]

+ 18 - 0
app/pos/migrations/0040_post_description.py
Wyświetl plik 

@@ -0,0 +1,18 @@
1 
+# Generated by Django 3.2.13 on 2022-06-01 07:36
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0039_post_tags'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AddField(
14 
+            model_name='post',
15 
+            name='description',
16 
+            field=models.TextField(blank=True, null=True),
17 
+        ),
18 
+    ]

+ 32 - 0
app/pos/migrations/0041_customer.py
Wyświetl plik 

@@ -0,0 +1,32 @@
1 
+# Generated by Django 3.2.13 on 2022-06-01 07:41
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 
+    dependencies = [
11 
+        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
12 
+        ('pos', '0040_post_description'),
13 
+    ]
14 
+
15 
+    operations = [
16 
+        migrations.CreateModel(
17 
+            name='Customer',
18 
+            fields=[
19 
+                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
20 
+                ('created_at', models.DateTimeField(auto_now_add=True)),
21 
+                ('updated_at', models.DateTimeField(auto_now=True)),
22 
+                ('fullName', models.CharField(max_length=200)),
23 
+                ('email', models.EmailField(blank=True, max_length=254, null=True)),
24 
+                ('lineId', models.CharField(blank=True, max_length=100, null=True)),
25 
+                ('gender', models.CharField(choices=[('na', 'N/A'), ('lgbt', 'LGBT'), ('male', 'Male'), ('female', 'Female')], default='na', max_length=40)),
26 
+                ('owner', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
27 
+            ],
28 
+            options={
29 
+                'abstract': False,
30 
+            },
31 
+        ),
32 
+    ]

+ 19 - 0
app/pos/migrations/0042_customer_store.py
Wyświetl plik 

@@ -0,0 +1,19 @@
1 
+# Generated by Django 3.2.13 on 2022-06-01 08:19
2 
+
3 
+from django.db import migrations, models
4 
+import django.db.models.deletion
5 
+
6 
+
7 
+class Migration(migrations.Migration):
8 
+
9 
+    dependencies = [
10 
+        ('pos', '0041_customer'),
11 
+    ]
12 
+
13 
+    operations = [
14 
+        migrations.AddField(
15 
+            model_name='customer',
16 
+            name='store',
17 
+            field=models.ForeignKey(default=None, null=True, on_delete=django.db.models.deletion.CASCADE, to='pos.store'),
18 
+        ),
19 
+    ]

+ 32 - 0
app/pos/migrations/0043_code.py
Wyświetl plik 

@@ -0,0 +1,32 @@
1 
+# Generated by Django 3.2.13 on 2022-06-02 14:02
2 
+
3 
+from django.conf import settings
4 
+from django.db import migrations, models
5 
+import django.db.models.deletion
6 
+import django_editorjs_fields.fields
7 
+
8 
+
9 
+class Migration(migrations.Migration):
10 
+
11 
+    dependencies = [
12 
+        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
13 
+        ('pos', '0042_customer_store'),
14 
+    ]
15 
+
16 
+    operations = [
17 
+        migrations.CreateModel(
18 
+            name='Code',
19 
+            fields=[
20 
+                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
21 
+                ('created_at', models.DateTimeField(auto_now_add=True)),
22 
+                ('updated_at', models.DateTimeField(auto_now=True)),
23 
+                ('body_default', models.TextField()),
24 
+                ('body_editorjs', django_editorjs_fields.fields.EditorJsJSONField()),
25 
+                ('body_editorjs_text', django_editorjs_fields.fields.EditorJsTextField()),
26 
+                ('owner', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
27 
+            ],
28 
+            options={
29 
+                'abstract': False,
30 
+            },
31 
+        ),
32 
+    ]

+ 24 - 0
app/pos/migrations/0044_auto_20220603_1058.py
Wyświetl plik 

@@ -0,0 +1,24 @@
1 
+# Generated by Django 3.2.13 on 2022-06-03 03:58
2 
+
3 
+from django.db import migrations
4 
+import filebrowser.fields
5 
+
6 
+
7 
+class Migration(migrations.Migration):
8 
+
9 
+    dependencies = [
10 
+        ('pos', '0043_code'),
11 
+    ]
12 
+
13 
+    operations = [
14 
+        migrations.AddField(
15 
+            model_name='code',
16 
+            name='document',
17 
+            field=filebrowser.fields.FileBrowseField(blank=True, max_length=200, verbose_name='PDF'),
18 
+        ),
19 
+        migrations.AddField(
20 
+            model_name='code',
21 
+            name='image',
22 
+            field=filebrowser.fields.FileBrowseField(blank=True, max_length=200, verbose_name='Image'),
23 
+        ),
24 
+    ]

+ 18 - 0
app/pos/migrations/0045_code_code.py
Wyświetl plik 

@@ -0,0 +1,18 @@
1 
+# Generated by Django 3.2.13 on 2022-06-03 04:35
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0044_auto_20220603_1058'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AddField(
14 
+            model_name='code',
15 
+            name='code',
16 
+            field=models.TextField(blank=True),
17 
+        ),
18 
+    ]

+ 48 - 0
app/pos/migrations/0046_auto_20220603_1258.py
Wyświetl plik 

@@ -0,0 +1,48 @@
1 
+# Generated by Django 3.2.13 on 2022-06-03 05:58
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0045_code_code'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.RenameField(
14 
+            model_name='code',
15 
+            old_name='code',
16 
+            new_name='cssCode',
17 
+        ),
18 
+        migrations.RemoveField(
19 
+            model_name='code',
20 
+            name='body_default',
21 
+        ),
22 
+        migrations.RemoveField(
23 
+            model_name='code',
24 
+            name='body_editorjs',
25 
+        ),
26 
+        migrations.RemoveField(
27 
+            model_name='code',
28 
+            name='body_editorjs_text',
29 
+        ),
30 
+        migrations.RemoveField(
31 
+            model_name='code',
32 
+            name='document',
33 
+        ),
34 
+        migrations.RemoveField(
35 
+            model_name='code',
36 
+            name='image',
37 
+        ),
38 
+        migrations.AddField(
39 
+            model_name='code',
40 
+            name='jsCode',
41 
+            field=models.TextField(blank=True),
42 
+        ),
43 
+        migrations.AddField(
44 
+            model_name='code',
45 
+            name='pluginCode',
46 
+            field=models.TextField(blank=True),
47 
+        ),
48 
+    ]

+ 19 - 0
app/pos/migrations/0047_code_store.py
Wyświetl plik 

@@ -0,0 +1,19 @@
1 
+# Generated by Django 3.2.13 on 2022-06-03 06:07
2 
+
3 
+from django.db import migrations, models
4 
+import django.db.models.deletion
5 
+
6 
+
7 
+class Migration(migrations.Migration):
8 
+
9 
+    dependencies = [
10 
+        ('pos', '0046_auto_20220603_1258'),
11 
+    ]
12 
+
13 
+    operations = [
14 
+        migrations.AddField(
15 
+            model_name='code',
16 
+            name='store',
17 
+            field=models.ForeignKey(default=None, null=True, on_delete=django.db.models.deletion.CASCADE, to='pos.store'),
18 
+        ),
19 
+    ]

+ 19 - 0
app/pos/migrations/0048_alter_code_store.py
Wyświetl plik 

@@ -0,0 +1,19 @@
1 
+# Generated by Django 3.2.13 on 2022-06-03 06:15
2 
+
3 
+from django.db import migrations, models
4 
+import django.db.models.deletion
5 
+
6 
+
7 
+class Migration(migrations.Migration):
8 
+
9 
+    dependencies = [
10 
+        ('pos', '0047_code_store'),
11 
+    ]
12 
+
13 
+    operations = [
14 
+        migrations.AlterField(
15 
+            model_name='code',
16 
+            name='store',
17 
+            field=models.OneToOneField(default=None, null=True, on_delete=django.db.models.deletion.CASCADE, to='pos.store'),
18 
+        ),
19 
+    ]

+ 18 - 0
app/pos/migrations/0049_uimenu_norder.py
Wyświetl plik 

@@ -0,0 +1,18 @@
1 
+# Generated by Django 3.2.13 on 2022-06-03 08:01
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0048_alter_code_store'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AddField(
14 
+            model_name='uimenu',
15 
+            name='nOrder',
16 
+            field=models.IntegerField(default=1),
17 
+        ),
18 
+    ]

+ 19 - 0
app/pos/migrations/0050_profile_store.py
Wyświetl plik 

@@ -0,0 +1,19 @@
1 
+# Generated by Django 3.2.13 on 2022-06-03 13:47
2 
+
3 
+from django.db import migrations, models
4 
+import django.db.models.deletion
5 
+
6 
+
7 
+class Migration(migrations.Migration):
8 
+
9 
+    dependencies = [
10 
+        ('pos', '0049_uimenu_norder'),
11 
+    ]
12 
+
13 
+    operations = [
14 
+        migrations.AddField(
15 
+            model_name='profile',
16 
+            name='store',
17 
+            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='pos.store'),
18 
+        ),
19 
+    ]

+ 18 - 0
app/pos/migrations/0051_menuitem_qrcode.py
Wyświetl plik 

@@ -0,0 +1,18 @@
1 
+# Generated by Django 3.2.13 on 2022-06-05 17:25
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0050_profile_store'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AddField(
14 
+            model_name='menuitem',
15 
+            name='qrCode',
16 
+            field=models.BinaryField(blank=True, null=True),
17 
+        ),
18 
+    ]

+ 18 - 0
app/pos/migrations/0052_alter_menuitem_qrcode.py
Wyświetl plik 

@@ -0,0 +1,18 @@
1 
+# Generated by Django 3.2.13 on 2022-06-05 17:59
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0051_menuitem_qrcode'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AlterField(
14 
+            model_name='menuitem',
15 
+            name='qrCode',
16 
+            field=models.FileField(blank=True, null=True, upload_to='uploads/%Y/%m/%d/'),
17 
+        ),
18 
+    ]

+ 23 - 0
app/pos/migrations/0053_auto_20220606_1058.py
Wyświetl plik 

@@ -0,0 +1,23 @@
1 
+# Generated by Django 3.2.13 on 2022-06-06 03:58
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0052_alter_menuitem_qrcode'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AddField(
14 
+            model_name='order',
15 
+            name='qrCode',
16 
+            field=models.FileField(blank=True, null=True, upload_to='uploads/%Y/%m/%d/'),
17 
+        ),
18 
+        migrations.AddField(
19 
+            model_name='store',
20 
+            name='qrCode',
21 
+            field=models.FileField(blank=True, null=True, upload_to='uploads/%Y/%m/%d/'),
22 
+        ),
23 
+    ]

+ 23 - 0
app/pos/migrations/0054_auto_20220606_1336.py
Wyświetl plik 

@@ -0,0 +1,23 @@
1 
+# Generated by Django 3.2.13 on 2022-06-06 06:36
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0053_auto_20220606_1058'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AddField(
14 
+            model_name='bookingtable',
15 
+            name='qrCode',
16 
+            field=models.FileField(blank=True, null=True, upload_to='uploads/%Y/%m/%d/'),
17 
+        ),
18 
+        migrations.AddField(
19 
+            model_name='table',
20 
+            name='qrCode',
21 
+            field=models.FileField(blank=True, null=True, upload_to='uploads/%Y/%m/%d/'),
22 
+        ),
23 
+    ]

+ 18 - 0
app/pos/migrations/0055_customer_qrcode.py
Wyświetl plik 

@@ -0,0 +1,18 @@
1 
+# Generated by Django 3.2.13 on 2022-06-06 06:41
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0054_auto_20220606_1336'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AddField(
14 
+            model_name='customer',
15 
+            name='qrCode',
16 
+            field=models.FileField(blank=True, null=True, upload_to='uploads/%Y/%m/%d/'),
17 
+        ),
18 
+    ]

+ 24 - 0
app/pos/migrations/0056_auto_20220606_1348.py
Wyświetl plik 

@@ -0,0 +1,24 @@
1 
+# Generated by Django 3.2.13 on 2022-06-06 06:48
2 
+
3 
+from django.db import migrations
4 
+import django_google_maps.fields
5 
+
6 
+
7 
+class Migration(migrations.Migration):
8 
+
9 
+    dependencies = [
10 
+        ('pos', '0055_customer_qrcode'),
11 
+    ]
12 
+
13 
+    operations = [
14 
+        migrations.AddField(
15 
+            model_name='store',
16 
+            name='geolocation',
17 
+            field=django_google_maps.fields.GeoLocationField(blank=True, max_length=100, null=True),
18 
+        ),
19 
+        migrations.AlterField(
20 
+            model_name='store',
21 
+            name='address',
22 
+            field=django_google_maps.fields.AddressField(blank=True, max_length=100, null=True),
23 
+        ),
24 
+    ]

+ 18 - 0
app/pos/migrations/0057_store_addresstext.py
Wyświetl plik 

@@ -0,0 +1,18 @@
1 
+# Generated by Django 3.2.13 on 2022-06-06 06:50
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0056_auto_20220606_1348'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AddField(
14 
+            model_name='store',
15 
+            name='addressText',
16 
+            field=models.TextField(blank=True, null=True),
17 
+        ),
18 
+    ]

+ 18 - 0
app/pos/migrations/0058_post_relatemenus.py
Wyświetl plik 

@@ -0,0 +1,18 @@
1 
+# Generated by Django 3.2.13 on 2022-06-11 13:18
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0057_store_addresstext'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AddField(
14 
+            model_name='post',
15 
+            name='relateMenus',
16 
+            field=models.ManyToManyField(blank=True, null=True, to='pos.MenuItem'),
17 
+        ),
18 
+    ]

+ 18 - 0
app/pos/migrations/0059_menuitem_featureimage.py
Wyświetl plik 

@@ -0,0 +1,18 @@
1 
+# Generated by Django 3.2.13 on 2022-06-11 16:17
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0058_post_relatemenus'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AddField(
14 
+            model_name='menuitem',
15 
+            name='featureImage',
16 
+            field=models.ImageField(blank=True, null=True, upload_to='uploads/%Y/%m/%d/'),
17 
+        ),
18 
+    ]

+ 18 - 0
app/pos/migrations/0060_menuitem_description.py
Wyświetl plik 

@@ -0,0 +1,18 @@
1 
+# Generated by Django 3.2.13 on 2022-06-12 05:51
2 
+
3 
+from django.db import migrations, models
4 
+
5 
+
6 
+class Migration(migrations.Migration):
7 
+
8 
+    dependencies = [
9 
+        ('pos', '0059_menuitem_featureimage'),
10 
+    ]
11 
+
12 
+    operations = [
13 
+        migrations.AddField(
14 
+            model_name='menuitem',
15 
+            name='description',
16 
+            field=models.TextField(blank=True, null=True),
17 
+        ),
18 
+    ]

+ 0 - 0
app/pos/migrations/0061_store_logo.py
Wyświetl plik


Niektóre pliki nie zostały wyświetlone z powodu dużej ilości zmienionych plików

tum/soc - Gogs: Simplico Git Service
Главная Обзор Помощь
Войти
tum
/
soc
Следить 1
В избранное 0
Ответвить 0
Код Обсуждения 0 Запросы на слияние 0 Коммиты 11 Релизы 0 Вики

Нет описания

Дерево: 51a7d8f87f
Ветки Метки
soc
/
iris-web
/
source
/
app
/
post_init.py

post_init.py 106KB
История Исходник

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743 
  1. #  IRIS Source Code
    2. 

  2. #  Copyright (C) 2021 - Airbus CyberSecurity (SAS)
    3. 

  3. #  ir@cyberactionlab.net
    4. 

  4. #
    5. 

  5. #  This program is free software; you can redistribute it and/or
    6. 

  6. #  modify it under the terms of the GNU Lesser General Public
    7. 

  7. #  License as published by the Free Software Foundation; either
    8. 

  8. #  version 3 of the License, or (at your option) any later version.
    9. 

  9. #
    10. 

  10. #  This program is distributed in the hope that it will be useful,
    11. 

  11. #  but WITHOUT ANY WARRANTY; without even the implied warranty of
    12. 

  12. #  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
    13. 

  13. #  Lesser General Public License for more details.
    14. 

  14. #
    15. 

  15. #  You should have received a copy of the GNU Lesser General Public License
    16. 

  16. #  along with this program; if not, write to the Free Software Foundation,
    17. 

  17. #  Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
    18. 

  18. import json
    19. 

  19. 

  20. from pathlib import Path
    21. 

  21. 

  22. import glob
    23. 

  23. import os
    24. 

  24. import random
    25. 

  25. import secrets
    26. 

  26. import string
    27. 

  27. import socket
    28. 

  28. import time
    29. 

  29. from alembic import command
    30. 

  30. from alembic.config import Config
    31. 

  31. from sqlalchemy import create_engine, exc, or_, text
    32. 

  32. from sqlalchemy_utils import create_database
    33. 

  33. from sqlalchemy_utils import database_exists
    34. 

  34. 

  35. from app import app
    36. 

  36. from app import bc
    37. 

  37. from app import celery
    38. 

  38. from app import db
    39. 

  39. from app.datamgmt.iris_engine.modules_db import iris_module_disable_by_id
    40. 

  40. from app.datamgmt.manage.manage_groups_db import add_case_access_to_group
    41. 

  41. from app.datamgmt.manage.manage_users_db import add_user_to_group
    42. 

  42. from app.datamgmt.manage.manage_users_db import add_user_to_organisation
    43. 

  43. from app.iris_engine.access_control.utils import ac_add_user_effective_access
    44. 

  44. from app.iris_engine.demo_builder import create_demo_cases
    45. 

  45. from app.iris_engine.access_control.utils import ac_get_mask_analyst
    46. 

  46. from app.datamgmt.manage.manage_groups_db import get_group_by_name
    47. 

  47. from app.iris_engine.access_control.utils import ac_get_mask_full_permissions
    48. 

  48. from app.iris_engine.module_handler.module_handler import check_module_health
    49. 

  49. from app.iris_engine.module_handler.module_handler import instantiate_module_from_name
    50. 

  50. from app.iris_engine.module_handler.module_handler import register_module
    51. 

  51. from app.models.models import create_safe_limited
    52. 

  52. from app.models.alerts import Severity, AlertStatus, AlertResolutionStatus
    53. 

  53. from app.models.authorization import CaseAccessLevel
    54. 

  54. from app.models.authorization import Group
    55. 

  55. from app.models.authorization import Organisation
    56. 

  56. from app.models.authorization import User
    57. 

  57. from app.models.cases import Cases, CaseState
    58. 

  58. from app.models.cases import Client
    59. 

  59. from app.models.models import AnalysisStatus, CaseClassification, ReviewStatus, ReviewStatusList, EvidenceTypes
    60. 

  60. from app.models.models import AssetsType
    61. 

  61. from app.models.models import EventCategory
    62. 

  62. from app.models.models import IocType
    63. 

  63. from app.models.models import IrisHook
    64. 

  64. from app.models.models import IrisModule
    65. 

  65. from app.models.models import Languages
    66. 

  66. from app.models.models import OsType
    67. 

  67. from app.models.models import ReportType
    68. 

  68. from app.models.models import ServerSettings
    69. 

  69. from app.models.models import TaskStatus
    70. 

  70. from app.models.models import Tlp
    71. 

  71. from app.models.models import create_safe
    72. 

  72. from app.models.models import create_safe_attr
    73. 

  73. from app.models.models import get_by_value_or_create
    74. 

  74. from app.models.models import get_or_create
    75. 

  75. from app.iris_engine.demo_builder import create_demo_users
    76. 

  76. 

  77. log = app.logger
    78. 

  78. 

  79. # Get the database host and port from environment variables
    80. 

  80. db_host = app.config.get('PG_SERVER')
    81. 

  81. db_port = int(app.config.get('PG_PORT'))
    82. 

  82. 

  83. # Get the retry parameters from environment variables
    84. 

  84. retry_count = int(app.config.get('DB_RETRY_COUNT'))
    85. 

  85. retry_delay = int(app.config.get('DB_RETRY_DELAY'))
    86. 

  86. 

  87. 

  88. def connect_to_database(host: str, port: int) -> bool:
    89. 

  89.     """Attempts to connect to a database at the specified host and port.
    90. 

  90. 

  91.     Args:
    92. 

  92.         host: A string representing the hostname or IP address of the database server.
    93. 

  93.         port: An integer representing the port number to connect to.
    94. 

  94. 

  95.     Returns:
    96. 

  96.         A boolean value indicating whether the connection was successful.
    97. 

  97.     """
    98. 

  98.     # Create a new socket object
    99. 

  99.     s = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
    100. 

  100.     try:
    101. 

  101.         # Try to connect to the database
    102. 

  102.         s.connect((host, port))
    103. 

  103.         # If the connection was successful, close the socket and return True
    104. 

  104.         s.close()
    105. 

  105.         return True
    106. 

  106.     except socket.error:
    107. 

  107.         # If the connection failed, close the socket and return False
    108. 

  108.         s.close()
    109. 

  109.         return False
    110. 

  110. 

  111. 

  112. def run_post_init(development=False):
    113. 

  113.     """Runs post-initiation steps for the IRIS application.
    114. 

  114. 

  115.     Args:
    116. 

  116.         development: A boolean value indicating whether the application is running in development mode.
    117. 

  117.     """
    118. 

  118.     # Log the IRIS version and post-initiation steps
    119. 

  119.     log.info(f'IRIS {app.config.get("IRIS_VERSION")}')
    120. 

  120.     log.info("Running post initiation steps")
    121. 

  121. 

  122.     if os.getenv("IRIS_WORKER") is None:
    123. 

  123.         create_directories()
    124. 

  124. 

  125.         # Attempt to connect to the database with retries
    126. 

  126.         log.info("Attempting to connect to the database...")
    127. 

  127.         for i in range(retry_count):
    128. 

  128.             log.info("Connecting to database, attempt " + str(i+1) + "/" + str(retry_count))
    129. 

  129.             conn = connect_to_database(db_host, db_port)
    130. 

  130.             if conn:
    131. 

  131.                 break
    132. 

  132.             log.info("Retrying in " + str(retry_delay) + "seconds...")
    133. 

  133.             time.sleep(retry_delay)
    134. 

  134.         # If the connection is still not established, exit the script
    135. 

  135.         if not conn:
    136. 

  136.             log.info("Failed to connect to database after " + str(retry_count) + " attempts.")
    137. 

  137.             exit(1)
    138. 

  138. 

  139.         # Setup database before everything
    140. 

  140.         #log.info("Adding pgcrypto extension")
    141. 

  141.         #pg_add_pgcrypto_ext()
    142. 

  142. 

  143.         # Setup database before everything
    144. 

  144.         with app.app_context():
    145. 

  145.             log.info("Creating all Iris tables")
    146. 

  146.             db.create_all(bind_key=None)
    147. 

  147.             db.session.commit()
    148. 

  148. 

  149.             log.info("Creating Celery metatasks tables")
    150. 

  150.             create_safe_db(db_name="iris_tasks")
    151. 

  151.             db.create_all(bind_key="iris_tasks")
    152. 

  152.             db.session.commit()
    153. 

  153. 

  154.             log.info("Running DB migration")
    155. 

  155. 

  156.             alembic_cfg = Config(file_='app/alembic.ini')
    157. 

  157.             alembic_cfg.set_main_option('sqlalchemy.url', app.config['SQLALCHEMY_DATABASE_URI'])
    158. 

  158.             command.upgrade(alembic_cfg, 'head')
    159. 

  159. 

  160.             # Create base server settings if they don't exist
    161. 

  161.             srv_settings = ServerSettings.query.first()
    162. 

  162.             if srv_settings is None:
    163. 

  163.                 log.info("Creating base server settings")
    164. 

  164.                 create_safe_server_settings()
    165. 

  165.                 srv_settings = ServerSettings.query.first()
    166. 

  166. 

  167.             prevent_objects = srv_settings.prevent_post_objects_repush
    168. 

  168. 

  169.             # Create base languages, OS types, IOC types, attributes, report types, TLP, event categories, assets,
    170. 

  170.             # analysis status, case classification, task status, severities, alert status, case states, and hooks
    171. 

  171.             log.info("Creating base languages")
    172. 

  172.             create_safe_languages()
    173. 

  173. 

  174.             log.info("Creating base os types")
    175. 

  175.             create_safe_os_types()
    176. 

  176. 

  177.             if not prevent_objects:
    178. 

  178.                 log.info("Creating base IOC types")
    179. 

  179.                 create_safe_ioctypes()
    180. 

  180. 

  181.             log.info("Creating base attributes")
    182. 

  182.             create_safe_attributes()
    183. 

  183. 

  184.             log.info("Creating base report types")
    185. 

  185.             create_safe_report_types()
    186. 

  186. 

  187.             log.info("Creating base TLP")
    188. 

  188.             create_safe_tlp()
    189. 

  189. 

  190.             log.info("Creating base events categories")
    191. 

  191.             create_safe_events_cats()
    192. 

  192. 

  193.             if not prevent_objects:
    194. 

  194.                 log.info("Creating base assets")
    195. 

  195.                 create_safe_assets()
    196. 

  196. 

  197.             log.info("Creating base analysis status")
    198. 

  198.             create_safe_analysis_status()
    199. 

  199. 

  200.             if not prevent_objects:
    201. 

  201.                 log.info("Creating base case classification")
    202. 

  202.                 create_safe_classifications()
    203. 

  203. 

  204.             log.info("Creating base tasks status")
    205. 

  205.             create_safe_task_status()
    206. 

  206. 

  207.             log.info("Creating base severities")
    208. 

  208.             create_safe_severities()
    209. 

  209. 

  210.             log.info("Creating base alert status")
    211. 

  211.             create_safe_alert_status()
    212. 

  212. 

  213.             log.info("Creating base evidence types")
    214. 

  214.             create_safe_evidence_types()
    215. 

  215. 

  216.             log.info("Creating base alert resolution status")
    217. 

  217.             create_safe_alert_resolution_status()
    218. 

  218. 

  219.             if not prevent_objects:
    220. 

  220.                 log.info("Creating base case states")
    221. 

  221.                 create_safe_case_states()
    222. 

  222. 

  223.             log.info("Creating base review status")
    224. 

  224.             create_safe_review_status()
    225. 

  225. 

  226.             log.info("Creating base hooks")
    227. 

  227.             create_safe_hooks()
    228. 

  228. 

  229.             # Create initial authorization model, administrative user, and customer
    230. 

  230.             log.info("Creating initial authorisation model")
    231. 

  231.             def_org, gadm, ganalysts = create_safe_auth_model()
    232. 

  232. 

  233.             log.info("Creating first administrative user")
    234. 

  234.             admin, pwd = create_safe_admin(def_org=def_org, gadm=gadm)
    235. 

  235. 

  236.             if not srv_settings.prevent_post_mod_repush:
    237. 

  237.                 log.info("Registering default modules")
    238. 

  238.                 register_default_modules()
    239. 

  239. 

  240.             log.info("Creating initial customer")
    241. 

  241.             client = create_safe_client()
    242. 

  242. 

  243.             log.info("Creating initial case")
    244. 

  244.             create_safe_case(
    245. 

  245.                 user=admin,
    246. 

  246.                 client=client,
    247. 

  247.                 groups=[gadm, ganalysts]
    248. 

  248.             )
    249. 

  249. 

  250.             # Setup symlinks for custom_assets
    251. 

  251.             log.info("Creating symlinks for custom asset icons")
    252. 

  252.             custom_assets_symlinks()
    253. 

  253. 

  254.             # If demo mode is enabled, create demo users and cases
    255. 

  255.             if app.config.get('DEMO_MODE_ENABLED') == 'True':
    256. 

  256.                 log.warning("============================")
    257. 

  257.                 log.warning("|  THIS IS DEMO INSTANCE   |")
    258. 

  258.                 log.warning("| DO NOT USE IN PRODUCTION |")
    259. 

  259.                 log.warning("============================")
    260. 

  260.                 users_data = create_demo_users(def_org, gadm, ganalysts,
    261. 

  261.                                                int(app.config.get('DEMO_USERS_COUNT', 10)),
    262. 

  262.                                                app.config.get('DEMO_USERS_SEED'),
    263. 

  263.                                                int(app.config.get('DEMO_ADM_COUNT', 4)),
    264. 

  264.                                                app.config.get('DEMO_ADM_SEED'))
    265. 

  265. 

  266.                 create_demo_cases(users_data=users_data,
    267. 

  267.                                   cases_count=int(app.config.get('DEMO_CASES_COUNT', 20)),
    268. 

  268.                                   clients_count=int(app.config.get('DEMO_CLIENTS_COUNT', 4)))
    269. 

  269. 

  270.             # Log completion message
    271. 

  271.             log.info("Post-init steps completed")
    272. 

  272.             log.warning("===============================")
    273. 

  273.             log.warning(f"| IRIS IS READY on port  {os.getenv('INTERFACE_HTTPS_PORT')} |")
    274. 

  274.             log.warning("===============================")
    275. 

  275. 

  276.             # If an administrative user was created, log their credentials
    277. 

  277.             if pwd is not None:
    278. 

  278.                 log.info(f'You can now login with user {admin.user} and password >>> {pwd} <<< '
    279. 

  279.                          f'on {os.getenv("INTERFACE_HTTPS_PORT")}')
    280. 

  280. 

  281. 

  282. def create_safe_db(db_name):
    283. 

  283.     """Creates a new database with the specified name if it does not already exist.
    284. 

  284. 

  285.     Args:
    286. 

  286.         db_name: A string representing the name of the database to create.
    287. 

  287.     """
    288. 

  288.     # Create a new engine object for the specified database
    289. 

  289.     engine = create_engine(app.config["SQALCHEMY_PIGGER_URI"] + db_name)
    290. 

  290. 

  291.     # Check if the database already exists
    292. 

  292.     if not database_exists(engine.url):
    293. 

  293.         # If the database does not exist, create it
    294. 

  294.         create_database(engine.url)
    295. 

  295. 

  296.     # Dispose of the engine object
    297. 

  297.     engine.dispose()
    298. 

  298. 

  299. 

  300. def create_safe_hooks():
    301. 

  301.     # --- Alert
    302. 

  302.     create_safe(db.session, IrisHook, hook_name='on_postload_alert_create',
    303. 

  303.                 hook_description='Triggered on alert creation, after commit in DB')
    304. 

  304. 

  305.     create_safe(db.session, IrisHook, hook_name='on_postload_alert_delete',
    306. 

  306.                 hook_description='Triggered on alert deletion, after commit in DB')
    307. 

  307. 

  308.     create_safe(db.session, IrisHook, hook_name='on_postload_alert_update',
    309. 

  309.                 hook_description='Triggered on alert update, after commit in DB')
    310. 

  310. 

  311.     create_safe(db.session, IrisHook, hook_name='on_postload_alert_resolution_update',
    312. 

  312.                 hook_description='Triggered on alert resolution update, after commit in DB')
    313. 

  313. 

  314.     create_safe(db.session, IrisHook, hook_name='on_postload_alert_status_update',
    315. 

  315.                 hook_description='Triggered on alert status update, after commit in DB')
    316. 

  316. 

  317.     create_safe(db.session, IrisHook, hook_name='on_postload_alert_escalate',
    318. 

  318.                 hook_description='Triggered on alert escalation, after commit in DB')
    319. 

  319. 

  320.     create_safe(db.session, IrisHook, hook_name='on_postload_alert_merge',
    321. 

  321.                 hook_description='Triggered on alert merge, after commit in DB')
    322. 

  322. 

  323.     create_safe(db.session, IrisHook, hook_name='on_postload_alert_unmerge',
    324. 

  324.                 hook_description='Triggered on alert unmerge, after commit in DB')
    325. 

  325. 

  326.     create_safe(db.session, IrisHook, hook_name='on_manual_trigger_alert',
    327. 

  327.                 hook_description='Triggered upon user action')
    328. 

  328. 

  329.     # --- Case
    330. 

  330.     create_safe(db.session, IrisHook, hook_name='on_preload_case_create',
    331. 

  331.                 hook_description='Triggered on case creation, before commit in DB')
    332. 

  332.     create_safe(db.session, IrisHook, hook_name='on_postload_case_create',
    333. 

  333.                 hook_description='Triggered on case creation, after commit in DB')
    334. 

  334. 

  335.     create_safe(db.session, IrisHook, hook_name='on_preload_case_delete',
    336. 

  336.                 hook_description='Triggered on case deletion, before commit in DB')
    337. 

  337.     create_safe(db.session, IrisHook, hook_name='on_postload_case_delete',
    338. 

  338.                 hook_description='Triggered on case deletion, after commit in DB')
    339. 

  339. 

  340.     create_safe(db.session, IrisHook, hook_name='on_postload_case_update',
    341. 

  341.                 hook_description='Triggered on case update, after commit in DB')
    342. 

  342. 

  343.     create_safe(db.session, IrisHook, hook_name='on_manual_trigger_case',
    344. 

  344.                 hook_description='Triggered upon user action')
    345. 

  345. 

  346.     # --- Assets
    347. 

  347.     create_safe(db.session, IrisHook, hook_name='on_preload_asset_create',
    348. 

  348.                 hook_description='Triggered on asset creation, before commit in DB')
    349. 

  349.     create_safe(db.session, IrisHook, hook_name='on_postload_asset_create',
    350. 

  350.                 hook_description='Triggered on asset creation, after commit in DB')
    351. 

  351. 

  352.     create_safe(db.session, IrisHook, hook_name='on_preload_asset_update',
    353. 

  353.                 hook_description='Triggered on asset update, before commit in DB')
    354. 

  354.     create_safe(db.session, IrisHook, hook_name='on_postload_asset_update',
    355. 

  355.                 hook_description='Triggered on asset update, after commit in DB')
    356. 

  356. 

  357.     create_safe(db.session, IrisHook, hook_name='on_preload_asset_delete',
    358. 

  358.                 hook_description='Triggered on asset deletion, before commit in DB')
    359. 

  359.     create_safe(db.session, IrisHook, hook_name='on_postload_asset_delete',
    360. 

  360.                 hook_description='Triggered on asset deletion, after commit in DB')
    361. 

  361. 

  362.     create_safe(db.session, IrisHook, hook_name='on_manual_trigger_asset',
    363. 

  363.                 hook_description='Triggered upon user action')
    364. 

  364. 

  365.     # --- Notes
    366. 

  366.     create_safe(db.session, IrisHook, hook_name='on_preload_note_create',
    367. 

  367.                 hook_description='Triggered on note creation, before commit in DB')
    368. 

  368.     create_safe(db.session, IrisHook, hook_name='on_postload_note_create',
    369. 

  369.                 hook_description='Triggered on note creation, after commit in DB')
    370. 

  370. 

  371.     create_safe(db.session, IrisHook, hook_name='on_preload_note_update',
    372. 

  372.                 hook_description='Triggered on note update, before commit in DB')
    373. 

  373.     create_safe(db.session, IrisHook, hook_name='on_postload_note_update',
    374. 

  374.                 hook_description='Triggered on note update, after commit in DB')
    375. 

  375. 

  376.     create_safe(db.session, IrisHook, hook_name='on_preload_note_delete',
    377. 

  377.                 hook_description='Triggered on note deletion, before commit in DB')
    378. 

  378.     create_safe(db.session, IrisHook, hook_name='on_postload_note_delete',
    379. 

  379.                 hook_description='Triggered on note deletion, after commit in DB')
    380. 

  380. 

  381.     create_safe(db.session, IrisHook, hook_name='on_manual_trigger_note',
    382. 

  382.                 hook_description='Triggered upon user action')
    383. 

  383. 

  384.     # --- iocs
    385. 

  385.     create_safe(db.session, IrisHook, hook_name='on_preload_ioc_create',
    386. 

  386.                 hook_description='Triggered on ioc creation, before commit in DB')
    387. 

  387.     create_safe(db.session, IrisHook, hook_name='on_postload_ioc_create',
    388. 

  388.                 hook_description='Triggered on ioc creation, after commit in DB')
    389. 

  389. 

  390.     create_safe(db.session, IrisHook, hook_name='on_preload_ioc_update',
    391. 

  391.                 hook_description='Triggered on ioc update, before commit in DB')
    392. 

  392.     create_safe(db.session, IrisHook, hook_name='on_postload_ioc_update',
    393. 

  393.                 hook_description='Triggered on ioc update, after commit in DB')
    394. 

  394. 

  395.     create_safe(db.session, IrisHook, hook_name='on_preload_ioc_delete',
    396. 

  396.                 hook_description='Triggered on ioc deletion, before commit in DB')
    397. 

  397.     create_safe(db.session, IrisHook, hook_name='on_postload_ioc_delete',
    398. 

  398.                 hook_description='Triggered on ioc deletion, after commit in DB')
    399. 

  399. 

  400.     create_safe(db.session, IrisHook, hook_name='on_manual_trigger_ioc',
    401. 

  401.                 hook_description='Triggered upon user action')
    402. 

  402. 

  403.     # --- events
    404. 

  404.     create_safe(db.session, IrisHook, hook_name='on_preload_event_create',
    405. 

  405.                 hook_description='Triggered on event creation, before commit in DB')
    406. 

  406.     create_safe(db.session, IrisHook, hook_name='on_postload_event_create',
    407. 

  407.                 hook_description='Triggered on event creation, after commit in DB')
    408. 

  408.     create_safe(db.session, IrisHook, hook_name='on_preload_event_duplicate',
    409. 

  409.                 hook_description='Triggered on event duplication, before commit in DB')
    410. 

  410. 

  411.     create_safe(db.session, IrisHook, hook_name='on_preload_event_update',
    412. 

  412.                 hook_description='Triggered on event update, before commit in DB')
    413. 

  413.     create_safe(db.session, IrisHook, hook_name='on_postload_event_update',
    414. 

  414.                 hook_description='Triggered on event update, after commit in DB')
    415. 

  415. 

  416.     create_safe(db.session, IrisHook, hook_name='on_preload_event_delete',
    417. 

  417.                 hook_description='Triggered on event deletion, before commit in DB')
    418. 

  418.     create_safe(db.session, IrisHook, hook_name='on_postload_event_delete',
    419. 

  419.                 hook_description='Triggered on event deletion, after commit in DB')
    420. 

  420. 

  421.     create_safe(db.session, IrisHook, hook_name='on_manual_trigger_event',
    422. 

  422.                 hook_description='Triggered upon user action')
    423. 

  423. 

  424.     # --- evidence
    425. 

  425.     create_safe(db.session, IrisHook, hook_name='on_preload_evidence_create',
    426. 

  426.                 hook_description='Triggered on evidence creation, before commit in DB')
    427. 

  427.     create_safe(db.session, IrisHook, hook_name='on_postload_evidence_create',
    428. 

  428.                 hook_description='Triggered on evidence creation, after commit in DB')
    429. 

  429. 

  430.     create_safe(db.session, IrisHook, hook_name='on_preload_evidence_update',
    431. 

  431.                 hook_description='Triggered on evidence update, before commit in DB')
    432. 

  432.     create_safe(db.session, IrisHook, hook_name='on_postload_evidence_update',
    433. 

  433.                 hook_description='Triggered on evidence update, after commit in DB')
    434. 

  434. 

  435.     create_safe(db.session, IrisHook, hook_name='on_preload_evidence_delete',
    436. 

  436.                 hook_description='Triggered on evidence deletion, before commit in DB')
    437. 

  437.     create_safe(db.session, IrisHook, hook_name='on_postload_evidence_delete',
    438. 

  438.                 hook_description='Triggered on evidence deletion, after commit in DB')
    439. 

  439. 

  440.     create_safe(db.session, IrisHook, hook_name='on_manual_trigger_evidence',
    441. 

  441.                 hook_description='Triggered upon user action')
    442. 

  442. 

  443.     # --- tasks
    444. 

  444.     create_safe(db.session, IrisHook, hook_name='on_preload_task_create',
    445. 

  445.                 hook_description='Triggered on task creation, before commit in DB')
    446. 

  446.     create_safe(db.session, IrisHook, hook_name='on_postload_task_create',
    447. 

  447.                 hook_description='Triggered on task creation, after commit in DB')
    448. 

  448. 

  449.     create_safe(db.session, IrisHook, hook_name='on_preload_task_update',
    450. 

  450.                 hook_description='Triggered on task update, before commit in DB')
    451. 

  451.     create_safe(db.session, IrisHook, hook_name='on_postload_task_update',
    452. 

  452.                 hook_description='Triggered on task update, after commit in DB')
    453. 

  453. 

  454.     create_safe(db.session, IrisHook, hook_name='on_preload_task_delete',
    455. 

  455.                 hook_description='Triggered on task deletion, before commit in DB')
    456. 

  456.     create_safe(db.session, IrisHook, hook_name='on_postload_task_delete',
    457. 

  457.                 hook_description='Triggered on task deletion, after commit in DB')
    458. 

  458. 

  459.     create_safe(db.session, IrisHook, hook_name='on_manual_trigger_task',
    460. 

  460.                 hook_description='Triggered upon user action')
    461. 

  461. 

  462.     # --- global tasks
    463. 

  463.     create_safe(db.session, IrisHook, hook_name='on_preload_global_task_create',
    464. 

  464.                 hook_description='Triggered on global task creation, before commit in DB')
    465. 

  465.     create_safe(db.session, IrisHook, hook_name='on_postload_global_task_create',
    466. 

  466.                 hook_description='Triggered on global task creation, after commit in DB')
    467. 

  467. 

  468.     create_safe(db.session, IrisHook, hook_name='on_preload_global_task_update',
    469. 

  469.                 hook_description='Triggered on task update, before commit in DB')
    470. 

  470.     create_safe(db.session, IrisHook, hook_name='on_postload_global_task_update',
    471. 

  471.                 hook_description='Triggered on global task update, after commit in DB')
    472. 

  472. 

  473.     create_safe(db.session, IrisHook, hook_name='on_preload_global_task_delete',
    474. 

  474.                 hook_description='Triggered on task deletion, before commit in DB')
    475. 

  475.     create_safe(db.session, IrisHook, hook_name='on_postload_global_task_delete',
    476. 

  476.                 hook_description='Triggered on global task deletion, after commit in DB')
    477. 

  477. 

  478.     create_safe(db.session, IrisHook, hook_name='on_manual_trigger_global_task',
    479. 

  479.                 hook_description='Triggered upon user action')
    480. 

  480. 

  481.     # --- reports
    482. 

  482.     create_safe(db.session, IrisHook, hook_name='on_preload_report_create',
    483. 

  483.                 hook_description='Triggered on report creation, before generation in DB')
    484. 

  484.     create_safe(db.session, IrisHook, hook_name='on_postload_report_create',
    485. 

  485.                 hook_description='Triggered on report creation, before download of the document')
    486. 

  486. 

  487.     create_safe(db.session, IrisHook, hook_name='on_preload_activities_report_create',
    488. 

  488.                 hook_description='Triggered on activities report creation, before generation in DB')
    489. 

  489.     create_safe(db.session, IrisHook, hook_name='on_postload_activities_report_create',
    490. 

  490.                 hook_description='Triggered on activities report creation, before download of the document')
    491. 

  491. 

  492.     # --- comments
    493. 

  493.     create_safe(db.session, IrisHook, hook_name='on_postload_asset_commented',
    494. 

  494.                 hook_description='Triggered on event commented, after commit in DB')
    495. 

  495.     create_safe(db.session, IrisHook, hook_name='on_postload_asset_comment_update',
    496. 

  496.                 hook_description='Triggered on event comment update, after commit in DB')
    497. 

  497.     create_safe(db.session, IrisHook, hook_name='on_postload_asset_comment_delete',
    498. 

  498.                 hook_description='Triggered on event comment deletion, after commit in DB')
    499. 

  499. 

  500.     create_safe(db.session, IrisHook, hook_name='on_postload_evidence_commented',
    501. 

  501.                 hook_description='Triggered on evidence commented, after commit in DB')
    502. 

  502.     create_safe(db.session, IrisHook, hook_name='on_postload_evidence_comment_update',
    503. 

  503.                 hook_description='Triggered on evidence comment update, after commit in DB')
    504. 

  504.     create_safe(db.session, IrisHook, hook_name='on_postload_evidence_comment_delete',
    505. 

  505.                 hook_description='Triggered on evidence comment deletion, after commit in DB')
    506. 

  506. 

  507.     create_safe(db.session, IrisHook, hook_name='on_postload_task_commented',
    508. 

  508.                 hook_description='Triggered on task commented, after commit in DB')
    509. 

  509.     create_safe(db.session, IrisHook, hook_name='on_postload_task_comment_update',
    510. 

  510.                 hook_description='Triggered on task comment update, after commit in DB')
    511. 

  511.     create_safe(db.session, IrisHook, hook_name='on_postload_task_comment_delete',
    512. 

  512.                 hook_description='Triggered on task comment deletion, after commit in DB')
    513. 

  513. 

  514.     create_safe(db.session, IrisHook, hook_name='on_postload_ioc_commented',
    515. 

  515.                 hook_description='Triggered on IOC commented, after commit in DB')
    516. 

  516.     create_safe(db.session, IrisHook, hook_name='on_postload_ioc_comment_update',
    517. 

  517.                 hook_description='Triggered on IOC comment update, after commit in DB')
    518. 

  518.     create_safe(db.session, IrisHook, hook_name='on_postload_ioc_comment_delete',
    519. 

  519.                 hook_description='Triggered on IOC comment deletion, after commit in DB')
    520. 

  520. 

  521.     create_safe(db.session, IrisHook, hook_name='on_postload_event_commented',
    522. 

  522.                 hook_description='Triggered on event commented, after commit in DB')
    523. 

  523.     create_safe(db.session, IrisHook, hook_name='on_postload_event_comment_update',
    524. 

  524.                 hook_description='Triggered on event comment update, after commit in DB')
    525. 

  525.     create_safe(db.session, IrisHook, hook_name='on_postload_event_comment_delete',
    526. 

  526.                 hook_description='Triggered on event comment deletion, after commit in DB')
    527. 

  527. 

  528.     create_safe(db.session, IrisHook, hook_name='on_postload_note_commented',
    529. 

  529.                 hook_description='Triggered on note commented, after commit in DB')
    530. 

  530.     create_safe(db.session, IrisHook, hook_name='on_postload_note_comment_update',
    531. 

  531.                 hook_description='Triggered on note comment update, after commit in DB')
    532. 

  532.     create_safe(db.session, IrisHook, hook_name='on_postload_note_comment_delete',
    533. 

  533.                 hook_description='Triggered on note comment deletion, after commit in DB')
    534. 

  534. 

  535.     create_safe(db.session, IrisHook, hook_name='on_postload_alert_commented',
    536. 

  536.                 hook_description='Triggered on alert commented, after commit in DB')
    537. 

  537.     create_safe(db.session, IrisHook, hook_name='on_postload_alert_comment_update',
    538. 

  538.                 hook_description='Triggered on alert comment update, after commit in DB')
    539. 

  539.     create_safe(db.session, IrisHook, hook_name='on_postload_alert_comment_delete',
    540. 

  540.                 hook_description='Triggered on alert comment deletion, after commit in DB')
    541. 

  541. 

  542. 

  543. def pg_add_pgcrypto_ext():
    544. 

  544.     """Adds the pgcrypto extension to the PostgreSQL database.
    545. 

  545. 

  546.     This extension provides cryptographic functions for PostgreSQL.
    547. 

  547. 

  548.     """
    549. 

  549. 

  550.     # Set the application context
    551. 

  551.     with app.app_context():
    552. 

  552. 

  553.         # Open a connection to the iris_db database
    554. 

  554.         with db.engine.connect() as con:
    555. 

  555.             # Execute a SQL command to create the pgcrypto extension if it does not already exist
    556. 

  556.             con.execute(text('CREATE EXTENSION IF NOT EXISTS pgcrypto CASCADE;'))
    557. 

  557.             db.session.commit()
    558. 

  558.             log.info("pgcrypto extension added")
    559. 

  559. 

  560. 

  561. def create_safe_languages():
    562. 

  562.     """Creates new Language objects if they do not already exist.
    563. 

  563. 

  564.     This function creates new Language objects with the specified name and code
    565. 

  565.     if they do not already exist in the database.
    566. 

  566. 

  567.     """
    568. 

  568.     # Create new Language objects for each language
    569. 

  569.     create_safe(db.session, Languages, name="french", code="FR")
    570. 

  570.     create_safe(db.session, Languages, name="english", code="EN")
    571. 

  571.     create_safe(db.session, Languages, name="german", code="DE")
    572. 

  572.     create_safe(db.session, Languages, name="bulgarian", code="BG")
    573. 

  573.     create_safe(db.session, Languages, name="croatian", code="HR")
    574. 

  574.     create_safe(db.session, Languages, name="danish", code="DK")
    575. 

  575.     create_safe(db.session, Languages, name="dutch", code="NL")
    576. 

  576.     create_safe(db.session, Languages, name="estonian", code="EE")
    577. 

  577.     create_safe(db.session, Languages, name="finnish", code="FI")
    578. 

  578.     create_safe(db.session, Languages, name="greek", code="GR")
    579. 

  579.     create_safe(db.session, Languages, name="hungarian", code="HU")
    580. 

  580.     create_safe(db.session, Languages, name="irish", code="IE")
    581. 

  581.     create_safe(db.session, Languages, name="italian", code="IT")
    582. 

  582.     create_safe(db.session, Languages, name="latvian", code="LV")
    583. 

  583.     create_safe(db.session, Languages, name="lithuanian", code="LT")
    584. 

  584.     create_safe(db.session, Languages, name="maltese", code="MT")
    585. 

  585.     create_safe(db.session, Languages, name="polish", code="PL")
    586. 

  586.     create_safe(db.session, Languages, name="portuguese", code="PT")
    587. 

  587.     create_safe(db.session, Languages, name="romanian", code="RO")
    588. 

  588.     create_safe(db.session, Languages, name="slovak", code="SK")
    589. 

  589.     create_safe(db.session, Languages, name="slovenian", code="SI")
    590. 

  590.     create_safe(db.session, Languages, name="spanish", code="ES")
    591. 

  591.     create_safe(db.session, Languages, name="swedish", code="SE")
    592. 

  592.     create_safe(db.session, Languages, name="indian", code="IN")
    593. 

  593.     create_safe(db.session, Languages, name="chinese", code="CN")
    594. 

  594.     create_safe(db.session, Languages, name="korean", code="KR")
    595. 

  595.     create_safe(db.session, Languages, name="arabic", code="AR")
    596. 

  596.     create_safe(db.session, Languages, name="japanese", code="JP")
    597. 

  597.     create_safe(db.session, Languages, name="turkish", code="TR")
    598. 

  598.     create_safe(db.session, Languages, name="vietnamese", code="VN")
    599. 

  599.     create_safe(db.session, Languages, name="thai", code="TH")
    600. 

  600.     create_safe(db.session, Languages, name="hebrew", code="IL")
    601. 

  601.     create_safe(db.session, Languages, name="czech", code="CZ")
    602. 

  602.     create_safe(db.session, Languages, name="norwegian", code="NO")
    603. 

  603.     create_safe(db.session, Languages, name="brazilian", code="BR")
    604. 

  604.     create_safe(db.session, Languages, name="ukrainian", code="UA")
    605. 

  605.     create_safe(db.session, Languages, name="catalan", code="CA")
    606. 

  606.     create_safe(db.session, Languages, name="serbian", code="RS")
    607. 

  607.     create_safe(db.session, Languages, name="persian", code="IR")
    608. 

  608.     create_safe(db.session, Languages, name="afrikaans", code="ZA")
    609. 

  609.     create_safe(db.session, Languages, name="albanian", code="AL")
    610. 

  610.     create_safe(db.session, Languages, name="armenian", code="AM")
    611. 

  611. 

  612. 

  613. def create_safe_events_cats():
    614. 

  614.     """Creates new EventCategory objects if they do not already exist.
    615. 

  615. 

  616.     This function creates new EventCategory objects with the specified name
    617. 

  617.     if they do not already exist in the database.
    618. 

  618. 

  619.     """
    620. 

  620.     # Create new EventCategory objects for each category
    621. 

  621.     create_safe(db.session, EventCategory, name="Unspecified")
    622. 

  622.     create_safe(db.session, EventCategory, name="Legitimate")
    623. 

  623.     create_safe(db.session, EventCategory, name="Remediation")
    624. 

  624.     create_safe(db.session, EventCategory, name="Initial Access")
    625. 

  625.     create_safe(db.session, EventCategory, name="Execution")
    626. 

  626.     create_safe(db.session, EventCategory, name="Persistence")
    627. 

  627.     create_safe(db.session, EventCategory, name="Privilege Escalation")
    628. 

  628.     create_safe(db.session, EventCategory, name="Defense Evasion")
    629. 

  629.     create_safe(db.session, EventCategory, name="Credential Access")
    630. 

  630.     create_safe(db.session, EventCategory, name="Discovery")
    631. 

  631.     create_safe(db.session, EventCategory, name="Lateral Movement")
    632. 

  632.     create_safe(db.session, EventCategory, name="Collection")
    633. 

  633.     create_safe(db.session, EventCategory, name="Command and Control")
    634. 

  634.     create_safe(db.session, EventCategory, name="Exfiltration")
    635. 

  635.     create_safe(db.session, EventCategory, name="Impact")
    636. 

  636. 

  637. 

  638. def create_safe_classifications():
    639. 

  639.     """Creates new CaseClassification objects if they do not already exist.
    640. 

  640. 

  641.     This function reads the MISP classification taxonomy from a JSON file and creates
    642. 

  642.     new CaseClassification objects with the specified name, name_expanded, and description
    643. 

  643.     if they do not already exist in the database.
    644. 

  644. 

  645.     """
    646. 

  646.     # Read the MISP classification taxonomy from a JSON file
    647. 

  647.     log.info("Reading MISP classification taxonomy from resources/misp.classification.taxonomy.json")
    648. 

  648.     with open(Path(__file__).parent / 'resources' / 'misp.classification.taxonomy.json') as data_file:
    649. 

  649.         data = json.load(data_file)
    650. 

  650.         # Iterate over each classification in the taxonomy
    651. 

  651.         for c in data.get('values'):
    652. 

  652.             predicate = c.get('predicate')
    653. 

  653.             entries = c.get('entry')
    654. 

  654.             # Iterate over each entry in the classification
    655. 

  655.             for entry in entries:
    656. 

  656.                 # Create a new CaseClassification object with the specified name, name_expanded, and description
    657. 

  657.                 create_safe(db.session, CaseClassification,
    658. 

  658.                             name=f"{predicate}:{entry.get('value')}",
    659. 

  659.                             name_expanded=f"{predicate.title()}: {entry.get('expanded')}",
    660. 

  660.                             description=entry['description'])
    661. 

  661. 

  662. 

  663. def create_safe_analysis_status():
    664. 

  664.     """Creates new AnalysisStatus objects if they do not already exist.
    665. 

  665. 

  666.     This function creates new AnalysisStatus objects with the specified name
    667. 

  667.     if they do not already exist in the database.
    668. 

  668. 

  669.     """
    670. 

  670.     # Create new AnalysisStatus objects for each status
    671. 

  671.     create_safe(db.session, AnalysisStatus, name='Unspecified')
    672. 

  672.     create_safe(db.session, AnalysisStatus, name='To be done')
    673. 

  673.     create_safe(db.session, AnalysisStatus, name='Started')
    674. 

  674.     create_safe(db.session, AnalysisStatus, name='Pending')
    675. 

  675.     create_safe(db.session, AnalysisStatus, name='Canceled')
    676. 

  676.     create_safe(db.session, AnalysisStatus, name='Done')
    677. 

  677. 

  678. 

  679. def create_safe_task_status():
    680. 

  680.     """Creates new TaskStatus objects if they do not already exist.
    681. 

  681. 

  682.     This function creates new TaskStatus objects with the specified status name,
    683. 

  683.     status description, and Bootstrap color if they do not already exist in the database.
    684. 

  684. 

  685.     """
    686. 

  686.     # Create new TaskStatus objects for each status
    687. 

  687.     create_safe(db.session, TaskStatus, status_name='To do', status_description="", status_bscolor="danger")
    688. 

  688.     create_safe(db.session, TaskStatus, status_name='In progress', status_description="", status_bscolor="warning")
    689. 

  689.     create_safe(db.session, TaskStatus, status_name='On hold', status_description="", status_bscolor="muted")
    690. 

  690.     create_safe(db.session, TaskStatus, status_name='Done', status_description="", status_bscolor="success")
    691. 

  691.     create_safe(db.session, TaskStatus, status_name='Canceled', status_description="", status_bscolor="muted")
    692. 

  692. 

  693. 

  694. def create_safe_severities():
    695. 

  695.     """Creates new Severity objects if they do not already exist.
    696. 

  696. 

  697.     This function creates new Severity objects with the specified severity name
    698. 

  698.     and severity description if they do not already exist in the database.
    699. 

  699. 

  700.     """
    701. 

  701.     # Create new Severity objects for each severity level
    702. 

  702.     create_safe(db.session, Severity, severity_name='Unspecified', severity_description="Unspecified")
    703. 

  703.     create_safe(db.session, Severity, severity_name='Informational', severity_description="Informational")
    704. 

  704.     create_safe(db.session, Severity, severity_name='Low', severity_description="Low")
    705. 

  705.     create_safe(db.session, Severity, severity_name='Medium', severity_description="Medium")
    706. 

  706.     create_safe(db.session, Severity, severity_name='High', severity_description="High")
    707. 

  707.     create_safe(db.session, Severity, severity_name='Critical', severity_description="Critical")
    708. 

  708. 

  709. 

  710. def create_safe_alert_status():
    711. 

  711.     """Creates new AlertStatus objects if they do not already exist.
    712. 

  712. 

  713.     This function creates new AlertStatus objects with the specified status name
    714. 

  714.     and status description if they do not already exist in the database.
    715. 

  715. 

  716.     """
    717. 

  717.     # Create new AlertStatus objects for each status
    718. 

  718.     create_safe(db.session, AlertStatus, status_name='Unspecified', status_description="Unspecified")
    719. 

  719.     create_safe(db.session, AlertStatus, status_name='New', status_description="Alert is new and unassigned")
    720. 

  720.     create_safe(db.session, AlertStatus, status_name='Assigned', status_description="Alert is assigned to a user and "
    721. 

  721.                                                                                     "pending investigation")
    722. 

  722.     create_safe(db.session, AlertStatus, status_name='In progress', status_description="Alert is being investigated")
    723. 

  723.     create_safe(db.session, AlertStatus, status_name='Pending', status_description="Alert is in a pending state")
    724. 

  724.     create_safe(db.session, AlertStatus, status_name='Closed', status_description="Alert closed, no action taken")
    725. 

  725.     create_safe(db.session, AlertStatus, status_name='Merged', status_description="Alert merged into an existing case")
    726. 

  726.     create_safe(db.session, AlertStatus, status_name='Escalated', status_description="Alert converted to a new case")
    727. 

  727. 

  728. 

  729. def create_safe_evidence_types():
    730. 

  730.     """Creates new Evidence Types objects if they do not already exist.
    731. 

  731. 

  732.     This function creates new Evidence Types objects with the specified type name
    733. 

  733.     and type description if they do not already exist in the database.
    734. 

  734. 

  735.     """
    736. 

  736.     # Create new EvidenceType objects for each status
    737. 

  737.     create_safe(db.session, EvidenceTypes, name='Unspecified', description="Unspecified")
    738. 

  738. 

  739.     create_safe(db.session, EvidenceTypes, name='HDD image - Generic', description="Generic copy of an hard drive")
    740. 

  740.     create_safe(db.session, EvidenceTypes, name='HDD image - DD - Other', description="DD copy of an hard drive")
    741. 

  741.     create_safe(db.session, EvidenceTypes, name='HDD image - DD - Windows', description="DD copy of an hard drive")
    742. 

  742.     create_safe(db.session, EvidenceTypes, name='HDD image - DD - Unix', description="DD copy of an hard drive")
    743. 

  743.     create_safe(db.session, EvidenceTypes, name='HDD image - DD - MacOS', description="DD copy of an hard drive")
    744. 

  744. 

  745.     create_safe(db.session, EvidenceTypes, name='HDD image - E01 - Other', description="E01 acquisition of an hard drive")
    746. 

  746.     create_safe(db.session, EvidenceTypes, name='HDD image - E01 - Windows', description="E01 acquisition of an hard drive")
    747. 

  747.     create_safe(db.session, EvidenceTypes, name='HDD image - E01 - Unix', description="E01 acquisition of an hard drive")
    748. 

  748.     create_safe(db.session, EvidenceTypes, name='HDD image - E01 - MacOS', description="E01 acquisition of an hard drive")
    749. 

  749. 

  750.     create_safe(db.session, EvidenceTypes, name='HDD image - AFF4 - Other', description="AFF4 acquisition of an hard drive")
    751. 

  751.     create_safe(db.session, EvidenceTypes, name='HDD image - AFF4 - Windows', description="AFF4 acquisition of an hard drive")
    752. 

  752.     create_safe(db.session, EvidenceTypes, name='HDD image - AFF4 - Unix', description="AFF4 acquisition of an hard drive")
    753. 

  753.     create_safe(db.session, EvidenceTypes, name='HDD image - AFF4 - MacOS', description="AFF4 acquisition of an hard drive")
    754. 

  754. 

  755.     create_safe(db.session, EvidenceTypes, name='SSD image - Generic', description="Generic copy of an solid state drive")
    756. 

  756.     create_safe(db.session, EvidenceTypes, name='SSD image - DD - Other', description="DD copy of an solid state drive")
    757. 

  757.     create_safe(db.session, EvidenceTypes, name='SSD image - DD - Windows', description="DD copy of an solid state drive")
    758. 

  758.     create_safe(db.session, EvidenceTypes, name='SSD image - DD - Unix', description="DD copy of an solid state drive")
    759. 

  759.     create_safe(db.session, EvidenceTypes, name='SSD image - DD - MacOS', description="DD copy of an solid state drive")
    760. 

  760. 

  761.     create_safe(db.session, EvidenceTypes, name='SSD image - E01 - Other', description="EO1 copy of a solid state drive")
    762. 

  762.     create_safe(db.session, EvidenceTypes, name='SSD image - E01 - Windows', description="EO1 copy of a solid state drive")
    763. 

  763.     create_safe(db.session, EvidenceTypes, name='SSD image - E01 - Unix', description="EO1 copy of a solid state drive")
    764. 

  764.     create_safe(db.session, EvidenceTypes, name='SSD image - E01 - MacOS', description="EO1 copy of MacOS on a solid state drive")
    765. 

  765. 

  766.     create_safe(db.session, EvidenceTypes, name='SSD image - AFF4 - Other', description="AFF4 copy of an solid state drive")
    767. 

  767.     create_safe(db.session, EvidenceTypes, name='SSD image - AFF4 - Windows', description="AFF4 copy of an solid state drive")
    768. 

  768.     create_safe(db.session, EvidenceTypes, name='SSD image - AFF4 - Unix', description="AFF4 copy of an solid state drive")
    769. 

  769.     create_safe(db.session, EvidenceTypes, name='SSD image - AFF4 - MacOS', description="AFF4 copy of an solid state drive")
    770. 

  770. 

  771.     create_safe(db.session, EvidenceTypes, name='VM image - Generic', description="Generic copy of a VM ")
    772. 

  772.     create_safe(db.session, EvidenceTypes, name='VM image - Linux Server', description="Copy of a Linux Server VM")
    773. 

  773.     create_safe(db.session, EvidenceTypes, name='VM image - Windows Server', description="Copy of a Windows Server VM")
    774. 

  774.     create_safe(db.session, EvidenceTypes, name='VM image - Windows Server', description="Copy of a Windows Server VM")
    775. 

  775. 

  776.     create_safe(db.session, EvidenceTypes, name='Phone Image - Android', description="Copy of an Android phone")
    777. 

  777.     create_safe(db.session, EvidenceTypes, name='Phone Image - iPhone', description="Copy of an iPhone")
    778. 

  778.     create_safe(db.session, EvidenceTypes, name='Phone backup - Android (adb)', description="adb backup of an Android")
    779. 

  779.     create_safe(db.session, EvidenceTypes, name='Phone backup - iPhone (iTunes)', description="iTunes backup of an iPhone")
    780. 

  780. 

  781.     create_safe(db.session, EvidenceTypes, name='Tablet Image - Android', description="Copy of an Android tablet")
    782. 

  782.     create_safe(db.session, EvidenceTypes, name='Tablet Image - iPad', description="Copy of an iPad tablet")
    783. 

  783.     create_safe(db.session, EvidenceTypes, name='Tablet backup - Android (adb)', description="adb backup of an Android tablet")
    784. 

  784.     create_safe(db.session, EvidenceTypes, name='Tablet backup - iPad (iTunes)', description="iTunes backup of an iPad")
    785. 

  785. 

  786.     create_safe(db.session, EvidenceTypes, name='Collection - Velociraptor', description="Velociraptor collection")
    787. 

  787.     create_safe(db.session, EvidenceTypes, name='Collection - ORC', description="ORC collection")
    788. 

  788.     create_safe(db.session, EvidenceTypes, name='Collection - KAPE', description="KAPE collection")
    789. 

  789. 

  790.     create_safe(db.session, EvidenceTypes, name="Memory acquisition - Physical RAM", description="Physical RAM acquisition")
    791. 

  791.     create_safe(db.session, EvidenceTypes, name="Memory acquisition - VMEM", description="vmem file")
    792. 

  792. 

  793.     create_safe(db.session, EvidenceTypes, name="Logs - Linux", description="Standard Linux logs")
    794. 

  794.     create_safe(db.session, EvidenceTypes, name="Logs - Windows EVTX", description="Standard Windows EVTX logs")
    795. 

  795.     create_safe(db.session, EvidenceTypes, name="Logs - Windows EVT", description="Standard Windows EVT logs")
    796. 

  796.     create_safe(db.session, EvidenceTypes, name="Logs - MacOS", description="Standard MacOS logs")
    797. 

  797.     create_safe(db.session, EvidenceTypes, name="Logs - Generic", description="Generic logs")
    798. 

  798.     create_safe(db.session, EvidenceTypes, name="Logs - Firewall", description="Firewall logs")
    799. 

  799.     create_safe(db.session, EvidenceTypes, name="Logs - Proxy", description="Proxy logs")
    800. 

  800.     create_safe(db.session, EvidenceTypes, name="Logs - DNS", description="DNS logs")
    801. 

  801.     create_safe(db.session, EvidenceTypes, name="Logs - Email", description="Email logs")
    802. 

  802. 

  803.     create_safe(db.session, EvidenceTypes, name="Executable - Windows (PE)", description="Generic Windows executable")
    804. 

  804.     create_safe(db.session, EvidenceTypes, name="Executable - Linux (ELF)", description="Generic Linux executable")
    805. 

  805.     create_safe(db.session, EvidenceTypes, name="Executable - MacOS (Mach-O)", description="Generic MacOS executable")
    806. 

  806.     create_safe(db.session, EvidenceTypes, name="Executable - Generic", description="Generic executable")
    807. 

  807. 

  808.     create_safe(db.session, EvidenceTypes, name="Script - Generic", description="Generic script")
    809. 

  809. 

  810.     create_safe(db.session, EvidenceTypes, name="Generic - Data blob", description="Generic blob of data")
    811. 

  811. 

  812. 

  813. def create_safe_alert_resolution_status():
    814. 

  814.     """Creates new AlertResolutionStatus objects if they do not already exist.
    815. 

  815. 

  816.     This function creates new AlertResolutionStatus objects with the specified resolution_status_name
    817. 

  817.     and resolution_status_description if they do not already exist in the database.
    818. 

  818. 

  819.     """
    820. 

  820.     create_safe(db.session, AlertResolutionStatus, resolution_status_name='False Positive',
    821. 

  821.                 resolution_status_description="The alert was a false positive")
    822. 

  822.     create_safe(db.session, AlertResolutionStatus, resolution_status_name='True Positive With Impact',
    823. 

  823.                 resolution_status_description="The alert was a true positive and had an impact")
    824. 

  824.     create_safe(db.session, AlertResolutionStatus, resolution_status_name='True Positive Without Impact',
    825. 

  825.                 resolution_status_description="The alert was a true positive but had no impact")
    826. 

  826.     create_safe(db.session, AlertResolutionStatus, resolution_status_name='Not Applicable',
    827. 

  827.                 resolution_status_description="The alert is not applicable")
    828. 

  828.     create_safe(db.session, AlertResolutionStatus, resolution_status_name='Unknown',
    829. 

  829.                 resolution_status_description="Unknown resolution status")
    830. 

  830.     create_safe(db.session, AlertResolutionStatus, resolution_status_name='Legitimate',
    831. 

  831.                 resolution_status_description="The alert is acceptable and expected")
    832. 

  832. 

  833. 

  834. def create_safe_case_states():
    835. 

  835.     """Creates new CaseState objects if they do not already exist.
    836. 

  836. 

  837.     This function creates new CaseState objects with the specified state name,
    838. 

  838.     state description, and protected status if they do not already exist in the database.
    839. 

  839. 

  840.     """
    841. 

  841.     # Create new CaseState objects for each state
    842. 

  842.     create_safe(db.session, CaseState, state_name='Unspecified', state_description="Unspecified", protected=True)
    843. 

  843.     create_safe(db.session, CaseState, state_name='In progress', state_description="Case is being investigated")
    844. 

  844.     create_safe(db.session, CaseState, state_name='Open', state_description="Case is open", protected=True)
    845. 

  845.     create_safe(db.session, CaseState, state_name='Containment', state_description="Containment is in progress")
    846. 

  846.     create_safe(db.session, CaseState, state_name='Eradication', state_description="Eradication is in progress")
    847. 

  847.     create_safe(db.session, CaseState, state_name='Recovery', state_description="Recovery is in progress")
    848. 

  848.     create_safe(db.session, CaseState, state_name='Post-Incident', state_description="Post-incident phase")
    849. 

  849.     create_safe(db.session, CaseState, state_name='Reporting', state_description="Reporting is in progress")
    850. 

  850.     create_safe(db.session, CaseState, state_name='Closed', state_description="Case is closed", protected=True)
    851. 

  851. 

  852. 

  853. def create_safe_review_status():
    854. 

  854.     """Creates new ReviewStatus objects if they do not already exist.
    855. 

  855. 

  856.     This function creates new ReviewStatus objects with the specified status name
    857. 

  857.     if they do not already exist in the database.
    858. 

  858.     """
    859. 

  859.     create_safe(db.session, ReviewStatus, status_name=ReviewStatusList.no_review_required)
    860. 

  860.     create_safe(db.session, ReviewStatus, status_name=ReviewStatusList.not_reviewed)
    861. 

  861.     create_safe(db.session, ReviewStatus, status_name=ReviewStatusList.pending_review)
    862. 

  862.     create_safe(db.session, ReviewStatus, status_name=ReviewStatusList.review_in_progress)
    863. 

  863.     create_safe(db.session, ReviewStatus, status_name=ReviewStatusList.reviewed)
    864. 

  864. 

  865. 

  866. def create_safe_assets():
    867. 

  867.     """Creates new AssetsType objects if they do not already exist.
    868. 

  868. 

  869.     This function creates new AssetsType objects with the specified asset name,
    870. 

  870.     asset description, and asset icons if they do not already exist in the database.
    871. 

  871. 

  872.     """
    873. 

  873.     # Create new AssetsType objects for each asset type
    874. 

  874.     get_by_value_or_create(db.session, AssetsType, "asset_name", asset_name="Account",
    875. 

  875.                            asset_description="Generic Account", asset_icon_not_compromised="user.png",
    876. 

  876.                            asset_icon_compromised="ioc_user.png")
    877. 

  877.     get_by_value_or_create(db.session, AssetsType, "asset_name", asset_name="Firewall", asset_description="Firewall",
    878. 

  878.                            asset_icon_not_compromised="firewall.png", asset_icon_compromised="ioc_firewall.png")
    879. 

  879.     get_by_value_or_create(db.session, AssetsType, "asset_name", asset_name="Linux - Server",
    880. 

  880.                            asset_description="Linux server", asset_icon_not_compromised="server.png",
    881. 

  881.                            asset_icon_compromised="ioc_server.png")
    882. 

  882.     get_by_value_or_create(db.session, AssetsType, "asset_name", asset_name="Linux - Computer",
    883. 

  883.                            asset_description="Linux computer", asset_icon_not_compromised="desktop.png",
    884. 

  884.                            asset_icon_compromised="ioc_desktop.png")
    885. 

  885.     get_by_value_or_create(db.session, AssetsType, "asset_name", asset_name="Linux Account",
    886. 

  886.                            asset_description="Linux Account", asset_icon_not_compromised="user.png",
    887. 

  887.                            asset_icon_compromised="ioc_user.png")
    888. 

  888.     get_by_value_or_create(db.session, AssetsType, "asset_name", asset_name="Mac - Computer",
    889. 

  889.                            asset_description="Mac computer", asset_icon_not_compromised="desktop.png",
    890. 

  890.                            asset_icon_compromised="ioc_desktop.png")
    891. 

  891.     get_by_value_or_create(db.session, AssetsType, "asset_name", asset_name="Phone - Android",
    892. 

  892.                            asset_description="Android Phone", asset_icon_not_compromised="phone.png",
    893. 

  893.                            asset_icon_compromised="ioc_phone.png")
    894. 

  894.     get_by_value_or_create(db.session, AssetsType, "asset_name", asset_name="Phone - IOS",
    895. 

  895.                            asset_description="Apple Phone", asset_icon_not_compromised="phone.png",
    896. 

  896.                            asset_icon_compromised="ioc_phone.png")
    897. 

  897.     get_by_value_or_create(db.session, AssetsType, "asset_name", asset_name="Windows - Computer",
    898. 

  898.                            asset_description="Standard Windows Computer",
    899. 

  899.                            asset_icon_not_compromised="windows_desktop.png",
    900. 

  900.                            asset_icon_compromised="ioc_windows_desktop.png")
    901. 

  901.     get_by_value_or_create(db.session, AssetsType, "asset_name", asset_name="Windows - Server",
    902. 

  902.                            asset_description="Standard Windows Server", asset_icon_not_compromised="windows_server.png",
    903. 

  903.                            asset_icon_compromised="ioc_windows_server.png")
    904. 

  904.     get_by_value_or_create(db.session, AssetsType, "asset_name", asset_name="Windows - DC",
    905. 

  905.                            asset_description="Domain Controller", asset_icon_not_compromised="windows_server.png",
    906. 

  906.                            asset_icon_compromised="ioc_windows_server.png")
    907. 

  907.     get_by_value_or_create(db.session, AssetsType, "asset_name", asset_name="Router", asset_description="Router",
    908. 

  908.                            asset_icon_not_compromised="router.png", asset_icon_compromised="ioc_router.png")
    909. 

  909.     get_by_value_or_create(db.session, AssetsType, "asset_name", asset_name="Switch", asset_description="Switch",
    910. 

  910.                            asset_icon_not_compromised="switch.png", asset_icon_compromised="ioc_switch.png")
    911. 

  911.     get_by_value_or_create(db.session, AssetsType, "asset_name", asset_name="VPN", asset_description="VPN",
    912. 

  912.                            asset_icon_not_compromised="vpn.png", asset_icon_compromised="ioc_vpn.png")
    913. 

  913.     get_by_value_or_create(db.session, AssetsType, "asset_name", asset_name="WAF", asset_description="WAF",
    914. 

  914.                            asset_icon_not_compromised="firewall.png", asset_icon_compromised="ioc_firewall.png")
    915. 

  915.     get_by_value_or_create(db.session, AssetsType, "asset_name", asset_name="Windows Account - Local",
    916. 

  916.                            asset_description="Windows Account - Local", asset_icon_not_compromised="user.png",
    917. 

  917.                            asset_icon_compromised="ioc_user.png")
    918. 

  918.     get_by_value_or_create(db.session, AssetsType, "asset_name", asset_name="Windows Account - Local - Admin",
    919. 

  919.                            asset_description="Windows Account - Local - Admin", asset_icon_not_compromised="user.png",
    920. 

  920.                            asset_icon_compromised="ioc_user.png")
    921. 

  921.     get_by_value_or_create(db.session, AssetsType, "asset_name", asset_name="Windows Account - AD",
    922. 

  922.                            asset_description="Windows Account - AD", asset_icon_not_compromised="user.png",
    923. 

  923.                            asset_icon_compromised="ioc_user.png")
    924. 

  924.     get_by_value_or_create(db.session, AssetsType, "asset_name", asset_name="Windows Account - AD - Admin",
    925. 

  925.                            asset_description="Windows Account - AD - Admin", asset_icon_not_compromised="user.png",
    926. 

  926.                            asset_icon_compromised="ioc_user.png")
    927. 

  927.     get_by_value_or_create(db.session, AssetsType, "asset_name", asset_name="Windows Account - AD - krbtgt",
    928. 

  928.                            asset_description="Windows Account - AD - krbtgt", asset_icon_not_compromised="user.png",
    929. 

  929.                            asset_icon_compromised="ioc_user.png")
    930. 

  930.     get_by_value_or_create(db.session, AssetsType, "asset_name", asset_name="Windows Account - AD - Service",
    931. 

  931.                            asset_description="Windows Account - AD - krbtgt", asset_icon_not_compromised="user.png",
    932. 

  932.                            asset_icon_compromised="ioc_user.png")
    933. 

  933. 

  934. 

  935. def create_safe_client():
    936. 

  936.     """Creates a new Client object if it does not already exist.
    937. 

  937. 

  938.     This function creates a new Client object with the specified client name
    939. 

  939.     and client description if it does not already exist in the database.
    940. 

  940. 

  941.     """
    942. 

  942.     # Create a new Client object if it does not already exist
    943. 

  943.     client = get_or_create(db.session, Client,
    944. 

  944.                            name="IrisInitialClient")
    945. 

  945. 

  946.     return client
    947. 

  947. 

  948. 

  949. def create_safe_auth_model():
    950. 

  950.     """Creates new Organisation, Group, and User objects if they do not already exist.
    951. 

  951. 

  952.     This function creates a new Organisation object with the specified name and description,
    953. 

  953.     and creates new Group objects with the specified name, description, auto-follow status,
    954. 

  954.     auto-follow access level, and permissions if they do not already exist in the database.
    955. 

  955.     It also updates the attributes of the existing Group objects if they have changed.
    956. 

  956. 

  957.     """
    958. 

  958.     # Create new Organisation object
    959. 

  959.     def_org = get_or_create(db.session, Organisation, org_name="Default Org",
    960. 

  960.                             org_description="Default Organisation")
    961. 

  961. 

  962.     # Create new Administrator Group object
    963. 

  963.     try:
    964. 

  964.         gadm = get_or_create(db.session, Group, group_name='Administrators', group_description='Administrators',
    965. 

  965.                              group_auto_follow=True, group_auto_follow_access_level=CaseAccessLevel.full_access.value,
    966. 

  966.                              group_permissions=ac_get_mask_full_permissions())
    967. 

  967. 

  968.     except exc.IntegrityError:
    969. 

  969.         db.session.rollback()
    970. 

  970.         log.warning('Administrator group integrity error. Group permissions were probably changed. Updating.')
    971. 

  971.         gadm = Group.query.filter(
    972. 

  972.             Group.group_name == 'Administrators'
    973. 

  973.         ).first()
    974. 

  974. 

  975.     # Update Administrator Group object attributes
    976. 

  976.     if gadm.group_permissions != ac_get_mask_full_permissions():
    977. 

  977.         gadm.group_permissions = ac_get_mask_full_permissions()
    978. 

  978. 

  979.     if gadm.group_auto_follow_access_level != CaseAccessLevel.full_access.value:
    980. 

  980.         gadm.group_auto_follow_access_level = CaseAccessLevel.full_access.value
    981. 

  981. 

  982.     if gadm.group_auto_follow is not True:
    983. 

  983.         gadm.group_auto_follow = True
    984. 

  984. 

  985.     db.session.commit()
    986. 

  986. 

  987.     # Create new Analysts Group object
    988. 

  988.     try:
    989. 

  989.         ganalysts = get_or_create(db.session, Group, group_name='Analysts', group_description='Standard Analysts',
    990. 

  990.                                   group_auto_follow=False,
    991. 

  991.                                   group_auto_follow_access_level=CaseAccessLevel.full_access.value,
    992. 

  992.                                   group_permissions=ac_get_mask_analyst())
    993. 

  993. 

  994.     except exc.IntegrityError:
    995. 

  995.         db.session.rollback()
    996. 

  996.         log.warning('Analysts group integrity error. Group permissions were probably changed. Updating.')
    997. 

  997.         ganalysts = get_group_by_name('Analysts')
    998. 

  998. 

  999.     # Update Analysts Group object attributes
    1000. 

  1000.     if ganalysts.group_permissions != ac_get_mask_analyst():
    1001. 

  1001.         ganalysts.group_permissions = ac_get_mask_analyst()
    1002. 

  1002. 

  1003.     if ganalysts.group_auto_follow is not False:
    1004. 

  1004.         ganalysts.group_auto_follow = False
    1005. 

  1005. 

  1006.     if ganalysts.group_auto_follow_access_level != CaseAccessLevel.full_access.value:
    1007. 

  1007.         ganalysts.group_auto_follow_access_level = CaseAccessLevel.full_access.value
    1008. 

  1008. 

  1009.     db.session.commit()
    1010. 

  1010. 

  1011.     return def_org, gadm, ganalysts
    1012. 

  1012. 

  1013. 

  1014. def create_safe_admin(def_org, gadm):
    1015. 

  1015.     """Creates a new admin user if one does not already exist.
    1016. 

  1016. 

  1017.     This function creates a new admin user with the specified username, email, and password
    1018. 

  1018.     if one does not already exist in the database. If an admin user already exists, it updates
    1019. 

  1019.     the email address of the existing user if it has changed.
    1020. 

  1020. 

  1021.     """
    1022. 

  1022.     # Get admin username and email from app config
    1023. 

  1023.     admin_username = app.config.get('IRIS_ADM_USERNAME')
    1024. 

  1024.     if admin_username is None:
    1025. 

  1025.         admin_username = 'administrator'
    1026. 

  1026. 

  1027.     admin_email = app.config.get('IRIS_ADM_EMAIL')
    1028. 

  1028.     if admin_email is None:
    1029. 

  1029.         admin_email = 'administrator@localhost'
    1030. 

  1030. 

  1031.     # Check if admin user already exists
    1032. 

  1032.     user = User.query.filter(or_(
    1033. 

  1033.         User.user == admin_username,
    1034. 

  1034.         User.email == admin_email
    1035. 

  1035.     )).first()
    1036. 

  1036.     password = None
    1037. 

  1037. 

  1038.     if not user:
    1039. 

  1039.         # Generate a new password if one was not provided in the app config
    1040. 

  1040.         password = app.config.get('IRIS_ADM_PASSWORD')
    1041. 

  1041.         if password is None:
    1042. 

  1042.             password = ''.join(random.choices(string.printable[:-6], k=16))
    1043. 

  1043. 

  1044.         log.info(f'Creating first admin user with username "{admin_username}"')
    1045. 

  1045. 

  1046.         # Create new User object for admin user
    1047. 

  1047.         user = User(
    1048. 

  1048.             user=admin_username,
    1049. 

  1049.             name=admin_username,
    1050. 

  1050.             email=admin_email,
    1051. 

  1051.             password=bc.generate_password_hash(password.encode('utf8')).decode('utf8'),
    1052. 

  1052.             active=True
    1053. 

  1053.         )
    1054. 

  1054. 

  1055.         # Generate a new API key if one was not provided in the app config
    1056. 

  1056.         api_key = app.config.get('IRIS_ADM_API_KEY')
    1057. 

  1057.         if api_key is None:
    1058. 

  1058.             api_key = secrets.token_urlsafe(nbytes=64)
    1059. 

  1059. 

  1060.         user.api_key = api_key
    1061. 

  1061.         db.session.add(user)
    1062. 

  1062. 

  1063.         db.session.commit()
    1064. 

  1064. 

  1065.         # Add admin user to admin group and default organisation
    1066. 

  1066.         add_user_to_group(user_id=user.id, group_id=gadm.group_id)
    1067. 

  1067.         add_user_to_organisation(user_id=user.id, org_id=def_org.org_id)
    1068. 

  1068. 

  1069.         log.warning(f">>> Administrator password: {password}")
    1070. 

  1070. 

  1071.         db.session.commit()
    1072. 

  1072. 

  1073.     else:
    1074. 

  1074.         if not os.environ.get('IRIS_ADM_PASSWORD'):
    1075. 

  1075.             # Prevent leak of user set password in logs
    1076. 

  1076.             log.warning(">>> Administrator already exists")
    1077. 

  1077. 

  1078.         if user.email != admin_email:
    1079. 

  1079.             # Update email address of existing admin user if it has changed
    1080. 

  1080.             log.warning(f'Email of administrator will be updated via config to {admin_email}')
    1081. 

  1081.             user.email = admin_email
    1082. 

  1082.             db.session.commit()
    1083. 

  1083. 

  1084.     return user, password
    1085. 

  1085. 

  1086. 

  1087. def create_safe_case(user, client, groups):
    1088. 

  1088.     """Creates a new case if one does not already exist for the specified client.
    1089. 

  1089. 

  1090.     This function creates a new case with the specified name, description, SOC ID, user, and client
    1091. 

  1091.     if one does not already exist in the database for the specified client. It also adds the specified
    1092. 

  1092.     user and groups to the case with full access level.
    1093. 

  1093. 

  1094.     """
    1095. 

  1095.     # Check if a case already exists for the client
    1096. 

  1096.     case = Cases.query.filter(
    1097. 

  1097.         Cases.client_id == client.client_id
    1098. 

  1098.     ).first()
    1099. 

  1099. 

  1100.     if not case:
    1101. 

  1101.         # Create a new case for the client
    1102. 

  1102.         case = Cases(
    1103. 

  1103.             name="Initial Demo",
    1104. 

  1104.             description="This is a demonstration.",
    1105. 

  1105.             soc_id="soc_id_demo",
    1106. 

  1106.             user=user,
    1107. 

  1107.             client_id=client.client_id
    1108. 

  1108.         )
    1109. 

  1109. 

  1110.         # Validate the case and save it to the database
    1111. 

  1111.         case.validate_on_build()
    1112. 

  1112.         case.save()
    1113. 

  1113. 

  1114.         db.session.commit()
    1115. 

  1115. 

  1116.     # Add the specified user and groups to the case with full access level
    1117. 

  1117.     for group in groups:
    1118. 

  1118.         add_case_access_to_group(group=group,
    1119. 

  1119.                                  cases_list=[case.case_id],
    1120. 

  1120.                                  access_level=CaseAccessLevel.full_access.value)
    1121. 

  1121.         ac_add_user_effective_access(users_list=[user.id],
    1122. 

  1122.                                      case_id=1,
    1123. 

  1123.                                      access_level=CaseAccessLevel.full_access.value)
    1124. 

  1124. 

  1125.     return case
    1126. 

  1126. 

  1127. 

  1128. def create_safe_report_types():
    1129. 

  1129.     """Creates new ReportType objects if they do not already exist.
    1130. 

  1130. 

  1131.     This function creates new ReportType objects with the specified names if they do not already
    1132. 

  1132.     exist in the database.
    1133. 

  1133. 

  1134.     """
    1135. 

  1135.     create_safe(db.session, ReportType, name="Investigation")
    1136. 

  1136.     create_safe(db.session, ReportType, name="Activities")
    1137. 

  1137. 

  1138. 

  1139. def create_safe_attributes():
    1140. 

  1140.     """Creates new Attribute objects if they do not already exist.
    1141. 

  1141. 

  1142.     This function creates new Attribute objects with the specified display name, description,
    1143. 

  1143.     object type, and content if they do not already exist in the database.
    1144. 

  1144. 

  1145.     """
    1146. 

  1146.     create_safe_attr(db.session, attribute_display_name='IOC',
    1147. 

  1147.                      attribute_description='Defines default attributes for IOCs', attribute_for='ioc',
    1148. 

  1148.                      attribute_content={})
    1149. 

  1149.     create_safe_attr(db.session, attribute_display_name='Events',
    1150. 

  1150.                      attribute_description='Defines default attributes for Events', attribute_for='event',
    1151. 

  1151.                      attribute_content={})
    1152. 

  1152.     create_safe_attr(db.session, attribute_display_name='Assets',
    1153. 

  1153.                      attribute_description='Defines default attributes for Assets', attribute_for='asset',
    1154. 

  1154.                      attribute_content={})
    1155. 

  1155.     create_safe_attr(db.session, attribute_display_name='Tasks',
    1156. 

  1156.                      attribute_description='Defines default attributes for Tasks', attribute_for='task',
    1157. 

  1157.                      attribute_content={})
    1158. 

  1158.     create_safe_attr(db.session, attribute_display_name='Notes',
    1159. 

  1159.                      attribute_description='Defines default attributes for Notes', attribute_for='note',
    1160. 

  1160.                      attribute_content={})
    1161. 

  1161.     create_safe_attr(db.session, attribute_display_name='Evidences',
    1162. 

  1162.                      attribute_description='Defines default attributes for Evidences', attribute_for='evidence',
    1163. 

  1163.                      attribute_content={})
    1164. 

  1164.     create_safe_attr(db.session, attribute_display_name='Cases',
    1165. 

  1165.                      attribute_description='Defines default attributes for Cases', attribute_for='case',
    1166. 

  1166.                      attribute_content={})
    1167. 

  1167.     create_safe_attr(db.session, attribute_display_name='Customers',
    1168. 

  1168.                      attribute_description='Defines default attributes for Customers', attribute_for='client',
    1169. 

  1169.                      attribute_content={})
    1170. 

  1170. 

  1171. 

  1172. def create_safe_ioctypes():
    1173. 

  1173.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="AS",
    1174. 

  1174.                         type_description="Autonomous system", type_taxonomy="")
    1175. 

  1175.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="aba-rtn",
    1176. 

  1176.                         type_description="ABA routing transit number",
    1177. 

  1177.                         type_taxonomy="")
    1178. 

  1178.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="account",
    1179. 

  1179.                         type_description="Account of any type",
    1180. 

  1180.                         type_taxonomy="")
    1181. 

  1181.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="anonymised",
    1182. 

  1182.                         type_description="Anonymised value - described with the anonymisation object via a relationship",
    1183. 

  1183.                         type_taxonomy="")
    1184. 

  1184.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="attachment",
    1185. 

  1185.                         type_description="Attachment with external information",
    1186. 

  1186.                         type_taxonomy="")
    1187. 

  1187.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="authentihash",
    1188. 

  1188.                         type_description="Authenticode executable signature hash", type_taxonomy="",
    1189. 

  1189.                         type_validation_regex=r"[a-f0-9]{64}", type_validation_expect="64 hexadecimal characters"
    1190. 

  1190.                         )
    1191. 

  1191.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="boolean",
    1192. 

  1192.                         type_description="Boolean value - to be used in objects",
    1193. 

  1193.                         type_taxonomy="")
    1194. 

  1194.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="btc",
    1195. 

  1195.                         type_description="Bitcoin Address", type_taxonomy="")
    1196. 

  1196.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="campaign-id",
    1197. 

  1197.                         type_description="Associated campaign ID",
    1198. 

  1198.                         type_taxonomy="")
    1199. 

  1199.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="campaign-name",
    1200. 

  1200.                         type_description="Associated campaign name",
    1201. 

  1201.                         type_taxonomy="")
    1202. 

  1202.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="cdhash",
    1203. 

  1203.                         type_description="An Apple Code Directory Hash, identifying a code-signed Mach-O executable file",
    1204. 

  1204.                         type_taxonomy="")
    1205. 

  1205.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="chrome-extension-id",
    1206. 

  1206.                         type_description="Chrome extension id",
    1207. 

  1207.                         type_taxonomy="")
    1208. 

  1208.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="community-id",
    1209. 

  1209.                         type_description="a community ID flow hashing algorithm to map multiple traffic monitors into common flow id",
    1210. 

  1210.                         type_taxonomy="")
    1211. 

  1211.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="cookie",
    1212. 

  1212.                         type_description="HTTP cookie as often stored on the user web client. This can include authentication cookie or session cookie.",
    1213. 

  1213.                         type_taxonomy="")
    1214. 

  1214.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="dash",
    1215. 

  1215.                         type_description="Dash Address", type_taxonomy="")
    1216. 

  1216.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="datetime",
    1217. 

  1217.                         type_description="Datetime in the ISO 8601 format",
    1218. 

  1218.                         type_taxonomy="")
    1219. 

  1219.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="dkim",
    1220. 

  1220.                         type_description="DKIM public key", type_taxonomy="")
    1221. 

  1221.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="dkim-signature",
    1222. 

  1222.                         type_description="DKIM signature", type_taxonomy="")
    1223. 

  1223.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="dns-soa-email",
    1224. 

  1224.                         type_description="RFC1035 mandates that DNS zones should have a SOA (Statement Of Authority) record that contains an email address where a PoC for the domain could be contacted. This can sometimes be used for attribution/linkage between different domains even if protected by whois privacy",
    1225. 

  1225.                         type_taxonomy="")
    1226. 

  1226.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="domain",
    1227. 

  1227.                         type_description="A domain name used in the malware",
    1228. 

  1228.                         type_taxonomy="")
    1229. 

  1229.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="domain|ip",
    1230. 

  1230.                         type_description="A domain name and its IP address (as found in DNS lookup) separated by a |",
    1231. 

  1231.                         type_taxonomy="")
    1232. 

  1232.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="email",
    1233. 

  1233.                         type_description="An e-mail address", type_taxonomy="")
    1234. 

  1234.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="email-attachment",
    1235. 

  1235.                         type_description="File name of the email attachment.", type_taxonomy="")
    1236. 

  1236.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="email-body",
    1237. 

  1237.                         type_description="Email body", type_taxonomy="")
    1238. 

  1238.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="email-dst",
    1239. 

  1239.                         type_description="The destination email address. Used to describe the recipient when describing an e-mail.",
    1240. 

  1240.                         type_taxonomy="")
    1241. 

  1241.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="email-dst-display-name",
    1242. 

  1242.                         type_description="Email destination display name", type_taxonomy="")
    1243. 

  1243.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="email-header",
    1244. 

  1244.                         type_description="Email header", type_taxonomy="")
    1245. 

  1245.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="email-message-id",
    1246. 

  1246.                         type_description="The email message ID",
    1247. 

  1247.                         type_taxonomy="")
    1248. 

  1248.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="email-mime-boundary",
    1249. 

  1249.                         type_description="The email mime boundary separating parts in a multipart email",
    1250. 

  1250.                         type_taxonomy="")
    1251. 

  1251.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="email-reply-to",
    1252. 

  1252.                         type_description="Email reply to header",
    1253. 

  1253.                         type_taxonomy="")
    1254. 

  1254.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="email-src",
    1255. 

  1255.                         type_description="The source email address. Used to describe the sender when describing an e-mail.",
    1256. 

  1256.                         type_taxonomy="")
    1257. 

  1257.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="email-src-display-name",
    1258. 

  1258.                         type_description="Email source display name",
    1259. 

  1259.                         type_taxonomy="")
    1260. 

  1260.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="email-subject",
    1261. 

  1261.                         type_description="The subject of the email",
    1262. 

  1262.                         type_taxonomy="")
    1263. 

  1263.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="email-thread-index",
    1264. 

  1264.                         type_description="The email thread index header",
    1265. 

  1265.                         type_taxonomy="")
    1266. 

  1266.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="email-x-mailer",
    1267. 

  1267.                         type_description="Email x-mailer header",
    1268. 

  1268.                         type_taxonomy="")
    1269. 

  1269.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="favicon-mmh3",
    1270. 

  1270.                         type_description="favicon-mmh3 is the murmur3 hash of a favicon as used in Shodan.",
    1271. 

  1271.                         type_taxonomy="")
    1272. 

  1272.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="filename",
    1273. 

  1273.                         type_description="Filename", type_taxonomy="")
    1274. 

  1274.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="filename-pattern",
    1275. 

  1275.                         type_description="A pattern in the name of a file",
    1276. 

  1276.                         type_taxonomy="")
    1277. 

  1277.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="filename|authentihash",
    1278. 

  1278.                         type_description="A checksum in md5 format",
    1279. 

  1279.                         type_taxonomy="",
    1280. 

  1280.                         type_validation_regex=r'.+\|[a-f0-9]{64}',
    1281. 

  1281.                         type_validation_expect="filename|64 hexadecimal characters")
    1282. 

  1282.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="filename|impfuzzy",
    1283. 

  1283.                         type_description="Import fuzzy hash - a fuzzy hash created based on the imports in the sample.",
    1284. 

  1284.                         type_taxonomy="", )
    1285. 

  1285.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="filename|imphash",
    1286. 

  1286.                         type_description="Import hash - a hash created based on the imports in the sample.",
    1287. 

  1287.                         type_taxonomy="",
    1288. 

  1288.                         type_validation_regex=r'.+\|[a-f0-9]{32}',
    1289. 

  1289.                         type_validation_expect="filename|32 hexadecimal characters")
    1290. 

  1290.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="filename|md5",
    1291. 

  1291.                         type_description="A filename and an md5 hash separated by a |", type_taxonomy="",
    1292. 

  1292.                         type_validation_regex=r'.+\|[a-f0-9]{32}',
    1293. 

  1293.                         type_validation_expect="filename|32 hexadecimal characters")
    1294. 

  1294.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="filename|pehash",
    1295. 

  1295.                         type_description="A filename and a PEhash separated by a |", type_taxonomy="",
    1296. 

  1296.                         type_validation_regex=r'.+\|[a-f0-9]{40}',
    1297. 

  1297.                         type_validation_expect="filename|40 hexadecimal characters")
    1298. 

  1298.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="filename|sha1",
    1299. 

  1299.                         type_description="A filename and an sha1 hash separated by a |", type_taxonomy="",
    1300. 

  1300.                         type_validation_regex=r'.+\|[a-f0-9]{40}',
    1301. 

  1301.                         type_validation_expect="filename|40 hexadecimal characters")
    1302. 

  1302.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="filename|sha224",
    1303. 

  1303.                         type_description="A filename and a sha-224 hash separated by a |", type_taxonomy="",
    1304. 

  1304.                         type_validation_regex=r'.+\|[a-f0-9]{56}',
    1305. 

  1305.                         type_validation_expect="filename|56 hexadecimal characters")
    1306. 

  1306.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="filename|sha256",
    1307. 

  1307.                         type_description="A filename and an sha256 hash separated by a |", type_taxonomy="",
    1308. 

  1308.                         type_validation_regex=r'.+\|[a-f0-9]{64}',
    1309. 

  1309.                         type_validation_expect="filename|64 hexadecimal characters")
    1310. 

  1310.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="filename|sha3-224",
    1311. 

  1311.                         type_description="A filename and an sha3-224 hash separated by a |", type_taxonomy="",
    1312. 

  1312.                         type_validation_regex=r'.+\|[a-f0-9]{56}',
    1313. 

  1313.                         type_validation_expect="filename|56 hexadecimal characters")
    1314. 

  1314.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="filename|sha3-256",
    1315. 

  1315.                         type_description="A filename and an sha3-256 hash separated by a |", type_taxonomy="",
    1316. 

  1316.                         type_validation_regex=r'.+\|[a-f0-9]{64}',
    1317. 

  1317.                         type_validation_expect="filename|64 hexadecimal characters")
    1318. 

  1318.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="filename|sha3-384",
    1319. 

  1319.                         type_description="A filename and an sha3-384 hash separated by a |", type_taxonomy="",
    1320. 

  1320.                         type_validation_regex=r'.+\|[a-f0-9]{96}',
    1321. 

  1321.                         type_validation_expect="filename|96 hexadecimal characters")
    1322. 

  1322.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="filename|sha3-512",
    1323. 

  1323.                         type_description="A filename and an sha3-512 hash separated by a |", type_taxonomy="",
    1324. 

  1324.                         type_validation_regex=r'.+\|[a-f0-9]{128}',
    1325. 

  1325.                         type_validation_expect="filename|128 hexadecimal characters")
    1326. 

  1326.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="filename|sha384",
    1327. 

  1327.                         type_description="A filename and a sha-384 hash separated by a |", type_taxonomy="",
    1328. 

  1328.                         type_validation_regex=r'.+\|[a-f0-9]{96}',
    1329. 

  1329.                         type_validation_expect="filename|96 hexadecimal characters")
    1330. 

  1330.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="filename|sha512",
    1331. 

  1331.                         type_description="A filename and a sha-512 hash separated by a |", type_taxonomy="",
    1332. 

  1332.                         type_validation_regex=r'.+\|[a-f0-9]{128}',
    1333. 

  1333.                         type_validation_expect="filename|128 hexadecimal characters")
    1334. 

  1334.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="filename|sha512/224",
    1335. 

  1335.                         type_description="A filename and a sha-512/224 hash separated by a |", type_taxonomy="",
    1336. 

  1336.                         type_validation_regex=r'.+\|[a-f0-9]{56}',
    1337. 

  1337.                         type_validation_expect="filename|56 hexadecimal characters")
    1338. 

  1338.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="filename|sha512/256",
    1339. 

  1339.                         type_description="A filename and a sha-512/256 hash separated by a |", type_taxonomy="",
    1340. 

  1340.                         type_validation_regex=r'.+\|[a-f0-9]{64}',
    1341. 

  1341.                         type_validation_expect="filename|64 hexadecimal characters")
    1342. 

  1342.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="filename|ssdeep",
    1343. 

  1343.                         type_description="A checksum in ssdeep format",
    1344. 

  1344.                         type_taxonomy="")
    1345. 

  1345.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="filename|tlsh",
    1346. 

  1346.                         type_description="A filename and a Trend Micro Locality Sensitive Hash separated by a |",
    1347. 

  1347.                         type_taxonomy="",
    1348. 

  1348.                         type_validation_regex=r'.+\|t?[a-f0-9]{35,}',
    1349. 

  1349.                         type_validation_expect="filename|at least 35 hexadecimal characters, optionally starting with t1 instead of hexadecimal characters"
    1350. 

  1350.                         )
    1351. 

  1351.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="filename|vhash",
    1352. 

  1352.                         type_description="A filename and a VirusTotal hash separated by a |", type_taxonomy="")
    1353. 

  1353.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="first-name",
    1354. 

  1354.                         type_description="First name of a natural person",
    1355. 

  1355.                         type_taxonomy="")
    1356. 

  1356.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="float",
    1357. 

  1357.                         type_description="A floating point value.", type_taxonomy="")
    1358. 

  1358.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="full-name",
    1359. 

  1359.                         type_description="Full name of a natural person",
    1360. 

  1360.                         type_taxonomy="")
    1361. 

  1361.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="gene",
    1362. 

  1362.                         type_description="GENE - Go Evtx sigNature Engine",
    1363. 

  1363.                         type_taxonomy="")
    1364. 

  1364.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="git-commit-id",
    1365. 

  1365.                         type_description="A git commit ID.", type_taxonomy="",
    1366. 

  1366.                         type_validation_regex=r"[a-f0-9]{40}", type_validation_expect="40 hexadecimal characters")
    1367. 

  1367.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="github-organisation",
    1368. 

  1368.                         type_description="A github organisation",
    1369. 

  1369.                         type_taxonomy="")
    1370. 

  1370.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="github-repository",
    1371. 

  1371.                         type_description="A github repository",
    1372. 

  1372.                         type_taxonomy="")
    1373. 

  1373.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="github-username",
    1374. 

  1374.                         type_description="A github user name",
    1375. 

  1375.                         type_taxonomy="")
    1376. 

  1376.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="hassh-md5",
    1377. 

  1377.                         type_description="hassh is a network fingerprinting standard which can be used to identify specific Client SSH implementations. The fingerprints can be easily stored, searched and shared in the form of an MD5 fingerprint.",
    1378. 

  1378.                         type_taxonomy="",
    1379. 

  1379.                         type_validation_regex=r"[a-f0-9]{32}", type_validation_expect="32 hexadecimal characters")
    1380. 

  1380.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="hasshserver-md5",
    1381. 

  1381.                         type_description="hasshServer is a network fingerprinting standard which can be used to identify specific Server SSH implementations. The fingerprints can be easily stored, searched and shared in the form of an MD5 fingerprint.",
    1382. 

  1382.                         type_taxonomy="",
    1383. 

  1383.                         type_validation_regex=r"[a-f0-9]{32}", type_validation_expect="32 hexadecimal characters")
    1384. 

  1384.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="hex",
    1385. 

  1385.                         type_description="A value in hexadecimal format",
    1386. 

  1386.                         type_taxonomy="")
    1387. 

  1387.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="hostname",
    1388. 

  1388.                         type_description="A full host/dnsname of an attacker",
    1389. 

  1389.                         type_taxonomy="")
    1390. 

  1390.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="hostname|port",
    1391. 

  1391.                         type_description="Hostname and port number separated by a |", type_taxonomy="")
    1392. 

  1392.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="http-method",
    1393. 

  1393.                         type_description="HTTP method used by the malware (e.g. POST, GET, …).", type_taxonomy="")
    1394. 

  1394.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="iban",
    1395. 

  1395.                         type_description="International Bank Account Number",
    1396. 

  1396.                         type_taxonomy="")
    1397. 

  1397.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="identity-card-number",
    1398. 

  1398.                         type_description="Identity card number",
    1399. 

  1399.                         type_taxonomy="")
    1400. 

  1400.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="impfuzzy",
    1401. 

  1401.                         type_description="A fuzzy hash of import table of Portable Executable format", type_taxonomy="")
    1402. 

  1402.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="imphash",
    1403. 

  1403.                         type_description="Import hash - a hash created based on the imports in the sample.",
    1404. 

  1404.                         type_taxonomy="",
    1405. 

  1405.                         type_validation_regex=r"[a-f0-9]{32}", type_validation_expect="32 hexadecimal characters")
    1406. 

  1406.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="ip-any",
    1407. 

  1407.                         type_description="A source or destination IP address of the attacker or C&C server",
    1408. 

  1408.                         type_taxonomy="")
    1409. 

  1409.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="ip-dst",
    1410. 

  1410.                         type_description="A destination IP address of the attacker or C&C server", type_taxonomy="")
    1411. 

  1411.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="ip-dst|port",
    1412. 

  1412.                         type_description="IP destination and port number separated by a |", type_taxonomy="")
    1413. 

  1413.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="ip-src",
    1414. 

  1414.                         type_description="A source IP address of the attacker",
    1415. 

  1415.                         type_taxonomy="")
    1416. 

  1416.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="ip-src|port",
    1417. 

  1417.                         type_description="IP source and port number separated by a |", type_taxonomy="")
    1418. 

  1418.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="ja3-fingerprint-md5",
    1419. 

  1419.                         type_description="JA3 is a method for creating SSL/TLS client fingerprints that should be easy to produce on any platform and can be easily shared for threat intelligence.",
    1420. 

  1420.                         type_taxonomy="",
    1421. 

  1421.                         type_validation_regex=r"[a-f0-9]{32}", type_validation_expect="32 hexadecimal characters")
    1422. 

  1422.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="jabber-id",
    1423. 

  1423.                         type_description="Jabber ID", type_taxonomy="")
    1424. 

  1424.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="jarm-fingerprint",
    1425. 

  1425.                         type_description="JARM is a method for creating SSL/TLS server fingerprints.", type_taxonomy="",
    1426. 

  1426.                         type_validation_regex=r"[a-f0-9]{62}", type_validation_expect="62 hexadecimal characters")
    1427. 

  1427.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="kusto-query",
    1428. 

  1428.                         type_description="Kusto query - Kusto from Microsoft Azure is a service for storing and running interactive analytics over Big Data.",
    1429. 

  1429.                         type_taxonomy="")
    1430. 

  1430.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="link",
    1431. 

  1431.                         type_description="Link to an external information",
    1432. 

  1432.                         type_taxonomy="")
    1433. 

  1433.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="mac-address",
    1434. 

  1434.                         type_description="Mac address", type_taxonomy="")
    1435. 

  1435.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="mac-eui-64",
    1436. 

  1436.                         type_description="Mac EUI-64 address", type_taxonomy="")
    1437. 

  1437.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="malware-sample",
    1438. 

  1438.                         type_description="Attachment containing encrypted malware sample", type_taxonomy="")
    1439. 

  1439.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="malware-type",
    1440. 

  1440.                         type_description="Malware type", type_taxonomy="")
    1441. 

  1441.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="md5",
    1442. 

  1442.                         type_description="A checksum in md5 format", type_taxonomy="",
    1443. 

  1443.                         type_validation_regex=r"[a-f0-9]{32}", type_validation_expect="32 hexadecimal characters")
    1444. 

  1444.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="middle-name",
    1445. 

  1445.                         type_description="Middle name of a natural person",
    1446. 

  1446.                         type_taxonomy="")
    1447. 

  1447.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="mime-type",
    1448. 

  1448.                         type_description="A media type (also MIME type and content type) is a two-part identifier for file formats and format contents transmitted on the Internet",
    1449. 

  1449.                         type_taxonomy="")
    1450. 

  1450.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="mobile-application-id",
    1451. 

  1451.                         type_description="The application id of a mobile application", type_taxonomy="")
    1452. 

  1452.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="mutex",
    1453. 

  1453.                         type_description="Mutex, use the format \\BaseNamedObjects<Mutex>", type_taxonomy="")
    1454. 

  1454.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="named pipe",
    1455. 

  1455.                         type_description="Named pipe, use the format .\\pipe<PipeName>", type_taxonomy="")
    1456. 

  1456.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="other",
    1457. 

  1457.                         type_description="Other attribute", type_taxonomy="")
    1458. 

  1458.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="file-path",
    1459. 

  1459.                         type_description="Path of file", type_taxonomy="")
    1460. 

  1460.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="pattern-in-file",
    1461. 

  1461.                         type_description="Pattern in file that identifies the malware", type_taxonomy="")
    1462. 

  1462.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="pattern-in-memory",
    1463. 

  1463.                         type_description="Pattern in memory dump that identifies the malware", type_taxonomy="")
    1464. 

  1464.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="pattern-in-traffic",
    1465. 

  1465.                         type_description="Pattern in network traffic that identifies the malware", type_taxonomy="")
    1466. 

  1466.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="pdb",
    1467. 

  1467.                         type_description="Microsoft Program database (PDB) path information", type_taxonomy="")
    1468. 

  1468.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="pehash",
    1469. 

  1469.                         type_description="PEhash - a hash calculated based of certain pieces of a PE executable file",
    1470. 

  1470.                         type_taxonomy="",
    1471. 

  1471.                         type_validation_regex=r"[a-f0-9]{40}", type_validation_expect="40 hexadecimal characters")
    1472. 

  1472.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="pgp-private-key",
    1473. 

  1473.                         type_description="A PGP private key",
    1474. 

  1474.                         type_taxonomy="")
    1475. 

  1475.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="pgp-public-key",
    1476. 

  1476.                         type_description="A PGP public key", type_taxonomy="")
    1477. 

  1477.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="phone-number",
    1478. 

  1478.                         type_description="Telephone Number", type_taxonomy="")
    1479. 

  1479.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="port",
    1480. 

  1480.                         type_description="Port number", type_taxonomy="")
    1481. 

  1481.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="process-state",
    1482. 

  1482.                         type_description="State of a process", type_taxonomy="")
    1483. 

  1483.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="prtn",
    1484. 

  1484.                         type_description="Premium-Rate Telephone Number",
    1485. 

  1485.                         type_taxonomy="")
    1486. 

  1486.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="regkey",
    1487. 

  1487.                         type_description="Registry key or value", type_taxonomy="")
    1488. 

  1488.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="regkey|value",
    1489. 

  1489.                         type_description="Registry value + data separated by |",
    1490. 

  1490.                         type_taxonomy="")
    1491. 

  1491.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="sha1",
    1492. 

  1492.                         type_description="A checksum in sha1 format", type_taxonomy="",
    1493. 

  1493.                         type_validation_regex=r"[a-f0-9]{40}", type_validation_expect="40 hexadecimal characters")
    1494. 

  1494.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="sha224",
    1495. 

  1495.                         type_description="A checksum in sha-224 format",
    1496. 

  1496.                         type_taxonomy="",
    1497. 

  1497.                         type_validation_regex=r"[a-f0-9]{56}", type_validation_expect="56 hexadecimal characters")
    1498. 

  1498.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="sha256",
    1499. 

  1499.                         type_description="A checksum in sha256 format",
    1500. 

  1500.                         type_taxonomy="",
    1501. 

  1501.                         type_validation_regex=r"[a-f0-9]{64}", type_validation_expect="64 hexadecimal characters")
    1502. 

  1502.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="sha3-224",
    1503. 

  1503.                         type_description="A checksum in sha3-224 format",
    1504. 

  1504.                         type_taxonomy="",
    1505. 

  1505.                         type_validation_regex=r"[a-f0-9]{56}", type_validation_expect="56 hexadecimal characters")
    1506. 

  1506.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="sha3-256",
    1507. 

  1507.                         type_description="A checksum in sha3-256 format",
    1508. 

  1508.                         type_taxonomy="",
    1509. 

  1509.                         type_validation_regex=r"[a-f0-9]{64}", type_validation_expect="64 hexadecimal characters")
    1510. 

  1510.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="sha3-384",
    1511. 

  1511.                         type_description="A checksum in sha3-384 format",
    1512. 

  1512.                         type_taxonomy="",
    1513. 

  1513.                         type_validation_regex=r"[a-f0-9]{96}", type_validation_expect="96 hexadecimal characters")
    1514. 

  1514.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="sha3-512",
    1515. 

  1515.                         type_description="A checksum in sha3-512 format",
    1516. 

  1516.                         type_taxonomy="",
    1517. 

  1517.                         type_validation_regex=r"[a-f0-9]{128}", type_validation_expect="128 hexadecimal characters")
    1518. 

  1518.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="sha384",
    1519. 

  1519.                         type_description="A checksum in sha-384 format",
    1520. 

  1520.                         type_taxonomy="",
    1521. 

  1521.                         type_validation_regex=r"[a-f0-9]{96}", type_validation_expect="96 hexadecimal characters")
    1522. 

  1522.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="sha512",
    1523. 

  1523.                         type_description="A checksum in sha-512 format",
    1524. 

  1524.                         type_taxonomy="",
    1525. 

  1525.                         type_validation_regex=r"[a-f0-9]{128}", type_validation_expect="128 hexadecimal characters")
    1526. 

  1526.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="sha512/224",
    1527. 

  1527.                         type_description="A checksum in the sha-512/224 format",
    1528. 

  1528.                         type_taxonomy="",
    1529. 

  1529.                         type_validation_regex=r"[a-f0-9]{56}", type_validation_expect="56 hexadecimal characters")
    1530. 

  1530.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="sha512/256",
    1531. 

  1531.                         type_description="A checksum in the sha-512/256 format",
    1532. 

  1532.                         type_taxonomy="",
    1533. 

  1533.                         type_validation_regex=r"[a-f0-9]{64}", type_validation_expect="64 hexadecimal characters")
    1534. 

  1534.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="sigma",
    1535. 

  1535.                         type_description="Sigma - Generic Signature Format for SIEM Systems", type_taxonomy="")
    1536. 

  1536.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="size-in-bytes",
    1537. 

  1537.                         type_description="Size expressed in bytes",
    1538. 

  1538.                         type_taxonomy="")
    1539. 

  1539.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="snort",
    1540. 

  1540.                         type_description="An IDS rule in Snort rule-format",
    1541. 

  1541.                         type_taxonomy="")
    1542. 

  1542.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="ssdeep",
    1543. 

  1543.                         type_description="A checksum in ssdeep format",
    1544. 

  1544.                         type_taxonomy="")
    1545. 

  1545.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="ssh-fingerprint",
    1546. 

  1546.                         type_description="A fingerprint of SSH key material",
    1547. 

  1547.                         type_taxonomy="")
    1548. 

  1548.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="stix2-pattern",
    1549. 

  1549.                         type_description="STIX 2 pattern", type_taxonomy="")
    1550. 

  1550.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="target-email",
    1551. 

  1551.                         type_description="Attack Targets Email(s)",
    1552. 

  1552.                         type_taxonomy="")
    1553. 

  1553.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="target-external",
    1554. 

  1554.                         type_description="External Target Organizations Affected by this Attack", type_taxonomy="")
    1555. 

  1555.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="target-location",
    1556. 

  1556.                         type_description="Attack Targets Physical Location(s)", type_taxonomy="")
    1557. 

  1557.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="target-machine",
    1558. 

  1558.                         type_description="Attack Targets Machine Name(s)",
    1559. 

  1559.                         type_taxonomy="")
    1560. 

  1560.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="target-org",
    1561. 

  1561.                         type_description="Attack Targets Department or Organization(s)", type_taxonomy="")
    1562. 

  1562.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="target-user",
    1563. 

  1563.                         type_description="Attack Targets Username(s)",
    1564. 

  1564.                         type_taxonomy="")
    1565. 

  1565.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="telfhash",
    1566. 

  1566.                         type_description="telfhash is symbol hash for ELF files, just like imphash is imports hash for PE files.",
    1567. 

  1567.                         type_taxonomy="",
    1568. 

  1568.                         type_validation_regex=r"[a-f0-9]{70}", type_validation_expect="70 hexadecimal characters")
    1569. 

  1569.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="text",
    1570. 

  1570.                         type_description="Name, ID or a reference", type_taxonomy="")
    1571. 

  1571.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="threat-actor",
    1572. 

  1572.                         type_description="A string identifying the threat actor",
    1573. 

  1573.                         type_taxonomy="")
    1574. 

  1574.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="tlsh",
    1575. 

  1575.                         type_description="A checksum in the Trend Micro Locality Sensitive Hash format",
    1576. 

  1576.                         type_taxonomy="",
    1577. 

  1577.                         type_validation_regex=r"^t?[a-f0-9]{35,}",
    1578. 

  1578.                         type_validation_expect="at least 35 hexadecimal characters, optionally starting with t1 instead of hexadecimal characters")
    1579. 

  1579.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="travel-details",
    1580. 

  1580.                         type_description="Travel details", type_taxonomy="")
    1581. 

  1581.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="twitter-id",
    1582. 

  1582.                         type_description="Twitter ID", type_taxonomy="")
    1583. 

  1583.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="uri",
    1584. 

  1584.                         type_description="Uniform Resource Identifier", type_taxonomy="")
    1585. 

  1585.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="url", type_description="url",
    1586. 

  1586.                         type_taxonomy="")
    1587. 

  1587.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="user-agent",
    1588. 

  1588.                         type_description="The user-agent used by the malware in the HTTP request.", type_taxonomy="")
    1589. 

  1589.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="vhash",
    1590. 

  1590.                         type_description="A VirusTotal checksum", type_taxonomy="")
    1591. 

  1591.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="vulnerability",
    1592. 

  1592.                         type_description="A reference to the vulnerability used in the exploit", type_taxonomy="")
    1593. 

  1593.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="weakness",
    1594. 

  1594.                         type_description="A reference to the weakness used in the exploit", type_taxonomy="")
    1595. 

  1595.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="whois-creation-date",
    1596. 

  1596.                         type_description="The date of domain’s creation, obtained from the WHOIS information.",
    1597. 

  1597.                         type_taxonomy="")
    1598. 

  1598.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="whois-registrant-email",
    1599. 

  1599.                         type_description="The e-mail of a domain’s registrant, obtained from the WHOIS information.",
    1600. 

  1600.                         type_taxonomy="")
    1601. 

  1601.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="whois-registrant-name",
    1602. 

  1602.                         type_description="The name of a domain’s registrant, obtained from the WHOIS information.",
    1603. 

  1603.                         type_taxonomy="")
    1604. 

  1604.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="whois-registrant-org",
    1605. 

  1605.                         type_description="The org of a domain’s registrant, obtained from the WHOIS information.",
    1606. 

  1606.                         type_taxonomy="")
    1607. 

  1607.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="whois-registrant-phone",
    1608. 

  1608.                         type_description="The phone number of a domain’s registrant, obtained from the WHOIS information.",
    1609. 

  1609.                         type_taxonomy="")
    1610. 

  1610.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="whois-registrar",
    1611. 

  1611.                         type_description="The registrar of the domain, obtained from the WHOIS information.",
    1612. 

  1612.                         type_taxonomy="")
    1613. 

  1613.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="windows-scheduled-task",
    1614. 

  1614.                         type_description="A scheduled task in windows",
    1615. 

  1615.                         type_taxonomy="")
    1616. 

  1616.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="windows-service-displayname",
    1617. 

  1617.                         type_description="A windows service’s displayname, not to be confused with the windows-service-name. This is the name that applications will generally display as the service’s name in applications.",
    1618. 

  1618.                         type_taxonomy="")
    1619. 

  1619.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="windows-service-name",
    1620. 

  1620.                         type_description="A windows service name. This is the name used internally by windows. Not to be confused with the windows-service-displayname.",
    1621. 

  1621.                         type_taxonomy="")
    1622. 

  1622.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="x509-fingerprint-md5",
    1623. 

  1623.                         type_description="X509 fingerprint in MD5 format", type_taxonomy="",
    1624. 

  1624.                         type_validation_regex=r"[a-f0-9]{32}", type_validation_expect="32 hexadecimal characters")
    1625. 

  1625.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="x509-fingerprint-sha1",
    1626. 

  1626.                         type_description="X509 fingerprint in SHA-1 format", type_taxonomy="",
    1627. 

  1627.                         type_validation_regex=r"[a-f0-9]{40}", type_validation_expect="40 hexadecimal characters")
    1628. 

  1628.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="x509-fingerprint-sha256",
    1629. 

  1629.                         type_description="X509 fingerprint in SHA-256 format", type_taxonomy="",
    1630. 

  1630.                         type_validation_regex=r"[a-f0-9]{64}", type_validation_expect="64 hexadecimal characters")
    1631. 

  1631.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="xmr",
    1632. 

  1632.                         type_description="Monero Address", type_taxonomy="")
    1633. 

  1633.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="yara",
    1634. 

  1634.                         type_description="Yara signature", type_taxonomy="")
    1635. 

  1635.     create_safe_limited(db.session, IocType, ["type_name", "type_description"], type_name="zeek",
    1636. 

  1636.                         type_description="An NIDS rule in the Zeek rule-format",
    1637. 

  1637.                         type_taxonomy="")
    1638. 

  1638. 

  1639. 

  1640. def create_safe_os_types():
    1641. 

  1641.     create_safe(db.session, OsType, type_name="Windows")
    1642. 

  1642.     create_safe(db.session, OsType, type_name="Linux")
    1643. 

  1643.     create_safe(db.session, OsType, type_name="AIX")
    1644. 

  1644.     create_safe(db.session, OsType, type_name="MacOS")
    1645. 

  1645.     create_safe(db.session, OsType, type_name="Apple iOS")
    1646. 

  1646.     create_safe(db.session, OsType, type_name="Cisco iOS")
    1647. 

  1647.     create_safe(db.session, OsType, type_name="Android")
    1648. 

  1648. 

  1649. 

  1650. def create_safe_tlp():
    1651. 

  1651.     create_safe(db.session, Tlp, tlp_name="red", tlp_bscolor="danger")
    1652. 

  1652.     create_safe(db.session, Tlp, tlp_name="amber", tlp_bscolor="warning")
    1653. 

  1653.     create_safe(db.session, Tlp, tlp_name="green", tlp_bscolor="success")
    1654. 

  1654.     create_safe(db.session, Tlp, tlp_name="clear", tlp_bscolor="black")
    1655. 

  1655.     create_safe(db.session, Tlp, tlp_name="amber+strict", tlp_bscolor="warning")
    1656. 

  1656. 

  1657. 

  1658. def create_safe_server_settings():
    1659. 

  1659.     if not ServerSettings.query.count():
    1660. 

  1660.         create_safe(db.session, ServerSettings,
    1661. 

  1661.                     http_proxy="", https_proxy="", prevent_post_mod_repush=False,
    1662. 

  1662.                     prevent_post_objects_repush=False,
    1663. 

  1663.                     password_policy_min_length="12", password_policy_upper_case=True,
    1664. 

  1664.                     password_policy_lower_case=True, password_policy_digit=True,
    1665. 

  1665.                     password_policy_special_chars="", enforce_mfa=app.config.get("MFA_ENABLED", False))
    1666. 

  1666. 

  1667. 

  1668. def register_modules_pipelines():
    1669. 

  1669.     modules = IrisModule.query.with_entities(
    1670. 

  1670.         IrisModule.module_name,
    1671. 

  1671.         IrisModule.module_config
    1672. 

  1672.     ).filter(
    1673. 

  1673.         IrisModule.has_pipeline == True
    1674. 

  1674.     ).all()
    1675. 

  1675. 

  1676.     for module in modules:
    1677. 

  1677.         module = module[0]
    1678. 

  1678.         inst, _ = instantiate_module_from_name(module)
    1679. 

  1679.         if not inst:
    1680. 

  1680.             continue
    1681. 

  1681. 

  1682.         inst.internal_configure(celery_decorator=celery.task,
    1683. 

  1683.                                 evidence_storage=None,
    1684. 

  1684.                                 mod_web_config=module[1])
    1685. 

  1685.         status = inst.get_tasks_for_registration()
    1686. 

  1686.         if status.is_failure():
    1687. 

  1687.             log.warning("Failed getting tasks for module {}".format(module))
    1688. 

  1688.             continue
    1689. 

  1689. 

  1690.         tasks = status.get_data()
    1691. 

  1691.         for task in tasks:
    1692. 

  1692.             celery.register_task(task)
    1693. 

  1693. 

  1694. 

  1695. def register_default_modules():
    1696. 

  1696.     modules = ['iris_vt_module', 'iris_misp_module', 'iris_check_module',
    1697. 

  1697.                'iris_webhooks_module', 'iris_intelowl_module']
    1698. 

  1698. 

  1699.     for module_name in modules:
    1700. 

  1700.         class_, _ = instantiate_module_from_name(module_name)
    1701. 

  1701.         is_ready, logs = check_module_health(class_)
    1702. 

  1702. 

  1703.         if not is_ready:
    1704. 

  1704.             log.info("Attempted to initiate {mod}. Got {err}".format(mod=module_name, err=",".join(logs)))
    1705. 

  1705.             return False
    1706. 

  1706. 

  1707.         module, logs = register_module(module_name)
    1708. 

  1708.         if module is None:
    1709. 

  1709.             log.info("Attempted to add {mod}. Got {err}".format(mod=module_name, err=logs))
    1710. 

  1710. 

  1711.         else:
    1712. 

  1712.             iris_module_disable_by_id(module.id)
    1713. 

  1713.             log.info('Successfully registered {mod}'.format(mod=module_name))
    1714. 

  1714. 

  1715. 

  1716. def custom_assets_symlinks():
    1717. 

  1717.     try:
    1718. 

  1718. 

  1719.         source_paths = glob.glob(os.path.join(app.config['ASSET_STORE_PATH'], "*"))
    1720. 

  1720. 

  1721.         for store_fullpath in source_paths:
    1722. 

  1722. 

  1723.             filename = store_fullpath.split(os.path.sep)[-1]
    1724. 

  1724.             show_fullpath = os.path.join(app.config['APP_PATH'], 'app',
    1725. 

  1725.                                          app.config['ASSET_SHOW_PATH'].strip(os.path.sep), filename)
    1726. 

  1726.             if not os.path.islink(show_fullpath):
    1727. 

  1727.                 os.symlink(store_fullpath, show_fullpath)
    1728. 

  1728.                 log.info(f"Created assets img symlink {store_fullpath} -> {show_fullpath}")
    1729. 

  1729. 

  1730.     except Exception as e:
    1731. 

  1731.         log.error(f"Error: {e}")
    1732. 

  1732. 

  1733. 

  1734. def create_directories():
    1735. 

  1735.     log.info("Attempting to create data directories")
    1736. 

  1736. 

  1737.     for d in ['UPLOADED_PATH', 'TEMPLATES_PATH', 'BACKUP_PATH', 'ASSET_STORE_PATH', 'DATASTORE_PATH']:
    1738. 

  1738.         try:
    1739. 

  1739.             log.info(f'Creating directory {d}')
    1740. 

  1740.             os.makedirs(app.config.get(d), exist_ok=True)
    1741. 

  1741.         except OSError as e:
    1742. 

  1742.             log.error(f"Failed to create directory {app.config.get(d)}: {e}")
    1743. 

  1743.