Page 3 of 3 FirstFirst 123
Results 21 to 22 of 22
  1. #21
    Join Date
    Jul 2012
    Posts
    16,733
    Plugin Contributions
    17

    Default Re: Speicals and Sales Tax Not Included

    Quote Originally Posted by lruskauff View Post
    I thought I remembered seeing that the ZC version of the function has a large SQL statement to factor for all tax types, the session information, etc... And that (the SQL execute result) needs to be set to the variable $product_check
    [/quote]
    To me, it looks like his function, pt_get_discount_amount, was taken from the middle of Zencarts zen_get_products_display_price. And that has the following before the code:

    Code:
       $product_check = $db->Execute("select products_tax_class_id, products_price, products_priced_by_attribute, product_is_free, product_is_call, products_type from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'" . " limit 1");
    
        // no prices on Document General
        if ($product_check->fields['products_type'] == 3) {
          return '';
        }
    So if this function only needs the tax class id, it could be shortened to:
    Code:
     $product_check = $db->Execute("select products_tax_class_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'" . " limit 1");
    I'm still looking for the SQL version you mentioned above but it really depends on whether I am guessing correctly as to what this function should do. So maybe the best advice would be is to chose a new template?[/QUOTE]

    Yup the second one should do, my confusion earlier was from looking at. Closely similar query in the function_taxes.php file. That was where tax groups or something were added and then given a name. Anyways, with the above query executed inside that function the display of differences between two prices should now come out correctly in this modified template that was developed by someone currently unavailable for what may be personal reasons...

    Hopefully can feedback that information so the next poor soul doesn't have to get it fixed either.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  2. #22
    Join Date
    Jul 2010
    Location
    Australia
    Posts
    131
    Plugin Contributions
    0

    Default Re: Speicals and Sales Tax Not Included

    I'm very sorry to have left you in the lurch all week. I injured myself and was unable to access a computer, BUT...
    Thank you SO much, guys! That snippet of code has included the tax on the specials tags (I have included a screenshot as evidence )
    Attached Images Attached Images  

 

 
Page 3 of 3 FirstFirst 123

Similar Threads

  1. v151 Sales tax shows for out of state but correctly not included in total
    By perfcomp in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 1
    Last Post: 12 Dec 2012, 09:10 AM
  2. Can I show "Tax incl" and "tax not included" right behind the price
    By elektroarena in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 0
    Last Post: 19 Jul 2012, 08:21 AM
  3. Sales Tax not Included?
    By alwiyah in forum General Questions
    Replies: 0
    Last Post: 26 Mar 2011, 01:19 AM
  4. Sales tax included in Out of state sales
    By kb9k in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 2
    Last Post: 19 Feb 2011, 11:22 PM
  5. Replies: 0
    Last Post: 13 Jun 2008, 12:57 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR