250 lines
11 KiB
PHP
250 lines
11 KiB
PHP
<?php
|
|
if (!empty($_SESSION['site203']))
|
|
{
|
|
?>
|
|
|
|
|
|
<?php
|
|
|
|
if ($_POST['subPumpSave']==$lab_ButtonName_Save && !empty($_POST['inPumpName']) && $_POST['inPumpManufName']>0 )
|
|
{
|
|
|
|
$checkIsExists = sqlGetResAsArray("select * from seg_pumps where PUP_NAME='".$_POST['inPumpName']."'");
|
|
if (count($checkIsExists)>0)
|
|
{
|
|
echo"<div class='actionERROR'>Typ pompy ".$_POST['inPumpName']." istnieje już w systemie</div>";
|
|
|
|
}
|
|
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"<div class='actionOK'>$lab_Field_site803_013</div>";
|
|
|
|
}
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
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"<div class='actionOK'>$lab_DeleteRecordNotification_001</div>";
|
|
}
|
|
|
|
if (!$_POST['sr_status']) $_POST['sr_status']=100;
|
|
?>
|
|
|
|
<?php
|
|
//paginacja
|
|
if (!$_GET['pgn']) {$_GET['pgn']=1; delSearchSessionData(); $_SESSION['site203_sr_param']=1;}
|
|
if ($_POST['sub_search']=='Szukaj') { $_SESSION['site203_input'] = $_POST['sr_well']; $_SESSION['site203_sr_param'] = $_POST['sr_param']; }
|
|
?>
|
|
|
|
|
|
<?php
|
|
$typSelArray = array(
|
|
array('id'=>1, 'value'=>$lab_Field_site203_001),
|
|
array('id'=>2, 'value'=>$lab_Field_site203_002a),
|
|
);
|
|
?>
|
|
|
|
|
|
<form action="./?pg=site203&pgn=1" method="post">
|
|
<div class="tag100">
|
|
<table>
|
|
<tr>
|
|
<td><?php getSelectValueAsArray('sr_param', $typSelArray,$_SESSION['site203_sr_param']); ?></td>
|
|
<td style="width: 10px;"></td>
|
|
<td><input type="text" name="sr_well" value="<?php echo $_SESSION['site203_input'];?>"></td>
|
|
<td style="width: 10px;"></td>
|
|
<td>producent:</td>
|
|
<td style="width: 5px;"></td>
|
|
<td>
|
|
<select name="sr_status">
|
|
<?php
|
|
$wynik = mysql_query("select MCF_ID,MCF_NAME from seg_manufacturers order by MCF_NAME");
|
|
if($wynik)while ($r = mysql_fetch_array($wynik))
|
|
{
|
|
$resID=$r["MCF_ID"];
|
|
$resDESC=$r["MCF_NAME"];
|
|
|
|
if ($_POST['sr_status']==$resID)
|
|
echo"<option value='$resID' selected>$resDESC</option>";
|
|
else
|
|
echo"<option value='$resID'>$resDESC</option>";
|
|
}
|
|
if ($_POST['sr_status']==100)
|
|
echo"<option value='100' selected>Wszyscy</option>";
|
|
else
|
|
echo"<option value='100'>Wszyscy</option>";
|
|
?>
|
|
</select>
|
|
</td>
|
|
<td style="width: 10px;"></td>
|
|
<td><input type="submit" name="sub_search" value="Szukaj" class="btn btn-default btn-sm"></td>
|
|
<td></td>
|
|
</tr>
|
|
<tr><td> </td></tr>
|
|
<tr>
|
|
<td colspan="3">
|
|
<?php
|
|
if (!empty($_POST['sr_all'])) echo"<input type='checkbox' name='sr_all' value='1' checked> ";
|
|
else echo"<input type='checkbox' name='sr_all' value='1'> ";
|
|
|
|
echo $lab_HistoricalData_007;
|
|
?>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</div>
|
|
</form>
|
|
|
|
|
|
<div class="tag100">
|
|
<div class="head_tag"><?php echo $lab_Tag_site203_001 ;?></div>
|
|
<div class="tag">
|
|
<table WIDTH="100%" class="tag">
|
|
<TR>
|
|
<TD class="label">Lp.</TD>
|
|
<TD class="label"><?php echo $lab_Field_site203_001 ;?></TD>
|
|
<TD class="label"><?php echo $lab_Field_site203_002a ;?></TD>
|
|
<TD class="label"><?php echo $lab_Field_site203_003 ;?></TD>
|
|
<TD class="label"><?php echo $lab_Field_site203_004 ;?></TD>
|
|
</TR>
|
|
|
|
<?php
|
|
|
|
if (empty($_SESSION['site203_array']) || $_POST['sub_search']=='Szukaj')
|
|
{
|
|
$query="select PUP_ID,MCF_NAME,PUP_NAME,(PUP_Q_N/60) PUP_Q_N,PUP_H_P from seg_pumps left join seg_manufacturers on PUP_MCF_ID=MCF_ID where ";
|
|
|
|
// wybiera odpowiedni operator
|
|
if ($_SESSION['site203_sr_param']==1) $query .= " PUP_STATUS='1' and PUP_NAME like '%".$_POST['sr_well']."%'";
|
|
elseif ($_SESSION['site203_sr_param']==2) $query .= " PUP_STATUS='1' and (PUP_Q_N/60) >= (".(getFullFloatValue($_POST['sr_well'])-(getFullFloatValue($_POST['sr_well'])*0.1)).") and (PUP_Q_N/60) <= (".(getFullFloatValue($_POST['sr_well'])+(getFullFloatValue($_POST['sr_well'])*0.1)).")";
|
|
|
|
if($_POST['sr_status']!=100) $query.=" and MCF_ID=".$_POST['sr_status'];
|
|
$query .= " and PUP_Q_N>0 order by PUP_Q_N,PUP_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["PUP_ID"],
|
|
'mfc'=>$r["MCF_NAME"],
|
|
'pumpName'=>$r["PUP_NAME"],
|
|
'qN'=>round(getFullFloatValue($r["PUP_Q_N"]),3),
|
|
'hP'=>getFullFloatValue($r["PUP_H_P"])
|
|
);
|
|
}
|
|
unset($_SESSION['site203_array']);
|
|
$_SESSION['site203_array']=$res;
|
|
}
|
|
|
|
|
|
//print_r($_SESSION['site203_array']);
|
|
//echo"<br/><br/><br/>";
|
|
|
|
|
|
$start=($_GET['pgn']-1)*20;
|
|
$stop = $_GET['pgn']*20;
|
|
if ($stop>count($_SESSION['site203_array'])) $stop=count($_SESSION['site203_array']);
|
|
|
|
for($i=$start;$i<$stop;$i++)
|
|
{
|
|
echo"
|
|
<TR STYLE='cursor: pointer;' onclick=".chr(34)."document.location.href='?pg=site203inf&pup=".$_SESSION['site203_array'][$i]['id']."'".chr(34).">
|
|
<TD class='field_left'>".($i+1).".</TD>
|
|
<TD class='field_left'>".$_SESSION['site203_array'][$i]['pumpName']."</TD>
|
|
<TD class='field_right'>".$_SESSION['site203_array'][$i]['qN']."</TD>
|
|
<TD class='field_right'>".$_SESSION['site203_array'][$i]['hP']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site203_array'][$i]['mfc']."</TD>
|
|
</TR>
|
|
";
|
|
}
|
|
?>
|
|
</table>
|
|
|
|
|
|
|
|
<table style="width:100%; background-color: #f5f5f5">
|
|
<tr>
|
|
<td style="width: 25%; text-align: left;"><span class="resume">Wyników: <?php echo count($_SESSION['site203_array']); ?></span></td>
|
|
<td style="width: 50%; text-align: center;">
|
|
<?php
|
|
if (count($_SESSION['site203_array'])>20)
|
|
echo pagination_grid('?pg=site203', $_GET['pgn'], count($_SESSION['site203_array']));
|
|
?>
|
|
</td>
|
|
<td style="width: 25%; text-align: right;">
|
|
<a href="./export/site203_xls.php" target="_blank" title="Export do EXCEL"><img src="./images/excel_ico.png" style="max-width: 20px; border: 0;"></a>
|
|
<a href="./export/site203_print.php" target="_blank" title="Wydruk"><img src="./images/printer-icon.png" style="max-width: 20px; border: 0;"></a>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
</div>
|
|
|
|
<?php
|
|
if (!empty($_SESSION['site203_edit']))
|
|
echo"
|
|
<div class=tag_buttons>
|
|
<a href='?pg=site203A'> <INPUT class='btn btn-success btn-sm' TYPE='BUTTON' VALUE='$lab_ButtonName_Add'></A>
|
|
</div>
|
|
";
|
|
?>
|
|
|
|
</div>
|
|
|
|
<?php
|
|
}
|
|
else showFooterWarningAccessNotification($lab_FooterWarningAccessNotification_001);
|
|
?>
|