/@dm1n/modul/mod_submenu/submenu.php

<?php

session_start();

 if (empty($_SESSION['username']) AND empty($_SESSION['passuser'])){

  echo "<link href='style.css' rel='stylesheet' type='text/css'>

 <center>Untuk mengakses modul, Anda harus login <br>";

  echo "<a href=../../index.php><b>LOGIN</b></a></center>";

}

else{

$aksi="modul/mod_submenu/aksi_submenu.php";

switch($_GET[act]){

  // Tampil Sub Menu

  default:

    echo "<h2>Sub Menu</h2>

          <input type=button value='Tambah Sub Menu' onclick=\"window.location.href='?module=submenu&act=tambahsubmenu';\">

          <table>

		<tr><th>no</th><th>sub menu</th><th>menu utama</th><th>seksi</th><th>link submenu</th><th>aksi</th></tr>";



    $tampil = mysql_query("SELECT a.id_sub,a.nama_sub,b.nama_menu,a.seksi,a.link_sub FROM submenu a,mainmenu b WHERE a.id_main=b.id_main");

  

    $no = 1;

    while($r=mysql_fetch_array($tampil)){

      echo "<tr><td>$no</td>

                <td>$r[nama_sub]</td>

                <td>$r[nama_menu]</td>

				<td align='center'>$r[seksi]</td>

                <td>$r[link_sub]</td>

		            <td><a href=?module=submenu&act=editsubmenu&id=$r[id_sub]>Edit</a> | 

		                <a href=$aksi?module=submenu&act=hapus&id=$r[id_sub]>Hapus</a></td>

		

		        </tr>";

      $no++;

    }

    echo "</table>";

    break;

  

  case "tambahsubmenu":

    echo "<h2>Tambah Sub Menu</h2>

          <form method=POST action='$aksi?module=submenu&act=input'>

          <table>

          <tr><td>Sub Menu</td>     <td> : <input type=text name='nama_sub'></td></tr>

          <tr><td>Menu Utama</td>  <td> : 

          <select name='menu_utama'>

            <option value=0 selected>- Pilih Menu Utama -</option>";

            $tampil=mysql_query("SELECT * FROM mainmenu ORDER BY nama_menu");

            while($r=mysql_fetch_array($tampil)){

              echo "<option value=$r[id_main]>$r[nama_menu]</option>";

            }

    echo "</select></td></tr>

	 <tr><td>Seksi</td><td> : 

		    <select name='seksi'>

		    	<option value=0 selected='selected'>- Pilih Seksi -</option>

		    	<option value='ALL'>ALL - Semua Seksi</option>

		    	<option value='UM'>UM - Sub Bagian Umum</option>

		    	<option value='PD'>PD - Pencairan Dana</option>

		    	<option value='BP'>BP - Bank dan Giro Pos</option>

		    	<option value='VR'>VR - Verifikasi dan Akuntansi</option>

		    	<option value='APD'>APD - Kasi Pencairan Dana</option>

		    </select>

		   </td>

	  </tr>

          <tr><td>Link Sub Menu</td><td> : <input type=text name='link_sub'></td></tr>

          <tr><td colspan=2><input type=submit value=Simpan>

                            <input type=button value=Batal onclick=self.history.back()></td></tr>

          </table></form>";

     break;

    

  case "editsubmenu":

    $edit = mysql_query("SELECT * FROM submenu WHERE id_sub='$_GET[id]'");

    $r    = mysql_fetch_array($edit);



    echo "<h2>Edit Sub Menu</h2>

          <form method=POST action=$aksi?module=submenu&act=update>

          <input type=hidden name=id value=$r[id_sub]>

          <table>

          <tr><td width=70>Sub Menu</td>     <td> : <input type=text name='nama_sub' value='$r[nama_sub]'></td></tr>

          <tr><td>Menu Utama</td>  <td> : <select name='menu_utama'>";

 

          $tampil=mysql_query("SELECT * FROM mainmenu ORDER BY nama_menu");

          if ($r[id_main]==0){

            echo "<option value=0 selected>- Pilih Menu Utama -</option>";

          }   



          while($w=mysql_fetch_array($tampil)){

            if ($r[id_main]==$w[id_main]){

              echo "<option value=$w[id_main] selected>$w[nama_menu]</option>";

            }

            else{

              echo "<option value=$w[id_main]>$w[nama_menu]</option>";

            }

          }

    echo "</select></td></tr>

	 <tr><td>Seksi</td><td> : 

		    <select name='seksi'>";

		    $qSeksi	= mysql_query("SELECT DISTINCT seksi FROM r_seksi ORDER BY seksi");

		    if($r[id_sub==0]){

    		    echo "<option value=0 selected='selected'>- Pilih Seksi -</option>";

		    }

		    while($rSeksi	= mysql_fetch_array($qSeksi)){

			    if($r[seksi]==$rSeksi[seksi]){

		    			echo "<option value='$rSeksi[seksi]' selected='selected'>$rSeksi[seksi] - $rSeksi[namaseksi]</option>";

			    }

			    else{

				    	echo "<option value='$rSeksi[seksi]'>$rSeksi[seksi] - $rSeksi[namaseksi]</option>";

			    }

		    }

	

          echo "<tr><td>Link Sub Menu</td><td> : <input type=text name='link_sub' value='$r[link_sub]'></td></tr>

          <tr><td colspan=2><input type=submit value=Update>

                            <input type=button value=Batal onclick=self.history.back()></td></tr>

         </table></form>";

    break;  

}

}

?>