116 lines
4.0 KiB
PHP
116 lines
4.0 KiB
PHP
<?php
|
|
if (!empty($_SESSION['site405']))
|
|
{
|
|
?>
|
|
|
|
<?php
|
|
// dodawanie nowego ujęcia
|
|
if ($_POST['subWISave']==$lab_ButtonName_Save && strlen($_POST['inName'])>0)
|
|
{
|
|
//mysql_query("INSERT INTO seg_water_intakes SET SWI_NAME='".$_POST['inName']."',SWI_DESC='".$_POST['inDesc']."',SWI_ADDRESS_01='".$_POST['inAddr1']."',SWI_ADDRESS_02='".$_POST['inAddr2']."',SWI_PHONE='".$_POST['inPhone']."',SWI_MAIL='".$_POST['inMail']."',SWI_LATITUDE='".str_replace(",",".",$_POST['inWellLat'])."',SWI_LONGITUDE='".str_replace(",",".",$_POST['inWellLong'])."',SWI_AUDIT_CU='".$_SESSION['user']."',SWI_AUDIT_CD=now()");
|
|
mysql_query("INSERT INTO seg_water_intakes SET SWI_NAME='".$_POST['inName']."',SWI_DESC='".$_POST['inDesc']."',SWI_TYPE='".$_POST['inType']."',SWI_LATITUDE='".str_replace(",",".",$_POST['inWellLat'])."',SWI_LONGITUDE='".str_replace(",",".",$_POST['inWellLong'])."',SWI_AUDIT_CU='".$_SESSION['user']."',SWI_AUDIT_CD=now()");
|
|
echo"<div class='actionOK'>$lab_SaveRecordNotification_001</div>";
|
|
}
|
|
?>
|
|
|
|
|
|
|
|
<?php
|
|
//paginacja
|
|
if (!$_GET['pgn']) {$_GET['pgn']=1; delSearchSessionData(); }
|
|
?>
|
|
|
|
|
|
|
|
|
|
<div class="tag100">
|
|
<div class="head_tag"><?php echo $lab_Tag_site405_001 ;?></div>
|
|
<div class="tag">
|
|
<table WIDTH="100%" class="tag">
|
|
<TR>
|
|
<TD class="label">Lp.</TD>
|
|
<TD class="label"><?php echo $lab_Field_site405_001 ;?></TD>
|
|
<TD class="label"><?php echo $lab_Tag_site302_003 ;?></TD>
|
|
<TD class="label"><?php echo $lab_Field_site206_003 ;?></TD>
|
|
</TR>
|
|
|
|
<?php
|
|
if (empty($_SESSION['site405_array']))
|
|
{
|
|
$res=null;
|
|
$wynik = mysql_query("select SWI_ID,SWI_NAME,DIC_POL_LANG,SWI_DESC,SWI_LATITUDE,SWI_LONGITUDE from seg_water_intakes left join sys_dictionaries on SWI_TYPE=DIC_ID order by SWI_NAME");
|
|
if($wynik)while ($r = mysql_fetch_array($wynik))
|
|
{
|
|
$res[]=array(
|
|
'wiID' => $r["SWI_ID"],
|
|
'wiName' => $r["SWI_NAME"],
|
|
'wiTyp' => $r["DIC_POL_LANG"],
|
|
'wiDesc' => $r["SWI_DESC"],
|
|
'wiLat' => $r["SWI_LATITUDE"],
|
|
'wiLong' => $r["SWI_LONGITUDE"],
|
|
);
|
|
}
|
|
unset($_SESSION['site405_array']);
|
|
$_SESSION['site405_array']=$res;
|
|
}
|
|
|
|
$start=($_GET['pgn']-1)*20;
|
|
$stop = $_GET['pgn']*20;
|
|
if ($stop>count($_SESSION['site405_array'])) $stop=count($_SESSION['site405_array']);
|
|
|
|
for($i=$start;$i<$stop;$i++)
|
|
{
|
|
echo"
|
|
<TR STYLE='cursor: pointer;' onclick=".chr(34)."document.location.href='?pg=site405inf&wi=".$_SESSION['site405_array'][$i]['wiID']."'".chr(34).">
|
|
<TD class='field_left'>".($i+1).".</TD>
|
|
<TD class='field_left'>".$_SESSION['site405_array'][$i]['wiName']."</TD>
|
|
<TD class='field_left'>".$_SESSION['site405_array'][$i]['wiTyp']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site405_array'][$i]['wiDesc']."</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['site405_array']); ?></span></td>
|
|
<td style="width: 50%; text-align: center;">
|
|
<?php
|
|
if (count($_SESSION['site405_array'])>20)
|
|
echo pagination_grid('?pg=site405', $_GET['pgn'], count($_SESSION['site405_array']));
|
|
?>
|
|
</td>
|
|
<td style="width: 25%; text-align: right;">
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
|
|
|
|
|
|
|
|
</div>
|
|
|
|
<?php
|
|
if (!empty($_SESSION['site405_edit']))
|
|
echo"
|
|
<div class=tag_buttons>
|
|
<a href='?pg=site405A'> <INPUT class='btn btn-success btn-sm' TYPE='BUTTON' VALUE='$lab_ButtonName_Add'></A>
|
|
</div>
|
|
";
|
|
?>
|
|
|
|
</div>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<?php
|
|
}
|
|
else showFooterWarningAccessNotification($lab_FooterWarningAccessNotification_001);
|
|
?>
|