Identitas Peserta Posyandu

{source}
<link href="https://cdn.jsdelivr.net/npm/This email address is being protected from spambots. You need JavaScript enabled to view it./dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-GLhlTQ8iRABdZLl6O3oVMWSktQOp6b7In1Zl3/Jr59b6EGGoI1aFkw7cmDA6j6gD" crossorigin="anonymous">
<?php
include JPATH_SITE."/config/db_connect_d.php";
$user =& JFactory::getUser();
$result = $connect_d->query("SELECT nama_anak FROM tb_user WHERE username='$user->username'");
$row_cnt = $result->num_rows;if($row_cnt==0){
echo" Anda belum mendaftarkan bayi/balita anda, </br>untuk mendaftar silahkan klik tombol dibawah ini</br></br>
";
}
else{
$result = $connect_d->query("SELECT * FROM tb_user WHERE username='$user->username'"); echo"<table style='width:100%'; >";
echo"<tr style='background-color: #afeeee;'>
<th style='text-align: center;'>Nama Ibu</th>
<th style='text-align: center;'>Nama Anak</th>
<th style='text-align: center;'>Tanggal Lahir</th>
<th style='text-align: center;'>Jenis Kelamin</th>
<th style='text-align: center;'>Berat Badan Saat lahir</th>
<th style='text-align: center;'>Lokasi Posyandu</th>
<th style='text-align: center;'>Tindakan</th>
</tr>";
foreach ($result as $row) {
$sourcedate = $row['tanggal_lahir'];
$date = new DateTime($sourcedate);
$id_user = $row['id_user'];
echo "<tr>
<td style='text-align: center;'> " . $row['nama_ibu'] . "</td>
<td style='text-align: center;'>" . $row['nama_anak'] . "</td>
<td style='text-align: center;'>" . $date->format('d-M-Y') . "</td>
<td style='text-align: center;'>" . $row['jenis_kelamin'] . "</td>
<td style='text-align: center;'>" . $row['bb_saat_lahir'] . "</td>
<td style='text-align: center;'>" . $row['lokasi_posyandu'] . "</td>
<td style='text-align: center;'>
<a href='../ubah-daftar-peserta-posyandu?id_user=$id_user' class='btn btn-warning' role='button'>Ubah</a>
<button type='button' data-id='" . $row['id_user'] . "' class='deleteData btn btn-danger' data-bs-toggle='modal' data-bs-target='#exampleModal'>Hapus</button>
<a href='../skoring' class='btn btn-primary' role='button'>Skoring</a>
</td>
</tr>
<!-- Modal -->
<div class='modal fade' id='exampleModal' tabindex='-1' aria-labelledby='exampleModalLabel' aria-hidden='true'>
<div class='modal-dialog'>
<div class='modal-content'>
<div class='modal-header'>
<h5 class='modal-title' id='exampleModalLabel'>Hapus Data Peserta Posyandu</h5>
<button type='button' class='btn-close' data-bs-dismiss='modal' aria-label='Batal'></button>
</div>
<div class='modal-body'>
</div>
<div class='modal-footer'>
</div>
</div>
</div>
</div>
";
}
echo"</table>";
}
echo"</br><a href='../buat-data-peserta' class='btn btn-success' role='button'>Tambah Data</a>";
?>

<script src="https://cdn.jsdelivr.net/npm/This email address is being protected from spambots. You need JavaScript enabled to view it./dist/js/bootstrap.bundle.min.js" integrity="sha384-w76AqPfDkMBDXo30jS1Sgez6pr3x5MlQ1ZAGC+nuZB+EYdgRZgiwxhTBTkF7CXvN" crossorigin="anonymous"></script>

<script type="text/javascript">
$(document).on("click", ".deleteData", function () {
var user_id = $(this).data('id');
var str_body = "Apakah anda yakin akan menghapus data peserta posyandu? ";
var str_footer = "<button type='button' class='btn btn-secondary' data-bs-dismiss='modal'> Batal</button><a href='../hapus-data-peserta-posyandu?id_user=" + user_id + "' class='btn btn-danger'>Hapus</a>";
$(".modal-body").html(str_body);
$(".modal-footer").html(str_footer);
});
</script>
{/source}

 

Pemeriksaan Bayi & Balita Sehat

  1. Pemeriksaan Status Gizi
  2. Pemberian ASI
  3. Pemeriksaan Fisik 10 Tanda Balita Sehat
  4. Perkembangan Bayi & Balita Sehat
  5. Status Imunisasi

 

Pemeriksaan Status Gizi

{source}

<link href="https://cdn.jsdelivr.net/npm/This email address is being protected from spambots. You need JavaScript enabled to view it./dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-GLhlTQ8iRABdZLl6O3oVMWSktQOp6b7In1Zl3/Jr59b6EGGoI1aFkw7cmDA6j6gD" crossorigin="anonymous">

<?php

include JPATH_SITE."/config/db_connect_d.php";
include JPATH_SITE."/asset/variabel.php";

$id_user_anak = $_POST['id_user_anak'];
$user =& JFactory::getUser();
$result = $connect_d->query("SELECT * FROM tb_user WHERE username='$user->username'");
$row_cnt = $result->num_rows;
$row = $result->fetch_array();

