commit 33005200191be430d91dfd297fc2c1707ca57150
parent b47cd8404810fdb7f86f777608c6af40729deea5
Author: Friedel Schön <[email protected]>
Date: Sat, 24 Jun 2023 13:56:40 +0200
renaming Controller/Template
Diffstat:
4 files changed, 99 insertions(+), 99 deletions(-)
diff --git a/Controller/Templates.php b/Controller/Templates.php
@@ -0,0 +1,88 @@
+<?php
+namespace Controller{
+ class Templates{
+ private \Lollipop\SQLDatabase $db;
+ private \Lollipop\DatabaseObject $table;
+ private string $schema = 'lollipop';
+ private string $table_name;
+ function __construct(\Lollipop\SQLDatabase $db, \Lollipop\DatabaseObject $table){
+ $this->db = $db;
+ $this->table = $table;
+ $this->table_name = $table::class;
+ }
+
+ 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;
+ }
+
+ 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):string{
+ $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> </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>' . $obj->{$col} . '</td>';
+ }
+ $table .= '
+ <td>
+ <a class="edit" href="' . $action . '/'. $obj->{$this->table->get_primary()} .'/edit/";>Edit</a>
+ <td>
+ <a class="delete" href="' . $action . '/'. $obj->{$this->table->get_primary()} .'/delete/">Delete</a>
+ </td>
+ </tr>';
+ }
+
+ $table .= "
+ </tbody>
+ </table>";
+ return $table;
+ }
+ }
+}
+\ No newline at end of file
diff --git a/controller/templates.php b/controller/templates.php
@@ -1,88 +0,0 @@
-<?php
-namespace controller{
- class templates{
- private \Lollipop\SQLDatabase $db;
- private \Lollipop\DatabaseObject $table;
- private string $schema = 'lollipop';
- private string $table_name;
- function __construct(\Lollipop\SQLDatabase $db, \Lollipop\DatabaseObject $table){
- $this->db = $db;
- $this->table = $table;
- $this->table_name = $table::class;
- }
-
- 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;
- }
-
- 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):string{
- $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> </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>' . $obj->{$col} . '</td>';
- }
- $table .= '
- <td>
- <a class="edit" href="' . $action . '/'. $obj->{$this->table->get_primary()} .'/edit/";>Edit</a>
- <td>
- <a class="delete" href="' . $action . '/'. $obj->{$this->table->get_primary()} .'/delete/">Delete</a>
- </td>
- </tr>';
- }
-
- $table .= "
- </tbody>
- </table>";
- return $table;
- }
- }
-}
-\ No newline at end of file
diff --git a/routing/course.php b/routing/course.php
@@ -3,7 +3,7 @@
$course_get = function(&$vars){
global $db;
$course = $db->get(Model\Course::class);
- $templates = new controller\templates($db, $course);
+ $templates = new Controller\Templates($db, $course);
if(isset($_POST["search"])){
$course->load($_POST["search"]);
@@ -18,7 +18,7 @@ $course_get = function(&$vars){
$course_post = function(&$vars){
global $db;
$course = $db->get(Model\Course::class);
- $templates = new controller\templates($db, $course);
+ $templates = new Controller\Templates($db, $course);
$data = [];
if(isset($_POST["form_type"])){
@@ -38,7 +38,7 @@ $course_post = function(&$vars){
$course_query = function(&$vars){
global $db;
$course = $db->get(Model\Course::class);
- $templates = new controller\templates($db, $course);
+ $templates = new Controller\Templates($db, $course);
$vars["form"] = $templates->form("/course");
$vars["search"] = $templates->search_form("/course/search");
$vars["table"] = $templates->crud_table("/course", $vars["search_query"], "name");
@@ -63,7 +63,7 @@ $course_search = function(&$vars){
$course_edit = function(&$vars){
global $db;
$course = $db->get(Model\Course::class);
- $templates = new controller\templates($db, $course);
+ $templates = new Controller\Templates($db, $course);
$data = [];
$course->load($vars["primary_key"]);
foreach($course->getData() as $key => $col){
@@ -78,7 +78,7 @@ $course_edit = function(&$vars){
$course_delete = function(&$vars){
global $db;
$course = $db->get(Model\Course::class);
- $templates = new controller\templates($db, $course);
+ $templates = new Controller\Templates($db, $course);
$course->load($vars["primary_key"]);
$course->delete();
$vars["form"] = $templates->form("/course");
diff --git a/routing/user.php b/routing/user.php
@@ -3,7 +3,7 @@
$user_get = function(&$vars){
global $db;
$user = $db->get(Model\User::class);
- $templates = new controller\templates($db, $user);
+ $templates = new Controller\Templates($db, $user);
if(isset($_POST["search"])){
$user->load($_POST["search"]);
@@ -18,7 +18,7 @@ $user_get = function(&$vars){
$user_post = function(&$vars){
global $db;
$user = $db->get(Model\User::class);
- $templates = new controller\templates($db, $user);
+ $templates = new Controller\Templates($db, $user);
$data = [];
if(isset($_POST["form_type"])){
@@ -38,7 +38,7 @@ $user_post = function(&$vars){
$user_query = function(&$vars){
global $db;
$user = $db->get(Model\User::class);
- $templates = new controller\templates($db, $user);
+ $templates = new Controller\Templates($db, $user);
$vars["form"] = $templates->form("/user");
$vars["search"] = $templates->search_form("/user/search");
$vars["table"] = $templates->crud_table("/user", $vars["search_query"], "email");
@@ -63,7 +63,7 @@ $user_search = function(&$vars){
$user_edit = function(&$vars){
global $db;
$user = $db->get(Model\User::class);
- $templates = new controller\templates($db, $user);
+ $templates = new Controller\Templates($db, $user);
$data = [];
$user->load($vars["primary_key"]);
foreach($user->getData() as $key => $col){
@@ -78,7 +78,7 @@ $user_edit = function(&$vars){
$user_delete = function(&$vars){
global $db;
$user = $db->get(Model\User::class);
- $templates = new controller\templates($db, $user);
+ $templates = new Controller\Templates($db, $user);
$user->load($vars["primary_key"]);
$user->delete();
$vars["form"] = $templates->form("/user");
