PHP-databaskonstruktion

Log | Files | Refs

operation.php (2544B)

      1 <?php
      2     require 'utils/imports.php';
      3 
      4     $handlerFactory = new InsertHandlerFactory();
      5     $updateFactory = new UpdateHandlerFactory();
      6 
      7     $pageContent = '';
      8 
      9     $operationName = urldecode($_GET['OperationName']);
     10     $startDate = urldecode($_GET['StartDate']);
     11     $incidentName = urldecode($_GET['IncidentName']);
     12     $incidentNumber = urldecode($_GET['IncidentNumber']);
     13 
     14     $queryCodeName = "SELECT CodeName AS Agents FROM OperatesIn 
     15         WHERE OperationName = '{$operationName}' 
     16         AND StartDate = '{$startDate}'
     17         AND IncidentName = '{$incidentName}'
     18         AND IncidentNumber = {$incidentNumber}";
     19 
     20     $pageContent .= "<h3>Agents in $operationName</h3>" . tableFactory::createCustomTable($queryCodeName);
     21 
     22     $addAgentModalBuilder = (new ModalBuilder())
     23         ->setModalId('insertModal')
     24         ->setTableName("OperatesIn")
     25         ->setPostHandler($handlerFactory->createHandler('OperatesIn'))
     26         ->addHiddenColumn("OperationName", $operationName)
     27         ->addHiddenColumn("StartDate", $startDate)
     28         ->addHiddenColumn("IncidentName", $incidentName)
     29         ->addHiddenColumn("IncidentNumber", $incidentNumber)
     30         ->addDropdownColumn("CodeName", getColumnValues("FieldAgents", "CodeName"));
     31 
     32 
     33     $addAgentModalBuilder->handleData();
     34     $pageContent .= $addAgentModalBuilder->build();
     35     $pageContent .= $addAgentModalBuilder->generateOpenButton("Add agent");
     36 
     37     $pageContent .= "<hr>";
     38     
     39     $queryGroupLeader = "SELECT GroupLeader FROM Operation 
     40         WHERE OperationName = '{$operationName}'
     41         AND StartDate = '{$startDate}'
     42         AND IncidentName = '{$incidentName}'
     43         AND IncidentNumber = {$incidentNumber}";
     44 
     45     $pageContent .= "<h3>Groupleader for $operationName</h3>" . tableFactory::createCustomTable($queryGroupLeader);
     46 
     47     $condition = "OperationName = '{$operationName}'
     48         AND StartDate = '{$startDate}'
     49         AND IncidentName = '{$incidentName}'
     50         AND IncidentNumber = {$incidentNumber}";
     51 
     52     $updateGroupLeaderModalBuilder = (new ModalBuilder())
     53         ->setModalId('updateModal')
     54         ->setTableName("Operation")
     55         ->setPostHandler($updateFactory->createHandler("Operation",  $condition))
     56         ->addDropdownColumn("GroupLeader", getColumnValues("GroupLeaders", "CodeName"));
     57 
     58     $updateGroupLeaderModalBuilder->handleData();
     59     $pageContent .= $updateGroupLeaderModalBuilder->build();
     60     $pageContent .= $updateGroupLeaderModalBuilder->generateOpenButton("Change GroupLeader");
     61 
     62     include 'utils/pageTemplate.php';
     63 ?>