<?
define("MAIN",1);
include("common.php");
include("registered_cmd.php");
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Memasukkan markah murid</title>
<link href="css/main.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
var lineObjOffsetTop = 4;
function createTextAreaWithLines(id)
{
var el = document.createElement('DIV');
var ta = document.getElementById(id);
ta.parentNode.insertBefore(el,ta);
el.appendChild(ta);
el.className='textAreaWithLines';
el.style.width = (ta.offsetWidth + 50) + 'px';
ta.style.position = 'absolute';
ta.style.left = '250px';
el.style.height = (ta.offsetHeight + 1) + 'px';
el.style.overflow='hidden';
el.style.position = 'relative';
el.style.width = (ta.offsetWidth + 50) + 'px';
var lineObj = document.createElement('DIV');
lineObj.style.position = 'absolute';
lineObj.style.top = lineObjOffsetTop + 'px';
lineObj.style.left = '0px';
lineObj.style.overflow='hidden';
lineObj.style.width = '250px';
el.insertBefore(lineObj,ta);
lineObj.style.textAlign = 'left';
lineObj.className='lineObj';
var string = '';
//for(var no=1;no<20;no++){
// if(string.length>0)string = string + '. Hafiz<br>';
//string = string + no;
//}
string = '<?
$tahun = $_GET['thn'];
$dbres = mysql_query("SELECT * FROM tbmurid WHERE `tahun` = '$tahun' ORDER BY jantina, nama ASC");
$total = mysql_num_rows($dbres);
$count=0;
while ($row = mysql_fetch_array($dbres))
{
$count++;
$nama=eregi_replace(" "," ",$row['nama']);
$span_o = "";
$span_c = "";
if(strtoupper($row['jantina'])=="P")
{
$span_o="<font color=#FF33FF>";
$span_c="</font>";
}
echo $span_o.$count.". ".$nama.$span_c."<br>";
}
?>';
//document.write(string);
ta.onkeydown = function() { positionLineObj(lineObj,ta); };
ta.onmousedown = function() { positionLineObj(lineObj,ta); };
ta.onscroll = function() { positionLineObj(lineObj,ta); };
ta.onblur = function() { positionLineObj(lineObj,ta); };
ta.onfocus = function() { positionLineObj(lineObj,ta); };
ta.onmouseover = function() { positionLineObj(lineObj,ta); };
lineObj.innerHTML = string;
}
function positionLineObj(obj,ta)
{
obj.style.top = (ta.scrollTop * -1 + lineObjOffsetTop) + 'px';
}
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
</script>
</head>
<body>
<p><strong><img src="images/data_add.png" width="48" height="48" /> Memasukkan markah »</strong></p>
<p>Login sebagai : <b>
<?=$_SESSION['logged']?>
</b> [ <a href="./?a=logout">Logout</a> ]</p>
<p>
[ <a href="./">Menu utama</a> ][ <a href="data.php">Memasukkan markah</a> ][ <a href="analisis.php">Analisis markah</a> ][ <a href="profile.php">Kemaskini maklumat diri</a> ]
<?
switch ($_POST['command'])
{
case "":
if(!$_POST['senarainama'])
{
?>
</p>
<form method="post" onsubmit="return check()">
<label>Tahun :
<select name="jumpMenu" id="jumpMenu" onchange="MM_jumpMenu('parent',this,0)">
<option value="data.php" >Sila Pilih Tahun</option>
<?
// Mengira jumlah guru belum daftar
$dbres = mysql_query("SELECT * FROM tbtahun");
$total = mysql_num_rows($dbres);
$count=0;
while ($row = mysql_fetch_array($dbres))
{
if($_GET['thn']==$row['tahun'])
{
$sel="selected";
}else $sel="";
echo " <option value=\"data.php?thn=".$row['tahun']."\" $sel>";
echo "Tahun ".$row['nama'];
echo "</option>\n";
}
?>
</select>
</label>
<p>Subjek :
<select name="pilih_subjek" id="pilih_subjek">
<?
// Mengira jumlah guru belum daftar
$dbres = mysql_query("SELECT * FROM subjek");
$total = mysql_num_rows($dbres);
$count=0;
while ($row = mysql_fetch_array($dbres))
{
echo " <option value=\"".$row['kodsubjek']."\">";
echo $row['subjek'];
echo "</option>\n";
}
?>
</select>
</p>
<p>
<div style=" width:250px; background:#999999; float:left; overflow:hidden; ">
<div align="center">Nama</div>
</div>
<div class="white" style="width:100px; background:#666666; float:left">
<div align="center"><strong>Markah</strong></div>
</div><br />
<textarea cols="50" id="codeTextarea" name="senarainama" style="text-transform:uppercase; "></textarea>
</p>
<p>
</p>
<p>
<label>
<input type="submit" name="button" id="button" value="Submit" />
</label>
</p>
</form>
<p>
<script type="text/javascript">
createTextAreaWithLines('codeTextarea');
</script>
<?
}
if($_POST['senarainama'])
{
?>
</p>
<p><strong>Adakah anda pasti untuk memasukkan data tersebut ke dalam senarai murid tahun
<?=$_GET['thn'];?> ?</strong></p>
<h3>Subjek : <?=$_POST['pilih_subjek'];?></h3>
<form id="form1" name="form1" method="post" action="">
<p>
<input type="submit" name="button3" id="button3" value="Submit" />
<label>
<input type="button" name="button4" id="button4" value="Cetak" onclick="javascript:window.print()" />
</label>
</p>
<table width="100%" border="0">
<tr>
<td width="25" bgcolor="#CCCCCC"><div align="center"><strong>BIL</strong></div></td>
<td bgcolor="#CCCCCC"><div align="center"><strong>NAMA</strong></div></td>
<td width="100" bgcolor="#CCCCCC"><div align="center"><strong>MARKAH</strong></div></td>
<td width="40" bgcolor="#CCCCCC"><div align="center"><strong>GRED</strong></div></td>
</tr><?
$counter=0;
$nama_a = explode("\n",stripslashes(strtoupper($_POST['senarainama'])));
$nama_a = array_filter($nama_a);
function checkblank($var){
if(trim($var)!="")return 1;
}
$dbres = mysql_query("SELECT * FROM tbmurid WHERE `tahun` = '$tahun' ORDER BY nama ASC");
$total = mysql_num_rows($dbres);
$count=0;
while ($row = mysql_fetch_array($dbres))
{
$count++;
$s_nama=eregi_replace(" "," ",$row['nama']);
//echo " <option value=\"".$row['id']."\">";
//echo $count.". ".$nama."<br>";
//echo "</option>\n";
//}
//$nama_a = array_filter($nama_a,"checkblank");
//foreach ($nama_a as $nama)
//{
$nama = $nama_a;
$nama = trim($nama[$count-1]);
if($nama=="")$nama=0;
//echo $nama;
//if($nama!="")
//{
//$counter++;
?>
<tr class="tr_hvr">
<td><div align="right">
<?=$count?>.
</div></td>
<td><? echo trim($s_nama);
$gred= kira_gred(trim($nama));
if($gred=="Err!")$error=1;
?>
<input name="murid_id[]" type="hidden" id="murid_id[]" value="<?=$row['id']?>" />
<input name="murid_nama[]" type="hidden" id="murid_nama[]" value="<?=$row['nama']?>" /></td>
<td><div align="center">
<?=$nama ?>
<input name="nama[]" type="hidden" id="nama[]" value="<?=trim($nama)?>" />
</div></td>
<td><div align="center"><span class="<?=warna("$gred");?>">
<? echo $gred;?>
</span> </div></td>
</tr>
<tr>
<td height="5" colspan="4" bgcolor="#F4F4F4"></td>
</tr>
<?
//{
}
?>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<input name="jumlah" type="hidden" id="jumlah" value="<?=$counter?>" />
<input name="command" type="hidden" id="command" value="insert" />
<input name="kelas" type="hidden" id="kelas" value="<?=$_POST['pilih_tahun']?>" />
<input name="subjek" type="hidden" id="subjek" value="<?=$_POST['pilih_subjek']?>" />
<br />
<input type="submit" name="button2" id="button2" value="Submit" />
</label>
</form><?
if($error){
?>
<script language="javascript">
document.forms[0].button3.disabled=1;
document.forms[0].button3.value="Terdapat kesalahan pada data! Sila masukkan markah kembali";
document.forms[0].button2.disabled=1;
document.forms[0].button2.value="Terdapat kesalahan pada data! Sila masukkan markah kembali";
</script>
<?
}
?>
<p>Bilangan data yang akan dimasukkan = <?=$count?><?
}
break;
case "insert";
$data=$_POST['nama'];
?>
<br />
</p>
<p> </p>
<p align="center">Data berjaya dimasukkan ke dalam kelas tahun <?=$_GET['thn'];?>!<br />
<br />
<?
$murid = $_POST['murid_id'];
$nama_murid = $_POST['murid_nama'];
$darjah = $_GET['thn'];
$subjek = $_POST['subjek'];
$c_thp = "SELECT tahap FROM `tbtahun`
WHERE `tahun` = '$darjah'
";
$c_thp = mysql_query($c_thp);
$c_thp = mysql_fetch_array($c_thp);
$cur_tahap = $c_thp['tahap'];
$bil_subjek = get_subjek($cur_tahap);
//echo $bil_subjek;
$count=0;
$lulus=0;
$gagal=0;
$all_pcent=array();
foreach ($data as $nama)
{
if(is_lulus($nama))
{
$lulus++;
} else $gagal++;
if(kira_gred($nama)=="A")$jum_a++;
if(kira_gred($nama)=="B")$jum_b++;
if(kira_gred($nama)=="C")$jum_c++;
if(kira_gred($nama)=="D")$jum_d++;
if(kira_gred($nama)=="E")$jum_e++;
$id_murid = $murid[$count];
//echo $gagal."<br><br>";
$count++;
$qdb = "INSERT INTO markah SET
darjah = '$darjah' ,
tahun = '$tahun_sekarang',
murid = '$id_murid',
$subjek = '$nama'
";
$sch = "SELECT id FROM `markah`
WHERE `darjah` = '$darjah'
AND `tahun` = '$tahun_sekarang'
AND `murid` = '$id_murid'
";
$sch = mysql_query($sch);
//echo $sch;
//$rows = mysql_num_rows($sch) or die(mysql_error());
if(mysql_num_rows($sch)>0)
{
$cur_id = mysql_fetch_array($sch);
$cid = $cur_id['id'];
$qdb = "UPDATE markah SET
darjah = '$darjah' ,
tahun = '$tahun_sekarang',
murid = '$id_murid',
$subjek = '$nama'
WHERE
id = '$cid'
";
}
//echo $qdb."<br>";
$dbres = mysql_query($qdb) or die("<span class=red><i>Terdapat masalah semasa memasukkan/mengemaskini data.
</i></span><br><br>".mysql_error());
$upd = "SELECT * FROM `markah`
WHERE `darjah` = '$darjah'
AND `tahun` = '$tahun_sekarang'
AND `murid` = '$id_murid'
";
$upd = mysql_query($upd);
$upd = mysql_fetch_array($upd);
$upd_id = $upd['id'];
$BMF = $upd['BMF'];
$BMT = $upd['BMT'];
$BI = $upd['BI'];
$BIL = $upd['BIL'];
$MT = $upd['MT'];
$SN = $upd['SN'];
$PI = $upd['PI'];
$JW = $upd['JW'];
$KT = $upd['KT'];
$KH = $upd['KH'];
$PSV = $upd['PSV'];
$PJK =$upd['PJK'];
$SV =$upd['SV'];
$MZ = $upd['MZ'];
$upd_tot = $BMF + $BMT + $BI + $BIL + $MT + $SN + $PI + $JW + $KT + $KH + $PSV + $PJK + $SV + $MZ;
$upd_pcent=$upd_tot/($bil_subjek*100)*100;
$upd_pcent = number_format($upd_pcent,2,".",",");
$upd_grd = kira_gred($upd_pcent);
array_push($all_pcent,array($upd_pcent,$upd_id));
// echo "<Br><br>$upd_tot";
$qdb = "UPDATE markah SET
JUM = '$upd_tot',
PERATUS = '$upd_pcent',
GRED = '$upd_grd'
WHERE `darjah` = '$darjah'
AND `tahun` = '$tahun_sekarang'
AND `murid` = '$id_murid'
";
$dbres = mysql_query($qdb) or die("<span class=red><i>Terdapat masalah semasa memasukkan/mengemaskini data.
</i></span><br><br>".mysql_error());
echo $nama_murid[$count-1]." »» (".$nama.") <span class=blue>√</span><br>\n";
}
$tertinggi = max($data);
$terendah = min($data);
$jumlah_markah = array_sum($data);
$bilangan = count($data);
$purata = $jumlah_markah/$bilangan;
$purata = number_format($purata,2,".",",");
$pcent_lulus=$lulus/$bilangan*100;
$pcent_lulus = number_format($pcent_lulus,2,".",",");
$pcent_gagal=$gagal/$bilangan*100;
$pcent_gagal = number_format($pcent_gagal,2,".",",");
echo "<br><br><b><span class=blue>Analisa:</span><br>Markah Tinggi : <span class=red>$tertinggi</span><br>
Markah terendah : <span class=red>$terendah</span><br><br>
Purata Markah : <span class=red>$purata</span><br />
Lulus : <span class=red>$lulus</span><br>
Gagal : <span class=red>$gagal</span><br><br>
Peratus Lulus : <span class=red>$pcent_lulus %</span><br>
Peratus Gagal : <span class=red>$pcent_gagal %</span><br>
</b>";
rsort($all_pcent);
//print_r($all_pcent);
$count=0;
foreach ($all_pcent as $markah)
{
//$where = $markah[$count][0];
$to = $markah[1];
$count++;
$ked=$count;
$qdb = "
UPDATE markah SET
KED = '$ked'
WHERE `id` = '$to'
";
//echo $qdb."<br>";
$dbres = mysql_query($qdb) or die("<span class=red><i>Terdapat masalah semasa memasukkan/mengemaskini data.
</i></span><br><br>".mysql_error());
}
save_log("memasukkan markah ($subjek) pada $count orang murid tahun $darjah pada ".masa());
//rsort($susun);
//echo $susun;
//foreach ($data as $key => $val) {
//echo "fruits[" . $key . "] = " . $val . "\n";
//}
//print_r($susun);
?>
</p>
<table width="400" border="0" align="center">
<tr>
<td bgcolor="#99FF66"><div align="center"><strong>Gred Mengikut M/P <?=$_POST['subjek'];?></strong>
</div></td>
<td bgcolor="#99FF66"><div align="center"><strong>Jumlah</strong></div></td>
</tr>
<tr>
<td><div align="center">A</div></td>
<td><div align="center">
<?=$jum_a?>
</div></td>
</tr>
<tr>
<td><div align="center">B</div></td>
<td><div align="center">
<?=$jum_b?>
</div></td>
</tr>
<tr>
<td><div align="center">C</div></td>
<td><div align="center">
<?=$jum_c?>
</div></td>
</tr>
<tr>
<td><div align="center">D</div></td>
<td><div align="center">
<?=$jum_d?>
</div></td>
</tr>
<tr>
<td><div align="center">E</div></td>
<td><div align="center">
<?=$jum_e?>
</div></td>
</tr>
<tr>
<td bgcolor="#CCCCCC"><div align="right">JUMLAH</div></td>
<td bgcolor="#CCCCCC"><div align="center"><?=$count?></div></td>
</tr>
</table>
<h2 align="center">[<img src="images/home.png" width="48" height="48" /> <a href="./">Menu utama</a> ]
<?
break;
}
?>
</h2>
</body>
</html>