0 && $_POST['subEngineSave']==$lab_ButtonName_Save) { mysql_query("INSERT INTO seg_dev_resources SET DRS_DEV_ID=".$_POST['inEngineID'].",DRS_DEV_TYPE=(select DIC_ID from sys_dictionaries where DIC_TYPE='DRS_DEV_TYPE' and DIC_NAME='ENGINE'),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_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['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); unset($_SESSION['site304_print_array']); } ?>
0 and DRS_DEPARTMENT = '".$_SESSION['syndis_eq_stock']."' and DRS_STATUS_DIC_ID in (6,7,8) group by ENG_ID,ENG_NAME,MCF_NAME order by ENG_NAME"); if (empty($_SESSION['site304_print_array'])) { $res=null; $wynik = mysql_query("select DRS_SN_NUMBER,DRS_RESOURCES_DIC_ID,ENG_NAME,ENG_VOLTAGE,ENG_POWER,(select WLL_NAME from seg_wells where WLL_ID=(select RWL_WLL_ID from seg_well_pump_eng_rel where RWL_ENG_DRS_ID=DRS_ID limit 1)) WLL_NAME from seg_dev_resources left join seg_engines on DRS_DEV_ID=ENG_ID and DRS_DEV_TYPE=11 where ENG_ID>0 and DRS_DEPARTMENT = '".$_SESSION['syndis_eq_stock']."' and DRS_STATUS_DIC_ID in (6,7,8,30) order by ENG_NAME,ENG_POWER"); if($wynik)while ($r = mysql_fetch_array($wynik)) { $res[]=array( 'ENG_NAME' => $r["ENG_NAME"], 'DRS_SN_NUMBER' => $r["DRS_SN_NUMBER"], 'STATUS' => setDicName($r["DRS_RESOURCES_DIC_ID"]), 'ENG_VOLTAGE' => $r["ENG_VOLTAGE"], 'ENG_POWER' => $r["ENG_POWER"], 'WLL_NAME' => $r["WLL_NAME"], 'DRS_DEPARTMENT' => $_SESSION['syndis_eq_stock'] ); } unset($_SESSION['site304_print_array']); $_SESSION['site304_print_array']=$res; } if (isset($_GET['eng']) && $_GET['eng']>0) $eng_array = sqlGetResAsArray("select DRS_ID,DRS_SN_NUMBER,DRS_STATUS_DIC_ID,DRS_RESOURCES_DIC_ID,ENG_ID,ENG_NAME,ENG_VOLTAGE,ENG_POWER,(select WLL_NAME from seg_wells where WLL_ID=(select RWL_WLL_ID from seg_well_pump_eng_rel where RWL_ENG_DRS_ID=DRS_ID limit 1)) WLL_NAME from seg_dev_resources left join seg_engines on DRS_DEV_ID=ENG_ID and DRS_DEV_TYPE=11 where DRS_DEPARTMENT = '".$_SESSION['syndis_eq_stock']."' and DRS_STATUS_DIC_ID in (6,7,8,30) and ENG_ID=".$_GET['eng']); //select DRS_ID,DRS_SN_NUMBER,DRS_STATUS_DIC_ID,DRS_RESOURCES_DIC_ID,PUP_ID,PUP_NAME,PUP_Q_N,PUP_H_P,(select WLL_NAME from seg_wells where WLL_ID=(select RWL_WLL_ID from seg_well_pump_eng_rel where RWL_ENG_DRS_ID=DRS_ID limit 1)) WLL_NAME from seg_dev_resources left join seg_engines on DRS_DEV_ID=ENG_ID and DRS_DEV_TYPE=11 where DRS_DEPARTMENT = '".$_SESSION['syndis_eq_stock']."' and DRS_STATUS_DIC_ID in (6,7,8,30) and ENG_ID=".$_GET['eng']) for($i=0; $i "; if (isset($_GET['eng']) && $_GET['eng']>0 && count($eng_array)>0 && $_GET['eng']==$_SESSION['site304_array'][$i]['ENG_ID']) { echo" "; } } ?>
Dostępne [szt.] Użytkowane [szt.] W remoncie [szt.] Ilość razem [szt.]
".$_SESSION['site304_array'][$i]['ENG_NAME']." ".$_SESSION['site304_array'][$i]['MCF_NAME']." ".$dostepne." ".$uzytkowa." ".$remont." ".$_SESSION['site304_array'][$i]['ILOSC']."
"; for ($j=0; $j "; } echo"
Lp. ".$lab_Field_site204_001." ".$lab_Field_site303_001." ".$lab_Field_site204_002." ".$lab_Field_site204_003." ".$lab_Field_site203_022." ".$lab_Field_site303_004."
".($j+1)." ".$eng_array[$j]['ENG_NAME']." ".$eng_array[$j]['DRS_SN_NUMBER']." ".$eng_array[$j]['ENG_VOLTAGE']." ".$eng_array[$j]['ENG_POWER']." ".$eng_array[$j]['WLL_NAME']." ".setDicName($eng_array[$j]['DRS_STATUS_DIC_ID'])."
Wyników:    
"; ?>