need know a product name, category name, unit pric

Start
Prev
1
Next
End

aspkiddy
Topic Author
Offline

Posts: 98
Thank you received: 1

11 years 3 months ago #145055

-- url of the page with the problem -- : http://127.0.0.139
-- HikaShop version -- : x2.2.3
-- Joomla version -- : Joomla! 2.5.11
-- PHP version -- : 5.4.5

I need know a product name, category name, unit price and quantity in an order :

In last step of transaction (in my end page (checkout/end.php)

I would write :

transaction Id = 1234
Site name = Toto Inc Web Site
bill total = 25.00
bill tax = 2.50
shipping = 5

Items :
product id = 123456789
product name = tostos
product category name = computer
product price = 10.00
product quantity = 1

Items :
product id = 323456789
product name = toptop
product category name = computer
product price = 7.50
product quantity = 1

I find the transaction Id, site name , bill total, bill tax and shipping but I can not find
information of each items : product id, product name, product category name, product price, product quantity

I put this code in my end.php :

$app = JFactory::getApplication();
$order_id = $app->getUserState('com_hikashop.order_id');

$orderClass = hikashop_get('class.order');
$this->order = $orderClass->loadFullOrder($order_id,true,false);
$transaction_id = $order_id;
	
$conf	= JFactory::getConfig();
if(HIKASHOP_J30)
	{
		$siteName=$conf->get('sitename');
	}
	else
	{
		$siteName=$conf->getValue('config.sitename');
	}

$site_name = $siteName; /* Site name */
	
	

$order_total = $this->order->order_full_price;
$bill_total = $order_total;  /* bill total */
	
	

$shipping_price_without_tax = $this->order->order_shipping_price-$this->order->order_shipping_tax;
$shipping = $shipping_price_without_tax;  /* shipping */

$taxes = $bill_total-$shipping-$this->order->order_subtotal_no_vat;
$bill_tax = $taxes; /* bill tax */

But I added also information of Items transaction.

How can I have it ?

I tried it with this code but I have anything :

$product_id = $this->product->order_product_code;
$product_name = $this->product->order_product_name;
$product_category_name = $this->product->order->product_category->category_name;
$product_price = $this->product->order_product_price+$this->product->order_product_tax;
$product_quantity = $this->product->order_product_quantity;

but these variables are null

How can I get its values ?

Thanks

Please Log in or Create an account to join the conversation.

nicolas
Away

Posts: 83933
Thank you received: 13588
MODERATOR

11 years 3 months ago #145078

You should do like that:

foreach($this->order->products as $product){
echo $product->order_product_name;
}

Last edit: 11 years 3 months ago by nicolas.

The following user(s) said Thank You: aspkiddy

Please Log in or Create an account to join the conversation.

aspkiddy
Topic Author
Offline

Posts: 98
Thank you received: 1

11 years 3 months ago #145197

Thanks Nicolas,

It works and I find :

product id = 123456789
product name = tostos

product price without tax = 10.00
product quantity = 1

foreach($this->order->products as $product){
echo $product->order_product_code; //product id
echo $product->order_product_name;  //product name
echo $product->order_product_price   //product price without tax
echo $product->order_product_quantity;  //product quantity

But I can't find name of product category and product price with tax :

product category name = computer
product price without tax = 12.50

I tried for' product category name" ( = computer)

echo $product->order_product_category->order_category_name;
echo $product->order_product_category->category_name;
echo $product->product_category->order_category_name;
echo $product->product_category->category_name;

I tried for' roduct price with tax" ( = computer)

echo $product->order_product_price+$product->order_product_tax;

But I have anything

How can I find its values for 'product category name' and 'product price with tax' ?

thanks

Please Log in or Create an account to join the conversation.

aspkiddy
Topic Author
Offline

Posts: 98
Thank you received: 1

11 years 3 months ago #145239

I have a also an other problem with this :
When I have many items, for example 2, I see only last item :
In my cart :

1 Items :
product id = 123456789
product name = tostos

product price without tax = 10.00
product quantity = 1

2nd Items :
product id = 323456789
product name = toptop

product price without tax = 7.50
product quantity = 1

bill total = 25.00
bill tax = 2.50
shipping = 5.00

but on my screen, on last step of transaction (in my end page (checkout/end.php), I see only last item :

transaction Id = 1234
Site name = Toto Inc Web Site
bill total = 25.00
bill tax = 2.50
shipping = 5

product id = 323456789
product name = toptop
product category name = [missing value]
product price without tax = 7.50
product price with tax = [missing value]
product quantity = 1

I can not see any information on 1st item : missing 1st item

foreach($this->order->products as $product)
{
	echo $product->order_product_code; //product id
	echo $product->order_product_name;  //product name
	echo $product->order_product_price   //product price without tax
	echo $product->order_product_quantity;  //product quantity 


	echo $product->order_product_price+$product->order_product_tax; //product price with tax[color=#ff0000] [missing value][/color]
	echo $product->order_product_category->order_category_name;    //product category name" ( = computer) [color=#ff0000][missing value][/color]
}

Can you help me

thanks

Please Log in or Create an account to join the conversation.

nicolas
Away

Posts: 83933
Thank you received: 13588
MODERATOR

11 years 3 months ago #145258

echo $product->order_product_price+$product->order_product_tax;
will indeed display the full unit price.

For the category, it's more complex....You'll have to use the product_id attribute to load the category_id from the hikashop_product_category table and then do another query to load the category name from the hikashop_category table based on the category_id from the first query result.

The following user(s) said Thank You: aspkiddy

Please Log in or Create an account to join the conversation.