<?php session_start();?>
<?php
require_once'./func.php';
require_once("./dbaccess.php");
require_once"./language/".$_SESSION['lang'].".php";

$con = 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");
?>

<?php


// odświerzanie tabeli rep_object_departments
if ($_POST['action']=='refresh_departments')
{
    mysql_query("truncate table rep_object_departments");
    mysql_query("insert into rep_object_departments select distinct DRS_ID,WLL_ID,WLL_NAME,RWL_PUP_DRS_ID,(select PUP_ID from seg_dev_resources left join seg_pumps on PUP_ID=DRS_DEV_ID and DRS_DEV_TYPE=10 where DRS_ID=RWL_PUP_DRS_ID limit 1) PUP_ID,(select PUP_NAME from seg_dev_resources left join seg_pumps on PUP_ID=DRS_DEV_ID and DRS_DEV_TYPE=10 where DRS_ID=RWL_PUP_DRS_ID limit 1) WLE_PUMP_NAME,(select PUP_Q_N from seg_dev_resources left join seg_pumps on PUP_ID=DRS_DEV_ID and DRS_DEV_TYPE=10 where DRS_ID=RWL_PUP_DRS_ID limit 1) WLE_PUMP_Q_N,(select DRS_SN_NUMBER from seg_dev_resources left join seg_pumps on PUP_ID=DRS_DEV_ID and DRS_DEV_TYPE=10 where DRS_ID=RWL_PUP_DRS_ID limit 1) WLE_PUMP_NO,RWL_ENG_DRS_ID,(select ENG_ID from seg_dev_resources left join seg_engines on ENG_ID=DRS_DEV_ID and DRS_DEV_TYPE=11 where DRS_ID=RWL_ENG_DRS_ID limit 1) ENG_ID,(select ENG_NAME from seg_dev_resources left join seg_engines on ENG_ID=DRS_DEV_ID and DRS_DEV_TYPE=11 where DRS_ID=RWL_ENG_DRS_ID limit 1) WLE_ENG_NAME,(select ENG_POWER from seg_dev_resources left join seg_engines on ENG_ID=DRS_DEV_ID and DRS_DEV_TYPE=11 where DRS_ID=RWL_ENG_DRS_ID limit 1) WLE_ENG_POWER,(select DRS_SN_NUMBER from seg_dev_resources left join seg_engines on ENG_ID=DRS_DEV_ID and DRS_DEV_TYPE=11 where DRS_ID=RWL_ENG_DRS_ID limit 1) WLE_ENG_NO,WLL_SYS_TYPE SOD_DESC,DRS_DEPARTMENT SOD_PLC,OHC_UJ SOD_UJ from seg_wells inner join seg_object_hole_cards on WLL_NAME=OHC_NAME left join seg_well_pump_eng_rel on RWL_WLL_ID=WLL_ID left join seg_dev_resources on DRS_DEV_ID=WLL_ID and DRS_DEV_TYPE=12 where DRS_ID IS not null");
}

