!c99Shell v. 1.0 pre-release build #16!

Software: Apache/2.2.3 (CentOS). PHP/5.1.6 

uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44
EDT 2010 i686 

uid=48(apache) gid=48(apache) groups=48(apache) 

Safe-mode: OFF (not secure)

/var/www/html/mis-bcnsurin-OK/manage/   drwxr-xr-x
Free 46.21 GB of 127.8 GB (36.16%)
Home    Back    Forward    UPDIR    Refresh    Search    Buffer    Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    


Viewing file:     SumPesonal.php (25.55 KB)      -rwxr-xr-x
Select action/file-type:
(+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
    
    /**  Define Validate Access  */
    define( '_VALID_ACCESS', 1 );

    
        /**  Configuration  */
        require_once( "./configuration.php" );
        require_once( $_Config_absolute_path . "/includes/framework.php" );
        require_once( "./include/Function.php" );
        
        /**  Create Database Object  */
        $dbObj = new DBConn;

        $myTable = "personal_tb";
        
        //===  salary_repot_tb
        $query = " SELECT *  FROM $myTable  ORDER  BY Teacher_name  ASC ";
        $result = $dbObj->execQuery($query);
        //$rs = $dbObj->fetchArray($result);
        $total = $dbObj->_numrows;

        

 ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<link href="./css/default.css" rel="stylesheet" type="text/css" />
<script language="javascript" src="./js/utilities.js"></script>
<title>ข้อมูลสถานะบุคลากร - <?=urldecode($topic);?></title>
<style type="text/css ">
<!--
.style1 {font-weight: bold}
.style2 {font-weight: bold}
-->
</style>
</head>

<body topmargin="0" rightmargin="0" bottommargin="0" leftmargin="0">
<?php
    include("./templates/incHeader.php");
?>
<table width="1003" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="203" align="left" valign="top" style="padding:10px 0px 0px 5px"><?php include( "./templates/incMainMenuLeft.php" );?></td>
    <td width="800" align="center" valign="top" style="padding:10px 0px 5px 10px"><fieldset><table width="755" border="0" cellspacing="0" cellpadding="0">
     <form id="myForm" name="myForm" method="post" action="<?=$PHP_SELF;?>?Budget_Year=<?=$Budget_Year;?>&amp;MoneyId=<?=$MoneyId;?>&amp;page=<?=$page;?>&amp;topic=<?=urlencode($topic);?>">
      <tr>
        <td height="5" colspan="2"></td>
      </tr>
      <tr>
        <td width="630" height="30" background="./images/background/bg-head-topic-w780.gif" class="PADDING-LEFT-10"><strong><a href="index.php">หน้าหลัก</a></strong> <strong>&raquo; <span class="NOTE">ข้อมูลสรุปสถานะบุคลากร</span></strong></td>
        <td width="125" align="right" class="PADDING-RIGHT-10">&nbsp;</td>
      </tr>
      <tr>
        <td colspan="2" align="center">&nbsp;</td>
      </tr>
      <tr>
        <td colspan="2" align="left">จำนวนประเภทบุคลากรประจำที่มีวุฒิการศึกษาสูงสุด</td>
      </tr>
      <tr>
        <td colspan="2" align="right"><table width="97%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF" style="background-color:#eeeeee; border:0px solid gray">
          <tr bgcolor="<?=$bgColor;?>">
            <td width="5%" height="22" align="center" bgcolor="#6699FF">No</td>
            <td width="48%" align="center" bgcolor="#6699FF" class="PADDING-LEFT-5">รายการ </td>
            <td width="11%" align="center" bgcolor="#6699FF" class="PADDING-LEFT-5">ปริญญาตรี</td>
            <td width="11%" align="center" bgcolor="#6699FF" class="PADDING-LEFT-5">ปริญญาโท</td>
            <td width="15%" align="center" bgcolor="#6699FF" class="PADDING-LEFT-5">ปริญญาเอก</td>
            <td width="10%" align="center" bgcolor="#6699FF" class="PADDING-LEFT-5">จำนวน</td>
          </tr>
          <?php
                $sql = " SELECT * FROM  person_type_tb    " ;
                $result19 = $dbObj->execQuery($sql); 
               $no = 1+($display-1)*$limit;
           while( $rss13 = $dbObj->fetchArray($result19) ) { 
                $bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
          ?>
          <tr bgcolor="<?=$bgColor;?>">
            <td height="22" align="center" bgcolor="#FFFFFF"><?=$no;?></td>
            <td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?=$rss13['Ptype_name'];?>
              </a></td>
            <td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">
              <?php   
                    $sql = " SELECT COUNT(Teacher_type) AS num  FROM personal_tb  WHERE  StatusId='1'   and  Person_type='$rss13[Ptype_code]'  and Degree_code='1' ";
                    $result11 = $dbObj->execQuery($sql);
                    $rs11 = $dbObj->fetchArray($result11);
                    $dbObj->freeresult($result11);
                        echo $rs11['num'];
                ?>
            </a><a href="PersonalDataType.php?StatusId=1&amp;Person_type=<?=$rss3['Ptype_code'];?>"></a></td>
            <td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">
              <?php   
                    $sql = " SELECT COUNT(Teacher_type) AS num  FROM personal_tb  WHERE  StatusId='1'   and  Person_type='$rss13[Ptype_code]'  and Degree_code='2' ";
                    $result12 = $dbObj->execQuery($sql);
                    $rs12 = $dbObj->fetchArray($result12);
                    $dbObj->freeresult($result12);
                        echo $rs12['num'];
                ?>
            </a><a href="PersonalDataType.php?StatusId=3&amp;Person_type=<?=$rss3['Ptype_code'];?>"></a></td>
            <td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">
              <?php   
                    $sql = " SELECT COUNT(Teacher_type) AS num  FROM personal_tb  WHERE  StatusId='1'   and  Person_type='$rss13[Ptype_code]'  and Degree_code='3' ";
                    $result13 = $dbObj->execQuery($sql);
                    $rs13 = $dbObj->fetchArray($result13);
                        echo $rs13['num'];
                ?>
            </a></td>
            <td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php   
                        $sum =  $rs11['num']+ $rs12['num']+  $rs13['num']; ;
                        echo $sum ;
                ?></td>
            <?php 
                $no++ ;
                     } # while 
                ?>
          </tr>
          <tr bgcolor="<?=$bgColor;?>">
            <td height="22" align="center" bgcolor="#FFCCFF">&nbsp;</td>
            <td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5">สรุป</td>
            <td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"></a>
              <?php   
                    $sql = " SELECT COUNT(Teacher_type) AS num5  FROM personal_tb  WHERE  StatusId='1'  and  Degree_code='1'  and  (  Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5') ";
                    $result1 = $dbObj->execQuery($sql);
                    $rs1 = $dbObj->fetchArray($result1);
                    $dbObj->freeresult($result7);
                        echo $rs1['num5'];
                ?></td>
            <td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php   
                    $sql = " SELECT COUNT(Teacher_type) AS num5  FROM personal_tb  WHERE   StatusId='1'  and  Degree_code='2'  and  (  Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5') ";
                    $result1 = $dbObj->execQuery($sql);
                    $rs1 = $dbObj->fetchArray($result1);
                    $dbObj->freeresult($result7);
                        echo $rs1['num5'];
                ?></td>
            <td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php   
                    $sql = " SELECT COUNT(Teacher_type) AS num5  FROM personal_tb  WHERE  StatusId='1'  and  Degree_code='3'   and  (  Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5') ";
                    $result1 = $dbObj->execQuery($sql);
                    $rs1 = $dbObj->fetchArray($result1);
                    $dbObj->freeresult($result7);
                        echo $rs1['num5'];
                ?></td>
            <td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php   
                    $sql = " SELECT COUNT(Teacher_type) AS num5  FROM personal_tb  WHERE  StatusId='1'   and (Degree_code='1'  Or  Degree_code='2'  Or Degree_code='3' )  and  (  Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5') ";
                    $result1 = $dbObj->execQuery($sql);
                    $rs1 = $dbObj->fetchArray($result1);
                    $dbObj->freeresult($result7);
                        echo $rs1['num5'];
                ?></td>
          </tr>
          <tr bgcolor="<?=$bgColor;?>">
            <td height="22" align="center" bgcolor="#FF99CC">&nbsp;</td>
            <td align="center" bgcolor="#FF99CC" class="PADDING-LEFT-5">อัตราส่วน</td>
            <td align="center" bgcolor="#FF99CC" class="PADDING-LEFT-5"><?php  
                    $sql = " SELECT COUNT(Teacher_type) AS sum  FROM personal_tb  WHERE  StatusId='1'  and  Degree_code='1'  and  (  Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5') ";
                    $result2 = $dbObj->execQuery($sql);
                    $rs2 = $dbObj->fetchArray($result2);
                    
                    $per2= ( $rs2['sum'] * 100 ) / $rs1['num5'] ;
                        echo number_format($per2,2,'.','.');
                ?></td>
            <td align="center" bgcolor="#FF99CC" class="PADDING-LEFT-5"><?php  
                    $sql = " SELECT COUNT(Teacher_type) AS sum  FROM personal_tb  WHERE  StatusId='1'  and  Degree_code='2'  and  (  Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5') ";
                    $result2 = $dbObj->execQuery($sql);
                    $rs2 = $dbObj->fetchArray($result2);
                    
                    $per2= ( $rs2['sum'] * 100 ) / $rs1['num5'] ;
                        echo number_format($per2,2,'.','.');
                ?></td>
            <td align="center" bgcolor="#FF99CC" class="PADDING-LEFT-5"><?php  
                    $sql = " SELECT COUNT(Teacher_type) AS sum  FROM personal_tb  WHERE  StatusId='1'  and  Degree_code='3'  and  (  Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5') ";
                    $result2 = $dbObj->execQuery($sql);
                    $rs2 = $dbObj->fetchArray($result2);
                    
                    $per2= ( $rs2['sum'] * 100 ) / $rs1['num5'] ;
                        echo number_format($per2,2,'.','.');
                ?></td>
            <td align="center" bgcolor="#FF99CC" class="PADDING-LEFT-5">100%</td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td colspan="2" align="center"><input type="button" name="button" id="button" value="แผนภูมิแสดงวุฒิการศึกษา" onclick="location.href='GrapDegree.php'" /></td>
      </tr>
      <tr>
        <td colspan="2" align="center">&nbsp;</td>
      </tr>
      <tr>
        <td colspan="2" align="left">จำนวนสายงานบุคลากรประจำที่มีวุฒิการศึกษาสูงสุด</td>
      </tr>
      <tr>
        <td colspan="2" align="right"><table width="97%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF" style="background-color:#eeeeee; border:0px solid gray">
          <tr bgcolor="<?=$bgColor;?>">
            <td width="5%" height="22" align="center" bgcolor="#6699FF">No</td>
            <td width="48%" align="center" bgcolor="#6699FF" class="PADDING-LEFT-5">รายการ </td>
            <td width="11%" align="center" bgcolor="#6699FF" class="PADDING-LEFT-5">ปริญญาตรี</td>
            <td width="11%" align="center" bgcolor="#6699FF" class="PADDING-LEFT-5">ปริญญาโท</td>
            <td width="15%" align="center" bgcolor="#6699FF" class="PADDING-LEFT-5">ปริญญาเอก</td>
            <td width="10%" align="center" bgcolor="#6699FF" class="PADDING-LEFT-5">จำนวน</td>
          </tr>
          <?php
                $sql = " SELECT * FROM  teacher_type_tb   Where  Flag ='Y'    " ;
                $result8 = $dbObj->execQuery($sql); 
               $no = 1+($display-1)*$limit;
           while( $rss4 = $dbObj->fetchArray($result8) ) { 
                $bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
          ?>
          <tr bgcolor="<?=$bgColor;?>">
            <td height="22" align="center" bgcolor="#FFFFFF"><?=$no;?></td>
            <td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?=$rss4['Ttype_name'];?>
              </a></td>
            <td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">
              <?php   
                    $sql = " SELECT COUNT(Teacher_type) AS num  FROM personal_tb    WHERE  StatusId='1'  and  Teacher_type='$rss4[Ttype_code]' and  Degree_code='1'     ";
                    $result21 = $dbObj->execQuery($sql);
                    $rs21 = $dbObj->fetchArray($result21);
                    echo $rs21['num'];
                ?>
            </a></td>
            <td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">
              <?php   
                    $sql = " SELECT COUNT(Teacher_type) AS num  FROM personal_tb    WHERE  StatusId='1'  and Teacher_type='$rss4[Ttype_code]' and  Degree_code='2'     ";
                    $result22 = $dbObj->execQuery($sql);
                    $rs22 = $dbObj->fetchArray($result22);
                    echo $rs22['num'];
                ?>
            </a></td>
            <td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">
              <?php   
                    $sql = "SELECT COUNT(Teacher_type) AS num  FROM personal_tb    WHERE  StatusId='1'  and  Teacher_type='$rss4[Ttype_code]' and  Degree_code='3'     ";
                    $result23 = $dbObj->execQuery($sql);
                    $rs23 = $dbObj->fetchArray($result23);
                    echo $rs23['num'];
                ?>
            </a></td>
            <td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php   
                        $sum =  $rs21['num']+ $rs22['num']+  $rs23['num']; ;
                        echo $sum ;
                ?></td>
            <?php 
                $no++ ;
                     } # while 
                ?>
          </tr>
          <tr bgcolor="<?=$bgColor;?>">
            <td height="22" align="center" bgcolor="#FFCCFF">&nbsp;</td>
            <td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5">สรุป</td>
            <td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php   
                    $sql = " SELECT COUNT(Teacher_code) AS num5  FROM personal_tb pt, teacher_type_tb tt   WHERE  pt.Teacher_type=tt.Ttype_code  and  tt.Flag='Y' and  pt.StatusId='1'  and  pt.Degree_code='1'   ";
                    $result1 = $dbObj->execQuery($sql);
                    $rs1 = $dbObj->fetchArray($result1);
                                echo $rs1['num5'];
                ?></td>
            <td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php   
                    $sql = " SELECT COUNT(Teacher_code) AS num5  FROM personal_tb pt, teacher_type_tb tt   WHERE  pt.Teacher_type=tt.Ttype_code  and  tt.Flag='Y' and  pt.StatusId='1'  and  pt.Degree_code='2'   ";
                    $result2 = $dbObj->execQuery($sql);
                    $rs2 = $dbObj->fetchArray($result2);
                                echo $rs2['num5'];
                ?></td>
            <td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php   
                    $sql = " SELECT COUNT(Teacher_code) AS num5  FROM personal_tb pt, teacher_type_tb tt   WHERE  pt.Teacher_type=tt.Ttype_code  and  tt.Flag='Y' and  pt.StatusId='1'  and  pt.Degree_code='3'   ";
                    $result3 = $dbObj->execQuery($sql);
                    $rs3 = $dbObj->fetchArray($result3);
                                echo $rs3['num5'];
                ?></td>
            <td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php   
                        $sum =  $rs1['num5']+ $rs2['num5']+  $rs3['num5']; ;
                        echo $sum ;
                ?></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td colspan="2" align="right">&nbsp;</td>
      </tr>
      <tr>
        <td colspan="2" align="left">จำนวนประเภทบุคลากรที่่ปฏิบัติงานและลาศึกษาต่อ</td>
      </tr>
      <tr>
        <td colspan="2" align="right"><table width="97%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF" style="background-color:#eeeeee; border:0px solid gray">
          <tr bgcolor="<?=$bgColor;?>">
            <td width="4%" height="22" align="center" bgcolor="#6699FF">No</td>
            <td width="43%" align="center" bgcolor="#6699FF" class="PADDING-LEFT-5">รายการ </td>
            <td width="11%" align="center" bgcolor="#6699FF" class="PADDING-LEFT-5">ปฏิบัติงาน</td>
            <td width="10%" align="center" bgcolor="#6699FF" class="PADDING-LEFT-5">อัตราส่วน</td>
            <td width="9%" align="center" bgcolor="#6699FF" class="PADDING-LEFT-5">ลาศึกษา</td>
            <td width="12%" align="center" bgcolor="#6699FF" class="PADDING-LEFT-5">ไปช่วยราชการ</td>
            <td width="11%" align="center" bgcolor="#6699FF" class="PADDING-LEFT-5">จำนวน</td>
          </tr>
          <?php
                $sql = " SELECT * FROM  person_type_tb    " ;
                $result9 = $dbObj->execQuery($sql); 
               $no = 1+($display-1)*$limit;
           while( $rss3 = $dbObj->fetchArray($result9) ) { 
                $bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
          ?>
          <tr bgcolor="<?=$bgColor;?>">
            <td height="22" align="center" bgcolor="#FFFFFF"><?=$no;?></td>
            <td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?=$rss3['Ptype_name'];?>
              </a></td>
            <td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">
              <?php   
                    $sql = " SELECT COUNT(Teacher_type) AS num1  FROM personal_tb  WHERE  StatusId='1'  and   Person_type='$rss3[Ptype_code]'   ";
                    $result1 = $dbObj->execQuery($sql);
                    $rs1 = $dbObj->fetchArray($result1);
                    $dbObj->freeresult($result7);
                        echo $rs1['num1'];
                ?>
            </a></td>
            <td align="center" bgcolor="#FF99CC" class="PADDING-LEFT-5"><?php  
                    $sql = " SELECT COUNT(Teacher_type) AS sum  FROM personal_tb  WHERE  StatusId='1'  and  (  Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5') ";
                    $result2 = $dbObj->execQuery($sql);
                    $rs2 = $dbObj->fetchArray($result2);
                    
                    $per2= ( $rs1['num1'] * 100 ) / $rs2['sum'] ;
                        echo number_format($per2,2,'.','.');
                ?></td>
            <td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">
              <?php   
                    $sql = " SELECT COUNT(Teacher_type) AS num2  FROM personal_tb  WHERE  StatusId='3' and   Person_type='$rss3[Ptype_code]'   ";
                    $result2 = $dbObj->execQuery($sql);
                    $rs2 = $dbObj->fetchArray($result2);
                    $dbObj->freeresult($result7);
                        echo $rs2['num2'];
                ?>
            </a></td>
            <td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">
              <?php   
                    $sql = " SELECT COUNT(Teacher_type) AS num3  FROM personal_tb  WHERE  StatusId='2'  and   Person_type='$rss3[Ptype_code]'   ";
                    $result3 = $dbObj->execQuery($sql);
                    $rs3 = $dbObj->fetchArray($result3);
                    $dbObj->freeresult($result7);
                        echo $rs3['num3'];
                ?>
            </a></td>
            <td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">
              <?php   
                        $sum =  $rs1['num1']+ $rs2['num2']+  $rs3['num3']; 
                        echo $sum ;
                ?>
            </a></td>
            <?php 
                $no++ ;
                     } # while 
                ?>
          </tr>
          <tr bgcolor="<?=$bgColor;?>">
            <td height="22" align="center" bgcolor="#FFCCFF">&nbsp;</td>
            <td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5">สรุป</td>
            <td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php   
                    $sql = " SELECT COUNT(Teacher_type) AS num5  FROM personal_tb  WHERE  StatusId='1'  and  (  Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5') ";
                    $result1 = $dbObj->execQuery($sql);
                    $rs1 = $dbObj->fetchArray($result1);
                    $dbObj->freeresult($result7);
                        echo $rs1['num5'];
                ?>
              </a></a></td>
            <td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5">100%</td>
            <td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php   
                    $sql = " SELECT COUNT(Teacher_type) AS num5  FROM personal_tb  WHERE  StatusId='3'  and  (  Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5') ";
                    $result1 = $dbObj->execQuery($sql);
                    $rs1 = $dbObj->fetchArray($result1);
                    $dbObj->freeresult($result7);
                        echo $rs1['num5'];
                ?></td>
            <td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php   
                    $sql = " SELECT COUNT(Teacher_type) AS num5  FROM personal_tb  WHERE  StatusId='2'  and  (  Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5') ";
                    $result1 = $dbObj->execQuery($sql);
                    $rs1 = $dbObj->fetchArray($result1);
                    $dbObj->freeresult($result7);
                        echo $rs1['num5'];
                ?></td>
            <td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php   
                    $sql = " SELECT COUNT(Teacher_type) AS num5  FROM personal_tb  WHERE   ( StatusId='1'  Or   StatusId='2'   Or  StatusId='3' )  and   (  Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5') ";
                    $result1 = $dbObj->execQuery($sql);
                    $rs1 = $dbObj->fetchArray($result1);
                    $dbObj->freeresult($result7);
                        echo $rs1['num5'];
                ?></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td colspan="2" align="center"><input type="button" name="button" id="button" value="แผนภูมิแสดงประเภทของบุคลากร" onclick="location.href='GrapStatus.php'" /></td>
      </tr>
      <tr>
        <td colspan="2" align="center">&nbsp;</td>
      </tr>
      <tr>
        <td colspan="2" align="left">จำนวนสายงานบุคลากรที่่ปฏิบัติงานและลาศึกษาต่อ</td>
      </tr>
      <tr>
        <td colspan="2" align="right"><table width="97%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF" style="background-color:#eeeeee; border:0px solid gray">
          <tr bgcolor="<?=$bgColor;?>">
            <td width="5%" height="22" align="center" bgcolor="#6699FF">No</td>
            <td width="48%" align="center" bgcolor="#6699FF" class="PADDING-LEFT-5">รายการ </td>
            <td width="11%" align="center" bgcolor="#6699FF" class="PADDING-LEFT-5">ปฏิบัติงาน</td>
            <td width="11%" align="center" bgcolor="#6699FF" class="PADDING-LEFT-5">ลาศึกษา</td>
            <td width="15%" align="center" bgcolor="#6699FF" class="PADDING-LEFT-5">ไปช่วยราชการ</td>
            <td width="10%" align="center" bgcolor="#6699FF" class="PADDING-LEFT-5">จำนวน</td>
          </tr>
          <?php
                $sql = " SELECT * FROM  teacher_type_tb   Where  Flag ='Y'    " ;
                $result8 = $dbObj->execQuery($sql); 
               $no = 1+($display-1)*$limit;
           while( $rss4 = $dbObj->fetchArray($result8) ) { 
                $bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
          ?>
          <tr bgcolor="<?=$bgColor;?>">
            <td height="22" align="center" bgcolor="#FFFFFF"><?=$no;?></td>
            <td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?=$rss4['Ttype_name'];?>
              </a></td>
            <td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">
              <?php   
                    $sql = " SELECT COUNT(Teacher_type) AS num  FROM personal_tb    WHERE  StatusId='1'  and  Teacher_type='$rss4[Ttype_code]'    ";
                    $result11 = $dbObj->execQuery($sql);
                    $rs11 = $dbObj->fetchArray($result11);
                    $dbObj->freeresult($result11);
                        echo $rs11['num'];
                ?>
            </a></td>
            <td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">
              <?php   
                    $sql = " SELECT COUNT(Teacher_type) AS num FROM personal_tb    WHERE  StatusId='3'  and  Teacher_type='$rss4[Ttype_code]'    ";
                    $result12 = $dbObj->execQuery($sql);
                    $rs12 = $dbObj->fetchArray($result12);
                    $dbObj->freeresult($result12);
                        echo $rs12['num'];
                ?>
            </a></td>
            <td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">
              <?php   
                    $sql = " SELECT COUNT(Teacher_type) AS num  FROM personal_tb    WHERE  StatusId='2'  and  Teacher_type='$rss4[Ttype_code]'    ";
                    $result13 = $dbObj->execQuery($sql);
                    $rs13 = $dbObj->fetchArray($result13);
                    $dbObj->freeresult($result13);
                        echo $rs13['num'];
                ?>
            </a></td>
            <td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php   
                        $sum =  $rs11['num']+ $rs12['num']+  $rs13['num']; ;
                        echo $sum ;
                ?></td>
            <?php 
                $no++ ;
                     } # while 
                ?>
          </tr>
          <tr bgcolor="<?=$bgColor;?>">
            <td height="22" align="center" bgcolor="#FFCCFF">&nbsp;</td>
            <td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5">สรุป</td>
            <td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php   
                    $sql = " SELECT COUNT(Teacher_code) AS num5  FROM personal_tb pt, teacher_type_tb tt   WHERE  pt.Teacher_type=tt.Ttype_code  and  tt.Flag='Y' and  pt.StatusId='1'    ";
                    $result1 = $dbObj->execQuery($sql);
                    $rs1 = $dbObj->fetchArray($result1);
                                echo $rs1['num5'];
                ?></td>
            <td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php   
                    $sql = " SELECT COUNT(Teacher_code) AS num5  FROM personal_tb pt, teacher_type_tb tt   WHERE  pt.Teacher_type=tt.Ttype_code  and  tt.Flag='Y' and  pt.StatusId='3'    ";
                    $result1 = $dbObj->execQuery($sql);
                    $rs1 = $dbObj->fetchArray($result1);
                                echo $rs1['num5'];
                ?></td>
            <td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php   
                    $sql = " SELECT COUNT(Teacher_code) AS num5  FROM personal_tb pt, teacher_type_tb tt   WHERE  pt.Teacher_type=tt.Ttype_code  and  tt.Flag='Y' and  pt.StatusId='2'    ";
                    $result1 = $dbObj->execQuery($sql);
                    $rs1 = $dbObj->fetchArray($result1);
                                echo $rs1['num5'];
                ?></td>
            <td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php   
                    $sql = " SELECT COUNT(Teacher_code) AS num5  FROM personal_tb pt, teacher_type_tb tt   WHERE  pt.Teacher_type=tt.Ttype_code  and  tt.Flag='Y' and  (pt.StatusId='1'  Or pt.StatusId='2' Or pt.StatusId='3')  ";
                    $result1 = $dbObj->execQuery($sql);
                    $rs1 = $dbObj->fetchArray($result1);
                                echo $rs1['num5'];
                ?></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td height="2" colspan="2" align="center" valign="top">
        </td>
      </tr>
      <tr>
        <td colspan="2" align="center"><input type="button" name="button" id="button" value="แผนภูมิแสดงสายงานของบุคลากร" onclick="location.href='GrapFacult.php'" /></td>
      </tr>
      <tr>
        <td colspan="2">&nbsp;</td>
      </tr></form>
     </table>
    </fieldset></td>
  </tr>
</table>
<?php include("./templates/incFooter.php"); ?>
</body>
</html>
<?php
    /**  Free Resource */
    $dbObj->freeresult($result);
    
    /**  Close the Database  */
    $dbObj->disconn();
    
    /**  Unset Class  */
    unset($dbObj);
?>

:: Command execute ::

Enter:
 
Select:
 

:: Shadow's tricks :D ::

Useful Commands
 
Warning. Kernel may be alerted using higher levels
Kernel Info:

:: Preddy's tricks :D ::

Php Safe-Mode Bypass (Read Files)

File:

eg: /etc/passwd
Php Safe-Mode Bypass (List Directories):

Dir:

eg: /etc/

:: Search ::
  - regexp 
:: Upload ::
 
[ Read-Only ]

:: Make Dir ::
 
[ Read-Only ]
:: Make File ::
 
[ Read-Only ]

:: Go Dir ::
 
:: Go File ::
 

--[ c999shell v. 1.0 pre-release build #16 Modded by Shadow & Preddy | RootShell Security Group | r57 c99 shell | Generation time: 0.034 ]--