conn = null; try { $this->conn = new PDO( "mysql:host={$this->host};dbname={$this->db_name}", $this->username, $this->password ); $this->conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch(PDOException $e) { echo "Connection error: " . $e->getMessage(); } return $this->conn; } } connect(); try { // Create work_reports table $conn->exec("CREATE TABLE IF NOT EXISTS work_reports ( id INT AUTO_INCREMENT PRIMARY KEY, work_date DATE NOT NULL, check_in TIME NOT NULL, check_out TIME NOT NULL, description TEXT NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP )"); // Create work_details table (for the table inside description) $conn->exec("CREATE TABLE IF NOT EXISTS work_details ( id INT AUTO_INCREMENT PRIMARY KEY, report_id INT NOT NULL, task_description TEXT NOT NULL, hours_spent DECIMAL(4,2) NOT NULL, status ENUM('completed', 'in_progress', 'pending') NOT NULL, FOREIGN KEY (report_id) REFERENCES work_reports(id) ON DELETE CASCADE )"); echo "Tables created successfully!"; } catch(PDOException $e) { echo "Error creating tables: " . $e->getMessage(); } conn = $database->connect(); } public function createReport($workDate, $checkIn, $checkOut, $description) { $query = "INSERT INTO work_reports (work_date, check_in, check_out, description) VALUES (:work_date, :check_in, :check_out, :description)"; $stmt = $this->conn->prepare($query); $stmt->bindParam(':work_date', $workDate); $stmt->bindParam(':check_in', $checkIn); $stmt->bindParam(':check_out', $checkOut); $stmt->bindParam(':description', $description); return $stmt->execute() ? $this->conn->lastInsertId() : false; } public function addWorkDetail($reportId, $taskDescription, $hoursSpent, $status) { $query = "INSERT INTO work_details (report_id, task_description, hours_spent, status) VALUES (:report_id, :task_description, :hours_spent, :status)"; $stmt = $this->conn->prepare($query); $stmt->bindParam(':report_id', $reportId); $stmt->bindParam(':task_description', $taskDescription); $stmt->bindParam(':hours_spent', $hoursSpent); $stmt->bindParam(':status', $status); return $stmt->execute(); } public function getAllReports() { $query = "SELECT * FROM work_reports ORDER BY work_date DESC"; $stmt = $this->conn->prepare($query); $stmt->execute(); return $stmt->fetchAll(PDO::FETCH_ASSOC); } public function getReportDetails($reportId) { $query = "SELECT * FROM work_details WHERE report_id = :report_id"; $stmt = $this->conn->prepare($query); $stmt->bindParam(':report_id', $reportId); $stmt->execute(); return $stmt->fetchAll(PDO::FETCH_ASSOC); } } createReport( $_POST['work_date'], $_POST['check_in'], $_POST['check_out'], $_POST['description'] ); if ($reportId) { // Process work details table if provided if (isset($_POST['tasks']) && is_array($_POST['tasks'])) { foreach ($_POST['tasks'] as $task) { $workReport->addWorkDetail( $reportId, $task['description'], $task['hours'], $task['status'] ); } } $success = "Work report submitted successfully!"; } } catch (Exception $e) { $error = "Error: " . $e->getMessage(); } } $reports = $workReport->getAllReports(); ?> Work Report System

Work Report System

Work Date

Check-in Time

Check-out Time

Work Description

Work Details

Previous Reports

Date	Check-in	Check-out	Actions
			View

getAllReports($reportId); $details = $workReport->getReportDetails($reportId); if (empty($report)) { header('Location: index.php'); exit; } $report = $report[0]; ?> View Work Report

Work Report -

Back to Reports

Basic Information

Date:

Check-in:

Check-out:

Work Description

Work Details

Task Description	Hours Spent	Status