/*
// odświerzanie tabeli rep_aggregate_departments
if ($_POST['action']=='refresh_aggregates')
{
    mysql_query("truncate table rep_aggregate_departments");
    mysql_query("insert into rep_aggregate_departments select null,PUP_ID,PUP_DRS_ID,PUP_NAME,PUP_SN_NO,PUP_Q_N,PUP_H_P,PUP_DEPARTMENT,ENG_ID,DRS_ID,ENG_NAME,ENG_SN_NO,ENG_VOLTAGE,ENG_POWER,DRS_DEPARTMENT,ECB_TYP,ECB_DLUGOSC,ECB_OZNAK_01,ECB_OZNAK_02 from (select PUP_ID,DRS_ID PUP_DRS_ID,PUP_NAME,DRS_SN_NUMBER PUP_SN_NO,DRS_DEPARTMENT PUP_DEPARTMENT,PUP_Q_N,PUP_H_P,(select TST_ENG_ID from tst_tests where TST_ID=(select max(TST_ID) from tst_tests where TST_PUP_ID=PUP_ID and TST_PUP_SN_NO=DRS_SN_NUMBER)) ENG_ID,(select ENG_NAME from seg_engines where ENG_ID=(select TST_ENG_ID from tst_tests where TST_ID=(select max(TST_ID) from tst_tests where TST_PUP_ID=PUP_ID and TST_PUP_SN_NO=DRS_SN_NUMBER))) ENG_NAME,(select ENG_VOLTAGE from seg_engines where ENG_ID=(select TST_ENG_ID from tst_tests where TST_ID=(select max(TST_ID) from tst_tests where TST_PUP_ID=PUP_ID and TST_PUP_SN_NO=DRS_SN_NUMBER))) ENG_VOLTAGE,(select ENG_POWER from seg_engines where ENG_ID=(select TST_ENG_ID from tst_tests where TST_ID=(select max(TST_ID) from tst_tests where TST_PUP_ID=PUP_ID and TST_PUP_SN_NO=DRS_SN_NUMBER))) ENG_POWER,(select TST_ENG_SN_NO from tst_tests where TST_ID=(select max(TST_ID) from tst_tests where TST_PUP_ID=PUP_ID and TST_PUP_SN_NO=DRS_SN_NUMBER)) ENG_SN_NO from seg_dev_resources left join seg_pumps on PUP_ID=DRS_DEV_ID where DRS_RESOURCES_DIC_ID=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES' and DIC_NAME='RESERVE') and DRS_STATUS_DIC_ID=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_STATUS' and DIC_NAME='AVAILABLE')and DRS_DEV_TYPE=10) tb1 left join seg_dev_resources on DRS_DEV_TYPE=11 and DRS_DEV_ID=tb1.ENG_ID and tb1.ENG_SN_NO=DRS_SN_NUMBER left join seg_engine_cables on ECB_ENG_NAME=ENG_NAME and ECB_ENG_NO=ENG_SN_NO");
}
*/


