<? session_start(); if($_SESSION['id'] == "") { echo "Please Login!"; exit(); } if($_SESSION['Status'] != "ADMIN") { echo "This page for Admin only!"; exit(); } $hostname = "localhost"; $user = "root"; $password = "123456"; $dbname = "leave"; $tblname = "useradmin"; mysql_connect($hostname,$user,$password)or die("ติดต่อฐานข้อมูลไม่ได้"); mysql_select_db($dbname) or die ("เลือกฐานข้อมูลไม่ได้"); $sql = "select * from $tblname WHERE id = '".$_SESSION['id']."'"; $dbquery = mysql_db_query($dbname,$sql); ?> <html> <head> <title>รายงานการลา</title> <meta http-equiv="Content-Type" content="text/html; charset=tis-620"> <link href="css/style.css" rel="stylesheet" type="text/css"> </head> <body bgcolor="#ffffff"> <br> <div align="center"><br> <table border="0" cellpadding="0" cellspacing="0" width="945"> <tr> <td><div align="right"><font color="#993333" size="2"><img src="images/icon_man.gif" width="15" height="15"> <font color="#333333">ยินดีต้อนรับคุณ</font></font><font color="#FF0000" size="2"> <? echo "<u $adminname /u>"; ?> <font color="#333333">เข้าใช้งานในระบบ<br> <a href="Profiles.php">ข้อมูลส่วนตัว</a> | <a href="Logout.php"><font color="#990000">ออกจากระบบ</font></a></font></font> </div></td> </tr> <tr> <td><img name="bx_r1_c1" src="images/bx_r1_c1.jpg" width="945" height="28" border="0" alt=""></td> </tr> <tr> <td background="images/bx_r2_c1.jpg"><div align="center"> <table width="99%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><table width="936" border="0" cellspacing="1" cellpadding="1"> <tr> <td width="150"><div align="center"><a href="AddUser.php"><img src="images/m1.jpg" width="117" height="71" border="0"></a></div></td> <td width="1"> </td> <td width="130"><div align="center"><a href="Depart.php"><img src="images/m3.jpg" width="117" height="71" border="0"></a></div></td> <td width="130"><div align="center"><a href="Leavetype.php"><img src="images/m4.jpg" width="117" height="71" border="0"></a></div></td> <td width="1"> </td> <td width="130"><div align="center"><a href="Leavereportperday.php"><img src="images/m6.jpg" width="117" height="71" border="0"></a></div></td> </tr> </table></td> </tr> <tr> <td><div align="center"><br> </div></td> </tr> <tr> <td><img src="images/h1.jpg" width="228" height="32"></td> </tr> <tr> <td><div align="center"> <table width="99%" border="0" align="center" cellpadding="1" cellspacing="1"> <tr> <td><div align="center"> <table border="0" cellpadding="0" cellspacing="0" width="673"> <!-- fwtable fwsrc="Untitled" fwbase="bxx.jpg" fwstyle="Dreamweaver" fwdocid = "742308039" fwnested="0" --> <tr> <td><img src="spacer.gif" width="673" height="1" border="0" alt=""></td> <td><img src="spacer.gif" width="1" height="1" border="0" alt=""></td> </tr> <tr> <td><img name="bxx_r1_c1" src="images/bxx_r1_c1.jpg" width="673" height="8" border="0" alt=""></td> <td><img src="spacer.gif" width="1" height="8" border="0" alt=""></td> </tr> <tr> <td background="images/bxx_r2_c1.jpg"> <script language="JavaScript"> function checkprdtype() { var prd1 = document.webFormprdtype.productstypename.value; if( prd1.length ==0) { alert("กรุณาใส่ประเภทสินค้าด้วยค่ะ"); document.webFormprdtype.productstypename.focus(); return false; } else return true; } </script> <table width="90%" border="0" align="center" cellpadding="1" cellspacing="1"> <form method="post" action="AddUsersave.php" name="webFormprdtype" onSubmit="return checkprdtype()"> <tr bgcolor="#FFFFFF"> <td width="163"> <div align="right"><font size="2">รหัสพนักงาน :</font></div></td> <td width="445"><font size="3"> <? $sql = "select * from $tblname WHERE id = '".$_SESSION['id']."'"; $db_queryr=mysql_db_query($dbname,$sql); $result_numcode=mysql_fetch_array($db_queryr); $num_rows_code=mysql_num_rows($db_queryr); $run_number = $num_rows_code+1; echo "<input type=text name=userid value='User-$run_number' class=input>"; ?> </font><font size="3"> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td> <div align="right"><font size="2">ชื่อพนักงาน :</font></div></td> <td><font size="3"> <input name="admin_name" type="text" class="input" id="admin_name" size="40"> </font><font size="3"> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td><div align="right"><font size="2">ตำแหน่ง :</font></div></td> <td><font size="3"> <input name="position" type="text" class="input" id="position" size="40"> </font><font size="3"> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td><div align="right"><font size="2">แผนก/ฝ่าย :</font></div></td> <td><select name="departid" class="input" id="departid"> <option selected>แผนก/ฝ่าย</option> <option value="100">ฝ่ายบุคคล</option> <option value="200">ฝ่ายผลิต</option> </select></td> </tr> </td> </tr> <tr bgcolor="#FFFFFF"> <td><div align="right"><font size="2">รหัสผ่าน :</font></div></td> <td><font size="3"> <input name="password" type="password" class="input" id="password" size="20"> </font><font size="3"> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td><div align="right"><font size="2">ยืนยันรหัสผ่าน :</font></div></td> <td><font size="3"> <input name="repassword" type="password" class="input" id="repassword" size="20"> </font><font size="3"> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td><div align="right"><font size="2">ส่วนของระบบ :</font></div></td> <td><select name="Status" class="input" id="Status"> <option selected>ส่วนระบบ</option> <option value="AMIN">Administrator</option> <option value="ENDORSEE">ผู้อนุมัติการลา</option> <option value="STAFF">เจ้าหน้าที่</option> <option value="USER">พนักงานทั่วไปทั่วไป</option> </select></td> </tr> <tr bgcolor="#FFFFFF"> <td> </td> <td><font size="3"> <input name="submit" type="submit" class="submit" value="เพิ่มข้อมูล" onClick="return confirm ('คุณต้องการบันทึก ใช่ หรือ ไม่? ') "> </font></td> </tr> </form> </table></td> <td><img src="spacer.gif" width="1" height="20" border="0" alt=""></td> </tr> <tr> <td><img name="bxx_r3_c1" src="images/bxx_r3_c1.jpg" width="673" height="8" border="0" alt=""></td> <td><img src="spacer.gif" width="1" height="8" border="0" alt=""></td> </tr> </table> </div></td> </tr> <tr> <td><div align="center"> <table border="0" cellpadding="0" cellspacing="0" width="673"> <!-- fwtable fwsrc="Untitled" fwbase="bxx.jpg" fwstyle="Dreamweaver" fwdocid = "742308039" fwnested="0" --> <tr> <td><img src="spacer.gif" width="673" height="1" border="0" alt=""></td> <td><img src="spacer.gif" width="1" height="1" border="0" alt=""></td> </tr> <tr> <td><img name="bxx_r1_c1" src="images/bxx_r1_c1.jpg" width="673" height="8" border="0" alt=""></td> <td><img src="spacer.gif" width="1" height="8" border="0" alt=""></td> </tr> <tr> <td background="images/bxx_r2_c1.jpg"> <div align="center"> <table width="94%" border="0" cellspacing="0" cellpadding="0"> <tr class="jobscss"> <td bgcolor="#FFFFFF"> <? $page = $_GET['page']; $select_type="select * from $tblname WHERE id = '".$_SESSION['id']."'"; ///"select * from useradmin order by id asc"; $query_select=mysql_query($select_type); $num_rows=mysql_num_rows($query_select); if($num_rows<1){ echo "<br><br><center><font color=#666666 face=tahoma size=2><b>ยังไม่มีการเพิ่มข้อมูล</b></font></center>"; }else{ $select="select * from $tblname WHERE id = '".$_SESSION['id']."'"; ///"select * from useradmin order by id asc"; $q_ry = mysql_query($select); $num_rows=mysql_num_rows($q_ry); $pagesize=20; $rt=$num_rows%$pagesize; if($rt!=0) { $totalpage=floor($num_rows/$pagesize)+1; } else { $totalpage=floor($num_rows/$pagesize); $toppic_id=1; } if(empty($page)) { $page=1; } mysql_free_result($q_ry); $goto=($page-1)*$pagesize; $sql_select_mem="Select * From useradmin order by id asc limit $goto,$pagesize"; $fect=mysql_query($sql_select_mem); if(!$fect) { ("ติดต่อฐานข้อมูลไม่ได้".mysql_error()); exit; } $bgcount=0; while($rows=mysql_fetch_array($fect)) { $idx =$rows['id']; $userid =$rows['userid']; $admin_name = $rows['name']; $position = $rows['position']; $de_partid = $rows['departid']; $password = $rows['password']; //$re_direct = $rows['redirect']; $Status = $rows['Status]'; $bgcount=$bgcount+1; $bgmod=$bgcount%2; if($bgmod==0){ $bgcolor="#E1DFD7"; }else{ $bgcolor="#FDFBF4"; } $a=number_format($salary,2,'.',','); ?> <table width="100%" border="0" cellspacing="1" cellpadding="1"> <tr> <td width="545" bgcolor=<? echo "$bgcolor"; ?>> <div align="left"></div> <div align="left"></div> <div align="center"> </div> <div align="left"><img src="images/arrow.jpg" width="5" height="12"><font color="#993300" size="2"> <? echo "[ $userid ] $admin_name<br>ตำแหน่ง : $position "; ?></font></div></td> <td width="54"> <div align="center"><a href="EditUser.php?ID=<? echo "$idx"; ?>"><img src="images/pencil.jpg" width="20" height="20" border="0"></a> <a href="DelUser.php?del_id=<? echo "$idx"; ?>"><img src="images/delete.png" width="22" height="22" border="0"></a> </div></td> </tr> </table> <? } } ?> </td> </tr> <tr class="jobscss"> <td height="19"> </td> </tr> <tr class="jobscss"> <td><strong><span class="maekhawtom"><font color="#990000" size="2">หน้าที่ :</font></span></strong> <font color="#999999" size="2"><span class="maekhawtom"> <? for($i=1;$i<$page;$i++) { echo"[<a href='$PHP_SELF?page=$i'><font size=2 color='#000000'>$i</font></a>]"; } echo"[<font size=2 color=#000000><b><font size=2 color='#FF00000'>$page</font></b></font>]"; for($i=$page+1;$i<=$totalpage;$i++) { echo"[<a href='$PHP_SELF?page=$i'><font size=2 color='#000000'>$i</font></a>]"; } ?> </span></font><font color="#FFFFFF" size="2"><span class="maekhawtom"> </span></font></td> </tr> <tr> <td><div align="center"></div></td> </tr> </table> </div></td> <td><img src="spacer.gif" width="1" height="20" border="0" alt=""></td> </tr> <tr> <td><img name="bxx_r3_c1" src="images/bxx_r3_c1.jpg" width="673" height="8" border="0" alt=""></td> <td><img src="spacer.gif" width="1" height="8" border="0" alt=""></td> </tr> </table> </div></td> </tr> </table> </div></td> </tr> </table> </div></td> </tr> <tr> <td><img name="bx_r3_c1" src="images/bx_r3_c1.jpg" width="945" height="9" border="0" alt=""></td> </tr> </table> <br> </body> </html>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
