Pay_Project/search.php

<?php
require 'config.php';

if (isset($_GET['debtorName'])) {
    $debtorName = $_GET['debtorName'];

    // 检查总欠款数据库中是否存在该姓名
    $stmt = $pdo->prepare("SELECT * FROM Debtors WHERE debtor_name = :debtorName");
    $stmt->execute(['debtorName' => $debtorName]);
    $debtor = $stmt->fetch(PDO::FETCH_ASSOC);

    if ($debtor) {
        // 获取还款记录
        $repaymentStmt = $pdo->prepare("SELECT * FROM Repayments WHERE debtor_name = :debtorName ORDER BY repayment_date DESC");
        $repaymentStmt->execute(['debtorName' => $debtorName]);
        $repayments = $repaymentStmt->fetchAll(PDO::FETCH_ASSOC);

        // 获取视图中的欠款信息
        $viewStmt = $pdo->prepare("SELECT * FROM DebtStatus WHERE 姓名 = :debtorName");
        $viewStmt->execute(['debtorName' => $debtorName]);
        $viewData = $viewStmt->fetch(PDO::FETCH_ASSOC);

        // 更新后的输出格式
        echo "<div class='result-header'>";
        echo "<h2 class='debtor-name'>{$debtor['debtor_name']}</h2>";
        echo "<p class='remaining-debt'>当前欠款余额: <span>¥{$viewData['剩余欠款金额']}</span></p>";
        echo "</div>";

        echo "<div class='repayment-section'>";
        echo "<h3>还款记录</h3>";

        if ($repayments) {
            echo "<div class='repayment-list'>";
            foreach ($repayments as $repayment) {
                echo "<div class='repayment-item'>";
                echo "<div class='repayment-date'>{$repayment['repayment_date']}</div>";
                echo "<div class='repayment-details'>";
                echo "<div class='repayment-amount'>¥{$repayment['repayment_amount']}</div>";
                echo "<div class='repayment-method'>{$repayment['repayment_method']}</div>";
                if (!empty($repayment['comments'])) {
                    echo "<div class='repayment-comment'>{$repayment['comments']}</div>";
                }
                echo "</div>";
                echo "</div>";
            }
            echo "</div>";
        } else {
            echo "<p class='no-repayments'>暂无还款记录</p>";
        }
        echo "</div>";
    } else {
        echo "<div class='no-result'>未找到相关记录</div>";
    }
} else {
    echo "<div class='no-input'>请输入姓名进行查询</div>";
}
?>