0 )
{
$checkIsExists = sqlGetResAsArray("select * from seg_pumps where PUP_NAME='".$_POST['inPumpName']."'");
if (count($checkIsExists)>0)
{
echo"Typ pompy ".$_POST['inPumpName']." istnieje już w systemie
";
}
else
{
$in_q_ZERO = 0;
$in_q_xm = 0.25*(getFloatValue($_POST['inPumpQn'])*60);
$in_q_min = 0.55*(getFloatValue($_POST['inPumpQn'])*60);
$in_q_1 = 0.7*(getFloatValue($_POST['inPumpQn'])*60);
$in_q_2 = 1.22*(getFloatValue($_POST['inPumpQn'])*60);
$in_q_max = 1.35*(getFloatValue($_POST['inPumpQn'])*60);
$in_q_xl = 1.42*(getFloatValue($_POST['inPumpQn'])*60);
$query_tmp = "INSERT INTO seg_pumps SET PUP_MCF_ID=".$_POST['inPumpManufName'].",PUP_NAME='".$_POST['inPumpName']."',PUP_Q_N=".(getFloatValue($_POST['inPumpQn'])*60).",PUP_Q_MIN=$in_q_min,PUP_Q_MAX=$in_q_max,PUP_H_P=".getFloatValue($_POST['inPumpHp']).",PUP_ETA_MAX=".getFloatValue($_POST['inPumpEta']);
if (getFloatValue($_POST['inPumpLg'])>0) $query_tmp .= ",PUP_PUMP_LENGTH=".getFloatValue($_POST['inPumpLg']);
if (getFloatValue($_POST['inPumpWeig'])>0) $query_tmp .= ",PUP_WEIGHT=".getFloatValue($_POST['inPumpWeig']);
if (getFloatValue($_POST['inPumpDiam'])>0) $query_tmp .= ",PUP_DIAMETER=".getFloatValue($_POST['inPumpDiam']);
//echo $query_tmp;
mysql_query($query_tmp);
unset($query_tmp);
$newPumpID = sqlValue("select max(PUP_ID) from seg_pumps");
mysql_query("INSERT INTO seg_pump_eng_param SET PEP_PUP_ID=$newPumpID,PEP_X_PARAM=$in_q_ZERO,PEP_TYPE='H';");
mysql_query("INSERT INTO seg_pump_eng_param SET PEP_PUP_ID=$newPumpID,PEP_X_PARAM=$in_q_xm,PEP_TYPE='H';");
mysql_query("INSERT INTO seg_pump_eng_param SET PEP_PUP_ID=$newPumpID,PEP_X_PARAM=$in_q_min,PEP_TYPE='H';");
mysql_query("INSERT INTO seg_pump_eng_param SET PEP_PUP_ID=$newPumpID,PEP_X_PARAM=$in_q_1,PEP_TYPE='H';");
mysql_query("INSERT INTO seg_pump_eng_param SET PEP_PUP_ID=$newPumpID,PEP_X_PARAM=".(getFloatValue($_POST['inPumpQn'])*60).",PEP_Y_PARAM=".getFloatValue($_POST['inPumpHp']).",PEP_TYPE='H';");
mysql_query("INSERT INTO seg_pump_eng_param SET PEP_PUP_ID=$newPumpID,PEP_X_PARAM=$in_q_2,PEP_TYPE='H';");
mysql_query("INSERT INTO seg_pump_eng_param SET PEP_PUP_ID=$newPumpID,PEP_X_PARAM=$in_q_max,PEP_TYPE='H';");
mysql_query("INSERT INTO seg_pump_eng_param SET PEP_PUP_ID=$newPumpID,PEP_X_PARAM=$in_q_xl,PEP_TYPE='H';");
mysql_query("INSERT INTO seg_pump_eng_param SET PEP_PUP_ID=$newPumpID,PEP_X_PARAM=$in_q_ZERO,PEP_Y_PARAM=0,PEP_TYPE='ETA';");
mysql_query("INSERT INTO seg_pump_eng_param SET PEP_PUP_ID=$newPumpID,PEP_X_PARAM=$in_q_xm,PEP_TYPE='ETA';");
mysql_query("INSERT INTO seg_pump_eng_param SET PEP_PUP_ID=$newPumpID,PEP_X_PARAM=$in_q_min,PEP_TYPE='ETA';");
mysql_query("INSERT INTO seg_pump_eng_param SET PEP_PUP_ID=$newPumpID,PEP_X_PARAM=$in_q_1,PEP_TYPE='ETA';");
mysql_query("INSERT INTO seg_pump_eng_param SET PEP_PUP_ID=$newPumpID,PEP_X_PARAM=".(getFloatValue($_POST['inPumpQn'])*60).",PEP_Y_PARAM=".getFloatValue($_POST['inPumpEta']).",PEP_TYPE='ETA';");
mysql_query("INSERT INTO seg_pump_eng_param SET PEP_PUP_ID=$newPumpID,PEP_X_PARAM=$in_q_2,PEP_TYPE='ETA';");
mysql_query("INSERT INTO seg_pump_eng_param SET PEP_PUP_ID=$newPumpID,PEP_X_PARAM=$in_q_max,PEP_TYPE='ETA';");
mysql_query("INSERT INTO seg_pump_eng_param SET PEP_PUP_ID=$newPumpID,PEP_X_PARAM=$in_q_xl,PEP_TYPE='ETA';");
echo"$lab_Field_site803_013
";
}
}
if (!empty($_SESSION['site203_edit']) && $_GET['del']=="OK")
{
mysql_query("delete from seg_pumps where PUP_ID=".$_GET['pup']);
mysql_query("delete from seg_pump_eng_param where PEP_PUP_ID=".$_GET['pup']);
mysql_query("delete from seg_pumps_xy_formula where PUF_PUP_ID=".$_GET['pup']);
echo"$lab_DeleteRecordNotification_001
";
}
if (!$_POST['sr_status']) $_POST['sr_status']=100;
?>
1, 'value'=>$lab_Field_site203_001),
array('id'=>2, 'value'=>$lab_Field_site203_002a),
);
?>
";
?>