$id_user = $row['id_user'];

//cek apakah anak udah terdaftar
if($row_cnt=='0'){
    echo" Anda belum mendaftarkan bayi/balita anda, </br>untuk mendaftar silahkan klik tombol dibawah ini</br></br>
    <a class='btn btn-primary' href='buat-data-peserta' role='button'>Daftar</a></br></br>";
}

if($row_cnt==1){

    $result1 = $connect_d->query("SELECT * FROM tb_user WHERE username='$user->username'");
    $data1 = $result1->fetch_array();

    $id_user = $data1['id_user'];
    $nama_ibu = $data1['nama_ibu'];
    $nama_anak = $data1['nama_anak'];
    $bb_saat_lahir = $data1['bb_saat_lahir'];
    $sourcedate = $data1['tanggal_lahir'];
    $date = new DateTime($sourcedate);
    $ubah_tgl_lahir = $date->format('d-M-Y');

    $result2 = $connect_d->query("SELECT * FROM tb_skoring WHERE id_user='$id_user'");
    foreach ($result2 as $data2) {
    $variabel = $data2['variabel'];
        if($variabel==$bb){$nilai_bb_saat_lahir=$data2['nilai'];}
        if($variabel==$vitamin_a){$nilai_pemberian_vit_a=$data2['nilai'];}
        if($variabel==$mp_asi){$nilai_pemberian_mp_asi=$data2['nilai'];}
                }

$total = $nilai_bb_saat_lahir+$nilai_pemberian_vit_a+$nilai_pemberian_mp_asi;

}

if($row_cnt>1){
    echo"<form class='form-inline' action='pemeriksaan-status-gizi' enctype='multipart/form-data' method='post'>
        <div class='form-group mb-2'>
            <p style='text-align: center;'><label>Nama Anak</label>
                <select class='custom-select mr-sm-2' id='inlineFormCustomSelect' name='id_user_anak'>";
    $result = $connect_d->query("SELECT * FROM tb_user WHERE username='$user->username'");
        foreach ($result as $row) {
        $nama_anak = $row['nama_anak'];
        $id_user = $row['id_user'];
        echo "<option value='$id_user'>$nama_anak </option>";
    }
    echo"</select>
            <button type='submit' class='btn btn-primary mb-2 btn-sm'>Pilih</button></p>
        </div>
    </form>";
        if(isset($id_user_anak)){
            $result3 = $connect_d->query("SELECT * FROM tb_user WHERE id_user='$id_user_anak'");
            $data3 = $result3->fetch_array();
            $id_user = $data3['id_user'];
            $nama_ibu = $data3['nama_ibu'];
            $nama_anak = $data3['nama_anak'];
            $bb_saat_lahir = $data3['bb_saat_lahir'];
            $sourcedate3 = $data3['tanggal_lahir'];
            $date3 = new DateTime($sourcedate3);
            $ubah_tgl_lahir = $date3->format('d-M-Y');

            $result2 = $connect_d->query("SELECT * FROM tb_skoring WHERE id_user='$id_user'");
            foreach ($result2 as $data2) {
                $variabel = $data2['variabel'];
                if($variabel==$bb){$nilai_bb_saat_lahir=$data2['nilai'];}
                if($variabel==$vitamin_a){$nilai_pemberian_vit_a=$data2['nilai'];}
                if($variabel==$mp_asi){$nilai_pemberian_mp_asi=$data2['nilai'];}
            }

        $total = $nilai_bb_saat_lahir+$nilai_pemberian_vit_a+$nilai_pemberian_mp_asi;

        }
        //default pilihan anak
        else{
            $result3 = $connect_d->query("SELECT * FROM tb_user WHERE id_user='$id_user'");
            $data3 = $result3->fetch_array();
            $id_user = $data3['id_user'];
            $nama_ibu = $data3['nama_ibu'];
            $nama_anak = $data3['nama_anak'];
            $bb_saat_lahir = $data3['bb_saat_lahir'];
            $sourcedate3 = $data3['tanggal_lahir'];
            $date3 = new DateTime($sourcedate3);
            $ubah_tgl_lahir = $date3->format('d-M-Y');

            $result2 = $connect_d->query("SELECT * FROM tb_skoring WHERE id_user='$id_user'");
            foreach ($result2 as $data2) {
                $variabel = $data2['variabel'];
                if($variabel==$bb){$nilai_bb_saat_lahir=$data2['nilai'];}
                if($variabel==$vitamin_a){$nilai_pemberian_vit_a=$data2['nilai'];}
                if($variabel==$mp_asi){$nilai_pemberian_mp_asi=$data2['nilai'];}
            }

        $total = $nilai_bb_saat_lahir+$nilai_pemberian_vit_a+$nilai_pemberian_mp_asi;
        }
}

    echo"
    <table>
        <tr>
            <td>Nama Ibu</td><td>: $nama_ibu</td>
        </tr>
        <tr>
            <td>Nama Anak</td><td>: $nama_anak</td>
        </tr>
        <tr>
            <td>Tanggal lahir</td><td>: $ubah_tgl_lahir</td>
        </tr>
    </table>";

        echo"
        <table class='table table-bordered border-primary' style='border-collapse: collapse; width: 100.032%; height: 281.8px;' border='1'>
            <tbody>
                <tr style='background-color: #00ffff;'>
                    <th style='width: 39.5135%; text-align: center; height: 41.8px; background-color: #00ffff;'>Variabel</th>
                    <th style='width: 26.2462%; text-align: center; height: 41.8px;'>Nilai Variabel</th>
                    <th style='width: 24.708%; text-align: center; height: 41.8px;'>Skor Nilai</th>
                    <th style='width: 9.51786%; text-align: center; height: 41.8px;'>Nilai</th>
                </tr>
                <tr style='height: 94.4px;'>
                    <td class='align-middle' style='width: 39.5135%; height: 94.4px; text-align: center;'>Berat badan saat lahir</td>
                    <td style='width: 26.2462%; text-align: center; height: 94.4px;'>
                        <ol>
                            <li style='text-align: left;'>≤ 2,5 kg</li>
                            <li style='text-align: left;'>2,5–3,9kg</li>
                            <li style='text-align: left;'>≥ 4kg</li>
                        </ol>
                    </td>
                    <td style='width: 24.708%; text-align: center; height: 94.4px;'>10<br />30<br />20</td>
                    <td class='align-middle' style='width: 39.5135%; height: 94.4px; text-align: center;'>$nilai_bb_saat_lahir</td>
                </tr>
                <tr style='height: 62.4px;'>
                    <td class='align-middle' style='width: 39.5135%; height: 62.4px; text-align: center;'>Pemberian vitamin A</td>
                    <td style='width: 26.2462%; text-align: center; height: 94.4px;'>
                        <ol>
                            <li style='text-align: left;'>Tidak Pernah</li>
                            <li style='text-align: left;'>Terkadang jika ingat</li>
                            <li style='text-align: left;'>Rutin bulan februari dan Agustus</li>
                        </ol>
                    </td>
                    <td style='width: 24.708%; text-align: center; height: 62.4px;'>10<br />20<br />30</td>
                    <td class='align-middle' style='width: 39.5135%; height: 94.4px; text-align: center;'>$nilai_pemberian_vit_a</td>
                </tr>
                <tr style='height: 62.4px;'>
                    <td class='align-middle' style='width: 39.5135%; height: 62.4px; text-align: center;'>Pemberian MP-ASI</td>
                    <td style='width: 26.2462%; text-align: center; height: 94.4px;'>
                        <ol>
                            <li style='text-align: left;'>≤ 4 Bulan</li>
                            <li style='text-align: left;'>&gt; 4 Bulan</li>
                            <li style='text-align: left;'>≥ 6 Bulan</li>
                        </ol>
                    </td>
                    <td style='width: 24.708%; text-align: center; height: 62.4px;'>10<br />20<br />30</td>
                    <td class='align-middle' style='width: 39.5135%; height: 94.4px; text-align: center;'>$nilai_pemberian_mp_asi</td>
                </tr>
                <tr style='height: 20.8px;'>
                    <td style='width: 39.5135%; height: 20.8px; text-align: center;' colspan='2'><strong>Total</strong></td>
                    <td style='width: 26.2462%; height: 20.8px;'> </td>
                    <td style='width: 39.5135%; height: 20.8px; text-align: center;'>$total</td>
                </tr>
            </tbody>
        </table>
