$n = 1;
$sql1 = "SELECT * FROM `kegiatan`";
$query1 = mysql_query($sql1);
$jml = mysql_num_rows($query1);
while ($d1 = mysql_fetch_array($query1)) {
if ($n != $jml) {
$sql .= "SUM(IF(absen.kd_kegiatan='{$d1['kd_kegiatan']}',1,0)) as {$d1['nm_singkat']},";
} else {
$sql .= "SUM(IF(absen.kd_kegiatan='{$d1['kd_kegiatan']}',1,0)) as {$d1['nm_singkat']} ";
}
$n++;
}
$sql .= "FROM\nabsen\nINNER JOIN dokter_pembimbing ON absen.kd_pembimbing = dokter_pembimbing.id_dokter_pembimbing\nINNER JOIN kegiatan ON absen.kd_kegiatan = kegiatan.kd_kegiatan ";
if ($_GET['aksi'] == 'filter_data') {
$tgl1 = __convert_date($_GET['tgl1']);
$tgl2 = __convert_date($_GET['tgl2']);
$sql .= "where tgl_absen BETWEEN '{$tgl1}' and '{$tgl2}' ";
}
$sql .= "GROUP BY nama\n";
//WHERE absen.tgl_absen BETWEEN '$thn_sekarang-$bln_sekarang-01' AND '$thn_sekarang-$bln_sekarang-31'
//echo $sql;
$query = mysql_query($sql);
$no = 1;
while ($r = mysql_fetch_array($query)) {
$s++;
?>
<tr>
<?php
<th>Kegiatan</th>
<th>Satuan</th>
<th>Jumlah</th>
<th>Jumlah Total</th>
</tr>
</thead>
<tbody>
<?php
$t_jml = 0;
$t_total = 0;
$no = 1;
$sql3 = "SELECT * from kegiatan";
$query3 = mysql_query($sql3);
while ($d3 = mysql_fetch_array($query3)) {
$tgl1 = __convert_date($_POST['tgl1']);
$tgl2 = __convert_date($_POST['tgl2']);
$sql = "SELECT Sum(IF (absen.kd_kegiatan = '{$d3['kd_kegiatan']}', 1, 0)) AS jml FROM absen WHERE kd_pembimbing='{$_POST['kd_pembimbing']}' \n and tgl_absen BETWEEN '{$tgl1}' and '{$tgl2}'";
$query = mysql_query($sql);
$d = mysql_fetch_array($query);
$jml = $d['jml'];
$satuan = $d3['satuan'];
$total = $jml * $satuan;
$t_jml = $t_jml + $jml;
$t_total = $t_total + $total;
echo "<tr>\n <td>{$no}</td>\n <td>{$d3['nm_kegiatan']}</td>\n <td>";
echo formatRupiah2($d3['satuan']);
echo "</td>\n <td>{$jml}</td>\n <td>";
echo formatRupiah2($total);
echo "</td>\n </tr> ";
$no++;
}
?>
'> </td>
</tr>
<tr><td colspan=3><button class=btn>Proses</button></td></tr>
</tbody> </table>
<input type="hidden" name="aksi" value="cari_data" />
<input type="hidden" name="module" value="kartu_pembimbing" />
</form>
<div class="clearfix"></div>
<?php
if ($_GET['aksi'] == 'cari_data') {
$tgl1 = __convert_date($_GET['tgl1']);
$kd_pembimbing = $_GET['kd_pembimbing'];
$sql2 = "SELECT * from dokter_pembimbing where id_dokter_pembimbing='{$_GET['kd_pembimbing']}'";
//echo $sql2;
$query2 = mysql_query($sql2);
$d2 = mysql_fetch_array($query2);
$tgl2 = adddate($tgl1, "+1 day");
$tgl3 = adddate($tgl1, "+2 day");
$tgl4 = adddate($tgl1, "+3 day");
$tgl5 = adddate($tgl1, "+4 day");
$date1 = get_date($tgl1);
$date2 = get_date($tgl2);
$date3 = get_date($tgl3);
$date4 = get_date($tgl4);
$date5 = get_date($tgl5);
echo "\n <hr>\n <center><h4>Rincian Kegiatan Pembimbing Klinik</h4></center><br>\n Tanggal : <b>" . tgl_indo($tgl1) . "</b> s.d. <b>" . tgl_indo($tgl5) . "</b><br><br>\n <button class=btn id='cetak'> Cetak</button>\n <table class='table table-bordered table-mod-2'>\n <tr>\n <th rowspan='2' scope='col'>No</th>\n <th rowspan='2' scope='col'>Kegiatan</th>\n <th scope='col'>" . convert_hari($tgl1) . "</th>\n <th scope='col'>" . convert_hari($tgl2) . "</th>\n <th scope='col'>" . convert_hari($tgl3) . "</th>\n <th scope='col'>" . convert_hari($tgl4) . "</th>\n <th scope='col'>" . convert_hari($tgl5) . "</th>\n <th rowspan='2' scope='col'>Jumlah</th>\n </tr>\n <tr>\n <td align='center'>{$date1}</td>\n <td align='center'>{$date2}</td>\n <td align='center'>{$date3}</td>\n <td align='center'>{$date4}</td>\n <td align='center'>{$date5}</td>\n </tr>";
