Numbering of billing documents (invoice & receipt) for Virtuemart3

Закрито Опубліковано %project.relative_time Оплачується при отриманні
Закрито Оплачується при отриманні

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

ID Проекту: #14746755

Про проект

22 заявок(-ки) Дистанційний проект Остання активність 6 роки(ів) тому

22 фрілансерів(-и) готові виконати цю роботу у середньому за €246

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 Більше

€500 EUR за 5 дні(-в)
(333 відгуків(и))
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 Більше

€200 EUR за 6 дні(-в)
(129 відгуків(и))
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 Більше

€266 EUR за 3 дні(-в)
(169 відгуків(и))
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 Більше

€111 EUR за 2 дні(-в)
(38 відгуків(и))
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 Більше

€188 EUR за 3 дні(-в)
(37 відгуків(и))
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 Більше

€277 EUR за 3 дні(-в)
(4 відгуків(и))
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 за 3 дні(-в)
(2 відгуків(и))
1.5
gladson147

A proposal has not yet been provided

€155 EUR за 20 дні(-в)
(0 відгуків(и))
0.0