Hi Alin, here are my thoughts on the taxation customization below:
We are going to build this on 1 of our demo servers, and we would like to give you access to both the demo site & ftp so can we pm this to you some how?
1) Create New Database Thread For Taxation
It appears as though the easiest way to make the taxation work, will be to mimic , as closely as possible the current Guru 'Promo Codes' function, beginning with the database structure.
We are planning on creating a new database thread, called jos_guru_taxes, and for the most part mirror the current jos_guru_promos db thread.
The new database thread will include the following database points:
- ID#
- Tax Name
- Tax Display (short name to display in invoices)
- Tax Type (% or fixed value)
- Tax Value
- Start Publish Date
- End Publish Date
2) Create New Guru Admin Page for Taxes
Once the new DB thread has been created, then we will require a new Joomla Admin view, so that users can administer the tax. Once again we plan to mimic the current 'Promo Codes' view:
/administrator/index.php?option=com_guru&controller=guruPromos
The new tax category view will employ the same css classes, as the promo codes, but will reflect the data listed in step 1 above.
Presumably the new page link would be :
/administrator/index.php?option=com_guru&controller=guruTaxes
2.1) Create New Guru Admin Page Edit Each Tax
Now that we have a Taxes category established, we will also require a full screen view to add/edit/delete and data entered, just like the current Promo Codes edit page, located here:.
/administrator/index.php?option=com_guru&controller=guruPromos&task=edit&cid[]=1
Following the logic above the new page would be located here:
/administrator/index.php?option=com_guru&controller=guruTaxes&task=edit&cid[]=1
3) Allow For JomSocial Custom User Field Integration
In Canada, taxation is based upon where the buyer is located, so we will need to make a series of fixed data options in the Jom Social registration process (Country & Province/State). When the user registers via the Jom Social login process, they will select this required data.
Upon Guru checkout, we will query the Jom Social user fields to determine whether or not the taxes will be applied to the Guru Invoice..
In addition to this element we will need to add an option in the newly built Guru Taxes edit page, where admins can make taxes conditional based upon these Jom Social fields.
4) Get Taxes to Display in Admin Orders Overview Page
Now that we have taxes working, we need to display it in the Guru Admin Orders page:
/administrator/index.php?option=com_guru&controller=guruOrders
Ideally there would be an additional column added to the main orders table to list taxes.
5) Get Taxes To Be An Exportable Element From Orders Overview Page
We will need to make the tax data exportable in the .csv & .xlsx data exporter so that admins ca easily export this information for accounting purposes.
ID is hoping that the iJoomla team can help with this element. 8)
6) Get Taxes to Display In Invoice View And Alter Final Pricing
The final element will be to restructure the invoice to display the current Price as Sub Total, then ad the taxation beneath it and final a total price based upon the Subtotal - (promotions) + (taxation) = Total
I am pretty sure we will need input from the iJoomla folks here as well. Also I think we might even have to add a data point or two to the Guru Orders data tables:
jos_guru_program_plans
jos_guru_order
6.1) Get Taxes to Display in Front End Invoice View
Same as step 6, but on the front end
