<?php
	require("../../config/koneksi.php");
	require("../../config/function.php");
	require("../../config/crud.php");
	require("../../config/dis.php");
	
	(isset($_SESSION['id_user'])) ? $id_user = $_SESSION['id_user'] : $id_user = 0;
	($id_user==0) ? header('location:login.php'):null;
	$id_bank = $_GET['id'];
	
	$user = fetch($koneksi, 'users',array('id_user'=>$id_user));
	$mapel=mysqli_fetch_array(mysqli_query($koneksi, "select * from banksoal where id_bank='$id_bank'"));
	if($mapel['idpk']=='0'){
		$jurusan='Semua Jurusan';
	}else{
		$jurusan=$mapel['idpk'];
	}
	$guru = fetch($koneksi, 'users',array('id_user'=>$mapel['idguru']));
	
	if(date('m')>=7 AND date('m')<=12) {
		$ajaran = date('Y')."/".(date('Y')+1);
	}
	elseif(date('m')>=1 AND date('m')<=6) {
		$ajaran = (date('Y')-1)."/".date('Y');
	}
	?>
	
	
				<style>
		* {
			margin: auto;
			padding: 0;
			line-height: 100%;
		}

		td {
			padding: 1px 3px 1px 3px;
		}

		.garis {
			border: 1px solid #000;
			border-left: 0px;
			border-right: 0px;
			padding: 1px;
			margin-top: 5px;
			margin-bottom: 5px;
		}
	</style>
			
			<table width="100%">
			<tr>
			<td rowspan='5'>
				<img src="<?= $homeurl ?>/<?= $setting['logo'] ?>" width='90px'/>
			</td>
			<td width=200>Mata Pelajaran </td>
			<td width=200>: <?= $mapel['nama'] ?></td> 
			<td rowspan='5' width=400></td>					
			</tr>
			<tr>
				<td>Jenis Soal </td>
				<td>: <?= $mapel['groupsoal'] ?></td>
			</tr>
			<tr>
				<td>Tingkat | Jurusan </td>
				<td>: <?= $mapel['level'] ?> | <?= $jurusan  ?></td>
			</tr>
			<tr>
				<td>Pembuat Soal</td>
				<td>: <?= $guru['nama'] ?></td>
			</tr>
			<tr>
				<td>Satuan Pendidikan</td>
				<td width=400>: <?= $setting['sekolah'] ?></td>
			</tr>
			</table>
			<div class='garis'></div>
			
				        <br/>
				
			                        <table  class='table' width="100%">
                                        <tbody>
                                            <?php $soalq = mysqli_query($koneksi, "SELECT * FROM soal where id_bank='$id_bank'  order by nomor "); ?>
                                            <?php while ($soal = mysqli_fetch_array($soalq)) : ?>

                                                <tr>
                                                    <td style='width:30px'>
                                                        <?= $soal['nomor'] ?>
                                                    </td>
                                                    <td style="text-align:justify">
                                                        <?php
                                                        if ($soal['file'] <> '') :
                                                            $audio = array('mp3', 'wav', 'ogg', 'MP3', 'WAV', 'OGG');
                                                            $image = array('jpg', 'jpeg', 'png', 'gif', 'bmp', 'JPG', 'JPEG', 'PNG', 'GIF', 'BMP');
                                                            $ext = explode(".", $soal['file']);
                                                            $ext = end($ext);
                                                            if (in_array($ext, $image)) {
                                                                echo "<p style='margin-bottom: 5px'><img src='$homeurl/files/$soal[file]' style='max-width:100px;'/></p>";
                                                            } elseif (in_array($ext, $audio)) {
                                                                echo "<p style='margin-bottom: 5px'><audio controls><source src='$homeurl/files/$soal[file]' type='audio/$ext'>Your browser does not support the audio tag.</audio></p>";
                                                            } else {
                                                                echo "File tidak didukung!";
                                                            }
                                                        endif;
                                                        ?>
                                                        <?= $soal['soal']; ?>
                                                        <?php
                                                        if ($soal['file1'] <> '') :
                                                            $audio = array('mp3', 'wav', 'ogg', 'MP3', 'WAV', 'OGG');
                                                            $image = array('jpg', 'jpeg', 'png', 'gif', 'bmp', 'JPG', 'JPEG', 'PNG', 'GIF', 'BMP');
                                                            $ext = explode(".", $soal['file1']);
                                                            $ext = end($ext);
                                                            if (in_array($ext, $image)) {
                                                                echo "<p style='margin-top: 5px'><img src='$homeurl/files/$soal[file1]' style='max-width:200px;' /></p>";
                                                            } elseif (in_array($ext, $audio)) {
                                                                echo "<p style='margin-top: 5px'><audio controls><source src='$homeurl/files/$soal[file1]' type='audio/$ext'>Your browser does not support the audio tag.</audio></p>";
                                                            } else {
                                                                echo "File tidak didukung!";
                                                            }
                                                        endif;
                                                        ?>
														<?php if ($soal['jenis'] == '1') : ?>
                                                        <table width="100%">
                                                            <tr>
                                                                <td style="padding: 3px;width: 2%; vertical-align: text-top;">A.</td>
                                                                <td style="padding: 3px;width: 31%; vertical-align: text-top;">
                                                                    <?php
                                                                    if ($soal['pilA'] <> '') {
                                                                        echo "$soal[pilA] ";
                                                                    }

                                                                    if ($soal['fileA'] <> '') {
                                                                        $audio = array('mp3', 'wav', 'ogg', 'MP3', 'WAV', 'OGG');
                                                                        $image = array('jpg', 'jpeg', 'png', 'gif', 'bmp', 'JPG', 'JPEG', 'PNG', 'GIF', 'BMP');
                                                                        $ext = explode(".", $soal['fileA']);
                                                                        $ext = end($ext);
                                                                        if (in_array($ext, $image)) {
                                                                            echo "<img src='$homeurl/files/$soal[fileA]' style='max-width:100px;'/>";
                                                                        } elseif (in_array($ext, $audio)) {
                                                                            echo "<audio controls><source src='$homeurl/files/$soal[fileA]' type='audio/$ext'>Your browser does not support the audio tag.</audio>";
                                                                        } else {
                                                                            echo "File tidak didukung!";
                                                                        }
                                                                    }
                                                                    ?>
                                                                </td>
																 <?php if ($soal['opsi'] >= 3) : ?>
                                                                <td style="padding: 3px;width: 2%; vertical-align: text-top;">C.</td>
                                                                <td style="padding: 3px;width: 31%; vertical-align: text-top;">
                                                                    <?php
                                                                    if (!$soal['pilC'] == "") {
                                                                        echo "$soal[pilC] ";
                                                                    }

                                                                    if ($soal['fileC'] <> '') {
                                                                        $audio = array('mp3', 'wav', 'ogg', 'MP3', 'WAV', 'OGG');
                                                                        $image = array('jpg', 'jpeg', 'png', 'gif', 'bmp', 'JPG', 'JPEG', 'PNG', 'GIF', 'BMP');
                                                                        $ext = explode(".", $soal['fileC']);
                                                                        $ext = end($ext);
                                                                        if (in_array($ext, $image)) {
                                                                            echo "<img src='$homeurl/files/$soal[fileC]' style='max-width:100px;' />";
                                                                        } elseif (in_array($ext, $audio)) {
                                                                            echo "<audio controls><source src='$homeurl/files/$soal[fileC]' type='audio/$ext'>Your browser does not support the audio tag.</audio>";
                                                                        } else {
                                                                            echo "File tidak didukung!";
                                                                        }
                                                                    }
                                                                    ?>
                                                                </td>
																  <?php endif; ?>
                                                                <?php if ($soal['opsi'] == 5) : ?>
                                                                    <td style="padding: 3px;width: 2%; vertical-align: text-top;">E.</td>
                                                                    <td style="padding: 3px; vertical-align: text-top;">
                                                                        <?php
                                                                        if (!$soal['pilE'] == "") {
                                                                            echo "$soal[pilE] ";
                                                                        }

                                                                        if ($soal['fileE'] <> '') {
                                                                            $audio = array('mp3', 'wav', 'ogg', 'MP3', 'WAV', 'OGG');
                                                                            $image = array('jpg', 'jpeg', 'png', 'gif', 'bmp', 'JPG', 'JPEG', 'PNG', 'GIF', 'BMP');
                                                                            $ext = explode(".", $soal['fileE']);
                                                                            $ext = end($ext);
                                                                            if (in_array($ext, $image)) {
                                                                                echo "<img src='$homeurl/files/$soal[fileE]' style='max-width:100px;' />";
                                                                            } elseif (in_array($ext, $audio)) {
                                                                                echo "<audio controls><source src='$homeurl/files/$soal[fileE]' type='audio/$ext'>Your browser does not support the audio tag.</audio>";
                                                                            } else {
                                                                                echo "File tidak didukung!";
                                                                            }
                                                                        }
                                                                        ?>
                                                                    </td>
                                                                <?php endif; ?>

                                                            </tr>

                                                            <tr>
															<?php if ($soal['opsi'] >=2) : ?>
                                                                <td style="padding: 3px;width: 2%; vertical-align: text-top;">B.</td>
                                                                <td style="padding: 3px;width: 31%; vertical-align: text-top;">
                                                                    <?php
                                                                    if (!$soal['pilB'] == "") {
                                                                        echo "$soal[pilB] ";
                                                                    }

                                                                    if ($soal['fileB'] <> '') {
                                                                        $audio = array('mp3', 'wav', 'ogg', 'MP3', 'WAV', 'OGG');
                                                                        $image = array('jpg', 'jpeg', 'png', 'gif', 'bmp', 'JPG', 'JPEG', 'PNG', 'GIF', 'BMP');
                                                                        $ext = explode(".", $soal['fileB']);
                                                                        $ext = end($ext);
                                                                        if (in_array($ext, $image)) {
                                                                            echo "<img src='$homeurl/files/$soal[fileB]' style='max-width:100px;' />";
                                                                        } elseif (in_array($ext, $audio)) {
                                                                            echo "<audio controls><source src='$homeurl/files/$soal[fileB]' type='audio/$ext'>Your browser does not support the audio tag.</audio>";
                                                                        } else {
                                                                            echo "File tidak didukung!";
                                                                        }
                                                                    }
                                                                    ?>
                                                                </td>
																 <?php endif; ?>
                                                                <?php if ($soal['opsi'] >= 4) : ?>
                                                                    <td style="padding: 3px;width: 2%; vertical-align: text-top;">D.</td>
                                                                    <td style="padding: 3px;width: 31%; vertical-align: text-top;">
                                                                        <?php
                                                                        if (!$soal['pilD'] == "") {
                                                                            echo "$soal[pilD] ";
                                                                        }

                                                                        if ($soal['fileD'] <> '') {
                                                                            $audio = array('mp3', 'wav', 'ogg', 'MP3', 'WAV', 'OGG');
                                                                            $image = array('jpg', 'jpeg', 'png', 'gif', 'bmp', 'JPG', 'JPEG', 'PNG', 'GIF', 'BMP');
                                                                            $ext = explode(".", $soal['fileD']);
                                                                            $ext = end($ext);
                                                                            if (in_array($ext, $image)) {
                                                                                echo "<img src='$homeurl/files/$soal[fileD]' style='max-width:100px;' />";
                                                                            } elseif (in_array($ext, $audio)) {
                                                                                echo "<audio controls><source src='$homeurl/files/$soal[fileD]' type='audio/$ext'>Your browser does not support the audio tag.</audio>";
                                                                            } else {
                                                                                echo "File tidak didukung!";
                                                                            }
                                                                        }
                                                                        ?>
                                                                    </td>

                                                                <?php endif; ?>

                                                            </tr>

                                                        </table>
                                                       														
														<?php endif; ?>
														
															<?php if ($soal['jenis'] == '3' AND $soal['kode'] == 'PGM') : ?>
													 <table width="100%" class='table'>
													 <tr>
															<td rowspan="2" class="text-center" ><br><b>Pernyataan</b></td>
															<td class="text-center" width="15%" ><b>Jawaban A</b></td>
															<td class="text-center" width="15%" ><b>Jawaban B</b></td>
															<td class="text-center" width="15%" ><b>Jawaban C</b></td>
															</tr>
                                                            <tr>
															
															<td><?= $soal['perA'] ?></td>
															<td><?= $soal['perB'] ?></td>
															<td><?= $soal['perC'] ?></td>
															</tr>
															<tr>
															<td><?= $soal['pilA'] ?></td>
															<td><input type="radio" name="<?= $soal['id_soal'] ?>1"></td>
															<td><input type="radio" name="<?= $soal['id_soal'] ?>1"></td>
															<td><input type="radio" name="<?= $soal['id_soal'] ?>1"></td>
															</tr>
															<tr>
															<td><?= $soal['pilB'] ?></td>
															<td><input type="radio" name="<?= $soal['id_soal'] ?>2"></td>
															<td><input type="radio" name="<?= $soal['id_soal'] ?>2"></td>
															<td><input type="radio" name="<?= $soal['id_soal'] ?>2"></td>
															</tr>
															<tr>
															<td><?= $soal['pilC'] ?></td>
															<td><input type="radio" name="<?= $soal['id_soal'] ?>3"></td>
															<td><input type="radio" name="<?= $soal['id_soal'] ?>3"></td>
															<td><input type="radio" name="<?= $soal['id_soal'] ?>3"></td>
															</tr>
															 <?php if ($namamapel['opsi'] <>3){ ?>
															<tr>
															<td><?= $soal['pilD'] ?></td>
															<td><input type="radio" name="<?= $soal['id_soal'] ?>4"></td>
															<td><input type="radio" name="<?= $soal['id_soal'] ?>4"></td>
															<td><input type="radio" name="<?= $soal['id_soal'] ?>4"></td>
															</tr>
															<?php } ?>
															  <?php if ($namamapel['opsi'] == 5){ ?>
															<tr>
															<td><?= $soal['pilE'] ?></td>
															<td><input type="radio" name="<?= $soal['id_soal'] ?>5"></td>
															<td><input type="radio" name="<?= $soal['id_soal'] ?>5"></td>
															<td><input type="radio" name="<?= $soal['id_soal'] ?>5"></td>
															</tr>
															<?php } ?>
															</table>
															
                                                    <?php endif; ?>
													
													<?php if ($soal['jenis'] == '3' AND $soal['kode'] == '') : ?>
													 <table width="100%">
													 <tr>
														      <td style="padding: 3px;width: 2%; vertical-align: text-top;">A.</td>
															 <td style="padding: 3px;width: 2%; vertical-align: text-top;"><input type="checkbox" name="<?= $soal['id_soal'] ?>"></td>
															 <td style="padding: 3px;width: 31%; vertical-align: text-top;"><?= $soal['pilA'] ?></td>
															  <?php if ($soal['opsi'] >=2){ ?>
															 <td style="padding: 3px;width: 2%; vertical-align: text-top;">B.</td>
															 <td style="padding: 3px;width: 2%; vertical-align: text-top;"><input type="checkbox" name="<?= $soal['id_soal'] ?>"></td>
															 <td style="padding: 3px;width: 31%; vertical-align: text-top;"> <?= $soal['pilB'] ?></td>
															<?php } ?>
															</tr>
															 <tr>
															  <?php if ($soal['opsi'] >=3){ ?>
														      <td style="padding: 3px;width: 2%; vertical-align: text-top;">C.</td>
															 <td style="padding: 3px;width: 2%; vertical-align: text-top;"><input type="checkbox" name="<?= $soal['id_soal'] ?>"></td>
															 <td style="padding: 3px;width: 31%; vertical-align: text-top;"><?= $soal['pilC'] ?></td>
															 	<?php } ?>
															 <?php if ($soal['opsi'] >=4){ ?>
															<td style="padding: 3px;width: 2%; vertical-align: text-top;">D.</td>
															 <td style="padding: 3px;width: 2%; vertical-align: text-top;"><input type="checkbox" name="<?= $soal['id_soal'] ?>"></td>
															 <td style="padding: 3px;width: 31%; vertical-align: text-top;"> <?= $soal['pilD'] ?></td>
															<?php } ?>
															</tr>
															
															  <?php if ($soal['opsi'] == 5){ ?>
															<tr>
														      <td style="padding: 3px;width: 2%; vertical-align: text-top;">E.</td>
															 <td style="padding: 3px;width: 2%; vertical-align: text-top;"><input type="checkbox" name="<?= $soal['id_soal'] ?>"></td>
															 <td style="padding: 3px;width: 31%; vertical-align: text-top;"><?= $soal['pilE'] ?></td>
															 <td style="padding: 3px;width: 2%; vertical-align: text-top;"></td>
															 <td style="padding: 3px;width: 2%; vertical-align: text-top;"></td>
															 <td style="padding: 3px;width: 31%; vertical-align: text-top;"> </td>
															
															</tr>
															<?php } ?>
															</table>
															
                                                    <?php endif; ?>
													
													
													<?php if ($soal['jenis'] == '4' ) : ?>
													 <table width="100%" class='table'>
													  <?php if ($soal['pilA']<>''){ ?>
													 <tr>									 
															<td class="text-center" ><b>Pernyataan</b></td>
															<td class="text-center" width="5%" ><b>Benar</b></td>
															<td class="text-center" width="5%" ><b>Salah</b></td>														
															</tr>
                                                         <?php }else{ ?>
													 <tr>															
															<td class="text-center" width="5%" ><b>Benar</b></td>
															<td class="text-center" width="5%" ><b>Salah</b></td>															
															</tr>
													 <?php } ?>   
															<tr>
															<?php if ($soal['pilA']<>''){ ?>
															<td><?= $soal['pilA'] ?></td>
															<?php } ?>
															<td class="text-center"><input type="radio" name="<?= $soal['id_soal'] ?>1"></td>
															<td class="text-center"><input type="radio" name="<?= $soal['id_soal'] ?>1"></td>			
															</tr>
															
															<?php if ($sol['opsi'] >= 2){ ?>
															<tr>
														<?php if ($soal['pilB']<>''){ ?>
															<td><?= $soal['pilB'] ?></td>
															<?php } ?>
															<td class="text-center"><input type="radio" name="<?= $soal['id_soal'] ?>2"></td>
															<td class="text-center"><input type="radio" name="<?= $soal['id_soal'] ?>2"></td>											
															</tr>
															<?php } ?>
															<?php if ($sol['opsi'] >= 3){ ?>
															<tr>
															<?php if ($soal['pilC']<>''){ ?>
															<td><?= $soal['pilC'] ?></td>
															<?php } ?>
															<td class="text-center"><input type="radio" name="<?= $soal['id_soal'] ?>3"></td>
															<td class="text-center"><input type="radio" name="<?= $soal['id_soal'] ?>3"></td>
															</tr>
															<?php } ?>
															 <?php if ($sol['opsi'] >= 4){ ?>
															<tr>
															<?php if ($soal['pilD']<>''){ ?>
															<td><?= $soal['pilD'] ?></td>
															<?php } ?>
															<td class="text-center"><input type="radio" name="<?= $soal['id_soal'] ?>4"></td>
															<td class="text-center"><input type="radio" name="<?= $soal['id_soal'] ?>4"></td>											
															</tr>
																<?php } ?>
														 <?php if ($soal['opsi'] == 5){ ?>
															<tr>
															<?php if ($soal['pilE']<>''){ ?>
															<td><?= $soal['pilE'] ?></td>
															<?php } ?>
															<td class="text-center"><input type="radio" name="<?= $soal['id_soal'] ?>5"></td>
															<td class="text-center"><input type="radio" name="<?= $soal['id_soal'] ?>5"></td>
															
															</tr>
															<?php } ?>
															</table>
															
                                                    <?php endif; ?>
													<?php if ($soal['jenis'] == '5') : ?>
													 <table width="100%" class='table'>
													       <tr>
														  
															<td class="text-center" ><b>Pernyataan</b></td>	
															<td class="text-center" width="5%" ><b></b></td>	
															<td class="text-center" width="5%" ><b></b></td>	
                                                            <td class="text-center" ><b>Jawaban</b></td>	
																													
															</tr>
                                                           
															<tr>															
															<td><?= $soal['perA'] ?></td>															
															<td><input type="checkbox" name="<?= $soal['id_soal'] ?>1"></td>
															<td><input type="checkbox" name="<?= $soal['id_soal'] ?>1"></td>
															<td><?= $soal['pilA'] ?></td>															
															</tr>
															 <?php if ($soal['opsi' ]>= 2){ ?>
															<tr>															
															<td><?= $soal['perB'] ?></td>															
															<td><input type="checkbox" name="<?= $soal['id_soal'] ?>1"></td>
															<td><input type="checkbox" name="<?= $soal['id_soal'] ?>1"></td>
															<td><?= $soal['pilB'] ?></td>															
															</tr>
															<?php } ?>
															 <?php if ($soal['opsi' ]>= 3){ ?>
															<tr>															
															<td><?= $soal['perC'] ?></td>															
															<td><input type="checkbox" name="<?= $soal['id_soal'] ?>1"></td>
															<td><input type="checkbox" name="<?= $soal['id_soal'] ?>1"></td>
															<td><?= $soal['pilC'] ?></td>															
															</tr>
															<?php } ?>
															 <?php if ($soal['opsi' ]>= 4){ ?>
															<tr>															
															<td><?= $soal['perD'] ?></td>															
															<td><input type="checkbox" name="<?= $soal['id_soal'] ?>1"></td>
															<td><input type="checkbox" name="<?= $soal['id_soal'] ?>1"></td>
															<td><?= $soal['pilD'] ?></td>															
															</tr>
																<?php } ?>
															 <?php if ($soal['opsi'] == 5){ ?>
															<tr>															
															<td><?= $soal['perE'] ?></td>															
															<td><input type="checkbox" name="<?= $soal['id_soal'] ?>1"></td>
															<td><input type="checkbox" name="<?= $soal['id_soal'] ?>1"></td>
															<td><?= $soal['pilE'] ?></td>															
															</tr>
															<?php } ?>
															</table>
                                                    <?php endif; ?>
													
                                                       
                                                    
													
                                                 
                                                
                                            <?php endwhile; ?>
                                        </tbody>
                                    </table>
			                    