//dodawanie dynamicznych warto�ci p�l
//zapis dynamicznego formularza
// =====================================================================================================================================
if ($_POST['post_site']=='site401inf' && $_POST['post_action']=='edit_param' && $_POST['post_dev']>0)
{
	if (empty($_POST['post_zas']) || $_POST['post_zas']<0 || $_POST['post_zas']>100) $_POST['post_zas']=100;
	$well_work_status = getLastValueFromDevResourceDetail('WELL_STATUSES','ON_OFF',$_POST['post_dev']);
	if ($well_work_status=='ON') $well_work_status=1;
	else $well_work_status=0;
	
	$dateVal = $_POST['post_date'];
	
	if (sqlStringValue("select WLL_CAT_DIC_ID from seg_dev_resources,seg_wells where WLL_ID=DRS_DEV_ID and DRS_DEV_TYPE=12 and DRS_ID=".$_POST['post_dev'], "WLL_CAT_DIC_ID") == 20)
	{
		$_POST['post_time'] = round(sqlValue("select getWellWorkingTimeInDate(".$_POST['post_dev'].",'".$dateVal."')")/3600,2);
		$_POST['post_v'] = sqlValue("select getWellPumpedWaterInDate(".$_POST['post_dev'].",'".$dateVal."')");
		
		// usuwa nowsze wpisy niż ten dodany przed chwilą
		mysql_query("DELETE FROM rep_his_data_everyday WHERE RHD_DRS_ID=".$_POST['post_dev']." and RHD_DATE>'".$_POST['post_date']."'");
		mysql_query("DELETE FROM seg_dev_resources_det WHERE DRD_RESOURCES_DETAIL in (200,205,210,215,220,225,230,245,401,402,730,270,275,280,290,260,721,265) and DRD_DRS_ID=".$_POST['post_dev']." and DRD_AUDIT_DATE>'".$_POST['post_date']."'");
		
	}
		
		
	// wpisuje do tabeli z danymi historycznymi
	$query_data_everyday = "INSERT INTO rep_his_data_everyday SET RHD_DRS_ID=".getFloatValue($_POST['post_dev']).",RHD_DATE='".$_POST['post_date']."'";
	if (getFloatValue($_POST['post_h0'])>0) $query_data_everyday .= ",RHD_HST0_VAL=".getFloatValue($_POST['post_h0']);
	if (getFloatValue($_POST['post_hs'])>0) $query_data_everyday .= ",RHD_HST_VAL=".getFloatValue($_POST['post_hs']);
	if (getFloatValue($_POST['post_hd'])>0) $query_data_everyday .= ",RHD_HD_VAL=".getFloatValue($_POST['post_hd']);
	if (getFullFloatValue($_POST['post_q'])>0) $query_data_everyday .= ",RHD_Q_VAL=".getFullFloatValue($_POST['post_q'])*60;
	if (getFloatValue($_POST['post_p1'])>0) $query_data_everyday .= ",RHD_P1_VAL=".getFloatValue($_POST['post_p1']);
	if (getFloatValue($_POST['post_p2'])>0) $query_data_everyday .= ",RHD_P2_VAL=".getFloatValue($_POST['post_p2']);
	if (getFloatValue($_POST['post_i'])>0) $query_data_everyday .= ",RHD_I_VAL=".getFloatValue($_POST['post_i']);
	if (getFloatValue($_POST['post_u'])>0) $query_data_everyday .= ",RHD_U_VAL=".getFloatValue($_POST['post_u']);
	if (getFloatValue($_POST['post_pe'])>0) $query_data_everyday .= ",RHD_PE_VAL=".getFloatValue($_POST['post_pe']);
	if (getFloatValue($_POST['post_fi'])>0) $query_data_everyday .= ",RHD_COS_VAL=".getFloatValue($_POST['post_fi']);
	if (getFloatValue($_POST['post_pp'])>0) $query_data_everyday .= ",RHD_PP_VAL=".getFloatValue($_POST['post_pp']);
	if (getFloatValue($_POST['post_hh'])>0) $query_data_everyday .= ",RHD_HH_VAL=".getFloatValue($_POST['post_hh']);
	if (getFloatValue($_POST['post_v'])>0) $query_data_everyday .= ",RHD_VM3_VAL=".getFloatValue($_POST['post_v']);
	if (getFloatValue($_POST['post_tw'])>0) $query_data_everyday .= ",RHD_WTEMP_VAL=".getFloatValue($_POST['post_tw']);
	if (getFloatValue($_POST['post_time'])>0) $query_data_everyday .= ",RHD_WORK_TIME_VAL=".getFloatValue($_POST['post_time']);
	$query_data_everyday .= ",RHD_AUDIT_CD=now()";
	
	mysql_query($query_data_everyday);	

	// jeśli studnia jest OPT lub BASE wpisuje jeszcze raz, żeby nie zaktualizować ostatnio wpisanego rekordu
	if (sqlStringValue("select WLL_CAT_DIC_ID from seg_dev_resources,seg_wells where WLL_ID=DRS_DEV_ID and DRS_DEV_TYPE=12 and DRS_ID=".$_POST['post_dev'], "WLL_CAT_DIC_ID") < 20)
	{
		mysql_query($query_data_everyday);
	}
	

	// Q
	if (getFullFloatValue($_POST['post_q'])>0)
		mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['post_dev'].",DRD_RESOURCES_DETAIL=200,DRD_VALUE='".(getFullFloatValue($_POST['post_q'])*60)."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['post_date']."'");
	// HD
	if (getFloatValue($_POST['post_hd'])>0)	
		mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['post_dev'].",DRD_RESOURCES_DETAIL=205,DRD_VALUE='".getFloatValue($_POST['post_hd'])."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['post_date']."'");
	// HST
	if (getFloatValue($_POST['post_hs'])>0)	
		mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['post_dev'].",DRD_RESOURCES_DETAIL=210,DRD_VALUE='".getFloatValue($_POST['post_hs'])."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['post_date']."'");
	// HST0
	if (getFloatValue($_POST['post_h0'])>0)	
		mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['post_dev'].",DRD_RESOURCES_DETAIL=212,DRD_VALUE='".getFloatValue($_POST['post_h0'])."',DRD_EXPORT_SEGAP='0',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['post_date']."'");
	// P1
	if (getFloatValue($_POST['post_p1'])>0)	
		mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['post_dev'].",DRD_RESOURCES_DETAIL=215,DRD_VALUE='".getFloatValue($_POST['post_p1'])."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['post_date']."'");
	// P2
	if (getFloatValue($_POST['post_p2'])>0)	
		mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['post_dev'].",DRD_RESOURCES_DETAIL=220,DRD_VALUE='".getFloatValue($_POST['post_p2'])."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['post_date']."'");
	// Pb
	if (getFloatValue($_POST['post_pb'])>0)	
		mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['post_dev'].",DRD_RESOURCES_DETAIL=225,DRD_VALUE='".getFloatValue($_POST['post_pb'])."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['post_date']."'");
	// Ilość wypompowanej wody
	if (getFloatValue($_POST['post_v'])>0)	
		mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['post_dev'].",DRD_RESOURCES_DETAIL=230,DRD_VALUE='".getFloatValue($_POST['post_v'])."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['post_date']."'");
	// Temperatura wody
	if (getFloatValue($_POST['post_tw'])>0)	
		mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['post_dev'].",DRD_RESOURCES_DETAIL=245,DRD_VALUE='".getFloatValue($_POST['post_tw'])."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['post_date']."'");
	// pp
	if (getFloatValue($_POST['post_pp'])>0)	
		mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['post_dev'].",DRD_RESOURCES_DETAIL=401,DRD_VALUE='".getFloatValue($_POST['post_pp'])."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['post_date']."'");
	// hh
	if (getFloatValue($_POST['post_hh'])>0)	
		mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['post_dev'].",DRD_RESOURCES_DETAIL=402,DRD_VALUE='".getFloatValue($_POST['post_hh'])."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['post_date']."'");
	// Zamknięcie zasuwy
	if (getFloatValue($_POST['post_zas'])>0)	
		mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['post_dev'].",DRD_RESOURCES_DETAIL=730,DRD_VALUE='".getFloatValue($_POST['post_zas'])."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['post_date']."'");
	
	
	// Prąd
	if (getFloatValue($_POST['post_i'])>0)	
		mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['post_dev'].",DRD_RESOURCES_DETAIL=270,DRD_VALUE='".getFloatValue($_POST['post_i'])."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['post_date']."'");
	// Napięcie
	if (getFloatValue($_POST['post_u'])>0)	
		mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['post_dev'].",DRD_RESOURCES_DETAIL=275,DRD_VALUE='".getFloatValue($_POST['post_u'])."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['post_date']."'");
	// Cosinus Fi
	if (getFloatValue($_POST['post_fi'])>0)	
		mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['post_dev'].",DRD_RESOURCES_DETAIL=280,DRD_VALUE='".getFloatValue($_POST['post_fi'])."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['post_date']."'");
	// Czas pracy agregatu
	if (getFloatValue($_POST['post_time'])>0)	
		mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['post_dev'].",DRD_RESOURCES_DETAIL=290,DRD_VALUE='".getFloatValue($_POST['post_time'])."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['post_date']."'");
	// Moc czynna
	if (getFloatValue($_POST['post_pe'])>0)	
		mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['post_dev'].",DRD_RESOURCES_DETAIL=260,DRD_VALUE='".getFloatValue($_POST['post_pe'])."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['post_date']."'");
	// Jednostkowe zużycie energii
	if (getFloatValue($_POST['post_en'])>0)	
		mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['post_dev'].",DRD_RESOURCES_DETAIL=721,DRD_VALUE='".getFloatValue($_POST['post_en'])."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['post_date']."'");
	// Pobór energii
	if (getFloatValue($_POST['post_kwc'])>0)	
		mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['post_dev'].",DRD_RESOURCES_DETAIL=265,DRD_VALUE='".getFloatValue($_POST['post_kwc'])."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['post_date']."'");
	
}


