iwa-panda2

Templates.php (6871B)

---

 <?php
 
 namespace Controller {
 
     /// Controller\Templates is a utility class for creating HTML-forms and other constructs
     class Templates
     {
         private \Lollipop\SQLDatabase $db;
         private \Lollipop\DatabaseObject $table;
         private string $schema = 'panda';
         private string $table_name;
 
         public function __construct(\Lollipop\SQLDatabase $db, \Lollipop\DatabaseObject $table)
         {
             $this->db = $db;
             $this->table = $table;
             $this->table_name = $table::class;
         }
 
         public function form(string $action, array $data = [], array $response = []): string
         {
             /*auto-increment fields are automatically hidden*/
             $form_type = "Add";
             $form = '<form method="POST" action="'. $action . '">';
             foreach($this->table->get_col_names_ai() as $col) {
                 if($data == []) {
                     $value = '-1';
                 } else {
                     if(in_array($col, array_keys($data))) {
                         $value = $data[$col];
                     }
                     $form_type = "Update";
                 }
                 $form .= '<input type="hidden" name="' . $col . '" value="' . $value . '">';
             }
             $form .= '<input type="hidden" name="form_type" value="' . $form_type . '">';
             foreach($this->table->get_col_names_no_ai() as $col) {
                 if($data == []) {
                     $value = '';
                 } else {
                     if(in_array($col, array_keys($data))) {
                         $value = $data[$col];
                     }
                 }
                 $form .= '<input type="text" name="' . $col . '" placeholder="' . $col . '" value="' . $value . '">';
                 $miss_key = 'missing_'.$col;
                 if(array_key_exists($miss_key, $response)) {
                     $form .= '<div class="form-response"><p style="color:red;"> col: '. $col . ' cannot be empty</p></div>';
                 }
             }
             $form .='
                 <input type="submit" value="'. $form_type .'"> 
             </form>';
 
             return $form;
         }
 
         public function form_v2(string $action, array $values = [], array $extra = [], array $response = []): string
         {
             /*auto-increment fields are automatically hidden*/
             if(sizeof($values) == 0) {
                 $form_type = "Add";
             } else {
                 $form_type = "Update";
             }
             $form = '<h1>'. $form_type .' '. $this->table->get_table() .'</h1>
                     <a href="/'. $this->table->get_table() .'">New</a>';
             $form .= '<form method="POST" action="'. $action . '">';
             foreach($this->table->get_col_info() as $col => $info) {
                 if(isset($info["extra"]) && $info["extra"] == "auto_increment") {
                     $form .= '<input type="hidden" name="' . $col . '" placeholder="' . $col . '" value="';
                     if(isset($values[$col])) {
                         $form .= $values[$col];
                     }
                     $form .= '">';
                 } elseif(isset($info["extra"]) && $info["extra"] == "password") {
                     $form .= '<input type="password" name="' . $col . '" placeholder="' . $col . '">';
                 } elseif(isset($info["input_type"])) {
                     $form .= '<input type="'. $info["input_type"] .'" name="' . $col . '" placeholder="' . $col . '" value="';
                     if(isset($values[$col])) {
                         $form .= $values[$col];
                     }
                     $form .= '">';
                 }
                 $miss_key = 'missing_'.$col;
                 if(array_key_exists($miss_key, $response)) {
                     $form .= '<div class="form-response"><p style="color:red;"> col: '. $col . ' cannot be empty</p></div>';
                 }
             }
             foreach($extra as $html) {
                 $form.= $html;
             }
             $form .= '<input type="hidden" name="form_type" " value="' . $form_type . '">';
             $form .='
                 <input type="submit" value="'. $form_type .'"> 
             </form>';
             return $form;
         }
 
         public function search_form(string $action): string
         {
             return '
                     <form method="POST" action="'. $action . '">
                         <input type="text" name="search" placeholder="Search...">
                         <input type="submit" value="Search"> 
                     </form>';
         }
 
         public function crud_table(string $action, string $search = "", string $search_key = "", \Model\PermissionUser $permissionUser = null): string
         {
             if($search == "") {
                 $search = "%";
             } else {
                 $search = "%$search%";
             }
             $table = "<table> <thead> <tr>";
             foreach($this->table->get_column_names() as $column) {
                 $table .= "<th>$column</th>";
             }
             $table .= "<th>Alter</th> <th>Delete</th>";
             if($permissionUser != null) {
                 $table .= "<th>user permissions</th>";
             }
             $table .= "</tr> </thead>";
 
             $objs = $this->db->all_where($this->table_name, [$search_key => $search]);
             $table .= "<tbody>";
             foreach($objs as $obj) {
                 $table .= "<tr>";
                 $col_names = $obj->get_column_names();
                 foreach($col_names as $col) {
                     $table .= '<td>';
                     if($col == "email" || $col == "name" || $col == "course" || $col == "exam") {
                         $table .= '<a href="/'.$this->table->get_table().'/' .$obj->{$col}.'">'. $obj->{$col} . '</a></td>';
                     } else {
                         $table .= $obj->{$col} . '</td>';
                     }
                 }
                 $table .= '
                     <td>
                         <a class="edit" href="' . $action . '/'. $obj->{$this->table->get_primary()} .'/edit/">Edit</a>
                     </td>
                     <td>
                         <a class="delete" href="' . $action . '/'. $obj->{$this->table->get_primary()} .'/delete/">Delete</a>
                     </td>
                     <td>';
                 if($permissionUser != null) {
                     foreach($this->db->all_where(\Model\PermissionUser::class, [$permissionUser->get_primary() => $obj->{$this->table->get_primary()}]) as $perm) {
                         $table .= $perm->id_permission . ' ';
                     }
                 }
                 $table .= '</td> </tr>';
             }
 
             $table .= "
                 </tbody>
             </table>";
             return $table;
         }
 
     }
 }