115 lines
4.5 KiB
PHP
115 lines
4.5 KiB
PHP
<?php
|
|
if (!empty($_SESSION['site803']))
|
|
{
|
|
?>
|
|
|
|
|
|
<?php
|
|
if ($_POST['subManufSave']==$lab_ButtonName_Save && strlen($_POST['inManufName'])>2)
|
|
{
|
|
mysql_query("INSERT INTO seg_manufacturers SET MCF_NAME='".$_POST['inManufName']."',MCF_CATEGORY='".$_POST['inManufCat']."',MCF_ADDRESS='".$_POST['inManufAdd']."',MCF_POST='".$_POST['inManufPost']."',MCF_CITY='".$_POST['inManufCity']."',MCF_MAIL='".$_POST['inManufMail']."',MCF_PHONE='".$_POST['inManufPhone']."',MCF_CONT_PERSON='".$_POST['inManufConPers']."',MCF_DESCTRIPTION='".$_POST['inManufDesc']."'");
|
|
echo"<div class='actionOK'>$lab_Field_site803_013</div>";
|
|
}
|
|
|
|
if ($_POST['subManufUpdate']==$lab_ButtonName_Update && strlen($_POST['inManufName'])>2)
|
|
{
|
|
mysql_query("update seg_manufacturers SET MCF_NAME='".$_POST['inManufName']."',MCF_CATEGORY='".$_POST['inManufCat']."',MCF_ADDRESS='".$_POST['inManufAdd']."',MCF_POST='".$_POST['inManufPost']."',MCF_CITY='".$_POST['inManufCity']."',MCF_MAIL='".$_POST['inManufMail']."',MCF_PHONE='".$_POST['inManufPhone']."',MCF_CONT_PERSON='".$_POST['inManufConPers']."',MCF_DESCTRIPTION='".$_POST['inManufDesc']."' where MCF_ID=".$_POST['mf']);
|
|
echo"<div class='actionOK'>$lab_Field_site803_015</div>";
|
|
}
|
|
|
|
|
|
|
|
//usuwanie
|
|
// ==================================================================================
|
|
if (!empty($_GET['param']))
|
|
{
|
|
$tpmArray=explode(',', $_GET['param']);
|
|
|
|
if ($tpmArray[0]>0 && $tpmArray[1]=='del' && $tpmArray[2]==md5($tpmArray[0]))
|
|
{
|
|
// Sprawdza warunek, czy nie jest powiązany z jakimś stanem
|
|
if (
|
|
sqlValue("select count(*) from seg_engines where ENG_MCF_ID=".$tpmArray[0])>0
|
|
|| sqlValue("select count(*) from seg_equipments where EQU_MCF_ID=".$tpmArray[0])>0
|
|
|| sqlValue("select count(*) from seg_pumps where PUP_MCF_ID=".$tpmArray[0])>0
|
|
|| sqlValue("select count(*) from seg_reservoirs_piezometers where SRP_MCF_ID=".$tpmArray[0])>0
|
|
|| sqlValue("select count(*) from seg_wells where WLL_MCF_ID=".$tpmArray[0])>0
|
|
)
|
|
{
|
|
echo"<div class='actionERROR'>$lab_DeleteRecordNotification_003</div>";
|
|
delSearchSessionData();
|
|
}
|
|
else {
|
|
mysql_query("DELETE FROM seg_manufacturers WHERE MCF_ID=".$tpmArray[0]);
|
|
echo"<div class='actionOK'>$lab_DeleteRecordNotification_001</div>";
|
|
delSearchSessionData();
|
|
}
|
|
|
|
}
|
|
}
|
|
// ==================================================================================
|
|
|
|
|
|
|
|
?>
|
|
|
|
|
|
<div class="tag100">
|
|
<div class="head_tag"><?php echo $lab_Tag_site803_001 ;?></div>
|
|
<div class="tag">
|
|
<table WIDTH="100%" class="tag">
|
|
<TR>
|
|
<TD class="label"><?php echo $lab_Field_site803_001 ;?></TD>
|
|
<TD class="label"><?php echo $lab_Field_site803_002 ;?></TD>
|
|
<TD class="label"><?php echo $lab_Field_site803_003 ;?></TD>
|
|
<TD class="label"><?php echo $lab_Field_site803_005 ;?></TD>
|
|
<TD class="label"><?php echo $lab_Field_site803_004 ;?></TD>
|
|
</TR>
|
|
|
|
<?php
|
|
$wynik = mysql_query("select MCF_ID,MCF_NAME,MCF_CATEGORY,MCF_ADDRESS,MCF_POST,MCF_CITY,MCF_PHONE,MCF_MAIL from seg_manufacturers order by MCF_NAME");
|
|
if($wynik)while ($r = mysql_fetch_array($wynik))
|
|
{
|
|
$sql_803_MCF_ID = $r["MCF_ID"];
|
|
$sql_803_MCF_NAME = $r["MCF_NAME"];
|
|
$sql_803_MCF_CATEGORY = $r["MCF_CATEGORY"];
|
|
|
|
$sql_803_MCF_MCF_ADDRESS = $r["MCF_ADDRESS"];
|
|
$sql_803_MCF_MCF_POST = $r["MCF_POST"];
|
|
$sql_803_MCF_MCF_CITY = $r["MCF_CITY"];
|
|
$sql_803_MCF_PHONE = $r["MCF_PHONE"];
|
|
$sql_803_MCF_MAIL = $r["MCF_MAIL"];
|
|
|
|
if (strlen($sql_803_MCF_MCF_POST)>0) $sql_803_MCF_MCF_ADDRESS .= "<br>".$sql_803_MCF_MCF_POST." ".$sql_803_MCF_MCF_CITY;
|
|
|
|
echo"
|
|
<TR STYLE='cursor: pointer;' onclick=".chr(34)."document.location.href='?pg=site803inf&mf=$sql_803_MCF_ID'".chr(34).">
|
|
<TD class='field_left'>$sql_803_MCF_NAME</TD>
|
|
<TD class='field_left'>$sql_803_MCF_CATEGORY</TD>
|
|
<TD class='field_left'>$sql_803_MCF_MCF_ADDRESS</TD>
|
|
<TD class='field_left'>$sql_803_MCF_PHONE</TD>
|
|
<TD class='field_left'>$sql_803_MCF_MAIL</TD>
|
|
</TR>
|
|
";
|
|
}
|
|
?>
|
|
</table>
|
|
</div>
|
|
|
|
<?php
|
|
if (!empty($_SESSION['site803_edit']))
|
|
echo"
|
|
<div class=tag_buttons>
|
|
<a href='?pg=site803A'> <INPUT class='btn btn-success btn-sm' TYPE='BUTTON' VALUE='$lab_ButtonName_Add'></A>
|
|
</div>
|
|
";
|
|
?>
|
|
|
|
</div>
|
|
|
|
|
|
<?php
|
|
}
|
|
else showFooterWarningAccessNotification($lab_FooterWarningAccessNotification_001);
|
|
?>
|