// zmienie przypisanie danego obiektu do oddziału
if ($_POST['post_site']=='site807objdep' && $_POST['post_action']=='change_dep' && $_POST['post_dev']>0)
{
	mysql_query("UPDATE seg_dev_resources SET DRS_DEPARTMENT='".$_POST['post_dep']."' WHERE DRS_ID=".$_POST['post_dev']);
	
}


// walidacja na dodawanie nowej studni: sprawdza, czy obiekt istenieje e studniach lub piezometrach
if ($_POST['post_site']=='site301A' && $_POST['post_action']=='create_new_well' && strlen($_POST['post_well_name'])>0)
{
	if (sqlValue("select count(1) from seg_wells,seg_dev_resources where WLL_ID=DRS_DEV_ID and DRS_DEV_TYPE=12 and WLL_NAME='".$_POST['post_well_name']."'")>0)	
		echo('<script>sweetAlert("Uwaga!", "Studnia '.$_POST['post_well_name'].' istnieje już w systemie. Wejdź w jej edycję lub spróbuj wprowadzić inną nazwę.", "error");</script>');
	elseif (sqlValue("select count(*) from seg_reservoirs_piezometers,seg_dev_resources where SRP_ID=DRS_DEV_ID and DRS_DEV_TYPE=601 and SRP_NAME='".$_POST['post_well_name']."'")>0)
		echo('<script>sweetAlert("Uwaga!", "Obiekt o nazwie '.$_POST['post_well_name'].' jest zarejestrowany jako piezometr. Jeśli chcesz zmienić jego typ musisz przejść do Stan » Stan piezometrów » Przekształć w studnię.", "error");</script>');

}


