| Server IP : 134.236.49.22 / Your IP : 216.73.216.114 Web Server : Apache/2.2.15 (Fedora) System : Linux km10.dyndns.org 2.6.31.5-127.fc12.i686.PAE #1 SMP Sat Nov 7 21:25:57 EST 2009 i686 User : apache ( 48) PHP Version : 5.3.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/Menu pusdu/showalladmin/ |
Upload File : |
<?php
$ebits = ini_get('error_reporting');
error_reporting($ebits ^ E_NOTICE);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<title>кԡʴçҺѵպ .10</title>
<style type="text/css">
<!--
.style6 {color: #FF0000}
.style9 {color: #FF3333; font-weight: bold; }
.style10 {
color: #000000;
font-size: 24px;
font-weight: bold;
}
.style12 {font-size: 12px}
-->
</style>
</head>
<body>
<div align="center"><span class="style10"><br>
<br>
Ҥ 2557 </span><br>
<br>
<br>
</div>
<table width="1276" height="464" border="1">
<tr>
<td width="731" bgcolor="#E6CCFF"><!-- --------------------------------------------- ˹§ҹ 1 ----------------------------------------------------------->
<div align="left">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center"> <span class="style9">˹§ҹ ʹȷҧᾷٹТ </span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_com");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\com\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr bgcolor="#F1955C">
<th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="49" rowspan="2" bgcolor="#FFAC91"> <div align="center">˹¹Ѻ </div></th>
<th width="61" rowspan="2" bgcolor="#FFAC91"> <div align="center">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style6">ͧѺ<br>
˹ҷٹ</div></th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91">حҵ<br>
ԡ</th>
<th width="38" bgcolor="#FFAC91">¨ԧ</th>
<th width="60" bgcolor="#FFAC91">Ҥҵ<br>
˹</th>
<th width="134" bgcolor="#FFAC91">Ҥ</th>
</tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left">
<input type="text" name="txtItem<?=$i;?>" size="30" value="<?=$objResult["Item"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>">
</div></td>
<td width="51" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center">
<input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>">
</div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left> <br>
<br>
</left>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!-- --------------------------------------------- ˹§ҹ 1 -----------------------------------------------------------></td>
<td width="529" bgcolor="#B0FFFF"><!-- --------------------------------------------- ˹§ҹ 2 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center"> <span class="style9">˹§ҹ Ѫ </span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_pharma");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\pharma\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr>
<th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="49" rowspan="2" bgcolor="#FFAC91"> <div align="center">˹¹Ѻ </div></th>
<th width="63" rowspan="2" bgcolor="#FFAC91"> <div align="center">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style6">ͧѺ<br>
˹ҷٹ</div></th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91">حҵ<br>
ԡ</th>
<th width="38" bgcolor="#FFAC91">¨ԧ</th>
<th width="63" bgcolor="#FFAC91">Ҥҵ<br>
˹</th>
<th width="241" bgcolor="#FFAC91">Ҥ</th>
</tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left">
<input type="text" name="txtItem<?=$i;?>2" size="30" value="<?=$objResult["Item"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>">
</div></td>
<td width="51" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center">
<input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>">
</div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left> <br>
<br>
</left>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!----------------------------------------˹§ҹ 2 ---------------------------------------------------------------------------------------------></td>
</tr>
<tr>
<td bgcolor="#E6CCFF"><!-- --------------------------------------------- ˹§ҹ 3 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center"> <span class="style6 style7"><strong>˹§ҹ ѹٵ </strong></span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_lab");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\lab\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr>
<th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="76" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">˹¹Ѻ </div></th>
<th width="108" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style12"">ͧѺ<br>
˹ҷٹ</div> </th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91" class="style12">حҵ<br>
ԡ</th>
<th bgcolor="#FFAC91" class="style12">¨ԧ</th>
<th bgcolor="#FFAC91" class="style12">Ҥҵ<br>
˹</th>
<th bgcolor="#FFAC91" class="style12">Ҥ</th> </tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left">
<input type="text" name="txtItem<?=$i;?>2" size="30" value="<?=$objResult["Item"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>">
</div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center">
<input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>">
</div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left> <br>
<br>
</left>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!----------------------------------------˹§ҹ 3 --------------------------------------------------------------------------------------------->
</td>
<td bgcolor="#B0FFFF"><!-- --------------------------------------------- ˹§ҹ 4 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="59"><p align="center"> <span class="style6 style7"><strong>˹§ҹ طʵ </strong></span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_yuth");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\strategy\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr>
<th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="76" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">˹¹Ѻ </div></th>
<th width="108" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style12"">ͧѺ<br>
˹ҷٹ</div> </th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91" class="style12">حҵ<br>
ԡ</th>
<th bgcolor="#FFAC91" class="style12">¨ԧ</th>
<th bgcolor="#FFAC91" class="style12">Ҥҵ<br>
˹</th>
<th bgcolor="#FFAC91" class="style12">Ҥ</th> </tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left">
<input type="text" name="txtItem<?=$i;?>2" size="30" value="<?=$objResult["Item"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>">
</div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center">
<input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>">
</div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left> <br>
<br>
</left>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!----------------------------------------˹§ҹ 4 ---------------------------------------------------------------------------------------------></td>
</tr>
<tr>
<td bgcolor="#E6CCFF"><!-- --------------------------------------------- ˹§ҹ 5 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="77"><p align="center"><span class="style7 style6"><strong>˹§ҹ ÷ </strong></span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_manage");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\manage\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr bgcolor="#FFAC91"> <th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="76" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">˹¹Ѻ </div></th>
<th width="108" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style12"">ͧѺ<br>
˹ҷٹ</div> </th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91" class="style12">حҵ<br>
ԡ</th>
<th bgcolor="#FFAC91" class="style12">¨ԧ</th>
<th bgcolor="#FFAC91" class="style12">Ҥҵ<br>
˹</th>
<th bgcolor="#FFAC91" class="style12">Ҥ</th> </tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left">
<input type="text" name="txtItem<?=$i;?>2" size="30" value="<?=$objResult["Item"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>">
</div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center">
<input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>">
</div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left> <br>
</left>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p></td>
<td bgcolor="#B0FFFF"><!-- --------------------------------------------- ˹§ҹ 6 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center"><span class="style6 style7"><strong>˹§ҹ СѹآҾ </strong></span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_insure");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\insuranc\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr>
<th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="76" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">˹¹Ѻ </div></th>
<th width="108" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style12"">ͧѺ<br>
˹ҷٹ</div> </th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91" class="style12">حҵ<br>
ԡ</th>
<th bgcolor="#FFAC91" class="style12">¨ԧ</th>
<th bgcolor="#FFAC91" class="style12">Ҥҵ<br>
˹</th>
<th bgcolor="#FFAC91" class="style12">Ҥ</th> </tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left">
<input type="text" name="txtItem<?=$i;?>2" size="30" value="<?=$objResult["Item"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>">
</div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center">
<input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>">
</div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left><br>
<br>
</left>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!----------------------------------------˹§ҹ 6 ---------------------------------------------------------------------------------------------></td>
</tr>
<tr>
<td bgcolor="#E6CCFF"><!-- --------------------------------------------- ˹§ҹ 7 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center"><span class="style6 style7"><strong>˹§ҹ ᾷἹ </strong></span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_massage");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\massage\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr bgcolor="#FFAC91"> <th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="76" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">˹¹Ѻ </div></th>
<th width="108" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style12">ͧѺ<br>
˹ҷٹ</div></th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91" class="style12">حҵ<br>
ԡ</th>
<th bgcolor="#FFAC91" class="style12">¨ԧ</th>
<th bgcolor="#FFAC91" class="style12">Ҥҵ<br>
˹</th>
<th bgcolor="#FFAC91" class="style12">Ҥ</th>
</tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left"><input type="text" name="txtItem<?=$i;?>" size="30" value="<?=$objResult["Item"];?>"></div></td>
<td><div align="center"><input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>"></div></td>
<td><div align="center"><input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>"></div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center"><input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>"></div></td>
<td><div align="center"><input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>"></div></td>
<td><div align="center"><input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>"></div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left><br>
<br>
</left>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
</td>
<td bgcolor="#B0FFFF"><!-- --------------------------------------------- ˹§ҹ 8 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center"><span class="style7 style6"><strong>˹§ҹ ͧҵѴ </strong></span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_or");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\OR\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr>
<th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="76" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">˹¹Ѻ </div></th>
<th width="108" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style12"">ͧѺ<br>
˹ҷٹ</div> </th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91" class="style12">حҵ<br>
ԡ</th>
<th bgcolor="#FFAC91" class="style12">¨ԧ</th>
<th bgcolor="#FFAC91" class="style12">Ҥҵ<br>
˹</th>
<th bgcolor="#FFAC91" class="style12">Ҥ</th>
</tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left"><input type="text" name="txtItem<?=$i;?>" size="30" value="<?=$objResult["Item"];?>"></div></td>
<td><div align="center"><input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>"></div></td>
<td><div align="center"><input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>"></div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center"><input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>"></div></td>
<td><div align="center"><input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>"></div></td>
<td><div align="center"><input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>"></div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left><br>
<br>
</left>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!----------------------------------------˹§ҹ 8 ---------------------------------------------------------------------------------------------> </td>
</tr>
<tr>
<td bgcolor="#E6CCFF"><!-- --------------------------------------------- ˹§ҹ 9 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center"><span class="style6 style7"><strong>˹§ҹ pcu ٵǧ </strong></span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_pcu");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\plutaluang\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr>
<th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="76" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">˹¹Ѻ </div></th>
<th width="108" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style12"">ͧѺ<br>
˹ҷٹ</div> </th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91" class="style12">حҵ<br>
ԡ</th>
<th bgcolor="#FFAC91" class="style12">¨ԧ</th>
<th bgcolor="#FFAC91" class="style12">Ҥҵ<br>
˹</th>
<th bgcolor="#FFAC91" class="style12">Ҥ</th> </tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left"><input type="text" name="txtItem<?=$i;?>" size="30" value="<?=$objResult["Item"];?>"></div></td>
<td><div align="center"><input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>"></div></td>
<td><div align="center"><input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>"></div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center"><input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>"></div></td>
<td><div align="center"><input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>"></div></td>
<td><div align="center"><input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>"></div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left><br>
<br>
</left>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!----------------------------------------˹§ҹ 9 ---------------------------------------------------------------------------------------------> </td>
<td bgcolor="#B0FFFF"><!-- --------------------------------------------- ˹§ҹ 10 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center"><span class="style7 style6"><strong>˹§ҹ ٹآҾӺѵպ </strong></span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_km1");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\km1\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr>
<th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="76" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">˹¹Ѻ </div></th>
<th width="108" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style12"">ͧѺ<br>
˹ҷٹ</div> </th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91" class="style12">حҵ<br>
ԡ</th>
<th bgcolor="#FFAC91" class="style12">¨ԧ</th>
<th bgcolor="#FFAC91" class="style12">Ҥҵ<br>
˹</th>
<th bgcolor="#FFAC91" class="style12">Ҥ</th> </tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left"><input type="text" name="txtItem<?=$i;?>" size="30" value="<?=$objResult["Item"];?>"></div></td>
<td><div align="center"><input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>"></div></td>
<td><div align="center"><input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>"></div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center"><input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>"></div></td>
<td><div align="center"><input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>"></div></td>
<td><div align="center"><input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>"></div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left>
<br>
<br>
</left>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<center>
</center>
</td>
</tr>
<tr>
<td bgcolor="#E6CCFF"><!-- --------------------------------------------- ˹§ҹ 11 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center"><span class="style6 style7"><strong>˹§ҹ ͧءԹ </strong></span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_er");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\er\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr>
<th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="76" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">˹¹Ѻ </div></th>
<th width="108" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style12"">ͧѺ<br>
˹ҷٹ</div> </th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91" class="style12">حҵ<br>
ԡ</th>
<th bgcolor="#FFAC91" class="style12">¨ԧ</th>
<th bgcolor="#FFAC91" class="style12">Ҥҵ<br>
˹</th>
<th bgcolor="#FFAC91" class="style12">Ҥ</th> </tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left"><input type="text" name="txtItem<?=$i;?>" size="30" value="<?=$objResult["Item"];?>"></div></td>
<td><div align="center"><input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>"></div></td>
<td><div align="center"><input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>"></div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center"><input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>"></div></td>
<td><div align="center"><input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>"></div></td>
<td><div align="center"><input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>"></div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left><br>
<br>
</left>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!----------------------------------------˹§ҹ 11 ---------------------------------------------------------------------------------------------> </td>
<td bgcolor="#B0FFFF"><!-- --------------------------------------------- ˹§ҹ 12 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center"><span class="style7 style6"><strong>ͧѡ͡˹¨¡ҧ </strong></span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_supply");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\supply\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr>
<th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="76" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">˹¹Ѻ </div></th>
<th width="108" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style12"">ͧѺ<br>
˹ҷٹ</div> </th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91" class="style12">حҵ<br>
ԡ</th>
<th bgcolor="#FFAC91" class="style12">¨ԧ</th>
<th bgcolor="#FFAC91" class="style12">Ҥҵ<br>
˹</th>
<th bgcolor="#FFAC91" class="style12">Ҥ</th> </tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left"><input type="text" name="txtItem<?=$i;?>" size="30" value="<?=$objResult["Item"];?>"></div></td>
<td><div align="center"><input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>"></div></td>
<td><div align="center"><input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>"></div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center"><input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>"></div></td>
<td><div align="center"><input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>"></div></td>
<td><div align="center"><input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>"></div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left><br>
<br>
</left>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!----------------------------------------˹§ҹ 12 ---------------------------------------------------------------------------------------------> </td>
</tr>
<tr>
<td bgcolor="#E6CCFF"><!-- --------------------------------------------- ˹§ҹ 13 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center"><span class="style6 style7"><strong>ҡ</strong></span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_canteen");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\canteen\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr>
<th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="76" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">˹¹Ѻ </div></th>
<th width="108" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style12"">ͧѺ<br>
˹ҷٹ</div> </th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91" class="style12">حҵ<br>
ԡ</th>
<th bgcolor="#FFAC91" class="style12">¨ԧ</th>
<th bgcolor="#FFAC91" class="style12">Ҥҵ<br>
˹</th>
<th bgcolor="#FFAC91" class="style12">Ҥ</th> </tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left"><input type="text" name="txtItem<?=$i;?>" size="30" value="<?=$objResult["Item"];?>"></div></td>
<td><div align="center"><input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>"></div></td>
<td><div align="center"><input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>"></div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center"><input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>"></div></td>
<td><div align="center"><input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>"></div></td>
<td><div align="center"><input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>"></div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left><br>
</left>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!----------------------------------------˹§ҹ 13 ---------------------------------------------------------------------------------------------> </td>
<td bgcolor="#B0FFFF"><!-- --------------------------------------------- ˹§ҹ 14 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center"><span class="style7 style6"><strong>ͧʹ</strong></span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_lr");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\lr\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr>
<th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="76" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">˹¹Ѻ </div></th>
<th width="108" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style12"">ͧѺ<br>
˹ҷٹ</div> </th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91" class="style12">حҵ<br>
ԡ</th>
<th bgcolor="#FFAC91" class="style12">¨ԧ</th>
<th bgcolor="#FFAC91" class="style12">Ҥҵ<br>
˹</th>
<th bgcolor="#FFAC91" class="style12">Ҥ</th> </tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left"><input type="text" name="txtItem<?=$i;?>" size="30" value="<?=$objResult["Item"];?>"></div></td>
<td><div align="center"><input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>"></div></td>
<td><div align="center"><input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>"></div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center"><input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>"></div></td>
<td><div align="center"><input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>"></div></td>
<td><div align="center"><input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>"></div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<center>
</center>
</td>
</tr>
<tr>
<td bgcolor="#E6CCFF"><!-- --------------------------------------------- ˹§ҹ 15 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center"><span class="style6 style7"><strong></strong></span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_ward");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\ward\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr>
<th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="76" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">˹¹Ѻ </div></th>
<th width="108" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style12"">ͧѺ<br>
˹ҷٹ</div> </th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91" class="style12">حҵ<br>
ԡ</th>
<th bgcolor="#FFAC91" class="style12">¨ԧ</th>
<th bgcolor="#FFAC91" class="style12">Ҥҵ<br>
˹</th>
<th bgcolor="#FFAC91" class="style12">Ҥ</th> </tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left"><input type="text" name="txtItem<?=$i;?>" size="30" value="<?=$objResult["Item"];?>"></div></td>
<td><div align="center"><input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>"></div></td>
<td><div align="center"><input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>"></div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center"><input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>"></div></td>
<td><div align="center"><input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>"></div></td>
<td><div align="center"><input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>"></div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!----------------------------------------˹§ҹ 15 ---------------------------------------------------------------------------------------------> </td>
<td bgcolor="#B0FFFF"><!-- --------------------------------------------- ˹§ҹ 16----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center"><span class="style7 style6"><strong>¹͡</strong></span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_opd");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\opd\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr>
<th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="76" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">˹¹Ѻ </div></th>
<th width="108" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style12"">ͧѺ<br>
˹ҷٹ</div> </th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91" class="style12">حҵ<br>
ԡ</th>
<th bgcolor="#FFAC91" class="style12">¨ԧ</th>
<th bgcolor="#FFAC91" class="style12">Ҥҵ<br>
˹</th>
<th bgcolor="#FFAC91" class="style12">Ҥ</th> </tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left"><input type="text" name="txtItem<?=$i;?>" size="30" value="<?=$objResult["Item"];?>"></div></td>
<td><div align="center"><input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>"></div></td>
<td><div align="center"><input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>"></div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center"><input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>"></div></td>
<td><div align="center"><input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>"></div></td>
<td><div align="center"><input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>"></div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<center>
</center>
</td>
</tr>
<tr>
<td bgcolor="#E6CCFF"><!-- --------------------------------------------- ˹§ҹ 17 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center"><span class="style6 style7"><strong>ѧ</strong></span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_pharsto");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\pharmastore\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr>
<th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="76" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">˹¹Ѻ </div></th>
<th width="108" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style12"">ͧѺ<br>
˹ҷٹ</div> </th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91" class="style12">حҵ<br>
ԡ</th>
<th bgcolor="#FFAC91" class="style12">¨ԧ</th>
<th bgcolor="#FFAC91" class="style12">Ҥҵ<br>
˹</th>
<th bgcolor="#FFAC91" class="style12">Ҥ</th> </tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left"><input type="text" name="txtItem<?=$i;?>" size="30" value="<?=$objResult["Item"];?>"></div></td>
<td><div align="center"><input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>"></div></td>
<td><div align="center"><input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>"></div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center"><input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>"></div></td>
<td><div align="center"><input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>"></div></td>
<td><div align="center"><input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>"></div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left><br>
<br>
</left>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!----------------------------------------˹§ҹ 17 ---------------------------------------------------------------------------------------------> </td>
<td bgcolor="#B0FFFF"><!-- --------------------------------------------- ˹§ҹ 18 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center"><span class="style7 style6"><strong>ͧѺö</strong></span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_driver");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\driver\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr>
<th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="76" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">˹¹Ѻ </div></th>
<th width="108" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style12"">ͧѺ<br>
˹ҷٹ</div> </th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91" class="style12">حҵ<br>
ԡ</th>
<th bgcolor="#FFAC91" class="style12">¨ԧ</th>
<th bgcolor="#FFAC91" class="style12">Ҥҵ<br>
˹</th>
<th bgcolor="#FFAC91" class="style12">Ҥ</th> </tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left"><input type="text" name="txtItem<?=$i;?>" size="30" value="<?=$objResult["Item"];?>"></div></td>
<td><div align="center"><input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>"></div></td>
<td><div align="center"><input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>"></div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center"><input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>"></div></td>
<td><div align="center"><input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>"></div></td>
<td><div align="center"><input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>"></div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!----------------------------------------˹§ҹ 18 ---------------------------------------------------------------------------------------------> </td>
</tr>
<tr>
<td bgcolor="#E6CCFF"><!-- --------------------------------------------- ˹§ҹ 19 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center"><span class="style6 style7"><strong>ѹ</strong></span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_dent");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\dental\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr>
<th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="76" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">˹¹Ѻ </div></th>
<th width="108" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style12"">ͧѺ<br>
˹ҷٹ</div> </th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91" class="style12">حҵ<br>
ԡ</th>
<th bgcolor="#FFAC91" class="style12">¨ԧ</th>
<th bgcolor="#FFAC91" class="style12">Ҥҵ<br>
˹</th>
<th bgcolor="#FFAC91" class="style12">Ҥ</th> </tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left"><input type="text" name="txtItem<?=$i;?>" size="30" value="<?=$objResult["Item"];?>"></div></td>
<td><div align="center"><input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>"></div></td>
<td><div align="center"><input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>"></div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center"><input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>"></div></td>
<td><div align="center"><input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>"></div></td>
<td><div align="center"><input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>"></div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!----------------------------------------˹§ҹ 19 ---------------------------------------------------------------------------------------------> </td>
<td bgcolor="#B0FFFF"><!-- --------------------------------------------- ˹§ҹ 20 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center"><span class="style7 style6"><strong>ͧѡᾷ</strong></span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_doctor");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\doctor\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr>
<th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="76" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">˹¹Ѻ </div></th>
<th width="108" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style12"">ͧѺ<br>
˹ҷٹ</div> </th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91" class="style12">حҵ<br>
ԡ</th>
<th bgcolor="#FFAC91" class="style12">¨ԧ</th>
<th bgcolor="#FFAC91" class="style12">Ҥҵ<br>
˹</th>
<th bgcolor="#FFAC91" class="style12">Ҥ</th> </tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left"><input type="text" name="txtItem<?=$i;?>" size="30" value="<?=$objResult["Item"];?>"></div></td>
<td><div align="center"><input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>"></div></td>
<td><div align="center"><input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>"></div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center"><input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>"></div></td>
<td><div align="center"><input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>"></div></td>
<td><div align="center"><input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>"></div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left><br>
<br>
</left>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!----------------------------------------˹§ҹ 20 ---------------------------------------------------------------------------------------------> </td>
</tr>
<tr>
<td bgcolor="#E6CCFF"><!-- --------------------------------------------- ˹§ҹ 21 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center"><span class="style7 style6"><strong>Թԡ</strong></span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_room4");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\room4\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr>
<th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="76" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">˹¹Ѻ </div></th>
<th width="108" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style12"">ͧѺ<br>
˹ҷٹ</div> </th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91" class="style12">حҵ<br>
ԡ</th>
<th bgcolor="#FFAC91" class="style12">¨ԧ</th>
<th bgcolor="#FFAC91" class="style12">Ҥҵ<br>
˹</th>
<th bgcolor="#FFAC91" class="style12">Ҥ</th> </tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left"><input type="text" name="txtItem<?=$i;?>" size="30" value="<?=$objResult["Item"];?>"></div></td>
<td><div align="center"><input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>"></div></td>
<td><div align="center"><input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>"></div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center"><input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>"></div></td>
<td><div align="center"><input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>"></div></td>
<td><div align="center"><input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>"></div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left><br>
<br>
</left>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!----------------------------------------˹§ҹ 21 ---------------------------------------------------------------------------------------------> </td>
<td bgcolor="#B0FFFF"><!-- --------------------------------------------- ˹§ҹ 22 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center"><span class="style6 style7"><strong>ͧ X-ray</strong></span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_xray");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_5 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\xray\pusducom557.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr>
<th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="76" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">˹¹Ѻ </div></th>
<th width="108" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style12"">ͧѺ<br>
˹ҷٹ</div> </th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91" class="style12">حҵ<br>
ԡ</th>
<th bgcolor="#FFAC91" class="style12">¨ԧ</th>
<th bgcolor="#FFAC91" class="style12">Ҥҵ<br>
˹</th>
<th bgcolor="#FFAC91" class="style12">Ҥ</th> </tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left"><input type="text" name="txtItem<?=$i;?>" size="30" value="<?=$objResult["Item"];?>"></div></td>
<td><div align="center"><input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>"></div></td>
<td><div align="center"><input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>"></div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center"><input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>"></div></td>
<td><div align="center"><input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>"></div></td>
<td><div align="center"><input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>"></div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left><br>
<br>
</left>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!----------------------------------------˹§ҹ 22 ---------------------------------------------------------------------------------------------> </td>
</tr>
<tr>
<td bgcolor="#E6CCFF"><!-- --------------------------------------------- ˹§ҹ 23 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center"><span class="style7 style6"><strong>˹§ҹ IC</strong></span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusducom_ic");
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
mysql_query("Set names 'tis620'");
$strSQL = "UPDATE Month_1 SET ";
$strSQL .="Seq = '".$_POST["txtSeq$i"]."' ";
//$strSQL .=",Item = '".$_POST["txtItem$i"]."' ";
//$strSQL .=",Unit = '".$_POST["txtUnit$i"]."' ";
$strSQL .=",Req_num = '".$_POST["txtReq_num$i"]."' ";
$strSQL .=",Allow = '".$_POST["txtAllow$i"]."' ";
$strSQL .=",Pay = '".$_POST["txtPay$i"]."' ";
$strSQL .=",Oneprice = '".$_POST["txtOneprice$i"]."' ";
$strSQL .=",Totalprice = '".$_POST["txtTotalprice$i"]."' ";
$strSQL .="WHERE Seq = '".$_POST["hdnSeq$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Month_1 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\ic\pusducom157.php?Action=Save">
<table width="620" height="155" border="1" align="center">
<tr>
<th width="205" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">¡ </div></th>
<th width="76" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">˹¹Ѻ </div></th>
<th width="108" rowspan="2" bgcolor="#FFAC91"> <div align="center" class="style12">ӹǹ<br>
ͧԡ </div></th>
<th height="48" colspan="4" bgcolor="#FFAC91"> <div align="center" class="style12"">ͧѺ<br>
˹ҷٹ</div> </th>
</tr>
<tr>
<th height="26" bgcolor="#FFAC91" class="style12">حҵ<br>
ԡ</th>
<th bgcolor="#FFAC91" class="style12">¨ԧ</th>
<th bgcolor="#FFAC91" class="style12">Ҥҵ<br>
˹</th>
<th bgcolor="#FFAC91" class="style12">Ҥ</th> </tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="left"><input type="text" name="txtItem<?=$i;?>" size="30" value="<?=$objResult["Item"];?>"></div></td>
<td><div align="center"><input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>"></div></td>
<td><div align="center"><input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>"></div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center"><input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>"></div></td>
<td><div align="center"><input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>"></div></td>
<td><div align="center"><input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>"></div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFDED2">
<td colspan="6" align="center">Ҥ Total price </td>
<td align="center"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left><br>
<br>
</left>
<center>
<input type="hidden" name="hdnLine" value="<?=$i;?>">
</center>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!----------------------------------------˹§ҹ 23 ---------------------------------------------------------------------------------------------> </td>
<td bgcolor="#B0FFFF"><div align="center">Ҥʴؤ ء˹§ҹҤ </div></td>
</tr>
</table>
</body>
</html>