PHP-databaskonstruktion

commit 632be8748d1b29c5d33ddfc4239e31b24b78a892
parent f2f3a4484f28dfb69db1a4649c35a708f296bef3
Author: William Lindholm <william_lindholm@outlook.com>
Date:   Wed, 27 Sep 2023 18:24:46 +0000

Added detailed view for operations.

Diffstat:
A
operation.php
 | 
42
++++++++++++++++++++++++++++++++++++++++++
M
operations.php
 | 
7
+++++--

2 files changed, 47 insertions(+), 2 deletions(-)
diff --git a/operation.php b/operation.php
@@ -0,0 +1,41 @@
+<?php
+    session_start();
+
+    require 'imports.php';
+    dbconnection::getInstance('mysql', 'a22willi', 'root', 'Safiren1');
+    $handlerFactory = new InsertHandlerFactory();
+
+    $pageContent = '';
+
+    $operationName = urldecode($_GET['OperationName']);
+    $startDate = urldecode($_GET['StartDate']);
+    $incidentName = urldecode($_GET['IncidentName']);
+    $incidentNumber = urldecode($_GET['IncidentNumber']);
+
+    $query = "SELECT CodeName FROM OperatesIn 
+              WHERE OperationName = '{$operationName}' 
+              AND StartDate = '{$startDate}'
+              AND IncidentName = '{$incidentName}'
+              AND IncidentNumber = {$incidentNumber}";
+
+    logg($query);
+
+    $pageContent .= "<h3>Agents in $operationName</h3>" . tableFactory::createCustomTable($query);
+
+    $modalBuilder = (new ModalBuilder())
+            ->setModalId('insertModal')
+            ->setTableName("OperatesIn")
+            ->setInsertHandler($handlerFactory->createHandler('OperatesIn'))
+            ->addHiddenColumn("OperationName", $operationName)
+            ->addHiddenColumn("StartDate", $startDate)
+            ->addHiddenColumn("IncidentName", $incidentName)
+            ->addHiddenColumn("IncidentNumber", $incidentNumber)
+            ->addDropdownColumn("CodeName", getColumnValues("FieldAgents", "CodeName"));
+
+
+    $modalBuilder->handleData();
+    $pageContent .= $modalBuilder->build();
+    $pageContent .= $modalBuilder->generateOpenButton("Add agent");
+
+    include 'pageTemplate.php';
+?>
+\ No newline at end of file
diff --git a/operations.php b/operations.php
@@ -1,21 +1,24 @@
 <?php
     require 'imports.php';
     dbconnection::getInstance('mysql', 'a22willi', 'root', 'Safiren1');
+    $handlerFactory = new InsertHandlerFactory();
 
     $pageContent = '';
 
-    $pageContent .= "<h3>Operations</h3>" . tableFactory::createTable("Operation");
+    $pageContent .= "<h3>Operations</h3>" . tableFactory::createTableWithRedirect("Operation", "operation.php", ["OperationName", "StartDate", "IncidentName", "IncidentNumber"]);
 
     $modalBuilder = (new ModalBuilder())
             ->setModalId('insertModal')
             ->setTableName("Operation")
+            ->setInsertHandler($handlerFactory->createHandler('Operation'))
             ->addColumn("OperationName")
             ->addColumn("StartDate")
             ->addColumn("EndDate", true)
             ->addColumn("SuccessRate", true)
             ->addDropdownColumn("GroupLeader", getColumnValues("GroupLeaders", "CodeName"))
-            ->addDropdownColumn("Incident", ['True', 'False']); #add GetCompositeKeyValues();
+            ->addDropdownColumn("Incident", GetCompositeKeyValues("Incident", ["IncidentName", "IncidentNumber"]));
 
+    $modalBuilder->handleData();
     $pageContent .= $modalBuilder->build();
     $pageContent .= $modalBuilder->generateOpenButton("Create operation");