function Simpan($md, $mhsw, $thn, $id)
{
$MKID = $_REQUEST['MKID'];
$BobotNilai = $_REQUEST['BobotNilai'];
$Catatan = sqling($_REQUEST['Catatan']);
$SetaraKode = sqling($_REQUEST['SetaraKode']);
$SetaraNama = sqling($_REQUEST['SetaraNama']);
$SetaraGrade = sqling($_REQUEST['SetaraGrade']);
$SKS = $_REQUEST['SKS'] + 0;
$m = GetFields('mhsw', "MhswID = '{$mhsw}' and KodeID", KodeID, '*');
$GradeNilai = GetaField('nilai', "ProdiID='{$m['ProdiID']}' and NA='N' and Bobot", $BobotNilai, "Nama");
$mk = GetFields('mk', 'MKID', $MKID, '*');
if ($md == 0) {
$krsid = $_REQUEST['id'];
$khsid = CekKHS($mhsw, $m, $thn);
$s = "update krs\r\n set MKID='{$MKID}',\r\n TahunID = '{$thn}',\r\n KHSID = '{$khsid}',\r\n MKKode = '{$mk['MKKode']}',\r\n Nama = '{$mk['Nama']}',\r\n SKS = '{$mk['SKS']}',\r\n GradeNilai = '{$GradeNilai}',\r\n BobotNilai = '{$BobotNilai}',\r\n Setara = 'Y',\r\n SetaraKode = '{$SetaraKode}',\r\n SetaraNama = '{$SetaraNama}',\r\n SetaraGrade = '{$SetaraGrade}',\r\n Catatan = '{$Catatan}',\r\n Sah = 'Y',\r\n Final = 'Y',\r\n LoginEdit = '{$_SESSION['_Login']}',\r\n TanggalEdit = now()\r\n where KRSID = '{$krsid}' ";
$r = _query($s);
UrutSesi($mhsw, $m, $thn);
Tutup();
} elseif ($md == 1) {
// Cek tahun dulu
$khsid = CekKHS($mhsw, $m, $thn);
$s = "insert into krs (KodeID, KHSID, MhswID, TahunID, MKID, MKKode, Nama, SKS, GradeNilai, BobotNilai, StatusKRSID, Tinggi, \r\n Setara, SetaraKode, SetaraNama, SetaraGrade, Final, Sah, Catatan, LoginBuat, LoginEdit)\r\n values ('" . KodeID . "', {$khsid}, '{$mhsw}', '{$thn}', '{$MKID}', '{$mk['MKKode']}', '{$mk['Nama']}', '{$SKS}', '{$GradeNilai}', '{$BobotNilai}', 'A', '*',\r\n 'Y', '{$SetaraKode}', '{$SetaraNama}', '{$SetaraGrade}', 'Y', 'Y', '{$Catatan}', '{$_SESSION['_Login']}', now())";
$r = _query($s);
UrutSesi($mhsw, $m, $thn);
Tutup();
} else {
echo ErrorMsg("Error", "Ada kesalahan mode edit.<br />\r\n Hubungi Sysadmin untuk informasi lebih lanjut.\r\n <hr size=1 color=silver />\r\n <input type=button name='btnClose' value='Tutup' onClick='window.close()' />");
}
}
function SaveAll($MhswID, $mhsw)
{
/*$si = "select k.*
from krs k
left outer join khs h on h.KHSID = k.KHSID and h.KodeID = '".KodeID."'
where k.MhswID = '$MhswID'
order by k.TahunID, k.MKKode";
$ri = _query($si);
$ni = _num_rows($ri);
while($wi=_fetch_array($ri))
{ $tempNum = substr($wi[MKKode],6,1);
if($tempNum==1) $theYear = $InputTahun1.$tempNum;
else if($tempNum==2) $theYear = $InputTahun1.$tempNum;
else if($tempNum==3) $theYear = ($InputTahun1+1).($tempNum-2);
else if($tempNum==4) $theYear = ($InputTahun1+1).($tempNum-2);
else if($tempNum==5) $theYear = ($InputTahun1+2).($tempNum-4);
else if($tempNum==6) $theYear = ($InputTahun1+2).($tempNum-4);
else if($tempNum==7) $theYear = ($InputTahun1+3).($tempNum-6);
else if($tempNum==8) $theYear = ($InputTahun1+3).($tempNum-6);
else $theYear = '';
//echo "$wi[MKKode]: $theYear<br>";
$ss = "update `krs` set
TahunID='$theYear',
Setara = 'Y',
SetaraKode = 'a',
SetaraNama = 'a',
SetaraGrade = 'a',
Sah = 'Y',
Final = 'Y',
LoginEdit = '$_SESSION[_Login]',
TanggalEdit = now()
where KRSID = '$wi[KRSID]'";
$rr = _query($ss);
}*/
$Siska = array($_REQUEST['Select1'], $_REQUEST['Select2'], $_REQUEST['Select3'], $_REQUEST['Select4'], $_REQUEST['Select5'], $_REQUEST['Select6'], $_REQUEST['Select7'], $_REQUEST['Select8'], $_REQUEST['Select9'], $_REQUEST['Select10'], $_REQUEST['Select11'], $_REQUEST['Select12'], $_REQUEST['Select13'], $_REQUEST['Select14'], $_REQUEST['Select15'], $_REQUEST['Select16'], $_REQUEST['Select17'], $_REQUEST['Select18'], $_REQUEST['Select19'], $_REQUEST['Select20'], $_REQUEST['Select21'], $_REQUEST['Select22'], $_REQUEST['Select23'], $_REQUEST['Select24'], $_REQUEST['Select25'], $_REQUEST['Select26'], $_REQUEST['Select27'], $_REQUEST['Select28'], $_REQUEST['Select29'], $_REQUEST['Select30'], $_REQUEST['Select31'], $_REQUEST['Select32'], $_REQUEST['Select33'], $_REQUEST['Select34'], $_REQUEST['Select35'], $_REQUEST['Select36'], $_REQUEST['Select37'], $_REQUEST['Select38'], $_REQUEST['Select39'], $_REQUEST['Select40'], $_REQUEST['Select41'], $_REQUEST['Select42'], $_REQUEST['Select43'], $_REQUEST['Select44'], $_REQUEST['Select45'], $_REQUEST['Select46'], $_REQUEST['Select47'], $_REQUEST['Select48'], $_REQUEST['Select49'], $_REQUEST['Select50'], $_REQUEST['Select51'], $_REQUEST['Select52'], $_REQUEST['Select53'], $_REQUEST['Select54'], $_REQUEST['Select55'], $_REQUEST['Select56'], $_REQUEST['Select57'], $_REQUEST['Select58'], $_REQUEST['Select59'], $_REQUEST['Select60'], $_REQUEST['Select61'], $_REQUEST['Select62'], $_REQUEST['Select63'], $_REQUEST['Select64'], $_REQUEST['Select65'], $_REQUEST['Select66'], $_REQUEST['Select67'], $_REQUEST['Select68'], $_REQUEST['Select69'], $_REQUEST['Select70']);
$Siska2 = array($_REQUEST['Hidden1'], $_REQUEST['Hidden2'], $_REQUEST['Hidden3'], $_REQUEST['Hidden4'], $_REQUEST['Hidden5'], $_REQUEST['Hidden6'], $_REQUEST['Hidden7'], $_REQUEST['Hidden8'], $_REQUEST['Hidden9'], $_REQUEST['Hidden10'], $_REQUEST['Hidden11'], $_REQUEST['Hidden12'], $_REQUEST['Hidden13'], $_REQUEST['Hidden14'], $_REQUEST['Hidden15'], $_REQUEST['Hidden16'], $_REQUEST['Hidden17'], $_REQUEST['Hidden18'], $_REQUEST['Hidden19'], $_REQUEST['Hidden20'], $_REQUEST['Hidden21'], $_REQUEST['Hidden22'], $_REQUEST['Hidden23'], $_REQUEST['Hidden24'], $_REQUEST['Hidden25'], $_REQUEST['Hidden26'], $_REQUEST['Hidden27'], $_REQUEST['Hidden28'], $_REQUEST['Hidden29'], $_REQUEST['Hidden30'], $_REQUEST['Hidden31'], $_REQUEST['Hidden32'], $_REQUEST['Hidden33'], $_REQUEST['Hidden34'], $_REQUEST['Hidden35'], $_REQUEST['Hidden36'], $_REQUEST['Hidden37'], $_REQUEST['Hidden38'], $_REQUEST['Hidden39'], $_REQUEST['Hidden40'], $_REQUEST['Hidden41'], $_REQUEST['Hidden42'], $_REQUEST['Hidden43'], $_REQUEST['Hidden44'], $_REQUEST['Hidden45'], $_REQUEST['Hidden46'], $_REQUEST['Hidden47'], $_REQUEST['Hidden48'], $_REQUEST['Hidden49'], $_REQUEST['Hidden50'], $_REQUEST['Hidden51'], $_REQUEST['Hidden52'], $_REQUEST['Hidden53'], $_REQUEST['Hidden54'], $_REQUEST['Hidden55'], $_REQUEST['Hidden56'], $_REQUEST['Hidden57'], $_REQUEST['Hidden58'], $_REQUEST['Hidden59'], $_REQUEST['Hidden60'], $_REQUEST['Hidden61'], $_REQUEST['Hidden62'], $_REQUEST['Hidden63'], $_REQUEST['Hidden64'], $_REQUEST['Hidden65'], $_REQUEST['Hidden66'], $_REQUEST['Hidden67'], $_REQUEST['Hidden68'], $_REQUEST['Hidden69'], $_REQUEST['Hidden70']);
$x = 0;
while (!empty($Siska[$x])) {
//echo "Select: $Siska[$x], KRSID: $Siska2[$x]<br>";
/*$ss = "update `krs` set
TahunID='$Siska[$x]',
Setara ='Y',
SetaraKode = 'a',
SetaraNama = 'a',
SetaraGrade = 'a',
Sah = 'Y',
Final = 'Y',
LoginEdit = '$_SESSION[_Login]',
TanggalEdit = now()
where KRSID='$Siska2[$x]'";*/
// cek khs
$adakhs = GetaField('khs', "MhswID='{$MhswID}' and TahunID='{$Siska[$x]}' and KodeID", KodeID, 'KHSID') + 0;
if ($adakhs == 0) {
// create new TahunID
$Sesi = GetaField('khs', "MhswID='{$MhswID}' and TahunID < '{$Siska[$x]}' and KodeID", KodeID, "Sesi") + 1;
$s = "insert into khs\r\n (TahunID, KodeID, ProgramID, \r\n ProdiID, MhswID, StatusMhswID,\r\n Sesi, LoginBuat, TanggalBuat)\r\n values\r\n ('{$Siska[$x]}', '" . KodeID . "', '{$mhsw['ProgramID']}',\r\n '{$mhsw['ProdiID']}', '{$MhswID}', 'A',\r\n '{$Sesi}', '{$_SESSION['_Login']}', now())";
$r = _query($s);
$adakhs = GetLastID();
}
// update krs
$ss = "update `krs` set TahunID='{$Siska[$x]}', KHSID='{$adakhs}' where KRSID='{$Siska2[$x]}'";
$rr = _query($ss);
$x++;
}
UrutSesi($MhswID, $mhsw);
BerhasilSimpan("?mnux={$_SESSION['mnux']}", 1000);
}
