<?php
session_start();

 if (session_is_registered("valid_user")&&session_is_registered("Priority"))
 {
 $Username = $valid_user;
 $Password = $password;
include("../include/FunctionDB.php");
include("../include/Function.php");
include("admin_menu.php");
ConnectDB();
$Username = $valid_user;
$strSQL = "SELECT * FROM finance4_tb Order By Date_note";
if (! $Page)
$Page = 1;
$Pre_Page = $Page - 1;
$Next_Page = $Page +1;
$Per_Page = 50;
$result = mysql_query($strSQL);

$Page_start = ($Per_Page*$Page) - $Per_Page;
$Num_Rows = mysql_num_rows($result);

if( $Num_Rows <= $Per_Page)
   $Num_Pages = 1;
else if (($Num_Rows % $Per_Page) == 0)
       $Num_Pages = ($Num_Rows / $Per_Page);
else
        $Num_Pages = ($Num_Rows / $Per_Page) + 1;
$Num_Pages = (int)$Num_Pages;

if (( $Page > $Num_Pages) || ($Page < 0))
  echo"Page $Page More than $Num_Pages";
$strSQL .=" LIMIT $Page_start,$Per_Page" ;
$result = mysql_query($strSQL); 
///////////////////////////////////////////////////////////////////////////////////
$num = mysql_num_rows( $result );
//$count = 0;
?>
<meta http-equiv="Content-Type" content="text/html; charset=TIS-620">

<table width="822" border="0" cellpadding="0" cellspacing="0">
    <tr>
        <td width="822"><br>
          <fieldset>
            <legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="menu_manage.php" >หน้าหลัก</a> <img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle"><a href="AddFinaDura.php?Teacher_code=<? echo $rss[Teacher_code] ?>">เพิ่มข้อมูล</a> <img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" /><a href="EditFinaList.php?Teacher_code=<? echo $rss[Teacher_code] ?>">แก้ไขข้อมูล</a><img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" />แก้ไขงบค่าบุคลากร</font></legend>
            <label><div align="center">
              <form id="form1" name="form1" method="post" action="EditFina.php">
                <table width="93%" border="0" align="center" cellpadding="0" cellspacing="1" style="border:1px solid gray">
                  <tr bgcolor="#7CAB84">
                    <td height="24" colspan="9"><div align="center"><font color="#FFCC66" size="4" face="Tahoma"><strong><font color="#FFFFFF">แสดงรายการ</font><font color="#FFFFFF" size="4" face="Tahoma"> ค่าครุภัณฑ์และสิ่งก่อสร้าง</font></strong></font></div></td>
                  </tr>
                  <tr bordercolor="#003366" bgcolor="#C7DED0">
                    <td width="28" align="center"><font color="#003366" size="2" face="Tahoma"><b>No.</b></font></td>
                    <td width="76" align="center" bgcolor="#C7DED0" class="style16"><span class="style24">เดือน<br />
                    </span></td>
                    <td width="104" align="center" bgcolor="#C7DED0" class="style16"><div align="center" class="style27"><span class="style18">ครุภัณฑ์การศึกษา</span></div></td>
                    <td width="62" align="center" bgcolor="#C7DED0" class="style16"><div align="center" class="style26"><span class="style18">สำนักงาน</span></div></td>
                    <td width="119" align="center" class="style16"><div align="center" class="style26"><span class="style18">โฆษณาและเผยแพร่</span></div></td>
                    <td width="57" align="center" class="style16"><div align="center" class="style26"><span class="style18">ก่อสร้าง</span></div></td>
                    <td width="86" align="center" class="style16"><div align="center" class="style26"><span class="style18">ไฟฟ้าและวิทยุ</span></div></td>
                    <td width="101" align="center" class="style16"><div align="center" class="style26"><span class="style18">งานบ้านงานครัว</span></div></td>
                    <td width="118" align="center" class="style16"><div align="center" class="style26"><span class="d  style18">วัสดุทางการแพทย์</span></div></td>
                  </tr>
                  <?php
$i = 1;
 while($row = mysql_fetch_array($result))
 {

     if($count==0)
     {
?>
                  <tr bgcolor="#EEEEEE" >
                    <td align="center" bordercolor="#D1D1D1" ><strong><font color="#003300" size="2" face="Tahoma">
                      <?=$i?>
                    </font></strong></td>
                    <td align="center" bordercolor="#DFDFDF" ><font color="#003300" size="2" face="Tahoma"><? echo"$row[Date_note]";?></font></td>
                    <td align="center" bordercolor="#DFDFDF" ><div align="right"><font color="#0033CC" size="2" face="Tahoma"> <? echo number_format($row['Cost1'],2,'.',',');?> </font></div></td>
                    <td bordercolor="#DFDFDF"><div align="right"><font color="#0033CC" size="2" face="Tahoma"> <? echo number_format($row['Cost2'],2,'.',',');?> </font></div></td>
                    <td bordercolor="#DFDFDF" bgcolor="#EEEEEE" ><div align="right"><font color="#0033CC" size="2" face="Tahoma"> <? echo number_format($row['Cost3'],2,'.',',');?></font></div></td>
                    <td bordercolor="#DFDFDF" ><div align="right"><font color="#0033CC" size="2" face="Tahoma"> <? echo number_format($row['Cost4'],2,'.',',');?></font></div></td>
                    <td bordercolor="#DFDFDF" ><div align="right"><font color="#0033CC" size="2" face="Tahoma"> <? echo number_format($row['Cost5'],2,'.',',');?></font></div></td>
                    <td bordercolor="#DFDFDF" ><div align="right"><font color="#0033CC" size="2" face="Tahoma"> <? echo number_format($row['Cost6'],2,'.',',');?></font></div></td>
                    <td bordercolor="#DFDFDF" ><div align="right"><font color="#0033CC" size="2" face="Tahoma"><? echo number_format($row['Cost7'],2,'.',',');?></font></div></td>
                  </tr>
                  <?
    $count=1;
     }
else
{
?>
                  <tr bgcolor="#FFFFFF">
                    <td align="center" bordercolor="#D1D1D1" ><strong><font color="#003300" size="2" face="Tahoma">
                      <?=$i?>
                    </font></strong></td>
                    <td align="center" bordercolor="#FFFFFF" ><font color="#003300" size="2" face="Tahoma"><? echo"$row[Date_note]";?></font></td>
                    <td height="18" align="center" bordercolor="#FFFFFF" ><div align="right"><font color="#0033CC" size="2" face="Tahoma"> <? echo number_format($row['Cost1'],2,'.',',');?></font></div></td>
                    <td bordercolor="#FFFFFF"><div align="right"><font color="#0033CC" size="2" face="Tahoma"> <? echo number_format($row['Cost2'],2,'.',',');?> </font></div></td>
                    <td bordercolor="#FFFFFF" ><div align="right"><font color="#0033CC" size="2" face="Tahoma"> <? echo number_format($row['Cost3'],2,'.',',');?></font></div></td>
                    <td bordercolor="#FFFFFF" ><div align="right"><font color="#0033CC" size="2" face="Tahoma"> <? echo number_format($row['Cost4'],2,'.',',');?></font></div></td>
                    <td bordercolor="#FFFFFF" ><div align="right"><font color="#0033CC" size="2" face="Tahoma"> <? echo number_format($row['Cost5'],2,'.',',');?></font></div></td>
                    <td bordercolor="#FFFFFF" ><div align="right"><font color="#0033CC" size="2" face="Tahoma"><? echo number_format($row['Cost6'],2,'.',',');?></font></div></td>
                    <td bordercolor="#FFFFFF" ><div align="right"><font color="#0033CC" size="2" face="Tahoma"><? echo number_format($row['Cost7'],2,'.',',');?></font></div></td>
                  </tr>
                  <?
$count=0;
}
$i++;
 }    
CloseDB();
?>
                  <tr bgcolor="#7CAB84">
                    <td colspan="9" align="center"><div align="center"><font color="#FFFFFF" size="2" face="Tahoma">ทั้งหมด <? echo $num ?> รายการ&nbsp;</font> </div></td>
                  </tr>
                </table>
              </form>
              </div>
            </label>
        </fieldset><br>
        <font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2"><b>หมายเหตุ :</b> ใช้เมาส์คลิกที่ชื่อ<br>
      </font></td>
    </tr>
</table>
<?php 
    }
else
{
       echo"<meta http-equiv=\"refresh\" content=\"3;URL=../login.php\">\n";
       echo"Please Login ";
}
?>