0)
{
unset($pup_array);
//$pup_array = sqlGetResAsArray("select * from seg_dev_resources,seg_pumps where DRS_DEV_TYPE=10 and DRS_DEV_ID=PUP_ID and DRS_ID in (select DRS_ID from seg_dev_resources,seg_pumps where DRS_DEV_TYPE=10 and DRS_DEV_ID=PUP_ID and DRS_DEPARTMENT='".$_SESSION['syndis_eq_stock']."' and PUP_ID=".$_GET['pup']." and (DRS_RESOURCES_DIC_ID in (1,2,3,707) or (DRS_RESOURCES_DIC_ID=40 and DRS_DEV_ATTENTION='1524')) union select RWS_PUP_DRS_ID DRS_ID from seg_wellsink_pump_eng_rel,seg_dev_resources left join seg_pumps on DRS_DEV_TYPE=10 and DRS_DEV_ID=PUP_ID where RWS_PUP_DRS_ID=DRS_ID and DRS_DEPARTMENT='".$_SESSION['syndis_eq_stock']."' and PUP_ID=".$_GET['pup'].") order by DRS_SN_NUMBER,PUP_Q_N");
$pup_array = sqlGetResAsArray("select * from seg_pumps,seg_dev_resources where DRS_DEV_TYPE=10 and DRS_DEV_ID=PUP_ID and PUP_ID=".$_GET['pup']." and (DRS_RESOURCES_DIC_ID in (1,2,3,707) or (DRS_RESOURCES_DIC_ID=40 and DRS_DEV_ATTENTION in ('1401','1524'))) and DRS_DEPARTMENT='".$_SESSION['syndis_eq_stock']."' order by PUP_NAME,DRS_SN_NUMBER");
}
// $pup_array = sqlGetResAsArray("select DRS_ID,DRS_SN_NUMBER,DRS_STATUS_DIC_ID,DRS_RESOURCES_DIC_ID,PUP_ID,PUP_NAME,(PUP_Q_N/60) 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_PUP_DRS_ID=DRS_ID limit 1)) WLL_NAME from seg_dev_resources left join seg_pumps on DRS_DEV_ID=PUP_ID and DRS_DEV_TYPE=10 where DRS_DEPARTMENT = '".$_SESSION['syndis_eq_stock']."' and DRS_STATUS_DIC_ID in (6,7,8,30) and PUP_ID=".$_GET['pup']);
// $pup_array = sqlGetResAsArray("select DRS_ID,DRS_SN_NUMBER,DRS_STATUS_DIC_ID,DRS_RESOURCES_DIC_ID,PUP_ID,PUP_NAME,(PUP_Q_N/60) 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_PUP_DRS_ID=DRS_ID limit 1)) WLL_NAME from seg_dev_resources left join seg_pumps on DRS_DEV_ID=PUP_ID and DRS_DEV_TYPE=10 where DRS_DEPARTMENT = '".$_SESSION['syndis_eq_stock']."' and PUP_ID=".$_GET['pup']." order by PUP_NAME,DRS_SN_NUMBER");
//$pup_array = sqlGetResAsArray("select DRS_ID,DRS_SN_NUMBER,DRS_STATUS_DIC_ID,DRS_RESOURCES_DIC_ID,PUP_ID,PUP_NAME,(PUP_Q_N/60) 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_PUP_DRS_ID=DRS_ID limit 1)) WLL_NAME from seg_dev_resources left join seg_pumps on DRS_DEV_ID=PUP_ID and DRS_DEV_TYPE=10 where DRS_RESOURCES_DIC_ID in (1,2,3,40,707) and DRS_DEPARTMENT = '".$_SESSION['syndis_eq_stock']."' and PUP_ID=".$_GET['pup']." order by PUP_NAME,DRS_SN_NUMBER");
//print_r($pup_array);
//echo"