PHP中如何合并同一患者的所有就诊数据展示？代码问题求助

Alright, let's tackle this problem where you want to display a patient's multiple visit records with their name only appearing once, while all corresponding visit dates and products are aligned properly. Since you didn't share your exact code or tech stack, I'll walk through common solutions for different scenarios—backend processing, frontend rendering, and even database-level fixes.

1. Backend Processing with Python Pandas #

If you're handling data in Python (a common workflow for healthcare data), you can use Pandas to clean and transform the data before displaying it:

import pandas as pd

# Sample patient data (replace with your actual dataset)
patient_records = {
    'Name': ['Ali', 'Ali', 'Ali', 'Sarah', 'Sarah'],
    'Visits Date': ['1 May', '2 May', '3 May', '10 May', '15 May'],
    'Product': ['test', 'test 2', 'test 3', 'drug A', 'drug B']
}

df = pd.DataFrame(patient_records)

# Group by Name, keep only the first occurrence of the name in each group
df['Name'] = df.groupby('Name')['Name'].transform(
    lambda group: [group.iloc[0]] + [''] * (len(group) - 1)
)

# Output as markdown table (or send this processed DataFrame to your frontend)
print(df.to_markdown(index=False))

This will output exactly the table format you want:

2. Frontend Rendering with JavaScript #

If you're working with client-side data (e.g., fetching records via API), you can process and render the table directly in the browser:

// Sample API response data
const patientData = [
    { Name: 'Ali', 'Visits Date': '1 May', Product: 'test' },
    { Name: 'Ali', 'Visits Date': '2 May', Product: 'test 2' },
    { Name: 'Ali', 'Visits Date': '3 May', Product: 'test 3' },
    { Name: 'Sarah', 'Visits Date': '10 May', Product: 'drug A' },
    { Name: 'Sarah', 'Visits Date': '15 May', Product: 'drug B' }
];

// Process data to hide duplicate names
let currentPatient = '';
const processedRecords = patientData.map(record => {
    const displayName = record.Name === currentPatient ? '' : record.Name;
    currentPatient = record.Name;
    return { ...record, Name: displayName };
});

// Generate HTML table
function buildTable(data) {
    const table = document.createElement('table');
    table.border = '1';

    // Add header row
    const headerRow = table.insertRow();
    Object.keys(data[0]).forEach(key => {
        const th = document.createElement('th');
        th.textContent = key;
        headerRow.appendChild(th);
    });

    // Add data rows
    data.forEach(record => {
        const row = table.insertRow();
        Object.values(record).forEach(value => {
            const td = document.createElement('td');
            td.textContent = value;
            row.appendChild(td);
        });
    });

    return table;
}

// Append table to your page
document.body.appendChild(buildTable(processedRecords));

3. Database-Level Fix with SQL #

If you're fetching data directly from a database, you can use window functions to format the name column during the query:

SELECT
    -- Only show the name on the first row of each patient's records
    CASE
        WHEN ROW_NUMBER() OVER (PARTITION BY Name ORDER BY "Visits Date") = 1 THEN Name
        ELSE ''
    END AS Name,
    "Visits Date",
    Product
FROM patient_records
-- Ensure records are sorted by patient name and visit date
ORDER BY Name, "Visits Date";

Key Notes to Avoid Issues #

• Always sort first: Make sure your data is sorted by patient name (and visit date, if needed) before applying any grouping/duplicate-hiding logic. Unsorted data will lead to broken formatting.
• Handle edge cases: If a patient has only one visit, their name will display correctly (no empty values).
• Debug your existing code: If your current code isn't running, check for syntax errors, missing dependencies (like Pandas if using Python), or incorrect data structure (e.g., your dataset might not have a consistent Name column).

内容的提问来源于stack exchange，提问作者Hamza Ali