PHP-databaskonstruktion

Log | Files | Refs

index.php (2688B)

      1 <?php
      2         require 'utils/imports.php';
      3         $handlerFactory = new InsertHandlerFactory();
      4 
      5         $pageContent = '';
      6 
      7         $pageContent .= "<h3>Remove agent</h3>";
      8         $pageContent .= '<div class="mt-3 mb-3">';
      9         $pageContent .= '    <form class="form-inline" method="GET" action="delete.php">';
     10         $pageContent .= '        <input type="hidden" name="table" value="Agent">';
     11         $pageContent .= '        <div class="form-group">';
     12         $pageContent .= '            <input type="text" class="form-control" id="CodeName" name="CodeName" placeholder="Agent codename" value="' . htmlspecialchars($_GET['CodeName'] ?? '') . '">';
     13         $pageContent .= '        </div>';
     14         $pageContent .= '        <button style="margin-left:0.5em;" type="submit" class="btn btn-danger">Remove Agent</button>';
     15         $pageContent .= '    </form>';
     16         $pageContent .= '</div><hr>';
     17 
     18         $pageContent .= "<h3>FieldAgents</h3>" . tableFactory::createTable("FieldAgents");
     19 
     20         $attributeModalBuilder = (new ModalBuilder())
     21                 ->setModalId('insertAttributeModal')
     22                 ->setTableName("FieldAgentAttributes")
     23                 ->setPostHandler($handlerFactory->createHandler('FieldAgentAttributes'))
     24                 ->addDropdownColumn("AgentCodeName", getColumnValues("FieldAgents", "CodeName"))
     25                 ->addColumn("Specialty")
     26                 ->addColumn("Competence");
     27 
     28         $pageContent .= $attributeModalBuilder->handleData();
     29         $pageContent .= $attributeModalBuilder->build();
     30         $pageContent .= $attributeModalBuilder->generateOpenButton("Set specialty");
     31 
     32         $pageContent .= "<hr>";
     33 
     34         $pageContent .= "<h3>GroupLeaders</h3>" . tableFactory::createTable("GroupLeaders");
     35 
     36         $pageContent .= "<hr>";
     37 
     38         $pageContent .= "<h3>Managers</h3>" . tableFactory::createTable("Managers");
     39 
     40         $agentModalBuilder = (new ModalBuilder())
     41                 ->setModalId('insertAgentModal')
     42                 ->setTableName("Agent")
     43                 ->setPostHandler($handlerFactory->createHandler('Agent'))
     44                 ->addColumn("CodeName")
     45                 ->addColumn("FirstName")
     46                 ->addColumn("LastName")
     47                 ->addColumn("Salary", true)
     48                 ->addDropdownColumn("IsFieldAgent", ['True', 'False'])
     49                 ->addDropdownColumn("IsGroupLeader", ['False', 'True'])
     50                 ->addDropdownColumn("IsManager", ['False', 'True']);
     51 
     52         $agentModalBuilder->handleData();
     53         $pageContent .= $agentModalBuilder->build();
     54         $pageContent .= $agentModalBuilder->generateOpenButton("Hire agent");
     55 
     56     include 'utils/pageTemplate.php';
     57 ?>