Identitas Peserta Posyandu
{source}
<link href="https://cdn.jsdelivr.net/npm/
<?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/
<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
- Pemeriksaan Status Gizi
- Pemberian ASI
- Pemeriksaan Fisik 10 Tanda Balita Sehat
- Perkembangan Bayi & Balita Sehat
- Status Imunisasi
Pemeriksaan Status Gizi
{source}
<link href="https://cdn.jsdelivr.net/npm/
<?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;'>> 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/
{/source}
Buat Data Peserta Posyandu
{source}
<link href="https://cdn.jsdelivr.net/npm/
<?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/
{/source}
{source}
<link href="https://cdn.jsdelivr.net/npm/
<?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/
<link rel='stylesheet' href='https://cdn.jsdelivr.net/npm/
<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/
<link rel='stylesheet' href='https://cdn.jsdelivr.net/npm/
<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