Closed

Numbering of billing documents (invoice & receipt) for Virtuemart3

Hi

In [url removed, login to view] 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 : [url removed, login to view]

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 [url removed, login to view] (renamed it to [url removed, login to view])

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 [url removed, login to view] (renamed it to [url removed, login to view])

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 [url removed, login to view] or [url removed, login to view] 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.

Skills: Joomla, PHP, Virtuemart

See more: invoice receipt generator, online invoice receipt generator, fake invoice receipt, cms, mysql, css, joomla, ajax, javascript, invoice receipt work, customer billing database fields, unique invoice numbering macros excel, asp net invoice billing projects, billing python invoice, invoice receipt graphic design work, gets posted flicker web site, sugarcrm invoice hour billing, hosting progres project php billing invoice, change invoice numbering system oscommerce, billing invoice scripts

About the Employer:
( 3 reviews ) Thessaloniki, Greece

Project ID: #14746755

24 freelancers are bidding on average €255 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
(237 Reviews)
8.5
joomextensions

Hello, I have read your project details and i want your site details and admin login details. But before that i think we have to discuss in brief about your project so it would be helpful if we can have 1-1 call More

€422 EUR in 5 days
(170 Reviews)
8.0
sapotacorp

Dear its4yougr. I check [login to view URL], 3.6.5, 3.018 carefully and I am absolutely sure that I can do the project very well. Our Joomla's projects: [login to view URL] Our latest Greece's projects: htt More

€191 EUR in 5 days
(468 Reviews)
7.9
€250 EUR in 3 days
(252 Reviews)
7.1
JoomlaVogue

Please have a look at our portfolio for Joomla based projects: [login to view URL] Relevant Skills and Experience Please have a l More

€277 EUR in 10 days
(112 Reviews)
7.5
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
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
(67 Reviews)
5.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
(37 Reviews)
5.4
€100 EUR in 3 days
(68 Reviews)
5.2
AppSquads

We are working on Joomla since last 10 years. and I am sure that we can help you on this changes list. Relevant Skills and Experience We are very experienced with Joomla and VM since version 1.x while it was known as More

€632 EUR in 9 days
(9 Reviews)
4.9
drudev

Hello. I am a web developer with 15 -year experience . I work remotely on DigitalRay company - [login to view URL] - LA (USA). Technical knowledges: [login to view URL] JavaScript Ruby RoR ASP.Net C#, Java, Python. Relevant Skills and More

€244 EUR in 11 days
(41 Reviews)
5.5
€250 EUR in 5 days
(18 Reviews)
5.1
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
(3 Reviews)
4.6
€155 EUR in 3 days
(23 Reviews)
4.9
mangaram1975

I am more then 4 years experienced in WEB-DESIGN / GRAPHIC-DESIGN / WORDPRESS /Magento/Joomla Adobe-Photoshop / corel-draw / PHP /Bootstrap/ PSD-TO-XHTML / PSD-TO-HTML / MYSQL / CSS / HTML Relevant Skills and Experien More

€200 EUR in 7 days
(17 Reviews)
4.2
rvtechsolution

my portfolio - [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL] Relevant Skills and Experience my portfolio - More

€555 EUR in 10 days
(27 Reviews)
4.7
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
(10 Reviews)
3.4
meganachunchu

review my profile and chat

€77 EUR in 1 day
(13 Reviews)
3.2
€315 EUR in 3 days
(1 Review)
2.4
€277 EUR in 3 days
(1 Review)
1.9