// walidacja na dodawanie nowego piezometru: sprawdza, czy obiekt istenieje w piezometrach lub studniach
if ($_POST['post_site']=='site309A' && $_POST['post_action']=='create_new_piezo' && strlen($_POST['post_piezo_name'])>0)
{
	if (sqlValue("select count(*) from seg_reservoirs_piezometers,seg_dev_resources where SRP_ID=DRS_DEV_ID and DRS_DEV_TYPE=601 and SRP_NAME='".$_POST['post_piezo_name']."'")>0)
		echo('<script>sweetAlert("Uwaga!", "Piezometr '.$_POST['post_well_name'].' istnieje już w systemie. Wejdź w jego edycję lub spróbuj wprowadzić inną nazwę.", "error");</script>');
	elseif (sqlValue("select count(1) from seg_wells,seg_dev_resources where WLL_ID=DRS_DEV_ID and DRS_DEV_TYPE=12 and WLL_NAME='".$_POST['post_piezo_name']."'")>0)
		echo('<script>sweetAlert("Uwaga!", "Obiekt o nazwie '.$_POST['post_piezo_name'].' jest zarejestrowany jako studnia. Jeśli chcesz zmienić jego typ musisz przejść do Stan » Stan studni » Przekształć w piezometr.", "error");</script>');
		
}


