webpage for gallib.net and gallib.com
gallib / macope Goto Github PK
View Code? Open in Web Editor NEWA package to manage your online finance
License: MIT License
A package to manage your online finance
License: MIT License
webpage for gallib.net and gallib.com
contains is the ost used option so add it by default instead of match
Add the ability to ignore some categories.
These categories must not be visible on expenses/incomes pages
on Category@index there are 2 links to go on the detail page, one is enough
on YearlyBIlling@index shorten month to reduce width of the table
eager load categories on journal to reduce significantly number of queries
for now http://xxx.yy/macope/dashboard shows the yearly billing table. Update route/controller/view to yearly-billing
Order by alphabetical order the select on categories, type categories and categorizations
In categorization rename type field in search_type
eager load type_categories on categories to reduce significantly number of queries
on TypeCategory@index there are 2 links to go on the details page, one is enough
When we create a new categorization, there is no option to apply the newly created categorization to existing entries.
Even better, add below the form a list of journal entries created by the rule we are writing
Yearly billing must be splitted in 2 parts: expenses and incomes.
To do so:
Split getYearlyBilling (service/query) in two for expenses/incomes
On Categorization@show add link to the related category
Add a selector to choose if a categorization concern an income or an expense, this choice must be mandatory.
Update amount, a value < 0 is not required anymore if the categorization concern an expense
Access to Macope must be restricted to logged users only
Add compatibility with auto discovery.
Auto discovery requires Laravel 5.5
See: https://laracasts.com/series/whats-new-in-laravel-5-5/episodes/5
Add a new vue component with expenses group by type category on a pie chart
On journal entry page, find a way to quickly assign (or edit) a category to an entry
on Categorization@index there are 2 links to go on the details page, one is enough
On the readme file there is no information about running
php artisan migrate
after running vendor:publish command
on LastExpenses component the chart id is still myChart. Change it to something more adapted
Add support of Migros Bank
in getSumByMonth method, we don't consider the "month end on" config option
in getExpensesByTypeCategory, we don't consider the "month end on" config option
On AccountController@show use [] instead of array()
also on AccountController@edit
after #25 will be done, entries that have been manually set must not be updated when we update a categorization
There is an SQL error on yearly billing page:
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'macope.type_categories.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SQL: select `categories`.`name` as `category_name`, `type_categories`.`name` as `type_category_name`, YEAR(journal_entries.date) as year, MONTH(journal_entries.date) as month, SUM(journal_entries.credit) as credit, SUM(journal_entries.debit) as debit from `journal_entries` inner join `categories` on `categories`.`id` = `journal_entries`.`category_id` inner join `type_categories` on `type_categories`.`id` = `categories`.`type_category_id` where year(`journal_entries`.`date`) = 2017 group by categories.name, YEAR(journal_entries.date), MONTH(journal_entries.date))
type categories must be visible on macope/journal @Index
Remove empty constructor like in JournalController
If there is no account set, add a warning on import file.
on Category@details add a link to the related type category
eager load categories on categorizations to reduce significantly number of queries
on TypeCategory@show add related categories
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.