From 86613978c06546af098e96ed9b9496a3dd67ad62 Mon Sep 17 00:00:00 2001
From: Mateja <mail@matejamaric.com>
Date: Fri, 2 Oct 2020 19:36:16 +0200
Subject: Work on reservation...

---
 handle-reservation.php | 44 ++++++++++++++++++++++++++++++++++++++++++++
 index.php              | 22 ++++++++++++++--------
 notes.sql              |  4 +++-
 reservation.php        | 27 +++++++--------------------
 style.css              | 14 +++++++++++++-
 5 files changed, 81 insertions(+), 30 deletions(-)
 create mode 100644 handle-reservation.php

diff --git a/handle-reservation.php b/handle-reservation.php
new file mode 100644
index 0000000..3e24dd8
--- /dev/null
+++ b/handle-reservation.php
@@ -0,0 +1,44 @@
+<?php
+if ($_SERVER["REQUEST_METHOD"] == "POST") {
+  // DB INFO
+  $user = "yota_requester";
+  $password = "oon5iraeghaidoShi5sheefie2uuz3gu";
+  $database = "yota_call_db";
+  $table = "activities";
+
+  // SPECIAL CALL
+  $specialCall = $_POST["scall"];
+
+  // TIME
+  $fromTime = $_POST["sdate"] . $_POST["stime"] . ":00";
+  $toTime = $_POST["edate"] . $_POST["etime"] . ":00";
+
+  // FREQUENCIES
+  $frequencies = $_POST["freqs"][0];
+  for ($i = 0; $i < sizeof($_POST["freqs"]) - 1; $i++) {
+    $frequencies += ", " . $_POST["freqs"][$i];
+  }
+
+  // MODES
+  $modes = $_POST["modes"][0];
+  for ($i = 0; $i < sizeof($_POST["modes"]) - 1; $i++) {
+    $modes += ", " . $_POST["modes"][$i];
+  }
+
+  // OPERATOR INFORMATION
+  $operatorCall = $_POST["ocall"] . "<br>";
+  $operatorName = $_POST["oname"] . "<br>";
+  $operatorEmail = $_POST["email"] . "<br>";
+  $operatorPhone = $_POST["phone"] . "<br>";
+
+  try {
+    //$conn = new PDO("mysql:host=localhost;dbname=$database", $user, $password);
+    //$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
+    //$stmt = $conn->prepare("INSERT INTO $table (name, surname, age) VALUES (:name, :surname, :age)");
+    //$stmt->bindParam(':name', $_POST['fname']);
+    //$stmt->execute();
+    //echo "<p>Data inserted.</p>";
+  } catch (PDOException $e) {
+    echo "<p>Error!: " . $e->getMessage() . "</p>";
+  }
+}
diff --git a/index.php b/index.php
index 938534c..6fd938b 100644
--- a/index.php
+++ b/index.php
@@ -26,7 +26,7 @@ session_start();
 <main>
 <?php
   $user = "yota_user";
-  $password = "leex3EThieK0ieLaiVaicaifef5eecei";
+  $password = "gahdeer6shai9hogai2sai4quuaj1eVu";
   $database = "yota_call_db";
   $table = "activities";
 
@@ -37,16 +37,22 @@ session_start();
 		echo '<div style="overflow-x:auto;">';
     echo "<table>\n";
     echo "<thead><tr>";
-    echo "<th>Ime</th>";
-    echo "<th>Prezime</th>";
-    echo "<th>Godine</th>";
+    echo "<th>Operator</th>";
+    echo "<th>From</th>";
+    echo "<th>To</th>";
+    echo "<th>Special sign</th>";
+    echo "<th>Frequencies</th>";
+    echo "<th>QSO</th>";
     echo "</tr></thead><tbody>\n";
 
