[Released] Prof. Invoice and Packingslip

TalonRAge wrote:Here is the vQmod file that handles both the invoices and packing slips since your latest release.

francoisv wrote:Hi there.
Thx for the mod. I am rather new at this.
I installed it and made all the changes to the files.
I have a few problems. The alignment of the button seems to be a bit off. See attached picture.
Also, how do I change the logo and the images at the bottom? It shows the default logo and not my company logo.
How do I change the line in yellow or remove it if I don't want it.
Sorry if I sound like a noob.
Thx

extigo wrote:In the manual it does not say you have to edit another div. I had the same problem because I put the input code in the same div as the original buttons. In the code you have to create a div for every button separately.

the changes are almost the same for both "mods"

admin/model/sale/order.php

public function getTotalSalesByYear($year) {
      	$query = $this->db->query("SELECT SUM(total) AS total FROM `" . DB_PREFIX . "order` WHERE order_status_id > '0' AND YEAR(date_added) = '" . (int)$year . "'");

		return $query->row['total'];
	}

	/* webme - get sku - for osC-invoice or Packingslip - mod - start */
	public function wbm_getSKU($prodID) {
		$query = $this->db->query("SELECT `sku` FROM `" . DB_PREFIX . "product` WHERE `product_id` = '".(int)$prodID."' LIMIT 1");
		
		return $query->row['sku'];
	}
	/* webme - get sku - for osC-invoice or Packingslip - mod - end */

step #1
open

Code: Select all

admin/controller/sale/order.php

find function

Code: Select all

public function osc_invoice() {

inside it
after

Code: Select all

$this->data['column_comment'] = $this->language->get('column_comment');

add

Code: Select all

$this->data['column_sku'] = $this->language->get('column_sku');

scroll down
after (somewhere around the line 1109)

Code: Select all

						'model'    => $product['model'],

add

Code: Select all

						'sku'    => $this->model_sale_order->wbm_getSKU($product['product_id']),

step #2
open

Code: Select all

admin/language/english/sale/osc_order.php

add anywhere

Code: Select all

$_['column_sku']         = 'SKU';

step #3
open

Code: Select all

admin/view/template/sale/osc_order_invoice.tpl

after

Code: Select all

<td class="dataTableHeadingContent-invoice"><?php echo $column_model; ?></td>

add

Code: Select all

<td class="dataTableHeadingContent-invoice"><?php echo $column_sku; ?></td>

after

Code: Select all

<td class="dataTableContent" valign="top"><?php echo $product['model']; ?></td>

add

Code: Select all

<td class="dataTableContent" valign="top"><?php echo $product['sku']; ?></td>

replace

Code: Select all

<td colspan="8" align="right"><br> <table border="0" cellpadding="2" cellspacing="0">

to

Code: Select all

<td colspan="9" align="right"><br> <table border="0" cellpadding="2" cellspacing="0">

OC_osC-invoice_packingslip_sku_001.png (55.93 KiB) Viewed 6397 times

step #1
open

Code: Select all

admin/controller/sale/order.php

find function

Code: Select all

public function packingslip() {

inside it
add

Code: Select all

$this->data['column_sku'] = $this->language->get('column_sku');

after

Code: Select all

$this->data['column_comment'] = $this->language->get('column_comment');

scroll down
after (somewhere around the line 1327)

Code: Select all

						'model'    => $product['model'],

add

Code: Select all

						'sku'    => $this->model_sale_order->wbm_getSKU($product['product_id']),

step #2
open

Code: Select all

admin/language/english/sale/packingslip.php

add anywhere

Code: Select all

$_['column_sku']         = 'SKU';

step #3
open

Code: Select all

admin/view/template/sale/order_packingslip.tpl

after

Code: Select all

<td class="dataTableHeadingContent-invoice"><?php echo $column_model; ?></td>

add

Code: Select all

<td class="dataTableHeadingContent-invoice"><?php echo $column_sku; ?></td>

after

Code: Select all

<td class="dataTableContent" valign="top"><?php echo $product['model']; ?></td>

add

Code: Select all

<td class="dataTableContent" valign="top"><?php echo $product['sku']; ?></td>

OC_osC-invoice_packingslip_sku_002.png (50.14 KiB) Viewed 6397 times

How do I change the line in yellow or remove it if I don't want it.

$_['entry_yellow_line'] = 'blah-blah-blah. Yellow line text. It is from the language file.';

  <tr>
    <td><img src="view/osc_invoice/pixel_trans.gif" alt="" width="1" border="0" height="5"></td>
  </tr>
  <tr>
    <td><table width="100%" border="0" cellpadding="2" cellspacing="0">
        <tbody><tr>
          <td class="main-payment2"><?php echo $entry_yellow_line; ?></td>
        </tr>
      </tbody></table></td>
  </tr>

admin/view/osc_invoice/stylesheet.css

megahuman wrote:Hey,

I want to install this mod but I'm just curious what the difference between the two download files are?

Prof. Invoice & Packingslip 1.3
or the Prof. Invoice & Packingslip 1.3 vQmod?

Do I need them both?

i2Paq wrote:

megahuman wrote:Hey,

I want to install this mod but I'm just curious what the difference between the two download files are?

Prof. Invoice & Packingslip 1.3
or the Prof. Invoice & Packingslip 1.3 vQmod?

Do I need them both?

If you are going to use the [MOD] - VirtualQMod "vQmod" Virtual File Modification System then yes, you need them both.

fiona86 wrote:Is it possible for us to add it a few more lines of text to the yellow box? I'm sure many of us would need more space type instructions and bank information for the customers to make payment.

admin/language/YOUR_LANG/sale/osc_order.php

$_['entry_yellow_line'] = 'blah-blah-blah. Yellow line text. It is from the language file.';

$_['entry_yellow_line'] = 'blah-blah-blah. Yellow line text. It is from the language file.<br /><br />blah-2<br />blah-3<br /><br />...<br /><br />blah-n';

Code: Select all

<br />

is a "line breaker".
each <br /> means "new line"

OC_oscInvoice_yellow_line_001.png (52.8 KiB) Viewed 6289 times