0) { $filter .= ' and D.building_id=?'; $params[]=$f_building_id; } if ($f_devtype_id >= 0) { $filter .= ' and D.device_type=?'; $params[]=$f_devtype_id; } else { $filter .= ' and D.device_type> ?'; $params[]=2; } if ($f_devmodel_id > 0) { $filter .= ' and D.device_model_id=?'; $params[]= $f_devmodel_id; } if ($rou > 0) { $filter .= ' and L.ou_id=? '; $params[]=$rou; } if ($rsubnet > 0) { $subnet_range = get_subnet_range($db_link,$rsubnet); if (!empty($subnet_range)) { $filter .= " and A.ip_int>=? and A.ip_int<=?"; $params[]=$subnet_range['start']; $params[]=$subnet_range['stop']; } } unset($_POST); print_device_submenu($page_url); ?>