softspm/kopalnia_2014
2
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
kopalnia_2014/ajax_func.php
T
debian 6ed3153f36 Initial commit
2026-09-03 11:24:19 +02:00

316 lines
20 KiB
PHP
Raw Permalink Blame History

<?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);
?>
Reference in New Issue View Git Blame Copy Permalink