Contents of the file: /payment-report-system/payment-report-system/backend/controllers/ReportController.php
db = $db;
}
public function getReport($id) {
$report = new Report($this->db);
return $report->find($id);
}
public function getReports() {
$report = new Report($this->db);
return $report->all();
}
public function createReport($data) {
$report = new Report($this->db);
return $report->save($data);
}
public function deleteReport($id) {
$report = new Report($this->db);
return $report->delete($id);
}
}
Contents of the file: /payment-report-system/payment-report-system/backend/models/Report.php
db = $db;
}
public function find($id) {
$stmt = $this->db->prepare("SELECT * FROM " . $this->table . " WHERE id = :id");
$stmt->bindParam(':id', $id);
$stmt->execute();
return $stmt->fetch(PDO::FETCH_ASSOC);
}
public function all() {
$stmt = $this->db->prepare("SELECT * FROM " . $this->table);
$stmt->execute();
return $stmt->fetchAll(PDO::FETCH_ASSOC);
}
public function save($data) {
$stmt = $this->db->prepare("INSERT INTO " . $this->table . " (amount, date, status) VALUES (:amount, :date, :status)");
$stmt->bindParam(':amount', $data['amount']);
$stmt->bindParam(':date', $data['date']);
$stmt->bindParam(':status', $data['status']);
return $stmt->execute();
}
public function delete($id) {
$stmt = $this->db->prepare("DELETE FROM " . $this->table . " WHERE id = :id");
$stmt->bindParam(':id', $id);
return $stmt->execute();
}
}
Contents of the file: /payment-report-system/payment-report-system/backend/routes/api.php
getConnection();
$reportController = new ReportController($db);
$requestMethod = $_SERVER["REQUEST_METHOD"];
switch ($requestMethod) {
case 'GET':
if (isset($_GET['id'])) {
$report = $reportController->getReport($_GET['id']);
echo json_encode($report);
} else {
$reports = $reportController->getReports();
echo json_encode($reports);
}
break;
case 'POST':
$data = json_decode(file_get_contents("php://input"), true);
$reportController->createReport($data);
break;
case 'DELETE':
if (isset($_GET['id'])) {
$reportController->deleteReport($_GET['id']);
}
break;
default:
header("HTTP/1.0 405 Method Not Allowed");
break;
}
Contents of the file: /payment-report-system/payment-report-system/frontend/views/index.html
Sistema de Reportes de Pago