538 replies to this topic

[Unified]

Quote

ok can you click on the name in the cart and get the description?

No. The name is not clickable.

By the way... as I am doing this stock I will mark all the changes in all the requisite files so when everything is finished we can have a complete fresh MS2 with the contrib ready to use and installed - if you want? this is with images etc

Regards

Jiten

[sw45859]

sounds good to me, what are the problems that are active now, i need to make a to do list

[Unified]

Ok here is a list of the issues remaining:

1. Invoice/Packing slip do not list components
2. Admin/orders.php does not list components
3. Catalog/shopping_cart.php does not list components
4. catalog/checkout_confirmation.php does not list components
5. Sessions lost on catalog/ccc.php when a FSB speed is selected

Those are the issues that are remaining that prevent the contribution from being functional - once these are sorted out I think it may be 100% functional for a live site!

There may be improvements here and there - like the ability to go back and revise the system from custom_checkout.php. I tried to add a link back to build.php but the product information is lost.

Those are the immediate things I can think of.

Regards

Jiten

[sw45859]

sessions should work because it is called from the application_top, i am going to see what else could be causeing it

[Unified]

I am going to retrace steps and see if we can get this working.

Sessions disappear when you click on any of the FSB speeds. I remember once sorting out a session issue by changing

... 'NONSSL', false

to:

...  'NONSSL', true

However, I would not know how that would be implemented into the form that you have used linking to the FSB speeds?

Will let you know progress with your new instructions!

[Unified]

Hello Stephen!

GOOD NEWS I MAY HAVE FIGURED IT OUT!!!!!!!

I was looking at why it was showing the list of products in account_history_info.php and not any other page!

What the shopping_cart.php and etc lack is "pd.products_description" in the

$products_query = tep_db_query

In shopping_cart.php I changed line 273 from:

        $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$products_id . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

to this:

        $products_query = tep_db_query("select p.products_id, pd.products_description, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$products_id . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

Notice the pd.products_description - now I can see the listing of products in the shopping cart!

Just want your confirmation that I am doing the right thing before i continue!

Regards

Jiten

[Unified]

Sorry could not edit previous post

The file is catalog/includes/classes/shopping_cart.php in case you were wondering!

Regards

Jiten

[sw45859]

ok does that take care of all the issues with the description not showing up on those pages?

[Unified]

Yes - now the products are being listed on the following pages:

1. catalog/shopping_cart.php
2. catalog/checkout_confirmation.php
3. catalog/account_history_info.php

Unfortunately - still not showing on the admin side? Nor in the invoices??? I will upload it soon to a website so you can see.

Any ideas - maybe pd.products_description needs to be added in admin/includes/classes/orders.php?

Regards

Jiten

[sw45859]

it is all there, i just have to remember where i edited to make it show, i could swear i put everything there for the admin side

[sw45859]

can you post the code between lines 80 and 95 in your admin/includes/classes/order.php please

Edited by sw45859, 26 December 2003, 18:51.

[Unified]

Stephen mate!

RELAX!

Too much time on the bloody computers! Thats the problem!

I am gonna go for a Pint now and u should too! Its boxing day and we have spent more time on this then probably with family/friends! So relax mate and we try sort it out later

Again thanx for help and support! Nearly close to finishing! Hopefully have it working soon! I am also commenting the changes actually within the files you mention and have reworked the catalog pages so that the form is easier on the eye and fits the standard MS2 layout tables (My columns etc were messing up previously) together with all images!

Take it easy mate & MERRY (SLIGHTLY LATE) XMAS TO EVERYBODY!

Regards

Jiten

[Unified]

Just coz we close to solution here goes:

These are lines 69-96 in admin/includes/classes/order.php

      $this->billing = array('name' => $order['billing_name'],
                             'company' => $order['billing_company'],
                             'street_address' => $order['billing_street_address'],
                             'suburb' => $order['billing_suburb'],
                             'city' => $order['billing_city'],
                             'postcode' => $order['billing_postcode'],
                             'state' => $order['billing_state'],
                             'country' => $order['billing_country'],
                             'format_id' => $order['billing_address_format_id']);

      $index = 0;
      $orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'");
      while ($orders_products = tep_db_fetch_array($orders_products_query)) {
        $this->products[$index] = array('qty' => $orders_products['products_quantity'],
                                        'name' => $orders_products['products_name'],
                                        'model' => $orders_products['products_model'],
                                        'tax' => $orders_products['products_tax'],
                                        'price' => $orders_products['products_price'],
                                        'final_price' => $orders_products['final_price']);

        $subindex = 0;
        $attributes_query = tep_db_query("select products_options, products_options_values, options_values_price, price_prefix from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int)$order_id . "' and orders_products_id = '" . (int)$orders_products['orders_products_id'] . "'");
        if (tep_db_num_rows($attributes_query)) {
          while ($attributes = tep_db_fetch_array($attributes_query)) {
            $this->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options'],
                                                                     'value' => $attributes['products_options_values'],
                                                                     'prefix' => $attributes['price_prefix'],
                                                                     'price' => $attributes['options_values_price']);

Hope this helps!

Regards

Jiten

[sw45859]

i put this in an earlier post:
replace

     $orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'");
     while ($orders_products = tep_db_fetch_array($orders_products_query)) {
       $this->products[$index] = array('qty' => $orders_products['products_quantity'],
                                       'name' => $orders_products['products_name'],
                                       'model' => $orders_products['products_model'],
                                       'tax' => $orders_products['products_tax'],
                                       'price' => $orders_products['products_price'],
                                       'final_price' => $orders_products['final_price']);

with

      $orders_products_query = tep_db_query("select orders_products_id, products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'");
      while ($orders_products = tep_db_fetch_array($orders_products_query)) {
       $description_query = tep_db_query("select products_description as desc_info from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = " . $orders_products['products_id']);
              $description_info = tep_db_fetch_array($description_query);

        $this->products[$index] = array('qty' => $orders_products['products_quantity'],
                                        'name' => $orders_products['products_name'],
 	 //CCC 
          'description' => $description_info['desc_info'],
 	 //DONE
                                        'model' => $orders_products['products_model'],
                                        'tax' => $orders_products['products_tax'],
                                        'price' => $orders_products['products_price'],
                                        'final_price' => $orders_products['final_price']);

[Unified]

Thats great!

It's now working! Thanks mate!

I kept modifying catalog/includes/classes.order.php

Sorry tired eyes!

Again thanx!

Now I am trying to sort out sessions issues - maybe I should define ccc.php in application_top.php on the catalog side?

Regards

Jiten

[sw45859]

the thing i am trying to figure out is that my site doesn't lose the session, do you have your sessions stored in mysql?

[Unified]

Yes... my sessions are stored in the database

Also, on my local machine I do not have ssl

[sw45859]

SHOW OF HANDS:
1. Bring Back Pictures?
2. If So Enable Them By Category Or Product?


not saying that this last release is completly fixed, but this is one of the next additions if it is wanted.

[Unified]

Maybe just for external components such as the Case/keyboard/speakers etc?

[sw45859]

so i will add it and have it able to be disabled by category, like keyboards, monitors, harddrives