newphpbees
19 Apr 2012, 06:58 PM
Hi..
I encountered problem in displaying joborder number or JO_No inside while loop.
I want to happen is only JO_No will display after I click the Approved button and it will only appear on the row where the Approved button was click.
Now in my code the JO_No was display automatically in the row of JO_No .
here is my code:
<?php
error_reporting(0);
date_default_timezone_set("Asia/Singapore"); //set the time zone
$con = mysql_connect('localhost', 'root','');
if (!$con) {
echo 'failed';
die();
}
mysql_select_db("mes", $con);
$Date_Shelve =date('Y-m-d H:i:s');
?>
<html>
<head>
<title>Job Order</title>
<link rel="stylesheet" type="text/css" href="kanban.css" />
</head>
<body>
<div id="SR_date">
<label>Date :</label>
<input type="text" name="Date_Shelve" id="Date_Shelve" value="<?php echo $Date_Shelve; ?>" size="16" readonly="readonly" style="border: none;">
</div>
<div id="kanban_table">
<table width="auto">
<th> JO No.</th>
<th> ETD </th>
<th> PO No. </th>
<th> SKU Code </th>
<th> Description </th>
<th> PO Req </th>
<th> Requirements </th>
<th> Priority</th>
<?php
$sql = "SELECT ETD, PO_No, SKUCode, Description, POReq
FROM sales_order";
$res_so = mysql_query($sql, $con);
$Approved = isset($_POST['priority']);
if ($Approved)
{
$PO_No = $_POST['PO_No'];
//----I want to display only the jo_number after click the approved button and it only display on the row where I click the approved button---
$sql = "SELECT jo_number FROM job_order ORDER BY jo_date DESC LIMIT 1";
$result = mysql_query($sql, $con);
if (!$result) {
echo 'failed';
die();
}
$total = mysql_num_rows($result);
if ($total <= 0) {
$currentSRNum = 1;
$currentYear = (int)(date('y'));
$currentMonth = (int)(date('m'));
$currentDay = (int)(date('d'));
$currentSRYMD = substr($row['jo_number'], 0, 6);
$currentYMD = date("ymd");
if ($currentYMD > $currentSRYMD)
{
$currentSRNum = 1;
}
else
{
$currentSRNum += 1;
}
}
else {
//----------------------------------------
$row = mysql_fetch_assoc($result);
$currentSRNum = (int)(substr($row['jo_number'],0,3));
$currentSRYear = (int)(substr($row['jo_number'],2,2));
$currentSRMonth = (int)(substr($row['jo_number'],0,2));
$currentSRNum = (int)(substr($row['jo_number'],6,4));
$currentYear = (int)(date('y'));
$currentMonth = (int)(date('m'));
$currentDay = (int)(date('d'));
$currentSRYMD = substr($row['jo_number'], 0, 6);
$currentYMD = date("ymd");
if ($currentYMD > $currentSRYMD)
{
$currentSRNum = 1;
}
else
{
$currentSRNum += 1;
}
}
$yearMonth = date('ymd');
$currentSR = $currentYMD . sprintf("%04d", $currentSRNum); //JO_No
}
while($row = mysql_fetch_assoc($res_so)){
echo "<form name='joborder_form' action='' method='post'>";
$PO_No = $row['PO_No'];
echo "<tr>
<td><input type='text' name='JO_No' id='JO_No' value='$currentSR' style='border:none;width:auto;' size='10'></td>
<td><input type='text' name='ETD' id='ETD' value='$row[ETD]' style='border:none;width:auto;' size='10'></td>
<td><input type='text' name='PO_No' id='PO_No' value='$row[PO_No]' style='border:none;' size='30'></td>
<td><input type='text' name='SKUCode' id='SKUCode' value='$row[SKUCode]' style='border:none;' size='15'></td>
<td><input type='text' name='Description' id='Description' value='$row[Description]' style='border:none;' size='35'></td>
<td><input type='text' name='POReq' id='POReq' value='$row[POReq]' style='border:none;width:auto;' size='10'></td>
<td> </td>
<td><input type='submit' name='priority' value='Approved' id='priority'></td>
</tr>";
echo "</form>";
}
?>
</table>
</div>
</body>
</html>
Any help is highly appreciated
Thank you
I encountered problem in displaying joborder number or JO_No inside while loop.
I want to happen is only JO_No will display after I click the Approved button and it will only appear on the row where the Approved button was click.
Now in my code the JO_No was display automatically in the row of JO_No .
here is my code:
<?php
error_reporting(0);
date_default_timezone_set("Asia/Singapore"); //set the time zone
$con = mysql_connect('localhost', 'root','');
if (!$con) {
echo 'failed';
die();
}
mysql_select_db("mes", $con);
$Date_Shelve =date('Y-m-d H:i:s');
?>
<html>
<head>
<title>Job Order</title>
<link rel="stylesheet" type="text/css" href="kanban.css" />
</head>
<body>
<div id="SR_date">
<label>Date :</label>
<input type="text" name="Date_Shelve" id="Date_Shelve" value="<?php echo $Date_Shelve; ?>" size="16" readonly="readonly" style="border: none;">
</div>
<div id="kanban_table">
<table width="auto">
<th> JO No.</th>
<th> ETD </th>
<th> PO No. </th>
<th> SKU Code </th>
<th> Description </th>
<th> PO Req </th>
<th> Requirements </th>
<th> Priority</th>
<?php
$sql = "SELECT ETD, PO_No, SKUCode, Description, POReq
FROM sales_order";
$res_so = mysql_query($sql, $con);
$Approved = isset($_POST['priority']);
if ($Approved)
{
$PO_No = $_POST['PO_No'];
//----I want to display only the jo_number after click the approved button and it only display on the row where I click the approved button---
$sql = "SELECT jo_number FROM job_order ORDER BY jo_date DESC LIMIT 1";
$result = mysql_query($sql, $con);
if (!$result) {
echo 'failed';
die();
}
$total = mysql_num_rows($result);
if ($total <= 0) {
$currentSRNum = 1;
$currentYear = (int)(date('y'));
$currentMonth = (int)(date('m'));
$currentDay = (int)(date('d'));
$currentSRYMD = substr($row['jo_number'], 0, 6);
$currentYMD = date("ymd");
if ($currentYMD > $currentSRYMD)
{
$currentSRNum = 1;
}
else
{
$currentSRNum += 1;
}
}
else {
//----------------------------------------
$row = mysql_fetch_assoc($result);
$currentSRNum = (int)(substr($row['jo_number'],0,3));
$currentSRYear = (int)(substr($row['jo_number'],2,2));
$currentSRMonth = (int)(substr($row['jo_number'],0,2));
$currentSRNum = (int)(substr($row['jo_number'],6,4));
$currentYear = (int)(date('y'));
$currentMonth = (int)(date('m'));
$currentDay = (int)(date('d'));
$currentSRYMD = substr($row['jo_number'], 0, 6);
$currentYMD = date("ymd");
if ($currentYMD > $currentSRYMD)
{
$currentSRNum = 1;
}
else
{
$currentSRNum += 1;
}
}
$yearMonth = date('ymd');
$currentSR = $currentYMD . sprintf("%04d", $currentSRNum); //JO_No
}
while($row = mysql_fetch_assoc($res_so)){
echo "<form name='joborder_form' action='' method='post'>";
$PO_No = $row['PO_No'];
echo "<tr>
<td><input type='text' name='JO_No' id='JO_No' value='$currentSR' style='border:none;width:auto;' size='10'></td>
<td><input type='text' name='ETD' id='ETD' value='$row[ETD]' style='border:none;width:auto;' size='10'></td>
<td><input type='text' name='PO_No' id='PO_No' value='$row[PO_No]' style='border:none;' size='30'></td>
<td><input type='text' name='SKUCode' id='SKUCode' value='$row[SKUCode]' style='border:none;' size='15'></td>
<td><input type='text' name='Description' id='Description' value='$row[Description]' style='border:none;' size='35'></td>
<td><input type='text' name='POReq' id='POReq' value='$row[POReq]' style='border:none;width:auto;' size='10'></td>
<td> </td>
<td><input type='submit' name='priority' value='Approved' id='priority'></td>
</tr>";
echo "</form>";
}
?>
</table>
</div>
</body>
</html>
Any help is highly appreciated
Thank you