$lab_DeleteRecordNotification_001"; } // dodawanie if (!empty($_POST['inEngName']) && $_POST['subEngSave']==$lab_ButtonName_Save) { $checkIsExists = sqlGetResAsArray("SELECT * FROM seg_engines WHERE ENG_NAME='".$_POST['inEngName']."' AND ENG_VOLTAGE='".$_POST['inEngVolt']."'"); if (count($checkIsExists)>0) { echo"
Silnik ".$_POST['inEngName']." o napięciu ".$_POST['inEngVolt']."[V] istnieje już w systemie
"; } else { $query_tmp = "INSERT INTO seg_engines SET ENG_MCF_ID=".$_POST['inEngNManufID'].",ENG_NAME='".$_POST['inEngName']."',ENG_STATUS='1'"; if (str_replace(",",".",$_POST['inEngVolt'])>0) $query_tmp .= ",ENG_VOLTAGE=".str_replace(",",".",$_POST['inEngVolt']); if (str_replace(",",".",$_POST['inEngDl'])>0) $query_tmp .= ",ENG_LENGTH=".str_replace(",",".",$_POST['inEngDl']); if (str_replace(",",".",$_POST['inEngMass'])>0) $query_tmp .= ",ENG_WEIGHT=".str_replace(",",".",$_POST['inEngMass']); if (str_replace(",",".",$_POST['inEngDiam'])>0) $query_tmp .= ",ENG_DIAMETER=".str_replace(",",".",$_POST['inEngDiam']); if (str_replace(",",".",$_POST['inEngPrzew'])>0) $query_tmp .= ",ENG_WIRES='".str_replace(",",".",$_POST['inEngPrzew'])."'"; if (str_replace(",",".",$_POST['inEngPower'])>0) $query_tmp .= ",ENG_POWER=".str_replace(",",".",$_POST['inEngPower']); if (str_replace(",",".",$_POST['inEngPrad'])>0) $query_tmp .= ",ENG_ELECTRICITY=".str_replace(",",".",$_POST['inEngPrad']); if (str_replace(",",".",$_POST['inEngObrot'])>0) $query_tmp .= ",ENG_RPM=".str_replace(",",".",$_POST['inEngObrot']); if (str_replace(",",".",$_POST['inEngCosFi'])>0) $query_tmp .= ",ENG_COS_FI=".str_replace(",",".",$_POST['inEngCosFi']); if (str_replace(",",".",$_POST['inEngSpraw'])>0) $query_tmp .= ",ENG_ETA=".str_replace(",",".",$_POST['inEngSpraw']); mysql_query($query_tmp); unset($query_tmp); echo"
$lab_SaveRecordNotification_001
"; } } // aktualizacja if (!empty($_POST['inEngName']) && $_POST['subEngUpdate']==$lab_ButtonName_Update) { $query_tmp = "update seg_engines SET ENG_MCF_ID=".$_POST['inEngNManufID'].",ENG_NAME='".$_POST['inEngName']."',ENG_STATUS='1'"; if (str_replace(",",".",$_POST['inEngVolt'])>0) $query_tmp .= ",ENG_VOLTAGE=".str_replace(",",".",$_POST['inEngVolt']); if (str_replace(",",".",$_POST['inEngDl'])>0) $query_tmp .= ",ENG_LENGTH=".str_replace(",",".",$_POST['inEngDl']); if (str_replace(",",".",$_POST['inEngMass'])>0) $query_tmp .= ",ENG_WEIGHT=".str_replace(",",".",$_POST['inEngMass']); if (str_replace(",",".",$_POST['inEngDiam'])>0) $query_tmp .= ",ENG_DIAMETER=".str_replace(",",".",$_POST['inEngDiam']); if (str_replace(",",".",$_POST['inEngPrzew'])>0) $query_tmp .= ",ENG_WIRES='".str_replace(",",".",$_POST['inEngPrzew'])."'"; if (str_replace(",",".",$_POST['inEngPower'])>0) $query_tmp .= ",ENG_POWER=".str_replace(",",".",$_POST['inEngPower']); if (str_replace(",",".",$_POST['inEngPrad'])>0) $query_tmp .= ",ENG_ELECTRICITY=".str_replace(",",".",$_POST['inEngPrad']); if (str_replace(",",".",$_POST['inEngObrot'])>0) $query_tmp .= ",ENG_RPM=".str_replace(",",".",$_POST['inEngObrot']); if (str_replace(",",".",$_POST['inEngCosFi'])>0) $query_tmp .= ",ENG_COS_FI=".str_replace(",",".",$_POST['inEngCosFi']); if (str_replace(",",".",$_POST['inEngSpraw'])>0) $query_tmp .= ",ENG_ETA=".str_replace(",",".",$_POST['inEngSpraw']); $query_tmp .= " where ENG_ID=".$_POST['inEngId']; mysql_query($query_tmp); unset($query_tmp); echo"
$lab_UpdateRecordNotification_001
"; } if (!$_POST['sr_status']) $_POST['sr_status']=100; ?> 1, 'value'=>$lab_Field_site204_001), array('id'=>2, 'value'=>$lab_Field_site204_003), ); ?>
producent:
 
"; else echo""; ?>
= ".(getFullFloatValue($_POST['sr_well']) - getFullFloatValue($_POST['sr_well'])*0.1)." and ENG_POWER <= ".(getFullFloatValue($_POST['sr_well']) + getFullFloatValue($_POST['sr_well'])*0.1); if($_POST['sr_status']!=100) $query.=" and MCF_ID=".$_POST['sr_status']; $query .= " order by ENG_POWER, ENG_NAME"; if (empty($_POST['sr_all'])) $query .= " limit 100"; $res=null; $wynik = mysql_query($query); if($wynik)while ($r = mysql_fetch_array($wynik)) { $res[]=array( 'id' => $r["ENG_ID"], 'mfc' =>$r["MCF_NAME"], 'engName' =>$r["ENG_NAME"], 'engPower' =>str_replace(".", ",", $r["ENG_POWER"]), 'engVoltage'=>str_replace(".", ",", $r["ENG_VOLTAGE"]) ); } unset($_SESSION['site204_array']); $_SESSION['site204_array']=$res; } $start=($_GET['pgn']-1)*20; $stop = $_GET['pgn']*20; if ($stop>count($_SESSION['site204_array'])) $stop=count($_SESSION['site204_array']); for($i=$start;$i<$stop;$i++) { echo" "; } ?>
Lp.
".($i+1).". ".$_SESSION['site204_array'][$i]['engName']." ".$_SESSION['site204_array'][$i]['engVoltage']." ".$_SESSION['site204_array'][$i]['engPower']." ".$_SESSION['site204_array'][$i]['mfc']."
Wyników: 20) echo pagination_grid('?pg=site204', $_GET['pgn'], count($_SESSION['site204_array'])); ?>    
"; ?>