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); }