feat: add clear couch transaction API

Reviewed-on: #113

.drone.yml

@@ -1,38 +1,109 @@
 kind: pipeline
 type: docker
-name: build
+name: server
 steps:
-  - name: build-dev
+  # - name: build
+  #   image: appleboy/drone-ssh
+  #   settings:
+  #     host:
+  #       - 172.10.10.10
+  #     username: eigen
+  #     key:
+  #       from_secret: DEVOPS_SSH_PRIVATE_OPEN
+  #     port: 22
+  #     script:
+  #       - cd /home/eigen/PROJECT/POS/POS.DEV/BE
+  #       - sh build.sh
+  #   when:
+  #     ref:
+  #       - refs/tags/devel_*
+  #       - refs/tags/*-alpha.*
+  - name: build-testing
     image: plugins/docker
     settings:
       registry: registry.eigen.co.id
       repo: registry.eigen.co.id/eigen/${DRONE_REPO_NAME}
-      build_args:
-        - env_target=env.development
-      tags: latest
+      tags: ${DRONE_TAG}
       custom_dns: 172.10.10.16
-trigger:
+    when:
       ref:
-    - refs/tags/devel_*
+        - refs/tags/*-alpha.*
+  - name: build-production
+    image: plugins/docker
+    settings:
+      registry: registry.eigen.co.id
+      repo: registry.eigen.co.id/eigen/${DRONE_REPO_NAME}
+      tags: ${DRONE_TAG}
+      custom_dns: 172.10.10.16
+    when:
+      ref:
+        - refs/tags/*-production.*
+  - name: send-message
+    image: plugins/webhook
+    settings:
+      urls: https://mattermost.eigen.co.id/api/v4/posts
+      content_type: application/json
+      headers:
+        - Authorization=Bearer 5zubexudb38uuradfa36qy98ca
+      template: |
+        {
+          "channel_id": "s1ekqde1c3du5p35g6budnuotc",
+          "message": "Build {{repo.name}} sudah selesai"
+        }
+trigger:
   event:
     exclude:
       - promote
 ---
 kind: pipeline
 type: docker
-name: deployment
+name: kustomize
+
+clone:
+  disable: true
+
 steps:
-  - name: deployment
-    image: alpine
-    failure: ignore
+  - name: kustomize-testing
+    image: registry.k8s.io/kustomize/kustomize:v5.0.0
+    environment:
+      DEVOPS_SSH_PRIVATE:
+        from_secret: DEVOPS_SSH_PRIVATE
+      DEVOPS_SSH_PUBLIC:
+        from_secret: DEVOPS_SSH_PUBLIC
+      INFRASTRUCTURE_REPO: "k8s-kustomize-external"
+      DIRECTORY_NAME: "weplay-pos-testing"
     commands:
-      - apk add --no-cache curl
-      - curl -X POST https://manager.sky.eigen.co.id/api/webhooks/806de7e2-1d3e-4889-b472-a59af0a5eb33
+      - mkdir -p ~/.ssh &&
+      - echo $DEVOPS_SSH_PRIVATE | base64 -d > ~/.ssh/id_rsa &&
+      - echo $DEVOPS_SSH_PUBLIC | base64 -d > ~/.ssh/id_rsa.pub &&
+      - ssh-keyscan -H -p 2222 git.eigen.co.id >> ~/.ssh/known_hosts &&
+      - chmod 700 ~/.ssh/ &&
+      - chmod 600 ~/.ssh/id_rsa &&
+      - git clone ssh://git@git.eigen.co.id:2222/eigen/$INFRASTRUCTURE_REPO.git &&
+      - cd $INFRASTRUCTURE_REPO/$DIRECTORY_NAME
+      - kustomize edit set image registry.eigen.co.id/eigen/$DRONE_REPO_NAME=registry.eigen.co.id/eigen/$DRONE_REPO_NAME:$DRONE_TAG &&
+      - git add . &&
+      - |-
+        git commit -m "feat: update $DRONE_REPO_NAME testing to $DRONE_TAG" &&
+      - git push origin master
+  - name: send-message
+    image: harbor.eigen.co.id/docker.com/plugins/webhook
+    settings:
+      urls: https://mattermost.eigen.co.id/api/v4/posts
+      content_type: application/json
+      headers:
+        - Authorization=Bearer 5zubexudb38uuradfa36qy98ca
+      template: |
+        {
+          "channel_id": "s1ekqde1c3du5p35g6budnuotc",
+          "message": "ALERT: {{ repo.name }} gagal update dengan tag ${DRONE_TAG}"
+        }
+    when:
+      status:
+        - failure
 trigger:
   ref:
-    - refs/tags/devel_*
-  event:
-    exclude:
-      - promote
+    include:
+      - refs/tags/*-alpha.*
 depends_on:
-  - build
+  - server

.drone.yml.old

@@ -0,0 +1,38 @@
+kind: pipeline
+type: docker
+name: build
+steps:
+  - name: build-dev
+    image: plugins/docker
+    settings:
+      registry: registry.eigen.co.id
+      repo: registry.eigen.co.id/eigen/${DRONE_REPO_NAME}
+      build_args:
+        - env_target=env.development
+      tags: latest
+      custom_dns: 172.10.10.16
+trigger:
+  ref:
+    - refs/tags/devel_*
+  event:
+    exclude:
+      - promote
+---
+kind: pipeline
+type: docker
+name: deployment
+steps:
+  - name: deployment
+    image: alpine
+    failure: ignore
+    commands:
+      - apk add --no-cache curl
+      - curl -X POST https://manager.sky.eigen.co.id/api/webhooks/806de7e2-1d3e-4889-b472-a59af0a5eb33
+trigger:
+  ref:
+    - refs/tags/devel_*
+  event:
+    exclude:
+      - promote
+depends_on:
+  - build

.vscode/launch.json

@@ -0,0 +1,20 @@
+{
+  // Use IntelliSense to learn about possible attributes.
+  // Hover to view descriptions of existing attributes.
+  // For more information, visit: https://go.microsoft.com/fwlink/?linkid=830387
+  "version": "0.2.0",
+  "configurations": [
+    {
+      "type": "node",
+      "request": "launch",
+      "name": "Debug Nest Framework",
+      "runtimeExecutable": "npm",
+      "runtimeArgs": ["run", "start:debug", "--", "--inspect-brk"],
+      "autoAttachChildProcesses": true,
+      "restart": true,
+      "sourceMaps": true,
+      "stopOnEntry": false,
+      "console": "integratedTerminal"
+    }
+  ]
+}

Dockerfile

@@ -5,12 +5,13 @@ COPY . .
 RUN yarn install
 RUN yarn build
 FROM node:18.17-alpine
-ARG env_target
+# ARG env_target
 WORKDIR /app
-RUN echo ${env_target}
-COPY env/$env_target /app/.env
-COPY --from=builder /app/env/$env_target .env
+# RUN echo ${env_target}
+# COPY env/$env_target /app/.env
+# COPY --from=builder /app/env/$env_target .env
 COPY --from=builder /app/node_modules ./node_modules
 COPY --from=builder /app/dist ./dist
+COPY --from=builder /app/assets ./assets
 COPY --from=builder /app/package.json ./package.json
 CMD ["node", "--max-old-space-size=8192","--max-http-header-size", "512000", "-r", "dotenv/config", "dist/main"]

assets/email-template/change-date-information.html

@@ -4,7 +4,7 @@
 <head>
     <meta name="viewport" content="width=device-width" />
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
-    <title>Email Ibunda</title>
+    <title>Email Confirmation</title>
     <style>
         /* -------------------------------------
                     GLOBAL RESETS
@@ -364,45 +364,36 @@
                                 <table border="0" cellpadding="0" cellspacing="0">
                                     <tr>
                                         <td>
-                                            <p>Halo {{customer_name}}</p>
-                                            <p>Pemesanan tiket telah berhasil dengan nomor invoice {{invoice_code}}, Silahkan lakukan pembayaran</p>
+                                            <p class="mb0"><b>Dear,</b></p>
+                                            <p class="mb0">{{customer_name}}</p>
+                                            <p>{{customer_phone}}</p>
+
+                                            <p class="mb0">Great News! We've successfully updated your booking date as per your request.</p>
+                                            <p>We're excited to accommodate your new plans and ensure evertyhing goes smoothly.</p>
+
+                                            <p class="mb0">Here are your updated booking details</p>
+                                            <b class="mb0">Original Booking Date: {{booking_date_before}}</b>
+                                            <b>New Booking Date: {{booking_date}}</b>
+
+                                            <p class="mb0">For yout convenience, we've attached a new confirmation receipt reflecting these changes.</p>
+                                            <p><b>Please be sure to bring this updated receipt with you on the new date</b></p>
+
+                                            <p class="mb0">To keep the good times rolling, our friendly support team is just a call away at</p>
+                                            <b>{{phone_cs}}</b>
                                             <br>
-                                            <p>
-                                                <b>PEMBAYARAN DAPAT MELALUI</b>
-                                                <ul>
-                                                    {{#each payment_methods}}
-                                                        <li>
-                                                            <p>
-                                                                <b>{{issuer_name}}</b><br>
-                                                                <span>Name: <b>{{account_name}}</b></span><br>
-                                                                <span>Number: <b>{{account_number}}</b></span>
-                                                            </p>
-                                                        </li>
-                                                    {{/each}}
-                                                </ul>
-                                            </p>
+
+                                            <p>Thank you and we can't wait to see you and make sure you have an amazing time!</p>
+
+                                            <br><br>
+                                            <b>Best Regrads,</b><br>
+                                            <b>WEplayground</b>
                                         </td>
                                     </tr>
                                 </table>
                             </td>
                         </tr>
-
                         <!-- END MAIN CONTENT AREA -->
                     </table>
-
-                    <!-- START FOOTER -->
-                    <div class="footer">
-                        <table border="0" cellpadding="0" cellspacing="0">
-                            <tr>
-                                <td class="content-block powered-by">
-                                    Powered by Skyworld
-                                </td>
-                            </tr>
-                        </table>
-                    </div>
-                    <!-- END FOOTER -->
-
-                    <!-- END CENTERED WHITE CONTAINER -->
                 </div>
             </td>
             <td>&nbsp;</td>

assets/email-template/invoice-bank.html

@@ -0,0 +1,412 @@
+<!doctype html>
+<html>
+
+<head>
+    <meta name="viewport" content="width=device-width" />
+    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
+    <title>Email Confirmation</title>
+    <style>
+        /* -------------------------------------
+                    GLOBAL RESETS
+                    ------------------------------------- */
+        img {
+            border: none;
+            -ms-interpolation-mode: bicubic;
+            max-width: 100%;
+        }
+
+        body {
+            background-color: #f6f6f6;
+            font-family: sans-serif;
+            -webkit-font-smoothing: antialiased;
+            font-size: 14px;
+            line-height: 1.4;
+            margin: 0;
+            padding: 0;
+            -ms-text-size-adjust: 100%;
+            -webkit-text-size-adjust: 100%;
+        }
+
+        table {
+            border-collapse: separate;
+            mso-table-lspace: 0pt;
+            width: 100%;
+        }
+
+        table td {
+            font-family: sans-serif;
+            font-size: 14px;
+            vertical-align: top;
+        }
+
+        /* -------------------------------------
+                    BODY & CONTAINER
+                    ------------------------------------- */
+
+        .body {
+            background-color: #f6f6f6;
+            width: 100%;
+        }
+
+        /* Set a max-width, and make it display as block so it will automatically stretch to that width, but will also shrink
+                    down on a phone or something */
+        .container {
+            display: block;
+            Margin: 0 auto !important;
+            /* makes it centered */
+            max-width: 580px;
+            padding: 10px;
+            width: 580px;
+        }
+
+        /* This should also be a block element, so that it will fill 100% of the .container */
+        .content {
+            box-sizing: border-box;
+            display: block;
+            Margin: 0 auto;
+            max-width: 580px;
+            padding: 10px;
+        }
+
+        /* -------------------------------------
+                    HEADER, FOOTER, MAIN
+                    ------------------------------------- */
+        .main {
+            background: #ffffff;
+            border-radius: 3px;
+            width: 100%;
+        }
+
+        .wrapper {
+            box-sizing: border-box;
+            padding: 20px;
+        }
+
+        .content-block {
+            padding-bottom: 10px;
+            padding-top: 10px;
+        }
+
+        .footer {
+            clear: both;
+            Margin-top: 10px;
+            text-align: center;
+            width: 100%;
+        }
+
+        .footer td,
+        .footer p,
+        .footer span,
+        .footer a {
+            color: #999999;
+            font-size: 12px;
+            text-align: center;
+        }
+
+        /* -------------------------------------
+                    TYPOGRAPHY
+                    ------------------------------------- */
+        h1,
+        h2,
+        h3,
+        h4 {
+            color: #000000;
+            font-family: sans-serif;
+            font-weight: 400;
+            line-height: 1.4;
+            margin: 0;
+            Margin-bottom: 30px;
+        }
+
+        h1 {
+            font-size: 35px;
+            font-weight: 300;
+            text-align: center;
+            text-transform: capitalize;
+        }
+
+        p,
+        ul,
+        ol {
+            font-family: sans-serif;
+            font-size: 14px;
+            font-weight: normal;
+            margin: 0;
+            Margin-bottom: 15px;
+        }
+
+        p li,
+        ul li,
+        ol li {
+            list-style-position: inside;
+            margin-left: 5px;
+        }
+
+        a {
+            color: #3498db;
+            text-decoration: underline;
+        }
+
+        /* -------------------------------------
+                    BUTTONS
+                    ------------------------------------- */
+        .btn {
+            box-sizing: border-box;
+            width: 100%;
+        }
+
+        .btn>tbody>tr>td {
+            padding-bottom: 15px;
+        }
+
+        .btn table {
+            width: auto;
+        }
+
+        .btn table td {
+            background-color: #ffffff;
+            border-radius: 5px;
+            text-align: center;
+        }
+
+        .btn a {
+            background-color: #ffffff;
+            border: solid 1px #3498db;
+            border-radius: 5px;
+            box-sizing: border-box;
+            color: #3498db;
+            cursor: pointer;
+            display: inline-block;
+            font-size: 14px;
+            font-weight: bold;
+            margin: 0;
+            padding: 12px 25px;
+            text-decoration: none;
+            text-transform: capitalize;
+        }
+
+        .btn-primary table td {
+            background-color: #3498db;
+        }
+
+        .btn-primary a {
+            background-color: #3498db;
+            border-color: #3498db;
+            color: #ffffff;
+        }
+
+        /* -------------------------------------
+                    OTHER STYLES THAT MIGHT BE USEFUL
+                    ------------------------------------- */
+        .last {
+            margin-bottom: 0;
+        }
+
+        .first {
+            margin-top: 0;
+        }
+
+        .align-center {
+            text-align: center;
+        }
+
+        .align-right {
+            text-align: right;
+        }
+
+        .align-left {
+            text-align: left;
+        }
+
+        .clear {
+            clear: both;
+        }
+
+        .mt0 {
+            margin-top: 0;
+        }
+
+        .mb0 {
+            margin-bottom: 0;
+        }
+
+        .preheader {
+            color: transparent;
+            display: none;
+            height: 0;
+            max-height: 0;
+            max-width: 0;
+            opacity: 0;
+            overflow: hidden;
+            visibility: hidden;
+            width: 0;
+        }
+
+        .powered-by a {
+            text-decoration: none;
+        }
+
+        hr {
+            border: 0;
+            border-bottom: 1px solid #f6f6f6;
+            Margin: 20px 0;
+        }
+
+        /* -------------------------------------
+                    RESPONSIVE AND MOBILE FRIENDLY STYLES
+                    ------------------------------------- */
+        @media only screen and (max-width: 620px) {
+            table[class=body] h1 {
+                font-size: 28px !important;
+                margin-bottom: 10px !important;
+            }
+
+            table[class=body] p,
+            table[class=body] ul,
+            table[class=body] ol,
+            table[class=body] td,
+            table[class=body] span,
+            table[class=body] a {
+                font-size: 16px !important;
+            }
+
+            table[class=body] .wrapper,
+            table[class=body] .article {
+                padding: 10px !important;
+            }
+
+            table[class=body] .content {
+                padding: 0 !important;
+            }
+
+            table[class=body] .container {
+                padding: 0 !important;
+                width: 100% !important;
+            }
+
+            table[class=body] .main {
+                border-left-width: 0 !important;
+                border-radius: 0 !important;
+                border-right-width: 0 !important;
+            }
+
+            table[class=body] .btn table {
+                width: 100% !important;
+            }
+
+            table[class=body] .btn a {
+                width: 100% !important;
+            }
+
+            table[class=body] .img-responsive {
+                height: auto !important;
+                max-width: 100% !important;
+                width: auto !important;
+            }
+        }
+
+        /* -------------------------------------
+                    PRESERVE THESE STYLES IN THE HEAD
+                    ------------------------------------- */
+        @media all {
+            .ExternalClass {
+                width: 100%;
+            }
+
+            .ExternalClass,
+            .ExternalClass p,
+            .ExternalClass span,
+            .ExternalClass font,
+            .ExternalClass td,
+            .ExternalClass div {
+                line-height: 100%;
+            }
+
+            .apple-link a {
+                color: inherit !important;
+                font-family: inherit !important;
+                font-size: inherit !important;
+                font-weight: inherit !important;
+                line-height: inherit !important;
+                text-decoration: none !important;
+            }
+
+            .btn-primary table td:hover {
+                background-color: #34495e !important;
+            }
+
+            .btn-primary a:hover {
+                background-color: #34495e !important;
+                border-color: #34495e !important;
+            }
+        }
+
+        ol {
+            padding: 0 0 0 1em;
+        }
+
+        ol li {
+            margin: 1em 0;
+        }
+    </style>
+</head>
+
+<body class="">
+    <table border="0" cellpadding="0" cellspacing="0" class="body">
+        <tr>
+            <td>&nbsp;</td>
+            <td class="container">
+                <div class="content">
+                    <table class="main">
+                        <!-- START MAIN CONTENT AREA -->
+                        <tr>
+                            <td class="wrapper">
+                                <table border="0" cellpadding="0" cellspacing="0">
+                                    <tr>
+                                        <td>
+                                            <p class="mb0"><b>Dear,</b></p>
+                                            <p class="mb0">{{customer_name}}</p>
+                                            <p>{{customer_phone}}</p>
+
+                                            <p>Thank you fot choosing us! We're absolutelty thrilled and can't wait to embark on this exciting day with you. See you soon for fun times ahead</p>
+
+                                            <p class="mb0">Here's a quick recap of your invoice:</p>
+                                            <p class="mb0">Booking Date: {{booking_date}}</p>
+                                            <p>Total Invoice: {{payment_total}}</p>
+
+                                            <p class="mb0">Just a friendly reminder that your invoice will expire on {{expire_date}}</p>
+                                            <p>To keep things running smoothly, please ensure your payment is completed before this data</p>
+
+                                            <p>
+                                                For your convenience, here is a list of our account details:
+                                                <ul>
+                                                    {{#each payment_methods}}
+                                                        <li>
+                                                            <p>{{issuer_name}} {{account_number}} a/n  >{{account_name}}</p>
+                                                        </li>
+                                                    {{/each}}
+                                                </ul>
+                                            </p>
+
+                                            <p class="mb0">Once you've made the payment, please kindly email or send the proof of payment so we can proceed with your booking promptly</p>
+                                            <p class="mb0">If you have any questions or need assistance, feel free to reach out to our support team at</p>
+                                            <b>{{phone_cs}}</b>
+
+                                            <br><br>
+                                            <b>Best Regrads,</b><br>
+                                            <b>WEplayground</b>
+                                        </td>
+                                    </tr>
+                                </table>
+                            </td>
+                        </tr>
+                        <!-- END MAIN CONTENT AREA -->
+                    </table>
+                </div>
+            </td>
+            <td>&nbsp;</td>
+        </tr>
+    </table>
+</body>
+
+</html>

assets/email-template/invoice-expired.html

@@ -4,7 +4,7 @@
 <head>
     <meta name="viewport" content="width=device-width" />
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
-    <title>Email Ibunda</title>
+    <title>Email Confirmation</title>
     <style>
         /* -------------------------------------
                     GLOBAL RESETS
@@ -364,36 +364,32 @@
                                 <table border="0" cellpadding="0" cellspacing="0">
                                     <tr>
                                         <td>
-                                            <p>Halo {{customer_name}}</p>
-                                            <p>Pemesanan tiket telah berhasil dengan nomor invoice {{invoice_code}}, Silahkan lakukan pembayaran dengan klik button dibawah ini</p>
-                                        </td>
-                                    </tr>
-                                    <tr>
-                                        <td align="center"
-                                            style="font-family: 'Lato', sans-serif; font-size:22px; color:#e5eaf5; line-height:24px; font-weight: 600;">
-                                            <a href="{{payment_midtrans_url}}">Lanjutkan Pembayaran</a>
+                                            <p class="mb0"><b>Dear,</b></p>
+                                            <p class="mb0">{{customer_name}}</p>
+                                            <p>{{customer_phone}}</p>
+
+                                            <p>We hope this message finds you well!</p>
+
+                                            <p class="mb0">Uh-oh! it looks like your invoice, dated {{invoice_date}}, has officially expired as of {{expired_date}}</p>
+                                            <p>But no worries, we can fix this together!</p>
+
+                                            <p class="mb0">To keep the good times rolling, our friendly support team is just a call away at</p>
+                                            <b>{{phone_cs}}</b>
+
+                                            <p class="mb0">Here are the details of the expired invoice:</p>
+                                            <p class="mb0">Booking Date: {{booking_date}}</p>
+                                            <p>Total Invoice: {{total_payment}}</p>
+
+                                            <br><br>
+                                            <b>Best Regrads,</b><br>
+                                            <b>WEplayground</b>
                                         </td>
                                     </tr>
                                 </table>
                             </td>
                         </tr>
-
                         <!-- END MAIN CONTENT AREA -->
                     </table>
-
-                    <!-- START FOOTER -->
-                    <div class="footer">
-                        <table border="0" cellpadding="0" cellspacing="0">
-                            <tr>
-                                <td class="content-block powered-by">
-                                    Powered by Skyworld
-                                </td>
-                            </tr>
-                        </table>
-                    </div>
-                    <!-- END FOOTER -->
-
-                    <!-- END CENTERED WHITE CONTAINER -->
                 </div>
             </td>
             <td>&nbsp;</td>

assets/email-template/invoice-midtrans.html

@@ -0,0 +1,419 @@
+<!doctype html>
+<html>
+
+<head>
+    <meta name="viewport" content="width=device-width" />
+    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
+    <title>Email Confirmation</title>
+    <style>
+        /* -------------------------------------
+                    GLOBAL RESETS
+                    ------------------------------------- */
+        img {
+            border: none;
+            -ms-interpolation-mode: bicubic;
+            max-width: 100%;
+        }
+
+        body {
+            background-color: #f6f6f6;
+            font-family: sans-serif;
+            -webkit-font-smoothing: antialiased;
+            font-size: 14px;
+            line-height: 1.4;
+            margin: 0;
+            padding: 0;
+            -ms-text-size-adjust: 100%;
+            -webkit-text-size-adjust: 100%;
+        }
+
+        table {
+            border-collapse: separate;
+            mso-table-lspace: 0pt;
+            width: 100%;
+        }
+
+        table td {
+            font-family: sans-serif;
+            font-size: 14px;
+            vertical-align: top;
+        }
+
+        /* -------------------------------------
+                    BODY & CONTAINER
+                    ------------------------------------- */
+
+        .body {
+            background-color: #f6f6f6;
+            width: 100%;
+        }
+
+        /* Set a max-width, and make it display as block so it will automatically stretch to that width, but will also shrink
+                    down on a phone or something */
+        .container {
+            display: block;
+            Margin: 0 auto !important;
+            /* makes it centered */
+            max-width: 580px;
+            padding: 10px;
+            width: 580px;
+        }
+
+        /* This should also be a block element, so that it will fill 100% of the .container */
+        .content {
+            box-sizing: border-box;
+            display: block;
+            Margin: 0 auto;
+            max-width: 580px;
+            padding: 10px;
+        }
+
+        /* -------------------------------------
+                    HEADER, FOOTER, MAIN
+                    ------------------------------------- */
+        .main {
+            background: #ffffff;
+            border-radius: 3px;
+            width: 100%;
+        }
+
+        .wrapper {
+            box-sizing: border-box;
+            padding: 20px;
+        }
+
+        .content-block {
+            padding-bottom: 10px;
+            padding-top: 10px;
+        }
+
+        .footer {
+            clear: both;
+            Margin-top: 10px;
+            text-align: center;
+            width: 100%;
+        }
+
+        .footer td,
+        .footer p,
+        .footer span,
+        .footer a {
+            color: #999999;
+            font-size: 12px;
+            text-align: center;
+        }
+
+        /* -------------------------------------
+                    TYPOGRAPHY
+                    ------------------------------------- */
+        h1,
+        h2,
+        h3,
+        h4 {
+            color: #000000;
+            font-family: sans-serif;
+            font-weight: 400;
+            line-height: 1.4;
+            margin: 0;
+            Margin-bottom: 30px;
+        }
+
+        h1 {
+            font-size: 35px;
+            font-weight: 300;
+            text-align: center;
+            text-transform: capitalize;
+        }
+
+        p,
+        ul,
+        ol {
+            font-family: sans-serif;
+            font-size: 14px;
+            font-weight: normal;
+            margin: 0;
+            Margin-bottom: 15px;
+        }
+
+        p li,
+        ul li,
+        ol li {
+            list-style-position: inside;
+            margin-left: 5px;
+        }
+
+        a {
+            color: #3498db;
+            text-decoration: underline;
+        }
+
+        /* -------------------------------------
+                    BUTTONS
+                    ------------------------------------- */
+        .btn {
+            box-sizing: border-box;
+            width: 100%;
+        }
+
+        .btn>tbody>tr>td {
+            padding-bottom: 15px;
+        }
+
+        .btn table {
+            width: auto;
+        }
+
+        .btn table td {
+            background-color: #ffffff;
+            border-radius: 5px;
+            text-align: center;
+        }
+
+        .btn a {
+            background-color: #ffffff;
+            border: solid 1px #3498db;
+            border-radius: 5px;
+            box-sizing: border-box;
+            color: #3498db;
+            cursor: pointer;
+            display: inline-block;
+            font-size: 14px;
+            font-weight: bold;
+            margin: 0;
+            padding: 12px 25px;
+            text-decoration: none;
+            text-transform: capitalize;
+        }
+
+        .btn-primary table td {
+            background-color: #3498db;
+        }
+
+        .btn-primary a {
+            background-color: #3498db;
+            border-color: #3498db;
+            color: #ffffff;
+        }
+
+        /* -------------------------------------
+                    OTHER STYLES THAT MIGHT BE USEFUL
+                    ------------------------------------- */
+        .last {
+            margin-bottom: 0;
+        }
+
+        .first {
+            margin-top: 0;
+        }
+
+        .align-center {
+            text-align: center;
+        }
+
+        .align-right {
+            text-align: right;
+        }
+
+        .align-left {
+            text-align: left;
+        }
+
+        .clear {
+            clear: both;
+        }
+
+        .mt0 {
+            margin-top: 0;
+        }
+
+        .mb0 {
+            margin-bottom: 0;
+        }
+
+        .preheader {
+            color: transparent;
+            display: none;
+            height: 0;
+            max-height: 0;
+            max-width: 0;
+            opacity: 0;
+            overflow: hidden;
+            visibility: hidden;
+            width: 0;
+        }
+
+        .powered-by a {
+            text-decoration: none;
+        }
+
+        hr {
+            border: 0;
+            border-bottom: 1px solid #f6f6f6;
+            Margin: 20px 0;
+        }
+
+        /* -------------------------------------
+                    RESPONSIVE AND MOBILE FRIENDLY STYLES
+                    ------------------------------------- */
+        @media only screen and (max-width: 620px) {
+            table[class=body] h1 {
+                font-size: 28px !important;
+                margin-bottom: 10px !important;
+            }
+
+            table[class=body] p,
+            table[class=body] ul,
+            table[class=body] ol,
+            table[class=body] td,
+            table[class=body] span,
+            table[class=body] a {
+                font-size: 16px !important;
+            }
+
+            table[class=body] .wrapper,
+            table[class=body] .article {
+                padding: 10px !important;
+            }
+
+            table[class=body] .content {
+                padding: 0 !important;
+            }
+
+            table[class=body] .container {
+                padding: 0 !important;
+                width: 100% !important;
+            }
+
+            table[class=body] .main {
+                border-left-width: 0 !important;
+                border-radius: 0 !important;
+                border-right-width: 0 !important;
+            }
+
+            table[class=body] .btn table {
+                width: 100% !important;
+            }
+
+            table[class=body] .btn a {
+                width: 100% !important;
+            }
+
+            table[class=body] .img-responsive {
+                height: auto !important;
+                max-width: 100% !important;
+                width: auto !important;
+            }
+        }
+
+        /* -------------------------------------
+                    PRESERVE THESE STYLES IN THE HEAD
+                    ------------------------------------- */
+        @media all {
+            .ExternalClass {
+                width: 100%;
+            }
+
+            .ExternalClass,
+            .ExternalClass p,
+            .ExternalClass span,
+            .ExternalClass font,
+            .ExternalClass td,
+            .ExternalClass div {
+                line-height: 100%;
+            }
+
+            .apple-link a {
+                color: inherit !important;
+                font-family: inherit !important;
+                font-size: inherit !important;
+                font-weight: inherit !important;
+                line-height: inherit !important;
+                text-decoration: none !important;
+            }
+
+            .btn-primary table td:hover {
+                background-color: #34495e !important;
+            }
+
+            .btn-primary a:hover {
+                background-color: #34495e !important;
+                border-color: #34495e !important;
+            }
+        }
+
+        ol {
+            padding: 0 0 0 1em;
+        }
+
+        ol li {
+            margin: 1em 0;
+        }
+    </style>
+</head>
+
+<body class="">
+    <table border="0" cellpadding="0" cellspacing="0" class="body">
+        <tr>
+            <td>&nbsp;</td>
+            <td class="container">
+                <div class="content">
+                    <table class="main">
+                        <!-- START MAIN CONTENT AREA -->
+                        <tr>
+                            <td class="wrapper">
+                                <table border="0" cellpadding="0" cellspacing="0">
+                                    <tr>
+                                        <td>
+                                            <p class="mb0"><b>Dear,</b></p>
+                                            <p class="mb0">{{customer_name}}</p>
+                                            <p>{{customer_phone}}</p>
+
+                                            <p>Thank you fot choosing us! We're absolutelty thrilled and can't wait to embark on this exciting day with you. See you soon for fun times ahead</p>
+
+                                            <p class="mb0">Here's a quick recap of your invoice:</p>
+                                            <p class="mb0">Booking Date: {{booking_date}}</p>
+                                            <p>Total Invoice: {{payment_total}}</p>
+
+                                            <p class="mb0">Just a friendly reminder that your invoice will expire on {{expire_date}}</p>
+                                            <p>To keep things running smoothly, please ensure your payment is completed before this data</p>
+
+                                            <p class="mb0">For your convenience, here is a list of our account details:</p>
+                                            <a href="{{payment_midtrans_url}}">{{payment_midtrans_url}}</a>
+                                            <br><br>
+
+                                            <p class="mb0">Once you've made the payment, please kindly email or send the proof of payment so we can proceed with your booking promptly</p>
+                                            <p class="mb0">If you have any questions or need assistance, feel free to reach out to our support team at</p>
+                                            <b>{{phone_cs}}</b>
+
+                                            <br><br>
+                                            <b>Best Regrads,</b><br>
+                                            <b>WEplayground</b>
+                                        </td>
+                                    </tr>
+                                </table>
+                            </td>
+                        </tr>
+                        <!-- END MAIN CONTENT AREA -->
+                    </table>
+
+                    <!-- START FOOTER -->
+                    <!-- <div class="footer">
+                        <table border="0" cellpadding="0" cellspacing="0">
+                            <tr>
+                                <td class="content-block powered-by">
+                                    Powered by Skyworld
+                                </td>
+                            </tr>
+                        </table>
+                    </div> -->
+                    <!-- END FOOTER -->
+
+                    <!-- END CENTERED WHITE CONTAINER -->
+                </div>
+            </td>
+            <td>&nbsp;</td>
+        </tr>
+    </table>
+</body>
+
+</html>

assets/email-template/payment-confirmation.html

@@ -0,0 +1,412 @@
+<!doctype html>
+<html>
+
+<head>
+    <meta name="viewport" content="width=device-width" />
+    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
+    <title>Email Confirmation</title>
+    <style>
+        /* -------------------------------------
+                    GLOBAL RESETS
+                    ------------------------------------- */
+        img {
+            border: none;
+            -ms-interpolation-mode: bicubic;
+            max-width: 100%;
+        }
+
+        body {
+            background-color: #f6f6f6;
+            font-family: sans-serif;
+            -webkit-font-smoothing: antialiased;
+            font-size: 14px;
+            line-height: 1.4;
+            margin: 0;
+            padding: 0;
+            -ms-text-size-adjust: 100%;
+            -webkit-text-size-adjust: 100%;
+        }
+
+        table {
+            border-collapse: separate;
+            mso-table-lspace: 0pt;
+            width: 100%;
+        }
+
+        table td {
+            font-family: sans-serif;
+            font-size: 14px;
+            vertical-align: top;
+        }
+
+        /* -------------------------------------
+                    BODY & CONTAINER
+                    ------------------------------------- */
+
+        .body {
+            background-color: #f6f6f6;
+            width: 100%;
+        }
+
+        /* Set a max-width, and make it display as block so it will automatically stretch to that width, but will also shrink
+                    down on a phone or something */
+        .container {
+            display: block;
+            Margin: 0 auto !important;
+            /* makes it centered */
+            max-width: 580px;
+            padding: 10px;
+            width: 580px;
+        }
+
+        /* This should also be a block element, so that it will fill 100% of the .container */
+        .content {
+            box-sizing: border-box;
+            display: block;
+            Margin: 0 auto;
+            max-width: 580px;
+            padding: 10px;
+        }
+
+        /* -------------------------------------
+                    HEADER, FOOTER, MAIN
+                    ------------------------------------- */
+        .main {
+            background: #ffffff;
+            border-radius: 3px;
+            width: 100%;
+        }
+
+        .wrapper {
+            box-sizing: border-box;
+            padding: 20px;
+        }
+
+        .content-block {
+            padding-bottom: 10px;
+            padding-top: 10px;
+        }
+
+        .footer {
+            clear: both;
+            Margin-top: 10px;
+            text-align: center;
+            width: 100%;
+        }
+
+        .footer td,
+        .footer p,
+        .footer span,
+        .footer a {
+            color: #999999;
+            font-size: 12px;
+            text-align: center;
+        }
+
+        /* -------------------------------------
+                    TYPOGRAPHY
+                    ------------------------------------- */
+        h1,
+        h2,
+        h3,
+        h4 {
+            color: #000000;
+            font-family: sans-serif;
+            font-weight: 400;
+            line-height: 1.4;
+            margin: 0;
+            Margin-bottom: 30px;
+        }
+
+        h1 {
+            font-size: 35px;
+            font-weight: 300;
+            text-align: center;
+            text-transform: capitalize;
+        }
+
+        p,
+        ul,
+        ol {
+            font-family: sans-serif;
+            font-size: 14px;
+            font-weight: normal;
+            margin: 0;
+            Margin-bottom: 15px;
+        }
+
+        p li,
+        ul li,
+        ol li {
+            list-style-position: inside;
+            margin-left: 5px;
+        }
+
+        a {
+            color: #3498db;
+            text-decoration: underline;
+        }
+
+        /* -------------------------------------
+                    BUTTONS
+                    ------------------------------------- */
+        .btn {
+            box-sizing: border-box;
+            width: 100%;
+        }
+
+        .btn>tbody>tr>td {
+            padding-bottom: 15px;
+        }
+
+        .btn table {
+            width: auto;
+        }
+
+        .btn table td {
+            background-color: #ffffff;
+            border-radius: 5px;
+            text-align: center;
+        }
+
+        .btn a {
+            background-color: #ffffff;
+            border: solid 1px #3498db;
+            border-radius: 5px;
+            box-sizing: border-box;
+            color: #3498db;
+            cursor: pointer;
+            display: inline-block;
+            font-size: 14px;
+            font-weight: bold;
+            margin: 0;
+            padding: 12px 25px;
+            text-decoration: none;
+            text-transform: capitalize;
+        }
+
+        .btn-primary table td {
+            background-color: #3498db;
+        }
+
+        .btn-primary a {
+            background-color: #3498db;
+            border-color: #3498db;
+            color: #ffffff;
+        }
+
+        /* -------------------------------------
+                    OTHER STYLES THAT MIGHT BE USEFUL
+                    ------------------------------------- */
+        .last {
+            margin-bottom: 0;
+        }
+
+        .first {
+            margin-top: 0;
+        }
+
+        .align-center {
+            text-align: center;
+        }
+
+        .align-right {
+            text-align: right;
+        }
+
+        .align-left {
+            text-align: left;
+        }
+
+        .clear {
+            clear: both;
+        }
+
+        .mt0 {
+            margin-top: 0;
+        }
+
+        .mb0 {
+            margin-bottom: 0;
+        }
+
+        .preheader {
+            color: transparent;
+            display: none;
+            height: 0;
+            max-height: 0;
+            max-width: 0;
+            opacity: 0;
+            overflow: hidden;
+            visibility: hidden;
+            width: 0;
+        }
+
+        .powered-by a {
+            text-decoration: none;
+        }
+
+        hr {
+            border: 0;
+            border-bottom: 1px solid #f6f6f6;
+            Margin: 20px 0;
+        }
+
+        /* -------------------------------------
+                    RESPONSIVE AND MOBILE FRIENDLY STYLES
+                    ------------------------------------- */
+        @media only screen and (max-width: 620px) {
+            table[class=body] h1 {
+                font-size: 28px !important;
+                margin-bottom: 10px !important;
+            }
+
+            table[class=body] p,
+            table[class=body] ul,
+            table[class=body] ol,
+            table[class=body] td,
+            table[class=body] span,
+            table[class=body] a {
+                font-size: 16px !important;
+            }
+
+            table[class=body] .wrapper,
+            table[class=body] .article {
+                padding: 10px !important;
+            }
+
+            table[class=body] .content {
+                padding: 0 !important;
+            }
+
+            table[class=body] .container {
+                padding: 0 !important;
+                width: 100% !important;
+            }
+
+            table[class=body] .main {
+                border-left-width: 0 !important;
+                border-radius: 0 !important;
+                border-right-width: 0 !important;
+            }
+
+            table[class=body] .btn table {
+                width: 100% !important;
+            }
+
+            table[class=body] .btn a {
+                width: 100% !important;
+            }
+
+            table[class=body] .img-responsive {
+                height: auto !important;
+                max-width: 100% !important;
+                width: auto !important;
+            }
+        }
+
+        /* -------------------------------------
+                    PRESERVE THESE STYLES IN THE HEAD
+                    ------------------------------------- */
+        @media all {
+            .ExternalClass {
+                width: 100%;
+            }
+
+            .ExternalClass,
+            .ExternalClass p,
+            .ExternalClass span,
+            .ExternalClass font,
+            .ExternalClass td,
+            .ExternalClass div {
+                line-height: 100%;
+            }
+
+            .apple-link a {
+                color: inherit !important;
+                font-family: inherit !important;
+                font-size: inherit !important;
+                font-weight: inherit !important;
+                line-height: inherit !important;
+                text-decoration: none !important;
+            }
+
+            .btn-primary table td:hover {
+                background-color: #34495e !important;
+            }
+
+            .btn-primary a:hover {
+                background-color: #34495e !important;
+                border-color: #34495e !important;
+            }
+        }
+
+        ol {
+            padding: 0 0 0 1em;
+        }
+
+        ol li {
+            margin: 1em 0;
+        }
+    </style>
+</head>
+
+<body class="">
+    <table border="0" cellpadding="0" cellspacing="0" class="body">
+        <tr>
+            <td>&nbsp;</td>
+            <td class="container">
+                <div class="content">
+                    <table class="main">
+                        <!-- START MAIN CONTENT AREA -->
+                        <tr>
+                            <td class="wrapper">
+                                <table border="0" cellpadding="0" cellspacing="0">
+                                    <tr>
+                                        <td>
+                                            <p class="mb0"><b>Dear,</b></p>
+                                            <p class="mb0">{{customer_name}}</p>
+                                            <p>{{customer_phone}}</p>
+                                     
+                                            <p class="mb0">We are excited to inform you that your payment has been successfully received!</p>
+                                            <p class="mb0">Attached to this email, you will find your confirmatin receipt</p>
+                                            <p class="mb0">Please keep this safe as you will need to show it at the entrance upon your arrival</p>
+                                            <p>It's your golden ticket to all the fun and excitement awaiting you!</p>
+
+                                            <br>
+                                                <p class="mb0">Here's a quick recap:</p>
+
+                                                <p class="mb0">Booking Date: {{booking_date}}</p>
+                                                <p class="mb0">Invoice Code: {{invoice_code}}</p>
+                                                <p class="mb0">Payment Date: {{payment_date}}</p>
+                                                <p class="mb0">Payment Code: {{payment_code}}</p>
+                                                <p class="mb0">Payment Via: {{payment_via}}</p>
+                                                <p class="mb0">Account No: {{account_no}}</p>
+                                                <p>On Behalf Of: {{account_name}}</p>
+                                            <br>
+
+                                            <p class="mb0">If you have any questions or need assistance, feel free to reach out to our support team at</p>
+                                            <b>{{phone_cs}}</b>
+                                            <br>
+
+                                            <p class="mb0">Font forget to bring a smile and your confirmation receipt (attached) for a smooth entry</p>
+                                            <p>We can't wait to see you and ensure you have an amazing time with us!</p>
+                                            
+                                            <br><br>
+                                            <b>Best Regrads,</b><br>
+                                            <b>WEplayground</b>
+                                        </td>
+                                    </tr>
+                                </table>
+                            </td>
+                        </tr>
+                        <!-- END MAIN CONTENT AREA -->
+                    </table>
+                </div>
+            </td>
+            <td>&nbsp;</td>
+        </tr>
+    </table>
+</body>
+
+</html>

assets/email-template/refund-confirmation.html

@@ -0,0 +1,415 @@
+<!doctype html>
+<html>
+
+<head>
+    <meta name="viewport" content="width=device-width" />
+    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
+    <title>Email Confirmation</title>
+    <style>
+        /* -------------------------------------
+                    GLOBAL RESETS
+                    ------------------------------------- */
+        img {
+            border: none;
+            -ms-interpolation-mode: bicubic;
+            max-width: 100%;
+        }
+
+        body {
+            background-color: #f6f6f6;
+            font-family: sans-serif;
+            -webkit-font-smoothing: antialiased;
+            font-size: 14px;
+            line-height: 1.4;
+            margin: 0;
+            padding: 0;
+            -ms-text-size-adjust: 100%;
+            -webkit-text-size-adjust: 100%;
+        }
+
+        table {
+            border-collapse: separate;
+            mso-table-lspace: 0pt;
+            width: 100%;
+        }
+
+        table td {
+            font-family: sans-serif;
+            font-size: 14px;
+            vertical-align: top;
+        }
+
+        /* -------------------------------------
+                    BODY & CONTAINER
+                    ------------------------------------- */
+
+        .body {
+            background-color: #f6f6f6;
+            width: 100%;
+        }
+
+        /* Set a max-width, and make it display as block so it will automatically stretch to that width, but will also shrink
+                    down on a phone or something */
+        .container {
+            display: block;
+            Margin: 0 auto !important;
+            /* makes it centered */
+            max-width: 580px;
+            padding: 10px;
+            width: 580px;
+        }
+
+        /* This should also be a block element, so that it will fill 100% of the .container */
+        .content {
+            box-sizing: border-box;
+            display: block;
+            Margin: 0 auto;
+            max-width: 580px;
+            padding: 10px;
+        }
+
+        /* -------------------------------------
+                    HEADER, FOOTER, MAIN
+                    ------------------------------------- */
+        .main {
+            background: #ffffff;
+            border-radius: 3px;
+            width: 100%;
+        }
+
+        .wrapper {
+            box-sizing: border-box;
+            padding: 20px;
+        }
+
+        .content-block {
+            padding-bottom: 10px;
+            padding-top: 10px;
+        }
+
+        .footer {
+            clear: both;
+            Margin-top: 10px;
+            text-align: center;
+            width: 100%;
+        }
+
+        .footer td,
+        .footer p,
+        .footer span,
+        .footer a {
+            color: #999999;
+            font-size: 12px;
+            text-align: center;
+        }
+
+        /* -------------------------------------
+                    TYPOGRAPHY
+                    ------------------------------------- */
+        h1,
+        h2,
+        h3,
+        h4 {
+            color: #000000;
+            font-family: sans-serif;
+            font-weight: 400;
+            line-height: 1.4;
+            margin: 0;
+            Margin-bottom: 30px;
+        }
+
+        h1 {
+            font-size: 35px;
+            font-weight: 300;
+            text-align: center;
+            text-transform: capitalize;
+        }
+
+        p,
+        ul,
+        ol {
+            font-family: sans-serif;
+            font-size: 14px;
+            font-weight: normal;
+            margin: 0;
+            Margin-bottom: 15px;
+        }
+
+        p li,
+        ul li,
+        ol li {
+            list-style-position: inside;
+            margin-left: 5px;
+        }
+
+        a {
+            color: #3498db;
+            text-decoration: underline;
+        }
+
+        /* -------------------------------------
+                    BUTTONS
+                    ------------------------------------- */
+        .btn {
+            box-sizing: border-box;
+            width: 100%;
+        }
+
+        .btn>tbody>tr>td {
+            padding-bottom: 15px;
+        }
+
+        .btn table {
+            width: auto;
+        }
+
+        .btn table td {
+            background-color: #ffffff;
+            border-radius: 5px;
+            text-align: center;
+        }
+
+        .btn a {
+            background-color: #ffffff;
+            border: solid 1px #3498db;
+            border-radius: 5px;
+            box-sizing: border-box;
+            color: #3498db;
+            cursor: pointer;
+            display: inline-block;
+            font-size: 14px;
+            font-weight: bold;
+            margin: 0;
+            padding: 12px 25px;
+            text-decoration: none;
+            text-transform: capitalize;
+        }
+
+        .btn-primary table td {
+            background-color: #3498db;
+        }
+
+        .btn-primary a {
+            background-color: #3498db;
+            border-color: #3498db;
+            color: #ffffff;
+        }
+
+        /* -------------------------------------
+                    OTHER STYLES THAT MIGHT BE USEFUL
+                    ------------------------------------- */
+        .last {
+            margin-bottom: 0;
+        }
+
+        .first {
+            margin-top: 0;
+        }
+
+        .align-center {
+            text-align: center;
+        }
+
+        .align-right {
+            text-align: right;
+        }
+
+        .align-left {
+            text-align: left;
+        }
+
+        .clear {
+            clear: both;
+        }
+
+        .mt0 {
+            margin-top: 0;
+        }
+
+        .mb0 {
+            margin-bottom: 0;
+        }
+
+        .preheader {
+            color: transparent;
+            display: none;
+            height: 0;
+            max-height: 0;
+            max-width: 0;
+            opacity: 0;
+            overflow: hidden;
+            visibility: hidden;
+            width: 0;
+        }
+
+        .powered-by a {
+            text-decoration: none;
+        }
+
+        hr {
+            border: 0;
+            border-bottom: 1px solid #f6f6f6;
+            Margin: 20px 0;
+        }
+
+        /* -------------------------------------
+                    RESPONSIVE AND MOBILE FRIENDLY STYLES
+                    ------------------------------------- */
+        @media only screen and (max-width: 620px) {
+            table[class=body] h1 {
+                font-size: 28px !important;
+                margin-bottom: 10px !important;
+            }
+
+            table[class=body] p,
+            table[class=body] ul,
+            table[class=body] ol,
+            table[class=body] td,
+            table[class=body] span,
+            table[class=body] a {
+                font-size: 16px !important;
+            }
+
+            table[class=body] .wrapper,
+            table[class=body] .article {
+                padding: 10px !important;
+            }
+
+            table[class=body] .content {
+                padding: 0 !important;
+            }
+
+            table[class=body] .container {
+                padding: 0 !important;
+                width: 100% !important;
+            }
+
+            table[class=body] .main {
+                border-left-width: 0 !important;
+                border-radius: 0 !important;
+                border-right-width: 0 !important;
+            }
+
+            table[class=body] .btn table {
+                width: 100% !important;
+            }
+
+            table[class=body] .btn a {
+                width: 100% !important;
+            }
+
+            table[class=body] .img-responsive {
+                height: auto !important;
+                max-width: 100% !important;
+                width: auto !important;
+            }
+        }
+
+        /* -------------------------------------
+                    PRESERVE THESE STYLES IN THE HEAD
+                    ------------------------------------- */
+        @media all {
+            .ExternalClass {
+                width: 100%;
+            }
+
+            .ExternalClass,
+            .ExternalClass p,
+            .ExternalClass span,
+            .ExternalClass font,
+            .ExternalClass td,
+            .ExternalClass div {
+                line-height: 100%;
+            }
+
+            .apple-link a {
+                color: inherit !important;
+                font-family: inherit !important;
+                font-size: inherit !important;
+                font-weight: inherit !important;
+                line-height: inherit !important;
+                text-decoration: none !important;
+            }
+
+            .btn-primary table td:hover {
+                background-color: #34495e !important;
+            }
+
+            .btn-primary a:hover {
+                background-color: #34495e !important;
+                border-color: #34495e !important;
+            }
+        }
+
+        ol {
+            padding: 0 0 0 1em;
+        }
+
+        ol li {
+            margin: 1em 0;
+        }
+    </style>
+</head>
+
+<body class="">
+    <table border="0" cellpadding="0" cellspacing="0" class="body">
+        <tr>
+            <td>&nbsp;</td>
+            <td class="container">
+                <div class="content">
+                    <table class="main">
+                        <!-- START MAIN CONTENT AREA -->
+                        <tr>
+                            <td class="wrapper">
+                                <table border="0" cellpadding="0" cellspacing="0">
+                                    <tr>
+                                        <td>
+                                            <p class="mb0"><b>Dear,</b></p>
+                                            <p class="mb0">{{customer_name}}</p>
+                                            <p>{{customer_phone}}</p>
+                                            
+                                            <p class="mb-0">Good News!</p>
+                                            <p>We've successfully processed your refund for:</p>
+
+                                            <p class="mb0">Here are the details of your refund:</p>
+                                            <p class="mb0">Transaction Date: <b>{{booking_date}}</b></p>
+                                            <p class="mb0">Transaction Code: <b>{{invoice_code}}</b></p>
+                                            <p class="mb0">Total Refund: <b>{{refund.refund_total}}</b></p>
+                                            <p>{{{refund_items}}}</p>
+                                            
+                                            <p class="mb0">Transaction Number: <b>{{invoice_code}}</b></p>
+                                            <p class="mb0">Refund Processed Date: <b>{{refund.refund_date}}</b></p>
+                                            <p class="mb0">Bank Account: <b>{{refund.bank_name}}</b></p>
+                                            <p class="mb0">Account Number: <b>{{refund.bank_account_number}}</b></p>
+                                            <p>Account Name: <b>{{refund.bank_account_name}}</b></p>
+
+                                            <p class="mb0">We hope this helps make things right, and we're here to assist if you need anything else</p>
+                                            <p>You should see the refund in your account within 3 business days</p>
+
+
+                                            <p class="mb0">Thank you for your patience and understanding</p>
+                                            <p>If you have any questions or need further assistance, don't hesitate to reach out us at</p>
+                                            <b>{{phone_cs}}</b>
+
+                                            <br>
+
+                                            <p class="mb0">Thank you and we can't wait to see you and make sure you have an amazing time!</p>
+
+                                            <br><br>
+                                            <b>Best Regrads,</b><br>
+                                            <b>WEplayground</b>
+                                        </td>
+                                    </tr>
+                                </table>
+                            </td>
+                        </tr>
+                        <!-- END MAIN CONTENT AREA -->
+                    </table>
+                </div>
+            </td>
+            <td>&nbsp;</td>
+        </tr>
+    </table>
+</body>
+
+</html>

assets/email-template/refund-request.html

@@ -0,0 +1,409 @@
+<!doctype html>
+<html>
+
+<head>
+    <meta name="viewport" content="width=device-width" />
+    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
+    <title>Email Confirmation</title>
+    <style>
+        /* -------------------------------------
+                    GLOBAL RESETS
+                    ------------------------------------- */
+        img {
+            border: none;
+            -ms-interpolation-mode: bicubic;
+            max-width: 100%;
+        }
+
+        body {
+            background-color: #f6f6f6;
+            font-family: sans-serif;
+            -webkit-font-smoothing: antialiased;
+            font-size: 14px;
+            line-height: 1.4;
+            margin: 0;
+            padding: 0;
+            -ms-text-size-adjust: 100%;
+            -webkit-text-size-adjust: 100%;
+        }
+
+        table {
+            border-collapse: separate;
+            mso-table-lspace: 0pt;
+            width: 100%;
+        }
+
+        table td {
+            font-family: sans-serif;
+            font-size: 14px;
+            vertical-align: top;
+        }
+
+        /* -------------------------------------
+                    BODY & CONTAINER
+                    ------------------------------------- */
+
+        .body {
+            background-color: #f6f6f6;
+            width: 100%;
+        }
+
+        /* Set a max-width, and make it display as block so it will automatically stretch to that width, but will also shrink
+                    down on a phone or something */
+        .container {
+            display: block;
+            Margin: 0 auto !important;
+            /* makes it centered */
+            max-width: 580px;
+            padding: 10px;
+            width: 580px;
+        }
+
+        /* This should also be a block element, so that it will fill 100% of the .container */
+        .content {
+            box-sizing: border-box;
+            display: block;
+            Margin: 0 auto;
+            max-width: 580px;
+            padding: 10px;
+        }
+
+        /* -------------------------------------
+                    HEADER, FOOTER, MAIN
+                    ------------------------------------- */
+        .main {
+            background: #ffffff;
+            border-radius: 3px;
+            width: 100%;
+        }
+
+        .wrapper {
+            box-sizing: border-box;
+            padding: 20px;
+        }
+
+        .content-block {
+            padding-bottom: 10px;
+            padding-top: 10px;
+        }
+
+        .footer {
+            clear: both;
+            Margin-top: 10px;
+            text-align: center;
+            width: 100%;
+        }
+
+        .footer td,
+        .footer p,
+        .footer span,
+        .footer a {
+            color: #999999;
+            font-size: 12px;
+            text-align: center;
+        }
+
+        /* -------------------------------------
+                    TYPOGRAPHY
+                    ------------------------------------- */
+        h1,
+        h2,
+        h3,
+        h4 {
+            color: #000000;
+            font-family: sans-serif;
+            font-weight: 400;
+            line-height: 1.4;
+            margin: 0;
+            Margin-bottom: 30px;
+        }
+
+        h1 {
+            font-size: 35px;
+            font-weight: 300;
+            text-align: center;
+            text-transform: capitalize;
+        }
+
+        p,
+        ul,
+        ol {
+            font-family: sans-serif;
+            font-size: 14px;
+            font-weight: normal;
+            margin: 0;
+            Margin-bottom: 15px;
+        }
+
+        p li,
+        ul li,
+        ol li {
+            list-style-position: inside;
+            margin-left: 5px;
+        }
+
+        a {
+            color: #3498db;
+            text-decoration: underline;
+        }
+
+        /* -------------------------------------
+                    BUTTONS
+                    ------------------------------------- */
+        .btn {
+            box-sizing: border-box;
+            width: 100%;
+        }
+
+        .btn>tbody>tr>td {
+            padding-bottom: 15px;
+        }
+
+        .btn table {
+            width: auto;
+        }
+
+        .btn table td {
+            background-color: #ffffff;
+            border-radius: 5px;
+            text-align: center;
+        }
+
+        .btn a {
+            background-color: #ffffff;
+            border: solid 1px #3498db;
+            border-radius: 5px;
+            box-sizing: border-box;
+            color: #3498db;
+            cursor: pointer;
+            display: inline-block;
+            font-size: 14px;
+            font-weight: bold;
+            margin: 0;
+            padding: 12px 25px;
+            text-decoration: none;
+            text-transform: capitalize;
+        }
+
+        .btn-primary table td {
+            background-color: #3498db;
+        }
+
+        .btn-primary a {
+            background-color: #3498db;
+            border-color: #3498db;
+            color: #ffffff;
+        }
+
+        /* -------------------------------------
+                    OTHER STYLES THAT MIGHT BE USEFUL
+                    ------------------------------------- */
+        .last {
+            margin-bottom: 0;
+        }
+
+        .first {
+            margin-top: 0;
+        }
+
+        .align-center {
+            text-align: center;
+        }
+
+        .align-right {
+            text-align: right;
+        }
+
+        .align-left {
+            text-align: left;
+        }
+
+        .clear {
+            clear: both;
+        }
+
+        .mt0 {
+            margin-top: 0;
+        }
+
+        .mb0 {
+            margin-bottom: 0;
+        }
+
+        .preheader {
+            color: transparent;
+            display: none;
+            height: 0;
+            max-height: 0;
+            max-width: 0;
+            opacity: 0;
+            overflow: hidden;
+            visibility: hidden;
+            width: 0;
+        }
+
+        .powered-by a {
+            text-decoration: none;
+        }
+
+        hr {
+            border: 0;
+            border-bottom: 1px solid #f6f6f6;
+            Margin: 20px 0;
+        }
+
+        /* -------------------------------------
+                    RESPONSIVE AND MOBILE FRIENDLY STYLES
+                    ------------------------------------- */
+        @media only screen and (max-width: 620px) {
+            table[class=body] h1 {
+                font-size: 28px !important;
+                margin-bottom: 10px !important;
+            }
+
+            table[class=body] p,
+            table[class=body] ul,
+            table[class=body] ol,
+            table[class=body] td,
+            table[class=body] span,
+            table[class=body] a {
+                font-size: 16px !important;
+            }
+
+            table[class=body] .wrapper,
+            table[class=body] .article {
+                padding: 10px !important;
+            }
+
+            table[class=body] .content {
+                padding: 0 !important;
+            }
+
+            table[class=body] .container {
+                padding: 0 !important;
+                width: 100% !important;
+            }
+
+            table[class=body] .main {
+                border-left-width: 0 !important;
+                border-radius: 0 !important;
+                border-right-width: 0 !important;
+            }
+
+            table[class=body] .btn table {
+                width: 100% !important;
+            }
+
+            table[class=body] .btn a {
+                width: 100% !important;
+            }
+
+            table[class=body] .img-responsive {
+                height: auto !important;
+                max-width: 100% !important;
+                width: auto !important;
+            }
+        }
+
+        /* -------------------------------------
+                    PRESERVE THESE STYLES IN THE HEAD
+                    ------------------------------------- */
+        @media all {
+            .ExternalClass {
+                width: 100%;
+            }
+
+            .ExternalClass,
+            .ExternalClass p,
+            .ExternalClass span,
+            .ExternalClass font,
+            .ExternalClass td,
+            .ExternalClass div {
+                line-height: 100%;
+            }
+
+            .apple-link a {
+                color: inherit !important;
+                font-family: inherit !important;
+                font-size: inherit !important;
+                font-weight: inherit !important;
+                line-height: inherit !important;
+                text-decoration: none !important;
+            }
+
+            .btn-primary table td:hover {
+                background-color: #34495e !important;
+            }
+
+            .btn-primary a:hover {
+                background-color: #34495e !important;
+                border-color: #34495e !important;
+            }
+        }
+
+        ol {
+            padding: 0 0 0 1em;
+        }
+
+        ol li {
+            margin: 1em 0;
+        }
+    </style>
+</head>
+
+<body class="">
+    <table border="0" cellpadding="0" cellspacing="0" class="body">
+        <tr>
+            <td>&nbsp;</td>
+            <td class="container">
+                <div class="content">
+                    <table class="main">
+                        <!-- START MAIN CONTENT AREA -->
+                        <tr>
+                            <td class="wrapper">
+                                <table border="0" cellpadding="0" cellspacing="0">
+                                    <tr>
+                                        <td>
+                                            <p class="mb0"><b>Dear,</b></p>
+                                            <p class="mb0">{{customer_name}}</p>
+                                            <p>{{customer_phone}}</p>
+
+                                            <p class="mb0">We're trully sorry for any inconvenience that led to this request</p>
+                                            <p>We've received your refund request for :</p>
+
+                                            <p class="mb0">Transaction Date: <b>{{booking_date}}</b></p>
+                                            <p class="mb0">Transaction Code: <b>{{invoice_code}}</b></p>
+                                            <p class="mb0">Refund Code: <b>{{refund.code}}</b></p>
+                                            <p class="mb0">Total Refund: <b>{{refund.refund_total}}</b></p>
+                                            <p>{{{refund_items}}}</p>
+                                            
+                                            <p class="mb0">Your satisfaction is important to us, and we're commited to resolving this as quickly as possible</p>
+                                            <p class="mb0">Our team is already on it and will process your refund request promptly</p>
+                                            <p>We'll keep you updated and notify you once the refund has been processed</p>
+
+                                            <p class="mb0">If you have any questions or need assistance, feel free to reach out to our support team at</p>
+                                            <b>{{phone_cs}}</b>
+
+                                            <br>
+                                            
+                                            <p class="mb0">Thank you for your patience and understanding</p>
+                                            <p>We appriciate your feedback and are here to make things right</p>
+
+                                            <br><br>
+                                            <b>Best Regrads,</b><br>
+                                            <b>WEplayground</b>
+                                        </td>
+                                    </tr>
+                                </table>
+                            </td>
+                        </tr>
+                        <!-- END MAIN CONTENT AREA -->
+                    </table>
+                </div>
+            </td>
+            <td>&nbsp;</td>
+        </tr>
+    </table>
+</body>
+
+</html>

env/env.development

@@ -24,8 +24,11 @@ CRON_EVERY_HOUR="0 * * * *"
 
 EMAIL_HOST=smtp.gmail.com
 EMAIL_POST=465
-EMAIL_USER=developer@eigen.co.id
-EMAIL_TOKEN=bitqkbkzjzfywxqx
+EMAIL_USER=weplayground.app@gmail.com
+EMAIL_TOKEN="sonv vwiu khse vtmv"
+
+// nama email yang akan muncul ke user sebagai pengirim
+EMAIL_SENDER=no-reply@eigen.co.id 
 
 MIDTRANS_URL=https://app.sandbox.midtrans.com
 MIDTRANS_PRODUCTION=false
@@ -37,3 +40,10 @@ ASSETS="https://asset.sky.eigen.co.id/"
 
 GOOGLE_CALENDAR_KEY="AIzaSyCSg4P3uC9Z7kD1P4f3rf1BbBaz4Q-M55o"
 GOOGLE_CALENDAR_ID="326464ac296874c7121825f5ef2e2799baa90b51da240f0045aae22beec10bd5@group.calendar.google.com"
+
+SUPERSET_URL=https://dashboard.weplayground.eigen.co.id
+SUPERSET_ADMIN_USERNAME=admin
+SUPERSET_ADMIN_PASSWORD=admin
+
+WHATSAPP_BUSINESS_ACCOUNT_NUMBER_ID=604883366037548
+WHATSAPP_BUSINESS_ACCESS_TOKEN=EAAINOvRRiEEBO9yQsYDnYtjHZB7q1nZCwbBpRcxIGMDWajKZBtmWxNRKvPYkS95KQZBsZBOvSFyjiEg5CcCZBZBtaSZApxyV8fiA3cEyVwf7iVZBQP2YCTPRQZArMFeeXbO0uq5TGygmjsIz3M4YxcUHxPzKO4pKxIyxnzcoUZCqCSo1NqQSLVf3a0JyZAwgDXGL55dV

env/env.production

@@ -25,7 +25,7 @@ CRON_EVERY_HOUR="0 * * * *"
 EMAIL_HOST=smtp.gmail.com
 EMAIL_POST=465
 EMAIL_USER=weplayground.app@gmail.com
-EMAIL_TOKEN=sonvvwiukhsevtmv
+EMAIL_TOKEN="sonv vwiu khse vtmv"
 
 MIDTRANS_URL=https://app.midtrans.com
 MIDTRANS_PRODUCTION=true
@@ -37,3 +37,10 @@ ASSETS="https://asset.sky.eigen.co.id/"
 
 GOOGLE_CALENDAR_KEY="AIzaSyCSg4P3uC9Z7kD1P4f3rf1BbBaz4Q-M55o"
 GOOGLE_CALENDAR_ID="326464ac296874c7121825f5ef2e2799baa90b51da240f0045aae22beec10bd5@group.calendar.google.com"
+
+SUPERSET_URL=https://dashboard.weplayground.eigen.co.id
+SUPERSET_ADMIN_USERNAME=admin
+SUPERSET_ADMIN_PASSWORD=admin
+
+WHATSAPP_BUSINESS_ACCOUNT_NUMBER_ID=604883366037548
+WHATSAPP_BUSINESS_ACCESS_TOKEN=EAAINOvRRiEEBO9yQsYDnYtjHZB7q1nZCwbBpRcxIGMDWajKZBtmWxNRKvPYkS95KQZBsZBOvSFyjiEg5CcCZBZBtaSZApxyV8fiA3cEyVwf7iVZBQP2YCTPRQZArMFeeXbO0uq5TGygmjsIz3M4YxcUHxPzKO4pKxIyxnzcoUZCqCSo1NqQSLVf3a0JyZAwgDXGL55dV

package.json

@@ -28,6 +28,7 @@
   },
   "dependencies": {
     "@faker-js/faker": "^8.4.1",
+    "@nestjs/axios": "^3.0.3",
     "@nestjs/common": "^10.0.0",
     "@nestjs/config": "^3.2.2",
     "@nestjs/core": "^10.0.0",
@@ -39,6 +40,7 @@
     "@nestjs/typeorm": "^10.0.2",
     "@types/multer": "^1.4.11",
     "algebra.js": "^0.2.6",
+    "axios": "^1.7.5",
     "bcrypt": "^5.1.1",
     "class-transformer": "^0.5.1",
     "class-validator": "^0.14.1",
@@ -47,12 +49,14 @@
     "exceljs": "^4.4.0",
     "fs-extra": "^11.2.0",
     "googleapis": "^140.0.0",
+    "gtts": "^0.2.1",
     "handlebars": "^4.7.8",
     "mathjs": "^13.0.2",
     "midtrans-client": "^1.3.1",
     "moment": "^2.30.1",
     "nano": "^10.1.3",
     "nodemailer": "^6.9.14",
+    "pdfmake": "^0.2.10",
     "pg": "^8.11.5",
     "plop": "^4.0.1",
     "reflect-metadata": "^0.2.0",

src/app.module.ts

@@ -44,7 +44,12 @@ import { ItemRateModel } from './modules/item-related/item-rate/data/models/item
 import { GoogleCalendarModule } from './modules/configuration/google-calendar/google-calendar.module';
 import { TransactionModule } from './modules/transaction/transaction/transaction.module';
 import { TransactionModel } from './modules/transaction/transaction/data/models/transaction.model';
-import { TransactionItemModel } from './modules/transaction/transaction/data/models/transaction-item.model';
+import {
+  TransactionBreakdownTaxModel,
+  TransactionItemBreakdownModel,
+  TransactionItemModel,
+  TransactionItemTaxModel,
+} from './modules/transaction/transaction/data/models/transaction-item.model';
 import { TransactionTaxModel } from './modules/transaction/transaction/data/models/transaction-tax.model';
 import { ReconciliationModule } from './modules/transaction/reconciliation/reconciliation.module';
 import { ReportModule } from './modules/reports/report/report.module';
@@ -70,6 +75,24 @@ import { BannerModule } from './modules/web-information/banner/banner.module';
 import { BannerModel } from './modules/web-information/banner/data/models/banner.model';
 import { MailModule } from './modules/configuration/mail/mail.module';
 import { PosLogModel } from './modules/configuration/log/data/models/pos-log.model';
+import { ExportModule } from './modules/configuration/export/export.module';
+import { TransactionDemographyModel } from './modules/transaction/transaction/data/models/transaction-demography.model';
+import { SupersetModule } from './modules/configuration/superset/superset.module';
+import { GateScanModule } from './modules/gates/gate.module';
+import { UserLoginModel } from './modules/user-related/user/data/models/user-login.model';
+import { LogUserLoginModel } from './modules/configuration/log/data/models/log-user-login.model';
+import { AuthService } from './core/guards/domain/services/auth.service';
+import { ReportSummaryModule } from './modules/reports/report-summary/report-summary.module';
+import { QueueModule } from './modules/queue/queue.module';
+import {
+  QueueOrderModel,
+  QueueTicketModel,
+  QueueItemModel,
+  QueueModel,
+} from './modules/queue/data/models/queue.model';
+import { ItemQueueModule } from './modules/item-related/item-queue/item-queue.module';
+import { ItemQueueModel } from './modules/item-related/item-queue/data/models/item-queue.model';
+import { QueueBucketModel } from './modules/queue/data/models/queue-bucket.model';
 
 @Module({
   imports: [
@@ -94,7 +117,9 @@ import { PosLogModel } from './modules/configuration/log/data/models/pos-log.mod
         ItemModel,
         ItemCategoryModel,
         ItemRateModel,
+        ItemQueueModel,
         LogModel,
+        LogUserLoginModel,
         NewsModel,
         PaymentMethodModel,
         PosLogModel,
@@ -108,13 +133,26 @@ import { PosLogModel } from './modules/configuration/log/data/models/pos-log.mod
         TransactionModel,
         TransactionItemModel,
         TransactionTaxModel,
+        TransactionDemographyModel,
+        TransactionItemBreakdownModel,
+        TransactionItemTaxModel,
+        TransactionBreakdownTaxModel,
         UserModel,
+        UserLoginModel,
+
         VipCategoryModel,
         VipCodeModel,
 
         // report
         ReportBookmarkModel,
         ExportReportHistoryModel,
+
+        // Queue
+        QueueOrderModel,
+        QueueTicketModel,
+        QueueItemModel,
+        QueueModel,
+        QueueBucketModel,
       ],
       synchronize: false,
     }),
@@ -123,6 +161,7 @@ import { PosLogModel } from './modules/configuration/log/data/models/pos-log.mod
     CqrsModule,
     CouchModule,
     CronModule,
+    ExportModule,
     GoogleCalendarModule,
     LogModule,
     MailModule,
@@ -139,6 +178,7 @@ import { PosLogModel } from './modules/configuration/log/data/models/pos-log.mod
     ItemCategoryModule,
     ItemModule,
     ItemRateModule,
+    ItemQueueModule,
 
     // transaction
     PaymentMethodModule,
@@ -166,9 +206,18 @@ import { PosLogModel } from './modules/configuration/log/data/models/pos-log.mod
     ReportModule,
     ReportBookmarkModule,
     ReportExportModule,
+    ReportSummaryModule,
+
+    // superset
+    SupersetModule,
+
+    GateScanModule,
+
+    QueueModule,
   ],
   controllers: [],
   providers: [
+    AuthService,
     PrivilegeService,
     /**
      * By default all request from client will protect by JWT

src/core/guards/domain/jwt.guard.ts

@@ -7,10 +7,10 @@ import {
   UnauthorizedException,
 } from '@nestjs/common';
 import { Reflector } from '@nestjs/core';
-import { Observable } from 'rxjs';
 import { SessionService, UsersSession } from 'src/core/sessions';
 import { UNPROTECTED_URL } from '../constants';
 import { PrivilegeService } from './services/privilege.service';
+import { AuthService } from './services/auth.service';
 
 @Injectable({ scope: Scope.REQUEST })
 export class JWTGuard implements CanActivate {
@@ -18,14 +18,13 @@ export class JWTGuard implements CanActivate {
     protected readonly session: SessionService,
     protected readonly reflector: Reflector,
     protected readonly privilege: PrivilegeService,
+    protected readonly authService: AuthService,
   ) {}
 
   protected isPublic = false;
   protected userSession: UsersSession;
 
-  canActivate(
-    context: ExecutionContext,
-  ): boolean | Promise<boolean> | Observable<boolean> {
+  async canActivate(context: ExecutionContext) {
     /**
      * Check if access url is protected or not
      * By default `isUnprotected` equals `false`
@@ -61,9 +60,29 @@ export class JWTGuard implements CanActivate {
      */
     try {
       this.userSession = this.session.verifyToken(token);
+      await this.authService.verifyRegisteredLoginToken(token);
+
       Logger.log(`Access from ${this.userSession.name}`, 'AuthGuard');
       return true;
     } catch (error) {
+      const expiredError = error.message;
+      if (expiredError === 'jwt expired') {
+        const [, body] = token.split('.');
+        const bodyToken = JSON.parse(atob(body));
+
+        const user = {
+          role: bodyToken.role,
+          user_id: bodyToken.id,
+          username: bodyToken.username,
+          user_privilege_id: bodyToken.user_privilege_id,
+          item_id: bodyToken.item_id,
+          item_name: bodyToken.item_name,
+          source: bodyToken.source,
+        };
+
+        this.authService.logoutUser(user, token);
+      }
+
       throw new UnauthorizedException({
         code: 10001,
         message:

src/core/guards/domain/roles.guard.ts

@@ -9,7 +9,7 @@ import { MAIN_MENU } from '../constants';
 @Injectable()
 export class RolesGuard extends JWTGuard {
   async canActivate(context: ExecutionContext): Promise<boolean> {
-    super.canActivate(context);
+    await super.canActivate(context);
 
     // jika endpoint tersebut bukan public, maka lakukan check lanjutan
     if (!this.isPublic) {
@@ -25,7 +25,7 @@ export class RolesGuard extends JWTGuard {
       if (isNotAllow) {
         throw new ForbiddenException({
           statusCode: 10003,
-          message: `Forbidden Access, you don't have access to this module!`,
+          message: `Akses Terlarang, anda tidak punya akses ke module ini!`,
           error: 'ACCESS_FORBIDDEN',
         });
       }

src/core/guards/domain/services/auth.service.ts

@@ -0,0 +1,78 @@
+import {
+  HttpStatus,
+  Injectable,
+  Scope,
+  UnauthorizedException,
+} from '@nestjs/common';
+import { InjectDataSource } from '@nestjs/typeorm';
+import {
+  CONNECTION_NAME,
+  OPERATION,
+} from 'src/core/strings/constants/base.constants';
+import { DataSource } from 'typeorm';
+import { UserRole } from 'src/modules/user-related/user/constants';
+import { UserModel } from 'src/modules/user-related/user/data/models/user.model';
+import { AppSource, LogUserType } from 'src/core/helpers/constant';
+import { EventBus } from '@nestjs/cqrs';
+import { LogUserLoginEvent } from 'src/modules/configuration/log/domain/entities/log-user-login.event';
+import { UserLoginModel } from 'src/modules/user-related/user/data/models/user-login.model';
+
+interface UserEntity {
+  user_id: string;
+  username: string;
+  role: UserRole;
+  user_privilege_id: string;
+  item_id: string;
+  item_name: string;
+  source: AppSource;
+}
+
+@Injectable({ scope: Scope.REQUEST })
+export class AuthService {
+  constructor(
+    @InjectDataSource(CONNECTION_NAME.DEFAULT)
+    protected readonly dataSource: DataSource,
+
+    private eventBus: EventBus,
+  ) {}
+
+  get repository() {
+    return this.dataSource.getRepository(UserLoginModel);
+  }
+
+  async logoutUser(user: UserEntity, token: string) {
+    await this.repository.delete({ login_token: token });
+
+    const userLogout = {
+      type: LogUserType.logout,
+      created_at: new Date().getTime(),
+      name: user.username,
+      user_privilege_id: user.user_privilege_id,
+      ...user,
+    };
+
+    this.eventBus.publish(
+      new LogUserLoginEvent({
+        id: user.user_id,
+        old: null,
+        data: userLogout,
+        user: userLogout as any,
+        description: 'Logout',
+        module: UserModel.name,
+        op: OPERATION.UPDATE,
+      }),
+    );
+  }
+
+  async verifyRegisteredLoginToken(token: string) {
+    const data = await this.repository.findOneBy({ login_token: token });
+
+    if (!data) {
+      throw new UnauthorizedException({
+        statusCode: HttpStatus.UNAUTHORIZED,
+        message: `Invalid token`,
+        error: 'Unauthorized',
+      });
+    }
+  }
+}

src/core/guards/domain/services/privilege.service.ts

@@ -52,7 +52,7 @@ export class PrivilegeService {
     if (!moduleKey) {
       throw new ForbiddenException({
         statusCode: 10005,
-        message: `Forbidden Access, access Module is Require!`,
+        message: `Akses Terlarang, anda tidak punya akses ke module ini!`,
         error: 'MODULE_KEY_NOT_FOUND',
       });
     }

src/core/helpers/constant/index.ts

@@ -0,0 +1,11 @@
+export enum LogUserType {
+  login = 'login',
+  logout = 'logout',
+}
+
+export enum AppSource {
+  POS_ADMIN = 'POS_ADMIN',
+  POS_COUNTER = 'POS_COUNTER',
+  QUEUE_ADMIN = 'QUEUE_ADMIN',
+  QUEUE_CUSTOMER = 'QUEUE_CUSTOMER',
+}

src/core/helpers/path/upload-store-path.helper.ts

@@ -8,7 +8,9 @@ import { diskStorage } from 'multer';
 const MB = 1024 * 1024;
 
 const fileFilter = (req, file, callback) => {
-  if (file.mimetype.match(/\/(jpg|jpeg|png)$/)) {
+  if (
+    file.mimetype.match(/\/(jpg|jpeg|png|flv|mp4|m3u8|ts|3gp|mov|avi|wmv)$/)
+  ) {
     callback(null, true);
   } else {
     callback(

src/core/helpers/query/check-duplicate.helpers.ts

@@ -43,9 +43,9 @@ export class CheckDuplicateHelper {
       if (data_exists > 0) {
         throw new UnprocessableEntityException({
           statusCode: HttpStatus.UNPROCESSABLE_ENTITY,
-          message: `Entity with ${columnCheck.column} : ${
+          message: `Gagal! Data dengan ${columnCheck.column} : ${
             this.entity[columnCheck.column]
-          } already exist`,
+          } telah ada`,
           error: 'Unprocessable Entity',
         });
       }

src/core/helpers/query/specific-search.helper.ts

@@ -20,12 +20,16 @@ export class SpecificSearchFilter<Entity = any> {
       new Brackets((qb) => {
         params.forEach((param) => {
           const { cols, data, additional, leftJoin } = param;
+          const columns = cols.split('.');
+          let arr = data;
 
-          const arr = data?.map((el) =>
+          if (!columns.includes('status::text')) {
+            arr = data?.map((el) =>
               el.includes("'")
                 ? `'%${el.trim().replace(/'/g, "''").replace(/\s+/g, ' ')}%'`
                 : `'%${el.trim().replace(/\s+/g, ' ')}%'`,
             );
+          }
 
           const aliases = !cols.match(/\./g)
             ? this.table.concat(`.${cols}`)

src/core/modules/data/service/base-data.service.ts

@@ -17,8 +17,8 @@ export abstract class BaseDataService<Entity> {
     entityTarget: EntityTarget<Entity>,
     entity: Entity,
   ): Promise<Entity> {
-    const newEntity = queryRunner.manager.create(entityTarget, entity);
-    return await queryRunner.manager.save(newEntity);
+    // const newEntity = this.repository.create(entityTarget, entity);
+    return await this.repository.save(entity);
   }
 
   async createMany(
@@ -26,8 +26,8 @@ export abstract class BaseDataService<Entity> {
     entityTarget: EntityTarget<Entity>,
     entity: Entity[],
   ): Promise<Entity[]> {
-    const newEntity = queryRunner.manager.create(entityTarget, entity);
-    return await queryRunner.manager.save(newEntity);
+    // const newEntity = this.repository.create(entityTarget, entity);
+    return await this.repository.save(entity);
   }
 
   async createBatch(
@@ -35,8 +35,8 @@ export abstract class BaseDataService<Entity> {
     entityTarget: EntityTarget<Entity>,
     entity: Entity[],
   ): Promise<Entity[]> {
-    const newEntity = queryRunner.manager.create(entityTarget, entity);
-    return await queryRunner.manager.save(newEntity);
+    // const newEntity = this.repository.create(entityTarget, entity);
+    return await this.repository.save(entity);
   }
 
   async update(
@@ -45,13 +45,13 @@ export abstract class BaseDataService<Entity> {
     filterUpdate: any,
     entity: Entity,
   ): Promise<Entity> {
-    const newEntity = await queryRunner.manager.findOne(entityTarget, {
+    const newEntity = await this.repository.findOne({
       where: filterUpdate,
     });
 
     if (!newEntity) throw new Error('Data not found!');
     Object.assign(newEntity, entity);
-    return await queryRunner.manager.save(newEntity);
+    return await this.repository.save(newEntity);
   }
 
   async deleteById(
@@ -59,7 +59,15 @@ export abstract class BaseDataService<Entity> {
     entityTarget: EntityTarget<Entity>,
     id: string,
   ): Promise<void> {
-    await queryRunner.manager.delete(entityTarget, { id });
+    await this.repository.delete(id);
+  }
+
+  async deleteByIds(
+    queryRunner: QueryRunner,
+    entityTarget: EntityTarget<Entity>,
+    ids: string[],
+  ): Promise<void> {
+    await this.repository.delete(ids);
   }
 
   async deleteByOptions(
@@ -67,11 +75,8 @@ export abstract class BaseDataService<Entity> {
     entityTarget: EntityTarget<Entity>,
     findManyOptions: FindManyOptions<Entity>,
   ): Promise<void> {
-    const datas = await queryRunner.manager.find(entityTarget, findManyOptions);
-    await queryRunner.manager.delete(
-      entityTarget,
-      datas?.map((item) => item['id']),
-    );
+    const datas = await this.repository.find(findManyOptions);
+    await this.repository.delete(datas?.map((item) => item['id']));
   }
 
   async getOneByOptions(findOneOptions): Promise<Entity> {

src/core/modules/domain/entities/base-core.entity.ts

@@ -1,3 +1,3 @@
 export interface BaseCoreEntity {
-  id: string;
+  id?: string;
 }

src/core/modules/domain/entities/base-filter.entity.ts

@@ -22,6 +22,7 @@ export interface Param {
   data: string[];
   additional?: any[];
   leftJoin?: any[];
+  isStatus?: boolean;
 }
 
 export interface RelationParam {

src/core/modules/domain/usecase/base.manager.ts

@@ -32,7 +32,7 @@ export abstract class BaseManager {
 
   setUser() {
     try {
-      this.user = this.userProvider?.user;
+      this.user = this.userProvider?.user ?? BLANK_USER;
     } catch (error) {
       this.user = BLANK_USER;
     }
@@ -60,7 +60,7 @@ export abstract class BaseManager {
     try {
       this.setUser();
 
-      // this.queryRunner.startTransaction();
+      this.queryRunner.startTransaction();
       this.baseLog.verbose('prepareData');
       await this.prepareData();
 
@@ -80,13 +80,13 @@ export abstract class BaseManager {
       this.baseLog.verbose('afterProcess');
       await this.afterProcess();
 
-      // this.baseLog.verbose('commitTransaction');
-      // await this.queryRunner.commitTransaction();
-
-      // await this.queryRunner.release();
+      this.baseLog.verbose('commitTransaction');
+      await this.queryRunner.commitTransaction();
     } catch (e) {
       if (e.response) throw new Error(JSON.stringify(e.response));
       else throw new Error(e.message);
+    } finally {
+      await this.queryRunner.release();
     }
   }
 

src/core/modules/domain/usecase/managers/base-batch-delete.manager.ts

@@ -38,7 +38,7 @@ export abstract class BaseBatchDeleteManager<Entity> extends BaseManager {
         if (!entity) {
           throw new NotFoundException({
             statusCode: HttpStatus.NOT_FOUND,
-            message: `Failed! Entity with id ${id} not found`,
+            message: `Gagal! data dengan id ${id} tidak ditemukan`,
             error: 'Entity Not Found',
           });
         }

src/core/modules/domain/usecase/managers/base-batch-update-status.manager.ts

@@ -15,6 +15,26 @@ export abstract class BaseBatchUpdateStatusManager<Entity> extends BaseManager {
   abstract get entityTarget(): any;
 
   setData(ids: string[], status: STATUS): void {
+    /**
+     * // TODO: Handle case confirm multiple tabs;
+     * Pola ids yang dikirim dirubah menjadi data_id___updated_at
+     * Untuk mendapatkan value id nya saja dan menghindari breaking change
+     * karena sudah digunakan sebelumnya lakukan split dari data ids yang dikirim
+     * Example:
+     * this.dataIds = ids.map((i)=> {
+     *    return i.split('___')[0]
+     * })
+     *
+     * Simpan data ids yang mempunyai update_at kedalam valiable baru
+     * Example:
+     * this.dataIdsWithDate = ids.map((i)=> {
+     *  return {
+     *      id: i.split('___')[0],
+     *      updated_at: i.split('___')[1]
+     *  }
+     * })
+     */
+
     this.dataIds = ids;
     this.dataStatus = status;
   }
@@ -32,8 +52,21 @@ export abstract class BaseBatchUpdateStatusManager<Entity> extends BaseManager {
     let totalSuccess = 0;
     const messages = [];
 
+    /**
+     * // TODO: Handle case confirm multiple tabs;
+     * Lopping data diambil dari dataIdsWithDate
+     * exp:  for (const item of this.dataIdsWithDate)
+     */
+
     for (const id of this.dataIds) {
       try {
+        /**
+         * // TODO: Handle case confirm multiple tabs;
+         * buat variable:
+         * const id = item.id
+         * const updated_at = item.updated_at
+         */
+
         const entity = await this.dataService.getOneByOptions({
           where: {
             id: id,
@@ -44,19 +77,19 @@ export abstract class BaseBatchUpdateStatusManager<Entity> extends BaseManager {
         if (!entity) {
           throw new NotFoundException({
             statusCode: HttpStatus.NOT_FOUND,
-            message: `Failed! Entity with id ${id} not found`,
+            message: `Gagal! data dengan id ${id} tidak ditemukan`,
             error: 'Entity Not Found',
           });
         }
         this.oldData = _.cloneDeep(entity);
+        await this.validateData(entity);
+
         Object.assign(entity, {
           status: this.dataStatus,
           editor_id: this.user.id,
           editor_name: this.user.name,
           updated_at: new Date().getTime(),
         });
-
-        await this.validateData(entity);
         await new ValidateRelationHelper(
           id,
           this.dataService,
@@ -64,6 +97,14 @@ export abstract class BaseBatchUpdateStatusManager<Entity> extends BaseManager {
           this.tableName,
         ).execute();
 
+        /**
+         * // TODO: Handle case confirm multiple tabs;
+         * lakukan update data dengan where condition id dan updated_at
+         * EXPECTATION => status akan berubah jika updated_at yang dikirim dari FE sama dengen yang di database
+         * IF => updated_at beda tidak perlu melakukan update status dan tidak perlu memanggil eventBus tetapi tetap dihitung sebagai aksi yang berhasil
+         * IF => FE tidak menambahkan updated_at makan lakukan update dan publishEvent
+         */
+
         const result = await this.dataService.update(
           this.queryRunner,
           this.entityTarget,

src/core/modules/domain/usecase/managers/base-change-position.manager.ts

@@ -29,7 +29,7 @@ export abstract class BaseChangePosition<Entity> extends BaseManager {
     if (!this.data?.end || this.data.start == this.data?.end) {
       throw new UnprocessableEntityException({
         statusCode: HttpStatus.UNPROCESSABLE_ENTITY,
-        message: 'Please drag to another position',
+        message: 'Gagal! tolong pindahkan ke posisi lain',
         error: 'Unprocessable Entity',
       });
     }
@@ -43,7 +43,7 @@ export abstract class BaseChangePosition<Entity> extends BaseManager {
     if (!this.startData) {
       throw new UnprocessableEntityException({
         statusCode: HttpStatus.UNPROCESSABLE_ENTITY,
-        message: `Entity with id : ${this.data.start} not found`,
+        message: `Gagal! data dengan id : ${this.data.start} tidak ditemukan`,
         error: 'Unprocessable Entity',
       });
     }
@@ -57,7 +57,7 @@ export abstract class BaseChangePosition<Entity> extends BaseManager {
     if (!this.endData) {
       throw new UnprocessableEntityException({
         statusCode: HttpStatus.UNPROCESSABLE_ENTITY,
-        message: `Entity with id : ${this.data.end} not found`,
+        message: `Gagal! data dengan id : ${this.data.end} tidak ditemukan`,
         error: 'Unprocessable Entity',
       });
     }

src/core/modules/domain/usecase/managers/base-create.manager.ts

@@ -71,7 +71,7 @@ export abstract class BaseCreateManager<Entity> extends BaseManager {
   }
 
   async publishEvents() {
-    this.eventBus.publish(
+    this.eventBus?.publish(
       new RecordLog({
         id: this.result['id'],
         old: null,
@@ -97,7 +97,7 @@ export abstract class BaseCreateManager<Entity> extends BaseManager {
 
       this.eventBus.publishAll([
         new topic.topic({
-          id: data?.['id'] ?? topic?.data?.['id'],
+          id: this.result['id'],
           old: null,
           data: data ?? topic.data,
           user: this.user,

src/core/modules/domain/usecase/managers/base-delete.manager.ts

@@ -23,7 +23,7 @@ export abstract class BaseDeleteManager<Entity> extends BaseManager {
     if (!this.data)
       throw new UnprocessableEntityException({
         statusCode: HttpStatus.UNPROCESSABLE_ENTITY,
-        message: `Data with id ${this.dataId} not found`,
+        message: `Gagal! Data denga id ${this.dataId} tidak ditemukan`,
         error: 'Unprocessable Entity',
       });
 

src/core/modules/domain/usecase/managers/base-index.manager.ts

@@ -50,13 +50,17 @@ export abstract class BaseIndexManager<Entity> extends BaseReadManager {
 
         // jika searching status terdapat dalam enum, maka dia mencari specific data
         // ? karena jika tidak, ketika dia search "active" maka "inactive" juga ikut
-        return STATUS[statusData.toUpperCase()] ?? statusData;
+        return `'${STATUS[statusData.toUpperCase()]}'`;
       });
+
+      const exist = specificFilter.find((item) => item.isStatus);
+      if (!exist) {
         specificFilter.push({
           cols: `${this.tableName}.status::text`,
           data: data,
         });
       }
+    }
 
     new SpecificSearchFilter<Entity>(
       this.queryBuilder,

src/core/modules/domain/usecase/managers/base-update-status.manager.ts

@@ -1,6 +1,10 @@
 import { ValidateRelationHelper } from 'src/core/helpers/validation/validate-relation.helper';
 import { BaseManager } from '../base.manager';
-import { OPERATION, STATUS } from 'src/core/strings/constants/base.constants';
+import {
+  OPERATION,
+  QUEUE_STATUS,
+  STATUS,
+} from 'src/core/strings/constants/base.constants';
 import * as _ from 'lodash';
 import { RecordLog } from 'src/modules/configuration/log/domain/entities/log.event';
 
@@ -8,12 +12,28 @@ export abstract class BaseUpdateStatusManager<Entity> extends BaseManager {
   protected dataId: string;
   protected result: Entity;
   protected oldData: Entity;
-  protected dataStatus: STATUS;
+  protected dataStatus: STATUS | QUEUE_STATUS;
   protected relations = [];
   protected duplicateColumn: string[];
   abstract get entityTarget(): any;
 
-  setData(id: string, status: STATUS): void {
+  setData(id: string, status: STATUS | QUEUE_STATUS): void {
+    /**
+     * // TODO: Handle case confirm multiple tabs;
+     * Pola id yang dikirim dirubah menjadi data_id___updated_at
+     * Untuk mendapatkan value id nya saja dan menghindari breaking change
+     * karena sudah digunakan sebelumnya lakukan split dari data ids yang dikirim
+     * Example:
+     * this.dataId = id.split('___')[0]
+     *
+     * Simpan data id yang mempunyai update_at kedalam valiable baru
+     * Example:
+     * this.dataIdsWithDate = {
+     *      id: id.split('___')[0],
+     *      updated_at: id.split('___')[1]
+     *  }
+     */
+
     this.dataId = id;
     this.dataStatus = status;
   }
@@ -43,6 +63,16 @@ export abstract class BaseUpdateStatusManager<Entity> extends BaseManager {
       this.tableName,
     ).execute();
 
+    /**
+     * // TODO: Handle case confirm multiple tabs;
+     * IF =>  updated_at sama dengen data yang di database
+     * THEN =>
+     *        - Lakukan update data dengan where condition id dan updated_at
+     *        - EXPECTATION = > status akan berubah jika updated_at yang dikirim dari FE sama dengen yang di database
+     * IF => updated_at beda maka retun curent data tanpa harus malakukan update status dan publish event
+     * IF => FE tidak menambahkan updated_at makan lakukan update dan publishEvent
+     */
+
     this.result = await this.dataService.update(
       this.queryRunner,
       this.entityTarget,

src/core/modules/domain/usecase/managers/base-update.manager.ts

@@ -27,7 +27,7 @@ export abstract class BaseUpdateManager<Entity> extends BaseManager {
     if (!this.oldData) {
       throw new NotFoundException({
         statusCode: HttpStatus.NOT_FOUND,
-        message: `Failed! Entity with id ${this.dataId} not found`,
+        message: `Gagal! Data denga id ${this.dataId} tidak ditemukan`,
         error: 'Entity Not Found',
       });
     }

src/core/modules/infrastructure/dto/base-filter.dto.ts

@@ -23,6 +23,7 @@ export class BaseFilterDto implements BaseFilterEntity {
   @IsNumber()
   limit = 10;
 
+  @ApiProperty({ type: String, required: false })
   q: string;
 
   @ApiProperty({ type: ['string'], required: false })

src/core/response/constants.ts

@@ -1 +1,2 @@
 export const PAGINATION_RESPONSE = 'PAGINATION_RESPONSE';
+export const GATE_RESPONSE = 'GATE_RESPONSE';

src/core/response/domain/decorators/pagination.response.ts

@@ -1,5 +1,5 @@
 import { SetMetadata } from '@nestjs/common';
-import { PAGINATION_RESPONSE } from '../../constants';
+import { GATE_RESPONSE, PAGINATION_RESPONSE } from '../../constants';
 
 /**
  * This decorator will tell the response,
@@ -7,3 +7,5 @@ import { PAGINATION_RESPONSE } from '../../constants';
  */
 export const Pagination = (isPagination = true) =>
   SetMetadata(PAGINATION_RESPONSE, isPagination);
+
+export const Gate = () => SetMetadata(GATE_RESPONSE, true);

src/core/response/domain/response.interceptor.ts

@@ -8,13 +8,20 @@ import { Observable } from 'rxjs';
 import { map } from 'rxjs/operators';
 import { Request } from 'express';
 import { Reflector } from '@nestjs/core';
-import { PAGINATION_RESPONSE } from '../constants';
+import { GATE_RESPONSE, PAGINATION_RESPONSE } from '../constants';
 import { createPaginationResponse } from './utils/pagination-meta.helper';
 
 @Injectable()
 export class TransformInterceptor implements NestInterceptor {
   constructor(protected readonly reflector: Reflector) {}
   intercept(context: ExecutionContext, next: CallHandler): Observable<any> {
+    const isGate = this.reflector.getAllAndOverride<boolean>(GATE_RESPONSE, [
+      context.getHandler(),
+      context.getClass(),
+    ]);
+
+    if (isGate) return next.handle();
+
     const isPagination = this.reflector.getAllAndOverride<boolean>(
       PAGINATION_RESPONSE,
       [context.getHandler(), context.getClass()],

src/core/sessions/domain/entities/user-sessions.interface.ts

@@ -1,8 +1,11 @@
+import { AppSource } from 'src/core/helpers/constant';
 import { UserRole } from 'src/modules/user-related/user/constants';
 
 export interface UsersSession {
   id: number;
   name: string;
   role: UserRole;
+  source?: AppSource;
+  item_id?: string;
   user_privilege_id: string;
 }

src/core/sessions/domain/providers/user.ts

@@ -23,4 +23,9 @@ export class UserProvider {
     const [, token] = this.request.headers['authorization'].split(' ');
     return this.session.verifyToken(token);
   }
+
+  get token(): string {
+    const [, token] = this.request.headers['authorization'].split(' ');
+    return token;
+  }
 }

src/core/strings/constants/base.constants.ts

@@ -15,11 +15,26 @@ export enum STATUS {
   WAITING = 'waiting',
 }
 
+export enum QUEUE_STATUS {
+  DONE = 'done',
+  CALLED = 'called',
+}
+
 export enum ORDER_TYPE {
   ASC = 'ASC',
   DESC = 'DESC',
 }
 
+export const DAY = [
+  'minggu',
+  'senin',
+  'selasa',
+  'rabu',
+  'kamis',
+  'jumat',
+  'sabtu',
+];
+
 export enum CONNECTION_NAME {
   DEFAULT = 'default',
 }

src/core/strings/constants/module.constants.ts

@@ -4,6 +4,7 @@ export enum MODULE_NAME {
   GATE = 'gates',
   ITEM = 'items',
   ITEM_CATEGORY = 'item-categories',
+  ITEM_QUEUE = 'item-queues',
   ITEM_RATE = 'item-rates',
   NEWS = 'news',
   PAYMENT_METHOD = 'payment-methods',
@@ -24,4 +25,7 @@ export enum MODULE_NAME {
   REPORT = 'report',
   REPORT_BOOKMARK = 'report-bookmark',
   REPORT_EXPORT = 'report-export',
+  REPORT_SUMMARY = 'report-summary',
+
+  QUEUE = 'queue',
 }

src/core/strings/constants/privilege.constants.ts

@@ -51,7 +51,6 @@ export const PrivilegeAdminConstant = [
     menu_label: 'Rekonsiliasi',
     actions: [
       PrivilegeAction.VIEW,
-      PrivilegeAction.CREATE,
       PrivilegeAction.CONFIRM,
       PrivilegeAction.DELETE,
       PrivilegeAction.CANCEL,
@@ -137,6 +136,12 @@ export const PrivilegeAdminConstant = [
     actions: [PrivilegeAction.CREATE],
     index: 13,
   },
+  {
+    menu: 'DOWNLOAD_POS_APP',
+    menu_label: 'Download POS App',
+    actions: [PrivilegeAction.VIEW],
+    index: 20,
+  },
 ];
 
 export const PrivilegePOSConstant = [
@@ -146,8 +151,8 @@ export const PrivilegePOSConstant = [
     actions: [
       PrivilegeAction.VIEW,
       PrivilegeAction.CREATE,
-      PrivilegeAction.DELETE,
       PrivilegeAction.EDIT,
+      PrivilegeAction.CANCEL,
     ],
     index: 14,
   },
@@ -160,7 +165,7 @@ export const PrivilegePOSConstant = [
   {
     menu: 'BOOKING',
     menu_label: 'Pemesanan',
-    actions: [PrivilegeAction.VIEW, PrivilegeAction.CREATE],
+    actions: [PrivilegeAction.VIEW],
     index: 16,
   },
   {
@@ -175,4 +180,10 @@ export const PrivilegePOSConstant = [
     actions: [PrivilegeAction.CREATE],
     index: 18,
   },
+  {
+    menu: 'PRINT_RECEIPT',
+    menu_label: 'Print Receipt',
+    actions: [PrivilegeAction.CREATE],
+    index: 19,
+  },
 ];

src/core/strings/constants/table.constants.ts

@@ -4,6 +4,7 @@ export enum TABLE_NAME {
   FAQ = 'faqs',
   ITEM = 'items',
   ITEM_CATEGORY = 'item_categories',
+  ITEM_QUEUE = 'item_queues',
   ITEM_RATE = 'item_rates',
   GATE = 'gates',
   LOG = 'logs',
@@ -20,8 +21,14 @@ export enum TABLE_NAME {
   TENANT = 'tenants',
   TRANSACTION = 'transactions',
   TRANSACTION_ITEM = 'transaction_items',
+  TRANSACTION_ITEM_BREAKDOWN = 'transaction_item_breakdowns',
   TRANSACTION_TAX = 'transaction_taxes',
+  TRANSACTION_ITEM_TAX = 'transaction_item_taxes',
+  TRANSACTION_ITEM_BREAKDOWN_TAX = 't_breakdown_item_taxes',
+  TRANSACTION_DEMOGRAPHY = 'transaction_demographies',
   USER = 'users',
+  USER_LOGIN = 'users_login',
+  LOG_USER_LOGIN = 'log_users_login',
   USER_PRIVILEGE = 'user_privileges',
   USER_PRIVILEGE_CONFIGURATION = 'user_privilege_configurations',
   VIP_CATEGORY = 'vip_categories',
@@ -29,4 +36,10 @@ export enum TABLE_NAME {
 
   REPORT_BOOKMARK = 'report_bookmark',
   EXPORT_REPORT_HISTORY = 'export_report_history',
+
+  QUEUE = 'queues',
+  QUEUE_ORDER = 'queue_orders',
+  QUEUE_TICKET = 'queue_tickets',
+  QUEUE_ITEM = 'queue_items',
+  QUEUE_BUCKET = 'queue_bucket',
 }

src/database/migrations/1722318939681-add-column-to-refund-table.ts

@@ -0,0 +1,27 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddColumnToRefundTable1722318939681 implements MigrationInterface {
+  name = 'AddColumnToRefundTable1722318939681';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `CREATE TYPE "public"."refunds_refund_reason_type_enum" AS ENUM('weather', 'ride malfunction', 'other')`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "refunds" ADD "refund_reason_type" "public"."refunds_refund_reason_type_enum" NOT NULL DEFAULT 'ride malfunction'`,
+    );
+    await queryRunner.query(`ALTER TABLE "refunds" ADD "refund_reason" text`);
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "refunds" DROP COLUMN "refund_reason"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "refunds" DROP COLUMN "refund_reason_type"`,
+    );
+    await queryRunner.query(
+      `DROP TYPE "public"."refunds_refund_reason_type_enum"`,
+    );
+  }
+}

src/database/migrations/1722334034920-update-column-to-transaction-table.ts

@@ -0,0 +1,25 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class UpdateColumnToTransactionTable1722334034920
+  implements MigrationInterface
+{
+  name = 'UpdateColumnToTransactionTable1722334034920';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "transaction_items" ADD "qr_image_url" character varying`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transactions" ADD "payment_code" character varying`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "transactions" DROP COLUMN "payment_code"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_items" DROP COLUMN "qr_image_url"`,
+    );
+  }
+}

src/database/migrations/1722509262047-pos_log_add_column_down_by.ts

@@ -0,0 +1,21 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class PosLogAddColumnDownBy1722509262047 implements MigrationInterface {
+  name = 'PosLogAddColumnDownBy1722509262047';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "logs_pos" ADD "drawn_by_name" character varying`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "logs_pos" ADD "drawn_by_id" character varying`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(`ALTER TABLE "logs_pos" DROP COLUMN "drawn_by_id"`);
+    await queryRunner.query(
+      `ALTER TABLE "logs_pos" DROP COLUMN "drawn_by_name"`,
+    );
+  }
+}

src/database/migrations/1722581313837-update-relation-table-transaction.ts

@@ -0,0 +1,49 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class UpdateRelationTableTransaction1722581313837
+  implements MigrationInterface
+{
+  name = 'UpdateRelationTableTransaction1722581313837';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "refunds" DROP CONSTRAINT "FK_8bb3b7579f49990d2e77684acd4"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "refunds" DROP CONSTRAINT "REL_8bb3b7579f49990d2e77684acd"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "refund_items" DROP CONSTRAINT "FK_07b481a163c219f5de8fb1c90b3"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "refund_items" DROP CONSTRAINT "REL_07b481a163c219f5de8fb1c90b"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "refunds" ADD CONSTRAINT "FK_8bb3b7579f49990d2e77684acd4" FOREIGN KEY ("transaction_id") REFERENCES "transactions"("id") ON DELETE CASCADE ON UPDATE CASCADE`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "refund_items" ADD CONSTRAINT "FK_07b481a163c219f5de8fb1c90b3" FOREIGN KEY ("transaction_item_id") REFERENCES "transaction_items"("id") ON DELETE CASCADE ON UPDATE CASCADE`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "refund_items" DROP CONSTRAINT "FK_07b481a163c219f5de8fb1c90b3"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "refunds" DROP CONSTRAINT "FK_8bb3b7579f49990d2e77684acd4"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "refund_items" ADD CONSTRAINT "REL_07b481a163c219f5de8fb1c90b" UNIQUE ("transaction_item_id")`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "refund_items" ADD CONSTRAINT "FK_07b481a163c219f5de8fb1c90b3" FOREIGN KEY ("transaction_item_id") REFERENCES "transaction_items"("id") ON DELETE CASCADE ON UPDATE CASCADE`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "refunds" ADD CONSTRAINT "REL_8bb3b7579f49990d2e77684acd" UNIQUE ("transaction_id")`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "refunds" ADD CONSTRAINT "FK_8bb3b7579f49990d2e77684acd4" FOREIGN KEY ("transaction_id") REFERENCES "transactions"("id") ON DELETE CASCADE ON UPDATE CASCADE`,
+    );
+  }
+}

src/database/migrations/1722587128195-update-type-column-item-table.ts

@@ -0,0 +1,17 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class UpdateTypeColumnItemTable1722587128195
+  implements MigrationInterface
+{
+  name = 'UpdateTypeColumnItemTable1722587128195';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(`ALTER TABLE "items" DROP COLUMN "sales_margin"`);
+    await queryRunner.query(`ALTER TABLE "items" ADD "sales_margin" numeric`);
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(`ALTER TABLE "items" DROP COLUMN "sales_margin"`);
+    await queryRunner.query(`ALTER TABLE "items" ADD "sales_margin" integer`);
+  }
+}

src/database/migrations/1722595038215-update-table-transaction.ts

@@ -0,0 +1,23 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class UpdateTableTransaction1722595038215 implements MigrationInterface {
+  name = 'UpdateTableTransaction1722595038215';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `CREATE TYPE "public"."transactions_payment_type_counter_enum" AS ENUM('midtrans', 'bank transfer', 'qris', 'counter', 'cash', 'credit card', 'debit', 'e-money')`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transactions" ADD "payment_type_counter" "public"."transactions_payment_type_counter_enum"`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "transactions" DROP COLUMN "payment_type_counter"`,
+    );
+    await queryRunner.query(
+      `DROP TYPE "public"."transactions_payment_type_counter_enum"`,
+    );
+  }
+}

src/database/migrations/1722693550579-add-column-to-transactions-table.ts

@@ -0,0 +1,19 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddColumnToTransactionsTable1722693550579
+  implements MigrationInterface
+{
+  name = 'AddColumnToTransactionsTable1722693550579';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "transactions" ADD "booking_date_before" date`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "transactions" DROP COLUMN "booking_date_before"`,
+    );
+  }
+}

src/database/migrations/1722922766205-unique_name_item.ts

@@ -0,0 +1,29 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class UniqueNameItem1722922766205 implements MigrationInterface {
+  name = 'UniqueNameItem1722922766205';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "item_bundlings" DROP CONSTRAINT "FK_a50e7abf2caba4d0394f3726b86"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "items" ADD CONSTRAINT "UQ_213736582899b3599acaade2cd1" UNIQUE ("name")`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "item_bundlings" ADD CONSTRAINT "FK_a50e7abf2caba4d0394f3726b86" FOREIGN KEY ("item_bundling_id") REFERENCES "items"("id") ON DELETE CASCADE ON UPDATE CASCADE`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "item_bundlings" DROP CONSTRAINT "FK_a50e7abf2caba4d0394f3726b86"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "items" DROP CONSTRAINT "UQ_213736582899b3599acaade2cd1"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "item_bundlings" ADD CONSTRAINT "FK_a50e7abf2caba4d0394f3726b86" FOREIGN KEY ("item_bundling_id") REFERENCES "items"("id") ON DELETE CASCADE ON UPDATE CASCADE`,
+    );
+  }
+}

src/database/migrations/1723706764654-add-item-profit.ts

@@ -0,0 +1,13 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddItemProfit1723706764654 implements MigrationInterface {
+  name = 'AddItemProfit1723706764654';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(`ALTER TABLE "items" ADD "share_profit" numeric`);
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(`ALTER TABLE "items" DROP COLUMN "share_profit"`);
+  }
+}

src/database/migrations/1723706764655-add-other-type-item.ts

@@ -0,0 +1,85 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddItemProfit1723706764654 implements MigrationInterface {
+  name = 'AddOtherType1723706764655';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "items" ADD "breakdown_bundling" boolean NOT NULL DEFAULT false`,
+    );
+    await queryRunner.query(
+      `ALTER TYPE "public"."item_categories_item_type_enum" RENAME TO "item_categories_item_type_enum_old"`,
+    );
+    await queryRunner.query(
+      `CREATE TYPE "public"."item_categories_item_type_enum" AS ENUM('tiket masuk', 'wahana', 'bundling', 'free gift', 'other')`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "item_categories" ALTER COLUMN "item_type" DROP DEFAULT`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "item_categories" ALTER COLUMN "item_type" TYPE "public"."item_categories_item_type_enum" USING "item_type"::"text"::"public"."item_categories_item_type_enum"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "item_categories" ALTER COLUMN "item_type" SET DEFAULT 'tiket masuk'`,
+    );
+    await queryRunner.query(
+      `DROP TYPE "public"."item_categories_item_type_enum_old"`,
+    );
+    await queryRunner.query(
+      `ALTER TYPE "public"."items_item_type_enum" RENAME TO "items_item_type_enum_old"`,
+    );
+    await queryRunner.query(
+      `CREATE TYPE "public"."items_item_type_enum" AS ENUM('tiket masuk', 'wahana', 'bundling', 'free gift', 'other')`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "items" ALTER COLUMN "item_type" DROP DEFAULT`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "items" ALTER COLUMN "item_type" TYPE "public"."items_item_type_enum" USING "item_type"::"text"::"public"."items_item_type_enum"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "items" ALTER COLUMN "item_type" SET DEFAULT 'tiket masuk'`,
+    );
+    await queryRunner.query(`DROP TYPE "public"."items_item_type_enum_old"`);
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `CREATE TYPE "public"."items_item_type_enum_old" AS ENUM('bundling', 'free gift', 'tiket masuk', 'wahana')`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "items" ALTER COLUMN "item_type" DROP DEFAULT`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "items" ALTER COLUMN "item_type" TYPE "public"."items_item_type_enum_old" USING "item_type"::"text"::"public"."items_item_type_enum_old"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "items" ALTER COLUMN "item_type" SET DEFAULT 'tiket masuk'`,
+    );
+    await queryRunner.query(`DROP TYPE "public"."items_item_type_enum"`);
+    await queryRunner.query(
+      `ALTER TYPE "public"."items_item_type_enum_old" RENAME TO "items_item_type_enum"`,
+    );
+    await queryRunner.query(
+      `CREATE TYPE "public"."item_categories_item_type_enum_old" AS ENUM('bundling', 'free gift', 'tiket masuk', 'wahana')`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "item_categories" ALTER COLUMN "item_type" DROP DEFAULT`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "item_categories" ALTER COLUMN "item_type" TYPE "public"."item_categories_item_type_enum_old" USING "item_type"::"text"::"public"."item_categories_item_type_enum_old"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "item_categories" ALTER COLUMN "item_type" SET DEFAULT 'tiket masuk'`,
+    );
+    await queryRunner.query(
+      `DROP TYPE "public"."item_categories_item_type_enum"`,
+    );
+    await queryRunner.query(
+      `ALTER TYPE "public"."item_categories_item_type_enum_old" RENAME TO "item_categories_item_type_enum"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "items" DROP COLUMN "breakdown_bundling"`,
+    );
+  }
+}

src/database/migrations/1723713873756-add-demography-transaction.ts

@@ -0,0 +1,23 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddDemographyTransaction1723713873756
+  implements MigrationInterface
+{
+  name = 'AddDemographyTransaction1723713873756';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `CREATE TABLE "transaction_demographies" ("id" uuid NOT NULL DEFAULT uuid_generate_v4(), "man" integer NOT NULL DEFAULT '0', "woman" integer NOT NULL DEFAULT '0', "teen" integer NOT NULL DEFAULT '0', "child" integer NOT NULL DEFAULT '0', "local" integer NOT NULL DEFAULT '0', "foreign" integer NOT NULL DEFAULT '0', "transaction_id" uuid, CONSTRAINT "PK_84083b782ebc2c6cb2a2dab8e2d" PRIMARY KEY ("id"))`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_demographies" ADD CONSTRAINT "FK_a2b705884bca06c148e3b35ab04" FOREIGN KEY ("transaction_id") REFERENCES "transactions"("id") ON DELETE CASCADE ON UPDATE CASCADE`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "transaction_demographies" DROP CONSTRAINT "FK_a2b705884bca06c148e3b35ab04"`,
+    );
+    await queryRunner.query(`DROP TABLE "transaction_demographies"`);
+  }
+}

src/database/migrations/1723716561482-fix-demography-nationality.ts

@@ -0,0 +1,49 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class FixDemographyNationality1723716561482
+  implements MigrationInterface
+{
+  name = 'FixDemographyNationality1723716561482';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "transaction_demographies" DROP COLUMN "local"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_demographies" DROP COLUMN "foreign"`,
+    );
+    await queryRunner.query(
+      `CREATE TYPE "public"."transaction_demographies_nationality_enum" AS ENUM('local', 'foreign', 'mix')`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_demographies" ADD "nationality" "public"."transaction_demographies_nationality_enum" NOT NULL DEFAULT 'local'`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_demographies" DROP CONSTRAINT "FK_a2b705884bca06c148e3b35ab04"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_demographies" ADD CONSTRAINT "FK_a2b705884bca06c148e3b35ab04" FOREIGN KEY ("transaction_id") REFERENCES "transactions"("id") ON DELETE CASCADE ON UPDATE CASCADE`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "transaction_demographies" DROP CONSTRAINT "FK_a2b705884bca06c148e3b35ab04"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_demographies" ADD CONSTRAINT "FK_a2b705884bca06c148e3b35ab04" FOREIGN KEY ("transaction_id") REFERENCES "transactions"("id") ON DELETE CASCADE ON UPDATE CASCADE`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_demographies" DROP COLUMN "nationality"`,
+    );
+    await queryRunner.query(
+      `DROP TYPE "public"."transaction_demographies_nationality_enum"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_demographies" ADD "foreign" integer NOT NULL DEFAULT '0'`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_demographies" ADD "local" integer NOT NULL DEFAULT '0'`,
+    );
+  }
+}

src/database/migrations/1723801180604-add-estimation-to-item.ts

@@ -0,0 +1,17 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddEstimationToItem1723801180604 implements MigrationInterface {
+  name = 'AddEstimationToItem1723801180604';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "items" ADD "play_estimation" numeric`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "items" DROP COLUMN "play_estimation"`,
+    );
+  }
+}

src/database/migrations/1724127202672-add-breakdown-item-transaction.ts

@@ -0,0 +1,23 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddBreakdownItemTransaction1724127202672
+  implements MigrationInterface
+{
+  name = 'AddBreakdownItemTransaction1724127202672';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `CREATE TABLE "transaction_item_breakdowns" ("id" uuid NOT NULL DEFAULT uuid_generate_v4(), "item_id" character varying NOT NULL, "item_name" character varying NOT NULL, "hpp" bigint, "base_price" bigint, "item_rates" bigint, "transaction_item_id" uuid, CONSTRAINT "PK_e04a30c648d3ba8778e9fb67fdd" PRIMARY KEY ("id"))`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_item_breakdowns" ADD CONSTRAINT "FK_b8c63b1f3ecace500587da713ae" FOREIGN KEY ("transaction_item_id") REFERENCES "transaction_items"("id") ON DELETE CASCADE ON UPDATE CASCADE`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "transaction_item_breakdowns" DROP CONSTRAINT "FK_b8c63b1f3ecace500587da713ae"`,
+    );
+    await queryRunner.query(`DROP TABLE "transaction_item_breakdowns"`);
+  }
+}

src/database/migrations/1724233193743-add-breakdown-to-transaction-item.ts

@@ -0,0 +1,19 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddBreakdownToTransactionItem1724233193743
+  implements MigrationInterface
+{
+  name = 'AddBreakdownToTransactionItem1724233193743';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "transaction_items" ADD "breakdown_bundling" boolean NOT NULL DEFAULT false`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "transaction_items" DROP COLUMN "breakdown_bundling"`,
+    );
+  }
+}

src/database/migrations/1724240624025-add-value-to-demography.ts

@@ -0,0 +1,47 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddValueToDemography1724240624025 implements MigrationInterface {
+  name = 'AddValueToDemography1724240624025';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TYPE "public"."transaction_demographies_nationality_enum" RENAME TO "transaction_demographies_nationality_enum_old"`,
+    );
+    await queryRunner.query(
+      `CREATE TYPE "public"."transaction_demographies_nationality_enum" AS ENUM('local', 'foreign', 'mix', 'foreigner')`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_demographies" ALTER COLUMN "nationality" DROP DEFAULT`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_demographies" ALTER COLUMN "nationality" TYPE "public"."transaction_demographies_nationality_enum" USING "nationality"::"text"::"public"."transaction_demographies_nationality_enum"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_demographies" ALTER COLUMN "nationality" SET DEFAULT 'local'`,
+    );
+    await queryRunner.query(
+      `DROP TYPE "public"."transaction_demographies_nationality_enum_old"`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `CREATE TYPE "public"."transaction_demographies_nationality_enum_old" AS ENUM('local', 'foreign', 'mix')`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_demographies" ALTER COLUMN "nationality" DROP DEFAULT`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_demographies" ALTER COLUMN "nationality" TYPE "public"."transaction_demographies_nationality_enum_old" USING "nationality"::"text"::"public"."transaction_demographies_nationality_enum_old"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_demographies" ALTER COLUMN "nationality" SET DEFAULT 'local'`,
+    );
+    await queryRunner.query(
+      `DROP TYPE "public"."transaction_demographies_nationality_enum"`,
+    );
+    await queryRunner.query(
+      `ALTER TYPE "public"."transaction_demographies_nationality_enum_old" RENAME TO "transaction_demographies_nationality_enum"`,
+    );
+  }
+}

src/database/migrations/1724926316235-add-value-variable-formula.ts

@@ -0,0 +1,19 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddValueVariableFormula1724926316235
+  implements MigrationInterface
+{
+  name = 'AddValueVariableFormula1724926316235';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "price_formulas" ADD "value_for" character varying NOT NULL DEFAULT 'dpp'`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "price_formulas" DROP COLUMN "value_for"`,
+    );
+  }
+}

src/database/migrations/1725962197762-add-payment-date-bank-column-at-transaction.ts

@@ -0,0 +1,19 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddPaymentDateBankColumnAtTransaction1725962197762
+  implements MigrationInterface
+{
+  name = 'AddPaymentDateBankColumnAtTransaction1725962197762';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "transactions" ADD "payment_date_bank" date`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "transactions" DROP COLUMN "payment_date_bank"`,
+    );
+  }
+}

src/database/migrations/1726033041774-add-pos-name-column.ts

@@ -0,0 +1,21 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddPosNameColumn1726033041774 implements MigrationInterface {
+  name = 'AddPosNameColumn1726033041774';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "transactions" ADD "creator_counter_name" character varying`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "logs_pos" ADD "pos_name" character varying`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(`ALTER TABLE "logs_pos" DROP COLUMN "pos_name"`);
+    await queryRunner.query(
+      `ALTER TABLE "transactions" DROP COLUMN "creator_counter_name"`,
+    );
+  }
+}

src/database/migrations/1726041175749-add-flag-role-queue.ts

@@ -0,0 +1,43 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddFlagRoleQueue1726041175749 implements MigrationInterface {
+  name = 'AddFlagRoleQueue1726041175749';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TYPE "public"."users_role_enum" RENAME TO "users_role_enum_old"`,
+    );
+    await queryRunner.query(
+      `CREATE TYPE "public"."users_role_enum" AS ENUM('superadmin', 'staff', 'tenant', 'queue_admin')`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "users" ALTER COLUMN "role" DROP DEFAULT`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "users" ALTER COLUMN "role" TYPE "public"."users_role_enum" USING "role"::"text"::"public"."users_role_enum"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "users" ALTER COLUMN "role" SET DEFAULT 'staff'`,
+    );
+    await queryRunner.query(`DROP TYPE "public"."users_role_enum_old"`);
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `CREATE TYPE "public"."users_role_enum_old" AS ENUM('superadmin', 'staff', 'tenant')`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "users" ALTER COLUMN "role" DROP DEFAULT`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "users" ALTER COLUMN "role" TYPE "public"."users_role_enum_old" USING "role"::"text"::"public"."users_role_enum_old"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "users" ALTER COLUMN "role" SET DEFAULT 'staff'`,
+    );
+    await queryRunner.query(`DROP TYPE "public"."users_role_enum"`);
+    await queryRunner.query(
+      `ALTER TYPE "public"."users_role_enum_old" RENAME TO "users_role_enum"`,
+    );
+  }
+}

src/database/migrations/1726045820711-add-tax-item-transaction.ts

@@ -0,0 +1,73 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddTaxItemTransaction1726045820711 implements MigrationInterface {
+  name = 'AddTaxItemTransaction1726045820711';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `CREATE TABLE "transaction_item_taxes" ("id" uuid NOT NULL DEFAULT uuid_generate_v4(), "tax_id" character varying, "tax_name" character varying, "taxt_value" numeric, "tax_total_value" numeric, "transaction_id" uuid, CONSTRAINT "PK_fc5f6da61b24eb5bfdd503b0a0d" PRIMARY KEY ("id"))`,
+    );
+    await queryRunner.query(
+      `CREATE TABLE "t_breakdown_item_taxes" ("id" uuid NOT NULL DEFAULT uuid_generate_v4(), "tax_id" character varying, "tax_name" character varying, "taxt_value" numeric, "tax_total_value" numeric, "transaction_id" uuid, CONSTRAINT "PK_a1ef08d2c68169a50102aa70eca" PRIMARY KEY ("id"))`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_items" ADD "total_profit_share" numeric`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_item_breakdowns" ADD "total_profit_share" numeric`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_item_taxes" ADD CONSTRAINT "FK_f5c4966a381d903899cafb4b5ba" FOREIGN KEY ("transaction_id") REFERENCES "transaction_items"("id") ON DELETE CASCADE ON UPDATE CASCADE`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "t_breakdown_item_taxes" ADD CONSTRAINT "FK_74bedce7e94f6707ddf26ef0c0f" FOREIGN KEY ("transaction_id") REFERENCES "transaction_item_breakdowns"("id") ON DELETE CASCADE ON UPDATE CASCADE`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_items" ADD "payment_total_dpp" numeric`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_item_breakdowns" ADD "payment_total_dpp" numeric`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_items" ADD "payment_total_tax" numeric`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_item_breakdowns" ADD "payment_total_tax" numeric`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_item_breakdowns" ADD "total_share_tenant" numeric`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "t_breakdown_item_taxes" DROP CONSTRAINT "FK_74bedce7e94f6707ddf26ef0c0f"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_item_taxes" DROP CONSTRAINT "FK_f5c4966a381d903899cafb4b5ba"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_item_breakdowns" DROP COLUMN "total_profit_share"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_items" DROP COLUMN "total_profit_share"`,
+    );
+    await queryRunner.query(`DROP TABLE "t_breakdown_item_taxes"`);
+    await queryRunner.query(`DROP TABLE "transaction_item_taxes"`);
+    await queryRunner.query(
+      `ALTER TABLE "transaction_item_breakdowns" DROP COLUMN "payment_total_dpp"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_items" DROP COLUMN "payment_total_dpp"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_item_breakdowns" DROP COLUMN "payment_total_tax"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_items" DROP COLUMN "payment_total_tax"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_item_breakdowns" DROP COLUMN "total_share_tenant"`,
+    );
+  }
+}

src/database/migrations/1726115025759-add-table-user-login.ts

@@ -0,0 +1,21 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddTableUserLogin1726115025759 implements MigrationInterface {
+  name = 'AddTableUserLogin1726115025759';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `CREATE TABLE "users_login" ("id" uuid NOT NULL DEFAULT uuid_generate_v4(), "login_date" bigint NOT NULL, "login_token" character varying, "user_id" uuid, CONSTRAINT "REL_2a80a213b51423ce5b8211f058" UNIQUE ("user_id"), CONSTRAINT "PK_e564194a9a22f8c623354284f75" PRIMARY KEY ("id"))`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "users_login" ADD CONSTRAINT "FK_2a80a213b51423ce5b8211f0584" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "users_login" DROP CONSTRAINT "FK_2a80a213b51423ce5b8211f0584"`,
+    );
+    await queryRunner.query(`DROP TABLE "users_login"`);
+  }
+}

src/database/migrations/1726122619596-update-table-user-login.ts

@@ -0,0 +1,23 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class UpdateTableUserLogin1726122619596 implements MigrationInterface {
+  name = 'UpdateTableUserLogin1726122619596';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "users_login" DROP CONSTRAINT "FK_2a80a213b51423ce5b8211f0584"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "users_login" ADD CONSTRAINT "FK_2a80a213b51423ce5b8211f0584" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE CASCADE`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "users_login" DROP CONSTRAINT "FK_2a80a213b51423ce5b8211f0584"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "users_login" ADD CONSTRAINT "FK_2a80a213b51423ce5b8211f0584" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`,
+    );
+  }
+}

src/database/migrations/1726123955427-add-table-log-user-login.ts

@@ -0,0 +1,23 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddTableLogUserLogin1726123955427 implements MigrationInterface {
+  name = 'AddTableLogUserLogin1726123955427';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `CREATE TYPE "public"."log_users_login_type_enum" AS ENUM('login', 'logout')`,
+    );
+    await queryRunner.query(
+      `CREATE TYPE "public"."log_users_login_role_enum" AS ENUM('superadmin', 'staff', 'tenant', 'queue_admin')`,
+    );
+    await queryRunner.query(
+      `CREATE TABLE "log_users_login" ("id" uuid NOT NULL DEFAULT uuid_generate_v4(), "type" "public"."log_users_login_type_enum", "role" "public"."log_users_login_role_enum", "user_id" uuid, "username" character varying, "created_at" bigint, CONSTRAINT "PK_75141588aa6ee560504f7d3adce" PRIMARY KEY ("id"))`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(`DROP TABLE "log_users_login"`);
+    await queryRunner.query(`DROP TYPE "public"."log_users_login_role_enum"`);
+    await queryRunner.query(`DROP TYPE "public"."log_users_login_type_enum"`);
+  }
+}

src/database/migrations/1726139426994-add-column-item_id.ts

@@ -0,0 +1,17 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddColumnItemId1726139426994 implements MigrationInterface {
+  name = 'AddColumnItemId1726139426994';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(`ALTER TABLE "users_login" ADD "item_id" uuid`);
+    await queryRunner.query(`ALTER TABLE "log_users_login" ADD "item_id" uuid`);
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "log_users_login" DROP COLUMN "item_id"`,
+    );
+    await queryRunner.query(`ALTER TABLE "users_login" DROP COLUMN "item_id"`);
+  }
+}

src/database/migrations/1726141393404-add-column-item_name.ts

@@ -0,0 +1,23 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddColumnItemName1726141393404 implements MigrationInterface {
+  name = 'AddColumnItemName1726141393404';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "users_login" ADD "item_name" character varying`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "log_users_login" ADD "item_name" character varying`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "log_users_login" DROP COLUMN "item_name"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "users_login" DROP COLUMN "item_name"`,
+    );
+  }
+}

src/database/migrations/1726365023179-add-formula-to-tax.ts

@@ -0,0 +1,17 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddFormulaToTax1726365023179 implements MigrationInterface {
+  name = 'AddFormulaToTax1726365023179';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(`ALTER TABLE "taxes" ADD "formula_render" json`);
+    await queryRunner.query(
+      `ALTER TABLE "taxes" ADD "formula_string" character varying`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(`ALTER TABLE "taxes" DROP COLUMN "formula_string"`);
+    await queryRunner.query(`ALTER TABLE "taxes" DROP COLUMN "formula_render"`);
+  }
+}

src/database/migrations/1726642119207-change-user-login-relation.ts

@@ -0,0 +1,35 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class ChangeUserLoginRelation1726642119207
+  implements MigrationInterface
+{
+  name = 'ChangeUserLoginRelation1726642119207';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(`ALTER TABLE "users" DROP COLUMN "refresh_token"`);
+    await queryRunner.query(
+      `ALTER TABLE "users_login" DROP CONSTRAINT "FK_2a80a213b51423ce5b8211f0584"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "users_login" DROP CONSTRAINT "REL_2a80a213b51423ce5b8211f058"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "users_login" ADD CONSTRAINT "FK_2a80a213b51423ce5b8211f0584" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE CASCADE`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "users_login" DROP CONSTRAINT "FK_2a80a213b51423ce5b8211f0584"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "users_login" ADD CONSTRAINT "REL_2a80a213b51423ce5b8211f058" UNIQUE ("user_id")`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "users_login" ADD CONSTRAINT "FK_2a80a213b51423ce5b8211f0584" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE CASCADE`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "users" ADD "refresh_token" character varying`,
+    );
+  }
+}

src/database/migrations/1726642499135-add-column-source-at-user-login.ts

@@ -0,0 +1,29 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddColumnSourceAtUserLogin1726642499135
+  implements MigrationInterface
+{
+  name = 'AddColumnSourceAtUserLogin1726642499135';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `CREATE TYPE "public"."users_login_role_enum" AS ENUM('superadmin', 'staff', 'tenant', 'queue_admin')`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "users_login" ADD "role" "public"."users_login_role_enum"`,
+    );
+    await queryRunner.query(
+      `CREATE TYPE "public"."users_login_source_enum" AS ENUM('POS_ADMIN', 'POS_COUNTER', 'QUEUE_ADMIN', 'QUEUE_CUSTOMER')`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "users_login" ADD "source" "public"."users_login_source_enum"`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(`ALTER TABLE "users_login" DROP COLUMN "source"`);
+    await queryRunner.query(`DROP TYPE "public"."users_login_source_enum"`);
+    await queryRunner.query(`ALTER TABLE "users_login" DROP COLUMN "role"`);
+    await queryRunner.query(`DROP TYPE "public"."users_login_role_enum"`);
+  }
+}

src/database/migrations/1726647442006-add-source-on-log-login.ts

@@ -0,0 +1,21 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddSourceOnLogLogin1726647442006 implements MigrationInterface {
+  name = 'AddSourceOnLogLogin1726647442006';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `CREATE TYPE "public"."log_users_login_source_enum" AS ENUM('POS_ADMIN', 'POS_COUNTER', 'QUEUE_ADMIN', 'QUEUE_CUSTOMER')`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "log_users_login" ADD "source" "public"."log_users_login_source_enum"`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "log_users_login" DROP COLUMN "source"`,
+    );
+    await queryRunner.query(`DROP TYPE "public"."log_users_login_source_enum"`);
+  }
+}

src/database/migrations/1726824289989-add-discount-for-item-transaction.ts

@@ -0,0 +1,43 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddDiscountForItemTransaction1726824289989
+  implements MigrationInterface
+{
+  name = 'AddDiscountForItemTransaction1726824289989';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "transaction_items" ADD "subtotal" numeric`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_items" ADD "discount_value" numeric`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_item_breakdowns" ADD "subtotal" numeric`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_item_breakdowns" ADD "discount_value" numeric`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_item_breakdowns" ADD "total_price" numeric`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "transaction_item_breakdowns" DROP COLUMN "total_price"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_item_breakdowns" DROP COLUMN "discount_value"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_item_breakdowns" DROP COLUMN "subtotal"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_items" DROP COLUMN "discount_value"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_items" DROP COLUMN "subtotal"`,
+    );
+  }
+}

src/database/migrations/1726830293878-change-column-name.ts

@@ -0,0 +1,23 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class ChangeColumnName1726830293878 implements MigrationInterface {
+  name = 'ChangeColumnName1726830293878';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "transaction_items" RENAME COLUMN "subtotal" TO "total_net_price"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_item_breakdowns" RENAME COLUMN "subtotal" TO "total_net_price"`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "transaction_item_breakdowns" RENAME COLUMN "total_net_price" TO "subtotal"`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "transaction_items" RENAME COLUMN "total_net_price" TO "subtotal"`,
+    );
+  }
+}

src/database/migrations/1728377112337-add-discount-value-to-voucher.ts

@@ -0,0 +1,25 @@
+import { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddDiscountValueToVoucher1728377112337
+  implements MigrationInterface
+{
+  name = 'AddDiscountValueToVoucher1728377112337';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "vip_codes" ADD "discount_value" numeric`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "vip_codes" ALTER COLUMN "discount" DROP NOT NULL`,
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "vip_codes" ALTER COLUMN "discount" SET NOT NULL`,
+    );
+    await queryRunner.query(
+      `ALTER TABLE "vip_codes" DROP COLUMN "discount_value"`,
+    );
+  }
+}