API tools faq
paste
Advertisement
joris

Coba

joris
Jul 27th, 2012
61
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 11.81 KB | None | 0 0
raw download clone embed print report
  1. <? include "koneksi.php"; ?>
  2. <html>
  3. <head>
  4. <title>Saran Kritik </title>
  5. <link rel="stylesheet" href="css/table.css" type="text/css"/>
  6.  
  7. <link rel="stylesheet" type="text/css" href="css/table.css" />
  8. <script type="text/javascript" src="jquery/jquery-1.2.3.pack.js"></script>
  9. <script type="text/javascript" src="jquery/jquery.validate.pack.js"></script>
  10.  
  11. <script>
  12.     function openWindow() {
  13.         sUrl="kreativpop.php";
  14.         features = 'toolbar=no, left=350,top=100, ' + 'directories=no, status=no, menubar=no, ' + 'scrollbars=yes, resizable=no, width=450, height=450';
  15.         window.open(sUrl,"winChild",features);
  16.     };
  17. </script>
  18.     <style type="text/css">
  19.     input.error, select.error { border: 1px solid red; }
  20.     label.error { color:red; margin-left: 10px; }
  21.     </style>
  22.  
  23. </head>
  24. <body>
  25.  
  26. <form name="formPK" method="post" action="">
  27. <fieldset id="fil">
  28. <legend id="legend">Pilih Kelas</legend>
  29. <table id="tabel" width="550" cellspacing="0">
  30.   <tr class="alts" >
  31.     <th scope="col" colspan="9">PILIH KELAS </th>
  32.   </tr>
  33.   <tr>
  34.   <tr class="alt">
  35.    <td colspan="2">Kode Kelas</td>
  36.    <td width="180">Nama Wali Kelas </td>
  37.    <td width="88">Tahun Ajaran </td>
  38.    <td width="78">Jurusan</td>
  39.   </tr>
  40.  <tr class="alt">
  41.    <td colspan="2"><input name="kd_kelas" id="kd_kelas" type="text" size="5" value="<?php echo isset($_POST['kd_kelas']) ? $_POST['kd_kelas'] : '';?>" readonly>&nbsp;<input  type="button"  value="Pilih Kelas" onClick="openWindow();"/><div style="color:red"><?php echo isset($error['kd_kelas']) ? $error['kd_kelas'] : '';?></div></td>
  42.     <td width="180"><input name="nm_wk" id="nm_wk" type="text" value="<?php echo isset($_POST['nm_wk']) ? $_POST['nm_wk'] : '';?>" readonly><div style="color:red"><?php echo isset($error['nm_wk']) ? $error['nm_wk'] : '';?></div></td>
  43.     <td width="88"><input name="thn_ajaran" id="thn_ajaran" type="text" size="10" value="<?php echo isset($_POST['thn_ajaran']) ? $_POST['thn_ajaran'] : '';?>" readonly><div style="color:red"><?php echo isset($error['thn_ajaran']) ? $error['thn_ajaran'] : '';?></div></td>
  44.     <td><input name="jurusan" id="jurusan" type="text" size="10" value="<?php echo isset($_POST['jurusan']) ? $_POST['jurusan'] : '';?>" readonly><div style="color:red"><?php echo isset($error['jurusan']) ? $error['jurusan'] : '';?></div></td>
  45.   </tr>
  46.       <th colspan="6"><input type="submit" name="pilsem" id="pilsem" value="Pilih Semester"></th>
  47. </table>
  48. </fieldset>
  49. <?php
  50.          if(isset($_POST['pilsem']))    {
  51.          $kd_kelas      = $_POST['kd_kelas'];    
  52.          $nm_wk         = $_POST['nm_wk'];
  53.          $thn_ajaran    = $_POST['thn_ajaran'];      
  54.          $error = array();  
  55.               if(empty($kd_kelas)){  
  56.               $error['kd_kelas'] = 'tidak boleh kosong';  
  57.               }
  58.               if(empty($nm_wk)){  
  59.               $error['nm_wk'] = 'tidak boleh kosong';  
  60.               }
  61.               if(empty($thn_ajaran)){  
  62.               $error['thn_ajaran'] = 'tidak boleh kosong';  
  63.               }
  64.               if(empty($error)){
  65.         ?>
  66. <fieldset id="fil">
  67. <legend id="legend">Pilih Semester</legend>
  68. <table id="tabel" width="650" cellspacing="0">
  69. <tr class="alt">
  70.     <th colspan="9">Kode Kelas  :&nbsp;<em>[<?=$kd_kelas?>]</em>Nama Wali Kelas :<em>&nbsp;[<?= $nm_wk?>]&nbsp;</em> </br> Tahun Ajaran:<em>&nbsp;[<?=$thn_ajaran?>]&nbsp;</em> </em>
  71.     </th>
  72.   </tr>
  73. <tr>
  74.     <td width="162" class="alt"> Semester : <select name="semester" id="semester" value="<?php echo isset($_POST['semester']) ? $_POST['semester'] : '';?>" class="required" title="harap Pilih Semester">
  75.       <option value="">--Pilih--</option>
  76.       <option value="Ganjil">Ganjil</option>
  77.       <option value="Genap">Genap</option>
  78.     </select><div style="color:red"><?php echo isset($error['semester']) ? $error['semester'] : '';?></div>
  79.     </td>
  80.     <td width="482" class="alt"><input type="submit" name="lihatSKSiswa" id="lihatSKSiswa" value="LihatSKSiswa"> </td>
  81. </tr>
  82. </table>
  83. <? }}?>
  84. </fieldset>
  85.  
  86.  
  87.             <?
  88.             if(isset($_POST['lihatSKSiswa']))   {
  89.                  $kd_kelas      = $_POST['kd_kelas'];    
  90.                  $nm_wk         = $_POST['nm_wk'];
  91.                  $thn_ajaran    = $_POST['thn_ajaran'];
  92.                  $semester      = $_POST['semester'];  
  93.                  $error = array();  
  94.                  
  95.                 if(empty($semester)){  
  96.                 $error['semester'] = 'Tidak Boleh Kosong';  
  97.                 }  
  98.                
  99.                 if(empty($error)){
  100.        
  101.                     $query1 = "SELECT a.nis, b.nama, a.kd_kelas, a.thn_ajaran  
  102.                              FROM detilkelas a
  103.                               JOIN mastasiswa b
  104.                              ON a.nis=b.nis
  105.                              where a.kd_kelas='".$kd_kelas."' and a.nm_wk='".$nm_wk."' and a.thn_ajaran = '".$thn_ajaran."' ";
  106.                     $sql1   = mysql_query($query1);
  107.                    
  108.             ?>
  109.            
  110.  
  111. <?
  112. if($semester['semester']="Ganjil")
  113. { ?>
  114.  
  115. <fieldset id="fil">
  116. <legend id="legend">lIHAT SK SISWA</legend>
  117. <table id="tableData" width="830" cellspacing="0">
  118.   <tr class="alt">
  119.     <th colspan="6">Kode Kelas  :&nbsp;<em>[<?=$kd_kelas?>]</em>Nama Wali Kelas :<em>&nbsp;[<?= $nm_wk?>]&nbsp;</em> </br> Tahun Ajaran:<em>&nbsp;[<?=$thn_ajaran?>]&nbsp;</em>Semester :<em>&nbsp;[<?=$semester?>]&nbsp;<input type="hidden" name="semester" value="<?=$semester?>"/></em>
  120.     </tr>
  121.     <tr class="alt">
  122.     <td width="15" rowspan="2">No.</td>
  123.     <td width="60" rowspan="2" align="center">NIS</td>
  124.     <td width="150" rowspan="2" align="center">NAMA</td>
  125.     </tr>
  126.     <tr class="alt">
  127.     <td align="center" width="170">CATATAN WALI KELAS </td>
  128.     <td align="center" width="170">MATA PELAJARAN YANG HARUS PERBAIKAN NILAI</td>
  129.     </tr>
  130.   <?php
  131.         $i=1;
  132.         while ($hasil = mysql_fetch_array($sql1)){
  133.             if(trim($_POST['semester'])=="Genap"){
  134.                 $query2 = "SELECT a.nis, c.keterangan1, c.keterangan2
  135.                         FROM mastasiswa a
  136.                         JOIN SK c
  137.                         ON a.nis=c.nis
  138.                         WHERE a.nis='".$hasil['nis']."' AND c.thn_ajaran='".$thn_ajaran."' AND c.semester='Genap'";
  139.             $sql2 = mysql_query($query2);
  140.                 }else{
  141.                     $query2 = "SELECT a.nis, c.keterangan1, c.keterangan2
  142.                         FROM mastasiswa a
  143.                         JOIN SK c
  144.                         ON a.nis=c.nis
  145.                         WHERE a.nis='".$hasil['nis']."' AND c.thn_ajaran='".$thn_ajaran."' AND c.semester='Ganjil'";
  146.             $sql2 = mysql_query($query2);
  147.                 }
  148.            
  149.            
  150.            
  151.     ?>  
  152.   <tr class="<?=(++$no%2) ? "tr1" : "tr2" ?>">
  153.     <td class="alts"><?php echo $i;?></td>
  154.     <td class="alts"><? echo $hasil['nis'];?></td>
  155.     <td class="alts"><? echo $hasil['nama'];?></td>
  156.    
  157.     <?php if($hasil2 = mysql_fetch_array($sql2)){ ?>
  158.    
  159.     <td class="alts"><? echo $hasil2['keterangan1']?>&nbsp;<? echo $hasil2['keterangan1']?></td>
  160.     <td class="alts"><? echo $hasil2['keterangan2']?>&nbsp;<? echo $hasil2['keterangan2']?></td>
  161.     <? } else
  162.         { ?>
  163.     <td class="alts">Belum Di Isi</td>
  164.     <td class="alts">Belum Di Isi</td>
  165.   </tr>
  166.   <? } ?>
  167. <? $i++; } ?>            
  168.   <tr>
  169.     <th colspan="6">
  170.     <input type="submit" name="isiSK" id="isiSK" value="Isi Saran Kritik"></th>
  171.     </tr>
  172. </table>
  173. </fieldset>
  174.  
  175.  
  176.  
  177.    
  178. <? }
  179. if($semester['semester']="Genap")
  180. { ?>
  181. <fieldset id="fil">
  182. <legend id="legend">lIHAT SK SISWA</legend>
  183. <table id="tableData" width="830" cellspacing="0">
  184.   <tr class="alt">
  185.     <th colspan="6">Kode Kelas  :&nbsp;<em>[<?=$kd_kelas?>]</em>Nama Wali Kelas :<em>&nbsp;[<?= $nm_wk?>]&nbsp;</em> </br> Tahun Ajaran:<em>&nbsp;[<?=$thn_ajaran?>]&nbsp;</em>Semester :<em>&nbsp;[<?=$semester?>]&nbsp;<input type="hidden" name="semester" value="<?=$semester?>"/></em>
  186.     </tr>
  187.     <tr class="alt">
  188.     <td width="15" rowspan="2">No.</td>
  189.     <td width="60" rowspan="2" align="center">NIS</td>
  190.     <td width="150" rowspan="2" align="center">NAMA</td>
  191.     </tr>
  192.     <tr class="alt">
  193.     <td align="center" width="170">CATATAN WALI KELAS </td>
  194.     <td align="center" width="170">SISWA NAIK KELAS GA?</td>
  195.     </tr>
  196.   <?php
  197.         $i=1;
  198.         while ($hasil = mysql_fetch_array($sql1)){
  199.             $query2 = "SELECT a.nis, c.keterangan1, c.keterangan2
  200.                         FROM mastasiswa a
  201.                         JOIN SK c
  202.                         ON a.nis=c.nis
  203.                         WHERE a.nis='".$hasil['nis']."' AND c.thn_ajaran='".$thn_ajaran."' AND c.semester='".$semester."'";
  204.             $sql2 = mysql_query($query2);
  205.     ?>  
  206.   <tr class="<?=(++$no%2) ? "tr1" : "tr2" ?>">
  207.     <td class="alts"><?php echo $i;?></td>
  208.     <td class="alts"><? echo $hasil['nis'];?></td>
  209.     <td class="alts"><? echo $hasil['nama'];?></td>
  210.    
  211.     <?php if($hasil2 = mysql_fetch_array($sql2)){ ?>
  212.    
  213.     <td class="alts"><? echo $hasil2['keterangan1']?>&nbsp;<? echo $hasil2['keterangan1']?></td>
  214.     <td class="alts"><? echo $hasil2['keterangan2']?>&nbsp;<? echo $hasil2['keterangan2']?></td>
  215.     <? } else
  216.         { ?>
  217.     <td class="alts">Belum Di Isi</td>
  218.     <td class="alts">Belum Di Isi</td>
  219.   </tr>
  220.   <? } ?>
  221. <? $i++; } ?>            
  222.   <tr>
  223.     <th colspan="6">
  224.     <input type="submit" name="isiSK" id="isiSK" value="Isi Saran Kritik"></th>
  225.     </tr>
  226. </table>
  227. </fieldset>
  228. <? } }} ?>
  229.  
  230.  
  231.  
  232.         <?
  233.             if(isset($_POST['isiSK']))  {
  234.                  $kd_kelas      = $_POST['kd_kelas'];    
  235.                  $nm_wk         = $_POST['nm_wk'];
  236.                  $thn_ajaran    = $_POST['thn_ajaran'];
  237.                  $semester      = $_POST['semester'];
  238.                  $q = "SELECT a.nis, b.nama, a.kd_kelas, a.thn_ajaran  
  239.                              FROM detilkelas a
  240.                               JOIN mastasiswa b
  241.                              ON a.nis=b.nis
  242.                              where a.kd_kelas='".$kd_kelas."' and a.nm_wk='".$nm_wk."' and a.thn_ajaran = '".$thn_ajaran."' ";
  243.                  $s = mysql_query($q);
  244.             ?>
  245.        
  246.         <fieldset id="fil">
  247. <legend id="legend">Lihat </legend>
  248. <table id="tableData" width="830" cellspacing="0">
  249.   <tr class="alt">
  250.     <th colspan="6">Kode Kelas  :&nbsp;<em>[<?=$kd_kelas?>]</em>Nama Wali Kelas :<em>&nbsp;[<?= $nm_wk?>]&nbsp;</em> </br> Tahun Ajaran:<em>&nbsp;[<?=$thn_ajaran?>]&nbsp;</em>Semester :<em>&nbsp;[<?=$semester?>]&nbsp;<input type="hidden" name="semester" value="<?=$semester?>"/></em>
  251.     </tr>
  252.   <tr class="alt">
  253.     <td width="15" rowspan="2">No.</td>
  254.     <td width="60" rowspan="2" align="center">NIS</td>
  255.     <td width="150" rowspan="2" align="center">NAMA</td>
  256.     </tr>
  257.    
  258.   <tr class="alt">
  259.     <td align="center" width="170">CATATAN WALI KELAS </td>
  260.     <td align="center" width="170">KETERANGAN KENAIKAN KELAS SISWA</td>
  261.   </tr>
  262.  
  263.     <?php  
  264.               $e=1;
  265.               while ($ha = mysql_fetch_array($s)){
  266.         ?>
  267.        
  268. <tr class="<?=(++$no%2) ? "tr1" : "tr2" ?>">
  269.     <td class="alts"><?php echo $e;?></td>
  270.     <td class="alts"><input type="text" id="nis[]" name="nis[]" value="<? echo $ha['nis'];?>" size="8" readonly></td>
  271.     <td class="alts"><input type="text" id="nama[]" name="nama[]" value="<? echo $ha['nama'];?>" size="25" readonly></td>
  272.     <td>
  273.     <textarea name="" id="alamat" class="required" title="Harap di Isi"  value="<?php echo isset($_POST['alamat']) ? $_POST['alamat'] : '';?>" /></textarea>
  274.     </td>
  275.      <td>
  276.     <textarea name="" id="alamat" class="required" title="Harap di Isi"  value="<?php echo isset($_POST['alamat']) ? $_POST['alamat'] : '';?>" /></textarea>
  277.     </td>
  278. </tr>
  279.  
  280.   </tr>
  281.   <? $e++; } ?>
  282.   <tr>
  283.       <th colspan="9"><input type="submit" name="simpan_SK" id="simpan_SK" value="Simpan SK Siswa"></th>
  284.   </tr>          
  285.   </table>
  286. </fieldset>
  287. <? } ?>
  288.  
  289.  
  290. <?
  291.     if (isset($_POST['simpan_SK'])) {        
  292.        $nis                 = $_POST['nis'];
  293.        $thn_ajaran          = $_POST['thn_ajaran'];
  294.        $semester            = $_POST['semester'];
  295.        $ket1                = $_POST['keterangan1'];
  296.        $ket2                = $_POST['keterangan2'];
  297.            
  298.         for($i=0;$i<count($nis);$i++){
  299.         $kuery = "insert into SK value('$nis[$i]','$thn_ajaran','$semester','$keterangan1[$i]','$keterangan2[$i]')";
  300.         $esq = mysql_query($kuery);
  301.            }
  302.         if ($esq){
  303.       ?>
  304.             <script language="JavaScript" type="text/javascript">
  305.             alert("Data telah tersimpan");
  306.             document.location = "?hal=entryssarankritik";
  307.             </script>
  308.     <?
  309.       }  else {
  310.                   die(mysql_error());
  311.       }} ?>
  312.  
  313.  
  314. </form>
  315. </body>
  316. </html>
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!