get($cacheKey); if ($cachedResult) { echo $cachedResult; exit; } } // 如果没有缓存，则查询数据库 $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); // 构建输出 $output = "

"; $output .= "

"; $output .= "

{$debtor['debtor_name']}

"; $output .= "

当前欠款余额: ¥{$viewData['剩余欠款金额']}

"; $output .= "

"; $output .= "

"; $output .= "

还款记录

"; if ($repayments) { $output .= "

"; foreach ($repayments as $repayment) { $output .= "

"; $output .= "

日期: {$repayment['repayment_date']}

"; $output .= "

"; $output .= "

金额: ¥{$repayment['repayment_amount']}

"; $output .= "

支付方式: {$repayment['repayment_method']}

"; if (!empty($repayment['comments'])) { $output .= "

备注: {$repayment['comments']}

"; } $output .= "

"; $output .= "

"; } $output .= "

"; } else { $output .= "

暂无还款记录

"; } $output .= "

"; $output .= "

"; // 如果Redis可用，缓存结果 if ($REDIS_ENABLED) { $redis->setex($cacheKey, 60, $output); } echo $output; } else { echo "

未找到相关记录

"; } } ?>