API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2019
57
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.39 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. if (isset($_POST[simpan])){
  3. if ($_POST[status]=='Update'){
  4. mysql_query("UPDATE rb_nilai_pengetahuan SET id_kompetensi_dasar='$_POST[a]', nilai1='$_POST[b]', nilai2='$_POST[c]' where id_nilai_pengetahuan='$_POST[id]'");
  5. }else{
  6. mysql_query("INSERT INTO rb_nilai_pengetahuan VALUES('','$_GET[jdwl]','$_GET[kdpelajaran]','$_POST[nisn]','$_POST[a]','$_POST[b]','$_POST[c]','$_SESSION[id]','".date('Y-m-d H:i:s')."')");
  7. }
  8. echo "<script>document.location='index.php?view=raport&act=listsiswa&jdwl=$_GET[jdwl]&kd=$_GET[kd]&id=$_GET[id]&ie=$_GET[ie]&tahun=$_GET[tahun]#$_POST[nisn]';</script>";
  9. }
  10.  
  11. if (isset($_GET[delete])){
  12. mysql_query("DELETE FROM rb_nilai_pengetahuan where id_nilai_pengetahuan='$_GET[delete]'");
  13. echo "<script>document.location='index.php?view=raport&act=listsiswa&jdwl=$_GET[jdwl]&kd=$_GET[kd]&id=$_GET[id]&ie=$_GET[ie]&tahun=$_GET[tahun]#$_GET[nisn]';</script>";
  14. }
  15.  
  16. $d = mysql_fetch_array(mysql_query("SELECT * FROM rb_kelas where kode_kelas='$_GET[id]'"));
  17. $n = mysql_fetch_array(mysql_query("SELECT * FROM rb_kls_pararel where id_kls_pararel='$_GET[ie]'"));
  18. $m = mysql_fetch_array(mysql_query("SELECT * FROM rb_mata_pelajaran where kode_pelajaran='$_GET[kd]'"));
  19. echo "<div class='col-md-12'>
  20. <div class='box box-info'>
  21. <div class='box-header with-border'>
  22. <h3 class='box-title'>Input Nilai Pengetahuan Siswa</b></h3>
  23. <a style='margin-top:-3px; margin-right:5px' class='btn btn-success pull-right' data-toggle='modal' data-target='#importnilaip'><span class='fa fa-file'></span> Import</a>
  24. </div>
  25.  
  26. <div class='box-body'>
  27. <div class='col-md-12'>
  28. <table class='table table-condensed table-hover'>
  29. <tbody>
  30. <input type='hidden' name='id' value='$s[kodekelas]'>
  31. <tr><th width='120px' scope='row'>Kode Kelas</th> <td>$d[kode_kelas]</td></tr>
  32. <tr><th scope='row'>Nama Kelas</th> <td>$d[nama_kelas]</td></tr>
  33. <tr><th scope='row'>Kelas Paralel</th> <td>$n[nm_pararel]</td></tr>
  34. <tr><th scope='row'>Mata Pelajaran</th> <td>$m[namamatapelajaran]</td></tr>
  35. </tbody>
  36. </table>
  37. </div>
  38.  
  39. <div class='panel-body table-responsive'>
  40. <table class='table table-bordered table-striped'>
  41. <tr>
  42. <th style='border:1px solid #e3e3e3' width='30px' rowspan='2'>No</th>
  43. <th style='border:1px solid #e3e3e3' width='170px' rowspan='2'>Nisn</th>
  44. <th style='border:1px solid #e3e3e3' width='170px' rowspan='2'>Nama Lengkap</th>
  45. <th style='border:1px solid #e3e3e3' colspan='3'><center>Penilaian</center></th>
  46. <th style='border:1px solid #e3e3e3; width:65px' rowspan='2'><center>Action</center></th>
  47. </tr>
  48. <tbody>";
  49. $no = 1;
  50. $tampil = mysql_query("SELECT * FROM rb_siswa where kode_kelas='$_GET[id]' AND id_kls_pararel='$_GET[ie]' ORDER BY id_siswa");
  51. while($r=mysql_fetch_array($tampil)){
  52. if (isset($_GET[edit])){
  53. $e = mysql_fetch_array(mysql_query("SELECT * FROM rb_nilai_pengetahuan where id_nilai_pengetahuan='$_GET[edit]'"));
  54. $name = 'Update';
  55. }else{
  56. $name = 'Insert';
  57. }
  58. if ($_GET[nisn]==$r[nisn]){
  59. echo "<form action='index.php?view=raport&act=listsiswa&jdwl=$_GET[jdwl]&kd=$_GET[kd]&id=$_GET[id]&ie=$_GET[ie]&tahun=$_GET[tahun]&kdpelajaran=$m[kode_pelajaran]' method='POST'>
  60. <tr>
  61. <td>$no</td>
  62. <td style='font-size:12px'>$r[nisn]</td>
  63. <td style='font-size:12px' id='$r[nisn]'>$r[nama]</td>
  64. <input type='hidden' name='nisn' value='$r[nisn]'>
  65. <input type='hidden' name='id' value='$e[id_nilai_pengetahuan]'>
  66. <input type='hidden' name='status' value='$name'>
  67. ";
  68. }else{
  69. echo "<form action='index.php?view=raport&act=listsiswa&jdwl=$_GET[jdwl]&kd=$_GET[kd]&id=$_GET[id]&ie=$_GET[ie]&tahun=$_GET[tahun]&kdpelajaran=$m[kode_pelajaran]' method='POST'>
  70. <tr>
  71. <td>$no</td>
  72. <td style='font-size:12px'>$r[nisn]</td>
  73. <td style='font-size:12px' id='$r[nisn]'>$r[nama]</td>
  74. <input type='hidden' name='nisn' value='$r[nisn]'>
  75. <input type='hidden' name='id' value='$e[id_nilai_pengetahuan]'>
  76. <input type='hidden' name='status' value='$name'>
  77. ";
  78. }
  79.  
  80. $pe = mysql_query("SELECT * FROM rb_nilai_pengetahuan a LEFT JOIN rb_kompetensi_dasar b ON a.id_kompetensi_dasar=b.id_kompetensi_dasar where a.kodejdwl='$_GET[jdwl]' AND a.nisn='$r[nisn]'");
  81. while ($n = mysql_fetch_array($pe)){
  82. $ratarata = average(array($n[nilai1],$n[nilai2],$n[nilai3],$n[nilai4],$n[nilai5]));
  83. $cekpredikat = mysql_num_rows(mysql_query("SELECT * FROM rb_predikat where kode_kelas='$_GET[id]' AND id_kls_pararel='$_GET[ie]'"));
  84. if ($cekpredikat >= 1){
  85. $grade1 = mysql_fetch_array(mysql_query("SELECT * FROM `rb_predikat` where (".number_format($ratarata)." >=nilai_a) AND (".number_format($ratarata)." <= nilai_b) AND kode_kelas='$_GET[id]'"));
  86. }else{
  87. $grade1 = mysql_fetch_array(mysql_query("SELECT * FROM `rb_predikat` where (".number_format($ratarata)." >=nilai_a) AND (".number_format($ratarata)." <= nilai_b) AND kode_kelas='0'"));
  88. }
  89.  
  90. echo "<tr>
  91. <td></td>
  92. <td></td>
  93. <td>$n[kd]. $n[kompetensi_dasar]</td>
  94. <td align=center>$n[nilai1]</td>
  95. <td align=center>$n[nilai2]</td>
  96. <td align=center><a href='index.php?view=raport&act=listsiswa&jdwl=".$_GET[jdwl]."&kd=".$_GET[kd]."&id=".$_GET[id]."&ie=".$_GET[ie]."&tahun=".$_GET[tahun]."&edit=".$n[id_nilai_pengetahuan]."&nisn=".$r[nisn]."#$r[nisn]' class='btn btn-xs btn-success'><span class='glyphicon glyphicon-edit'></span></a>
  97. <a href='index.php?view=raport&act=listsiswa&jdwl=".$_GET[jdwl]."&kd=".$_GET[kd]."&id=".$_GET[id]."&ie=".$_GET[ie]."&tahun=".$_GET[tahun]."&delete=".$n[id_nilai_pengetahuan]."&nisn=".$r[nisn]."' class='btn btn-xs btn-danger' onclick=\"return confirm('Apa anda yakin untuk hapus Data ini?')\"><span class='glyphicon glyphicon-remove'></span></a></td>
  98. </tr>";
  99. }
  100. $ta = mysql_fetch_array(mysql_query("SELECT kodejdwl, nisn, sum(nilai1)/count(nisn) as uh, sum(nilai2)/count(nisn) as tugas FROM `rb_nilai_pengetahuan` where nisn='$r[nisn]' AND kodejdwl='$_GET[jdwl]' GROUP BY kodejdwl"));
  101. $countKD = mysql_fetch_array(mysql_query("SELECT count(`id_nilai_pengetahuan`) as countKD FROM `rb_nilai_pengetahuan` WHERE nisn='$r[nisn]' and `kodejdwl` = '$_GET[jdwl]'"));
  102.  
  103. $range = mysql_fetch_array(mysql_query("SELECT sum(nilai1)/$countKD[countKD] as uh, sum(nilai2)/$countKD[countKD] as tugas FROM `rb_nilai_pengetahuan` WHERE nisn='$r[nisn]' and `kodejdwl` = '$_GET[jdwl]'"));
  104. $ee = mysql_fetch_array(mysql_query("SELECT * FROM rb_nilai_pengetahuan_semester where id_nilai_pengetahuan_semester='$_GET[editsemester]'"));
  105. $sms = mysql_fetch_array(mysql_query("SELECT * FROM rb_nilai_pengetahuan_semester where kodejdwl='$_GET[jdwl]' AND nisn='$r[nisn]'"));
  106.  
  107. // $total = ($range[uh]+$range[tugas]+$sms[nilai1]+$sms[nilai2])/4;
  108. $total = ($sms[nilai1]*6+$sms[nilai2]*4)/10;
  109.  
  110. $rapn = mysql_fetch_array(mysql_query("SELECT kodejdwl, nisn, (sum(uh)+sum(tugas))/2 as total FROM ((SELECT kodejdwl, nisn, sum(nilai1)/count(nisn) as uh, sum(nilai2)/count(nisn) as tugas FROM `rb_nilai_pengetahuan` where nisn='$r[nisn]' GROUP BY kodejdwl) UNION (SELECT kodejdwl, nisn, nilai1, (nilai2*2) FROM rb_nilai_pengetahuan_semester where nisn='$r[nisn]')) as a where a.kodejdwl='$_GET[jdwl]' GROUP by a.kodejdwl"));
  111.  
  112.  
  113. // echo "<tr>
  114. // <td></td><td></td>
  115. // <td align=center class='pull-right'>Nilai Rata-Rata</td>
  116. // <td align=center>".number_format($ta[uh])."</td>
  117. // <td align=center>".number_format($ta[tugas])."</td>
  118. // </tr>";
  119.  
  120. if ($_GET[nis]==$r[nisn]){
  121. echo "<form action='' method='POST'>
  122. <input type='hidden' value='$_GET[jdwl]' name='jdwl'>
  123. <td align=right>Nilai Rata-Rata Bulanan :</td>
  124. <td align=center colspan='2'><input type='hidden' value='$r[nisn]' name='nis'><input type='hidden' value='$ee[id_nilai_pengetahuan_semester]' name='id'><input type='text' name='a' class='form-control' style='width:95px; text-align:center; padding:0px; border:1px solid red' value='$ee[nilai1]'></td>
  125. <td rowspan='3' align=center colspan='2' style='vertical-align:middle;'>
  126. <button type='submit' name='updatesemester' title='Simpan Nilai UTS atau UAS' class='btn btn-lg btn-success' style='margin-top:5px'><span class='glyphicon glyphicon-ok'></span></button></a>
  127. </td>
  128. </tr>
  129. <tr>
  130. <td></td><td></td><td></td>
  131. <td align=right>Nilai UAS</td>
  132. <td align=center colspan='2'><input type='text' name='b' class='form-control' style='width:95px; text-align:center; padding:0px; border:1px solid red' value='$ee[nilai2]'></td>
  133. </tr>
  134. </form>";
  135. }else{
  136. echo "
  137. <td align=right>Rata-Rata Nilai Bulanan :</td>
  138. <td align=center colspan='2'>".number_format($sms[nilai1])."</td>
  139. <td rowspan='3' align=center colspan='2' style='vertical-align:middle;'>
  140. <a title='Ubah Nilai UTS atau UAS' href='index.php?view=raport&act=listsiswa&jdwl=$_GET[jdwl]&kd=$_GET[kd]&id=$_GET[id]&ie=$_GET[ie]&tahun=$_GET[tahun]&nis=$r[nisn]&editsemester=$sms[id_nilai_pengetahuan_semester]#$r[nisn]' class='btn btn-lg btn-primary' style='margin-top:5px'><span class='glyphicon glyphicon-edit'></span></a>
  141. </td>
  142. </tr>
  143. <tr>
  144. <td></td><td></td></td><td>
  145. <td align=right>Nilai UAS :</td>
  146. <td align=center colspan='2'>".number_format($sms[nilai2])."</td>
  147. </tr>";
  148. }
  149.  
  150. echo "<tr>
  151. <td></td><td></td></td><td>
  152. <td align=right ><b style='color:blue'>Nilai Raport :</b></td>
  153. <td align=center colspan='2'><b style='color:blue'>".number_format($total)."</b></td>
  154. </tr>";
  155. $no++;
  156. }
  157.  
  158. if (isset($_POST[updatesemester])){
  159. if (trim($_POST[id])==''){
  160. $query = mysql_query("INSERT INTO rb_nilai_pengetahuan_semester VALUES('','$_POST[jdwl]','$_GET[kdpelajaran]','$_POST[nis]','$_POST[a]','$_POST[b]','$_SESSION[id]','".date('Y-m-d H:i:s')."')");
  161. }else{
  162. $query = mysql_query("UPDATE rb_nilai_pengetahuan_semester SET nilai1 = '$_POST[a]', nilai2 = '$_POST[b]' where id_nilai_pengetahuan_semester='$_POST[id]'");
  163. }
  164.  
  165. if ($query){
  166. echo "<script>document.location='index.php?view=raport&act=listsiswa&jdwl=$_GET[jdwl]&kd=$_GET[kd]&id=$_GET[id]&ie=$_GET[ie]&tahun=$_GET[tahun]&sukses#$_POST[nis]';</script>";
  167. }else{
  168. echo "<script>document.location='index.php?view=raport&act=listsiswa&jdwl=$_GET[jdwl]&kd=$_GET[kd]&id=$_GET[id]&ie=$_GET[ie]&tahun=$_GET[tahun]&gagal#$_POST[nis]';</script>";
  169. }
  170. }
  171.  
  172. echo "</tbody>
  173. </table>
  174. </div>";?>
  175. <div class='modal fade bs-example-modal-lg' id='importnilaip' tabindex='-1' role='dialog' aria-labelledby='myModalLabel' aria-hidden='true'>
  176. <div class='modal-dialog modal-lg'>
  177. <div class='modal-content'>
  178. <div class='modal-header'>
  179. <button type='button' class='close' data-dismiss='modal' aria-hidden='true'>&times;</button>
  180. <h5 class='modal-title' id='myModalLabel'>Import Nilai</h5>
  181. </div>
  182. <div class='modal-body'>
  183. <?php
  184. echo "<form action='test.php' method='POST' enctype='multipart/form-data'>
  185. <div class='form-group'>
  186. <a title='Lihat Format File' href='download_format.php?file=format_soal.xls'><span class='glyphicon glyphicon-file'></span> Ambil Format File</a>
  187. <label style='width:13%;' for='inputEmail3' class='col-sm-2 control-label'>File (.xls)</label>
  188. <div style='background:#fff;' class='input-group col-sm-10'>
  189. <input type='file' class='required form-control' name='nilaip'>
  190. </div>
  191. </div>
  192. <div class='form-group'>
  193. <div style='margin-left:13%;' class='col-sm-offset-2'>
  194. <button type='submit' class='btn btn-primary'>Upload Nilai</button>
  195. </div>
  196. </div>
  197. </form>";
  198. ?>
  199. <div style='clear:both'></div>
  200. </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!