106 lines
2.7 KiB
PHP
106 lines
2.7 KiB
PHP
<!DOCTYPE html>
|
|
<html lang="pl">
|
|
<head>
|
|
<meta charset="utf-8">
|
|
<meta http-equiv="X-UA-Compatible" content="IE=edge">
|
|
<meta name="viewport" content="width=device-width, initial-scale=1">
|
|
<link rel="shortcut icon" href="./images/SoftSPM.ico">
|
|
<!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
|
|
<title>Update time and water</title>
|
|
|
|
<!-- Bootstrap -->
|
|
<link href="./reports/bootstrap.min.css" rel="stylesheet">
|
|
|
|
|
|
|
|
</head>
|
|
<body>
|
|
<?php
|
|
|
|
date_default_timezone_set('Europe/Warsaw');
|
|
require_once("./func.php");
|
|
require_once("./dbaccess.php");
|
|
|
|
$polacz = mysql_connect($db_host, $db_user, $db_user_pass) or die ('cannot connect to db');
|
|
mysql_select_db($db_name);
|
|
mysql_query("SET NAMES utf8");
|
|
mysql_query("SET CHARACTER_SET utf8_general_ci");
|
|
|
|
?>
|
|
|
|
<h1>Usuwanie podejżanych wpisów do tabeli załączeń</h1>
|
|
|
|
<h2>Czyszczenie sąsiadujących ON/OFF - seg_dev_resources_det</h2>
|
|
<?php
|
|
|
|
unset($tbArray);
|
|
$tbArray = sqlGetResAsArray("select * from (select * from seg_dev_resources_det where DRD_RESOURCES_DETAIL=507 union select * from seg_dev_resources_det_his where DRD_RESOURCES_DETAIL=507) tb order by DRD_DRS_ID,DRD_AUDIT_DATE");
|
|
$studnia=0;
|
|
$onoff_status="";
|
|
for ($i=0; $i<count($tbArray); $i++)
|
|
{
|
|
if ($studnia!=$tbArray[$i]['DRD_DRS_ID'])
|
|
{
|
|
$studnia=$tbArray[$i]['DRD_DRS_ID'];
|
|
}
|
|
|
|
//echo "Studnia: ".$tbArray[$i]['DRD_DRS_ID'].", status: ".$tbArray[$i]['DRD_VALUE']."<br/>";
|
|
|
|
$poprzedni = $i-1;
|
|
if ($tbArray[$i]['DRD_VALUE']==$tbArray[$poprzedni]['DRD_VALUE'] && $studnia==$tbArray[$poprzedni]['DRD_DRS_ID'])
|
|
{
|
|
echo "Do usunięcia: ".$tbArray[$i]['DRD_ID']."<br/><br/>";
|
|
mysql_query("DELETE FROM seg_dev_resources_det WHERE DRD_ID=".$tbArray[$i]['DRD_ID']);
|
|
mysql_query("DELETE FROM seg_dev_resources_det_his WHERE DRD_ID=".$tbArray[$i]['DRD_ID']);
|
|
}
|
|
}
|
|
|
|
|
|
?>
|
|
|
|
|
|
|
|
|
|
|
|
<h2>Czyszczenie nipotrzebnych ON/OFF oraz załączeń/wyłączeń - seg_wells_manual_work_syndis</h2>
|
|
<?php
|
|
|
|
|
|
unset($tbArray);
|
|
$tbArray = sqlGetResAsArray("select * from seg_wells_manual_work_syndis order by SLA_DRS_ID,SLA_DATETIME");
|
|
$studnia=0;
|
|
$onoff_status="";
|
|
|
|
for ($i=0; $i<count($tbArray); $i++)
|
|
{
|
|
if ($studnia!=$tbArray[$i]['SLA_DRS_ID'])
|
|
{
|
|
$studnia=$tbArray[$i]['SLA_DRS_ID'];
|
|
}
|
|
|
|
$poprzedni = $i-1;
|
|
if ($tbArray[$i]['SLA_WORK_STATUS']==$tbArray[$poprzedni]['SLA_WORK_STATUS'] && $studnia==$tbArray[$poprzedni]['SLA_DRS_ID'])
|
|
{
|
|
echo "Do usunięcia: ".$tbArray[$i]['SLA_ID']."<br/><br/>";
|
|
mysql_query("DELETE FROM seg_wells_manual_work_syndis WHERE SLA_ID=".$tbArray[$i]['SLA_ID']);
|
|
//mysql_query("UPDATE rep_his_data_everyday SET RHD_SPM_WT=NULL,RHD_SPM_PW=NULL WHERE RHD_DRS_ID=".$tbArray[$i]['SLA_DRS_ID']);
|
|
}
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
?>
|
|
|
|
|
|
|
|
|
|
<?php
|
|
mysql_close($polacz);
|
|
|
|
?>
|
|
</body>
|
|
</html>
|