Just wondered if anyone has this mod working or is it just me?
cheers
Dave
It may be just you if the problem you would indicate may not be elaborated. 
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
hi,
is there a way to display the product description in the invoice without changing the database?
I have tried the following:
in: admin/model/sale/order.php
after :
insert this:
in: admin/controller/sale/order.php
after: (2nd instance)
insert:
&
after:
insert:
in: admin/view/template/sale/order_invoice.tpl
after:
insert:
&
after:
insert:
&
after:
insert:
but I get an error:
Warning: htmlspecialchars_decode() expects parameter 1 to be string, array given in C:\wamp\www\beadsforyou.co.za\vqmod\vqcache\vq2-admin_controller_sale_order.php on line 2647
does anyone know how to fix this one?
is there a way to display the product description in the invoice without changing the database?
I have tried the following:
in: admin/model/sale/order.php
after :
Code: Select all
return $query->row['total'];Code: Select all
public function getDescription($product_id) {
$query = $this->db->query("SELECT description FROM " . DB_PREFIX . "product_description WHERE product_id = '" . (int)$product_id . "'");
return $query->row;
}after: (2nd instance)
Code: Select all
$option_data = array();Code: Select all
$product['description'] = $this->model_sale_order->getDescription($product['product_id']);after:
Code: Select all
$product_data[] = array(Code: Select all
'description' => htmlspecialchars_decode($product['description']),after:
Code: Select all
<td><b><?php echo $column_model; ?></b></td>Code: Select all
<td><b>Description</b></td>after:
Code: Select all
<td><?php echo $product['model']; ?></td>Code: Select all
<td><b><?php echo $product['description'] ?></b></td>after:
Code: Select all
colspan="4"Code: Select all
colspan="5"Warning: htmlspecialchars_decode() expects parameter 1 to be string, array given in C:\wamp\www\beadsforyou.co.za\vqmod\vqcache\vq2-admin_controller_sale_order.php on line 2647
does anyone know how to fix this one?
--
South Africa, Johannesburg GMT +2
I think you are missing to put the snippet length? The way I have it, to display it in the cart, is like this:
You can change the 400 to which ever number of characters to display. Please someone correct me if I'm wrong.
I ain't no programmer, but let me know if it works, because I need to put it now to the invoice.
Code: Select all
htmlspecialchars_decode(substr($product['description'],0,400)) . '...',I ain't no programmer, but let me know if it works, because I need to put it now to the invoice.
Hi, nope the code returns an array into a string, I guess I have to select the correct order_id & product_id together, I am still figuring this one out
--
South Africa, Johannesburg GMT +2
Hi,
I got something working, please verify the program on your end, just note this is meant for the standard OC "Print Invoice" button under Sales > Orders, my OC version is 1.5.5.1
I got something working, please verify the program on your end, just note this is meant for the standard OC "Print Invoice" button under Sales > Orders, my OC version is 1.5.5.1
Attachments
--
South Africa, Johannesburg GMT +2
Ok, I did several tests.
1. It is creating the column correctly with the title "Description"
2. No matter how many pieces I buy from the same product; 2,3 or 4, it will display as 2 separate items and only one line is displaying the description. the other one is empty.
3. The description didnt came out correct with me, it showed the first line of it and then 2 unrecognized characters , as the following:
On this example, I bought 3 pieces in one single order.
Tested OC 1.5.5.1 with the default print button.
1. It is creating the column correctly with the title "Description"
2. No matter how many pieces I buy from the same product; 2,3 or 4, it will display as 2 separate items and only one line is displaying the description. the other one is empty.
3. The description didnt came out correct with me, it showed the first line of it and then 2 unrecognized characters , as the following:
On this example, I bought 3 pieces in one single order.
Tested OC 1.5.5.1 with the default print button.
Hi,
I think there is still changes to be made, I will look into it later, but for now its a step into the right direction
I think there is still changes to be made, I will look into it later, but for now its a step into the right direction
--
South Africa, Johannesburg GMT +2
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Link aboved edited. Now added VAT entry with both invoices. Also fixed minor bugs from yesterday's release.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
HI Straightlight -
Amazing job, works for 1.5.5.1 w shoppica 2.
One tiny problem though. It places description not in the same row where the product is, but in the row below. Please seevmy attachment. Any suggestions?
Thanks
Amazing job, works for 1.5.5.1 w shoppica 2.
One tiny problem though. It places description not in the same row where the product is, but in the row below. Please seevmy attachment. Any suggestions?
Thanks
Attachments
Hi, the xml above is working great. I would like to know if there is a way to show category description on the invoice based on the products? so if there is the 'canon' product is in the cart it will show camera category information on the invoice.
thanks
thanks
Who is online
Users browsing this forum: No registered users and 12 guests
