Products Available Date

[DigiBooks]

Hi

We have been using the products available date to display forthcoming books soon to be released.

Problem is we are sure that one was set with a due date of 9th June and this morning it has gone from the list. Does the system automatically remove these dates once they are passed? I wouldn't have thought so but now I'm not so sure.

I've even looked in PHP Admin and sorted on product_expected and only the 8 that show on the site are there with a date.

[Ajeh]

Yes, once the Available Date has happened then the date is removed from the Product record ...

[DigiBooks]

Yes, once the Available Date has happened then the date is removed from the Product record ...

Oh how annoying!!! We're using it as a Product Expected date rather than a Product Available date ..... going to have to rethink this then

[DigiBooks]

Would anybody happen to know where the code for this automatic date removal sits please? We would like to keep product available even past the date specified if we cannot locate it.

Thanks

[Ajeh]

Check first that the fieldname is:
products_date_available

vs what you have posted:
product_expected

[DigiBooks]

Check first that the fieldname is:
products_date_available

vs what you have posted:
product_expected

Hi AJeh

Yes thanks - I did that work bit out ... just trying to find where it erases the products_data_available field in the database

[DigiBooks]

Think I may have it:

In Admin/products_expected.php

I have commented out the following:

// $db->Execute("update " . TABLE_PRODUCTS . "
// set products_date_available = NULL
// where to_days(now()) > to_days(products_date_available)");


Should see tomorrow if that does the trick as I have set up a dummy product available tomorrow

[Ajeh]

You have two files to customize if you NEVER want the products_date_available to change except when you manually change it ...
/your_secret_admin/includes/modules/update_product.php

comment out the line that removes it when in the Admin:

  } elseif ($_POST['products_model'] . $_POST['products_url'] . $_POST['products_name'] . $_POST['products_description'] != '') {
    $products_date_available = zen_db_prepare_input($_POST['products_date_available']);
//    $products_date_available = (date('Y-m-d') < $products_date_available) ? $products_date_available : 'null';
    // Data-cleaning to prevent MySQL5 data-type mismatch errors:

then in the Catalog, you need to change the date filter so ALL dates are valid unless blank by commenting the old method and adding a new date range that will force it to always be valid when not blank ...
/includes/functions/functions_lookups.php

// build date range for upcoming products
  function zen_get_upcoming_date_range() {
    // 120 days; 24 hours; 60 mins; 60secs
    $date_range = time();
    $zc_new_date = date('Ymd', $date_range);
// need to check speed on this for larger sites
//    $new_range = ' and date_format(p.products_date_available, \'%Y%m%d\') >' . $zc_new_date;
//    $new_range = ' and p.products_date_available >' . $zc_new_date . '235959';
$new_range = ' and p.products_date_available > "2000-01-01"';
    return $new_range;
  }

[DigiBooks]

You have two files to customize if you NEVER want the products_date_available to change except when you manually change it ...
/your_secret_admin/includes/modules/update_product.php

comment out the line that removes it when in the Admin:

  } elseif ($_POST['products_model'] . $_POST['products_url'] . $_POST['products_name'] . $_POST['products_description'] != '') {
    $products_date_available = zen_db_prepare_input($_POST['products_date_available']);
//    $products_date_available = (date('Y-m-d') < $products_date_available) ? $products_date_available : 'null';
    // Data-cleaning to prevent MySQL5 data-type mismatch errors:

then in the Catalog, you need to change the date filter so ALL dates are valid unless blank by commenting the old method and adding a new date range that will force it to always be valid when not blank ...
/includes/functions/functions_lookups.php

// build date range for upcoming products
  function zen_get_upcoming_date_range() {
    // 120 days; 24 hours; 60 mins; 60secs
    $date_range = time();
    $zc_new_date = date('Ymd', $date_range);
// need to check speed on this for larger sites
//    $new_range = ' and date_format(p.products_date_available, \'%Y%m%d\') >' . $zc_new_date;
//    $new_range = ' and p.products_date_available >' . $zc_new_date . '235959';
$new_range = ' and p.products_date_available > "2000-01-01"';
    return $new_range;
  }

You'r a star thank you .. I will get these changed :)

[Ajeh]

You are most welcome ...

Remember, you will have to remove the date manually when you want it to go away ...