Hi…
I need to add code to check if the compound that was choose is reach the maximum value then if it is already reach theirs a notification displayed that he already gain the maximum.
the problem is…I don’t know how can I check if what the user choose before run the condition.
here is my code:
<?php
$config['BASE_DIR'] = dirname(dirname(__FILE__));
$config['BASE_DIR'] = $config['BASE_DIR']. '\\MES PROJECT';
define('SMARTY_DIR', $config['BASE_DIR']. '/INCLUDE/smarty/libs/');
require(SMARTY_DIR . 'Smarty.class.php');
$smarty = new Smarty();
$smarty = new Smarty();
$smarty->template_dir = $config['BASE_DIR']. '/smarty/templates';
$smarty->config_dir = $config['BASE_DIR']. '/smarty/config';
$smarty->cache_dir = $config['BASE_DIR']. '/INCLUDE/smarty/cache';
$smarty->compile_dir = $config['BASE_DIR']. '/INCLUDE/smarty/templates_c';
$con= mysql_connect('localhost', 'root', '');
if (!$con) {
echo 'failed';
die();
}
mysql_select_db("mes", $con);
$hostAddr = $_SERVER['REMOTE_ADDR'];
$terminal = $hostAddr; //<-enable this in server
//$terminal = $_POST['doThis']; //<- disable this in server
$terminal = "192.168.1.101";
switch ($terminal) {
case "192.168.1.101" : //<< enable this in server
//case "1" :
$smarty->assign('process', 'Rubber/Chemical Preparation');
$smarty->assign('termNo', 'Terminal 1');
$smarty->assign('text_name1','Compound Code');
$smarty->assign('text_name2','Lot Traveler ID');
$smarty->assign('text_name3','Kit Weight ');
$smarty->assign('text_name4','Operator Code');
[b] $smarty->assign('compoundIndexValue', array('0', 'P28', 'P30', 'P32', 'P33', 'P35', 'P35M', 'P38', 'P40', 'P41', 'P42', 'P43', 'P46', 'P47', 'PXX', 'P35W'));[/b]
$smarty->assign('names', array('<Choose Code>', 'P28', 'P30', 'P32', 'P33', 'P35', 'P35M', 'P38', 'P40', 'P41', 'P42', 'P43', 'P46', 'P47', 'PXX', 'P35W'));
$smarty->assign('weightIndexValue', array('0', '60.145', '68.980', '65.381', '69.270', '49.360', '68.610', '54.880', '73.300', '51.973', '52.944', '57.627', '45.997', '69.196', '70.000', '55.000'));
$smarty->assign('kitWeight', array('<Choose Weight>','60.145', '68.980', '65.381', '69.270', '49.360', '68.610', '54.880', '73.300', '51.973', '52.944', '57.627', '45.997', '69.196', '70.000', '55.000'));
//Chemical weighing Process : Terminal 1
$smarty->display('header.tpl'); // common Header
$smarty->display('box_1.tpl');
$smarty->display('footer.tpl');
[b] $compound = mysql_real_escape_string($_POST['compoundIndexValue']);
$sql = "SELECT
P28, P28_max, P28_min,
P30, P30_max, P30_min,
P32, P32_max, P32_min,
P33, P33_max, P33_min,
P35, P35_max, P35_min,
P35M, P35M_max, P35M_min,
P35W, P35W_max, P35W_min,
P38, P38_max, P38_min,
P41, P41_max, P41_min,
P42, P42_max, P42_min,
P43, P43_max, P43_min,
P46, P46_max, P46_min,
P47, P47_max, P47_min
FROM parameter_settings";
$res_pcode = mysql_query($sql, $con);
$row = mysql_fetch_assoc($res_pcode);
$P28 = $row['P28'];
$P28_max = $row['P28_max'];
$P28_min = $row['P28_min'];
$P30 = $row['P30'];
$P30_max = $row['P30_max'];
$P30_min = $row['P30_min'];
$P32 = $row['P32'];
$P32_max = $row['P32_max'];
$P32_min = $row['P32_min'];
$P33 = $row['P33'];
$P33_max = $row['P33_max'];
$P33_min = $row['P33_min'];
$P35 = $row['P35'];
$P35_max = $row['P35_max'];
$P35_min = $row['P35_min'];
$P35M = $row['P35M'];
$P35M_max = $row['P35M_max'];
$P35M_min = $row['P35M_min'];
$P35W = $row['P35W'];
$P35W_max = $row['P35W_max'];
$P35W_min = $row['P35W_min'];
$P38 = $row['P38'];
$P38_max = $row['P38_max'];
$P38_min = $row['P38_min'];
$P41 = $row['P41'];
$P41_max = $row['P41_max'];
$P41_min = $row['P41_min'];
$P42 = $row['P42'];
$P42_max = $row['P42_max'];
$P42_min = $row['P42_min'];
$P43 = $row['P43'];
$P43_max = $row['P43_max'];
$P43_min = $row['P43_min'];
$P46 = $row['P46'];
$P46_max = $row['P46_max'];
$P46_min = $row['P46_min'];
$P47 = $row['P47'];
$P47_max = $row['P47_max'];
$P47_min = $row['P47_min'];
$sql = "SELECT PCODE, total FROM kanban_checker WHERE PCODE = '$compound' ORDER BY PCODE";
$res_kanban = mysql_query($sql, $con);
$row_kanban = mysql_fetch_assoc($res_kanban);
$PCODE = $row_kanban['PCODE'];
$total = $row_kanban['total'];
if($compound == $P28 && $total == $P28_max){
echo "<script type='text/javascript'>notify(P28 gain total maximum)</script>";
}
else {
echo '';
}
if($compound == $P30 && $total == $P30_max){
echo "<script type='text/javascript'>notify(P30 gain total maximum)</script>";
}
else{
echo '';
}
if($compound == $P32 && $total == $P32_max){
echo "<script type='text/javascript'>notify(P32 gain total maximum)</script>";
}
else{
echo '';
}
if($compound == $P33 && $total == $P33_max){
echo "<script type='text/javascript'>notify(P33 gain total maximum)</script>";
}
else{
echo '';
}
if($compound == $P35 && $total == $P35_max){
echo "<script type='text/javascript'>notify(P35 gain total maximum)</script>";
}
else{
echo '';
}
if($compound == $P35M && $total == $P35M_max){
echo "<script type='text/javascript'>notify(P35M gain total maximum)</script>";
}
else{
echo '';
}
if($compound == $P35W && $total == $P35W_max){
echo "<script type='text/javascript'>notify(P35W gain total maximum)</script>";
}
else{
echo '';
}
if($compound == $P38 && $total == $P38_max){
echo "<script type='text/javascript'>notify(P38 gain total maximum)</script>";
}
else{
echo '';
}
if($compound == $P41 && $total == $P41_max){
echo "<script type='text/javascript'>notify(P41 gain total maximum)</script>";
}
else{
echo '';
}
if($compound == $P42 && $total == $P42_max){
echo "<script type='text/javascript'>notify(P42 gain total maximum)</script>";
}
else{
echo '';
}
if($compound == $P43 && $total == $P43_max){
echo "<script type='text/javascript'>notify(P43 gain total maximum)</script>";
}
else{
echo '';
}
if($compound == $P46 && $total == $P46_max){
echo "<script type='text/javascript'>notify(P46 gain total maximum)</script>";
}
else{
echo '';
}
if($compound == $P47 && $total == $P47_max){
echo "<script type='text/javascript'>notify(P47 gain total maximum)</script>";
}
else{
echo '';
}[/b]
break;
case "192.168.1.102" : //<< enable this in server
//case "2" :
$smarty->assign('process', 'Compounding Process');
$smarty->assign('termNo', 'Terminal 2');
$smarty->assign('text_name1','Lot Traveler ID');
$smarty->assign('text_name2','Kit Weight');
$smarty->assign('text_name3','Machine Code');
$smarty->assign('text_name4','Operator Code');
$smarty->assign('machineID', array('0', 'B1', 'B2', 'B3', 'K1', 'K2', 'OM1', 'OM2', 'OM3', 'OM4', 'OM5', 'OM6', 'OM7'));
$smarty->assign('machineIDdisplay', array('<Choose Machine ID>', 'B1', 'B2', 'B3', 'K1', 'K2', 'OM1', 'OM2', 'OM3', 'OM4', 'OM5', 'OM6', 'OM7'));
$smarty->display('header.tpl'); // common Header
$smarty->display('box_2.tpl');
$smarty->display('footer.tpl');
break;
}
?>
My only purpose is to avoid adding data so i need to prompt if he already reach the maximum per compound.
Thank you so much