0 && $_POST['subPumpSave']==$lab_ButtonName_Update) { if (!empty($_POST['inPumpCasDate'])) $casDate = "DRS_CASSATION_DATE='".$_POST['inPumpCasDate']."'"; else $casDate = "DRS_CASSATION_DATE=null"; if (!empty($_POST['inPumpAvDate'])) $avDate = "DRS_AVAILABLE_DATE='".$_POST['inPumpAvDate']."'"; else $avDate = "DRS_AVAILABLE_DATE=null"; if (!empty($_POST['inPumpStat'])) mysql_query("update seg_dev_resources SET ".$casDate.", DRS_SN_NUMBER='".$_POST['inPumpSN']."',DRS_BUY_DATE='".$_POST['inPumpBuyDate']."',".$avDate.",DRS_STATUS_DIC_ID=".$_POST['inPumpStat'].",DRS_RESOURCES_DIC_ID=".$_POST['inPumpDevRes'].",DRS_DEV_ATTENTION='".$_POST['inPumpAtt']."',DRS_AUDIT_USR='".$_SESSION['user']."',DRS_AUDIT_DATE=now() where DRS_ID=".$_GET['dev']); else mysql_query("update seg_dev_resources SET ".$casDate.", DRS_SN_NUMBER='".$_POST['inPumpSN']."',DRS_BUY_DATE='".$_POST['inPumpBuyDate']."',".$avDate.",DRS_RESOURCES_DIC_ID=".$_POST['inPumpDevRes'].",DRS_DEV_ATTENTION='".$_POST['inPumpAtt']."',DRS_AUDIT_USR='".$_SESSION['user']."',DRS_AUDIT_DATE=now() where DRS_ID=".$_GET['dev']); mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_GET['dev'].",DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES_DETAIL' and DIC_NAME='ASSET'),DRD_VALUE='".$_POST['inPumpEST']."',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()"); mysql_query("insert into seg_dev_resources_his select * from seg_dev_resources where DRS_ID=".$_GET['dev']); // Jeśli podano przyczynę kasacji, pompa przechodzi do satusu WYCOFANA if ($_POST['inPumpDevRes']==40 && !empty($_POST['inPumpAtt'])) { mysql_query("UPDATE seg_dev_resources SET DRS_AVAILABLE_DATE=NULL,DRS_STATUS_DIC_ID=9,DRS_RESOURCES_DIC_ID=41,DRS_AUDIT_USR='".$_SESSION['user']."',DRS_AUDIT_DATE=now() where DRS_ID=".$_GET['dev']); } echo"
$lab_UpdateRecordNotification_001
"; } ?>
Uwagi
Opis
Opis
10) $subQuery = " and RHD_DATE<='".$historyArray[$i]['WLE_DATE_TO']."'"; else $subQuery=""; $workingTime=null; //$workingTime = sqlStringValue("select RHD_WORK_TIME_VAL from rep_his_data_everyday where RHD_DATE=(select max(RHD_DATE) from rep_his_data_everyday where RHD_DRS_ID=".$historyArray[$i]['DRS_ID']." and RHD_DATE>='".$historyArray[$i]['WLE_DATE_FROM']."' ".$subQuery.") and RHD_DRS_ID=".$historyArray[$i]['DRS_ID']." limit 1", "RHD_WORK_TIME_VAL"); $workingTime = sqlStringValue("select RHD_WORK_TIME_VAL from rep_his_data_everyday where RHD_ID=(select max(RHD_ID) from rep_his_data_everyday where RHD_DRS_ID=".$historyArray[$i]['DRS_ID']." and RHD_DATE>='".$historyArray[$i]['WLE_DATE_FROM']."' ".$subQuery.")", "RHD_WORK_TIME_VAL"); echo" "; } ?>
Lp. Studnia Typ silnika Nr silnika Data zab. Data wyb. Czas pracy [h] Powód
".(count($historyArray)-$i)." ".$historyArray[$i]['WLL_NAME']." ".$historyArray[$i]['WLE_ENG_NAME']." ".$historyArray[$i]['WLE_ENG_NO']." ".$historyArray[$i]['WLE_DATE_FROM']." ".$historyArray[$i]['WLE_DATE_TO']." ".$workingTime." ".$historyArray[$i]['WLE_REASON']."
> "; ?>