newphpcoder
Verified User
- Joined
- Dec 22, 2010
- Messages
- 7
Good day!
I have code to check if the cloth type is NW or W for the operation name Operation3, Operation4, and Operation5.
NW = AAA, BBB, CCC
W = all cloth that was not belong to NW
if it is NW the input will multiply to 14.15 and if W it will multiply to 15.85. Reason why i need to multiply because the user they input number that is frame so I need it to convert to dozen.
Here is the code I want to ask for you if correct and if I have missing code, because I’m not good in if condition and mysql statement.
In this code theres no error but it did not mulitply
I have code to check if the cloth type is NW or W for the operation name Operation3, Operation4, and Operation5.
NW = AAA, BBB, CCC
W = all cloth that was not belong to NW
if it is NW the input will multiply to 14.15 and if W it will multiply to 15.85. Reason why i need to multiply because the user they input number that is frame so I need it to convert to dozen.
Here is the code I want to ask for you if correct and if I have missing code, because I’m not good in if condition and mysql statement.
PHP:
<?php
include 'config.php';
$rexist = 0;
if($_POST["clt_no"])
{
$query = sprintf("INSERT INTO clt_transact(cloth_type)VALUES ('%s')",
mysql_real_escape_string($_POST["cloth_type"])
);
$result = mysql_query($query);
$clt_transact_id = mysql_insert_id();
$opname = $_POST["opname"];
$inqty = $_POST["inqty"];
$outqty = $_POST["outqty"];
$varqty = $_POST["varqty"];
$totalarr = count($opname) - 1;
for($ctr=0; $ctr < $totalarr; $ctr++)
{
$inqty[$ctr] = (float) $inqty[$ctr];
$varqty[$ctr] = (float) $varqty[$ctr];
$outqty[$ctr] = (float) $outqty[$ctr];
$query = "INSERT INTO clt_traceability (operation_name, input_qty, output_qty, variance_qty, clt_transact_id) VALUES ('" . $opname[$ctr] . "', '" . $inqty[$ctr] . "','" . $outqty[$ctr] . "', '" . $varqty[$ctr] . "', '" . $clt_transact_id . "')";
$result = mysql_query($query);
}
}
$cloth_type = $_POST["cloth_type"];
$query = "SELECT t.operation_name FROM clt_traceability t, clt_transact c WHERE c.cloth_type = '" . $cloth_type . "' AND t.operation_name IN ('Operation3, Operation4, Operation5 ') AND t.clt_no = c.clt_no";
$result = mysql_query($query);
//$debugVar = "Cloth Type:".$cloth_type."<BR>";
//$debugVar .= "Input Qty:".$input_qty."<BR>";
//$debugVar .= "Output Qty:".$output_qty."<BR>";
if($cloth_type == 'AAA' || $cloth_type == 'BBB' || $cloth_type == 'CCC') {
$input_qty = $input_qty * 14.15;
$output_qty = $output_qty * 14.15;
}
else{
$input_qty = $input_qty * 15.85;
$output_qty = $output_qty * 15.85;
}
$rexist = 0;
?>
<html>
<head>
<style type="text/css">
.myclass {
font-size: 10pt; font-family:Arial, Helvetica, sans-serif;
}
</style>
<script type="text/javascript">
document.onkeypress = function(e){
e = e || event; e.returnValue = true;
var t = e.target || e.srcElement, re = /^(inqty|outqty)(\d+)$/, f = arguments.callee, m, i;
function next(){
if(!f.els && (m = t.form) === document.forms.clttype){
var ipts = m.getElementsByTagName('input'), els = []; i = ipts.length - 1;
for (i; i > -1; --i){
if(ipts[i].type && ipts[i].type.toLowerCase() === 'text'){
els.push(ipts[i]);
}
}
f.els = els;
}
if(f.els){
i = f.els.length - 1;
for (i; i > -1; --i){
if(f.els[i] === t && (m = f.els[i - 1])){
m.focus();
}
}
}
}
if((m = re.exec(t.id)) && e.keyCode === 13){
e.returnValue = false;
t.form.elements['varqty' + m[2]].value = t.form.elements['inqty' + m[2]].value - t.form.elements['outqty' + m[2]].value;
} else if (t.type && e.keyCode === 13 && t.type.toLowerCase() !== 'submit') {
e.returnValue = false;
}
if(!e.returnValue){
next();
if(e.preventDefault){e.preventDefault();}
}
return e.returnValue;
}
</script>
</head>
<body>
<form action='frame.php' method="post" name="clttype">
<?php
$rexist = 1;
echo "<table>";
echo "<tr><td>Cloth Type</td><td><input type='text' name='cloth_type' id='cloth_type' /></td></tr>";
echo "</table>";
echo "<p> </p>";
$query = "SELECT * FROM clt_trace_operations ORDER BY operation_name";
$last_operation_name = "";
$result = mysql_query($query);
if($result)
{
$rexist = 1;
echo "<table>";
echo "<tr><th class='myclass'>OPERATIONS</th><th class='myclass'>INPUT <br/> QTY</th><th class='myclass'>OUTPUT <br/> QTY</th><th class='myclass'>VARIANCE Qty</th></tr>";
$totalrows = mysql_num_rows($result);
$trows = $totalrows - 1;
for($ctr = 0; $ctr < $trows; $ctr++)
{
$row = mysql_fetch_array($result);
$tctr = $ctr + 1;
echo "\n\t<tr>";
echo "\n\t\t<td>";
if ($last_operation_name != $row["operation_name"]) echo $row["operation_name"];
$last_operation_name = $row["operation_name"];
echo "<input type='hidden' width='400' name='opname[]' value='" . $row["operation_name"] . "' /></td>";
echo "\n\t\t<td><input size='6' type='text' name='inqty[]' id='inqty" . $ctr . "' /></td>";
echo "\n\t\t<td><input size='6' type='text' name='outqty[]' id='outqty" . $ctr . "' ></td>";
echo "\n\t\t<td><input size='6' type='text' name='varqty[]' id='varqty" . $ctr . "' /></td>";
echo "\n\t</tr>";
}
if($totalrows > 1);
{
$row = mysql_fetch_array($result);
echo "\n\t<tr>";
echo "\n\t\t<td>";
if ($last_operation_name != $row["operation_name"]) echo $row["operation_name"];
$last_operation_name = $row["operation_name"];
echo "<input type='hidden' width='400' name='opname[]' value='" . $row["operation_name"] . "' /></td>";
echo "<input type='hidden' name='opname[]' value='" . $row["operation_name"] . "' /></td>";
echo "\n\t\t<td><input size='6' type='text' name='inqty[]' id='inqty" . $ctr . "' /></td>";
echo "\n\t\t<td><input size='6' type='text' name='outqty[]' id='outqty" . $ctr . "' /></td>";
echo "\n\t\t<td><input size='6' type='text' name='varqty[]' value='' id='varqty" . $ctr . "' /></td>";
echo "\n\t</tr>";
}
echo "</table>";
}
echo "<p><input type='submit' value=' Save ' id='saveform' /></p>";
echo "<input type='hidden' name='clt_typeno' value='" . $_POST["clt_typeno"] . "' />";
?>
</form>
</body>
</html>
In this code theres no error but it did not mulitply