0 && $_POST['subEngineSave']==$lab_ButtonName_Save) { if (sqlValue("select count(1) from seg_dev_resources where DRS_DEV_TYPE=11 and DRS_DEV_ID=".$_POST['inEngineID']." and DRS_SN_NUMBER='".$_POST['inEngineSN']."'")==0) { mysql_query("INSERT INTO seg_dev_resources SET DRS_DEV_ID=".$_POST['inEngineID'].",DRS_DEV_TYPE=11,DRS_SN_NUMBER='".$_POST['inEngineSN']."',DRS_BUY_DATE='".$_POST['inEngineBuyDate']."',DRS_AVAILABLE_DATE='".$_POST['inEngineAvDate']."',DRS_STATUS_DIC_ID=".$_POST['inEngineStat'].",DRS_RESOURCES_DIC_ID=".$_POST['inEngineDevRes'].",DRS_DEV_ATTENTION='".$_POST['inEngineAtt']."',DRS_DEPARTMENT = '".$_SESSION['syndis_eq_stock']."',DRS_AUDIT_USR='".$_POST['inEngineVol']."',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['inEngineEST']."',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_005
"; 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_ENG_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 silnika: producent:
 
"; else echo""; ?>
0 and DRS_DEPARTMENT = '".$_SESSION['syndis_eq_stock']."' and DRS_STATUS_DIC_ID in (6,7,8) and ENG_NAME like '%".$_POST['sr_well']."%'"; $query = "select ENG_ID,count(ENG_ID) ILOSC,ENG_NAME,MCF_NAME from seg_dev_resources left join seg_engines on DRS_DEV_ID=ENG_ID and DRS_DEV_TYPE=11 left join seg_manufacturers on ENG_MCF_ID=MCF_ID where ENG_ID>0 and DRS_RESOURCES_DIC_ID in (1,2,3,40,707) and DRS_DEPARTMENT = '".$_SESSION['syndis_eq_stock']."' and ENG_NAME like '%".$_POST['sr_well']."%'"; if($_POST['sr_status']!=100) $query.=" and MCF_ID=".$_POST['sr_status']; $query .= " group by ENG_ID,ENG_NAME,MCF_NAME order by ENG_NAME,ENG_POWER"; if (empty($_POST['sr_all'])) $query .= " limit 100"; $res=null; $wynik = mysql_query($query); if($wynik)while ($r = mysql_fetch_array($wynik)) { unset($arrayStatuses); unset($nowe); unset($rezerwa); unset($remont); unset($eksploat); unset($kasacja); // $arrayStatuses = sqlGetResAsArray("select DRS_STATUS_DIC_ID, count(DRS_STATUS_DIC_ID) ILE from seg_dev_resources,seg_engines where DRS_DEV_TYPE=11 and ENG_ID=DRS_DEV_ID and DRS_STATUS_DIC_ID in (6,7,8) and DRS_DEPARTMENT='".$_SESSION['syndis_eq_stock']."' and ENG_ID=".$r["ENG_ID"]." group by DRS_STATUS_DIC_ID"); $arrayStatuses = sqlGetResAsArray("select DRS_RESOURCES_DIC_ID, count(DRS_RESOURCES_DIC_ID) ILE from seg_dev_resources,seg_engines where DRS_DEV_TYPE=11 and ENG_ID=DRS_DEV_ID and DRS_RESOURCES_DIC_ID in (1,2,3,40,707) and DRS_DEPARTMENT='".$_SESSION['syndis_eq_stock']."' and ENG_ID=".$r["ENG_ID"]." group by DRS_RESOURCES_DIC_ID"); for ($s=0; $s $r["ENG_ID"], 'mfc' => $r["MCF_NAME"], 'engName' => $r["ENG_NAME"], 'engcount' => $r["ILOSC"], 'nowe' => $nowe, 'rezerwa' => $rezerwa, 'remont' => $remont, 'eksploat' => $eksploat, 'kasacja' => $kasacja ); } unset($_SESSION['site304_array']); $_SESSION['site304_array']=$res; } $start=($_GET['pgn']-1)*20; $stop = $_GET['pgn']*20; if ($stop>count($_SESSION['site304_array'])) $stop=count($_SESSION['site304_array']); for($i=$start;$i<$stop;$i++) { echo" "; } ?>
Lp. Nowe [szt.] Rezerwa [szt.] Remont [szt.] W eksploatacji [szt.] Kasacja [szt.] Ilość razem [szt.]
".($i+1).". ".$_SESSION['site304_array'][$i]['engName']." ".$_SESSION['site304_array'][$i]['mfc']." ".$_SESSION['site304_array'][$i]['nowe']." ".$_SESSION['site304_array'][$i]['rezerwa']." ".$_SESSION['site304_array'][$i]['remont']." ".$_SESSION['site304_array'][$i]['eksploat']." ".$_SESSION['site304_array'][$i]['kasacja']." ".$_SESSION['site304_array'][$i]['engcount']."
Wyników: 20) echo pagination_grid('?pg=site304', $_GET['pgn'], count($_SESSION['site304_array'])); ?>    
"; ?>