-    foreach($db->query("SELECT * FROM $table where approved=true") as $row) {
+    foreach($db->query("SELECT * FROM $table where approved=false ORDER BY `id` DESC") as $row) {
       echo "<tr>";
-      echo "<td>" . $row['name'] . "</td>";
-      echo "<td>" . $row['surname'] . "</td>";
-      echo "<td>" . $row['age'] . "</td>";
+      echo "<td>" . $row['operatorCall'] . "</td>";
+      echo "<td>" . $row['fromTime'] . "</td>";
+      echo "<td>" . $row['toTime'] . "</td>";
+      echo "<td>" . $row['specialCall'] . "</td>";
+      echo "<td>" . $row['frequencies'] . "</td>";
+      echo "<td>" . $row['qso'] . "</td>";
       echo "</tr>\n";
     }
 
diff --git a/notes.sql b/notes.sql
index 1794c53..dd59770 100644
--- a/notes.sql
+++ b/notes.sql
@@ -3,15 +3,17 @@ USE yota_db;
 
 CREATE TABLE activities(
         `id` int(11) not null auto_increment primary key,
+        `approved` boolean not null default false;
+        `specialCall` varchar(50) not null,
         `fromTime` datetime not null,
         `toTime` datetime not null,
-        `specialCall` varchar(50) not null,
         `frequencies` varchar(255) not null,
         `modes` varchar(255) not null,
         `operatorCall` varchar(50) not null,
         `operatorName` varchar(50) not null,
         `operatorEmail` varchar(100) not null,
         `operatorPhone` varchar(50) not null
+        `qso` int not null default 0;
       ) charset=utf8;
 
 CREATE TABLE admins(
diff --git a/reservation.php b/reservation.php
index 7b34f71..ec46440 100644
--- a/reservation.php
+++ b/reservation.php
@@ -25,24 +25,7 @@ session_start();
 </nav>
 <main>
 <?php
-if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['fname']) && isset($_POST['lname']) && isset($_POST['age'])) {
-  $user = "yota_user";
-  $password = "leex3EThieK0ieLaiVaicaifef5eecei";
-  $database = "yota_call_db";
-  $table = "activities";
-  try {
-    $conn = new PDO("mysql:host=localhost;dbname=$database", $user, $password);
-    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
-    $stmt = $conn->prepare("INSERT INTO activities (name, surname, age) VALUES (:name, :surname, :age)");
-    $stmt->bindParam(':name', $_POST['fname']);
-    $stmt->bindParam(':surname', $_POST['lname']);
-    $stmt->bindParam(':age', $_POST['age']);
-    $stmt->execute();
-    echo "<p>Data inserted.</p>";
-  } catch (PDOException $e) {
-    echo "<p>Error!: " . $e->getMessage() . "</p>";
-  }
-}
+  require "handle-reservation.php";
 ?>
 
 <form method="post">
@@ -52,11 +35,15 @@ if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['fname']) && isset($_PO
   <option value="YT50SCWC">YT50SCWC</option>
 </select> 
 <!-- START TIME -->
+<label for="start-date">Start date:</label>
+<input type="date" id="start-date" name="sdate">
 <label for="start-time">Start time:</label>
-<input type="datetime-local" id="start-time" name="stime">
+<input type="time" id="start-time" name="stime">
 <!-- END TIME -->
+<label for="end-date">End date:</label>
+<input type="date" id="end-date" name="edate">
 <label for="end-time">End time:</label>
-<input type="datetime-local" id="end-time" name="etime">
+<input type="time" id="end-time" name="etime">
 <!-- BANDS -->
 <fieldset>
   <legend>I will be active on bands:</legend>
diff --git a/style.css b/style.css
index 7fee13f..7b2b25e 100644
--- a/style.css
+++ b/style.css
@@ -48,7 +48,7 @@ nav a:hover {
 /* MAIN STYLING */
 main {
     margin: 1rem auto;
-    max-width: 750px;
+    /*max-width: 750px;*/
 
     line-height: 1.6rem;
     font-size: 1rem;
@@ -71,6 +71,13 @@ table {
     width: 100%;
 }
 
+thead {
+    background-color: black;
+    color: white;
+    /*color: black;*/
+    /*background-color: #ccc;*/
+}
+
 td, th {
     border: 1px solid #ccc;
     text-align: left;
@@ -82,6 +89,11 @@ tr:nth-child(even) {
 }
 
 /* FORM STYLING */
+form {
+    max-width: 750px;
+    margin: 0rem auto;
+}
+
 input, select {
   width: 100%;
   padding: 12px 10px;
-- 
cgit v1.2.3