Flat Rate Shipping - Table Rates - Duplicate for Category Specific Items?

[Ajeh]

Remind me, as my mind is slow ...

For Table409 you need:

1 All Products must be from these categories?

2 All Products may NOT be from these categories?

The control is in these choices:

// if number of Products do not match ALL Products in the Cart disable
    if (($chk_cat_total) != $chk_catAll) {
      $this->enabled = false;
    }

// if number of Products does match ALL Products in the Cart disable
    if (($chk_cat_total) == $chk_catAll) {
      $this->enabled = false;
    }

[limelites]

Well, the logic should be in two files.

table409.php - IF all the products in the cart ARE from ONLY these categories then enable

table.php - IF all the products in the cart ARE from ONLY these categories then disable

I'm testing it now with a few different scenarios.

[Ajeh]

Well, the logic should be in two files.
table409.php - IF all the products in the cart ARE from ONLY these categories then enable

// disable if checked count does NOT equal total count
    if (($chk_cat_total) != $chk_catAll) {
      $this->enabled = false;
    }

Well, the logic should be in two files.
table.php - IF all the products in the cart ARE from ONLY these categories then disable

// disable checked count DOES equal total count
    if (($chk_cat_total) == $chk_catAll) {
      $this->enabled = false;
    }

[limelites]

Almost working... but not quite. When I had several products in cart from a mix of different linked and main cats it was showing only the table409.php option at checkout.

However, adding some bulkier products (from categories outside the list of ID's I'm using) and the table409.php is still the only option. It should not show at this stage. Only the table.php option should show. Let me paste the contents of both files. I think it's one of my stupid syntax things!

table409.php

// bof: only show if all Products are from individual products_id and Master/Linked Categories
  if (!IS_ADMIN_FLAG) {


//-------------------------------------------------------------------------------------------------
    // check individual products_id 168, 169, 172
//    $chk_products_found = 0;
//    $chk_products = $_SESSION['cart']->get_products();
//    for ($i=0, $n=sizeof($chk_products); $i<$n; $i++) {
//      if ( in_array((int)$chk_products[$i]['id'], array(168, 169, 172)) ) {
//        $chk_products_found += $chk_products[$i]['quantity'];
//      }
//   }
//echo 'Products Individual Found: ' . $chk_products_found . '<br>';
//-------------------------------------------------------------------------------------------------


    // check Products from Linked Categories 5, 10, 22
    $chk_linked = $db->Execute("SELECT distinct products_id FROM " . TABLE_PRODUCTS_TO_CATEGORIES . " WHERE categories_id IN (409, 7, 103, 104, 105, 336, 372, 361, 397, 395, 385, 401, 391, 400, 394, 384, 387, 399, 390)");
    while(!$chk_linked->EOF) {
      $selected_products_check .= $chk_linked->fields['products_id'];
      $chk_linked->MoveNext();
      if (!$chk_linked->EOF) {
        $selected_products_check .= ',';
      }
    }
    $selected_products = explode(',', $selected_products_check);
    // check cart contents for linked products
    $chk_products_linked = $chk_products;
    $chk_products_found_linked = 0;
    for ($i=0, $n=sizeof($chk_products_linked); $i<$n; $i++) {
      if ( in_array((int)$chk_products_linked[$i]['id'], $selected_products) ) {
        $chk_products_found_linked += $chk_products_linked[$i]['quantity'];
      }
    }
echo 'Products Master/Linked Found: ' . $chk_products_found_linked . '<br>';

    $chk_cat_total = ($chk_products_found + $chk_products_found_linked);

    // if any Products are found and does not match ALL products in cart turn off the shipping module
    if (($chk_cat_total) != $chk_catAll) {
      $this->enabled = false;
    }
  }
// eof: only show if all Products are from individual products_id and Master/Linked Categories 

table.php

// bof: only show if all Products are OUTWITH Master/Linked Categories
  if (!IS_ADMIN_FLAG) {


//-------------------------------------------------------------------------------------------------
    // check individual products_id 168, 169, 172
//    $chk_products_found = 0;
//    $chk_products = $_SESSION['cart']->get_products();
//    for ($i=0, $n=sizeof($chk_products); $i<$n; $i++) {
//      if ( in_array((int)$chk_products[$i]['id'], array(168, 169, 172)) ) {
//        $chk_products_found += $chk_products[$i]['quantity'];
//      }
//   }
//echo 'Products Individual Found: ' . $chk_products_found . '<br>';
//-------------------------------------------------------------------------------------------------


    // check Products from Linked Categories 
    $chk_linked = $db->Execute("SELECT distinct products_id FROM " . TABLE_PRODUCTS_TO_CATEGORIES . " WHERE categories_id IN (409, 7, 103, 104, 105, 336, 372, 361, 397, 395, 385, 401, 391, 400, 394, 384, 387, 399, 390)");
    while(!$chk_linked->EOF) {
      $selected_products_check .= $chk_linked->fields['products_id'];
      $chk_linked->MoveNext();
      if (!$chk_linked->EOF) {
        $selected_products_check .= ',';
      }
    }
    $selected_products = explode(',', $selected_products_check);
    // check cart contents for linked products
    $chk_products_linked = $chk_products;
    $chk_products_found_linked = 0;
    for ($i=0, $n=sizeof($chk_products_linked); $i<$n; $i++) {
      if ( in_array((int)$chk_products_linked[$i]['id'], $selected_products) ) {
        $chk_products_found_linked += $chk_products_linked[$i]['quantity'];
      }
    }
echo 'Products Master/Linked Found: ' . $chk_products_found_linked . '<br>';

    $chk_cat_total = ($chk_products_found + $chk_products_found_linked);

    // if any Products are found and does not match ALL products in cart turn off the shipping module
    if (($chk_cat_total) == $chk_catAll) {
      $this->enabled = false;
    }
  }
// eof: only show if all Products are OUTWITH Master/Linked Categories 

[limelites]

Not sure why, but it doesn't matter what's in your cart now. Only table409.php shows. Regardless of product or category. It's never table.php. Always table409.php

[Ajeh]

Right now, Table409 is saying if checked categories does NOT match ALL Products in the cart, it should be disabled ...

Right now, Table is saying if checked categories DOES match ALL Products in the cart, it should be disabled ...

[Ajeh]

I have to run for a few hours but I will review the code and see if I might have goobered up somewhere ... not that I ever goober up things ...

[Ajeh]

See what happens if you uncomment these two lines:

//    $chk_products_found = 0;
//    $chk_products = $_SESSION['cart']->get_products();

[limelites]

See what happens if you uncomment these two lines:

//    $chk_products_found = 0;
//    $chk_products = $_SESSION['cart']->get_products();

Uncommenting those two lines seems to have no effect. I have a product in the cart which does not come under the category ID's in the list. However, the only option is shown as teble409.php. It should be table.php.

[Ajeh]

Below those two can you add:

    $chk_products_found = 0;
    $chk_products = $_SESSION['cart']->get_products();
    $chk_catAll = $_SESSION['cart']->count_contents();