Number of Orders - shown on Invoice

[farrel]

Hi
Happy New Year.
Could anyone help me get the "number of orders" information (as seen when looking at admin - customers) printed on the invoices.

This would be very useful for packing order e.g.: if first order then include full brochure etc.

Ideal way would be a suffix to order number: e.g instead of 1234 it could be 1234-3 for third order from customer etc.

Thanks

[Ajeh]

You could customize the file:
/your_secret_admin/invoice.php

with the code in RED:

      <tr>
        <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>
        <td class="main"><?php echo $order->info['payment_method']; ?></td>
      </tr>
<?php
// bof: number of orders
         $customers_orders = $db->Execute("select o.orders_id,  o.date_purchased, o.order_total, o.currency,  o.currency_value                                          from " .  TABLE_ORDERS . " o
                                          where customers_id='" . $order->customer['id'] . "'");
?>
      <tr>
        <td class="main"><b><?php echo 'Number of Orders: '; ?></b></td>
        <td class="main"><?php echo $customers_orders->RecordCount(); ?></td>
      </tr>
<?php
// eof: number of orders
?>
    </table></td>

[farrel]

You could customize the file:
/your_secret_admin/invoice.php

with the code in RED:

      <tr>
        <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>
        <td class="main"><?php echo $order->info['payment_method']; ?></td>
      </tr>
<?php
// bof: number of orders
         $customers_orders = $db->Execute("select o.orders_id,  o.date_purchased, o.order_total, o.currency,  o.currency_value                                          from " .  TABLE_ORDERS . " o
                                          where customers_id='" . $order->customer['id'] . "'");
?>
      <tr>
        <td class="main"><b><?php echo 'Number of Orders: '; ?></b></td>
        <td class="main"><?php echo $customers_orders->RecordCount(); ?></td>
      </tr>
<?php
// eof: number of orders
?>
    </table></td>

BRILLIANT. Thank you so much!!

[Ajeh]

You are most welcome ... thanks for the update that this worked for you ...

[SRQHoyas]

This is absolutely perfect for my uses also. I added the code to my 1.5.1 version and it works like a charm!
Thanks Ajeh

[Ajeh]

Thanks for the update that this works for you ...