Jump to content

rosemaryann

Members
  • Content count

    40
  • Joined

  • Last visited

Profile Information

  • Real Name
    Rosemary
  1. rosemaryann

    Country-State Selector

    Does anyone else have trouble with this working in Internet Explorer? I have v. 1.5.5 but it seems the ajax isn't working for some IE customers including myself on my test server. I checked in IE 8 and IE 7. It doesn't update the state field at all when you change the country. However, it works in Firefox 3.6 - haven't tried in v. 4
  2. rosemaryann

    Account Balance (gift certificate redemption)

    This add on doesn't work quite properly. If the account balance is less than what is owed, the credit card is still charged $0.00. Just an FYI. I'm trying to figure out how to fix that, but I just thought I'd give a heads up to those using it.
  3. rosemaryann

    Account Balance (gift certificate redemption)

    You need to run the sql queries included with the zip file on your database... ALTER TABLE `customers` ADD `customers_account_balance` DECIMAL( 15, 4 ) default '0'; DROP TABLE IF EXISTS customers_balance_history; CREATE TABLE customers_balance_history( orders_id int(11) NOT NULL, customers_id int(11) NOT NULL default '0', customers_firstname char(20) default NULL, customers_lastname char(20) default NULL, date_customers_balance datetime NOT NULL, amount_customer_balance decimal(15,4) default'0', type_customer_balance char(20) default NULL, desc_customer_balance char(64) default NULL ) TYPE=MyISAM;
  4. rosemaryann

    Seperate Pricing Per Customer v3.5

    For those of you using Separate Pricing Per Customer & Quantity Price Breaks with Zappo's Options Types... There is a query error when customers with text attributes (if they include a comma in their text) get when they log back in. I found a fix for this and thought I would share: In /catalog/includes/classes/PriceFormatterStore.php Find... if (tep_not_null($valid_value)) { $product_id_list_array[] = $valid_value; } And replace with... if (tep_not_null($valid_value)&&is_numeric($valid_value)) { $product_id_list_array[] = $valid_value; } This way the product_id array only returns numeric values. :D Hope this helps someone else.
  5. rosemaryann

    Seperate Pricing Per Customer v3.5

    I feel really stupid now. I actually found it, I had typed wrong in the first $products_query $products_query = tep_db_query("select products_id, customers_basket_quantity from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . (int)$customer_id . "'"); // BOF SPPC Hide products and categories from groups $no_of_products_in_basket = 0; while ($products = tep_db_fetch_array($products_query)) { $temp_post_get_array[] = $_products['products_id']; $products[] = $_products; $no_of_products_in_basket += 1; } The while condition should be $_products NOT $products... DoH! Good grief. :blush:
  6. rosemaryann

    Seperate Pricing Per Customer v3.5

    I don't think that this is a repeat question, I apologize if it is - there is a LOT of posts in this topic. I'm getting an error when the function tep_get_hide_status() is called (when customer logs in with 1 item in cart, and this is supposed to remove any hidden items from that cart) I am getting a query error on the $hide_query the variable $list_of_products_ids comes up blank so I get the following error: I am assuming it's causing it in the shopping_cart class file because I do have another addon (Zappos Options Types) installed. I'm going to keep looking but thought another pair of eyes might help. Can anyone see where I'm missing a variable defined? Below is the portion of code that I **THINK** is what is causing problems but I'm not really sure. $products_query = tep_db_query("select products_id, customers_basket_quantity from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . (int)$customer_id . "'"); // BOF SPPC Hide products and categories from groups $no_of_products_in_basket = 0; while ($products = tep_db_fetch_array($products_query)) { $temp_post_get_array[] = $_products['products_id']; $products[] = $_products; $no_of_products_in_basket += 1; } if ($no_of_products_in_basket > 0) { $hide_status_products = array(); $hide_status_products = tep_get_hide_status($hide_status_products, $this->cg_id, $temp_post_get_array); for ($i=0 ; $i < $no_of_products_in_basket; $i++) { foreach($hide_status_products as $key => $subarray) { if ($subarray['products_id'] == tep_get_prid($products[$i]['products_id']) && $subarray['hidden'] == '0') { // not hidden for this customer, can be added to the object shoppingCart $this->contents[$products['products_id']] = array('qty' => $products[$i]['customers_basket_quantity']); // attributes //BOF - Zappo - Option Types v2 - Update query to pull attribute value_text. This is needed for text attributes. $attributes_query = tep_db_query("select products_options_id, products_options_value_id, products_options_value_text from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . (int)$customer_id . "' and products_id = '" . tep_db_input($products[$i]['products_id']) . "'"); while ($attributes = tep_db_fetch_array($attributes_query)) { $this->contents[$products[$i]['products_id']]['attributes'][$attributes['products_options_id']] = $attributes['products_options_value_id']; // - Zappo - Option Types v2 - If attribute is Text, set additional information if ($attributes['products_options_value_id'] == OPTIONS_VALUE_TEXT_ID) { $this->contents[$products[$i]['products_id']]['attributes_values'][$attributes['products_options_id']] = $attributes['products_options_value_text']; } //EOF - Zappo - Option Types v2 - Update query to pull attribute value_text. This is needed for text attributes. } // end while } elseif ($subarray['products_id'] == tep_get_prid($products[$i]['products_id']) && $subarray['hidden'] == '1') { // product is hidden for the customer, don't add to object shoppingCart, delete from db next $products_to_delete_from_cb[] = $products[$i]['products_id']; } // end if/elseif }// end foreach ($hide_status_products as $key => $subarray) } // end for ($i=0 ; $i < $no_of_products_in_basket; $i++) // delete from the database those products that are hidden from this customer if (tep_not_null($products_to_delete_from_cb)) { $no_of_iterations = count($products_to_delete_from_cb); // since the products_id in the table customer_basket and customer_basket_attributes can contain // attributes like 1{4}2{3}6 we need to delete them one by one for the two tables for ($y = 0; $y < $no_of_iterations; $y++) { tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . (int)$customer_id . "' and (products_id = '" . (int)$products_to_delete_from_cb[$y] . "' or products_id REGEXP '^" . (int)$products_to_delete_from_cb[$y] . "{');"); tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . (int)$customer_id . "' and (products_id = '" . (int)$products_to_delete_from_cb[$y] . "' or products_id REGEXP '^" . (int)$products_to_delete_from_cb[$y] . "{');"); } // end for ($y = 0; $y < $no_of_iterations; $y++) } // end if (tep_not_null($products_to_delete_from_cb)) } // end if ($no_of_products_in_basket > 0) // EOF SPPC Hide products and categories from groups $this->cleanup(); }
  7. rosemaryann

    Quickbooks Merchant Service v1.0

    Hey everyone, I was wondering if anyone who has the Desktop Model up and running, do you experience the authorization request pulling the customer's account address/postcode instead of the billing address/post code? I'm getting pretty frequent transactions rejected when a customer does not enter their billing address as their main account address even if they change the billing address to their correct billing information. My QBMS module does seem to be coded right where it's requested the $order->billing['street_address'] so I'm not sure what the deal is. Anyone have this problem?
  8. rosemaryann

    [Contribution] Option Types v2

    Agh, nevermind. I've done something to where I have no idea what I did and no uploads work at all. Back to the drawing board. Time to revisit the original code meticulously again! Sorry
  9. rosemaryann

    [Contribution] Option Types v2

    Hey, hey! So I'm having an issue with file option types where if the file extension does not match, it won't display the error and it adds the product to the shopping cart without the file option if the file does not match. Where would I find the output for the error. I looked in the classes/upload.php and it's the same as the one included in the contribution. I thought it might be in the application_top where the case "add_product" was but this is identical too. Any suggestions where to look?
  10. rosemaryann

    Batch Printing without Frames or PDF

    Hey I just added a update file to the contribution, I wanted to have the option to notify a customer of an status update or not. My changes adds a Yes/No radio along with the other options that you can select to notify the customer of a status change instead of always emailing the customer for every status change. So see the contribution page for these changes: http://addons.oscommerce.com/info/3155 Cheers!
  11. rosemaryann

    [Contribution] Option Types v2

    Hey!, I'm sorry if I'm beeing so insistent but I really need help, if someone has the answer to my problem please tell me, help will be even more appreciated than yesterday ;) Thanks. Hey - probably you need to check and make sure you have added the file: includes/modules/option_types.php in the correct location. The other thing I would suggest is to go through /includes/classes/shopping_cart.php and make sure all the modifications are entered correctly. Though if you have another contribution(s) installed it may effect it differently.
  12. rosemaryann

    [Contribution] Option Types v2

    MultiMixer, Yeah I'm trying the same thing. I got similar results a little differently. PM me if you want to compare my version. My problem is that I cannot get the Text options to add to the cart. I'm thinking it's something in the classes/shopping_cart. Though it may be somewhere in the modules/option_types file. Do you have this problem as well?
  13. rosemaryann

    Seperate Pricing Per Customer v3.5

    Hey everyone, I'm trying to combine this add-on with the Options Types 2.0 add-on. I just about have it (I think) but having a tough time with the text values being added to the shopping cart. I believe I've narrowed it down to the shopping cart class... (/includes/classes/shopping_cart.php) I was wondering if anyone has these two installed or if you can look at what I have, because I need a 2nd pair of eyes. I'm still not quite sure how the hidden attributes work in this add-on. I believe my problem is somewhere in this area: /includes/classes/shopping_cart.php // insert current cart contents in database if (is_array($this->contents)) { reset($this->contents); // BOF SPPC attribute hide/invalid check: loop through the shopping cart and check the attributes if they // are hidden for the now logged-in customer $this->cg_id = $this->get_customer_group_id(); while (list($products_id, ) = each($this->contents)) { // only check attributes if they are set for the product in the cart if (isset($this->contents[$products_id]['attributes'])) { $check_attributes_query = tep_db_query("select options_id, options_values_id, IF(find_in_set('" . $this->cg_id . "', attributes_hide_from_groups) = 0, '0', '1') as hide_attr_status from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . tep_get_prid($products_id) . "'"); while ($_check_attributes = tep_db_fetch_array($check_attributes_query)) { $check_attributes[] = $_check_attributes; } // end while ($_check_attributes = tep_db_fetch_array($check_attributes_query)) $no_of_check_attributes = count($check_attributes); $change_products_id = '0'; foreach($this->contents[$products_id]['attributes'] as $attr_option => $attr_option_value) { $valid_option = '0'; for ($x = 0; $x < $no_of_check_attributes ; $x++) { if ($attr_option == $check_attributes[$x]['options_id'] && $attr_option_value == $check_attributes[$x]['options_values_id']) { $valid_option = '1'; if ($check_attributes[$x]['hide_attr_status'] == '1') { // delete hidden attributes from array attributes, change products_id accordingly later $change_products_id = '1'; unset($this->contents[$products_id]['attributes'][$attr_option]); } } // end if ($attr_option == $check_attributes[$x]['options_id'].... } // end for ($x = 0; $x < $no_of_check_attributes ; $x++) if ($valid_option == '0') { // after having gone through the options for this product and not having found a matching one // we can conclude that apparently this is not a valid option for this product so remove it unset($this->contents[$products_id]['attributes'][$attr_option]); // change products_id accordingly later $change_products_id = '1'; } } // end foreach($this->contents[$products_id]['attributes'] as $attr_option => $attr_option_value) if ($change_products_id == '1') { $original_products_id = $products_id; $products_id = tep_get_prid($original_products_id); $products_id = tep_get_uprid($products_id, $this->contents[$original_products_id]['attributes']); // add the product without the hidden attributes to the cart $this->contents[$products_id] = $this->contents[$original_products_id]; // delete the originally added product with the hidden attributes unset($this->contents[$original_products_id]); } } // end if (isset($this->contents[$products_id]['attributes'])) } // end while (list($products_id, ) = each($this->contents)) reset($this->contents); // reset the array otherwise the cart will be emptied // EOF SPPC attribute hide/invalid check while (list($products_id, ) = each($this->contents)) { $qty = $this->contents[$products_id]['qty']; $product_query = tep_db_query("select products_id from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . (int)$customer_id . "' and products_id = '" . tep_db_input($products_id) . "'"); if (!tep_db_num_rows($product_query)) { tep_db_query("insert into " . TABLE_CUSTOMERS_BASKET . " (customers_id, products_id, customers_basket_quantity, customers_basket_date_added) values ('" . (int)$customer_id . "', '" . tep_db_input($products_id) . "', '" . tep_db_input($qty) . "', '" . date('Ymd') . "')"); if (isset($this->contents[$products_id]['attributes'])) { //BOF - Zappo - Option Types v2 - Update query to include attribute value && Check for Uploads from customer and copy to Upload dir $uploads_query = tep_db_query("select files_uploaded_name from " . TABLE_FILES_UPLOADED . " where sesskey = '" . tep_session_id() . "'"); while ($uploads_array = tep_db_fetch_array($uploads_query)) { if (file_exists(TMP_DIR . $uploads_array['files_uploaded_name'])) { // Customer upload found in TMP dir --> Copy to Upload Dir @rename(TMP_DIR . $uploads_array['files_uploaded_name'], UPL_DIR . $uploads_array['files_uploaded_name']); // Set Customer_ID for the files that are found tep_db_query("update " . TABLE_FILES_UPLOADED . " set customers_id = '" . (int)$customer_id . "' where sesskey = '" . tep_session_id() . "' and files_uploaded_name = '" . $uploads_array['files_uploaded_name'] . "'"); } } reset($this->contents[$products_id]['attributes']); while (list($option, $value) = each($this->contents[$products_id]['attributes'])) { $attr_value = $this->contents[$products_id]['attributes_values'][$option]; tep_db_query("insert into " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " (customers_id, products_id, products_options_id, products_options_value_id, products_options_value_text) values ('" . (int)$customer_id . "', '" . tep_db_input($products_id) . "', '" . $option . "', '" . (int)$value . "', '" . tep_db_input($attr_value) . "')"); //EOF - Zappo - Option Types v2 - Update query to include attribute value && Check for Uploads from customer and copy to Upload dir } } } else { tep_db_query("update " . TABLE_CUSTOMERS_BASKET . " set customers_basket_quantity = '" . tep_db_input($qty) . "' where customers_id = '" . (int)$customer_id . "' and products_id = '" . tep_db_input($products_id) . "'"); } } } // reset per-session cart contents, but not the database contents $this->reset(false); $products_query = tep_db_query("select products_id, customers_basket_quantity from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . (int)$customer_id . "'"); while ($products = tep_db_fetch_array($products_query)) { $this->contents[$products['products_id']] = array('qty' => $products['customers_basket_quantity']); // attributes //BOF - Zappo - Option Types v2 - Update query to pull attribute value_text. This is needed for text attributes. $attributes_query = tep_db_query("select products_options_id, products_options_value_id, products_options_value_text from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . (int)$customer_id . "' and products_id = '" . tep_db_input($products['products_id']) . "'"); while ($attributes = tep_db_fetch_array($attributes_query)) { $this->contents[$products['products_id']]['attributes'][$attributes['products_options_id']] = $attributes['products_options_value_id']; // - Zappo - Option Types v2 - If attribute is Text, set additional information if ($attributes['products_options_value_id'] == OPTIONS_VALUE_TEXT_ID) { $this->contents[$products['products_id']]['attributes_values'][$attributes['products_options_id']] = $attributes['products_options_value_text']; } //EOF - Zappo - Option Types v2 - Update query to pull attribute value_text. This is needed for text attributes. } } $this->cleanup(); }
  14. rosemaryann

    [Contribution] Option Types v2

    Ok so I'm having some issues with the textarea option type. I have put in 100 for it's value but only 32 characters show up in the shopping cart and consequently on the packing slip/invoice/orders.php on the admin side. I'm not sure if this is a setting I need to change somewhere or it's a setting in option types? Any suggestions? It's one of those things where I keep looking for it but just cannot see.
  15. rosemaryann

    Quickbooks Merchant Service v1.0

    I've gotten the module to work. We just manually enter the information in our QB file. What I'm wondering though is there a way to pull the Credit Card type, Name on Card and the Last 4 digits (the info that displays just before checkout confirmation) on the invoice on the admin side? I'd like to keep this information on file for our records since there's no way to pull payment info from the merchant services account (per QBMS Customer Service) So when we make our notes in the QB company file I'd like to have something there to reference that. Would I have to create new columns in the database and somehow pull that info? I'm bad at writing queries.... Ha! So any ideas/help would be appreciated!
×