<strong>Keterangan Skor</strong></br>
Skor 10 : Kurang</br>
Skor 20 : Cukup</br>
Skor 30 : Baik</br></br>";

    echo"Untuk melakukan pengisian data pemeriksaan status gizi, silahkan klik tombol dibawah ini.";
    echo"</br><a href='buat-pemeriksaan-status-gizi-1?id_user=$id_user' class='btn btn-success' role='button'>isi Data</a>";

?>

<script src="https://cdn.jsdelivr.net/npm/This email address is being protected from spambots. You need JavaScript enabled to view it./dist/js/bootstrap.bundle.min.js" integrity="sha384-w76AqPfDkMBDXo30jS1Sgez6pr3x5MlQ1ZAGC+nuZB+EYdgRZgiwxhTBTkF7CXvN" crossorigin="anonymous"></script>

{/source}

 

Buat Data Peserta Posyandu

{source}

<link href="https://cdn.jsdelivr.net/npm/This email address is being protected from spambots. You need JavaScript enabled to view it./dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-GLhlTQ8iRABdZLl6O3oVMWSktQOp6b7In1Zl3/Jr59b6EGGoI1aFkw7cmDA6j6gD" crossorigin="anonymous">

<?php
$user =& JFactory::getUser();

echo"
<form action='insert-data-user' enctype='multipart/form-data' method='post'>
<table>
    <tbody>
        <tr>
            <td>User Name</td>
            <td>:</td>
            <td><input name='cUserName' type='text' value='$user->username' disabled/></td>
        </tr>
        <tr>
            <td>Nama Anak</td>
            <td>:</td>
            <td><input name='cNamaAnak' required='' type='text' /></td>
        </tr>
        <tr>
            <td>Jenis Kelamin</td>
            <td>:</td>
            <td>
                <input type='radio' required='' name='cJenisKelamin' value='laki-laki'> Laki-laki
                <input type='radio' required='' name='cJenisKelamin' value='perempuan'> Perempuan
            </td>

        </tr>
        <tr>
            <td>Tanggal Lahir</td>
            <td>:</td>
            <td><input class='input-tanggal' name='cDate' required='' type='date' /></td>
        </tr>
        <tr>
            <td>Berat Badan Saat Lahir</td>
            <td>:</td>
            <td><input name='cBBsaatlahir' required='' type='number' placeholder='0.0' required='' step='0.1' /></td>
            <td>Kg</td>
        </tr>
        <tr>
            <td>Nama Ibu</td>
            <td>:</td>
            <td><input name='cNamaIbu' type='text' value='$user->name'/> </td>
        </tr>
        <tr>
            <td>Lokasi Posyandu</td>
            <td>:</td>
            <td><input name='cLokasiPosyandu' required='' type='text' /></td>
        </tr>
        <tr>
        <td colspan='3' align='right'><input class='btn btn-secondary' type='submit' value='Simpan' /> <a href='skoring/daftar-peserta-posyandu' class='btn btn-secondary' role='button' />Batal</a></td>
        </tr>
    </tbody>
</table>
</form>";
?>

<script src="https://cdn.jsdelivr.net/npm/This email address is being protected from spambots. You need JavaScript enabled to view it./dist/js/bootstrap.bundle.min.js" integrity="sha384-w76AqPfDkMBDXo30jS1Sgez6pr3x5MlQ1ZAGC+nuZB+EYdgRZgiwxhTBTkF7CXvN" crossorigin="anonymous"></script>

{/source}

{source}
<link href="https://cdn.jsdelivr.net/npm/This email address is being protected from spambots. You need JavaScript enabled to view it./dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-GLhlTQ8iRABdZLl6O3oVMWSktQOp6b7In1Zl3/Jr59b6EGGoI1aFkw7cmDA6j6gD" crossorigin="anonymous">

<?php
include JPATH_SITE."/config/db_connect_d.php";
include JPATH_SITE."/asset/variabel.php";

$id_user_anak = $_GET['id_user_anak'];
$user =& JFactory::getUser();

date_default_timezone_set('Asia/Jakarta');
$year = date('Y');
$month = date('m');

$sql = $connect_d->query("SELECT nama_anak FROM tb_user WHERE username='$user->username'");
$row_cnt = $sql->num_rows;

if($row_cnt=='0'){
    echo" Anda belum mendaftarkan bayi/balita anda, </br>untuk mendaftar silahkan klik tombol dibawah ini</br></br>
    <a class='btn btn-primary' href='../buat-data-peserta' role='button'>Daftar</a></br>";
}
else if($row_cnt=='1'){
    $result1 = $connect_d->query("SELECT * FROM tb_user WHERE username='$user->username'");
    $data1 = $result1->fetch_array();

    $id_user = $data1['id_user'];
    $nama_ibu = $data1['nama_ibu'];
    $nama_anak = $data1['nama_anak'];
    $sourcedate = $data1['tanggal_lahir'];
    $date = new DateTime($sourcedate);
    $ubah_tgl_lahir = $date->format('d-M-Y');

    //cek apakah sudah checklist kehadiran berdasarkan default id anak, bulan dan tahun skr
    $result2 = $connect_d->query("SELECT * FROM tb_checklist_kehadiran WHERE id_user='$id_user' AND MONTH(tanggal_kehadiran)='$month' AND YEAR(tanggal_kehadiran)='$year'");
    $row_cnt2 = $result2->num_rows;

    //jika tidak ada data pada tabel 
    if($row_cnt2==0){
        echo"Untuk mengisi daftar kehadiran, tekan tombol dibawah ini saat anda datang ke posyandu.<br>";
        //pop up modal
        echo"
        <script src='https://cdn.jsdelivr.net/npm/This email address is being protected from spambots. You need JavaScript enabled to view it..1/dist/sweetalert2.all.min.js'></script>
        <link rel='stylesheet' href='https://cdn.jsdelivr.net/npm/This email address is being protected from spambots. You need JavaScript enabled to view it..1/dist/sweetalert2.min.css'>
        <button class='third'>Checklist Kehadiran</button>
        <script>
            document.querySelector('.third').addEventListener('click', function(){
          Swal.fire('Checklist Kehadiran', 'Anda telah mengisi checklist kehadiran bulan ini!', 'success').then((result) => {
           if (result.value) {
             window.location.href = `../buat-checklist-kehadiran?id_user=$id_user`
           }
         });
        });
        </script>";
    }
    //jika data ada pada tabel
    else{
        $result4 = $connect_d->query("SELECT YEAR(tanggal_kehadiran) AS tahun_hadir, MONTH(tanggal_kehadiran) AS bulan_hadir, usia_anak FROM tb_checklist_kehadiran WHERE id_user='$id_user'");
        foreach ($result4 as $data4){
            $tahun_hadir = $data4['tahun_hadir'];
            $bulan_hadir = $data4['bulan_hadir'];
            $usia_anak = $data4['usia_anak'];

            if($bulan_hadir=='01' && $usia_anak='1'){$jan1='✓';}
            else if($bulan_hadir=='01' && $usia_anak='2'){$jan2='✓';}
            else if($bulan_hadir=='01' && $usia_anak='3'){$jan3='✓';}
            else if($bulan_hadir=='01' && $usia_anak='4'){$jan4='✓';}
            else if($bulan_hadir=='01' && $usia_anak='5'){$jan5='✓';}
            else if($bulan_hadir=='02' && $usia_anak='1'){$feb1='✓';}
            else if($bulan_hadir=='02' && $usia_anak='2'){$feb2='✓';}
            else if($bulan_hadir=='02' && $usia_anak='3'){$feb3='✓';}
            else if($bulan_hadir=='02' && $usia_anak='4'){$feb4='✓';}
            else if($bulan_hadir=='02' && $usia_anak='5'){$feb5='✓';}
            else if($bulan_hadir=='03' && $usia_anak='1'){$mar1='✓';}
            else if($bulan_hadir=='03' && $usia_anak='2'){$mar2='✓';}
            else if($bulan_hadir=='03' && $usia_anak='3'){$mar3='✓';}
            else if($bulan_hadir=='03' && $usia_anak='4'){$mar4='✓';}
            else if($bulan_hadir=='03' && $usia_anak='5'){$mar5='✓';}
            else if($bulan_hadir=='04' && $usia_anak='1'){$apr1='✓';}
            else if($bulan_hadir=='04' && $usia_anak='2'){$apr2='✓';}
            else if($bulan_hadir=='04' && $usia_anak='3'){$apr3='✓';}
            else if($bulan_hadir=='04' && $usia_anak='4'){$apr4='✓';}
            else if($bulan_hadir=='04' && $usia_anak='5'){$apr5='✓';}
            else if($bulan_hadir=='05' && $usia_anak='1'){$mei1='✓';}
            else if($bulan_hadir=='05' && $usia_anak='2'){$mei2='✓';}
            else if($bulan_hadir=='05' && $usia_anak='3'){$mei3='✓';}
            else if($bulan_hadir=='05' && $usia_anak='4'){$mei4='✓';}
            else if($bulan_hadir=='05' && $usia_anak='5'){$mei5='✓';}
            else if($bulan_hadir=='06' && $usia_anak='1'){$jun1='✓';}
            else if($bulan_hadir=='06' && $usia_anak='2'){$jun2='✓';}
            else if($bulan_hadir=='06' && $usia_anak='3'){$jun3='✓';}
            else if($bulan_hadir=='06' && $usia_anak='4'){$jun4='✓';}
            else if($bulan_hadir=='06' && $usia_anak='5'){$jun5='✓';}
            else if($bulan_hadir=='07' && $usia_anak='1'){$jul1='✓';}
            else if($bulan_hadir=='07' && $usia_anak='2'){$jul2='✓';}
            else if($bulan_hadir=='07' && $usia_anak='3'){$jul3='✓';}
            else if($bulan_hadir=='07' && $usia_anak='4'){$jul4='✓';}
            else if($bulan_hadir=='07' && $usia_anak='5'){$jul5='✓';}
            else if($bulan_hadir=='08' && $usia_anak='1'){$aug1='✓';}
            else if($bulan_hadir=='08' && $usia_anak='2'){$aug2='✓';}
            else if($bulan_hadir=='08' && $usia_anak='3'){$aug3='✓';}
            else if($bulan_hadir=='08' && $usia_anak='4'){$aug4='✓';}
            else if($bulan_hadir=='08' && $usia_anak='5'){$aug5='✓';}
            else if($bulan_hadir=='09' && $usia_anak='1'){$sep1='✓';}
            else if($bulan_hadir=='09' && $usia_anak='2'){$sep2='✓';}
            else if($bulan_hadir=='09' && $usia_anak='3'){$sep3='✓';}
            else if($bulan_hadir=='09' && $usia_anak='4'){$sep4='✓';}
            else if($bulan_hadir=='09' && $usia_anak='5'){$sep5='✓';}
            else if($bulan_hadir=='10' && $usia_anak='1'){$okt1='✓';}
            else if($bulan_hadir=='10' && $usia_anak='2'){$okt2='✓';}
            else if($bulan_hadir=='10' && $usia_anak='3'){$okt3='✓';}
            else if($bulan_hadir=='10' && $usia_anak='4'){$okt4='✓';}
            else if($bulan_hadir=='10' && $usia_anak='5'){$okt5='✓';}
            else if($bulan_hadir=='11' && $usia_anak='1'){$nop1='✓';}
            else if($bulan_hadir=='11' && $usia_anak='2'){$nop2='✓';}
            else if($bulan_hadir=='11' && $usia_anak='3'){$nop3='✓';}
            else if($bulan_hadir=='11' && $usia_anak='4'){$nop4='✓';}
            else if($bulan_hadir=='11' && $usia_anak='5'){$nop5='✓';}
            else if($bulan_hadir=='12' && $usia_anak='1'){$des1='✓';}
            else if($bulan_hadir=='12' && $usia_anak='2'){$des2='✓';}
            else if($bulan_hadir=='12' && $usia_anak='3'){$des3='✓';}
            else if($bulan_hadir=='12' && $usia_anak='4'){$des4='✓';}
            else if($bulan_hadir=='12' && $usia_anak='5'){$des5='✓';}
        }

        //menghitung total
        for($a=1;$a<6;$a++){
            $result5 = $connect_d->query("SELECT * FROM tb_checklist_kehadiran WHERE id_user='$id_user' AND usia_anak='$a' AND YEAR(tanggal_kehadiran)='$year'");
            ${'total'.$a}= $result5->num_rows;
        }
    }
    $result3 = $connect_d->query("SELECT * FROM tb_user WHERE id_user='$id_user'");
    $data3 = $result3->fetch_array();
    $nama_ibu = $data3['nama_ibu'];
    $nama_anak = $data3['nama_anak'];
    $sourcedate1 = $data3['tanggal_lahir'];
    $date1 = new DateTime($sourcedate1);
    $ubah_tgl_lahir = $date1->format('d-M-Y');
}
//jika anak lebih dari 1
if($row_cnt>1){
    //form pilihan anak
    echo"<form class='form-inline' action='checklist-kunjungan' enctype='multipart/form-data' method='GET'>
        <div class='form-group mb-2'>
            <p style='text-align: left;'><label>Nama Anak</label>
            <select class='custom-select mr-sm-2' id='inlineFormCustomSelect' name='id_user_anak'>";
            $result = $connect_d->query("SELECT * FROM tb_user WHERE username='$user->username'");
            foreach ($result as $row1) {
                $nama_anak = $row1['nama_anak'];
                $id_user = $row1['id_user'];
                echo "<option value='$id_user' selected>$nama_anak </option>";
            }
            echo"</select>
            <button type='submit' class='btn btn-primary mb-2 btn-sm'>Pilih</button></p>
        </div>
    </form>";

    if(isset($id_user_anak)){$result1 = $connect_d->query("SELECT * FROM tb_user WHERE id_user='$id_user_anak'");}

    //default pilihan anak
    else{
        $result1 = $connect_d->query("SELECT * FROM tb_user WHERE username='$user->username'");
    }

    $data1 = $result1->fetch_array();
    $id_user = $data1['id_user'];
    $nama_ibu = $data1['nama_ibu'];
    $nama_anak = $data1['nama_anak'];
    $sourcedate1 = $data1['tanggal_lahir'];
    $date1 = new DateTime($sourcedate1);
    $ubah_tgl_lahir = $date1->format('d-M-Y');

    //cek apakah sudah checklist kehadiran berdasarkan default id anak, bulan dan tahun skr
    $result2 = $connect_d->query("SELECT * FROM tb_checklist_kehadiran WHERE id_user='$id_user' AND MONTH(tanggal_kehadiran)='$month' AND YEAR(tanggal_kehadiran)='$year'");
    $row_cnt2 = $result2->num_rows;

    //jika tidak ada data pada tabel 
    if($row_cnt2==0){
        echo"Untuk mengisi daftar kehadiran, tekan tombol dibawah ini saat anda datang ke posyandu.<br>";
        //pop up modal
        echo"
        <script src='https://cdn.jsdelivr.net/npm/This email address is being protected from spambots. You need JavaScript enabled to view it..1/dist/sweetalert2.all.min.js'></script>
        <link rel='stylesheet' href='https://cdn.jsdelivr.net/npm/This email address is being protected from spambots. You need JavaScript enabled to view it..1/dist/sweetalert2.min.css'>
        <button class='third'>Checklist Kehadiran</button>
        <script>
            document.querySelector('.third').addEventListener('click', function(){
          Swal.fire('Checklist Kehadiran', 'Anda telah mengisi checklist kehadiran bulan ini!', 'success').then((result) => {
           if (result.value) {
             window.location.href = `../buat-checklist-kehadiran?id_user=$id_user`
           }
         });
        });
        </script>";
    }

    //jika data ada pada tabel
    else{
        $result4 = $connect_d->query("SELECT YEAR(tanggal_kehadiran) AS tahun_hadir, MONTH(tanggal_kehadiran) AS bulan_hadir, usia_anak FROM tb_checklist_kehadiran WHERE id_user='$id_user'");
        foreach ($result4 as $data4){
            $tahun_hadir = $data4['tahun_hadir'];
            $bulan_hadir = $data4['bulan_hadir'];
            $usia_anak = $data4['usia_anak'];

            if($bulan_hadir=='01' && $usia_anak='1'){$jan1='✓';}
            else if($bulan_hadir=='01' && $usia_anak='2'){$jan2='✓';}
            else if($bulan_hadir=='01' && $usia_anak='3'){$jan3='✓';}
            else if($bulan_hadir=='01' && $usia_anak='4'){$jan4='✓';}
            else if($bulan_hadir=='01' && $usia_anak='5'){$jan5='✓';}
            else if($bulan_hadir=='02' && $usia_anak='1'){$feb1='✓';}
            else if($bulan_hadir=='02' && $usia_anak='2'){$feb2='✓';}
            else if($bulan_hadir=='02' && $usia_anak='3'){$feb3='✓';}
            else if($bulan_hadir=='02' && $usia_anak='4'){$feb4='✓';}
            else if($bulan_hadir=='02' && $usia_anak='5'){$feb5='✓';}
            else if($bulan_hadir=='03' && $usia_anak='1'){$mar1='✓';}
            else if($bulan_hadir=='03' && $usia_anak='2'){$mar2='✓';}
            else if($bulan_hadir=='03' && $usia_anak='3'){$mar3='✓';}
            else if($bulan_hadir=='03' && $usia_anak='4'){$mar4='✓';}
            else if($bulan_hadir=='03' && $usia_anak='5'){$mar5='✓';}
            else if($bulan_hadir=='04' && $usia_anak='1'){$apr1='✓';}
            else if($bulan_hadir=='04' && $usia_anak='2'){$apr2='✓';}
            else if($bulan_hadir=='04' && $usia_anak='3'){$apr3='✓';}
            else if($bulan_hadir=='04' && $usia_anak='4'){$apr4='✓';}
            else if($bulan_hadir=='04' && $usia_anak='5'){$apr5='✓';}
            else if($bulan_hadir=='05' && $usia_anak='1'){$mei1='✓';}
            else if($bulan_hadir=='05' && $usia_anak='2'){$mei2='✓';}
            else if($bulan_hadir=='05' && $usia_anak='3'){$mei3='✓';}
            else if($bulan_hadir=='05' && $usia_anak='4'){$mei4='✓';}
            else if($bulan_hadir=='05' && $usia_anak='5'){$mei5='✓';}
            else if($bulan_hadir=='06' && $usia_anak='1'){$jun1='✓';}
            else if($bulan_hadir=='06' && $usia_anak='2'){$jun2='✓';}
            else if($bulan_hadir=='06' && $usia_anak='3'){$jun3='✓';}
            else if($bulan_hadir=='06' && $usia_anak='4'){$jun4='✓';}
            else if($bulan_hadir=='06' && $usia_anak='5'){$jun5='✓';}
            else if($bulan_hadir=='07' && $usia_anak='1'){$jul1='✓';}
            else if($bulan_hadir=='07' && $usia_anak='2'){$jul2='✓';}
            else if($bulan_hadir=='07' && $usia_anak='3'){$jul3='✓';}
            else if($bulan_hadir=='07' && $usia_anak='4'){$jul4='✓';}
            else if($bulan_hadir=='07' && $usia_anak='5'){$jul5='✓';}
            else if($bulan_hadir=='08' && $usia_anak='1'){$aug1='✓';}
            else if($bulan_hadir=='08' && $usia_anak='2'){$aug2='✓';}
            else if($bulan_hadir=='08' && $usia_anak='3'){$aug3='✓';}
            else if($bulan_hadir=='08' && $usia_anak='4'){$aug4='✓';}
            else if($bulan_hadir=='08' && $usia_anak='5'){$aug5='✓';}
            else if($bulan_hadir=='09' && $usia_anak='1'){$sep1='✓';}
            else if($bulan_hadir=='09' && $usia_anak='2'){$sep2='✓';}
            else if($bulan_hadir=='09' && $usia_anak='3'){$sep3='✓';}
            else if($bulan_hadir=='09' && $usia_anak='4'){$sep4='✓';}
            else if($bulan_hadir=='09' && $usia_anak='5'){$sep5='✓';}
            else if($bulan_hadir=='10' && $usia_anak='1'){$okt1='✓';}
            else if($bulan_hadir=='10' && $usia_anak='2'){$okt2='✓';}
            else if($bulan_hadir=='10' && $usia_anak='3'){$okt3='✓';}
            else if($bulan_hadir=='10' && $usia_anak='4'){$okt4='✓';}
            else if($bulan_hadir=='10' && $usia_anak='5'){$okt5='✓';}
            else if($bulan_hadir=='11' && $usia_anak='1'){$nop1='✓';}
            else if($bulan_hadir=='11' && $usia_anak='2'){$nop2='✓';}
            else if($bulan_hadir=='11' && $usia_anak='3'){$nop3='✓';}
            else if($bulan_hadir=='11' && $usia_anak='4'){$nop4='✓';}
            else if($bulan_hadir=='11' && $usia_anak='5'){$nop5='✓';}
            else if($bulan_hadir=='12' && $usia_anak='1'){$des1='✓';}
            else if($bulan_hadir=='12' && $usia_anak='2'){$des2='✓';}
            else if($bulan_hadir=='12' && $usia_anak='3'){$des3='✓';}
            else if($bulan_hadir=='12' && $usia_anak='4'){$des4='✓';}
            else if($bulan_hadir=='12' && $usia_anak='5'){$des5='✓';}            
        }
        //menghitung total
        for($a=1;$a<6;$a++){
            $result5 = $connect_d->query("SELECT * FROM tb_checklist_kehadiran WHERE id_user='$id_user' AND usia_anak='$a' AND YEAR(tanggal_kehadiran)='$year'");
            ${'total'.$a}= $result5->num_rows;
        }
    }
}
?>
{/source}

