Numbering of billing documents (invoice & receipt) for Virtuemart3

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

Hi

In [login to view URL] which is a Joomla 3.6.5 and Virtuemart 3.018 I have made some modifications on the following files in order for the customer to get a receipt or an invoice depending on his choice during checkout process:

Under : /templates/shaper_varsita/html/com_virtuemart/orders : [login to view URL]

That is where we decide if we will show a button for invoice "Τιμολόγιο" or receipt "Απόδειξη" depending on the customer's choice during the checkout process.

Also here the button Προβολή / Εκτύπωση Απόδειξης for receipt and Προβολή / Εκτύπωση Τιμολογίου displays if and only if the order is confirmed. If the order is not confirmed the customer should not be able to get an invoice or a receipt!

Under : /templates/shaper_varsita/html/com_virtuemart/invoice [login to view URL] (renamed it to [login to view URL])

Here there is some code to "translate" the amount into Greek words and the <?php echo $this->item->id ?> on line 136 takes the order ID for the invoice number.

Under : /templates/shaper_varsita/html/com_virtuemart/receipt [login to view URL] (renamed it to [login to view URL])

Here there is some code to "translate" the amount into Greek words and the <?php echo $this->item->id ?> on line 137 takes the order ID for the receipt number.

Of couree there is a field into the virtuemart_userinfos table called parastatiko which takes values "Απόδειξη" & "Τιμολόγιο" for receipt and invoice accordingly during the checkout process.

NOW what needs to be done is:

1. If a customer chooses to have "Τιμολόγιο" (invoice) during the checkout process (OPC cart) to set, starting from 1, the invoice number on a different DB table for that specific order.

2. If a customer chooses to have "Απόδειξη" (receipt) during the checkout process (OPC cart) to set, starting from 1, the receipt number on the same DB table for that specific order.

3. Then depending on the order number when the [login to view URL] or [login to view URL] gets executed to get the value for that order for invoice or receipt number from the coresponding value of invoice or receipt from that DB table for the specific order.

This DB table ie named billing with fields virtuemart_order_id (same as in virtuemart_orders), invoice_id and receipt_id would just increase the invoice_id and receipt_id by one when the customer chooses invoice or receipt.

I am including my example that I posted on the forum below:

Initially:

invoice_number = 0

receipt_number = 0

if

1st Order --> Invoice

invoice_number+1 (0+1=1)

invoice_number = 1

if

2nd Order --> Invoice

invoice_number+1 (1+1=2)

invoice_number = 2

if

3rd Order --> Receipt

receipt_number+1 (0+1=1)

receipt_number = 1

if

4th Order --> Receipt

receipt_number+1 (1+1=2)

receipt_number = 2

if

5th Order --> Receipt

receipt_number+1 (2+1=3)

receipt_number = 3

if

6th Order --> Invoice

invoice_number+1 (2+1=3)

invoice_number = 3

if 7th Order --> Receipt

receipt_number+1 (3+1=4)

receipt_number = 4

Therefore after the 7th Order :

invoice_number = 3

receipt_number = 4

If you have any questions and if you need FTP, DB and backend access please feel free to contact me.

Joomla PHP Virtuemart

Project ID: #14746755

About the project

22 proposals Remote project Active 6 years ago

22 freelancers are bidding on average €246 for this job

bdsiddhi

Hi, As you describe, We can surely help you to update & upgrade your existing Joomla (Virtue-mart) website. I'm very much interested & confident to work on this project. Relevant Skills and Experience We are a Jooml More

€500 EUR in 5 days
(333 Reviews)
9.0
jwsolution

have to make customazation in virtuemart in generate invoice flow as per client requirement and specification. Relevant Skills and Experience I have hand of experience of more than 6 year in joomla framework. In mean More

€200 EUR in 6 days
(129 Reviews)
7.0
VnBestSolutions

Dear Sir. I had read your descriptions about project. Kindly give me a chance, i would like to discuss more about project and sure everything clear. I am a developer very strong in below skills. Relevant Skills and Ex More

€266 EUR in 3 days
(169 Reviews)
6.7
joomlavenus

Hello, I'm an expert in Virtuemart. Please give me a chance to work with you. (You can review my profile, I have done a lot Virtuemart project, tasks,) I need FTP access, DB and backend access too. I'm looking forw More

€111 EUR in 2 days
(38 Reviews)
5.5
dilshadbukhari

I have more than 5 years experience in PHP programming and well versed in open-sources / Framework like Codeigniter , OpenCart, Wordpress and other Web solutions . , Relevant Skills and Experience My strengths are web More

€188 EUR in 3 days
(37 Reviews)
5.0
cuibeauty

Dear sir Thank you for your description,I have checked your project and understood all your requirements So I can help you Relevant Skills and Experience I have already developed many site so that I have many top ski More

€277 EUR in 3 days
(4 Reviews)
4.7
MetaoriginLab

Though I am new here but my team has 4 years of experience into Website Design and Development across all Platforms especially on . Can very well execute this Project and can start immediately.

€225 EUR in 3 days
(2 Reviews)
1.5
gladson147

A proposal has not yet been provided

€155 EUR in 20 days
(0 Reviews)
0.0