0 && $_POST['subPumpSave']==$lab_ButtonName_Save) { if (sqlValue("select count(1) from seg_dev_resources where DRS_DEV_TYPE=10 and DRS_DEV_ID=".$_POST['inPumpID']." and DRS_SN_NUMBER='".$_POST['inPumpSN']."'")==0) { mysql_query("INSERT INTO seg_dev_resources SET DRS_DEV_ID=".$_POST['inPumpID'].",DRS_DEV_TYPE=10,DRS_SN_NUMBER='".$_POST['inPumpSN']."',DRS_BUY_DATE='".$_POST['inPumpBuyDate']."',DRS_AVAILABLE_DATE='".$_POST['inPumpAvDate']."',DRS_STATUS_DIC_ID=".$_POST['inPumpStat'].",DRS_RESOURCES_DIC_ID=".$_POST['inPumpDevRes'].",DRS_DEV_ATTENTION='".$_POST['inPumpAtt']."',DRS_DEPARTMENT = '".$_SESSION['syndis_eq_stock']."',DRS_AUDIT_USR='".$_SESSION['user']."',DRS_AUDIT_DATE=now()"); $maxDRSid = sqlValue("select max(DRS_ID) from seg_dev_resources"); mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=$maxDRSid,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=$maxDRSid"); echo"
$lab_Field_site803_013
"; unset($maxDRSid); delSearchSessionData(); } else { echo"
$lab_SaveRecordNotification_004
"; delSearchSessionData(); } } //usuwanie // ================================================================================== if (!empty($_GET['param'])) { $tpmArray=explode(',', $_GET['param']); if ($tpmArray[0]>0 && $tpmArray[1]=='del' && $tpmArray[2]==md5($tpmArray[0])) { // Sprawdza warunek, czy nie jest powiązany z jakimś stanem if (sqlValue("select count(*) from seg_well_pump_eng_rel where RWL_PUP_DRS_ID=".$tpmArray[0])>0) { echo"
$lab_DeleteRecordNotification_003
"; delSearchSessionData(); } else { mysql_query("DELETE FROM seg_dev_resources WHERE DRS_ID=".$tpmArray[0]); echo"
$lab_DeleteRecordNotification_001
"; delSearchSessionData(); } } } // ================================================================================== ?>
Typ pompy: producent:
 
"; else echo" "; echo $lab_HistoricalData_007; ?>
0 and DRS_DEPARTMENT = '".$_SESSION['syndis_eq_stock']."' and DRS_STATUS_DIC_ID in (6,7,8)"; $query = "select PUP_ID,count(PUP_ID) ILOSC,PUP_NAME,MCF_NAME from seg_dev_resources left join seg_pumps on DRS_DEV_ID=PUP_ID and DRS_DEV_TYPE=10 left join seg_manufacturers on PUP_MCF_ID=MCF_ID where PUP_NAME like '%".$_POST['sr_well']."%' and PUP_ID>0 and DRS_DEPARTMENT = '".$_SESSION['syndis_eq_stock']."'"; if($_POST['sr_status']!=100) $query.=" and MCF_ID=".$_POST['sr_status']; $query .= " group by PUP_ID,PUP_NAME,MCF_NAME order by PUP_NAME,PUP_Q_N"; if (empty($_POST['sr_all'])) $query .= " limit 100"; $res=null; $wynik = mysql_query($query); if($wynik)while ($r = mysql_fetch_array($wynik)) { //NOWE+ REZERWA+ EKSPLOATACJA+ REMONT+ KASACJA unset($arrayStatuses); // $arrayStatuses = sqlGetResAsArray("select DRS_STATUS_DIC_ID, count(DRS_STATUS_DIC_ID) ILE from seg_dev_resources,seg_pumps where DRS_DEV_TYPE=10 and PUP_ID=DRS_DEV_ID and DRS_STATUS_DIC_ID in (6,7,8) and DRS_DEPARTMENT='".$_SESSION['syndis_eq_stock']."' and PUP_ID=".$r["PUP_ID"]." group by DRS_STATUS_DIC_ID"); $arrayStatuses = sqlGetResAsArray("select DRS_STATUS_DIC_ID, count(DRS_STATUS_DIC_ID) ILE from seg_dev_resources,seg_pumps where DRS_DEV_TYPE=10 and PUP_ID=DRS_DEV_ID and DRS_DEPARTMENT='".$_SESSION['syndis_eq_stock']."' and PUP_ID=".$r["PUP_ID"]." group by DRS_STATUS_DIC_ID"); $dostepne=0; $uzytkowa=0; $remont=0; $nieuzytk=0; for ($s=0; $s $r["PUP_ID"], 'mfc' => $r["MCF_NAME"], 'pumpName' => $r["PUP_NAME"], 'pumpcount' => $r["ILOSC"], 'dostepne' => $dostepne, 'uzytkowa' => $uzytkowa, 'remont' => $remont, 'ndostpne' => $niedostepne, 'notused' => $nieuzytk ); } unset($_SESSION['site303_array']); $_SESSION['site303_array']=$res; } //print_r($_SESSION['site303_array']); //echo"


"; $start=($_GET['pgn']-1)*20; $stop = $_GET['pgn']*20; if ($stop>count($_SESSION['site303_array'])) $stop=count($_SESSION['site303_array']); for($i=$start;$i<$stop;$i++) { echo" "; } ?>
Lp. Dostępne [szt.] Użytkowane [szt.] W remoncie [szt.] Niedostępne [szt.] Nieużytkowane [szt.] Ilość razem [szt.]
".($i+1).". ".$_SESSION['site303_array'][$i]['pumpName']." ".$_SESSION['site303_array'][$i]['mfc']." ".$_SESSION['site303_array'][$i]['dostepne']." ".$_SESSION['site303_array'][$i]['uzytkowa']." ".$_SESSION['site303_array'][$i]['remont']." ".$_SESSION['site303_array'][$i]['ndostpne']." ".$_SESSION['site303_array'][$i]['notused']." ".$_SESSION['site303_array'][$i]['pumpcount']."
Wyników: 20) echo pagination_grid('?pg=site303', $_GET['pgn'], count($_SESSION['site303_array'])); ?>    
"; ?>