Simpan Kode Script - Anti Repot

Script Koleksi Saya

<head>
<style>
    body { font-family: 'Poppins', sans-serif; padding: 15px; color: #333; background-color: #fff; }
    .search-box { 
        background: #f8f9fa; padding: 15px; border-radius: 10px; 
        border: 1px solid #ddd; margin-bottom: 20px;
    }
    .form-group { display: flex; gap: 10px; flex-wrap: wrap; }
    select, input[type="text"] {
        padding: 10px 15px; border-radius: 8px; border: 1px solid #ccc; outline: none;
    }
    select { background-color: #fff; cursor: pointer; flex: 1; min-width: 150px; }
    input[type="text"] { flex: 2; min-width: 200px; }
    input[type="text"]:focus { border-color: #e63946; box-shadow: 0 0 5px rgba(230,57,70,0.2); }
    .text-muted { font-size: 0.9rem; color: #666; }
</style>

if (str.length == 0) { 
        document.getElementById("txtHint").innerHTML = "";
        return;
    }
    
    var xmlhttp = window.XMLHttpRequest ? new XMLHttpRequest() : new ActiveXObject("Microsoft.XMLHTTP");
    
    xmlhttp.onreadystatechange = function() {
        if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
            document.getElementById("txtHint").innerHTML = xmlhttp.responseText;
        }
    }
    // Mengirim q (kata kunci) dan k (kategori)
    xmlhttp.open("GET", "data_pendonor1.php?q=" + encodeURIComponent(str) + "&k=" + kat, true);
    xmlhttp.send();
}
</script>
</head>

<body>
    <div class="search-box">
        <form onsubmit="return false;"> 
            <label class="fw-bold d-block mb-2">Cari Data Pendonor :</label>
            <div class="form-group">
                <select id="kategori" onchange="showHint()">
                    <option value="Kode">ID Pendonor</option>
                    <option value="Nama">Nama Lengkap</option>
                    <option value="Alamat">Alamat</option>
                    <option value="TglLahir">Tgl Lahir (YYYY-MM-DD)</option>
                </select>
                <input type="text" id="txtCari" onkeyup="showHint()" placeholder="Ketik kata kunci..." autocomplete="off" />
            </div>
        </form>
    </div>
    
    <div id="txtHint">
        <p class="text-muted italic">Silakan masukkan data untuk memulai pencarian...</p>
    </div>
</body>

2.data_pendonor1
<?php
if (isset($_GET['q'])) {
    include('../config/db_connect.php');
    
    $today = date('Y-m-d H:i:s');
    $q = mysql_real_escape_string($_GET["q"]);
    $k = isset($_GET["k"]) ? $_GET["k"] : "Kode";

// Logika Query: Jika Nama atau Alamat gunakan LIKE agar fleksibel
    if ($k == "Nama" || $k == "Alamat") {
        $filter = "$k LIKE '%$q%'";
    } else {
        $filter = "$k = '$q'";
    }

// Query Data Pendonor (Limit 5 agar tidak berat jika pencarian terlalu umum)
    $query = mysql_query("SELECT * FROM pendonor WHERE $filter LIMIT 5");
    
    // Ambil detail record pertama untuk cekal & form donor
    $sql_cekal = mysql_query("SELECT cekal, tglkembali, jumDonor, Rhesus, GolDarah, Nama, Kode FROM pendonor WHERE $filter LIMIT 1");
    $cekal1 = mysql_fetch_assoc($sql_cekal);
    
    // Definisikan ID Pendonor yang terpilih untuk history & cetak
    $selected_kode = $cekal1['Kode'];

// Ambil data instansi dan kendaraan
    $instansi = mysql_fetch_assoc(mysql_query("SELECT * FROM detailinstansi WHERE aktif='1'"));
    $kendaraan = mysql_fetch_assoc(mysql_query("SELECT k.kendaraan, d.KodeDetail, d.aktif FROM kegiatan AS k, detailinstansi AS d WHERE k.kodeinstansi=d.KodeDetail AND d.aktif='1'"));

// ------------------------ SET ID TRANSAKSI BARU -------------------------
    $udd1 = mysql_query("SELECT id FROM utd WHERE aktif='1'");
    $udd  = mysql_fetch_assoc($udd1);
    $idp_q = mysql_query("SELECT * FROM tempat_donor WHERE active='1'");
    $idp1  = mysql_fetch_assoc($idp_q);
    $th   = substr(date("Y"), 2, 2);
    $bl   = date("m");
    $tgl  = date("d");
    $kdtp = substr($idp1['id1'], 0, 2) . $tgl . $bl . $th . "-" . $udd['id'] . "-";
    $id_last_q = mysql_query("SELECT NoTrans FROM htransaksi WHERE NoTrans LIKE '$kdtp%' ORDER BY NoTrans DESC");
    $id_last   = mysql_fetch_assoc($id_last_q);
    $idp2 = substr($id_last['NoTrans'], 14, 4);
    if ($idp2 < 1) { $idp2 = "0000"; }
    $idp3 = (int)$idp2 + 1;
    $id31 = strlen($idp2) - strlen($idp3);
    $idp4 = "";
    for ($i = 0; $i < $id31; $i++) { $idp4 .= "0"; }
    $id_transaksi_baru = $kdtp . $idp4 . $idp3;
    // ------------------------------------------------------------------------

if (mysql_num_rows($query) > 0) {
?>

<table bgcolor="#000012" cellspacing="1" cellpadding="3" width="100%" style="margin-bottom: 10px; border-radius: 5px;"> 
    <tr bgcolor="#DDDD12">
        <th style="color: black; padding: 10px;">HASIL PENCARIAN & INFO DONOR KEMBALI</th>
    </tr>
</table>

<table bgcolor="#CCCCCC" cellspacing="1" cellpadding="5" width="100%" style="border-radius: 5px; overflow: hidden;"> 
    <tr bgcolor="#EEEEEE" style="color: black; font-size: 12px;">
        <th>Nama Pendonor</th> 
        <th>Gol Drh</th>
        <th>Jml Donor</th>
        <th>Tgl Kembali</th>
        <th>Status</th>
    </tr>
    <?php while($row = mysql_fetch_object($query)): ?>
        <?php $status_cekal = ($row->cekal == '1') ? '<b style="color:red;">Confirm</b>' : '<b style="color:green;">OK</b>'; ?>
        <tr bgcolor="#FFFFFF" style="font-size: 13px; color: #333;">
            <td><?php echo $row->Nama; ?> (<?php echo $row->Kode; ?>)</td>
            <td align="center"><?php echo $row->GolDarah; ?> (<?php echo $row->Rhesus; ?>)</td>
            <td align="center"><?php echo $row->jumDonor; ?></td>
            <td align="center"><?php echo $row->tglkembali; ?></td>
            <td align="center"><?php echo $status_cekal; ?></td>
        </tr>
    <?php endwhile; ?>
</table>

<div style="margin: 15px 0;">
    <?php if ($cekal1 && $cekal1['cekal'] == "0" && $cekal1['tglkembali'] <= $today): ?>
        <form name="kirim" method="post" action="formulir_donor_PDF.php?kp=<?php echo $selected_kode; ?>" target="_blank">
            <input name="nokan" type="hidden" value="<?php echo $selected_kode; ?>">
            <input name="notrans" type="hidden" value="<?php echo $id_transaksi_baru; ?>">
            <input name="instansi" type="hidden" value="<?php echo $instansi['nama']; ?>">
            <input name="kendaraan" type="hidden" value="<?php echo $kendaraan['kendaraan']; ?>">
            <input type="submit" value="Cetak Form Donor: <?php echo $cekal1['Nama']; ?>" style="background: #28a745; color: white; border: none; padding: 10px 20px; border-radius: 5px; cursor: pointer; font-weight: bold;">
        </form>
    <?php elseif($cekal1): ?>
        <p style="color: #8b0000; font-weight: bold; font-style: italic;">* Pendonor pertama dalam daftar belum waktunya donor kembali atau status ditangguhkan.</p>
    <?php endif; ?>
</div>

<table bgcolor="#000012" cellspacing="1" cellpadding="3" width="100%" style="margin-top: 20px; border-radius: 5px;"> 
    <tr bgcolor="#DDDD12">
        <th style="color: black; padding: 10px;">HISTORY DONOR (BERDASARKAN HASIL PERTAMA)</th>
    </tr>
</table>

<table bgcolor="#CCCCCC" cellspacing="1" cellpadding="5" width="100%" style="border-radius: 5px;"> 
    <tr bgcolor="#EEEEEE" style="color: black; font-size: 11px;">
        <th>No.</th><th>Tanggal</th><th>BB</th><th>Tensi</th><th>Jenis</th><th>Tempat</th><th>Instansi</th><th>Nokantong</th><th>Status Aftap</th>
    </tr>
    <?php
    $no = 1;
    $trans = mysql_query("SELECT Kodependonor, Tgl, Pengambilan, beratBadan, tensi, JenisDonor, tempat, Instansi, NoKantong FROM htransaksi WHERE KodePendonor='$selected_kode' 
                          UNION 
                          SELECT Kodependonor, Tgl, Pengambilan, beratBadan, tensi, JenisDonor, tempat, Instansi, NoKantong FROM htransaksilama WHERE KodePendonor='$selected_kode' 
                          ORDER BY Tgl DESC LIMIT 10");

while ($dtrans = mysql_fetch_assoc($trans)):
        $jenis = ($dtrans['JenisDonor'] == '1') ? 'DP' : 'DS';
        $tempat = ($dtrans['tempat'] == 'M') ? 'MU' : 'DG';
        $st_aftap = ($dtrans['Pengambilan'] == '0') ? "Berhasil" : (($dtrans['Pengambilan'] == '2') ? "Gagal" : "Batal");
    ?>
        <tr bgcolor="#FFFFFF" style="font-size: 12px; color: #333;">
            <td align="center"><?php echo $no++; ?></td>
            <td><?php echo $dtrans['Tgl']; ?></td>
            <td align="right"><?php echo $dtrans['beratBadan']; ?> kg</td>
            <td align="center"><?php echo $dtrans['tensi']; ?></td>
            <td align="center"><?php echo $jenis; ?></td>
            <td align="center"><?php echo $tempat; ?></td>
            <td><?php echo $dtrans['Instansi']; ?></td>
            <td align="center"><?php echo $dtrans['NoKantong']; ?></td>
            <td align="center"><?php echo $st_aftap; ?></td>
        </tr>
    <?php endwhile; ?>
</table>

<?php 
    } else {
        echo "<p style='color:red; font-weight:bold;'>Data tidak ditemukan. Pastikan kata kunci benar.</p>";
    }
} 
?>