Checklist Kunjungan

{source}
<?php
    echo"<table>
        <tr><td>Nama Ibu</td><td>: $nama_ibu</td></tr>
        <tr><td>Nama Anak</td><td>: $nama_anak</td></tr>
        <tr><td>Tanggal Lahir</td><td>: $ubah_tgl_lahir</td></tr>
    </table>";
echo"
<table class='table table-bordered border-primary'>
<thead>
<tr>
<th class='align-middle' scope='col' style='text-align: center;' rowspan='2'>Bulan</th>
<th scope='col' colspan='5' style='text-align: center;'>Usia Anak</th>
</tr>
<tr>
<th scope='col' style='text-align: center;'>1 Tahun</th>
<th scope='col' style='text-align: center;'>2 Tahun</th>
<th scope='col' style='text-align: center;'>3 Tahun</th>
<th scope='col' style='text-align: center;'>4 Tahun</th>
<th scope='col' style='text-align: center;'>5 Tahun</th>
</tr>
</thead>
<tbody>
<tr>
<th scope='row' style='text-align: center;'>Januari</th>
<td style='text-align: center;'>$jan1</td>
<td style='text-align: center;'>$jan2</td>
<td style='text-align: center;'>$jan3</td>
<td style='text-align: center;'>$jan4</td>
<td style='text-align: center;'>$jan5</td>
</tr>
<th scope='row' style='text-align: center;'>Februari</th>
<td style='text-align: center;'>$feb1</td>
<td style='text-align: center;'>$feb2</td>
<td style='text-align: center;'>$feb3</td>
<td style='text-align: center;'>$feb4</td>
<td style='text-align: center;'>$feb5</td>
</tr>
<th scope='row' style='text-align: center;'>Maret</th>
<td style='text-align: center;'>$mar1</td>
<td style='text-align: center;'>$mar2</td>
<td style='text-align: center;'>$mar3</td>
<td style='text-align: center;'>$mar4</td>
<td style='text-align: center;'>$mar5</td>
</tr>
<th scope='row' style='text-align: center;'>April</th>
<td style='text-align: center;'>$apr1</td>
<td style='text-align: center;'>$apr2</td>
<td style='text-align: center;'>$apr3</td>
<td style='text-align: center;'>$apr4</td>
<td style='text-align: center;'>$apr5</td>
</tr>
<th scope='row' style='text-align: center;'>Mei</th>
<td style='text-align: center;'>$mei1</td>
<td style='text-align: center;'>$mei2</td>
<td style='text-align: center;'>$mei3</td>
<td style='text-align: center;'>$mei4</td>
<td style='text-align: center;'>$mei5</td>
</tr>
<th scope='row' style='text-align: center;'>Juni</th>
<td style='text-align: center;'>$jun1</td>
<td style='text-align: center;'>$jun2</td>
<td style='text-align: center;'>$jun3</td>
<td style='text-align: center;'>$jun4</td>
<td style='text-align: center;'>$jun5</td>
</tr>
<th scope='row' style='text-align: center;'>Juli</th>
<td style='text-align: center;'>$jul1</td>
<td style='text-align: center;'>$jul2</td>
<td style='text-align: center;'>$jul3</td>
<td style='text-align: center;'>$jul4</td>
<td style='text-align: center;'>$jul5</td>
</tr>
<th scope='row' style='text-align: center;'>Agustus</th>
<td style='text-align: center;'>$aug1</td>
<td style='text-align: center;'>$aug2</td>
<td style='text-align: center;'>$aug3</td>
<td style='text-align: center;'>$aug4</td>
<td style='text-align: center;'>$aug5</td>
</tr>
<th scope='row' style='text-align: center;'>September</th>
<td style='text-align: center;'>$sep1</td>
<td style='text-align: center;'>$sep2</td>
<td style='text-align: center;'>$sep3</td>
<td style='text-align: center;'>$sep4</td>
<td style='text-align: center;'>$sep5</td>
</tr>
<th scope='row' style='text-align: center;'>Oktober</th>
<td style='text-align: center;'>$okt1</td>
<td style='text-align: center;'>$okt2</td>
<td style='text-align: center;'>$okt3</td>
<td style='text-align: center;'>$okt4</td>
<td style='text-align: center;'>$okt5</td>
</tr>
<th scope='row' style='text-align: center;'>Nopember</th>
<td style='text-align: center;'>$nop1</td>
<td style='text-align: center;'>$nop2</td>
<td style='text-align: center;'>$nop3</td>
<td style='text-align: center;'>$nop4</td>
<td style='text-align: center;'>$nop5</td>
</tr>
<th scope='row' style='text-align: center;'>Desember</th>
<td style='text-align: center;'>$des1</td>
<td style='text-align: center;'>$des2</td>
<td style='text-align: center;'>$des3</td>
<td style='text-align: center;'>$des4</td>
<td style='text-align: center;'>$des5</td>
</tr>
<th scope='row' style='text-align: center;'>Total Kehadiran</th>
<td style='text-align: center;'>$total1</td>
<td style='text-align: center;'>$total2</td>
<td style='text-align: center;'>$total3</td>
<td style='text-align: center;'>$total4</td>
<td style='text-align: center;'>$total5</td>
</tr>
</tbody>
</table>";

?>

{/source}

Page 2 of 2