Please read well before bidding
We need to develop a micro model for basic accounting for opencart with the caring of external expenses of the compny and another incomes beside sales as investment or prizes.
Module should be developed to match open cart 2.3.0.2 and without touching opencart core but as module that is installed from extension installer and get access to admin users and ability to use vqmod/ocmod.
plz work on clean version of oc 2.3.0.2 and you submit module as zipped file to test on any opencart to check it independently.
you can use many components of opencart reports , filtering,... to simplify the job
alo u will send me the needed mysql changes
The task:
Admin menu called acounting has sub menus :
1-expenses
it has 2 tables expense (id,description,ammount,category_id,date,user_id,active) & expense_category (id,name)
ADD/EDIT/Delete for cost "Soft delete by letting active=0 in database
2-income
ADD/EDIT/Delete "Soft delete by letting active=0 in database"
it has 2 tables income (id,description,ammount,category_id,date,user_id,active) & income category (id,name)
ADD/EDIT/Delete for income "Soft delete by letting active=0 in database"
3-expenses categories view with buttons to
ADD/EDIT/Delete for expense_category
4-income categories view with buttons to
ADD/EDIT/Delete for income_category
5-reports
ability to enter start & end date fields to filter data according to order date (and by default show data for all the time)
show these data:
Total number of orders
Total Sales
Collected Sales (we will add money_collected field in order table with true/false option and it appear also at admin edit order & admin columns in view order and we will calculate oders whose money_collected=1)
Non-Collected Sales (money_collected=0)
Cost of Goods Sold (i will tell you in #6 how to determine)
Gross profit = Total Sales- Cost of Goods Sold
Operating expenses (i will tell you in #6 how to determine)
Net Profit = Gross profit - Operating expenses
CashFlow = Net profit-Not collected sales +Income (Show this only in case of there is no start and end date entered as they are globla for whole period)
6-settings
-user can choose components of Cost of Goods Sold "we talked about in reports"
where all categories of expenses appears in checkboxes with ability of multiple select
-user can choose components of operating expenses"we talked about in reports"
where all categories of expenses appears in checkboxes with ability of multiple select
so the system knows which are components for each when they do calculation of costs & incomes of the selected categoires to give the right result in the reports.
We will have additional column in order table called "order_expenses" and it is by default = 0
we will add that value to the cost of good sold "calculated above" , only show the order_cost filed with money_collected filed during order create/edit to be able to add any excess cost from here.
Dear Sir, I have read your project description.i have 8 year experience in opencart.i have done it 200+ opencart site.i m the top of listing on opencart skill. i can do it your work perfectly.
Relevant Skills and Experience
I have experience on opencart 2.3.0.2 with created any type of module create using vqmod,I have lots of module created before in oc using vqmod., i have experience, theme creation, custmization.
Proposed Milestones
$400 USD - on Complete
I've been designing small to mid size Opencart websites for 8 years.
I specialize in Opencart Template, Integrating kinds of api like payment processing, Shipping api, Crm API etc.
Relevant Skills and Experience
opencart / php/ jquery / custom module / api integration
Proposed Milestones
$300 USD - reporting module
Hi
I am familiar with all versions of Opencart.
I read and understood your requirement.
I build exact function as your requirement
Please feel free to contact me and we go on.
Relevant Skills and Experience
I am Opencart developer. You can check here: https://www.freelancer.com/u/Ginjag
All my completed projects are on Opencart.
So, Everything is possible with me on Opencart.
Proposed Milestones
$250 USD - Milestone
Please feel free to contact me and I will start immediately
Hello There,
I have read your message.
I can do this job very well. I have done several systems along with mobile apps for the mobile device.
Relevant Skills and Experience
We have an Expertise:-
CMS:- Wordpress, Drupal, Joomla, OpenCart
Frameworks:- Laravel, CodeIgniter, CakePHP
Mobile Applications:- Android, iOS
Programming:- PHP, MySQL
Web Designing:- HTML5, jQuery
Proposed Milestones
$25 USD - default