/quanlyktx/admincp/lop/lop.php
PHP | 270 lines | 264 code | 3 blank | 3 comment | 17 complexity | e11116244578d8b4ac598a3034d877f2 MD5 | raw file
- <?php
- require_once("../config/config.php");
- ob_start();
- ?>
-
- <div id="main_lop">
- <?php
- if(!isset($_GET["thaydoi"]))
- {
- ?>
- <form action="" method="post" name="form_lop">
- <span style="float:right;">
- Li?t Kę Danh Sách:
- <select name="danhsach" onchange="form_lop.submit()" style="width:250px;text-align:center">
- <option value="1" <?php if((isset($_POST["danhsach"]))&&($_POST["danhsach"]==1)) echo "selected"; ?>>Khoa</option>
- <option value="2" <?php if((isset($_POST["danhsach"]))&&($_POST["danhsach"]==2)) echo "selected"; ?>>Khu</option>
- <option value="3" <?php if((!isset($_POST["danhsach"]))||($_POST["danhsach"]==3)) echo "selected"; ?>>L?p</option>
- <option value="4" <?php if((isset($_POST["danhsach"]))&&($_POST["danhsach"]==4)) echo "selected"; ?>>Phňng</option>
- <option value="5" <?php if((isset($_POST["danhsach"]))&&($_POST["danhsach"]==5)) echo "selected"; ?>>Sinh Vien</option>
- </select>
- </span><br/><br />
- <h1 style="text-align:center">Qu?n Lý Ký Túc Xá Theo L?p </h1>
- <?php
- if(!isset($_POST["danhsach"]))
- {
- $khoa=mysql_query("select * from khoa",$quanlyktx);
- ?> <span>Danh Sách C?a Khoa:
- <select name="khoa" onchange="form_lop.submit()" style="width:250px;text-align:center;">
- <option value="-1"> Ch?n </option>
- <?php while($row_khoa=mysql_fetch_array($khoa))
- {
- ?> <option value="<?php echo $row_khoa["MA_KHOA"];?>" <?php if((isset($_POST["khoa"]))&&($_POST["khoa"]== $row_khoa["MA_KHOA"])) echo "selected"; ?>><?php echo $row_khoa["TEN_KHOA"];?></option>
- <?php }
- ?> </select>
- </span><br/><br />
-
- <?php
-
- }
- elseif(isset($_POST["danhsach"]))
- {
- if($_POST["danhsach"]==1)
- {
- //header("location:khoa/listkhoa.php");
- echo "<script>window.location='khoa/listkhoa.php';</script>";
- }
- elseif($_POST["danhsach"]==2)
- {
- require_once("khu/_khu.php");
- }
- elseif($_POST["danhsach"]==3)
- {
- $khoa=mysql_query("select * from khoa",$quanlyktx);
- ?> <span>Danh Sách C?a Khoa:
- <select name="khoa" onchange="form_lop.submit()" style="width:250px;text-align:center;">
- <option value="-1"> Ch?n </option>
- <?php while($row_khoa=mysql_fetch_array($khoa))
- {
- ?> <option value="<?php echo $row_khoa["MA_KHOA"];?>" <?php if((isset($_POST["khoa"]))&&($_POST["khoa"]== $row_khoa["MA_KHOA"])) echo "selected"; ?>><?php echo $row_khoa["TEN_KHOA"];?></option>
- <?php }
- ?> </select>
- </span><br/>
- <?php if((isset($_POST["khoa"]))&&($_POST["khoa"]!=-1))
- {
- $lop="select * from lop where MA_KHOA= '".$_POST["khoa"]."'";
- $query_lop=mysql_query($lop,$quanlyktx);
- $stt=0;
- ?> <table width="98%" border="1" cellspacing="0" cellpadding="3">
- <tr>
- <td align="center" valign="top" bgcolor="#00CCFF"><h1><strong>STT</strong></h1></td>
- <td align="center" valign="top" bgcolor="#00CCFF"><h1><strong>Mă L?p</strong></h1></td>
- <td align="center" valign="top" bgcolor="#00CCFF"><h1><strong>Tęn L?p</strong></h1></td>
- <td align="center" valign="top" bgcolor="#00CCFF"><h1><strong>S? L??ng</strong></h1></td>
- <td align="center" valign="top" bgcolor="#00CCFF"><h1>Giáo Vięn Ch? Nhi?m</h1></td>
- <td align="center" valign="top" bgcolor="#00CCFF"><h1> </h1></td>
- </tr>
- <?php while($row_lop=mysql_fetch_array($query_lop))
- {
- ?> <tr>
- <td><?php echo $stt++;?></td>
- <td><?php echo $row_lop['MA_LOP'];?></td>
- <td><?php echo $row_lop['TEN_LOP'];?></td>
- <td><?php echo $row_lop['SOLUONG_SV'];?></td>
- <td><?php echo $row_lop['GIAOVIEN_CN'];?></td>
- <td><a href="index.php?chon=2&&ma_lop=<?php echo $row_lop['MA_LOP'];?>&&thaydoi=1">Edit</a></td>
- </tr>
- <?php }
- ?> <tr>
- <td colspan="6" style="text-align:center;">
- <a href="index.php?chon=2&&thaydoi=2"><input type="button" value=" Thęm L?p" /></a>
- </td>
- </tr>
- </table>
- <?php
- }
- }
- elseif($_POST["danhsach"]==4)
- {
- //header("location:index.php?chon=3");
- echo "<script>window.location='index.php?chon=3';</script>";
- }
- elseif($_POST["danhsach"]==5)
- {
- //header("location:sinhvien/quanlysinhvien.php");
- echo "<script>window.location='sinhvien/quanlysinhvien.php';</script>";
- }
- }
- ?>
- </form>
- <?php
- }
- elseif($_GET["thaydoi"]==1)
- {
- if(isset($_GET["sua"]))
- {
- $query_update= "update lop set MA_LOP='".$_POST['malop']."',TEN_LOP='".$_POST['tenlop']."',SOLUONG_SV=".$_POST['soluong'].",GIAOVIEN_CN='".$_POST['giaovien']."',MA_KHOA='".$_POST['khoa']."' where MA_LOP='".$_GET["ma_lop"]."'";
- $bol=mysql_query($query_update,$quanlyktx);
- if($bol)
- {
- echo "S?a Thŕnh Công!<a href='#' onClick='history.go(-1)'>Nh?n Vŕo ?ây ?? Quay Tr? L?i</a>";
- }
- else
- {
- echo "Có L?i!Vui Lňng Lięn H? V?i Ng??i Qu?n Tr? ?? S?a L?i Nŕy";
- }
- }
- else
- {
- $lop=mysql_query("select * from lop where MA_LOP='".$_GET["ma_lop"]."'",$quanlyktx);
- if($row_lop=mysql_fetch_array($lop))
- {
- ?> <form action="index.php?chon=2&&thaydoi=1&&sua=yes&&ma_lop=<?php echo $_GET["ma_lop"];?>" method="post" name="form_sua">
- <table width="589" height="76" border="0" align="center" style="font: 13px/1.5em Verdana;">
- <tr>
- <td height="28">
- Mă L?p:
- </td>
- <td>
- <input type="text" value="<?php echo $_GET["ma_lop"];?>" name="malop" id="malop" size="25px" onFocus="form_lop.malop.value=''">
- </td>
- </tr>
- <tr>
- <td>
- Tęn L?p:
- </td>
- <td>
- <input type="text" value="<?php echo $row_lop["TEN_LOP"];?>" name="tenlop" id="tenlop" size="25px" onFocus="form_lop.tenlop.value=''">
- </td>
- </tr>
- <tr>
- <td>
- S? L??ng Sinh Vięn:
- </td>
- <td>
- <input type="text" value="<?php echo $row_lop["SOLUONG_SV"];?>" name="soluong" id="soluong" size="25px" onFocus="form_lop.soluong.value=''">
- </td>
- </tr>
- <tr>
- <td>
- Giáo Vięn Ch? Nhi?m:
- </td>
- <td>
- <input type="text" value="<?php echo $row_lop["GIAOVIEN_CN"];?>" name="giaovien" id="giaovien" size="25px" onFocus="form_lop.giaovien.value=''">
- </td>
- </tr>
- <tr>
- <td>
- Khoa:
- </td>
- <td>
- <?php $query_khoa=mysql_query("select * from khoa",$quanlyktx);
- ?> <select name="khoa" style="width:250px;text-align:center;">
- <option value="-1"> Ch?n </option>
- <?php while($row_khoa=mysql_fetch_array($query_khoa))
- {
- ?> <option value="<?php echo $row_khoa["MA_KHOA"];?>" <?php if($row_lop["MA_KHOA"]==$row_khoa["MA_KHOA"]) echo "selected"; ?>><?php echo $row_khoa["TEN_KHOA"];?></option>
- <?php }
- ?> </select>
- </td>
- </tr>
- <tr>
- <td colspan="2" style="text-align:center;padding:3px;">
- <input type="submit" value="S?a L?p" name="abc">
- <input type="button" value="Quay L?i" onClick="history.go(-1)">
- </td>
- </tr>
- </table>
- </form>
- <?php
- }
- }
- }
- else
- {
- if((isset($_GET["them"]))&&($_POST["malop"]!="")&&($_POST["tenlop"]!="")&&($_POST["soluong"]!="")&&($_POST["giaovien"]!="")&&($_POST["khoa"]!=-1))
- {
- $query_update= "insert into lop(MA_LOP,TEN_LOP,SOLUONG_SV,GIAOVIEN_CN,MA_KHOA) values('".$_POST['malop']."','".$_POST['tenlop']."',".$_POST['soluong'].",'".$_POST['giaovien']."','".$_POST['khoa']."')";
- if($ketqua=mysql_query($query_update,$quanlyktx))
- {
- echo "Thęm Thŕnh Công";
- }
- else
- {
- echo "Có l?i!Vui lňng lięn h? v?i ban qu?n tr? ?? s?a l?i nŕy!";
- }
- }
- else
- {
- ?>
- <form action="index.php?chon=2&&thaydoi=2&&them=yes" method="post" name="form_sua">
- <table width="589" height="76" border="0" align="center" style="font: 13px/1.5em Verdana;">
- <tr>
- <td height="28">
- Mă L?p:
- </td>
- <td>
- <input type="text" name="malop" size="25px" value="">
- </td>
- </tr>
- <tr>
- <td>
- Tęn L?p:
- </td>
- <td>
- <input type="text" name="tenlop" id="tenlop" size="25px" value="">
- </td>
- </tr>
- <tr>
- <td>
- S? L??ng Sinh Vięn:
- </td>
- <td>
- <input type="text" name="soluong" id="soluong" size="25px" value="">
- </td>
- </tr>
- <tr>
- <td>
- Giáo Vięn Ch? Nhi?m:
- </td>
- <td>
- <input type="text" name="giaovien" id="giaovien" size="25px" value="">
- </td>
- </tr>
- <tr>
- <td>
- Khoa:
- </td>
- <td>
- <?php $query_khoa=mysql_query("select * from khoa",$quanlyktx);
- ?> <select name="khoa" style="width:250px;text-align:center;">
- <option value="-1"> Ch?n </option>
- <?php while($row_khoa=mysql_fetch_array($query_khoa))
- {
- ?> <option value="<?php echo $row_khoa["MA_KHOA"];?>"><?php echo $row_khoa["TEN_KHOA"];?></option>
- <?php }
- ?> </select>
- </td>
- </tr>
- <tr>
- <td colspan="2" style="text-align:center;padding:3px;">
- <input type="submit" value="Thęm L?p" name="abc">
- <input type="button" value="Quay L?i" onClick="history.go(-1)">
- </td>
- </tr>
- </table>
- </form>
- <?php }
- }
- ?>
- </div>