PHP-databaskonstruktion

Log | Files | Refs

operations.php (2202B)

      1 <?php
      2     require 'utils/imports.php';
      3     $handlerFactory = new InsertHandlerFactory();
      4 
      5     $pageContent = '';
      6 
      7     $pageContent .= '<form action="" method="post" class="mt-3">';
      8     $pageContent .= '    <div class="form-group">';
      9     $pageContent .= '        <label for="startDate">Start Date:</label>';
     10     $pageContent .= '        <input type="date" class="form-control" id="startDate" name="startDate">';
     11     $pageContent .= '    </div>';
     12     $pageContent .= '    <div class="form-group">';
     13     $pageContent .= '        <label for="endDate">End Date:</label>';
     14     $pageContent .= '        <input type="date" class="form-control" id="endDate" name="endDate">';
     15     $pageContent .= '    </div>';
     16     $pageContent .= '    <input type="hidden" name="OperationType" value="filter">';
     17     $pageContent .= '    <button type="submit" class="btn btn-primary">Filter</button>';
     18     $pageContent .= '</form><hr>';
     19 
     20     if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST["OperationType"]) && $_POST["OperationType"] == "filter") {
     21         $startDate = $_POST["startDate"];
     22         $endDate = $_POST["endDate"];
     23         $query = "CALL GetOperationsInRange('$startDate', '$endDate');";
     24     } else {
     25         $query = "SELECT * FROM Operation;";
     26     }
     27 
     28     $pageContent .= "<h3>Operations</h3>" . tableFactory::createTableWithRedirect($query, "operation.php", ["OperationName", "StartDate", "IncidentName", "IncidentNumber"], "Operation");
     29 
     30     $modalBuilder = (new ModalBuilder())
     31             ->setModalId('insertModal')
     32             ->setTableName("Operation")
     33             ->setPostHandler($handlerFactory->createHandler('Operation'))
     34             ->addColumn("OperationName")
     35             ->addDateColumn("StartDate")
     36             ->addDateColumn("EndDate")
     37             ->addColumn("SuccessRate", true)
     38             ->addDropdownColumn("GroupLeader", getColumnValues("GroupLeaders", "CodeName"))
     39             ->addDropdownColumn("Incident", GetCompositeKeyValues("Incident", ["IncidentName", "IncidentNumber"]));
     40 
     41     $modalBuilder->handleData();
     42     $pageContent .= $modalBuilder->build();
     43     $pageContent .= $modalBuilder->generateOpenButton("Create operation");
     44 
     45     include 'utils/pageTemplate.php';
     46 ?>