// usuwanie parametrów hemicznych
// Ładowanie danych
// ==============================================================================================================================
if ($_POST['page']=='site401CH' && $_POST['post_action']=='show_params' && $_POST['post_dev_id']>0 && $_POST['post_param_id']>0)
{
	unset($listOfParamsArray);
	$listOfParamsArray = sqlGetResAsArray("
						select * from seg_dev_resources_det where DRD_AUDIT_DATE>='".$_POST['post_date_from']." 00:00:00' and DRD_AUDIT_DATE<='".$_POST['post_date_to']." 23:59:59' and DRD_RESOURCES_DETAIL=".$_POST['post_param_id']." and DRD_DRS_ID=".$_POST['post_dev_id']."
						union
						select * from seg_dev_resources_det_his where DRD_AUDIT_DATE>='".$_POST['post_date_from']." 00:00:00' and DRD_AUDIT_DATE<='".$_POST['post_date_to']." 23:59:59' and DRD_RESOURCES_DETAIL=".$_POST['post_param_id']." and DRD_DRS_ID=".$_POST['post_dev_id']."
						order by DRD_AUDIT_DATE desc
						");
	
	echo'
    	<div class="head_tag">'.$lab_HistoricalData_001.'</div>
    	<div class="tag">
			<table WIDTH="100%" class="tag" id="delChemia" >
				<tr>
					<TD class="label">Lp.</TD>
					<TD class="label">'.$lab_Field_site401_003.'</TD>
					<TD class="label">'.$lab_Field_site401_004.'</TD>
					<td class="label"></td>
				<tr>';
	
				for($i=0; $i<count($listOfParamsArray); $i++)
				{
					echo'
    					<tr id="'.$listOfParamsArray[$i]['DRD_ID'].'">
    						<TD class="field_left">'.($i+1).'</TD>
							<TD class="field_center">'.$listOfParamsArray[$i]['DRD_AUDIT_DATE'].'</TD>
							<TD class="field_center">'.$listOfParamsArray[$i]['DRD_VALUE'].'</TD>
							<TD class="field_center"><img style="cursor: pointer;" title="Usuń" src="./images/remove_ico.png"></TD>
    					</tr>
    			
    				';
				}
	echo'
			</table>
		</div>
		';
	
	
	echo'
		<script>
			$(document).on("click", "#delChemia tr", function (e) {
				e.stopPropagation();
		
				if (confirm("Czy chcesz usunąć?"))
				{
			    	$.post("./ajax_func.php",
					    	{
				    			page: "site401CH",
				    			post_action: "del_params",
				    			post_rowid: $(this).closest("tr").attr("id"),
				    			post_dev_id: "'.$_POST['post_dev_id'].'",
				    			post_param_id: "'.$_POST['post_param_id'].'",
				    			post_date_from: "'.$_POST['post_date_from'].'",
				    			post_date_to: "'.$_POST['post_date_to'].'",
						    }
				    ).done(function(data)
				       		{
				        		$("#tagShowHistData").html(data);
				       		}
			    	);
					return true;
				}
				else
				{
					return false;
				}
			});
		</script>
		';	
}
// usuwanie parametrów hemicznych
// Ładowanie danych
// ==============================================================================================================================
if ($_POST['page']=='site401CH' && $_POST['post_action']=='del_params' && $_POST['post_dev_id']>0 && $_POST['post_param_id']>0 && $_POST['post_rowid']>0)
{
	mysql_query("DELETE FROM seg_dev_resources_det WHERE DRD_ID=".$_POST['post_rowid']);
	mysql_query("DELETE FROM seg_dev_resources_det_his WHERE DRD_ID=".$_POST['post_rowid']);
	
	unset($listOfParamsArray);
	$listOfParamsArray = sqlGetResAsArray("
						select * from seg_dev_resources_det where DRD_AUDIT_DATE>='".$_POST['post_date_from']." 00:00:00' and DRD_AUDIT_DATE<='".$_POST['post_date_to']." 23:59:59' and DRD_RESOURCES_DETAIL=".$_POST['post_param_id']." and DRD_DRS_ID=".$_POST['post_dev_id']."
						union
						select * from seg_dev_resources_det_his where DRD_AUDIT_DATE>='".$_POST['post_date_from']." 00:00:00' and DRD_AUDIT_DATE<='".$_POST['post_date_to']." 23:59:59' and DRD_RESOURCES_DETAIL=".$_POST['post_param_id']." and DRD_DRS_ID=".$_POST['post_dev_id']."
						order by DRD_AUDIT_DATE desc
						");

	echo'
    	<div class="head_tag">'.$lab_HistoricalData_001.'</div>
    	<div class="tag">
			<table WIDTH="100%" class="tag" id="delChemia" >
				<tr>
					<TD class="label">Lp.</TD>
					<TD class="label">'.$lab_Field_site401_003.'</TD>
					<TD class="label">'.$lab_Field_site401_004.'</TD>
					<td class="label"></td>
				<tr>';

	for($i=0; $i<count($listOfParamsArray); $i++)
	{
		echo'
    					<tr id="'.$listOfParamsArray[$i]['DRD_ID'].'">
    						<TD class="field_left">'.($i+1).'</TD>
							<TD class="field_center">'.$listOfParamsArray[$i]['DRD_AUDIT_DATE'].'</TD>
							<TD class="field_center">'.$listOfParamsArray[$i]['DRD_VALUE'].'</TD>
							<TD class="field_center"><img style="cursor: pointer;" title="Usuń" src="./images/remove_ico.png"></TD>
    					</tr>
    
    				';
	}
	echo'
			</table>
		</div>
		';
}


?>


<?php
mysql_close($con);
?>