Hi Minesh,
Yes you are correct want to display the posts when Grant status equal to "open" and the custom field "grant-final-closing-date" value is >= than current date.
I created this Grant status select dropdown and set the option as No default but when i checked now it showing grant status closed for all the grants and I havent manually provided the grant status to the any grant post. I tried deleting the grant status custom field now and created the new custom field(grant status updated) with no value as default but it taking as status closed by default in all the grants. (the new custom field name is not updated in the code yet) .
Not sure why it automatically taking as closed in custom field. Do i need to set grant status as a seperate custom code drop down to work with this logic?
I do have a page with grant status as ajax with custom dropdown and same php for open and closed. (In block editor )
The same issue the total estimated amount (normal toolset custom field) work seperate and grant status work seperate. grant status work well with taxonomy filters only issue is with this estimated total amount. That´s the reason i tried creating status custom field to make it logic work together.
hidden link
view name: 2023RFD
code snippet name: dropdown -open or closed
<form method="get" action="<?php echo esc_url(add_query_arg($_GET)); ?>">
<label for="grant_status">Grant Status</label><br />
<select name="grant_status" id="grant_status">
<option value="all" <?php echo (isset($_GET['grant_status']) && $_GET['grant_status'] === 'all') ? 'selected' : ''; ?>>All</option>
<option value="open" <?php echo (isset($_GET['grant_status']) && $_GET['grant_status'] === 'open') ? 'selected' : ''; ?>>Open Grants</option>
<option value="closed" <?php echo (isset($_GET['grant_status']) && $_GET['grant_status'] === 'closed') ? 'selected' : ''; ?>>Closed Grants</option>
</select><br />
<!-- Include hidden inputs to append other existing parameters -->
<?php
foreach ($_GET as $key => $value) {
if ($key !== 'grant_status') {
echo '<input type="hidden" name="' . htmlspecialchars($key) . '" value="' . htmlspecialchars($value) . '">';
}
}
?>
<input type="submit" name="submit_status" value="Filter"><br />
<?php
// current query parameters
$current_url = strtok($_SERVER["REQUEST_URI"], '?');
$query_params = $_GET;
// Remove 'grant_status' from existing query parameters
unset($query_params['grant_status']);
// The new URL with updated 'grant_status' parameter
$new_url = $current_url . '?' . http_build_query($query_params);
?>
</form>
<script src="hidden link"></script>
<script>
$(document).ready(function() {
$('#grant_status').on('change', function() {
// Get the form element
var form = $(this).closest('form');
// 'submit_status' parameter
var submitStatusInput = $('<input type="hidden">');
submitStatusInput.attr('name', 'submit_status');
submitStatusInput.val('Filter');
form.append(submitStatusInput);
form.submit();
});
});
</script>
<style>
/* filter button visibility */
input[name="submit_status"] {
display: none;
}
</style>
---------------------------------------------------------------
Php snippet name: open and closed old
function set_grant_status_filter3($query_args, $view_settings, $view_id) {
if ($view_id == 43949) {
// Grant status filter using URL parameters
if (isset($_GET['submit_status']) && isset($_GET['grant_status'])) {
$grant_status = sanitize_text_field($_GET['grant_status']);
$current_timestamp = time();
// query filter for taxonomy take
$tax_query = array(
array(
'taxonomy' => 'rolling',
'field' => 'slug',
'terms' => 'yes',
'operator' => 'NOT IN',
),
);
// Filterfor grant status
if ($grant_status == 'open') {
$query_args['meta_query'] = array(
'relation' => 'OR',
array(
'key' => 'wpcf-grant-final-closing-date',
'value' => $current_timestamp,
'type' => 'NUMERIC',
'compare' => '>=',
),
array(
'key' => 'wpcf-grant-final-closing-date',
'value' => '',
'compare' => '='
)
);
} elseif ($grant_status == 'closed') {
$query_args['meta_query'] = array(
array(
'key' => 'wpcf-grant-final-closing-date',
'value' => $current_timestamp,
'type' => 'NUMERIC',
'compare' => '<',
),
array(
'key' => 'wpcf-grant-final-closing-date',
'value' => '',
'compare' => '!='
)
);
// $query_args['tax_query'] = $tax_query;
}
}
// Pagination
global $wp_query;
if (isset($_GET['wpv_paged'])) {
$wp_query->query_vars['paged'] = intval($_GET['wpv_paged']);
} else {
$wp_query->query_vars['paged'] = 1;
}
}
return $query_args;
}
add_filter('wpv_filter_query', 'set_grant_status_filter3', 10, 3);
-----------------------------------------------------
Trying to do the same in both view to make this logic work.
Please guide me how to set this grant status appropriate to work along with other filters.
Thanks in advance,
